Multi-Stop Estimation Vehicle Cost

A new home for the Coupa Supply Chain documentation

Starting with Supply Chain 42, our documentation will be located on Coupa Compass. The help here will continue to be accessible for the foreseeable future, but will no longer be updated. If you need a Compass user account, contact your company’s Designated Support Contact (DSC).

You can access new and updated Supply Chain documentation in the following location on Compass:

https://compass.coupa.com/en-us/products/supply-chain-design-and-planning

Multi-Stop Estimation Vehicle Cost

Internal Table Name: AdvancedCosting_PseudoRoutingVehicleCosts

Use the Multi-Stop Estimation Vehicle Cost table to define the costs and constraints that are used for Multi-Stop Estimation.

Name

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: CostName

Type: Short Text (100)

Enter the name for the multi-stop estimation vehicle cost definition. This value is available for the Fixed Shipment Cost column in the Modes table.

Capacity Utilization

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: CapacityUtilization

Type: Number (Float)

Specify the factor by which the vehicle capacity can be decreased if desired. For example, if you want to allow a 10% decrease in the capacity, set the Capacity Utilization to 90. Values between 0 and 100 are valid.

Default: 100

Location Loading Time (Min)

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: LocationLoadingTime

Type: Number (Float)

Specify the time required to load at each location the vehicle visits. Enter a value in minutes.

Default: 0

Vehicle Speed Factor

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: VehicleSpeedFactor

Type: Number (Float)

Specify the factor by which the default transport speed is scaled for this vehicle. The default transport speed depends on the distance of the lane specified by the transportation policy. It is calculated as follows, with distances measured in KM and speed in KMH:

If (distance >= 320) then speed = 80;

else if (distance >= 32) then speed = 48 + ((distance - 32) / 9);

else speed = 32 + (distance / 2)

For example, if the default transport speed is 80 and you enter a Vehicle Speed Factor of 120, the speed for this vehicle is 96.

Default: 80

Inter Drop Distance

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: InterDropDistance

Type: Short Text (25)

Specify the average distance between two drops within a Transportation Region. This value overrides the calculated inter drop distance. Enter a value and optionally select a unit of measure. If you do not select a unit of measure, the default Distance unit of measure in Model Settings is used.

Default: null

Max Number Of Days Per Journey

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: MaxNumberOfDaysPerJourney

Type: Number (Float)

Enter the number of days that the driver and vehicle can operate before returning to a site. This value has an effect on the Overnight Allowance.

Default: null

Time Utilization

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: TimeUtilization

Type: Number (Float)

Specify the factor by which the available time for the vehicle can be increased or decreased if desired. The available time is defined by the combination of the Hours Worked Per Shift, the Number of Shifts Per Day and the Operating Days Per Week. For example, assume you have Hours Worked Per Shift = 8, the Number of Shifts Per Day = 2 and the Operating Days Per Week = 5. The available time is 80 hours. If you enter a Time Utilization of 80, the time that can be utilized is now 64 hours.

Default: null

Hours Worked Per Shift

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: HoursWorkedPerShift

Type: Number (Float)

Enter the number of hours that a driver works in a shift. This value, combined with the Number of Shifts Per Day and the Operating Days Per Week determines the available time for the vehicle.

Default: null

Number Of Shifts Per Day

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: NumberOfShiftsPerDay

Type: Number (Float)

Enter the number of shifts, each of which is defined by Hours Worked Per Shift, that the vehicle operates in one day. These values, combined with the Operating Days Per Week, determines the available time for the vehicle.

Default: null

Fixed Unloading Time (Min)

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: FixedUnloadingTime

Type: Number (Float)

Enter the fixed time required to unload at each location. Enter a value in minutes.

Default: null

Variable Unloading Time (Min)

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: VariableUnloadingTime

Type: Number (Float)

Enter the variable time per unit of measure to unload at each location. Enter a value in minutes.

Default: null

Overnight Allowance

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: OvernightAllowance

Type: Number (Float)

Use this value to apply an overnight cost when the Max Number Of Days Per Journey is greater than one. For each overnight on the journey, the Overnight Allowance is accumulated.

Fixed Route Cost

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: FixedRouteCost

Type: Number (Float)

Enter the fixed cost for each route that is scheduled with the vehicle.

Default: 0

Operating Days Per Week

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: OperatingDaysPerWeek

Type: Number (Float)

Enter the number of days per week that the vehicle is in operation. For example, you can define a 5 day work week for the vehicle.

Default: null

Max Number Of Drops On Vehicle

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: MaxNumberOfDropsOnVehicle

Type: Number (Integer)

Enter the maximum number of delivery locations that the vehicle can service in a route.

Default: null

Hours Break Time Per Shift

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: HoursBreakTimePerShift

Type: Number (Float)

Enter the required break time in hours that must be taken within each shift.

Default: null

Delivery Time Window

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: DeliveryTimeWindow

Type: Number (Float)

