Great Deal! Get Instant $25 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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 32 days AfterOct 28, 2017

Solution

David answered on Nov 30 2017
22 Votes
Answer Report 1
    Microsoft Excel 16.0 Answer Report
    Worksheet: [cheese.xlsx]Sheet1
    Report Created: 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