Question: 1. (15 marks) Given the following linear programming model and the Excel Solver outputs, answer the questions that follow: Let x1 = the quantity of

1. (15 marks) Given the following linear1. (15 marks) Given the following linear

1. (15 marks) Given the following linear programming model and the Excel Solver outputs, answer the questions that follow: Let x1 = the quantity of economy widgets to make Let x2 = the quantity of standard widgets to make Let x3 = the quantity of deluxe widgets to make Maximize profit = 6 x + 10 x2 + 12 x3 Subject to Machine time: 1 X + 2 x2 + 3 x 5 80 hours Labour: 3 X1 + 2 x2 + 4 x3 s 120 hours Material: 6 x2 + 10 x3 s 280 sprockets Storage space: 2 X1 + 2 x2 + 3x3 s 90 c. feet X1, X2 and x3 20 Microsoft Excel 10.0 Answer Report Target Cell (Max) Cell Name $F$8 Profit Total Profit Original Value Final Value 410 Adjustable Cells Cell Name $C$6 Economy X1 $D$6 Standard X2 $E$6 Deluxe X3 Original Value 0 0 0 Final Value 10 35 0 Constraints Cell $F$11 Name Machine Time Actual Usage Slack 0 $F$12 Labour Actual Usage Cell Value Formula Status 80 $F$11

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!