HomeMy WebLinkAboutResolutions - 2012.08.01 - 20450MISCELLANEOUS RESOLUTION #12190 August 1, 2012
BY: FINANCE COMMITTEE — THOMAS MIDDLETON, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY AND DEPARTMENT OF MANAGEMENT AND
BUDGET / EQUALIZATION DIVISION —UPGRADE OF TAXING AND ASSESSING SOFTWARE TO BS&A .NET
EDITION
TO THE OAKLAND COUNTY BOARD OF COMMISIONERS
Chairperson, Ladies and Gentlemen:
WHEREAS the Department of Information Technology (OCIT) provides a taxation and
assessment software used by the county departments and subscribing local CVTs; and
WHEREAS the current taxation and assessment software, BS&A Pervasive, is nearing end of life
for vendor support and new functionality is no longer being developed in this version of the system;
and
WHEREAS the Oakland County Equalization Division and Department of Information Technology
have evaluated opportunities to reduce the "total cost of ownership" and, at the same time, increase
system functionality provided to system end users; and
WHEREAS a Request for Proposals was released, and the BSA .NET product was determined to
be the solution that best met the County and subscribing local CVT needs, and was the lowest cost
option; and
WHEREAS an upgrade from the existing BS&A Pervasive software to the NET edition would
provide the following benefits to Oakland County and subscribing local CVTs:
• Reduce data sharing compatibility issues between the County's Assessing and Taxation related
systems,
• Improve integration between Assessing, Tax, and Special Assessment applications. This
integration will reduce data entry errors, increased productivity and provide accurate, real-time
information for each municipality.
• Result in an estimated 20% reduction in IT time related to support and maintenance for an aging
system.
• Achieve over 2,000 hours of Equalization department productivity gains annually due to the
upgraded system's improved functionality and stability.
• Allow for conversion to a standardized Microsoft .NET Platform and SQL Server database
platform consistent with County standards.
• Improve reporting capabilities and reduce manual report processing time,
• Integrate GIS capabilities allowing more flexibility in managing property comparables, sales and
ECF analysis results visually on a map.
WHEREAS the costs of the project will be tracked under the Major Departmental Support
Projects Funds as a separate fund and project number; and
WHEREAS the contract with BS&A Software is subject to review and approval from Corporation
Counsel.
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners hereby
approves the appropriation of Major Departmental Support Projects Fund #42060 for the BS&A .NET
implementation and the FY2012 Budget is amended as follows:
General Fund (#10100) FY 2012
Revenue
9010101-196030-665882 Planned Use of Fund Balance $3,046,418
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote with Long and Quarles absent.
Expenditure
9010101-152130-788001-42060 Transfer Out
Total General Fund
BSA Tax Assess Software Upgrade Fund (#42060)
Proj Business Unit MAJOR, Project #100000001641, Activity A
Revenue
9016001-152130-695500-10100 Transfer In from GF
Total Revenue
Expenditures
9016001-152130-731773
9016001-152130-731941
9016001-152130 :731458
9016001-152130-773630
9016001-152130-760132
9016001-152130-730359
$3,046,418
0
$3,046,418
$3,046,418
$ 944,771
6,630
281,229
1,642,335
125,950
45,503
$3,046,418
Software Purchase
Training
Professional Services
IT Development
Computer Equipment
Contingency
Total Expenditures
BE IT FURTHER RESOLVED the cost for the BS&A .NET implementation will be funded by the by
the Major Departmental Support Project Fund 42060 which has a balance of $5,000,000 and as an
exception is being requested to authorize a transfer of $3,046,418.
BE IT FURTHER RESOLVED that the Oakland County Board of Commissioners hereby approves
the implementation of the .NET edition of BS&A Software by the Equalization Department and the
Department of Information Technology, at a cost not to exceed $3,046,418.
Chairperson, on behalf of the Finance Committee, I move for the adoption of the foregoing
resolution.
FINANCE CO1v)M4TTEE
„f1 ,
HEREBY APPFID-VE THIS RESOLUTION
CHIEF DEPUTY COUNTY EXECUTIVE
ACTING PURSUANT TO MCL 45.559A (7)
Resolution #12190 August 1, 2012
Moved by Weipert supported by McGillivray the resolutions (with fiscal notes attached) on the amended
Consent Agenda be adopted (with accompanying reports being accepted).
AYES: Covey, Crawford, Dwyer, Gershenson, Gingell, Gosselin, Hatchett, Hoffman, Jackson,
Long, Matis, McGillivray, Middleton, Nash, Nuccio, Potts, River, Runestad, Scott, Taub, Weipert,
Woodward, Zack, Bosnic. (24)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the amended
Consent Agenda were adopted (with accompanying reports being accepted).
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Bill Bullard Jr., Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true
and accurate copy of a resolution adopted by the Oakland County Board of Commissioners on August 1,
2012, with the original record thereof now remaining in my office.
In Testimony Whereof, I have hereunto set my hand and affixed the seal of the County of Oakland at
Pontiac, Michigan this 1 St day of August, 2012.
Bill Bullard Jr., Oakland County