Golding Landscaping and Plants, Inc. Kenneth and Patricia Golding spent a career as a husband-and-wife real estate investment partnership in Washington, DC. When they finally retire to a 25-acre farm in northern Virginia's Fairfax County, they became ardent amateur gardeners. Kenneth planted shrubs and fruit trees, and Patricia spent her hours potting all sizes of plants. When the volume of shurbs and plants reached the point that the Goldings began to think of their hobby in a serious vein, they built a greenhouse adjacent to their home and installed heating and watering systems. By 2005, the Goldings realized that their retirement from real estate had really only led to a second career - in the plant and shrub business - and they filed for a Virginia businesslicense. Withiin a matter of months, they asked their attorney to file incorporation documents and formed the firm Golding Landscaping and Plants, Inc. Early in the new business's existence, Kenneth Golding recognized the need for a high-quality commercial fertilizer that he could blend himself, both for sale for his own nursery. His goal was to keep his costs to a minimum while producing a top-notch product that was especially suited to the northern Virginia climate. Working with chemists at George Mason University, Golding blend "Golding-Grow". it consists of four chemical compoungs: C-30, C-92, D-21 and E-11. The cost per pound for each compound is indicated in the following table. Chemical compound Cost per Pound ($) C-30 .12 C-92 .09 D-21 .11 E-11 .04 The specifications for Golding-Grow are as follows: a. Chemical E-11 must comprise at least 15% of the blend b. C-92 and C-30 must together consitute at least 45% of the blend c. Dl-21 and C-92 can together constitute no more than 30% of the blend d Golding-Grow is packaged and sold in 50-pound bags. 1. 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 2. Solve by using Excel to find the best solution 3. Please submit your Excel spreadsheet template with solver 4. Which combination of the components used is the optimal solution to minimize cost in this case? Tell me English the Cost and the combinations used. hints: This is a minimize cost template - use the Holiday Meat Turkey ranch example as a template The model should give you the # of lbs for each C-30, C-92, D-21 and E11 The cost is given to you. Here are the constraints 50 lbs bugs on the RHS you put = 50 E-11 >=15% on the RHS your calculation should be =.15*50 (which will give you 7.5) C-92 and C-30 >=22.5 (45% for both) - On the RHS you put =.45*50 (that will give you 22.5) D-21 and C=92 <=30% On the RHS you put =.3*50 (that will give you 15) Use solver chapter 13 Looking for 5 answers. Final hints: Use the template attached but insert 2 additional columns since you have 4 products. You are looking for minimizing cost. I gave you the constraints...
Golding Landscaping and Plants, Inc.
Kenneth and Patricia Golding spent a career as a husband-and-wife real estate investment
By 2005, the Goldings realized that their retirement from real estate had really only led to a second career - in the plant and shrub business - and they filed for a Virginia businesslicense. Withiin a matter of months, they asked their attorney to file incorporation documents and formed the firm Golding Landscaping and Plants, Inc.
Early in the new business's existence, Kenneth Golding recognized the need for a high-quality commercial fertilizer that he could blend himself, both for sale for his own nursery. His goal was to keep his costs to a minimum while producing a top-notch product that was especially suited to the northern Virginia climate. Working with chemists at George Mason University, Golding blend "Golding-Grow". it consists of four chemical compoungs: C-30, C-92, D-21 and E-11. The cost per pound for each compound is indicated in the following table.
Chemical compound Cost per Pound ($)
C-30 .12
C-92 .09
D-21 .11
E-11 .04
The specifications for Golding-Grow are as follows:
a. Chemical E-11 must comprise at least 15% of the blend
b. C-92 and C-30 must together consitute at least 45% of the blend
c. Dl-21 and C-92 can together constitute no more than 30% of the blend
d Golding-Grow is packaged and sold in 50-pound bags.
1. 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
2. Solve by using Excel to find the best solution
3. Please submit your Excel spreadsheet template with solver
4. Which combination of the components used is the optimal solution to minimize cost in this case? Tell me English the Cost and the combinations used.
hints: This is a minimize cost template - use the Holiday Meat Turkey ranch example as a template
The model should give you the # of lbs for each C-30, C-92, D-21 and E11
The cost is given to you.
Here are the constraints
50 lbs bugs on the RHS you put = 50
E-11 >=15% on the RHS your calculation should be =.15*50 (which will give you 7.5)
C-92 and C-30 >=22.5 (45% for both) - On the RHS you put =.45*50 (that will give you 22.5)
D-21 and C=92 <=30% On the RHS you put =.3*50 (that will give you 15)
Use solver chapter 13
Looking for 5 answers.
Final hints: Use the template attached but insert 2 additional columns since you have 4 products. You are looking for minimizing cost.
I gave you the constraints...
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
