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 |
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.

