The operations vice president of Security Home Bank has been interested in investigating the efficiency of the bank's operations. She has been particularly concerned about the costs of handling routine transactions at the bank and would like to compare these costs at the bank's various branches. If the branches with the most efficient operations can be identified, their methods can be studied and then replicated elsewhere. While the bank maintains meticulous records of wages and other costs, there has been no attempt thus far to show how those costs are related to the various services provided by the bank. The operations vice president has asked your help in conducting an activity-based costing study of bank operations. In particular, she would like to know the cost of opening an account, the cost of processing deposits and withdrawals, and the cost of processing other customer transactions. The Westfield branch of Security Home Bank has submitted the following cost data for last year: Teller wages Assistant branch manager salary Branch manager salary Total $ 160,000 75,000 80,000 $ 315,000 Virtually all other costs of the branch-rent, depreciation, utilities, and so on-are organization-sustaining costs that cannot be meaningfully assigned to individual customer transactions such as depositing checks. In addition to the cost data above, the employees of the Westfield branch have been interviewed concerning how their time was distributed last year across the activities included in the activity-based costing study. The results of those interviews appear below: Distribution of Resource Consumption Across Activities Processing Processing Opening Deposits and Other Customer Accounts Withdrawals Transactions Teller wages 65% 20% Assistant branch manager salary 15% 30% Branch manager salary 10% 5% Other Activities 10% 50% 85% Totals 100% 100% 100% 56 Required: Prepare the first-stage allocation for the activity-based costing study. Distribution of Resource Consumption Across Activities Processing Processing Deposits Other Opening and Customer Other Accounts Withdrawals Transactions Activities Totals Teller wages Assistant branch manager salary Branch manager salary Total cost $ 0 $ 0 $ 0 $ 0 $ 0 The operations vice president of Security Home Bank has been interested in investigating the efficiency of the bank's operations. She has been particularly concerned about the costs of handling routine transactions at the bank and would like to compare these costs at the bank's various branches. If the branches with the most efficient operations can be identified, their methods can be studied and then replicated elsewhere. While the bank maintains meticulous records of wages and other costs, there has been no attempt thus far to show how those costs are related to the various services provided by the bank. The operations vice president has asked your help in conducting an activity-based costing study of bank operations. In particular, she would like to know the cost of opening an account, the cost of processing deposits and withdrawals, and the cost of processing other customer transactions. The Westfield branch of Security Home Bank has submitted the following cost data for last year: Teller wages Assistant branch manager salary Branch manager salary Total $ 160,000 75,000 80,000 $ 315,000 Virtually all other costs of the branch-rent, depreciation, utilities, and so on-are organization-sustaining costs that cannot be meaningfully assigned to individual customer transactions such as depositing checks. In addition to the cost data above, the employees of the Westfield branch have been interviewed concerning how their time was distributed last year across the activities included in the activity-based costing study. The results of those interviews appear below: Distribution of Resource Consumption Across Activities Processing Processing Opening Deposits and Other Customer Accounts Withdrawals Transactions Teller wages 65% 20% Assistant branch manager salary 30% Branch manager salary 0% 10% Other Activities 10% 50% 857 Totals 100% 100% 100% 5 % The manager of the Westfield branch of Security Home Bank has provided the following data concerning the transactions of the The manager of the Westfield branch of Security Home Bank has provided the following data concerning the transactions of the branch during the past year: Activity Opening accounts Processing deposits and withdrawals Processing other customer transactions Total Activity at the Westfield Branch 500 new accounts opened 100,000 deposits and withdrawals processed 5,000 other customer transactions processed Required: 1. Compute the activity rates for the activity-based costing system. (Round your answers to 2 decimal places.) Activity Cost Pool Opening accounts Processing deposits and withdrawals Processing other customer transactions Activity Rate per account opened per deposit or withdrawal per other customer transaction Durban Metal Products, Ltd., of the Republic of South Africa makes specialty metal parts used in applications ranging from the cutting edges of bulldozer blades to replacement parts for Land Rovers. The company uses an activity-based costing system for internal decision-making purposes. The company has four activity cost pools as listed below: Activity Cost Pool Order size Customer orders Product testing Selling Activity Measure Number of direct labor-hours Number of customer orders Number of testing hours Number of sales calls Activity Rate $ 16.85 per direct labor-hour $ 320.00 per customer order $ 89.00 per testing hour $ 1,090.00 per sales call The managing director of the company would like information concerning the cost of a recently completed order for heavy-duty trailer axles. The order required 200 direct labor-hours, 4 hours of product testing, and 2 sales calls. Required: What is the total overhead cost assigned to the order for heavy-duty trailer axles? ABC Cost Activity Cost Pool Order size Customer orders Product testing Selling Total overhead cost $ Worley Company buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to hundreds of hospitals. Worley sets its prices for all hospitals by marking up its cost of goods sold to those hospitals by 5%. For example, if a hospital buys supplies from Worley that cost Worley $100 to buy from manufacturers, Worley would charge the hospital $105 to purchase these supplies. For years, Worley believed that the 5% markup covered its selling and administrative expenses and provided a reasonable profit. However, in the face of declining profits, Worley decided to implement an activity-based costing system to help improve its understanding of customer profitability. The company broke its selling and administrative expenses into five activities as shown: Activity Cost Pool (Activity Measure) Customer deliveries (Number of deliveries) Manual order processing (Number of manual orders) Electronic order processing (Number of electronic orders) Line item picking (Number of line items picked) Other organization-sustaining costs (None) Total selling and administrative expenses Total Cost Total Activity $ 500,000 5,000 deliveries 248,000 4,000 orders 200,000 12,500 orders 450,000 450,000 line items 602,000 $2,000,000 Worley gathered the data below for two of the many hospitals that it serves-University and Memorial (each hospital purchased medical supplies that had cost Worley $30,000 to buy from manufacturers): Activity University Memorial 10 25 Activity Measure Number of deliveries Number of manual orders Number of electronic orders Number of line items picked 30 15 120 250 Required: 1. Compute the total revenue that Worley would receive from University and Memorial. 2. Compute the activity rate for each activity cost pool. 3. Compute the total activity costs that would be assigned to University and Memorial. 4. Compute Worley's customer margin for University and Memorial. (Hint: Do not overlook the $30,000 cost of goods sold that Worley incurred serving each hospital.) Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Compute the total revenue that Worley would receive from University and Memorial. Total Revenue University Memorial Required 1 Required 2 > Activity Rate Activity Cost Pool Customer deliveries Manual order processing Electronic order processing Line item picking per delivery per manual order per electronic order per line item picked Total Activity Costs University Memorial Customer Margin University Memorial Foam Products, Inc., makes foam seat cushions for the automotive and aerospace industries. The company's activity-based costing system has four activity cost pools, which are listed below along with their activity measures and activity rates: Activity Cost Pool Supporting direct labor Batch processing Order processing Customer service Activity Measure Number of direct labor-hours Number of batches Number of orders Number of customers Activity Rate $ 5.55 per direct labor-hour $ 107.00 per batch $ 275.00 per order $2,463.00 per customer The company just completed a single order from Interstate Trucking for 1,000 custom seat cushions. The order was produced in two batches. Each seat cushion required 0.25 direct labor-hours. The selling price was $20 per unit, the direct materials cost was $8.50 per unit, and the direct labor cost was $6.00 per unit. This was Interstate Trucking's only order during the year. Required: Calculate the customer margin on sales to Interstate Trucking for the year. (Round your answers to 2 decimal places.) Required: Calculate the customer margin on sales to Interstate Trucking for the year. (Round your answers to 2 decimal places.) Interstate Trucking Customer Margin-ABC Analysis Costs: 0.00 0.00 Customer margin Fogerty Company makes two products-titanium Hubs and Sprockets. Data regarding the two products follow: Direct Labor- Hours per Annual Unit Production 0.80 10,000 units 0.40 40,000 units Hubs Sprockets Additional information about the company follows: a. Hubs require $32 in direct materials per unit, and Sprockets require $18. b. The direct labor wage rate is $15 per hour. c. Hubs require special equipment and are more complex to manufacture than Sprockets. d. The ABC system has the following activity cost pools: Activity Activity Cost Pool (Activity Measure) Machine setups (number of setups ) Special processing (machine-hours) General factory (organization-sustaining) Estimated Overhead Cost $ 72,000 $200,000 $816,000 Hubs Sprockets Total 100 300 400 5,000 0 5,000 NA NA NA Required: 1. Compute the activity rate for each activity cost pool. 2. Determine the unit product cost of each product according to the ABC system. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Determine the unit product cost of each product according to the ABC system. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Hubs Sprockets Direct materials Direct labor Overhead Unit cost $ 0.00 $ 0.00 Activity Cost Pool Activity Rate per Machine setups Special processing setup per MH