Turns

Summary

The turns screen shows you your inventory turns. You can see turns both in unit-based, or value-based (e.g. dollars or your preferred currency).

Four tabs are available:

• By Item-Site
• By Site
• By ABC
• By Hierarchy Level

Column Description

Within the turns screen, each different tab has a set of columns to help show turns info.

Broadly, the numbers are grouped into two groups: unit-based, and value-based.  Different sets of measurements will be important to different companies.  When looking at aggregated values, such as by site, or by hierarchy level, measuring turns by value is usually the better approach.  At the item-site level, either unit or value based measurements are valid.

Clicking on a row will show more detail about turns for that particular selection, including average turns, target turns, and variance between the two.  For context, on hand balance vs targets are shown as well.

Use the Display Options to change interval between turns by Week, Month, Quarter, or Year.

TIP: To see year-to-date Turns, set your interval to "Yearly", and set the start date filter in Filters to January 1 of the current year.

IMPORTANT: Remember that turns are always an ANNUALIZED value.  the COGS and Quantity Sold values shown in the columns are the correct values for the week/month/quarter/year that you have selected in the Display Options.  The Turns quantity shown is annualized, adjusted by using the Measurement Period Days for each period as described in the Turns topic.

 Here is a bit more info on each column.

• Period Date - the start date for the period summarized in this row. When the screen first shows, this will usually be the last complete month.  You can change the interval using the Display Options button at the top of the screen.  If you have changed this to Quarterly, Weekly or Yearly, the date is the start date of that period.
• Qty Sold - what was the qty sold in this period? (Used for unit turns).
• COGS - what was the COGS in this period (Used for value-based turns).
• On Hand - a snapshot of the on-hand quantity of the item taken at the beginning of this period.
• Average On Hand - average on hand quantity over the duration of that time period.
• Target On Hand - your target on hand quantity stored for that item during that time period. Since your target inventory quantity can change over time, such as when an item moves in and out of season, or target turns may also change.
• Unit Turns - turns based on units-based measurement compared to the on-hand snapshot taken at the start of the period; see the Turns topic for details on the different calculations.
• Avg Unit Turns - turns based on the average on hand quantity; see the Turns topic for details on the different calculations.
• Tgt Unit Turns - a target turns value, based on the target on hand quantity, e.g. a theoretical ideal turns value.
• Unit Avg Turns vs Target - this shows the delta between your average turns and target turns, which represents opportunity for improvement in your inventory turns. As your average on hand converges on target inventory, you're getting closer to the ideal situation.
• On Hand $ - inventory value associated with the on-hand quantity captured at the start of the measurement period.
• Avg On Hand $ - average Inventory value associated with the average on hand quantity during the measurement period.
• Tgt On Hand $ - inventory value associated with the target on hand quantity in the measurement period.
• Turns - value-based turns from your on-hand balance. 
• Avg Turns - value-based turns from your average on hand balance.
• Tgt Turns - value-based turns calculated from your target on hand balance.
• Avg vs Target - comparison of your average vs target turns, to represent opportunity for improvement, as with the Unit Avg Turns vs Target.
• Turns vs Target - measurement of the beginning-of-period turns position vs target, again, as a comparative measure.
• Measurement Period Days - the number of days in the measurement period, e.g. 31 days in a month, or ~90 days in a quarter etc. This value is used to convert the COGS or Qty sold into an annualized number for reporting turns as an annual value.