Current Attempt in Progress

Waterway and Crede, CPAs, are preparing their service revenue $($sales$)$ budget for the coming year $(2025).$ 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,390,1,610,2,040,2,470],[$Tax$,3,060,2,200,2,040,2,550],[$Consulting$,1,530,1,530,1,530,1,530]]$

Average hourly billing rates are auditing $$70,$ tax $$80,$ and consulting $$100.$

Prepare the service revenue $($sales$)$ budget for $2025$ by listing the departments and showing billable hours, billable rate, and total revenue for each quarter and

Year