Problem
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,450 1,840 2,330 2,710 Tax 3,130 2,650 2,300 2,800 Consulting 1,640 1,640 1,640 1,640 Average hourly billing rates are auditing $84, tax $94, and consulting $105.
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.