Garza and Neely, CPAs, are preparing their

E20-3 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,400               1,860               2,310               2,680

Tax                  3,360               2,800               2,240               2,820

Consulting       1,730               1,730               1,730               1,730

Average hourly billing rates are: auditing $83, tax $93, and consulting $105.

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