# The Learning Center runs a day camp for 6-10 year olds during the summer. Its manager, Elizabeth

## Question:

The nutritional requirements are as follows. Each child should receive between 300 and 500 calories, but no more than 30 percent of these calories should come from fat. Each child should receive at least 60 milligrams (mg) of vitamin C and at least 10 grams (g) of fiber.

To ensure tasty sandwiches, Elizabeth wants each child to have a minimum of 2 slices of bread, 1 tablespoon (tbsp) of peanut butter, and 1 tbsp of jelly, along with at least 1 cup of liquid (milk and/or cranberry juice).

Elizabeth would like to select the food choices that would minimize cost while meeting all these requirements.

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

b. Formulate this same model algebraically?

Fantastic news! We've Found the answer you've been seeking!

## Step by Step Answer:

**Related Book For**

## Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets

**ISBN:** 978-0078024061

5th edition

**Authors:** Frederick S. Hillier, Mark S. Hillier