Instructions In Assignment 1. you needed to solve Question 5 using both LINGO and the Excel Solver. In Assignments 2 to 6 inclusive, you will be asked only to use either LINGO or the Excel Solver. Based on your experience with Assignment 1, Question 5, do whichever you find easier. If you solve the models in Excel Solver, you will have to write them in standard form, i.e. all variables on the left-hand side, and a number of the right-hand side. If you use LINGO, you are not bound by this restriction. For each question, do the following: (a) Formulate an algebraic model for the problem. Submit this in Word or pdf. (b) Use LINGO or the Excel Solver to solve this model, including your name and student number on the model. If using LINGO, submit files for the model and the solution for each question. If using the Excel Solver, submit one file for all questions, using tabs for the model and the Answer Report (a total of ten tabs.) (c) State the solution in words. Submit this in Word or pdf. When you attempt to solve these models, you might receive a message about the solution being infeasible. While this is a theoretical possibility, it won't happen for any of these questions. It means that a mistake has been made in formulating the model. Each question is worth 20 marks. 1. A company blends two gasolines from Avalon Energy and Bonavista Petroleum (in- puts) into two commercial products, Premium and Regular gasoline (outputs). For the inputs, the octane ratings, the vapour pressures in kilopascals, and the amounts available in cubic metres (m) and their prices are known. These are: Input Octane Vapour Amount Gasoline Rating Pressure (kPa) Available (m) Avalon 105 35 25,000 Bonavista 82 66 38.000 Buying Price ($ per m) 310 240 For the Premium and Regular gasolines the requirements are: Output Gasoline Minimum Octane Rating 95 87 Maximum Minimum Selling Vapour Amount Price Pressure (kPa) Required (m) ($ per m) 43 19.000 350 58 27,000 290 Premium Regular We define the variables as follows: A and B are respectively the amount of gasoline in m purchased from Avalon Energy/Bonavista Petroleum. P and R are respec- tively the amount of Premium/Regular gasoline in m blended and sold. AP, AR, BP, and BR are respectively the amounts in m of Avalon/Bonavista gasoline used to make Premium/Regular gasoline. Please use lingo Instructions In Assignment 1. you needed to solve Question 5 using both LINGO and the Excel Solver. In Assignments 2 to 6 inclusive, you will be asked only to use either LINGO or the Excel Solver. Based on your experience with Assignment 1, Question 5, do whichever you find easier. If you solve the models in Excel Solver, you will have to write them in standard form, i.e. all variables on the left-hand side, and a number of the right-hand side. If you use LINGO, you are not bound by this restriction. For each question, do the following: (a) Formulate an algebraic model for the problem. Submit this in Word or pdf. (b) Use LINGO or the Excel Solver to solve this model, including your name and student number on the model. If using LINGO, submit files for the model and the solution for each question. If using the Excel Solver, submit one file for all questions, using tabs for the model and the Answer Report (a total of ten tabs.) (c) State the solution in words. Submit this in Word or pdf. When you attempt to solve these models, you might receive a message about the solution being infeasible. While this is a theoretical possibility, it won't happen for any of these questions. It means that a mistake has been made in formulating the model. Each question is worth 20 marks. 1. A company blends two gasolines from Avalon Energy and Bonavista Petroleum (in- puts) into two commercial products, Premium and Regular gasoline (outputs). For the inputs, the octane ratings, the vapour pressures in kilopascals, and the amounts available in cubic metres (m) and their prices are known. These are: Input Octane Vapour Amount Gasoline Rating Pressure (kPa) Available (m) Avalon 105 35 25,000 Bonavista 82 66 38.000 Buying Price ($ per m) 310 240 For the Premium and Regular gasolines the requirements are: Output Gasoline Minimum Octane Rating 95 87 Maximum Minimum Selling Vapour Amount Price Pressure (kPa) Required (m) ($ per m) 43 19.000 350 58 27,000 290 Premium Regular We define the variables as follows: A and B are respectively the amount of gasoline in m purchased from Avalon Energy/Bonavista Petroleum. P and R are respec- tively the amount of Premium/Regular gasoline in m blended and sold. AP, AR, BP, and BR are respectively the amounts in m of Avalon/Bonavista gasoline used to make Premium/Regular gasoline. Please use lingo
