Differential Analysis and Product Pricing. i

$1)$ Your lawn is approximately $85,000$ sqft $(2$ acres$).$

$2)$ Sargent$$s program is a $4-$phase program. Phase I $($Weed and Crab Grass Prevention$)$ is to

be applied in early spring; Phase II $($Lawn Food$)$ is to be applied in early summer; Phase

III $($More Lawn Food$)$ is to be applied in mid$-$summer; Phase IV $($Lawn Winterization$)$ is to

be applied in late fall.

$3)$ All the product for all the phases comes in either small bags or big bags. You can buy the

product in small bags, big bags, or some combination thereof.

$4)$ A small bag covers $5,000$ sqft$.$ and costs $$25\mathrm{.}00.$

$5)$ A big bag covers $15,000$ sqft$.$ and costs $$65\mathrm{.}00.$

Using Excel, create different scenarios and figure out what is going to be the most cost effective. I need this in a excel spreadsheet form with formulas to use