(d) Prepare a report analysing the variances calculated in part (b) of your answer. You should indicate possible instances of inter-relationships between the variances and provide possible reasons for, and solutions to, the problems highlighted.

AutoSave OFF ACY . DA9 ... Copy of Blibb_Blobb_Assessment_22_ Home Insert Draw Page Layout Formulas Data Review View Automate ? Tell me Calibri (Body) 10 v A A ab Wrap Text v General Paste IUVV = = Merge & Centre v x Update Available We've made some fixes and improvements. To complete the process, the app needs to restart. L28 X V ABC D LL I KLM Z O Contribution Variances Standard Quantity Standard Mix Standard Contribution A Blibb 22,000 0.454545455 72.00 720,000 Blobb 22,000 0.545454545 88.00 1,056,000 1,776,000 Actual Quantity Standard Mix Standard Contribution Blib 22,200 0.454545455 72.00 726,545 Blobb 22,200 0.545454545 88.00 1,065,600 1,792,145 Actual Quantity Actual Mix Standard Contribution C Blibb 22,200 0.44 72.00 705,600 Blobb 22,200 0.56 88.00 1,091,200 1,796,800 Actual Quantity Actual Mix Actual Contribution E D Blibb 22,200 0.44 66.00 646,800 Blobb 22,200 0.56 103.00 1,277,200 1,924,000 Variances Volume A-B 1,776,000 1,792,145 16, 145 F Mix B-C 1,792,145 1,796,800 4,655 F Price C-D 1,796,800 1,924,000 127,200 F Total A-D 1,776,000 1,924,000 148,000 Question Flexed budget Sales Contribution Materials Labour Fixed OH Recon Select destination and press ENTER or choose PasteFormulas Review View Automat Home Insert Draw Page Layout Data A ab Wrap Calibri (Body) 11 X'o ICH em = = = Merge Paste I U * Update Available We've made some fixes and improvements. To complete the process, the app need 132 X V I O CO Reconciliation of Budgeted to Actual Profit Absorption Method 1,440,000 Budgeted profit 143,200 Sales Margin Variances 1,583,200 Cost Variances: Material -31,750 Labour -446,702 Variable overheads Fixed overhead variance -72,982 -551,434 Actual profit 1,031,766 Marginal Method Budgeted contribution 1,776,000 Sales contribution Variances 148,000 1,924,000 Cost Variances: Material -31,750 Labour -446,702 Variable overheads -478,452 Actual Contribution 1,445,548 Budgeted fixed overheads 336,000 Fixed overhead expenditure variance 71,000 265,000 Actual profit 1,180,548 34 35 Question Flexed budget Sales Contribution Materials Labour Select destination and press ENTER or choose PasteCopy of Blibb_Blobb_Assessment_22_Template.xis - C AutoSave OFF Formulas Data Automate Tell me Page Layout Review View Home Insert Draw Custom Calibri (Body) v 10 VAA ap Wrap Text v LO BI MVA v Merge & Centre v % 9 Paste UV x Update Available We've made some fixes and improvements. To complete the process, the app needs to restart. H4 fx =((Question!D14/(Question!D13/Question!C13))) Z I LL IJK A Fixed Overhead Variances Standard Hours Standard Rate 44 32,003 $6.00 192,018 D Actual Production Hours Standard Rate 4 58 ,860 f6.00 353,160 Budgeted overheads 11 336,000 Actual overheads 11 265,000 Variances Efficiency A-B 192,018 353,160 -161,142 A Capacity B-C 353,160 336,000 17,160 F Volume A-C 192,018 336,000 11 11 11 11 1 Expenditure -143,982 A C-D 336,000 265,000 Cost 71,000 F A-D 192,018 265,000 -72,982 A Question Flexed budget Sales Contribution Materials Labour Fixed OH Select destination and press ENTER or choose Paste Recon + escPaste x Update Available We've made some fixes and improvements. To complete the process, 055 X O I m ABC C Material Variances Standard Mix Standard Price Standard Quantity 156,800 58,800 0.333333333 8.00 Blibb 0.666666667 6.00 235,200 58.800 392,000 4.50 111,600 Blobb 69,440 0.3571 69.440 0.6429 5.00 223,200 334,800 Actual Quantity Standard Mix Standard Price E 8.00 154,667 B Blib 58,000 0.333333333 11 58,000 0.666666667 6.00 232,000 386,667 112,500 Blobb 70,000 0.36 4.50 70,000 0.64 5.00 225,000 337,500 Actual Quantity Actual Mix Standard Price C Blibb 58,000 0.310 8.00 144,000 58,000 0.690 6.00 240,000 384,000 Blobb 70,000 0.271 4.50 85,500 70,000 0.729 5.00 255,000 340,500 Actual Quantity Actual Mix Actual Price E D Blibb 58,000 0.310 7.80 140,400 2 2 58,000 0.690 6.20 248,000 388,400 Blobb 70,000 0.271 4.45 84,550 2 X 70,000 0.729 5.60 285,600 370,150 Variances Yield A-B Blibb 392,000 386,667 5,333 F Blobb 334,800 337,500 -2,700 A Mix B-C Blibb 386,667 384,000 2,667 F Blobb 337,500 340,500 -3,000 A Usage A-C Blibb 392,000 384,000 8,000 F Blobb 334,800 340,500 5,700 A Price C-D Blibb 384,000 388,400 Blobb 4,400 A 340,500 370,150 29,650 A Total A-D Blibb 392,000 388,400 Blobb 3,600 F 334,800 370,150 -35,350 A -31,750 A Question Flexed budoA Wrap Text Calibri (Body) = Merge & Centre Paste U x Update Available We've made some fixes and improvements. To complete the process, the app needs to res 128 X V KLM O Z I LL ABC D m Sales Variances Standard Profit E Standard Quantity Standard Mix 22,000 0.454545455 60.00 600,000 A Blibb 70.00 840,000 Blob 22,000 0.545454545 1,440,000 Actual Quantity Standard Mix Standard Profit B Blibb 22,200 0.454545455 60.00 605,455 Blobb 22,200 0.545454545 70.00 847,636 1,453,091 Actual Quantity Actual Mix Standard Profit C Blibb 22,200 0.44 60.00 588,000 Blobb 22,200 0.56 70.00 868,000 1,456,000 Actual Quantity Actual Mix Actual Profit E D Blibb 22,200 0.44 54.00 529,200 Blobb 22,200 0.56 85.00 28 1,054,000 29 1,583,200 30 Variances Volume A-B 1,440,000 Mix 1,453,091 B-C 1,453,091 1,456,000 Price C-D 1,456,000 2,909 F 1,583,200 127,200 F Total A-D 1,440,000 1,583,200 143,200 F 4 Question Flexed budget Sales Contribution Materials Select destination and press ENTER or choose Paste Labour Fixed OHOFF AC Y . DAP .. Copy of Blibb_Blobb_Assessment_22_Temp Insert Draw Page Layout Formulas Data Review View Automate ? Tell me Calibri (Body) A ab Wrap Text v General I U A Merge & Centre v e Available We've made some fixes and improvements. To complete the process, the app needs to restart. X LL I I J K our Variances Standard Hours Standard Rate 32,003 f16 512,048 Actual Production Hours Standard Rate * 58,520 E16 936,320 Actual Production Hours + Idle Time Standard Rate H U 58,660 16.00 938,560 Actual Hours Standard Rate 59,000 16.00 944,000 Actual Hours Actual Rate WU 59,000 f16.25 958,750 Variances Efficiency A-B 512,048 936,320 424,272 A 11 Idle Time B-C 936,320 938,560 -2,240 A Overtime C-D 938,560 944,000 -5,440 A Rate D-E 944,000 958,750 -14,750 A Cost A-E 512,048 958,750 -446,702 A Question Flexed budget Sales Contribution Materials Labour Fixed OH Recon ect destination and press ENTER or choose Paste