This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
INPUT
LEAD-ACID BATTERY
LITHIUM ION
FUEL CELL
Workdays per year
Days
Days
Days
Value per year per square foot
$/sq.ft
$/sq.ft
$/sq.ft
Fully burdened price of labor
$/hour
$/hour
$/hour
# of shifts per day
Shifts
Shifts
Shifts
Federal Energy Credit - 30% fuel cell ITC through 2024
%
%
%
Price of power inclusive of peak demand
Guidance:
Take your entire electricity bill and divide it by the the total number of kWh consumed in the period.
$/kWh
$/kWh
$/kg
% of grid energy generated from natural gas
%
% of grid energy generated from coal
%
% of grid energy generated from petroleum
%
CO2 emmissions from natural gas per kWh
lbs
CO2 emmissions from natural coal per kWh
lbs
CO2 emmissions from natural petroleum per kWh
lbs
EU Allowance (EUA) contract per metric ton in USD
$
POWER INDUSTRIAL TRUCKS
# PIT
MHE
MHE
Guidance:
5% less PIT required due to efficiencies in productivity.
MHE
Average price per PIT
$/MHE
$/MHE
$/MHE
Amortization period
Years
Years
Years
Cost to maintain PIT per month (avg. or full maintenance)
$/Month
$/Month
$/Month
Reduced(-) or increased maintenance expenses
%
%
Guidance:
Based on data showing a decrease in maintenance costs due to consistently high voltage without droop.
%
MOTIVE POWER UNITS
# Batteries
Batteries
Batteries
Fuel cells
kWh
/ size of motive power unit
kWh
kWh
Kg
Avg budgetary cost each battery or fuel cells
$
$
$
Amortization period
Years
Years
Years
Battery changer cost
$
$
$
Battery changer monthly maintenance
$
$
$
Amortization period
Years
Years
Years
Battery charging efficiency (coulombic)
%
%
N/A
%
# of batteries/tanks used per day
Batteries
1
Batteries
1
Fuel cells
Lost labor per shift due to refuel/charging
Minutes
Minutes
Minutes
# of battery maintenance workers per shift
FTE
FTE
0
FTE
Increased productivity from high steady voltage
%
%
%
Cost to water a battery per month
$
$
$
Cost to wash a battery per year
$
$
$
Cost to repair a battery per year
$
$
$
Cost to dispose of motive power unit
$
$
$
CHARGING
# Chargers / Dispensers
Chargers
Chargers
Guidance:
One needed per (80) PIT. Minimum (2) required.
Dispensers
Avg budgetary cost each charger
$
$
$
Annual charger maintenance and repair
$
$
Guidance:
Maintenance is included in the fuel cell's purchase price.
$
Amortization period
Years
Years
Years
Charger efficiency
%
%
N/A
%
Charging area in square feet
sqft
sqft
Guidance:
Each dispenser is 24" x 36". (1) forklift being refueled consumes 40 sq.ft.
sqft
Cost for electrical or H2 storage infrastructure
$
$
$
Amortization period
Years
Years
Years
TIME (LABOR)
Time to change/charge/refuel/day (incl battery room tech)
$
$
$
Time to change/charge/refuel per year
$
$
$
Time to change/charge/refuel over 5 years
$
$
$
SPACE
Land cost to store & charge motive power per month
$
$
$
Land cost to store & charge motive power per year
$
$
$
Land cost to store & charge motive power over 5 years
$
$
$
CURRENT / H2
Cost to recharge/refuel motive power/day
$
$
$
Cost to recharge/refuel motive power/year
$
$
$
Cost to recharge/refuel motive power fleet/year
$
$
$
BATTERY MAINTENANCE COSTS
Watering per year
$
$
$
Washing per year
$
$
$
Battery repairs per year
$
$
$
Disposal per year
$
$
$
Maintenance and disposal fees per year
$
$
$
OPERATING COSTS - MONTHLY
Fewer PIT - monthly maintenance
$
$
$
Monthly labor expense
$
$
$
Increased productivity savings
$
$
$
PIT maintenance benefit or expense from high voltage
$
$
$
Battery changer maintenance
$
$
$
Battery changing/charging/fueling lost labor expense
$
$
$
Cost to water, maintain, wash, repair battery monthly
$
$
$
Cost to maintain chargers monthly
Leased land cost for charging area
$
$
$
Electricity/H2 monthly expense
$
$
$
Total monthly operating costs
$
$
$
Fuel cell operating costs advantage per month
$
$
CAPITAL
PIT
$
$
$
Batteries/GenDrives
$
$
$
Chargers/dispensers
$
$
$
Battery changers
$
$
$
Infrastructure
$
$
$
Cost to dispose of batteries/fuel cells
$
$
$
Total capital required
$
$
$
30% Investment Tax Credit
$
$
$
Capital net of ITC
$
$
$
Fuel cell capital advantage net of ITC or (disadvantage)
Amortized per year
$
$
$
Fuel cell capital costs advantage per year
$
$
ITC credit over 5 years
$
Amortized capital cost per year in first 5 years
$
$
$
CO2 EMMISSIONS FROM CHARGING USING THE GRID
LEAD-ACID BATTERY
LITHIUM ION
FUEL CELL
Carbon dioxide produced per year from natural gas
lbs/year
lbs/year
0
lbs/year
Carbon dioxide produced per year from coal
lbs/year
lbs/year
0
lbs/year
Carbon dioxide produced per year from petroleum
lbs/year
lbs/year
0
lbs/year
Total (SEC has proposed GHG emmissions disclosures)
lbs/year
Guidance:
We assumed that the consumption of kWh is the same as lead-acid. Reduction comes from charger and coulombic efficiencies.
lbs/year
Guidance:
Green hydrogen is made from renewable electricity and water. The H2 is produced by splitting water into its molecular components. When hydrogen is consumed in a fuel cell it reforms as water, producing electricity, and heat. If liquid green hydrogen is transported using green transportation the GHG is near or at zero.
0
lbs/year
COST OF CO2 EMMISSIONS BASED ON EUA CONTRACTS
LEAD-ACID BATTERY
LITHIUM ION
FUEL CELL
Equivalent cost of carbon dioxide produced per year from natural gas
$/year
$/year
0
$/year
Equivalent cost of carbon dioxide produced per year from coal
$/year
$/year
0
$/year
Equivalent cost of carbon dioxide produced per year from petroleum
$/year
$/year
0
$/year
Total (does not apply to US businesses yet)
$/year
$/year
0
$/year
Update
Reset
Print This