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.

Attribute Value
Name Rear-loader 1
Description Rear-loading truck
Capacities 15000
CostPerUnitDistance 2.75

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 3 Results
Description Two rear-loading trucks
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?