Example of Generating Prorated Bill Calculation Lines

Let's say that 1200 kWh was consumed from March 17 to April 30. The peak kW for the consumption period is 20 kW.

A monthly rate schedule E-COM1 exists with two rate versions.

Rate version effective prior to April 1 has the following components:

  • $0.05 per kWh.
  • $1.00 per kW.

Rate version effective as of April 1 has the following calculation rules:

  • $0.04 per kWh; as of April 16, $0.07 per kWh (new effective bill factor value).
  • $1.50 per kW; as of April 16, $1.25 per kW (new effective bill factor value).

Calculation Period March 17 to March 31

The consumption period spans 45 days, so the consumption period factor is 30 normal days / 45 days = 0.6666667.

This calculation period spans 15 days, so the calculation period factor is 0.5.

Service quantity proration for the first calculation period yields:

  • 1200 kWh x 0.6666667 (consumption period factor) x 0.5 (calculation period factor) = 400 kWh.
  • 20 kW x 1 (not applicable) = 20 kW.

Calculation rule value proration for the first calculation period yields:

  • $0.05 x 1 (not applicable) = $.05 per kWh.
  • $1.00 x 0.5 (calculation period factor) = $0.50 per kW.

First Set of Bill Calculation Lines

Bill calculation line 1: 400 kWh x $0.05 = $20.00.

Bill calculation line 2: 20 kW x $0.50 = $10.00.

Calculation Period April 1 to April 30

This calculation period spans 30 days, so the calculation period factor is 1.

Service quantity proration for the calculation period yields:

  • 1200 kWh x 0.6666667 (consumption period factor) x 1 (calculation period factor) = 800 kWh.
  • 20 kW x 1 (not applicable) = 20 kW.

Calculation rule value proration for the first calculation period yields:

  • $0.04 x 1 (not applicable) x 0.5 (BF value period factor) = $0.02 per kWh.
  • $0.07 x 1 (not applicable) x 0.5 (BF value period factor) = $0.035 per kWh.
  • $1.50 x 1 (calculation period factor) x 0.5 (BF value period factor) = $0.75 per kW.
  • $1.25 x 1 (calculation period factor) x 0.5 (BF value period factor) = $0.625 per kW.

Second Set of Bill Calculation Lines

Bill calculation line 1: 800 kWh x $0.02 per kWh = $16.00.

Bill calculation line 2: 800 kWh x $0.035 per kWh = $26.00.

Bill calculation line 3: 20 kW x $0.75 per kW = $15.00.

Bill calculation line 4: 20 kW x $0.625 per kW = $12.50.