6 2 1 Microsoft Excel 16.0 Sensitivity Report 2 Worksheet: (EXAM 1 excel.xlsx]Cool Dorm 3 Report Created: 10/25/2016 10:03:30 AM - Engine: Standard LP/Quadratic 5 6 Object ve Ce (Vax 8 SESO unt profits Total Drorit 250 0 Dec son Varias e Ces 0.00 5.00 -5.00 0.00 20 50 5 E-30 15-30 20.0000002 2 13 5358 Number to Make Stand 4 5056 Numberto Make Cubes 5 16 Constraints 17 *8 525:2 Volc Processing Used 20 505:3 Fishing Used 21 505:4 Stands Demand used 72 20.00 40.00 5.00 0.00 5.25 0.00 35 40 10 15-30 32 15-30 13 40 5 14. Producing one more stand will result in a. Improving the model b. Worsening the model C. Not change the model d. None of the above Objective Call (Max) Call Name Final Value SE$9 Unit Profits Total Profit 250 Anal Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 0.00 -5.00 20 5 1E30 5.00 0.00 50 10.30 10.0000002 10 Decision Variable Cells 11 12 Call Name 13 $8$8 Number to Make Stand 14 $C$8 Number to Make Cubes 15 16 Constraints 17 18 Call Name 19 SD$12 Mold Processing Used 20 $D$13 Finishing Used 21 $D$14 Stands Demand Used Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 20.00 0.00 36 1E430 16 40.00 6.25 40 32 40 5.00 0.00 10 15.30 5 6 2 1 Microsoft Excel 16.0 Sensitivity Report 2 Worksheet: (EXAM 1 excel.xlsx]Cool Dorm 3 Report Created: 10/25/2016 10:03:30 AM - Engine: Standard LP/Quadratic 5 6 Object ve Ce (Vax 8 SESO unt profits Total Drorit 250 0 Dec son Varias e Ces 0.00 5.00 -5.00 0.00 20 50 5 E-30 15-30 20.0000002 2 13 5358 Number to Make Stand 4 5056 Numberto Make Cubes 5 16 Constraints 17 *8 525:2 Volc Processing Used 20 505:3 Fishing Used 21 505:4 Stands Demand used 72 20.00 40.00 5.00 0.00 5.25 0.00 35 40 10 15-30 32 15-30 13 40 5 14. Producing one more stand will result in a. Improving the model b. Worsening the model C. Not change the model d. None of the above Objective Call (Max) Call Name Final Value SE$9 Unit Profits Total Profit 250 Anal Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 0.00 -5.00 20 5 1E30 5.00 0.00 50 10.30 10.0000002 10 Decision Variable Cells 11 12 Call Name 13 $8$8 Number to Make Stand 14 $C$8 Number to Make Cubes 15 16 Constraints 17 18 Call Name 19 SD$12 Mold Processing Used 20 $D$13 Finishing Used 21 $D$14 Stands Demand Used Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 20.00 0.00 36 1E430 16 40.00 6.25 40 32 40 5.00 0.00 10 15.30 5