Abc Analysis/Xyz Analysis

ABC analysis is a business term used to define an inventoryation technique often used in material management

ABC analysis provides a mechanism for identifying items which will have a significant impact on overall inventory cost whilst also providing a mechanism for identifying different categories of stock that will require different management and controls When carrying out an ABC analysis, inventory items are valued (item cost multiplied by quantity issued/consumed in period) with the results then ranked. The results are then grouped typically into three bands. These bands are called ABC codes.

ABC codes

“A class” inventory will typically contain items that account for 80% of total value, or 20% of total items.

“B class” inventory will have around 15% of total value, or 30% of total items.

“C class” inventory will account for the remaining 5%, or 50% of total items.

ABC Analysis is similar to Praetor the “A class” group will typically account for a large proportion of the overall value but a small percentage of the overall volume of inventory.

The ABC classification process is an analysis of a range of objects, such as finished products, items lying in inventory or customers into three categories. It’s a system of categorization, with similarities to Pareto analysis, and the method usually categorizes inventory into three classes with each class having a different management control associated:

A – outstandingly important; B – of average importance; C – relatively unimportant as a basis for a control scheme.

Each category can and sometimes should be handled in a different way, with more attention being devoted to category A, less to B, and still less to C.

Popularly known as the “80/20” rule ABC concept is applied to inventory management as a rule of-thumb. It says that about 80% of the Rupee value, consumption wise, of an inventory remains in about 20% of the items.

This rule , in general , applies well and is frequently used by inventory managers to put their efforts where greatest benefits , in terms of cost reduction as well as maintaining a smooth availability of stock, are attained.

The ABC concept is derived from the Pareto’s 80/20 rule curve. It is also known as the 80-20 concept. Here, Rupee / Dollar value of each individual inventory item is calculated on annual consumption basis.

Thus, applied in the context of inventory, it’s a determination of the relative ratios between the number of items and the currency value of the items purchased / consumed on a repetitive basis.

10-20% of the items (‘A’ class) account for 70-80% of the consumption

the next 15-25% (‘B’ class) account for 10-20% of the consumption and

the balance 65-75% (‘C’ class) account for 5-10% of the consumption

‘A’ class items are closely monitored because of the value involved (70-80% !).

High value (A), Low value (C), intermediary value (B)

20% of the items account for 80% of total inventory consumption value (Qty consumed X unit rate)

Specific items on which efforts can be concentrated profitably

Provides a sound basis on which to allocate funds and time

A,B & C , all have a purchasing / storage policy – “A”, most critically reviewed , “B” little less while

“C” still less with greater results.

