Create a Sales forecast for 12 months based on the information below for an Online business.

Include Notes to financial of how the numbers were formulated, like 20% increase during December because of Christmas etc.

What will the monthly variable expenses be and why?

These will fluctuate with the sales and are often determined calculated percentage.

Selling products:

Example: Accessories, Bags, Collectibles, Hats, Shoes, Socks, T-shirts, Tops, Outerwear, Bottoms

Market target: Gen Z and millennials age 13-35

Average spending for customers $15-$35 per customer visit

Product prices range from $2-$100

Should look like this:

4 5 6 Board and Kennel November December January February March April May June July August September October Units 160 353 106 156 251 143 168 233 410 354 228 232 Pricel s 25.00 $ 25.00$ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00$ 25.00 $ 25.00 $ 25.00 $ 25.00 Total $ 4,000.00 $ 8,825.00 $ 2,650.00 $ 3,900.00 $ 6,275.00$ 3,575.00 $ 4,200.00 $ 5,825.00 $ 10,250.00 $ 8,850.00 $ 5,700.00 $ 5,800.00 7 8 9 10 11 12 Doggy Day Care November December January February March April May June July August September October Units 126 155 89 123 128 120 101 120 175 133 129 120 Price $ 20.00 $ 20.00 $ $ 20.00 $ 20.00 $ 20.00 $ 20.00 $ 20.00 $ 20.00 $ 20.00 $ 20.00 $ 20.00 $ 20.00 Total $ 2,520.00$ 3,100.00 $ 1,780.00 $ 2,466.67 $ 2,560.00 $ 2,400.00 $ 2,020.00 $ 2,400.00 $ 3,500.00 $ 2,660.00 $ 2,580.00 $ 2,400.00 13 14 15 16 17 18 + Grooming November December January February March April May June July August September October Grooming Units 72 118 73 101 110 106 111 113 139 121 131 97 Price $ 69.92 $ 69.92 $ 69.92 $ 69.92 $ 69.92 $ 69.92 $ 69.92 $ 69.92 $ 69.92 $ 69.92 $ 69.92 $ 69.92 Total $ 5,034.00 $ 8,250.17 $ 5,103.92 $ 7,061.58 $ 7,690.83 $ 7,411.17 $ 7,760.75 $ 7,900.58 $ 9,718.42 $ 8,459.92 $ 9,159.08 $ 6,781.92 19 20 21 22 18 30 28 28 28 35 30 33 24 Special Shampoo Units Price $ Total $ 23 27 10.25$ 10.25$ 184.50 $ 18 10.25$ 187.06 $ 10.25$ 302.38$ 25 10.25$ 258.81 $ 10.25 $ 281.88 $ 10.25$ 284.44 $ 10.25 $ $ 289.56 $ 10.25$ 356.19 $ 10.25$ 310.06 $ 10.25$ 335.69 $ 10.25 248.56 24 271.63 $ 25 26 21 29 Brush Out Units Price $ 27 28 29 32 71 22.50 $ 22.50 $ $ 720.00 $ 1,588.50 $ 22.50 $ 477.00 S 21 50 22.50 $ 22.50 $ 477.00 $ 1,129.50 $ 22.50 $ 643.50 $ 34 47 82 71 46 46 22.50 $ 22.50 $ 22.50 $ $ 22.50 $ 22.50 $ 22.50 756.00 $ 1,048.50 $ 1,845.00 $ 1,593.00 $ 1,026.00 $ 1,044.00 Total $ 30 43 29 42 57 26 27 35 59 36 35 Nail Trim Units Price $ 31 76 10.00 $ 762.00 $ 10.00 $ 10.00 $ 10.00 $ 429.00 $ 10.00 10.00 $ 292.50 $ 10.00 $ 419.00 $ 10.00 $ 568.50 $ 10.00 $ 269.00 $ 49 10.00 $ 487.00 $ 10.00 $ $ 585.00 $ 10.00 $ 357.00 $ Total $ 263.00 $ 353.00 $ 352.00 32 33 29 20 26 27 35 59 36 34 35 36 Ear Cleaning Units Price $ Total $ 51 11.50 $ 11.50 $ 28 11.50 S 321.23 $ 38 11.50 $ 435.85$ 11.50 11.50 $ 224.25$ $ 11.50 $ 11.50 $ 302.45$ 11.50 $ 309.35 $ 49 11.50 $ 560.05 $ 11.50 $ 410.55$ 35 11.50 404.80 328.90 $ 584.20 $ 405.95 $ 672.75 $ 42 * March, June, July, August, December & January will be full capacity for dogs in kennels due to military leaves 43 Doggy Day Care spots are likely to not be at compacity during these times as people could be at home on leave 44 Grooming Clients come once monthly, however more come before holidays to get their pets ready for special occasions 45 Roughly 15% of clients from doggy day care and Kenneling will purchase a nail trim in the winter/fall months 46 Roughly 10% of clients from doggy day care and kenneling will purchase a nail trim in summer months as dogs wear them down faster than winter 47 Roughly 25% of Grooming Clients will purchase the Special Shampoo Treatment 48 Marketing - 2% of revenue for busy months (marketed previous month), slower months we used 1% of revenue 49 May - August Enbridge expense is hard coated for plain delivery fee 50 November to April - We estimate a 1.5% in Enbridge charge based on revenue and weather 51 September and October we estimate a 0.5% in Enbridge charge based on revenue and weather 52 Hydro - we estimate 2.5% of revenue 53 Vehicle Gas Expense - we estimate 0.5% military will use this service 54 Projected Sales April 2019 - March 2020 Month April May June July August September October November December January February March TOTAL Capacity % 50% 65% 70% 85% 80% 75% 75% 70% 80% 55% 45% 50% # Patrons Beverage Food Merchandise 3,750 37,500 39,375 2,344 $ 5,265 63,180 55,283 3,291 $ 5,460 65,520 57,330 3,413 $ 6,630 79,560 69,615 4,144 $ 6,480 77,760 68,040 4,050 $ 5,625 67,500 59,063 3,516 $ 6,075 72,900 63,788 3,797 $ 5,460 65,520 57,330 6,825 $ 5,760 69,120 60,480 7,200 $ 4,290 51,480 45,045 2,681 $ 3,375 40,500 35,438 2,109 $ 3,900 46,800 40,950 2,438 $ 62,070 $ 737,340 $ 651,735 $ 45,806 $ Total $ 79,219 121,753 126,263 153,319 149,850 130,078 140,484 129,675 136,800 99,206 78,047 90,188 1,434,881