User Account

All Pages

Develop a staffing plan based on the expected hours

Assignment Help Accounting Basics
Reference no: EM131623805

Facts:

The W Company Civil Engineers consists of two divisions. The divisions are Water and Infrastructure. The company sells engineering services to various customers. The following are the bill rates for the various staff classifications:

Vice President

$250/hour

Senior Engineer

$200/hour

Associate Engineer

$190/hour

Staff Engineer

$160/hour

The two divisions expect to bill the following hours:

  • Water- 10,000 hours, vice president at 10% of the time, 20% of Senior Engineer time 10% to Associate engineers and remaining to Staff Engineers.
  • Waste Water- 6,000 hours, vice president at 12% of the time, 20% of Senior Engineer time, 5% to Associate engineers and remaining to Staff Engineers.

The Direct Labor costs per hours are as follows:

Vice President

$90/hour

Senior Engineer

$70/hour

Associate Engineer

$60/hour

Staff Engineer

$50/hour.

The utilization (billable ratio to total hours) for each staff members are as follows:

Vice President

60%

Senior Engineer

80%

Associate Engineer

85%

Staff Engineer

90%.

The company has the following other costs:

Admin Salaries

$81,000

Rent

$120,000

Utilities

$16,000

Benefits

$75,000

Assume that there are 2080 hours per year that each engineer can work including vacation and other benefit hours.

Assignment:

You are an outside consulting firm and the company Board and the CFO have engaged you. The goal of the Board and the CFO is to improve profitability of the divisions and company. Therefore, to accomplish that the following questions should be answered during the presentation and the write up.

(1) Develop a staffing plan based on the expected hours to be billed. This means, how many of (Full Time Equivalents) the various staff types should be there to accomplish the set goals or billable hours.

(2) Develop an Income Statement budget for the company and the two divisions. All overhead costs can be allocated using percentage of revenues.

(3) What can the company do to allocate costs differently to the divisions? Prepare a revised Income statement by division.

(4) Make recommendations to improve profitability.

Reference no: EM131623805

Questions Cloud

Brief summary of the history of islam : Explore differences between various groups within Islam and understand current practices today.Brief summary of the history of Islam.
What is the current share price of your stock : What is the current share price of your stock? Discuss the effects of leverage and its tax shields effects on the future value of the two firms.
Identify and briefly describe cost behaviour characteristics : Identify and briefly describe cost behaviour characteristics for the different cost elements of a product or service
What is the total obligation under capital leases : Financial Statement Analysis Case Wal-Mart Stores, Inc. Presented in Illustration 21-31 are the financial statement disclosures from the January 31, 2012.
Develop a staffing plan based on the expected hours : The W Company Civil Engineers consists of two divisions. Develop a staffing plan based on the expected hours to be billed
How does ual use of leases compare with southwest : Comparative Analysis Case UAL, Inc. and Southwest Airlines Instructions Go to the book's companion website or the company websites and use information found.
What amount of capital leases was reported by p-and-g : What amount of capital leases was reported by P&G in total and for less than one year?
The treatment theory you would use and why : A description of how you would address any mental health, medical, legal, and substance use issues that the client exhibits in the case study.
Calculate the exercise price of call option : Are your call options in the money, at the money, or out of money? Calculate the Exercise price of call option.

Reviews

Write a Review

Accounting Basics Questions & Answers

  What are the two special rights

Terminology varies in the way companies differentiate among share types. But many corporations designate shares as common or preferred. What are the two special rights usually given to preferred shareholders?

  Case study of mary kay cosmetics

Asian Market Entry Why has MKC not been as successful as Avon in penetrating world markets? How does MKC's internationalization process compare with that of Avon or other cosmetics marketers who have expanded abroad?

  The standard cost sheet calls for 80 pounds of zinc per

the standard cost sheet calls for 80 pounds of zinc per batch of 70 faucets. zinc has a standard price of 5.10 per

  Determine the coupon rate

Page Enterprises has bonds on the market making annual payments, with eight years to maturity, and selling for $988. At this price, the bonds yield 7.90 percent.

  The shares are held in the treasury

The shares are held in the treasury, what effect does this transaction have on (a) net income, (b) total assets, (c) total paid-in capital, and (d) total stockholders' equity?

  Annual gift tax exclusion

The annual policy premium of $12,000 had been paid on January 1. Damitria's gift (before the annual gift tax exclusion) to Tremayne is:

  Purchases on landscaping supplies direct materials are paid

environmental landscaping inc. is preparing its budget for the first quarter of 2012. the next step in the budgeting

  Determine the external and internal factors that influence

determine the external and internal factors that influence credit policy and decision making within a company that

  A company had inventory on november 1 of 5 units at a cost

a company had inventory on november 1 of 5 units at a cost of 20 each. on november 2 they purchased 10 units at 22

  Container shipping wants to begin to use process costing in

container shipping inc. is contemplating the use of process costing to track the cost of its operations. the operation

  The current year and expects to earn

Pinecone Company has plan assets of $500,000 at the beginning of the current year and expects to earn 12% on its plan assets during the year.

  Complete termination redemption

Lupe and Rodrigo, father and son, each own 50% of the stock outstanding of Heron Corporation (Eof $400,000). During the current year, Heron redeems all of Lupe's shares for $250,000. The transaction cannot qualify as a complete termination redempt..

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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