Reorder points from your own sales
When to reorder is a calculation, not a feeling. Work it out from how fast you sell and how long your supplier takes, then let the reorder list do the remembering.
The cost of guessing
Reorder too late and you tell a customer to come back next week. Reorder too early, or too much, and your cash sits on a shelf. Most owners reorder when a shelf looks empty, which is usually a few days too late for anything the supplier doesn’t keep in stock.
The formula
A reorder point is the stock level at which you place the next order. It covers what you will sell while you wait for the supplier, plus a cushion for a bad week.
Reorder point = average daily sales × supplier lead time + safety stock.
Say you sell 12 paint rollers a day on average, and your supplier delivers 5 days after you order. You will sell 60 while you wait. Add 2 days of safety stock, 24 rollers, and the reorder point is 84. When stock drops to 84, you order.
Where the numbers come from
Use your own history, not the supplier’s promises. Four numbers are enough.
- Average daily sales: take the quantity delivered over the last 90 days and divide by 90. Use deliveries, not orders, because that is what actually left the shelf.
- Lead time: count the days from your purchase order to the receipt for the last few orders from that supplier. Use the slower ones, not the best case.
- Safety stock: start with 2 or 3 days of sales. Raise it for items you can’t afford to run out of, and lower it for slow, expensive items.
- Season: recalculate before Ramadan, the school season or the summer if your sales change with them.
How much to order
The reorder point says when. The maximum says how much. Set a maximum you are comfortable holding, often two to four weeks of sales. For the rollers, four weeks at 12 a day is about 340. Order the difference between the maximum and what you have.
If the supplier sells by the carton of 24, round up to full cartons. With 84 on hand, the gap to 340 is 256 rollers, which is 10.7 cartons, so you order 11.
Setting it up in Ignitix Inventory
Reorder rules come with every plan, Starter included. Each rule is set per item and per warehouse: a minimum (your reorder point), a maximum, and an order multiple such as 24 for a carton. Each item also keeps its preferred vendor and its lead time in days.
The reorder list shows every item that has fallen to its minimum or below and suggests the quantity that brings it back to the maximum, rounded to the multiple. You review it and raise purchase orders for what you need.
Check the rules every quarter. A reorder point is only as good as the sales and lead times behind it.
Examples are illustrative and use fictional businesses. Costing and tax treatment depend on your circumstances; your accountant can help apply them to your business.