The present invention relates to business location modeling systems and methods. More particularly, the invention relates to insurance agency location modeling to establish new insurance agency locations in various geographic locations based on an evaluation of user selected criteria.
The decision to open a new office or branch in order to increase sales for various different types of products or services in a particular geographical region or postal zip code can involve consideration of numerous factors such as population density, potential population growth, customer household data, and traffic flow patterns. When determining a location for a new office or branch for an insurance company, a business entity or business owner may desire to consistently use the same factors or analysis when comparing different geographical locations for the new office site. The use of inconsistent data or factors across geographic locations may result in a suboptimal site location being selected for a new office or branch.
Moreover, as the number of potential geographic regions increases, it can be desirable to standardize results so that comparisons between the different geographic regions may be utilized. For example, a company providing a particular product or service may wish to open a number of new offices or branches across a large geographic region such as the United States. With such a large geographic region to consider, it can be desirable to display comparable results to decision makers so that suitable site locations may be selected.
Current site location models in use in other industries such as retail pharmacy do not take into account unique factors and problems found in the insurance industry. In addition, existing site location models or systems of other industries may not utilize an overall scoring method that allows results to be consistently and easily displayed to the decision maker or business entity. Without an overall scoring methodology, the analysis of the results is more time consuming and inefficient involving the unnecessary consumption of numerous resources.
Furthermore, it is desirable to take into account a host of perils that affect a geographic area during comparison of potential insurance agency site locations. These perils may include natural events such as a volcanic eruption, earthquake, landslide, avalanche, flood, tsunami, hurricane, tornado, and/or wildfire and perils related to human activity such as toxic waste and/or industrial accidents.
Therefore, there is a need in the art for an insurance agency location modeling method and system regarding the process of determining successful placement of future insurance agency locations. The method and system for suitable insurance agency locations must provide consistent and easily interpreted results.
Aspects of the invention overcome problems and limitations of the prior art by providing a method of determining suitable locations for insurance agency locations. The disclosed method may be utilized to increase market penetration of underrepresented markets. The method comprises the use of a scoring algorithm to rank various geographical regions by related zip codes. The scoring algorithm may be implemented by a location modeling system based upon markets selected by a user. The method further comprises use of distance modeling to determine risk from various perils.
In an exemplary aspect of the invention, a user may select a geographical region to be evaluated for placement of an insurance agency location. The geographical region may be in the form of a postal zip code. Various modeling factors are used to determine a highly suitable location for a new insurance agency. A score for each zip code is calculated with the highest overall score representing the most highly suitable, preferred or optimized location for the new office or branch.
In yet another exemplary aspect of the invention, a user may calculate a distance from, or inclusion within a risk border as a shoreline or an elevation contour for use in evaluation of insurance agency placement and assessment of customer locations. In an embodiment, a peril may include a host of natural events such as a volcanic eruption, earthquake, landslide, avalanche, flood, tsunami, hurricane, tornado, and/or wildfire and perils related to human activity such as toxic waste and/or industrial accidents. The distance calculations may account for the curvature of the earth to ensure an accurate calculated distance from the risk border to the potential insurance agency location. Furthermore, for each geographical region analyzed, the population, households, current customer count, agency deployment score, and the households in each of the distance ranges from the risk border may be displayed in a table and/or shown on an interactive map.
In yet another aspect of the invention, a calculated distance from the risk border may be used as a modeling factor in determining the overall score for each zip code being analyzed for a potential new office or branch location.
In certain embodiments of the invention, the present invention can be partially or wholly implemented with a computer-readable medium, for example, by storing computer-executable instructions or modules, or by utilizing computer-readable data structures. Of course, the methods and systems of the above-referenced embodiments may also include other additional elements, steps, computer-executable instructions, or computer-readable data structures.
The details of these and other embodiments of the present invention are set forth in the accompanying drawings and the description below. Other features and advantages of the invention will be apparent from the description and drawings.
A more complete understanding of the present invention and the advantages thereof may be acquired by referring to the following description in consideration of the accompanying drawings, in which like reference numbers indicate like features, and wherein:
In the following description of the various embodiments, reference is made to the accompanying drawings, which form a part hereof, and in which is shown by way of illustration various embodiments in which the invention may be practiced. It is to be understood that other embodiments may be utilized and structural and functional modifications may be made without departing from the scope of the present invention.
User computers 112, 114 and 116 and research workstations 102 and 104 may require information from external data sources to assist in evaluation of a potential new agency location. Requests for such information may be transmitted via data solutions transaction manager computer 110 to a data gathering system 120. Data gathering system 120 may include a processor, memory and other conventional computer components and may be programmed with computer-executable instructions to communicate with other computer devices. Data gathering system 120 may access original primary survey data 134 and external sources of information, such as information vendors 122, 124 and 126 via the Internet 128. Information vendors may include federal or state agencies that provide census type information and/or other geographical type data such as maps.
An exemplary information vendor or source that may provide data on population and housing characteristics within the United States is the American Community Survey (ACS). ACS is an official survey of the U.S. Census Bureau. ACS data is organized by a new census geography called a Public Use Micro-data Area (PUMA). Those skilled in the art may recognize the ability to calculate estimates and forecasts of population and housing characteristics of each PUMA, state, and the country. PUMAs represent special non-overlapping areas that partition a state. In general, a PUMA represents an area which may include all or part of several zip codes. In an embodiment, the United States may be divided up and represented by 2,071 PUMAs.
Data solutions transaction manager 110 may be programmed with computer-executable instructions to receive requests for data from user computers 112, 114 and 116 and research workstations 102 and 104, format the requests and transmit the requests to data gathering system 120. In one embodiment of the invention, requests for data are in the form of documents that are in extensible markup language (XML) format. Data solutions transaction manager 110 may also be coupled to a data manager computer device 130 that accesses customer data stored in a data repository 132. In one embodiment of the invention, all data gathered on a customer or potential customer is stored in data repository 132 so that when additional requests are made for the same data, the data may quickly be obtained without requesting it from information vendors 122, 124 and 126. Data repository 132 may be implemented with a group of networked server computers or other storage devices.
Users and decision makers may be provided with a user interface on user computers 112, 114 and 116 for displaying information. This user interface may enable users and decision makers to interact with data solutions transaction manager 110. The user interface may allow a user or decision maker to perform a variety of functions, such as entering local market data into analysis report templates, and displaying decision results. In addition, users and decision makers may execute various analysis tools to answer questions such as: 1) “Where is the best location for a new office?”, 2) “What is the makeup of the population?”, 3) “Where are our competitors' offices?”, 4) “Which markets will experience household and vehicle growth?”, and 5) “Are there enough prospects that own homes in a three mile radius around a particular agent's office?”
In an embodiment, senior decision makers may use the system to improve their understanding of the marketplace, facilitating business decisions. The senior decision maker may select various geographic regions and run various reports to obtain agency deployment information.
One or more of the computer devices and terminals shown in
The term “network” as used herein and depicted in the drawings should be broadly interpreted to include not only systems in which remote storage devices are coupled together via one or more communication paths, but also stand-alone devices that may be coupled, from time to time, to such systems that have storage capability. Consequently, the term “network” includes not only a “physical network” but also a “content network,” which is comprised of the data—attributable to a single entity—which resides across all physical networks.
Upon activation of the agency deployment tool 304, in a first step 202, a user selects at least one geographic region to be evaluated for placement of a new insurance agency location. The geographic region may be a region of the United States such as the Midwest or may be a combination of various different states, cities, towns, neighborhoods, or other geographic identifiable regions. In addition, the user may select a particular PUMA which represents a geographical region extending across multiple zip codes. Those skilled in the art will realize that numerous different geographic regions and combinations may be defined for analysis. For instance,
A user may create a customized geographic region for ease of use in future sessions. For example, a user may select California, Florida, Illinois, New York, Ohio, and Texas using the add button 404 and define these selected States 405 as the “Large States” 406. Similarly, a user may edit their customized selection through the use of the remove button 407. A user may save their customized selection using the “Save Changes” button 408. Once saved, a user may select their customized selection during future modeling sessions as illustrated in
Based on the user selected geographic regions, the underlying or related zip codes for selected geographic regions are determined in step 204. The use of zip codes enables all of the collected data from various data sources to be converted into data that may be used and scored on a common metric scale. The common metric scale allows various information sources to be integrated and scored. Those skilled in the art will realize that distinguishable data other than zip codes may be used in order to allow processing of data on a common metric scale.
Next, in step 206, data is received from the user which includes at least one modeling factor to be utilized in the determination of the insurance agency location. Those skilled in the art will realize that any number or combination of modeling factors may be used depending upon the marketing or agency growth strategy.
The modeling factors may include one of the following exemplary factors: 1) households with 2+ vehicles current year estimate; 2) households with 2+ vehicles five year projection; 3) net change vehicle households in five years; 4) owner occupied dwellings current year estimate; 5) owner occupied dwellings five year projection; 6) net change in owner occupied dwellings in five years; 7) total households current year estimate; 8) total household five year projection; 9) net change (number and %) in households in five years; 10) new movers; 11) new homeowners; 12) average household net worth; 13) average household income; 14) population 25+ years old; 15) population 25+ with some college education; 16) population 25+ with associate degree; 17) population 25+ with bachelor's degree; 18) population 25+ with graduate or professional degree; 19) percent population 25+ any college education; 20) households with length of residence less than one year; 21) percent households with length of residence less than one year; 22) total real estate transactions; 23) active property insurance casualty policies; 24) active life/financial insurance policies; 25) active insurance policies; 26) total insurance customer households; 27) total insurance customer household lifetime value; 28) average insurance customer household lifetime value; 29) value of expansion opportunity; 30) new businesses; 31) United States Postal Service (USPS) Delivery Units Statistics for delivered mail; and 32) United States Postal Service (USPS) Delivery Units Statistics for undelivered mail.
As those skilled in the art will realize, the above modeling factors and/or combinations of modeling factors do not represent an exhaustive list of modeling factors that may used in the determination of agency locations. As an alternative, to the individual selection of each of the modeling factors, templates may be defined with particular modeling factors to be used in the agency location model. For example, templates such as “Established but Still Growing” template 504 in
In another example, the “Communities in Progress” template 506 may identify growth opportunities in generally smaller communities experiencing recent change. This template 506 may only evaluate and score lower density rural/small town communities in the model. Modeling factors that may be utilized when the “Communities in Progress” template 506 is used may include: 1) new movers; 2) new homeowners; 3) percent households with length of residence less than one year; 4) new businesses; and 5) USPS quarterly delivery units statistics.
In step 208, a final score per zip code may be calculated. The calculation of the scores may be determined by the following equations:
(Variable 1 score*Variable 1 weight)+(Variable 2 score*Variable 2 weight)+(Variable 3 score*Variable 3 weight)+other Variables=Composite score Equation 2
In equations 1 and 3, μ represents the mean and σ represents standard deviation of the individual variables and variable scores multiplied by their variable weights. A positive score reflects greater potential for future business growth in the particular geographic region of interest. A negative score reflects less opportunity for future growth relative to the variation within each geographic region. For example,
A score per variable 617 using equation 1 is calculated for each of the zip codes listed 602, 604, and 606 as shown in Table 2 of
Next, equation 3 is applied to each of zip codes 602, 604, and 606 as illustrated in Tables 1 and 2 of
The final scores for each zip code may be displayed along with additional profile information which may be of interest to the user. For example, the final scores may be integrated with profile information to create new perspectives and insights regarding each market. An example of such profile information is illustrated in
Any of the selected zip codes may be displayed on a map such that specific point locations and surrounding areas may be interactively defined with respective model outputs and information generated for surrounding areas. For example,
A few examples of a few embodiments of the invention are provided below. These examples describe only versions of a few embodiments of the invention. The invention is not limited to the examples described below and includes numerous additional embodiments and versions. The examples should not be read to limit the disclosure of the invention in this application.
An insurance agency location is determined through steps of (1) receiving from a user at least one geographic region to be evaluated for placement of the insurance agency location, (2) based on at least one geographic region received in step (1), determining related zip codes to be evaluated, (3) receiving from the user at least one modeling factor to be utilized in the determination of the insurance agency location, (4) calculating at a processor a final score for each of the zip codes determined in step (2); and (5) comparing the final scores for each of the zip codes to determine the zip code with the highest final score The receiving, determining, calculating and comparing can be performed by a computer. They also can be performed by a person. In addition, the modeling factors that may be used include one or more of the following: total and net change in households in current year and last five years; number of new homeowners and new movers; percentage of population with at least twenty five years of age and some college education; percentage of households with length of residency of less than one year; total number of agency customer households; total number of new businesses; agency customer household lifetime value; whether or not household maintains 2 or more vehicles; whether a dwelling is owner occupied; average household income; average household net worth; and/or change in the number of postal delivery units.
The location for an insurance agency is determined using at least the following steps. A geographic region to be evaluated for placement of the insurance agency location is received from a user. Based on this geographic region, particular zip codes are identified to be evaluated. A composite score is calculated for each zip code. A final score is then calculated at a processor for each of the zip codes using the formula
Composite Score−μ=Final Score
The final scores are compared to each other to determine the relative ranking. The final scores may be displayed on a map and/or summarized and detailed in a report.
A computer-readable medium contains computer-executable instructions for causing a computer device to perform a number of steps. These steps include (a) receiving from a user zip codes to be evaluated for placement of an insurance agency location; (b) receiving from research terminal 102, 104 modeling factors to be utilized in the determination of the insurance agency location; (c) calculating at a processor a final score for each of the zip codes received in step (a); (d) comparing the final scores for each of the zip codes to determine the zip code with the highest final score; and (e) displaying the final scores for each of the zip codes on a map and/or report that contains at least street level information.
In another aspect of the invention, final scores for each zip code may be displayed along with additional information which may be useful to the user such as a calculated distance to a coastline or shoreline for use assessing additional risk factors. Those skilled in the art will realize that if a particular site location is within a defined distance range of a risk border such as a coastline or shoreline, then the site location may be treated as subject to increased underwriting scrutiny and consideration. For instance, a potential insurance agency location located near a coastline or shoreline may acquire customers that represent additional risks from hurricanes and other perils due to the close proximity to the coastline or shoreline.
Those skilled in the art will realize that in various aspects of the invention, a coastline and/or shoreline refers to a line of contact between land and a body of water. Furthermore, those skilled in the art will realize that a body of water may include but is not limited to oceans, lakes, rivers, streams, canals, and/or reservoirs.
Furthermore, those skilled in the art will also realize that coastline and shoreline are only two such risk borders, which may be evaluated using distance calculations, and that other types of risk borders and associated perils include but are not limited to a host of natural events such as a volcanic eruption, earthquake, landslide, avalanche, flood, tsunami, hurricane, tornado, and/or wildfire and perils related to human activity such as toxic waste and/or industrial accidents. These perils and associated risk borders may also be considered in agency placement and displayed on an interactive map for further analysis.
In an aspect of the invention, updated and improved National Oceanic & Atmospheric Administration (NOAA) defined boundaries may be overlaid directly onto cartography maps. These overlays may allow for a clear picture of boundaries and the associated cartography. For instance,
In an aspect of the invention, calculating the distance to a shoreline involves manipulating data supplied from a NOAA shoreline data file. Each of the lines supplied in the NOAA shoreline data file may be broken up into individual line segments. Furthermore, each of the line segments may be defined by nodes. The generated nodes may include millions of nodes depending upon the extent of the original shoreline data files. In an embodiment to ensure accurate distance processing, a line segment coming into a node and a line segment leading away from the node may be identified, creating line segments on either side of the node.
In an aspect of the invention, the distance to the shoreline calculations after initial processing of the shoreline file may be completed on a state-by-state basis. In an embodiment, a program may be written to run several spatial queries to accomplish the calculations. The program may be run multiple times with a pass for each state. In another embodiment, larger states such as New York and Texas may be broken into multiple passes each based on estimated processing time. For each state, an estimate for the minimum possible distance a location may be to the shoreline is calculated. In an embodiment, the distance may be calculated between potential geographical agency or customer locations and the closest shoreline.
Given this, the angle AOB may be determined using the following formula:
Cos(AOB)=[{Cos(LatA)*Cos(LatB)}]*[{Cos(LongB−LongA)}+{Sin(LatA)*Sin(LatB)}]
Where LatA is the Y coordinate of point A and LongA is the X coordinate of point A. The distance between points A 1402 and B 1404 (and thus arc AB) may be calculated by R*(AOB). Where R is the radius of the earth and AOB is the angle the two points make with the center of the earth in radians.
In an aspect of the invention, the distance from each potential agency or customer location to all shoreline points that fall within circle 1304 may be calculated. All points may be evaluated and the shoreline point with the shortest distance to each potential agency/customer location may be selected and associated with each potential agency/customer location. The shoreline segments on either side of the shoreline node 1504 selected are extracted from the shoreline. Finally, the program may calculate the distances 1506 and 1508 of the potential agency/customer location to both shoreline segments and the shorter distance to the shoreline segments may be designated as the distance to shore as illustrated in
In another aspect of the invention, a calculated distance from a peril may be used as a modeling factor in determining the overall score for each zip code being analyzed for potential new office or branch location.
While the invention has been described with respect to specific examples including presently preferred modes of carrying out the invention, those skilled in the art will appreciate that there are numerous variations and permutations of the above described systems and techniques that fall within the spirit and scope of the invention.
This application is a continuation of co-pending U.S. application Ser. No. 14/341,276, filed Jul. 25, 2014, and entitled “Retail Deployment Model,” which is a continuation of U.S. application Ser. No. 13/517,878 (now U.S. Pat. No. 8,805,805), filed Jun. 14, 2012, which is a continuation of U.S. application Ser. No. 12/141,746, filed Jun. 18, 2008, now U.S. Pat. No. 8,219,535, issued Jul. 10, 2012, which claims the benefit of U.S. Provisional Application No. 60/952,989, filed Jul. 31, 2007, and which is a continuation-in-part of U.S. application Ser. No. 11/461,512, filed Aug. 1, 2006, which claims the benefit of U.S. Provisional Application No. 60/743,295, filed Feb. 15, 2006, the disclosures of which are herein incorporated by reference in their entirety.
Number | Date | Country | |
---|---|---|---|
60743295 | Feb 2006 | US | |
60952989 | Jul 2007 | US |
Number | Date | Country | |
---|---|---|---|
Parent | 14341276 | Jul 2014 | US |
Child | 15441503 | US | |
Parent | 13517878 | Jun 2012 | US |
Child | 14341276 | US | |
Parent | 12141746 | Jun 2008 | US |
Child | 13517878 | US |
Number | Date | Country | |
---|---|---|---|
Parent | 11461512 | Aug 2006 | US |
Child | 12141746 | US |