BOOK Show Me How Office 365 Print om Service department changes and activity bases Varney Corporation, a manufacturer of electronics and communication 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 Help desk Number of calls $74,400 3.100 Network center Number of devices monitored 158,000 2,000 Electronic mail Number of user accounts 144,000 4,500 Smartphone support Number of smartphones issued 90,000 5,000 One of the profit centers for Varney Corporation is the communication Systems (COMM) sector. Assume the following information for COMMI COMM has 2,000 employees, of whom 35% are office employees All the office employees have been issued a smartphone, and 93% of them have a computer on the network One hundred percent of the employees with a computer also have an email account. The average number of help desk calls for August was 0.6 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. x] THE 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 Previous Next > Check My Work Internat Show Me How Office 365 Printem IX 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 Per call Network center Per device monitored Electronic mail Per user or email account Smartphone support Per smartphone issued b. Compute the allocation of CC's services to COMM for August. Round your answers to the nearest dollar August allocations to the COMMI Help desk charge Network center charge Electronic mall charge Smartphone support charge Check My Work a Divide the budgeted cost by the budgeted activity base quantity for each category b. Determine the Help desk charge by multiplying the rate from (a) by the number of employees, the percentage of office meet the percentage with computer and the calls. Follow a similar process for each of the other tre categories Previous Next > Check My Work Email instructor Save and Submit Assignment for Grading All work saved