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

Roe - return on equity, ROE - Return on Equity The average of the...

ROE - Return on Equity The average of the industry ROE was 21.38% for 2004, 24.99% for 2005, and 23.56% for 2006. The chart showed that after the acquisition of IBM PC di

Advantage of bill - source of finance, Advantage of Bill - Source of Financ...

Advantage of Bill - Source of Finance Advantages of necessitating a Bill as a Source of Finance They are a faster means of raising finance whether drawer is credible.

Net present value method - dcf technique, Net Present Value Method - DCF Te...

Net Present Value Method - DCF Technique The method discounts outflows and inflows and ascertains the total present value via deducting discounted outflows from discounted inf

Existence of quantity discounts, Existence of Quantity Discounts Recur...

Existence of Quantity Discounts Recurrently, the firm is capable to take benefits of quantity discounts.  Since these discounts affect the price per unit, they influence also

Define the term contractual savings depository institutions, Define the ter...

Define the term contractual savings depository institutions. Contractual savings institutions: Contractual savings institutions obtain funds at periodic intervals onto a

Business activity cycle, Business Activity Cycle The interest rates al...

Business Activity Cycle The interest rates also depend on business cycles as above. Because the economy moves in the four (4) business cycles, such interest rates will shift l

Weighted average cost of capital, Below is information provided for tw...

Below is information provided for two companies, A and B.  Assuming a risk-free rate of 2.5%, an effective tax rate of 40%, and a market risk premium of 5.5%, estimate th

Calculate future value, Your grandparents put $1,000 into a saving account ...

Your grandparents put $1,000 into a saving account for you when you were born 30 years ago. This account has been earning interest at a compound rate of 7%. What is its value today

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