When a product has reached its reorder point, you have to decide how much to order. If you order a little at a time, you have to order often. If you order a lot, it ties up money and space. A few fixed rules help.
Base quantity: sales during the order cycle
The simplest rule is to order what will sell until the next order, plus what is missing to reach the safety stock:
Quantity = sales during (lead time + order cycle) + safety stock − available stock
If you order from the supplier every 60 days and the product sells 2.6 units a day, an order has to cover about 156 units beyond the lead time.
Economic order quantity (EOQ)
EOQ finds the quantity at which the cost of ordering and the cost of holding the product are lowest combined:
EOQ = √(2 × D × S / H)
Dis annual sales in units.Sis the cost per order, e.g. time for ordering and receiving, plus freight.His the holding cost per unit per year, typically 20 to 30% of the cost price.
A product sells 1,200 units a year, an order costs 300 DKK, and the cost price is 80 DKK with a 25% holding cost (20 DKK per unit per year):
√(2 × 1,200 × 300 / 20) = √36,000 = 190 units
EOQ assumes even sales, so it suits X products best (see ABC/XYZ). For seasonal products it is probably better to use the base quantity above with the seasonal forecast.
Case sizes and minimum quantities
The supplier often only sells in whole cases or from a minimum quantity. The quantity is then rounded up:
- Quantity 156 units and a case size of 24: 7 cases = 168 units.
- Minimum quantity 200 units: then it is 200, whatever the calculation says.
If the minimum quantity is much higher than what sells in one cycle, it is worth calculating how long the products will sit. 200 units of a product that sells 20 a month is 10 months of stock.
Minimum order per supplier
Many suppliers have a minimum order value or free freight above an amount. When an order is just below the limit, you can top it up with products that need to be ordered soon anyway, instead of ordering extra of what is already on the order. Sort by when the products would otherwise have to be ordered, and add the first ones until the limit is reached.
Volume discount
If the supplier gives a discount from e.g. 500 units, compare:
- The saving: number of units × discount per unit.
- The cost: the extra units × cost price × holding cost × the extra time they sit in stock.
The discount is probably only worth taking if the products sell while the discount is still larger than the holding cost. For products with uncertain sales, the risk of overstock is often greater than the discount.
Order suggestions in lesslater
lesslater rounds suggestions up to minimum quantities and case sizes, takes incoming goods and volume discounts into account, and collects the suggestions in one order per supplier. If the order is below the supplier’s minimum order, it is topped up with the products that need to be ordered first anyway.