Inventory valuation: the number that decides your profit
How stock is valued changes reported profit and tax without anything physical changing. FIFO against weighted average, what cost includes, and the write-down nobody wants to make.
A reorder point is the stock level at which you order more. How to calculate it from lead time and usage, how much buffer to add, and why one number per item is not enough.
A reorder point is the level at which an item has to be ordered so that the new stock arrives before the old runs out. It is the most useful piece of arithmetic in a stockroom and almost nobody calculates it — ordering happens when a shelf looks empty, which means it happens too late by exactly the length of the supplier's lead time.
Enough to cover the variation you actually see, not the worst case you can imagine. The honest way to size it is to look at the spread in your own history: if lead time is usually ten days but has twice been eighteen, the buffer needs to cover eight days of usage rather than a round guess. Buffer is cash sitting on a shelf, so it belongs where running out is expensive — items that stop production, items with a long lead time, items a customer will not wait for — and not spread evenly across everything in the room.
Use your measured lead time, never the quoted one. Suppliers quote their intention and deliver their history, and the gap between the two is where stockouts live. Three or four past orders are enough to see the difference.
Because demand is often seasonal and lead times move. A reorder point set in a quiet month will leave you short in the busy one, which is the commonest failure of a system that was correct when somebody built it. Either review the numbers each quarter for the items that matter, or set a seasonal pair for the handful where the swing is large. The rest can sit on an annual review, because for most items being slightly wrong costs nothing.
Ettex Sheets holds the usage, lead time, buffer and resulting level per item, so the list of things to order today is a filter rather than a walk round the stockroom. The stock figure itself has to come from counting, and a rolling count keeps it honest without closing anything down.
Average daily usage multiplied by lead time in days, plus a buffer for variation in both. Use lead times measured from your own order history.
Sized to the variation you have actually experienced, and concentrated on items where running out is expensive rather than spread evenly.
Quarterly for items that matter, annually for the rest, and immediately when a supplier or usage pattern changes.
How stock is valued changes reported profit and tax without anything physical changing. FIFO against weighted average, what cost includes, and the write-down nobody wants to make.
Staff turnover is easy to calculate and easy to misread. How to work it out, why voluntary and involuntary must be separated, and what a replacement actually costs.
Business interruption cover replaces lost profit while you cannot trade. How the sum insured is calculated, why the indemnity period is the number that matters, and what is usually excluded.