Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Agenda_GGAF_12.02.2020
Notice of Meeting for the General Gov ernment and F inance Adv isory B oard of the City of Georgetown December 2, 2020 at 4:30 P M at Virtual T he C ity of G eorgetown is committed to compliance with the Americans with Disabilities Act (ADA). If you require as s is tance in partic ipating at a public meeting due to a disability, as defined under the ADA, reas onable as s is tance, adaptations , or ac commodations will be provided upon request. P leas e c ontact the C ity S ec retary's O ffic e, at leas t three (3) days prior to the sc heduled meeting date, at (512) 930-3652 or C ity Hall at 808 Martin Luther King Jr. S treet, G eorgetown, T X 78626 for additional information; T T Y users route through R elay Texas at 711. Consiste nt with Gover nor Gr eg A bbott’s suspension of var ious provisions of the O pen M ee tings A ct, e ffec tive A ugust 1, 2020 and until fur the r notic e, to r educ e the c hance of C O V I D-19 tr ansmission, all C ity of Ge orge town Advisor y B oar d mee tings will be held vir tually. P ublic c omment will be allowed via telec onfer ence ; no one will be allowed to appear in pe rson. To participate , please c opy and paste the following we blink into your browse r: Weblink: J oin Zoom M e eting https://geor getowntx.zoom.us/j/99589976072? pwd=T3 F W Z2l V Y VA zajdsUzdo M D Z B djdw U T09 M e eting I D: 995 8997 6072 P assc ode : 980568 O ne tap mobile +13462487799,,99589976072#,,,,,,0#,,980568# U S (H ouston) +12532158782,,99589976072#,,,,,,0#,,980568# U S (Tac oma) Dial by your loc ation +1 346 248 7799 U S (H ouston) +1 253 215 8782 U S (Tac oma) +1 669 900 6833 U S (San J ose) +1 312 626 6799 U S (Chic ago) +1 929 205 6099 U S (Ne w Yor k) +1 301 715 8592 U S (Washington D.C) 833 548 0276 U S Toll-fre e 833 548 0282 U S Toll-fre e 877 853 5257 U S Toll-fre e Page 1 of 199 888 475 4499 U S Toll-fre e M e eting I D: 995 8997 6072 P assc ode : 980568 F ind your loc al numbe r: https://geor getowntx.zoom.us/u/az63il0 P O Citizen comme nts are acc epted in thr ee differ ent for mats: 1. Submit written comme nts to danella.e lliott@ge orge town.org by noon on the date of the mee ting and the R ec ording S ec re tary will r ead your c omments into the r ec ording during the item that is being discussed. 2. L og onto the mee ting at the link above and “r aise your hand” during the item. 3. Use your home /mobile phone to call the toll-fre e numbe r To join a Zoom me eting, c lick on the link provided and join as an attende e. You will be aske d to e nte r your name and email addre ss (this is so we can ide ntify you when you ar e c alled upon). To spe ak on an item, clic k on the “Raise your H and” option at the bottom of the Zoom mee ting we bpage once that ite m has opened. Whe n you are calle d upon by the Re cor ding Se cr etar y, your devic e will be r emotely un-muted by the A dministrator and you may spe ak for thre e minute s. P lease state your name clear ly, and when your time is over, your de vice will be muted again. Use of pr ofanity, thr eate ning language, slande rous r emarks or thr eats of harm are not allowed and will re sult in you be ing imme diately re moved fr om the mee ting. Regular Session (T his R egular S es s ion may, at any time, be rec es s ed to c onvene an Exec utive S es s ion for any purpose authorized by the O pen Meetings Act, Texas G overnment C ode 551.) A Disc ussion on how this virtual c onference will be c onducted, to inc lude options for public c omments and how the public may addres s the C ommis s ion –Tommy G onzalez, G G AF C hair B C ons ideration and p o s s ib le ac tion to approve the minutes fro m the O c tober 28, 2020 G eneral G overnment and F inanc e Advisory Board Meeting - S haron P arker, Board Liais on C C ons ideration and possible action to recommend to C ity C ouncil the purchas e of two P ierc e F ire Engines from S iddons-Martin Emergenc y G roup through the Buy-Board C ontrac t #571-18 for a cost not to exceed $1,760,000.00. –John S ullivan, F ire C hief D P resentation and update of an as s es s ment c onducted by G artner to evaluate bus iness processes and gaps in the C ustomer Information S ystem (C I S ), and Advanc ed Metering Infras tructure (AMI) and Meter Data Management (MDM) s ystems . - Mayra C antu, M anagement Analyst E Disc ussion and possible recommend ation to ap p ro ve is s uance o f a P urchase Order for utility bill Page 2 of 199 printing and mailing services thro ugh 2/21/2022 to Datapros e LLC purs uant to a piggyback c laus e in an agreement with the C ity of P lano at an annual cost of $315,840. - C indy P ospisil, Customer Care Manager F C ons ideration and possible ap p ro val to purc hase Zerto O rches tration S oftware through S irius C omputer S olutions for a total of $84,247.00. - James Davis , I T Manager - O perations G C ons ideration and pos s ible ap p ro val to p urc has e rep lacement lapto p s and tablets , assoc iated doc ks and port rep licato rs , and in-vehic le modems for emergenc y s ervic e vehicles, as well as new ruggedized laptops and c o mp uter equip ment fo r two new P o lice O ffic ers from Ingram Technologies LLC for an amo unt of $118,046.27 – Jess Henderson, P ublic S afety I T Manager Adjournment Ce rtificate of Posting I, R obyn Densmore, C ity S ecretary for the C ity of G eorgetown, Texas, do hereby c ertify that this Notic e of Meeting was posted at C ity Hall, 808 Martin Luther King Jr. S treet, G eorgetown, T X 78626, a plac e readily acc es s ible to the general public as required by law, on the _____ day of _________________, 2020, at __________, and remained s o posted for at leas t 72 c ontinuous hours prec eding the s cheduled time of said meeting. __________________________________ R obyn Dens more, C ity S ec retary Page 3 of 199 City of Georgetown, Texas Government and Finance Advisory Board December 2, 2020 S UB J E C T: C onsideration and p o s s ib le ac tion to approve the minutes from the O c tober 28, 2020 G eneral G overnment and F inance Advis ory Board Meeting - S haron P arker, Board Liaison IT E M S UMMARY: F IN AN C IAL IMPAC T: . S UB MIT T E D B Y: S haron P arker AT TAC H ME N T S: Description Type 10.28.2020 Draft Minutes Cover Memo Page 4 of 199 Minutes of Meeting of the GENERAL GOVERNMENT AND FINANCE ADVISORY BOARD (GGAF) City of Georgetown, Texas Wednesday, October 28, 2020 at 4:30 PM The General Government and Finance Advisory Board met on Wednesday, October 28, 2020 at 4:30 PM via Zoom virtual meeting. The City of Georgetown is committed to compliance with the Americans with Disabilities Act (ADA). If you require assistance in participating at a public meeting due to a disability, as defined under the ADA, reasonable assistance, adaptations, or accommodations will be provided upon request. Please contact the City Secretary’s Office, at least three (3) days prior to the scheduled meeting date, at (512) 930-3652 or City Hall at 808 Martin Luther King Jr Street for additional information; TTY users route through Relay Texas at 711. Board Members Present: City Staff Present: Kevin Pitts, Vice-Chair David Morgan, City Manager Stu McLennan, Secretary Laurie Brewer, Assistant City Manager Robert Witt Leigh Wallace, Finance Director Eric Corp Elaine Wilson, Assistant Finance Director Karrie Pursley, Treasurer Tadd Phillips, HR Director Chris Bryce, IT Director Greg Berglund, Assistant IT Director James Davis, IT Manager Stan Holman, Fleet Services Manager Edward O’Neal, Support Services Manager Mayra Cantu, Management Analyst Danella Elliott, Board Liaison Sharon Parker, Board Liaison Board Members Absent: Tommy Gonzalez, Chair Others present: Susan Anderson , Valley View Investments Regular Agenda: Kevin Pitts Called the meeting to order at 4:34 p.m. Leigh introduced Sharon Parker, the new Administrative Assistant in Finance and explained that she will be taking over as Board Liaison for the General Government and Finance Advisory Board. Page 5 of 199 Minutes of Meeting of the GENERAL GOVERNMENT AND FINANCE ADVISORY BOARD (GGAF) City of Georgetown, Texas Wednesday, October 28, 2020 at 4:30 PM A. Discussion on how this virtual conference will be conducted, to include options for public comments and how the public may address the Commission – Tommy Gonzalez, GGAF Chair David Morgan, City Manager explained how the virtual conference would be conducted. A. Review minutes from the August 26, 2020 General Government and Finance (GGAF) Advisory Board – Danella Elliott, Board Liaison. No comments, Motion to approve the minutes by Stu McLennan, second by Robert Witt. Approved 4-0. Tommy Gonzalez absent. B. Presentation, discussion, and update on mitigation since the 2018 risk assessment. – Mayra Cantu, Management Analyst. Mayra Cantu gave an overview of the 2018 Risk Assessment and the changes the City has implemented at this time. The risk assessment was done citywide with the highest risk noted was fire and IT. We have now touched about 97% of all areas. We have made significant changes. In June all staff and council completed the city security awareness training. Significant changes since 2018 • Electric Utility Energy Portfolio Management • Reorganization of City • Workday ERP • Covid-19 • Lost EMS Ipad (possible HIPAA Breach) • Senate Bill 2 (revenue caps) • Shot Clock Legislation • Back-Up Date Center Near Term Actions • Conduct a citywide operational and enterprise risk assessment every 5 years with next study slated for FY23 • Complete Hazard Mitigation Plan • Implement consultants’ recommendations • Conduct an audit of the electric risk management practices • Finalize and initiate internal/external audit work plan • Process improvement • Overall biannual review and update of citywide and departmental policies and procedures • Providing public dashboards of departmental performance management metrics. Discussion: Eric – some of slides are a little different than what was provide on the agenda. Mayra - Presentation was updated, she would give the updated presentation to the board liaison to send to the board. Are there going to be two different risk assessments? Mayra - enterprise would be once every 5 Page 6 of 199 Minutes of Meeting of the GENERAL GOVERNMENT AND FINANCE ADVISORY BOARD (GGAF) City of Georgetown, Texas Wednesday, October 28, 2020 at 4:30 PM years, any other assessments would be for the specific needs of the department. Stu - Is there anything the board needed to be aware of on the HIPPA audit? Chris Bryce – the audit focused largely on IT and how we managed HIPPA data. They gave us about 10 recommendations mostly about documenting policy. What type of system is currently being used for badge access? James - Lenel system. Have the 20/21 water rates study been published yet? Mayra - yes those were part of last night’s CC meeting, and she would send to the board liaison to the link to where this is located at on the City’s website. What are the issues and what software is being considered? Mayra - The problem is we want to merge are process to be more considerate with legal and purchasing we want to be more intentional with how we move along with that process and staff. How does city personnel access the city’s website when working remote? Chris - VPN but only on City devices or utilizing VDI. Water system, are we receiving any push back from Bell County regarding water planning regarding Stillhouse water reservoir? David – the council just agreed to transfer 7600 acres of our CCN of our water territory to Kempner, a water service district and the reason for that is because they requested service and we do not have any customers in that area. I think that kind of work will help go a long way in terms of Bell County realizing that we are not trying to control the development in Bell County. Robert Witt – with the way we are growing do you think we are looking far enough out for water and electric? Myra – I think so, the city is being very proactive and a lot of regional efforts also. David – we must blend planning for the future and managing our risk at the same time. We must be more expressive with our growth pattern. No action needed. C. Consideration and possible action to recommend a resolution formally adopting the City’s Investment Policies for Fiscal Year 2021. – Leigh Wallace, Finance Director Leigh Wallace presented the City’s Investment Policies for Fiscal Year 2021 Investment policy objectives • Safety • Liquidity • Public Trust • Yield Proposed changes • Adding Nathan Parras, Finance Director, as an investment officer • Broker / Dealer list minor editing changes Year in review - Interest earnings declined drastically in 2020. Due to COVID-19 and market changes, the Fed Rate decreased significantly in 2020 to 0-.25%. Example: In August 2019, we accepted a rate of 2.25%, but in September 2020, our highest rate was .30% for 9 months. Continued laddered purchases throughout the year. Renewed Depository Banking Contract through Spring 2022. Susan Anderson – Investment advisor with Valley View Consulting – presented historical yields. Page 7 of 199 Minutes of Meeting of the GENERAL GOVERNMENT AND FINANCE ADVISORY BOARD (GGAF) City of Georgetown, Texas Wednesday, October 28, 2020 at 4:30 PM Discussion: Eric Corp – sometimes we have to wait for things to mature if we find that money markets and investments are changing - what is the process for the investment officers to make changes throughout the year? Leigh – the investment officers have a committee that will look at the market, current cash flows and makes the decisions. Susan – this is one of the reasons you pass the investment policy. It gives you the structures and the parameters. The only time they would have to go back to council is if it is a new investment pool. Are there any major changes for the investment policy for next year? Leigh – they are mild, adding Nathan Parras as one of our investment officers. Change on our broker/dealer list. The quarterly reports go to council, is this something the GGAF could get? Leigh – this is public document; we can alert the board when it has been posted. Kevin Pitts – we do not allow for commercial paper through our policy, does this fall under money market funds? Susan explained some differences options between commercial paper, gateway banks, and CDARS. Rates just are not as good as CD’s. Motion to approve a recommendation of a Resolution formally adopting the City’s Investment Policies for Fiscal Year 2021 by Stu McLennan, second by Robert Witt, Approved 4-0. Tommy Gonzalez absent. D. Consideration and possible recommendation to Council of a contract with Suddenlink to provide dedicated Internet service for a total of $136,620 over three years. – James Davis, IT Manager- Operations James Davis presented a contract with Suddenlink to provide internet service. Discussion: Stu – who is the 2nd provider? James - Fiberlight. Eric – are we getting close to the 200 MB bandwidth? James - Yes, we would monitor on a regular basis and we would receive the full 200 meg. Stu - You mentioned in the notes that no other vendor can reasonably provide this accommodation of services, is that because of the fiberoptic cables? James - A big part of that is going to be because of the feed for channel 10. We have to have that feed with Suddenlink to provide that service and currently they host all of our IP addresses. Robert Witt – Does Suddenlink own all the cable lines here in Georgetown? Chris Bryce – we have talked to other providers and in order for them to serve us they would have to use our fibers to get to access to our data centers which is one thing that prevents us from going to another provider.. Right now, it does not seem that anyone else owns any fiber near our data center. Motion to approve Contract with Suddenlink by Eric Corp, second by Stu McLennan. Approved 4-0 Tommy Gonzalez absent. E. Consideration and possible action to recommend to Council the purchase of vehicles and equipment in the amount of $2,317, 620. – Stan Hohman, Fleet Services Manager Stan Holman presented vehicles and equipment to be purchased. Discussion: Stu – hail damage you have two listed? Stan - we are replacing these two because they were new. Most of the other vehicles that received damage had already been approved to replace. Stu McLennan – are you still getting the whole package from Silsbee Ford? Stan - we reached out to Caldwell also, but they did not respond in a timely manner, so we went with Silsbee. Page 8 of 199 Minutes of Meeting of the GENERAL GOVERNMENT AND FINANCE ADVISORY BOARD (GGAF) City of Georgetown, Texas Wednesday, October 28, 2020 at 4:30 PM Motion to approve recommendation to Council the purchase of vehicles and equipment in the amount of $2,317,62.00 by Eric Corp, second by Stu McLennan. Approved 4-0. Tommy Gonzalez absent. Motion to adjourn meeting by Stu McLennan, second by Kevin Pitts, approved 4-0 Tommy Gonzalez absent. Meeting adjourned at 6:00 p.m. __________________________________ ____________ Tommy Gonzalez Date Board Chair ___ _______________________________ ____________ Stu McLennan Date Board Secretary __________________________________ ____________ Sharon Parker Date Board Liaison Page 9 of 199 City of Georgetown, Texas Government and Finance Advisory Board December 2, 2020 S UB J E C T: C onsideration and pos s ible ac tion to rec ommend to C ity C ounc il the purc hase of two P ierce F ire Engines from S iddons -Martin Emergency G roup through the Buy-Board C ontract #571-18 for a c os t not to exc eed $1,760,000.00. –John S ullivan, F ire C hief IT E M S UMMARY: T hes e apparatuses will be purchas ed through c ooperative purchas ing agreement. T hey have been included in the 2021/22 Annual Budget as part of the F leet R eplacement I S F. T he new apparatus will replac e our 2010 and 2011 P ierce Engines. Delivery time projec ted on this apparatus is ten (10) to eleven (11) months. F IN AN C IAL IMPAC T: T hes e vehic les were budgeted in the 2021/22 F leet R eplacement I S F Budget. S UB MIT T E D B Y: S haron P arker AT TAC H ME N T S: Description Type Siddons-Martin Propos al Cover Memo Buy Board Cover Memo photo Cover Memo Page 10 of 199 Siddons Martin Emergency Group, LLC 3500 Shelby Lane Denton, TX 77073 GDN P115891 TXDOT MVD No. A115890 October 20, 2020 Clay Shell, Assistant Chief GEORGETOWN FIRE DEPARTMENT 3500 D B WOOD RD GEORGETOWN, TX 78628 Proposal For: 2021 Georgetown Pumpers Siddons-Martin Emergency Group, LLC is pleased to provide the following proposal to GEORGETOWN FIRE DEPARTMENT. Unit will comply with all specifications attached and made a part of this proposal. Total price includes delivery FOB GEORGETOWN FIRE DEPARTMENT and training on operation and use of the apparatus. Description Amount Qty. 2 - 702 - Pierce-Custom Velocity Pumper, 2nd Gen (Unit Price - $905,753.00) Delivery within 10-11 months of order date QUOTE # - SMEG-0001285-3 Vehicle Price $1,817,866.00 Multi Truck Discount ($10,000.00) Full Prepay Discount ($49,366.00) 702 - UNIT TOTAL $1,758,500.00 SUB TOTAL $1,758,500.00 BuyBoard 571-18 $1,500.00 TOTAL $1,760,000.00 Price guaranteed for 60 days Taxes: Tax is not included in this proposal. In the event that the purchasing organization is not exempt from sales tax or any other applicable taxes and/or the proposed apparatus does not qualify for exempt status, it is the duty of the purchasing organization to pay any and all taxes due. Balance of sale price is due upon acceptance of the apparatus at the factory. Proposal 2021 Georgetown Pumpers Page 1 of 2 October 20, 2020 Page 11 of 199 Late Fee: A late fee of .033% of the sale price will be charged per day for overdue payments beginning ten (10) days after the payment is due for the first 30 days. The late fee increases to .044% per day until the payment is received. In the event a prepayment is received after the due date, the discount will be reduced by the same percentages above increasing the cost of the apparatus. Cancellation: In the event this proposal is accepted and a purchase order is issued then cancelled or terminated by Customer before completion, Siddons-Martin Emergency Group may charge a cancellation fee. The following charge schedule based on costs incurred may be applied: (A) 10% of the Purchase Price after order is accepted and entered by Manufacturer; (B) 20% of the Purchase Price after completion of the approval drawings; (C) 30% of the Purchase Price upon any material requisition. The cancellation fee will increase accordingly as costs are incurred as the order progresses through engineering and into manufacturing. Siddons-Martin Emergency Group endeavors to mitigate any such costs through the sale of such product to another purchaser; however, the customer shall remain liable for the difference between the purchase price and, if applicable, the sale price obtained by Siddons-Martin Emergency Group upon sale of the product to another purchaser, plus any costs incurred by Siddons-Martin to conduct such sale. Acceptance: In an effort to ensure the above stated terms and conditions are understood and adhered to, Siddons-Martin Emergency Group, LLC requires an authorized individual from the purchasing organization sign and date this proposal and include it with any purchase order. Upon signing of this proposal, the terms and conditions stated herein will be considered binding and accepted by the Customer. The terms and acceptance of this proposal will be governed by the laws of the state of Texas. No additional terms or conditions will be binding upon Siddons-Martin Emergency Group, LLC unless agreed to in writing and signed by a duly authorized officer of Siddons-Martin Emergency Group, LLC. Sincerely, Travis Walden I, _____________________________, the authorized representative of GEORGETOWN FIRE DEPARTMENT, agree to purchase the proposed and agree to the terms of this proposal and the specifications attached hereto. __________________________________________________________ Signature & Date Proposal 2021 Georgetown Pumpers Page 2 of 2 October 20, 2020 Page 12 of 199 Buy Board Contract 571-18 Contract No.:571-18 Date:10/20/2020 Agency:Contractor: Contact:Prepared: Phone:Phone: Fax:Fax: Email:Email: Prod. Code:10 Description: 503,555.12$ Cost Cost 334,962.00$ Subtotal B: 334,962.00$ 838,517.12$ Cost Cost 117,922.00$ Subtotal C: 117,922.00$ 14% Cost Cost Subtotal D: -$ 956,439.12$ 2 956439.12 =Subtotal E: 1,912,878.24$ Subtotal F: 1,500.00$ Cost Cost (49,366.00)$ (95,012.24)$ (10,000.00)$ (59,366.00)$ (95,012.24)$ Subtotal G: (154,378.24)$ 1,760,000.00$ Jeff Doran 281-442-6806 Description Description B. Published Options - Itemize below - Attach additional sheet(s) if necessary - Include Option Code in description if applicable. jdoran@siddons-martin.com Subtotal of column Subtotal of Column Description Description 100% Pre-Payment Discount Contract Discount Multi-Unit Discount X Subtotal of A + B + C + D: D. Other Cost Items Not Itemized Above (e.g. Installation, Freight, Delivery, Etc.) Description Description Description Description Subtotal From Additional Sheet(s): C. Unpublished Options - Itemize below / attach additional sheet(s) if necessary. Total Published Options CONTRACT PRICING WORKSHEET for motor vehicles only Velocity Pumper A. Product Item Base Unit Price Per Contractor's Buy Board Contract: N/A City of Georgetown Asst. Chief Clay Shell 512-930-3473 clay.shell@georgetown.org Siddons-Martin Emergency Group H. Total Purchase Price (E+F+G): Delivery Date: 10- 11 Months ARO Subtotal From Additional Sheet(s): Quantity Ordered: Check: Total cost of Unpublished Options (C) cannot exceed 25% of the total of the Base Unit Price plus Published Options (A+B). F. Buy Board Fee Calculation (From Current Fee Tables) E. Total Cost Before Any Applicable Trade-In / Other Allowances / Discounts (A+B+C+D) Page 13 of 199 Option Published Unpublished Number Qty Description Options Options 102 1 Add Frame Liner Custom $1,814.00 105 1 upgrade to 22,800# front axle $2,175.00 109 1 TAK-4 Suspension $16,965.00 127 1 Mud Flaps $606.00 136 1 12 or 120 volt air compressor $1,855.00 137 1 Brake fittings compression type $1,437.00 140 1 Cummins L9 400hp to 450hp L9 $2,103.00 141 1 Cummins L9 450hp to Detroit DD13 470 hp $20,187.00 142 1 Detroit DD13 470 to 525 $4,788.00 149 1 EVS 3000 TO 4000 $9,661.00 151 1 Aggressive Down shift $143.00 159 1 Add Extended Bumper $2,335.00 161 2 Bumper tray with cover $1,936.00 173 1 Stainless Door Jamb Scuffplates $721.00 174 1 Mounting plate on engine tunnel $505.00 176 9 Electric Door locks $10,431.00 179 1 Safety System $10,111.00 186 2 EMS Compartment in Cab $5,336.00 187 2 EMS Compartment w outside access (each)$5,662.00 190 7 Handrail with LED Lighting Cab $4,032.00 192 1 Cab Windows Factory Tint $504.00 208 7 Spare 12 volt power (each)$833.00 209 1 Radio with Weatherband $1,070.00 215 1 install Customer radio $947.00 221 1 Camera System Rear only $1,087.00 235 4 Intercom Headset - wireless $4,080.00 237 1 IOTA Charger $1,185.00 246 1 Auto-eject 30 amp $1,224.00 247 1 Transfer switch $628.00 254 1 LED body perimeter additional $1,978.00 255 1 LED Headlights $1,800.00 256 1 12 volt LED Scene - A $1,308.00 259 1 12 volt LED Flood Brow light B $2,679.00 262 2 12 volt-Hi Viz LED (per light)$3,572.00 264 2 12 volt LED Flood Recessed or surface (per light) B $3,704.00 267 1 Tail Board Upgrade Package $1,815.00 275 1 Hose Bed Cover, Aluminum $5,853.00 278 3 Additional Hosebed Divider $1,599.00 279 1 NY Hose Bed $2,874.00 292 1 Full Height - Depth Compartments $5,792.00 297 1 LED Compartment Lighting premium $3,219.00 309 14 Mate Flex in Enclosed Compartments Per Shelf $1,792.00 310 5 Adjustable Compartment shelves $1,000.00 312 1 Swing-out tool board $1,747.00 314 7 Slide-out floor tray $5,894.00 316 1 Adjustable slide-out tray $725.00 319 7 PegBoard in compartment $3,899.00 325 1 SCBA Cylinder storage in fender panel single (each)$682.00 327 2 SCBA Cylinder storage in fender panel triple (each)$1,918.00 329 3 Extinguisher Compartment $2,010.00 337 1 add pump anodes (pair)$362.00 338 1 Add Mechanical Seal to Pump $883.00 344 1 2.5" Discharge front bumper $3,123.00 350 4 2.5" Discharge $7,232.00 351 1 3" Discharge $2,675.00 353 1 Add Large Diameter Side Discharge $5,737.00 357 1 Extenda-gun 18"$4,270.00 364 1 Add Hinged-Type Aluminum Cover to Crosslay (per set of 2)$696.00 367 2 Poly Tray additional $1,096.00 Page 14 of 199 379 1 Pierce Husky 12 Single Agent (5) discharge $18,313.00 382 1 Foam Cell 20 Gallons $1,568.00 392 1 Tank Level LED Group $1,368.00 420 1 Additional Speaker $645.00 422 1 Q2B Siren $4,122.00 423 1 Chrome Bell with manual pull string $1,702.00 429 1 Traffic Directing light bar "B"$2,426.00 438 1 Hydraulic 6 KW $18,963.00 458 1 Light Tower 12 volt 4 - Lights $13,448.00 461 1 Electrical Receptacle duplex (per each) 15 or 20 amp $299.00 495 1 Two-tone Cab paint $2,233.00 506 3 Graphics Upgraded 4 $14,118.00 507 5 Extended Chassis Warranty (per year)$23,920.00 508 5 Extended Body Warranty (per year)$30,990.00 567 4 Each Portable Hand Light w/ Mounting Brackets $552.00 576 2 Piston Intake $4,000.00 1362 1 TFT XFC-52 Crossfire Monitor Package $5,006.00 1363 1 Radio, Motorola APX 7500, Georgetown 2017 Units $7,500.00 1364 1 BK Kustomz Poly Package for Georgetown FD $6,000.00 3634 2 Tray, Hose, Running Board, Soft Suction Hose, 25' of 5.00"$1,163.00 5080 5 Reducer, 2.5"$669.00 5447 1 Upgrade Foam Cell 30 Gallons $148.00 10458 2 Platform, Slide Out, 500 lb Capacity, w/Morton Cass $3,488.00 13897 1 Upgrade Tank to New York Style $6,066.00 15215 1 Reel, Booster, Over Pump, Right Side, Steel $3,665.00 19845 6 Guard, Drip Pan, S/S, Rollup Door $938.00 27844 1 Fluid, 4000 Series Trans, Allison Approved TES-295 Synthetic $541.00 35500 1 Raised Pump House Structure, Side Control $866.00 41289 1 Notch, Poly Tank, Hose, Hydraulic Lines or Wiring $346.00 60016 1 Upgrade Pumper, Long $6,682.00 79144 1 Inserts, Screws, For All Cab Door Panels $408.00 512420 1 Key Pad, Electric Door locks $510.00 546420 1 Hose, Booster - 200' of 1.00"/800 PSI, (50+50+50+50)$405.00 552481 1 Refill, Foam Tank, Single Tank, Husky 12, Class A Foam $1,060.00 553725 1 Restraint, Water Tank, Heavy Duty, Special Type Tank, 4x4, or Export $544.00 559503 4 Install Customer Provided Portable Radio Charger(s)$535.00 564202 1 Upgrade Chassis to Big Block $3,645.00 566101 1 Recess, Dash Panel, Officer Side, Vel/Imp $574.00 590572 1 Emblem, Banner, with Lettering, Pair $132.00 590934 2 Hose Restraint, Running Board, Straps, FV Fastener $408.00 597940 1 Install Customer Provided Two-Way Radio Speaker(s)$134.00 601429 2 Housing, Light, Side Scene, Aluminum, Painted, Body Pair $1,205.00 602762 1 Flap, Rear of Alum Hose Bed Cover, Vinyl, Rollup w/Handhold $1,299.00 618799 5 Cable, Vinyl Covered $157.00 635329 1 Modified Poly Tank & Cradle, Ext'd To Rear, Pumper $1,321.00 636428 1 Motion Device for Gamber Johnson Computer Docking Station, 9" Locking Slide Arm $415.00 640003 1 Install Customer Provided Modem $615.00 642303 1 Master Control, Electric Door Locks, Body Drs and Cab Drs $540.00 642600 1 Upgrade EVS 4000 to 4500 $4,298.00 647964 1 Scuffplate, Trim, Hose Bed Edge, Chevron Protection $184.00 648736 1 Cross Tube, Reinforcement, Above Hose Bed $393.00 654498 8 Trim, Rollup Door, Painted Job Color, by Gortite $1,334.00 656031 1 Compt, Backboard Storage, Over Pump $1,836.00 660232 1 Drain, Remote Air Tank, Single Valve, All tanks $542.00 660435 1 Coating, Top Flange, Front Bumper, Outside Exterior, Rhino Lining, Black $394.00 663471 1 Rack, Zico Quic-Lift, Side Sheet Mount $7,865.00 667614 2 Handrail, Crew Cab Door Window Protector, Modified $498.00 681048 1 Elbow, Large Dia Outlet, 30 Deg, 4.00" FNST x 5.00"$546.00 691086 7 Warranty, Engine, DDC DD13, 7 Years $5,843.00 697689 1 Steps, Stirrup, Formed w/Grip Strut, Cab & Crew Cab Doors $1,338.00 Page 15 of 199 729471 1 Tray, Right, Above Air Horns $584.00 741239 1 Upgrade A/C $4,892.00 746113 1 Intercom, Setcom 950W4, 4-Pos, (D,O Wireless), 2C Wireless, AM/FM Mute $4,836.00 747845 1 Cover, 2" Raised Alum Treadplate, 3/4 Width Over Bumper, Rubber Latch $1,594.00 747941 1 Eng Compt, Trans, 24" Wide, 71.25" Ext Height, Full Width, Rollup Door $8,215.00 749728 1 Deadlay(s), Above Engineering Compartment, Special Cap.$1,474.00 762447 2 Lights, Walk Surf, Amdor AY-LB-12HW0** LED/Cargo $540.00 763088 1 Trash Hook, 8' Fire Hooks Unlimited, Fiberglass $192.00 764144 1 Light, Step, Additional, Amdor, AY-LB-12HW012, 12" LED $245.00 764818 1 Step, Folding - Extra, Body Only, Black, w/LED, Trident $352.00 765009 1 Lightbars, Wln, Freedom IV, 2-21.5", ARBR RBRA $4,349.00 765010 1 Upgrade Lightbar $1,398.00 765847 1 Pike Poles $587.00 770851 1 Mounting Provisions, Top of Tank Only, Foam System $599.00 772376 2 Handlight, Streamlight, Vulcan 180, 44305, 12v, Yellow $932.00 775378 1 Step, Spcl Width, Rear Of Body, 8", 45 Deg Corners, (3) Handholds $849.00 780484 1 Upgrade Headlights to HiViz $851.00 780529 1 Antenna, Panorama, Tiger Sharkee, Cell/GPS/Dual Band $1,152.00 785102 1 Steps, Folding, Front of Body, Cargo Bed Access, w/LED, Trident $964.00 793667 1 Cable, Radio to Intercom Interface, Setcom 950, 1 Radio $578.00 796216 2 Floor Extension, Compartment, 1.00" Downturned Lip $683.00 Base Bid 503,555.12$ Published Options 334,962.00$ Total with Published Options 838,517.12$ Unpublished Options 117,922.00$ 14.06% Total Options including Fee 956,439.12$ Page 16 of 199 Page 17 of 199 City of Georgetown, Texas Government and Finance Advisory Board December 2, 2020 S UB J E C T: P res entation and update of an assessment conduc ted by G artner to evaluate busines s proc es s es and gaps in the C us tomer Information S ys tem (C I S ), and Advanced Metering Infrastruc ture (AMI) and Meter Data Management (MDM) sys tems. - Mayra C antu, Management Analyst IT E M S UMMARY: T his item is an update on the findings of the as s es s ment c onducted by G artner. T his assessment reviewed the C ity’s C I S bus iness processes, bus iness capabilities and bus iness need as well as the C ity’s AMI and MDM s ystem’s func tionality. T he key objectives of the engagement: · Evaluate the C ity’s C I S bus iness processes agains t the c urrent C I S s ystem, identify gaps or areas for opportunities, and explore alternative options to improve the C ity’s C I S operations and s upporting tec hnologies · Evaluate the b us ines s value provid ed b y the AMI and MDM sys tems to enab le the C ity to meet its s mart meter information needs G artner develo p ed a s et of recommend ations fo r a go ing-fo rward s trategy to mitigate o uts tand ing billing is s ues and c lo s ing gap s b etween current C I S c apabilities and the C ity’s b usines s need s as well as providing recommendations that serve the s mart meter information needs of the C ity. F IN AN C IAL IMPAC T: T he c os t of the s tudy was $210,000. T here are varied costs in the implementation of the rec ommendations. S UB MIT T E D B Y: S haron P arker AT TAC H ME N T S: Description Type Go G CIS AMI MDM Executive Pres entation Cover Memo Page 18 of 199 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved.Gartner is a registered trademark of Gartner, Inc. or its affiliates.This presentation, including all supporting materials, is proprietary to Gartner, Inc. and/or its affiliates and is for the sole internal use of the intended recipients. Because this presentation may contain information that is confidential, proprietary or otherwise legally protected, it may not be further copied, distributed or publicly displayed without the express written permission of Gartner, Inc. or its affiliates. CIS & AMI/MDM Assessment –Executive Presentation December 2nd, 2020 v1.0 Engagement Number: 330063873 Page 19 of 199 2 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved. RESTRICTED DISTRIBUTION Table of Contents 1 2 Engagement Background and Objectives Key Findings 3 Recommendations Page 20 of 199 3 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved. RESTRICTED DISTRIBUTION 1. Engagement Background and Objectives Page 21 of 199 4 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved. RESTRICTED DISTRIBUTION This presentation will cover the assessment of the City of Georgetown’s (the City) key utility systems Components that are covered in the full report Assessment of systems which includes the customer information system (CIS), advanced metering infrastructure (AMI) and meter data management (MDM) Commentary and insights into the advanced meter reading system (AMR) and the asset/work management system (Infor) Recommendations for the CIS/AMI/AMR/MDM Systems Prioritization and roadmap for the CIS/AMI/AMR/MDM systems recommendations Page 22 of 199 5 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved. RESTRICTED DISTRIBUTION •To evaluate the CIS business processes against the current key utility systems •To identify gaps or areas of opportunity and explore alternative options to improve the City’s utility operations and supporting technologies Project background and objectives ObjectivesBackground •The CIS system that the City has implemented was based on a prior Utility Strategy that was originally developed in 2012 and updated in 2016. •The Utility Strategy was influenced by the strong electric power market that aligned to a set of goals for the City that are no longer achievable, such as expanding it’s jurisdiction, customer base and associated revenues. •The City’s service territory includes Georgetown itself, plus the rural Western District, which significantly increases the geographic size. The City is currently supported by Electric and Water AMI meters that support two-way communication and can provide usage data on a interval basis. •The City services the Western District (WD) for water only. This area is running AMR meters and it’s usage readings are collected once a month by drive-by. Page 23 of 199 6 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved. RESTRICTED DISTRIBUTION Gartner utilized its proven IT assessment approach to assess the City systems’ current state Presentation of the Inputs and findings from the CIS assessment and AMI/MDM analysis to the City to validate findings and finalize the inputs to the roadmap Interviews & Discovery Gartner’s approach to assess the CIS and analyze the MDM/AMI systems involved the employment of various data gathering methods, analysis frameworks and current research and benchmarking tools IT Assessment ActivitiesIT Assessment Activities Document Review Gartner Research Findings & Validation Business Capability Model Interviews provided insights into the current state of systems and applications at the City, gaps, desired capabilities and outcomes Documents and procedures review provided examples of current status of contracts, architecture, financials and other key data points Gartner Research provided current industry trends and information for benchmarking vendors against peers The business capability model allowed Gartner to map key activities performed by the City and mapped risks Page 24 of 199 7 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved. RESTRICTED DISTRIBUTION Business Fit Degree in which the applications or products supports the City’s business capabilities or processes from a user perspective Information Quality How accurate, secure and timely information provided by the applications or products are? Future Potential Will the application support future known City (or industry) requirements? Reliance on Skills To what degree is there a reliance on a limited number of subject matter experts? Maintainability How easy is it to run and upgrade the applications or products? How much effort is required to integrate applications together? Vendor Support How well do the vendors support the City and are they investing in their products for the future? Architectural Alignment Degree in which the technology stack is aligned to the City’s standards Stability and Security How reliable and secure are the applications and products? Financial What does it cost to operate the applications and products and are they reasonable?Gartner Source: G00373556 The City’s CIS/AMI/MDM solutions were assessed against the nine (9) dimensions of Gartner’s Solution Fitness Assessment Framework Page 25 of 199 8 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved. RESTRICTED DISTRIBUTION 2. Key Findings Page 26 of 199 9 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved. RESTRICTED DISTRIBUTION Based on discovery and assessment activities, Gartner identified common issues across the CIS/AMI/MDM systems which are addressed in the recommendations Integration Inefficiencies Process Inefficiencies Inadequate Training and Change Management System Functionality Redundancies 1 2 3 4 5 Solution Architecture Based on Prior Growth Strategy Integrations between systems often don’t exist or are inefficient leading to duplicate effort, manual processes and potentially unreliable data Processes are impacted by the complexity of the systems and are not standardized across different departments leading to inefficient workflows Training on new systems and change management on systems and processes not fully implemented leading to knowledge gap between system functionality and the City organization The current systems and solution architecture is based on previous vision for the City which has since changed and the City is now operating within a different environment Various functions are managed in multiple systems or can be consolidated into a single system leading to duplicate effort and increasing the risk of integration complications Page 27 of 199 10 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved. RESTRICTED DISTRIBUTION Specific concerns with the CIS system were found in discovery The CIS system was scoped based on a larger city model to support a prior vision that is no longer the goal. This more complex environment makes simple configurations changes difficult to make or manage in-house Due to the size and complexity of the system, more infrastructure and staff time and therefore budget is required to operate the system than anticipated (e.g., managed services contract and staff spending time managing quarterly releases The transition from GUS to the current operating model has changed how CIS support is managed. For example, there was a gap in business knowledge that was causing misinterpretation and impacting prioritization of user needs that is being filled on an interim basis, diverting the FTE from typical duties The system is not right-sized for the City & is more complex than anticipated Associated resources/costs required to maintain the system are higher Misalignment of roles and responsibilities and resource constraint Despite perceptions otherwise, the system is in a stable state The number of tickets has reduced steadily over time and the system is relatively stable. The complexity is primarily driven from size, lack of system automation (test/env), inefficient integration, organizational / resource issues or a lack of system knowledge Insufficient investment adjusting business processes and conducting training Business processes have not fully evolved from those used under the previous system’s operating environment and not enough training have been provided on the new CIS system Data within UMAX is stored in data cubes and has to be highly manipulated to generate a report, this is done using different tools creating inefficiency in reporting Reporting is difficult Page 28 of 199 11 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved. RESTRICTED DISTRIBUTION The discovery process also revealed specific gaps and concerns with the AMI/AMR/MDM system We have limited internal resources to support and develop the solutions, leaving us reliant on our vendors We have complex integrations, yet keeping data between systems synchronized is a major challenge and a cause of process failures The Western District is seeing the highest population growth, but the AMR solutions are end of life and don’t provide the features we get with AMI Managing meter related work in Infor makes things more difficult, without adding any benefit MDM is a significant integration point between AMR/AMI/CIS, has billing rules built in and provides useful functionality such as the ability to directly review customer usage and could do much more Page 29 of 199 12 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved. RESTRICTED DISTRIBUTION Overall, Gartner distilled specific system findings for the CIS, AMI and MDM systems into key findings for each system Key System Findings The City wants to provide services in the most cost effective way and therefor needs to determine the most cost efficient use of future capital and operating spend. The current set of systems are relatively stable, however, the following key findings were iden tified: CIS MDM AMI The system is stable but costly and complex for a utility of the City’s size. This complexity requires a high level of infrastructure to support it and makes the system difficult to maintain without vendor intervention, which drives up costs. The CIS system must be upgraded or replaced by October of 2023. The system is an intricate part of the overall architecture with business rules built into it and a key part of current integrations. However, the vendor has previously not supported direct access to the City data and response time to data requests is too long to be effective; can take months to get a response. The system is fit or purpose and doing what is required of it. The City AMI does not have a historian functionality and therefore a separate MDM system is still required to support future use cases that require historic data (e.g., water loss trend analysis) Page 30 of 199 13 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved. RESTRICTED DISTRIBUTION 3. Recommendations Page 31 of 199 14 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved. RESTRICTED DISTRIBUTION A list of initiatives was developed based on key findings and are categorized according to the impact segment they will have at the City Initiatives Classification Categories Initiatives to support and clearly define the City’s vision and strategy for the future of the utilities. These initiatives also serve as the foundation for the successful implementation of mid to long-term initiatives. Strategic Initiatives Strategic Initiatives Initiatives that comprise the future technology solutions or direction. These initiatives, if implemented, will ensure alignment to the City’s vision, support customer care operations and provide the functionality desired of the systems. Technology Initiatives Technology Initiatives Business Initiatives Business Initiatives These initiatives were identified across business units. Implementing them will enable the business to better meet strategic goals, support growth, provide better customer care, standardize processes, and improve productivity. Each initiative has been plotted onto a roadmap based on duration (found in the appendix): •short-term (3 –6 months), •mid-term (6 –12 months) •long term projects (12 months +) The execution of these projects will depend on upon availability of resource and funding. Page 32 of 199 15 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved. RESTRICTED DISTRIBUTION Strategic Initiatives* Strategic Initiatives* Business Initiatives*Business Initiatives*Technology Initiatives*Technology Initiatives* Recommendations: Key Initiatives to support the City’s vision (AMI/MDM/CIS) 1)Reimplement the CIS (enhancement or new RFP) 2)Implement AMI in the Western District OR 3)AMR meter/module replacement in the Western District 5) Enhance hydraulic model to use MDM data 6) Develop a data and analytics strategy 9) Simplify the meter management processes 10) Enable CRM functionality in the CIS 11) Greater leverage of MDM capabilities 12) Gradually reduce Itineris managed services support 4) Enhance water loss analytics to monitor daily water loss and identify issues sooner 7) Enable automated testing 8) Identify, procure and implement a new Enterprise Integration Platform * Numbering of key initiatives indicates prioritization, however, many initiatives can be done concurrently Page 33 of 199 16 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved. RESTRICTED DISTRIBUTION Strategic Initiatives Strategic Initiatives Business InitiativesBusiness Initiatives Technology InitiativesTechnology Initiatives Recommendations: Quick wins to support the City’s vision (AMI/MDM/CIS) ▪Develop a Western District Strategy Plan and business case * ▪Review previous utility strategies ▪Enhance reporting capabilities ▪Address functional knowledge gaps ▪Align CIS roles and responsibilities ▪Manage installation of water meters in- house ▪Identify an AMI management resource ▪Enhance remote area connectivity ▪Enable direct reporting from ElectSolve ▪UMAX configuration replication ▪Enhance databases and Enterprise Integration Platform expertise ▪Investigate effort to streamline metering and billing exceptions Quick WinsQuick Wins Quick wins represent initiatives that can be done in the short-term, for the most part are low in implementation complexity, require a lower amount of resources than key initiatives and offer quick business value through process improvements or added functionalities . Quick wins can lay the foundation to support medium and long-term key initiatives. * Required before implementing key initiatives 2 or 3 (previous slide)Page 34 of 199 17 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved. RESTRICTED DISTRIBUTION From the list of recommendations, making a decision on how the City will move forward regarding the CIS is of critical importance due to its impact on other initiatives in the roadmap No City accept CIS intervention is required Continue to run UMAX at risk after October 2023 End Accept existing Itineris offer? Yes Renegotiate with Itineris? Go out to tender for new CIS No Yes No Yes New Tender Successful outcome? No Yes New Tender UMAX 365 Upgrade Assumption 1: Meter work order functionality will be migrated from Infor to CIS in all future scenarios Assumption 2: Meter volumes will remain the same, or commercial arrangements will allow reduction should the Western District be divested To start 18 –24 months before UMAX support ends in 10/2023 To start 12 –18 months before UMAX support ends in 10/2023 UMAX 365 Upgrade ^ Compliant solution but cost-inefficiencies persist ^ Very high-risk strategy ^ Cost-optimized, compliant solutionMajorMinorLow/None Residual Risk Key See CIS TCO model See CIS TCO model CIS Decision Tree Page 35 of 199 18 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved. RESTRICTED DISTRIBUTION Likewise, a decision on how the City will proceed with the Western District must be made before other initiatives downstream can be implemented No City retaining Western District? Continue to run AMR in Western District then handover End Compelling Business Case or other reason to upgrade AMR? Yes Continue to run AMR in Western District Yes No Assumption: IPKeys/Electsolve UCentra is fit-for-purpose as the MDM and existing Issues with AMR maintenance is addressed End No longer the City’s issue once migration is complete AMR will continue to be supported by the vendor, but residual issues with meter modules, etc. need to be addressed. Benefits of AMI won’t be realised Go to competitive tender for AMI solution New Tender While a single-vendor may meet all of the City’s needs Water-only AMI will be different to that already deployed ^ Not time bound Major Minor Low/None Residual Risk Key Western District Strategy AMR/AMI Decision Tree Page 36 of 199 19 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved. RESTRICTED DISTRIBUTION In addition to the CIS and Western District initiatives that must be prioritized, Gartner has identified seven (7) other initiatives to prioritize based on their impact to the City Recommendation Impact / Rationale Align CIS Roles and Responsibilities Aligning roles along the CIS and adding a FTE will help mitigate a number of the challenges currently experienced, streamline service intake and reduce reliance on vendor Bring Installation of New Water Meters In-House Making a policy change to remove the responsibility of installing water meters from third parties will improve the quality and accuracy of meter data, reducing errors in CIS Enable Automated Testing Enabling automated testing for releases and configuration changes will allow for rapid business and IT regression testing, reducing time to implement and free up resource Address Functional Knowledge Gaps Addressing knowledge gaps with the UMAX system will help the City deliver additional functionalities desired from the system Enable direct reporting from ElectSolve (MDM)The MDM stores historical information that is currently inaccessible, causing issues that a direct reporting capability would resolve, such as water-metering compliance Develop a Data and Analytics Strategy Foundational changes such as additional resource or a data warehouse will deliver some benefit short-term, but a more cohesive city wide approach is required in the longer term Review Previous Utility Strategies The City should review the prior strategies for the Utility to inform decisions around CIS reimplementation and WD strategy Page 37 of 199 20 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved. RESTRICTED DISTRIBUTION A hight level cost estimate for all initiatives is presented to help the City plan ahead CIS reimplementation $1.2M to $2.4M Implement AMI in the Western District TBC * Replace Western District AMR meters/modules TBC * Enhance water loss analytics $50K to $250K Enhance hydraulic model $50K to $250K Develop a data and analytics strategy $150K to $250K Enable automated testing $50K to $150K Enterprise Integration Platform as a service $100K to $200K Simplify the meter management process $50K to $250K Enable CRM functionality in the CIS $50K to $250K Greater leverage of MDM $50K to $250K Gradually reduce Itineris managed services support $0 1 2 3 4 5 6 7 8 9 10 11 12 Initiative Estimated Cost Total: Quick Win Initiatives $500K- $2.25M to $4.75M * City of Georgetown Budget The City of Georgetown approved its FY 2021 budget on 22 September 2020 totaling $396 Million. •The City’s 2021 budget comes in 10% lower than FY 2020’s budget. •The City is taking a conservative position on budgeting to account for the impacts of COVID and may further impact FY 2022 budgeting. •The water utility has been allocated $28M for capital projects. •The wastewater utility has been allocated $2.7M for capital projects. •The electric utility has been allocated $5.6M for capital projects; $2.5M of which is for customer growth while the remainder is for ongoing system maintenance. * TBC, costs need to be validated through an RFP, will be “High” range. AMI in City was ~ $10M. Page 38 of 199 21 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved. RESTRICTED DISTRIBUTION The City will also require the addition of full -time resources to fully address operational and knowledge gaps Initiatives Requiring Additional Full-Time Resources The initiative to align CIS roles and responsibilities to ensure that there is a resource that understands both the business processes and CIS functionality is estimated to require the addition of 1 full-time employee This is most critical resource gap The initiative to identify an AMI management resource that will be responsible for holistic management of the AMI system is estimated to require 1 full-time employee The initiative to enhance database and middleware management expertise is estimated to require the addition of 1 full-time employee The initiative to enhance reporting capabilities is estimated to require the addition of 1 full-time employee to support reporting and manage reporting tools Recommended initiatives had identified an estimated need for a total of 4 additional full-time positions to fully support City operations Page 39 of 199 22 © 2020 Gartner, Inc. and/or its affiliates. All rights reserved. RESTRICTED DISTRIBUTION Contacts Craig Rintoul Associate Partner, Energy & Utilities Gartner Consulting Phone:+1 303 570 3789 Craig.rintoul@gartner.com Gary Thomas Director, Energy & Utilities Gartner Consulting gary.thomas@gartner.com William Wong Managing Partner Public Sector Gartner Consulting Phone: +1 512 589 9886 william.wong@gartner.com Julio Zambrano Consultant Gartner Consulting Phone: +1 312 206 1590 Julio.Zambrano@gartner.com Page 40 of 199 City of Georgetown, Texas Government and Finance Advisory Board December 2, 2020 S UB J E C T: Dis cus s ion and p o s s ib le rec o mmendatio n to ap p ro ve is s uance of a P urchase Order for utility bill printing and mailing s ervic es thro ugh 2/21/2022 to Dataprose LLC p ursuant to a p iggybac k c lause in an agreement with the C ity of P lano at an annual c os t of $315,840. - Cindy P ospisil, C ustomer C are M anager IT E M S UMMARY: T he C ity award s the utility b ill printing and mailing s ervic e c ontrac t b y utilizing an inter-lo cal agreement with the C ity o f P lano . G eo rgeto wn has benefited fro m the extend ed vo lume p ricing in the P lano contrac t in the pas t and this proc es s s atisfies the s tate p ro curement req uirements . T he C ity of G eorgetown has had muc h s uc cess with P lano ’s vend o r, Datap ro s e, and would like to c ontinue utilizing their s ervic es fo r another year. We anticipate printing and mailing 47,000 bills, no tic es , and ac c o unt spec ific letters (on average/p er month) in the next year. P ostage c o s ts inc reas ed $0.007 in 2020 and are p ro jec ted to increase again in 2021. P os tage is the bulk of this contrac t s o any inc reas es will affec t overall contrac t costs . T he average c o s t per bill is $0.56 and the printing and insertio n p o rtion remained at $0.14. T he total es timated c o s ts of the renewed contrac t are $315,840 (calc ulated b elo w). P ostage is es timated to be $236,880 and printing and insertion s ervic es is $78,960. Bills printed & delivered vis US P S: (47,000 (bills/month) x .56 (rate) x 12 (months) = $315,840 F IN AN C IAL IMPAC T: T he to tal c o ntract cost for 2020/2021 is $315,840 whic h is an increase of 9% over p rio r year, o r $26,880. Bec ause o f the large inc reas e, we are in the p ro cess o f releas ing our own reques t fo r p ro p o s al (R F P ) for bill print & mail services this year. S taff rec ommend s ap p ro val of this item. T he funding for the $315,840 is in the 2020/21 C us tomer C are Budget C C 0321, S pend C ategory C ons ulting-G overnmental. S UB MIT T E D B Y: S haron P arker AT TAC H ME N T S: Description Type Piggyback Agreement Backup Material Contract - Data Prose Backup Material Page 41 of 199 {00011134 / v2 / / PURCHASING / PIGGYBACK / 2/13/2020} Piggyback Contract Page 1 of 2 Contract No. _____________ PIGGYBACK CONTRACT WITH THE CITY OF GEORGETOWN, TEXAS THIS AGREEMENT is made and entered into this ____ day of ___________, 2020 (“Effective Date”) by and between the CITY OF GEORGETOWN, TEXAS, a Texas home-rule municipality (the “CITY”) and DATA PROSE, LLC, (the “VENDOR”). WHEREAS, pursuant to Chapter 791 of the Texas Government Code, the CITY has the legal authority to “piggyback” onto a contract procured by another governmental entity when seeking to utilize the same or similar services provided for in said contract in the interest of the public; and WHEREAS, the CITY requires the services of a VENDOR that can provide utility bill printing and mailing and insert printing services, (the “SERVICES”); and WHEREAS, the CITY entered into an Interlocal Agreement with the CITY OF PLANO, TEXAS, a home-rule municipality, under Resolution No. 010808-V on January 8, 2008; and WHEREAS, the VENDOR has previously entered into a Contract dated January 31, 2017 with the CITY OF PLANO, TEXAS in response to the CITY OF PLANO, TEXAS Bid No. 2016-0370-C for SERVICES (the “CONTRACT”). A copy of the CONTRACT, Bid No. 2016-0370-C, VENDOR’S Response, and amendments to the Contract are attached hereto as Exhibit “A”; and WHEREAS, the CITY desires to “piggyback” onto the above referenced CONTRACT between the VENDOR and THE CITY OF PLANO, TEXAS dated January 31, 2017 for SERVICES, and the VENDOR consents to the aforesaid “piggybacking.” NOW THEREFORE, in consideration of the mutual covenants contained herein, and for other valuable consideration received, the receipt and sufficiency of which are hereby acknowledged, the parties agree as follows: 1. The above stated recitals are true and correct. 2. VENDOR affirms and ratifies the terms and conditions of the above referenced CONTRACT and agrees to perform the services set forth therein for the CITY in accordance with the terms of the CONTRACT. 3. The CITY agrees to utilize the SERVICES of the VENDOR in the manner and upon the terms and conditions as set forth in the CONTRACT. 4. This Agreement shall be effective on the date it is fully executed by the CITY and the VENDOR and shall terminate on February 21, 2021. 5. Except as otherwise stated herein, the terms and conditions of the CONTRACT shall form the basis of this Agreement with the CITY having the rights, duties and obligations of the CITY OF PLANO, TEXAS thereunder. The CONTRACT is hereby incorporated Page 42 of 199 {00011134 / v2 / / PURCHASING / PIGGYBACK / 2/13/2020} Piggyback Contract Page 2 of 2 Contract No. _____________ into this Agreement, and if any provision of this Agreement conflicts with any provision of the CONTRACT, then the terms, conditions and provisions of this Agreement shall control. 6. The terms and conditions of the CONTRACT are modified, amended or supplemented as follows: A. Section IV. PAYMENT shall be amended as follows: “The CITY may not expend in excess of $288,960.00 for VENDOR’S SERVICES.” B. Section XVIII. MAILING OF NOTICES shall remain the same except for the Notice address for the CITY which shall be amended as follows: Notice to CITY: City Manager with a Copy to: City Attorney PO Box 409 PO Box 409 Georgetown, Texas Georgetown, Texas David.Morgan@georgetown.org Legal@georgetown.org 7. This Agreement, with all exhibits, includes the entire agreement of the City and the Consultant and supersedes all prior and contemporaneous agreements between the parties, whether oral or written, relating to the subject of this agreement. IN WITNESS WHEREOF, the Parties execute this Agreement. DATA PROSE, LLC CITY OF GEORGETOWN By: ______________________________ By: ______________________________ Printed Name: _____________________ Printed Name: _____________________ Title: ____________________________ Title: _____________________________ Date: ____________________________ Date: _____________________________ ATTEST: __________________________________ Robyn Densmore, City Secretary APPROVED AS TO FORM: __________________________________ Skye Masson, First Assistant City Attorney Page 43 of 199 Page 44 of 199 Page 45 of 199 Page 46 of 199 Page 47 of 199 Page 48 of 199 Page 49 of 199 Page 50 of 199 Page 51 of 199 Page 52 of 199 Page 53 of 199 Page 54 of 199 Page 55 of 199 Page 56 of 199 Page 57 of 199 Page 58 of 199 Page 59 of 199 Page 60 of 199 Page 61 of 199 Page 62 of 199 Page 63 of 199 Page 64 of 199 Page 65 of 199 Page 66 of 199 Page 67 of 199 Page 68 of 199 Page 69 of 199 Page 70 of 199 Page 71 of 199 Page 72 of 199 Page 73 of 199 Page 74 of 199 Page 75 of 199 Page 76 of 199 Page 77 of 199 Page 78 of 199 Page 79 of 199 Page 80 of 199 Page 81 of 199 Page 82 of 199 Page 83 of 199 Page 84 of 199 Page 85 of 199 Page 86 of 199 Page 87 of 199 Page 88 of 199 Page 89 of 199 Page 90 of 199 Page 91 of 199 Page 92 of 199 Page 93 of 199 Page 94 of 199 Page 95 of 199 Page 96 of 199 Page 97 of 199 Page 98 of 199 Page 99 of 199 Page 100 of 199 Page 101 of 199 Page 102 of 199 Page 103 of 199 Page 104 of 199 Page 105 of 199 Page 106 of 199 Page 107 of 199 Page 108 of 199 Page 109 of 199 Page 110 of 199 Page 111 of 199 Page 112 of 199 Page 113 of 199 Page 114 of 199 Page 115 of 199 Page 116 of 199 Page 117 of 199 Page 118 of 199 Page 119 of 199 Page 120 of 199 Page 121 of 199 Page 122 of 199 Page 123 of 199 Page 124 of 199 Page 125 of 199 Page 126 of 199 Page 127 of 199 Page 128 of 199 Page 129 of 199 Page 130 of 199 Page 131 of 199 Page 132 of 199 Page 133 of 199 Page 134 of 199 Page 135 of 199 Page 136 of 199 Page 137 of 199 Page 138 of 199 Page 139 of 199 Page 140 of 199 Page 141 of 199 Page 142 of 199 Page 143 of 199 Page 144 of 199 Page 145 of 199 Page 146 of 199 Page 147 of 199 Page 148 of 199 Page 149 of 199 Page 150 of 199 Page 151 of 199 Page 152 of 199 Page 153 of 199 Page 154 of 199 Page 155 of 199 Page 156 of 199 Page 157 of 199 Page 158 of 199 Page 159 of 199 Page 160 of 199 Page 161 of 199 Page 162 of 199 Page 163 of 199 Page 164 of 199 Page 165 of 199 Page 166 of 199 Page 167 of 199 Page 168 of 199 Page 169 of 199 Page 170 of 199 Page 171 of 199 Page 172 of 199 Page 173 of 199 Page 174 of 199 Page 175 of 199 Page 176 of 199 Page 177 of 199 Page 178 of 199 Page 179 of 199 Page 180 of 199 Page 181 of 199 Page 182 of 199 Page 183 of 199 Page 184 of 199 Page 185 of 199 Page 186 of 199 Page 187 of 199 Page 188 of 199 Page 189 of 199 City of Georgetown, Texas Government and Finance Advisory Board December 2, 2020 S UB J E C T: C onsideration and p o s s ib le ap p ro val to purc hase Zerto O rches tration S o ftware through S irius C omputer S olutions for a total of $84,247.00. - James Davis, I T Manager - O perations IT E M S UMMARY: T his item is to request approval to purchas e Zerto DR O rc hestration S oftware for a total of $84,247.00. Zerto provid es disaster rec overy, b ackup and wo rkload mo b ility s o ftware for virtualized infras tructures and cloud environments . It is a d is as ter rec o very applic ation that copies s erver c onfiguration and d ata fro m our primary data center to our dis as ter recovery data center which then allows for the automated rec overy of up to 75 servers to the dis as ter recovery data center. T he Zerto software will provide the following c apabilities for the C ity: 1. P rovide c ontinuous data protec tion and bac kup to multiple locations. 2. O rches tration that enables full automation of recovery and migration processes for 75 s ervers. 3. R educe the R ec overy Time and R ecovery P oint O bjectives for the protec ted s ystems . 4. T he ability to fully test failover c apabilities without dis rupting production s ystems . 5. T he capability to migrate on premise s ystems to c loud platforms. T his s oftware will be purchas ed fro m S irius C o mp uter S o lutio ns in ac cordance with p ricing and terms and conditions set by the Texas Department of Information R esources agreement DI R -T S O -3680. F IN AN C IAL IMPAC T: All items were b udgeted d uring the F Y 2021 b udget proc es s . Exp ens es will be rec orded in C C 0652 (I T Management) in s pend category (S oftware Maintenanc e S ubs criptions and S upport S ervices). S UB MIT T E D B Y: S haron P arker AT TAC H ME N T S: Description Type Quote Cover Memo Page 190 of 199 Sirius Computer Solutions, Inc. Headquarters: 10100 Reunion Place, Suite 500 San Antonio, Texas 78216 www.siriuscom.com Sirius Tax ID # 74-2836721 Prepared for: CITY OF GEORGETOWN 113 E 8TH STREET GEORGETOWN, TEXAS 78626 UNITED STATES Client Executive: Trent Delomel trent.delomel@siriuscom.com Proposal Number:Q-00124045 Proposal Date:11/05/2020 Expires:11/27/2020 Description:Zerto - 1 Year Currency:USD SOLUTION PROPOSAL Page 191 of 199 Client Executive: Trent Delomel trent.delomel@siriuscom.com Proposal Number: Q-00124045 Proposal Date: 11/05/2020 Expires: 11/27/2020 Description: Zerto - 1 Year Attn: CITY OF GEORGETOWN 113 E 8TH STREET GEORGETOWN, TEXAS 78626 UNITED STATES Proposal #: Q-00124045 1 Sirius Confidential Sirius Computer Solutions, Inc. Headquarters: 10100 Reunion Place, Suite 500 San Antonio, Texas 78216 www.siriuscom.com Sirius Tax ID # 74-2836721 Part #Description Qty Ext. Price ZVR-ECE-ZP-25 ZERTO VIRTUAL REPL ENT CLD ED 25 VM PACK ZERTO E-DELIVERY 3 $61,379.28 ZVR-ECE-MS-PRM-ZP-25 PREM MAINT/SUP VIRTL REPL ENT CLD ED 25 VM PACK ZERTO E-DEL Comments: 1 Year 3 $16,116.75 ZPS-QIKSTR Zerto Quick Start Service provides remote guidance, direction, and knowledge transfer through three scheduled sessions: Introduction & Prerequisites; Installation & Failover Test 1 $6,750.00 Extended Subtotal:$84,246.03 Total Client Price:$84,246.03 Proposal Comments: Terms and Conditions: Unless otherwise noted, price does not include shipping, handling or applicable tax which may be added at the time of invoice. All quoted shipping and handling charges or tax amounts are estimates only, and are subject to change upon invoicing. In the event CITY OF GEORGETOWN (“Customer”) requests expedited shipping, whether such request is made before or after acceptance of this Solution Proposal ("Proposal") by Customer, the price stated above for shipping and handling is subject to change. This Proposal is subject to the Terms and Conditions below and/or any referenced agreements. Acceptance of this Proposal by an authorized representative of Customer will be deemed the equivalent of a Customer Purchase Order, which will authorize Sirius Computer Solutions, Inc. (“Sirius”) to order the products listed in this Proposal. Until Sirius receives and accepts a Purchase Order or a signed copy of this Proposal for the solution proposed, pricing provided in this Proposal is subject to change based on manufacturer's pricing schedule. The products contained on this Proposal may be delivered to the Customer through multiple shipments based upon supplier availability, and Customer agrees to pay one or more partial payments of the total purchase price stated above for any such partial shipment of products. Notwithstanding anything to the contrary in the Terms and Conditions below and/or any referenced agreements, Customer hereby agrees that the products listed on this Proposal are noncancelable, nonreturnable, and nonrefundable except with the express written permission of Sirius. This Proposal shall be governed by the following agreement: DIR-TSO-3680. The provision of the maintenance services contained on this proposal will be controlled by the terms and conditions of the applicable manufacturer and/or maintenance provider (hereinafter the "Provider"), and may be subject to auto-renewal if so provided in the applicable terms and conditions. Sirius does not guarantee any rights of termination during the term of the maintenance services contained on this proposal or any renewal term, and all refund calculations are determined solely by the applicable Provider. If the maintenance services contained on this proposal cover multiple hardware or software components, any discounts provided in this proposal may vary between such components, and all pricing information is confidential and proprietary information of the applicable Provider. If travel is required to perform the proposed Services, Sirius may invoice the Customer for reasonable and actual out-of-pocket travel and living expenses. Page 192 of 199 Proposal #: Q-00124045 2 Sirius Confidential CITY OF GEORGETOWN Accepted by:Approved by: CITY OF GEORGETOWN Sirius Computer Solutions, Inc. Signature of Authorized Representative Signature of Authorized Representative Printed Name Printed Name Title of Authorized Representative Title of Authorized Representative Date Signed Date Signed Ship to Contact (Name, Phone, & Email)Bill to Contact (Name, Phone, & Email) Ship to Address Bill to Address Page 193 of 199 City of Georgetown, Texas Government and Finance Advisory Board December 2, 2020 S UB J E C T: C onsideration and p o s s ib le ap p ro val to purchas e replac ement lap tops and tablets , assoc iated d o cks and port rep lic ato rs , and in-vehic le mo d ems for emergenc y service vehic les , as well as new rugged ized laptops and computer eq uipment fo r two new P olic e O fficers fro m Ingram Technologies LLC fo r an amount of $118,046.27 – Jes s Henders on, P ublic S afety I T Manager IT E M S UMMARY: Every year we rep lace roughly 20-25% of the P anas onic Toughb o o ks used b y the EMS , F ire and P olice Departments. T hes e are fully rugged or s emi-rugged lap top c o mp uters made to withstand the c onditions experienced by our P ublic S afety pers onnel. T his year we are rep lacing 18 c o mp uters with assoc iated warranties , 20 vehic le d o cking s tatio ns, and 16 C radleP oint In-Vehic le modems, at a c o s t o f $107,294.89. Ad d itionally, we are p urc has ing 2 new fully ruggedized lapto p s and doc king s tatio ns for T W O new P olic e O ffic ers ap p ro ved in the 2020/2021 budget, at a c os t of $10,751.38. In the past several years we have p o s itively managed o ur expenses o n ruggedized c o mp uters through s everal changes in our purchas ing proc es s . We have moved from a four year to a five year replacement cycle on the d evic es and we have trans itioned about 40% of the fleet fro m fully rugged devic es to more cost effec tive s emi-rugged d evic es o r s tandard lapto p s o r tab lets . Additio nally, P anas o nic has s een a major inc reas e in c o mp etitio n in this market which has wo rked to drive p ric ing d o wn. As a result, o ur annual expens e has remained flat, or slightly dec reas ed , despite an inc reas ing total numb er o f d evic es purc hased for natural increases in pers onnel and apparatus. Ingram Tec hno lo gies LLC is an Aus tin bas ed reseller fo r P anasonic Toughb o o ks and numerous makes and models o f rugged ized computing eq uipment. All p ricing is in acc o rd anc e with Texas Department of Information R esources contrac t number DI R -T S O -4025 F IN AN C IAL IMPAC T: All items were ap p ro ved d uring the F Y 2020/2021 b udget proc es s . Exp ens es in the amount of $118,046.27 will be rec o rd ed in F und 570 (I T ), C ost C enter C C 0651 (I T Infras tructure), in the “C omputer Hardware” s pend category. S UB MIT T E D B Y: S haron P arker AT TAC H ME N T S: Page 194 of 199 Description Type Toughbook replacement quote Cover Memo Page 195 of 199 Quote Date 11/24/2020 Estimate # 2927 Name / Address City of Georgetown Austin Madison Ship To City of Georgetown Information Technology - 300 Industrial Ave Georgetown, TX 78626 Ingram Technologies LLC c/o Scott Ingram PO Box 203324 Austin, TX 78720 Rep SAI Thank you Signature _____________________________________ Total Sales Tax (0.00) Description Qty MSRP Price Total Texas DIR-TSO-4025 Georgetown, City Of ASM: Scott Morris D-00006BBduQAG Rev#: 13 FZ-55C0-02VM MSRP: $3677.00 Public Sector Specific, Win10 Pro, Intel Core i5-8365U 1.6GHz, vPro, 14.0" FHD 1000 nit Gloved Multi Touch, 512GB SSD, 8GB, Intel Wi-Fi, Bluetooth, TPM 2.0, 4G LTE Band 14 (EM7511), dGPS, Dual Pass (Ch1:dGPS/Ch2:WWAN), Infrared Webcam, Emissive Backlit Keyboard, Flat, CF-SVCPDEP3Y - Toughbook and Toughpad Premier Deployment - Unit Un- Packaging And Assembly (Battery, Stylus/Tether, Case, And Holder). 48 Hour Burn-In, Windows Disk Image Management, Windows Image Validation, Windows Device Imaging, Custom Bios/Cmos Settings, Asset Tagging, Logo Badge Installation (If Purchased), Cellular Sim Insertion, Multi- 6 2,799.90833 16,799.45T Page 1Page 196 of 199 Quote Date 11/24/2020 Estimate # 2927 Name / Address City of Georgetown Austin Madison Ship To City of Georgetown Information Technology - 300 Industrial Ave Georgetown, TX 78626 Ingram Technologies LLC c/o Scott Ingram PO Box 203324 Austin, TX 78720 Rep SAI Thank you Signature _____________________________________ Total Sales Tax (0.00) Description Qty MSRP Price Total Location Shipping With Custom Shipping Labels, Multiple Ship Dates, Packaging Inserts, Deployment Reporting, Customer Portal Access, Up To 5 Minutes Of Post Imaging Configuration, Multiple Images, Service Updates/Engineering Changes, Charge Battery, Up To 59 Days Storage Insured (One Month End) For Years 1,2,3, CF-SVCLTNF3YR - Protection Plus Warranty - Laptop (Years 1, 2, 3) FZ-BAZ1908 MSRP: $167.00 8GB MEMORY FOR FZ-55 MK1 6 119.99833 719.99T CF-SVCPSY5 MSRP: $645.00 4th and 5th years Public Safety Service Bundle Add on (Year 4 & 5 only). Must be purchased in conjunction with PS bundle base unit. Includes Premier, Protection Plus, Customer Portal, Disk Image Management, HDD No Return. 6 549.98167 3,299.89T 7170-0251-P Gamber-Johnson Vehicle docking station (dual pass) for the Panasonic Toughbook CF-54. Inculdes External LIND Power Supply. USB 3.0 (2), VGA, HDMI, RJ45, Serial, Keyed lock, Dual RF Antennas 10 900.041 9,000.41T Page 2Page 197 of 199 Quote Date 11/24/2020 Estimate # 2927 Name / Address City of Georgetown Austin Madison Ship To City of Georgetown Information Technology - 300 Industrial Ave Georgetown, TX 78626 Ingram Technologies LLC c/o Scott Ingram PO Box 203324 Austin, TX 78720 Rep SAI Thank you Signature _____________________________________ Total Sales Tax (0.00) Description Qty MSRP Price Total CF-318B-02VM MSRP: $5,428.00 Public Sector Specific - Premium Dual Pass, Win10 Pro, Intel Core i5- 7300U 2.60GHz, vPro, 13.1" XGA Touch, 16GB(8+8), 256GB SSD, Intel Wi-Fi, TPM 2.0, Bluetooth, Dual Pass (Ch1:WWAN/Ch2:selectable), No PC/Expresscard, 4G LTE-Advanced Multi Carrier (EM7455), dGPS, Emissive Backlit Keyboard, DVD, Flat, CF-SVCPDEP3Y - Toughbook / Toughpad Premier Deployment - Includes Imaging, Customer Portal Access, Multilocation Shipping and Disk Image Management at the Panasonic National Service Center (Years 1,2,3), CF-SVCLTNF3YR - Protection Plus Warranty - Laptop (Years 1, 2 & 3), CF-SVC256SSD3Y - 256GB SSD - Toughbook No return of defective drive (Years 1,2 & 3), CF-SVCADDPRM12B - Absolute Resilience - 12 Month Term - Panasonic PS Bundle Sled Customer Only. 14 3,699.89429 51,798.52T CF-SVCPSY5 MSRP: $645.00 4th and 5th years Public Safety Service Bundle Add on (Year 4 & 5 only). Must be purchased in conjunction with PS bundle base unit. Includes Premier, Protection Plus, Customer Portal, Disk Image Management, HDD No Return. 14 549.98071 7,699.73T Page 3Page 198 of 199 Quote Date 11/24/2020 Estimate # 2927 Name / Address City of Georgetown Austin Madison Ship To City of Georgetown Information Technology - 300 Industrial Ave Georgetown, TX 78626 Ingram Technologies LLC c/o Scott Ingram PO Box 203324 Austin, TX 78720 Rep SAI Thank you Signature _____________________________________ Total Sales Tax (0.00) Description Qty MSRP Price Total 7160-0318-06-P Gamber-Johnson Light-Weight MAG? Dock for Panasonic Toughbook CF-30 and CF-31 with Dual RF/Standard Lock with LIND Internal Power Supply (Ports: (5) USB, (2) Serial, (1) VGA, (2) Ethernet, (1) Speaker, (1) Headphone) 10 1,125.819 11,258.19T MAA1-0900120B-NA MSRP: $1,119.00 1-yr NetCloud Mobile Essentials Plan, Advanced Plan, and IBR900 router with WiFi (1000Mbps modem), no AC power supply or antennas, North America 16 1,000.00188 16,000.03T 170704-002 Mini black, LTE/4G/3G 4.5” 2/3 dBi antenna with SMA connector for all IBR900 Series and IBR600C Series products (1x) 32 12.99 415.68T 170836-000 MSRP: $14.95 Wi-Fi Antenna, Charcoal, Dual-band 2.4/5 GHz 32 14.95 478.40T GPSME MSRP: $47.04 The GPS Mini Mag Antenna is a robust magnetic mount antenna incorporating a sophisticated active antenna with 26dB LNA 6m/19ft SMA(f) 16 35.99875 575.98T Standard Shipping Included 0.00 0.00 Page 4 $118,046.27 $0.00 Page 199 of 199