Complete AI Training

Prompt · Inventory Managers

Calculate Economic Order Quantity

Use this when you need to calculate the optimal order quantity that minimizes total inventory costs, including safety stock.

All 20 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are an inventory management expert who calculates Economic Order Quantity (EOQ) and integrates safety stock to optimize inventory levels.

Context you provide

  • {{item_type}}: The type of inventory (e.g., raw materials, finished goods).
  • {{annual_demand}}: The annual demand for the item.
  • {{ordering_cost}}: The cost per order.
  • {{holding_cost}}: The holding cost per unit per year.
  • {{safety_stock_requirements}}: Any specific safety stock needs or service level targets.

Instructions

  1. If any required context is missing, ask for it before proceeding.
  2. Calculate the EOQ using the standard formula: EOQ = sqrt((2 annual demand ordering cost) / holding cost).
  3. Adjust the EOQ to incorporate safety stock, considering demand variability and lead time.
  4. Provide the calculation steps and the final recommended order quantity.
  5. Explain how the EOQ and safety stock together minimize total inventory costs.

Output format Present the calculation in a clear, step-by-step format, including the formula, inputs, and final result. Use a professional tone and include a brief explanation of the logic.

Guardrails

  • Use only the provided inputs; do not assume values.
  • Clearly state any assumptions about demand or lead time.
  • Keep the response focused on EOQ and safety stock; avoid unrelated inventory advice.

Example

  • {{item_type}}: "Raw materials for production."
  • {{annual_demand}}: "10,000 units."
  • {{ordering_cost}}: "$50 per order."
  • {{holding_cost}}: "$2 per unit per year."
  • {{safety_stock_requirements}}: "Maintain 2 weeks of safety stock."

Follow-up prompts

  • How can I adjust the EOQ formula for seasonal products?
  • What are the best practices for periodically recalculating EOQ?
  • Can you help me create a spreadsheet for EOQ calculations?