A company has two divisions. The divisions are Water and Waste Water. The following are the bill rates for the staff:

Vice President$250/hour

Senior Engineer$200/hour

Associate Engineer$190/hour

Staff Engineer$160/hour.

Then, we have the descriptions on what these two division did:

Water-TOTAL of 10,000hours, a) vice president at 10% of the time b): 20% of Senior Engineer time c):10% to Associate engineers d): and remaining to Staff Engineers.

Waste Water-TOTAL of 6,000hours, a): vice president at 12% of the time b): 20% of Senior Engineer time c): 5% to Associate engineers d): and remaining to Staff Engineers.

The following are more information:

A): The Direct Labor costs

Vice President$90/hour; Senior Engineer$70/hour; Associate Engineer $60/hour; Staff Engineer$50/hour.

B): The utilization. "The utilization means the billable ratio to total hours for each staff members"

Vice President60%; Senior Engineer80%; Associate Engineer85%; Staff Engineer90%.

C): Others:

Admin Salaries$81,000; Rent$120,000; Utilities$16,000; Benefits$75,000

D): Most importantly, we assume that there are 2080 hours per year that each engineer can work.

QUESTIONS:

1).Show the static budget for the company.

2): However, the actual utilization is the following:

Vice President50%; Senior Engineer82%; Associate Engineer88%; Staff Engineer93%.

Now, write out 2a). flexible budget and 2b): calculate the Level 2/3 variances.