Skip to content

Week 2 | Session 5: Inventory Segmentation — Methods, Advanced Approaches & AHP Case

Course: Supply Chain Digitization



Key benefits:

BenefitDescription
Cost optimisationAllocate SC resources precisely where they generate the most value
Improved service levelsSet and maintain the right service level per SKU category
Right storage systemAssign appropriate storage infrastructure per inventory type
Better picking strategyDesign warehouse and DC picking processes based on movement frequency and item characteristics
Operational performanceOverall improvement across fulfilment, replenishment, and inventory accuracy

Section titled “Popular Inventory Segmentation Methods — 4 Traditional Approaches”
Criterion: Revenue Contribution

Classification based on the revenue contribution of each inventory item — the Pareto principle applied to inventory.

SegmentShare of ProductsShare of RevenueManagement Priority
A~20%~80%Highest — tightly monitored, frequent review
B~30%~15%Moderate — regular review
C~50%~5%Lowest — simplified, automated management

Criterion: Speed of Movement

Classification based on the consumption rate and speed of movement through the warehouse.

SegmentShare of ItemsMovement BehaviourAvg Cumulative Stay
F — Fast Moving~10%Very short stay in warehouse; consumed rapidlyLess than 10% of average cumulative stay
S — Slow Moving~30%Moderate movement; stays longer in warehouse~20% of average cumulative stay
N — Non-Moving~50%Stagnant inventory — no consumption for extended period; inventory turnover ratio < 1High cumulative stay

Criterion: Operational Criticality

Classification based on the criticality of each item to business operations — not its value or movement speed.

SegmentMeaningDescription
V — VitalCannot operate without itAbsolutely crucial — business halts if unavailable
E — EssentialVery importantHigh priority after Vital; significant disruption if unavailable
D — DesirableNot strictly necessaryOperations can continue without it, but quality or efficiency suffers

4. XYZ Analysis — Demand Variability-Based

Section titled “4. XYZ Analysis — Demand Variability-Based”
Criterion: Demand Predictability

Classification based on the predictability of demand over time — complementary to ABC analysis.

SegmentDemand BehaviourManagement Approach
XLittle or no variation — highly predictableLean inventory; tight replenishment cycles
YUnsteady demand — but can be predicted to a certain extentModerate safety stock; regular review
ZVery high variation — no discernible trend or causal factorsHigh safety stock; frequent monitoring; hardest to manage

MethodClassification CriterionSegments
ABCRevenue contributionA (high) / B (medium) / C (low)
FSNSpeed of movement / consumption rateF (fast) / S (slow) / N (non-moving)
VEDCriticality to operationsV (vital) / E (essential) / D (desirable)
XYZDemand predictability / variabilityX (stable) / Y (variable) / Z (unpredictable)

Advanced Inventory Segmentation Approaches

Section titled “Advanced Inventory Segmentation Approaches”
Multi-Criteria Methods
  • Linear Programming (LP) or Non-Linear Programming (NLP)
  • Formulates the segmentation problem as a mathematical optimisation model incorporating multiple criteria simultaneously

Used when the problem is too complex for exact mathematical programming:

AlgorithmType
Genetic Algorithm (GA)Evolutionary optimisation
Particle Swarm Optimisation (PSO)Swarm intelligence
Simulated AnnealingProbabilistic local search

Heavily data-driven — well suited to today’s data-rich SC environment:

AlgorithmType
Artificial Neural Networks (ANN)Deep learning
Support Vector Machines (SVM)Supervised classification
Back Propagation NetworksNeural network training
K-Nearest Neighbor (KNN)Instance-based learning
Regression modelsPredictive modelling

Incorporates expert opinion to weigh multiple factors:

MethodDescription
AHP — Analytical Hierarchy ProcessPairwise comparison of criteria to derive priority weights
Fuzzy AHPAHP with fuzzy logic to handle uncertainty in expert judgement
ANP — Analytical Network ProcessExtension of AHP allowing interdependencies between criteria

Combinations of the above — e.g., AHP + ML, GA + LP — used when no single method is adequate alone.


MCDM Framework

