Calculate the overhead absorption rates, Finance Basics

Assignment Help:

A manufacturing organisation has three production cost centres, the cutting department, the processing department and the finishing department, and two service cost centres, the stores and the canteen.

Budgeted information for the following 6 month period is available as follows:

                                                                        £

Direct materials                                           155,200

Direct labour                  

          Cutting                           15,000

          Processing                      35,000

          Finishing                         10,000

          Canteen                          6,240           66,240       

Indirect materials

Cutting                           25,500

Processing                      10,200

Finishing                           7,300

Stores                                        3,000

Canteen                            2,200         48,200

Indirect labour

Cutting                             4,200

Processing                      10,500

Finishing                           3,000

Stores                                      12,800

Canteen                            4,500       35,000

Rent                                                            12,000

Supervisor's wages                                        12,000

Machinery insurance                                       3,300

Maintenance expenses                                   5,400

The following information is also provided:

 

Total

Cutting

Process'g

Finish'g

Stores

Canteen

Direct labour hours

8,600

2,730

4,550

1,320

-

-

Direct machine hours

11,100

6,500

1,900

2,700

-

-

Floor area

(sq m)

50,000

20,000

18,000

8,000

2,000

2,000

Maintenance hours

 

1,100

400

400

100

100

100

Materials requisitions

1,800

1,200

300

300

-

-

Number of employees

90

20

35

20

5

10

Supervisor's time in each department (hours)

 

960

 

480

 

360

 

90

 

30

 

0

Value of machinery

£150,000

£60,000

£50,000

£30,000

£5,000

£5,000

You are required to:

  1. Create an overhead schedule to show the allocation/ apportionment of the overheads to each of the production and service cost centres.  Show all figures to the nearest whole £.
  2. Reapportion the service cost centre costs to the production cost centres, again showing all figures to the nearest whole £.
  3. Having collected all of the overheads in the production cost centres, calculate the overhead absorption rates for each cost centre, to two decimal places.
  4. Explain how these absorption rates will be used to charge the overheads into production and what adjustments may be required once the actual overhead figures are available.

Related Discussions:- Calculate the overhead absorption rates

Origination fees, jack needs to borrow $1000 for the next year. Bank south ...

jack needs to borrow $1000 for the next year. Bank south will give him the loan at 9%. Suncoast will give him the loan at 7% with a $50 loan orgination fee. First national will giv

Calculate its operating-financial and combine leverage, The operating and c...

The operating and cost data of ABC Ltd. are: Sales Rs. 20,00,000 Vari

Required Return.., Valuing Preferred Stock Gest, Inc has an issue of prefer...

Valuing Preferred Stock Gest, Inc has an issue of preferred stock outstanding that pays a $4.50 dividend every year in perpetuity. If this issue currently sells for for $79.85 per

THE CASE OF THE MISSING BONDS RATING, Three of these companies have bonds t...

Three of these companies have bonds that carry investment - grade ratings. The other 3 companies carry junk - bond ratings. Judging by the information in the table, which 3 compani

Necessity of risk adjusted hurdle rates for companies, Discuss the necessit...

Discuss the necessity of risk adjusted hurdle rates for companies with diverse lines of business. Every company invests in new projects based on the expectation of earnings

Finance calculation, #ques1. Steve and Ed are cousins who were both born on...

#ques1. Steve and Ed are cousins who were both born on the same day, and both turned 25 today. Their grandfather began putting $2,500 per year into a trust fund for Steve on his 20

Financial analysis, Financial analysis: Financial analysis (also defin...

Financial analysis: Financial analysis (also defined to as financial statement analysis or accounting analysis or Analysis of finance) defines to an assessment of the viabilit

Example of replacement of assets, Example of Replacement of Assets Est...

Example of Replacement of Assets Estate Developers purchased a machine five years ago on a cost of £7,500.  The machine had a probable economic life of 15 years at the moment

Calculate effective annual cost, What is the effective annual cost of skipp...

What is the effective annual cost of skipping the discount and paying at the end of the net period for the following credit terms: 6/10, net 70? please show work"

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