Support with qs in new excel sheet

File Edit View Insert Format Tools Data Window Help 8 8 13% Fri 9:22 AM Q O E AutoSave OFF 3hw3 ajuda - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Share Comments Calibri (Body) V 11 A" A " E 2 Wrap Text v General Insert v Ex Delete v ZY AP- O. Paste BIUV V VA v E Merge & Center v $ ~ % 9 Conditional Format Cell Format X v Sort & Find & Ideas Sensitivity Formatting as Table Styles Filter Select B22 4 X V fx A B C D E F 4-43 Two-Stage Activity-Based Costing, Banking, Benchmarking IN (This exercise is a continuation of Exercise 4-42 and should be assigned only if Exercise 4-42 is also assigned.) A part of the activity analysis conducted at the Maple Lake branch of Buffalo State Savings Bank (BSSB) was identifying potential cost drivers for each major activity. The following cost drivers were chosen because they were both plausible and reliable and data were available: Activity Cost Driver Annual Flow of Cost Driver 1 0O Process new accounts Number of new accounts Process deposits and withdrawals Number of deposits and 166,000 withdrawals 10 Process other transactions Number of other transactions 46,000 11 Of the 3,100 customers of the branch, only 400 are local businesses. The business-customer class 12 generated 20 new accounts, 89,000 deposits and withdrawals, and 22,000 other transactions. The 13 implementation of ABC at all branches of BSSB provided sufficient data for internal benchmarking. 14 The following are the lowest activity costs among all branches implementing two-stage ABC systems: 15 Activity Lowest Activity Cost per Driver Unit 16 Open new accounts $204.73 per new account 17 Process deposits and withdrawals $ 2.25 per deposit or withdrawal 18 Process other transactions $ 3.83 per transaction 19 20 Customer Class owest Customer Cost per Account 21 Retail $126.85 $593.83 22 Commercial 23 1. Determine the allocated (indirect) cost per account for retail and commercial accounts. Use 24 Exhibit 4-18 as a guide. 2. Under what conditions would benchmarking between the Maple Lake branch of BSSB and the 25 other branches be inappropriate? 26 3. What do the results of the ABC study suggest? 27 28 29 30 4-42 4-43 + + 125% A EX WCost Description Cost Teller Wages (14) $370,000 Retail Sales Manager Salaries & Benefits (3) $220,000 Managing Office Salary & Benefits (1) $120,000 Other Bank Costs $400,000 Total $1,110,000 Total Customers 3,100 4-42 Two-Stage Activity-Based Costing-Stage One The Maple Lake branch of Buffalo State Savings Bank (BSSB) is a retail branch in a rapidly grow- ing residential area. It services individuals and local businesses. To support its services, the branch employs 14 tellers, 3 retail sales managers (RSMs), and the branch managing officer. The branch services about 3,100 customers. Each of the 70 branches of BSSB is implementing ABC in order to improve profitability. BSSB's branch managing officers have been given the responsibility to imple- ment activity-based costing. The managing officer at the Maple Lake branch decided to implement a two-stage ABC system. Exhibit 4-18 depicts its two-stage ABC system. The Maple Lake branch has the following cost data for the last year: Teller wages $ 370,000 RSM salaries and benefits 220,000 Managing officer salary and benefits 120,000 Other bank costs 400.000 Total $1,1 10,000 Two-Stage ABC RETAIL OTHER TELLERS SALES MANAGING RESOURCES MANAGERS OFFICER (UNALLOCATED $370,000 $220,000 $120,000 $400,000 T R M O R R M R M 20% 15% 55% 15% 10% 15% 30% 35% OPEN NEW PROCESS PROCESS ACCOUNTS DEPOSITS AND OTHER WITHDRAWALS TRANSACTIONS