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: Provider of Service Computing User of Service HR HR 15% Computing Deposit 10% 60% 50% Loan 30% 35% The budgeted costs in the two service departments for the year are as follows: $153,000 229,500 HR Computing Required: Use the step-down method to allocate the budgeted costs of the HR and Computing departments to the Deposit and Loan departments. Tuscaloosa National Bank allocates the costs of the HR Department first. (Do not round intermediate calculations.) Deposit Loan Allocation of HR Department costs Allocation of Computing Department costs Total costs allocated to each department 91,800 s 45,900 91,800 S 45,900

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: Provider of Service Computing User of Service HR HR 15% Computing Deposit 10% 60% 50% Loan 30% 35% The budgeted costs in the two service departments for the year are as follows: $153,000 229,500 HR Computing Required: Use the step-down method to allocate the budgeted costs of the HR and Computing departments to the Deposit and Loan departments. Tuscaloosa National Bank allocates the costs of the HR Department first. (Do not round intermediate calculations.) Deposit Loan Allocation of HR Department costs Allocation of Computing Department costs Total costs allocated to each department 91,800 s 45,900 91,800 S 45,900

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

View Policies Current Attempt in Progress Blossom's Medical operates three support departments and two operating units, Surgery and ER. The support departments are allocated based on the hours used. The cost of operating the accounting (acct), administration (admin), and human resources (HR) departments is $274500, $164700, and $66000, respectively. Information on the hours used are as follows: Acct Admin HR Surgery ER Hours in Acct 20 48 360 220 Hours in Admin 16 8 120 80 Hours in HR 8 4 65 130 What amount of costs would be allocated from the HR department to the other support departments (Acct and Admin) using the reciprocal method to allocate costs? (Do not round the intermediate calculations.) $5438. $0. $7203. $6894. eTextbook and Media
Division Accounting Personnel Information Technology Sales Production 8. 9. 10. 90 Number of Employees No Shows Pald (Non- Cancellations Registrations Attended refundable) (Refundable) 50 26 14 (I) 208 150 185 TRAINING ATTENDANCE AND RELATED COSTS BY DIVISION TRAINING ATTENDANCE C. $40,000. D. $41,600. 81 156 102 157 The value of (III) is A. $31,200. B. $32,448. The value of (IV) is A. $6,525. B. $7,050. C. $9,225. D. $9,450. 6 28 31 23 3 24 17 5 Attendance Ratio of Those Registered 0.52 0.90 (II) Adjusted Cost per Total Cost per Salary Registration Registration Cancellation Training Registration (5) (5) Payment (5) Refunds ($) Cost (5) (5) 6,700 100 5,000 1,000 10,700 268 2,700 225 (IV) 47,200 6,000 0.85 4,625 0.75 10,400 200 75 The value of (V) (rounded to the nearest whole dollar) is A. $71. B. $83. C. $86. D. $98. RELATED COSTS Registration Cost 140 60 6,750 (III) 21,000 11,100 4,800 106 257 185 2,380 24,620 300 15,425 (V)
Exercises 9. In Auditing Company there are 10 workers whose working time can be allocated to the commissions. Their annual salaries and social costs are as follows: Auditor Accountant Assistant Direct costs 2 * 56 000 = 112 000 5 * 43 000 = 215 000 3 * 24 000 = 72 000 399 000 The indirect costs per year are 189 000 euros and the expected profit per year 20 000 euros. Yearly working time is 1496 hours/worker. a) How much is the overhead rate 1 ? b) How much is the overheat rate 2 ? c) How much should the price (with VAT) of a commission be, if it takes time as follows: Auditor Accountant Assistant 2 hours 8 hours 3 hours
PART 3 Betty's Book and Music Store has two service departments, Warehouse and Data Centre. Warehouse Department costs of $175,000 are allocated on the basis of budgeted warehouse-hours. Data Centre Department costs of $75,000 are allocated based on the number of computer log-on hours. The costs of operating departments Music and Books are $125,000 and $150,000, respectively. Data on budgeted warehouse-hours and number of computer log-on hours are as follows: Support Departments Warehouse Production Departments Department Data Centre Department Music Books Budgeted costs $175,000 $75,000 $125,000 $150,000 Budgeted warehouse- NA 250 500 750 hours Number of computer hours 100 ΝΑ 400 500 Required: 1. Assign the support department costs to the production departments using: a. The Direct Method (3) b. The Step-Down Method assigning the Warehouse Department first (4) c. The Reciprocal Method using linear equations. (4)
Exercise 11-36 (Algo) Cost Allocation: Step Method (LO 11-3) Bens Corporation has three service departments (Repairs, HR, and IT) and two production departments (M1 and M2). The following usage data for each of the service departments for the previous period follow. Repairs HR IT M1 M2 Repairs — 0 % 0 % 40 % 60 % HR 10 % — 20 % 35 % 35 % IT 0 % 10 % — 20 % 70 % The direct costs of the service departments in the previous period were $92,000 for Repairs, $111,600 for HR, and $207,000 for IT. Required: Use the step method to allocate the service department costs to the production departments. Allocate HR costs first, followed by IT, and then Repairs. (Negative amounts should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.)
Answer question 3-4 using the information below: Fantasy Book and Music Store has two support departments and two production departments. Costs of each department are presented below. Data on budgeted warehouse-hours and number of computer log-on hours for cost allocation of support departments are as follows: Support Departments Production Departments Warehouse Data Center Music Books Budgeted costs Budgeted warehouse-hours Number of computer hours $495,000 1,750 $412,500 3,500 2,800 $1,155,000 $495,000 N/A 5,250 3,500 700 N/A 3. Using the direct method, how much are the total costs of the Books Department? A. $495,000 B. $275,000 C. $693,000 D. $1,463,000 4. Using the step-down method, what amount of Data Center Department cost will be allocated to Music Department if the service department with the highest percentage of interdepartmental support service is allocated first? A. $387,229 B. $220,001 C. $307,267 D. $381,150
Question 3 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: SUPPORT OPERATING AS IS GVT CORP TOTAL Budgeted overhead costs $600,000 $2,400,000 $8,756,000 $12,452,000 $24,208,000 before any inter-department cost allocations Support work supplied by 25% 40% 35% 100% AS (budgeted head count) Support work supplied by 10% IS (budgeted time) computer 30% 60% 100% Required: 1. Allocate the two support departments' costs to the two operating departments using the following methods: a. Direct method b. Step-down method (allocate AS first) c. Step-down method (allocate IS first) 2. Compare and explain differences in the support-department costs allocated to each operating department.
Direct Method Eilers Company has two producing departments and two support departments. The following budgeted data pertain to these four departments: Support Departments Producing Departments General Factory Receiving Assembly Finishing Direct overhead $430,000 $170,000 $45,000 $76,000 Square footage 2,500 5,000 5,000 Number of receiving orders 320 1,900 1,200 Direct labor hours 28,000 45,000 The company has decided to simplify its method of allocating support service costs by switching to the direct method. Required: 1. Allocate the costs of the support departments to the producing departments using the direct method. Round allocation ratios to four significant digits. Round allocated costs to the nearest dollar. Use the rounded values for subsequent calculations. Allocation ratios: Assembly Finishing Square footage Number of receiving orders
ezto.mheducation.com Homework: Cost Management and Allocation Assignment Question 7- Homework: Cost Management and Allocation Assignment- Connect Homework: Cost Management and Allocation Assignm... i Saved Help Save & Exit Submit Check my work 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. 4. points Administration Communications Facilities Deposits $8,320,000 $4,600,000 447, 000 Loans Direct costs $200,000 24,000 $290,000 31,000 $253,000 20,500 Employee hours Number of employees Square footage occupied Skipped 360,000 8. 14 6. 230 130 4,600 13,800 5,100 244, 100 203,300 The costs of the service departments are allocated on the following bases: Administration, employee-hours; Communications, number of employees; and Facilities, square…
Problem 11-60 (Algo) Cost Allocation: Step and Reciprocal Methods (LO 11-1) Dunedin Bank has two operating departments (Retail and Commercial) and three service departments: Operations, Information Technology (IT), and Transactions. For the last period, the following costs and service department usage ratios were recorded: Supplying Department Transactions IT Operations Direct cost Using Department Transactions IT Operations Retail Commercial Ө Ө 70% 30% 10% Ө 20% 30% 40% 50% Ө Ө 10% 40% $ 390,000 $ 810,000 $ 1,650,000 $ 3,850,000 $ 2,400,000 Required: a. Allocate the service department costs to the two operating departments using the reciprocal method. From: Costs Operations Allocated to: Transactions Retail Commercial IT $ 810,000 $ 162,000 $ 81,000 $ 243,000 $ 324,000 Operations Transactions Total $ 243,000 $ 324,000
Question 4: Dhofar Company manufactures two products M1 and Z1. Its sales department has three divisions: Salalah, Raysut and Mirbat. Initial estimates for the sales budgets for the year ending 31 December 2021 which are based on the assessments of the divisional executives are as follows; Product M1 : Salalah 45,000 units: Raysut 110,000 units and Mirbat: 25,000 units Product Z1: Salalah 70,000 units: Raysut 82,000 units and Mirbat:0 Sales Prices: M1: 3 OMR and Z1= 4 OMR in all areas. Arrangements are made for the extensive advertising of product M1 and Z1 and it is estimated that Salalah division sales will increase by 30,000 units. Arrangements are also made to advertise and distribute product z1 in the Mirbat area in the second half of 2021 when sales are expected to be 100,000 units. Since the estimated sales of the Raysut division represented an unsatisfactory target, it is agreed to increase both the estimates by 15 %. Prepare a sales budget for the year to 31…
Question 4: Dhofar Company manufactures two products M1 and Z1. Its sales department has three divisions: Salalah Ravsut and Mirkat. Initial estimates for the sales budgets for the year ending 31 December 2021 which are based on the assessments of the divisional executives are as follows; Product M1 : Şalalah 45,000 units: Raxsut 110,000 units and Mirkat; 25,000 units Product Z1: Salalah 70,000 units: Raysut 82,000 units and Mirbat:0 Sales Prices: M1: 3 OMR and Z1= 4 OMR in all areas. Arrangements are made for the extensive advertising of product M1 and Z1 and it is estimated that Salalah division sales will increase by 30,000 units. Arrangements are also made to advertise and distribute product z1 in the Mirkat area in the second half of 2021 when sales are expected to be 100,000 units. Since the estimated sales of the Ravsut division represented an unsatisfactory target, it is agreed to increase both the estimates by 15 %. Prepare a sales budget for the year to 31 December 2021.