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
Transit Fare Evasion Pattern Analysis Builder
Analyze transit fare evasion patterns with station segments, time trends, inspection data, equity safeguards, revenue estimates, and intervention testing.
Food Pantry Distribution Demand Analysis Builder
Analyze food pantry demand, visit patterns, household needs, item stockouts, volunteer coverage, and distribution-slot capacity for nonprofit food programs.
Library Hold Queue Wait Time Analysis Builder
Analyze public library hold queues, copy availability, branch demand, wait times, and purchasing signals for print, ebook, audiobook, or media collections.
Sterile Processing Instrument Tray Turnaround Analysis Builder
Analyze sterile processing instrument tray turnaround times, bottlenecks, rework, case readiness, staffing, and quality issues for hospital operations.
Clinical Lab Specimen Turnaround Time Analysis Builder
Analyze clinical lab specimen turnaround time by collection, transport, accessioning, testing, verification, priority, department, and bottleneck risk.
Municipal Permit Processing Backlog Analysis Builder
Analyze building permit intake, review stages, resubmissions, staffing, and service targets to find bottlenecks and reduce municipal permit backlogs.