Retail deployment model
11587178 · 2023-02-21
Assignee
Inventors
- Larry Shigeo Kobori (Newark, CA)
- Carl Katsumi Mayeda (Cupertino, CA, US)
- Priya Sahai (Cupertino, CA, US)
Cpc classification
G06Q10/0637
PHYSICS
International classification
G06Q10/0637
PHYSICS
Abstract
A method of determining and optimizing the location of a new insurance agency is disclosed to increase market penetration of underrepresented markets. The method comprises the use of a scoring algorithm to rank various geographic regions or related zip codes. The scoring algorithm may be implemented by a location modeling system based on variables selected by a user. In addition, the various ranked geographic regions or related zip codes may be analyzed for proximity to natural or man made perils.
Claims
1. A method for determining an insurance agency location, the method comprising: receiving at least one geographic region comprising land from at least two zip codes to be evaluated for placement of the insurance agency location; displaying an interactive map having first boundaries; overlaying, on the interactive map, second boundaries to generate a high resolution definition of a displayed shoreline; generating a risk border comprising a plurality of geographical points abutting a source of peril and a plurality of line segments connecting the plurality of geographical points; receiving at least one distance band to the risk border; receiving modeling factors to be utilized in the determining of the insurance agency location; displaying the at least two zip codes and surrounding areas on the interactive map, the at least two zip codes and surrounding areas being interactively defined with model outputs for determining the insurance agency location and information associated with the at least two zip codes; determining the insurance agency location based on the received at least one distance band and a number of homeowners within the at least one distance band; calculating a final score for each of the at least two zip codes; ranking the final score for each of the at least two zip codes; and displaying the ranking for each of the at least two zip codes on the map.
2. The method of claim 1, further including displaying the number of homeowners within the at least one distance band, wherein displaying the number of homeowners within the at least one distance band includes displaying homeowner locations within the at least one distance band on a map.
3. The method of claim 2, wherein the map includes street level information.
4. The method of claim 2, wherein the map includes aerial imagery.
5. The method of claim 2, wherein the map includes use of 3D cartography.
6. The method of claim 1, further including displaying the number of homeowners within the at least one distance band, wherein the displaying the number of homeowners comprises displaying homeowner locations within the at least one distance band in a report.
7. The method of claim 1, further comprising: determining the number of homeowners within the received at least one distance band for the determined zip codes.
8. The method of claim 1, further including displaying the generated risk border on the interactive map.
9. The method of claim 1, wherein calculating the final score for each of the at least two zip codes comprises normalizing scores for each of the at least two zip codes based on a mean and standard deviation of the scores for each of the at least two zip codes.
10. The method of claim 1, wherein the risk border follows a boundary between a body of water and land.
11. A method for determining an insurance agency location, the method comprising: receiving at least one geographic region comprising land from at least two zip codes to be evaluated for placement of the insurance agency location; displaying an interactive map having first boundaries; overlaying, on the interactive map, second boundaries to generate a high resolution definition of a displayed shoreline; receiving modeling factors to be utilized in the determining of the insurance agency location; generating a risk border comprising a plurality of geographical points abutting a source of peril and a plurality of line segments connecting the plurality of geographical points; receiving distance bands to the risk border; displaying the at least two zip codes and surrounding areas on the interactive map, the at least two zip codes and surrounding areas being interactively defined with model outputs for determining the insurance agency location and information associated with the at least two zip codes; calculating a final score for each of the at least two zip codes based on the modeling factors and distance bands; ranking the calculated final score for each of the at least two zip codes; and displaying the ranking for each zip code on the interactive map.
12. The method of claim 11, wherein the interactive map comprises street level information, aerial imagery, and 3D cartography.
13. The method of claim 11, wherein the calculating the final score for each of the at least two zip codes comprises calculating a composite score for each of the at least two zip codes.
14. The method of claim 13, wherein the composite score comprises a weighted composite score.
15. The method of claim 11, further including displaying the generated risk border on the interactive map.
16. The method of claim 11, wherein the map includes use of 3D cartography.
17. An apparatus comprising: a display; a memory; and a processor coupled to the memory and programmed with computer-executable instructions for performing steps comprising: receiving at least one geographic region comprising land from at least two zip codes to be evaluated for placement of an insurance agency location; displaying an interactive map having first boundaries; overlaying, on the interactive map, second boundaries to generate a high resolution definition of a displayed shoreline; generating a risk border including a plurality of geographical points abutting a source of peril; receiving a distance band to the risk border; receiving modeling factors to be utilized in a determination of the insurance agency location; displaying the at least two zip codes and surrounding areas on an interactive map, the at least two zip codes and surrounding areas being interactively defined with model outputs for determining the insurance agency location and information associated with the at least two zip codes; calculating, based on the distance band and the modeling factors, a final score for each of the at least two zip codes; ranking the calculated final score for each of the at least two zip codes; displaying the ranking of each of the at least two zip codes on the interactive map; and determining the insurance agency location based on the final scores.
18. The apparatus of claim 17, the processor further configured to perform the steps comprising: displaying homeowner counts within the distance band for each determined zip code; and displaying the final score for each zip code.
19. The apparatus of claim 18, wherein the displaying the homeowner counts within the distance band and the final scores comprises displaying the homeowner counts and the final scores on the interactive map.
20. The apparatus of claim 19, wherein the interactive map comprises street level information, aerial imagery, and 3D cartography.
Description
BRIEF DESCRIPTION OF THE DRAWINGS
(1) 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:
(2)
(3)
(4)
(5)
(6)
(7)
(8)
(9)
(10)
(11)
(12)
(13)
(14)
(15)
(16)
(17)
(18)
DETAILED DESCRIPTION
(19) Exemplary Operating Environment
(20) 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.
(21)
(22) 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.
(23) 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.
(24) 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.
(25) 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?”
(26) 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.
(27) One or more of the computer devices and terminals shown in
(28) 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.
EXEMPLARY EMBODIMENTS
(29)
(30)
(31) 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,
(32) 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
(33) 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.
(34) 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.
(35) 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.
(36) 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
(37) 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.
(38) In step 208, a final score per zip code may be calculated. The calculation of the scores may be determined by the following equations:
(39)
(Variable 1 score*Variable 1 weight)+(Variable 2 score*Variable 2 weight)+(Variable 3 score*Variable 3 weight)+other Variables=Composite score Equation 2
(40)
(41) 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,
(42) 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
(43) Next, equation 3 is applied to each of zip codes 602, 604, and 606 as illustrated in Tables 1 and 2 of
(44) 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
(45) 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,
(46) 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.
Example 1
(47) 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.
Example 2
(48) 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.
Example 3
(49) 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.
(50) 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.
(51) 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.
(52) 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.
(53)
(54) 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,
(55)
(56) 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.
(57)
(58) 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.
(59)
(60) 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)}]
(61) 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.
(62) 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
(63) 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.
(64)
(65)
(66)
(67) 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.