p 8~~ ~1 d 71.11 ~~ ~~ corv~~ssiQl~E~s~ couRT AGEIVnA REouEST PLEASE FURNISH ONE ORIGINAL AND TEN COPIES OF THIS REQUEST AND DOCUMENTS TO BE REVIEWED BY THE COURT. MADE BY: Leonard Odom MEETING DATE: August 27, 2007 OFFICE: Road & Bridge TIME PREFERRED: SUBJECT: (PLEASE BE SPECIFIC): Consider, discuss, and take appropriate action to purchase Road & Bride software. EXECUTIVE SESSION REQUESTED: (PLEASE STATE REASON) NAME OF PERSON ADDRESSING THE COURT: Leonard Odom ESTIMATED LENGTH OF PRESENTATION: 10 minutes TF PERSONNEL MATTER -NAME OF EMPLOYEE: Time for submitting this request for Court to assure that the matter is posted in accordance with Title 5, Chapter 551 and 552, government Code, is a follows: Meeting scheduled for Mondays: 5:00 P.M. previous Tuesday THIS REQUEST RECEIVED BY: THIS REQUEST RECEIVED ON: All Agenda Requests will be screened by the County Judge's Office to determine if adequate information has been prepared for the Court's formal consideration and action at time of Court Meetings. Your cooperation will be appreciated and contribute towards your request being addressed at the earliest opporhtnity. See Agenda Request Rule Adopted by Commissioners' Court. req 1 ~~~~ E ~ . a w,~ Kerr Coecnty Road & Bridge 40ta San Antonio Hwy Kerrville, Texas 78028 TO: COMMISSIONERS COURT FROM: LEONARD ODOM DATE: August 21, 2007 RE: Road & Bridge Software We are currently using programming of our own design to manage citizens concerns, State Road List, traffic accidents, daily work sheets, work schedules and hours, sign placement and inventory, equipment repairs, and etc. They work well, but are not integrated. We visited with John Trolinger about our needs and what software might be available. Truby has been researching what is available and at what cost. Last week we got information on CompuLink's `Jisual R&B IMS. There are currently 6 counties in Texas using this software. Truby talked with four (Grimes, Falls, Red River, and Denton} and found all of them Iike the product and are extremely pleased with the service they receive. Denton County Road & Bridge has used it for 7 years and said they "couldn't imagine trying to do the jab without it." CompuLink will convert all of our current files to the new system for $500 -$1,000 depending on the amount of data we send them. The regular price for this system is $20,000 + $1,000 annual maintenance fee. They are running a special that ends Oct. 1, 2007 for all twenty-one integrated modules for an annual subscription of $1,750. The only other software we have considered is $20,000 per module + $1,000 annual maintenance fee per module. And the minimum number of modules we would need to replace what we have would be 3, or $60,000 + $3,000 annual maintenance fee. We currently have money in Engineering to pay for the software and conversion and ask the Court to allow us to purchase it at this time. For the upcoming year we would need to set up a tine item for software maintenance. Th compulink t~,~ ~ . 409 Vandiver Drive #4-200 Columbia, MO 65202 B00-879-0517 573-443-1282 FAX:573-449-8200 www.compulink-Itd.com 'Ilse `UwuaB ,"toad & t~cld ye 9~CeyxG.ted 7~Lara yearreoct SyateESC© ~H August 16, 2007 Ms. Truby Hardin, Asst. Administrator KE~R coulvTY 4010 San Antonio Hwy Kerrville, TX 78028 >1,; !i0 annual subscription includes all modules, support and updates Price Reduction ends October 1St, 2007 Dear Ms. Hardin, {yisual`R&B IMS® is a fully integrated 21 module software suite for your Public Works, Road & Bridge and Street department. Our software solution provides control of all current, historical and forecasted costs, inspection histories and provides you with instant (one-mouse click} solutions for many of your day-to-day information needs. l~rsualR&B IMS® represents 15 years of continuous development and engineering enhancements (40,000+ person-hours) - -our modules provide solutions you're looking for. All modules are designed to run independently. or concurrently, so you only implement the modules you need -bring other modules on-line as your data management needs grow. Most information is only a couple of mouse-clicks away - no more file cabinet treks or combining multiple spreadsheets to get the "big" picture of your operations! Native FEMA reports with only a few mouse clicks vs. hundreds of hours of hard work assembling data the way they want it. The same level of data integration flows to GIS platforms, from our free (built-in) GIS to Google Earth's© satellite-sourced-imagery to high-end GIS platforms ranging from ESRI®ArcView/ Arclrtfo® to GeoMedia®, Maplnfo® and most other leading GIS platforms. Our software is currently running in cities and counties with populations from 4,000 to 575,000+, from 6 to 4,900+ square miles in size, and, in states from Idaho and Nevada to Georgia and Florida. For a quick overview of our system user interface, check the Modules page at www.compulink-Itd_com , or call 800-879-0517; or, Email us at compulinkltdCc~cs.com for a current evaluation demo. ' We've been in the software industry since 1982 and in the Public Works and Road & Bridge market since 1993. This promotion should enable more cities and counties to run ~'r~~E',al Road & Bridge IMS®and realize operating efficiencies and cost savings provided by our software. Sincerely, ~tir~ Rich Knoch Road & Bride Integrated Management System0 I Es~i~ ` RIB IMS is a 32 bit, network ready, relational information management system designed specifically for City and County Highway, Public Works and Road & Bridge Department operations. Two Financial Accounting Systems (either Lrte or Complete System -depending on your needs) Cost 8~ Project Accounting System for management of all operations Integrated Work Order Modules (2) plus separate (integrated) Shop Work Order Module ~ Perpetual (multi-location) Inventory System for materials management and control Fleet Management (P.M. System) for all equipment (alt departments) '~ Simplified Road Management (SRM©) System -Instant road/street condition report Scan and manage your documents with our TWAIN compliant scanner module Integrated GIS with your city/county dataSet (optional); data compatible with ArcView©and other GIS ~ Over 300 reports; State Specific Reports; optional I'f ~ ~tNtt Report Writer for unlimited reports ~ QBE (Query by Example); 100% flexible search and reporting; SearchPrint utility ~ Instant Fuel Efficiency Graphic Analysis of your entire Equipment Fleet '~ Context sensitive HELP, On-Line manuals, 1-800 support ~ 32 Bit, network ready, runs under Windows© 95!98/NT/2000,XP OS/2, AS/400 and Linux (Samba) WEB Page generator to summarize all road spending over selected period for publishing First year support, training and upgrades included in purchase price ~ GASB34 Capital Assets Management module (Depreciation andlor Modified Approach) ~ Payroll Benefit tracking -regular, overtime, sick leave; holiday, personal & vacation time ~ Work Force Planning -graphically designed to show personnel needs ~- Contract Trucking -tracks weight loads, quarry tickets for outside trucking companies. ~- Animal Control -writes notifications to offenders and fines • Solid Waste module -manage and control all solid waste ops (from customer to landfill/recycle) • Flood Plain Management and Waste Water Management modules r On-line software updates keep you up-to-date with enhancements, new modules and technology Our unique system design enables you to run each module independently. Starting each module, when you're ready, means you don't need to change your operating procedures. With all systems operational you'll have control over every phase of departmental operations; from road/street complaints, planning, forecasting and budget authorization, through material purchases and inventory control, to whom, what, when and where material, labor, equipment and contract costs are applied. r ~ gaN n x«~ grcw.u ova a~.n,q 1Ykdow 4s w~+ ydp ~ .. xc iv . op ~ • - ~-~ ~~ ~~ ~ @~et Rdect> ~ I:Wa '. n ' SmmrY ® C'~~NB R~ --~ (_ _. _ i_J 1=-J Osortl . Manegemem Corr C'e mais F F ~ F~, I ~Y A n MMn` IC'K f Mr e'hx1 M'AE'lsl6~ ,_ - _ . _ 1 ~ r f s -r ~ ~NIM ~ - -_ , F hp f trE 1 M - - :.~ - 9.bre f-__-1 _ _. k-tc T _ ~ rA~ I{` F.:- ..n 0. e':; open WN? ___- _.__.__~ C - ~ __ - - _.- fi1hF' 'ef- ~ , O { tom. ' - - _ '.:t Irnrn ' ~~7.,_ - . -I :h~~~ 'f^ FM.'MH I v n,..`.i -:'F:?~` _„per :~s.12t-- ~• 3s_...N:.'~aic. iaMiw. Dec:nne ~.2W6 3. S5Pnt WI-~AT Q ~JI~ ~IS~R.S' ~-1AVE TO SAY.• "...exceptional service from the very beginning and the potential for total management is vast...." - Deh, Curter C:orznty, ~i~I f (406-232-1970) "No other program that we surveyed could keep up with costs as easily as this one.....keep up with all costs involved in maintaining from 12 road maintenance workers....The Complaints Module can be used to manage your daily all of the county roads, bridges, signs, culverts, etc....It takes about 1 to 2 hours daily to enter job tickets calls from property owners.....There are lots of hidden extras......Budget planning at the end of the year is so simple when you have your budget loaded on the Road & Bridge software....This software makes cost tracking on special projects or FEMA claims easy." - Rrr!~zrrrr, 11~%ite Couret~~, G.~I (706-865-2510) "Compulink has saved me a lot of time and it keeps good records on all job assignments. It saves a lot of paper work on all reports that I have to prepare." - It`"r!li:rrzr - (;u~rhorzru C~zzrzt1,119S (662-624-3024) "Information can be entered very quickly and easily. The reports compile all information are very helpful. The staff has been easy to work with and guides us through any problems that arise." Eli~afret/z- C.~orvley~ C'orrrrtl~, IBS (620-221-5425) "I can enter our daily time sheets in your program in about a third of the time it took with the system we used to use.....It takes me about ten to fifteen minutes to enter one day's information.....paying bills, tracking equipment expenses, etc. is fast and easy. The best thing about the program is the support. If we want something custom made for us, all we have to do is ask, plus they don't make you feel like a dummy when you have questions." - .-lrrztu, .Burlier Cozrrrtl, KS~ (620-886-5087) "Your software is very extensive and covers all aspects of the Road and Bridge programs that is necessary for the Commissioners to keep records for practically all areas that pertain to their business. Your staff is very helpful in all areas, pleasant to work with, is easy to follow uz interpretations of where to go in the software.... It is nice to know that when I call up with a situation, that any and all questions are handled in a professional and timely manner." - Befh, Hopkirz.r C'orrnt~,, 7;~' (903-438-3030) "I was given the assignment to locate and implement a road & bridge tracking system. As we all know there is more to Road & Bridge than maintaining the roads and bridges. We have to track our budget, contracts, equipment, assets, labor and materials. Prior to the Visual IMS software, all this information was tracked in separate databases. When I came across the Visual IMS software, it was unbelievable - an all-in-one- interactive database. We have been using the application since 2000. The customer and technical support is a one-in-a-kind lifetime opportunity. They downloaded all our history from years past and we converted over. We hit the road and have been running ever since. Thanks, Rich and Janet, for making these past five years a breeze. If you ask, Compulink, Ltd. will get it done." - Drane, Derttarz Caurtty, 7X (940-349-3430) "I was scared at first that this would be a big job setting up, but it was SO EASY to do!! And it is now so supple to run reports and get bills out that my job is less stressful and quite organized." - ~wrT,rre, I~eaz~er-heurl Coarrzt}', ,11T (406-683-3781) (Call if you would like other references) iVlodule ~'ricing 'f~t• ~Ofl7 - - C-R - - ,~11 i~lodules fog y~,i'a~l .~nnua3 Subsc~~p~tion Price Reduction ends October 1St, 2007 Our Modular architecture means you only run modules currently needed -bring others on-line as needed Cost Accounting Module* $ 2,000 Document, Analyze and Report on all work performed by your department Fund Accounting Module** 2,000 Document, Analyze and Report on all Actual Spending; Maintain Budget Shop Work Order/Fleet Management Module 1,000 Document, Analyze, Report and Maintain Maintenance History on Equipment Permitting Module 750 Track, Control and Document all Permits issued by your department Geographic Information System (GIS) free Perform Spatial Data Analysis and other Standard GIS operations Bridge Module 750 Document, Analyze and Maintain Control of Bridges (CIS :~r~r-5led) Culvert Module 750 Document, Analyze and Maintain Control of Culverts (~f.S ~4',~zr+h!erl) Sign Module 750 Document, Analyze and Maintain Control of Signs (Gd,S tilau 3/ert) Other Assets 750 Document, Analyze and Maintain Control of all other Assets Complaints Module 750 Document, Analyze and Control all Complaints and Service Requests Contracts Management Module 750 Document, Analyze and Maintain Control of Contracts to others Weed Control Module 750 Document and Report Spraying and Weed Control Ops (GdS ,°ratr5!ed) Pavement Management 750 Visual Pavement Management Benefits Module ~ 2,750 Document, Report and Track Benefit Hours Earned and Used Work Force Planning 750 Monitor & project working operations Scanning and Document Management Module 750 Scan and file documents -let your computer manage them (TWAIN compliant) Contract Trucking Module 750 Track the weight loads and associated costs Animal Control Module 750 Track (from animal pickup through adoption and transfer), manage and control costs Solid Waste Module 750 Track, manage and control costs of solid waste (from consumer to landfill/recycle) Accident ReporCing Module `c 750 Documents and report vehicle accidents (persons, vehicles and causal factors) Flood Plain &Module (download -plug-in in FEMA Flood maps) 750 Documents, manage, report on, control and forecast needs in these areas * Sub-Modules included with Cost Accounting Module Equipment Inventory Inventory Transfers Personnel, Vendors Projects Area Maintenance Analyrsis Work Orders Recurring W.O. Road/Streets Profiles GAS634 Utilities Maintenance Analysis ** Sub-Modules included with Fund Accounting Module Budget Funds Receipts Purchase Orders Receivers Accounts Payable Invoices Accounts Receivable Vendors/Contractors