Prompt lesson · 22 prompts
Inventory KPIs and Metrics prompts for Inventory Managers
22 ready-to-use prompts from our AI for Inventory Managers course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Analyze and Optimize Lead Time
Use this when you need to calculate lead time from historical data, identify bottlenecks, and suggest strategies to reduce it.
Role You are a supply chain analyst who helps inventory managers measure lead time, uncover root causes of delays, and recommend actionable improvements.
Context you provide
- {{Product/Category name}} — The product or category to analyze (e.g., "Electronics – Smartphones").
- {{Specific Products}} — If you want a focused analysis on particular SKUs, list them (e.g., "Model X, Model Y").
- {{lead time data}} — Provide the historical data you have, such as order dates, receipt dates, and any known sources of delay. If you don’t have structured data, describe the process (e.g., "We order from three suppliers, average lead time is 30 days, but we don’t track supplier performance per order").
Instructions
- If data is missing, ask for clarification or suggest how to collect it.
- Analyze the provided lead time data: calculate average lead time, variability, and identify outliers or trends.
- Identify strategies to reduce lead time for the specified products, considering supplier performance, transportation, customs, and internal processes.
- Evaluate the impact of lead time on inventory holding costs, stockouts, and service levels.
- Provide a prioritized list of recommendations with estimated effort and potential reduction in lead time.
Output format Deliver a structured analysis report: Lead Time Metrics, Root Cause Analysis, Impact Assessment, and Recommendations. Use tables for metrics, bullet points for causes, and a prioritization matrix for recommendations. Include numerical examples where possible. Keep the tone analytical and practical.
Guardrails
- Do not fabricate historical data; base calculations only on provided data or clearly stated assumptions.
- Flag any assumptions about supplier reliability or external factors (e.g., weather, political instability).
- Stay within lead time analysis; do not expand into broader inventory optimization without being asked.
Example {{Product/Category name}}: "Office Supplies – Paper" {{Specific Products}}: "A4 copy paper, 80gsm, 5000 sheets" {{lead time data}}: "We have 12 months of order records: order date, expected delivery, actual delivery. Average lead time is 14 days, but some orders took 30 days due to supplier delays."
Open this prompt Analysis · Intermediate
Analyze Backorder Rate and Reduction Strategies
Use this when you need to calculate backorder rates, identify patterns, and find root causes to reduce stockouts.
Role — You are an inventory and supply chain analyst who specialises in turning backorder data into actionable insights to reduce stockouts and improve customer fulfillment.
Context you provide
- {{time_frame}} — e.g., "last quarter" or "past 12 months"
- {{product_categories}} — comma-separated list of categories to analyze
- {{regions}} — optional, e.g., "North America, Europe"
- {{specific_products}} — optional, e.g., "laptop model X, phone case Y"
Instructions
- If any required context is missing, ask for it before proceeding.
- Calculate the backorder rate (backorders / total orders) for each product category and region provided.
- Identify patterns such as seasonal spikes, geographic concentration, or recurring product issues.
- Analyze historical data and demand patterns to suggest root causes for the backorders.
- Provide 3–5 concrete, prioritised recommendations to reduce backorders, covering inventory levels, supplier management, and demand forecasting.
Output format A structured report with:
- Backorder rate table (category, region, rate, trend)
- Pattern summary (bullet points)
- Root cause analysis (paragraph)
- Actionable recommendations (numbered list)
Guardrails
- Do not invent data; work only with the information provided or explicitly assumed.
- Flag any assumptions you make about seasonality or demand patterns.
- Keep recommendations within the scope of inventory and supply chain operations.
Example {{time_frame}} = "last quarter", {{product_categories}} = "electronics, apparel", {{regions}} = "North America", {{specific_products}} = ""
Open this prompt Analysis · Intermediate
Analyze Fill Rates And Find Improvement Areas
Use this when you need to review fill rate performance across products or categories and pinpoint where to improve.
Open this prompt Analysis · Intermediate
Analyze Inventory Shrinkage
Use this when you need to calculate inventory shrinkage, identify affected products, and get preventive recommendations.
Open this prompt Analysis · Intermediate
Analyze Stockout Rates and Causes
Use this when you need to explain why a product or category keeps running out of stock.
Open this prompt Analysis · Intermediate
Calculate An Inventory Reorder Point
Use this when you need to calculate a reorder point for a product based on its demand and lead-time variability.
Open this prompt Analysis · Intermediate
Calculate And Analyze Inventory Turnover
Use this when you need to calculate inventory turnover from your sales and inventory figures and spot trends worth acting on.
Open this prompt Analysis · Beginner
Calculate and Interpret Days Sales of Inventory
Use this when you need to compute Days Sales of Inventory (DSI) for a company or product line and understand what the metric reveals about inventory efficiency.
Open this prompt Analysis · Beginner
Calculate Days Inventory Outstanding
Use this when you need to calculate and interpret DIO for a product, category, or location.
Open this prompt Analysis · Intermediate
Calculate Inventory Carrying Costs
Use this when you need to quantify what holding inventory is actually costing you across storage, insurance, and obsolescence.
Open this prompt Analysis · Intermediate
Calculate Inventory Carrying Costs
Use this when you need to calculate the carrying cost of inventory, including storage, insurance, and obsolescence, and identify cost reduction strategies.
Open this prompt Analysis · Intermediate
Fill Rate Analysis
Use this when you need to calculate and analyze fill rates from order fulfillment data to identify improvement areas.
Open this prompt Analysis · Intermediate
Identify And Analyze Dead Stock
Use this when you need to find inventory that hasn't sold and understand why, to plan next steps.
Open this prompt Analysis · Intermediate
Improve Inventory Accuracy
Use this when you need to analyze inventory count data, identify root causes of discrepancies, and get recommendations to boost accuracy.
Open this prompt Analysis · Intermediate
Inventory Accuracy Assessment
Use this when you need to assess the accuracy of inventory records, identify discrepancies, and recommend improvements.
Open this prompt Analysis · Intermediate
Inventory Aging and Slow-Mover Analysis
Use this when you need to identify slow-moving or obsolete inventory and decide what to do with it.
Open this prompt Analysis · Intermediate
Inventory Turnover Ratio
Use this when you need to calculate and interpret inventory turnover for a company, warehouse, or product category.
Open this prompt Analysis · Beginner
Inventory-to-Sales Ratio Analysis
Use this when you need to calculate, monitor, or analyze inventory-to-sales ratios for a company, product category, or time period.
Open this prompt Analysis · Intermediate
Order Cycle Time Analysis
Use this when you need to analyze order processing data to calculate cycle time and identify bottlenecks.
Open this prompt Analysis · Intermediate
Rationalize SKU Portfolio
Use this when you need to evaluate your product portfolio and identify underperforming SKUs for consolidation or elimination.
Open this prompt Analysis · Intermediate
Stock Turnover Analysis and Improvement
Use this when you need to analyze stock turnover rates, identify slow-moving items, and get recommendations for improvement.
Open this prompt Analysis · Intermediate
Stockout Rate Analysis and Improvement
Use this when you need to calculate stockout rates from historical data, identify causes, and recommend inventory improvements.
Open this prompt Analysis · Intermediate