Memorandum

City of Lawrence

Information Systems Department

TO:	David Corliss, City Manager
FROM:	Ron Hall, Information Systems Director
CC:	Alan Landis, Purchasing Specialist Cynthia Boecker, Assistant City Manager Diane Stoddard, Assistant City Manager Jonathan Douglass, Assistant to the City Manager
DATE:	January 18, 2008
RE:	January 29, 2008 Consent Agenda Item

Please include the following item on the City Commission consent agenda for consideration at the January 29, 2008 meeting:

Approve expenditure to SunGard HTE for 2008 software maintenance.

Program History.  The City of Lawrence uses computer software from SunGard HTE (Lake Mary, FL) for a variety of applications that serve all departments. Financial software used includes Budgeting and Accounting, Purchasing/Inventory, Business Licenses, Asset Management, Cash Receipts, Accounts Receivable, Payroll/Personnel, and Utility Billing. The Planning and Development Services division uses HTE software for Building Permits and Code Enforcement cases. Additionally, specialized HTE egov software is used for online utility billing and building permits as well as an interactive voice response (IVR) interface for providing account information via telephone. SunGard HTE charges an annual software maintenance fee to support software product improvements, software fixes, and general customer support.

Program Funding.  Software maintenance fees are funded annually by the base budgets in the primary user departments. Because of the large number and variety of software applications in use, several accounts are used to fund the maintenance fees. Specifically funding would come from these sources:

Funding Source	Account	Amount
General Fund Code Enforcement	001-1032-532.33-06	1,540.00
General Fund Building Inspection	001-1034-534.33-06	9,310.00
General Fund City Clerk	001-1050-542.40-04	1,380.00
General Fund Fire & Medical	001-2200-562.26-05	4,795.00
General Fund Information Systems	001-1070-557.33-06	19,966.00
Water & Sewer Utility Billing	501-1069-559.26-05	33,876.00
Water & Sewer Administration	501-7100-580.26-05	3,222.00
Residential Sanitation	502-3510-571.26-05	5,370.00
Commercial Sanitation	502-3520-572.26-05	5,370.00
Storm Water Utility	505-3900-579.26-09	1,611.00
TOTAL Charges		$86,440.00

Action Request.  Information Systems Department staff requests approval to fund SunGard HTE 2008 software maintenance in the amount of $86,440.00.