Skip to content
Plymouth AI Lab

Blog

How to work out months of inventory on hand

By Noam Turecki ·

Divide the value of your inventory at month end by that month's sales. The result is your months of stock on hand, and multiplying it by about 30 gives you days.

Statistics Canada describes its inventory-to-sales ratio the same way: it measures the time, in months, that would be required to exhaust inventories if sales stayed at their current level (Monthly Survey of Manufacturing, August 2026, published 15 October 2026).

Two public ratios for August 2026 give you something to check against: 1.60 from Statistics Canada and 1.33 from the Census report covered below. They cover different groups, so look at what each one counts before you set your number beside either.

If you want this number on a screen your team checks every week, Plymouth AI Lab builds logistics dashboards from the data in a firm's warehouse management system (WMS), transportation management system (TMS), accounting tool and spreadsheets. Its page says a build starts by agreeing the five to eight numbers the team will look at each week and how each one is calculated.

Divide month-end inventory by the month's sales

You need two numbers for the same month: what your inventory was worth on the last day, and what you sold during that month.

  1. Pick one month.
  2. Take the value of your inventory on the last day of that month.
  3. Take that month's sales, in the same currency.
  4. Divide the inventory value by the sales.

Value both numbers the same way. Your books may carry inventory at cost or at selling price; pick one and keep it fixed, month after month, or the ratio will move for reasons that have nothing to do with your stock.

Read the answer as months. A result of 2.0 means the stock on hand would take about 2 months to run out if sales stayed where they were that month. To get days, multiply by about 30, since a month is taken as about 30 days.

One month's ratio moves with that month's sales. A slow month pushes the figure up even if you haven't bought a single extra pallet, and a busy month pulls it down.

Worked example with public figures: 1.60 months is about 48 days

This example uses Statistics Canada manufacturing figures for August 2026. It is public data, not a Plymouth or client result.

Statistics Canada reported manufacturing sales of $79.9 billion for August 2026 and total inventories of $127.7 billion for the same month. Both come from the same release, Monthly Survey of Manufacturing, August 2026.

Divide $127.7 billion by $79.9 billion and you get about 1.60. That matches the ratio Statistics Canada published, which fell from 1.62 in July to 1.60 in August.

Multiply 1.60 months by 30 and you get about 48 days. That last step is our own arithmetic with the 30-day rule of thumb.

The same steps work on a single warehouse or a single product line. Swap in your own month-end inventory value and your own sales for the month, and keep the units the same on top and bottom.

What the US and Statistics Canada ratios say for August 2026

The Census report, Manufacturing and Trade Inventories and Sales: August 2026, put the total business inventories/sales ratio at 1.33 at the end of August, based on seasonally adjusted data. The August 2025 ratio in the same report was 1.40.

Statistics Canada's ratio was 1.60 for August 2026, down from 1.62 in July.

SourceRatioComparison point
Census report, end of August 20261.331.40 in August 2025
Statistics Canada, August 20261.601.62 in July 2026

One is a United States government page and the other is a Government of Canada page. Both were published on 15 October 2026.

The two comparison points differ: the Census figure is set against the same month a year earlier, and the Statistics Canada figure against the month before. Don't read the two rows as one trend.

The Census passage doesn't say the 1.33 is measured in months, so this post reports it only as a ratio of 1.33. It also doesn't say the figure is defined the same way as the Statistics Canada one.

Check these differences before you compare your ratio

Start with what each figure counts. The Census report is titled for manufacturing and trade. The Statistics Canada release is the Monthly Survey of Manufacturing, and its figures are manufacturing sales and manufacturing inventories.

Next, look at seasonal adjustment. The Census ratio is based on seasonally adjusted data, and Statistics Canada says its monthly data in the release are seasonally adjusted too. Your own month-end ratio is probably not adjusted, so a single month of yours can look different from a seasonally adjusted public number.

Then check prices. Statistics Canada expresses its monthly figures in current dollars. The Census inventory level is adjusted for seasonal and trading day differences but not for price changes.

Your books have their own version of the same question: whether inventory and sales are both valued at cost or both at selling price. Pick one and keep it.

Neither ratio is a target or a benchmark for a warehouse, a third-party logistics provider or anyone else, and neither is a recommendation. They are yardsticks. Check what each side counts before you read a gap as good or bad.

Put the ratio on a monthly routine

A ratio is only useful if it means the same thing every time you look at it. Write the definition beside the number: which inventory value, which sales, which month.

Then calculate it the same way each month. When the next releases from Statistics Canada and the Census report appear, set your own figure beside theirs, after checking again what each one counts.

Your next step: work out your ratio for last month end with your own inventory value and sales, write down how you calculated it, and only then set it beside the 1.33 and 1.60 figures.

Sources

Related service: Supply chain analytics and logistics dashboards, built from your own data

This post was researched and drafted by AI agents, then checked by a separate AI fact-checker and reviewer before publishing. Every source is linked above.

From data points to pathways.

Book a 1:1 intro call and see how a small AI system could work on the data your operation already has.

Book a call