Activity rates and product costs using activity-based costing Instructions Activity Table Entry Lighting Activity Table Dining Room Lighting Instructions Lightsquare 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 Activit Activity Base Casting $114,380 Machine hours 66,620 Direct labor hours Assembly 26,985Number of inspections 29,631Number of setups Inspecting Setup Materials handling 28,105 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 2,100 1,168 3,268 1,089 2,242 3,331 Direct labor hours 977 308 1,285 Number of inspections Number of setups 190 59 249 Number of loads 593 210 803 Units produced 5,830 2,078 7,908 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 cent Activity Table Entry Lighting Complete the Activity Table for entry lighting fixtures. A. Determine the activity rate for each activity. Enter these rates in the Activity Rate column 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. Entry Lighting Fixtures Activity- Activity Activity Activity Base Rate Cost Usage Casting Assembly Inspecting Setup Materials handling Total activity cost + Number of units Activity cost per unit Activity Table Dining Room Lighting Complete the Activity Table for dining room lighting fixtures A. Determine the activity rate for each activity. Enter these rates in the Activity Rate column 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. Dining Room Lighting Fixtures Activity- Activity Activity Base Activity Cost Rate Usage Casting Assembly Inspecting Setup Materials handling Total activity cost Number of units Activity cost per unit