1. What's The use use variance for part a? (Hint: for production of both X and Y)?

2. what is the price variance for part a? (hint: for production of both X and Y)?

3. What is the total variance for part a? (hint: for production of both X and Y) ?

4. What is the use variance for Part B? (hint: for production of both X and Y)?

5. what is the price variance for Part B? (hint: for production of both X and Y)?

6. what is the total variance for Part B? (hint: for production of both X and Y)?

7. what is the rate variance for labor? (hint: for production of both X and Y )?

8. What is the Efficiency variance for labor? (hint: for production of both X and Y) ?

9. what is the total variance of Labor (hint: for both production X and Y )?

Excel and please kindly show how to do it thank you :)

I. As 31 A B We are analyzing 2 products - product X and product Y. (45 points) Product X requires 2 Part As and 3 Part B's. Product Y requires 4 Part A's and 2 Part B's. The standard cost for Part A is $10 per unit. The standard cost for Part B is $25 per unit. During this month, the company purchased 50,000 units of Part A for $550,000 (there was no beginning balance). During this month, the company purchased 100,000 units of Part Pout B for $2,400,000 (there was no beginning balance). During the month the company produced 500 Xs and 1000 Ys. SQ AP: 950,00 During the month the company used 4900 units of Part A and 11 3600 units of Part B. A2 = 4,90 units of Pata & AQ Factory payroll was $393,000 with 19,500 hours (this is actual - vents of Paul B direct labor only) -> AH = 19,5W ~ AR: 393,00 X uses 10 standard direct labor hours. - $20. 19,56 Y uses 15 standard direct labor hours. SH X 10DLH Labor standard cost is $20 per hour. AP -$24/B hint: for production of both X and Y Y IS DLH o units of AP - 2422,22