ABC Classification model
creation of data table for each Master table ABC (Unit,Variability, Value) and level (1 or 3)
ABC lvl1
data field specifications :
| data field | ABC class | Cumulated Proportion | proportion | Rank | Upper Class Bound | Volume (ABC UNIT) |
|---|---|---|---|---|---|---|
| Value | choice list master table ABC lvl x Unit/Value/Variability | Decimal | Decimal | Decimal | Decimal | Decimal |
| Dimension | DFU | DFU | DFU | DFU | Item Group | DFU |
| UoM | Numerical | Percentage | Percentage | Numerical | Percentage | Quantity |
ABC master table
Lvl1 and Lvl3 will be the 2 standard levels for ABC calculation.
Master Tables have been renamed in order to create a set of harmonized ABC Class
| DFU level | Lvl3 |
|---|---|
|
|
ABC Classification usage by GBU - calculation detail
| ABC Classification | level | based on | Cluster/grouping | Calculation | Usage/workspace | |
|---|---|---|---|---|---|---|
| Novecare | Manual ABC | DFU | iCM value for the last 12 Month rolling period + Override process (class A) ==> ABC lvl1 (Value) | Bfc BU@Zone | Class A: Manual sold to level Class B/C : Based on iCM value for the past year | Class A : No statistical input in the forcing loop. Sales Team forecast mandatory for the next 4 months (after 4 months, statistical forecast is included in the forcing loop) Class B/C : Statistical forecast included in the forcing loop |
| Aroma Performance | Manual ABC (specific) | DFU | 2 calculations:
| PA - A0. Data Management (New Aroma - ABC Classification override) PA - A2. Calculate Forecast (New Aroma - C Class List) PA . TEST Statistical rounded (Batch size per DFU) + several web workspace | ||
| Technology Solutions | none |
Task Sequence
2 different sequences exist:
Forecast Calculate & update ABC class
STATIC IMPORT - DAILY - Update master table for manual Entries