Enter the number of hours between the first drop and last drop on the route. While the vehicle may operate for 12 hours a day, the delivery window may be only 4 hours. Multi-stop estimation does not reflect actual time of day, but this enables you to model limited delivery windows, such as morning only for retail locations. While the Delivery Time Window does not include the stem distances, it can adjust the shape of those average route and cost functions with larger stem mileage values. The default time unit is Hour.

Default: null

Does Not Return To Location

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: DoesNotReturnToLocation

Type: Bit

One of Yes, No. (Actual database values are 1,0.)

When this option is set to Yes, return mileage is not added to the route calculation. As a result, there can be more drops on the multi-stop estimation route and this can affect the cost function. When this option is set to No, the return stem mileage (from the last stop to the vehicle home location) is included in the route calculation.

Default: Yes

Number Of Days To Schedule Transportation

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: NumberOfDaysToScheduleTransportation

Type: Number (Float)

You can use this value to “tune” the efficiency of the route by affecting the calculated inter drop distance. Typically, routes in the real world will be more efficient the longer you have to schedule them. The higher you set this number, the lower the inter drop distance which results in effectively more efficient routes.

Default: null

Variable Cost

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: VariableCost

Type: Number (Float)

Enter the variable per distance unit cost that is incurred when the vehicle is used.

Default: 0

Fixed Drop Cost

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: FixedDropCost

Type: Number (Float)

Enter the fixed cost incurred at each delivery location.

Default: 0

Freeze Cost Matrix

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: FreezeCostMatrix

Type: Bit

One of Yes, No. (Actual database values are 1,0.)

If you have already run the model and multi-stop estimation values have been calculated, you can set this field to Yes to prevent the values from being recalculated when you next run the model.

Default: Yes

Lead Time Override (Day)

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: LeadTimeOverride

Type: Number (Integer)

You can override the Transport Time in the Transportation Policy table by entering a value in Lead Time Override. Enter a value in days.

Default: null

Stem Distance Adjustment Percentage

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: StemDistanceAdjustmentPercentage

Type: Number (Double)

The multi-stop estimation algorithm calculates an average distance using the customer demand, called a stem distance. You can enter a percentage by which to adjust the stem distance to calibrate this distance to match your actual network more closely. The algorithm does not use an actual site. Instead, it looks at the spread of demand for the included customers and calculates an average stem distance.

Default: null

Create Fixed Cost Movements

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: CreateFixedCostMovements

Type: Bit

One of Yes, No. (Actual database values are 1,0.)

This field is used to limit the cost used to a fixed integer cost rather than a per unit cost. Fixed cost movements are limited to supply and InterSite movements and do not apply to customer distribution.

This is not currently implemented.

Default: Yes

Is Owned Vehicle

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: IsOwnedVehicle

Type: Bit

One of Yes, No. (Actual database values are 1,0.)

Specify whether or not the vehicle is owned, or belongs to a different company. The algorithm varies depending on whether or not you own the vehicle. For owned vehicles, the algorithm uses cost factors including fixed cost per day, driver- and maintenance-related costs. When the vehicle is not owned, the algorithm uses fixed cost per route, fixed cost per drop and the variable cost per distance.

Default: Yes

Fixed Cost Per Day

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: FixedCostPerDay

Type: Number (Double)

Enter the fixed cost for each day that the vehicle is in operation.

Default: 0

Driver Cost Per Hour

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: DriverCostPerHour

Type: Number (Double)

Enter the cost per hour for the driver. This is applied based on the Hours Worked Per Shift and Number Of Shifts Per Day.

Default: 0

Fuel Cost Per Distance (KM)

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: FuelCostPerDistance

Type: Number (Double)

Enter the fuel surcharge that is incurred per kilometer.

Default: 0

Maintenance Cost Per Distance (KM)

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: MaintenanceCostPerDistance

Type: Number (Double)

Enter the maintenance surcharge for the vehicle that is incurred per kilometer.

Default: 0

Capacity (Quantity)

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: UnitCapacity

Type: Number (Integer)

Enter the maximum number of units that can be transported on the vehicle at any point in time. Enter a value, then optionally select a quantity unit of measure. If you do not select a unit of measure, the default Quantity Unit Of Measure from Model Settings is used.

Default: 1

Capacity (Weight)

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: WeightCapacity

Type: Number (Float)

Enter the maximum weight that can be transported on the vehicle at any point in time. Enter a value, then optionally select a weight unit of measure. If you do not select a unit of measure, the default Weight Unit Of Measure from Model Settings is used.

Default: 0

Capacity (Volume)

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: CubicCapacity

Type: Number (Double)

Enter the maximum volume that can be transported on the vehicle at any point in time. Enter a value, then optionally select a volume unit of measure. If you do not select a unit of measure, the default Volume Unit Of Measure from Model Settings is used.

Default: 0

Status

Technology: NO

Table: AdvancedCosting_PseudoRoutingVehicleCosts

Internal Name: Status

Type: Short Text (25)

One of Include, Exclude.

This field determines whether or not the vehicle cost record will be included when you run the model.

Default: Include

Last modified: Wednesday May 15, 2024

Is this useful?

Yes No