Using multi-stop estimation

Multi-stop estimation costs are generated when you run Network Optimization and have turned on the "Run Multi-Stop Estimation With NO" switch in Network Optimization Options.

The matrix has two bands: one for distance and one for drop size, based on the Multi-Stop Estimation Options. Demand for the Mode, Transport Region, Product and Period is pulled from the Customer Demand table. Breakpoints are generated based on minimum/maximum distance and minimum/maximum drop size. Any breakpoints that exceed the maximum capacity or maximum travel distance of the asset are excluded.

Demand is classified using three measures: quantity, weight, volume. Assume the default units of measure (as defined in Model Settings) are:

Quantity = EA

Weight = KG

Volume = CMTR

Our product has Unit Weight = 0.5 (KG) and Unit Volume = 0.1 (CMTR).

The Customer Demand record looks like this:

Period Customer Product Quantity Series Offset Time Occurrences
Horizon Cust_123 Prod_A 100 0 10

The total demand is 1000 pieces. Based on the Product definition, 3 drop sizes are defined: 100 for Quantity, 50 for Weight and 10 for Volume. These drops are delivered 10 times in the period. The drops are then aggregated for the region and period.

Assume that you have a Multi-Stop Estimation Vehicle Cost record that limits the vehicle travel distance to 600 KMs. The vehicle has a Capacity (Quantity) of 100, Capacity (Weight) of 0, and a Capacity (Volume) of 0. In this case, the matrix will use only Quantity-based lookup values.

When generating the matrix using all Customer Demand, assume that drop bands may range from 0 to 100 pieces per drop and distances may range from 0 to 1000 KMs. Proposed drop band sizes are 0, 20, 40, 60, 80, 100. Proposed distance bands are 100, 200, 300, 400, 500, 600, 700, 800, 900, 1000. The actual bands written to the matrix are those within the drop size and distance capacities: drop size = 0, 20, 40, 60, 80, 100 and distance = 100, 200, 300, 400, 500, 600.

Multi-Stop Estimation uses the Units Of Measure table and expects the row ID values (in the database table) to match those defined when the model was first created. That is, the Quantity unit of "EA" has ID = 1. Be careful not to change these values. This can occur if you export the table to Excel, then re-import it.

Multi-Stop Estimation Limitations

The following are limitations to the current implementation of Multi-Stop Estimation:

  • In the Multi-Stop Estimation Vehicle Cost table, some columns in this table have fixed units of measure (Fuel Cost Per Distance (KM) and Maintenance Cost Per Distance (KM)). This is to support the internal calculations for the cost matrix, which are in KM. For the Capacity (Quantity), Capacity (Weight) and Capacity (Volume) columns, the units of measure are the defaults as defined in Model Settings. Units of Measure are supported for the Unit Weight and Unit Volume on the Products table. You can apply a unit of measure to the Inter Drop Distance.
  • Step Functions and Distributions are not supported for the Multi-Stop Estimation Vehicle Cost table. Regular numbers are supported for the columns in this table.
  • Groups are not supported for Customer Demand (Period, Customer and Product). If the demand is grouped when you calculate the matrix, you see the following error: “Calculation Failed: No Available Demand in Horizon or Transportation Region”. You can expand the model, then run Multi-Stop Estimation on the expanded model.
  • Multi-Stop Estimation is not supported with Cloud Solve.

Last modified: Wednesday May 15, 2024

Is this useful?