Question

In: Accounting

Service Department Charges and Activity Bases Middler Corporation, a manufacturer of electronics and communications systems, uses...

Service Department Charges and Activity Bases

Middler Corporation, a manufacturer of electronics and communications systems, uses a service department charge system to charge profit centers with Computing and Communications Services (CCS) service department costs. The following table identifies an abbreviated list of service categories and activity bases used by the CCS department. The table also includes some assumed cost and activity base quantity information for each service for October.

CCS Service
Category

Activity Base

Budgeted Cost
Budgeted Activity
Base Quantity
Help desk Number of calls $110,550 3,300
Network center Number of devices monitored 610,000 10,000
Electronic mail Number of user accounts 45,200 5,650
Handheld technology support Number of handheld devices issued 120,320 9,400

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,000 employees, of whom 30% are office employees.

Almost all office employees (80%) have a computer on the network.

90 percent of the employees with a computer also have an e-mail account.

The average number of help desk calls for October was 1 calls per individual with a computer.

There are 280 additional printers, servers, and peripherals on the network beyond the personal computers.

All the nonoffice employees have been issued a handheld device.

a. Determine the service charge rate for the four CCS service categories for October. Round your answers to two decimal places.

CCS Service Category Service Charge Rate
Help desk $
Network center $
Electronic mail $
Handheld technology support $

b. Determine the charges to the COMM sector for the four CCS service categories for October.

October charges to the COMM sector:
Help desk charge $
Network center charge $
Electronic mail charge $
Handheld technology support $

Solutions

Expert Solution

1.Calculation of activity rate using cost driver.
a.Calculation of cost driver
Particular Help Desk Network center Electronic mail Local voice support
A.Overhead incurred $110,550 610,000 45,200 120,320
B.Driver Number of calls Number of devices monitored Number of user accounts Number of phone extension
C.No. of times an activity is performed 3300 10000 5650 9400
D.Cost driver (A/C) 33.5 61 8 12.8
per call per device monitored per employee per phone extension
Calculation of total costs of COMM sector
Partciulars Amount Cost
Total employee 5000
office employee (30% of 5000) 1500
Phone (all office employee) 1500 12.8*1500
Computer network(80% of offfice employe) 1200 61*1200
Email account (90% of office employee with computer) 1080 8*1080
Number of calls (1.0 per individual with computer) 1080 33.5*1080
Printers and other devices 280 61*280
2
October charges to COMM sector
Help desk charge 36180
Network center charge 90280
Electronic mail charge 8640
Local voice support charge 19200
Total 154300

Related Solutions

Service Department Charges and Activity Bases Middler Corporation, a manufacturer of electronics and communications systems, uses...
Service Department Charges and Activity Bases Middler Corporation, a manufacturer of electronics and communications systems, uses a service department charge system to charge profit centers with Computing and Communications Services (CCS) service department costs. The following table identifies an abbreviated list of service categories and activity bases used by the CCS department. The table also includes some assumed cost and activity base quantity information for each service for October. CCS Service Category Activity Base Budgeted Cost Budgeted Activity Base Quantity...
Service Department Charges and Activity Bases Harold Corporation, a manufacturer of electronics and communications systems, uses...
Service Department Charges and Activity Bases Harold Corporation, a manufacturer of electronics and communications systems, uses a service department charge system to charge profit centers with Computing and Communications Services (CCS) service department costs. The following table identifies an abbreviated list of service categories and activity bases used by the CCS department. The table also includes some assumed cost and activity base quantity information for each service for April. CCS Service Category Activity Base Budgeted Cost Budgeted Activity Base Quantity...
Service Department Charges and Activity Bases Middler Corporation, a manufacturer of electronics and communications systems, uses...
Service Department Charges and Activity Bases Middler Corporation, a manufacturer of electronics and communications systems, uses a service department charge system to charge profit centers with Computing and Communications Services (CCS) service department costs. The following table identifies an abbreviated list of service categories and activity bases used by the CCS department. The table also includes some assumed cost and activity base quantity information for each service for October. CCS Service Category Activity Base Budgeted Cost Budgeted Activity Base Quantity...
1. Support Department Allocations And Cost Drivers Varney Corporation, a manufacturer of electronics and communications systems,...
1. Support Department Allocations And Cost Drivers 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 Services Cost Drivers Budgeted Cost Budgeted Quantity of Services Help desk Number of calls $90,000 3,600 Network center Number of devices 120,000 1,500 Electronic...
Bellamy Corporation uses customers served as its measure of activity. The company bases its budgets on...
Bellamy Corporation uses customers served as its measure of activity. The company bases its budgets on the following information: Revenue should be $3.20 per customer served. Wages and salaries should be $21,000 per month plus $0.80 per customer served. Supplies should be $0.70 per customer served. Insurance should be $5,300 per month. Miscellaneous expenses should be $3,100 per month plus $0.10 per customer served. The company reported the following actual results for October: Customers served 22,000 Revenue $ 73,300 Wages...
ABC Corporation has three service departments with the following costs and activity base: Service Department Cost...
ABC Corporation has three service departments with the following costs and activity base: Service Department Cost Activity Base for Allocation Graphics Production $200,000 # of copies Accounting $500,000 # of invoices processed Personnel Department $400,000 # of employees ABC has three operating divisions, Micro, Macro and Super. Their revenue, cost and activity information for December 31, 2017 are as follows: Micro Macro Super Direct Revenues $700,000 $850,000 $650,000 Direct Operating Expenses $50,000 $70,000 $100,000 # of copies made 20,000 30,000...
Adam Fresnel is the manager of a customer-service department bases in a call center. The eight...
Adam Fresnel is the manager of a customer-service department bases in a call center. The eight members of his team performed well in the last year, evidenced by high levels of satisfaction reported by customers. To increase customer satisfaction, Adam hired two additional employees. However, customer satisfaction ratings started to drop. Employees began taking longer breaks together and waiting longer to pick up calls because they are chatting with one another. In addition, the workspace became noisy and crowded with...
Service Department Charges In divisional income statements prepared for Demopolis Company, the Payroll Department costs are...
Service Department Charges In divisional income statements prepared for Demopolis Company, the Payroll Department costs are charged back to user divisions on the basis of the number of payroll distributions, and the Purchasing Department costs are charged back on the basis of the number of purchase requisitions. The Payroll Department had expenses of $49,452, and the Purchasing Department had expenses of $19,360 for the year. The following annual data for Residential, Commercial, and Government Contract divisions were obtained from corporate...
Service Department Charges In divisional income statements prepared for Demopolis Company, the Payroll Department costs are...
Service Department Charges In divisional income statements prepared for Demopolis Company, the Payroll Department costs are charged back to user divisions on the basis of the number of payroll distributions, and the Purchasing Department costs are charged back on the basis of the number of purchase requisitions. The Payroll Department had expenses of $73,392, and the Purchasing Department had expenses of $37,760 for the year. The following annual data for Residential, Commercial, and Government Contract divisions were obtained from corporate...
Service Department Charges The centralized employee Travel Department of Duden Company has expenses of $52,800. The...
Service Department Charges The centralized employee Travel Department of Duden Company has expenses of $52,800. The department has serviced a total of 2,400 travel reservations for the period. The South Division has made 1,056 reservations during the period, and the West Division has made 1,344 reservations. How much should each division be charged for travel services? Do not round interim calculations. South Division $ West Division $
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT