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 the cost per dinner based on average sales, Question: Airways C...

Question: Airways Catering prepares dinner for several airlines, and sales average 500,000 dinners per month. The cost of each dinner is made up principally of the cost of meat

Flexible budget and static budget, Brabham Enterprises manufactures tires f...

Brabham Enterprises manufactures tires for the Formula One motor racing circuit. For August 2011, Brabham budgeted to manufacture and sell 3,000 tires at a variable cost of $74

Explain about credit-worthiness, Q. Explain about Credit-worthiness? Th...

Q. Explain about Credit-worthiness? There are a numerous ways in which Fenton Security plc could ensure that customers are subjected to tighter credit appraisal checks before g

A prior period adjustment, Q. A prior period adjustment that corrects incom...

Q. A prior period adjustment that corrects income of a prior period requires that an entry be made to a. an income statement account. b. a current year revenue or expense account.

One period rate - equilibrium, Suppose that the one-period rate is 4%. Expl...

Suppose that the one-period rate is 4%. Explain why a two-period rate of 6% cannot be an equilibrium when individuals expect the one-period rate to remain constant.

MBA 2nd semester assigenment, Considering the following information, what i...

Considering the following information, what is the price of the share as per Gordon’s Model? Details of the Company Net sales Rs.120 lakhs Net profit margin 12.5% Outstanding prefe

Explain your findings and conclusion, When the stock market is going up ove...

When the stock market is going up over a long period of time, investors can become complacent about the risks of being a stockholder. After the significant decline of the stock mar

Assembly of financial statements, Q. Assembly of Financial Statements? ...

Q. Assembly of Financial Statements? Assembly of Financial Statements -Providing of various accounting or data-processingservices by an accountant, output of which is in the fo

Calculate ß for the intercept-income and noncauc, For this question you wil...

For this question you will use the dataset "murder.xls", which includes: • rate = Murder rate per 100,000 • convictions = Number of convictions divided by number of murders • execu

Inter company balances-group accounts, Inter Company balances One of th...

Inter Company balances One of the companies may appear as receivable (debtor) or payable (creditor) in the other company’s books. Just like in accounting four branches, such in

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