Activity rates and product costs using activity-based costing Lonsdale Inc, manufactures entry and dining room iting fixtures. Five activities are used in manufacturing the fixtures. These activities and the stocated budgeted activity costs and activity bras follows: Budgeted Activity Activity Cost Activity Base Casting $576.000 Machine hours Assembly 104.000 Direct labor hours Inspecting 44.100 Number of inspection 500 Number of setups Material handling 24.000 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 Tatry Total Machine 5.680 12,370 Direct lator hours 1.000 Number of inspection 100 nads This information has been collected in the Microsoft Excel Online is open the ashes or there analysis, diput your awes is the gestione Open spreadshe Determine the activity rate for each activity free, found the rate to the nearest dollar Activity Activity Rate Casting 3 De machine the Assembly 5 per direct labor hour Inspecting 5 per inspection Setup 48,500 Number of setup Materials handling 24,700 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,680 12,320 18,000 Direct labor hours 33.900 2,600 6,500 Number of inspections 230 820 1.050 Number of setups 300 200 500 Number of loads 510 950 Units produced 4,300 3,200 7.500 440 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 Activity Rate Casting $ per machine hour Assembly 5 per direct labor hour Inspecting 5 per inspection Setup 5 per setup Materials handling $ 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 rates to the nearest cent. Product Total Activity Cost Activity Cost Per Unit Entry Ughting Fixtures 5 Dining Room Lighting Fixtures $ 5