Data table 1 2 Budgeted overhead costs before any 3 interdepartment cost allocations Support work supplied by AS 4 (budgeted head count) Support work supplied by IS 5 (budgeted computer time) B SUPPORT AS IS $ D E F OPERATING GOVT CORP Total - X 600,000 $6,000,000 $ 8,700,000 $ 12,540,000 $ 27,840,000 Roun 0 10% 20% 48% 32% 100% 27% 63% 100% Print Done 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 (CORP). For the first quarter of 2020, Phoenix's cost records indicate the following: (Click the icon to view the cost records.) Read the requirements. KCLE 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: (Click the icon to view the direct method.) (Click the icon to view the step-down method (AS first).) (Click the icon to view the step-down method (IS first).) (Click the icon to view a summary of the three methods.) C 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.) Reciprocal Method Budgeted overhead costs before interdepartment cost allocations. Allocation of AS costs Allocation of IS costs Total budgeted overhead of operating departments Support Departments Operating Departments AS IS GOVT CORP Total Requirements o view t - - X o view t o view 1. Allocate the two support departments' costs to the two operating departments using the reciprocal method. Use (a) linear equation and (b) repeated iterations. 2. Compare and explain differences in requirement 1 with those of the direct hethod and the step down method. Which method do you prefer? Why? Print Done step) f o the tmen COR 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= IS= $600,000 + $6,000,000 + 0.10 IS 0.20 AS Now allocate the support departments' costs (AS and IS department costs that you determined in the prior step) to the two operating dem the reciprocal method. (Round decimal calculations to three decimal places, .XXX, and your final answers to the nearest whole dollar. L a minus sign when decreasing departments by allocating costs. Enter a "0" for any zero balances.)