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 Katies workout plan, choose the best number or formula for the cells that have been shaded away.

Q1 What formula should be typed into cell E13 so that it can be dragged all the way down to cell E16?

	a)	=B13
	b)	=C13
	c)	=SUM(B13:C13)
	d)	=SUMPRODUCT(B13:C13, $B$19:$C$19)
	e)	None of the above are correct

Q2 Given that the formula in E23 is =B13, what formula should be typed into G23?

a)		=5
b)		=C23
c)		=C23*B13
d)		=C23*B17
e)		None of the above are correct

Q3 What should be the sign in cells F25 and F26?

	a)	>=
	b)	=
	c)	=/= (not equal to)
	d)	None of the above are correct

Q4 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:C9). How many of the four exercises have maxed out Katies 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? __________

At the optimal solution, Katie will burn a total of ______calories. Of this total, _______ calories are burned from the arms workout, and ________ calories are burned from the legs workout.

n D E F G H Time Used Time Available units 0 0 units minutes minutes minutes minutes minutes minutes minutes minutes 0 0 units minutes minutes minutes minutes minutes minutes minutes minutes