Operations Floor: Calculator
Economic order quantity calculator (enrichment)
Order often in small batches and the cost of ordering mounts; order rarely in large ones and the cost of holding stock mounts instead. The economic order quantity is the batch size that balances the two. Enter your figures and the calculator finds it, shows what a different order size would cost, and checks whether a supplier's quantity discount is worth taking.
Section 01: How to use it
-
Enter the yearly demand, the cost of placing one order and the cost of holding one unit for a year. The calculator finds the economic order quantity at once.
-
Enter the order size you use now, or one you are considering, to see what it costs a year beside the EOQ.
-
Add any buffer stock, and switch on a supplier's quantity discount to see whether buying in bigger batches pays once the price is included.
-
Read the chart, the table of order sizes and the working. Your figures are kept on this device; download them as JSON or CSV, or print the page.
Where it sits in the course. Not part of the IB course. Subtopic 5.6 (HL only) names the reorder quantity on a stock control chart but gives no method for choosing it (guide, p. 35), and the guide's list of formulas has no economic order quantity. The model comes from operations management and is here for interest and for university and professional study. The IB does not assess it.
Calculator
Wrenhurst Cycles' gear sets, a fictional example
Wrenhurst uses 10,000 gear sets a year, 200 in each of 50 working weeks, as in the notes on production planning. Each order costs $96 and each gear set $3 a year to hold. Its buyer is weighing orders of 1,200, and the supplier offers 2% off orders of 2,000 or more. Every figure is simulated.
The tool could not start in this browser. Everything below is the worked example as it was prepared, with its results.
The result
- Economic order quantity
- 800gear sets
- Orders a year
- 12.5one about every 4.0 weeks
- Cost a year at the EOQ
- $3,000ordering and holding
- Cost a year at your quantity
- $3,200$200 more
- Taking the discount
- $4,920saved a year, price included
Reading. The economic order quantity is 800 gear sets: 12.5 orders a year, one about every 4.0 weeks. At that size the yearly cost of ordering ($1,200) equals the cost of holding the stock each order brings ($1,200). The buffer adds $600 a year whatever the order size, for a total of $3,000. Ordering 1,200 at a time costs $3,200 a year, $200 (6.7%) more.
Implication. Any order between 584 and 1,096 gear sets costs no more than 5% above the lowest, so the answer is less exact than the formula suggests. Including the price paid, taking the discount (orders of 2,000) saves $4,920 a year: the lower price outweighs the extra cost of holding stock, which the EOQ formula alone would miss.
| Order quantity | Orders a year | Weeks between orders | Ordering | Holding, with the buffer | Total |
|---|---|---|---|---|---|
| 200 | 50.0 | 1.0 | $4,800 | $900 | $5,700 |
| 400 | 25.0 | 2.0 | $2,400 | $1,200 | $3,600 |
| 600 | 16.7 | 3.0 | $1,600 | $1,500 | $3,100 |
| 800 EOQ | 12.5 | 4.0 | $1,200 | $1,800 | $3,000 |
| 1,000 | 10.0 | 5.0 | $960 | $2,100 | $3,060 |
| 1,200 Yours | 8.3 | 6.0 | $800 | $2,400 | $3,200 |
| 1,600 | 6.3 | 8.0 | $600 | $3,000 | $3,600 |
| 2,000 | 5.0 | 10.0 | $480 | $3,600 | $4,080 |
The working
- Given
- Annual demand (D): 10,000 gear sets
- Cost per order (S): $96
- Holding cost per gear set per year (H): $3
- Formula
- EOQ = √(2 × D × S ÷ H)
- Substitution
- = √(2 × 10,000 × 96 ÷ 3)
- Working
- 2 × 10,000 × 96 = 1,920,000÷ 3 = 640,000√640,000 = 800.00
- Answer
- 800 gear sets
Enrichment: the guide gives no formula for the reorder quantity. At the EOQ the yearly cost of ordering equals the yearly cost of holding the stock each order brings; holding any buffer costs extra, the same at every order size.
- Unit
- gear sets per order
- Interpretation
- The economic order quantity is 800 gear sets: 12.5 orders a year, one about every 4.0 weeks. At that size the yearly cost of ordering ($1,200) equals the cost of holding the stock each order brings ($1,200). The buffer adds $600 a year whatever the order size, for a total of $3,000. Ordering 1,200 at a time costs $3,200 a year, $200 (6.7%) more.
- Business implication
- Any order between 584 and 1,096 gear sets costs no more than 5% above the lowest, so the answer is less exact than the formula suggests. Including the price paid, taking the discount (orders of 2,000) saves $4,920 a year: the lower price outweighs the extra cost of holding stock, which the EOQ formula alone would miss.
Section 02: What it leaves out
Every model simplifies. Say so in an answer, and say what else you would want to know.
- The formula assumes demand is steady and known, each order costs the same whatever its size, holding costs rise in proportion to stock, each order arrives complete and stock never runs out. Few businesses meet all five.
- It ignores quantity discounts, which is why the discount check adds the price paid; even then, it treats the holding cost of a unit as fixed when the price changes.
- Lead time and buffer stock do not change the EOQ. The lead time sets when to reorder, and the buffer adds the same holding cost at every order size.
- The answer is less exact than it looks. Order sizes well away from the EOQ cost little more, so practical limits such as pack sizes, storage space and cash often decide the final figure.
Section 03: Read and practise next
Arjun Agrawal | The Business Brief, https://the-business-brief-dun.vercel.app/operations-floor/economic-order-quantity/. Original teaching material, not an IB publication. The organizations in the teaching cases are fictional unless a case says otherwise.