Understanding the "Stock turns per year" metric
- Diane Partridge
- Peter Drill
Overview
This actionable metric indicates how many times your stock turns over per year.
A task 'Refresh cubes' needs to have run to calculate the metrics.
Eg re formula below based upon what the number of Days to Access has been set
Refer Administration>Advanced>System Type> Dashboard-metrics>Code = Stock-turns-per-year-sales-days = 30
Stock turns per year metric excludes non stock products.
Ensure the products are in the right product category.
Polulate onto the Sale Shipment details lines are, the field = Category Type.
Worked EG:
Value shipped at Cost Ex tax with a status of Posted for the last 30 days (from today going back 30 days ) = $3344.25
$3344.25/30 = 111.475 which is the average amount shipped per day (ensure you are looking at the shipment lines that are for stock controlled products only)
111.475 x 365 days = 40688.375 per year
40688.375 / value of hand as per now 1285309.95 (from 14/06/2018 - 14/05/2018) = 0.03
Valued shipped at cost is for stock controlled products only.
It normalises the stock turns to a "per year" basis even if you are basing it on the last month.
You can use whatever number of days you want, but 30 is the default in the system reference type 
The idea is 'this is how many stock turns per year you have based on the sales from the last X days.
Colour Coding
Colour | Definition |
|---|---|
| Green | The stock turns per year varies from the target by less than 2. |
| Yellow | The stock turns per year varies from the target by less than 4. |
| Red | The stock turns per year varies from the target by more than 4. |
Configuration
You can view and change the parameters of this metric (including how far back examine shipments and what the target is) in the dashboard metrics system type.