Question

In: Accounting

Tuscaloosa National Bank has two service departments, the Human Resources (HR) Department and the Computing Department....

Tuscaloosa National Bank has two service departments, the Human Resources (HR) Department and the Computing Department. The bank has two other departments that directly service customers, the Deposit Department and the Loan Department. The usage of the two service departments’ output for the year is as follows:
   

User of Service Provider of Service
HR Computing
HR 0 10 %
Computing 10 % 0
Deposit 60 % 50 %
Loan 30 % 40 %

  
The budgeted costs in the two service departments for the year are as follows:

HR $ 569,000
Computing 798,500

  
Required:
Use the reciprocal-services method to allocate the budgeted costs of the HR and Computing departments to the Deposit and Loan departments. (Do not round your intermediate calculations and round final answers to the nearest dollar amount.)

Solutions

Expert Solution

Answer:

Deposit Loan
HR department $      393,242 $      196,621
Computing department $      432,020 $      345,616

Calculations:

It is given that:

Deposit Loan HR department Computing department Total
HR department 60 30 0 10 100
Computing department 50 40 10 0 100

Now,

Let the total cost of HR department be x.
Let the total cost of Computing department be y.

and,

So, x = 569000 + 0.1y ---------Equation 1
y = 798500 + 0.1x ---------Equation 2

and,

Solving Equation 1 and 2:
Substitute value of 'y' from equation 2 in Equation 1-
So, x = 569000 + 0.1 (798500 + 0.1x)
So, x = $ 655404.04
The total cost of HR department is $ 655404.04

and,

Putting the value of x in equation 2-
So, y = 798500 + 0.1 * 655404.04
So, y = $ 864040.40
The total cost of Computing department is $ 864040.40

and,

Deposit Loan HR department Computing department
Total cost $                 -   $                 -   $          569,000 $                        798,500
HR department $      393,242 $      196,621 $        (655,404) $                          65,540
Total cost $      393,242 $      196,621 $          (86,404) $                        864,040
Computing department $      432,020 $      345,616 $            86,404 $                       (864,040)
Total cost $      825,263 $      542,237 $                    -   $                                   -  

In case of any doubt or clarification, feel free to come back via comments.


Related Solutions

