Turnover rate per category
|
The turnover rate per category is used as one of the primary KPIs when working with ABC Analyzer. WHAT: The turnover rate is calculated as ”Cost value/Average stock value”. This recipe makes sure that you’ll see the correct turnover rate per item number and per ABC category. If you choose to use the formula window in ABC Analyzer, remember to put a checkmark in the box at the bottom to see the correct turnover rate per category. WHY CALCULATE THE TURNOVER RATE PER CATEGORY? Your turnover rate varies between the different ABC categories, and the total turnover rate for your stock is only an overall indication of whether your warehouse is correctly optimized. By calculating the turnover rate per category, you’ll get tools to steer by in your everyday worklife. For some ABC categories you may want a high turnover rate, while you can accept a lower for others. COLUMNS NEEDED IN THE CALCULATION:
FORMULA: [Cost value 12 months]/[Average stock value 12 months] |
Master ABC Categorization
Set up the most frequently used categorization in ABC Analyzer.
Adequacy in days
How long does your current stock go? A week or several years?
Consumption per day
How many items do you sell on average per day?
The item’s age
For how long have you stocked a specific item?
Days since last consumption
When did you last time sell this item? Yesterday or last year?
Stock surplus 12 months (value)
How much of your current stock goes further than a year’s consumption?
Stock surplus 12 months (value)
How much of your current stock goes further than a year’s consumption?
Round up to the nearest pack size
You cannot order half a pallet, so let ABC Analyzer round up to the nearest possible pack- or pallet size for you.
Round up to the nearest pack size
You cannot order half a pallet, so let ABC Analyzer round up to the nearest possible pack- or pallet size for you.