The URL can be used to link to this page

Home My WebLink AboutAgenda Report - March 15, 2017 C-05TM CITY OF LODI COUNCIL COMMUNICATION AGENDA TITLE: MEETING DATE: PREPARED BY: AGENDA ITEM C5 Adopt Resolution Authorizing the City Manager to Accept a Donation from the Lodi Police PARTNERS' Foundation for the Purchase of a Vehicle and Appropriate Funds in the Amount of $20,988.62 March 15, 2017 Chief of Police RECOMMENDED ACTION: Adopt resolution authorizing the City Manager to accept a donation from the Lodi Police PARTNERS' Foundation for the purchase of a vehicle and appropriate funds in the amount of $20,988.62. BACKGROUND INFORMATION: The Lodi Police PARTNERS' Foundation, a California non- profit corporation, has donated several vehicles to the City for use in its Lodi Police PARTNERS' Program over the past several years. These vehicles are integral to the PARTNERS' Program of supporting the Lodi Police Department with volunteers, and Staff acknowledges the financial commitment the Foundation has made to the success of the program. Currently the City has four vehicles donated by the Foundation in its vehicle fleet, described as: 1. 2007 Ford Freestar, License No. 1359280, 2. 2008 Dodge Ram, License No. 1429579, 3. 2014 Chevy Equinox, License No. 1395160, and 4. 2015 Ford Transit Connect Wagon XLT, License No. 1444419 The 2007 Ford Freestar has logged over 107,470 miles and has cost the City a total of nearly $29,000 to maintain since the date of purchase in 2010. Due to the Freestar's age, costly maintenance and years in service, the Foundation determined it was in need of replacement. The Foundation reviewed several vehicles that would effectively replace the Ford Freestar and found the 2016 Ford Transit Connect would meet the needs of the PARTNERS Program and the Lodi Police Department. Staff requests Council accept the cash donation of $20,988.62 from the Lodi Police PARTNERS' Foundation to purchase a 2016 Ford Transit Connect to replace the 2007 Ford Freestar. Pursuant to Resolution 2015-54, the City will, upon retirement from the City's fleet, forward the proceeds from the sale or auction thereof made payable to the Lodi Police PARTNERS' Foundation, or alternatively, title to the retired 2007 Ford Freestar will be transferred to the Lodi Police PARTNERS' Foundation, to facilitate the Foundation's continued financial support of the Lodi Police PARTNERS' Program. Adopt Resolution Authorizing the City Manager to Accept a Donation from the Lodi Police PARTNERS' Foundation for the Purchase of a Vehicle and Appropriate Funds in the Amount of $20,988.62 March 15, 2017 Page Two FISCAL IMPACT: Donation of $20,988.62 to be received in the Donations Account (40300000.57702) FUNDING AVAILABLE: Vehicle Replacement Fund (40399100.77040) /Cal usan Bjork Supervising Budget Analyst Tod Patterson Chief of Police Prepared by: Jennelle Baker, Management Analyst Cc: Randy Laney, Fleet Services Supervisor Attachments 2016 Ford Transit Connect Standard Features • Fuel Consumption: City: 19 mpg • Fuel Consumption: Highway: 27 mpg • Remote power door locks • Power windows • Cruise controls on steering wheel • Cruise control • 4 -wheel ABS Brakes • Front Ventilated disc brakes • 1st, 2nd and 3rd row head airbags • Passenger Airbag • Side airbag • Rear air conditioning with separate controls • Buckets Third Row Seat • Digital Audio Input • In -Dash single CD player • MP3 player • AM/FM stereo • Radio Data System • Speed Sensitive Audio Volume Control • Total Number of Speakers: 4 • Braking Assist • ABS and Driveline Traction Control • Stability control with anti -roll control • Privacy glass: Deep • Wheel Diameter: 16 • Wheel Width: 6.5 • Front fog/driving lights • Urethane steering wheel trim • Urethane shift knob trim • Video Monitor Location: Front • External temperature display • Tachometer • Manufacturer's 0-60mph acceleration time (seconds): 9.7 s • Power remote driver mirror adjustment • Heated driver mirror • Heated passenger mirror • Power remote passenger mirror adjustment • Dual vanity mirrors • Rear heat ducts with separate controls • Audio controls on steering wheel • Front reading lights • Cloth seat upholstery • Bucket front seats • Split rear bench • Fold forward seatback rear seats • Rear seats center armrest • Tilt and telescopic steering wheel • Electric power steering • Suspension class: Regular • Manual front air conditioning • Tire Pressure Monitoring System • Exterior entry lights • Cargo area light • Max cargo capacity: 104 cu.ft. • Vehicle Emissions: SULEV II • Fuel Type: Regular unleaded • Fuel Capacity: 15.8 gal. • Instrumentation: Low fuel level • Clock: In -radio display • Coil front spring • Regular front stabilizer bar • Independent front suspension classification • Strut front suspension • Front Independent Suspension • Coil rear spring • Rear Stabilizer Bar: Regular • Semi-independent rear suspension • Torsion beam rear suspension • Front and rear suspension stabilizer bars • Variable intermittent front wipers • Steel spare wheel rim • Spare Tire Mount Location: Underbody w/crankdown • Gray grille • Center Console: Full with storage 4 DATE: 10/11/2016 TIME: 10:00 a.m. STARTING VMRS CODE: 000-000-000 ENDING VMRS CODE: 999-999-999 CITY OF LODI, CA ID: 1-32/RRV PAGE: VEHICLE REPAIR HISTORY REPORT FACILITY: 00001 DATE: FIRST DATE: LAST VEHICLE: 05-109 VEHICLE: 05-109 UNIT: 05-109 LF MTR: 107470.0 CUR MTR: 107470.0 YR: 07 MAKE: FORD DEPT: 10032000 SIZE: M CLASS: VAN6 FUEL: U VMRS CODE DATE WO NUM LF -MILS ODOM WORK DESCRIPTION OUT PARTS 001 TITLE > HEAT & AIR CONDITION 001-002-000 08172016 0026918 106110 001-004-000 08042016 0026918 105720 001-004-000 07272016 0026862 105710 001-004-000 10122015 0025158 98330 001-004-000 10092015 0025143 98330 001-004-000 09242015 0025005 98320 001-005-000 08172016 0026918 106110 001 TOTAL >HEAT & AIR CONDITION 002 TITLE > BODY AND GLASS 002-000-000--06042015---0024489 95290 002-000-000 08252011 0017213 57320 002-005-000 05222015 0024437 95290 002 TOTAL >BODY AND GLASS 003 TITLE > ELEC,INSTRM,LIGHT&CH 003-001-000 06222015 0024585 95380 003-003-000 08242016 0026918 106220 003-003-000 11282011 0017754 59680 003-004-000 09062016 0026918 106530 003-004-000 07282016 0026892 105720 003-004-000 12102015 0025525 99940 003-005-000 11292011 0017766 59880 003-008-000 10092015 0025124 98330 003-008-000 06152015 0024441 95380 003-008-000 06032015 0024441 95290 003-008-000 05012013 0020271 73530 003-008-000 04252013 0020247 73530 003-011-000 04272011 0016498 54520 003 TOTAL >ELEC,INSTRM,LIGHT&CH 004 TITLE > BATTERY, CHRG & STAR 004-001-000 11102010 0015241 50200 004-002-000 01222015 0023695 92160 004 TOTAL >BATTERY, CHRG & STAR 106106 BLOWER MOTOR & FAN OUT 105718 SERV A/C SYS (EVAC/R 105718 SERV A/C SYS (EVAC/R 98332 SERV A/C SYS (EVAC/R 98332 SERV A/C SYS (EVAC/R 98315 SERV A/C SYS (EVAC/R 106106 COMPRESS/CLUTCH- REP OUT 95286 -BODY -AND -GLASS- -- 57321 BODY AND GLASS 95286 WINDOW/RELATED PARTS 95384 ALL INSTRM & RELT PA 106216 ALL LIGHTS/SWTICHES/ 59682 ALL LIGHTS/SWTICHES/ 106526 WIPER/WASH/RELATED P OUT 105718 WIPER/WASH/RELATED P 99944 WIPER/WASH/RELATED P 59881 WIRING/FUSE - REPLAC 98332 DIST/S PLG/WIRE, NEW OUT 95384 DIST/S PLG/WIRE, NEW OUT 95286 DIST/S PLG/WIRE, NEW OUT 73533 DIST/S PLG/WIRE, NEW OUT 73533 DIST/S PLG/WIRE, NEW OUT 54520 LENS COVER - REPLACE 50204 TEST CHRG/START/BATT 92156 BATTERY - REPLACE 005 TITLE > COOLING 005-006-000 09292015 0025071 98320 98315 WATER PUMP LABOR 270.97 0.00 10.30 366.01 0.00 6.56 0.00 259.96 0.00 91.97 10.52 0.00 266.90 0.00 558.69 724.50 TOTAL HOURS MECHANIC CC RC WA 270.97 376.31 6.56 259.96 91.97 10.52 266.90 1283.19 7.54- 20.64 28.19 0.00 113.55 113.55 0.00 242.13 242.13 7.54 376.32 383.86 0.00 122.00 122.00 0.00 11.26 11.26 0.00 25.33 25.33 7.99 0.00 7.99 3.81 0.00 3.81 4.12 0.00 4.12 0.00 37.54 37.54 190.47 0.00 190.47 62.05 0.00 62.05 45.80 0.00 45.80 4.31 0.00 4.31 60.63 0.00 60.63 0.00 6.56 6.56 379.18 202.69 581.87 0.00 102.90 102.90 0.00 3.90 MV 0.07 MV 2.77 JT 0.98 JT 0.00 0.00 0.22 TN 1.21 JT 2.58 LR 1.30 JT 0.12 JR 0.27 JT 0.00 0.00 MV 0.00 0.40 JT 0.00 0.00 0.00 0.00 0.00 0.07 CM 146.40 146.40 1.56 KG 59.12 162.02 0.63 JR 205.52 308.42 OUT 104.40 0.00 01 1 XX 01 1 XX 01 1 XX 01 4 XX 01 1 XX 01 1 XX 01 1 XX XX 1 XX 01 1 XX 01 4 XX 01 1 XX 01 1 XX 01 4 XX 01 1 xx 01 1 XX 01 1 XX 01 1 XX 01 1 XX 01 4 XX 01 4 XX 01 4 XX 01 1 XX XX 8 XX 01 1 XX XX 1 XX 104.40 0.00 01 4 XX DATE: 10/11/2016 TIME: 10:00 a.m. STARTING VMRS CODE: 000-000-000 ENDING VMRS CODE: 999-999-999 CITY OF LODI, CA VEHICLE REPAIR HISTORY REPORT FACILITY: 00001 DATE: FIRST DATE: LAST ID: 1-32/RRV PAGE: 2 VEHICLE:: 05-109 VEHICLE: 05-109 UNIT: 05-109 LF MTR: 107470.0 CUR MTR: 107470.0 YR: 07 MAKE: FORD DEPT: 10032000 SIZE: M CLASS: VAN6 FUEL: U VMRS CODE DATE WO NUM LF -MILS ODOM WORK DESCRIPTION OUT PARTS 005-009-000 06032015 0024441 95290 005-009-000 06022015 0024441 95290 005-009-000 02062013 0019881 71420 005-010-000 08042016 0026918 105720 005-010-000 07272016 0026862 105720 005 TOTAL >COOLING 007 TITLE > TRANS(MAIN/AUX) PTO/ 007-004-000 08122016 0026892 106010 007-004-000 07282016 0026892 105720 007-004-000 07282016 0026892 105720 007 TOTAL >TRANS(MAIN/AUX) PTO/ 008 TITLE > EMISSION CONTROL 008-005-000 05102013 0020271 73710 008-011-000 09082016 0026918 106740 008-011-000 08292016 0026918 106400 008-011-000 07022014 0022362 86550 008-011-000 06252014 0022362 86550 008 TOTAL >EMISSION CONTROL 010 TITLE > ENGINE 010-001-000 07282016 0026892 105720 010-001-000 01242011 0015810 51650 010-006-000 07032014 0022362 010-008-000 10012015 0025071 010-008-000 10062015 0025071 010-008-000 06302015 0024621 010-008-000 12232010 0015540 010 TOTAL >ENGINE 86550 98320 98320 96800 50850 011 TITLE > TIRES AND WHEELS 011-001-000 06302015 0024621 96800 011-001-000 06222015 0024585 95380 011-001-000 01022015 0023591 91830 011-001-000 11132014 0023361 90200 011-002-000 07132016 0026794 105460 011-002-000 04052016 0026265 102800 95286 ANTI -FREEZE LEAK OUT 95286 ANTI -FREEZE LEAK 71423 ANTI -FREEZE LEAK 105718 OVER HEATING PROBLEM 105718 OVER HEATING PROBLEM 106006 TRANS - OTHER REPAIR OUT 105718 TRANS - OTHER REPAIR 105718 TRANS - OTHER REPAIR 73719 ON BOARD ECM/SENSOR/ 106742 SMOG CHECK/CERTIFICA OUT 106398 SMOG CHECK/CERTIFICA 86550 SMOG CHECK/CERTIFICA OUT 86550 SMOG CHECK/CERTIFICA 105718 ENGINE - REPAIR 51649 ENGINE - REPAIR 86550 ENGINE MOUNT(S) - RE OUT 98315 OIL LEAK - INSPECT/R OUT 98315 OIL LEAK - INSPECT/R 96801 OIL LEAK - INSPECT/R 50851 OIL LEAK - INSPECT/R 96801 TIRES - BALANCE 95384 TIRES - BALANCE 91832 TIRES - BALANCE 90200 TIRES - BALANCE 105460 TIRE(S) - REPAIR/ROT 102799 TIRE(S) - REPAIR/ROT LABOR TOTAL HOURS MECHANIC CC RC WA 156.61 0.00 156.61 29.15 372.58 401.73 0.00 84.46 84.46 26.93 202.71 229.64 0.00 193.33 193.33 317.09 853.08 1170.17 65.01 0.00 65.01 0.00 329.41 329.41 0.00 114.49 114.49 65.01 443.90 508.91 0.00 638.18 638.18 35.00 0.00 35.00 0.00 105.11 105.11 0.00 25.00 25.00 0.00 175.49 175.49 35.00 943.78 978.78 0.00 0.00 0.00 0.00 228.05 228.05 201.46 0.00 201.46 292.39 0.00 292.39 55.85 2820.19 2876.04 21.73 566.85 588.59 18.22 585.62 603.84 589.65 4200.71 4790.36 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 76.95 76.95 0.00 79.77 79.77 0.00 3.97 MV 0.90 JR 2.16 MV 2.06 MV 0.00 3.51 MV 1.22 MV 6.80 CMc 0.00 1.12 LR 0.00 1.87 LR 0.00 MV 2.43 MV 0.00 0.00 30.05 MV 6.04 MV 6.24 CMc 0.00 0.00 0.00 0.00 0.82 JT 0.85 JR 01 4 XX 01 4 XX XX 1 xx 01 1 xx 01 1 XX 01 1 XX XX 1 XX 01 1 xx 01 4 XX 01 1 XX 01 1 XX 01 4 XX 01 4 XX xx 1 xx 01 1 XX 01 4 XX 01 4 XX 01 4 XX 01 4 XX 01 4 XX 01 4 XX 01 1 XX 01 1 xx 01 1 xx 01 1 XX 01 1 XX DATE: 10/11/2016 TIME: 10:00 a.m. STARTING VMRS CODE: 000-000-000 ENDING VMRS CODE: 999-999-999 CITY OF LODI, CA VEHICLE REPAIR HISTORY REPORT FACILITY: 00001 DATE: FIRST DATE: LAST ID: 1-32/RRV PAGE: 3 VEHICLE:: 05-109 VEHICLE: 05-109 UNIT: 05-109 LF MTR: 107470.0 CUR MTR: 107470.0 YR: 07 MAKE: FORD DEPT: 10032000 SIZE: M CLASS: VAN6 FUEL: U VMRS CODE DATE WO NUM LF -MILS ODOM WORK DESCRIPTION OUT PARTS 011-002-000 01052016 0025638 011-002-000 07012015 0024621 011-002-000 06222015 0024585 011-002-000 02272015 0023909 011-002-000 01022015 0023591 011-002-000 11132014 0023361 011-002-000 11062013 0021206 011-002-000 05082013 0020310 011-002-000 02062013 0019881 011-002-000 07052012 0018827 011-003-000 07162015 0024621 011-003-000 06302015 0024621 011-003-000 04252014 0021206 011-003-000-09302013 0021015 011-003-000 09302013 0021015 011-003-000 07162012 0018761 011-003-000 07052012 0018827 011-003-000 04242012 0018444 011-003-000 02042011 0015864 011-003-000 01312011 0015864 011-004-000 01022015 0023591 011-004-000 05022013 0020271 011 TOTAL >TIRES AND WHEELS 012 TITLE > DRIVE TRAIN 012-001-000 12232010 0015540 012-003-000 12232010 0015540 012-004-000 12222010 0015540 012-004-000 12202010 0015540 012 TOTAL >DRIVE TRAIN 013 TITLE > BRAKES 013-001-000 06252014 0022362 013-002-000 10272015 0025124 013-002-000 10072015 0025124 013-009-000 06222015 0024585 013-009-000 07012014 0022362 013 TOTAL >BRAKES 100360 96800 95380 93190 91830 90300 79150 73640 71250 64990 96800 96800 82640 78350 78350 65220 64990 63080 51920 51880 91830 73530 100363 TIRE(S) 96801 TIRE(S) 95384 TIRE(S) 93193 TIRE(S) 91832 TIRE(S) 90307 TIRE(S) 79147 TIRE(S) 73635 TIRE(S) 71250 TIRE(S) 64993 TIRE(S) 96801 TIRE(S) 96801 TIRE(S) - REPAIR/ROT - REPAIR/ROT - REPAIR/ROT - REPAIR/ROT - REPAIR/ROT - REPAIR/ROT - REPAIR/ROT - REPAIR/ROT - REPAIR/ROT - REPAIR/ROT - REPLACE OUT - REPLACE 82640 TIRE(S) - REPLACE OUT 78350 TIRE(S) REPLACE 78350 TIRE(S) - REPLACE OUT 65222 TIRE(S) - REPLACE OUT 64993 TIRE(S) - REPLACE 63075 TIRE(S) - REPLACE OUT 51922 TIRE(S) - REPLACE OUT 51883 TIRE(S) - REPLACE 91832 WHEEL - REPAIR/REPLA 73533 WHEEL - REPAIR/REPLA OUT 50850 50851 R AXLE SHAFT/SEALS/B 50850 50851 DRIVE LINE - REPAIR/ 50850 50851 UNIV JOINT/CV JOINT/ OUT 50600 50604 UNIV JOINT/CV JOINT/ 86550 86550 BRAKE SHOES/PADS -RE OUT 98660 98657 DRUMS/ROTORS - REPLA OUT 98320 98315 DRUMS/ROTORS - REPLA 95380 95384 BRAKE(S) - OTHER SER 86550 86550 BRAKE(S) - OTHER SER 014 TITLE > SPECIAL EQUIPMENT 014-001-000 06042015 0024489 95290 95286 EMERGENCY LIGHTING 0.00 0.00 0.00 0.00 0.00 0.00 117.98 0.00 0.00 0.00 358.09 0.00 120.95 0.00 100.55 200.64 0.00 100.32 80.07 0.00 34.06 82.30 1194.96 0.00 0.00 114.17 0.00 114.17 66.51 90.10 0.00 0.00 0.00 156.61 LABOR 119.18 192.39 0.00 284.36 0.00 180.19 157.66 62.87 150.15 79.77 0.00 0.00 0.00 70.38 0.00 0.00 86.34 0.00 0.00 73.20 0.00 0.00 1613.21 0.00 46.92 0.00 335.98 382.90 0.00 0.00 771.44 0.00 930.05 1701.49 0.00 35.66 TOTAL HOURS MECHANIC CC RC WA 119.18 192.39 0.00 284.36 0.00 180.19 275.65 62.87 150.15 79.77 358.09 0.00 120.95 70.38 100.55 200.64 86.34 100.32 80.07 73.20 34.06 82.30 2808.17 0.00 46.92 114.17 335.98 497.07 66.51 90.10 771.44 0.00 930.05 1858.10 1.27 JT 2.05 JT 0.00 3.03 JR 0.00 1.92 JT 1.68 JR 0.67 JR 1.60 JR 0.85 CM 0.00 0.00 0.00 0.75 JR 0.00 0.00 0.92 CM 0.00 0.00 0.78 JR 0.00 0.00 0.00 CMc 0.50 CMc 0.00 3.58 KG 0.00 0.00 8.22 MV 0.00 9.91 JW 01 1 01 4 01 1 01 1 01 1 01 1 XX 8 01 1 XX 1 01 4 01 4 01 4 01 8 01 1 01 1 01 8 XX 4 01 1 01 1 01 1 01 1 01 4 xx XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX 4 XX 01 4 XX 01 4 XX 01 4 xx 01 4 XX 01 1 XX 01 1 XX 01 1 XX 01 4 XX 35.66 0.38 TN 01 1 XX DATE: 10/11/2016 TIME: 10:00 a.m. STARTING VMRS CODE: 000-000-000 ENDING VMRS CODE: 999-999-999 CITY OF LODI, CA VEHICLE REPAIR HISTORY REPORT FACILITY: 00001 DATE: FIRST DATE: LAST ID: 1-32/RRV PAGE: 4 VEHICLE:: 05-109 VEHICLE: 05-109 UNIT: 05-109 LF MTR: 107470.0 CUR MTR: 107470.0 YR: 07 MAKE: FORD DEPT: 10032000 SIZE: M CLASS: VAN6 FUEL: U VMRS CODE DATE WO NUM LF -MILS ODOM WORK DESCRIPTION OUT PARTS LABOR TOTAL HOURS MECHANIC CC RC WA 014-001-000 01262015 0023695 92220 92216 EMERGENCY LIGHTING OUT 2.69 0.00 2.69 0.00 01 1 XX 014-001-000 01222015 0023695 92210 92216 EMERGENCY LIGHTING 0.00 2642.81 2642.81 28.16 TN 01 1 XX 014-001-000 12082014 0023106 90660 90657 EMERGENCY LIGHTING OUT 111.82 125.00 236.82 0.00 01 1 XX 014-001-000 11202014 0023361 90420 90418 EMERGENCY LIGHTING OUT 1149.20 0.00 1149.20 0.00 01 1 XX 014-001-000 10022014 0023106 89250 89250 EMERGENCY LIGHTING 0.00 191.45 191.45 2.04 TN 01 1 XX 014-001-000 03142014 0021916 82460 82461 EMERGENCY LIGHTING OUT 8.19 0.00 8.19 0.00 01 1 XX 014-001-000 03172014 0021916 82540 82542 EMERGENCY LIGHTING 2.60 421.38 423.98 4.49 JW 01 1 XX 014-001-000 12132011 0017811 60060 60062 EMERGENCY LIGHTING 0.00 510.54 510.54 5.44 CMc 01 8 XX 014-001-000 04152011 0016429 54010 54014 EMERGENCY LIGHTING 0.00 75.08 75.08 0.80 LR 01 4 XX 014 TOTAL >SPECIAL EQUIPMENT 1274.50 4001.92 5276.42 019 TITLE > MISCELLANEOUS 019-001-000 08042016 0026918 105720 105718 ROAD TEST / DIAGNOSI 0.00 37.53 37.53 0.40 MV 01 1 XX 019-001-00001052016 0025638 100360 100363 ROAD TEST /DIAGNOSI 0.00 0.00 0.00 0.00 01 1 XX 019-001-000 06302015 0024621 96800 96801 ROAD TEST / DIAGNOSI 0.00 0.00 0.00 0.00 01 4 XX 019-001-000 06222015 0024585 95380 95384 ROAD TEST / DIAGNOSI 0.00 0.00 0.00 0.00 01 1 XX 019-001-000 01022015 0023591 91830 91832 ROAD TEST / DIAGNOSI 0.00 0.00 0.00 0.00 01 1 XX 019-001-000 11132014 0023361 90200 90200 ROAD TEST / DIAGNOSI 0.00 0.00 0.00 0.00 01 1 XX 019-001-000 01272011 0015832 51650 51649 ROAD TEST / DIAGNOSI 0.00 262.77 262.77 2.80 MV 01 4 XX 019-002-000 06132016 0026621 104680 104683 SERVICE CALL 0.00 237.44 237.44 2.53 LR 01 1 XX 019-002-000 06132016 0026621 104680 104683 SERVICE CALL 0.00 114.49 114.49 1.22 JT 01 1 XX 019-002-000 12302015 0025613 100240 100235 SERVICE CALL 0.00 153.91 153.91 1.64 MV 01 1 XX 019-002-000 09242015 0025005 98320 98315 SERVICE CALL 0.00 240.25 240.25 2.56 LR 01 1 XX 019-002-000 01022015 0023591 91830 91832 SERVICE CALL 0.00 244.00 244.00 2.60 JT 01 1 XX 019-002-000 01022015 0023591 91830 91832 SERVICE CALL 0.00 0.00 0.00 0.00 TN 01 1 XX 019-002-000 04282014 0022166 82640 82640 SERVICE CALL 0.00 39.41 39.41 0.42 MV 01 10 XX 019-002-000 05012014 0022166 82640 82640 SERVICE CALL 0.00 266.53 266.53 2.84 LR 01 10 XX 019-002-000 04252012 0018444 63160 63159 SERVICE CALL 0.00 131.39 131.39 1.40 CMc 01 1 XX 019-002-000 05012012 0018444 63150 63159 SERVICE CALL 0.00 128.57 128.57 1.37 LR 01 1 XX 019-002-000 05102011 0016520 54520 54520 SERVICE CALL 0.00 166.11 166.11 1.77 CMc 01 1 XX 019-002-000 05022011 0016520 54520 54520 SERVICE CALL 0.00 150.16 150.16 1.60 LR 01 1 XX 019-002-000 01312011 0015864 51650 51649 SERVICE CALL 0.00 0.00 0.00 0.00 MV 01 1 XX 019-002-000 02082011 0015864 52000 52006 SERVICE CALL 0.00 125.75 125.75 1.34 LR 01 1 XX 019-004-000 11122010 0015241 50200 50204 NEW VEH PREP/INSPECT 6.31 1114.93 1121.25 11.88 KG 01 1 XX 019-004-000 11112010 0015241 50200 50204 NEW VEH PREP/INSPECT 0.00 885.00 885.00 9.43 CM 01 1 XX 019-005-000 06302015 0024621 96800 96801 STEAM CLEAN 0.00 0.00 0.00 0.00 01 4 XX 019-010-000 10272015 0025124 98660 98657 MISCELLANEOUS OUT 55.10 0.00 55.10 0.00 01 1 XX 019-010-000 09242015 0025005 98320 98315 MISCELLANEOUS 0.00 0.00 0.00 0.00 01 1 XX DATE: 10/11/2016 TIME: 10:00 a.m. STARTING VMRS CODE: 000-000-000 ENDING VMRS CODE: 999-999-999 CITY OF LODI, CA VEHICLE REPAIR HISTORY REPORT FACILITY: 00001 DATE: FIRST DATE: LAST ID: 1-32/RRV PAGE: 5 VEHICLE:: 05-109 VEHICLE: 05-109 UNIT: 05-109 LF MTR: 107470.0 CUR MTR: 107470.0 YR: 07 MAKE: FORD DEPT: 10032000 SIZE: M CLASS: VAN6 FUEL: U VMRS CODE DATE WO NUM LF -MILS ODOM WORK DESCRIPTION OUT PARTS LABOR TOTAL HOURS MECHANIC CC RC WA 019-010-000 07012015 0024585 96800 96801 MISCELLANEOUS OUT 019-010-000 06222015 0024585 95380 95384 MISCELLANEOUS 019-010-000 04272011 0016498 54370 54370 MISCELLANEOUS 019-010-000 11172010 0015241 50200 50204 MISCELLANEOUS OUT 019-010-000 11052010 0015241 50200 50204 MISCELLANEOUS 019-012-000 09232015 0025005 98200 98199 FIRE EXT - REMOVE/RE 019-013-000 11112010 0015241 50200 50204 DECALS - REMOVE/APPL 019-014-000 11132013 0021206 79150 79147 P U/DEL VEH TO COMM 019-014-000 11132013 0021206 79150 79147 P U/DEL VEH TO COMM 019-014-000 11122013 0021206 79150 79147 P U/DEL VEH TO COMM 019-015-000 11062013 0021206 79150 79147 ALL BELTS - REPL/ADJ 019-015-000 11062013 0021206 79150 79147 ALL BELTS - REPL/ADJ OUT 019 TOTAL >MISCELLANEOUS 55.10 0.00 0.00 0.00 0.00 1.87 11.80 0.00 0.00 0.00 0.00 0.00 0.00 343.49 0.00 91.97 0.00 106.98 0.00 469.24 0.00 212.10 30.61 0.00 158.92 5523.89 55.10 0.00 0.00 0.00 1.87 0.02 CM 11.80 0.00 0.00 0.00 CM 0.00 0.00 343.49 3.66 CM 91.97 0.98 MV 106.98 1.14 JT 469.24 5.00 MV 212.10 2.26 JR 30.61 0.00 5682.81 O1 1 XX 01 1 XX XX 8 XX 01 1 XX XX 1 XX 01 1 xx xx 1 xx 01 8 XX 01 8 XX O1 8 XX XX 8 XX 01 8 XX 020 TITLE > FILTERS 020-001-000 09232015 0025005 98200 98199 AIR FILTER - REPLACE 7.16 0.00 7.16 0.00 01 1 XX 020-001-000 12082011 0017811 60060 60062 AIR FILTER - REPLACE 0.00 0.00 0.00 0.00 JT XX 8 XX 020-001-000 04272011 0016498 54520 54520 AIR FILTER - REPLACE 0.00 0.00 0.00 0.00 CM XX 8 XX 020-001-000 04272011 0016498 54370 54370 AIR FILTER - REPLACE OUT 6.97 0.00 6.97 0.00 01 8 XX 020-001-000 11082010 0015241 50200 50204 AIR FILTER - REPLACE OUT 8.70 0.00 8.70 0.00 01 1 XX 020-001-000 11042010 0015241 0 0 AIR FILTER - REPLACE 0.00 4.69 4.69 0.05 CM XX 1 XX 020-003-000 04252013 0020247 73530 73533 FUEL FILTER - REPLAC OUT 17.79 0.00 17.79 0.00 01 1 XX 020 TOTAL >FILTERS 40.62 4.69 45.31 066 TITLE > PREVENTATIVE MAINTEN 066-001-000 06142016 0026627 104720 104725 PM A SERVICE 066-001-000 09242015 0025005 98310 98315 PM A SERVICE 066-001-000 01222015 0023695 92210 92216 PM A SERVICE 066-001-000 07012014 0022362 86550 86550 PM A SERVICE 066-001-000 11062013 0021206 79150 79147 PM A SERVICE 066-001-000 02072013 0019881 71420 71423 PM A SERVICE 066-001-000 06192012 0018761 64560 64563 PM A SERVICE 066-001-000 12082011 0017811 60060 60062 PM A SERVICE 066-001-000 08252011 0017213 57410 57414 PM A SERVICE 066-001-000 04272011 0016498 54520 54520 PM A SERVICE 066 TOTAL >PREVENTATIVE MAINTEN 17.76 231.80 249.57 2.47 JR 26.76 381.03 407.79 4.06 JT 20.49 260.90 281.39 2.78 JR 25.91 378.21 404.13 4.03 JW 20.17 326.59 346.77 3.48 JR 48.21 164.23 212.44 1.75 JR 20.42 150.16 170.58 1.60 JR 28.71 152.97 181.68 1.63 JT 25.26 79.77 105.03 0.85 JT 19.00 286.24 305.25 3.05 CM 252.69 2411.90 2664.59 01 8 XX 01 1 XX Ol 1 XX 01 4 XX 01 8 XX 01 1 XX O1 8 XX 01 8 XX 01 1 XX 01 8 XX DATE: 10/11/2016 TIME: 10:00 a.m. STARTING VMRS CODE: 000-000-000 ENDING VMRS CODE: 999-999-999 CITY OF LODI, CA VEHICLE REPAIR HISTORY REPORT FACILITY: 00001 DATE: FIRST DATE: LAST ID: 1-32/RAV PAGE: 6 VEHICLE:: 05-109 VEHICLE: 05-109 VMRS Code METER : STANDARD SUBTOTALS OF VMRS CODES FOR DIVISION > AL PERIOD : CURRENT TOT COST QUANTITY LABOR HRS LABOR COST PARTS COST TOTAL COST PERCENT /METER 001 HEAT & AIR CONDITIONIN 7 7.5 724.50 002 BODY AND GLASS 3 3.9 376.32 003 ELEC,INSTRM,LIGHT&CHAS 13 2.0 202.69 004 BATTERY, CHRG & STARTI 2 2.1 205.52 005 COOLING 6 8.9 853.08 007 TRANS(MAIN/AUX) PTO/CL 3 4.7 443.90 008 EMISSION CONTROL 5 9.7 943.78 010 ENGINE 7 44.6 4200.71 011 TIRES AND WHEELS 28 16.6 1613.21 012 DRIVE TRAIN 4 4.0 382.90 013 BRAKES 5 18.1 1701.49 014 SPECIAL EQUIPMENT 10 41.0 4001.92 019 MISCELLANEOUS 38 58.1 5523.89 020 FILTERS 7 0.0 4.69 066 PREVENTATIVE MAINTENAN 10 25.2 2411.90 558.69 7.54 379.18 102.90 317.09 65.01 35.00 589.65 1194.96 114.17 156.61 1274.50 158.92 40.62 252.69 1283.19 4.40 % 13.36656 383.86 1.30 % 3.99854 581.87 2.00 % 6.06115 308.42 1.10 % 3.21271 1170.17 4.10 % 12.18927 508.91 1.80 % 5.30115 978.78 3.40 % 10.19563 4790.36 16.60 % 49.89958 2808.17 9.70 % 29.25177 497.07 1.70 % 5.17781 1858.10 6.40 % 19.35521 5276.42. 18.30 % 54.96271..... 5682.81 19.70 % 59.19594 45.31 0.20 % 0.47198 2664.59 9.20 % 27.75615 TOTALS: 148 246.4 23590.50 5247.53 TOT: 28838.03 100 % 0.39616 LflepaLt2 CA:A/2-LN la qv pin wio =42ikk/P I ��rrwcfit at,='°N102S2g,3..b'D3 yr_./97,4/70 IIB. APPROVAL SIGNATURES 1. AA# 2. JV# CITY OF LODI APPROPRIATION ADJUSTMENT REQUEST TO: Internal Services Dept. - Budget Division ACCOUNT* 3 FROM: Police Department 15. DATE 2/24/17 4. DEPARTMENT/DIVISION: 6. REQUEST ADJUSTMENT OF APPROPRIATION AS LISTED BELOW FUND* BUS. UNIT* ACCOUNT* ACCOUNT TITLE AMOUNT A. SOURCE OF FINANCING 403 40300000 57702 Donations $ 20,988.62 L. B. USE OF FINANCING 403 40399100 77040 Vehicle Replacement Fund $ 20,988.62 7. REQUEST IS MADE TO FUND THE FOLLOWING PROJECT NOT INCLUDED IN THE CURRENT BUDGET Please provide a description of the project, the total cost of the project, as well as justification for the requested adjustment. If you need more space, use an additional sheet and attach to this form. The Partners' Foundation will be donating $20,988.62 to purchase a 2016 Ford Transit Connect. The Lodi Police Department will purchase the vehicle and place it into service for Partners' Patrol. If Council has authorized the appropriation adjustment, competsthe following: Meeting Date: Department Head Signature: ._.__._. Res Attach copy of resolution to this form. Deputy City Manager/Internal Services Manager Date Submit completed form to the Budget Division with any required documentation Final approval will be provided in electronic copy format RESOLUTION NO. 2017-34 A RESOLUTION OF THE LODI CITY COUNCIL AUTHORIZING THE CITY MANAGER TO ACCEPT A CASH DONATION FROM THE LODI POLICE PARTNERS' FOUNDATION FOR THE PURCHASE OF A 2016 FORD TRANSIT CONNECT VEHICLE; AND FURTHER APPROPRIATING FUNDS WHEREAS, the Lodi Police PARTNERS' Foundation, a California non-profit corporation, desires to donate the sum of $20,988.62 to the City of Lodi for the purchase of a 2016 Ford Transit Connect, VIN: NMOGS9F7XG1272185, for use in the PARTNERS' Program; and WHEREAS, in consideration for the donation of said vehicle, City agrees that when the vehicle is retired from the City's vehicle fleet, the proceeds from the sale or auction thereof will be made payable to the Lodi Police PARTNERS' Foundation, or alternatively, title to the vehicle will be transferred to the Lodi Police PARTNERS' Foundation. NOW, THEREFORE, BE IT RESOLVED that the Lodi City Council does hereby authorize the City Manager to accept the donation of $20,988.62 for the purchase of a 2016 Ford Transit Connect, VIN: NMOGS9F7XG1272185, for use in the PARTNERS' Program from the Lodi Police PARTNERS' Foundation; and BE IT FURTHER RESOLVED that pursuant to Resolution No. 2015-154, the City will forward the proceeds from the sale or auction of the same to the Lodi Police PARTNERS' Foundation, or alternatively title to the vehicle will be transferred to the Lodi Police PARTNERS' Foundation when the above-described vehicle is retired from City's vehicle fleet to facilitate the Foundation's continued financial support of the PARTNERS' Program; and BE IT FURTHER RESOLVED that funds in the amount of $20,988.62 are hereby appropriated for the vehicle purchase, as shown on the attached Appropriation Request Form. Date: March 15, 2017 I hereby certify that Resolution No. 2017-34 was passed and adopted by the Lodi City Council in a regular meeting held March 15, 2017, by the following vote: AYES: COUNCIL MEMBERS — Chandler, Johnson, Nakanishi, and Mayor Kuehne NOES: COUNCIL MEMBERS — None ABSENT: COUNCIL MEMBERS — Mounce ABSTAIN: COUNCIL MEMBERS — None 2017-34 m *-GtA4-0-6 NIFER FERRAIOLO ity Clerk IIB. APPROVAL SIGNATURES 1. AA# 2. JV# CITY OF LODI APPROPRIATION ADJUSTMENT REQUEST TO: Internal Services Dept. - Budget Division ACCOUNT* 3 FROM: Police Department 15. DATE 2/24/17 4. DEPARTMENT/DIVISION: 6. REQUEST ADJUSTMENT OF APPROPRIATION AS LISTED BELOW FUND* BUS. UNIT* ACCOUNT* ACCOUNT TITLE AMOUNT A. SOURCE OF FINANCING 403 40300000 57702 Donations $ 20,988.62 L. B. USE OF FINANCING 403 40399100 77040 Vehicle Replacement Fund $ 20,988.62 7. REQUEST IS MADE TO FUND THE FOLLOWING PROJECT NOT INCLUDED IN THE CURRENT BUDGET Please provide a description of the project, the total cost of the project, as well as justification for the requested adjustment. If you need more space, use an additional sheet and attach to this form. The Partners' Foundation will be donating $20,988.62 to purchase a 2016 Ford Transit Connect. The Lodi Police Department will purchase the vehicle and place it into service for Partners' Patrol. If Council has authorized the appropriation adjustment, competsthe following: Meeting Date: Department Head Signature: ._.__._. Res Attach copy of resolution to this form. Deputy City Manager/Internal Services Manager Date Submit completed form to the Budget Division with any required documentation Final approval will be provided in electronic copy format