Stock-to-Sales Ratio: Formula and Retail Inventory Planning

Stock-to-sales ratio compares the value of inventory on hand with sales during a period. Retailers use it to judge whether inventory levels are high or low relative to sales.

Stock-to-sales ratio formula

Stock-to-Sales Ratio = Inventory Value ÷ Sales Value

If month-end inventory is $120,000 and monthly sales are $60,000:

$120,000 ÷ $60,000 = 2.0

The business holds inventory equal to two times one month's sales.

Use consistent valuation

Do not mix inventory at cost with sales at retail value without understanding the distortion. Use a consistent planning basis.

What does a high stock-to-sales ratio mean?

It may indicate:

• excess inventory
• slower sales
• seasonal build-up
• long lead-time preparation
• weak assortment

A high ratio is not automatically bad if stock is intentionally built before a peak period.

What does a low ratio mean?

It can indicate efficient inventory use, but it can also signal insufficient coverage and higher stockout risk.

Stock-to-sales example by location

Store A:

• Inventory: $60,000
• Monthly sales: $60,000
• Ratio: 1.0

Store B:

• Inventory: $90,000
• Monthly sales: $30,000
• Ratio: 3.0

Store B may have excess inventory or slower demand even if the companywide total looks normal.

Stock-to-sales vs weeks of supply

Both compare stock with demand.

• Stock-to-sales is a financial ratio.
• Weeks of supply expresses inventory coverage in time.

Weeks of supply is often more intuitive for operational replenishment.

Stock-to-sales vs inventory turnover

Stock-to-sales is a point-in-time planning measure. Turnover measures how often average inventory cycles through over a longer period.

How retailers use stock-to-sales

• monthly merchandise planning
• category budgeting
• store comparison
• seasonal planning
• identifying overstock
• open-to-buy planning

See open-to-buy planning.

Why one target ratio is not enough

Different categories need different inventory coverage. Fast-moving staples, seasonal merchandise and slow-moving high-value products should not share one ratio target.

How to improve the ratio

If the ratio is too high

• reduce new purchasing
• transfer excess stock
• markdown aging products
• improve forecasting

If the ratio is too low

• review reorder points
• increase safety stock where justified
• address supplier delays
• increase purchase frequency

Common mistakes

• mixing cost and retail values
• using one companywide ratio only
• ignoring seasonality
• comparing categories with different economics
• treating a low ratio as automatically good

How Stash helps

Stash helps physical businesses compare stock, sales context, purchasing and locations so operators can identify where inventory is high or low relative to demand.

Frequently asked questions

Is a lower stock-to-sales ratio better?

Not always. Too low can increase stockout risk.

Should I calculate it monthly?

Monthly is common for retail planning, but faster cycles may be useful for volatile categories.

Can I use units instead of dollars?

You can compare units to unit sales, but the traditional stock-to-sales ratio is often used on a financial basis.

Next steps

Calculate the ratio by category and location, then compare it with weeks of supply and inventory turnover.

Stock-to-sales planning example

Suppose a retailer plans $80,000 of November sales and wants a 1.5 stock-to-sales ratio at the start of the month.

Target stock = $80,000 × 1.5 = $120,000

If projected beginning inventory is only $95,000, the planning gap is $25,000 before considering open purchase orders, markdowns and other inventory-plan inputs.

This is why the ratio is often useful in merchandise and open-to-buy planning rather than as a stand-alone reorder formula.

Beginning-of-month vs ending stock

Retail planning teams may define stock-to-sales using beginning-of-month stock, ending stock or another consistent point in the planning cycle. The exact convention matters less than using the same convention when comparing periods and categories.

How seasonality changes the ratio

A retailer may intentionally raise the ratio before a holiday or peak season, then lower it afterward. If the target remains static all year, the business can underbuy before peaks and overbuy after them.

Stock-to-sales by category

Staples with stable replenishment may operate efficiently with a lower ratio than seasonal or long-lead-time products. Set category-level targets based on demand volatility, lead time, gross margin, shelf life and service goals.