Question

In: Operations Management

A diet needs to be created that contains not less than 2146 calories, not more than...

A diet needs to be created that contains not less than 2146 calories, not more than 58 grams of protein, not less than 10 grams of carbohydrates and not less than 13 grams of fat. Also, the diet should haveminimal cost. In addition the diet should include at least 1 Units of fish and at least 1.2 cup of milk.

The diet will consist of the six different foods: Bread, Milk, Cheese, Fish, Potato and Yogurt. The following table lists the cost per unit of each item and the number of grams of protein, fat, and carbohydrates per unit as well as the calories that will be supplied by each food unit.

Bread

Milk

Cheese

Potato

Fish

Yogurt

Cost, (cents)

12

30

33

15

59

20

Protein, g

6

9

11

1.3

11

12.2

Fat, g

2

9

10

0.1

12

2

Carbohydrates, g

22

11.7

0.4

23.6

0

19

Calories, Cal

120

154

155

157

133

356





Find a diet that meets the requirements above while keeping the cost at an absolute minimum. Make sure that your Food Units are all Integers.

Minimum Cost=

Min Cost value is between 263 and 279

Bread =


Milk=


Cheese=


Potato=


Fish=

Yogurt=

Solutions

Expert Solution

Excel LP formulation

Solving the Solver Output is

Minimum Cost = 271

Optimal Solution

Bread = 1
Milk= 2
Cheese= 0
Potato= 8
Fish= 1
Yogurt= 1

Related Solutions

Provide a diet for three days for a person who needs to consume 2988 calories per...
Provide a diet for three days for a person who needs to consume 2988 calories per day. she wants to optimize performance with nutrition.
can you provide a diet for a woman who needs to consume 2988 calories per day?...
can you provide a diet for a woman who needs to consume 2988 calories per day? she is 21 years old 165 lb highly active high-level athlete and she is looking to optimize with nutrition
Diet Fractions. Roll 2 dice and use the numbers to make a fraction less than or...
Diet Fractions. Roll 2 dice and use the numbers to make a fraction less than or equal to 1. Player A wins if the fraction cannot be reduced; otherwise, player B wins. a. Play the game 50 times and record the results. b. Is the game fair or not? Why or why not? c. Using the sample space for 2 dice, compute the probabilities of winning for player A and for player B. Do these agree with the results obtained...
In no less than 200, but no more than 300 words explain to the class your...
In no less than 200, but no more than 300 words explain to the class your definition of Quality of Care. Make sure that your definition is in your own words, you provide references in your definition, and you format your writing in APA style.
Write a project proposal on this topic, not less than 2,500 words and not more than...
Write a project proposal on this topic, not less than 2,500 words and not more than 3000 words including references - “ Investigating the challenges confronting the performance of small and medium enterprises (SMEs) in Abuja.”
Why is focusing on the quality of foods you are consuming more important than counting calories?...
Why is focusing on the quality of foods you are consuming more important than counting calories? Be specific in your answer. Create a healthy/balanced sample daily menu complete with serving sizes that meets all the recommended servings.  You must include breakfast, lunch, dinner, snacks and beverages.
I was wondering, is there more or less water on the Earth than there used to...
I was wondering, is there more or less water on the Earth than there used to be a million years ago?
Write a paragraph for each question no less than 4 sentences, and no more than 10...
Write a paragraph for each question no less than 4 sentences, and no more than 10 sentences. Why is responsibility retained by nurses when tasks are delegated? What are the five individual power sources? Provide an example of each. Why is positive reinforcement such a powerful motivator? How does leadership differ from power? Can a leader be effective without power?
A diet doctor claims Australians are, on average, overweight by more than 10kg. To test this...
A diet doctor claims Australians are, on average, overweight by more than 10kg. To test this claim, a random sample of 100 Australians were weighed, and the difference between their actual weight and their ideal weight was calculated and recorded. The data are contained in the Excel file Weights.xlsx. Use these data to test the doctor's claim at the 5% level of significance. Excess weight (Kgs) 16.0 4.0 4.0 4.5 11.0 7.0 7.0 16.5 14.5 5.5 16.5 0.5 13.5 26.0...
Do advertisements appeal more to needs than to wants or do they appeal more to wants...
Do advertisements appeal more to needs than to wants or do they appeal more to wants than to needs? Write a journal entry response based on this question. Make sure to include specific examples and illustrations. This entry should be two paragraphs long and about 150 to 200 words.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT