Calculating the Sales Trend

When calculating the sales trend, the application uses this year’s actuals for a specific week, if they are available. If this year’s actuals are not available in the system, then the application uses the forecasted sales for that week instead.

In general, the sales trend is the weighted average of the ratio between the actual or forecasted sales and the budgeted sales for the 8 previous weeks. For example, the application uses the following formula to calculate the sales trend for week 14: