Required information (The following information applies to the questions displayed below) Miami Valley Architects Inc. provides a wide range of engineering and architectural consulting services through its three branch offices in Columbus, Cincinnati, and Dayton, Ohio. The company allocates resources and bonuses to the three branches based onthe net income of the period. The results of the firm's performance for the most recent year follows ($ In thousands); Columbus $ 1,500 Cincinnati $ 1,419 Dayton $ 1,067 Total $ 3,986 Sales Less: Direct labor Direct materials Overhead Net income 382 281 710 $. 127 317 421 589 $92 317 185 589 5 (24) 1,016 387 1.888 $ 195 Miami Valley accumulates overhead items in one overhead pool and allocates it to the branches based on direct labor dollars. For this year, the predetermined overhead rate was $1.859 for every direct labor dollar incurred by an office. The overhead pool includes rent, depreciation, and taxes, regardless of which office incurred the expense, Some branch managers complain that the overhead allocation method forces them to absorb a portion of the overhead incurred by the other offices. Management is concemed with the recent operating results. During a review of overhead expenses, management noticed that many overhead items were clearly not correlated to the movement in direct labor dollars as previously assumed. Management decided that applying overhead based on activity-based costing and direct tracing wherever possible should provide a more accurate picture of the profitability of each branch. An analysis of the overhead revealed that the following dollars for rent, utilities, depreciation, and taxes could be traced directly to the office that incurred the overhead ($ in thousands): An analysis of the overhead revealed that the following dollars for rent, utilities, depreciation, and taxes could be traced directly to the office that incurred the overhead ($ in thousands) Direct overhead Columbus $ 180 Cincinnat $ 270 Dayton $ 177 Total $627 Activity pools and their corresponding cost drivers were determined from the accounting records and staff surveys as follows: General administration Project costing Accounts payable/receiving Accounts receivable Payroll/Mail sort and delivery Personnel recruiting Employee Insurance processing Proposals Sales meetings/Sales aids Shipping Ordering Duplicating costs Blueprinting $ 499,000 48,000 139,000 47, eee 3e, eae 38,000 14,000 139,000 202,000 24.ee 48,000 45,000 22.000 $ 1,261,600 Cost Driver Direct labor cost Timesheet entries Vendor invoices client invoices Employees New hires Insurance claims filed Proposals Contracted sales Amount of Cost Driver Use ty Location Columbus Cincinnati Dayton $ 382,413 $ 317,086 $ 317,105 6,000 3,800 3,500 1,020 85e 444 96 23 26 8 4 7 230 260 180 200 250 60 1,824,439 1,399,617 571,208 588 Nav at #4 (Chapter 5) Saved Cost Driver Direct labor cost Timesheet entries Vendor invoices Client invoices Employees New hires Insurance claims filed Proposals Contracted sales Projects shipped Purchase orders Copies duplicated Blueprints Amount of Cost Driver Use by Location Columbus Cincinnati Dayton $ 382,413 $ 317,086 $ 317,188 6,000 3,800 3,500 1,020 850 400 588 444 96 23 26 18 8 4 7 230 260 200 250 1,824,439 1,399,617 571,200 99 124 30 135 110 80 162,500 146,250 65,000 39,000 31,200 16.000 100 Required: 1. What overhead costs should be assigned to each branch based on ABC concepts? 2. What is the contribution of each branch before subtracting the results obtained in requirement 1? 3. What is the profitability of each branch office using ABC? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 What overhead costs should be assigned to each branch based on ABC concepts? (Do not round Intermediate calculations. Enter your answers in thousands of dollars, rounded to two decimal places.) Activity based Overhead Allocation in thousands) Required information Required 1 Required 2 Required 3 What overhead costs should be assigned to each branch based on ABC concepts? (Do not round intermediate calculations. Enter your answers in thousands of dollars, rounded to two decimal places.) General administration Project costing Accounts payable/receiving Accounts receivable Payroll/ Mail sort and delivery Personnel recruiting Employee insurance processing Proposals Sales meetings/Sales aids Shipping Ordering Duplicating costs Blueprinting Total Activity-based Overhead Allocation in thousands) Cost Driver Columbus Cincinnati Dayton Direct labor cost $ 153 84s 127 56 $ 127 80$ Timesheet entries 21 65 13.71 12 63 Vendor Invoices 62.46 52.05 24 49 Client invoices 24,50 18 50 400 Employees 10.30 11 66 806 New hires 16.00 800 14.00 Insurance claims filed 481 5.43 3.78 Proposals 54 51 68 14 16.35 Contracted sales 97 10 74 49 30.40 Projects shipped 9.39 1176 285 Purchase orders 1994 16.251 11 82 Copios duplicated 20.00 18.00 8.00 Blueprints 34 84 27 87 14 29 $ 529.34 $ 453 40 S 278 25$ Total 40900 47 99 139.00 47.00 30.00 38.00 1400 139.00 20190 2400 48 01 48.00 77.00 1 200 99 Re 1 Required 2 > Required information - mem LUMENTY Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 What is the contribution of each branch before subtracting the results obtained in requirement 17 (Enter your answers in thousands of dollars.) Contribution of Each Branch (in thousands) Columbus Cincinnati Dayton Total Sales 1.500 s 1.419 $ 1,067 $ 3.980 Less Direct labor 382 317 317 1,016 Less Direct materials 281 421 185 887 Less Direct overhead 180 270 177 627 Contribution margin $ 657 S 411 $ 388 $ 1,456 Required information 2. What is the contribution of each branch before subtracting the results obtained in requirement 1? 3. What is the profitability of each branch office using ABC? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 What is the profitability of each branch office using ABC? (Enter your answers in thousands of dollars. Round your Intermediate calculations and "Activity based overhead" to 2 decimal places.) Profitability of Each Branch Based on Activity-based Costing (in thousands) Columbus Cincinnati Dayton Total Contribution margin $ 0 Activity-based overhead $ 0.00 $ 000 $ 0.00 $ Operating income(loss) 0.00 Required information 2. What is the contribution of each branch before subtracting the results obtained in requirement 1? 3. What is the profitability of each branch office using ABC? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 What is the profitability of each branch office using ABC? (Enter your answers in thousands of dollars. Round your Intermediate calculations and "Activity based overhead" to 2 decimal places.) Profitability of Each Branch Based on Activity-based Costing (in thousands) Columbus Cincinnati Dayton Total Contribution margin $ 0 Activity based overhead Operating income(loss) $ 0.005 0.00 $ 0.00 $ 0.00