I need help on this problem...

! Required information Problem 5-44 Activity-Based Costing (LO 5-2,5-3] (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 on the net income of the period. The results of the firm's performance for the most recent year follows ($ in thousands): Sales Less: Direct labor Direct materials Overhead Columbus $1,500 382 281 710 $ 127 Cincinnati $1,419 317 421 589 $ 92 Dayton $1,067 317 185 589 Total $3,986 1,016 887 1,888 $ 195 Net income $ (24) 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 concerned 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 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): Columbus $ 180 Cincinnati Dayton $ 270 $ 177 Total $ 627 Direct overhead Activity pools and their corresponding cost drivers were determined from the accounting records and staff surveys as follows: 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 $ 409,000 48,000 139,000 47,000 30,000 38,000 14,000 139,000 202,000 24,000 48,000 46,000 77,000 $ 1,261,000 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 180 200 250 60 1,824,439 1,399,617 571, 208 99 124 30 135 110 80 162,500 146, 250 65,000 39,000 31,200 16,000 1 Required information 30 points 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? Answer is complete but not entirely correct. 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? (Enter your answers in thousands of dollars. Round your intermediate calculations and final answers to 2 decimal places.) Activity-Based Overhead Allocation (000s) Columbus Cincinnati Dayton Total Cost Driver 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 153,839.79 127,559.59 127,600.62 409,000.00 X Direct labor dollar 21,654.14 13,714.29 12,631.58 X 48,000.00 X Timesheet entries 62.458.15 X 52,048.46 24.493.39 X 139,000.00 X Vendor invoices 24,500.00 18,500.00 X 4,000.00 X 47,000.00 X Client invoices 10,298.51 X 11,641.79 8,059.70 X 30,000.00 X Employees 16,000.00 X 8,000.00 14,000.00 X 38,000.00 X New hires 4,805.97 X 5,432.84 X 3,761.19 X 14,000.00 x Insurance claims filed 54,509.80 X 68,137.25 16,352.94 x 139,000.00 X Proposals 97,104.36 X 74,493.54 X 30,402.11 X 202,000.00 X Contracted sales 9,391.30 x 11.762.85 X 2,845.85 X 24,000.00 % Projects shipped 19,938.46 X 16,246.15 x 11,815.38 x 48,000.00 X Purchase orders 20,000.00 X 18,000.00 8,000.00 X 46,000.00 % Copies duplicated 34,837.59 X 27.870.07 14,292.34 X 77,000.00 Blueprints 529,338.07 453,406.83 278,255.10 $ 1,261,000.00 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? Answer is complete but not entirely correct. 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 1? (Enter your answers in thousands of dollars.) Sales Less: Direct labor Columbus Cincinnati Dayton Total $ 1,500,000 X $ 1,419,000 X $ 1,067,000 X $ 3,986,000 X 382,000 X 317,000 X 317,000 x 1,016,000 X 281,000 X 421,000 X 185,000 X 887,000 X 180,000 X 270,000 x 177,000 X 627,000 x $ 657,000 $ 411,000 $ 388,000 $ 1,456,000 Less: Direct materials Less: Direct overhead Contribution margin 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? X Answer is complete but not entirely correct. 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.) Sales Less: Direct labor Less: Direct materials Less: Direct overhead Columbus Cincinnati Dayton Total $ 1,500,000 $ 1,419,000 $ 1,067,000 $ 3,986,000 X 382,000 x 317,000 X 317,000 X 1,016,000 X 281,000 X 421,000 X 185,000 X 887,000 X 180,000 x 270,000 X 177,000 X 627,000 X 657,000 $ 411,000 $ 388,000 $ 1,456,000 529,338.07 X 453,406.83 X 278,255.10 X 1,261,000.00 X $ $ 127,661.93 (42,406.83) $ 109,744.90 $ 195,000.00 Contribution margin Activity-based overhead Operating income(loss)