Question 2 (30 marks): The following flow diagram represents a part of methanol production process, it is produced by the reaction of synthesis gas (CO and H2) at 200300 C and 3.5-10 MPa according to the following reaction: CO+2H2CH3OH Stream 1 is a fresh feed to the reactor, with a total flow rate of 1000mol/hr containing 34% CO,65%H2 and 1%CH4 (all in mole % ). This stream is introduced to the reactor where catalytic reaction happens according to Equation (1), with only 45% conversion of CO. The product Stream 2 is then fed to a separator where methanol is separated from the unreacted reactants. The bottom product stream (Stream 4 ) contains 1.5\% CO, 2%H2,0.5%CH4 and 96% methanol (all in mole \%). ENG1083: Transferable Skills - Excel Coursework Semester 2/Academic Year 2022-2023 Please solve this system to get: - The total flow rates of Stream 2, Stream 3, and Stream 4. [20 marks] - The molar fractions of all the components in Stream 2, and Stream 3. [20 marks] Note that you should solve this question using the solver function. Question 3 (30 marks): A pharmaceutical company manufactures two products x1 and x2 for which it needs 3 different types of raw materials A, B and C. The quantities of raw materials are limited in unit time and the prices of the products are different ( $4 per unit of x1 and $3 per unit of x2 ): Questions: - How many of product of x1 and x2 to produce in order to maximise revenue (income) assuming that every unit is sold at given price? [15 marks] - How much of raw material will remain? [15 marks] Question 2 (30 marks): The following flow diagram represents a part of methanol production process, it is produced by the reaction of synthesis gas (CO and H2) at 200300 C and 3.5-10 MPa according to the following reaction: CO+2H2CH3OH Stream 1 is a fresh feed to the reactor, with a total flow rate of 1000mol/hr containing 34% CO,65%H2 and 1%CH4 (all in mole % ). This stream is introduced to the reactor where catalytic reaction happens according to Equation (1), with only 45% conversion of CO. The product Stream 2 is then fed to a separator where methanol is separated from the unreacted reactants. The bottom product stream (Stream 4 ) contains 1.5\% CO, 2%H2,0.5%CH4 and 96% methanol (all in mole \%). ENG1083: Transferable Skills - Excel Coursework Semester 2/Academic Year 2022-2023 Please solve this system to get: - The total flow rates of Stream 2, Stream 3, and Stream 4. [20 marks] - The molar fractions of all the components in Stream 2, and Stream 3. [20 marks] Note that you should solve this question using the solver function. Question 3 (30 marks): A pharmaceutical company manufactures two products x1 and x2 for which it needs 3 different types of raw materials A, B and C. The quantities of raw materials are limited in unit time and the prices of the products are different ( $4 per unit of x1 and $3 per unit of x2 ): Questions: - How many of product of x1 and x2 to produce in order to maximise revenue (income) assuming that every unit is sold at given price? [15 marks] - How much of raw material will remain? [15 marks]