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.
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.