Inventory management is how a business decides what goods to buy, when and how many, keeps track of them while they wait on the shelf, and knows what they cost when they are sold. The aim is simple to say: enough stock to serve every customer, and no more cash in stock than that.
Buy → receive → record → count → cost → measureAny business selling and storing physical goods must manage inventory in one way or another. Inventory is often the largest part of a small business's working capital, so every extra box on the shelf is money that cannot pay a bill.
Inventory management all comes down to balance. Too much stock ties up cash and space, and some of it never sells: a major source of obsolete inventory is excessive buying. Too little stock means empty shelves, lost sales and customers who try another shop. One of the main reasons for having inventory is to satisfy customer demand in a timely way. Good inventory management does both: it removes the risk of cash getting tied up in stock that doesn't sell, and keeps the items that do sell on the shelf.
| Task | The question it answers | Read more |
|---|---|---|
| Buying | What to order, from whom, when and how many | Reorder point and safety stock |
| Receiving | Did the supplier send what we ordered? | Check each delivery against its purchase order |
| Records | How many do we have, and where? | Perpetual vs periodic inventory |
| Counting | Are the records right? | How to do a stock count |
| Costing | What did the goods we sold cost us? | FIFO vs moving average cost |
| Measuring | Is the stock working hard enough? | The numbers below |
Purchasing develops a plan that will ensure that the goods will be on hand at the time they are needed. Receiving is where the plan meets the truck: count what came, compare it with the order, and only then add it to stock.
Inventory is usually measured at cost until it either becomes impaired or is sold or disposed of. That cost decides the profit, which is why the costing method matters as much as the count.
| Method | What it does | Free tool |
|---|---|---|
| ABC analysis | Ranks items by sales value, so the few important ones get the most care | ABC analysis |
| Reorder point | Says when to order each item | Reorder point calculator |
| Safety stock | A buffer for late deliveries and busy days | Safety stock calculator |
| Min-max | Orders up to a maximum when stock falls below a minimum | Min-max calculator |
| Economic order quantity | Says how much to order at a time | EOQ calculator |
| Cycle counting | Counts a few items every day instead of everything once a year | Cycle count plan |
ABC analysis is a common inventory management technique that helps to identify your most valuable items. Purchasing based on reorder points is a very common method to use, and it needs a buffer: some margin of safety must be kept by means of the stock on hand so that satisfactory sales can be made.
Just-in-time, where goods arrive only when they are needed, works for factories with close suppliers. Most small shops buy from wholesalers with lead times of days or weeks, so they keep a reorder point and a small safety stock instead.
Inventory turnover measures the number of times a shop has sold and replaced its inventory over a given time period. A variation on the turnover formula is to divide 365 days by it, which gives the number of days of inventory on hand.
| Number | Formula |
|---|---|
| Inventory turnover | Cost of goods sold for the year ÷ average stock at cost |
| Days on hand | 365 ÷ inventory turnover |
| GMROI | Gross profit for the year ÷ average stock at cost |
| One year, at cost | Today | Target |
|---|---|---|
| Sales | 200,000 | 200,000 |
| Cost of goods sold | 120,000 | 120,000 |
| Gross profit | 80,000 | 80,000 |
| Average stock | 30,000 | 24,000 |
| Inventory turnover | 4.0 | 5.0 |
| Days on hand | 91 | 73 |
| GMROI | 2.67 | 3.33 |
Today the shop sells and replaces its stock four times a year, so the average item waits about 91 days. If better reorder points cut the average stock to 24,000 with the same sales, the turnover rises to 5 and 6,000 of cash comes off the shelf and into the bank. Each 1.00 in stock then earns 3.33 of gross profit a year instead of 2.67.
Turnover should be tracked on a trend line to see if there are small reductions in the rate of turnover, which can show that action is required to eliminate excess stock. Work it out for each category, not only for the whole shop: one slow category can hide behind a fast one.
Do the arithmetic for your own figures with the inventory turnover calculator and the GMROI calculator.
A commonly used inventory tracking option is to record everything in a spreadsheet. Spreadsheets may be a good short term solution for shops dealing with low order volumes and a small product range. The trouble starts when two people edit the file, when a sale is not typed in, or when the item list grows past what one person can check.
Inventory software effectively does the work of a spreadsheet, but without the manual input. A sale at the till lowers the stock, a receiving raises it, and the reorder list builds itself. Incorrect inventory records lead to a number of other problems, such as stockouts, wrong purchase quantities, and a badly inaccurate cost of goods sold, so whichever you use, accurate records come first.
Not ready for software? The free inventory and invoice template is an .xlsx file with stock on hand and reorder alerts.
System 5 is a Windows program for a small business that wants its stock on its own PC.
The words are often used for the same thing. When they are kept apart, control is the day-to-day part (records, counts, security) and management also covers the decisions: what to buy, when and how much.
It depends on what you sell: fresh food turns many times a year, hardware and furniture far fewer. Compare your own figure with last year's, and each category with the others.
With accurate records. Count the stock, enter it, and keep every receiving and sale in the system. Reorder points and turnover figures are only as good as the stock figures under them.
An asset while it is on the shelf. It becomes an expense, the cost of goods sold, when it is sold, damaged or lost.
For each item, enough to cover the demand during the supplier's lead time plus a safety stock. The reorder point guide works it out step by step.
Golden Inventory System 5 is a Windows program that you pay for once: $99 for up to 5 users, $199 for any number.