Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and Maintenance). During July, the following costs and service department usage ratios were recorded: Supplying Department Using Department Engineering Administration Maintenance Fabrication Assembly Engineering 0 60 % 0 20 % 20 % Administration 15 % 0 10 % 50 % 25 % Maintenance 0 20 % 0 30 % 50 % Direct cost $ 50,000 $ 290,300 $ 45,000 $ 250,000 $ 90,000
Supplying Department | Using Department | ||||||||||||||
Engineering | Administration | Maintenance | Fabrication | Assembly | |||||||||||
Engineering | 0 | 60 | % | 0 | 20 | % | 20 | % | |||||||
Administration | 15 | % | 0 | 10 | % | 50 | % | 25 | % | ||||||
Maintenance | 0 | 20 | % | 0 | 30 | % | 50 | % | |||||||
Direct cost | $ | 50,000 | $ | 290,300 | $ | 45,000 | $ | 250,000 | $ | 90,000 |
Required: Allocate the service department costs to the two operating departments using the reciprocal method. (Do not round intermediate calculations.)
|
Answer -
Allocated to: | |||
Costs | Fabrication | Assembly | |
Engineering | $105500 | $21100 (20%) | $21100 (20%) |
Administration | $370000 | $185000 (50%) | $92500 (25%) |
Maintenance | $82000 | $24600 (30%) | $41000 (50%) |
Total | $230700 | $154600 |
Calculation:
Here,
The equations expressing the usage:
1. Engineering = Direct cost + 15% of Administration
Engineering = $50000 + (15% * Administration)
2. Administration = Direct cost + 60% of Engineering + 20% of Maintenance
Administration = $290300 + (60% * Engineering) + (20% * Maintenance)
3. Maintenance = Direct cost + 10% of Administration
Maintenance = $45000 + (10% * Administration)
So,
Substituting the equations for Engineering and Maintenance into the equation for Administration
Administration = $290300 + [60% * ($50000 + 15% * Administration)] + [20% * ($45000 + 10% * Administration)]
Administration = $290300 + [$30000 + 9% * Administration] + [$9000 + 2% * Administration]
Administration = $370000
Now,
Substituting the Administration amount into the equation for Engineering and Maintenance
Engineering = $50000 + (15% * Administration)
Engineering = $50000 + (15% * $370000)
Engineering = $105500
And
Maintenance = $45000 + (10% * Administration)
Maintenance = $45000 + (10% * $370000)
Maintenance = $82000
So,
Fabrication = ($20% * Engineering) + (50% * Administration) + (30% * Maintenance)
Fabrication = ($20% * $105500) + (50% * $370000) + (30% * $82000)
Fabrication = $21100 + $185000 + $24600
Fabrication = $230700
Assembly = ($20% * Engineering) + (25% * Administration) + (50% * Maintenance)
Assembly = ($20% * $105500) + (25% * $370000) + (50% * $82000)
Assembly = $21100 + $92500 + $41000
Assembly = $154600
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and...
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and Maintenance). During July, the following costs and service department usage ratios were recorded: Supplying Department Using Department Engineering Administration Maintenance Fabrication Assembly Engineering 0 60 % 0 20 % 20 % Administration 15 % 0 10 % 50 % 25 % Maintenance 0 20 % 0 20 % 60 % Direct cost $ 58,000 $ 329,000 $ 50,000 $ 270,000 $ 90,000 Required: Allocate...
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and Maintenance). During July, the following costs and service department usage ratios were recorded: Supplying Department Using Department Engineering Administration Maintenance Fabrication Assembly Engineering 0 60 % 0 20 % 20 % Administration 15 % 0 10 % 50 % 25 % Maintenance 0 30 % 0 15 % 55 % Direct cost $ 54,000 $ 304,600 $ 50,000 $ 260,000 $ 90,000 Required:...
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and Maintenance). During July, the following costs and service department usage ratios were recorded. Engineering Assembly 20% Supplying Department Engineering Administration Maintenance Direct cost 15% Using Department Administration Maintenance 60% 10% 30% $274,500 $45,000 Fabrication 20% 50% 15% $245,000 25% $48,000 55% $80,000 Required: Allocate the service department costs to the two operating departments using the reciprocal method. (Do not round intermediate calculations.) Allocated to:...
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and Maintenance). During July, the following costs and service department usage ratios were recorded. 0.76 points Engineering Fabrication 15% Supplying Department Engineering Administration Maintenance Direct cost 20% Using Department Administration Maintenance 40% 25% 20% $ 222,800 $40,000 45% 30% $ 205,000 45% 10% 50% $50,000 $32,000 eBook Required: Allocate the service department costs to the two operating departments using the reciprocal method. (Do not round...
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and Maintenance). During July, the following costs and service department usage ratios were recorded. Engineering Supplying Department Engineering Administration Maintenance Direct cost Using Department Administration Maintenance 40% 25% 20% $246,500 $40,000 20% Fabrication 15% 45% 30% $220,000 Assembly 45% 10% 50% $80,000 $38,000 Required: Allocate the service department costs to the two operating departments using the reciprocal method. (Do not round intermediate calculations.) Allocated to:...
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering Administration, and Maintenance). During July, the following costs and service department usage ratios were recorded. Engineering Supplying Department Engineering Administration Maintenance Direct cost Using Department Administration Maintenance 60% Fabrication 20% 15% Assembly 20% 25% lex Sex 2ex 20% $ 298,000 $52,000 60% $45,000 $255,000 $90,000 Required: Allocate the service department costs to the two operating departments using the reciprocal method. (Do not round intermediate calculations.) Allocated...
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and Maintenance). During July, the following costs and service department usage ratios were recorded. 1.15 points Engineering Supplying Department Engineering Administration Maintenance Direct cost Using Department Administration Maintenance Fabrication 40% 0 15% 25% 45% 30% 15% $248,550 $ 45,000 $230,000 Skipped 208 Assembly 45% 10% 55% $80,000 $ 42,000 eBook References Required: Allocate the service department costs to the two operating departments using the reciprocal...
Anderson Enterprises has three service departments, Administration, Maintenance and security and two production departments, Machining and Assembly. Total Manufacturing overhead was either directly traced or allocated to all of the departments resulting gin a total of $300,000 of overhead in the Maintenance Department, $240,000 in the administration department, $135,000 in the security department, $1,000,000 in the machining department and $300,000 in the assembly department. The company allocates service department cost using the step method. The maintenance department overhead is allocated...
Barstow Manufacturing Company has two service departments-product design and engineering support, and two production departments -assembly and finishing. The distribution of each service department's efforts to the other departments is shown below. Design Support 0% 20% sign Support Assembly Finishi 60% 35% 10% 0% 30% 45% The direct operating costs of the departments (including both variable and fixed costs) were as follows: Design Engineering Support Assembly Finishing 250,000 270,000 S 990, 000 $1,500, 000 The total cost accumulated in the...
Caro Manufacturing has two production departments, Machining and Assembly, and two service departments, Maintenance and Cafeteria. Direct costs for each department and the proportion of service costs used by the various departments for the month of August follow: Proportion of Services Used by Department Direct Costs Maintenance Cafeteria Machining Assembly Machining $ 120,000 Assembly 84,000 Maintenance 55,000 — 0.2 0.5 0.3 Cafeteria 42,000 0.7 — 0.2 0.1 Required: Use the reciprocal method to allocate the service costs. (Matrix algebra is...