Method of selecting the most cost effective cellular service plan provided by cellular telephone resellers to multi-line customers

• US 5,027,388 A
• Filed: 06/01/1990
• Issued: 06/25/1991
• Est. Priority Date: 02/01/1990
• Status: Expired due to Term

• Current Assignee: Motorola, Inc. (Motorola Solutions, Inc.)
• Original Assignee: Motorola, Inc. (Motorola Solutions, Inc.)
• Inventors: Baum, David M., Bradshaw, Andrea E., Rivera, Dionne A.
• Primary Examiner(s): SCHREYER, STAFFORD
• Application Number:
  US07/532,132
• Time in Patent Office: 389 Days
• Field of Search: 379/112, 379/111, 379/116, 379/119, 379/120, 379/121, 379/126, 379/127, 379/134, 379/135, 379/133, 379/59
• US Class Current: 379/114.1
• CPC Class Codes: G06Q 30/04 Billing or invoicing
• CPC Class Codes: H04M 15/00 Arrangements for metering, time-control or time indication ; Metering, charging or billing arrangements for voice wireline or wireless communications, e.g. VoIP
• CPC Class Codes: H04M 15/49 Connection to several service providers
• CPC Class Codes: H04M 15/51 for resellers, retailers or service providers
• CPC Class Codes: H04M 15/80 Rating or billing plans; Tariff determination aspects
• CPC Class Codes: H04M 15/8022 Determining tariff or charge band
• CPC Class Codes: H04M 15/8044 Least cost routing
• CPC Class Codes: H04M 15/8066 According to the number of recipients
• CPC Class Codes: H04M 15/8083 involving reduced rates or discounts, e.g. time-of-day reductions or volume discounts
• CPC Class Codes: H04M 2215/0152 General billing plans, rate plans, e.g. charge rates, numbering plans, rate centers, customer accounts
• CPC Class Codes: H04M 2215/0184 involving reduced rates or discounts, e.g. time-of-day reductions, volume discounts, cell discounts, group billing, frequent calling destination(s) or user history list
• CPC Class Codes: H04M 2215/2026 Wireless network, e.g. GSM, PCS, TACS
• CPC Class Codes: H04M 2215/32 Involving wireless systems
• CPC Class Codes: H04M 2215/42 Least cost routing, i.e. provision for selecting the lowest cost tariff
• CPC Class Codes: H04M 2215/46 Connection to several service providers
• CPC Class Codes: H04M 2215/54 Resellers-retail or service providers billing, e.g. agreements with telephone service operator, activation, charging/recharging of accounts
• CPC Class Codes: H04M 2215/74 Rating aspects, e.g. rating parameters or tariff determination apects
• CPC Class Codes: H04M 2215/7421 Determine tariff or charge band
• CPC Class Codes: H04M 2215/745 Least cost routing, e.g. Automatic or manual, call by call or by preselection
• CPC Class Codes: H04M 2215/7478 According to the number of recipients
• CPC Class Codes: H04W 4/24 : Accounting or billing

Abstract

A unique cellular telephone billing system (100) processes call detail records (102) of cellular telephone calls made by users of multi-line customers to produce invoices and reports containing consolidated billing, usage and cost information for the current and other eligible cellular service plans. The call detail records (301 and 302) for each user of a multi-line customer include a unique key identification number (311 and 321) and may include an information format (401 and 402) having variable-length sub-fields (411-415 and 421-423). A candidate file (136) is created from the customer detail pool file (112) by including active user records for multi-line customers and usage data is accumulated in summary records for each user. Eligible cellular service plans are identified for each user in the candidate file and costs for accumulated usage data are estimated under the current and eligible cellular service plans. The estimated costs for the current and eligible cellular service plans may then be compared to determine the most cost effective service plan for each user on the basis of current average usage or rate plan level, account level or market level aggregate average usage. Reports may be generated for each multi-line user illustrating consolidated billing, usage and cost information by sorting on the basis of the corresponding key identification number and information format.

Claims

1. A method of selecting one of a plurality of rate plans for cellular radiotelephone users each having corresponding user records from one or more cellular systems gathered in a billing pool, said billing pool including user records for at least a current billing period and a previous billing period, each user record including a current rate plan and usage information for the current and previous billing periods, said method comprising the steps of:

a) selecting all user records from the billing pool for each cellular radiotelephone user which has non-zero usage information for the current billing period;

b) creating a current usage pool and a previous usage pool by accumulating the usage information in the selected user records for the current billing period and the previous billing period, respectively;

c) creating a summary user record for each cellular radiotelephone user by accumulating the usage information in all corresponding user records;

d) appending current and previous usage pools to each summary user record;

e) calculating costs for each cellular radiotelephone user based upon the accumulated usage information in the corresponding summary user record and at least two of the rate plans; and

f) selecting for each cellular radiotelephone user the rate plan which has the lowest calculated cost.

2. The method according to claim 1, further including the step of presenting, for each cellular radiotelephone user, the corresponding selected rate plan, current rate plan, and accumulated usage information in human perceptible form.

3. The method according to claim 1, wherein said step a) further includes the step of excluding all user records for each cellular radiotelephone which has changed current rate plans during the current or previous billing periods.

4. The method according to claim 1, wherein said step a) further includes the step of creating a sequence number associated with a selected radiotelephone user.

5. The method according to claim 4, wherein said step a) further includes the step of sorting said selected user records in accordance with said sequence number.

6. The method according to claim 1, wherein said step a) further includes the step of adding to each user record a key identification number and an information format having at least one sub-field associated with at least one user;

and wherein said method further includes the steps of sorting the summary user records by at least one key identification number to produce a file of summary user records for said at least one key identification number, selecting information from the summary user records in said file in accordance with said information format, and presenting said summary user records in human perceptible form.

7. A key account billing controller for use with a digital computer, the controller comprising:

a computer program storage medium having a computer program to be executed by the digital computer stored thereon, the computer program comprising;

first means for processing cellular radiotelephone call data including a multiplicity of user records from one or more cellular systems gathered in a billing pool for billing users and adding to each user billing record a key identification number and an information format having at least one sub-field associated with at least one user; and

second means for selecting all user records from the billing pool for each cellular radiotelephone user which has non-zero usage information for the current billing period, creating a current usage pool and a previous usage pool by accumulating the usage information in the selected user records for the current billing period and the previous billing period, respectively, creating a summary user record for each cellular radiotelephone user by accumulating the usage information in all corresponding user records, appending current and previous usage pools to each summary billing record, and calculating costs for each cellular radiotelephone user based upon the accumulated usage information in the corresponding summary user record and at least two of the rate plans; and

third means for sorting the summary user records by at least one key identification number to produce a file of summary user records for said at least one key identification number, selecting information from the summary user records in said file in accordance with said information format, and presenting said summary user records in human perceptible form.