The URL can be used to link to this page

Home My WebLink AboutAgenda Report - July 6, 2016 C-03TM CITY OF LODI COUNCIL COMMUNICATION AGENDA ITEM C°5 AGENDA TITLE: 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,463.90 MEETING DATE: July 6, 2016 PREPARED BY: 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,463.90. 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 three vehicles donated by the Foundation in its vehicle fleet, described as: 2008 Dodge Ram, License No. 1429579, VIN 1D7HA18NX8S585228; 2014 Chevy Equinox, License No. 1395160, VIN 2GNALAEK4F6428091; and 2007 Ford Freestar, License No. 1359280, VIN 2FMZA52227BA04300. The PARTNERS' Foundation also utilizes a 2001 Ford Windstar for patrol. Purchased in 2002, the Ford Windstar was originally purchased for Community Development and in 2007, was reassigned to the Partners for patrol use. The vehicle has logged nearly 74,800 miles and has cost the City a total of nearly $50,000 to maintain since the date of purchase. Due to the Windstar's costly maintenance and years in service, the Fleet Services Supervisor determined it was in need of replacement, leaving the PARTNERS' Foundation in need of a new vehicle. The Foundation reviewed several vehicles that would effectively replace the Ford Windstar van and found the 2015 Ford Transit Connect Wagon XLT would meet the needs of the Foundation and the Lodi Police Department. Staff requests Council accept the cash donation of $20,463.90 from the Lodi Police PARTNERS' Foundation to purchase a 2015 Ford Transit Connect Wagon XLT, to replace the 2001 Ford Windstar. 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 2015 Ford Transit Connect Wagon XLT will be APPROVED: ILL Stephen Schwaba er ity Manager 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,463.90 July 6, 2016 Page Two transferred to the Lodi Police PARTNERS' Foundation, to facilitate the Foundation's continued financial support of the Lodi Police PARTNERS' Program. FISCAL IMPACT: Donation of $20,463.90 to be received in Vehicle Replacement Fund (40300000.55024) FUNDING AVAILABLE: Vehicle Replacement Fund (40399100.77040) 6---C)c,, Jordan Ayers Deputy City Manager/Internal Services Director Tod Patterson Chief of Police Prepared by: Paula O'Keefe, Management Analyst TBP/PJO Attachments - . ' • 1 ye, ; .11 j• 3 Li 44V ' WriVV4 %S. 4 g*/ ••• "if . ./ 11, • • 1' 1; • 6.r , 1's-?-eA • •. - . . 41,00 •-••-•• . ••-• • J. J J 1 • Front Wheel Drive • Power Steering • ABS • 4 -Wheel Disc Brakes • Brake Assist • Heated Mirrors • Power Mirror(s) • Rear Defrost • Privacy Glass • Variable Speed Intermittent Wipers • Third Passenger Door • Fourth Passenger Door • Power Door Locks • Fog Lamps • AM/FM Stereo • CD Player • Steering Wheel Audio Controls • Back -Up Camera • Auxiliary Audio Input • MP3 Player • Pass -Through Rear Seat • Rear Bench Seat • Adjustable Steering Wheel • Trip Computer • Power Windows • 3rd Row Seat • Keyless Entry • Cruise Control • A/C • Rear A/C • Cloth Seats • Bucket Seats • Driver Adjustable Lumbar • Driver Vanity Mirror • Passenger Vanity Mirror • Floor Mats • Engine Immobilizer • Traction Control • Stability Control • Front Side Air Bag • Tire Pressure Monitor • Driver Air Bag • Passenger Air Bag • Passenger Air Bag Sensor • Front Head Air Bag • Rear Head Air Bag � � L 1A-4112-- 8,0-1)6 u-' 22, c)0 u,� 2015 TRANSIT CONNECT WAGON REVIEW NY DAILY NEWS The 2015 Ford Transit Connect Wagon has seating for 7, two sliding rear doors, a rear lift gate, and a car -based platform. It is, by all definitions of the word, a minivan. But Ford has gone so far in their launch of the Transit Connect to call it the "unminivan," even affixing a hash tag to the front of the term for all you social -media -savvy parents out there. It's a bold move to distance them from the vehicle that has long been the staple of the suburban American family, but after a weekend with our "race red" Connect, we're inclined to agree with them. Built on Ford's global C platform that underpins their small cars and crossovers like the Focus and Escape, the Transit Connect drives more like a sedan than an SUV, with a refreshingly responsive steering rack and a decent amount of feedback through the familiar Ford wheel. Powered by a naturally aspirated 2.5 -liter 4 -cylinder routed to the front wheels, don't expect the Transit Connect to get you up to highway speeds in a hurry, especially with a full payload. With 169 -horsepower and 171 lb. -ft. of torque, the aging four -pot has a decent amount of punch in the lower revs, but loses steam as it climbs up the tachometer. We can't help but wish that a slightly more powerful version of the 1.6 -liter EcoBoost four in the five -passenger model made it under the hood of the larger Connect, but in the world of people -hauling, power isn't everything. The 2.5 -liter also falls behind the fuel economy of its boosted brethren, returning 20 -mpg in the city and 28 -mpg on the highway. Over a weekend and more than 500 miles with it, the Connect averaged about 24 -mpg in a mix of city and highway driving. While I affectionately dubbed our bright red van the "Ford Bustang," the Connect's refreshingly lively driving dynamics is not what makes it truly unique. At a base price of only $26,710 for the long -wheelbase 7 -passenger model, the Transit Connect Wagon is a refreshingly honest hauler that is low on frills but high on practicality. Our Titanium model was fully -loaded, with a sticker price of $32,923, but for that relatively low sum you get 17 -inch wheels, leather seats, the MyFordTouch infotainment system with navigation and a backup camera, and a massive panoramic sunroof that makes interior space feel almost endless. Speaking of interior space, the Transit Connect is ripe with it. With 166 cubic feet of interior cargo space from its squared -off walls and sky-high ceilings, the Bustang has more than enough room to haul almost all of your possessions, as I found out in an attempt to move all of my belongings from Manhattan to Boston in one night. That's more capacity than any minivan on sale today for a significant discount on base price. The rear two rows of seats cleverly fold down to create a low, flat floor, and load in is surprisingly easy given the Transit Connect's low ride height. In all, I was able to comfortably fit two small dressers, a desk, multiple large boxes, and three suitcases, as well as a myriad of other small items. There are even aircraft -style overhead bins above the sun visors in the front, and available overhead storage if you forgo the panoramic sunroof. The Titanium may be wearing a fancy suit, but it can't hide its roots as an honest commercial van. If it's loads of technology and comfort you're looking for, however, you may want to consider a traditional minivan. While Ford's often -finicky infotainment system is more than up to a myriad of tasks, there is little else to speak of in terms of creature comforts. The Transit Connect lacks a true rear entertainment system and couch -worthy rear seats, as well as clever family -friendly features like Honda's in -van vacuum or Toyota's PA system, so keeping the kids entertained and firmly planted in their seats is better left to traditional methods like road trip games. Both front and rear seats are pretty firm, the front seat warmers barely work even at full blast, and there are hard plastics everywhere in the interior, but if you can get past those minor details, the Transit Connect will happily do anything you ask of it for a price well south of minivans and SUVs that can cost close to $50,000 fully -loaded. The Transit Connect Wagon doesn't have any true rivals in its segment, as the cargo -van -only Nissan NV200 and 5 -passenger -maximum Ram ProMaster City both fall short of the Connect's capabilities, and traditional minivans are a step above in terms of features and price bracket. It seems Ford may be on to something with their #minivan campaign after all. While our Transit played the part of a workhorse for the weekend, I couldn't help but feel almost sad to return such an honest and likeable van. On a budget, there are few vehicles that can match the capability and drivability of Ford's microbus, and it makes a strong case as the ultimate vehicle for the urban -dwelling large family. NY Daily News EDMONDS VEHICLE REVIEW TRANSIT CONNECT WAGON Suppose you're a business owner drawn to the form and function of a utility van like the Sprinter, but you operate in confined urban settings or just don't need its full-size capacity and full-size price tag. With the relatively compact and affordable Ford Transit Connect, your search could be over. This Euro -derived cargo (or passenger) van offers impressive functionality in a maneuverable and fuel-efficient package. A scaled-down alternative to traditional full-size work vans, the Ford Transit Connect features a car -based architecture and an economical four -cylinder engine. Its payload and towing capacities are pretty meager compared to a regular van, but in return the Transit Connect should woo commercial buyers with its affordable price, maneuverable size and remarkably practical interior. Current Ford Transit Connect Redesigned for 2014, the latest Ford Transit Connect compact commercial van is available in two different wheelbases. Compared to the previous -generation Transit Connect, the smaller one is 6.7 inches shorter in length while the larger one is 9.1 inches longer. Both of the new versions, however, are nearly 7 inches shorter in height compared to the first -gen Transit Connect, which means taller folks won't have it as easy moving around inside as they did with the older van. Besides the different wheelbases, the Transit Connect is offered in cargo van or passenger - oriented wagon body styles. Trim levels are comprised of base XL, midlevel XLT and, for the wagon only, the plush Titanium. All the cargo vans can be had in short- or Tong -wheelbase form. The XL and Titanium wagons are long -wheelbase only and seat seven; the XLT wagon can be had in either short- or Tong -wheelbase versions and as such seats five or seven, respectively. Standard power is provided by a 2.5 -liter four -cylinder engine with 169 horsepower and 171 pound -feet of torque. A turbocharged 1.6 -liter four with 178 hp and 184 Ib -ft of torque is optional on select variants. Both engines send power to the front wheels through a six -speed automatic transmission. Fuel economy is quite good, as EPA estimated combined fuel economy ranges from 23-25 mpg. Standard feature highlights of the XL cargo van include air-conditioning, vinyl upholstery, a tilt - and -telescoping steering wheel, power front windows and door locks and a two -speaker sound system with an auxiliary audio jack. The XL wagon has second- and third -row seats, a center console and power second -row windows. The XLT cargo van adds body -color bumpers, foglights, heated power mirrors, cloth upholstery, a 4.2 -inch multifunction display, cruise control and a CD player. The XLT wagon features rear privacy glass, a rearview camera and rear climate controls. The Titanium wagon adds alloy wheels, automatic headlights and wipers, power -folding mirrors, dual -zone automatic climate control, leather upholstery, a power driver seat, heated front seats, four speakers and Ford's voice -controlled Sync system. Major options include a compressed natural gas engine prep package, front and rear parking sensors, a towing package, a fixed panoramic sunroof, a roof rack, the MyFord Touch electronics interface (includes a 6.5 -inch touchscreen and a navigation system) and the Crew Chief telematics system designed for fleet operators. While we've yet to spend any time behind the wheel of the latest Ford Transit Connect, we know enough to suggest that the standard 2.5 -liter engine will likely prove adequate for most buyers' needs. We also expect this small van to possess relatively nimble handling, especially in short - wheelbase form. Check back for additional driving impressions as they become available. KKB REVIEW OF TRANSIT CONNECT WAGON The 2015 Ford Transit Connect minivan comes in two flavors: as the passenger -hauling wagon that seats up to seven, or as a cargo van ready for commercial service. Each is available in two lengths. But even in Tong -wheelbase (LWB) form, the Transit Connect is rather small, roughly the length of a midsize sedan. This makes the Transit Connect easy to maneuver in parking lots and bustling city confines. While a LWB Transit Connect is larger than a Mazda5 minivan and small cargo haulers like the Nissan NV200, it doesn't offer the spaciousness of a full-size van like the Honda Odyssey or its own big brother, the Ford Transit. But for families and businesses looking for a roomy -yet -not -big van, the Transit Connect could be their Goldilocks. As with its not -too -big, not -too -small size, the Transit Connect splits differences in additional ways compared to other vans. It's fun (relatively speaking) to drive, attains up to 30 mpg, and starts in the mid -$20,000 range. As a family hauler or delivery vehicle, Ford's small van makes a lot of sense. • Front Wheel Drive • Power Steering • ABS • 4 -Wheel Disc Brakes • Brake Assist • Heated Mirrors • Power Mirror(s) • Rear Defrost • Privacy Glass • Variable Speed Intermittent Wipers • Third Passenger Door • Fourth Passenger Door • Power Door Locks • Fog Lamps • AM/FM Stereo • CD Player • Steering Wheel Audio Controls • Back -Up Camera • Auxiliary Audio Input • MP3 Player • Pass -Through Rear Seat • Rear Bench Seat • Adjustable Steering Wheel • Trip Computer • Power Windows • 3rd Row Seat m Keyless Entry O Cruise Control ® A/C • Rear A/C • Cloth Seats • Bucket Seats • Driver Adjustable Lumbar • Driver Vanity Mirror ® Passenger Vanity Mirror m Floor Mats • Engine Immobilizer ® Traction Control • Stability Control • Front Side Air Bag • Tire Pressure Monitor • Driver Air Bag m Passenger Air Bag • Passenger Air Bag Sensor • Front Head Air Bag m Rear Head Air Bag is@$icitotz uo-?/ vow() IAA:tif2- � e� moo u' Z2, E M S/ P C for The City of Lodi Report Date: 06/06/14 Equip No 05-121 Equip Cl VAN6 Cost: Orig Repl Descr VAN, MINI Manuf FORD Model WINDSTAR Dept CD 02 Company Cost Ctr Equipment Master Data Serial 2FMZA50401BB76238 Yr 2001 Status Off Road N Own/Lease 0 Appr Code N Equipment Vendor 1144 Authorization Replacing NEW Warr Exp Date 06/05/04 Fuel Card 0 Monthly Cost Insurance Cost Replacement Cost License Cost Monthly Rent Billing 0.00 0.00 0.00 0.00 0 00 PM: 22363 Delivery 04/26/01 0 In Sery 06/05/01 Reg Exp Meter 1 Total Miles 18945 Currt Meter 18960 Deliv Meter 15 Latest Read 09/26/06 Source OPEN ORDER Meter 2 Parking Loc Stored Loc Shop 01 License 1091036 CA Type 1-C Color WHITE Assoc Eq Operator 4067 HOLDSWORTH, ROBERT Radio No PM Notify Dept CD 02 Purchase Order No CLAIM Disposal Method Buy Back Was Replaced By Exp Miles (1) 36000 Exp (2) Next Next Last Last Last Sched Sched Sched Sched Start Last Fuel Loc 01 Asset No Lease Expir Date 12/31/99 Sery 00 Date Sery 00 Date 09/18/06 Meter 1 Last Start 18960 Meter 1 Override 0 Pref Shift Program Type Comments TRANS TO PD 05-121, 7/2007, WAS 03-050 Exclude from: Cost Reports N 1 INDIVIDUAL Exception Reports N Inventory Lists N Inspection Data: Inspection Month 06 Next Statutory Inspection 06/2008 Interval 24 Months Additional Inspection Data: Sry Last Sched Last Perf Next Sched Interval Last Work Order Type 1 Type 2 Type 3 Warr Vendor Date Warr Deductible 0.00 Page 1 Account Code 100456 Revenue Account 1200451.7851 384E Retired Sold for Est Repl Mo 06 Yr 2008 Repl Code Depreciation Method SL Life Mos 84 Shop Priority Mos Rem 0 Shop Status Salvage 0 No Open Orders 0 Declining Balance 21474.00 Fuel Type UNL Oil Type Tire Type Current Month Usage Tickets NO E M S/ P C for The City of Lodi Report Date: 06/06/14 Equip No 05-121 Equip Cl VAN6 Meter 1 Miles Fuel Gallons Fuel Cost MPG Meter 1 Oil Quarts Oil Cost Misc Cost Rep Lab Cost Rep Pts Cost Rep Lab Hours Rep Task Count PM Lab Cost PM Pts Cost PM Lab Hours PM Task Count Deprec Cost Rental Rev Lease Cost Downtime Hours Shop Dept Delay Hours Warr Recovery Descr VAN, MINI Manuf FORD Model WINDSTAR Equipment Master Data Serial 2FMZA50401BB76238 Yr 2001 Status Page 2 F G H I J K L M N Shop 01 License 1091036 CA Color WHITE Operator 4067 Radio No Type 1-C Assoc Eq HOLDSWORTH, ROBERT This Mth Pry Mth 1 Pry Mth 2 This Qtr Pry Qtr 1 Pry Qtr 2 Pry Qtr 3 Pry Qtr 4 Life 1113 0 237 1113 459 0 948 882 18945 15.1 22.8 21.3 15.1 66.9 66.9 66.6 86.3 1652.7 43.46 72.85 52.01 43.46 173.79 173.79 139.34 211.23 2753.38 73.71 0.00 11.13 73.71 6.86 0.00 14.23 10.22 11.46 0 0 5 0 5 5 0 5 84 0.00 0.00 6.50 0.00 6.50 6.50 0.00 6.50 104.01 4.50 4.50 5.00 4.50 9.50 9.50 0.00 12.00 186.95 596.46 0.00 548.77 596.46 749.36 749.36 23.31 125.05 3279.53 355.21 0.00 165.47 355.21 186.93 186.93 0.00 61.20 1881.67 7.1 0.0 7.8 7.1 13.1 13.1 0.9 4.1 74.3" 7 0 6 7 12 12 1 8 91 53.97 0.00 0 00 53.97 0.00 0.00 38.85 30.50 697.71 3.35 0.00 0.00 3.35 0.00 0.00 3.34 0.00 60.69 1.5 0.0 0.0 1.5 0.0 0.0 1.5 1.0 24.7 1 0 0 1 0 0 1 1 17 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 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 0.00 0.0 0.0 -15.0 0.0 -11.1 -11.1 0.0 5.0 8.7 0.0 0.0 0.0 0.0 0.0 0.0 0.0 5.0 5.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Individual PM Program Service A B Next Due Date 121806 Last Due Date 061306 Meter Last Start 18960 Meter Override 6000 Time Interval MONTHS No of Time Units 3 jai C D E MONTHS MONTHS MONTHS MONTHS MONTHS MONTHS MONTHS MONTHS MONTHS 7,5 60 0 MONTHS =45,1111 411-itL P 11A e�- 4-7578 014_ yi867 -at, - 6, / j 7 o 7 DATE: 06/22/2016 TIME: 03:05 p.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: 1 VEHICLE:: 05-121 VEHICLE: 05-121 UNIT: 05-121 LF MTR: 74785.0 CUR MTR: 74785.0 YR: 01 MAKE: FORD DEPT: 10032000 SIZE: 0 CLASS: VAN6 FUEL: U VMRS CODE DATE WO NUM LF -MILS ODOM WORK DESCRIPTION OUT PARTS 001 TITLE > HEAT & AIR CONDITION 001-004-000 06182008 0006837 23720 001-004-000 06192008 0006837 23720 001-005-000 06242008 0006837 23720 001-007-000 03302016 0026157 71550 001-007-000 03212016 0026157 71380 001-008-000 11062013 0021159 46090 001 TOTAL >HEAT & AIR CONDITION 002 TITLE > BODY AND GLASS 002-001-000 05162012 0018603 002-004-000 03012016 0026048 002-004-000 11192015 0025406 002-004-000 11192015 0025406 002-004-000 12062011 0017791 002-004-000 12072011 0017791 002-004-000 03232011 0016217 002-005-000 03232011 0016217 002-005-000 03232011 0016217 002-005-000 11092010 0015272 002-005-000 11092010 0015272 002-005-000 07132010 0014240 002-005-000 07132010 0014240 002-008-000 01262015 0023705 002 TOTAL >BODY AND GLASS 23719 SERV A/C SYS (EVAC/R 23719 SERV A/C SYS (EVAC/R 23720 COMPRESS/CLUTCH- REP 71553 A/C LINE - REPAIR/RE OUT 71376 A/C LINE - REPAIR/RE 46087 HEATER CORE/HOSES OUT LABOR TOTAL HOURS MECHANIC CC RC WA 0.00 119.70 119.70 1.80 LR 01 11 30 0.00 19.95 19.95 0.30 PB 01 11 XX 221.18 126.35 347.53 1.90 MV 01 11 XX 51.79 40.00 91.79 0.00 01 1 XX 8.83 169.86 178.70 1.81 TN 01 1 XX 66.36 0.00 66.36 0.00 01 1 XX 348.16 475.86 824.02 32260 32255 SEAT/SAFETY BELT OUT 84.96 0.00 84.96 0.00 01 4 XX 70770 70774 DOOR LATCH/LOCK/REL OUT 67.87 0.00 67.87 0.00 01 1 XX 67900 67898 DOOR LATCH/LOCK/REL 0.00 394.17 394.17 4.20 LR 01 4 XX 67900 67898 DOOR LATCH/LOCK/REL OUT 98.91 0.00 98.91 0.00 01 4 XX 29960 29955 DOOR LATCH/LOCK/REL OUT 35.69 0.00 35.69 0.00 01 4 XX 29960 29955 DOOR LATCH/LOCK/REL 0.00 436.40 436.40 4.65 MV 01 4 XX 29450 29450 DOOR LATCH/LOCK/REL 0.00 126.69 126.69 1.35 MV 01 1 XX 29450 29450 WINDOW/RELATED PARTS 0.00 195.20 195.20 2.08 MV 01 1 XX 29450 29450 WINDOW/RELATED PARTS OUT 99.30 0.00 99.30 0.00 01 1 XX 28550 28552 WINDOW/RELATED PARTS OUT 69.70 0.00 69.70 0.00 01 1 XX 28550 28552 WINDOW/RELATED PARTS 0.00 207.40 207.40 2.21 MV 01 1 XX 28230 28228 WINDOW/RELATED PARTS OUT 69.70 0.00 69.70 0.00 01 4 XX 28230 28228 WINDOW/RELATED PARTS 0.00 398.86 398.86 4.25 KG 01 4 XX 59580 59579 BODY-REPAIR/MODIFICA OUT 793.99 949.20 1743.19 0.00 01 12 XX 1320.12 2707.92 4028.04 003 TITLE > ELEC,INSTRM,LIGHT&CH 003-000-000 09012015 0024926 66000 003-003-000 07022014 0022444 53500 003-003-000 06182014 0022444 52960 003-003-000 07072009 0010904 25950 003-003-000 12112007 0005071 22570 003-003-000 07202006 0000011 18100 003-004-000 11132014 0023359 57560 003-004-000 06162014 0022446 52960 003-004-000 05062014 0022165 50680 003-004-000 04282014 0022165 50680 66007 ELEC,INSTRM,LIGHT&CH 53496 ALL LIGHTS/SWTICHES/ OUT 52956 ALL LIGHTS/SWTICHES/ 25945 ALL LIGHTS/SWTICHES/ 22573 ALL LIGHTS/SWTICHES/ 18099 ALL LIGHTS/SWTICHES/ OUT 57561 WIPER/WASH/RELATED P 52956 WIPER/WASH/RELATED P 50680 WIPER/WASH/RELATED P 50680 WIPER/WASH/RELATED P OUT 0.00 1393.67 1393.67 14.85 TN 01 1 XX 19.86 0.00 19.86 0.00 01 4 XX 0.00 298.44 298.44 3.18 LR 01 4 XX 1.03 0.00 1.03 0.00 01 1 XX 1.44 0.00 1.44 0.00 CM XX 1 XX 0.00 0.00 0.00 0.00 XX 1 XX 7.56 0.00 7.56 0.00 01 4 XX 0.00 67.57 67.57 0.72 JR XX XX XX 0.00 175.49 175.49 1.87 JW 01 4 XX 36.02 0.00 36.02 0.00 01 4 XX DATE: 06/22/2016 TIME: 03:05 p.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-121 VEHICLE: 05-121 UNIT: 05-121 LF MTR: 74785.0 CUR MTR: 74785.0 YR: 01 MAKE: FORD DEPT: 10032000 SIZE: 0 CLASS: VAN6 FUEL: U VMRS CODE DATE WO NUM LF -MILS ODOM WORK DESCRIPTION OUT PARTS 003-004-000 06282011 0016880 29600 003-004-000 01032011 0015649 29020 003-004-000 12172009 0012447 27070 003-004-000 12092008 0009002 24750 003-004-000 12112007 0005071 22570 003-004-000 06052007 0003239 21300 003-004-000 09182006 0000719 18960 003-007-000 01042010 0012447 27070 003-008-000 05292012 0018603 32560 003-010-000 07242006 0000212 18100 003-012-000 06162015 0024544 63700 003-012-000 11172011 0017729 29910 003 TOTAL >ELEC,INSTRM,LIGHT&CH 004 TITLE > BATTERY, CHRG & STAR 004-001-000 03102014 0021864 49780 004-001-000 08142012 0019015 34000 004-001-000 08022012 0018962 33740 004-001-000 07162012 0018876 33480 004-001-000 12092008 0009002 24750 004-002-000 04092013 0020084 39320 004-004-000 08132012 0019015 33740 004-009-000 07162012 0018876 33480 004-010-000 08092012 0019005 33740 004-010-000 07162012 0018876 33480 004 TOTAL >BATTERY, CHRG & STAR 005 TITLE > COOLING 005-001-000 01282013 0019834 005-002-000 11042014 0023288 005-006-000 11052014 0023288 005-006-000 11042014 0023288 005-006-000 09252008 0008052 005-006-000 09182008 0007933 005-008-000 01292013 0019834 005-008-000 01282013 0019834 005-009-000 12192014 0023543 005-009-000 12222014 0023543 29602 29017 27070 24745 22573 21305 18960 27070 32559 18099 63701 29909 WIPER/WASH/RELATED P WIPER/WASH/RELATED P WIPER/WASH/RELATED P WIPER/WASH/RELATED P WIPER/WASH/RELATED P WIPER/WASH/RELATED P WIPER/WASH/RELATED P ALL OTHER ELEC COMPO OUT DIST/S PLG/WIRE, NEW OUT CNTRL MODU/COIL/MISC OUT HEADLIGHT - REPAIR/R HEADLIGHT - REPAIR/R 49778 TEST CHRG/START/BATT 34001 TEST CHRG/START/BATT 33740 TEST CHRG/START/BATT 33483 TEST CHRG/START/BATT 24745 TEST CHRG/START/BATT 39319 BATTERY - REPLACE 33740 ALTERNATOR - REPLACE OUT 33483 BATTERY - OTHER SERV 33740 JUMP START 33483 JUMP START 37760 37764 PRESS CHK COOLING SY 57560 57561 RADIATOR HOSE(S) OUT 57560 57561 WATER PUMP 57560 57561 WATER PUMP 24180 24179 WATER PUMP 24180 24179 WATER PUMP 37760 37764 OTHER COOL SYS REPAI OUT 37760 37764 OTHER COOL SYS REPAI 57560 57561 ANTI -FREEZE LEAK OUT 57560 57561 ANTI -FREEZE LEAK OUT OUT OUT LABOR 4.66 0.00 14.17 4.69 0.00 0.00 0.00 0.00 13.40 0.00 18.67 13.30 14.35 19.95 0.00 50.00 135.65 0.00 259.24 270.00 0.00 79.77 0.00 46.92 526.05 2419.80 0.00 0.00 0.00 0.00 0.00 98.18 185.37 0.00 0.00 0.00 283.55 0.00 42.34 0.00 89.27 229.19 2.59 26.29 0.00 28.16 26.00 0.00 420.44 117.31 154.85 0.00 0.00 0.00 0.00 0.00 0.00 692.60 TOTAL HOURS MECHANIC CC RC WA 4.66 18.86 0.00 0.00 13.40 31.97 34.30 50.00 135.65 529.24 79.77 46.92 2945.85 0.00 420.44 117.31 154.85 0.00 98.18 185.37 0.00 0.00 0.00 976.15 0.00 0.00 0.00 42.34 492.71 492.71 0.00 89.27 0.00 229.19 0.00 2.59 0.00 26.29 0.00 0.00 0.00 28.16 554.65 580.66 0.00 CM 0.05 JR 0.00 JT 0.00 CM 0.00 CM 0.20 JR 0.30 RO 0.00 0.00 0.00 0.85 JR 0.50 JR 0.00 JT 4.48 CMc 1.25 JR 1.65 JT 0.00 CM 0.00 0.00 0.00 JT 0.00 JT 0.00 JT 0.00 JT 0.00 5.25 MV 0.00 0.00 0.00 0.00 0.00 JT 0.00 5.91 MV XX 8 XX XX 8 XX XX 1 XX XX 8 XX XX 1 XX XX 8 XX XX 8 XX 01 1 XX 01 4 XX XX 12 XX XX 8 XX 01 1 XX XX 1 XX 01 4 XX 01 4 XX 01 1 XX XX 8 XX 01 1 XX 01 4 XX XX 1 XX XX 1 XX XX 1 XX 01 1 XX 01 4 XX XX 4 XX 01 4 XX 01 12 XX 01 12 XX 01 1 XX 01 1 XX 01 1 XX 01 1 XX DATE: 06/22/2016 TIME: 03:05 p.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-121 VEHICLE: 05-121 UNIT: 05-121 LF MTR: 74785.0 CUR MTR: 74785.0 YR: 01 MAKE: FORD DEPT: 10032000 SIZE: 0 CLASS: VAN6 FUEL: U VMRS CODE DATE WO NUM LF -MILS ODOM WORK DESCRIPTION OUT PARTS LABOR TOTAL HOURS MECHANIC CC RC WA 005-009-000 01282013 0019834 37760 37764 ANTI -FREEZE LEAK 005-010-000 09172008 0007884 24170 24179 OVER HEATING PROBLEM 005 TOTAL >COOLING 006 TITLE > FUEL 006-004-000 03212012 0018209 006-004-000 03062012 0018209 006-009-000 09232015 0024926 006-010-000 10292015 0024926 006 TOTAL >FUEL 31650 31649 FUEL PUMP - REPLACE OUT 31460 31462 FUEL PUMP - REPLACE 66450 66454 OTHER FUEL SYS SERVI OUT 67450 67448 INSTALL AIM DEVICE 007 TITLE > TRANS(MAIN/AUX) PTO/ 007-003-000 02292012 0017543 31290 007-003-000 02132012 0017543 31170 007-004-000 05092016 0026420 72510 007-004-000 05042016 0026420 72510 007-004-000 02282012 0017543 31290 007 TOTAL >TRANS(MAIN/AUX) PTO/ 31291 TRANS - REPAIR/REPLA OUT 31173 TRANS - REPAIR/REPLA OUT 72513 TRANS - OTHER REPAIR OUT 72513 TRANS - OTHER REPAIR 31291 TRANS - OTHER REPAIR 008 TITLE > EMISSION CONTROL 008-004-000 06152016 0026638 73670 73668 008-004-000 04122016 0026293 71870 71867 008-004-000 09212015 0024926 66450 66454 008-004-000 03112014 0021864 49780 49778 008-004-000 11202013 0021299 46520 46524 008-004-000 12222011 0017543 30250 30254 008-004-000 01072011 0015658 29020 29017 008-005-000 11042014 0023288 57560 57561 008-005-000 05302012 0018603 32560 32559 008-011-000 08292014 0022895 55410 55414 008-011-000 03292012 0018300 31650 31649 008-011-000 07202010 0014337 28450 28449 008-011-000 11032008 0008533 24660 24655 008-011-000 10292008 0008533 24270 24265 008 TOTAL >EMISSION CONTROL COMPUTER ANALYS BOAR COMPUTER ANALYS BOAR COMPUTER ANALYS BOAR COMPUTER ANALYS BOAR COMPUTER ANALYS BOAR COMPUTER ANALYS BOAR COMPUTER ANALYS BOAR ON BOARD ECM/SENSOR/ ON BOARD ECM/SENSOR/ SMOG CHECK/CERTIFICA SMOG CHECK/CERTIFICA SMOG CHECK/CERTIFICA SMOG CHECK/CERTIFICA SMOG CHECK/CERTIFICA 009 TITLE > EXHAUST 009-004-000 06182008 0006837 23720 23719 HANGERS/CLAMPS OUT OUT OUT OUT OUT 7.40 310.64 10.16 565.25 461.40 1923.25 318.05 3.31 JT 575.41 8.50 MV 2384.65 168.12 0.00 168.12 0.00 492.71 492.71 205.44 0.00 205.44 289.64 201.77 491.42 663.20 694.48 1357.68 9.72 1104.00 1113.72 1753.09 0.00 1753.09 59.49 0.00 59.49 2.19 311.58 313.77 0.00 101.35 101.35 1824.49 1516.93 3341.42 0.00 305.01 305.01 0.00 213.97 213.97 0.00 827.75 827.75 0.00 281.54 281.54 50.65 331.29 381.94 0.00 246.82 246.82 0.00 272.16 272.16 154.78 0.00 154.78 0.00 525.56 525.56 0.00 25.00 25.00 0.00 25.00 25.00 0.00 25.00 25.00 0.00 25.00 25.00 0.00 252.70 252.70 205.43 3356.80 3562.23 120.60 159.60 0.00 5.25 MV 0.00 2.15 TN 0.00 0.00 0.00 3.32 MV 1.08 LR 01 1 XX 01 1 XX 01 1 XX XX 1 XX 01 1 XX 01 1 XX 01 4 XX 01 4 XX 01 1 XX 01 1 XX XX 4 XX 3.25 MV 01 4 XX 2.28 MV 01 1 XX 8.82 MV 01 1 XX 3.00 JT 01 1 XX 3.53 TN 01 1 XX 2.63 MV 01 4 XX 2.90 LR 01 4 XX 0.00 01 4 XX 5.60 MV 01 4 XX 0.00 01 12 XX 0.00 01 4 XX 0.00 01 12 XX 0.00 01 11 XX 3.80 PB 01 11 XX 280.20 2.40 PB 01 11 XX DATE: 06/22/2016 TIME: 03:05 p.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-121 VEHICLE: 05-121 UNIT: 05-121 LF MTR: 74785.0 CUR MTR: 74785.0 YR: 01 MAKE: FORD DEPT: 10032000 SIZE: 0 CLASS: VAN6 FUEL: U VMRS CODE DATE WO NUM LF -MILS ODOM WORK DESCRIPTION OUT PARTS LABOR TOTAL HOURS MECHANIC CC RC WA 009 TOTAL >EXHAUST 010 TITLE > ENGINE 010-004-000 10302013 0021159 45910 010 TOTAL >ENGINE 011 TITLE > TIRES AND WHEELS 011-000-000 05082012 0018300 32040 011-001-000 09032009 0011431 26540 011-001-000 09012009 0011406 26510 011-002-000 06172014 0022444 52960 011-002-000 09082011 0017297 29880 011-002-000 09012009 0011406 26510 011-002-000 12262006 0001699 19960 011-002-000 07122006 0000011 17960 011-003-000 11302015 0025406 67900 011-003-000 03012016 0025406 70770 011-003-000 11132014 0023355 57560 011-003-000 11052014 0023288 57560 011-003-000 06162014 0022444 52960 011-003-000 12192013 0021420 47470 011-003-000 12172013 0021420 47470 011-003-000 06222010 0014065 28040 011-003-000 06222010 0014065 28040 011-003-000 09032009 0011431 26540 011-003-000 09032009 0011431 26530 011-003-000 08272007 0003979 21880 011 TOTAL >TIRES AND WHEELS 013 TITLE > BRAKES 013-001-000 06212016 013-001-000 08052014 013-001-000 08052014 013-001-000 06222010 013-001-000 12172009 013-001-000 12162009 013-004-000 12122013 013-009-000 06212016 45910 ENGINE - OTHER SERVI 32043 TIRES AND WHEELS 26537 TIRES - 26508 TIRES - 52956 TIRE(S) 29884 TIRE(S) 26508 TIRE(S) 19959 TIRE(S) 17955 TIRE(S) 67898 TIRE(S) 70774 TIRE(S) 57561 TIRE(S) 57561 TIRE(S) 52956 TIRE(S) 47470 TIRE(S) 47470 TIRE(S) 28042 TIRE(S) 28042 TIRE(S) 26537 TIRE(S) 26530 TIRE(S) 21879 TIRE(S) BALANCE BALANCE - REPAIR/ROT - REPAIR/ROT - REPAIR/ROT - REPAIR/ROT - REPAIR/ROT - REPLACE - REPLACE OUT - REPLACE - REPLACE OUT - REPLACE OUT - REPLACE OUT - REPLACE - REPLACE - REPLACE OUT - REPLACE - REPLACE OUT - REPLACE 0026665 74790 74785 BRAKE SHOES/PADS -RE 0022736 54550 54552 BRAKE SHOES/PADS -RE OUT 0022736 54550 54552 BRAKE SHOES/PADS -RE OUT 0014065 28040 28042 BRAKE SHOES/PADS -RE 0012447 27070 27070 BRAKE SHOES/PADS -RE 0012447 26950 26952 BRAKE SHOES/PADS -RE OUT 0021420 47470 47470 HYD SYS - REPAIR/REP OUT 0026665 74790 74785 BRAKE(S) - OTHER SER 120.60 159.60 280.20 23.59 874.68 898.27 9.32 MV 23.59 874.68 898.27 01 1 XX 0.00 635.36 635.36 6.77 CMc 01 4 0.00 0.00 0.00 0.00 JT XX 1 0.00 0.00 0.00 0.00 JT XX 1 0.00 161.42 161.42 1.72 LR 01 4 0.00 90.09 90.09 0.96 JT 01 1 0.00 75.08 75.08 0.80 JT 01 1 0.00 99.75 99.75 1.50 CM XX 4 0.00 33.25 33.25 0.50 JT XX 1 0.00 131.39 131.39 1.40 LR 01 4 213.97 0.00 213.97 0.00 01 4 0.00 70.38 70.38 0.75 TN 01 1 159.41 0.00 159.41 0.00 01 4 71.32 0.00 71.32 0.00 01 4 159.00 0.00 159.00 0.00 01 1 0.00 168.93 168.93 1.80 JR XX 1 0.00 0.00 0.00 0.00 KG XX 1 110.62 0.00 110.62 0.00 01 1 0.00 0.00 0.00 0.00 JT XX 1 54.59 0.00 54.59 0.00 01 1 124.37 106.40 230.77 1.60 RO 01 1 893.28 1572.05 2465.33 XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX 0.00 0.00 0.00 0.00 01 1 XX 78.71 0.00 78.71 0.00 01 1 XX 22.86 0.00 22.86 0.00 01 1 XX 44.45 143.59 188.04 1.53 KG XX 1 XX 0.00 305.01 305.01 3.25 JT XX 1 XX 19.23 0.00 19.23 0.00 01 1 XX 19.42 0.00 19.42 0.00 01 1 XX 0.00 0.00 0.00 0.00 JT 01 1 XX DATE: 06/22/2016 TIME: 03:05 p.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-121 VEHICLE: 05-121 UNIT: 05-121 LF MTR: 74785.0 CUR MTR: 74785.0 YR: 01 MAKE: FORD DEPT: 10032000 SIZE: 0 CLASS: VAN6 FUEL: U VMRS CODE DATE WO NUM LF -MILS ODOM WORK DESCRIPTION OUT PARTS 013-009-000 08052014 0022736 013-009-000 03132014 0021897 013-009-000 03132014 0021897 013-009-000 03102014 0021864 013-009-000 12172013 0021420 013-009-000 07122006 0000011 013 TOTAL >BRAKES 54550 49810 49810 49780 47470 17960 014 TITLE > SPECIAL EQUIPMENT 014-000-000 08272015 0024926 66000 014-001-000 09012015 0024926 66010 014-001-000 11132014 0023359 57560 014-001-000 01302012 0017543 30960 014-001-000 12072011 0017543 29960 014-001-000 12012011 0017543 29960 014-001-000 11292011 0017543 29950 014-002-000 12052011 0017791 29960 014-003-000 04082016 0026258 71550 014-003-000 12202012 0019676 36780 014 TOTAL >SPECIAL EQUIPMENT 015 TITLE > STEERING AND SUSPENS 015-001-000 11182014 0023288 57560 015-003-000 12162013 0021420 47470 015-003-000 04302012 0018300 31850 015-006-000 12122013 0021420 47470 015-006-000 12172013 0021420 47470 015-006-000 04302012 0018300 31850 015-006-000 04302012 0018300 31850 015-006-000 03292012 0018300 31650 015-006-000 03272012 0018300 31650 015-006-000 04052012 0018300 31690 015-006-000 03272012 0018300 31650 015-006-000 03222012 0018298 31650 015-008-000 11182014 0023288 57560 015-008-000 08052014 0022736 54550 015-008-000 12162013 0021420 47470 015-008-000 04302012 0018300 31850 54552 BRAKE(S) 49810 BRAKE(S) 49810 BRAKE(S) 49778 BRAKE(S) 47470 BRAKE(S) 17955 BRAKE(S) - OTHER SER - OTHER SER - OTHER SER OUT - OTHER SER - OTHER SER - OTHER SER 65997 SPECIAL EQUIPMENT 66007 EMERGENCY LIGHTING 57561 EMERGENCY LIGHTING 30961 EMERGENCY LIGHTING 29955 EMERGENCY LIGHTING 29955 EMERGENCY LIGHTING 29955 EMERGENCY LIGHTING 29955 OTHER SPEC EQP - REP 71553 SPECIAL WIRING - REP 36784 SPECIAL WIRING - REP 57561 47470 31854 47470 47470 31854 31854 31649 31649 31694 31649 31649 57561 54552 47470 31854 OUT OUT OUT OUT ALIGNMENT - CHECK/AD OUT STEER LINK & SUSP ME STEER LINK & SUSP ME STEERING PUMP - REPL OUT STEERING PUMP - REPL STEERING PUMP - REPL OUT STEERING PUMP - REPL OUT STEERING PUMP - REPL OUT STEERING PUMP - REPL OUT STEERING PUMP - REPL STEERING PUMP - REPL OUT STEERING PUMP - REPL OUT OTHER SUSP/STEER SER OUT OTHER SUSP/STEER SER OTHER SUSP/STEER SER OUT OTHER SUSP/STEER SER OUT LABOR TOTAL HOURS MECHANIC CC RC WA 0.00 437.34 437.34 0.00 174.56 174.56 569.05 0.00 569.05 0.00 258.08 258.08 0.00 535.88 535.88 0.00 19.95 19.95 753.72 1874.41 2628.13 0.00 89.15 89.15 1358.89 0.00 1358.89 0.00 0.00 0.00 0.00 0.00 0.00 25.04 0.00 25.04 690.09 0.00 690.09 0.00 574.36 574.36 0.00 79.77 79.77 3.17 713.25 716.43 6.26 248.70 254.96 2083.45 1705.23 3788.68 0.00 59.95 59.95 0.00 109.80 109.80 4.25 137.02 141.27 74.32 0.00 74.32 0.00 573.42 573.42 102.60 0.00 102.60 19.38 0.00 19.38 19.38 0.00 19.38 11.38 0.00 11.38 0.00 490.83 490.83 103.56 0.00 103.56 102.60 0.00 102.60 67.93 98.50 166.43 0.00 28.15 28.15 74.91 0.00 74.91 33.06 0.00 33.06 4.66 JR 1.86 MV 0.00 2.75 MV 5.71 JR 0.30 JT 01 1 XX 01 1 XX 01 1 XX 01 1 XX 01 1 XX XX 1 XX 0.95 TN XX 1 XX 0.00 01 1 XX 0.00 01 4 XX 0.00 01 4 XX 0.00 01 4 XX 0.00 01 4 XX 6.12 CMc 01 4 XX 0.85 MV 01 4 XX 7.60 MV 01 1 XX 2.65 CMc 01 1 XX 0.00 01 4 XX 1.17 JR XX 1 XX 1.46 MV 01 4 XX 0.00 01 1 XX 6.11 JR XX 1 XX 0.00 01 4 XX 0.00 01 4 XX 0.00 01 4 XX 0.00 01 4 XX 5.23 CMc 01 4 XX 0.00 01 4 XX 0.00 01 1 XX 0.00 01 4 XX 0.30 JR 01 1 XX 0.00 01 1 XX 0.00 01 4 XX DATE: 06/22/2016 TIME: 03:05 p.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: 6 VEHICLE:: 05-121 VEHICLE: 05-121 UNIT: 05-121 LF MTR: 74785.0 CUR MTR: 74785.0 YR: 01 MAKE: FORD DEPT: 10032000 SIZE: 0 CLASS: VAN6 FUEL: U VMRS CODE DATE WO NUM LF -MILS ODOM WORK DESCRIPTION OUT PARTS 015-008-000 04252012 0018300 31850 015-009-000 11182014 0023288 57560 015-009-000 11042014 0023288 57560 015-009-000 11042014 0023288 57560 015 TOTAL >STEERING AND SUSPENS 019 TITLE > MISCELLANEOUS 019-001-000 06212016 0026665 019-001-000 11052014 0023288 019-001-000 01282013 0019834 019-001-000 07162012 0018876 019-001-000 09032009 0011431 019-001-000 09012009 0011406 019-001-000 08222007 0003979 019-001-000 07172006 0000011 019-002-000 06212016 0026665 019-002-000 06202016 0026665 019-002-000 04052016 0026258 019-002-000 04052016 0026258 019-002-000 11032014 0023284 019-002-000 06202013 0020514 019-002-000 08092012 0019005 019-002-000 08092012 0019005 019-002-000 07162012 0018876 019-002-000 03062012 0018209 019-002-000 03062012 0018209 019-002-000 03012012 0018209 019-002-000 01312012 0017543 019-002-000 01302012 0017543 019-002-000 09032009 0011431 019-002-000 09032009 0011431 019-002-000 09022009 0011406 019-002-000 09012009 0011406 019-002-000 09172008 0007801 019-002-000 09112008 0007801 019-003-000 03292012 0018300 019-005-000 06282011 0016880 019-010-000 11062014 0023303 74790 57560 37760 33480 26540 26510 21880 18100 74790 74790 71550 71550 57560 41300 33740 33740 33480 31460 31460 31370 31170 31170 26530 26530 26530 26510 24120 24120 31650 29600 57560 31854 OTHER SUSP/STEER SER OUT 57561 SHOCKS & STRUTS - RE OUT 57561 SHOCKS & STRUTS - RE OUT 57561 SHOCKS & STRUTS - RE 74785 ROAD TEST 57561 ROAD TEST 37764 ROAD TEST 33483 ROAD TEST 26537 ROAD TEST 26508 ROAD TEST 21879 ROAD TEST 18099 ROAD TEST / DIAGNOSI / DIAGNOSI / DIAGNOSI / DIAGNOSI / DIAGNOSI / DIAGNOSI / DIAGNOSI / DIAGNOSI 74785 SERVICE CALL 74785 SERVICE CALL 71553 SERVICE CALL 71553 SERVICE CALL 57561 SERVICE CALL 41296 SERVICE CALL 33740 SERVICE CALL 33740 SERVICE CALL 33483 SERVICE CALL 31462 SERVICE CALL 31462 SERVICE CALL 31367 SERVICE CALL 31173 SERVICE CALL 31173 SERVICE CALL 26537 SERVICE CALL 26530 SERVICE CALL 26530 SERVICE CALL 26508 SERVICE CALL 24117 SERVICE CALL 24117 SERVICE CALL 31649 COMM TOW - BRING TO OUT 29602 STEAM CLEAN 57561 MISCELLANEOUS LABOR TOTAL HOURS MECHANIC CC RC WA 268.54 0.00 268.54 0.00 0.00 256.10 256.10 0.00 177.28 0.00 177.28 0.00 0.00 76.95 76.95 0.82 MV 1059.19 1830.72 2889.91 01 4 XX 01 4 XX 01 4 XX 01 4 XX 0.00 0.00 0.00 0.00 JT 01 1 38.81 1886.38 1925.20 20.10 MV 01 4 0.00 6.56 6.56 0.07 JT 01 1 0.00 0.00 0.00 0.00 JT XX 1 0.00 0.00 0.00 0.00 JT XX 1 0.00 0.00 0.00 0.00 JT XX 1 0.00 66.50 66.50 1.00 RO XX 1 0.00 66.50 66.50 1.00 RO XX 1 0.00 123.88 123.88 1.32 LR 01 1 0.00 72.26 72.26 0.77 JT 01 1 0.00 140.77 140.77 1.50 LR 01 1 0.00 192.39 192.39 2.05 JT 01 1 0.00 197.08 197.08 2.10 MV 01 1 0.00 236.50 236.50 2.52 MV 01 1 101.78 103.23 205.01 1.10 JR 01 1 0.00 102.29 102.29 1.09 JT 01 1 0.00 0.00 0.00 0.00 JT XX 1 0.00 203.65 203.65 2.17 MV 01 1 0.00 130.45 130.45 1.39 LR 01 1 0.00 0.00 0.00 0.00 CMc 01 1 0.00 44.10 44.10 0.47 MV 01 4 0.00 121.06 121.06 1.29 LR 01 4 0.00 150.16 150.16 1.60 JT 01 1 0.00 84.46 84.46 0.90 KG 01 1 0.00 168.93 168.93 1.80 KG 01 1 0.00 65.69 65.69 0.70 JT 01 1 0.00 93.10 93.10 1.40 LR 01 1 0.00 73.15 73.15 1.10 MV 01 1 0.00 85.00 85.00 0.00 01 4 0.00 1.87 1.87 0.02 CM XX 8 0.00 73.20 73.20 0.78 TN 01 1 XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX DATE: 06/22/2016 TIME: 03:05 p.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: 7 VEHICLE:: 05-121 VEHICLE: 05-121 UNIT: 05-121 LF MTR: 74785.0 CUR MTR: 74785.0 YR: 01 MAKE: FORD DEPT: 10032000 SIZE: 0 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 019-010-000 019-010-000 019-010-000 019-010-000 019-010-000 019-010-000 019-010-000 019-010-000 019-010-000 019-012-000 019-012-000 019-013-000 019-013-000 019-013-000 019-013-000 019-013-000 019-013-000 019-013-000 019-014-000 019-014-000 019-014-000 019-014-000 019-014-000 019-014-000 019-014-000 019-014-000 019-014-000 019-014-000 019-014-000 019-014-000 019-014-000 019-015-000 019-015-000 019-015-000 019-017-000 019-017-000 11062014 07182012 07162012 03212012 12212011 07212010 05262010 05262010 09252006 07122006 12172009 12092008 11132014 12082011 11172011 12122007 12112007 12112007 08222007 12162014 08162010 08162010 05262010 12182009 12172009 06122007 12132006 12132006 12082006 12132006 09202006 09202006 11042014 04022012 01032011 12162014 12112007 0023303 0018876 0018876 0018298 0017543 0014345 0013295 0013295 0000719 0000011 0012447 0009002 0023359 0017543 0017543 0005076 0005071 0005076 0003979 0023534 0014532 0014532 0013295 0012459 0012447 0003245 0000989 0000989 0001548 0000989 0000719 0000719 0023288 0018300 0015649 0023535 0005071 019 TOTAL >MISCELLANEOUS 57560 33480 33480 31650 30250 28450 28040 28030 18960 18100 27070 24750 57560 29960 29910 22570 22570 22570 21880 57560 28550 28550 28040 27070 27070 21310 19850 19840 19800 19850 18960 18960 57560 31690 29010 57560 22570 57561 33483 33483 31649 30254 28449 28037 28037 18960 18099 27070 24745 57561 29955 29909 22573 22573 22573 21879 57561 28552 28552 28037 27070 27070 21313 19846 19846 19803 19846 18960 18960 57561 31694 29017 57561 22573 MISCELLANEOUS MISCELLANEOUS MISCELLANEOUS MISCELLANEOUS MISCELLANEOUS MISCELLANEOUS MISCELLANEOUS MISCELLANEOUS MISCELLANEOUS MISCELLANEOUS FIRE EXT - REMOVE/RE FIRE EXT - REMOVE/RE DECALS - REMOVE/APPL DECALS - REMOVE/APPL DECALS - REMOVE/APPL DECALS - REMOVE/APPL DECALS - REMOVE/APPL DECALS - REMOVE/APPL DECALS - REMOVE/APPL P U/DEL VEH TO COMM P U/DEL VEH TO COMM P U/DEL VEH TO COMM P U/DEL VEH TO COMM P U/DEL VEH TO COMM P U/DEL VEH TO COMM P U/DEL VEH TO COMM P U/DEL VEH TO COMM P U/DEL VEH TO COMM P U/DEL VEH TO COMM P U/DEL VEH TO COMM P U/DEL VEH TO COMM P U/DEL VEH TO COMM ALL BELTS - REPL/ADJ ALL BELTS - REPL/ADJ ALL BELTS - REPL/ADJ PICK UP PARTS PICK UP PARTS 020 TITLE > FILTERS 020-000-000 12182014 0023543 57560 57561 FILTERS 0.00 95.72 95.72 1.02 JR XX 1 XX OUT 64.65 0.00 64.65 0.00 01 1 XX 0.00 0.00 0.00 0.00 JT XX 1 XX OUT 36.84 0.00 36.84 0.00 01 1 XX OUT 71.11 50.00 121.11 0.00 01 4 XX OUT 38.52 0.00 38.52 0.00 01 4 XX 0.00 0.00 0.00 0.00 01 11 XX 0.00 239.31 239.31 2.55 JT 01 11 XX 144.06 99.75 243.81 1.50 RO XX 8 XX 0.00 139.65 139.65 2.10 PB XX 1 XX 0.00 0.00 0.00 0.00 JT XX 1 XX 0.00 0.00 0.00 0.00 CM XX 8 XX 0.00 143.59 143.59 1.53 JT 01 4 XX OUT 0.00 119.50 119.50 0.00 01 4 XX 0.00 75.07 75.07 0.80 CM 01 4 XX 0.00 119.70 119.70 1.80 JR 01 1 XX 0.00 0.00 0.00 0.00 CM 01 1 XX 0.00 26.60 26.60 0.40 JT 01 1 XX 0.00 46.55 46.55 0.70 RO XX 1 XX 0.00 79.77 79.77 0.85 MV 01 1 XX 0.00 91.97 91.97 0.98 JT 01 11 XX 0.00 82.58 82.58 0.88 CM 01 11 XX 0.00 0.00 0.00 0.00 JT XX 11 XX 0.00 134.20 134.20 1.43 JT 01 1 XX 0.00 0.00 0.00 0.00 JT XX 1 XX 36.10 53.20 89.30 0.80 PB 01 1 XX 0.00 33.25 33.25 0.50 KG XX 1 0.00 59.85 59.85 0.90 PB XX 1 XX 0.00 33.25 33.25 0.50 KG XX 1 XX 0.00 46.55 46.55 0.70 RO XX 1 XX 0.00 39.90 39.90 0.60 KG XX 8 XX 0.00 46.55 46.55 0.70 PB XX 8 XX OUT 27.40 0.00 27.40 0.00 01 4 XX 0.00 9.38- 9.38- 0.10-CMc 01 4 XX 24.57 150.16 174.73 1.60 JR XX 8 XX 0.00 68.51 68.51 0.73 TN 01 1 XX 0.00 0.00 0.00 0.00 CM XX 1 XX 583.84 6554.95 7138.79 OUT 7.07 0.00 7.07 0.00 01 1 XX DATE: 06/22/2016 TIME: 03:05 p.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: 8 VEHICLE:: 05-121 VEHICLE: 05-121 UNIT: 05-121 LF MTR: 74785.0 CUR MTR: 74785.0 YR: 01 MAKE: FORD DEPT: 10032000 SIZE: 0 CLASS: VAN6 FUEL: U VMRS CODE DATE WO NUM LF -MILS ODOM WORK DESCRIPTION OUT PARTS 020-001-000 06212016 0026665 020-001-000 03112014 0021864 020-001-000 12172009 0012447 020-001-000 12142007 0005071 020-001-000 06052007 0003239 020-003-000 05302012 0018603 020 TOTAL >FILTERS 74790 74785 AIR FILTER - REPLACE 49810 49810 AIR FILTER - REPLACE 27070 27070 AIR FILTER - REPLACE 22570 22573 AIR FILTER - REPLACE 21310 21305 AIR FILTER - REPLACE 32560 32559 FUEL FILTER - REPLAC 066 TITLE > PREVENTATIVE MAINTEN 066-001-000 06212016 0026665 74790 066-001-000 03162016 0026157 71370 066-001-000 06162015 0024544 63700 066-001-000 08052014 0022736 54550 066-001-000 03112014 0021864 49810 066-001-000 08292013 0020882 43750 066-001-000 03262013 0020084 39090 066-001-000 05222012 0018620 32450 066-001-000 11172011 0017729 29910 066-001-000 06282011 0016880 29660 066-001-000 01032011 0015649 29010 066-001-000 06232010 0014065 28040 066-001-000 12172009 0012447 27070 066-001-000 06162009 0010695 25940 066-001-000 12092008 0009002 24750 066-001-000 12082008 0008977 24750 066-001-000 06102008 0006751 23690 066-001-000 12122007 0005071 22570 066-001-000 06052007 0003239 21300 066-001-000 09202006 0000719 18960 066 TOTAL >PREVENTATIVE MAINTEN 74785 71376 63701 54552 49810 43745 39092 32455 29909 29669 29017 28042 27070 25945 24745 24745 23687 22573 21305 18960 PM A SERVICE PM A SERVICE PM A SERVICE PM A SERVICE PM A SERVICE PM A SERVICE PM A SERVICE PM A SERVICE PM A SERVICE PM A SERVICE PM A SERVICE PM A SERVICE PM A SERVICE PM A SERVICE PM A SERVICE PM A SERVICE PM A SERVICE PM A SERVICE PM A SERVICE PM A SERVICE LABOR TOTAL HOURS MECHANIC CC RC WA 10.42 0.00 10.42 0.00 XX 1 9.91 1.87 11.78 0.02 JT XX 1 0.00 0.00 0.00 0.00 JT XX 1 11.10 0.00 11.10 0.00 CM XX 1 9.59 19.95 29.54 0.30 JR XX 8 9.63 0.00 9.63 0.00 MV 01 4 57.72 21.82 79.54 17.65 414.81 432.47 4.42 JT 01 1 18.67 302.19 320.87 3.22 JR 01 1 20.07 215.85 235.92 2.30 JR 01 8 20.20 238.37 258.58 2.54 JR 01 1 19.89 194.26 214.16 2.07 JT 01 1 0.00 1.87 1.87 0.02 JR 01 1 30.38 231.80 262.19 2.47 JR 01 1 20.42 98.54 118.97 1.05 JR 01 8 0.00 259.96 259.96 2.77 JR 01 1 20.91 198.96 219.87 2.12 CM 01 8 0.00 157.66 157.66 1.68 JR 01 8 17.56 311.58 329.14 3.32 KG 01 1 34.55 236.50 271.05 2.52 JT 01 1 18.87 215.85 234.72 2.30 CM 01 8 16.81 179.55 196.36 2.70 CM 01 8 0.00 166.25 166.25 2.50 CM 01 1 0.00 86.45 86.45 1.30 JR 01 8 14.03 365.75 379.78 5.50 CM 01 1 13.99 113.05 127.04 1.70 JR 01 8 12.42 133.00 145.42 2.00 RO XX 8 296.42 4122.25 4418.67 XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX DATE: 06/22/2016 TIME: 03:05 p.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: 9 VEHICLE:: 05-121 VEHICLE: 05-121 VMRS Code METER : STANDARD SUBTOTALS OF VMRS CODES FOR DIVISION > AL QUANTITY LABOR HRS LABOR COST PARTS COST PERIOD : CURRENT TOT COST TOTAL COST PERCENT /METER 001 HEAT & AIR CONDITIONIN 6 5.8 475.86 348.16 824.02 1.90 % 0.60104 002 BODY AND GLASS 14 18.5 2707.92 1320.12 4028.04 9.20 % 2.93803 003 ELEC,INSTRM,LIGHT&CHAS 22 22.2 2419.80 526.05 2945.85 6.70 % 2.14869 004 BATTERY, CHRG & STARTI 10 7.2 692.60 283.55 976.15 2.20 % 0.71200 005 COOLING 12 22.9 1923.25 461.40 2384.65 5.40 % 1.73935 006 FUEL 4 7.3 694.48 663.20 1357.68 3.10 % 0.99028 007 TRANS(MAIN/AUX) PTO/CL 5 4.3 1516.93 1824.49 3341.42 7.60 % 2.43721 008 EMISSION CONTROL 14 35.6 3356.80 205.43 3562.23 8.10 % 2.59827 009 EXHAUST 1 2.4 159.60 120.60 280.20 0.60 % 0.20438 010 ENGINE 1 9.3 874.68 23.59 898.27 2.00 % 0.65519 011 TIRES AND WHEELS 20 17.6 1572.05 893.28 2465.33 5.60 % 1.79820 013 BRAKES 14 19.8 1874.41 753.72 2628.13 6.00 % 1.91694 014 SPECIAL EQUIPMENT 10 18.0 1705.23 2083.45 3788.68 8.60 % 2.76344 015 STEERING AND SUSPENSIO 20 14.9 1830.72 1059.19 2889.91 6.60 % 2.10788 019 MISCELLANEOUS 68 70.6 6554.95 583.84 7138.79 16.20 % 5.20699 020 FILTERS 7 0.3 21.82 57.72 79.54 0.20 % 0.05802 066 PREVENTATIVE MAINTENAN 20 48.0 4122.25 296.42 4418.67 10.00 % 3.22295 TOTALS: 248 324.7 32503.35 11504.21 TOT: 44007.56 100 % 32.09886 /gel) 4;,./i Ng• - 29,4 r. G 7 2g13)/,/ , Z0779 Ad 3'5F 8� 1 AA# 2. JV# CITY OF LODI APPROPRIATION ADJUSTMENT REQUEST TO Internal Services Dept - Budaet Division 3. FROM: Police Department 4 DEPARTMENT/DIVISION 5. DATE 6/21/16 6. REQUEST ADJUSTMENT OF APPROPRIATION AS LISTED BELOW FUND # BUS. UNIT # ACCOUNT # ACCOUNT TITLE AMOUNT A. SOURCE OF FINANCING 403 40300000 55024 Revenue - Other $ 20,463.90 B USE OF FINANCING 403 40399100 77040 Vehicle Replacement Fund $ 20,463.90 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,463.90 to purchase a 2015 For Transit Connect Wagon XLT. The Lodi Police Department will purchase the vehicle and place it into service for Partners' Patrol. If Council has authorized the appropriation adjustment, complete the following: Meeting Date: Res No: Department Head Signature: 1 Attach copy of resolution to this form. B. APPROVAL SIGNATURES 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. 2016-111 A RESOLUTION OF THE LODI CITY COUNCIL AUTHORIZING THE CITY MANAGER TO ACCEPT MONETARY DONATION FROM THE LODI POLICE PARTNERS' FOUNDATION FOR THE PURCHASE OF A VEHICLE AND FURTHER APPROPRIATING FUNDS WHEREAS, the Lodi Police Partners' Foundation, a California non-profit corporation, desires to donate the sum of $20,463.90 to the City of Lodi for the purchase of a 2015 Ford Transit Connect Wagon XLT, VIN No. NMOGE9F70F1198328, for use in the Partners' Program; and WHEREAS, the City Council adopted Resolution No. 2015-54, which provides that when vehicles are purchased by donated funds from the Lodi Police Partners' Foundation and are retired from City's vehicle fleet, the proceeds from the sale or auction of the same will be returned to the Lodi Police Partners' Foundation, or alternatively title to the vehicle will be transferred to the Lodi Police Partners' Foundation, to facilitate the Foundation's continued financial support of the Partners' Program. NOW, THEREFORE, BE IT RESOLVED that the Lodi City Council does hereby authorize the City Manager to accept the monetary donation of $20,463.90 for the purchase of a 2015 Ford Transit Connect Wagon XLT, VIN No. NMOGE9F70F1198328, for use in the Partners' Program from the Lodi Police Partners' Foundation; and BE IT FURTHER RESOLVED that funds in the amount of $20,463.90 are hereby appropriated for the vehicle purchase as shown on the attached Appropriation Adjustment Request Form. Date: July 6, 2016 I hereby certify that Resolution No. 2016-111 was passed and adopted by the Lodi City Council in a regular meeting held July 6, 2016, by the following vote: AYES: COUNCIL MEMBERS — Johnson, Kuehne, Mounce, Nakanishi, and Mayor Chandler NOES: COUNCIL MEMBERS — None ABSENT: COUNCIL MEMBERS — None ABSTAIN: COUNCIL MEMBERS — None NNIFE1 FERRAIOLO ity Clerk 2016-111 1 AA# 2. JV# CITY OF LODI APPROPRIATION ADJUSTMENT REQUEST TO Internal Services Dept - Budaet Division 3. FROM: Police Department 4 DEPARTMENT/DIVISION 5. DATE 6/21/16 6. REQUEST ADJUSTMENT OF APPROPRIATION AS LISTED BELOW FUND # BUS. UNIT # ACCOUNT # ACCOUNT TITLE AMOUNT A. SOURCE OF FINANCING 403 40300000 55024 Revenue - Other $ 20,463.90 B USE OF FINANCING 403 40399100 77040 Vehicle Replacement Fund $ 20,463.90 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,463.90 to purchase a 2015 For Transit Connect Wagon XLT. The Lodi Police Department will purchase the vehicle and place it into service for Partners' Patrol. If Council has authorized the appropriation adjustment, complete the following: Meeting Date: Res No: Department Head Signature: 1 Attach copy of resolution to this form. B. APPROVAL SIGNATURES 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