How to Calculate Days in Inventory

PDF download Download Article
PDF download Download Article

Finding the days in inventory for your business will show you the average number of days it takes to sell your inventory. The lower the number you calculate, the better return on your assets you're getting. If you're not sure where to start, don't worry! Calculating days in inventory is actually pretty straightforward, and we'll walk you through it step-by-step below.

Method 1
Method 1 of 3:

Calculating Inventory Turnover Ratio

PDF download Download Article
  1. Inventory turnover means how many times a business sells and replaces its inventory in a given period of time. A low turnover rate indicates unproductive assets and lower profits. The company is holding on to too much excess inventory because it is not selling fast enough. A high turnover rate may be an indication of lost sales as products may be out of stock when a customer wants to buy them. [1]
    • The components of the formula are cost of goods sold (COGS) and average inventory.
    • The formula for calculating the inventory turnover ratio is .
    • Inventory can also be calculated by dividing sales by inventory. [2]
  2. The cost of goods sold is the direct expense associated with providing a service or producing a product. For the service industry, cost of goods sold includes labor expenses, including wages, taxes and benefits. In retail or wholesale, the cost of goods sold is comprised of merchandise that was purchased from a manufacturer, plus the expenses associated with acquiring, storing, and displaying inventory items.
    • The cost of goods sold is recorded on the income statement. It is recorded as a deduction of revenue and determines the company’s gross margin.
    • It is typically calculated with the formula
    • For example, suppose in a 12 month period, a company has a beginning inventory of $9,000, $20,000 in purchases and an ending inventory of $3,000.
    • Calculate the COGS with the formula .
    • The COGS for that 12 month period is $26,000, and it would be recorded as an offset to revenue on the income statement.
    Advertisement
  3. Average inventory is the median value of inventory within an accounting period. [3] The value of inventory may change significantly within an accounting period. Therefore, it makes sense to calculate the average inventory when comparing inventory to total sales or cost of goods sold. This calculation eliminates confusion from spikes in the inventory level.
    • The formula for average inventory is .
    • For example, suppose in a 12 month period, a company had a beginning inventory of $9,000 and an ending inventory of $3,000.
    • Calculate the average inventory with the formula .
  4. Once you know the COGS and the average inventory, you can calculate the inventory turnover ratio. Using the information from the above examples, in this 12 month period, the company had a COGS of $26,000 and an average inventory of $6,000. To calculate the inventory turnover ratio, you would divide the COGS by the average inventory.
    • This company sold and replaced its inventory 4.33 times in the 12 month period.
    5. Advertisement
Method 2
Method 2 of 3:

Calculating Days in Inventory

PDF download Download Article
  1. Once you know the inventory turnover ratio, you can use it to calculate the days in inventory. Days in inventory is the total number of days a company takes to sell its average inventory. It also determines the number of days for which the current average inventory will be sufficient. Companies use this metric to evaluate their efficiency in using their inventory. [4]
  2. You calculate the days in inventory by dividing the number of days in the period by the inventory turnover ratio. In the example used above, the inventory turnover ratio is 4.33. Since the accounting period was a 12 month period, the number of days in the period is 365.
    • Calculate the days in inventory with the formula .
    • It takes this company 84.2 days to sell its average inventory.
  3. If you have not calculated the inventory turnover ratio, you could simply use the cost of goods sold and the average inventory figures. You would divide the average inventory by the COGS. Then you would multiply that number by the number of days in the accounting period. [5]
    • In the example used above, the average inventory is $6,000, the COGS is $26,000 and the number of days in the period is 365.
    • Calculate the days in inventory with the formula
    • You still get the same answer. It takes this company 84.2 days to sell its average inventory.
    4. Advertisement
Method 3
Method 3 of 3:

Analyzing Days in inventory

PDF download Download Article
  1. The cash conversion cycle measures the number of days it takes a company to convert its resources into cash flow. [6] Days in inventory is the first of three parts for this calculation. The second is the days sales outstanding, which is the number of days it takes the company to collect on accounts receivable. The third part is the days payable outstanding, which states how many days it takes the company to pay its accounts payable. [7]
    • The cash conversion cycle follows cash as it is first turned into inventory and accounts payable, then into sales and accounts receivable, and finally back into cash again. [8]
    • It measures the effectiveness of the company’s management. Having a quick cash conversion cycle shows that management has devised ways to reduce time wasted by the business by keeping items in inventory for a short time and getting payment for goods quickly. Doing both of these requires tightly managed and carefully planned systems.
  2. The number of days in inventory expresses how long a company holds on to its inventory. This clarifies how long a company’s cash is tied up in its inventory. The longer a company holds on to its inventory, the more chances it has of losing money on that investment. Items in inventory can become outdated or they can expire. Also, prices can fall, which devalues the inventory. [9]
    • Holding inventory for a long period also educes return on investment, as excess capital is tied up in inventory during this time.
  3. The number of days in inventory makes more sense as a measure of effectiveness if you compare it with that of other businesses in the same industry. Different kinds of businesses sell their inventory at different rates. Retailers who sell perishable items have a smaller number of days in inventory than a company that sells cars or furniture. Therefore, compare your days in inventory with other businesses in the same industry to determine if you are selling your inventory efficiently. [10]
    • You can also compare your days in inventory with your own historical inventory days calculations. This will help you identify trends, positive or negative, that might be affecting your cash conversion cycle duration.
    4. Advertisement


