Question: Can someone please help me with the following problems on excel, while using solver. Thank you Chrissy is a health and fitness coach. She wants

Can someone please help me with the following problems on excel, while using solver. Thank you

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 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.

Can someone please help me with the following

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 480 480 0.009 0.052 458.40 818.57 192.00 188.00 360 360 Fill in the following blanks based on the Sensitivity Report a. The optimal solution that Chrissy obtained shows a blend of lbs of Type A lbs. of Type B and lbs. of Type C Protein Powders. b. The total minimum cost for Chrissy's Blend is c. The total minimum cost PER LB of Chrissy's Blend is $

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!