Electricity quote units and decimal errors

A quote sheet can display 95 in one column and 0.095 in another. They might represent the same price, radically different prices, or different cost components. The reviewer needs the units and scope before deciding which interpretation applies. Decimal precision is useful only when the underlying field is understood.

The contracts hub connects this check with offer approval. This guide provides a dimensional and arithmetic review, not a market-rate recommendation. Its output is a comparison that another employee can reproduce from the written quotation without guessing what a number means.

Which fields must be written beside the rate?

Record currency, price unit, component, service period and the quantity to which the rate applies. Identify whether the field represents a quoted offer, a market reference, an estimated component or a fixed fee. Those categories may appear together in a spreadsheet but should not be treated as one undifferentiated rate.

The 2025 New York business filing contains priced business-exhibit fields. These dated forms illustrate why the approved price belongs with defined scope and accounts; blank or illustrative fields are not current offers.

Retain the original notation. If the supplier writes a currency symbol and a unit in separate headings, capture both when transferring the number. Copying a cell into another workbook can discard the heading that made it intelligible. A price without its source label should remain unresolved until clarified.

What physical conversions are relevant?

EIA’s electricity-measurement explanation separates power from energy and describes metric units. A megawatt-hour contains 1,000 kilowatt-hours. For an equivalent energy-component price, that relationship connects dollars per MWh and dollars per kWh.

Currency representation is another conversion: one dollar is 100 cents. Apply the physical and currency conversions explicitly rather than moving the decimal by intuition. Record the conversion factor so an independent reviewer can see why the resulting number is different.

Do not use a unit conversion to erase differences in product scope. Two correctly normalized rates can cover different components, periods or quantity conditions. The arithmetic establishes a common representation; the agreement determines whether the offers are commercially comparable.

How should an independent test amount be calculated?

Assume a fictional energy quantity of 100,000 kWh and the assumed component price shown in the table. Multiplying by $0.095/kWh gives $9,500. Separately convert the energy quantity to 100 MWh and multiply by $95/MWh; that also gives $9,500.

These prices and quantities are invented teaching inputs, not current rates or supplier offers. Delivery, taxes, other components and additional fees are outside the example. Agreement-specific quantity treatment must be confirmed before using the method on an actual invoice.

Now assume an analyst mistakenly enters $0.0095/kWh. The same energy quantity produces $950, one-tenth of the intended example amount. A spreadsheet can multiply that mistaken input perfectly. The independent equivalent-unit calculation is what exposes the decimal problem; a formula’s successful execution does not prove the input was correct.

Why are power and energy charges not interchangeable?

An energy rate applies to an energy quantity, while a demand-related rate can apply to a defined power measure. Identify the applicable billing method and period before computing either amount. Do not multiply every field by monthly kWh merely because that is the most visible quantity on the bill.

Separate customer fees, demand components, energy components and other agreed adjustments into distinct calculations. Combine only their dollar results within the stated boundary. If management wants an effective cost per kWh, describe it as a derived summary using the specified total and energy denominator, not as the original contractual rate.

Keep the index-settlement guide alongside this check where a market reference is involved. A correct dollar/MWh conversion can still use the wrong series or location. Unit validation and source-reference validation answer different questions.

How are included components and compensation checked?

Read the full quotation and exhibit rather than relying on the top-line rate. Ask which costs are included, excluded, estimated or subject to adjustment. The fixed-price scope guide explains those distinctions; normalization should preserve them in separate columns.

Illinois Section 454.90 addresses inclusive unit-price and anticipated-cost disclosure for licensed ABCs within its scope. It is a jurisdiction-specific provision, not a universal requirement that every hotel receive an identical itemized invoice.

Ask whether broker compensation is embedded or additional and record its calculation unit. A disclosed per-unit amount may be useful for understanding the economics while already being included in the quoted price. The broker-fee guide supplies the wider compensation review; this check prevents a unit or inclusion mistake in the offer calculation.

What happens when spreadsheets transform source data?

Keep source fields separate from normalized fields. Label each conversion and avoid overwriting the original value. An analyst should be able to follow the chain from supplier notation to the unit used in the comparison and to the final modeled amount.

Check formatting that can hide precision or scale. A cell displayed as cents may contain dollars, or a percentage format may be applied to a unit-price input. Document the workbook’s conventions and test the actual stored values rather than relying on the visible number alone.

Watch imported text, rounded values and copied formulas with shifted references. These are possible failure modes to investigate, not findings about a particular supplier. Review the affected field and compare a small independent calculation before describing the entire workbook as validated.

1. Preserve the written source value and its complete headings.
2. Confirm currency, unit, component and service period.
3. Normalize using documented conversion factors.
4. Calculate a test amount through an independent equivalent method.
5. Resolve inclusion and compensation differences.
6. Compare the approved final exhibit with the reviewed workbook.

Which questions should be resolved before signature?

Ask the supplier to clarify ambiguous abbreviations and confirm the rate notation in the final agreement. Identify affected accounts and service periods in the request. Do not turn the analyst’s preferred interpretation into an accepted term without a corresponding document.

If the supplier provides a corrected quotation, retain the original and the change explanation. Recompute the comparison using the revised field and obtain approval for any changed cost or exposure. An apparently minor decimal correction can alter the purchasing decision materially.

Confirm that the final execution package preserves the same unit and inclusions as the approved analysis. A signed cover page with an inconsistent attachment should be resolved through the document process, not patched only inside the hotel’s budget workbook.

What should the first invoice review establish?

Match the bill’s rate, quantity, period and components with the accepted exhibit. Identify whether the invoice presents the agreed price directly or combines components in another permitted format. Ask for a reproducible explanation where the relationship is unclear.

Retain both the normalized comparison and the original source documents. A new employee can then test the invoice without reversing undocumented decimal changes. If the first bill differs, describe the specific field and amount rather than simply saying that the rate increased.

The completed record should make each calculation understandable from its dimensions. It provides a practical approval control while leaving market forecasts, product selection and legal interpretation to their own evidence and review processes.