Manhattan Partners provides management consulting services to government and corporate clients. Concord has two support departments---administrative services (AS) and information system (IS)---and two operating departments---government consulting (GOVT) and corporate consulting (CORP). For the first quarter of 2017, Manhattan's cost records indicate the following:
SUPPORT |
OPERATING |
|||||
AS |
IS |
GOVT |
CORP |
Total |
||
Budgeted overhead costs before any |
||||||
interdepartment cost allocations |
$390,000 |
$3,600,000 |
$8,750,000 |
$12,540,000 |
$25,280,000 |
|
Support work supplied by AS |
||||||
(budgeted head count) |
--- |
20% |
48% |
32% |
100% |
|
Support work supplied by IS |
||||||
(budgeted computer time) |
10% |
--- |
36% |
54% |
100% |
The two support departments' costs have been allocated to the two operating departments using the direct method and the step-down method (AS department first) and the step-down method (IS department first). The results of the allocations are as follows:
direct method
Support Departments |
Operating Departments |
||||
Direct Method |
AS |
IS |
GOVT |
CORP |
Total |
Budgeted overhead costs |
|||||
before interdepartment cost allocations |
$390,000 |
$3,600,000 |
$8,750,000 |
$12,540,000 |
$25,280,000 |
Allocation of AS costs |
(390,000) |
234,000 |
156,000 |
||
Allocation of IS costs |
(3,600,000) |
1,440,000 |
2,160,000 |
||
Total budgeted overhead of operating departments |
$0 |
$0 |
$10,424,000 |
$14,856,000 |
$25,280,000 |
step down method (AS) first
Support Departments |
Operating Departments |
||||
Step-down Method |
AS |
IS |
GOVT |
CORP |
Total |
Budgeted overhead costs |
|||||
before interdepartment cost allocations |
$390,000 |
$3,600,000 |
$8,750,000 |
$12,540,000 |
$25,280,000 |
Allocation of AS costs |
(390,000) |
78,000 |
187,200 |
124,800 |
|
$0 |
3,678,000 |
||||
Allocation of IS costs |
(3,678,000) |
1,471,200 |
2,206,800 |
||
Total budgeted overhead of operating departments |
$0 |
$10,408,400 |
$14,871,600 |
$25,280,000 |
step down method (IS) first
Support Departments |
Operating Departments |
||||
Step-down Method |
AS |
IS |
GOVT |
CORP |
Total |
Budgeted overhead costs |
|||||
before interdepartment cost allocations |
$390,000 |
$3,600,000 |
$8,750,000 |
$12,540,000 |
$25,280,000 |
Allocation of IS costs |
360,000 |
(3,600,000) |
1,296,000 |
1,944,000 |
|
$750,000 |
$0 |
||||
Allocation of AS costs |
(750,000) |
450,000 |
300,000 |
||
Total budgeted overhead of operating departments |
$0 |
$10,496,000 |
$14,784,000 |
$25,280,000 |
summary of the three methods
GOVT |
CORP |
|
Direct method |
$1,674,000 |
$2,316,000 |
Step-down (AS first) |
1,658,400 |
2,331,600 |
Step-down (IS first) |
1,746,000 |
2,244,000 |
Requirement 1a. Allocate the two support departments' costs to the two operating departments using the reciprocal method.
First, determine the linear equations for each support department.
___
Now allocate the support departments' costs (AS and IS department costs that you determined in the prior step) to the two operating departments using the reciprocal method. (Round decimal calculations to three decimal places, .XXX, and your final answers to the nearest whole dollar. Use parentheses or a minus sign when decreasing departments by allocating costs. Enter a "0" for any zero balances.)
Requirement 1b. Allocate the two support departments' costs to the two operating departments using the reciprocal method. Use repeated iterations. (Round your final answers to the nearest whole dollar. Use parentheses or a minus sign when decreasing departments by allocating costs. Enter a "0" for any zero balances.)
SUPPOSE AS COST =X
IS COST = Y
X = 390000+ 0.10Y EQUATION 1
Y = 3600000+0.20X EQUATION 2
Y = 3600000+0.20(390000+0.10Y)
Y = 3600000+78000+0.02Y
0.98Y = 3678000
Y =3753061
X = 390000+0.10(3753061)
= 765306
AS | IS | GOVT | CORP | TOTAL | |
INTERDEPARTMENTAL COST ALLOCATION | 390000 | 3600000 | 8750000 | 12540000 | 25280000 |
AS COST ALLOCATED | -765306 |
153061 [765306*20%] |
367347 [765306*48%] |
244898 [765306*32%] |
|
IS COST ALLOCATED |
375306 [3753061*10%] |
-3753061 |
1351102 [3753061*36%] |
2026653 [3753061*54%] |
|
TOTAL | 0 | 0 | 10468449 | 14811551 | 25280000 |
Manhattan Partners provides management consulting services to government and corporate clients. Concord has two support departments---administrative services (AS) and information system (IS)---and t...
Phoenix Partners provides management consulting services to government and corporate clients. Phoenix has two support departments-administrative services (AS) and information systems (15)—and two operating departments-government consulting (GOVT) and corporate consulting (CORP). For the first quarter of 2017, Phoenix's cost records indicate the following: SUPPORT ASIS OPERATING GOVT CORP Total $ 600,000 $ 2,400,000 $8,756,000 $ 12,452,000 $ 24,208,000 Budgeted overhead costs before any interdepartment cost allocations Support work supplied by AS (budgeted head count) Support work supplied by IS (budgeted...
Manhattan Partners provides management consulting Services to government and corporate clients Manhattan has two support departments administrative services (AS) and information systems (15) and two operating departments government consulting (GOT) and corporate consulting (CORP) For the first quarter of 2017. Manhattan's cost records indicate the following 11. Click the icon to view the cost records) The two support department costs have been allocated to the two operating departments in the direct method and the p-down method (AS department and the...
Phoenix Partners provides management consulting services to government and corporate clients. Phoenix has two support departments-administrative services (AS) and information systems (IS)—and two operating departments-government consulting (GOVT) and corporate consulting RP). For the first quarter of 2017, Phoenix's cost records indicate the following: (Click the icon to view the cost records.) (CORP). Po Read the requirements. Requirement 1a. Allocate the two support departments' costs to the two operating departments using the direct method. (Do not round intermediary calculations and round...
Phoenix Partners provides management consulting services to government and Corporate clients Phoenix has two support depart ament e services (AS) and information systems (15) and two operating departments-government consting (GOVT) and corporate consulting (CORP) For the first quarter of 2017, Phoenix's cost records indicate the following (Click the icon to ww the cost records The two Sport department costs have been allocated to the two operating departments the vect method and the step-down method (AS department fest) and the step...
Atlanta Partners provides management consulting services to government and corporate clients. Atlanta has two support departments—administrative services (AS) and information systems (IS)—and two operating departments-government consulting (GOVT) and corporate consulting (CORP). For the first quarter of 2017, Atlanta's cost records indicate the following: SUPPORT AS IS OPERATING GOVT CORP Total $ 330,000 $ 1,200,000 $ 7,500,000 $ 12,490,000 $ 21.520,000 Budgeted overhead costs before any interdepartment cost allocations Support work supplied by AS (budgeted head count) Support work supplied by...
Seattle Partners provides management consulting Services to government and corporate clients. Seattle has two support departments administrative services (AS) and information systems (S) and two operating departmenis gaverrment consulting (GOVT) and corporate consulting (CORP). For the first quarter of 2017, Seattle's cost records indicate the following: Click the icon to view the cost records.) Read the rccuircments. Requirement 1a. Allocate the two support departments' costs to the two operating departments using the direct method. (Do not round intermediary calculations and...
Phoenix Partners provides management consulting services to government and corporate clients. Phoenix has two support departmentslong dashadministrative services (AS) and information systems (IS)long dashand two operating departmentslong dashgovernment consulting (GOVT) and corporate consulting (CORP). For the first quarter of 2017, Phoenix's cost records indicate the following: 1. Allocate the two support departments' costs to the two operating departments using the following methods: a. Direct method b. Step-down method (Allocate AS first) c. Step-down method (Allocate IS first Data Table SUPPORT...
PhoenixPartners provides management consulting services to government and corporate clients. Phoenix has two support departments—administrative services(AS) and information systems(IS)—and two operating departments—government consulting (GOVT) and corporate consulting (CORP). For the first quarter of 2017, Phoenix's cost records indicate the following: SUPPORT OPERATING AS IS GOVT CORP Total Budgeted overhead costs before any interdepartment cost allocations $600,000 $2,400,000 $8,756,000 $12,452,000 $24,208,000 Support work supplied by AS (budgeted head count) 0 25% 40% 35% 100% Support work supplied by IS (budgeted computer...
Apex provides management consulting services to government and corporate clients. Apex has two support departments-administrative services (AS) and information systems (IS) and two operating departments-government consulting (GOVT) and corporate consulting (CORP). For the second quarter of 2014, Apex's cost records indicate the following: Particulars Total Support AS Support IS Operating Gaxt Operating Corp $500,000 $200,000 $200,000 1,400,000 Interdepartmental cost $500,000 allocations Support work supplied by AS (budgeted head count) 25% 50% 25% 100% 20% 30% 50 % 100 % Support...
two support Ev e nt consulting (GOVT) and corporate consulting Phoenix Partners provides management consulting services to government and corporate clients for departments administrative services (AS) and information system (IS) and two operating departments CORP) For the best quarter of 2017 Phone's cost records indicate the following Check the icon to the cost records) Read the U S Requirement ta. Alocate the two support departments costs to the two operating departments using the direct method. Do not round intermediary calculations...