Question 10 Variance analysis (20 marks) Create a handwritten/manual solution AND a spreadsheet solution to the following problem. Scanor use your phone to capture an image and paste a copy of your manual solution in your assignment submission. Also paste a spreadsheet solution showing the row and column headings and the fomula view. Your report should be completely fomula driven. Design your spreadsheet to meet the assignment requirements set out above. In particular, check the spreadsheet requirements and the Spreadsheet Advice PDF. Page 4 of 6 AC211 Management Accounting - Assessment 2 A B D E STANDARD COSTVARIANCE ANALYSIS - KLINGON LTD 2 3 Data 4 Standards 5 kg/hour Per Unit 6 Materials 11 $6 $66 7 Direct Labour 2 $20 $40 8 9 Monthly production data 10 11 Units produced 19.500 12 Material used 197,000 kg 13 Labour worked 40,000 hours 14 Material purchased 220.000 kg 15 Material purchased $1,364.000 16 17 18 Total Direct Labour Variance $1.950 UF 19 20 A. Answer the requirements using both a manual and spreadsheet solution. In yourspreadsheet, include the IF function to determine Favourable and Unfavourablevariances. Question 10 Variance analysis (20 marks) Create a handwritten/manual solution AND a spreadsheet solution to the following problem. Scanor use your phone to capture an image and paste a copy of your manual solution in your assignment submission. Also paste a spreadsheet solution showing the row and column headings and the fomula view. Your report should be completely fomula driven. Design your spreadsheet to meet the assignment requirements set out above. In particular, check the spreadsheet requirements and the Spreadsheet Advice PDF. Page 4 of 6 AC211 Management Accounting - Assessment 2 A B D E STANDARD COSTVARIANCE ANALYSIS - KLINGON LTD 2 3 Data 4 Standards 5 kg/hour Per Unit 6 Materials 11 $6 $66 7 Direct Labour 2 $20 $40 8 9 Monthly production data 10 11 Units produced 19.500 12 Material used 197,000 kg 13 Labour worked 40,000 hours 14 Material purchased 220.000 kg 15 Material purchased $1,364.000 16 17 18 Total Direct Labour Variance $1.950 UF 19 20 A. Answer the requirements using both a manual and spreadsheet solution. In yourspreadsheet, include the IF function to determine Favourable and Unfavourablevariances