Optimizing Organic Waste Diversion Using a Vehicle Routing Model

Table of Contents

  1. Optimizing Organic Waste Diversion Using a Vehicle Routing Model
  2. Setting up Your Workspace
  3. Preparing the Data
  4. Skill Drill: Clip the Roads Layer to the City of Eureka
  5. Skill Drill: Add a Time Cost Attribute to the Roads Layer
  6. Skill Drill: Adding XY Data
  7. Skill Drill: Geocoding an Address  and Creating a CSV Table to Import As XY Data
  8. Creating A Network Dataset
  9. Setting up a Vehicle Routing Problem (VRP)
  10. Loading Orders into the Model
  11. Loading the Depot into the Model
  12. Adding Route Parameters into the Model
  13. Adding a Route Renewal into the Model
  14. Adjusting the Analysis Setting of Model
  15. Running the Vehicle Routing Model
  16. Skill Drill: Adding a Second Garbage Truck to the Model
  17. Skill Drill: Adjusting the Model to include Rear-Loading Trucks
  18. Skill Drill: Creating a Map of the Results

Adding Route Parameters into the Model

As you will recall from the lecture videos, Modeling Network Paths, the route is more than just a path. In a vehicle routing model, routes are a network class that defines the vehicle, the driver, and the linear features they travel on. Routes also have attributes that influence cost or place limitations on the model. In this model, our routes have attributes that include the depot where the route will start and end. The starting and ending service time attributes indicate the time it takes to prepare and service the garbage trucks at the start and end of each day. The earliest and latest start time attributes indicate the time window when the route will first begin. Routes also have attributes related to the vehicle. The capacities attribute indicates the carrying capacity of the garbage truck before it needs to be emptied. In this scenario, a side-loading garbage truck can carry twenty thousand pounds before it needs to be emptied.  When the model runs, this attribute will be compared to the pickup quantities attribute of the Orders to determine when the truck is full. The model assumes that both the capacity and the pickup quantities use the same unit of measurement. The cost per unit distance attribute defines the operating cost of the vehicle per mile, including fuel and maintenance. Finally, routes have attributes related to the driver. These attributes include driver salaries, as dollars per minute, under the cost per unit time value. The overtime start and cost per unit overtime tracks when any overtime pay accrues. The max total time attribute defines the maximum length of time a single driver can work. In this scenario, the total number of hours a driver can work is limited to twelve hours. Right click on Routes in the Network Analyst window and select Add Item. This opens up the Route Properties window.

An image of the route properties window for side-loader truck 1

Under the Value column, enter the following values in the Route Properties window. Keep the default values for any properties not listed here.

AttributeValue
NameSide-loader 1
DescriptionSide-loading truck
StartDepotNameEureka Garbage Dump
EndDepotNameEureka Garbage Dump
StartDepotServiceTime15
EndDepotServiceTime30
EarliestStartTime5:00 AM
LatestStartTime6:00 AM
Capacities20000
CostPerUnitTime0.75
CostPerUnitDistance3.95
OvertimeStartTime540
CostPerUnitOvertime1.13
MaxOrderCount300
MaxTotalTime720

Once the values above are entered, click OK. The routes should now be loaded in two places. The routes in the Network Analyst window represent our model parameters. Any modification of the model parameters, or input to the model, are entered here. In the Table of Contents, the memory feature class, also named Routes, is now populated with the route attributes, the output from the model. Next, you will add a Route Renewal into the model.