Average Inventory Formula: How to Calculate It (With Examples)

Knowing what's on your shelves today tells you very little about how much stock you carry over a month or a year. A warehouse that was packed in early January and nearly empty by the end of the month looks lean on the last day, even though it held a lot of stock for most of the period.

Average inventory fixes that by smoothing out the swings caused by seasonality, bulk purchases, and sales spikes. It also feeds directly into inventory turnover and days sales of inventory, two metrics that finance teams and investors watch closely. This guide covers the formula, the multi-period version, worked examples, and how to use the result in day-to-day planning.

What Is Average Inventory?

Average inventory is the typical amount of stock you held over a set period, usually a month, a quarter, or a year. It answers one question: on average, how much stock did I carry during this period? It doesn't tell you what's in the warehouse right now.

How It Differs from Beginning and Ending Inventory

• Beginning inventory is the stock you had at the start of the period, for example on 1 January.
• Ending inventory is the stock you had at the end, for example on 31 January.
• Average inventory sits between the two and smooths out the swings, so a single snapshot doesn't mislead you.

Say you stocked up heavily in early January for a sale and sold almost everything by the end of the month. Your ending inventory would look very low, but it wouldn't reflect the stock you actually held through the month. Average inventory gives you a more balanced picture.

Average Inventory Formula

The Basic Formula

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

Suppose you start March with $20,000 of inventory and end it with $28,000.

Average Inventory = ($20,000 + $28,000) ÷ 2 = $24,000

Over March, you held an average of $24,000 in stock. This version works well for short periods and for businesses whose stock levels move steadily.

The Multi-Period Formula

Average Inventory = Sum of Inventory at Each Point ÷ Number of Points

Use this version for quarterly or yearly analysis, or whenever stock levels swing a lot. Here are month-end balances for the first half of the year:

Total = $15,000 + $18,000 + $21,000 + $20,000 + $24,000 + $22,000 = $120,000

Average Inventory = $120,000 ÷ 6 = $20,000

More data points give a truer picture, so weekly counts beat monthly ones for fast-moving stock.

How to Calculate Average Inventory, Step by Step

1. Choose the period: Pick a month, a quarter, or a year, depending on what you're reporting. Monthly suits turnover reviews, while quarterly or yearly suits financial analysis.
2. Collect the inventory values: You need the beginning and ending balances for the basic formula, or month-end (or weekly) balances for the multi-period one. Use physical counts or a reliable inventory system, because errors here flow into every metric built on top.
3. Pick the formula: Use the basic version for short periods with steady stock. Use the multi-period version when levels fluctuate or the period is long.
4. Use the result: On its own, the number is only a starting point. It becomes useful once you feed it into turnover and days sales of inventory, covered below.

Where to Find the Numbers

Inventory sits on the balance sheet under current assets. Average inventory isn't listed there directly, so take the inventory balance at the start and end of your period and average them.

If you don't have a beginning figure, look at the previous period's closing balance. Beginning inventory for one period is always the ending inventory of the one before it. Balance sheet inventory is carried at cost, so keep your cost of goods sold (COGS) and your average inventory on the same cost basis.

Putting Average Inventory to Work in Other Metrics

Average inventory is rarely the end goal. It's an input to two metrics that show how efficiently your stock is moving.

Inventory turnover ratio = COGS ÷ Average Inventory: This shows how many times you sold and replaced your stock during the period. The full guide to the inventory turnover ratio covers benchmarks by industry.

Days sales of inventory (DSI) = (Average Inventory ÷ COGS) × 365: This shows how long stock sits before it sells. You may also see it called days inventory outstanding. If you're working with a quarter instead of a year, swap 365 for the number of days in that quarter.

Here's how they work together. Say a year's COGS is $120,000 and your average inventory for the year is $20,000.

• Turnover = $120,000 ÷ $20,000 = 6
• DSI = ($20,000 ÷ $120,000) × 365 ≈ 61 days

