Month: September 2015

Let’s say your transportation costs are too high. With Mapline, you can easily optimize your transportation costs by identifying the closest distribution center to your retail stores. Just take your Excel spreadsheet with the list of your store locations and the list of all the distribution centers. You want to find the distribution center that has the shortest distance to each store location. So, once these are pasted into Mapline, just select the Distance Calculations option. Now you need to pick the two data sets that represent the distribution centers and the stores. Once you hit download you will get a spreadsheet that shows the distances between each store and each distribution center. Now, using Excel, you can easily run a minimum formula to find which distribution center is closest to each of your stores. And that’s how easy it is to minimize transportation costs using Mapline! Sign up to try it out yourself.

Mapline makes it simple for you to streamline operations by identifying backup supply options. Let’s say that you own some gas stations, and there are occasionally supply outages from your fuel supplier. You want to find some backup supply options so that your operations aren’t affected. This is simple to do with mapping. Just plot your gas stations and suppliers in Mapline. This can be added with a simple paste from your Excel spreadsheet. Once the gas stations and suppliers are on your map, just go to the Distance Calculations option and select these two data sets. Once you hit download you’ll get a spreadsheet showing the gas stations along the left rows and the suppliers along the top columns. Where the Row and Column intersects is the distance between the two points. Now that you have a huge distance grid spreadsheet, you can easily run a =SMALL() formula in Excel to identify the first, second, and third closest supply locations to evaluate your options! And that’s how you can streamline operations using Mapline! Sign up to start streamlining your operations with mapping.

Visualize Your Territories with Territory Mapping Software

Well-defined sales territories directly impact sales results. But how do you take the data you have and visualize it, so you can view your current sales territories and identify new opportunities? This is where Mapline’s quick and easy sales territory mapping feature can help.  

Territory Mapping with Mapline’s Drawing Pad

Let’s say your business has grown to the point where you need to restructure your sales territories so they can be more effective. There are two ways to build sales territories, and they are both super simple. The first way is to leverage the drawing pad to draw territories on your map. This is easy if there aren’t too many territories and you aren’t looking for perfection.

Create Sales Territory with Overlays

The other way to build sales territories is by mapping territory overlays. This method is best if your sales territories consist of groupings of zip code, county, or state boundaries, and you’d like to color each territory (such as zip code or county) according to the sales territory it belongs to. Let’s assume you’d like to do this with zip codes.

Steps for Sales Territory Mapping

1. Go to your Excel spreadsheet and make the first column header “Territory.”
2. Below that, enter all the zip codes you have.
3. Make the second column header “Color.”
4. Next to each zip code, enter the color you would like it to appear on the map. (Perhaps you want Clark’s zip codes to be “Blue” and Peter’s zip codes to be “Green” and so on.)
5. Then, just paste those two columns into Mapline and you’re done!

That’s how easy it is to build sales territories with mapping. There’s so much more you can do with Mapline! Check out all of our features to make sure you’re getting the most out of your account.