A gas distributor wants to plan the delivery of three main products (premium gasoline, an intermediate...

  

Transcribed Image Text:

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) 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)

Answer rating: 100% (QA)

Here are the stepbystep calculations 1 List the minimum and maximum amounts required for each gasoli... View the full answer