Sales Forecast Template - Free Download | Page 3
4.7,
2830
votes
Please vote for this template if it helps you.
Page 3 of 5
Beach City Surf Shop
2013-2014 Monthly Sales Projections
Year 1 of Operations
June July August September October November December January February March April May Total
Fishing Rods - - - 38.46% 38.46% 42.86% 46.67% 38.46% 38.46% 42.86% 50.00% 50.00% 44.77%
Bait and Tackle - - - 46.67% 46.67% 46.67% 46.67% 46.67% 60.00% 68.00% 73.33% 73.33% 61.81%
NOTES:
1) This example is for a first year firm. Returning firms may record sales in June, July and/or August.
2) The numbers used in this example are not accurate, they are simply a representation of what a completed sales forecast may look like
3) Average unit cost and average unit price would represent the average of ALL items in a particular product line
4) Units sold may spike during months in which your firm participates in a trade show. In this example the firm participated in trade shows in November in April
5) Markup is calculated using the following formula: 100 * (sales price - cost)/cost
6) Gross sales is equal to the average unit price multiplied by the expected sales total
7) Cost of goods sold is equal to the average unit cost multiplied by the expected sales total
8) Gross profit is calculated by subtracting the cost of goods sold from gross sales
9) Gross profit margin is calculated using the following formula: (revenue - cost of goods sold) / revenue
