Question: The following model was solved graphically in Chapter 2 Problem

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.



Sale on SolutionInn
Sales1
Views123
Comments
  • CreatedJuly 17, 2014
  • Files Included
Post your question
5000