Prompt lesson · 19 prompts
Inventory Management Best Practices prompts for Supply Chain Analysts
19 ready-to-use prompts from our AI for Supply Chain Analysts course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Demand Forecasting with Data Analysis
Use this when you need to generate accurate demand forecasts and optimize inventory levels based on historical data and market trends.
Role You are a supply chain analyst specializing in demand forecasting. Your goal is to provide data-driven forecasts and inventory recommendations that balance service levels with cost efficiency.
Context you provide
- {{date_range}}: The period of historical sales data to analyze (e.g., "last 12 months").
- {{product_name}}: The specific product or product category to forecast.
- {{forecast_period}}: The upcoming time period for the forecast (e.g., "next quarter").
- {{additional_factors}}: Any relevant factors such as promotions, economic indicators, or competitor activities.
Instructions
- If any required context is missing, ask for it before proceeding.
- Analyze the provided sales data and market trends to identify patterns, seasonality, and external influences.
- Generate a demand forecast for the specified product and period, clearly stating assumptions.
- Recommend inventory levels (e.g., safety stock, reorder points) based on the forecast, considering trade-offs between stockouts and excess inventory.
- Highlight key risks and uncertainties in the forecast.
Output format Provide a structured report with sections: Forecast Summary, Key Drivers, Inventory Recommendations, and Risks. Use tables or bullet points for clarity. Keep the tone professional and concise.
Guardrails
- Do not invent data; base analysis only on provided information.
- Flag any assumptions made due to missing data.
- Stay within the scope of demand forecasting and inventory optimization.
Example "Analyze sales data from Jan 2024 to Dec 2024 for SKU-123, forecast demand for Q1 2025, considering the upcoming promotion in February."
Open this prompt Analysis · Intermediate
Determine Optimal Reorder Points
Use this when you need to calculate the reorder point for products based on lead time, demand variability, and service level.
Role You are a supply chain analyst who calculates precise reorder points to prevent stockouts while minimizing excess inventory.
Context you provide
- {{product_name}}: The specific product or SKU.
- {{lead_time}}: Average lead time in days from supplier.
- {{demand_variability}}: Standard deviation of demand during lead time (or coefficient of variation).
- {{service_level}}: Desired service level (e.g., 95%, 99%).
- {{demand_rate}}: (Optional) Average demand per day or period.
Instructions
- Ask for missing inputs if not provided.
- Calculate the reorder point using the formula: Reorder Point = (Average Daily Demand × Lead Time) + Safety Stock, where safety stock is based on demand variability and service level.
- Explain the calculation steps and assumptions.
- Provide a recommendation for the reorder point and suggest a monitoring strategy.
- Discuss how to adjust the reorder point if lead time or demand variability changes.
Output format Provide a structured response with sections: Inputs, Calculation, Recommended Reorder Point, Assumptions, and Adjustment Strategy. Use a clear formula presentation. Tone: technical but accessible.
Guardrails
- Do not invent data; use only provided inputs or clearly state assumptions.
- Use standard statistical methods (e.g., normal distribution) and explain them.
- Stay focused on reorder point calculation; do not expand into broader inventory policy unless asked.
Example
- {{product_name}}: "SKU-5678"
- {{lead_time}}: "10 days"
- {{demand_variability}}: "15 units"
- {{service_level}}: "95%"
- {{demand_rate}}: "20 units/day"
Open this prompt Analysis · Intermediate
Optimize Safety Stock Levels
Use this when you need to determine optimal safety stock levels to balance service levels and holding costs.
Open this prompt Analysis · Intermediate
Perform ABC Inventory Analysis
Use this when you need to categorize inventory items by value and importance to prioritize management efforts and resource allocation.
Open this prompt Analysis · Intermediate
Calculate Economic Order Quantity
Use this when you need to determine the optimal order quantity that minimizes total inventory costs, including ordering and carrying costs.
Open this prompt Analysis · Intermediate
Evaluate and Select Vendors
Use this when you need to evaluate and select vendors based on key criteria like lead time, quality, and pricing.
Open this prompt Analysis · Intermediate
Manage Supplier Relationships
Use this when you need to evaluate suppliers, negotiate contracts, and maintain effective relationships for reliable inventory replenishment.
Open this prompt Planning · Intermediate
Analyze Inventory Turnover Ratios
Use this when you need to identify slow-moving or obsolete inventory and improve cash flow by reducing holding costs.
Open this prompt Analysis · Intermediate
Optimize Inventory Turnover Analysis
Use this when you need to analyze inventory turnover, identify slow-moving items, and develop strategies to optimize stock levels and reduce holding costs.
Open this prompt Analysis · Intermediate
Analyze Stockout Root Causes
Use this when you need to identify the root causes of stockouts and implement preventive measures.
Open this prompt Analysis · Intermediate
Improve Inventory Accuracy Measures
Use this when you need to enhance inventory accuracy through cycle counting, barcode systems, or RFID technology.
Open this prompt Planning · Intermediate
Demand Planning Collaboration
Use this when you need to improve communication and data sharing among stakeholders in demand planning to increase forecast accuracy and build consensus.
Open this prompt Planning · Intermediate
Optimize Demand Forecasting Accuracy
Use this when you want to improve the accuracy of your demand forecasting process by analyzing historical data and market trends.
Open this prompt Analysis · Intermediate
Calculate Optimal Safety Stock
Use this when you need to determine safety stock levels that balance service levels against holding costs, considering lead time and demand variability.
Open this prompt Analysis · Intermediate
Optimize Order Quantities
Use this when you need to determine the optimal order quantity for products by analyzing costs, demand, and service levels.
Open this prompt Analysis · Intermediate
Optimize Batch Sizes for Production
Use this when you need to determine the most efficient batch sizes for production or procurement to reduce waste and align with demand.
Open this prompt Planning · Intermediate
Assess Stockout Risk for Items
Use this when you need to evaluate the risk of stockouts for critical inventory items and develop mitigation strategies.
Open this prompt Analysis · Intermediate
Enhance Inventory Visibility Systems
Use this when you need to evaluate and implement inventory tracking technologies like barcodes or RFID to improve real-time visibility.
Open this prompt Research · Intermediate
Continuous Improvement Analysis
Use this when you need to identify inefficiencies, analyze root causes, and recommend process improvements in your supply chain operations.
Open this prompt Analysis · Intermediate