3 HW2 1.xIsx [Shared] Q Search Sheet Home Insert Draw Page Layout Formulas Data Review View o+ Share Cut 1401 _ AutoSum Calibri (Body) . 10 A- A- FEET . E Wrap Text General Normal Bad Good Neutral Q . Copy Fill Sort & Find Paste Conditional Format Calculation Check Cell Explanatory T.. Input Insert Delete Format Format BI UT -&. A. Merge & Center Formatting as Table Clear Filter Select + x V fx r G H M N P Q R U V w Answer the following Questions based on the Sensitivity Report Provided Question ANSWER Explain or show formula used (as needed The below sensitivity report is generated from the diet problem (Chapter 4). You must be able to answer all question from this report. This is a MINIMIZATION Problem (Min Cost) How many decision variables are in this problem? Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease What is the optimal decision (i.e. what is the answer that $C$25 1. Bran cereal (cup) 0 0 180 17.7 87.0 2 63.3 excel gave us)? SD$25 2. Dry cereal (cup) 0 $3.3 220 LE+30 $E$25 3. Oatmeal (cup) 0 100 5.6 20.9 $F$25 4. Oat bran (cup) 0 5.1 120 16+30 5.1 3 What is the optimal optimal cost? $G$25 5. 30.7 100 LE+3 30.7 SH$25 6. Bacon (slice) 72.8 90 1E+30 72.8 $1$25 7. Orange 0 323.3 400 LE+3 323.3 raints are binding? $J$25 8. Milk-2% (cup) 1.25 160 42.8 89.9 SK$25 9. Orange juice (cup) 439.8 500 E+30 39.8 $L$25 10. Wheat toast (slice) 70 What would the new optimal cost be if the price of oatmeal 11.7 gets discounted from 100 fils to 85 fils? Constraints How does the optimal value change if the price of wheat Final Shadow Constraint Allowable Allowable Cell Name Decrease 10 toast decreases from 70 fils to 60 fils? Value Price R.H. Side Increase $M$28 Calories 420 0.5 420 42.7 How does the cost change if the requirement of protein is $M$29 Fat 10 0 20 E+30 10 $M$30 Cholesterol LE+30 15 increased from 20 to 25? 15 $M$31 Iron 5 19.1 7.2 0 8 What would the new optimal cost be if the price of wheat $M$32 Calcium 400 0.4 8 un 105.9 toast increases from 70 fils to 80 fils? SM$33 Protein 15.25 20 SM$34 Fiber 12 0 25 5.25 E+30 o fl increase the requirement for iron by 3 (from 5 to 8), wha would my new optimal cost be? 10 How much slack does the protein constraint have? 11/ How much slack does the Calories constraint have? 15 16 17 18 20 21 22 23 24 25 27 29 30 31 Sensitivity Questions Salads Tangram + + 100% Enter