Need help solving this problem
A 3D Models My Add-ins Recommended Maps PivotChart 3D Line Column Win/ Slicer Timeline Link Text PivotTables Charts Map Loss Box Tables Illustrations Add-ins charts Tours Sparklines Filters Links UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. Update now A1 : X V fx ABC Method A B C D E G H 1 ABC Method Product 1 Product 2 2 Total Activity 3 Pool Driver Total Cost for Driver Rate Activity $Allocation Activity $Allocation 4 18 10 11 12 13 Total 14 15 Units Units OH Per Unit OH Per Unit 16 Sheet1 Example ABC |Example Traditional | + Edit Type here to search O e m : 45 W X P DELLPivotTable Recommended Table Pictures 3D Models My Add-ins Recommended Maps PivotChart 3D Line Column Win/ Slicer Timeline PivotTables Charts Map Loss Tables Illustrations Add-ins Charts Tours Sparklines Filters UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. Update now A1 X fx ABC Method A B D E G H K 8 9 10 11 12 13 Total 0 14 15 Units Units 16 OH Per Unit OH Per Unit 17 18 DM Per Unit DM Per Unit 19 DL Per Unit DL Per Unit 20 OH Per Unit OH Per Unit 21 Total per Unit 0.00 Total per Unit 0.00 22 23 Sheet1 Example ABC | Example Traditional | + Edit Type here to search W X P DELLFile Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Cut Calibri 11 VA A ab Wrap Text General Normal Bad Paste Copy B IU . . DA. Merge & Center 5 - % " .00 20 Conditional Format as Good Neutral Format Painter Formatting . Table . KIKIS Insert Clipboard Font Alignment Number Styles UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. Update now H24 X V fx A B C D E F G H K L Traditional Total Activity 3 POOL Driver Total Cost For Driver Rate Activity $Allocation Activity $Allocation TOTAL OH DLH UT 6 00 V 10 11 12 13 TOTAL 14 15 16 Units Units 17 OH Per Unit OH Per Unit 18 19 DM Per Unit DM Per Unit 20 DL Per Unit DL Per Unit 21 OH Per Unit OH Per Unit 22 Total Per Unit Total Per Unit 23 24 25 26 27 + Sheet1 + Ready O Type here to search O 45 W PInstructions 1. We are analyzing 2 products - product X and product Y. . Product X requires 3 Part As and 4 Part B's. . Product Y requires 2 Part A's and 3 Part B's. . The standard cost for Part A is $12 per unit. . The standard cost for Part B is $24 per unit. . During this month, the company purchased 50,000 units of Part A for $587,500 (there was no beginning balance). . During this month, the company purchased 100,000 units of Part B for $2,500,000 (there was no beginning balance). . During the month the company produced 500 Xs and 1000 Ys. . During the month the company used 3550 units of Part A and 4975 units of Part B. . Factory payroll was $393,000 with 19,500 hours (this is actual - direct labor only). . X uses 12 standard direct labor hours. . Y uses 14 standard direct labor hours. . Labor standard cost is $20 per hour. hint: for production of both X and Y Questions 1-25: Suggestion: Use a scratch paper to solve all the variances first, then answer the questions. 2.Use the information given in Problem I. Use standard cost information for all calculations except as noted below.. X uses 12 standard direct labor hours. ic . Y uses 14 standard direct labor hours. . Labor standard cost is $20 per hour. hint: for production of both X and Y Questions 1-25: Suggestion: Use a scratch paper to solve all the variances first, then answer the questions. 2.Use the information given in Problem I. Use standard cost information for all calculations except as noted below. Department $ Costs Activity Cost Driver Supplies $22,000 Direct labor hours Assembling $17,000 Units of standard direct material (Parts) Packaging $15,000 Completed units Questions 26-50: Suggestion: use the worksheet to complete the problem first, then answer the questions. to search e 45 W PUPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. Update now K28 X V fx A B C D E G H K M UTA Price Use (quantity) 6 Part A Total Variance 9 IN 10 11 12 AQ AP AQ SP sQ SP 13 14 15 Price Use (quantity) 16 Part B 17 18 Total Variance 19 20 21 22 23 AH AR AH SR SH SR 24 25 26 DL Rate ( Labor P) Efficiecity ( labor q) 27 28 29 Total Variance 30 Sheet1 + Ready Type here to search O e 45 W X P