More Inventory Metrics
I appreciate that Finale is continuously improving the product, and I like where you are headed with the dashboard.
In our case, we have other systems that report on sales. We rely on Finale to help us manage our inventory. I'd like to see more inventory metrics. This would include:
1) COGS and gross margin for the period
2) Inventory value by location over time
3) Inventory turns
4) Fill rate
It would also be great to have metrics to help us better manage supply chain execution. This would include:
1) SKUs where days of coverage is less than X (e.g., 14 days) for a given location.
2) SKUs with a significant change in velocity (up or down) by location. Eg, SKUs where the trailing 7 day average velocity has increased or decreased more than 20% over the 30 day average.
3) Purchase orders that are late (Estimated Receive Date has passed)
4) Transfers that are late (Expected Receive date has passed)
Thanks for considering these features!
-
Official comment
We are definitely planning on add a set of inventory metrics and a set of product related metrics. We wanted to get started with the metrics around purchase orders and sales orders since they were generally useful and relatively straight forward to implement.
For the inventory metrics, what are the most important ways to break down COGS and gross margin? We have thought about showing break downs by product category, by sale origin, by sale source, and many other fields on products and sales order.
Similarly inventory turns / days on hand could be broken down by any attributes on the product or potentially by location. Is that important, and if so which attributes are most important?
I hadn't thought about sorting by products by the ratio 7 day vs 30 day sales velocity. As you say that seems like a pretty quick way to identify changes from normal behavior. I'll look to see if we can get that in.
Comment actions -
Inventory turns is a KPI that we track at an aggregate level (ie, across all inventory locations). I currently run reports to pull COGS and inventory values to compute this manually. It would be great if this were a dashboard metric. I suppose it depends upon how your distribution network is configured, but it might be useful to track inventory turns at a location-level.
From a supply chain execution standpoint, it would be immensely helpful if the Finale dashboard could tell us:
1) Which SKUs + Locations have dropped below the Safety Stock Days set in Finale and therefore require extra attention.
2) Which SKUs + Locations have experienced a significant change in velocity (up or down) and therefore require extra attention3) Which Purchase Orders and Transfer Orders are late versus the expected date
-
1. Line graph of item units sold per day - add any item you like, adjust timeline
Shows me "best and worst" in class.
2. Ability to adjust the color of the line for each product displayed in graph above
3. Margin (sell price less avg cost) by day
5. Display sales by category
Showing where to invest marketing and what effects are of product focuses on a daily level
6. Item "health" bar - shows the current QOH vs. Reorder point (level 0) and Reorder Max (100)
7. Add filter to item as "finished good" vs material ingredient
8. Percent of Sales over a time period by item with category colorings:
Shows me what our flagships are and where there's opportunity to develop more products
9. Show sales by state, filter by item:
Shows me where I can control marketing dollars - don't need them in MA but could use some in NM.
Please sign in to leave a comment.
Comments
3 comments