Model 4: Blending

Process Requirements per Unit Time Output per Unit Time
Raw Material 1 (units) Raw Material 2 (units) Fuel (units) Chemical 1 (units) Chemical 2 (units)
1 9 5 50 9 6
2 6 8 75 12 4
3 4 11 100 10 6
Amount
available
200 400 1850

A company makes a blend consisting of two chemicals, 1 and 2, in the ratio 5:2 by weight. These chemicals can be manufactured by three different processes using two different raw materials and a fuel. Production data are given in the table at the top. For how much time should each process be run in order to maximize the total amount of blend manufactured?


Excel Spreadsheet