A 1 2 B Activity rates and product costs using activity-based costing D E F 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: 3 4 5 6 Activity 7 Casting 8 Assembly 9 Inspecting 10 Setup 11 Materials handling 12 DATA Budgeted Activity Cost $700,000 Activity Base Machine hours Direct labor hours Number of inspections 133,000 44,650 56,400 34,850 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 13 produced follow: 14 15 16 Activity Base 17 Machine hours. 18 Direct labor hours 19 Number of inspections 20 Number of setups 21 Number of loads 22 Units produced 23 DATA Entry Dining Total 6,320 13,680 20,000 5,700 3,800 9,500 460 490 950 360 240 600 230 620 850 3,400 3,100 6,500 Using formulas and cell references, perform the required analysis, and input your answers into Activity Rate, Total Activity Cost, and Activity Cost Per Unit columns. Transfer the numeric results for the green entry cells (C27:C31, C34:D35) into the appropriate fields in CNOWv2 for grading. 24 25 26 a. Activity 27 Casting 28 Assembly Activity Rate per machine hour per direct labor hour Formulas 29 Inspecting per inspection 30 Setup per setup 31 Materials handling per load 32 33 b. Total Activity Cost Activity Cost Per Unit Formulas 34 Entry Lighting Fixtures 35 Dining Room Lighting Fixtures 36 37 38 G