Question: You are designing a diet plan for a meal. There are six different foods: bread, milk, cheese, potato, fish, and yogurt. The cost and nutrition

You are designing a diet plan for a meal. There are six different foods: bread, milk, cheese, potato, fish, and yogurt. The cost and nutrition values per unit are shown below. The objective is to find a minimum-cost meal that contains at least 300 calories, not more than 10 grams of protein, not less than 10 grams of carbohydrates, and not less than 8 grams of fat. In addition, the diet should contain at least 0.5 unit of fish and no more than 1 unit of milk. Use SOLVER to find the the least cost meal subject to the constraints outlined. Create a spreadsheet model for this problem and solve it using Solver. Describe the optimal solution in the shaded box using a few sentences. Make sure to format the changing cells (border), input data (gray shade), and objective function (yellow shade).
BreadMilkCheesePotatoFishYogurtCost$2.00$3.50$8.00$1.50$11.00$1.00Protein, g4871.389.2Fat, g1590.171Carbohydrates, g1511.70.422.6017Calories9012010697130180

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!