Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Materials Management

Authors: Arnold J. R. Tony, Gatewood Ann K., M. Clive Lloyd N. Chapman Stephen

8th edition

9386873249, 134156323, 978-9386873248

More Books

Students also viewed these General Management questions

Question

Exercise 17.1.15 Prove formula (17.8).

Answered: 1 week ago