Building a Project

School: Brigham Young University, Idaho - Course: BUS 180 - Subject: Accounting

SALES IN UNITS SECTION 1.Calculate 'PPC clicks': A.Notice that the "Initial Number of Clicks Per Month" is already included in the "Assumptions" area of the worksheet. B.Assume that the number of clicks will increase each month based on the "Growth Rate Per Month" as stated in the "Assumptions" area of the worksheet. C.Enter a formula in the cell for Jan PPC Clicks that is equal to the Initial Number of Clicks Per Month. [=InitialClicks] → the value is 750 D.Enter a formula in the cell for Feb PPC Clicks that increases the PPC clicks for Jan by the Growth Rate/Month. Remember to add the increase for the month to the previous month. D20 is [=C20+(C20*GrowthRate)] → the value is 752 E.Copy this formula across to December. → the December value is 775. 2.Calculate the 'Unit Cake Sales': A.Assume the number of cakes that will be sold, will be some percentage of the number of clicks on the link in the Google Ads campaign. Note: 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. B.Enter a formula in the Jan column that calculates the number of cakes expected to be sold each month by multiplying the PPC Clicks times the Conversion Rate. [=(C20*ConvRate)] → the value is 75. C.Copy the January formula across to December. → The Dec value is 78. 3.Calculate the 'New Subscriptions Each month': Note: It is reasonable to think that not everyone who buys a cake will also subscribe.

A.Enter a formula in the Jan column that calculates the number of subscriptions expected to be sold each month. → the value for Jan is 6. B.Copy the January formula across to December. → The Dec value is also 6. NOTE: Since our numbers are so small, the subscriptions only increase by around 2/hundredths each month. Since these are estimates it's OK to have parts of a whole expressed as decimals. We are only hiding the decimals on the spreadsheet to make it easier to read. DO NOT round your results because the hidden decimals have a significant impact on the calculations. 4.'Subscriptions Ended Each Month' is calculated for you. A.It is also reasonable to think that those who subscribe will not subscribe every month. Eventually they will end their subscription. B.This is a complicated formula so it has been created for you based on the "Average Number Months Subscribed."DO NOTchange, copy or erase any of the cells in this row! (You may want to look at the formula and try to figure out how it works.) C.The Jan value is zero, seen as a dash '-', and the Dec value is 6. Note: These projections are all based on averages. One person may end their subscription after one month and another may subscribe for three years.