help needed with part B

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: Budgeted Activity Cost Activity Activity Base Casting $375,000 Machine hours Assembly 42,000 Direct labor hours Inspecting 33,250 Number of inspections Setup 46,750 Number of setups Materials handling 22,100 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 4,740 10,260 15,000 Direct labor hours 1,800 1,200 3,000 Number of inspections 440 510 950 Number of setups 330 220 550 Number of loads 550 300 850 Units produced 5,800 2,200 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 the questions below. Number of loads 550 300 850 Units produced 5,800 2,200 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 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 $ 25 per machine hour Assembly $ 14 per direct labor hour Inspecting $ 35 per inspection Setup $ 85 per setup Materials handling $ 26 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 Lighting Fixtures $ $ Dining Room Lighting Fixtures $ $ ni Arial 10 B v Av Merge General $ 40 .00 2 im > v ov Or ... H E34 fx =IF(C34="","",IF(ISERROR(FORMULATEXT(C34)), "Your answer should be a formula.",FORMULATEXT(C34))) A B D F 1 Activity rates and product costs using activity-based costing 2 Lonsdale Inc. manufactures entry and dining room lighting fixtures. Five activities are used in manufacturing the fixtures. These activities and their associated 3 budgeted activity costs and activity bases are as follows: 4 5 DATA 6 Activity Budgeted Activity Cost Activity Base 7 Casting $375,000 Machine hours 8 Assembly 42.000 Direct labor hours 9 Inspecting 33,250 Number of inspections 10 Setup 46,750 Number of setups 11 Materials handling 22, 100 Number of loads 12 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 DATA 16 Activity Base Entry Dining Total 17 Machine hours 4,740 10,260 15,000 18 Direct labor hours 1,800 1.200 3,000 19 Number of inspections 950 20 Number of setups 330 220 550 21 Number of loads 550 300 850 22 Units produced 5,800 2,200 8,000 440 510 = Data + G H 550 E34 fx =IF(C34="","",IF(ISERROR(FORMULATEXT(C34)),"Your answer should be a formula.",FORMULATEXT(C34))) A B D E F 15 DATA 16 Activity Base Entry Dining Total 17 Machine hours 4,740 10,260 15,000 18 Direct labor hours 1,800 1,200 3,000 19 Number of inspections 440 510 950 20 Number of setups 330 220 21 Number of loads 550 300 850 22 Units produced 5,800 2,200 8.000 23 Using formulas and cell references, perform the required analysis, and input your answers into Activity Rate, Total Activity Cost, and Activity Cost Per Unit 24 columns. Transfer the numeric results for the green entry cells (C27:C31, C34:D35) into the appropriate fields in CNOWv2 for grading. 25 26 a. Activity Activity Rate Formulas 27 Casting per machine hour 28 Assembly per direct labor hour 29 Inspecting per inspection 30 Setup per setup 31 Materials handling per load 32 33 Total Activity Cost Activity Cost Per Unit Formulas 34 Entry Lighting Fixtures 35 Dining Room Lighting Fixtures 36 37 38 b