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 Computing and Communications Services (CCS) service department costs. The following table identities an abbreviated list of service categories and activity bases used by the CCS 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 2,800 Network Center Number of devices monitored 686,000 9,800 Electronk mail Number of user accounts 94,500 10,500 Smartphone support Number of smartphones issued 114,000 9.500 One of the profit centers for Middier Corporation is the Communication Systems COMM) sector. Assume the following information for the COMM sector . The sector has 5.500 employees, of whom 20% are office employees All the office employees have been issued a umartphone, and 91% of them have a comuter on the network, One hundred percent of the employees with a computer also have an e-mail account The verge number of help desk calls for October was 1 call per individual with a computer . There are 610 additional printers, servers, and peripherals on the network beyond the personal computer This information has been collected in the Microsoft Excel Delinete. Open the spreadsheet, perform the required analysis, Open spreadsheet 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 Helpdesk Network center Check My Work Add 40 of 12 PM Smartphone portre e d114.000 One of the profit centers for Mi Corporation is the Communication Systems (COM) co m e the towing formation for the Crector The sector has 5,500 employees, of whom are office employees . All the office employees have been issued a smartphone, and 91% of them have a comer 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 I call per individual with a computer . There are 610 aditional printers, servers and peripherals on the network beyond the personal computers Open the w e sterom the required an d This wormation has been collected in the crowce Online out you x] Open sweadsheet a. Determine the service charge rate for the four CCS service categories for October, Round your answers to the nearest do CCS Service Category Service Charge Rate Helpdesk Network center Electronic mal Smartphone s ort Det the charges to the C o r for the four CCS Service Categories for October Round your answer to the October charges to the COMH sector Helpdesk charge Network center charge Electronic mail charge Smartphone support charge