Question: a) Formulate a model for this problem, taking care to define each of the variables used. (b) Solve the model using Excel. (c) State the
a) Formulate a model for this problem, taking care to define each of the variables used.
(b) Solve the model using Excel.
(c) State the recommendation.

An gasoline blending operation has three types of inputs, with the following prices and characteristics: The inputs are blended to produce two outputs, with the following outputs and promised specifications: The blending operation has a capacity of 1,000,000 litres/day overall. Subject to the overall capacity, up to 500,000 litres/day of any input, or 650,000 litres/day of any output can be handled. We can assume that there are no losses in the blending process, and that the characteristics of the outputs are a weighted average (by volume) of the characteristics of the inputs
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
