Plan Efficient Routes for Field Personnel Using Optimized Routing & Time Windows

A traveling sales person/repair technician works for Acme HVAC. The rep both sells and repairs HVAC systems. Consolidation of the sales and repair groups is a recent company experiment. While the consolidation cut company travel expenses in half, not all repair people can sell, and not all sales people have the skills to repair HVAC systems. Still, there was a lot of overlap.

Problem: How can a traveling technician schedule appointments and plan efficient travel and while accommodating cancelations?

Wearing two distinct hats means field technicians have little time for problems in scheduling. One canceled appointment and the whole week can deteriorate. Field techs found themselves far afield when customers canceled a scheduled appointment. Such cancelations can destroy three to four hours of repair or sales time, often several times a week.

Solution: Subscribe each sales person to a business mapping software that provides optimized routing services that can help manage schedules.

The State of Online Map Routing

Business mapping tools provide many productivity enhancing features including:

1. Efficient turn-by-turn directions across multi-stop optimized routes
2. The ability to import and adjust routing stops by time window
3. A view of alternative accounts and prospect locations across the entire sales and repair coverage area, so when visits get canceled technicians can more easily substitute a new appointment immediately

Mapping software routing is a common feature on cell phones and Internet mapping tools. Less common is the ability to build multi-stop optimized routes with up to one hundred stops per route. With the addition of time windows, routing becomes a full-fledged scheduling tool. Field technicians can estimate visit times by stop. So now a full week’s schedule can be planned and considered with driving time, customer visit times and even a lunch stop off.

Turn-by-turn directions are included in business map routing tool results output. Acme reps generate directions to customer locations and use the results to submit travel reimbursement reports. Route stops and directions are exportable as PDF, CSV, GPX, and popular Personal Navigation Device file formats. This means sharing maps, routes, and itineraries is easy. This comes in handy for route hand-offs on sick days or in emergency response mode.

Acme field technicians are encouraged to import customer and prospect address databases into the map application. These customer records are usually color coded and symbolized for easy viewing on the map – depending on field tech priorities:

• Color code prospects and customers differently for fast identification
• Color code customer locations by planned visit week, or visit day
• Color code the coming week’s scheduled appointments Red and turn visited stops Green as completed or Yellow if further work is required

How to Import an Excel Sheet of Customer Addresses & Route

1. Prepare an Excel sheet of customer addresses with separate columns for Address, City, ZIP, etc.
2. Use the Plot Data button to navigate to and select your data. Process the data to the map while choosing labeling options
3. Color Code and Symbolize customer pinpoints as required
4. Filter Select or Polygon Search Select a subset of customer records for the day or weeks activity
5. In the Data Window, view the search results and choose the Add All Rows to Route option
6. Adjust stop orders and amend stay durations as necessary
7. Alternatively, a user can incrementally select points for route stops by click the Car icon in the label or in the Data Base view
8. Choose optimize or route in order of list. Select round trip route as required

Acme HVAC field technicians are required to have the latest customer and prospect datasets loaded in their MapBusinessOnline map view. In the event of a sudden field cancelations, traveling techs can find other customers or prospects in the area to contact. With any luck, they will have service requirements come due and another trip to the area can be avoided. The company has received several unplanned orders due to rescheduled visits.

The mapping tool also include a map sharing option, transmittable by email, the enables a fast hand-off in the event of an emergency or duration overruns. These interactive web maps even allow Acme field reps to create new routes in the field as required.

Business mapping software with routing and time windows provides a platform for field technician workflow scheduling. Affordable cloud-based services that control costs.