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
- Go to your Excel spreadsheet and make the first column header “Territory.”
- Below that, enter all the zip codes you have.
- Make the second column header “Color.”
- 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.)
- 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.
How to Draw on a Map to Create Custom Territories
Mapline offers many ways to visualize territories – state, county, area code, zip code and plenty more. But sometimes you need a custom option, and we provide that too. If you have territories that are unique to your company and don’t quite match up to existing shapes, you can plot shapes on a map to meet your individual needs.
But there’s more! You can click on your custom shape to see a list of all the locations that are inside the shape. Then you can easily export them back to Excel to use in other analysis. This makes it super nice when you are creating sales territories and need a quick list of whose territory new customers fall.
With custom mapping software from Mapline, you can quickly draw custom territories and shapes on your map with the Draw Pad feature. Just select the shape you would like to draw on your map, such as a line, circle, square, or polygon. For circles, squares and the like, you simply click on your map to create the shape. For custom polygons, click along the edges of the custom territory you want to create, and finally click back on your original point to close the shape.
Using Custom Territories for Additional Analysis
There’s even more you can do with Mapline! You can click on your custom shape to see a list of all the locations that are inside the shape. Then you can easily export them back to Excel to use in other analysis. This makes it super nice when you are creating sales territories and need a quick list of whose territory new customers fall into.
This gives you the ability to do what can’t be accomplished in Excel! And it only takes a few minutes. Get started adding your custom shapes or territories to a map and find out more about what Mapline can do.
Save a map zoom level and position so that you don’t have to re-position it each time you open the map. To save the map zoom level and position, follow these steps:
- Open your map.
- Zoom and position your map to where you would like to save it.
- Click “Menu.”
- Choose “Save Current Position.”