Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 fileStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started