Develop an income statement budget for the company

Reference no: EM131807309

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 $215/hour

Senior Engineer $200/hour

Associate Engineer $170/hour

Staff Engineer $160/hour.

The two divisions expect to bill the following hours:

Water- 12000 hours, vice president at 10% of the time, 30% of Associate/Senior Engineer (15% each) time and remaining to Staff Engineers.

Infrastructure- 5000 hours, vice president at 20% of the time, 20% of Associate/Senior Engineer (10% each) time and remaining to Staff Engineers.

The Direct Labor costs per hours are as follows: Vice President $80/hour

Senior Engineer $60/hour

Associate Engineer $50/hour

Staff Engineer $40/hour.

The utilization for each staff members are as follows: Vice President 65%

Senior Engineer 85%

Associate Engineer 90%

Staff Engineer 92%.

The company has the following other costs: AdminSalaries $100,000

Rent Utilities Benefits

$110,000 $9,000 $99,000

Note: Assume that all employees are on salary and they are employed for 2080 total hours per year.

Project:

You are an outside consulting firm and the company Board and the CFO have engaged you. The ultimate goal of the Board and the CFO is to improve profitability. To accomplish that the following questions should be answered in the write up. The report should be something that would be given to a Board of Directors and a CFO.

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

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

(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: EM131807309

Questions Cloud

Calculate the cost per equivalent unit for transferred : Calculate the cost per equivalent unit for transferred in costs only

Testing the transportation analyst belief : Fresh numbers from the U.S. Department of Transportation suggest that fewer flights in the U.S. arrive on time than before.

Particular section of highway pavement : Annual maintenance costs for a particular section of highway pavement are $2000. The placement of a new surface would reduce the annual maintenance cost

How will the application of the chosen concept impact : How will the application of the chosen concept impact the structure of the health care institution when allocating resources?

Develop an income statement budget for the company : Develop an Income Statement budget for the company and the two divisions. All overhead costs can be allocated using percentage of revenues for each division.

Scores on the writing component of the test : The SAT is required of most students applying for college admission in the United States. This standardized test has gone through many revisions over the years.

Determine the amount of joint cost allocated to each product : Determine the amount of joint cost allocated to each product if the physical-measure method is used

Using the hours required to accomplish tasks chart : Using the Hours Required to Accomplish Tasks chart, determine the optimal schedule for assigning each of the six nurses to the six patients in the ward.

Prepare statement of cash flows for the year ended december : Cash dividends of $15,000 were paid. Prepare a statement of cash flows for the year ended December 31, 2011, using the indirect method

User Account

All Pages