Tuscaloosa National Bank has two service departments, the Human Resources (HR) Department and the Computing Department....
Tuscaloosa National Bank has two service departments, the Human Resources (HR) Department and the Computing Department. The bank has two other departments that directly service customers, the Deposit Department and the Loan Department. The usage of the two service departments’ output for the year is as follows:     User of Service Provider of Service HR Computing HR 0 25 % Computing 20 % 0 Deposit 70 % 65 % Loan 10 % 10 %    The budgeted costs in the...
Exercise 17-17: Tuscaloosa National Bank has two service departments, the Human Resources (HR) Department and the...
Exercise 17-17: Tuscaloosa National Bank has two service departments, the Human Resources (HR) Department and the Computing Department. The bank has two other departments that directly service customers, the Deposit Department and the Loan Department. The usage of the two service departments’ output for the year is as follows: Provider of Service User of Service HR Computing HR ......................................................................................................................................................... — 15% Computing ............................................................................................................................................ 10% — Deposit ................................................................................................................................................. 60% 50% Loan ...................................................................................................................................................... 30% 35% The budgeted costs in the two service...
The Buckaneer Clinic has two service departments (Human Resources and Information Resources) and two "production" departments...
The Buckaneer Clinic has two service departments (Human Resources and Information Resources) and two "production" departments (In-patient Treatment and Out-patient Treatment). The service departments service the "production" departments as well as each other, and studies have shown that Information Resources provides the greater amount of service. Which of the following allocations would occur if Buckaneer uses the direct method of cost allocation? Multiple Choice Information Resources cost would be allocated to In-patient Treatment. Information Resources cost would be allocated to...
Exercise 17-17 Direct Method of Service Department Cost Allocation; Bank (LO 17-1) Tuscaloosa National Bank has...
Exercise 17-17 Direct Method of Service Department Cost Allocation; Bank (LO 17-1) Tuscaloosa National Bank has two service departments, the Human Resources (HR) Department and the Computing Department. The bank has two other departments that directly service customers, the Deposit Department and the Loan Department. The usage of the two service departments’ output for the year is as follows: Provider of Service User of Service HR Computing HR — 20 % Computing 20 % — Deposit 50 % 40 %...
Bradford Company has two service departments, Human Resources and Janitorial, and two production departments, Cutting and...
Bradford Company has two service departments, Human Resources and Janitorial, and two production departments, Cutting and Glazing. The following data have been estimated for next year’s operations: Department: Direct Charges Number of Employees Square Footage Human Resources $360,000 6    15,000 Janitorial $280,000 8    20,000 Cutting $428,000 42    25,000 Glazing $562,000 40    35,000 Requirements: (1)   Distribute the service department costs using the sequential distribution method. Distribute the Human Resources Department first. (24 points/3 points each) (2) Prepare the journal entries to...
Exercise 17-18 Step-Down Method of Service Department Cost Allocation; Bank (LO 17-1) Tuscaloosa National Bank has...
Exercise 17-18 Step-Down Method of Service Department Cost Allocation; Bank (LO 17-1) Tuscaloosa National Bank has two service departments, the Human Resources (HR) Department and the Computing Department. The bank has two other departments that directly service customers, the Deposit Department and the Loan Department. The usage of the two service departments’ output for the year is as follows: User of Service Provider of Service HR Computing HR — 20 % Computing 10 % — Deposit 70 % 50 %...
The Hearts and Hands Clinic has two service departments (Human Resources and Information Systems) and two...
The Hearts and Hands Clinic has two service departments (Human Resources and Information Systems) and two "production" departments (In-patient Treatment and Out-patient Treatment). The service departments service the "production" departments as well as each other, and studies have shown that Information Systems provides the greater amount of service. Which of the following allocations would not occur if Hearts uses the step-down method of cost allocation? Select one: a. Human Resources cost would be allocated to In-patient Treatment. b. In-patient Treatment...
19) Christina Company has two service departments, Maintenance and Human Resources. Christina Company also has two...
19) Christina Company has two service departments, Maintenance and Human Resources. Christina Company also has two production departments, Mixing and Finishing. Maintenance costs are allocated based on square footage while Human Resources costs are allocated based on number of employees. The following information has been gathered for the current year:                                                                        Human                                          Maintenance         Resources              Mixing          Finishing Direct costs                                $50,400             $33,600              $42,000             $70,000 Square footage                              1,600                   800                 3,200                 2,400 Number of employees                       16                     24                     48                     64 Assume the step-down method is used to allocate service department costs and the Human Resources Department is allocated first. Then the...
Paul Corp. is a retailing firm which has two service departments, Human resources and Information systems,...
Paul Corp. is a retailing firm which has two service departments, Human resources and Information systems, and two operating departments, Corporate sales and Consumer sales. The Human resources Department costs of $100,000 are allocated on the basis of number of employees. The Information systems Department costs of $150,000 are allocated based on the processing time. The costs of operating departments, Corporate sales and Consumer sales, are $528,000 and $222,000, respectively. Data on overhead costs, and information about the number of...
Matt limited has two production, departments, machine department and assembly department. There are two service departments,...
Matt limited has two production, departments, machine department and assembly department. There are two service departments, stores and maintenance. The budgeted overheads of each department along with overheads that have yet to be apportioned are listed below, along with details which can be used for appointment. Total Machine Dept Assembly Dept Stores Maintenance K’000 K’000 K’000 K’000 K’000 Indirect labour 1 125 000 400 000 650 000 40 000 35 000 Indirect material 310 000 160 000 120 000 10...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT