Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A gas distributor wants to plan the delivery of three main products (premium gasoline, an intermediate octane grade and regular gasoline) to one of

A gas distributor wants to plan the delivery of three main products (premium gasoline, an intermediate octane (a) (15 points) Develop an integer programming formulation to maximize the amount of fuel loaded on the 

A gas distributor wants to plan the delivery of three main products (premium gasoline, an intermediate octane grade and regular gasoline) to one of its customers. This customer requires the following amounts for each type: At least At most Premium 8800 13200 Liters of Intermediate 12000 17200 Regular 12800 16400 The amount delivered cannot be smaller than the minimum amount and cannot be greater than the maximum amount given in the table for each type of gasoline. A delivery tank truck is used to perform the delivery. It has four compartments with capacities in liters of 14000, 12200, 10800, and 4400. Only one gasoline type can be stored in a compartment in the delivery vehicle. (a) (15 points) Develop an integer programming formulation to maximize the amount of fuel loaded on the truck. Define your decision variables clearly. (b) (10 points) Solve the model you developed in part (a) using OpenSolver and report the optimal solution. Upload the excel file as well when uploading your solutions. (Hint: Optimal objective function value is 41,400)

Step by Step Solution

3.47 Rating (154 Votes )

There are 3 Steps involved in it

Step: 1

Here are the stepbystep calculations 1 List the minimum and maximum amounts required for each gasoli... 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

Financial Accounting and Reporting a Global Perspective

Authors: Michel Lebas, Herve Stolowy, Yuan Ding

4th edition

978-1408066621, 1408066629, 1408076861, 978-1408076866

More Books

Students also viewed these Finance questions

Question

=+What are the outcomes?

Answered: 1 week ago