The URL can be used to link to this page

Home My WebLink AboutPACKET Utilities Committee 2003-09-11I 4 AGENDA TOWN OF ESTES PARK UTILITIES COMMITTEE September 11, 2003 8:00 a.m. Preparation date: 9/5/03 *Revision date: ACTION ITEMS Light and Power Department 4. Light & Power Shop Asphalt Paving â€¢ Request to proceed with lot asphalt paving proj ect J 1. 5-year Financial Plan: Black and Veatch Presentation â€¢ Request to adopt Black and Veatch plan Water Department 0 1. Water Department Cost of Services/Rate Study Presentation â€¢ Request to adopt recommendation by Black and Veatch J 2. Fall River Tank: Project Design/Construction Management â€¢ Request approval of Scope of Services / 3. Glacier View Subdivision: Request for Water Rights Exchange â€¢ Subdivision request for Windy Gap water rights REPORTS Light and Power Department â€¢ Monthly Financial Report â€¢ Misc. projects update Water Department â€¢ Monthly Financial Report â€¢ Misc. projects update Note: The Utilities Committee reserves the right to consider other appropriate items not available at the time the agenda was prepared. TOWN of ESTES PARK Inter-Office Memorandum September 4,2003 TO: Bill Linnane / Utilities Committee FROM: Bob Goehring j'~~ SUBJECT: Overlay new L&P Building parking lot Background: Last year Greg Sievers reviewed the condition of the parking lot at 615 Elm Road (the new L&P shop), map below. The lot was built and paved in 1990 and has never been overlaid or chip sealed. The parking lot is approximately 2400 square yards. This will require about 200 tons of asphalt Coulson Excavating is the Town's asphalt paving contractor and proposes to begin the project by the middle of the month. Cost/Budget Cost Coulson per Town bid (preparation and asphalt) $14,400.00 Budget $15,000.00 Recommendation: Staff recommends the $14,400 expenditure. LAP 1 :1 4 glop f 4 15 23... SU j 21 640 ELM:AD % ---6 *frtÂ»==br:ta-- -- : 1 1 pu./14 944 1 i.\ ..9%, 614Â¢,ee,~ "--Ns %if:93% ts l'., -#fra:4:le-J :I:: e f ~...... L. "ezz/.terift.~43222~213' #_.1 i ,$41 H 92 ' ..1 : 1 1- ? .5 j I 1-1 %%% I.--'ll/.3.:b#-- : TOWN of ESTES PARK Inter-Office Memorandum September 10, 2003 TO: Utilities Committeen FROM: Bill Linnane b SUBJECT: Light & Power 5-year Financial Plan by Black and Veatch Background: John Gallagher of Black and Veatch will present the Light & Power 5-year Financial Plan. The attached spread sheet summarizes the proposed Light & Power Department 5-year Capital Improvement and Financial Plan. If the budget and Financial Plan is adopted, the plan will be the basis for a 2004 cost of services/rate analysis which will itemize all of the individual rate classes. Included in this plan are the revised 2003 and 2004 budget figures that staff has submitted to Administration for the upcoming Town Board review process. The 5-year C.LP. includes: â€¢ $50,000 annual conductor line/system improvement project. â€¢ $70,000 annual meter replacement project starting in 2005 with a 100 percent meter change-out estimated to be completed by 2007. â€¢ $70,000 annual street light project â€¢ $600,000 fiber optic project that willlink Estes Park to Loveland. The proposed plan projects an annual year-end surplus beginning in 2006 and thereon. Also, a target goal of $2.5 million fund balance (90 days O&M) occurs in the year 2008. Both goals greatly enhance the financial stability of the fund. Cost/Budget N/A Action Staff recommends adoption of the plan. BL/lb Attachment 2-1 - 9/100003 1:37 PM Table Ll Estes Park, Colorado Light and Power Utility Cash Flow Analysis Line -No. Description 2222 2004 2005 2006 2007 2008 $ $ $ S $ S 1 Beginning Balance 2,558,500 1,550,900 1,016,200 802,400 1,186,600 1,588,900 Revenues 2 Revenue adopted Ught and Power Service Rates (a) 8,027,200 8,695,000 8,899,000 9,099,100 9,299,200 9,499,300 Additional Light and Power Service Revenue Required Percent Months Year Increase Effective 3 2003 0,0% 12 0 0 0 0 0 0 4 2004 0.096 12 0 0 0 0 0 5 2005 3.996 12 347,100 354,900 362,700 370,500 6 2006 3.996 12 368,700 376,800 384,900 7 2007 3.9% 12 391,500 399,900 8 2008 3.996 12 415,500 9 Total Ught and Power Service Revenue 8,027,200 8,695,000 9,246,100 9,822,700 10,430,200 11,070,100 10 Purchased Power Rider 0 173,900 337,500 345,200 352,900 360,600 11 Pole Rental 27,800 27,800 28,600 29,500 30,400 31,300 12 Vehicle Wbrk Orders 30,000 35,000 36,100 37,200 38,300 39,400 13 Meter Reading 28,400 29,000 29,900 30,800 31,700 32,700 14 Interest Earnings 29,400 41,300 27,300 29,800 41,600 64,700 15 Intergovernmental EPURA 10,100 10,200 10,500 10,800 11,100 11,400 16 15,000 15,000 15,500 16,000 16,500 17,000 Buildings 256,800 264,500 272,400 17 Miscellaneous Revenue 246,700 242,000 249,300 18 Total Revenues 8,414,600 9,269,200 9,980,800 10,578,800 11,217,200 11,899,600 Expenses Operation and Maintenance Expense 19 Source of Supply 1,634,300 1,675,100 4,123,000 4,440,000 4,606,100 4,710,900 4,815,700 4,920,500 20 Distribution and Maintenance 1,448,500 1,501,100 1,594,600 1,662,100 21 Customer Accounts 649,600 731,700 753,500 776,200 799,500 823,500 22 Administrabon and General 1,167,500 1,206,900 1,244,000 1,290,500 1,338,500 1,388,500 23 Total Operation and Maintenance Expense 7,388,600 7,879,700 8,198,200 8,411,900 8,628,800 8,794,600 Debt Service 24 R~enue Bonds 299,000 302,000 304,000 305,300 300,900 301,100 25 State and Other Loans 0 0 0 0 0 0 26 Total Debt Service 299,000 302,000 304,000 305,300 300,900 301,100 27 Capital Improvements 914,500 703,500 703,500 430,500 777,500 495,500 Transfers 28 Museum Fund 26,100 25,300 26,100 26,900 27,700 28,500 29 Interfund Transfer 762,600 842,500 910,400 966,000 1,024,400 1,085,900 30 Vehide Replacement 31,400 50,900 52,400 54,000 55,600 57,300 31 Net Transfers 820,100 918,700 988,900 1,046,900 1,107,700 1,171,700 32 Total Expenses 9,422,200 9,803,900 10,194,600 10,194,600 10,814,900 10,762,900 33 Annual Surplus (Deficiency) (1,007,600) (534,700) (213,800) 384,200 402,300 1,136,700 34 Ending Balance 1,550,900 1,016,200 802,400 1,186,600 1,588,900 2,725,600 35 Debt Service Coverage (b) 343% 460% 586% 710% 860% 1031% Recommended Service Revenue Increases 36 Overall Annual Increase 0.096 0.096 3 9% 3.996 3.996 3.9% 37 Cumulative Increase 0.056 0.0% 3.9% 8.096 12.2% 16.5% Cumulative Revenue Increases Including Purchased Power Rider 38 Overall Annual Increase 0.0% 2.056 7.7% 7.696 7.4% 7.3% 39 Cumulative Increase 0.0% 2.096 9.8% 181% 26.9% Sal% (a) Revenue from adopted rates in 2003 and 2004 includes the annual increases of 5.25 percent. (b) Total revenue less O&M expense, divided by total debt service. 2-2 9/10/2003 1:36 PM Table L2 Estes Park, Colorado Light and Power Utility Capital Improvement Program Line Total Projected -Ng. gescription 2003 2004 2005 ~ 2003-2008 $$$$$$$ Capital Equipment 1 Building Remodeling 12,500 12,500 0 5,000 5,000 5,000 40,000 2 Station Equipment 15,000 10,000 0 10,000 10,000 10,000 55,000 3 Office Equipment 5,000 0 0 5,000 2,500 5,000 17,500 4 Data Processing Equipment 75,300 82,500 82,500 70,000 75,000 75,000 460,300 5 Transformers 132,800 120,000 120,000 120,000 120,000 120,000 732,800 6 Communication Equipment . 28.700 0 0 0 0 0 28,700 7 Vehides 259,200 22,500 45,000 26,500 256,000 26,500 635,700 8 Street Lights 95,000 20,000 20,000 20,000 20,000 20,000 195,000 9 Poles, Towers and Fbrtures 48,000 12,000 12,000 15,000 15,000 15,000 117,000 10 Overhead Lines 96,000 74,000 74,000 74,000 74,000 74,000 466,000 11 Underground Conductors 147,000 50,000 50,000 50,000 50,000 50,000 397,000 12 Total Capital Equipment 914,500 403,500 403,500 395,500 627,500 400,500 3,145,000 Capital Improvement Projects 13 Fiber Optics/PRPA 0 300,000 300,000 0 0 0 600,000 14 McGregor Ranch Underground Project 0 0 0 35.000 0 0 35.000 15 MoGregor Avenue Underground Project 0 0 0 0 150,000 0 150,000 16 Stanley Park Undergroung Project 0 0 0 0 0 95,000 95,000 17 Total Capital Improvement Projects 0 300,000 300.000 35,000 150,000 95,000 880,000 18 Total Capital Improvements 914,500 703,500 703,500 430,500 777,500 495,500 4,025,000 2-3 9/10/2003 12:55 PM Table L3 Estes Park, Colorado Light and Power Utility Projected Operation and Maintenance Expense Projected Line Budget ..No. Description 2003 2004 2005 2006 2007 2008 $$$$$$ Purchased Power Supply 1 Purchased Power Supply 4,100,000 4,415,000 4,581,100 4,685,900 4,790,700 4,895,500 2 Wind 23,000 25,000 25,000 25,000 25,000 25,000 3 Total Purchased Power Supply 4,123,000 4,440,000 4,606,100 4,710,900 4,815,700 4,920,500 Distribution and Maintenance 4 Personal Services and Salaries 820,100 873,600 899,800 926,800 954,600 983,200 5 Employer Benefits 215,200 255,200 262,900 270,800 278,900 287,300 6 Insurance Premiums 19,900 21,200 21,800 22,500 23,200 23,900 7 Professional Services and Fees 4,400 2,800 2,900 3,000 3,100 3,200 8 Rentals 2,200 2,200 2,300 2,400 2,500 2,600 9 Repair and Maintenance 105,100 106,300 109,500 112,800 116,200 119,700 Material and Supplies 10 Small Tools 16,000 11,500 11,500 11,500 11,500 11,500 11 Meters 150,300 157,700 212,700 212,700 212,700 157,700 12 Streets and Lights 95,000 50,000 50,000 50,000 50,000 50,000 13 All Other Materials and Supplies 10,700 10,700 11,000 11,300 11,600 11,900 14 Job Performance Expenses 9,600 9,900 10,200 10,500 10,800 11,100 15 Other Current Expenses 0 0 0 0 0 0 16 Total Distribution and Maintenance 1,448,500 1,501,100 1,594,600 1,634,300 1,675,100 1,662,100 Customer Accounts 17 Personal Service and Salaries 408,900 439,500 452,700 466,300 480,300 494,700 18 Employer Benefits 97,100 134,000 138,000 142,100 146,400 150,800 19 Insurance Premiums 7,600 8,200 8,400 8,700 9,000 9,300 20 Professional Services and Fees 1,000 200 200 200 200 200 21 Rentals 1,200 1,200 1,200 1,200 1,200 1,200 22 Repair and Maintenance 59,400 61,100 62,900 64,800 66,700 68,700 23 Materials and Supplies 56,300 69,900 72,000 74,200 76,400 78,700 24 Job Performance Expenses 7,100 6,000 6,200 6,400 6,600 6,800 25 Other Current Expenses 11,000 11,600 11,900 12,300 12,700 13,100 26 Total Customer Accounts 649,600 731,700 753,500 776,200 799,500 823,500 Administration and General 27 Personal Service and Salaries 240,400 266,800 274,800 283,000 291,500 300,200 28 Employer Benefits 65,000 70,300 72,400 74,600 76,800 79,100 29 Insurance Premiums 15,200 16,000 16,500 17,000 17,500 18,000 30 Professional Services and Fees 51,600 44,300 45,600 47,000 48,400 49,900 31 Publishing 4,700 4,000 4,100 4,200 4,300 4,400 32 Rentals 81,600 79,400 81,800 84,300 86,800 89,400 33 Repair and Maintenance 177,600 167,900 172,900 178,100 183,400 188,900 34 Materials and Supplies 160,600 153,500 158,100 162,800 167,700 172,700 35 Job Perforrnance Expenses 36,900 43,100 44,400 45,700 47,100 48,500 36 Utility Expenditures 75,700 76,900 79,200 81,600 84,000 86,500 37 PILOT and Franchise Fees 258,200 284,700 294,200 312,200 331,000 350,900 38 Total Administration and General 1,167,500 1,206,900 1,244,000 1,290,500 1,338,500 1,388,500 39 Total Operation and Maintenance Expense 7,388,600 7,879,700 8,198,200 8,411,900 8,628,800 8,794,600 2-4 , TOWN of ESTES PARK Inter-Office Memorandum September 10, 2003 TO: Utilities Comi~~f FROM: Bill Linnane O(/'(,Â« SUBJECT: Water Department Cost of Services Analysis/Water Rate Study Background: John Gallagher will present the proposed Water Department rate structure as described in the above-referenced study. The study proposes extension of the 2.9 percent rate increase already adopted for the years 2004,2005 and 2006. A new 2.9% rate increase is proposed for 2007 and 2008. A fund balance of more than $1.1 million is projected for each year with a maximum fund balance of $2.4 million estimated for the year 2008. It should be noted that the 2004 estimated balance of $1.1 million is the projected balance included in Black and Veatch's 2001 study. Cosl/Budget N/A Action Staff recommends adoption of the study and also the 2.9 percent rate increase for the years 2007 and 2008. This will extend the 2.9 percent rate increase currently approved for 2004 - 2006. BL/lb 3-1 4 I. 9/10/2003 3:39 PM Table Wl Estes Park, Colorado Water Utility Cash Flow Analysis Line Description 2002 2004 2005 200Â§ 2007 2029 $ $ $ $ $ S 1 Beginning Balance 2,784,900 1,810,500 1,121,500 1,219,000 1,456,000 1,769,600 Revenues 2 Revenue from Adopted Water Rates 1,947,600 2,011,300 2,107,500 2,200,700 2,232,400 2,264,200 Additional Water Rate Revenue Indjcated Percent Months X22[ Increase Effective 3 2003 0.0% 12 0 0 0 0 0 0 4 2004 0.0% 12 0 0 0 0 0 5 2005 0.0% 12 0 0 0 6 2006 0.0% 12 0 7 2007 2.996 12 0 0 0 8 2008 2.9% 12 64,700 65,700 67,600 9 Total Water Service Revenue 1,947,600 2,011,300 2,107,500 2,200,700 2,297,100 2,397,500 10 Bulk Dispenser 16,000 16,000 16,000 16,000 16,000 16,000 11 Bulk Water Surcharge 25,700 25,700 25,700 25,700 25,700 25,700 12 Plant Development Fees 200,000 200,000 140,000 140,000 140,000 140,000 13 Water Rights Fee 300,000 300,000 400,000 410,000 420,000 420,000 14 Materials 2,400 2,400 2,400 2,400 2,400 2,400 15 Meters 42,900 42,900 42,900 42,900 42,900 42,900 16 Fire Hydarnt Fees 0 0 0 0 0 0 17 Interest Earnings 38,900 66,400 35,100 40,100 48,400 58,300 18 Land 100 100 100 100 100 100 19 C*her 73,500 10,900 10,900 10,900 10,900 10,900 20 Filing Fees 300 200 200 200 200 200 21 Sales of Fixed Assets 0 0 0 0 0 0 22 Total Revenues 2,647,400 2,675,700 2,780,600 2,888,800 3,003,500 3.113,800 Expenses 23 OperaOon and Maintenance Expense 24 Source of Supply 125,000 130,000 133,900 137,900 142,000 146,300 25 Water Treatment Purification 473,100 435,100 448,200 461,600 475,500 489,900 26 Distribution and Maintenance 498,700 510,400 525,700 541,500 557,700 574,400 27 Customer Accounts 215,000 220,900 289,400 298,000 306,800 252,500 28 Administration and General 696,500 538,700 504,500 513,600 526,200 544,200 29 Total Operation and Maintenance Expense 2,008,300 1,835,100 1,901,700 1,952,600 2,008,200 2,007,300 Debt Senice 30 tevenue Bonds 304,100 298,900 308,200 303,600 306,500 299,300 31 State and Other Loans 0 0 0 0 0 0 Proposed 32 Revenue Bonds 0 0 0 0 0 0 33 State and Other Loans 0 0 0 0 0 0 34 Total Debt Service 304,100 298,900 308,200 303,600 306,500 299,300 35 Capital Improvements 1,220,300 1,125,100 363,000 281,000 256,000 337,000 Transfers 26,400 36 Vehicle Replacement Fund 9,500 23,500 24,200 24,900 25,600 37 Interfund Transfer 79,600 82,100 86,000 89,700 93,600 97,600 38 Net Transfers 89,100 105,600 110,200 114,600 119,200 124,000 39 Total Expenses 3,621,800 3,384,700 2,683,100 2,651,800 2,689,900 2,767,600 40 Annual Surplus (Deficiency) (974,400) (689,000) 97,500 237,000 313,600 346,200 41 Ending Balance 1,810,500 1,121,500 1,219,000 1,456,000 1,769,600 2,115,800 Recommended Reserves 42 Operatng (90 days of OaM) 495,200 452,500 468,900 481,500 495,200 495,000 43 2% of Fixed Assets 392,600 424,500 444,800 464,000 483,500 505,600 44 Total Recommended Reserves 887,800 877,000 913,700 945,500 978,700 1,000,600 45 Ending Balance Excess (Shortfall) 922,700 244,500 305,300 510,500 790,900 1,115,200 46 Debt Ser/ice Coverage (a) 210% 281% 285% 308% 325% 370% Recommended Water Service Revenue Increases 47 Overall Annual Increase 00% 0.0% 0.0% 0.0% 2.9% 2.9% 48 Cumulative Increase 0.0% 0.0% 0.0% 0.0% 2.9% 5.996 (a) Total revenue less 0&M expense, dhided by tctal debt ser,ice. â€¢ 6 t. 9/10/2003 5:39 PM Table W2 Estes Park, Colorado Water Utility Capital Improvement Program Line Projected Total -Ng= Description 2003 2004 2005 2006 2007 2008 2003-2008 $ $ S $ S $ $ Capital Equipment Building Remodeling 15,000 144,000 10,000 10,000 10,000 10,000 199,000 1 Station Equipment 3,300 5,800 0 0 0 0 9,100 2 Furniture and Fixtures 0 5,000 0 0 0 0 5,000 3 Office Equipment 0 0 0 0 0 0 0 4 Data Processing Equipment 29,500 20,300 10,000 10,000 10,000 10,000 89,800 5 Communication Equipment 0 16,000 16,000 16,000 16,000 16,000 80,000 6 Lab Equipment 0 0 0 0 0 0 0 7 Purification Equipment 32,000 50,500 20,000 20,000 20,000 20,000 162,500 8 Tools 0000000 9 Vehicles 36,600 38,500 32,000 0 0 65,000 172,100 10 Total Capital Equipment 116,400 280,100 88,000 56,000 56,000 121,000 717,500 Waterline Projects Priority Two Projects 11 US 34 MacDonald's to Church 0 0 0 225,000 200,000 0 425,000 12 Hill Streets 0 0 275,000 0 0 0 275,000 13 Panorama Circle 0 0 0 0 0 216,000 216,000 14 Upper Broadview 0 80,000 0 0 0 0 80,000 15 Total Priority Two Projects 0 80,000 275,000 225,000 200,000 216,000 996,000 Water System Master Plan 16 Backup Raw Water Pump 1,103,900 00000 1,103,900 17 Fall River Tank #2 0 500,000 0 0 0 0 500,000 18 Fall River Tank#2 Pipeline 0 265,000 0 0 0 0 265,000 19 Total Vkter System Master Plan Projects 1,103,900 765,000 0000 1,868,900 20 Total Waterline Projects 1,103,900 845,000 275,000 225,000 200,000 216,000 2,864.900 21 Total Capital Improvements 1,220,300 1,125,100 363,000 281,000 256,000 337,000 3,582,400 . 6 4 9/10/2003 5:40 PM Table W3 Estes Park, Colorado Water Utility Projected Operation and Maintenance Expense P rejected Line Budget ...No. Description 2003 2004 2005 2006 2007 2008 $$$$$$ 1 Source of Supply 125,000 130,000 133,900 137,900 142,000 146,300 Water Treatment Purification 2 Personnel Services and Salaries 215,100 177,200 182,500 188,000 193,600 199,400 3 Employer Benefits 56,300 51,800 53,400 55,000 56,700 58,400 4 Insurance Premiums 5,100 5,500 5,700 5,900 6,100 6,300 5 Professional Services 12,000 14,000 14,400 14,800 15,200 15,700 6 Publishing 2,500 2,500 2,600 2,700 2,800 2,900 7 Repair and Maintenance 31,800 36,400 37,500 38,600 39,800 41,000 8 Materials and Supplies 90,500 84,900 87,400 90,000 92,700 95,500 9 Utility Expenditures 59,800 62,800 64,700 66,600 68,600 70,700 10 Total Water Treatment Purification 473,100 435,100 448,200 461,600 475,500 489,900 Distribution and Maintenance 11 Personnel Services and Salaries 271,400 286,400 295,000 303,900 313,000 322,400 12 Employer Benefits 76,400 89,100 91,800 94,600 97,400 100,300 13 Insurance Premiums 7,500 8,000 8,200 8,400 8,700 9,000 14 Professional Services 8,600 8,600 8,900 9,200 9,500 9,800 15 Rentals 88,900 101,200 104,200 107,300 110,500 113,800 16 Repair and Maintenance 35,500 6,200 6,400 6,600 6,800 7,000' 17 Materials and Supplies 700 800 800 800 800 800 18 Job Performance Expenses 9,700 10,100 10,400 10,700 11,000 11,300 19 Utility Expenditures 0 0 0 0 0 0 20 Total Distribution and Maintenance 498,700 510,400 525,700 541,500 557,700 574,400 Customer Accounts 21 Personnel Services and Salaries 46,400 48,500 50,000 51,500 53,000 54,600 22 Employer Benefits 15,200 18,900 19,500 20,100 20,700 21,300 23 Insurance Premiums 400 400 400 400 400 400 24 Professional Services 28,600 29,600 30,500 31,400 32,300 33,300 25 Materials and Supplies 121,300 121,800 187,300 192,900 198,700 141,200 26 Job Performance Expenses 100 100 100 100 100 100 27 Other Current Expenses 3,000 1,600 1,600 1,600 1,600 1,6CX) 28 Total Customer Accounts 215,000 220,900 289,400 298,000 306,800 252,500 Administration and General 29 Personnel Services and Salaries 195,400 217,600 224,100 230,800 237,700 244,800 30 Employee Benefits 50,700 55,200 56,900 58,600 60,400 62,200 31 Insurance Premiums 13,800 14,600 15,000 15,500 16,000 16,500 32 Professional Services 268,100 58,600 33,000 27,000 24,000 25,900 33 Publishing 2,000 3,000 3,100 3,200 3,300 3,400 34 Rentals 44,000 43,800 45,100 46,500 47,900 49,300 35 Repair and Maintenance 2,500 22,000 22,700 23,400 24,100 24,800 36 Material and Supplies 6,800 6,600 6,800 7,000 7,200 7,400 37 Job Performance Expenses 22,800 23,400 24,100 24,800 25,500 26,300 38 PILOT @ 2.5% of Inside Sales 31,000 31,900 33,500 34,900 36,400 38,000 39 Franchise Fee @ 3.056 of Inside Sales 37,200 38,300 40,200 41,900 43,700 45,600 40 Subsidies-Housing 22,200 23,700 0 0 0 0 41 Total Administration and General 696,500 538,700 504,500 513,600 526,200 544,200 42 Total Operation and Maintenance Expense 2,008,300 1,835,100 1,901,700 1,952,600 2,008,200 2,007,300 TOWN of ESTES PARK Inter-Office Memorandum September 10, 2003 TO: Utilities Committee FROM: Bill Linnane (a< SUBJECT: Design/Construction Management Scope of Services for the Proposed Fall River High Zone Water Tank and Water Line Background: A 0.3 million gallon high zone water tank located in the northwest portion of the Town's water service area has been included in the Water System Master Plan since the plan was adopted in 1985. The attached map shows the location which is adjacent and north of Hwy. 34 near the north entrance to Rocky Mountain National Park. Design and Construction Management Scope of Service is included in the proposed 2003 budget revisions as well as the proposed 5-year Capital Improvement Plan. Construction costs are included in the proposed 2004 revised budget (Continued on page 2) Cosl/Budget: Design/Construction Management Cost: $76,000: (Original Scope Cost of $84,000 was negotiated to $76,000) Revised Budget: (as proposed) $76,000 (Note: the tank and water line cost estimate is $765,000 and is proposed for the revised Action: 2004 budget) Staff requests and recommends approval of the $76,000 Scope from Cornerstone and requests to bid the project and anticipates presenting the results at the November Utilities Committee Meeting. BL/mjs Attachrnent 4-1 Background - Continued from Page 1) Construction of the tank was originally budgeted in 2003 but was put on hold due to the cost of the Marys Lake Raw Water Pump Project. Easements have been obtained and the hydraulic analysis supports the location and elevation by increasing the "blue line" in the Fish Hatchery Road and Fall River Road area to 8,055'. Cornerstone Engineering submitted a Design/Construction Management Scope of $76,000. If the proposed Scope is approved, design should be completed in October and the project would be bid by the last week of October. The bid results would then be presented at the November Utilities Committee Meeting. Construction is anticipated to begin January 2004. Staff requests approval of the Scope as well as approval to bid the project without additional Committee approval. Staff will present the bids for approval at the November Utilities Committee meeting. 4-2 9 W FALL RI vERRD <SS> i lo 33 \ 44 1 .Joiul ji u U.1 ~ Z 9 . <244 00 Ul 8 . Rl - m , 4 , 1 . 4 & 1 . dcti 1 . Z .-0 01, - CROOf J U-1 4 4 O 9 GL .â€¢ I ... gaul- P 469 Ate ~61 1 91*2 1/ , 4-3 .......i" 9.\I. gag mgmam or kit 4 . 1--01> oc cr/'*tr %%% RA ~--NI<AN LINE PROPOSED CORNEASTONE (970) 586-2458 437 South St. Vrain Estes Park, CO 80517 Fax (970) 586-2459 ENGINEERING & //( SURVEYING, INC. E-mail: ces@charter.net September 5,2003 Mr. Bill Linnane Director o f Public Works Town of Estes Park P.O. Box 1200 Estes Park, CO 80517 RE: Fall River Water Storage Tank and Associated Water Line Dear Bill: Cornerstone Engineering & Surveying, Inc. (CES) appreciates the opportunity to submit the following scope of services with cost for the Town of Estes Park, Public Works Department, Fall River Water Storage Tank and Associated Water Line. Water Storage Tank The Town of Estes Park currently operates a water distribution system along the Fall River corridor above the Town's blue line. The system is operated by a pump station at Fall River Drive and U.S. Highway 34 which supplies water to an existing 100,000 gallon water storage tank located in Fall River Estates. The tank provides potable water and fire flow storage for property above the blue line at 7,850 feet and below the existing Fall River tank at 8,020 feet. Existing and future water system demands are as follows: Taps USaHe â€¢ Existing Town Taps 234 56,600 GPD â€¢ Existing Buildings with Potential Connection to Town System 164 39,000 GPD â€¢ Future Development within Town Limits 105 25,000 GPD â€¢ Additional Development within the Study Area 192 46.000 GPD Total Potential Potable Water Demand 695 168,000 GPD Additional storage for fire flow at 2500 GPM for 120 minutes is 300,000 gallons. Total Storage Recommended: 60% of Average Daily Flows = 100,000 Gallons Fire Flow Storage = 300.000 Gallons Total Storage 400,000 Gallons 4-4 Mr. Bill Linnane Fall River Water Storage Tank/Water Line September 5,2003 Page 2 The turnover rate of the water storage tank per the current average daily demand would be 7 days. The proposed tank would be a 300,000 gallon concrete tank to supplement the existing 100,000 gallon water storage tank. The tank's elevation would match the existing water storage tank elevation. The proposed location for the water storage tank is north ofU.S. Highway 34 adjacent to the MeGregor Mountain Lodge. The owner of the property has expressed interest in having the tank placed on his property. Construction ofthe tank is estimated at $450,000 based on current rates around the Front Range of $1.50 per gallon. Water Line Approximately 1,250 linear feet ofnew 8" ductile iron water line would be required to connect the water tank to the Fall River transmission main near the Harmony Foundation. The water line would involve the acquisition of three to four easements, crossing of Fish Hatchery Road, Fall River and U.S. Highway 34. Additional valving will be required to help equalize the flows between the two tanks. The estimated construction cost for the 8" water line is $200,000. Design Services In defining our design services, we have utilized knowledge gained from similar projects with water storage tanks and water lines for municipalities and private clients. Diana Horner of Bates Engineering, Inc. would supplement our team for the tank's structural design. Project Coordination and Permits â€¢ Attend all necessary Town coordination meetings. Preparation ofthe following permits: i. Army Corps of Engineers 404 Permit for the Fall River Crossing. ii. State Highway Utility Access Permit iii. Colorado Department of Health iiii. Larimer County Department of Health Â· Preparation and negotiation of necessary easements. 4-5 Mr. Bill Linnane Fall River Water Storage Tank/Water Line September 5,2003 Page 3 Prepare Preliminarv and Final Construction Plans Survey â€¢ Grading Plan with Bench Mark Elevation â€¢ Geotechnical Investigation â€¢ Structural Plans â€¢ Tank Piping and Fixtures â€¢ Water Main Plan and Profile â€¢ Approval of Construction Plans â€¢ Specification with Construction Documents for bidding â€¢ Estimate of Construction Cost Construction Services As the final design and approval of the project is completed, CES will provide bidding and construction observation services. Our approach is to provide a seamless transition from design services to construction services retaining the vast amount of information learned during the planning and approval process. CES responsibilities during the construction phase of the project will be as follows: â€¢ Solicitation o f bids Â· Review ofbids with recommendations for contractor â€¢ Review of submittals for approval â€¢ Review of contractor pay request â€¢ Resolve questions for owner and/or contractor â€¢ Construction staking â€¢ Daily on site inspection to insure the contractor complies with the intent of the plans and specifications q, Cost of Services Design The cost of design services shall be: $46,648 Construction Services The cost of construction services shall be: $29.136 Total Cost $75,784 CES cost does not include materials testing. 4-6 Mr. Bill Linnane Fall River Water Storage Tank/Water Line September 5,2003 Page 4 CES knows how to design and build quality projects. We have the proven experience, the quality minded professional staff, and the motivation and desire to help this project become a reality. We look forward to your approval and the opportunity to continue working with the Town of Estes Park. We will provide you with services that promote a very successful project for your partnership. Sincerely, Cornerstone Engineering & Surveying, Inc. *11 -fx=-- Michael S. Todd, P.E. Principal 4-7 CORNERSTONE ENGINEERING AND SURVEYING, INC. ENGINEERING COST FALL RIVER TANK AND WATERLINE DESIGN PERSONNEL HRS. RATE/HR. TOTAL COST Principal 24 $90.00 $2,160.00 Project Manager 90 $70.00 $6,300.00 Project Engineer 120 $60.00 $7,200.00 Engineer Technician 90 $50.00 $4,500.00 Surveyor 8 $55.00 $440.00 Survey Crew 32 $110.00 $3,520.00 AutoCadd Technician 40 $50.00 $2,000.00 Clerical 16 $33.00 $528.00 Structural Design Consultant $20,000.00 TOTAL DESIGN $46,648.00 CONSTRUCTION OBSERVATION PERSONNEL HRS. RATE/HR. TOTAL COST Principal 24 $90.00 $2,160.00 Project Manager 80 $70.00 $5,600.00 Project Engineer 120 $60.00 $7,200.00 Engineer Technician 90 $50.00 $4,500.00 Surveyor 8 $55.00 $440.00 Survey Crew 24 $110.00 $2,640.00 AutoCadd Technician 24 $50.00 $1,200.00 Clerical 12 $33.00 $396.00 Structural Design Consultant $5,000.00 TOTAL CONSTRUCTION OBSERVATION $29,136.00 TOTAL ENGINEERING COST $75,784.00 4-8 TOWN of ESTES PARK Inter-Office Memorandum September 10, 2003 TO: Utilities Commifee A i 1 j UL EROM: Bill Linnane vv SUBJECT: Glacier View Water System Inc. request to exchange one CBT unit for one ac. ft. of Town-owned Windy Gap water rights Background: Greg White will attend the committee meeting to present this agenda item. Glacier View Water System Inc. has submitted the attached letter of request to exchange one CBT unit for one ac. ft. of Town-owned Windy Gap water. The request is for a 20-year lease to be renewed if both parties agree at the end of the period. The company also agrees to an annual $350 maintenance charge payable to the Town. The company will install a bulk rate meter and connect to our system if the Town's water main becomes contiguous to their property; all at the Glacier View Water System Inc.'s expense. The transaction does not change the Town's existing water rights total. Cosl/Budget N/A Action Staff recommends approval of the request. BL/lb Attachment 5-1 LYNN A. HAMMOND LAW OFFICES 200 EAST SEVENTH STREET. SUITE 418 LYNN A. HAMMOND LOVELAND. COLORADO 80537 PHoNE: 970-557-1023 FAx: 970-559-9380 E-MAIL: LAHLAWYER@AOL.COM Dear Mr. Lannane, I am writing you on behalf of my client, Glacier View Water System, Inc., a group of eight home owners who are located just outside the City of Estes at the approximate location of the intersection ofHigh Vista Lane and Glacier View Lane. For a period of years, the subdivision has been dependant upon a small capacity well for its domestic water requirement. The well has been permitted to withdraw up to 2.5 acre- feet annually, and limited to indoor use only. Recently, the homeowners have added a second well to the system to help compensate for the poor production of the original well during the recent drought. Normally, wells such as these that produce less than 15 gallons per minute are considered exempt from state administration. However, because of their use in a subdivision, these wells must be operated pursuant to a Water Court approved augmentation plan. This requires the homeowners to introduce into the stream system a foreign water source that will compensate downstream water users for the (virtually negligible) effect their wells have on the Big Thompson River. It is our understanding that the City has some reusable Windy Gap water available. Unlike CBT water which is readily available in small quantities but may only be used directly or by exchange, Windy Gap water may be used in augmentation plans in accordance with District policies. Therefore, we would like to enter into an agreement with the City of Estes Park whereby one acre foot of CBT purchased by the homeowners is transferred to the City's water treatment plant and exchanged for one Acre Foot of Windy Gap. Preferably, this would be accomplished by a direct exchange in ownership of the rights. However a second option might be a long term (20 year minimum) lease agreement whereby the augmentation plan is credited with a "second use" of the Windy Gap water. The homeowners understand that there will be some time expended in accounting for their use of this water and are willing to provide reasonable compensation or make other arrangements as necessary. I have also been advised by the homeowners that previous negotiations with the City regarding long term lease arrangements have been unsuccessful. It has been suggested that the homeowners tap into the City water line located approximately 1800 feet from their property. Let me assure you that the high cost associated with installing the necessary main line and laterals in the local bed rock makes this option financially infeasible. Quotes received so far are all well over a quarter million dollars. Therefore, we are hoping that the homeowner's private contribution of water to the municipal system changes the course of the negotiations that have occurred thus far. 5-2 The homeowners have already invested a significant amount of money in the development of their water right. They have filed for a series of costly extensions to their well permit and paid extensive legal fees in addition to well installation costs totaling in sum over $30,000. As I'm sure you can appreciate, it has also been psychologically unsettling to live with an uncertain water supply. Therefore, I would appreciate if this letter could be circulated among the responsible reviewing party as soon as possible, so that we may begin annexing the subdivision into the Conservancy District's Boundaries and formulating a contract agreeable to everyone. Thank you for your assistance, if you have any questions please feel free to call. Sincerely, L t-ki-- Sean Rutledge Esq. 5-3 LIGHT AND POWER FUND 2002 VS. 2003 MONTH ' CASH FLOW COMPARISON AUGUST AUGUST 2002 2003 Difference Revenues Utility Sales $ 633,778 $ 695,729 $ 61,951 Other 80,993 15,117 (65,876) Total Revenues $ 714,771 $ 710,846 $ (3,925) Expenditures Operation and Maintenance Expense Source of Supply $ 302,327 $ 321,289 $ 18,962 Distribution and Maintenance 111,659 220,451 108,792 Customer Billing and Accounts 32,180 21,294 (10,886) Administration and General 84,077 31,120 (52,957) -Transfer to Vehicle Fund 368 2,617 2,249 Total Operation and Maintenance Expense $ 530,611 $ 596,771 66,160 Debt Service 25,145 24,917 (228) Capital 276,027 153,989 (122,038) Transfers to General Fund and Museum 61,896 65,661 3,765 Total Expenditures 893,678 841,337 (52,341) Surplus (Deficiency) $ (178,907) $ (130,491) $ 48,416 Note 1) Transfer and debt service are annual amounts accrued on a monthly basis. R L&P 1 LIGHT AND POWER FUND 2002 VS. 2003 YTD CASH FLOW COMPARISON YTD YTD August August 2002 2003 Difference Revenues Utility Sales $ 5,069,027 $ 5,362,404 $ 293,377 Other 246,240 280,248 34,008 Total Revenues $ 5,315,267 $ 5,642,652 $ 327,385 Expenditures Operation and Maintenance Expense Source of Supply $ 2,628,751 $ 2,651,871 $ 23,120 Distribution and Maintenance 844,625 904,027 59,402 Customer Billing and Accounts 368,084 394,776 26,692 Administration and General 789,089 641,124 (147,965) Transfer to Vehicle Fund 2,945 20,933 17,989 Total Operation and Maintenance Expense 4,633,494 4,612,731 $ (20,762) Debt Service 201,157 199,333 (1,823) Capital 875,182 575,639 (299,543) Transfers to General Fund and Museum 495,165 525,287 30,121 Total Expenditures 6,204,998 5,912,990 (292,007) Surplus (Deficiency) $ (889,731) $ (270,338) $ 619,392 Note 1) Transfer and debt service are annual amounts accrued on a monthly basis. R L&P 2 . 4. 1. 0 4 I '1 1 4 . 12 I . 9// 4 .: $ I . 1 1 4%0. . 4 - 4 I I . 4 . I 6 0. / 1 . g - 3,â€ž . kl '- ' .9 4 + 4 t , 1 b + : 4 r. h 4 t . U - 0 0 1 , Z 4 . I Y . 1% , . a . '92 4.- - #74 4. , , , 8. 1 1 1 Li 4 . . 4- . * * U ' AL 4 1, .$4 .1 73 - 0 4 CL 2 - 4 & F - 4 '1* i* 1 , 7 4 49. . -4 0 % $ .4 - k . . . -16 $ 4 34 9 1 .. , r N CO * , 4, 888 . ..f. 1 * ic 1 N 01 01 1 k 1 Â· -+41+ 1 4 4 . . 1, A, r -. 4. :E . . .4.1. 1 If . . I I :21 Â¥\ * ~. - 1 I. . 4 t - + 4 ' I 1/ 't A k .f . .. ... ~ A., , *4 - 1 44 - p ,â€¢1 1 ./ 1 1 % Â£ A - '4 . .1 11 4 - 1. 1 1 11 j. I D If 4 4 + '' . 1 1 - 0,9 0 0 06 0 0 0 0 0 g O 0 0.*00 1 . C) I CON O 0 f 8 r- .I r- 1 '10 " 1- 1 1 1 t - / I 1 + 11. . ., Mil V\131SAS j - I 00 s 4. 97 idÂ¥ J lept . 40=1 uer -te 00017 L .~ *422000 Â¥ 21000-- 4 2000 Â· , 1*9 1 1 1%8%8%8%8*R**********%8$***%8%8**3******33***S****%8* .0 1 1 1 1 t 1 1******Â§**9$9**9%8%8**%8*Â§**&%48**88*%******$$66 0 1 - &%**%******S*$$*%8%**89$83***%8%8*S***k g 1 1 - 1?8888888~888888888*3888888888888888888888*888888888888*8888888*8$ 4,9 13*$9%*%8%8$$9R~~r*?99$3*****%*SM/*ESS#8*%866 1/1 1 1 1 1 14 1 R**SM**S**SMS**Â§&%*S***%8*&8**%83**$69*$$***S ~ 1 - f ~06~-WA~~111/V~,AA/,A/v/v'v'v'v'v'4444444 4415Â·,66/44,â‚¬444/0 Vâ€¢/v'Ve/Â·/./vV~'sAAA;~ ~~1 Â¥1.-............Yâ€¢ 11 EÂ¥**%:***ill.*illi~ifiti0~illilill***:*6***4.8 I '1 1% 1 ~f'i.:..'.'j~0~i.f:~Â®>NE-:14%*:90:~**PLYLit#*AVMMUM//.:VVW~. C. 09*69*33*4****%8%*$9***99%**%8%89 160 booÂ«Â»D*<XecÂ»*000%;Â«0;Â«Â»04<XX7NEK7;<*DÂ«><y><0>fÂ»Â¢*,00***Â»,-,IX;Â«>4 . .2,4. 1%8*MS*SR**%8%8*%68%~ \*Â§***9*9:*%*Ms/40/~4301"I Fâ„¢- 1 1 1 1*5*R225%2055:*5?2*59*M.--Â°--*--'- --'- -'-'--*----'-Â«**x>*4&*>b*Â§2********444***4>934%"995$5554 -.1 19%**S***%9*$**$6$***3:*%**%8*%8$$*$*8**%833Â§8$%8$$$.-B 1 1 ~ew,~Ae;VPP\.Â»bl.\AA Â»Â»Â»Â»hAAAAAAAA,Â·%.>AA P~ 22Â»~ A.6. v.Â».4\Â»Â»Â»..Â»Â»trhb.FFF*~EP~.,4.PV,w,~Â»Â»PPÂ»Â»FhArÂ»\ Â»Ve,AÂ» A .1 1 'â€¢ -1Â¥rrrY ........ 1*Si83*****%S***MS**%*3*%&%Â§8Â§***%SM**SM*SM* ~ I I 1 1 IMS**rs*%*92%8Â§%**8***Â§8*8*%8*8****8*SR*Â§88%8*69***%* 1 1 1 1 i '2 .L t Z~ ,1 41 4, 8 09,1 ili; - E--ur -4 r 1- 11-1 9 1111 ili ' rp -- . 5 1 -2 1 1-1 -0 --1/ ' 1:eggianizin.m, 1-1 11 4 - Â¥ 1 02000 02002 102003 =12%82% - I. 61 *41 I J *1 01 . A 6 ..: i ..4 - i. .44Â»fl , t. bLt f + I. 1 1 . ry.., 114 4 0 9 1. 6 * 8#wAMw~w#*RAMRAY##AwmRssfFdrAss*AANA#*Rawar,53 89 L I L . 4. Â· A . ..1 , , 4 4 41 '4 . R 0, + . 1 9 I , . 1 -4 & 1 h '19**S***S//*//*A////r&~f#~//rAS%**S/***%889$$*$6 I. 8 1, 1. * 4.. 4 '' In 1 .'F~F . 4 ... .1 Â¥ 1 , '' ~1 ~ 1~ **A â€ž *4 1 . â€¢IA M Ii' ~~ c-; e<4*'r".m~.w-vz.rrv.:-: :.::'v: '. *0 B -- ~ '7~*%8*Â§8**s*ss*ss***~~*****2 41.i t 9 00 y : -. 4 41 4 1 t I I . 0 *-I ... 1, 4 C tt paw#Awk#k**SY&%**AS*%8k , 4 I . 1 I. ... I . 4 k . '1 $*****k***8**me*Â§$Â§ 4 * 4. 4 lili. - 1 - . . 4 -'4 : 4 44#FAVWBAW#WRiS* . I , A .* 6/ - 4 1 F 1 7'.el r L. i 6 4 1 :4 1 . 11 ' m."Imm.LE . . 6 7 + 1 3 1 f //M//M//M 0 E~mSSSSZ~SSE (D. Lt.24,.I fr L.Â· d . 1 - 41. f " 2 1 h 4. , 1 Â·Â· 1 4 , I I . 1 . f . 4 0 $ O , 1 4 . . .. Â£ I -M . 24 4 - I I~Â· 4 . ir . % 'Deseuoind AMIN DIA '~ -9 4 ,Â· . 1 ' 1 1, i 0 Loadh99.xls 9/8/2003 02001 Â£001 m AON *10 deS' JdÂ¥ 100 :00009 -,r. ENERGY PURC HASES 3 ~D 2 2002 |= * 8-d91 hi YEAR'TO DATE 4 12000 --1 - 100000 0400, r 80000' 1-:. 11 . ... 1 # 01, ~ 4 . I # â‚¬ I ./ .. . . 5 ~ . 2 4 0': 1 Â·It v . 1. 4,4 -9,? 3 i. .. . i r- i .4, 4 4 C , 141 . & 6 44 - 't ' , 1, 1 i 1 ..Â¥ I . .41. 0 b At ** , /* . ., , 1. -t . - : ... i 1 + ./ 1 i. rig Â¢E .1.Apa#f>00*~0000~ * . 4. A - . 1 tÂ· 1*;t- .. - I. 1 .* 4 P 1*077777,74*747*131#9' . /1 ..6 59 hy; 4 -4 r .1 , ' 6 6. . 4. i ' ~I';229APjwgiONVS#*/76%%%4% P , 1 v. 0 . t. 1.4 , . 6 - 1 -4 . k - :111+11... 1,33*AAA;~AAA.984.AAA.AA.A.A- 2. 9- TE.- C . Â¥ A . , S. 4 . i Â».. h 0 4. . 6 ' pg,00@1000000g1'gle'gl'g...10& gl : . '11 4 J ..Â· 1 ..'. - . Â£ 4 7 * 1. ..... t . .............................. . . . 4 k -4,1 -1+000000Â»Â»Â»Â»00,2 1 5 +I 0. , 11 1 1 ........1 1/1..............1- 4% * I O * 1 &<f<%%%<ff<<fiffi<%4 , 1 1 Ir 4 k. 1 , 4 ..4 2Â¥ , 1 '4 r . . I Â¥ r r * ........................ 1 1 4- + Â»2,2202*024*#Fardrar*770,4178 44 { 1 9 ., 7% ,\ /: \ t.* t- ./ /1 . 6 * ......â€žÂ¥ ............................ F:.1 ............................. + e i N-raM~M@~424*9444444%44 -4,3 4 $ . 13 j 1 .1 2-2 4 h I.:I: . i 4, 4., 11 48,bad,9~4*0,~*5*PAE#JU,9,2,;ia,aiai#424 6, I *. 1 1 1- + 4 1 A .1 1 .... V Â¥ ................... ........ .. . # 44*%9#9"%941%9411/%%%9A%%1#11/&%92~Â¥. 1 1 .4. 1 .1 ./ 91 . 1 .1 1 I 1 $ 1 4 .0 0 8 81 0 8 .0 0 0 8 . 0 r 0 04 O CD . 4 h.:C (0 .lo 9 1 I AC ($) 931Â¥S *1HiNOIN . ,-~ 4% O, . r 4 2, ... 1 t ' 0, w + i . v 4 4 4 . 9 1. - SALEHIST.XLS 9/8/2003 2001 zooz m â‚¬0039 000 . AO N * p. 130 unr : - 1 uer 'ELECTRIC~LE~BO~ 6-d91 hi 00;0007 , - i Â·r . 400'06â‚¬ 800,000 -Â· -- - . I * . 4 -1 2 .4 . . 4 P y* W J r- 0.1 CO CD 4 'R O 0 00 P . O 0 0 -0 1 . 4 f 0 2 5 1 & I. k>94\30004Â»49\4113 Iii IN 15Â·Â· 64<NÂ»(Â» 4 -1 -& 3'.K o , P . 1 6,1,& 14-4 4 * *-6 1 t. f . 1 1XXÂ«%<NXÂ»><Â»Y,*'::**<p<Â»fv..Prprppx\Â¢Â«Â»9Â« j i~ ~+ 1 . -r t . * . . % I-: 1 f A . . % 4 4 6, I. .> Â¥ 4 1 .. . i , EnÂ©'4940Â©44%1~~4<Â«''CÂ»Â¢'Â·0â‚¬M>04%449~~Â«'â‚¬Â»4# 'i OIl â‚¬ it. .-1 i'~IÂ· * t, OJe .;1~xvxY<Yxx9341<,2*~.*1,*:*'*,br' *"*:'bbx'%'41*16' . A ' + 4, 41 " %2 .. 1 - 1 . I Ix~<Â«<Â»Â«<YYFFY <XY>N>44\Trpt\N I % 1 . 4 0 4. %1 - 1 1 7 . 16 .f -- 2- * r - 01 " tÂ«xÂ»NÂ»'~Â«\V~Â«xtz*xÂ»Â«vÂ·Â«~. 11Â·2 +1 Â·29- + 1 1# / 1 9=10'r~ 0 J I ' 17 4 + ul Ul , $ 0 di LU O 1 00 19\99Â«\>~Â«'Â«FT,1 4*Rq g , 4 1 06 1 N I '44 ZÂ¤ *0 * 4 |* ti%-7-7 Y-*d-ryja:Â¥2~9-6,27Â·3 - .. t % 4 .. I. 1 6. , I . a ['#WeE-6-6-4496*6-*vÂ·r . f Â¢ ..4 1. 0 "t j , J. V 3 0 1 4 - 4 A I , . KNY>Â»<999Â©vi 1 4 1 h :41 - I . ... D. 1, 116, , ' r I 4 , - ~644*.C.LK. t. ' 1 > 1. 1 1, 0 , . 1 1 Â· e....cÂ¢ t 1 ' e + 11 W I ... 7 I . O .O 6 0 0. 0 0 0 8% 0, 3 - 8, 4, 8-4 8 5 .4 '8- O- O 4 0. ct i 0 0 8. 0 O + 0 0 0.00 0 0 4 i |94*/MEMEY#.6.5.4-flE<;EI<66-2-6,6'vee . C ' A U 1 /313<64<1604xk\34Â»14 34. , I i 9 1 41 0 O * 0 9 01. .O 0 C.-1-CR P. 0- ai ' cO (D 10 4- CO â€¢ f r ($) SaTIVS 3140 01 klÂ¥3* . 1 , rk 1 1 L 14.i ** 4 Â¥ trn--.-i~~1, â€¢ SALEHIST.XLS 9/8/2003 Â·YEAR T SALES ' des pov Jd . Jew | 6.70~22000032YTD ~ _ 01.-dÂ¥-1 21 9 -I 7,000,0040 ' 9/8/2003 2003 Year-to-Date Electric Revenues Vs Budget I ./ , 9,000,000 $ 1 ' 8,000,000 * L -41 0 7,000,000 - --- 4 6,0000;000 ~ . .. - - - - 5,000,000 .. - m O Budget 4,000;000*- - -44 - - 2 -1 licetual 3,000,000 2,000,000 . 1 * 1,000,000 ---fE- I- - ~- r- L O -M' 1 L . 1 1 ' 1.1. 1 1 , I f. L>'C-'CD (5>0 *. 4 2 22. 2 22 g.% 2 * 58 028 . - . I A I 2003 Year-to:Date PRPA Invoices vs. Budget - - ...r: . 4,500,000 $ ' 4,000,000 3,500,000 I . 1. I 3,000,000 --- .. 2,500,000 - - - 0 Budget 2,000,000, -- -- -Ii-I- - - = Â· 1 Actual 1,500;000 12000;000 * 500,002~ Im - # i WIll , 1 1 1 - 1 C ../ L * C S 0) a > . r 222 St Z 0 0 . 1 ./ R L&P-11 1 1 1 11 17 WATER FUND 2002 VS. 2003 MONTH CASH FLOW COMPARISON AUGUST AUGUST 2002 2003 Difference Revenues Water Sales $ 306,733 $ 274,156 $ (32,577) Plant Development Tap Fees 9,580 10,101 521 Water Rights Tap Fees 8,600 16,200 7,600 Other 25,444 796 (24,648) Total Revenues $ 350,357 $ 301,253 $ (49,104) Expenditures Operation and Maintenance Expense Source of Supply $ 104,423 $ -$ (104,423) Purification 25,948 19,924 (6,024) Distribution and Maintenance 44,446 27,270 (17,176) Customer Billing and Accounts 7,810 24,643 16,833 Administration and General 33,914 16,056 (17,858) Transfer to Vehicle Fund 417 792 375 Total Operation and Maintenance Expense $ 216,958 $ 88,685 $ (128,273) Debt Service 25,564 25,348 (216) Capital 7,805 66,262 58,457 Total Expenditures $ 250,327 $ 180,295 $ (70,032) Surplus (Deficiency) $ 100,030 $ 120,958 $ 20,928 Note 1) Transfer and debt service are annual amounts accrued on a monthly basis. RW1 WATER FUND 2002 VS. 2003 YTD CASH FLOW COMPARISON YTD YTD August August 2002 2003 Difference Revenues Water Sales $ 1,531,084 $ 1,350,441 $ (180,643) Plant Development Tap Fees 173,078 178,270 5,192 Water Rights Tap Fees 197,692 239,085 41,393 Other 115,883 138,246 22,363 Total Revenues $ 2,017,737 $ 1,906,042 $ (111,695) Expenditures Operation and Maintenance Expense Source of Supply $ 1,182,326 $ 75,769 $ (1,106,557) Purification 300,089 278,763 (21,326) Distribution and Maintenance 215,105 317,629 102,524 Customer Billing and Accounts 37,909 95,224 57,315 Administration and General 342,304 367,599 25,295 Transfer to Vehicle Fund 3,333 6,333 3,000 Total Operation and Maintenance Expense $ 2,081,066 $ 1,141,317 m $ (939,749) Debt Service 204,515 202,784 (1,731) Capital 432,041 1,078,585 646,544 Total Expenditures $ 2,717,622 $ 2,422,686 $ (294,936) Annual Surplus (Deficiency) $ (699,885) $ (516,644) $ 183,241 Note 1) Transfer and debt service are annual amounts accrued on a monthly basis. RW2 WATER FUND 2003 TOTAL BUDGET VS. ACTUAL YTD CASH FLOW ANALYSIS YTD Budget August YTD % of Target 2003 2003 Budget % Revenues Water Sales $ 2,183,040 $ 1,350,441 62% 66% Plant Development Tap Fees 175,000 178,270 102% 67% Water Rights Tap Fees 330,000 239,085 72% 67% Other 100,013 138,246 138% 67% Total Revenues $ 2,788,053 $ 1,906,042 68% 67% , Expenditures Operation and Maintenance Expense Source of Supply $ 125,000 $ 75,769 61% 95% Purification 398,351 278,763 70% 67% Distribution and Maintenance 561,408 317,629 57% 67% Customer Billing and Accounts 248,686 95,224 38% 67% Administration and General 782,075 367,599 47% 67% Transfer to Vehicle Fund 9,500 6,333 67% 67% Total Operation and Maintenance Expense $ 2,125,020 $ 1,141,317 54% 67% Debt Service 304,176 202,784 67% 67% Capital 1,269,135 1,078,585 85% 67% Total Expenditures $ 3,698,331 $ 2,422,686 66% 67% Note 1) Charge for Services target based on previous years data. Note 2) Source of Supply target based on previous years NCWCD invoices. Note 3) All other targets based on % of Year complete. RW3 N"""10"01,1,1/1. 1 Vt,1/00#1#1"""""" L ' N#,0,0,1,1,1,1,#,1,/,##,6 Â»"Ne<,eeÂ©eÂ¢,NONÂ©NÂ©4>004>'"4""'pj,",0.'"" k P hxÂ»Â©eeÂ»Â»NeÂ©6Â»xâ€¢e~Â»NeÂ©*eeÂ©4Â»Xy ' L6007>597,1,000~/f>599Â«Â»1117/7747117/172 w 4/004./.*illilill'llill'llixÂ«4~ CE k.......4...d..4,.::... \ 1 KNeeeÂ¢Â©04â€ž.4,Â« \****##f#***,#f#,##'* Â»0Â©NON,Â»Â»xeÂ»x N######m#"#01/"##, \# if ##**#######*#//*.' 2XNX\Â»4Â»00*Â»**4Â»Â¢ \# *#/##*--.- ..0/*/#*/#11* 0 1 R Sales.xls 9/10/2003 Â¤2001 1001Â¤ 8001 0 Dea AON 100 des Bnv inr unr XeIN Jdv Jel/\1 qe:1 uer Water Sales by Month 300,000 250,000 - - 000'OOL -- 000'09 200,000 . 000'09X U, J m ' 0, '40111#110'IIi#11*01 10* */ft#F#fiti###*. Ii,11/1,1 5,0,0,8,1, i i "1,10,1,0,/ 'll 4- 41""1""1111""""/1/1/1,1. F////////<////////////////// kÂ»XeÂ»x4xexexeÂ»xer 9%8 , N/#**//*1####*##/***8#*li Â£9: 1 - LO O a ..Â£ I 'Â»Â»Â»XeleÂ»Â» N""""f fl f f j. -' } AXÂ«eÂ»XON N"151""le ~i 1 . >ff#fl,jib UÂ· t' I Â¥ 10Â»Â»Â» 4. 11 4/5/##A 1<Â»X>Â¢ P . I lili* lim 1 -/ t, . 1"k ~2001 02002 IZZ--2003 AUN JUU uets r unr ABIN JaÂ¥ Jel/\1 qe=1 ibl