Sales Velocity Forecast Prompt Template
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.
0
0 comments
Sabrina Valdez
1
Sales Velocity Forecast Prompt Template
powered by
CPG AI ACCELERATOR
skool.com/cpg-ai-accelerator-2786
Where CPG founders unlock AI to scale smarter, faster, and leaner — without hiring more. Stay ahead, save time, and grow with the power of AI.
Build your own community
Bring people together around your passion and get paid.
Powered by