Overview: Rate Wizard
The process of creating a rate using the Rate Wizard is dependent upon an understanding of utility tariffs. Care must be taken when creating rates from tariff information, as they tend to be vague, and open to interpretation (see example).
Prior to creating a rate using the Rate Wizard it is advisable to document the rate in action – typically via a spreadsheet calculation.
Example: On 5/21/2001, a bill is received for $5,015.85 using 100,000 kWh and 70 kW. Use the rate’s properties to manually calculate the bill with the usage of 100,000 kWh and 70 kW.
|
Customer Charge: |
$150.00 month |
|
Energy Charge: |
$0.101 for the first 150 kWh per kW $0.08 for the next 100 kWh per kW $0.009 for the next 300 kWh per kW $0.008 for the remaining kWh |
|
Demand Charge: |
$5.56 for all kW over 5kW |
|
Energy Adjustment: |
Amount determined in accordance with rider EAJ. The adjustment appears on the monthly bill - our example has an adjustment of 0.0181 $/kWh |
|
State Tax: |
Not included in the tariff but assume a state tax of 8.5% |
This rate tariff states that peak demand is charged at "$5.56 for each kW of demand in excess of 5 kW."
Note: No mention of demand step sizes are given but are used in the demand calculation – this is where the tariff interpretation comes in.
In this example we find that the calculations are correct – the calculated cost is equal to the bill’s total cost.
|
05/21/2001 |
Use |
100,000 |
kWh |
|
|
|
|
|
Demand |
70 |
kW |
|
|
|
|
|
Total Cost |
$5,015.85 |
|
|
|
|
|
Customer Charge |
|
|
|
|
$150.00 |
|
|
Energy |
step size |
* billing demand |
Actual Step used |
$/kWh |
|
Energy Cost |
|
Step 1 |
150 |
70 |
10,500 |
0.101 |
|
1,060.50 |
|
Step 2 |
100 |
70 |
7,000 |
0.08 |
|
560.00 |
|
Step 3 |
300 |
70 |
21,000 |
0.009 |
|
189.00 |
|
Step 4 |
remainder |
|
61,500 |
0.008 |
|
492.00 |
|
|
|
Use check |
100,000 |
Usage Subtotal |
$2,301.50 |
|
|
Demand |
step size |
|
Actual Step used |
$/kW |
|
Demand Cost |
|
Step 1 |
5 |
|
5 |
0 |
|
0 |
|
Step 2 |
remainder |
|
65 |
5.56 |
|
361.4 |
|
|
|
demand check |
70 |
Demand Subtotal |
$361.40 |
|
|
Energy Adjustment |
Use |
$/kWh |
|
|
Engy-Adj Cost |
|
|
|
|
100,000 |
0.0181 |
|
|
$1,810.00 |
|
Subtotal |
|
|
|
|
|
|
|
|
|
|
|
Subtotal cost |
$4,622.90 |
|
|
Tax |
Subtotal of cost |
Tax % |
|
|
Tax Cost |
|
|
|
$4,622.90 |
|
8.50% |
|
|
$392.95 |
|
|
|
|
|
Total Cost |
$5,015.85 |
|
