Inventory Demand Forecasting Assistant
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.
How to use this prompt
- Pick your AI model. Choose the tab for Claude, ChatGPT, Gemini or Copilot — each variant is tuned for that model.
- Copy the full prompt. Click Copy Full Prompt to copy the text to your clipboard.
- Paste into your AI tool. Open your chosen model and paste the prompt into a new chat.
- Replace the
[placeholders]. Swap any bracketed fields for your company name, audience, product or tone. - Run and refine. Review the output. If anything is off, ask the AI to tighten tone, length or format.
Prompt Variants by Model
Claude
Claude 4.x
UPDATED 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
UPDATED 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
UPDATED 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)
UPDATED 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.
Frequently Asked Questions
What does the Inventory Demand Forecasting Assistant prompt do?
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.
Which AI models is this prompt tested on?
This prompt is field-tested on Claude, ChatGPT, Gemini and Copilot. Each model has its own optimized variant above.
Do I need a paid AI account to use this prompt?
No. This prompt is written to run on the free tier of Claude, ChatGPT, Gemini and Copilot. Paid tiers simply give you longer context windows and faster responses.
Can I customize this prompt for my business?
Yes. Any text inside square brackets is a placeholder you replace with your own business details, such as company name, audience, product or tone. You can also ask the AI to adjust format, length or style after the first output.
When was this prompt last verified?
Each model variant above shows its own freshness stamp. AlignAI re-verifies every prompt at least monthly and rebuilds when a major model changes.
Don’t see what you need? tailored to your use case.