Question
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.
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 reported for the period. Presented below are the results for the 2016 fiscal year ($ in thousands).
Columbus | Cincinnati | Dayton | Total | |
Sales | $1,500 | $1,419 | $1,067 | $3,986 |
Less: | ||||
Direct Labor | (382) | (317) | (317) | (1,016) |
Direct Materials | (281) | (421) | (185) | (887) |
Overhead | (710) | (589)) | (589) | (1,888) |
Net Income | $127 | $92 | ($24) | $195 |
Overhead items are accumulated in one overhead pool for the entire firm and then allocated to the branches based on direct labor dollars. For fiscal 2016 this predetermined rate was $1.859 for every direct labor dollar incurred by an office. The overhead pool includes rent, depreciation, taxes, etc. regardless of which office incurred the expense. Management is concerned with the results of the fiscal 2016 performance reports. During a review of the overhead, it became apparent that many items of overhead were not correlated with the direct labor dollars. Management decided to apply overhead based on direct tracing where possible and to apply Activity Based Costing (ABC) to model the profitability of each branch. Results of Overhead Analysis An analysis of the overhead revealed that facility sustaining costs for rent, utilities, depreciation, property taxes, etc. could be traced directly to the office where the costs were incurred ($ in thousands).
Columbus | Cincinnatti | Dayton | Total | |
Direct Overhead | $180 | $270 | $177 | $627 |
Activity pools and activity drivers determined from the accounting records and staff surveys are presented in the table
Activity | By | Location | |||||
Activity Pools | Activity Driver | Columbus | Cincinnati | Dayton | |||
General Admission | $409,000 | Direct Labor Dollars | $382,413 | $317,086 | $317,188 | ||
Project Costing | $48,000 | # of Timesheet Entries | 6,000 | 3,800 | 3,500 | ||
Accounts Payable/Receivable | $139,000 | # of Vendor Invoices | 1,020 | 850 | 400 | ||
Accounts Receivable | $47,000 | # of Client Invoices | 588 | 444 | 96 | ||
Payroll/Mail Sort & Delivery | $30,000 | # of Employees | 23 | 26 | 18 | ||
Personell Recruiting | $38,000 | # of New Hires | 8 | 4 | 7 | ||
Employee Insurance Processing | $14,000 | # of Claims Filed | 230 | 260 | 180 | ||
Proposals Accepted by Clients | $139,000 | # of Proposals Accepted | 200 | 250 | 60 | ||
Sales Meeting / Sales Aids | $202,000 | Contracted Sales | $1,824,439 | $1,399,617 | $571,208 | ||
Shipping | $24,000 | # of Projects | 99 | 124 | 30 | ||
Ordering | $48,000 | # of Purchase Orders | 135 | 110 | 80 | ||
Duplicating Costs | $46,000 | # of Copies Duplicated | 162,500 | 146,250 | 65,000 | ||
Blueprinting | $77,000 | # of Blueprints | 39,000 | 31,200 | 16,000 | ||
$1,261,000 |
3. (In the first analysis the net incomes attributed to the Columbus, Cincinnati, and Dayton offices were $127,000; $92,000; and, ($24,000), respectively. If profits for the offices are calculated using the ABC approach, the profits attributed to the Columbus, Cincinnati, and Dayton offices are $128,000; ($42,000); and, $109,000, respectively these computations were made to save you the need to spend time doing the arithmetic, they do not need to be verified and you should accept these numbers as correct. )
After the reviewing the revised data, Don Johnson, the head of Miami Valleys executive committee takes you out to lunch to discuss the committees new plan for closing the Cincinnati office and continuing to serve some remaining loyal Cincinnati clients from the Columbus office. Don begins the conversation by telling you how you saved the company from making a disastrous mistake. Don said that the executive committee knew something wasnt right and before your ABC project Dayton was targeted for closure within the next six months. Now, the numbers make it clear that the problem is with the Cincinnati office and this is the office that should be closed within the coming six months. Don is a person of action and he is ready to prune when and where pruning is needed. The new ABC numbers show that Cincinnati is reporting an operating loss of $42,000. Don believes that closing the Cincinnati office will avoid this loss and overall firm profit will increase by $42,000 or more. Explain why a more careful study of the impact of closing Cincinnati must be undertaken because it is unlikely that Dons expected increase in firm profit of $42,000 will actually occur if Cincinnati is closed
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started