Question
Coronado and Crede, CPAs, are preparing their service revenue (sales) budget for the coming year (2022). The practice is divided into three departments: auditing, tax,
Coronado 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.
Department
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Auditing 2,140 1,460 1,840 2,220
Tax 2,760 2,000 1,840 2,300
Consulting 1,380 1,380 1,380 1,380
Average hourly billing rates are auditing $70, tax $80, and consulting $100.
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 total revenue.
CORONADO AND CREDE, CPAs
Service Revenue Budget
choose the accounting period
Quarter 1
Quarter 2
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
CORONADO AND CREDE, CPAs
Service Revenue Budget
choose the accounting period
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
CORONADO 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started