Kenneth and Patricia Golding spent a career as a husband-and-wife real estate investment…

Written by

in

Kenneth and Patricia Golding spent a career as a husband-and-wife real estate investment partnership in Washington, DC. When they finally retired 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 shrubs 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. 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 business license. Within 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 and 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 blended “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 in the following table:
Chemical Compound
Cost Per Pound ($)
C-30
0.15
C-92
0.20
D-21
0.25
E-11
0.30
The specifications for Golding-Grow are as follows:
C-30 and D-21 must together constitute no more than 40% of the blend.
C-92 and E-11 must together constitute at least 20% of the blend.
Golding-Grow is packaged and sold in exactly 100-pound bags. Define the decision variables, write the objective function, and write the constraints in a blank Excel file. Set up and solve the given problem using SOLVER Add-In. How many pounds of C-30 should be used in the blend? Enter the amount (lbs) of C-30. *Please enter your answers as whole numbers (like 0; 1; 14; 50; etc.).

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *