Question: Can someone help me with the following problems on excel using the solver function t o to determine the solution. Thank you Chrissy has two

Can someone help me with the following problems on excel using the solver function tCan someone help me with the following problemso to determine the solution. Thank you

Chrissy has two types of clients the first type of clients are those that need to maintain high levels of protein intake, have intensive work-outs 4 days a week, and need to lower their body weight. The second type of clients are those that need to increase their weight along with their fitness levels for optimal outcome of their sessions with Chrissy. She realizes that the Nutritional Blend she created earlier would be sufficient for the first type of client, but the second type of clients require a different blend for their nutritional needs. Thus, Chrissy decides that she would create two different formulas using the same Type A Type B, and Type C protein powders, where Formula 1 would cater to the first type of client and Formula 2 would cater to the second type of client. Formula 1 contains 50 gm of protein, 40 gm of carbohydrates, and 30 gm of fat per serving whereas Formula 2 contains 20 gm of protein, carbohydrates, and fats each per serving. The cost of producing 1 lb of Formula 1 is $11.99 and the cost of producing each pound of Formula 2 is $9.52. Chrissy intends to sell Formula 1 for a price of S20 and Formula 2 for a price of $15 per pound. The following table shows that Chrissy has spent $995 in obtaining Type A Type B, and Type C protein powders at this time. Her calculations have shown that Formula 1 contains 20% of Type A, 32% of Type B, and 49% of Type C powders, whereas Formula 2 contains 5% of Type A, 31% of Type B, and 64% of Type C powders. Remember that percentages also represent the proportion of each type of formula per lb. Help Chrissy determine how many pounds of Formula 1 and Formula 2 should she create from her ingredients to maximize her profit using a linear programming model. (Remember Profit = Selling price per lb. - Cost per lb.) Price/lb Formula Formula 1 2 0.20 0.05 0.32 0.31 0.49 0.64 $25.00 $10.00 $8.00 Purchased Lbs 15 30 40 Amt. Spent $375.00 $300.00 $320.00 Type A Type B Type C Selling Price Cost/lb $20 $15 TOTAL Spent $995.00 $11.99 $9.52 Fill in the following blanks: a. The Optimal Solution for Chrissy is to produce lbs of Formula 1 and lbs of Formula 2 to maximize her profits to $ (round to two decimal places) b. If Chrissy purchases an additional pound of Type A formula, her profits can increase by $ (round to two decimal spaces)

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!