| Exercise 20 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,580 | 1,710 | 2,210 | 2,580 | ||||
| Tax | 3,250 | 2,650 | 2,290 | 2,840 | ||||
| Consulting | 1,630 | 1,630 | 1,630 | 1,630 |
Average hourly billing rates are: auditing $83, tax $92, and consulting $104.
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.
| GARZA AND NEELY, CPAs Sales Revenue Budget For the Year Ending December 31, 2012 |
||||||
| Quarter 1 | Quarter 2 | |||||
| Dept. | Billable Hours | Billable Rate | Total Rev. | Billable Hours | Billable Rate | Total Rev. |
| Auditing | |
$ |
$ |
|
$ |
$ |
| Tax | |
|
|
|
|
|
| Consulting | |
|
|
|
|
|
| $ |
$ |
|||||
| GARZA AND NEELY, CPAs Sales Revenue Budget For the Year Ending December 31, 2012 |
||||||
| Quarter 3 | Quarter 4 | |||||
| Dept. | Billable Hours | Billable Rate | Total Rev. | Billable Hours | Billable Rate | Total Rev. |
| Auditing | |
$ |
$ |
|
$ |
$ |
| Tax | |
|
|
|
|
|
| Consulting | |
|
|
|
|
|
| $ |
$ |
|||||
| GARZA AND NEELY, CPAs Sales Revenue Budget For the Year Ending December 31, 2012 |
|||
| Year | |||
| Dept. | Billable Hours | Billable Rate | Total Rev. |
| Auditing | |
$ |
$ |
| Tax | |
|
|
| Consulting | |
|
|
| $ |
|||