Question

In: Accounting

Texas Building Services provides cleaning services for a variety of clients. The company has two producing​...

Texas Building Services provides cleaning services for a variety of clients. The company has two producing​ departments, residential and​ commercial, and two service​departments, personnel and administrative. The company has decided to allocate all service department costs to the producing​ departments' personnel on the basis of number of employees and administrative on the basis of direct department costs. The budget for 20X2 shows the​ following:

Personnel

Administrative

Residential

Commercial

Direct department costs

$70,000

$100,000

$240,000

$400,000

Number of employees

3

5

12

18

Direct-labor hours

24,000

36,000

Square feet cleaned

4,500,000

9,970,000

Requirement 1. Allocate service department costs using the direct method. ​(Use parentheses or a minus sign when decreasing departments by allocating costs. For amounts with a​ $0 balance, make sure to enter​ "0" in the appropriate​ cell.)

Personnel

Administrative

Residential

Commercial

Direct department costs before allocation

Personnel

Administrative

Total costs after allocation

Requirement 2. Allocate service department costs using the​ step-down method. Personnel costs should be allocated first. ​(Use parentheses or a minus sign when decreasing departments by allocating costs. For amounts with a​ $0 balance, make sure to enter​ "0" in the appropriate​ cell.)

Personnel

Administrative

Residential

Commercial

Direct department costs before allocation

Personnel

Administrative

Total costs after allocation

Requirement 3. Suppose the company prices by the hour in the residential department and by the square foot cleaned in commercial. Using the results of the​step-down allocations in number​ 2, (a) compute the cost of providing 1​ direct-labor hour of service in the residential department and​ (b) compute the cost of cleaning one square foot of space in the commercial department.

​(a) First determine the​ formula, then compute the cost of providing 1​ direct-labor hour of service in the residential department. ​(Round your answer to the nearest​ cent.)

  

/

=

Cost per direct-labor hour

/

=

​(b) Next, determine the​ formula, then compute the cost of cleaning one square foot of space in the commercial department. ​(Round your answer to the nearest​ cent.)

/

  

=

Cost per one square foot

/

=

Requirement 4. For each type of cost assignment made in number 2 using the​ step-down method, indicate the assignment type using the framework for cost accounting system

Allocations from the personnel to the administrative departments are__________ allocations. Allocations from the administrative to the residential and commercial operating departments are allocations.

Solutions

Expert Solution

1. Allocation of service department cost using direct method

Personnel

Administrative

Residential

Commercial

Direct department costs before allocation

$70000 $100000 $240000 $400000

Personnel

- 0 $28000 $42000

Administrative

0 - $37500 $62500

Total costs after allocation

0 0 $305500 $504500

2. Allocation of service department cost using step down method.

Personnel

Administrative

Residential

Commercial

Direct department costs before allocation

$70000 $100000 $240000 $400000

Personnel

- $10000 $24000 $36000

Administrative

0 0 $41250 $68750

Total costs after allocation

0 0 $305250 $504750

Note : in step down method only one service cost is allocated to both service and production department, rest of them is allocated on the basis of department. In this case Personnel Department is allocated first, administration department cost ($100000 + 10000) allocated on the basis of department.

3.

a. cost of providing 1​ direct-labor hour of service in the residential department

total cost of residential department

after allocation

/

total direct labor hours

=

Cost per direct-labor hour

$305250

/

24000 hours

=

$12.718

b. cost of cleaning one square foot of space in the commercial department.

total cost of commercial department

after allocation

/

total square foot cleaned

=

Cost per one square foot

$504750

/

9970000

=

$0.0506

4.

Allocations from the personnel to the administrative departments are STEP-DOWN allocations.

Allocations from the administrative to the residential and commercial operating departments are DEPARTMENT allocations.


Related Solutions

