3 4 5 6 7 In the World of Corporate Financial Analysis, one key concept that financial analyst need to develop and update at the end of every month when closing the book for the company is "Cost Allocation" schedule. FMC Corporation has a new FMC N.A. Headquarter in Philadelphia at the 30th Street Amtrak Station. (1) The company rent the entire 22th and 23th floors with a total office space of 86,000 sq.ft. (2) The total office-floor-space "annual" rental cost = $3,196,000 10 (3) The total office "annual" utility cost = $245,400 11 (4) The total office "annual" maintenance & custodial cost = $148,400 12 1239 (5) There are 118 FMC employees within 12 departments currentlyworking at the location. 13 11 14 15 16 17 18 19 20 (6) The total 3 annual costs above are to be allocated to each departmental P&L statements at the end of each month as part of the SG&A expenses (7) The headcount distribution are as provided below. QUESTION: Create a worksheet and perform all cost allocations based on departmental headcounts You are required to build the office-space monthly rental-cost-allocation schedule for each department at this 30th Street Amtrak Station DEPARTMENT CEO Headcount Headcount % Departmental "Monthly" Rental-Cost Allocation Departmental "Monthly" Utility-Cost Allocation 6 Departmental "Monthly" Maintenance-Cost Allocation 21 22 22 (2) (3) Legal 7 CFO & Finance 18 23 (4) 24 25 25 Accounting HR Tax & Treasury 13 3 3 26 Chemical Div. 12 27 Agricultural Div. 17 26 (9) Engineering & Design 12 29 (10) IT Support 4 30 (11) Facility 2 31 (12) Sales Support 22 32 202 TOTAL 119 0.0% $0 $0 $0 en en $0