Thome and Crede, CPAs, are preparing their service revenue $($sales$)$ budget for the coming year $(2020).$ 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,5301,8502,3202,740$

Tax $3,2502,6802,1402,690$

Consulting $1,7701,7701,7701,770$

Average hourly billing rates are auditing $$83,$ tax $$94,$ and consulting $$102.$

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

THOME AND CREDE, CPAs

Service Revenue Budget

choose the accounting period

For the Quarter Ending December $31,2020$

Quarter $1$

Quarter $2$

Dept.

Billable Hours

Billable Rate

Total Rev.

Billable Hours

Billable Rate

Total Rev.

Auditing

enter a number of hours

$2530$

$enter a dollar amount

$83$

$enter a dollar amount

$209990$

enter a number of hours

$1850$

$enter a dollar amount

$83$

$enter a dollar amount

$153550$

Tax

enter a number of hours

$3250$

enter a dollar amount

$94$

enter a dollar amount

$305500$

enter a number of hours

$2680$

enter a dollar amount

$94$

enter a dollar amount

$251920$

Consulting

enter a number of hours

$1770$

enter a dollar amount

$102$

enter a dollar amount

$180840$

enter a number of hours

$1770$

enter a dollar amount

$102$

enter a dollar amount

$180840$

Totals $enter a total dollar amount

$696330$

$enter a total dollar amount

$586310$

THOME AND CREDE, CPAs

Service Revenue Budget

choose the accounting period

For the Year Ending December $31,2020$

Quarter $3$

Quarter $4$

Dept.

Billable Hours

Billable Rate

Total Rev.

Billable Hours

Billable Rate

Total Rev.

Auditing

enter a number of hours

$enter a dollar amount

$enter a dollar amount

enter a number of hours

$enter a dollar amount

$enter a dollar amount

Tax

enter a number of hours

enter a dollar amount

enter a dollar amount

enter a number of hours

enter a dollar amount

enter a dollar amount

Consulting enter a number of hours

enter a dollar amount

enter a dollar amount

enter a number of hours

enter a dollar amount

enter a dollar amount

Totals

$enter a total dollar amount

$enter a total dollar amount

THOME AND CREDE, CPAs

Service Revenue Budget

choose the accounting period

Year

Dept.

Billable Hours

Billable Rate

Total Rev.

Auditing

enter a number of hours

$enter a dollar amount

$enter a dollar amount

Tax

enter a number of hours

enter a dollar amount

enter a dollar amount

Consulting

enter a number of hours

enter a dollar amount

enter a dollar amount

Totals $enter a total dollar amount