Question: I need some help on the following problems on excel. Thank you and please clarify on the answer. Chrissy is a health and fitness coach.

I need some help on the following problems on excel. Thank you and please clarify on the answer.

I need some help on the following problems on

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 eflicient 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 that her blend would need to meet her own minimum requirements of 50 gms of protein, 40 gms of carbohydrates, and 30 gms of fat per serving. Her sensitivity report is given here. Microsoft Excel 16.0 Sensitivity Report Variable Cells Name A Final Value 0.705 1.122 1.734 Reduced Objective Allowable Allowable CostCoefficient Increase Decrease 0 25 5.80 11.32 0 10 11.94 1.53 0 8 6.44 5.60 B Constraints Final Value Shadow Constraint Allowable Allowable Price R.H. Side Increase Decrease 600 0.033 600 405.33 241.26 Name Protein LHS Carbs LHS Fat LHS 0.009 480 480 360 458.40 818.57 192.00 188.00 0.052 360 Fill in the following blanks based on the Sensitivity Report to specify the objective function ranges (round to only 2 decimal spaces). a. The range for Type A's cost is to b. The range for Type B's cost is to c. The range for Type C's cost is to

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!