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

Skill Drill: Adjusting the Model to include Rear-Loading Trucks

After running the first two models, it is clear that at least two routes are needed to complete all of the orders. The next step is to determine if more money can be saved by using a rear-loading garbage truck instead of a side-loading truck. The rear-loading trucks have a lower cargo capacity, but the operating costs per mile are lower as well. Right click on Side-loader Truck 1 in the Network Analyst Window and select Properties.

An image of a right click to select the route properties.

Change the name to Rear-loader Truck 1 and edit the following attributes.

NameRear-loader 1
DescriptionRear-loading truck

Leave all of the other attributes unchanged. Repeat these steps to change Side-loader Truck 2 to Rear-loader Truck 2. Once the changes to the routes are complete, you will have to update the properties to both of the route renewals to reflect the name changes  When you are ready, run the model by clicking on the Solve button in the Network Analyst Toolbar. The new model will run and the new results will overwrite the previous results in the memory feature classes in the Table of Contents. Record the results on a third table in Microsoft Excel.

VRM Model 3Results
Total cost in dollars
(two routes added together)
Total time in minutes
(two routes added together)
Number of time violations?
Orders not reached?

Think about the following questions and make a note to yourself for later reference.

  • What was the status of the orders?
  • Were all of the orders reached?
  • Were there any other problems, such as Time Violations?
  • How did the cost of rear-loading trucks compare to the side-loading trucks?