Loading...
HomeMy WebLinkAbout12/09/20131. 2. 3. 4. FINANCE COMMITTEE December 9, 2013 5:00 p.m. Council Chambers Roll Ca11: Members: Chairperson Carolyn Cole Steve Schmitt Quentin Hart Approval of Agenda, as proposed. Approval of Minutes of December 2, 2013. NEW BUSINESS Travel Requests Name & Title of Class/Meeting Amount not Personnel Destination Date(s) to Exceed Sgt. Melissa Ludwig Traumas of Law St. Paul, MN 2/23/14- 633.00 E Enforcement 2/26/14 Michael Wilson, Interview Aberdeen, SD 12/9/13- 860.00 Director of Aviation 12/10/13 Candidate Michael Clow, Interview Morgantown, 12/16/13- 795.00 Director of Aviation WV 12/17/13 Candidate Pre Authorizations to Expend over $1,000.00 Dept. Amount + Est. S/H Expenditure Building Maint $1,125.00 Rental of Power washer for power washer at E 5th Parking Ramp Building Maint $2,065.00 Professional Services for Police Evidence Storage Building Remodel Leisure Services $1,125.00 Miscellaneous janitorial equipment to be utilized at the Cedar Valley SportsPlex Parking Maint $4,500.00 4 double and 1 single meter and hardware Police $24,000.00 Eight Panasonic laptop computers with docking stations for police patrol cars Police $20,384.00 Thirty two cradlepoint broadband units with power supply & antenna Police $5,600.00 Flashback DVR collision sensors for all patrol vehicles Traffic $1,200.00 Replace failing or burnt out Yellow, Green and Yellow Operations arrow LEDS WMS $3,936.20 Body repair work on 2008 Ford Ranger #220803 BILLS PAYMENT ADJOURNMENT Suzy Schares City Clerk FINANCE COMMITTEE December 2, 2013 5:10 p.m. Council Chambers Members present: Cole, Schmitt, Hart. Moved by Hart, seconded by Schmitt that the Agenda, as proposed, be approved. Ayes: Three. Motion carried. Moved by Hart, seconded by Schmitt that the Minutes of November 25, 2013, as proposed, be approved. Ayes: Three. Motion carried. Moved by Schmitt, seconded by Cole that the request for the following travel requests, be approved. Travel Requests Name & Title of Personnel Class/Meeting Destination Date(s) Amount not to Exceed Tom Lind & Patrick Morrissey, Iowa League of Cities Ankeny, IA 12/14/13 / $350.00 Council Elect Municipal Leadership Conference Independence, IA 12/07/13 Mohammad Elahi, Traffic Brown Traffic 2013 Davenport, IA 12/09/13- $290.00 Engineer User's Group 12/11/13 Ayes: Three. Motion carried. Moved by Hart, seconded by Schmitt that the request for the following pre -authorizations to expend over $1,000.00, be approved. Pre -Authorizations to Expend over $1,000.00 Dept. Amount + Est. S/H Expenditure Leisure Services $4,250.00 Employee module upgrade to the time keeping system Leisure Services $8,300.00 A rider scrubber and smaller cylindrical scrubber for the Cedar Valley SportsPlex Leisure Services $2,515.00 Padlocks and combination software program for Club Lockers at the Cedar Valley SportsPlex Mayor $3,150.00 Fees for putting on two goal setting sessions. The first, 1/7/14 with department heads the second, 1/23/14 is for Council Planning $2,700.00 (2) ArcGIS for Desktop Basic Single Use License at $1,350.00 each Police $10,000.00 Police K-9 dog for the Police Department K-9 unit Police $6,397.00 Renewal of SNS Vcenter server foundation and Vsphere agreement Police $20,960.25 Twenty-five (25) Dell Opti Plex Desktop computers with monitors Police $3,400.00 Paint walls at the police training center Police $2,975.00 Paint the walls of the first floor of the Police Department Police $3,330.71 + 64.99 Equipment to install in police patrol vehicle for transporting of a police K-9 Street $1,814.80 Snow fence and posts Traffic Operations $2,500.00 NTE Shelving for signs in Public Works Building paint and sign shop Finance Committee December 2, 2013 Page 2 Ayes: Three. Motion carried. Mr. Schmitt voted Nay on the request by the Mayor for the goal setting session. Mr. Schmitt mentioned that the goal setting session is supported but he would prefer to use UNI or a local person. Moved by Cole, seconded by Hart that the project budget for the Bullet Proof Vests allocation, funded 50% with a federal grant in the amount of $3,278.12 and 50% with bond funds, be approved. Ayes: Three. Motion carried. Moved by Cole, seconded by Hart the project budget for the Law Enforcement Terrorism Prevention grant with federal funding in the amount of $48,353.00, be approved. Ayes: Three. Motion carried. Moved by Cole, seconded by Hart that Bills Payment, as contained in Accounts Payable Invoice Report, dated December 2, 2013, in the amount of $2,018,261.33, be received, placed on file and approved and forwarded to the full council for approval. Ayes: Three. Motion carried. With no further business before the committee, it was moved by Hart, seconded by Schmitt that the meeting be adjourned at 5:15 p.m. Ayes: Three. Motion carried. Suzy Schares City Clerk City Clerk Use Only Finance Committee 12,19 Approval Date City of Waterloo Expenditure Pre -Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Building Maint Department to expend $ 1,125.00 plus est. shipping costs of $ to pay for or purchase This purchase or expenditure is being made because: Rental of Power Washer for power washer at E 5th Parking Ramp Vendor selected for this purchase: Black Hawk Rental n Bids or written quotes were taken on this purchase, as follows: Q Bids or quotes were not taken on this purchase because: Power washing was done by city employees Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: nGeneral Fund ❑ Road Use Tax ❑ Sewer ❑ Sanitation riBonds El Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 411-22-7960-246e— (Fund - Department - Activity - Account Number) in which the budgeted amount is and the current available balance is tfully s - itted, nature Dept. Head or Designee) (Project Code) $ ! (lvv $� 3/61 cl72' a,/1.f2ediA Date (Signature F ance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) City of Waterloo Expenditure Pre -Authorization Request Form City Clerk Use Only Finance Committee Approval Date 12-11/i 3 The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Building Maint Department to expend $ 2,065.00 plus est. shipping costs of $ to pay for or purchase This purchase or expenditure is being made because: Professional Services for Police Evidence Storage Building Remodel Vendor selected for this purchase: Struxture Architects ❑ Bids or written quotes were taken on this purchase, as follows: O Bids or quotes were not taken on this purchase because: Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: • General Fund n Road Use Tax Sewer n Sanitation QX Bonds n Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 407-22-8800-2152 (Fund - Department - Activity - Account Number) in which the budgeted amount is (Project Code) $ X i and the current available balance is $ RespegetfuIly sclbyAitted, , L-i-(LL L(:�C �(,i Z /13;a/3 ead or Designee) Date (ign ture Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) City Clerk Use Only Finance Committee I� Approval Date 17-/4// Zj City of Waterloo Expenditure Pre -Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Leisure Services Department to expend $ 1,125.00 plus est. shipping costs of $ na to pay for or purchase miscellaneous janitorial equipment to be utilized at the Cedar Valley SportsPlex. This purchase or expenditure is being made because: these items will be used to assist in cleaning of the facility. Vendor selected for this purchase: Capital Sanitary Supply (Hiawatha, IA) x Bids or written quotes were taken on this purchase, as follows: Capital Sanitary supply (Hiawatha, IA) $1,125.00 Martin Brothers (Cedar Falls, IA) $1,193.15 Weber Paper (Cedar Falls, IA) $1,271.02 Bids or quotes were not taken on this purchase because: Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: x General Fund Bonds Road Use Tax Federal/other grants n Sewer Other (specify) Sanitation This expenditure is to be coded to the following budget line -item: 426-37-4202-2178 37SPLX-GIFT (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is $ 1,984,192.00 and the current available balance is $ 831,411.00 Respectfully submitted, .c O (Signature Dept. Head or Designee) t/ t zco t ))J,./ 'lam l//erI'Jt 2 //'gt W3 Date 7) (Signature Finance Dept. Review) Date K:\shared goodies\forms\misc janitorial.xls (Mar 2010) City Clerk Use Only Finance Committee / Approval Date r12' 7 9/i City of Waterloo Expenditure Pre -Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Parking Maintenal Department to expend $ NTE 4,500.00 plus est. shipping costs of $ 200.00 to pay for or purchase 4 double and 1 single meter and hardware This purchase or expenditure is being made because: Replace meters on Jefferson St. between W. 4th and Park Ave. Vendor selected for this purchase: POM �X Bids or written quotes were taken on this purchase, as follows: POM Russellville, AR $4,441.42 ❑ Bids or quotes were not taken on this purchase because: Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: ❑ General Fund ❑ Road Use Tax ❑ Sewer ❑ Sanitation ❑X Bonds Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 412-17-7910-2126 (Fund - Department - Activity - Account Number) in which the budgeted amount is and the current available balance is (Sir 241/41/.0 ure Dept. He Respectfully submitted, Si na ?eA✓ or Designee) (Project Code) $ 70,000.00 $ 61,564.85 q i'S (/,lilt LeiZt &, /A /1..6LO %2-47Z:43 ate (Signature Finance Dept. Review) Date K:\shared goodies\forms\2013-December-Expenditure Pre -Authorization - Parking Meters & Hardware for Jefferson St. - PM.xls (Mar 2010) City Clerk Use Only Finance Committee Approval Date ( /1/ . City of Waterloo Expenditure Pre -Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Police Department to expend $ 24,000.00 plus est. shipping costs of $ 0.00 to pay for or purchase eight Panasonic laptop computers with docking stations for police patrol cars. This purchase or expenditure is being made because: these computers are to replace aging and older units that are at the end of their workable life cycle. Vendor selected for this purchase: CDW-G ❑ Bids or written quotes were taken on this purchase, as follows: n Bids or quotes were not taken on this purchase because: this price is the State of Iowa Bid price. CDW-G has that bid. Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: ❑x General Fund ❑ Road Use Tax ❑ Sewer ❑ Sanitation Bonds ❑ Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 411-11-1100-2106 (Fund - Department - Activity - Account Number) in which the budgeted amount is and the current available balance is (Project Code) $ /077 OO)�� $ ;,( I 8'7e) Respectfully submitted, 1/-z62-/$ i„t -:��� (Si� Ddpt. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre -Authorization (Mar 2010) City Clerk Use Only Finance Committee Approval Date 1 . R /� City of Waterloo Expenditure Pre -Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Police Department to expend $ 20,384.00 plus est. shipping costs of $ 0.00 to pay for or purchase thirty two cradlepoint broadband units with power supply and antenna. This purchase or expenditure is being made because: these units will be installed in the police patrol vehicles to connect the in car computers to the wireless network that allows communication between the PD and the vehicles. Vendor selected for this purchase: CDW-G n Bids or written quotes were taken on this purchase, as follows: CDW-G $20,384.00 DH Wireless services $28,863.70 ❑ Bids or quotes were not taken on this purchase because: Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: ❑X General Fund ❑ Road Use Tax n Sewer Bonds ❑ Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 411-11-1100-2106 (Fund - Department - Activity - Account Number) in which the budgeted amount is and the current available balance is Respectfully submitted, (Signafu�e Dept. Head or Designee) Sanitation (Project Code) $ /CC'CcC Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre -Authorization (Mar 2010) City Clerk Use Only Finance Committee Approval Date //q%3 City of Waterloo Expenditure Pre -Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Police Department to expend $ 5,600.00 plus est. shipping costs of $ 100.00 to pay for or purchase Flashback DVR collision sensors for all patrol vehicles. This purchase or expenditure is being made because: this purchase will trigger automatic recording of patrol vehicle DVR's in the event of a vehicle collision during routine and emergency driving. Vendor selected for this purchase: L3 Mobile -Vision, Inc. ❑ Bids or written quotes were taken on this purchase, as follows: ❑x Bids or quotes were not taken on this purchase because: L-3 Mobile -Vision, Inc. is the sole provider of the digital recording equipment that is in all the patrol vehicles of the department. This equipment is an add on to that equipment. Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: O General Fund ❑ Road Use Tax ❑ Sewer n Sanitation ▪ Bonds n Federal/other grants n Other (specify) This expenditure is to be coded to the following budget line -item: 412-11-1100-2127 (Fund - Department - Activity - Account Number) in which the budgeted amount is and the current available balance is spectfully submitted, (Project Code) $ /CCU vCG $ (Signat re Dept. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre -Authorization (Mar 2010) City of Waterloo Expenditure Pre -Authorization Request Form City Clerk Use Only Finance Committee / Approval Date 1 4 / � The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Traffic Operations Department to expend $ NTE $1,200.00 plus est. shipping costs of $ to pay for or purchase Programmable LEDs This purchase or expenditure is being made because: Replace failing or burnt out Yellow, Green and Yellow arrow LEDs Vendor selected for this purchase: Brown Traffic Products ❑X Bids or written quotes were taken on this purchase, as follows: Brown Traffic Products, Inc. Davenport, IA $1,050.50 ❑ Bids or quotes were not taken on this purchase because: Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: General Fund ❑ Road Use Tax 0 Sewer ❑ Sanitation Bonds FederaVother grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 412-17-7161-2125 (Fund - Department - Activity - Account Number) in which the budgeted amount is and the current available balance is (Project Code) $ 60,000.00 V $ 56,359.50 Respectfully submitted, r // f��° U �/t/ -J /r L� Iua ii� �a:r /.- 2of3 ig ature Dept. H Tor Designee) Date ( ignature Finance Dept. Review) Date K:\shared goodies\forms\2013-December-Expenditure Pre -Authorization - Programmable LEDs.xls (Mar 2010) City of Waterloo Expenditure Pre -Authorization Request Form City Clerk Use Only Finance Committee Approval Date f Z/1►// ?% The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the WMS Department to expend $ 3,936.20 plus est. shipping costs of $ 0.00 to pay for or purchase Body repair work on 2008 Ford Ranger #220803 This purchase or expenditure is being made because: Body damage to bed assy and tailgate assy Vendor selected for this purchase: Cedar Valley Motors & Collision Center LLC n Bids or written quotes were taken on this purchase, as follows: Two written quotes taken. Cedar Valley Motors & Collision Center total cost of $3,936.20 and Iowa Auto Rebuilers total cost of $8,409.02 n Bids or quotes were not taken on this purchase because: Prior Committee Actions (Dates): None Please check the following box(es) as appropriate to describe the funding for this expense: ElGeneral Fund n Road Use Tax ❑ Sewer n Sanitation 0 Bonds ri Federal/other grants Other (specify) This expenditure is to be coded to the following budget line -item: 525-15-5400-1569 (Fund - Department - Activity - Account Number) in which the budgeted amount is and the current available balance is Respectfully submitte (Project Code) $ 143, 000.00 4/- $ 77,701.21 GJ-C n'E; rra ip c/-oreie (Si nature CSept. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Body repair 2008 Ford Ranger #220803.xls (Mar 2010) 'Sep 1813 10:34a Coda r Valley Motors 3q 36 319-274-4075 p.2 CEDAR VALLEY MOTORS & COLLISION CENTER 3075 BURTON AVENUE, WATERLOO, IA 50703 Phone: (319) 233-1072 FAX: (319) 274-4075 Preliminary Estimate Workfile ID: 1871ecld Federal ID: 41-2189680 Resale Number: 1-07-037448 Customer: City of Waterloo lob Number: Written By: lOm Williams Insured: Type of Loss: Point of Impact: City of Waterloo Policy #: Date of Loss: Claim 1: Days to Repair: 0 Owner: Inspection Location: Insurance Company: City of Waterloo CEDAR VALLEY MOTORS & COLLISION CENTER 715 Mulberry Street 3075 BURTON AVENUE Waterloo, IA 50702 WATERLOO, IA 50703 Repair Facility (319) 233-1072 Business VEHICLE Year: 2008 Body Style: 2D P/U VIN: 1FTYR14U68PA26455 Mileage In: Make: FORD Engine: 6-3.0L-Ft License: #220803 Mileage Out: Model: RANGER 4X2 SUPERCAB Production Date: 9/2007 State: IA Vehicle Out: Color: White Int: Condition: lob #: TRANSMISSION Dual Mirrors Stereo Styled Steel Wheels Overdrive Console/Storage Search/Seek PAINT 5 Speed Transmission CONVENIENCE SAFETY Clear Coat Paint POWER Intermittent Wipers Drivers Side Air Bag TRUCK Power Steering RADIO Passenger Air Bag Rear Step Bumper Power Brakes AM Radio Anti -Lock Brakes (4) DECOR FM Radio WHEELS 9/18/2013 10:50:00 AM 068727 Page 1 Sep 1813 10:34a Cedar Valley Motors 319-274-4075 p3 r Preliminary Estimate Customer: City of Waterloo Job Number: Vehide: 2608 FORD RANGER 4X2 SUPERCAB 2D P/U 6-3.OL-i-I White Line Oper Description Part Number Qty Extended Labor Paint Price $ 1 PICK UP BOX 2 = Repl LKQ bed assy; short bed 3 x Add for Clear Coat 4 * Rep1 LKQ tailgate assy 5 Overlap Major Non-Adj. Panel 6 » Add for Clear Coat 7 # Spray -in Bed liner 8 REAR BUMPER 9 * Rep LKQ bumper assy; painted 6L5Z99285088 L 800.09 6L5Z9940700AA 1 150.00 1 450.00 4L527.7906DA 1 175.00 SUBTOTALS 1,525.00 2.5 0.8 0.6 3.9 14.9 5.6 3.0 -0.2 0.6 0..0 23.0 ESTIMATE TOTALS Category Basis Rate Cost $ Parts 1,525.00 Body Labor 3.9 hrs @ $ 58.90 /hr 226.20 Paint Labor 23.0 hrs © $ 58.00 /hr 1,334.00 Paint Supplies 23.0 hrs @ $ 37.00 /hr 851.00 Subtotal 3,936.20 Grand Total 3,936.20 Deductible 0.00 CUSTOMER PAY 0.00 INSURANCE PAY 3,936.20 All workmanship including welding, metal, body, paint and glass has a one year warranty on repairs. No warranty on rust repairs. THANK YOU FOR CHOOSING CEDAR VALLEY COLLISION CENTER. SIGNATURE DATE 9/18/2013 10:50:00 AM 068727 Page 2 Sep 1813 10:34a Cedar Valley Motors 319-274-4075 p.4 Preliminary Estimate Customer: City of Waterloo Job Number: Vehicle: 2008 FORD RANbtR 4X2 SUPERCAB 2D P/U 6-3.0L-F1 White Estimate based on MOTOR CRASH ESTIMATING GUIDE. Unless otherwise noted all items are derived from the Guide DR2MD98, CCC Data Date 9/16/2013, and the parts selected are OEM -parts manufactured by the vehicles Original Equipment Manufacturer. OEM parts are available at OE/Vehicle dealerships. OPT OEM (Optional OEM) or ALT OEM (Alternative OEM) parts are OEM parts that may be provided by or through alternate sources other than the OEM vehicle dealerships. OPT OEM or ALT OEM parts may reflect some specific, special, or unique pricing or discount. OPT OEM or ALT OEM parts may include 'Blemished" parts provided by OEM's through OEM vehicle dealerships. Asterisk (*) or Double Asterisk (**) indicates that the parts and/or labor information provided by MOTOR may have been modified or may have come from an alternate data source. Tilde sign («) items indicate MOTOR Not -Included Labor operations. The symbol (<>) indicates the refinish operation WILL NOT be performed as a separate procedure from the other panels in the estimate. Non -Original Equipment Manufacturer aftermarket parts are described as Non OEM or NM. Used parts are described as LKQ, RCY, or USED. Reconditioned parts are described as Recond. Recored parts are described as Recore. NAGS Part Numbers and Benchmark Prices are provided by National Auto Glass Specifications. Labor operation times listed on the line with the NAGS information are MOTOR suggested labor operation times. NAGS labor operation times are not included. Pound sign (#) items indicate manual entries. Some 2014 vehicles contain minor changes from the previous year. For those vehides, prior to receiving updated data from the vehicle manufacturer, labor and parts data from the previous year may be used. The CCC ONE estimator has a complete list of applicable vehicles. Parts numbers and prices should be confirmed with the local dealership, The following is a list of additional abbreviations or symbols that may be used to describe work to be done or parts to be repaired or replaced: SYMBOLS FOLLOWING PART PRICE: m=MOTOR Mechanical component. s=MOTOR Structural component. T=Miscellaneous Taxed charge category. X=Miscellaneous Non -Taxed charge category. SYMBOLS FOLLOWING LABOR: D=Diagnostic labor category. E=Electrical labor category. F=Frame labor category. G=Glass labor category. M=Mechanical labor category. S=Structural labor category. (numbers) 1 through 4=User Defined Labor Categories. OTHER SYMBOLS AND ABBREVIATIONS: Adj.=Adjacent. Algn.=Align. ALU=Aluminum. A/M=Aftermarket part. Bind -Blend. BOR=Boron steel. CAPA=Certified Automotive Parts Association. D&R=Disconnect and Reconnect. HSS=High Strength Steel. HYD=Hydroformed Steel. Incl.=Included. LKQ=Like Kind and Quality. LT=Left. MAG=Magnesium. Non-Adj.=Non Adjacent. NSF=NSF International Certified Part. O/H=Overhaul. Qty=Quantity. Refn=Refinish. Repl=Replace. R&I=Remove and Install. R&R=Remove and Replace. Rpr=Repair. RT=Right. SAS=Sandwiched Steel. Sect=Section. Subl=Sublet. UHS=Ultra High Strength Steel. N=Note(s) associated with the estimate line. CCC ONE Estimating - A product of CCC Information Services Inc. The following is a list of abbreviations that may be used in CCC ONE Estimating that are not part of the MOTOR CRASH ESTIMATING GUIDE: BAR=Bureau of Automotive Repair. EPA=Environmental Protection Agency. NHTSA= National Highway Transportation and Safety Administration. PDR=Paintless Dent Repair. VIN=Vehicle Identification Number. 9/18/2013 10:50:00 AM 068727 Page 3 Damage Assessed By: CHRIS FLOSS Condition Code: Deductible: Claim Number: Owner: Description: Body Style: VIN: Mileage: OEM/ALT: Color: Options: Line Entry Labor Item Number Type 1 706298 FRM 2 701267 REF 3 900500 BDY* 4 706164 BDY 5 705495 BDY 6 706170 BDY 7 AUTO BDY 8 704929 BDY 9 703328 BDY 10 706687 BDY 11 706688 BDY 12 701543 BDY 13 701544 BDY 14 703283 BDY 15 703284 BDY 16 706691 BDY 17 706692 BDY 18 704827 BDY 19 AUTO REF 20 900500 BDS* 21 AUTO 22 AUTO 23 AUTO Good UNKNOWN UNIT 220803 CITY OF WATERLOO IOWA AUTO REBUILDERS 2550 Ranchero Rd, Waterloo, IA 50701 (319) 234-5546 Fax: (319) 234-4678 Email: iaauto@iaautorebuilders.com Tax ID: 42-1344630 Mitchell Service: 917623 Date: Estimate ID: Estimate Version: Preliminary Profile ID: 2008 Ford Ranger XL Vehicle Production Date: 9/07 2D PkupXCb 6' Bed 125" WB Drive Train: 3.OL Inj 6 Cyl 2WD 1FTYR14U6BPA26455 License: 109880 IA 38,409 0 Search Code: B223772 WHITE PASSENGER AIRBAG, DRIVER AIRBAG, POWER STEERING, ANTI -LOCK BRAKE SYS., V6 ENGINE FRONT AIR DAM, TINTED GLASS, ANTI -THEFT SYSTEM, FRONT SPLIT BENCH SEAT Operation REMOVE/REPLACE REFINISH REMOVE/REPLACE REMOVE/REPLACE REMOVE/REPLACE REMOVE/REPLACE OVERHAUL REMOVE/REPLACE REMOVE/REPLACE REMOVE/REPLACE REMOVE/REPLACE REMOVE/REPLACE REMOVE/REPLACE REMOVE/REPLACE REMOVE/REPLACE REMOVE/REPLACE REMOVE/REPLACE REMOVE/REPLACE ADD'L OPR REPAIR ADD'L COST ADD'L COST ADD'L COST Line Item Description Frame Assembly Pickup Bed Components SPRAY IN BEDLINER Pickup Bed Assembly Tailgate Adhesive Emblem Tailgate Adhesive Nameplate Rear Bumper Assy Rear Bumper Face Bar Rear Bumper Step Pad R Rear Bumper Bolt L Rear Bumper Bolt R Rear Bumper Mounting Arm L Rear Bumper Mounting Arm R Rear Otr Bumper Bracket L Rear Otr Bumper Bracket R Rear Bumper Bolt L Rear Bumper Bolt Rear Bumper Stabilizer Clear Coat SPARE TIRE TUB Paint/Materials Shop Materials Hazardous Waste Disposal ESTIMATE RECALL NUMBER: 06/18/2013 14:23:33 61333 Mitchell Data Version: OEM: MAY_13_V0605 Copyright (C) 1994 - 2013 Mitchell International Software Version: 7.1.140 All Rights Reserved 9/17/2013 11:00 AM 61333 0 " Mitchell Part Type/ Dollar Labor Part Number Amount Units 7L5Z 5005 DA 2,038.88 25.0 C 8.5 # Sublet 475.00 * 0.0* 6L5Z 9928508 B d1397.68 3.5 AABZ 9942528 A 31.77 0.2 6L5Z 9942528 B 25.67 0.2 0.7 4L5Z 17906 DA 429.00 INC ORDER FROM DEALER 110.67 INC * W710222 S439 8.00 INC * W710222 S439 8.00 INC F37Z 17787 A 22.55 INC F37Z 17788 A 22.55 INC ORDER FROM DEALER 15.00 INC ORDER FROM DEALER 14.75 INC * N605946 S439 2.00 INC * N605946 S439 2.00 INC 4L5Z 17D826 AA 268.50 INC 3.4* Existing 4.0* 452.20 100.80 4.00 Page 1 of 2 Dale: 9/17/2013 11:00 AM Estimate ID: 61333 Estimate Version: 0 Preliminary Profile ID: " Mitchell - Judgment Item # - Labor Note Applies d - Discontinued by the Manufacturer C - Included in Clear Coat Calc Estimate Totals Add'I Labor Sublet I. Labor Subtotals Units Rate Amount Amount Body Bdy-S Refinish Frame Totals II. Part Replacement Summary 4.6 60.00 0.00 0.00 276.00 T 4.0 60.00 0.00 0.00 240.00 T 11.9 60.00 0.00 0.00 714.00 T 25.0 70.00 0.00 0.00 1,750.00 T Taxable Labor 2,980.00 Labor Summary 45.5 III. Additional Costs Taxable Costs Total Additional Costs Paint Material Method: Rates Init Rate = 38.00 , Init Max Hours = 99.9, Addl Rate = 0.00 2,980.00 Taxable Parts Total Replacement Parts Amount Amount IV. Adjustments 557.00 557.00 Customer Responsibility Total Labor: Total Replacement Parts: Total Additional Costs: Gross Total: IV. Total Adjustments: Net Total: This is a preliminary estimate. Additional changes to the estimate may be required for the actual repair. ESTIMATE RECALL NUMBER: 06/18/2013 14:23:33 61333 Mitchell Data Version: OEM: MAY_13_V0605 Copyright (C) 1994 - 2013 Mitchell International Software Version: 7.1.140 All Rights Reserved Amount 4,872.02 4,872.02 Amount 0.00 2,980.00 4,872.02 557.00 8,409.02 0.00 8,409.02 Page 2 of 2