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
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
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
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.