The merchandise turnover ratio shows how many times a business sells and replaces its stock during a year. You calculate it by dividing cost of goods sold (COGS) by average inventory. Most industries aim for 5 to 10 turns a year, but the right number depends on what you sell.

What Is Merchandise Turnover Ratio?

It is a financial efficiency metric that measures how fast goods move from your shelves to customers. It is also called inventory turnover, stock turnover, or inventory turns. “Merchandise turnover” is simply the retail-focused name for the same calculation.

A high ratio usually means strong sales and lean stock. A low ratio means you hold more stock than you sell. Business owners, retail managers, accountants, lenders, and students all use it.

Merchandise Turnover Ratio Formula

The standard formula is COGS divided by average inventory.

Merchandise Turnover Ratio = COGS ÷ Average Inventory

Average Inventory = (Beginning Inventory + Ending Inventory) ÷ 2

COGS is the direct cost of the goods you sold in the period. Always use COGS, not sales revenue. Sales include your profit margin, so they inflate the ratio and give a false sense of efficiency. Both figures should also be at cost, not retail price.

How to Calculate Merchandise Turnover Ratio

You can calculate it in five steps: pick a period, find COGS, find average inventory, divide, and interpret the result.

1. Choose your period, such as a fiscal year, quarter, or month.
2. Take COGS for that same period from your income statement.
3. Add beginning and ending inventory (both at cost) and divide by two.
4. Divide COGS by average inventory.
5. Compare the result with peers in your industry.

Example: A clothing store has annual COGS of $600,000. Beginning inventory was $90,000 and ending inventory was $110,000.

• Average inventory = ($90,000 + $110,000) ÷ 2 = $100,000
• Turnover ratio = $600,000 ÷ $100,000 = 6

The store sold through its average stock six times in the year, or roughly once every two months.

What Is a Good Merchandise Turnover Ratio?

A good ratio is usually between 5 and 10 turns a year, but “good” depends on your industry. NetSuite and Extensiv both treat this range as a sensible target for most businesses. It means stock sells and restocks about every one to two months.

Two warning lines are worth remembering. A ratio below 3 usually deserves a review. A ratio above 10 may mean you are running out of stock before you reorder.

Your own history also matters. Tracking your trend over time often tells you more than chasing an industry average.

Merchandise Turnover Ratio by Industry

Benchmarks vary widely because products differ. Groceries sell in days, while furniture and jewelry sit for months.

Industry	Typical Turnover	Days Sales in Inventory
Grocery / food retail	15–30x	12–24 days
Fast fashion / apparel	6–10x	36–61 days
Consumer electronics	6–10x	36–61 days
General retail	5–9x	41–73 days
Automotive dealerships	3–5x	73–122 days
Furniture / home goods	2–4x	91–183 days
Luxury goods	1–3x	122–365 days

Recent figures show how sizes and models differ:

• The global retail average was 8.96 turns in Q2 2025.
• E-commerce businesses averaged 10.19 turns in 2025, helped by leaner inventory models.
• Small retailers averaged 6.25 turns, which leaves room to improve.
• CSI Markets 2025 data puts retail at 10.86 turns. Netstock’s July 2026 benchmarks show 13.79. The gap comes from different methods, so compare your ratio with one source consistently.

Compare yourself with direct competitors that sell similar products, not with unrelated industries.

How to Interpret Your Turnover Ratio

A low ratio points to overstock, and a high ratio points to fast sales or thin stock. Context decides which one is a problem.

Ratio	What it suggests	What to do
Below 3	Excess stock, weak sales	Review at once, clear slow items
3–5	Overstocked, slow movement	Improve forecasts, order less
5–10	Balanced inventory	Maintain and fine-tune
10–15	Efficient, fast-moving	Watch for stockouts
Above 15	Possible lost sales	Raise safety stock, shorten lead times

Red flags include frequent markdowns, rising storage costs, aging stock, and cash shortages despite good sales. Frequent stockouts on popular items are a red flag too, even when the ratio looks great.

Days Sales in Inventory (DSI)

DSI tells you how many days it takes to sell your average inventory. The formula is 365 ÷ Turnover Ratio. In our example, 365 ÷ 6 gives about 61 days.

