Progressive Corporation uses an activity-based budgeting approach to prepare its annual budget for manufacturing overhead. Management is now in the process of preparing the budget for 2012. The activity cost pools and budgeted activity rates that have been identified are shown below. Budgeted Activity Rate Activity Cost Pool Direct labour support Batch setups Materials handling Purchasing Quality inspections Customer orders Product design $3 per DLH $500 per setup $200 per setup $150 per order $50 per inspection $25 per order $2,000 per modification The company manufactures two products, the R-192 and the T-295. Details developed for preparing the 2012 budget are as follows: a. Total budgeted sales (in units) based on the sales forecast are 6,000 for the R-192 and 15.000 for the T-295. b. Budgeted labour-hours per unit are 2.5 for the R-192 and 2 for the T-295. c. The R-192 will be produced in batch sizes of 500 units, while the T-295 will be produced in batch sizes of 1.500 units. d. Acquiring the materials needed to produce the R-192 will require 16 purchase orders, while the T-295 will need 20 purchase orders. e. Quality inspections will be performed on 10% of the units produced for both products. f. A total of 1,000 customer orders are expected for the R-192 and 750 for the T-295. g. Five design modifications are planned for the R-192 and three for the T-195. h. Direct materials are budgeted to be $45 per unit for the R-192 and $30 per unit for the T-295. 1. Direct labour costs are budgeted to be $20 per hour for 2012 j. There will be no opening or closing finished goods inventories. Management also estimates that the budget for the organization-sustaining overhead costs, not assigned to products, will be $250,000 for 2012. Required: Calculate the total budgeted expense for each activity in 2012. (Omit the "$" sign in your response.) 1. Budgeted Activity Cost $ Activity Cost Pool Direct labour support Batch setups Materials handling Purchasing Quality inspections Customer orders Product design Required: 1. Calculate the total budgeted expense for each activity in 2012. (Omit the "S" sign in your response.) Budgeted Activity Cost $ Activity Cost Pool Direct labour support Batch setups Materials handling Purchasing Quality inspections Customer orders Product design Total $ 2. Calculate the total overhead budget for 2012. (Omit the "$" sign in your response.) Total overhead budget 2. Calculate the total overhead budget for 2012. (Omit the "$" sign in your response.) Total overhead budget 3. Calculate the total budgeted production costs (including direct costs) for 2012. (Omit the "$" sign in your response.) Budgeted Amount Item Direct material costs: R-192 T-295 Direct labour costs: R-192 T-295 Activity costs Organization sustaining costs n Total production costs