Days since last consumption
|
When did you last time sell this item? Yesterday or last year? WHAT: This calculation gives you the number of day since last sales/consumption. Use it for example when you have to identify high-frequency items that suddenly do not sell. WHY CALCULATE DAYS SINCE LAST CONSUMPTION? Items, that no customer is buying any longer, takes unnecessary storage space. By calculating days since last consumption you can set up extra categories and/or reports containing items that have not been sold in a given period. You can benefit from creating a report called “Items to be phased out?” or “AA items without sales in 20 days” based on “Days since last consumption”. COLUMNS NEEDED IN THE CALCULATION:
FORMULA: FileDate()-days([Last date of consumption]) |
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?
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.
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.