4.7 Extension 6: Order Compartment Restrictions

Accompanying Workbook: olm_extension_6.xlsx

You may want to prevent an order from being assigned to a specific compartment. This might be due to physical restrictions or safety considerations at the delivery site. We refer to such compartments as being forbidden for the order in question.

Let’s take the scenario from Extension 5, but this time will forbid Order 1 from being assigned to Compartment 2.

To do this, add the Forbidden Compartments sheet shown in Table 9.

Order Compartment
Order 1 Compartment 2
Table 9: Extension 6 forbidden compartments.

Figure 25 shows the assignments that result when this new scenario is run. When compared with the original scenario’s assignments (Figure 24), you can see that the solution has changed to avoid violating the forbidden compartment constraint.

PIC

Figure 25: Extension 6 solution compartment.