help please!

Garfield Inc. manufactures entry and dining room lighting fotures. Five activities are used in manufacturing the fixtures. These activities and their associated budgeted activity costs and activity buses are as follows: Activity Casting Assembly Inspecting Budgeted Activity Cost Activity Base $142.926 Machine hours 57.741 Direct labor hours 19,912 Number of inspections 24,300 Number of setups Setup Materials handling 32.452 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 Dining Total Activity Base Machine hours 1.030 3.486 2.456 840 Direct labor hours 2,199 3,039 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 Total Entry 2.456 Dining 1,030 3.486 840 3,039 Activity Base Machine hours Direct labor hours Number of inspections Number of sus Number of loads Units produced 2.199 290 758 1,048 174 51 225 638 216 854 6,432 2.200 8.632 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 Complete the Activity Table for entry lighting fixtures a Determine the activity rate for entry fighting activity. Enter these rates in the Activity Rato column 6. Use the activity rates in (a) to determine the total and persunt activity costs associated with entry igning product Round the per-unt rates to the nearest cent Entry Lighting Fixtures Activity Activity Base Activity Activity Usage Rate Cost Casting 1.429 X mi $348 X 541 X Assembly 5.774 X dih 19 X 5303 Xh Inspecting 1991 X insp $104 X Ansp. I 19 X Setup 2.430 X setups $225 X setup 108 X Dr Navt 11:09 PM Shaded cele deck Activity Activity Base Activity Activity Usage X Rate Cost Casting 1,429 X $348 X $41 Assembly 5,774 X dit 5303 X lih 19 X Inspecting 1.991 X insp. 5104 X Ansp. 19 X Setup 2.430 X setups 5225 X setup 108 X Materials handling 3,245 X loads $854 Xoad 38 X Total activity cost Number of units Activity cost per unit Points 9/28 Drain 11 Activity Table - Dining Room Lighting Shaded cetve feed Complete the activity Table for dining room lighting futures a. Determine the activity rate for dining room lighting activity Enter these rates in the Activity Rate 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-unt rates to the nearest cent Dining Room Lighting Fixtures Activity Activity Activity Activity Base X Rate Cost Usage $41 $100,696 X 2.456 X Casting $19 15.960 x 840 X Assembly $19 14.42 x 758 X Inspecting 18.792 x 5108 174 X Setup Materials D 11:09 PM 90 Activity Table - Dining Room Lighting Shaded celle dock Dining Room Lighting Fixtures Activity Activity Base Activity Activity Usage X Rate Cost Casting 2.456 X 341 $100,696 X Assembly 5197 840 X 15,960 x $19 758 X Inspecting 14.402 X 5108 18,792 Setup 174 X $38 24 244 X Materials handling 638 X 1 $174.094 X Total activity cost 6.432 X Number of units $27 06 X Activity cost per unit Dr Naut 11:09 PM