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 |
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 |
Re-running the optimiser with this new product and order produces the assignments seen in Figure 20.

