The following model was solved graphically in Chapter 2 (Problem 18):

maximize Z = 5x1 + 8x2 ($, profit2 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 using Excel.

 LO.1