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 (S In thousands): Sales Less: Direct labor Direct materials Overhead Net income Direct overhead Show Transcribed Text General administration Project costing Columbus $ 1,500 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. 382 281 710 $ 127 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. Columbus $ 180 Accounts payable/receiving Accounts receivable Payroll/Mail sort and delivery Personnel recruiting Employee insurance processing Proposals 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): Sales meetings/Sales aids Shipping Ordering Duplicating costs Blueprinting Cost Driver Direct labor cost Timesheet entries Vendor invoices Client invoices Employees New hires Cincinnati $ 1,419 Insurance claims filed Proposals Contracted sales Projects shipped Purchase orders Copies duplicated Blueprints 317 421 589 $ 92 Cincinnati $ 270 Activity pools and their corresponding cost drivers were determined from the accounting records and staff surveys as follows: 162,500 Dayton $ 1,067 39,000 317 185 589 $ (24) Dayton $ 177 $ 409,000 48,000 139,000 47,000 30,000 38,000 14,000 139,000 202,000 24,000 48,000 Total $ 3,986 46,000 77,000 $ 1,261,000 1,016 887 1,888 $ 195 Total $ 627 3 Columbus $ 382,413 Amount of Cost Driver Use by Location Cincinnati $ 317,086 6,000 3,800 1,020 850 588 444 23 26 8 4 11 230 260 200 250 1,824,439 1,399,617 99 124 135 110 146,250 31,200 Dayton $ 317,188 3,500 400 96 18 7 180 68 571,208 30 80 65,000 16,000 C

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Please do not give solution in image format ? And Fast Answering Please ? And Explain Proper Step by Step.

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
Direct overhead
Show Transcribed Text
General administration
Project costing
Accounts payable/receiving
Accounts receivable
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.
Payroll/Mail sort and delivery
Personnel recruiting
Employee insurance processing
Proposals
Sales meetings/Sales aids
Shipping
Ordering
Columbus
$ 1,500
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):
Duplicating costs
Blueprinting
Cost Driver
Direct labor cost
Timesheet entries.
382
281
710
$ 127
Columbus
$ 180
Vendor invoices
Client invoices
Employees
New hires.
Insurance claims filed
Proposals
Contracted sales
Cincinnati
$ 1,419
Projects shipped
Purchase orders
Copies duplicated
Blueprints
Activity pools and their corresponding cost drivers were determined from the accounting records and staff surveys as
follows:
Cincinnati
$ 270
317
421
589
$92
Columbus
$382,413
6,000
1,020
588
23
8
230
200
Dayton
$ 1,067
1,824,439
317
185
589
$ (24)
99
135
162,500
39,000
$ 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
Dayton
$ 177
Amount of Cost Driver Use by Location
Cincinnati
Total
$ 3,986
1,016
887
1,888
$195
$ 317,086
3,800
850
444
26
260
258
Total
$ 627
1,399,617
124
110
146,250
31,200
Dayton
$317,188
3,500
400
96
18
7
180
60
571,208
30
80
65,000
16,000
Transcribed Image Text: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 Direct overhead Show Transcribed Text General administration Project costing Accounts payable/receiving Accounts receivable 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. Payroll/Mail sort and delivery Personnel recruiting Employee insurance processing Proposals Sales meetings/Sales aids Shipping Ordering Columbus $ 1,500 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): Duplicating costs Blueprinting Cost Driver Direct labor cost Timesheet entries. 382 281 710 $ 127 Columbus $ 180 Vendor invoices Client invoices Employees New hires. Insurance claims filed Proposals Contracted sales Cincinnati $ 1,419 Projects shipped Purchase orders Copies duplicated Blueprints Activity pools and their corresponding cost drivers were determined from the accounting records and staff surveys as follows: Cincinnati $ 270 317 421 589 $92 Columbus $382,413 6,000 1,020 588 23 8 230 200 Dayton $ 1,067 1,824,439 317 185 589 $ (24) 99 135 162,500 39,000 $ 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 Dayton $ 177 Amount of Cost Driver Use by Location Cincinnati Total $ 3,986 1,016 887 1,888 $195 $ 317,086 3,800 850 444 26 260 258 Total $ 627 1,399,617 124 110 146,250 31,200 Dayton $317,188 3,500 400 96 18 7 180 60 571,208 30 80 65,000 16,000
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.)
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
Show Transcribed Text
Required 1 Required 2
Sales
Less: Direct labor
Less: Direct materials
Less: Direct overhead
Contribution margin
Direct labor cost
Timesheet entries
Show Transcribed Text
Contribution margin
Activity-based overhead
Operating income(loss)
Activity-based Overhead Allocation
(in thousands)
Vendor Invoices
Client invoices
Required 3
Cost Driver
Employees
New hires
Insurance claims filed
Proposals
Contracted sales
Projects shipped
Purchase orders
Copies duplicated
Blueprints
Columbus
Contribution of Each Branch
(in thousands)
What is the contribution of each branch before subtracting the results obtained in requirement 1? (Enter your answers in
thousands of dollars.)
Required 3
Cincinnati
< Required 1
Dayton
Columbus Cincinnati
Profitability of Each Branch Based on Activity-based Costing
(in thousands)
Columbus
Dayton
Cincinnati
< Required 2
Total
Required 3 >
Required 1 Required 2
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.)
Ű
g
Required 3 >
Ć
Dayton
Total
Total
Transcribed Image Text: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.) 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 Show Transcribed Text Required 1 Required 2 Sales Less: Direct labor Less: Direct materials Less: Direct overhead Contribution margin Direct labor cost Timesheet entries Show Transcribed Text Contribution margin Activity-based overhead Operating income(loss) Activity-based Overhead Allocation (in thousands) Vendor Invoices Client invoices Required 3 Cost Driver Employees New hires Insurance claims filed Proposals Contracted sales Projects shipped Purchase orders Copies duplicated Blueprints Columbus Contribution of Each Branch (in thousands) What is the contribution of each branch before subtracting the results obtained in requirement 1? (Enter your answers in thousands of dollars.) Required 3 Cincinnati < Required 1 Dayton Columbus Cincinnati Profitability of Each Branch Based on Activity-based Costing (in thousands) Columbus Dayton Cincinnati < Required 2 Total Required 3 > Required 1 Required 2 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.) Ű g Required 3 > Ć Dayton Total Total
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 2 images

Blurred answer
Knowledge Booster
Cost allocation
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education