Question: please answer in excel, the last response was not organized/right A farm blends commercial fertilizers to create a customized mixture for its crops. The farm

please answer in excel, the last response was not organized/right
A farm blends commercial fertilizers to create a customized mixture for its crops. The farm has access to three commercial fertilizers X, Y, and Z. The customized mix must contain at least 200 pounds of Nitrogen (N),170 pounds of Phosphorous (P), and 160 pounds of Potassium (K). The below table indicates the percentage of the commercial fertilizer which contains each element, along with the cost per pound of each fertilizer. The percentages do not total 100 because each fertilizer has useless (but harmless) material as well. A. Create a spreadsheet model in standard LP form and use Solver to determine the optimal number of pounds of each of the three types of fertilizer (X, Y, and Z) to buy meet the requirements for Nitrogen, Phosphorous, and Potassium in the blended mix at minimum cost. Although the pounds of fertilizer purchased do not need to be integer, round their presentation to integers in your spreadsheet. Label your tab as Q2A. B. Write an algebraic formulation of the model. You may imbed your algebraic formulation into your spreadsheet (using tab Q2B) or you may submit it as a separate MS-word file or PDF file
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
