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 the profitability of company - investment decision, In no more th...

In no more than one typed page, provide a statement of your decision to invest or not invest in this company's stock based on your interpretation of the company's long-term prospec

Concepts in accounting, J inherited 30000 & decides to open a saloon.1/4/20...

J inherited 30000 & decides to open a saloon.1/4/2016.under jasper.commits 10000 to the business .opens a a/c in the bank as jasper. What will be th capital amount in his books o

Vertical anaylsis, Income Statement 2013 2012 2011 Vertical Anaylsis Vertic...

Income Statement 2013 2012 2011 Vertical Anaylsis Vertical Anayl Horizontal Net revenue 5,075,390 4,763,180 4,158,507 year 1 year 2 Anaylsis Cost of goods 1,377,242 1,297,102 1,134

How much would the income from operation, Materials used by Company X in pr...

Materials used by Company X in producing Division A's product are currently purchased from outside suppliers at a cost of $30 per unit. But the same materials are available from Di

Journal entry, Clemens Cars' job cost sheet for job A40 shows that the cost...

Clemens Cars' job cost sheet for job A40 shows that the cost to add security features to a car was $10,500. The car was delivered to the customer, who paid $14,900 in cash for the

Record the estimated bad debts expense, At year-end (December 31), Chan Com...

At year-end (December 31), Chan Company estimates its bad debts as 0.30% of its annual credit sales of $753,000. Chan records its Bad Debts Expense for that estimate. On the follow

Prepare traditional income statement, Scottsdale Fine Piano%u2019s purchase...

Scottsdale Fine Piano%u2019s purchases pianos from a well-known manufacturer and sells them through their retail store. The Baby Grand Pianos sell, on average, for $2,500 each. The

Determine the total cost of hiring and layoff, A company has the following ...

A company has the following forecast demand for the next five months: 1,600, 2,400, 3,200, 2,800, and 2,400. The following information is also available.                  curren

Calculate marginal tax rate, Rogers Communication is considering whether to...

Rogers Communication is considering whether to take advantage of historically low Canadian interest rates and lower its cost of debt by refunding its old bonds. Rogers has a $50mil

What is amount per share, Q. What is Amount per share? Par Value - Amou...

Q. What is Amount per share? Par Value - Amount per share set in ARTICLES OF INCORPORATION of a CORPORATION to be entered in CAPITAL STOCKS account where it's left permanently

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