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

please help
please help 2. Using the below Sensitivity Report, answer the questions making

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

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 Accounting Questions!