Expert Q&A

Search
Add New Question
  • Question
    Why is it bad to hold on to inventory?
    Keila Hill-Trawick, CPA
    Certified Public Accountant
    Keila Hill-Trawick is a Certified Public Accountant (CPA) and owner at Little Fish Accounting, a CPA firm for small businesses in Washington, District of Columbia. With over 15 years of experience in accounting, Keila specializes in advising freelancers, solopreneurs, and small businesses in reaching their financial goals through tax preparation, financial accounting, bookkeeping, small business tax, financial advisory, and personal tax planning services. Keila spent over a decade in the government and private sector before founding Little Fish Accounting. She holds a BS in Accounting from Georgia State University - J. Mack Robinson College of Business and an MBA from Mercer University - Stetson School of Business and Economics.
    Keila Hill-Trawick, CPA
    Certified Public Accountant
    Expert Answer
    it isn't necessarily bad if you are going to have enough sales to keep your revenue up. You always want to have some inventory available to fulfill orders. You just don't want to be stuck with inventory that isn't going to sell or may go bad, since that will tie your money up.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 1 Helpful 1
  • Question
    What does a high inventory turnover mean?
    Keila Hill-Trawick, CPA
    Certified Public Accountant
    Keila Hill-Trawick is a Certified Public Accountant (CPA) and owner at Little Fish Accounting, a CPA firm for small businesses in Washington, District of Columbia. With over 15 years of experience in accounting, Keila specializes in advising freelancers, solopreneurs, and small businesses in reaching their financial goals through tax preparation, financial accounting, bookkeeping, small business tax, financial advisory, and personal tax planning services. Keila spent over a decade in the government and private sector before founding Little Fish Accounting. She holds a BS in Accounting from Georgia State University - J. Mack Robinson College of Business and an MBA from Mercer University - Stetson School of Business and Economics.
    Keila Hill-Trawick, CPA
    Certified Public Accountant
    Expert Answer
    It might mean that you don't have enough stock to satisfy customer needs. You could be losing sales if a customer comes to buy things and they're out of stock.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 0 Helpful 1
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Buy a Car Under a Business Name
      How to
      Operate a Manual Pallet Jack
      How to
      Create a Barcode
      Finding a China Manufacturer: Importing & Exporting Product
      How to
      Calculate Safety Stock
      How to
      Get a Resale Number
      How to
      Get a Wholesale License in California
      How to
      Account for Stolen Inventory
      How to
      Buy Direct from a Wholesale Company
      How to
      Write an Inventory Report
      How to
      Import from China into the USA
      How to
      Shrink Wrap a Pallet
      Advertisement

      References

      1. ↑ Keila Hill-Trawick, CPA. Certified Public Accountant. Expert Interview. 30 July 2020.
      2. ↑ http://www.investopedia.com/ask/answers/070914/how-do-i-calculate-inventory-turnover-ratio.asp
      3. ↑ http://www.investopedia.com/terms/a/average-inventory.asp
      4. ↑ https://xplaind.com/548679/days-inventory-on-hand
      5. ↑ http://www.investopedia.com/ask/answers/070914/how-do-i-calculate-inventory-turnover-ratio.asp
      6. ↑ http://www.investopedia.com/terms/c/cashconversioncycle.asp
      7. ↑ http://www.investopedia.com/terms/d/dsi.asp
      8. ↑ http://www.investopedia.com/articles/06/cashconversioncycle.asp
      9. ↑ Keila Hill-Trawick, CPA. Certified Public Accountant. Expert Interview. 30 July 2020.
      1. ↑ http://www.investopedia.com/terms/d/dsi.asp

      About This Article

      Article Summary X

      To calculate days in inventory, find the inventory turnover rate by dividing the cost of goods sold by the average inventory. Then, use the inventory rate to calculate the days in inventory by dividing the number of days in the period by the previously calculated turnover rate. Alternatively, you can divide the average inventory by the cost of goods sold, and multiply by the number of days in the accounting period. For examples and tips on analyzing the days in inventory, read on!

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 702,073 times.

      Reader Success Stories

      • Mudassir Nawaz

        Oct 2, 2020

        "Great gesture, clear understanding with the help of excellent examples, I was too confused but after going through ..." more
      More reader stories Hide reader stories
      Share your story

      Did this article help you?

      Advertisement