Billing Variance Table Maintenance

Use Billing Variance Table Maintenance to maintain the variance ranges used to compare the customers' present consumptions with their past consumptions. This table is used when printing the Billing Exception Report.

Note:

How Billing Exception Variances are calculated
The usage is converted to daily usage for the calculation and comparison. The number of days for the historical service period is calculated and is then used to calculate each customer's daily historical usage = history usage / #of days. The number of days in the current billing period is determined and is used to calculate each customer's daily usage for the current reading period.
Exception Variance calculation: (current daily usage - historical daily usage)/historical daily usage = variance percentage
Note: The Application Options Exception Model setting specifies the historical usage to use.

Directions:

To open:

1. Click Daily Work from the menu.

2. Click File Maintenance.

3. Click Table Maintenance.

4. Click Billing Tables.

5. Click Billing Variance Table.

Tip: Or, use the keyboard shortcut: [ALT] [y] [m] [t] [b] [v].

Billing Variance Table Example:

Billing Variance Table Maintenance Prompts Tip: To indicate that you are building a new Billing Variance Table, New displays near the Bill-Var name. Default entries display and the first field is highlighted to let you know you can begin entering information.
	To update the new or changed information, click Save or press [ENTER]. Keyboard shortcut: [ALT + s]
	CAUTION To avoid losing data, you must save new or changed records.
	The Search function is not available during Billing Variance Table Maintenance.
	To display the Billing Variance Table, click Retrieve, or press [ENTER]. Keyboard shortcut: [ALT + t]
Title	Enter the title of the billing variance table. (up to 14 characters)
Description	Enter the full description of this table. (up to 79 characters)
Variance Up %	Enter the percentage the customer consumptions can vary upward from their past consumptions without being considered an exception that prints on the report. (6.2 numeric)
Variance Down %	Enter the percentage the customer consumptions may vary downward from their past consumptions without being considered an exception that prints on the report. (6.2 numeric)

Opening Billing Variance Table Maintenance, click More.
Creating a new Billing Variance Table, click More.
Editing an existing Billing Variance Table, click More.
CAUTION: To avoid losing data, you must save new or changed records.
1. To position the pointer to the information that you want to change, press [TAB] or click the field using the mouse.
2. Enter the data changes.
3. To complete the edit process, click Save , or press [ENTER] if the button is in focus.
  Keyboard shortcut: [ALT + s]
Deleting an existing Billing Variance Table, click More.

The Delete Command is not available for Billing Variance Table Maintenance.