my Corpo de comunicare Comics Servicepartment (CCS) Cotthewtablet the types encat bestehende the cand for the CCSS Buded Ouantity Categy Cost Drive Rudi Casi Services Net Nam 152.700 1900 Number of 11400 7.000 3,000 Once center capita mame COM come home for COM COMM),200 Anemom, them have them with a contestovan - he was called with com the one on the brand the promotes The human in cercare Orchest, perform the record in and meet your own the comme Com the service en rute for each of Services for Agend your own to the va della CCS Service Category Service Allocation Rate 15 perc Neto.com 3 e device word Det med Per or email ac 26 Perfumarthome issued 1. Come the chance to COM August. Rund to the rest dolle Ang allocations to the COMME Network can the Election Smartphone andarge E 24,700 issued Services Department (CCS) costs to profit centers. 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 Budgeted CCS Service Budgeted Category Quantity Cost Drivers Cost of Services Help desk Number of calls $48,000 3,200 Number of devices Network center 157,700 1,900 monitored Electronic mail Number of user accounts 114,400 4,400 Smartphone Number of smartphones support 78,000 3,000 One of the profit centers for Varney Corporation is the Communication Systems (COMM) sector. Assume the following information for COMM: . COMM has 3,800 employees, of whom 25% are office employees. . All the office employees have been issued a smartphone, and 92% 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.7 calls per individual with a computer. . There are 360 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 a. Compute the service allocation rate for each of Ccs's services for August. Round your answers to the nearest dollar. ces Service Category Service Allocation Rate Help desk 15 Per call Network center 33 Per device monitored Electronic mail 26 Per user or email account Smartphone support 26 Per smartphone issued b. Compute the allocation of CCS's services to COMM for August. Round your answers to the nearest dollar. August allocations to the COMM: Help desk charge Network center charge Electronic mail charge Smarthone cunnnrt charne 74 700