Nov 01, 2022
907
There are often questions regarding the definitions of metrics we display in product tables throughout Bridge.
Using the Inventory Details table on the Inventory dashboard in Bridge, here are the definitions of the columns you’ll find here.
- Name = product name as the store has entered it in their point of sale
- Category = category the product is attached to - as the store has entered it
- Last Sale = the last sale date recorded for this product
- Average Unit Cost = the average cost of the product for the dispensary based on the cost entered at the point of sale
- Average Item Price = the average price the product sold to the consumer for in the date range chosen for this dashboard
- In Stock Average Units Per Day - this is the average units sold per day for the product when it was available. If the item was out of stock at any point in the time frame you chose, those days are not considered in the average
- Total Quantity on Hand - count of units in stock as of today
- In Stock Average Sales Per Day = the average daily revenue this product brought in when it was available in the time frame you chose
- Total Sales = the total revenue this product brought in during the time frame you selected
- Total Units =the total number of units sold in the time frame you selected for this product
- Est Days Remaining = based on the average daily units sold per day, we are showing if the product continues to sell at that pace, the estimated days you have left before it’s out of stock.
- Percent Days In Stock = the percent of your total time frame selected at the top of the report, that the product was actually in stock and available to sell
- Total In Stock Cost = the cost of the products (what the dispensary paid to obtain them) that are in stock today, based on what was entered into the point of sale
- Total In Stock Retail Value = the value of the inventory in stock today. This value is based on the listed price of the product and cannot predict any discounts that may be applied once it sells
- Potential Lost Profit = this represents the potential profit lost for items that are not in stock now but had sales in the time frame you were looking at. See below for an example: