Overview
This actionable metric indicates how many times your stock turns over per year.
...
Eg re formula below based upon what the number of Days to Access has been set in the system reference 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
| Expand | ||
|---|---|---|
| ||
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
|
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. |
...