View Policies Current Attempt in Progress Lewis and Lee, 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 here. Quarter 1 Quarter 2 Quarter 3 Quarter 4 Department Auditing 2,668 1.856 2,320 2,784 Tax 3.480 2.552 2,320 2.900 Consulting 1.740 1.740 1,740 1740 Average hourly billing rates are auditing $100, tax $108. and consulting S124 Prepare the service revenue sales budget for 2022 by listing the departments and showing for each ouarter and the year in total. billable hours, billable rate, and total revenue. LEWIS AND LEE, CPAS Service Revenue Budget Quarter 1 Dept. Billable Hours Billable Rate Total Rev. Billable Hours Auditing $ S Tax Consulting S Totals LEWIS AND LEE, CPAS Service Revenue Budget er 1 Quarter 2 Rate Total Rev. Billable Hours Billable Rate Total Rev. $ s $ s S LEWIS AND LEE, CPAS Service Revenue Budget Quarter 3 Dept. Billable Hours Billable Rate Total Rev. Billable Hours Auditing $ $ Tax Consulting 5 Totals AND IFE Cnas LEWIS AND LEE, CPAS Service Revenue Budget Quarter 4 Rate Total Rev. Billable Hours Billable Rate Total Rev. s S $ $ $ LEWIS AND LEE, CPAS Service Revenue Budget Year Dept. Billable Hours Billable Rate Total Rev. Auditing $ $ Tax Consulting Totals