Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The facilities manager at Ontario Tech is planning to apply fertilizer to the grass in the quadrangle area in the spring. The grass needs nitrogen,

The facilities manager at Ontario Tech 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: Three kinds of commercial fertilizer are available, with mineral content and prices per 1,000 pounds as given in the following table. Using Excel Solver, determine how much of each fertilizer should be purchased to satisfy the requirements at minimum cost. Be sure to select keep the Solver solution and generate an answer report. Excel Solver Task (a) Open a NEW workbook and save it as Fertilizer Cost.xlsx. Insert a Documentation worksheet and add an appropriate title for the workbook in cell A1. In cell B3, enter your name. In cell B4, enter your student number. In cell B5, enter the completion date of your assignment, and in cell B6, enter a sentence to describe the purpose of the workbook. (b) Using a new worksheet, formulate and enter the above optimization problem. Note: you can find several examples on Excel Solver on Canvas Module, under Lecture 5. (c) Enter Solver Parameters (Set Objective, To, By Changing Variable Cells and Subject to the Constraints) (d) Solve the problem. Be sure to select Keep the Solver Solution and generate an Answer report. Note: If you get an internal memory error message, remove Solver as an add-in, close the workbook, open the workbook, add Solver in again, and finish using Solver. (e) Using the same worksheet, answer the following questions. i. How much of each fertilizer should be purchased to satisfy the requirements at minimum cost? ii. What is the minimum cost? (rounded your answer to the nearest cent) (f) Format your workbook as desired (Headings, Font, Fill color, Number format...) (g) Save and close your workbook.

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

Enron And World Finance A Case Study In Ethics

Authors: P. Dembinski, C. Lager, A. Cornford, J. Bonvin

1st Edition

1403947635, 978-1403947635

More Books

Students also viewed these Finance questions

Question

=+ e. What happens to Oceanias real exchange rate?

Answered: 1 week ago

Question

What is Aufbau's rule explain with example?

Answered: 1 week ago

Question

to encourage a drive for change by developing new ideas;

Answered: 1 week ago

Question

4 What are the alternatives to the competences approach?

Answered: 1 week ago