HomeMy WebLinkAboutResolutions - 2006.04.27 - 28057MISCELLANEOUS RESOLUTION #06082 April 27, 2006
BY: FINANCE COMMITTEE, CHUCK MOSS, CHAIRPERSON
IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - CONTINUATION OF INTEGRATED E-
FINANCIAL SYSTEM AND OUTLOOKSOFT IMPLEMENTATION PROJECT
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
WHEREAS on March 14, 2002, the Board of Commissioners adopted M.R.
#02043 authorizing acquisition of PeopleSoft Licenses thereby enabling
commencement of the Integrated E-Financial System Project, components of
which include e-procurement, enhanced time and labor reporting, project
costing, an Internet portal for on-line payment, activity based management,
full financial management and reporting; and
WHEREAS in recognition of the State of Michigan's budgetary challenges,
regional economic concerns, and their unknown effect on future Oakland County
budgets, execution of the Integrated E-Financial System Project had been
split into three Phases, each of which provided critical functionality to
governmental operations and value to County taxpayers, and yielded a six -year
estimated payback period as a result of projected cost avoidances; and
WHEREAS Phase III included the implementation of performance management
and data warehousing modules that are highly beneficial to effective and
efficient management and would enhance best business practices; and
WHEREAS Phase III was originally estimated to cost $3,946,623 and for
which a designation of $4,000,000 was included in the adopted Fiscal Year
2006 and 2007 Budget and Genera: Appropriations Act by the Board of
Commissioners in MR# 05223; and
WHEREAS it was decided after Phase II Go Live to place Phase III of the
Integrated E-Financial System Project implementation on -hold due to budget
uncertainties; and
WHEREAS the Phase II implementation of the PeopleSoft Budgeting module
that was scheduled to Go Live in the spring of 2006 was also placed on -hold
while the implementation team re-evaluated the most cost-effective way to
implement budgeting, performance management and data warehousing
functionality; and
WHEREAS it was decided to competitively bid for the acquisition and
implementation of a budgeting, performance management, and data warehousing
system that would closely integrate with PeopleSoft; and
WHEREAS OutlookSoft was subsequently selected as the finalist; and
WHEREAS OutlookSoft has been implemented at numerous other entities in
lieu of the PeopleSoft budgeting, performance management, and data
warehousing modules, thereby allowing Fisca= Services to keep on -hold Phase
III of the Integrated E-Financial System implementation project; and
WHEREAS OutlookSoft is designed to provide critical and timely
information for decision making and identifying opportunities to better
manage taxpayer funds; and
WHEREAS the implementation of Phase II came in under budget and the
remaining monies in the Major Departmental Support Projects Fund have been
used since Go Live to address numerous implementation issues, work towards
improving system use efficiencies, continue to provide supplementary training
to end-users, etc.; and
WHEREAS the remaining monies in the Major Departmental Support Projects
Fund have also been used to license ten OutlookSoft seats, allowing
Management & Budget to implement a replacement for the former in-house
customized budgeting system; and
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote.
WHEREAS Management & Budget would like to rollout the new budgeting
system to all departments and begin implementation work on performance
management and data warehousing capabilities; and
WHEREAS a site-license providing unlimited seats for $205,000,
including the first year's support, is available from OutlookSoft that would
provide all departments with access to budgeting data and performance
management tools; and
WHEREAS the eVerge Group, who was competitively selected in 2004, has
successfully assisted the County with Phases I and II of the Integrated E-
Financial System Project implementation and is still under contract with the
County, and is assisting with the implementation of OutlookSoft; and
WHEREAS the additional assistance required from eVerge to further
address Phase II implementation issues, training, and efficiencies, and assist
with performance management and data warehousing efforts, will not exceed
$248,000; and
WHEREAS the internal workload and job duty shifting required to
accomplish the above will likely require the assistance of up to seven PTNEs
for up to nine months at a not-to-exceed cost of $157,500; and
WHEREAS assistance from the Information Technology Department and
additional servers to support the rollout will cost up to $75,000; and
WHEREAS a 20% project contingency amounting to $137,100 is both
customary and will help ensure that the project is completed on schedule and
within budget; and
WHEREAS $281,000 of the Integrated E-Financial System Project budget
unspent from Phase II is available to help offset the $822,600 estimated
total cost for the above;
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of
Commissioners authorizes an appropriation of $541,600 (13% of the original
designation) from the Designated Fund Balance for Phase III of the E-
Financial System implementation to fund the above.
BE IT FURTHER RESOLVED that the appropriation be transferred to the
capital projects fund titled "Major Departmental Support Projects Fund"
(project # 100000000751).
BE IT FURTHER RESOLVED that the FY 2006 Budget be amended, as specified
below:
GENERAL FUND # 10100
Revenue
9010101 196030 665882 Planned Use of Fund Balance $541,600
Expenditures
9010101 989999 788001 42000 Transfer to Maj. Dept. Supt. $541,600
0
Chairperson, on behalf of the Finance Committee, I move adoption of the
foregoing resolution.
FINANCE COMMITTEE
0/41-6-A
Rutt-'1180ionf, County Clerk
Resolution #06082 April 27, 2006
Moved by Moss supported by Long the resolutions (with fiscal notes attached) on the Consent Agenda be
adopted (with accompanying reports being accepted).
AYES: Coleman, Coulter, Crawford, Douglas, Gershenson, Gregory, Hatchett, Jamian, KowaII,
Long, Melton, Middleton, Molnar, Moss, Nash, Palmer, Patterson, Potter, Rogers, Scott, Suarez,
Wilson, Woodward, Zack, Bullard. (25)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the Consent
Agenda were adopted (with accompanying reports being accepted).
••••••
I BY APPROVE THE FORM RESOURION
s-/)
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Ruth Johnson, 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 April 27, 2006, 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 27th day of April, 2006.