Exercise 21-3 | Accounting homework help

Thome and Crede, CPAs, are preparing their service revenue (sales) budget for the coming year (2017). 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,970		2,390		2,640
Tax		3,360		2,660		2,400		2,840
Consulting		1,860		1,860		1,860		1,860

Average hourly billing rates are auditing $82, tax $92, and consulting $103.

Prepare the service revenue (sales) budget for 2017 by listing the departments and showing for each quarter and the year in total, billable hours, billable rate, and total revenue.