Napa's Best Sales Territories and Routes

This was an interesting project for a ficticious company based in Napa County.  We created three sales territories using a variety of methods with the goal of equal distribution of sales prospects in terms of potential sales and number of prospects. 

We then created a route map for the top ten highest sales potential prospects for each sales territory starting from the salesperson's home.  The default map was then compared to a optimum route map created using Network Analyst. 

Napa's Best Wines Final Presentation

Better Books new store site selection - Report

Following is the link to my final power point presentation.  This was an interesting project for an area in which I lived.  I lived and worked on the Presidio of San Francisco and am very familiar with potential new store locations and existing store locations.  Better Books and the sales data was ficticious; however, the demographics came from 2003 Census Data. 

I would have liked to delve more into the marketing analysis of this project, e.g. which demographics most affect sales, how to interpret sales figures but just didn't have any more time.

Better Books Site Selection Presentation