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 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