Syntha Lab RU

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.

Working with stock: transfers, top-up, defects, prices, order entry For whom: Buyers and logisticians for steady items: basic lines, accessories, consumables.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Annual demandunits/yr12,000How 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,000Everything 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,200The base price without volume discounts. The example value is illustrative.
Holding cost per year% of price25Cost 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 lotunits500The supplier ships no less. Footwear, accessories and children’s have their own values: take the category data.
Order multipleunits100A 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 sizeunits3,000For comparing costs. May be left empty.
Lead timedays30For 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

StepFormula
Annual costdemand × price + demand ÷ order × order cost + order ÷ 2 × holding × price
EOQ√(2 × demand × order cost ÷ (holding × price))
Limitsorder = round up to the multiple of max(break EOQ; break start; minimum lot)
Choicethe break with the lowest annual cost; the price is taken at the actual order size
Interval365 × 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 and holding cost by order size (base price)
Line chart: Ordering: 600k → 49.1k; Holding: 54k → 660k; Ordering + holding: 654k → 709k0200k400k600k800k1,0002,0003,0004,000EOQOrdering, 360: 600kOrdering, 4400: 49.1kHolding, 360: 54kHolding, 4400: 660kOrdering + holding, 360: 654kOrdering + holding, 4400: 709k₽Order size, units
  • Ordering
  • Holding
  • Ordering + holding
Data as a table
Order size, unitsOrderingHoldingOrdering + holding
360600k54k654k
562384k84.3k469k
764283k115k397k
966224k145k369k
1,168185k175k360k
1,370158k206k363k
1,572137k236k373k
1,774122k266k388k
1,976109k296k406k
2,17899.2k327k426k
2,38090.8k357k448k
2,58283.7k387k471k
2,78477.6k418k495k
2,98672.3k448k520k
3,18867.8k478k546k
3,39063.7k509k572k
3,59260.1k539k599k
3,79456.9k569k626k
3,99654.1k599k653k
4,19851.5k630k681k
4,40049.1k660k709k
Annual cost by price break
Bar chart: base price 14.8m, from 2,000 14.7m, from 5,000 14.8m05m10m15mbase pricebase priceAnnual cost: 14.8m14.8mfrom 2,000from 2,000Annual cost: 14.7m14.7mfrom 5,000from 5,000Annual cost: 14.8m14.8m₽
Data as a table
MeasureAnnual cost
base price14.8m
from 2,00014.7m
from 5,00014.8m

Price breaks: order size and annual cost

From, unitsPriceOrder, unitsOrders per yearAnnual costVersus best
01,200 ₽1,2001014.8 m ₽74,500 ₽
2,0001,190 ₽2,000614.7 m ₽best
5,0001,170 ₽5,0002.414.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.

Terms used

Calculate on your data →