Question: Please use Microsoft Excel to solve each linear programming. Microsoft Excel Please use Microsoft Excel to solve each linear programming. Lawn Rich, Inc., makes four
Please use Microsoft Excel to solve each linear programming.
Microsoft Excel

Please use Microsoft Excel to solve each linear programming.
Lawn Rich, Inc., makes four different lawn care products that have fixed percents of phosphate, nitrogen, potash, and other minerals. The following table shows the percent of each of the four ingredients in each of Lawn Rich's products and the profit per ton for each product. A lawn care company buys in bulk from Lawn Rich and then blends the products for its own purposes. For the blend it desires, the lawn care company wants its Lawn Rich order to contain at least 35 tons of phosphate, at most 20 tons of nitrogen, at most 9 tons of potash, and at most 4 tons of other minerals. How many tons of each product should Lawn Rich produce to fulfill the customer's needs and maximize its own profit? What is the maximum profit
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
