Service department charges and activity bases Varney Corporation, a manufacturer of electronics and communications systems, allocates Computing and Communications Services Department (CCS) costs to profit corters. The following table lists the types of services and cost drivers for each service. The table also includes the budgeted cost and quantity for each service for August CCS Service Budgeted Quantity Category Cost Drivers Budgeted Cost of Services Help desk Number of calls $64,600 3,800 Network center Number of devices monitored 216,000 2,700 Electronic mail Number of user accounts 121,800 4,200 Smartphone support Number of smartphones issued 67,200 4,200 One of the profit centers for Varney Corporation is the Communication Systems (COMM) sector. Assume the following information for COMM COMM has 3,900 employees, of whom 30% are office employees. . All the office employees have been issued a smartphone, and 93% of them have a computer on the network, Ninety-five percent of the employees with a computer also have an email account The average number of help desk calls for August was 0.8 calls per individual with a computer. There are 350 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 questions below Open spreadsheet . There are 350 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 questions below. X H Open spreadsheet a. Compute the service allocation rate for each of CSS services for August. Round your answers to the nearest dollar CCS Service Category Service Allocation Rate Help desk Network center Electronic mail Smartphone support b. Compute the allocation of cos's services to COMM for August, Round your answers to the nearest doltat. August allocations to the COMM: Help desk charge Network conter charge Electronic mail charge Smartphone support charge