Austin Partners provides management consulting services to government and corporate clients. Austin has two support departments...
Austin Partners provides management consulting services to government and corporate clients. Austin has two support departments —administrative services​ (AS) and information systems (IS)—and two operating departments—government consulting​ (GOVT) and corporate consulting​ (CORP). For the first quarter of 2013​, Austin's cost records indicate the​ following: SUPPORT OPERATING AS IS GOVT CORP Total Budgeted overhead costs before any interdepartment cost allocations $690,000 $1,800,000 $7,325,000 $12,550,000 $22,365,000 Support work supplied by AS (budgeted head count) --- 20% 52% 28% 100% Support work supplied...
Boston Partners provides management consulting services to government and corporate clients. Boston has two support Departments...
Boston Partners provides management consulting services to government and corporate clients. Boston has two support Departments —administrative services​ (AS) and information systems (IS)—and two operating departments—government consulting​ (GOVT) and corporate consulting​ (CORP). For the first quarter of 2013​, Boston's cost records indicate the​ following: SUPPORT OPERATING AS IS GOVT CORP Total Budgeted overhead costs before any interdepartment cost allocations $630,000 $3,000,000 $8,725,000 $12,470,000 $24,825,000 Support work supplied by AS (budgeted head count) 0 20% 48% 32% 100% Support work supplied...
Job order cost accounting for a service company The Fly Company provides advertising services for clients...
Job order cost accounting for a service company The Fly Company provides advertising services for clients across the nation. The Fly Company is presently working on four projects, each for a different client. The Fly Company accumulates costs for each account (client) on the basis of both direct costs and allocated indirect costs. The direct costs include the charged time of professional personnel and media purchases (air time and ad space). Overhead is allocated to each project as a percentage...
James House is planning on starting a cleaning services business but has not decided whether he should focus on residential clients or commercial clients.
James House is planning on starting a cleaning services business but has not decided whether he should focus on residential clients or commercial clients. His estimates of revenue, variable expenses, and fixed expenses are shown below.     Residential Commercial Revenue $25 per hour $35 per hour Variable expense $15 per hour $20 per hour Fixed expense $500 per month $825 per hour   Required: 1. At what volume of hours per month will James be indifferent between focusing on...
Your company provides a variety of delivery services. Management wants to know the volume of a...
Your company provides a variety of delivery services. Management wants to know the volume of a particular delivery that would generate $10,000 per month in operating profits before taxes. The company charges $20 per delivery. The controller’s office has estimated overhead costs at $9,000 per month for fixed costs and $12 per delivery for variable costs. You believe that the company should use regression analysis. Your analysis shows the results to be: Monthly overhead = $ 26 , 501 +...
Phoenix Partners provides management consulting services to government and corporate clients. Phoenix has two support departments—administrative...
Phoenix Partners provides management consulting services to government and corporate clients. Phoenix has two support departments—administrative services (AS) and information systems (IS)—and two operating departments—government consulting (GOVT) and corporate consulting (CORP). For the first quarter of 2017, Phoenix’s cost records indicate the following: Allocation of Administrative Services on dollar amount ranking is $150,000 Allocate the support divisions’ costs to the operating divisions using the direct method. Allocate the support divisions’ costs to the operating divisions using the step-down method. Start...
The Angela’s home cleaning ltd provides home cleaning services. The following is the 1 March 2020...
The Angela’s home cleaning ltd provides home cleaning services. The following is the 1 March 2020 Trial Balance (TB). The company has not made all the March entries but the required info is given below. You will be asked to update the accounts as at 31 March 2020. angela’s Cleaning COMPANY Angela’s Unadjusted Trial Balance 1 March 2020             Cash...................................................................................... $ 5,700             Accounts receivable...........................................................      1,800             Cleaning supplies...............................................................         800             Accounts payable...............................................................                              300             Dividend payable...................................................................
A&B Co. provides house cleaning services. The company uses the number of jobs to measure activity....
A&B Co. provides house cleaning services. The company uses the number of jobs to measure activity. At the beginning of April, the company budgeted for 80 jobs, but the actual number of jobs turned out to be 90. A report comparing the budgeted revenues and costs to the actual revenues and costs appears below: A&B Co. For the Month Ended April 30 Revenue/Cost Formulas Actual Results Planning Budget Number of jobs (Q) 90 80 Revenue $100Q 8,900 8,000 Expenses: Variable...
Part 2 Communications Unlimited provides support services to its clients. This company expects to earn an...
Part 2 Communications Unlimited provides support services to its clients. This company expects to earn an annual return on the assets invested at a rate of: 20% The company has the following amount invested in the business: $8,000,000 The annual budgeted costs for next year are: Variable costs Fixed costs Support Services $600,000 1,900,000 The annual budgeted hours for next year are: Consulting services           60,000 hours Required: You must use cell references for all calculations. 5. Determine the markup...
Karuda Transportation Sdn Bhd provides bonded trucking services to its clients. The company is evaluating a...
Karuda Transportation Sdn Bhd provides bonded trucking services to its clients. The company is evaluating a potential lease arrangement on a truck that cost $250,000 and falls into the MACRS 5-year class. The applicable MACRS depreciation rates are 20%, 32%, 19%, 12%, 11% and 6%. Karuda has a ready credit line from their banker, a term loan financing with an attractive rate of 10% p.a. if they decided to borrow money and buy the asset rather than lease it. The...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT