Question

In: Accounting

Thome and Crede, CPAs, are preparing their service revenue (sales) budget for the coming year (2020)....

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,530 1,850 2,320 2,740
Tax 3,250 2,680 2,140 2,690
Consulting 1,770 1,770 1,770 1,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 Year Ending December 31, 2020December 31, 2020For 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

$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                                                          For the Quarter Ending December 31, 2020December 31, 2020For 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                                                          For the Year Ending December 31, 2020December 31, 2020For the Quarter Ending December 31, 2020

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

Solutions

Expert Solution

THOME AND CREDE CPAs
Sales Revenue Budget
For the year ending December 31,2020
Quarter 1 Quarter 2
Dept. Billable hours Billable rate Total rev. Billable hours Billable rate Total rev.
Auditing 2530 83 209990 1850 83 153550
Tax 3250 94 305500 2680 94 251920
Consulting 1770 102 180540 1770 102 180540
Totals 696030 586010
THOME AND CREDE CPAs
Sales Revenue Budget
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 2320 83 192560 2740 83 227420
Tax 2140 94 201160 2690 94 252860
Consulting 1770 102 180540 1770 102 180540
Totals 574260 660820
THOME AND CREDE CPAs
Sales Revenue Budget
For the year ending December 31,2020
Year
Dept. Billable hours Billable rate Total rev.
Auditing 9440 83 783520
Tax 10760 94 1011440
Consulting 7080 102 722160
Totals 2517120

Related Solutions

Thome and Crede, CPAs, are preparing their service revenue (sales) budget for the coming year (2020)....
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,500 1,730 2,400 2,690 Tax 3,250 2,750 2,400 2,720 Consulting 1,780 1,780 1,780 1,780 Average hourly billing rates are auditing $85, tax $94, and consulting $105. Prepare the service revenue (sales) budget for...
Thome and Crede, CPAs, are preparing their service revenue (sales) budget for the coming year (2020)....
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,480 1,920 2,300 2,570 Tax 3,170 2,510 2,300 2,640 Consulting 1,890 1,890 1,890 1,890 Average hourly billing rates are auditing $81, tax $93, and consulting $102. Prepare the service revenue (sales) budget for...
Thome and Crede, CPAs, are preparing their service revenue (sales) budget for the coming year (2017)....
Thome and Crede, CPAs, are preparing their service revenue (sales) budget for the coming year (2017). 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,450 1,840 2,330 2,710 Tax 3,130 2,650 2,300 2,800 Consulting 1,640 1,640 1,640 1,640 Average hourly billing rates are auditing $84, tax $94, and consulting $105. Prepare the service revenue (sales) budget for...
Exercise 21-3 Thome and Crede, CPAs, are preparing their service revenue (sales) budget for the coming...
Exercise 21-3 Thome and Crede, CPAs, are preparing their service revenue (sales) budget for the coming year (2017). 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,540 1,930 2,200 2,740 Tax 3,330 2,510 2,110 2,780 Consulting 1,730 1,730 1,730 1,730 Average hourly billing rates are auditing $83, tax $95, and consulting $103. Prepare the service revenue (sales)...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 111,000 Unit sales for December 2019 101,000 Expected unit sales for January 2020 112,000 Expected unit sales for February 2020 114,000 Expected unit sales for March 2020 115,000 Expected unit sales for April 2020 124,000...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 114,000 Unit sales for December 2019 103,000 Expected unit sales for January 2020 114,000 Expected unit sales for February 2020 111,000 Expected unit sales for March 2020 116,000 Expected unit sales for April 2020 125,000...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 111,000 Unit sales for December 2019 103,000 Expected unit sales for January 2020 114,000 Expected unit sales for February 2020 114,000 Expected unit sales for March 2020 116,000 Expected unit sales for April 2020 127,000...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 113,000 Unit sales for December 2019 101,000 Expected unit sales for January 2020 114,000 Expected unit sales for February 2020 111,000 Expected unit sales for March 2020 117,000 Expected unit sales for April 2020 124,000...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 112,000 Unit sales for December 2019 101,000 Expected unit sales for January 2020 114,000 Expected unit sales for February 2020 112,000 Expected unit sales for March 2020 115,000 Expected unit sales for April 2020 127,000...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 111,000 Unit sales for December 2019 103,000 Expected unit sales for January 2020 114,000 Expected unit sales for February 2020 112,000 Expected unit sales for March 2020 116,000 Expected unit sales for April 2020 124,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT