Overview
This actionable metric indicates how many times your stock turns over per year.As an example, if you have $1200 sales per year and your stock was $100, stock turn would be 1200/100=12 - this means you have sold your stock 12 times 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 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. |
...