Using the last four weeks of sales data [or Attach file]:
Week 1: [insert units]
Week 2: [insert units]
Week 3: [insert units]
Week 4: [insert units]
Notes on anomalies: [insert any stockouts, distribution issues, or unusual spikes]
Expected percent change due to upcoming factor (promo, seasonality, traffic): [insert percent]
Please calculate the following:
Average of the last four weeks (raw)
Adjusted average accounting for anomalies. If any week is impacted by an anomaly, replace that week with the average of the non-anomalous weeks.
Expected percent change adjustment
Final weekly velocity forecast
Final monthly forecast (weekly forecast multiplied by 4)
Please present the results in a clear table with these rows:
Average of the last four weeks
Adjustments for anomalies
Adjustment for expected percent change
Final weekly forecast
Final monthly forecast
Then compute the final forecast using the values above.