Green Acres just ran out of stock and suddenly has two emergency orders for grass seed blends: one is for 1800 pounds of normal, the other for 3300 pounds of special.At least each pound of normal should contain 60 percent annual seed, while each pound of special should contain at least 70 percent perennial seed.Green Grass has two input mixtures, A and B.Mixture A contains 80 percent perennial and 15 percent annual seed.Mixture B contains 70 percent annual and 25 percent perennial seed.Mixture A costs 85 cents per pound and mixture B costs 55 cents per pound.Solve this blending problem using Excel Solver.
Let W = lbs.of mixture A used to produce the normal blend
X = lbs.of mixture A used to produce the special blend
Y = lbs.of mixture B used to produce the normal blend
Z = lbs.of mixture B used to produce the special blend

Question

Quizplus · Accepted Answer

The Answer of Green Acres just ran out of stock and suddenly has two emergency orders for grass seed blends: one is for 1800 pounds of normal, the other for 3300 pounds of special.At least each pound of normal should contain 60 percent annual seed, while each pound of special should contain at least 70 percent perennial seed.Green Grass has two input mixtures, A and B.Mixture A contains 80 percent perennial and 15 percent annual seed.Mixture B contains 70 percent annual and 25 percent perennial seed.Mixture A costs 85 cents per pound and mixture B costs 55 cents per pound.Solve this blending problem using Excel Solver.
Let W = lbs.of mixture A used to produce the normal blend
X = lbs.of mixture A used to produce the special blend
Y = lbs.of mixture B used to produce the normal blend
Z = lbs.of mixture B used to produce the special blend

Green Acres Just Ran Out of Stock and Suddenly Has