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.