Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2. Council Workshop Items-Public Works Department
CITY OF SHAKOPEE Memorandum TO: Mayor & City Council Mark McNeill, City Administrator FROM: Bruce Loney, Public Works Director SUBJECT: March 11, 2008 Council Workshop Items DATE: March 6, 2008 INTRODUCTION: This memo is intended,to outline the items for discussion with the City Council on the workshop with Public Works Department. BACKGROUND: The Public Works Department consists of the Engineering, Street Maintenance, Park Maintenance, Fleet Maintenance Divisions and the Sanitary Sewer and Storm Drainage Utilities. For 2008, staff would like to update the Council on various activities and present items that need discussion or direction from the Council. Attached is an agenda with subtopics and timelines for March 11, 2008. Item No. l -CSAH 17 Corridor Study Scott County is conducting a study on CSAH 17, from C.R. 101 to T.H. 19 near New Prague. The purpose of the study is to develop a long term plan or vision for the CH 17 & TH 13 corridor and to study. the pending 2013 project, from CSAH 42 to St. Francis Avenue. S.E.H., Inc. has done a study for the County and will present their preliminary findings and be able to answer questions. The corridor study is from CH 101 Bridge to CH 17 & CH 101 intersection and south to TH 19 in Scott County. A future open house with the public is scheduled for Apri18, 2008. Item No. 2 -Transportation Issues for 2008 Staff will present an 11-minute DVD on modern roundabouts and included is a brochure on roundabouts for Council information. A map is also included to indicate potential roundabout locations in the City of Shakopee. A traffic study would need to be done to justify a roundabout at any intersection. Ideally, a roundabout should be looked at whenever a new traffic control signal system is being considered. Staff would like to also discuss the future design of Eagle Creek Boulevard, from CSAH 17 to CSAH 83, as this is now a City roadway. Currently, this road is a 4-lane individual urban roadway with a traffic volume of 6,700 ADT and a 2030 projected volume of 9,400 ADT. Staff will show a preliminary design of a 3-lane urban roadway with a roundabout at Eagle Creek Boulevard and Vierling Drive and discuss the pros and cons of this design. Staff has had resident complaints on the speeds of traffic on Eagle Creek Boulevard and a three lane design has a tendency to reduce traffic speeds. A speed study would be recommended for this segment of roadway to see if any changes are warranted in the posted speed limit. The City did receive funds from the County to seal coat Eagle Creek Boulevard this year and after the road is done being used as a detour route for C.R. 101 bridge replacement. Attached also is a proposal to analyze a 4-lane versus a 3-lane design by WSB & Associates. Also attached is a 2007 accident location map for Eagle Creek Boulevard and this map does not show a lot of accidents except at the intersection of CSAH 17 and CSAH 83. Staff wants to discuss this design for Council feedback on whether to pursue a 3-lane design or wait until a future overlay which is expected in 6-8 years. Additional traffic and development in the area would be needed to justify a roundabout improvement at Vierling Drive and Eagle Creek Boulevard. Other traffic/transportation items is to discuss briefly the amount of County road projects and studies being done in the next two to three years. Staff has also identified potential segments of roadway that Council may want to conduct a MN/DOT Speed Study. Attached is a mad for possible speed studies and Mn/DOT speed limit brochure. Finally, a map of 2008 potential traffic studies is included for Council information and discussion, if any. Item No. 3 -Pavement Management Staff will present a power point presentation on this program, an update of the 5-year seal coat needs and current bid prices and a discussion item on additional funding for this program using State Aid funding. An updated State Aid Funding summary to the year 2013 has been prepared to show the impact of additional expenditures for seal coating. Item No. 4 -GIS for Public Works Assets A power point presentation will be done to update the Council on the status of GIS and examples of Public Works operations using GPS/GIS. Also a 2008 work plan will be presented on the major highlights. Item No. 5 -Public Works Updates Mike Hullander will present an update on the Fleet Maintenance Program and included are reports for 2007. Also, staff. would like to discuss the signage requirements by January, 2012 and to show a number of ideas to include a City logo on certain street signs. Nearby Cities are doing logos on street signs and staff would like to introduce the idea and get Council direction on whether to include or not. Finally, an update on the additional street sweeper purchase will be discussed. Major studies have been done and are being done to analyze the different types of sweepers and their advantages and the amount of sweeping for cities to consider. Most studies indicate that the City should do more sweeping as a storm water quality measure, particularly in those areas of important water bodies such as lakes, rivers and streams or where no water quality ponds has been incorporated (i.e. downtown area). Item No. 6 -City Project Updates If time is available, staff would like to discuss the status of C.R. 77 trail and how to proceed with the project. Staff has two designs that MNDOT would accept depending on the posted speed limit. Staff will discuss options and attached are the options that meet MNDOT criteria. Staff is thankful for the opportunity to inform Council and the public of items that are progressing in the Public Works Department. Not all areas were covered, such as the Park Maintenance Program and projects which will be presented to the Park Advisory Board on March 31, 2008 and the addition of L-16 lift station and interceptor from the Met Council. The transfer of these facilities became the City's on February 22, 2008. ACTION REQUESTED: Discuss various items and provide staff direction on: 1. Eagle Creek Boulevard preliminary design from a 4-lane to 3-lane. 2. Road segments to request Mn/DOT Speed Studies. 3. Discuss additional funding needs for Pavement Preservation and the transfer of State Aid Funds to the General Fund. 4. Discuss whether to use a City logo on street signs and what logo is preferred. 5. Provide direction on C.R. 77 project as to whether this project should be completed this year or not. ce Loney, P Public Works erector ENGR/2008-PROJECT S/2008-COUNCIIJ W ORK-SHOP-ITEMS PUBLIC WORKS City Council Workshop Agenda March 11, 2008 1) CSAH 17 Corridor Study -Scott County Presentation (60 minutes) 2) Transportation Issues for 2008 (30 minutes) a) How about aRoundabout DVD -11 minutes b) County Road Coordination on CR 101, CR 17, CR 21, CR 83 c) Eagle Creek Boulevard from CSAH 17 to CSAH 83 future design discussion d) Speed Studies in the City of Shakopee -Show Map e) Traffic Studies for 2008 -Show Map 3) 10 Minute Recess 4) Pavement Management (30 minutes) a) Program (Power Point Presentation) b) Update on 5 year seal coat, overlay, and reconstruction projects c) Additional Funding Discussion 5) GIS for Public Works Assets (20 minutes) a) Status of Project b) Examples of GIS operations 6) Public Works Updates (30 minutes) a) Fleet Update b) Signage Requirements and City Logo on Signs c) Street Sweeper Purchase Analysis 7) City Project Updates (5 minutes) a) CR 77 (Fuller Street) Trail b) 2008 Street and Overlay Projects c) 2008 Cured In Place Pipe (CIPP) d) Atwood Street Railroad Signal e) OPUS Public Street Petition. f j Beckrich Estates Sewer and Water Extension g) CR 101 Bridge Replacement, CR 101 Overlay, CR 101 Culvert Replacement h) Storm Water Management Plan i) Storm Water Ordinance 74~m /a CH 17/TH 13 Corridor Study Shakopee City Council Presentation March 11, 2008 Study Purpose • High projected population growth in Scott County by 2030 (and beyond) • CH 17 is a key link in the transportation system -links to 3 river crossings • Identify and address immediate needs (now through 2030) • Plan/Preserve for post-2030 needs Develop along-teem vision fog CH 17 / TH 13 Stud Area v ~ ~ ,err ~ ~ ~f'° SEGME~JTS E 3 F ,-'4- '.T 1 1 ) R[ I~ EX Tlf`G ANO FVTURF -_~'J V NiE IJN hU 3APEfY 156 CARVER Cb ~ F iiENr ~n~cor~u-rt~r I ~ .r ~ ~ i.~~ ~T^~, ~ SEGMENT 4 .i ~ q p ~ E l,Ua3E CnF6TY nN E_w rv E 3 ~a j 'r y ~Y- c ! SUt~ Gi J txt LOi~r 1 t 1t~JNf s-~ ( j ~ ] ~t,. . ~ ~5 ~+a ~~E~. ~os+inur rcn ri ~~~+'1.~+ iix~:etienrAtozemsi:cneo SEGMENT G vY tn3 INTER( nN~.t ~5 ~ IHtI ARl A}.DRt CFIAILt ~Y 1 ~ .rll~ (1- t CF I -t+F R C) I l i ANCIS - Tr:J 3 tt t HIGH l~3t N]IF _ '.~C IL' 'f~ _ ~t' atia c oer aEi .tier ~ ~ n _ ~ ~ _v_ _ _ HhTUVI AY tkF'AN 81J _ _ ~ t r' ~ ~ L r~.~ - ~ L+ , ~ ~ , ~ ~ ~ ~ ~ .r ti I ~ : ~rr~J' a.~ , i , i ~~na~ nc ~ t 'J ~'+~rt ` ~~GMBNTS A 8 & ~ ~ ' ` r uE'atL A ~lNr-rErl e h oli ,'p -1,. ~ 1 PIIR GH I, T ~.Y A\D 5 PFC ACING p[FA4WAY _ l ~i ~ t GE~INE R GAIT OF\ hY HEEG~ FJR 1 ~y - I { P0.C SEAVAT n1 RNf A[. ~f Cl'.i[ f1AN~~C~R~NT t i\ IAA PEAN TS S/.FELY PR ID,, liC l 1 GES$ ~f Hitt NT tiih 1 NV II JF UW AY CR3 hCIIY t r , r f - f J ~ n 1 .r. f `~~1 , J i m.. _ e e r ~ ~ `4 . ~ ~ r c7 ,o.. t.ti ~ ~ ~ ~ ~ ~ t t A ' ~ ~ L. ~ e,. S \t` ,s ~ r ~ ~J`~ -,.,1 ~n,n~ r I r- r i I LESUE.UR CO 'I~, ~ _ RICE C.O Study goals for Each Ssgment ~f ; ..73.r~Er7f. ~P# CSAH t71 TH 13 Corfidar Study IE .7Rr #r{r 5cbttGounty,Minnesota r. Study Participants • County Staff -Planning and Public Works • Mn/DOT • Cities of Shakopee and Prior Lake • Cedar Lake and Spring Lake Townships • Met Council • Shakopee Mdewakanton Sioux Community • The Public - Citizen's Advisory Committee (CAC) - Open Houses (April 8, 2008) Public Involvement GH '17 ! TH ~13 Pubiic Participation Plan Committee Roles and Responsibilities, and Decision Making Process Input from Smrt County, tdrrl~OT, Cllks of ahakgpe~:. Prrsje!tt CommuritrntK,ns- and Prior lake. ~n9 Lake ! Public MaeGngs, EmaB, gym! amt Cedar lake TownsMps, i Wots 9ita RaadbaGc daC H69U131(Ny ftgQn(Xe6 Cftlxen`s Advisory Committee {CAC} Review and Commenton Protect peliverahies Communicate Issue5lConcems piCOnstituents Watkin Cemrtlittees Provide Dngoing Suppntt, Guidance and Advice fo 9 Scott County end MnlDOT Provide Forum7ot Diseussu~g'5trateg(es Serve as Fro)ect Advocates SLT Study Leadership Team (SLT) Ongoing h4anage and Deliver Project oiuuesion3 Prepare Deliverables for SIV1T and CAC Review! Comment ~Aanage CommunicatPons and Intergovernrnontal CAC SMT - Concerns stutly t4lanagement Team {3M i ) SMT ROCOmmetld8t101'It Review and Comment ort Process Delivery Ana Technics! Products Provide Directipn for SLT Review CAC Issues and Concerns Prepare Recommendatipns to~3elutions for Sant • County Board, City Councils Tovrnship Boards ord !An!D'~1T Sco ; Cti~unly Bvaid vn3,opoc Clry Gcuna~ Fnu I ~kn Cry ~.DUnGd S t~r~nJ IdYC Try++T15h 0 ~lyd ~~r)ar Lnk~ T~•~M quip Owrcl Mn2~07 D6clSlnr{& 'Long Term i'lan for CH 17 and TH 13 Traffic Demands are Growin CSAN i?lGSUrtb! fbf7fiUAw //////CS~N fOllSpMFM Bt LSA1/1Tf C&W IYI - essen {gnuxy766Ty. i - ~ fS. R 96l8P i ° R ~ NQf56tl 7'ja0: pgp +tr ttryblbttl 8 g. i ~saorT~o' - _ - d ~ 4 P 8oraoo .1 4.._ f26rzm ; mt~a C mrm fbsfo .f h. t F ~abt~b.t k0itrs24 {s ~t+teo~q w ;,eb76.. $ aaor+@p .r ~ €DtK+ 301:60. ~ $ ?2cr~m~Y ~ i ,,,~na,~¢0' _ . ~ ~sson a ~ _ ~ ~i~~ ~/i k:~ i ~ - r r ~ ~ed~r-_~~t ~ O i CSAH)ettdwa.lSr ~~hn•<_ tx~q: ~ C ~ cSUtf]+1(NAMf ~ e p ~ e,~a,,,-... w ~ ~ Ftr / P $ LSbfM ri , 3 L wr;o a'~p^ ~ ~ ~ tb0r,ro t,~ ~fieko ° a ~ aObij Fill } ~ 4 ~ ,a,z~ 1 ~ _~ht ~ t. o k... a.p mP+l~a; ray.: ~ ~ f81 t0,1 ~ Z. sto+taob o o - ~ ~ ~ ~ CV 1 ,s iora~ ~`oR ~ N ~'"",s N A. 9 e ma.~ ~ GsAN tbIVMMMU6sf r,.~"'~ ti „F A., 4/ 4S --`-----w- a,. e / ~ ~ ,v.ynn ~ R g,,. t, torso csarrr~: s~,e c~mve p ~ ~ d ~ a tKC'n>.C {~I(AUwa2Qpbf c. a i < n~^ d } 1~ f :a.c - ~ s wr3o.t ry t ~ ~ ~ t ~c,sio r ~-.r~ F r ~ ~,~,cw a ~ ~ ~ $ SC sabrsa o, 1~ I ~o ~ ~ q ~ ~ 4 s mmzsb ,,,~~,~.vr~„ _ - _ ~A.a I ~ ~ enrla.r. R. aaee6 7 a ao ~ ~ ~ CNU117tYpT ~ <.n.u.~ ~ ~c:+rm n.a~._ 2 Sqf. $ 16r2G- 2 i~ ne.v u;. R 8 !S. b Y/ 1 aw mt~ Legend > bbrlab 3 e ' d ,AM I PM ABBk HpG~ 1 ~ F ~ Tuminp MaYgment Co¢~1 aorab ~ ~ F v~k ~ ~ rnr~c ~ ~ ~ w ~a ~'s ~N n;a pM Pbalt H,bur7wning- a StlQ to60 ~ $ ~ M, MavembntCaxlt IIIIIIIIIIIIIG:Wi7Fea 4---,~, v~a~~. xX}6~ fulureAOT ~ ~tio vn. t ~ ~ _ _ r SEGMENTS F & Traffic Demands are Growin g k4AC` _ ~ P rrk -i -?l ~ ro cswr nt 4 Q'~ CSAN 77! v ,~`,~~/1} HsNamn+mP NrYnpOr _ } I ~ ~G ~ - ~ ' ~j/ r , e s ~ t F ~ O p -~rr~ ~ '-Q 'L ~1'4D ,v'~.y" ~ L 841114 G~~~ ( ~ Q c r ~ 4 i ,~irxi . s ,~~Q r ~ t swraitti d` ~ y a ~t h t . a ~ ~ iao,i44,,. h 1 4 I„a<c+ 169 as4r~sa ~ ~ ~ ~ t ~ ~ 4 ANY. ~ T ~ 4iwN'i" _ \ r,`, ,695wMRmep csxea7r,7m~w - ~ 24Q.~O,e. o 2a~ao ~ aw-- r 4 ~ ~ ~~x,r ,r { a rwr~s4 ~ ~ ~ xa,r~ti .r t r .,oi4g4 .4 h - r. Shakopee 0~4 ~ ~..-g alora~fo - etasr, _ d _ ~ l.~.nA * ~ ~ ~ NP,~~„- p ( ~ . ~ -msrv;m-.._ csaf 171SiwNaUA~e ~ i~. b $ c s.M~ d°-rwc° $ '44 Tf4dJAD ~1 ° a F7. r 1414 e •,!M1 ~ ~ ~ 34f 104 ' 17000 .?assri ~ d?A ~ 1 mria J ~ ~ P. tSRH tT.'CR7t - e` 6 Jackson ~ o ~ -Pexe aw gg LOl iL N ~ ° .r 50YG Q d ~ M p ~4ra ~ 5~i a SdOrB14'{1ti 0 4 ~P.! v Lux3F4C0 s ,vw~u,w i~ rwro~~r,_ ° ~ Ff +ti 9F70 i, J ~ b F 7tdlaEO .inn, - Legend ~ j , '~.M YAM Ceak,+4w- ° " z 8 _ minq Movement Caunl r,~ ~ F P ~FrSmcalmrhin~ °~~u ~ j r ' 17oao ?C?IX.?f 'fuNraAl~T Frnaµ n`a tr i Traffic Demands are Growin g i_%' r Jackson ~ ~ ~ v Twp ~ a ~ ' ~ - 3va, 7'~Q~O 2AJ~ Ave - _ina~ qg .!t ~ ~ / ~ ~ See Segment C ~ ~ N ~ ~ , , ~ N a _"„'r_ e_" Fc 'r O O i i - i t - ~s~`,, ~ s r Shakopee; ) ~ ~ n t3oina00o ~ ter ~_aa~sv , • ~CSNI l7lC3Ni1< ~j~ a.tec La-.~ , / /j/ 9 a' l ~/r' OO A s Pncr a~ } 9 " Lake amryso 1 tD x'0'3 h ~ ~ , cxwniaqu ~ , ' tC v. ~ R E Avg ~ ~ i 4 s a~ofxza h _ ~ 1 ~ ~ t ~ ~ ~ ~ Z CYMf17rCSA~r to t sP . ~ L t801tA6~~:, _ a ~ l +stu' pct J ~.~4 r+aorso ~a~,a .r _ ; ~ _ ~ Sand rotfu h t N Creek ~ O - - h r. .ti i. \ 8 6 / v Legend _ ~ a'- - nMrPMPeaktlair _ luming Movement count ~ ~ - ~ ~ r . ~ i PM?eakHuurTum~nO ~ ~ - ~ Movetpentcaunt i ~ ~ t. ,r~' > a ;C)}"jfij( FutwaADT ~ _ ~ -~~500 n ,;~so zsoa ~ 8~p0~ ti ~~._~~7~, Y 1 SEGMENT' B Traffic Demands are Growin g r., ~ - _.arior;. Lake;. s r .Z r~ 0 _ See SegmenE 8 T pppp ~ r..,._. o..:.~~ 3aatl ~ ~ ng .a, o - a } Creek ' } ~ lake Tvrp- ,3 1...,.1:. t I F j ~ r1 iJi CSAN itl T y ~~V~ 244 s S4 n+~,tatcs~x~ E \ ~ ..t ~ 4 so J ~ k nxp r . 4 ~ ~ } r 3~ OQ ~r ~1 ~N~;r, ~c z e z ~n , s ~ .~I J t ~ j ~ I t4b yl } ~ ~ ao j _ n\ ire,' ~ tl s~ /~s'~~ ~ t f i. - ~//An' la r3. ~ - S Cedar ' I LB ke iwy. ~ n+aarxem+sr r' m»rcrarse ~ ~ ~ tG ~ a ~ ~ ~NS FlSnh $ 3a ~y0 / ~ ~ 1~T ~ ~ ~ In r ttl. r -Q --"~-,..,..,y,%.-' ~ ~ Jf 9dti Q.o 6001 r..r 1700E c nHn ~ ~ h! :h ~ ~ s. Legend - ~ ~ _:.~,~e (Q pM1PM peak HOUr O~ 7Nf0lfl11P '<.Y- Twnmg Movement Counl ~ ' - O nM Pelt Haur'FUrnin9 C7a i- eo MavemeMCo~n~ 15404 s 9840 ~ e'.s: ,,....,,eo ...E } ~ ,e ~ulvre a0T ;ue~~ ca ~ ~ :a+ r ~ t 0 0~ sneer ~ / C R~ (A~~! ~E~IYI~tYT Findings of Fact • Key N-S corridor -Future Principal Arterial • Should address mobility, safety and congestion - Pre 2030 Needs • 5 lanes on CH 17 north of Vierling Dr • 6 lanes near US 169 interchange • 4 lanes on CH 17 south of 17t" Ave • 4 lanes on TH 13 to CR 64 -Post 2030 needs • 4 lanes on TH 13 • Preserve R/W now to avoid costly buyouts and future delays • Access management and supporting roadway network • 2030 improvements -not preclude longer-range needs (post-2030) Community Issues • Prior Lake -Safety, congestion -Emerging development -Access and local circulation -Supporting road system - CH 17/TH 13/TH 282 Intersection • Commercial Industrial node • Cedar Lake and Spring Lake Townships -Safety -Access and local circulation -Supporting road system Community Issues • Shakopee -Congestion, safety • Future design of 1St Avenue • Future design of Marschall Road between 1St Avenue and Vierling • Marschall RoadNierling intersection • TH 169 interchange operation • 2013 Project - St. Francis to CR 42 -Access and local circulation -Business concerns -Supporting road system Segment C St. Francis Avenue to CH 42 • Construction project programmed for 2013 This study includes a preliminary design / geometric layout - 4-Lane need through 2030 - Resolve numerous access issues - Define R/W needs - Define intersection configurations 1 's ,A e 3~~ .~,~t r- f, _ _ r. _ .,a~ y . - a r ~1 ~ - T 'w ~ ,tip. '.-,~'~'saM:ry'~~C ~i~i ~ k tiM ~ Y ' '1 l~a.i Fes".. ~q•' a._ , . ~ j _ ~ ~ _ t''~ _ ~ . a 4~' i ry f ~ . . . ~ y 1 i~. ~ S? w. F r' 4 , , 4 ~ a E . ~ a CH 1 I 'ew _ _ / e ~ e .3~ ~ j n' i ti'' I 1~~ ~ IJJ ~ ~ ~ ~ 3. r { ~ 'i ~ f - t *ry t ` t _ Jl~ . , . C ..n Y ~ _ . ,]k ~ ~.i ~ - , n q_ .n I J-r _~1 - ~~1 s _ rr. J~.. 1y/ Cr 1 :a I ~,1 CH 17_ t C _ 8 . ~ - ~ij ~ ~ ~ - Vt ~ _ r' . ~ t- t Ste. 1 - - - ..e F 4 i ~b 4 ~~'i~~. :,fir kh ~ {r ` ,~.,a i~t ~y . _ ¦ C H 17 - Wood Duck Tra ~ I to CH 78 , I~~ III ~4 ~i~H4~9~5 1' - - t rr u i r - . ~ ~ y . 1 ' I t .,k Y ~ , ~ r * .q_~' J - ~ q 1 L _C _ 1 _ ( ce t 1 . ~ ~ a~ . . ~ , ~~,;,w k ~ h l TT ~ ti h w fC^ ~y4 i~ ._*6` ~ ) Kr.t.` ~1 r _ _ ~ ~<< Y~ f-w ~,1.. V~ ~ rr , I lt~ ~ ~ { ~ . ~ ~ ~ f ~ 'i~~ ` i t ~ ~ Y 1J~ ~ ~ f~: ~ ~ ~ ; ~ ~ i _ I Ili ~ f' 7 4_ _on r~. - ~ ! . y ; u ~ J °i L d ~~~c„- ~ . ti.. y ~ { r,i w . ~ ~ J ' r J L~ ~1 2 \1 ~ t V i _ `x . 1~~ k ~ ~ ,f r . Long Term Considerations • Post 2030 Needs -Future 6 lane expressway? -Future Freeway? -Possible interchanges at CH 78 and CH 42? Next Steps • Public Involvement -County Board Meeting -February 12th -Prior Lake Council -February 19tH -Joint Township Workshop -February 21St -Shakopee Council -March 11tH -Public Open House -April gtn • Refine Layout and Study Results • Present Study Findings -July 08 Questions or Comments? _ ~ k ~ i . @ ; Motorists a~j ~ ~ . ~ ~ j I v` • When approaching a roundabout, slow down. For F"i ~ ~ ~ r r multi-lane roundabouts, as with any intersection, ~ ~ ~ ~ i t- get into the appropriate lane. rf y,; ~ ~ ~ ~ ~ y ~ ~ r ~ _,J ~ •~l • Yield to edesrrians in the crosswalk, because the ',tt.:.:•.~;:::~` ~ ~ P Y ,a ~ have the right of way. It is the Law ax~ • , f • ~ ~ ~ • When entering a roundabout, yield ~v ` ' ~ to vehicles alread in the ~ • ~ ~ ' u ~ ; ~ rowadabout. Merge into the traffic ,f,~~~ a;, j - rr, 4 } flow when it is safe. ,~~£5~~~ .p ~ s • ~ ~ ~ • ~ ~S d n Jf. ~ . • :iii • • Conunue throe h the roundabout t ~ rr r ~ g Z r •r ~ s ~r a+. r ~i~ i •l n.v 1 rr+.~ r ~ 1 unul you reach your extt. Do not ~ ~ ~-~f~~~~` ~a 1 ~ ~ ~ , ~i L stop or pass in a roundabout. r '~~<~rr;``-;z ~ k,~,~ _ .r, ~ ~ • If an emergency vehicle approaches, r ~J4 ? z r : •;x- ~ ~ exit the roundabout immediately ~ ~ ~ r ' :e - and then pull over - do not stop in ~ ~ `z ~f } p ~ ~ ~ li the roundabout. ~ ~ ~ - t , ~ ~ • When exiting the roundabout, signal your ' ' ~ ~ `l` ri ~ x turn and yield to pedestrians in the crosswalk. ~ • ~ h. y ~ : t~ ' ` ~ b I cy~nsts s r \ern; , t ~ ~ ~ ~ . x_ ~ CSC i • Cyclists can either ride with traffic inside the ~ y r[ s ~ roundabout or use the crosswalks appropriately. ~ • ',fi " t r, ~ atr~~` ; i • Cyclists who ride with traffic must follow the same ! ~ ' rules as vehicles and must yield as they enter the ~ roundabout. Since traffic is slower inside the ~ a ~ r~~ roundabout, ryclists should be able to travel at or ~R ~ , near the same speed as motorists, staying in line r • tr , ~"'~~:~1'`° . ~"-`r Y ~z-~ 4 "'w- ~F ""`s~ with the crrculatrng traffic. 5~5r ~ ,,~~i'~~, ~ • Pedestrians yes®urces ~ I, • Cross onl r at crosswalks, and alwa s sta on the Y Y Minnesota Department of Transportation ` ~ , ~ ~ designated walkways. wwwdoGsta[e.rnn.us ~ ~ ~ ~ ~ ~ ~>t~ 4 • Never cross to the central island. Federal Highway Administration r ' ~ 3 ~ J, www.fhwa.dot.gov , ~ ~ x~ , ~ 3s • Cross the roundabout one approach at a time. Use t 3 ~ insurance Institute for Highway Safety t the sputter island as a halfway point where you can _ wwwiihs.org ~ y ~ _ . check for approaching tragic. ~ o~` ` / This brae%ure is a nrpPle>:rent to a ' ~ DVD which rr avai/able by retfrren at: ~ * . I www.lrrG.org nr 651-282-2272 u< How About a Roundabout? A Minnesota Guide ~ ~ ; n„•~~~ Nananfirr2006 ~ ~®r~a~®u~? F~~~r~ ~ ~7~sa~rn ~~~nc#ab®~~ A modern roundabout is a circular intersection G;here traffic flows around a center island. . - } Today, roundabouts can be alternatives to traffic =r-~~-~-~-~~°m°°x•-~~_ >u'~x ~ ~ ' l~.I Traffic Flow v ~ signals and stop signs to control traffic. In many s , cases, they have several advantages over signals and i ('~1VE Ilittnf 11t~Irkln~S, ~ ,I Pedestrian ~ curve ~ at envy putnla ~ , i stop signs, including: ' ' •~~.~r' i Crossing and I~uSed islands direct • Pewer injury crashes and fatalities ~ i tl"alllc, IlltO a one-uvay ~ , • Increased pedestrian safety Splltter Island ~ far COU11ter-Clockwise fiow ~ ~ 2 ~ ~',l ~ around the central island. ~ • Less vehicle delay and pollution ~r Roundabouts, like all intersections, under o r thorou h anal sis rior to im lementation go TfUCk ~ .~ti~,• 1r~"j..~~~.+'`~,.~ CIrCUlatory g Y P P Apron ,~Y,, ? t ~ ~ ~ Roadway determine if it is the appropriate solution. , ~ ~ - x ~v # y~ N 3~~~ 1 E u~v 4..tiy i C } # .S'~j ~u ~ as 3 _ . 1A-.. ~ r J..c s ,rr-:~~~s};„.R9 Roundabouts can dramatically improve safety when ~ r7' ~ e;f~~' fit' ~ v ~^r. t~f x..~s~ compared co traditional four-way intersections. In ~ J ~ ' ~ ~ ~ ~ ~ ~ ` ~ ~ ; fact, a recent study of 23 tntersecttons converted to r--~ ~ ~ ~ ~;4'~ ~y ~f ~ • ~1 ~ roundabouts shows a decrease in total crashes by r~.---~---" }'S ' i ~ t'`r ~-.:---T r ~ a ~ ' 39%> a decrease in in u crashes of 76%, and a t 1 ~~x s ; ~ Y~: -~r`~r t i 1 ` dramatic 8)% decrease in fatal crashes ("Safety Effects ~r.,~ ~~~~t~ n 4 ~•.~.,,~3.vj f of Roundabout Conversions in the US." Insurance Institute for s.,,u~- ` ' " ~ ' ~ , K~. Flighway Safety). 8~~ ~ " ° ~ off. ~ ~ Yield Line Curvature ti~~ Reduction in Crashes After Conversion - t to Roundabouts (231ntersections) fhe Size t~f 1110 ~ j" , r Yield at entry o roundabout ante 1110 4~~ at I r~~f`hc cntcrind the o% angles of enUy rare ~~a~~ - Clr'Cle yleids to traffic ~s~ e ~ designed to Slovu the ~ ~ alroady ill the circle. speed of vehicles. i''. z N • ~ i o'``~ - w o - ~ ' ~ - s - 4y, 100% ~ 4._ - _ ~ ~ - . All Injury Fatal ~ , ' ~..e~ y Crashes Crashes Crashes t , -~:.F _ " a -s a.~~ ~ ~ ~ ° L.~~ ! - pa ~e ~ 5~ ~ I l1! ~~,9 t~-{a f ~ r4 tJ"f i f ~ - - ~ ~ d fit- ~ ~ F E _ _ r rv.v _ ~~.•.a`gKeis" ~ ..C. `3ki'~`.. +w.~a`a3a~~...10 , ..v . _ ~ L..c6.i..- _ - ,..Ssa.._ "3 n _ _ _ _ I ~~PO~ 2.6 ~I r~~~ u~~ ~ ~ ~ ~ ~ ti ~ CAtF4EH WSINSY ~ ~ ~ ~ ~ 9C~'aT tM1UMfY le INNE`'dT Q ~ o ~ I F r~ (91 ^}4~J~ ~ 1i~Ai~ f r: Z o Z ~ ~ r~~. "a fi~@ i°=1806' ~ , I m y m m ~ 8 m B ~ ~ 1 ~ `~""~a,:R I ~i~~~° ~'~;a~aa~J ~ !I ~ ~ ~ ~ ~ ~ ,a m, ~ ~ ~ ~ ~ ~ I ~ ~ ~ J PPiC "?"'7~ .,f4 t I1 M ~ ~ ~ ~ ~ o ~ ~ 9U~Ns~ ~~~IS~'~~ i~ ~(,~a`a'~ ..xz~..~P € "~i.,_,~ r'~' :h ~ ~ ` Ul ,Iii r----.~"'_"~~... ~ `.,aa J~ ~ 3 fj`~.~~ ~ ~l}~~,~ 7 ~ iii 7 `"mow.,,.. I,. '~J I IfJL~4Z~%8 ~ '~a: ~I i umam m H tt ~ '1 rrTT11 I' o- _ PPS6@ Yd:B% ~.SR LaRX s Ew-1 i~~~-r ~ O ~ 0 i i ~ a~ ~ ~ oq ~~1~_ z z n~ o a ~ ~ ~I i ~ U i; ~ p ~ i ~ ~ , ' § ~ z~ ~ A~ _ ~ A ^ .1 5~,wel~ ~ - Potentia] Roundabout Locations of potential roundabouts include but are not limited to installation ofMini-Roundabouts, Urban Compact, Urban Single ~ Lane, Urban Double Lane, Rural Single Lane, and Rural Double Lane Roundabouts. sHEEr No. _ ~ 2007 Accident Incidents a `r•,.r Cfit.~'°a "~'i `z °d ~1~ ;.t~° .a.'~~' ~a + =m i ~ ~s;= ~~+,a;, ` r,fi ~ )i i. ~ r, . i i'1 4 q {r., ~ t ly~- ~ T'r nCWOU~()I;y y^r 3 P~ ~ r~~ r. i 5 f va: . ~ ~ , al ;4x r •>r .t.* . r : ; P ,er »s.r ~..='rYr Ctft ft t't aa`g 'b.~ ~ f flr s(,nenrrat.1riymL .°=C ~ ~ r?;. ,'r~ ~ ,b°" t a, t 3 a., + m` j}" . - A' r~.,...k. a rt .a'°'1, ? vim. .i p ``ds':,,' r~.~K:: .r - 4rk' ~ +d . r r~ p : r..,r .wti,.r. - p r ~ ~ ~c :r:`x~ 'A •.7 9rm~ +,r ,3.. r. y . b". ...a ,C w» .3t' J. /r ..f ~,~fF ~ ..w ,d-0 e ~ ® t'"'v. , r Co . i,'^t" r , .f;Pp r. fr R.' t~•, a p:+ ?r'i`'?1 „i•~'a "a, f~ '~,.a..~+~~ ~ "x. ` r,,. rr w' • , ' n P,,, 1; y _ t ca j: . ~ .ct m x'? a:,r r ,i.' F~,~ ~ ,U t ~ " t,,. ..a F'--.^ ,V a. 4" '"a`i ",t^6i:~'n 4 t..(^"j'^'!t fi x ~;•~.y. ..;1. ~'"1~. IUrlr..ti... _ . s ~ fed, ~ 4' . •'+J• ~ s.. ; ~ , , u~., a - r{,Eashr,st Avct' awx.,a,< ,Shenandiedr Ur r c, f r.rhl3j. r yr; `,m~ a'... I'`~' tp - ^fk!~ . ~~'°y, t~A~ - - c~k .r ~.g~ • * , tr ~ v, ; ~ ~ ~T{rt~r~r ~r r ~t i#fr~Fi~r' cC ,,r,, `.:F,7thA~2°, fat 's" .:rr.r ,e t. ,tits; ,..~i"sF .,m:: _ t _ a t v;~m~a ,m,.. ~ .4 ~ lute ~R*~ - ~,r:; . xr l :ink IC' p •ryr i } i ~ , ,~.I ~ axsvR. , , Lt # :.s, ~ F h's:. d ,7"*_1,,.L rJK i r r i7 ~ : tiwu'.,ti I r ~ lr ..t, f ~ r ,~~c.. ~ ~ ,~Icr (nt.F 3r Er. . ,g1 r . r y +w4 ;.'sr - .7r ~ ~ +`@ 8' r, i ~°i ac:7 t^ . ti'7 ~ r a ,f < w b ~ K '-'r^'.. z i 4,-,, ..n, ~4:- P e~,... . _^~C .'r X`. ;E~rt~a rB rr- °r~ FC ,.,w - , s, n. - '1 " f 3~a ~l".;~-. ,a n- rrr-'~ki'a$v • -~x .ti.~ ~o ~ r t r`'" 8~. ~ ~ a ~2'` m' r y{ t r t~0 ~Y S'~ : Y ?ah '~.r(~ ~+T~ yl,a ~~.g;i '9. C f.~.a { ,~M.~Y1 ~~r. ^ o k r ~^p tit ~ . ~ .,„t, ~ 'rtw,w ~T r Uri, ` i . t a~ ~ ~ c , i. , .r ~ ~ a i 3, t t . v a r.,~'.~ . , f r - - PA'' q,r . ' f_"" # ' f~'FT`~'t~~ , r tzu.k,ara....,a „ i ,~,",;*~,s ""'`"""'",Shalopee;l~e .,~~v; ,,P`r^'`+~~,"~~c~.!".x pia T rr: .x ~S _ o ~ ~ ~ , m ~ c,~ . ~a:2, ~ ~s - ~ a>R ~y' J~ v~' t1 v. . , ~ i .r.3a V„ c. a .~77,,. 1.. R a} s ;:F.~€, a*a..r ~t t'k tz,. r~' e ~a` • ,ri~*a» ---u lUth.lKe ?rk~,Y'r„~: ~ ..ru a ~ a~ @` ~ ~ I , ~ ' a ~ >~a a ' ' ~ .:r ~r ~ A~ r r-- r,::. m , -:1 a a"" . <.r. r . , 2 v, ;k a' - ..e s".'; 4 ;xa d 0 .fir k":..r +..e .r.t ,n `tT>r, g.- . .•,,C. ; r {r ~ c- f ~ # ..ei y 'q,.,t ` ~'°+k„ 3'• ~ •47 ,m„ ~ #t 4::®k.. s - -:.F t~mt.5.s ae ::~k E% C ,?~t Kt. .w ,.tit t1 Q., rE,3t.,i r=, ~ :+..o 1 ~ 1°`a ~s r rt+" rM r-, „ t ~ w _ r XtP~. S, :a. dF, a~ ,J. ~ _ ~f YI 3 .ma.f.=.- s. r_ t~:~jm.. r ,.,4 _ r, x~ 1`c'...1 a~::... r+s ~ r r +6 _,r ~y - ' : . ~ arm,;,:., a ea.... ..,J: t -_:..,a as,~ A ~ :f °,i-~. t -~~~fi 1 .}65; ,r~ ti-,. ,~`-,t~ v::. r F~ r., e.,e x,d,;,, :G,,:..a Irk m .5 eMy i ~ -'L ~v,<„a.,..?6 t.a_;~tlx.~~ ' r ~ ~ is ~ W ' z r ,Y, a 4 1a y ~ ~ a jfiib~, . s`~"'. (~p~^, # a ,,p ~r, r ..,I . r a a1, 4.. ~ar';s 3 i.~. . , ,i' t ° '3L~1; ° : e i :.d!°.+~""'r +I, ':',d ,ter e ,rv: I< rol x ':r K@Y , c, 9::4' . 1 ..rxro-, ~ r .~..r.: ,.'k, r~, .,..,.d { K~,^ ?k~+ v. i. lr ~ ,,,.~.'~;*a ..3 f% f -1 i.'~*x r~ r a , ,c':• .a e ~ ,°s , „K..:v`+ Ya '.»y„; Y...¢,.. ~'s .r`?.. .`+a, ; In e::. G.,.. r.,x: r i,k, tr ~ ,1 ~ ~ 4t a: , ` ,S . t,. ~ t'a s. r~ s ~ r ppfd ,w,; l n, / "+1. s ~ ~~",y„:;, r m t. e,f.r. ,..,r,.,> o_ , ivy . -~f g.x,, 'Q r ,o- #?2.. s s 'ti F`'w .v T`~1d TP" :Y::r 9 ~ r ,y .~r 1. v, i. . , 7, r..r $ .o-, ..n ~-°tk. , .C +x 1. ,.1., m„ :rm._c 3 .r,,,'~..... ....,+.,,H.lltltAve:~,.xk ~s ~ .aaaA. e~j'~ ~ r v. ~ t g e 4.. 4• a, t"~' h ~p " 'f, 3,.Y- ' ' 5, ,~'.C t' ! -rr--' `ri`a. m,y d~ a ~ ~ ^ tr ,.r.,:. ~,1 #'~.:Pr.nri< Let+" v . , _l'n J`t. ,idl~ . x, ~ n. .f, i~ rr' r,,. uqx t,. s., , :`~~R -....,r t<,r~h:. .rte ~,'~*r C^r• '12th 1rch.s, „ ~ r;r F r ~ , a'.:~~ , ~,r .ter', 1Pt5i;~'€.r t •~r~ A~- +~#.»~J8 1A .f r - ~ . r~ ,,ate .r., +r- ,wr r ,..r<,..>w,.. Y ~,2. ,'f f 'rprn3..'. ',g'r•'C•£e~ p .,Yf`~(S#.~ ~ x; #r .,,a ^!~17.v'a',~. ,r„. r, x..rrar,,r~~ ` x ~ ~ ,:t r . t.,, < peer (t s x ~ ~ r F tt r r .z~+, i t~ « i~t ~F, ' a, ~tpr, alt ~:r ts, .a~.n, p d: x.. r ,.I' ,,.r' fi', r'`, ve+ t 1~- .~»~11 r:lta. a r4 x - l ~`3 ;4 r r , Car' r.` r. m k p:,:..',., 'a, > r ~,~,.x9+,, a it =^a * ) ,i. C ,nr^ Seerehuiatllr +*;..w tPlq' ~,.ar„ t: :,.-.1 . a' ~.a a t, r. rF,. ~.,r, e ~g„~ p~"e «d0 r~° ~k,. r' ,»r,.,,' ~r s'~ r. -s w, t . I k' ~ Y , r gr~.., r w.~,,F"'"t, ,aa r m.; d asu~ q`. ~ t~~ {"ilk' ) , AS't., Y ~ F°. r r~ s, gg ¢ y. Kf ;!r` f`,-~ a.:,r, , I.. r.; to t rt'` ,r'i rt. C: ! ~ , . "4. .:;1 ~ t r',~ a. . 3 i , F~ $ ~ t k. ' `t+ ~ I. a r+d4 ~ ~..e„t"ap.M.&F. - ~ ~ . h=,. xrl. a. .-~~m.;: y° , . ,z. r , ;49ur~hoA3e ,5; ~ e~;;' ~ o t '>!a ~ IsonecrTr, - r#"y":. °rt; y. v ~~i, i ,ff - r ..'ss e,,,,,, ,,,,i~rg 4.a=:~~.: •m 7 r,v ~ i r~•,-~ 're 1 rs, ` .!'xr ( : f''.rr.. '.r°r- , , , ~ 1- r s- trr~c r t"• Om~ Dr ,.:r~w^ ~ ~ u,F ,:t I, ~ .vF. ~ r , « , ' !+n ,;•s , ~>ar, .lrv '~(y ~ , ~ix...~s L ~r i ~--~r tro i`:-° Y a „?'.t; , , ' + ~ ` .tb " ~ r, ,.r„.;,. dm - _ ',n sr e , tc;~,~v ~ _ "n, . ^ Granite Dr r~ ..a .ar'qg~~.t ,t. € ~ e ,j6v r ~,.a r'„. < +G.t ~a?5; ,.,,e , f.,, 1+ r.... K-- ,..a Y,.*~"... a. n +.:.:f-.. ~`~af ~et<. a..-'°S ,sew, tnhn - L-. ti, ~ < =:r., sf. r~ . r , 1, caGxPw .ro .Cir r,,, rr~:*~ ~0 4.. L ...-""~--~,c E .y" ~ r . ~ .,r ri-:'t r .,t. „J,``,~3~Jadr, p, m ,ai, ,t: J c r~~+ `"7 rs ~ ,r •~,DallcsUr.1~ t"_.aa~~~sf~arr >tt,," rfr,rr; r~..,, k „v'? 'v ;:a ,ms r'~~` ~nti~ nor i { F .cr: , c~ .r. .gym ~.,Y~ a ~r vet ~~h . $ e,. ,r'`- . ,,4` t~,, ..M w• a r r#~' ssr .a, ' s ~".rrr; to c .r„ .11, ~ ,rj , , . u r .r • , „ a. r»:; r , rr _ d` # ~ ; r. ~ , w.~t~' ~r,~ ~r wr° br CC rT. J... t~, „7, !Q r T, r»'~-r ID, p .',j.,,k:P• s,,. , ~ y.: _ < ,y~,t. t ^'p +Vp r. h{F J. yy w. :+w. 1 .y,L I, irtu > 5 dh '1,.'' ,..4?. f .'f '~'F, '~Y T{. .a: t o r~3`.f _ F _ ~ x v a~ < , t', , ~ ° X'. ff' .,.r~•+~:. `s f ^ t ."`r'~ a.- y`~ Yti d''~' ER ' -u. t r e t: , r 't , ~ ~ Lr t , ~ „ +-~`r ..1~ ;,a.: t : k' w' P:w.~-~. 'ivo .F 'C { . 9` .v , , . .rt ° _ x a?~r ~ x"°- ' ,T- 1rer1 r,.-----;°°"'"~„ 'Pt' v+r1 16 :w~::. ;,I r. m ,r ^ . ~ 'X f'~ ~.,,r fie..^N He« , '...w,.... S1 . ;raL , n, r. . Y° t c"~`',`w, ,n w ' F'' Y 7"' G ~.,a 4 • , t ,r,.k~S... # g a «x„+e.~.~ .M _ "t' < ",:.max, :ir'"" ' , ',a:° z ~~r'?;. . 4 . „r, ~ ~ fir,. ~ w a ~ _ v~ f:lfi,„~ , r~ . i ,f ?'~'.aa~.,. si. r;.~"r . ti .,x,~+'* pS11 n .-E~`' r_ . .+3 .r 'v,, ,i;.;,' r ~ i ~ rt r. rr r ~~Ze a+w~ ~ t x ~ < , 4. r ~ to ~ r. i t , , - t.. t , a , ~ - Lilac (t ;F, r~r ~ ' ~ ~ ~ , 1 + t+ - . ~ _y _ v. _,~.-r vvv 16m,,...F-M-r=te : ~ • :,s "`vr ,rr _ , , , ..n,.: Unl.nown nr 1~o Street ~ ' LS }l g ya='", Cr,< am ?~me „ -r@ - ~ r ~ g } . O y nfllpr,C ~"t'*'..., r ~ ~ ~tsecnr ~ u;;~ ; , H ;.r ~.a 'r ' ~ d . r j ri _ A. Rr1} .i ~ k of . „y;. fl $ j~ w- ~ a KEY 2007Accideuts - Streets ^~`+,'~~xc~,~~.3 .,,'`'','~`,,9fi~~a,d',~5~°~a„'~':`"s~'o-,^3+~',„~`„~' "e#~'~a 3^t7~f€~"y a k ~ e,~ ~ jai r'`"x' Q D 1 ~~~~~~,„t~,~~x 3~„ . ~ z a Q Citti Boundary SHAKOPEE ° 5.7 B-10 co~,~n~ti~rPxmEstlvicel~7 C0.04509 0.18 ~ . . Miles WSB ~ Asso- Infrastructure ¦ Engineering ¦ Planning ¦ Construction 701 Xenia Avenue South Suite 300 Minneapolis, MN 55416 Tel: 763 541-4800 Fax: 763 541-1700 February 26, 2008 Mr. Bruce Loney, PE Public Works Director/City Engineer City of Shakopee 400 Gorman Street Shakopee, MN 55379 Re: Extension Agreement for Professional Services Estimate of Cost to Provide Engineering Services Eagle Creek Boulevard (Old CSAH 16) -CSAH 83 to CSAH 17 Corridor Study City of Shakopee, MN Dear Mr. Loney: According to our Agreement for Professional Services"within the City of Shakopee and Section I-C-2 (Major Projects), this extension agreement is written to provide you with an estimate of cost for engineering services for the above-referenced project. We are proposing to complete the work as detailed on attached Exhibit A -Scope of Services. The attached work plan describes the approach and tasks proposed to be completed by WSB. It should be noted that the work plan includes preparing a corridor study including preliminary engineering. This cost assumes no design survey work or Feasibility Report will be required. It is further understood that the City of Shakopee will provide any traffic counts required for the study. We are proposing to complete this work as described in the scope of work on a cost- reimbursable basis in accordance with our current fee schedule. Payment of services for the proposal is estimated at $7,000. It is proposed that all work under this contract would be considered complete after the acceptance of the report by City Council. We are available to begin work as soon as authorized by the City, and we anticipate completion of the project according to the following schedule, assuming that we receive the notice to proceed on February 19, 2008. We would propose to complete the project according to a tentative schedule noted as follows: Approval of extension agreement (Council Workshop) March 11, 2008 Commence work March 12, 2008 Traffic Counting (by City) Week of March 17, 2008 Traffic Analysis /Preliminary Design ................................................March 12 to April 11, 2008 Draft Report to Staff April 18, 2008 C:IDocuments and Seatngslb[oneylLocol SeMngslTemparorylntemetFileslOLK]081021108-b1 (2).doc Mr. Bruce Loney, PE Shakopee, MN February 26, 2008 Page 2 Meeting with City Staff Week of Apri121, 2008 Final Report to City Council .......................................................................................May 6, 2008 The City of Shakopee agrees to reimburse WSB & Associates for these services in accordance with Section IV of the Agreement for Professional Services. If this agreement meets with your approval, please sign below and return one copy to our office. Sincerely, WSB & Associates. Inc. Charles T. Rickart, PE, PTOE City Administrator Principal /Project Manager cc: Donald W. Sterna, WSB & Associates, Inc. City Clerk Mayor Date C: iDocuments and Set6ngslb(oneylLocal SettingslTemporary Internet F'lesIOLK/081021208-b1 (2J.doc Exhibit A Eagle Creek Boulevard Corridor Study CSAH 83 to CSAH 17 City of Shakopee, MN WORK PLAN Task 1-Project Management This task includes planning and coordination of all work tasks, establishment and monitoring of budgets and correspondence with the City of Shakopee on a periodic basis. The project manager will provide technical direction on all aspects of the project, review all work products, and prepare monthly progress reports as needed. The project manager will serve in a primary role for many of the preliminary design and analysis tasks. Task 2 -Data Collection (by City) Available data will be collected from the City of Shakopee, Scott County, Mn/DOT, and adjacent developers, as necessary, to prepare a corridor study. It is assumed that the City of Shakopee will provide all traffic counts for the corridor including AM and PM peak-hour turning movement counts at the following intersections: 1. CSAH 83 2. Holiday Gas Station entrance 3. Tyrone Drive 4. Vierling Drive 5. Alyshebia Road 6. Sarazin Street 7. CSAH 17 (Marshall Road) It is also assumed the City of Shakopee will provide directional, daily traffic counts at three locations through the corridor: 1. CSAH 83 to Vierling Drive 2. Vierling Drive to Sarazin Street 3. Sarazin Street to CSAH 17 (Marshall Road) In addition to the traffic count information, the City will provide WSB the latest crash data for the corridor. Task 3 -Traffic Projections Traffic projections will be prepared for the corridor based on existing traffic counts in the corridor, the 2006 draft Shakopee Transportation Plan Projections, and the anticipated land use in the corridor based on the draft 2008 comprehensive plan. These projections will be made for 2030 conditions in the corridor including daily traffic and peak turning movements at selected intersections. Exhibit A and B Page 1 of 3 Task 4 -Traffic Analysis Based on the existing conditions and the projected traffic volumes for the corridor, a traffic analysis will be completed for the corridor. The traffic analysis will include determining the transportation needs in the corridor now and in the future. Two specific analyses will be conducted as part of this task. A. Vierling Drive Intersection Traffic Control -The Vierling Drive intersection will be evaluated to determine the appropriate traffic control. This will include looking at a potential roundabout at this location as well as traffic signalization, all-way, and two-way stop sign control. B. Eagle Creek Boulevard Roadway Cross Section/Access Plan -Based on the existing and projected traffic volumes in the corridor, a typical roadway section will be determined and a recommendation will be made to the number of lanes required in the corridor. This will include evaluation of both three-lane and four-lane sections. Atypical section and concept layout will be developed as part of this task. It is assumed the City will provide the base mapping for the layout is developed with this task. In addition, this task will include review of the current access locations in the corridor and evaluating the need for restricting, eliminating, or adding access. Task 5 -Agency Coordination It is assumed that one (1) meeting will be held with City staff to review the corridor analysis. In addition, it is assumed that attendance at one City Council meeting will be required. Task 6 -Report Preparation A draft and fmal report will be prepared for review and approval. The draft report will be completed and submitted to City staff for review. Following receipt of comments from City staff, the fmal report will be prepared and presented to the City of Shakopee Council for review and approval. Exhibit A and B Page 2 of 3 Exhibit B Eagle Creek Boulevard Corridor Study CSAH 83 to CSAH 17 City of Shakopee, MN ESTIMATED COST Based on the scope of work outlined in Exhibit A, the following cost per task is anticipated: Task 1-Project Management $250 Task 2 -Data Collection (By City) Task 3 -Traffic Projections $750 Task 4 -Traffic Analysis A. CSAH 83 Southwest Quadrant, Site Access ..................................................................$0 B. Vierling Drive Traffic Control $2,500 C. Eagle Creek Boulevard Roadway Section/Access Location $2,000 Task 5 -Agency Coordination $750 Task 6 -Report Preparation $750 Total Project Cost - $7,000 Exhibit A and B Page 3 of 3 ~ ~ ~ ~ ~ ; ~ ~ ~ r^ ~z„a ~ s ~ ;~w - x a . .m.a..... . r, F - _ _ ~ ~ . ,a ,axes i, ~ uµ} r - ry.. .;,a,~ ~ ~ ~~,'t'~i~~xt44~~iif,~i~jil~lil~+`=~ < ~ ~ ~ t ~ ~ ~ _„o. _ 4- t i I<TN Statute 169.14 ~`"~w`~"~ Speed laws are created for the protection of The commissioner of transportation sets regulatory speed the public and the curbing of um•easonable limits on state and local roads based on a thorough j ~ behavior. To effectively enforce a law, the engineering and traffic investigation. public must believe that the law is reasonable. Minnesota's speed regulations are based on the These factors are considered: same Basic Speed Law that is used in a1150 states: I`TO ~ road type and condition person shall drive a vehicle on a highway at a speed greater ~ location and p than is reasonable and prudent under the conditions". type of access oints intersections, enhances, etc.) Statutory limits are based on the concept that uniform ~ sufficient length of roadway (1/4 mile mutimum) categories of highways can operate safely at certain preset ~ existing traffic control devices (signs, signals, etc.) maximum speeds under ideal conditions. Whether the speed ~ crash history limit is osted or un osted, drivers are re uired to reduce ~ traffic volume P P 4 speed below these values for poor weather conditions, curves ~ sight distances (curve, hill, etc.) or hills and potential hazards such as pedestrians. Drivers ~ test drive results must also reduce speed when approaching or passing ~ speed study emergency vehicles with emergency lights flashing. The most important part of the traffic investigation is the These are the most common statutory speeds: speed study. When choosing a speed, drivers take many ~ ] 0 mph in alleys roadway environment factors into consideration. Therefore, the s eed that the ma•ori of eo le consider rodent is an ~ 30 mph on streets in urban disn•icts p ~ ~ p p p ~ 70 mph on rural interstate highways important value. Data is collected by performing radar ~ 65 mph on urban interstate highways checks at selected locations on the roadway under ideal ~ 65 mph on expressways driving conditions. Ateclmical analysis is done on the results ~ 55 mph on other roads to determine the 85th percentile. This is the value indicating ~ the speed at which most (85 /o) drivers are traveling under. Ex erience has shown that a osted s ed li tit r t - Whenever these statutory speed limits are not the correct p p pe n nea lux value for a specific highway, the commissioner of value is the maximum safe and reasonable speed. Studies transportation authorizes the posting of other regulatory have shown that traveling much faster or slower than this i speed limits. value can increase your chance of being in a crash. I Engineering judgement is an important tool. The traffic I11t@CSt2f2S are high design multi-lane divided highways investigator must use knowledge of nationally accepted that have controlled access interchanges such as cloverleafs principles Combined With experience to assign the Safe speed. or diamond shaped interchanges. Through traffic on the interstate never has to stop or yield. Examples: 1-94 orI-35 ~,titsr~j o°~ August 002 ® EXpC2SSW8~lS are multi-lane divided highways but they Minnesota Department of Transportation have entries and intersections, sometimes controlled by ~ Office of Traffic Engineering & ® traffic signals. Some interchanges may exist but they are ~ Intelligent Transportation Systems ttOttherule. Examples: Highway l(1 orHigTnvay52 `~'cp~aP~~' vt-wtiv.dot. state.nut.us/trafficeng -ink /vtiirx_.,,,-~ i e i i ~ I REGULATORY SPEED LIIVIIT SIGN Will lowering the speed limit reduce speeds? NO. Studies show that there is Little change in the speed pattern SPEED This black and white sign shows the maximum speed after the posting of a speed lieut. The driver is much more LIMIT that a motorist may travel under ideal conditions. It influenced by the roadway conditions. 50 can be a statutory value or else it must be authorized by the commissioner of transportation. Will lowering the speed limit reduce crash frequency? NO. Although lowering the speed limit is often seen as a ADVISORY SPEED SIGN cure-all in preventing crashes, this is not the case. Crashes are most often the result of driver inattention and driver error. This black and yellow speed sign is used to advise However, if a posted speed limit is unrealistically low, it creates a motorists of a comfortable speed to navigate certain greater speed variance (i.e. some drivers follow the speed Bruit situations. It is used with a warning sign. For while most drive the reasonable speed). This speed variance can I instance, when traveling on a winding road, the curve contribute to crashes. ~ ~ warring sib r would be used with an advisory speed MrH sign. This sign may be posted by the local road Why do we even have speed limits? authority on local roads. A uniform speed of vehicles in a traffic flow results in the safest operation. The posted speed limits can keep the traffic SPEED LI111ITS IN SCHOOL ZONES flowing smoothly provided the majority of drivers fmd the speed limits reasonable. To best do this, the limits must be consistent tiu-oughout the state. The speed limits also give the i scxoo~ Local authorities may establish school speed limits on motorist an idea of a reasonable speed to drive in an unfamiliar local streets, within a school zone, upon the basis of location. The speed limits are used by police officials to SPEED an engineering and traffic investigation as prescribed identify excessive speeds and curb unreasonable behavior. i LIMIT by the commissioner of n•ansportation. This 20 regulatory speed limit is in effect whenever children are present, such as before and after school or during ~ ~ ~ ~ ~ recess. The school plate is black and yellow and the other signs are black and white. Optional flourescent If you believe that there is a safety concern or an inappropriate yellow green may be used for the school plate. speed limit posted, the person to contact depends on the type of road. SPEED LII!'LITS IN WORK ZONES ~ TRUNK HIGHWAYS i ~ Advisory speed limits are used to identify safe speeds For regulatory and advisory speed limits on the trunk highway for specific conditions within a work zone. These system, you may contact the district traffic engineer at your black and orange signs are always used with warning Mrr/DOT district office. 3 5 sighs. The local road authority can post these plates in work zones on local roads. The trunk highway system includes: MPH Work zone speed limits are short term regulatory r Interstate Highways, speed limits that are established for worker safety due ~ U.S. Highways and Fires ? Minnesota State Highways ooue~e to traffic in adjacent lanes. These speed limits range SPEED from 20 mph to 40 mph on two lane-two way roads LOCAL STREETSAND HIGHWAYS LIMIT and up to 55 mph on divided highways. They can be For these roadways, you may contact your Local road authority posted by the local road authority in active work zones coun cit or townshi For adviso seed limits: The 40 on local roads. The FINES DOUBLE plate is black ~ Ty' y' p)• ry p local road authority can determine these advisory speeds and and orange and the speed limit sign is black and white. post the plates without authorization from the commissioner of transportation. For regulatory speed limits: The Local road Temporary speed limits in construction zones are authority can pass a resolution requesting an investigation by ~ SPEED sometimes needed for long term construction projects Mn%DOT. Based upon the results, MrvDOT may then uM~r or detour routes. These regulatory black and white authorize the local road authority to post new speed limits. 5U signs are used when a reduced speed is needed for ••I driver safety. Valid 24 hours a day, 7 days a week, The phone numbers to call for state or local assistance can be these must be authorized by the commissioner of found in the phone book under government listings. If you are transportation for any roadway. unable to find the proper phone number, you may call the Mn/DOT Information Center at the following numbers: See the website: www.dotstate.mn.us/speed 1-800-657-3774 Greater Minnesota or for more information on "Work Zone Speed Guidelines" 651-296-3000 Twin Cities Metro Area J DOUBLE FINES will be imposed for violating any regulatory speed limits in work zones or ~ in school zones. Fines are also double for failing to reduce speed when passing by a stopped ~ ~ emergency vehicle with its lights flashing. ~ When an EMERGENCY VEHICLE is approaching you, move to the closest shoulder without crossing the path of the approaching emergency vehicle. You may proceed when the emergency vehicle passes you. If you are approaching a stopped emergency vehicle with its lights flashing, immediately reduce speed and, if it's safe to do so, move over in your lane away from the stopped emergency vehicle. Drivers should actually change lanes if there are two or more lanes hr the same direction and there are no vehicles in their path. I ~T z w MINK x ~iNN~SpTq R AuAN~~ utatosa PA~~Ftc ~A~u~DA4 ffi ~ SPEED ~ SPEED Tn ; ~ ~`{`~..,,1"'} ~ 444...---+++~~~x~ a LIMIT L~MI~T ~Q (~"~(~~,.Q,SI.~-' ~~j'(~ 4TN A4E ~O ~ 5 89 ~C'"}~V~' t....s','"' ~('`~Lk i~~ 14_lli~,~"y"' 4TH AVENUE ~ ~US~A~ N OPD , 4 t 3Rd I~~--.1 ~('1~'"~~ t..-'~ Vr"~ i N ~ CR17T0 CR B3 ~ ~ UNtDN PACIFIC R±~ J V ~ } ~ l.--i -ry 4 o T~AOTNY m i t.--,-i ? G MAN ~ ° ~ ~ ~NPQN AACtF1C.~+A y{~''{~~ 4~-~'~~~~ C~ C~~ ~ ALY~IEBA ~ ~ {,O S AD P~ N F ~ -.^'k ~ ~ SHAKIX'EE A~ U Z 4 SLIMIT ~ N ~ ~ ~ EERY 30 1I VALLEY PARK DRIVE ~ ~ a u°i `e ~ ° ~ ° ~i a d C__~_~ 10?H AVE ~ A 11THAVETOCR101 15 ~ 1DTH A ~ x ~ ~ ~ I 1 a 12TH AVENUE sPEED r a CR83TOVALLEYPARKDR LIMIT a 7 ~ 91i1i A D S C 30 w BT 12TH A4E ~ p AUSTIN ST n ~ ° ~ MENKE LAR TSPUR ~ CT d B k Chi m ~ ~ N N p~~R Ci ~ G4Elh. pp ~ ~ ~ lU~ ~ ' ~ 8\~~~ ~ T C OAgRrA ~ ~ ~ r ~ ~ ~ aR ~ gR~APPLE14gQD ~„J~' i~ 4i ~ a a o ~ WA PARKVIEW FlRESiDE ~ P F SAGE ~ < WAtl7lFOftp j~ ~ n ~ Ga SPEED VIERLING DRNE ,~/+AN~~, cr R CI ro Q ~ LIMI CRI7TOEAGLECREEKBLVD DEAN / °sl P ~ UN ER ~-.NDJ A~1 RNE ~ ~ I.1 ~ 1'' p A~~° $3 A ~ APP DS~3M LN 16~ ~ ~ EJ ~~M 2 ~ I ~sF FAST ? POTfOK PRW A4E• o a T7TH AVE £ £A F DEAN LAKE n = fa DEANS LAKE N 3~ LSDa ~ ~o ~®NOT ~ AVE dA~ z A wAY K@~ z ~ N AVE ~ ~ ~ o R~ EA~BAULT 1 AVE ~ YMA ~ ~ a I--__1 y ~ NEf~ W GT C7 MONTEg70 ~ m 17TH AV£ £ ~~~L ~ ~-B<dSSBlI r A ON AVE ~T W ~ ~ 7 a SQtA ~ z 4 ~ v: ~ rc RD C Fft CIS G w B o CT o SPEED KOEPPER AVENUE GT a F ~ LCIMIT VIERLING DR TO SOUTNCITYLIMITS C S N AVE ~ ~ p ~ USEA ~ 50 `,~jk,\1 _ia it ~ ~ ? °z a ~A1RA WAY HAWrHOR ~ MODE125 A ~R5 ~ ~ a ¢ a aP~ a CT p ~ HILL44g00 N V N NOS tIF'LAA'AN U ~ PA ~ ~ < giES °T PRdPOSED SPEED LIMIT STUDIES a SON ~ d g D A ~ ~2 ~ ~ m CIR LN o ~ ~ ELM PL 92BTH S7~~ W ~ ~ ~ C7 oc~i ~y r(J}AC~KrSO~N}ry t ~ ~ G~ ~ p ~ ROADWAY TO BE STUDIED } 1 V iF1Y SLi1C DR rn d~ 4 C IAC~ ~ ~ ~7 2 0 ~ 3 ~ LYR aR D aR c~ rA ~ ~ cr ~ o ASARUM cr o 0 0 ~ ~ u~TD CURRENT POSTED SPEED LIMIT d DANITA 9 NA SC 50 1aoTH sT w 78 78 0 w 22ND AVE VALLEY NEW RD z Za 3 ISE AVE ABBEY PT o LOUISVILLE q Q ~ 3 yM~c{t ° S:>i. >.`€~"?1'„. a' y,r.. ~a ~~fi~ ~pq i iA~t i~a~ ~ . ( y ~t .,._ra.,., s ,:r~ ~ ~k.~~,",. t.... + =~r~ A' ~ v 't~ i~". ,.fit ~ t~ i .~r,~ ~ S w +,~+'*Y 2 t"kt' 4 7 ~x '6:. ~ K~ ~R 1C $ ~ ~ .t . 1` ,m 'F 3 ,"'e t`' ` ' }aqy S q ~ 1 ~ e ~ ~~Y f ^ t~ .,fY : " ~ ~ ,y . w.. ~ ,t t ` ~ t r!~ F; w "4 _ r~ ~ r ~'x . ~ r ~ r r t ~ z . amz ° a ~1~i S~:' & `i , . ~ ~ . ' .,w t ,J' F • r t -x. " rcp~ ~i ~ xis, v," .4 i x ..r ~ " ~ a; may, 7 •m ~T .~A, a A~F^' 1 aAnN .?4`a.^ , .~ik~tw a, _ xay,. a~.yt i'''~.',.. r„i ~ , t .9`i ~a°-•,, y 1 n; #r `'C. ~ " , ,r ~ u'./ x H i t ~ t N # i e b~~ t' { ~ ~ ~ t x~~~~ ' i tkFF..t tt S e $ ~ t # ~ a t " ~ e" ~ t' ~ ~ N W A Pe t- ~ ~ p . ~ ,.~%'~9't*~~'~'~ .z ~~"'+ti;. mss; ~ . J ~'AF r w,~„~ ~ ~ _ ~ a" ~ b , ~ ~ yf ~Ir~~~°y . !Y~ e ~ ~ .,St ~ r _ v 5 , ~t ~7 W + ' at 7° E _ a` ~ E k' ~ " , w w . , .ems kid, r`.'~"~' ;~','-,?k 5"ik`w. r"3'!~""'~~.::. n~:x*`z,~". ti`: ~ - r ~4 :xr`~, t• g>~t~~i` t, Z e ' ~ E~, Imo, `II R" ~ ^e 6 _ ,~+n ~ ~f •Y i~ t~ ry .l I•~ ~ ~ { ~ > ~ ~ Q ~ N v, r ~ ~ t ~ . a r : . - 9 , Garden Lane Parkin ~ ~ ' ~ Horizon Drive (11lilhisperingoaks) g ~ ~ ~ , ~ '~~{.a ~ . T r , ..ter 'c y~~ .t'" ' ,a'^ ' ~TTIf - 'f? C% ~ 1` '~4' ~~f i y A ~t~4 T~ 9 '.fa~ ~ ~T S ,i ~ t- 5~ ~k 3~ ~I..: c.,. i• a~'~b~" ~ ~ 1, 6"~ r, f: ~ ' ° s ~ ~ ~ ~ f,~ ~I " , ' ~ _ . ~ P. 4" , fi a y r Cn~ ~ t' i., i a y ,$.~%3s~ ~ ~ ~ ~ ~ ~ ~ ~~~-Fr' £~~~'~C. ~i~~~C.. ,,.p,.~ ~z~.'ya."n^.: ~a;~,~af. ~C",°.w'~~rt 3 ~ ~ ~ ~ ~ y cr, ~ ka°'e` r ~v^.a t; -a~~` ~ ~`~.k"~ar` ~ "~,ni~ r~~r r.~ E_ w~s.> - , "y, ~ ~ rte, r` ~r yr ~ sT {F;~ y~ ' x~ E r .r,. ,4 A. p " L `F.:s.. ~ 'ny~'~ Fj'.gY 'SayY"Y N°~`~. R' ~ k~.i l ~ 4~ ~ bt*, ~"~ki'"• ~ rk ~'w ~~t :*i~= b a 7"4c ~ 1"~a "i q~~ .i. ,1. .1 4.,4 4. /7. ~+5,`.^°" ,~~rx ~r "R 0,~"~C.~'A~ ~"9 ~~~.vt~.w., t , r. a, a e + , FFF ~~.t+ 9'" ~ ~ =e ~ } _ 1'CP°',.DS~R RR °e ~'i... ~'Kt' A"'r, §n*, 5~:~ prt;~.. s,= ~.s;; ; ,z sr ~ x~3 ~ a d°- 't~• r ~ rR~ i~ s~~.'~: ~ ~ p ~.;i„jJ- b> _ ~i, .y. . , `f ~"Q. ~ Cr f?" `'.~a,. - -.t C'- t'.Cc G' `C~ .,~ti E1 ~ s`° f- 'rrt w. . w ~ ~ : fi , ~ a s. • ~ 2 3,, ir~» ~ a, , z~;. G, . `~G 4r.4~e ' a`~~°:'; ~ r- a lei ~ , ~ Ctiti Y E:' ~ ,q9.5 r< ° crf rr~ . ~ w'~a ~r~ ,`1~frr,,;~~r~ .r~., ',4 a r.' w"- h. i~.,, ,i"' . ~ '~"r!%~'` ,r~" ty~x ,r ~Y» $$"a~ j : r " r< c.~•',; - q - "~r'' . P` ti~° , ~ ~ M ~ Via'- ;~.p ;r Ir t T r~ .r, , .e, 1 ~,t t~ ~ :+1`~ • 7` fi ~ , -f, i ''fir, ~t~-, ~~a s ~i~r,.. @ ata~'-" c'..' . ."r,„ `a~' aah, 3. ~a ~t'•' aa, E7 ~ s~t~ ~~1 ~r f' ~~~~€~~v p r 1 ,~~~t~~~ ~~a ~ a 9 w fii £ v?)~ s y. ,^.r p., i F ~ ~ ~ i ~'~i ;;'f .+~Z~~ . "~r'~ y«-r x^'(:~ ,p~^~~(~ ~~e ~ r 1 C #,d: ~ ~ "^tMm y., ~ ~ ~ ~I. ypk' uR .fit p ~a.~~'s.~~ g~z~ z~. `5e" '{5'Qf ~ ~ x ,,5 1, ry i?`" ~ r° t'~ " ~ X `l`il y t ~ , y T..~ y-t`~.~1"j. 'E~h~' ~r'Y~. 1 i r k v ~.Jlf:.:a~a _M•.~ a }`f _ .v , , x ~k . d ~ ),~7~ TIl. r..~_ fi. E`"e i. 1YW3 ,Jek ~ _ ~ tA. ~ ~ .1~, Mi d4 ~ ~ ~~A.~^~P ~ 4 STe 44 . ~~~~~`~'r ~~~~~.~'~tW4~~tt kT~*t re~~~"~~f~k.t~r gt any ~,"~~~T ii Evergreen Lane ~ Patterson Drwe Cardinal Drive Thrush Street ~ ~ ~ ~r ~ ~ .F~. a Luis Street rth ~ve~~ue ~ 3 ~ City of Shakopee Infrastructure Asset 154 total miles of City owned Streets $125,000,000 Total Asset How do we manage our Investment? SHAKOPEE Pavement Preservation! r~ SHAKOPEE What is Pavement Preservation? Pavement Preservation is a strategically planned, engineering-based program of treating pavements to maximize their useful life. Pavement Preservation takes the maintenance process one step further by carefully choosing and timing pavement maintenance applicationsto extend the life of the pavement. SHAKOPEE 1 Practical Definition of Pavement Preservation? The right treatment At the right time On the right roadway Done Right! SHAKOPEE Typical life of a road DO NOTHING VS PAVEMENT MANAGEMENT STRATEGY _u _ 1 ~ _ 4_\_ _ i- ~~~re ° ~-.~1~ ' SHAKOI'EE What are the Benefits of Pavement Preservation? Preserving initial investment ~ Extended roadway life of serviceability ~ Lower life-cycle cost ~ More predictable costs/budgeting Fewer premature pavement failures Reduced user delays and user cost Reduce assessments e Better condition pavements e~ A happier driving public -tax payers SHAKO}'EE L How do we develop a Pavement Preservation Program? Inventory our-roadway system Field research to determine the pavement condition ~ Analyze research to determine strategy . Plan a strategy from analysis Implementation of a system as a tool SxnxorEE Inventory ~ Total miles of roadway Age of roadway ~ Year constructed Classification of roadway Previous treatments ~ Width of road SHAKOPEE Field Research _~g~_ ~ Rating of roadway (PCp Age of roadway . ,.y___...___ Previous treatment ~ Year constructed - Classification of roadway ~ ,....z... , _ . _ nom..r nova ur. o wnno~,e ro~oia,oooo . ~ ) .d ~ ~ ,a .v o 0 3 .Field Research Photos taken Anri12oo7 T ~ a ~y` ~ ~ _ a r ~ C2 4 YYJl y= f: ~ 'I~r h t 1 i' _ 1 ~ z r >p' Y ~ ~'i ~ _r t S i ~ ~ .Y Nay[ it ~ ~ - ~ - J s.~: ~ _ y i - ~ ~N';,ri ~ .ti a St~corcc ~ year oltl pavement surtace M... Field Research - ' ~ ' . _ .~~a7 L.. - ~i 3 year old pavement surtace Field Research ~ z ~ _ r ~ ~ ~ _ t ~ ~ - i 4 year old - o year old - - Sg ~pavementsurface~pavement surface - 4 Field Research ~ ~ ~y . - ~ SHAKOPEE 5 year old pavement surfaces Field Research t= t_` ~ g ~F i ~ { ~ ~ - - ~x; t 7 year old } ~ - 6 year oltl ~ ~ ~ c ` y'F.r<1ICOPEE pavement surface pavement surface Field Research r ~~~~vo , ~s~ s ~ - % y -t ~ ,t`.~ F~~. ~`r ~ ~ sue- ~ ~ Y y 4 y~,`~~ fir{',y~ J M } ~ 3- J 5-~~ ~ ~ ~ - v `iii! "rte-'y 7 year old pavement surface 5 Analyze/Plan SF:AC'Si? r.>v..meM 4:xragnm<r:t Straa:yy to LcwE 5°.m.^!s {E}ev2b!:cr?ays for Ssf ^x:al *.'.oat~ ~ -P _ ~ SHAICOFEE PMP Mapping with GIS SFLIKOPMEE Seal Coat Map .r 1 _ ~ [ City of Shakopee ~y S ~E- Seal Coat Map 6 r~ sr=~~~ Street Improvement Project Map a _ - Cost Analysis Overlay/Recen 5year projection Veal ReROrf Plznnotl Differen 2007 51 t3-l~ (w ~ ~1,%4f ;+ctual) 1 lUin7 51 Y ~ 51,;x_ ~(i1 11 (iii) [01 £~,f ~xJ 51 Nil ~ $-3 lK%~ ~i111 Jt,r~1~.i.G-0 £2,3I,1_i.Fl $3~~5,(Y7! '2Uh2 52101,oirJ $~1ryy,~0 £00.1 TOtal $11.FS1o .1(•J 811130,600 ~~l(a~ Nu[included Ih 03.ninent icnL rep Ap0lied n ~'+Iion f-a;tur. Projected Funding needed for the Sealcoaf Program Yodr Needed Bu Geted County Bulltl ing Fund Stata Aid ~~%)7 ~~1 ~:~N1 51~t f $ ),~:~~!G <30 6~1 5`ti,!:+KI 1JQ 51 ~ 2010 52 ; l.) 101i $232,060 5'y,,~~~6 , Implementation Construction fechniques used in Shakopee Pothole patching Crack Sealing Chip Seal/Seal Coating Overlay Mill & overlay FDR (Full Depth Reclamation) Reconstruction SH.AKOPEE Construction techniques used around Minnesota ~ Pothole patching Crack Sealing ~ Chip SeaUSeal Coating e Fog seal ri Micro-surfacing Macro-surfacing Slurry seal Ultra thin bonded wearing course Thin overlay Mill 8 overlay t FDR • W ith Asphalt Emulsion K Reconstruction $I-If+TCOFEG Resources _ r i _ _ i •,61,. ~,.I _ ._TT~ .r= car-a-~-,u~=s. ~ _ _ ~ 5 ~ .A ti~'.~S' x _ SCifixor~ 8 _ _ _ _ _ CHANHASSEN ~ ~ ~ OO~~TI' / CARVER COUNTY a X _ ~ I w SCOTT COUNTY 12 x m MINNESOTA _ ~ Mr 1j'Ia RNER ~ ~ - ~r_= / ~B/U~j //j ~ z NN OA i'~O ~-~~A'' iC -:r w ~csz~~~~ \~~^i\ 9 /~~jj5 /E/,/ \ z T r I~ SHAKOPEF ~ ~ ~ ' ~ ~ MINNESOrn ~ d~ ' ~ a ~ ~ ~ i i / ~rr,o ~ ~ s ~ ~ I _ ~ _ i n~ w Q~~ -~~,a ~ ~ II ~I~~ ? IN G\~ J ~ ~_1 JI I',,, ~~nx- &w \ J / / / ~ y _ I - ~ ~ _ M~ . ~ ~ - 6 / p~ ~tii i..m i~ iTM ~ w~l 1 A~.I~r ~,~~pm " N i~~ f 1W ~ so ~ ~ I ~ ~ / : 0 i ~ ~ /-e 1~ ~~h~:. ~ ~ p ~ ~ it 3 ~ ~ ~ r'F~W ~inni l~ ~ ~ ~ ~ M ~ ~ I es _ I,'i Q ~ ~ n iom n - 4 Can ~ j ~ ~ ua_.,a~c ~ ~ % ~,II ~~nxe ~i~/~~ ' i~ ~ y r ~ ~ _ ~ p© C I 'T w ~ I n & S ~ E a ~~aC E ~al~ y) a~`Y ~d nx~e r art a`~~,~ re o ~>x s~ i ~ ~rc { UrV.A~t. ,.'G i 9 w .t o .p~ S IN a l '~bN®IY .?s ~ ~vgy ~Rtis~'"n ..~~wara n 4~,.. gin AVi. _ or' i ewl~ o r 8~ im ~ j r ~ arr ~+cwcm lA/~ aeits' i ~~~~/a_~ 3i h ~...~z~ ~~~s i3°Gi'~~ p.. -.,s bt~`;.~ ~ `C i I,,._J aJ_ 3 I.C Pw+ .`..L`_`L~ _;ij i \ ~ r~~q /3:%uc:` ~ NERLx oa ~=_"'uww>E` ~ cd~F v~.~ ~ / - 4 ` $ ik y~ I g', f .i G~ I„i~, i -sm e- ~,~~vs oa 5 om~ uuc ~ i _ i r " ::xl: I Gt ~i"~~~~' a' K nG, . ~c 6~ q t~ ~ I y~ ~~~'w ~uua , ~ `mP&~ ~ ~ ~ ~cW7 i ~A, ~ a ~ c ~~f~~,, ~ X13 Y ~ ~a, e S, ~ ~ ~ ,e~" ;T ~ is m w,~ Q 3 i uui : / .,ffi a xµ~u ssr J ~ n i ,u r1 €a / ~ ii ~ i ~ ~ { a.e~ w~ 'a`~ k ~ ~y nu dC _ bra.. ~o wpm r- z nw nJ~-[ ~ ~ / ~ ywm ~ p ~ / kS0 TOWNSHIP sm"^. ~ a E € d C,~rS~ ~ ~1L7 % ~.x~n~ .~€cr e. mr'ri' wwa ~,°a 4~'~ tl ' Fr Gf 3 w ~ r b ~ ~ uoaee 4 t _ tam ~nr~~~ ~ nm arc. c hl x ~ ~ j'Y ~ p.:~ LANE , ~ i 'b~~ ~ ~s e wo a ~ esaw,w° ~ ~ ~ usr'h a zE ~ ttc~ ~'rtwwr~ Whoa ~ ~ ~ rte... d W ~ R wE ~ ~ ~ annsar_s€ ~ ~ ~rx A w~ d , mavi ~ ~ r ~ e ~ s ff ~ ~ ~111d ~ E { a ~ E ~ i ~ ? ~ / ao - ~ gk~ ~B E 3 ~ ~ ~ 4 Y ~ uros m S W p aL- n ~ ~ V ~ ~ ~ ~ ~ ~~K "-s~'o ~ w eNb was J~~ g ~ 4~m~' & ay,,i ~ wawa n ~ ~ Y i- urt. wev n.~,~x 'rma `c vs a n ~ n h 1 4a w o'', f~ sou E ~I ~1a'G'' Russ na~.r 1~ ~ ~ °!"am~ _ ~~~~4`~P&~ ~`ryi ~f _ _ 4 I~ ~ ~ _ - qW F C ~ JACKSON ~ ~ d'~d ~~~~I esli 1, ci._ x ~ ~ ~ auri " ' N fir-j ~ !III' a iii enTMAx 9~B_ ~ ~2aws J sn a fw I ga ~ TOWNSHIP 9~ ~ .;a f Air ~ Pm_, g~sr ~ S$ 9°GocE 8; e e s ~ 4 ~ ~ E _ ~ w: ~ ~ ~ ~ ~ ff ; As~~wc. tia ~ G ~ i a~ w - ~ ~a uon+ sr -icons sr wti" - ~a ~r a~ g ~ s,- ~ I mN~ it ~ -asxo me w ~ i _ - W VAllEY NEW RO I : PI 1 ~ LOUISVIIJ.E ! 3 j k ?ri - TOWNSHIP ~ ~ w ~,a e.~ ~~~a! 3 i _Q M€ . w.wwaa I I~ Sara LL W P~ I~ ~ , m a:a n' ~ ~ ~ s PRIDR LAIC PRIOR L4EE II, of / / MW a t4P,pY~' u / 3royeec,&1. du k j~' A a ~ ~I< u r/! ~ _ ~ s~ I ii Y ~nEe ~ n,~ ~ ~ I' SEAL COAT PROJECT FOR 2008 i= / ` ~ r~ ~ la ii 1 o ' ~ i~ la w~°~ I~ ~ City of Shakopee / ' I' I TH~L~EE ; ; 1= n~r~ Seal Coat Man ~ ~ - = as SEAL COAT PROJF.;CT FOR 2011 ss.. p ~ s 2000'20 12 SEAL COAT PROJECT FOR 2012 I ~ G i Shodmt Co 2008 Flve Year Plan for C2ck Seal M6p.dwg.l k CHANHASSEN ~ ~Y~f'lm ~ ~ ~ it C~Uiy ~ z - ~ CARVER COUNTY o. ~r ~ X ~ ~ ~ i ~ SCOTT COUNTY Z - ~ ~ R / - z - ~~i ~ ~ a, ~ ~ ~ ~ MINNESOTA / / i / ~ ' ~m U - c KE ~ ~ BLU LA - NF.R _ / / / ~ / MANN SO ~ ~ ~ ~ ~ ~ ~ / ~ / ~ ~ ~ ~ H gaff ~ ~ SHAKOPEE ~ ~Ey ~ ~ F h(IN.N6SOTil gsoaub:.. ~ ~ Cj ; ~ ~ w~., ~ I e 1 ~ a \ ~ ~ ~ z+ ~ ~ a _ ,TM uv ~ ~ / / n ~ c ~ i - ~ cTM - _ ,~,._aw _ - _ wov ~ / - - ~ s ~ c - ~ r~ _ "~ei / a ~ x 1 i ~ _ ve[wsea wr ~ % t mwEJ ~ I ~ - ~nuon+v I ~ ~ I~ ~ . - 01- 'l1_ ~ ~ i 1 ~ J I ~ a I c ~ ` G6ay GI ?'xrvaee s~.j ~ l ~ - ~r i _ m-n'~ G s, m n m 6 ~ 1 ~ ~ ~ ~ ~~y i. s7 I ~nswn~. .l, ~ i?~sm~ ~ I~ , so s 1~) 9 >..a 5~ ~~,.y io 3V SIF f °I ~ Iomn~ i ~ .~~~mr ( III u.x / / r ~a Tg~~ h~~~~ i L~iamn~ ~°°P~~trs I' e ~ x ~ g p p"~\`` < 6 / I; I~', s i,'~'/'.~/ Ii I ti I~ s/' b ~ . ~J C K~~~. a >H ~ ~ ~ ~ ~ ~ ~ i ~ i ~ cl W6~ ~ st r 4 ~ ~ a>tu 6sn~ a / ~ ~ ~ ~ ~ S` `R iiw nr4 G ~ ~ ~nu~n~s a~ ~ ~ r-._._- _ ~ ~ ~ ~tw.. ~ ~ _ k ~ -.IA~M n`4 n o i ~ 4 cx E ~ - rc ~ i ~ _ `na ~ gar arsP e 4 ~ Jrs u~ v ~4°~~ o / ~ w W tnm r- o 169- - s1 ~ ~`~i fad ~ ~ d A, vr" i e ~ L ~ oa +AU][+ r, pc ~ ~ ~ - r~ _ "I'° ~ sm ,r ~ sNEptJFC oe~ ~ ~t 1 ~ W~c /<~"<" ~ ~e~r~Na~R ~ ~aiauHC ~ . au x °'r° ~ I„1~~ ~ J! a'j, J~ ~ ,~;y 9 i k...,a~i .,ur ~o ~W .w~w n~c~ ?~y,~ '"`~a°~ a~~i~. 4, ~ 9'v d ~r_', 2 ~ r..~- I ~ ~~U wy ~ .n orw ~ x a xO Egq ~i ~.ro~l~~~ ~ ~ j _ h. ~ o axE P I' 1t _ I n~ ~ a, ~ "a„~ _ / I ~ i'_s ~ ~ i~ ,tia 'fie i Jf Ia m ~ILa ~ ^ ~ 4 romw. _ ~ ~cµr ~~xes/~~,wm~~ua r~~ ~ t9~~~mnv~uv~w , / ` °°Wn ~ m ~:Qi L / + g ~~y < ~ Row+wG a~ 7 / ~d ~A~ 30 an ~ v nor ~1 mwc rc i U ~ o NT ~ ,:z.-. ~ U. ,E4cA / 2 < xm x w k N .x ~n tl YN 'u 1 3 17tH AVE E ~ C / / 9 ~ Yn~~ e ~w Ral eaene, ~ raonowcaoa $ rasex ~ ~ un ~ f `~W:,~ " .uE'.,~ grx_.w ~.RCerts r ~iDEAN LAKE/ 1~~ I TOWNSHIP nrsm", ~ nv niu, ~ t tarp ' irni. Y _.t2Ma4EE ~ ~ W .E ,~na ~ti , ~ ~a:.- t~ Duns ~u~ / i~ x ~ a ~ I e w i ~ ~ K. ~~j¢r 3 tan aa, aq nu: r iTM~€ I~jNO aw ~ i s ~ c ~ v L~^ / x wau ~ ~ - _ ~~o ,nx au w. ~ . ~ ~ ~ y~ ~ 6 v Q I ~'cr i8 ~ mo ~ !i% wx8~ra p ~ ~4uE a nm Pr ~ "N ~Q~GavEl nvE c ~a ~ m bm nuE E - ~Tti ~ ~ ''~µa 4~,~~ ~o9am ~rcc ~ ~Rivnm-'~ ~ ~~~or ~rV~ ~ I~ °m cm : wts av ~ ~ ~ , oa ~ g ~ I i C~ ~ i ~S'-_ `Dwuer ~~R ~ ~I xa Ii u< qrg 1 ~ ~ ~ ~ e ca svxys~ s` aus~vE I> o p~: ~Ly-- A~'I.muxmoo~u nr-arev uawA u cporau~m~~~nr IRmvs~si n4.~et~ >Hru s~_~ I.z E's'c J~~ `kc~s~ '~rCU Ufa g~`~ersa, m E I 'i„ o 4 k ~P < c E p rye, Nni w .~_e ~a .;'~a~ox r n o n~Y _ ~ ~ ~ P ns g 9~ id w s,, t ~ ARE Bl ~-pp V~~ ~ ~ - _ < a~ kn0.l 9.i. Nhl X4E uR~~ ~ Ni. ~-W w ~ ~ ~ ly ~ w ,9 P~ E C~ ~ ~ ~ _ r wsnnu a ~ S a ~ ~ e~ wnn~ ~ ~ ~~,ctF ~ Ek ~0!Ne ~ v rI, JACKSON Es ~ ~ ~ tcnw L a Ng i m~ F^=- n TOWNSHIP 9,' irvxv, ~e~ n>y c sr". ~ ~ ~ it 8° ~ ~ ~s ~ id case ¢ c 17 ~ 9s I F mac[ ccx ~ ~r ~ ~ A . - , ° _ r o ai # a _ _ '"~r'~ m~" _Iws `a^~~ ~s ~ ~ ~y ~~~s ~-nsr evES I ~?y 7B`=- 1Jam sr w fJO1H 78 ~ '~~r w ~ " ~ ~ I s~~.BO ~ 6i w - U utlJxA Si ~ ~ ~ D ~f 5~ J/Ghs 2'i vu.~er wew eo ~ n x - ` ~ ~ ' uc it a ~ ~ ~ ~ea°l ` ~e r I I ~BBP7 x l A LOUISVILLE ~ I F~I YII. \ ~ ~ `J~ ~~y, TOWNSHIP il~" iww s ~ k ~ ' 3 ~ wnwcoo 6 ~ ~,~rax oasE I - - ~J~ ~ dR , ~ w r r wR ~xeao c,~ m~' rom W r w a' i° PftIOR LAKE PRIOR LAKE zm c 6 ~ 9 a , o ,m ~ ~ i a7 I i, ~ ~ E / / ~ ~i ~ ntA n~, 6 / R ~ s g ~ 5,' / / v r, ~ _ G / ~g~ ~ o ~ /j ` ~ CRACK SEAL PROJECT FOR 2008 LAKE w,~ A I~ ~ ' ~ / ~ i ~o / /~i % ~ z , 1. ~ to ~ i. I 1 (17' ~ ` ~an: ~ ~a Cit of Shako ee ~ ~ « I~ p / ~ ',.THOLE LAKEr a`n"" II / / \ l ~ / ~ ~ ~ CRACK SEAL PRO.IE;CT FOR 2011 - 6n ~ ~ ~ - Crack Seal Ma ~ ~ , ~ ~ ~o~,;~, ~ ~ ~ ~ CRACK SEAL PROJECT FOR 2012 song sr c n ~ ~ ism nvE ` ' S( I - - - - _ - State Aid /Street Fund 2008 2009 2010 2011 2012 2013 Balance 1/1 $3,086,935 $3,403,935 $3,566,935 $4,168,935 $4,502,935 $5,542,935 Maintenance Allocation $215,000 $215,000 $220,000 $220,000 $220,000 $220,000 Construction Allocation $202,000 $299,000 $650,000 $650,000 $650,000 $650,000 Turn Back Funds $950,000 Interest $123,000 $149,000 $152,000 $164,000 $170,000 $190,000 Total Revenue $3,626,935 $4,066,935 $4,588,935 $6,152,935 $5,542,935 $6,602,935 Expenditure $223,000 $500,000 $420,000 $1,650,000 $1,600,000 Balance $3,403,935 $3,566,935 $4,168,935 $4,502,935 $5,542,935 $5,002,935 Includes using $98,000 in 2008 for seal coating. Joint Powers A reement g Seal Coat /Crack Seal and Pazr~tzng Budget 2008 thou 2012 Total Funds Required ~ Seal-Coat Crack-Seal Painting Funding Considered Necessary Pro'ect Pro'ect Pr 'e M rkin an I ~ ~ o~ ct a g d with an increase of % per year over 2007 contract Year est. Area est. Area Symbol (SY) (LF) (Gal) 3% 5% 7% 8.5% $334,427.78 $340,921.52 $347,415.27 $352,444.20 ~ j 2008 331,03 Q 60,000 1,025 Fire Sta[ion and Community Center Parking Areas paid by Building Fund i (est. $30,000.00) with an additional $30,000.00 Paid By Scott County for work on Bagle Creek Blvd. During Project Year 2008 Otily 2009 247,972 70,000 1,025 $281,249.57 $286,710.73 $292,171.88 $29b,461.38 2010 269,207 65,000 1,025 $318,045.79 $324,221.44 $330,397.09 $335,228.05 2011 250,995 65,000 1,025 $323,224.77 $329,500.97 $335,777.18 $340,700.53 2012 246,] 82 60,000 1,025 $336,287.97 $342,817.83 $349,347.70 $354,464.47 Funding Plan Bud et Bud et Bud et I g g g Essential State Aid Funds Budget Funding Funding Funding I Year for for for with an increase of % per year over 2007 contract Seal-Coat Crack-Seal Painting 3% 5% 7% 8.5% 2008 $160,000.00 $20,000.00 $14,000.00 $80,427.78 $86,921.52 $93,415.27 $98,444.20 2009 $160,000.00 $20,000.00 $1.4,000.00 $27,249.57 $32,710.73 $38,171.88 $42,46].38 ~ 2010 $175,000.00 $22,500.00 $14,500.00 $46,045.79 $52,221.44 $58,397.09 $63,228.05 2011 $1.75,000.00 $22,500.00 $15,000.00 $50,724.77 $57,000.97 $63,277.18 $68,200.53 2012 $175,000.00 $24,000.00 $16,000.00 $61,287.97 $67,817.83 $74,347.70 $79,464.47 I Work Plan Summary Seal-Coat Crack-Seal Painting Project Yellow and Symbol and Year Center-Line Parking Lot Area Total Area Total Miles (SY) (SY) (LF) White Paint Markings (Gal) (Gal) 2008 11.9 31,469 331,030 60,000 750 275 2009 11.4 247,972 70,000 750 275 ~ 2010 13.5 269,207 65,000 750 275 i 2011 10.9 250,995 65,000 750 275 2012 12.1 246,182 60,000 750 275 I I I utline _ _ _ J ~=_u~~u~ GIS an Asset Management Update ¦ Overview ¦ Update of activities to date ¦ Examples of output ¦ Overview of 2008 work plan ¦ Questions GIS and AMS Overview.,.,. J GIS/AMS Integration ,1 C ~ m,.. [ ¦ GIS is a computerized system for managing, analyzing, and displaying all forms of geographically referenced information ¦ AMS is a computerized system to: o Track estimated and actuai costs o Predict asset performance o Manage maintenance activities o Reduce liability and exposure o Maximizes existing budget dollars and helps plan future budgets o Exfend life of infrastructure r J r g Activities to Date 1 Si ns ~ L 1 ¦ Built GIS database ¦ Created GPS collection application ¦ Developed parks timesheet application ¦ Inventoried info on 1300 signs ¦ Collected sign and sidewalk GPS data ¦GPS/GIS data integrated ¦ AMSrated storm, sanitary, signs with the ¦ Supports data checkout to GPS ¦ Completed 1St phase of GIS Server ¦ Support wireless via VPN implementation ¦ Integrated information with Cartegraph ¦ Planned for the future 1 . Storm and Sanitary Sewer Televised Sanitary Sewer Map 1 ¦ Designed databases for integration ~ Y;~ - with Cartegraph ¦ Integrated GIS data with Cartegraph _ ¦ Integrated maintenance history ~ ~ ~ : ¦ Got data ready for mobile access ~s"` - L , y c'u • It ¦ Planned out functionality of timesheet ~ application ~..1=~`-~-=`` , Pavement Mana ement .I Sidewalk data collection ¦ Efficient way to collect data - ¦ Have record of issues ~ i""` ~ ¦ Have record of actions F _ ~'.4 4. a~ ;.I i V~ II i'-wcn - - - - - - - - - - - - - - - - _-<4 Parks .I 2008 Work Plan J [ C ¦ First group to get the timesheet app. ¦ Expand timesheet to all public works ¦ Efficient way to enter data departments ¦ No redundant data entry ¦ Implement CALLdirector ¦ Accurate data entry ¦ Wireless data entry via VPN ¦ Flexible reporting ¦ Final Implementation of GIS Web Server ¦ Expandable in future ¦ GPS Sanitary and Storm Sewer ¦ Deploy canned and flexible reports ¦ Integrate Z Int , ratlOn ~ Integrated Maintenance & Mapping J Q r ~9~ ~ MA ! y.,!- ~ 6 ~ ~ ' t . .Rx y a s ~ ~ - - - ~ ,y* ~ - 1i f~ ~fS~«~A ~ _ C Questions? 3 , n.,.n~. r,aa ~,ma =.a m,a na=~,.name. m o M.4 w~ex,ty rrfT ae r:,-o..Fr r~x F ,ra . a~6 w ~c ~s.~„.tr, ~a, a4~«..,i rv „ a~..~„rr ~a,., r Fti nr,~ ~r~ i .,r*J~twt-r~ .i ni, er, .m vr, .m..rrk ax M~. 3 n,,.aamsams~a, Deem,. i.n~a z r i acre mavrv~aa w=~e~a,a i ~_}y.a~ea„m..imxi ~I vwaa amsa.~~ z.m, mars r nm«, m„yam araa~~~m.i 11 'I aai~.~ v.a. mars mFem ,:ars ,cars .r.avm~m F~>av®.~~~.< ' i".-_1+,~.«~~ r.a iawe,W wrt ea a, waa i.a~„m i.m~wa ,.m tea„ -I,im x.aa.,.ma I mm xl xn spn rv enn v'is y nua'v am ~a. v, me Rrrnaanoarl ~ Jme. mnmaryafn.~ tnV. SYUmse+xo aimg,M anrs arcs mmy9o9 i•vam ~rnb ' ' I I cwp moew~owa.m„asm~ snrs ~m ma~y~m maa a,nms mmm>n ~sxi ~aav~amaa -haa naa.. aaor.i m T I a - I ~.w msa.A ew,., ra ~o ears ~x earn rn.vdm ra r;m Ar aem rsaai~wl ~l maa ~rymaanaw~ amana r„am.ag wa~~ rsn, Fa a,we >w azw e, em Im'x~ - ~4mae~~maaien~ j Ua~r, sawn, ~a~a w<ara maa m,~ „wd,rroa Faaa~.A.a.~ aoars aan, ,a.~~m ia.vam amn.w..oa ~ r a.,~ I i I i aan.o.,,rnaa aa, ~ r maa, m naa,ym Ara a, ~,~~al ~~~„m,a,~, ~~,re..,aa,mo Aa,a nem m.n,are ia.„aa r ~amawww ~,a m ~r.~ ' awaa P aM Ceara iaz~m m~7ym Ar,aw, maa,w~l I ;maa~amaa~~P L - ~ rani. s rzam r ~.a~m ,w~m~rom ~ ~ i--_~ raa~a~ra.,aa~ czars Baca iaa~w rreenr I iw~ ~ o ears ~a,ra i.eywa w~znmm~aa~,m„~, ~~wmaeaia~i ~.aam,a~a~ i~ rwrs ma~,mm mati,.m era moa ~ II i,~ la,a«~ai~a ears eoa., , d,~w r,a~m,mama ..rs~~. I~m,aa~w..¢am.~ L , seamaaw' n w,~a,aF~mana~~aaa ,nrs ava, r v,r~ Fa~h~ yam, - ~ ,~aa~w,a>ne~aar~ronr~mdm mau ears maati„m w.aay® rmk j ~ ~ ~I =„a<o ~ wMa.be»,am,as.meR ~z,ars >sa~oaa r„~n~~ N.~~,A,~am Iwa~ ~ ~N maa~ar, I o~awa~eaaas aan Ceara iw~ ,~,aa~A~~~w~i I~aa,mdanm.i I mw~.~.ea wvaa, enrs ae, mais,m raawA.a eo a». P ,~aaami ' . m,aeea,aaa~n ~~~rrsa ~n <M cars maagrm iaa~~mA, ~rMPwwaaa a~m,w~ao~s mars ma~wa ,uPw~m a,aae ~ ~ I ~ far. e„macaw., oaa,. mars r:. ra moayyna w.,~n~m I I I - . a a w ~ ~ am,rw ~aaa~.. ~,aaeamaWa„a . ~ma~~nsa a m,nmea w M i ~ is 4~~ - °a"' I I e.~e~aw,watl~wa~,eaaa Bears wan ways ,~~~aa~~~w _~,mam I' ~m~aao ~ea~~~m aaa~. o. mwr~w ia.mvwmaaars~~mw~ ~ "-1maa~~.a~e' I I I ~a,aiw,moa,maw„aw~a~ ,.nee„ maaw,m i~,~ym Rraaaanmaa,wr,, i 3 ears i - L; ma, ~„maanon, -a i~aaa.,=.~ms~, a,ars „ma, m~,ym _ _ - - i• ,~,a, r„ars r~eear• moay>,aa waarn~vm I I avaa,~,wrareaa C - - - - I ww~~aawa~~a~ wars r~,aara m~,y~, , , ~ + i I~ ~PSSgaa aaavzsm maa~,,aaime~aaaa~a~rra~~ i - _ - - ewers - - - - - tee,. rze, Baca iae.,~a, iae,~ awnmas~aow~oarsao~rn Tema ea=rs ,a.w,rm iaa~a,,a~,.a m<al,w~ ~ ~daama~a.«~, u '3 eaaowewa a<a aan mn rme wao rmn. ,a,v2so, m a-wm aaaaea,,m.,nmrd ~ iigaam,aaaaiani~ _ w orsawaaw,, ma<,bnrm,w wars a9 ear, F.wr m w.avzlm ara.~,maMwmi i_~_ _,.ry,a esam.a~awa ~waiao~awemw~~, Boars a , maw~m iasLwAr>namma~.~ ~_~~,~r„maa,wr, ~aaa~aam~o~~ a~ ,.ear, ~as~m wm~~R~aa~,ma.~;~., i ~aa~,aaaaww, aawnimes'. ~a ~.w,vnamaai ears r. er ma vam ras=ro. araaers axi n~i - i _ I ,?es~a.amm.. mn nmm roc4s Ban,: rr. ear: moa srvm w.w s,s r ^apsawl - ..._~'mr'"-s.xmanpkwl cs,uanasrn essuars a enn r,s ear, wm vam Few Rr=aersaaaryeo'ul _ L avv s mm=apart - I azryiryl w J~ ss mwd°Pawa .m.arsana nswnnar sn [ n, as mn, irvan tte mmarigvw ui.,mau..almxl ~ ~ - ~"^'a`. ' ~I i` - cm,m iregmsem ee na oeq i.aimoe maabr w crane m.almxl - ~ -~--lRVan q, manlem.l owAapnpdzama +aiiee er.rnr ao n.: was iurA~m moanam Bran - ~ mmen III ou.sau:ne ew Boors wane rnaas'am em~maaw.naJmul - - ~'~onnm wiapm~1, Vaaaaa.ane=~=ama mn~s ;sn. i...nsm F, wxa an Iwnl ~ _ ~ ~iaaV- „ma1~0~a1 '~'ryan eo,manlmxl I kginrw.iAeag aonrs sang. iaaa5ce rvmaiv r m+nlw'*I - ~ - , ay,a.eaava~awm enrs mnrs rre~aivw Faarvcs swama.wa+zVmn' ~onnmaunwia(as'r.l n~sa Mpaaors rsnia rrw Fa aism t.: br.. 7 move _ - _J~ I arnoman:ormna~irni~n r5nrs eo nrs ia.di~ iaenm aaartnmamae[ml ~ ~_~ronn xeawen ael2%I u, walrp'an,m(p se - eon P.g,xn minmwe ~ sanmvr vox r r..,a r ~ ] ,rrmiuik.ra~v.® oxMlme Hockey Rink Maintenance December 1st 2007 -Current Filter ((Activity is equal to "Park Amenities -Hockey Rinks") Or (Activity is equal to "Park Amenities -Open Ice Rinks")) Working Set Filter (..\Retease Date is null) Sort <NOt Applicable> Group By Activity Hockey Rink Maintenance Activity Park Amenities -Hockey Rinks Total For Park Amenities -Hockey Rinks Total Hours 428.75 Activity Park Amenities -Open Ice Rinks Total For Park Amenities -Open Ice Rinks Total Hours 203.75 Total Hours 632.50 Total Log 731 Tuesday, March 04,2008 1 of 1 I ~ ~ ~ ~r,,~u+......._v,.Ja.aa.~`~~aS~~.t i w~a. ~ ~f, i a ~4A~ - u i ~;3 ?V~.i sy ~~F ~s~ ~ SHAKOPEE COMMUNITY PRIDE SAKE IH57 I II PUBLIGWORKS FLEET DEPARTMENT I E- I h I I rt I ~ ~ I , I I FLEET 2007 i t Packet Information • Fleet Update • Fleet Survey Results, January 2008 • Mechanic Labor Totals for 2007 • .Department Totals of Vehicle Maintenance for 2007 • Vehicle Expense Summary for 2007 (Vehicle #55 used as an example) • Vehicle Repair Order Summary (Vehicle #55 used as an example) • Fuel Transactions for 2007 (Vehicle #55 used as an example) • Fuel Usage Totals for 2007 (Unleaded & Diesel) • Vehicle Car Wash & Truck Wash Services for 2007 • Fuel Services 2007 • Fuel Administrative Surcharges 2007 • Fuel Department Totals 2007 • Inventory -Fleet Stock Items s Fleet Update: In 2007, the focus in Fleet was to get the data & details entered from the mechanic's repair orders for each vehicle repaired. We also started tracking and entering miscellaneous work that the mechanics were providing for other City departments. This also tracked other areas of labor time that needed to be accounted for. The mechanics and Lisa discussed and redesigned the repair orders for better documentation. The Fleet Department also worked together to set up stock items, using the vendor's stock numbers for easier cross reference in future orders. Our main concern was to get the preventative stock items in our Fleet Software. Entering new stock numbers on other items is an on-going process that will streamline our stock in future years. We also did our first Stock Inventory count in December of 2007, with ayear-end count and amount that was provided to our Finance Department. Overall, we had good results for our first year. The Fleet Software has enabled us to enter large amounts of data to be compiled into reports at our fingertips. We can also view history of a vehicle that shows what parts and what maintenance was done on that particular vehicle. Data entry of the repair orders has also provided detailed reports that Lisa provides to the Finance Department on a monthly basis, in which Eileen then charges the departments for their vehicle maintenance. Entering the repair orders into the Fleet software also enables us to pull a report on accident maintenance for insurance inquiries. lnfact, mid- year of 2007 we focused on making sure that any accidents in the future are coded to the "Accident Category;' rather than separate categories such as fabrication, lighting, engine, etc. on the mechanic repair orders.. This will enable us to retrieve the accident vehicle reports more accurately, without missing any vehicles that were entered into the software. Outside labor is another area that we started tracking more closely. All outside labor invoices are being entered into the Fleet Controller software towards the vehicle. We code the invoices to an account number for Finance, which indicates to them that this invoice will be charged towards that particular vehicle on the City Department monthly reports used by Eileen. This prevents any duplication of charging the department twice for that vendor invoice. Costs can be ran by vendor name or vehicle ID number to provide reports on outside labor inquiries. One of the areas that we hope to see improvements on is the meter entries that are entered into the fuel pedestals when City employees are fueling the vehicles. About 95% of entries are correctly entered; however, we are still finding a few entries that are incorrect and coming upon the Fuel Error Reports which are ran once a week. Either the employee is entering a fictitious number, or reading the wrong meter reading. We are also showing that a few employees are sharing the fuel nozzle at time of fueling two separate vehicles. With the cooperation of the Department Heads reinforcing the importance of correct entries by their employees, we will then be able to have more accurate reports on fuel usage, miles per gallon, and preventative maintenance scheduling. Meetings are held once a month with the Fleet Department which includes the mechanics, Lisa Jeurissen, Mike Hullander, and Bruce Loney. The meetings have provided us with new ideas and better ways of improving our ways of tracking labor, vehicle maintenance, and stock inventory. The Fleet Team has worked hard to implement the "new technology" of tracking vehicle maintenance. Their efforts have not been unnoticed. As time goes on, the data entered will build a history that will benefit future reports and tracking. A Fleet Survey was conducted in January 2008. We received 25 out of 30 surveys that were randomly distributed to City departments. Included in this packet are the results. Good job City Mechanics! y a FLEET SURVEY RESULTS January 2008 Q ` 2008 Fleet Survey Results Ratings Explanation Received feedback from 25 out of 30 surveys randomly handed out. 1 Exceeds Expectations Overall, the mechanics meet employee expectations. 2 Meets Expectations 3 Needs Improvement 0 Not Applicable Maintenance and Repair Services Averaee Results A. Scheduling 1.76 Meets Expectations 8. Response time to reported needs 1.so Meets Expectations C. Job turn around time 1.72 Meets Expectations D. Quality of service 1.64 Meets Expectations E. Overall rating 1.56 Meets Expectations Requesting Service/Maintenance A. Scheduling 1.84 Meets Expectations B. Job turn around time 1.80 Meets Expectations C. Quality Of Service 1.64 Meets Expectations D. Overall rating 1.80 Meets Expectations Service Calls Off-Site (away from shop) A. Response time 0.92 Exceeds Expectations B. Quality and safety o.92 Exceeds Expectations C. Overall rating 1.00 Exceeds Expectations Preventative Maintenance Services (changing oil & filter, etc.) A. Scheduling 1.72 Meets Expectations B. Job turn around time 1.64 Meets Expectations C. Quality of Service 1.48 Exceeds Expectations D. Overall rating 1.56 Meets Expectations Body and Glass Repair A. Response time to needs 1.68 Meets Expectations 8. Turn around time 1.64 Meets Expectations C. Job quality _ 1.52 Meets Expectations Tire Repairs or Replacement A. Turn around time 1.56 Meets Expectations B. Repair quality/reliability 1.64 Meets Expectations C. Service call if needed 1.24 Exceeds Expectations r ~ Car Wash Bay Averase Results A. Availability 1.36 Exceeds Expectations B. Readiness - soap, equipment, & system always working. 1.36 Exceeds Expectations C. Detergent performance 1.44 Exceeds Expectations D. Heat, Lights, etc. 1.48 Exceeds Expectations E. Drain/Pit maintained 1.52 Meets Expectations F. Overall Rating 1.52 Meets Expectations Truck Wash Bay A. Availability 1.08 Exceeds Expectations B. Readiness - is soap, equipment, & system always working. 1.24 Exceeds Expectations C. Washer pressure 1.08 Exceeds Expectations D. Detergent performance 1.28 Exceeds Expectations E. Heat, Lights, etc. 1.08 Exceeds Expectations F. Drain/Pit maintained 1.04 Exceeds Expectations G. Overall Rating 1.28 Exceeds Expectations Fuel Island A. Location/Convenience 1.84 Meets Expectations B. Availability 1.76 Meets Expectations C. Fuel Pedestal (entering your vehicle information for authorization) 1.s4 Meets Expectations . Seasonal Vehicles (Applicable to those who run seasonal equipment/vehicles) A. QUantlty available 1.24 Exceeds Expectations B. Quality 0.96 Exceeds Expectations C. Variety 1.04 Exceeds Expectations D. Accessories provided (hitches, strobes, etc.) 1.04 Exceeds Expectations E. Overall rating 1.04 Exceeds Expectations Mechanic Staff A. Assistance 1.40 Exceeds Expectations B. Knowledge 1.36 Exceeds Expectations C. Attitude 1.60 Meets Expectations MECHANIC LABOR. TOTALS RECAP OF 2007 v f SHAKOPEE MECHANIC TIME SUMMARY 02-25-2008 Page 1 SHOW TOTALS ONLY Selection Criteria: DATE from Jan 1,2007 to Dec 31,2007 DIRECT INDIRECT TOTAL PARKS$ LABOR$ TOTAL$ TIME TIME TIME GENE JEURISSEN 010 Total 1119.8 1119.8 11135.34 72874.45 84009.79 KEITH WECKMAN 020 Total 581.5 581.5 8046.14 37794.25 45840.39 JESSE ABRAHAM 030 Total 1174.2 1174.2 24310.67 76519.30 100829.97 RYAN WIDMAN 040 Total 157.5 157.5 1914.59 10237.50 12152.09 MISC STREET 042 Total 13.5 13.5 87.65 877.50 965.15 MISC PARKS 062 Total 27.8 27.8 173.23 1803.75 1976.98 MISC STORMWATER 073 Total 8.3 8.3 15.26 536.25 551.51 Report Total 3082.5 3082.5 45682.88 200643.00 246325.88 Column Headings . DV =Division Number . VT =Vehicle Type . VEHN =Vehicle Number YRMO = A period of time (Year and Month, Year To Date, Life To Date) MILES =Miles driven (or hours) accumulated during the period GALLONS =Amount of fuel used during the period MPG =Miles Per Gallon FUEL$ =Fuel cost during the period MAINT$ =Maintenance cost during the period PM /OIL$ =Preventive Maintenance cost during the period TIRES$ =Tire cost during the period • VRBLE$ =Variable total cost during the period CPM =Cost Per Mile DOWN =Downtime during the period SHAKOPEE MECHANIC TIME SUMMARY 03-04-2008 Page 1 SHOW TOTALS ONLY ~ ~/~~Q' Selection Criteria: DATE from Jan 1,2008 to Jan 31,2008 WW pp DIRECT INDIRECT TOTAL PARTS$ LABOR$ TOTAL$ TIME TIME TIME GENE JEURISSEN 010 Total 94.8 94.8 1329.87 7106.25 8436.12 KEITH WECKMAN 020 Total 78.5 78.5 1947.40 5887.50 7834.90 JESSE ABRAHAM 030 Total 122.3 122.3 1420.94 9168.75 10589.69 RYAN WIDMAN 040 Total 3.5 3.5 12.66 262.50 275.16 Report Total 299.0 299.0 4710.87 22425.00 27135.87 X008 SHAKOPEE MECHANIC TIME SUMMARY 03-04-2008 Page 1 SHOW TOTALS ONLY Selection Criteria: DATE from Feb 1,2008 to Feb 29,2008 DIRECT INDIRECT TOTAL PARTS$ LABOR$ TOTAL$ TIME TIME TIME GENE JEURISSEN 010 Total 73.0 73.0 267.56 5437.50 5.705.06 KEITH WECKMAN 020 Total 89.5 89.5 734.70 6712.50 7447.20 JESSE ABRAHAM 030 Total 119.0 119.0 1151.76 8925.00 10076.76 MISC STREET 042 Total 12.0 12.0 86.68 900.00 986.68 Report Total 293.5 293.5 2240.70 21975.00 24215.70 DEPARTMENT TOTALS VEHICLE MAINTENANCE 2007 ~ • SHAKOPEE DETAILED VEHICLE HISTORY 02-26-2008 Page 1 Sorted by: DIVISION - TOTALS ONLY Selection Criteria: DV from 18 to 95 DATE from San 1,.2007 to Dec 31,2007 All Status Codes except SOLD PARTS$ LABOR$ TOTAL$ TIME GOVT BUILDINGS 18 Total 426.12 1370.75 1796.87 20.75 ENGINEERING 30 Total 1361.23 2501.20 3862.43 36.00 POLICE 31 Total 32817.52 63148.95 95966.47 839.45 DRUG TASK FORCE 32 Total 809.18 455.00 1264.18 7.00 BUILDING INSP 40 Total 2582.44 3840.65 6423.09 54.25 ADMINISTRATION 41 Total 51.55 545.00 596.55 7.00 STREET 42 Total 14953.59 50315.50 65269.09 730.65 SHOP 44 Total 2.98 97.50 100.48 1.50 PARK 62 Total 17133.21 44027.75 61160.96 657.10 COMM CTR 70 Total 1233.59 1853.00 3086.59 28.00 SANITARY SEWER 71 Total 4397.78 9891.00 14288.78 148.00 STORMWATER 73 Total 12081.41 22201.44 34282.85 319.40 SPUC 91 Total 403.58 1137.50 1541.08 17.50 FIRE 95 Total 8663.63 10065.50 18729.13 146.60 Report Total 96917.74 211450.80 308368.50 3013.20 VEHICLE EXPf NSE SUMMARY (Police Vehicle #55 used as an example) 2007 , q ~ ~Y ~ ~q1 ~ ad^'~ _ ~h ors ~ y - - ,~n°°°' w~ ~ ~ ~ ti~~ ~ Ial : I ~ SHAKOPEE VEHICLE VARIABLE EXPENSE SUMMARY 02-25-2008 Page 1 Sorted by: VEHN Selection Criteria: VEHN X0055 Only YRMO (from January, 2007 to December, 2007 DV VT VEHN YRMO MILES GALLONS MPG FUEL$ PARTS$ LABOR$ TIRES$ VRBLE$ CPM DOWN 31 04 0055 05 CRN VIC 0701 1957 144 13.6 264.20 0.00 48.75 0.00 312.95 0.160 0 31 04 0055 05 CRN VIC 0702 1486 177 8.4 324.94 103.95 130.00 429.90 988.79 0.665 0 31 04 0055 05 CRN VIC 0703 2389 159 15.0 335.19 133.71 162.50 0.00 631.40 0.264 0 31 04 0055 05 CRN VIC 0704 2830 222 12.7 512.71 28.84 195.00 97.50 834.05 0.295 0 31 04 0055 05 CRN VIC 0705 2373 176 13.5 472.38 14.43 130.00 20.00 636.81 0.268 0 31 04 0055 05 CRN VIC 0706 2555 202 12.6 586.28 513.97 639.45 0.00 1739.70 0.681 0 31 04 0055 05 CRN VIC 0707 2303 180 12.8 481.15 403.90 113.75 0.00 998.80 0.434 0 31 04 0055 05 CRN VIC 0708 2467 209 11.8 532.08 131.73 260.00 0.00 923.81 0.375 0 31 04 0055 05 CRN VIC 0709 2528 177 14.3 443.82 34.26 422.50 0.00 900.58 0.356 0 31 04 0055 05 CRN VIC 0710 2276 161 14.1 391.27 138.35 260.00 0.00 789.62 0.347 0 31 04 0055 05 CRN VIC 0711 2223 188 11.8 474.35 23.54 130.00 546.84 1174.73 0.528 0 31 04 0055 05 CRN VIC 0712 2402 244 9.8 638.98 144.11 227.50 0.00 1010.59 0.421 0 Vehicle Total 27789 2239 12.4 5457..35 1670.79 2719.45 1094.24 10941.83 0.394 0 Report Total 27789 2239 12.4 5457.35 1670.79 2719.45 1094.24 10941.83 0.394 0 Cr'~s L~G,l~pr T~ res ~~O,,ir~rdlexs v'P,6L~~ = Fuel Paris ~ ~.a(o~r~-T, r~~ Cp+~ = e~~- M ~ ~e~; C1-~ 55 X01 ~ ~ ~ ~~5u~a~~ 3`1 I e Y , ~f~ VEHICLE REPAIR ORDER SUMMARY (Police Vehicle #55 used as an example) JAN. 2007 thru DEC. 2007 • SHAKOPEE DETAILED VEHICLE HISTORY 03-06-2008 ~ Page 1.~ Sorted by: VEHN / DATE Selection Criteria: VEHN X0055 Only ~ DV ~ 31 Only ~ ~ DATE from Jan 1,2007 to Dec 31,2007 Q ~ ~ All Status Codes except SOLD ~ ~ ~ VEHN DV VT DESCRIPTION 0055 31 04 SQUAD.CAR 05 CRN VIC i ~ DATE CT METER COMMENTS PARTS$ LABOR$ TOTAL$ TIME MECH MECHANIC/VENDOR RON``i~/'~INV 12/28/07 30 61092 BAD SMELL IN CAR. RPL 126.24 0.00 126.24 0.00 MO10 GENE JEURISSEN 1235 12/28/07 30 61092 REAR BATTERY. BATTERY 0.00 0.00 0.00 0.00 MO10 GENE JEURISSEN 1235 12/28/07 30 61092 WAS OLD DATED JUNE2005 0.00 65.00 .65.00 1.00 M010 GENE JEURISSEN 1235 12/18/07 40 60205 APM 12.35 65.00 77.35 1.00 M030 JESSE ABRAHAM 1187 12/18/07 45 60205 CLN INJECTORS & THROTTLE 0.00 0.00 0.00 0.00 M030 JESSE ABRAHAM 1187 12/18/07 45 60205 BODY. 0.00 97.50 97.50 1.50 M030 JESSE ABRAHAM 1187 12/18/07 40 60205 PREVENTIVE MAINT 5.52 0.00 5.52 0.00 M000 PARTS ONLY 1187 11/13/07 40 57969 APM 13.13 65.00 78.13 1.00 M030 JESSE ABRAHAM 1070 11/13/07 17 57969 PUT WINTER TIRES ON. 514.34 32.50 546.84 0.50 M030 JESSE ABRAHAM 1070 11/05/07 09 57316 AIR BAG LGHT WAS FLSHG. 10.41 0.00 10.41 0.00 MO10 GENE JEURISSEN 1044 11/05/07 09 57316 SCANNED CAR CODE#B1884 0.00 0.00 0.00 0.00 MO10 GENE JEURISSEN 1044 11/05/07 09 57316 ALSO COMPRD W/UNIT 51&55 0.00 0..00 0.00 0.00 MO10 GENE JEURISSEN 1044 11/05/07 09 57316 RPLCD LAMP ASSMBLY. 0.00 65.00 65.00 1.00 M010 GENE JEURISSEN 1044 10/31/07 30 56824 TEST BATTERY-LOW;TEST 126.24 0.00 126.24 0.00 M010 GENE JEURISSEN 1030 10/31/07 30 56824 CHRAGING SYSTEM OK; RPL 0.00 0.00 0.00 0.00 M010 GENE JEURISSEN 1030 10/31/07 30 56824 BATTERY DUE TO CONTINUAL 0.00 0.00 0.00 0.00 M010 GENE JEURISSEN 1030 10/31/07 30 56824 PROBLEMS. 0.00 .65.00 65.00 1.00 MO10 GENE JEURISSEN 1030 10/29/07 30 56789 NO POWER TO FLSHLGHT; 0.00 0.00 0.00 0.00 M010 GENE JEURISSEN 1024 10/29/07 30 56789 LGHTR PLUG'D IN WRONG 0.00 0.00 0.00 0.00 M010 GENE JEURISSEN 1024 10/29/07 30 56789 TRIPLE PLUG;RPR&REWIRED 0.00 0.00 0.00 0,00 MO10 GENE JEURISSEN 1024 10129/07 30 56789 TO CHRG OFF OF REAR BAIT 0.00 65.00 65.00 1.00 M010 GENE JEURISSEN 1024 10/29/07 30 56789 INSTL ANTHR TRIPLE PLUG 0.00 0.00 0.00 0.00 M010 GENE JEURISSEN 1024 10/29/07 30 56789 FOR ADD'TL ACCESSORIES. 0.00 65.00 65.00 1.00 MO10 GENE JEURISSEN 1024 10/15/07 40 55677 APM 12.11 65.00 77.11 1.00 M030 JESSE ABRAHAM 0969 10/15/07 40 55677 PREVENTIVE MAINT 0.00 0.00 0.00 0.00 M000 PARTS ONLY 0969 09/27/07 44 54192 PUT FUEL PUMP FILTER IN. 0.00 0.00 0.00 0.00 M030 JESSE ABRAHAM 0901 09/27/07 44 54192 CK WHY CAR QUIT. 0.00 65.00 65.00 1.00 M030 JESSE ABRAHAM 0901 09/27/07 44 54192 CK FUEL PRESSURE- LOW. 0.00 65.00 65.00 1.00 M030 JESSE ABRAHAM 0901 09/27/07 40 54192 ROAD TEST 2 TIMES. 22.15 -97.50 119..65 .1.50 M030 JESSE ABRAHAM 0901 09/27/07 40 54192 CK OPERATION W/SCAN TOOL 0.00 0.00 0.00 0.00 M010 GENE JEURISSEN 0901 09/27/07 40 54192 & CK FUEL PRESSURE. 0.00 32.50 32.50 0.50 M010 GENE JEURISSEN 0901 09/27/07 40 54192 INSPECT AIRFLTR ASSEMBLY 0.00 0.00 0.00 0.00 M010 GENE JEURISSEN 0901 SHAKOPEE DETAILED VEHICLE HISTORY 03-06-2008 Page 2 09/27/07 40 54192 AND MASS AIR FLOW AND 0.00 0.00 0.00 0.00 M010 GENE JEURISSEN 0901 09/27/07 40 54192 RPL AIR FILTER. 0.00 97.50 97.50 1.50 M010 GENE JEURISSEN 0901 09/27/07 40 54192 PREVENTIVE MAINT 0,00 0.00 0.00 0.00 M000 PARTS ONLY 0901 09/13/07 40 53283 APM 12.11 65.00 77.11 1.00 M030 JESSE ABRAHAM 0867 09/13/07 40 53283 PREVENTIVE MAINT 0.00 0.00 0.00 0.00 M000 PARTS ONLY 0867 08/20/07 40 51182-BPM 64.76 130.00 194.76 2.00 M030 JESSE ABRAHAM 0759 08/20/07 13 51182 REAR BRAKES 56.77 32.50 89.27 0.50 M030 JESSE ABRAHAM 0759 08/02/07 30 49900 RPR FLASHLIGHT CHRGR; 0.00 0.00 0.00 0.00 M030 JESSE ABRAHAM 0708 08/02/07 30 49900 RPR DASHLGHT; RPR PLGINS 0.00 97.50 97.50 1.50 M030 JESSE ABRAHAM 0708 08/02/07 31 49900 CHARGING 10.20 0.00 10.20 0.00 M000 PARTS ONLY 0708 07/23/07 40 48845 PREVENTIVE MAINT 12.11 0.00 12.11 0.00 M000 PARTS ONLY 0676 07/23/07 40 48845 APM 0.00 65.00 65.00 1.00 M030 JESSE ABRAHAM 0676 07/23/07 30 48845 FIX DRVR WINDOW SWITCH 0.00 32.50 32.50 0.50 M030 JESSE ABRAHAM 0676 07/23/07 30 48845 WINDOW SWITCH 40.51 0.00 40.51 0.00 V004 APPLE FORD OF SH 18621 07/16/07 30 48255 RPL LIGHT MODULE 0.00 16.25 16.25 0.25 M040 RYAN WIDMAN 0659 07/16/07 30 48255 LIGHT MODULE 351.28 0.00 351.28 0.00 V004 APPLE FORD OF SH 18234 06/25/07 40 46863 APM 14.43 65.00 79.43 1.00 M030 JESSE ABRAHAM 0583 06/25/07 04 468&3 FIX ARM REST 0.00 32.50 32.50 0.50 M030 JESSE ABRAHAM 0583 .06/25/07 34 46863 RPL STROBLIGHT FRNT LFT 45.32 32.50 77.82 0.50 M030 JESSE ABRAHAM 0583 06/11/07 34 45722 FIX SPOTLIGHT-NEW BULB 5.64 48.75 54.39 0.75 M030 JESSE ABRAHAM 052.8 06/01/07 09 45722 RECOND BUMPER 448.58 460.70 909.28 0.00 V016 CANTEBURY COLL/G 28649 06/01/07 09 45722 INVOICE DATED 02/05/07 0.00 0.00 0.00 0.00 V016 CANTEBURY COLL/G 28649. 06/01/07 09 45722 *HAS BEEN CHRG'D TO PD* 0.00 ~ 0.00 0.00 0.00 V016 CANTEBURY COLL/G 28649 05/30/07 40 44560 PREVENTIVE MAINT 14.43 0.00 14.43 0.00 M000 PARTS ONLX 0478 05/30/07 17 44560 BALANCE TIRES 0.00 20.00 20.00 0.00 V043 HENNEN'S SHELL 0478 05/30/07 40 44560 APM 0.00 65.00 65.00 1.00 M030 JESSE ABRAHAM 0478 05/17/07 34 43578 RPR WILDCARD UNIT LIGHTS 0.00 65:00 65.00 1.00 M010 GENE JEURISSEN 0436 04/30/07 40 42289 APM 1.4.42 65.00 79.42 1.00 M030 JESSE ABRAHAM 0385 04/24/07 30 41718 RPL THE GUN LOCK TIMER 0.00 65.00. 65.00 1.00 MO10 GENE JEURISSEN 0367 04/12/07 17 40754 FORD RIM RECALL ON RIMS 0.00 48.75 48.75 0.75 MO10 GENE JEURISSEN 0331 04/12/07 I7 40754 SWITCHED RIMS & TIRES 0.00 48.75 48.75 0.75 M010 GENE JEURISSEN 0331 04/04/07 40 39883 APM 14.42 65.00 79.42 1.00 M030 JESSE ABRAHAM 0313 03/12/07 40 37832 BPM 47.19 130.00 177.19 2.00 M030 JESSE ABRAHAM 0246 03/12/07 40 37832 PREVENTIVE MAINT 0.00 0.00 0.00 0.00 M000 PARTS ONLY 0246 03/12/07 40 37832 PREVENTIVE MAINT 33.88 0.00 33.88 0.00 M000 PARTS ONLY 0246 03/06/07 34 37489 RPL SPOTLIGHT HANDLE 52.64 32.50 85.14 0.50 M010 GENE JEURISSEN 0229 02/07/07 40 35739 APM 13.96 65.00 78.96 1.00 M030 JESSE ABRAHAM 0156 02/07/07 17 35739 iNSTL 4 NEW SNOW TIRES 397.40 32.50 429.90 0.50 M030 JESSE ABRAHAM 0156 02/05/07 31 35584 CK & TEST BATTERY (BAD) 0.00 32.50 32.50 0.50 M010 GENE JEURISSEN 0152 02/05/07 04 35584 RPL BATTERY;MADE BRKT 0.00 32.50 32.50 0.50 M010 GENE JEURISSEN 0152- 02/05/07 30 35584 ELECTRICAL 89.99 0.00 89.99 0.00 M000 PARTS ONLY 0152 01/22/07 34 34756 RPR SPOTLIGHT 0.00 48.75 48.75 0.75 M010 GENE JEURISSEN 0112 29 repair orders Vehicle 0055 Total 2582.53 2901.95 5484.48 37.25 29 repair orders Report Total 2582.53 2901.95 5484.48 37.25 FUEL TRANSACTION REPORT (Police Vehicle #55 used: as an example) 2007 . ~ SHAKOPEE FUEL TRANSACTIONS 02-25-2008 Page 1 Sorted by: VENN/ DATE Selection Criteria: VEHN X0055 Only DATE from Jan 1,2007 to Dec 31,2007 ATE DV VEHN METER GALLONS FUEL$ FUELTYPE NOTES 1/04/2007 31 0055 33850 13.1 26.06 G UNLEAD GASBOY4B 1/05/2007 31 0055 33998 8.2 16.25 G UNLEAD GASBOY4B 1/06/2007 31 0055 34078 5.6 10.05 G UNLEAD GASBOY4B 1/09/2007 31 0055 34186 17.1 30.95 G UNLEAD GASBOY4B 1/11/2007 31 0055 34295 7.1 12.85 G UNLEAD GASBOY4B 1/13/2007 31 0055 34395 9.0 16.24 G UNLEAD GASBOY4B 1/14/2007 31 0055 34445 4.8 8.72 G UNLEAD GASBOY4B 1/16/2007 31 0055 34545 13.7 24.83 G UNLEAD GASBOY4B 1/20/2007 31 0055 34695 17.2 31.06 G UNLEAD GASBOY4B 1/24/2007 31 0055 34806 15.1 27.3.5 G UNLEAD GASBOY4B 1/26/2007 31 0055 34914 13.7 24.78 G UNLEAD GASBOY4B 1/28/2007 31 0055 35088 13.1 23.69 G UNLEAD GASBOY4B 1/29/2007 31 0055 35172 6.3 11.37 G UNLEAD GASBOY4B 2/03/2007 31 0055 35453 23.5 42.50 G UNLEAD GASBOY4B 2/04/2007 31 0055 35523 6.7 12.16 G UNLEAD GASBOY4B 2/05/2007 31 0055 35584 5.8 10.55 G UNLEAD GASBOY4B 2/06/2007 31 0055 35659 7.8 14.19 G UNLEAD GASBOY4B 2/09/2007 31 0055 35809 15.8 29.16 G UNLEAD GASBOY4B 2/10/2007 31 0055' 35907 10.1 18.70 G UNLEAD GASBOY4C 2/12/2007 31 0055 36092 5.9 10.86 G UNLEAD GASBOY4C 2/13/2007 31 0055 36163 6.2 11.41 G UNLEAD GASBOY4C 2/15/2007 31 0055 36265 10.4 19.26 G UNLEAD GASBOY4C 2/18/2007 31 0055 36416 16.6 30.77 G UNLEAD GASBOY4C 2/19/2007 31 0055 36461 6.4 11.77 G UNLEAD GASBOY4C 2/20/2007 31 0055 36572 7.6 14.06 G UNLEAD GASBOY4C 2/24/2007 31 0055 36710 15.0 27.68 G UNLEAD GASBOY4C 2/25/2007 31 0055 36819 15.4 28.45 G UNLEAD GASBOY4C 2/27/2007 31 0055 36931 13.3 24.59 G UNLEAD GASBOY4C 2/28/2007 31 0055 37070 10.2 18.83 G UNLEAD GASBOY4C ?/28/2007 31 0055 37020 0.0 0.00 G UNLEAD GASBOY4C 3/01/2007 31 0055 37141 6.3 11.58 G UNLEAD GASBOY4C 3/02/2007 31 0055 37243 8.0 14.84 G UNLEAD GASBOY4C 3/03/2007 31 0055 37381 11.3 20.94 G UNLEAD GASBOY4C 3/05/2007 31 0055 37416 8.3 15.39 G UNLEAD GASBOY4C 3/07/2007 31 0055 37532 13.2 24.48 G UNLEAD GASBOY4C 3/08/2007 31 0055 37584 6.7 12.34 G UNLEAD GASBOY4C 3./17/2007 31 0055 38334 9.6 21.57 G UNLEAD GASBOY4C 3/18/2007 31 0055 38474 9.6 21.57 G UNLEAD GASBOY4C 3/19/2007 31 0055 38555 7.0 15.68 G UNLEAD GASBOY4C 3/20/2007 31 0055 38686 11.0 24.64 G UNLEAD GASBOY4C 3/22/2007 31 0055 38883 14.9 33.29 G UNLEAD GASBOY4C 3/24/2007 31 0055 38967 10.5 23.45 G UNLEAD GASBOY4C 3/25/2007 31 0055 39049 7.3 16.31 G UNLEAD GASBOY4C 3/26/2007 31 0055 39149 7.8 17.47 G UNLEAD GASBOY4C 3/28/2007 31 0055 39282 12.1 27.10 G UNLEAD GASBOY4C 3/31/2007 31 0055 39459 15.4 34.54 G UNLEAD GASBOY4C ~/Ol/2007 31 0055 39563 9.3 20.90 G UNLEAD GASBOY4C x/02/2007 31 0055 39672 7.2 16.17 G UNLEAD GASBOY4C x/03/2007 31 0055 39728 4.6 10.33 G UNLEAD GASBOY4C x/04/2007 31 0055 39881 9.8 21.88 G UNLEAD GASBOY4C x/06/2007 31 0055 40076 16.8 37.52 G UNLEAD GASBOY4C SHAKOPEE FUEL TRANSACTIONS 02-25-2008 Page 2 ATE DV VENN METER GALLONS FUEL$ FUELTYPE NOTES x/08/2007 31 0055 40215 14.7 33.02 G UNLEAD GASBOY4C 4/09/2007 31 0055 40421 14.5 32.50 G UNLEAD GASBOY4C 4/10/2007 31 0055 40516 5.7 12.79 G UNLEAD GASBOY4C 4/11/2007 31 0055 40628 7.3 16.42 G UNLEAD GASBOY4C 4/12/2007 31 0055 40753 7.8 17.36 G UNLEAD GASBOY4C 4/14/2007 31 0055 40846 10.0 22.31 G UNLEAD GASBOY4C 4/15/2007 31 0055 40987 12.0 26.88 G UNLEAD GASBOY4C 4/17/2007 31 0055 41141 11.4 25.42 G UNLEAD GASBOY4C 4/19/2007 31 0055 41266 10.3 24.74 G UNLEAD GASBOY4C 4/20/2007 31 0055 41315. 3.1 7.44 G UNLEAD GASBOY4C 4/21/2007 31 0055 41414 8.4 20.26 G UNLEAD GASBOY4C 4/22/2007 31 0055 41542 10.9 26.09 G UNLEAD GASBOY4C 4/24/2007 31 0055 41720 14.9 35.76 G UNLEAD GASBOY4C 4/26/2007 31 0055 41862 9.5 22.75 G UNLEAD GASBOY4C 4/27/2007 31 0055 41945 6.8 16.39 G UNLEAD GASBOY4C 4/28/2007 31 0055 42008 5.6 13.34 G UNLEAD GASBOY4C 4/29/2007 31 0055 42125 9.6 22.97 G UNLEAD GASBOY4C 4/30/2007 31 0055 42225 12.3 29.47 G UNLEAD GASBOY4C 5/02/2007 31 0055 42472 13.5 32.33 G UNLEAD GASBOY4C 5/03/2007 31 0055 42611 9.0 21.60 G UNLEAD GASBOY4C 5/05/2007 31 0055 42729 11.8 28.27 G UNLEAD GASBOY4C 5/06/2007 31 0055 42807 7.7 18.43 G UNLEAD GASBOY4C 5/07/2007 31 0055 42853 3.6 8.71 G UNLEAD GASBOY4C 5/09/2007 31 0055 43000 10.0 23.88 G UNLEAD GASBOY4C 5/11/2007 31 0055 43103 11.2 26.78 G UNLEAD GASBOY4C 5/13/2007 31 0055 43230 11.4 27.43 G UNLEAD GASBOY4C 5/14/2007 31 0055 43310 6.1 14.54 G UNLEAD GASBOY4C 5/15/2007 31 0055 43413 8.5 20.33 G UNLEAD GASBOY4C 5/16/2007 31 0055 43512 6.5 15.48 G UNLEAD GASBOY4C 5/18/2007 31 0055 43643 9.9 30.36 G UNLEAD GASBOY4C 5/20/2007 31 0055 43790 14.3 43.99 G UNLEAD GASBOY4C 5/21/2007 31 0055 43847 3.7 11.33 G UNLEAD GASBOY4C 5/22/2007 31 0055 43967 8.2 25.14 G UNLEAD GASBOY4C 5/22/2007 31 0055 51275 4.3 13.20 G UNLEAD 5/23/2007 31 0055 44075 8.7 26.56 G UNLEAD GASBOY4C 5/25/2007 31 0055 51386 8.6 26.40 G UNLEAD 5/29/2007 31 0055 44519 2.0 6.14 G UNLEAD GASBOY4C 5/29/2007 31 0055 44520 3.4 10.50 G UNLEAD GASBOY4C 5/31/2007 31 0055 44662 13.4 40.98 G UNLEAD GASBOY4C 6/02/2007 31 0055 44825 14.7 45.01 G UNLEAD GASBOY4C 6/03/2007 31 0055 44925 9.4 28.83 G UNLEAD GASBOY4C 6/04/2007 31 0055 45011 6.8 20.85 G UNLEAD GASBOY4C 6/05/2007 31 0055 45159 8.8 26.89 G UNLEAD GASBOY4C 6/07/2007 31 0055 45343 14.4 44.21 G UNLEAD GASBOY4C 6/08/2007 31 0055 45496 9.3 28.67 G UNLEAD GASBOY4C 6/09/2007 31 0055 45567 6.5 19.96 G UNLEAD GASBOY4C 6/10/2007 31 0055 45675 9.3 28.61 G UNLEAD GASBOY4C 6/12/2007 31 0055 45853 14.3 43.81 G UNLEAD GASBOY4C 6/15/2007 31 0055 46025 14.5 44.52 G UNLEAD GASBOY4C 6/16/2007 31 0055 46111 8.2 25.20 G UNLEAD GASBOY4C 6/17/2007 31 0055 46210 8.0 24.50 G UNLEAD GASBOY4C 6/18/2007 31 0055 46304 6.9 21.06 G UNLEAD GASBOY4C 6/21/2007 31 0055 46475 15.0 38.73 G UNLEAD GASBOY4C 6/23/2007 31 0055 46577 9.2 23.61 G UNLEAD GASBOY4C 6/24/2007 31 0055 46715 10.5 27.14 G UNLEAD GASBOY4C . ~ SHAKOPEE FUEL TRANSACTIONS 02-25-2008 Page 3 ATE DV VEHN METER GALLONS FUEL$ FUELTYPE NOTES 6/25/2007 31 0055 41755 11.5 29.75 G UNLEAD GASBOY4C 6/27/2007 31 0055 46997 8.7 22.47 G UNLEAD GASBOY4C 6/29/2007 31 0055 47160 12.7 32.71 G UNLEAD GASBOY4C 6/30/2007 31 0055 47217 3.8 9.75 G UNLEAD GASBOY4C 7/01/2007 31 0055 47378 8.0 20.72 G UNLEAD GASBOY4C 7/01/2007 31 0055 47283 5.5 14.14 G UNLEAD GASBOY4C 7/03/2007 31 0055 47482 7.3 18.86 G UNLEAD GASBOY4C 7/04/2007 31 0055 47613 11.0. 28.25 G UNLEAD GASBOY4C 7/06/2007 31 0055 47752 8.4 21.57 G UNLEAD GASBOY4C 7/09/2007 31 0055 47878 13.8 35.63 G UNLEAD GASBOY4C 7/10/2007 31 0055 47974 8.2 21.21 G UNLEAD GASBOY4C 7/11/2007 31 0055 48056 7.1 18.19 G UNLEAD GASBOY4C 7/12/2007 31 0055 48165 7.4 19.20 G UNLEAD GASBOY4C 7/13/2007 31 0055 48248 5.5 14.11 G UNLEAD GASBOY4C 7/18/2007 31 0055 48379 10.7 29.48 G UNLEAD GASBOY4C 7/19/2007 31 0055 48514 11.0 30.22 G UNLEAD GASBOY4C 7/20/2007 31 0055 4861.1 6.2 17.11 G UNLEAD GASBOY4C 7/21/2007 31 0055. 48704 7.2 19.66 G UNLEAD GASBOY4C 7/22/2007 31 0055 48823 7.3 20.13 G UNLEAD GASBOY4C 7/24/2007 31 0055 48913 8.3 22.91 G UNLEAD GASBOY4C 7/25/2007 31 0055 48999 6.1 16.89 G UNLEAD GASBOY4C 7/26/2007 31 0055 49142 10.8 29.65 G UNLEAD GASBOY4C 7/28/2007 31 0055 49284 11.1 30.61 G UNLEAD GASBOY4C ' 7/29/2007 31 0055 49423 9.3 25.69 G UNLEAD GASBOY4C 7/31/2007 31 0055 49520 9.8 26.92 G UNLEAD GASBOY4C 8/02/2007 31 0055 49692 12.1 33.28 G UNLEAD GASBOY4C 8/02/2007 31 0055 49750 4.2 11.61 G UNLEAD GASBOY4C 8/03/2007 31 0055 49876 9.7 26.59 G UNLEAD GASBOY4C 8/04/2007 31 0055 49941 5.9 16.17 G UNLEAD GASBOY4C 8/05/2007 31 0055 500,55 11.2 30.66 G UNLEAD GASBOY4C 8/07/2007 31 0055 50149 8.4 23.05 G UNLEAD GASBOY4C 8/09/2007 31 0055 50223 7.9 21.75 G UNLEAD GASBOY4C 8/10/2007 31 0055 50331 11.0 27.19 G UNLEAD GASBOY4C 8/11/2007 31 0055 50452 7.5 18.57 G UNLEAD GASBOY4C 8/12/2007 31 0055 50544 9.8 24.21 G UNLEAD GASBOY4C 8/12/2007 31 0055 50626 6.7 -16.62 G UNLEAD GASBOY4C 8/15/2007 31 0055 50746 9.9 24,50 G UNLEAD GASBOY4C 8/16/2007 31 0055 50804 4.6 11.26 G UNLEAD GASBOY4C 8/18/2007 31 0055 50996 15.0 36.98 G UNLEAD GASBOY4C 8/19/2007 31 0055 51146 11.6 28.58 G UNLEAD GASBOY4C 8/22/2007 31 0055 51349 14.8 36.56 G UNLEAD GASBOY4C 8/23/2007 31 0055 51418 7.7 19.02 G UNLEAD GASBOY4C 8/24/2007 31 0055 51636 16.3 40.36 G UNLEAD GASBOY4C 8/27/2007 31 0055 51721 11.5 28.41 G UNLEAD GASBOY4C 8/29/200.7 31 0055 51862 13.6 33.49 G UNLEAD GASBOY4C 8/31/2007 31 0055 51987 9.4 23.22 G UNLEAD GASBOY4C 9/05/2007 31 0055 52479 10.0 24.65 G UNLEAD GASBOY4C 9/06/2007. 31 0055 52658 13.5 33.22 G UNLEAD GASBOY4C 9/07/2007 31 0055 52846 15.6 38.53 G UNLEAD GASBOY4C 9/09/2007 31 0055 53038 15.4 37.91 G UNLEAD GASBOY4C 9/12/2007 31 0055 53215 14.4 36.21 G UNLEAD GASBOY4C 9/13/2007 31 0055 53321 8.2 20.59 G UNLEAD GASBOY4C 9/14/2007 31 0055 53413 5.9 14.87 G UNLEAD GASBOY4C 9/15/2007 31 0055 53555 12.1 30.52 G UNLEAD GASBOY4C 9/16/2007 31 0055 53660 8.2 20.74 G UNLEAD GASBOY4C SHAKOPEE FUEL TRANSACTIONS 02-25-2008 Page 4 , ATE DV VEHN METER GALLONS FUEL$ FUELTYPE NOTES 3/19/2007 31 0055 53823 16.1 40.67 G UNLEAD GASBOY4C x/21/2007 31 0055 53980 12.5 31.50 G UNLEAD GASBOY4C x/23/2007 31 0055 54152 14.1 35.61 G UNLEAD GASBOY4C 3/27/2007 31 0055 54246 11.5 29.01 G UNLEAD GASBOY4C 3/28/2007 31 0055 54370 9.0 22.65 G UNLEAD GASBOY4C 3/30/2007 31 0055 54515 10.8 27.14 G UNLEAD GASBOY4C 0/02/2007 31 fl055 54623 10.7 27.06 G UNLEAD GASBOY4C 0/03/2007 31 0055 54780 13.6 34.32 G UNLEAD GASBOY4C 0/11/2007 31 0055 55357 14.8 35.60 G UNLEAD GASBOY4C 0113/2007 31 0055 55500 10.4 25.16 G UNLEAD GASBOY4C 0/14/2007 31 0055 55586 6.4 15.38 G UNLEAD GASBOY4C 0/16/2007 31 0055 55728 11.7 28.25 G UNLEAD GASBOY4C 0/18/2007 31 0055 55814 10.0 24.03 G UNLEAD GASBOY4C 0/19/2007 31 0055 55963 14.4 34.66 G UNLEAD GASBOY4C 0/21/2007 31 0055 56085 10.9 26.29 G UNLEAD GASBOY4C 0/22/2007 31 0055 56193 7.2 17.23 G UNLEAD GASBOY4C 0/23/2007 31 0055 56337 11.0 26.53 G UNLEAD GASBOY4C 0/24/2007 31 0055 56423 6.2 14.94 G UNLEAD GASBOY4C 0/26/2007 31 0055 56573 12.0 28.94 G UNLEAD GASBOY4C 0/27/2007 31 0055 56667 10.3 24.92 G UNLEAD GASBOY4C 0/30/2007 31 0055 56791 11.6 27.96 G UNLEAD GASBOY4C 1/01/2007 31 0055 56854 7.4 17.91 G UNLEAD GASBOY4C 1/02/2007 31 0055 56962 9.8 23.59 G UNLEAD GASBOY4C 1/03/2007 31 0055 57121 10.7 25.84 G UNLEAD GASBOY4C 1/04/2007 31 0055 57228 7.7 18.46 G UNLEAD GASBOY4C 1/06/2007 31 0055 57363 9.1 21.96 G UNLEAD GASBOY4C 1/07/2007 31 0055 57475 9.5 22.85 G UNLEAD GASBOY4C 1/08/2007 31 0055 57581 7.3 17.59 G UNLEAD GASBOY4C 1/09/2007 31 0055 57668 8.1 19.47 G UNLEAD GASBOY4C 1/10/2007 31 0055 57824 13.0 31.21 G UNLEAD GASBOY4C 1/12/2007 31 0055. 57911 9.9 23.88 G UNLEAD GASBOY4C 1/14/2007 31 0055 58046 10.9 26.32 G UNLEAD GASBOY4C 1/16/2007 31 0055 58200 13.9 37.17 G UNLEAD GASBOY4C 1/18/2007 31 0055 58252 12.7 33.99 G UNLEAD GASBOY4C 1/20/2007 31 0055 58496 12.9 34.52 G' UNLEAD GASBOY4C 1/23/2007 31 0055 58629 11.6 30.87 G UNLEAD GASBOY4C 1/24/2007 31 0055 58701 7.2 19.20 G UNLEAD GASBOY4C 1/26/2007 31 0055 58885 12.6 33.56 G UNLEAD GASBOY4C 1/29/2007 31 0055 59014 13.5 35.96 G UNLEAD GASBOY4C 2/01/2007 31 0055 59214 10.5 28.01 G UNLEAD GASBOY4C 2/02/2007 31 0055 59520 12.8 34.10 G UNLEAD GASBOY4C 2/04/2007 31 0055 59360 10.0 26.81 G UNLEAD GASBOY4C 2/05/2007 31 0055 59508 15.3 40.90 G UNLEAD. GASBOY4C 2/08/2007 31 0055 59623 15.7 41.87 G UNLEAD GASBOY4C 2/09/2007 31 0055 59729 10.1 26.89 G UNLEAD GASBOY4C 2/12/2007 31 0055 59893 14.2 38.02 G UNLEAD GASBOY4C 2/13/2007 31 0055 59950 11.0 29.26 G UNLEAD GASBOY4C 2/15/2007 31 0055 60030 13.8 36.85 G UNLEAD GASBOY4C 2/16/2007 31 0055 60200 15.1 40.24 G UNLEAD GASBOY4C 2/19/2007 31 0055 60287 7.2 18.51 G UNLEAD GASBOY4C 2/20/2007 31 0055 60456 13.0 33.33 G UNLEAD GASBOY4C 2/22/2007 31 0055 60567 12.1 31.03 G UNLEAD GASBOY4C 2/24/2007 31 0055 60727 17.3 44.21 G UNLEAD GASBOY4C 2/26/2007 31 0055 60912 15.5 39.58 G UNLEAD GASBOY4C 2/26/2007 31 0055 60975 5.6 14.41 G UNLEAD GASBOY4C • SHAKOPEE FUEL TRANSACTIONS 02-25-2008 Page 5 LATE DV VENN METER GALLONS FUEL$ FUELTYPE NOTES .2/28/2007 31 0055 61087 10.3 26.47 G UNLEAD GASBOY4C .2/2912007 31 0055 61167 10.8 27.72 G UNLEAD GASBOY4C .2/30/2007 31 0055 61287 11.6 29.64 G UNLEAD GASBOY4C .2/31/2007 31 0055 61416 12.2 31.13 G UNLEAD GASBOY4C 220 transaction(s) 2238.6 5457.35 220 transaction(s) 2238.6 5457.35 Report Totals FUEL USAGE TOTALS 2007 q t 1 S '.S i i 1.08.01.1 Fuel Transactions (complete format) 02/27/200813:25:23 From 01/01/2007 To 12/31/2007 Page 1 of 1 - CITY OF SHAKOPEE 400 GORMAN ST SHAKOPEE MN 55379 SITE- TRAN DATE TIME P# PR :PRICE ODOM ERR $ TOTAL QUANTITY MILES MPG KEY1 KEY2 VEH DEPT EMP PR 00 TOTAL: (Q „ ~ ~ 59.96 21.030 407 19.4 PR 01 TOTAL: 1 eQd ~ 218307.69 89793.130 1026132. 11.4 PR 02 TOTAL: ~ ~ ~~i 232655.53 94344.630 769249 8.2 GRAND TOTAL: ` 451023.18 184158.790 1795788 Records requested PR : 00-02 Ascending DEPARTMENT FUEL TOTALS 2007 (Includes Scott County & SPUC) ~ ~ o 0 r~~ .~Q ~ ~ Cam- Ilill 1.08.01.1 Fuel Transactions (complete format) 02/28/200807:46:30 From 01/01/2007 To 12/31/2007 Page 1 of3 CITY OF SHAKOPEE 400 GORMAN ST SHAKOPEE MN 55379 SITE -IRAN DATE TIME P# PR PRICE ODOM ERR $ TOTAL QUANTITY MILES MPG KEY1 KEY2 VEH DEPT EMP DEPT 0018 TOTAL: 0.00 0.000 0 0.0 DEPT 0030 TOTAL: 0.00 0.000 2 0.0 EPT 0031 TOTA 23.1 a 9.030 82 9.1 ~'R ~~rrz~r ~C7ti i d ~ pEP 0032 TOTAL: 0.00 0.000 0 0.0 DEPT 0040 TOTAL: 0.00 0.000 0 0.0 DEPT 0041 TOTAL: 0.00 0.000 0 0.0 DEPT 0042 TOTAL: 0.00 0.000 0 0.0 ~e-U 0~~-0~~~ C,,, ~ ~ ~ _ S -1 C,1 36.84 12.000 320 26.7 DEPT 0051 TOTAL: ~.~.il 1 0.00 0.000 0 0.0 ~~'`'`°"-"`y" DEPT 0062 TOTAL: 0.00 0.000 3 0.0 ~ ~ ~ ~ ~.'~'l~ DEPT 0070 TOTAL: 0.00 0.000 0 0.0 ~ ~l ~ u~~~"` DEPT 0071 TOTAL: 0.00 0.000 0 0.0 DEPT 0073 TOTAL: a.00 0.000 0 0.0 C~~ ~ i~ ' l ~ " DEPT 0091 TOTAL: a.ao a.ooo 0 0.0 DEPT 0095 TOTAL: 0.00. 0.000 ~0 0.0 DEPT 0251 TOTAL: 0.00 O.oao 0 0.0 DEPT 1100 TOTAL: 0.00 0.000 0 0.0 DEPT 1550 TOTAL: 0.00 0.000 0 0.0 DEPT 1600 TOTAL: 0.00 0.000 0 0.0 1.08.01.1 Fuel Transactions (complete format) , 02/28/2008 07:46:48 From 01/01/2007 To 12/31/2007 Page 2 of 3 SITE TRAN DATE TIME P# PR .PRICE ODOM ERR $ TOTAL QUANTITY MILES MPG KEY1 ; KEY2 VEH DEPT EMP DEPT 1750 TOTAL: 0.00 0.000 0 0.0 DEPT 1950 TOTAL: 0.00 0.000 0 0.0 DEPT 6300 TOTAL: 0.00 0.000 0 0.0 u~ 1 ^ „ ~ _ ` ,<-,,,t DEPT 6600 TOTAL: 0.00 0.000 0 0.0 1 ~l~(~, `~-(JJ DEPT 6700 TOTAL: nn 0.00 0.000 0 0.0 PR 00 TOTAL: = ~C~S ~ 59.96 21.030 407 19.4 DEPT 0018 TOTAL: 403.91 169.580 1801 10.6 DEPT 0030 TOTAL: ~ 4981.51 1951.080 22084 11.3 DEPT 0031 TOTAL: ~ 98760.17 40619.440 448305 11,0 DEPT 0032 TOTAL: 5129.13 2158.980 30992 14.4 S r( -nr(;~ DEPT 0040 TOTAL:. 7737.18 3198.960 38364 12.0 ~.s. t~ DEPT 0041 TOTAL: ~ 543.25 214.040 3135 14.6 ~'Yl ~ 1 ~~Q.~ I pl~l DEPT 0042 TOTAL~~~~~~ 5834.18 2402.680 23168 9.6 r DEPT 0050 TOTAL: ` t _ _ ~ 6979.71 2758.960 59174 21.4 ~ If ~Ca' ~ 1 i ~cr't C~ DEPT 0051 TOTAL: ~ 17406.37 7338.100 143672 19.6 DEPT 0062 TOTALc' j ~ tJr1.~~ 6484.36 2610.760 19470 7.5 DEPT 0070 TOTAL: ~}~(i®~~~ Q ~ 1897.98 760.710 8368 11.0 DEPT 0071 TOTAL: l.J 4221.77 1729.430 14232 8.2 ~ ' ~ DEPT 0091 TOTAL: ~~i , ~ 465o4.a2 19145.500 172867 9.0 DEPT 0095 TOTAL: r 11341.82 4703.810 38176 8.1 DEPT 1600 TOTAL: 82.13 31.100 2324 74.7 ~~d~~-~~-. C.~t~~~-~ veh~c~~ ~'.-e evY-r~ re 1.0 $.01.1 -Fuel Transactions (complete format) , . 02/28/2008 07:46:30 From 01/01/2007 To 12/31/2007 Page 3 of 3 SITE. - TRAN DATE TIME P# PR PRICE ODOM ERR $ TOTAL QUANTITY MILES MPG KEY1 KEY2 VEN DEPT EMP PR 01 TOTAL' ~,`{1 ~ ~ 218307.69 89793.130 1026132 11.4 DEPT 0030 TOTAL: ~ 0.00 0.000 10 0.0 [ ~ ~t rlg DEPT 0042 TOTAL: ~r.,~~.,t. 38504.84 15394.610 41675 2.7 DEPT 0051 TOTAL: l~ 133135.06 54179.850 598234 11.0 - DEPT 0062 TOTAL: ~n ~i J 18165.57 7311.730 12202 1.7 DEPT 0071 TOTAL: 5.1~~ ice. 2117.20 830.630 1763 2.1 n 1 `°Y~l ~ i C~ ,/`,1~~~ DEPT 0073 TOTAL: L _ 9309.87 3735.070 9221 2.5 J.~.~ DEPT 0091 TOTAL: ~~(7(1~~/~ W 16652.32 6809.240 77201. 11.3 t DEPT 0095 TOTAL: ~ ~h 14770.67 6083.500 28943 4.8 PR 02 TOTAL: = ~ ~SL~ -~~~5 ~ 232655.53 94344.630 769249 8.2 GRAND TOTAL' 451023.18 184158.790 1795788 Records requested PR : 00-02 Ascending DEPT :ALL Ascending ~c~~~-~ ~ ~ ~~~~1 FUEL 2007 ADMINISTRATIVE SURCHARGES I 2007 FUEL CHARGES SPUC School Scott Co January 2,052.13 121.26 4,582.77 February 1,770.23 136.83 4,490.18 March 2,057.43 103.06 4,605.55 April 2,097.73 207.92 4,778.38 May 2,431.30 255.30 5,251.61 June 2,402.60 409.23 6,505.98 July 2,539.77 426.49 6,556.56 August 2,784.35 435.29 6,088.99 September 1,896.45 150.91 4,558.18 October 2,357.06 179.11 4,960.79 November 1,787.00 155.69 4,270.16 December 1,778.69 178.70 4,783.98 25,954.74 2,759.79 61,433.13 $0.05/gal 1,297.74 137.99 3,071.66 Total 4, 507.38 } VEHICLE WASH SERVICES (car wash and truck wash) 2007 1 I~ I?~ ~ << J Car Wash Debit $6,614.11 Credit $9,312.67 Net $2,698.56 Profit Truck Wash Debit $12,338.16 Credit $ 8,227.18 Net $ 4,110.98 Loss INVENTORY FLEET STOCK ITEMS J~ C C SHAKOPEE MASTER PARTS LISTING 02-25-2008 Page 1 Sorted by: PARTDESC CT PARTCODE VENDCODE PARTDESC LOCATION ONHAND EXPDATE LASTORD FROM AVGCOST VALUE 30 755-1845 ADAPTER-ELEC PLUG 1 16.50 16.50 40 BW/R109685 AIR DRYER 2 308.85 617.70 40 46253 AIR FILTER 1 9.44 9.44 40 42562 AIR FILTER 1 18.41 18.41 40 42621 AIR FILTER 0 4.55 0.00 40 42233 AIR FILTER 1 21.65 21.65 40 42255 AIR FILTER 1 21.42 21.42 40 42292 AIR FILTER 1 3.77 3.77 40 42305 AIR FILTER 1 6.61 6.61 40 42336 AIR FILTER 1 30.96 30.96 40 42371 AIR FILTER 3 5.32 15.96 40 42374 AIR FILTER 1 4.16 4.16 40 42522 AIR FILTER 1 29.9.1 29.91 40 46035 AIR FILTER 1 8.30 8.30 40 46126 AIR FILTER 1 4.97 4.97 40 46153 AIR FILTER 1 6.13 6.13 40 46180 AIR FILTER 1 6.13 6.13 40 46302 AIR FILTER 1 7.49 7.49 40 46406 AIR FILTER 1 10.91 10.91 40 46441 AIR FILTER 1 13.63 13.63 40 46443 AIR FILTER 0 12.26 0.00 40 46449 AIR FILTER 2 14.14 28.28 40 46453 AIR FILTER 1 16.59 16.59 40 46528 AIR FILTER 1 22.34 22.34 40 46571 AIR FILTER 0 16.30 0.00 40 46761 AIR FILTER 0 46.09 0.00 40 46577 AIR FILTER 1 16.30 16.30 40 46804 AIR FILTER 1 17.84 17.84 40 42088 AIR FILTER 2 4.51 9.02 40 42095 AIR FILTER 1 6.21 6.21 40 42126 AIR FILTER 2 16.01 32.02 40 42098 AIR FILTER 2 _ 5.32 10.64 40 42222 AIR FILTER 1 15.64 15.64 40 42253 AIR FILTER 1 37.56 37.56 40 42276 AIR FILTER 2 14.49 28.98 40 42373 AIR FILTER 1 5.03 5.03 40 42769 AIR FILTER 1 15.66 15.66 40 42776 AIR FILTER 2 45.61 91.22 40 42297 AIR FILTER 1 6.00 6.00 40 42321 AIR FILTER 1 27.71 27.71 40 42714 AIR FILTER 1 3.88 3.88 40 42359 AIR FILTER 1 9.95 9.95 SHAKOPEE MASTER PARTS LISTING 02-25-2008 Page 2 CT PARTCODE VENDCODE PARTDESC LOCATION ONHAND EXPDATE LASTORD FROM AVGCOST VALUE 40 42725 AIR FILTER 1 15.57 15.57 40 42982 AIR FILTER 1 46.01. 46.01 40 46040 AIR FILTER 1 5.80 5.80 40 46048 AIR FILTER 1 4.63 4.63 40 46814 AIR FILTER 1 14.35 14.35 40 46077 AIR FILTER 2 7.13 14.26 40 46255 AIR FILTER 1 11.66 11.66 40 46084 AIR FILTER 1 5.48 5.48 40 46270 AIR FILTER 1 11.56 11.56 40 46117 AIR FILTER 1 9.23 9.23 40 46174 AIR FILTER 2 6.82 13.64 40 46418 AIR FILTER 2 12.79 25.58 40 46438 AIR FILTER 1 22'87 22'87 40 46440 AIR FILTER 3 13.79 41.37 40 46522 AIR FILTER 1 17.59 17.59 40 46452 AIR FILTER 2 25.96 51.92 40 46516 AIR FILTER 1 23.22 23.22 40 46635 AIR FILTER 1 30.55 30.55 40 46648 AIR FILTER 1 12.14 12.14 40 46036 AIR FILTER 1 5.06 5.06 40 46555 AIR FILTER 1 37.34 37.34 40 46664 AIR FILTER 3 45.61 136.83 40 46527 AIR FILTER 1 48.22 48.22 40 46562 AIR FILTER 1 28.74 28.74 40 49136 AIR FILTER 2 15.55 31.10 40 46556 AIR FILTER 1 57.07 57.07 40 46569 AIR FILTER 2 16.27 32.54 40 PR17-02262 AIR FILTER 0 12.02 0.00 40 7-02262 AIR FILTER 1 10.73 10.73 40 42323 AIR FILTER 1 6.91 6.91 40 46506 AIR FILTER 0 31.20 0.00 40 104.0860 AIR FILTER 1 0.00 0.00 40 7-07182 AIR FILTER 1 8.09 8.09 40 7-02297 AIR FILTER 1 2.14 2.14 40 46766 AIR FILTER 3 20.64 61.92 40 6598492 AIR FILTER BOBCAT 0 15.88 0.00 40 6681474 AIR FILTER BOBCAT 2 27.88 55.76 56 730-4855 ANTENNA 1 11.39 11.39 40 VC-7-B ANTI-FR 719565 13 2.74 35.62 40 55GAL ANTI-FREEZE 141 1.49 210.09 40 03695 ANTI-FRZ HAVOLINE 4 2.98 11.92 40 KK031 ANTIFRZ EXTENDER 11 13.29 146.19 30 782-5316 ATC FUSE BOX 6 15.95 95.70 SHAKOPEE MASTER PARTS LISTING 02-25-2008 Page 3 _ CT PARTCODE VENDCODE PARTDESC LOCATION ONHAND EXPDATE LASTORD FROM AVGCOST VALUE 30 73040 BACKUP ALARM 3 38.42 115.26 30 993478 BATTERY 6 126.24 757.44 18 204RY2 BEARINGS 12 17.19, 206.27 40 25-060908 BELT NBH SERP 0 26.00 0.00 30 10929-01539 BOSCH RELAY 0 4.37 0.00 13 MGM/3430008X BRAKE CAM SPRING 0 60.48 0.00 13 3430008X BRAKE CHAMBER 2 68.63 137.26 13.89746 BRAKE CNTRLR TRLR 1 175.76 175.76 13 BRSD-931 BRAKE PADS 4 52.10 208.40 13 BRSD-932 BRAKE PADS REAR 4 56.77 227.08 13 AS1140 BRAKE SLACK ADJ 2 86.19 172.38 57 ZBW-CW-8BR BROOM-BROCE 1 541.02 541.02 57 ZBW-CW-E-HD BROOM-ELGIN POLY 1 427.60 427.60 34 GELH1-55/BP BULB 1 5.64 5.64 30 HB6B BUTTON FOR HORN 1 4.56 4.56 30 m15412 CABLE #4 80 2.13 170.40 58 77-2990 CABLE THROTTLE 1 151.12 151.12 40 CAR-EGA-1 CARBIDE SHOES 0 224.72 0.00 30 BR330 CIRCUIT BREAKER 5 14.06 70.30 30 BR310 CIRCUIT BREAKER 1 14.30 14.30 30 BR305 CIRCUIT BREAKER 1 12.02 12.02 30 89737 CONNECTOR ELEC BRK 1 88.11 88.11 58 111.2863 CUTTER BAR FTAP74 0 3792.39 0.00 59 600-49251 CUTTINGEDGE9" WESTN 1 178.43 178.43 29 027791 CYLINDER FOR HYDRLC 1 126.66 126.66 40 EL-1004908-C DIRT SHOE W/CARPEG 0 34.08 0.00 34 44530 ELECTRIC FLASHER 2 16.57 33.14 40 755-1573 ELECTRICAL CONNECTR 1 4.25 4.25 40 69-1720 FILTER-ELEMENT 2 48.44 96.88 34 656101 FLASHER '05CRWN VIC 1 58.61 58.61 30 ETPPOOCG FLASHER (FRNT) 1 89.69 89.69 34 656101-06 FLASHER HDLGT'06CRN 1 59.19 59.19 34 ETQSFLEET FLASHER HDLT'03-'04 1 59.69 59.69 31 SL-SLEEVE FLSHLHT CHRGRSLEEVE 4 11.97 47.87 40 33031 FUEL FILTER 1 2.77 2.77 40 33120 FUEL FILTER 1 7.10 7.10 40 33032 FUEL FILTER 2 2.81 5.62 40 33166 FUEL FILTER 1 4.70 4.70 40 33338 FUEL FILTER 1 9.39 9.39 40 33192 FUEL FILTER 1 10.30 10.30 40 33097 FUEL FILTER 6 7.88 47.28 40 33218 FUEL FILTER 2 7.30 14.60 40 33046 FUEL FILTER 1 13.35 13.35 SHAKOPEE MASTER PARTS LISTING 02-25-2008 Page 4 CT PARTCODE VENDCODE PARTDESC LOCATION ONHAND EXPDATE LASTORD FROM AVGCOST VALUE FUEL FILTER 1 12.00 12.00 40 33405 4 6.86 27.44 40 33118 FUEL FILTER 7,43 7.43 40 33219 FUEL FILTER 1 FUEL FILTER 1 6.70 6.70 40 33358 1 6.53 6.53 40 33361 FUEL FILTER 7,03 7.03 40 33339 FUEL FILTER 1 FUEL FILTER 2 16.21 32.42 40 33376 1 7.34 7.34 40 33357 FUEL FILTER 1 10.28 10.28 40 33394 FUEL FILTER 2 21.18 42.36 40 33211 FUEL FILTER 3 3.15 9.45 40 33033 FUEL FILTER 25.61 25.61 40 33518 FUEL FILTER 1 FUEL FILTER 1 25.79 25.79 40 33217 1 9.15 9.15 40 33403 FUEL FILTER 6,27 6.27 40 33225 FUEL FILTER 1 FUEL FILTER 1 8.60 8.60 40 33233 1 6.26 6.26 40 33239 FUEL FILTER 24.13 72.39 40 33231 FUEL FILTER 3 FUEL FILTER 1 14.16 14.16 40 33532 2 13.07 26.14 40 33548 FUEL FILTER 27,33 27.33 40 33232 FUEL FILTER 1 FUEL FILTER 1 9.29 9.29 40 33472 2 6.50 13.00 40 33356 FUEL FILTER 7,g0 23.40 40 33595 FUEL FILTER 3 FUEL FILTER 1 2.30 2.30 40 33271 4 9.76 39.04 40 33481 FUEL FILTER 1 9.64 9.64 40 33626 FUEL FILTER 1 8.61 8.61 40 33365 FUEL FILTER 10.07 10.07 40 33366 FUEL FILTER 1 FUEL FILTER 1 8.65 8.65 40 33369 1 8,65 8.65 40 33377 FUEL FILTER g,06 8.06 40 33382 FUEL FILTER 1 FUEL FILTER 1 5.53 5,53 40 33386 1 8-82 8'82 40 33398 FUEL FILTER 8 8.96 71.65 40 24029 FUEL FILTER 1 7.15 7.15 40 33296 FUEL FILTER 34.86 209.14 40 60-5470 FUEL FILTER 6 FUEL FILTER 1 5.96 5.96 40 33507 3 12.53 37.58 40 ABPN12232FRT2 FUEL FILTER 33.49 33.49 40 FF5310 FUEL FILTER FLTGRD 1 FUEL FILTER KIT 3 50.36 151.09 40 3C3Z-9N184-CA 2 17.46 34.91 40 ABPN122R50423 FUEL FILTER PRIMARY 5,52 49.68 40 2-18469 FUEL INJECT CLNR 9 SHAKOPEE MASTER PARTS LISTING 02-25-2008 Page 5 - CT PARTCODE VENDCODE PARTDESC LOCATION ONHAND EXPDATE LASTORD FROM AVGCOST VALUE 30 782-1139 - FUSE 1 5.97 .5.97 30 782-1143 FUSE BLK 5 10.00 50.00 30 782-3205 FUSE BLOC 4 32.88 131.51 40 ET223 FUSE HOLD. 1 2.55 2.55 30 ET227 FUSE HOLD. 2 3.27 6.54 30 ET224 FUSE HOLDER ET224 2 2.55 5.09 42 TCS45996 GASKET (TIMING) 0 16.97 0.00 42 51813 GASKET MAKER ANAER. 0 14.28 0.00 30 PG-G4904R GUN LOCK HEAD 2 106.45 212.89 30 VP239 GUN LOCK TIMER 4 18.89 75.56 34 F8AZ-15350-AA HANDLE 1 52.64 52.64 34 ETHFSS-SPA HEADLIGHT FLASHER 1 60.07 60.07 40 N9086 HYD FILTER 0 85.66 0.00 40 57723 HYD FILTER 1 29.94 29.94 40 56D928934 HYDR.FILTER TT70/75 1 115.66 115.66 40 51614 HYDRAULIC FILTER 0 16.35 0.00 40 51553 HYDRO FILTER 2 5.07 10.14 40 51759 HYDRO FILTER 3 10.24 30.72 40 51858 HYDRO FILTER 1 18.53 18.53 40 HF0658700 HYDRO FILTER FLTGRD 1 70.77 70.77 29 101-1001 HYDRO SPINNER MOTOR 1 209.30 209.30 34 GEL9007 LAMP AUTO 0 7.67 0.00 34 BP1210/H3 LAMP FOR SPOTLIGHT 2 7.98 15.96 34 103654A1 LAMP HEAD 2 65.53 131.06 34 BP9007 LAMP HEAD HI/LO 0 6.40 0.00 30 1203A LAMP MARK LMP 3 7.97 23.91 34 9007 LAMP-HEADLAMP BULB 3 6.35 19.05 34 GEL H6054 LAMP-HEADLIGHT 0 10.49 0.00 34 50-60202R-3 LAMP-RED TAIL LIGHT 2 5.83 11.66 34 ABT-119000B LED DASH LIGHT-BLUE 4 104.03 416.12 34 ABT-119000R LED DASH LIGHT-RED 4 50.78 203.12 34 GEL H7600 LIGHT BULB-STANDARD 2 13.41 26.82 30 RSB02ZCR LIGHT-BLUE 0 69.14 0.00 34 H3-55 LIGHT-HALOGEN 0 5.64 0.00 40 R5R02ZCR LIGHT-RED 0 69.14 0.00 34 911-GAL48.MN LIGHTBAR GALXY48LED 0 1250.00 0.00 34 1-41228 LIGHTBAR UNIV MNT 0 115.35 0.00 34 50972 LIGHTFIX.3STUD COMB 1 20.70 20.70 40 981770 LUBE HD 80/90 195 1.17 228.15 40 63010 LUBEGARD TRANS ADDI 38 13.12 498.56 34 BP1255/H3 MINI LAMP 0 5.85 0.00 40 XT-6-QSP OIL ATF (FORD) 27 4.81 129.87 40 98HQ94 OIL CLEAN 10/30 895 1.64 1467.80 SHAKOPEE MASTER PARTS LISTING 02-25-2008 Page 6 CT PARTCODE VENDCODE PARTDESC LOCATION ONHAND EXPDATE LASTORD FROM AVGCOST VALUE 40 98HR03 OIL CLEAN 5/20 56 1.57 87.92 40 98HR05 OIL CLEAN 5/30 121 1.70 205.70 40 98JD32 OIL DELVAC 15/40 752 ~ 1.91 1436.32 45 F75Z-6730-BA OIL DRAIN PLUG 0 4.57 0.00 40 981018 OIL DTE 15M 407 2.23 907.61 40 98BK95 OIL EXXONXD-3 40WHT 100 1.87 187.00 40 51042 OIL FILTER 1 4.70 4.70 40 51064 OIL FILTER 1 5.78 5.78 40 51034 OIL FILTER 2 4.70 9.40 40 51068 OIL FILTER 3 4.02 12.06 40 51036 OIL FILTER 2 4.15 8.30 40 51069 OIL FILTER 1 4.15 4.15 40 51060 OIL FILTER 4 4.15 16.60 40 51084 OIL FILTER 1 6.79 6.79 40 51040 OIL FILTER 1 4.15 4.15 40 51061 OIL FILTER 2 4.15 8.30 40 51085 .OIL FILTER 1 4.27 4.27 40 51133 OIL FILTER 1 5.71 5.71 40 51261 OIL FILTER 2 4.88 9.76 40 51348 OIL FILTER 2 4.05 8.10 40 51290 OIL FILTER 1 25.33 25.33 40 51311 OIL FILTER 1 4.69 4.69 40 51243 OIL FILTER 1 4.59 4.59 40 51334 OIL FILTER 1 4.72 4.72 40 51372 OIL FILTER 2 4.41 8.82 40 51455 OIL FILTER 1 28.33 28.33 40 51482 OIL FILTER 1 26.52 26.52 40 51515 OIL FILTER 3 3.89 11.67 40 51394 OIL FILTER 1 4.63 4.63 40 51495 OIL FILTER 2 30.50 61.00 40 51516 OIL FILTER 0 4.15 0.00 40 51410 OTL FILTER 1 5.45 5.45 40 51521 OTL FILTER 2 5.14 10.28 40 51452 OTL FILTER 2 6.16 12.32 40 51506 OIL FILTER 1 7.25 7.25 40 51522 OTL FILTER 2 4.92 9.84 40 51523 OIL FILTER 1 8.05 8.05 40 51607 OIL FILTER 1 5.87 5.87 40 51742 OIL FILTER 1 8'88 8'88 40 51545 OIL FILTER 1 10.09 10.09 40 51611 OIL FILTER 1 10.47 10.47 40 51623 OIL FILTER 2 16.33 32.66 40 51747 OIL FILTER 3 12:07 36.21 SHAKOPEE MASTER PARTS LISTING 02-25-2008 Page 7 • CT PARTCODE VENDCODE PARTDESC LOCATION ONHAND EXPDATE LASTORD FROM AVGCOST VALUE 40 51551 OIL. FILTER 2 5.29 10.58 40 51630 OIL FILTER 1 3.61 3.61 40 51748 OIL FILTER 2 30.11 60.22 40 51663 OIL FILTER 2 6.67 13.34 4D 51749 OIL FILTER 2 17.02 34.04 40 51734- OIL FILTER 2 12.19 24.38 40 51754 OIL FILTER 4 8.78 35.12 40 51859 OIL. FILTER 1 31.71 31.71 40 57243 OIL. FILTER 1 10.01 10.01 40 51791 OIL FILTER 2 7.82 15.64 40 51970 OIL FILTER 3 .14.89 44.67 40 51798 OIL FILTER 1 8.92 8.92 40 51971 OIL FILTER 2 13.74 .27.48 40 51799 OIL FILTER 1 20.99 20.99 40 57099 OIL FILTER 0 5.22 0.00 40 51806 OIL FILTER 2 7.82 15.64 40 57106 OIL FILTER 1 8.20 8.20 40 51163 OIL FILTER 1 7.01 7.01 40 51414 OIL FILTER 1 30.13 30.13 40 51494 OIL FILTER 3 34.41 103.23 40 51586 OIL FILTER 1 15.65 15.65 40 51622 OIL FILTER 1 7.86 7.86 40 51758 OIL FILTER 1 9.11 9.11 40 51762 OIL FILTER 4 5.39 21.56 40 51794 OIL FILTER 1 8.53 8.53 40 57213 OIL FILTER 1 19.58 19.58 40 57314 OIL FILTER 0 16.58 0.00 40 57401 OIL FILTER 5 33.78 168.90 40 57521 OIL FILTER 1 21.09 21.09 40 57740XE OIL FILTER 1 65.63 65.63 40 58904 OIL FILTER 1 9.93 9.93 40 58918 OIL FILTER 1 10.62 10.62 40 58937 OIL FILTER 1 6.22 6.22 40 58956 OIL FILTER 1 13.58 13.58 40.58967 OIL FILTER 1 19.45 19.45 40 46247 OIL FILTER 1 12.83 12.83 40 57750 OIL FILTER l 11.34 11.34 40 FL820 OIL FILTER 45 3.23 145.35 40 110-6166 OIL FILTER 9 11.86 106.74 40 58897 OIL FILTER 0 10.98 0.00 40 3C3Z-6731-AA OIL FILTER 11 20.21 222.31 40 51335 OIL FILTER 1 5.22 5.22 40 57730 OIL FILTER 4 .6.31 25.23 SHAKOPEE MASTER PARTS LISTING 02-25-2008 Page 8 CT PARTCODE VENDCODE PARTDESC LOCATION ONHAND EXPDATE LASTORD FROM AVGCOST VALUE 40 51731 OIL FILTER 1 60.59 60.59 40 1R1807 OIL FILTER 4 13.42. 53.68 40 6675517 OIL FILTER BOBCAT 0 6.13 0.00 40 6678233 OIL FILTER BOBCAT 0 7.87 0.00 40 1R-1807 OIL FILTER CAT 2 12.69 25.38 40 98HE51 OIL MULTI-VEH ATF 276 1.43 394.68 51 755-1073 PIN-HITCHPIN 2 5.31 10.62 30 15-610 PLUG 0 4.57 0.00 31 L5078 REGULATOR 5078R 0 50.00 0.00 17 16RIM RIM 16" 0 20.00 0.00 40 SF16 SEAFOAM 31 5.72 177.32 51 LAG-3PCV99 SEAT-'92FRD CRWNVIC 0 437.26 0.00 58 100.4141 SHAFT CARDAN TT75 0 773.00 0.00 30 WH-BETA112R SIREN BETA 100W 0 186.32 0.00 30 WH-BETAl SIREN112 CNTRL HEAD 0 121.41 0.00 30 PG-PG701 SOLENOID 0 67.80 0.00 30 SS584T SOLENOID 2 25.99 51.98 45 SP-493 SPARK PLUG 237938 8 2.64 21.12 56 FS-DYNAMAX SPEAKER ASSBLYl00W 0 244.98 0.00 09 171610 SPRAY ON BEDLINER 0 330.00 0.00 34 ABT-111005SF STROBE FLASHER 3 22.09 66.27 34 10929-02145 STROBE LGHT PIGTAIL 1 30.28 30.28 30 SOS-ETUPOC.WP STROBE TUBE I 52.36 52.36 34 0718827 STROBEGRILLLGHTBLUE 1 0.00 0.00 34 0718822 STROBEGRILLLIGHTRED 1 0.00 0.00 34 SOS-ETUCOC STROBELGHT BULB CLR 2 42.95 85.90 30 DS194 SWITCH 1 9.83 9.83 01 12559575 THERMOSTAT 0 8.99 0.00 42 1038-ST THERMOSTAT GASKET 0 0.49 0.00 42 13359 THERMOSTAT USF 0 6.35 0.00 17 5198221 TIRE 22575R15RADTRL 1 84.35 84.35 17 25431 TIRE 23570R15 TERRA 0 94.27 0.00 17 25386 TIRE 24575R16 0 84.54 0.00 17 732-354-500 TIRE EAGLE RSA SUMR 0 80.98 0.00 17 21940 TIRE P19575R14 2 49.18 98.36 17 147-354-070 TIRE P225/60R16 WTR 0 99.35 0.00 17 166-579-530 TIRE P235/55R17 0 129.51 0.00 17 23584 TIRE225 75R15RADIAL 0 85.68 0.00 30 15-600 TRAILER PLUG-ELEC 2 6.85 13.69 40 TT16 TRANS ADDITIVE 28 5.73 160.44 40 58607 TRANS FILTER 1 13.64 13.64 40 58841 TRANS FILTER 3 13.56 40.68 40 58892 TRANS FILTER 1 35.05 35.05 SHAKOPEE MASTER PARTS LISTING 02-25-2008 Page 9 .t CT PARTCODE VENDCODE PARTDESC LOCATION ONHAND EXPDATE LASTORD FROM AVGCOST VALUE 40 58955 TRANS FILTER 1 14.55 14.55 40 58968 TRANS FILTER 1 21.14 21.14 40 58917 TRANS FILTER 1 15.78 15.78 40 58890 TRANS FILTER 0 13.34 0.00 40 3C3Z-7A098-AA TRANS FILTER 1 29.55 29.55 25 AM38891 UNIVRSL JNT-SNWBLR 1 170.40 170.40 40 24056 WATER FILTER 11 4.56 50.16 40 24070 WATER FILTER 1 7.93 7.93 40 24072 WATER FILTER 1 12.55 12.55 40 24073 WATER FILTER 1 15.72 15.72 40 24428 WATER FILTER 1 8.47 8.47 04 00001 WINGTUBE FRNTLARGE 1 392.15 392.15 04 00002 WINGTUBE SM.REAR 2 150.00 300.00 30 23488 WIRE-4 COND BONDED 600 0..82 494.14 357 observations Total 20167.90 ,u . NS STREET SIGNS STREET SIG Lyle Signs has been delivering street signs throughout the ~ nation since the 1920s. Making street signs is one of our core ~ ~ ~ Nether ou need 'ust street sin ~ manufacturing strengths. W y ~ g h, 4~ faces or finished double faced signs, give us a call. We will save ~ E,: ~ ~ F ~ ou time and move .Our ob'ective is to shi our street signs , y y ~ PY "`,a; 1 i within 5 to 7 days. ' ~ Sample Styles ~ n r nt i n CoI o )e s et S to S r g p T77e II~I1~'C'd~ arre~ ~III~U~I pr®pc~.sed t1aa~~~raar~al~ r de DG3 3M Diamond G a reflectpvrty.~tarldards rrrapact ®~z street.slgr~s. 3M I Iigh Intensity Prismatic Standard Colors ~ The 1997 MiJTCD Section 2d-39 set forth the Following minimums for White letters on green background I street signs on roads with speed limits in excess of 25 mph: tlae minimum White letters on blue back round ' ' ~ letter size~for street name signs of 6 " UC, 4 1/2 " LC and 3 "Abbreviations. g Black letters on white background All streetname signs are required to be reflective. The compliance date is I 1 Standard. Hei lets January 2012. The net result is most signs installed today should be 8" or g 9" in height to accommodate 6" letter series. 9" with G" main letters ' t ' Alternative: 8" plates f The expected final PHWA ruling on minimum reflectivity will indicate that G" plates are not recommended street signs/green series will need to have a minimum of a TYPI? III sheet- I - Substrates - ~ ing. The FHbVA proposes to eliminate Type I materzallorground-mounted GRAND AV 4 0 0 guide sign legends including street signs. Type III or higher would be re- .080 Alumh)Um Standard quired Agencies and officials would have until January 1, 2017, to bring 9" extruded dog bone ~ the identified street name signs and overhead guide signs into conformance with minimum reflectivity guidelines. - i ~ i i ~ Compliance period for adherence to minimum reflectivity for street signs cerupp~cC ~ _ may appear to be a few years away. I Iowever, planning to install prismatic I products today is a much better life cycle cost decision. ~ 911 Emer enc Si ns rkers Fire Ma g y g Lyle Signs offers a complete line of fire markers and 911 emer enc si ns. an example of the impact of g y 9 ~ sheeting type and plate size. ' ~ ~ , . a 1 Top: Diamond grade sheeting i , I ~ f ~ ` • ~ ~ ~ ! ~ Center: High intensity sheeting • B ttom. En ineer rade sheetin 0 • 9 9 9 ~ 1~ 'i~! LYLE ALS® SPECIALIZES IN RI~RAL AD®RESSING SIGNS, ~ i I I ~1~ 46'-2" tOUT TO OUT OF BRIDGE DECKI 1'-B" 9'-5" 12•_0• 12'-0" 9'-5" 1'-B° SHOULDER II SHOULDER 2" 1'-6 L~ CO. RD. 77 I -6" 2" PROFILE GRADE & CROWN 2% 1~ 5% 1.5% 2Y. wEST SIDE EAST SIDE INPLACE TRANSVERSE SECTION 46'-2" tOUT TO OUT OF BRIDGE DECK) 1'-B" 6'-0" 12'-0" 12'-0" 6'-0" t'-6" 6'-0" I'-0" SHOULDER SHOULDER BIKE TRAIL 2" 1'-6" 3'-5" ~ z ~ CO. RD. 77 o PROFILE GRADE I PROFILE GRADE ~ ~ z 2'/. V~ AR. 1~ 5% 1.5% VAR, yqR, 'e U WEST SIDE EAST SIDE PROPOSED TRANSVERSE SECTION <GREATER THAN 40 MPH) 46'-2" tOUT TO OUT OF BRIDGE DECK) 1'-B" 6'-0" 12•_0" 12'_0" 6'-O° B'-B° SHOULDER SHOULDER I 2" 1'-6" 3'-5" 7'-6" '-0 2" BIKE TRAIL i i ~W ~ U T. ~ ~ CO. RD. 77 - _ ° &m ~ PROFILE GRADE I PROFILE GRADE v 1% N 2« ~ VAR. 1.5% 1.5% vAR. 0 wEST SIDE EAST SIDE PROPOSED TRANSVERSE SECTION (LESS THAN 40 MPH) CERTIFIED BY TITLE: DES: DR: RWS APPROVED: PRfKE551t)NAI. ERCINEER PROPOSED CHK: CHK: res BRIDGE N0. REG. No. zo TRANSVERSE SECTION SHEET N0. 1 OF 1 SHEETS 70012 r., ~ ~ ~ { a ` ~~:w ~ e ~ " r"~, d'` ""w..~r<8 A .r;~~ -.,,wad ric~','~.~Yve` ! r~-z~,~ 1. y~ ~-S ~ C. ate.-~~= y~R~~ ~i k ~a ~ y ~ *"sa~ ~ ~ 'T .5, 'st Y ~ b',~ ,kA,~ ref' .3. t ~ ~ w~ ~ ~ x s* ~ 9 ~ a s 5 4 *?4e f ~ . ~ for e ~ . ag 'maw ~r.., . k` n . . ,.yyx xsk 4 ~ t ~ '~..,,,.,K ° ` k.{ v b"i a v, v . - w , e... max.:- E . ~ ~ g €N, ~ *t,~ ~ ~ ~ ~ b ~ w r , i ~ 1 ~ ~ ~ e =k ~ r ' -a ~•rv. c' § r fi3'' - ~ y,~ a n . a ~Y ,w . u, i e , r - ~ ~ t ?u a N x ~ ~ ' . Yq" .'F`y ~p W t _ v+~~~~m J C > ~ rn, ¢ r ~ 1f /7 CRS ~ N 1/~K-77 I7 7h~; r y -n o n ~r-~ ~r rr ri J/ /~n~ n 101 BRIDGE ' if P - r,_, IMPROVEMENTS ~ '1 '1 6p~ ATR`GNAL / ~ - - n n n N l/ I'ii' S. ?~1 L_ A aaa~ I f - - p dQO~Q°aa~ a oaQo f; as as c~ ~ ~ . , oQa~aaaoa~°a a~ as C!aa~ ~ Ca a ~flp~p aOQOQ~a ,5 as as Qcaaaa q a °°°aaa°~~aDaaaa ~ 2oae ~ ~ ~~a~0~ aaaaaaaaaaa ac~~aao~ ,e °~Y ~ aaaLJLJU 5 ~ ~~~~a~~ i ~ I ~ P RES~TORAH~ANON L i~ ~ f/ ~ Cy~°~rICtAI~ / ~ ~ ~ ~aaai.Jaa~~ 2009 CIPP ~ ~ (0'~ „ ~o „ ~~~FULLER ST MARKETPLACE DRAINAGE ~ r2 J V TRAIL ~ ~ ~ SWALE REHAB ~ ~ ~ ~ ~ ~ 11_/1 n ? ~ U~ ~ ~ t ~ ; a~ ~~o auU ~ \ J ~ WESTCHESTER i a ' ,w~~ ~ 11- f! PARK C~~ I(I~~~~ ~ ~ r~~ s Qa~ ~ ~ ~ ~ ~ ,e iB I a ~ C' ~aa~~~ ~ _U _1!_ BECKP.ICH \ ih SER~'R EXT Jr _ _rc-u a [r_ r,~ul a rJ ! P RESTORAT ONEL I h is ti /1 L! IJ _!l. t1 _.!1 11-J1~ tl__ J!_11 - Ll . 1! _ __J! 11 t -l l~ i6 z~ 2009 STREET IMPROVEMENT u X008 PROJECTS/I~[P~OVE~[ENTS ll f`"\ , ~ , . ~ , .~F . PROPOSED PUBLIC IMPROVEMENTS NT3