Sales Forecast Template
![Sales Forecast Template]()
Through this template you can use to compile a basic monthly sales forecast for a three year period. Users are required to enter the monthly sales volumes, selling prices and gross profit percentages for each product category and all the other calculations are automatically updated. The template includes five default product categories but you can add additional product categories by simply inserting the appropriate number of rows in each section of the sales forecast.
Note: All the cells on the SalesForecast sheet that require user input have been highlighted with a "Light Green" cell background. All the other cells contain formulas and are therefore automatically updated.
The monthly periods that are included in the sales forecast are determined by the date that is entered in cell B4. You can enter any date in accordance with the regional settings that are specified in the System Control Panel into this cell and all the other monthly periods will be amended accordingly.
The monthly sales volumes, selling prices and gross profit percentages also need to be entered. All other amounts are automatically calculated. Note that the monthly cost of sales amounts are determined by calculating the monthly gross profit amounts based on the gross profit percentages that have been specified and the monthly sales amounts that have been calculated and then deducting these gross profit amounts from the monthly sales amounts.
If you require additional product categories, we recommend inserting the required number of additional rows anywhere between the first and last product categories in each section of the sales forecast and then copying the existing formulas from one of the default product category rows in each section.
Note that the additional rows should be inserted into the same position in each section of the sales forecast before copying the formulas in order to ensure that formulas are copied accurately.
