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 Budgeted Activity Cost Activity Base Assembly Inspecting Setup Materials handling $279,160 Machine hours 227,400 Direct labor hours 41.310 Number of inspections 40,600 Number of setups 40,590 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,280 4,690 9,970 Direct labor hours 4.550 6,820 11,370 Number of inspections 1,850 580 2,430 Number of setups 230 60 290 Number of loads Units produced 780 10,600 210 5,300 990 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.