Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started