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 time) |
10% |
0 |
30% |
60% |
100% |
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.
Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
Phoenix | |||||
Reciprocal Method | AS | IS | GOVT | CORP | Total |
Support work supplied by AS | 0.00% | 25.00% | 40.00% | 35.00% | 100.00% |
Support work supplied by IS | 10.00% | 0.00% | 30.00% | 60.00% | 100.00% |
Department cost | 600,000.00 | 2,400,000.00 | 8,756,000.00 | 12,452,000.00 | 24,208,000.00 |
Let cost of AS is $ X and IS $ Y | |
So, X= 600000+ 10% of Y | Equation 1 |
Y= 2400000+ 25% of X | Equation 2 |
Or, X= 600000+ 0.10Y | |
Y= 2400000+ 0.25X |
Substituting the value of X in equation 2: |
Y = 2400000 + 0.25(600,000 + 0.10Y) |
Y = 2400000 + 150000+.0025Y |
Y – 0.025Y = 2400000+150,000 |
0.975Y = 2,550,000 |
Y = 2,550,000/0.975 |
Y = $ 2,615,385 |
Substituting the value of Y in equation 1: |
So, X= 600000+ .010Y |
So, X= 600000+ 0.10*2615385 |
So, X= 600000+ 261538 |
X= $ 861,538 |
Allocation Summary | AS | IS | GOVT | CORP | Total |
Support work supplied by AS | - | 25.00% | 40.00% | 35.00% | 100.00% |
Support work supplied by IS | 10.00% | - | 30.00% | 60.00% | 100.00% |
Department cost | 600,000.00 | 2,400,000.00 | 8,756,000.00 | 12,452,000.00 | 24,208,000.00 |
Allocation | |||||
S 1 | (861,538.00) | 215,385.00 | 344,615.00 | 301,538.00 | - |
S 2 | 261,538.00 | (2,615,385.00) | 784,616.00 | 1,569,231.00 | - |
Cost after allocation | - | - | 9,885,231.00 | 14,322,769.00 | 24,208,000.00 |
PhoenixPartners provides management consulting services to government and corporate clients. Phoenix has two support departments—administrative services(AS)...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...