{"id":7650,"date":"2021-10-13T22:22:19","date_gmt":"2021-10-13T22:22:19","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/homework-help-please-spreadsheet-numerical-analysis-homework-help\/"},"modified":"2021-10-13T22:22:19","modified_gmt":"2021-10-13T22:22:19","slug":"homework-help-please-spreadsheet-numerical-analysis-homework-help","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/homework-help-please-spreadsheet-numerical-analysis-homework-help\/","title":{"rendered":"Homework help please spreadsheet | Numerical analysis homework help"},"content":{"rendered":"
\n

Fertilizing the Lawn.<\/p>\n

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.<\/p>\n

\u00a0Mineral\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Minimum Weight (lb)<\/p>\n

Nitrogen\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 2<\/p>\n

Phosphorus\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 4<\/p>\n

Potash\u00a0 1 8<\/p>\n

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.<\/p>\n

Nitrogen Phosphorus Potash<\/p>\n

Fertilizer Content (lb) Content (lb) Content (lb) Price ($)<\/p>\n

A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 20\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 0<\/p>\n

B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8<\/p>\n

C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7<\/p>\n

How much of each fertilizer should be purchased to satisfy the requirements at minimum cost?<\/p>\n

HINT<\/span><\/p>\n\n\n\n\n
\n

Constraints<\/span><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/p>\n<\/td>\n

\n

Requirements<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Notrogin<\/span><\/p>\n<\/td>\n

\n

20<\/span><\/p>\n<\/td>\n

\n

10<\/span><\/p>\n<\/td>\n

\n

15<\/span><\/p>\n<\/td>\n

\n

SUMPRODUCT Formula<\/span><\/p>\n<\/td>\n

\n

>=<\/span><\/p>\n<\/td>\n

\n

12<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n


The other\u00a0fertilizer\u00a0needed ingredients go under nitrogen just like the\u00a0machinery\u00a0and \u00a0assembly in the video. The set up is the same as the video. \u00a0<\/span><\/span><\/p>\n

Video help link <\/span><\/p>\n

http:\/\/screencast.com\/t\/sPx5mYEAd07<\/a> <\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

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. \u00a0Mineral\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Minimum Weight (lb) Nitrogen\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 2 Phosphorus\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 4 Potash\u00a0 1 8 Three […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[],"class_list":["post-7650","post","type-post","status-publish","format-standard","hentry","category-homework-help"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/7650","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=7650"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/7650\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=7650"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=7650"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=7650"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}