Question

In: Statistics and Probability

Solve the following problem with Excel Solver: (Leave no cells blank - be certain to enter...

Solve the following problem with Excel Solver: (Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Round your answers to 2 decimal places.)

Maximize Z = 8X + 17Y.
8X + 14Y 143          Resource A
1X + 2Y 75          Resource B
3Y 12          Resource C
  Decision for X   
  Decision for Y   
  Total profit $   
              Resources Used
  Resource A     
  Resource B     
  Resource C     

Solutions

Expert Solution

I HOPE ITS HELPFUL TO YOU IF YOU HAVE ANY DOUBTS PLS COMMENTS BELOW..I WILL BE THERE TO HELP YOU ...ALL THE BEST

Decision for X = 10.86

Decision for Y = 4

Total profit = 155

Resource A used = 143

Resource B used = 18.86

Resource C used = 12

I HOPE YOU UNDERSTAND..PLS RATE THUMBS UP ITS HELPS ME ALOT..

THANK YOU...!!


Related Solutions

Solve the following LP problem using the Solver in MS Excel. A farmer wants to customize...
Solve the following LP problem using the Solver in MS Excel. A farmer wants to customize his fertilizer for his current crop. He can buy plant food mix A and plant food mix B. Each cubic yard of food A contains 20 pounds of phosphoric acid, 30 pounds of nitrogen and 5 pounds of potash. Each cubic yard of food B contains 10 pounds of phosphoric acid, 30 pounds of nitrogen and 10 pounds of potash. He requires a minimum...
Solve the following LP problem using the Solver in MS Excel.   A municipality has two incinerators...
Solve the following LP problem using the Solver in MS Excel.   A municipality has two incinerators for burning trash . Incinerator A costs $3 .80 per ton of trash to operate, and has a capacity of 28 tons per day . Incinerator B costs $4 .25 per ton to operate, and has a capacity of 30 tons per day . The municipality produces over 100 tons of trash per day, and all trash not burned in the incinerators must be...
How to solve using Excel Solver: This is an assignment problem with 10 applicants and 5...
How to solve using Excel Solver: This is an assignment problem with 10 applicants and 5 positions. Determine the optimal assignments that Brenda Last should make. Use the data to determine the optimal assignments, but do not complete questions in the last two paragraphs of the text Formulate a linear programming model for this problem. List the objective function (minimize or maximize) and all model constraints. Solve problem using MS Excel’s Solver Hint: Use the “integer” constraint Highlight the "winning"...
2. Solve the following LP problem graphically; confirm your results using Solver in MS Excel. Maximize...
2. Solve the following LP problem graphically; confirm your results using Solver in MS Excel. Maximize profit = 20x1 + 10x2 Subject to: 5x1 + 4x2 ≤ 250 2x1 + 5x2 ≤ 150 x1, x2 ≥ 0
1. Solve the following integer optimization model by using Excel Solver: Maximize Z = 5x1 +...
1. Solve the following integer optimization model by using Excel Solver: Maximize Z = 5x1 + 6x2 Subject to 3x1 + 4x2 < 10 4x1 + 2x2 < 15      x1, x2 > 0 and integer Please show how to use the excel solver as well as steps. :)
SOLVE THE FOLLOWING 2 LINEAR PROGRAMMING PROBLEMS USING EXCEL AND THE SOLVER ADD-IN. PLEASE SHOW ME...
SOLVE THE FOLLOWING 2 LINEAR PROGRAMMING PROBLEMS USING EXCEL AND THE SOLVER ADD-IN. PLEASE SHOW ME ALL THE EXCEL STEPS. PROBLEM #1:   Maximize Z = $60X + $90Y                             Subject to:   60X + 30Y >= 1,500                                                     100X + 100Y <= 6,000                                                                              Y >= 30                                                                           X, Y >= 0 PROBLEM #2: Minimize Z = $3,000X + $1,000Y                              Subject to:   60X + 20Y >= 1,200                                                         10X + 10Y >= 400                                                     ...
4.B Construct an Excel model with solver to solve for the profit maximizing levels of price...
4.B Construct an Excel model with solver to solve for the profit maximizing levels of price and quantity for the profit function, Z = qp - cf - qcv, where cf = 8000, cv = 6, and the demand function for the product is q = 2400 - 24p. Illustrate the solution with a graph of the profit function, showing the profit maximizing price level. For an oligopoly as described in the chapter, construct an Excel model to solve for...
Solve the following linear programming problem using Solver. Be sure to write in your optimal solution...
Solve the following linear programming problem using Solver. Be sure to write in your optimal solution below the problem. Max Z = 20X1 + 30X2 + 25X3 + 32X4 s.t. 4X1 + 8X2 + 5X3 + 6X4 ≤ 40 X1 + X2 ≥ 3 (X1 + X2) ≤ (X3 + X4) ?1 ?2 ≥ 3 2 X1 = __________ X2 = ___________ X3 = ___________ X4 = ___________ Z = ____________
Solve the following linear programming problem using Solver. Be sure to write in your optimal solution...
Solve the following linear programming problem using Solver. Be sure to write in your optimal solution below the problem. Max Z = 20X1 + 30X2 + 25X3 + 32X4 s.t. 4X1 + 8X2 + 5X3 + 6X4 ≤ 40 X1 + X2 ≥ 3 (X1 + X2) ≤ (X3 + X4) x1/x2 ≥ 3/2 X1 = __________X2 = ___________X3 = ___________X4 = ___________Z = ____________
Solve the following linear programming problem by solver. Maximize Z = 7 x1 + 5 x2...
Solve the following linear programming problem by solver. Maximize Z = 7 x1 + 5 x2 + 5 x3 subject to x1 + x2 + x3 <= 25 2 x1 + x2 + x3 <= 40 x1 + x2          <= 25                    x3 <= 6 x1, x2, x3 >= 0 (non-negativity conditions)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT