Support Department Allocations And Cust Drivers Varney Corponation, a manufacturer of electronics and communications systems, allocates Computing and Communications Services Department (CCS) costs to brufit ceniteri. 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. Oise of the profat centers for Varriey Corporation is the Communication Systems (COMM) division. Assums the following information for COMM: - ColMM has 2,600 employees, of whom 25\% are office employees. - All of the office employees have been issued a smartphone, and 92%6 of them have a computer on the networki. - Of the employees with a computer, One hundred\% of them also have an email account. - The average number of help desk calls for August was 0.5 calls per individual with a computer. - There are 410 additional printers, servers, and peripherals on the network beyond the personal computers. This intrormation hai been coliected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions belown. Cpentripredshect a. Compute the service allocation rate for each of CCS's services for August. a. Compute the service allocation rate for each of CCS's services for August. b. Compute the allocation of CCS's services to COMM for August. Round your answers to the nearest dollar. Feedback T Check My Wark Support Department Allocations And Cust Drivers Varney Corponation, a manufacturer of electronics and communications systems, allocates Computing and Communications Services Department (CCS) costs to brufit ceniteri. 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. Oise of the profat centers for Varriey Corporation is the Communication Systems (COMM) division. Assums the following information for COMM: - ColMM has 2,600 employees, of whom 25\% are office employees. - All of the office employees have been issued a smartphone, and 92%6 of them have a computer on the networki. - Of the employees with a computer, One hundred\% of them also have an email account. - The average number of help desk calls for August was 0.5 calls per individual with a computer. - There are 410 additional printers, servers, and peripherals on the network beyond the personal computers. This intrormation hai been coliected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions belown. Cpentripredshect a. Compute the service allocation rate for each of CCS's services for August. a. Compute the service allocation rate for each of CCS's services for August. b. Compute the allocation of CCS's services to COMM for August. Round your answers to the nearest dollar. Feedback T Check My Wark
