This dashboard allows you to view inventory metrics for a specific store location during a specific period of time. Some questions you can answer:
Are inventory levels healthy?
Are specific SKUs over/understocked?
How many days until an item is out of stock?
Lost potential revenue for the store?
This chart shows you exactly how many units you had in stock at the selected store on any particular day during the date range selected, broken down by category. Note that categories are determined based on how the retailer has these entered into their POS. Here you can see the changes in inventory whether that is depletion due to sales or an increase due to a restock.
Inventory Scatter Plot:
The inventory scatter plot is a great way to quickly get a high-level overview of inventory health at any given store. By looking at average total sales per day and average units per day, along with current stock levels, we are able to estimate how many days you can continue to sell this product without a reorder. The estimated days remaining is calculated by taking the quantity in stock and dividing it by the average number of units sold per day.
Right away you can see if stock levels are very low (dark red) or if there is an excess or possibly overstocked item (dark green). In the example above, dark red is bad since it indicates low to no stock. On the other hand, it can also indicate a fast-moving product as well and you may need to recommend a larger order next time. Dark green may also be bad as it indicates that a product may be overstocked or not selling well.
You can always click-through on a product to investigate that particular product's history at that store as well.
Example questions to consider when reviewing this:
Is a product priced too high or too low if there has been little or a lot of movement?
Is a similar product moving faster or slower at other stores? If so, could it be due to demographics such as urban vs. rural location? Is a specific store in a tourist heavy area?
Are some of these new products that budtenders have not been educated on, thus the lack of sales?
The goal here is not necessarily to provide answers, but data points to allow you to probe deeper into your business.
The stock history chart is used to visualize the dates that your products were in stock. Long, continuous bars are what you should be aiming for to ensure customers can consistently purchase your products.
The length of the bar represents the amount of time a product was in stock. The color of the bar represents how many units are sold on average each day in the time frame (based on the selected filters). Watch out for fast-moving products that are frequently out of stock. If you see many short bars with gaps between them, this is an indication that you are probably not delivering an appropriate number of units to the store. This also indicates a longer period of time a product was out of stock and these gaps are potentially missed revenue opportunities.
The chart below is a great example of an ideal scenario.
This table allows you to quickly see the history of inventory health for each product for a specific location over a specified period of time. Products are only shown on this table if they have had a sale within the last 60 days OR it is currently in stock. Average item price/units per day is calculated for the selected date range. Total quantity in stock always reflects what is in the store today, regardless of the date range selected. The estimated days remaining is calculated by taking the total quantity in stock divided by the average units per day. Note that the average units per day calculation does not include out of stock days.
You can also easily sort this table in a number of ways by clicking on the chevron in the header of each column. Possibly the most important column on here is lost potential revenue.
To clarify, lost potential revenue is the revenue for the retail store; not the Bridge customer. This number can serve as a great topic to facilitate a conversation with your retailer on how much they are losing by not keeping enough of your products in stock.
Bridge: Details Dashboard
For additional resources and help articles please visit the Headset Help Center.