Measure Inventory Performance Using DSI Formula

How To Calculate And Improve Amazon Days Sales In Inventory

DSI Formula To Measure Inventory Performance

Amazon Days Sales In Inventory (DSI) is an excellent way to measure inventory management performance over time. It tells you how well you balance stock levels and sales, move slow-moving products and excess inventory, and keep top sellers in stock. Simply put, maintaining a good DSI ratio encourages and mirrors best inventory management practices.

Efficiently managing your inventory can lead to reduced operational costs, increased profitability, and accelerated business growth. It will also help you ship out orders to your customers more quickly or avoid missing sales due to stockouts.

To understand and calculate your Amazon Days Sales in Inventory, follow along with the guide below.

In this Days Sales In Inventory guide, we’ll take a look at:

What is Amazon Days Sales in Inventory?

Amazon Days Sales In Inventory Meaning

Days Sales in Inventory is also known as:

DSI has different meanings, but it’s most commonly interpreted as a financial metric that indicates the average time (in days) that a business takes to sell its inventory.

This metric is also one way to determine a business’s cash conversion cycle, which is the average days to convert assets into cash.

And in terms of inventory liquidity, DSI reflects the number of days a business’s current stock will last.

A lower DSI ratio is ideal as it implies that your business only needs a shorter amount of time to turn inventory into sales.

What’s the Difference between DSI and Inventory Turnover?

Days Sales in Inventory or Days Inventory Outstanding is similar to Inventory Turnover, which is another way to measure the number of times a business can sell its inventory over a given period (e.g., quarterly and annually).

Inventory Turnover Ratio (ITR) is calculated by dividing the Cost of Goods Sold (COGS) by average inventory. A high ITR is optimal as it means you’re turning inventory into cash quickly during a particular period.

Inventory Turnover is connected to DSI through this formula:

DSI Formula:

(1 / inventory turnover) x (365 days) = DSI

As seen above, DSI is an inverse of ITR. So, a lower DSI means higher ITR and vice versa.

For simplicity and clarity, Inventory Turnover is how often you sell through your inventory, such as 6.5 times in a year, and Days Sales is how many days it takes for your inventory to turn into final sales, such as 56 days.

Pro tip: Click here to learn how to calculate your Inventory Turnover Ratio + tips to improve it.

Why Should You Calculate Your Days Inventory Outstanding Ratio?

Top Reasons To Calculate DSI Ratio

Measures How Fast Your Inventory Moves

Days Sales In Inventory helps you figure out how fast your products move. As you already know, storage and handling of inventory in a warehouse adds a lot of extra cost. If your inventory isn’t turning as quickly as it should, your holding costs will start to pile up. And these costs typically include rent, long-term storage costs, insurance, labor expenses, obsolete inventory write-offs, among many others. When your capital gets tied up in these holding costs, it may disrupt your cash flow.

Pro tip: Listen to this podcast to discover the key strategies for managing your Amazon FBA inventory.

Shows the Liquidity of Your FBA Business

DSI also reflects how liquid your business is, which means it is a crucial financial metric for creditors and investors. The more you turn assets into cash, the greater your cash flows and ROI will be.

Reflects Amazon Inventory Performance

The Amazon Inventory Performance Index (IPI) is an advanced scoring system for assessing how well sellers manage their inventory. The scores range from 0-1000, depending on your FBA business performance. A score of 500 and above means your inventory is performing efficiently, while anything lower than that could result in reduced storage volume space and overage fees.

By staying up to date with your DSI ratio, you can be proactive about the health of your inventory, minimize storage costs, and develop better inventory management practices.

4 Factors That Affect Your Amazon IPI Score

When managing your FBA inventory, it’s essential to keep these four influencing factors in mind to improve and maintain your inventory performance score.

  1. Excess inventory percentage – This influencing factor helps you determine when to put excess units on sale or dispose of them, which may increase your IPI score.
  2. FBA sell-through rate – Sell-through rate is quite similar to inventory turnover in that they both refer to the rate at which you sold out one batch of inventory in a given period. The only difference is that Amazon uses 90 rolling days instead of 365 days to calculate the sell-through rate. So increasing your sell-through rate can also help you boost your IPI score.
  3. In-stock rate – This metric refers to the value you’re getting out of your inventory by keeping replenishable products, specifically the top sellers, in stock. Stocking out on a popular product could not only lower your IPI score, but also lead to lost sales, which means a lost opportunity to improve your inventory performance.
  4. Stranded inventory percentage – Stranded inventory is inventory that is sitting in at an Amazon warehouse to be fulfilled, but the listing is inactive, missing, or incomplete. Therefore, while it remains stranded, Amazon is not able to sell the inventory and it will sit collecting dust on their shelves. Not only do these stranded units incur storage fees without the possibility of being sold, they may reduce your IPI score as well.

