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,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 2020 by listing the departments and showing for each quarter and the year in total, billable hours, billable rate, and total revenue.

Solutions

Expert Solution

Particulars DEPARTMENTS
Auditing Tax Consulting
Quarter 1 :
Billable Hours 2500 3250 1780
Hourly Billing rate 85 94 105
Quarter 1 Revenue $212,500 305,500 186,900
Quarter 2 :
Billable Hours 1730 2750 1780
Hourly Billing rate 85 94 105
Quarter 2 Revenue 147,050 258,500 186,900
Quarter 3 :
Billable Hours 2400 2400 1780
Hourly Billing rate 85 94 105
Quarter 3 Revenue 204,000 225,600 186,900
Quarter 4 :
Billable Hours 2690 2690 1780
Hourly Billing rate 85 94 105
Quarter 4 Revenue 228,650 252,860 186,900
Total Billing Hours for the year 9320 11090 7120
Hourly Billing rate 85 94 105
Total Yearly Revenue 792,200 1,042,460 747,600

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,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 (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...
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 Continuing Problem 09 Waterways Corporation is preparing its budget for the coming year, 2020. The...
Waterways Continuing Problem 09 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 112,000 Expected unit sales for March 2020 116,000 Expected unit sales...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT