The Inventory Levels Dashboard provides a window into your operation and enables you to manage all the moving parts. By default, this dashboard displays data for the last 90 days, however, the date filter can be used to analyze inventory movement over a select period of time.
Skip to:
_________________________________________________________________________
How This Dashboard Can be Used
This Dashboard can be used to:
- Track inventory levels across all locations
- Identify your top-selling items and breadwinner products
- Forecast your inventory based on recent sales trends
- Monitor potential sales lost or gained due to inventory management skills
NOTE: This dashboard includes clickable Drill-Downs (DD), which allows you to see a more detailed view of the metric card. To reveal the drill-down view on an eligible card, simply click the grid cell or graph point as directed. To return to the original metric card view, click the arrow next to the card name.
_________________________________________________________________________
Metric Cards Explained
Potential Sales Lost
Shows the potential sales lost due to inventory being unsellable or out of stock. This is calculated by multiplying the daily average units sold by the product's price. Once we get that value, we multiply it by the number of days it’s been unsellable or out of stock.
(Daily Avg Sold * Avg Price * Days out of Stock)
_________________________________________________________________________
Days Remaining Trend
Shows how many days your current inventory will last at its current daily average sold ratio.
_________________________________________________________________________
Category Sales
(Requires 1 Brand and Product Type Filter to be selected)
Shows two KPIs based on the brand and product type you select.
- Shows a line graph that plots the amount of revenue gained from that brand over time.
- Shows the percentage of your sales that are generated from the selected product type from that brand over time.
_________________________________________________________________________
Inventory Retail Feed
Shows several KPIs that analyze individual product performance based on historical inventory movement data. We outline each KPI in the following grid. Drill-Downs (DD) are available if you click the product or the product category.
DD: Last 30 Drill By Product
Shows the change in total available units overtime for the drilled-down product or category.
Here are the abridged KPI definitions:
- Monthly ABC Rank / Class Rank - shows the impact of revenue/sales generated for the last 3 months. For an in-depth explanation of how to use the ABC/ XYZ table, click here.
- A = High Sales Value
- B = Medium Sales Value
- C = Low Sales Value
- Demand - shows consistency in demand for the last 3 months. For an in-depth explanation of how to use the ABC/XYZ table, click here.
- X = Consistent demand
- Y = Up and down demand
- Z = Random demand
- Avg % of Category - shows the percentage of gross receipts of the product category that the product’s sales account for.
- Average Price - shows the average unit price the item sold at.
- Current Units - shows the number of units available for an item.
- Daily Avg Units - shows the average number of units sold per day that item was in stock. This calculation does not account for days the item was out of stock.
- Example: (Units Sold) / (Count of Days in Stock)
20 units / 5 days = 4 Units Sold Daily on Avg
- Example: (Units Sold) / (Count of Days in Stock)
- Days Out of Stock - shows the number of days an item was out of stock.
- Estimated Days Remaining - shows the number of days remaining for the product before stock out. This calculation is based on Daily Average Units sold (each day an item is in stock), as well as Current Units remaining.
-
Example:
(Current Units) / (Daily Average Units)
100 Current (available) Units / 10 Units Sold Daily on Avg = 10 Estimated Days Remaining
NOTE: If your Daily Avg Unit falls below 0.10 Units a day, we will not display an estimated days remaining
-
- Suggested Reorder - the suggested reorder quantity per product if you were to order new inventory today. The suggested reorder is based on current units, daily average units sold, 2 weeks of safety stock, and lead time set per distributor in the Distributor Management module. If lead time is not populated per distributor, we assume a 7 day lead time.
-
Example:
((14 Days - Estimated Days) x Daily Avg Units) + (Lead Time x Daily Avg Units) = Suggested Reorder
Estimated Days = 8
Daily Avg Units = 10
Lead Time = 7
((14 - 8) x 10) + (7 x 10) = 60 + 70 = 130
NOTE: If your Daily Avg Unit falls below 0.9 units a day, your estimated day's remaining amount will be 0.
-
- Sellable Units - cumulative number of inventory units in a sellable location.
- Backstock Units - cumulative number of inventory units in a non-sellable or back stock location.
- Last Sale Date - the last day this item was sold.
- Sell-Through Rate - units Sold / (Current Units + Units Sold).
- Return Rate - units Returned / (Current Units + Units Returned)
_________________________________________________________________________
Comments
0 comments
Article is closed for comments.