Exercise 7-35 Activity-based budgeting LO A1 Render Co. CPA is preparing activity-based budgets for 2017. The partners expect the firm to generate billable hours for the year as follows: Data entry Auditing Tax Consulting 1,060 hours 2,340 hours 2,240 hours 390 hours The company pays $12 per hour to data-entry clerks, $39 per hour to audit personnel, $53 per hour to tax personnel, and $53 per hour to consulting personnel. Prepare a schedule of budgeted labor costs for 2017 using activity-based budgeting. RENDER CO. CPA Activity-Based Budget For The Year Ending December 31, 2017 Budgeted Budgeted Budgeted Hours Rate/hour Cost Data-entry Auditing Tax Consulting Total