Joyce and Marvin run a day care for preschoolers. They are trying to decide what to feed the children for lunches. They would like to keep their costs down, but they also need to meet the nutritional requirements of the children. They have already decided to go with peanut butter and jelly sandwiches, and some combination of graham crackers, milk, and orange juice. The nutritional content of each food choice and its cost are given in the table below.

The nutritional requirements are as follows. Each child should receive between 400 and 600 calories. No more than 30 percent of the total calories should come from fat. Each child should consume at least 60 milligrams (mg) of vitamin C and 12 grams (g) of protein. Furthermore, for practical reasons, each child needs exactly 2 slices of bread (to make the sandwich), at least twice as much peanut butter as jelly, and at least 1 cup of liquid (milk and/or juice).
Joyce and Marvin would like to select the food choices for each child that minimize cost while meeting the above requirements.
a. Identify the requirements that lead to resource constraints, to benefit constraints, and to fixed-requirement constraints.
b. Formulate and solve a linear programming model for this problem on a spreadsheet.
c. Express the model in algebraic form?

Transcribed Image Text:

Calories from Fat Total Calories Protein (g) Vitamin C Cost (mg) Food Item (c) Bread (1 slice) Peanut butter (1 tbsp.) Strawberry jelly (1 tbsp.) Graham cracker (1 cracker) Milk (1 cup) Juice (1 cup) 70 100 50 10 75 4 4 20 70 60 150 100 15 35 120 o omONg