Assignment 2 - Network Analysis
This storymap shows the network analysis assignment.
This map shows the walking and driving routes from my home to the local ice skating rink.
Walking takes almost 50 minutes, while driving only takes a bit less than 10 minutes.
Walking distance: 4,10km
Driving Distance: 4,82km
Interestingly, the driving route correctly chooses the correct way along the Staatsbrücke and Rudolfskai, since the other side of the river is a one-way street.
Map Except: Correct rerouting via southern side of the river for car traffic
On this map, the three closest Glass Recycling Containers and the walking routes to said containers are shown.
All containers are within one kilometer walking distance, the closest is the one in Goethestraße with a walking time of 7.5 minutes.
Distance and walking time to three closest glass containers.
SCENARIO 1
This map shows an optimization of travel routes for glass container pick-up, starting from the recycling facility in Bergheim
After finding out that a recycling truck has a capacity of 8 tons, I opted to only use two truck since that leaves almost 120kg pick-up capacity per stop on a 70 stop route. Starting the route at 6 in the morning, the route time is under 6 hours - which is a good shift time for the employees. Using only two trucks reduces the labor and logistical costs significantly.
Number of stops, driving and servicing times as well as start- and endtime for each of the two routes. Green: Route 1 Purple: Route 2
It seems that the weight of the pickups per route is manageable, but it is questionable if the trucks can hold the volume of the glass. If this is the case, I propose scenario 2 on the following map.
SCENARIO 2
If the volume of the garbage truck is not enough to collect every container in one go, we should look into the possibility of two sorties per truck, meaning each of the two trucks completes two loops per collection day.
Since in the first scenario, two optimal routes have already been chosen, we use these routes two divide each one again, meaning each truck does 25% of all containers per route, but two routes per day in order to return and empty the truck in between.
Using this method, the maximum amount of containers visited before returning to the facility per sortie shrinks to 48 (and the weight pickup per stop reaches 175kg), each shift does not take more than 4 hours. This means, two trucks with shifts of 8 hours per day (divided into 2 sections each) can cover all glass containers within a day, eliminating the need for a third truck all together.
Using this method, we manage to pick up all glass containers within one working day, using the time the crews can be expected to work per day optimally and being sure that the trucks will not be too full. Additionally, the workers can enjoy a lunch break at their facility before they start in the 2nd half of the day.
This map shows the iso-walking time maps or several popular student bars.
The total area where one of those bars is reachable via walking within 4 minutes is 0,83 square kilometers. For 8 minutes, this area is 1,42 square kilometers larger than within 4 minutes; for 10 minutes the area is 3,23 square kilometers in total.
