Description
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,340 | 1,900 | 2,240 | 2,500 | ||||
| Tax | 3,240 | 2,560 | 2,360 | 2,630 | ||||
| Consulting | 1,730 | 1,730 | 1,730 | 1,730 |
Average hourly billing rates are: auditing $82, tax $95, and consulting $102.
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 | |||
| $ |
Reviews
There are no reviews yet.