File #: 17-3871   
Type: Ordinance-S Status: Adopted
Meeting Body: City Council Formal Meeting
On agenda: 10/18/2017 Final action: 10/18/2017
Title: Institute Program Products Master License Agreement (JMP-Pro License) (Ordinance S-43972)
District: Citywide

Title

Institute Program Products Master License Agreement (JMP-Pro License) (Ordinance S-43972)

 

Description

Request to authorize the City Manager, or his designee, to add additional funds for Contract 51385 with SAS Institute, Inc., in the amount of $195,000.  Further request authorization for the City Controller to disburse all funds related to this item.

 

Report

Summary

The Water Services Department (WSD) uses JMP-Pro License, a statistical software program, to manipulate large data sets. With monthly billing records for over 400,000 customers and associated data, such as property assessment records that require organization and analysis, WSD needs efficient and cost-effective statistical software. This request is for additional licenses, allowing staff to use the advanced toolset to work efficiently and reduce response time for information requests related to emergency situations and customer concerns. Additional benefits include improved projections for the City's Water and Wastewater Master Plans, Water Resource Plans, Capital Improvement Plans, and Infrastructure Improvement Plans for impact fees.

 

Procurement Information

In accordance with Administrative Regulation 3.10, normal competition was waived as the result of a Determination Memo citing that there is only one source for the necessary goods and services. During this determination period, Information Technology will follow a step-methodology / alternative solutions analysis to obtain information on future technologies that could provide innovative and improved processes.

 

Financial Impact

With the $195,000 in additional funds, the contract's revised value is now $620,000 (including applicable taxes). Estimated annual expenditures in support of these additional funds are $39,000.  Funds are available in the Water Services Department operating budget.

 

Concurrence/Previous Council Action

This contract was awarded by Formal Council Action on Oct. 17, 1991, with an original value of $17,000 per year.

 

Department

Responsible Department

This item is submitted by Deputy City Manager Karen Peters and the Water Services Department.