eBook Show Me How Office 365 Calculator Service department charges and activity bases Middler Corporation, a manufacturer of electronics and communications systems, uses a service department charge system to charge profit centers with Computingar Communications Services (CCS) service department costs. The following table identifies an abbreviated list of service categories and activity bases used by the cos department. The table also includes some assumed cost and activity base quantity Information for each service for October CCS Service Budgeted Activity Category Activity Base Budgeted Cost Base Quantity Help desk Number of calls $147,000 3,000 Network center Number of devices monitored 756,600 9,700 9,900 Electronic mail 59,400 Number of user accounts 176,800 10,400 Smartphone support Number of smartphones issued One of the profit centers for Middler Corporation is the Communication Systems (COMM) sector. Assume the following information for the COM sector The sector has 5,700 employees, of whom 40% are office employees All the office employees have been issued a smartphone, and 90% of them have a computer on the network. Ninety-five percent of the employees with a computer also have an e-mail account. The average number of help desk calls for October was 1.5 calls per individual with a computer. . There are 600 additional printers, servers, and peripherals on the network beyond the personal computers This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question X Open spreadsheet a. Determine the service charge rate for the four CCS service categories for October. Round your answers to the nearest dollar. CCS Service Category Service Charge Rate