Service department charges and activity bases Varney Corporation, a manufacturer of electronics and communications systems, allocates Computing and Communications Services Department (CCS) costs to pnofit centers. The following toble lists the types of services and cost drivers for each service. The table also includes the budgeted cost and auantity for each service for Augur One of the profit centers for Vamey Corporation is the Communication Systems (ComM) sectoc Assume the following information for COMM: + coMM has 2,600 employees, of whom 254 are office employeet. - Nr the office emporees have been isued a smarphone, and 95% of them hove o computer en the networkr. - One hundred percent of the employees whth a computer aho have an emai account. - The averege number of heip desk calis for August was 0.9 calis per individual wath a computer. - There are 360 sodnonal printen, servers, and peripherals eo the network betyond the persenal computeri This infarmation has been coliected in the Microsoft Excel Online fine, Open the spresdsheet, perform the required analyais, and input your ansmers in the aveitions beion. - There are 360 additonal priters, serversy and perpherats on the network beyond the personar computers. This information has been collected in the Microsoft Excel Oniline file. Open the spreadsheet, perform the required analysis, and input your answers in the questions belov Open spreadsheet a. Compute the service allocation rate for each of CCS's secvices for August. Round your answers to the nearest dollar. b. Compute the aliocation of CCS's services to ComM for August. Round your answers to the nearest dollar: Auaust allocations to the COMM