Assume that you work for Mr$.$ Sprangle who owns Springle CupCakes. You created a model for Mr$.$ Sprangle to show the cost and sales of different types of cupcakes for a typical month. For each type of cupcakes, cost is unit cost multiplied by number of cupcakes; sales is unit price multiplied by number of cupcakes. Profit is Sales minus Cost. Complete the worksheet C$13$:E$17.$

In addition, Mr$.$ Sprangle has borrowed $$65,000$ from a bank for his business. The bank charges him an interest rate of $3\mathrm{.}75\%$ to be paid off in $3$ years. What is the monthly payment for this loan? Show the monthly payment formula in cell B$24.$

$($Provide your answers to $2$ decimal places for answers related to currency and $0$ decimal places otherwise.$)$

What is the Total Profit for a typical month?

If Mr$.$ Sprangle wants to make a total profit of $$21,000$ per month, how many cupcakes would he have to produce each month?

If Mr$.$ Sprangle maintains production of $8000$ cupcakes and wants to make a total profit of $$20,500$ per month, what should the price for each Lavender Tangerine Dream Cupcake be$?$

Provide the formula you used in cell B$24.$

What is Mr$.$ Sprangle's monthly loan payment $($provide this amount as a positive figure$)?$