Question: (a). Formulate an algebraic model for the problem. If you wish to solve the models in Excel Solver, you will have to write them in

(a). Formulate an algebraic model for the problem. If you wish to 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. Submit the algebraic model in the single Word or pdf file. (b) Use LINGO or the Excel Solver to solve this model. Imbed the LINGO model and solution report files, or tabs of the model and Answer Report from the Excel f ile, into the single Word or pdf submission file. (c). State the solution in words. Submit this in the single Word or pdf submission document.
1. A company blends two gasolines from High-Quality Fuels and Junk Petroleum (inputs) into two commercial products, Super and Regular gasoline (outputs). For the inputs, the octane ratings, the lead content in grams per litre, and the amounts available in cubic metres (m3) and their prices are known. These are: For the Super and Regular gasolines the requirements are: We define the variables as follows: H and J are respectively the amount of gasoline in m3 purchased from High-Quality Fuels/Junk Petroleum. S and R are respectively the amount of Super/Regular gasoline in m3 blended and sold. HS, HR, JS, and JR are respectively the amounts in m3 of High-Quality/Junk gasoline used to make Super/Regular gasoline. For this and each of the other four questions which follow, make sure that you answer parts (a), (b), and (c) as given at the bottom of the previous pageStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
