Loading...
5.5. SR 08-14-2006 City of Elk River REQUEST FOR COUNCIL ACTION Agenda Section Meeting Date Worksession Au ust 14,2006 Item Description 2007 Bud et Administrator Introduction At Monday's meeting we will start the 2007 budget process. We will focus mainly on the estimated tax capacity increase and resulting increase in tax levy and requests for capital equipment and new employees. Discussion Information on the above items will be distributed on Monday. I have received preliminary property value data from the Sherburne County Assessor that will provide a basis for the initial estimate of property tax that can be raised using the payable 2005 tax rate. As you know, the payable 2006 tax rate went up slighrly because some properties were eligible for a class rate reduction that was not included in the September net tax capacity estimate. The Council earlier this year confirmed its intent to revert back to the 2005 tax rate for taxes payable in 2007. Further, Phil Hals, Bruce West, and Jeff Beahen will be present at the meeting to discuss their equipment requests and, in very general terms, any changes in their proposed budgets. We will provide a brief overview of the changes in their budgets in terms of programs that have changed and other operational changes or needs that affect the budget. Finally, this is just the opening of the budget discussion. At the next budget worksession the entire budget will be presented for review by the Council. The community development and parks and recreation department heads will be available to answer questions about their budgets at that meeting. Financial Impact None Attachments None Action Requested Discussion on 2007 budget. Council Action Motion by _ Second by _ Vote Follow Up C\Documents and Settings\tallard\Local Settings\Temporary Internet Files\OLKF\2007 budget 0814 06.doc PRELIMINARY LEVY SAMPLE FOR TAXES PAYABLE 2007 Hanc1ln0b rthif{ ou> Final NTC -March 2006 NTC 20,085,784 Levy 8,823,793 Tax Rate 43.931 % Avail. For 2006 General Fund General Fund Tax Levy Tax Levy Increase 5% NTC Increase Proposed Levy 21,090,073 1,488,025 7.056% 2005 Tax Rate 21,090,073 9,229,649 43.763% 7,741,624 7,220,500 8% NTC Increase Proposed Levy 21,692,647 1,488,025 6.860% 2005 Tax Rate 21,692,647 9,493,353 43.763% 8,005,328 7,220,500 9% NTC Increase Proposed Levy 21,893,505 1,488,025 6.797% 2005 Tax Rate 21,893,505 9,581,254 43.763% 8,093,229 7,220,500 10% NTC Increase Proposed Levy 22,094,362 1,488,025 6.735% 2005 Tax Rate 22,094,362 9,669,156 43.763% 8,181,131 7,220,500 521,124 784,828 872,729 960,631 Market Value Levv % Total Levv EDA 1,786,411,900 0.01813% 323,876.48 5% increase in MV 1,875,732,495 0.01813% 340,070.30 7% increase in MV 1,911,460,733 0.01813% 346,547.83 10% Increase in MV 1,965,053,090 0.01813% 356,264.13 County Estimated MV 1,788,227,700 0.01813% 324,205:68 HRA 1,786,411,900 0.0131% 234,019.96 5% increase in MV 1,875,732,495 0.01310% 245,720.96 7% increase in MV 1,911,460,733 0.01310% 250,401.36 10% Increase in MV 1,965,053,090 0.01310% 257,421.95 County Estimated MV 1,788,227,700 0.01310% 234,257.83 Estimated Market Value Increase for Payable 2007 is 10.9% Of this increase 4.2% is from increases in existing property values 6.7% is from new construction. Estimated NTC increase is around 9%. (Data from Sherburne County Assessor on 8/4/06) 8/14/2006 Tax Levy.xls ct) z o E o o <( I-LL. wLL. C)~ Oct) ::>0 COw 1'-1- Oct) Ow N::> >-0 O:::w <(0::: Z -0 ~<( ....JW WJ: 0:::1- e..Z W ~ I- 0::: <( e.. W o Iii 01 ..... 0 ~O ~~I ;;::: ~ lIll Q)..... CO III ~8 >- m e.. III "E Q) E E o o Q) ,g ;a .8 Q) "O,g 51:: e ~ ~ E m 0 ~J= <0 ~Q) o Q)lIl o Q)m N 3:~ .= U "0 Qj .= Q) 0. C o lIlm ~ ~::;.!!1 CTOlOlll 0:::Q) -g ;: :c ..oN I- Iii c ;;::: .= "0 Q) "0 ::l U .= o z 00 00 ...,.N "':0) N..- tI9- J o 10 I'- C"i tI9- 00 100 <ON C"io) N..- tI9- ) 1'-1'- 00 00 ~~ ..- ..- -- ..- ..- 1-1- e..e.. c o :;::::; "iij o e.. "E m o .iij III <( Qj ~ 0 5::..0 O~ J E .iij ~ "E .g"iij co~ m~ .: co LL.e.. d o o ci N tI9- >- 03 Cij E .x e 0. 0. m .!!1 o o U "0 Q) III m ~ U .= Iii ::l "0 <( 00 NO co I'- cDC"i ...,. o o 10 N 00 NO C"ll'- ..tC"i ...,. I'- 1'-0 00 ON N- _N ~O ..- ..- 1-1- LL.e.. "E m o .iij III <( ... Q) o U CijE cO :Om o U o .~ o Q) cct) .E Iii "0 ::l <(0 ~ ~ ..0 ::i ~ ... 0) c"E o 0) :0:.0 m ... ~ .2 U c 0) 0) O:::ct) "E .iij 0. vi U m III 0) "0 "S U 3: o c.. vi ~ Iii 3: 0) "0 .iij 03 > o .s::. ct) ... O).E~ mt)UJg> c ~ ~ "~ :~ "E "S 0 O38uc.. 10 N <0 0) Ol u"O "0 "0 C Q) ~ ~ Oij) :; ~ ~ ~ ~ .~ "~ ~ 0) Q) U"OO) Ol ..0 ..0 C 0) <5 "= 0 0 ~ ro .s::. 131- I- O)~o Cij"2.... -0 a~ >- ": 0.5 ar5 0) m:c Ol ~ e "0 0 "0 E .iij "= 2_0)=0)0)lIl.s::. ~>UU,uU"OOlll "'-' '- C c: "Ci) c.. 2 8..mmmm.....aiu ->-l6>-l65uQj C)~""'.:JI:.""'lIl_C..... CQ).=O).= miE ~~E~E~~.5 U "'0) Ol "'0) Ol 3: .= 0 m C cQ)m"O t; 0.._ 0.._ "0 E ~;g ~;g.iij Ol.8 U Ci::l::l::l::103clll..... .= 0 ..0 0 ..0 > .- 1i) 0) .e..s::. :5 .s::. :5 0 ;g 0) "0 ~~.~~.~c55~~ lij 10 I'- ...,. ci C"l o o 10 ...,.- ..- o o 10 ..t ..- o o C"l o o C"l o 10 co 0) N o o N ..t ..- o o N ..t ..- I'- o o ~ ..- - ..- I I'- o o ~ ..- - ..- I'- o o ~ ..- - ..- I l- LL. l- e.. l- e.. ... ~ o ..0 m ....J ... ~ o ..0 m ....J ... 0) ... o ..0 m ....J III 1i) 0) ... Ci5 III 1i) ~ Ci5 III 1i) ~ Ci5 ctJandouJ~ t/ll/[tfte 10 I'- ...,. ci C"l o I'- o ,..: co tI9- 10 N <0 o 10 co 0) N I'- o o N - ..- - ..- I l- LL. ... 0) ... o ..0 m ....J "E .iij ~ <0 o o ~ 10 ..- co Ol "0 co 2007 CAPITAL OUTLAY Department Item Requested Amount Funding Source General Equipment Other Fund Certificate Fund Department Total Information Tech Upgrade to full phone cabinet at Fire Station #1 New Web server 10,000 6,000 16,000 Police Unmarked squad (3) Marked squad Supervisor squad Mobile video cameras (3) Mobile data computers (3) 60,000 34,000 30,000 19,000 15,000 158,000 Fire Tanker Truck 175,000 Streets Single-axle truck w/plow equipment Heavy duty one-ton truck Fuel card system Skid Loader Steel roller (used) Crack router Dump box for Unit 234 Roadside mower attachment Pickup truck Building roof replacement 150,000 66,000 53,250 32,000 10,650 6,400 6,400 8,500 28,750 120,000 481,950 Snow Removal Loader snow plow 7,455 Park Maintenance 2 - 3/4 ton pick ups Trimming Mower Cab & broom for Toro tractor 53,250 12,250 11 ,700 77,200 Subtotal General Fund Departments 915,605 Library Liquor Tasting Bar - Northbound 10,000 Total $925,605 $0 $0 $0 $0 '1/~7/b4 2007 Capital Outlay (revised) Priority 1 Grader trade $100,000 I.L.O. truck purchase ($60,000 savings) 2 H.D. One Ton Truck 66,000 ( same cost as original estimate) 3 Pick up Truck 25,000 (price reduced $3750) Lz 40 l) ~dump box #234 ~ 'S"''OQ roadside mower attachment 31,950 (same cost as original estimate) I 1) \.0 ~ steel roller l.Q 4 ~ 0 crack router 5 Skid loader trade 21000 (price reduced $11,000) Total $243,950 Building roof still being researched City of Elk River, Minnesota Capital Improvement Plan 2006 thru 2010 PROJECTS BY DEPARTMENT Department Project# Priority 2006 2007 2008 2009 2010 Total IFire I Vehicle Replacement FO-01 3 40,000 40,000 Fire Truck Replacement - Grass Rigs FD-02 3 45,000 45,000 Fire Truck Replacement - Tankers FD-04 3 175,000 50,000 225,000 Fire Truck Replacement - Other FO-05 3 235,000 235,000 Fire Total 45,000 175,000 235,000 40,000 50,000 545,000 IPolice I Marked Squad Replacement & Additions PO-01 3 90,000 30,000 124,000 124,000 96,000 464,000 Unmarked Squad Replacement & Additions PO-02 3 60,000 60,000 62,000 31,000 64,000 277,000 CSO Vehicle Replacement & Additions PO-03 3 30,000 31,000 61,000 Police Department - Other Equipment PO-04 3 20,000 187,000 36,000 32,000 275,000 Police Total 200,000 277,000 186,000 222,000 192,000 1,077,000 IPublic Safety Building ~ Energy Management System PS-01 4 11,000 11,000 Public Safety Building Total 11,000 11,000 IStreets ~ Vehicle Replacement - pickup trucks ST-01 3 27,000 27,000 Dump Truck Replacement ST-02 3 360,000 210,000 175,000 180,000 195,000 1,120,000 Heavy Equipment Replacement ST-03 3 143,000 260,000 150,000 200,000 753,000 Other Equipment Replacement ST-04 3 50,000 75,000 125,000 Public Works Complex ST-09 3 750,000 220,000 970,000 Public Works Building Maintenance ST-11 3 50,000 50,000 Streets Total 1,160,000 380,000 705,000 405,000 395,000 3,045,000 GRAND TOTAL 1,416,000 832,000 1,126,000 667,000 637,000 4,678,000 2006 elP Draft 05/30/06 Page 1 Capital Improvement Plan 2006 thru 2010 Fire Chief Contact City of Elk River, Minnesota Department Fire FD-Ol Type Vehicle Project # Useful Life 10 years Project Name Vehicle Replacement Category Vehicles Priority 3 Important I I I Description I Replace fire chief and inspector vehicles as follows: 2003 - inspector SUV 2004 - SUV Chief 2009 - SUV - Inspector 2 2012 - SUV - Inspector 1 2017 - SUV - Inspector 2 I 2013 - SUV - Chief I I I Justification I The fire chief and fire inspector's vehicles are used for everyday general use along with response to emergency incidents. After a period of 7-9 years, safety for emergency response becomes an issue with the vehicles. Expenditures 2006 2007 2008 2009 2010 Total Vehicles 40,000 40,000 Total 40,000 40,000 Funding Sources 2006 2007 2008 2009 2010 Total Equipment Certificates 40,000 40,000 Total 40,000 40,000 2006 elP Draft 05/30/06 Page 1 Capital Improvement Plan City of Elk River, Minnesota 2006 thru 2010 Contact Fire Chief Department Fire Type Equipment Useful Life 15 years Category Vehicles Priority 3 Important Project # FD-02 Project Name Fire Truck Replacemeut - Grass Rigs Description I Grass Rigreplacements as follows: 2004 - Grass Rig 2 2006 - Grass Rig 1 2011 - Grass Rig 3 2018 - Grass Rig 2 (repl. 2003) 2020 - Grass Rig 1 (rep. 2006) Justification I The grass rigs are 4X4 I-ton vehicles that are used during emergency response for various responses besides grass fires. The emergency response and safety become a factor during the expected life of the vehicles. Expenditures Vehicles 2006 45,000 45,000 2007 2008 2009 2010 Total 45,000 45,000 Total Funding Sources Equipment Certificates 2006 45,000 45,000 2007 2008 2009 2010 Total 45,000 45,000 Total 2006 elP Draft 05/30/06 Page 2 Capital Improvement Plan 2006 thru 2010 Fire Chief Contact City of Elk River, Minnesota Department Fire FD-04 Type Vehicle Project # Useful Life 20 years Project Name Fire Truck Replacement - Tankers Category Vehicles Priority 3 Important Description I Fire Tanker replacement as follows: 2007 - Tanker 1 2010 - Tanker 2 - Refurbish (tank only) 2015 - Tanker 2 Justification I If possible, tanker 1 will be refurbished (tank only) instead of purchasing a new tanker. Expenditures 2006 2007 2008 2009 2010 Total Vehicles 175,000 50,000 225,000 Total 175,000 50,000 225,000 Funding Sources 2006 2007 2008 2009 2010 Total Equipment Certificates 175,000 50,000 225,000 Total 175,000 50,000 225,000 2006 CIP Draft 05/30/06 Page 3 --.-- -----.- Capital Improvement Plan 2006 thru 2010 Fire Chief Contact City of Elk River, Minnesota Department Fire Project # FD-05 Type Vehicle Useful Life 25 years Project Name Fire Truck Replacement - Other Category Vehicles Priority 3 Important Description I Other Fire Truck replacement as follows: 2008 - Rescue I 2014 - Aerial Ladder Justification I Rescue I may be moved to station 2 as part of a change in the department's response with pumpers also serving as rescue units. This enables the designated rescue trucks to become more of an equipment unit. Expenditures 2006 2007 2008 2009 2010 Total Vehicles 235,000 235,000 Total 235,000 235,000 Funding Sources 2006 2007 2008 2009 2010 Total Equipment Certificates 235,000 235,000 Total 235,000 235,000 2006 CIP Draft 05/30/06 Page 4 Capital Improvement Plan 2006 thru 2010 Police Chief Contact City of Elk River, Minnesota Department Police Project # PD-Ol Type Vehicle Useful Life 3 years Project Name Marked Squad Replacement & Additions Category Vehicles Priority 3 Important Description I Routine replacement of vehicles at or near 100,000 miles. Includes all equipment and setup. 2004 - 3 replacement 2005 - 4 replacement 2006 - 3 replacement 2007 - I replacement 2008 - 4 replacement 2009 - 3 replacement; 1 new 2010 - 3 replacement 2011 - 3 replacement 2012 - 4 replacement 2013 - I replacement 2014 - 3 replacement Justification I Expenditures 2006 2007 2008 2009 2010 Total Vehicles 90,000 30,000 124,000 124,000 96,000 464,000 Total 90,000 30,000 124,000 124,000 96,000 464,000 Funding Sources 2006 2007 2008 2009 2010 Total Equipment Certificates 90,000 30,000 124,000 124,000 96,000 464,000 Total 90,000 30,000 124,000 124,000 96,000 464,000 2006 CIP Draft 05/30/06 Page 5 Capital Improvement Plan 2006 thru 2010 Contact Police Chief City of Elk River, Minnesota Department Police Project # PD-02 Type Vehicle Unmarked Squad Replacement & Additions Useful Life 3 years Proj ect Name Category Vehicles Priority 3 Important Description I 2003 - I unmarked 2004 - I replacement 2005 - I new (captain) 2006 - 2 replacement 2007 - 2 replacement 2008 - 2 replacement 2009 - 1 replacement 2010 - 2 replacement 2011 - 2 replacement 2012 - 2 replacement 2013 - 2 replacement 2014 - 3 replacement Justification I Expenditures 2006 2007 2008 2009 2010 Total Vehicles 60,000 60,000 62,000 31,000 64,000 277,000 Total 60,000 60,000 62,000 31,000 64,000 277,000 Funding Sources 2006 2007 2008 2009 2010 Total Equipment Certificates 60,000 60,000 62,000 31,000 64,000 277,000 Total 60,000 60,000 62,000 31,000 64,000 277,000 2006 CIP Draft 05/30/06 Page 6 - - --- - ---------- ------------- Capital Improvement Plan 2006 thru 2010 Contact Police Chief City of Elk River, Minnesota Department Police PD-03 Type Vehicle Project # Useful Life 10 years Project Name CSO Vehicle Replacement & Additions Category Vehicles Priority 3 Important Description I CSO vehicle replacement and additions as follows: 2006 - truck 2009 - truck 2011 - truck replacement and new truck 2012 - truck Justification I Expenditures 2006 2007 2008 2009 2010 Total Vehicles 30,000 31,000 61,000 Total 30,000 31,000 61,000 Funding Sources 2006 2007 2008 2009 2010 Total Equipment Certificates 30,000 31,000 61,000 Total 30,000 31,000 61,000 2006 elP Draft 05/30/06 Page 7 ------------- Capital Improvement Plan 2006 thru 2010 Police Chief Contact City of Elk: River, Minnesota Department Police Project # PD-04 Type Equipment Useful Life Unassigned Project Name Police Department - Other Equipment Category Equipment Priority 3 Important Description I 2005 - 5 Mobile Computers 2006 - 4 Mobile Computers 2007 - 800 mhz radios $152k; bar code software $35k 2009 - 6 Mobile Computers 2010 - 5 Mobile Computers 2012 - 8 Mobile Computers Justification I Expenditures 2006 2007 2008 2009 2010 Total Equipment 20,000 187,000 36,000 32,000 275,000 Total 20,000 187,000 36,000 32,000 275,000 Funding Sources 2006 2007 2008 2009 2010 Total Capital Outlay Reserve 20,000 187,000 36,000 32,000 275,000 Total 20,000 187,000 36,000 32,000 275,000 2006 elP Draft 05/30/06 Page 8 Capital Improvement Plan 2006 thru 2010 Contact Building Maintenance Supv. City of Elk: River, Minnesota Department Public Safety Building Project # PS-Ol Type Building Useful Life Unassigned Project Name Energy Management System Category Building Maintenance Priority 4 Low Priority Description I Add co2 sensors to energy management system. Justification I Expenditures 2006 2007 2008 2009 2010 Total Building Maintenance 11,000 11,000 Total 11,000 11,000 Funding Sources 2006 2007 2008 2009 2010 Total Government Buildings Reserve 11,000 11,000 Total 11,000 11 ,000 2006 CIP Draft 05/30/06 Page 9 Capital Improvement Plan 2006 thru 2010 Street Supt. Contact City of Elk River, Minnesota Department Streets Project # ST-Ol Type Vehicle Vehicle Replacement - pickup trucks Useful Life 15 years Project Name Category Vehicles Priority 3 Important Description I Street department pickup truck replacements. 2007 - 1 2011 - 1 Justification I Expenditures 2006 2007 2008 2009 2010 Total Vehicles 27,000 27,000 Total 27,000 27,000 Funding Sources 2006 2007 2008 2009 2010 Total Equipment Certificates 27,000 27,000 Total 27,000 27,000 2006 elP Draft 05/30/06 Page 10 Capital Improvement Plan 2006 thru 2010 Contact Street Supt. City of Elk River, Minnesota Department Streets Proj ect # ST-02 Type Equipment Dump Truck Replacement Useful Life 20 years Project Name Category Heavy Equipment Priority 3 Important Description 1 Dump truck replacement and additions. Includes all plow equipment. 2006 - I Single Axle 140k; I Tandem Axle 160k; lOne Ton 60k 2007 - 1 Single Axle 145k; lOne Ton 65k 2008 - 1 Single Axle with plow 2009 - 1 Tandem Axle with plow 2010 - 1 Tandem Axle with plow 2011-10neTon 2012 - 1 Tandem Axle with plow 2013 - Sign Truck 2014 - lOne Ton Justification I Expenditures 2006 2007 2008 2009 2010 Total Equipment 360,000 210,000 175,000 180,000 195,000 1,120,000 Total 360,000 210,000 175,000 180,000 195,000 1,120,000 Funding Sources 2006 2007 2008 2009 2010 Total Equipment Certificates 360,000 210,000 175,000 180,000 195,000 1,120,000 Total 360,000 210,000 175,000 180,000 195,000 1,120,000 2006 CIP Draft 05/30/06 Page 11 , Capital Improvement Plan City of Elk: River, Minnesota 2006 thru 2010 Project # ST -03 Project Name Heavy Equipment Replacement Contact Street Supt. Department Streets Type Equipment Useful Life 20 years Category Heavy Equipment Priority 3 Important Description I Heavy Equipment replacements & additions as follows: 2007 - skid loader 35k; steel roller 25k; 2 pup trailer dumps 60k; loader snow plow 7k; dump body 6k; roadside mower 10k 2008 - front end loader 175K; mini backhoe 50k; pup trailer dump 35k 2009 - grader 2010 - sweeper 2011 - skid loader 2013 - front end loader 200k; skid loader 50k 2014 - sweeper Justification I Expenditures 2006 Equipment 2009 150,000 150,000 2007 143,000 143,000 2008 260,000 260,000 Total Funding Sources 2006 Equipment Certificates 2008 260,000 260,000 2009 150,000 150,000 Total 2007 143,000 143,000 2006 elP Draft 05/30106 Page 12 2010 200,000 200,000 Total 753,000 753,000 2010 200,000 200,000 Total 753,000 753,000 ---------- -----.------- ------- ------ Capital Improvement Plan 2006 thru 2010 Street Supt. Contact City of Elk River, Minnesota Department Streets Project # ST -04 Type Equipment Useful Life 10 years Project Name Other Equipment Replacement Equipment Category Priority 3 Important Description I Replace other Street Department equipment as follows: 2008 - fuel card system50k 2009 - shouldering machine 25k; salt/sand mixing equip 50k 2011 - skid loader trailer 20k; cold mill attach 25k; air compressor 30k 2012 - asphalt patcher 60k; automatic truck wash 120k Justification 1 . Expenditures 2006 2007 2008 2009 2010 Total Equipment 50,000 75,000 125,000 Total 50,000 75,000 125,000 Funding Sources 2006 2007 2008 2009 2010 Total Equipment Certificates 50,000 75,000 125,000 Total 50,000 75,000 125,000 2006 elP Draft 05/30/06 Page 13 Capital Improvement Plan 2006 thru 2010 Contact Street Supt. City of Elk River, Minnesota Department Streets Project # ST -09 Type Building Public Works Complex Useful Life Unassigned Project Name Category Buildings Priority 3 Important Description I Public Works Master Plan as approved by Council January, 2005 2005 - Master Grading Plan 38k; Bldg Plans & Specs 5k; Salt/Sand Storage 150k; Cold Storage 125k; Parking lot & driveway improvements 79k 2006 - Site grading & utility improvements 2008 - Office Expansion 220k TBD - Tempered Storage #1 1500k; TBD - Tempered Storage #2 1100k TBD ~ Mechanic bay expansion 200k Justification I Expenditures 2006 2007 2008 2009 2010 Total Construction/Maintenance 750,000 750,000 Buildings 220,000 220,000 Total 750,000 220,000 970,000 Funding Sources 2006 2007 2008 2009 2010 Total Government Buildings Reserve 750,000 220,000 970,000 Total 750,000 220,000 970,000 2006 elP Draft 05/30/06 Page 14 . Capital Improvement Plan 2006 thru 2010 Contact Street Supt. City of Elk River, Minnesota Department Streets Project # ST -11 Type Improvement Useful Life 25 years Project Name Public Works Building Maintenance Category Building Maintenance Priority 3 Important Description I Replace Building Roof I Justification I Expenditures 2006 2007 2008 2009 2010 Total Construction/Maintenance 50,000 50,000 Total 50,000 50,000 Funding Sources 2006 2007 2008 2009 2010 Total Government Buildings Reserve 50,000 50,000 Total 50,000 50,000 2006 elP Draft 05/30/06 Page 1"5 C{) z o i= o o <( I-LL UJLL (!)~ OC{) ::>0 COUJ 1"-1- OC{) OUJ N::> >-0 ~UJ <(~ Z -0 ~<( ....JUJ UJI ~I- o..z UJ ~ I- ~ <( 0.. UJ o ~~I ~~I ..... 1+= :g ClJI Q)..... CO CIJ 0/18 ~ 0.. .$ I:: Q) E E o o tii I:: 1+= .5: "0 Q) "0 ::::l "0 .5: :; .... o ..... Q) "O,g I:: ::::It o (ll m c. m E Q) e cO ~~ g 18 [{l N 3=~ .E: ..... CJ "0 Q) .5: Q) c.1:: Ui+oi~co ~ Q) ~ .!!l c- .g>.I::. .!!l Q)::::ll"-.I::. ~.oNI- ..... o Z 00 00 '<:I"N r--:oi N...... yt .~: ~ C{) o 1.0 ?"- M- yt 00 1.00 CON M- 0)- N...... yt J "'iii Q) ::::l Q) ~ 1'-1'- 00 00 ~~ ...... ...... ..... ..... ...... ...... I I 1-1- 0..0.. I:: o :p '00 o 0.. ..... I:: (ll ..... CIJ '00 ~ Iii ~ 0 l:j:.o oj I +oJ I:: 'ffi ~+oJ .1:: 01'- 32~ fE~ Q) .... .!::: CO LLo.. <Ii E :p ci o o O- N yt >- lii 1ii E 'x o is.. c. (ll .!!l ..... CIJ o U "0 Q) CIJ (ll Q) o .5: tii ::::l "0 <( 00 NO COI"- CO- M- '<:I" o o 1.0 N 00 NO MI"- .<f M- '<:I" I"- 1"-0 00 O~ ~~ ~O ...... ...... I I 1-1- LLo.. ..... I:: (ll "'iii '00 ~ .... Q) o u 1iil:j: .5: 0 "Em o .2 00 ~ Q) cC{) 'E "lii "0 ::::l <(0 ~ (ll .0 ::J ~ Iii ..... I:: I:: .2 Q) .....0 (ll .... Q) 0 0'2 Q) Q) ~C{) oj I:: '50 'C "'iii ..... I:: 'ffi C. ui u (ll CIJ Q) "0 :; u 3= o 0.. ui ~ tii ~ "0 '00 lii > o .I::. C{) Q) 01 "0 "0 "0 I:: Q) Q) '00 :E ro ro .~ ~ ~ ~ ~ Q)-3=c. . Q) Q) gal~ BoO .0 (ll....O Q)O 0 1::(ll.I::. "01-: I- Q).I::.'O 1::"O+oJ"'d+oJcCIJc. ~ 5 ~ ~ ~.~ ~ .~ l::eQ)....Q)Q)UJ.I::. ~~g~g:Q8.~ 1ii~~~~~Q)-o ~~2~2oglii ~ 18 .~ 18 .~ ~ ~ ~ '03= E3= Etii2'5 c. Iii 01 Iii 01 3= .5: 0 oj c..5: c..5: ~ E "0 ~~;g ~;g'w OlE u ii:::::l::::l::::l::::llii I:: CIJ.....Q) ~ 0 .0 0 .0 > ._ Q) g.I::..s.I::..so;gQ)"o o ~ .~ ~ .~ c55 il 1Ji ffi .... Q).Eg ........OUJC> (ll (ll Q) I:: I:: .l:l "0 .~ :~ E ::::l 0 liiuuo.. 1.0 N co 1.0 I"- '<:I" o- M o 1.0 co 0)- N I'- o o ~ ...... ..... ...... I l- LL .... Q) o .0 (ll ....J -al ~ ..... C{) o o 1.0 '<:1"- ...... o o 1.0 '<:1"- ...... 1.0 I"- '<:I" ci M o o M o o M 1.0 N CO o o N '<:1"- ...... o 1.0 co 0)- N o o N .<f ...... I"- o o ~ ...... ..... ...... I I"- o o ~ ...... ..... ...... I I- 0.. I"- o o ~ ...... ..... ...... I l- LL I- 0.. Iii o .0 (ll ....J .... ~ o .0 (ll ....J Iii o .0 (ll ....J .$ Q) ~ ..... C{) -al ~. Ci5 +oJ I:: 'ffi ~ til "0 m CO o o ~ '<:I" ...... ..... co Elk River Police Department 2007 Budget Addendum Public Safety Records Management Software Proposal Submitted by: Jeffrey A. Beahen Chief of Police Project Manager August 14, 2006 2 Introduction: In 1999, the police department requested an upgrade to their computer system, which had been purchased in 1984, and a new records management system and mobile computer system were installed. A records management system (RMS) was purchased after bids were let, and the RMS system installed was called "Vision" Vision RMS is a records system based on a Microsoft Sequel, version 7, data storage system, a common and reliable platform for data storage. The RMS system is basically proprietary however in that the agency can not make changes to the system, but can advocate changes as part of a user group. This group however is nationally based, and changes are often difficult to obtain. Since 1999, software and hardware changes have been constant, and unforeseen. The platform on which we built our RMS system alone has changed from Windows NT, to Windows 2000 to Windows 2003. Additional platform changes are right around the corner. Although our RMS system operates efficiently and is unhampered by these changes, it is but one small illustration of the vast infrastructure and system enhancements that have taken place over the past seven years. We are proposing replacing our system with a new RMS platform, that addresses the needs of this agency for many years, and unlike the Vision system, it is browser based or accessed through the world wide web, so not only is access easier, but the department is not responSible for maintaining as much of the operating platform, insuring us that as future technological changes occur, we will not be left behind. Problem Identification: We were inspired to look at a new system while pursuing an upgrade to our current processes. We had approval from the Council to implement a bar coding system for evidence tracking purposes. We found that this integration was cumbersome and the end result would be a bar coding system that albeit would code and track the evidence, it would not be fully system integrated and thus the value was minimal. One of the software systems offered however was a complete integrated platform, which not only offered us the chance to see what full integration does, it allowed us to see how little system integration we actually had. 3 The desire to implement a new RMS system is not so much problem solving or resolving what does not work, but rather being proactive in finding ways to better handle our daily workload and improve the utilization of our staff. We are seeking a cost effective way to vastly improve our reporting process, greatly increasing our efficiency and effectiveness. I am confident that the Council will see an approved RMS system that has the proven ability to outperform our current system in almost immeasurable terms. Why not utilize our current platform? Vision Software was sold to another vendor in 2003, and it became "Visionaire Public Safety". At that time, they removed all their Minnesota support and sale staff, and implemented a national call center for departments to access, either for software glitches or system questions. This loss of a Minnesota support network hampered our relationship with our RMS provider, and although the system operates very well, it is basically the same system that we purchased in 1999, with small improvements and changes being made along the way. The software world in general has passed Visionaire by, leaving us wishing that there was far more efficient ways to process the vast amount of information we input each and every day. We became aware of this product, that upon viewing a demonstration of same, made us realize that there is a system out there that is revolutionary in terms of what it can do, has immeasurable time savings contained within, and has the long term ability to be adaptable, upgradeable and is marketed and devised by a totally Minnesota based company, with invaluable operational links to the State of Minnesota-specifically the Department of Motor Vehicles. The other, likely most important feature, is that the product we are looking at-is CIBERS compliant. CIBERS is the new format that all police departments must utilize for crime reporting to the State and Federal agencies that track crime data. All agencies must be CIBERS complaint by 2008. At this time, only LETG is CIBERS compliant, and CIBERS operational as well. The value of this proposed program is in the changes in efficiency rather than utilizing things that are broken or outdated. As this project is laid out for the reader, it should become obvious how much change is possible and the value of this proposed system for the City of Elk River. User Committee Patrol Sergeants 1 "Investigator 1-Clerical 1-Patrol Ad Hoc Committee Patrol Clerical Mordal Masica Patrol officer Morris Executive Sponsor Chief Jeffrey A. Beahen Steering Committee Rolfe,K1unl2;, Masica, Vila Projec:lManager Chief Jeffrey A.Beahen Data Transfer Pearson State InterfacelMlNCISlDVS LETG 4 5 BENEFITS AND GOALS OF NEW SYSTEM IMPLEMENTATION . More accurate and complete data retrieved and archived. . Data and information is available in a more timely fashion. o Increased search capability. o Higher case clearance rate results. · Enhanced information in the squad, which can lead to: o Higher overall arrest rates. o Higher warrant arrests. o Reduction of radio traffic. o Reduction in errors. o Higher data accuracy. o Reduction is dispatch times. o Reduced response times. o Increased patrol times. o More time for citizen contact. · A greater reduction in redundant data leading to: o Greater efficiency o Greater accuracy · Tremendous reduction in paper documents. · Better decision making by officers in the field, detectives investigating a crime and management, in allocating resources. . More complete, accurate and accessible information will improve reporting and trend analysis, streamline data processing and workflow, and will ultimately enhance officer and public safety. o Allows better information analysis. o Geographically based. o Real time. o Allows for more efficient resource assignments. 6 BUSINESS PROCESS BASELINE . Current practices 1. Current technology implemented in 1999 2. Actual software was developed in 1996 (Ten years old) . Technology is rapidly evolving, leaving us far behind. 1. No Computer Aided Dispatch (CAD) link 2. No direct field interface with records management system. (RMS) 3. No automated mobile field reporting. (AFR) 4. No automated field accident reporting. (MAR) 5. No automated citation system. (MNCIS) 6. All basic reports are handwritten and later have to be reentered. (Dual entry) 7. No bar coding feature. 8. No ability to track evidence. 9. No ability to audit evidence. . No interface to courts for case dispositions or cases disposals. . Implementation as proposed would allow department to reallocate staff as follows: 1. Redeploy or reassign two data entry staff (2-FTE) 2. Reduce amount of staff time to .5 full time equivalents. (FTE) 3. Reduce supervisory time by 1-FTE. 7 Case Study for Change to New System Issues pertaining to direct users: 1. Browser based a. Much faster access to data than current system. b. Easy to interface from a variety of locations. c. Able to interface direct with web site to allow community access to crime data. 2. Easier system for our IT staff to maintain. Maintenance of backbone is done by software provider. a. Upgrades are pushed out to the user via the browser, no need for IT to go around and update each Pc. b. Upgrades are real time. 3. Not proprietary based. Same technology that is used on the web, every day by almost everyone. Simple, easy to use. Allows access and ease of interface with not just Microsoft products, but almost any other commercial software available. 4. Will be able to have complete paperless reporting; a. Motor vehicle accidents b. Traffic citations c. Incidents reports i. Clerical staff take on task of validating ii. Reassess assignment, redeploy workforce iii. Creates a proactive vs. reactive agency 5. Integrates new technology. a. Printers in cars, eliminates needs to purchase traffic . citations b. Drivers license swipes in each car. c. Ability to utilize inexpensive PDA's (Palm pilots) in place of expensive laptops for investigators and command staff. d. Eliminates some recurring monthly expenses. e. Full bar coding system. f. Ability to locate and track evidence. 6. Times savings. a. Be able to complete accident reports in the car, no need for the officers to return to the station later and reenter the form. 8 b. Evidence audit-currently not done, almost impossible to do by hand. Will be able to do so in the future within minutes, and at any time. c. Evidence disposal. Current practice is to get dispositions in writing, go through files by hand and then dispose of item. Takes hours to get through just a few items. New system will link court database with evidence tracking-disposal will occur real time. d. Ability to associate and import any data file to the case file electronically. Video, photos, either BIT/JPG/HTML. e. Ability to input or even create our own forms. Not just generating a form, but easily creating one that when used, the data inputs directly to the RMS system. f. No ticket printing costs. We currently pay over $5,000 a year. That cost would be greatly reduced, perhaps less than half. 7. Ease of access. a. Ability to customize the search engine. b. Data is very easy to find. c. No need for cumbersome Crystal reports or links. 8. Ability to link or interface with CAD. Buffalo PD did this with Wright County who has the same software that Sherburne County has: 1. Ability to access current call screen, all data surrounding the call. 2. Ability to access prior call history. 3. Ability to access prior call history date. (Phone numbers, names, vehicle information, etc.) In-Direct Users . MNCIS (State and District court systems) . Department of Motor Vehicles (DVS) accident reporting system. . Community via the web interface. . Local paper (Automated weekly news reports) 9 FUNDING . Currently have $50,000 available this year to start the project. $25,000 from bar coding, $13,337 in a maintenance contract that would have been paid to Visionaire and approximately $15,000 in IT management funding that is available. The IT costs were going to be used to upgrade our current RMS server- which is running low on space. . We have the ability to lease. With $50,000 down, we can spread the system costs out over 5-7 years, making the system not only affordable, but also less impact on a single year's budget. . The department has paid over $77,000 in annual maintenance costs thus far to Visionaire. We don't feel that are return on that investment has been very rewarding. . The fixed costs for the new system are much lower than what we paid to start our current RMS system in 1999. There is still a 150/0 annual maintenance cost for this new project. (The industry standard) . The 10th District Court announced on Thursday August 10, 2006, that they have been awarded funding from the State to implement the MNCIS/Police Department citation interface. That interface is a pilot program utilizing LETG, the software firm that we wish to purchase our new software from. Details of the funding will be made available on Sept. 8th, 2006. It is anticipated that as much as 250/0 of the project costs might be absorbed through this grant. 10 WHAT WE WANT OUR SYSTEM TO DO: (Specifics as identified by the Ad Hoc Committee) GENERAL: . -Integration between all modules (w/ CAD interface) . -Single entry point (not duplicating data entry) . -RMS will automatically submit data to external sources (i.e. CIBRS, etc.) . -Single data base . -RMS should provide capability to generate inquires from external and internal data sources . -Interface with state and federal agencies . -System will allow settings for specific security access MOBILE: . Access to full RMS and evidence modules . Automated ticket writing (D.L. swipe, ticket printer) . Use of D.L. swipe will automatically populate the offender information to the citation . Also written warnings and repair orders . Audit ability to track where citations are issued by area as well as missing numbers . Field reporting (integrated to RMS) . Imports data from CAD (if interfaced) . Has the ability to create and alter forms (i.e. tow sheets, property report, etc.) . Mapping software . Automated accident investigation/reporting, must allow for the state accident reports to be written and drawn using the DVS site and download the report to RMS. System will also automatically populate the information off a driver's license or license plate to the form. . CAD (with proper interface in place) . Mobile messaging . Ability to communicate with external entities and access DVS photo files 11 · Prior call history and alerts, as well as being able to place a safety notice on an address . Ability to use GPS · Mobile equipment check-out (officers can type in what PBT, radar, camera, etc they have) . Ability to do activity log from the car . Ability to access RMS files for permits, animal licensing, handgun permits, etc. . Ability to record and save in RMS verbal and/written warnings reference traffic, curfew, etc. . Internet access . Future integration with B&z for the ability to bring up blueprints in the field . Ability to access aerial photos of an area RMS: . User friendly . Browser based . Master name, vehicle, and location index . Incident and field reporting . Case management (user friendly) . Ability to assign cases . Ability to audit open cases assigned to a particular officer . Case aging report . Activity follow- up . Crime analysis (ability to see where the problems are occurring and when) . Activity type . Time of day . Day of week . Combination . Date range . Address range . Method of operation comparison . Training records (ability to maintain and audit staff training records) . Equipment inventory . Permit files (animal licenses, hunting permits, gun purchase permits, city licensing-alcohol, tobacco, etc.) . Ability to access juvenile data separately from adult data . Ability to tie a juvenile entry to the parent or guardian . Ability to import digital information (dictation files, digital photos, etc.) EVIDENCE: . Fully integrated bar-coding system . Ability to read up-to-date evidence reports from any authorized workstation . Holds chain of custody . Ability to import files (jpeg photo files, etc.) . Electronic signature ability . Integrated ability to construct form letters to notify property owners of disposition . Property audit trail ability . Ability to track evidence through case file number . Notification system when case is outside statute of limitation . System will provide a means to match stolen property with recovered property . System will provide a means to easily replicate data 12 13 PROJECT COSTS: To place this project out for bids would require the use of a consultant. The Edina Police Department had the cheapest rate for a consultant we could find, and that was $30,000. Other related projects in Mille Lacs County, Crow Wing County, Buffalo, Isanti County and others, have incurred consultant fees as high as $145,000. One way to avoid these costs is to start small and then add on to the system as the funding becomes available through our lease program. We can start the process and avoid bids by purchasing the first section of this new RMS project, the mobile piece, for under $50,000. No formal bid process would be required, thus eliminating the need to hire a consultant and pay the cost to develop a request for proposal and bids. We have the IT staff in-house that could assist with that process, but a consultant would still be needed to draft the required documents for the requests. Edina's RFP was almost 175 pages in length. We have examined the other vendors who are available, as well as looking at our current software provider as potential options instead of LETG. None of these are viable solutions, and our IT staff strongly advocated the LETG solution for ease in long term maintenance, ability to implement future change, and the browser based solution provided as the primary means on interface. In addition, LETG is the only solution that is working with the State to accomplish the DVS and MNCIS interfaces. Our IT manager Bob Pearson has thrown his total support into the LETG project, and has been a strong advocate for migration to a solution that offers this much efficiency and enhanced performance. If approved, we would work the vendor on lease options, and would structure a payment program that would be cost effective for the next 5-7 years. See the attached spread sheet for exact details. 01 c: :Q a: I'll Ol .;c (jj > a: "" jjj e 'm ::!!: Iii ::l c: c: <( C'?OOOO ....0000 MoiNMN C'?CO 1'-0) 0 NC'?C'?....CO Ncr:iM"':cr:i C'\I~~~or- ~ ~~ C'? .... oi CO I'- ai LO ~ o I'- cO C'? CO ll"i 0) .... ~ o o ci o .... ai 0) N ~ o I'- cO C'? N cr:i 0) .... ~ LO CO ci CO o ai 0) ~ LO CO r--: I'- ....: 0) ~ N 0) C'? .... Iii "0 I- Ui o U Iii "0 I- OLOOLOO C'?COCO....C'? cioioioioi COMor-......,... ON LO.... C'? Mai"':aiN I'-....C'?o).... .... ~~~~~ en ::!!: a:: 00000 00000 cicicicici 00000 CONCOOCO cr:ill"iNaicr:i NC'?........I'- .... ~~~~~ "0 I'll ::l 0- en .... Ol c. Iii "0 I- LOLOLOLOLO 0)0)0)0)0) oioioioioi 1'-1'-1'-1'-1'- CO CO CO CO CO oq:oq:oq:oq:oq: ~~~~~ ~ :c o ::!!: Iii "0 I- OLOOLOO C'?COCO....C'? cioioioioi COC'l")or-.......,..... ....Ol'-....LO cr:ioq:ai"':ll"i oc::t--"'C""'"lt)CO ~~~~~ !!! I'll ~ o en ~ :c o ::!!: LOOOOO COOOOO cicicicici NCOCONCO CONCOCOCO "':"":aicr:iM N NC'? ~~~~~ !!! I'll 3: "0 lu J: ~ :c o ::!!: LOLOOLOO ....COCO....C'? oioioioioi LOI'-C'?LOC'? CO 1'-0 CO CO oq:cr:iaioq:...: N NC'? ~~~~~ a. en ...: ::l U c: 0000000 ~ en l!! Ol Ul ::> CO........LO.... ('l')..... ,...('\1 or-('I)"llt,...-.;;t .... ........ Ul "0 I'll ::l 0- en [;' c: Ol 01 <( >- Ole ....0 ~6 ~o.E'cU a:~~~~ :!!: I'll E I'll I'll WUlCOUUl LO co ci CO .... ai 0) C'? ~ rfe. o o .0 .... .... c: 'm ::!!: c: c: <( !!! I'll ~ o en Iii "0 I- o o ci o N M ~ en ::!!: a:: (jj l/l ::> (jj a. OOLO 000) ci ci oi OOLO ~co,... .... ~~~ .... ~ L-.sa '0 .!!.5 "C .5 a: CI) a. a:....c. ~ Ol 13'~ :c .... en .g ~E~ ..:: 1-<(0 .... c: 'm ::!!: 00 00 cici LO LO LOLO NN c: c: <( ~~ 0000 0000 cicicici 0000 OOOLO "":"":ll"i"": .......,.....('\1 ~~~~ .l!} l/l o U c: o ~ e Ol E Ol a. .E "0 ~ u: (jj 01 ~ (jj e ,S: en ~ ~ ,~ OlenOl.... =en 011- .g-I'll~ ::!!:t3~:c enen::!!:~ ~~'O- w w ,~en ::!!:::!!:e::!!: OlOlo.a:: o o o o .... ~ "0 c: I'll o o o C'? ~ c: Ol~ Ol>- !() Ol c: co~ c: ::l "0 !!! 01 ....c: l/l ,- 0"0 u.2 () .... c: Ol ,- 2:.... Ol 0 ene o o o ll"i ~ ~ :c o E ~ l/l o () Iii Ui ..E LO 0) oi LO N N ~ 0000 0000 cicicici OOON OLOCOC'? . ~ 6;~~ !!! ~ 'E I'll J: Iii "0 I- !!! Ol I'll 01= ~:E.g:g o o::!!: c: en C.en .J!:! C:~I-C: ,2 a:: :::!; n;:2wen :t: ,~ ::!!: a. Uu.OlC) o o o. ~ !!! ::l n; .e .c;- 'C ::l () Ol l/l c: 01 'iij I'll ~ o ~ o o LO cr:i co ~ o o ci N .... N ~ ~ :c o ::!!: Iii "0 I- o o o o .... ~ cb ~ o o LO ....: ~ I'll n; "0 - o c: o .~ Ol > c: o U l/l Ui 8 '0 Ol '[ a. () l/l ~ (j) n; E :;::; l/l ~ goooo 0,88 8 ~ ~oq:"":ocr:i N~~~~ ~ l/l Ui o U :gx Ol I'll 01- a: Iii "0 I- Ole c: I'll 'g(5 .2 en COU Oz ~::!!: 00 NO LO 0 OM COC'? ....~ ~ .... .... c: c: ::l ::l o 0 E E <(I'll Ol~ l/l .... I'll I'll Ol Ol ~>- 'C' >- r-:. .J!:! I'll ,5 Ui ~ lu Ol >- .... l!! "" l/l Ui o () e 'm E o z 14 CONCLUSION I respectfully request that the Council review this overview of the proposed project and ask approval to move forward with the software implementation. The implementation would begin with the mobile transition, followed by full records change out to the LETG software package in late 2006 or early 2007, with lease payments structured to begin in 2007.