6) 16% -Given the following data for operation departments A and B, prepare a schedule using the direct and step method of allocation to allocate service department costs to the operating departments and show total cost for department A and B. Department Costs # of Employees Square Feet Operating Dept A $1600 80 200 Operating Dept B $1300 120 300 Maintenance $3,000 100 100 Payroll $4,000 100 100 For the step method, begin with the maintenance department.

6) 16% -Given the following data for operation departments A and B, prepare a schedule using the direct and step method of allocation to allocate service department costs to the operating departments and show total cost for department A and B. Department Costs # of Employees Square Feet Operating Dept A $1600 80 200 Operating Dept B $1300 120 300 Maintenance $3,000 100 100 Payroll $4,000 100 100 For the step method, begin with the maintenance department.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter7: Allocating Costs Of Support Departments And Joint Products

Section: Chapter Questions

Problem 24E: Refer to the data in Exercise 7.22. The support departments are ranked in order of highest cost to...

See similar textbooks

Similar questions

Distribution of service department costs to production departments using the sequential distribution method Required: Using the information in P4-6, prepare a schedule showing the distribution of the service departments’ expenses using the sequential distribution method in the order of number of other departments served. (Hint: First distribute the service department that services the greater number of other departments.)
Hh1. Account
D1. Account
Karen Co. has four departments: Materials, Personnel, Manufacturing, and Packaging. In a recent month, the four departments incurred three shared indirect expenses. The amounts of these indirect expenses and the bases used to allocate them follow. Indirect Expense Cost Allocation Base Supervision Utilities $ 82,000 Number of employees 59,000 Square feet occupied 27,000 Value of assets in use Insurance Total $168,000 Departmental data for the company's recent reporting period follow. Department Materials Employees Square Feet 66,500 9,500 95,000 19,000 Asset Values 58 $10,350 4,140 38,640 15,870 Personnel 8 Manufacturing Packaging 70 64 Total 200 190,000 $69,000 1. Use this information to allocate each of the three indirect expenses across the four departments. 2. Prepare a summary table that reports the indirect expenses assigned to each of the four departments. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Use this information to allocate…
Required information [The following information applies to the questions displayed below.] The following information is departmental cost allocation with two service departments and two production departments. Department Service 1 (S1) Service 2 (S2) Production 1 (P1) Production 2 (P2) Cost $ 47,000 37,000 270,000 320,000 Service Department Cost Allocation Total Cost Percentage Service Provided to P1 S1 0% 20 S2 20% 0 What is the total cost in P1 and P2 and what is the amount of service department cost allocated to P1 and P2 using the step method with S1 going first? P1 40% 20 P2 P2 40% 60
The Bramble Company makes wheels and wings for ground transport vehicles and drones. In addition to the key manufacturing departments, Bramble needs two key support services, provided by its Maintenance and IT departments. The Maintenance costs are allocated to other departments based on the square footage of space each department occupies. The IT department allocates its costs to other departments based on the amount of time the IT employees spend assisting the other departments. The cost information of all four departments, along with their usage information for both allocation bases, is as follows. Initial cost Square feet occupied IT labor hours used Support Departments Maintenance IT $120.000 $74.000 1,100 1.800 1,100 Operating Departments Wheels $396,000 2,160 2,280 Wings $700,000 5,040 h 1.720 Totals $1,290,000 10,100 5,100
Comprehensive support department allocationsManagement at C. Pier Press has decided to allocate costs of the paper’s two support departments (administration and human resources) to the two revenue-generating departments (advertising and circulation). Administration costs are to be allocated on the basis of dollars of assets employed; human resources costs are to be allocated on the basis of number of employees. The following costs and allocation bases are available: Department Direct Costs Number of Employees Assets Employed Administration $1,094,100 14 $541,940 Human resources 689,780 11 408,380 Advertising 1,340,920 17 1,067,360 Circulation 1,893,640 36 2,618,420 Totals $5,018,440 78 $4,636,100 e. Using the algebraic method, allocate the support department costs to the revenue-generating departments. Note: Round percentages in your calculation to the nearest whole percent (for example, round 34.5% to 35%). Note: Round your final answer to the nearest…
Comprehensive support department allocationsManagement at C. Pier Press has decided to allocate costs of the paper’s two support departments (administration and human resources) to the two revenue-generating departments (advertising and circulation). Administration costs are to be allocated on the basis of dollars of assets employed; human resources costs are to be allocated on the basis of number of employees. The following costs and allocation bases are available: Department Direct Costs Number of Employees Assets Employed Administration $1,094,100 14 $541,940 Human resources 689,780 11 408,380 Advertising 1,340,920 17 1,067,360 Circulation 1,893,640 36 2,618,420 Totals $5,018,440 78 $4,636,100 c. Assuming that the benefits-provided ranking is the order shown in the table, use the step method to allocate the support department costs to the revenue-generating departments.Note: Round your final answers only to the nearest whole dollar. Amount allocated…
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)
Comprehensive support department allocations Management at C. Pier Press has decided to allocate costs of the paper’s two support departments (administration and human resources) to the two revenue-generating departments (advertising and circulation). Administration costs are to be allocated on the basis of dollars of assets employed; human resources costs are to be allocated on the basis of number of employees. The following costs and allocation bases are available: Department Direct Costs Number of Employees Assets Employed Administration $390,750 5 $193,550 Human resources 246,350 4 145,850 Advertising 478,900 6 381,200 Circulation 676,300 13 935,150 Totals $1,792,300 28 $1,655,750 a. Using the direct method, allocate the support department costs to the revenue-generating departments.Note: Round percentages in your calculation to the nearest whole percent (for example, round 34.5% to 35%).Note: Round your final answer to the nearest whole dollar.Total…
1. Allocate the support departments' costs to the operating departmens using the direct method. 2. Rank the support departments based on the % of their services provided to other support departments. Use this ranking to allocate the support departments' costs to the operating departments based on the step-down method. 3. How could you have ranked teh support departments differently?
Answer with all workings for all with steps explanation calculation formula answer in text