System and method for determining optimal wireless communication service plans based on spectrum licenses

A method, comprising the steps of:

• receiving billing information associated with a subscriber of a telecommunication service under a current rate plan;
• processing the subscriber related billing information to produce organized data in a calling profile record for each telecommunication service being used by the subscriber;
• determining cost of the current rate plan;
• determining cost of at least one other rate plan;
• and
• determining at least one proposed rate plan from the at least one other rate plan of at least one telecommunication service provider that would save the subscriber telecommunication costs relative to the current rate plan;
• wherein the step of processing the subscriber related billing information to produce organized data in a calling profile record comprises the steps of:
• determining a telephone number from where a call, within a series of calls, is made by the subscriber;
• determining a zip code associated with the telephone number;
• determining a license code associated with the zip code;
• and
• determining a charge for the call associated with the license code;
• wherein each call within the series of calls that is not made from a home zip code is separated by an originating city zip code and an originating state zip code, and a total number of minutes within each originating city zip code and Within each originating state zip code is stored with the associated zip codes;
• and
• wherein if there are four or fewer zip codes, the zip codes are written to the calling profile record in descending order by the amount of minutes for each zip code.

A method, comprising the steps of:

• receiving billing information associated with a subscriber of a telecommunication service under a current rate plan;
• processing the subscriber related billing information to produce organized data in a calling profile record for each telecommunication service being used by the subscriber;
• determining cost of the current rate plan;
• determining cost of at least one other rate plan;
• and
• determining at least one proposed rate plan from the at least on other rate plan of at least one telecommunication service provider that would save the subscriber telecommunication costs relative to the current rate plan;
• wherein the step of processing the subscriber related billing information to produce organized data in a calling profile record comprises the steps of:
• determining a telephone number from where a call, within a series of calls, is made by the subscriber;
• determining a zip code associated with the telephone number;
• determining a license code associated with the zip code;
• and
• determining a charge for the call associated with the license code;
• wherein each call within the series of calls that is not made from a home zip code is separated by an originating city zip code and an originating state zip code, and a total number of minutes within each originating city zip code and within each originating state zip code is stored with the associated zip codes;
• the method further comprising the following steps:
• if there are more than a predetermined number of zip codes, writing the zip code with the highest number of minutes to a first portion of the calling profile record;
• grouping remaining zip codes by combining zip codes with the same first three digits and adding associated minutes;
• if there are more than a predetermined number minus one zip codes remaining, writing the zip code with the highest number of minutes to a second portion of the calling profile record;
• grouping remaining zip codes by combining zip codes with the same first two digits and adding associated minutes;
• if there are more than the predetermined number minus two zip codes remaining, writing the zip code with the highest number of minutes to a third portion of the calling profile record;
• and
• grouping remaining zip codes by combining zip codes with the same first digit and adding associated minutes and writing the zip code with the highest number of minutes to a fourth portion of the calling profile record.

A system, comprising:

• means for receiving billing information associated with a subscriber of a telecommunication service under a current rate plan;
• means for processing the subscriber related billing information to produce organized data in a calling profile record for each telecommunication service being used by the subscriber, the means for processing being communicatively coupled to the means for receiving;
• means for determining cost of the current rate plan, the means for determining cost of the current rate plan being communicatively coupled to the means for processing and the means for receiving;
• means for determining cost of at least one other rate plan, the means for determining cost of at least one other rate plan being communicatively coupled to the means for determining cost of the current rate plan, the means for processing, and the means for receiving;
• and
• means for determining at least one proposed rate plan from the at least one other rate plan of at least one telecommunication service provider that would save the subscriber telecommunication costs relative to the current rate plan, the means for determining at least one proposed rate plan being communicatively coupled to the means for determining cost of at least one other rate plan, the means for determining cost of the current rate plan, the means for processing, and the means or receiving;
• wherein the means for determining cost of the current rate plan performs the following:
• determines a telephone number from where a call, within a series of calls, is made;
• determines a zip code associated with the telephone number;
• determines a license code associated with the zip code;
• and
• determines a charge for the call associated with the license code.

A system, comprising:

• at least one transceiver configured to receive billing information associated with a subscriber of a telecommunication service under a current rate plan;
• a storage unit configured to store the billing information, wherein the storage unit is communicatively coupled to the transceiver;
• a memory comprising software, wherein the memory is communicatively coupled to the transceiver and the storage unit;
• and
• a processor, communicatively coupled to the transceiver, storage unit, and memory, configured by the software to:
• process the subscriber related billing information to produce organized data in a calling profile record for each telecommunication service being used by the subscriber;
• create a usage history table and a call detail table within the storage unit from the processed billing information in accordance with a specified billing period;
• determine the cost of the current rate plan;
• determine the cost of at least one other rate plan via use of the usage history table and call detail table;
• determine at least one proposed rate plan from the at least one rate plan of at least one telecommunication service provider that would save the subscriber telecommunication costs relative to the current rate plan;
• and
• produce a report of the at least one proposed rate plan to enable selection of a best telecommunication service provider and a best rate plan;
• wherein the transceiver is configured to transmit the report;
• and
• wherein determining at least one proposed rate plan is performed by:
• providing a training set of data comprising the at least one proposed rate plan;
• providing a test set of data comprising a most recent rate plan selected, wherein the most recent rate plan is one of a group of rate plan made of the at least one rate plan;
• comparing the at least one proposed rate plan from the training set to the most recent rate plan of the test set;
• and
• determining an ability of the training set to predict cost results of the test set.

A computer readable medium having a computer program stored thereon, the computer readable medium comprising:

• logic configured to process subscriber related billing information to produce organized data in a calling profile record for each telecommunication service being used by the subscriber, where the subscriber is under a current rate plan;
• logic configured to create a usage history table and a call detail table from the processed billing information in accordance with a specified billing period;
• logic configured to determine the cost of the current rate plan;
• logic configured to determine the cost of at least one other rate plan via use of the usage history table and call detail table;
• and
• logic configured to determine at least one proposed rate plan from the at least one rate plan of at least one telecommunication service provider that would save the subscriber telecommunication costs relative to the current rate plan;
• wherein the logic configured to determine the cost of the current rate plan, also:
• determines a telephone number from where a call is made;
• determines a zip code associated with the telephone number;
• determines a license code associated with the zip code;
• and
• determines a charge for the call associated with the license code.

A system, comprising:

• p1 a storage unit configured to store billing information associate with a subscriber of a telecommunication service under a current rate plan;
• a memory comprising software, wherein the memory is communicatively coupled to the storage unit;
• and
• a processor, communicatively coupled to the storage unit, and memory, configured by the software to:
• process the subscriber related billing information to produce organized data in a calling profile record for each telecommunication service being used by the subscriber;
• determine cost of the current rate plan;
• determine cost of at least one other rate plan;
• determine at least one proposed rate plan from the at least one other rate plan of at least one telecommunication service provider that would save the subscriber telecommunication costs relative to the current rate plan;
• and
• produce a report of the at least one proposed rate plan enable selection of a best telecommunication service provider and a best rate plan;
• wherein the processor determining cost of the current rate plan is performed by the processor:
• determining a telephone number from where a call is made;
• determining a zip code associated with the telephone number;
• determining a license code associated with the zip code;
• and
• determining a charge for the call associated with the license code.