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.

a) Formulate a model for this problem, taking care to define each

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!