Lonsdale 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: Cosporate 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: 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 below, Open spreadsheet a. Determine the activity rate for each activity. If required, round the rate to the nearest dollar: b. Use the activity rates in (a) to determine the total and per-unit activity costs associated with each product. Pound the per-unit rates to the nearest cent