ABC Analysis of Inventory with Industrial Example

ABC Analysis of Inventory with Industrial Example:

Hi Readers! Here, we are going to discuss one of the popular inventory management systems, which is nothing namely called ABC Analysis of Inventory. As you know that in the industry managing stock of raw materials, bop, WIP, semi-finished products, and the finished product is a matter, if you don’t have any control over inventory then a huge amount of product or material stock, Space consumption, and money consumption for a certain period will be there. That-why proper inventory control or management should be there in place so that you can get the benefit from low inventory costs.

Free Download of Quality Template / Format

Benefits of Inventory management or control:

  • Low Inventory Cots
  • Preventing stock issues
  • Better space control
  • Eliminates duplication in ordering
  • Better utilization of stocks
  • Reduces stock holding costs

To achieve maximum benefits with minimum efforts, it is essential to manage inventory control, so here, we are going to discuss the step-by-step process of abc analysis of inventory control.

ABC Analysis of Inventory with Industrial Example:

ABC analysis classifies a large number of items in inventory into three categories- A-class, B-class, and C-class items. The classification is based on annual usage in value. ABC analysis aims to reduce the cost of managing inventory by controlling the inventory of a few high-value items. The abc analysis technique is based on the Pareto chart law. A higher contribution of annual usage is because of low items. These high annual usage inventory values should be paid more attention.

Class or CategoryAnnual Usage (Not limited to)
A-Category70-80%
B-Category15-25%
C-Category5%

ABC Analysis Example:

For example, the Maintenance department of ABC Limited has recorded the annual usage unit of machine maintenance parts as below for doing the ABC analysis and categorizes the items into A, B & C for better inventory control and minimizing the inventory carrying costs.

ItemAnnual Usage UnitUnit Cost in $
MCP-15000200
MCP-280025
MCP-31500150
MCP-4250060
MCP-5300030
MCP-690018
MCP-7200020
MCP-8120050
MCP-9100040
MCP-10130019
MCP-11600100
MCP-12200040

ABC Analysis of Inventory Steps by Steps Calculation:

Step-1: Calculate the annual usage cost by multiplying the quantity of each item with their respective price.

ItemAnnual Usage UnitUnit Cost in $Annual Usage Cost ($)
MCP-150002001000000
MCP-28002520000
MCP-31500150225000
MCP-4250060150000
MCP-530003090000
MCP-69001816200
MCP-720002040000
MCP-812005060000
MCP-910004040000
MCP-1013001924700
MCP-1160010060000
MCP-1220004080000

Step-2: Rearrange the above items in descending order (largest to smallest).

ItemAnnual Usage UnitUnit Cost in $Annual Usage Cost (xK$)
MCP-150002001000
MCP-31500150225
MCP-4250060150
MCP-530003090
MCP-1220004080
MCP-812005060
MCP-1160010060
MCP-720002040
MCP-910004040
MCP-1013001924.7
MCP-28002520
MCP-69001816.2
Step-3: Calculate the cumulative annual usage cost:
ItemAnnual Usage UnitUnit Cost in $Annual Usage Cost (xK$)Cum. Annual Usage Cost (xK$)
MCP-1500020010001000
MCP-315001502251225
MCP-42500601501375
MCP-5300030901465
MCP-12200040801545
MCP-8120050601605
MCP-11600100601665
MCP-7200020401705
MCP-9100040401745
MCP-1013001924.71769.7
MCP-280025201789.7
MCP-69001816.21805.9

Step-4: Calculate the cumulative percentage

ItemAnnual Usage UnitUnit Cost in $Annual Usage Cost (xK$)Cum. Annual Usage Cost (xK$)Cum. Percentage %
MCP-150002001000100055.37
MCP-31500150225122567.83
MCP-4250060150137576.14
MCP-530003090146581.12
MCP-1220004080154585.55
MCP-812005060160588.88
MCP-1160010060166592.20
MCP-720002040170594.41
MCP-910004040174596.63
MCP-1013001924.71769.798.00
MCP-280025201789.799.10
MCP-69001816.21805.9100.00
Step-5: Select the category by “A” by max. 80% contribution, “B” by 25% and “C” by 5%
ItemAnnual Usage UnitUnit Cost in $Annual Usage Cost (xK$)Cum. Annual Usage Cost (xK$)Cum. Percentage %Class/Category
MCP-150002001000100055.37A
MCP-31500150225122567.83A
MCP-4250060150137576.14A
MCP-530003090146581.12B
MCP-1220004080154585.55B
MCP-812005060160588.88B
MCP-1160010060166592.20B
MCP-720002040170594.41B
MCP-910004040174596.63C
MCP-1013001924.71769.798.00C
MCP-280025201789.799.10C
MCP-69001816.21805.9100.00C

Note: Based in Cumulative percentage we have selected  “A” category up to 80% contribution, “B” category from 80% to 95%, and “C” category from 95% to 100% contribution.

ABC Analysis of Inventory
Class / CategoryItem
AMCP-1, MCP-3, MCP-4
BMCP-5, MCP-12, MCP-8, MCP-11, MCP-7
CMCP-9, MCP-10, MCP-2, MCP-6

Free Templates / Formats of QM: we have published some free templates or formats related to Quality Management with manufacturing / industrial practical examples for better understanding and learning. if you have not yet read these free template articles/posts then, you could visit our “Template/Format” section. Thanks for reading…keep visiting techiequality.com

Popular Post

Add a Comment

Your email address will not be published. Required fields are marked *

error: Content is protected !!