please use excel to answer

QUESTION 45 Use the following information related to an Activity-Based-Costing system to answer the following question. Cardinal Warehouse has determined the following activity cost pools and cost driver levels for the year: Activity Activity Cost Activity Cost Driver Machine Setup $50,000 1,000 setup hours Machine operation $75,000 1,000 machine hours The following data is for the production of one batch of a product Y: Units Produced 100 Direct labor cost $500 Direct materials costs $5,000 Machine hours Setup hours Required: Required: a. Determine the cost allocation rate (CAR) for each activity pool (machine setup and machine operations). b. Calculate the total product cost per unit for product Y. You must record your final answers to parts a and b in the answer space provided below. Label all answers. Note: You must show your work for partial credit. You may use the Excel file provided to document work and calculations or you may type work into the answer box below. ExcelFile.xlsx Anal 3/12p0