Skip to content
PromptNewFinanceConsulting

EOQ Optimizer

Written in-house · editorially graded

Every SkillsBank offering is written in-house — never scraped or crowd-sourced — and graded against a fixed editorial rubric in a separate grading step.

Dry-run test passed · Aug 16, 2026

Editorially graded · Aug 16, 2026

Given an item’s current stock, weekly usage, lead time, and unit cost, returns the optimal reorder quantity using Economic Order Quantity (EOQ) and safety‑stock calculations. Use when you need a quick, data‑driven reorder amount for any cleaning supply. Deliverable: Markdown table listing each item with recommended reorder quantity, safety stock, and total cost (≈10 rows). Inputs: For each item: current quantity, average weekly usage, supplier lead time (weeks), unit price, optional holding‑cost %. Rigor: Implements EOQ formula: sqrt((2 × D × S) / H) where D = annual demand, S = ordering cost (default $5), H = holding cost (unit price × holding‑cost %), plus safety stock = usage × lead time × 1.2. Edge: Delivers precise EOQ‑based reorder figures instantly, which a simple prompt cannot compute accurately without embedded formulas and domain‑specific parameters.

What you get

A ready-to-paste prompt you can drop into your AI.

Works in
Claude · ChatGPT · Gemini
Paste it in, fill the [brackets]
Any AI assistant
Works anywhere you can paste text

See it in action

A real input → output sample

Example Input
Here's my inventory list. Can you tell me what to reorder?

| Item | Current Stock | Avg Weekly Usage | Lead Time (wks) | Unit Cost |
|------|--------------|------------------|-----------------|-----------|
| Widget A | 120 | 30 | 2 | $2.50 |
| Widget B | 80 | 15 | 3 | $4.00 |
| Widget C | 200 | 50 | 1 | $1.20 |
| Widget D | 60 | 10 | 2 |  |
| Widget E | 0 | 5 | 4 | $8.00 |

I think our ordering cost is around $5 per order.
Example Output
**Reorder Recommendations**

| Item | Current Stock | Avg Weekly Usage | Lead Time (wks) | Unit Cost | EOQ | Safety Stock | Reorder Point | Action | Order Qty | Total Annual Cost |
|------|--------------|------------------|-----------------|-----------|-----|-------------|---------------|--------|-----------|-------------------|
| Widget E | 0 | 5 | 4 | $8.00 | 40 | 24 | 44 | Reorder now | 41 | $2,144.51 |
| Widget B | 80 | 15 | 3 | $4.00 | 99 | 54 | 99 | Reorder now | 99 | $3,198.99 |
| Widget A | 120 | 30 | 2 | $2.50 | 177 | 72 | 132 | Reorder now | 177 | $3,988.32 |
| Widget C | 200 | 50 | 1 | $1.20 | 329 | 60 | 110 | Not yet | — | $3,198.99 |
| Widget D | 60 | 10 | 2 | — | — | 24 | 44 | Insufficient data — cost missing | — | — |

**Assumptions Used**
- Ordering cost (S): $5.00 per order (default, confirmed by user's "$5 per order" note)
- Holding-cost rate: 20% of unit cost annually (default)
- Safety-stock factor: 1.2× weekly usage × lead time (default)
- TAC basis: "Reorder now" rows use the actual rounded order quantity; "Not yet" rows use the unrounded theoretical EOQ (Q*) for TAC since no order is being placed yet

**Note**
Needs input: 1 item(s)
- Widget D: unit cost is missing — EOQ, order quantity, and total annual cost cannot be computed. ROP and safety stock are shown from available stock, usage, and lead-time data. Provide a unit cost to complete this row.

Related