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

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 using Excel.

Transcribed Image Text:

HW3-5-Excel File Home Insert Page Layout Formulas Data Review View Add-ins Tell me what you want to do.... Show Queries Connections K Clear Group From Table Properties Reapply H Ungroup Get External New Refresh Z Sort Filter Text to What- Forecast Data Query De Recent Sources All Edit Links Advanced Columns Analysis Sheet Subtotal Get & Transform Connections Sort & Filter Data Tools Forecast Outline 19 B17 $x B C D E F G H J K 1 Homework # 3-5 2 3 Items. 4 Profit per item. 5 Constraints 1 5 20 8 6 1 3 7 2 2 8 3 1 540 Available 50 Usage Left over 40 8 9 4 0 1 10 0000 50 40 8 10 10 11 Production: 12 1= 13 2= 14 Z= 15