'\\ Varney 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 Help desk Number of calls $64,600 3,800 Network center Number of devices monitored 218,400 2,800 Electronic mail Number of user accounts 163,200 5,100 Smartphone support Number of smartphones issued 107,800 4,900 One of the prot centers for Varney Corporation is the Communication Systems (COMM) sector. Assume the following information for COMM: 0 COMM has 2,400 employees, of whom 20% are ofce employees. - All the office employees have been issued a smartphone, and 96% of them have a computer on the network. 0 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.? calls per individual with a computer. 0 There are 370 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. 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. CCS Service Category Service Allocation Rate Help desk Network center Electronic mail ) Smar'tphone support 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 C Network center charge 94:] Electronic mail charge C Smar'tphone support charge 95': ) Budget Performance Report for a Cost Center The Eastern District of Adelson Inc. is organized as a cost center. The budget for the Eastern District of Adelson Inc. for the month ended December 31 is as follows: Sales salaries $319,340 System administration salaries 443,152 Customer service salaries 152,600 Billing salaries 93,760 Maintenance 271,104 Depreciation of plant and equipment 92,232 Insurance and property taxes 41,280 Total $1,923,968 During December, the costs incurred in the Eastern District were as follows: Sales salaries $313,300 System administration salaries 447,720 Customer service salaries 183,120 Billing salaries 93,100 Maintenance 273,000 Depreciation of plant and equipment 92,232 Insurance and property taxes 41,400 ? Total $1,954,452 Required: 1. Prepare a budget performance report for the manager of the Eastern District of Adelson for the month of December. If an amount box does not require an entry, leave it blank. Adelson Inc. Budget Performance Report-Manager, Eastern District For the Month Ended December 31 Actual Budget Over Budget Under Budget Sales salaries $ $ $ System administration salaries Customer service salaries Billing salaries Maintenance Depreciation of plant and equipment Insurance and property taxes DOC Total 2. For which costs might the manager be expected to request supplemental reports? a. Customer service salaries. b. Customer service salaries and maintenance. c. Customer service and sales salaries as well as maintenance