Activity rates and product costs using activity-based cost Idris Inc. manufactures entry and dining room lighting fixtures. Five activities are used in manufacturing the fixtures. These activities and their associated budgeted activity costs and activity bases are as follows: Budgeted Activity Cost Activity Base Activity Casting Assembly Inspecting Setup $350,700 Machine hours 159,880 Direct labor hours 23,760 Number of inspections 37,700 Number of setups 50,600 Number of loads Materials handling Corporate records were obtained to estimate the amount of activity to be used by the two products. The estimated activity-base usage quantities and units produced follow: Activity Base Entry Dining Total Machine hours 5,310 4,710 10,020 Direct labor hours 4,570. 6,850 11,420 Number of inspections 1,640 520 2,160 Number of setups 230 60 290 Number of loads 870 230 Units produced 10,600 5,300 1,100 15,900 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below Dnen spreadsheet Check My Work Previous eBook Office 365 Machine hours 5,310 4,710 10,020 Direct labor hours 4,570 6,850 11,420 Number of inspections 1,640 520 2,160 Number of setups 230 60 290 Number of loads 870 230 1,100 Units produced 10,600 5,300 15,900 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open.spreadsheet a. Determine the activity rate for each activity. If required, round the rate to the nearest dollar. Activity Casting Assembly Inspecting Setup Activity Rate 35 per machine hour 14 per direct labor hour 11 per inspection 130 per setup Materials handling 46 per load b. Use the activity rates in (a) to determine the total and per-unit activity costs associated with each product. Round the per unit amounts to the nearest cent. Product Entry Lighting Fixtures Dining Room Lighting Fixtures Total Activity Cost Activity Cost Per Unit