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 help me with the solution to this problem. Please show me how you use the solver function in excel in order to determine the answer. 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.
Trending now
This is a popular solution!
Step by step
Solved in 8 steps with 6 images
