This sales forecast model
allows estimating quarterly sales
with a break down for the top five products for the next two years using percentage growth from the same quarter of prior year method
The model requires an input of one year actual quarterly sales data. Quarterly sales forecast for consequent years is calculated based on the sales percentage growth from the same quarter of prior year estimates that you will input in designated cells.
Product quarterly and annual dollar sales estimates, quarterly % sales growth, % from annual products sales are automatically calculated.
The data is then pulled out in a set of interactive excel dashboards.
- Total sales analysis
summarizes and compares annual and quarterly sales in tables and graphs.
- Quarterly % growth from prior quarter by product
table and graphs analyze each products sales growth seasonality pattern.
- Quarterly % growth from prior year by product
table and graphs analyze each products sales percentage change from the same quarter of prior year.
- Quarterly contribution to yearly total
table and graphs analyze each products quarterly contribution to product annual sales.