please help me

Activity rates and product corts using activity-based costing Lonsdale Ine manufact is entry and dining toom lighting fixtures. Five activities are used in manufacturing the fistures. These activities ane their asteciated budgeted activity cos and activity bases ate as follows: Corporate records were obtained to estimate the amount of activity to be used by the two products. The estimated activity-bste usage quantities and units producet falluw: This information has been collected in the Microsot Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions beiow. Open spreadsheet a. Determine the activity rete for each activity, If required, round the rate to the nearest dolar: b. Use the activity rotes in (a) to determine the total and per-unit activity costs associated with each product. Round the per ualt rates to the nearest cent. T Chesk Mo wie b. Caiculate for each produst: Lonsdale Inc. manufactures entry and dining room lighting fotures. Five activities are used in manufacturing the foctures. These activities and theif associated budgeted activity costs and activity bases are as follows: Corporate records were obtained to estimate the amount of activity to be used by the two products. The estimated activity-base usage quantisies and units produced follow: Using formulas and cell references, perform the required analysis, and input your answers into Activity Rate, Total Activity Cost, and Activity Cost Per Unit alimne. Transfer the numeric results for the green entry cells (C27:C31, C34:D35) into the appropriate fields in CNOWv2 for grading. Ising formulas and cell reforences, perform the required analysis, and input your answers into Activity Rate, Total Activity Cost, and Activity Cost Per Unit olumns. Transfer the numeric results for the green entry cells (C27:C31, C34:D35) into the appripriate fields in CNOWV2 for grading