Current Attempt in Progress

Concord and Crede, CPAs, are preparing their service revenue $($sales$)$ budget for the coming year $12027.$ The practice is divided lata 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],[$Audlting$,1,990,1370,1720,2\mathrm{.}070],[$Tax$,2,580,1,890,1720,2,150],[$Consultine$,1\mathrm{.}290,1\mathrm{.}290,1290,1,290]]$

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

Prepare the service revenue $($sales$)$ budpet for $2027$ by listing the departments and showing for each quarter and the vear in fotall billable hours, billable rate, and total revenue.