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.