Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Working with chemists at Virginia Tech and George Washington Universities, landscape contractor Kenneth Golding blended his own fertilizer, called Golding-Grow. It consists of four


image text in transcribed

Working with chemists at Virginia Tech and George Washington Universities, landscape contractor Kenneth Golding blended his own fertilizer, called "Golding-Grow." It consists of four chemical compounds: C-30, C-92, D-21, and E-11. The cost per pound for each compound is indicated as follows: CHEMICAL COMPOUND COST PER POUND ($) C-30 0.12 C-92 0.09 0.11 0.04 D-21 E-11 The specifications for Golding-Grow are as follows: (1) E-11 must constitute at least 15% of the blend; (2) C-92 and C-30 must together constitute at least 45% of the blend; (3) D-21 and C-92 can together constitute no more than 30% of the blend; and (4) Golding-Grow is packaged and sold in 50-pound bags. Formulate an LP problem to determine what blend of the four chemicals will allow Golding to minimize the cost of a 50-pound bag of the fertilizer. Detailed requirement: Define the decision variables necessary for the LP formulation as follows: W = Pounds of C-30 used in the blend X = = Pounds of C-92 used in the blend Pounds of D-21 used in the blend Z = Pounds of E-11 used in the blend (a) Formulate appropriately as an LP to minimize total cost. Provide the algebraic model formulation in your submission. Must be neatly presented. (b) Input and solve the formulation using Excel. All constraints must be presented in the spreadsheet (i.e., not only in Solver). After running Solver, report the total cost, and the resulting usage of each type of chemical compound.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

To formulate the linear programming LP problem follow these steps a Algebraic Model Formulation Obje... 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

Project Management A Managerial Approach

Authors: Jack R. Meredith, Samuel J. Mantel Jr.

8th edition

470533021, 978-0470533024

More Books

Students also viewed these General Management questions