A lot of times when we use our inventory turnover ratio, we use a related ratio called the average days in inventory. Let's check it out here. So average days in inventory, remember it's going to be related to that inventory turnover ratio. Well, the average days in inventory, it helps us analyze how long a unit sits in the warehouse before being sold, okay? So this is literally going to be the number of days that we're thinking about that the unit sitting in the warehouse. So this average days in inventory, it's another common efficiency ratio similar to the inventory turnover ratio. Cool? So it's an efficiency ratio to see how efficiently we're using our inventory balance. So remember that holding inventory costs us money. So the longer that a unit sits in the warehouse, that's going to cost us money in renting the warehouse and paying utilities in the warehouse, whatever it is, there's going to be all sorts of expenses related to having inventory. So imagine the more and more inventory we have, the bigger warehouse we need, the more we're going to need to spend on it. So like I said, this average days in inventory, it's related to the inventory turnover and let's just go over that inventory turnover ratio real quick before we move on to the average days in inventory. Now there was a whole discussion on the inventory turnover ratio, so make sure that you understood that and then move on here with the average days in inventory. So remember, we calculated inventory turnover, we had the cost of goods sold divided by our average inventory, right? And we always calculate average balances in all cases, it's always going to be for any sort of average. Anytime we have an average, balance of an account, so average inventory, average accounts receivable, average whatever it is, we're going to take the beginning balance in that account plus the ending balance in that account and divide it by 2, right? Let me do it as a fraction here. Divided by 2, right? That's always going to be how we calculate average. So in this case, average inventory, beginning inventory plus ending inventory divided by 2. So notice when we go to calculate our average days in inventory, well all we do is we take our inventory turnover ratio and we're going to do 365 ratio , okay? So that's easy enough, right? And notice that this average days in inventory, just like it says, average days in inventory, it tells us how many days. How many days a unit sits in inventory. So it's going to be a number of days. This you on average, we buy a unit and it sits there for 20 days before we sell it, right? So you can imagine that a company wants to sell these things as fast as possible. They want a unit to come into inventory and we sell it right away to make that money. So how do we compare average days in inventory? Well, just like a lot of other ratios, we're going to use benchmarking, right? We want to compare to our industry. You can imagine different industries are going to have different days in inventory, right? Sometimes they're going to have to sit there for a while before they get sold. Sometimes things move really quickly. So we want to see how our competitors do in their average days in inventory as well as maybe just an industry average for this kind of number and then compare how our company is doing. Okay? So what do you think? Would a higher amount of days in inventory or a lower amount of days in inventory be more efficient? A lower amount of days, right? That's what we want. We want to be able to buy a unit and sell it immediately. We want a low amount of days in inventory and that means that we're turning our inventory really fast. So just like the inventory turnover, it's kind of related to it in a reciprocal fashion where we want to be able to turn over our inventory many times, well that means we're selling it quickly and we're going to have a low average days in inventory. So that's how these are kind of interrelated there. So why don't we move on to this example and see how we use the average days in inventory in practice. Let's try this example together. XYZ company had net sales of 500,000 and COGS of 320,000. If the beginning balance of inventory was 60,000 and the ending balance in inventory was 100,000, what is the average days in inventory? So the first thing we want to do is calculate our inventory turnover ratio, right? This is going to be a 2 step process. We calculate our inventory turnover ratio and then we do 365 divided by that ratio. So let's go ahead and do that. So remember, when we do our inventory turnover ratio, notice above we don't talk about net sales at all. That's extraneous information. We don't need that. So let's go ahead and use what we do need, our cogs for our numerator and our average inventory balance. So the first thing we want to do is that average inventory balance and remember, that's just beginning plus ending divided by 2. So what we got, 60000 + 100000 2 and that is going to be our average inventory. 160000 2 , 80,000 is our average inventory balance, right? So let's go ahead and finish up our inventory turnover ratio before we get to our average days in inventory. So inventory turnover, well, what do we got? 320000 80000 , right, cogs over average inventory and that gives us an inventory turnover ratio of 4.0. Right? 4 on the dot. So last thing we gotta do is calculate our average days in inventory. So here we go. How do we do it? Very simple, right? 365 4 . Well, we're going to round it. It's approximately 91. So remember, this is a number of days, right? This is a number of days, So what does that mean? We buy a unit into our inventory and it's going to sit there for 91 days, for 3 months before we sell it. Cool? So 91 days, that's our answer in this case. C is the answer. Alright. Cool. Let's go on to the next one and you guys try and calculate the average days in inventory.

