Question

In: Accounting

Welshpool Engineering has two production departments and two support departments. Budgeted data for the year follow. The company does not separate fixed and variable costs.

 

Welshpool Engineering has two production departments and two support departments. Budgeted data for the year follow. The company does not separate fixed and variable costs.

 

Support Departments

Production Departments

 

Maintenance

Power

Drilling

Assembly

Overhead costs

$160,000

$200,000

$81,500

$45,000

Machine hours

-

11,250

15,000

3,750

Kilowatt-hours

20,000

5,000

18,000

162,000

The maintenance department costs are allocated based on machine hours and power department costs are allocated based on kilowatt hours.

Required:

  1. Determine the total overhead costs for each of the production department, after allocation of support department costs, using each of the following allocation methods:
  1. Direct method:
  2. Ratio

    Maintenance

    Power

    Drilling

    Assembly

             
             

    Allocation of costs:

    Overhead costs

    $160,000

    $200,000

    $81,500

    $45,000

             
             
             
             
             

    b.    Step down(sequential) method. (Show your working to determine the ranking of the support   departments)                                                                                                                            

     

    Ratio

    Maintenance

    Power

    Drilling

    Assembly

             
             

    Ranking of Support department:

    Allocation of costs:

    Overhead costs

    $160,000

    $200,000

    $81,500

    $45,000

             
             
             
             
             

     

  3. Reciprocal method
  4.  

     

    Ratio

    Maintenance

    Power

    Drilling

    Assembly

             
             

    Allocation of costs:

    Overhead costs

    $160,000

    $200,000

    $81,500

    $45,000

             
             
             
             
             

     

    2.      Which method would the production manager of the Assembly Department prefer and why? Which method most accurately allocates support department costs and why?  

                                                                                                                         

Solutions

Expert Solution


Related Solutions

Reciprocal Method Eilers Company has two producing departments and two support departments. The following budgeted data...
Reciprocal Method Eilers Company has two producing departments and two support departments. The following budgeted data pertain to these four departments: Support Departments Producing Departments General Factory Receiving Assembly Finishing Direct overhead $400,000 $150,000 $45,000 $71,000 Square footage — 2,700 5,400 5,400 Number of receiving orders 300 — 1,680 1,020 Direct labor hours — — 25,000 40,000 Required: 1. Allocate the overhead costs of the support departments to the producing departments using the reciprocal method. (Round allocation ratios to two...
Reciprocal Method Eilers Company has two producing departments and two support departments. The following budgeted data...
Reciprocal Method Eilers Company has two producing departments and two support departments. The following budgeted data pertain to these four departments: Support Departments Producing Departments General Factory Receiving Assembly Finishing Direct overhead $400,000 $150,000 $42,000 $71,000 Square footage — 2,700 5,400 5,400 Number of receiving orders 300 — 1,680 1,020 Direct labor hours — — 25,000 40,000 Required: 1. Allocate the overhead costs of the support departments to the producing departments using the reciprocal method. (Round allocation ratios to two...
Sequential Method Eilers Company has two producing departments and two support departments. The following budgeted data...
Sequential Method Eilers Company has two producing departments and two support departments. The following budgeted data pertain to these four departments: Support Departments Producing Departments General Factory Receiving Assembly Finishing Direct overhead $400,000 $150,000 $45,000 $75,000 Square footage — 2,700 5,400 5,400 Number of receiving orders 300 — 1,680 1,020 Direct labor hours — — 25,000 40,000 The support departments are ranked in order of highest cost to lowest cost. Required: 1. Allocate the costs of the support departments using...
Sequential Method Eilers Company has two producing departments and two support departments. The following budgeted data...
Sequential Method Eilers Company has two producing departments and two support departments. The following budgeted data pertain to these four departments: Support Departments Producing Departments General Factory Receiving Assembly Finishing Direct overhead $500,000 $170,000 $45,000 $75,000 Square footage — 2,700 5,400 5,400 Number of receiving orders 300 — 1,680 1,020 Direct labor hours — — 25,000 40,000 The support departments are ranked in order of highest cost to lowest cost. Required: 1. Allocate the costs of the support departments using...
Reciprocal Method Eilers Company has two producing departments and two support departments. The following budgeted data...
Reciprocal Method Eilers Company has two producing departments and two support departments. The following budgeted data pertain to these four departments: Support Departments Producing Departments General Factory Receiving Assembly Finishing Direct overhead $500,000 $150,000 $45,000 $75,000 Square footage — 2,700 5,400 5,400 Number of receiving orders 300 — 1,680 1,020 Direct labor hours — — 25,000 40,000 Required: 1. Allocate the overhead costs of the support departments to the producing departments using the reciprocal method. (Round allocation ratios to two...
Direct Method Eilers Company has two producing departments and two support departments. The following budgeted data...
Direct Method Eilers Company has two producing departments and two support departments. The following budgeted data pertain to these four departments: Support Departments Producing Departments General Factory Receiving Assembly Finishing Direct overhead $470,000 $150,000 $48,000 $76,000 Square footage — 2,200 4,400 4,400 Number of receiving orders 360 — 2,000 1,150 Direct labor hours — — 27,000 49,000 The company has decided to simplify its method of allocating support service costs by switching to the direct method. Required: 1. Allocate the...
Direct Method Eilers Company has two producing departments and two support departments. The following budgeted data...
Direct Method Eilers Company has two producing departments and two support departments. The following budgeted data pertain to these four departments: Support Departments Producing Departments General Factory Receiving Assembly Finishing Direct overhead $420,000 $150,000 $44,000 $76,000 Square footage — 2,200 4,400 4,400 Number of receiving orders 320 — 1,600 1,250 Direct labor hours — — 28,000 48,000 The company has decided to simplify its method of allocating support service costs by switching to the direct method. Required: 1. Allocate the...
Reciprocal Method Eilers Company has two producing departments and two support departments. The following budgeted data...
Reciprocal Method Eilers Company has two producing departments and two support departments. The following budgeted data pertain to these four departments: Support Departments Producing Departments General Factory Receiving Assembly Finishing Direct overhead $400,000 $170,000 $45,000 $71,000 Square footage — 2,700 5,400 5,400 Number of receiving orders 300 — 1,680 1,020 Direct labor hours — — 25,000 40,000 Required: 1. Allocate the overhead costs of the support departments to the producing departments using the reciprocal method. (Round allocation ratios to two...
Reciprocal Method Eilers Company has two producing departments and two support departments. The following budgeted data...
Reciprocal Method Eilers Company has two producing departments and two support departments. The following budgeted data pertain to these four departments: Support Departments Producing Departments General Factory Receiving Assembly Finishing Direct overhead $500,000 $150,000 $42,000 $71,000 Square footage — 2,700 5,400 5,400 Number of receiving orders 300 — 1,680 1,020 Direct labor hours — — 25,000 40,000 Required: 1. Allocate the overhead costs of the support departments to the producing departments using the reciprocal method. (Round allocation ratios to two...
Sequential Method Eilers Company has two producing departments and two support departments. The following budgeted data...
Sequential Method Eilers Company has two producing departments and two support departments. The following budgeted data pertain to these four departments: Support Departments Producing Departments General Factory Receiving Assembly Finishing Direct overhead $400,000 $160,000 $43,000 $74,000 Square footage — 2,700 5,400 5,400 Number of receiving orders 300 — 1,680 1,020 Direct labor hours — — 25,000 40,000 The support departments are ranked in order of highest cost to lowest cost. Required: 1. Allocate the costs of the support departments using...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT