PLEASE USE EXCEL FORMAT PROVIDED $TO$ SOLVE!!

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 $toa25-$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.

$By2005,$ 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\mathrm{.}12$

$C-92\mathrm{.}09$

$D-21\mathrm{.}11$

$E-11\mathrm{.}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 $in50-$pound bags.

$1.$ Formulate $anLP$ problem $to$ determine what blend $of$ the four chemicals will allow Golding $to$ minimize the cost $ofa50-$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 # $oflbs$ for each $C-30,C-92,D-21$ and $E11$

The cost $is$ given $to$ you.

Here are the constraints

$50lbs$ bugs $on$ the $RHS$ you put $=50$

$E-1115\%on$ the $RHS$ your calculation should $be=\mathrm{.}15*50(which$ will give you $7\mathrm{.}5)$

$C-92$ and $C-3022\mathrm{.}5(45\%$ for both$)-On$ the $RHS$ you put $=\mathrm{.}45*50(that$ will give you $22\mathrm{.}5)$

$D-21$ and $C=9230\%On$ the $RHS$ you put $=\mathrm{.}3*50(that$ will give you $15)$

PLEASE use the excel solver I have provided $to$ solve this problem. I have also provided the formula for cell $F3$ and also for cells $F5-F8$ which are all the sasme from $F5toF8.$