DSI and turnover are two views of the same idea. Higher turnover means lower DSI. Many non-financial colleagues find “61 days of stock” easier to grasp than “6 turns,” so track both.

Common Mistakes in Turnover Calculation

The most common mistakes are using sales instead of COGS and mixing up time periods or valuation methods. Each one can make a weak business look strong.

• Using sales instead of COGS. This inflates the ratio.
• Using retail value for inventory. Inventory and COGS must both be at cost.
• Mismatched periods. Annual COGS with quarterly inventory gives a wrong answer.
• One inventory snapshot. Seasonal shops should average monthly or weekly counts instead.
• Ignoring write-offs and shrinkage. This overstates inventory health.
• Only measuring the total. Category-level numbers reveal hidden underperformers.

Consignment stock is a special case. You don’t own it, so leave it out of average inventory. Drop-shipped items never touch your shelves, so leave them out of both COGS and inventory.

How to Improve Merchandise Turnover Ratio

You improve it by selling stock faster or holding less of it, without causing stockouts. Start with the changes that cost the least.

• Forecast demand using past sales and seasonal patterns.
• Clear slow movers early with discounts or bundles.
• Place smaller, more frequent orders to cut average inventory.
• Ask suppliers for faster delivery to shorten reorder cycles.
• Use ABC analysis to focus on your best sellers.
• Review prices on items that are not moving.
• Run cycle counts and use barcode scanning for accurate data.

Just-in-time ordering and vendor-managed inventory work well for predictable, high-volume items. Always track stockouts next to turnover so you don’t trade one problem for another.

Merchandise Turnover and Cash Flow

Faster turnover frees up cash. Money sitting in unsold stock cannot pay suppliers, staff, or rent. It also adds holding costs such as storage, insurance, and the risk of obsolete goods.

Turnover also links to supplier payment terms and the cash conversion cycle. If you sell stock in 61 days but pay suppliers in 30, you must finance the gap. Better terms or faster sales both shrink it.

Pair turnover with GMROI (gross margin ÷ average inventory). Turnover shows speed, and GMROI shows whether that speed is profitable.

Advanced Turnover Analysis and Tools

Once the basics work, split your analysis by category, store, and sales channel. Online and in-store numbers often tell different stories. Track new products separately until they have six to twelve months of sales history.

In high-inflation markets, compare years in constant currency so price rises don’t distort results. Document your method, including the period and how you average inventory, so others can trust the numbers.

You can start with Excel or Google Sheets. As you grow, inventory software such as NetSuite, Unleashed, Finale Inventory, or Netstock can track turnover automatically. POS systems like Shopify POS and Square also help, and AI-based forecasting is becoming more common.

Key Takeaways

• The merchandise turnover ratio equals COGS ÷ average inventory.
• Use COGS and cost values, never sales or retail prices.
• 5–10 turns is a common target, but industry decides what is right.
• Below 3 needs review. Above 10 needs a stockout check.
• Track DSI, GMROI, and category-level results alongside it.

Calculate your ratio this month, set a baseline, and improve it one category at a time.

FAQs

What is the difference between merchandise turnover and inventory turnover?
Nothing in the math. Merchandise turnover is the retail term, and inventory turnover is the broader term used across retail, wholesale, and manufacturing.

Should I use COGS or sales in the formula?
Use COGS. Sales include profit margin and inflate the result.

What is a bad merchandise turnover ratio?
For general retail, anything below 3 usually needs review. It points to excess stock and tied-up cash.

Can the ratio be too high?
Yes. Above 10 to 12 in most retail, it can mean frequent stockouts and lost sales.

How often should I calculate it?
Annually for reporting, quarterly for interim reviews, and monthly for day-to-day control.

How does seasonality affect it?
Seasonal swings distort a simple beginning-and-ending average. Use monthly or weekly inventory snapshots instead.

What if I have many product categories?
Calculate turnover for each category, vendor, or location, and set separate targets.

How do I explain it to non-financial colleagues?
Convert it to days. “A turnover of 6 means we sell our stock about every two months.