1. Write out the Linear Program (equations) that Chrissy might have used.

2. What is the optimal solution that Chrissy obtained? Total Minimum Cost?

3. Specify the objective function ranges. What do they mean? (in words)

4. Identify each of the Right-Hand Side ranges. What do they mean? (in words)

5. Interpret the shadow prices of each constraint (in words)

Chrissy is a health and fitness coach. She wants to create a nutritional supplement, which meets the required daily dose of key nutrients at the lowest cost. Her goal is to sell this blend to her own clients to ensure that their nutritional needs are met in the most efficient manner possible. She decides to combine three different protein powders in order to create her own blend. The price of Type A Protein Powder is $25 per pound and it contains 42 gms of protein, 20 gms of carbohydrates and 10 gms of fat per serving. The price of Type B Protein Powder is $10 per pound and it contains 12 gms of protein, 20 gms of carbohydrates and 5 gms of fat per serving. The price of Type C Protein Powder is $8 per pound and it contains 4 gms of protein, 2 gms of carbohydrates and 10 gms of fat per serving. Each pound of any protein powder is equivalent to 12 servings. Chrissy runs a cost minimization linear program and identifies the blend would result in the lowest cost of $15.94 per pound of her own mix in order to meet the minimum requirements of 60 gms of protein, 45 gms of carbohydrates, and 20 gms of fat per serving. Her sensitivity report is given here. Based on the report, answer the following questions:

Microsoft Excel 16.0 Sensivity Report
Worksheet: [Final Solutions.xlsx]Sheet1
Variable Cells
		Final	Reduced	Objective	Allowable	Allowable
Cell	Name	Value	Cost	Coefficient	Increase	Decrease
$B$9	A	1.066	0	25	5.8	11.32
$C$9	B	1.148	0	10	11.94	1.53
$D$0	C	0.36	0	8	6.44	5.6
Constraints
		Final	Shadow	Constraint	Allowable	Allowable
Cell	Name	Value	Price	R.H. Side	Increase	Decrease
$C$14	Protein LHS	720	0.0331	720	234	365.05
$C$15	Carbs LHS	540	0.0089	540	260	196.42
$C$16	Fat LHS	240	0.0517	240	1238	39