$$ Q$20($Lemonade Stand$)(4$pt$)$ page $85($see your online textbook$)$

Create your own template from scratch

Create range names for all variables and paste range names in the template

For part A$,$ use goal seek to find the break$-$even sales volume

For part B$,$ create one$-$way table to answer the question

In your spreadsheet, discuss how a change in sales volume affects profit.

Try lemonade sold ranging from $100$ to $500$ with an increment of $50.$

For part C$,$ create two$-$way table to answer the question

In your spreadsheet, discuss how a change in sales volume and variable

cost jointly affect profit. Try lemonade sold ranging from $100$ to $500$ with

an increment of $50,$ and variable cost ranging from $$0\mathrm{.}10$ to $$0\mathrm{.}45$ with an

increment of $$0\mathrm{.}05$