A The following budgeted price and cost information is available for 2022: Selling price Body Butter $ Hand Cream Lip Butter 16.00 $ 12.00 $ 7.50 Costs: Beeswax 2.00 1.50 0.50 Other natural seed/plant oil 1.50 1.25 0.25 Natural flavour 0.75 0.68 0.32 Labour costs 2.84 1.67 0.36 Manufacturing overhead costs (Note 1) 3.00 2.00 1.00 Selling and admin costs (Note 2) 2.46 1.80 1.20 12.55 8.90 3.63 Margin $ 3.45 $ 3.10 $ 3.87 Note 1: Manufacturing overhead is allocated at $8.00/machine hour. 40% of the manufacturing overhead costs are considered variable. Note 2: 10% of the selling and admin costs are variable. The remaining is fixed. Monthly demand information is as follows: Max Demand Min Demand Body Butter Hand Cream Up Butter 5,000 2,000 1,500 3,000 The monthly machine hour capacity is limited to 1,800 hours. Question 1: Prepare a product mix analysis. Determine the ranking of the products in order of their contribution margin per constrained resource. (10 marks) Question 2: Using the linear programming model under Solver, compute the optimal number of each product to make and sell monthly to maximize the profit. (Include a screenshot of your LP models and results). Interpret the Answer Report and Sensitivity Report. What are the binding constraints? If the company can acquire more machine hours, comment on what price the company would be willing to pay with your rationale. (20 marks)