Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
PACKET Town Board Study Session Budget #3 2012-10-19
2013 BUDTGOEWTNSTBUODAYRSDESSIONS Friday, Elktober 19, 2012 Meeting #3: 8:00 a.m. to 12:00 p.m. Town Board Room Presentation of the following funds: Special Revenue Funds ■ Community Services - Visitor Center - Transportation - Senior Center - Special Events - Museum - Facilities/Marketing - Conference Center Enterprise Funds ■ Utilities - Light and Power - Water Fiduciary Funds ■ Theater General Fund Transportation(#101-5600) Town of Estes Park-2013 Budget SCOPE OF SERVICES Seasonal shuttle service for 4 routes.Special charters as needed. Original Budget Revised Budget Budget L. 2011 2012 2012 2013 Expenses - Personnel Services $0 $0 $0 $0 Operations&Maintenance 221,164 259,772 261,598 0 Total Current Expenses 221,164 259,772 261,598 0 Capital 0 0 0 0 Total Expenses $221,164 $259,772 $261,598 $0 inc/dec over prior year 58% 17% 1% -100% Rollovers(included above) 0 0 0 0 Personnel Levels none Operations&Maintenance Professional services/fees 216,296 253,872 253,872 0 Materials and supplies 4,868 5,900 7,380 0 Job performance expenses 0 0 346 0 221,164 259,772 261,598 0 Capital none *department merged with 222-2600 in 2013. Monies to fund 101-5600 appear in 101-9000(transfer). 1 Town of Estes Park Detail budget information Transportation 101-5600-456 Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Details 22-60 Transportation fees 172,172 172,172 0 22-60 Base(4 busses) 0 0 0 22-60 Fairgrounds shuttle 26,800 26,800 0 22-60 Additional hours 7,500 7,500 0 22-60 Additional fuel 33,000 33,000 0 22-60 Lease buses 1,500 1,500 0 22-60 Mileage overages 2,700 2,700 0 22-60 Lettering 1,000 1,000 0 22-60 Animal logos 1,200 0 0 22-60 Ambassador training(from 222-2600) 2,500 0 0 22-60 Conf Ctr(moved from 222-2800) 5,500 9,200 0 22-60 Spec charters(scotfest/elkfest/xmas) Professional Fees/Services 253,872 253,872 0 2,100 2,100 0 26-01 Office Supplies 3,800 5,280 0 26-52 Traffic signs Materials and Supplies 5,900 7,380 0 0 247 0 27-05 Dues/subscriptions 0 99 0 27-07 Mileage reimbursement job Performance Expenses 0 346 0 Total Operations& Maintenance Costs 259,772 261,598 0 Capital Equipment 0 0 0 2 ACTIVITY CHANGES IN COMMUNITY SERVICES FUND(FUND#222) Budget Net 2012 2013 Change Comments about Department/category Investment Income $1,500 $1,500 $0 Visitors Center transportation moved from General Fund 101-5600 Revenues 42,100 39,500 transportation increased from$262k to$344k($82k) Expenses 371,038 799,533 Shuttle coordinator added (328,938) (760,033) (431,095) Marketing/Sales Revenues 50,000 0 moved to General Fund 101-1300(Executive) Expenses 241,979 0 (191,979) 0 191,979 Senior Center Revenues decreased$4k Revenues 64,702 60,797 Senior Ctr Coordinator increased from 0.5 to 1.0(full-time) Expenses 229,336 284,060 O&M up$22k:IT$6k,Sr Fair expo$4k,food contract$6k (164,634) (223,263) (58,629) Events Revenues 599,945 598,616 Secretary added for Coordinator(Bo) Expenses 1,120,718 1,180,140 O&M up$10k:IT$6k,VRF$7k (520,773) (581,524) (60,751) Museum Revenues flat Revenues 12,760 12,400 Payroll flat Expenses 250,168 263,719 O&M up$13k(16%):IT$10k,brochure$2.5k (237,408) (251,319) (13,911) Conference Center Revenues 24,000 0 moved to General Fund 101-1700(Buildings) Expenses 115,856 0 (91,856) 0 91,856 Net (1,534,088) (1,814,639) (280,551) Transfer out: (18,723) 0 18,723 to seed Medical Fund in 2012 Transfer in: 1,350,000 1,900,000 550,000 to get fund balance up to 5%from 3%($85,361) Net fund balance ($202,811) $85,361 $288,172 change: 3 COMMUNITY SERVICES FUND Special Revenue Fund,#222 SUMMARY Town of Estes Park-2013 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 became 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 2011 2012 2012 2013 REVENUES BY DEPARTMENT Interest income $1,301 $1,500 $1,500 $1,500 Visitor Center(2600) 79,891 42,100 42,100 39,500 Facilities Sales&Marketing(2800) 1,461 3,000 50,000 0 LMD(2900) 483,019 0 0 0 Senior Center(5304) 72,809 81,177 64,702 60,797 Events(5500) 581,715 601,451 599,945 598,616 Museum(5700) 21,677 21,050 12,760 12,400 Conference Center(5800) 24,114 24,000 24,000 0 Total Revenues 1,265,988 774,278 795,007 712,813 Expenditures Personnel Salaries 1,104,901 774,258 857,402 734,263 Benefits 410,368 288,001 284,421 332,660 1,515,269 1,062,259 1,141,823 1,066,923 Operations&Maintenance 1,131,757 1,136,868 1,181,655 1,460,529 Total Current Expenses 2,647,026 2,199,127 2,323,478 2,527,452 Capital 16,854 30,000 5,617 0 Subtotal 2,663,880 2,229,127 2,329,095 2,527,452 Rollovers 0 0 0 0 Total Expenditures 2,663,880 2,229,127 2,329,095 2,527,452 inc/dec over prior year -16% 4% 9% Excess(deficiency)of revenues over (1,397,892) (1,454,849) (1,534,088) (1,814,639) expenditures Other financing sources(transfers in-General) 1,445,000 1,350,000 1,350,000 1,900,000 Other financing uses(transfers out)* 0 18,723 18,723 0 (*Medical Insurance Fund) Increase(decrease)in fund balance 47,108 (123,572) (202,811) 85,361 Beginning Fund balance 308,139 355,247 231,675 28,864 CAFR adjustment 0 0 0 0 Ending Fund balance $355,247 $231,675 $28,864 $114,225 Fund balance% 13% 10% 1% 5% 4 COMMUNITY SERVICES FUND Special Revenue Fund,#222-2000 Advertising(to Local Marketing District) Town of Estes Park-2013 Budget SCOPE OF SERVICES Original Budget Revised Budget Budget 2011 2012 2012 2013 Revenues Investment income $1,299 $1,500 $1,500 $1,500 Miscellaneous 2 0 0 0 Total Revenues 1,301 1,500 1,500 1,500 Expenditures Personnel 0 0 0 0 Operations&Maintenance 0 0 0 0 Capital 0 0 0 0 Total Expenditures $0 $0 $0 $0 inc/dec over prior year 0% 100% 200% Personnel none Operations&Maintenance none Capital none *Advertising costs assumed by the Local Marketing District-2010 COMMUNITY SERVICES FUND Special Revenue Fund,#222-2600 Visitor Center Town of Estes Park-2013 Budget SCOPE OF SERVICES Assist walk-in visitors and callers seeking information about Estes Park and Rocky Mountain National Park. 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 Budget 2011 2012 2012 2013 Revenues Charges for services(retail sales) $34,414 $37,500 $37,500 $39,500 Current(rental) 26,496 0 0 0 Miscellaneous 18,981 4,600 4,600 0 Total Revenues 79,891 42,100 42,100 39,500 Expenditures Personnel Salaries 155,926 155,354 173,760 201,916 Benefits 56,183 55,788 56,450 89,212 212,110 211,142 230,210 291,128 Operations&Maintenance 129,650 136,766 135,211 508,405 Capital 0 0 5,617 0 Total Expenditures $341,760 $347,908 $371,038 $799,533 inc/dec over prior year 2% 7% 115% 211 O 2012 R 2012 2013 Revenues 79,891 42,100 42,100 39,500 Retail sales 34,414 37,500 37,500 39,500 Rent-LMD(moved from 101-1700) 26,496 0 0 0 Reimbursement for 1/2 FIE(LMD agreement) 18,981 0 0 0 Miscellaneous 0 4,600 4,600 0 Personnel Community Services Director 0.20 0.20 0.20 0.00 Coordinator of Community Services 0.00 0.00 0.00 0,04 Visitor Center Manager 1.00 1.00 1.00 1.00 Visitor Services Specialist(2 PT) 2.00 2.00 2.00 2.00 Shuttle Coordinator 0.00 0.00 0.00 1.00 Seasonal Phone Operators (6) 2.10 2,10 2.10 2.10 Total 5.30 5.30 5.30 6.14 Operations&Maintenance Insurance premiums 1,887 2,086 1,665 1,831 Professional fees/services 23,541 22,258 22,158 379,005 Publishing 870 1,175 1,175 1,300 6 COMMUNITY SERVICES FUND Special Revenue Fund,#222-2600 Visitor Center Town of Estes Park-2013 Budget SCOPE OF SERVICES Assist walk-in visitors and callers seeking information about Estes Park and Rocky Mountain National Park. In cooperation with the Local Marketing District,promote Estes Park area events and activities. Create and distribute informational materials. I Coordinate approximately 75 volunteer Ambassadors. Handle limited retail sales of Estes Park-related merchandise. Original Budget Revised Budget Budget 2011 2012 2012 2013 Rentals 3,561 4,200 4,200 3,100 Repair&maintenance 34,789 38,124 37,310 45,910 Materials&supplies 14,358 16,600 17,257 20,225 Job performance expenses 806 781 1,131 3,950 Utilities 25,819 25,205 22,315 25,584 Other current expenditures 24,020 26,687 28,000 27,500 Total Expenditures 129,650 137,116 135,211 508,405 Capital 0 0 0 0 7 Town of Estes Park Detail budget information Visitor Center(222-2600-426-) Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail 197 185 203 21-01 Property 1,889 1,480 1,628 21-02 Liability Insurance Premiums 2,086 1,665 1,831 250 250 250 22-08 Legal 21,108 21,108 34,255 22-09 IT(9 PCs+call In ctr) 500 400 400 22-10 Bank service 300 300 300 22-41 Website Upgrades 0 0 343,700 22-60 Transportation(formerly 101-5600) busses increased from 4 to 5 100 100 100 22-98 Background checks Professional Fees/Services 22,258 22,158 379,005 Publishing 1,175 1,175 1,300 23-01 Publication fees(resort map,emp ads) 1,175 1,175 1,300 Rentals 4,200 4,200 3,100 24-01 Copier lease 4,200 4,200 3,100 33,999 32,400 39,285 25-01 Maintenance contracts (janitorial,window washing,elevator, mats,phones,hvac) 4,000 4,000 6,500 25-02 Buildings,Furniture,Fixtures& Equipment(FF&E) 125 910 125 25-98 Other equip/machinery Repair&Maintenance 38,124 37,310 45,910 2,650 2,650 3,700 26-01 Office Supplies($1,200 from 101-5600) 400 350 350 26-02 Postage 200 100 200 26-03 Printing forms 0 7 25 26-04 Freight/shipping 500 300 400 26-05 Janitorial supplies 700 1,200 1,100 26-15 Exhibit/display(flags,lobby) 1,000 1,000 1,000 26-17 Catering/special circumstances 650 500 650 26-23 FF&E 4,000 4,800 5,500 26-29 Promotional mat printing (counter materials/annual report) 5,800 5,800 2,000 26-33 Data processing equipment 350 550 500 26-46 Communication equipment 350 0 4,800 26-52 Traffic signs(from 101-5600) Materials and Supplies 16,600 17,257 20,225 350 350 1,500 27-04 Education/training 50 145 1,650 27-05 Member dues/subscriptions ($1,450 from 101-5600) 256 336 400 27-06 Employee recognition(5 x$80) 125 300 400 27-07 Mileage reimbursement Job Performance 781 1,131 3,950 5,890 3,000 3,000 28-01 Telephone 2,900 2,900 2,800 28-02 Natural Gas 9,729 9,229 9,936 28-03 Electrical 2,621 2,421 2,982 28-04 Water 1,200 1,800 3,500 28-05 Sewer 850 950 1,250 28-06 Trash disposal 2,015 2,015 2,116 28-15 Telephone lines Utility Expenditures 25,205 22,315 25,584 21,000 22,000 22,000 29-20 Resale purchases 8 Town of Estes Park Detail budget information Visitor Center(222-2600-426-) Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail 5,687 6,000 5,500 29-24 Ambassadors club Other Current Expenses 26,687 28,000 27,500 E Total Operations& Maintenance Costs 137,116 135,211 508,405 0 5,617 0 33-31 Large screen TV for Visitors Center Capital Equipment 0 5,617 0 COMMUNITY SERVICES FUND Special Revenue Fund,#222-2800 Facilities Sales&Marketing Town of Estes Park-2013 Budget SCOPE OF SERVICES Develop and implement comprehensive marketing program for Conference Center and Fairgrounds Promote,recruit,book and facilitate Town-wide groups into the Conference Center and other facilities Coordinate with local marketing officials to promote meeting properties Book,facilitate and support local events and fundraisers at the Conference Center This department moved to 101-1300 in 2013. Original Budget Revised Budget Budget 2011 2012 2012 2013 Revenues Miscellaneous(room night fees) $1,461 $3,000 $50,000 $0 Total Revenues 1,461 3,000 50,000 0 Expenditures Personnel Salaries 90,988 92,151 168,738 0 Benefits 33,222 33,681 48,272 0 124,210 125,832 217,010 0 Operations&Maintenance 16,738 18,912 24,969 0 Capital 0 0 0 0 Total Expenditures $140,947 $144,744 $241,979 $0 incfdec over prior year ##REFI 3% 67% -100% Personnel Group Sales and Marketing Manager 1.00 1.00 1.00 0.00 Community Services Director 0.10 0.10 0,10 0.00 Total 1.10 1.10 1.10 0.00 Operations&Maintenance Insurance premiums 662 728 701 0 Professional fees/services 2,394 2,345 2,345 0 Publishing 6,460 7,750 10,235 0 Materials&supplies 152 750 600 0 Job performance expenses 2,851 2,838 3,088 0 Utilities 2,242 1,500 5,000 0 Other current expenditures 1,976 3,000 3,000 0 Total Expenditures 16,738 18,911 24,969 0 Capital 0 0 0 0 none 10 Town of Estes Park Detail budget information Facilities Sales&Marketing(222-2800-428-) Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail 12 12 0 21-01 Property 716 689 0 21-02 Liability 1 Insurance Premiums 728 701 0 IT Services 2,345 2,345 0 22-09 PCs(1) , 7,500 7,500 0 23-01 Conference Center advertising 250 2,735 0 23-03 Advertising production(web update) Publishing 7,750 10,235 0 500 500 0 26-01 Office Supplies 250 0 0 26-02 Postage ' 0 100 0 26-03 Printing/forms(Conf Ctr photos) Materials and Supplies 750 600 0 0 27-04 Education/training 750 1,500 0 27-04 Conf Ctr,State Tourism conferences(CSAE) 0 27-05 Member dues/subscriptions 1,500 1,500 0 27-05 Cob Society of Assoc Executives International Assoc of Assembly Mgrs Prof Convention Mgrs Assoc 88 88 0 27-06 Employee recognition(1.1 @$80) 500 0 0 27-07 Mileage reimbursement Job Performance 2,838 3,088 0 1,500 5,000 0 28-01 Telephone Utility Expenditures 1,500 5,000 0 3,000 3,000 0 29-22 Marketing expense (trade shows,csae,pcma,promos) 0 0 0 29-35 Shuttle buses for conferences Other Current Expenses 3,000 3,000 0 (moved to 101-5600) Total Operations& Maintenance Costs 18,911 24,969 0 11 COMMUNITY SERVICES FUND Special Revenue Fund,#222-2900 Local Marketing District Assistance Town of Estes Park-2013 Budget SCOPE OF SERVICES Beginning in 2010,Town Board agreed to provide assistance with LMD 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 0 2011 2012 2012 2013 Revenues Miscellaneous(personnel reimbursement) $483,019 $0 $0 $0 Total Revenues 483,019 0 0 0 Expenditures Personnel Salaries 356,709 0 0 0 Benefits 134,524 0 0 0 491,233 0 0 0 Operations&Maintenance 2,631 0 0 0 Capital 0 0 0 0 Total Expenditures $493,864 $0 $0 $0 inc/dec over prior year -100.00% 0.00% 0.00% 2011 2012 O 2012 R 2013 Personnel Communications Manager 1.00 0.00 0.00 0.00 Communications Coordinator 1.00 0.00 0,00 0.00 Stakeholder Sales/Service Manager 1.00 0.00 0.00 0.00 Executive Director 1.00 0.00 0.00 0.00 Seasonal Administrative Assistant 0.50 0.00 0.00 0.00 Mtgs/Conf sales Manager 1.00 0.00 0.00 0.00 Total 5.50 0.00 0.00 0.00 Operations&Maintenance Insurance-liability 1,919 0 0 0 Professional fees 27 0 0 0 Publication fees 684 0 0 0 2,631 0 0 0 Capital none 0 0 0 0 12 COMMUNITY SERVICES FUND Special Revenue Fund,#222-5304 Senior Center Town of Estes Park-2013 Budget SCOPE OF SERVICES Provide on-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 Budget 2011 2012 2012 2013 Revenues Grants/Awards $6,465 $2,475 $6,875 $6,875 Charges for Services 19,234 25,652 25,652 28,772 Miscellaneous 47,109 53,050 32,175 25,150 Total Revenues 72,809 81,177 64,702 60,797 Expenses Personnel Services Salaries 84,591 84,211 84,422 90,603 Benefits 32,889 33,588 30,845 56,656 117,480 117,799 115,267 147,259 Operations&Maintenance 112,281 111,028 114,069 136,801 Total Current Expenses 229,761 228,827 229,336 284,060 Capital 11,705 20,000 0 0 Total Expenses 241,466 248,827 229,336 284,060 inc/dec over prior year Budget comments 2011 2012 2012 2013 Revenues(totals) 72,809 81,177 64,702 60,797 Intergovernmental 6,465 2,475 6,875 6,875 Services 19,234 25,652 25,652 28,772 Current(buildings,fund raisers,United Way) 20,195 19,950 18,800 13,550 Other(SC Inc) 24,911 32,000 12,000 10,500 Coffee fund 1,587 1,000 1,000 1,000 Van usage fees 417 100 375 100 Personnel Services Community Services Director 0.10 0.10 0.10 0.00 Coordinator of Community Services 0.00 0.00 0.00 0.03 Senior Center Manager 1.00 1.00 1.00 1.00 Van Drivers 0.15 0.15 0.15 0.15 Senior Center Coordinator 0.50 0.50 0.50 1.00 Total 1.75 1.75 1.75 2.18 13 COMMUNITY SERVICES FUND Special Revenue Fund,#222-5304 Senior Center Town of Estes Park-2013 Budget SCOPE OF SERVICES Provide on-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 Budget 2011 2012 2012 2013 Operations&Maintenance Insurance premiums 2,581 2,841 2,781 3,059 Professional fees/services 32,691 27,727 27,748 40,279 Publishing 0 2,000 0 0 Repair&maintenance 35,381 31,735 31,735 32,522 Materials&supplies 27,448 31,780 36,549 44,965 Job performance expenses 833 1,365 1,561 2,114 Utilities 13,347 13,580 13,695 13,862 Total Expenditures 112,281 111,028 114,069 136,801 Capital SCINC:deck repair/wood floor/water heater 11,705 0 0 0 SCINC:dining room upgrade 0 20,000 0 0 14 Town of Estes Park Detail budget information Special Revenue Fund,#222-5304-453 Senior Center Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail 1,816 1,767 1,944 21-01 Property 1,025 1,014 1,115 21-02 Liability Insurance Premiums 2,841 2,781 3,059 11,727 11,727 17,919 22-09 IT Services(5 PCs) 16,000 16,000 22,000 22-71 Food service contract O 21 360 22-98 Background checks Professional Services/Fees 27,727 27,748 40,279 Publishing 2,000 0 0 23-01 Meal program promo materials(SCINC) (SCINC-Senior Center Inc funding source) 22,022 25-01 Maintenance contracts 700 700 700 25-01 Carpet cleaning 860 860 860 25-01 Floors 6,360 6,360 6,360 25-01 Janitorial 3,719 3,719 3,939 25-01 Mechanical Services contract 360 360 360 25-01 Small copier contract 1,500 1,500 1,500 25-01 SCINC: Large Copier Contract 2,250 2,250 2,250 25-01 Hydroplant grounds-Janitorial 3,091 3,091 2,858 25-01 Telephone(7) 950 950 650 25-01 Valley Fire Inspections O 0 600 25-01 Pest control 800 800 800 25-01 Entry Mats 350 350 350 25-01 Annual grease trap cleaning 600 600 0 25-01 Window washing 195 195 195 25-01 AED Authority-annual 500 500 0 25-01 Email subscriber list mgmt O 0 600 25-01 Wireless service for senior center 3,500 3,500 4,500 25-02 Buildings(Sr Ctr,Hydro plant) 2,700 2,700 2,700 25-04 Van maintenance 3,300 25-98 Other 2,500 2,500 3,000 25-98 Kitchen equipment 800 800 300 25-98 Meeting room and program equipment Maintenance&repair 31,735 31,735 32,522 1,450 1,450 1,450 26-01 Office Supplies 500 500 600 26-02 Postage 1,000 973 1,000 26-10 Lawn 21,515 26-16 Programs 4,950 4,950 4,950 26-16 Day trip ticketing(participant covered) 6,360 6,360 8,765 26-16 Instructor fees(participant covered) 1,320 1,320 0 26-16 Class trip supplies 1,500 1,500 0 26-16 Membership events 500 500 500 26-16 Guest meals 500 500 500 26-16 Volunteer recognition O 0 4,000 26-16 Senior fair/expo(partnering w/EPMC) 2,800 2,800 2,800 26-16 General programs/supplies O 90 500 26-17 Catering/special circumstances 2,500 26-23 Furniture,Fixtures&Equipment O 261 2,500 26-23 Dining room bussing station 2,400 2,445 3,000 26-33 Data processing 1,000 5,400 5,900 26-96 Coffee,County Grant-Blizzard boxes 8,500 26-97 Operating supplies 3,000 3,000 3,500 26-97 Meals-Wheels(pass through) 1,200 1,200 1,200 26-97 Fundraising supplies 1,500 1,500 2,500 26-97 Food service 1,800 1,800 1,300 26-97 Janitorial Materials and Supplies 31,780 36,549 44,965 15 Town of Estes Park Detail budget information Special Revenue fund,8222-5304-453 Senior Center Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail 1,100 27-04 Education/Training 600 600 600 27-04 Colo Assoc of Senior Ctrs(workshops) 0 0 500 27-04 RFP research for other Snr Centers 125 321 330 27-05 Member Dues/Subscriptions 140 140 184 27-06 Employee Recognition(3 FT,3 PT @$80) 500 500 500 27-07 Mileage Reimbursement Job Performance Expenses 1,365 1,561 2,114 1,020 970 970 28-01 Telephone 2,200 2,200 2,200 28-02 Natural gas 7,000 7,000 7,300 28-03 Electrical energy 560 725 592 28-04 Water 600 600 600 28-05 Sewer 2,200 2,200 2,200 28-06 Trash Disposal Utility Expenditures 13,580 13,695 13,862 Total Operations& Maintenance Costs 111,028 114,069 136,801 y 20,000 0 0 32-22 SCINC:dining rm upgrade Capital Equipment 20,000 0 0 16 COMMUNITY SERVICES FUND Special Revenue Fund,#222-5500 • Events Town of Estes Park-2013 Budget SCOPE OF SERVICES I 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,and 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 Original Budget 2011 2012 2012 2012 Revenues Charges for services $506,427 $522,700 $517,194 $545,365 Current 23,346 26,500 26,500 26,500 Miscellaneous 51,943 52,251 56,251 26,751 Total Revenues 581,715 601,451 599,945 598,616 Expenditures Personnel Salaries 305,149 340,188 314,115 330,463 Benefits 102,412 113,963 98,494 130,839 407,561 454,151 412,609 461,302 Operations&Maintenance 681,432 672,364 708,109 718,838 Capital 0 0 0 0 Total Expenditures $1,088,993 $1,126,515 $1,120,718 $1,180,140 inc/dec over prior year Revenues $581,715 $601,451 $509,945 $598,616 Special Event vendor permits 360 4,500 4,500 6,000 Arena 29,466 26,500 28,000 30,000 Stall 81,487 105,000 95,000 106,000 Camper 15,672 16,500 16,500 16,500 Commercial Vendors 35,236 31,000 35,314 43,000 Storage 2,180 2,500 0 0 Parking 7,849 8,300 10,938 3,765 Food concessions 11,851 10,000 11,000 12,000 Dance(Rodeo Queen) 4,438 4,500 4,500 4,500 Admissions 175,879 170,000 170,000 180,000 Entry Fees(Wool Market animals) 9,295 10,600 10,600 10,600 Workshop fees 30,620 31,800 31,800 30,000 Feed sales 92,692 95,000 85,000 90,000 Retail 9,763 11,000 11,000 11,000 Ticket processing 0 0 7,542 8,000 Buildings 6,696 7,000 7,000 7,000 Real property(Bond/Performance Park rentals) 4,650 4,500 4,500 4,500 17 COMMUNITY SERVICES FUND Special Revenue Fund,#222-5500 Events Town of Estes Park-2013 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,and 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 Original Budget 2011 2012 2012 2012 Donations 12,000 15,000 15,000 15,000 Other 2,271 3,000 3,000 3,000 Sponsorship 40,411 36,000 40,000 9,000 Program sales 150 0 0 0 Platte River Power Authority-No Colorado 8,751 8,751 8,751 8,751 Economic Development(Grant) Personnel Community Services Director 0.46 0.46 0.46 0.00 Coordinator of Community Services 0.00 0.00 0.00 0.90 Fairgrounds/Special Events Manager 1.00 1.00 1.00 0.00 Municipal Services Foreman 1.00 1.00 1.00 1.00 Special Events Coordinator 1.00 1.00 1.00 1.00 Special Events Worker 1.00 1.00 1.00 1.00 Secretary II 0.00 0.00 0.00 1.00 Seasonal workers(FTEs)I 4.06 4.06 4.06 4.06 Total 8.52 8.52 8.52 8.96 'seasonal employee numbers are calculated by taking total budgeted seasonal wages and dividing by FTE units. It does not necessarily reflect the number of actual seasonal workers hired. Operations&Maintenance Insurance premiums 13,065 9,802 14,222 15,346 Professional fees/services 166,105 154,875 157,550 164,569 Publishing 6,248 4,200 9,042 2,350 Rentals 21,855 25,400 29,615 27,900 Real property 7,418 7,768 7,768 8,000 Repair&maintenance 102,178 94,709 92,559 101,893 Materials&supplies 136,552 129,250 146,406 149,440 Job performance expenses 12,935 15,920 15,281 14,003 Utilities 52,375 50,945 51,141 52,502 Other current expenditures 162,701 179,495 184,525 182,835 Total Expenditures 681,432 672,364 708,109 718,838 Capital 0 0 0 0 18 Town of Estes Park Detail budget information Events(222-5500-455-) Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail 5,490 8,515 9,366 21-01 Property I 4,312 5,437 5,980 21-02 Liability O 270 0 21-50 Unemployment Insurance Premiums 9,802 14,222 15,346 300 1,500 1,500 22-08 Legal 11,727 11,727 17,919 22-09 IT(5 computers) 2,200 2,200 1,000 22-10 Bank Service fees 48,000 22-12 Contract Services 11,500 11,500 11,500 Christmas Parade 3,100 3,100 3,100 Jazz Fest 5,100 5,100 5,100 Elk Fest 17,276 19,788 19,788 Wool Market-judges fees 2,000 2,000 2,000 Concert 4,512 4,512 4,512 Performance Park musicians O 2,000 2,000 Other contracted services 95,000 22-20 Entertainment 18,500 15,450 15,450 Jazz Fest-bands 3,300 3,300 3,300 Performance Park 5,500 5,500 5,500 Riverside Plaza/Bond Park singalongs 30,000 30,000 30,000 Fireworks/4th July 1,600 1,600 1,600 Rooftop Rodeo 35,000 35,000 35,000 Scottish Fest/Hotel rooms 150 150 150 Auto Extravaganza O 0 2,000 Miscellaneous 2,000 2,000 2,000 . Hunter Jumper concert 1,000 1,000 1,000 22-26 Insurance damage claims 110 123 150 22-98 Other prof services as needed Professional Fees/Services 154,875 157,550 164,569 300 342 350 23-01 Publication fees 2,000 23-02 Advertising production 500 100 100 Rodeo News O 6,700 0 Rodeo ads 1,200 200 200 Banner Changes 500 200 200 Poster designs 500 500 500 Western Horseman Magazine 1,000 1,000 1,000 Regent Broadcast Radio Assoc 200 0 0 Scoops Ad-Car Show Publishing 4,200 9,042 2,350 20,900 24-01 Equipment 1,400 1,400 1,400 Bobcat 20,000 20,000 18,000 Tents/tables-Wool Market 1,500 1,500 1,500 Panel rental-Wool Market O 1,775 0 Rodeo tent O 2,440 0 Other equipment O 0 4,500 Water truck rental(lease,not purchase) 2,500 2,500 2,500 Sound equipment for facility Rental Equipment 25,400 29,615 27,900 3,700 3,700 3,700 24-02 School Rental-Wool Market 3,423 3,423 3,423 Office/Trailer rental 645 645 877 School rental-Westernaires Real Property 7,768 7,768 8,000 20,915 25-01 Maintenance contracts 2,797 2,797 2,681 Phone(6) 5,889 5,889 6,694 Copier 19 Town of Estes Park Detail budget information Events(222-5500-455-) Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail 420 420 420 Hand-held radios 9,120 9,120 9,120 Sound Systems(downtown/fairgrounds) 1,500 1,500 1,500 Larimer County Work Crews 500 500 500 Email Subscriber List mgt 32,200 25-02 Buildings 17,000 17,000 17,000 General 0 0 4,500 Vinyl fence repair 2,800 2,800 2,800 Roof gazebos and small office 8,000 8,000 7,900 Stall repair/maintenance 1,500 25-03 Furniture/fixtures 2,800 650 1,500 safe,flags 37,000 37,000 33,000 25-04 Vehicle maintenance and fuel 600 600 750 25-05 Machinery/tools 6,283 6,283 13,528 25-44 Future vehicle purchase Repair&Maintenance 94,709 92,559 101,893 3,200 10,000 4,500 26-01 Office Supplies • 1,750 1,000 1,000 26-02 Postage 600 61 1,000 26-03 Printing/forms 500 100 100 26-04 Freight/shipping 5,000 5,000 3,800 26-05 Janitorial 1,000 1,066 1,000 26-06 Small tools • 500 500 500 26-07 Small hardware 9,400 8,160 13,200 26-08 Lumber/Paint 7,000 15,610 12,500 26-10 Lawn 68,000 68,000 70,000 26-12 Feed costs 250 250 200 26-13 Medical 10,000 10,000 10,000 26-15 Exhibit/Display 6,000 26-17 Catering/special circumstances 4,700 4,600 4,600 Wool Market luncheons 1,300 1,400 1,400 Rodeo 4,300 26-18 Trophies/Awards 150 150 150 Rooftop President 650 650 650 Elk Fest Bugling 3,200 3,200 3,500 Wool Market Ribbons O 1,108 0 Additional 400 400 0 Auto Extravaganza 9,340 3,500 3,50D 4,240 26-23 Equipment-Tables(8',picnic) 1,500 1,500 1,500 26-23 New folding tables O 0 2,000 26-23 Power dist.boxes O 0 1,600 26-23 cords for boxes 4,000 4,000 0 26-23 Heaters for events O 0 5,500 26-32 Data processing software(online tix) O 1,819 2,000 26-33 Data Processing Equipment(Mgr) 800 0 0 26-46 Communication equipment 850 384 500 26-48 Shop Equipment 1,000 3,948 4,000 26-52 Traffic Signs Materials and Supplies 129,250 146,406 149,440 500 0 500 27-01 Personal Safety Equipment 1,500 1,326 1,500 27-02 Uniform allowance 6,550 27-04 Education/training 150 150 150 Farm show 500 500 500 Computer training 150 150 150 Stock Show 4,700 4,700 3,000 Prof Rodeo Cowboys Assoc(PRCA)rodeo 750 750 750 Equip training for two FTEs 2,000 2,000 2,000 Footing academy,equip training 4,500 27-05 Member dues/subscriptions 22 22 25 Western Horsemen 20 Town of Estes Park Detail budget information Events(222-5500-455-) Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail 315 315 315 Amer Society for Composers,Authors, and Publishers(ASCAP) 100 100 100 International Festivals/Events Assoc 150 150 150 Alpaca-Llama Show Association ( 25 25 25 Rabbit Sanction fees 500 500 500 State Discharge Permit 100 100 100 Assoc of Rodeo Committees 1,250 1,250 1,250 PRCA 300 300 300 Broadcast Music Inc(BMI) 260 260 260 Society of European Stage Authors and Composers(SESAC) 500 500 500 Alpaca Owners and Breeders Assoc 150 150 150 Cultural Arts Council 275 275 275 League of Equine and Agriculture Ctrs O 35 0 Other 50 50 50 Colo Assoc of Fairs and Shows 500 500 500 Commercial Drivers License(CDL)fees 353 353 353 27-06 Employee recognition(4.41 x$80) 820 820 600 27-07 Mileage reimbursement Job Performance 15,920 15,281 14,003 4,100 4,100 3,500 28-01 Telephone 3,800 3,800 3,900 28-02 Natural Gas 11,009 11,009 11,504 28-03 Electrical Energy 10,036 10,036 10,598 28-04 Water 6,000 6,000 6,000 28-05 Sewer 16,000 16,196 17,000 28-06 Trash Disposal Utility Expenditures 50,945 51,141 52,502 650 0 0 29-12 Parade(Rooftop Rodeo) 3,800 29-13 Dance(rodeo) 3,980 3,980 3,800 Queen's Dance room rental 1,500 1,500 1,500 29-14 Sponsors'dinner 44,400 29-15 Added purse money 40,000 31,800 33,600 Rodeo(upgrade to medium-sized rodeo) 3,000 3,000 3,000 Draft horse show O 0 3,000 Chuckwagon cookoff 5,300 4,840 4,800 Wool Market 2,325 5,555 5,500 29-16 Security/Ticket Labor 3,525 29-17 Volunteers banquets 2,100 2,100 2,100 Rooftop Rodeo 1,000 1,000 1,000 Wool Market 425 425 425 Elk Fest 225 225 0 Auto Show 98,010 29-18 Rodeo 77,900 77,900 79,850 Stock contractor 6,000 6,000 0 Scoreboard 110 110 110 Womens Pro Rodeo Association 1,000 1,000 0 Tickets 2,700 2,700 2,700 Pro Rodeo Judges 1,000 1,000 200 Signs 2,000 2,000 0 Ambulance 200 200 0 Mutton Bustin'prizes 180 180 0 Vet room O 0 750 PRCA approval 500 500 0 Sheep for Mutton Bustin' O 11,000 11,000 Increase in stock fees O 1,800 1,800 Increase in ambulance 1,000 1,610 1,600 Misc 8,200 29-20 Resale purchases 21 Town of Estes Park Detail budget information Events(222-5500-455-) Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail 5,200 5,200 5,200 Wool market 3,000 3,000 3,000 Elk Fest 3,200 900 900 29-25 Promotion(Queens/ponies) 15,000 15,000 17,000 29-30 Manure/bedding Other Current Expenses 179,495 184,525 182,835 Total Operations& Maintenance Costs 672,364 708,109 718,838 Capital 0 0 0 33-31 Bleachers per CIRSA(CRF#204) 0 0 0 34-98 Irrigation forTHUB(CRF#204) 0 0 0 22 COMMUNITY SERVICES FUND Special Revenue Fund,#222-5700 Museum Town of Estes Park-2013 Budget SCOPE OF SERVICES Create permanent exhibits,temporary installations,and off-site installations i Conduct educational programs,provide research assistance,and manage web site. Manage collections of historical objects and related databases. Oversee Fall River Hydroplane and Knoll-Willows properties. Manage approximately 55 volunteers. Offer facility rental and public meeting space. Original Budget Revised Budget Budget 2011 2012 2012 2013 Revenues Grants 0 0 0 0 Charges for Services 3,407 2,150 3,960 3,450 Other • 18,271 18,900 8,800 8,950 Total Revenues $21,677 $21,050 $12,760 $12,400 Expenditures Personnel Salaries 111,538 102,354 116,367 111,281 Benefits 51,138 50,981 50,360 55,953 162,676 153,335 166,727 167,234 Operations&Maintenance 82,610 81,800 83,441 96,485 Capital 5,149 10,000 0 0 Subtotal 250,435 245,135 250,168 263,719 Rollovers 0 0 0 0 Total Expenditures 250,435 245,135 250,168 263,719 inc/dec over prior year 5% 2011 O 2012 R 2012 2013 Personnel Community Services Director 0.14 0.14 0.14 0.00 Coordinator of Community Services 0.00 0.00 0.00 0.03 Curator-Education 1.00 1.00 1.00 1.00 Curator-Exhibits/Manager 1.00 1.00 1.00 1.00 Seasonal grant-funded Digital Technician 0.33 0.00 0.00 0.00 Collection Inventory Assistant(temporary) 0.00 0.00 0.00 0.25 Seasonal(Shared with CVB) 0.00 0.23 0.23 0.23 Total 2.47 2.37 2.37 2.51 Revenues Grants $0 $0 $0 $0 Charges for services 3,407 2,150 3,960 3,450 Miscellaneous(buildings,donations) 7,660 7,600 7,600 7,550 Contributions from"Friends" 10,611 11,300 1,200 1,400 Total revenues 21,677 21,050 12,760 12,400 Operations&Maintenance Insurance premiums 3,979 4,308 4,350 4,786 Professional fees/services 20,525 19,662 20,016 30,071 23 COMMUNITY SERVICES FUND Special Revenue Fund,#222-5700 Museum Town of Estes Park-2013 Budget SCOPE OF SERVICES Create permanent exhibits,temporary installations,and off-site installations Conduct educational programs,provide research assistance,and manage web site. Manage collections of historical objects and related databases. Oversee Foil River Hydroplant and Knoll-Willows properties. Manage approximately 55 volunteers. Offer facility rental and public meeting space. Original Budget Revised Budget Budget 2011 2012 2012 2013 Publishing 2,508 3,345 3,845 5,500 Repair&maintenance 27,928 25,464 25,864 26,457 Materials&supplies 13,043 10,650 11,445 11,250 Job performance expenses 1,993 2,671 2,671 3,071 Utilities 12,632 15,700 15,250 15,350 Total Expenditures 82,610 81,800 83,441 96,485 Capital Buildings remodeling/upgrades Handicap door-front/back(FRIENDS) 5,149 0 0 0 Roof repair(FRIENDS) 0 10,000 0 0 5,149 10,000 0 0 24 Town of Estes Park Detail budget information Special Revenue Fund,#222-5700-457 Museum and Hydroplant Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail I 3,044 2,935 3,229 21-01 Property 1,264 1,415 1,557 21-02 Liability Insurance Premiums 4,308 4,350 4,786 100 440 400 22-08 Legal 18,762 18,762 28,671 22-09 IT Services(8 PCs) 800 814 1,000 22-10 Banks chgs(reimb by FRIENDS) Professional Services/Fees 19,662 20,016 30,071 Publishing 1,050 1,550 3,100 23-01 Publications(brochure-$2,500) 2,295 2,295 2,400 23-02 Advertising 3,345 3,845 5,500 25-01 Maintenance contracts 21,557 2,900 2,900 2,992 Trane mechanical 2,504 2,504 2,505 Telephone system(5) 7,260 7,260 7,260 Cleaning Museum 450 450 450 Pastperfect software mtc 4,000 4,000 4,000 Copier 100 100 100 Fire extinguisher 500 500 500 Enviropest 500 500 500 Enviropest(Hydro) 500 500 500 ADT Security Hydro 2,000 2,000 2,000 Clean hydroplant 500 500 0 Email Subscriber List Mgmt 750 750 750 Entry mats 25-02 Buildings 3,400 2,000 2,000 3,000 General O 0 400 Museum Lights/Ballasts 0 400 0 25-03 Furniture/fixtures 1,500 1,500 1,500 25-04 Van Maintenance O 0 0 25-44 Future vehicle purchase Maintenance&Repair 25,464 25,864 26,457 2,050 2,050 2,050 26-01 Office Supplies 1,800 1,800 1,800 26-02 Postage 100 100 100 26-03 Printing/Forms 100 100 100 26-04 Freight/Shipping 400 400 400 26-05 Janitorial O 0 100 26-06 Small tools 2,300 26-15 Exhibit/Display 250 1,000 0 Stanley Fairground sign 500 500 0 Mace exhibit 800 0 0 Birch Cabin signs 250 250 0 Sweet History exhibit 250 0 0 Horse Power exhibit 250 500 500 Exhibit repairs O 250 0 Sandzen exhibit O 0 300 Exhibit 1 Main Gallery O 0 500 Exhibit 2 NPS building O 0 1,000 Main Gallery Education renovations 2,100 26-16 Programs 500 400 400 Education(Rotary funded) 900 1,000 1,000 Speaker expense 200 250 250 Program supplies 300 350 450 Van trip 1,100 26-17 Catering/special circumstances 550 550 550 Exhibit openings(2) 25 Town of Estes Park Detail budget information Special Revenue Fund,R222-5700-457 Museum and Hydroplant Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail 200 250 350 Volunteer brunch/pot luck 100 100 100 Volunteer recognition 100 100 100 Meeting refreshments O 0 26-23 Furniture/fixtures 700 26-26 Conservation supplies 400 400 500 Archival Folders/Papers 250 250 200 Acquisitions O 315 300 26-32 Data processing software 0 26-33 Data processing equipment O 0 Manager/laptop 400 530 200 External backup drive Materials and Supplies 10,650 11,445 11,250 1,500 27-04 Education/Training 900 900 1,000 Colo-Wyo Assoc of Museums (CWAM) 200 200 300 Front Range educators O 0 0 Assoc of Northern Front Range Museums(curator) 100 100 200 Reference materials 1,200 27-05 Member Dues/Subscriptions 225 225 245 Amer Assoc of Museums 110 110 120 Amer Assoc for State/Local History 60 60 70 Mountain-Plains Museum Assoc 40 40 60 CWAM 100 100 110 Cultural Arts Council of Estes Park 65 65 75 Colorado Historical Society 45 45 55 Estes Park Trail Gazette 55 55 65 Nat Assoc Interpretation 300 300 300 American Society of Composers, Authors and Publishers Broadcast Music Incorporated Society of European Stage Authors and Composers 100 100 100 Domain name registration 171 171 171 27-06 Employee Recognition(2.14 FTE @$80) 200 200 200 27-07 Mileage Reimbursement Job Performance Expenses 2,671 2,671 3,071 1,550 1,100 1,100 28-01 Telephone 3,050 3,050 3,050 28-02 Natural gas 7,400 7,400 7,400 28-03 Electrical energy 1,900 1,900 2,000 28-04 Water 500 500 500 28-05 Sewer 1,300 1,300 1,300 28-06 Trash Disposal Utility Expenditures 15,700 15,250 15,350 Total Operations& Maintenance Costs 81,800 83,441 96,485 33-22 Building remodeling 10,000 0 0 Roof repair(FRIENDS) Capital Equipment 10,000 0 0 (NPS Building,storage shed) 26 COMMUNITY SERVICES FUND Special Revenue Fund,#222-5800 Conference Center Town of Estes Park-2013 Budget ! SCOPE OF SERVICES Operation of conference center. See fl2800 for further details on scope of services. Original Budget Revised Budget Budget 2011 2012 2012 2013 Revenues Misc(Rocky Mtn Park Inn F&B concession) $24,114 $24,000 $24,000 $0 Total Revenues 24,114 24,000 24,000 0 Expenditures Personnel 0 0 0 0 Operations&Maintenance 106,415 115,998 115,856 0 Capital 0 0 0 0 Total Expenditures 106,415 115,998 115,856 0 inc/dec over prior year 9% 9% -100% Personnel none Operations&Maintenance Insurance premiums 7,298 7,298 7,156 0 Rentals 36,250 36,250 36,250 0 Repair&maintenance 15,000 15,000 15,000 0 Utilities 57,450 57,450 57,450 0 Total Expenditures 115,998 115,998 115,856 0 Capital None 0 0 0 0 2' Town of Estes Park Detail budget information , Conference Center(222-5800-458-) Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail 7,298 7,156 0 21-01 Property insurance Premiums 7,298 7,156 0 24,000 24,000 0 24-02 Real property Equipment 12,250 12,250 0 24-04 Land taxes 36,250 36,250 0 15,000 15,000 0 25-02 Buildings(repairs as needed) Repair&Maintenance 15,000 15,000 0 1,000 1,000 0 28-01 Telephone 1,200 1,200 0 28-02 Natural Gas 50,000 50,000 0 28-03 Electrical Energy 3,250 3,250 0 28-04 Water 2,000 2,000 0 28-05 Sewer Utility Expenditures 57,450 57,450 0 Total Operations& Maintenance Costs 115,998 115,856 0 Capital 0 0 0 33-31 , 28 Light&Power Fund Enterprise Fund,#502 Town of Estes Park 2013 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 1 through two substations with electricity provided by Platte River Power Authority. Light&Power maintains over 300 miles of distribution lines and constructs f 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 Budget 2011 2012 2012 2013 OPERATING REVENUES Charges for Services $12,264,062 $13,186,105 $12,429,086 $12,984,166 Other 369,342 200,001 200,001 200,001 Total Operating Revenues 12,633,404 13,386,106 12,629,087 13,184,167 OPERATING EXPENSES Source of Supply 5,695,225 6,413,487 6,062,000 6,005,200 Distribution Personnel 1,296,301 1,303,686 1,310,067 1,395,618 Operations and Maintenance 646,920 717,959 778,622 826,833 Customer Accounts Personnel 486,274 518,446 501,200 542,166 Operations and Maintenance 105,399 120,841 114,934 126,123 Administration/General Personnel 400,718 455,491 464,587 543,567 Operations and Maintenance 1,203,289 1,380,188 1,399,861 1,309,564 Capital 0 1,298,000 1,303,580 1,877,500 Depreciation 799,638 0 0 0 TOTAL OPERATING EXPENSES 10,633,763 12,208,098 11,934,851 12,626,571 change from prior year 5% 21% 15% 16% OPERATING INCOME(LOSS) 1,999,641 1,178,008 694,236 557,596 NON OPERATING REVENUES(EXPENSES) investment income 49,540 35,000 35,000 35,000 Interest expense/Debt service payments (223,389) (449,213) (449,213) (449,719) TOTAL NON-OPERATING REVENUES(EXPENSES) (173,849) (414,213) (414,213) (414,719) NET INCOME(LOSS)BEFORE CAPITAL 1,825,792 763,795 280,023 142,877 CONTRIBUTIONS AND TRANSFERS Transfers Out (1,039,550) (1,150,696) (588,062) (1,316,601) CHANGE IN AVAILABLE FUNDS 786,242 (386,901) (308,039) (1,173,724) Rollover adjustment 0 0 0 0 AVAILABLE FUNDS*,Beginning,as Restated 6,589,712 7,375,954 7,375,954 7,067,915 AVAILABLE FUNDS*,Ending $7,375,954 $6,989,053 $7,067,915 $5,894,191 Rollovers 0 25,352 0 0 *Fund availability is calculated as"unrestricted current assets less inventories less current liabilities",(source:audited financial statements,page 6,for the fiscal year ended Dec.31,2011). Amounts for 2011 ending fund balance are:unrestricted current assets($9,699,740)less current liabilities($1,707,445)less inventories($616,341),for an available ending fund balance of$7,375,954. 2013 revenues forecasted to increase 4.5%per rate increase schedule. $106,005(12/31/2011)of fund balance is in form of Note Receivable from Estes Park Housing Authority,due June 2013. COVERAGE DATA Debt service ratio* 5.24 3.37 3.56 2.85 Bond 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 Light&Power Fund Enterprise Fund,#502 Town of Estes Park 2013 Budget SCOPE OF SERVICES Light&Power provides reliable quality electric power to approximately 10,000 accounts,including Rocky Mountain Notional 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 oll 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 2011 2012 2012 2013 90 days operating coverage* (>1.00) 2.48 2.23 2.42 1.88 *90 day ratio=fund balance/((total expenditures-capital)x.25) Fund balance $7,375,954 $6,989,053 $7,067,915 $5,894,191 (90 day coverage) (2,974,176) (3,127,502) (2,917,137) (3,128,848) Fund balance-90 day coverage ratio $4,401,778 $3,861,551 $4,150,778 $2,765,343 Summary of expenditure types Source of Supply 5,695,225 6,413,487 6,062,000 6,005,200 Personnel 2,183,293 2,277,623 2,275,854 2,481,351 Salaries 1,597,877 1,658,048 1,686,873 1,784,149 Benefits 585,415 619,576 588,981 697,202 Operations and Maintenance 1,955,608 2,218,988 2,293,418 2,262,521 Capital 0 1,298,000 1,303,580 1,877,500 Depreciation 799,638 0 0 0 Debt Service 223,389 449,213 449,213 449,719 Transfers out 1,039,550 1,150,696 588,062 1,316,601 Rollovers 0 0 0 0 11,896,703 13,808,007 12,972,127 14,392,892 Source of Supply Includes PRPA purchased power increase. 5,695,225 6,062,000 6,062,000 6,005,200 Personnel Director of Utilities 0.58 0.58 0.58 0.58 Utilities Superintendent 0.00 0.00 0.00 0,80 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 2.00 2.00 2.00 2.00 Meter Reader 1.00 1.00 1.00 1.00 Secretary II 1.00 0.70 0.70 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.00 0.00 0.00 0.00 Human Resource Generalist 0.26 0.48 0.48 0.48 Payroll/HR Technician 0.26 0.48 0.48 0.48 Utilities Administrator(shops) 0.00 0.00 0.00 0.60 Seasonal GIS specialist 0.00 0.00 0.00 0.50 Finance Officer 0.26 0,26 0.26 0.26 Assistant Finance Officer 0.26 0.26 0.26 0,26 Accountant I 0,26 0.26 0.26 0.26 Accts.Payable/Utility Billing Specialist 0.94 0.94 0.94 0.94 Administrative Clerk II 1.29 1.29 1.29 1,29 Town Administrator 0.48 0.48 0,48 0.48 Deputy Town Administrator 0.48 0.48 0.48 0.48 Town Clerk 0.48 0.48 0.48 0.48 Deputy Town Clerk 0.48 0.48 0.48 0.48 Executive Secretary 0.48 0.48 0.48 0.48 Public Information Officer 0.48 0.48 0.48 0,48 30 Light&Power Fund Enterprise Fund,#502 Town of Estes Park 2013 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 sthrough 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 oll 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 2011 2012 2012 2013 Total 25.29 25.43 25,43 27.33 Operations and Maintenance Distribution Engineering(Loveland IGA)included in Prof fees/services 20,627 25,000 25000 10,000 Insurance Premiums 9,372 10,309 10,166 11,183 Professional fees/services 26,540 57,500 57,750 92,500 Equipment rentals/leases 2,400 2,400 2,400 2,400 Repair&Maintenance 506,464 474,250 512,374 558,750 Materials&Supplies 83,915 142,000 160,768 132,000 Job Performance Expenditures 29,441 31,500 35,164 30,000 Other current expenses (11,212) 646,920 717,959 778,622 826,833 Customer Accounts Insurance Premiums 2,853 3,138 2,969 3,266 Professional fees/services 525 500 250 250 Equipment rentals/leases 949 1,000 3,920 3,920 Repair&Maintenance 8,511 7,676 8,799 8,852 Materials&Supplies 49,813 68,681 62,181 68,900 Job Performance Expenditures 3,538 4,845 1,815 5,935 Uncollectible accounts 39,210 35,000 35,000 35,000 105,399 120,840 114,934 126,123 Administration Future vehicle replacement 140,350 128,751 128,751 119,864 (this item is part of the below information) Insurance Premiums 34,106 37,517 35,656 39,220 Professional fees/services 67,705 89,477 96,017 168,930 Publishing 3,629 3,000 3,000 3,500 Equipment rentals/leases 86,228 89,000 89,000 89,000 Repair&Maintenance 345,716 343,111 356,223 331,669 Materials&Supplies 158,155 272,500 274,298 313,500 Job Performance Expenditures 52,817 54,380 54,464 55,330 Utilities 68,295 79,850 79,850 73,350 Other Interest on deposits 526 1,000 1,000 1,000 Payments in lieu of taxes 170,758 181,524 181,524 8,154 PUC Gross receipt taxes 10,444 11,000 11,000 11,000 Franchise Fees(3%-urban revenue) 204,909 217,829 217,829 214,911 1,203,289 1,380,188 1,399,861 1,309,564 Transfers General Fund(<10%per study session 08/14/12) 1,039,550 1,150,696 550,195 1,266,601 Medical Insurance Fund 0 0 37,867 0 Community Reinvestment Fund(portion of office remodel) 0 0 0 50,000 2012 revised transfer=normal transfer rate,less Catastrophic Loss reimbursement from General Fund($498,287) Debt Service Series 2027,$6.18m,3.875% Bond principal 235,000 245,000 245,000 255,000 Bond interest 223,389 204,213 204,213 194,719 Capital Continuation of software development 0 0 0 50,000 Building/office remodeling 0 75,000 75,000 15,000 Station Equipment 0 20,000 20,000 40,000 31 Light&Power Fund Enterprise Fund,#502 Town of Estes Park 2013 Budget SCOPE OF SERVICES Light&Power provides reliable quality electric power to approximately 10,000 accounts,including Rocky Mountain Notional Pork. 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 Budget 2011 2012 2012 2013 Office Equipment 23,828 13,000 13,000 9,500 Data Processing Equipment 53,417 40,000 40,000 0 Data Processing Equipment-GPS Field 0 0 0 50,000 Transformers 82,565 125,000 125,000 125,000 Tools 0 15,000 15,000 15,000 Other machinery/equipment 0 30,000 30,000 20,000 Street Lights 0 10,000 10,000 20,000 Poles/Towers/Fixtures 0 20,000 25,580 0 New LED lights on Highway 7 0 0 0 60,000 Overhead Lines 170,775 0 0 0 2012 Camp Allenspark Phase 1/II 0 688,000 688,000 688,000 Conductor system upgrades/tree cable 0 112,000 112,000 112,000 Loveland engineering capital upgrades 0 0 0 25,000 Fall River/Big Thompson Double Circuit(re:Cat Loss'12) 0 0 0 498,000 Underground Conductors 464,336 150,000 150,000 150,000 Total Capital 1,298,000 1,303,580 1,877,500 4- *L&P vehicle 93313A('02 Ford Explorer S-Trac)scheduled for replacement in Vehicle Replacement Fund in 2013,valued at$26,500. 32 Town of Estes Park Detail budget information Light and Power 502-6301-540-Distribution Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail 2,721 2,457 2,703 21-01 Property 7,588 7,709 8,480 21-02 Liability Insurance Premiums 10,309 10,166 11,183 25,000 25,000 10,000 22-02 City of Loveland System Engineering(IGA) 0 0 35,000 22-02 GIS Services 15,000 15,000 30,000 22-13 Seasonal GIS 1,500 1,750 1,500 22-14 Lab testing 10,000 10,000 10,000 22-26 Insurance claims 1,000 1,000 1,000 22-30 Land use fees(Forest Service) 5,000 5,000 5,000 22-98 Other engineering as needed Professional Fees/Services 57,500 57,750 92,500 Rentals 2,400 2,400 2,400 24-01 Prospect Mtn access lease 10,000 10,000 5,000 25-01 Shop cleaning 0 1,533 2,500 25-02 Buildings 6,000 6,000 2,500 25-05 Machinery/tools 250 250 250 25-06 Meters 7,500 7,500 5,000 25-07 Transformers-repaint ground mounts 3,000 3,000 3,000 25-08 Transformer oil testing 15,000 15,000 15,000 25-30 Street light maintenance 50,000 63,343 70,000 25-31 Substation per IGA w/PRPA (PRPA-Platte River Power Authority) 300,000 323,248 350,000 25-32 Overhead maintenance/tree trimming 75,000 75,000 100,000 25-33 Underground conduit 3,500 3,500 2,500 25-34 Customer service lines 4,000 4,000 3,000 25-98 Other equipment/machinery Repair and Maintenance 474,250 512,374 558,750 500 500 500 26-01 Office Supplies 1,000 1,000 1,000 26-04 Freight/shipping 1,500 1,500 1,500 26-05 Janitorial supplies 17,000 20,738 17,000 26-06 Small tools/new chain saws 5,000 5,000 5,000 26-07 Small hardware • 5,000 5,000 5,000 26-19 Traffic control 2,000 2,000 2,000 26-20 Electrical 80,000 80,000 70,000 26-34 Meters 30,000 45,030 30,000 26-55 Street light program(new LEDs) Materials and Supplies 142,000 160,768 132,000 30,000 33,664 30,000 27-01 Personal Safety Equipment 1,000 1,000 0 27-03 Vehicle Allowance 500 500 0 27-07 Mileage reimbursement Job Performance 31,500 35,164 30,000 Total Operations& Maintenance Costs 717,959 778,622 826,833 33 Town of Estes Park Detail budget information Light and Power 502-6401-550 Customer Accounts Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail 3,138 2,969 3,266 21-02 Liability Insurance Premiums 3,138 2,969 3,266 500 250 250 22-98 Coding Accuracy Support System Professional Fees/Services 500 250 250 (mailing list verification with USPS) 1,000 1,000 1,000 24-01 Town records disposal 0 2,920 2,920 24-03 Lease-folder/inserter Rentals/leases 1,000 3,920 3,920 25-01 Maintenance contracts 5,730 6,300 6,300 25-01 Minolta copier 1,716 1,759 1,802 25-01 Folder/inserter 0 500 500 25-01 Postage meter mtc 230 240 250 25-01 Letter opener Repair and Maintenance 7,676 8,799 8,852 15,281 15,281 15,000 26-01 Office Supplies 27,500 27,500 28,000 26-02 Postage 12,500 12,500 12,500 26-03 Printing/forms 1,600 1,600 1,600 26-04 Freight/shipping 1,300 1,300 1,300 26-17 Catering/special circumstances 2,000 1,000 2,000 26-23 Furniture/fixtures 3,000 3,000 3,000 26-33 3 desktop replacements 5,500 0 5,500 26-42 Office equipment Materials and Supplies 68,681 62,181 68,900 4,500 1,500 5,620 27-04 Education/training-HUG conferences 225 195 195 27-05 Dues-HUG 120 120 120 27-07 Mileage reimbursement Job Performance 4,845 1,815 5,935 Uncollectible accounts 35,000 35,000 35,000 29-07 Uncollectible accounts Total Operations& Maintenance Costs 120,840 114,934 126,123 I 1 34 Town of Estes Park Detail budget information Light and Power 502-6501-560 Administration/General Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail € 30,943 29,436 32,378 21-01 Property 6,574 6,220 6,842 21-02 Liability Insurance Premiums 37,517 35,656 39,220 11,250 11,250 13,500 22-01 Auditing 10,000 10,000 10,000 22-02 Loveland 1GA system analysis 250 250 250 22-07 Recording fees 5,000 5,000 5,000 22-08 Legal 60,977 60,977 93,180 22-09 IT Services(26 computers) 2,000 2,000 2,000 22-10 Bank Service O 5,000 0 22-33 Data processing O 1,540 0 22-98 Minor professional services O 0 45,000 22-98 Compensation analysis($10)k),Rate Study Professional Fees/Services 89,477 96,017 168,930 Plan($35k) Publishing 3,000 3,000 3,500 23-01 Publications fees 85,000 85,000 85,000 24-02 Real property-rent of Muni Bldg office space 4,000 4,000 4,000 24-03 Copier lease Rentals 89,000 89,000 89,000 74,236 25-01 Maintenance contracts 13,600 13,600 13,600 25-01 Itron handheld reading equipment 6,000 6,000 6,000 25-01 MV-90 Xl support 2,000 2,000 2,000 25-01 Minolta shop copier 5,000 5,000 5,000 25-01 HVAC (heating,ventilation,air-conditioning) 3,000 3,000 3,000 25-01 Milsoft 3,500 3,500 3,500 25-01 ARC FM 22,000 22,000 22,000 25-01 Wonderware SCADA(Supervisory Control and Data Acquisition) 1,800 1,800 1,800 25-01 OCE plotter 20,000 20,000 0 25-01 IT contracting O 0 7,650 25-01 ESRI GIS 8,360 8,360 9,686 25-01 Telephone system(25) O 0 2,000 25-02 Buildings(security cameras) 1,000 1,000 1,000 25-03 Furniture/fixtures(remod eng/shop) 127,500 127,500 130,000 25-04 Vehicle fuel&maintenance 100 100 500 25-05 Machinery/tools 128,751 141,863 123,433 25-44 Future vehicle purchases 500 500 500 25-98 Repair on minor equipment/machinery Repair and Maintenance 343,111 356,223 331,669 15,000 15,000 15,000 26-01 Office Supplies 5,000 5,000 5,000 26-02 Postage 2,000 2,000 2,000 26-03 Printing/forms 500 500 500 26-06 Machinery/tools 2,500 2,500 2,500 26-13 Medical 85,000 85,000 85,000 85,000 26-15 Exhibit/display 3,500 3,500 3,500 26-17 Catering/special circumstances 4,000 4,000 5,000 26-23 Furniture/fixtures 100,000 100,000 100,000 26-25 Energy efficiency program 10,000 10,000 15,000 26-32 Data processing software(Navaline 09) 26-33 Data processing equipment 10,000 10,610 15,000 26-33 Network,Meter(1),LP Shop(2)replacements 20,000 20,000 10,000 26-42 Copier-eng/plotter-GIS(Geographic Info System) 5,000 5,000 5,000 26-43 Heavy Equipment 10,000 11,188 50,000 26-46 Communication equipment(800mh radio Materials and Supplies 272,500 274,298 313,500 conversion) 35 Town of Estes Park Detail budget information Light and Power 502-6501-560 Administration/General Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail 4,500 4,546 5,000 27-02 Uniform allowance 35,400 27-04 Education/training 1,100 1,100 1,100 27-04 Rocky Mtn Electric Assoc(RMEA)meter school 2,500 2,500 2,500 27-04 ITRON(operating system)users conference 1,000 1,000 1,000 27-04 RMEA Fall tech conference 6,400 6,400 6,400 27-04 Mesa Hotline School 1,550 1,550 1,550 27-04 Rocky Mtn Electrical League(RMEL)classes 7,500 7,500 9,500 27-04 Safety training 1,800 1,800 1,800 27-04 Institute of Electrical/Electronic Engineers (IEEE)Conference 1,550 1,550 1,550 27-04 RMEL Spring/Fall conference 5,000 5,000 5,000 27-04 Apprentice training 2,000 2,000 2,000 27-04 Meter foreman training 2,000 2,000 2,000 27-04 Locater training 1,800 1,800 1,000 27-04 Management training 13,000 13,000 12,000 27-05 Membership dues/subscriptions 1,680 1,680 1,680 27-06 Employee recognition 500 500 500 27-07 Mileage reimbursement 500 538 750 27-10 Meal reimbursement-emerg. Job Performance 54,380 54,464 55,330 25,000 25,000 20,000 28-01 Telephone 10,000 10,000 7,500 28-02 Natural Gas 35,000 35,000 36,000 28-03 Electrical 2,500 2,500 2,500 28-04 Water 350 350 350 28-05 Sewer 7,000 7,000 7,000 28-06 Trash disposal Utility Expenditures 79,850 79,850 73,350 1,000 1,000 1,000 29-06 Interest on deposit 181,524 181,524 8,154 29-08 Payments in lieu of taxes(PILOTS) 11,000 11,000 11,000 29-09 Public Utility Customer Protection Division (PUC)gross receipts 217,829 217,829 214,911 29-10 Franchise fees Other current expenses 411,353 411,353 235,065 Total Operations& Maintenance Costs 1,380,188 1,399,861 1,309,564 36 Town of Estes Park Detail budget information Light and Power 502-7001-580 Capital Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail i 7000- 0 0 50,000 37-01 Continuation of software development 15,000 15,000 15,000 32-22 General building 60,000 60,000 0 32-22 New roof on L&P Building 20,000 20,000 0 33-30 SCADA equipment O 0 40,000 33-30 Substation equipment 13,000 13,000 0 33-32 Replace network copier/printer-Finance O 0 9,500 33-32 Office remodel equip,shared scanner 40,000 40,000 0 33-33 Data processing equipment(ARCSDE GIS) collector 0 0 50,000 33-33 GPS Field Assets 125,000 125,000 125,000 33-35 Transformers 15,000 15,000 15,000 33-41 Tools 10,000 10,000 0 33-98 Subdivision lighting,poles,fixtures 20,000 20,000 20,000 34-98 IR sensor,inspection and maintenance 10,000 10,000 20,000 35-55 Street lights/New Subdiv lighting,poles 20,000 25,580 0 35-56 Poles/towers/fixtures O 0 60,000 35-56 New LED lights on Highway 7 35-57 Overhead lines 688,000 688,000 0 35-57 2012 Camp Allenspark Phase I O 0 688,000 35-57 2012 Camp Allenspark Phase II 112,000 112,000 112,000 35-57 Conductor sys upgrade proj,tree cable O 0 25,000 35-57 Loveland Engineering Capital upgrades 0 0 498,000 35-58 Fall River/Big Thompson Double Circuit (re:Cat Loss distribution'12) 150,000 150,000 150,000 35-58 Underground conductor Capital Equipment 1,298,000 1,303,580 1,877,500 I 37 Water Fund Enterprise Fund,#503 Town of Estes Park-2013 Budget SCOPE OF SERVICES The Water Department treats and delivers over 500 million gallons of clean drinking water per year.The Water Department is responsible for resource management of water which includes watershed management,demand forecasting,augmentation planning,treating and distributing water for public use. The Water Department administers the backflow prevention program and maintains all fire hydrants and water meters. The Water Department meets all regulatory reporting requirements of the Colorado Department of Public Health and Environment(CDPH&E),EPA and the State River Commissioner. Water Department personnel are required to be state certified and licensed as Class A plant operators,Class 2 distribution system operators and certified backflow prevention technicians. Original Budget Revised Budget Budget 2011 2012 2012 2013 OPERATING REVENUES Charges for Services $3,142,564 $3,334,323 $3,867,280 $4,115,363 Miscellaneous 43,920 12,289 42,906 27,912 Total Revenues 3,186,484 3,346,612 3,910,186 4,143,275 OPERATING EXPENSES Source of Supply 151,414 164,461 164,461 167,461 Purification Personnel 246,719 275,972 263,263 289,243 Operations and Maintenance 322,491 386,283 387,789 536,776 Distribution Personnel 711,478 755,230 748,748 825,041 Operations and Maintenance 208,923 273,959 275,528 368,693 Customer Accounts Personnel 115,540 115,091 104,483 119,792 Operations and Maintenance 143,252 140,325 142,304 142,428 Administration/General Personnel 144,203 164,804 167,028 211,677 Operations and Maintenance 339,312 325,354 337,227 358,457 Capital 0 518,000 598,425 639,300 Depreciation 689,242 0 0 TOTAL OPERATING EXPENSES 3,072,574 3,119,479 3,189,256 3,658,868 change from prior year -1% 2% 4% 15% OPERATING INCOME(LOSS) 113,910 227,133 720,930 484,407 NON OPERATING REVENUES(EXPENSES) Investment income 13,588 17,000 17,000 17,000 Intergovernmental 22,628 0 0 0 Debt service payments/interest expense (140,006) (405,786) (405,786) (407,204) Interest expense(loans) incl above incl above incl above incl above TOTAL NON OPERATING REVENUES(EXPENSES) (103,790) (388,786) (388,786) (390,204) NET INCOME(LOSS)BEFORE TRANSFERS 10,120 (161,653) 332,144 94,203 Capital Contributions(Tap fees) 305,871 0 0 0 Transfers In(General Fund/Catatrophic Loss Fund reimbursement) 0 0 114,873 0 Transfers Out (121,316) (145,542) (25,049) (214,953) CHANGE IN AVAILABLE FUNDS 194,675 (307,195) 421,968 (120,750) Rollover adjustment 0 0 0 0 AVAILABLE FUNDS*,Beginning,as Restated 2,802,498 2,997,173 2,997,173 3,419,141 AVAILABLE FUNDS*,Ending 2,997,173 2,689,978 3,419,141 3,298,391 Rollovers 0 23,673 0 0 *Fund availability is calculated as"unrestricted current assets less inventories less current liabilities",(source: audited financial statements,page 6,for the fiscal year statements,page 6 for the year ended Dec.31,2011). Amounts for the 2011 ending balance is:unrestricted current assets($3,622,304)less current liabilities($507,163)less inventories($117,967)for a fund balance of$2,997,174. 38 Water Fund Enterprise Fund,#503 Town of Estes Park-2013 Budget SCOPE OF SERVICES The Water Department treats and delivers over 500 million gallons of clean drinking water per year.The Water Department is responsible for resource management of water which includes watershed management,demand forecasting,augmentation planning,treating and distributing water for public use. The Water Department administers the backflow prevention program and maintains all fire hydrants and water meters. The Water Department meets all regulatory reporting requirements of the Colorado Deportment of Public Health and Environment(CDPH&E),EPA and the State River Commissioner. Water Department personnel are required to be state certified and licensed as Class A plant operators,Class 2 distribution system operators and certified backflow prevention technicians. Original Budget Revised Budget Budget 2011 2012 2012 2013 Revenues forecasted to increase 5.6%due to rate increase. $78,405(12/31/2011)of fund balance is in form of Note Receivable from Estes Park Housing Authority,due lune 2013. COVERAGE DATA Debt service coverage ratio* 5.22 1.63 3.23 2.27 Bond covenant requirements 1.10 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) 3.90 4.14 5,28 4.37 *90 day ratio=fund balance/((total expenditures-capital)x.25) Fund balance 2,997,173 2,689,978 3,419,141 3,298,391 (90 day coverage) (768,143) (650,370) (647,708) (754,892) Fund balance-90 day coverage amount 2,229,030 2,039,609 2,771,434 2,543,499 Summary of expenditure types Source of Supply 151,414 164,461 164,461 167,461 Personnel 1,217,941 1,311,097 1,283,522 1,445,753 Salaries 871,472 959,441 926,885 1,006,664 Benefits 346,469 381,656 356,637 439,089 Operations and Maintenance 1,013,978 1,125,921 1,142,848 1,406,354 Capital 0 518,000 598,425 639,300 Depreciation 689,242 0 0 0 Debt Service 140,006 405,786 405,786 407,204 Transfers out 121,316 145,542 25,049 214,953 Rollovers 0 0 0 0 3,333,896 3,670,807 3,620,091 4,281,025 Personnel Director of Utilities 0.37 0.37 0.37 0.37 Utilities Superintendent 0.00 0.00 0.00 0.20 Water Superintendent 1.00 1.00 1.00 1.00 Assistant Water Superintendent(Operations Manager'13) 1.00 1.00 1.00 1.00 Plant Manager 0.00 0.00 0.00 1.00 Water Plant Operators 3.00 4.00 4.00 4.00 Water Quality Manager(Laboratory Supervisor'13) 1.00 0.00 0.00 0.00 Lab Technician 1.00 1.00 1.00 1.00 Municipal Service Worker 3.00 3.00 3.00 3.00 Cross Connection Control Sp. 1.00 1.00 1.00 1.00 Secretary II 0.15 0.30 0.30 0.30 Electrical Engineer 0.20 0.20 0.20 0.20 Secretary III 0.15 0.00 0.00 0.00 Human Resource Generalist 0.11 0.14 0.14 0.14 Utilities Administrator(shops) 0.00 0.00 0.00 0.40 Payroll Technician 0.14 0.14 0.14 0.14 Finance Officer 0.16 0.14 0.14 0,14 Assistant Finance Officer 0.16 0.14 0.14 0.14 Accountant I 0.16 0.14 0.14 0.14 Accounts Pay/Util bill Spec 0.46 0.46 0.46 0.46 Administrative Clerk 0.62 0.61 0.61 0.61 Town Administrator 0.14 0.14 0.14 0.14 3 Water Fund Enterprise Fund,#503 Town of Estes Park-2013 Budget SCOPE OF SERVICES The Water Department treats and delivers over 500 million gallons of clean drinking water per year.The Water Department is responsible for resource management of water which includes watershed management,demand forecasting,augmentation planning,treating and distributing water for public use. The Water Department administers the backflow prevention program and maintains all fire hydrants and water meters. The Water Department meets all regulatory reporting requirements of the Colorado Department of Public Health and Environment(CDPH&E),EPA and the State River Commissioner. Water Department personnel are required to be state certified and licensed as Class A plant operators,Class 2 distribution system operators and certified backfiow prevention technicians. Original Budget Revised Budget Budget 2011 2012 2012 2013 Deputy Town Administrator 0.14 0.14 0.14 0.14 Town Clerk 0.14 0.14 0.14 0.14 Deputy Town Clerk 0.14 0.14 0.14 0.14 Executive Secretary 0.14 0.14 0.14 0.14 Public Information Officer 0.14 0.14 0.14 0.14 Total 14.52 14.48 14.48 16.08 Purification insurance premiums 1,579 1,737 1,560 1,716 Professional Fees/Services 14,069 21,725 21,725 25,230 Publishing 0 500 500 500 Repair&Maintenance 57,867 64,650 66,333 64,800 Materials&Supplies 129,809 158,175 158,175 304,100 Utility Expenditures 119,168 139,496 139,496 140,430 322,491 386,283 387,789 536,776 Distribution Future vehicle replacement 42,450 35,499 35,499 45,609 listed below under Repairs&Maintenance section Insurance premiums 5,874 6,461 6,688 7,355 Professional Fees/Services 4,311 1,530 1,530 26,500 Rentals/leases 9,713 9,713 9,713 9,713 Repair&Maintenance 152,467 182,049 182,049 192,159 Materials&Supplies 17,245 38,425 39,767 87,425 Job Performance Expenditures 6,987 2,300 2,300 5,500 Utility Expenditures 13,472 33,481 33,481 40,041 Over/short inventory/Depreciation 136,155 0 0 0 346,224 273,959 275,528 368,693 Customer accounts Insurance premiums 704 774 754 828 Professional Fees/Services 34,000 34,000 34,000 34,000 Materials&Supplies 105,189 102,551 104,550 104,600 Uncollectible Accounts 3,360 3,000 3,000 3,000 143,252 140,325 14 2,304 142,428 Administration&General Engineering 0 6,373 0 0 listed below under Professional Fees/Services section Insurance premiums 18,435 20,278 20,678 22,747 Professional Fees/Services 101,616 55,435 66,861 116,013 Publishing 446 0 47 50 Rentals/leases 46,429 48,401 48,401 48,401 Repair&Maintenance 20,833 34,718 34,718 27,497 Materials&Supplies 2,937 6,800 6,800 6,900 Job Performance Expenditures 33,890 46,205 46,205 49,305 Utilities 0 65 65 65 Other Payment in Lieu of Tax 52,147 51,569 51,569 11,717 Franchise Fee(3.0%Urban Revenue) 62,577 61,883 61,883 75,762 339,310 325,354 337,227 358,457 Transfers General Fund(<10%per 08/15/12 study session) 121,316 145,542 0 199,953 Community Reinvestment Fund(office remodel) 0 0 0 15,000 Medical Insurance Fund 0 0 25,049 0 2012 revised transfer=normal transfer rate,resulting in$140,658,less Catastrophic Loss reimbursement from General Fund($255,531),This created a net transfer into Water Fund of$114,873. Debt Service 2008 Series A Colorado Water Resources,$5.494m,3.94% Final maturity 2028 40 Water Fund Enterprise Fund,#503 Town of Estes Park-2013 Budget SCOPE OF SERVICES The Water Department treats and delivers over 500 million gallons of clean drinking water per year.The Water Department is responsible for resource management of water which includes watershed management,demand forecasting,augmentation planning,treating and distributing water for public use. The Water Department administers the backflow prevention program and maintains all fire hydrants and water meters. The Water Department meets all regulatory reporting requirements of the Colorado Department of Public Health and Environment(CDPH&E),EPA and the State River Commissioner. Water Department personnel are required to be state certified and licensed as Class A plant operators,Class 2 distribution system operators and certified backflow prevention technicians. Original Budget Revised Budget Budget 2011 2012 2012 2013 Principal 289,859 261,098 261,098 266,774 Interest 140,006 144,688 144,688 140,430 429,865 405,786 405,786 407,204 Capital Land 0 0 40,000 0 Building remodeling 473,012 83,500 83,500 21,500 Furniture,fixtures,equipment 0 0 0 2,500 Data processing equipment 0 24,000 64,425 11,000 Communication equipment 0 19,000 19,000 35,000 Lab equipment 0 8,500 8,500 7,000 Purification equipment 43,284 26,000 26,000 26,000 Tools 0 7,000 7,000 0 Water system 33,000 350,000 350,000 471,300 Water system master plan 0 0 0 65,000 Total capital 549,296 518,000 598,425 639,300 'Water vehicle 9034A('98 Ford F150 4x4)scheduled for replacement in Vehicle Replacement Fund in 2013,valued at$27,000. 4 Town of Estes Park Detail budget information Water 503-6200-530 Purification Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail 1,737 1,560 1,716 21-02 Liability Insurance Premiums 1,737 1,560 1,716 21,725 21,725 25,230 22-14 Lab testing Professional Fees/Services 21,725 21,725 25,230 Publishing 500 500 500 23-01 Publications fees 30,500 25-02 Buildings 22,000 22,000 22,000 25-02 Pond discharge/sludge press/haul 8,000 8,000 8,500 25-02 General maintenance and repair 150 150 150 25-05 Machinery/tools 7,800 7,800 10,650 25-08 Laboratory 1,200 2,883 1,200 25-23 Pump treatment 10,500 10,500 7,300 25-26 Storage tank(cleaning/panel replacements) 15,000 15,000 15,000 25-98 Maintenance/sample stations Repair and Maintenance 64,650 66,333 64,800 225 225 250 26-01 Office Supplies 1,900 1,900 1,950 26-02 Postage 3,300 3,300 3,300 26-03 Printing/forms 300 300 300 26-05 Janitorial supplies 650 650 650 26-06 Small tools 2,850 2,850 2,900 26-07 Small hardware 105,000 105,000 115,000 26-09 Chemical 22,950 22,950 27,750 26-14 Laboratory 0 0 117,000 26-40 GASB 62 designation-membrane set-aside 21,000 21,000 35,000 26-40 Process Analyzer replacement/membrane Materials and Supplies 158,175 158,175 304,100 cleaning chemical sales 6,000 6,000 6,000 28-01 Telephone 25,500 25,500 25,500 28-02 Natural Gas 60,996 60,996 61,530 28-03 Electrical 41,100 41,100 41,500 28-05 Sewer 5,900 5,900 5,900 28-11 Propane gas Utility Expenditures 139,496 139,496 140,430 Total Operations& Maintenance Costs 386,283 387,789 536,776 1 1 42 Town of Estes Park Detail budget information Water 503-6300-540 Distribution Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail 2,721 2,457 2,703 21-01 Property 1 3,740 4,231 4,652 21-02 Liability Insurance Premiums 6,461 6,688 7,355 1,530 1,530 26,500 22-26 Insurance claims(error) Professional Fees/Services 1,530 1,530 26,500 Rentals 9,713 9,713 9,713 24-02 Real property 8,500 8,500 8,500 25-01 Maintenance contracts 8,000 8,000 8,000 25-02 Buildings 55,000 55,000 55,000 25-04 Vehicle Equipment 550 550 550 25-05 Machinery/tools 950 950 950 25-06 Meters 47,500 25-21 Water system 47,500 47,500 47,500 25-21 Maintenance 6,000 6,000 6,000 25-21 leak survey-distribution system 5,200 5,200 5,200 25-23 Pumps 2,500 2,500 2,500 25-34 Customer Service lines 35,499 35,499 45,609 25-44 Future vehicle purchase 12,350 12,350 12,350 25-98 Maintenance/safety block inspection Repair and Maintenance 182,049 182,049 192,159 3,000 3,000 3,000 26-01 Office Supplies 200 200 250 26-04 Freight/shipping 300 330 350 26-0S Janitorial supplies 11,500 11,500 12,300 26-06 Small tools 1,800 1,800 1,900 26-D7 Small hardware 2,400 2,400 2,400 26-08 Lumber/paint 325 347 325 26-13 Medical 600 1,117 600 26-17 Catering/special circumstances 800 1,573 1,600 26-23 Furniture/fixtures 800 800 800 26-25 Energy efficiency 2,000 2,000 2,500 26-32 Data processing software 15,000 26-33 Data processing equipment 4,600 4,600 9,600 Rugged notebooks(2 @$4800) 2,700 2,700 5,400 CPU repl(desktop,2 @$2700) 0 0 0 SCADA machines,MLWTP(2) (Marys Lake Water Treatment Plant) 2,500 2,500 2,500 26-42 Office equipment 4,000 4,000 43,000 26-46 800mhz replacemnets 900 900 900 26-48 Shop Equipment Materials and Supplies 38,425 39,767 87,425 2,300 2,300 5,500 27-01 Personal Safety Equipment Job Performance 2,300 2,300 5,500 8,070 8,070 13,500 28-01 Telephone 7,242 7,242 7,604 28-02 Natural Gas 15,249 15,249 16,006 28-03 Electrical 370 370 381 28-04 Water 2,550 2,550 2,550 28-06 Trash Utility Expenditures 33,481 33,481 40,041 Total Operations& Maintenance Costs 273,959 275,528 368,693 I I_ 43 Town of Estes Park Detail budget information Water 503-6400-550 Customer Accounts Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail 774 754 828 21-02 Liability Insurance Premiums 774 754 828 34,000 34,000 34,000 22-98 Meter reading Professional Fees/Services 34,000 34,000 34,000 13,751 13,750 13,800 26-02 Postage 8,000 5,000 5,000 26-03 Printing/forms 800 800 800 26-04 Freight/shipping 80,000 85,000 85,000 26-34 New meters Materials and Supplies 102,551 104,550 104,600 3,000 3,000 3,000 29-07 Uncollectible accounts Other Current Expenses 3,000 3,000 3,000 Total Operations& Maintenance Costs 140,325 142,304 142,428 44 Town of Estes Park Detail budget information Water 503-6500-560 Administration and General Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail 17,929 18,310 20,141 21-01 Property 2,349 2,368 2,606 21-02 Liability insurance Premiums 20,278 20,678 22,747 r r f 5,500 5,500 7,500 22-01 Auditing 0 22-02 Engineering O 6,373 0 '12:h2o conservation plan(rollover'11) O 0 0 '13:water system master plan 155 208 155 22-07 Recording fees 12,000 12,000 12,000 22-08 Legal 35,180 35,180 53,758 22-09 IT Services(15 PCs) 2,000 2,000 2,000 22-10 Bank service O 5,000 0 22-33 Data processing O 0 30,000 22-89 Financial Plan O 0 10,000 22-89 Compensation Analysis 600 600 600 22-98 Other Professional Fees/Services 55,435 66,861 116,013 Publishing 0 47 50 23-01 Publications fees 45,201 45,201 45,201 24-02 Real property 3,200 3,200 3,200 24-03 Copier lease(shared with L&P) Rentals 48,401 48,401 48,401 25-01 Maintenance contracts 2,600 2,600 2,600 25-01 Copiers 1,000 1,000 1,000 25-01 Radio 4,878 4,878 4,807 25-01 Telephone(10) 8,000 8,000 8,000 25-01 Supervisory Control and Data Acquisition (SCADA)support 2,100 2,100 2,100 25-01 HP plotter 2,500 2,500 2,500 25-01 Laboratory Information Mgt System(LIMS) 13,000 13,000 2,850 25-01 Zenotrac 24/7 support O 0 3,000 25-01 InfowaterMWH 640 640 640 25-01 Tokay software agreement Repair and Maintenance 34,718 34,718 27,497 1,700 1,700 1,700 26-01 Office Supplies 1,000 1,000 1,000 26-02 Postage 1,000 1,000 1,000 26-03 Printing/forms 900 900 900 26-13 Medical-CDL physicals 1,200 1,200 1,300 26-17 Catering/special circumstances 1,000 1,000 1,000 26-42 Office equipment Materials and Supplies 6,800 6,800 6,900 8,800 8,800 8,800 27-02 Uniform allowance 25,450 27-04 Education/training 1,200 1,200 1,200 27-04 Lab Classes O 0 0 27-04 American Water Works Assoc.(AWWA)- out of state 4,000 4,000 4,000 27-04 Membrane users conference(out of state) O 0 2,000 27-04 Pump classes 1,100 1,100 1,100 27-04 Cross connections classes 500 500 1,000 27-04 License renewal fees 4,300 4,300 4,300 27-04 Standard/advanced water 3,500 3,500 3,500 27-04 Distribution training 1,000 1,000 1,000 27-04 Misc seminars 1,100 1,100 1,100 27-04 AWWA collateral 45 Town of Estes Park Detail budget information Water 503-6500-560 Administration and General Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail 300 300 300 27-04 Cross Connection manuals 1,950 1,950 1,950 27-04 Motorola Supervisory Control and Data Acquisition(MOSCAD)-in state 4,000 4,000 4,000 27-04 MOSCAD out of State 13,425 27-05 Membership dues/subscriptions 1,500 1,500 1,500 27-05 AWWA research foundation 800 800 800 27-05 AWWA individuals 450 450 450 27-05 AWWA standards 1,225 1,225 1,225 27-05 Northern Front Range Water Quality Planning Assoc(NFRWQPA) 475 475 475 27-05 Cob Dept of Public Health&Environment (CDPHE)Discharge permit 2,000 2,000 2,000 27-05 Big Thompson Watershed forum 350 350 350 27-05 Marys Lake HOA 100 100 100 27-05 Top of Rockies Road Assoc 1,200 1,200 1,200 27-05 CDL Physicals/license fees 3,800 3,800 4,400 27-05 CDPHE Public Water System fee/lab cert 400 400 400 27-05 Colorado Rural Water Assoc(CRWA) Northern Colorado Water Conservancy District(NCWCD) 250 250 250 27-05 Larimer false alarm reduction program 275 275 275 27-05 American Backflow Prevention Assoc (ABPA)-American Society of Safety Engineers(ASSE) 880 880 880 27-06 Employee recognition(11 @$80) 750 750 750 27-07 Mileage reimbursement Job Performance 46,205 46,205 49,305 65 65 65 28-01 Telephone Utility Expenditures 65 65 65 51,569 51,569 11,717 29-08 PILOTS(Payments in lieu of taxes) 61,883 61,883 75,762 29-10 Franchise fees Other Current Expenses 113,452 113,452 87,479 Total Operations& Maintenance Costs 325,354 337,227 358,457 1 1 46 Town of Estes Park Detail budget information Water 503-7000-580 Capital Original Budget Revised Budget Budget Account Account Name 2012 2012 2013 Number 2013 Detail 0 40,000 0 31-11 Land(water tank w/Kiowa Ridge) 7,500 7,500 7,500 32-22 Security Equipment 60,000 60,000 0 32-22 Demolition of Fall River WTP O 0 14,000 32-22 Paint Castle Mountain Tank 16,000 16,000 0 32-22 Crystal Storage/Big Thompson Tank Fencing O 0 2,500 33-31 Scanner(shared) 24,000 64,425 11,000 33-33 SCADA Software upgrades 19,000 19,000 35,000 33-36 Communication equipment/SCADA programs 8,500 8,500 0 33-37 DR 5000 Spectrophotometer replacement O 0 7,000 33-37 Biomass Reader 26,000 26,000 26,000 33-40 Feeder replacement 7,000 7,000 0 33-41 Confined space entry equipment 35-54 Water system 272,000 272,000 0 35-54 Virginia Drive water system O 0 177,800 35-54 Big Horn Drive water system 40,000 40,000 25,000 35-54 GPS Data Collection 13,000 13,000 0 35-54 GCWTP water rights-engineering O 0 133,500 35-54 UTSD Tap Fee/Capacity Increase 25,000 25,000 0 35-54 GCWTP water rights-legal O 0 135,000 35-54 Automatic Meter Reading Replacement Project O 0 65,000 35-62 Water system master plan Capital Equipment 518,000 598,425 639,300 I Theater Fund (formerly known as Friends of Stanley Hall Fund) Fiduciary Fund,#716 Town of Estes Park-2013 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 deemed unfeasible,by 05/31/2012,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 Budget 2011 2012 2012 2013 Revenues Investment income $475 $600 $600 $0 Total Revenues 475 600 600 0 Expenses Personnel Services 0 0 0 0 Operations&Maintenance 5 1,000 1,000 0 Total Current Expenses 5 1,000 1,000 0 Capital 0 0 0 0 Total Expenses 5 1,000 1,000 0 Transfer out/to close account 0 0 0 (456,850) Increase(decrease)in Fund balance 471 (400) (400) 0 Beginning Fund balance 456,779 457,250 457,250 456,850 Ending Fund balance $457,250 $456,850 $456,850 ($0) Budget comments 2011 2012 O 2012 R 2013 Operations&Maintenance Other professional fees 0 1,000 1,000 0 Materials&supplies 5 0 0 0 48 Lem 0.4 COvmpofteal %MM.! 0 VIOftileani 0 U C W LL- 11111.11111111M > UM./ W f aliWirfr4t40 (1.9 KwitgOWSejLIM CO p UM 1•4-14,,,olts D2(10) r..„„..,, CE:11/ ........ 4) (/1 ..C. CO o 4- I 0 o m 0 7- o N o C. 4-- O 0 CO C• N O CO SD, Sa '7'ti OD t til no till c z � �tap � O z ° � ~`�co • ; i c6 1-1- ct T N cb 7 c Q N O S 0 -0 7 ..- s. 'i O ( P p) O O �n ii) c. lii 1 c cio 0 isJis4 0 CO 0) '. O L9 -0 -0 S u .lis �� N C) S, LA-** ..-- tr, 5 s cv U O a) �A 0) c. -0 CO 0 C° ..j r•O. M . ) -tj t 0 G) '3) Cr) O � -o c� 4, 7:0 o V, o t� o 0 0 co a) O Q O Cfl , C. a) O ca N N N 44 N taA 0) N „.. �'' p . O m O .1 4-''.4:4 tail) L$(0 1 e C'f 0, 0 ,,,,s44 roll., 0) .),-J (1) 0, .., •Z)- • O '6 `d 4.1 N N ✓ ' N a) 3sa3 m y— k1 y .�-j N '{� 1c'k p � � � e. - Ct) s' C� 0 c� (I) °v Ict O `�z4 0 a) O ''t S. Iffil [ ii) ca 25 o ..441, r- ,- -a •— O cm O rt i CO „I G) ..0 %.... - S. ty. CO CO Vol n• L9 „.--. tp .4,(t) a) LA C--,- vt pS 4721, 14- C) C? O O ' O s �°". x s a� =_ C. 44 • c. r o °- & CD Z -CI cb N U -a " CO sN ,41 .s� �, cn_, 444 p o 1;4 0_ i t-3 444-4 la 4-4.44 o io 0 0 u) a) y 0 Ss J S) . co V r Q) V y 0.5 v -'6 O N # AjlSnA AS .7 Q 0 0 v Q t.f) N N i 2 ‘5, 0- :) 65S S y � � o v o 1-0 tc5 a) °S 45' a) .'f'., -0 sa 16 0 0-- _CI 0 Fs) ti- C.) O. � -o � � � �- ' U C �, .4-> CO i na) s t -S- °J: l9 � �' cv o � � L,9 LE) -c, cn A., co G.) , vA o 2 ‘%.i O v U o -� c� N J' 9 o 0 2 `� : o u4 y a1 o rn � � O 7 N cs) p v 0 n. cn a) O • _ -6 tp WO O '�5 rl g ) t�M p � � � `� ; � � \ - ,� s 2 -a S' Pt lf) t.i... CD" r4 0 0 0 FA ri C CU 0 0 - -0 vjs A CD ,.... 7.5 a) a) „...(1) C (3) a—. ••••••• L„.. ki) 1._ .*ti -0 C CU •-- CO • .+-+ rt, I p_ 0 - -.1.--A o >" ("1 _ •-- +.0 "Vi CL — — v) C E A CD 0- CO v) s_rp v) C 0- . V) s.... vs s.- •-... C 13 -C -----P.'" 8 -IA- .- C F- 1:3 cri ev, F . .- C e-I..._... -0 "1:3 = ei 1 , U, c a) _c ^,,-; 1.1,_ z.....- L-, o L., ro 4-J 4-) %.i Ni c .....j ---1 ,.,..- Z -0 a) CO •-- r-I a) 4_, 4— — 0 2 _c o cu a) .0 zi C1) co 0" = *- N (1) 41 LLI r-i -,,4, 4— 0- •--, 4.4_, (I-) _.0 5,.... 2 ..,7 0 ..?' >, 73 a) tr) 0 E -. -04 °C .4....E.. 4_,L_ (AO ---->, 4;1 .--,e/ ,.. .•%. • I >' 0 -0 --, C -0 03 *-- c (.1L- -# sa) _ 0—- ,----) U a—. •,_,- ...._ _ el 1 .— Q) C -t;-- 1 •••••• W 4.1 Fin". • • 4-0 „.......... ..--1 -1-3 W :111 C -.- > v) o " = 1:3 ..._ 4--' = a) a) LIU I:3 .ij CD irk fa (-1 03 4— 0- 4...) • .,...47.4 0 co I CO e.., u s.:...„_,,p ..,- a) ro c L- el L9 c a., .tao c 0, -4,(,,,- .4-1--- = (-) *---- 0 >-• u 14-(1) •-...._ " W 4441 CD S- 4-J U > C 0 1.- — = --,--a4 c • c 4-1 C ............ s_ a. < a.) Cu .— 0 = ,cc E .,., a..) cl) Q) 1/4.1/ eto _C 13 _c Ci CO C C a) 0 CD 1:3 L.... a) 47.=•t I • CU 4-)Z C (1) " C .—= > 4'; .t-2 (13 ..C 0 V (Y) Lu u.... o- N 0OCCUsyil_) >•••,,----/ 0 co a) " a 0 4-) 4_, 0 •-•-• C c ."--- .4.-2 --i4--11 Z------4 ---,,z-i < c 44 N V) (1) 0 0 0 e4,1 0 , AI 1 .-. --.e,..,. -,-1 El -41;i1 --, %- N .. N ° ca ca L o a o� 3 , N m '(a a a) `' o `+ `' .% ,n o 0 tJ tom.) a) ta N O - ° •aA p o U � lr. .' 1_ . i CI.C/^) 4- C. c4 '&n* -ttk- -% - a) (3 C. •-• `,'' s, Jr)�� i- o + Si 0 o 's ) t 0 e tp �_ � 6 s � � 4� s 5 cn �./ � N - �,- N to N ?� %- -`p, o ti) .k-Jai ' � G. ,..-A (a)� A u, sv �, I'l.' CO 0 U �- ti ° o O 4. c 4 0 0 Ct$ (6 .:G ,Y 701 CO a) s • a) .tn (c5 , '11. s C - _C 4- . -9- Cr.) u- , . 4 - 4-' N u- o iPzei illmill° 43) 0 .--- Q) -5 `nay NJ Zs .ilti a) •s to y At (I) 2 • • ..,a t_,>,.. sci) ---tio . ..4_2. D ca) .0 -x .z N c E EE ,c i) ... ,(1':.. V-4 E . 2, ••••. . .,. ;"' O Uo u a)vv E2 0 u o -a a) .� s c E LO) 0 1"-- 4- 40 -_4,..: ...... , .,. C OD (a) vl a) O -u — a) a) Ln 544 VIIIIIIIII, , i 404 a) C a s • 11) o a a) o 0- c L9 = VI . '.- 0.) 4-) 0C (D .-- CIC Q.) x---4 u +-Jr° (-0 ° --77) (1) ID o w-, ,,, tip 0 a ci)lu- Qs ,t:,,:i CO n ,-¢ m z d o a) a)o �, LU %--- N a) N U ate-+ 4-4 ,_,,, o 4 c op N 0 i-C3 WA SA 0 444, -14 CI irWeki ......... U LEM 0 a) M z t-r U. 0 0 f"4"" a) Z V 404,04414,004.01 (Ni w 444-50-4000404 ca 2 .1111111111111 w ,,,.:„..,...,,,..:1 Umi(9 Z rO 0,44,4404,41,00 w L. a Ct CD w >- V ID 1--- 2 .....‘z,0„...r.4 e„,—,...„0„,,, r,,,,,..„.„,,,, .,,..!..:.„-t-,,,,,, _,,,,...,.. , 450-0,0444440,4,04 CO Z a) .#,,,,,,,„,:21 2 .,,,..„...„,„*.1 ..,,„.....„,„. 6...„...„,,,,,,,A 4....; it,,,,,,...1 (y) 2 .4„,„,t,4.,,,, -.it.-,,r.":4 0 Y.,4:404440400,44 P44,00.44 Wig til tit -6 C (1) p 6) 7 Q. 0 a) (V Sa % %-c-i t C. 0 w.C. 1".6 OD S.-- e ...... .... :# c‘ .4 .- 0 (1.) -F-,3 a) ,_ 3 c a) C -C3 aA a) %.... r. .6.-- 2. .,5 e ,./., ,..... 0 -.-Fr; o - ZO ?I° cc) s % c: 0 " o a) e ? a) Q c) V .u) .4..J - .�A, a) - a) co 4. :8 o t-1-- -a C. 0,, Li.- o '0- oO a 'a) ` - UVe u- a o 0 a) '.ice 1.1� -03 � � c4 % rip_ o � aG 0- 0 c� Q- 0 ? N a) a) 0 '� 0 = = C, t� ter./ .tom co ce. � CO " Ca U C' y4 k- v s N c rcA a) ca � ° �a- � � ° 0 oo 'oa 0 f6 •0 '- o , ,,..) 0 r, -0 N 00 0 Q. c, 4.p. ‘, 0 ,„ -t) („) (ts — ua. -6 c. , , t_,%-- 0 ,..3.. , >4. * , .4..) "---- 0 U ca 0 0 bA 4) .. CCS qA - `4- -0 ® t6 .F ram , co CAA CD' 44% C. L) ci- a) t^4 co``) p -a% s- %A .C. O ,-;75' caP a) m .b.J 344,41 400 Vim', �, 0 'o cv ..... 4,' v 0 0 c6 c6 c teo 0 O tU -•O 4 -1145, Oa U N O v'0 p (I) +,'. . ' .e-' OOD LOc. (V ", 'n c6 ,� N q) O ' ) �OJ �G.) cn (,,�14 k's. °' U ss ° Ln .�' O o V G --- a) p V -0 'c c'�u c. c�•.� O O Q, ` 4- t3 7 U 11 N ° E o C o L a� Q. C 4-) Ca LL- o i ►_ o cc c Q LA c co N O co 5- .� -O i CO Z a) oCO = � � � .c 2 n' E U Q ,O N � U CA ,O . .CQ 2 _.c U C N `''- cn c O (1 E O 0 U tu L.) (a s) a) cn U cn an U (13 a) C/ an C C -C CD o° 1� -1-j C (6 ° - -) 4- V) 6 U cli _ v) an v) O D 'an -, CU > •- o ai .0 x N ° CO . m �„ a) o o O- 2 _c o 4- m o cn a) L y C. ca •C• IA-. a) �; of) Q) tv 0 o '�- o- 0 y ) (0 kin 4.fl• -e. . (..9 vsl Vii......, CO la Ct5 CU v- �+ Cr) a) y ioi Q- N co c•k •p a) nA �' O sft 149 x co y 0 O G ) 0,) t.) ,¢ np .till- V r _ . `VI 'en 0.) —(6 --C.11 t, (0 0,.) 0) \''' i a"' 0v 'CS N N 4-> N CCS afo V 0 p 0 O m O CCS CO k o y 3 u -ts S1 i Cn 3 a CO ;4: C• ljei 144 '1AX Q- m • co 0 S • C4 4. 0 o co S -r� 0 ° o- a) a y' . ko.•• o- L.) o � •� � � .- ci)(0 0. ca N O O O _ •� Qsa '7 (i) S LC) AC?; caLid AS Ws ‘A, Ad) S)co 0 0 . 0 ,a) 15 0 st sa) c-4 c6 O tU cn o 4 s-- Q) ctS o ° u la c6 0 vom 4 _ CO Q o taD a) Q- Claco N OO Ea) — — a) cos.- O 4.0 �' E CZ5a) 4) 7" cn �, 0 }, t11 cts s.- a) N .4-� T5 N 5 V o (0 a) V a) "11°,,,, s.- C ICU --'"- 0) co = - zs Am ' t. •-- 0 a) C ..Q 4)Wir as c ca a) --' li en .. C 0) C 0 G) CU Ln' co •''' V $.. to Z +j C ,8. � , 444 VI 0 -4-3 � CO in O E o aa) 0) aV) ,:,1 LL- -05 4- co c cv -a . .,,-., *JCL) Li- S (.1) 7 .;.4 CC' O- c/) O v i SI .Q ni nt*.i. Lor.) E V i a) TS V C. -04 .� co 0 p ,. "O C O C '11,1 4....)LA ct5 -,- 0 %...• % ...6 u,..re 4._ 4 O • ;a O s .Q 4 V f 9 �- a ❑ Nil PII4 IIIPTM4141.11C1) t.ti . gad I 1 !,. i' I ! 7*- •. '' ef i . . . , . - . I - - A'ce, • 111: \' L 1, N,s1 I _ ‘ 1.1 I 1...1 \ -41 1 ' CD 14 NI 7"" ', I. I, i lil \ : AA . t,t (C...›. -71 Cid L1.".11:1 14 ... . . .. . CU w cf) .1,1. , / , `\ ..I 1-4 1 n t 1 P '''' v ,i, , , [ 411.''... 6\ et '10 1;1 4 ! , 0 i in la ptli..'. bIli • 1.- "AA IL 1 v ,• ., 4. ...., .•1 i. •. .4 ‘ . 1 t ,, r . . .. /1 i ... ili ;m4 Cii) Ill • ' 1 1 Asma 4 : . . , _ Lli , 1 . I it Lie 1 I '-' • .II I V I J- 1 III 4-4 — c 0 o o 3 '- O o O 4) 's- O - -a) .,: '0 7 to V -a Q 4- a a r a) > 4) _ O (U 0E. a) 4) o o Q- 4) c. ' 4) � 3 o 0 c 0 0 E. a V s' " o •3 ipi, o -a 0) S v Nc. a) .� T 'gin tn •� c. c. ( ) Q _ ^ a Can 4.. -0O 0 0 IMF 0 a) E Q i '?" .Q • 0 ,( 4) t- '0 , PA 0 • O 4) i a) _ Q cu o �./ O '*' 4) 0 V0 cri) -a s - T s to O {• 4) '3E. 0 4- y pG L a ♦. 4) �0�••• 4) 0- ��. 0.. 4- 0 0 0 LO CD c •_ V a (A Cl) a '" c _ L_ a log -0 U bOg, a) a. � _.. I I •_4a } s ' V a) i c 4- '> s bti 1- Li- •v 3 111 � � J a) Ii Q a N O 4- N i •_ •- 4 a) } 0 4 1_ a) a) o r- a) a) o C 4- N = a o } O O N 0 d) } 0 v N 45. M 0 43 N o4- C II a) v o E � � N a s M > H V O 0 M N `O O -O NL09- 0 M 0 N O %O (N `O CO 69- sO 0 N O Os N `O N tf} O 0 0 0 0 0 0 0 -1Q9- O O 0 0 0 0 0 0 O O O O O O O O O L() O LC) O L ) O Lo 7t. co CO N N r— 1— 49 to} 49 L09- 0 N N U co a C 0c a) N 06 til 16 in c CI �� ' '. . 6:. I. Cil C'V o a ,o _ o0 "' co a '- M o O O4 o- II 0 N coLo r-- h O h. N co N Cr,!Illi • I X O W N N Lo N Lc) O ►`� N ,q. N 0 0 O O 0 0 0 trY 0 0 0 0 0 O O 0 O O' 0Lc) 0 0 00 O COin M N N r' E!} te 4 a o c. L. N N O O7 op N O O T a) c } N a) Q a) } to �^ +- E c -0 N 0) } D a- N 4- O O O O O s D 0 D N O N 3 1 4- u 0 U 4- 0 O •� u O u ° O u CTO — — C _ u • N to 0 } M O 141( N ,-- co L CA O• N O O � PIO N N N CO... Ilk O O N (NI O O O O O O O tol- o O O O O O O O O O O O O O in O Lc) O 0 O 0 = co co N N 1405-11-1 N c -0 O Ti a aV v N V v �; s v •a o ed 8 a) '0 0 C N 0 QJ • iiicit No 0,-) co coO sO N ,O - N 'O O • N O NO I • - CO414 1 ed try O O O O O O O O ii(D O O O O O O O O O O O O O O O O O O O O O N ` s d' 00 N r— y-- 0 0 LO 0, c 0 N �V c 0 o s C a)0 E I(I:IfI4:tj:) a) • ,c E r4 o 1 ta) ,_ Q 0 • � a) 1 z 6 " M '� 3 11111 1'4 U E O } N • „, 4_7 a) a) U.. 0 0 LI- o = 4— N 0 _ 0 N 44 L-61 Information Systems Technology Fund 201_ 4. 11 ---. leo NbAegit 41. ntll: -• Scope of Services •:•Services Include: • Three people work in the IT Division which includes all GIS mapping services • PC support • Network hardware management: printers, copiers, faxes, • scanners, multifunction units Phone communication management • Audio video management • Management of network plant/equipment, facility security, Light & Power/Water process control support + Records management: software licenses, external connectivity, network security, maintenance contracts, database management • User training hts2013 Hi hli g g •;' SunGard/OneSolution — PM and staff engaged — much work to follow in 201 3 •:• Town Carneras/DVR Ownership — numerous replacements (in several Town buildings) in 201 3 plan ❖ Internet — doubled speed, will soon double that — zero cost •:• Fiber Optics — Raising public awareness — agreements in progress fP Revenue 0. 2013 $700,000 - i. I Charges for Services $600,000 $500,000 $400,000 $685,089 Miscellaneous $6,003 / •Investment Income $1,500 $300,000 -/ $200,000 i $1=OD;000 To-t-ai—r $9=2-,59-2 $0 2011 2012 2013 $498,822 $479,099 $692,592 [p p [P Expenses 2013 Personnel $300,000 $281,040 $250,000 PI Operations & Maintenance $200,000$150,000 $100,000 $232 606 Capital $179,500 Total = $693,146 $50,000 ■ $ 40% 0 26°/ 2011 2012 2013 $439,778 $535,800 $693,146 34% Personnel 2013 $400,000 IT Division manages $300,000 377 devices attached to seven networks. $200,000 They manage over 1 50 email accounts. $1 00,000 $0 4o0io 2011 2012 2013 $237,751 $243,336 $281,040 EP Operations & Maintenance 1111 �P p c 2013 $250,000 O&M charges include our , Or■ Internet service provider, $200,000 telephone charges and ■ annual maintenance $1 50,000 agreements. $100,000 $50,000 ' $0 - j. 2011 2012 2013 $185,930 $232,464 $232,606 34% A EP Capital 2013 $180,000 •:•DVR $160,000 $140,000 '/ ::.•SeAvr/vGers$1 20,000 /$100,000 / •SunGard Project $80,000 / ear $60,000 $40,000 / $2_0,0_00 / F $0 2011 2012 2013 $ 5,790 $60,000 $179,500 26% EP 2013 Highlights 11111 ❖ SunGard/OneSolution — PM and staff engaged — much work to follow in 201 3 ❖ Town Cameras/DVR Ownership — numerous replacements (in several Town buildings) in 201 3 plan ❖ Internet — doubled speed, will soon double that — zero cost ❖ Fiber Optics — Raising public awareness — agreements in progress End 1-11 A Expenses R p 2013 Personnel 40% $281,040 It Operations & Maintenance 26% $232,606 r Capital $179,500 34% Total = $693,146 • A EP Operations & Maintenance 2013 $1 40,000 Repair & Maintenance $120,000 / includes annual i licensing/support $100,000 charges for the 16 $80,000 ' hardware and / software items. $60,000 $40,000 •-7 . Materials & Supplies include internet $20,000 services. $0 ' ' `J�5 d°ce \e5 ot• • • ca Ge �d �� et ck-eeMI 111 MI I 34% P CapitalOutlaY Y b CRIMMIll $140,000 2013 $1 20,000 / $100,000 / $80,000 / $60,000 / :: :: ,0 / iL $o ii- (I ajoQto�boat ata cp'' 2 6% r,0,,,,,,,P,--„,,,,, PAVOIZZI CC M Xx ril.4 z � _ „...„,......., O D LL � ....,,____.„ rs4 I z2 Vim-- ,,,,„:„...„,,,...„ G ' (::$ ,„ ,,x. LLI IJJ U C Q CO LID J $ -- d Ca QW U..� U t,..„,,....„„ r.s.„,..„,,,,,1 2 ttia,,, ,,iti „,,,.....„....,..„ CCI U j w vi 0 0 0 -0t , s O -a Nu ' � ia) top .L a) o 0. a) .?<- E o w 13.0 (� O t �w V6M1� .i a) ccs tYy O ca tit) ?) N a) ,_T° v-i 0 >a) °VI S irf) ‘ .i ?-/') CI) Si Z .• C .N O E a) N s- a) c W �.� a) u- -Cj. .i (A 1(-11 t —-S 1";) -F it =.- 'f], u- V - • �U1- CU N a) f •- 71) U co mil % 0 0 •� a) a c (NI a) >O ,t? c6 c to v VI 4- •n >• a) t . S -c) LA 4-J > ---3 ..0 -0. r- C a) N in- ''>' CAA U E 7 a) ..� o c a) ca S _a) � - C CID E. co t 4.••• ...c. co .� C ) 4 •— CO CO U a) U czr u- Q -0 a c L. oG a) CO 0 4- • N t1' N • co ..... 0)L) ....- e 114 o y ,4444, ip c6 C. 0 o -.7441 *10 ta MI Q- tin o tri, 0- kp ‘11...° -3 °'44,344 N S a�WA = �'y to a � � N,404 CO o CO 4114 0 .. * 0 U ) N 0 � - 0) �, KS 0 ,..- vo e .., - ...,.., -,t.,,, 0.0...e. 74...) ta........ G.) e ......144 .• s- 0 t...) %rt., N �, u-- o cv ft0 CC* S, v 0 S I "`- 0 t (1' ' 0 4(11)) 01 cJ a) v 0 S" r`' 4 0.'Iry 48 N 3 Aft- 4 N Yo t t `g\ %, tp w 4-1 'C' .4 ‘ 1:) Cn � � � � -- 0 CC ,4 J' " > N t o 7 `":'s a) . " -'%8 P. ) -re 0_ , c) 0 (I) 0, O a3 0 L r. t.f •r I •_i ,a Kit; I J - • , 11,11MM.; . ' . ' '• , >11' I . ......._ ...A ......... ..i. i.. .... •„,,,,,fr;i, . . 't ! .., 1 ilo' • P-4 404111140 .-b-- _ _,... , , , • I II a I ' . • P * l7 • (in r ir4 -.- . ./ IF • Fm4 . It)110 , ii gr, '1" ' 4')'#.. re • - ' — , ,11 i . ,_ ._,.fil ,, , F : ..lor CIIIII) P: • 411--1, 0 ' •:.4 4r---ts ‘ 4 .-ifi-i • I 14 ). yr, IVO ir 1.4 ,-4.•- •41"110 e •- .1.d.V410.''..r I •'._.-i ' .1. .. / I' r---7 ,..- , • • , ' •i .' - s.,• • 1. -, r I - 1' ' • i I . . .. 0 0. • 1 N, ' m . •, _ . - . ... s.._____,,, %,i---------4---." .-,..,.. , ,, , ..,Lf•,. 1:1:0 i liZ , ;■411.5. -11 -• 1 , l' •46.4.....' IIP' 1401 t,. . I ,\ 4 , 11 .4 '11 ;MI , . Z ;. i ib ril • I / M CIIII) CPIIII j, •: 6 _mg \\,,,,. I illti.(I) (iiii /4 ym {." 11111P ' '' i .\ 1g i 0 ( ,i IV 0 / ie. iiiNt r 1 i? .•dit„,,, .' ale 1 t \ . , 1—. ,, .• 440f43 „min; l ill a) O U S a) c o_ CO O a) V 0 Cin U co 6 •6 i •Q V � 1-6 u T C c } 4 . •� s (a) a Q _0 014 .(3) 4- 0 O C) Np = 'i a co O c rieJ O ,-uQ 0 a)uco • .kl- )(41) -0 u- u .- ..;:-. __1 4.- D d O O a) "- J O O :J m i V fa- ♦ • ♦ 0 • ♦♦♦ •♦♦♦ CO > ♦ ♦♦ ♦♦ ♦ ♦• ♦*♦ I • 0 voi t)4,1 .4- -0 13 06) a- i y 0 Cs 7 cr) 0- 0- ye, -0 (2) 0o -0 0 q • 7 L S • 0 p 0 r= t5 CO s o o 'tr a s o °t o 0 o o -0 s V Q Q s, • s ' 0 �jj© N V C a C '0 Q) M +- c N d• •a 0 tV M M dS 00IN O O c N 0 N N o — a) � °: c II ,_ , 0 • Nt o 0t- 0_ v I� ► ■ N CD N VJ M O Itg MMII. O N N N 4;9- : M x N `CI 0 0 0 N N COAA- O Op N 49 O O O O O O O O O 0 0 0 0 0 0 0 0 O O O O O O O O O O O O O O O O OO V' N O CO •O � N r e- F e- 99- 99' 49 99- 93 -99 -99 UN� M O U }-o (/) _D Cn v c O O No lit r• 4 coco li Ciii) 00 O co N tR. COp ,..4 ' N pp O __ __ _ O N Cin to. r N (Ni N IN N to O O 0 0 0 O O 0 0 to O 0 0 0 0 0 0 0 0 L() 0 N } ® {f} {f} 49 44 � L.) c 1Z' II) . c O a 0aD i 0a v =ca) .c . O N . 1_ = 4- PA 0 O iOcD-0E cO3 -ti c v D Q • a a sO or> V j a) 13 -I- C..) c O i D C -0 D 'i O •N Q _ u Q u) _ N -0 a. u = N j. CU •��1 IN V M O> O 'I N O 0 N 0p ill O sO N M 69. O • i■■4 Os tit ,-- 0 O '(NI r- t9 CN IIII . . . CA o 44 a a pig "a- -6 bt a) a • P E 0 8 45 60 a) Q E. • 'y 144 v);CI: O 73 u o " -Z ''' 8 .0 3L.- 7) .0 -0 -a a F_ rsii a) 2 Csa � 0 u 0 a -a a m a .N � O N _— a) O a C u > C a f- -0 •V g-i- 73 :-Ei „,a) -0 47- CU • Pawl o r 0 o D a N ,0 a) :z-5 g +- 0 - S 0 E < Q U E • • D 0 V) 40 ,41111110 /ft . Mr ,.. I./* . I. Y ' •/ i . • lm4 _ICJ fN ate •, 7:$ I.Ng.. yv • r �.011 )1,1 1°19 • • 46-...:44' -;':1'1...": . * ,. : .. Ord` . i en leci---- : . , •' • o C -- - '' '' ...' : .S .,I i„ 4 • . l� 4>Ir.% • O N ilit$ . _ , . ... _ . [1.1111 III , _ ail 7 . 7._ , ct . 1 dim _. cie ..._ m-mor . ._. . ., , i ,.. 4o j; ,A) L s N -0 0 cr) V „, itl) 3 y o ' o o o o 1.?, c- uk-,. w -0 O O -6 v . � O Q N CIO O �0") •--- N �Q v c. i V N Y yt5 0 0 •4- .- T `It) s 0 u V CillikAw '0 0.) *4-- '',..., t5 -0 v � N T 0 .(5) , C. '0 r; an O .� Q ♦♦ N vo- • ♦♦♦ •♦♦ '7 ♦♦♦ •♦ y C) • 0 ♦♦♦ ♦ 0 a) ikao VN C. a a M M cr S. M °6 11 r' 0O a N . oa a o a i L.) r Q. r- o- ■ Q 4d3 r Mc rf) \ \ \ \ \ \ \ \ \ M` la) tP. 0 -cr N Volk tie \ \ \ \ \ \ \ \124 C11:11114k. A \ - 0 N ,�- W \ \ \ \ \ \ \ \ °(:°).. 1 c4 413 O O O o • o o O o •0 0 0 0 o O 0 ° ►n O ' 00 �no `fl 0 Cr) kA )(I)) i Oo • o O v V CLJ cin ccl: c 75 = s a ' j' c a a._ iL m a 4-. } CV) 72 & 7 NO •VO N 'ama a m in N a } i a i iO N I I I N7' co '7r co O Oam N . = ! 0 10° = i N O0 `O hO NO Nr k. pmis4 U O N te O O O O O 0 0 0 0 tot)0 0 0 0 0 Le ® � -LAYNth} O AO "Ci11c v a o ai �' c a N o 0, •= O M N Q. ) = a °Q � Q u 0 � i vi O i � 01 .19 -0 t3) --,-.7 X -0 \ N v O v += v D c 4- Q - v v — a v) a) E - CO 144 • '.y a o co N flO r-- N -L9- N � O N O N 0 0 O O O 0 0 0 M% N N r- r- ' e I I General Fund 2013 - Executive t e Expenses = $520,1 62 p Sco a of Services .:.Services include: ':'Implement Town Board goals and strategic plan(s) ....Provide direction and ensure efficient operations of Town Departments •:•Responsible for the administration and enforcement of Town ordinances •:•Responsible for presenting the annual budget to the Town Board ....Public Information .:.Sales and Marketing of Conference Center Provide Support for the Town Board 5 Full Time Employees — Administration A 2013 Changes Summary of changes included in this department are. . . • Administrative Services Department • Sales and Marketing of Conference Center Impact of Changes _$177,145 Transfer In $244,739 _ Transfer Out A Expenses 2013 Operations & Maintenance Personnel ■ Net Effect $400,000 $350,000 Total = $520,162 $300,000 $250,000 $200,000 1111 $150,000 $T00,000 $50,000 $0 31% 2011 2012 2013 Personnel fP o nel Services 11= 2013 • 5 FTE's $400,000 $350,000 - $300,000 $250,000 $200,000 - $150,000 $100,000 $50,000 $0 2011 2012 2013 $215,640 $252,672 $357,274 Operations & Maintenance 2013 $500,000 - $400,000 - $300,000 - - - $200,000 - $100,000 $0 2011 2012 2013 $200,299 $228,475 $162,888 ti Expenditures by Cate orp Category 2013 $200,000 - ■ Insurance Premiums • Prof. Services/Fees $150,000 • Publishing • Repair/Maintenance $100,000 I .Materials/Supplies • Job Perf. Expenditures $50,000 • Utilities _$0 _ I - • Othr Exp Review of 2013 Changes Summary of changes included in this department are. . . • Administrative Services Department • Sales and Marketing of Conference Center 111 I ' • 14. , Libri-f- Q •- 'l I • F a - ° ? . I i. . IF 72ai- r I ,., . ,!.. ....,„ ' '• "'�" iii LiiIli - a . . fI � -.1:4'%4.4t\.). : . .4 :�: i Eiji- • . .i. .,...r , Ile). , . 8.1iL .1 .. ' K4r, -,,, filD .1 t .1. day - 4 � • 8 • \ ••* ♦ ♦♦. <. N ♦♦♦ ♦ •♦♦' ..♦ ♦ .P ♦♦♦ .•. '.' ' ?� n C o ; 3 Q - 5 CD3 O p CI C O Q. Q 0 -1 • . r1 n - 00 /. 0- .Q ((D (DD n . Q ' 0 N C N O O n [ V tND -c C I 3 n cD 0 to M"'t"N ci) n Cl (110 O ° lilt 'lei : CD 10••► • c Q (o Cl) O 54. c c4 n (D tn . . . E N Q V C3 4- '> i 4- a) a) = tsa) 3 � a) E 0 > N +- Q } a) C3 a)0 a a) ulimo 0_ } •N O 4 (D 0") 'E E a) .N _o Q M 'al I— 4- �c O O r4 c u > E N i i a) 0 • - - N 7- a) N Z D a) V '.� p •- O O D .0 0 NI7.)' Z _Q N 0 It a 0 en N 0) CE ;' � D U\ a) .a O Q c 0 O w NI } O 0 0 Q 0`� I -s- ue-- cN a) - QO c4- — . E O N -o Q E U < w m U U Q E . D © (I) v N 0 v v C ,) N a) v M . 40 �_ r J o " o, `o r J N in) O — so, CO M O O N a) a) coN D OS — Lo (I) N - 0- � D N r II CO tocY 2 ► • a 0 I- 1 O CO NO r ,0 -- 0 a : ;Cid 0 N 1 N M N r 0 r 0 d' `� M \ O O O O O O te O O O O O O O O O O O O O V) 0 L() 0 Lil CO N N r r {f} 40 N V C a 411 0 V. os ,O = r> -q �a 03 M N 06 p " u. . CAI try 0 c M O M Cs' 75 oN to t - C C 0 .. 0 II o r- a .� U) a6 O O - v ■ • cn o` M � Lo O Q: N N M 44 X o C ap 0 0 N +_ u O N N W O 0 O O 0 0 O 0 0 0 0 O O O O O in 0 L() 0 LO N N r-- r- 49. ® -b9- 4 • . /� N CA 44 PA I- a) bt a) 0 N Immo i -~ 144 a 0 a a)bt a) sv •N 0 0) ,� � • � E E .Z1 0 D c en c u .... -0 OD CV p a) N :'-' C -D 0 0 Cl) 0 N _ p a > 0) a 0 o O N 3 Z NC4 'EN O a O 0) 0) C- > a) •- CU s Q •o O 8 o ELu �+- u -o • `+- 0 a a Q a O N I N 0 C CU O .E O .� N - O g L... N E N E O 0 V Q w m U U Q D • O O -0 • • • ® Cl) 40 J '4 k[p General Fund 2013 - Finance ...:_. ., _±,- ..-771 i i . �' ' ►e ► NFORMA1 _ l�iNlye L W , ., :: i ^`i.. 1.I • I -ifi_ 00 I are ' , / .1 1!.P4 '•-70 ..-.,.,.. ..:2.7_,.__2:1t IA-I:I --' , ' :" - I I 4 wr II l'\I I , '�'7 t] (1 u 12012 Budget figik -§ r Advnerneni A 50%01 , . , -. ` .{ Inc Enelenon In Snantlei oa I l I i fp Scope of Services ---, immisii ....Services include: Act as "Front Desk" for Town Hall, providing information, billing inquiries/requests, telephone-answering. •:• Generate, process and manage —15,000 utility billing accounts. Budget & CAFR preparation/presentation. •:•Manage cash flow, accounts payable/receivable and investment functions. :•Provide services for other governmental entities (EVPLD). ....Provide internal/external reports to staff, public, Board and other interested parties. [P . Revenue 2013 $25,000 EVPLD accounting EVFPD accounting $20,000 •LETA/LMD admin fees $15,000 •Misc sales/services $10,000 $5,000 Total = $15,614 $0 2011 2012R 2013 $39,779 $16,080 $15,614 [p Expenses 2013 Personnel $251,917 0% #Operation & Maintenance $70,953 22% 78% 1 `i > ■Capital $0 Total = $322,870 Expenses 2013 $350,000 - Operations & Maintenance $300,000 / $70,953 $250,000 $200,000 Personnel $251,917 $150,000 $100,000 $50,000 IL Ai Total = $322,870 $0 2011 2012 R 2013 0% $381,747 $294,391 $322,455 ( / 78% 22% OP. Personnel Services 2013 Human Resources and $350,000 - payroll moved from Finance to $300,000 j: Administration in $250,000 / 2012. $200,000 $150,000 $100,000 $50,000 / 7 $0 z 0% 2011 2012R 2013 $317,148 $233,496 $249,955 78% 0o111111lPl' 2 Operations & Maintenance 2013 / Major O&M expenses include auditing, IT, $80,000 / County Treasurer fees, $70,000 / courier service, phone $60,000 - system, office $50,000 supplies/postage and a computer $40,000 replacement for the $30,000 Assistant Finance $20,000 Officer. O&M comprises 22% of $10,000 Finance expenses. $0 ' o% 2011 2012 R 2013 $64,599 $60,895 $72,500 78% 22 11111111111 pm Capital / 2013 $1 There are no capital $1 / expenditures $1 / budgeted in Finance in $1 / 2013. $1 / $1 / $0 / $0 / $0 / $0 / $0 2011 2012 0 2012 R 2013 78% $0 $0 $0 $0 1111 g Chan es Year Over Year Summary of changes included in this department are... • The most significant recent change in Finance was the migration of payroll and human resources from Finance to Administration (2012). This has resulted in lower reported costs in both personnel and O&M (in reality, the costs were moved to Administration (101 -1 300)). 11 1, rIlk r tf0:11:1 , :411111\ • CO • ; Wilk , W . i , O \''9.'t\ii _\ et , C:ril 4 5s 'i \ \„ tr....t ,,r,. \ i \ \\\\\I' , o IF of, • �;j • o }. a 0 rair)Qj - :14 III N 0 Aw E W N a CL) �$2611 o c O m OCD C O N 1- s V V 0) 1/2u T O N ill. UP) -0 N ° 3 TS >- E a0 O ,c O w c 0 N a N N E E O 0 V w 3 I a) ♦ ♦ ♦ ♦ ♦�• AL ® L.. L. •- CD s i 0 o 4- a) 3 a o cry C3 N 1 . i a. riil!1 +- 0 IZI1 111 0 4- o L Q N o c o . . 0 c c c a) c a) a) - 73 _c } u •c o •c o N o a) N N a) E c 3 tn _ o • o •- o } L R. L N o 46- 0 o 0 Q Q E • . • • ® V) I * I O tn.. in.' i- •E a. a `'' `+- •' > O s tn _ a. 0 N aD O T 0 v o a eild D a) -a '5 TI) c 42 = a c 0 u a w CO Q = w =E 0 a. 4-• iii ;• 1•04 41111 . , 0, - tilili011 c0 h. h O N 4. 4 iii"17,_. _ ,--- r O 0 0% I ed — co„ O co N It-$:1111 0 0 0 0 0 0 0 O O O O O O to 0 0 0 0 0 0 (-NiO 00 `O d' (to NI Q� • • N Q O s CA L L L_ O 14 -1 bt a) � 0 a)• � .- E ~ O 0 4 N Ita) CD o } N a a) �• a r"'� a •� 0 •- 0 CV u 4,7 o ° } ID" . L_ Q N tA O N E N lit c Q (1) a) - } } 0 _� D '■■� _V •C •C p V) • !� O u N E 0 a ik li •- 0 0 0 - a L (D L. (D OD •- 0 V N V L V E • • • • D E) V) 44 L 10/12/2012 AGeneral Fund 2013 EP , Community Development 1 Planning(1600) &Building Safety (2300) i t Estes Valley Congn•el,eusive Plan I t l 111.0.iPT. rp. 1 1 0 tl5F41uu! M f t+ 1 ' F . 11 A Scope of Services EP . Manning •:• Estes Valley Long Range/Master Planning Articulate a desired future to inform decision-making today. Current Planning Provide for coordinated/harmonious development of the Estes Valley. Administer/enforce local zoning & subdivision regulations and municipal code nuisance regulations Strive to obtain voluntary code compliance through education/outreach. l Staff support to Planning Commission, Board of Adjustment, and 1I Creative Sign Design Review Board 11 I Land Use Nuisances j Eliminate nuisances - waste accumulation, unsanitary conditions, noxious I; weeds,junk vehicles,trash/hoarding. I' + Administer/enforce local zoning & subdivision regulations and municipal code nuisance regulations it I Ili L 1 10/12/2012 A 2013 Highlights IP Planning ❖Add Code Compliance Officer/Planner I position. +Improve public access to geographic information, such as online access zoning, wildfire and geologic hazards maps. Hire a consultant to organize/update geographic data. •:•Analyze population, housing, land use, economic data/trends. Convert data to information to assist decision-making. +Continued outreach to Enhance Planning & Building Services. A Revenue Ep Planning $50,000 T— $45,000 A Lorimer County IGA $40,000 $45,998 $35,000 $30,000 — Charges for Services $25,000 $35,000 $20,000 $15,000 •Misc $400 $10,000 $5,000$ _ Total = $81,398 2011 2012 2013 Revised _- - 47=2fl 3—$80;410 398 2 10/12/2012 Personnel Services 41111111111110 fP Planning 2013 $350,000 2 full time staff and a 3/4 of the Secretary Ill and $300,000 Community Development $250,000 Director positions $200,000 $150,000 $100,000 li $50,000 $0 } 2011 2012 2013 Revised 82 $325,893 $275,410 $360,770 Operations & Maintenance EP Planning Division (1600) 2013 $1 20,000 Improve public access to geographic $1 10,000 information system. $100,000 $90,000 $80,000 Analyze population,housing,land use, $ ,000 economic data/trends. $60,0000 $50,000 $40,000 Enhance f tanning&Building Service $30,000 $20,000 $10,000 $0 ,2011 2012 2013 Revised $70,721 $78,137 $112,147 18% 3 10/12/2012 Scof Sers 4111111111111 Building Safety •:•Building Safety Promote a safe built environment to (1) minimize loss of life and injury to the general public and emergency responders; and (2) reduce property damage and destruction. •.•Addressing Enhance public safety through the easy and rapid location of properties by law enforcement, fire, rescue, and emergency medical personnel within the Town of Estes Park. •:•Floodplain Management Minimize death, injury, and losses to public and private property due to flooding. •SSignage Protect the health, safety, and welfare of the public by (1) ensuring the signage is safe and (2) is compatible with adjacent land uses and the total visual environment of the Estes Valley. [EP1, Scope of Services Building Safety •:• Administer local building, sign codes, and floodplain codes Building code consultation Permitting, plan review, and inspections Strive to obtain voluntary code compliance through education/outreach. 4 10/12/2012 2013 Highlights EP Building Safe •:Construction activity increased for 3 straight years (2010 — 201 2, increased permit activity (56% more permits) -� increased revenue. +Budgeted for $22,000 in additional revenue in 2013 over 201 2 original budget. Revenue likely to exceed projection. +Replaced the Plans Examiner position with Senior Building Permit Technician position (2012). +Review Addressing Geographic Information best practices, research/write grants to improve the Town's addressing system ❖Hire a summer intern to assist with increased summer activity. +Plan for continued community outreach to Enhance Planning & Building Services. Revenu LI -1111111 Building Safety $180,000 2013 $160,000 tt Licenses and Permits $1410,000 — $160,000 $120,000 $100,000 Fines$5,000 it $80,000 $60,000 I ■Misc$1,900 Total = $166,900 it 2011 2012 2013 Revised $173,654 $156,900 $166,900 II li 5 • 10/12/2012 EP Expenses Building Safety ty $350,000 2013 $300,000 n Operations& $250,000 Maintenance $77,751 $200,000 Personnel$346,882 $150,000 $100,000 $50,000 •Capital $2,500 $0 2011 2012 Revised 2013 Total = $427,133 $393,459 $397,138 $427,133 81 K 1% I8% Personnel Services EP Building Safety 2013 $350,000 3 full time staff and a 1/4 $300,000 of the Secretary Ill and Community Development $250,000 Director positions $200,000 $150,000 $100,000 $50,000 _4 _ $0 2011 2012 2013 Revised $344,481 $297,766 $346,882 ( •" 81% 6 10/12/2012 d1H Operations & Maintenance Building Safety 2013 $$90,000 Addressing best practices $90,000 - $80,000 Summer Intern $70,000 $60,000 ;� Enhance Planning & Building $50,000 Services $40,000 _ $30,000 _ $20,000 $10,000 $0 2011 2012 2013 Revised 18000. $48,979 $99,372 $77,751 III . I 111 I,I II it ai Il ll ll II l I'. Illl 7 10/12/2012 A Revenue & Expenses - Trends Planning& Building Safety $1,000,000 $900,000 — $800,000 +— $700,000 _,a Revenue $600,000 —P.Expenses $500,000 — $400,000 — $300,000 — $200,000$100,000 — $- 0 0 0 0 N `''' 0 N N N N N • 0 N A Expenses Planning Division Personnel Includes: 'Operation&Maintenance Include: Director(75%) Refer to next slide Senior Planner Code Compliance Officer/Planner I Secretary III (75%) $363,451 $112,147 76% 24% , 8 10/12/2012 I . . a ' ses by tegory Planning Division Professional Services/Fees $71,271 Materials&Supplies $19,870 Job Performance $13,799 Repair&Maintenance $ 5,952 Rentals $ 2,136 Materials& Insurance Premiums $ 1,955 Professional Supplies Utilities,Publishing,Other $ 1.100 Services/Fees 17% TOTAL PROJECTED EXPENSES $116,083 Job Performance 12% Repair&Maintenance 5% Rentals 2% Utilities,Publishing, \Insurance Premiums Other 2% 1% A 2013 oposed Expenses EP • Safety •Personnel Includes: ■Operations& Maintenance Community Development Director(25%) Refer to next slide Chief Building Official Building Inspector I Senior Building Permit Technician Secretary III(25%) $77,751 $349,562 18% 82% 9 10/12/2012 013 Expenses by Category iiiiiiilli Building Safety Professional Services/Fees $42,375 Materials& Supplies $1 2,750 Materials& Job Performance $ 9,460 Supplies Job Repair& Maintenance $ 8,463 22% Performance 18i° Rentals $ 2,136 Insurance Premiums $ 2,327 Repair& Utilities $ 240 Maintenance 14% Professional Services/Fees TOTAL PROJECTED EXPENSES $77,751 48% Rentals 10% —_Insurance Premiums 3% Utilities 0% 10 [P eneral Fund 2013 - Police ,, Ili IMik gas- ma , 0 . _ _____„,,--, i if ,g Afo,,,[ti 1 N` ..3.. • . lam+ e` ) ,,,iii }; I7 C: 1 • ' .a. 'L4 i '''''1' ;:...-1-.." tr- Scope of Services/ Patrol Administration - Community presentations, employee development and recruitment strategies, strategic planning, policy development, mutual aid agreements, budget preparation, maintenance of State Professional Standards, LETA Board Member, Victim li Services board member, Estes Valley Community Services representative, State Council board member for Restorative Justice. �PsScope of Services/ Patrol Patrol Services - 24-hour patrol services, criminal and accident investigations, traffic enforcement and DUI enforcement, zone policing, neighborhood watch, vacation checks, crime prevention, traffic studies, special events, parking enforcement, accident investigation for Town owned vehicles, court liaison, Emergency Response Team, Emergency Management, enforcement of all state laws and municipal ordinances. Investigations - Felony crime investigations, internal affairs, drug investigations, juvenile crimes, property crimes, missing persons, crimes against persons, liquor license inspections, evidence and property storage and management. p Scope of Services / Support Services Support Services - (Dispatch, Records) . Maintain 24/7 communications for: •Estes Park Police •Estes Park Fire District •Glen Haven Fire •Rocky Mountain National Park Service •Estes Park Municipal Services •Medical Center Ambulance Service •Colorado State Patrol •Larimer County Sheriffs Office (limited) •Division of Wildlife Crime data entry, CBI monthly reports, maintain all Law Enforcement Records, monitor department reporting requirements, responsible for front desk customer services, Court document management and archiving of reports. f Sco e of Services / Community �p p Services Community Services - Community and volunteer services, chaplain services, front desk volunteer program, records volunteer program, Restorative Justice program, RJ state counsel board member, Larimer County Corrections board member, adult crimes, parole reintroduction program, juvenile status offenders, grant- writing, management of 20 Auxiliary volunteers, management of 30 RJ volunteers. mployees / Seasonal and Volunteers SWORN NON-SWORN Chief Community Services Manager Operations Commander Communications Supervisor Administrative Sergeant Executive Assistant 2 Patrol Sergeants Restorative Justice Case Worker 2 Investigators 6 Dispatchers 11 Police Officers Records Clerk School Resource Officer SEASONAL EMPLOYEES Seasonal Records Clerk 4 Community Service Officers 19 Sworn Officers VOLUNTEERS 1 1 Non- Sworn Employees 30 Restorative Justice Volunteers 20 Auxiliary Volunteers ile 5 Seasonal Employees 2 Chaplains EP otal Revenue 2013 1111 2013 $250,000 ■ Patrol $200,000 $150,000 Dispatch $100,000 - ■Community Svcs $50,000 -' Total = $222,567 $0 ' - 2011 2012 2013 $427,929 $258,884 $222,567 Revenue Sources mai • Parking Permits/Parking Tickets • Animal License/Impounds • Bullet Proof Vest Grant • Click It or Ticket Grant • Colorado Department of Transportation DUI Enforcement Grant • Traffic Summons / Fines • False Alarms/Fingerprinting/Portable Breath Testing • Police Security Services • Intoxilyzer / DUI and Drug (DUID) Restituti-o_n fr-om=Cour=ts= - -• Dispatch Services —Hospital & Fire District • Restorative Justice Grants • Police Record requests • VIN Checks • Total Expenses 2013 Operations & Maintenance $562,079 $3,000,000 $2,500,000 / Personnel $2,653,879 $2,000,000 $1,500,000 / ■Capital $0 $1,000,000 $500,000 / 83% $0 / 2011 2012 2013 $2,927,761 $2,747,719 $3,215,958 Total = $3,215,958 [[P Personnel Services 2013 $3,000,000 ZZ $2,500,000 $2,000,000 83% $1,500,000 $1,000,000 $500,000 j / $0 2011 2012 2013 $2,463,244 $2,281,445 $2,653,879 EP Operations & 1aintenance 2013 $600,000 $500,000 $400,000 o*. - , . 17% $300,000 $200,000 $100,000 $0 2011 2012 2013 $459,443 $466,274 $562,079 EP igh1ights for 2013 111M Police Department Re-organization : ► Re-instate vacant Police Officer position ("On Hold Status" since 2005) ► Addition of Communications Supervisor— Bringing Sworn Sergeant back down to patrol unit to create Administrative Sergeant • 1/2 Salary of RJ Case Worker — has been grant funded for ten years ► Re-instate fourth Community Service Officer (CSO) absolute minimum for working down town area. , Questions? 10/12/2012 6 • a eral Fund 2013 - Engineering .- fir+j,` i.i E is - I I i i 1 \ew it i.� . J. •_ Jy �er_ EP Scope of Services Handles oversight of Public Works capital projects. + Issues RFPs, administers contracts,organizes and directs engineering design teams. + Authorizes construction in public Right of Ways. Reviews development plans and building permits for compliance with Town standards. Provides engineering guidance for Public Works improvement projects for drainage,streets and parks. I 111 + Transportation engineering & long-range transportation planning Ii with state and federal agencies. 1 I l l 1 1 10/12/2012 rEP 1115013 Highlights 9.1111111111, Summary of changes for 2013 in this department are... d• Development Standards Manual update. Engineering guide of details and standards,compatible with Larimer County, that consultants and contractors will reference when working on Town projects. •:•Continued public outreach for developing alternative funding methods to sustain and maintain public infrastructure,streets and storm drainage. •:•Elm Road environmental planning and approval of landfill leachate with the Colorado Department of Public Health and Environment. •:•Design of Dry Gulch Road reconstruction for 2014 replacement. fp evenue • $1,000 2013 $900 - $800 $700 $600 II Sales of $500 Maps/Publications $50 $400 - $300 $200 $1001 '— Total = $50$0 2011 2012 2013 $33 $100— $50 2 10/12/2012 Expenses limiligill 2013 $80,000 $70,000 ■Operations&Maintenance $60,000 $72,570 $50,000 $40,000 Personnel $58,960 $30,000 $20,000 Total = $131,530 $10,000 $0 2011 2012 2013 45% $84,286 $129,634 $131,530 55% 0111111114 Personnel Services 1111 2013 A percentage of the $60,000 expense for the Director of Public Works&the $50,000 Public Works Civil $40,000 Engineer is charged to the Engineering Account. $30,000 [_____h[. Personnel Services comprises 45%of total $20,000 engineering expenses. $10,000 $0 45% 2011 2012 2013 $44,340 $54,662 $58,960 3 • 10/12/2012 P Operations & Maintenance $80,000 2013 Major expenses in $70,000 Operations& $60,000 Maintenance include $SO 000 the Development Standards Update and $40,000 the Pavement Index $30,000 } Update. $20,000 $10,000 $0 2011 2012 2013 $39,946 $74,972 $72,570 ss/• E� 2013 Highlights Summary of changes for 2013 in this department are... •:• Development Standards Manual update. Engineering guide of details and standards,compatible with Lorimer County, that consultants and contractors will reference when working on Town projects. •:•Continued public outreach for developing alternative funding methods to sustain and maintain public infrastructure,streets and storm drainage. •:•Elm Road environmental planning and approval of landfill leachate with the Colorado Department of Public Health and Environment. •:Design of Dry Gulch Road reconstruction for 2014 replacement. 4 10/12/2012 Li General Fund 2013 - Streets I . i •11."11114 } 11 U i-' z1R I-If 11l .+wow._..,. - i tat , * 'lam i F ', 1L '� •� � JCS, '�. r p t , .T ' .� SL of rs.' dlOrl-ML.,_ :' u... EPI Scope of Services Responsible for 57 miles of roadway including snow removal, street sweeping, striping and street maintenance programs, and over 100 miles of drainage ways and roadside ditches. Oversees and coordinates high-water events. •S Three full-time staff members in the department and several seasonal employees hired during the summer months. •.• Replaces and maintains thousands of signs within Town limits, installation and removal of seasonal signs, and installation of traffic control signs during special events. Cleans parking lots and streetscapes and maintains roadway bridges and culverts. 1 10/12/2012 A - 2013 Highlights Summary of changes for 201 3 in this department are... •:• Purchase of a mini excavator for projects such as digging asphalt patches, culverts and ditches. •S Update pavement conditions index. •S Addition of a hydraulic snowblacle attachment for parking lots. • Funding reserve for Dry Gulch Road reconstruction in 2014. I Revenue iG 2013 $300,000 Licenses& Permits $1000 $250,000 HUTF(Highway Users Trust $200,000 - Fund) $252,886 ■Motor Vehicle Registrations $150,000 $26,000 $100,000 A Road& Bridge $60,000 $50,000 Other(recycling rebates, $0 _ work orders) $0 2011 2012 2013 Toia1—$339,886 $354,924 $343,993 $339,886 2 10/12/2012 11.0 fP Expenses 2013 r Operations&Maintenance $1,400,000 $702,762 $1,200,000 Personnel $414,007 $1,000,000 $800,000 $600,000 •Capital $67,500 $400,000 $200,000 Total = $1,184,269 11111 $0 2011 2012 2013 3s% 6% $1,139,255 $2,262,768 $1,184,269 59 EP Personnel Services 2013 A percentage of the expense for the $500,000 Director of Public Works,the Public $400,000 Works Superintendent, Civil Engineer,and $300,000 office personnel is charged to the Streets $200,000 Account. 100%of Streets Division staff $100,000 comes from this account. $0 2011 2012 2013 35% $401,904 $401,535 $414,007 3 • 10/12/2012 f OperationsMaintenance12013 Major expenses $800,000 include maintenance contracts,materials, $700,000 striping, storm $600,000 drainage, traffic signs • $500,000 maintenance and $400,000 replacement,vehicle $300,000 equipment and fuel, downtown trash $200,000 disposal,streetlight $100,000 — - utility fee,and future $0 vehicle purchases. 2011 2012 2013 (411/1/kb' $584,661 $661,131 $702,762 59 fp _ Capital 2013 Capital expenses in $1,400,000 2013 include $45,000 $1,200,000 for a mini excavator, $1,000,000 $20,000 for a new snowblade and $800,000 $2,500 for a wide- $600,000 format color printer. $400,000 $200,000 $0 �� 2011 2012 2013 a/ $152,691 $1,200,102 $67,500 4 I t • 10/12/2012 111111111,1111111 P 2013 Changes Summary of changes for 201 3 in this department are... •:• Purchase of a mini excavator for projects such as digging asphalt patches, culverts and ditches. Update pavement conditions index. •:• Addition of a hydraulic snowblade attachment for parking lots. Funding reserve for Dry Gulch Road reconstruction in 2014. 5 10/12/2012 EP Geral Fund 2013 - Parks 1111111‘ xA t. rr - - 'T -,� �`' iV Hi. .s .34 'j11z 1• ,, , • i►. EP Scope of Services Responsible for the maintenance, renovation and management of all Town-owned park land. ri •:• Approximately 38,000 annual flowers planted each year in addition to 8,000 perennial flowers. II !I •:• Maintains own greenhouse, 10 acres of turf, 32 irrigation systems, 0 53 flower beds and 7 bronze statues. il •:• Cares for the Estes Park Area Historical Museum property,Stanley ii Park Fairgrounds, Light& Power Building grounds,open spaces,Estes i i. Park welcome signage and the downtown area. I II1 idll •:• Assists in snow removal during winter & spring months. II I I I 1 I 10/12/2012 1071111 ighlights Summary of changes for 201 3 in this department are... Further development of Bond Park landscape areas.Assisting in design and development of Bond Park next phase. d• Overseeing design and construction of irrigation system at Stanley Park Fairgrounds. Further investigation and mitigation of trash issues with bears. Expenses 2013 n Operations& Maintenance $600,000 - $412,034 $500,000 Personnel $588,876 $400,000 $300,000 ■Capital $3,500 $200,000 IN $100,000 Total = $1,004,410 $0 2011 2012 2013 59% 0% $854,278 $985,867 $1,004,410 4 41%a 2 10/12/2012 A EP Personnel Services 2013 $600,000 Includes five full-time employees, 16 $500,000 seasonals and a $400,000 portion of the salaries for the Public Works $300,000 Director and the Public $200,000 Works Superintendent. $100,000 $0 59 2011 2012 2013 $484,912 $553,591 $588,876 P . Operations & Maintenance $420,000 2013 $410,000 Major expenses $400,000 include maintenance $390,000 1 - - contracts,maintaining trees and plants,and 7$380,000 11 vehicle equipment. $370,000 $360,000 $350,000 $340,000 2011 2012 2013 $367,252 $413,776 $412,034 ftilii 41% 3 10/12/2012 ril Capital 2013 $20,000 Capital expenses in $18,000 add include $16,000 scheduled Bobcat $14,000 exchanges. $12,000 $10,000 $8,000 $6,000 $4,000 —LI_ ------------- $2,000 0 io $0 2012 2013 2011 $2,114 $18,500 $3,500 1111111, um 2013 Highlights Summary of changes for 2013 in this department are... •• Further development of Bond Park landscape areas.Assisting in design and development of Bond Park next phase4. . Overseeing design and construction of irrigation system at Stanley Pork Fairgrounds. •y Further investigation and mitigation of trash issues with hears. 4 10/12/2012 LGeneral Fund 2013 - Buildings Ill eilli. kill'IN ,.::''''„.„..._. _ ..„ ,. . gig J 1 is It , - ,,,, A 4 IP, '-el pa lc 1 .er , gliniiii"rA' I'S I , .. ►i P Scope of Services Manages all publicly owned buildings, which consists of over 20 structures. Maintains all the contractual documents for services and administers specific contracts for annual maintenance contracts of numerous building services. ❖ Oversees the operation of a complex variety of systems: •.• Plumbing •:• HVAC •.• Electrical •.• Structural/finishes Operates and manages Downtown trash collection, Elevators, Public restroom cleaning, Carpet cleaning, Recycle container collection, Fire extinguishers,Building security. 1 10/12/2012 2013 Highlights Summary of changes for 2013 in this department are: • Increase in janitorial services for both municipal building and public restrooms, in response to public complaints. System wide facility assessment. • Design and construction oversight of Public Works& Utilities office remodel. • Addition of one full-time position of Facilities Manager. P Revenue $140,000 2013 $120,000 •Building Rent $130,201 $100,000 $80,000 Employee Housing Rent $42,241 $60,000 — •RM Park Inn F&B $40,000 Concession$24,000 $20,000 Total = $196,442 $0 2011 2012 2013 $186,770 $173,342 $196,442 2 10/12/2012 1110 Expenses 2013 •Operations& Maintenance $700,000 $619,899 $600,000 Personnel $122,718 $500,000 $400,000 $300,000 •Capital $22,500 $200,000 $100,000 Total = $765,117 $0 tbi 2011 2012 2013 3'%0 $527,802 $580,459 $765,117 81% Personnel Services 2013 A percentage of the expense for the $140,000 Director of Public $120,000 Works&the Puc $10,000 Works Civil Engiblineer is 0charged to the $80,000 Buildings Account. $60,000 Personnel Services $40,000 comprises 1 6%of total buildings $20,000 expemnses. $0 tei 2011 2012 2013 $32,614 $36,187 $122,718 3 • 10/12/2012 EP Operations & Maintenance 2013 $700,000 Included in this category are building $600,000 maintenance,insurance $500 000 premiums,maintenance contracts,janitorial $400,000 supplies, and utilities. $300,000 Operations& Maintenance comprises $200,000 81%percent of $100,000 Buildings expenses. $0 2011 2012 2013 $495,188 $536,772 $619,899 81% fP Capital1111$25,000 2013 Capital is allocated $20,000 for FF&E costs for remodel of the Public $15,000 Works offices. Capital comprises 3%of total $10,000 Buildings expenses. $5,000 $0 2011 2012 2013 si $0 $7,500 $22,500 • 10/12/2012 mom, Ujahlights Summary of changes for 201 3 in this department are: •+ Increase in janitorial services for both municipal building and public restrooms,in response to public complaints. ❖ System wide facility assessment. Design and construction oversight of Public Works& Utilities office remodel. Addition of one full-time position of Facilities Manager. 5 10/19/2012 pedal Revenue Fund 2013 - Community Services 1:141 4114111H: • 2,, Lit f 1iw •)s P M ' 1 � Revenue = $71 2,81 3 jlism Transfers (In) = $1,957,979 Expenses = $2,689,836 IU) jr—a CS Scope of Services ❖Special Revenue Funds •:•Includes 4 divisions providing non-traditional services which have as financing sources generated income and a General Fund transfer: Visitor Services ❖ Senior Center •:• Fairgrounds/Events +Museum 19.79 FTE Staff •:•340 Volunteers •:•Discontinued Funds: Sales and Marketing and Conference Center are no longer a part of this fund 1 10/19/2012 Iii,LIAVomm. Services 2013 Highlights ': 2013 Fund balance projected at 1% (policy is not to exceed 5%) •:`Visitor Center budget increased with addition of shuttle system to budget (formerly in separate account) •:•General Fund Transfer increase -$1,900,000 •:•One additional FTE Coordinator for Shuttle System Mgt. ' One additional FTE Clerical to assist Community Services Coordinator Ettiommunity Services Revenue 2013 i'Interest$1,500 $800,000 — $700,000 Charges for Services $600,000 $617,087 $500,000 `Miscellaneous $400,000 -" $60,851 $300,000 If Grants/Awards $200,000 $6,875 $100,000 ■Rentals$26,500 $0 _ �7 2011 2012 2013 $1,265,988 $825,007 $712,813 Total = $712,813 • 10/19/2012 Ep CS Revenue byDivision fir $600,000 r— $525,000 $450,000 2013 $375,000 — — $300,000 Total $712,813 $225,000 $150,000 $75,000 $0 E �00 q b00 '1q1 b.\b b00 anti' ,5 b0' h'b' r V • §O (<o ep_ Community Services Expenses 2013 $2,000,000 O&M$1,460,529 $1,500,000 Personnel$1,066,923 $1,000,000 $500,000 . 11 Total = $2,527,452 $0 42% 2011 2012 2013 $2,571,240 $2,854,176 $2,527,452 58% 3 • 10/19/2012 CS Operations & Maintenanc 2013 Includes insurance $1,600,000 Iii premiums, $1,400,000professional services, publishing, $1,200,000 rentals,repair& maintenance, $1,000,000 $800,000materials& supplies, $600,000job performance $400,000expenses,utilities& $200,000 other. $0 2011 2012 2013 $1,131,757 $1,151,710 $1,460,529 fP ommunity Services Personnel • $1,600,000 $1,400,000 /� $1,200,000 $l,000,000 2013 $SOo,000 Includes 19.79 FTE $600,000 staff salaries and $400,000 benefits. $200,000 II 1 / $0 2011 2012 2013 1,515,269 $1,141,823 $1,066923 4 10/19/2012 LComm. Services 2013 Highlights •A201 3 Fund balance projected at 1%(policy is not to exceed 5%) •:•Visitor Center budget increased with addition of shuttle system to budget (formerly in separate account) •)General Fund Transfer increase - $1,900,000 +One additional FTE Coordinator for Shuttle System Mgt. •:•One additional FTE Clerical to assist Community Services Coordinator I• ( peciai Revenue Fund 2013 -Visitor Services ., .. , , ,: „,,,.. , , ,,, • I{ 1 �It M : . 1 L I ¢ 1 IP' .i. �_ --1 �1 U _ , : ��_ie I !s I �� 1 --.."17 4, ' al j.: 1-GTAAISE' ' * ,.. 1 I 1 \ 1 ,..„; a 5 10/19/2012 t Visitor Serv. Scope of Servic Services include: •:• Assist walk-in visitors and callers seeking information •:• In cooperation with the Visit Estes Park, promote area events & activities •:• Create & distribute informational materials +Limited retail sales of Estes Park-related merchandise •.• 6.14 FTE Staff •:• 65 Volunteer Ambassadors `:•Coordinate Town Shuttle System isitor Services 2013 Highlights •:•Shuttle system budget is now included in Visitor Services budget •:•New signs needed to better assist guests with parking and direction at the Visitor Center •:•New employee for Shuttle System 6 10/19/2012 P Visitor Services Revenue 2013 •Charges for Services $40,000 $39,500 $35,000 $20 000 _ $25,000 Miscellaneous$0 $20,000 $15,000 $10,000 $5,000 00 Total = $39,500 $0 2011 2012 2013 $79,891 $42,100 $39,500 E Visitor Services Expenses in 2013 $600,000 = -O&M$508,405 $500,000 = $400,000 = Personnel$291,128 $300,000 Total = $799,533 $200,000 $100,000 = $0 = 2011 2012 2013 36% $341,760 $371,038 $799,533 64% 7 it 10/19/2012 P VS Personnel Servi cep 2013 Visitor Services has $300,000 / 6.14 FTEstaff, including a mgr., $250,000 L info. specialists, $200,000 seasonal phone operators and a $150,000 / shuttle coordinator. / Personnel costs $100,000 / make up 36%of $50,000 _ ' total Visitor Services j expenses. This is $0 / up due to the shuttle budget addition.2011 2012 2013 $212,110 $230,210 $291,128 36%___ ITVisitor Services O&M 2013 Included in this category are insurance premiums, $600,000 7 professional fees, $500,000 / _____ •Iv publishing, rentals, repair& maintenance, $400,000 7 materials & supplies, $300,000 7 job performance expenses, utilities, & $200,000 7 other. O&M $100,000 / comprises 64% percent of Visitor $0 Services expenses 2011 2012 2013 with the addition of the $129,650 $135 21 1 shuttle=budget- $508,405 64% 36% 8 10/19/2012 03 isitor Services 2013 Highlights +Shuttle system budget is now included in Visitor Services budget •:•New signs needed to better assist guests with parking and direction at the Visitor Center I tIpecia1 Revenue Fund 2013 - Senior Center i .44. " . , -.4,9" 1 1 .t. It - r i t x,.: . . ;. li! , , ; ■ice`,`;� 9 10/19/2012 V, Senior Center Scope of Services +Services include: •:• On-site dining, take-out meals, Meals on Wheels •:•Information & referral services •:• Health & wellness classes, adult education& recreation opportunities on and off site •:•Facility rental & public meeting space •:•2.18 FTE Staff •:•100 Volunteers ilSenior Center 2013 Highlights ❖The Senior Center is reviewing proposals for a master plan with the Museum. No new construction on the facility is scheduled until this process is complete. (There was a plan in place to remodel the dinning area) ❖Increase in food service contract to cover meals provided to customers on sliding scale. This increase represents funds lost by provider :•United Way is not giving as much as in the past and staff is budgeting $5,000 less in revenues ❖New Senior Expo Planned ❖Increase Senior Center Coordinator to full time 10 10/19/2012 fp Senior Center Revenue 2013 •Grants/Awards $6,875 $60,000 $50,000 •Charges for Services $40,000 $28,772 (program fees) $30,000 ■Misc. $25,150(rentals, $20,000 fundraisers, United rz Way,SC Inc., coffee $10,000 fund,van use) • $0 �� 2011 2012 2013 Total = $60,797 $72,809 $64,702 $60,797 fI H Senior Center Expenses 111 2013 $250,000 0 & M$136,801 $200,000 IPersonnel $147,259 $150,000 Total = $284,060 $100,000 $50,000 52% $0 I 2011 2012 2013 /' $229,761 $229,336 $284,060 48%I 11 10/19/2012 P Senior Center Personnel Services 2013 Includes 2.18 FTE $150,000 / staff(a manager, $125,000 coordinator and on-call van $100,000 / drivers). $75,000 Personnel costs are 52% of Senior $50,000 / — Center expenses. $25,000 $0 / 52% 2011 2012 2013 $117,480 $115,267 $147,259 f' C Operations & Maintenance Included in this 2013 category are insurance premiums, professional $140 000 fees/services, publishing, $120,000 repairs/maintenance, $100,000 materials/supplies, job $80,000 performance $60,000 expenses,and utilities. 0& M comprises 48% $40,000 of Senior Center $20,000 expenses. $0 2011 2012 2013 $112,281 $114,069 $136,801 48% 12 10/19/2012 [ jenior Center 2013 Highlights ❖The Senior Center is reviewing proposals for a master plan with the Museum. No new construction on the facility is scheduled until this process is complete. (There was a plan in place to remodel the dinning area) ❖Increase in food service contract to cover meals provided to customers on sliding scale. This increase represents funds lost by provider ❖United Way is not giving as much as in the past and staff is budgeting $5,000 less in revenues ❖New Senior Expo Planned ❖Move Senior Center Coordinator to full time Special Rev. Fund 2013 - Fairgrounds/Events 4 ,. ,,,, _,0.1,,, , ._, Fr- - , „, -,, w „...„-",,.. _ - .. . hF JJ- \ 4 I it, 4 A , , c. 4P.- 1"'""6-- i 'I-./ .':',,i 4,... ''.- '.•'II .*� • HE HIGHLAND DRAB]_ R y {F_ .44. ;r 1 ! r 4.CY rI1 f. fts r 4y ,..07 4 13 10/19/2012 EP /EScopeofServices 711 •:•Services include: :• Plan/execute Town events like Jazz Fest, Rooftop Rodeo and Wool Market •:• Assist with local events like Scottish-Irish Fest, Labor Day Crafts Show and Scandinavian Festival •:• Coordinate use of Fairgrounds, Performance Park,etc. •8 Support destination shows like Hunter-Jumpers + Solicit new events •:4 Maintain facilities • 8.96 FTE Staff •:•1 10 + Volunteers lairgrounds/Events 2013 Highlights •:•MOU with Western Heritage will change expenses and Revenues. This change will have a minimal effect on the bottom line. •3With proposed new stall barns,staff is anticipating more vendors for Wool Market as well as bringing in new events to use the facility - increase in revenues. •:•Vinyl fence repair expense +Lease water truck - $4500 per month for 1.5 months instead of purchase new truck +Acid 1 FTE Clerical to assist with Community Services Coordination 14 10/19/2012 bFairgrounds/Events Revenue 2013 Charges for Services $545,365 $600,000 -Z I $500,000 $400,000 -7 Rentals and Donations $26,500 (on-site bldg $300,000 -7 rental,off-site events $200,000 � venues,fireworks donations) $100,000 ■Misc.$26,751 $0 allP ' (Sponsorships, PRPA econ dev grant) 2011 2012 2013 $581,715 $599,945 $598,616 Total = $598,616 E Fairgrounds/Events Expenses 1 2013 $800,000 O & M$718,838 $700,000 $600,000 0 $500,000 Personnel $461,302 $400,000 $300,000 Total = $1,180,140 $200,000 $100,000 0 , $0 39% 4" 2011 2012 2013 $1,088,993 $1,120,718 $1,180,140 61% 15 10/19/2012 P F/E Personnel Services 2013 Fairgrounds/Event proposes 8.96 FTE staff,including a / mgr., foreman, $600,000 / events coordinator, events worker, $500,000 / �-- proposed clerical $400,000 .asonalersonnel $300,000 I--- costs make up 39% / workerstotalsFairgProunds/ $200,000 / Events ande of expenses. $100,000 / $0 49% 2011 2012 2013 I I $407,561 $412,609 $461,302 f /E ance Operations & Maintenance 2013 Included in this category are insurance premiums, $800,000 V7 _ professional fees, ill $700 000 publishing, rentals, , 2 $600,000 real property, repair & $500,000 maintenance, materials & supplies, $400,000 job performance $300,000 expenses, utilities, $200,000 and other. 0 & M $100,000 2 / comprises 61% of F/E $o / expenses. 2011 2012 2013 $681,432 $708,109 $718,838 r , 61% 16 10/19/2012 F grounds/Events 2013 Highlights :•MOU with Western Heritage will change expenses and Revenues. This change will have a minimal effect on the bottom line. •:•With proposed new stall barns, staff is anticipating more vendors for Wool Market- increase in revenues. •:•Vinyl fence repair expense :•Lease water truck-$4500 per month for 1.5 months instead of purchase new truck •:•Add 1 FTE Clerical to assist with Community Services Coordination T !Special Revenue Fund 2013 - Museum 1 .tir • ii JIr� Jy rJ17 _ . eZ 1% ,A`. J i 7 _ 6 17 10/19/2012 Museum Scope of Services •:•Services include: •:• Permanent, temporary&off-site exhibits •:• Education programs, research assistance, web site management Collections management •:• Fall River Hydroplant •:• Knoll Willows Property (primarily structures) :• Facility rental & public meeting space •:• 2.51 FTE Staff •:• 55 + Volunteers EP Museum 2013 Highlights •:•New Brochure produced —(enough for 2 years) ( 9 Y ) :•Proposed temporary Collection Assistant (1A time) •:•Master Plan with Senior Center •:•Addition of Collection Inventory Assistant .25 FTE 18 10/19/2012 P Museum Revenue gm, 2013 $20,000 -7 R Grants$0 $18,000 -� $16,000 -7 $14,000 1 Charges for Services $12,000 $3,450 $10,000 $8,000 I Hiri ■Other $8,950 (rent, $6,000 _ donations,Museum $4,000 Friends support) $2,000 $0 Total = $12,400 2011 2012 2013 $21,677 $12,760 $12,400 i_t) Muum Expenses all 2013 $180,000 _ l'0& M $96,485 $160,000 $140,000 Personnel$167,234 $120,000 $100,000 Total = $263,719 $80,000 $60,000 $40,000 $20,000 $0 - 36% 2011 2012 2013 $250,435 $250,168 $263,719 64%J 19 10/19/2012 P Museum Personnel Services 2013 2.51 FTE personnel includes a mgr/ $200,000 exhibits curator, $180,000 7 educ./collections $160,000 / curator,proposed $140,000 / temp. inventory $120,000 / assistant,and a $100,000 / seasonal. Personnel $80,000 / Services comprises $60,000 / $40,000 / 1 64%of total $20 000 / / Museum expenses. $0 64% 2011 2012 2013 I $162,676 $166,727 $167,234 EP Museum O&M 2013 / Included in this category $100,000 / are insurance premiums, $90,000 / professional fees/ $80,000 services, publishing, $70,000 $60 000 repair/maintenance, $50,000 materials/supplies, job $40,000 pfmnne 111 $30,000 ander utilities. O & M $20,000 comprisesor 36 ce%expe percent s s, $10,000 / of Museum expenses. $0 2011 2012 2013 36% $82,610 $83,441 $96,485VII 20 10/19/2012 E Museum 2013 Highlights ❖Proposed temporary Collection Assistant(1/4 time) •:•Master Plan with Senior Center :•New Brochure produced — (enough for 2 years) •:•Addition of Collection Inventory Assistant .25 FTE Thanks for your time Community Services Department 21 10/19/2012 Town of Estes Park ill ; II roposal ,41 fltrae 22 10/19/2012 R. The Shuttle Committee111 This committee met throughout 2012 to study and make suggestions to improve what has already become a very successful free shuttle system in Estes Park. The group met to examine and evaluate: • The routes • Schedules • Signage • Printed materials used to promote the system •Suggestions for the 2013 Free shuttle season. The committee's membership is comprised of representatives from all facets of the public and private sector. fP . Shuttle Committee Participants Jerry Miller—Chairman Mark Elrod —Town Trustee John Hannon —Rocky Mountain National Park Lindsay Lamson—Visit Estes Park/Destination Marketing Organization Lynette Lott— Estes Area Lodging Association (EALA) Sandy Osterman—Ambassadors Julie Pieper—Downtown businesses Gary Van Horn—Estes Park Center YMCA of the Rockies Joe Walsh— Rocky Mountain Transit Management Town of Estes Park Staff: Lowell Richardson — Interim Town Administrator Bo Winslow—Coordinator, Community Services Department Kate Rusch— Public Information Officer Teri Salerno —Manager, Visitor Services Laurie Button—Administrative Support Brian Wells—Shuttle Coordinator 23 10/19/2012 Transportation Scope of service 2013 Proposed Services Seasonal shuttle service for 5 routes (Red, Blue, Silver, Brown and a downtown Trolley) serving 58,853 people in 2012, a 3.5% increase over 2011. 1 Special Charters for Longs Peak Scottish-Irish Festival, Autumn Gold, Elk Fest, Catch the Glow Parade, Rodeo Parade, Winter Fest, Conferences & training, and other misc. requests. A Transportation EP 2013 Changes IE;Z+ Per Shuttle committee recommendation, $90,000 was added to the budget to pay for the following additions; • 10 additional days of service = 83 days • 1 additional hour in the evening for the brown route • Addition of a Downtown only trolley route • Addition of Full Time Shuttle Coordinator 24 10/19/2012 A Proposed 2013 EP • Shuttle Calendar !Q 83 Full Service Days • June 21 through September 8, 2013 (New for 2013 June 21-27) • September 13-15 (New for 2013) Service Times • Red, Blue. Silver &Trolley: 9:00 a.m. to 10:00 p.m. • Brown: 8:00 a.m. to 10:00 p.m. (New for 2013 9:00-10:00 p.m.) vw Special Weekends & Events • Winter Fest(Jan. 18-20) (New for 2013), Scottish/Irish Festival & Parade (Sept. 6-8), Fine Arts & Crafts (Sept. 14-15), Elk Fest(Sept. 28-29), Catch the Glow Parade (Nov. 29). I EP Downtown Trolley wd Dedicated downtown route • 12 stops, utilizing previous stops from 2011 and 2012. • No set schedule but arrival times at each stop will be estimated using the real time tracking system. • Route begins at the Estes park visitor center and goes west to just beyond Mtn. Sage inn before returning to the EP Visitor Center. ';; Service times: 9:00 a.m. to 10:00 p.m. Added Benefits • Eliminates the delays that the red route experienced. • Trolleys tend to "attract" riders for nostalgic and entertaining reasons. • Potential for advertising revenue to offset expenses. 25 10/19/2012 Li Downtown Trolley * III: 1�'�' 1 1 0 43* * 4, ® ; "� **** fP H Estes Park **,** y *,**41** I= •�v, Visitor Center 13 ,E 4T17 0 I III ► ►►► St 5 ►► Barlow Plaza r 1 Estes Park Visitor Center 7 Mountain Sage Inn 2 Bond Park 8 Elkhorn lodge 3 Local's Grill 9 Mrs. Walsh's garden 4 Ore Cart Rock Shop 10 grub steak 5 Tregent Park 11 Trading post 6 West Park Center 12 Barlow Plaza [' Service Comparison Year Service Days Service #of Routes With Hours Riders 2013 83 5478 5 2012 81 4464 4 58,853 2011 79 2992 4 56,908 2010 68 1952 3 30,008 26 10/19/2012 Local vs. Guest RI Mk Ridership Total Riders 25000 • focal Guests 20000 II MI Guest _____________ ■Local \- / 15000 10000 ■ III 000 0 , Red Blue Silver Brown 4 ' Visitor Services 2013 ill....91 fP - • Transportation .T. . IIII Si - : L : - ,. ` I OR Proposed innigi In'Plirmi "'''''"''' i' .• Revenue = $ 0 " -¶E.'''' Expenses = 343,700 27 10/19/2012 EP Shuttle Breakdown 111 • Total 2013 Shuttle Base Only $ 240,868 • 2013 Proposed Additions $ 26,738 • Additional Shuttle Expenses $ 3,100 • Proposed Trolley Expenses $ 68,346 • Misc. $ 4648 28 10/19/2012 ILYnterprise Fund 2013 - Light & Power UMW t ! P T- •oit ri • Tf • '' • :11 S r R Beginning Fund Balance: $ 7,067,915 + Projected Revenues: $13,219,167 - Projected Expenses: $1 3,076,290 I .y, -Transfers Out: $ 1,316,601 4 N Ending Fund Balance: $ 5,894,191 it . 1,1 III Scope of Services Services Include: •:• Light& Power employs 26 people including line crew, administration and finance/billing services. •:• We provide electric power to approximately 10,000 accounts, including service to Rocky Mountain National Park. •:• Light& Power maintains over 300 miles of distribution lines and constructs new infrastructure. •:• Light& Power is responsible for reading all electric and water meters. • We provide maintenance of all Town-owned street lights. • We provide records management for all billing information and Federal reporting. • The Town promotes energy efficiency through the Light& Power Division and provides our customers the ability to purchase renewable energy. II 1 10/19/2012 EP • 2013 Highlights 3111 Summary of changes included in this division are... •:• Continue the Allenspark Circuit Upgrade with tree/wildlife cable. •:• Additional administrative personnel for inventory, new customer processing and budgeting (shared with Water). • Continued development of the distribution computer model. • New electric meter test bench. •:• Replace street lights on Highway 7 with LED lights. • Rate Study ❖ 800 MHz Radios Revenue $14,000,000 " 20 3 $12,000,000 R Charges for Services $10,000,000 -' $12,984,166 $8,000,000 Other $200,001 $6,000,000 I Investment Income $4,000,000 -"' $35,000 $2,000,000 $0 2011 2012 2013 Total = $13,219,167 $1 2,682,944 $1 2,664,087 $13,219,167 2 10/19/2012 P Expenses 2013 M Source of Supply $6,005,200 $7,000,000 Personnel $6,000,000 / $2,481,351 $5,000,000 I I Operations& Maintenance $4,000,000 $2,262,520 $3,000,000 7 Capital $1,877,500 $2,000,000 $1,000,000 ' Total = $12,626,571 $0 ' 2011 2012 2013 4-7 15% $9,834,1 26 $1 1,934,851 $1 2,626,571 18% 20% P : Personnel Services 2013 Light& Power includes 15 administrative staff and 12 crew members for $3,500,000 i' operations of the electric i system. $3,000,000 ' $2,500,000 ' _ $2,000,000 $1,500,000 $1,000,000 2011 2012 2013 $2,183,293 $2,275,854 $2,481,351 20% 3 10/19/2012 P Operations & Maintenance 2013 / Included in this $2,500,000 category are transfers which increase as a i $2,000,000 / percentage of revenues. i $1,500,000 Other increases i $1,000,000 include include additional costs for IT services,a ■ higher bond payment. $500,000 $0 ' ..- 2011 2012 2013 $1,955,608 $2,293,417 $2,262,520 I8% Capital 2013 Capital projects are i comprised of three main $2,000,000 components: renewal and $1,800,000 // replacement,regulatory $1,600,000 i requirements and / growth/capacity increases. $1,400,000 i/ At a minimum,capital $1,200,000 should be funded at an $1,000,000 $800,000 / amount equal to or $600,000 greater than the annual $400,000 depreciation(GAAP). $200,000 '/ i / Annual depreciation is $0 /' $800,000. 2011 2012 2013 $794,921 $1,303,580 $1,877,500 I 5%. I 4 10/19/2012 p 2013 Highlights Summary of changes included in this division are... •:• Continue the Allenspark Circuit Upgrade with tree/wildlife cable. Additional administrative personnel for inventory, new customer processing and budgeting (shared with Water). •:• Continued development of the distribution computer model. •;• New electric meter test bench. •;• Replace street lights on Highway 7 with LED lights. •:• Rate Study •:• 800 MHz Radios The End 5 10/19/2012 Expenses 2013 47% ■Source of Supply °II° $6,005,200 15% •Personnel $2,481,351 •Operations&Maintenance $2,262,520 •Capital $1,877,500 18% 20% Total = $12,626,571 UDistribution - O&M Expense by Categor _, $600,000 ' 2013 $500,000 Budget for distribution $400,000 ' includes tree trimming, substation maintenance, $300,000 /� electric meters,street light maintenance and $200,000 replacement,engineering services,safety equipment $100,000 ' and materials to maintain $0 / / the distribution system. - ocoe �04,,4 s�=NOS t\ 0- ``O�s�.yQ_ \t, Q`ok e°y eke doe ,`k o.QF Q p 6 10/19/2012 Customer Accounts - O&M Expense by Category Py $70,000 7 2013 $60,000 ' Customer accounts includes costs for meter $50,000 reading and the $40,000 7 processing, printing and mailing of utility $30,000 bills. $20,000 $10,000 '' $0 '-II I Air y es a e ee e`' tic, J� Fe o o°o C' `'' teF e� ve eC JQ b OP Jc e t 5 0 \cSJtor QtI,. ec��e eQ �(5* ..g. Qe�. Q\_epo J\Qtl p ' ' <a 1 LfpAdministration - O&M Expense by Category 2013 Administration budget $350,000 zincludes funds set aside $300,000 for vehicle replacement, $250,000 ' energy efficiency programs,fuel and $200,000 , service for 20 vehicles, ' shop and office space $150,000 ' rent,seasonal decorations, $100,000 financial audits and professional memberships $50,000 z $0 oti e es p, e`' ce e`' e`' e`' et s `JF e ,cc De oc Q\� et ;�i� r `6e yJtp ek5 C�� O`t\�Ote Qe.. Je \e Qt Fe c4P w 01Jt ,,,a 7 10/19/2012 ansfer & Debt Service - O&M Expense by Category $1,400,000 $1,200,000 2013 The General Fund $1,000,000 transfer is 9.8%of $800,000 ' revenues from electric service. $600,000 Light& Power has one $400,000 ' $6.2M bond. Final $200,000 bond payment is in $0 / i� 2027. e Asto yet •5e eke:, Oe <6 e•4' AF QO Capital Outlay by Category $800,000 - 2013 $700,000 $600,000 Capital projects for $500,000 2013 include: Allensparl< Phase 2, $400,000 continued development $300,000 of the distribution $200,000 computer model,new $100,000 _ LED street lights and $o '--I---.—' �1_ ,_ transformers. Q• e� c� e �a t`' nk � d e ;P ¢ °a tce 4 <<` cue\°cue >or o�>?o oa.tc 1/4 o :; egot ��Q� S.S DS O-eRke oo C.°c�Jo�`°c Qc°ce"4<s Oec�oe�r�o�\oca�Q�,\�`Jcaet 96,6 8 10/19/2012 Enterprise Fund 2013 - Wate • 0 - �/J �✓ vim' ,�- - %'1 j I Beginning Fund Balance: $3,419,142 + Projected Revenues: $4,160,275 1 ' - Projected Expenses: $4,066,072 -�� / -Transfers Out: $ 214,953 -1 •-o '2:.g, ;9 Ending Fund Balance: $3,298,392 Scope of Services ....Services Include: 4. The Water Division employs 14 people including operators, administration and finance/billing services. ❖ The Water Division is responsible for resource management of water which includes watershed management, demand forecasting, augmentation planning,treating and distributing water for public use. •:• We administer the backflow prevention program and maintain all fire hydrants and water meters. We meet all regulatory reporting requirements of the Colorado Department of Public Health and Environment (CDPH&E), EPA and the State River Commissioner. •:• As required by the State,we have trained and licensed Class A plant operators, Class 2 distribution system operators and certified backflow prevention technicians. 1 • 10/19/2012 E 2013 Highlights •:• Continued development of the distribution computer model. •.• Big Horn Drive waterline replacement. • Automation software upgrades. • Process analyzer replacements. • Automated Meter Reading installation. • Water System Master Plan. •:• Additional administrative personnel for inventory, new customer processing and budgeting (shared with L&P). • Rate Study • 800 MHz Radios EP Revenue 2013 $4,500,00o J $4,000,000 7 Charges for Services $3,500,000 --"'" $4,115,363 $3,000,000 Miscellaneous $2,500,000 -, $27,912 I Investment Income $2,000,000 -' $17,000 $1,500,000 $1,000,000 -' $500,000 -/ Total = $4,160,275 $o . — � 2011 2012 2013 $3,222,700 $3,927,186 $4,160,275 2 10/19/2012 fP Expensesill 2013 I'Source of Supply $167,461 $1,600,000 IN Personnel Expenses $1,400,000 ' $1,445,753 $I,200,000 I Operations&Maintenance $1,000,000 ' j $1,406,354 $800,000 V I Capital $600,000 ' $639,300 $400,000 $200,000 . ' Total = $3,658,868 $0 2011 2012 2013 5 i 40% $3,069,928 $3,189,256 $3,658,868 17% 38 • P Personnel Services • 2013 Water Division includes 3 administrative staff and 11 people for operations of $1,600,000 the treatment plants and $1,400,000 Z. distribution system. $1,200,000 $1,000,000 / $800,000 $600,000 $400,000 $200,000 " $0 / ..,_ 40% 2011 2012 2013 I $1,217,940 $1,283,522 $1,445,753 3 10/19/2012 P. Operations & Maintenance 1 I- 2013 O&M expenses have / increased to levelize $1,600,000 / large maintenance $1,400,000 / accruals. $1,200,000 $1,000,000 ' $800,000 $600,000 $400,000 $200,000 / / $0 2011 2012 2013 $1,013,978 $1,142,848 $1,406,354 38% — t. EP. %pita1 2013 Capital projects are comprised of three main / components: renewal and $700,000 i/ replacement,regulatory • $680,000 requirements and / growth/capacity increases. � $660,000 At a minimum,capital $640,000 , should be funded at an $620 000 amount equal to or greater than the annual $600,000 depreciation(GAAP). $580,000 '� Annual depreciation is $560,000 $650,000. /$540;000=,' ,- 2011 2012 2013 17% $689,242 $598,425 $639,300 4 10/19/2012 EP "013 Highlights .111111.10 •:• Continued development of the distribution computer model. • Big Horn Drive waterline replacement. • Automation software upgrades. ti• Process analyzer replacements. ❖ Automated Meter Reading installation. • Water System Master Plan. •:• Additional administrative personnel for inventory, new customer processing and budgeting (shared with L&P). $• Rate Study ❖800 MHz Radios The End 5 10/19/2012 A _ Ex ei siii 2013 40°I° Source of Supply 5% $167,461 "Personnel Expenses 17% $1,445,753 n Operations& Maintenance I $1,406,354 I I Capital $639,300 Total = $3,658,868 38°A) tr_ p, Purification - O&M Expense by Category 2013 $350,000 '/--- Budget for purification $300,000 ind laboratory $250,000 testiclunges,the Annual Consumer Confidence $200,000 Report,backwash pond mnten , plant and $150,000 — laboratory analyzers, iiiiiiE plant valve actuators, $50,000 $100,000 — water treatment chemicals _ and treatment plant utility charges. $0 S S —ms ' r C,Q a — e 5 Qv is o \h c °e p o� e s�dzs + os o ' \cS Q � � 3>9 6 10/19/2012 Ep 'Distribution - M Expense by Category $200,000 2013 Budget for distribution il $150,000 ' i includes funds set i' aside for vehicle _ replacement,fuel and $100,000 service for 11 vehicles, ( excavation and $50,000 I materials for repairs iof water mains, plotter ink,radios, personnel $0 equipment for ec's / ee", de' cce .e`' ose`' se`' confined spaces and A°e� se,` e� �\,eo eca se c$` ca`� utilities. eQ\ 'e s4 c (5 pro \y� +Qe +Qe .0 . ,e•6 \cy�so°Qsclk• ec����eQov �o�es e;t J�Ki �Jse �QJ.Q to p �k ustomer Accounts - O&M Expense by Category 2013 Si 20,000 / / Customer accounts $100,000 includes costs for meter / reading and the , i_____ $80,000 / processing,printing $60,000 and mailing of utility bills. $40,000 / $20,000 `�R \fie Q'. o°c Qsev- `ez �.Q Pea ocLe Des; s o�e� �\e Jt off. 60 \ \e� \c5 Qs \ Gee Jc I 7 10/19/2012 pAdministration - O&M Expense by Category $120,000 / 2013 $1 oo 000 ' Administration budget includes expenses for $80,000 ' legal and engineering services,IT services,rent $60,000 ' of office and shop space, water system automation $40,000 AI software, professional III $20,000 memberships and training. $0 ' — etv Q J•`a Q, \5\ o \`' ec J \ t e� Q4\ o,1 e et Qtk c1�t 8,' ',.' o Q Q&.'Z �e ..p PTransfer & Debt Service - O&M Expense by Category $450,000 2013 $400,000 . The General Fund $350,000 — transfer is 5.4%of $300,000 'i ,— — water sales excluding $250,000 — bulk water sales. $200,000 ' �' In 2011 the Water $150,000 Division made its last $100,000 payment on the 1997 $50,000 bond. The 2008 bond $0 / will be paid off in het tine fee +e`' 2028. 4,t �� o. C�ecet.° O Ft j�ec�;v Qo 8 10/19/2012 {p Capital Outlay by Category 3 2013 $500,000 / Capital projects for $450,000 ' 2013 include:Big Horn $400,000 — Drive pipe replacement, $350,000 ' security equipment, $300,000 '' automation software $250,000 ' upgrades,new $200,000 ' 4 laboratory analyzer, $150,000 ' j Automated Meter $100,000 / Reading installation, $50,000 '-- '. water distribution model $0 ,-1I - ' . — ' . 17 i development and Water DO &N &N &N &N ec� ef' \po System Master Plan. 0 S`&Cs ti�ee� y`cA� •OCs �o •OCs dot �e�V F°tc Jt �o,Q God e --e> 9