System and method for cell site performance management

A method of assessing metrics associated with cell sites to manage cell site performance, comprising:

• reading, by a server communicatively coupled to a network, revenue data and usage data from call detail records in a data store, wherein the usage data comprises data about cell site usage of each of a plurality of wireless communication service subscribers, and wherein the revenue data comprises data about revenue obtained by a wireless communication service provider from each of the wireless communication service subscribers;
• analyzing, by the server, the usage data for each mobile device associated with a subscriber to determine a set of cell sites used by each mobile device associated with the subscriber, wherein the set of used cell sites is identified from among a plurality of cell sites operated by the wireless communication service provider;
• based on the analysis of usage data and the determination of the set of cell sites used by each mobile device, determining, by the server, that a mobile device uses cell sites in a different location from cell sites corresponding to a number plan area code and a central office code for the mobile device;
• associating, by the server, a portion of the revenue data for each mobile device to the set of cell sites used by that mobile device irrespective of the number plan area code and the central office code associated with the mobile device;
• reading, by the server, expense data for each of the plurality of cell sites from a data store, wherein the expense data comprises the expense of operating the cell site;
• reading, by the server, capital cost data for each of the plurality of cell sites from a data store, wherein the capital cost data represents the capital cost associated with the cell site;
• determining, by the server, a return on invested capital (ROIC) value for each of the plurality of cell sites based on the portion of revenue data of each subscriber associated to the cell site, based on the expense data associated to the cell site, and based on the capital cost data associated to the cell site;
• storing, by the server, the return on invested capital (ROIC) value for each cell site in a data store comprising cell site information, wherein the data store comprising cell site information is accessible to users associated with a plurality of workstations;
• accessing, by the server, the data store comprising cell site information to retrieve the ROIC value for each of the plurality of cell sites;
• identifying, by the server, cell sites with ROIC values above a predefined threshold, wherein the identified cell sites with ROIC values above the predefined threshold are classified as profitable cell sites;
• classifying, by the server, cell sites with ROIC values below the predefined threshold as unprofitable cell sites;
• determining, by the server, the metrics corresponding to the profitable cell sites and the metrics corresponding to the unprofitable cell sites, wherein the metrics comprise subscriber details, locations, and markets associated with the cell sites;
• comparing, by the server, the metrics corresponding to the profitable cell sites with the metrics corresponding to the unprofitable cell sites, wherein differences among the cell sites are identified;
• determining, by the server, changes to be implemented at the unprofitable cell sites to optimize metrics and increase ROIC values based on the differences among the cell sites;
• compiling, by the server, information obtained from the cell site classification and comparison of metrics corresponding to the profitable cell sites and the unprofitable cell sites, wherein the compiled information is represented as one of a coverage map, histogram, graph, or pie chart illustrating profitable cell sites and unprofitable cell sites, along with corresponding metrics;
• sending, by the server via a network, the compiled information to a workstation;
• and
• recommending, by the server to the workstation via the network, changes to be implemented at the unprofitable cell sites based on the compiled information.

A method of managing cell site performance based on evaluating subscriber usage of cell sites in various markets, comprising:

• reading, by a server communicatively coupled to a network, revenue data and usage data from a data store, wherein the usage data comprises data about cell site usage of each of a plurality of wireless communication service subscribers, and wherein the revenue data comprises:
• data about revenue obtained by a wireless communication service provider from each of the wireless communication service subscribers, and
• data about service revenue that is non-specific to any cell sites, wherein the service revenue is prorated across a plurality of cell sites;
• analyzing, by the server, the usage data for each mobile device associated with a subscriber to determine a set of cell sites used by each of mobile device associated with the subscriber, wherein the set of used cell sites is identified from among a plurality of cell sites operated by the wireless communication service provider;
• based on the analysis of usage data and the determination of the set of cell sites used by each mobile device, determining, by the server, that a mobile device uses cell sites in a different location from cell sites corresponding to a number plan area code and a central office code for the mobile device;
• associating, by the server, a portion of the revenue data for each mobile device to the set of cell sites used by that mobile device irrespective of the number plan area code and central office code associated with the mobile device;
• reading, by the server, expense data for each of the plurality of cell sites from a data store, wherein the expense data represents the expense of operating the cell site;
• reading, by the server, capital cost data for each of the plurality of cell sites from a data store, wherein the capital cost data represents the capital cost associated with the cell site;
• determining, by the server, a return on invested capital (ROIC) value for each of the plurality of cell sites based on the portion of revenue data of each subscriber associated to the cell site, based on the expense data associated to the cell site, and based on the capital cost data associated to the cell site;
• storing, by the server, the return on invested capital (ROIC) value for each cell site in a data store comprising cell site information, wherein the data store comprising cell site information is accessible to users associated with a plurality of workstations;
• and
• recommending, by the server to a communicatively coupled work station computer system, to one of perform a technology upgrade on a selected cell site, perform an adjustment procedure on the selected cell site, or build a new cell site proximate to the selected cell site based on the return on invested capital of the selected cell site.