Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi, please explain in detail how to get the answer. Thanks Answer the following 4 questions using only the sensitivity analysis report provided below. A

Hi, please explain in detail how to get the answer. Thanks

image text in transcribed
Answer the following 4 questions using only the sensitivity analysis report provided below. A 61 B I c . D l E I F l G | H l 6_Variable Cells 77 Final Reduced Objective Allowable Allowable 8_ Cell Name Value Cost Coefficient Increase Decrease 9 __ _$B$13 Stretch Arm Workout 5 0 100 150 600 10 $C$13 Stretch Leg Workout 12.5 0 100 150 1833333333 11 $35 14 Pushup Arm Workout 5 0 400 1E+30 150 12 SC$14 Push-up Leg Workout 0 0 400 1E+30 1E+30 13 $35 15 Squat Arm Workout 0 0 500 1E+30 1E+30 14 $C$15 Squat Leg Workout 10 0 500 1E+30 400 15 SBS 16 Cardio Arm Workout 5 0 250 150 150 11 $C$16 Cardio Leg Workout 7.5 0 250 1E+30 150 E 1i Constraints 19_ Final Shadow Constraint Allowable Allowable 2g Cell Name Value Price R.H. Side Increase Decrease 21 $E$13 Stretch Time Used 17.5 0 60 1E+30 42.5 22 $5514 Push-up Time Used 5 150 5 S 2.5 23 SE$15 Squat Time Used 10 400 10 5 10 24 $E$16 Cardio Time Used 12.5 0 30 1E+30 17.5 25 SESZB Stretching for Arms Output 5 -150 0 5 2.5 26__ $E$24 Stretching for Legs Output 12.5 0 0 S 1E+30 27 $E$25 Push-ups for Legs Output 0 150 0 2.5 0 28_ _$E$26 Squats for Arms Output 0 -150 0 5 0 29 $5527 Cardio for Arms Output 5 0 D 1E+30 2.5 30 SESZS Cardio for Legs Output 7.5 150 0 5 7.5 31 $E$29 Maximum Time for Arms Output 15 200 15 15 7.5 32_ SESSO Maximum Time for Legs Output 30 137.5 30 5666666667 10 Suppose that Katie has seen improvements in her physique and is now physically capable of doing push-ups for 8 minutes instead of 5. How will this impact the optimal point and the value of the target cell? 0 The optimal point will: [7%.] (changeiremain the same/can't tell) In the rst drop down. indicate the direction of the change in the target cell. In the second drop down, select how much the target cell changes by, if at all, or if you can even calculate the change. 0 The target cellwill: [ $1 I $1

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 Responsible Management Global Sustainability Responsibility and Ethics

Authors: Oliver Laasch

1st Edition

9781285981321, 1285080262, 1285981324, 978-1285080260

More Books

Students also viewed these General Management questions

Question

When is the use of single-value grouping particularly appropriate?

Answered: 1 week ago