📊 ABC Analysis - Complete Guide

What is ABC Analysis?

The core idea: a small number of items (A) account for the majority of total value.

The Three Categories

Category A - "The Vital Few"

• High-value, low-quantity items
• Require tight control, frequent monitoring, and detailed records
• Examples: expensive machinery parts, premium products, top 20% customers
• Management approach: Weekly/daily review, low safety stock, accurate demand forecasting

Category B - "The Middle Ground"

• Moderate value and moderate quantity
• Require regular but less intensive monitoring
• Examples: standard machine parts, mid-range electrical components
• Management approach: Monthly review, moderate safety stock

Category C - "The Trivial Many"

• Low value, high quantity items
• Require minimal oversight - can be stocked in bulk
• Examples: bolts, lubricants, packaging materials, safety gloves
• Management approach: Quarterly review, high safety stock, bulk ordering

Step-by-Step: How to Perform ABC Analysis

Step 1: Gather Data

• Collect data on all inventory items (item name, unit cost, annual usage/demand)
• Typical time period: 6-12 months of historical data

Step 2: Calculate Annual Consumption Value

Annual Consumption Value = Unit Cost × Annual Quantity Used

Step 3: Sort Items in Descending Order

• Arrange all items from highest to lowest consumption value

Step 4: Calculate Cumulative Percentage

Cumulative % = (Cumulative Value / Total Value) × 100

Step 5: Assign A, B, C Categories

• A = Items that cumulatively account for up to ~70-80% of total value
• B = Items that bring cumulative total from ~80% to ~95%
• C = Remaining items (last 5-10% of value)

Step 6: Apply Appropriate Control Strategies

Practical Numerical Example

• Items A1 + A2 = 72% of value with only 40% of items → Class A
• Items B1 + B2 = 22.5% of value → Class B
• Item C1 = 5.5% of value → Class C

Applications of ABC Analysis

1. Inventory Management - Prioritize ordering and stocking decisions
2. Procurement - Negotiate harder for Class A suppliers
3. Warehouse Layout - Place A items near dispatch for fast picking
4. Customer Segmentation - Identify top 20% customers driving 80% revenue
5. Cost Accounting - Focus cost-reduction efforts on high-value items
6. Stocktaking / Cycle Counting - A items counted more frequently

ABC Analysis + VED Analysis (Extended)

• V = Vital (cannot function without it)
• E = Essential
• D = Desirable

Advantages

• Simple and easy to implement
• Focuses management attention where it matters most
• Reduces inventory costs by optimizing stock levels
• Improves customer service for high-value items
• Helps in better supplier negotiations

Limitations / Disadvantages

• Does not consider criticality - a cheap but vital item gets ignored (e.g., a safety pin in aerospace)
• Ignores lead time variations
• Based on historical data - may not reflect future demand
• Does not account for seasonal fluctuations
• Conflicts with GAAP costing systems

⭐ IMPORTANT NOTES (Exam/Quick Reference)

Note 1: ABC is based on the Pareto Principle (80-20 rule) - 20% items = 80% value.

Note 2: "ABC" can also stand for "Always Better Control" in Indian inventory management terminology.

Note 3: Classification percentages are guidelines, not rigid rules - they can vary by industry.

Note 4: A items need perpetual inventory system; C items can use periodic review.

Note 5: The correct basis for ABC classification is Annual Consumption Value (cost × quantity), NOT just unit price or quantity alone.

Note 6: ABC analysis should be reviewed periodically (at least annually) as item values change.

Note 7: ABC can be applied beyond inventory - to customers, suppliers, tasks, projects - wherever prioritization is needed.

Note 8: Combined ABC-VED matrix is used in hospitals and critical manufacturing to handle items that are cheap but vital.

Real-World Example: Walmart