Calculating the Sales Baseline
The application uses the following weighted average to calculate the sales baseline for a specific week:
[(Current week budgeted sales * 2) + (Next week budgeted sales * 3) + (Following week budgeted sales * 2)] / 7
Example
For example, the application calculates the forecast for week 14 as follows:
[(Week 14 budgeted sales * 2) + (Week 15 budgeted sales * 3) + (Week 16 budgeted sales * 2)] / 7