Develop a spreadsheet, the solver window, its optimization results, and a spreadsheet model.

A $-3$ PAV

Howard's Apple Farm makes applesauce and apple juice from their apples. It costs $$0\mathrm{.}80$ to produce a jar of applesauce and $$0\mathrm{.}60$ to produce a bottle of apple juice. The farm requires that no less than $20\%$ and no more than $60\%$ of its output be applesauce. The farm can meet the demand for each product no matter the quantity, so he is not concerned about the quantity to produce of each product as that is dictated by the demand. Howard estimates that the fixed demand for applesauce is $5,000$ jars, plus an additional $3$ jars for every dollar spent on advertising for applesauce. Fixed demand for apple juice is estimated to be $4,000$ bottles, plus an additional $5$ bottles for every dollar spent on advertising for apple juice. The farm has $$16,000$ to spend on producing and advertising its two products. Applesauce sells for $$2\mathrm{.}00$ per jar; apple juice sells for $$1\mathrm{.}25$ per bottle. Additionally, making each jar of applesauce and each bottle of apple juice generates $0\mathrm{.}1$ and $0\mathrm{.}2$ pounds of compost, respectively, which Howard sells for $$5$ per pound. Can you help Howard in achieving the best business results? Develop a spreadsheet and spreadsheet model, solver window and its optimization results.