Activity and product cousing 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: Budgeted Activity Cost Activity Base SS58.000 Machine hours Assembly 60.000 Direct labor hours Inspecting 47,300 Number of inspections 47,000 Number of setups Material handling 34,000 Number of loads Corporate records were and to estimate the amount of activity to be used by the two products. The stated activity and its produced Activity Base Entry Dining Total Machine hours 5,680 12,320 18.000 Direct labor hours 2,400 1,600 4,000 Number of inspections 290 810 1,100 Number of setups 300 Number of ads 1.000 10 6.000 This information has been collected in the Microsoft Excel Online fille. Open the spreadsheet perform the required analysis, and input your answers in the questions below 700 500 x] Open spreadsheet Determine the activity for each activity. Freed, there tot Activity Rate per machine hou Assembly per direct labor hour Inspecting per inspection Previous Machine hours 5.680 12,320 18.000 Direct labor hours 2,400 1,600 4,000 Number of inspections 290 101,100 Number of setups 300 200 500 Number of loads 420 580 1,000 Units produced 900 5.100 6,000 Open the spreadsheet, perform the retured analysis, and not your answers in This information has been collected in the Microsoft Excel Online x Open spreadsheet a. Determine the activity rate for each activity. If required, rond a te to the nearest do Activity Activity Rate Casting per machine hour per direct labor hour Assembly Inspecting per inspection per setup Material handling per load Use the activity rates in (a) to determine the total and per unit activity Co s ciated with each product. Round the per un rates to the neares Product Total Activity Cost Activity Cost Per Unit Entry Lighting Fixtures Dining Room Lighting Fixtures