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...
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...
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...
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 +...
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...
Question 3 Ted’s Travel Agency provides travel services for walk-in retail clients and for corporate clients....
Question 3 Ted’s Travel Agency provides travel services for walk-in retail clients and for corporate clients. It is the largest privately owned travel agency in the greater Toronto area. Ted Thompson has been the owner since its first day of business. Many clients are walk-ins who live within a fivekilometre radius of the office, and others hear about the agency from friends and will drive from much farther away. The agency also has a large and growing component of business...
The Superior Gardening Service provides gardening services to its clients. The company uses an activity-based costing...
The Superior Gardening Service provides gardening services to its clients. The company uses an activity-based costing system for its overhead costs. The company has provided the following data from its activity-based costing system. Activity Cost Pool   Total Cost    Total Activity Gardening $125,425 17,300 hours Job support 28,134 1,775 jobs Client support 4,530 280 clients Other     150,000 Not applicable Total   $308,089 The "Other" activity cost pool consists of the costs of idle capacity and organization-sustaining costs. One particular client, the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT