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, InformationTechnology (IT), and Transactions. For the last period, the following costs and service department usage ratios were recorded:SupplyingDepartmentTransactionsITOperationsDirect costITFrom:OperationsTransactionsTransactionsTotal810%70%$ 310,000ITUsing DepartmentOperationsCostsOperationsS 250,000 $ 750,000670,000 X1,510,000 x888$ 730,000Required:a. Allocate the service department costs to the two operating departments using the reciprocal method.Answer is complete but not entirely correct.Allocated to:Transactions$ 250,000 $2,233,333 x830%8$ 1,570,000$RetailRetail0X $0.x0x0CommercialS$ 3,770,00078%30%10%833,333 X0x0x833,333Commercial36%38%28%$ 2, 320, 000

Cost allocation:Cost allocation refers to the costing technique through which costs can be allocated…

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 IT From: Operations Transactions Total Transactions 8 10% 70% $ 310,000 IT Using Department Operations Costs Operations S 250.000 $ 750,000 670,000 x 1.510,000 x 8 8 8 $ 730,000 Required: a. Allocate the service department costs to the two operating departments using the reciprocal method. Answer is complete but not entirely correct. Allocated to: Transactions 0 30% 8 $ 250,000 $ 2,233,333 x $ 1,570,000 $ 3,770,000 Retail Retail Commercial 833,333 X x 0X S 0x 0x 0 S 70% 30% 10% 833,333 Commercial 30% 38% 28% $ 2,320,000

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 IT From: Operations Transactions Total Transactions 8 10% 70% $ 310,000 IT Using Department Operations Costs Operations S 250.000 $ 750,000 670,000 x 1.510,000 x 8 8 8 $ 730,000 Required: a. Allocate the service department costs to the two operating departments using the reciprocal method. Answer is complete but not entirely correct. Allocated to: Transactions 0 30% 8 $ 250,000 $ 2,233,333 x $ 1,570,000 $ 3,770,000 Retail Retail Commercial 833,333 X x 0X S 0x 0x 0 S 70% 30% 10% 833,333 Commercial 30% 38% 28% $ 2,320,000

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 30E: A company uses charging rates to allocate service department costs to the using departments. The...

See similar textbooks

Similar questions

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
Problem 11-60 (Algo) Cost Allocation: Step and Reciprocal Methods (LO 11-3, 4) Great Eastern Credit Union (GECU) has two operating departments (Branches and Electronic) and three service departments (Processing, Administration, and Maintenance). During July, the following costs and service department usage ratios were recorded: Supplying Department Using Department Processing Administration Maintenance Branches Electronic Processing 0 40 % 0 15 % 45 % Administration 0 0 0 60 % 40 % Maintenance 10 % 20 % 0 20 % 50 % Direct cost $ 89,000 $ 590,000 $ 310,000 $ 4,900,000 $ 1,950,000 Required: Allocate the service department costs to the two operating departments using the reciprocal method.
Customers as a Cost Object Morrisom National Bank has requested an analysis of checking account profitability by customer type. Customers are categorized according to the size of their account: low balances, medium balances, and high balances. The activities associated with the three different customer categories and their associated annual costs are as follows: Additional data concerning the usage of the activities by the various customers are also provided: Required: (Note: Round answers to two decimal places.) 1. Calculate a cost per account per year by dividing the total cost of processing and maintaining checking accounts by the total number of accounts. What is the average fee per month that the bank should charge to cover the costs incurred because of checking accounts? 2. Calculate a cost per account by customer category by using activity rates. 3. Currently, the bank offers free checking to all of its customers. The interest revenues average 90 per account; however, the interest revenues earned per account by category are 80, 100, and 165 for the low-, medium-, and high-balance accounts, respectively. Calculate the average profit per account (average revenue minus average cost from Requirement 1). Then calculate the profit per account by using the revenue per customer type and the unit cost per customer type calculated in Requirement 2. 4. CONCEPTUAL CONNECTION After the analysis in Requirement 3, a vice president recommended eliminating the free checking feature for low-balance customers. The bank president expressed reluctance to do so, arguing that the low-balance customers more than made up for the loss through cross-sales. He presented a survey that showed that 50% of the customers would switch banks if a checking fee were imposed. Explain how you could verify the presidents argument by using ABC.
Algebraic method The following chart indicates the percentage of support department services used by other departments. Service departments are designated S1, S2, and S3; operating departments are designated RP1 and RP2. Services Used S3 Department S1 S2 N/A 10% 40% N/A S1 S2 S3 20 30 N/A RP1 RP2 20% 30% 40% 30 20 10 40 10 Direct costs of the period were $170,000, $360,000, and $600,000 for S1, S2, and S3, respectively. Allocate the support department costs to the operating departments using the algebraic method. Note: Do not round proportions in your calculations; round your final answer to the nearest whole dollar. Note: Round your final answers below to the nearest 100; for example, round 8,668 to 8,700.
Calculating ABC Unit Costs Perkins National Bank has collected the following information for four activities and two types of credit cards: Activity Driver Classic Gold Activity Rate ($) Processing transactions Transactions processed 12,000 7,200 0.20 Preparing statements Number of statements 12,000 7,200 0.95 Answering questions Number of calls 24,000 36,000 4.00 Providing ATMs ATM transactions 48,000 14,400 1.50 There are 5,000 holders of Classic cards and 21,000 holders of the Gold cards. Required: Calculate the unit cost (rounded to the nearest cent) for Classic and Gold credit cards. Unit cost for Classic $fill in the blank 1 Unit cost for Gold $fill in the blank 2
Calculating ABC Unit Costs Perkins National Bank has collected the following information for four activities and two types of credit cards: Activity Driver Classic Gold Activity Rate ($) Processing transactions Transactions processed 12,000 7,200 0.20 Preparing statements Number of statements 12,000 7,200 0.95 Answering questions Number of calls 24,000 36,000 4.00 Providing ATMs ATM transactions 48,000 14,400 1.50 There are 4,700 holders of Classic cards and 19,900 holders of the Gold cards. Required: Calculate the unit cost (rounded to the nearest cent) for Classic and Gold credit cards. Unit cost for Classic Unit cost for Gold
> Calculating ABC Unit Costs Perkins National Bank has collected the following information for four activities and two types of credit cards: Activity Driver Classic Gold Activity Rate Processing transactions Transactions processed 12,000 7,200 $0.20 Preparing statements Number of statements 12,000 7,200 0.95 Answering questions Number of calls 24,000 36,000 4.00 ATM transactions 48,000 14,400 1.50 Providing ATMS There are 7,500 holders of Classic cards and 30,000 holders of Gold cards. Required: Calculate the unit cost (rounded to the nearest cent) for Classic and Gold credit cards. Unit cost for Classic Unit cost for Gold 35.66 X 9.07 X
Cost Direct Center Cost Proportion of Services used by: S1 S2 S3 P1 P2 P3 S1 P120,000 .10 .30 .25 .20 .15 S2 80,000 .20 .40 .20 .20 S3 45,000 .60 .35 .05 P1 78,000 P2 99,000 P3 45,000 __________26. Under the step method which department will allocate its direct cost first? __________27. Under the step method which department will allocate its direct cost last? __________28. Using the algebraic method, how much is the total costs to be allocated by S1 to all departments? __________29. Using algebraic method, how…
Customers as a Cost ObjectMorrisom National Bank has requested an analysis of checking account profitability by customer type. Customers are categorized according to the size of their account: low balances, mediumbalances, and high balances. The activities associated with the three different customer categories and their associated annual costs are as follows: Required:(Note: Round answers to two decimal places.)1. Calculate a cost per account per year by dividing the total cost of processing andmaintaining checking accounts by the total number of accounts. What is the average feeper month that the bank should charge to cover the costs incurred because of checkingaccounts?2. Calculate a cost per account by customer category by using activity rates.3. Currently, the bank offers free checking to all of its customers. The interest revenuesaverage $90 per account; however, the interest revenues earned per account by categoryare $80, $100, and $165 for the low-, medium-, and high-balance…
QUESTION 2/15 2020033800068702: From the following information distribute cost of Time Keeping department among various other departments: Total cost of Time keeping department as per primary Distribution: Rs. 10000, Ratio of Stores Requisition: 4:3:2:1, Ratio of Machine Hours: 3:3:2:2, Ratio of No of Employee: 3:4:2:1 and Ratio of Floor area: 5:3:1:1 O Rs. 4000, Rs. 3000, Rs. 2000 and Rs. 1000 O Rs. 3000, Rs. 3000, Rs. 2000 and Rs. 2000 O Rs. 3000, Rs. 4000, Rs. 2000 and Rs. 1000 O Rs. 5000, Rs. 3000, Rs. 1000 and Rs. 1000
Account Activity and Relationships Each case is independent. Solve for missing data in alphabetical order. (Hint: Refer to Exhibit 18.6, p. 18-17 and the WIP table, p. 18-25.) Case A Case B Case C Case D Sales $425,000 Answer 550,000 Answer Direct materials 75,000 105,000 Answer 105,000 Direct labor 25,000 Answer 100,000 Answer Total direct costs Answer 160,000 Answer 150,000 Conversion cost Answer 130,000 Answer Answer Manufacturing overhead 40,000 Answer 50,000 Answer Current manufacturing costs Answer Answer 475,000 395,000 Work in process, beginning 35,000 50,000 Answer 105,000 Work in process, ending 25,000 Answer 105,000 Answer Cost of goods manufactured Answer 160,000 Answer 410,000 Finished goods inventory, beginning 45,000 40,000 35,000 60,000 Finished goods inventory, ending 30,000 Answer 40,000 Answer Cost of goods sold Answer 175,000 Answer 400,000 Gross profit…
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) Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and P2). The distribution of each service department’s efforts (in percentages) to the other departments is: From To S1 S2 P1 P2 S1 — 10% 20% ?% S2 10% — ? 30 The direct operating costs of the departments (including both variable and fixed costs) are: S1 $ 180,000 S2 60,000 P1 50,000 P2 120,000 Required: 1. Determine the total cost of P1 and P2 using the direct method. 2. Determine the total cost of P1 and P2 using the step method. 3. Determine the total cost of P1 and P2 using the reciprocal method.