Developing and making a proposal

Assignment Help Cost Accounting
Reference no: EM131462116

Part: Miami Valley Architects Inc.

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,956

Less:

 

 

 

 

Direct labor

(362)

(317)

(317)

(1,016)

Direct materials

(281)

(421)

(185)

( 887)

Overhead

(710)

(580)

(580)

(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        Cincinnati        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 on the next page'.

 

 

 

# Activities by Location

Activity Pools

 

Activity Driver

Columbus

Cincinnati

Dayton

General Administration

$409,000

Direct Labor Dollars

$3821413

$317,086

$3171188

Project Costing

$48,000

# of Timesheet Entries

6,000

3,800

3,500

Accounts Payable/Receiving

$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

Personnel 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

5571,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

 

 

 

 

PLEASE provide consice straigtforward answers. Show all work (math in excel need formulas shown) Questions 1-4

REQUIRED:

1. Assume each job Miami Valley Architects completes required a proposal. Furthermore, assume proposals can involve talent from any of the three offices and from central administration who can make proposals to clients located anywhere the firm does work. Using ABC and the data provided above as presented in this case, Mat amount will be charged to a job completed by Miami Valley Architects for the cost of developing and making a proposal?

2. Activity based costing is one approach to the difficult problem of cost allocation. However, the results may still be arbitrary and too imprecise for some applications. Consider the case of a large, national architectural firm with offices located throughout the country. Assume this firm needs to establish a transfer price to charge different profit centers across the country for their use of a centralized Personnel Recruiting service located within a centralized Human Resources group Using the example of Personnel Recruiting in this problem: discuss reasons why activity based costing as it is implemented in this model by Miami Valley Architects for Personnel Recruiting lacks the precision needed for the large, national architectural firm seeking to establish a transfer price.

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 S: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.

4. After the reviewing the revised data, Don Johnson, the head of Miami Valley's executive committee takes you out to lunch to discuss the committee's 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 wasn't 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 Don's expected increase in firm profit of $42,000 will actually occur if Cincinnati is closed.

Verified Expert

The task is based on the ABC Principle of costing. It consists of a case study where the overhead cost of each unit has been computed. The questions have been answered on the basis of the computations.

Reference no: EM131462116

Questions Cloud

What is the monosaccharide that results at the end : Make sure you explain how this test work in this way along with identifying what is the monosaccharide that results at the end.
What are your most valuable skills : In the past, company loyalty and ability to assume increasing job responsibility usually ensured advancement within an organization.
Consider possible root causes of the ofi : Describe the problem or OFI that you have selected for your MAP. Why is it important to resolve this problem right now?
How texting is effecting business communications : How Texting is effecting Business Communication- the pro's and con's, the ways to do it effectively, how the future is shaping up for texting in business world.
Developing and making a proposal : Explain why a more careful study of the impact of closing Cincinnati must be undertaken because it is unlikely that Don's expected increase in firm profit
Determining the sequence of changes : How many joules of energy were released by the water during this sequence of changes.? The specific heat of ice is 2.06 j/gK and the molar heat of fusion.
Plot the water depth against distance : ENV3104 Hydraulics II 2017 Assignment. Plot the water depth against distance. Modify the model to accommodate the design storm hyetograph
Total shareholders equity : On January 1, 2015, XYZ purchases 10 million shares of ABC for $600 million in cash. Total Shareholder’s Equity:
List all the activities involved in operations management : What is the difference between an analytical and a synthetic manufacturing process? Give an example of each type of process.

Reviews

inf1462116

5/5/2017 6:12:23 AM

I am a repeat customer this is a straightforward problem. so please offer a reasonable amount. Send please confirm quality assignment solution Sir attached questions for experts need to know where highlighted numbers come from on excel sheet. Please send back updated excel. 22769936_1Question IN YELLOW for expert.xlsx thank you quality expert and solution provided!

len1462116

4/14/2017 1:57:18 AM

Need accounting expert. 4 question on attachment please show work. Question need concise answers.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).

Write a Review

Cost Accounting Questions & Answers

  Cost accounting assignment

Evaluate Method of measuring costs associated with production, budgeting process, normal job-order costing system , master budget, cycle time.

  Prepare the journal entries

Prepare the journal entries to record the bond issue and interest expense.

  Advise as to the liability of all the parties

Write a report on given case study and Advise as to the liability of ALL the parties both under common law and the Corporations Law.

  Prepare revenues budget

Prepare Revenues budget and Production budget in units

  Effect of exchange rate changes on cash and cash

Effect of exchange rate changes on cash and cash

  Corporate governance

You are to reflect on how this case of China Sky relates to what the arguments for and against allowing audit firm partners and/or employees to join audit committees.

  Cost-benefit analysis

A cost-benefit analysis of electronic medical records in primary care

  Non-annual interest rates and annuities

Theory of Interest- Non-annual interest rates and annuities

  Job costing in service organizations

How is job costing in service organizations different from job costing in manufacturing environments?

  Accounting for bad debt expense

Accounting for bad debt expense

  Accounting and partnership problems

Accounting and Partnership problems

  Development of relevant cash flows

Development of relevant cash flows - Cost estimating and financial analysis

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd