Sales Forecast method using growth % from same month of prior year
This sales forecast model uses percentage growth from the same month of the prior year method to estimated next year monthly sales volume.
The model requires an input of two year monthly actual sales data. Next year’s monthly sales forecast is calculated based on the sales percentage growth from the same month of the prior year that you will input in designated cells.Monthly sales estimates, annual sales estimates, 2- and 3- year averages, monthly % contribution to total sales are automatically calculated.
The data is then pulled out in sets of interactive excel dashboards.
- Total sales analysis
summarizes and compares monthly sales in tables and graphs.
- Monthly contribution to annual total
table and graphs analyze each month’s contribution to annual sales.
ExcelIdea.com offers consulting services in creating custom solutions or upgrading your existing company spreadsheets. No request is too big or too small. Learn more .