SALES IN UNITS SECTION INSTRUCTIONS

Calculate PPC clicks:

Notice that the Initial Number of Clicks Per Month is already included in the Assumptions area of the worksheet.

Assume that the number of clicks will increase each month based on the Growth Rate Per Month as stated in the Assumptions area.

Enter a formula in the cell for January PPC Clicks that is equal to the Initial Number of Clicks Per Month. $[=$InitialClicks$]->$ the Jan value is $750$

Enter a formula in the cell for February PPC Clicks that increases the PPC clicks for January by the growth rate per month. Remember to add the increase for the month to the previous month. D$20$ is $[=$C$20+($C$20*$GrowthRate$)]->$ the Feb value is $752$

Copy the Feb formula across to December $->$ the Dec value is $775.$

Calculate Number of Cakes Sold

Assume the number of cakes sold will be some percentage of the number of clicks on the web page. In a web business, a conversion is when the viewer does what you want them to do$.$ For example, a conversion is when a viewer buys a cake.

Enter a formula in the January column that calculates the number of cakes expected to be sold each month by multiplying the PPC clicks times the conversion rate. $[=($C$20*$ConvRate$)]->$ the Jan value is $75.$

Copy the January formula across to December $->$ The Dec value is $78.$