Hi, Can you please help me with question 3? All necessary documentation follows:

change in gross margin overall unit cost changes in direct ingredients changes in direct labour in relation to sales dollars A full variance analysis is not expected or required. Brief numerical summaries are encouraged to highlight changes. 3. Manufacturing overhead costs analysis (13 marks) a) Plant utilities cost analysis (3 marks) Prepare an analysis of utilities costs using the data provided in Exhibit 5. Using the high-low method, determine how much of the monthly utilities costs for the year are fixed versus variable. Your answer should consist of a cost formula. Determine the accuracy of this formula by applying it to the total machine hours in the 20X7 data from Exhibit 5 and comparing the result to the actual utilities cost. Consider that a discrepancy of 3% on this cost estimation is acceptable to management. (Note: Round the final fixed cost answer to the nearest dollar, however, do not round the variable cost figure when calculating total costs.) b) Capacity analysis i) (4 marks) Prepare an analysis that highlights idle capacity costs by analyzing 20X7 total manufacturing overhead costs (Exhibit 4), similar to the approach in Topic 2.3-10. Practical capacity is 12,000 direct labour hours (Note: Round the manufacturing overhead costs to the nearest dollar, however, do not round the MPH rate calculated when calculating the total costs.) ii) (4 marks) Explain the purpose of this analysis to management and the information it provides in relation to capacity utilization. c) Based on the results of requirements 1, 2, and 3 above, briefly comment on the manufacturing costs. (2 marks) 4. Dashboard presentation of break-even options and analysis. (6 marks) Prepare a presentation and analysis of the relationship between selling price and break-even units for The-Bar based on information provided in Exhibit 9. The purpose of the presentation is to assist the management team with cost and selling price planning for 20X8. The presentation will consist of a Power BI dashboard. The appendix at the end of this project provides instructions on how to find the data and create the dashboard using Power BI. The analysis should address the following: a) Using the 20X8 budget data provided, create a Power BI dashboard similar to the one in the appendix to this project. Based on the dashboard created, prepare an analysis that addresses the following questions: i) What is the break-even in batches?Exhibit 4 Other budgeted and actual schedules are provided below to help with the analysis. Actual quantity and cost of direct ingredients For the year ended December 31, 20X7 Ingredient Price The-Bar Alamonde Salt-Lick Total Quantity Cost Quantity Cost Quantity Cost Quantity Cost Chocolate liquor $5.55/kg 27.160 5150.738 18,480 $102,564 8.894 $40.350 54 534 5302.661 Cocoa butter $8.10/kg 10,321 82.057 7,022 42.837 2 753 16,702 20.086 122.586 Cocoa powder $1.18/kg 5.432 8.410 2.218 2.817 2 118 2,409 2.788 11.525 Cane sugar 50.70/kg 10,321 7.225 7,022 4,916 8.247 4,372 23,500 18.513 Emulsifier 50.80/kg 482 369 730 590 212 169 1,413 1.129 Vanilla $70/litre 825 43.728 370 25,872 424 20,645 1,418 99.245 Almonds $10/kg 1,109 11.088 1,108 11.088 Himalayan salt $5.50/kg 529 2.012 520 2.912 Cost of ingredients $271,427 $190,484 $105,748 $567.659 Wrappers $0.08/bar 776,000 82,080 528,000 42.240 302,500 24,200 1,606,500 128,520 Total cost $333.507 $232.724 $129,948 $696.179 Budgeted quantity and cost of direct ingredients For the year ended December 31, 20X7 Ingredient Price The-Bar Alamonde Salt-Lick Total Quantity Cost Quantity Cost Quantity Cost Quantity Cost Chocolate liquor $5.50/kg 27,104 $149.072 18,510 $101,852 3.861 $48.736 54.484 $299 660 Cocoa butter $6.00/kg 10,300 81.797 7,037 42,222 2.743 16,456 20,079 120.478 Cocoa powder $1.15/kg 5,421 8.234 2.222 2.556 2.110 2.426 0,753 11.216 Cane sugar 50.70/kg 10,300 7 210 7,037 4.926 3 224 4.357 23,560 18 492 Emulsifier $0.80/kg 481 369 741 503 211 169 1,412 1.130 Vanilla $70/litre 325 43,637 370 25,926 424 20.537 1,418 99.101 Almonds $10/kg 1.109 11.111 1.109 11.111 Himalayan salt $5.50/kg 529 2,201 520 2 901 Cost of ingredients $268.319 $189,186 $104,582 $562.087 Wrappers $0 08/bar 776,000 81.952 528,000 42,328 302 500 24.112 1,808,500 128.302 Total cost $330,271 $231.514 $128,694 $690.479 Actual direct labour For the year ended December 31, 20X7 The-Bar Alamonde Salt-Lick Total Direct labour hours 4,105 3,744 2,125 9,974 Cost per direct labour hour 33.10 33.10 33.10 33.10 Total actual direct labour costs $ 135,876 $ 123,926 $ 70,338 $ 330,140Budgeted direct labour For the year ended December 31, 20X7 The-Bar Alamonde Salt-Lick Total Direct labour hours 4,560 3,140 1,790 9,490 Cost per labour hour 32.40 32.40 $ 32.40 S 32.40 Total budgeted direct labour cost $ 147,744 $ 101,736 $ 57,996 $ 307,476 Actual manufacturing overhead For the year ended December 31, 20X7 Variable Plant utilities 103,584 Plant maintenance 89.566 $ 193,150 Fixed Quality control 37,500 Computer and supplies 188,000 Plant and equipment amortization 150,000 Research and development 135,000 Indirect plant salary and wages 193,000 Plant lease 196.000 899.500 Total manufacturing overhead $ 1,092,650 Budgeted manufacturing overhead For the year ended December 31, 20X7 Variable Plant utilities 101,876 Plant maintenance 91,081 $ 192,957 Fixed Quality control S 39,000 Computer and supplies 189,000 Plant and equipment amortization 150,000 Research and development 120,000 Indirect plant salary and wages 192,500 Plant lease 196.000 886.500 Total manufacturing overhead $ 1,079,457 Predetermined overhead rate = $1,079,457/9,490 direct labour hours = $113.74678 per direct labour hour One of the cost issues faced by the company is understanding what the variable costs are and what the fixed costs are. The manufacturing overhead schedule shows plant utilities as a purely variable cost yet even with no machinery running, the company gets a bill. So, a study was conducted on the plant utilities costs compared to direct machine hours. The information is provided below.Exhibit 5 Utilities costs and machine hour data The following are 23 months of data relating to monthly utilities costs and number of machine hours. Month Plant utilities Machine hours February 20X6 $ 8,674 650 March 20X6 8,500 625 April 20X6 8,750 629 May 20X6 9,483 745 June 20X6 9,497 664 July 20X6 9,611 748 August 20X6 8,687 653 September 20X6 8,338 656 October 20X6 8,703 699 November 20X6 8,931 701 December 20X6 7,870 610 January 20X7 7,328 571 February 20X7 8,084 620 March 20X7 8,506 665 April 20X7 8,591 662 May 20X7 9,516 749 June 20X7 9,431 656 July 20X7 9,608 761 August 20X7 8,674 656 September 20X7 8,421 667 October 20X7 8,674 690 November 20X7 8,843 671 December 20X7 7,908 621 Total $ 200.628 15.369