Question
Kindly I need to solve the below in excel (by solver ) I found the answer on the book however Im stell can not under
Kindly I need to solve the below in excel (by solver ) I found the answer on the book however Im stell can not under stand the question nor do it in excel
Oilco produces three types of gasoline: regular, unleaded, and premium. All three are produced by combining lead and crude oil brought in from Alaska and Texas. The requiredsulphur content, octane levels, minimum daily demand (in gallons), and sales price pergallon of each type of gasoline are given in Table 3. The crude brought in from Alaska is made by blending two types of crude: Alaska1 and Alaska2. The Alaska crude is blended in Alaska and shipped via pipeline to Oilco's Texas refinery. At most, 10,000 gallons of crude per day can be shipped from Alaska. The sulphur content, octane level, daily maximum amount available (in gallons) and purchase cost (per gallon) for each type of Alaska crude, Texas crude, and lead are given in Table 4. Of course, unleaded gasoline can contain no lead. Formulate a model to help Oilco maximize the daily profit obtained from selling gasoline (The question is taken from: Wayne Winston, Operations Research : Algorithms and Applications 4th edition. Please feel free to find it and use the book information for your answer).
a)What kind of question is this (linear programming, transportation, assignment, nonlinear, regression?) Why? Please provide proof for your answer.
b)Please verbally define your objective function; decision variables, and constraints.
c)Create the model
d)Solve the model in Solver
e)Please put screen shots of Excel Model and Solver and interpret the results
Answer
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started