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 the sequential method. (Use the rounded values for subsequent calculations. Round allocation ratios to four significant digits. Round allocated costs to the nearest dollar. If an amount is zero, enter "0".)

Allocation ratios:

	Receiving	Assembly	Finishing
Square footage
Number of receiving orders

Allocations:

	General Factory	Receiving	Assembly	Finishing
Direct overhead cost	$	$	$	$
Allocate:
General Factory
Receiving
Total	$	$	$	$

2. Using direct labor hours, compute departmental overhead rates. (Round to the nearest cent.)

	Overhead Rate
Assembly	per direct labor hour
Finishing	per direct labor hour

Solutions

Expert Solution

Requirement 1

Allocation ratios:
	Receiving	Assembly	Finishing
Square footage [2700 + 5400 + 5400 = 13500]	0.2000 [2700/13500]	0.4000 [5400/13500]	0.4000 [5400/13500]
Number of receiving orders [=1680 + 1020 = 2700]		0.6222[1680 / 2700]	0.3778 [1020/2700]

Requirement 2

	General Factory	Receiving	Assembly	Finishing
Direct overhead cost	$400,000	$160,000	$43,000	$74,000
Allocate:
General Factory	($400,000)	$80,000	$160,000	$160,000
Receiving		($240,000)	$149,328	$90,672
Total	$0	$0	$352,328	$324,672

Requirement 3

Overhead Rate
Assembly	$ 14.09	per direct labor hour [352328 / 25000]
Finishing	$ 8.12	per direct labor hour [324672 / 40000]

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

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

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

Maddock Company has two service departments and two producing departments. Budgeted costs and budgeted activity...

Maddock Company has two service departments and two producing departments. Budgeted costs and budgeted activity in the various departments for last year are shown below. (show all calculations) Departments 2 Service Departments 2 Production Custodial Services Cafeteria Cutting Department Assembly Department Department overhead costs $50,400 $28,000 $120,000 $200,000 Square meters occupied 500 1,000 4,000 5,000 Number employees 10 15 75 100 Machine hours 10,000 15,000 Service department costs are allocated to producing department with the costs of...

Subjects