The Comcast Construction 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 r $70/hour
Associate Engineer $60/hour
Staff Enginee $50/hour
The utilization (billable ratio to total hours) for each staff members are as follows:Vice President 65%Senior Engineer 80%Associate Engineer 85%
Staff Engineer 90%.The company has the following other costs:
Admin Salaries $181,000Software $20,000CEO Salary $150,000Rent$ 125,000Utilities $16,000Benefits $75,000Assume that there are 2080 hours per year that each engineer can work including vacation and other benefit hours.
Group 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) Calculate the breakeven revenue.
5) Make recommendations to improve profitability.
Answers: 3
Other questions on the subject: Business
Business, 22.06.2019 20:50, arturocarmena10
Which of the following is an example of a monetary policy? a. the government requires credit card companies to protect customers' privacy. b. the government restricts the amount of money that banks can lend. c. the government lowers taxes and increases spending. d. the government pays for repairing damage from a natural disaster.
Answers: 1
Business, 22.06.2019 21:10, chrisraptorofficial
This problem has been solved! see the answerthe xyz corporation is interested in possible differences in days worked by salaried employees in three departments in the financial area. a survey of 23 randomly chosen employees reveals the data shown below. because of the casual sampling methodology in this survey, the sample sizes are unequal. research question: are the mean annual attendance rates the same for employees in these three departments? days worked last year by 23 employees department days worked budgets (5 workers) 278 260 265 245 258 payables (10 workers) 205 270 220 240 255 217 266 239 240 228 pricing (8 workers) 240 258 233 256 233 242 244 249 picture click here for the excel data filefill in the missing data. (round your p-value to 4 decimal places, mean values to 1 decimal place and other answers to 2group mean n std. dev variancesbudgets payables pricing total one factor anova source ss df ms f p-value treatment error total
Answers: 2
Business, 22.06.2019 21:30, dondre54
The year-end financial statements of calloway company contained the following elements and corresponding amounts: assets = $34,000; liabilities = ? ; common stock = $6,400; revenue = $13,800; dividends = $1,450; beginning retained earnings = $4,450; ending retained earnings = $8,400. based on this information, the amount of expenses on calloway's income statement was
Answers: 1
You know the right answer?
The Comcast Construction Company Civil Engineers consists of two divisions. The divisions are Water...
Questions in other subjects:
Mathematics, 24.06.2020 19:01
History, 24.06.2020 19:01
Mathematics, 24.06.2020 19:01
Mathematics, 24.06.2020 19:01
Social Studies, 24.06.2020 19:01
English, 24.06.2020 19:01
