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: Activity Casting Assembly Inspecting Setup Materials handling Budgeted Activity Cost Activity Base $294,500 Machine hours 184,110 Direct labor hours 29,960 Number of inspections 48,280 Number of setups 36,960 Number of loads 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,040 4,460 9,500 Direct labor hours 4,330 6,500 10,830 Number of inspections 1,630 510 2,140 Number of setups 280 60 340 Number of loads 700 180 880 Units produced 10,000 5,000 15,000 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. a. Determine the activity rate for each activity. If required, round the rate to the nearest dollar. Activity Casting Assembly Inspecting Activity Rate per machine hour per direct labor hour per inspection Setup Materials handling per setup 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 Total Activity Cost Activity Cost Per Unit Entry Lighting Fixtures Dining Room Lighting Fixtures $ $