New Exercise Bank Content Qu$.06-26$

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 thelr 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.

Click here for the Excel Data File

The nutritional requirements are as follows. Each child should recelve between $400$ and $600$ calories. No more than $30$ percent of the

total calorles should come from fat. Each child should consume at least $60$ milligrams $($ mg $)$ of vitamin C and $12$ grams $($ g $)$ of proteln.

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 Julce$).$

Formulate and solve a linear programming model for this problem on a spreadsheet

a$.$ Joyce and Marvin would like to select the food choices for each child that minimize cost while meeting the above requirements.

Note: Leave no cells blank. Enter $"$O$"$ when necessary. Round your answers to $3$ decimal places.

b$.$ Determine the total cost

Note: Leave no cells blank. Enter $"$O$"$ when necessary. Round your answer to $2$ decimal places.