Activity rates and product costs using activity-based costing Lonsdale 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 $416,000 Machine hours 28,000 Direct labor hours 35,150 Number of inspections 53,350 33,150 Number of setups 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,050 10,950 16,000 Direcabor hours 1,200 800 2,000 Number of inspections 620 330 950 Number of setups 330 220 550 Number of loads 350 300 650 Units produced 2,500 5,500 8,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in