Definition: How many days of stock do you have in inventory TO how many units you expect to sell in the date period selected in the filter. (For every 1 unit I expect to sell, I have (stock_ratio_value) in inventory).

Note: This uses the current units on hand in the equation. The average number of units sold per day is when the product was in stock and the amount of days that's used for that average is determined by the date filter. This also will need ANOTHER date filter to determine how many days of stock is needed for.

Equation: total quantity on hand as of today/ (average number of units sold per day*number of days stock needed for)

Example: There's a whole dashboard dedicated to this concept. This metric is very similar to the estimated days remaining, except with the use of a filter you are able to add in how many days you'd like to cover. The graph below tells you if you need to rush in an order or if you are set up for success. A stock coverage ratio between 0 and 0.75 means you are understocked, you will most likely lose out on sales due to the product not being in stock. Between 0.75 to 1.25, this means you are properly stocked and aren't wasting space with being overstocked and won't lose out on sales because you run out of product. A ratio exceeding 1.25 means you are overstocked and if the ratio is very high retailers might want to consider ways to push their inventory. From the snip below, I might want to consider an apparel sale, since that's the majority of my non-cannabis quantity is coming from, and make more room for beverages to be stocked well.