Prompt · Operation Managers
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.
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.
Prompt
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%"
Follow-up prompts
- How would the reorder point change if lead time increased to 10 days?
- What safety stock level corresponds to a 99% service level?
- Can you show a sensitivity analysis for different demand variability levels?