After a long summer of working on her healthier lifestyle, Katie wants to plan a daily workout schedule for when she goe

[answerhappygod]

After A Long Summer Of Working On Her Healthier Lifestyle Katie Wants To Plan A Daily Workout Schedule For When She Goe 1 (76.54 KiB) Viewed 69 times

After a long summer of working on her healthier lifestyle, Katie wants to plan a daily workout schedule for when she goes back to school in September. In hopes of achieving a more balanced workout plan, Katie will do a combination of stretching, push-ups, squats, and cardio each day. Although she thinks she is quite jacked, she is only physically capable of exercising so much. Katie knows that she is physically capable of stretching for 60 minutes, doing push-ups for 5 minutes, squatting for 10 minutes, and doing cardio for 30 minutes each day. For her "new year, new me" lifestyle, Katie thinks she will be able to dedicate a maximum of 15 minutes to work out her arms before class and a maximum of 30 minutes to work out her legs after class. For her arms workout, she wants to stretch for at least a third of the workout and do cardio for no more than half of the workout, but do no squats. For her legs workout, she wants to stretch for at least a quarter of the workout and do cardio for no more than a quarter of the workout, but do no push-ups. Katie can burn 100 calories, 400 calories, 500 calories, and 250 calories for each minute of stretching, push-ups, squats, and cardio, respectively. Of course, Katie wants to burn as many calories in a day (arm workout before class and leg workout after class) as possible. What combination of stretching, push-ups, squats, and cardio should Katie do for her arms workout and for her legs workout? Use this scenario for the remaining questions of the homework. Katie would now like to set up the blending model in Excel, using Solver to find the solution for her daily workout plan, and needs your help to do so. Based on the provided screenshot for Katie's workout plan, choose the best number or formula for the cells that have been shaded away. Hint: it may be helpful to recreate the blending model yourself!
Minutes Capable 60 5 10 30 Leg Workout Time Used Time Available <= 1 Katie's Workout 2 3 Input Data 4 5 Calories per Minute 6 Stretch 100 7 Push-up 400 8 Squat 500 9 Cardio 250 10 11 Action Plan 12 Arm Workout 13 Stretch 14 Push-up 15 Squat 16 Cardio 17 Workout Time 18 19 Workout Calories 20 21 Additional Constraints (Blending) 22 23 Stretching for Arms 24 Stretching for Legs 25 Push-ups for Legs 26 Squats for Arms 27 Cardio for Arms 28 Cardio for Legs 29 Maximum Time for Arms 30 Maximum Time for Legs A A A 60 5 10 30 units minutes minutes minutes minutes Total calories Output Requirement YY 0 Oo 1/3 0.250 0.000 0.000 0.500 0.250 15 30 units minutes minutes minutes minutes minutes minutes minutes minutes <= <= 15 30
E F G H 600 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 5 0 100 150 12.5 0 100 150 183.3333333 5 0 400 1E+30 150 0 0 400 1E+30 1E+30 0 0 500 1E+30 1E+30 10 0 500 1E+30 400 5 0 250 150 150 7.5 0 250 1E+30 150 А в с 6 Variable Cells 7 8 Cell Name 9 $B$13 Stretch Arm Workout 10 $C$13 Stretch Leg Workout 11 $B$14 Push-up Arm Workout 12 $C$14 Push-up Leg Workout 13 $B$15 Squat Arm Workout 14 $C$15 Squat Leg Workout 15 $B$16 Cardio Arm Workout 16 $C$16 Cardio Leg Workout 17 18 Constraints 19 20 Cell Name 21 $E$13 Stretch Time Used 22 $E$14 Push-up Time Used 23 $E$15 Squat Time Used 24 $E$16 Cardio Time Used 25 $E$23 Stretching for Arms Output 26 $E$24 Stretching for Legs Output 27 $E$25 Push-ups for Legs Output 28 $E$26 Squats for Arms Output 29 $E$27 Cardio for Arms Output 30 $E$28 Cardio for Legs Output 31 $E$ 29 Maximum Time for Arms Output 32 $E$30 Maximum Time for Legs Output 30 Final Shadow Constraint Allowable Value Price R.H. Side Increase 17.5 0 60 1E+30 5 150 5 5 10 400 10 5 12.5 0 1E+30 5 -150 0 5 12.5 0 0 5 0 150 0 2.5 0 -150 0 5 5 0 0 1E+30 7.5 150 0 5 15 200 15 15 30 137.5 30 56.66666667 Allowable Decrease 42.5 2.5 10 17.5 2.5 1E+30 0 0 2.5 7.5 7.5 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? • The optimal point will: (change/remain the same/can't tell) In the first 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. • The target cell will:
Ignoring the previous question, suppose that Katie sprained her wrist from taking so many gym selfies so that she is only physically capable of doing 1 minute of push-ups instead of 5. How will this impact the optimal point and the value of the target cell? • The optimal point will: (change/remain the same/can't tell) In the first 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. • The target cell will:
Ignoring the previous questions, suppose that Katie wants to increase the time she spends stretching in her leg workouts from a quarter to a third, since her legs are extremely sore. How will this impact the optimal point and the value of the target cell? • The optimal point will: (change/remain the same/can't tell) In the first 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. • The target cell will:
Ignoring the previous questions, suppose that Katie wants to burn more calories from stretching, so she starts cranking up the heat in her dorm room to do hot yoga (after all, she might as well get the most out of how much she pays for residence each month!) Katie can now burn 300 calories per minute of stretching instead of 100. How will this impact the optimal point and the value of the target cell? • The optimal point will: (change/remain the same/can't tell) In the first 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. . The target cell will: