The California Cheese Company produces two cheese spreads by blending mild cheddarcheese with sharp cheddar cheese. The cheese spreads are sold in one pound containers.There are two blends. Regular blend contains 80% mild cheddar and 20% sharp cheddar.The Tangy blend contains 60% mild cheddar and 40% sharp cheddar.The company can buy as much as 8100 pounds of mild cheddar cheese for $1.20 per poundand up to 3000 pounds of sharp cheddar cheese for $1.40 per pound. The cost to blend andpackage the cheese spreads is $.20 per one-pound container.Each container of the Regular blend sells for $2.60 and each container of Tangy sells for$2.20. The company can sell up to 7000 pounds of the Regular blend and up to 4000pounds of the Tangy blend.The California Cheese Company wants to determine how many (one pound) containers ofeach blend to produce. Its goal is to maximize profit.(a) Draw the problem network. (4 Points)(b) Define the decision variables. (4 Points)(c) Write the objective Function. (6 Points)(d) Write the constraints. (16 Points)(e) Solve the problem in Excel (20 Points)
The California Cheese Company
Plagiarism-free and delivered on time!
We are passionate about delivering quality essays.
Our writers know how to write on any topic and subject area while meeting all of your specific requirements.
Unlike most other services, we will do a free revision if you need us to make corrections even after delivery.