Loading...
HomeMy WebLinkAboutAgenda Report - September 6, 2017 C-06TM CITY OF LODI COUNCIL COMMUNICATION AGENDA ITEM C-6 AGENDA TITLE: Adopt Resolution Authorizing the City Manager to Accept a Donation from the Lodi Police Foundation of $10,000 Towards the Purchase of a Vehicle for the Community Liaison Officer and Appropriate Funds MEETING DATE: September 6, 2017 PREPARED BY: Chief of Police RECOMMENDED ACTION: Adopt resolution authorizing the City Manager to accept a donation from the Lodi Police Foundation for $10,000 towards the purchase of a vehicle for the Community Liaison Officer and appropriate funds. BACKGROUND INFORMATION: The Lodi Police Department has created a Community Liaison Officer position to assist with the demands of our growing homeless population. This officer's duties include transporting large amounts of personal property, shopping carts and other large items. The vehicle will be outfitted with all necessary emergency equipment including a computer terminal and secure prisoner transportation, allowing the officer to be fully self-sufficient. The department has identified that a four door truck is required to meet these needs. The department reviewed the State of California government vehicle contract for four -door trucks and found that the Ford F150 from Elk Grove Ford met all of the bid specifications including lowest price. In addition, the Ford brand will stay consistent with our current patrol fleet vehicles. The cost of the Ford F-150 is $28,319.73, with an additional $18,196.98 needed for purchase and installation of emergency and electronic equipment. This vehicle will replace interceptor 05-72, a 2004 Chevy Impala. The 2004 Chevy Impala has 96,060 miles and is currently in need of major engine repair estimated to cost over $4,000 which exceeds the current value of the vehicle. The Lodi Police Foundation, a California non-profit corporation, has generously donated $10,000 to the City for use in its purchase of a vehicle for the Community Liaison Officer. Additional funding of $25,000 and $11,516.71 has been appropriated and approved in the 2017/18 General Fund Capital and Vehicle Replacement budget. Staff requests Council accept the Lodi Police Foundation's cash donation and appropriate funding in the amount of $10,000 to the purchase of a 2018 Ford F-150 truck. APPROVED: chwa , City Manager Adopt Resolution Authorizing the City Manager to Accept a Donation from the Lodi Police Foundation of $10,000 Towards the Purchase of a Vehicle for the Community Liaison Officer and Appropriate Funds September 6, 2017 Page Two FISCAL IMPACT: Donation of $10,000 from the Lodi Police Foundation. FUNDING AVAILABLE: Cc: Randy Laney, Fleet Services Supervisor Attachments Transfer from the Police Vehicle Replacement fund's appropriated 2017/18 budgeted of $11,516.71 to account 43100000.50001. Donation of $10,000 account 43100000.57702. Total appropriation of $21,516.71 in account 43199000.77040. aVittuv\C- Andrew Keys Deputy City Manager/Internal Services Director /1/7 T. T; = tterso n Chie of Police TJA Ct1t ' Ja/J Cal eProcure LPA Contract Details Home News/Events FAQ Help - Quicklinks - View Contract Header Contract ID: 1-16-23-20F Contract Type: Statewide Contract Description: Fleet Vehicles, Trucks Begin Date: 02/22/2016 Expire Date: 02/21/2010 Supplier: 0000044085 ELK GROVE FORD Contract Items Lines Status: Approved Acquisition Type: NON -IT Goads Department: DGS -Statewide Procurement Administrator/Buyer: Vanessa Vaughn Phone: Email ID: vanessasaughn@dgs.cagov I View All I I Download First 1-2 of 2 Last Line Item Description EPP/SABRCUOMUOM Description Base Price Category Description Status 1 See Attachment A, Contract Pricing EPP/SABRCEA Each 25100000 Motor vehicles Active 1 See Attachment A, Contract Pricing EPP/SABRCEA Each 25100000 Motorvehides Active Contract Categories Lines I ViewAII I 1 Download First 1 o 1 Last Line Category Description EPP/SABRC Status EPP/SABRC Attachments View Attachments Attached File I View All I I Download First 1-5 of 13 Last View lAttac hment_B= _Bid _Specifi cation_2310-3281.docx 2EI k_G rove_Ford_Qu esti on na i rexlsx 3Downtown_Ford_Questi on na i rexlsx 4 Elk _Grove _Auto_Questiona i rexlsx 5 Freeway_Toyota_Question na i rexlsx View View View View View Share the Link httpsf/caleprocure. ca.gov/PSRelay /ZZ PO.ZZ CTR SU DGS STATE OF CALIFORNIA BID SPECIFICATION FLEET VEHICLES Attachment B 2310-3281 1 SCOPE This specification establishes the minimum requirements for the State of California Fleet Vehicles. These vehicles will be used on highways, city/county roads and shall be designed to operate under typical ambient temperatures (which can range from 10° to 120° F). 2 SPECIFICATIONS AND STANDARDS Specifications and standards referenced in this document in effect on the opening of the Request for Proposal form a part of this specification where referenced. Each vehicle delivered shall be fully compliant with all Federal and State regulations for vehicles in effect as of the date of manufacture. 2.1 DEFINITIONS: • GVWR - Gross Vehicle Weight Rating • CA - Cab to Axle • WB — Wheelbase • 4x2 — Two wheel drive • 4x4 — Four wheel drive • SUV — Sport Utility Vehicle • AWD — All Wheel Drive 2.2 SAFETY: Each vehicle delivered shall conform to the Federal Motor Vehicle Safety Standards (FMVSS) and the California Vehicle Code (CVC) requirements in effect as of the date of manufacture. 2.3 EMISSION CONTROL: The engine shall be California Air Resource Board (CARB) certified to operate on - highway in the State of California at the time of manufacture. Any motor vehicle rated at 8,500 pounds GVWR or less which has a vehicle curb weight of 6,000 pounds or less shall meet or exceed California's Ultra -Low Emission Vehicle II (ULEV II) standards for exhaust emissions (13 CCR 1961). 2.4 BRAKES: All motor vehicle brake friction materials must meet the requirements as identified in Health and Safety Code Section 25250.51 3 REQUIREMENTS 3.1 GENERAL (APPLIES TO ALL VEHICLES): Each vehicle shall be new (unused), current production as specified in the solicitation at the line item description. Vehicles bid must meet or exceed the requirements in the RFP line item description unless stated otherwise. Each vehicle shall be supplied with all equipment and accessories indicated as standard equipment in the manufacturer's published literature (or web site). Optional equipment necessary to meet the minimum requirements of this specification shall be included. Vehicle classifications in this specification or at the line item description are consistent with The U.S. Environmental Protection Agency (EPA) and U.S. Department of Energy (DOE) Fuel Economy Guide found at www.fueleconomy.gov. Vehicles shall be evaluated to ensure that they are listed in the proper class in the Fuel Economy Guide that matches the line item description with the following exceptions: • Sport utility vehicles and passenger vans with a GVWR of more than 10,000 lbs. • Other vehicles with a GVWR of 8,500 lbs. or more • Special Purpose Vehicles shall be included in the evaluations as Vans The following items (supplementing if necessary those items already cataloged as standard equipment) shall be furnished: • Air Conditioning • Automatic Transmission • AM/FM Radio • Original Equipment Manufacturer (O.E.M.) floor mat sets installed in all seating rows where the vehicle comes with carpeted floors If offered by the manufacturer, all vehicles with a GVWR under 10,000 lbs. shall include a mounted spare tire and wheel changing tools (if a full size spare is available, then it shall be included) Wheel weights shall contain no more than 0.1 percent lead by weight (Health and Safety Code Section 25215.6). WRISTON, M. PAGE 1 OF 2 10/30/15 FLEET VEHICLES 2310-3281 Exterior shall be painted with a solar reflective color (white, silver metallic or gold metallic) per Management Memo 12-03 (exceptions are listed in the Memo). 3.2 FUEL TYPES: Specific fuel requirements for each vehicle are found at the line item description in the bid and may include any of the following types: • Gasoline (maximum 87 octane) • Diesel • Flexible Fuel Vehicles (FFV) also called Ethanol or E85 • Compressed Natural Gas (CNG): CNG systems must be O.E.M. or O.E.M. approved • Hybrid -Electric Vehicles (HEV) • Plug-in Hybrid Electric Vehicles (PHEV) • Electric Vehicles (EV) also called Battery Electric Vehicles (BEV) • Fuel Cell Vehicles (FCV) 3.3 CARS Car line items that call for a 5 -door hatchback require a rear door that provides access to a cargo area. Car line items that call for 4 -Doors require a locking trunk that conceals the cargo from view from the outside of the vehicle (a 5 -door "hatchback" will not be accepted). 3.4 VANS Vans that call for "High Ceiling" require at least 76 inches of interior height from floor to ceiling. 3.5 SPORT UTILITY VEHICLES (SUV): All SUVs shall come equipped with a hard top roof. SUVs that call for a minimum cargo volume refers to the cargo volume behind the first row of seats. SUVs that call for "4x4 Off -Road" require a limited slip or locking rear differential and meet the minimum requirement for ground clearance listed in the line item description. 3.6 TRUCKS: Trucks with a GVWR of more than 26,000 lbs. shall come equipped with air brakes. The RFP line item description shall specify the cab configuration which is defined as follows: • Regular: Equipped with 2 doors and seating for 2-3 passengers • Extra: Equipped 3 or 4 doors and seating for 4-5 passengers (rear door(s) are typically less than full size) • Crew: Equipped with 4 full-size doors with center post that can open independently, allow egress of the rear passengers without disturbing the front passenger/driver and seating for 5-6 passengers WRISTON, M. PAGE 2 OF 2 10/30/15 FLEET VEHICLES Prepared For: Lt. Steve Nelson Lodi P.D. Phone: (209) 333-5519 Prepared 14: Dwane Galati' Fleet Sales Officer Phone: (916) 429-4702 2018 Ford F-150 W1C XL 2WD SuperCrew 5.5' Box STATE CONTRACT 1-16-23-20F F.O.B. SACRAMENTO LINE 7 RANK 2 Po21//A0,c9� 01. D z, 3 d o p �; � t Capt. Lk.HFAc k t e1) i ,20 2.. 3o 2'.03c5. G$ 3 l&a nix ea 7 747„, g, 7S 75. 7-ro_ Ft. 1_ y!: rt.ny 73 g 3/(0,73 STANDARD EQUIPMENT STANDARD EQUIPMENT -2018 Fleet/Non-Retail WIC XL 2WD SuperCrew 5.5' Box ENTERTAINMENT • Radio: AM/FM Stereo w/6 Speakers -inc: auxiliary audio input jack (not available w/SYNC) • Radio w/Aux Audio Input Jack • Fixed Antenna • 2 LCD Monitors in The Front EXTERIOR • Wheels: 17" Silver Steel • Tires: P245/70R17 BSW A/S • Regular Box Style • Steel Spare Wheel • Full -Size Spare Tire Stored Underbody w/Crankdown • Clearcoat Paint • Black Front Bumper w/Black Rub Strip/Fascia Accent • Black Rear Step Bumper • Black Side Windows Trim and Black Front Windshield Trim • Black Door Handles • Black Manual Side Mirrors w/Convex Spotter and Manual Folding • Fixed Rear Window • Light Tinted Glass • Variable Intermittent Wipers • Aluminum Panels • Black Grille • Tailgate Rear Cargo Access • Manual Tailgate/Rear Door Lock • Fully Automatic Aero -Composite Halogen Daytime Running Lights Preference Setting Headlamps w/Delay-Off • Cargo Lamp w/High Mount Stop Light Report content is based on current data version referenced. Any performance -related calculations are offered solely as guidelines. Actual unit performance will depend on your operating conditions. GM AutoBook, Data Version: 500.0, Data updated 7/18/2017 © Copyright 1986-2012 Chrome Data Solutions, LP. All rights reserved. Customer File: July 21, 2017 8:59:57 AM Page 2 STANDARD EQUIPMENT STANDARD EQUIPMENT • 2018 Fleet/Non-Retail WIC XL 2WD SuperCrew 5.5' Box INTERIOR • Cloth 40/20/40 Front Seat -inc: 2 -way manual driver/passenger adjustment and armrest • 4 -Way Driver Seat -inc: Manual Recline and Fore/Aft Movement • 4 -Way Passenger Seat -inc: Manual Recline and Fore/Aft Movement • 60-40 Folding Split -Bench Front Facing Fold -Up Cushion Rear Seat • Manual Tilt/Telescoping Steering Column • Gauges -inc: Speedometer, Odometer, Voltmeter, Oil Pressure, Engine Coolant Temp, Tachometer, Transmission Fluid Temp and Trip Odometer • Manual Rear Windows • Front Cupholder • Rear Cupholder • Manual Air Conditioning • HVAC -inc: Underseat Ducts • Glove Box • Interior Trim -inc: Cabback Insulator and Chrome Interior Accents • Full Cloth Headliner • Urethane Gear Shift Knob • Day -Night Rearview Mirror • Passenger Visor Vanity Mirror • 3 12V DC Power Outlets • Fade -To -Off Interior Lighting • Full Vinyl/Rubber Floor Covering • Pickup Cargo Box Lights • Instrument Panel Bin, Dashboard Storage, Driver / Passenger And Rear Door Bins • Manual 1st Row Windows • Outside Temp Gauge • Analog Display • Front Center Armrest • Manual Adjustable Front Head Restraints and Manual Adjustable Rear Head Restraints • Securilock Anti -Theft Ignition (pats) Engine Immobilizer Report content is based on current data version referenced. Any performance -related calculations are offered solely as guidelines. Actual unit performance will depend on your operating conditions. GM AutoBook, Data Version: 500.0, Data updated 7/18/2017 © Copyright 1986-2012 Chrome Data Solutions, LP. All rights reserved. Customer File: July 21, 2017 8:59:57 AM Page 3 STANDARD EQUIPMENT STANDARD EQUIPMENT - 2018 Fleet/Non-Retail WIC XL 2WD SuperCrew 5.5' Box MECHANICAL • Engine: 3.3L V6 PDFI -inc: auto start -stop technology and flex -fuel capability LATE AVAILABILITY for flex -fuel capability. • Transmission: Electronic 6 -Speed Automatic -inc: selectable drive modes: normal/tow-haul/sport • 3.55 Axle Ratio • GVWR: 6280 lbs Payload Package • Transmission w/SelectShift Sequential Shift Control • Rear -Wheel Drive • 70-Amp/Hr 610CCA Maintenance -Free Battery w/Run Down Protection • 200 Amp Alternator • Towing w/Harness and Trailer Sway Control • 1700# Maximum Payload • Gas -Pressurized Shock Absorbers • Front Anti -Roll Bar • Electric Power -Assist Speed -Sensing Steering • Single Stainless Steel Exhaust • 26 Gal. Fuel Tank • Double Wishbone Front Suspension w/Coil Springs • Leaf Rear Suspension w/Leaf Springs • 4 -Wheel Disc Brakes w/4 -Wheel ABS, Front And Rear Vented Discs, Brake Assist, Hill Hold Control and Electric Parking Brake SAFETY • Electronic Stability Control (ESC) And Roll Stability Control (RSC) • ABS And Driveline Traction Control • Side Impact Beams • Dual Stage Driver And Passenger Seat -Mounted Side Airbags • Tire Specific Low Tire Pressure Warning • Dual Stage Driver And Passenger Front Airbags • Airbag Occupancy Sensor • Safety Canopy System Curtain 1st And 2nd Row Airbags • Outboard Front Lap And Shoulder Safety Belts -inc: Rear Center 3 Point, Height Adjusters and Pretensioners • Rear Child Safety Locks • Back -Up Camera Report content is based on current data version referenced. Any performance -related calculations are offered solely as guidelines. Actual unit performance will depend on your operating conditions. GM AutoBook, Data Version: 500.0, Data updated 7/18/2017 © Copyright 1986-2012 Chrome Data Solutions, LP. All rights reserved. Customer File: July 21, 2017 8:59:57 AM Page 4 SELECTED MODEL & OPTIONS SELECTED MODEL - 2018 Fleet/Non-Retail W1C XL 2WD SuperCrew 5.5' Box Code Description W1C 2018 Ford F-150 XL 2WD SuperCrew 5.5' Box SELECTED VEHICLE COLORS - 2018 Fleet/Non-Retail WIC XL 2WD SuperCrew 5.5' Box Code Description Interior: No color has been selected. Exterior 1: No color has been selected. Exterior 2: No color has been selected, SELECTED OPTIONS - 2018 Fleet/Non-Retail WIC XL 2WD SuperCrew 5.5' Box CATEGORY Code Description ENGINE 996 ENGINE: 3.3L V6 PDFI -inc: auto start -stop technology and flex -fuel capability (STD) LATE AVAILABILITY for flex -fuel capability. TRANSMISSION 446 TRANSMISSION: ELECTRONIC 6 -SPEED AUTOMATIC -inc: selectable drive modes: normal/tow-haul/sport (STD) OPTION PACKAGE 100A EQUIPMENT GROUP 100A BASE AXLE RATIO X19 3.55 AXLE RATIO (STD) WHEELS 64C WHEELS: 17" SILVER STEEL (STD) TIRES TIRES: P245/70R17 BSW A/S (STD) PRIMARY PAINT YZ OXFORD WHITE PAINT SCHEME STANDARD PAINT SEAT _•E DARK EARTH GRAY, CLOTH 40/CONSOLE/40 FRONT -SEATS -inc: flow-through console, steering column -mounted shift and 2nd outlet in console when ordered w/11OV/400W outlet (91V) ADDI 1• AL EQUIPMENT XL POWER EQUIPMENT GROUP -inc: Power Glass Sideview Mirrors w/Black Skull Caps, manual -folding, Power Door Locks, flip key and integrated key transmitter keyless -entry (includes Autolock), Illuminated Entry, Power Front & Rear Windows, Perimeter Alarm, Power Tailgate Lock, MyKey w/100A, REQUIRES valid FIN code. 'GROSS* (With the selection of 53C, requires XL Power Equipment Group savings) (With the selection of 53A, requires XL Power Equipment Group savings) Report content is based on current data version referenced. Any performance -related calculations are offered solely as guidelines. Actual unit performance will depend on your operating conditions. GM AutoBook, Data Version: 500.0, Data updated 7/18/2017 © Copyright 1986-2012 Chrome Data Solutions, LP. All rights reserved. Customer File: July 21, 2017 8:59:57 AM Page 5 SELECTED MODEL & OPTIONS SELECTED OPTIONS - 2018 Fleet/Non-Retail W1 C XL 2WD SuperCrew 5.5' Box CATEGORY Code ADDITIONAL 422 Description EQUIPMENT CALIFORNIA EMISSIONS SYSTEM -inc: Required code for California Emissions States registration, Optional code for Cross Border State dealers (Arizona, District of Columbia, Idaho, New Hampshire, Nevada, Ohio, Virginia and West Virginia) (Requires 93N) CLASS IV TRAILER HITCH RECEIVER -inc: towing capability up to 5,000 lbs, on 3.5L Ti -VCT engine (998) and 2.7L EcoBoost engine (99P) or up to 7,000 lbs, on 3.5L EcoBoost engine (99G) and 5.OL V8 engine (99F), smart trailer tow connector and 4-pin/7-pin wiring harness Ordering the Trailer Tow Package does not include Integrated Brake Controller (67T). Integrated Brake Controller (67T) is a standalone option and must be ordered separately. SPRAY -IN BEDLINER (PRE-INSTALLED) -inc: Custom Accessory OPTIONS TOTAL 712 osz, 3J $ 96, So Report content is based on current data version referenced. Any performance -related calculations are offered solely as guidelines. Actual unit performance will depend on your operating conditions. GM AutoBook, Data Version: 500.0, Data updated 7/18/2017 © Copyright 1986-2012 Chrome Data Solutions, LP. All rights reserved. Customer File: July 21, 2017 8:59:57 AM Page 6 SSE / Delivered as Promised NET 30 DAYS s O L D T 0 JANNELLE LODI POLICE DEPARTMENT 310 W ELM ST LODI CA 95240 4707 Northgate Blvd. Sacramento, CA. 95834 Parts Dept. 916-646-6626 Service Dept 916-646-6636 Fax 916-646-6656 GROUND s P 0 ** QUOTATION ** *** DUPLICATE *** Ord # 01 70604 P/0 # HMLS TRK UC LODI POLICE DEPARTMENT 310 W ELM ST LODI CA 95240 Page 1 Br Accnt 00 50888 DF HO 7/05/17 12:44:25 Expires 12/06/2017 Lin 195.0000 195.00 25.0000 25.00 90.4500 180.90 90.4500 180.90 18.9900 18.99 19.0000 1.9.00 423.5000 423.50'. 2195.0000 2195.00 001 1 WH SA315P 1 WH SAK9 2 WH 'VTX609R 2 WH "VTX609B 1 RD NMO-K-DS 1 RD,QWFT120 1 WH HHS2200 1 WHGB2DEDE 1 WH STPKT94 1 SE1K0574FDT15F150PDR PP i' 03-0115 1 LE PKILLMAG 1 SE BK2019FDT15F150 002 004 005 010 011 013 014 015 016 018 019 020 F SIREN SPEAKER F SPEAKER BRACKET 3' VERTEX RED F VERTEX BLUE F COAX CABLE F ANTENNA WHIP F HAND HELD SIREN F LEGACY BAR 54° STRAP KIT 1/2 CAGE F150 F PTRL PWR HARNES E SIREN PARK KILL PB450L4 BUMPER 1 TV"T-FDFsESo-15S'-PW F150 AIL WEATHE amara; fFattrlrawer 6'6" bed all weather T drawers. price includes $205.00 freight 021 1 P3 CF- 5 1 P3 CF5VCGTNFSY 32JLZt NM 023 1 GJ 7160-0393-02 024 1 GJ 14650 025 1 AP.NAV-GWG-A-511-WH 026 1 GJ` 7160-0554 027 1 GJ DS -LOWER -9 028 1 GJ 7160-0178 029 1 GJ 7160-0220 030 1 0J 7160-0230 031 1 LA I CE 53 LAPTOP 022 5YR PROT PLUS F CF -53 DOCK POWER SUPPLY,, AP -NAV 6N F FLOOR' MOUNT F 9 LOWER POLE AS F 7" UPPER POLE F 9" ARM W/TILT SUPPORT BRACE S INSTALLATION 807.2100 807.21' 695.0000 695.00 42.0000 42.00 748.8600 748.86 3758.4100 3758.41 ruckuault standard height 2658.4111 706.2065 1070.4000 112.0000 335.0000 124.8000 46.4000 66.4000 261.6000 59.2000 2018.7500 2658.41 706.20 1070.40 112.00. 335.00 124.80 46.40 66.40 261.60 59.20 2018.75 27 16748.94 150.00 OTAL UMTS:; PART TOTAL CORE TOTAL WWW.LEHRAUTO. COM SALES@LEHRAUTO.COM '. HANDDNO RCVD. BY: 1298.04 OTHER TAi PAY THIS AMOUNT 18196.98 E M S/ P C for The City of Lodi Report Date: 06/06/14 Equip No 05-072 Equip C1 SEDB Cost: Orig Repl nt Master Data Descr SEDAN, 4 DOOR Manuf CHEVROLET' Serial 2G1WF52E849343674 Model IMPALA Yr 2004 Status Dept PD 01 Company Cost Ctr Off Road N Own/Lease 0 Appr Code N Equipment Vendor 1144 Authorisation Replacing 45-082 Warr Exp Date Fuel Card 0 Billing Monthly Cost Insurance Cost Replacement Cost License Cost Monthly Rent 0.00 0.00 0.00 0.00 0.00 18842 Delivery 11/04/04 PM 0 In Sery 12/08/04 Reg Exp Meter 1 Total Miles 15977 Currt Meter 31099 Deliv Meter 15122 Latest Read 11/07/06 Source OPEN ORDER Meter 2 Parking Loc Stored Loc Shop 01 License 2QZW021 CA Type 1-2 Assoc Eq Color SILVER Operator Radio No UNDERCOVER PM Notify Dept PD 01 Purchase Order No CLAIM Disposal Method Buy Rack Was Replaced By Exp Miles (1) 0 Warr Vendor Exp (2) Warr Deductible Date 11/04/04 Last Fuel Loc 01 Asset No Lease Expir 0.00 Page 1 Account Code 101031 Revenue Account 1201031.7851.489E Retired Sold for Est Repl Mo 12 Yr 2008 Rept Code Next Sched Date 12/31/99 Depreciation Next Sched Sery 00 Last Sched Date Last Sched Sery 00 Last Start Date 10/31/06 Meter 1 Last Start 31099 Meter 1 Override 0 Pref Shift Program Type 1 INDIVIDUAL Comments NO WARR, REPL'S 45-082'97 FORD MUSTANG, REPL 4 YRS OR 60,000 Exclude from: Cost Reports N Exception Reports N Inventory Lists N Inspection Data: Inspection Month 12 Next Statutory Inspection 12/2012 Interval 24 Months Additional Inspection Data: Sry Last Sched Last Perf Next Sched Interval Last Work Order Type 1 Type 2 Type 3 Method SL Life Mos 48 Mos Rem 0 Salvage 0 Declining Balance Fuel Type UHL Oil Type 'Lire Type Current Month Usage Tickets NO Shop Priority Shop Status No Open Orders 0 18842.00 e M S/ P C for The City of Lodi Report Date: 06/06/14 Equip No 05-072 Equip C1 SEDB Meter 1 Miles Fuel Gallons Fuel Cost MPG Meter 1 Oi1 Quarts 011 Coot Misc Cost Rep Lab Cost Rep Pte Cost Rep Lab Hours Rep Task Count PM Lab Cost PM Pte Cost PM Lab Hours PM Task Count Deprec Cost Rental Rev Lease Cost Downtime Hours Shop Dept Delay Hours Warr Recovery Descr SEDAN, 4 DOOR Manuf CHEVROLET Model IMPALA Yr 2004 Status Equipment Master Data Serial 2018E52E849343674 Shop 01 License 2QZW021 CA Color SILVER Operator Radio No UNDERCOVER This Mth Pry Mth 1 Pry Mth 2 This Qtr Pry Qtr Pry Qtr 2 Pry Qtr 3 Pry Qtr 4 3578 1394 0 3578 3053 0 1099 1822 15.1 64.4 50.9 15.1 143.5 143.5 76.8 131.0 46.15 193.61 131.04 46.15 382.01 382.01 163,92 315.68 236.95 21.65 0.00 236.95 21.28 0.00 14.31 13.91 0 0 4 0 4 4 0 4 0.00 0.00 5.20 0.00 5.20 5.20 0.00 5.20 9.00 9.00 0.00 9.00 9.00 9.00 4.50 28.00 73.90 0.00 0.00 73.90 76.24 76.24 0.00 0.00 12.34 0.00 0.00 12.34 146.70 146.70 0.00 0.00 2.1 0,0 0,0 2.1 2.5 2.5 0,0 0.0 5 0 0 5 6 6 0 0 86,43 0.00 0.00 86.43 45.74 45.74 0.00 0.00 3.23 0.00 0.00 3.23 3.36 3.36 0.00 0.00 2.5 0.0 0.0 2.5 1.5 1.5 0.0 0.0 1 0 0 1 1 1 0 0 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 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.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 Individual PM Program Service A H C D E 043007 101706 31099 6000 MONTHS MONTHS MONTHS MONTHS MONTHS Next Due Date Last Due Date Meter Last Start Meter Override Time Interval No of Time Units 6 � UJ /rrw(.ry 96.660. 0 G H K L Page 2 Type 1-D Assoc Eq Life 15977 817.6 1906.17 19.54 17 21.90 92.50 a 410.253 WWW M 1)-tv 310.a8 12.8 243?44t &I 277.8 16.51 8.3 5 0.00 0.00 0.00 0.0 0.0 0.0 0.00 N 0 MONTHS MONTHS MONTHS MONTHS MONTHS MONTHS MONTHS MONTHS MONTHS MONTHS 41 zo;7-.5T.8 . 2, Goo. 78 pin Oa" Ur. Y3Z920 id-:= ' s/ sOlci 46 i 28Y 97- DATE: 07/19/2017 TIME: 02:37 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-072 VEHICLE: 05-072 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 1 0.0 0.00 6.49 6.49 0.00 % 0.04807 002 BODY AND GLASS 6 7.1 676.65 365.64 1042.29 9,10 % 7.72067 003 ELEC,INSTRM,LIGHT&CHAS 19 26.3 2513.26 1092.67 3605.93 14.30 % 26.71059 004 BATTERY, CHRG & STARTI 10 10.6 992.46 766.47 1758.93 7.00 % 13.02911 005 COOLING 5 16.4 1552.27 209.54 1761.81 7.00 % 13.05044 006 FUEL 7 26.8 2525.47 351.26 2876.73 11.40 % 21.30911 007 TRANS(MAIN/AUR) PTO/CL 5 23.0 2166.99 85.04 2252.03 8.90 % 16.68170 008 EMISSION CONTROL 6 0.0 831.50 449.75 1281.25 5.10 % 9.49074 009 EXHAUST 1 0.0 0.00 23.85 23.85 0.10 % 0.17667 010 ENGINE 3 3.7 347.48 144.34 491.82 1.90 8 3.64311 011 TIRES AND WHEELS 12 4.6 420.15 1258.32 1678.47 6.60 % 12.43311 012 DRIVE TRAIN 1 0.0 0.00 9.04 9.04 0.00 % 0.06696 013 BRAKES 9 4.3 387.36 243.48 630.84 2.50 % 4.67289 014 SPECIAL EQUIPMENT 8 13.9 989.21 483.45 1472.66 5.80 % 10.90859 015 STEERING AND SUSPENSIO 2 4.8 453.29 72.95 526.24 2.10 % 3.89807 019 MISCELLANEOUS 21 12,3 1200.82 248.28 1449.10 5.70 % 10.73407 020 FILTERS 6 0.5 35.12 37.25 72.37 0.30 % 0.53607 066 PREVENTATIVE MAINTENAN 21 43.4 3786.69 542.51 4329.20 17.10 % 32.06815 TOTALS: 143 197.7 18878.72 6390.33 TOT: 25269.05 100 % 87.17812 V17 /(22/ n SJ DATE: 07/19/2017 TIME: 02:37 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-072 VEHICLE: 05-072 UNIT: 05-072 LF MTH: 96060.0 CUR MTR: 96060.0 YR: 04 MAKE: CHEVROLET DEPT: 10032000 SIZE: 0 CLASS: SED8 FUEL: U VMRS CODE DATE WO NUM LF -MILS ODOM WORK DESCRIPTION OUT PARTS 001 TITLE > HEAT & AIR CONDITION 001-007-000 12082016 0027594 96000 96003 A/C LINE - REPAIR/RE OUT 001 TOTAL >HEAT & AIR CONDITION 002 TITLE > BODY AND GLASS 002-005-000 01252016 0025623 002-005-000 01042016 0025623 002-005-000 02122008 0005604 002-006-000 12142016 0027594 002-006-000 04192012 0018438 002-007-000 02042015 0023742 002 TOTAL >BODY AND GLASS 93210 93207 WINDOW/RELATED PARTS OUT 93040 93038 WINDOW/RELATED PARTS 41360 41360 WINDOW/RELATED PARTS 96000 96003 H000/TRNK LATCH/RELT OUT 70610 70609 HOOD/TANK LATCH/RELT OUT 87160 87164 MIRROR(S) 003 TITLE > ELEC,INSTRM,LIGHT&CH 003-001-000 01072014 0021341 79190 003-001-000 12062013 0021341 78890 003-001-000 06052013 0019571 74440 003-003-000 06022015 0024475 90030 003-003-000 06022015 0024475 90030 003-003-000 06042015 0024475 003-003-000 04242015 0024245 003-003-000 03112015 0023742 003-003-000 08122010 0014526 003-003-000 08122010 0014526 003-003-000 04152010 0013409 003-003-000 05212009 0010460 003-004-000 12022013 0021341 003-004-000 01052011 0015683 003-005-000 04122010 0013409 003-008-000 12062016 0027594 003-012-000 02202014 0021739 003-012-000 02192014 0021739 003-012-000 02202014 0021739 90030 88240 88240 59410 59700 57280 50730 78810 62450 57280 96000 80200 80200 80200 003 TOTAL >ELEC,INSTRM,LIGHT&CH 79187 ALL INSTRN & RELT PA OUT 78899 ALL INSTRM & RELT PA 74445 ALL INSTRM & RELT PA 90025 ALL LIGHTS/SWPICHES/ OUT 90025 ALL LIGHTS/SWTICHES/ 90025 ALL LIGHTS/SWTICHES/ 88236 ALL LIGHTS/SVTICHES/ 88236 ALL LIGHTS/SWTICHES/ OUT 59411 ALL LIGH'PS/SWTICRES/ 59703 ALL LIGHTS/SWTICHES/ 57279 ALL LIGHTS/SWTICHES/ OUT 50729 ALL LIGHTS/SWTICHES/ 78805 WIPER/WASH/RELATED P 62446 WIPER/WASH/RELATED P 57279 WIRING/FUSE - REPLAC 96003 DIST/S PLG/WIRE, NEW OUT 80200 HEADLIGHT - REPAIR/R 80200 HEADLIGHT - REPAIR/R OUT 80200 HEADLIGHT - REPAIR/R 004 TITLE > BATTERY, CHRG & STAR 004-001-000 03032010 0013065 56550 56553 TEST CHRG/START/BATT 6.49 6.49 LABOR 0.00 0.00 TOTAL HOURS MECHANIC CC RC WA 6.49 0.00 6.49 01 1 xx 105.24 0.00 105.24 0.00 01 1 XX 0.00 114,49 114,49 1.22 40 01 1 XX 202.50 0.00 202.50 0.00 01 1 XX 23.44 0.00 23.44 0.00 01 1 XX 34.46 0.00 34.46 0.00 01 8 XX 0.00 562.16 562.16 5.99 MV 01 1 XX 365.64 676.65 1042.29 29.49 0.00 29.49 0.00 01 1 XX 0.00 299.38 299.38 3.19 JW 01 1 XX 0.00 123.88 123.88 1.32 JR 01 12 XX 427.02 0,00 427.02 0.00 01 1 XX 0.00 59.12 59,12 0.63 TN 01 1 XX 0.00 336,92 336.92 3.59 TN 01 1 XX 51.46 0.00 51.46 0.00 01 1 XX 43.50 0.00 43.50 0.00 01 1 XX 0.00 425.14 425.14 4.53 CMc 01 8 XX 0.00 101,35 101.35 1.08 LR XX 8 XX 7.90 0.00 7.90 0.00 01 4 XX 0.00 469.25 469.25 5.00 PB 01 4 XX 7.90 20.64 28.55 0.22 JW 01 1 XX 8.43 1.87 10.31 0.02 CM XX 8 XX 0.00 361.32 361.32 3.85 CMc 01 4 XX 104.27 0,00 104.27 0.00 01 1 XX 0.00 164.23 164.23 1.75 TN 01 1 XX 412.70 0.00 412.70 0.00 01 1 XX 0.00 150.16 150.16 1.60 JR XX 1 XX 1092.67 2513.26 3605.93 0.00 497.40 497.40 5.30 MV 01 4 XX DATE: 07/19/2017 TIME: 02:37 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-072 VEHICLE: 05-072 UNIT: 05-072 LF MTR: 96060.0 CUR MTR: 96060.0 YR: 04 MAKE: CHEVROLET DEPT: 10032000 SIZE: 0 CLASS: SED8 FUEL: U VMRS CODE DATE WO MRA LF -MILS ODOM WORK DESCRIPTION OUT PARTS 004-001-000 01092010 0012562 55500 004-001-000 12212009 0012483 55500 004-001-000 07072008 0007042 43800 004-002-000 07192017 0028827 96000 004-002-000 02092015 0023544 87350 004-002-000 07072008 0007042 43800 004-004-000 03172010 0013065 56600 004-004-000 07182008 0007042 43800 004-010-000 07192017 0028827 96000 004 TOTAL >BATTERY, CHRG & STAR 005 TITLE > COOLING 005-004-000 12122016 0027594 005-004-000 12162016 0027594 005-005-000 12122016 0027594 005-008-000 12122016 0027594 005-008-000 05062016 0026340 005 TOTAL >COOLING 006 TITLE > FUEL 006-004-000 05232013 0019571 006-004-000 05082013 0019571 006-008-000 12072016 0027594 006-009-000 02042015 0023742 006-009-000 12232014 0023544 006-009-000 04102014 0021738 006-009-000 02182014 0021739 006 TOTAL >FUEL 55499 TEST CHRG/START/BATT 55499 TEST CHRG/START/BATT 43796 TEST CHRG/START/BATT 96003 BATTERY - REPLACE 87351 BATTERY - REPLACE 43796 BATTERY - REPLACE 56604 ALTERNATOR - REPLACE OUT 43796 ALTERNATOR - REPLACE 96003 JUMP START 96000 96003 RADIATOR - REPLACE OUT 96000 96003 RADIATOR - REPLACE 96000 96003 THERMOSTAT & GASKET OUT 96000 96003 OTHER COOL SYS REPAI 94360 94364 OTHER COOL SYS REPAI OUT 74350 74347 FUEL PUMP - REPLACE 74320 74322 FUEL PUMP - REPLACE OUT 96000 96003 COMPTR ANLYS OF FUEL 87160 87164 OTHER FUEL SYS SERVI 86940 86936 OTHER FUEL SYS SERVI 81260 81263 OTHER FUEL SYS SERVI 80200 80200 OTHER FUEL SYS SERVI 007 TITLE > TRANS(MAIN/AUX) PTO/ 007-003-000 12032013 0021341 78810 007-003-000 12032013 0021341 78810 007-004-000 02042015 0023742 87160 007-004-000 04092014 0021738 81260 007-004-000 04092014 0021738 81260 007 TOTAL >TRANS(MAIN/AUX) PTO/ 78805 TRANS - REPAIR/REPLA OUT 78805 TRANS - REPAIR/REPLA 87164 TRANS - OTHER REPAIR 81263 TRANS - OTHER REPAIR 81263 TRANS - OTHER REPAIR OUT LABOR TOTAL HOURS MECHIANIC CC RC WA 90.86 288.11 378.98 0.00 167.05 167.05 0.00 0.00 0.00 121.33 0.00 121.33 102.90 0.00 102.90 96.42 39.90 136.32 156.59 0.00 156.59 198.37 0.00 198.37 0.00 0.00 0.00 766.47 992.46 1758.93 135.00 0.00 135.00 46.71 841.83 888.54 6.03 0.00 6.03 0.00 710,44 710.44 21.80 0.00 21.80 209.54 1552.27 1761.81 2.12 206.46 208.58 349.14 0.00 349.14 0.00 619.40 619.40 0.00 284.36 284.36 0.00 792.09 792.09 0.00 443.91 443,91 0.00 179.25 179,25 351.26 2525.47 2876.73 22.02 0,00 22.02 18.06 460.80 478.86 0,00 793.97 793.97 22,94 912.22 935.16 22.02 0.00 22.02 85.04 2166.99 2252.03 008 TITLE > EMISSION CONTROL 008-003-000 02102015 0023544 87470 87469 FUEL EVAPORATIVE SYS OUT 246.38 746.50 3.07 MW 1.78 LR 0.00 CMc 0.00 0.00 0.60 CMc 0.00 0.00 CMc 0.00 0.00 8.97 2N 0.00 7.57 TN 0.00 2.20 MV 0.00 6.60 MV 3.03 MV 8.44 MV 4.73 MV 1.91 JR 0.00 4.91 JW 8.46 hN 9.72 MV 0.00 01 4 01 4 01 4 01 1 01 1 XX 4 01 4 XX 4 01 1 01 1 XX XX 1 XX 01 1 XX 01 1 XX 01 1 xx 01 12 XX 01 12 XX 01 1 xx 01 1 xx 01 1 xx 01 1 XX XX 1 XX 01 1 Y.X. 01 1 XX 01 1 XX 01 1 XX 01 1 XX 992.88 0.00 01 1 XX 7 DATE: 07/19/2017 TIME: 02:37 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/ARV PAGE: 3 VEHICLE:: 05-072 VEHICLE: 05-072 UNIT: 05-072 LF MTR: 96060.0 CUR MTR: 96060.0 YR: 04 MAKE: CHEVROLET DEPT: 10032000 SIZE: 0 CLASS: 8808 FUEL: U VMRS CODE DATE WO MUM LF -MILS ODOM WORK DESCRIPTION OUT PARTS 008-003-000 02052015 008-011-000 09132016 008-011-000 08232016 008-011-000 08042014 008-011-000 02192014 008 TOTAL >EMISSION 0023544 87160 0027057 95530 0027057 95170 0022735 83240 0019571 80200 CONTROL 87164 FUEL EVAPORATIVE SYS OUT 95531 SMOG CHECK/CERTIFICA OUT 95167 SMOG CHECK/CERTIFICA 83244 SMOG CHECK/CERTIFICA OUT 80200 SMOG CHECK/CERTIFICA OUT 009 TITLE > EXHAUST 009-004-000 10092015 0025141 92230 92226 HANGERS/CLAMPS 009 TOTAL >EXHAUST 010 TITLE > ENGINE 010-006-000 05062016 0026340 010-006-000 05022016 0026340 010-008-000 10232007 0004588 010 TOTAL >ENGINE 011 TITLE > TIRES AND WHEELS 011-001-000 04242015 0024245 011-001-000 10062009 0011712 011-002-000 02232010 0012995 011-002-000 10062009 0011712 011-002-000 10232007 0004588 011-003-000 04272015 0024257 011-003-000 04242015 0024245 011-003-000 04302013 0019571 011-003-000 04302013 0019571 011-003-000 08112010 0014526 011-003-000 08262008 0007571 011-003-000 04082008 0006083 011 TOTAL >TIRES AND WHEELS LABOR TOTAL HOURS MECHANIC CC RC WA 203.37 0.00 203.37 0.00 35.00 35.00 0.00 0.00 0.00 0.00 25.00 25.00 0.00 25.00 25.00 449.75 831.50 1281.25 OUT 23.85 0.00 23.85 0.00 94360 94364 ENGINE MOUNT(S) - RE OUT 94360 94359 ENGINE MOUNT(S) - RE' 39400 39398 OIL LEAK - INSPECT/R 88240 88236 TIRES - BALANCE 53910 53906 TIRES - BALANCE 56500 56496 TIRES) - REPAIR/ROT 53910 53906 TIRE(S) - REPAIR/ROT 39400 39398 TIRE(S) - REPAIR/ROT 88240 88236 TIRE(S) - REPLACE OUT 88240 88236 TIRE(S) - REPLACE 74140 74142 TIRE(S) - REPLACE 74140 74142 TIRE(S) - REPLACE OUT 59410 59411 TIRB(S) - REPLACE 44810 44810 TIRE(S) - REPLACE 42390 42392 TIRES) - REPLACE 012 TITLE > DRIVE TRAIN 012-001-000 08162010 0014526 59700 012 TOTAL >DRIVE TRAIN 0.00 0.00 0.00 0.00 0.00 23.85 0.00 23.85 144.34 0.00 144.34 0.00 327.53 327.53 0.00 19.95 19.95 144,34 347.48 491.82 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 33.25 33.25 228.06 0.00 228.06 0.00 230.87 230.87 0.00 105.11 105.11 559.96 0.00 559.96 94.56 30.97 125.53 191.21 13.30 204.51 184.53 6.65 191.18 1258.32 420.15 1678.47 59703 R AXLE SHAFT/SEALS/B OUT 9.04 013 TITLE > BRAKES 013-001-000 12222014 0023544 86940 86936 BRAKE SHOES/PADS -RE 9.04 0.00 0.00 2.01 194.26 0.00 3.49 NV 0,30 RO 0.00 0.00 JT 0.00 JT 0.00 JT 0.50 PE 0.00 2.46 JT 1.12 JR 0.00 0,33 LR 0.20 MV 0.10 CM 9.04 0.00 9.04 O1 1 XX 01 1 XX O1 1 XX 01 11 XX 01 12 XX 01 8 XX 01 1 XX 01 1 XX 01 1 xx 01 1 XX XX 1 XX XX 1 XX xx 1 XX 01 1 XX 01 12 XX 01 1 XX XX 12 XX 01 12 XX XX 8 XX 01 4 XX XX 1 XX 018 XX 196.28 2.07 MV XX 1 XX DATE: 07/19/2017 TIME: 02:37 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-072 VEHICLE: 05-072 UNIT: 05-072 LF MTR: 96060.0 CUR MTR: 96060.0 YR: 04 MAKE: CHEVROLET DEPT: 10032000 SIZE: 0 CLASS: SED8 FUEL: U VMRS CODE DATE WO NUM LF -MILS ODOM WORK DESCRIPTION OUT PARTS 013-001-000 12182014 0023544 013-001-000 12032013 0021341 013-001-000 09012011 0017261 013-001-000 09012011 0017261 013-001-000 09012011 0017261 013-001-000 10242007 0004588 013-002-000 12032013 0021341 013-009-000 12022013 0021341 013 TOTAL >BRAKES 86940 86936 BRAKE SHOES/PADS -RE OUT 78810 78805 BRAKE SHOES/PADS -RE OUT 69250 69253 BRAKE SHOES/PADS -RE 69250 69253 BRAKE SHOES/PADS -RE 69250 69253 BRAKE SHOES/PADS -RE OUT 39400 39398 BRAKE SHOES/PADS -RE 78810 78805 DRUMS/ROTORS - REPLA OUT 78810 78805 BRAKE(S) - OTHER SER 014 TITLE > SPECIAL EQUIPMENT 014-001-000 07102008 0007042 014-001-000 07102008 0007042 014-001-000 10312006 0001143 014-002-000 10232009 0011712 014-002-000 10062009 0011712 014-002-000 10312006 0001143 014-003-000 07012010 0014051 014-003-000 06212010 0014051 014 TOTAL >SPECIAL EQUIPMENT 43800 43796 EMERGENCY LIGHTING 43800 43796 EMERGENCY LIGHTING 31050 31059 EMERGENCY LIGHTING 53910 53906 OTHER SPEC EQP - REP OUT 53910 53906 OTHER SPEC EQP - REP 31050 31059 OTHER SPEC EQP - REP 58530 58534 SPECIAL WIRING - REP OUT 58530 58534 SPECIAL WIRING - REP 015 TITLE > STEERING AND SUMS 015-004-000 08182010 0014526 59700 015-004-000 08122010 0014526 59700 015 TOTAL >STEERING AND SUSPENS 019 TITLE > MISCELLANEOUS 019-001-000 04242015 0024245 88240 019-002-000 07192017 0028827 96000 019-002-000 04072008 0006083 42390 019-002-000 04072008 0006083 42390 019-003-000 04242015 0024245 88240 019-003-000 04102015 0024156 88240 019-003-000 04102015 0024156 88240 019-005-000 01052011 0015683 62450 019-008-000 07192017 0028827 96060 019-010-000 04272015 0024257 88240 019-010-000 04272015 0024257 88240 59703 F WHL BEAR/SEAL-REPA OUT 59703 F NHL BEAR/SEAL-REPA LABOR TOTAL HOURS MECHANIC CC RC WA 62.20 0.00 62.20 30.88 0.00 30.88 0.00 65.69 65.69 0.00 58.18 58.18 50.49 0.00 50.49 41.76 59.85 101.61 56.14 0.00 56.14 0.00 9.38 9.38 243.48 387.36 630.84 0.00 425.60 425.60 0.00 272.65 272.65 0.00 19.95 19.95 473.29 0.00 473.29 0.00 0.00 0.00 0.00 59.85 59.85 6.25 0.00 6.25 3.91 211.16 215.07 483.45 989.21 1472.66 72.95 0.00 72.95 0.00 453.29 453.29 0.00 0.00 0.70 JT 0.62 CM 0.00 0.90 PB 0.00 0.10 JW 6.40 KG 4.10 CMc 0.30 RO 0.00 0.00 JT 0.90 RO 0.00 2.25 CMc 72.95 0.00 453.29 4.83 LR 526.24 88236 ROAD TEST / DIAGNOSI 0.00 0.00 0.00 0.00 96003 SERVICE CALL 0.00 0.00 0.00 0.00 42392 SERVICE CALL 0.00 119.70 119.70 1.80 CM 92392 SERVICE CALL 0.00 73.15 73.15 1.10 PB 88236 COMM TOW - BRING TO OUT 75.00 0.00 75.00 0.00 88236 C014F1 TOW - BRING TO OUT 0.00 75.00 75.00 0.00 88236 COMM TOW - BRING TO OUT 0.00 45.00 45.00 0.00 62446 STEAM CLEAN 0.00 0.00 0.00 0.00 CM 96060 EVAL EQUIP 908 DISPO 0.00 611.90 611.90 6.52 JT 88236 MISCELLANEOUS OUT 3.24 0.00 3.24 0.00 88236 MISCELLANEOUS OUT 170.04 0.00 170.04 0.00 01 1 01 1 01 8 XX 8 01 8 01 1 01 1 01 1 xx xx xx xx XX XX XX XX 01 4 XX 01 4 XX xx 1 xx 01 1 xx XX 1 XX xx 1 xx 01 4 XX 01 4 XX 01 8 XX xx 8 XX 01 1 XX 01 1 XX 01 1 XX 01 1 XX 01 1 XX 01 12 XX 01 12 XX XX 8 XX 01 1 XX 01 12 XX 01 12 XX DATE: 07/19/2017 TIME: 02:37 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-072 VEHICLE: 05-072 UNIT: 05-072 LF MTR: 96060.0 CUR MTR: 96060.0 YR: 04 MAKE: CHEVROLET DEPT: 10032000 SIZE: 0 CLASS: SED8 FUEL: U VMRS CODE DATE WO NUM LF -MILS ODOM WORK DESCRIPTION OUT PARTS LABOR TOTAL HOURS MECHANIC CC RC WA 019-010-000 04272015 0024245 019-010-000 04242015 0024245 019-010-000 04192012 0018438 019-012-000 02232010 0012995 019-012-000 01202009 0009375 019-012-000 10312006 0001143 019-014-000 07122016 0026703 019-014-000 04272015 0024251 019-017-000 04242015 0024245 019-017-000 08122010 0014526 019 TOTAL >MISCELLANEOUS 020 TITLE > FILTERS 020-001-000 09012011 0017261 020-001-000 01052011 0015683 020-001-000 10062009 0011712 020-001-000 05202009 0010449 020-001-000 03212007 0002533 020-003-000 12062016 0027594 020 TOTAL >FILTERS 88240 88236 MISCELLANEOUS 88240 88236 MISCELLANEOUS 70610 70609 MISCELLANEOUS 56500 56496 FIRE EXT - REMOVE/RE 47970 47973 FIRE EXT - REMOVE/RE 31060 31059 FIRE EXT - REMOVE/RE 95030 95029 P 0/0E1, VEH TO COMM 88240 88236 P U/DEL VEH TO COMM 88240 88236 PICK UP PARTS 59700 59703 PICK UP PARTS 69250 69253 AIR FILTER - REPLACE 62450 62446 AIR FILTER - REPLACE 53910 53906 AIR FILTER - REPLACE 50720 50724 AIR FILTER - REPLACE 34440 34440 AIR FILTER - REPLACE 96000 96003 FUEL FILTER - REPLAC OUT 066 TITLE > PREVENTATIVE MAINTEN 066-001-000 11082016 0027473 96000 96003 PM A SERVICE 066-001-000 04192016 0026340 94350 94359 PM A SERVICE 066-001-000 10122015 0025141 92220 92226 PM A SERVICE 066-001-000 12222014 0023544 86940 86936 PM A SERVICE 066-001-000 04092014 0021738 81260 81263 PM A SERVICE 066-001-000 02182014 0021739 80200 80200 PM A SERVICE 066-001-000 04302013 0019571 74320 74322 PM A SERVICE 066-001-000 04192012 0018438 70610 70609 PM A SERVICE 066-001-000 09022011 0017261 69250 69253 PM A SERVICE 066-001-000 01052011 0015683 62440 62446 PM A SERVICE 066-001-000 08112010 0014526 59410 59411 PM A SERVICE 066-001-000 02232010 0012995 56490 56496 PM A SERVICE 066-001-000 10062009 0011712 53900 53906 PPI A SERVICE 066-001-000 05202009 0010449 50720 50729 PM A SERVICE 066-001-000 01202009 0009375 47970 47973 PM A SERVICE 066-001-000 08262008 0007566 44780 44779 PM A SERVICE 0.00 0.00 0.00 0.00 0.00 0,00 0.00 37.54 37.54 0.00 0.00 0.00 0.00 0.00 0.00 0.00 13.30 13.30 0.00 106.05 106.05 0.00 119.18 119.18 0.00 0.00 0.00 0.00 0.00 0.00 248.28 1200.82 1449.10 6.00 1.87 7.87 6.00 0.00 6.00 0.00 0.00 0.00 6.08 0.00 6.08 5.46 33.25 38.71 13.71 0.00 13.71 37.25 35.12 72.37 16.29 180.19 196.48 16.27 153.91 170.19 17.21 176.43 193.65 26.64 139.83 166.47 6.08 191.45 197.51 17.43 190.51 207.94 17.79 149.22 167.01 17.73 142.65 160.38 25.81 270.28 296.10 21.53 228.05 249.58 19.02 148.28 167.30 13.81 154.85 168.66 20.53 666.33 686.86 14.11 150.16 164.27 14.70 139.65 154.35 13.44 73,15 86.59 0.00 01 1 XX 0.00 01 1 XX 0.40 JR 01 8 XX 0.00 JT 01 1 XX 0.00 JR XX 8 XX 0.20 RO XX 1 XX 1.13 LR 01 1 XX 1.27 MV 011 XX 0.00 01 1 xx 0.00 LR XX 8 XX 0.02 CM 0.00 CM 0.00 JT 0.00 CM 0.50 RO 0.00 XX 8 XX XX 8 XX XX 1 XX XX 8 XX. XX 1 XX 01 1 XX 1.92 JR 01 1 XX 1.64 JR 01 1 XX 1.88 JR 01 8 XX 1.49 MV 01 1 XX 2.04 JR 01 1 XX 2.03 JR 01 1 XX 1.59 JR 01 12 XX 1.52 JR 01 8 XX 2.88 CM 01 8 XX 2.43 CM 01 8 XX 1.58 LR 01 8 XX 1.65 JT 01 1 XX 7.10 JT 01 1 XX 1.60 CM 01 8 XX 2.10 JR 01 8 XX 1.10 RV 01 8 XX DATE: 07/19/2017 TIME: 02:37 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-072 VEHICLE: 05-072 UNIT: 05-072 LF MTR: 96060.0 CUR MTR: 96060.0 YR: 04 MAKE: CHEVROLET DEPT: 10032000 SIZE: 0 CLASS: SEDO FUEL: 0 VMRS CODE DATE WO NUM LF -MILS ODOM WORK DESCRIPTION OUT PARTS LABOR TOTAL HOURS MECHANIC CC RC WA 066-001-000 04072008 0006083 42390 42392 PM A SERVICE 066-001-000 04072008 0006083 42390 42392 PM A SERVICE 066-001-000 10232007 0004585 39390 39398 PM A SERVICE 066-001-000 03212007 0002533 34440 34440 PN A SERVICE 066-001-000 10312006 0001143 31090 31099 914 A SERVICE 066 TOTAL >PREVENTATIVE MAINTEN 216.37 186.20 402.57 2.80 JR 0.00 39.90 39.90 0.60 CM 12.28 86.45 98.73 1.30 JR 11.27 106.40 117.67 1.60 RO 24.20 212,80 237.00 3.20 CM 542.51 3786.69 4329.20 01 1 XX 01 1 XX 01 8 XX XX 1 xx XX 1 xx RESOLUTION NO. 2017-164 A RESOLUTION OF THE LODI CITY COUNCIL AUTHORIZING THE CITY MANAGER TO ACCEPT A DONATION OF CASH FROM THE LODI POLICE FOUNDATION FOR THE PURCHASE OF A VEHICLE FOR THE COMMUNITY LIAISON OFFICER; AND FURTHER APPROPRIATING FUNDS WHEREAS, the Lodi Police Department has created a Community Liaison Officer position to assist with the demands of our growing homeless population; and WHEREAS, the officer's duties include transporting large amounts of personal property, as well as shopping carts and other large items; and WHEREAS, the Department has reviewed several vehicles available under the State of California government vehicle contracts and has priced a Ford F-150 truck at a cost of $28,319.73 from Elk Grove Ford, a State of California contract dealer; and WHEREAS, the vehicle will be outfitted with all necessary emergency equipment, including a computer terminal and secure prisoner transportation, at a cost of $18,196.98, for a total vehicle cost of $46,516.71; and WHEREAS, the Lodi Police Foundation, a California non-profit corporation, desires to donate the sum of $10,000 to the City for the purchase of a 2018 Ford F-150 truck, for use by the Community Liaison Officer; and WHEREAS, this vehicle will replace Interceptor No. 05-72, a 2004 Chevy Impala. NOW, THEREFORE, BE IT RESOLVED that Lodi City Council does hereby authorize the City Manager to accept the $10,000 cash donation from the Lodi Police Foundation towards the purchase of a 2018 Ford F-150 truck, for use by the Community Liaison Officer; and BE IT FURTHER RESOLVED that funds in the amount of $10,000 be appropriated for the vehicle purchase from account 43100000.57702; and BE IT FURTHER RESOLVED that additional funding of $25,000 has been allocated and approved in the 2017/18 general fund capital budget (43199000.77040); and BE IT FURTHER RESOLVED that additional funding of $11,516.71 has been appropriated and approved in the 2017/18 police vehicle replacement fund (40399100.77040) for this purchase. Date: September 6, 2017 I hereby certify that Resolution No. 2017-164 was passed and adopted by the Lodi City Council in a regular meeting held September 6, 2017, by the following vote: AYES: COUNCIL MEMBERS — Chandler, Johnson, Mounce, Nakanishi, and Mayor Kuehne NOES: COUNCIL MEMBERS — None ABSENT: COUNCIL MEMBERS — None ABSTAIN: COUNCIL MEMBERS — None NIFER qty Clerk 2017-164 /11,21---QAAA-L4 FERRAIOLO