Joyce and Marvin run a daycare for preschoolers. They are trying to decide what to feed the children for lunches. They wonld like to keep their costs down, but also need to meet the nutritional requirements of the children. They have already decided to offer peanut butter and jelly sandwiches, and some combination of graham crackers, milk, and orange juce. The nutritional content of each food chcice 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 constume at lenst 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 guce). Joyce and Marvin would like to select the food choices for each child which minimize cost while meeting the above requirements. a. Formulate a linear programming model for this problem (10 points) b. Solve this model in Excel using the umiplex method and report your answer

Q&A Education