Question
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
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?
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 Katies workout plan, choose the best number or formula for the cells that have been shaded away.
using only the sensitivity analysis report provided below, answer the following:
choices for the above are:
C D E F G H Minutes Capable 60 5 10 30 Leg Workout Time Used Time Available units 0 0 0.333 0.250 0.000 0.000 0.500 0.250 15 30 units minutes minutes minutes minutes minutes minutes minutes minutes 0 0 0.333 0.250 0.000 0.000 0.500 0.250 15 30 units minutes minutes minutes minutes minutes minutes minutes minutesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started