The URL can be used to link to this page

Home My WebLink About7. App. Hooper Bay Windmill Heating System Spreadsheet 10-7-08FuelIncrease12%HOOPER BAY WTP Water Plant and Washeteria Heat from WindmillsHooper Bay, Alaska Date: October 6, 2008PRELIMINARY EXISTING CONDITIONS Existing Fuel Type:Fuel Oil Current Annual Fuel Cost:$4.68 Fuel oil to be displaced15,955 Annual Heating Costs:$74,668ENERGY CONVERSION (to 1 mmbtu, or 1 dka)Gross Displaced Fuel Volume (btu):2,137,916,550 Assumed efficiency of existing heating system (%):80% Net Annual Fuel Heat Output (btu):1,710,333,240 ELECTRICAL HEATING SYSTEM WITH WINDMILLSElectric HeatGross output of two 100 KW windmills539,000 KwH Assumed efficiency of electric boiler system:93% Net output of windmills501,270 KwHHeat Equivalent of Windmill Net Output1,710,333,240 btu Project Capital Cost $2,220,000 Project Financing InformationPercent Financed0%Est. Pwr Use 1750 kWhAmount Financed $0 Elec Rate $0.42 /kWhAmount of Grants $1,200,000 Interest Rate 5.00%Term 10Annual Finance Cost (years) $0 35 yearsInflation FactorsO&M Inflation Rate 5.0%Current Fuel Inflation Rate 12.0%YearYearYearYearYearYearYearYearYearYearYearYearYearYearYearYearYearYearYearYearCash flow Descriptions Unit Costs HeatingSource ProportionAnnual Heating Source VolumesHeating Units1234567891011121314151617181920Existing Heating System Operating CostsDisplaced heating costs$4.68 100% 15955 gal $74,668 $83,628 $93,663 $104,903 $117,491 $131,590 $147,380 $165,066 $184,874 $207,059 $231,906 $259,735 $290,903 $325,811 $364,909 $408,698 $457,741 $512,670 $574,191 $643,094Displaced Operation and Maintenance Costs$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0Total Fuel Oil Heat Operating Costs for Displaced Fuel$74,668$83,628$93,663$104,903$117,491 $131,590$147,380$165,066$184,874$207,059$231,906$259,735$290,903$325,811 $364,909$408,698$457,741 $512,670$574,191 $643,094Windmill Electric Heating System Operating CostsFuel Costs$0.00 0% 0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0Operation and Maintenance Costs$0.021 100% 539000 KwH $11,319 $11,885 $12,479 $13,103 $13,758 $14,446 $15,169 $15,927 $16,723 $17,559 $18,437 $19,359 $20,327 $21,344 $22,411 $23,531 $24,708 $25,943 $27,241 $28,603Additional Electrical Cost $0.42 100% 1750 KwH $736 $773 $866 $970 $1,086 $1,216 $1,362 $1,526 $1,709 $1,914 $2,144 $2,401 $2,689 $3,012 $3,373 $3,778 $4,231 $4,739 $5,308 $5,945Total Windmill Heat Operating Costs$12,055$12,658$13,291 $13,955$14,653$15,386$16,155$16,963$17,811 $18,702 $19,637 $20,619$21,649$22,732 $23,869$25,062 $26,315$27,631 $29,012 $30,463Net Annual Cash Flow62,612$ 70,970$ 80,372$ 90,947$ 102,838$ 116,204$ 131,225$ 148,103$ 167,063$ 188,357$ 212,269$ 239,116$ 269,253$ 303,079$ 341,040$ 383,636$ 431,426$ 485,040$ 545,178$ 612,631$ Cumulative Cash Flow62,612 133,582 213,954 304,901 407,739 523,943 655,168 803,271 970,334 1,158,691 1,370,961 1,610,077 1,879,330 2,182,410 2,523,450 2,907,086 3,338,512 3,823,551 4,368,730 4,981,361Benefit Cost Ratio0.03 0.06 0.10 0.14 0.18 0.24 0.30 0.36 0.44 0.52 0.62 0.73 0.85 0.98 1.14 1.31 1.50 1.72 1.97 2.24Simple Payback: Total Project Cost/Year One Operating Cost Savings:Additional Power Use