The URL can be used to link to this page

Home My WebLink About6.A. Fleet Management Fleet Controller Shakopee Public Works Presentation Designed by: Lisa J eurissen Presented by: Mike Hullander Bruce Loney Vehicles Using Fuel System Set-up Fleet in System. . Design Repair Order 2-part form for Mechanics . Enter Vehicle Numbers in Fleet to Track Fuel Usage . Build Divisions (City Depts.) . Build Vehicle & Equipment Type Codes . Build Category Codes (Maintenance Descrip) . Build Vendor List . Build Mechanic Name List . Build Stock Numbers for Parts . Research City Fleet Inventory (Gene) . Data Entry of Vehicle Details Vehicles & Equipment Division # of Vehicles # of Equipment Pieces (mowers, plows, attachments) Gov't Buildings 2 Engineering 7 Police/DrugTask Force 25/2-3 Building. Inspections 6 Administration 2 Street 18 80 . Park 9 71 Community Center 4 Fire Department 15 3 Stormwater 1 12 Sanitary Sewer 2 7 TOTALS 94 173 Vehicle Type Codes .... .. . .... .. .. . Trailers Category/Maintenance Codes Vendor List Mechanic Name/ Codes Stock Numbers for Parts . Vendor ite1ll nUlllber is used as the stock nUlIlber. . ItelIls received and prices per unit are entered into the Fleet software off of the vendor . . 1nVOices. . ItelIls issued are written on a Repair Order by the m.echanic for Lisa to enter in the Fleet software. Mechanic labor and outside labor costs are also entered into the syste1ll. Repair Order EQUIPMENT REPAIR ORDER Cep!:. city of Shal<opee Oala of Repairs Equipment # Vehicle Maintenance Dept. Vehicle Make Public Works Building Mmei\ge HC>lJF5 LABOR PARTS Mech Cat. Labw Invoice Part Unit COde COde Desuimion HOItlIrS # '# Descririli<m Qw Cost . . Mechanic CommentslNotes: Total Labor Hrs. Written Repair Order \~ EQUIPMENT REPAIR ORDER Nf! O{l72 Dept. 4?,", L ~c E City of Shakopee Daleo/Repairs. Equ"ment # D Of 3 Vehicle Maintenance Dept. {l"Y/o '7 . v..lIi<:I.. '''ake :i eo"" '-Ii ~1'.1V U ~ I: .. Publio Wcl1w Builc'ing ~ Mileage tf, -S- .2Z.. 3 . t) - "':Jura LAaQR PARTS Cal. Labor II'l~iea Vo:.ndor Part Unit Code -r.' ~Gril:'tion Hours # Code # OEJ$Ctiotkm Qlv Cost D . ,~..:'U~...-- em. , ;::i>1'iJ~ b-.r;:::7~ ..:/-?"2z-- _ 'f;'F.V~ t ... .19~... '... --,. _ Q3U,e 0.;"" .....: f.) .":.'"7".LA ;0" <.lIZ': 1./0 I,> o..;~,.., 7':?.....~<;; · L q )j{.fA:W A'l-r.<:;: --. /kf u <:::r,,~c' '75.2.-'-11. "':C,f dr'A/L. Y/ur:.. III v' ~.-O -~" '-/.~"- u _..... d P.. _.._ _ __ - .. i i , , Mechanic Commen1slNotes: Meohlllnia 10# /JIB , Total Labor HIS. lD ! I Print of Repair Order Entered SfI1\KOPEElDE'CAXLEDVElHIGLElHIS'CORY 01...04-2007 page 1 Sorted by; RONOMBl!:P' $e.leQ1;\,iqn C;pite;pia:RON 10072 On.ly l\lJ.. Status Codes ~exceptSQJ.,D P,ONIINV DATE VEHN G'CCQ~MEN'L'S I?ARTS$ LA.BOR$ 'C0'l'.A.lJ$ TI101EMECl:I 101EClIANIC/VENPOR .0.0'72 01103/07 0043 40pP,EVENTIV,E: MAIN'!' 16. 15 0.00 16.15 O.OQ.MQOO )?ARTS ONLY '0.072 ol/QaIQ'7 0043 110 ARM/ADDED.SQlI' lI'O 'CRANS .o.bU 65..0.0 6.5.00 1. 00101010 JE:tJRlSSENGENE (lOn 01/03/01 0043 4.5 ENGINE 4.57 0..00: 4.57 .0.00 MOaO PAR'CS ONLY 1 )';'$pa.ir:Or:Qer Repb:tt T:o.tal 20.72 65,..00 8.5.72 1.00 Written Repair Order ____._.,.... _________.___.,...__________.____ ____ __ - ___ ___ _.- ___ ______ ___.._. - ____._..____._ _..._ --'---'-0. __...._ EQUIPMENT REPAIR ORDER N~ 007t). Dept. 1'6 tt'C& City of Shakopee Dats Of Repairos EqUipment fI C> 'f. ~ Vahid9 Mafntenarlce Dept. ~/ y0~ Vehicle Make --?"o~ Cf~ U~ Public Works Ell.lildill9' Mileage :-z 1I ;0 Hcurs LABOR PARTS Cat. labor IfJlloice VerJdor Par1 Unit I Cede Descriclion Houns # Code # Dllscril)tlon Clt!l C4'.$t ! v. r>/}.... ....~ ~[) ~JuJ~ B...IT1lA Jo>' l'5- " 'Frs c-f::.. 99JV'7J' B" ~ "'"' I 30 'r ..~.A -t:&-<... r/. .... 8,.. T"1t ....t.::..... . FR ".... PK:I- .17" -... .~~ 4_ ~ , . ~^..o i-:I;;;- ~-J..~ d.. ~ ,:;:__ ~ ..- --".'''-' . . __A' ---.- .. - ;r-" 'ff -=&- f. .J'Jf ~"'lI"7':."":: .. ""E-='.<'"7":- K.RJM ~.'I. D ~-:" 'i."~ "J ( ~- ~&. .~.'.-oU.A. . I n lLl <'., I..' c~ ~ c-> v. <:tr.:. I 4' . -- 1-_..- .-. . .... .. .. ..-.- .--.-- -- Mechamic CommentslNoIes: MecharJic 10 l\I --. r':>/C'J Tolal Labor Hrs. ,t.Q u Print of Repair Order Entered SHAKOl?EE .OETAILEDVEt:lt.CLEnJ:STORX ():t-05-~OtJ7 Page 1 $.QJ::itea oy: EO NUMBER seLection Cr.iter.ia: RON. r Q()75 Only All Statu$Codss except SOLD ~ONt:rNV PAWE. VERN CT COMMENTS I?ART$$ LABOR $ TO.TAL$ TrME MeCH MECHANIG/VENDOR OQ75 .01104/07 0042 30 REPL REARBATTERX .AND..:. 89.;99 65...00 15.i!h 99 1;00 MP1Q JEURISSEN GENE 00'7'5 Ol/04/07 0042 30 PUT RE.AR.BATTE~t IN .FRNT O.OQ 32:.50 32.50' o ..sOM010 JEURI.S$EN GENE 0075 01.1tJ.41a7 Qa42 31 :BA'l'.T.ERX TE$TAND CHARGED Q "ao 3.2 . pO 3.2,50 .0.50 .MOIO JEUR1SSEN GENE 1. r.epair order ReportTQtal !39.:99 130.0'0 219.99 .2.00 Reports I Monthly hy Division (Example: Repair Orders on Police Vehicles) SliAKOE.EEPOLICE OE'l'J\.ILEDVEHICLE HrS'J.'ORY' Ol-O$-ZO()7 lta.ge :L $ortedby.: Uti I 'VEItH Select;,ionCrit.eria: UV t310nly DATE J:from !.lan3;,200''l to Janll,2001 Al1 $tqtu$Gog'es ~xC!ePt SOLD vEHN DV VTDESCRIpTION g042 31 04 SQUAD CAR 0'4 CRN VIC DATE CT ME'l'ER COMMENTS J;>AR'l'S$ !.A]30R$ TO'.CAt$ 'l'lME MEca MEGaANICIVE:NDOR RONI:CNV ' 01/04/07 30 79434 REE.I. ,REJ\.R BATTERY AND.. ". 89:.9,9 65:.00 154.99 l.OO MOIQ JEU:RI:SSEN GENE 0075 01104./07 30 7'9434 PUT REAR BATTERyrN FRNT 0.00 ,32.50 32.50 0.50 Mala .JEURISSEN GENE 0075 0110,4/07 31. 79434 BAT'l'ERY TES'l' AND CHARGED 0.00 S2.50 32.50 0.50'1'4010 J'EUR.ISSEN G:ENE 00.15 i repair orde.t1 vehicle 0042 Tota.l 89.99 130.,00 219,99 2,00 VEaN DV VT DESCRIPTION 0043' 31 o 4 SQUAD CJ\.R 04 CRN VIC DATE CT METER COMMENTS PARTS $ LABOR$ TOT1\1.$ TIME MECH MECHANIC/VENDOR RON/!'N"it b110'310'1 40 652'23 PREVENTIVE MAINT 16,15 0.00 16,15 0.0.0 M(lO.O J;>J\.RTSONLY 0072 01/0sI07 40 ~$.223 APMlADI)ED .5 QTTO TRANS 0.'00 tis.ao ti'5 .00 L 00 MOta JE:ORISSEN GENE 00'72 Ol/ns/O? 45 6522'3 :ENG:tNE 4..57 0...00' 4.57 0',,0'0' MOOO .E.AR'l'SONLY 00'72 1 :r~pa'irbtd,er veMcle0043 Total 20.72 65 ..O() 85.72 :1.0'0 .2 rep,a.irorders DivisionS! Total. llD..71 195.0.0 305.7:;l. 3,..00 .2 repa.;Lrorde.t1s Repo:rtTotal 110.'l1 HI5 .00 305.'11 3,00' Reports Reports · can be generated by: .L '--' ., Division (Depart1l1ent) Vehicle NU1l1ber Repair Order Ticket Nutnber Various reports can be generated to show the cost of repairs, parts, and fuel for each vehicle. Fleet Data Final Results . History of each vehicle for each departtnent is cotnpiled over tim.e. . History of a vehicle can be obtained on the c01llputer screen for the tnechanic to review. . . History of the vehicle provides information for selected reports. . Data provides tnanage1llent with the ability to 1lleasure overall fleet departtnent perfor1llance. .