How to reorder stock from your sales data
Reorder from sales by deciding how many days of sales an order should cover, working out daily sales from a recent period, and subtracting the stock you have and what is already on its way. Then round up to the supplier's pack size, and leave one-off bulk orders out of the history so they do not inflate the result.
The basic calculation
Example, with made-up round numbers: you sell about 30 units a week of a product, about 4 a day. You want this order to last 30 days, so you need about 120 units. You have 40 on the shelf and 20 already ordered. You order 120 − 40 − 20 = 60.
That is all reordering from sales really is. The rest of this guide is about getting each of those numbers right.
Days of cover
Days of cover is how long the order should last. It depends on how long the supplier takes to deliver, how often you place orders with them, and how much cash you want tied up in stock. A supplier who delivers in two days and takes orders every week needs less cover than one who ships from abroad once a month.
More cover is not free. Stock on the shelf is money you have already spent, it takes up bins, and some of it will go out of fashion or out of date. Start with a cover close to the time between two orders to the same supplier, plus the delivery time, and adjust once you see how often you run short.
Choosing the sales period
The period you calculate from decides what "normal sales" means. A short period, such as the last 7 or 14 days, reacts quickly to change but jumps around. A longer one, such as 60 or 90 days, is steadier but slow to notice a product taking off or fading.
For seasonal products, look at the same period last year, not the last few weeks. Selling few garden hoses in winter says little about spring.
Minimum and recommended stock levels
Set two levels per product. The minimum stock is the point at which you must reorder: roughly what you sell while waiting for a delivery, plus a little safety stock. The recommended level is where you want to be after the delivery arrives. When stock falls to the minimum, order enough to get back to the recommended level.
Review the levels for your best sellers every few months. Levels set when a product was new are often wrong a year later.
Pack sizes and one-off orders
Suppliers sell in cases, cartons or pallets. If the calculation says 60 and the case holds 24, you order 72, not 60. Round up rather than down for best sellers; round down for slow ones if you can live with ordering sooner.
One large order can distort everything. Say a company buys 200 units once for an event. Left in the history, it makes the product look ten times more popular for months, and you reorder far too much. Leave such sales out of the calculation.
- Products with no supplier assigned cannot be reordered automatically; find and fix them.
- Only count stock on its way when the supplier has confirmed it.
- One buyer per supplier, or a shared draft, stops two people ordering the same goods.