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

What is credit analysis, Q. What is Credit Analysis? Potential credit c...

Q. What is Credit Analysis? Potential credit customers must be carefully screened using such methods as bank references, trade references, credit reports from credit reference

Terms "tangible" and "intangible" , Explain the meaning of the terms "tangi...

Explain the meaning of the terms "tangible" and "intangible" and discuss how these terms are used in describing assets.

Definition of bankruptcy, DEFINITION OF BANKRUPTCY Bankruptcy is another ...

DEFINITION OF BANKRUPTCY Bankruptcy is another key area of accounting . The issues addressed here deal with the properties of an individual (a sole trader or partner in a partner

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

Scope, scope of financial accounting

scope of financial accounting

Benefits of common stock and preferred stock, Evaluate the following statem...

Evaluate the following statements, and explain why you agree or disagree. (a)    In a recent interview, a Wall Street investment banker commented on the infrequent use of Prefer

Sugar and Spice bakery, Perform a business size-up of Sugar and Spice Baker...

Perform a business size-up of Sugar and Spice Bakery. 2. Qualitatively analyze the opportunity of closing the storefront to cater events.

What is completion report, Q. What is Completion Report? The object of a ...

Q. What is Completion Report? The object of a completion report is to compare the cost of work actually constructed with those provided for in the last sanctioned estimate. A com

Explain the term- recording business transactions, Recording Business Trans...

Recording Business Transactions ACCOUNT. An account is an individual record or form to record and précis information for each liability, asset, or owner's equity transactio

Investments carried as trading securities, Did ford realize any gain or los...

Did ford realize any gain or loss from securty sales during 2009?

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