Patent ID: 7885851

Claim:
A method for obtaining an optimal number of retailers in a geographical area, the method comprising the steps of: obtaining demographical data for a plurality of regions, each region being identified by a region identifier, the demographical data containing population information, retailer count, sales figures, retailer density count, and per capita sales information, the demographical data being segmented into subgroups and inputting same into a computerized spreadsheet containing the region identifier and demographical data; sorting the region identifiers in descending order based on the retailer count and omitting any region identifiers with zero retailer count; for each subgroup: sorting the remaining region identifiers via the electronic spreadsheet based on a population of the selected subgroup and further omitting any of the plurality of regions with a zero population for the subgroup; sorting the remaining region identifiers based on per capita sales using the computerized spreadsheet; determining a top percentage of regions from the resulting region identifiers based on the population information wherein the top percentage comprises selecting a percentage of the region identifiers for analysis after using the computerized spreadsheet to rank at least one of the demographical data categories of the subgroup, determining an average sales figure for the top percentage of regions via the computerized spreadsheet, determining an average retailer density count for the top percentage of regions using the computerized spreadsheet; and computing via the computerized spreadsheet the optimal number of retailers based on the average sales figure and average density count.