- 1. Introduction to Accounting1h 21m
- 2. Transaction Analysis1h 13m
- 3. Accrual Accounting Concepts2h 38m
- Accrual Accounting vs. Cash Basis Accounting10m
- Revenue Recognition and Expense Recognition24m
- Introduction to Adjusting Journal Entries and Prepaid Expenses36m
- Adjusting Entries: Supplies12m
- Adjusting Entries: Unearned Revenue11m
- Adjusting Entries: Accrued Expenses12m
- Adjusting Entries: Accrued Revenues6m
- Adjusting Entries: Depreciation16m
- Summary of Adjusting Entries7m
- Unadjusted vs Adjusted Trial Balance6m
- Closing Entries10m
- Post-Closing Trial Balance2m

- 4. Merchandising Operations2h 30m
- Service Company vs. Merchandising Company10m
- Net Sales28m
- Cost of Goods Sold - Perpetual Inventory vs. Periodic Inventory9m
- Perpetual Inventory - Purchases10m
- Perpetual Inventory - Freight Costs9m
- Perpetual Inventory - Purchase Discounts11m
- Perpetual Inventory - Purchasing Summary6m
- Periodic Inventory - Purchases14m
- Periodic Inventory - Freight Costs7m
- Periodic Inventory - Purchase Discounts10m
- Periodic Inventory - Purchasing Summary6m
- Single-step Income Statement4m
- Multi-step Income Statement17m
- Comprehensive Income2m

- 5. Inventory1h 55m
- Merchandising Company vs. Manufacturing Company6m
- Physical Inventory Count, Ownership of Goods, and Consigned Goods10m
- Specific Identification7m
- Periodic Inventory - FIFO, LIFO, and Average Cost23m
- Perpetual Inventory - FIFO, LIFO, and Average Cost31m
- Financial Statement Effects of Inventory Costing Methods10m
- Lower of Cost or Market11m
- Inventory Errors14m

- 6. Internal Controls and Reporting Cash1h 16m
- 7. Receivables and Investments3h 8m
- Types of Receivables8m
- Net Accounts Receivable: Direct Write-off Method5m
- Net Accounts Receivable: Allowance for Doubtful Accounts13m
- Net Accounts Receivable: Percentage of Sales Method9m
- Net Accounts Receivable: Aging of Receivables Method11m
- Notes Receivable25m
- Introduction to Investments in Securities13m
- Trading Securities31m
- Available-for-Sale (AFS) Securities26m
- Held-to-Maturity (HTM) Securities17m
- Equity Method25m

- 8. Long Lived Assets5h 1m
- Initial Cost of Long Lived Assets42m
- Basket (Lump-sum) Purchases13m
- Ordinary Repairs vs. Capital Improvements10m
- Depreciation: Straight Line32m
- Depreciation: Declining Balance29m
- Depreciation: Units-of-Activity28m
- Depreciation: Summary of Main Methods8m
- Depreciation for Partial Years13m
- Retirement of Plant Assets (No Proceeds)14m
- Sale of Plant Assets18m
- Change in Estimate: Depreciation21m
- Intangible Assets and Amortization17m
- Natural Resources and Depletion16m
- Asset Impairments16m
- Exchange for Similar Assets16m

- 9. Current Liabilities2h 19m
- 10. Time Value of Money1h 23m
- 11. Long Term Liabilities2h 45m
- 12. Stockholders' Equity2h 15m
- Characteristics of a Corporation17m
- Shares Authorized, Issued, and Outstanding9m
- Issuing Par Value Stock12m
- Issuing No Par Value Stock5m
- Issuing Common Stock for Assets or Services8m
- Retained Earnings14m
- Retained Earnings: Prior Period Adjustments9m
- Preferred Stock11m
- Treasury Stock9m
- Dividends and Dividend Preferences17m
- Stock Dividends10m
- Stock Splits9m

