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
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...See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started