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.

Back to 5.6 Production planning

Status
Enrichment, beyond the syllabus
Worked example
Wrenhurst Cycles' gear sets, a fictional example

Section 01: How to use it

  1. 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.

  2. Enter the order size you use now, or one you are considering, to see what it costs a year beside the EOQ.

  3. 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.

  4. 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

Source: Enrichment Enrichment, beyond the syllabus

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.

Your changes are kept in this browser, on this device only.

The figures
Administration, delivery and checking, whatever the order size.
Storage, insurance, losses and the cash tied up.
Adds the same holding cost at every order size.
A quantity discount

This is the worked example. With JavaScript on, you can enter your own figures.

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.

Yearly cost against order quantityYearly ordering cost falls and the yearly cost of holding the stock each order brings rises as the order quantity grows; they are equal, and their total is lowest, at the economic order quantity of 800 gear sets, $3,000 a year. Order sizes from 584 to 1,096 cost no more than 5% above that. The order size entered, 1,200, costs $3,200 a year. The total includes $600 a year for holding the buffer, the same at every order size.$0$2,000$4,000$6,00005001,0001,5002,0002,500Within 5% of the lowest costOrderingHoldingTotalEOQ 800Yours: 1,200, $3,200Order quantity (gear sets)Cost a year
Chart Ordering cost falls and the cost of holding the stock each order brings rises with the order size; they cross at the EOQ, where the total is lowest. The total also includes holding the buffer, the same at every order size. The green band is every order size within 5% of the lowest cost. Simulated teaching data.
Order quantity Orders a year Weeks between orders Ordering Holding, with the buffer Total
20050.01.0$4,800$900$5,700
40025.02.0$2,400$1,200$3,600
60016.73.0$1,600$1,500$3,100
800 EOQ12.54.0$1,200$1,800$3,000
1,00010.05.0$960$2,100$3,060
1,200 Yours8.36.0$800$2,400$3,200
1,6006.38.0$600$3,000$3,600
2,0005.010.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