Answered step by step
Verified Expert Solution
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 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...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