Adequacy in days
|
How long does your current stock go? A week or several years? WHAT: This formula calculates the number of days that your stock will last. The calculation is based on data from 12 months. WHY CALCULATE THE ADEQUACY? When you have calculated your stock’s adequacy, you can estimate whether it is correctly compound. Do you for example have a lot of items number with more than 365 days’ consumption? Or have you bought items to several days’ consumption even though the supplier is stabile and able to deliver at short notice? COLUMNS NEEDED IN THE CALCULATIONS:
FORMULA: if([Number in stock]=0, 0, (if(and([Consumption per day]0), 99999 [Number in stock]/[Consumption per day]))) RELATED RECIPE
|
Master ABC Categorization
Set up the most frequently used categorization in ABC Analyzer.
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?
Turnover rate per category
The turnover rate per category is used as one of the primary KPIs when working with ABC Analyzer.
Turnover rate per category
The turnover rate per category is used as one of the primary KPIs when working with ABC Analyzer.
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.