ebook Show Me How Oce365 Printem Service department charges and activity bases Varnay Corporation, a manufacturer of electronics and communications systems, allocates Computing and Communications 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 CCS Service Budgeted Quantity Category Cost Drivers Budgeted Cost of Services Helpdesk Number of calls $115,600 3.400 Network center Number of devices monitored 101,400 1300 Electronic mall Number of user accounts 159,000 4.700 Smartphone support Number of smartphones issued 95,200 3,400 One of the droit centers for Varney Corporation is the Communication Systems (COMM) sector Assume the following information for COMM COMM 2,600 employees of whom 40% are office employees . All the office employees have been issued a smartphone, and 94 of them have a computer on the network De hundred percent of the employees with a computer also have an email account: The average number of helpdesk calls for August wes 0.5 cali per individual wm a computer . There are 3 additional ters, servers, and peripherals on the network beyond the personal computers This information has been collected in the Microsoft Excel Online file. Open the spreadhe, perform the required analysis, and out your answers in the questions Blow Open spreadsheet .. Compute the service allocation rate for each of CCS services for August Round your answers to the nearest della CCS Service Category Service Allocation Rate Help om 34 Per call Next > Open spreadsheet a. Compute the service allocation rate for each of CCS's services for August. Round your answers to the nearest dollar. CCS Service Category Service Allocation Rate Help desk 34 Per call Network center 78 Per device monitored Electronic mail 34 Per user or email account Smartphone support 28 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 $1 Electronic mail charge Smartphone support charge Check My Wo Divide the budgeted cost by the budgeted activity base quantity for each category b. Determine the Helpdesk charge by multiplying the rate from (a) by the number of employees the percentage of office amployees, the percentage with a computer and the numbe Calle Follow a similar process for each of the other three categories