Warehouse Fill Rate and Stockout Risk Analyzer
Evaluate order fill rate, stockout drivers, and replenishment risk across products, warehouses, or regions.
Prompt Template
You are a supply chain analyst. Create a fill rate and stockout risk analysis using the information below. Business type: [retail, ecommerce, wholesale, manufacturing] Products or categories in scope: [list] Warehouses or regions: [list] Order demand pattern: [stable, seasonal, promotional, volatile] Current metrics available: [fill rate, backorders, lead time, forecast accuracy, safety stock, days of inventory] Recent issues: [missed SLAs, stockouts, overstock, supplier delays] Decision needed: [reduce stockouts, rebalance inventory, improve replenishment rules] Provide: 1. Executive summary of service-level performance 2. Likely drivers of low fill rate or stockouts 3. Segment breakdowns to review first 4. Risk matrix by SKU, warehouse, or supplier 5. Recommended replenishment or inventory actions 6. KPIs to monitor weekly going forward 7. Questions the ops team should answer before making changes Keep the analysis grounded in operational decisions, not generic inventory theory.
Example Output
Executive Summary
Overall fill rate is 94.1%, but three fast-moving SKUs in the South warehouse account for 62% of missed lines. Supplier lead-time volatility, not forecast error, appears to be the main risk.
Priority Breakdown
- SKU A12: stockout risk high, lead time doubled in past 6 weeks
- SKU C44: healthy forecast but safety stock below promo-season demand
- North warehouse: overstocked on slow movers, candidate for transfer
Recommended Actions
Increase safety stock on the top 5 volatility-prone SKUs, create transfer triggers between North and South, and review supplier OTIF on the primary packaging vendor weekly.
Tips for Best Results
- 💡Include warehouse and supplier detail if you have it, aggregate inventory metrics hide the crime scene.
- 💡Ask for a risk matrix so the output points to where teams should act first.
- 💡Mention whether demand was promotional or seasonal because that changes how stockouts should be interpreted.
Frequently Asked Questions
What is the Warehouse Fill Rate and Stockout Risk Analyzer prompt?
Evaluate order fill rate, stockout drivers, and replenishment risk across products, warehouses, or regions. It's a free ChatGPT prompt template from our Data Analysis collection — copy it, fill in the bracketed variables, and paste it into your AI tool.
Which AI tools work with this prompt?
It's written and tested for ChatGPT, Claude and Gemini. Any AI assistant that accepts free-form text prompts will handle it well.
How do I customize this ChatGPT prompt?
Replace the bracketed variables — such as [list], [stable, seasonal, promotional, volatile] — with your own details before running it. Include warehouse and supplier detail if you have it, aggregate inventory metrics hide the crime scene.
Is this prompt free to use?
Yes. Every prompt on PromptAtlas is free to copy, customize, and use — no signup required.
Related Prompts
Dataset Summary and Insights
Paste or describe a dataset and get an instant summary of key statistics, patterns, anomalies, and actionable insights.
SQL Query Writer for Business Reports
Generate SQL queries for common business reporting needs — revenue trends, cohort analysis, funnel metrics, and more.
Dashboard KPI Definition Framework
Define the right KPIs for your business dashboard with clear formulas, targets, and data sources.