Crede and Rensing, CPA\'s are preparing their services revenue (sales) budget fo

Question

Crede and Rensing, CPA's are preparing their services revenue (sales) budget for the coming year (2011). The practice is divided into three departments: auditing, tax, and consulting. Billable hours for each department by quarter are provided below.

Department: Q#1- Q#2- Q#3- Q#4-
Auditing 2116 1549 1979 2487
Tax 2912 2464 2051 2416
Consulting 1474 1474 1474 1474

Average hourly billing rates are: auditing $81, tax $89, and consulting $104

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

Directions: After completing the table for all three departments & four quarters. Please remember to provide totals for each department, and the grand total won't count as regular totals.

Explanation / Answer

Sales budget for the first Quarter:                   Sales budget                      For the year ended December 2011. Department Bill hours Bill rate price($) Total sales($) Auditing 2116 81 171396 Tax 2912 89 259168 Consulting 1474 104 153296 Total revenue form 1st Quarter sales 583860                   Sales budget                      For the year ended December 2011. Department Bill hours Bill rate price($) Total sales($) Auditing 2116 81 171396 Tax 2912 89 259168 Consulting 1474 104 153296 Total revenue form 1st Quarter sales 583860
Sales budget for the second Quarter:                Sales budget                      For the year ended December 2011. Department Bill hours Bill rate($) Total sales($) Auditing 1579 81 127899 Tax 2464 89 219296 Consulting 1474 104 153296 Total revenue form 2nd Quarter sales 500491 Sales buger for the third Quarter:                      Sales budget                            For the year ended December 2011. Department Bill rate Bill hours price($) Total sales($) Auditing 1979 81 160299 Tax 2051 89 182539 Consulting 1474 104 153296 Total revenue form 3rd Quarter sales 496134 Sales budget for the fouth Quarter:                      Sales budget                            For the year ended December 2011. Department Bill rate Bill hours price($) Total sales($) Auditing 2487 81 201447 Tax 2416 89 215024 Consulting 1474 104 153296 Total revenue form 4th Quarter sales 569767                      Sales budget                            For the year ended December 2011. Department Bill rate Bill hours price($) Total sales($) Auditing 2487 81 201447 Tax 2416 89 215024 Consulting 1474 104 153296 Total revenue form 4th Quarter sales 569767                   Sales budget                      For the year ended December 2011. Department Bill hours Bill rate price($) Total sales($) Auditing 2116 81 171396 Tax 2912 89 259168 Consulting 1474 104 153296 Total revenue form 1st Quarter sales 583860

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.