Garza and Neely, 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,360
|
|
1,960
|
|
2,370
|
|
2,730
|
|
Tax
|
|
3,200
|
|
2,740
|
|
2,240
|
|
2,690
|
|
Consulting
|
|
1,680
|
|
1,680
|
|
1,680
|
|
1,680
|
Average hourly billing rates are: auditing $81, tax $94, and consulting $105.
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.