Inventory Demand Forecasting Assistant
Use this prompt to
Build an agentic workflow that analyzes 12 months of sales data, seasonal patterns, and supplier lead times to generate a rolling 90-day demand forecast with reorder alerts and safety stock recommendations.
Pro tip
Export sales data as CSV and include columns for date, SKU, units sold, and any promotional flags. For best results, pair with a Code Interpreter session to generate visual trend charts.
Prompt Variants by Model
Claude
Claude 4.x
FRESH APR 2026
You are a supply chain analyst. I will provide 12 months of sales data as a CSV. Build a comprehensive demand forecast.
<business_context>
Business type: [INDUSTRY]
Number of SKUs: [COUNT]
Average...You are a supply chain analyst. I will provide 12 months of sales data as a CSV. Build a comprehensive demand forecast.
<business_context>
Business type: [INDUSTRY]
Number of SKUs: [COUNT]
Average supplier lead time: [DAYS]
Seasonal patterns: [DESCRIBE ANY KNOWN SEASONALITY]
Upcoming promotions: [LIST ANY PLANNED PROMOS WITH DATES]
</business_context>
Analyze the attached data and produce:
1. **Trend analysis:** Overall sales trajectory, month-over-month growth rates
2. **Seasonality detection:** Identify recurring patterns and quantify their impact
3. **90-day rolling forecast:** Weekly demand projections for the next 90 days, per SKU category
4. **Reorder alerts:** Flag any SKU where projected demand will exceed current inventory within lead time
5. **Safety stock recommendations:** Calculate recommended safety stock levels using a 95% service level
6. **Promotional impact modeling:** Estimate demand uplift for planned promotions based on historical promo data
Output the forecast as a structured table. Flag high-confidence vs. low-confidence predictions. Highlight the top 5 SKUs by revenue risk (highest chance of stockout).
Notes: Upload the CSV directly. For visualization, ask Claude to generate Python code for charts in an Artifact.
ChatGPT
GPT-5
FRESH APR 2026
You are a demand planning analyst. I'm uploading 12 months of sales data (CSV). Build me a 90-day demand forecast.
**Business Info:**
- Industry: [INDUSTRY]
- SKU count:...You are a demand planning analyst. I'm uploading 12 months of sales data (CSV). Build me a 90-day demand forecast.
**Business Info:**
- Industry: [INDUSTRY]
- SKU count: [COUNT]
- Average supplier lead time: [DAYS]
- Known seasonal patterns: [DESCRIBE]
- Planned promotions: [LIST WITH DATES]
**Use Code Interpreter to:**
1. Analyze sales trends and month-over-month growth
2. Detect seasonal patterns and quantify impact
3. Generate a 90-day weekly demand forecast per SKU category
4. Flag SKUs at risk of stockout within lead time
5. Calculate safety stock (95% service level)
6. Model demand uplift for planned promotions
**Output:**
- Summary forecast table
- Charts showing trend + forecast for top SKUs
- Reorder alert list with recommended order dates
- Confidence levels for each prediction
Highlight the 5 SKUs with the highest revenue risk from potential stockouts.
Notes: This is where Code Interpreter shines — upload the CSV and get automated chart generation.
Gemini
Gemini 3 Pro
FRESH APR 2026
I need to build a demand forecast from my sales data. I will share 12 months of sales history.
**My business:**
- Industry: [INDUSTRY]
- Number of...I need to build a demand forecast from my sales data. I will share 12 months of sales history.
**My business:**
- Industry: [INDUSTRY]
- Number of products/SKUs: [COUNT]
- Supplier lead time: [DAYS] on average
- Seasonal patterns I know about: [DESCRIBE]
- Upcoming promotions: [LIST WITH DATES]
Please analyze the data and create:
1. Trend analysis (overall direction, growth rates)
2. Seasonal pattern detection
3. 90-day weekly demand forecast by SKU category
4. Reorder alerts for items at stockout risk
5. Safety stock recommendations (95% service level)
6. Promotional demand uplift estimates
Present the forecast as a clear table with confidence indicators. Call out the top 5 SKUs with the highest risk of stockout by revenue impact.
Notes: Use Gemini Advanced with Google Sheets integration to build a live forecasting dashboard.
Copilot
Copilot (Microsoft 365)
FRESH APR 2026
I have 12 months of sales data and I need a 90-day demand forecast for my business.
My business: [INDUSTRY]
Number of products:...I have 12 months of sales data and I need a 90-day demand forecast for my business.
My business: [INDUSTRY]
Number of products: [COUNT]
How long suppliers take to deliver: [DAYS]
Seasonal trends I know about: [DESCRIBE]
Promotions coming up: [LIST WITH DATES]
Please analyze my sales data and give me:
1. Overall sales trends and growth rates
2. Any seasonal patterns in the data
3. A 90-day weekly forecast for each product category
4. Warnings for any products that might run out before I can restock
5. How much safety stock I should keep
6. How upcoming promotions might affect demand
Show me a summary table and flag the 5 products I am most at risk of running out of.
Notes: Copilot in Excel can process the data directly in your spreadsheet.
Need Something Similar?
Request a prompt tailored to your specific use case.