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

1 answer below »

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.

Let R =
number of containers of Regular
Z =
number of containers of Zesty

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

Answered Same DayOct 28, 2019

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

David answered on Nov 30 2019
59 Votes
Answer Report 1
    Microsoft Excel 16.0 Answer Report
    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

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here