Inventory Turnover for a Small Shop: Formula, Days on Hand and Dead Stock

Stockroom shelves of boxed goods with a clipboard and calculator on a worktable.

Inventory turnover measures how many times a shop sells through its average stock in a period, and it is built from two figures already sitting in the books: cost of goods sold and the value of inventory on hand. The ratio turns a shelf full of product into a single number that can be tracked from year to year.

Video: The Finance Storyteller

The Formula and Where Each Number Comes From

Cost of goods sold first

An accounting textbook published through Lumen Learning gives the formula as cost of merchandise sold divided by average inventory. Its example divides $414,000 of merchandise sold by the average of $55,000 and $48,000 in inventory balances, which produces a turnover of 8.0.

For a sole proprietor, the cost of goods sold figure has an official recipe. The IRS instructions in Publication 334 say to add beginning inventory, purchases, labor, materials and supplies, and other costs, then subtract ending inventory. The remainder is cost of goods sold. Beginning inventory normally matches the prior year’s closing inventory.

Average inventory

Average inventory is beginning inventory plus ending inventory, divided by two. Some formulas use the ending balance alone, but a software company’s guide to the calculation cautions that this figure might not be “representative of other points of the year”.

Why cost, not sales

Sales include markup, while inventory sits on the books at cost. One small-business finance site notes that some companies divide total sales by average inventory instead of cost of goods sold, which is why two published ratios for the same shop can differ. The cost-based version matches the way inventory is valued, and it is the version used throughout this article.

Days Sales of Inventory

Turning the ratio into days

Days sales of inventory restates turnover as a length of time. The Lumen text gives the formula as average inventory divided by cost of goods sold, multiplied by 365, and notes it is essentially the inverse of turnover. Its example turns 8.0 into 45.6 days by dividing 365 by 8.

A worked example

A hypothetical shop opens the year with $40,000 of inventory at cost, buys $200,000 of goods during the year and closes with $60,000. Cost of goods sold is $40,000 plus $200,000 minus $60,000, or $180,000. Average inventory is $50,000. Turnover is $180,000 divided by $50,000, or 3.6. Days sales of inventory is $50,000 divided by $180,000, times 365, or about 101 days.

The inventory-software guide supplies a second worked case: $500,000 of cost of goods sold against $60,000 of average inventory gives a turnover of about 8.33 and roughly 43.8 days. A finance site puts the meaning plainly, saying that a ratio of 5 means inventory is sold and replaced about five times a year.

The two figures from the hypothetical shop say the same thing in different units: stock turns a little over three times a year, and a typical item waits roughly 101 days before it sells.

Laptop with a spreadsheet next to stacked cardboard boxes on a shop counter.

What the Ratio Means, and Where Sources Disagree

Direction matters more than any single reading

A higher turnover generally means faster sales and, in the Lumen text’s words, more cash generated to pay bills and debts. A low ratio is ambiguous. An inventory-software company writes that a low ratio “could signify either weak sales or overstocking”, and that a very high ratio can also signal trouble because thin stock raises the risk of running out.

Published ranges conflict

Fetched sources do not agree on what counts as healthy. A small-business finance site states that a ratio between 5 and 10 is considered good for most industries. An e-commerce platform’s blog says the figure a retail business should aim for is between 2 and 4, in a post marked as several years old. The inventory-software guide cited above says there is “no universal ideal inventory turnover ratio” and itself quotes two different ranges, 4 to 6 and 5 to 10.

The Lumen text explains why a single target fails: turnover varies by product, with fast-moving milk in a grocery store contrasted against slower holiday cards. A second guide reaches the same conclusion from another angle, noting that a designer sofa may take longer to sell than a book but still pay off through higher margins.

The comparison that holds up is a shop against its own history. The finance site recommends benchmarking against industry averages and the company’s own past performance, and no fetched source supplies an industry average for a specific type of small shop. Specific ranges for shop types are therefore left out here.

Holding Costs

What unsold stock costs

Stock that does not sell still costs money. An e-commerce software company lists four groups of carrying cost: capital tied up in stock, storage, service costs such as insurance and counting labor, and risk losses from obsolescence, spoilage, theft and shrinkage. The same article describes the benchmark as roughly 20% to 30% of average inventory value per year, and the inventory-software guide from earlier puts the figure at 20%-30% of inventory value.

A bookkeeping-software company’s guide gives a slightly wider range, 20 to 35 percent of value per year. The article promotes its own products, and its range comes without a named study. Applied to the hypothetical shop, 20% to 30% of $50,000 in average inventory is $10,000 to $15,000 a year.

How it appears in the numbers

Holding costs rarely show up as one line in the accounts. A slow turnover figure and a long days-on-hand figure are the visible signs: cash sits in product, storage space fills, and the interest or lost return on that cash accumulates quietly. A high days-sales figure, according to the inventory-software guide, links to excess stock and carrying costs.

Dusty unsold items on a low back shelf with well-stocked shelves behind them.

Dead Stock and Slow Movers

Spotting it before it hardens

A shop-wide ratio can look acceptable while a handful of items drag it down. The inventory-software guide describes low turnover as an early warning of obsolescence and recommends acting before inventory becomes dead stock.

The bookkeeping-software company defines dead stock, citing a textbook convention, as product with no sales in twelve months, and treats items with no sales for six months as slow-moving stock on probation. Those thresholds come from a vendor article rather than from a regulator, so a shop with seasonal lines may reasonably set its own.

Per-item sales dates reveal what the shop-wide ratio hides. A simple inventory spreadsheet can carry a last-sold date for every item, and the specials board is one way a restaurant moves stock before it ages.

Cost-flow methods shift the inputs

The method used to assign cost to units sold changes both cost of goods sold and closing inventory, and with them the ratio. Publication 538 describes FIFO as treating the earliest purchased items as sold first, so closing inventory is matched to the most recent costs. LIFO treats the latest items as sold first, which in rising-price periods produces a larger cost of goods sold and a lower closing inventory. Where actual costs can be matched to individual items, specific identification applies instead.

How the tax rules treat value

For tax purposes, IRS Publication 538 states that an inventory is necessary to clearly show income when buying or selling merchandise is an income-producing factor, and that inventory must be valued at the beginning and end of each tax year. Under the lower of cost or market method, the publication has the owner compare each item’s market value with its cost and use the lower figure, valuing items individually. Qualifying small businesses may choose not to keep an inventory, but they must still use a method that clearly reflects income. Publication 334 adds that inventory practices must be consistent from year to year.

Hands counting items from an open box onto a wooden counter beside a handheld tally counter.

Choosing a Period and Keeping Inputs Consistent

Seasonal shops

Annual figures smooth over seasons. The inventory-software guide advises considering seasonal fluctuations and product demand, and the bookkeeping-software article suggests averaging monthly or quarterly balances for seasonal businesses. A shop that stocks heavily before a December rush would see a year-end balance that misrepresents the other eleven months.

Monthly, quarterly or annual

A retail e-commerce blog notes that ratios are normally calculated annually, though many businesses use monthly or quarterly periods, and advises combining the ratio with other indicators. The finance site adds a caution on the other side of the scale: a high turnover can reflect strong sales, but it may also mean too little stock, and holding extra inventory can be worthwhile if prices are expected to rise.

Same method every time

Comparisons across years only mean something when the inputs are built the same way. Counting dates, valuation method and the treatment of returns and damaged goods all change the ratio without any change in how fast product sells. For restaurants, food cost percentage runs on much of the same purchase and inventory data.

For informational purposes only — consult a licensed attorney, tax professional or financial advisor.

Sources