# The New England Cheese Company produces two cheese spreads by blending mild cheddar cheese with extra sharp cheddar cheese. The cheese spreads are packaged in 12-ounce containers, which are then sold...

The New England Cheese Company produces two cheese spreads by blending mild cheddar cheese with extra sharp cheddar cheese. The cheese spreads are packaged in 12-ounce containers, which are then sold to distributors throughout the Northeast. The Regular blend contains 65% mild cheddar and 35% extra sharp, and the Zesty blend contains 75% mild cheddar and 25% extra sharp. This year, a local dairy cooperative offered to provide up to 8100 pounds of mild cheddar cheese for \$1.30 per pound and up to 3500 pounds of extra sharp cheddar cheese for \$1.50 per pound. The cost to blend and package the cheese spreads, excluding the cost of the cheese, is \$0.30 per container. If each container of Regular is sold for \$1.80 and each container of Zesty is sold for \$2.10, how many containers of Regular and Zesty should New England Cheese produce? Do not round your interim computations. If required, round your answers to the nearest whole number.

 LetR= number of containers of Regular Z= number of containers of Zesty

Optimal Solution:
R
= ,
Z
= , profit = \$.

## Answer To: The New England Cheese Company produces two cheese spreads by blending mild cheddar cheese with...

David answered on Nov 30 2019
Worksheet: [cheese.xlsx]Sheet1
Report Creat
ed: 29/10/2017 09:25:00
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.032 Seconds.
Iterations: 1 Subproblems: 4
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling
Max Subproblems Unlimited, Max Integer...
SOLUTION.PDF