CERCE Corporation USES the direct method to allocate Service department costs to operating departments . The company has two service departments ,...

Please show all work, the ratios are the hardest part for me to understand how to calculate.

CERCE Corporation USES the direct method to allocate Service department costs to operating departments .The company has two service departments , Administrative and Facilities , and two operating departments .Assembly and Finishing.SERVICE DepartmentOperating DepartmentAdministrativeFACILITIESASSEMBLYFinishing*DEPartmental costs$ 31 , 480$ 38 , 315$ 125 , 580$ 417 , 650EmployEE hours3, 50101 , 17025 , 8BE25 , 8BESPACE OCCUPIED- - Square FEET8 , 5801 , 17045 , 8902 . 580Administrative Department costs are allocated on the basis of EmployEE hours and Facilities DepartmentCosts are allocated on the basis of SPACE Occupied.Required :`Allocate the SERVICE department costs to the operating departments using the direct method .Service DepartmentOperating DepartmentAdministrative*FacilitiesAssemblyFinishingTotal costs after allocation