Loading...
HomeMy WebLinkAboutPACKET Town Board Budget Study Session 2011-10-07To: Honorable Mayor Pinkham Board of Trustees TOWN OF ESTES PARK From: Jacquie Halburnt — Town Administrator Steve McFarland — Finance Officer Date: October 7, 2011 RE: Budget Sessions Background: Welcome to week one of the three week budget study process. The budget is a large, complex document, so it is being presented to you in three pieces. As was the case with the 2011 Budget process, the 2012 Budget will be presented in much the same order as it appears in its final printed form. Internal Service Funds (Fleet, Information Systems Technology and Vehicle Replacement) will be reviewed first because their costs are passed along to many of the departments and funds that will be reviewed in subsequent weeks. We wiil then systematically present the General Fund departments. Week One will include Legislative, Judicial, Executive, Elections, Finance, Community Development/Protective Inspections, Buildings, and Employee Benefits. As was the case in 2011, staff is presenting an annual budget that in form is unchanged. The Department Heads and/or other appropriate staff will again deliver brief presentations reviewing their services and highlighting expenditure items within their budgets. Following the October 2011 budget sessions, the budget will be reviewed in its entirety in the November 08, 2011 Board meeting and will be officially adopted in the second November 22, 2011 Board meeting. This allows citizens additional time to provide input to the budgetary process. Page 1 1 TOWN OF ESTES PARK Budget highlights: GENERAL COMMENTS • 2012 General Fund balance projected at 30% (Board gave permission to go as low as 25%). • Community Reinvestment Fund transfer reduced from $800,000 to $750,000. $50,000 has been diverted to increasing funding for transportation (101-5600). • 2012 sales tax is forecasted at $7,200,000, a 2.9% increase from the 2011 original budget. • Revenues and Expenditures associated with the LMD have been discontinued. • A 2% one-time bonus has been included in 2011 expenditures, and a 3% raise has been included in 2012 expenditures. • Health insurance for 2012 was forecasted at a 100% increase. Final details are as yet unknown. • Catastrophic Loss (605), Medical (606) Fire Pension (709) and Police Pension (710) Funds have been discontinued. Pages for these Funds appear in the budget for reference. GENERAL FUND • Departmentally: O 1100 (Legislative) -Mayor's Fund has been decreased from $45,000 to $40,000. O 1300 (Executive) - Human Resources was moved from 101-1500 (Finance) to 101-1300 (Executive). A departmental assessment ($20,000) has been included in 2012. $28,000 has been included for filing systems and furniture for the new Town Clerk/HR offices. O 1400 (Elections) — one election has been budgeted for 2012. O 1600 (Com Dev) - $8,000 for hi capacity filing system and office storage cabinets. O 1700 (Buildings) - $32,000 increase for restroom cleaning (extended hours). $50,000 to address support beams in CVB lobby. $30,000 to stain CVB exterior. $7,500 for new water heater in conference center. Page 2 EP TOWN of ESTES PARK O 1900 (Community Grants) — LMD subsidy discontinued. Other grants total ($270,900) level with 2011. The Fire District transfer is now listed here instead of under transfers (101-1900), per the auditors. O 2100 (Police) — Intoxilyzer ($10,000) to be purchased. No longer available from County (?). O 2300 (Prot Inspections) - $5,000 — high capacity filing system, $5,000 for increased training. O 2400 (Engineering) - $45,000 (Virginia/Park Lane/MacGregor rehabs), $20,000 for Developmental Standards update. O 3100 (Streets) - $25,000 for Storm drainage/street consultant, $16,000 for Snow Box for Loader, Annual STIP/Concrete rehab budgeted at $435,000. O 5200 (Parks) - $15,000 for Children's Park renovation. O 5600 (Transportation) - $50,000 increase to reflect expanded services. a 9000 (Transfers) - $70,000 reduction in transfer to Community Services Fund. • COMMUNITY REINVESTMENT FUND • Approximately $1,642,150 of fund balance available as of 12/31/2012. $858,500 additional (4 years) held aside for FOSH. $200,000 held aside for Museum Storage Facility. • From 09/27/2011 Study Session, $600,000 allocated for Stall Barns Phase 111, $40,000 for Police Department Entrance remodel, $50,000 for Barn W re- roofing/roof repair. • $50,000 for signalization for Wiest pedestrian crossing. CONSERVATION TRUST FUND • Maintaining existing bark beetle, noxious weed, and Arbor Day Tree City programs. OPEN SPACE FUND • $225,000 of forecasted $456,000 Bond Park Phase II costs allocated. COMMUNITY SERVICES FUND • LMD revenues and expenditures have been eliminated. • 2012 Fund balance projected at 4% (policy is to not exceed 5°1°). • 5304 (Senior Center) - $20,000 dining room upgrade (SC Inc project). Page 3 TOWN OF ESTES P.AI\ • 5500 (Events) - $17,000 costs associated with increasing Rodeo from "small" to "medium". • 5700 (Museum) - $10,000 NPS building/storage shed repairs (FRIENDS project). L&PIWATER FUNDS • Required ratios (debt service, 90-day O&M) maintained. • L&P: $1,298,000 in capital expenditures forecasted, including: o $688,000 for Camp Allenspark Phase I, $112,000 for conductor system upgrades/tree cable. • Water: $486,000 in capital expenditures forecasted, including: o $318,000 for water system upgrades (Virginia Drive - $272,000). FLEET MAINTENANCE FUND • Mechanic added to address increased needs. IT FUND • Fiber optic lease revenues/expenditures ($27,500) moved from L&P to IT. • $20,000 — year 3 of 5 in AV Board room upgrades scheduled. • $13,500 — Avaya phone system maintenance added. VEHICLE REPLACEMENT FUND • 8 vehicles scheduled for replacement. • Charges to participating departments/funds maintained at 2011 levels. POLICE PENSION FUND • Sole participant passed away in 2011. Fund will be discontinued after 12/31/2011. THEATER (FOSH) FUND • Budgeted expenditure level reduced to $1,000 per Trustee request in 2011 budget sessions. Page 4 2012 BUDGET SESSIONS Week 1 Fleet 612 October 7, 2011 IT 625 Friday - 8:00a Vehicle Replacement 635 Legislative 101-1100 Judicial 101-1200 Executive 101-1300 Elections 101-1400 Finance 101-1500 Community Development 101-1600 Protective Inspections 101-2300 Buildings 101-1700 Employee Benefits 101-1800 Week 2 Grants 101-1900 October 14, 2011 Police Friday - 8:00a Police 101-2100 Dispatch 101-2155 Community Services 101-2175 Engineering 101-2400 Streets 101-3100 Parks 101-5200 Transportation 101-5600 Transfers 101-9000 Community Reinvestment 204 Conservation Trust 211 Open Space 220 Week 3 Community Services October 21, 2011 Visitor Center 222-2600 Friday - 8:00a Facilities/Marketing 222-2800 Local Marketing District 222-2900 Senior Center 222-5304 Special Events 222-5500 Museum 222-5700 Conference Center 222-5800 Light & Power 502 Water 503 Theater 716 Other Employee compensation Funds 605, 606, 709, 710 Week 4 October 28, 2011 Friday - 8:00a Optional REVENUE Taxes Intergovernmental Current Miscellaneous Charges for Services Interest Total Operating Revenues Other sources Transfers -In from other funds Sale of assets Bond/Loan Proceeds TOTAL REVENUES EXPENDITURES Source of Supply Personnel Operating & Maintenance Capital Total Operating Expenditures Debt Service Other uses Transfers/reserves TOTAL EXPENDITURES NET SOURCE (USE) OF FUNDS FUND BALANCES, Beginning (unrestricted) Emergency reserve change FUND BALANCES, End of Year (unrestricted) TOWN OF ESTES PARK Financial Overview - All Funds - 2012 Budget General Fund Special Revenue Funds Community Conservation Open Community Reinvestment Trust Space Services $8,241,212 $ 38,238 12,113 233,093 1,502,721 30,000 10,057,377 1,233,322 11,290,699 5,089,287 3,813,360 487,000 9,389,647 2,125,000 $ 0 0 0 0 15,000 32,000 0 0 0 500 $ 240,000 0 0 0 1,000 $ 2,475 26,500 151,301 592,502 1,500 15,000 32,500 241,000 774,278 750,000 1,375,000 765,000 32,500 241,000 2,149,278 41,716 740,000 36,703 199 225,000 2,235,731 30,000 740,000 41,716 261,902 2,265,731 11,514,647 740,000 (223,948) 25,000 lnte Fleet $ 0 0 0 365,000 1,200 366,200 366,200 307,076 58,847 365,923 41,716 261,902 2,265,731 365,923 (9,216) (20,902) (116,453) 277 3,630,059 2,675,647 14,727 24,088 198,755 291,471 (6,651) 3,399,460 $2,700,647 $5,511 $3,186 $82,302 $291,748 rnal Service Funds Information Vehicle Technology Replacement TOWN OF ESTES PARK Financial Overview - All Funds - 2012 Budget Fiduciary Fund Enterprise Funds Light & % of Theater Power Water Total Total $ $ - $ $ - $ 8,241,212 28.39% 0 0 0 0 0 312,713 1.08% 0 0 0 0 0 38,613 0.13% 27,500 0 0 200,001 92,289 704,184 2.43% 466,899 253,470 0 13,186,105 3,254,323 19,621,020 67.58% 1,000 12,000 600 35,000 17,000 114,800 0.40% 495,399 265,470 600 13,421,106 3,363,612 29,032,542 100.00% 3,358,322 495,399 265,470 600 13,421,106 3,363,612 32,390,864 164,461 164,461 251,070 - - 449,213 1,360,071 9,729,151 216,647 - 1,000 10,984,131 1,157,921 16,303,821 20,000 476,500 - 1,298,000 486,000 3,732,500 487,717 476,500 1,000 12,731,344 3,168,453 29,929,933 0.55% 32.51% 54.47% 12.47% 100.00% - 405,786 405,786 - 1,112,829 120,493 3,358,322 487,717 476,500 1,000 13,844,173 3,694,732 33,694,041 7,682 (211,030) (400) (423,067) (331,120) (1,303,177) 248,675 2,183,066 456,379 6,154,208 2,448,188 18,325,263 $256,357 $1,972,036 $455,979 $5,731,141 $2,117,068 $17,022,086 TOWN OF ESTES PARK Financial Overview - General Fund - 2012 Budget General Community Building Legislative Judicial Executive Elections Finance Development Maintenance 1000 1100 1200 130D 1400 1500 1600 1700 REVENUE Taxes $8,241,212 $ $ $ - $ $ $ $ General (PILOTS, cigrtte, rent, etc) 283,444 Grant related - - - Departmental - 125 300 318,499 24,231 75,250 172,442 Interest 30,000 - - Total Operating Revenues 8,554,656 125 300 318,499 0 24,231 75,250 172,442 - Other sources Transfers -In from other funds 1,233,322 TOTAL REVENUES 9,787,978 125 300 318,499 24,231 75,250 172,442 EXPENDITURES Personnel 0 91,351 43,442 316,601 0 241,959 261,033 38,230 Operating & Maintenance 0 112,448 2,083 280,175 11,400 62,015 74,167 592,072 Capital 0 0 0 0 0 0 0 7,500 Total Operating Expenditures 0 203,799 45,525 596,776 11,400 303,974 335,200 637,802 Other uses Transfer- Community Services Fund 1,375,000 0 0 0 0 0 0 0 Transfer - Community Reinvestment Fund 750,000 0 0 0 0 0 0 0 Transfer - Local Marketing District 0 0 0 0 0 0 0 0 Transfer- Fire Services Fund 0 0 0 D 0 0 0 0 TOTAL EXPENDITURES 2,125,000 203,799 45,525 596,776 11,400 303,974 335,200 637,802 NET SOURCE (USE} OF FUNDS 7,662,978 (203,674) (45,225) (278,277) (11,400) (279,743) (259,950) (465,360) DEPT./FUND BALANCES, Beginning (unrestricted) Emergency reserve change DEPT./FUND BALANCES, End (unrestricted) - $ {203,674) $ (45,225) $ (278,277) $ (11,400) $ (279,743) $ (259,950) $ (465,360) TOWN OF ESTES PARK Financial Overview - General Fund - 2012 Budget Employee Protective %of Benefits Subsidies Police Inspections Engineering Streets Parks Transportation 1800 1900 2100-75 2300 2400 3100 5200 5600 Total Total $ $ $ $ " $ $ - $ $ $8,241,212 - 283,444 43,952 - - 43,952 360,423 145,900 100 358,999 2,500 1,458,769 - 30,000 0 0 404,375 145,900 100 358,999 2,500 0 10,057,377 1,233,322 81.94% 2.82% 0.44 % 14.50% 0.30% 100.00% 404,375 145,900 100 358,999 2,500 11,290,699 O 0 2,679,839 337,728 58,455 426,669 593,979 0 5,089,287 94,775 774,900 437,290 58,416 84,386 619,440 355,022 254,772 3,813,360 O 0 10,000 0 0 451,000 18,500 0 487,000 94,775 774,900 3,127,129 396,144 142,841 1,497,109 967,501 254,772 9,389,647 0 0 0 0 0 0 0 0 1,375,000 O 0 0 0 0 0 0 0 750,000 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 94,775 774,900 3,127,129 396,144 142,841 1,497,109 967,501 254,772 11,514,647 (94,775) (774,900) (2,722,754) (250,244) (142,741) (1,138,110) (965,001) (254,772) (223,948) 3,630,059 (6,651) $ 194,775) $ (774,900) $ {2,722,754) $ (250,244) $ (142,741) $ (1,138,110) $ (965,001) $ (254,772} $ 3,399,460 54.20% 40.61 % 5.19% 100.00% Projected Statement of Revenues, Expenditures, and Fund Balance General Fund Town of Estes Park - 2012 Budget Original Budget Revised Budget Budget 2010 2011 2011 2012 Revenues $9,894,342 $9,841,341 $10,015,184 $10,057,377 Expenditures Personnel Services Salaries 3,369,560 3,537,219 3,451,196 Benefits* 1,251,865 1,517,738 1,638,092 4,532,989 4,882,347 5,054,958 5,089,287 Operations and Maintenance 3,254,147 3,061,547 3,868,188 3,813,360 Total Current Expenses 7,787,136 7,943,894 8,923,146 8,902,647 Capital 940,207 455,800 591,733 487,000 Subtotal 8,727,342 8,399,694 9,514,879 9,389,647 Rollovers 0 229,273 0 0 Total Expenses $8,727,342 $8,628,967 $9,514,879 $9,389,647 Excess (deficiency) of revenues over expenditures 1,167,000 1,212,374 500,305 667,730 Other financing uses (cont/transfers out) (2,425,000) (2,867,485) {2,245,000) (2,125,000) Adj to CAFR (rounding)/proceeds from EPHA -1 0 0 0 Other financing sources (transfers in) L&P/Water 1,123,057 1,139,732 1,155,611 1,233,322 Catastrophic Loss Fund {closure)* 1,277,658 0 0 0 Medical Insurance Fund (closure)* 250,250 0 0 0 Increase {decrease) in fund balance 1,392,964 (515,379) (589,084) {223,948) Beginning (estimated) fund balance 4,522,186 5,915,150 5,915,150 5,326,066 Reserved fund balance: Emergency Reserve 377,000 418,349 418,349 425,000 Prepaid Expenditures 11,970 0 0 Catastrophic Loss 1,277,658 1,277,658 1,277,658 1,277,658 Total reserved fund balances 1,666,628 1,696,007 1,696,007 1,702,658 Unreserved (estimated) fund balance 4,248,522 3,703,764 3,630,059 3,399,460 Total (estimated) fund balance $5,915,150 $5,399,771 $5,326,066 $5,102,118 Unreserved General Fund Balance/ (Total Expenses + Transfers Out) 38% 32% 31% 30% *Transfer to close Medical Fund (4 606) listed as $209,937. Balance of $209,937 + $40,313 ( OPEB liability) is $250,250. *Transfer to close Catastrophic Loss Fund (ft605) listed as $1,437,750. Balance of $1,437,750 - $160,092 (EPHA loan) is $1,277,658. Projected Statement of Revenues, Expenditures, and Fund Balance General Fund Town of Estes Park - 2012 Budget Original Budget Revised Budget Budget 2010 2011 2011 2012 • Benefits Benefits as a % of salaries: FICA/medicare 7.65%; retirement avg 13.0%; insurances —20% (Medical/life/dental/vision/EAP/workers comp) Fund cash flow summary Total monies in $12,545,306 $10,981,073 $11,170,795 $11,290,699 total monies out $11,152,342 $11,496,452 $11,759,879 $11,514,647 net change in cash position $1,392,964 ($515,379) {$589,084) ($223,948) General Fund Revenue Detail Town of Estes Park - 2012 Budget Original Budget Revised Budget Budget 2010 2011 2011 2012 Taxes $7,994,946 $8,015,375 $8,149,659 $8,241,212 Intergovernmental 34,151 35,500 38,238 38,238 {cigarette, mineral) Current 12,126 12,113 12,113 12,113 (rentals) Miscellaneous 216,035 216,472 220,035 233,093 (lieu of taxes) Interest 22,664 55,942 26,000 30,000 Departmental revenues 1,614,419 1,505,939 1,569,139 1,502,721 Subtotal 9,894,342 9,841,341 10,015,184 10,057,377 Proceeds from: EPF4A loan 0 0 0 0 Transfers Light & Power 1,007,750 1,023,467 1,036,294 1,112,829 Water 115,307 116,265 119,317 120,493 Catastrophic Loss 1,277,658 0 0 0 Medical Fund 250,250 0 0 0 Total transfers 2,650,965 1,139,732 1,155,611 1,233,322 Total Revenue $12,545,307 $10,981,073 $11,170,795 $11,290,699 inc/dec over prior year 18% -12% 2% 1% Revenue data]] 2010 2011 0 2011 R 2012 Taxes Property $331,460 $349,308 $349,308 $350,000 Ownership - license plate fees 21,865 25,000 25,000 25,000 Sales - General 7,007,094 7,000,000 7,125,000 7,200,000 Sales - vehicles sold in EP 2,158 2,500 2,500 2,500 Use - vehicles sold outside EP 199,092 165,000 175,000 175,000 Prop tax - late pmnt fees 393 1,300 612 500 Telephone franchise 15,237 22,000 16,000 16,000 Natural gas franchise 102,492 137,500 137,500 237,500 Cable TV franchise 57,147 53,000 55,000 55,000 Electric franchise 199,011 201,743 204,360 217,829 Water franchise 58,997 58,024 59,379 61,883 7,994,946 8,015,375 8,149,659 8,241,212 Departmental Revenues Legislative 180 300 1,370 125 Judicial 270 200 300 300 Executive 314,540 303,624 308,984 318,499 Elections 0 0 0 0 Finance/Administration 42,068 38,453 38,449 24,231 Community Planning 74,529 65,000 72,935 75,250 Buildings 177,294 188,744 206,574 172,442 Benefits 0 6,500 6,500 0 Community Service 39,000 0 0 0 Police 387,366 382,965 398,874 404,375 Protective Inspections 159,003 139,500 146,500 145,900 Engineering 95 100 100 100 Streets 417,714 378,053 386,053 358,999 Parks 2,360 2,500 2,500 2,500 $1,614,419 51,505,939 $1,569,139 $1,502,721 General Fund Expense by Department Town of Estes Park - 2012 Budget 2010 Original Budget 2011 Revised Budget 2011 Budget 2012 Legislative (1100) Judicial (1200) Executive (1300) Elections (1400) Finance (1500) Community Development (16001 Buildings (1700) Employee Benefits (1800) Community Service Grants (1900) Police Patrol (2100) Dispatch (2155) Community Service (2175) Protective Inspections (2300) Engineering (2400) Streets (3100) Parks (5200) Transportation (5600) Subtotal Transfers/Contingencies Community Reinvestment Museum Senior Center CVB/CSF Total Expenditures Rollovers inc/dec over prior year Personnel expenditures Employer benefits Insurance premiums Professional services/fees Publishing Rentals Repairs and maintenance Materials and supplies Job performance expenditures Utilities Other current expenditures Contingency (Mayor's fund) Grants/subsidies Transfers out Capital Subtotal Rollovers Totals $133,771 40,657 415,940 12,144 351,749 379,909 459,871 27,334 802,347 1,829,473 688,410 260,122 347,532 98,763 1,873,606 865,328 140,387 EXPENDITURES BY DEPARTMENT 1.5% 0.5% 4.8% 0.1% 4.0% 4.4% 5.3% 0.3% 9.2% 21.0% 7.9% 3.0% 4.0% 1.1% 21.5% 9.9% 1.6% $195,296 44,049 449,779 6,500 394,785 402,929 490,269 118,218 894,535 1,958,994 746,674 266,743 367,536 83,686 1,454,375 943,039 204,772 2.2% 0.5% 5.0% 0.1% 4.4% 4.5% 5.4% 1.3% 9.9% 21.7% 8.3% 3.0% 4.1% 0.9% 16,1% 10.5% 2.3% $195,630 44,066 481,147 6,500 400,025 434,148 580,703 99,968 898,635 2,000,931 768,282 276,640 401,843 95,408 1,633,996 984,016 212,941 2.1% 0.5% 5.1% 0.1% 4.2% 4.6% 6.1% 1.1% 9.4% 21.0% 8.1% 2.9% 4.2% 1.0% 17.2% 10.3% 2.2% $203,799 2.2% 45,525 0.5% 596,776 6.4% 11,400 0.1% 303,974 3.2% 335,200 3.6% 637,802 6.8% 94,775 1.0% 774,900 8.3% 2,070,778 22.1% 789,132 8.4% 267,219 2.8% 396,144 4.2% 142,841 1.5% 1,497,109 15.9% 967,501 10.3% 254,772 2.7% 8,727,342 100.0% 800,000 7.2% 0 0.0% 0 0.0% 1,625,000 14.6% 9,022,179 100.0% 800,000 7.1% 0 0.0% 0 0.0% 1,445,000 12.8% 9,514,879 100.0% 800,000 0 0 1,445,000 6.8% 0.0% 0.0% 12,3% 9,389,647 100.0% 750,000 8.0% incl in CSF 0.0% inclin CSF 0.0% 1,375,000 14.6% 2,425,000 21.7% 2,245,000 19.9% $11,152,342 100.0% $0 4% $4,532,989 739 76,633 556,669 6,780 29,281 967,089 315,564 159,291 301,661 15,633 22,460 802,347 2,425,000 940,206 $11,267,179 100.0% $229,273 1% EXPENDITURES BY CATEGORY 41% 0% 1% 5% 0% 0% 9% 3% 1% 3% 0% 0% 7% 22% 8% 11,152,342 100.0% 0 0.0% $4,882,347 42% 67,118 1% 79,070 1% 703,022 6% 8,100 0% 35,201 0% 1,020,092 9% 331,020 3% 181,636 2% 314,238 3% 5,000 0% 45,000 0% 894,535 8% 2,245,000 20% 455,800 4% 11,267,179 98.0% 229,273 2% 11,152,342 100.0% 11,496,452 100.0% 2,245,000 19.1% $11,759,879 100.0% 5% $5,054,958 43% 48,513 0% 93,196 1% 729,714 6% 12,244 0% 33,801 0% 1,131,939 10% 377,445 3% 173,139 1% 319,562 3% 5,000 0% 45,000 0% 898,635 8% 2,245,000 19% 591,733 5% 11,759,879 100.0% 0 0% 2,125,000 18.5% $11,514,647 100.0% -2% $5,089,288 44% 45,075 0% 88,817 1% 857,852 7% 10,573 0% 33,879 0% 1,088,124 9% 366,769 3% 185,019 2% 317,351 3% 5,000 0% 40,000 0% 774,900 7% 2,125,000 18% 487,000 4% 11,514,647 100.0% 0 0% 11,759, 879 100.0% 11,514,647 100.0% TOWN BOARD 2012 BUDGET STUDY SESSIONS Friday, Elktober 7, 2011 Meeting #1: 8:00 a.m. to 12:00 p.m. Town Board Room 1 Budget Overview 2. Presentation of the following funds: Internal Service Funds • 612 - Fleet Maintenance (Scott ZiDave M) ■ 625 - Information Systems Technology (Reuben/Mark P) • 635 - Vehicle Replacement (Steve M/Dave M) General Fund (101) • 1100 - Legislative (Jackie W) ■ 1200 - Judicial (Jackie W) • 1300 - Executive (Jackie W) • 1400 - Elections (Jackie W) ■ 1500 - Finance (Steve M) • 1600 - Community Development/Protective Inspections (Alison C) ® 1700 - Buildings (Scott Z) ▪ 1800 - Employee Benefits (Jackie W) Fleet Maintenance Fund Internal Service Fund, #612 Town of Estes Park - 2012 Budget SCOPE OF SERVICES * Services: vehicle/equipment repair/maintenance, aerial/fire inspections, DOT regulations/inspections, equipment specifications and acquisitions, equipment cost tracking, communication equipment fire extinguisher/1st aid kit inspections, licensing, fueling, equipment purchase/maintenance budgets, warranty/recall management, billing re: vehicles, ASE certified mechanics * Records management: w/o tracking, equipment costs, fuel tracking, DOT records, replacement recommendations * Special projects: equip police vehicles, equipment training * Miscellaneous: L&P special cant. weld brackets, build transformer mounts/cable, puller clamps/guide wheels, Stanley Park bleachers/stalls/doors, banner mounts, Water Dept. shut off keys, Parks Dept. sign brackets, bridge repair, trash can repair * Inspections: Preventative Maintenance inspections Budget Revised Budget 2010 2011 2011 Budget 2012 Revenues Charges for services investment income Total Revenues Expenses $256,383 $295,000 $295,253 $365,000 1,412 2,050 1,000 1,200 257,795 297,050 296,253 366,200 Personnel Services Salaries 149,643 154,823 157,533 190,829 Benefits Operations & Maintenance Total Current Expenses 59,962 74,681 75,165 116,246 209,605 229,504 232,698 307,076 40,660 67,007 68,867 58,847 250,265 296,511 301,565 365,923 Capital 0 0 0 0 Depreciation 4,124 0 0 0 Subtotals 254,389 296,511 301,565 365,923 Rollovers Total Expenses increase/decrease from prior year Excess (deficiency) of revenues over expenditures Other financing sources (transfers in) Other financing uses (transfers out) Increase (decrease) in fund balance NET ASSETS - Beginning O 0 0 0 254,389 296,511 301,565 365,923 -23% 17% 2% 23% 3,406 539 (5,312) 277 O 0 0 0 O 0 0 0 3,406 539 (5,312) 277 293,377 296,783 296,783 291,471 NET ASSETS - Ending Invested in Capital Assets 51,527 51,527 51,527 51,527 Funds Available (unrestricted) $245,256 $245,795 $239,944 $240,221 Week 1 - Page 1 Fleet Maintenance Fund Internal Service Fund, #612 Town of Estes Park - 2012 Budget SCOPE OF SERVICES * Services: vehicle/equipment repair/maintenance, aerial/fire inspections, DOT regulations/inspections, equipment specifications and acquisitions, equipment cost tracking, communication equipment, fire extinguisher/1st aid kit inspections, licensing, fueling, equipment purchase/maintenance budgets, warranty/recall management billing re: vehicles, ASE certified mechanics * Records management: w/o tracking, equipment costs, fuel tracking, DOT records, replacement recommendations * Special projects: equip police vehicles, equipment training * Miscellaneous: L&P special cant. weld brackets, build transformer mounts/cable, puller clamps/guide wheels, Stanley Park bleachers/stalls/doors, banner mounts, Water Dept. shut off keys, Parks Dept. sign brackets, bridge repair, trash can repair * inspections: Preventative Maintenance inspections 2010 Budget Revised Budget Budget 2011 2011 2012 Personnel Director of Public Works Public Works Superintendent Lead Mechanic Mechanic Seasonal Mechanic (FTE) 2010 0.10 0.34 1.00 1.00 0.50 2011 0.10 0.34 1.00 1.00 0.50 2011 0.10 0.34 1.00 1.00 0,50 2012 0.10 0.34 1.00 2.00 0.00 Operations and Maintenance expenses include: Insurance premiums 1,715 1,835 2,018 2,220 Professional Services/Fees 7,189 7,182 7,182 7,036 Publishing 0 100 443 100 Repair & Maintenance 9,094 24,600 25,934 18,551 Materials & Supplies 14,069 18,350 18,350 15,650 Job Performance Expenditures 2,414 7,675 7,675 8,025 Utilities 6,119 7,265 7,265 7,265 Depreciation/Clearing 4,186 0 0 0 44,786 67,007 68,867 58,847 Capital includes: 0 0 0 0 Week 1 - Page 2 Account Name Insurance Premiums Professional Services/Fees Publishing 7,101 3,200 Maintenance & repair 10,300 Materials and Supplies 4,580 Town of Estes Park Detail budget information Internal Service Fund #612 Fleet Services, 612-4300-610 2011 2012 Account Rev Budget Budget Number Detail 616 683 21-01 Property 1,219 1,537 21-02 Liability 1,835 2,220 7,182 7,036 22-09 IT Services 7,182 7,036 100 100 23-01 Publication fees 100 100 25-01 Maintenance contracts 1,794 2,245 Telephone 400 400 Motorola 4,456 4,456 H.T.E. (acct software) 25-02 Buildings 3,200 3,200 General maintenance/repair 8,000 0 Vehicle exhaust rpr/replace 1,100 1,100 25-03 Furniture/fixtures maintenance 4,000 5,500 25-04 Vehicle Maintenance and fuel 1,650 1,650 25-05 Machinery/tools 24,600 18,551 2,850 2,850 26-01 Office Supplies 50 50 26-02 Freight/shipping 500 500 26-06 Small tools 400 400 26-13 Medical 550 550 26-17 Catering/special circumstances 1,000 1,000 26-23 Furniture/fixtures acquisition 2,700 0 26-33 Data processing 26-48 Shop equipment 3,500 3,500 Diagnostic software upgrade 2,500 2,500 Alldata - online service manual 2,500 0 Porta-power replacement 1,800 0 Transmission Jack replacement 0 2,500 Chain hoist 0 1,800 Floor jack replacement 18,350 15,650 1,200 1,200 27-01 Personal safety equipment 1,175 1,525 27-02 Uniform allowance 27-04 Education/Training 630 630 Snow & Ice conference 650 650 American Public Works Assoc (Gunnison) 750 750 RM Fleet Mgrs Assoc Conference 1,200 1,200 Sweeper/aerial training Week 1 - Page 3 Town of Estes Park Detail budget information Internal Service Fund #612 Fleet Services, 612-4300-610 2011 2012 Account Account Name Rev Budget Budget Number Detail 1,000 1,000 Equipment diagnostic training 350 350 DOT regulatory training 480 480 27-05 Member Dues/Subscriptions 240 240 27-06 Employee Recognition (3 @ $80) Job Performance Expenses 7,675 8,025 600 600 28-01 Telephone 4,200 4,200 28-02 Natural gas 1,800 1,800 28-03 Electrical energy 200 200 28-04 Water 465 465 28-05 Sewer Utility Expenditures 7,265 7,265 Total Operations & Maintenance Costs 67,007 58,847 0 0 Capital Equipment 0 0 Week 1 - Page 4 Information Systems Technology Fund Internal Service Fund, #625 Town of Estes Park - 2012 Budget SCOPE OF SERVICES * Services: PC support, replacement, installation, management and software maintenance Printer, copier, fax, scanner, multifunction support PDA, cell phone, phone handsets support A/V - boardroom, firehouse, training rooms, museum User training, network plant/equipment facility security, light & power/water SCADA support, A5400 * Records management: software licenses, external connectivity, network security, maintenance contracts, database management Budget Revised Budget 2010 2011 2011 Budget 2012 Revenues Charges for Services Miscellaneous Investment income Expenses 5469,028 $457,795 $457,795 $466,899 $7,585 50 $30,028 $27,500 $1,012 $1,500 $1,000 $1,000 477,625 459,295 488,823 495,399 Personnel Services Salaries 156,130 155,939 158,982 160,047 Benefits 61,438 78,594 79,287 91,024 Operations & Maintenance Total Current Expenses 217,568 234,533 238,269 251,070 151,069 217,383 252,097 216,647 368,637 451,916 490,366 467,717 Capital 0 20,000 20,000 20,000 Depreciation 16,733 0 0 0 Subtotal 385,370 471,916 510,366 487,717 Total Expenses inc/dec over prior year Increase (decrease) in Fund balance NET ASSETS - Beginning 385,370 471,916 510,366 487,717 -24% 22% 32% 92,255 (12,621) (21,543) 177,963 270,218 270,216 -4% 7,682 248,675 NET ASSETS - Ending Invested in Capital Assets 52,681 52,681 52,681 52,681 Funds Available $217,537 $204,916 $195,994 $203,676 Rollovers 0 0 34,400 0 Personnel Services Director of Utilities IT Manager Support Analyst IT Support 0.05 1.00 1.00 0,50 . 0.05 1.00 1.00 0.50 0.05 1.00 1.00 0.50 0.05 1.00 1.00 0.50 Revenues 469,929 459,295 488,823 495,399 Week 1 - Page 5 Information Systems Technology Fund Internal Service Fund, #625 Town of Estes Park - 2012 Budget SCOPE OF SERVICES * Services: PC support, replacement installation, management and software maintenance Printer, copier, fax, scanner, multifunction support PDA, cell phone, phone handsets support A/V - boardroom, firehouse, training rooms, museum User training, network plant/equipment, facility security, light & power/water SCADA support, AS400 * Records management: software licenses, external connectivity, network security, maintenance contracts, database management Budget Revised Budget 2010 2011 2011 Budget 2012 IT Services Phone maintenance fees Fiberoptic lease Interest income Other 399,807 68,822 0 1,300 0 401,047 56,748 0 1,500 0 401,047 56,748 27,448 1,000 2,580 401,047 65,852 27,500 1,000 0 Operations & Maintenance includes: Insurance premiums 1,128 1,207 1,521 1,673 Professional Services/Fees 7 0 0 0 Publishing 585 0 0 0 Repair & Maintenance 81,917 104,789 104,789 122,127 Materials & Supplies 33,785 76,452 110,852 59,452 Job Performance Expenditures 2,152 4,935 4,935 3,395 Utility Expenditures 31,495 30,000 30,000 30,000 151,069 217,383 252,097 216,647 Capital Data processing equipment New (8) HP proliant services (split w/ L&P) 23,900 0 0 0 Other equipment AV Board rm repl (Syr plan, '12 is yr 3 of 5) 0 20,000 20,000 20,000 23,900 20,000 20,000 20,000 Week 1 - Page 6 Town of Estes Park Detail budget information Information Technology Fund 625-2500-425 2011 2012 Account Account Name Budget Budget Number Justification 180 376 21-01 Property 1,027 1,297 21-02 Liability Insurance Premiums 1,207 1,673 120,127 25-01 Maintenance contracts 55,000 55,000 H.T.E. software 1,500 1,500 H.T.E. graphical license 0 3,000 IBM server maintenance 2,500 2,500 IBM support line 300 300 IBM alert options 10,000 10,000 Annual CCTV security mtc {CCTV = closed-circuit TV) 0 13,500 Avaya phone system maintenance 12,000 12,000 Cisco/Websense firewall content 3,000 3,000 McAfee Virus/spyware 2,000 2,000 Net motion (wireless) 3,000 3,000 Quantum tape backup 4,000 4,000 Qualys lnt/Ext security scan 2,000 2,000 Plotter maintenance 1,200 2,000 Blackberry server maintenance 2,400 3,400 Cybernetics virtual tape drive 2,389 2,927 Phone (6) 2,500 1,000 25-04 Vehicle Maintenance 1,000 1,000 25-44 Future Vehicle Purchase Repair and Maintenance 104,789 122,127 1,000 1,000 26-01 Office Supplies 500 500 26-04 Freight/shipping 10,000 26-32 Data processing software 10,000 10,000 H.T.E. Navaline 22,952 26-33 Data processing equipment 5,000 5,000 Networking equipment 25,000 10,000 Network servers 5,000 5,000 Cell extender/subscriber units 2,952 2,952 Blackberry service 14,000 26-35 Data processing 5,000 5,000 Electrical/cooling needs 9,000 9,000 Front Range Internet ISP 1,000 1,000 26-42 Office equipment 10,000 26-46 Communication equipment 7,000 5,000 AV room misc equipment/upgrades 5,000 5,000 Security expansion (door locks, cameras) Materials and Supplies 76,452 59,452 195 195 27-02 Uniform allowance 2,500 0 27-04 Education/training 1,500 2,500 27-05 'Member dues/subscriptions 240 200 27-06 Employee recognition (3 @ $80) 500 500 27-07 Mileage reimbursement Job Performance 4,935 3,395 30,000 30,000 28-01 Telephone Week 1 - Page 7 Town of Estes Park Detail budget information Information Technology Fund 625-2500-425 2011 2012 Account Account Name Budget Budget Number Justification Utility Expenditures 30,000 30,000 Total Operations & Maintenance Costs 217,383 216,647 33-36 Other equipment 20,000 20,000 AV Board room replacement Capital Equipment 20,000 20,000 Week 9 - Page 8 Vehicle Replacement Fund Internal Service Fund, #635 Town of Estes Park - 2012 Budget PURPOSE To fund depreciation of vehicles and accumulate funds for the scheduled replacement of vehicles. Budget Revised Budget 2010 2011 2011 Budget 2012 Revenues Revenues -future vehicle purchases $392,795 $278,526 $278,526 $253,470 Interest/other income 14,047 20,000 12,000 12,000 Total Revenues 406,843 298,525 290,526 265,470 Expenses Personnel Services 0 0 0 0 Operations & Maintenance 2,700 0 0 0 Total Current Expenses 2,700 0 0 0 Capital 243,967 464,000 613,935 476,500 Total Expenses 246,667 464,000 613,935 476,500 Excess (deficiency) of revenues over 160,176 (165,474) (323,409) (211,030) expenditures NETASSETS- Beginning 2,136,536 2,506,475 2,506,475 2,183,066 ADJUSTMENTS TO GAAP BASIS Capital Outlay 243,967 0 0 0 Depreciation (34, 204) 0 0 0 Invested in Capital Assets 279,850 279,850 279,850 279,850 Unrestricted 2,226,625 2,061,151 1,903,216 1,692,186 NET ASSETS - Ending $2,506,475 $2,341,001 $2,183,066 $1,972,036 Rollovers Financing sources 0 0 193,935 0 2010 2011 0 2011 R 2012 General 181,113 88,995 88,995 82,937 Museum 2,220 1,110 1,110 0 Special Events (CVB) 30,900 4,621 4,621 6,283 Light and Power 137,963 140,350 140,350 128,751 Water 39,600 42,450 42,450 35,499 IT 1,000 1,000 1,000 0 392,796 278,526 278,526 253,470 Vehicles scheduled for purchase/replacement Summary of vehicles purchased 101-2100 (Police), G-98B-'00Jeep Cherokee 4x4 18,083 0 0 0 101-3100 (Streets), G-97A-'96 Elgin Pelican 149,012 0 0 0 101-3100 (Streets), G-22A -'93 Ford F350 4x2 34,130 0 0 0 222 (CVB), G-103-'88 Ford 545A Tractor 42,742 0 0 0 Week 1 - Page 9 Vehicle Replacement Fund Internal Service Fund, #635 Town of Estes Park - 2012 Budget PURPOSE To fund depreciation of vehicles and accumulate funds for the scheduled replacement of vehicles. Budget Revised Budget Budget 2010 2011 2011 2012 503 (Water), 9037-'03 GMC 2500HD 4x4 502 (L&P), 93315A-'97 Ford F1504x4 502 (L&P), 93334A-'03 Jeep Liberty 502 (L&P), 93327A - '98 F700 Bucket (4x4) 101-3100 (Streets) G-1008 Ford F-250 4x4 101-3100 {Streets} G-53A'00 Freightliner FL80 4x4 101-3100 {Streets) G-70E'09 John Deere 544J 101-5200 {Parks) G-56A'01 Cushman Truckster 101-5200 (Parks) G-69A'00 Ford F250 4x4 502 (L&P) 93317'99 Jeep Cherokee 4x4 502 (L&P) 933188 '01 Ford F-150 4x4 502 (L&P) 93320D'06 GMC K3500 4x4 222 (Special Events) G-115A'01 J/D Gator 503 (Water} '00 GMC K1500 4x4 503 (Water) 9036'04 Ford F350 4x4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O 40,719 O 21,494 O 13,233 O 118,489 35,000 35,000 185,000 185,000 20,000 20,000 12,000 12,000 33,000 33,000 0 0 0 0 0 0 0 0 0 26,500 26,500 0 25,000 25,000 0 44,000 0 46,000 12,000 12,000 0 27,500 27,500 0 44,000 44,000 0 101-2100 (Police) G-72B,'06 Ford Expedition 4x4 0 0 0 30,000 101-5200 (Parks) G-42, `97 Cushman Truckster 0 0 0 22,000 101-5200 (Parks) G-59A'97 Cushman White Truck 0 0 0 22,000 L&P 93313A'02 Ford Explorer 5-Trac 0 0 0 26,500 L&P 93331A'03 I-H 7400 (Bucket) 4x4 0 0 0 230,000 Special Events G-84A J/0 5200 Tractor 0 0 0 50,000 Water 90310 '02 Ford 350 4x4 0 0 0 50,000 243,967 464,000 613,935 476,500 Week 1 - Page 10 General Fund Legislative, ##101-1100 {Mayor & Town Board) Town of Estes Park - 2012 Budget SCOPE OF SERVICES * Mayor and Board of 6 Town Trustees provide broad policy direction. * Develop strategic plans as necessary * Serve as the quasi judicial body in matters related to the Estes Valley Development Cade and as the local liquor licensing authority * Reappoint advisory committees annually Town Board approves budget annually 2010 Original Budget 2011 Revised Budget 2011 Budget 2012 Personnel Services Salaries Benefits $31,450 48,979 $31,450 $31,450 49,090 59,901 $66,537 $80,429 $80,540 $91,351 Operations & Maintenance 67,234 Total Current Expenses 133,771 Capital 114,867 115,090 112,448 195,296 195,630 203,799 0 0 0 0 Total Expenses $133,771 inc/dec over prior year -16% $195, 296 $195,630 $203,799 46% 46% 4% Rollovers (included above) $0 $0 $0 $0 Revenues 180 300 1,370 125 Personnel Levels Mayor 1.00 1.00 1.00 1.00 Trustees 6.00 6.00 6.00 6.00 Operations & Maintenance insurance premiums 152 163 186 203 Professional services/fees 3,762 8,200 11,200 10,200 Materials and supplies 16,547 24,600 24,800 22,600 Job performance expenditures 19,216 31,704 28,704 34,245 Utilities 1,247 1,200 1,200 1,200 Other current expenditures 3,850 4,000 4,000 4,000 Contingency {Mayor's fund) 22,460 45,000 45,000 40,000 67,234 114,867 115,090 112,448 Week 1- Page 11 Town of Estes Park Detail budget information Legislative 101-1100-411 (Mayor and Board) 2011 2012 Account Account Name Orig Budget Budget Number 2012 Detail 2 1 21-01 Property 161 202 21-02 Liability Insurance Premiums 163 203 3,000 5,000 22-04 Ordinance Revision Fees 5,200 5,200 22-98 Plans/studies as needed Professional Services/Fees 8,200 10,200 1,700 1,500 26-01 Office Supplies 300 500 26-02 Postage 300 300 26-03 Printing/Forms 10,800 10,800 26-17 Volunteer Recognition Luncheon 11,500 9,500 26-17 Catering/Special Circumstances Materials and Supplies 24,600 22,600 22,000 27-04 Education/Training details 11,500 12,500 27-04 5 out of state 6,500 7,500 27-04 5 in state 1,500 2,000 27-04 CIA class 10,495 27-05 Dues/subscriptions details 7,378 7,378 27-05 Colo Municipal League 1,117 1,117 27-05 National League Cities 1,650 1,650 27-05 Colo Assoc of Ski Towns 309 350 27-05 Other dues/sub as needed 1,000 1,000 27-06 Employee Recognition 750 750 27-07 Mileage Reimbursement Job Performance Expenses 31,704 34,245 Utility Expenditures 1,200 1,200 28-01 Telephone Other Current Expenses 4,000 4,000 29-40 Pride Awards Mayor's Contingency 45,000 40,000 60-01 Contingency Fund for Mayor Total Operations & Maintenance Costs 114,867 112,448 Capital Equipment 0 0 Week 1 - Page 12 General Fund Judicial, #101-1200 (Municipal Court) Town of Estes Park - 2012 Budget SCOPE OF SERVICES * Provide fair and impartial application of Town codes to include the model traffic code * Manage and review sentencing of offenders * Assist with certification of municipal election results * Provide for the swearing -in of Town elected officials Original Budget Revised Budget 2010 2011 2011 Budget 2012 Personnel Services Salaries Benefits $33,845 $33,801 $35,496 7,974 7,992 7,946 $39,055 $41,819 Operations & Maintenance 1,602 Total Current Expenses 40,657 Capital 2,230 $41,793 $43,442 2,273 2,083 44,049 44,066 45,525 0 0 0 0 Total Expenses $40,657 $44,049 $44,066 $45,525 inc/dec over prior year 0% 8% 8% 3% Rollovers (included above) $0 Revenues $0 $0 $0 270 200 300 300 Personnel Levels Judge 0.50 0.50 0.50 0.50 Court Clerk 0.50 0.50 0.50 0.50 Assistant Judge contracted contracted contracted contracted 5% salary increase by ordinance in even -numbered years (next ='12) Operations & Maintenance Insurance premiums 197 211 254 279 Professional services/fees 7 250 250 0 Materials and supplies 0 364 364 374 Job performance expenditures 1,399 1,405 1,405 1,430 1,602 2,230 2,273 2,083 Week 1 - Page 13 Town of Estes Park Detail budget information Judicial 101-1200-412 {Municipal Court} 2011 2012 Account Account Name Orig Budget Budget Number 2012 Detail 211 279 21-02 Liability Insurance Premiums 211 279 Prof services/fees -250 0 22-98 Translator fees 167 174 26-01 Office Supplies 128 130 26-02 Postage 69 70 26-17 Printing/Forms Materials and Supplies 364 374 749 750 27-04 Education/Training 576 600 27-05 Member Dues/Subscriptions (Bar Assoc, Clerk/Judge Assoc) 80 80 27-06 Employee recognition (1 @ $80) emp rec contingency for cont. judge Job Performance Expenses 1,405 1,430 Total Operations & Maintenance Costs 2,230 2,083 Capital Equipment 0 0 Week 1 - Page 14 General Fund Executive, l#101-1300 Town of Estes Park - 2012 Budget SCOPE OF SERVICES * Implementation of Town Board goals and strategic plan(s) * Provide operational oversight of Town Departments * Supervise enforcement of laws and ordinances * Maintain official documents and records * Oversight of legal publications * Human resource functions, payroll and risk management * Minutes for Town Board and Committee meetings " Preparation and monitoring of annual budget * Manage business and liquor licensing * Oversight of public information programs and publications " Serve or facilitate as liaison between Town and community groups as needed * Staff support to the Mayor and Town Board of Trustees Original Budget Revised Budget 2010 2011 2011 Budget 2012 Personnel Services Salaries Benefits Operations & Maintenance Total Current Expenses Capital $166,552 $191,171 $227,109 55,367 61,501 89,493 $215,640 $221,919 $252,672 $316,602 200,299 227,860 228,475 280,174 415,940 449,779 481,147 596,776 0 0 0 0 Total Expenses $415,940 $449,779 $481,147 $596,776 Inc/dec over prior year -3% 8% 16% 24% Rollovers {included above) $0 Revenues Personnel Levels so so $0 314,540 303,624 308,984 318,499 Liquor occupation licenses 55,873 51,624 51,624 51,624 General occupation licenses 256,650 250,000 251,355 255,000 Other (Hlt services for LETA, EVFPD): 2,017 2,000 6,005 11,875 Town Administrator Deputy Town Administrator Town Clerk/ Dir. Of Administrative Services Deputy Town Clerk Public Information Officer Secretary ill Human Resource Generalist HR/Payroll Technician Operations & Maintenance 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 - 0.38 0.38 Insurance premiums 1,146 1,226 1,405 1,503 Professional services/fees 135,882 161,349 155,490 164,120 Publishing 3,890 2,500 4,500 4,000 Repair & maintenance 9,332 8,183 9,848 12,316 Materials and supplies 20,069 25,000 30,029 55,000 Job performance expenditures 27,071 27,002 24,604 40,635 Utilities 2,909 2,600 2,600 2,600 200,299 227,860 228,476 280,174 Week 1 - Page 15 Town of Estes Park Detail budget information Executive 101-1300-413 2011 2012 Account Account Name Orig Budget Budget Number 2012 Detail 168 142 21-01 Property 1,058 1,361 21-02 Liability Insurance Premiums 1,226 1,503 750 750 22-07 Recording Fees 90,000 90,000 22-08 Legal 40,699 39,870 22-09 IT Services 3,700 3,500 22-98 Public information as needed 5,500 5,000 22-98 Newsletter 0 20,000 22-98 Departmental assessment 1,700 1,700 22-98 Annual report 7,000 3,300 22-98 Website mgt 12,000 0 22-98 Citizen survey Professional Services/Fees 161,349 164,120 Publication Fees 2,500 4,000 23-01 Publishing 6,583 7,348 25-01 Phone 500 500 25-01 Clerk's index 1,100 4,468 25-01 Copy machine maintenance Maintenance Contracts 8,183 12,316 5,000 6,000 26-01 Office Supplies 7,000 7,000 26-02 Postage (incl. Newsletter - $3,600) 1,500 2,500 26-03 Printing/Forms 100 100 26-04 Freight/Shipping 6,000 4,500 26-17 Catering/Special Circumstances 0 13,000 26-23 FF&E - filing systems 0 15,000 26-23 FF&E - workroom/furniture 5,400 4,900 26-33 Admin Asst desktop, Printer 0 2,000 26-42 Office Equipment - Door lock system Materials and Supplies 25,000 55,000 33,000 27-04 Education/Training 12,500 20,000 27-04 Out of state (8) 7,500 12,000 27-04 In state (8) 1,000 1,000 27-04 misc training 4,325 27-05 Member Dues/Subscriptions 202 202 27-05 Newspapers 90 90 27-05 Colo Muni Clerks Assoc 250 250 27-05 Intl Inst of Muni Clerks 1,000 1,000 27-05 Intl City/Cty Mgrs Assoc 65 65 27-05 Colo City/Cty Mgrs Assoc 215 215 27-05 Colo Assoc of Transit Agencies Week 1 - Page 16 Town of Estes Park Detail budget information Executive 101-1300-413 2011 2012 Account Account Name Orig Budget Budget Number 2012 Detail 275 275 27-05 Rotary - TA 75 75 27-05 Colo Public Info Officers Assoc 80 80 27-05 Nat Info Officers Assoc 0 1,000 27-05 Listserve: PIO & Town Clerk 0 160 27-05 5HRM 0 474 27-05 Personnel CO & FED 0 439 27-05 FBA Updates 375 0 27-05 3 City/Cty Cmnctn/Mkt Assoc. 325 0 27-05 Misc 2,610 27-06 Employee Recognition 720 720 27-06 9 Dept heads 360 640 27-06 8 employees @ $80 1,270 1,250 27-06 125 employees @ $10 700 700 27-07 Mileage Reimbursement Job Performance Expenses 27,002 40,635 Utility Expenditures 2,600 2,600 28-01 Telephone Total Operations & Maintenance Costs 227,860 280,174 Capital Equipment 0 0 Week 1 - Page 17 General Fund Elections, 14101-1400 Town of Estes Park - 2012 Budget SCOPE OF SERVICES Provide administrative oversight of all municipal elections to include regular elections and special elections as called Original Budget Revised Budget 2010 2011 2011 Budget 2012 Personnel Services Operations & Maintenance Total Current Expenses Capital $0 12,144 $0 6,500 so $0 6,500 11,400 2,144 6,500 6,500 11,400 0 0 0 0 Total Expenses $12,144 $6,500 $6,500 $11,400 inc/dec over prior year 0% -46% -46% 75% Rollovers (included above) $0 Revenues Personnel Levels none Operations & Maintenance so so so 0 0 o 0 Professional services/fees 0 600 600 1,200 Publishing 39 100 100 200 Materials and supplies 12,106 5,800 5,800 10,000 12,144 6,500 6,500 11,400 Week 1 - Page 18 Town of Estes Park Detail budget information Elections 101-1400-414 2011 2012 Account Account Name Orig Budget Budget Number 2012 Detail Professional Services/Fees 600 1,200 22-25 Judges Publication Fees 100 200 23-01 Publishing 26-01 Office Supplies 4,100 7,500 26-01 Municipal election(s) 1,500 2,500 26-02 Postage 200 0 26-17 Catering Materials and Supplies 5,800 10,000 Total Operations & Maintenance Costs 6,500 11,400 Capital Equipment 0 0 Week 1 - Page 19 General Fund Finance, #101-1500 Town of Estes Park - 2012 Budget SCOPE OF SERVICES * Act as a front desk" for Town Hall - information/billing requests, phone answering * Generate, process and manage utility billing process s Provide internal/external reports to staff, public, board, other interested parties • Budget and CAFR preparation/presentation k Manage cash flow, accounts payable/receivable functions " Provide services for other governmental entities (EPURA, EVRPD, EVPPD), including Fire Services Original Budget Revised Budget 2010 2011 2011 Budget 2012 Personnel Services Salaries Benefits Operations & Maintenance Total Current Expenses Capital Total Expenses inc/dec over prior year Rollovers (included above) Revenues $222,163 $230,203 $165,823 96,465 97,427 76,136 5278,863 $318,628 $327,630 $241,959 72,886 76,157 72,395 62,015 351,749 394,785 400,025 303,974 0 0 0 0 $351,749 $394,785 $400,025 5303,974 11% 12% 14% -23% $0 $0 so $0 42,068 38,453 38,449 24,231 EVFPD accounting 15,000 7,900 7,896 1,800 EVPLDaccounting 21,144 21,778 21,778 22,431 LETA admin fee 3,066 3,775 3,775 0 LMD admin fee 1,128 5,000 5,000 0 Miscellaneous counter sales/services 1,730 0 0 0 Personnel Levels* Finance Officer Administrative Clerk Accounts Payable/Utility Billing Specialist Accountant I Accounting Manager Human Resources Generalist Payroll/NB Technician 0.55 0.14 0.57 0.55 0.55 0.48 0.60 0.55 0.14 0.57 0.55 0.55 0.48 0.60 0.55 0.14 0.57 0.55 0.55 0.48 0.60 *2011 is final year of 6-yr migration of staff costs from utilities to Finance to more accurately reflect activity/tasks Operations & Maintenance 0.60 0.10 0.60 0.60 0.60 insurance premiums 2,146 1,223 1,524 1,676 Professional services/fees 45,551 47,988 48,250 38,267 Publishing 629 1,250 1,933 1,873 Repair & maintenance 5,112 4,183 4,183 4,326 Materials and supplies 6,202 9,459 9,889 11,258 Job performance expenditures 3,006 10,899 5,461 3,485 Utilities - 1,069 1,155 1,155 1,130 Other current expenditures 9,170 0 0 0 72,886 76,157 72,395 62,015 Week 1 - Page 20 Town of Estes Park Detail budget information Finance 101-1500-415 2011 2012 Account Account Name Orig Budget Budget Number 2012 Detail 6 6 21-01 Property 1,217 1,670 21-02 Liability Insurance Premiums 1,223 1,676 7,453 7,453 22-01 Auditing 250 250 22-08 Legal 28,729 18,762 22-09 IT Services 700 700 22-10 Bank fees 6,300 6,655 22-11 County Treasurer (collection fees for sales tax, etc.) 4,447 22-98 Other 531 457 22-98 Govt Finance Officers Assoc (GFOA) Application fee for award 3,900 3,885 22-98 Courier service 125 105 22-98 Workers comp policy fee Professional Services/Fees 47,988 38,267 Publication Fees 1,250 1,873 23-01 Publishing 4,183 4,326 25-01 Phone System contract Repair & Maintenance 4,183 4,326 2,000 1,499 26-01 Office Supplies 3,244 3,244 26-02 Postage 2,500 2,500 26-03 Printing/Forms (Budgets) 115 115 26-04 Freight/Shipping 1,000 1,000 26-17 Catering/Special Circumstances 500 500 26-23 Office Furniture file cabinets, counter efficiency 100 2,400 26-33 Data processing equipment Materials and Supplies 9,459 11,258 (Asst. Finance Officer) 1,911 27-04 Education/Training 6,000 0 27-04 GFOA/RM Leadership 1,136 1,136 27-04 6 in -state classes 100 775 27-04 GFOA resource material 284 0 27-04 HR class 500 0 27-04 H.T.E. (acct software) conference 844 27-05 Member Dues/Subscriptions 90 590 27-05 GFOA national 150 179 27-05 GFOA state 164 0 27-05 SHRM (Soc HR Mgmt) 480 0 27-05 Cola/Ntl HR issues 450 0 27-05 FMLA Handbook Week 1 - Page 21 Town of Estes Park Detail budget information Finance 101-1500-415 2011 2012 Account Account Name Orig Budget Budget Number 2012 Detail 500 0 27-05 HR Cafe (21 Bus publishing) 75 75 27-05 Notary renewal 720 480 27-06 Employee Rec (6 FTE @ $80) 250 250 27-07 Mileage Reimbursement Job Performance Expenses 10,899 3,485 Utility Expenditures 1,155 1,130 28-01 Telephone Total Operations & Maintenance Costs 76,157 62,015 Capital Equipment 0 0 Week 1 - Page 22 General Fund Community Development, Protective inspection Summary (1600, 2300) Town of Estes Park - 2012 Budget SCOPE OF SERVICES * see 101-1600 and 101-2300 for departmental details Original Budget Revised Budget 2010 2011 2011 Budget 2012 Personnel Services Salaries Benefits $439,143 211,729 $485,505 $385,232 216,373 213,530 $624,175 $650,872 $701,878 $598,761 Operations & Maintenance 103,266 119,593 134,113 132,583 Total Current Expenses 727,441 770,465 835,991 731,344 Capital Total Expenses $727,441 $770,465 $835,991 $731,344 0 0 0 0 inc/dec over prior year -2% 6% 15% -13% Revenues Community Development (1600} 74,529 65,000 72,935 75,250 Protective inspections (2300} 159,003 139,500 146,500 145,900 Total 233,532 204,500 219,435 221,150 Week 1 - Page 23 General Fund Community Development, lt101-1600 Town of Estes Park - 2012 Budget Custome r Service: Estes Valley Development Code: Sign code: Code compliance/enforcement: Web presence/communication: G15: Staff liaison: Records management: SCOPE OF SERVICES Land use consultation (walk-ins and by appointment, Ensure compliance with adopted development code including: review of subdivisions, development, rezoning, and variance applications; administration of improvement guarantees, review of building permit and business license applications; coordination with affected agencies. Review sign code variance applications and Creative Sign program applications Ensure compliance with Estes Valley Development Code through education, cooperation, enforcement and abatement. Maintain and update Community Development Department web pages. Maintain and update zoning map. Assist with Planning Commission, Board of Adjustment, Creative Sign Review Board Maintain land use files. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Personnel Services Salaries Benefits Operations & Maintenance Total Current Expenses Capital Total Expenses inc/dec over prior year Rollovers (included above) $223,819 111,050 $241,652 $164,773 112,685 96,261 $317,489 $334,869 62,420 68,060 $354,336 $261,033 79,812 74,167 379,909 402,929 434,148 335,200 0 0 0 0 $379,909 $402,929 $434,148 $335,200 3% 6% 0 $0 14% -23% $11,093 $0 Revenues (totals) Larimer County IGA planner's salary Application fees Other Personnel Levels Community Development Director Planner Ii Secretary 01 Operations & Maintenance insurance premiums Professional services/fees Publishing Rentals Repair & maintenance Materials and supplies Job performance expenditures Utilities Other current expenditures 74,529 65,000 43,178 29,665 1,686 40,000 24,500 500 72,935 75,250 40,000 40,000 32,185 35,000 750 250 0.75 0.75 0.75 0.75 2.00 2.00 1.00 1.00 0.75 0.75 0.75 0.75 1,480 35,247 450 2,787 4,301 7,507 7,797 853 1,997 62,420 1,584 38,076 300 3,300 6,620 7,600 9,080 1,000 500 68,060 1,809 1,955 37,088 40,706 800 800 2,600 2,640 4,324 5,498 19,601 12,600 11,990 8,640 1,100 828 500 500 79,812 74,167 Week 1 - Page 24 Town of Estes Park Detail budget information Community Development 101-1600-416 2011 2012 Account Account Name Orig Budget Budget Number 2012 Detail 120 97 21-01 Property 1,464 1,858 21-02 Liability Insurance Premiums 1,584 1,955 0 5,000 22-03 G15 consultant services 0 5,000 22-03 Sungard (H.T.E.) data transfer 27,500 20,000 22-08 Legal 9,576 9,381 22-09 IT Services 1,000 1,250 22-35 Applications (Town and County notices) 0 75 22-98 Background checks Professional Services/Fees 38,076 40,706 Publication fees 300 800 23-01 Publication fees Lease 3,300 2,640 24-03 Copy machine lease 2,950 1,000 25-01 Copy charges -planning dept 676 676 25-01 Copy charges - other users 1,794 1,822 25-01 Telephone system 1,200 0 25-01 OCE printer (2011) 0 2,000 25-02 Minor office remodel Maintenance Contracts 6,620 5,498 2,000 1,750 26-01 Office Supplies 1,500 600 26-02 Postage 500 250 26-03 Printing/Forms 2,000 1,800 26-17 Catering/Special circumstances 0 5,000 26-23 Hi capacity filing system 0 3,000 26-23 Office storage cabinet 1,600 200 26-32 Data processing software Materials and Supplies 7,600 12,600 5,645 27-04 Education/Training 0 1,400 27-04 Mtn Town/Resort Planners Summit 1,000 1,200 27-04 Amer Planning Assoc State Conference 2,790 1,145 27-04 Rocky Mtn Land Use conference 0 1,200 27-04 Fred Pryor Seminars 0 500 27-04 Planning Commission training 210 200 27-04 Educational videos/supplies 2,395 27-05 Member Dues/Subscriptions 1,560 2,350 27-05 Amer Planning Assoc (APA) - staff 500 0 27-05 APA - PC 1,300 0 27-05 APA - subscriptions 375 0 27-05 Amer Assoc of Landscape Architects 45 45 27-05 EP Trail Gazette Week 1 - Page 25 Town of Estes Park Detail budget information Community Development 101-1600-416 2011 2012 Account Account Name Orig Budget Budget Number 2012 Detail 20 0 27-05 Other dues/subscriptions as needed 280 200 27-06 Employee Recognition (2.5 @ $80) 1,000 400 27-07 Mileage Reimbursement Job Performance Expenses 9,080 8,640 Utility Expenditures 1,000 828 28-01 Telephone Interest on Deposits 500 500 29-06 Interest on Deposits Total Operations & Maintenance Costs 68,060 74,167 Capital Equipment 0 0 Week 1 - Page 26 General Fund Buildings, #101-1700 Town of Estes Park - 2012 Budget SCOPE OF SERVICES Services include: exterior and interior, HVAC, Utilities and Elevator maintenance cleaning contracts. Records management: maintenance records, as -built, mechanical equipment, warrantie: Original Budget Revised Budget Budget 2010 2011 2011 2012 Personnel Services Salaries Benefits Operations & Maintenance Total Current Expenses 459,871 $25,420 $25,904 $25,613 9,435 10,444 12,616 $35,988 $34,855 $36,348 $38,229 Capital 423,883 455,414 544,355 592,073 0 490,269 0 580,703 630,302 0 7,500 Total Expenses $459,871 inc/dec over prior year -12% $490,269 $580,703 $637,802 7% 26% 10% Rollovers (included above} 0 0 35,300 0 Revenues (totals) 177,294 188,744 206,574 172,442 Building rent (from 1&P, Water) 130,201 130,201 130,201 130,201 Employee housing rent 41,641 42,241 42,241 42,241 LMD rent 0 16,302 16,302 0 Youth Center insurance reimbursement 5,000 0 17,830 0 Other 453 0 0 0 Personnel Levels Director of Public Works Public Works Civil Engineer II Operations & Maintenance Capital 0.14 0.14 0.16 0.16 0.14 0.14 0.16 0.16 Insurance premiums 21,820 24,153 24,153 19,622 Professional services/fees 14,228 0 18,131 30,000 Rentals 12,501 12,501 12,501 12,501 Repair & maintenance 249,273 289,810 359,810 401,000 Materials and supplies 24,879 26,000 26,810 26,000 Job performance expenditures 0 350 350 350 Utilities 101,182 102,600 102,600 102,600 423,883 455,414 544,355 592,073 New water heater - conference cntt 0 0 0 7,500 0 0 0 7,500 Week 1 - Page 27 Town of Estes Park Detail budget information Buildings 101-1700-417 2011 2012 Account Account Name Orig Budget Budget Number 2012 Detail 22,148 19,256 21-01 Property 2,005 366 21-02 Liability Insurance Premiums 24,153 19,622 Professional Services 0 30,000 22-02 Facility assessment Rentals 12,501 12,501 24-02 Real property (rental prop from L&P/H20) 227,000 25-01 Maintenance contracts 67,260 87,260 25-01 Municipal buildings (janitorial) 64,000 76,000 25-01 Public restrooms (janitorial) 3,500 3,500 25-01 Shops 35,000 35,000 25-01 Mechanical 11,000 11,000 25-01 Carpets 2,400 2,400 25-01 Elevator inspections 1,500 1,500 25-01 Copiers 1,060 1,060 25-01 Telephone system 9,280 9,280 25-01 Minor/mist maintenance/janitorial 174,000 94,810 94,000 25-02 Buildings (23) 0 50,000 25-02 Repl/Rep support beams in CVB lobby 0 30,000 25-02 Stain CVB exterior Maintenance Contracts 289,810 401,000 500 500 26-01 Office Supplies 25,000 25,000 26-05 Janitorial supplies 500 500 26-23 Furniture/fixtures Materials and Supplies 26,000 26,000 Education and Training 350 350 24-04 Education and Training 2,500 2,500 28-02 Natural gas 85,000 85,000 28-03 Electrical energy 5,100 5,100 28-04 Water 10,000 10,000 28-05 Sewer Utility Expenditures 102,600 102,600 Total Operations & Maintenance Costs 455,414 592,073 0 7,500 33-31 New water heater- conference center Capital Equipment 0 7,500 Week 1 - Page 28 General Fund Employee Benefits, #101-1800 Town of Estes Park - 2012 Budget PURPOSE This division provides for employee recognition, motivation and events, In 2011, the department will absorb the casts from the #606 (Medical) Fund. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Personnel Services Operations & Maintenance $o $0 $0 $o 27,334 118,218 99,968 94,775 Total Current Expenses 27,334 Capital 118,218 99,968 94,775 0 0 0 0 Total Expenses $27,334 inc/dec over prior year 0% $118,218 332% $99,968 $94,775 -15% -5% Rollovers (included above) 0 0 0 0 Revenues 0 6,500 6,500 (3% fee for administering policies for Estes Valley Library District, Estes Valley Fire Protection District, Estes Park Housing Authority) Personnel Levels none Operations & Maintenance 0 Employer benefits 739 67,118 48,513 45,075 Professional services/fees 0 25,100 30,455 25,200 Materials and supplies 14,876 12,000 12,000 13,000 Job performance expenditures 11,719 14,000 9,000 11,500 27,334 118,218 99,968 94,775 Operations & Maintenance details Post Employment Insurance* 0 0 0 44,075 Wellness Benefit 0 0 0 1,000 (3 current, 3 eligible} Benefit Consultant Fee* 0 0 0 25,000 Actuarial Fee* 0 0 0 200 Catering (2011 = holiday party) 14,876 17,000 12,000 13,000 Employee recognition (longevity) 1,969 2,000 2,000 2,500 Employee Home Ownership 9,750 10,750 12,000 9,000 (Employee Home Ownership 2011: Town contributes $250/participant/month; currently 2 participants - 1 additional participant anticipated. Employee must contribute minimum of $95/pay period) *moved from 11606 (Medical) Fund TOTAL. PREMIUMS (Town portion): 2010 2011 EST Medical 1,050,874 1,234,158 Dental 83,585 86,249 Vision 18,499 17,540 Week 1 - Page 29 Town of Estes Park Detail budget information Employee benefits 101-1800-418 2011 2012 Account Account Name Orig Budget Budget Number 2012 Detail 38,210 16,718 14-60 Post employment insurance (3 current) 27,908 27,357 14-60 Post employment insurance (3 eligible) 1,000 1,000 14-80 Wellness Benefit Employer Benefits 67,118 45,075 25,000 25,000 22-28 Benefit consultant 100 200 22-90 Actuarial study Prof. services/fees 25,100 25,200 12,000 13,000 26-17 Holiday Party Materials and Supplies 12,000 13,000 2,000 2,500 27-06 Employee recognition (longevity) 12,000 9,000 27-11 Employee home ownership Job Performance Expenses 14,000 11,500 (2 current, 1 anticipated) Total Operations & Maintenance Costs 118,218 94,775 Capital Equipment 0 0 Week 1 - Page 30 TOWN BOARD 2012 BUDGET STUDY SESSIONS Friday, Elktober 14, 2011 Meeting #2: 8:00 a.m. to 12:00 p.m. Town Board Room Presentation of the following funds: General Fund • Community Services Grants ■ Police - Patrol - Dispatch - Community Service ■ Public Works - Engineering - Streets - Parks ■ Transportation Transfers Special Revenue Funds • Community Reinvestment • Conservation Trust • Open Space General Fund Community Services, #101-1900 Town of Estes Park - 2012 Budget SCOPE OF SERVICES The Community Services department is the source of Town assistance to various community organizations. Contingent upon funding availability, the Town will provide subsidies to organizations representing a broad spectrum of cultural and human services. The bract( categories include arts and education, transportation, youth programs, various human services, the food tax refund program and continuing support of the Estes Park Library District. Fund appropriation is "'5% of prior year's sales tax collection estimate. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Arts & Education Transportation Housing* Youth Food Tax Refund Human Services Sister City Program subtotal: Subsidy to EVFPD (7% of sales tax) Subsidy to Local Marketing District Total inc/det over prior year (not counting EPHA loan) $2,400 $4,800 $4,800 26,000 26,000 26,000 168,400 136,000 136,000 42,000 39,600 39,600 17,550 17,500 16,350 47,000 39,800 39,800 8,500 8,350 8,350 $311,850 $272,050 $270,900 490,497 493,500 498,750 0 128,985 128,985 $6,600 27,300 128,310 36,000 17,500 46,800 8,390 $270,900 504,000 0 $802,347 $894,535 $898,635 $774,900 -22% -32% -13% -13% Revenues (loan repayment from EVFPD) 39,000 0 0 0 Budget Comments Current funding levels do not guarantee funding in future budgets. Continued funding is contingent upon full and open disclosure of financial information by funded groups/agencies 2010 20110 2011 R 2012 Arts & Education Art Center of EP 800 700 700 500 Chamber Music Society of Estes Park 800 700 700 0 Cultural Arts Council of EP 0 400 400 500 Estes Land Stewardship Association 0 0 0 400 Estes Valley Historical Preservation 0 0 0 1,000 EP Repertoire Theater Company 0 700 700 700 Estes Park Jazz Big Band 0 700 700 900 Estes Park Village Band 0 700 700 900 Life Rythms Music Therapy 0 0 0 1,000 Oratorio Society of Estes Park 800 700 700 700 Stanley Museum 0 200 200 0 2,400 4,800 4,800 6,600 Transportation Special transit 26,000 26,000 26,000 26,000 26,000 26,000 27,300 27,300 Housing Estes Park Housing Authority 161,500 129,500 129,500 123,310 Estes Housing Assistance Program 1,900 1,500 1,500 0 Habitat for Humanity of Estes Valley 5,000 5,000 5,000 5,000 168,400 136,000 136,000 128,310 Week 2 - Page 1 of 30 General Fund Community Services, #101-1900 Town of Estes Park - 2012 Budget SCOPE OF SERVICES The Community Services department is the source of Town assistance to various community organizations. Contingent upon funding availability, the Town will provide subsidie to organizations representing a broad spectrum of cultural and human services. The broac categories include arts and education, transportation, youth programs, various human services, the food tax refund program and continuing support of the Estes Park Library District. Fund appropriation is -5% of prior year's sales tax collection estimate. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Youth BACers (Bobcat Athletics) Circle of Friends Montessori School Estes Park Learning Place Estes Valley Inv in Childhood Success PACK Partners Mentoring of Larimer County Partnership of EP Nonprofit Resource Food Tax Refund 0 5,000 2,000 26,000 4,000 3,800 1,200 42,000 17,550 3,800 0 1,800 25,800 3,800 3,600 800 39,600 17,500 3,800 0 1,800 25,800 3,800 3,600 800 39,600 0 0 2,000 30,000 0 4,000 0 36,000 16,350 17,500 Human Services American Legion Post 119 1,500 0 0 0 Audio Information Network of CO 500 500 500 500 Crossroads Ministry of Estes Park 19,000 18,850 18,850 18,000 Estes Park Gun & Archery Club 3,000 1,600 1,600 1,800 Estes Park Nonprofit Resource Center 0 0 0 2,500 Estes Park 5alud Foundation 19,000 18,850 18,850 19,000 Estes Valley Victim Advocates 4,000 0 0 5,000 47,000 39,800 39,800 46,800 Estes Park Sister Cities Association 8,500 8,350 8,350 8,390 $311,850 $272,050 $270,900 $270,900 Week 2 - Page 2 of 30 General Fund Police, #101-2100, 2155, 2175 (summary) Town of Estes Park - 2012 Budget SCOPE OF SERVICES Summary of 2100, 2155, 2175 Original Budget Revised Budget 2010 2011 2011 Budget 2012 Personnel Services Salaries Benefits $1,766,982 $1,802,766 $1,845,438 767,247 780,576 834,401 $2,304,198 $2,534,229 $2,583,342 $2,679,839 Operations & Maintenance 468,539 435,882 457,437 437,290 Total Current Expenses 2,772,737 2,970,111 3,040,779 3,117,129 Capital 5,268 2,300 5,074 10,000 Rollovers 0 0 0 0 Total Expenses 2,778,005 2,972,411 3,045,853 3,127,129 inc/dec over prior year 1% 7% 10% 3% Revenues Police (2100) $109,561 $104,325 $123,226 $125,735 Communications (2155) 194,185 202,328 198,001 202,328 Com Svcs {2175) 83,620 76,312 77,647 76,312 $387,366 $382,965 $398,874 $404,375 Week 2- Page 3of30 General Fund Police (Patrol), #101-2100 Town of Estes Park » 2012 Budget Patrol: investigations: Administration: SCOPE OF SERVICES 24-hour patrol services, criminal and accident investigations, traffic and DUI enforcement, Zone policing, neighborhood watch, vocation checks, crime prevention, traffic studies, special events, parking enforcement front window assistance, Segway and bike programs, community educational classes, accident investigation for Town -owned vehicles, Court liaison, Emergency Response Team, Emergency Management Systems. Felony crimes, internal affairs, drugs, juvenile and property crimes, missing persons, crimes against persons, liquor license inspections, evidence storage and management, lost and found property storage. Community presentations, employee development and recruitment strategies, strategic planning policy development, mutual aid agreements, budget preparation, maintenance of professional standards, LETA Board member, Victims Services board member, Estes Valley Community Services representative. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Personnel Services Salaries Benefits Operations & Maintenance Total Current Expenses Capital Total Expenses inc/dec over prior year Rollovers (included above) $1,132,818 $1,153,901 $1,179,611 485,389 496,257 546,831 $1,474,321 $1,618,207 $1,650,158 $1,726,442 349,884 338,487 350,773 334,336 1,824,205 1,956,694 2,000,931 2,060,778 5,268 2,300 10,000 ,829,473 1,958,994 2,000,931 2,070,778 1% 1% 9% 3% 0 0 0 0 Revenues (totals) 109,561 104,325 123,226 125,735 Licenses/permits 1,752 2,000 2,000 2,000 Federal grants 4,893 3,535 8,876 2,550 State grants 11,353 14,438 14,438 14,438 Charges for services 1,170 1,000 1,000 1,000 Court fines 44,463 40,600 48,900 51,700 Sales of fixed assets (police equipment) 8,000 0 0 0 Intoxilyzer restitution 0 0 0 10,095 Other event coverage, charities, (Chiefs golf tourney") 37,931 42,752 48,012 43,952 *The Chief's Golf Tournament is a pass -through event where revenues and expenses offset to a net $0 Personnel Levels Police Chief 1.00 1.00 1.00 1.00 Secretary I€i 1.00 1.00 1.00 1.00 Police Commander 1.00 1.00 1.00 1.00 Patrol Sergeant 2.00 2.00 2.00 2.00 Investigator(s) 2.00 2.00 2.00 2.00 Patrol Officers 10.00 10.00 10.00 10.00 Community Services Officer (3) 0.00 0.00 0.00 1.00 (moved from 101-2175) Operations & Maintenance Week 2 - Page 4 of 30 General Fund Police (Patrol), #101-2100 Town of Estes Park - 2012 Budget Patrol: Investigations: Administration: SCOPE OF SERVICES 24-hour patrol services, criminal and accident investigations, traffic and DU/ enforcement, Zone policing, neighborhood watch, vacation checks, crime prevention, traffic studies, special events, parking enforcement, front window assistance, Segwoy and bike programs, community educational classes, accident investigation for Town -owned vehicles, Court liaison, Emergency Response Team, Emergency Management Systems. Felony crimes, internal affairs, drugs, juvenile and property crimes, missing persons, crimes against persons, liquor license inspections, evidence storage and management, lost and found property storage. Community presentations, employee development and recruitment strategies, strategic planning, policy development, mutual aid agreements, budget preparation, maintenance of professional standards, LETA Board member, Victims Services board member, Estes Volley Community Services representative. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Capital Insurance premiums Professional services/fees Publishing Repair & maintenance Materials and supplies Job performance expenditures Utilities Other current expenses 28,880 90,858 0 132,932 56,540 37,656 2,403 616 30,978 109,192 500 99,457 62,570 32,390 2,900 500 34,162 97,992 500 112,624 70,194 31,901 2,900 500 37,578 105,384 500 109,449 53,800 24,225 2,900 500 349,884 338,487 350,773 334,336 Equipment for vehicles 5,268 2,300 0 0 Speed radar sign replacement 0 0 0 0 Lightbars for Ford Expedition {2} 0 0 0 0 Intoxilyzer 0 0 0 10,000 *Police vehicle G-42 ('06 Ford Expedition 4x4) to be replaced through Vehicle Replacement Fund in 2012 ($30,000 Week 2 - Page 5 of 30 Town of Estes Park Detail budget information Patrol 101-2100-421 2011 2012 Account Account Name Orig Budget Budget Number 2012 Detail 1,764 2,059 21-01 Property 29,214 35,519 21-02 Liability Insurance Premiums 30,978 37,578 7,200 7,200 22-05 Veterinary/boarding 500 500 22-06 Medical (shots/physicals/evals) 3,000 3,000 22-08 Legal 71,822 68,014 22-09 IT Services 16,000 1,000 1,000 22-14 Lab testing 15,000 15,000 22-14 MOU - hospital 10,670 22-98 Other 7,920 7,920 22-98 Victim advocate service 2,300 2,300 22-98 HUB service/fees (Center for Juvenile Services) 450 450 22-98 Job fairs Professional Fees/services 109,192 105,384 Publishing S00 500 23-01 Publications fees 28,353 25-01 Maintenance contracts 10,000 10,000 25-01 Tiburon agreement - Larimer Co 5,500 5,500 25-01 Wireless citation 3,400 3,400 25-01 Copier 7,292 8,713 25-01 Phone (16) 390 390 25-01 AED authority (Automatic External Defibrillator) 350 350 25-01 Radar certification (6) 0 3,500 25-02 Admin Hallway glass door 59,480 25-04 Vehicle Equipment 39,500 39,500 25-04 Fuel costs 19,400 19,980 25-04 Maintenance/Repair/Upkeep 13,625 17,516 25-44 Future vehicle purchases 0 600 25-98 Equipment repairs Maintenance & repair 99,457 109,449 6,900 6,900 26-01 Office Supplies 1,000 1,000 26-02 Postage 3,500 3,000 26-03 Printing/forms 250 250 26-04 Freight/shipping 100 100 26-06 Small tools 100 100 26-07 Small hardware 10,050 26-11 Police Equipment & Supply 2,300 2,300 26-11 Ammunition - Patrol 1,000 1,000 26-11 Ammunition - SEU/ERT (Special Enforcement Unit/Emergency Response Team) 980 1,200 26-11 Evidence collection supplies 1,000 0 26-11 Digital camera for investigations Week 2- Page 6of30 Town of Estes Park Detail budget information Patrol 101-2100-421 2011 2012 Account Account Name Orig Budget Budget Number 2012 Detail 50 100 26-11 Marking paint 50 0 26-11 Police barrier tape 1,900 1,750 26-11 Taser (2) replacements 300 400 26-11 Taser batteries 600 800 26-11 Taser cartridges 200 150 26-11 Digital camera for car 300 500 26-11 Batteries 1,750 0 26-11 Replace radar speed gun 190 200 26-11 CO Peace Officers handbook 100 100 26-11 Transport belt 0 250 26-11 PFD vehicle 525 600 26-11 Portable Breather Tester supplies 800 0 26-11 APS Replacement hand held (2) (Advanced Public Safety) 400 400 26-11 Thermal Paper for Wireless Citations 50 0 26-11 Chalk 50 0 26-11 Parking permit supplies 100 100 26-11 Dog tags 375 200 26-11 Pepper spray 500 0 26-11 Arrest control equipment 300 300 26-13 Medical 17,700 26-17 Catering/special circumstances 11,700 12,200 26-17 Chief's golf tourney 3,000 3,000 26-17 Special Meetings 2,500 2,500 26-17 Safety Fair 14,400 26-33 Data processing equipment 500 0 26-33 ICOP (in car camera) Hard drives (4) 19,200 14,400 26-33 Toughbook replacements (7) - patrol Materials and Supplies 62,570 53,800 3,100 27-01 Personal Safety Equipment 4,220 3,100 27-01 Bullet resistant vests (4) 8,760 27-02 Uniform Allowance 7,200 7,200 27-02 16 uniforms 400 400 27-02 Investigations allowance (2) 1,000 1,000 27-02 Community Service Officers uniforms 160 160 27-02 Taser holsters (4) 8,400 27-04 Education/training 350 600 27-04 Colo Assoc of Chiefs of Police conference 4,000 0 27-04 Tuition reimbursement 6,500 4,000 27-04 Fitness memberships 450 300 27-04 Admin assistant training 2,000 1,500 27-04 Basic police services 2,000 2,000 27-04 Supervisor/Management training 1,865 27-05 Member dues/subscriptions 240 120 27-05 Int Assoc of Police Chiefs 120 240 27-05 Colo Assoc of Chiefs of Police 500 500 27-05 Firearms range fee Week 2 - Page 7 of 30 Town of Estes Park Detail budget information Patrol 101-2100-421 2011 2012 Account Account Name Orig Budget Budget Number 2012 Detail 40 45 27-05 Estes Park Trail Gazette 175 175 27-05 National Tactical Officers Association 150 0 27-05 Rocky Mountain Information Network 130 130 27-05 Ragan communications 35 35 27-05 Notary 270 270 27-05 Thompson employment law 200 200 27-05 Quinlan legal updates 125 125 27-05 Public Employment Report 25 25 27-05 Nat Citizens Police Academy Assoc 1,600 1,600 27-06 Employee recognition (17 @$80), annual awards ($240) 500 500 27-07 Mileage reimbursement Job Performance 32,390 24,225 28-01 Telephone service 2,400 2,400 28-01 Blackberry 500 500 28-01 cell phones (3) Utility Expenditures 2,900 2,900 500 500 29-25 Recruitment & promotion Other Current Expenses 500 500 Total Operations & Maintenance Costs 338,487 334,336 0 10,000 33-98 Intoxilyzer 2,300 0 34-41 Lightbars for Ford Expedition (2) Capital Equipment 2,300 10,000 Week 2 - Page 8 of 30 General Fund Police (Dispatch}, #101-2155 Town of Estes Park - 2012 Budget Dispatch: SCOPE OF SERVICES Maintain 24/7 communications for EPFD, GHFD, RMNP, EP Municipal, £MD Ambulance Service, CSP, LCSO (limited basis). Crime data entry, CBI monthly reports, maintain all records, department reporting requirements, front desk customer services. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Personnel Services Salaries Benefits Operations & Maintenance Total Current Expenses 688,410 $473,311 192,526 $484,929 $494,283 194,874 212,524 $591,808 $665,837 $679,803 $706,807 96,602 80,837 83,405 82,325 Capital 796,674 763,208 789,132 0 0 5,074 0 Total Expenses $688,410 incldec over prior year -3% $746,674 $768,282 $789,132 8% 12% -3% Rollovers (included above} 0 0 5,074 0 Revenues 194,185 202,328 198,001 202,328 Larimer Emergency Telephone Authority (LETA) 20,738 21,000 16,673 21,000 LETA director salary and benefits 121,647 129,528 129,528 129,528 Fire dispatch 16,800 16,800 16,800 16,800 Hospital dispatch 35,000 35,000 35,000 35,000 Personnel Levels Administrative Sergeant 1,00 1.00 1.00 1.00 Dispatchers 6.00 7.00 6.00 6.00 LETA Executive Director (paid by LETA 1.00 1.00 1.00 1.00 Records Technician 1.00 1.00 1.00 1.00 Code Compliance Officer 1.00 0.00 0.00 0.00 Operations & Maintenance Capital Insurance premiums 3,535 3,783 4,398 4,838 Professional services/fees 33,073 32,623 32,623 29,644 Publishing 250 150 159 0 Repair & maintenance 16,543 21,561 21,561 25,413 Materials and supplies 23,848 0 1,186 0 Job performance expenditures 10,036 10,720 11,478 10,430 Utilities 9,318 12,000 12,000 12,000 96,602 80,837 83,405 82,325 0 0 5,074 0 Week 2 - Page 9 of 30 Town of Estes Park Detail budget information Dispatch 101-2155-421 2011 2012 Account Account Name Orig Budget Budget Number 2012 Details 531 671 21-01 Property 3,252 4,167 21-02 Liability Insurance Premiums 3,783 4,838 31,123 28,144 22-09 IT Services 1,500 1,500 22-98 Digital archiving Professional Fees/Services 32,623 29,644 Publication fees 150 0 Publication fees 25-01 Maintenance contracts 2,629 2,593 25-01 Dispatch phone 9,282 10,320 25-01 Wireless advanced 850 850 25-01 Heron communication site (LETA) 700 900 25-01 Coplink 900 1,200 25-01 Care maintenance program 6,800 6,800 25-01 NCRCN Maintenance agreement (Northern Colo Radio Comm Network) 400 400 25-01 Pagers 0 1,350 25-01 Biddle Critical] Maint (LETA) 0 1,000 25-01 Smartboard maintenance (LETA) Maintenance and repair 21,561 25,413 26-33 Data processing equipment Materials and Supplies 0 0 7,900 27-04 Education/training 1,200 0 27-04 Records clerk conference 3,600 3,600 27-04 Nat Emergency Number Assoc (LETA) 1,800 1,800 27-04 Assoc of Public Safety Communication Officials (LETA) 1,800 1,800 27-04 Navigator (LETA) 100 100 27-04 CPR (LETA) 200 200 27-04 Emergency Medical Dispatching (EMD) re-cert training (LETA) 400 400 27-04 EMD - QA certifications (LETA) 415 140 27-05 Member dues/subscriptions 0 1,185 27-05 Member dues/subscriptions (LETA) 1,205 1,205 27-06 Employee recognition (10 x $80, AMD, LETA) Job Performance 10,720 10,430 12,000 12,000 28-01 Utilities - telephone Utility Expenditures 12,000 12,000 Total Operations & Maintenance Costs 80,837 82,325 Capital Equipment 0 0 Week 2 - Page 10 of 30 Town of Estes Park Detail budget information Dispatch 101-2155-421 Account Name 2011 2012 Account Drig Budget Budget Number 2012 Details Week 2 - Page 11 of 30 General Fund Police (Community Services), #101-2175 Town of Estes Park - 2012 Budget SCOPE OF SERVICES Community and volunteer services, auxiliary unit, chaplain services, front desk volunteer program, records volunteer program, Community Restorative Justice, Restorative Justice State Council Board member, Lorimer County Community Corrections board member, adult Services: crimes, parole reintroduction program, juvenile status offenders, grant -writing, management of 20 auxiliary volunteers, management of 50 Restorative Justice volunteers. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Personnel Services Salaries Benefits Operations & Maintenance Total Current Expenses Capital $160,853 89,332 $163,936 $171,544 89,445 75,046 $238,070 $250,185 22,052 16,558 $253,381 $246,590 23,259 20,629 260,122 266,743 276,640 267,219 0 0 0 0 Total Expenses $260,122 inc/deck over prior year 15% $266,743 $276,640 $267,219 3% 69% -3% Rollovers (included above) 0 0 1,000 0 Revenues 83,620 76,312 77,647 76,312 Federal Grants 68,820 55,230 55,230 55,230 Operating Grants 14,305 21,082 21,826 21,082 Other 495 0 591 0 Personnel Levels Manager 1.00 1.00 School Resource Officer 1.00 1.00 Restorative Justice Coordinator 1.00 1.00 (pending grant funding) Seasonal Community Service Officers (FTEs) 1.33 1.33 (moved to 101-2100 in 2011) Operations & Maintenance 1.00 1.00 1.00 1.00 1.00 1.00 1.33 0.00 Insurance premiums 1,115 1,193 1,555 1,712 Professional services/fees 2,814 6,000 6,000 6,000 Publishing 330 0 0 0 Materials and supplies 6,069 1,782 4,338 1,782 Job performance expenditures 10,801 6,363 10,166 9,935 Utilities 923 1,200 1,200 1,200 22,052 16,558 23,259 20,629 Week 2 - Page 12 of 30 Town of Estes Park Detail budget information Police (Community Services) 101-2175-421 2011 2012 Account Name Orig Budget Budget Account Number 2012 Details 16 23 21-01 Property 1,177 1,689 21-02 Liability Insurance Premiums 1,193 1,712 Other 500 500 22-98 OMNI Services - grant restor 950 950 22-98 OMNI data collection grant restor 4,550 4,550 22-98 Larimer Center for MH grant restor Professional Fees 6,000 6,000 1,000 1,000 26-03 Brochures (offset by grant) 282 26-11 Police equipment & supply 200 200 26-11 Fingerprint gloves 82 82 26-11 maysi-2 manual - resor offset by grant 500 500 26-17 SRO Supplies Materials and Supplies 1,782 1,782 1,500 1,500 27-02 Auxiliary uniforms 7,610 27-04 Education/training 500 500 27-04 Drug/alcohol prevention materials 800 1,000 27-04 CPA Academy 500 500 • 27-04 Auxiliary training 500 1,250 27-04 SRO training (NASRO) 750 0 27-04 RJ training (case manager/volunteers) 650 0 27-04 CS manager training jug (conf) 360 360 27-04 SRO physical fitness membership 0 4,000 27-04 Tuition reimbursement 175 175 27-05 Member dues/subscriptions 648 650 27-06 Employee recognition (3 @ $80) annual recognitions/awards ($410) Job Performance 6,383 9,935 1,200 1,200 28-01 Telephone Utility Expenditures 1,200 1,200 Total Operations & Maintenance Costs 16,558 20,629 Week 2 - Page 13 of 30 Genera' Fund Engineering, #101-2400 Town of Estes Park - 2012 Budget SCOPE OF SERVICES * Services: Project engineering/management, contract administration, right of way management, development review, public information, drainage, pavement management phone system * Records management: certificate of liability insurance, request for proposals, press releases, sale maps and publications, complaint database 2010 Original Budget Revised Budget 2011 2011 Budget 2012 Personnel Services Salaries Benefits Operations & Maintenance Total Current Expenses Capital $38,468 13,108 $39,199 $37,964 16,016 20,490 $57,508 $51,576 $55,215 $58,454 41,255 32,110 40,193 84,387 98,763 0 83,686 0 95,408 142,84 0 0 Total Expenses 598,763 inc/dec over prior year 17% $83,686 $95,408 $142,841 -15% •3% 50% Rollovers (included above) 0 0 2,790 0 Revenues Revenues 95 100 100 100 {Sales of Maps/Publications) Personnel Levels Director of Public Works 0.04 0.04 0.04 0.04 Public Works Civil Engineer 0.48 0.48 0.48 0.48 Operations & Maintenance Insurance premiums 274 293 326 354 Professional services/fees 30,310 24,576 30,458 75,881 Publishing 389 100 1,492 500 Repair & maintenance 1,799 1,461 1,461 1,822 Materials and supplies 3,379 1,330 1,698 1,330 Job performance expenditures 5,103 4,350 4,758 4,500 41,255 32,110 40,193 84,387 Week 2 - Page 14 of 30 Town of Estes Park Detail budget information Engineering 101-2400-424 2011 2012 Account Account Name Orig Budget Budget Number 2012 Details 35 34 21-01 Property 258 320 21-02 Liability Insurance Premiums 293 354 10,000 0 22-02 Grant match for CDOTfrom 2010 0 45,000 22-02 Virginia/Park Ln/MacGregor St. Rehab 5,000 1,500 22-08 Legal 9,576 9,381 22-09 IT Services 0 20,000 22-98 Development standards update Professional Fees/Services 24,576 75,881 Publication fees 100 500 23-01 Publication fees 1,461 1,822 25-01 Phone (4) Repair and Maintenance 1,461 1,822 1,000 1,000 26-01 Office Supplies 130 130 26-17 Catering/special circumstances 200 200 26-23 Furniture/fixtures Materials and Supplies 1,330 1,330 3,000 27-04 Education/training 1,500 1,500 27-04 International Building Code - Colo Chptr 1,000 1,000 27-04 Flood plain and urban drainage 500 500 27-04 Traffic control/engineering ref manuals 0 150 27-04 Amer Soc of Civil Engineers 1,000 1,000 27-05 Dues- Inst of Transportation Engineers 250 250 27-05 Dues - other 100 100 27-07 Mileage reimbursement Job Performance 4,350 4,500 Total Operations & Maintenance Costs 32,110 84,387 Capital Equipment 0 0 Week 2 - Page 15 of 30 General Fund Streets, #101-3100 Tows of Estes Park - 2012 Budget SCOPE OF SERVICES • Services: snow removal, street sweeping, street signs, parking lot maintenance and striping, patching(pot holes), crack sealing, drainage, special projects, right of ways, seasonal trash. * Records management: work order tracking, time card tracking, invoices • inspections: potholes, crack sealing, signs, trash, sweeping, drainage, curbs • Assists other departments: museum (picnic grounds), senior center (parking lot/drainage), parks, library (booksale), police (parking/signs/barricades), special events, fire (barricades, sanding cleanup), water (sanding), specialties (culverts, signs, curbs/drainage) Original Budget Revised Budget 2010 2011 2011 Budget 2012 Personnel Services Salaries Benefits Operations & Maintenance Total Current Expenses Capital Total Expenses inc/dec over prior year Rollovers (included above) $282,466 107,242 $296,283 $292,752 113,275 133,918 $393,572 $389,708 $409,558 $426,670 551,855 614,667 645,462 619,439 945,427 1,004,375 928,179 450,000 ,055,020 1,046,109 578,976 451,000 $1,873,606 $1,454,375 $1,633,996 $1,497,109 87% -22% 13% -8% 0 0 146,264 0 Revenues 417,714 378,053 386,053 358,999 Licenses and permits 4,400 4,500 4,500 0 HUTF (Highway Users Trust Fund) 260,325 273,820 273,820 270,999 Motor Vehicle registrations 26,743 28,500 28,500 28,000 Road & Bridge 58,040 50,000 58,000 60,000 Other {recycling rebates, work orders) 68,206 21,233 21,233 0 Personnel Levels Director of Public Works Public Works Superintendent Municipal Service Worker Municipal Service Foreman Public Works Civil Engineer Secretary II Seasonal Maintenance (FTEs) Operations & Maintenance Capital 0.38 0.25 2.00 1.00 0.16 0.70 1.80 0.38 0.25 2.00 1.00 0.16 0.70 1.80 0.38 0.25 2.00 1.00 0.16 0.70 1.80 0.38 0.25 2.00 1.00 0.16 1.00 1.80 Insurance premiums 7,871 6,610 15,347 10,213 Professional services/fees 2,515 13,794 17,304 44,345 Publishing 538 1,700 1,760 1,700 Rentals 4,704 9,000 9,000 9,000 Repair & maintenance 374,480 389,642 401,220 357,160 Materials and supplies 19,150 31,075 36,786 34,175 Job performance expenditures 8,546 14,313 14,313 14,313 Utilities 134,051 148,533 149,732 148,533 551,855 614,667 645,462 619,439 Pothole patcher Asphalt roller 34,097 20,500 0 0 O 0 O 0 Week 2 - Page 16 of 30 General Fund Streets, #101-3100 Town of Estes Park- 2012 Budget SCOPE OF SERVICES • Services: snow removal, street sweeping, street signs, parking lot maintenance and striping, patching(pot holes), crack sealing, drainage, special projects, right of ways, seasonal trash. • Records management: work order tracking, time card tracking, invoices • inspections: potholes, crack sealing, signs, trash, sweeping, drainage, curbs • Assists other departments: museum (picnic grounds), senior center (parking lot/drainage), parks, library (hook sale), police (parking/signs/barricades), special events, fire (barricades, sanding cleanup), water (sanding), specialties (culverts, signs, curbs/drainage) Original Budget Revised Budget 2010 2011 2011 Budget 2012 Grapple for Loader Snow box with hydraulics for Loader Streets Annual STIP (Street Improvement Program) over/ay Prospect Avenue project Fall River Retaining Wall Parking lot/concrete rehab 0 0 0 0 22,526 0 0 16,000 25,000 400,000 402,686 400,000 755,877 0 70,481 0 32,896 0 0 0 59,808 50,000 83,283 35,000 928,179 450,000 578,976 451,000 Week 2 - Page 17 of 30 Town of Estes Park Detail budget information Streets 101-3100-431 2011 2012 Account Account Name Orig Budget Budget Number 2012 Detail 1,914 5,987 21-01 Property 4,696 4,226 21-02 Liability Insurance Premiums 6,610 10,213 6,000 6,000 22-02 Engineering 400 6,000 22-08 Legal (re: 22-98) 2,394 2,345 22-09 IT Services 5,000 5,000 22-26 Insurance damage claims 0 25,000 22-98 Storm drainage/Streets consultant Professional Fees/Services 13,794 44,345 Publishing 1,700 1,700 23-01 Publications fees Rentals 9,000 9,000 24-01 30-day material screen project (annual) 56,460 25-01 Maintenance contracts 1,059 1,235 25-01 Phone (2} 375 375 25-01 Heron Trust (Radio site) 1,400 1,400 25-01 Motorola (radio mtc) 900 900 25-01 OCE printer 850 850 25-01 Copier 1,200 1,200 25-01 Seasonal trash can cleaning 25,000 25,000 25-01 Parking lot Striping 25,000 25,000 25-01 Roadway striping 500 500 25-01 Other 2,400 2,400 25-02 Building maintenance 128,000 130,000 25-04 Vehicle Maintenance and Fuel 350 350 25-05 Machinery/tools 90,000 25-20 Streets 47,500 49,000 25-20 Materials for maintenance/repair 10,000 10,000 25-20 Curb/gutter 6,000 6,000 25-20 Sidewalks 2,000 2,000 25-20 Guardrails 15,000 15,000 25-20 Salt/sand 8,000 8,000 25-20 Snow plow blades 40,000 15,000 25-24 Storm drainage (culvert repair/cleaning) 11,700 25-25 Traffic signs 5,200 5,200 25-25 Delineators/reflectors/materials 10,000 5,000 25-25 Replacement - MUTCD (1 of 6 yrs) (Manual Uniform Traffic Control Devices) 1,500 1,500 25-25 Stencils (replace worn out) 57,408 51,250 25-44 Future vehicle replacement Repair and Maintenance 389,642 357,160 2,700 2,700 26-01 Office Supplies 75 75 26-03 Printing/forms 50 50 26-04 Freight/shipping 5,250 6,250 26-06 Base small tools 1,600 1,600 26-07 Small hardware 3,600 3,600 26-08 Lumber/paint 650 650 26-13 CDOT physicals 1,000 1,000 26-17 Catering/special circumstances 5,000 5,000 26-21 Bridges (foot per CIRSA) Week 2 - Page 18 of 30 Town of Estes Park Detail budget information Streets 101-3100-431 2011 2012 Account Account Name Orig Budget Budget Number 2012 Detail 4,750 4,750 26-23 School/signals materials (1,750), trash cans (3,000) 2,700 0 26-33 Data processing equipment 3,200 8,000 26-46 Radio upgrade per 2013 FCC req (2012) 500 500 26-48 Shop equipment Materials and Supplies 31,075 34,175 400 400 27-01 Personal Safety Equipment 1,650 1,650 27-02 Uniform Allowance 10,250 27-04 Education/training 1,050 1,050 27-04 Snow & Ice 900 900 27-04 American Public Works Assoc (APWA) 1,800 1,800 27-04 Co Asphalt 3,500 3,500 27-04 APWA out of state 1,200 1,200 27-04 APWA - Grand Junction 1,800 1,800 27-04 CIRSA flagging/winter driving 1,513 27-05 Member dues/subscriptions 650 650 27-05 Micro -paver 200 200 27-05 APWA 200 200 27-05 Co Asphalt Paving Assoc 50 50 27-05 Co Assoc of Road Mtc 105 105 27-05 COL renewals 48 48 27-05 Better Roads magazine 260 260 27-05 Additional as needed 400 400 27-06 Employee recognition (5 @ $80) 100 100 27-07 Mileage reimbursement Job Performance 14,313 14,313 3,750 3,750 28-01 Telephone 7,000 7,000 28-02 Natural Gas 2,900 2,900 28-03 Electrical 400 400 28-04 Water 900 900 28-05 Sewer 62,500 62,500 28-06 Trash disposal 71,083 71,083 28-09 Street light electricity charge Utility Expenditures 148,533 148,533 Total Operations & Maintenance Costs 614,667 619,439 0 16,000 34-98 Snow Box with hydraulics for Loader 400,000 400,000 35-51 Annual Street Improvement Program (STIP) 50,000 35,000 35-51 Concrete rehab/Parking lot Capital Equipment 450,000 451,000 Week 2 - Page 19 of 30 General Fund Parks, #101-5200 Town of Estes Park - 2012 Budget SCOPE OF SERVICES * Services: flower planting, irrigation, grounds maintenance and landscaping, benches/tables/trash cons parks/bridges/picnic grounds, walkways/river walk/sidewalks/trails, playground inspectiar and maintenance, Christmas tree drop, snow removal, tree boars * Contract management: sidewalk cleaning, Bureau of Reclamation Grounds mtc, weed control, sculpture maintenance and cleaning, annual backflow maintenance/testing, tree trimmint * Records management: work order tracking, time card tracking, invoices * Miscellaneous: police (graffiti/wasp nest removal), library (book transport/sale), special event (tent/parade assistance), , Senior Center, picnic grounds clean/maintenance, Town Mall roof maintenancr Original Budget Revised Budget 2010 2011 2011 Budget 2012 Persannel5ervices Salaries Benefits Operations & Maintenance Total Current Expenses Capital Total Expenses inc/dec over prior year Rollovers (included above) $395,586 162,726 $400,937 $404,320 165,045 189,660 517,453 558,312 565,982 593,980 341,116 381,227 410,351 355,021 858,569 939,539 976,333 949,001 6,759 3,500 7,683 18,500 $865,328 $943,039 $984,016 $967,501 5% 9% 14% 3% 0 0 25,220 0 Revenues 2,360 6,025 2,500 2,500 Personnel Levels Director of Public Works 0.24 Public Works Superintendent 0.41 Municipal Service Foreman 1.00 Municipal Service Workers 4.00 Seasonal Park Personnel(FTEs)* 7.04 Work study student 0.05 0.24 0.41 1.00 4.00 7.04 0.05 0.24 0.41 1.00 4.00 7.04 0.00 *seasonal employee numbers are calculated by taking total budgeted seasonal wages and dividing by FTE units. It does nol necessarily reflect the number of actual seasonal workers hired. 0.24 0.41 1.00 4.00 7.04 0.00 Operations & Maintenance Insurance premiums 6,096 5,598 5,961 6,557 Professional services/fees 12,634 19,432 19,883 14,286 Publishing 264 1,000 1,000 1,000 Rentals 6,605 7,100 7,100 7,100 Repair & maintenance 165,211 188,237 206,558 165,318 Materials and supplies 93,145 108,550 114,791 106,050 Job performance expenditures 10,288 11,010 11,358 11,010 Utilities 46,873 40,300 43,700 43,700 341,116 381,227 410,351 355,021 Capital Childress Park renovation 0 0 0 15,000 Bobcat exchanges 1,351 3,500 3,500 3,500 Peacock Park renovation 5,408 0 4,183 0 6,759 3,500 7,683 18,500 * Parks vehicle G-42 ('97 Cushman Truckster) to be replaced through Vehicle Replacement Fund in 2012 ($22,000) Week 2 - Page 20 of 30 Town of Estes Park Detail budget information Parks 101-5200-452 2011 2012 Account Account Name Orig Budget Budget Number 2012 Detail 1,728 2,013 21-01 Property 3,870 4,544 21-02 Liability Insurance Premiums 5,598 6,557 7,182 7,036 22-09 IT Services 10,000 5,000 22-98 Dead tree removal 1,500 1,500 22-98 Bark Beetle Mgmt 750 750 22-98 Speaker fees - tree symposium Professional Fees/Services 19,432 14,286 Publishing 1,000 1,000 23-01 Publications fees 3,600 3,600 24-01 Bobcat rental {bark beetle mgt) 3,500 3,500 24-02 Storage building rental {from L&P) Rentals 7,100 7,100 45,647 25-01 Maintenance contracts 1,925 2,397 25-01 Phone 16,000 16,000 25-01 Sidewalk cleaning 600 600 25-01 Motorola 5,000 5,000 25-01 Sculpture maintenance 4,500 4,500 25-01 Tree Trimming 7,500 7,500 25-01 Annual Backflow maintenance 2,150 2,150 25-01 Brick planter repair 7,500 7,500 25-01 Irrigation maintenance 6,500 6,500 25-02 Shop/greenhouse 51,500 25-03 Furniture/fixtures 500 500 25-03 Normal repair/fountains 7,500 7,500 25-03 Confluence Park inlet 4,000 4,000 25-03 Tables 2,000 2,000 25-03 Tree Grates 7,000 7,000 25-03 Benches 16,250 10,000 25-03 Trail Repair 2,500 2,500 25-03 Seasonal trash cans 10,000 0 25-03 River bank repair 10,000 10,000 25-03 Paver repair 10,000 8,000 25-03 Riverwalk repair 50,000 47,500 25-04 Vehicle maintenance/upkeep/fuel 16,812 14,171 25-44 Future vehicle replacement Repair and Maintenance 188,237 165,318 1,200 1,200 26-01 Office Supplies 7,750 7,750 26-06 Small tools 1,800 1,800 26-07 Small hardware 2,000 2,000 26-08 Lumber/paint 500 500 26-09 Chemical 27,000 19,500 26-10 Lawn (irrigation/turf mat/sup/upgrade ssi) 750 750 26-13 Medical (CDL physicals) 2,050 2,050 26-17 Catering/special circumstances 6,000 26-22 Walkways 6,000 6,000 26-22 Paving repair/materials Week 2 - Page 22 of 30 Town of Estes Park Detail budget information Parks 101-5200-452 2011 2012 Account Account Name Orig Budget Budget Number 2012 Detail 2,000 2,000 26-23 Equipment/fixtures 4,000 4,000 26-27 Aggregate 8,000 8,000 26-30 Mulch 42,500 26-36 Maintenance, trees, plants 40,000 40,000 26-36 Flowers, flower -related supplies 2,500 2,500 26-36 CVB plantings 0 5,000 26-46 Radio upgrade (2013 FCC req) 3,000 26-48 Shop equipment 1,20D 0 26-48 Drill press 0 1,200 26-48 Hand grinder 600 600 26-48 Grinder 600 600 26-48 Planter repair 600 600 26-48 Work bench Materials and Supplies 108,559 106,050 1,000 1,000 27-01 Personal Safety Equipment 2,250 2,250 27-02 Uniform Allowance 6,850 27-04 Education/training 1,250 1,250 27-04 Backflow prevention certification 1,200 1,200 27-04 Turf conference (3) 2,750 2,750 27-04 Pro green expo (5) 150 150 27-04 Pesticide conference 1,500 1,500 27-04 Horticulture 510 510 27-05 Member dues/subscriptions 400 400 27-06 Employee recognition (5 @ $80) Job Performance 11,010 11,010 600 600 28-01 Telephone 3,100 3,100 28-02 Natural Gas 9,200 9,200 28-03 Electrical 25,500 25,500 28-04 Water 200 200 28-05 Sewer 1,700 5,100 28-06 Trash disposal Utility Expenditures 40,300 43,700 Total Operations & Maintenance Costs 381,227 355,021 34-98 Other machinery/equipment 1,100 1,100 34-98 Annual 5100 bobcat exchange 2,400 2,400 34-98 Annual 5360 bobcat exchange 0 15,000 35-61 Children's Park renovation Capital Equipment 3,500 18,500 Week 2 - Page 23 of 30 General Fund Transportation (#101.5600) Town of Estes Park - 2012 Budget SCOPE OF SERVICES Seasonal shuttle service for 3 routes. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Expenses Personnel Services Operations & Maintenance Total Current Expenses Capital $0 so $o so 140,387 204,772 212,941 259,772 140,387 204,772 212,941 259,772 o a o 0 Total Expenses $140,387 $204,772 $212,941 $259,772 inc/dec over prior year -16% 46% 52% 22% Rollovers (included above) 0 0 0 0 Personnel levels none Operations & Maintenance Professional services/fees Materials and supplies Operations & Maintenance details 136,769 198,872 207,000 253,872 3,618 5,900 5,941 5,900 140,387 204,772 212,941 259,772 Shuttle contract 136,769 Shuttle services provided for Scotfest, Christmas Parade, and other miscellaneous requests Office supplies 1,763 Traffic signs 1,855 Capital none 198,872 2,100 3,800 198,872 253,872 2,116 2,100 3,800 3,800 Week 2 - Page 24 of 30 General Fund Transfers from General Fund, #101-9000 Town of Estes Park 2012 Budget PURPOSE to provide for contingency in the general budget and transfers between the General and other Funds Original Budget Revised Budget 2010 2011 2011 Budget 2012 Personnel Services Operations & Maintenance Total Current Expenses Capital Total Expenses so so so so 0 0 0 0 0 0 0 0 Transfers out/to: Community Reinv. Fund Museum Fund Senior Center Fund CVB/Com Services Fund Fire services Fund* Local Marketing District* 800,000 800,000 0 0 0 0 1,625,000 1,445,000 0 0 0 0 800,000 0 0 1,445,000 0 0 750,000 incl in CSF incl in CSF 1,375,000 0 0 Total: inc/dec over prior year 2,425,000 2,245,000 2,245,000 2,125,000 -26% -7% -7% -5% *moved to 101-1900 Week 2 - Page 25 of 30 Community Reinvestment Fund Special Revenue Fund, #204 Town of Estes Park - 2012 Budget Purpose: * The Community Reinvestment Fund provides funds for General Fund, Special Revenue Fund and Internal Service Fund capital projects. Funding comes from the General Fund and TABOR excesses (per voter approval in 2000) when applicable. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Total Revenues Expenses Personnel Services Operations & Maintenance Total Current Expenses $26,420 $1,445,000 $1,435,075 $15,000 0 0 55,171 0 28,600 0 119,205 0 28,600 0 174,376 Capital 204,190 1,508,000 1,928,501 740,000 Total Expenses 232,790 1,508,000 2,102,877 740,000 Rollovers 0 0 94,327 0 Excess (deficiency} of revenues over expenditures (206,370) (63,000) (667,802) (725,000) Other financing sources (transfers in - General Fund) Transfer from Catastrophic Loss Fund 800,000 800,000 800,000 750,000 0 0 0 0 800,000 800,000 800,000 750,000 Increase (decrease) in fund balance 593,630 737,000 132,198 25,000 Transfer out to EPURA for Grandstands project (799,222) 0 0 0 Beginning Fund balance 2,745,041 2,543,449 2,543,449 2,675,647 Ending Fund balance* $2,543,449 $3,280,449 $2,675,647 $2,700,647 *2012 = $858,500 {4 yrs) of Fund Balance is reserved for Society of Performing Arts site prep, parking and drainage *2012 = $200,000 of Fund Balance is reserved for Museum Storage Facility Revenues Interest income 19,226 23,000 13,000 15,000 Other 7,194 0 75 0 Transportation Hub Grant - CDOT 0 956,000 956,000 0 (Colorado Department of Transportation) Grant Match for CDOT Transportation Enhancement 0 256,000 256,000 0 Grant Match for NEPA study 0 210,000 210,000 0 26,420 1,445,000 1,435,075 15,000 Personnel Seasonal Engineer (% reimbursable through Grant) 0 0 2.48 0 Operations & Maintenance Engineering, prof fees, etc. 0 0 94,327 0 (rollovers: transit hub, mpec engineering, mpec Week 2 - Page 26 of 30 Community Reinvestment Fund Special Revenue Fund,14204 Town of Estes Park - 2012 Budget Purpose: * The Community Reinvestment Fund provides funds for General Fund, Special Revenue Fund and Internal Service Fund capital projects. Funding comes from the General Fund and TABOR excesses (per voter approval in 2000) when applicable. Original Budget Revised Budget 2010 2011 2011 Budget 2012 proforma} Legal RTA - Elkhorn Lodge Project application fee 0 0 0 0 0 0 1,500 23,378 119,205 0 0 0 Capital Fairgrounds - grandstands w/ EPURA 59,607 0 0 0 Stanley Park Master Project 144,583 0 0 0 Transportation HUB Grant 0 956,000 956,000 0 Grant Match for CDOTTransportation Enhancement 0 302,000 302,000 0 (grant = $256k + match $46k1 Grant Match for NEPA Study 0 250,000 250,000 0 (grant = $200 Fed/$10k NPS + match $40k) Bond Park ($500,000 in Open Space Fund. Balance 0 0 420,501 0 in Community Reinvestment Fund) Stall Barns Phase III 0 0 0 600,000 Police Dept Entrance Remodel 0 0 0 40,000 Barn W - Re -roofing 0 0 0 50,000 Signalization - Wiest Pedestrian Crossing 0 0 0 50,000 204,190 1,508,000 1,928, 501 740,000 Week 2 - Page 27 of 30 Conservation Trust Fund Special Revenue Fund, #211 Town of Estes Park - 2012 Budget Scope of services: To collect and distribute the proceeds of State lottery revenues for the purpose of acquiring, constructing and maintaining parks and facilities. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Revenues Intergovernmental Investment income Other Total Revenues Expenses $27,715 $30,000 $30,000 $32,000 519 800 400 500 347 0 0 0 28,581 30,800 30,400 32,500 Personnel Services 0 0 0 0 Operations & Maintenance 0 40,000 73,716 41,716 Total Current Expenses Capital Total Expenses 40,000 73,716 41,716 36,092 13,110 6,000 0 36,092 53,110 79,716 41,716 % change from prior year -61% -42% 121% -48% Rollovers 0 0 28,000 0 Increase (decrease) in Fund balance (7,511) (22,310) (49,316) (9,216) Beginning Fund balance 71,554 64,043 64,043 14,727 Rollover adjustment Ending Fund balance $64,043 $41,733 $14,727 $5,511 Operations & Maintenance Bark Beetle Mgmt 780 20,000 20,000 15,000 Weed Control ( plus rollovers) 15,000 20,000 42,000 15,000 Tree replacement - Arbor day (moved to O&M) 0 0 11,716 11,716 (pop revision to 5,858) Park Improvements 11,262 0 0 0 27,042 40,000 73,716 41,716 Capital Arbor Day/tree replacement 9,050 13,110 0 0 (Est. population 6,555 x $2.00, to be used for Tree City designation) Bird sanctuary fencing (rollover) 0 0 6,000 0 9,050 13,110 6,000 0 Week 2 - Page 28 of 30 Larimer County Open Space Fund Special Revenue Fund, #220 Town of Estes Park- 2012 Budget PURPOSE in 1996, Lorimer County voters approved a one -quarter of one percent soles tax increase to be used for trails and open space purchases through 2018. This fund accounts for the Town's portion of the tax. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Revenues Intergovernmental Grant Other Investment income Total Revenues Expenses Personnel Services Salaries Benefits $244,599 $200,000 $240,000 $240,000 O 0 12 0 O 0 17 0 2,876 4,000 1,000 1,000 $247,475 $204,000 $241,029 $241,000 39,316 9,940 24,779 24,345 11,194 12,358 40,354 49,256 35,973 36,703 Operations & Maintenance 1,254 161 181 199 Total Current Expenses 41,608 49,417 36,154 36,902 Capital 75,559 500,000 694,077 225,000 Total Expenses 117,167 549,417 730,231 261,902 Rollovers 0 0 44,077 0 Excess (deficiency) of revenues over expenditures Other financing sources (transfers in) Other financing uses (transfers out)* 130,308 (345,417) (489,202} (20,902) O 0 0 0 50,000 0 0 0 Increase (decrease) in fund balance 80,308 (345,417) (489,202) (20,902) Beginning Fund balance 432,983 513,291 513,291 24,088 Rollover adjustment Ending Fund balance $513,291 $167,874 $24,088 $3,186 * joint grant with Estes Valley Park and Recreation District Personnel services Director of Public Works Public Works Civil Engineer II Seasonal engineer (moved to CRF #204) 0.10 0.20 0.00 0.10 0.20 0.25 0.10 0.20 0.00 0.10 0.20 0.00 Operations & Maintenance Storm drainage 0 0 0 0 Walkways/bikeways 1,105 0 0 0 Insurance - liability 150 161 181 199 Week 2 - Page 29 of 30 Larimer County Open Space Fund Special Revenue Fund, 4220 Town of Estes Park - 2012 Budget PURPOSE In 1996, Larimer County voters approved a one -quarter of one percent sales tax increase to be used for trails and open space purchases through 2018. This fund accounts for the Town's portion of the tax. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Capital Walkways and Bikeways Bond Park Phase I (rollover included) Fall River Trail Bond Park Phase 11 (partial) Total 24,500 51,059 0 75,559 500,000 0 0 500,000 694,077 0 0 0 0 225,000 694,077 225,000 Week 2 - Page 30 of 30 TO N BOARD 2012 BUDGET STUDY SESSIONS Friday, Elktober 21, 2011 Meeting #3: 8:00 a.m. to 12:00 p.m. Town Board Room I . Presentation of the following funds: Special Revenue Funds ■ Community Services - Visitor Center Facilities/Marketing Local Marketing District - Senior Center Special Events Museum Conference Center Enterprise Funds ® Utilities - Light and Power - Water Fiduciary Funds ® Police Pension ■ Theater Other ® Employment Compensation COMMUNITY SERVICES FUND Special Revenue Fund, #222 SUMMARY Town of Estes Park - 2012 Budget SCOPE OF SERVICES * In 2010, the CVB Fund (#222) absorbed the Museum (#207) and Senior Center (#217) Funds. The Museum and Senior Center Funds become divisions within Fund #222, the name changing from "CVB" to "Community Services" Fund. With the creation of the Local Marketing District (LMD), the Advertising (#222-2000) and Visitors Guide (#222-2700) divisions were discontinued. The LMD division (#222-2900) was added to reflect the agreement between the Town and LMD regarding Town assistance with LMD payroll. This arrangement will be discontinued in 2012. Original Budget Revised Budget Budget 2010 2011 2011 2012 REVENUES BY DEPARTMENT Interest income $1,362 $2,500 $1,300 $1,500 Visitor Center (2600) 292,423 39,200 41,500 42,100 Facilities Sales & Marketing (2800) 3,180 5,000 1,000 3,000 LMD (2900) 75,824 574,801 574,801 0 Senior Center (5304) 54,977 77,427 77,727 81,177 Events (5500) 600,001 570,400 583,967 601,451 Museum (5700) 27,502 34,750 34,570 21,050 Conference Center (5800) 24,000 24,000 24,114 24,000 Total Revenues 1,079,269 1,328,078 1,338,979 774,278 Expenditures Personnel Salaries Benefits 1,039,861 1,171,764 1,190,712 774,261 386,993 471,693 482,254 324,606 1,42 6,854 1,643,457 1,672,965 1,098, 867 Operations & Maintenance 1,093,804 1,139,308 1,151,710 1,136,864 Total Current Expenses 2,520,658 2,782,765 2,824,676 2,235,731 Capital 50,582 29,500 29,500 30,000 Subtotal 2,571,240 2,812,265 2,854,176 2,265,731 Rollovers 0 0 0 0 Total Expenditures 2,571,240 2,812,265 2,854,176 2,265,731 inc/dec over prior year -12% 9% 1% -21% Excess (deficiency) of revenues over (1,491,971) (1,484,187) (1,515,197) (1,491,453) expenditures Other financing sources (transfers in - General) 1,625,000 1,445,000 1,445,000 1,375,000 Other financing uses (transfers out) 0 0 0 0 Increase (decrease) in fund balance 133,029 (39,187) (70,197) (116,453) Beginning Fund balance 175,105 308,139 268,952 198,755 CAFR adjustment 5 Ending Fund balance $308,139 $268,952 $198,755 $82,302 Fund balance % 12% 10% 7% 4% COMMUNITY SERVICES FUND Special Revenue Fund, #222-2600 Visitor Center Town of Estes Park - 2012 Budget SCOPE OF SERVICES Assist walk-in visitors and callers seeking information about Estes Park and Rocky Mountain National Pail In cooperation with the Local Marketing District, promote Estes Park area events and activities Create and distribute informational materials Coordinate approximately 75 volunteer Ambassadors. Handle limited retail sales of Estes Park - related merchandise. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Revenues Charges for services Investment income Miscellaneous Total Revenues Expenditures Personnel Salaries Benefits $287,180 $37,500 $37,500 $37,500 0 0 0 0 5,243 1,700 4,000 4,600 292,423 39,200 41,500 42,100 158,835 150,297 155,371 155,354 47,709 57,315 58,615 63,996 206,544 207,612 213,986 219,350 Operations & Maintenance 136,753 139,945 140,122 136,766 Capital 0 0 0 0 Total Expenditures $343,297 $347,557 $354,108 $356,116 inc/dec over prior year -36% 1% 3% 1% Personnel 2010 2011 2011 2011 Visitor Center Manager Visitor Information Specialist {2 PT, 1 FT) Community Services Director Seasonal Phone Operators 1.00 3.00 0.20 2.10 1.00 2.00 0.20 2.10 1,00 2.00 0.20 2.10 1.00 2.00 0.20 2.10 Operations & Maintenance Insurance premiums 2,066 2,211 2,211 2,076 Professional fees/services 28,806 24,796 22,996 22,258 Publishing 850 1,099 1,100 1,175 Rentals 3,657 4,999 3,800 4,200 Repair & maintenance 35,673 35,173 38,298 38,124 Materials & supplies 14,440 19,274 19,874 16,250 Job performance expenses 1,511 1,491 941 781 Utilities 26,010 24,602 24,602 25,205 Other current expenditures 23,740 26,300 26,300 26,687 Total Expenditures 136,753 139,945 140,122 136,756 Capital 0 0 0 0 Week 3 - Page 1 of 48 Town of Estes Park Detail budget information Visitor Center (222-2600-426-) Account Name Insurance Premiums Professional Fees/Services Publishing Rentals Repair & Maintenance Materials and Supplies Job Performance 2011 2012 Account Orig Budget Budget Number Justification 211 187 21-01 Property 2,000 1,889 21-02 Liability 2,211 2,076 250 250 22-08 Legal 21,546 21,108 22-09 IT 2,400 500 22-10 Bank service 500 300 22-41 Website Upgrades 100 100 22-98 Background checks 24,796 22,258 1,099 1,175 23-01 Publication fees (resort map, emp ads) 1,099 1,175 4,999 4,200 24-01 Copier lease 4,999 4,200 30,438 33,999 25-01 Maintenance contracts (janitorial, window washing, elevator, mats, phone, hvac) 4,635 4,000 25-02 Buildings, Furniture, Fixtures & Equipment (FF&E) 100 125 25-98 Other equip/machinery 35,173 38,124 3,202 2,650 26-01 Office Supplies 500 400 26-02 Postage 0 200 26-03 Printing forms 400 500 26-05 Janitorial supplies 500 700 26-15 Exhibit/display (flags, lobby) 972 1,000 26-17 Catering/special circumstances 300 650 26-23 FF&E 5,000 4,000 26-29 Promotional mat printing (counter materials/annual report) 8,100 5,800 26-33 Data processing equipment 300 350 26-46 Communication equipment 19,274 16,250 500 350 27-04 Education/training 610 50 27-05 Member dues/subscriptions 256 256 27-06 Employee recognition (3.2 x $80) 125 125 27-07 Mileage reimbursement 1,491 781 5,888 5,890 28-01 Telephone 2,888 2,900 28-02 Natural Gas 9,196 9,729 28-03 Electrical 2,482 2,621 28-04 Water 1,208 1,200 28-05 Sewer 840 850 28-06 Trash disposal Week 3 - Page 2 of 48 Town of Estes Park Detail budget information Visitor Center (222-2600-426-) 2011 2012 Account Account Name Orig Budget Budget Number Justification 2,100 2,015 28-15 Telephone lines Utility Expenditures 24,602 25,205 22,000 21,000 29-20 Resale purchases 4,300 5,687 29-24 Ambassadors club Other Current Expenses 26,300 26,687 Total Operations & Maintenance Costs 139,945 136,756 0 0 Capital Equipment 0 0 Week 3 - Page 3 of 48 COMMUNITY SERVICES FUND Special Revenue Fund, #222-2800 Facilities Sales & Marketing Town of Estes Park - 2012 Budget SCOPE OF SERVICES Develop and implement comprehensive marketing program for Conference Center and Fairground. Promote, recruit, book and facilitate Town -wide groups into the Conference Center and otherfacilitie. Coordinate with local marketing officials to promote meeting propertie: Book, facilitate and support local events and fundraisers at the Conference Cente Original Budget Revised Budget 2010 2011 2011 Budget 2012 Revenues Miscellaneous (room night fees) Total Revenues Expenditures Personnel Salaries Benefits $3,180 $5,000 $1,000 $3,000 3,180 5,000 1,000 3,000 91,708 89,592 91,374 92,151 26,440 33,599 34,027 37,830 118,148 123,191 125,400 129,981 Operations & Maintenance 21,947 23,618 23,824 18,911 Capital 0 0 0 0 Total Expenditures $140,095 $146,809 $149,224 $148,892 inc/dec over prior year 1% 5% 7% 0% Personnel Group Sales and Marketing Manager 1.00 1.00 1.00 1.00 Community Services Director 0.10 0.10 0.10 0.10 Seasonal 0.00 0.00 0.00 0.00 Operations & Maintenance Insurance premiums 454 486 667 728 Professional fees/services 3,394 2,394 2,394 2,345 Publishing 7,549 8,150 8,175 7,750 Materials & supplies 1,225 1,500 1,500 750 Job performance expenses 3,316 4,588 4,588 2,838 Utilities 1,475 1,500 1,500 1,500 Other current expenditures 4,534 5,000 5,000 3,000 Total Expenditures 21,947 23,618 23,824 18,911 Capital 0 0 0 0 none Week 3 - Page 4 of 48 Town of Estes Park Detail budget information Facilities Sales & Marketing (222-2800-428-) 2011 2012 Account Account Name Orig Budget Budget Number Justification 15 12 21-01 Property 471 716 21-02 Liability Insurance Premiums 486 728 IT Services 2,394 2,345 22-09 8,000 7,500 23-01 Publication fees 150 250 23-03 Advertising production Publishing 8,150 7,750 500 500 26-01 Office Supplies 500 250 26-02 Postage 500 0 26-03 Printing/forms (Conf Ctr photos) Materials and Supplies 1,500 750 750 27-04 Education/training 1,500 750 27-04 Conf Ctr, State Tourism conferences (CSAE) 1,500 27-05 Member dues/subscriptions 2,000 1,500 27-05 Colo Society of Assoc Executives International Assoc of Assembly Mgrs Prof Convention Mgrs Assoc 88 88 27-06 Employee recognition (1.1 @ $80) 1,000 500 27-07 Mileage reimbursement Job Performance 4,588 2,838 1,500 1,500 28-01 Telephone Utility Expenditures 1,500 1,500 4,000 3,000 29-22 Marketing expense (trade shows, csae, pcma, promos) 1,000 0 29-35 Shuttle buses for conferences Other Current Expenses 5,000 3,000 (moved to 101-5600) Total Operations & Maintenance Costs 23,618 18,911 Week 3 - Page 5 of 48 COMMUNITY SERVICES FUND Special Revenue Fund, #222-2900 Local Marketing District Assistance Town of Estes Park - 2012 Budget SCOPE OF SERVICES Beginning in 2010, Town Board agreed to provide assistance with LMO payroll. An amended agreement was made in 2011. This division will be discontinued in 2012 based on further revisions to the agreement. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Revenues Miscellaneous (personnel reimbursement) Total Revenues Expenditures Personnel Salaries Benefits $75,824 $574,801 5574,801 50 5,824 574,801 574,801 0 269,350 407,069 413,228 0 137,987 167,732 168,637 0 407,337 574,801 581,865 0 Operations & Maintenance 1,265 1,500 1,919 0 Capital 0 0 0 0 Total Expenditures $408,602 $576,301 5583,784 $0 inc/dec over prior year N/A N/A N/A -100.00% Personnel Communications Manager Communications Coordinator Stakeholder Sales/Service Manager Executive Director Seasonal Administrative Assistant Mtgs/Conf sales Manager 1.00 1.00 1.00 1.00 0.50 1.00 1.00 1.00 1.00 1.00 0.50 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 Operations & Maintenance Insurance -liability 1,000 1,500 1,919 2,111 Publication fees 265 0 0 0 1,265 1,500 1,919 2,111 Capital none 0 0 0 0 Week 3 - Page 6 of 48 COMMUNITY SERVICES FUND Special Revenue Fund, #222-5304 Senior Center Town of Estes Park - 2012 Budget SCOPE OF SERVICES Provide ort-site dining, take-out meals, and Meals on Wheels. Offer information with referral services. Organize health & wellness classes, adult education programs, and recreational opportunities on and off -site. Coordinate approximately 100 volunteers. Offer facility rental and public meeting space. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Revenues Grants/Awards Charges for Services Miscellaneous Total Revenues Expenses Personnel Services Salaries Benefits $6,375 $2,475 $2,475 $2,475 20,166 23,852 23,852 25,652 28,436 51,100 51,400 53.050 54,977 77,427 77,727 81,177 84,177 28,926 113,103 Operations & Maintenance 105,809 81,847 33,209 115,056 105,576 84,980 84,212 33,906 37,737 118,886 121,949 106,465 111,026 Total Current Expenses 218,912 220,632 225,351 232,975 Capital Total Expenses 218,912 inc/dec over prior year Budget comments Revenues (totals) 19,500 240,132 19,500 20,000 244,851 252,975 2010 2011 O 2011 R 2012 54,977 77,427 77,727 81,177 Intergovernmental 6,375 2,475 2,475 2,475 Services 20,166 23,852 23,852 25,652 Current (buildings, fund raisers, United Way) 15,602 19,500 19,500 19,950 Other (SC Inc) 11,624 30,500 30,500 32,000 Coffee fund 1,100 1,000 1,000 1,000 Van usage fees 110 100 400 100 Personnel Services Community Services Director Senior Center Manager Van Drivers Senior Center Coordinator Operations & Maintenance Insurance premiums 0.10 1.00 0.10 0.50 0.10 1.00 0.15 0.50 0.10 1.00 0.15 0.50 0.10 1.00 0.15 0.50 1,730 1,851 2,581 2,839 Week 3 - Page 7 of 48 COMMUNITY SERVICES FUND Special Revenue Fund, #222-5304 Senior Center Town of Estes Park - 2012 Budget SCOPE OF SERVICES Provide on -site dining, take-out meals, and Meals an Wheels. Offer information with referral services. Organize health & wellness classes, adult education programs, and recreational opportunities on and off -site. Coordinate approximately 100 volunteers. Offer facility rental and public meeting space. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Professional fees/services Publishing Repair & maintenance Materials & supplies Job performance expenses Utilities Total Expenditures Capital SCINC: deck repair/wood floor/water heater SCINC: dining room upgrade 34,418 171 23,190 33,312 1,064 11,924 32,130 0 28,200 28,770 1,375 13,250 32,130 0 28,900 28,239 1,365 13,250 27,727 2,000 31,735 31,780 1,365 13,580 105,809 0 0 105,576 106,465 19,500 19,500 0 0 111,026 0 20,000 Week 3 - Page 8 of 48 Town of Estes Park Detail budget information Special Revenue Fund, #222-5304-453 Senior Center 2011 2012 Account Account Name Orig Budget Budget Number Detail 1,026 1,816 21-01 Property 825 1,023 21-02 Liability insurance Premiums 1,851 2,839 11,970 11,727 22-09 IT Services 20,160 16,000 22-71 Food service contract Professional Services/Fees 32,130 27,727 Publishing 0 2,000 23-01 Meal program promo materials (SCINC) (SCINC - Senior Center fnc funding source) 22,235 25-01 Maintenance contracts 800 700 25-01 Carpet cleaning 860 860 25-01 Floors 6,360 6,360 25-01 Janitorial 3,611 3,719 25-01 Mechanical Services contract 360 360 25-01 Small copier contract 2,459 3,091 25-01 Telephone (7) 450 950 25-01 Valley Fire Inspections 1,500 1,500 25-01 SCINC: Large Copier Contract 1,500 2,250 25-01 Hydroplant grounds -Janitorial 800 800 25-01 Entry Mats 600 600 25-01 Window washing 0 195 25-01 AED Authority - annual 0 500 25-01 Email subscriber list mgmt 400 350 25-01 Grease trap pumping 1,500 3,500 25-02 Buildings 3,700 2,700 25-04 Van maintenance 3,300 25-98 Other 2,000 2,500 25-98 Kitchen equipment 1,300 800 25-98 Meeting room and program equipment 1laintenance & repair 28,200 31,735 1,450 1,450 26-01 Office Supplies 500 500 26-02 Postage 1,000 1,000 26-10 Lawn 17,930 26-16 Programs 4,950 4,950 26-16 Day trip ticketing (participant covered) 5,520 6,360 26-16 Instructor fees (participant covered) 350 1,320 26-16 Class trip supplies 1,500 1,500 26-16 Membership events 500 500 26-16 Guest meals 500 500 26-16 Volunteer recognition 2,800 2,800 26-16 General programs/supplies 0 26-23 Furniture, Fixtures & Equipment 1,000 0 26-23 Billiards/furniture (SCINC) 0 2,400 26-33 Data processing 1,000 1,000 26-96 Coffee (pass through from SCINC) Week 3 - Page 9 of 48 Town of Estes Park Detail budget information Special Revenue Fund, #222-5304-453 Senior Center 2011 2012 Account Account Name Orig Budget Budget Number Detail 7,500 26-97 Operating supplies 3,000 3,000 26-97 Meals -Wheels (pass through) 1,200 1,200 26-97 Fundraising supplies 2,000 1,500 26-97 Food service 1,500 1,800 26-97 Janitorial Materials and Supplies 28,770 31,780 600 27-04 Education/Training 200 600 27-04 Colo Assoc of Senior Ctrs (workshops) 400 0 27-04 Computertraining(2) 135 125 27-05 Member Dues/Subscriptions 140 140 27-06 Employee Recognition (1.75 @ $80) 500 500 27-07 Mileage Reimbursement Job Performance Expenses 1,375 1,365 1,020 1,020 28-01 Telephone 1,500 2,200 28-02 Natural gas 7,400 7,000 28-03 Electrical energy 530 560 28-04 Water 600 600 28-05 Sewer 2,200 2,200 28-06 Trash Disposal Utility Expenditures 13,250 13,580 Total Operations & Maintenance Costs 105,576 111,026 20,000 32-22 SCINC: dining rm upgrade 7,000 0 SCINC: refinish and repair exterior deck 5,000 0 SCINC: refinish wood floor (rm 114) 7,500 0 SCINC: replace commercial water heater Capital Equipment 19,500 20,000 Week 3 - Page t0 of 48 COMMUNITY SERVICES FUND Special Revenue Fund, #222-5500 Events Town of Estes Park - 2012 Budget SCOPE OF SERVICES Plan and execute Town events such as Jazz Fest Wool Market, Rooftop Rodeo, Auto Extravaganzas, Elk Fest, and Catch the Glow Assist with local events such as the Longs Peak Scottish-lrish Festival, July 4th fireworks, Coolest Car Show, Autumn Gold, an Scandinavian Festival. Coordinate use of Fairgrounds, Performance Park, and other Town venues. Support destination shows such as the Hunter -Jumper Horse Show, Senior Rodeo, Dressage and Miniature Horse Shows Monage approximately 110 volunteers Solicit new events. Maintain facilities. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Revenues Charges for services Current Miscellaneous Total Revenues Expenditures Personnel Salaries Benefits $487,563 $482,300 $515,026 $527,200 34,244 26,600 23,040 26,500 78,194 61,500 45,901 47,751 600,001 570,400 583,967 601,451 334,086 332,503 333,418 340,189 106,294 131,730 134,265 126,255 440,380 464,233 467,683 466,443 Operations & Maintenance 633,884 660,059 671,004 672,364 Capital 44,082 0 0 0 Total Expenditures $1,118,346 $1,124,292 $1,138,687 $1,138,807 inc/dec over prior year 15% 1% 2% 0% Revenues $600,001 $570,400 $583,967 $601,451 Special Event vendor permits 7,780 4,500 4,500 4,500 Arena 24,442 19,500 26,066 26,500 Stall 110,942 110,000 101,000 105,000 Camper 21,161 17,500 15,500 16,500 Commercial Vendors 28,765 24,000 31,484 31,000 Storage 2,211 2,500 2,500 2,500 Parking 7,005 8,300 8,300 8,300 Food concessions 11,856 12,000 10,000 10,000 Dance (Rodeo Queen) 4,349 4,000 4,438 4,500 Admissions 148,311 135,000 168,118 170,000 Entry Fees (Wool Market animals) 10,495 10,500 10,500 10,600 Workshop fees 28,289 30,000 30,620 31,800 Feed sales 76,884 98,000 91,000 95,000 Retail 12,853 11,000 11,000 11,000 Buildings 13,974 7,000 7,000 7,000 Real property (Bond/Performance Park rentals; 3,770 1,600 4,040 4,500 Donations 16,500 18,000 12,000 15,000 Week 3 - Page 11 of 48 COMMUNITY SERVICES FUND Special Revenue Fund, #222-5500 Events Town of Estes Park - 2012 Budget SCOPE OF SERVICES Plan and execute Town events such as Jazz Fest, Wool Market Rooftop Rodeo, Auto Extravaganzas, Elk Fest, and Catch the Glow Assist with local events such as the Longs Peak Scottish -Irish Festival, July 4th fireworks, Coolest Car Show, Autumn Gold, ons Scandinavian Festival. Coordinate use of Fairgrounds, Performance Park, and other Town venues Support destination shows such as the Hunter Jumper Horse Show, Senior Rodeo, Dressage and Miniature Horse Shows Manage approximately 110 volunteers Solicit new events. Maintain facilities. Original Budget Revised Budget 2010 2011 2011 Other Sponsorship Program sales Platte River Power Authority - No Colorado Economic Development (Grant) Budget 2012 Personnel Fairgrounds/Special Events Manager Municipal Services Foreman Special Events Coordinator Special Events Worker Seasonal workers (FTEs)' Community Services Director 16,466 35,359 9,808 8,781 3,000 38,000 8,000 8,000 3,000 34,000 150 8,751 3,000 36,000 0 8,751 1.00 1.00 1.00 1.00 4.06 0.46 1.00 1.00 1.00 1.00 4.06 0.46 1.00 1.00 1.00 1.00 4.06 0.46 'seasonal employee numbers are calculated by taking total budgeted seasonal wages and dividing by FTE units. It does no necessarily reflect the number of actual seasonal workers hired 1.00 1.00 1.00 1.00 4.06 0.46 Operations & Maintenance Insurance premiums 11,304 12,107 12,696 9,802 Professional fees/services 153,576 151,637 169,096 154,875 Publishing 3,076 5,157 5,325 4,200 Rentals 36,910 22,150 31,328 25,400 Real property 0 6,520 0 7,768 Repair&maintenance 115,480 82,314 91,248 94,709 Materials & supplies 99,293 145,860 130,085 129,250 Job performance expenses 13,553 15,670 14,958 15,920 Utilities 49,338 47,704 53,297 50,945 Other current expenditures 151,354 170,940 163,021 179,495 Total Expenditures 633,884 660,059 671,004 672,364 Capital (site work - arena floor) 44,082 0 0 0 25pecial Events vehicle G-84A (1/D 5200 Tractor) replaced from Vehicle Replacement Fund - $50,00( Week 3 - Page 12 of 48 Town of Estes Park Detail budget information Events (222-5500-455-) 2011 2012 Account Name Orig Budget Budget Account Number Justification 8,776 5,490 • 21-01 Property 3,331 4,312 21-02 Liability Insurance Premiums 12,107 9,802 300 300 22-08 Legal 9,576 11,727 22-09 IT 1,200 2,200 22-10 Bank Service fees 43,488 22-12 Contract Services 11,500 11,500 Christmas Parade 3,100 3,100 Jazz Fest 5,100 5,100 Elk Fest 17,788 19,788 Wool Market - judges fees 0 2,000 Concert 0 2,000 Other contracted services 96,050 22-20 Entertainment 18,500 18,500 Jazz Fest - bands 5,300 3,300 Performance Park 7,500 5,500 Riverside Plaza/Bond Park singalongs 30,000 30,000 Fireworks/4th July 1,600 1,600 Rooftop Rodeo 35,000 35,000 Scottish Fest/Hotel rooms 150 150 Auto Extravaganza 2,000 0 Heritage Festival 1,913 2,000 Hunter Jumper concert 1,000 1,000 22-26 Insurance damage claims 110 110 22-98 Other prof services as needed professional Fees/Services 151,637 154,875 300 300 23-01 Publication fees 3,900 23-02 Advertising production 490 500 Rodeo News 347 0 Arabian Magazine 1,200 1,200 Banner Changes 120 500 Poster designs 500 500 Western Horseman Magazine 1,000 1,000 Regent Broadcast Radio Assoc 1,000 0 Radio Ads - Wool Mkt 200 200 Scoops Ad - Car Show 'ublishing 5,157 4,200 22,900 24-01 Equipment 1,400 1,400 Bobcat 19,100 20,000 Tents/tables - Wool Market 1,650 1,500 Panel rental - Wool Market 0 2,500 Sound equipment for facility :eetal Equipment 22,150 25,400 3,700 3,700 24-02 School Rental - Wool Market 2,820 3,423 Office/Trailer rental 0 645 School rental - Westernaires Week 3 - Page 13 of 48 Town of Estes Park Detail budget information Events{222-5500-455-) 2011 2012 Account Account Name Orig Budget Budget Number Justification Real Property 6,520 7,768 20,226 25-01 Maintenance contracts 2,258 2,797 Phone (6) 3,800 5,889 Copier 420 420 Hand-held radios 9,120 9,120 Sound Systems (downtown/fairgrounds) 0 1,500 Larimer County Work Crews 0 500 Email Subscriber List mgt 27,800 25-02 Buildings 15,000 17,000 General 2,500 2,800 Roof gazebos and small office 0 8,000 Stall repair/maintenance 2,500 0 Privacy fence 5,000 0 Dirt - stalls/alleys 2,800 25-03 Furniture/fixtures 1,600 0 Misc repair/supplies 0 2,800 20x40 tent, sides 35,000 37,000 25-04 Vehicle maintenance and fuel 500 600 25-05 Machinery/tools 4,616 6,283 25-44 Future vehicle purchase Repair & Maintenance 82,314 94,709 3,200 3,200 26-01 Office Supplies 1,750 1,750 26-02 Postage 1,000 600 26-03 Printing/forms 500 500 26-04 Freight/shipping 4,810 5,000 26-05 Janitorial 1,000 1,000 26-06 Small tools 1,500 500 26-07 Small hardware 11,500 9,400 26-08 Lumber/Paint 5,000 7,000 26-10 Lawn 70,000 68,000 26-12 Feed costs 500 250 26-13 Medical 15,000 10,000 26-15 Exhibit/Display 11,300 0 26-16 Programs (Rooftop, Wool) 6,000 26-17 Catering/special circumstances 6,000 4,700 Wool Market luncheons 900 1,300 Rodeo 4,400 26-18 Trophies/Awards 150 150 Rooftop President 650 650 Elk Fest Bugling 3,200 3,200 Wool Market Ribbons 400 400 Auto Extravaganza 9,000 1,500 3,500 26-23 Equipment -Tables (8', picnic) 1,500 26-23 New folding tables 4,000 26-23 Heaters for events 800 0 26-32 Data processing software 2,700 0 26-33 Data Processing Equipment 800 800 26-46 Communication equipment 700 850 26-48 Shop Equipment Week 3 - Page 14 of 48 Town of Estes Park Detail budget information Events (222-5500-455-) 2011 2012 Account Account Name Orig Budget Budget Number Justification 1,000 1,000 26-52 Traffic Signs Materials and Supplies 145,860 129,250 150 500 27-01 Personal Safety Equipment 1,500 1,500 27-02 Uniform allowance 8,250 27-04 Education/training 100 150 Farm show 500 500 Computer training 100 150 Stock Show 450 0 Colo Festival and Events Conf 4,700 4,700 Prof Rodeo Cowboys Assoc (PRCA) rodeo 500 750 Equip training for two FTEs 2,000 2,000 Footing academy, equip training 4,497 27-05 Member dues/subscriptions 22 22 Western Horsemen 315 315 Amer Society for Composers, Authors, and Publishers (ASCAP) 100 100 International Festivals/Events Assoc 150 150 Alpaca -Llama Show Association 25 25 Rabbit Sanction fees 500 500 State Discharge Permit 100 100 Assoc of Rodeo Committees 1,250 1,250 PRCA 300 300 Broadcast Music Inc (BMI) 260 260 Society of European Stage Authors and Composers (SESAC) 500 500 Alpaca Owners and Breeders Assoc 150 150 Cultural Arts Council 275 275 League of Equine and Agriculture Ctrs 50 50 Colo Assoc of Fairs and Shows 500 500 Commercial Drivers License (CDL) fees 353 353 27-06 Employee recognition (4.41 x $80) 820 820 27-07 Mileage reimbursement lob Performance 15,670 15,920 4,100 4,100 28-01 Telephone 3,600 3,800 28-02 Natural Gas 10,500 11,009 28-03 Electrical Energy 9,504 10,036 28-04 Water 6,000 6,000 28-05 Sewer 14,000 16,000 28-06 Trash Disposal Jtility Expenditures 47,704 50,945 650 650 29-12 Parade (Rooftop Rodeo) 3,980 29-13 Dance (rodeo) 3,480 3,980 Queen's Dance room rental 1,500 1,500 29-14 Sponsors' dinner 48,300 29-15 Added purse money 23,600 40,000 Rodeo (upgrade to medium-sized rodeo) 3,000 3,000 Draft horse show 7,000 5,300 Wool Market Week 3 - Page 15 of 48 Town of Estes Park Detail budget information Events (222-5500-455-) 2011 2012 Account Account Name Orig Budget Budget Number Justification 2,000 2,325 29-16 Security/Ticket Labor 3,750 29-17 Volunteers banquets 2,100 2,100 Rooftop Rodeo 1,000 1,000 Wool Market 425 425 Elk Fest 225 225 Auto Show 95,560 92,590 29-18 Rodeo 8,200 29-20 Resale purchases 5,200 5,200 Wool market 2,000 3,000 Elk Fest 3,200 3,200 29-25 Promotion (Queens/ponies) 20,000 15,000 29-30 Manure/bedding Other Current Expenses 170,940 179,495 Total Operations & Maintenance Costs 660,059 672,364 Week 3 - Page 16 of 48 COMMUNITY SERVICES FUND Special Revenue Fund, #222-5700 Museum Town of Estes Park - 2012 Budget SCOPE OF SERVICES Create permanent exhibits, temporary installations, and off -site installation, Conduct educational programs, provide research assistance, and manage web site Manage collections of historical objects and related databases Oversee Fall River Hydroplant and Knoll -Willows properties. Manage approximately 55 volunteers. Offer facility rental and publk meeting space. Original Budget Revised Budget 2010 2010 2011 Budget 2012 Revenues Grants Charges for Services Other Total Revenues Expenditures Personnel Salaries Benefits 6,037 13,065 13,065 0 1,668 3,985 3,205 2,150 19,797 17,700 18,300 18,900 $27,502 $34,750 $34,570 $21,050 101,705 110,456 112,342 102,354 39,637 48,108 52,805 58,789 141,342 158,564 165,147 161,143 Operations & Maintenance 94,172 90,831 90,596 81,800 Capital 6,500 10,000 10,000 10,000 Subtotal 242,014 259,395 265,743 252,943 Rollovers 0 0 0 0 Total Expenditures 242,014 259,395 265,743 252,943 Inc/dec over prior year 10% -2% Personnel Community Services Director Curator -Education Curator - Exhibits/Manager Seasonal grant -funded Digital Technician Seasonal (Shared with CVB) Revenues 2010 2011 O 2011 R 2012 0.14 €.00 1.00 0.33 0.00 0.14 1.00 1.00 0.33 0.00 0.14 1.00 1.00 0.33 0.23 0.14 1.00 1.00 0.00 0.23 Grants $6,037 $13,065 $13,065 $0 Charges for services 1,668 3,985 3,205 2,150 Miscellaneous (buildings, donations) 7,058 6,500 7,100 7,600 Contributions from "Friends" 12,739 11,200 11,200 11,300 Total revenues 27,502 34,750 34,570 21,050 Operations & Maintenance insurance premiums 4,779 5,114 5,114 4,308 Professional fees/services 22,768 19,952 20,059 19,662 Publishing 2,259 2,295 2,345 3,345 Repair& maintenance 31,165 25,224 29,379 25,464 Materials & supplies 16,620 16,710 16,085 10,650 Week 3 - Page 17 of 48 COMMUNITY SERVICES FUND Special Revenue Fund, #222-5700 Museum Town of Estes Park - 2012 Budget SCOPE OF SERVICES Create permanent exhibits, temporary installations, and off -site installation Conduct educational programs, provide research assistance, and manage web site Manage collections of historical objects and related databases Oversee Fall River Hydroplant and Knoll -Willows properties. Manage approximately 55 volunteers. Offer facility rental and public meeting space. Original Budget Revised Budget 2010 2010 2011 Budget 2012 Job performance expenses Utilities Total Expenditures Capital Buildings remodeling/upgrades Event Garden {FRIENDS) Handicap door - front/back (FRIENDS) Roof repair (FRIENDS) 2,563 14,018 94,172 3,071 18,465 90,831 2,381 15,233 90,596 2,671 15,700 81,800 6,500 0 0 0 0 10,000 10,000 0 0 0 0 10,000 6,500 10,000 10,000 10,000 Week 3 - Page 18 of 48 Town of Estes Park Detail budget information Special Revenue Fund, #222-5700-457 Museum and Hydroplant 2011 2012 Account Account Name Orig Budget Budget Number Detail 3,677 3,044 21-01 Property 1,437 1,264 21-02 Liability Insurance Premiums 5,114 4,308 0 100 22-08 Legal 19,152 18,762 22-09 IT Services 800 800 22-10 Banks chgs (reimb by FRIENDS) Professional Services/Fees 19,952 19,662 Publishing 2,295 1,050 23-01 Publications 0 2,295 23-02 Advertising 2,295 3,345 25-01 Maintenance contracts 21,964 2,657 2,900 Trane mechanical 2,057 2,504 Telephone system (5) 6,500 7,260 Cleaning Museum 450 450 Pastperfect software mtc 3,000 4,000 Copier 100 100 Fire extinguisher 500 500 Enviropest 500 500 Enviropest (Hydro) 500 500 ADT Security Hydro 2,000 2,000 Clean hydroplant 0 500 Email Subscriber List Mgmt 750 750 Entry mats 25-02 Buildings 2,000 2,000 2,000 General 500 0 Museum Lights/Ballasts 2,600 1,500 25-04 Van Maintenance 1,110 0 25-44 Future vehicle purchase Maintenance & Repair 25,224 25,464 2,160 2,050 26-01 Office Supplies 1,800 1,800 26-02 Postage 300 100 26-03 Printing/Forms 100 100 26-04 Freight/Shipping 600 400 26-05 Janitorial 2,300 26-15 Exhibit/Display 0 250 Stanley Fairground sign 0 500 Mace exhibit 0 800 Birch Cabin signs 0 250 Sweet History exhibit 0 250 Horse Power exhibit 500 250 Exhibit repairs Week 3 - Page 19 of 48 Town of Estes Park Detail budget information Special Revenue Fund, #222-5700-457 Museum and Hydroplant 2011 2012 Account Account Name Orig Budget Budget Number Detail 350 0 Wiest Butterflies 1,200 0 Hydro signs 500 0 History clothing 1,900 26-16 Programs 300 500 Education (Rotary funded) 1,200 900 Speaker expense 300 200 Program supplies 500 300 Van trip 950 26-17 Catering/special circumstances 500 550 Exhibit openings (2) 250 200 Volunteer brunch/pot luck 200 100 Volunteer recognition 150 100 Meeting refreshments 100 0 26-23 Furniture/fixtures 650 26-26 Conservation supplies 500 400 Archival Folders/Papers 500 250 Acquisitions 0 26-33 Data processing equipment 4,700 0 Manager/laptop 0 400 External backup drive Materials and Supplies 16,710 10,650 1,200 27-04 Education/Training 800 900 Colo-Wyo Assoc of Museums (CWAM) 300 200 Front Range educators 300 0 Assoc of Northern Front Range Museums (curator) 200 100 Reference materials 1,100 27-05 Member Dues/Subscriptions 225 225 Amer Assoc of Museums 110 110 Amer Assoc for State/Local History 60 60 Mountain -Plains Museum Assoc 40 40 CWAM 100 100 Cultural Arts Council of Estes Park 65 65 Colorado Historical Society 45 45 Estes Park Trail Gazette 55 55 Nat Assoc Interpretation 300 300 American Society of Composers, Authors and Publishers Broadcast Music Incorporated Society of European Stage Authors and Composers 100 100 Domain name registration 171 171 27-06 Employee Recognition (2.14 FTE @ $80) Week 3 - Page 20 of 48 Town of Estes Park Detail budget information Special Revenue Fund, #222-5700-457 Museum and Hydroplant 2011 2012 Account Account Name Orig Budget Budget Number Detail 200 200 27-07 Mileage Reimbursement Job Performance Expenses 3,071 2,671 1,550 1,550 28-01 Telephone 3,050 3,050 28-02 Natural gas 10,465 7,400 28-03 Electrical energy 1,600 1,900 28-04 Water 500 500 28-05 Sewer 1,300 1,300 28-06 Trash Disposal Utility Expenditures 18,465 15,700 Total Operations & Maintenance Costs 90,831 81,800 33-22 Building remodeling 10,000 0 Handicap door front/back (FRIENDS) 0 10,000 Roof repair (FRIENDS) Capital Equipment 10,000 10,000 (NPS Building, storage shed) Week3-Page21 of46 COMMUNITY SERVICES FUND Special Revenue Fund,14222-5800 Conference Center Town of Estes Park - 2012 Budget SCOPE OF SERVICES Operation of conference center. See #2800 for further details on scope of services Original Budget Revised Budget 2010 2011 2011 Budget 2012 Revenues Miscellaneous (Holiday Inn F&B concession) $24,000 $24,000 $24,114 $24,000 Total Revenues Expenditures Personnel 0 0 0 0 Operations & Maintenance 99,974 117,779 117,779 115,998 Capital 0 0 0 0 Total Expenditures 99,974 117,779 117,779 115,998 Inc/dec over prior year -8% 8% 0% -2% Personnel none 24,000 24,000 24,114 24,000 Operations & Maintenance Insurance premiums 8,275 8,854 8,854 7,298 Rentals 35,289 36,250 36,250 36,250 Repair & maintenance 7,752 15,000 15,000 15,000 Utilities 48,658 57,675 57,675 57,450 Total Expenditures 99,974 117,779 117,779 115,998 Capital Stacking chairs replacement program 0 0 0 0 Week 3 - Page 22 of 48 Town of Estes Park Detail budget information Conference Center (222-5800-458-) 2011 2012 Account Account Name Orig Budget Budget Number Justification 8,854 7,298 21-01 Property Insurance Premiums 8,854 7,298 24,000 24,000 24-02 Real property Equipment 12,250 12,250 24-04 Land taxes 36,250 36,250 15,000 15,000 25-02 Buildings (repairs as needed) Repair & Maintenance 15,000 15,000 975 1,000 28-01 Telephone 1,200 1,200 28-02 Natural Gas 50,000 50,000 28-03 Electrical Energy 3,250 3,250 28-04 Water 2,250 2,000 28-05 Sewer Utility Expenditures 57,675 57,450 Total Operations & Maintenance Costs 117,779 115,998 Capital 0 0 33-31 Week 3 - Page 23 of 48 Light & Power Fund Enterprise Fund, #502 Town of Estes Park 2012 Budget SCOPE OF SERVICES Light & Power provides reliable quality electric power to approximately 10,000 accounts, including Rocky Mountain National Park. All customers are served through two substations with electricity provided by Platte River Power Authority. Light & Power maintains aver 300 miles of distribution lines and constructs infrastructure for new developments. Light & Power is also responsible for reading all electric meters, maintenance of all Town -owned street lights, and records management including billing information and federal reporting. The Town promotes energy efficiency and offers renewable energy to all of its customers. Original Budget Revised Budget 2010 2011 2011 Budget 2012 OPERATING REVENUES Charges for Services Other Total Operating Revenues OPERATING EXPENSES Source of Supply Distribution Personnel $11,834,082 $12,564,144 $12,304,538 $13,186,105 330,457 210,379 214,817 200,001 12,164,539 12, 774,523 5,327,859 5,922,716 12,519,355 13,386,106 5,922,830 6,413,487 1,247,588 1,321,636 1,326,075 1,341,187 Operations and Maintenance 530,960 696,494 713,601 717,959 Customer Accounts Personnel 536,544 539,543 548,505 540,968 Operations and Maintenance 102,564 122,265 116,851 126,840 Administration/General Personnel 369,354 380,298 407,886 469,502 Operations and Maintenance 1,190,592 1,398,574 1,312,746 1,380,188 Capital 0 724,872 1,190,006 1,298,000 Depreciation 791,376 0 0 0 TOTAL OPERATING EXPENSES change from prior year OPERATING INCOME (LOSS) 10,096,837 11,106, 398 11,538,499 12, 282,131 5% 9% 12% 6% 2,067,702 1,668,125 980,856 1,103,975 NON OPERATING REVENUES (EXPENSES) Intergovernmental 7,500 0 0 0 Investment income 60,358 50,000 32,000 35,000 Interest expense/Debt service payments (211,700) (448,319) (448,319) (449,213) Interest Expense (Bonds) incl above incl above incl above incl above TOTAL NON -OPERATING REVENUES (EXPENSES) NET INCOME (LOSS) BEFORE CAPITAL CONTRIBUTIONS AND TRANSFERS Capital Contributions Transfers Out CHANGE IN AVAILABLE FUNDS Rollover adjustment AVAILABLE FUNDS*, Beginning, as Restated AVAILABLE FUNDS*, Ending Rollovers (143,842) (398,319) (416,319) (414,213) 1,923,860 1,269,806 564,537 689,762 0 0 0 0 (1,007,750) (1,023,467) (1,036,294) (1,112,829) 916,110 246,339 (471,757) (423,067) 0 0 0 0 5,709,855 6,625,965 6,625,965 6,154,208 $6,625,965 $6,872,304 $6,154,208 $5,731,141 0 0 411,540 0 *Fund availability is calculated as 'net current assets less inventories', (source: audited financial statements, page 6, for the fiscal year ended Dec. 31, 2010). Amounts for 2010 ending balance are unrestricted current assets ($8,914,650) less current liabilities ($1,645,545) less inventories ($643,140) for an available fund balance of $6,625,965. $116,859 of fund balance is in form of Note Receivable from Estes Park Housing Authority, due June 2013. COVERAGE DATA Week 3 - Page 24 of 48 Light & Power Fund Enterprise Fund, #502 Town of Estes Park 2012 Budget SCOPE OF SERVICES Light & Power provides reliable quality electric power to approximately 10,000 accounts, including Rocky Mountain National Park. All customers are served through two substations with electricity provided by Platte River Power Authority. Light & Power maintains over 300 miles of distribution lines and constructs infrastructure for new developments. tight & Power is also responsible for reading all electric meters, maintenance of all Town -owned street lights, and records management including billing information and federal reporting. The Town promotes energy efficiency and offers renewable energy to all of its customers. Original Budget Revised Budget 2010 2011 2011 Debt service ratio' 6.57 3,54 2.97 Band covenant requirements 1.25 1.25 1.25 1.25 *Debt service ratio = (total revenues - total expenditures + capital + future vehicle replacement +cap -related engineering costs)/debt service 90 days operating coverage* (>1.00) 2.34 2.32 2.08 1.83 '90 day ratio = fund balance/((total expenditures - capital) x .25) Fund balance $6,625,965 $6,872,304 $6,154,208 $5,731,141 (90 day coverage) (2,829,072) (2,963,328) (2,958,277) (3,136,543) Fund balance -90day coverage ratio $3,796,893 $3,908,976 $3,195,932 $2,594,598 Budget 2012 Summary of expenditure types Source of Supply Personnel Salaries Benefits Operations and Maintenance Capital Depreciation Debt Service Transfers out (to General Fund) Rollovers 5,327,859 5,922,716 2,153,486 2,241,477 1,602,729 638,748 1,824,116 2,217,333 0 724,872 791,376 0 211,700 448,319 1,007,750 1,023,467 0 0 5,922,830 2,282,466 1,635,370 647,095 2,143,197 1,190,006 0 448,319 1,036,294 0 3.27 6,413,487 2,351,656 1,658,048 693,609 2,218,988 1,298,000 0 449,213 1,112,829 0 11,316,287 12,578,184 13,023,112 13,644,173 Source of Supply Includes PRPA purchased power increase of 8.3%. Wind power included, projected at $47,000 in 2012 Wheeling charges (hydro) 2012 - $11,000 Personnel 5,327,859 5,922,716 5,922,830 6,413,487 Director of Utilities 0.58 0.58 0.58 0.58 Line Superintendent 1.00 1.00 1.00 1.00 Crew Chief 1.00 1.00 1.00 1.00 Linemen 8.00 8.00 8.00 8.00 Groundman 1.00 1.00 1.00 1.00 Material Mgmt. Specialist 1.00 1.00 1.00 1.00 Utilities Meter Foreman 1.00 1.00 1.00 1.00 Meter Specialist 1.00 2.00 2.00 2.00 Meter Reader 2.00 1.00 1.00 1.00 Secretary li 0.50 1.00 1.00 0.70 Electrical Engineer 0.80 0.80 0.80 0.80 IT Specialist 0.50 0.50 0.50 0.50 Secretary III 0.50 0.00 0.00 0.00 Human Resource Generalist 0.41 0.41 0.26 0.48 Payroll/HRTechnician 0.26 0.26 0.26 0.48 Seasonal GI5 0.83 0.00 0.00 0.00 Finance Officer Assistant Finance Officer Accountant I Accts. Payable/Utility Billing Specialist Administrative Clerk II Town Administrator Deputy Town Administrator 0.29 0.29 0.29 0.97 1.24 0.48 0.48 0.26 0.26 0.26 0.94 1.29 0.48 0.48 0.26 0.26 0.26 0.94 1.29 0.48 0.48 0.26 0.26 0.26 0.94 1.29 0.48 0.48 Week 3 - Page 25 of 48 Light & Power Fund Enterprise Fund, #502 Town of Estes Park 2012 Budget SCOPE OF SERVICES Light & Power provides reliable quality electric power to approximately 10,000 accounts, including Rocky Mountain National Park. All customers are served through two substations with electricity provided by Platte River Power Authority. Light & Power maintains over 300 miles of distribution lines and constructs infrastructure for new developments. Light & Power is also responsible for reading all electric meters, maintenance of all Town -owned street lights, and records management including billing information and federal reporting. The Town promotes energy efficiency and offers renewable energy to all of its customers. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Town Clerk Deputy Town Clerk Executive Secretary Public Information Officer Operations and Maintenance Distribution Engineering (Loveland IGA) included in Prof fees/services Insurance Premiums Professional fees/services Equipment rentals/leases Repair & Maintenance Materials & Supplies Job Performance Expenditures 0.48 0.48 0.48 0.48 0.48 0.48 0.48 0.48 0.48 0.48 0.48 0.48 0.48 0.48 0.48 0.48 0 25,000 25,000 5,000 5,849 6,258 9,372 10,309 26,090 28,900 38,943 57,500 2,400 2,400 2,400 2,400 306,948 475,750 477,579 474,250 167,514 149,000 151,621 142,000 22,159 34,186 33,686 31,500 530,960 696,494 713,601 717,959 customer Accounts Insurance Premiums 2,822 3,020 3,020 3,138 Professional fees/services 1,021 500 525 500 Equipment rentals/leases 896 2,000 1,000 1,000 Repair & Maintenance 7,051 7,665 7,871 7,676 Materials & Supplies 54,869 74,250 59,620 68,681 Job Performance Expenditures 339 4,830 4,815 4,845 Uncoltectible accounts 35,566 30,000 40,000 35,000 102,564 122,265 116,851 120,840 Administration Engineering Distribution system upgrade (15% of $2M project) 125,000 0 0 0 Future vehicle replacement 137,963 140,350 140,350 140,350 (these items are part of the below information) Insurance Premiums 41,480 45,454 45,454 37,517 Professional fees/services 126,182 85,987 68,741 89,477 Publishing 1,105 3,000 3,100 3,000 Equipment rentals/leases 88,658 89,000 89,000 89,000 Repair & Maintenance 301,013 363,514 366,733 343,111 Materials & Supplies 142,165 279,000 213,901 272,500 Job Performance Expenditures 41,131 60,515 61,015 54,380 Utilities 73,328 90,350 78,698 79,850 Other Interest on deposits 783 1,000 1,000 1,000 Payments in lieu of taxes (2.5%• urban revenue) 165,843 168,119 170,300 181,524 PUC Gross receipt taxes 9,892 10,892 10,444 11,000 Franchise Fees (3% - urban revenue) 199,011 201,743 204,360 217,829 1,190,592 1,398,574 1,312,746 1,380,188 Transfers General Fund (8.5%} 1,007,750 1,023,467 1,036,294 1,112,829 Debt Service Series 2027, $6.18m, 3.875% Bond principal 0 235,000 235,000 245,000 Bond interest 211,700 213,319 213,319 204,213 Capital Week 3 - Page 26 of 48 Light & Power Fund Enterprise Fund, #502 Town of Estes Park 2012 Budget SCOPE OF SERVICES Light & Power provides reliable quality electric power to approximately 10,000 accounts,- including Rocky Mountain National Park. All customers are served through two substations with electricity provided by Platte River Power Authority. Light & Power maintains over 300 miles of distribution lines and constructs infrastructure for new developments. Light & Power is also responsible for reading ail electric meters, maintenance of all Town -owned street lights, and records management including billing information and federal reporting. The Town promotes energy efficiency and offers renewable energy to all of its customers. Original Budget Revised Budget Budget 2010 2011 2011 2012 Building remodeling ML substation (2008-09), Line upgrades (2010) Station Equipment Office Equipment Data Processing Equipment ('11 revised includes rollovers) Transformers Communication Equipment Tools Subdivision lighting, poles, fixtures Security system - Elm Road Other machinery/equipment Street Lights Poles/Towers/Fixtures Overhead Lines ('11 revised includes rollovers) 2012 Camp Allenspark Phase I Conductor system upgrades/tree cable Underground Conductors (11 revised includes rollovers) Total Capital 0 0 0 0 34,690 38,846 0 0 0 0 0 0 0 786,163 0 0 923,133 15,000 20,000 0 25,000 91,549 100,000 43,323 15,000 0 0 15,000 10,000 20,000 250,000 0 0 120,000 15,000 20,000 0 25,000 145,216 100,000 43,323 15,000 0 19,546 15,000 10,000 20,000 402,201 0 0 359,720 75,000 0 20,000 13,000 40,000 125,000 0 15,000 10,000 0 20,000 10,000 20,000 0 688,000 112,000 150,000 1,782,832 724,872 1,190,006 1,298,000 'L&P vehicle 93313A ('02 Ford Explorer S-Trot) scheduled for replacement in Vehicle Replacement Fund in 2012, valued at $26,500. `L&P vehicle 93331A ('03 I-H 7400 (Bucket) 4x4) scheduled for replacement in Vehicle Replacement Fund in 2011, valued at $230,000. 'L&P vehicle 93320D ('06 GMC K3500 4x4) scheduled for replacement in Vehicle Replacement Fund in 2012, valued at $46,000. Week 3 - Page 27 of 48 Town of Estes Park Detail budget information Light and Power 502-6301-540 - Distribution 2011 orig 2012 Account Account Name Budget Budget Number Justification 0 2,721 21-01 Property 6,258 7,588 21-02 Liability Insurance Premiums 6,258 10,309 0 25,000 22-02 City of Loveland System Engineering (IGA) 0 15,000 22-13 Seasonal GIS 1,500 1,500 22-14 Lab testing 400 10,000 22-26 Insurance claims 2,000 1,000 22-30 Land use fees (Forest Service) 25,000 5,000 22-98 Other engineering as needed Professional Fees/Services 28,900 57,500 Rentals 2,400 2,400 24-01 Prospect Mtn access lease 10,000 10,000 25-01 Shop cleaning 15,000 0 25-02 Buildings 6,000 6,000 25-05 Machinery/tools 250 250 25-06 Meters 4,000 7,500 25-07 Transformers - repaint ground mounts 4,000 3,000 25-08 Lab - test safety equipment 15,000 15,000 25-30 Street light maintenance 40,000 50,000 25-31 Substation per [GA w/ PRPA (PRPA - Platte River Power Authority) 300,000 300,000 25-32 Overhead maintenance / tree trimming 75,000 75,000 25-33 Underground conduit 3,500 3,500 25-34 Customer service lines 3,000 4,000 25-98 Other equipment/machinery Repair and Maintenance 475,750 474,250 500 500 26-01 Office Supplies 1,000 1,000 26-04 Freight/shipping 1,500 1,500 26-05 Janitorial supplies 17,500 17,000 26-06 Small tools/new chain saws 6,000 5,000 26-07 Small hardware 0 5,000 26-19 Traffic control 2,500 2,000 26-20 Electrical 90,000 80,000 26-34 Meters 30,000 30,000 26-55 Street Tight program (new LEDs) Materials and Supplies 149,000 142,000 32,686 30,000 27-01 Personal Safety Equipment 1,000 1,000 27-03 Vehicle Allowance 500 500 27-07 Mileage reimbursement Job Performance 34,186 31,500 Total Operations & Maintenance Costs 696,494 717,959 Week 3 ; Page 28 of 48 Town of Estes Park Detail budget information Light and Power 502-6401-550 Customer Accounts 2011 orig 2012 Account Account Name Budget Budget Number Justification 3,020 3,138 21-02 Liability Insurance Premiums 3,020 3,138 500 500 22-98 Coding Accuracy Support System Professional Fees/services 500 500 (mailing list verification with USPS} Rentals 2,000 1,000 24-01 Town records disposal 25-01 Maintenance contracts 5,500 5,730 25-01 Minolta copier 525 0 25-01 Check encoder 1,365 1,716 25-01 Folder/inserter 125 230 25-01 Letter opener 150 0 25-03 Furniture/fixtures Repair and Maintenance 7,665 7,676 15,350 15,281 26-01 Office Supplies 27,500 27,500 26-02 Postage 12,500 12,500 26-03 Printing/forms 1,700 1,600 26-04 Freight/shipping 1,300 1,300 26-17 Catering/special circumstances 2,000 2,000 26-23 Furniture/fixtures 8,400 3,000 26-33 3 desktop replacements 5,500 5,500 26-42 Office equipment Materials and Supplies 74,250 68,681 4,500 4,500 27-04 Education/training - HUG conferences 210 225 27-05 Dues - HUG 120 120 27-07 Mileage reimbursement Job Performance 4,830 4,845 Uncollectible accounts 30,000 35,000 29-07 Uncollectible accounts Total Operations & Maintenance Costs 122,265 120,840 Week 3 - Page 29 of 48 Town of Estes Park Detail budget information Light and Power 502-6501-560 Administration/General 2011 prig 2012 Account Account Name Budget Budget Number Justification 37,852 30,943 21-01 Property 7,602 6,574 21-02 Liability Insurance Premiums 45,454 37,517 11,250 11,250 22-01 Auditing 0 10,000 22-02 Loveland IGA system analysis 250 250 22-07 Recording fees 5,000 5,000 22-08 Legal 45,487 60,977 22-09 IT Services (26 computers) 2,000 2,000 22-10 Bank Service 22,000 0 22-98 Other engineering/prof fees as needed Professional Fees/Services 85,987 89,477 Publishing 3,000 3,000 23-01 Publications tees 85,000 85,000 24-02 Real property- rent of Muni Bldg office space 4,000 4,000 24-03 Copier lease . Rentals 89,000 89,000 85,260 25-01 Maintenance contracts 13,520 13,600 25-01 Itron handheld reading equipment 6,000 6,000 25-01 MV-90 XI support 2,000 2,000 25-01 Minolta shop copier 5,000 5,000 25-01 HVAC (heating, ventilation, air-conditioning) 2,900 3,000 25-01 Milsoft 3,400 3,500 25-01 ARC FM 22,000 22,000 25-01 Wonderware SCADA (Supervisory Control and Data Acquisition) 1,800 1,800 25-01 OCE plotter 20,000 20,000 25-01 IT contracting 8,444 8,360 25-01 Telephone system (25) 10,000 0 25-02 Buildings (security cameras) 7,500 1,000 25-03 Furniture/fixtures (remod eng/shop} 120,000 127,500 25-04 Vehicle fuel & maintenance 100 100 25-05 Machinery/tools 140,350 128,751 25-44 Future vehicle purchases 500 500 25-98 Repair on minor equipment/machinery Repair and Maintenance 363,514 343,111 15,000 15,000 26-01 Office Supplies 5,000 5,000 26-02 Postage 1,500 2,000 26-03 Printing/forms 0 500 26-06 Machinery/tools 2,000 2,500 26-13 Medical 2,500 0 26-14 Laboratory 85,000 85,000 85,000 26-15 Exhibit/display 3,500 3,500 26-17 Catering/special circumstances 2,000 4,000 26-23 Furniture/fixtures 100,000 100,000 26-25 Energy efficiency program 10,000 10,000 26-32 Data processing software (Navaline 09) 26-33 Data processing equipment 17,500 10,000 26-33 Network, Meter (1), LP Shop (2) replacements 20,000 20,000 26-42 Copier-eng/plotter- GIS (Geographic Info Week 3 - Page 30 of 48 Town of Estes Park Detail budget information Light and Power 502-6501-550 Administration/General 2011 orig 2012 Account Account Name Budget Budget Number Justification System) 5,000 5,000 26-43 Heavy Equipment 10,000 10,000 26-46 Communication equipment Materials and Supplies 279,000 272,500 4,635 4,500 27-02 Uniform allowance 4,000 0 27-03 Vehicle allowance 34,200 27-04 Education/training 1,100 1,100 27-04 Rocky Mtn Electric Assoc (RMEA) meter school 2,500 2,500 27-04 ITRON (operating system) users conference 1,000 1,000 27-04 RMEA Fall tech conference 6,400 6,400 27-04 Mesa Hotline School 1,550 1,550 27-04 Rocky Mtn Electrical League (RMEL) classes 7,500 7,500 27-04 Safety training 1,800 1,800 27-04 Institute of Electrical/Electronic Engineers (IEEE) Conference 1,550 1,550 27-04 RMEL Spring/Fall conference 5,000 5,000 27-04 Apprentice training 2,000 2,000 27-04 Meter foreman training 2,000 2,000 27-04 Locater training 1,800 1,800 27-04 Energy efficient buildings conference 13,000 13,000 27-05 Membership dues/subscriptions 1,680 1,680 27-06 Employee recognition 2,500 500 27-07 Mileage reimbursement 500 500 27-10 Meal reimbursement-emerg. Job Performance 60,515 54,380 35,000 25,000 28-01 Telephone 10,000 10,000 28-02 Natural Gas 35,500 35,000 28-03 Electrical 2,500 2,500 28-04 Water 350 350 28-05 Sewer 7,000 7,000 28-06 Trash disposal Utility Expenditures 90,350 79,850 1,000 1,000 29-06 Interest on deposit 168,119 181,524 29-08 Payments in lieu of taxes {PILOTS) 10,892 11,000 29-09 Public Utility Customer Protection Division (PUC) gross receipts 201,743 217,829 29-10 Franchise fees Other current expenses 381,754 411,353 Total Operations & Maintenance Costs 1,398,574 1,380,188 Week 3 - Page 31 of 48 Town of Estes Park Detail budget information Light and Power 502-7001-580 Capital 2011 orig 2012 Account Account Name Budget Budget Number Justification 15,000 15,000 32-22 Building remodeling - general 0 60,000 32-22 New roof on L&P Building 20,000 20,000 33-30 SCADA equipment 25,000 13,000 33-32 Replace network copier/printer - Finance 91,549 40,000 33-33 Data processing equipment (ARCSDE GI5) 100,000 125,000 33-35 Transformers 43,323 0 33-36 Communication equipment 15,000 15,000 33-41 Tools 0 10,000 33-98 Subdivision lighting, poles, fixtures 15,000 20,000 34-98 IR sensor, inspection and maintenance 10,000 10,000 35-55 Street lights 20,000 20,000 35-56 Poles/towers/fixtures 250,000 35-57 Overhead lines 688,000 35-57 2012 Camp Allenspark Phase I 112,000 35-57 Cndctr system upgrade projects/tree cable 120,000 150,000 35-58 Underground conductor Capital Equipment 724,872 1,298,000 Week 3 - Page 32 of 48 Water Fund Enterprise Fund, #503 Town of Estes Park- 2012 Budget SCOPE OF SERVICES Services: Order/purchase/lease water, contract review, easements, planning and forecasting, augmentation plan, watershed management, report to River Commissioner, produce water for public, water plant and distribution system maintenance, maintain water mains and fire hydrants, customer billing meter maintenance, maintain bockflow prevention program, troubleshoot customer PS! and volume problems, locate water mains and service lines, maintain system maps Records management: COON reports, EPA reports, operations and historical data State required personnel: Class A water operators, Class 3 distribution system operators, Certified backflow prevention technician Original Budget Revised Budget 2010 2011 2011 Budget 2012 OPERATING REVENUES Charges for Services Miscellaneous Total Revenues OPERATING EXPENSES Source of Supply Purification Personnel Operations and Maintenance Distribution Personnel Operations and Maintenance Customer Accounts Personnel Operations and Maintenance Administration/General Personnel Operations and Maintenance Capital Depreciation $2,938,182 $3,276,066 $3,320,166 $3,334,323 12,907 12,289 12,289 12,289 2,951,089 3,288,355 3,332,455 3,346,612 158,817 160,561 160,561 164,461 289,666 274,986 278,455 285,952 297,459 422,621 372,478 386,283 692,703 753,107 765,365 784,357 231,482 317,256 288,792 267,958 126,759 135,991 138,023 119,875 183,509 154,773 152,348 140,325 135,230 138,382 144,974 169,887 406,250 385,703 371,531 363,355 0 486,000 1,380,422 486,000 576,297 0 0 0 TOTAL OPERATING EXPENSES 3,698,172 3,229,380 4,052,949 3,168,453 change from prior year 4% 4% 31% -22% OPERATING INCOME (LOSS) (147,083) 58,975 (720,494) 178,159 NON OPERATING REVENUES (EXPENSES) Investment income 21,155 30,000 16,000 17,000 Debt service payments/interest expense (125,555) (429,830) (429,180) (405,786) Interest expense (loans) incl above incl above incl above inci above TOTAL NON OPERATING REVENUES (EXPENSES) (104,400) (399,830) (413,180) (388,786) NET INCOME (LOSS) BEFORE TRANSFERS (251,483) (340,855) (1,133,674) (210,627) Capital Contributions (Tap fees) 196,004 0 0 0 Transfers Out (115,307) (116,265) (119,317) (120,493) CHANGE IN AVAILABLE FUNDS (170,786) (457,120) (1,252,991) (331,120) Rollover adjustment 0 0 0 AVAILABLE FUNDS`, Beginning, as Restated 3,076,094 2,905,308 2,905,308 2,448,188 AVAILABLE FUNDS*, Ending 2,905,308 2,448,188 1,652,317 2,117,068 Rollovers 0 0 904,115 0 'Fund availability is calculated as "net current assets less inventories", (source: audited financial statements, page 6 for the fiscal year ended Dec. 31, 2010). Amounts for 2010 ending balance are unrestricted current assets ($3,537,666) less current liabilities ($498,751) less inventories ($133,607) for a fund balance Week 3 - Page 33 of 48 Water Fund Enterprise Fund, #503 Town of Estes Park - 2012 Budget SCOPE OF SERVICES Services: Order/purchase/lease water, contract review, easements, planning and forecasting, augmentation plan, watershed management, report to River Commissioner, produce water far public, water plant and distribution system maintenance, maintain water mains and fire hydrants, customer billing meter maintenance, maintain backflow prevention program, troubleshoot customer PSI and volume problems, locate water mains and service lines, maintain system maps Records management: CAOH reports, EPA reports, operations and historical data State required personnel: Class A water operators, Class 3 distribution system operators, Certified bockflaw prevention technician Original Budget Revised Budget 2010 2011 2011 Budget 2012 of $2,905,308. $87,509 of fund balance is in form of Note Receivable from Estes Park Housing Authority, due June 2013. COVERAGE DATA Debt service coverage ratio* 3.82 1.29 1.52 Bond covenant requirements 1.10 1.10 1.10 'Debt coverage ratio = (total revenues - total expenditures + capital + future vehicle replacement + cap -related engineering costs)/debt service 90 days operating coverage* (>1.00) "90 day ratio = fund balance/((total expenditures - capital) x .25) Fund balance (90 day coverage} Fund balance - 90 day coverage amount Summary of expenditure types 1.47 1.10 3.75 3.57 2.47 3.16 2,905,308 (774,543) 2,448,188 (685,845) 1,652,317 (668,132) 2,117,068 (670,613) 2,130,765 1,762,343 984,185 1,446,455 Source of Supply 158,817 160,561 160,561 164,461 Personnel 1,244,358 1,302,466 1,326,816 1,360,071 Salaries 971,959 932,431 929,441 Benefits 349,256 394,385 430,629 Operations and Maintenance 1,118,700 1,280,353 1,185,150 1,157,921 Capital 0 486,000 1,380,422 486,000 Depreciation 576,297 0 0 0 Debt Service 125,555 429,830 429,180 405,766 Transfers out (to General Fund) 115,307 116,265 119,317 120,493 Rollovers 0 0 0 0 3,339,034 3,775,475 4,601,446 3,694,732 Personnel Director of Utilities Water Superintendent Assistant Water Superintendent Water Plant Operators Water Quality Manager Lab Technician Municipal Service Worker Cross Connection Control 5p. Secretary II Electrical Engineer Secretary ill Human Resource Generalist Payroll Technician Finance Officer Assistant Finance Officer Accountant Accounts Pay/Util bill Spec Administrative Clerk Town Administrator Deputy Town Administrator Town Clerk 0.37 0.37 0.37 0.37 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 2.00 3.00 4.00 4.00 1.00 1.00 0.00 0.00 1,00 1.00 1.00 1.00 3.00 3.00 3.00 3.00 1.00 1.00 1.00 1.00 0.15 0.15 0.30 0.30 0.20 0.20 0.20 0.20 0.15 0.15 0.00 0.00 0.11 0.11 0.14 0.14 0.14 0.14 0.14 0.14 0.16 0.16 0.14 0.14 0.16 0.16 0.14 0.14 0.16 0.16 0.14 0.14 0.46 0.46 0.46 0.46 0.62 0.62 0.61 0.61 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 Week 3 - Page 34 of 48 Water Fund Enterprise Fund, #503 Town of Estes Park - 2012 Budget SCOPE OF SERVICES Services: Order/purchase/lease water, contract review, easements, planning and forecasting, augmentation plan, watershed management, report to River Commissioner, produce water for public, water plant and distribution system maintenance, maintain water mains and fire hydrants, customer billing, meter maintenance, maintain bockflow prevention program, troubleshoot customer PSI and volume problems, locate water mains and service lines, maintain system maps Records management: COOH reports, EPA reports, operations and historical data State required personnel: Class A water operators, Class 3 distribution system operators, Certified backflow prevention technician Original Budget Revised Budget 2010 2011 2011 Budget 2012 Deputy Town Clerk Public Information Officer Purification Insurance premiums Professional Fees/Services Publishing Repair & Maintenance Materials & Supplies Utility Expenditures 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 1,277 1,366 1,579 1,737 11,975 22,480 22,480 21,725 0 1,000 0 500 40,386 78,200 73,200 64,650 132,235 187,075 145,510 158,175 111,672 132,500 129,710 139,496 297,545 422,621 372,479 386,283 Distribution Future vehicle replacement 39,600 42,450 42,450 35,499 listed below under Repairs & Maintenance section Insurance premiums 2,682 2,870 5,874 6,461 Professional Fees/Services 0 1,500 1,500 1,530 Rentals/leases 9,713 9,713 9,713 9,713 Repair & Maintenance 163,800 191,850 184,850 176,049 Materials & Supplies 30,939 75,098 48,620 36,424 Job Performance Expenditures 844 7,975 7,975 2,300 Utility Expenditures 21,815 27,750 29,760 33,481 Promotions 3,211 500 500 0 Over/short inventory (1,522) 0 0 0 Customer accounts Insurance premiums 746 798 798 774 Professional Fees/services 34,000 34,000 34,000 34,000 Materials & Supplies 142,030 113,975 114,550 102,551 Uncollectible Accounts 6,733 6,000 3,000 3,000 Administration & General Engineering 104,500 52,500 52,500 0 listed below under Professional Fees/Services section Insurance premiums 21,601 23,767 23,767 20,279 Professional Fees/Services 182,985 107,641 109,496 93,435 Publishing 1,573 3,300 2,000 0 Rentals/leases 48,859 48,401 48,401 48,401 Repair & Maintenance 10,635 39,022 29,022 34,718 Materials & Supplies 3,213 6,200 5,288 6,800 Job Performance Expenditures 29,223 50,930 44,630 46,205 Utilities 0 65 65 65 Other Payment in Lieu of Tax (2.5% Urban Revenue) 49,164 48,353 49,483 51,569 Franchise Fee (3.0% Urban Revenue) 58,997 58,024 59,379 61,883 231,482 317,256 288,792 267,958 Transfers General Fund (4.0% of sales, less bulk water) Debt Service 1990 Series A Colorado Water Resources, 4.85% Final payment made in 2010 1997E Series A Colorado Water Resources, 4.75% Final payment to be made in 2011 2008 Series A Colorado Water Resources, $5.494m, 3.94% Final maturity2028 183,509 154,773 152,348 140,325 406,250 385,703 371,531 363,355 115,307 116,265 119,317 120,493 Week 3 - Page 35 of 48 Water Fund Enterprise Fund, #503 Town of Estes Park - 2012 Budget SCOPE OF SERVICES Services: Order/purchase/lease water, contract review, easements, planning and forecasting, augmentation plan, watershed management report to River Commissioner, produce water for public, water plant and distribution system maintenance, maintain water mains and fire hydrants, customer billing, meter maintenance, maintain backflow prevention program, troubleshoot customer P51 and volume problems, locate water mains and service lines, maintain system maps Records management: CDOH reports, EPA reports, operations and historical data State required personnel: Class A water operators, Class 3 distribution system operators, Certified backflow prevention technician Original Budget Revised Budget 2010 2011 2011 Budget 2012 Principal Interest Capital Building remodeling Data processing equipment Communication equipment Lab equipment Purification equipment Tools Water system Total capital 385,233 125,555 510,788 289,859 139,971 429,830 292,209 139,617 431,826 261,098 147,334 408,432 260,858 142,000 1,023,422 83,500 0 0 18,000 24,000 O 15,000 15,000 19,000 O 5,000 0 8,500 O 89,000 89,000 26,000 O 0 0 7,000 39,564 235,000 235,000 318,000 300,442 486,000 1,380,422 486,000 'Water vehicle 90310 i'02 Ford 350 4x4} scheduled far replacement in Vehicle Replacement Fund in 2012, valued at 550,000. Week 3 - Page 36 of 48 Town of Estes Park Detail budget information Water 503-6200-530 Purification 2011 orig 2012 Account Account Name Budget Budget Number Justification 1,366 1,737 21-02 Liability Insurance Premiums 1,366 1,737 22,480 21,725 22-14 Lab testing Professional Fees/Services 22,480 21,725 Publishing 1,000 500 23-01 Publications fees 32,000 25-02 Buildings 7,000 22,000 25-02 Pond discharge/sludge press/haul 22,000 8,000 25-02 General maintenance and repair 3,000 0 25-02 Chlorine room monitoring 150 150 25-05 Machinery/tools 14,000 7,800 25-08 Laboratory 2,050 1,200 25-23 Pump treatment 13,000 10,500 25-26 Storage tank (cleaning/panel replacements) 17,000 15,000 25-98 Maintenance/sample stations Repair and Maintenance 78,200 64,650 225 225 26-01 Office Supplies 3,100 1,900 26-02 Postage 3,100 3,300 26-03 Printing/forms 300 300 26-05 Janitorial supplies 650 650 26-06 Small tools 2,850 2,850 26-07 Small hardware 150,000 105,000 26-09 Chemical 22,850 22,950 26-14 Laboratory 4,000 21,000 26-40 Process Analyzer replacement Materials and Supplies 187,075 158,175 4,900 6,000 28-01 Telephone 25,000 25,500 28-02 Natural Gas 60,000 60,996 28-03 Electrical 37,500 41,100 28-05 Sewer 5,100 5,900 28-11 Propane gas Utility Expenditures 132,500 139,496 Total Operations & Maintenance Costs 422,621 386,283 Week 3 - Page 37 of 48 Town of Estes Park Detail budget information Water 503-6300-540 Distribution 2011 orig 2012 Account Account Name Budget Budget Number Justification 0 2,721 21-01 Property 2,870 3,740 21-02 Liability Insurance Premiums 2,870 6,461 1,500 1,530 22-26 Insurance claims Professional Fees/Services 1,500 1,530 Rentals 9,713 9,713 24-01 Real property 9,000 8,500 25-01 Maintenance contracts 14,000 8,000 25-02 Buildings 59,500 55,000 25-04 Vehicle Equipment 550 550 25-05 Machinery/tools 1,000 950 25-06 Meters 47,500 25-21 Water system 47,500 47,500 25-21 Maintenance 500 0 25-22 Water hydrant 2,500 5,200 25-23 Pumps 2,500 2,500 25-34 Customer Service lines 42,450 35,499 25-44 Future vehicle purchase 12,350 12,350 25-98 Maintenance/safety block inspection Repair and Maintenance 191,850 176,049 5,600 2,999 26-01 Office Supplies 200 200 26-04 Freight/shipping 300 300 26-05 Janitorial supplies 16,450 11,500 26-06 Small tools 1,750 1,800 26-07 Small hardware 2,400 2,400 26-08 Lumber/paint 325 325 26-13 Medical 600 600 26-17 Catering/special circumstances 500 800 26-23 Furniture/fixtures 1,473 800 26-25 Energy efficiency 8,000 2,000 26-32 Data processing software 7,300 26-33 Data processing equipment 9,600 4,600 CPU notebook (2 @ $2300) 2,700 2,700 CPU repl (desktop) 18,000 0 SCADA machines, MLWTP (2) (Marys Lake Water Treatment Plant) 2,500 2,500 26-42 Office equipment 4,000 4,000 26-46 Communication equipment 700 900 26-48 Shop Equipment Materials and Supplies 75,098 38,424 7,975 2,300 27-01 Personal Safety Equipment Job Performance 7,975 2,300 3,000 8,070 28-01 Telephone 7,100 7,242 28-02 Natural Gas 15,000 15,249 28-03 Electrical Week 3 - Page 38 of 48 Town of Estes Park Detail budget information Water 503-6300-540 Distribution 2011 orig 2012 Account Account Name Budget Budget Number Justification 150 370 28-04 Water 2,500 2,550 28-06 Trash Utility Expenditures 27,750 33,481 Promotion 500 0 29-25 Water conservation promotion Total Operations & Maintenance Costs 317,256 267,958 Week 3 - Page 39 of 48 Town of Estes Park Detail budget information Water 503-6400-550 Customer Accounts 2011 orig 2012 Account Account Name Budget Budget Number Justification 798 774 21-02 Liability Insurance Premiums 798 774 34,000 34,000 22-09 IT Services Professional Fees/Services 34,000 34,000 13,750 13,751 26-02 Postage 10,000 8,000 26-03 Printing/forms 225 800 26-04 Freight/shipping 90,000 80,000 26-34 New meters Materials and Supplies 113,975 102,551 6,000 3,000 29-07 Uncollectible accounts Other Current Expenses 6,000 3,000 Total Operations & Maintenance Costs 154,773 140,325 i Week 3 - Page 40 of 48 Town of Estes Park Detail budget information Water 503-6500-560 Administration and General Account Name insurance Premiums 13,00 Professional Fees/Services Publishing Rentals Repair and Maintenance Materials and Supplies 22,950 2011 orig 2012 Account Budget Budget Number Justification 20,985 17,929 21-01 Property 2,782 2,350 21-02 Liability 23,767 20,279 4,475 5,500 22-01 Auditing 22-02 Engineering 35,000 0 Prospect Pressure Relief Valve (PRV), Grey Fox PRV, Dressed & Center Match 17,500 0 Glacier Creek Flood Plain 0 13,000 GCWTP Water Rights 155 155 22-07 Recording fees 12,000 37,000 22-08 Legal (Base, GCWTP Water Rights) 35,911 35,180 22-09 IT Services 2,000 2,000 22-10 Bank service 600 600 22-98 Other 107,641 93,435 3,300 0 23-01 Publications fees 45,201 45,201 24-02 Real property 3,200 3,200 24-03 Copier lease (shared with L&P} 48,401 48,401 25-01 Maintenance contracts 2,600 2,600 25-01 Copiers 1,000 1,000 25-01 Radio 3,982 4,878 25-01 Telephone (10} 8,000 8,000 25-01 Supervisory Control and Data Acquisition (SCADA) support 2,100 2,100 25-01 HP plotter 2,500 2,500 25-01 Laboratory Information Mgt System (LIMS) 4,200 D 25-01 Economic and Social Research Institute (ERSI) modeling software license 14,000 13,000 25-01 Zenotrac 24/7 support 640 640 25-01 Tokay software agreement 39,022 34,718 1,700 1,700 26-01 Office Supplies 1,000 1,000 26-02 Postage 1,000 1,000 26-03 Printing/forms 0 900 26-13 Medical - CDL physicals 1,500 1,200 26-17 Catering/special circumstances 1,000 1,000 26-42 Office equipment 6,200 6,800 8,000 8,800 27-02 Uniform allowance 27-04 Education/training 1,200 1,200 27-04 Lab Classes 3,700 0 27-04 American Water Works Assoc. (AWWA) - out of state Week3-Page41 of48 Town of Estes Park Detail budget information Water 503-6500-560 Administration and General 2011 orig 2012 Account Account Name Budget Budget Number Justification 0 4,000 27-04 Membrane users conference (out of state) 2,000 0 27-04 Pump classes 1,100 1,100 27-04 Cross connections classes 500 500 27-04 License renewal fees 4,300 4,300 27-04 Standard/advanced water 3,500 3,500 27-04 Distribution training 1,000 1,000 27-04 Misc seminars 1,300 1,100 27-04 AWWA collateral 300 300 27-04 Cross Connection manuals 3,600 1,950 27-04 Motorola Supervisory Control and Data Acquisition (MOSCAD) - in state 3,700 4,000 27-04 MOSCAD out of State 12,825 27-05 Membership dues/subscriptions 2,300 1,500 27-05 AWWA research foundation 1,000 800 27-05 AWWA individuals 450 450 27-05 AWWA standards 1,225 1,225 27-05 Northern Front Range Water Quality Planning Assoc (NFRWQPA) 475 475 27-05 Colo Dept of Public Health & Environment (CDPHE) Discharge permit 2,000 2,000 27-05 Big Thompson Watershed forum 400 350 27-05 Marys Lake HOA 100 100 27-05 Top of Rockies Road Assoc 1,000 1,200 27-05 CDL Physicals/license fees 4,000 3,800 27-05 CDPHE Public Water System fee/lab cert 400 400 27-05 Colorado Rural Water Assoc (CRWA) Northern Colorado Water Conservancy District (NCWCD) 1,200 0 27-05 Endocrine disruptor sampling 250 250 27-05 Larimer fake alarm reduction program 300 275 27-05 American Backflow Prevention Assoc (ABPA) - American Society of Safety Engineers (ASSE) 880 880 27-06 Employee recognition (11 @ $80) 750 750 27-07 Mileage reimbursement Job Performance 50,930 46,205 65 65 28-01 Telephone Utility Expenditures 65 65 48,353 51,569 29-08 PILOTS (Payments in lieu of taxes) 58,024 61,883 29-10 Franchise fees Other Current Expenses 106,377 113,452 Total Operations & Maintenance Costs 385,703 363,355 Week 3 - Page 42 of 48 Town of Estes Park Detail budget information Water 503-7000-580 Capital 2011 orig 2012 Account Account Name Budget Budget Number Justification Marys Lake Water Treatment Facility (MLWTP) 142,000 0 32-22 Expansion/modification 7,500 32-22 Security Equipment 60,000 32-22 Demolition Fall River WTP 16,000 32-22 Crystal Storage/Big Thompson Tank Fencing 24,000 33-33 SCADA Software upgrades 15,000 19,000 33-36 Communication equipment/SCADA programs 5,000 8,500 33-37 DR 5000 Spectrophotometer replacement 33-40 Purification Equipment 29,000 0 33-40 Total Organic Carbon process analyzer 26,000 26,000 33-40 Feeder replacement 14,000 0 33-40 Process TSS analyzer (membrane optimization) 20,000 0 33-40 MLWTP screen housing monorail 0 7,000 33-41 Confined space entry equipment 235,000 0 35-54 Prospect - PRV Install/ Thunder Mtn Pump (PRV = pressure relief valve) 0 272,000 35-54 Virginia Drive water system 0 40,000 35-54 GI5 water system (software/hardware implementation) 0 6,000 35-54 Distribution system leak survey Capital Equipment 486,000 486,000 Week 3 - Page 43 of 48 Catastrophic Loss Fund Internal Service Fund, #605 Town of Estes Park - 2012 Budget PURPOSE * To provide a reserve account in the event that on unforeseen loss would not be covered by the Town's insurance coverages. The Fund also includes the 3% emergency reserve required by the Tabor amendment. * The Catastrophic Loss Fund no longer qualifies as an Internal Service Fund, and has been absorbed into the General Fund in 201I under a restricted line item in Fund Balance. Original Budget Revised Budget Budget 2010 2011 2011 2012 Revenues Investment income $9,080 $0 $0 $0 Total Revenues 9,080 0 0 Expenses Personnel Services 0 0 0 0 Operations & Maintenance 9,719 0 0 0 Total Current Expenses 9,719 0 0 0 Capital 0 0 0 0 Total Expenses 9,719 0 0 0 Increase(decrease)in Fund balance (639) 0 0 0 Repayment of £PHA loan 0 0 0 0 Transfer to Community Reinvestment 0 0 0 0 Beginning Fund balance 1,438,389 0 0 0 Transfer to General Fund to close Fund (1,437,750) 0 0 0 Restricted balance - TABOR calc 0 0 0 0 Restricted balance - EPHA loan 0 0 0 0 Unrestricted Fund Balance 0 0 0 0 Ending Fund Balance SO $0 $0 $0 Budget comments Catastrophic Loss Fund dosed into General Fund 12/31/2010 Week 3 - Page 44 of 48 Medical Insurance Fund Internal Service Fund, #606 Town of Estes Park - 2012 Budget PURPOSE *To provide o Retiree Medical Health Insurance Fund for eligible employees upon retirement until age 65. (Eligible employees must have at least 15 years of service and be at Least 60 years of age at the time of retirement to be eligible to continue (until age 65) coverage under the Town's medical plan.) * The Medical Insurance Fund no longer qualifies as an Internal Service Fund, and was absorbed into the General Fund in 2011. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Revenues Charges for services Investment income Miscellaneous Total Revenues Expenses Personnel Services $0 $0 $0 $0 2,042 0 0 0 5,593 0 0 0 7,635 0 0 0 0 Operations & Maintenance 57,187 0 0 0 Total Current Expenses 57,187 0 0 0 Capital 0 0 0 0 Subtotal 57,187 0 0 0 Rollovers 0 0 0 0 Total Expenses 57,187 0 0 0 in/dec over prior year: -54% -100% -100% #DIV/0! Transfer to General Fund to close Fund 209,937 0 0 0 Increase (decrease) in Fund balance (259,4B9) 0 0 0 Beginning Fund balance 259,489 (0) 0 0 Ending Fund balance ($0) ($0) $0 $0 EXPENSES INCLUDE: 57,187 Post employment insurance benefits 25,486 Other post employment (from Actuarial) (534) Benefit consultant fee for bidding coverage 25,000 Actuarial study (required by GASB 45 for 7,235 post -employment benefits) TOTAL PREMIUMS (Town portion): ACTUAL Medical 1,050,874 Dental 83,585 Vision 18,499 Week 3 - Page 45 of 48 Fire Pension Fund Fiduciary Fund, #709 Town of Estes Park- 2012 Budget PURPOSE To provide a pension to retired volunteer firefighters that have served the Town of Estes Park. This fund was closed in 2010 and pension responsibilities were assumed by the Estes Valley Fire District Pension Board. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Revenues Additions: State: Town: Investment income: Total Revenues Expenses Personnel Services $0 $0 so $0 0 0 0 0 (2,289) 0 0 0 ($2,289) $0 $0 $0 0 0 0 0 Operations & Maintenance 0 0 0 0 Total Current Expenses 0 0 0 0 Capital 0 0 0 0 Total Expenses 0 0 0 0 in/dec over prior year: Distribution/closing of fund to EVFPD (1,243,145) 0 0 0 Excess (deficiency) of revenues over (2,289) 0 0 0 expenditures Beginning Net Asset balance 1,245,434 0 0 0 Ending Net Asset balance $0 $0 $0 $D Week 3 - Page 46 of 48 Police Pension Fund Fiduciary Fund (Closed}, #710 Town of Estes Park - 2012 Budget PURPOSE The Police Pension Fund wass a plan that was formerly offered to the Town of Estes Pares law enforcement personnel. The plan was closed to new enrollees in 1988, and a 401(a) defined contribution plan was offered. Budget Revised Budget 2010 2011 2011 Budget 2012 Revenues Additions: State: Town: Investment income: Total Revenues so $0 $0 $0 3,465 2,640 2,305 0 0 0 0 0 $3,465 $2,640 $2,305 $0 Expenses Personnel Services 0 0 0 0 Operations & Maintenance (benefit payment) 3,465 2,640 2,640 0 Total Current Expenses 3,465 2,640 2,640 0 Capital 0 0 0 0 Total Expenses 3,465 2,690 2,640 0 Excess (deficiency) of revenues over 0 0 (335) 0 expenditures Other financing sources (transfers in) 0 0 0 0 Other financing uses (transfers out) 0 0 0 0 ncrease {decrease) in fund balance 0 0 (335) 0 Beginning Net Asset balance Ending Net Asset balance 335 335 335 0 $335 $335 $0 $ The Town administers the single employer Police Defined Benefit Pension Plan. The only surving participant passed away in 2010, thus causing the Fund to cease. The monthly benefit was $214. Expenses Current benefit payment Actuarial study 2,640 2,640 2,640 0 0 0 0 0 Week 3 - Page 47 of 48 Theater Fund (formerly known as Friends of Stanley Hall Fund) Fiduciary Fund, #716 Town of Estes Park - 2012 Budget PURPOSE The Friends of Stanley Hall donated funds to the Town of Estes Park for the purpose of construction of a performing arts facility. if construction of the facility is not feasible, by 12/31/2011 the funds are to be donated a non-profit organization dedicated to the support of the performing arts. if construction is deemed feasible, Friends of Stanley Hall has 8 additional years to use funds. Original Budget Revised Budget 2010 2011 2011 Budget 2012 Revenues Investment income Total Revenues Expenses Personnel Services Operations & Maintenance Total Current Expenses Capital $691 $600 $600 $600 $691 $600 $600 $600 0 0 0 0 8 21,000 1,000 1,000 21,000 1,000 1,000 0 0 0 0 Total Expenses 8 21,000 1,000 1,000 in/dec over prior year: -77% 59900% 12400% 0% Increase {decrease) in Fund balance Beginning Fund balance Ending Fund balance 683 (20,400) (400) (400) 456,096 456,779 456,779 456,379 $456,779 $436,379 $456,379 $455,979 Budget comments 2010 2011 2011 2012 Operations & Maintenance Legal 1,000 1,000 0 0 Other professional fees 7,500 7,500 1,000 1,000 Publication fees 1,000 1,000 0 0 Materials & supplies 11,500 11,500 0 0 Postage 0 0 0 0 Week 3 - Page 48 of 48