Answer 1-C, 1-D, 1-E, 1-F Microsoft Excel 16.0 Sensitivity Report 1 2 Worksheet:
ID: 349415 • 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
1C No As none of the variables take a zero value 1D Yes As the reduced cost is 0, which means the solution is optimal. And there are 2 constraints which are bounding. 1E 8 (8+0) , as the allowable increase is 0, this the maximum value possible 1F Current RHS New with 5% increase Chickens 100 105 As allowable increase is 10 so till 110 it wont change(it is within that limit) Would not change Soy 120 126 As allowable increase is 120 so till 240 it wont change in the solution(it is within that limit) Would not change Cranberries 160 168 Not bounding Would not change Dog treat demand 50 52.5 Not bounding Would not change Cat treat demand 20 21 Not bounding Would not change