Hotel fixed versus index component calculator

What comparison does this calculator make?

This tool compares two energy-price components over the same entered volume. It multiplies kilowatt-hours by the difference between a fixed component price and an assumed index component price. A positive result means the fixed component costs more under that assumption; a negative result means it costs less. The result is a scenario, not a prediction of future market prices.

This is deliberately narrower than comparing complete supplier agreements. Two products may allocate capacity, transmission, losses, ancillary services, fees, taxes, volume risk, and credit obligations differently. A lower displayed component does not establish a lower complete cost. Confirm equal inclusions before using the arithmetic in a purchasing decision.

What inputs belong in the fields?

Enter the volume in kilowatt-hours for the period you want to compare. Enter both prices in dollars per kilowatt-hour. For example, 8.5 cents per kWh is $0.085 per kWh. Entering 8.5 into a dollar field creates a hundredfold unit error. Keep written units beside the source figures when transferring them from a bid sheet.

Use a fixed price for the specified component and an assumed average index price for the equivalent component. Neither field should contain an all-in bill average while the other contains only energy supply. If a broker fee or supplier adder is included in one price, account for its treatment in the other. Ask how compensation is reflected rather than assuming that the labels imply equal coverage.

The Pennsylvania business shopping guidance supports examining business supply choices in that jurisdiction. It does not establish choice eligibility in another state or approve a particular hotel contract. The actual account, utility, and agreement determine what can be purchased.

How does a worked scenario look?

For illustration, 840,000 kWh multiplied by the difference between $0.085 and $0.080 per kWh equals $4,200. Under those hypothetical component assumptions, the fixed component costs $4,200 more. If the assumed index were $0.090 instead, the difference would be negative $4,200. These figures are invented examples, not a current rate, an offer, or an observed outcome.

The tool starts with blank inputs because it cannot supply a live market assumption. Choosing the index value is a user judgment requiring its own evidence. The assumed index field accepts a negative value if that is the scenario you intend; confirm how the agreement treats negative settlement prices and adders. Consider several assumptions and retain the reasoning behind them. Do not present the most favorable scenario as the expected result.

Why can actual indexed costs differ?

An indexed agreement may settle using interval usage, a named market location, specified publication, and contract adjustments. A simple average index can differ from the hotel’s load-weighted cost. Higher usage during expensive hours can matter even when the unweighted average appears modest. A block-and-index structure introduces purchased blocks and residual exposure that this calculator does not model.

The EIA overview of electricity price factors explains why fuel, infrastructure, weather, and other conditions influence prices. It does not forecast the settlement index for this property. Use the supplier’s defined formula and interval data when evaluating actual exposure.

How should a purchasing team use the result?

Begin with matching service periods and component coverage. Document fixed exclusions, the index formula, supplier adders, compensation, volume provisions, notice windows, credit requirements, and termination consequences. Then compare scenarios against the hotel’s budget tolerance and operational ability to respond. A financial scenario does not establish that staff can shift laundry, cooling, or guest-service loads during high-price intervals.

The break-even for identical components and equal volume occurs when the assumed index equals the fixed component price. Different fixed fees or coverage require a fuller model. Review fixed, index, and block-and-index structures and the Five-Clause Contract Check before treating this component worksheet as part of a complete offer evaluation. Keep the input evidence and contract assumptions with the output so the decision can be reviewed later.