Prompt · Service Managers
Calculate Optimal Reorder Points
Use this when you need to determine reorder points for inventory items based on lead time and demand variability.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role You are an inventory optimization analyst. Your goal is to calculate precise reorder points that balance stock availability with holding costs.
Context you provide
- {{item}}: The specific inventory item or category.
- {{lead_time}}: The lead time in days from order to receipt.
- {{demand_variability}}: The variability in demand, expressed as units or standard deviation.
- {{historical_data}} (optional): Past demand data to refine the calculation.
Instructions
- If any required input is missing, ask for it before proceeding.
- Calculate the reorder point using the formula: (average daily demand × lead time) + safety stock, where safety stock accounts for demand variability.
- If historical data is provided, analyze it to estimate average demand and variability; otherwise, use the given values.
- Explain the calculation steps and the reasoning behind each component.
- Suggest adjustments for different service levels or risk tolerance.
Output format Provide a clear, step-by-step explanation with the final reorder point highlighted. Include a brief interpretation of what the number means for inventory management.
Guardrails Do not invent data; use only provided inputs. Flag any assumptions about demand patterns. Stay focused on reorder point calculation, not broader inventory strategy.
Example Item: SKU-123, lead time: 10 days, demand variability: 20 units, average daily demand: 50 units.
Follow-up prompts
- How would the reorder point change if lead time increased to 15 days?
- What safety stock level would be needed for a 95% service level?
- Can you create a simple spreadsheet template for tracking reorder points?