AHP organises a complex, multi-factor decision into a hierarchical structure, performs pairwise comparisons of all factors to determine their relative importance, and outputs quantitative, consistent priority weights for each factor. Inputs can come from a single expert or aggregated from multiple experts.

AHP Hierarchical Structure Diagram — Goal → Criteria → Alternatives

  1. Define the problem — state the objective clearly
  2. Develop the hierarchical framework — list all criteria and map their relationships
  3. Construct the Pairwise Comparison Matrix for each level using the Saaty scale (1–9)
  4. Normalise the matrix — calculate criterion weights (the priority vector)
  5. Calculate the Consistency Ratio (CR) using: CR = CI / RI where CI = Consistency Index and RI = Random Index (standard table value based on matrix size)
  6. Check CR: If CR < 0.1 → consistent, proceed. If CR ≥ 0.1 → inconsistent, return to Step 3 and redo the pairwise comparison

Case Study — AHP-Based Inventory Segmentation: XYZ E-tailer

Section titled “Case Study — AHP-Based Inventory Segmentation: XYZ E-tailer”
Case Study
ParameterDetail
CompanyXYZ E-tail — an e-commerce retailer
ConstraintFixed warehouse space under a 3-year contract
Listing policyA product is listed as ‘available’ only if it is physically present in the warehouse
ChallengeManagement wants to expand the product portfolio but warehouse space is limited
Previous policy95% service level maintained uniformly for all SKUs
New planClassify 25 SKUs into 3 groups with differentiated service levels
ToolAHP — to classify 25 SKUs into Class A / B / C

Target service levels under the new classification:

ClassService Level
A95%
B90%
C85%

XYZ E-tailer SKU Data Table — 25 SKUs with values across all 6 criteria


Criteria Summary Table — Direction and description of all 6 AHP criteria

The six criteria used, with their direction of preference:

#CriterionUnitDirection
1Monthly DemandUnits/monthHigher = Better
2Priority of Product CategoryScore 1–10Higher = Better
3Supplier Reliability% perfect ordersHigher = Better
4Profit Margin%Higher = Better
5Lead TimeHoursLower = Better
6Likelihood of Return%Lower = Better

Pairwise Comparison Matrix — 6×6 Saaty Scale Ratings for All Criteria Pairs

Example reading: Monthly Demand vs. Priority of Product Category → Monthly Demand rated 3× more important (Saaty scale = 3).


Step 2 — Normalised Matrix & Criterion Weights

Section titled “Step 2 — Normalised Matrix & Criterion Weights”

Normalised Pairwise Matrix and Criterion Weight (Priority Vector) Table


Criterion Weights Summary — AHP Priority Vector for All 6 Factors


Problem: All six criteria are in different units — they cannot be directly compared or multiplied.

Solution: Normalise all criteria to a 0–1 scale before scoring.

Normalised SKU Data Table — All 25 SKUs with Normalised Scores Across All 6 Criteria



  1. Sort all 25 SKUs by combined SKU Score in descending order (highest → most important)
  2. Calculate cumulative score and the cumulative % of total score for each SKU
  3. Apply cut-offs to assign classes:
    • Class A → top SKUs up to ~60% of cumulative score → 7 out of 25 items → 95% service level
    • Class B → next ~25% of cumulative score → 8 out of 25 items → 90% service level
    • Class C → remaining ~15% → 10 out of 25 items → 85% service level

Final SKU Scores Table — Sorted by Score with Cumulative % and A/B/C Class Assignment

Classification Summary — Count of SKUs per Class and Assigned Service Level


Module 2 Summary — Supply Chain Segmentation (All 5 Sessions)

Section titled “Module 2 Summary — Supply Chain Segmentation (All 5 Sessions)”
SessionTopic Covered
Session 1SC challenges — building the case for why segmentation is needed
Session 28 reasons for segmentation + 7 types of segmentation
Session 3Functional vs. Innovative products → Efficient vs. Responsive SC → Push / Pull / Hybrid → Push-Pull Boundary
Session 4Analytical product segmentation (CoV quadrant) + Kraljic Matrix
Session 5Inventory segmentation — ABC / FSN / VED / XYZ + Advanced methods + AHP multi-criteria classification case