Could someone please help me set up the linear program for this problem? I am having a hard time determining the equation and constraints. Once I have those, I know how to enter them into excel and solve to find the optimal solution. Although if someone could fully explain from start to finish that would be even more appreciated! I am still learning.

Thank you!

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 85% mild cheddar and 15% 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 9000 pounds of mild cheddar cheese for $1.50 per pound and up to 4000 pounds of extra sharp cheddar cheese for $1.70 per pound. The cost to blend and package the cheese spreads, excluding the cost of the cheese, is $0.25 per container. If each container of Regular is sold for $2.00 and each container of Zesty is sold for $2.50, 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 RegularZ=number of containers of Zesty

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