Guide · the basics for small businesses

What is inventory management?

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 → measure

Why it matters for a small business

Any 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.

What inventory management covers

TaskThe question it answersRead more
BuyingWhat to order, from whom, when and how manyReorder point and safety stock
ReceivingDid the supplier send what we ordered?Check each delivery against its purchase order
RecordsHow many do we have, and where?Perpetual vs periodic inventory
CountingAre the records right?How to do a stock count
CostingWhat did the goods we sold cost us?FIFO vs moving average cost
MeasuringIs 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.

The methods most shops use

MethodWhat it doesFree tool
ABC analysisRanks items by sales value, so the few important ones get the most careABC analysis
Reorder pointSays when to order each itemReorder point calculator
Safety stockA buffer for late deliveries and busy daysSafety stock calculator
Min-maxOrders up to a maximum when stock falls below a minimumMin-max calculator
Economic order quantitySays how much to order at a timeEOQ calculator
Cycle countingCounts a few items every day instead of everything once a yearCycle 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.

The numbers that show whether it works

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.

NumberFormula
Inventory turnoverCost of goods sold for the year ÷ average stock at cost
Days on hand365 ÷ inventory turnover
GMROIGross profit for the year ÷ average stock at cost

Worked example: a shop with 30,000 in stock

One year, at costTodayTarget
Sales200,000200,000
Cost of goods sold120,000120,000
Gross profit80,00080,000
Average stock30,00024,000
Inventory turnover4.05.0
Days on hand9173
GMROI2.673.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.

Spreadsheet or software?

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.

Inventory management in Golden Inventory System 5

System 5 is a Windows program for a small business that wants its stock on its own PC.

Questions

What is the difference between inventory management and inventory control?

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.

What is a good inventory turnover for a small shop?

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.

Where should a small business start?

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.

Is inventory an asset or an expense?

An asset while it is on the shelf. It becomes an expense, the cost of goods sold, when it is sold, damaged or lost.

How much stock should I keep?

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.

Inventory management on your own PC

Golden Inventory System 5 is a Windows program that you pay for once: $99 for up to 5 users, $199 for any number.