Crane and Crede, CPAs, are preparing their service revenue $($sales$)$ budget for the coming year $(2022).$ The practice is divided into three departments: auditing, tax, and consulting. Billable hours for each department, by quarter, are provided below.

$\backslash$table$[[$Department$,$Quarter $1,$Quarter $2,$Quarter $3,$Quarter $4],[$Auditing$,2,490,1,670,2,120,2,570],[Tax,3,180,2,280,2,120,2,650],[$Consulting$,1,590,1,590,1\mathrm{.}590,1,590]]$

Average hourly billing rates are auditing $$80,$ tax $$90,$ and consulting $$110.$

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

CRANE AND CREDE, CPAS

Service Revenue Budget