Madison, WI Header
File #: 10910    Version: 1 Name: 6/17/08 - MFD and Police Scheduling System
Type: Resolution Status: Passed
File created: 6/11/2008 In control: BOARD OF ESTIMATES (ended 4/2017)
On agenda: 6/17/2008 Final action: 7/1/2008
Enactment date: 7/2/2008 Enactment #: RES-08-00681
Title: Amending the 2008 Information Technology Capital Budget to eliminate MFD Personnel Scheduling System and to instead fund Police Scheduling System for 2008; thereby eliminating the Police Scheduling System project from the 2009 Capital Budget.
Sponsors: David J. Cieslewicz

Fiscal Note

This resolution eliminates the MFD Personnel Scheduling System project entirely.  This project was funded in the 2008 Capital Budget using a transfer in from the general fund in the amount of $120,000.  Since this project is being cancelled, this amount is being reallocated to two separate projects for 2008.  The first project is the Police Scheduling System, which will receive $35,000 in additional expenditure authority and will be funded using a transfer in from the general fund of $35,000. Additionally, the 2009 CIP anticipated funding of $51,000 for this project is deleted by this resolution. 

 

The second project is the Purchased Software Enhancements project, which will receive $85,000 in funding from a transfer in from the general fund.  This additional funding for this project will be used to lower the $270,000 originally budgeted general obligation borrowing by $85,000.  

 

The following adjustments will be made to the 2008 Capital Budget:

(40,000)   CE34-58015-810594-00-0000000-00000000-00000000

(80,000)   CE34-58510-810594-00-0000000-00000000-00000000

120,000    CE34-79410-810594-00-0000000-00000000-00000000

 

35,000     CE34-58510-810493-00-0000000-00000000-00000000

(35,000)  CE34-79410-810493-00-0000000-00000000-00000000

 

(85,000)  CE34-79410-810345-00-0000000-00000000-00000000

85,000     CE34-79140-810345-00-0000000-00000000-00000000

Title

Amending the 2008 Information Technology Capital Budget to eliminate MFD Personnel Scheduling System and to instead fund Police Scheduling System for 2008; thereby eliminating the Police Scheduling System project from the 2009 Capital Budget.

 

Body

WHEREAS, the 2008 Information Technology Capital Budget Project 10 titled MFD Personnel Scheduling System for $120,000.00 provides for the purchase of a personnel scheduling system for the Madison Fire Department that will interface with the current payroll system; and

 

WHEREAS, the City of Madison Fire Department is satisfied with their current method of scheduling and is not interested in pursuing another option outside of the scope of the City seeking a new comprehensive financial, payroll, and human resources system; and

 

WHEREAS, the 2009 Information Technology Capital Improvement Program includes Project 12 titled Police Scheduling System forecasted at $51,000.00 to add the functions of automated vacation scheduling and shift-changes to The Police Department’s existing automated scheduling system (TeleStaff) in use since 2004; and

 

WHEREAS, the Madison Police Department will perform vacation scheduling and shift-changes for 2009 in November and December of 2008, and this manual process consumes more than 500 hours of staff time annually that could be saved with an automated process; and

 

WHEREAS, the TeleStaff vendor, PDSI, Inc., is offering a discount for the purchase of the modules required for automated vacation and shift-change processing until July 31, 2008 reducing the cost $35,000.00;

 

NOW, THEREFORE, BE IT RESOLVED, that the 2008 Information Technology Capital Budget be amended by removing funding for Project 10 (#810594) titled MFD Personnel Scheduling System for $120,000.00; and

 

BE IT FURTHER RESOLVED, that the 2008 Information Technology Capital Budget be amended by adding funding for Project 12 titled Police Scheduling System in the amount of $35,000.00 to cover the software, installation, and training costs; and

 

BE IT FURTHER RESOLVED, that the 2009 Information Technology Capital Improvement Program Project 12 titled Police Scheduling System in the amount of $51,000.00 be eliminated; and

 

BE IT FURTHER RESOLVED, that the 2008 Information Technology Capital Budget be amended by adjusting funding for Project 8 titled Purchased Software Enhancements by adding $85,000 in funding from a transfer in from the general fund and reducing general obligation borrowing by $85,000; and

 

BE IT FINALLY RESOLVED, that the Comptroller's Office is authorized to make necessary accounting entries to the general ledger to accommodate these changes.