Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

[The following information applies to the questions displayed below.] Miami Valley Architects Inc. provides a wide range of engineering and architectural consulting services through

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

[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 Net income Columbus $1,500 Cincinnati $1,419 Dayton $1,067 Total $ 3,986 382 317 317 1,016 2811 421 185 887 710 $127 589 589 1,888 $ 92 $ (24) $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 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 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): Direct overhead Columbus $ 180 Cincinnati $270 Dayton $177 Total 5627 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 $ 382,413 $317,086 Dayton $317,188 6,000 1,020 3,800 3,500 850 400 588 444 96 23 26 18 8 4 7 230 260 1801 200 250 60 1,824,439 1,399,617 571,208 99 135 124 30 110 80 162,500 39,000 146,250 31,200 65,000 16,000 Required information Required 1 Required 21 Required 3 What overhead costs should be assigned to each branch based on ABC concepts? (Do not round intermediate calculations. Enter your answer thousands of dollars, rounded to two decimal places.) Activity-based Overhead Allocation (in thousands) General administration Project costing Accounts payable/receiving Accounts receivable Payroll/Mail sort and delivery Personnel recruiting Employee insurance processing Proposals Direct labor cost Timesheet entries Vendor Invoices Client invoices Employees New hires Insurance claims filed Cost Driver Columbus Cincinnati Dayton Total $ 000 0.00 0.00 0.00 0.00 T 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $ 0.00 $ 0.00 $ 0.00 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.) Contribution of Each Branch (in thousands) Columbus Cincinnati Dayton Total Sales $ 1,500 $ 1,419 $ 1,067 $ 3,986 Less Direct labor 281 421 185 887 Less Direct materials Less Direct overhead 382 317 317 1,016 180 270 277 727 Contribution margin $ 657 S 411 S 288 $ 1,356 < Required 1 Required 3 > 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 you 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 $ 0 Contribution margin Activity-based overhead Operating income(loss) $ 0.00 $ 0.00 $ 0.00 $ 0.00 < Required 2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: J. David Spiceland, James Sepe, Mark Nelson

6th edition

978-0077328894, 71313974, 9780077395810, 77328892, 9780071313971, 77395816, 978-0077400163

Students also viewed these Accounting questions

Question

Explain the characteristics of a good system of control

Answered: 1 week ago

Question

State the importance of control

Answered: 1 week ago

Question

What are the functions of top management?

Answered: 1 week ago

Question

Bring out the limitations of planning.

Answered: 1 week ago

Question

Find the radius of convergence of? 1.2.3 1.3.5 (2n-1) r2n+1 -1

Answered: 1 week ago