What is average inventory?
Average inventory is the mean value of a company's stock over a given period — typically a month, quarter, or year. Rather than using a single point-in-time snapshot, it smooths out fluctuations caused by seasonality, restocking cycles, and irregular demand patterns.
Businesses use average inventory as an input for other important calculations: inventory turnover ratio, days inventory outstanding (DIO), and the cost of goods sold. A single end-of-period inventory balance can be misleading — a business might deliberately run inventory down before a reporting date, making efficiency look better than it actually is. Average inventory corrects for this.
Average inventory formula
The standard two-point formula uses the beginning and ending inventory balances for a period:
This works well for short, stable periods. For businesses with seasonal swings or irregular restocking, a multi-period average gives a more accurate picture.
Multi-period formula
For example, averaging 13 monthly snapshots (January through January) gives a full-year rolling average that accounts for every peak and trough in the cycle.
How to calculate average inventory step by step
Two-point method (most common)
- Find your beginning inventory — the stock value at the start of the period. This is usually the ending inventory from the prior period.
- Find your ending inventory — the stock value at the close of the period, from your balance sheet or stock count.
- Add the two values together.
- Divide by 2.
Multi-period method
- Collect inventory balances at the end of each period (month, quarter, etc.).
- Include the opening balance of the first period as your first data point.
- Add all balances together.
- Divide by the total number of data points used.
Worked examples
Example 1 — Two-point annual average
A retailer starts the year with $120,000 in inventory and ends the year with $80,000:
The average inventory for the year is $100,000 — a more realistic view than using either the high ($120,000) or the low ($80,000) figure alone.
Example 2 — Monthly average (seasonal business)
A garden supply company with strong spring seasonality tracks monthly closing balances:
Note how the simple two-point method (Jan $40K + Dec $35K ÷ 2 = $37,500) would significantly understate the actual average, because it misses the spring peak entirely. Multi-period is the right approach for seasonal businesses.
Example 3 — Quarterly average
A wholesale distributor reporting quarterly:
How average inventory is used
Average inventory feeds directly into several key business metrics:
| Metric | Formula using average inventory | What it tells you |
|---|---|---|
| Inventory Turnover | COGS ÷ Average Inventory | How many times stock is sold and replaced per period |
| Days Inventory Outstanding | 365 ÷ Inventory Turnover | How many days stock sits before being sold |
| Inventory to Sales ratio | Average Inventory ÷ Net Sales | How much inventory is held relative to revenue |
| Working Capital analysis | Part of current assets | How much capital is tied up in stock |
Inventory turnover example
Using the retailer from Example 1:
This means the business sells through its entire stock about every 61 days — a reasonable figure for a mid-range retailer. Industry benchmarks vary widely, so always compare against peers in the same sector.
Common mistakes to avoid
- Using year-end only: Businesses sometimes manipulate year-end inventory by running down stock before the reporting date. Using only the end-of-year balance rewards this behavior in the metrics. Multi-period averaging reduces this distortion.
- Mixing valuation methods: Beginning and ending inventory must use the same valuation method (FIFO, LIFO, or weighted average). Mixing methods produces a meaningless average.
- Ignoring work-in-progress: For manufacturers, average inventory should include raw materials, work-in-progress (WIP), and finished goods — not just finished goods alone.
- Using retail value instead of cost: Inventory turnover uses COGS (at cost) in the numerator. Average inventory must also be valued at cost for the ratio to be meaningful.
- Averaging too few data points for seasonal businesses: A two-point annual average for a seasonal business will almost always be wrong. Monthly snapshots give a far more accurate picture of true average stock levels.
How to interpret your average inventory result
Average inventory on its own is a dollar figure — it only becomes useful in context. Here is how to interpret what you find:
Frequently asked questions
What is average inventory used for?
Average inventory is used to calculate inventory turnover ratio, days inventory outstanding, and inventory-to-sales ratio. It smooths out period-end fluctuations to give a more accurate view of how much stock a business typically holds.
What is the difference between beginning and ending inventory?
Beginning inventory is the stock value at the start of a period — it equals the ending inventory from the prior period. Ending inventory is the value at the close of the current period, after sales and new purchases have been accounted for.
Should I use the two-point or multi-period method?
Use the two-point method (beginning + ending ÷ 2) when your business has stable, predictable inventory levels throughout the year. Use multi-period averaging (monthly or quarterly snapshots) when you have seasonal demand, large restocking events, or significant month-to-month variation.
Can average inventory be calculated in units instead of dollars?
Yes — the formula works identically with unit counts. Simply replace dollar values with unit quantities. Unit-based averages are useful for planning reorder points and safety stock, while dollar-based averages are used for financial reporting and ratios.
What is a good inventory turnover ratio?
It depends heavily on industry. Grocery and fast-moving consumer goods can turn inventory 12–30 times per year. Furniture or automotive parts might turn 3–6 times. Always compare your turnover against industry benchmarks, not a universal standard. A higher ratio means faster-moving stock, but too high can signal understocking.