- 13. Statement of Cash Flows2h 24m
- 14. Financial Statement Analysis5h 25m
- Horizontal Analysis14m
- Vertical Analysis23m
- Common-sized Statements5m
- Trend Percentages7m
- Discontinued Operations and Extraordinary Items6m
- Introduction to Ratios8m
- Ratios: Earnings Per Share (EPS)10m
- Ratios: Working Capital and the Current Ratio14m
- Ratios: Quick (Acid Test) Ratio12m
- Ratios: Gross Profit Rate9m
- Ratios: Profit Margin7m
- Ratios: Quality of Earnings Ratio8m
- Ratios: Inventory Turnover10m
- Ratios: Average Days in Inventory9m
- Ratios: Accounts Receivable (AR) Turnover9m
- Ratios: Average Collection Period (Days Sales Outstanding)8m
- Ratios: Return on Assets (ROA)8m
- Ratios: Total Asset Turnover5m
- Ratios: Fixed Asset Turnover5m
- Ratios: Profit Margin x Asset Turnover = Return On Assets9m
- Ratios: Accounts Payable Turnover6m
- Ratios: Days Payable Outstanding (DPO)8m
- Ratios: Times Interest Earned (TIE)7m
- Ratios: Debt to Asset Ratio5m
- Ratios: Debt to Equity Ratio5m
- Ratios: Payout Ratio5m
- Ratios: Dividend Yield Ratio7m
- Ratios: Return on Equity (ROE)10m
- Ratios: DuPont Model for Return on Equity (ROE)20m
- Ratios: Free Cash Flow10m
- Ratios: Price-Earnings Ratio (PE Ratio)7m
- Ratios: Book Value per Share of Common Stock7m
- Ratios: Cash to Monthly Cash Expenses8m
- Ratios: Cash Return on Assets7m
- Ratios: Economic Return from Investing6m
- Ratios: Capital Acquisition Ratio6m

- 15. GAAP vs IFRS56m
- GAAP vs. IFRS: Introduction7m
- GAAP vs. IFRS: Classified Balance Sheet6m
- GAAP vs. IFRS: Recording Differences4m
- GAAP vs. IFRS: Adjusting Entries4m
- GAAP vs. IFRS: Merchandising3m
- GAAP vs. IFRS: Inventory3m
- GAAP vs. IFRS: Fraud, Internal Controls, and Cash3m
- GAAP vs. IFRS: Receivables2m
- GAAP vs. IFRS: Long Lived Assets5m
- GAAP vs. IFRS: Liabilities3m
- GAAP vs. IFRS: Stockholders' Equity3m
- GAAP vs. IFRS: Statement of Cash Flows5m
- GAAP vs. IFRS: Analysis and Income Statement Presentation5m

# Ratios: Average Days in Inventory - Online Tutor, Practice Problems & Exam Prep

The average days in inventory measures how long a unit remains in stock before sale, calculated as $365/\mathrm{Inventory}\mathrm{Turnover}$. A lower average indicates efficient inventory management, reducing holding costs associated with warehousing. To find the inventory turnover ratio, divide the cost of goods sold (COGS) by the average inventory, calculated as $\mathrm{Beginning}\mathrm{Inventory}+\mathrm{Ending}\mathrm{Inventory}/2$. Comparing these metrics against industry benchmarks helps assess performance.

### Ratios: Average Days in Inventory

#### Video transcript

ABC Company had $200,000 in Net Sales and Gross Profit of $80,000. If Inventory had a balance of $60,000, what is the company's average days in inventory ratio?

### Here’s what students ask on this topic:

What is the formula for calculating average days in inventory?

The formula for calculating average days in inventory is:

$\frac{365}{\mathrm{InventoryTurnover}}$

This formula helps determine the average number of days a unit remains in stock before being sold. A lower average indicates more efficient inventory management.

How do you calculate the inventory turnover ratio?

To calculate the inventory turnover ratio, use the following formula:

$\frac{\mathrm{COGS}}{\mathrm{AverageInventory}}$

Where COGS is the cost of goods sold, and Average Inventory is calculated as:

$\frac{\mathrm{BeginningInventory}+\mathrm{EndingInventory}}{2}$

Why is it important to compare average days in inventory to industry benchmarks?

Comparing average days in inventory to industry benchmarks is crucial because it helps assess a company's inventory management efficiency relative to its competitors. Different industries have varying norms for inventory turnover, so benchmarking provides context and helps identify areas for improvement. Efficient inventory management reduces holding costs and improves cash flow.

What does a lower average days in inventory indicate?

A lower average days in inventory indicates that a company is efficiently managing its inventory. It means that units are sold quickly, reducing the costs associated with holding inventory, such as warehousing and utilities. This efficiency can lead to better cash flow and profitability.

How do you calculate average inventory?

To calculate average inventory, use the following formula:

$\frac{\mathrm{BeginningInventory}+\mathrm{EndingInventory}}{2}$

This formula provides the average value of inventory over a specific period, which is essential for calculating the inventory turnover ratio.