## MAT 131 Sample Quiz 4

A woman wants to use milk and orange juice to increase the amount of calcium
and vitamin A in her daily diet. An ounce of milk contains 37 milligrams (mg) of
calcium and 57 micrograms (mcg) of vitamin A. An ounce of orange juice contains 5
mg of calcium and 65 mcg of vitamin A. How many ounces of milk
and orange juice should the woman drink each day to provide exactly 500
mg of calcium and 1,200 mcg of vitamin A?

Let x_{1} represent the number of ounces of milk and x_{2} the number of
ounces of orange juice. Here is a mathematical model of this problem:

Calcium: 37x_{1} + 5x_{2} = 500 mg
Vitamin A: 57x_{1} + 65x_{2} = 1200 mcg

This model was set up in Excel as shown below:

1. What Excel expression should go in cell H4?

2. What Excel expression should go in cell H5?

3. What range of cells should go in the "By Changing Cells" box in the
Solver Parameters dialog?

4. What constraints should go in the "Subject to the Constraints" box in
the Solver Parameters dialog?

Answers