Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Auditing An Introduction To International Standards On Auditing

Authors: Rick Stephan Hayes, Roger Dassen, Arnold Schilder, Philip Wallage

2nd Edition

0273684108, 978-0273684107

More Books

Students also viewed these Accounting questions

Question

Using this MATCH function in cell G 3 , day 1 9 returns the row

Answered: 1 week ago