Calculators › Utility bills and rates
Weighted contracted gas price calculator
Weighted contracted gas price
Blended commodity price is calculated as (E_fixed × r_fixed + E_spot × r_spot) / (E_fixed + E_spot). Use the stated system boundary and matching input units.
Units IP (US) SI (metric)
r blend = E fixed × r fixed + E spot × r spot E fixed + E spot r_{\text{blend}} = \frac{E_{\text{fixed}} \times r_{\text{fixed}} + E_{\text{spot}} \times r_{\text{spot}}}{E_{\text{fixed}} + E_{\text{spot}}} r blend = E fixed + E spot E fixed × r fixed + E spot × r spot
r blend = E fixed × r fixed + E spot × r spot E fixed + E spot r_{\text{blend}} = \frac{E_{\text{fixed}} \times r_{\text{fixed}} + E_{\text{spot}} \times r_{\text{spot}}}{E_{\text{fixed}} + E_{\text{spot}}} r blend = E fixed + E spot E fixed × r fixed + E spot × r spot
Calculator
Enter the values you know and leave one box empty. Calculate finds the empty one, the result or any input.
Worked example
Given
E fixed E_{\text{fixed}} E fixed = 1,600 MMBtu r fixed r_{\text{fixed}} r fixed = 6 $/MMBtu E spot E_{\text{spot}} E spot = 400 MMBtu r spot r_{\text{spot}} r spot = 11 $/MMBtu
r blend = 1600 × 6 + 400 × 11 1600 + 400 = 7 r_{\text{blend}} = \frac{1600 \times 6 + 400 \times 11}{1600 + 400} = 7 r blend = 1600 + 400 1600 × 6 + 400 × 11 = 7
Given
E fixed E_{\text{fixed}} E fixed = 1,600 GJ r fixed r_{\text{fixed}} r fixed = 6 $/GJ E spot E_{\text{spot}} E spot = 400 GJ r spot r_{\text{spot}} r spot = 11 $/GJ
r blend = 1600 × 6 + 400 × 11 1600 + 400 = 7 r_{\text{blend}} = \frac{1600 \times 6 + 400 \times 11}{1600 + 400} = 7 r blend = 1600 + 400 1600 × 6 + 400 × 11 = 7
Symbols and units
Symbol Meaning Unit
r blend r_{\text{blend}} r blend blended commodity price $/MMBtu
E fixed E_{\text{fixed}} E fixed contracted fixed-price energy MMBtu
r fixed r_{\text{fixed}} r fixed fixed commodity price $/MMBtu
E spot E_{\text{spot}} E spot spot-purchased energy MMBtu
r spot r_{\text{spot}} r spot spot commodity price $/MMBtu
Symbol Meaning Unit
r blend r_{\text{blend}} r blend blended commodity price $/GJ
E fixed E_{\text{fixed}} E fixed contracted fixed-price energy GJ
r fixed r_{\text{fixed}} r fixed fixed commodity price $/GJ
E spot E_{\text{spot}} E spot spot-purchased energy GJ
r spot r_{\text{spot}} r spot spot commodity price $/GJ
Studying for the CEM® exam?
The ClueLuma CEM app has 1,041 calculation-focused practice questions, a formula calculator like this one in every question, and an endless drill where the numbers change every time. Try it free, no card needed.
Results are estimates for study and screening. Check the inputs, units and assumptions before you use them for design, billing or contract decisions.