Lonsdale Inc. manufactures entry and dining room lighting fixtures, Five activities are used in manufacturing the futures. These activities and their associated budgete activity costs and activity bases are as follows: Budgeted Activity Activity Cost Activity Base Casting 5414,000 Machine hours Assembly 152,000 Direct labor hours Inspecting 39,600 Number of inspections Setup 28,000 Number of setups Materials handling 22,000 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 10,000 Direct labor hours 4,800 3,200 8,000 Number of inspections 280 820 1,100 Number of setups 240 400 Number of loads 370 630 1,000 Units produced 1,800 4,700 6,500 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 160 Open spreadsheet 280 160 400 Machine hours 5.680 12,320 18,000 Direct labor hours 4,800 3,200 8,000 Number of inspections 329 1,100 Number of setups 240 Number of loads 370 630 1,000 Units produced 1,800 4,700 6,500 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. X Open sredsheet 3. Determine the activity rate for each activity. It required, round the rate to the nearest dollar Activity Activity Rate Casting per machine 5 per direct labor hour Inspecting 5 per inspection Setup $ per setup Material handling 5 3. 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 Living Fixtures 1 Dining Room Lighting Fixtures per ad