Use this sheet to define how each task affects vehicle capacity.

Each row represents one capacity dimension for a task. If a task uses multiple units of measure (for example, pallets and pounds), it must appear on multiple rows, one per unit of measure.

This sheet is optional. It is only required if you are modeling capacity constraints (for example, pallets, weight, volume, etc.). If no vehicle capacity limits are defined, this sheet may be left blank.

Task ID

Specifies the task to which the demand size applies.

This field must match a Task ID defined in the Tasks sheet exactly. A task ID may appear on multiple rows if it has demand in multiple units of measure.

Unit of Measure

Specifies the capacity dimension associated with this demand value.

This field must match a Unit of Measure defined in the Units sheet. Each Task ID + Unit of Measure combination must be unique.

Demand

Defines how the task changes the vehicle’s load.

Demand must be entered as a numeric value and may be positive or negative, or zero.

• A positive value increases the vehicle’s load (for example, loading 5 pallets onto the truck).

• A negative value decreases the vehicle’s load (for example, unloading 5 pallets from the truck).

• A value of zero means the task does not affect capacity.

Vehicle capacity constraints are enforced throughout the route, ensuring the vehicle’s load never exceeds its defined capacity.

Pickup and Delivery Modeling

When modeling pickup and delivery tasks that represent the movement of the same goods:

• The pickup task should have a positive demand.

• The delivery task should have a negative demand of the same magnitude.

• The two tasks must be linked in the Task Pairs sheet.

This ensures:

• The pickup occurs before the delivery.

• Both tasks are assigned to the same vehicle.

• Vehicle capacity is respected at all times.

Rules and Structure

• Task ID must exist in the Tasks sheet.

• Unit of Measure must exist in the Units sheet.

• Demand values must be numeric.

• If a task has multiple size dimensions, the task must appear once per dimension.