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

Corporation accounting oversight board, PCAOB - Public Corporation Accounti...

PCAOB - Public Corporation Accounting Oversight Board, a private-sector, non-profit corporation created by Sarbanes-Oxley Act of 2002, to oversee AUDITORs of public companies in or

What is the turnover needed to earn, a company recorded for the past year a...

a company recorded for the past year a sales of 500,000 and an operating incme of 40,000. What is the turnover needed to earn in order to achieve an ROI of 20%

What is financial risk when company experiencing changes, Financial risk is...

Financial risk is the likelihood of a company experiencing changes in the level of its distributable earnings as a result of the need to make interest payments on debt finance or p

Determine income statement and balance sheet, Prepare an Excel spreads...

Prepare an Excel spreadsheet containing the following: - Construct the next five-year pro-forma statements (income statement and balance sheet). - Estimate annual F

Public debt, effects of public debt on production, d

effects of public debt on production, d

Dissolution of a partnership, Dissolution of a partnership A partnership i...

Dissolution of a partnership A partnership is dissolved when: It is temporary (maybe set up for a given period which has lapsed); One partner notifies the others in writ

Potential sources of finance for very new businesses, Potential sources of ...

Potential sources of finance for very new businesses Initial owner finance is almost always the first source of finance for a business, whether from the owner or from family co

Holding company with a direct shareholding in sub-subsidiary, Holding compa...

Holding company with a direct shareholding in sub-subsidiary company Under this type of structure, both the holding and subsidiary company have some shareholding in the sub-subsi

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