Support Department Allocations And Cost Drivers

One of the profit centers for Varney Corporation is the Communication Systems $($COMM$)$ division. Assume the following information for COMM:

COMM has $3,800$ employees, of whom $35\%$ are office employees.

All of the office employees have been issued a smartphone, and $96\%$ of them have a computer on the network.

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\mathrm{.}7$ calls per individual with a computer.

There are $430$ 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$\text{'}$s services for August.

b$.$ Compute the allocation of $CC{S}^{\text{'}}$ s services to COMM for August. Round your answers to the nearest dollar.