Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please let me know your answers in the yellow highlighted box and formulas too A 5 5 0 FMC Corporation has a new FMC N.A.
Please let me know your answers in the yellow highlighted box and formulas too
A 5 5 0 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 = $1,896,000 (3) The total office floor-space monthly rental cost = (4) There are 118 FMC employees with 12 departments working at the location. (5) The total floor-space monthly rental cost is to be allocated to each departmental P&L statements at the end of each month as part of the SG&A expenses (6) The headcount distribution are as provided below. QUESTION: Create a worksheet and perform rental cost allocation 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 1 2 3 5 S DEPARTMENT Headcount 7 Headcount% Departmental Monthly Rental-Cost Allocation 8 CEO 3 4 ( (1) (2) (3) (4) 0 Legal CFO & Finance Accounting 18 1 12 2 (5) HR 3 3 (6) 3 Tax & Treasury Chemical Div. (7) 18 $ (8) 17 5 12 4 (9) (10) (11) (12) Agricultural Div. Engineering & Design IT Support Facility Sales Support TOTAL 8 2 22 0 1 A 5 5 0 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 = $1,896,000 (3) The total office floor-space monthly rental cost = (4) There are 118 FMC employees with 12 departments working at the location. (5) The total floor-space monthly rental cost is to be allocated to each departmental P&L statements at the end of each month as part of the SG&A expenses (6) The headcount distribution are as provided below. QUESTION: Create a worksheet and perform rental cost allocation 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 1 2 3 5 S DEPARTMENT Headcount 7 Headcount% Departmental Monthly Rental-Cost Allocation 8 CEO 3 4 ( (1) (2) (3) (4) 0 Legal CFO & Finance Accounting 18 1 12 2 (5) HR 3 3 (6) 3 Tax & Treasury Chemical Div. (7) 18 $ (8) 17 5 12 4 (9) (10) (11) (12) Agricultural Div. Engineering & Design IT Support Facility Sales Support TOTAL 8 2 22 0 1Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started