The URL can be used to link to this page

Item 4C MemoCITY OF SOUTH LADE MEMORANDUM October 4, 2011 To: Shana Yelverton, City Manager From: Sharen Jackson, Director of Finance Timothy Slifka, Purchasing Manager Subject: Item 4C Approve the Purchase of Replacement and New Vehicles from Philpott Motors in the amount of $423,305 Action Requested: Approve the purchase of replacement vehicles from Philpott Motors for Public Works, Planning, and DPS Police in the amount of $423,305. Background Information: Per the City's Vehicle Replacement Plan /Policy the vehicles are scheduled for replacement. State of Texas and City of Southlake bidding requirements have been met by utilizing Houston Galveston Area Council (HGAC) and BuyBoard cooperative purchasing contracts. Financial Considerations: The request will be funded through the City's vehicle replacement fund and Department budgets for FY 2012. Strategic Link: C1 — Achieve the highest standards of safety and security. B2 — Collaborate with select partners to implement service solutions. F2 — Invest to provide and maintain high quality public assets. Citizen Input/ Board Review: None Legal Review: None Alternatives: Deny and retain the old vehicles. This will lead to increased vehicle maintenance cost. Supporting Documents: HGAC and BuyBoard Pricing Worksheets. Staff Recommendation: Approve the purchase of these vehicles from Philpott Motors. CONTRACT PRICING WORKSHEET For Standard Equipment Purchases Contract No.: VE03 -06 Date Prepared: 8/19/11 This Form must be prepared by Contractor and given to End User. The H -GAC administrative fee shall be shown in Section E End User issues PO to Contractor, and MUST also fax a copy of PO, together with completed Pricing Worksheet, to H- GAC @ 713 - 993 -4548. Please type or print legibly. Buying Agency: CITY OF SOUTHLAKE Contractor: PHILPOTT MOTORS Contact Person: TIM SLIFKA Prepared By: RICHARD HYDER Phone: (817) 748 -8312 Phone: (409) 853 -3440 Fax: (817) 748 -8048 Fax: 1 ( 09) 724 -0886 Email: TSLIFKA(a)-CI. SOUTH LAKE.TX.US Email: RICHARD. HYDER(D_PHILPOTTMOTORS.COM Product Code: D18 Description: 2011 FORD EXPLORER A. Product Item Base Unit Price Per Contractor's H -GAC Contract: $ 20,692.00 B. Published Options - Itemize below - Attach additional sheet(s) if necessary - Include Option Code in description if applicable. (Note: Published Options are options which were submitted and priced in Contractor's bid.) Description Cost Description Cost FLOOR PLAN INTEREST $ 434.54 EXTERIOR - -WHITE SUEDE $ LOT INSURANCE $ 62.08 INTERIOR- -GRAY 3.5L V6 GAS $ 6 -SPEED AUTOMATIC TRANSMISSION $ K713 UPGRADE PKG (REQ FOR 2011) INLCUDES POWER EQUIPMENT, SPEED CONTROL, FRONT /REAR AIR CONDITIONING, AMFM CD, APPEARANCE PKG, CLOTH BUCKETS W/ CONSOLE, CLOTH 2ND ROW, CARPET FLOORING, HILL DESCENT CONTROL, 3RD ROW SEATING, RSC AND TRACTION CONTROL $ 2,481.00 4286 Subtotal From Additional Sheet(s): $ Subtotal B: $ 2,977.62 C. Unpublished Options - Itemize below / attach additional sheet(s) if necessary. (Note: Unpublished options are items which were not submitted and priced in Contractor's bid.) Description Cost Description Cost PDI CHARGE $ 80.00 WIGWAGS $ 99.00 Subtotal From Additional Sheet(s): $ REAR FLASHERS $ 99.00 Subtotal C: $ 278.00 Check: Total cost of Unpublished Options (C) cannot exceed 25% of the total of the Base Unit Price plus Published Options (A +B). For this transaction the percentage is: 1% D. Other Cost Items Not Itemized Above (e.g. Installation, Freight, Delivery, Etc.) Description Cost Description Cost DELIVERY 300 MILES $ 450.00 ESP PREMIUM 6/100 $100 DED $ 1,990.00 Subtotal D: $ 2,440.00 E. Total Cost Before Any Applicable Trade -In / Other Allowances / Discounts (A +B +C +D) $ 26,387.62 Quantity Ordered: 1 X Subtotal of A + B + C + D: I $ 26,387.62 = Subtotal E: j $ 26,387.62 F. H -GAC Fee Calculation (From Current Fee Tables) Subtotal F: $ G. Trade -Ins / Other Allowances / Special Discounts Description Cost Description Cost Subtotal G: $ Estimated Delivery Date: IN STOCK H. Total Purchase Price (E +F +G): S 26,387.62 PRODUCT PRICING SUMMARY BASED ON CONTRACT BUYBOARD #358 -10 Vehicles and Heavy Duty Trucks End User: CITY OF SOUTHLAKE Philpott Rep: RICHARD HYDER Contact: TIM SLIFKA Phone: (409) 853 -3440 Phone /email: 817 748 -8312 tsh1'ka@,ei.south1ake.tx.us Email: richard.hyderkphilpottmotors.com Product Description: FORD SUPER DUTY Date: September 8, 2011 A. Bid Series: 100 A. Base Price: I S 24,442.00 B. Published Options [Itemize each below] Code Options Bid Price Code Options Bid Price W4G CREW CAB UPGRADE $ 2,745.00 206 FLAT BED DUMP $ 6,299.17 99T 6.7L V8 DIESEL B20 $ 7,036.00 197 STAKE SIDES AND REAR $ 3,824.93 44W 6 -SPD AUTO TRANSMISSION $ 179.00 267 UNDERBODY MT TOOLBOX $ 489.75 X4L 14.30 LIMITED SLIP AXLE $ 339.00 156 BALL/PINTLE COMBO HITCH $ 253.74 200 200" WHEELBASE 84" CA $ 282.00 101 WHELEN LED LIGHTBAR TO SPEC $ 2,395.00 90L POWER EQUIPMENT GROUP $ 997.00 262 6 -WAY TRAILER PLUG $ 76.45 512 SPARE TIRE AND WHEEL $ 329.00 102A WHELEN 700 LED AMBER /RED $ 361.00 52B ELECTRIC BRAKE CONTROLLER $ 217.00 102A WIGWAGS /REAR FLASHERS $ 198.00 66S UPFITTER SWITCHES $ - 102B EQUIPMENT SERVICES $ 420.00 535 HD TRAILER TOWING PKG $ 329.00 184 ANTHONY SM2500SF LIFTGATE $ 5,988.92 62R PTO PROVISION $ 264.00 276 UNIT # 716 Total of B. Published Options: S 33,023.96 C. Unpublished Options [Itemize each below, not to exceed 25 %] S= 10.6 % Options Bid Price Options Bid Price 4 KEYS $ 6.00 HAVIS DOCKING STATION FOR CF30 W $ 795.00 WESTIN CAB STEPS $ 225.00 HAVIS MD102 ACTION ADAPTER $ 225.00 LEGAL WINDOW TINT $ 200.00 HAVIS HDM202 9" LOWER POLE $ 110.00 ESP PREMIUM 6/100 $100 DEDUCTIBLE $ 4,440.00 HAVIS HDM136 UNIVERSAL FLOOR MO $ 61.00 HAVIS HDM401 SUPPORT BRACE $ 45.00 D. E. F. G. H I. J. K L. M. N. O. Pre - delivery Inspection: Texas State Inspection: Manufacturer Destination /Delivery: Floor Plan Interest (for in -stock and /or equipped vehicles): Lot Insurance (for in -stock and /or equipped vehicles): Contract Price Adjustment: BUDGET DISCOUNT Additional Delivery Charge: 0 miles Subtotal: Quantity Ordered 1 x K = Trade in: Total of C. Unpublished Options: S 6,107.00 ] $ 80.00 $ 21.75 $ 975.00 488.84 97.78 S (236.33) $ - $ 65,000.00 S 65,000.00 BUYBOARD Administrative Fee (5400 per purchase order) TOTAL PURCHASE PRICE INCLUDING BUYBOARD FEE $ 65,000.1111 PRODUCT PRICING SUMMARY BASED ON CONTRACT BUYBOARD #358 -10 Vehicles and Heavy Duty Trucks End User: CITY OF SOUTHLAKE Philpott Rep: RICHARD HYDER Contact: TIM SLIFKA Phone: (409) 853 -3440 Phone /email: 817 748 -8312 tslifka@ei.southlake.tx.us Email: richard .hvderkphilpottmotors.com Product Description: FORD SUPER DUTY CHASSIS Date: September 16, 2011 A. Bid Series: 100 A. Base Price: $ 24,442.00 B. Published Options [Itemize each below] Code Options Bid Price Code Options Bid Price 212 UPGRADE TO F7F 26K# GVWR $ 19,501.00 76B FRONT TOW HOOKS $ 69.00 425 EMISSIONS $ 4,000.00 65V 65 GALLON FUEL TANK $ 235.00 158 158" WB 84" CA $ 115.00 88H 10 GALLON UREA TANK $ 76B IFRONT TOW HOOKS $ 69.00 54C I CONVEX MIRRORS $ 41.00 67C AIR BRAKES $ 1,261.00 447 DAVIS 6/8 YD DUMP ** $ 7,593.60 62D AIR DRYER $ 430.00 COLOR GREEN #PMS 553 61D TAPER LEAF SPRINGS 12K= $ 150.00 88B DRIVER AIR RIDE SEAT $ 436.00 43C FRONT I -BEAM 12K# $ 493.00 99C CUMMINS 6.71, ISB 24011P $ 1,457.00 X51) 5.57 REAR AXLE RATIO $ - #739 475 REAR AXLE SINGLE SPD 21K# $ 158 158" WHEELBASE 84" CA $ 115.00 Total of B. Published Options: I $ 35,965.60 C. Unpublished Options [Itemize each below, not to exceed 25 %] $= 11.3 % Options Bid Price Options Bid Price * *UPGRADE DAVIS DUMP: MANUAL TARP, 60K# TOWING PKG FOR ELECTRIC OR AIR BRAKE TRAILERS, GREEN PMS 553 $ 3,396.40 ESP BASE 5 YEAR 200K MILES $ 3,200.00 (DOES NOT COVER ENGINE /TRANS) LEGAL WINDOW TINT $ 200.00 D. Pre - delivery Inspection: E. Texas State Inspection: F. Manufacturer Destination /Delivery: G. Floor Plan Interest (for in -stock and /or equipped vehicles): H Lot Insurance (for in -stock and /or equipped vehicles): L Contract Price Adjustment: J. Additional Delivery Charge: 0 miles K. Subtotal: L. Quantity Ordered 1 x K = M. Trade in: N. BUYBOARD Administrative Fee ($400 per purchase order) O. TOTAL PURCHASE PRICE INCLUDING BUYBOARD FEE Total of C. Unpublished Options: I $ 6,796.40 $ 80.00 $ - $ 1,275.00 488.84 97.77 $ - $ 69,145.61 $ 69,145.61 $ 400.00 $ 69,545.61 CONTRACT PRICING WORKSHEET For Standard Equipment Purchases Contract No.: VE03 -06 Date Prepared: 8/19/11 This Form must be prepared by Contractor and given to End User. The H -GAC administrative fee shall be shown in Section E End User issues PO to Contractor, and MUST also fax a copy of PO, together with completed Pricing Worksheet, to H- GAC @ 713 - 993 -4548. Please type or print legibly. Buying Agency: CITY OF SOUTHLAKE Contractor: PHILPOTT MOTORS Contact Person: TIM SLIFKA Prepared By: RICHARD HYDER Phone: (817) 748 -8312 Phone: (409) 853 -3440 Fax: (817) 748 -8048 Fax: 1 ( 09) 724 -0886 Email: TSLIFKA(a)-CI. SOUTH LAKE.TX.US Email: RICHARD. HYDER(D -PHILPOTTMOTORS.COM Product Code: D24 Description: 2011 FORD F150 SUPERCAB A. Product Item Base Unit Price Per Contractor's H -GAC Contract: $ 15,839.00 B. Published Options - Itemize below - Attach additional sheet(s) if necessary - Include Option Code in description if applicable. (Note: Published Options are options which were submitted and priced in Contractor's bid.) Description Cost Description Cost FLOOR PLAN INTEREST $ 332.62 EXTERIOR - -WHITE $ LOT INSURANCE $ 47.52 INTERIOR- -GRAY AUTOMATIC TRANSMISSION $ - 6 -WAY SWITCHBOX $ 119.00 AIR CONDITIONING $ LED LIGHTBAR W/ SPLIT TA $ 2,395.00 ANTILOCK BRAKES $ XH9 LIMITED SLIP AXLE $ 270.00 145" 6.5' BED $ CLOTH SEATING 40/20/40 $ UNIT 4 793 AMFM RADIO $ 99F 5.OL V8 GAS /E85 $ 1,830.00 7050# GVWR $ 535 TRAILER TOWING PKG $ 350.00 Subtotal From Additional Sheet(s): $ - 85A POWER EQUIPMENT GROUP $ 995.00 Subtotal B: $ 6,339.14 C. Unpublished Options - Itemize below / attach additional sheet(s) if necessary. (Note: Unpublished options are items which were not submitted and priced in Contractor's bid.) Description Cost Description Cost PDI CHARGE $ 80.00 ADD 6 WIRE ROUND TRAILER PLUG $ 5213/54P TRAILER BRAKE CONTROLLER $ 351.00 Subtotal From Additional Sheet(s): $ 1,759.00 WINDOW TINT LEGAL $ 150.00 Subtotal C: $ 2,340.00 Check: Total cost of Unpublished Options (C) cannot exceed 25% of the total of the Base Unit Price plus Published Options (A +B). For this transaction the percentage is: 11% D. Other Cost Items Not Itemized Above (e.g. Installation, Freight, Delivery, Etc.) Description Cost Description Cost DELIVERY 300 MILES $ 450.00 ESP PREMIUM 6/100 $100 DED $ 1,990.00 EQUIPMENT SERVICES $ 210.00 Subtotal D: $ 2,650.00 E. Total Cost Before Any Applicable Trade -In / Other Allowances / Discounts (A +B +C +D) $ 27,168.14 Quantity Ordered: 1 X Subtotal of A + B+ C + D: I $ 27,168.14 = Subtotal E: $ 27,168.14 F. H -GAC Fee Calculation (From Current Fee Tables) Subtotal F: $ G. Trade -Ins / Other Allowances / Special Discounts Description Cost Description Cost Subtotal G: $ Estimated Delivery Date: 90 DAYS ARO H. Total Purchase Price (E +F +G): S 27,168.14 wq vp PAGE 2 -- ADDITIONAL OPTIONS Contract No.: I VE03 -06 Date Prepared: 8/19/11 This Form must be prepared by Contractor and given to End User. The H -GAC administrative fee shall be shown in Section E End User issues PO to Contractor, and MUST also fax a copy of PO, together with completed Pricing Worksheet, to H- GAC @ 713 - 993 -45 Buying Agency: CITY OF SOUTHLAKE Contractor: PHILPOTT MOTORS Contact Person: TIM SLIFKA Prepared By: RICHARD HYDER Phone: 8177488312 Phone: 4098533440 Fax: 8177488048 Fax: 4097240886 Email: TSLIFKA(p7CI.SOUTHLAKE.TX.US Email: RICHARD. HYDER(d)PHILPOTTMOTORS.COM Product Code: D24 Description: 2011 FORD F150 SUPERCAB B. Additional Published Options to be added to page 1 Description Cost Description Cost Subtotal B: $ C. Additional Unpublished Options to be added to page 1 Description Cost Description Cost WIGWAGS $ 99.00 REAR FLASHERS $ 99.00 4 KEYS $ 100.00 WESTIN TUBULAR CAB STEPS $ 225.00 HAVIS DOCKING STATION FOR CF30 W/ 2 PORTS $ 795.00 HAVIS MD 102 ACTION ADAPTER $ 225.00 HAVIS HDM202 9" LOWER POLE $ 110.00 HAVIS HDM136 UNIVERSAL FLOOR MOUNT $ 61.00 HAVIS HDM401 SUPPORT BRACE $ 45.00 Subtotal C: $ 1,759.00 PRODUCT PRICING SUMMARY BASED ON CONTRACT BUYBOARD #358 -10 Vehicles and Heavy Duty Trucks End User: CITY OF SOUTHLAKE Philpott Rep: RICHARD HYDER Contact: TIM SLIFKA Phone: (409) 853 -3440 Phone /email: 817 748 -8312 tslifka@ci.southlake.tx.us Email: richard .hvderkphilpottmotors.com Product Description: FORD SUPER DUTY Date: August 19, 2011 A. Bid Series: 100 A. Base Price: I $ 24,442.00 B. Published Options [Itemize each below] Code Options Bid Price Code Options Bid Price W4G CREW CAB UPGRADE $ 2,745.00 HAVIS DOCKING STATION FOR CF30 W $ 795.00 99T 6.71, V8 DIESEL B20 $ 7,036.00 HAVIS MD102 ACTION ADAPTER #825 225.00 44W 6 -SPD AUTO TRANSMISSION $ 179.00 HAVIS HDM202 9" LOWER POLE $ 110.00 X41, 14.30 LIMITED SLIP AXLE $ 339.00 156 BALL/PINTLE COMBO HITCH $ 253.74 200 200" WHEELBASE 84" CA $ 282.00 101 WHELEN LED LIGHTBAR TO SPEC $ 2,395.00 90L POWER EQUIPMENT GROUP $ 997.00 262 6 -WAY TRAILER PLUG $ 76.45 512 SPARE TIRE AND WHEEL $ 329.00 102A WHELEN 700 LED AMBER/RED $ 361.00 52B ELECTRIC BRAKE CONTROLLER $ 217.00 102A WIGWAGS/REAR FLASHERS $ 198.00 66S UPFITTER SWITCHES $ - 102B EQUIPMENT SERVICES $ 420.00 535 HD TRAILER TOWING PKG $ 329.00 62R PTO PROVISION $ 264.00 UNIT # 825 Total of B. Published Options: I $ 16,421.19 C. Unpublished Options [Itemize each below, not to exceed 25 %] $= 14.9 % Options Bid Price Options Bid Price 4 KEYS $ 6.00 HAVIS DOCKING STATION FOR CF30 W $ 795.00 WESTIN CAB STEPS $ 225.00 HAVIS MD102 ACTION ADAPTER $ 225.00 LEGAL WINDOW TINT $ 200.00 HAVIS HDM202 9" LOWER POLE $ 110.00 ESP PREMIUM 6/100 $100 DEDUCTIBLE $ 4,440.00 HAVIS HDM136 UNIVERSAL FLOOR MO $ 61.00 HAVIS HDM401 SUPPORT BRACE $ 45.00 D. Pre - delivery Inspection: E. Texas State Inspection: F. Manufacturer Destination /Delivery: G. Floor Plan Interest (for in -stock and /or equipped vehicles): H Lot Insurance (for in -stock and /or equipped vehicles): L Contract Price Adjustment: J. Additional Delivery Charge: 0 miles K. Subtotal: L. Quantity Ordered 1 x K = M. Trade in: N. BUYBOARD Administrative Fee ($400 per purchase order) O. TOTAL PURCHASE PRICE INCLUDING BUYBOARD FEE Total of C. Unpublished Options: $ 6,107.00 $ 80.00 $ 21.75 $ 975.00 488.84 97.78 $ - $ 48,633.56 $ 48,633.56 $ - $ 48,633.56 CONTRACT PRICING WORKSHEET For Standard Equipment Purchases Contract No.: VE03 -06 Date Prepared: 8/19/11 This Form must be prepared by Contractor and given to End User. The H -GAC administrative fee shall be shown in Section E End User issues PO to Contractor, and MUST also fax a copy of PO, together with completed Pricing Worksheet, to H- GAC @ 713 - 993 -4548. Please type or print legibly. Buying Agency: CITY OF SOUTHLAKE Contractor: PHILPOTT MOTORS Contact Person: TIM SLIFKA Prepared By: RICHARD HYDER Phone: (817) 748 -8312 Phone: (409) 853 -3440 Fax: (817) 748 -8048 Fax: 1 ( 09) 724 -0886 Email: TSLIFKA(a)-CI. SOUTH LAKE.TX.US Email: I RICHARD. HYDER(D -PHILPOTTMOTORS.COM Product Code: D28 Description: 2012 FORD F250 SUPER CAB PICKUP (WITH 4X4 UPGRADE) A. Product Item Base Unit Price Per Contractor's H -GAC Contract: $ 20,013.00 B. Published Options - Itemize below - Attach additional sheet(s) if necessary - Include Option Code in description if applicable. (Note: Published Options are options which were submitted and priced in Contractor's bid.) Description Cost Description Cost FLOOR PLAN INTEREST $ 420.28 X3E ELECTRONIC LOCKING AXLE $ 366.00 LOT INSURANCE $ 60.04 90L POWER EQUIPMENT GROUP $ 799.00 99T 6.7L DIESEL B20 $ 6,895.00 66S UPFITTER SWITCHES $ 80.00 44T 6 -SPD AUTOMATIC TRANSMISSION $ - 52B TRAILER BRAKE CONTROLLER $ 195.00 AIR CONDITIONING $ HEADACHE RACK $ 335.00 TELESCOPIC MIRRORS $ LED LIGHTBAR W/ SPLIT TA $ 2,395.00 158" WB 8' BED $ 4x4 UPGRADE $ 2,975.00 AMFM RADIO $ TBM ALL TERRAIN TIRES $ 118.00 9400# GVWR $ 213 SHIFT ON THE FLY $ 174.00 RECEIVER HITCH $ UNIT 4 828 SPARE TIRE AND WHEEL $ Subtotal From Additional Sheet(s): $ 40/20/40 CLOTH SPLIT BENCH SEAT $ 100.00 Subtotal B: $ 14,912.32 C. Unpublished Options - Itemize below / attach additional sheet(s) if necessary. (Note: Unpublished options are items which were not submitted and priced in Contractor's bid.) Description Cost Description Cost PDI CHARGE $ 80.00 ADD 6 WIRE ROUND TRAILER PLUG $ - Subtotal From Additional Sheet(s): $ 3,584.00 WINDOW TINT LEGAL $ 175.00 Subtotal C: $ 3,839.00 Check: Total cost of Unpublished Options (C) cannot exceed 25% of the total of the Base Unit Price plus Published Options (A +B). For this transaction the percentage is: 11% D. Other Cost Items Not Itemized Above (e.g. Installation, Freight, Delivery, Etc.) Description Cost Description Cost DELIVERY 300 MILES $ 450.00 ESP 6/100 PREMIUM $100 DED $ 2,980.00 EQUIPMENT SERVICES $ 210.00 Subtotal D: $ 3,640.00 E. Total Cost Before Any Applicable Trade -In / Other Allowances / Discounts (A +B +C +D) $ 42,404.32 Quantity Ordered: 1 X Subtotal of A + B + C + D: I $ 42,404.32 = Subtotal E: $ 42,404.32 F. H -GAC Fee Calculation (From Current Fee Tables) Subtotal F: $ G. Trade -Ins / Other Allowances / Special Discounts Description Cost Description Cost Subtotal G: $ - Estimated Delivery Date: 90 DAYS ARO H. Total Purchase Price (E +F +G): S 42,404.32 wq vp PAGE 2 -- ADDITIONAL OPTIONS Contract No.: I VE03 -06 Date Prepared: 8/19/11 This Form must be prepared by Contractor and given to End User. The H -GAC administrative fee shall be shown in Section E End User issues PO to Contractor, and MUST also fax a copy of PO, together with completed Pricing Worksheet, to H- GAC @ 713 - 993 -45 Buying Agency: CITY OF SOUTHLAKE Contractor: PHILPOTT MOTORS Contact Person: TIM SLIFKA Prepared By: RICHARD HYDER Phone: 8177488312 Phone: 4098533440 Fax: 8177488048 Fax: 4097240886 Email: TSLIFKA(p7CI.SOUTHLAKE.TX.US Email: RICHARD. HYDER(d)PHILPOTTMOTORS.COM Product Code: D28 Description: 2012 FORD F250 SUPER CAB PICKUP (WITH 4X4 UPGRADE) B. Additional Published Options to be added to page 1 Description Cost Description Cost Subtotal B: $ C. Additional Unpublished Options to be added to page 1 Description Cost Description Cost WIGWAGS $ 99.00 REAR FLASHERS $ 99.00 4 KEYS $ 100.00 WESTIN TUBULAR CAB STEPS $ 225.00 HAVIS DOCKING STATION FOR CF30 W/ 2 PORTS $ 795.00 HAVIS MD 102 ACTION ADAPTER $ 225.00 HAVIS HDM202 9" LOWER POLE $ 110.00 HAVIS HDM136 UNIVERSAL FLOOR MOUNT $ 61.00 HAVIS HDM401 SUPPORT BRACE $ 45.00 UWS TT- 100 -COMBO WITH FILLRITE 1210C PUMP AND 50' HOSE WITH IN CAB SWITCH $ 1,825.00 Subtotal C: $ 3,584.00 CONTRACT PRICING WORKSHEET For Standard Equipment Purchases Contract No.: VE03 -06 Date Prepared: 8/19/11 This Form must be prepared by Contractor and given to End User. The H -GAC administrative fee shall be shown in Section E End User issues PO to Contractor, and MUST also fax a copy of PO, together with completed Pricing Worksheet, to H- GAC @ 713 - 993 -4548. Please type or print legibly. Buying Agency: CITY OF SOUTHLAKE Contractor: PHILPOTT MOTORS Contact Person: TIM SLIFKA Prepared By: RICHARD HYDER Phone: (817) 748 -8312 Phone: (409) 853 -3440 Fax: (817) 748 -8048 Fax: 1 ( 09) 724 -0886 Email: TSLIFKA(a)-CI. SOUTH LAKE.TX.US Email: RICHARD. HYDER(D -PHILPOTTMOTORS.COM Product Code: D24 Description: 2011 FORD F150 SUPERCAB A. Product Item Base Unit Price Per Contractor's H -GAC Contract: $ 15,839.00 B. Published Options - Itemize below - Attach additional sheet(s) if necessary - Include Option Code in description if applicable. (Note: Published Options are options which were submitted and priced in Contractor's bid.) Description Cost Description Cost FLOOR PLAN INTEREST $ 332.62 EXTERIOR - -WHITE $ LOT INSURANCE $ 47.52 INTERIOR- -GRAY AUTOMATIC TRANSMISSION $ - 6 -WAY SWITCHBOX $ 119.00 AIR CONDITIONING $ LED LIGHTBAR W/ SPLIT TA $ 2,395.00 ANTILOCK BRAKES $ XH9 LIMITED SLIP AXLE $ 270.00 145" 6.5' BED $ CLOTH SEATING 40 /20/40 $ UNIT 4 917 AMFM RADIO $ 99F 5.OL V8 GAS /E85 $ 1,830.00 7050# GVWR $ 535 TRAILER TOWING PKG $ 350.00 Subtotal From Additional Sheet(s): $ - 85A POWER EQUIPMENT GROUP $ 995.00 Subtotal B: $ 6,339.14 C. Unpublished Options - Itemize below / attach additional sheet(s) if necessary. (Note: Unpublished options are items which were not submitted and priced in Contractor's bid.) Description Cost Description Cost PDI CHARGE $ 80.00 ADD 6 WIRE ROUND TRAILER PLUG $ 5213/54P TRAILER BRAKE CONTROLLER $ 351.00 Subtotal From Additional Sheet(s): $ 1,759.00 WINDOW TINT LEGAL $ 150.00 Subtotal C: $ 2,340.00 Check: Total cost of Unpublished Options (C) cannot exceed 25% of the total of the Base Unit Price plus Published Options (A +B). For this transaction the percentage is: 11% D. Other Cost Items Not Itemized Above (e.g. Installation, Freight, Delivery, Etc.) Description Cost Description Cost DELIVERY 300 MILES $ 450.00 ESP PREMIUM 6/100 $100 DED $ 1,990.00 EQUIPMENT SERVICES $ 210.00 Subtotal D: $ 2,650.00 E. Total Cost Before Any Applicable Trade -In / Other Allowances / Discounts (A +B +C +D) $ 27,168.14 Quantity Ordered: 1 X Subtotal of A + B+ C + D: I $ 27,168.14 = Subtotal E: $ 27,168.14 F. H -GAC Fee Calculation (From Current Fee Tables) Subtotal F: $ 600.00 G. Trade -Ins / Other Allowances / Special Discounts Description Cost Description Cost Subtotal G: $ Estimated Delivery Date: 90 DAYS ARO H. Total Purchase Price (E +F +G): S 27,768.14 wq vp PAGE 2 -- ADDITIONAL OPTIONS Contract No.: I VE03 -06 Date Prepared: 8/19/11 This Form must be prepared by Contractor and given to End User. The H -GAC administrative fee shall be shown in Section E End User issues PO to Contractor, and MUST also fax a copy of PO, together with completed Pricing Worksheet, to H- GAC @ 713 - 993 -45 Buying Agency: CITY OF SOUTHLAKE Contractor: PHILPOTT MOTORS Contact Person: TIM SLIFKA Prepared By: RICHARD HYDER Phone: 8177488312 Phone: 4098533440 Fax: 8177488048 Fax: 4097240886 Email: TSLIFKA(p7CI.SOUTHLAKE.TX.US Email: RICHARD. HYDER(d)PHILPOTTMOTORS.COM Product Code: D24 Description: 2011 FORD F150 SUPERCAB B. Additional Published Options to be added to page 1 Description Cost Description Cost Subtotal B: $ C. Additional Unpublished Options to be added to page 1 Description Cost Description Cost WIGWAGS $ 99.00 REAR FLASHERS $ 99.00 4 KEYS $ 100.00 WESTIN TUBULAR CAB STEPS $ 225.00 HAVIS DOCKING STATION FOR CF30 W/ 2 PORTS $ 795.00 HAVIS MD 102 ACTION ADAPTER $ 225.00 HAVIS HDM202 9" LOWER POLE $ 110.00 HAVIS HDM136 UNIVERSAL FLOOR MOUNT $ 61.00 HAVIS HDM401 SUPPORT BRACE $ 45.00 Subtotal C: $ 1,759.00 CONTRACT PRICING WORKSHEET For Standard Equipment Purchases Contract No.: VE03 -06 Date Prepared: 8/19/11 This Form must be prepared by Contractor and given to End User. The H -GAC administrative fee shall be shown in Section E End User issues PO to Contractor, and MUST also fax a copy of PO, together with completed Pricing Worksheet, to H- GAC @ 713 - 993 -4548. Please type or print legibly. Buying Agency: CITY OF SOUTHLAKE Contractor: PHILPOTT MOTORS Contact Person: TIM SLIFKA Prepared By: RICHARD HYDER Phone: (817) 748 -8312 Phone: (409) 853 -3440 Fax: (817) 748 -8048 Fax: 1 ( 09) 724 -0886 Email: TSLIFKA(a)-CI. SOUTH LAKE.TX.US Email: RICHARD. HYDER(D -PHILPOTTMOTORS.COM Product Code: D24 Description: 2011 FORD F150 SUPERCAB A. Product Item Base Unit Price Per Contractor's H -GAC Contract: $ 15,839.00 B. Published Options - Itemize below - Attach additional sheet(s) if necessary - Include Option Code in description if applicable. (Note: Published Options are options which were submitted and priced in Contractor's bid.) Description Cost Description Cost FLOOR PLAN INTEREST $ 332.62 EXTERIOR - -WHITE $ LOT INSURANCE $ 47.52 INTERIOR- -GRAY AUTOMATIC TRANSMISSION $ - 6 -WAY SWITCHBOX $ 119.00 AIR CONDITIONING $ LED LIGHTBAR W/ SPLIT TA $ 2,395.00 ANTILOCK BRAKES $ XH9 LIMITED SLIP AXLE $ 270.00 145" 6.5' BED $ CLOTH SEATING 40/20/40 $ AMFM RADIO $ UNIT 4 918 99F 5.OL V8 GAS /E85 $ 1,830.00 7050# GVWR $ 535 TRAILER TOWING PKG $ 350.00 Subtotal From Additional Sheet(s): $ 85A POWER EQUIPMENT GROUP $ 995.00 Subtotal B: $ 6,339.14 C. Unpublished Options - Itemize below / attach additional sheet(s) if necessary. (Note: Unpublished options are items which were not submitted and priced in Contractor's bid.) Description Cost Description Cost PDI CHARGE $ 80.00 ADD 6 WIRE ROUND TRAILER PLUG $ 5213/54P TRAILER BRAKE CONTROLLER $ 351.00 Subtotal From Additional Sheet(s): $ 1,759.00 WINDOW TINT LEGAL $ 150.00 Subtotal C: $ 2,340.00 Check: Total cost of Unpublished Options (C) cannot exceed 25% of the total of the Base Unit Price plus Published Options (A +B). For this transaction the percentage is: 11% D. Other Cost Items Not Itemized Above (e.g. Installation, Freight, Delivery, Etc.) Description Cost Description Cost DELIVERY 300 MILES $ 450.00 ESP PREMIUM 6/100 $100 DED $ 1,990.00 EQUIPMENT SERVICES $ 210.00 Subtotal D: $ 2,650.00 E. Total Cost Before Any Applicable Trade -In / Other Allowances / Discounts (A +B +C +D) $ 27,168.14 Quantity Ordered: 1 X Subtotal of A + B+ C + D: I $ 27,168.14 = Subtotal E: $ 27,168.14 F. H -GAC Fee Calculation (From Current Fee Tables) Subtotal F: $ G. Trade -Ins / Other Allowances / Special Discounts Description Cost Description Cost Subtotal G: $ Estimated Delivery Date: 90 DAYS ARO H. Total Purchase Price (E +F +G): S 27,168.14 wq vp PAGE 2 -- ADDITIONAL OPTIONS Contract No.: I VE03 -06 Date Prepared: 8/19/11 This Form must be prepared by Contractor and given to End User. The H -GAC administrative fee shall be shown in Section E End User issues PO to Contractor, and MUST also fax a copy of PO, together with completed Pricing Worksheet, to H- GAC @ 713 - 993 -45 Buying Agency: CITY OF SOUTHLAKE Contractor: PHILPOTT MOTORS Contact Person: TIM SLIFKA Prepared By: RICHARD HYDER Phone: 8177488312 Phone: 4098533440 Fax: 8177488048 Fax: 4097240886 Email: TSLIFKA(p7CI.SOUTHLAKE.TX.US Email: RICHARD. HYDER(d)PHILPOTTMOTORS.COM Product Code: D24 Description: 2011 FORD F150 SUPERCAB B. Additional Published Options to be added to page 1 Description Cost Description Cost Subtotal B: $ C. Additional Unpublished Options to be added to page 1 Description Cost Description Cost WIGWAGS $ 99.00 REAR FLASHERS $ 99.00 4 KEYS $ 100.00 WESTIN TUBULAR CAB STEPS $ 225.00 HAVIS DOCKING STATION FOR CF30 W/ 2 PORTS $ 795.00 HAVIS MD 102 ACTION ADAPTER $ 225.00 HAVIS HDM202 9" LOWER POLE $ 110.00 HAVIS HDM136 UNIVERSAL FLOOR MOUNT $ 61.00 HAVIS HDM401 SUPPORT BRACE $ 45.00 Subtotal C: $ 1,759.00 PRODUCT PRICING SUMMARY BASED ON CONTRACT BUYBOARD #358 -10 Vehicles and Heavy Duty Trucks End User: CITY OF SOUTHLAKE Philpott Rep: RICHARD HYDER Contact: TIM SLIFKA Phone: (409) 853 -3440 Phone /email: 817 748 -8312 tsh1'ka@,ci.south1ake.tx.us Email: richard.hyder philpottmotors.com Product Description: FORD SUPER DUTY Date: August 19, 2011 A. Bid Series: 100 A. Base Price: $ 24,442.00 B. Published Options [Itemize each below] Code Options Bid Price Code Options Bid Price W4G CREW CAB UPGRADE $ 2,745.00 206 FLAT BED DUMP $ 6,299.17 99T 6.7L V8 DIESEL B20 $ 7,036.00 197 STAKE SIDES AND REAR $ 3,824.93 44W 6 -SPD AUTO TRANSMISSION $ 179.00 X4L 14.30 LIMITED SLIP AXLE $ 339.00 156 BALL/PINTLE COMBO HITCH $ 253.74 200 200" WHEELBASE 84" CA $ 282.00 101 WHELEN LED LIGHTBAR TO SPEC $ 2,395.00 90L POWER EQUIPMENT GROUP $ 997.00 262 6 -WAY TRAILER PLUG $ 76.45 512 SPARE TIRE AND WHEEL $ 329.00 102A WHELEN 700 LED AMBER /RED $ 361.00 52B ELECTRIC BRAKE CONTROLLER $ 217.00 102A WIGWAGS /REAR FLASHERS $ 198.00 66S UPFITTER SWITCHES $ - 102B EQUIPMENT SERVICES $ 420.00 535 HD TRAILER TOWING PKG $ 329.00 184 ANTHONY SM2500SF LIFTGATE $ 5,988.92 Total of B. Published Options: S 32,270.21 C. Unpublished Options [Itemize each below, not to exceed 25 %1 S= 8.6 % Options Bid Price Options Bid Price 4 KEYS $ 6.00 WESTIN CAB STEPS $ 225.00 LEGAL WINDOW TINT $ 200.00 UNIT # 959 ESP PREMIUM 6/100 $100 DEDUCTIBLE $ 4,440.00 #959 D. E. F. G. H I. J. K L. M. N. O. Pre - delivery Inspection: Texas State Inspection: Manufacturer Destination /Delivery: Floor Plan Interest (for in -stock and /or equipped vehicles): Lot Insurance (for in -stock and /or equipped vehicles): Contract Price Adjustment: Total of C. Unpublished Options: S 4,871.00 $ 80.00 $ 21.75 $ 975.00 488.84 97.78 Additional Delivery Charge: 0 miles Subtotal: Quantity Ordered 1 x K = Trade in: BUYBOARD Administrative Fee (5400 per purchase order) TOTAL PURCHASE PRICE INCLUDING BUYBOARD FEE $ - S 63,246.58 S 63,246.58 - $ 63,246.58 CONTRACT PRICING WORKSHEET For Standard Equipment Purchases Contract No.: VE03 -06 Date Prepared: 8/19/11 This Form must be prepared by Contractor and given to End User. The H -GAC administrative fee shall be shown in Section E End User issues PO to Contractor, and MUST also fax a copy of PO, together with completed Pricing Worksheet, to H- GAC @ 713 - 993 -4548. Please type or print legibly. Buying Agency: CITY OF SOUTHLAKE Contractor: PHILPOTT MOTORS Contact Person: TIM SLIFKA Prepared By: RICHARD HYDER Phone: (817) 748 -8312 Phone: (409) 853 -3440 Fax: (817) 748 -8048 Fax: 1 ( 09) 724 -0886 Email: TSLIFKA(a)-CI. SOUTH LAKE.TX.US Email: RICHARD. HYDER(D -PHILPOTTMOTORS.COM Product Code: D23 Description: 2011 FORD F150 A. Product Item Base Unit Price Per Contractor's H -GAC Contract: $ 18,279.00 B. Published Options - Itemize below - Attach additional sheet(s) if necessary - Include Option Code in description if applicable. (Note: Published Options are options which were submitted and priced in Contractor's bid.) Description Cost Description Cost FLOOR PLAN INTEREST $ 314.84 EXTERIOR -- WHITE $ LOT INSURANCE $ 44.98 INTERIOR- -GRAY AUTOMATIC TRANSMISSION $ - XH9 LIMITED SLIP AXLE $ 270.00 AIR CONDITIONING $ 6 -WAY SWITCHBOX $ 119.00 ANTILOCK BRAKES $ LED LIGHTBAR W/ SPLIT TA $ 2,395.00 145" 8' BED $ CLOTH SEATING 40 /20/40 $ UNIT 4 971 AMFM RADIO $ 6750# GVWR $ 535 TRAILER TOWING PKG $ 350.00 85A POWER EQUIPMENT GROUP $ 995.00 Subtotal From Additional Sheet(s): $ Subtotal B: $ 4,488.82 C. Unpublished Options - Itemize below / attach additional sheet(s) if necessary. (Note: Unpublished options are items which were not submitted and priced in Contractor's bid.) Description Cost Description Cost PDI CHARGE $ 80.00 WINDOW TINT LEGAL $ 150.00 CREDIT F12WQ145 $ (3,607.00) Subtotal From Additional Sheet(s): $ 2,110.00 5.OL V8 GAS E85 - -360 HP, 380 FTLBS TORQUE $ 1,830.00 Subtotal C: $ 563.00 Check: Total cost of Unpublished Options (C) cannot exceed 25% of the total of the Base Unit Price plus Published Options (A +B). For this transaction the percentage is: 2% D. Other Cost Items Not Itemized Above (e.g. Installation, Freight, Delivery, Etc.) Description Cost Description Cost DELIVERY 300 MILES $ 450.00 ESP PREMIUM 6/100 $100 DED $ 1,990.00 EQUIPMENT SERVICES $ 210.00 Subtotal D: $ 2,650.00 E. Total Cost Before Any Applicable Trade -In / Other Allowances / Discounts (A +B +C +D) $ 25,980.82 Quantity Ordered: 1 X Subtotal of A + B + C + D: I $ 25,980.82 = Subtotal E: $ 25,980.82 F. H -GAC Fee Calculation (From Current Fee Tables) Subtotal F: $ G. Trade -Ins / Other Allowances / Special Discounts Description Cost Description Cost Subtotal G: $ Estimated Delivery Date: 60 -90 DAYS H. Total Purchase Price (E +F +G): S 25,980.82 wq vp PAGE 2 -- ADDITIONAL OPTIONS Contract No.: I VE03 -06 Date Prepared: 8/19/11 This Form must be prepared by Contractor and given to End User. The H -GAC administrative fee shall be shown in Section E End User issues PO to Contractor, and MUST also fax a copy of PO, together with completed Pricing Worksheet, to H- GAC @ 713 - 993 -45 Buying Agency: CITY OF SOUTHLAKE Contractor: PHILPOTT MOTORS Contact Person: TIM SLIFKA Prepared By: RICHARD HYDER Phone: 8177488312 Phone: 4098533440 Fax: 8177488048 Fax: 4097240886 Email: TSLIFKA(p7CI.SOUTHLAKE.TX.US Email: RICHARD. HYDER(d)PHILPOTTMOTORS.COM Product Code: D23 Description: 2011 FORD Fl-50 B. Additional Published Options to be added to page 1 Description Cost Description Cost Subtotal B: $ C. Additional Unpublished Options to be added to page 1 Description Cost Description Cost 5213/54P TRAILER BRAKE CONTROLLER $ 351.00 ADD 6 WIRE ROUND TRAILER PLUG $ WIGWAGS $ 99.00 REAR FLASHERS $ 99.00 4 KEYS $ 100.00 WESTIN TUBULAR CAB STEPS $ 225.00 HAVIS DOCKING STATION FOR CF30 W/ 2 PORTS $ 795.00 HAVIS MD 102 ACTION ADAPTER $ 225.00 HAVIS HDM202 9" LOWER POLE $ 110.00 HAVIS HDM136 UNIVERSAL FLOOR MOUNT $ 61.00 HAVIS HDM401 SUPPORT BRACE $ 45.00 Subtotal C: $ 2,110.()0