Calculate stock levels or define service levels per ABC category.
Advanced columns allow you to customize formulas or enter values per ABC category.
Fx. Eg. excessive stock values
- AA products: Excessive stock = "More than 90 days of consumption"
- CA products (cheap & fast-selling): 365 days
Read more on how you calculate days of consumption
Example: Calculate excessive stock
For each ABC category: How many days should your stock cover?
(Your excessive stock will be calculated using these values.)
Before you can calculate the excessive stock, your data must include: Product age & Consumption per day. If they're not in your dataset already, use recipes to calculate them.
Add a new advanced column
- Click "Edit" / "Columns" / "New advanced column"
- Name your column
- Enter the default value or default formula (will be used if you leave specific categories blank, see screenshot below)
- Enter the desired value or formula for each ABC category
- Click "OK" to save
Make an "Excessive Stock per category"-column
Above you created a column with specific values per ABC category. Insert this in your calculation.
- Create a new column
- Name your column. In this example: "Differentiated stock surplus"
- Insert the advanced column (Table_excessive stock) in the formula
[Cost price (Euro)], if ([Stock quantity] - [Consumption per day] * [TABLE_stocksurplus] <= 0, 0, [Stock quantity] - [Consumption per day] * [TABLE_stocksurplus]) * [Cost price (Euro)])
NB! This is an example. Please do not consider the formula or values as universal truths