Question

The Comcast Construction CompanyCivil 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,000hours, vice president at 10% of the time, 20% of Senior Engineer time10% to Associate engineers, and remaining to Staff Engineers.

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

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 President60%

Senior Engineer80%

Associate Engineer85%

Staff Engineer90%.

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.

Question (1). Prepare a static budget for the company.

Answer 1

	Static Budget
	Division	Water	Infrastructure
	Hours	10000	6000
		%	Total Hours	Utilisation Ratio(%)-Billable Ratio	Hours	Rate	Sales	%	Total Hours	Utilisation Ratio(%)-Billable Ratio	Hours	Rate	Sales	Total Sales
	Sales
	Vice President	10	1000	60	600	250	1,50,000	12	720	60	432	250	1,08,000
	Senior Engineer	20	2000	80	1600	200	3,20,000	20	1200	80	960	200	1,92,000
	Associate Engineer	10	1000	85	850	190	1,61,500	5	300	85	255	190	48,450
	Staff Engineer	60	2080	90	1872	160	2,99,520	63	2080	90	1872	160	2,99,520
	Total						9,31,020						6,47,970	15,78,990
Less	Direct Labour Cost
		%	Total Hours	Utilisation	Hours	Labour Cost Per Hour	Cost	%	Total Hours	Utilisation Ratio(%)-Billable Ratio	Hours	Labour Cost Per Hour	Sales	Total Cost
	Vice President	10	1000	60	600	90	54,000	12	720	60	432	90	38,880
	Senior Engineer	20	2000	80	1600	70	1,12,000	20	1200	80	960	70	67,200
	Associate Engineer	10	1000	85	850	60	51,000	5	300	85	255	60	15,300
	Staff Engineer	60	2080	90	1872	50	93,600	63	2080	90	1872	50	93,600
	Total						3,10,600						2,14,980	5,25,580
Less	Over Head
	Admin Salaries													81,000
	Rent													1,20,000
	Utilities													16,000
	Benefits													75,000
	Total													2,92,000
	Net Income				ekkarill92 Next > < Previous Related Solutions The WIX Company Civil Engineers consists of two divisions. The divisions are Water (WA) and Infrastructure (IF). The WIX Company Civil Engineers consists of two divisions. The divisions are Water (WA) and Infrastructure (IF). The company sells engineering services to various customers. The following are the bill rates for the various staff classifications: Vice President $280/hour Senior Engineer $220/hour Associate Engineer $200/hour Staff Engineer $160/hour The two divisions expect to bill the following hours: • Water- 12,000 hours, vice president at 15% of the time, 20% of Senior Engineer time 10% to Associate engineers and remaining to... The WIX Company Civil Engineers consists of two divisions. The divisions are Water (WA) and Infrastructure (IF).   The WIX Company Civil Engineers consists of two divisions. The divisions are Water (WA) and Infrastructure (IF). The company sells engineering services to various customers.The following are the bill rates for the various staff classifications:Vice President $280/hourSenior Engineer $220/hourAssociate Engineer $200/hourStaff Engineer $160/hourThe two divisions expect to bill the following hours:• Water- 12,000 hours, vice president at 15% of the time, 20% of Senior Engineer time 10% to Associate engineers and remaining to Staff Engineers.• Infrastructure- 4,000 hours, vice... The WIX Company Civil Engineers consists of two divisions. The divisions are Water and Waste Water.   The WIX Company Civil Engineers consists of two divisions. The divisions are Water and Waste Water. The company sells engineering services to various customers. The following are the bill rates for the various staff classifications: Vice President $200/hour Senior Engineer $180/hour Staff Engineer $150/hour. The two divisions expect to bill the following hours: Water- 10000 hours, vice president at 10% of the time, 30% of Senior Engineer time and remaining to Staff Engineers. Waste Water- 6000 hours, vice president... The WIX Company Civil Engineers consists of two divisions. The divisions are Water (WA) and Infrastructure (IF). The company sells engineering services to various customers.   The WIX Company Civil Engineers consists of two divisions. The divisions are Water (WA) and Infrastructure (IF). The company sells engineering services to various customers.The following are the bill rates for the various staff classifications:Vice President $280/hourSenior Engineer $220/hourAssociate Engineer $200/hourStaff Engineer $160/hourThe two divisions expect to bill the following hours:• Water- 12,000 hours, vice president at 15% of the time, 20% of Senior Engineer time 10% to Associate engineers and remaining to Staff Engineers.• Infrastructure- 4,000 hours, vice... Business Case – Manchester Business School (Civil Engineering) The Company (Civil Engineers) consists of two divisions.... Business Case – Manchester Business School (Civil Engineering) The Company (Civil Engineers) consists of two divisions. The divisions are Transportation 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: Transportation - 10,000 hours, vice president at 10% of the time, 20% of Senior Engineer time 10% to... Ludmilla Construction Company is composed of two divisions: (1) Home Construction and (2) Commercial Construction. The... Ludmilla Construction Company is composed of two divisions: (1) Home Construction and (2) Commercial Construction. The Home Construction Division is in the process of building 12 houses and the Commercial Construction Division is working on three projects. Required Identify each cost as being a direct or indirect cost assuming the cost objects are the individual products (houses or projects). Identify each cost as being a direct or indirect cost, assuming the cost objects are the two divisions. Identify each cost... For energy engineers; Review the mechanical design features materials, construction and so on of two types... For energy engineers; Review the mechanical design features materials, construction and so on of two types of energy storage system. please talk about it deeply like an article. much explanation needed. 1: WV Construction has two divisions: Remodeling and New Home Construction. Each division has an on-site... 1: WV Construction has two divisions: Remodeling and New Home Construction. Each division has an on-site supervisor who is paid a salary of $78,000 annually and one salaried estimator who is paid $44,000 annually. The corporate office has two office administrative assistants who are paid salaries of $48,000 and $36,000 annually. The president's salary is $150,000. How much of these salaries are common fixed expenses? Multiple Choice $84,000 $234,000 $150,000 $298,000 __________________________ 2: Corporation X sold 25,000 units of product... Described two of A geopolitical place consists of community boundaries, transportation infrastructure, geographic features, climate, vegetation,... Described two of A geopolitical place consists of community boundaries, transportation infrastructure, geographic features, climate, vegetation, animals, and human-made homes and facilities? Markey Corporation consists of two divisions, North and South. The North makes Glop, a product that... Markey Corporation consists of two divisions, North and South. The North makes Glop, a product that can be used in the production of the product that the South division makes and sells. Both divisions are considered profit centers. The following data are available concerning Glop and the two divisions: North South Average units produced 150,000 Average units sold 150,000 Variable manufacturing cost per unit $2 Variable finishing cost per unit $5 Fixed divisional costs $75,000 $125,000 The North Division can... ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions Translate the following Code into MIPS (.asm) Arrays and Reentrant Subprograms CallingSubroutinesDemo.asm Implement the following pseudo... What impact has the internet and social media had on bullying? Has the online world made... A consensus forecast is the average of a large number of individual analysts' forecasts. Suppose the... Prelab 7: DC Circuits 1 What are the units of Resistance? Watch the video tutorial about... Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment... The Kretovich Company had a quick ratio of 1.2, a current ratio of 3.0, a days... Assume you are considering a portfolio containing two​ assets, L and M. Asset L will represent... ADVERTISEMENT About @ 2020 WizEdu