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 Complete the rest of the model yourself, and run it in Solver to answer the following questions. Report all answers in whole numbers, or use as few decimals as possible. Do not include any symbols, signs, or spaces in the answers. • Katie is only physically capable of doing each exercise for so many minutes (cells C6:09). How many of the four exercises have maxed out Katie's physical capability? • How many constraints are there in total? • How many non-negativity constraints are there? • How many of the constraints (including non-negativity constraints) are binding? calories. Of this total, At the optimal solution, Katie will burn a total of calories are burned from the arms workout, and calories are burned from the legs workout.
