lomework CEL.ALGO eBook Machine hours ng Center Login Direct labor hours Open spreadsheet 10,130 11,550 Number of inspections 2,210 Number of setups 270 Number of loads 1,060 Units produced 10,600 5,300 15,900 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 bel Product 5,370 4,620 1,680 $ $ Entry Lighting Fixtures Dining Room Lighting Fixtures 220 840 Office 365 a. Determine the activity rate for each activity. If required, round the rate to the nearest dollar. Activity Rate 4,760 6,930 530 Activity Casting per machine hour Assembly per direct labor hour per inspection Inspecting Setup 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 amounts to the nearest cent. Total Activity Cost Activity Cost Per Unit $ 50 220

Dpen spreadsheet a. Determine the activity rate for each activity. If required, round the rate to the nearest doltar