Sales Forecast Template - Free Download | Page 4
4.7,
2830
votes
Please vote for this template if it helps you.


Page 4 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
Average Unit Cost
Swimsuits 10 10 10 10 10 10 10 10 10 10 10 10 10.00
Wet Suits 10 10 10 10 10 10 10 10 10 10 10 10 10.00
Surf Boards 10 10 10 10 10 10 10 10 10 10 10 10 10.00
Fishing Rods 10 10 10 10 10 10 10 10 10 10 10 10 10.00
Bait and Tackle 10 10 10 10 10 10 10 10 10 10 10 10 10.00
Average Unit Price
Swimsuits 20 20 20 20 20 20 20 20 20 20 20 20 20.00
Wet Suits 20 20 20 20 20 20 20 20 20 20 20 20 20.00
Surf Boards 20 20 20 20 20 20 20 20 20 20 20 20 20.00
Fishing Rods 20 20 20 20 20 20 20 20 20 20 20 20 20.00
Bait and Tackle 20 20 20 20 20 20 20 20 20 20 20 20 20.00
Average Unit Markup
Swimsuits 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
Wet Suits 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
Surf Boards 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
Fishing Rods 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
Bait and Tackle 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
Units Sold 25 25 25 25 25 25 25 25 25 25 25 25 300
Swimsuits 5 5 5 5 5 5 5 5 5 5 5 5 60
Wet Suits 5 5 5 5 5 5 5 5 5 5 5 5 60
Surf Boards 5 5 5 5 5 5 5 5 5 5 5 5 60
Fishing Rods 5 5 5 5 5 5 5 5 5 5 5 5 60
Bait and Tackle 5 5 5 5 5 5 5 5 5 5 5 5 60
Gross Sales 500 500 500 500 500 500 500 500 500 500 500 500 6,000
Swimsuits 100 100 100 100 100 100 100 100 100 100 100 100 1,200
Wet Suits 100 100 100 100 100 100 100 100 100 100 100 100 1,200
Surf Boards 100 100 100 100 100 100 100 100 100 100 100 100 1,200
Fishing Rods 100 100 100 100 100 100 100 100 100 100 100 100 1,200
Bait and Tackle 100 100 100 100 100 100 100 100 100 100 100 100 1,200
Cost of Goods 250 250 250 250 250 250 250 250 250 250 250 250 3,000
Swimsuits 50 50 50 50 50 50 50 50 50 50 50 50 600
Wet Suits 50 50 50 50 50 50 50 50 50 50 50 50 600
Surf Boards 50 50 50 50 50 50 50 50 50 50 50 50 600
Fishing Rods 50 50 50 50 50 50 50 50 50 50 50 50 600
Bait and Tackle 50 50 50 50 50 50 50 50 50 50 50 50 600
Gross Profit 250 250 250 250 250 250 250 250 250 250 250 250 3,000
Swimsuits 50 50 50 50 50 50 50 50 50 50 50 50 600
Wet Suits 50 50 50 50 50 50 50 50 50 50 50 50 600
Surf Boards 50 50 50 50 50 50 50 50 50 50 50 50 600
Fishing Rods 50 50 50 50 50 50 50 50 50 50 50 50 600
Bait and Tackle 50 50 50 50 50 50 50 50 50 50 50 50 600
Gross Profit Margin 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00%
Swimsuits 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00%
Wet Suits 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00%
Surf Boards 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00%
Fishing Rods 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00%