Answer 1-C, 1-D, 1-E, 1-F Microsoft Excel 16.0 Sensitivity Report 1 2 Worksheet:
ID: 348818 • Letter: A
Question
Answer 1-C, 1-D, 1-E, 1-F
Microsoft Excel 16.0 Sensitivity Report 1 2 Worksheet: [EXAM 1 excel.xlsx]1. Bouncy Paws 3 Report Created: 10/24/2016 4:42:27 PM 4 1-c. Is the optimal solution degenerate? Explain why or why not 1-d. Is the optimal solution unique? Explain why or why not 1-e. What is the highest value the objective Engine: Standard LP/Quadratic Objective Cell (Max) 7 8 6 Name Final Value 160 Cell $ES7 Unit Profits Total Profit 10 Decision Variable Cells Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase function dog treats coefficient can assume 12 Cell Name 13 SBS6 Number to Make Dog Treat 16.67 0.00 0.00 8 0.00000012 4.80000006 4 6.00000007S 0.00000006 without changing the optimal solution? 1-f. Using the 100% rule, will the current 6.67 14 SC$6 Number to Make Cat Treat 15 16 Constraints 17 18 Cell 19 SD$11 Chicken(oz) Used 20 SD$12 Soybeans (oz) Used 21 SD$13 Cranberries (oz) Used 22 SD$14 Dog treat demand Used 23 SD$15 Cat treat demand Used Final Shadow Constraint Allowable Allowable solution remain optimal if the binding Value Price R.H. Side Increase Name Decrease constraints are increased by 5 percent? 100.00 0.00 120.00 1.33 133.33 0.00 16.67 0.00 6.67 0.00 100 120 160 50 20 10 200 24A 120 E+30 26.66666667 E430 33.33333333 1E+30 13.33333333 Analyze and explainExplanation / Answer
1-c. The optimal solution is not degenerate, because none of the basic variables takes on zero value.
1-d. The optimal solution is not unique, because all the basic variables are strictly positive and the reduced cost of both the variables is zero. So, there exist alternative optimal solutions.
1-e. The reduced cost for objective coefficient of Dog treats is 0 , therefore, the highest value that it can take is its current objective coefficient, i.e. 8 only
1-f. The binding constraints are Soyabean and Chicken.
Total increase in binding constraints as percentage of allowable increase = 100*5%/10 + 120*5%/120 = 5/10+6/120 = 55%
This is less than 100%. Therefore, as per 100% rule, the current solution remains optimal.