Energy Bill with Entered Progressive Tiers

Calculate using the labelled inputs: Energy Bill with Entered Progressive Tiers.

Consumption allocated to tiers (kWh)
220
Rounded variable energy charge
36.00
Total with fixed charge
41.00
Rounded variable charge per kWh
0.1636363636
Total charge per kWh including fixed charge
0.1863636364
Tiers with positive consumption
3
Price of the last used tier per kWh
0.3

Calculation and assumptions

variable=round(Σ(consumption_in_tier·tier_price),2); total=variable+fixed; average=displayed_charge/consumption.

Each price applies only to consumption inside its tier, not to all consumption. Enter increasing cumulative limits, not tier widths; only the final limit may be zero for unlimited capacity. Without that final row, consumption above the last limit is rejected. Separate rows by newline or semicolon, columns by spaces. Limits, usage and rates allow six decimals, fixed charge two. Sum exact tier costs before one rounding to cents, halves away from zero. Averages use displayed rounded charges. Zero usage keeps the fixed charge and gives dashes for averages and last-used price. Enter all rates yourself; taxes, discounts and legal eligibility are not inferred. In one chosen two-decimal currency; no taxes or current market rates are supplied.

Frequently asked questions

How is the result calculated?

variable=round(Σ(consumption_in_tier·tier_price),2); total=variable+fixed; average=displayed_charge/consumption.

What assumptions apply?

Each price applies only to consumption inside its tier, not to all consumption. Enter increasing cumulative limits, not tier widths; only the final limit may be zero for unlimited capacity. Without that final row, consumption above the last limit is rejected. Separate rows by newline or semicolon, columns by spaces. Limits, usage and rates allow six decimals, fixed charge two. Sum exact tier costs before one rounding to cents, halves away from zero. Averages use displayed rounded charges. Zero usage keeps the fixed charge and gives dashes for averages and last-used price. Enter all rates yourself; taxes, discounts and legal eligibility are not inferred. In one chosen two-decimal currency; no taxes or current market rates are supplied.

How precise are the results?

Monetary totals use two decimal places with the stated rounding rule; other numbers show up to ten significant digits. Display precision does not improve input accuracy.

Also try:

Back to category →