Homework Help Please Spreadsheet

Would you like to buy an assignment? Use our custom writing services for better grades.


Order a Similar Paper Order a Different Paper

Fertilizing the Lawn.

The facilities manager at Oxbridge University is planning to apply fertilizer to the grass in the quadrangle area in the spring. The grass needs nitrogen, phosphorus, and potash in at least the amounts given in the following table.

 Mineral               Minimum Weight (lb)

Nitrogen              1 2

Phosphorus        1 4

Potash  1 8

Three kinds of commercial fertilizer are available, with mineral content and prices per 1,000 pounds as given in the following table. There is virtually unlimited supply of each kind of fertilizer.

Nitrogen Phosphorus Potash

Fertilizer Content (lb) Content (lb) Content (lb) Price ($)

A             20           1 0          5              1 0

B             1 0          5              1 5          8

C             1 5          1 0          5              7

How much of each fertilizer should be purchased to satisfy the requirements at minimum cost?

HINT

Constraints

 

 

 

 

 

Requirements

Notrogin

20

10

15

SUMPRODUCT Formula

>=

12


The other fertilizer needed ingredients go under nitrogen just like the machinery and  assembly in the video. The set up is the same as the video.  

Video help link

http://screencast.com/t/sPx5mYEAd07

Writerbay.net

Do you need help with this or a different assignment? We offer CONFIDENTIAL, ORIGINAL (Turnitin/LopesWrite/SafeAssign checks), and PRIVATE services using latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and PhD writers.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper