Β
This guide walks you through the Strategic Network Design certification exam. By following the steps below, youβll understand the logic behind each scenario and verify your answers with the correct results.
ποΈ Step 1: Understand the Template
Before starting, make sure your template matches the exam setup. (Template attached)
β οΈ Warning: Even a small mismatch (e.g., number of warehouses, suppliers, or constraints) will lead to incorrect results later.
1οΈβ£ Current Network Analysis
β Question
How does the current network look when we take into account the use of all the 6 warehouses and 5 suppliers?
π§ How to approach it
-
Enforce the constraint of minimum 6 warehouses and minimum 5 suppliers.
-
Solve the model.
β Expected Answers
-
Total cost β 14,451,218
-
Largest throughput warehouse β Toulouse
-
Largest supplier β Budapest
2οΈβ£ Demand Increase in Spain
π Scenario
A new retailer in Spain increases demand by 15% for Barcelona and Madrid.
π§ How to approach it
-
Go to the Customer Data section.
-
Adjust demand for Barcelona and Madrid using the widget.
-
Solve the model again.
β Expected Answers
-
Total cost β 14,858,057
-
Total demand β 48,259
π‘ Tip: Always double-check that demand changes are saved before solving.
3οΈβ£ Optimal Number of Warehouses
ποΈ Scenario
The VP wants to know if itβs optimal to actually use all 6 warehouses, or if demand can be fulfilled with fewer.
π§ How to approach it
-
Relax the Minimum Number of Warehouses constraint in the Control Panel.
-
Allow the solver to choose from 1 to 6 warehouses.
β Expected Answers
-
Optimal number of warehouses β 4
-
Total cost β 14,743,277
-
Warehouse at maximum capacity β Hannover
4οΈβ£ Expanding Warehouse Capacities
π¦ Scenario
The VP is interested in expanding warehouse capacities to check if a more optimal network can be achieved.
π§ How to approach it
-
Relax the Maximum Warehouse Capacity constraint.
-
Keep relaxing the Minimum Number of Warehouses constraint.
β Expected Answers
-
Total cost β 14,673,324
-
Optimal number of warehouses β 3
-
Warehouses needing expansion β Hannover & Toulouse
π‘ Tip: Red-highlighted warehouses in the results indicate where capacity is exceeded.
5οΈβ£ Naples Supplier Closing
π« Scenario
The Naples supplier will not renew their contract.
π§ How to approach it
-
In the Data section, force close the Naples supplier.
-
In the Control Panel, reduce the Minimum Number of Suppliers from 5 β 4.
β Expected Answers
-
Is it possible to fulfill demand? β Yes
-
Total cost β 15,217,074
β οΈ Warning: If you donβt reduce the supplier requirement, the model will be infeasible.
π― Final Notes
By carefully following these steps, you can ensure that your answers match the expected exam results. Always:
-
Double-check constraints before solving.
-
Verify that your template matches the one provided.
-
Interpret results not just as numbers, but also in terms of business impact.