Example of abc analysis, Financial Accounting

Assignment Help:

Illustration: Dinesh Limited is looking selective control for its inventories. By using the subsequent datas, prepare the ABC plan.

Items                 A           B           C          D          E          F         G

Unit                   8,000     15,000    5,000   7,5000   5,000   7,000    2,500

Unit Cost (Rs.)  5.50     1.70      30.40    1.50      0.65      5.14    51.20

Solution:

 

Item

 

Per Unit

Cost (Rs.)

 

Inventory

 

Total Value

 

 

Cate- gory

 

Units

 

% of

Total

 

Cumul- ative %

 

Total

Cost Rs.

 

% of

Total

 

Cumul- ative %










ABC Analysis:

 

 

C G A F B D E

 

30.40

 

51.20

 

5.50

 

5.14

 

1.70

 

1.50

 

0.65

 

5,000

 

2,500

 

8,000

 

7,000

 

15,000

 

7,500

 

5,000

 

10

15%

5

 

16

30%

14

 

30

 

15 55%

 

10

 

 

 

15%

 

 

45%

 

 

 

 

 

100%

 

1,52,000

 

1,28,000

 

44,000

 

36,000

 

25,000

 

11,250

 

3,250

 

38

70%

32

 

11

20%

9

 

6.38

 

10%

2.80

 

0.82

 

 

 

70%

 

 

90%

 

 

 

 

 

100%

 

 

A

 

 

 

 

 

B C

 

Total

 

 

50,000

 

100%

 

 

4,00,000

 

100%

 

 


Related Discussions:- Example of abc analysis

Calculate pre-tax roi return on investment, Shannon Kampa is in talks with ...

Shannon Kampa is in talks with Resul Ozbayrak Leaseco, a leasing company, to rent store space for new stores that Shannon is considering adding to her high-end natural foods chain.

Calculate the earnings per share, Q. Calculate the earnings per share? ...

Q. Calculate the earnings per share? Dividend cover is a measure of the relationship among dividends and earnings and may be calculated for the whole company or on a per share

Greek Debt Exchange, Greek Debt Exchange On the evening of February 20, 201...

Greek Debt Exchange On the evening of February 20, 2012 private institutional investors, representatives of the IMF, ECB, and European governments agreed to a major "intervention"

What kinds of business ownership exist, What kinds of business ownership ex...

What kinds of business ownership exist? Particular form of business ownership has significant implications for accounting purposes and so it's useful to be clear about the main

Calculate economic profit, Calculate Economic profit: Suppose a monopo...

Calculate Economic profit: Suppose a monopolistically competitive firm is facing the following demand and cost information. a.  If the firm is a profit maximizer, how

A case study on timbertops, Q. A case study on TIMBERTOPS? Cost of cap...

Q. A case study on TIMBERTOPS? Cost of capital Use Ke = Do (1 + g)/ Po + g where g = br Retention rate b = 245 ÷ 442 = 55% Return on capital r = 442 ÷ (1,932 -

Excel., prepare an balance sheet

prepare an balance sheet

The common stock of warner inc, The common stock of Warner Inc. is currentl...

The common stock of Warner Inc. is currently selling at $114 per share. The directors wish to reduce the share price and increase share volume prior to a new issue. The per share

Format for balance sheet, FORMAT FOR BALANCE SHEET The non current asse...

FORMAT FOR BALANCE SHEET The non current assets, current assets and current liabilities sections remain identical to those of a sole proprietorship.  However, the “capital sect

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd