{"id":14722,"date":"2022-10-06T15:33:02","date_gmt":"2022-10-06T22:33:02","guid":{"rendered":"https:\/\/michaeljbrumm.com\/dcl-v3\/?p=14722"},"modified":"2024-01-02T09:41:48","modified_gmt":"2024-01-02T17:41:48","slug":"days-in-inventory-dii","status":"publish","type":"post","link":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/inventory\/days-in-inventory-dii\/","title":{"rendered":"Days in Inventory (DII): How to Calculate & More"},"content":{"rendered":"

Days in Inventory<\/span><\/p>\n

 <\/p>\n

The average time for which a company holds its inventory before selling it is determined by \u201cdays in inventory\u201d. Other names prevalent in some organizations are days inventory outstanding, inventory days outstanding or inventory days of supply. Once days in inventory are determined, a company can more accurately determine its efficiency in terms of finances and operations. It also helps to tell how quickly a company can sell its inventory.<\/span><\/p>\n

If the inventory figure is small then it implies that the company is quickly selling its goods. There may be a situation in which a company discovers that its conversion via sales is slow. This can show which products may be moving slowly.\u00a0<\/span><\/p>\n

 <\/p>\n

What is the Definition of Days in Inventory?<\/span><\/p>\n

Days in inventory is a ratio that shows the average number of days it takes a company to turn its inventory into sales. The inventory that\u2019s considered in days in inventory calculations is work in process inventory and finished goods inventory.<\/span><\/p>\n

It\u2019s a company\u2019s average days to sell inventory, basically. The lower the number, the better. That\u2019s less days inventory is held. That means lower inventory carrying cost and less cash is tied up in inventory for less time. And there\u2019s less risk that inventory expires or becomes obsolete.<\/span><\/p>\n

Calculating days in inventory is crucial for any business in order for it to be successful. It is one of the many inventory management techniques that business owners should understand.<\/span><\/p>\n

 <\/p>\n

The Formula for Days in Inventory<\/span><\/p>\n

 <\/p>\n

In order to calculate the days in inventory you just have to divide the average inventory by the COGS (cost of goods sold) in a day. The average inventory is calculated by coming up with the average between the inventory levels at the beginning of an accounting period and the inventory levels at the end of the said accounting period. Note that results from this method are sensitive to how you calculate average inventory. The most common way is to add beginning inventory and ending inventory, then divide by two, for the time period in question.<\/span><\/p>\n

Then, the COGS (cost of goods sold) can be calculated by dividing the total cost of goods sold in a single year by 365 days. On the other hand, the average days to sell the inventory metric is calculated by dividing 365 (the number of days) by the inventory turnover ratio.<\/span><\/p>\n

 <\/p>\n

Why Businesses Should Care About Days in Inventory<\/span><\/p>\n

 <\/p>\n

Businesses should care about days in inventory (sometimes abbreviated DII) for three reasons:<\/span><\/p>\n

    \n
  1. Days in Inventory is a Measure of Efficiency.<\/span>
    \n<\/span>A single number for a single time period may not mean much in isolation, but when DII is tracked over time, it may uncover changes and trends that, in turn, could provide signals about inventory management. For example, a slow and steady decline in DII may be a sign that a new sales strategy is working, while a sudden jump may indicate a problem. (Remember not to diagnose a red flag solely on DII.) DII can also be used to compare similar companies in the same industry during the same time period.<\/span><\/li>\n
  2. Days in Inventory is an Important Component of Cash Management.<\/span>
    \n<\/span>Too much cash tied up in inventory can cause problems elsewhere, such as the inability to pay a supplier on time or invest in a new opportunity because all your money is tied up in inventory. For many businesses, storing inventory may be costly, too. Monitoring DII can help prevent those kinds of issues from happening.<\/span><\/li>\n
  3. Days in Inventory is Important for Inventory Management.<\/span>
    \n<\/span>A business can use the backward-looking formula to see how it did in the last quarter or year, but applying the same logic to sales projections and current inventory levels \u2014 especially when tracked precisely in an enterprise resource planning (ERP) system \u2014 offers a window into where the business is heading as well.<\/span><\/li>\n<\/ol>\n

     <\/p>\n

    DII calculations matter more for companies that deal primarily or exclusively in physical goods, and especially so for those that sell perishable inventory. Days in inventory drifting too high for products that go bad and become worthless could result in huge monetary losses, as opposed to more standard inventory, where upward DII means the business will likely incur slightly too high carrying costs and slightly too low liquidity.<\/span><\/p>\n

     <\/p>\n

    What Does a High or Low Days Inventory Mean?<\/span><\/p>\n

    A high days inventory outstanding specifies that a company is incapable of rapidly transforming its stock into sales. Its reasons can be the acquisition of a lot of inventory or poor sales performance.<\/span><\/p>\n

    A low days inventory outstanding specifies that a company can more rapidly transform its inventory into sales. Hence, a low DII indicates a more efficient sales performance and inventory management business.<\/span><\/p>\n

    Too low inventory is disadvantageous to a company because the stock might turn obsolete and inferior. On the other hand, holding surplus inventory negatively influences the company\u2019s capital.<\/span><\/p>\n

     <\/p>\n

    Other Names for Days in Inventory<\/span><\/p>\n

    There are many ways to refer to days in inventory. They all have their own acronyms, which may make you think they\u2019re different from DII in some way. While they aren\u2019t necessarily different, they can sometimes be used in different contexts.<\/span><\/p>\n

     <\/p>\n

    Days Sales In Inventory: (DSI)<\/span><\/p>\n

    You will see days sales in inventory, or DSI frequently. Days sales in inventory is a measure of the average time in days that it takes a business to turn inventory into sales.<\/span><\/p>\n

    Referring to this metric as \u201cDSI\u201d specifically is often done when companies want to emphasize how many days the current stock of inventory will last.<\/span><\/p>\n

     <\/p>\n

    Days Inventory Outstanding: (DIO)<\/span><\/p>\n

    Days inventory outstanding, or DIO, is another term you\u2019ll come across. It\u2019s the same exact financial ratio as days in inventory or DSI, and it measures average inventory turn-in days. DIO is often used interchangeably with DSI.<\/span><\/p>\n

     <\/p>\n

    Inventory Days On Hand: (DOH)<\/span><\/p>\n

    DOH stands for inventory days on hand. It\u2019s interchangeable with DII, DSI, and DIO. DOH measures the number of days inventory remains in stock\u2014or on hand.<\/span><\/p>\n

     <\/p>\n

    Inventory Turnover Days<\/span><\/p>\n

    Inventory turnover days is yet another way to refer to the average days it takes companies to turn their inventory into sales. But this synonym often comes with some confusion. It has the word \u201cturnover\u201d in it. So what\u2019s the difference between inventory turnover days and inventory turnover?<\/span><\/p>\n

    Inventory turnover ratio shows how quickly a company receives and sells its inventory. Sell through rate is similar. The higher the number, the better. Inventory turnover days, on the other hand, calculates the average number of days a company takes to sell its inventory. The lower the number, the better. They are related, yet the inverse of each other.<\/span><\/p>\n

     <\/p>\n

    Bottom Line<\/span><\/p>\n

    There are risks associated with decreasing your days in inventory on hand, so it\u2019s important to determine your business\u2019s particular risk tolerance. Not carrying enough inventory can lead to stockouts, lost sales, and ultimately lost customers. If a shopper lands on your site for the first time and is greeted with an out of stock notification, they will likely find what they\u2019re looking for somewhere else.<\/span><\/p>\n

    To avoid issues like these it is important to monitor inventory levels and turn off marketing campaigns and promotions when inventory is low. Ultimately you have to weigh the risk of missed sales opportunities against the increased profit potential to make the best decision for your business.<\/span><\/p>\n

     <\/p>\n

    Help with inventory management is one of the many benefits to working with a 3PL. If you are seeking logistics support we\u2019d love to hear from you. You can read <\/span>DCL\u2019s list of services<\/span><\/a> to learn more, or check out <\/span>the many companies we work with<\/span><\/a> to ensure great logistics support. <\/span>Send us a note<\/span><\/a> to connect about how we can help your company grow.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

    Days in Inventory   The average time for which a company holds its inventory before selling it is determined by \u201cdays in inventory\u201d. Other names prevalent in some organizations are days inventory outstanding, inventory days outstanding or inventory days of supply. Once days in inventory are determined, a company can more accurately determine its efficiency […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":""},"categories":[107],"tags":[2050],"class_list":["post-14722","post","type-post","status-publish","format-standard","hentry","category-inventory","tag-calculators-formulas"],"acf":[],"yoast_head":"\nDays in Inventory (DII): How to Calculate & More | DCL Logistics<\/title>\n<meta name=\"description\" content=\"Days in inventory (DII) is an inventory management formula that indicates the average time in days that a company takes to turn its inventory.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/inventory\/days-in-inventory-dii\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Days in Inventory (DII): How to Calculate & More\" \/>\n<meta property=\"og:description\" content=\"Days in inventory (DII) is an inventory management formula that indicates the average time in days that a company takes to turn its inventory.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/inventory\/days-in-inventory-dii\/\" \/>\n<meta property=\"og:site_name\" content=\"DCL Logistics\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DCLLogistics\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-06T22:33:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-02T17:41:48+00:00\" \/>\n<meta name=\"author\" content=\"Hadleigh Reid\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dcl_logistics\" \/>\n<meta name=\"twitter:site\" content=\"@dcl_logistics\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Hadleigh Reid\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Days in Inventory (DII): How to Calculate & More | DCL Logistics","description":"Days in inventory (DII) is an inventory management formula that indicates the average time in days that a company takes to turn its inventory.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/inventory\/days-in-inventory-dii\/","og_locale":"en_US","og_type":"article","og_title":"Days in Inventory (DII): How to Calculate & More","og_description":"Days in inventory (DII) is an inventory management formula that indicates the average time in days that a company takes to turn its inventory.","og_url":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/inventory\/days-in-inventory-dii\/","og_site_name":"DCL Logistics","article_publisher":"https:\/\/www.facebook.com\/DCLLogistics\/","article_published_time":"2022-10-06T22:33:02+00:00","article_modified_time":"2024-01-02T17:41:48+00:00","author":"Hadleigh Reid","twitter_card":"summary_large_image","twitter_creator":"@dcl_logistics","twitter_site":"@dcl_logistics","twitter_misc":{"Written by":"Hadleigh Reid","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/inventory\/days-in-inventory-dii\/#article","isPartOf":{"@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/inventory\/days-in-inventory-dii\/"},"author":{"name":"Hadleigh Reid","@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/#\/schema\/person\/da6717f42cf9f668559023de5ff93aa6"},"headline":"Days in Inventory (DII): How to Calculate & More","datePublished":"2022-10-06T22:33:02+00:00","dateModified":"2024-01-02T17:41:48+00:00","mainEntityOfPage":{"@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/inventory\/days-in-inventory-dii\/"},"wordCount":1323,"publisher":{"@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/#organization"},"keywords":["Calculators & Formulas"],"articleSection":["Inventory"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/inventory\/days-in-inventory-dii\/","url":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/inventory\/days-in-inventory-dii\/","name":"Days in Inventory (DII): How to Calculate & More | DCL Logistics","isPartOf":{"@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/#website"},"datePublished":"2022-10-06T22:33:02+00:00","dateModified":"2024-01-02T17:41:48+00:00","description":"Days in inventory (DII) is an inventory management formula that indicates the average time in days that a company takes to turn its inventory.","breadcrumb":{"@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/inventory\/days-in-inventory-dii\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/inventory\/days-in-inventory-dii\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/inventory\/days-in-inventory-dii\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/michaeljbrumm.com\/dcl-v3\/"},{"@type":"ListItem","position":2,"name":"Days in Inventory (DII): How to Calculate & More"}]},{"@type":"WebSite","@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/#website","url":"https:\/\/michaeljbrumm.com\/dcl-v3\/","name":"DCL Logistics","description":"Logistics and Fulfillment Experts","publisher":{"@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/michaeljbrumm.com\/dcl-v3\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/#organization","name":"DCL Logistics","url":"https:\/\/michaeljbrumm.com\/dcl-v3\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/#\/schema\/logo\/image\/","url":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-content\/uploads\/2023\/05\/DCL-Icon-Transparent.png","contentUrl":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-content\/uploads\/2023\/05\/DCL-Icon-Transparent.png","width":153,"height":153,"caption":"DCL Logistics"},"image":{"@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DCLLogistics\/","https:\/\/x.com\/dcl_logistics","https:\/\/www.linkedin.com\/company\/dcl\/"]},{"@type":"Person","@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/#\/schema\/person\/da6717f42cf9f668559023de5ff93aa6","name":"Hadleigh Reid","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c5013befad8eff04fe16ec86f138a6ce6ad76a1e7ead9470408af4a80a6e5da6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c5013befad8eff04fe16ec86f138a6ce6ad76a1e7ead9470408af4a80a6e5da6?s=96&d=mm&r=g","caption":"Hadleigh Reid"},"description":"Hadleigh is the Content Manager at DCL Logistics. He drives the content marketing strategy and writes articles to help ecommerce businesses understand the 3PL and fulfillment world and grow and improve their strategy. Feel free to reach out at hadleighr@dclcorp.com","url":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/author\/hadleigh\/"}]}},"_links":{"self":[{"href":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-json\/wp\/v2\/posts\/14722","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-json\/wp\/v2\/comments?post=14722"}],"version-history":[{"count":0,"href":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-json\/wp\/v2\/posts\/14722\/revisions"}],"wp:attachment":[{"href":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-json\/wp\/v2\/media?parent=14722"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-json\/wp\/v2\/categories?post=14722"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-json\/wp\/v2\/tags?post=14722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}