Many logistic service providers such as harbor operators see increasing demand but cannot easily increase their infrastructure such as the number of berths in a harbor. The intuitive solution is to optimize productivity and utilization of what you already have. That is where optimization kicks in.
Luckily this is one of the tasks that can be done quite well with the integrated SAP HANA features for optimization. My name is dr..marcus.dettenbach and I am a Data Scientist at SAP. This blog is about a solution we built to tackle the problem I just lined out.
Do more with less – Berth Planning is one of the classical optimization problems of matching demand and supply in an optimal way. Demand in our case are vessels that require a berth position for loading and unloading. Supply is the harbor's infrastructure such as berths, cranes, pumps etc. The objective is to pack vessels as tight as possible in the time and space dimension and to maximize productivity of loading and unloading. Of course there are quite a number of constraints to consider. These constraints include minimal spatial and time distance between vessels, draught of a vessel, handling of dangerous goods, special equipment for loading or unloading, timing constraints etc. The figure below illustrates the problem.
If the description of the current problem gives you a tingling sensation in the back of your mind, then it’s probably the reminder of the operations research course you once took at university or the linear programming lecture you attended. Right, this is the time this becomes quite useful since the problem can be modeled as a so called set partitioning problem.
In order to solve it, we use the SAP HANA Optimization Function Library (OFL). Similar to the SAP HANA Predictive Analytics Library (PAL) the OFL is an SAP HANA Application Function Library and comes with every SAP HANA installation. The OFL provides functions to solve various optimization problems including the Set Partitioning Problem. Being one of the lesser known features of SAP HANA it provides access to an open-source solver called SCIP. While other (commercial) solvers can also be used by OFL, we found that for many problem sizes in berth planning SCIP solved most problems in reasonable time. Only to stress this point a little bit more: In most projects or product development it is highly appreciated that SCIP comes for free with every SAP HANA installation whereas commercial solvers usually have a pretty decent price tag attached.
With the 2021 release of SAP Yard Logistics berth planning became an integral part of the product. SAP Yard Logistics has always integrated end-to-end yard logistics management. With berth planning, a new feature was added to allow for optimal berth allocation. The resulting berth plan is graphically visualized and fully integrated into the overall solution.
If you are interested in using tools like OFL with SCIP in your own products or have any questions around optimization problems in general, please feel free to contact dr..marcus.dettenbach or engage in the comment section below.
For the readers interested in other use cases of applied optimization at SAP these blog posts offer more on this topic:
SAP optimizes call center workforce to make customers and staff happy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
10 | |
10 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 |