Question
Service department allocations and cost drivers Middler Corporation, a manufacturer of electronics and communications systems, allocates Computing and Communications Services (CCS) service department costs to
Service department allocations and cost drivers
Middler Corporation, a manufacturer of electronics and communications systems, allocates Computing and Communications Services (CCS) service department costs to profit centers. The following table lists service categories and cost drivers used by the CCS department. The table also includes cost and cost drivers for each service for October.
Budgeted Cost | |||||
CCS Service Category | Cost Driver | Budgeted Cost | Driver Quantity | ||
Help desk | Number of calls | $156,000 | 2,600 | ||
Network center | Number of devices monitored | 742,500 | 9,900 | ||
Electronic mail | Number of user accounts | 70,700 | 10,100 | ||
Handheld technology support | Number of handheld devices issued | 109,200 | 9,100 |
One of the profit centers for Middler Corporation is the Communication Systems (COMM) sector. Assume the following information for the COMM sector:
The sector has 5,900 employees, of whom 35% are office employees.
Almost all office employees (99%) have a computer on the network.
Ninety percent of the employees with a computer also have an e-mail account.
The average number of help desk calls for October was 1.3 calls per individual with a computer.
There are 550 additional printers, servers, and peripherals on the network beyond the personal computers.
All the nonoffice employees have been issued a handheld device.
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.
Determine the allocations to the COMM sector for the four CCS service categories for October. Round your answers to the nearest dollar.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started