What is the total cost, Solve the problem using SOLVER and

What is the total cost

Reference no: EM13977796

Consider the following model to MINIMIZE total cost
Min 5A + 8B

Subject to:
1 2A + 3B >=6
2 3A - B <=15
3 - A+ B <= 4
4 2A + 4B <= 27
5 A,B>=0

Solve the problem using SOLVER and generate the answer and sensitivity reports

Based on your Excel output, what is the optimal solution?
A <-enter number in yellow cell
B <-enter number in yellow cell

Based on your Excel output, what is the total cost?

Total Cost <-enter number in yellow cell

If the objective coefficient for A is 7 instead of 5 and the constraint 4 RHS is 25 instead of 27, by how much the total cost will change?
Total cost <- Type 'increases' or 'decreases' in yellow cell
by <-enter number in yellow cell

Reference no: EM13977796

Questions Cloud

Determine which market segment to target : Occasionally, a student will suggest that his or her product or service is universally needed, such as providing a haircut. Therefore, they plan to target everyone. Why is this not a good idea? What criteria should be used to determine which market s..

American criminal justice system : First identify and explain in detail no less than five separate and distinct strengths and likewise three opportunities for improvement in the American Criminal Justice System

How much work is done by the force at zero degrees : If the forces at 71.37 at 0 degrees, and 96.96 at 30 degrees, and 33.66 at 150 degrees. How much work is done by the force at 0 degrees?

Use of market research reduces some risk : Companies want to make the best marketing decisions possible regarding which customers to pursue, which products or services to introduce or promote, where to sell their products or services, and at what price. Although not perfect, the use of market..

What is the total cost : Solve the problem using SOLVER and generate the answer and sensitivity reports , Based on your Excel output, what is the optimal solution?

NPV projects to fund may want to increase its dividend based : A corporation with very high growth prospects and many positive NPV projects to fund may want to increase its dividend based on the: A. very low agency costs of corporation B. information effect C. tax bias against capital gains D. residual dividend ..

What is the bonds price-one-year zero rates : The six-month and one-year zero rates are both 10% per annum. For a bond that has a life of 18 months and pays a coupon of 8% per annum (with semiannual payments and one having just been made), the yield is 10.4% per annum. What is the bond’s price?

Own an annuity-what rate of return : Assume that you own an annuity that will pay you $15,000 per year for 12 years, with the first payment being made today. You need money today to open a new restaurant, and your uncle offers to give you $120,000 for the annuity. If you sell it, what r..

Paper about same-sex adoption should be legalized : Topic: Same-sex Adoption Should be Legalized in All States in the United States and Should be Supported by the Public. Adoption by Same-Sex Couples: Public Policy Issues in Texas Law & Practice

User Account

All Pages