Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

using only the sensitivity analysis report provided below, answer the following:

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

choices for the above are:

image text in transcribed

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 minutes

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

Filing And Computer Database Projects

Authors: Jeffrey Stewart

2nd Edition

007822781X, 9780078227813

More Books

Students also viewed these Databases questions

Question

4 What are the alternatives to the competences approach?

Answered: 1 week ago