Question

In: Accounting

State Financial Corp. has three service departments (Administration, Communications, and Facilities), and two production departments (Deposits...

State Financial Corp. has three service departments (Administration, Communications, and Facilities), and two production departments (Deposits and Loans). A summary of costs and other data for each department prior to allocation of service department costs for the year ended December 31 follows.

Administration Communications Facilities Deposits Loans
Direct costs $ 210,000 $ 320,000 $ 253,000 $ 8,220,000 $ 4,600,000
Employee hours 20,500 34,000 21,000 480,000 365,000
Number of employees 9 15 7 230 160
Square footage occupied 5,100 13,300 5,800 245,300 201,200

  

The costs of the service departments are allocated on the following bases: Administration, employee-hours; Communications, number of employees; and Facilities, square footage occupied.

Required:

a. Assume that the bank elects to distribute service department costs to production departments using the direct method. What amount of Communications Department costs is allocated to the Deposits Department?

b. Assume the same method of allocation as in requirement (a). What amount of Administration Department costs is allocated to the Loans Department?

c. Assuming that the bank elects to distribute service department costs to other departments using the step method (starting with Facilities and then Communications), what amount of Facilities Department costs is allocated to the Communications Department?

d. Assume the same method of allocation as in requirement (c). What amount of Communication Department costs is allocated to Facilities?

Solutions

Expert Solution

Under the Direct method, the costs of service department are allocated only in production departments, whereas in the Step method, Service department costs are allocated in Production department and other Service Departments in a sequential process.
a. Amount of Communications Department costs is allocated to the Deposits Department under Direct Method
Communication Department Costs are to be allocated on the basis of Number of Employees
Direct Cost of Communication Department $320,000
Total number of Employees of Production Departments (Deposits & Loans Departments) (230+160) 390
Cost per Employee 320000/390 $          820.51
No. of Employees in Deposits Department 230
Amount of Communications Department costs is allocated to the Deposits Department 230*$820.51 $ 188,717.95
b. Amount of Administration Department costs is allocated to the Loans Department Under Direct Method
Administration Department Costs are to be allocated on the basis of Number of Employees Hours
Direct Cost of Administration Department $210,000
Total number of Employee Hours of Production Departments (Deposits & Loans Departments) (480000+365000) 845000
Cost per Employee Hour 210000/845000 $          0.2485
No. of Employee Hours in Loans Department 365000
Amount of Administration Department costs is allocated to the Loans Department 365000*$0.2485 $    90,710.06
c. Amount of Facilities Department costs allocated to the Communications Department under Step method
in the Step method, Service department costs are allocated in Production department and other Service Departments in a sequential process. The sequence adopted by the Bank is First Facilities department, then Communications Department and then Administration Department.
The Cost of Facilities Department will be allocated between the Production Departments i.e. Deposits and Loans Department and remaining Service Departments (i.e. Communications Department and Administration Department)
The Facilities Department Costs will be allocated on the basis of square footage occupied
Direct Cost of Facilities Department $253,000
Total number of Square Footage of Deposits, Loans, Communications and Administration Department (245300+201200+13300+5100) 464900
Cost per Square Footage 210000/845000 $          0.5442
No. of Square Footage in Communications Department 13300
Amount of Facilities Department costs allocated to the Communications Department 13300*$0.5442 $      7,237.90
d. Amount of Communication Department costs allocated to the Facilities Department under Step method
Since in the Step method, Service department costs are allocated in Production department and other Service Departments in a sequential process and sequence adopted by the Bank is First Facilities department, then Communications Department and then Administration Department. Therefore the Communication Department Cost will be allocated between Production Departments i.e. Deposits and Loans Department and Administration Department. It will not be allocated to Facilities Department.

Related Solutions

State Financial Corp. has three service departments (Administration, Communications, and Facilities), and two production departments (Deposits...
State Financial Corp. has three service departments (Administration, Communications, and Facilities), and two production departments (Deposits and Loans). A summary of costs and other data for each department prior to allocation of service department costs for the year ended December 31 follows. Administration Communications Facilities Deposits Loans Direct costs $ 240,000 $ 330,000 $ 260,000 $ 7,890,000 $ 5,400,000 Employee hours 21,000 37,000 20,500 476,000 334,000 Number of employees 7 10 6 210 130 Square footage occupied 5,300 13,400 5,100...
State Financial Corp. has three service departments (Administration, Communications, and Facilities), and two production departments (Deposits...
State Financial Corp. has three service departments (Administration, Communications, and Facilities), and two production departments (Deposits and Loans). A summary of costs and other data for each department prior to allocation of service department costs for the year ended December 31 follows: Administration Communications Facilities Deposits Loans Direct costs $ 240,000 $ 300,000 $ 256,000 $ 8,170,000 $ 4,800,000 Employee hours 23,000 34,000 23,000 420,000 367,000 Number of employees 9 17 4 230 160 Square footage occupied 4,500 14,300 5,500...
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and...
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and Maintenance). During July, the following costs and service department usage ratios were recorded. Supplying Department Using Department Engineering Administration Maintenance Fabrication Assembly Engineering 0 40 % 0 15 % 45 % Administration 20 % 0 25 % 45 % 10 % Maintenance 0 30 % 0 15 % 55 % Direct cost $ 42,000 $ 248,550 $ 45,000 $ 230,000 $ 80,000 Required: Allocate...
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and...
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and Maintenance). During July, the following costs and service department usage ratios were recorded. Supplying Department Using Department Engineering Administration Maintenance Fabrication Assembly Engineering 0 40 % 0 15 % 45 % Administration 20 % 0 25 % 45 % 10 % Maintenance 0 30 % 0 15 % 55 % Direct cost $ 42,000 $ 248,550 $ 45,000 $ 230,000 $ 80,000 Required: Allocate...
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and...
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and Maintenance). During July, the following costs and service department usage ratios were recorded. Supplying Department Using Department Engineering Administration Maintenance Fabrication Assembly Engineering 0 50 % 0 10 % 40 % Administration 10 % 0 20 % 50 % 20 % Maintenance 0 50 % 0 20 % 30 % Direct cost $ 24,000 $ 179,500 $ 25,000 $ 185,000 $ 50,000    Required:...
1.Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and...
1.Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and Maintenance). During July, the following costs and service department usage ratios were recorded: Supplying Department Using Department Engineering Administration Maintenance Fabrication Assembly Engineering 0 50 % 0 10 % 40 % Administration 10 % 0 20 % 50 % 20 % Maintenance 0 20 % 0 20 % 60 % Direct cost $ 22,000 $ 193,300 $ 25,000 $ 180,000 $ 50,000    Required:...
Av-Y6 Company operates three service departments, administration, maintenance, and personnel and two production departments, assembly and...
Av-Y6 Company operates three service departments, administration, maintenance, and personnel and two production departments, assembly and packaging. Information for the three service departments is given below: Admin Maint Person Directly traced overhead $68,000 $46,000 $77,000 Square feet occupied 2,000 3,500 3,000 Number of employees 36 24 30 Maintenance hours 2,500 2,000 4,000 Information for the two production departments is given below: Assembly Packaging Directly traced overhead $167,060 $120,090 Square feet occupied 2,100 1,400 Number of employees 42 18 Maintenance hours...
Av-Y6 Company operates three service departments, administration, maintenance, and personnel and two production departments, assembly and...
Av-Y6 Company operates three service departments, administration, maintenance, and personnel and two production departments, assembly and packaging. Information for the three service departments is given below: Admin Maint Person Directly traced overhead $65,000 $33,000 $74,000 Square feet occupied 2,000 3,500 3,000 Number of employees 42 24 30 Maintenance hours 2,500 2,000 4,000 Information for the two production departments is given below: Assembly Packaging Directly traced overhead $167,030 $114,090 Square feet occupied 2,100 1,400 Number of employees 36 18 Maintenance hours...
Av-Y6 Company operates three service departments, administration, maintenance, and personnel and two production departments, assembly and...
Av-Y6 Company operates three service departments, administration, maintenance, and personnel and two production departments, assembly and packaging. Information for the three service departments is given below: Admin Maint Person Directly traced overhead $68,000 $46,000 $77,000 Square feet occupied 2,000 3,500 3,000 Number of employees 36 24 30 Maintenance hours 2,500 2,000 4,000 Information for the two production departments is given below: Assembly Packaging Directly traced overhead $167,060 $120,090 Square feet occupied 2,100 1,400 Number of employees 42 18 Maintenance hours...
Craylon Corp has two service departments, S1 and S2, and two production departments, P1 and P2....
Craylon Corp has two service departments, S1 and S2, and two production departments, P1 and P2. The data for April were as follows: Services provided to: Activity Costs S1 S2 P1 P2 S1 $100,000 25% 40% 35% S2 $80,000 10% 55% 35% Fixed Costs P1 $400,000 P2 $500,000 One of the algebraic equations in linear form for an activity using the reciprocal method is S2 = 80,000 +.25S1 S1=100,000 + .25S2 S2 = 80,000 + .35S1 S1 = 100,000 +.10S2
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT