Question: Using the Sensitivity Report, answer the questions making sure to explain why in each case. Adjustable Cells Final Value 87.5 Reduced Objective Cost Coefficient 0

Using the Sensitivity Report, answer the questions making sure to explain why in each case.

Using the Sensitivity Report, answer the

Adjustable Cells Final Value 87.5 Reduced Objective Cost Coefficient 0 12 Allowable Increase Allowable Decrease 6 0 Cell Name $B$2 #to make Economy $C$2 #to make Standard $D$2 #to make Premium $E$2 #to make Presidential 0 0 15 0 -2.5 0 112.5 14 2.5 18 6.000000001 1E+30 1E+30 0 0 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$5 cutting 196.25 0 240 1E+30 43.75 $F$6 assembly 230 0 250 1E+30 20 $F$7 finishing 250 7.5 250 20 90 $F$8 packaging 100 12 100 56.25 21.875 a. What is the total profit from this production plan? 1 points b. What happens if Economy diaper bags made $14 unit profit? 1 points c. What happens if you were able to gain 5 assembly hours? 1 points d. What happens if you only made $13 unit profit for a Premium diaper bag? 1 points e. What happens if you gained ten finishing hours and thirty packaging hours? 1 points f. What happens if someone offers you $80 for 10 hours of finishing time? 1 points g. What happens if you lost 15 finishing hours and 5 packaging hours? 1 points h. What happens if you lose 10 hours of packaging time? 1 points

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!