Question

The following model was solved graphically in Chapter 2 (Problem 22):
maximize Z = 5x1 + 8x2 ($, profit)
subject to
3x1 + 5x2 ≤ 50 (units, resource 1)
2x1 + 4x2 ≤ 40 (units, resource 2)
x1 ≤ 8 (units, resource 3)
x2 ≤ 10 (units, resource 4)
x1 , x2 ≥ 0

Given the following Excel spreadsheet for this model, indicate the formulas in cells F6, F7, F8, F9, G6, G7, G8, G9, and B14, and fill in the Solver Parameters window with the necessary information to solve the model. Solve the model usingExcel.


$1.99
Sales0
Views80
Comments0
  • CreatedJuly 17, 2014
  • Files Included
Post your question
5000