Legislation Details

File #: HIST-4428    Version: 1 Subject:
Type: Historical Status: Action Item
In control: City Council Meeting Agenda
On agenda: 2/26/2007 Final action: 2/26/2007
Title: 1) Appropriation of funds in the amount of $20,000; 2) Approval of an Agreement with Progressive Solutions for Pet Licensing Software and Services; 3) Authorization of an Amendment to the City’s Contract with the Los Angeles County Department of Animal Care and Control; and 4) Adoption of a Resolution Establishing a Licensing, Microchipping, and Spay/Neuter Amnesty Program for Dog and Cat Owners.
Attachments: 1. A-1__07-02-26_Animal_Licensing - FINAL.doc, 2. A-1__Animal Licensure.pdf
City of Culver City, California City Council Agenda Item Report RECOMMENDATION: Staff recommends the City Council: 1. Appropriate $20,000 from the General Fund Reserve; 2. Approve an agreement with Progressive Solutions for Pet Licensing Software and Services; 3. Authorize an amendment to the City’s Contract with the Los Angeles County Department of Animal Care and Control (LACDACC); and 4. Adopt a resolution establishing a licensing, microchip, and spay/neuter amnesty opportunity for dog and cat owners who license their pets in accordance with the amnesty requirements during the amnesty period (April 1, 2007 to June 29, 2007); The Budget Amendment requires a 4/5 vote. BACKGROUND: Currently, all Culver City Animal Control services are contracted through LACDACC. In FY 2005-2006, the City of Culver City had a total of 17,130 households with 2,974 Meeting Date: 02/26/07 Item Number: A-1 AGENDA ITEM: 1) Appropriation of funds in the amount of $20,000; 2) Approval of an Agreement with Progressive Solutions for Pet Licensing Software and Services; 3) Authorization of an Amendment to the City’s Contract with the Los Angeles County Department of Animal Care and Control; and 4) Adoption of a Resolution Establishing a Licensing, Microchipping, and Spay/Neuter Amnesty Program for Dog and Cat Owners Contact Person/Dept.: Shelly Wolfberg, Intergovernmental Relations Officer Phone Number: (310) 253-6008 Fiscal Impact: Yes [X] No [] General Fund: Yes [X] No [] Public Hearing: [] Action Item: [X] Attachments: [X] Public Notification: Friends of Culver City Animals; Friends of Culver City Dog Park; Progressive Solutions, Hiderleiter de Llamas (HdL) and Master Notification List (02/21/07). Department Approval: Martin R. Cole (02/21/2007) City Attorney Approval: Carol Schwab (by H. Iker) (02/21/07) City Controller Approval: Marlee Chang (02/21/2007) City Manager Approval: Jerry B. Fulwood (02/21/2007)City of Culver City, California City Council Agenda Item Report licensed dogs. The current license fees are $20.00 for altered dogs and $40.00 for unaltered dogs. Residents 60 years old and older may be exempt and/or eligible for a reduced license fees if they meet specific income criteria. LACDACC amended its Animal Control Ordinance (Title 10) in 2006 to include various provisions. On September 11, 2006, the City Council adopted Title 10 in total. At that City Council meeting, the City Council authorized, beginning July 1, 2007, the mandatory microchipping of dogs; mandatory spay and neutering of dogs; and mandatory cat licensing and microchipping - pending the availability of LACDACC to administer such services. Since the September 11 th Council meeting, staff has contacted LACDACC which has indicated its ability to support the new requirements for Culver City cats. Over the past year, the City Council subcommittee of Mayor Silbiger and Councilmember Corlin has met to discuss animal care and control with City staff, the Friends of Culver City Animals, elected officials and staff from other local cities. The Subcommittee has been assessing current animal care and control services and exploring opportunities for the future of the program. Areas evaluated by the Subcommittee included bringing animal licensing in house and creating a subsequent one year amnesty for the mandatory spay and neutering and microchipping of dogs and cats. DISCUSSION: In-House Animal Licensing Software Staff has received some complaints from the community regarding the timeliness of receiving dog licenses from the County of Los Angeles and the occasional mismatched pet licenses in homes with multiple pets. Subsequently, staff researched options to bring animal licensing in house. Some of the benefits of an in- house program include the ability to more closely and efficiently track the receipt of animal license applications and payments, and the direct transfer of funds into the City’s revenue accounts. Staff met with two providers of animal licensing software- HdL and Progressive Solutions. HdL’s program is currently used to track Culver City business license and property tax information, and Progressive Solutions Ca$hierCentral cash receipting software is used by the City Treasurer’s Office and will be used by Parks, Recreation and Community Services. Progressive Solutions’ Animal Control software program would include a seamless electronic interface via the City’s cash receipting software. HdL’s program would provide the electronic interface, however the service would be custom work and would require an additional charge to be determined on a time and materials basis.City of Culver City, California City Council Agenda Item Report HdL’s fee for the basic program is $13,078 and the annual maintenance fee is $2,495. Progressive Solutions’ fee is $17,600 (including maintenance until June 30, 2007). The annual maintenance fee of $2,600 would be due on July 1, 2007 and would be included in the budget request for Fiscal Year 2007/2008 should the City Council approve purchase of this software. Because Progressive Solutions’ software is already being implemented in processing City receipts, staff is recommending the use of this program for greater efficiency in processing license payments. Animal licensure software is provided by only a limited number of vendors. Additionally, when the compatibility issue is factored into the decision, HdL and Progressive remain the only software packages that meet the City’s requirements. Under the City’s Purchasing Ordinance, because the purchase amount is less than $20,000, formal bidding is not required, With the use of an in house animal licensing system, staff has identified an opportunity to improve the licensing process. Staff believes through the use of an improved system, the number of pet licenses in Culver City will increase while also improving customer service to Culver City residents. Based on Veterinary Market Statistics, the national average number of dogs per dog owning households represents an estimated 7,500 dogs in Culver City. And, there may also be an estimated 6,500 cats in Culver City. In FY 2005-06, under the current contract with LACDACC, 2,860 dogs were licensed resulting in gross revenues of $70,314.50, which included license fees and penalties. Staff believes that an increased amount of revenue will be realized through an in house licensing program and the new requirement of cat licensing. To implement the new software program, Progressive Solutions would import LACDACC’s data into the system. The new in-house license system would be managed by existing staff in the City Manager’s office with payments made through the interfaced software in coordination with the City Treasurer’s Office. Amnesty Process In an effort to increase the number of dogs licensed in Culver City, staff has contacted LACDACC who has agreed to expand its annual rabies vaccination clinic to include dog licensing and free dog microchipping. This clinic will be held on April 21, 2007 from 7:30 a.m. to 3:30 p.m. at the Culver City Armory. The first 500 pet owners desiring a free microchip for their dog must show proof of the dog’s spay or neuter status and show proof of license and vaccination-or obtain one at the event. Further, the County of Los Angeles offers free microchipping clinics throughout the County. These free microchipping clinics represent a step forward to bring Culver City dog owners into compliance.City of Culver City, California City Council Agenda Item Report Yet, staff believes the process to bring pet owners into compliance relative to mandatory microchipping and spay and neutering will be an adjustment for community members. In order to increase the effectiveness of this new ordinance, staff recommends the offering on an amnesty to all dog and cat owners under the following conditions:  Amnesty Period is April 1, 2007 to June 29, 2007  Dog and Cat owners who license their pets during the Amnesty Period will have all prior license fees and penalties waived  To qualify for amnesty licensing, pets must follow all of the requirements of Title 10 and the additional Culver City requirements (including licensing, alteration and microchipping of dogs and licensing and microchipping of cats). Should this proposal be adopted by City Council, staff proposes to send postcards to every household informing them of the amnesty, the requirements to qualify for the amnesty, and the opportunity to come to the City’s microchipping/vaccination event and other events in the County. By purchasing an in-house animal licensing program and providing for the amnesty, staff will have an opportunity to maximize the benefit of an in house licensing program to update pet license data and bring more pet owners into compliance. Further, using the data gathered in-house, staff would be able to provide the City Council with more accurate revenue figures for use by the City Council in considering what, if any, enhancements the Council may deem appropriate. To that end, staff will complete its analysis of the April – June licensure data and provide the City Council with an update at the City Council meeting of July 23, 2007. While the licensing program is brought in-house, the City will still be in need of animal control and sheltering services. The current contract with the County will be amended to delete the licensing requirement effective April 1, 2007. Animal Control and sheltering would continue to be provided through LACDACC. FISCAL ANALYSIS: While staff will present to Council in July a very accurate estimation of annual licensure revenues based upon actual receipts during the amnesty period, it is conservatively estimated that through implementation of the new licensure program, an additional 20% (or 570 dogs) would be licensed. This equates to an increase in annual revenue of $11,400 (570 x $20). Under the new cat licensing requirements, City of Culver City, California City Council Agenda Item Report staff conservatively estimates at least 500 cats would be licensed, generating an additional $10,000 in licensing revenues. The cost of the software from Progressive Solutions is $17,400. Staff recommends the City Council appropriate $20,000 (to allow for the advertisement(s) for the amnesty program and any unexpected contingencies) from the General Fund Reserve and allocate this amount to an operating budget account, The City Controller’s Office will be working with the City Treasurer’s Office to established appropriate accounts for this approved program, including the revenue and appropriation accounts. ATTACHMENTS: 1. Progressive Solutions Proposal for Pet Licensing Software and Services to the City of Culver City. 2. Proposed resolution. MOTION: That the City Council: 1. Appropriate $20,000 from the General Fund reserve to an operating budget account; and, 2. Approve an Agreement with Progressive Solutions for Pet Licensing Software and associated services at a cost of $17,600; and 3. Direct the City Attorney to draft and/or approve the Agreement as to form and authorize the City Manager to execute the Agreement on behalf of the City; Authorize the City Manager to execute an amendment to the City’s Agreement with LACDACC; and, 4. Adopt a resolution establishing a licensing, microchip, and spay/neuter amnesty program for dog and cat owners The budget amendment requires a 4/5ths vote. MEETING DATE: February 26, 2007 AGENDA ITEM: 1) Appropriation of funds in the amount of $20,000; 2) Approval of an Agreement with Progressive Solutions for Pet Licensing Software and Services; 3) Authorization of an Amendment to the City's Contract with the Los Angeles County Department of Animal Care and Control; and 4) Adoption of a Resolution Establishing a Licensing, Microchipping, and Spay/Neuter Amnesty Program for Dog and Cat Owners. ATTACHMENTS 1. Progressive Solutions Proposal for Pet Licensing Software and Services to the City of Culver City Pages 1-14 2. Resolution No. 2007-R A Resolution of the City 15-16 Council of the City of Culver City, California, Implementing an Amnesty Program for Dog and Cat Licensing for the Period of April 1, 2007-June 29, 2007.Progressive Solutions® Proposal For Pet Licensing Software & Services —To The City of Culver City Progressive Solutions® Glenn R. Vodhanel P. 0. Box 783 Brea, California 92822-0783 (714) 671-1597 Progressive Solutions® 1 February 15, 2007TABLE OF CONTENTS A.Licensing, Permitting and other Services 4 B.Scope of Services 7 C. Firm History and Key Personnel 10 D. Compensation 11 E.Relevant Experiences/References 13 F.Options 14- Progressive Solutions® 2 Februaty 15, 2007PROGRESSIVE SOLUTIONS® P 0 Box 783 Brea, California 92822-0783 (714)671-1597 Voice (714)255-9775 Fax February 19, 2007 Mr. Martin R. Cole Assistant City Manager City of Culver City 9770 Culver Boulevard Culver City CA, 90232-0507 Dear Mr. Cole, Thank you for the opportunity to respond to your request for proposal. Please allow me to re-introduce our company and services. The Company. Progressive Solutions® a California corporation, located in the city of Brea, has assisted cities with their data processing needs since 1979. The Company currently has many cities and water districts (Utility Billing) as clients and offers several other software products. Purpose. The Company's mission is to provide the finest software and support available anywhere. We are unique in the marketplace for three reasons: • our commitment to service, • the close attention we pay to our clients needs and the incorporation of client suggestions in software design and enhancements, and • availability, for training and software modifications, of the experts who designed the software. Software The attached estimate includes specifications and feature information for PetTrack—; the premier windows based pet-licensing system. Thank you for considering Progressive Solutions ® for your pet license processing needs. • PetTrack — operates on W[ndow®s and Novell systems using Microsoft% SQL server. • Our internet renewal and payment process is second to none. The software accepts credit card and Autodebit (ACH) transactions. • In most cases our software is flexible enough to adapt to your City's needs without the need for additional programming, and most required customization is included at no extra charge. • We have an extensive audit trail coupled with simple and effective system security. • Our software utilizes the latest technology in a user-friendly format. And with our regular upgrades, it will continue to serve the City's needs for many years to come. • PSI software support is only a phone call away. We provide quick response and knowledgeable support staff available to you from 8:00 AM through 5:00 PM. In the following pages you will find brief descriptions of the system features that Progressive Solutions® has recognized as important in a seamlessly interfaced pet licensing systems. We will be pleased to provide you with any additional information needed in making your vendor selection. Respectfully Submitted, kg1 Glenn R. Vodhanel Progressive Solutions® 3 February 15, 2007 3A. Licensing, Permitting and other Services Our Understanding Culver City citizens and administration wish to improve management of the pet licensing functions by providing services directly to their citizens. Currently the city contracts for these services with the County of Los Angeles. A "window of opportunity" has opened to make this change that created this opportunity to offer superior citizen services. The entire proposition relies on the ability of the neW system to be live and operational before April 1, 2007. Per our proposal, Progressive Solutions® will be pleased to accommodate this time frame. With the "Progressive Solution", the city will benefit from a seamless electronic interface via the city's CahierCentral cash receipting software. This functionality is included at no extra charge. In addition to our superior time saving and accuracy maximizing software, Progressive Solutions® also offers full internet renewal and payment features (as an option), that match the city's desired goals and direction for improved & automated citizen services. —PetTracieL4 98IN-772000 and Windows--°—)CP Pet Track is the premier pet licensing system available on any platform. The system has been designed for reliability and flexibility. Features have been designed as table-driven options to ensure complete flexibility, conforming to the Microsoft ° standard. Pet Track was designed with extensive input from data entry clerks and customer service representatives—the people who use the system with the greatest frequency. Most day-to-day operations may be handled from a single screen for fast and efficient processing. • Pen-rack' uses the Microsoft° SQL Server database engine. Data entry and modifications are controlled through C++ programs that implement extensive data validation. • With a web interface, PetTrace has the ability to accept renewals and applications over the Internet. • Optional invoicing is integrated into the system. • Ad hoc reporting is available as well as the ability to export data into Excel or Quaftro Pro or any other ODBC compliant application. • Accounts may be located by searching any fields whether system or user defined such as customer name, address or account number, etc. D Our system handles multiple charges and late fees. In fact virtually any method of charging you can dream up, PetTracr can accommodate. • Additional information such as home or work phone numbers, associated parties (landlord and tenant information) are easily maintained and retrieved. • An extensive note subsystem allows tracking of specific items through customer records. • The Linked accounts feature allows a parent account to have unlimited associated accounts and the system allows the user to quickly switch between "parent" and "child" accounts. When financial reports are run, linked accounts can be grouped. • The Linked files feature allows the attachment of any kind of file or scanned document to an account. Fire, Police, Planning or any other department can process approvals on-line. • Tight integration with Ca$hierCentral for printing to a receipt/validation printer. • Optional integration with fingerprint recognition hardware for access control. • The system supports data import/export of system data to a laptop. Progressive Solutions@ 4 February 15, 2007One screen is minimum necessary Most commonly needed on-line data may be entered in the Account Maintenance Screen. Cash receipts, customer notes, associated parties and additional information may be added for new customers by selecting the appropriate tab with no screen changes. This makes learning and navigation within the program very simple. Detailed customer data can be recorded and accessed quickly by the intuitively designed interface. Report Customization Pet Track' allows the user complete control over the query generated by a report. All fields can be queried on and then passed to a report with many different sort and display options. The user may select from a choice of predefined report settings or may create and save their own. The user may select the type of report based on a wide variety of data classifications (e.g., reports by pet name, color, age, license expiration, status code, note code, address, etc.). In fact, virtually any field whether system or user defined can be used to build queries and generate reports. There is a complete license register that prints out all certificates generated. —PetTrace =also-allows-the -user-to -preview-the-report-before-it -is -printed. Reportsmay be exported to Microsoft Excel, Microsoft Access, a comma-delimited file and others. Finally, reports may be emailed without leaving PetTrack- software system. Menu & Table Driven PetTracr is both menu and table driven. Processes may be selected from the toolbar or main menu using a mouse or keyboard. Right click menus are supported as well as context sensitive and online helps. Software Documentation The documentation consists of an online context sensitive help file. Documentation updates are generally provided with major software revisions for clients subscribing to annual software support. Additional Fields Additional fields can be added by users or PSI. Fields can be configured and labeled to user preferences. All new fields will then appear on the query menus where they can be searched. "On-line" Data Entry The software allows on-line entry of all new customer data in Pet Account Maintenance. This entry may be performed while the customer service representative is on the telephone with the requesting customer. Free Form Notations Pet Track includes an extensive note subsystem. These notes may be utilized to make any notations needed for customer service information and change tracking. Multiple User Design Pet Track was designed as a multi-user system. Each user is given a security level. The system administrator may elect to allow a user access to certain fields and not to others. Field labels may be changed (even into different languages) depending on the user security level. Access to the systems may also be granted and revoked at any time or on specific dates. Progressive Solutions® 5 February 15, 2007Audit Trail All changes to the database are time/date stamped and the user's name and workstation is recorded. In addition, the user's name and workstation appears at the bottom of all data entry screens. Changes to fields and all letter correspondence can also be automatically archived to notes. Search Capabilities Any field may serve as the basis of an account lookup. In addition, when searching for accounts the user may specify the sort order for the results. Address Validation I he petlidensing syStem pro- V06 — s an inTegrated— dibbase utility for verifying address formats. In addition, an optional database is available on CDROM that provides immediate nationwide address and zip plus four validations. This service provides updates every 2 months. Software Maintenance & Upgrades No charge is made for software assistance provided: (1) a Software Support Agreement is in effect, (2) software assistance is not the result of modifications made by parties other than Progressive Solutions ® and (3) Access to your system is available via the internet to facilitate technical support. Software enhancements that are part of the regular update process are included in the cost of the Software Maintenance Agreement. Charges for custom system enhancements that the City may specifically request are made pursuant to written proposals and are billed at the rate specified in such proposals. 6B. Scope of Services Project Management Team The project manager for the City will be Glenn Vodhanel. Kevin Harker, Software Development Manager for PetTrace, may assist. Steve Le Van may assist with customer interviews to create development of installation/program specifications and Shawn Cobarrubias may serve as a client liaison and provide Crystal Reporte' customization. Additional personnel may be utilized as needed to meet or exceed client objectives. Installation, initial training and on-going support during the implementation period are all provided and included. Primary Objectives • Efficient data entry, maintenance and validation. • Efficient generation of licenses, renewals, delinquents and custom letters. • Ease of obtaining ad hoc management and operational information. Outline of Implementation Plan and Services 1. Discuss how the City is now doing business and what improvements can be made. Current city forms will be reviewed and suggestions made for improvements based upon examples from our current inventory of forms. 2. Review City municipal code and implement tables and rate structures in PetTrack—. This will involve setting up rate structures where applicable for each type of charge that is utilized in the system. 3. Have the City provide us with the current data files so that we can develop a migration matrix to specify where and how data will be migrated. The data files will be provided in a machine readable format and will include a description of the data fields. A test migration and evaluation will be conducted at this time. We will also discuss the fields to be utilized and how they will be configured in the system to best suit the City's needs. 4. Install software at the City with migrated data for evaluation, testing and review. 5. Have City review Custom Renewal, Delinquent, License and Underpayment forms developed by Progressive Solutions ® based upon the City's specifications, 6. Schedule a go live date. 7. Upon receipt of city's final data, migrate data to Pet Track". 8. Provide migrated data and operational training to city staff. 9. Provide additional data tuning. 10. Software maintenance and customer support. Progressive Solutions® 7 February 15, 2007Timeline The number of days required for delivery and installation of the software after execution of the contract and receipt of payment are determined by our receipt of your purchase order. Implementation of our packaged software can be completed in as few as 30 days after contract execution. An implementation schedule detailing the steps and responsibilities of each party will be provided upon execution of the contract. Data migration assumes that the city provides their data to PSI in personal computer readable format, and that the format will not change between the initial migrated test data versus the final live migrated data. Access to the system and data must be made available via Internet using the Symantec's PC Anywhere or other similar application at the time of the live implementation. Go-live before April 1, 2007 requires contract execution by March 1, 2007. Training Training will be provided to end-users, managers and administrators of the software. No special training is required for technical personnel other than a familiarization where the data is stored and where the executable and dll files reside on the server. The training will be conducted in the City's training room if one is available, or at the user's workstations at the choice of the City. All training is hands-on with the most current converted City data. Training or end-user workstations can be set up on the first day of training. Training and documentation for setting up additional workstations will be provided to the City's IS staff. We have allocated 2 days for training. Due to the intuitive nature of the software, most users are comfortable with daily operations within 1 or 2 days. After the initial training, questions may arise that can easily be handled through our courteous and prompt phone support that is included in our maintenance agreement. Additional training can be purchased at our standard daily rate of $1200. Data Conversion Procedure The Migration procedure consists of: 1. Matrix definition (to identify customer fields and determine where fields will be transferred) 2. 2 data conversions (The first conversion is a test to identify any data issues. The second conversion is done immediately prior to the live date.) On the first conversion, the City must provide us with their current data in a suitable format via internet or mail. We will convert the data and verify functionality within Pet Track to identify any data issues as mentioned above. The City's current data will also help us to determine how the fields should best be configured and utilized. The migration procedure does not include any detailed data evaluation or modification unless specified in writing and approved by both parties prior to migration. All customer data must be provided in the same format for each conversion. Any data inconsistency and/or migration rescheduling may result in implementation delay and/or additional charges. Typically, the data addresses will be validated and cleaned up through the address validation software. From our experience, our current system has the capability of storing far more detailed information than the systems that we convert from, so it is anticipated that there will be no significant loss of data during conversion. 8Interfaces Since the system is designed to the ODBC standards, interfaces can be created between other ODBC compliant products. In addition, PetTrack have built in financial export editors that allows the financial export files to be tailored to virtually any format as well as tight integration with our Ca$hierCentral product or existing system. The estimated pricing for interfaces will be included in the quote on a time and materials basis. The interface to your Ca$hierCentral system is included. System Growth and Enhancements Regular enhancements to the system are made based upon customer requests. All customers benefit from any enhancements made to the software. Updates are available from our website ensuring our customers benefit from the latest changes in technology. Optional public lookup inquiry is available through the Internet. Progressive Solutions® can work with the City's web designer in order to configure this service. Other options available include taking payments and applications for pet licenses through the Internet as a means of reducing data entry. Software Support The maintenance fee includes technical support, help with reports, etc. via phone, web and Symantec's PC Anywhere. Also included are periodic software updates downloadable from our website. Our current customers will verify that our customer support is very prompt and that most report customizations and letters are included in the software support fee, making us unique among our competitors. Other Services Progressive Solutions® currently performs a range of information services. All personnel involved in system development have earned computer science degrees from reputable colleges, and/or have proven their ability in past software development projects. Modification of Agreement Progressive Solutions ® will perform strictly to any negotiated agreement. Any modifications to the negotiated agreement must be in writing and signed by the respective authorized representatives. Progressive Solutions@ 9 February 15, 2007 9C. Firm History and Key Personnel Progressive Solutions®, a privately held California corporation, was started by Glenn R. Vodhanel in 1979. The firm began by providing facility management services to municipalities. Additional expansion occurred by marketing developed software and services to other governmental agencies. Glenn R. Vodhanel currently serves as president and Yolande C. Vodhanel serves as both secretary and treasurer. As president, Mr. Vodhanel is authorized to represent the company and to make most required decisions. Progressive Solutions ® is not a party to any pending litigation. From the beginning, the Company has maintained a sound and stable financial condition. It has had and continues to have the ability to meet its obligations as they come due, and has sufficient cash reserves for contingencies. Banking references are available from the Customer Service Department at Wells Fargo, Brea, California. Our Federal Employer ID is 33-0113562 Our corporate offices are located in Brea, California. Our mailing address is: Progressive Solutions ®, PO BOX 783, Brea, CA 92822-0783 Progressive Solutions° maintains both workers compensation and general liability insurance. Should the city desire any coverage in addition to what we maintain, we will be pleased to comply provided the city compensates us for any cost difference resulting from the city's mandate. As a growing company, we work harder to exceed your expectations! Our customers are not just numbers! They are individuals with whom we have accomplished mutual objectives and formed personal relationships. Key Personnel Glenn R. Vodhanel Glenn Vodhanel is the founder of the company and continues to assist customers with consulting and software design services. The firm began providing services in 1979 and in the course of providing facility management to municipalities; PSI grew to employ over 20 employees. Today, PSI's primary focus is on municipal software development and support. In 1981, Mr. Vodhanel earned his BA in business administration with a concentration in accounting. He was first certified with Microsoft during the Lan Manager days and as a result of his efforts Progressive Solutions® has earned the title Microsoft® Certified Solution Provider. Kevin Harker Kevin has been designing and programming software enhancements in Progressive Solutions® software products for over the past 8 years. He has been responsible for keeping our products on the leading edge of technology and making sure that all our customers benefit from any software enhancements. Steve Le Van Steve has worked with Progressive Solutions® for over 7 years providing software training and support services. He is a seasoned professional who works well with people and understands their desires. Matt Hamutoff Matt has worked with information systems for the past 6 years. He has expertise in web page design, form design and database configuration. Shawn Cobarrubias Shawn acts as a client liaison for our customers. In addition, she serves as a valuable member of the migration team by providing her expertise in designing forms using Crystal Reports. 1 0 Progressive Solutions® 10 February 15, 2007D. Compensation Description List PetTrackTm software license (1 concurrent user) $12,800 Conversion of all records provided in an electronic format $2,200 Offsite turnkey database/software setup and configuration $1,200 2 Days Training @ $1,200 per day $2,400 3-Customized Designed Forms (License, Renewal or Delinquent) on generic PSI form paper Included Electronic interface with Culver City's Ca$hierCentral (a $15,000 value) Included $18,600 Current Customer Discount ($1,000) Total Installed Software Cost with discount taken $17,600 Annual Software Maintenance** (1 User) $2,600 Optional: GL Interface to JDE (through Ca$hierCentral) Included Optional: Map Objects Interface with ERSI compliant system $7,500 Optional: Interface for generation of CASS Certification and Postal Statements available $1,080/yr Optional: Interface with an Internet/Web based system for Pet Track payments and renewals $7,500 **Annual maintenance will be prorated to July 1. Reasonable Travel and Lodging will be billed at actual cost if applicable. Setup and License Fee We propose the above initial one-time fee to establish the various charges and finance codes and configuration of the Pet Track licensing system. Also included in this price are custom forms. We are proposing to utilize the Microsoft SQL Server Client-Server Database in the proposal. This does not include the SQL Server software and license from Microsoft ° that from our understanding the City may already have. We propose to utilize the Microsoft ° SQL Server Client-Server Database for maximum performance and enhanced reporting capabilities. Assuming that a SQL Server box is available, it is expected that no additional hardware will be required unless the City decides to utilize a receipt printer and cash drawer with the pet licensing system. If this is desired, the pricing for these 2 items is listed under F. Options. The above fee will include conversion of the city's active license files if the current license data can be provided in a standard PC format. If this is not possible, manual conversion is available on a time and materials basis. Web site payment setup and configuration. We will be pleased to work with your Information Services staff in developing web renewal and payment options for the City's Customers. We can quote a fixed price or provide a time and materials structure. Optional Components PetTrackTm is compatible with a variety of optional components to facilitate ease of use. Optional components are listed in F. Options. Progressive Solutions® 11 February 15, 2007Concurrent User License We have proposed a solution that includes 1 concurrent user license. This proposal allows an unlimited number of staff members to be established. The only limitation is that no more than 1 user may access the system concurrently (at the same time); departmental approval and read only users are unlimited. We have made this proposal in the interest of providing the city with a low cost solution that meets or exceeds the city's needs. Forms Progressive Solutions maintains a supply of blank forms designed specifically for PetTrack"r". Using these forms will ensure printer compatibility. The above custom forms design is quoted using PSI forms. The use of other forms may incur additional cost. If other forms must be used, we recommend that our forms (paper) be used as a template. Zip+4 Validation Progressive So/utionigrincludes automatic Zip+4 Validation for Pea-rad -77 Addresses are automatically parsed and validated as an actual deliverable mailing or business address at the time of data entry. Customization Services PetTrack is a table driven system designed to adapt to the operation of most licensing entities. Should the city desire specific programming modifications to our system, modifications are available on either a fixed price or time and material basis. This proposal is valid for 90 days from the date of the proposal. Most implementations can be completed within 30 to 60 days from receipt of an executed agreement! Annual Maintenance and Customer support Fee The maintenance fee includes technical support via phone, web and Symantec's PC Anywhere. Also included are periodic software updates and fixes downloadable from our website. Progressive Solutions@ 12 February 15, 2007E. Relevant Experiences/References At Progressive Solutions our primary focus has been on providing software and service to municipal government. It is these hands on experience that we bring to your table. We gladly impart the benefits of our experience so that your objectives are met or exceeded. Progressive Solutions Client Contact List Client City of Grand Terrace 22795 Barton Road Grand Terrace, CA 92313 Contact Person: Mari Montes Pop: 12,067 Installed: Oct 2006 Telephone Number: (909)430-2201 Business & Pet Licensing, Code Enforcement, Cashiering and Workflow & Citizen Relationship -management City of Monterey 351 Madison St Monterey, CA 93940 City of National City 1243 National City Blvd. National City, CA 91950 City of Selma 1710 Tucker Street Selma, CA 93662-3728 City of Wichita 455 North Main St, 1st Floor Wichita, KS 67202-1678 Pam Erlandson Pop: 29,701 Installed Feb 2004 Gabby Soriano Pop: 55,541 Approved: Nov 2006 Patricia Neal Pop: 23,000 Installed: Jan 2003 Sean Seamster Pop: 344,000 Installed: April 1999 (831)646-3958 Business Licensing, Pet Licensing and Cashiering (619)336-4378 Business Licensing, Pet Licensing, Cashiering, Building Permits, Code Enforcement & Parcel Assessment (559)896-1064 Business and Pet Licensing (316)352-4848 Business Licensing, Pet Licensing and Cashiering City of Merced 678 West 18th Street Merced, CA 95340 City of Hawthorne 4455 W. 126th Street Hawthorne, CA 90250 Renie Fagundes Pop: 68,225 Approved: Oct 2006 Debbie Culling Pop: 86,680 Installed: Dec 1999 (209)385-6924 Pet Licensing (310)349-2937 Business Licensing, Pet Licensing, Alarm permitting & false alarm billing and Cashiering 13 Progressive Solutions® 13 February 15, 2007F. Options • License Paper 1 box (6000) $510 2 to 3 boxes $408/box 4 to 7/boxes $326.40/box 8 & above $261.12/box • Renewal & Delinquent Paper 1 box (2200) $255 2 to 3 boxes $204/box 4 to 7/boxes $162/box 8 & above $132/box • CASS Certification (Allows validation & discounts) j <5,000 records $1,080/yr • Register Components Star Micronics Receipt Printer/Document Validator $795 Electronic cash drawer $325 • Register add-ons Customer LCD Display $189 Extra cash tray(extra) $47 Cash drawer lid(with lock & key) $36 Thermal receipt paper (50/box) $2.50/roll Compatible Ribbons (6/box)(Minimum order of 1 dozen) $3.50/ribbon • Fingerprint Recognition Fingerprint recognition devices $149 Fingerprint recognition driver alone $50 • Integrated Software Seagate Crystal Reports Professional Upgrade $199 Seagate Crystal Reports Standard Upgrade $79 • Bar code Components Bar Code Scanner (CCD:0"-3") $399 Bar Code Scanner (Laser:0"-12") $799 Bar Code fonts (Also includes Postnet) $225 • Credit Card Components (Select One) Credit Card Connector (each Register) or site license $99 Credit Card Connector (Site License) $999 • Payment Processing Components (Select One) Mag Stripe/Credit Card Reader $159 Check21 Reader $995 \Lk 14 February 15, 2007 Progressive Solutions®RESOLUTION NO. 2007-R A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF CULVER CITY, CALIFORNIA, IMPLEMENTING AN AMENSTY PROGRAM FOR DOG AND CAT LICENSING FOR THE PERIOD OF APRIL 1 2007 TO JUNE 29, 2007. WHEREAS, animal licensure is an important component of ensuring pets are properly cared for; and ,--W-HEREAfuly- ew-reqttiremen-tsttall--be-.comeDeffective-_wltch---____ require all pet owners to license and alter (spay and neuter) their dogs and license their cats (among other requirements); and WHEREAS, the City Council has also expressed its support for the mandatory alteration and microchipping of cats to provide the same benefits of such procedures to our feline companions as those enjoyed by our canine friends; and, WHEREAS, in an attempt to improve licensure rates in the City of Culver City and to provide all Culver City pet owners with an opportunity to comply with the new requirements, the City Council wishes to implement an amnesty program for dog and cat licensing. NOW, THEREFORE, the City Council of the City of Culver City, California, DOES HEREBY RESOLVE as follows: 1. The Dog and Cat Licensing Amnesty Program ("Amnesty Program") is hereby authorized and declared for the period of April 1, 2007 to June 29, 2007 ("Amnesty Period"), under all of the following conditions: a. Pet owners who license their dogs and cats during the Amnesty Period shall have all prior license fees and associated penalties waived. 15|1010101010101010|8 |10 10 10|11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28a A. S Attorney|10 10 10|11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 b. To qualify for the Amnesty Program, pet owners must comply with the provisions of Ordinance 2006-010 which, among other things, requires licensing, proof of alteration, rabies vaccination and microchipping for dogs, as well as licensing of cats. c. Additionally, to qualify for the Amnesty program, pet owners who are licensing their cats must show proof of alteration, microchipping, and other requirements of current law, similar to the requirements for dog licensure contained in Ordinance 2006-010. d. All other provisions of currently applicable law shall remain in full force and effect. 2. The City Manager or his designee is hereby empowered to effectuate this Amnesty Program in accordance with the provisions contained in this Resolution. 3. This Resolution shall take effect immediately upon its adoption. APPROVED and ADOPTED this 26 th day of February, 2007. GARY SILBIGER, MAYOR City of Culver City, California ATTEST: CHRISTOPHER ARMENTA, City Clerk 28|1013|