HomeMy WebLinkAboutResolutions - 1999.12.16 - 25677MISCELLANEOUS RESOLUTION #99331 December 16, 1999
BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 1999 YEAR-END REPORT
AND BUDGET AMENDMENTS
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
WHEREAS all accounts have been posted and final adjustments made for Fiscal
Year (FY) 1999; and
WHEREAS Statement #1 of the Governmental Accounting, Auditing and Financial
Reporting Standards requires that encumbrances and appropriations carried-forward
be treated as a reserved fund balance at the year-end and that such amounts be
reappropriated in the subsequent year in order to be available for expenditure;
and
WHEREAS the results of operation after consideration of expenditures,
accruals, encumbrances, appropriations carried forward, transfers, adjustments,
and closing entries produces an excess available resources over total charges as
reflected in the attached schedule; and
WHEREAS a reserve of 81,606,819.79 fcr Genera: Fund/General Purpose
Operations has been created to cover encumbrances and pre-encumbrances obligated
through the end of FY 1999, a reserve of $2,362,385.48 for General Fund/General
Purpose Operations to cover requested carry forward of unspent FY 1999
appropriations, and a reserve for long and short term advances in the amount of
8150,424.68; and
WHEREAS in order to meet future space needs the County is negotiating for
the purchase of the Oakland Schools building; current estimated cost for the
purchase and renovation of this facility equals $22 million, a designated fund
balance of $7,800,000 has been created to partially offset the cost of this
project; and
WHEREAS the OakNet project is the backbone of a number of County wide
technology efforts, which benefit not only County government, but also all the
cities, villages and townships in the County, including law enforcement, 9-1-1,
enhanced access, land records, etc., a designated fund balance of $6,000,000 has
been created to continue this project expansion; and
WHEREAS the information systems for the Administration of Justice and the
Law Enforcement functions needs to be updated to incorporate recent technological
advancements as well as integrated so as to prevent duplication of effort, a
designated fund balance of $5,000,000 has been created to upgrade and integrate
this system; and
WHEREAS pursuant to M.R. #89283 the Board of Commissioners established a
Designated Fund for Operational Improvements, which makes available a source of
funds departments can use to support innovative programs, providing the Board
approves the use of the fund balance and the requesting department commits to a
pay-back within six (6) years of the original allocation, the fund balance of
$3,000,000 is again established; and
WHEREAS a designated fund balance of $2,650,000 has been created to
continue the development of a Geographic Information Management System (GIS)and
related Remonumentation efforts which has county wide and regional benefits; and
WHEREAS changes in the factors used to calculate personal property taxes
for public utilities could have a negative impact on property tax revenue, a
designated fund balance of $2,500,000 has been established to cover potential tax
tribunal claims; and
WHEREAS funds were removed from the FY 1999 Capital Improvement Plan to
assist in balancing the FY 1999 budget and related building fund equity, a
designated fund balance of $2,000,000 has been created to return a portion of the
funds taken from the plan; and
WHEREAS upgrades are necessary to the Human Resources Financial Information
System (HRFIS) to maintain the useful life of the system, these upgrades include
improvements to the time and labor system as well as installation of the most
recent version of the financial software, a designated fund balance of $1,250,000
has been created tc cover the cost of these upgrades; and
FINANCE COMMITTEE VOTE:
Motion carried unanimously on a roll call vete.
WHEREAS the Board of Commissioners authorized implementation of Phases I
and II of the Corrections Services Staffing Study with the FY 2000 budget, a
portion of that budget anticipated the use of a designated fund balance of
$1,200,000 to help offset the cost of the study's full; and
WHEREAS the County is close to reaching agreement with the State of
Michigan to purchase portions of the Clinton Valley Center property, a designated
fund balance of $1,200,000 has been created to accomplish this purpose; and
WHEREAS the County along with the various cities, villages and townships,
has pursued the development of a Fire Records Management system which will assist
in coordinating information between the various public safety and fire safety
entities, enhancing the services provided to our citizens, a designated fund
balance of $800,000 has been created to cover the original capital cost of the
equipment; and
WHEREAS in order to meet the expanding demands of providing service to its
customers, the Department Information Technology is investigating the hiring of
a consultant to review and improve the work processing, a designated fund balance
in the amount of $500,000 has been created to support this effort; and
WHEREAS in order to improve the communication and support between the
Information Technology Department and the various user departments, the creation
of user liaisons is being explored through the Information Technology Leadership
Groups, a designated fund balance of $500,000 has been created to cover the
potential cost of additional staffing and/or consulting effort; and
WHEREAS three communities have opted to purchase 9-1-1 Call Taking
Equipment independent of the County-wide equipment purchased in FY 1998 through
the use of a designated fund balance, the three communities have asked for
reimbursement from the County to cover the purchase cost of their equipment, a
new designated fund balance of $316,000 has been created to cover these
communities' capital cost; and
WHEREAS a $250,000 designated fund balance has been created for the Board
of Commissioners to utilize on special projects; and
WHEREAS a designated fund balance in the amount of $200,000 has been
created for Community Corrections to implement new programs, independent of state
funding, which should lead to a reduced jail population.
NOW THEREFORE BE IT RESOLVED that the report of operations, for Fiscal Year
1999, is accepted and the results of operations by line-item after inclusion of
expenditures, accruals, encumbrances, appropriations carried-forward, transfers,
adjustments, and closing entries is approved.
BE IT FURTHER RESOLVED that various line items in the FY 2000 Budget be
amended to include $1,606,819.79 in General Fund/Genera: Purpose Operations for
outstanding purchase orders and $2,362,385.48 in General Fund/General Purpose
Operations for appropriations carried forward as detailed in the attached
schedules.
BE IT FURTHER RESOLVED adjustments to the fund balance be approved as
follows:
Balance Before Adjustments (result of FY 1999 activity) $ 18,542,238.13
Add to General Fund Balance:
Repayment of Advance for
Lake Charwood 6,493.09
Long Lake 4,000.00
Decrease in Prepaid Expenditures 22,785.33
Well Code Study 150,000.00
Strategic Planning 245,000.00
Sentencing Guidelines Implementation 250,000.00
Office Software Training 2,300,000.00
Subsequent Years Budget 3,066,900.00
Adjusted Total Including Additions $ 24,589,416.55
Deduct from General Fund Balance:
Prior Years Balance
Operating Transfer - IT-Oak/Net
Increase in Petty Cash $ 1,100.00)
E-911 Call Taking 16,000.00)
Treasurer's Cast Register Project 58,665.00)
Community Corrections 66,505.00)
Board of Commissioners Projects ( 250,000.00)
I.T. Standards Project ( 500,000.00)
User Liaison Project ( 500,000.00)
Fire Records Management ( 800,000.00)
Operational Improvements ( 1,571,102.00)
Court System Replacement ( 2,000,000.00)
GS ( 2,470,000.00)
Tax Tribunal Appeals ( 2,500,000.00)
OakNet ( 6,000,000.00)
Oakland Schools Building ( 7,800,000.00)
Adjusted Total including Additions/Subtractions $ 56,044.35
Undesignated Fund Balance At Beginning of Year 571,401.33
Undesignated Fund Balance At the End of Year 627,445.88
BE IT FURTHER RESOLVED that $6,000,000 from the FY 1999 Designated Fund
Balance for OakNet be appropriated, as specified below, to continue purchase and
expansion of the MAN/WAN system:
GENERAL FUND
Revenue
90-190000-14000-1582
Expenditures
90 -310000-40000-8001
INFORMATION TECHNOLOGY FUND
Revenue
18-636113-10000-1701 Operating Transfer In - GF
Expenditure
18-455-001 Information Technology - Balance
56,000,000
$6,000,000
0
$6,000,000
$6,000,000
0
BE IT FURTHER RESOLVED that $2,295,000 from the FY 1999 Designated Fund
Balance for GIS be appropriated, as specified below, in order to continue work
in this vital area:
GENERAL FUND
Revenue
90-190000-14000-1582 Prior Years Balance $ 2,295,000
Expenditures
19-224000-14062-3348 Planning-Professional Services $ 130,000
90-310000-40000-8001 Operating Transfer - IT-GIS 2,165,000
$ 2,295,000
0
INFORMATION TECHNOLOGY FUND
Revenue
18-636113-10000-1701 Operating Transfer In-Gen. Fund $ 2,165,000
Expenses
18-636172-95200-3348 IT - Professional Services $ 2,165,000
BE IT FURTHER RESOLVED that $2,500,000 from the FY 1999 Designated Fund
Balance for Tax Tribunal Appeals be appropriated, as specified below, in order
to cover the cost of potential lost property tax revenue:
Prior Years Balance $ 2,500,000
GENERAL FUND
Revenue
90-190000-14000-1582
ExiDenditures
90-210000-2:000-9099 Tax Tribunal Appeals $ 2,500,000
$ _ 0
BE IT FURTHER RESOLVED that $286,000 from the FY 1999 Designated Fund
Balance for 59-1-1 Call Taking Equipment be appropriated, as specified below, so
that the effected communities may be reimbursed for their expenses:
GENERAL FUND
Revenue
90-190000-14000-1582 Prior Years Balance $ 286,000
Expenditures
90-310000-40000-8001 Operating Trans. - IT-Call Taking $ 286,000
INFORMATION TECHNOLOGY FUND
'Revenue
18-636113-1C000-1701 Operating Transfer In - CF $ 286,000
Expenditure
18-455-001 Information Technology - Balance $ 286,000
0
Chairperson, on behalf of the Finance Committee, I move adoption of the
foregoing resolution.
FINANCE COMMITTEE
C21:1744-"(//
n:\budget\forecast\99yeared.mr
Resolution #99331 December 16, 1999
Moved by Douglas supported by Millard the resolution be adopted.
AYES: Dingeldey, Douglas, Galloway, Gregory, Jensen, Law, McCulloch,
McPherson, Melton, Millard, Moffitt, Obrecht, Palmer, Patterson, Schmid, Sever,
Suarez, Taub, Amos, Appel, Causey-Mitchell, Colasanti, Coleman. (23)
NAYS: Garfield. (I)
A sufficient majority having voted therefor, the resolution was adopted.
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, G. William Caddell, 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 December 16, 1999 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 16,ph day/Of December, 1999.
G. William Caddell, County Clerk
isammosnammwro
PAGE
1
4
23
46
50
COUNTY OF OAKLAND
FY 1999 YEAR END REPORT
TABLE OF CONTENTS
TRANSMITTAL LETTER
SUGGESTED RESOLUTION (including amendments)
SUMMARY OF GENERAL FUND/GENERAL PURPOSE REVENUES 10
AND EXPENDITURES BY DEPARTMENT
SUMMARY STATEMENT OF RECEIPTS AND EXPENDITURES
FY 1999 GENERAL FUND ENDING FUND BALANCE
SUMMARY OF CHANGES IN GENERAL FUND EQUITY
FROM 9/30/98 TO 9/30/99
DETAILED CHANGES IN GENERAL FUND EQUITY DURING FY 1999 17
FY 1999 YEAR END REVENUE EXPLANATIONS 19
Detailed sheets for each Department/Division showing
variances for general fund/general purpose revenue with
explanation of variance.
FY 1999 YEAR END EXPENDITURE EXPLANATIONS
Detailed sheets for each Department/Division showing
variances for general fund/general purpose expenditures,
with explanation of variance.
BUDGET AMENDMENTS
List of Miscellaneous Resolutions authorizing amendments
to the Adopted Budget.
INTERNAL SERVICE FUND REPORTS
Summary of Revenues and Expenses with explanation of
variances from Budget.
REPORT OF SUNDRY REVENUE 59
REPORT OF SUNDRY EXPENDITURES 60
INMATE WAVIER REPORT 61
DONATED EQUIPMENT REPORT 62
GIS INFORMATION 64
12
15
16
L. BROOKS PATTERSON, OAKLAND COUNTY EXECUTIVE
COUNTY MICHIGAN
DEPARTMENT OF MANAGEMENT AND BUDGET Jeffrey C. Pardee, WNW Director
TO: Members of the Finance Commiitee
" et/
FROM: Jeffre.!, C. Pardee7 1=Sytor, Management and Budget
SUBJECT: Letter of Transmittal - Fiscal Year (FY) 1999 Year End Report
DATE: December 3, 1999
FY 1999 ACTIVITY
Attached please find the FY 1999 Year End Report and recommended budget amendments. In
total, the County completed the fiscal year with a 518,542,238.13 favorability in the General
Fund/General Purpose Operations (GF/GP). GF/GP includes all operations except Grants and
Internal Service funds. This overall favorability is split between receiving $6,417,495,29 more
revenue than budgeted (1.58%), and expending $12,124,742.84 less than budgeted (3.76%).
REVENUES
GF/GP revenues came in 1.58% above budget or $6,417,495.29. This favorability reflects a
number of events:
A. GENERAL FUND.- INTERGOVERNMENTAL REVENUE (fav. $2,406,424.45)
This favoarability results from the same areas reported in the third quarter:
increased state payments for Cigarette Tax and the Court Equity Fund, as well as
booking of the indirect cost payment from Community Mental Health for FY
1998 and FY 1999. It is important to note that the FY 2000 revenue budget was
increased to match the increased Cigarette Tax and Court Equity payments. Also,
because CMH is now a separate authority, the County will no longer receive
indirect cost.
B. GENERAL FUND - CHARGES FOR SERVICES (fav. $2,826,111.42)
The primary vehicle for favorability was the high real estate activity as evidenced
in increased revenue for the Register of Deeds for Mortgages and Recording Fees
(approximately $2.4 million). In addition, however, revenue from the State for
diverted felons was $1.4 million higher than anticipated due to active invoicing by
Fiscal Services staff of prisoners who's offenses were committed prior to 1999.
The new sentencing guidelines are not yet effective for offenders currently being
processed by the courts. It was anticipated that this processing would begin in
April 1999, however this delay simply increased County revenues. Finally the
52nd District Court experienced approximately $1.0 million in favorable revenue
due to increased probation activity and bond forfeiture revenue, as did the Friend
of the Court due to aggressive billing under the CRP.
cypri ITIVE OFFICE BUILDING 34 EAST • 1200 N TELEGRAPH RD DEPT 403 • PONTIAC MI 48341-0403 • (248) 858-0487 • FAX (248) 452-2148
C. GENERAL FUND - MISCELLANEOUS REVENUE (fav. $3,465,619.72)
This area experienced favorability due to two factors. First, a number of old
payable accounts were closed out by Fiscal Services, most notably a payable set
up for previous years Tax Tribunal Cases. This one time change resulted in
additional revenue of $1.4 million. In addition, investment income generated $2
million more than expected do to prudent investing by the Treasurer.
D. GENERAL PURPOSE FUNDS - INTERGOVERNMENTAL (fav. $2,202,901.14)
Almost this entire amount reflects the continued 50% reimbursement received
from the state for the Child Care Fund. It should be noted that the FY 2000
budget expects 50% reimbursement.
E. GENERAL PURPOSE FUNDS - CHARGES FOR SERVICES (unfav. $1,777,503.58)
The variance here reflects transfers from other funds which were not required.
F. RESOURCES CARRIED FORWARD (unfav. $2,053,020.26)
Again, this variance reflects the anticipated use of prior years fund balance which
was not required
EXPENDITURES
In total, expenditures fell 3.76% below budget or S12,124,742.84. A majority of the
favorability is related to vacant and underfilled positions (known as turnover). Only two (2)
departments have experienced overall unfavorability:
A. BOARD OF COMMISSIONERS - The unfavorable expenditures reflects an additional
payment of S300,000 to the CMH Authority related to the transfer of equipment and
leased vehicles from the County to the Authority. The payment is a result of the fact that
CMH made lease payments throughout the years for these items, in an amount higher
than the book value. When the equipment and vehicles were transferred to the Authority,
the amount of overpayment was also transferred.
B. INFORMATION TECHNOLOGY - The General Fund portion of Information
Technology shows a negative variance due to additional data warehousing work.
FUND BALANCE
As indicated on the attached sheet, after adding the $18,542,238.13 favoability from FY 1999
activity to the $17,573,837.43 in remaining fund balance, (as well as the $2,370,608.54 in
General Fund encumbrances) the County's General Fund fund balance stood at $38,486,684.10
as of September 30, 1999.
Although $38.5 million is a large figure, the following must be remembered:
I. This figure reflects 12% of the General Fund/General Purpose budget. Industry
standards require that the General Fund balance be between 10% to 20%,
therefore the County is in the lower end of this range.
2. The County spent $17.5 million of last years fund balance on projects not only for
County government, but projects that supported the cities, villages, and townships
as well. The surplus from FY 1999 activity basically covered what was spent
z..
from last year's balance. As will be specified below, a number of needs have
already appeared for FY 2000, which will require the use of the designated fund
balances.
3. Of the FY 1999 surplus, $6.4 million was generated by the receipt of unbudgeted
revenue. However, as was pointed out above, the FY 2000 revenue budget was
increased to account for this additional revenue. Approximately $6.0 million of
the $6.4 million revenue favoarability reflected one-time generated revenue and
those areas were the FY 2000 budget was increased. Therefore, any revenue
favorability in FY 2000 must come from other sources.
4. Of the $12.1 million expenditure favorability, 56% reflects position turnover; e.g.
vacancies and underfills. Taking out turnover, actual operating favorability was
approximately $5.6 million or 1.74%. This means the County spent 98.26% of it
operating allocation.
This General Fund balance is divided into three categories:
1. Reserved Fund Balance ($2,693,238.22) - This amount primarily reflects
commitments made by the County that have yet to be completed. A detailed
breakdown is included on the schedule following the resolution.
2. Designated Fund Balance ($35,166,000.00) - This category reflects amounts
needed to meet upcoming demands and/or projects. Seven (7) of these,
JIMS,OakNet. GIS, Tax Tribunal, E9-1-1 Call Taking, Community Corrections
and Fire Records Management require a transfer with this Finance meeting. Two
resolutions adopted in November also reduced the fund balance. Should these
requests be approved, the Designated Fund balance would be reduced by $15.1
million. Funds can only be spent from the Designated Fund Balances through
specific resolutions approved by the Board of Commissioners.
3. Undesignated Fund Balance ($627,445.88) - This reflects the remaining funds
after accounting for the reserves and designations. As with the designations,
funds can only be spent through specific resolution.
Should you have any questions, please feel free to contact me or our committee staff liaison, Tim
Soave.
MISCELLANEOUS RESOLUTION
BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 1999 YEAR-END REPORT
AND BUDGET AMENDMENTS
TO THE OAKLAND COUNTY 30ARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
WHEREAS all accounts have been posted and final adjustments made for
Fiscal Year (FY) 1999; and
WHEREAS Statement 41 of the Governmental Accounting, Auditing and
Financial Reporting Standards requires that encumbrances and appropriations
carried-forward be treated as a reserved fund balance at the year-end and that
such amounts be reappropriated in the subsequent year in order to be available
for expenditure; and
WHEREAS the resdlts of operation after cansideration of expenditures,
accruals, encumbrances, appropriations carried forward, transfers,
adjustments, and closing entries produces an excess available resources over
total charges as reflected in the attached schedule; and
WHEREAS a reserve of $1,606,819.79 for General Fund/General Purpose
Operations has been created to cover encumbrances and pre-encumbrances
obligated through the end of FY 1999, a reserve of $2,362,385.48 for General
Fund/General Purpose Operations to cover requested carry forward of unspent FY
1999 appropriations, and a reserve for long and short term advances in the
amount of $150,424.68; and
WHEREAS in order to meet future space needs the County is negotiating
for the purchase of the Oakland Schools building; current estimated cost for
the purchase and renovation of this facility equals $22 million, a designated
fund balance of $7,800,000 has been created to partially offset the cost of
this project; and
WHEREAS the OakNet project is the backbone of a number of County wide
technology efforts, which benefit not only County government, but also all the
cities, villages and townships in the County, including law enforcement, 9-1-
1, enhanced access, land records, etc., a designated fund balance of
$6,000,000 has been created to continue this project expansion; and
WHEREAS the information systems for the Administration of Justice and
the Law Enforcement functions needs to be updated to incorporate recent
technological advancements as well as integrated so as to prevent duplication
of effort, a designated fund balance of $5,000,300 has been created to upgrade
and integrate this system; and
WHEREAS pursuant to M.R. #89283 the Board of Commissioners established a
Designated Fund for Operational Improvements, which makes available a source
of funds departments can use to support innovative programs, providing the
Board approves the use of the fund balance and the requesting department
commits to a pay-back within six (6) years of the original allocation, the
fund balance of $3,000,030 is again established; and
WHEREAS a designated fund balance of $2,650,000 has been created to
continue the development of a Geographic Information Management System
(GIS)and related Remonumentation efforts which has county wide and regional
benefits; and
WHEREAS changes in the factors used to calculate personal property taxes
for public utilities could have a negative impact on property tax revenue, a
designated fund balance of $2,500,000 has been established to cover potential
tax tribunal claims; and
WHEREAS funds were removed from the FY 1999 Capital Improvement Plan to
assist in balancing the FY 1999 budget and related building fund equity, a
designated fund balance of $2,000,000 has been created to return a portion of
the funds taken from the plan; and
WHEREAS upgrades are necessary to the Human Resources Financial
information System HRFIS) to maintain the usefol 11fe of the system, these
upgrades include improvements to the time and Labor system as well as
installation of the most recent version of the financial software, a
designated fund balance of $1,250,000 has been created to cover the cost of
these upgrades; and
WHEREAS the Board of Commissioners authorized implementation of Phases I
and I: of the Corrections Services Staffing Study with the FY 2000 budget, a
portion of tnat budget anticipated the use of a designated fund balance of
$1,200,000 to help offset the cost of the study's full; and
WHEREAS the County is close to reaching agreement with the State of
Michigan to purchase portions of the Clinton Valley Center property, a
designated fund balance of $1,200,000 has been created to accomplish this
purpose; and
WHEREAS the County along with the various cities, villages and
townships, has pursued the development of a Fire Records Management system
which will assist in coordinating information between the various public
safety and fire safety entities, enhancing the services provided to our
citizens, a designated fund balance of $800,000 has been created to cover the
original capital cost of the equipment; and
WHEREAS In order to meet the expanding demands of providing service to
its customers, the Department Information Technology is investigating the
hiring of a consultant to review and improve the work processing, a designated
fund balance in the amount of $500,000 has been created to support this
effort; and
WHEREAS in order to improve the communication and support between the
Information Technology Department and the various user departments, the
creation of user liaisons is being explored through the Information Technology
Leadership Groups, a designated fund balance of $500,000 has been created to
cover the potential cost of additional staffing and/or consulting effort; and
WHEREAS three communities have opted to purchase 9-1-1 Call Taking
Equipment independent of the County-wide equipment purchased in FY 1998
through the use of a designated fund balance, the three communities have asked
for reimbursement from the County to cover the purchase cost of their
equipment, a new designated fund balance of $316,000 has been created to cover
these communities' capital cost; and
WHEREAS a $250,000 designated fund balance has been created for the
Board of Commissioners to utilize on special projects; and
WHEREAS a designated fund balance in the amount of $200,000 has been
created for Community Corrections to implement new programs, independent of
state funding, which should lead to a reduced jail population.
NOW THEREFORE BE IT RESOLVED that the report of operations, for Fiscal
Year 1999, is accepted and the results of operations by line-item after
inclusion of expenditures, accruals, encumbrances, appropriations carried-
forward, transfers, adjustments, and closing entries is approved.
BE IT F1;RTHER RESOLVED that various line items in the FY 2000 Budget be
amended to include $1,606,819.79 in General Fund/General Purpose Operations
for outstanding purchase orders and $2,362,385.48 in General Fund/General
Purpose Operations for appropriations carried forward as detailed in the
attached schedules.
BE IT F7RTHER RESOLVED adjustments to the fund balance be approved as
follows:
Balance Before Adjustments (result of FY 1999 activity) $ 18,542,238.13
Add to General Fund Balance:
Repayment of Advance for
Lake Charwood
Long Lake
Decrease in Prepaid Expenditures
Well Code Study
Strategat Planning
Sentencing Guidelines Implementation
Office Software Training
8,493.09
4,000.00
22,785.33
150,000.00
245,000.00
250,000.00
2,300,000.00
Undesignated Fund Balance At Beginning
Undesignated Fund Balance At the End of Year
56,044.55
S 571,401.33
S 627,445.88
Adjusted Total Including Additions/Subtractions $
of Year
Prior Years Balance
Operating Transfer - IT-Oak/Net
Operating Transfer In - GE
Information Technology - Balance
Prior Years Balance
Planning-Professional Services
Operating Transfer - IT-GIS
$6,000,000
S6,000,000
0
S6,000,000
$6,000,000
0
Designated Fund
to continue work
$ 2,297,000
$ 130,000
2,165,000
8 2,295,003
0
2,165,000
2,165,000
••n
Subsequent Years Budget 3,066,900.00
$(
Adjusted Total Including Additions
Deduct from General Fund Balance:
Increase in Petty Cash
E-911 Call Taking
Treasurer's Cash Register Proje
Community Corrections
Board of Commissioners Projects
LT. Standards Project
User Liaison Project
Fire Records Management
Operational Improvements
Court System Replacement
GIS
Tax Tribunal Appeals
OakNet
Oakland Schools Building
$ 24,589,416.55
1,100.00)
16,000.00)
58,665.00)
66,505.00)
250,000.00)
500,000.00)
500,000.00)
800,000.30)
1,5 7 1,102.00)
2,000,000.00)
2,470,000.00)
2,500,000.00)
6,000,000.00)
7 ,800,000.00)
BE IT FURTHER RESOLVED that $6,000,000 from the FY 1999 Designated Fund
Balance for OakNet be appropriated, as specified below, to continue purchase
and expansion of the MAN/WAN system:
GENERAL FUND
Revenue
90-190000-14000-1582
Expenditures
90-310000-40000-8001
INFORMATION TECHNOLOGY E-,JND
Reven u e
18-636113-10000-1701
Expenditure
18-455-001
BE IT FURTHER RESOLVED that $2,295,000 from the FY 1999
Balance for GIS be appropriated, as specified below, in order
in this vital area:
GENERAL FUND
Revenue
90-190000-14000-1582
,xoenditures
19-224000-14062-3348
90-310000-40000-8001 •
INFORMATION TECHNOLOGY FUND
Revenue
18-636113-10000-1701 Operating Transfer In-Gen, Fund
;Sxpenses
18-636172-95200-334E IT - Professitnal Services
BE IT FURTHER RESOLVED that $2,500,000 from the FY 1999 Designated Fund
Balance for Tax Tribunal Appeals be appropriated, as specified below, in order
to cover the cost of pdtehtial lost property tax revenue:
Prior Years Balance $ 2,500,000
GENERAL FUND
Revenue
90-190000-14000-1582
Expenditures
90-210000-21000-9099 Tax Tribunal Appeals $ 2,500,000
0
BE IT FURTHER RESOLVED that $286,000 from the FY 1999 Designated Fund
Balance for E9-1-1 Call Taking Equipment be appropriated, as specified below,
so that the effected communities may be reimbursed for their expenses:
GENERAL FUND
Revenue
90-190000-14000-1582 Prior Years Balance $ 286,000
Expenditures
90-310000-40000-8001 Operating Trans. - IT-Call Taking S 286,000
0
INFORMATION TECHNOLOGY FUND
Revenue
18-636113-10000-1701 Operating Transfer In - GF
Expenditure
18-455-001 information Technology - Balance
$ 286,000
$ 286,000
_ 0
Chairperson, on behalf of the Finance Committee, I move adoption of the
foregoing resolution.
FINANCE COMMITTEE
n:\budget\forecast\99yea :ed.mr
Encumbrances
Fiscal Year ended September 30, 1999
FUND: GENERAL
Department:
11 County Executive S 10,868.05
12 Management and Budget 87,986.47
13 Central Services - 0 -
14 Facilities Management 697.81
15 Personnel 5,673.35
16 Human Services 21.39
17 Public Services 11,947.66
18 Information Technology - 0 -
19 Community & Economic Develop. 114.650.11
21 Cleric/Register of Deeds 26,773.83
22 Treasurer 2,369.94
31 Circuit Court 62,723.80
32 District Court 54,506.66
34 Probate Court 5,148.01
41 Prosecuting Attorney 104,633.32
43 Sheriff 369,724.01
51 Board of Commissioners 73.08
61 Drain Commissioner - 0 -
90 Non-Departmental 234,376.00
GENERAL FUND $ 1,092,173.49
FUND: FRIEND OF THE COURT
Department:
12 Management and Budget
31 Circuit Court
16,128.88
6,284.25
TOTAL FRIEND OF THE COURT 22.413.13
FUND: HEALTH
Department:
14 Facilities Management
16 Human Services
-0-
427,131.89
TOTAL HEALTH FUND 427,131.89
FUND: JUVENILE MAINTENANCE
Department:
16 Human Services 65101.28
TOTAL GF AND GP FUND'S ENCUMBRANCES $ 1,606,819.79
Treasurer
22 221120 01000 3348 Professional Services
Circuit Court
31 101200 10001
31 101200 10001
31 101200 10001
31 101200 10001
31 101200 10001
31 102200 10001
31 105200 10001
31 105200 10001
31 105200 10001
31 105200 10001
64,151.00
2,934.00
85,294.00
2,993.00
15,383.00
15,337.00
7,222.00
17,500.00
1,645.00
202,380.00
1.522.00
352,210.00
3324 Printing
3348 Professional Services
3844 Workshops & Meetings
4100 Expendable Equipment
9169 Capital Outlay
4100 Expendable Equipment
2448 Budgeted Projects
3844 Workshops & Meetings
4100 Expendable Equipment
9169 Capital Outlay
Total
Requested Carryforwards
1999
Fiscal Services - Equalization
12 240000 44100 3348 Professional Services
19 240000 10000 3348 Professional Services
Non-Departmental:
90 210000 21000 9069 Remonumentation
Info Tech. - General Fund
18 101122 95000 3348 Professional Services - G.I.S.
Community Court Services - WAM
17 403200 70211 8001 Opeating Transfer Out
Planning & Economic Development
19 221000 10000 3348 Professional Services
Community & Economic Development
19 210000 10000 3348 Professional Services
19 210000 13500 3348 Professional Services
Clerk/Register of Deeds
21 240100 01000 3348 Professional Services
21 230100 01000 4084 Election Supplies
$29,009.00
21.991.0Q
$51,000.00
172,922.10
54,288.63
50,000.00
90,000.00
15,138.25
25,000.00
70,193.99
17,834.06
9
Sheriff Department
43 023310 20021 9169 Capital Outlay $ 150,000.00
43 023601 20004 9169 Capital Outlay 60,000.00
43 023635 20011 4056 Diving Supplies 6,000.00
43 023910 10001 4044 Deputy Supplies 79.697.02
43 023 1 01 20002 3784 Uniform Replacement 20,000.00
315.697.02
Total General Fund 1.278.435.05
Health Department
16 201200 10000 3196 Miscellaneous 240.224.00
16 261200 75000 3544 Satellite Centers 587,353.47
16 201200 10000 2448 Budgeted Projects 12.455.96
840.033.43
C. R. L M. P.
16 259003 80000 8001 Health - Dental 243,917.00
Total General Fund and General Purpose Funds 1362.385.48
6.24%
1.08%
1.93%
TOTAL GENERAL GOVERNMENT $32,384,161.00 $30,686,311 73 530.442,121 44 $244,190.29 0.80%
$4.659,925.62
13.737,870.28
1.677,884 15
1.794.337,64
3.961.501.43
52,599,281.22
7,142.245.66
7.046,059.94
7.218,601.52
599,837.707 46
5276,703 330 48
$50,444.79
716,361 00
35.121.94
177.209.09
150,374.22
2,508.520.00
447,271.59
(15,322.15)
999.149 95
55.069.130.43 ......
$9.470.724.17
1.07%
4,96%
2.05%
8.99%
3.86%
4.55%
5.89%
-0.22%
12.16%
4 83%
331%
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NON•DEPARTMENTALS $22 616.749 00 $36.696.333.40 534 042.314.73 52.654 018.67 7.23%
$0 II
General Fund/General Purpose
Favcrable,(Unfavorable) ($0) 518,542.238.13 518,542.238.13 z
FY 1999 YEAR END FINANCIAL REPORT
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
FY 1999 BUDGET AMOUNT
ADOPTED AS FY 1999 FAVORABLE/
BUDGET AMEND_ED ACTUAL (UNFAVORABLE) PERCENT
REVENUE
GENERAL FUND
Taxes 5158.040,000.00 5158,040,000.00 $157,388,962.40 ($653.037.60) -0.41%
Intergovernmental 32.287.600 00 33.687,334.00 36.093,758.45 2,408,424.45 3.26%
Charges for Services 64.335,132.00 69,965,885.00 72.791,996.42 2.828.111.42 4.04%
Miscellaneous Revenue 20,351,700.00 20,351,700.00 23.817,319.72 3,465,819.72 17,03%
SUB-TOTAL GENERAL FUND $275,014.432.00 $282,044,919.00 5290,090.036.99 $8,045,117.99 2.39%
GENERAL PURPOSE FUNDS
Intergovernmental 57.340,000.00 59.532.915.50 $11.735,816.54 $2,202,901.14 23.11%
Charges for Services 6.923.620 00 9,180,970 24 7,403,468.66 (1,777,503.58) -19.36%
SUB-TOTAL GP FUNDS 514,253.620 00 518,713.885.74 519.139.283.30 $425,397.56 2.27%
TOTAL GF/GP FUNDS 5289,278,052.00 $300,758,804 74 $309 229,320 29 $8,470,515.55 2.38%
Resources camed forward 54.433,450.00 522.111,563.31 520,058,563 05 ($2,053,020.26) 0.00%
TOTAL GOVERNMENTAL RESOURCES $293,711.502.00 $322,870.388.05 $329,287,883.34 $6,417,495.29 1.58%
TOTAL ADMIN OF JUSTICE 556.152.070.00
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court
52nd District Court
Probate Court
$25.507.557 29
11.129,60443
22,612,641 26
$59,249,602.98
524,078.523 50
10 756.393 48
22,017 063 07
556 851,980.05
$1.429.033.79 5.60%
373,210.95 3.35%
595.578.19 2.63%
52,397.822,93 4.05%
$23 649,573.00
10.667,826.00
21 834.671 00
LAW ENFORCEMENT
Prosecuting Attorney
Sheriff
TOTAL LAW ENFORCEMENT
$14,380.666 00 $15,045.695.91
72.563.097.00 76,285,406.14
586.943,76300 $91,331,102.05
514.107,200.89
75.464.320.64
589,571,521.53
$938,495.02
821,085 50
---------
$1,759,580.52
GENERAL GOVERNMENT
Clerk/Register of Deeds $8.576,971.00 $9.776.973.35
Treasurer 2.905.811.00 3.408.165.00
Board of Commissioners 4 658.639.00 4,912.279.77
CMH Match 9,620.616.00 9,620,616.00
Library Board 2.440.644.00 2,610.308.13
Drain Commissioner 6,622,124 00 2,968,277.61
39,562.092.95 $214,880.40
3,262,436.18 145,728.82
4.863 850 33 48,429.44
9.920,616.00 (300,000.00)
2.607,247.54 3,060.59
2,833,125.98 135,151,63
2.20%
4.28%
0.99%
-3.12%
0.12%
4.55%
COUNTY EXECUTIVE
County Executive Admn. $4.322,634.00 54,710,370 41
Management and Budget 9.212,109.00 14,454,231.28
Central Services 1,655,206.00 1,713,006 09
Facilities Management 2,760.083.00 1,971,546 73
Personnel 3.746,646.00 4,111,875.65
Human Svs 51,377,389.00 55,107,801.22
Public Services 7.019.172.09 7.589,517.25
Informaton Technology 5.006,808.00 7.030.737.79
Community 8 Economic Dev 10.514112.00 8,217.751 47
TOTAL COUNTY EXECUTIVE $95,614,759.00 5104,906.837.89
TOTAL DEPARTMENTS 5271 094 753.00 $286 174.054.65
TOTAL GOVERNMENTAL EXPENDITURES 5293.711.502.00 5322,870.388.05 5310.745.645.21 $12.124,742.84 3.76%
Amended
Budget
09/30/99
Adopted
Budget
10/01/98
Budget
Amendments
$000 $0.00
$0.00 $0.00
$0.00 $000
$000 $0.00
$348,704.80 9,447,291.07
3,195,915 24
9,920,616.00 14,784,393 25
90,040.00 2,833,125.98
$26,773.83 $88,028.05
2,36994 64,151 00
73 08
COUNTY OF OAKLAND
Summary Statement of
Receipts and Expenditures for Governmental Funds
For the fiscal year ended September 30, 1999
Appropriations
Carried
Forward
Revenues
Collections and
Expenditures
before
Adjustments Transfers
Total
Revenue/
Expenditures
and Transfers Encumbrances
Revenue/
Uncollected
Unencumbered
Balance
General Fund
Taxes
Intergovernmental
Charges for Services
Miscellaneous
Sub-Total General Fund
General Purpose Funds
Intergovernmental
Charges for Services
Sub-Total G/P Funds
Total Budged Funds
Resources Carried Forward
Total Governmental Resources
$158,040,000 00
32287,600 00
64,335,132.00
20.351,700.00
7,340,000 00
6,923,620.00
$14,263,620.00
$289,278,052.00
4,433,450 00
$293,711,502.00
1,399,734.00
5,630,753.00
2,192,91550
2,257,350.24
$4,450,265.74
$11,480,752,74
17,678,133.31
$29,158,886,05
$158,040.000 00
33,687,334 00
69,965,885 00
20,351,700 00
$282,044,919.00 $27635252565
11,263,087 64
7,403,466 66
$1871388574 $18,666,554 30
300,758,804 74 $295,019,079.95
22,111,583.31 20,058,563.05
$322,870,388.05 $315,077,643.00
2,277,989.84
11,459,521 50
$1373751134 $29009003699
11,735.816 64
7,403,466 66
$472,729 00 $19,139,283 30
$14,210,240.34 $309,229,320.29
20,058,563.05
$14,210,240.34 $329,287,883.34
($653,037 60)
2,406,424 45
2,826,111.42
3,465,619 72
$8,045.117 99
2,202,901 14
(1,777,503 58)
$425,397.56
$8,470,515 55
(2,053,020 26)
$6,417,495.29
$275.014,432.00 $7,030,487.00
$15738696240
36,093,758.45
70,514,006 58
12,357,798.22
9.532 916 50
9,180,970 24
$157,386,962 40
36,093,758 45
72,791.996 42
23,817,319.72
472,729 00
$23,657,305 45 $69,008 05 $352,210 00 $1,429,033 79
10,701,886 82 54,506 66 373,210 95
22,011,915.06 5.148.01 595.578 19
$0.00 $56,371,107.33 $128,662 72 $352,210.00 $2,397,822.93
$28,000.00
447,870 00
$475,870.00
Expenditures
Administration of Justice
Circuit Court
52nd District Court
Probate Court
Total Administration of Justice
Law Enforcement
Prosecuting Attorney
Sheriff
Total Law Enforcement
$23,649,573.00 $1,857,984.29 $25,507,557 29 $23,657,305.45
10,667,826.00 461,778.43 11,129,604.43 10,701,886.82
21,834,671.00 777,970 26 22,612,64126 22,011,915.06
$56,152,070.00 $3,097,732.98 $59,249,802.98 $56,371,107.33
$14,380,666.00 $665,029.91 $15,045,695.91 $13,974,567.57
72,563,097.00 3,722,309.14 76,285,406.14 74,331,029.61
$86,943,763.00 $4,387,339.05 $91,331,102.05 $88,305,597.18
14,002,567.57 $104,633.32 $938,495.02
74,778,899.61 369,724.01 315,697 02 821,085.50
$88,781,467.18 $474,357.33 6315,697.02 $1,759,580 52
General Government
Clerk/Register of Deeds
Treasuer
Board of Commissioners
Drain Commissioner
Total General Government
$8,576,971.00 $1,200,002.35 $9,776,973 35 $9,098,586 27
2.905,811.00 502,354.00 3,408,165 00 3,195,915.24
14,279,255.00 253,640.77 14,532,895 77 4,863,777,25
6,622,124.00 (3.653,846,39) 2,968.277 61 2.743,085.98
$32,384,161.00 ($1,697,849.27) $30,686,311.73 $19,901,364.74 $ 10,359,360 80 $30,260,725.54 $29,216.85 $152,179.05
$214,880.40
145,728.82
(251,570,56)
135,151.63
$244,190.29
County Executive
Adopted
Budget
10/01/98
Budget
Amendments
Amended
Budget
09/30/99
$10,868 05
104,115 35
697.81
5,673 35
492,254 56
11,947.66
29.009.00
1,083.950.43
50,000.00
54,288.63
152,129 25
$1,369,377 31
$2,189,463.38
22,616,749.00 14,079,584 40 36,696,333.40 15,526,873.25 18,108,143.38 33,635,016 63 172,922 10 2.654,01867 234,376 00
COUNTY OF OAKLAND
Summary Statement of
Receipts and Expenditures for Governmental Funds
For the fiscal year ended September 30, 1999
Appropriations
Carried
Forward
Revenues
Collections and
Expenditures
before
Adjustments Transfers
Total
Revenue/
Expenditures
and Transfers Encumbrances
Revenue/
Uncollected
Unencumbered
Balance
114,650 11
$92,286,092.26 $5,442,031 00 $97,728,123 26 $740,206.89
$1,372,443 79
County Executive Administration
Management and Budget
Central Services
Facilities Management
Personnel
Human Services
Public Services
Information Technology
Community and Economic Dev.
Total County Executive
Total Departments
Non-Departmental Appropriations
Total Non-Departmentals
$432263400 $387.736 41 $4.710.370 41
9,212,109 00 5,242.122 28 14,454,231 28
1,655,20600 57,800 09 1,713,00609
2,760,083 00 (788,536 27) 1,971.546 73
3,746,646 00 365,229 65 4.111,87565
51,377,389 00 3,730,412 22 55,107,801 22
7,019,172 00 570,345 25 7,589,517 25
5,006,80800 2,023,929 79 7,030,737 79
10,514,712 00 (2,296,960 53) 8,217,751 47
$95,614,759.00 $9,292,078 89 $104,906,837.89
$271,094,753.00 $15,079,301.65 $28617405465
$4.649.057 57 4,649.057 57
13.604,74593 13,604,745 93
1,677,884 15 1,677.884 15
1,739,363 83 54.276 00 1,793.639.83
3.955,82808 3,955.828 08
50.550,34723 472.729 00 51.023.076.23
7,080,298 00 7,080,298 00
2.158,43531 4,833,336 00 6,991.771 31
6,870,132 16 81,690.00 6,951.822 16
$256,864,161.51 $16,277,261.80 $273,141,423 31
$50,444 79
716,361 00
35,121 94
177,209.09
150,374 22
2,508,520 00
447,271 59
(15,322 15)
999,149 95
$5,069,130 43
$9,470,724 17
Total Governmental Expenditures $293,711,502.00 $29,158,886.05 $322,870,388.05 $272,391,034.76 $34,385,405.18 $306,776,439.94 $1,606,819 79 $2,362,385.48 $12,124,742.84
1111011,004.
1/4")
$6,417,495 29
12,124,742 84
$18,542,238 13
Adjustments to Undesignated General Fund Balance:
Add to General Fund Balance:
Repayment of Advance for Lake Charnwood
Long Lake
Decrease in prepaid expenditures
Strategic Planning
Well Code Study
Sentencing Guidelines Imp.
Subsequent Years Budget
Office Softwear Training
Adjusted Total Including Additions
Deduct From UndesIgnated Fund Balance
Increase in Petty Cash
Operational Improvements
Community Corrections
GIS
Court System Replacement
Oakland Schools Building
Oak Net
Fire Records Management
User Liason Project
Board of Commissioners Projects
I T Standards Project
Tax Tribunal Appeals
Treasurers Cash Register Project
E-911 Call Taking
Adjusted Total Including Additions and Subractions
Balance at Beginning of Year
COUNTY OF OAKLAND
Summary Statement of
Receipts and Expenditures for Governmental Funds
For the fiscal year ended September 30, 1999
Budget
Amendments
Adopted
Budget
10/01198
Amended
Budget
09130/99
Revenues
Collections and
Expenditures
before
Adjustments
Total
Revenue/
Expenditures
Transfers and Transfers Encumbrances
Appropriations
Carried
Forward
Revenue!
Uncollected
Unencumbered
Balance
GOVERNMENTAL FUNDS
Revenues
Expenditures
Excess Revenues over/under Expenditures
$293,711,502 00 $29,158,886.05 $32287038805 $31507764300 $14,210,240 34 $32928788334 $000 $0.00
293,711,502 00 29,158,886 05 322,870,388 05 272,391,034 76 34,385,405 18 306,776,439 94 1,606,819 79 2.362.385 48
$0.00 $000 $0.00 $42,686,608 24 (520,175.164 84) $22,511,443.40 (51,606,819 79) ($2,362,385 48)
8,49309
4,000.00
22,785.33
245,000 00
150,000 00
250,000 00
3,066,900.00
2,300,000 00
$24,589,416 55
(1,100.00)
(1,571,102.00)
(66,505.00)
(2.470.000.00)
(2,000,000 00)
(7,800,000.00)
(6,000,000.00)
(800,000 00)
(500,000.00)
(250,000.00)
(500,000.00)
(2,500,000.00)
(58,665.00)
(16,000.00)
56,044 55
571,401.33
Undesignated Fund Balance at End of Fiscal Year $627,445.88
FY 1999 GENERAL FUND
ENDING FUND BALANCE
Reserved Fund Balances:
\YN,
D073-0 TOTAL RESERVES
AND DESIGNATIONS
Undesignated
TOTAL FUND BALANCE
537,859,238.22
$627,445.88* 444
$38,486,684.10
Encumbrances/Pre-Encumbrances
Payroll and Petty Cash
Pre-Paids and Long Term Advances
Carry Forwards
Total Reserves
$1,092,173.49
172,205.00
150,424.68
1,27_84435M
$2,693,238.22
Designated Fund Balances:
Oakland Schools Building $7,800,000.00
,OakNet (MAN/WAN) 6,000,000.00
,Court System Replacement 5 s 5 D 5,000,000.00
Operational Improvements L.5 3,000,000.00-r
,--GIS/Remonumentation )3 2,650,000.00
_Tax Tribunal Appeals !/..<0, 2,500,000.00
Capital Improvement Replace. 2,000,000.00
Financial System Ur5,,,,,le -4. VkAP,s r
Sheriffs Corrections Staffing
CVC Property
- Fire Records Management
I.T. Standards Project
User Liaison Project
Call Taking Equip.
Board of Commissioner Projects
— Community Corrections
Total Designations
1,250,000.00 -
1,200,000.00
1,200,000.00
800,000.00
500,000.00
500,000.00
316,000.00
250,000.00
20040_00.0()cp-C-6,/ (424' .)
$35,166,000.00
Prepared by: Fiscal Services
SUMMARY OF CHANGE
IN GENERAL FUND EQUITY FROM
9130/98 TO 9130/99
General Fund Equity (9/30/98) $36,016,970.74
Reductions in General Fund Equity (18,4434133-311)
During FY 1999
Adjusted General Fund Equity $17,573,83743
FY 1999 Activity
Revenue Above Budget $6,417,495.29
Expenditures Below Budget 12;124,742.84
Result of FY 1999 Activity $11L5422313.13
Reserve for Carry Forward Appropriations $2.370.608.54
and Encumbrances
General Fund Equity (9/30/99) $38,486.684.1_0
Prepared by Fiscal Service Division
/
(20,000.00) (100,000.00)
(350,000.00)
(59,326.00)
OAKLAND COUNTY, MICHIGAN
CHANGES IN GENERAL FUND EQUITY DURING FY 1999
Fund
General Fund
Equity
09/30/98
M.R. #98328
Year - End
Report
M.R. #98242
Tax. , Equal.,
Assessing Sys.
M.R. #98313
Clerk/Register
Remonumentation
M.R. #99005
Medical Examiner
Computers
M.R. #99031
Community
Corrections
M.R. #99056
Digital
Photography
M.R. #99057
Equalization
Reorganization
Encumbrances & Carry Forwards
Long Term Advances
Payroll and Petty Cash
Total Reserves
Imaging Loan
Subsequent Years' Budget
Court Replacement System
E-911 Call Taking Equipment
Operational Improvements
Office SoftwarefTraining
Capital Improvement Replacement
Financial System
Sheriff Corrections Staffing
CVC Property
GIS/Remonumentation
Setencing Guidelines Impact
Medical Examiners Computers
Strategic Planning
Community Corrections
Well Code Implementation
$9,782,669.31
185,703.10
171,105.00
$10,139,477.41
$3,400,000.00
3,066,900.00
3,000,000.00
3,000,000.00
2,844,192.00
2,300,000.00
2,000,000.00
1,250,000.00
1,200,000.00
1,200,000.00
500,000.00
500,000.00
350,000.00
295,000.00
250,000.00
150,000.00
($9,782,669.31)
($9,782,669.31)
(765,000.00) (552,500.00)
(250,000.00)
(97,794 00)
$25,306,092 00
$35,445,569.41
$571,401.33
$36,016,9Z0,74
Total Designations
Total Reserves and Designations
Undesignated Fund Balance
TOTAL GENERAL FUND EQUITY
($1,015,000.00)
($10,797,669,31)
($58,665.00)
($10.856.114.31)
($552,500.00) ($100,000.00) ($350,000.00) ($59,326.00) ($97,794.00) ($20,000.00)
($552,500.00) ($100,000.00) ($350,000.00) ($59,326.00) ($97,794.00) ($20,000.00)
$0.00 $0.00 $0.00 ($57,179.00) $0.00 $0.00
($552,500.00) ($100.000.00) ($350,000.00) ($116,505.00) ($97,794.00) ($20,000.00)
Prepared by: Fiscal Services Division
($3,400,000.00)
(2,700,000.00)
(200,000.00)
($2,700,000.00)
($2,700,000.00)
$0.00
($2,700,000.00)
($3,600,000.00)
($3,600,000.00)
$0.00
($3,600,000.00)
M.R. #99218
Elec. Task Force
Fund
M.R. #99060
1st On Forecast
E911
M.R. #99141
2nd Quarter
Forecast
Total Adjustments
to Equity
During FY 1999
Adjusted General
Fund Equity
FY 1999
(50,000.00)
($50,000.00)
($50,000.00)
$0.00
($50,000.00)
Encumbrances & Carry Forwards
Long Term Advances
Payroll and Petty Cash
Total Reserves
Imaging Loan
Subsequent Years Budget
Court Replacement System
E-911 Call Taking Equipment
Operational Improvements
Office SoftwarefTraining
Capital Improvement Replacement
Financial System
Sheriff Corrections Staffing
CVC Property
GIS/Remonumentation
Setencing Guidelines Impact
Medical Examiners Computers
Strategic Planning
Community Corrections
Well Code Implementation
Total Designations
Total Reserves and Designations
Undesignated Fund Balance
TOTAL GENERAL FUND EQUITY
($9,782,669 31)
0,00
0.00
($9,782,669.31)
(3,400,000.00)
0.00
0.00
(2,700,000 00)
(1,415,294.00)
0.00
0.00
0.00
0.00
0.00
(320,000.00)
(250,000.00)
(350,000.00)
(50,000.00)
(59,326.00)
0.00
($8,544,620.00)
($18,327,289.31)
($115,844.00)
($18,443,133.31)
($0.00)
185,703.10
171,105.00
$356,808.10
$0.00
3,066,900.00
3,000,000.00
300,000.00
1,428,898.00
2,300,000.00
2,000,000.00
1,250,000.00
1,200,000.00
1,200,000.00
180,000.00
250,000.00
0 00
245,000.00
190,674.00
150,000.00
$16,761,472.00
$17,118,280.10
$455,557.33
$17,573,837.43
REVENUE
PROPERTY TAXES
1998 Tax Levy
NET CURRENT PROPERTY TAX
COUNTY OF OAKLAND
FY 1999 YEAR END REPORT
RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL
SPECIAL REVENUE AND PROPRIETARY FUNDS
FOR YEAR ENDING SEPTEMBER 30, 1999
BUDGET BUDGET AMOUNT
AS AS FY 1999 FAVORABLE/
ADOPTED ADJUSTED ACTUAL (UNFAVORABLE) PERCENT
$157,345,000.00 3157.345,000 00 $15690316813 ($441 831 87) -028%
$157,345,000.00 8157,345,000 00 $15690316813 ($441,831 87) -028%
OTHER TAXES
Other Taxes $695,000.00 $695,000 00 $483,794.27 ($211,205 73) -30 39%
695,000.00 695,000.00 483,794.27 (211,205 73) -30 39%
TOTAL PROPERTY AND OTHER TAXES 5158,040,000 00 8158.040.000 00 $157,386,962 40 ($653,037 60) 0 41%
BUDGETED RECEIPTS OTHER THAN TAXES
GENERAL FUND STATE AND FEDERAL
Outside Agencies
TOTAL BUDGETED RECEIPTS
GENERAL FUND STATE AND FEDERAL
$32,287,600.00 833.687.334 00 336,093,758 45 $2,406,424.45 714% increased Cigarette Tax and Court Equity Fund fund payments as well as increased
Indirect Cost revenue due to payment born CMH for FY 1998
$32.287,600.00 833,687,334 00 $36,093,758.45 82,406,424.45 7 14%
CHARGES FOR SERVICES
County Executive Administration 331,70000 $31.700 00 $57000 (531,130 00) 98 20% -Reimbursement for Michigan Council for Arts & Cultural .Affairs regranting receipted in FY 2000
Auditing 117,400 00 303,759 00 338,611.33 34,85233 1147% -Additional auditing services requested by Community Mental Health Authority
Corporation Counsel 235.607 00 128,607 00 74,736 54 (53.870 46) -41 89% -Reimbursement less than than anticipated
Fiscal Services 418,000.00 418,000 00 422,372 00 4.37200 1 05%
Reimbursement Division 220,000.00 220,000 00 323,869 87 103.869 87 47 21% -Fax due to receipt of unbudgeted Civil Action Entry Fees , Misc. and Tax Intercept fees
Central Services Administration 0 00 0 00 420 00 420 00 Fay. due to receipt of unbudgeted Per Diem revenue for Parks and Rec. Board attendance
Materials Management 13,000 00 13,000 00 2,117 59 (10.882 41) 0 00% -Most auction revenue credited to supplying departments, less general auction revenue
Support Services 71.800.00 71.800.00 62.695.99 (9,104 01) -12 68% -Contract change for Oakland Room services reduced anticipated revenue
Facilities Mgt - Admin 416,01000 295,19300 367,805 75 72,612.75 24 60% Mid year transfer of Solid Waste dm budgeted revenue in variance to actual revenue booked
Facilities Engineering 16,470.00 16.470 00 0.00 (16.470 00) • 100.00% Revenue inadvertently not transfered from General Fund
Personnel 12,257.00 12,257 00 30,070.55 17.813 55 145 33% -Fax Miscellaneous Revevenue due to unbudgeted funds to pay for Student Intern for Circuit CI
Family Independent Agency 500.00 0.00 000 000 000% .
Medical Examiner 77,800.00 77,800 00 95,571 32 17,771 32 2284% Due to increase in demand for medical services
Public Services ' 11,300.00' 11,300.00 7,139.69 4.16031 3682% Actual charges tor Public Services .Administration costs associated with Empoyment and Training
less than anticipated
MSU Extension- Oakland County 349,934 00 349,934 00 329.233.42 (20,700 58) -5 92% State reimbursement for the Gypsy Moth Suppression Program significantly less than anticipated
due to federal governmental shortfall
12/02/9902:43 PMFIRSTREV.WK4 1 12/02199
COUNTY OF OAKLAND
FY 1999 YEAR END REPORT
RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL
SPECIAL REVENUE AND PROPRIETARY FUNDS
FOR YEAR ENDING SEPTEMBER 30, 1999
BUDGET BUDGET AMOUNT
AS AS FY 1999 FAVORABLE!
ADOPTED ADJUSTED ACTUAL (UNFAVORABLE) PERCENT
— —--
REVENUE
Community Court Services 109.694 00 124 669 00 174 802 57 50.133 57 40 21% -Fax due to increased fees from WAM expansion of the Step Forward program and receipt of
unbudgeted Forfeiture of Bonds. Donations and Rebates on Purchases
Development & Planning 631.000 90 751 81700 516 645 80 (235 171 20) -31 28% -Map sales not as high as anticipated
Equalization 1,650.041 00 1.730.081 00 1,864.657 41 134 576 41 7 78% Revenue unfav due to vacant positions related to contract for services
County Clerk 1.774.160 00 2.14624200 2 233.829 53 87 587 53 408% -Fey Certified Copies due to increased activity
Elections 10 400 00 10,400 00 20.827 24 10.427 24 100 26% -Fan Board of Canvasser Service Fees based on election activity
Register of Deeds 8.099,59300 12,027,181 00 14,472 240.98 2.445,05998 20 33% - Fax Mortgages 3459407, Land Transfer Tax $ 1,105,502, Recording Fees $749,530.
Deeds $110,441. and Photostats $58.091 due to high level of real estate activity
Treasurer 4,580,865 00 4,580,865 00 4,603.016 82 22.151 82 0 48% -Fay Tax Statement fees due to high real estate activity
Circuit Court 3.070,55000 3 361,478 00 3,008,743 97 (352,734 03) -10 49% -Fax Defense Alt Refunds $31.095 reflects increased collections Unfav Mediation
Fines ($137,755). and Civil Mediation Payments ($279,550) due to reduced activity which is also
reflected in decreased expenditure Fax Court Costs revenue, $51.650 which is historically
supported and reflects increased activity
Friend of the Court 7.094,500.00 7,094.500.00 8.15615937 1.061,659 37 14 96% - Unfav Miscellaneous ($48,116) due to change in recording fees. Unfav. Federal
Incentive payments ($231 087) reflects reduced rates and caseload Fax CRP Contract
$616,947 is historically supported. Fax Alimony Service Fees, $59.727 reflects
increased activity.
District Court 7.929,09700 8,018.39700 9,086,693 29 1,068,296 29 13 32% - Fax PSUAlcohol assessments $47,000 and Probation Fees, $293,494, due to Increased
probation caseload. Fax Ordinance Fines & Costs $395.400. Bond Forfeiture $120,200.
Late Penally $56,500. and No Proof of Insurance Fee $35,400, reflect increased activity
State Law Costs untav ($25,000) due to fewer tickets being issued on state laws
Probate Court 1,160,800 00 1153.200 00 1.165.20576 1200576 1 04%
Prosecutor 177.622 00 205,622 00 187.686 46 (17,935 54) -8 72% -Unfav Victim Witness $35,000 underestimated
Sheriffs Office 10 800 00 205,500 00 281,994 21 .76,494 21 3722% -Fax SS Inc Payments $7.600, Sub Fees $9,700, Auction $13.500 and NET Refunds 531.200
Administrative Services 1,50000 1,500 00 2,105.94 605 94 40 40%
Corrective Services 3,298,700 00 3,438.043 00 4,886.270.24 1.445,22724 42 12% -Fax Inmate Board and Care $164,500, Diverted Felons $1,087,500, OUIL III $237200, and
Reimb Cl Svcs $32,100 underestimated
Corrective Services - Satellites 1,375,27500 1,375.725 00 1,470.442.65 94.717 65 658% -Fax. Board and Care $94,700 underestimated
Patrol Services 16230672 00 17.457.45900 17,558,589 41 101,130 41 058% -Fax Reimb Salaries $333,500 (inlay. Sheriff Spec Deputies $225,200.
Technical Services 256,600 00 256,600 00 400.545 75 143,945 75 56 10% -Fax NET salaries $142,500 due to reirnb for both F V 98 and FY 99
Board of Commissioners 20.59600 10,500 00 8.210.00 (2.290 00) .21.81% -Per Diems less than anticipated
Library Board 184,482 00 178.214 00 157.346 67 (20.867 33) -11.71% -Unfav Computer Research Fees ($4,500) and Copy Machine Charges ($9.000) due to
increased utilization of CD Rom products A budget amendment is recommended.
Sundry 000 3.000.000 00 000 (3,000.000 00) 000% Transfer made to Non. Departmental
Drain Administration 501.78400 408,322 00 23.290.00 (385,032 00) 9430% Untav due to reduced sal, cap invoiced to other funds. & grant rev not drawn, offset by fax exp
Operations & Maintenance 770.45600 000 000 000 0(10%
12/02/9902:43 PM F IR ST R EV. WK4 2 12/02/99
Children's Village
Animal Control
Friend of the Court
Probate Court
Non-Departmental
RESOURCES CARRIED FORWARD
Prior Years Balance $4,433,450 00 $22,111,583 31 $20,058,563 05 ($2,053,020 26) -928% Planned transfer from General Fund equity not required
COUNTY OF OAKLAND
FY 1999 YEAR END REPORT
RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL
SPECIAL REVENUE AND PROPRIETARY FUNDS
FOR YEAR ENDING SEPTEMBER 30, 1999
BUDGET BUDGET AMOUNT
AS AS FY 1999 FAVORABLE/
ADOPTED ADJUSTED ACTUAL (UNFAVORABLE) PERCENT
-----
(22.271 70)
52.826,11142
52,202,901 14
52.2132,901 14
REVENUE
3,404,263 00 479.750 00 457,478 30
TOTAL CHARGES FOR SERVICES $64,335.132 CO 569,965.88500 572,791,996 42
GENERAL FUND
BUDGETED RECEIPTS - GENERAL PURPOSE
GOVT STATE AND FEDERAL
Outside Agencies
TOTAL BUDGETED RECEIPTS -GEN. PURPOSE 57,340.000 00 $953291550 511,735,616 64
GOV'T STATE AND FEDERAL
-4 64% Unfav, due to reduced reimb for mileage cap invoiced to other funds, 8 reduced Plat Svc Fees
404%
23 11% Recognition of 50% Child Care Fund reimbursement already received and requested.
as well as increased focal Public Health funds (old Health Cost Sharing)
23 11%
Engineering 8 Construction
57,340,00000 $9,532,915 50 511,735,816 64
CHARGES FOR SERVICES
Emergency Management Services 2,210.00 2,21000 1,768.61 ($441 39) -19 97%
Health Division 2,173.910 00 2,128,75300 2,286,581 33 157.828 33 741% Fay primarily reflects high volume of vaccinations and immunizations administered
2,680,500.00 2,680,500 00 2,844,713 70 164,213 70 6 13% -Fay reflects receipt and adjustment of prior years revenue.
819.80000 819,800 00 794,116.12 (25,683 88) -3 13% Sale of licenses and service fees slightly less than anticipated
437,200.00 437.20000 377,457 82 (59,742 18) -13 66% -State Incentive unfav ($34,000) due to formula change and reduced caseload Unfav i OC
Filing Fees ($10,000) reflects reduced activity and is historically supported
810.000 00 1,030,000 00 1,098,629 08 68,829 08 668% -Fay Board and Care. $52,127 and Gov't Board and Care. $16,701 reflect increased
activity and collection efforts
2.082,507 000 (2,082,507 24) -10000%
56,923,620 00 59.180,97024 $7,403,466.66 ($1,777,503 58) -19 36%
MISCELLANEOUS REVENUE
Sundry $1,050,000 00 51,050.000 00 52,449,949 30 51,399,949 30 133 33% Closing of Reserve for Tax Tribunial expenses into the General Fund.
Investment Income 19.301,700.00 19.301,70000 $21,367,370.42 2,065,670 42 1070% Increased investments.
$20,351,700 00 520,351,700 00 523.817,31972 53,465,619 72 I ? 03%
811111.00,
12/02/9902:43 PMFIRSTREV.WK4 3 12/02/99
($52,321.766 00) (553,061,643 34) ($47,837.197 98) $522404636 .985%
9293,711,502.00 9322,870,388.05 9329,287,883.31 56,417,495.29 1.99%
COUNTY OF OAKLAND
FY 1999 YEAR END REPORT
RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL
SPECIAL REVENUE AND PROPRIETARY FUNDS
FOR YEAR ENDING SEPTEMBER 30, 1999
BUDGET BUDGET AMOUNT
AS AS FY 1999 FAVORABLE/
ADOPTED ADJUSTED ACTUAL (UNFAVORABLE) PERCENT
REVENUE
$443345000 $22,111 583 31 $2005856305 ($2.053 020 26) 000%
OPERATING TRANSFERS
TOTAL AVAILABLE RESOURCES
GENERAL FUND/GENERAL PURPOSE
Less Operating Transfers
NET GFIGP RESOURCES
552,321 766 00 553,061,843 34 $47 837,797 98 (55 224 045 361 -989%
5346,033,268 00 $375,932,231 39 9377,125 681 32 51.193 449 93 032%
12/02/9902:43 PMFIRSTREV.WK4 4 12/02/99
Administration
Controllable Personnel
Controllable Operating
$617640300 $6,273,498 00 $6,272,463 17
- 6,551,488.00 7,056,153.31 6,105,588 52
$136,966 38
1,067,812.20
224255 21
$1,429,033.79 5.60%
1.06%
13.97%
0.00%
COUNTY OF OAKLAND
FY 1999 YEAR END REPORT
EXPENDITURES
CIRCUIT COURT
AMOUNT
ADOPTED AMENDED FY 1999 FAVORABLE
BUDGET BUDGET ACTUAL (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$103483 002%
950,564 79 1347% - Fay attorney fees-mediator $221,371 due to reduced activity Fay transcripts, $63,318
reflect reduced demand Fay Psychological Testing $27,544, Juror Fees and Mileage
$63,165 and Juror Cost District Court Remand $23,323 due to reduced demand. Publishing
Court Calendar $19,940 lower than expected Cost. Defense Attorney Fees fay. $569,244.
Visiting judges unfav. ($79,842) due to increased use.
Non-Controllable Operating 2,290,374.00 2,728,835.82 2,724,905 47 3,930.35 0.14%
$15018265 00 $16,058,487.13 $15,102,957.16
$6,598,798 00 $6,658,758 00 $6,522,826 45
584,513.00 585,083.54 467,836.13
Non-Controllable Operating 1,447,997 00 2,205,228.62
$8,631,308 00 $9,449,070.16 $8,975,566 34
$95552997 595%
2.04% - Turnover
20.04% - Fay indirect costs, $58,583 reflects salary fay. Fay. professional services, $35,021 due
to changes in billing practices. Postage fay. $24.,006 reflects reduced demand
9.99% Information Technology Imaging fay. $177,255 due to reduced billing; Print Shop fay. $4,475
due to reduced usage Leased Vehicles fay. $7,442 and Telephone Communications $10,141
due to reduced billings.
$47350382 501%
Friend of the Court
Controllable Personnel
Controllable Operating
$135,931 55
117,247 41
1,984,903.76 220,324.86
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$12,775,201.00 $12,932,256.00 $12,795,289.62
7,136,001.00 7,641,236 85 6,573,424.65
3,738,371.00 4,934,064.44 4,709,809 23
$23 649 573 00 $25,507,557 29 $24,078,523 50
604
12/02/99
$2.535,418.00
908,816.89
$2.520,468 00
878,62000
$944,516 00
313,236.98
$936,463 00
292.796 00
174,377.00 250,924.87
$912,381 34
328,006.64
$32.134.66
(14,769 66)
213,699 86 37,225 01
Division 2 - Clarkston
Controllable Personnel
Controllable Operating
Non-Controllable Operating
3.40% Salary and fringe fav. $29,751.06 due to turnover Overtime fay $2,383 60.
-4.72% Attorney Fees unfav. (3,701.75) due to new schedule. Juror Fees fay. $4.610.40 due to
decrease in need. Bank Charges ($4,893.50) due to rate increase. Properly Taxes unfav
($15,476 05).
14 84% Info, Tech Operations fay. $25,585 53 quarterly adjustment overestimated actual
Division 4 - Troy
Controllable Personnel
Controllable Operating
Non-Controllable Operating
COUNTY OF OAKLAND
FY 1999 YEAR END REPORT
EXPENDITURES
DISTRICT COURT
AMOUNT
ADOPTED AMENDED FY 1999 FAVORABLE
BUDGET BUDGET ACTUAL (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
District Court Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$110,881.00 $11088100 $2811640 $82,764.60
50,545 00 50,545.00 23,020.32 27,524.68
0.00 0.00 000 0.00
------ --------------------- — — —
$l61,42600 $161,426.00 $51,136,72 $11028928
74.64% Fav due to reduced demand on part tome staff.
54.46% Fav court reporters $9,167.00, and visiting judges $17,617.68, due to reduced demand.
68.32%
Division 1 - Novi
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$2,440,119.70
891,852.44
401,637 00 502,908 27 462,777 79
$3,800,725.00 $3,947,143.16 $3,794,749.93
$95,298 30 3,76% Salary and fringe fav $84,749 86 due to turnover. Overtime unfav. ($10,548 44)
16,964 45 1.87% Bank Charges unfav ($11.645 16) reflects rate increase Training, Psych. & Med Exam
unfav. ($6,126 15) due to increase use which is offset by revenue. Attorney Fees unfav.
($8,078) due to increased demand. Postage fay $10,049.83 Juror Fees fay. $4,813.60 and
Rent fay $21,334 00 which are historically supported
40,130,48 7.98% • Info Tech. Operations fay $39,767.81 quarterly adjustment overestimated actual.
$152,393.23 3.86%
Division 3 - Rochester Hills
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$1,403,636.00 $1,508,677.85 $1,454,087.84 $54,590,01
$2,164,863.00 $2,206,421.00 $2,140,956. 69 $65,464.31 2.97% Fav. due to turnover.
631,164.00 651,164.00 720,259.58 (69,095.58) -10.61% Unfav. Bank Charges ($10,497.60) reflects rate increase. Fay Custodial Services $19,869.00
due to billing change Attorney Fees unfav ($20,8913) due to fee scheduling change and
greater than expected need. Office Supplies unfav. $1183203 partially offset by Stationery
Stores fay $9,679.27 due to purchase from outside sources. Training, Psych. & Med. Exam
unfav of which ($45,255) is due to unreleased encumbrance and ($6,729.00) due to increased
use and is offset by revenue.
373,809.00 437,736.35 350,534,44 87,201.91 19.92% Info. Tech. Operations fay. $65,074.16 quarterly adjustment overestimated actual. Telephone
Communications fay $8,226.27 due to reduced billing.
$3,169,836.00 $3,295,321.35 $3,211,750.71 $83,570.64 2.54%
$1,558,902.00 $1,568,650 00 $1,544,954.19 $23,695.81 1.51% Fav, due to turnover.
307,753.00 307,812.20 334,086 36 (26,274.16) -8.54% Unfav. Bank Charges ($11,308.52) reflects rate increase. Unfav. Rent ($16,902.74). Fay.
Professional Services $7,496.59. Unfav Training, Psych. & Med. Exam ($11,870.00) which
is offset by revenue Office Supplies fay. $5,337 31 due to decreased use.
265,548.00 340,573.87 365,627.73 (25,053.86) -7.36% Info.Tech. Operations unfav. ($37,963.60)quarterly adjustment underestimated actual.
_ — ----------------- Fair. Stationery Stores $7,910.87 due to decreased use and Telephone Communications
$2,132,203.00 $2,217,036.07 $2,244,668 28 ($27,632.21) -1 25% fay. $6,973.41 due to reduced billing.
$7.291,577 00 $7,365,886 00 $7,066,528 32 $299,357.68
2,160,878 00 2,231,575.07 2,297,225 34 (65,650.27)
1,215,371.00 1,532,143.36 1,392,639 82 139,503.54
$10,667,826.00 $11,129,604.43 $10,756,393.48 $373,210 95 3.35%
3.62%
4.06%
-2.94%
9.11%
12101/99
Judicial/Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Juvenile Maintenance
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Court Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
COUNTY OF OAKLAND
FY 1999 YEAR END REPORT
EXPENDITURES
PROBATE COURT
AMOUNT
ADOPTED AMENDED FY 1999 FAVORABLE
BUDGET BUDGET ACTUAL (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Judicial Support
Controllable Personnel
Controllable Operating
Non-controllable Operating
$2,339,401 00 $2,354,077.00 $2,354,265 95 wee 95) -0 01%
66,118.00 65,066.76 97,380.62 (29,313.86) -43.07% - Fair. Visiting Judges unfav. 520.318 due to increased demand and Office Supplies unfav.
($7,645) which is offset by Stationery Stores fay.
552,331.00 851,760.94 922,451.45 (70.690.51) -8 30% - Info. Tech. - Operations unfav. ($74.910).
$2,957,850.00 $3,273,904.70 $3,374,098.02 ($100,193 32) -3.06%
$0.00 $0.00 $0.00 $0.00 000%
4,095,973.00 4,495,973.00 4,374,296,41 121,676.59 2.71% - Fav. Foster Boarding Homes, $11,890, and Pre-Adoptive Care, $13.078 are historically
supported. Fav Sanctuary, $29,520 and State Institutions $60,427 both due to amount of
33 00 33 00 139 60 (10660) 000% placements
$4,096,006.00 $4,496,006.00 $4,374,436.01 $121,569 99 2.70%
$4,563,908.00 $4,570,918.00 $4,337,387.50 $233,530 50 5 11% - Salary and Fringe fay. $238,925 due to turnover: Overtime unfav. ($5,395)
1,754,951.00 1.591,148.71 1,479,553.34 111,595.37 7.01% - Fay. Defense Attorney Fees $219,236.31, unfav. Fees Guardian Ad Litem ($168,231), unfav.
Defense Attorney Fees PPO ($27.695) due to levels of demand. Fav. Medical Services
$31,151 is historically supported. Court Reporter Services lay. 9,390, Court Transcripts fay.
95,600, Expert Witness Fees fay. $7,211 all due to level of activity. Expendable Equipment
fav. 13,552.
799,704.00 1,007,117.53 994,667.08 12,450.45 1.24% Stationary stores fay. $11,500 due to expenditure adjustment.
$7.118,563.00 $716918424 $6,811,607.92 $357,576 32 4.99%
$692064200 $6.920,642 00 86,678,003.84 $242,638.16 351% - Turnover
341,819.00 342,182.70 372,210.25 (30,027.55) -878% - Professional Services Juvenile Maintenance Fund unfav, ($101,044) which is partially offset by
Professional Services General Fund $52,658.
399,791.00 410,721.62 406,707.03 4,01459 0.98% - Various Internal Service law
$7,662,252.00 $7,673,546.32 $7,456,921 12 $216,625.20 282%
$13,823,951.00 513,845.637.00 $13.369,657 29 $475,979.71 3.44%
6,258.861.00 6,497,371.17 6.323.440.62 173,930 55 268%
1,751,859.00 2,269,633 09 2,323,965.16 (54,332.07) -2.39%
$21,834,671.00 $22,612,641.26 922,017,063.07 $595,578.19 2.63%
===
cs3
12/01/99
COUNTY OF OAKLAND
FY 1999 YEAR END REPORT
EXPENDITURES
PROSECUTING ATTORNEY
AMOUNT
ADOPTED AMENDED FY 1999 FAVORABLE
BUDGET BUDGET ACTUAL (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel $1 771,646 00 $1.781,219.00 $1,718,780 34 $62.438.66 3.51% Fav due to underlined positions.
Controllable Operating 1,633,190.00 1,754,001.18 1,558,939 09 $195,062 09 11.12% Fav, Witness Fees $ 26,215, Filing Fees, $14,830. Grant Match $48,383, Professional
Services $18,165 Grant Match $48.383, and various other operating due mainly to
changes in office operations:
Non-Controllable Operating 1,792,416.00 2,326,694.83 2,305,944 28 $20.750.55 0.89% Fav in Leased Vehicles, $19,137; Radio Communications, $11,612 and Copier,
$6,938, attributed to continuing operational changes and improvements.
$5,197,252 00 $5,861,915.01 $5,583,663.71 $278,251 30 4 75%
Litigation
Controllable Personnel $5,914,551 00 $5,914,551.00 $5,658,635 58 $255,915 42 4 33% Fav due to underfilled positions.
Controllable Operating 56,492 00 56,492.00 25,741 86 $30,750.14 0.00% Personal Mileage fay due to continuing operational changes and improvements.
Non-Controllable Operating 0.00 0.00 0.00 $0 00 0.00%
$5,971,043 00 $5,971,043.00 $5,684,377 44 $286,665 56 4 80%
Warrants
Controllable Personnel $1,722,901 00 $1,722,901.00 $1,558,444 85 $164,456 15 9.55% Fav. due to underlined positions and turnover.
Controllable Operating 2,758.00 3,124.90 3,366.09 ($241 19) 0.00%
Non-Controllable Operating 0.00 0.00 0.00 $0 00 0.00%
$1,725,659.00 $1,726,025.90 $1,561,810.94 $164,214.96 951%
Appellate
Controllable Personnel $1,479,827 00 $1,479.827.00 $1,273,847.33 $205,979 67 1392% Fay due to underfilled positions and turnover.
Controllable Operating 6.88500 6,88500 3,501 47 $3,383 53 0 00% Use of Personal Mileage significantly less than anticipated
Non-Controllable Operating 0 00 0.00 0 00 $0 00 0.00%
$1,486,712.00 $1,486,712 00 $1,277,348 80 $209,363.20 14.08%
Department
Controllable Personnel $10,888,925 00 $10,898,498.00 $10,209,708.10 $688,789.90 6.32%
Controllable Operating 1.699,32500 1,820,503.08 1,591,548.51 228,954 57 12 58%
Non-Controllable Operating 1,792,416.00 2,326,694 83 2,305,944 28 20,750 55 0.89%
$14,380,666.00 $15,045,695.91 $14,107,200.89 $938,495.02 624%
Cs3
12/02/99
($11,827.55) -1.61% -Unfav. salaries ($6,000), fringes ($2,500) and overtime ($3,300) due to turnover
and position transfer.
($90,329.63) -33 06% -Unfav. transition costs ($18,200) & communications ($2,200) not budgeted, expend.
equip. ($6,000) offset in other division, and grant match ($57,700) due to timing.
Fay. professional services $12,000.
$46,476.09 3.45% -Fay. leased veh. $16,900, convenience copier $3,400 and insurance fund $26,200
($55,681.09) -2.37%
$75,874 58 7 28%
($86.692.55) -16.65%
$76,876.63 19.49%
--------- --
$66,058.66 3.37%
$17,316,574.00 $17,564,002.00 $17,479,536.96 $84,465.04 048% -Fay. salaries $611,700 and fringes $152,800 due to turnover offset by unfav.
overtime ($680,000).
5,173,189.00 5,796,946.56 $4,006,469.66 $1,790,476.90 30.89% -Fay. laundry & cleaning $46,600 due to laundry being done by inmates, fay.
hosp. of inmates $764,700 due to fewer hospitalizations, dry goods $99,100,
med. svcs. physicians $35,600 due to cost reduction efforts, culinary sup $13,500,
out-county prisoner housing $766,600 due to decrease use of other facilities offset by
unfav. data processing supplies ($29,900) due to new identification system, medical
med. supplies ($93,000) due to health Dept. invoicing and expend. equip.
7,178,631 00 7,885,413.78 $8,105,477 29 ($220,063.51) -2.79% -Unfav. provisions ($100,000) due to change from privatization, culinary supplies
($13.600) offset in controllable culinary sup., leased vehicles ($35,200) & radio
$29,668,394.00 $31,246,362 34 $29,591,483.91 $1,654,878.43 5.30% communications ($22,200).
($220,291 41)
$46,098.32
-2 25%
26.51%
ADOPTED
BUDGET
AMENDED
BUDGET
COUNTY OF OAKLAND
FY 1999 YEAR END REPORT
EXPENDITURES
SHERIFF DEPARTMENT
AMOUNT
FY 1999 FAVORABLE
ACTUAL (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Sheriffs Office
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Administrative Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Corrective Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
S725,718.00 5733,409.00 $745,236.55
232,586 00 273,217.17 $363,546.80
1,330,039.00 1,347,456.00 $1,300,979 91
$2,288,343.00 $2,354,082.17 $2,409,763.26
¶1,035,021 00 $1,042,301.00 $966,426.42
469,730.00 520,570.86 $607,263.41
394,039.00 394,462.00 $317,585 37
$1,898,790.00 $1,957,333.86 $1,891,275.20
-Fay. salaries, fringes and overtime $75,900 due to staff changes & underfill position
-Unfav. training exp. ($6.700) due to extra training per deputy contract, office
supplies ($103,700) partially offset by fav. stationery stock below, unfav emp.
med. exams ($4,400) due to many new hires, fait uniform clng $11,500 & uniform
replacement $26,900 due to lag time in hiring new deputies and use of used uniforms.
-Unfav. printing ($21,100) partially due to change in command, fav. stationery
stock 386,000 offset by unfav, office supplies above.
Corrective Services-Satellites
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Patrol Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
¶9,772,11600 $9,808,070 00 ¶10,028,361 41
157,308.00 181,442.56 $133,344 24
1,018,164 00 1.018,164.00 $955,125.21 $63,038.79 6.19%
510,947,588 00 $11,007,676.56 $11,116,830.86 ($109,154.30) -0.99%
¶17,447,57000 $18,318,840.00 $18,804,418.06 ($485,578.06)
152,555.00 915,866.56 $896,115.55 $19,151.01
1,776,190.00 1,858,396.00 $2,051,821.69 ($193,425.69)
$19,376,315,00 $21,093,102.56 $21,752,955.30 ($659,852.74)
by unfav overtime ($270,000) and fringes ($5 300)
,700 due to laundry being done by inmates, bedding
expendable equip. $6,000 partially offset by unfav.
and bldg space $41,200 offset in other divisions.
-Unfav. overtime ($400,000) and fringes ($85,500) due to mini-contracts and
no-fill postings.
-Fav misc. capital outlay $253,400 due to delay in video system, towing fees
$10,200, diving supplies $6,300 and marine equip $9,400.
-Unfav. bldg. space ($59,400) offset in other divisions and leased vehicles
($101,600) due to increased usage.
-2.65%
2.09%
-10.41%
-3 13%
-Fay. salaries $55,000 offset
-Fay. laundry & cleaning $30
$14,600, dry goods $18,400,
equip repairs ($20,000).
-Fav. housekeeping $21,500
12/02199
Technical Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$6.824,764 00 $6,886,902 00 $6,937.317 39 ($50,415 39) -0 73% -Fay salaries $74,000 and fringes $40,300 offset by unfav overtime ($164,900)
583,647 00 764,002.90 $74464382 $1935908 2.53% -Fav prof services $21,400, microfilm $16,700. extradition $10,100, equip repair
$3,800, deputy supp $87,200, exp. equip $9,500 offset by unfav, equip. rental
($12,700), and liquor/gambling evidence ($4,500)
975,256 00 975,943.75 $1,020,050 90 ($44,107 15) -4 52% -Fav. stationery stock $5,800, micrographics $10,800, leased vehicles $8,500,
and telephone $11,000 offset in other divisions Uniav radio ($82,800).
$5312176300 $54,353,524.00 $54,961,296 79 ($607,772.79) -1.12%
6,769,015.00 8,452,046.61 6,751,983 48 $1,700,063.13 2011%
-12,672,319 00 13,479,835.53 13,751,040 37 ($271,204.134) -2.01%
$72.563,097.00 $76,285,406.14 $7546432064 $821,085.50 1.08%
$8,383,667 00 $8,626,848.65 $8.702,012.11 ($75,163 46) -0.87%
12/02/99
COUNTY OF OAKLAND
FY 1999 YEAR-END REPORT
EXPENDITURES
CLERK/REGISTER OF DEEDS
ADOPTED AMENDED
BUDGET BUDGET
AMOUNT
FY 1999 FAVORABLE
ACTUAL (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
County Clerk
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Elections
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Register of Deeds
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Jury Commission
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$362,252.00 $365,757.00 $356,542.18 $9,214.82 2.52%
82,655.00 82,777.44 77,035,80 5,741.64 6.94%
106,950.00 143,011.97 149,035.40 (6,023 43) -4.21%
$551,857.00 $591,546.41 $582,613.38 $8,933.03 1.51%
$2,997,422.00 $3,011,596.00 $2,929,554.72 $82,041.28 272%
266,477.00 378,881.07 367,369.55 11,511.52 3.04%
519,248.00 656,563.56 534,669.68 121,893.88 1857%
$3,783,147.00 $4,047,040.63 $3,831,593.95 $215,446.68 5.32%
$379,968.00 $384,125.00 $357,869.84 $26,255.16 6.84%
441,944.00 931,112.08 938,302.24 (7,190.16) -077%
79,368.00 174,324.50 157,718.64 16,605.86 9.53%
$901,280.00 $1,489,561 58 $1,453,890.72 $35,670.86 2.39%
$1,481,233.00 $1,623,243.00 $1,629,139.09 ($5,896.09) -0.36%
859,119.00 810,619,00 875,039.72 (64,420.72) -7.95%
851,238.00 1,083,291 00 1,081,536.12 1,754.88 0.16%
$3,191,590.00 $3,517,153.00 $3,585,714.93 ($68,561.93) -1.95%
$14,454.00 $14,454.00 $16,730.33 ($2,276.33) -15.75%
52,363.00 52,363 00 33,740.13 18,622.87 35.56%
82,280.00 64,854 73 57,809.51 7,045.22 10.86%
$149,097.00 $131,671.73 $108,279.97 $23,391.76 17,77%
$5,235,329.00 $5,399,175.00 $5,289,836.16 $109,338,84 2.03%
1,702,558.00 2,255,752.59 2,291,487.44 (35,734.85) -1.58%
1,639,084 00 2,122,045.76 1,980,769.35 141,276.41 6.66%
$8,576,971.00 $9,776,973.35 $9,562,092.95 $214,880.40 2.20%
-Turnover
-Fav. Postage costs
-Unfav. Equipment Rental and Telephone Communications costs.
-Turnover partially offset by Overtime costs.
-Fav. Court Transcripts cost partially offset by unfav. Office Supplies due to
expanded use of the Staples contract.
-Fay. IT Operations, IT imaging Operations, and IT Imaging Development costs
due to decreased billings; and fay. Stationery Stock due to increased
utilization of Staples contract.
-Turnover
-Unfav. Fees/Per Diem cost for Board of Canvassers due to special elections.
-Fay. IT Operations and Stationery Stock due to increased utilization of
Staples contract.
-Unfav. Overtime costs for increased document recording & mortgage
refinancing activities.
-Unfav. Postage (51,702) due to high volume of real estate document mailings
caused by high level of real estate activity and unfav. Office Supplies (14,319)
due to expanded use of the Staples contract.
-Emergency Salaries appropriation not transferred.
-Favorable Postage cost.
-Fay. Print Shop cost.
12/02/99
COUNTY OF OAKLAND
FY 1999 YEAR-END REPORT
EXPENDITURES
TREASURER
AMOUNT
ADOPTED AMENDED FY 1999 FAVORABLE
BUDGET BUDGET ACTUAL (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
n•n••••n••n•~..••n•n•n••n••~..........7.nnn••n•••••n•••••
Administration
Controllable Personnel $2,274,295.00 $2,258,070.00 $2,185,704 67 $72,365.33 3.20% -Turnover
Controllable Operating 236,573.00 327,007.05 $255,944.63 71,062.42 21.73% -Fay. Township & City Treasurer Bonds due to reimbursement by taxing
jurisdictions $ 29,158; fav. D.P. Supplies costs for checks $ 23,297; and
Non-Controllable Operating 394,943.00 823,087.95 820,786.88 2,301.07 0.28% fav. Expendable Equipment Expense due to delay in implementation of
office remodeling project $12,633.
Division Total $2,905,811.00 $3,408,165.00 $3,262,436 18 $145,728 82 4 28%
Department Total $2,905,811.00 $3,408,165.00 $3,262,436.18 $145,728.82 4.28%
kaos,
12/02/99
ADOPTED
BUDGET
AMENDED
BUDGET
857,153.00
$2,440,644.00
964,179.79
$2,610,308.13
968,590.03 ($4,410.24)
$2,607,247.54 $3,060.59
$14,532,895.77 $14,784,466.33
COUNTY OF OAKLAND
FY 1999 YEAR END REPORT
EXPENDITURES
BOARD OF COMMISSIONERS
AMOUNT
FY 1999 FAVORABLE
ACTUAL (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Library Board
Controllable Personnel
Controllable Operating
$1,510,957.00
415,636 00
9,912,018.00
$11,838,611.00
$780,533.00
802,958.00
$1,510,957.00
473,082.67
9,938,547.97
$11,922,587.64
$794775.00
851,353.34
$1,562,435.28 ($51,478.28)
357,868.95 $115,213.72
10,256,914.56 ($318,366.59)
$12,177,218.79 ($254,631.15)
$779,143.15 $15,631.85
859,514 36 ($8,161.02)
-3.41% Unfav. Salaries and Fringe resulting from union contract
settlement for committe reporters, $6,100
24 35% Fav. Legal Services $29,833, Professional Services $63,344 and
Public Information $45,000.
-3.20% Operating Transfer of $300,000 reflects final reconciliation
between the County and the Community Mental Health Authority
related to the purchase of equpment and leased vehicles. Unfav.
-2.14% Info Tech Operations $18,000,
1.97% Fav. due to vacancy and underfilled positions.
-0.96% Unfav. Office Supplies offset by fay. Stationery Stock.
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$2,291,490.00
1,218,594.00
10,769,171.00
$14,279,255.00
$2,305,732.00
1,324,436.01
10,902,727.76
$2,341,578 43
1,217,383.31
11,225,504 59
($35,846.43)
107,052.70
.(322,776.83)
($251,570.56)
-0.46% Unfav. Info Tech Operations as charges were higher than
anticipated; offset by fav. Stationery Stock.
0.12%
-1.55%
8.08%
-2.96%
-1.73%
12/01/99
COUNTY OF OAKLAND
FY 1999 YEAR END REPORT
EXPENDITURES
DRAIN COMMISSIONER - GENERAL FUND
AMOUNT
ADOPTED AMENDED FY 1999 FAVORABLE
BUDGET BUDGET ACTUAL (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Drain Commissioner
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Division Total
Department Total
$563999300 $189514200 $1,943,195 22 ($48.053 22) -254% LInfav due largely to Administratton fringe benefit budget understated
4/6,011 00 458,222.94 263,214 27 195,008.67 4256% Fey due to consultants (var offset by grant revenue). grant rev and exp moved to FY 2000
566,120 00 614,912 67 626,716.49 (11,803 82) .1.92% Untav due to increased computer svcs . and drain equipment charges
$662212400 $296827761 $2,833,125.98 $135,151.63 455%
$6,622,124.00 $2,968,277.61 $283312598 $135,151 63 4.55%
t#N,I
is`43
Prepared by: Budget Division 12/02/99
ADOPTED
BUDGET
AMENDED FY 1999
BUDGET ACTUAL
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Corporation Counsel
Controllable Personnel
Controllable Operating
Non-Controllable Operating
COUNTY OF OAKLAND
FY 1999 YEAR-END REPORT
EXPENDITURES
COUNTY EXECUTIVE
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Auditing
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$1,319,702.00 $1,326,982.00 $1,320,216.79
193,221.00 290,321.00 250,33/38
337,245.00 397,943.02 403,626.07
$1,850,168.00 $2,015,246.02 $1,974,180.24
$89191400 $1,072,862.00 $1,052,662.01
13,496.00 19,871.00 20,384.31
130,632.00 174,780.09 171,033.10
$1,036,042.00 $1,267,513.09 $1,244,079.42
$1,224,548.00 $1,166,621.00 $1,178,476.19
26,741.00 37,840.60 31,217.36
185,135.00 223,149.70 231,972 41
$1,436,424.00 $1,427,611.30 $1,441,665.96
$3,436,164.00 $3,566,465.00 $3,551,354.99
233,458.00 348,032.60 301,939.05
653,012.00 795,872.81 806,631.58
$4,322,634.00 $4,710,370.41 $4,659,925.62
$6,765.21 0.51%
39,983 62 13.77%
(5,683.05) -1.43%
$41,065.78 2.04%
$20,199.99 1.88%
(513.31) -2.58%
3,746.99 2.14%
$23,433.67 1.85%
($11,855.19) -1 02%
6,623.24 17.50%
(8,822.71) -3.95%
($14,054.66) -0.98%
$15,110.01 0.42%
46,093.55 13.24%
(10,758.77) 0.00%
$50,444.79 1.07%
-Turnover
-Travel & Conference costs for trade mission and costs to administer the
Michigan Council for Arts & Cultural Affairs regranting program were less
than anticipated.
-Increased usage of pool leased vehicles.
-Turnover
-Seminar costs higher than anticipated.
-Fay. Stationery Stock and Convenience Copier costs.
-The salaries budget was amended downward in FY 1999 in anticipation
of delayed hiring of new personnel. Positions, however, were filled
earlier than expected causing the unfav, salaries variance.
-Fay. Reporter & Steno Services reflects reduced demand for transcripts.
-Information Technology Operations costs higher than anticipated_
hoN3
Lj
11/29/99
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Purchasing
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Equalization
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Fiscal Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$3,830,327.00 $3,936,124.01 $3,753,989.56 $182,134.45 4.63%
$7,117,591.00 $10,281,780.00 $9,872,201.55 $409,578.45
527,144 00 1,117,310.90 843,840.71 $273,470.19
1,567,374.00 3,055,140.38 3,021,828 02 $33,312.36
$9,212,109.00 $14,454,231.28 $13,737,870.28 $716,361.00
3.98%
24 48%
1.09%
4.96%
COUNTY OF OAKLAND
FY 1999 YEAR END REPORT
EXPENDITURES
MANAGEMENT AND BUDGET
ADOPTED
BUDGET
AMOUNT
AMENDED FY 1999 FAVORABLE
BUDGET ACTUAL (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$244,731.00 $244,731.00 $248,458.62 ($3,727 62) -152%
7,480.00 7,480.00 9,689.38 (2,189.38) -29 27%
9,086.00 9,086.00 9,500 35 (414.35) -4 56%
$261,297.00 $261 297.00 $267,628.35 ($6,331.35) -2.42%
$641,626.00 $645,131.00 $704,072.53 ($58,941.53) -9.14%
26,295.00 27,316.20 20,763.98 6,552 22 2399%
185,802.00 156,422 46 158,419 06 (1,996 60) -1 28%
$853,723.00 $82886966 $883,255.57 ($54,385 91) -656%
$0.00 $3,131,294.00 $2,884,073.16 $247,220.84 7.90%
0.00 3558,176.00 384,156.71 174,019.29 31 18%
000 $859,484.54 891,096.64 (31,612.10) -3.68%
$0.00 $4,548,954.54 $4,159,326.51 $389,628.03 8 57%
$3,499,347 00 $3,510,672.00 $3,338,043.81 $172,628.19 4 92%
121,556.00 143,147.05 88,417.68 54,729 37 3823%
645,859 00 1,225,167.02 1,247,208.80 (22,041.78) -1.80%
$4,266,762.00 $4,878,986.07 $4,673,670.29 $205,315.78 4.21%
- Positions underbudgeted due to use of prior years' data. Situation corrected in the FY 2000 budget.
- Unfav. Memberships, Dues and Publications and Travel and Conference due to increase in
positions not reflected in proportional increase in budget for these items
- Unfav. Convenience Copier reflects greater usage.
- Positions underbudgeted due to use of prior years' data Situation corrected in the FY 2000 budget.
- Fav. advertising expense as more potential vendors Join the Master Vendor file.
- Unfav. Telephone Comm due to retroactive chg representing 15% increase for PBX
- Fav. due to turnover
- Fay. Professional Services as work related to Personal Property Tax factors is reassigned to FY 00.
- Unfav Information Technology Operations due to expansion of Purchasing component of HRFIS.
- Fav. due to turnover.
- Fav Professional Services as upgrades to HRFIS are reassigned to FY 2000.
- Unfav. Building Space cost as charges are reassigned to proper areas
Reimbursement
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$2,731,887.00 $2,749,952.00 $2,697,553.43 $52,398.57
371,813.00 381,191.65 340,832 96 40,358.69
726,627.00 804,980.36 715,603 17 89,377.19
1.91% - Fay. due to turnover.
10 59% - Fay. Bank Charges and postage due to improved operating methods
11.10% - Fav. Information Technology imaging due to delay in project implementation.
12/02/99
COUNTY OF OAKLAND
FY 1999 YEAR END REPORT
EXPENDITURES
CENTRAL SERVICES
AMOUNT
ADOPTED AMENDED FY 1999 FAVORABLE
BUDGET BUDGET ACTUAL (UNFAVORABLE) EXPLANATION OF SIGNIFICANT VARIANCES
Administrative
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Support Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$141,834 00 5141,834.00 $143,176.15
2,522.00 2,522.00 825 69
10,684.00 12,806.84 12,480.36
$155,040.00 $157,162.84 $156,482.20
$880,707.00 $819,490.00 $777,655.30
26,683 00 59,563.54 42,989.09
592,776.00 676,789.71 700,757.56
$1,500,166.00 $1,555,843.25 $1,521,401.95
$1,022,541 00 $961,324.00 $920,831.45
29,205.00 62,085.54 43,814.78
603,460.00 689,596.55 713,237.92
($1,342.15) Unfavorable due to increased fringe benefits expenditures
1,696.31 Usage of Contractual Services was less than anticipated
326 48 Use of lease vehicles and print shop less than anticipated
$680.64
$41,834 70 Favorable due to turnover in personnel
16,574.45 Expendable equipment expense favorable due to less than anticipated cost of equipment
(23,967 85) Building Space Cost actual charges are higher than budgeted amount
$34,441.30
$40,492.55
18,270.76
(23,641.37)
$1,655,206.00 $1,713,006.09 $1,677,884.15 $35,121.94
("3
12/02/99
12/01/99 14.WK4
COUNTY OF OAKLAND
FY 1999 YEAR END REPORT
FACILITIES MANAGEMENT. EXPENDITURES
AMOUNT
ADOPTED AMENDED FY 1999 FAVORABLE
BUDGET BUDGET ACTUAL (UNFAVORABLE 1 PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$988,436.00 $576,307.00 $461,313,50 $114,993 50 19 95% Salaries 8 Fringes are favorable due to vacancies in Tech Sup! & Admen staff
315,902.00 124,297 00 17,538.89 106,758.11 85 89% Overall Cant Oper is fav largely due to Solid Waste prof sacs, & legal exp not incurred
345,781 00 130,754.00 132,205.83 (1,451 83) -1.11%
$1,650,119.00 $831,358.00 $611,058.22 $220,299.78 2650%
Facilities Engineering
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$832,555.00 $825,555.00 $783,808 59 $41,746.41 5 06% Salaries & Fringes are favorable due to position turnover, & vacancies
126,327.00 153,416.36 235,250.60 (81,834 24) -53 34% Unfav, largely due to travel 8 conf attend trade cont., & inflation incr in prof sacs & member dues
151,082 00 161,217.37 164,220 23 (3,002 86) -1 86% Non-Control Oper is untav largely due to Info-Tech open , leased tieh a telephones
$110996400 $1,140,188.73 $1,183,279.42 ($4309069) -378%
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$1,820,991 00 $1,401,862.00 $1,245,122.09 $156,739 91 1118%
442,229.00 277,713.36 252,789 49 24,923.87 8.97%
496,863 00 291,971.37 296,426.06 (4,454.69) -1.53%
$2,760,083 00 $1,971,546.73 $1,794,337.64 $177,209 09 8.99%
8,700.82 4,025.00 6,525.00
COUNTY OF OAKLAND
FY 1999 YEAR END REPORT
EXPENDITURES
PERSONNEL
AMOUNT
ADOPTED AMENDED FY 1999 FAVORABLE
BUDGET BUDGET ACTUAL (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel $252,109 00 $252.109.00 $257,469.84
Controllable Operating
6,359.00 18,459.61 19,703.07
$262,493.00 $277,093.61 $285,873.73
Human Resources
Controllable Personnel $1,709,147.00 $1,727,485.00 $1,727,493.31
Controllable Operating 350,887.00 356,957.25 310,899.85
Non-Controllable Operating 507,206.00 789,937 69 703,702.19
$2,567,240.00 $2,874,379.94 $2,742,095.35
$618,341.00 $631,551.00 $634,970.24
183,480.00 213,759.10 183,484.88
Non-Controllable Operating 115,092 00 115,092.00 115,077.23
$916,913.00 $960,402.10 $933,532.35
Department Total
Controllable Personnel $2,579,597.00 $2,611,145.00 $2,619,933.39
Controllable Operating 538,392.00 577,241.35 503,085.55
Non-Controllable Operating 628,657.00 923,489.30 838,482,49
($5,360.84) -2.13% - Positions underbudgeted due to the use of prior years' data. Situation corrected
with the FY 2000 budget.
(2,175.82) -33.35% - Unfav. Travel & Conference due to two annual Peoplesoft conferences being held in the
same fiscal year. These conferences were to be charged to the Fringe Benefit Fund,
unfortunately, they were mischarged to this budget, causing the unfav.
(1,243.46) -6.74% - Unfav. Convenience Copier charges reflecting increased usage
($8,780.12) -3.17%
($8 31) -0.00%
46,057.40 12.90% - Fav. Intern Program due to difficulties in recruitment.
86,235.50 10.92% Fav. Information Technology Development due to over budgeting of last quarter expenses.
$132,284.59 4.60%
($3,419 24) -0.54% - Overtime unfav. due to heavy workload.
30,274.22 16.50% - Fay. Professional Services due to quicker completion of certain bargaining unit
negotiations. Employee Medical Exams - ADA also fav. due to lower requests than
anticipated.
14.77 0.01%
$26,869.75 2.88%
($8,788.39) -0.34%
74,155.80 12.85%
85,006.81 9.20%
Non-Controllable Operating
Employee Relations
Controllable Personnel
Controllable Operating
$3,746,646.00 $4,111,875.65 $3,961,501.43 $150,374.22 3.66%
12102/99
EXPLANATION OF SIGNIFICANT VARIANCES
COUNTY OF OAKLAND
FY 1999 YEAR-END REPORT
EXPENDITURES
HUMAN SERVICES
AMOUNT
ADOPTED AMENDED FY 1999 FAVORABLE
BUDGET BUDGET ACTUAL (UNFAVORABLE) PERCENT
--------- – — — — — — –– —
$14827700 $147,025.58
Administration
Controllable Personnel $148,277.00 $1,251.42 0.84% Reimbursement of personnel costs for Human Services Coordinating Council grants for period
of 8/28/99 - 9/30/99.
Controllable Operating 9,278,945.00 9,304,445.00 8,880.179 11 424,265 89 4.56% Quarterly payments fav $200,700 to Human Services Agency (OLHSA) . Payment short by one
quarter due to timing of actual payments (Jan. Apr., Aug ) The schedule has been corrected
to start in Oct for FY 2000 Also, Foster Care (FIA) fay. $53,200, Independent Living lay
$83.800. Private Institutions-Foster Care fav. $154,600, and Private Institutions fay. $508,900
due to the decrease in demand for for these services. This lay is offset by a significant
unfav variance ($552,950) in Private Institutions-Residential and need for Dry Goods and
Clothing 155,800), due to an increase in usage and length of stay for more specialized care
Non-Controllable Operating
Non-Controllable Operating reflects unfav variance due to start-up costs for printing and copying
7,27200 727200 7,531 26 (259.26) -3.57% of materials associated with implementation of Human Services Coordinating Council; offset by
lower than anticpated IT-Operations costs and usage of Stationary Stores for supplies
$9,434,494.00 $9,459,994.00 $9,034,735.95 $425,258 05 4.50%
Health
Controllable Personnel $20,202,636.00 $20,475,872.00 $19,190,193 74 $1,285,678 26 6.28% Fait $1,394,600 due to turnover, Offset by unfav. Overtime 5(108,900) due to continued high
activity in Jail Health, with greater turnover of staff; Central Support unit reflects high usage
of Overtime due to large volume of data entry done for the new well code system. Also. the
Sanitarian position for Southfield was not filled until the second quarter and the revenue
associated with this position was incorrectly posted as Salaries Reimbursement instead of
Reimbursement of Contracts
Controllable Operating 3,863,067 00 5,975,055 38 5,416,574 77 558,480 61 9.35% Professional Services fav. $499,400 primarily due to lenthy (1 to 2 months) time frame involved
between the billing process and making the actual payment Invoices were not issued until the
services had been completed, which in some cases took several months Also with the
anticipated closing of the Breast Z. Cervical Cancer Screening Program, and the continued
decrease in TB cases, supplies are fav. $58,600.
Non-Controllable Operating
Children's Village
Controllable Personnel
Controllable Operating
Non-Controllable Operating
2,305,342.00 2,907,463.51 2,772,850 48 134,613 03 4.63% Health Division Building Space Cost was adjusted due to grant being incorrectly charged to
Health Fund instead of the grant fund $96,200; Equipment Rental charges fay $10.850 and
Telephone Communications fav. $29,950 as actual costs were less than anticipated.
$26,371,045.00 $29,358,390.89 $27,379,618 99 $1,978,771 90 6 74%
$8,348,827.00 $8,374,194.00 $8,388,726 50 ($14,532.50) -0.17% Salaries and Fringe Benefits fav. $575,550, while Overtime is unfav ($165,900) due to high
turnover of staff, particularly for secured buildings. Also. Emergency Salaries unfav. ($424,200)
The offset is reflected in the Non-Dept. Emergency Salaries account.
2,666,847.00 2,657,498.50 2,626,620.67 30,877 83 1 16% Teachers Services and Expense fay. $183,700 due to greater efficiencies, offset by unfav.
Laundry and Cleaning ($46,700) due to change in policy to increase the number of days
laundry is done; Expendable Equipment Expense unfav. ($54,700) due to costs for new security
systems installed in secured buildings greater than anticipated; Commodities unfav ($52,100)
due to an increase in number juveniles and specialized needs
1.833.24800 2.161,787.83 1,983,838 02 177,949.81 8 97% Information Technology Operations fav $276,500 as cost operating costs for new computers
less than anticipated; offset by unfav. Materials Management supplies unfav. ($80,750) again.
----- due to an increase in number of juveniles and specialized needs; Radio Communications also
$12,848,922.00 $13,193,480 33 $12,999,185 19 $194,295.14 1.47% unfav. ($20,600) as FY 1998 project to purchase and install security cameras in the secured
buildings was unintentionally not implemented until the beginning of FY 1999. As a result no
funds were ever carried forward to cover the costs of the project.
12/01/99
Medical Examiner
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
4.19%
5.50%
3.52%
4 55%
$1,750,097 00 $1,750.097.00 $1,735,644.30 $14,452 70 083% Due to delay in hire of Forensic Pathologist and Typist I position approved in FY 1999 Budget.
Salaries and Fringe Benefits lay. $5,200, while Overtime unfav. ($19,700).
381,738 00 469,738.00 471,137 58 (1,399,58) -0.30% Contractual costs have tapered as projected due to the decrease in demand for outside services,
while Commodities were slightly unfav. due to the increase in supplies needed (i.e. Medical
Supplies).
591,093,00 876,101.00 978,959.21 (102.858.21) -11.74% Building Space cost unfav. ($131,700) due to building space allocation inaccurately
adjusted for the new facility, which resulted in a budgeted amount less than actual cost
________ offset by fav. Information Technology-Operations $41,150 as cost for the new computers
installed was less than anticipated
$2,722,928 00 $3,095,936 00 $3,185,741.09 ($89,805.09) -2.90%
$30,449,837.00 $30,748,440.00 $29.461,590.12 $1,286,849 88
16,190,597 00 18,406,736.88 17,394,512 13 1,012,224 75
4,736,955.00 5,952,624.34 5,743,178.97 209.445 37
$51.377,389 00 $55,107,801 22 $52,599,281 22 $2,508,520 00
12/01/99
$129,653.00
174300
$12965300
1,743 00
$131,337 26
6,127 70
Public Services - Admin.
Controllable Personnel
Controllable Operating
($1,684.26) -1.30%
(4,384 70) -251.56% - Controllable Operating primarily unfav, due to expansion of services for new Troy facility
$1,815,200.00 81,857,474 44 $1,871,403.83 ($13,929.98) -0 75%
12/02199
COUNTY OF OAKLAND
FY 1999 YEAR-END REPORT
EXPENDITURES
PUBLIC SERVICES
AMOUNT
ADOPTED AMENDED FY 1999 FAVORABLE
BUDGET BUDGET ACTUAL )UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Non-Controllable Operating
11,117 00 11,117.00
$14251300 6142,513.00
6,748.47 4,368.53
$144,213 43 ($1,700 43)
39.30% - Charges for Equipment Rental and Information technology - Operations significantly less than
anticipated
-1.19%
Veteran's Services
Controllable Personnel
Controliable Operating
$1,164,911 00 $1,168,416.00 $1,095,954 45
303,442 00 308,134 51 237,292 58
$72,461.55 6.20% - Turnover
70,841 93 22.99% - F.av primarily due to Soldier Burial eligibility requirements
Non Controllable Operating 221,819 00 243,147 65 247,191 96 (4,044 31) -1.66% - Unfav primarily due to Information Technology-Operations ($8,900) and Telephone
Communication ($3,700) charges higher than anticipated, offset by fay, usage of Stationery
Stock $3,500 and Leased Vehicles $3,600.
$1,690,172 00 $1,719,698 16 51,580,438 99 $13925917
Community Corrections
Controllable Personnel $1,152,153.00 $1.276,800.00 $1,049,416 45 $227„383.55 17.81% - Salary & Fringe fay $258,800 due to delay in filling new positions, partially offset by unfav.
Overtime ($31,400) due to rapid expansion of Alternative Programs. Controllable Operating 74,833.00 218,035.57 207,921 24 10,114.33 4.64% - Grant Match fay. $35,150 and Operating Transfer fan. $50,000 as these items were utilized less
than anticipated: offset by unfav. Material and Supplies due to additional program demands.
Non-Controllable Operating 75,484.00 125,584.00 239,754 36 (114.170 36) -90.91% Building Space Costs unfav. ($90,800) and Information Technology - Operations unfav.($12,100)
due to actual charges greater than anticipated Leased Vehicles unfav ($10,800) due to addition
$1,302,470 00 $1,620,419.57 $1,497,092.05 $123,327.52 7.61% of one (1) van
8 10%
MSU Ext. Oakland County
Controllable Personnel 651,604.00 713,490.00 659,915.99 53,574.01 7.51% - Fay. Salaries & Fringes due to turnover 860.300, partially offset by unfav. Overtime ($6,700).
Controllable Operating 338,638 00 348,906,85 296,106 60 52,800.25 15.13% - Professional Services fay $132,400 as actual acreage sprayed, lower than anticipated; offset
by unfav Workshops and Meetings ($26,800), Car Allowance ($23,500), Field Trips ($17,850)
and Miscellaneous ($12,400) due to usage of these accounts, for which there was no budget.
Non-Controllable Operating 208,435.00 254,142.62 232,575 93 21,566.69 8.49% Information Technology - Operations charges were less than anticipated.
$1,198,677.00 31,316,539 47 $1,188,598 52 $127,940.95 9.72%
Animal Control
Controllable Personnel $1,227,214.00 $1,256,801 00 $1,290,709 61 ($33,908.61) -2.70% - Unlay. Overtime ($31,700) primarily due to heavy workload
Controllable Operating 107,089.00 107,490.00 108,667.59 (1,177.59) -1 10% - Controllable Operating expense slightly unfav, due to higher usage of Professional Services than
anticipated, offset by fewer purchases of supplies.
Non-Controllable Operating 480,897 00 493,182.85 472,026.63 21,156 22 4.29% Fay_ due to charges for Leased Vehicles and Radio Communications less than anticipated.
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Con b unable Operating
COUNTY OF OAKLAND
FY 1999 YEAR-END REPORT
EXPENDITURES
PUBLIC SERVICES
AMOUNT
ADOPTED AMENDED FY 1999 FAVORABLE
BUDGET BUDGET ACTUAL (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Circuit Court Probation
Controllable Personnel $0 00 30.00 $0 00 0.00%
Controllable Operating 31,055 00 26,52520 141,522 02 (14,996 82) 000% - Increase in purchase of Office Supplies though outside vendor instead of Stationery Stores. The
Stationery Stores account reflects a fav offset
839,085 00 806,348.00 718,976 82 87,371 18 10.84% Fav. $100,000 due to lower than anticipated cost for Building Space; offset by unfav. Telephone
Communications ($15.400) as charges were higher than anticipated
$870,140 00 $932,873 20 3860,498 84 $72,374 36 7.76%
$4.325,535 00 $454516000 $4,227,333 76 $317,826 24 6 99%
856,800 00 1,110,1335 13 997,637 73 113 197 40 10 19%
1,836,837 00 1.933,522 12 1.917,274 17 16,247 95 084%
$7,019,172 00 37,589,517 25 $7,142,245 66 $447,271 59 5.89%
12/02/99
Department Total $5,006,808.00 $7,030,737.79 $7,046,059.94 ($15,322.15) -0.22%
ADOPTED AMENDED
BUDGET BUDGET
Administration
COUNTY OF OAKLAND
1999 YEAR END REPORT
EXPENDITURES
INFORMATION TECHNOLOGY
FY 1999 AMOUNT
YEAR END FAVORABLE
ACTUAL (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Controllable Personnel
Controllable Operating Expenses
Non-Controllable Operating Expenses
Division Total
$0 $358,040.00 $355,242.18 2,797.82
155,808.00 238,739.42 225,400.53 13,338.89
4,851,000.00 6,433,958.37 6,465,417 23 (31,458.86)
$5,006,808.00 $7,030,737.79 $7,046,059.94 ($15,322.15)
5.59% - Unused Professional Services DISC Res. 98041
-0.49% Dala Warehouse Res. #97136 $155,808, Enhancements to
Equalizaton & Tax Billing Sys. Res 98242 $552,500, #99005
-022% $279,115 Med. Ex. Case Mgmt , Res. #99059 E-911 $2,700,000
#99140 MAN/WAN $1,301,721
Prepared by Fiscal Services, Linda Pearson 1 12/02/99
$2308961 GO
673.622 71
$2,234,086 72
549,570 72
Community and Home Improvement
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Equalization
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$252,993.05 11.33% Division transferred from Community and Economic Development to the Department of
($183,065 54) -47 24% Management and Budget during FY 1999 resulting in variances due to the timing of expenditures
$484,629.32 47.82% Information Tech - Operations cost lower than anticipated.
$554,556.83
270,928 00 304,453.00 299,025.00 5,428.00 1.78% Actual match required less than expected.
$5,244,263 00
220,049.00
1,028,112 00
$2,232,105 00
387,560.32
1,013,353.64
1,979,111.95
570,625.86
528,724 32
$6,492,424.00 $3,633,018.96 $3,078,462.13
$7,218,601.52 $999,149 95 12.16%
COUNTY OF OAKLAND
FY 1999 YEAR END REPORT
EXPENDITURES
COMMUNITY AND ECONOMIC DEVELOPMENT
AMOUNT
ADOPTED AMENDED FY 1999 FAVORABLE
BUDGET BUDGET ACTUAL (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
--------
$142,402.00 $19565300 $152,410.57 $43,242 43 22.10% Fav due to vacancies
88,779.00 144,702 00 96,733 32 $4796868 33 15% Fav. Legal Services $25,135 and Membership Dues $15,291, and Travel and Conference $9,955.
43,521.00 86,074 46 32,711 03 $53,363.43 62 00% Fay. Information Tech. Operations and Development and Budding Space Cost due to lower costs
than anticipated.
$274,702.00 $426,429 46 $281,854 92 $144,574.54 33.90%
Planning and Economic Development Services
Controllable Personnel $2,283,494 00
Controllable Operating 647,752 00
545,412 00 871,266 34 775,602 03
$3,476,658 00 $3,853,850.05 $3,559,259.47
$74,874 28 3 24%
$124,051 99 1842%
$95,664.31 10.98%
$294,590 58 7 64%
Fav due to underfilled and vacant positions
Fay Printing $73,191 and Professional Services $97,110 due to uncompleted printing of collateral
materials due to vacancy of Marketing Coordinator position In addition, street atlas's were not
not fully revised due to existing inventories, resulting in favorability for these line-items.
Fav. Print Shop $37,978 and Info Tech Operations fay. $48,176 due to replacement of older PC's
with Intergraph PC's
Non-Controllable Operating
$270,928.00 $304,453.00 $299,025.00 $5,428.00 1.78%
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$7,670,159.00 $4,736,719.00 $4,365,609.24
1,227,508.00 1,510,338 03 1,515,954.90
1,617,045.00 1,970,694.44 1,337,037.38
$371,109 76 7.83%
(5,616.87) -0.37%
633,657.06 32.15%
$10,514,712.00 $8,217,751.47
•
12/02/99
COUNTY OF OAKI-AND
FY 1999 YEAR END REPORT
EKPEND1TURES
BUDGET BUDGET AMOUNT
AS AS FY 1999 FAVORABLE
ADOPTED ADJUSTED ACTUAL (UNFAVORABLE) PERCENT EXPLANATION
NON-DEPART. APPROPRIATIONS
COUNTY OPERATIONS
Financial System $000 $498,860.00 $0.00 $498„860.00 100 00% Upgrades to HRFIS System held off to FY 2000.
State Institutions 635,300 00 635,300.00 457,612 26 177,687.74 27.97% Reduced use of state facilities for County wards, ordered into custody by the Circuit Court
Ambulance 19,800 00 19,800.00 9,649 00 10,151.00 51.27% Reduced usage.
Insurance arid Surety Bonds 85,100 00 85.100.00 77,538.00 7,56200 8 89%
Tax Tribunal Appeals 702,900 00 652,608..00 0.00 652,608.00 100 00% Line item no longer used
Road Commission - Drain Assessment 1,116,300.00 1.116,300.00 1,127,255.12 (10,955.12) -0 98% Increased road work requiring additional work on easements
Road Commission - In-Party Agreement 1,250,000.00 1„250,000„00 1,330,133 00 (80,133.00) -641% Final payment for FY 1998 charged to FY 1999 due to timing difficulty.
Remonumentation 000 1,129,755.55 1,129,755.55 000 000%
MANiWAN 0.00 000 0.00 000 0.00%
Grant Match 000 6,844.384 00 6.520,715.34 323,668 66 4 73% Match requirements met.
$3,809,400.00 $12,232,107.55 $10,652,653.27 $1,579,449.28 12.91%
COUNTY BUILDINGS $3,115,567.00 $2,598,694.10 $1,440,953 52 $1,157,740 58 44.55% Anticipated $650,000 transfer paid from "Transfers -General Activities" account (see below); also
reallocation of certain vacant space and Public Works building space to user departments.
COUNTY ASSOCIATIONS
SE M.0 0.G.
Association of Metro Sewage Groups
Area Wide Water Quality
National Assoc. of Counties
Michigan Assoc. of Counties
Traffic Improvement Association
$415,000.00 $415,000.00 $420,347 50 ($5,347 50) -1 29% Actual dues.
0.00 0.00 1.500.00 (1,500.00) -100.00% Actual dues.
57,200.00 57,200.00 52,190.00 5,010.00 8.76% Actual dues.
19,000.00 19,000.00 19,092.00 (92.00) -0.48% Actual dues.
50,000.00 50,000.00 56,287.00 (6,287.00) -12.57% Actual dues.
22,300.00 22,300,00 22,300.00 0.00 0.00% Actual dues.
$563,500.00 $563,500.00 $571,716.50 ($8,216.50) -1 46%
SUNDRY $674,300.00 $1,367,305.00 $260,844 06 $1,106,460.94 80 92% Anticipated transfers paid from "Transfers-General Activities" account (see below)
RESERVED FOR TRANSFERS
Expenditures
Contingency $234,983.00 $7,516.00 $0.00 $7,516 00 100 00% Variance in "Reserves for Transfer" accounts reflect the remaining balances after funds have been
Infrastructure Improvements 0 00 3,000,000.00 3,000,000.00 0.00 0.00% moved to operating departments.
Salary Adjustment 0.00 0.00 0.00 0.00 000%
Classification & Rate Change 84,627.00 (896.00) 0 00 (896 00) 100.00%
Overtime 53,000 00 20,780.00 0.00 20,780.00 109.00%
Summer Employment 424,200.00 67.00 0.00 67 00 100 00%
Emergency Salaries 636,300.00 790,000.00 0.00 790.000 00 100 00% '
Fringe Benefit Adjustments 0.00 0.00 0 00 0.00 0.00%
Capital Outlay 75,000.00 15,956.75 000 15,956.75 100.00%
Clinton River Watershed Council 5,141.00 5,141.00 5,141 00 0.00 000%
Huron River Watershed Council 2,706.00 2,706.00 2,706.00 0.00 000%
Partnership for Saginaw River Watershed 2,276.00 2,276.00 2,276 00 0 00 0 00%
Rouge River Watershed Council 2,177.00 2,177.00 (2,124.00) 4,301.00 197.57%
Office Automation 1,200,000.00 3,031.00 0.00 3,031.00 100.00%
$272041000 $3,848,754.75 $3,007,999.00 $840,755 75 21 84%
Prepared by' Budget Division 1 11/23/99
($2,193,005 00)
0.00
000
170,833.62
-50.39% Transfers, budgeted in other accounts, paid from this account (see above)
0.00%
0.00%
8,79%
TOTAL NON-DEPT. APPROPRIATIONS $22,616,749.00 $36,696,333.40 $34,042,314 73 7.23% $2,654,018.67
$10,618,762.91
22,974,152.98
13,873,479.45
67,378.00
0 00
$10,063,700 35
20,878,336 63
11,826,002 59
14,417.41
0.00
$555,062.56
2,095,816.35
2,047,476 86
52,960.59
0.00
TRANSFER TO GENERAL PURPOSE FUNDS
Friend of the Court Fund $9,852,993.00
Health Fund 23,364,748 00
Juvenile Maintenance Fund 14,036,647.00
Social Welfare Fund 67,378.00
CRIMP Fund 0 00
5 23% Favorable variances reflect underexpenditures in the operating departments supported by these
9.12% funds. Underexpenditures in those departments reduces the requirements for this General Fund
14 76% transfer.
78 60%
0.00%
COUNTY OF OAKLAND
FY 1999 YEAR END REPORT
. EXPENDITURES
Transfers to Other Funds
General Activities
Environmental Infrastructure
Building Fund
Building Authority
BUDGET
AS
ADOPTED
$000
5,000,000 00
3.242,911.00
3,490,661 00
BUDGET
AS
ADJUSTED
$4,352,400.00
5,000,000 00
4,789,272 00
1,944,300.00
FY 1999
ACTUAL
56,545,405 00
5,000,000.00
4,789,272 00
1,773,466.38
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION
$11,733,572 00 $16,085,972.00 $18,108,143.38 ($2,022,171 38) -12.57%
$47,321,766.00 $47,533,773.34 $42,782,456 98 $4,751,316.36 10.00%
va‘Cel ,
Prepared by: Budget Division 2 11/23/99
FY 1999 BUDGET AMENDMENTS
General Fund
General Purpose
FY 1999 BUDGET AS ADOPTED
BUDGET AMENDMENTS
M.R. #98233 - 10/15/98
Sheriff Department - Law Enforcement Contract
Amendment for Highland Township
M.R. #98242 - 10/15/98
Information Technology - Enhancement of County's
Assessing, Equalization and Tax Billing and
Collection System
M.R. #98258 - 10/29198
Sheriff Department - Law Enforcement Contract
Amendment for Addison Township
M.R. #98258 - 10129/98
Central Services - Temporary Fleet Expansion
for Community Corrections
M.R. #98271 - 11/19/98
Health Division - Partnership Agreement with
the City of Southfield
M.R. #98281 - 11/19/98
Circuit Court - Local Law Enforcement Block Grant
Match
$293,711,502.00
$77,477.00
552,500.00
83,526.00
9,000.00
73,843.00
17,674.00
M.R. #98282 - 12/10/98 114,179.00
Circuit Court - Use of Mediation Funds
M.R. #98295 - 12/10/98
Sheriff Department - Law Enforcement Contract
Amendment for Oakland Township
M.R. #98296 - 12/10/98
Sheriff Department - Law Enforcement Contract
Amendment for Springfield Township
M.R. #98325 - 12/10198
Sheriff Department - Law Enforcement Contract
Amendment for Commerce Township
M.R. #98294 - 12/10/98
Sheriff Department - Contract for Court Security at
the 48 th District Court - Bloomfield Township
M.R. #98289 - 12/10/98
Drain Commissioner - Implementation of Labor
Distribution System, Miscellaneous Accounting
Policy Changes and Organizational Changes
60,214.00
68,110.00
48,611.00
13,923.00
($3,788,431,00)
M.R. #98313 - 12/10/98 $100,000.00
Clerk/Register of Deeds - Remonumentation Grant
M.R. #98315 - 12/10/98 $7,232.00
Library Board - LBPH - Creation of One GF/GP
Clerk I Position and the Deletion of Two PINE
General Clerical Positions
M.R. #98328 - 12/10/98 $11,706,764.05
Management and Budget - FY 1998 Year End
Report and Budget Amendments
M.R. #98339 - 12/10/98 $233,807.00
Personnel Actions Related to the Transition of
Community Mental Health to an Authority
M.R. #99005 - 1/25/99 $350,000.00
Medical Examiner - Case Management System
M.R. #99043 - 2/25199 $89,195.00
Sheriff - FY 1998 State Criminal Alien Assistance
Grant Acceptance
M.R. #99031 - 2/25/99 $126,505.00
Community Corrections - Program Expansion
M.R. #99042 - 3/18/99 $2,700.00
Sheriff Department - Processing Fee Increase
M.R. #99049 - 3/18/99 $28,000.00
Prosecutors Office - Fleet Expansion
M.R. #99050 - 3/18/99 $1,494,259.00
Health Division - Acceptance of FY 1998/1999
CPBC Contract
$97,794.00
$3,826,200.00
$22,521.00
$36,898.00
$48,693.00
$4,000.00
M.R. #99056 - 3118199
Equalization Division - Digital Photography Project
M.R. #99060 - 3/18/99
Management and Budget - FY 1999 First Quarter
Financial Forecast and Budget Amendments
M.R. #99057 - 4/15/99
Management and Budget/ Equalization -
Reorganization
M.R. #99065 - 4/15/99
Sheriff Department - Law Enforcement Contract
Amendment for Orion Township
M.R. #99066 -4115/99
Sheriff Department - Law Enforcement Contract
Amendment for Oakland Township
M.R. #99068 - 4/15/99
Sheriff Department - Use of DARE Vehicle
te,
M.R. #99070 - 4/29/99 $78,597.00
Circuit Court - Use of Mediation Funds
M.R. #99071 -4/29/99 $165,088.00
Sheriff Department - Use of Forfeited Funds
KR. #99105 - 4129/99 $20,000.00
52-3 District Court - Additional Lease Space
M.R #99114 - 5/27/99 $197,332.00
Sheriff's Department - Use of Forfeited Funds for
K-9 Program
M.R. #99133 - 5/27/99 $339,874.00
Sheriff Department - Law Enforcement Contract
for Royal Oak Township
M.R. #99123 - 5/27/99 $693.005.00
Information Technology - Appropriation for
Unfunded Mandates
M.R. #99130 - 6/10/99 $3,000,000.00
I-75/M-59 Technology Park Improvements
M.R. #99140 - 6/10/99 $232,000.00
Information Technology - MAN/WAN
M.R. #99136 - 6/10/99 $77,519.00
Management and Budget - Equalization - Commerce
Township Contract
M.R. #99141 - 6/10/99
Management and Budget - FY 1999 Second Quarter
Financial Forecast
M.R. #99160 - 8/5/99
Community Corrections - Additional Position for
Club 'Em Program
M.R. #99161 - 8/5/99
Sheriff Department - Rochester Hills Deputy
Contract Amendment
M.R. #99162 - 8/5/99
Sheriff Department - Rochester Hills Sergeant
Contract Amendment
M.R. #99179 -8/5199
Sheriff Department - Groveland Township Special
Event Contract
M.R. #99184 - 8/5/99
Information Technology - Purchase of Election
Results Management System
M.R. #99210 - 9/9199
Circuit Court - Use of Mediation Funds
$7,288,263.00
$2,425.00
$27,934.00
$10,520.00
$31,998.00
$364,482.00
$80,478.00
M.R. #99213 - 919/99
Sheriff Department - Oakland Township Contract
Amendment
M.R. #99215 - 9/9/99
Sheriff Department - Use of Forfeited Funds for
Southeastern Oakland County Resource Team
M.R. #99218 - 9/9199
Board of Commissioners - Formation of Electrical
Energy Evaluation Task Force
Total Amendments
$6,589.00
$19,700.00
$50,000.00
$967,888.00
$29,158,886.05
M.R. #99228 - 9/9/99
Management and Budget - FY 1999 Third Quarter
Financial Forecast and Budget Amendments
Amended Budget 9/30/99 $322,87_0.,388.4t5
Prepared by: Fiscal Services Division
$152,328
108,054
$260,382
$125,100
400,986
$526,086
$125,100
400,986
$526,086
$277,428
509,040
$786,468
$16,200
$276,582
$526,086 $526,086 $509,886
$0 $0 $276,582
, MICROGRAPHICS FUND (#654)
REVENUES
Outside
Inside
Total Revenues
OPERATING EXPENSES
REVENUE OVER (UNDER)
EXPENDITURES
-Favorable revenue variances reflect the high demand
from outside title companies and internal county departments,
primarily the Register of Deeds Division, for micrographic
services, caused by the high real estate activity level in
Oakland County during FY 1999.
-Favorable Print Shop and Depreciation variances.
COUNTY OF OAKLAND
FY 1999 YEAR-END REPORT
INTERNAL SERVICE FUNDS
DEPARTMENT OF CLERK/REGISTER OF DEEDS
ADOPTED AMENDED FY 1999 VARIANCE
BUDGET BUDGET ACTUAL FAV/(UNFAV) EXPLANATION OF SIGNIFICANT VARIANCES
11/19/99
DEPARTMENT OF DRAIN COMMISSIONER
INTERNAL SERVICE FUNDS
1999 YEAR END REPORT
ADOPTED AMENDED 1999 VARIANCE
BUDGET BUDGET ACTUAL FAVOUNFAV) COMMENTS
DRAIN EQUIPMENT FUND (#639)
OPERATING REVENUES:
Outside Revenue
Inside Revenue
Total Revenue
OPERATING EXPENSES
$2,058,161 00 $1,958,140.00 $1,497,723.76 ($460,416.24) Unfavorable due largely to reduced rebilled chgs., & rental equip revenue.
86,898 00 86,898 00 746,443.45 659,545.45 Favorable due largely to increase in vehicle rental revenue
$2,145,059.00 $2,045,038.00 $224416721 $199,129 21
$2,538,232.00 $2,438,211 00 $1,811,504.00 $626,707 00 Favorable due largely to position vacancies, savings to contracted svcs, & leased veh. expense.
OPERATING INCOME (LOSS) ($393,173.00) ($393,173.00) $432,663.21 $82583621
NET NON-OPERATING REVENUE (EXP) $40,022.00 $40,022.00 $78,098 00 $38,076 00 Favorable due to gain on sales of vehicles & equip offset by lower returns on investments.
NET REVENUES OVER(UNDER)
EXPENSES ($353,151.00) ($353,151,00) $510,761.21 $863,912.21
1 FOREPRNT.VVK41dASdate1123wksidrain1 12/02/9904:37 PM
RISK MANAGEMENT
INTERNAL SERVICE FUND
FY 1999 YEAR-END REPORT
ADOPTED AMENDED FY 1999 VARIANCE
BUDGET BUDGET ACTUAL FAVAUNFAV)
LIABILITY INSURANCE FUND (#677)
COMMENTS
REVENUE $3,596,728 $3,596,728 $3,794,342 $197,614 - Fav. Investment Income 309,049 due to higher than expected interest
rates and investment base, partially offset by reduced Liability
Insurance revenue due to Community Mental Health's move on 1-1-99
to Authority status (87,343) and Rebilled Charges (24,092).
OPERATING EXPENSE $807,561 $807,561 $785,893 $21,668 -Fav. Insurance premium costs 36,016, turnover 33,203, insurance
appraisal, vaccines, and training supplies costs partially offset by
unfav. Legal Services charges (22,793) for preparation for potential
legal suit and Information Technology Operations costs (35,128).
CLAIMS PAID 2,789,167 2,789,167 2,412,591 376,576 -Adjustment of Liability Insurance claim-year reserves as determined by
fiscal year-end analysis of claims and reserve requirements.
TOTAL EXPENSES $3,596,728 $3,596,728 $3,198,484 $398,244
NET REVENUES OVER/(UNDER)
EXPENSES
$0 $0 $595,858 $595 858 , _ I
FRINGE BENEFIT FUND
INTERNAL SERVICE FUNDS
FY 1999 YEAR-END REPORT
ADOPTED AMENDED
BUDGET BUDGET
FY 1999 VARIANCE
ACTUAL FAVAUNFAV) COMMENTS
FRINGE BENEFIT FUNI3(#6714
REVENUE
DEFINED BENEFIT CONTRIBUTION
RETIREES HOSPITALIZATION
RETIREMENT ADMINISTRATION
COMPENSATED ABSENCES
TUITION REIMBURSEMENT
EMPL. DEFERRED COMP ADMIN
EMPLOYEE IN-SERVICE TRAINING
DEFINED CONTRIBUTION PLAN
DEFINED CONTRIBUTION ADMIN.
GROUP LIFE
HOSPITALIZATION
SOCIAL SECURITY
DENTAL INSURANCE
OPTICAL INSURANCE
DISABILITY INSURANCE
SHORT-TERM DISABILITY
FLEXIBLE BENEFITS DEDUCTIONS
FORFEITURES
WORKERS COMPENSATION
UNEMPLOYMENT COMPENSATION
INVESTMENT INCOME
TOTAL REVENUE
$1,534,100 $1,534,100 $1,629 ,554
12 681,100 12,681,100 11,782,013
2,986,100 2,986,100 2,879,704
750,000 750,000 723,735
300,000 300,000 289,494
39,800 39,800 67,544
845,100 845,100 812,615
6,744,400 6,744,400 6,503,458
458,400 458,400 441,859
794,400 794,400 771,126
18,207,700 18,207,700 18,290,625
13 538,400 13,538 400 12,429,274
2,310,000 2,310,000 2,387,393
315,600 315,600 319,593
615,000 615,000 592,956
1,262,300 1,262,300 1,174,829
206,500 206,500 85
185,000 185,000 265,473
3,210,500 3,210,500 3,348 916
225,000 225,000 216,497
750,000 750,000 1,879,460
$67,959,400 $67,959,400 $66,806,203
$95,454 -95.4% of the Retirement revenue budget was recovered in FY 1999.
(899,087) The move of Community Mental Health to Authority status, effective 1-1-99, reduced both
(106,396) revenue and expenditure to the Fringe Benefit Fund beginning in January 1999
(26,265)
(10,506)
27,744 -Includes transfer of interest earned in Deferred Compensation Fund (now closed).
(32,485)
(240,942)
(16,541)
(23,274)-CMH separation reduced revenue.
82,925 -Increased number of emloyee health-care contracts
(1,109,126)-Social Security (FICA) revenue follows FICA expenditure: CMH separation reduced revenue
77,393 -Increased number of emloyee dental contracts
3,993
(22,044)
(87,471)-Departments are charged for actual short-term disability costs.
(206,415)-Payments from employees for .enhanced coverages in Flex Benefit Program are now netted
against amounts paid to employees for reduced coverages. eliminating this revenue.
80,473 -Return of DC Plan contributions from ICMA for employees who separated from County service
138.416 prior to vesting and health & dependent care forfeiture of unused deposits.
(8,503)
1,129,460 -Interest rates and investment base higher than expected
($1,153,197)
EXPENSE
DEFINED BENEFIT CONTRIBUTION
RETIREES' HOSPII ALIZATION
RETtREMENT ADMINISTRATION
COMPENSATED ABSENCES
TUITION REIMBURSEMENT
EMPL. DEFERRED COMP. ADMIN.
EMPLOYEE IN-SERVICE TRAINING
1N-SERVICE TRAINING - INFO TECH
DEFINED CONTRIBUTION PLAN
DEFINED CONTRIBUTION ADMIN.
GROUP LIFE
HOSPITALIZATION
SOCIAL SECURITY
DENTAL INSURANCE
OPTICAL INSURANCE
DISABILITY INSURANCE
FLEXIBLE BENEFIT PAYMENTS
PROFESSIONAL SERVICES
WORKERS COMPENSATION
UNEMPLOYMENT COMPENSATION
ACCOUNTING SERVICES
OPERATING TRANSFER OUT
TOTAL EXPENDITURES
$1,534,100 91,534,100 $0
12,681,100 12,681,100 12,344,997
2,986,100 2,986,100 3,069,637
750,000 750,000 566,263
300,000 300,000 258,377
39,800 39,800 36,382
485,100 485,100 590,591
360.000 360,000 427 565
6,744,400 6,744,400 5,976,391
458,400 458,400 229,003
794,400 794,400 748,626
18,207,700 18,207,700 18,151,442
13,627,000 13,627,000 12,476,944
2,310,000 2,310,000 2,251,321
315,600 315,600 273,622
1,877,300 1,877,300 1,724,881
364,500 364,500 26,404
132,300 132,300 125,087
3,210,500 3.210,500 1,374,632
225,000 225,000 145,878
68,478
1,600,000
967,403,300 967,403,300 $62,466,521
$1,534,100 -Budget was established prior to receipt of latest actuarial calculation. Contribution to Retirement
Fund was not required for General County employees as per actuarial report.
336,103 -Budget was established prior to receipt of latest actuarial calculation.
(83,537)-Financial education seminars for County employees 106,900.
183,737 -Payments for accumulated AIL and SYL days to employees separating from County service.
41,623 -Cost reflects current level of participation in the Tuition Reimbursement Program.
3,418
(105,491)-Variance is due to PeopleSoft training costs.
(67,565)-Cost reflects current level of IT training.
768,009 -County contributions to ICMA for the Defined Contribution Plan, CMH separation reduced cost
229,397 -Administration fees paid to ICMA were reduced from an asset-based fee to $12/participant/yr.
45.774 -Variance reflects the separation of CMH employees 1/1/99
56,258 -Costs include actual claims costs, administration and stop/loss charges from BC/BS and HMO
premiums. Costs were credited 835,000 for adjustment of Health IBNR reserve.
1,150,056 -FICA rate applied against actual salaries cost; CMH separation reduced cost.
58,679 -Cost based on actual claims and administration fee paid to Delta Dental beg. January 1999
41,978 CMH separation reduced cost.
152,419 -Short-term disability claims (recovered by charges to departments).
338,096 -Payments to employees for reduced coverages (including hospitalization opt-outs) in Flexible
Benefits Program were netted against payments received from employees for enhanced
7,213 coverages, which reduced both Program expense and revenue.
1,835,868 -Adjustment of Workers' Compensation claim-year reserves as determined by fiscal
79,122 year-end analysis of claims and reserve requirements.
(68,478)-Charge for accounting services to Fringe Benefit Fund was implemented subsequent to budget.
_(1,600,000)-Transfer to Capital Improvement Fund for capital costs of on-site child care facility - MR#98329
$4,956,779
$556,100 $556,100 $4,339,682 $3,783,582 REVENUE OVER/( UNDER) EXPENSE
$3,371,638.00
3,378,138.00
(6,500.00)
6,500.00
$0.00
$3,378,138.00
3,378,138 00
0.00
6,500 00
$5.500.00
DEPARTMENT OF CENTRAL SERVICES
INTERNAL SERVICE FUNDS
FY 1999 YEAR END REPORT
ADOPTED
BUDGET
MATERIALS MANAGEMENT FUND 633
AMENDED
BUDGET
FY 1999 VARIANCE
ACTUAL FAVALINFAV) EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING REVENUE
OPERATING EXPENSE
OPERATING INCOME(LOSS)
NON-OPERATING REVENUE(EXPENSE)
NET INCOME (LOSS)
$3,586,105.09 $207,967.09 Favorable due to increase in demand for meats and groceries
3,656,428.27 (278,290.27) Unfavorable due to increased expenses in Personnel and Commodities
(70,323.18) (70,323.18)
13,704.71 7,204.71 Favorable due to investment income from larger than anticipated fund balance
($56,618.47) ($63,118.47)
MAILING, CONVENIENCE COPIER AND PRINTING FUND 667
$2,650,152.00
2,729,774.00
(79,622.00)
47,210.00
($32.412,0Q)
$2,647,577.00
2,731,064.00
(83,487.00)
48,500.00
($34,987.00)
OPERATING REVENUE
OPERATING EXPENSE
OPERATING INCOME(LOSS)
NON-OPERATING REVENUE(EXPENSE)
NET INCOME (LOSS)
$2,049,590.59 ($597,986.41) Unfavorable due to decrease in demand for printing and equipment rental
2,636,737.08 94,326.92 Favorable due to higher than anticipated usage of copier machines
(587,146.49) (503,659.49)
25,001.06 (23,498.94) Unfavorable due to investment income from less than anticipated fund balance
_ ($527,158:43)
$2,694,821.00
3,094,821.00
($400,000.00)
_400,000.00
_ $0.00
$4,162,263.00
4,744,219.00
($581,956.00)
279,293.00
($302,663 00)
$3,094,821.00
3,117,321.00
($22,500.00)
400,000.00
$3,77,500.00
$4,035,892.00
4,865,192.00
($829,300.00)
485,091.00
($344,209.00)
$3,645,590.52
3,038,773.66
$606,816.86
394,726 23
$1,001,543.09
$3,970,981.61
5,221,964.54
($1,250,982.93)
609,711.03
($641,271.90)
$550,769.52 Favorable due to an increase in demand for gas, land leasing, and t-hanger rental
78,547 34 Favorable due to turnover in Personnel
$629,316.86
(5,273.77)
$624,043.09
($64,910.39) Unfavorable due to Insurance Reserves collecting less than anticipated revenue
($356,772.54) Unfavorable due to increased insurance costs
($421,682.93)
124,620.03 Favorable due to investment income from larger than anticipated fund balance
($297,062.90)
345,509 00 339,595.00 (5,914.00)
$1,300.00 ($3o1,76.90) , ($302,976 90)
($55,531.00) ($890,421.78) ($834,890.78)
7,500,00 48,613.37 41,113.37 Favorable due to investment income from larger than anticipated fund balance
303,963.00
$1,300.00
$477,038.00
1,249,569.00
$1,726,607.00
893,248.00
$833,359 00
7,500.00
$11,612.40
209,209.12 Favorable revenue is associated with Antenna Site Management
$220,821.52
(1,055,712.30) Unfavorable due to increased spending on equipment repairs and maintenence associated
with the upgrade and repair of the 006Mhz communication system
$477,038 00
1,249,556.00
$1,726,594.00
1,782,125.00
$488,650.40
1,458,765.12
$1,947,415 52
2,837,837.30
68,297.00 508,428.00 440,131 00 Favorable due to Resolution #99141 authorizing upgrade of communications system
_. $20,266 00 _($3313a141) (;353,646.41)
DEPARTMENT OF CENTRAL SERVICES
INTERNAL SERVICE FUNDS
FY 1999 YEAR END REPORT
ADOPTED
BUDGET
AMENDED
BUDGET
FY 1999 VARIANCE
ACTUAL FAV/(UNFAV) EXPLANATION OF SIGNIFICANT VARIANCES
;OAKLAND COUNTY INTERNATIONAL AIRPORT 581
OPERATING REVENUE
OPERATING EXPENSE
OPERATING INCOME (LOSS)
NON-OPERATING REVENUE(EXPENSE)
NET INCOME (LOSS)
MOTOR POOL 661
OPERATING REVENUE
OPERATING EXPENSES
OPERATING INCOME (LOSS)
NON-OPERATING REVENUE(EXPENSE)
NET INCOME(LOSS) BEFORE OPERATING
TRANSFERS
OPERATING TRANSFERS IN
NET INCOME (LOSS)
IRA= COMMUNICATIONS 660
OPERATING REVENUES - OUTSIDE
OPERATING REVENUES - INSIDE
TOTAL OPERATING REVENUE
OPERATING EXPENSES
OPERATING INCOME (LOSS)
NON-OPERATING REVENUE(EXPENSE)
NET1NCOME(LOSS) BEFORE OPERATING
TRANSFERS
OPERATING TRANSFERS IN
NET INCOME (LOSS)
$840,859.00 ($48,031 00) ($841,808.41) ($793,777.41)
59,627.00
_ $900,486,..00
tIN
$21,470,885 00
$862.016.00
$200,000.00
$54,000.00
($2,350,000.00)
($1,233,984.00)
$21,470,885.00
$862,016 00
$200,000.00
$54,000.00
($2,350,000.00)
($1,233,984.00)
$20,019,136.00
$557,027.00
$220,725.00
$54,000,00
($2,350,000.00)
($1,518,248.00)
OPERA TING EXPENSES $1,451,749.00 t ay. due to position vac. & turnover. tower OT, lower sublet repairs, elect, and gas util.,& lower supplies usage.
Partially offset by higher Internal Svcs: computer oper., telephones, and leased veh.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
NON-OPERATING REVENUE/(EXPENSE)
OPERATING TRANSFERS IN
OPERATING TRANSFERS (OUT)
NET REVENUES OVER(UNDER)
EXPENSES
($304,989.00)
$20,725.00 Fay, due to higher invested assets generating higher income.
$0.00
$0.00
($284,264.00)
$107,562.00
$107,562.00
$0.00
$107,562.00
$107,562.00
$000
$113,229.00
$108,103.00
$5,126.00
'PONTIAC MARKET (261)
OPERATING REVENUES - OUTSIDE
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
OPERATING TRANSFERS IN
OPERATING TRANSFERS (OUT)
$5,667.00 Fay. variance due to increases in stall rental and annual rent revenue.
($541.00) Untav. valiance due to increase in employee overtime hours worked.
$5,126.00
NET REVENUES OVER(UNDER)
EXPENSES $0.00 $5,126.00 $5,126.00 $0.00
DEPARTMENT OF FACILITIES MANAGEMENT
INTERNAL SERVICE FUNDS
1999 YEAR END REPORT
1999
ACTUAL
ADOPTED
BUDGET
FACILITIES MAINTENANCE & OPERATIONS (631)
AMENDED
BUDGET
VARIANCE
FAW(UNFAV) COMMENTS
OPERATING REVENUES:
Outside Revenue
Inside Revenue
$906,122.00
21,426,779.00
$906,122.00
21,426,779.00
$755,947.00
19,820,216.00
($150,175.00)
(1,606,563.00) Main, Dept Charges budget realigned, & Special Contracts cost now direct charged to projects
Total Revenue $22,332,901.00 $22,332,901.00 $20,576,163.00 ($1,756,738.00)
12(01/9909:37 AM 1 FMOPORE.INK4t
Information Technology - Operations (636)
OPERATING REVENUES:
Outside
Inside
Prior Years Balance
ADOPTED AMENDED
BUDGET BUDGET
2.173,161.00 1,684,209 00
15,581,104.00 18,017,430.00
1,542,307 00 1,542,307 00
FY 1999
YEAR END
ACTUAL
2,035,092 85
19,508,258.21
1,542,307.00
OPERATING TRANSFERS IN 155,808.00 5,804,639.00
19,452,380.00 27,048,585.00 Total
OPERATING EXPENSES
OPERATING TRANSFERS (00 t)
OPERATING INCOME (LOSS)
Information Technology - In-Car Terminals (637)
OPERATING REVENUES:
Outside
Inside
OPERATING TRANSFERS IN
Total
OPERATING EXPENSES
OPERATING TRANSFERS (OUT)
OPERATING INCOME (LOSS)
FUND EQUITY 10/31198
RESIDUAL EQUITY TRANSFER OUT
Information Technology - CLEMIS (635)
OPERATING REVENUES'
Outside
Inside
OPERATING TRANSFERS IN
Total
OPERATING EXPENSES
OPERATING INCOME (LOSS)
FUND EQUITY 10131/98
RESIDUAL EQUITY TRANSFER IN
22,458,872.32
626,785.74
252,692.77
60,686.00
44,750.00
358,128.77
108,742.70
0.00
1,380,095.20
(1,629,481.27)
0 00
358,007 53
1,435,000.00
2,700,000.00
4,493,007.53
1,582,888 29
2,910,119.24
748,617.35
1,629,481.27
5,288,217.86
19.452,380.00 21,422,499.00
0.00
0.00 5,626,086 00
211,652 00
65,671 00
44,750.00
322,073.00
162,318.00
0.00
159,755.00
281,153.00
1,435,000.00
2,700,000.00
4,416,153.00
2,931,916 00
1,484,237.00
211,652.00
60,686.00
272,338.00
157,333.00
0.00
281,153 00
1,435,000.00
1,716,153.00
1,716,153.00
0 00
115,005.00
OAKLAND COUNTY INTERNAL SERVICES
INFORMATION TECHNOLOGY
FY99 YEAR END REPORT
VARIANCE
FAVi(UNFAV)
Total Fund:
350,883 85 - Fav. due to revised Equalization User Rate Structure
1,490,828 21 - (Unfav) due to decrease of Information Technology User Rate Structure
0.00 - Offset of I.T. fund balance to balance I.T. budget
(5,804,639 00)- Data Warehouse Res. #97136, $155,808---Transfer positions from Comm. & Econ
Dev. to Disc Res *98309, $81,690-- Enhancements to Equal & Tax Billing Sys Res.
Res. *98242, $552,500. Res. #99005 Med. Examiner Case Mgmt Sys. $279,115.,
Res. #99123 unfunded state mandates $693,005 , $99141 DTRF Imaging loan payoff
52,671,100., *99140 Man/Wan 51,533,721,09141 GIS $182,000
$5,852 Law Library SCSI CD Drives
(1,036,373 32)- Professional Services unfav due to Y2K contractors
- Software unfav due to replacement of non-compliant pc suites
0.00
(4,999,300 26)
Total Fund:
41,040.77
(4,985.00)-
0.00 - Sheriff's Dept. Contract with Addison, Highland,Springtield, Orion, Oakland & R.O. Twp.
36,055.77 - Revenue's Fay due to Income from Investments
53,575.30 - Fax due to minimum operating expenses
0 00
89,631.07
The MDT Fund was closed into the CLEMIS Fund after third quarter ending 6-30-99
Total Fund:
76,854.53 - CLEMIS Outside Operations Fay due to (3) additional outside customers
0.00 Sheriff Dept. Contracted Services of $27,000, plus County Countribution of 1,408,000
0.00 - E-911 call taking equipment
76,854.53
1,349,027.7 I - Fay. due to minimum operating expenses
1,425,882 24
The MDT Fund was closed into the CLEMIS Fund after third quarter ending 6-30-99
COMMENTS
23,085,658.06 (3,962,926 94)
2 Prepared by Fiscal Services, Linda Pearson 1 1I/10/99
OAKLAND COUNTY INTERNAL SERVICES
INFORMATION TECHNOLOGY
FY99 YEAR END REPORT
FY 1999
ADOPTED AMENDED YEAR END VARIANCE
BUDGET BUDGET ACTUAL FAVALINFAV) COMMENTS
Information Technology - Telephone Communications (675)
OPERATING REVENUES Total Fund:
Outside 2,524,212.00 1,527,803.00 1,096,583.36 (431,219.64)- (Unfav) due to over-stated appropriation
Inside 1,527,803.00 2,524,212.00 2,791,372.67 267,160.67
OPERATING TRANSFERS IN 890,000.00 890.000 00 Future PBX equipment
Total 4,052,015 00 4,052,015.00 4,777,956 03
OPERATING EXPENSES 3.582,54000 4,117,540 00 3,758,934 31
OPERATING TRANSFERS (OUT) (535,000 00)
OPERATING INCOME (LOSS) (65,525 00) (65,525.00) 1,019,021 72
725,941.03 -
358,605.69 - Fav. due to minimum operating expenses
0 00
1,084,546 72
Prepared by Fiscal Services, Linda Pearson 2 11110199
TOTAL
384.279.33
$ 2,449,949.30
COUNTY OF OAKLAND
DETAIL OF NON-DEPARTMENTAL SUNDRY REVENUE
FOR THE TWELVE-MONTH PERIOD ENDED SEPTEMBER 30, 1999
Refund of prior years expenditures:
Write-off of general fund liability set up for
Michigan Tax Tribunal Appeals 1,900,000.00
Correction of payroll posting errors in 1998 64.775.23
Refund of pior years attorney fees incurred
in the Orion Township incinerator lawsuit 57,464.00
Write-off of 1998 accrual of Automation Alley
estimated costs 21,000.00
Close unexpended balances of work projects
from prior years into the general fund. 16,464.49
Miscellaneous 5,966.25
2,065,669.97
Sundry revenue:
Prior years checks cancelled 158,233.14
Miscellaneous 108,110.97
Interest and Penalty 45,992.30
Interest on Investments 32,622.73
Refunds 14,494.34
Sale of Equipment 10,466.00
NSF Check Fees 9,654.16
Employee Reimbursement of Compensation 4,003.10
Reimbursement of Telephone Communications 354.59
Garnishment Fees _ 348.00
COUNTY OF OAKLAND
DETAIL OF NON-DEPARTMENTAL SUNDRY EXPENDITURES
FOR THE TWELVE MONTHS ENDED SEPTEMBER 30, 1999
1998 Grant costs not recorded until 1999 $ 173,908.66
Reinstatement of prior years
cancelled checks 32,042.43
Oxford Twp. 911 reimbursement 30,000.00
1998 Bank charges not recorded
until 1999 15,890.54
Ambulance 9,649.00
Refund prior years revenue 5,131.18
Insurance surety bonds 1,350.00
Miscellaneous 1,992.25
GFOA application for 1998 CAFR award 1,045.00
Fees/Per Diem 284.00
Bank Charges 276.00
Boundry Commission 274.09
TOTAL $ 271.843.06
TOTAL 942 $1,921,218.60
Nancy R. Wagner
Reimbursement
1200 N Telegraph Road
Pontiac, Michigan 48343
te1:248-858-1459 41' fax:248-975-4288
Interoffice
MEMORANDUM
to:
CC:
from:
re:
date:
Linda Spiekerman-Harvey, Reimbursement
Tim Soave, Fiscal Services
Claudia Martell°, Reimbursement
Nancy R Wagner, Reimbursement
Inmate Waived Report
October 22, 1999
Submitted for your review is the updated Inmate Report for 1999 for inclusion in the
Quarterly Financial Forecast.
Amounts Amount Waived
October 98 009421 CZ 84 $ 167,191.00
November 98 010222 CZ 57 $ 122,227.00
December 98 010895 CZ 85 $ 217,171.00
January 99 011586 CZ 80 $ 159,747.00
February 99 012242 CZ 73 $ 108,440.40
March 99 012902 CZ 83 $203,842.60
April 99 013723 CZ 79 $ 144,864.00
May 99 014435 CZ 81 $ 146,868.80
June 99 015057 CZ 69 $ 141,613.00
July 99 015761 CZ 89 $ 197,847.80
August 99 016476 CZ 96 $ 171,313.00
September 99 017239 CZ 66 $ 140,093.00
From the desk of
$2,000
$ 200
$2.500
$4,700
Sin
Michael J. Bouc
Sheriff
COUNTY OF OAKLAND
OFFICE OF THE SHERIFF
MICHAEL J. BOUCHARD
September 27, 1999
Thomas Ott, Manager
Fiscal Services
Department of Management & Budget
Oakland County
RE: Donation of Exercise Equipment
Dear Mr. Ott:
Per the direction of the County Gift Donation policy, I am forwarding to you a list and estimated
value of exercise equipment that Fitness USA, Inc donated to the Oakland County Sheriff
Department. This equipment was donated for the purpose of having an exercise area for deputies
to improve there health. The equipment is located in the basement of the main jail.
Paramount Equipment:
Multi Cable Station
Hyper Extension Bench
Life Cycle
Elect. Cycle
Total
Please let me know if you need any further information.
1201 N Telegraph Rd * Pontiac, Michigan 48341-1044 * (248) 858-5008
V.Xgft-o4.4e
Michael J. Bouchard
Sheriff
COUNTY OF OAKLAND
OFFICE OF THE SHERIFF
MICHAEL J. BOUCHARD
September 27, 1999
Thomas Ott, Manager
Fiscal Services
Department of Management & Budget
Oakland County
RE: Donation of Exercise Equipment
Dear Mr. Ott:
Per the direction of the County Gift Donation policy, I am forwarding to you a list and estimated
value of exercise equipment that Guardian Industries (Palace of Auburn Hills) donated to the
Oakland County Sheriff Department. This equipment was donated for the purpose of having an
exercise area for deputies to improve there health. The equipment is located in the basement of
the main jail.
Nautilus Equipment:
Double Chest Bench Press $1,500
Overhead Press $1,000
Pull Over $1,000
Leg Curl $1,000
Leg Extension $1,000
Lower Back Extension $1,000
Multi Triceps $1,000
Compound Rowing $ 500
Other:
Dumb Bells $1.200
Total
Please let me know if you need any further information.
$9,200
1201 N Telegraph Rd * Pontiac, Michigan 48341-1044 * (2481 858-5008
GIS PROGRAM BUDGET APPROPRIATION
22-Nov-99
Program Area Acct Number Item k. GIS Fund Total , ,
,
Data Automation if - 434172- '36100-334g. Spring 2000 Orthophotos $ 1,900,000.00 $ 1,900,000.00
Il -221-600 - f1/642-33w Historical Aerial Scanning $ 130,000.00 $ 130.000.00
'GIS Software It- 43417 z-1.61:05- 3 3qg New ESRI Modules ' $ 65,000.00 $ 65,000.00 '
GIS Application Development . '
/
New Application Development $ 100,00000 $ 100,000.00
GIS Consulting Services GIS Consulting
_
$ 100,000.00 $ 100,000.00
Total: $ 2,295,000.00
GIS Utility Strategic Plan - November 8. 1999
Oakland County GIS Utility Strategic Plan
1.0 INTRODUCTION
The Oakland County GIS Utility Strategic Plan is a business plan that will be used to document
program missions, goals and supporting objectives. This plan is a living document, which
reflects new service delivery models, application priorities and changes in technology.
In October of 1996, the first GIS Strategic Plan was drafted. The intent of that Plan was to
document and guide the selection of a GIS software platform and assist in base map
development. The 1996 Plan documented early GIS initiatives and established a framework for
these initial development steps. In addition to the 1996 Plan, a Strategic Plan was developed in
1998. It further facilitated GIS implementation and conveyed a vision for the future. The
initiatives, documented as a part of the 1998 Plan, will be used to benchmark the progress of the
County's GIS program.
In some cases throughout this document, references will be made to earlier strategic plan
documents. The 1999 GIS Utility Strategic Plan will continue to build on these earlier efforts and
remain flexible enough to address enterprise implementation issues and the evolving GIS Utility,
1.1 What is the GIS Utility?
At the heart of Oakland County's enterprise GIS implementation is a central service group called
the GIS Utility. The GIS Utility performs GIS services on behalf of the entire enterprise and
coordinates the efforts of many diverse agencies and cities, villages and townships (CVTs). The
GIS Utility serves as a core group of service-oriented individuals dedicated to providing
expertise, support and assistance to participating agencies and the general public. The GIS Utility
serves as a mechanism to improve GIS technology and its relationship to daily business
functions.
With a focus on providing GIS services, the GIS Utility is an ENABLING organization that
establishes technical standards through consensus and facilitates GIS education thiough
"technology transfer". It serves as a leader in advancing the automation and modernization of
land administration practices and leveraging existing "location-based" projects to maximize their
use across participating agencies and CVTs. In addition to being a mechanism to improve
"location-based" data management, the GIS Utility facilitates strategic decision-making, and
leverages existing GIS expertise in one or more participating organizations.
Under strong leadership and technical resources, the GIS Utility provides several key services on
behalf of the program. When performed centrally, those services eliminate duplication and
promote the development of agency-specific systems.
GS Utility Strategic Plan - November 8, 1999
Typically, the GIS Utility provides the following services:
• Enterprise spatial data development, management. support access.
• Technology coordination, consulting and implementation.
• Application development and support.
• Spatial data design, automation and documentation.
• Strategic planning and system integration planning.
• Technology training and support.
Within the County. the GIS Utility currently is working with the following agencies:
• Planning & Economic Development Services (PEDS).
• Health Division.
• Drain Commissioner's Office.
• Road Commission.
• Register of Deeds Office (ROD).
• Equalization Division.
• Court & Law Enforcement Management Information System (CLEMIS).
• Parks Department,
• MSU Extension/Oakland County.
• Oakland County International Airport.
As implementation continues, other agencies and programs, such as the Treasurer's Office,
Emergency Management and Facilities Management will begin to benefit from GIS
implementation and will be using the services provided by the GIS Utility.
To facilitate major GIS or technology initiatives in a given agency, Project Implementation Plans
are developed. They are a result of the strategic planning process and extensive onsite interviews,
past reports, and discussions with specific agency representatives. The Implementation Plans, in
conjunction with the GIS Strategic Plan, facilitate technology development in a specific agency.
The components of these plans enable successful technology implementation and promote long-
term sustainability. As implementation continues in a specific agency, more detailed task lists
are documented to manage specific initiatives. The Plans leverage enterprise-wide objectives
found in the Strategic Plan to accomplish a series of agency-specific initiatives. The plans are
supplemented as implementation continues and specific goals/initiatives have been meet.
At the local level, the GIS Utility is actively assisting the CVTs with GIS development through a
concept called "vertical integration-. By providing parcel data, software and technical expertise
from a County or "central" position, local CVTs are able to avoid up-front costs and develop
cost-effective GIS programs. The County is providing parcel data, digital orthophototzraphy, road
1,4
GIS Utility Strategic Plan. November 3. 1999
centerline/address ramie data to CVTs along with access to technology and the hope is for the
CVTs to build upon this strong base. The CVTs will continue to benefit from. and play an active
role in, the development of the County's enterprise GIS program.
A more detailed organizational discussion and supporting diagram can be found in Section 2 of
the 1998 Strategic Plan. In addition, several fundamental enterprise implementation concepts are
described in the 1998 Strategic Plan.
2.0 GIS PROGRAM ACCOMPLISHMENTS AND STATUS
In the 1998 Strategic Plan, several GIS initiatives were defined to carry out the GIS program goal
and objectives. As a point of reference for the 1999 Plan, each initiative from the previous plan
and its status has been provided below.
Corporate Data Development Initiatives:
1. Parcel automation is in progress and is expected to be completed by September of 1999.
Status: Approximately 400,000 parcels have been automated as of October 1, 1999. In
concert with the completion of the remonumentation program (October 1999), parcel
automation will be finished. The expected completion date is March of 2000.
2. The Oakland County Enterprise Parcel Manual was released in March of 1998.
Institutional adjustments, workflow changes, data standards, conversion procedures and
other issues were documented and published. Updates to the Manual will be incorporated
as implementation continues.
Status: The Parcel Manual continues to be a source of reference for those individuals
responsible for parcel management. Incremental updates have occurred over the course
of the year and published on the web once completed. A major revision will occur in the
fall of 1999 to accommodate the maintenance of the County's road centerline coverage.
3. A third party parcel management software was selected and will be implemented in
August of 1998.
Status: Parcel Mapper, a third party parcel management software package developed by
Southern Digital Services, was implemented in the RODs Office and Equalization
Division. Application enhancements have been documented and submitted to the vendor
for incorporation in the next software release of Parcel Mapper.
Efforts are underway to track historical parcel transactions and provide date specific
historical coverages.
GIS Utility Strategic Plan - November S. 1999
Status: As part of the GIS Utility's parcel management toolkit, historical parcel
transactions are being posted prior to the commitment of new parcel splits/combinations.
5. A Digital Submission Requirement was adopted by the Oakland County . Plat Board and
implemented in July. of 1998.
Status: The Digital Submission Requirement is still being provided to surveyors and
engineers doing business with the RODs Office.
6. A high-flight digital orthophoto project was flown in the spring of 1997 and delivered in
the fall. Efforts are being made to explore the use of color orthophotos, satellite imagery
and compression utilities.
Status: A RFP was developed for a spring 2000 low-flight digital orthophotography
project. In addition to black-white photography, color infrared orthophotography will be
collected. Mr. SID compression utilities have been implemented to reduce the size of the
raster files stored on the GIS server and transported over the network.
7. A road centerline / address range data design and conflation RFP has been drafted and
released in July of 1998.
Status: ASI/MSE was selected to perform the conflation and development of a road
centerline / address range data set. ASI/MSE delivered the final data in April of 1999 and
the GIS Utility has been cleansing this information and adding CLEMIS public safety
attributes.
8. Efforts are underway to work with the Bureau of Land Management and Forest Service to
document and develop object-oriented COGO management functionality.
Status: The Bureau of Land Management, Forest Service and Oakland County have
developed a parcel consortium that has been working with ESR1 to develop object-
oriented parcel management functionality. High-level use cases that support object-
oriented programming have been developed by the consortium and are currently being
reviewed by ESRI. In addition to the parcel management functionality, the Federal
Geographic Data Committee (FGDC) Cadastral Data Content Standard and the FGDC
Metadata Content Standard will be migrated to an object-oriented database. Access to
upper level ESRI officials through this project has enabled the County to become an
ArcInfo 8.x beta site. Continued participation in this effort will allow the County to test
and evaluate new ESRI software modules prior to their general release.
9. Nletadata is being documented and plans are being made to make this information
available over the Internet.
4
GIS Utility Strategic Plan - November 8. 1999
Status: The GIS Utility requires FGDC compliant metadata of every outsourced data
automation/conversion contract. The information is documented in XML format and will
be positioned on the County's GIS website later this year.
Business Process Re-engineering Initiatives:
1. The Enterprise Parcel Manual documents the parcel maintenance re-engineering efforts
that are occurring in the Register of Deeds Office and the Equalization Division.
Status: As parcel management in the ESRI environment continues, new opportunities to
re-engineer maintenance workflow is evaluated. The Enterprise Parcel Manual will
continue to serve as a reference manual for those workflow requirements.
2. Efforts are underway to develop an enterprise infrastructure management re-engineering
manual.
Status: As part of the GIS Utility's work with the Drain Commissioner's, a GIS Project
Implementation Plan was developed. This Plan identified several functional areas (data,
technology, applications and organization) where the Drain Commission could begin
advancing GIS. The foundational work done as part of the Plan's development has also
served as a model for other GIS implementations throughout the County.
3. Efforts are underway to evaluate and re-engineer existing services being provided in
Planning & Economic Development Services Division's "One-Stop Shop".
Status: The PEDS Division, working in conjunction with the GIS Utility and Data
Warehouse Team has developed a "One-Stop Shop-Decision Support Center" Draft
Implementation Plan. Efforts are underway to identify an area where a "proof-of-
concept" can be illustrated. In support of that effort, the GIS Utility applied for an ESRI
Livable Communities Public Access Grant. This grant will provide the ESRI software
necessary to enhance the existing parcel kiosk.
4. The Road Commission is in the process of developing a GIS Strategic Plan that will be
used to guide the initial implementation.
Status: The Road Commission's GIS Strategic Plan was not completed. In lieu of
completing that plan, representatives from the Road Commission have been
autonomously developing individual GIS projects.
5. Efforts are underway to pilot and evaluate GPS/GIS integration in the Environmental
Health Division and to re-engineer existing water well and septic permitting workflow ..
61 5
GIS Utility Strategic Plan - November 3, 1999
Status: The Type II Well GPS pilot program was completed during the summer of 1999.
In addition to the Type E wells, the Environmental Health Division is completing the
conversion of its domestic well database and evaluating new permitting workflow.
Departmental GIS Development.'
1. Using enterprise data sets as a reference, the following agencies are developing data sets:
Parks, Planning & Economic Development Services Division, Register of Deeds, Health
Division, Aviation, Drain Commissioner's Office and Equalization Division.
Status: Those agencies mentioned above have used enterprise data sets as a reference for
the following datasets: parkland development, local CVT zoning, environmentally
sensitive areas, historic preservation areas, downtown development areas, historical aerial
orthophotos, wells, septic, sanitary sewers, storm sewers, pressure water, assessment
neighborhoods, airport safety zones, noise mitigation areas and departure critical zones.
2. Develop where appropriate, data standards and quality assurance procedures.
Status: For each dataset mentioned above, the appropriate data designs and quality
assurance procedures were developed to ensure data integrity. Appropriate data designs
are being published on the County's GIS website.
3. Metadata is being documented and plans are being made to make this information
available over the Internet.
Status: The GIS Utility requires FGDC compliant metadata of every outsourced data
automation/conversion contract. The information is documented in XML format and will
be positioned on the County's GIS website in early 2000.
Application Development:
1. Work with MSU Extension to develop and implement a GIS based Gypsy Moth
Suppression Program.
Status: The MSU Extension Gypsy Moth Suppression Application was completed in the
March of 1999. It was widely used as part of the 1999 Spray Program.
2. Work with the Data Warehouse team to link the data warehouse to the parcel fabric.
Status: The GIS Utility and Data Warehouse teams have developed procedures to link
the ArcView parcel shapefiles to the assessment information contained in the Data
Warehouse. As a result of that process, the local CVTs now receive this information
through quarterly updates.
'10 6
GIS Utility Strategic Plan • November S. 1999
Work with Aviation and the Data Warehouse team to support a specific noise reduction
grant application.
Status: Specific GIS applications have been developed to assist the Oakland County
International Airport with noise complaint tracking and tall structure monitoring. Those
applications will be installed at the airport in November of 1999.
4. Work with the Equalization Division on an application and database design for automated
and historical Sidwell Number assignment.
Status: A database design for historical Sidwell Number assignment has been developed
to support data automation in the Equalization Land Description Section. Once,
automated, a specific application must be developed to integrate this into the parcel
management workflow.
Education and Training:
I. Conduct ArcInfo and/or ArcView training every calendar quarter at a minimum.
Status: The County has developed an Intro to ArcView class and has classes scheduled
twice a month. Over 100 people have signed up for the classes that are scheduled
currently through March of 2000. In addition to the Intro to Arc View class, the GIS
Utility is working on a continuing education curriculum for its current GIS users.
2. Work with Lawrence Tech University to develop training facilities and a GIS curriculum.
Status: The County ceased working with Lawrence Tech University (LTU) when they
failed to gain experience in ESRI's software products.
Hardware and Technical Architecture:
I. Leverage the use of Intergraph NT workstations.
Status: As part of Y2K upgrades, Intergraph NT workstations will be leveraged for GIS
implementation.
2. Completely migrate to a Windows NT Server environment in late summer of 1998. At
the same time, physically separate and isolate access to production data from data used
for query and analysis.
Status: A complete migration to a Windows NT server environment was completed in
the spring of 1999. At that time, production data was positioned on a single "production"
server in ArcLibrarian to support parcel maintenance. On a second "publishing" server,
GIS data was positioned and optimized for querying and analysis.
1 7
GIS Utility Straws lie Plan - November S. (999
Promote Arc View software as the preferred software tool for high-end spatial querying
and analysis.
Status: The GIS Utility continues to distribute Arc View to County agencies and local
CVTs. To date. more than 150 copies have been distributed as part of the County's
master purchase agreement. In addition to the distribution of software, the GIS Utility is
developing agency-specific applications (ex. MSU Gypsy Moth and Oakland County
International Airport) on top of Arc View's core software functionality.
4. Work with Ayres Associates to implement "Mr. SIDS" compression utilities for access to
digital orthophotos.
Status: In the fall of 1998, the County compressed its 1997 digital orthophotography
using the Mr. SID technology. In doing so, it took what was once a 13 GB database and
reduced it to almost 600 MB.
5. Evaluate ESRI's Spatial Data Engine (SDE) software and it's application in Oakland
County during the winter of 1998.
Status: In the spring of 1999, the GIS Utility evaluated the use of ESRI's SDE software to
distribute parcel data across the County's Local Area Network (LAN). The software tests
provided valuable system design input and will be used to determine the final SDE
implementation plan in the spring of 2000.
3.0 STRATEGIC GIS PROGRAM MISSION
The strategic program mission has been developed, and is intended to provide, a high-level
guiding principle for the entire GIS program. GIS program goals and supporting objectives have
also been developed to effectuate this mission and guide future development.
3.1 Statement of GIS Program Measures
The following items have been identified as GIS program measures and will be used to gauge the
successfulness of a specific GIS project or implementation:
1. Increased productivity.
2. More efficient use of resources.
3. Provision of additional services.
4. Propagate more accurate and informed decision-making.
5. Increased access and dissemination of digital information.
GIS Utility Strategic Plan - November 8, 1999
3.2 Critical Success Factors
Critical success factors are those attributes, assets, or skills that will be needed for the successful
implementation of an enterprise GIS. The critical success factors are:
1. County Executive, Board of Commissioners. and other elected officials support and
commitment.
2. Commitment of, and support from, an enterprise GIS program "champion".
3. Inculcation of GIS into location-based workflow.
4. Coordinated intra-agency involvement with the GIS program.
5. An openness to new technology and improved workflow.
6. Effective and applicable research and development,
7. Continuous education and training of County GIS staff.
8. The continued promotion of centralized and coordinated public access to location-based
data through the "One Stop Shop".
9. All location-based data will be shared across County agencies, except where security and
confidentiality warrants otherwise.
10. All County agencies will be treated as equal and important partners of the GIS Utility.
11. Continuous development and support of information technology infrastructure
(networking, relational database (RDBMS), distributed computing, etc.).
3.3 GIS Mission
To develop an enterprise GIS program that will allow Oakland County and its CVTs to re-
engineer existing workflow and create a more efficient and effective operating government.
3.4 GIS Program Goals
The following GIS program goals represent broad statements of desired accomplishments:
1. To use the successful development of the enterprise GIS program to promote Oakland
County as an information technology center in the United States.
2. To enable. through vertical integration, GIS development in local CVTs.
9 13
GIS Utility Strategic Plan - November 8. 1999
3. To elevate the expertise of the GIS user community and support staff.
4. To continuously improve the content and accuracy of all location-based data sets.
5. To maintain a responsive GIS technology service delivery model.
6. To re-engineer business processes through the inculcation of GIS technology into the
workflow of internal County agencies.
7. To leverage developing technologies (imaging, Internet, digital photography, field
collection, distributed computing, etc.) to enhance land records management in Oakland
County.
3.5 GIS Program Objectives
The following GIS program objectives set forth a specific approach or position that can be used
to implement a GIS program goal:
I. To participate in regional efforts, professional conferences and other professional
opportunities.
1 To further the development of GIS-based intemet technologies and use of the County's
OakNET for the dissemination of information to local CVTs.
3. To enable GIS development in local CVTs through the provision of parcel information,
ArcView software and GIS support services.
4. To provide core GIS services through "vertical integration" and offset costs that would
otherwise encumber local CVTs.
5. To promote GIS development in local CVTs and County agencies through data standards
and centrally administered functions.
6. To further the technical development of the System Area Specialists through an extensive
software training and GIS mentoring program.
7. To encourage technology transfer directly through the technical user groups, training,
Internet discussion lists and the County's GIS homepage.
8. To empower GIS System Area Specialists to develop GIS applications and data sets
within their own agencies.
9. To develop and assist in the standardization of the County's enterprise-wide activities
(data sets, functions and technology).
10
GIS Utility Strategic Plan - November S. 1999
10. To cooperate, where feasible, with state and federal efforts in the development of
standards and applications.
11. To coordinate and integrate computer infrastructure improvements and technical resource
deployment.
12. To promote the use of Global Positioning Systems (GPS) as a preferred data collection
method.
13. To leverage existing ArcInfo and Arc View development code and avoid duplicative
application development efforts among local governments and County agencies.
3.6 GIS Initiatives
Initiatives are projects or sub-projects that are defined and planned for the purpose of carrying
out a goal and objectives. The list below restates the GIS program goals and provides a high
level outline of current GIS initiatives.
Goal: To use the successful development of the enterprise GIS program to promote Oakland
County as an information technology center in the United States.
1. Participate as officers and directors in national and statewide GIS organizations like
URISA and IMAGIN and increase the exposure to Oakland County's enterprise GIS
program.
2. Pursue awards recognizing the achievements of Oakland County's enterprise GIS
program.
3. Explore cutting edge GIS applications like virtual reality, historic aerial rectification and
distributed GIS integration.
Goal: To enable, through vertical integration, GIS development in local CVTs.
1. Provide enterprise data sets (parcels, digital orthophotography, road centerline/address
range and other information) to local CVTs for use in their own GIS efforts.
2. Distribute ESRI's ArcView GIS software to local CVTs for use in their own (MS efforts.
Upon completion of the OalcNET, develop a GIS application that will provide access to
current GIS data and allow local CVTs to easily perform the most commonly used GIS
functions.
4. Explore the integration of other (MS data sets (local zoning, local master plan, well,
septic, and infrastructure) through common data standards.
7C 11
GIS Utility Strategic Plan - November S. 1999
Goal: To elevate the expertise of the GIS user community and support staff
1. Continue to conduct an Intro to ArcView GIS training class, that is targeted at County
and CVT personnel who need a working understanding of these tools. twice a month at
Oakland County's Information Technology Building.
Formulate a continuing education survey that will compile the needs of current GIS users
and provide long-term training opportunities. Upon completion of the survey, a GIS
Training Plan will be finalized for the calendar year 2000.
3. Sponsor and organize the formation of a Michigan ESRI User Group.
4. Continue to provide educational workshops (ex. Intro to ArcInfo 8.0) to elevate the
exposure to new GIS technology.
5. Promote GIS expertise in County agencies through technology transfer, mentoring and
education.
6. Work with the Oakland County Personnel Department on the creation of more specific
GIS job classifications (GIS Mapping Technician and GIS Analyst).
Goal: To continuously improve the content and accuracy of all location-based data sets.
1. Complete the automation of parcel data by March of 2000.
2. Increase the content and spatial accuracy of the County's parcel data set through
enterprise management.
3. Complete the development of a low-flight black and white and high-flight color IR digital
orthophotography project by December of 2000.
4. Complete the quality assurance and attributing of the road centerline /address range
coverage by June of 2000.
5. Complete the development of Court and Law Enforcement Management Information
System (CLEMIS) public service boundaries by June of 2000.
6. Update the content and currency of Oakland County's Enterprise Parcel Manual to
include road centerline management procedures and updated parcel management
procedures.
7. Work with the Environmental Health Division to complete the automation of a domestic
well data set.
-74 12
GIS Utility Strategic Plan - November 8. 1999
8. Work with the Drain Commissioner's Office to outsource the development of sanitary.
storm and pressure water data sets.
9. Complete the development of the County's ArcInfo parcel data model.
10. Work with other participating County agencies to create an Address Standards
Committee that standardizes the format and definition of addresses.
11. Continue to support PEDS with the orthorectification of historical aerial photography.
12. Continue to support the development of agency-specific GIS data sets through standards
and proper documentation.
13. Increase the content, accuracy and exposure of spatial metadata.
14. Work with the Register of Deed's Office to enhance the Public Land Survey Section
(PLSS) database.
Goal: To maintain a responsive GIS technology service delivery model.
1. Process requests for service within 48 hours of receiving the request.
2. Provide monthly reports to customers detailing the nature and status of open requests.
3. Maintain and improve, where appropriate, the services provided by the GIS Help Desk.
4. Develop a GIS Utility Service Deliver Policy that supports GIS development in County
agencies and the CVTs.
5. To develop written policy statements that provides guidance to program cooperators and
consistency in development and deployment efforts.
Goal: To re-engineer business processes through the inculcation of GIS technology into the
workflow of internal County agencies.
1. Work with the Equalization Division to complete the implementation of GIS-enabled
assessment management and land administration tools.
Work with the Drain Commission to select a vendor to assist in the implementation of a
turnkey GIS-enabled facilities management system.
3. Work with the Environmental Health Division to improve the permitting process and GIS
integration of well and septic data.
1-71 13
GIS Utility Strategic Plan November 8. 1999
4. Work with CLEMIS to complete the development of a GIS-enabled computer aided
dispatch (CAD) system and crime analysis tool.
5. Work with the Oakland County International Airport to complete the implementation of
GIS-enabled airport management tools.
6. Work with PEDS to further the implementation of the "Decision Support Center".
7. Work with Emergency Management to develop GIS-enabled tools and data sets.
8. Work with CLEMIS to complete the development of a GIS-enabled Fire Records
Management System.
9. Work with PEDS to further the conversion of the County's hardcopy photo lab to a
softcopy photo lab.
Goal: To leverage developing technologies (imaging, Internet, digital photography, field
collection, distributed computing, etc.) to enhance land records management in Oakland
County.
I. Work with the Equalization and Environmental Health Division to assess the use of field-
based computing and data collection.
2. Work with the Equalization Division to integrate the Digital Photography Program into
GIS-enabled analysis.
Work with the Enhanced Access Team to develop an Internet-enabled kiosk that will
provide access to GIS data sets.
4. Work with ESRI to enhance land records management tools in ArcInfo 8.x.
5. Work with ESRI to implement Spatial Data Engine and an Intranet-enabled tool for
querying and/or browsing of GIS data.
6. Work with ERDAS to implement IMAGINE and OrthoBase for historical' rectification
and feature classification applications.
4.0 GIS ORGANIZATIONAL STRUCTURE
The successful implementation of organizational changes will be vital to enterprise
implementation. Adjustments to current staffing requirements in the GIS Utility and the County
agencies must be made to accommodate newly redesigned workflows and additional technical
services. These changes will enable the GIS Utility to continue to bring new and improved
services to the County agencies and CVTs.
14 '1g
Is
GIS (Ailir: Stra:Lyzie Plan - November S. 1999
4.1 GIS Utility Roles
In December of 1997. the Oakland County Board of Commissioners formally established the
GIS Utility inside of the existing Information Technology Systems Development Division. Since
that time, the County has formally created the Information Technology DISC Division and
moved the GIS Utility to the DISC. Current GIS Utility staff provide County agencies and local
CVTs GIS technical support. To date the following roles have been successfully filled:
GIS Utility Administrator - The GIS Utility Administrator role is responsible for the
management, coordination, policies, standards, and outreach of the County's enterprise
(County and CVT) GIS program. It is responsible for the formulation of business
strategies that incorporate geographic information and improve the County's and CVTs
overall operating efficiency. The role is responsible for the development of geographic
information plans, associated policies, geographic technology investments and agency-
wide information products and technology requirements. The Administrator promotes
enterprise GIS efforts through external representation in. and presentations to, national,
state and local organizations. Furthermore, it also supports the creation and management
(content, standards, quality, geographic reference, integration, interoperability and
documentation) of enterprise geographic information and other geographic data
resources.
Application Analyst/Internal Support - The Application Analyst/Internal Support role
assists County agencies and CVTs with the development of ArcInfo AML applications
and scripts. The role also supports ArcView applications, debugs new software modules,
maintains the County's ArcLibrarian database and assists with the administration of the
GIS program's hardware, software and networking infrastructure.
GIS User Support Specialist - The GIS User Support Specialist role provides authorized
training, support and help desk functions (ex. technical support, software procedures,
technical user groups, GIS newsletter) to GIS users within County agencies and CVTs. It
actively works to further the development and use of GIS through the communication of
data needs, data transfer requirements, and the implementation of data sets and data
standards. This role further supports GIS development in County agencies and CVTs by
identifying and formulating the needs of GIS applications.
System Administration - The System Administration role manages and administers the
servers, workstations, operating systems, Internet and intranet operations and software
necessary to support GIS implementation. Typical activities include: developing security
measures, user maintenance, installation of upgrades, operating system maintenance and
programming, peripheral management, and licensing arrangements. This role maintains
an open line of con-u-nunication and promotes coordination with other Information
Technology initiatives to ensure compatibility throughout all systems.
GIS Utility Strategic Plan - November 8, 1999
Enterprise Data Technician — This role is responsible for the population and on-going
management of the enterprise data sets (parcels. orthophotos, road centerline/address
range, and other). Typical activities include: enterprise data management and conversion,
quality control and assurance, departmental data automation assistance and coordination
of data distribution. This role maintains an open line of communication and promotes
coordination with other County agencies and CVTs to ensure data integrity and
compatibility throughout the County's enterprise GIS.
In response to current GIS initiatives planned in Section 3.6 of the Strategic Plan and in an effort
to maintain a high-quality service delivery model, two key roles should be formulated in the GIS
Utility.
The first role, a CLEMIS Data Technician, will be vital to the development and completion of
the County's road centerline/address range data. A significant portion of the position's cost will
be offset by making the road centerline/address range data available to the commercial sector
through the County's Enhanced Access Program. Furthermore, costs will be offset by providing
value-added data conversion services to out-county CLEMIS members. The CLEMIS Data
Technician will fill the following role:
CLEMIS Data Technician — This role will be responsible for the population and on-
going management of the CLEMIS data sets (public service boundaries, road
centerline/address data, common place data, fire response data, etc). Typical activities
include: CLEMIS data management and conversion, CAD uploads, quality control and
assurance, out-County data automation and coordination of data distribution. This role
maintains an open line of communication and promotes coordination with the CLEM'S
Team and participating agencies (County, CVT and out-county) to ensure data integrity
and compatibility throughout the program.
The second role, GIS Application Analyst, will assist in the development of advanced GIS
applications that benefit the County agencies and CVTs. The role will work to advance the
County's GIS presence on the Internet through advanced web-based technologies and object-
oriented principles. The GIS Application Analyst will fill the following role:
GIS Application Analyst - This role will be responsible for business function
identification, existing application research and identification, and application design,
development and implementation. Typical activities include: application development in
ESRI's AML. Avenue, MapObjects , Microsoft's Visual Basic or web-enabled
programming languages. This role will be very active with County agencies and CVTs
and will be assisting with application implementation on a daily basis.
I 6
GIS Utility Strate2ic Plan November 8. 1999
6.0 SUMMARY
The Oakland County GIS Utility Strategic Plan is a high-level, business plan that documents a
program mission, goal and supportive objectives and initiatives. As the DISC Division develops,
this plan will become a component of an overall DISC Strategic Plan and cross-references
between the operating groups will be more fully developed.
The GIS Utility will continue to facilitate enterprise GIS development through the development
of common technical and data standards. Facilitated data distribution across jurisdictional
boundaries will also be a major focus of the GIS Utility and Internet technologies will be
leveraged where appropriate.
6.1 Agency Review and Support
As a participating agency in the Oakland County enterprise GIS program, we understand the
importance of the GIS Utility Strategic Plan. By signing below we indicate that we have read the
Strategic Plan and will participate in the implementation of the Oakland County enterprise GIS
program.
Oakland County Drain Commission Oakland County Parks Department
Oakland County Register of Deeds Office Oakland County Equalization Division
Oakland County Health Department Oakland County Information Technology
Oakland County Road Commission Oakland County Aviation
Oakland County MSU Extension Oakland County Planning & Economic
Development Services Division
\SDataqviy Documents\ organizational . str_plan strat_plan_1999_v 2.doc
19