More Inventory Metrics



  • Official comment
    Chris Hondl

    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 Permalink
  • Avatar

    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 attention

    3) Which Purchase Orders and Transfer Orders are late versus the expected date

    Comment actions Permalink
  • Avatar
    Max Poling

    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. 

    Comment actions Permalink

Please sign in to leave a comment.