Project 4-GIS & Transportation

Report Week
This weeks submittal shows the optimal driving routes to the 'Top Ten Prospects in each of the 3 sales territories.  The Network Analyst tool bar was utilized to find the optimal driving routes for the sales people. I also checked the attribute tables for the top ten prospects in each territory and they were somewhat equitable.

Project 4-GIS & Transportation

Week 2-Analyze-Determine Sales Territories

This weeks goals are to provide the fictional company, Napa's Best-Wine Distributors with a sales territory division.  One system is to show a somewhat equitable system and the other is to show the territories to being divided by the major roads.


Map 1-Showing two systems for dividing the territories.  One system shows an equitable system with a more or less equal number of prospects and sales potential within 5% of the mean of potential sales. The other system divides the territories by the major road system in Napa County.

Map 2- Shows the preferred system of dividing the territory by an equal number of prospects and sales potential, as shown above but with more detail.

I have chosen Alternative 1 as the most equitable system.  However, I believe it is possible to design 'highway system' with equality. This would necessitate using local collector streets for the routes.  This may result in longer travel times for the sales force.  Alternative 1, I believe is more fair.  It divides the highest density area (Napa City) amongst the sales people.  I also believe that the County is not so large to create a burden, although the salesperson in the South territory will have less driving to make the sales calls.  With that said, I believe most salespeople would prefer a system of equality in prospects and sales potential.  Given enough time and understanding the true driving times, the highway system may have merit, but it may be difficult to design?

Project 4-GIS & Transportation

Week 1-Prepare--Managing Sales Territories and Routes

This project is to show a hypothetical wine distributor known as Napa's Best and how sales territories may be divided equitably to three sales people within Napa County. The maps shown below are the initial preparation showing the number of households, total number of restaurants, liquor stores and the overall wine sales within the County per household. As one can see there is a higher concentration of restaurants and liquor stores around the Napa, CA  area but the restaurant, liquor and wine sales per household in the west-central portion of the county are high over a large geographical area. In the next phase of analysis it may become clearer on what the most equitable way to divide the territory is? However at this time, it appears that some equality will have to be given to divide the Napa City area amongst the sales people as the largest number of potential accounts (restaurants and liquor stores) are within this area. Guess we'll see!

Project 3-GIS & Economics

Project 3-Final Report for Better Books, Inc
Site Selection Analysis for New Store

This was a fun project with lots of real world applications! The color of the slides gets a little lost in the background but I still think they are visible.

Project 3-GIS & Economics

Part 2-Analysis for siting a new store for the Better Books franchise.

Step 1- Review market areas

This portion of the project analyzes two market conditions.  The first map shows the market areas around both hypothetical stores representing the area responsible for 60% of all sales.  This also contained another polygon surrounding the 60% area showing the area of 80% of the sales.  It was deemed that the most important measure was the concentration of sales closest to the book stores, so only the 60% area is shown. The household income and the Book Lover Club members are also shown.The second map shows the area around each store showing driving times to the stores for 1 minute and 3 minutes. After reviewing both of these markets and comparing against demographics, such as total population, annual population growth, household income and average home valuation it was determined that that the Steiner store has a population that is growing and has a higher net worth and higher home values.  Comparing the statistics of drive time to the stores, the population surrounding the Steiner store is over three times larger within 1 minute and over 2 times larger than the Bosworth store.  The net worth, and home valuations are still higher in the Steiner neighborhoods.  In both cases the Bosworth area has a higher average household income but it is also noted that the Book Lover Club annual sales are consistently higher for the Steiner store.  It was determined that the Steiner Store is the model store.

Step 2-Review potential book store sites.

Three sites have been determined for new stores.  The are the Northwest, Southwest and East Central locations.  The following map shows a 1 mile buffer radius from the potential stores with the census blocks shown that have their centroid within the 1 mile buffer.  The demographics for these stores have also been examined. At first glance the East Central appears to be the most desirable location for a new store as it has the highest overall population, the highest number of households and highest number of Book Lover Club members. However currently there are 12 competitor stores within a 1 mile radius of this location.  It is also noted that although the Northwest store has the lowest overall population, it has the highest average household income, highest average net worth and highest home values.  The Northwest location has only 4 competing stores within the 1 mile buffer and the 2nd highest number of Book Lover Club members.  It appears at this point in the analysis, the Northwest location will have the best possibility of success based on these statistics and factors.  No real estate costs were determined for any of these sites.

Project 3-GIS & Economic Development

Week 1-Prepare Data

This week's submittal represents a hypothetical book store chain in San Francisco, CA.  The Better Books store is trying to determine where to open a new store.  The maps represent the following: Map 1 is the demographics of the area, Map 2 shows a 1 mile buffer radius around each store and how many of the Better Book Lover's club reside within those buffers.  Map 3 shows the market areas based on U.S. Census data showing the census blocks that their centroid within the 1 mile buffer.  Map 4 shows the market areas overlaid with the the percentage of the population that has had some college.  The project to this point has been straightforward except for loading these large (12-15mb) maps into this blog.  I had to compress the size, so the quality of the maps is not as clear as I would like. In addition to these maps a calculation page was prepared showing average household income, number of households and average home values within the market areas.

Project 2-GIS and Landscape Design

Report Week-Marin, California Tree Study
Project Goals--To show the number of trees and the energy savings associated with trees.
and to show the number of trees that need to be planted to offset ½ of the energy costs associated with the proposed Marin City Center.

This map is to show the number of trees in the neighborhoods and the energy savings based an average cost of $4.39 per tree.

 











This map shows the Proposed Marin City Center.

Overall I thought this was a fun project and has a number of real world applications.  It would seem that many municipalities will be undertaking studies like this to determine if the cost of mapping, planting and maintenance are beneficial to the city.  As can be seen, an energy savings is only one of the benefits.  Other benefits include: stormwater management, help with soil erosion, carbon storage and sequestration and an increase in property values. 
Calculating the energy costs and the number of trees that needed to be planted for the proposed Marin City Center had a few challenges, as there was limited information on the building sizes or number of building proposed.  I made a "crude" count of the buildings for my calculations and ultimately ended with around 1,200 trees that needed to be planted to offset ½ of the energy costs for the proposed City Center.