Question: please help 2. Using the below Sensitivity Report, answer the questions making sure to explain why in each case Adjustable cells Cell Name $B$2 #to
2. Using the below Sensitivity Report, answer the questions making sure to explain why in each case Adjustable cells Cell Name $B$2 #to make Economy $C$2 #to make Standard $D$2 # to make Premium $E$2 #to make Presidential Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 87.5 0 12 6 0 0 0 15 0 1E+30 0 -2.5 14 2.5 1E+30 112.5 0 18 6.000000001 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.5 points b. What happens if Economy diaper bags made $14 unit profit? 1.5 points c. What happens if you were able to gain 5 assembly hours? 1.5 points d. What happens if you only made $13 unit profit for a Premium diaper bag? 1.5 points e. What happens if you gained ten finishing hours and thirty packaging hours? 1.5 points f. What happens if someone offers you $80 for 10 hours of finishing time? 1.5 points g. What happens if you lost 15 finishing hours and Spackaging hours? 1,5 points h. What happens if you lose 10 hours of packaging time? 1.5 points 2. Using the below Sensitivity Report, answer the questions making sure to explain why in each case Adjustable cells Cell Name $B$2 #to make Economy $C$2 #to make Standard $D$2 # to make Premium $E$2 #to make Presidential Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 87.5 0 12 6 0 0 0 15 0 1E+30 0 -2.5 14 2.5 1E+30 112.5 0 18 6.000000001 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.5 points b. What happens if Economy diaper bags made $14 unit profit? 1.5 points c. What happens if you were able to gain 5 assembly hours? 1.5 points d. What happens if you only made $13 unit profit for a Premium diaper bag? 1.5 points e. What happens if you gained ten finishing hours and thirty packaging hours? 1.5 points f. What happens if someone offers you $80 for 10 hours of finishing time? 1.5 points g. What happens if you lost 15 finishing hours and Spackaging hours? 1,5 points h. What happens if you lose 10 hours of packaging time? 1.5 points
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
