4.3 Extension 2: Multiple Products

Accompanying Workbook: olm_extension_2.xlsx

As Opturion Fuel continue to expand they begin to deliver products other than ULP.

The planner modifies the Products sheet to include the additional information, as seen in Table 2.

Id Density
ULP 0.74
Diesel 0.85
Table 2: Extension 2 products.

The Orders sheet is also updated to add an additional order (“Order 2”) with a “Diesel” product type. This can be seen in Table 3.

Id Site Product Target Volume Maximum Volume Minimum Compartment Volume
Order 1 Site 1 ULP 26,550 35,000 3,600
Order 2 Site 1 Diesel 10,000 11,000 3,600
Table 3: Extension 2 orders.

Re-running the optimiser with this new product and order produces the assignments seen in Figure 20.

PIC

Figure 20: Extension 2 solution compartments.