Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Each question in Assignment 2 is worth 20 marks. For each question, do the following: (a) Formulate a model for the problem either in LINGO

image text in transcribed
image text in transcribed
Each question in Assignment 2 is worth 20 marks. For each question, do the following: (a) Formulate a model for the problem either in LINGO syntax or an Excel file.' For each model: (i) Write your name and student number. (ii) Write the definitions of all the variables. (This is the same as what was given for Q1; make your own variable definitions for the other questions.) (iii) Write the objective function. (iv) Write the constraints with comments to explain their purpose. 2 (v) The non-negativity restrictions are to be omitted. 3 (vi) LINGO only: Every variable which must be integer must be so declared using an @GIN command. This is followed by an END command. Copy-and-paste the LINGO file into the Word or pdf submission document. (vii) Excel only: The Solver Parameters box must be filled in, including an int declaration for each integer variable. Copy-and-paste the Excel file into the Word or pdf submission document, and include a screenshot of the Solver Parameters box into this document. (b) Solve the model, and copy-and-paste either the LINGO solution file or the Excel Solver Answer Report into the Word or pdf submission document. (c) State the solution in words in the Word or pdf submission document. 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 would mean that a mistake has been made in formulating the model. 1. A company blends two gasolines from Avalon Energy and Bonavista Petroleum (inputs) 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 (m3) and their prices are known. These are: For the Premium and Regular gasolines the requirements are: We define the variables as follows: A and B are respectively the amount of gasoline in m3 purchased from Avalon Energy/Bonavista Petroleum. P and R are respectively the amount of Premium/Regular gasoline in m3 blended and sold. AP, AR, BP, and BR are respectively the amount in m3 of Avalon/Bonavista gasoline used to make Premium/Regular gasoline. For this and the next four questions, follow instructions (a), (b) and (c) on page 2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essential Wholesaling Strategies For Real Estate Success

Authors: Farisg H. Al-farisi

1st Edition

979-8866103171

More Books

Students also viewed these Finance questions

Question

Account for scrap

Answered: 1 week ago