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:

Determine the total overhead costs for each of the production department, after allocation of support department costs, using each of the following allocation methods:

Direct method:

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

Reciprocal method

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?

Expert Solution

ekkarill92 answered 2 years ago

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...

Question

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.

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...

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...

Reciprocal 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...

Direct 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...

Reciprocal 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...