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

Bond Amortization, How do you show bond amortization on a spreadsheet and t...

How do you show bond amortization on a spreadsheet and then in journal entries and compute interest payments?

Atriculation of Statements, What information goes on each sheet of an Artic...

What information goes on each sheet of an Articulationof statements, i.e. the Data Entry sheet, the Trial Balance sheet, the Single step Income statement, multi-step income stateme

Extent of tests of control, Extent of Tests of Control -Every year AUDITOR ...

Extent of Tests of Control -Every year AUDITOR should obtain sufficient evidence about whether company's internal control over financial reporting, including controls for all inter

Prepare income statement for 2011, The Wanless Corporation provides Interne...

The Wanless Corporation provides Internet consulting services to a wide-range of customers. The company's fiscal year ends on December 31. For the year ended December 31, 2011, the

What is the pretax stock compensation, Refer to the Consolidated Statements...

Refer to the Consolidated Statements of Shareholders' Equity (pp. 62-63), Consolidated Statements of Cash Flow, including an abstract from Note 2, Cash Flow Information (pp. 61 and

Draw x-bar process control chart and calculate probability , Kevin Murtuag...

Kevin Murtuagh, manager of an national reservation service for a nationwide chain of luxury hotels, is concerned about productivity of his operation.  Analysis of recent historical

maximize profit, Natural Furniture Company manufactures three outdoor prod...

Natural Furniture Company manufactures three outdoor products, benches, chairs, and tables. Every product must pass by the following departments before it is shipped: sanding, sawi

Make journal entries required to dispose off, make journal entries require...

make journal entries required to dispose off over or under applied manufacturing overhead assuming it is allocated among work in process, finished goods and cost of goods sold ba

Why convertibles might be an attractive source, Q. Why convertibles might b...

Q. Why convertibles might be an attractive source of finance for companies? - Convertibles is able to provide immediate finance at lower cost since the conversion option effect

Ledger, “Ledger is said to be the principal book entry and the transactions...

“Ledger is said to be the principal book entry and the transactions can even be directly entered into the ledger account.” Elaborate and explain why journal is necessary.

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