Inventory Turns on items less than 365 Days Old

lizatesbylizatesby Member Posts: 2

Hi!

As a fashion retail company, all of our product is seasonal. Thus, it's rare that we have any time in stock for 365 days or more. We want to be able to look at the Inventory Turns report so that we can see which styles (matrixes) are selling at the most volume and pace, so that we can identify which styles to quickly reproduce or reallocate in our assortment. The current Turns report is not helpful since any given style of the season is much less than 365 days old, its average inventory over 365 days is quite low, and so the turns information is not accurate.

To find the numbers I'm looking for, I've been taking Lightspeed's turn rate, referencing a separate inventory age report to find the age in days of the good, then multiplying the Lightspeed turn figure by the age relative to 365 days, but of course I'd love to build a report that does this extra steps -- any ideas on how to achieve this?


Thanks!

1 comment

  • runawayshoes_radrunawayshoes_rad Member Posts: 6

    I've found the turn rate equation has been lacking for awhile. They changed the equation a year or two ago, and it helped a little bit, but I'm with you. An accurate turn rate per matrix would be fantastic.

Sign In or Register to comment.