Question: The Microsoft Excel answer report is the computer reports on the next page All the questions are based on the LP model and computer reports

The Microsoft Excel answer report is the "computer reports on the next page" The Microsoft Excel answer report is the

The Microsoft Excel answer report is the

All the questions are based on the LP model and computer reports on the next page: 1. Calculate the six missing numbers (??) on the "answer report" and "sensitivity report according to the LP model and relations. A= B= C D E F= Microsoft Excel Answer Report Target Cell (Max) Cell Name Original Final Value Value 51 (A7?) Adjustable Cells Cell Name Final Value Original Value 3 (B??) $B$5 Quant X1 SCS5 Quant x2 520 160 Slack Constraints Cell Name $D$8 Plastic Total $D$9 Time Total $D$1 Total Total C ell Value Formula Status 1200 $D$8=0 Not Binding 160 $C$5>=0 Not Binding $B$5 Quant X1 $C$5 Quant X2 Microsoft Excel Sensitivity Report Worksheet: [LPGalaxy.xls]Sheet1 Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 Quantity X1 520 0 7 3 3.25 $C$5 Quantity X2160 0 5 4.3 1.5 Constraints Cell Name $D$8 Plastic $D$9 Production Time $D$1 Total Final Shadow Constraint Allowable Allowable Value Price RH. Side Increase Decrease 1200 2.6 1200 64 650 (F??) 0.6 2200 600 150 6800 360 0 800 1E+30 4501E+30 120 90 $D$1 Mix

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!