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 fieldABC classCumulated ProportionproportionRankUpper Class BoundVolume (ABC UNIT)
Value

choice list

master table

ABC lvl x Unit/Value/Variability

DecimalDecimalDecimalDecimalDecimal
DimensionDFUDFUDFUDFUItem GroupDFU
UoMNumericalPercentagePercentageNumericalPercentageQuantity

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 levelLvl3

ABC Classification usage by GBU - calculation detail


ABC Classificationlevelbased onCluster/groupingCalculationUsage/workspace
NovecareManual ABCDFU

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 PerformanceManual ABC (specific)DFU

2 calculations: 

  • override ABC sold to level by ABC ship to level
  • override the previous calculation 


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 Solutionsnone





Task Sequence

2 different sequences exist:

Forecast Calculate & update ABC class

STATIC IMPORT - DAILY - Update master table for manual Entries