a week, which results in approximately $192$ potential dog services per month. Unfortunately, Kai is only booking $4$ grooming appointments on average each day. Kai knows he needs to do some marketing to increase his client base. To increase his bookings, Kai is deciding between two different promotional marketing campaigns.

Kai is deciding between running an advertisement in a local Dallas magazine and creating a $$10$ off coupon direct mail campaign. The magazine ad Kai is considering has an advertising cost of $$1000$ while the advertising cost for the direct mailing is $$500.$ Based on his research, Kai believes that the magazine advertisement would result in a $25$ percent increase in customers $(120$ customers per month$)$ while the direct mail coupon would result in a $55$ percent increase in customers $(150$ customers per month$).$

The goal of this activity is to understand the profit equation and the relationship between sales, revenue, and costs. Keep in mind that:

Profit $=$ Total Revenue $-$ Total Costs. Total Revenue $(TR)=$ Price $(P)$ Quantity Sold $m$ Q$).$

Refer to the formulas above and the spreadsheet below to help answer the questions that follow. The spreadsheet fields highlighted in yellow can be changed in order to determine possible outcomes. You can find the initial values in the corresponding blue cells in columns $E$ to $G.$ Start by entering the initial values into columns $B$ to $D.$ Then review the questions below and adjust the values in columns $B$ to $D$ to determine the correct answers.

$\backslash$table$[[,$A$,,B,,$C$,$D$,,$E$,,$F$,,$G$],[1,,$No promotion,$\backslash$table$[[$Magazine$],[$advertising$]],\backslash$table$[[$Coupon direct$],[$mail$]],\backslash$table$[[$Initial Value:$],[$No promotion$]],\backslash$table$[[$Initial Value:$],[$Magazine$],[$advertising$]],\backslash$table$[[$Initial Value:$],[$Coupon direct$],[$mail$]]],[2,$Number of clients per month,E$,,n,\backslash$table$[[150]],135,,96,-,120,,150],[3,$List price for service,$1,1,$$$,60\mathrm{.}00,60\mathrm{.}00,$$$,60\mathrm{.}00,5,6000,s,60\mathrm{.}00],[4,$Total Revenue $($Clients X List Price$),$$$,0\mathrm{.}00,$$$,9,000\mathrm{.}00,8,100\mathrm{.}00,5,5,760\mathrm{.}00,$$$,7,200\mathrm{.}00,$$$,9,000\mathrm{.}00$