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

Australi a, i ordered case study 1 susam and malcom. when i open the docume...

i ordered case study 1 susam and malcom. when i open the document is completely different, not the same case study an is only relivent in the usa not australia... do you have the c

Leverage and coverage ratios, Leverage and Coverage Ratios   (The dat...

Leverage and Coverage Ratios   (The data for interest coverage are in I-Metrix's liquidity ratios section.  The others listed in this table are in the leverage ratios section

Funding venture capital, Funding Venture Capital Whenever a company's ...

Funding Venture Capital Whenever a company's directors look for support from a venture capital institution, so they must distinguish that as: a) The institution will would

Example of miller-orr model, Example of Miller-Orr Model XYZ's managem...

Example of Miller-Orr Model XYZ's management has put the minimum cash balance to be equivalent to Sh.10, 000. The standard deviation of daily cash flow is of Sh.2, 500 and the

Asset based valuation, Asset Based Valuation  This method acquires int...

Asset Based Valuation  This method acquires into account the entire business along with reference to its assets and then divides the resultant value via the number of shares i

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

Finance model paper questions, 1.  Suppose you would like to buy a house an...

1.  Suppose you would like to buy a house and you decided you can pay 3500 per month for 30 years.  Your bank has approved you for a 30-year fixed rate mortgage loan at a quoted AP

Binomial and continuous model - mathematics of finance, Consider a binomial...

Consider a binomial model of a risky asset with the parameters r = 0:06, u = 0:059, d = 0:0562, S 0 = 100, T = 1, 4t = 1=12. Note that u and d are monthly effective rates of retur

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