Question

In: Accounting

The Personnel Department at LastCall Enterprises handles many administrative tasks for the two divisions that make...

The Personnel Department at LastCall Enterprises handles many administrative tasks for the two divisions that make up LastCall: LaidBack and StressedOut. LaidBack division manages the company’s traditional business line. This business, although lucrative, is currently not growing. StressedOut, on the other hand, is the company’s new business, which has experienced double-digit growth for each of the last three years.

The cost allocation system at LastCall allocates all corporate costs to the divisions based on a variety of cost allocation bases. Personnel costs are allocated based on the average number of employees in the two divisions.

There are two basic activities in the Personnel Department. The first, which is called employee maintenance, manages employee records. Virtually all of this activity occurs when employees are hired or leave the company. The other activity is payroll, which is an ongoing activity and requires the same amount of work for each employee regardless of the employee’s salary.

Assorted data for LastCall for the last year follow: LaidBack StressedOut Total Number of employees (average) 100 20 120 Employees hired/leaving 5 13 18 The Personnel Department incurred the following costs during the year:

Employee maintenance $ 108,000

Payroll 12,000

Total $ 120,000

Required:

A. Under the current allocation system, what are the costs that will be allocated from personnel to LaidBack? To StressedOut? (Do not round intermediate calculations.)

B. Suppose the company implements an activity-based cost system for personnel with the two activities, employee maintenance and payroll. Use the number of employees hired/leaving as the cost driver for employee maintenance costs and the average number of employees for payroll costs. What are the costs that will be allocated from personnel to LaidBack? To StressedOut?

Solutions

Expert Solution

a.
Costs that will be allocated from personnel to LaidBack and Stressed Out is calculated as under:
Total personnel Department cost is $120,000
Average number of employees is 120
Employees in Laid Back department is 100 and Stressed Out department is 20
So cost is $1000,000 in laidback and $20,000 in Stressed out.
b.
Costs that will be allocated from personnel to LaidBack and To StressedOut using ABC is:
Activity Activity Cost Pool Cost driver LaidBack StressedOut Total
Employee Maintenance $108,000 No. of employees hired/leaving 5 13 18
Payroll 12,000 Average number of employees 100 20 120
Total $120,000 105 33 138
Activity Activity Cost Pool Cost driver LaidBack StressedOut Total
Employee Maintenance $108,000 No. of employees hired/leaving $30,000 $78,000 $108,000
Payroll 12,000 Average number of employees $10,000 $2,000 $12,000
Total $120,000 $40,000 $80,000 $120,000

Related Solutions

The Personnel Department at LastCall Enterprises handles many administrative tasks for the two divisions that make...
The Personnel Department at LastCall Enterprises handles many administrative tasks for the two divisions that make up LastCall: LaidBack and StressedOut. LaidBack division manages the company’s traditional business line. This business, although lucrative, is currently not growing. StressedOut, on the other hand, is the company’s new business, which has experienced double-digit growth for each of the last three years. The cost allocation system at LastCall allocates all corporate costs to the divisions based on a variety of cost allocation bases....
Factory Overhead Budget Service Department 1 handles personnel matters. The firm anticipates having 12 factory employees...
Factory Overhead Budget Service Department 1 handles personnel matters. The firm anticipates having 12 factory employees and expects the variable costs to operate the personnel department to average $1,000 per employee. The cost of this department is allocated to other departments on the assumption that there will be three employees in the maintenance department, five employees in the molding department, and four employees in the smoothing department. The personnel department’s fixed costs are estimated to be $15,000 and will be...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and wants to apply it to her department. She has identified four basic activities her employees spend most of the their time on: Interviewing, Hiring, Assessment, and Separation Processing. The department employs 12 staff who perform these activities. The manager provides the following estimates for the amount of time it takes to complete each of these activities: Interviewing: 52 minutes. Hiring: 67 minutes. Assessment: 89...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and wants to apply it to her department. She has identified four basic activities her employees spend most of the their time on: Interviewing, Hiring, Assessment, and Separation Processing. The department employs 5 staff who perform these activities. The manager provides the following estimates for the amount of time it takes to complete each of these activities: Interviewing: 45 minutes. Hiring: 60 minutes. Assessment: 75...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and wants to apply it to her department. She has identified four basic activities her employees spend most of the their time on: Interviewing, Hiring, Assessment, and Separation Processing. The department employs 25 staff who perform these activities. The manager provides the following estimates for the amount of time it takes to complete each of these activities: Interviewing: 65 minutes. Hiring: 80 minutes. Assessment: 115...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and wants to apply it to her department. She has identified four basic activities her employees spend most of the their time on: Interviewing, Hiring, Assessment, and Separation Processing. The department employs 5 staff who perform these activities. The manager provides the following estimates for the amount of time it takes to complete each of these activities: Interviewing: 45 minutes. Hiring: 60 minutes. Assessment: 75...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and wants to apply it to her department. She has identified four basic activities her employees spend most of the their time on: Interviewing, Hiring, Assessment, and Separation Processing. The department employs 20 staff who perform these activities. The manager provides the following estimates for the amount of time it takes to complete each of these activities: Interviewing: 60 minutes. Hiring: 75 minutes. Assessment: 105...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and...
The manager of the Personnel Department at City Enterprises has been reading about time-driven ABC and wants to apply it to her department. She has identified four basic activities her employees spend most of the their time on: Interviewing, Hiring, Assessment, and Separation Processing. The department employs 4 staff who perform these activities. The manager provides the following estimates for the amount of time it takes to complete each of these activities: Interviewing: 245 minutes. Hiring: 160 minutes. Assessment: 275...
A multinational company has many divisions. Two of these divisions are Mic Division and Mandy Division....
A multinational company has many divisions. Two of these divisions are Mic Division and Mandy Division. The Mic Division produces a component that is used by the Mandy Division. The cost of manufacturing the component is as follows: Direct materials $10 Direct labour $6 Variable overhead $4 Fixed overhead $5* Total cost $25 *Based on a normal volume of 400,000 components Other costs incurred by the Mic Division are as follows: Fixed selling and administrative: $400,000 Variable selling: $1.50 per...
The Personnel Department at Hernandez Bros. is centralized and provides services to the two operating units:...
The Personnel Department at Hernandez Bros. is centralized and provides services to the two operating units: Miami and New York. The Miami unit is the original unit of the company and is well established. The New York unit is new, much like a start-up company. The costs of the Personnel Department are allocated to each unit based on the number of employees in order to determine unit profitability. The current rate is $300 per employee. Data for the fiscal year...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT