Please use the information to complete the excel sheet that should be filled.

We are analyzing 2 products - product X and product Y. o Product X requires 4 Part As and 3 Part B's. o Product Y requires 3 Part A's and 2 Part B's. o The standard cost for Part A is $24 per unit. The standard cost for Part B is $12 per unit. o During this month, the company purchased 50,000 units of Part A for $1,220,000 (there was no beginning balance). o During this month, the company purchased 50,000 units of Part B for $590,000 (there was no beginning balance). During the month the company produced 500 Xs and 1000 Ys. During the month the company used 4950 units of Part A and 3540 units of Part B. o Factory payroll was $393,000 with 19,500 hours (this is actual - direct labor only). o Xuses 14 standard direct labor hours. Y uses 12 standard direct labor hours. Labor standard cost is $20 per hour. t: for production of both X and Y Use standard cost information for all calculations except as noted below. Department $Costs Activity Cost Driver Supplies $22,800 Direct labor hours Assembling $12,750 Units of standard direct material (Parts) Packaging $10,050 Completed units Questions 26-50: Suggestion: use the worksheet to complete the problem first, then answer the questions. Product 1 Product 2 Total Activity for Driver Pool Dover Total Cost Rate Activity $Allocation Activity $Allocation Total Units Units OH Per Unit OH Per Unit DM Per Unit DM Per Unit DL Per Unit DL Per Unit OH Per Unit OH Per Unit Total per Unit 0.00 Total per Unit