please answer this question and thank you for your help

1. [S marks] Continuing the story set up in A3 Q4, to complete his weekly body-building diet at the lowest possible cost, Husky Harry must choose from among three speciality food supplements: Power Potion (PP), Musilmix (MM), and Bulk Broth (BB). The following table gives the units of protein, carbohydrates, and fat per litre of each supplement, along with their costs. Harry requires at least 200 units of protein and 300 units of carbohydrates per week, but no more than 50 units of fat. Harry's Dietary Supplement pp MM BB Protein 30 45 200 Carbohydrates 40 30 150 Fat 4 8 40 Cost/Litre $4.50 $6.00 $15.00 The formulation of this problem to decide on the amount of each supplement to achieve his goal is: Let P be the number of litres of Power Potion, M be the number of litres of Musilmix B be the number of litres of Bulk Broth per week Minimize C = 4.50 P+ 6 M + 15 B Subject to 30 P + 45 M + 200 B 2 200 Units of Protein 40 P + 30 M + 150 B 2 300 Units of Carbohydrates 4P + 8M+ 40 B 50 Units of Fat P20, M20, B20 Questions follow:a. [6] Set up the LP model in Excel and solve, using Solver. As your answer, screen-capture: a) the model; b) the answer report; and c) the sensitivity report. (Please do NOT capture your entire screen, just the section with data. Ensure that the information is readable.) b. [2] According to your optimal solution, how many litres of each food supplement should Harry choose weekly? What is the minimum cost