Stepped Taxes
This is a difficult example. You should take the time to understand it even if you don't have stepped taxes because it illustrates the power of the various rate algorithms.
The following table illustrates the rate components necessary to levy a simple rate that contains the following charges:
- $0.10 per kWh.
- Service charge of $6.00
- Taxes are stepped:
- 6.383% for the anything up to $10
- 9.89% for everything above $10
Note that the dollar amount should be prorated if the bill is prorated.
Seq # |
Description |
RC Type |
Value Type |
Value |
UOM/TOU/SQI |
Cross Reference |
Calc Only |
Result Type |
10 |
Energy Charge |
Service Quantity |
Unit Rate |
0.10 |
KWH |
N |
||
20 |
Customer Charge |
Flat |
Charge |
6.00 |
N |
|||
30 |
Total Taxable Revenue |
Summary |
10, 20 |
Y |
Charge |
|||
40 |
Taxable Rev for 1st tax tier |
Maximum |
Charge |
10.00 |
30 |
Y |
Charge |
|
50 |
Taxable Rev for 1st tax tier |
Summary |
30, 40 |
Y |
Charge |
|||
60 |
Taxable Rev for 2nd tax tier |
Apply To |
Percent |
-100.00 |
50 |
Y |
Charge |
|
70 |
Taxable Rev for 2nd tax tier |
Summary |
30, 60 |
Y |
Charge |
|||
80 |
Tax for 1st tier |
Apply to |
Percent |
6.383 |
50 |
N |
||
90 |
Tax for 2nd tier |
Apply to |
Percent |
9.89 |
70 |
N |
Notice that sequences 30, 40, 50, and 60 are calculation-only rate components that are used to calculate the amount of revenue applicable for each tax rate. We'll let you work the math.