Warehouse management for small businesses: stock, on-hand quantities and the reorder point
In a small business the warehouse is rarely "managed". It gets watched. Someone walks along the shelves, sees that a certain material is running low, and orders more. This works as long as the same person always runs the warehouse and knows consumption by heart. Then the big job comes in, or the supplier stretches out delivery times, and production grinds to a halt over a material everyone assumed was in stock.
Warehouse management in small businesses doesn't require a complex system. It requires three things done well: knowing what is really there, knowing what is already committed, and knowing when to order. This guide explains how to build them.
In brief
- On-hand stock and availability are two different numbers. Confusing them is the most common cause of stockouts.
- Minimum stock is calculated from consumption and replenishment time, not from a gut feeling.
- The reorder point is the availability level below which you order. It is the single automation that solves the most problems.
- A warehouse kept in someone's head works with one person. With two, it drifts apart within a few weeks.
- You don't need to track everything: ABC classification tells you which items deserve control and which don't.
The three numbers that really matter
On-hand stock
It is the quantity physically present. It changes only with real movements: goods come in, on-hand stock goes up; goods go out, it goes down. Nothing else touches it.
On-hand stock is the number you verify with the physical count. If the system says 340 and there are 315 on the shelf, you have a discrepancy to explain, and the causes are almost always the same: unrecorded waste, urgent withdrawals made without paperwork, counting errors at goods-in.
Availability
It is on-hand stock minus the quantities committed to confirmed orders and open jobs, plus any quantities inbound on supplier orders already placed.
A concrete example. You have 500 sheets in the warehouse. A confirmed job needs 400 of them. On-hand stock is 500, availability is 100. If the salesperson looks at on-hand stock and confirms another job for 300 sheets, they have just promised the customer material that isn't there.
This distinction is the main reason a spreadsheet isn't enough. The spreadsheet knows the on-hand stock. The committed quantities live in the orders, which sit elsewhere.
Average consumption
How much you use over a period. It is the figure that feeds everything else, and the only one that needs a bit of history to be reliable. Three months of movements are the minimum, six are better, and they should be cleaned of exceptional jobs that would skew the average.
How to calculate minimum stock
The formula is simple; what requires attention are the inputs.
Minimum stock = (average daily consumption × lead time in days) + safety stock
Average daily consumption. Consumption over the period divided by the working days in the period. If you used 12,000 sheets over 60 working days, consumption is 200 per day.
Lead time. The days between placing the order and the material actually being available. Not the days the supplier quotes: the real ones, measured on recent orders. They are almost always longer.
Safety stock. The buffer that absorbs variability. A practical rule of thumb, good enough for most small businesses:
| Situation | Safety stock |
|---|---|
| Steady consumption, reliable supplier | 15-20% of consumption during lead time |
| Variable consumption or unreliable supplier | 30-40% |
| Critical item that halts production | 50% or more |
| Item easily sourced elsewhere | even 0 |
With 200 sheets a day, a 10-day lead time and 30% safety stock: (200 × 10) + 600 = 2,600 sheets of minimum stock.
The reorder point
The reorder point is the availability level below which the order is triggered. Numerically it coincides with the minimum stock just calculated: when availability drops to 2,600, you order.
What makes the difference is that it is checked automatically. A reorder point written on a card no one looks at is useless. A system that flags the items below threshold turns replenishment from a reactive activity ("we noticed we're out") into a planned one.
The benefit isn't only avoiding stoppages. It is no longer buying in a hurry, which is the most expensive way to buy: worse prices, sub-optimal quantities, express shipping.
How much to order
The reorder point tells you when. The economic order quantity tells you how much. Without getting into the Wilson formula, the practical criteria for a small business are:
- The supplier's quantity break: it is often worth moving up to the next tier if the discount exceeds the cost of tying up capital.
- One or two months of consumption, as a reasonable starting rule.
- Physical constraints: full pallets, minimum formats, available space.
- Perishability: materials with an expiry date or substrates that yellow shouldn't be stockpiled.
ABC classification: where to focus control
Not all items deserve the same effort. The rule of thumb says that a minority of item codes accounts for the majority of the value moved.
| Class | Share of codes | Share of value | How to manage it |
|---|---|---|---|
| A | ~20% | ~80% | Calculated reorder point, frequent checks, close relationship with the supplier |
| B | ~30% | ~15% | Indicative reorder point, periodic checks |
| C | ~50% | ~5% | Generous stock, reorder on sight, no calculation |
The practical takeaway: if you have 400 item codes in the warehouse, the codes worth calculating minimum stock and reorder point for are maybe 80. For the rest, keep a generous stock and don't think about it. This is the opposite of what many companies do when they introduce a warehouse system, namely trying to track everything at the same level of detail and giving up after three weeks.
Goods in, goods out and the discipline problem
A warehouse works if movements get recorded. It sounds obvious, and it is exactly the point where almost every project runs aground.
Goods in. When goods arrive, against the delivery note. The rule is to record the counted quantity, not the one written on the document. If they don't match, the discrepancy must be reported to the supplier straight away.
Goods out. When material is picked for production. It is the movement that gets skipped most often, because when there's a rush people grab the material and record it "later". Later almost never comes.
Two measures that work better than any reminder:
- Automatic goods-out from the job. If the system knows that job consumes 2,400 sheets of that substrate, goods-out can happen on confirmation or as work progresses, without anyone having to remember it.
- Recording where the movement happens. If recording goods-out means crossing the shop floor and switching on a PC, it won't get done. If it can be done from a phone or a tablet next to the shelf, it gets done.
Adjustments. Discrepancies should be recorded as adjustments with a reason code, not silently corrected. The recurring reason codes are the diagnosis of the problem: if waste adjustments are systematic, the theoretical consumption is wrong and needs correcting at the quoting stage, where it is doing far greater damage. The link between real consumption and price is the subject of how to calculate the margin on a job.
Stocktaking: once a year isn't enough
The annual physical inventory serves accounting purposes, but as a control tool it arrives too late: in December you discover a discrepancy that started in March, and reconstructing its cause is impossible.
The alternative is cycle counting: you check a few codes at a time, every week, giving priority to class A. Over a year the whole warehouse has been covered, discrepancies are caught within a few weeks of when they arise, and you never shut operations down for two days.
When the spreadsheet is no longer enough
Excel handles on-hand stock well. It struggles on three fronts.
Committed quantities. They require the link between warehouse and orders. In a spreadsheet that means manually updating a column at every order confirmation, and no one keeps that up for long.
Concurrency. Two people working the same file produce conflicts or copies. The same dynamics described in managing quotes with Excel apply identically to the warehouse.
Real time. The salesperson on the phone with the customer needs to know right now whether the material is there. A spreadsheet updated at the end of the day answers the wrong question.
The deciding test is practical: if stockouts have become a recurring problem, or if someone has promised a customer material that wasn't there, the spreadsheet has run its course.
Where to start, in order
- Export the last six months of movements and classify the codes into A, B, C by value moved.
- For the A codes, measure the suppliers' real lead time on recent orders.
- Calculate average consumption, minimum stock and reorder point for those codes only.
- Do a full physical inventory so you start from true on-hand quantities.
- Define who records movements and with what tool, before switching on any software.
- Turn on the low-stock alerts and let them work for a month before adding anything else.
Step five is the one that decides the outcome. A warehouse system never fails because of technical limits: it fails because movements stop being recorded.
FAQ
What is the difference between on-hand stock and availability?
On-hand stock is the quantity physically present in the warehouse. Availability is on-hand stock minus the quantities already committed to confirmed orders, plus any quantities inbound from suppliers. Decisions are made on availability; the inventory count is done on on-hand stock.
How is minimum stock calculated?
You multiply the average daily consumption by the supplier's replenishment time, and add a safety stock proportional to the variability of consumption and to the reliability of the supplier.
What is the reorder point formula?
Reorder point = (average daily consumption × lead time in days) + safety stock. When availability falls below this value, the replenishment order is placed.
Do I need warehouse software if I have only a few items?
If you have a few dozen items, they rarely change and a single person handles them, a well-kept spreadsheet can be enough. Software becomes necessary when you need the quantities committed to orders, when several people move stock, or when stockouts start to halt production.