Answer 2-C, 2-D, 2-E, 2-F 1 Microsoft Excel 16.0 Sensitivity Report 2 Worksheet:

Question

Answer 2-C, 2-D, 2-E, 2-F

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 4 Engine: Standard LP/Quadratic 6 Objective Cell (Max) 8 SE$9 Unit Profits Total Profit 10 Decision Variable Cells 2-c. Is the optimal solution degenerate? Explain why or why not 2-d. Is the optimal solution unique? Explain why or why not 2-e. How will raising the production of stands to its Cell Name Final Value 250 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease allowable increase affect the objection function total? 12 Cell 13 $B$8 Number to Make Stand 14 $CS8 Number to Make Cubes 15 16 Constraints 17 18 Name 1E+30 0.00 5.00 5.00 0.00 20 50 1E+30 10.0000002 2-f. Will the current solution remain optimal if finishing used is increased by 5 percent? Fina Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease Analyze and Explain Cell Name 9SDS12 Mold ProcessingUsed 20.00 0 20 SD$13 Finishing Used 21 SD$14 Stands Demand Used 20.00 0.00 40.00 6.25 5.00 0.00 36 1E+30 40 10 1E+30 16 40 32

Explanation / Answer

2C Yes As the variable value is at 0 for Stand. 2D Yes As one of the variable is at 0, the optimality is function of just one variable 2E It will not As the increase in production of stands to its allowable limit will not affect the optimal solution. Hence the final value remains the same 2F No As with the increase in 5%, RHS will go to 42, and as the allow more stands to be created, hence the optimal solution mix and the final value will change

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.