ABC Analysis is the basis for material management processes and helps define how stock is managed. It can form the basis of various activity including leading plans on alternative stocking arrangements (consignment stock), reorder calculations and can help determine at what intervals inventory checks are carried out (for example A class items may be required to be checked more frequently than c class stores

 Inventory Control Application: The ABC classification system is to grouping items according to annual issue value, (in terms of money), in an attempt to identify the small number of items that will account for most of the issue value and that are the most important ones to control for effective inventory management. The emphasis is on putting effort where it will have the most effect.

High value (A), Low value (C) , intermediary value (B)

A Items: These Items are seen to be of high Rupee consumption volume. “A” items usually include 10-20% of all inventory items, and account for 50-60% of the total Rupee consumption volume.

 B Items: “B” items are those that are 30-40% of all inventory items, and account for 30-40% of the total Rupee consumption volume of the inventory. These are important, but not critical, and don’t pose sourcing difficulties.

C Items: “C” items account for 40-50% of all inventory items, but only 5-10% of the total Rupee consumption volume. Characteristically, these are standard, low-cost and readily available items.

ABC classifications allow the inventory manager to assign priorities for inventory control. Strict control needs to be kept on A and B items, with preferably low safety stock level. Taking a lenient view, the C class items can be maintained with looser control and with high safety stock level. The ABC concept puts emphasis on the fact that every item of inventory is critical and has the potential of affecting, adversely, production, or sales to a customer or operations. The categorization helps in better control on A and B items.

In addition to other management procedures, ABC classifications can be used to design cycle counting schemes. For example, A items may be counted 3 times per year, B items 1 to 2 times, and C items only once, or not at all.

Suggested policy guidelines for A , B & C classes of items

A items (High cons. Val)B items (Moderate cons. Val)C item (Low cons. Val)
Very strict cons. ControlModerate controlLoose control
No or very low safety stockLow safety stockHigh safety stock
Phased delivery (Weekly)Once in three monthsOnce in 6 months
Weekly control reportMonthly control reportQuarterly report
Maximum follow upPeriodic follow upExceptional
As many sources as possibleTwo or more reliableTwo reliable
Accurate forecastsEstimates on past dataRough estimate
Central purchasing /storageCombination purchasingDecentralised
Max.efforts to control LTModerateMin.clerical efforts
To be handled by Sr.officersMiddle levelCan be delegated

How to do ABC Analysis / Classification

ABC analysis is a basic supply chain technique, often carried out by inventory controllers/materials managers, and is the starting point in Inventory control.

ABC classification is a system of categorization, with similarities to Pareto analysis and the method usually categorizes inventory into three classes with each class having a different management control associated.

Although different criteria may be applied to each category the typical method of “scoring” an inventory item is that of annual consumption value of said item (Qty consumed X Cost of item) with the result then ranked and then scored (A, B or C).

Classification may be specific to the industry but typically follows a 70%, 90%, 100% banding in that A class items represent 70% of the value, B class items fall between 70% and 90% of the annual value with C class the remaining.

In practical terms the complex high cost materials typically fall into the A class items, with the consumable, low cost (and typically fast moving) classed as C class.

How to carry out the actual analysis?

Carrying out ABC analysis is a bit tricky affair. What ultimately is done is to segregate all the inventory items into three categories viz. A, B & C.

ABC analysis can be done for any given data that has money value as the prime factor. For example classification of pending suppliers’ bills, items of an MRO or any type of inventory, expenditure over a period of time, customers with respect to sale value etc.

Procedural steps:

First of all, collect all the data of the inventory and calculate the consumption or sale value. For a

Stores, maintaining inventory, this shall be Quantity issued X unit rate of an item, say x1. Similarly, get the values for all the remaining items, say, x2,x3,x4….x100 in the following way :

SI. NoItemUnit RateConsumption (Qty) issue
1X11010
2X21210
3X31512
4X4205
5X5302
6X65100
7X7480
8X81612
9X91322
10X10356

Now, arrange all the consumption values in ascending or descending order of values. Let us assume we have listed in descending order (starting with highest consumption value item to lowest consumption value item)

Create next column and start adding the cumulative total of consumption value, starting from the top and finishing with the last item as given in the table below:

Consumption   ValueValue in ascending orderCumulative   ValueItemClass
10060560X5C
1201001160X1C
180100260X4C
100120380X2C
60180560X3C
500192752X8C
320210962X10B
1922861248X9B
2863201568X7A
2105002068X6A

From the last column it is clearly evident that the bottom 20 % of items (x6 & x7) consume together nearly 70% of value, upper 70% (x1, x2, x3, x4, x5, x8) items consume only 20% value and the remaining 10% items (x9) consume 10% value. Respectively, these are A,B and C classes of items

ABC Classification / Analysis of Inventory

The ABC classification process is an analysis of a range of objects, such as finished products, items lying in inventory or customers into three categories. It’s a system of categorization, with similarities to Pareto analysis, and the method usually categorizes inventory into three classes with each class having a different management control associated:

A – Outstandingly important; B – of average importance; C – relatively unimportant as a basis for a control scheme.

Each category can and sometimes should be handled in a different way, with more attention being devoted to category A, less to B, and still less to C.

Popularly known as the “80/20” rule ABC concept is applied to inventory management as a rule of-thumb. It says that about 80% of the Rupee value, consumption wise, of an inventory remains in about 20% of the items.

This rule, in general, applies well and is frequently used by inventory managers to put their efforts where greatest benefits, in terms of cost reduction as well as maintaining a smooth availability of stock, are attained.

The ABC concept is derived from the Pareto’s 80/20 rule curve. It is also known as the 80-20 concept. Here, Rupee / Dollar value of each individual inventory item is calculated on annual consumption basis.

Thus, applied in the context of inventory, it’s a determination of the relative ratios between the numbers of items and the currency value of the items purchased / consumed on a repetitive basis.

10-20% of the items (‘A’ class) account for 70-80% of the consumption

The next 15-25% (‘B’ class) account for 10-20% of the consumption and

The balance 65-75% (‘C’ class) account for 5-10% of the consumption

High value (A), Low value (C), intermediary value (B)

20% of the items account for 80% of total inventory consumption value (Qty consumed X unit rate)

Specific items on which efforts can be concentrated profitably

Provides a sound basis on which to allocate funds and time

A,B & C , all have a purchasing / storage policy – “A”, most critically reviewed , “B” little less while “C” still less with greater results.

ABC Analysis is the basis for material management processes and helps define how stock is managed. It can form the basis of various activity including leading plans on alternative stocking arrangements (consignment stock), reorder calculations and can help determine at what intervals inventory checks are carried out (for example A class items may be required to be checked more frequently than c class stores

Inventory Control Application: The ABC classification system is to grouping items according to

annual issue value, (in terms of money), in an attempt to identify the small number of items that will account for most of the issue value and that are the most important ones to control for effective inventory management. The emphasis is on putting effort where it will have the most effect.

A Items: These Items are seen to be of high Rupee consumption volume. “A” items usually include 10-20% of all inventory items, and account for 50-60% of the total Rupee consumption volume.

B Items: “B” items are those that are 30-40% of all inventory items, and account for 30-40% of the total Rupee consumption volume of the inventory. These are important, but not critical, and don’t pose sourcing difficulties

C Items: “C” items account for 40-50% of all inventory items, but only 5-10% of the total Rupee consumption volume. Characteristically, these are standard, low-cost and readily available items.

ABC classifications allow the inventory manager to assign priorities for inventory control. Strict control needs to be kept on A and B items, with preferably low safety stock level. Taking a lenient view, the C class items can be maintained with looser control and with high safety stock level. The

ABC concept puts emphasis on the fact that every item of inventory is critical and has the potential of affecting, adversely, production, or sales to a customer or operations. The categorization helps in better control on A and B items.

 XYZ Analysis

The XYZ analysis is a procedure of stock management in the management economics, with which on the basis empirical experiences, results are usually assigned to a classification by bill explosions or by the determination by variation and/or fluctuation coefficients of goods and articles concerning its turnover regularity (consumption and its predictableness).

X constant consumption, fluctuations are rather rare

Y stronger fluctuations in consumption, usually for trend-moderate or seasonal reasons

Z completely irregular consumption

The XYZ analysis in the materials requirement Planning (materials requirements planning), in addition, in camp planning and in the calculation is used, frequently combined with the ABC analysis.

XYZ analysis is one of the basic supply chain techniques, often used to determine the inventory valuation inside a Store. It’s also strategic as it intends to enable the Inventory manager in exercising maximum control over the highest stocked item, in terms of stock value. A system of categorization, with similarities to Pareto analysis, the method usually categorizes inventory into three bands with each band having a different management control associated. Although different criteria may be applied to each category the typical method of “scoring” an inventory item is that of annual stock value of said item (qty in stock X cost of item) with the result then ranked and then scored (X, Y or Z).

Bandings may be specific to the industry but typically follow a 70%, 90%, 100% banding in that X class items represent 70% of the stock value (although they may account for 20% number wise), Y class items fall between 70% and 90% of the annual stock value with C class the remaining. In practical terms the complex high cost materials typically fall into the X class items, with the consumable, low cost (and typically fast moving) classed as X class.

Not all stock is equally valuable and therefore doesn’t require the same management focus. The results of the XYZ analysis provide information that helps evaluate how each inventory part should be monitored and controlled. These controls are typically:

X class items which are critically important and require close monitoring and tight control – while this may account for large value these will typically comprise a small percentage of the overall inventory count.

Y class is of lower criticality requiring standard controls and periodic reviews of usage

Z class require the least controls, are sometimes issues as “free stock” or forward holding.

Classification of inventory in terms of XYZ is also quite strategic as It can form the basis of various activity including leading plans on alternative stocking arrangements (consignment stock), reorder calculations and can help determine at what intervals inventory checks are carried out (for example X class items may be required to be checked more frequently than Z class stores.

Based on the ABC and XYZ analysis there is another control mechanism, popularly known as AX control.

AX Control

What is the AX category of items of Inventory?

Inventory plays an important role for any organization as it blocks the working capital which otherwise would have earned the organization some money. While the need for having inventory can’t be denied for any running plant / machinery, its availability in controlled measures too is highly desirable. Control techniques such as ABC and XYZ analyses though done in different ways, try, at the same time, to get maximum control with little commitment of resources.

One of the ways to have still better (tight) control over the inventory with still less commitment of resources is by determining the AX category of items in a given inventory. Once ABC and XYZ analyses have been done and a list of A and X classes of items is drawn then AX category is a combination of the two categories. Going by the definition of A and X separately, AX category of items, normally, display a high consumption (A) as well as a high stock value (X). Essentially, these items are high value, in terms of overall procurement cost including their being costly. Obviously , the measures that need to be taken to keep AX inventory under control is similar to that of A or X items, viz stock less number at any given time, have tight consumption control, more sources so that supply doesn’t become a constraint when needed etc.

Management Of Automatic Procurement Items
Glossary of Materials Management Terms

Get industry recognized certification – Contact us

keyboard_arrow_up
Open chat
Need help?
Hello 👋
Can we help you?