Overall, these influencing factors are put in place to give you an idea about what actions you should implement to improve your IPI score and your DSI rate.

Bonus: Read 4 Ways to Improve Your Amazon IPI Score + IPI Updates for more FBA inventory management tips.

How to Calculate Days In Inventory?

Steps To Calculating Your DSI Ratio

You can calculate DSI by dividing average inventory by COGS and then multiplying the dividend by 365 days. To find this end formula often takes using other inventory formulas which make up the component parts of the DSI formula.

Average Inventory Formula

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

Average Inventory Sample

$30,000 + $25,000 ÷ 2 = $27,500

COGS Formula

Beginning Inventory + Purchases During Period - Ending Inventory = COGS

COGS Example

$30,000 + $90,000$25,000 = $95,000

Days Sales in Inventory Formula

Now that you’ve determined the values for Average Inventory and COGS, it’s time to calculate DSI.

DSI Formula

(Average Inventory / Cost of Goods Sold) x (365 days) = DSI

DSI Example

$27,500 ÷ $95,000 x 365 = 105,66 or 106 days

The Days Sales in Inventory for this example is 106. That means in one year; you’re able to sell one batch of inventory almost every four months. Whether that’s good or bad largely depends on the type of industry or product you’re selling.

Pro tip: Optimal DSI rates vary by industry. While a lower ratio is ideal, it’s still best practice to compare your company’s DSI to the ratios of your competitors in the industry. For example, Amazon can be compared to another online retail giant like Shopify regarding sales and inventory performance.

What is a Good DSI Ratio for Retail Businesses?

The Good Days Sales In Inventory For Retail Businesses

The ideal DSI for retailers and online sellers alike will vary depending on the retail business category they’re operating in.

For example, grocery stores usually have a low inventory days rate, whereas fashion and furniture shops have a higher DSI. That’s because grocery stores have plenty of perishable goods that require a rapid turnover rate, or they will become unsellable after the expiry date. On the other hand, fashion stores tend to order their inventory seasonally and put the products on sale during the slower months.

So to see how well you’re managing your inventory, it’s essential to identify your retail category and compare your DSI rate with your industry standards.

What Does Low or High DSI Tell You?

Indications Of High And Low DSI Rate

A business with a low Days Sales in Inventory rate indicates top performance, both in inventory management and sales. It reflects your excellent ability to turn products into sales fast enough to prevent your business from incurring holding costs.

Conversely, a DSI higher than your industry benchmarks indicates either a subpar sales performance or you’re carrying excess inventory that may become obsolete eventually. High DSI may also mean that you’re keeping many units in your warehouse to meet expected demand spikes (due to seasonality). But as long as you increase your sales to get your inventory levels back to a healthy range, you should see your DSI and sell-through rate improve.

Common causes of very high inventory days outstanding rate include:

Want to improve your overall sales and inventory performance?

Consider utilizing an inventory management program that allows you to:

Alternatively, you can also join our Inventory Secrets webinar to learn how to develop an inventory plan, optimize inventory tracking and reordering, and tackle common inventory management mistakes, such as over-ordering and under-ordering.

Inventory Management Software to Improve DSI Ratio

Increase DSI Rate Using SoStocked

Seeing that high DSI rates are often the result of poor inventory management and sales performance, it’s imperative to use an inventory management tool to help you address these problems. And that’s where SoStocked comes in handy. It has the following features:

Schedule a SoStocked demo with our inventory management experts today!

Maintain Excellent Inventory Performance

Maintain And Improve Good DSI

Amazon Days Sales in Inventory is another effective way to measure how well you manage your FBA business. A good rule of thumb is to keep your DSI rate within industry benchmarks.

Anything higher or lower than that indicates you don’t have an effective system in place to convert inventory into sales quickly without running out of stock. Using advanced inventory management software can help you optimize your DSI ratio and automate inventory processes for increased efficiency.

1,000+ Customers. Free Data Migration. 1-on-1 Onboarding.

Need more information?

  1. Send Message: We typically reply within 2 hours during office hours.
  2. Schedule Demo: Dive deeper into the nuances of our software with Chelsea.
  3. Join Live Upcoming Webinar: New to Amazon inventory management? Learn three inventory techniques you can implement right away.

2 Comments

  1. wajahat noor August 14, 2021

Give a Comment

NEW FEATURE: Factor Amazon Restock Limits Into Forecasts