I need help completing a "activity rates and production costs using activity based costing" worksheet. I have attached all information needed.

Activity rates and product costs using activity-based costing Instructions Activity Table - Entry Lighting Activity Tablo - Dining Room Lighting Instructions Garfield Inc. manufactures entry and dining room lighting frodures. Five activities are used in manufacturing the futures. These activities and their associated budgeted activity costs and activity bases are as follows: Budgeted Activity Cost $105,741 62,010 Activity Casting Assembly Inspecting Setup Materials handling Activity Base Machine hours Direct labor hours Number of inspections Number of setups Number of loads 18,981 27,360 24.710 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 Total Entry 2.294 985 Dining 1.117 3.411 2.460 3.445 Machine hours Direct labor hours Number of inspections Number of setups 731 268 999 157 53 240 Number of loads 458 248 706 Units produced 5,253 2,039 7.292 Activity rates and product costs using activity-based costing Instructions Activity Table - Entry Lighting Activity Table - Dining Room Lighting NU UISCOS Instructions sperity Setup Materials handling 10,90 27,360 Number of setups 24,710 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 Entry Total Dining 1.117 2.294 3,411 985 2.460 3,445 Activity Base Machine hours Direct labot hours Number of inspections Number of seves Number of loads 731 268 999 187 53 240 458 248 706 Units produced 5,253 2,039 7,292 Required: Complete the Activity Table for entry lighting and dining room lighting fixtures a Determine the activity rate for each activity. Enter these rates in the Activity Rate columns 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 cont Activity rates and product costs using activity-based costing Instructions Activity Table - Entry Lighting Activity Tablo - Dining Room Lighting Instructions Activity Table - Entry Lighting ca Complete the Activity Table for entry lighting foxtures. a. Determine the activity rate for entry lighting activity. Enter these rates in the Activity Rato column. b. Use the activity rates in (a) to determine the total and per-unt activity costs associated with entry lighting product. Round the per-unit rates to the nearest cont. Entry Lighting Fixtures Activity Activity Base Activity Activity Usage X Rate Cost Casting S Assembly $ > Inspecting $ Setup $ Materials handling > $ Activity rates and product costs using activity-based costing Instructions Activity Table - Entry Lighting Activity Table - Dining Room Lighting Instructions Activity Table - Entry Lighting the nearest cont ca Entry Lighting Fixtures Activity Activity Baso Activity Activity Usage Rate Cost Casting > S Assembly $ Inspecting > $ > Setup $ 1 Materials handling $ Total activity cout $ Number of units Activity cost per unit tivity rates and product Instructions Activity Table - Entry Lighting Activity Table - Dining Room Lighting Activity Table - Dining Room Lighting Complete the Activity Table for dining room lighting fixtures. a. Determine the activity rate for dining room lighting activity. Enter these rates in the Activity Rato column. b. Use the activity rates in (a) to determine the total and per-unt activity costs associated with dining room lighting product. Round the per-unit rates to the nearest cent Dining Room Lighting Fixtures Activity Activity Activity Activity Base Cost Rate Usage S Casting > s Assembly > $ Inspecting $ Sotup > $ Materials handling vity rates and product costs using activity-based costing structions Activity Table - Entry Lighting Activity Table - Dining Room Lighting Activity Table - Dining Room Lighting Dining Room Lighting Fixtures Activity Activity Base Activity Activity Usage Rato Cost $ Casting Assembly $ 1 Inspecting > $ Setup S $ Materials handling > > $ Total activity cost Number of units Activity cost per unit S