EOQ: economic order quantity with a minimum lot and volume discounts
Finds the order size at which ordering and holding costs together are lowest, tests volume price breaks, respects the minimum lot and the pack multiple, and shows annual costs and the saving against your size.
At a glance
- What question does it answer?
- In what lots to order so that ordering and holding together cost least, and whether a volume discount pays for a larger lot.
- What data is needed?
- Annual demand and the cost of one order without the goods price.
- How to read the result?
- Example on the default values: EOQ 1,200 units, but the 1,190 discount from 2,000 units wins: the recommended order is 2,000 units, 6 orders a year, annual cost RUB 14.7 million, a saving against an order of 3,000 units of RUB 112,750.
Why and how to reason
Each order costs money (processing, delivery, receiving), and each unit in the warehouse also costs money (capital, space, risk). Big orders are cheaper in orders but dearer in holding, and vice versa. The minimum of the sum of the two costs is where they are equal. This is the EOQ formula: the root of 2 × demand × cost per order ÷ (holding × price). For demand of 12,000, order cost 18,000 and holding of 25% of price 1,200: √(2 × 12,000 × 18,000 ÷ 300) = 1,200. Then 10 orders a year cost 180 thousand and holding 180 thousand. But you have discount steps: an order from 2,000 gets a price of 1,190, and that is more profitable. The calculation compares steps and finds the best order of 2,000: costs of 14.69 million against 14.80 million at your present size of 3,000, a saving of 112.8 thousand a year.
When to use it
It comes in handy for regularly replenished goods with stable demand: basic range, materials, packaging. Do not use it for a one-off seasonal buy (for that there is the critical ratio) and for fast-obsolescing goods. Assumptions: demand is even, order and holding costs are constant, shortage is not allowed, price depends only on order size. Good as a check on current practice: if your present size differs greatly from the recommended one, look for the reason rather than just change it.
How to read the result
Compare three numbers: EOQ without limits (1,200), the recommended size (2,000) and your present one (3,000). The difference shows that the discount step and the minimum lot move the optimum. The cost curve near the minimum is flat, so do not chase an exact number: an order 10 to 20% bigger or smaller costs almost nothing, and you can pick a convenient multiple. The interval between orders (61 days) and consumption during the lead time (986) are needed to plan the reorder point. The saving of 112.8 thousand a year matters, but check that the warehouse and the money will bear a bigger order.
Common mistakes
The usual mistakes: taking holding only as warehouse rent, not including the cost of money and the risk of obsolescence, not entering the whole cost of an order, ignoring discount steps, applying the formula to goods with sharp seasonality. Check order costs against the two latest orders, not by feel.
What data is needed?
- Annual demand and the cost of one order without the goods price.
- The price, the annual holding rate, the minimum lot and the pack multiple.
- Volume price breaks if the supplier gives them.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Annual demand | units/yr | 12,000 | How many units of the item sell in a year. The method does not suit seasonal goods: use a seasonal buying model. The example value is illustrative. |
| Cost of one order | ₽ | 18,000 | Everything independent of order size: freight, receiving, paperwork, buyer time. Do not include the goods price. The example value is illustrative. |
| Unit price excl. VAT | ₽ | 1,200 | The base price without volume discounts. The example value is illustrative. |
| Holding cost per year | % of price | 25 | Cost of money, storage, spoilage, insurance and obsolescence as a percentage of the unit price per year. There is no single standard: enter your own. The example value is illustrative. |
| Minimum lot | units | 500 | The supplier ships no less. Footwear, accessories and children’s have their own values: take the category data. |
| Order multiple | units | 100 | A pack or a carton: the order is rounded up to a multiple. Footwear, accessories and children’s have their own values: take the category data. |
| Your current order size | units | 3,000 | For comparing costs. May be left empty. |
| Lead time | days | 30 | For the demand over lead time. Count safety stock separately: the “Reorder point and safety stock” calculation. Optional. Empty: the field is ignored (counted as zero in sums). |
How it is calculated
| Step | Formula |
|---|---|
| Annual cost | demand × price + demand ÷ order × order cost + order ÷ 2 × holding × price |
| EOQ | √(2 × demand × order cost ÷ (holding × price)) |
| Limits | order = round up to the multiple of max(break EOQ; break start; minimum lot) |
| Choice | the break with the lowest annual cost; the price is taken at the actual order size |
| Interval | 365 × order ÷ demand |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- EOQ without discounts and limits
- 1,200 unitsThe root of 2 × demand × order cost ÷ (holding × price).
- Recommended order size
- 2,000 unitsWith the minimum lot, the multiple and the price breaks.
- Unit price at this order
- 1,190 ₽
- Orders per year
- 6
- Interval between orders
- 61 days
- Annual cost: goods, orders, holding
- 14.7 m ₽
- Ordering cost per year
- 108,000 ₽
- Holding cost per year
- 297,500 ₽
- Average stock at purchase price
- 1.19 m ₽
- Your size: annual cost
- 14.8 m ₽
- Saving against your size
- 112,750 ₽
- Demand over the lead time
- 986 unitsWithout safety stock: it is counted separately.
- Ordering
- Holding
- Ordering + holding
Data as a table
| Order size, units | Ordering | Holding | Ordering + holding |
|---|---|---|---|
| 360 | 600k | 54k | 654k |
| 562 | 384k | 84.3k | 469k |
| 764 | 283k | 115k | 397k |
| 966 | 224k | 145k | 369k |
| 1,168 | 185k | 175k | 360k |
| 1,370 | 158k | 206k | 363k |
| 1,572 | 137k | 236k | 373k |
| 1,774 | 122k | 266k | 388k |
| 1,976 | 109k | 296k | 406k |
| 2,178 | 99.2k | 327k | 426k |
| 2,380 | 90.8k | 357k | 448k |
| 2,582 | 83.7k | 387k | 471k |
| 2,784 | 77.6k | 418k | 495k |
| 2,986 | 72.3k | 448k | 520k |
| 3,188 | 67.8k | 478k | 546k |
| 3,390 | 63.7k | 509k | 572k |
| 3,592 | 60.1k | 539k | 599k |
| 3,794 | 56.9k | 569k | 626k |
| 3,996 | 54.1k | 599k | 653k |
| 4,198 | 51.5k | 630k | 681k |
| 4,400 | 49.1k | 660k | 709k |
Data as a table
| Measure | Annual cost |
|---|---|
| base price | 14.8m |
| from 2,000 | 14.7m |
| from 5,000 | 14.8m |
Price breaks: order size and annual cost
| From, units | Price | Order, units | Orders per year | Annual cost | Versus best |
|---|---|---|---|---|---|
| 0 | 1,200 ₽ | 1,200 | 10 | 14.8 m ₽ | 74,500 ₽ |
| 2,000 | 1,190 ₽ | 2,000 | 6 | 14.7 m ₽ | best |
| 5,000 | 1,170 ₽ | 5,000 | 2.4 | 14.8 m ₽ | 128,950 ₽ |
The break from 2,000 units wins: the discount pays for the larger order and its holding.
The method is for steady demand: basic lines, accessories, consumables. For seasonal collections use “How much to order under uncertain demand”. For footwear and children’s count by size: each size has its own demand.
Nuances and limits
- Applying it to seasonal collections: they have no steady demand, a seasonal buying model is needed.
- Taking the order cost together with the goods price.
- Not checking that the discount does not inflate stock: holding grows with the lot.