Loading...
HomeMy WebLinkAboutContract 48936-A1A1 O CITY SECRETARY CONTRACT NO.- LI'89 36-AIN �-,4, �y FIRST AMENDMENT TO CITY SECRETARY CONTRACT NO.48936-Al 0 5V AN AMENDED AND RESTATED AGREEMENT BETWEEN THE CITY OF FORT WORTH AND GENUINE PARTY COMPANY D/B/A NAPA AUTO PARTS FOR FLEET PARTS MANAGEMENT AND SUPPLY SERVICES This First Amendment to City Secretary Contract No.48936-A1,an amended and restated agreement for fleet parts management and supply services ("First Amendment"), is made and entered into by and between the CITY OF FORT WORTH (the"City"), a home rule municipal corporation situated in portions of Tarrant, Denton and Wise Counties, Texas, acting by and through Jesus J. Chapa, its duly authorized Assistant City Manager, and GENUINE PARTS COMPANY d/b/a NAPA AUTO PARTS("Contractor"),a Georgia corporation authorized to do business in the State of Texas and acting by and through Stu Kambury,its duly authorized Division Vice President. City and Contractor are each individually referred to herein as a "Party" and collectively as the"Parties". WHEREAS, the Parties previously entered into City Secretary Contract No. 48936 for fleet parts management and supply services;and WHEREAS, the Parties entered into an amended and restated agreement for fleet parts management and supply services, the same being City Secretary Contract No. 48936-A1 (the "Agreement");and WHEREAS, the City has added the North Service Center as a new on-site store, as contemplated by the Parties when the Agreement was executed; and WHEREAS, the parties desire to amend the Agreement to incorporate provisions reflecting the addition of the new on-site store; NOW,THEREFORE, in consideration of the mutual promises and covenants contained herein, and other good and valuable consideration, the receipt and sufficiency of which are acknowledged,the Parties hereto agree as follows: I. Exhibit A, Section 37.0"Definitions"of the Agreement is amended to add the following: Will Call parts Will Call parts are parts that City personnel have requested be obtained and held for pickup by City personnel. Will Call parts will be treated as Demand Inventory for all purposes under this Agreement,except that Will Call parts will not be subject to the same approval requirements for acquisition.Upon termination of this Agreement,Contractor has the option to require the City to repurchase Will Call parts as well as all Demand Inventory pursuant to Section 38.9.11 of this Agreement. II. Exhibit A, Section 38.6.1 of the Agreement is amended to be and read as follows: 38.6.1 Light Vehicle/Automotive Needs LIGHT DUTY PARTS FIRST AMENDMENT TO CITY SECRETARY CONTRACT NO.48936 Page l of 4 On Demand Parts Orders 90% Within 2 days 95% Within 3 days or less 98% On Demand Parts for location shaving Parts Rooms On-site(James Ave., Southside Service Center, Water Dept. and North Service Center) must have fulfillment of request within twenty-five(25)minutes. • On Demand Parts for location without On-site Parts Room (Village Creek and Brennan Body Shop), must not exceed a fifty-five minute lead time for fulfillment. III. Exhibit A, Section 38.6.2 of the Agreement is amended to be and read as follows: 38.6.2 Medium/Heavy Duty Vehicle Needs MEDIUM/HEAVY DUTY PARTS On Demand Parts Orders 60% Within 2 days 80% Within 3 days or less 90% On Demand Parts for location shaving Parts Rooms On-site(James Ave., Southside Service Center, Water Dept. and North Service Center) must have fulfillment of request within twenty-five (25)minutes. • On Demand Parts for location without On-site Parts Room (Village Creek and Brennan Body Shop), must not exceed a fifty-five minute lead time for fulfillment. IV. Exhibit A,Section 38.22 of the Agreement is amended to add the following subsection: 38.22.10 City is responsible for fixed furnishings such as desks, chairs, the main counter pick up, the main rack and shelves, and for computers, internet, printers, phones, heat, electricity, and other utilities. Contractor is responsible for computers that utilize Contractor's management system for integration and accountability of the stock Contractor acquires as City's vendor, and all associated training and maintenance. V. Exhibit B of the Agreement is amended to be and read as set forth in Attachment 1 to this First Amendment. FIRST AMENDMENT TO CITY SECRETARY CONTRACT NO.48936 Page 2 of 4 VI. Exhibit C of the Agreement is amended to add the following: North Service Center 301 Hillshire Drive Fort Worth, TX 76052 1`-Shift: lam :4pm Monday Thru Friday * Estimated Quantity of Vehicles &Equipment Assi ned this Location is: 200-220 VII. Exhibit D of the Agreement is amended to be and read as set forth in Attachment 2 to this First Amendment. VIII. 1. City and Contractor agree that execution of this First Amendment shall not affect the maximum amount of compensation City shall pay Contractor (an amount not to exceed $20,380,805.00 for the Initial Term in accordance with the terms of the agreement and the Cost Methodology in Exhibit B),or compensation City shall pay Contractor during any Renewal Period (an amount not to exceed$12,706,003.00). 2. All other terms and conditions of the Agreement shall remain in full force and effect except as specifically set forth in this First Amendment. 3. All terms of this First Amendment that are capitalized but not defined shall have the meanings assigned to them in the Agreement. [SIGNATURES ON FOLLOWING PAGE] FIRST AMENDMENT TO CITY SECRETARY CONTRACT NO.48936 Page 3 of 4 IN WITNESS WHEREOF,the parties hereto have executed this Amendment in multiples to be effective on May 29, 2018. ACCEPTED AND AGREED: CITY OF FORT WORTH: CONTRACT COMPLIANCE MANAGER: By signing I acknowledge that I am the By: person responsible for the monitoring and Assistantt City Manager esus J. administration of this contract, including ity ensuring all performance and reporting Date: l r� requirements. APPROVAL RECOMMENDED: By: B Assistant Property Management j r�S Director L _4W Director of Property Management APPROVED AS TO FORM AND _ ()RT ST: LEGALITY: ' y' By. ary . I e Richard A. McCracken City Secr Lary Assistant City Attorney 'r CONTRACT AUTHORIZATION: M&C: VIp1 CONTRACTOR: Genuine Parts Company ATTEST: d/b/a NAPA Auto Parts NANCY E. RODEF Notary Public,State c By; �L ✓ q'• +c Comm.Expires 02-0! °;, �` Notary ID 129294 2tu3b7ry Name:Prestdent Title:: IYA�(c(s Date: 11/02/18 IONNUAL RECORD Ct*rl SECRETARY FIRST AMENDMENT TO CITY SECRETARY CONTRACT NO.48936 FrTPWWH,'TX ATTACHMENT 1 City of Fort Worth Operational Projections with Addition of North Service Center *Projections subject to change based on actual monthly costs and expenses incurred relative to the operation of the On Site Store(s) 2018 Combined 2019 Combined 2020 Combined Operation Projections Operation Projections Operation Projections Expense Descriptions Expense Category Jan thru Dec)( (Jan thru Dec) (Jan thru Sept) Monthly Annualized Monthly Annualized Monthly Annualized Customer Part Purchases 369,667 4,436,000 380,757 4,569,080 392,179 3,529,614 Projected Part Purchases Cost of Goods(Less Tires) 312,936 3,755,228 322,324 3,867,885 331,993 2,987,941 Cost of Goods(Less Tires) N Cost of Goods(Tires) 56,731 680,772 58,433 701,195 60,186 541,673 Cost of Goods(Tires) Gross Markup Margin 0 0 0 0 0 0 Z Admin Expense 1,848 22,180 1,904 22,845 1,961 17,648 Accounting and Data Processing Fees 0 2,773 33,270 2,856 34,268 2,941 26,472 General Office a Total Admin Expenses 4,621 55,450 4,759 57,114 4,902 44,120 Payroll Expenses Delivery Driver Salaries 9,224 110,685 9,500 114,006 9,785 88,069 Delivery Driver Salaries Manager/Counter Salaries 41,005 492,065 42,236 506,827 43,503 391,524 Manager/Counter Salaries Employee Pension/401K 1,664 19,962 1,713 20,561 1,765 15,883 Employee Pension/401K z 7,420 89,044 7,643 91,715 7,872 70,850 Group Insurance w a 369 41433 381 4,566 392 3,528 EE Benefits IC w Group Insurance/Benefits Other J 148 1,773 152 1,827 157 1,411 EE Benefits Life Insurance J O 57 682 58 702 60 542 Employee Benefits Other a Workers Comp Insurance 275 3,298 283 3,397 292 2,624 Workers Comp Insurance 725 8,700 747 8,961 769 6,922 Insurance Expense Payroll Taxes 4,072 48,869 4,195 50,335 4,320 38,884 Payroll Taxes FICA 500 6,000 515 6,180 530 4,774 Payroll Taxes UCI Total IBS Payroll Expenses 65,459 785,510 67,423 809,076 69,446 625,011 Delivery Truck Insurance 1,3381 16,060 1,378 16,542 1,420 12,779 Delivery Truck Ins urance Delivery Maintenance/Gas 1,703 20,440 1,754 21,053 1,807 16,264 Delivery Expense Fuel 483 5,800 4981 5,974 513 4,615 Delivery Expense Maintenance Truck Payment 696 8,352 717 8,603 738 6,645 Delivery Expense-Depreciation 35 416 36 428 37 331 Deliver Expense -Leased Facility Expenses 148 1,780 153 1,833 157 1,416 Building/Content Insurance Fixed Asset Depreciation 164 1,967 169 2,026 174 1,565 Fixed Asset Depreciation N 275 3,300 283 3,399 292 2,626 Misc.Store Expenses Z 108 1,300 112 1,339 115 1,034 Misc.Store Expenses x Store Expenses 300 3,604 309 3,712 319 2,868 Stationary/Office Supplies X 0 0 0 0 0 0 Restocking Fees and Inventory expense o1,158 13,900 1,193 14,317 1,229 11,060 Telephone/communication Z 0 0 0 0 0 0 Travel Other 5 978 11,740 1,008 12,092 1,038 9,341 Connectivity/IT/Computers U 334 4,008 344 4,128 354 3,189 NAPA Wan `-^ 555 6,666 572 6,866 589 5,304 Computer Hardware Computers and Support Equipment 540 6,480 556 6,674 573 5,156 Computer Fees 1,308 15,700 1,348 16,171 1,388 12,492 Data processing and maintenance 117 1,400 120 1,442 124 1,114 Computer Equipment Depreciation Taxes-Not Income 3,217 38,598 3,313 39,756 3,412 30,711 Taxes-Not Income Freight&Postage 4,708 56,500 4,850 58,195 4,995 44,956 Freight&Postage-In � -3,827 -45,920 -3,941 -47,298 -4,060 -36,537 Freight&Postage-Out i K Insurance 550 6,600 567 6,798 583 5,251 General Liability Insurance Total IBS Misc Expense 14,891 178,690 15,338 184,051 15,798 142,179 rex TOTAL EXPENSES 84,971 1,019,651 87,520 1,050,240 90,146 811,311 ?02 N Gross Margin Less Expenses -84,971 -1,019,651 -87,520 -1,050,240 -90,146 -811,311 )6 Z Miscellaneous Adjustments 0 0 0 0 0 0 a w IBS Sales contracted at 8% 25,035 300,418 25,786 309,431 26,559 239,035 IBS Sales contracted at S% 2,837 34,039 2,922 35,060 3,0091 27,084 IBS Management Fee 112,842 1,354,108 116,228 1,394,731 119,7141 1,077,430 NAPA's Proposed Return 1 27,8711 334,457 28,708 344,4911 29,5691 266,119 ATTACHMENT City of Fort Worth Payroll Projections with additon of North Service Center and addtional shift for Water Service Center ---------------------------------------------- "Base"Payroll Projections Payroll Escalation(CPI) f 2.5% j 3.0% 1 3.0% (not including Benefits) 2017 Contract Projections 2018 Estimates I Future Estimates 2017 2017 2018 Title Hrs 2017 Pay Rate Range 2018 Annual 2019 Annual 2020 Annual POSITION SHIFT Monthly Annual Current Abv Sch LOW HIGH MID Wages Estimate Monthly Estimate Estimate Estimate Southside Service Center(SSC) Note:Payroll increases are"Projected",actual Pay Rates Ranges will be based on"CPI" Manager 1 7:OOAM-4:OOPM MGR 40 14.73 16.73 15.73 2,819 33,830 2,789 1 33,4711 34,475 1 35,509 Driver 8:00AM-2:00PM DRV 1 30 9.25 11.25 10.25 1,201 14,411 1 1,2011 14,4111 14,843 1 15,289 James Avenue Service Center Note:Payroll increases are"Projected"actual Pay Rates Ranges will be based on"CPI" Manager 7:OOAM-5:OOPM MGR 50 4,310 4,995 4,653 4,792 57,505 4,912 58,944 60,712 62,534 Counter Pro 7:OOAM-4:OOPM CTR 40 14.55 16.55 15.55 2,787 33,442 2,758 33,095 34,088 35,110 Counter Pro 7:OOAM-4:OOPM CTR 40 14.55 16.55 15.55 2,787 33,442 2,732 32,782 33,765 34,778 Counter 2 12:30PM-11:30PM CTR 40 13.50 15.50 14.50 2,599 31,184 2,575 30,902 31,829 32,784 Counter Pro 11:00AM-10:00PM CTR 40 14.55 16.55 15.55 2,599 31,184 2,880 34,556 35,593 36,661 Driver 7:OOAM-4:OOPM DRV 40 10.73 12.73 11.73 2,102 25,227 1,998 23,970 24,689 25,430 P/T Driver 2 8:OOAM-2:OOPM DRV 30 10.73 12.73 11.73 1,374 16,492 1,374 16,492 16,987 17,496 P/T Driver 1 2:OOPM-8:30PM DRV 30 9.95 11.95 1 10.95 875 10,503 875 1 10,503 1 10,8181 11,142 Water Service Center Note:Payroll increases are"Projected",actual Pay Rates Ranges will be based on"CPI" Manager 7:OOAM-4:OOPM MGR 40 16.90 18.90 17.90 3,208 38,496 3,167 38,002 39,142 40,316 Counter 7:OOAM-4:OOPM CTR 40 14.00 16.00 15.00 2,688 32,260 2,575 30,902 31,829 32,784 Driver 7:30AM-4:OOPM DRV 40 9.95 11.95 10.95 1,962 23,550 1,931 23,177 23,872 24,588 Counter 12:30PM-11:30PM CTR 40 14.00 16.00 15.00 - - 2,575 30,902 31,829 32,784 North Service Center(NSC) Note:Payroll increases are"Projected",actual Pay Rates Ranges will be based on"CPI" Manager 7:OOAM-4:OOPM I MGR 1 45 16.90 18.90 1 17.90 1 3,470 1 41,642 1 42,8911 44,177 Driver 7:30AM-4:OOPM I DRV 1 40 10.73 12.73 1 11.73 1 1,844 1 22,133 1 22,797 1 23,481 NAPA Management and Administrative Note:Payroll increases are"Projected",actual Pay Rates Ranges will be based on"CPI" Project Mgr 7:00AM-5:00PM PRO 40 1 4,750 5,400 5,075 5,227 1 62,727 5,335 64,018 65,939 67,917 Admin 8:30AM-5:30PM ADM 40 14.00 16.00 15.00 2,688 32,260 2,575 30,902 31,829 32,784 Inv Mgr 7:OOAM-4:OOPM INV 40 14.00 16.00 15.00 2,688 32,260 2,662 31,946 32,905 33,892 Floater 7:OOAM-4:OOPM CTR 40 20 42,398 508,772 50,229 602,750 620,832 639,457 51,736 53,288 • Projections subject to change based on actual monthly costs and expenses incurred relative to the operation of the On Site Store(s) For any approved hours physically worked over forty(40)in a given work week,for non-exempt employees,those employees will be paid at 1&112 times their normal hourly Rate of Pay ATTACHMENT 2 NAPA Staffing Schedules Amended to add North Service Center and addition possition to Water Service Center SOUTHSIDE JAMES AVE. WATER DEPT. NORTH SC PROJECT SUPPORT COMBINED POSITION SUMMARY Hours of Operation 22 2 2 `O N m d a d a N m v m y v v v > .> 40 Cr v v m Q U U U a Q K io O O ' Q m Q O "O C a o a n. a u u o d d 0.. Q LL N d u o n 7:00 7:30 X 1 0 X X X X 3 1 X X 2 1 01 X 1 11 01 X I X X 3 0 4 1 3 10 7:30 8:00 X 1 0 X X X X 3 1 X X X 2 1 1 X 1 1 01 X I X X 1 1 3 0 4 2 3 11 8:00 8:30 X X 1 1 X X X X X 3 2 X X X 2 1 X X 1 1 X X X 3 0 4 4 3 13 8:30 9:00 X X 1 1 X X X X X 3 2 X X X 2 1 X X 1 1 X X X X 3 0 4 4 4 14 9:00 9:30 X X 1 1 X X X X X 3 2 X X X 2 1 X X 1 1 X X X X 3 0 4 4 4 14 9:30 10:00 X X 1 1 X X X X X 3 2 X X X 2 1 X X 1 1 X X X X 3 01 4 41 41141 10:00 10:30 X X 1 1 X X X X X 3 2 X X X 2 1 X X 1 1X X X X 3 0 4 41 4114 10:30 11:00 X X 1 1 X X X X X 3 2 X X X 2 1. X X 1 1 X X X X 3 0 4 4 4 14 11:00 11:30 1 X 01 1 X X X X X 3 2 X X X 2 1. X 0 1 X X X X 2 0 3 41 4113 11:30 12:00 X 01 1 X X X X X 3 2 X X 1 1 X 0 1 X X X X 1 0 3 4 4 12 Noon 12:30 X X 1 1 X X X X X 4 1 X 0 1 X X 1 1 X X 2 0 4 3 2 10 12:30 1:00 X X 1 1 X X X X X 4 1 X X X 1 1 X X 1 1 X X 2 0 4 3 2 11 1:00 1:30 X X 1 1 X X X X X X X 5 2 X X X 2 0 X X 1 1 X X X 3 0 5 3 3 14 1:30 2:00 X X 1 1 X X X X X X X 5 2 X X X X 2 1 X X 1 1 X X 3 0 5 4 2 14 2:00 2:30 X 1 0 X X X X X X 4 2 X X X X 2 1. X 1 0 X X X X 3 0 4 3 4 14 2:30 3:00 X 1 0 X X X X X X 4 2 X X X X 2 1. X 1 0 X X X X 1 3 0 4 3 4 14 3:00 3:30 X 1 0 X X X X X X X 5 2 X X X X 2 1. X 1 0 X X X X 3 0 5 3 4 15 3:30 4:00 X 1 0 X X X x X X X 5 2 X X X X 2 1. X 1 0 X X X X 3 0 51 3 1 4 15 4:00 4:30 01 01 X X X X 3 1 X 0 0 X 1 01 X X 0 2 2 1 2 5 4:30 - 5:00 0 0 X X X. X 3 1 1 X 0 0 X 11 01 X X 0 2 2 1 2 5 5:00 - 5:30 0 0 X X X 2 1 X 0 0 01 0 X 1 0 2 2 1 1 4 5:30 6:00 0 0 x, X X 2 1 X 0 0 0 0 1 1 0 2 2 1 0 3 6:00 6:30 0 0 X 1 0 1 0 0 0 0 1 1 0 2 1 0 0 1 6:30 7:00 0 0 X X 1 1 0 0 0 0 1 1 01 2 1 1 0 2 7:00 7:30 0 0 X X 1 1 X 0 0 0 0 1 01 2 1 1 0 2 7:30 8:00 01 0 X X 1 1 1 X 01 0 0 0 0 2 1 1 0 2 8:00 8:30 1 01 0 1 X I X X 2 1 1 X 1 0 0 1 01 0 0 2 2 1 0 3 8:30 9:00 01 0 1 X X 2 1 0 X 1 0 0 01 0 1 0 2 2 0 0 2 9:00 9:30 0 0 X X 2 0 X 0 0 0 0 0 2 2 0 0 2 9:30 10:00 0 0 X X 2 0 X 0 0 0 0 0 2 2 0 0 2 10:00 10:30 0 0 X 1 0 X 0 0 0 0 0 2 1 0 0 1 10:30 - 11:00 0 0 X 1 0 X 0 0 0 0 0 2 1 0 0 1 11:00 11:30 0 0 X 1 0 X 0 0 0 0 0 2 1 0 0 1 11:30 - 12:00 0 0 0 0 0 0 0 0 �O3 2 1 0 0 0 Hours/Day 8 6 5 5 11018 8 8 8 8 6+6 5 5 8 8 10 8 5 5 9 6 5 5 10 8 8 8 0 5 5 4 17