The URL can be used to link to this page

Home My WebLink About8. App. Hooper Bay Windmill Heating System Spreadsheet 10-7-08FuelIncrease8%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 8.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 $80,641 $87,092 $94,060 $101,584 $109,711 $118,488 $127,967 $138,204 $149,261 $161,202 $174,098 $188,026 $203,068 $219,313 $236,858 $255,807 $276,271 $298,373 $322,243Displaced 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$80,641 $87,092 $94,060$101,584$109,711 $118,488$127,967 $138,204$149,261 $161,202$174,098$188,026$203,068$219,313$236,858$255,807 $276,271 $298,373$322,243Windmill 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 $835 $902 $974 $1,052 $1,136 $1,227 $1,325 $1,431 $1,545 $1,669 $1,802 $1,947 $2,102 $2,271 $2,452 $2,648 $2,860 $3,089Total 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$ 67,983$ 73,801$ 80,104$ 86,931$ 94,325$ 102,333$ 111,004$ 120,393$ 130,559$ 141,565$ 153,479$ 166,376$ 180,336$ 195,444$ 211,796$ 229,492$ 248,640$ 269,361$ 291,780$ Cumulative Cash Flow62,612 130,595 204,397 284,501 371,432 465,757 568,090 679,094 799,487 930,047 1,071,611 1,225,091 1,391,467 1,571,802 1,767,247 1,979,043 2,208,535 2,457,175 2,726,536 3,018,315Benefit Cost Ratio0.03 0.06 0.09 0.13 0.17 0.21 0.26 0.31 0.36 0.42 0.48 0.55 0.63 0.71 0.80 0.89 0.99 1.11 1.23 1.36Additional Power UseSimple Payback: Total Project Cost/Year One Operating Cost Savings: