B.1. You were asked to formulate the LP model for Mayas problem and solve it by using Excels Solver. Report the model and the optimal solution to Maya in plain English. She has asked you to be precise and concise. (10 marks)

MaxFuel Refinery produces one fuel by combining three raw materials, R1, R2, and R3. The raw materials have different cost. The costs are presented in the table below, together with the quantities of chemicals (Chemical A, B, C, and D) that is contained in each millilitres (ml) of the raw material. Maya is the production manager of MaxFuel Refinery and knows the market's requirement for each chemical. Each ml of fuel should contain at least 24 ml of Chemical A, 16 ml of Chemical B, 8 ml of Chemical C, and 3.4 ml of Chemical D. Maya wants to know how to combine the three types of raw stocks so that the total cost of each ml of the fuel is minimised. Chemical A Chemical B Chemical C Chemical D Cost per ml of raw material ($) R1 22 16 8 5 33 R2 28 14 7 0 47 R3 21 25 9 6 38 Market's requirement 24 16 8 3.4