What is ABC Analysis? - KING OF EXCEL

KING OF EXCEL

KINGEXCEL.INFO ( KING OF EXCEL ) Welcome KINGEXCEL.INFO - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Accounting, Living Skills ...

Monday, January 20, 2020

What is ABC Analysis?

What is ABC Analysis?

ABC analysis is one of the known inventory classification methods available in which inventory is categorized in three classes A, B and C where A being most important, B being important and C being less important. ABC analysis is also known as Pareto Analysis, Pareto rule or 80/20 rule.

ABC analysis must not be confused with Activity Based Costing which is also termed as ABC.
In ABC Inventory analysis, products are categorized on the basis of their importance to the entity rather than their quantity in the warehouse. Importance on the other hand can be judged in difference ways like:
  1. Sales revenue generated by each product
  2. Contribution made by each product
  3. Level of investment or simply cost incurred on each product
  4. NRV of each product
  5. Turnover period of each product
Its up to the management to decide what basis to use for classification but mostly sales revenue or cost basis are used for ABC. One thing to remember however is that inventory is not just stock as it can be anything like creditors, debtors, investments etc. So the use of word inventory is little generic in this analysis and not specifically meant to be units produced or purchased. We can classify debtors on the basis of debt. Similarly we can classify creditors on the basis of amount owed to them.
The main reason why importance based classification so important is that organizations must concentrate more on those items that are more valuable and prove more worthy to entity. For example if entity’s offering many different products to customers is analysed on sales revenue generated by each product, it is observed that the products generating majority of revenues are in minority like, 10% of total units sold generate 90% of revenue.
Understanding what is important and then reinforcing efforts in that direction will benefit entity even more therefore, ABC analysis helps management in identifying such elements.
Have a look at the following data where we know about 49 different products an entity sells with their sales value:
Serial NumberAmount
120,000
217000
314450
412283
510441
68875
77544
86412
95450
104633
113938
123347
132845
142418
152055
161747
171485
181262
191073
20912
21775
22659
23560
24476
25405
26344
27292
28248
29211
30179
31152
32129
33110
3494
3580
3668
3758
3849
3942
4036
4131
4226
4322
4419
4516
4614
4712
4810
499
Ordinarily all 49 are given equal care which in fact is not necessary and might be detrimental to entity. If we find the total of sales from all 49 products we find it to be 133,296
To conduct ABC analysis we need two more columns i.e. one in which cumulative sales are calculated and second that gives the percentage total:
Serial NumberAmountCumulative SalesPercentage
120,00020,00015.00%
21700037,00027.76%
31445051,45038.60%
41228363,73347.81%
51044174,17455.65%
6887583,04962.30%
7754490,59367.96%
8641297,00572.77%
95450102,45576.86%
104633107,08880.34%
113938111,02683.29%
123347114,37385.80%
132845117,21887.94%
142418119,63689.75%
152055121,69191.29%
161747123,43892.60%
171485124,92393.72%
181262126,18594.67%
191073127,25895.47%
20912128,17096.15%
21775128,94596.74%
22659129,60497.23%
23560130,16497.65%
24476130,64098.01%
25405131,04598.31%
26344131,38998.57%
27292131,68198.79%
28248131,92998.97%
29211132,14099.13%
30179132,31999.27%
31152132,47199.38%
32129132,60099.48%
33110132,71099.56%
3494132,80499.63%
3580132,88499.69%
3668132,95299.74%
3758133,01099.79%
3849133,05999.82%
3942133,10199.85%
4036133,13799.88%
4131133,16899.90%
4226133,19499.92%
4322133,21699.94%
4419133,23599.95%
4516133,25199.97%
4614133,26599.98%
4712133,27799.99%
4810133,28799.99%
499133,296100.00%
If we investigate on ABC basis using the revenue contributed by each product we find that out of 49 only 7 products are making up 70% of entity’s revenue. In other words roughly 14% of the total products are generating 70% of revenue and thus considered most important and requires close attention. These 6 products will be classified as “A”.
On the same basis we can find the products that belong to category B and C.
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

No comments:

Post a Comment