Green Acres Just Ran Out of Stock and Suddenly Has

question 49

Essay

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

---

Definitions:

Ethical Behavior

Actions or practices conducted in accordance with recognized moral principles or standards, crucial in maintaining trust and integrity in business.

Whistle-blower

An individual who exposes illegal, unethical, or improper conduct within an organization, often risking their own career or well-being.

Consumer Product Safety Commission

A U.S. federal agency responsible for the regulation of the sale and manufacture of consumer products to ensure their safety.

Electrical System

A network of electrical components deployed to generate, transmit, and distribute electricity to various endpoints.