I NEED HELP COMPLETING THE TABLE ! PLEASE SHOW CALCULATIONS

KEEP THE SAME TABLE FORMAT

THANKS !

Phoenix Partners provides management consulting services to government and corporate clients. Phoenix has two support departmentsadministrative services (AS) and information systems (IS)and two operating departmentsgovernment consulting (GOVT) and corporate consulting (CORP). For the first quarter of 2017, Phoenix's cost records indicate the following: Data table SUPPORT OPERATING AS IS 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 computer time) 0 25% 40% 35% 100% 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. AS= $600,000 + 0.10 IS IS= $2,400,000 + 0.25 AS 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 rec 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 "O" for any zero balances.) Support Departments Operating Departments AS IS GOVT CORP Total Reciprocal Method Budgeted overhead costs 600,000 2,400,000 8,756,000 12,452,000 24,208,000 before interdepartment cost allocations Allocation of AS costs Allocation of IS costs Total budgeted overhead of operating departments