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

Contribution margin , Contribution Margin The Average of the indu...

Contribution Margin The Average of the industry Contribution Margin (CM) was 15.40% for 2004, 14.39% for 2005, and 13.18% for 2006. The chart showed that Contribution Mar

Basic Business Math, A new pet shop wants to apportion their investment mon...

A new pet shop wants to apportion their investment money $132,000 for advertising, building upgrades, and education in the ratio of 5:4:3. How much money does each category get app

Federal funds market-federal funds rate and discount rate, What does reserv...

What does reserve requirements and the discount rate? What the Fed Does: Reserve needs and the Discount Rate The federal funds market Financial market which allows banks

Taxation position and profitability & liquidity, Taxation Position and Prof...

Taxation Position and Profitability & Liquidity Profitability and liquidity A company's capacity to pay dividend will be determined primarily with its capability to creat

Disadvantages of debt finance, Disadvantages of Debt Finance It is...

Disadvantages of Debt Finance It is a conditional finance that is it is not invested along with any approval of lender. Debt finance, whether used in excess may interr

Calculate average price-earnings ratio, Regan Inc., was founded nine years ...

Regan Inc., was founded nine years ago by brother and sister Carrington and Genevieve Regan. The company manufactures and installs commercial heating, ventilation, and cooling (HVA

Financial cycle, what is the applicability of a financial cycle to poultry...

what is the applicability of a financial cycle to poultry?

Determine tax cash flows & irr, An industrial engineer proposed the purchas...

An industrial engineer proposed the purchase of a RFID Fixed Asset Tracking System for the company's warehouse and weave rooms.  The engineer though that the system would provide a

Present annuity & future annuity, John has just retired & she is running ou...

John has just retired & she is running out of cash. Her finanical planner advises her to do reverse mortage to improve her standard of living. The current market value of her self

Income statement-balance sheet and cash flow, Looking at the income stateme...

Looking at the income statement, balance sheet and cash flow statement of the company and relating it with the non financial factors, I have the important observations as below:-

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