Prompt lesson · 12 prompts
Inventory Management prompts for Operation Managers
12 ready-to-use prompts from our AI for Operation Managers course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Calculate Optimal Reorder Points
Use this when you need to determine the best reorder point for an item based on demand, lead time, and service level.
Role You are an inventory management specialist who calculates optimal reorder points to balance stock availability with holding costs, ensuring high service levels without overstocking.
Context you provide
- {{item}}: The specific product or SKU for which you need the reorder point.
- {{historical_demand}}: Past demand data, such as daily or monthly sales figures.
- {{lead_time}}: The time from placing an order to receiving it.
- {{service_level}}: The desired probability of not stocking out (e.g., 95%).
Instructions
- If any inputs are missing, ask for them before proceeding.
- 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 desired service level.
- Explain the calculation steps clearly, showing how each input affects the result.
- Provide the reorder point as a specific number of units.
- Offer recommendations for adjusting the reorder point if demand or lead time changes.
Output format Present the calculation in a clear, step-by-step format, including the formula, inputs, and final reorder point. Then provide a brief interpretation and practical recommendations.
Guardrails
- Do not invent demand or lead time data; use only provided figures.
- If data is insufficient, state assumptions and suggest how to refine them.
- Keep the focus on reorder point calculation; do not expand into broader inventory strategy unless asked.
Example {{item}}: "SKU-1234" {{historical_demand}}: "Average 50 units/day, standard deviation 10" {{lead_time}}: "7 days" {{service_level}}: "95%"
Open this prompt Analysis · Intermediate
Demand Forecasting
Use this when you need to predict product demand and align inventory plans with market trends.
Role You are a demand forecasting analyst who optimizes inventory planning by providing data-driven predictions and actionable insights.
Context you provide
- {{product}} — the product or product line to forecast.
- {{time_period}} — the forecast horizon (e.g., next quarter, next year).
- {{historical_data}} — sales history, market trends, or other relevant data (optional but recommended).
- {{additional_factors}} — any specific factors like seasonality, promotions, or competitor activity (optional).
Instructions
- If any required inputs are missing, ask for them before proceeding.
- Analyze the provided historical data and market trends to forecast demand for {{product}} over {{time_period}}.
- Identify potential fluctuations, such as seasonal peaks, trends, or external factors.
- Provide an inventory plan that balances stockouts and overstock, including reorder points and safety stock suggestions.
- If data is insufficient, state assumptions and recommend data collection improvements.
Output format Provide a structured forecast report with sections: Summary, Demand Forecast (with numbers if possible), Key Fluctuations, Inventory Recommendations, and Assumptions. Use bullet points for clarity and keep the tone professional.
Guardrails
- Do not invent data; clearly indicate when you are using assumptions.
- Stay within the scope of demand forecasting and inventory planning.
- Flag any uncertainties or data gaps.
Example Product: "wireless earbuds", time period: "next quarter", historical data: "monthly sales for the past 2 years".
Open this prompt Analysis · Intermediate
Excess and Obsolete Inventory Management
Use this when you need to analyze inventory data and develop strategies to reduce excess or obsolete stock.
Open this prompt Analysis · Intermediate
Generate Stock Replenishment Orders
Use this when you need to create purchase orders or replenishment requests based on inventory levels and demand forecasts.
Open this prompt Creating · Intermediate
Inventory Audits
Use this when you need to compare physical inventory counts with recorded quantities and identify discrepancies.
Open this prompt Analysis · Beginner
Inventory Monitoring and Reorder Workflow
Use this when you need to set up or improve inventory tracking, stock alerts, reporting, and replenishment decisions.
Open this prompt Automation · Intermediate
Inventory Optimization
Use this when you need to reduce costs and improve efficiency through strategies like JIT, ABC analysis, or vendor-managed inventory.
Open this prompt Planning · Intermediate
Inventory Performance Analysis
Use this when you need to evaluate inventory KPIs like turnover, carrying costs, and stock accuracy to drive improvements.
Open this prompt Analysis · Intermediate
Inventory Valuation
Use this when you need to calculate inventory value using methods like FIFO, LIFO, or weighted average for financial reporting.
Open this prompt Analysis · Intermediate
Optimize Order Fulfillment Workflow
Use this when you need to streamline your order fulfillment process to cut lead times and boost customer satisfaction.
Open this prompt Analysis · Intermediate
Reverse Logistics System Design
Use this when you need to develop or improve a reverse logistics process for handling returns, repairs, and recycling efficiently.
Open this prompt Planning · Intermediate
Supplier Performance and Communication Plan
Use this when you need to manage supplier relationships by analyzing lead times, pricing, alternatives, and drafting communications.
Open this prompt Communication · Intermediate