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

Periodic inventory system, Analyse the limitations of using a periodic inve...

Analyse the limitations of using a periodic inventory system and provide examples to support your view. essay type

Prepare a cash budget, Prepare a cash budget The following information...

Prepare a cash budget The following information appeared on the balance sheet of XYZ Ltd at 30 June 2012:                              Accounts receivable

Calculate the loss suffered by the shareholders, In June 2004, Feltex Carpe...

In June 2004, Feltex Carpets Limited raised NZ $254 million in an initial public offering. Twenty seven months later the company was in receivership, its share price having collaps

Basic interest rate and maximum interest rate, Suppose a risk neutral agent...

Suppose a risk neutral agent has $100,000 today that he wants to save for one year. Compare the following two savings plans. Bank A offers a standard savings account with 4% p.a

Dividends out of the capital profits , Dividends out of the capital profits...

Dividends out of the capital profits Dividends out of the capital profits are apportioned on the same basis as dividends out of income (Re. Doughty). (a) Variation of sec

Prepare journal entry to record the accrued biweekly payroll, Stark Company...

Stark Company has five employees. Employees paid by the hour receive a $10 per hour pay rate for the regular 40-hour work week plus one and one-half times the hourly rate for each

Prepare the journal entry at december 31, On December 31, 2004, Internation...

On December 31, 2004, International Refining Company purchased machinery having a cash selling price of $85,933.75. The company paid $10,000 down and agreed to finance the remainde

Permanent accounts would not include in accounts, Permanent accounts would ...

Permanent accounts would not include a interest expense b wage payable c prepaid rent d unearned revenues

Executive, Ask question #EM201683STE718FACMinimum 100 words accepted#

Ask question #EM201683STE718FACMinimum 100 words accepted#

Analyse the main sources of finance , Consider a multinational listed compa...

Consider a multinational listed company that has recently carried out an acquisition. You may also select a company that carried out an acquisition long ago as long as there is inf

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