Ernst and Anderson, CPAs, are preparing their service revenue (sales) budget for the coming year (2012). The practice is divided into three departments: auditing, tax, and consulting. Billable hours for each department, by quarter, are provided below.
|
Department |
Quarter 1 |
Quarter 2 |
Quarter 3 |
Quarter 4 |
|
Auditing |
2,200 |
1,600 |
2,000 |
2,400 |
|
Tax |
3,000 |
2,400 |
2,000 |
2,500 |
|
Consulting |
1,500 |
1,500 |
1,500 |
1,500 |
Average hourly billing rates are: auditing $80, tax $90, and consulting $100.
Instructions
Prepare the service revenue (sales) budget for 2012 by listing the departments and showing for each quarter and the year in total, billable hours, billable rate, and total revenue.