Phase 2. Add Operating Hours for Customers

In the previous phase we imported the scenario, ran the Capacitated TO experiment, and observed results. In this phase we will add operating hours for our customers (limiting the possible delivery period) and compare the results. 

We will assume that the Lidl stores can accept deliveries from 6 a.m. to 9 a.m., which means that the Gabrovo DC is supposed to visit all customers within this time period.

Add operating hours

  1. Click Data to open the scenario input data.

  2. Click All to see the full list of tables, then open the Operation Hours table.


  3. Click Add to create a new record.

  4. Leave the default value of the Facility column, allows us to define operating hours for all customers.
  5. Click the Start Time cell and set the time to 6:00 AM by either using the arrows on the right side or typing 6

  6. In the same way define the end time in the End Time column:

  7. The Operation column defines if the specified Facility is supposed to receive (in case of a customer) or ship (in case of a site) the order. We will leave the default value of the column, since it defines the working hours for the customers. 

Now we will set up the CTO experiment and run it. The experiment will consider the operating hours, which will affect the routes.

Set up the experiment and run it

  1. Navigate to the experiment's properties, by clicking Capacitated TO experiment in the experiment's section.
  2. Enable the Use time windows option by clicking the toggle button. This will make the experiment consider the data from the Operating Hours table.

  3. Click  Run to run the experiment.

When the experiment is completed, proceed to analyze its results.

Observe the received results

  1. Navigate to the Optimization results tab below the experiment view. This time the result contains 32 routes for 2 shipments. 
  2. Type Lovech in the filter field of the Destination column to see the list of routes in which it is used.
    As you can see, there are two routes, one per shipment. The date of the shipment is specified in the Aggregation period column.

  3. Click the first record to have it displayed on the map. 
    The new route comprises three destinations (Lovech, Pleven, Gabrovo), while the previous result comprised 4 destinations (see the screenshot below).

  4. Switch to the Generated Paths tab, group data per Shipment, then click the Add to comparison button to add this element to the comparison dashboard and name it Result 2. We will get back to it later.

  5. Finally switch to the Generated Path Segments tab and group data per Shipment. This table contains details on each segment of every route. We are mostly interested in the data from the following columns:

  6. Scroll down until you see the Lovech customer in the Destination column.
    Let us have a closer look at this route (see screenshot below):

Now we will compare the previous result with the current result.

Compare results

  1. Navigate to the comparison dashboard by clicking Comparison below the result tabs.

  2. Compare transportation costs in the Cost, USD column, and the number of routes in the Destinations column.
    As you can see, the number of routes has increased as well as the transportation costs. Overall the supply chain has become more expensive, but the good part is that we managed to visit all customers within the customer's operating hours.

We have completed the second phase of this tutorial. We added operating hours for our customers, ran the experiment and compared the received results.

  Phase 1. Import scenario and run the experimentPhase 3. Add operating hours for DC