Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

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


 Formula

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
GreenThe stock turns per year varies from the target by less than 2.
YellowThe stock turns per year varies from the target by less than 4.
RedThe 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.

  • No labels