Always use average inventory and COGS from the same period. With sales steady, a lower average inventory means higher turnover, and a rising DSI points to slow-moving stock.

Average Inventory vs. Other Inventory Metrics

Average inventory and average cost sound alike but answer different questions. Average inventory averages your stock levels. Average cost averages your unit prices, and it's used in the weighted average valuation method to work out COGS and the value of what's left.

How to Use Average Inventory in Business Decisions

• Spot overstocking and understocking: Compare average inventory with sales. A consistently high average alongside flat sales points to overstock. A low average alongside strong sales or frequent stockouts points to understocking. Either way, it shows you where to trim excess or add cover.
• Check supplier and planning performance: If average inventory climbs without a matching rise in sales, look for late deliveries, forecasting misses, or order cycles that are out of step with demand.
• Set smarter replenishment rules: Combined with sales velocity and lead times, average inventory helps you set reorder points and safety stock buffers. From there, the replenishment quantity formula turns those inputs into an order size.
• Read seasonal patterns: Tracked month by month next to sales, it shows when stock needs to ramp up or down ahead of campaigns and seasonal swings.

In fashion and multi-location retail, it also helps you watch depth (stock per SKU) against width (the number of styles and variants you carry). Too much of both ends in markdowns, and too little ends in missed bestsellers.

Best Practices for Using Average Inventory

• Use consistent periods: Whether you analyze by month, quarter, or year, keep the same cadence when comparing performance or spotting trends.
• Keep your data current: Outdated counts throw off the whole calculation. Run routine cycle counts or audits so your balances match what's physically on the shelf.
• Pair it with other metrics: Average inventory becomes far more useful next to turnover, DSI, and gross margin, which together show how healthy your stock really is.
• Let software do the tracking: Manual counts get slow and error-prone as SKUs and locations grow. A system that tracks stock continuously makes every period-end balance easier to trust.

How Supplymint Helps with Average Inventory

Average inventory is only as good as the stock data behind it. Supplymint's warehouse management system keeps counts accurate with barcode and RFID-backed tracking, and variance detection during cycle counts surfaces mismatches by bin, rack, or zone before they distort your numbers. With real-time inventory visibility across locations, the starting and ending balances you use are ones you can rely on.

Want to see how this works across your own warehouses and stores? Book a demo with Supplymint.

Frequently Asked Questions

1. What's the Difference Between Average Inventory and Average Cost?

Average inventory is the average level of stock you held over a period. Average cost is the average unit cost of the items in that stock, used for valuation and COGS. One measures how much you held, and the other measures what it cost.

2. Can I Use Average Inventory to Calculate COGS?

Not directly, because COGS comes from your accounting records, based on the units you actually sold and what they cost under your valuation method, such as FIFO, LIFO, or weighted average. Average inventory goes the other way: it's used alongside COGS in metrics like inventory turnover and days sales of inventory.

3. How Often Should I Calculate Average Inventory?

It depends on what you need it for. Monthly works for stock optimization and trend spotting, quarterly for financial analysis and seasonal planning, and yearly for year-end reporting and budgets. Businesses with fast-moving stock or many SKUs often get better control from monthly or even weekly calculations.

4. What If I Don't Have Beginning Inventory?

Use the closing balance from the previous period, since it's the same number. If you're starting from scratch, average whatever period-end balances you do have, and add more data points as you collect them.

5. Should I Calculate It in Units or in Value?

Either works, as long as you stay consistent. Use value at cost when feeding turnover or DSI, since COGS is also a value. Use units when you're planning stock levels, such as reorder points and safety stock.

6. How Does Average Inventory Affect Inventory Turnover?

Turnover is COGS divided by average inventory, so a higher average inventory lowers turnover and may point to overstock. A very low average can push turnover up, but it also raises the risk of stockouts. The inventory turnover ratio guide shows what a healthy number looks like.