using excel full answer graded assignment

FENICIA Partners provides management consulting services to government and corporate clients. FENICIA 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 2018, FENICIA's cost records indicate the following: Instructions: To ensure individual work Plug in the last 6 digits of your ID number in the place of the $600,000 AS overhead cost. 1) Using excel 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. Reciprocal method (repeated iterations or use equations). 2) After allocating the interdepartmental cost, using the Step down method, Corporation consulting department allocates the overhead costs based on direct labor hours. Total budgeted labor hours are expected to be 100,000 hours in the first quarter of 2018. Job order \# 100 used 20 labor hours at $200/ hour. Calculate total cost and price of this job, if the company charges 20% mark up on total cost