Get documents about "Energy Data Form
Document Sample
Energy Workbook
Instructions
Use pull down menus at top of worksheet to navigate.
Fill in only those boxes that have a white background.
Fill in the worksheets in the order that they are listed below.
Initial Data:
Enter all information available; When only one product description is entered, use the available buttons to
make the changes to the SUMMARY sheet.
Electric Data:
Natural Gas Data:
Water & Sewer Data:
Other Fuel Data:
Energy Balance:
Printing:
Your computer's default printer will be used unless you choose a different one from the PrintData menu.
Comments or suggestions:
If you find any problems or have suggestions, notify Bill Meffert.
Note:
Some data is updated automatically and does not need to be changed manually. (e.g. use drop down boxes on
initial data sheet)
Fact Sheet:
Data will be filled into the FACTSHEET as the Energy Worksheet is filled out.
Print the FACTSHEET prior to plant visit.
InitialData
Directions
Fill in all unshaded areas because the conversion factors and units of consumption are used in all the charts. Be su
Conversion Factors Units of Consumption First Month of Bills Producti
Electricity 0.003412 Demand kW
kW May-99
Natural Gas 0.103 Natural Gas CCF
CCF
Propane 0.092 Propane gal Operating Schedule
Other Fuel 0 Other Fuel gal hrs/shift
Water 1 Water kgal
kgal shifts/day
days/wk
Choose other type of fuel (if any): Other Fuel wks/yr
NOTE: if none choose blank selection hrs/yr 0
at bottom of drop down box.
Electricity Accounts
Utility Name Rate Name Acount #
Account #1
Account #2
Account #3
Account #4
Account #5
Natural Gas Accounts
Utility Name (LDC) Rate Name Commodity Supplier
Account #1
Account #2
Account #3
Account #4
Page 2
InitialData
Page 3
InitialData
used in all the charts. Be sure the first month follows the format shown.
Production Data
Description
Annual Prod
NOTE: if there is not a second
Units of Prod product, leave the second row
of each heading blank,
% of Energy
Use
Water & Sewer Accounts
Utility Name Acount #
Account #1
Account #2
Account #3
Account #4
ommodity Supplier Account #
Page 4
InitialData
Page 5
InitialData
Page 6
InitialData
Page 7
Electricity Tracking
Utility:
Rate Name:
Account No.:
Consumption Demand (kW) Excess Electrical Consumption & Cost
Month-Year (kWh) Actual Billing KVAR HUD Cost 1 $1
May-99 #####
1 $1
Jun-99 #####
Jul-99 ##### 1 $1
Aug-99 #####
Cost ($)
kWh
Sep-99 ##### 1 $1
Oct-99 #####
Nov-99 ##### 0 $0
Dec-99 #####
0 $0
Jan-00 #####
Feb-00 ##### 0 $0
Mar-00 #####
Dec-99
Jan-00
Feb-00
Mar-00
Apr-00
Jun-99
Jul-99
Sep-99
Oct-99
Nov-99
May-99
Aug-99
Apr-00 #####
Totals 0 0 $0 Consumption Cost
Unit Cost: #DIV/0! /kWh
Electrical Cost Breakdown Electrical Demand
1.2
On Peak
Other
Off Peak 1
21%
0%
73%
0.8
kW
0.6
0.4
0.2
0
May-99
Jun-99
Jul-99
Aug-99
Sep-99
Oct-99
Nov-99
Dec-99
Jan-00
Feb-00
Mar-00
Apr-00
Month
Actual Billing
Electricity Tracking
Utility:
Rate Name:
Account No.:
Consumption Demand (kW) Excess Electrical Consumption & Cost
Month-Year (kWh) Actual Billing KVAR HUD Cost 1 $1
May-99 ######
Jun-99 ###### 1 $1
Jul-99 ######
1 $1
Aug-99 ######
Cost ($)
kWh
Sep-99 ###### 1 $1
Oct-99 ######
Nov-99 ###### 0 $0
Dec-99 ######
0 $0
Jan-00 ######
Feb-00 ###### 0 $0
May-99
Aug-99
Nov-99
Dec-99
Mar-00
Apr-00
Mar-00 ######
Jun-99
Jul-99
Sep-99
Oct-99
Jan-00
Feb-00
Apr-00 ######
Totals 0 0 $0 Consumption Cost
Unit Cost: #DIV/0! /kWh
Electrical Cost Breakdown Electrical Demand
1
Demand
Other
Energy (kWh)
0% 1
1
kW
1
0
0
0
Jun-99
Jul-99
Oct-99
Nov-99
Dec-99
Mar-00
Apr-00
Sep-99
Jan-00
Feb-00
May-99
Aug-99
Month
Actual Billing
Electricity Tracking
Utility:
Rate Name:
Account No.:
Consumption Demand (kW) Excess Electrical Consumption & Cost
Month-Year (kWh) Actual Billing KVAR HUD Cost 1 $1
May-99 #DIV/0!
Jun-99 #DIV/0! 1 $1
Jul-99 #DIV/0!
1 $1
Aug-99 #DIV/0!
Cost ($)
kWh
Sep-99 #DIV/0! 1 $1
Oct-99 #DIV/0!
Nov-99 #DIV/0! 0 $0
Dec-99 #DIV/0!
0 $0
Jan-00 #DIV/0!
Feb-00 #DIV/0! 0 $0
Jun-99
Feb-00
Apr-00
Jul-99
Sep-99
Nov-99
Jan-00
Mar-00
Aug-99
Oct-99
Dec-99
Mar-00 #DIV/0!
May-99
Apr-00 #DIV/0!
Totals 0 0 $0 Consumption Cost
Unit Cost: #DIV/0! /kWh
Electrical Cost Breakdown Electrical Demand
1
Demand
Other
Energy (kWh)
0% 1
1
kW
1
0
0
0
Jul-99
Sep-99
Nov-99
Jan-00
Mar-00
May-99
Jun-99
Oct-99
Dec-99
Feb-00
Apr-00
Aug-99
Month
Actual Billing
Electricity Tracking
Utility:
Rate Name:
Account No.:
Consumption Demand (kW) Excess Electrical Consumption & Cost
Month-Year (kWh) Actual Billing KVAR HUD Cost 1 $1
May-99 ######
Jun-99 ###### 1 $1
Jul-99 ######
1 $1
Aug-99 ######
Cost ($)
kWh
Sep-99 ###### 1 $1
Oct-99 ######
Nov-99 ###### 0 $0
Dec-99 ######
0 $0
Jan-00 ######
Feb-00 ###### 0 $0
May-99
Aug-99
Oct-99
Dec-99
Feb-00
Apr-00
Mar-00 ######
Jun-99
Jul-99
Sep-99
Nov-99
Jan-00
Mar-00
Apr-00 ######
Totals 0 0 $0 Consumption Cost
Unit Cost: #DIV/0! /kWh
Electrical Cost Breakdown Electrical Demand
1
Demand
Other
Energy (kWh)
0% 1
1
kW
1
0
0
0
Jun-99
Jul-99
Oct-99
Nov-99
Dec-99
Mar-00
Apr-00
Sep-99
Jan-00
Feb-00
May-99
Aug-99
Month Actual Billing
Electricity Tracking
Utility:
Rate Name:
Account No.:
Consumption Demand (kW) Excess Electrical Consumption & Cost
Month-Year (kWh) Actual Billing KVAR HUD Cost 1 $1
May-99 #DIV/0!
Jun-99 #DIV/0! 1 $1
Jul-99 #DIV/0!
1 $1
Aug-99 #DIV/0!
Cost ($)
Sep-99 #DIV/0!
kWh
1 $1
Oct-99 #DIV/0!
Nov-99 #DIV/0! 0 $0
Dec-99 #DIV/0!
0 $0
Jan-00 #DIV/0!
Feb-00 #DIV/0! 0 $0
Jun-99
Oct-99
Dec-99
Feb-00
Apr-00
Jul-99
Aug-99
Sep-99
Nov-99
Jan-00
Mar-00
May-99
Mar-00 #DIV/0!
Apr-00 #DIV/0!
Totals 0 0 $0 Consumption Cost
Unit Cost: #DIV/0! /kWh
Electrical Cost Breakdown Electrical Demand
1
Demand
Other
Energy (kWh)
0% 1
1
kW
1
0
0
0
Jun-99
Oct-99
Nov-99
Feb-00
Mar-00
Jul-99
Sep-99
Dec-99
Jan-00
Apr-00
May-99
Aug-99
Month
Actual Billing
ElectricCosts
Electrical Account #1
Unit Costs Total Costs
Month-Year HUD $/kWh FCR/PPA $/kW Energy (kWh)
May-99 #DIV/0! $0
Jun-99 #DIV/0! $0
Jul-99 #DIV/0! $0
Aug-99 #DIV/0! $0
Sep-99 #DIV/0! $0
Oct-99 #DIV/0! $0
Nov-99 #DIV/0! $0
Dec-99 #DIV/0! $0
Jan-00 #DIV/0! $0
Feb-00 #DIV/0! $0
Mar-00 #DIV/0! $0
Apr-00 #DIV/0! $0
Totals $0
Average Unit Costs (annualized)
kWh Cost: #DIV/0!
kW Cost: #DIV/0!
Page 10
ElectricCosts
Page 11
ElectricCosts
Page 12
ElectricCosts
Total Costs
Demand Other
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
Month-Year HUD
May-99 #DIV/0!
Jun-99 #DIV/0!
Jul-99 #DIV/0!
Aug-99 #DIV/0!
Sep-99 #DIV/0!
Oct-99 #DIV/0!
Nov-99 #DIV/0!
Dec-99 #DIV/0!
Jan-00 #DIV/0!
Feb-00 #DIV/0!
Mar-00 #DIV/0!
Apr-00 #DIV/0!
Totals
Unit Costs
kWh Cost:
kW Cost:
Page 13
ElectricCosts
Page 14
ElectricCosts
Page 15
ElectricCosts
Electrical Account #2
Unit Costs Total Costs
$/kWh FCR $/kW Energy (kWh) Demand Other
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
Totals $0 $0 $0
Unit Costs
#DIV/0!
#DIV/0!
Page 16
ElectricCosts
Page 17
ElectricCosts
Page 18
ElectricCosts
Electrical Account #3
Unit Costs
Month-Year HUD $/kWh FCR
May-99 #DIV/0!
Jun-99 #DIV/0!
Jul-99 #DIV/0!
Aug-99 #DIV/0!
Sep-99 #DIV/0!
Page 19
ElectricCosts
Oct-99 #DIV/0!
Nov-99 #DIV/0!
Dec-99 #DIV/0!
Jan-00 #DIV/0!
Feb-00 #DIV/0!
Mar-00 #DIV/0!
Apr-00 #DIV/0!
Totals
Unit Costs
kWh Cost: #DIV/0!
kW Cost: #DIV/0!
Page 20
ElectricCosts
Page 21
ElectricCosts
Electrical Account #3
nit Costs Total Costs
$/kW Energy (kWh) Demand Other
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
Page 22
ElectricCosts
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
Page 23
ElectricCosts
Page 24
ElectricCosts
Page 25
ElectricCosts
Electrical Account #4
Unit Costs Total Costs
Month-Year HUD $/kWh FCR $/kW Energy (kWh)
May-99 #DIV/0! $0
Jun-99 #DIV/0! $0
Jul-99 #DIV/0! $0
Aug-99 #DIV/0! $0
Sep-99 #DIV/0! $0
Oct-99 #DIV/0! $0
Nov-99 #DIV/0! $0
Dec-99 #DIV/0! $0
Jan-00 #DIV/0! $0
Feb-00 #DIV/0! $0
Mar-00 #DIV/0! $0
Apr-00 #DIV/0! $0
Totals $0
Unit Costs
kWh Cost: #DIV/0!
kW Cost: #DIV/0!
Page 26
ElectricCosts
Page 27
ElectricCosts
Page 28
ElectricCosts
Total Costs
Demand Other
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
Month-Year HUD
May-99 #DIV/0!
Jun-99 #DIV/0!
Jul-99 #DIV/0!
Aug-99 #DIV/0!
Sep-99 #DIV/0!
Oct-99 #DIV/0!
Nov-99 #DIV/0!
Dec-99 #DIV/0!
Jan-00 #DIV/0!
Feb-00 #DIV/0!
Mar-00 #DIV/0!
Apr-00 #DIV/0!
Totals
Page 29
ElectricCosts
Unit Costs
kWh Cost:
kW Cost:
Page 30
ElectricCosts
Page 31
ElectricCosts
Electrical Account #5
Rates Total Costs
$/kWh FCR $/kW Energy (kWh) Demand Other
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
Totals $0 $0 $0
Page 32
ElectricCosts
Unit Costs
#DIV/0!
#DIV/0!
Page 33
ElectricCosts
Page 34
ElectricCosts
Page 35
ElectricCosts
Page 36
ElectricCosts
Page 37
ElectricCosts
Page 38
ElectricCosts
Page 39
DemandCostCalc
Marginal Cost Calculator
Utility Name / Rate GeorgiaPower PLL
Georgia Power PLL
Marginal Costs
Energy $0.02493 /kWh
Monthly Usage, kWh: 250000 Base Charge: $16.75000 Demand $19.664 /kW
Billing Demand: 1000 FCR (PPA, ECR): $0.01355 Other Costs
HUD: 250 Tax Rate (%): 0.06 Total Bill ~ $27,653.02
CF* $191.75
Base Demand Charge: $4.74 Avg. $/kWh $0.1106
All consumption below 200 HUD * CF = correction factor
First 3000 kWh @ $0.11050 /kWh
Next 7000 kWh @ $0.10050 /kWh
Next 190000 kWh @ $0.08600 /kWh
Over 200000 kWh $0.06700 /kWh
All consumption in excess of 200 kWh @ $0.01138 /kWh $14.924 /kW
per kW of billing demand: $11.124 /kW
All consumption in excess of 400 kWh @ $0.00900 /kWh $15.876 /kW
per kW of billing demand: $12.076 /kW
All consumption in excess of 600 kWh @ $0.00650 /kWh $17.376 /kW
per kW of billing demand: $13.576 /kW
200 HUD x BD = 200,000 Correction Factor
$16.75
$46.75
$191.75
$3,991.75
Page 40
Natural Gas Tracking
Utility (LDC):
Rate Name:
Account No.:
Total Burner Tip Nymex Natural Gas Consumption & Cost
Consumptio Total Cost Price Month Close 1.2 $1
Month-Year (CCF) ($) ($/MMBtu) ($/MMBtu)
May-99 $2.348 1 $1
Jun-99 $2.226
Jul-99 $2.262 0.8 $1
Aug-99 $2.601
Cost ($)
CCF
Sep-99 $2.912 0.6 $1
Oct-99 $2.560
0.4 $0
Nov-99 $3.092
Dec-99 $2.120 0.2 $0
Jan-00 $0.000
Feb-00 $2.662 0 $0
Jun-99
Jul-99
Jan-00
Feb-00
Mar-00
Apr-00
May-99
Sep-99
Oct-99
Nov-99
Dec-99
Aug-99
Mar-00 $2.761
Apr-00 $2.945
Totals 0 $0 #DIV/0! Consumption Cost
Unit Cost: #DIV/0! /MMBtu
Natural Gas Cost Breakdown Burner Tip Cost vs. Spot Price
0% (NYMEX Month-End Price)
$3.50
$3.00
$2.50
Unit Prices ($)
$2.00
$1.50
$1.00
$0.50
$0.00
May-99
Jun-99
Jul-99
Aug-99
Sep-99
Oct-99
Nov-99
Dec-99
Jan-00
Feb-00
Mar-00
Apr-00
Commodity Transportation LDC
Unit Cost Spot Price
Natural Gas Tracking
Utility/LDC:
Rate Name:
Account No.:
Total Burner Tip Nymex Natural Gas Consumption & Cost
Consumptio Total Cost Price Month Close 1 $1
Month-Year (CCF) ($) ($/MMBtu) ($/MMBtu)
May-99 $2.348 1 $1
Jun-99 $2.226
Jul-99 $2.262 1 $1
Aug-99 $2.601
Cost ($)
CCF
Sep-99 $2.912 1 $1
Oct-99 $2.560
0 $0
Nov-99 $3.092
Dec-99 $2.120 0 $0
Jan-00 $0.000
Feb-00 $2.662 0 $0
May-99
Jul-99
Sep-99
Oct-99
Dec-99
Feb-00
Apr-00
Jun-99
Aug-99
Nov-99
Jan-00
Mar-00
Mar-00 $2.761
Apr-00 $2.945
Totals 0 $0 #DIV/0! Consumption Cost
Unit Cost: #DIV/0! /MMBtu
Natural Gas Cost Breakdown Burner Tip Cost vs. Spot Price
0% (NYMEX Month-End Price)
$3.50
$3.00
$2.50
Unit Prices ($)
$2.00
$1.50
$1.00
$0.50
$0.00
May-99
Jul-99
Oct-99
Nov-99
Jan-00
Feb-00
Apr-00
Jun-99
Aug-99
Sep-99
Dec-99
Mar-00
Commodity Transportation LDC
Unit Cost Spot Price
Natural Gas Tracking
Utility/LDC:
Rate Name:
Account No.:
Total Burner Tip Nymex Natural Gas Consumption & Cost
Consumptio Total Cost Price Month Close 1 $1
Month-Year (CCF) ($) ($/MMBtu) ($/MMBtu)
May-99 $2.348 1 $1
Jun-99 $2.226
Jul-99 $2.262 1 $1
Cost ($)
Aug-99 $2.601
CCF
1 $1
Sep-99 $2.912
Oct-99 $2.560
0 $0
Nov-99 $3.092
Dec-99 $2.120 0 $0
Jan-00 $0.000
Feb-00 $2.662 0 $0
Sep-99
Jan-00
Feb-00
Mar-00
Jul-99
Aug-99
Nov-99
Apr-00
May-99
Jun-99
Oct-99
Dec-99
Mar-00 $2.761
Apr-00 $2.945
Totals 0 $0 #DIV/0! Consumption Cost
Unit Cost: #DIV/0! /MMBtu
Natural Gas Cost Breakdown Burner Tip Cost vs. Spot Price
0% (NYMEX Month-End Price)
$3.50
$3.00
$2.50
Unit Prices ($)
$2.00
$1.50
$1.00
$0.50
$0.00
Mar-00
Jun-99
Sep-99
Dec-99
May-99
Jul-99
Aug-99
Oct-99
Nov-99
Jan-00
Feb-00
Apr-00
Commodity Transportation LDC
Unit Cost Spot Price
Natural Gas Tracking
Utility/LDC:
Rate Name:
Account No.:
Total Burner Tip Nymex Natural Gas Consumption & Cost
Consumptio Total Cost Price Month Close
1 $1
Month-Year (CCF) ($) ($/MMBtu) ($/MMBtu)
May-99 $2.348 1 $1
Jun-99 $2.226
Jul-99 $2.262 1 $1
Aug-99 $2.601
Cost ($)
CCF
Sep-99 $2.912 1 $1
Oct-99 $2.560
0 $0
Nov-99 $3.092
Dec-99 $2.120 0 $0
Jan-00 $0.000
Feb-00 $2.662 0 $0
May-99
Aug-99
Nov-99
Feb-00
Jun-99
Jul-99
Sep-99
Oct-99
Dec-99
Jan-00
Mar-00
Apr-00
Mar-00 $2.761
Apr-00 $2.945
Totals 0 $0 #DIV/0! Consumption Cost
Unit Cost: #DIV/0! /MMBtu
Natural Gas Cost Breakdown Burner Tip Cost vs. Spot Price
0% (NYMEX Month-End Price)
$3.50
$3.00
$2.50
Unit Prices ($)
$2.00
$1.50
$1.00
$0.50
$0.00
Jun-99
Oct-99
Dec-99
Feb-00
Apr-00
May-99
Jul-99
Aug-99
Sep-99
Nov-99
Jan-00
Mar-00
Commodity Transportation LDC Unit Cost Spot Price
NatGasCosts
Nat Gas Account #1
Transportation Load
Commodity Basis LDC Cost Factor
Month-Year Total Cost MDQ $$$ $$$
May-99 #DIV/0!
Jun-99 #DIV/0!
Jul-99 #DIV/0!
Aug-99 #DIV/0!
Sep-99 #DIV/0!
Oct-99 #DIV/0!
Nov-99 #DIV/0!
Dec-99 #DIV/0!
Jan-00 #DIV/0!
Feb-00 #DIV/0!
Mar-00 #DIV/0!
Apr-00 #DIV/0!
Totals $0 $0 $0 $0 #DIV/0!
for pie chart: Commodity Transportation LDC
$0 $0 $0
Page 43
NatGasCosts
Page 44
NatGasCosts
Page 45
NatGasCosts
Page 46
NatGasCosts
Page 47
NatGasCosts
Page 48
NatGasCosts
Page 49
NatGasCosts
Nymex Month
End Spot
Prices
$2.5770
$2.5770
$2.5770
$2.5770
$2.5770
$2.5770
$2.5770
$2.5770
$2.5770
$2.5770
$2.5770
$2.5770
$2.5770
Nat Gas Account #2
Transportation
Commodity Basis
Month-Year Total Cost MDQ $$$
May-99
Jun-99
Jul-99
Aug-99
Sep-99
Oct-99
Nov-99
Dec-99
Jan-00
Feb-00
Mar-00
Apr-00
Totals $0 $0 $0
for pie chart: Commodity Transportation LDC
$0 $0 $0
Page 50
NatGasCosts
Page 51
NatGasCosts
Page 52
NatGasCosts
Page 53
NatGasCosts
Page 54
NatGasCosts
Page 55
NatGasCosts
Page 56
NatGasCosts
as Account #2
Nymex Month
LDC Cost Load Factor End Spot
$$$ Prices
#DIV/0! $2.5770
#DIV/0! $2.5770
#DIV/0! $2.5770
#DIV/0! $2.5770
#DIV/0! $2.5770
#DIV/0! $2.5770
#DIV/0! $2.5770
#DIV/0! $2.5770
#DIV/0! $2.5770
#DIV/0! $2.5770
#DIV/0! $2.5770
#DIV/0! $2.5770
$0 #DIV/0! $2.5770
Page 57
NatGasCosts
Nat Gas Acc
Commodity
Month-Year Total Cost MDQ
May-99
Jun-99
Jul-99
Aug-99
Sep-99
Oct-99
Nov-99
Dec-99
Jan-00
Feb-00
Mar-00
Apr-00
Totals $0 $0
for pie chart: Commodity Transportation
$0 $0
Page 58
NatGasCosts
Page 59
NatGasCosts
Page 60
NatGasCosts
Page 61
NatGasCosts
Page 62
NatGasCosts
Page 63
NatGasCosts
Page 64
NatGasCosts
Nat Gas Account #3
Transportation Nymex Month
Basis LDC Cost Load Factor End Spot
$$$ $$$ Prices
#VALUE! $2.5770
#VALUE! $2.5770
#VALUE! $2.5770
#VALUE! $2.5770
#VALUE! $2.5770
#VALUE! $2.5770
#VALUE! $2.5770
#VALUE! $2.5770
#VALUE! $2.5770
#VALUE! $2.5770
#VALUE! $2.5770
#VALUE! $2.5770
$0 $0 #VALUE! $2.5770
LDC
$0
Commodity
Month-Year
May-99
Jun-99
Jul-99
Aug-99
Sep-99
Oct-99
Nov-99
Dec-99
Jan-00
Feb-00
Mar-00
Apr-00
Totals
for pie chart:
Page 65
NatGasCosts
Page 66
NatGasCosts
Page 67
NatGasCosts
Page 68
NatGasCosts
Page 69
NatGasCosts
Page 70
NatGasCosts
Page 71
NatGasCosts
Nat Gas Account #4
Transportation Nymex Month
Commodity Basis LDC Cost Load Factor End Spot
Total Cost MDQ $$$ $$$ Prices
#DIV/0! $2.5770
#DIV/0! $2.5770
#DIV/0! $2.5770
#DIV/0! $2.5770
#DIV/0! $2.5770
#DIV/0! $2.5770
#DIV/0! $2.5770
#DIV/0! $2.5770
#DIV/0! $2.5770
#DIV/0! $2.5770
#DIV/0! $2.5770
#DIV/0! $2.5770
$0 $0 $0 $0 #DIV/0! $2.5770
Commodity Transportation LDC
$0 $0 $0
Page 72
NatGasCosts
Page 73
NatGasCosts
Page 74
NatGasCosts
Page 75
NatGasCosts
Page 76
NatGasCosts
Page 77
NatGasCosts
Page 78
NatGasCosts
Page 79
NatGasCosts
NYMEX Historical Month E
Year /
1996 1997
Month
Jan $3.4480 $3.9980
Feb $2.3400 $2.9860
Mar $2.7460 $1.7800
Apr $2.7790 $1.8070
May $2.2140 $2.1220
Jun $2.3610 $2.3460
Jul $2.6460 $2.1450
Aug $2.3220 $2.1610
Sep $1.8530 $2.5150
Oct $1.8280 $3.3460
Nov $2.6520 $3.2660
Dec $3.9010 $2.5770
NYMEX Month End Clos
$12.0000
$10.0000
$8.0000
$/MMBtu
$6.0000
$4.0000
$2.0000
$0.0000
Jan Feb Mar
1996
Page 80
NatGasCosts
Page 81
NatGasCosts
Page 82
NatGasCosts
Page 83
NatGasCosts
Page 84
NatGasCosts
Page 85
NatGasCosts
Page 86
NatGasCosts
NYMEX Historical Month End Close
1998 1999 2000 2001 2002
$2.3090 $1.7650 $9.9800
$2.0010 $1.8100 $2.6620 $5.7070
$2.2860 $1.6600 $2.7610 $5.2360
$2.3000 $1.8520 $2.9450 $5.0250
$2.2620 $2.3480 $3.1410 $4.6950
$2.0170 $2.2260 $4.3560 $3.9900
$2.3580 $2.2620 $4.4760 $3.0960
$1.9420 $2.6010 $3.7740 $3.2960
$1.6720 $2.9120 $4.7820 $2.3800
$2.0310 $2.5600 $5.1860 $2.2440
$1.9720 $3.0920 $4.4900 $3.2910
$2.1490 $2.1200 $6.5890
NYMEX Month End Close (Henry Hub)
Mar Apr May Jun Jul Aug Sep Oct Nov Dec
1997 1998 1999 2000 2001 2002
Page 87
NatGasCosts
Page 88
NatGasCosts
Page 89
NatGasCosts
Page 90
NatGasCosts
Page 91
NatGasCosts
Page 92
NatGasCosts
Page 93
NatGasCosts
Page 94
NatGasCosts
Page 95
NatGasCosts
Page 96
NatGasCosts
Page 97
NatGasCosts
Page 98
NatGasCosts
Page 99
NatGasCosts
Page 100
NatGasCosts
Page 101
NatGasCosts
Page 102
NatGasCosts
Page 103
NatGasCosts
Page 104
NatGasCosts
Page 105
NatGasCosts
Page 106
NatGasCosts
Page 107
NatGasCosts
Page 108
NatGasCosts
Page 109
NatGasCosts
Page 110
NatGasCosts
Page 111
NatGasCosts
Page 112
Propane Consumption
Supplier:
Consumption Cost Unit Cost
Month-Year (gal) ($) $/gal
May-99
Jun-99
Jul-99
Aug-99
Sep-99
Oct-99
Nov-99
Dec-99
Jan-00
Feb-00
Mar-00
Apr-00
Totals 0 $0
Unit Cost: #DIV/0! /MMBtu
Propane Consumption & Cost
1 $1
1 $1
1 $1
gal
1 $1
0 $0
0 $0
0 $0
Sep-99
Feb-00
Oct-99
Dec-99
Jan-00
Mar-00
May-99
Jun-99
Jul-99
Nov-99
Apr-00
Aug-99
Consumption Cost
Other Fuel Consumption
Supplier:
Consumption Cost Unit Cost
Month-Year (gal) ($) ($/gal)
May-99
Jun-99
Jul-99
Aug-99
Sep-99
Oct-99
Nov-99
Dec-99
Jan-00
Feb-00
Mar-00
Apr-00
Totals 0 $0
Unit Cost: #DIV/0! /MMBtu
Other Fuel
1 $1
1 $1
1 $1
Cost ($)
gal
1 $1
0 $0
0 $0
0 $0
Jul-99
Oct-99
Sep-99
Nov-99
Dec-99
Jan-00
Feb-00
Mar-00
Jun-99
Aug-99
Apr-00
May-99
Consumption Cost
Water Tracking
Supplier:
Account No.:
Water Cons. Water Cost Sewer Cons. Sewer Cost Surcharges Total
Month-Year (kgal) ($) (kgal) ($) ($) Sewer Cost
May-99 $0
Jun-99 $0
Jul-99 $0
Aug-99 $0
Sep-99 $0
Oct-99 $0
Nov-99 $0
Dec-99 $0
Jan-00 $0
Feb-00 $0
Mar-00 $0
Apr-00 $0
Totals 0 $0 0 $0 $0 $0
Water: #DIV/0! /kgal
Unit Costs Sewer: #DIV/0! /kgal
WATER & SEWER DATA
1 $1
$1
1
$1
$1
1
$1
Cost ($)
kgal
1 $1
$0
0
$0
$0
0
$0
0 $0
May-99 Jun-99 Jul-99 Aug-99 Sep-99 Oct-99 Nov-99 Dec-99 Jan-00 Feb-00 Mar-00 Apr-00
Month
Water Consumption Sewer Consumption Water Cost Sewer Cost
Water Tracking
Supplier:
Account No.:
Water Cons. Water Cost Sewer Cons. Sewer Cost Surcharges Total
Month-Year (kgal) ($) (kgal) ($) ($) Sewer Cost
May-99 $0
Jun-99 $0
Jul-99 $0
Aug-99 $0
Sep-99 $0
Oct-99 $0
Nov-99 $0
Dec-99 $0
Jan-00 $0
Feb-00 $0
Mar-00 $0
Apr-00 $0
Totals 0 $0 0 $0 $0 $0
Water: #DIV/0! /kgal
Unit Costs Sewer: #DIV/0! /kgal
WATER & SEWER DATA
1 $1
$1
1
$1
$1
1
$1
Cost ($)
kgal
1 $1
$0
0
$0
$0
0
$0
0 $0
May-99 Jun-99 Jul-99 Aug-99 Sep-99 Oct-99 Nov-99 Dec-99 Jan-00 Feb-00 Mar-00 Apr-00
Month
Water Consumption Sewer Consumption Water Cost Sewer Cost
Water Tracking
Supplier:
Account No.:
Water Cons. Water Cost Sewer Cons. Sewer Cost Surcharges Total
Month-Year (kgal) ($) (kgal) ($) ($) Sewer Cost
May-99 $0
Jun-99 $0
Jul-99 $0
Aug-99 $0
Sep-99 $0
Oct-99 $0
Nov-99 $0
Dec-99 $0
Jan-00 $0
Feb-00 $0
Mar-00 $0
Apr-00 $0
Totals 0 $0 0 $0 $0 $0
Water: #DIV/0! /kgal
Unit Costs Sewer: #DIV/0! /kgal
WATER & SEWER DATA
1 1
0.9
1
0.8
0.7
1
0.6
Cost ($)
gal
1 0.5
0.4
0
0.3
0.2
0
0.1
0 0
May-99 Jun-99 Jul-99 Aug-99 Sep-99 Oct-99 Nov-99 Dec-99 Jan-00 Feb-00 Mar-00 Apr-00
Month
Water Consumption Sewer Consumption Water Cost Sewer Cost
Annual Utility Consumption & Cost
Conversion Energy Use
Utility Source Consumption Factor (MMBtu) Cost Unit Cost
Electricity 0 (kWh) 0.003412 0 $0 $0.00 / MMBtu
Natural Gas 0 (CCF) 0.103000 0 $0 $0.00 / MMBtu
Propane 0 (gal) 0.092000 0 $0 $0.00 / MMBtu
Other Fuel 0 (gal) 0.000000 0 $0 $0.00 / MMBtu
Water 0 (kgal) $0 $0.00 / kgal
Sewer 0 (kgal) $0 $0.00 / kgal
Totals 0 $0
Production Efficiency Data
Production Schedule: hrs/shift shifts/day days/week weeks/yr
Annual % of Energy Btu/Unit
Product Description Production Usage of Production Cost/Unit of Production
#DIV/0! #DIV/0!
Electrical 2 744
Electrical 3 120 ENERGY BALANCE
Electrical 4 1527
1.2 -49.5
Other Electrical
1.0
0.8
Percentage (%)
0.6
0.4
0.2
0.0
Consumption
Cost
EnergyBalance
To conduct an energy balance for the facility, just double click on the icon below. It will route you
program that Rick Good wrote.
The bar charts from the program can then be copied to this sheet to complete the SUMMARY Secti
Page 116
EnergyBalance
Page 117
EnergyBalance
ick on the icon below. It will route you to the EBALANCE
sheet to complete the SUMMARY Section of this spreadsheet.
Page 118
EnergyBalance
Page 119
EnergyBalance
Page 120
EnergyBalance
Page 121
EnergyBalance
Page 122
EnergyBalance
Page 123
EnergyBalance
Page 124
EnergyBalance
Page 125
EnergyBalance
Page 126
EnergyBalance
Page 127
EnergyBalance
Page 128
EnergyBalance
Page 129
EnergyBalance
Page 130
EnergyBalance
Page 131
EnergyBalance
Page 132
EnergyBalance
Page 133
EnergyBalance
Page 134
EnergyBalance
Page 135
EnergyBalance
Page 136
EnergyBalance
Page 137
EnergyBalance
Page 138
Plant Energy Fact Sheet
ELECTRICITY:
- kWh used 0 kWh
- Total Dollars Paid $0
- Utility Rate 0
- Actual highest demand 0 kW, when
- Average cents per kWh #DIV/0! / kWh
- Incremental energy cost, cents per kWh 0.0249 / kWh
- On-peak demand (kW) charge $19.664 / kWh
- Off-peak demand (kW) charge $0.00 / kWh
- Typical load factor #DIV/0!
- Electricity Supplier 0
NATURAL GAS & OTHER FUELS:
- MMBtu's Use 0 MMBtu
- Total Dollars Paid $0
- Average Dollars per MMBtu / MMBtu / MMBtu
- Utility Rate 0
- Gas Suppliers 0
- Local Distribution Company 0
PRODUCTION INFORMATION:
- Annual Production () 1 0
- Electrical, $ / $0.000 /
- Gas, $ / $0.000 /
- Average Energy Cost, $ / $0.000 /
- Electrical, kWh / 0 kWh/
- Gas, Btu / 0 Btu/
- Average Energy Used, Btu / 0 Btu/
FINANCIAL INFORMATION:
- Annual Sales, $/yr $0
- Gross Profit Margin 50 %
- Cost of Manufacturing (COM) $0
- Total Energy Cost $0
- Total Energy Cost as Percent of COM #DIV/0! %
Top Three Costs in COM
% Raw Material %
% Labor %
% Capital %
Note: 1 kWh = 3,412 Btu
May-99
DataStorage
consumption and cost totals combo box items: range names menu items, macros and parameters change (true to update macro)
electric 0 $0 demand consumption
kW
nat gas 0 $0 kVA
CBL
water 0 $0 natural gas consumption
CCF
sewer 0 $0 MCF
Therm
MMBtu
water consumption
gal
kgal
CCF
other fuel type
Other Fuel
#2 Oil
#6 Oil
Coal
RateNames Base Charge FCR Tax Rate kWh kW First @ Next @ Next @ Over @ HUD1 /kW HUD2 /kW HUD3 /kW
Georgia Power PLS $16.75000 $0.00141 0.06 12000 25 25 $0.00000 2975 $0.19800 7000 $0.10430 10000 $0.09000 200 $0.01110 400 $0.00836 600 $0.00732
Georgia Power PLM $16.75000 $0.01355 0.06 12000 50 3000 $0.10900 7000 $0.09988 190000 $0.08600 200000 $0.06670 200 $0.01100 400 $0.00836 600 $0.07320
Max Values of the Electric Worksheets Georgia Power PLL $16.75000 $0.01355 0.06 250000 1000 3000 $0.11050 7000 $0.10050 190000 $0.08600 200000 $0.06700 200 $0.01138 400 $0.00900 600 $0.00650
0 May-99 Dalton Demand Rate $11.50000 $0.00341 0.05 250000 1000 3000 $0.06300 7000 $0.05400 190000 $0.04300 200000 $0.03800 200 $0.02500 400 $0.02400 600 $0.02300
0 Jun-99 Alabama Power LPM 0 0 0.05 25000 100 0.00 0.046 250 0.026337
0 Jul-99 -Other-
0 Aug-99
0 Sep-99
0 Oct-99
0 Nov-99
0 Dec-99
0 Jan-00
0 Feb-00
0 Mar-00
0 Apr-00
0 May-99
0 Jun-99
0 Jul-99
0 Aug-99
0 Sep-99
0 Oct-99
0 Nov-99
0 Dec-99
0 Jan-00
0 Feb-00
0 Mar-00
0 Apr-00
0 May-99
0 Jun-99
0 Jul-99
0 Aug-99
0 Sep-99
0 Oct-99
0 Nov-99
0 Dec-99
0 Jan-00
0 Feb-00
0 Mar-00
0 Apr-00
0 May-99
0 Jun-99
0 Jul-99
0 Aug-99
0 Sep-99
0 Oct-99
0 Nov-99
0 Dec-99
0 Jan-00
0 Feb-00
0 Mar-00
0 Apr-00
0 May-99
0 Jun-99
0 Jul-99
0 Aug-99
0 Sep-99
0 Oct-99
0 Nov-99
0 Dec-99
0 Jan-00
0 Feb-00
0 Mar-00
0 Apr-00
