week 4 forecast sales
LARA-G
SaleForecastTemplateExcel.xls36 Month Sales Forecast
| 36 Month Sales Forecast | ||||||||||||||
| Fiscal Year 1 | 2020 | |||||||||||||
| 2020 | ||||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Totals | ||
| Product Name | Enter Product/Service Name Here | |||||||||||||
| Units | 1,000 | 1,500 | 1,000 | 1,000 | 1,000 | 1,000 | 1,100 | 1,200 | 1,300 | 1,400 | 1,500 | 1,600 | 14,600 | |
| Selling Price | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | ||
| Total Sales | $5,000 | $7,500 | $5,000 | $5,000 | $5,000 | $5,000 | $5,500 | $6,000 | $6,500 | $7,000 | $7,500 | $8,000 | $73,000 | |
| % of Total | 6.85% | 10.27% | 6.85% | 6.85% | 6.85% | 6.85% | 7.53% | 8.22% | 8.90% | 9.59% | 10.27% | 10.96% | 100.00% | |
| 2021 | ||||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Totals | ||
| Units | 1,300 | 1,500 | 1,200 | 1,300 | 1,400 | 1,500 | 1,600 | 1,200 | 1,300 | 1,400 | 1,500 | 1,600 | 16,800 | |
| Selling Price | $5.10 | $5.10 | $5.10 | $5.10 | $5.10 | $5.10 | $5.10 | $5.10 | $5.10 | $5.10 | $5.10 | $5.10 | ||
| Total Sales | $6,630 | $7,650 | $6,120 | $6,630 | $7,140 | $7,650 | $8,160 | $6,120 | $6,630 | $7,140 | $7,650 | $8,160 | $85,680 | |
| % of Total | 7.74% | 8.93% | 7.14% | 7.74% | 8.33% | 8.93% | 9.52% | 7.14% | 7.74% | 8.33% | 8.93% | 9.52% | 100.00% | |
| 2022 | ||||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Totals | ||
| Units | 1,500 | 1,600 | 2,000 | 1,000 | 1,000 | 1,000 | 1,100 | 1,200 | 1,300 | 1,400 | 1,500 | 1,600 | 16,200 | |
| Selling Price | $5.10 | $5.10 | $5.10 | $5.10 | $5.10 | $5.10 | $5.10 | $5.10 | $5.10 | $5.10 | $5.10 | $5.10 | ||
| Total Sales | $7,650 | $8,160 | $10,200 | $5,100 | $5,100 | $5,100 | $5,610 | $6,120 | $6,630 | $7,140 | $7,650 | $8,160 | $82,620 | |
| % of Total | 9.26% | 9.88% | 12.35% | 6.17% | 6.17% | 6.17% | 6.79% | 7.41% | 8.02% | 8.64% | 9.26% | 9.88% | 100.00% | |
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |||
| 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | |||
| 2020 | 2021 | 2022 | ||||||||||||
| Units | 14,600 | 16,800 | 16,200 | |||||||||||
| Total Sales | $73,000 | $85,680 | $82,620 |
&C© Copyright, 2010, JaxWorks, All Rights Reserved.
This worksheet forecasts 3 years of product sales. The first two key data entries that you need to make are the first fiscal year and the first month of the forecast.
With the first year and month entered, the spreadsheet will automatically enter the remaining years and months. Your next step is to enter the number of units and selling price for each month.
This worksheet will print Centered and in Black & White.
Enter Start Month Here.
36 Month Sales Forecast
Units
Total Sales
