Question

In: Accounting

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

Solutions

Expert Solution

THOME AND CREDE CPAs
Sales Revenue Budget
For the year ending December 31,2017
Quarter 1 Quarter 2
Dept. Billable hours Billable rate Total rev. Billable hours Billable rate Total rev.
Auditing 2450 84 205800 1840 84 154560
Tax 3130 94 294220 2650 94 249100
Consulting 1640 105 172200 1640 105 172200
Totals 672220 575860
THOME AND CREDE CPAs
Sales Revenue Budget
For the year ending December 31,2017
Quarter 3 Quarter 4
Dept. Billable hours Billable rate Total rev. Billable hours Billable rate Total rev.
Auditing 2330 84 195720 2710 84 227640
Tax 2300 94 216200 2800 94 263200
Consulting 1640 105 172200 1640 105 172200
Totals 584120 663040
THOME AND CREDE CPAs
Sales Revenue Budget
For the year ending December 31,2017
Year
Dept. Billable hours Billable rate Total rev.
Auditing 9330 84 783720
Tax 10880 94 1022720
Consulting 6560 105 688800
Totals 2495240

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 (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...
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)...
Todd Enterprises is preparing a cash budget for the second quarter of the coming year. The...
Todd Enterprises is preparing a cash budget for the second quarter of the coming year. The following data have been forecasted: April May Sales ………………………………………………………… $150,000 $157,500 Merchandise purchases …………………………… 107,000 112,400 Operating expenses: Payroll ………………………………………………… 13,600 14,280 Advertising ………………………………………….. 5,400 5,700 Rent …………………………………………………….. 2,500 2,500 Depreciation ………………………………………… 7,500 7,500 End of April balances: Cash ……………………………………………………… 30,000 Bank loan payable ………………………………… 26,000 Additional data: (1) Sales are 40% cash and 60% credit. The collection pattern for credit sales is 50%...
Corporation is preparing its budget for the coming year. The first step is to plan for...
Corporation is preparing its budget for the coming year. The first step is to plan for the first quarter of that coming year. Waterways gathered the following information from the managers. Sales: Actual unit sates for November 113,500 Actual unit sales for December 103,100 Expected unit sales for January 114,000 Expected unit sales for February 113,500 Expected unit sales for March 116,000 Expected unit sales for April 126,000 Expected unit sales for May 138,500 Unit selling price $12 Waterways wants...
As part of the process of preparing the master budget for the coming year, you’ve been...
As part of the process of preparing the master budget for the coming year, you’ve been asked to perform what-if analyses, in the form of scenarios, on the original planning assumptions regarding Product A produced by your company. The following are the baseline planning data for the coming year for this product: Sales volume (annual, in units) 2,500 Selling price per unit $ 1,500 Variable cost per unit $ 1,000 Fixed costs (per year) $ 200,000 Required: 1. Based on...
EcoSacks manufactures cloth shopping bags. The controller is preparing a budget for the coming year and...
EcoSacks manufactures cloth shopping bags. The controller is preparing a budget for the coming year and asks for your assistance. The following costs and other data apply to bag production. Direct materials per bag 2.80 yard cotton at $3.80 per yard 1.10 yards canvas finish at $11.20 per yard Direct labor per bag 1.20 hour at $18.60 per hour Overhead per bag Indirect labor $ 1.30 Indirect materials 2.00 Power 2.20 Equipment costs 3.10 Building occupancy 2.70 Total overhead per...
Northern Illinois Manufacturing is preparing its budget for the coming year. The first step is to...
Northern Illinois Manufacturing is preparing its budget for the coming year. The first step is to plan for the first quarter of that coming year. Northern Illinois gathered the following information from its managers. Sales: Actual unit sates for November 113,500 Actual unit sales for December 103,100 Expected unit sales for January 114,000 Expected unit sales for February 113,500 Expected unit sales for March 116,000 Expected unit sales for April 126,000 Expected unit sales for May 138,500 Unit selling price...
Northern Illinois Manufacturing is preparing its budget for the coming year. The first step is to...
Northern Illinois Manufacturing is preparing its budget for the coming year. The first step is to plan for the first quarter of that coming year. Northern Illinois gathered the following information from its managers. Sales: Actual unit sates for November 113,500 Actual unit sales for December 103,100 Expected unit sales for January 114,000 Expected unit sales for February 113,500 Expected unit sales for March 116,000 Expected unit sales for April 126,000 Expected unit sales for May 138,500 Unit selling price...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT