Question: Can someone help write our the objective functions for the following, as well as the subject to the constraint. Thank you! Chrissy is a health

Can someone help write our the objective functions for the following, as well as the subject to the constraint. Thank you!Can someone help write our the objective

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. Iler 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 360 480 360 458.40 818.57 192.00 188.00 0.052 Based on the report, answer the following question: Write out the Linear Program (equations) that Chrissy might have used to obtain this solution. DO NOT refer me to "see the excel file

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!