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 $78,890 2,300
Network center Number of devices monitored 573,000 9,550
Electronic mail Number of user accounts 66,500 6,650
Smartphone support Number of smartphones issued 144,000 9,000

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 50% are office employees.

• All the office employees have been issued a smartphone, and 80% of them have a computer on the network.

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

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

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

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 $  
Smartphone support $  

b. Determine the charges to the COMM sector for the four CCS service categories for October. Round your answers to the nearest dollar amount.

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

Solutions

Expert Solution

Answer:
A)

CCS Service Category Service Charge Rate
Help desk 34.3
Network center 60
Electronic mail 10
Smartphone support 16

b)

Total Employees 5000
Office Employees 2500
Office Employees with Smart Phone 2500
Office Employees with Computers 2125
Office Employees with Email Facility 2019
Avg. Help Desk Calls for Oct 1 Call per Individual with Computer
Total no of Help Desk Calls 2125

October charges to the COMM sector:

Service Rates No of Services Availed in Oct Service Charge for Oct
Help desk charge $         34.30 2125 $                   72,887.50
Network center charge $         60.00 2355 $                1,41,300.00
Electronic mail charge $         10.00 2019 $                   20,187.50
Smartphone support charge $         16.00 2500 $                   40,000.00

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 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...
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