One of the profit centers for Middler Corporation is the Communication Systems (COMM) sector. Assume the following information for the COMM sector: - The sector has 4,600 employees, of whom 25% are office employees. - Almost all office employees (99%) have a computer on the network. - One hundred percent of the employees with a computer also have an e-mail account. - The average number of help desk calls for October was 1.1 calls per individual with a computer. - There are 650 additional printers, servers, and peripherals on the network beyond the personal computers. - All the nonoffice employees have been issued a handheld device. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions belov Open spreadsheet a. Determine the service allocation rate for the four CCS service categories for October. Round your answers to the nearest dollar. b. Determine the allocations to the COMM sector for the four CCS service categories for October. Round your answers to the nearest dollar. Service department allocations and cost drivers Middler Corporation, a manufacturer of electronics and communications systems, allocates Computing and Communications Services (CCS) service department costs to profit centers. The following table lists service categories and cost drivers used by the CCS department. The table also includes cost and cost drivers for each service for October. One of the profit centers for Middler Corporation is the Communication Systems (COMM) sector. Assume the following information for the COMM sector: Select the corresponding units in the dropdowns in cells D25:D28. Using formulas and cell references, perform the required analysis, and input your answers into the green cells in the C column. Transfer the numeric results for the green entry cells (C25:C28, C31:C34) into the appropriate fields in CNOWv2 for grading