View Policies Current Attempt in Progress Roche and Young. CPAs, are preparing their service revenue (sales) budget for 2020. Their practice is divided into three departments, auditing, tax, and consulting, Billable hours for each department, by quarter are as follows: Department Quarter 1 Quarter 2 Quarter 3 Quarter 4 Auditing 2.200 1.600 1,800 2,600 Tax 3.300 2.300 1.900 2.700 Consulting 1,500 1.500 1.500 1,500 Average hourly billing rates are $60 for auditing, $71 for tax, and $82 for consulting services. Prepare the service revenue (sales) budget for 2020 by listing the departments and showing the billable hours, billable rate and total revenue for each quarter and the year in total ROCHE AND YOUNG, CPAS Service Revenue Budget For the Year Ending December 31, 2020 Quarter Auditing Billable 1 2 3 hours Rate Service Revenue Budget For the Year Ending December 31, 2020 Quarter 3 2 Auditing: Billable hours $ Rate $ Total revenue Quarter 2 3 Tax Billable hours $ $ $ S Rate $ $ Total revenue Quarter 3 Consulting Billable Quarter 3 N Tax Billable hours $ s $ Rate $ Total revenue Quarter 3 2 1 Consulting Billable hours $ $ $ Rate $ Total revenue $ $ Total revenue Thank and Media Lockwood Company combines its operating expenses for budget purposes in a selling and administrative expenses budget. For the first six months of 2020, the following data are available: 1 2 3. Sales: 19.900 units in quarter 1:22,500 units in quarter 2 Variable costs per dollar of sales: sales commissions 5%: delivery expense 2%; and advertising 4% Fixed costs per quarter: sales salaries $10.800; office salaries $7,300; depreciation $3,900; insurance $1,500, utilities $800; and repairs expense $400 Unit selling price: $20 Prepare a selling and administrative expenses budget by quarters for the first six months of 2020. LOCKWOOD COMPANY Selling and Administrative Expenses Budget For the Six Months Ending June 30, 2020 2 Total : $ $ $ $ $ $ Question 3 of 3