Thome and Crede. are preparing their services revenue (sales) budget for the coming year (2017). The practice is divided into three department : 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,300 1,600 2,000 2,400
Tax 3,000 2,200 2,000 2,500
Consulting 1,500 1,500 1,500 1,500
Average hourly billing rates are auditing $80, tax $90, and consulting $110
Instructions
Prepar the service revenue (sales) budget for 2017 by listings the departments and showing for each quarter and the year in total, billable hours, billable rate, and total revenue.





