HomeMy WebLinkAboutResolutions - 2002.04.18 - 26696MISCELLANEOUS RESOLUTION #02093 April 18, 2002
BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2002 FIRST QUARTER
FINANCIAL FORECAST AND BUDGET AMENDMENTS
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
WHEREAS Public Act 621 of 1978, the Uniform Budgeting and Accounting
Act for Local Units of Government, provides for adjustments to the adopted
budget; and
WHEREAS in accordance with Oakland County General Appropriations Act
Section 22, which authorizes budget amendments for variances between the
budgeted revenue and actual revenue, and Section 23, which authorizes budget
adjustments for variances between estimated revenue and projected
expenditures, adjustments are required; and
WHEREAS the Fiscal Year (FY) 2002 First Quarter Financial Forecast
Report has identified several variances and budget amendments are
recommended; and
WHEREAS a budget amendment is requested for 52nd District Court Division
I (Novi) and Division III (Rochester Hills) to increase the appropriation in
the amount of $5,500 each for Printing costs to order annual reports, which
can be offset by favorable revenue in Ordinance Fines and Cost; and
WHEREAS an amendment is necessary to transfer the Salaries and Fringe
Benefits appropriation for two (2) User Support Specialists, currently
budgeted in 52nd District Court Division I (Novi), to the 52'd District Court
Administration Division; and
WHEREAS a correction is necessary to transfer appropriation for JIMS
War Room Project operating expenses from various accounts within the 52"cl
District Court, Clerk/Register of Deeds, and Prosecutor to Circuit Court-
Business division; and
WHEREAS Circuit Court Mediation funds of $10,000 previously approved by
MR #00127, were inadvertently omitted as part of the designated funds and, an
amendment is recommended to restore these funds for JIMS training, as
originally intended, transferring funds from the Undesignated Fund Balance GL
account #9901; and
WHEREAS an amendment is requested to transfer the FY 2002 appropriation
for the Sheriff's Aviation program between divisions of the Sheriff's
Department, to more accurately reflect the function of the program, as well
as, establish the Aviation Internal Services Fund revenue and expenditure
appropriations to correspond with the operations of this unit; and
WHEREAS a budget amendment is needed for the Clerk/Register of Deeds to
more accurately reflect the microfilming and reproduction services provided
by Internal Services rather than Contracted Services; and
WHEREAS a budget amendment is requested for Clerk/Elections, to
appropriate funds to complete the project for remodeling the Elections
Division for better efficiencies, costs can be offset by projected
favorability in Mortgage revenues; and
WHEREAS, due to the recent transfer of the Emergency Response Unit from
the Health Fund to the General Fund, an amendment is necessary to transfer an
appropriated encumbrance of $15,572.70, associated with the Emergency
Response Unit, from the Health Fund to the General Fund; and
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote.
WHEREAS funds were encumbered at the close of fiscal year 2001 that are
no longer needed due to the cancellation of purchase orders (Prosecuting
Attorney - $9,500) and payment by Internal Service fund (Facilities
Maintenance & Operations - $97,685) thus making funds available; and
WHEREAS the State payment from the Convention Facility and Liquor Tax
distribution has increased, resulting in a favorable variance; and
WHEREAS one-half of these funds must be used for Substance Abuse
Prevention programs in the Health Division, the remainder may be used to
cover expenditures and revenue shortfalls; and
WHEREAS a budget amendment is necessary to correct the budgeting of a
Fiscal Services position in the Health Fund which should have been budgeted
in the General Fund; and
WHEREAS the appropriation for Community Corrections' Expendable
Equipment Expense was inadvertently budgeted under Fringe Benefits - Dental
and a budget amendment is requested to transfer the funds to the appropriate
account; and
WHEREAS a transfer of the appropriation for Information Technology
Operations expense is necessary due to the reassignment of the Gypsy Moth
Suppression Program from the Department of Public Services to the Department
of Community and Economic Development; and
WHEREAS an amendment is necessary to reallocate funding for rental
payments on the Planning Division's Downtown Design Studio from Professional
Services to Rent; and
WHEREAS the Fiscal Services Division's efforts on behalf of the
Sheriff's Department to collect revenue from the State for diverted felons
has continued to be effective in generating a projected favorable variance;
and
WHEREAS State Court Equity payment for Oakland County is projected to
be unfavorable ($407,544), due to a reduction in fee revenues and state
general fund revenues appropriated to the Court Equity Fund as part of the
State's plan to cover the FY 2002 budget shortfall; and
WHEREAS an additional appropriation is needed for the Circuit Court's
Wraparound Pilot Program to fully fund its obligation as authorized to cover
cost associated with In-Home Child Care; and
WEHREAS the Sheriff's Department anticipates favorability within the
Aviation Unit operations, due to delay in hiring personnel and use of
helicopter, therefore reducing the amount necessary from the General Fund to
cover these costs; and
WHEREAS the FY 2002 Adopted Budget approved the increase in fleet for
two (2) vehicles for the Prosecuting Attorney for criminal investigation
purposes, and budgeted for operating costs, but did not include capital
outlay and therefore an amendment of $31,000 is recommended; and
WHEREAS one (1) General Fund Chief's position in the Central Services
Department was inadvertently omitted from the budget and an amendment is
requested to appropriate funding; and
WHEREAS a budget amendment is requested to appropriate funding for this
position in the Support Services Division under General Fund; and
WHEREAS the Human Services' Healthy Start/Healthy Families program was
abolished as of October 1, 2002, and an amendment is necessary to reduce the
budget to reflect the elimination of this program; and
WHEREAS MSU Cooperative Extension/Natural Sciences Unit is requesting
an appropriation for Recognition Events and Workshops and Meetings, which was
inadvertently omitted during the FY 2002 Budget process even though the
related estimated revenue was included; and
WHEREAS the Medical Examiner's budget is reflecting a negative
appropriation and requires a budget amendment to appropriate funds to cover
the expense; and
WHEREAS amendments are necessary to reflect actual payment of
membership dues for S.E.M.C.O.G. and Traffic Improvement Association; and
WHEREAS due to increased activity, the Non-Departmental Contingency,
Salary Adjustments and Fringe Benefit Adjustments accounts require an
additional appropriation to maintain a positive balance through the remainder
of the fiscal year; and
WHEREAS various divisions are in need of a budget adjustment for
Information Technology Operations and Telephone Communication appropriations,
to correspond with actual usage; and
WHEREAS an amendment is requested to transfer funds from the Non-
Departmental MAN/WAN account to Information Technology to fund OAKNET
expenses; and
WHEREAS indirect cost charges to the Facilities Maintenance and
Operations Fund now include the cost of three (3) M & B - Fiscal Services
accounting positions in the fund and a budget amendment is required to
reflect this change; and
WHEREAS an additional appropriation is necessary to fund Information
Technology - Operations within the Medical Care Facility due to the
additional equipment and work associated with Reimbursement services; and
WHEREAS a budget amendment is requested to reflect on-going
contributions to the local municipalities in the County towards CLEMIS
operations; and
WHEREAS Information Technology is requesting an amendment to
reappropriate several I.T. Reserves from Fund Equity to various projects
currently in progress; and
WHEREAS Miscellaneous Resolutions #99051, #01140, #01159 and #01265
authorized pre-design services, Detroit Edison line relocation,
architect/engineering services, construction management services, and initial
construction costs for the Work Release Facility Project and authorized
transfer of funding from the Building Improvement fund (#401) to the Project
Work Order Fund (#404); and
WHEREAS the Oakland County Building Authority has subsequently issued
Building Authority Bonds for the Work Release Facility Project, as authorized
by Miscellaneous Resolution #01265, and a separate fund has been established
for the project; and
WHEREAS appropriations and expenditures recorded in the Project Work
Order Fund for this project require transfer to the Work Release Facility
Fund (#411) and the Building Improvement Fund requires reimbursement from
bond proceeds; and
WHEREAS MR #02020 established the following "Designated Fund Balance",
for which an appropriation is now requested:
Health Division - Health Satellite
IT - Fire Records Management (County's 75% Contribution)
$ 150,000
$ 250,000;
and
WHEREAS funding in the amount of $10,000 is available for a rate study
for the Drain Commissioner in a Designated Fund Balance (Mainland Drain
Construction).
NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts
the Fiscal Year 2002 First Quarter Financial Forecast.
BE IT FURTHER RESOLVED that the Board authorizes amendments to the FY
2002 Budget as detailed on the attached Schedules.
BE IT FURTHER RESOLVED that funding previously transferred from the
Building Improvement Fund (#401) to the Project Work Order Fund (#404) for
the Work Release Facility Project be reimbursed to the Building Improvement
Fund from Bond proceeds.
BE IT FURTHER RESOLVED that appropriations and expenditures recorded in
the Project Work Order Fund for the Work Release Facility Project be
transferred to the Work Release Facility Fund (#411).
BE IT FURTHER RESOLVED that the FY 2002 Budget be amended, as specified
below, to utilize Designated Fund Balances for Health Satellite (GL account
#9407-006000), Fire Records Management (GL account #9407-061000) and Mainland
Drain Construction (GL account #9407-022000) as detailed below:
Revenue
90-190000-14000-1582 Prior Years Balance $ 410,000
Expenditures
16-261200-72500-3544
61-211001-10000-3348
90-310000-40000-8001
Revenue
8-531003-53001-1701
Expenditure
18-636172-25100-3348
Health-Satellite Centers
Drain - Professional Svcs
Non-Dept - IT Fund Transfer
Total
IT - Transfer In
IT - Professional Svcs
Total
$ 150,000
10,000
250,000
$ 410,000
$ 0
$ 250,000
250,000
$ 0
Chairperson, on behalf of the Finance Committee, I move the adoption of
the foregoing resolution.
FINANCE COMMITTEE
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2002 FIRST QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP) ACTIVITIES
ACCOUNT NUMBER ACCOUNT NAME
FY 2002
AMENDMENT
GF/GP OPERATIONS - SELF BALANCING AMENDMENTS
52nd District Courts
Revenues
32-201100-20001-0753
32-401100-20001-0753
Expenditures
32-201200-20001-2001
32-201200-20001-2074
32-201200-20001-3324
32-101200-20001-2001
32-101200-20001-2074
32-401200-20001-3324
Ordinance Fines and Cost
Ordinance Fines and Cost
Salaries
Fringe Benefits
Printing
Salaries
Fringe Benefits
Printing
Total
$ 5,500.00
5,500.00
$ 11,000.00
(57,578.00)
(23,032.00)
5,500.00
57,578.00
23,032.00
5,500.00
$ 11,000.00
JIMS
Expenditures
32-201200-20001-4100
32-201200-20001-6636
32-201200-20001-6675
21-221000-01000-4100
21-221000-01000-6636
21-221000-01000-6675
41-211000-41100-4100
41-211000-41100-6636
41-211000-41100-6675
35-220000-12000-4100
35-220000-12000-6636
35-220000-12000-6675
$ (2,400.00)
(7,300.00)
(2,830.00)
(2,400.00)
(7,300.00)
(2,830.00)
(1,200.00)
(3,560.00)
(1,415.00)
6,000.00
18,160.00
7,075.00
District Court - Div I - Expend Equip
District Court - Div I - IT Operations
District Court - Div I - Telephone Comm
Clerk/Reg. of Deeds - Expend Equip
Clerk/Reg. of Deeds - IT Operations
Clerk/Reg. of Deeds - Telephone Comm
Prosecutor - Expend Equip
Prosecutor - IT Operations
Prosecutor - Telephone Comm
Circuit Court/Business - Expend Equip
Circuit Court/Business - IT Operations
Circuit Court/Business - Telephone Comm
Total
Fund (101)
Salaries
FB - Workers Compensation
FB - Group Life
FB - Retirement
FB - Hospitalization
FB - Social Security
FB - Dental
FB - Disability
FB -'Unemployment Insurance
FB - Optical
Convenience Copier
Total
$ 59,359.00
145.00
164.00
9,592.00
8,186.00
4,541.00
1,149.00
232.00
83.00
140.00
484.00
84,075.00
$ (3,070.00)
3,070.00
(50,000.00)
50,000.00
Fiscal Services - General
Expenditures
12-601200-28000-2001
12-601200-28000-2075
12-601200-28000-2076
12-601200-28000-2077
12-601200-28000-2078
12-601200-28000-2079
12-601200-28000-2080
12-601200-28000-2081
12-601200-28000-2082
12-601200-28000-2085
12-601200-28000-6667
$ (84,075.00)
Expenditure
90-310000-33000-8001 Non-Dept - Health Fund Transfer Out
Public Services
Expenditures
17-402200-70211-2080 Community Corrections - Fringe Ben - Dental $ (20,000.00)
17-402200-70211-4100 Community Corrections - Exp. Equip Expens 20,000.00
Total
Public Services / Comm & Econ Dev
Expenditures
17-501200-50001-6636 MSU - IT Operations
19-210000-13500-6636 Comm & Econ Dev - IT Operations
19-221000-10000-3348 Comm & Econ Dev - Professional Svcs
19-221000-10000-3476 Comm & Econ Dev - Rent
Total
GF/GP OPERATIONS - GENERAL AMENDMENTS
Revenues
Non-Departmenal
43-013301-21400-0431 Deferred Offender Reimbursement
90-130000-12000-0231 State Court Equity
$ 109,256.00
(407,544.00)
$ (298,288.00) Total Revenues
Juvenile Maintenance Fund
Revenues
90-470000-31000-1701 Operating Transfer In from General Fund
Expenditures
35-242293-64000-3848 Juv. Maint./Circuit Court - Wraparound Pilot
Total Juvenile Maintenance Fund
Expenditures
Circuit Court
90-3100000-35000-8001 Operating Transfer Out to Juv. Maint
Sheriff
43-023601-34300-6680 Sheriffs Aviation
Prosecuting Attorney
41-211000-41700-2548 Computer Research Services
41-221000-41500-8001 Operating Transfer Out - Motorpool
Total
Facilities Management
14-210000-10000-4100 Expendable Equipment
Central Services - Support Services
13-138502-15100-2001 Salaries
13-138502-15100-2075 Fringe Benefits
Total
Human Services
16-121000-10000-2001
16-121000-10000-2077
16-122000-10002-2077
16-122000-10002-2078
16-122000-10002-2080
16-122000-10002-2081
16-122000-10002-2085
Admin - Salaries
Admin - FB - Retirement
FIA - FB - Retirement
FIA - FB - Hospitalization
FIA - FB - Dental
FIA - FB - Disability
FIA - FB - Optical
Total
Public Services
17-510200-50240-3488
17-510200-50240-3844
17-912000-15000-6677
MSU - Recognition Events
MSU - Workshops & Meetings
Medical Examiner - Insurance Fund
Total
t •
$ 48,242.00
$ 48,242.00
$ 48,242.00
$ (300,000.00)
$ (9,500.00)
31,000.00
21,500.00
$ (97,685.00)
$ 61,734.00
24,694.00
$ 86,428.00
$ (90,541.00)
(30,338.00)
(420.00)
(27,639.00)
(3,881.00)
(10.00)
(471.00)
$ (153,300.00)
$ 6,850.00
23,000.00
8,125.00
$ 37,975.00
Total Expenditures $ (298,288.00)
Non-Departmental Accounts
90-230000-23000-9105 Traffic Improvement Association
90-230000-23000-9072 S.E.M.C.O.G. Dues
90-270000-24000-3940 Sundry - Prior Years Expense
90-290000-25000-2404 Basic Readjustment
90-290000-25000-2564 Contingency
90-290000-25000-9075 Salary Adjustments
90-290000-25000-9051 Fringe Benefit Adjsutments
7,000.00
34,370.00
120,199.00
(443,593.00)
227,041.00
23,425.00
90,110.00
$ 58,552.00
Total
Information Technology Operations
17-402200-70111-6636 Community Corrections Admin.
17-501200-50001-6636 MSU Extention OC/Admin
17-510200-50240-6636 MSU Extention OC/Natural Science
21-221000-01000-6636
21-210100-10000-6636
32-201200-20001-6636
35-220000-12000-6636
41-211000-41100-6636
43-023301-20000-6636
51-231000-53000-6636
90-290000-25000-2404
Clerk - Legal Records
Clerk/Reg. of Deeds - Admin.
Distict Court - Div I (Novi)
Circuit Court - Business
Prosecuting Attorney - Admin
Sheriff - Corrective Svcs
Library Board - Research Library
Non-Dept - Basic Readjustment
$ (105,577.00)
(10,530.00)
10,531.00
(7,300.00)
(5,800.00)
27,037.00
(10,949.00)
(3,651.00)
(859.00)
(1,901.00)
108,999.00
Telephone Communications
17-402200-70234-6675 Community Corrections - Admin
21-210100-10000-6675
32-201200-20001-6675
35-220000-11000-6675
41-211000-41700-6675
90-290000-25000-2404
Clerk/Reg. of Deeds - Admin
District Court - Division I (Novi)
Circuit Court - Business
Prosecuting Attorney - Admin
Non-Dept - Basic Readjustment
$ 71,412.00
(1,200.00)
6,770.00
(4,245.00)
(1,415.00)
(71,322.00)
1TOTAL GF/GP OPERATIONS
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2002 FIRST QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP) ACTIVITIES
EFFECTING PROPRIETARY FUNDS
ACCOUNT NUMBER ACCOUNT NAME
SELF BALANCING AMENDMENTS
General Fund (101)
Non Departmental
90-210000-21000-9100 Non-Dept - MAN/WAN
90-310000-40000-8001 Non-Dept - I.T. Transfer Out
FY 2002
AMENDMENT
$ (2,500,000.00)
2,500,000.00
Total General Fund (101)
I.T. Fund (636)
Revenue
18-636162-81000-1701
Expenditures
18-636162-81000-2540
18-636162-81000-2775
18-636162-81000-3348
I.T. Transfer In
I.T. - Communications
I.T. - Equipment Repairs & Maint
I.T. - Professional Services
$ 2,500,000.00
$ 594,485.00
640,637.00
1,264,878.00
$ 2,500,000.00
Total I.T. Fund (636)
Rental Helicopters
Salaries
Overtime
Fringe Benefits
Clothing Allowance
Equipment Repairs and Maint.
Depreciation
Interest Expense
FA Expendable Equipment Exp.
Gas, Oil, Grease
Office Supplies
Shop Supplies
Equipment Rental
Telephone Communications
Insurance Fund
Total
Management and Budget / Facilities Management (Fund 631)
Expenditures
12-640632-27001-2001
12-640632-27001-2074
12-640632-28000-2001
12-640632-28000-2074
14-270000-30000-2960
Project Work Oder Fund (404)
14-310007-60953-1701 Transfer In (Clerk - Remodeling)
14-210007-60953-8005 Change in Fund Equity
Total
Salaries
Fringe Benefits
Salaries
Fringe Benefits
Indirect Cost
Total
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2002 FIRST QUARTER BUDGET AMENDMENTS
PROPRIETARY AND ENTERPRISE FUND ACTIVITIES
FY 2002
AMENDMENT ACCOUNT NUMBER ACCOUNT NAME
ISELF BALANCING AMENDMENTS I
Sheriff Aviation (Fund 680)
Revenue
43-136680-34300-0924
Expenditures
43-236680-34300-2001
43-236680-34300-2002 .
43-236680-34300-2075
43-236680-34300-2524
43-236680-34300-2776
43-236680-34300-3912
43-236680-34300-3965
43-236680-34300-4100
43-236680-34300-4116
43-236680-34300-4252
43-236680-34300-4308
43-236680-34300-6018
43-236680-34300-6675
43-236680-34300-6677
$ 1,121,148.00
$ 122,068.00
15,000.00
3,465.00
3,500.00
200,000.00
280,000.00
179,130.00
35,000.00
80,000.00
525.00
860.00
400.00
1,200.00
200,000.00
$ 1,121,148.00
$ (51,229.00)
(29,929.00)
(61,734.00)
(23,920.00)
$ 166,812.00
$ 76,500.00
76,500.00
$ 2,304.00
$ 2,304.00
$
Daily Patient Services
I.T. Operations
Total
Medical Care Facility (Fund 521)
Revenue
16-302100-20120-0417
Expenditure
16-701521-35000-6636
I.T. - CLEMIS (Fund 635)
23-635152-10010-6636
23-635111-10010-8005
I.T. Operations
Change in Fund Equity
Total
$ 5,190.00
(5,190.00)
I.T. Fund (636)
18-636172-26000-3348
18-636122-12000-3348
18-636122-15000-3348
18-636172-25100-3348
18-636142-15000-8005
Professional Services
Professional Services
Professional Services
Professional Services
Change in Fund Equity
$ 28,613.00
88,782.00
266,780.00
250,000.00
(634,175.00)
L. BROOKS PATTERSON, OAKLAND COUNTY EXECUTIVE
Jeffrey C. Pardee, Director
Laurie Van Pelt, Deputy Director
COAKLAND IIIIr"
...---. .,,,m...-..,,
COUNTY MICHIGAN
DEPARTMENT OF MANAGEMENT AND BUDGET
........... -- n•nnnn•n..... n•n••n••nn
TO: Members of the Finance Committee
FROM: Jeffrey C. Pardee, Director, Management and Budget
Tim Soave, Manager, Fiscal Services
Nancy Fournier, Chief, Fiscal Services
SUBJECT: Letter of Transmittal - Fiscal Year (FY) 2002 First Quarter Financial Forecast
DATE: February 28,2002
FY 2002 FORECAST
Attached please find the FY 2002 First Quarter Financial Forecast Report. In total, the Fiscal Services
Division forecasts that the County will complete Fiscal Year 2002 with a $2,539,488 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 $1,914,377 more revenue than
budgeted (0.54%), and expending $625,111 less than budgeted (0.18%).
REVENUES
GF/GP revenues are forecasted to be 0.54% above budget or $1,914,377. This favorability reflects a
number of events.
A. GENERAL FUND - INTERGOVERNMENTAL REVENUE (Fay. $91,300)
This favorability results from an increase in Convention Facility/Liquor Tax revenue
from the State. The County is estimated to receive $3,198,786, which is approximately
$498,800 more than what the County received in FY 2001($2,873,477). This is offset by
the State's notice to the County that State Court Equity will be reduced this year. The
County anticipated approximately $6.6 million in revenue, while the State has indicated
theCounty's share is estimated at $6.192 million. (about a $408,000 reduction).
B. GENERAL FUND - CHARGES FOR SERVICES (Fay. $1,935,577)
This favorability primarily results from an unanticipated continuance of activity
regarding new mortgages and refinancing as reflected in the Clerk's revenue. An
estimated $970,000 in favorability is forecasted as a result. Favorability of $581,075 is
forecasted in the Treasurer's Office due to a one time collection from the Local
Development Financing Authority.
C. GENERAL PURPOSE FUNDS - CHARGES FOR SERVICES (Unfav. $112,500)
Due to delays in the construction of the Secure Detention Facility ("J" Building), the
Children's Village Division is projecting an unfavorable variance with regards to
anticipated revenue from providing space for Out County Board and Care.
EXECUTIVE OFFICE BUILDING 34 EAST • 1200 N TELEGRAPH RD DEPT 409 • PONTIAC MI 48341-0409 • (248) 858-0487 • FAX (248) 858-9172
EXPENDITURES
In total, expenditures are anticipated to be 0.18% below budget or $625,111. A majority of the favorability
is related to vacant and under filled positions (referred to as "Turnover"). The following divisions are
projected to experience overall unfavorability:
A. 52'd DISTRICT COURT - Division I (Novi) is projected to have an unfavorable variance
($78,100) in Controllable Operating due to an increase in bank charges, the use of
Defense Attorneys and Interpreters. There is an offset of favorability in Controllable
Personnel $22,600. Also, Division III (Rochester Hills) is anticipated to have
unfavorability ($48,500) due to an increase in use of Overtime and the use of unbudgeted
Misc. Capital Outlay for office furniture.
B. CLERK/REGISTER OF DEEDS - The majority of unfavorability ($285,800) stems from
the continued high volume of activity within the Clerk's Office, in spite of the current
decline in the economy. Fortunately, the revenue generated from this activity has also
created a favorable variance for the County as previously mentioned. Also, due to the
shift in using the courier services of the mail room versus direct mailing, there is an
increase in cost, which was not included in the original budget. The overall budget for
this in projected to be unfavorable by ($137,800), with an offset of favorability in total
for Controllable Personnel $39,900.
C. DRAIN COMMISSIONER - Activity related to the Water Quality Grant and Drain
Redistricting costs has resulted in a projected unfavorable variance for the Drain
Commissioner's Office ($34,038), with an offset of favorability in funds budgeted in
Transfers Out $24,048 for maintenance on Chapter 4 drains.
D. CENTRAL SERVICES - This is primarily due to an oversight of budgeting enough funds
to cover one (1) Chief position under Support Services.
E. NON-DEPARTMENTALS - Membership dues for S.E.M.C.O.G. has increase
substantially from previous year to FY 2002 ($34,574), Traffic Improvement Association
dues has resulted in a $7,000 increase over what was budgeted, and Sundry expense is
unfavorable ($120,200) due to a prior years expense. The Reserves for Transfers
("Contingency Accounts") are currently reflecting a deficit ($197,441) due to several
requests approved by the Board during first quarter of FY 2002.
For those divisions projected to have negative variances, budget amendments have been
recommended. There are also budget amendments recommended for other various reasons, but
are riot necessarily related to any unfavorable variances. All amendment requests will be
presented at the next Finance Committee meeting on March 21, 2002.
r r Z1JUZ NM, I WAN I Cr( rtnitt.H.4 fltYLItt
GENERAL FUND/GENERAL PURPOSSREVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
FY 2002 BUDGET AMOUNT
ADOPTED AS FY 2002 FAVORABLE/
BUDGET AMENDED FORECAST (UNFAVORABLE). PERCENT
REVENUES
GENERAL FUND
Taxes $193,547,700.00 $193,547,700.00 $193,547,700.00 $0.00 0.00%
Intergovernmental 45,273,177.00 45,273,177.00 45,364,477.00 91,300.00 0.20%
Charges for Services 87,131,086.00 88,195,266.19 70,130,843.19 1,935,577.00 2.84%
Miscellaneous Revenue 23,478,492.00 24,838,418.00 24,838,418.00 . 0.00 0.00%
SUB-TOTAL GENERAL FUND $329,430,435.00 $331,854,561.19 $333,881,438.19 $2,028,877.00 0.81%
GENERAL PURPOSE FUNDS
Intergovernmental $9,115,000.00 $9,115,000.00 $9,115,000.00 $0.00 0.00%
Charges for Services 10,787,597.00 10,787,597.00 10,855,097.00 (112,500.00) -1.04%
SUB-TOTAL GP REVENUES
BACK USE OF FUND BALANCE
$19,882,597.00 $19,882,597.00 $19,770,097.00 ($112,500.00) -0.57%
TOTAL GF/GP FUNDS $349,313,032.00 4351,737,158.19 $353,651,535.19 $1,914,377.00 0.54%
EXPENDITURES
ADMINISTRATION OF JUSTICE
Chu& Court $43,975,487.00 $44,280,692.17 $44,260,692.17 $0.00 0.00%
52nd District Court 12,811,468.00 12,923,190.65 12,977,490.65 ($54,300.00) -0.42%
Probate Court 5,070,180.00 5,092,711.31 5,083,111.31 $29,600.00 0.58%
TOTAL ADMIN. OF JUSTICE $61,857,133.00 $82,276,594.13 $62,301,294.13 ($24,700.00) -0.04%
LAW ENFORCEMENT
Prosecuting Attorney $16,367.247.00 $18,537,572.93 $18,296,872.93 $240,700.00 1.48%
Sheriff 92,281,969.00 93,928,872.91 93,211,772.91 717,100.00 0.78%
TOTAL LAW ENFORCEMENT $108,649,216.00 $110,466,445.84 $109,508,645.84 $957,800.00 0.87%
GENERAL GOVERNMENT . • Clerk/Register of Deeds $10,898,913.00 $10,987,195.78 $11,372,395.78 ($385200.00) 3.51%
Treasurer 3,576.730.00 3,650,885.49 3,805,085.49 45,800.00 1.25%
Board of Commissioners 2,683,731.00 2,865,609.29 2,658,309.29 . 9,300.00 0.35%
Library Board 2,691,527.00 2,693,788.88 2,693,788.86 0.00 0.08%
Drain Commissioner 3,440.515.00 3,454,427.58 3,464,427.58 (10,000.00) -0.29%
TOTAL GENERAL GOVERNMENT $23.271,416.00 $23,451,907.00 $23,792,007.00 ($340,100.00) -1.45%
COUNTY EXECUTIVE
County Executive Acimn. $6,095,607.00 $7,876,382.91 $7,876,382.91 $0.00 0.00%
Management and Budget 518,093,519.00 $18,493,729.58 $18,493,729.58 0.00 0.00%
Central Services $2,289,438.00 $2,329,703.00 $2,418,131.00 (88,428.00) -3.71%
Facilities Management $1,669,649.00 $1,870.576.82 $1,665,578.82 6,000.00 0.30%
Personnel $4,626,076.00 $4,859,112.94 . $4,859,112.94 0.00 0.00%
Human Svs. $55,874,555.00 $58,138,881.93 $55,813,581.93 323,300.00 0.58%
Public Services $13,641,138.00 $13,883,089.45 $13,568,839.45 114,250.00 0.83%
Community & Economic Day. $5,654,905.00 $5,858,217.80 $5,823,217.80 35,000.00 0.82%
CLEMIS & Emergency Communications 51,237.488.00 $0.00 $0.00 0.00 0.00%
Workforce Development $1,028,899.00 $1,027,100.00 $1,027,100.00 0.00 0.00%
TOTAL COUNTY EXECUTIVE 8110.189272.00 5111,534,794.43 $111,143,672.43 $391,122.00 0.35%
TOTAL DEPARTMENTS $303,967,037.00 $307,729,741.40 $306,745,619.40 $984,122.00 0.32%
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NON-DEPARTMENTALS $45,345,995.00 $44,007,416.79 . $44,366,427.79 (5359,011.00) -0.82%
TOTAL GOVERNMENTAL EXPENDITURES $349,313,032.00 $351,737,158.19 $351,112,047.19 -llfs $625,111.W 00 0.18% •,..=-,.,==,==.,=,.. mgeseMmermairam....2.. vesweaMetaecalalle.12.6.2e1B MallIMOSIMMIUM
General Fund/General Purpose
Favorable/(Unfavorable) $0 50 $2,539,488 $2,539,486
0.00%
PROPERTY TAXES
2001 Tax Levy $ 192,852,700.00 $ 192,852,700.00 $ 192,852,700.00 $
NET CURRENT PROPERTY TAX $ 192,852,700.00 $ 192,852,700.00 $ 192,852,700.00 $ 0.00%
6,00%
0.00%
TOTAL PROPERTY AND OTHER TAXES $ 193,547,700.00 $ 193,647,700.00 $ 193,547.700.00 $ 0.00%
$ 45,273,177.00 $ 45,273,177.00 $ 45,384,477.00 $
$45,273,177.00 $45,273,177.00 645,384,477.00 $
$ 500.00
1,310.00
80,000.00
2,142,538.00
318,000.00
12,500.00
85,000.00
25,000.00
750.00
500.00 $ 555.00 $
32,810.00 45,310.00
80,000.00 80,000.00
2,151,475.00 2,151,475.00
315,000.00 315,000.00
12.500.00 12,500.00
65,000.00 85,000.00.
25,000.00 25,000.00
750.00 • 750.00
403,000.00 403,000.00 381,000.00
71,125.00
98.500.00
71,125.00 71,125.00
98,500.00 108,500.00
828,935.00 828,935.00 1328,935.00
477,500.00 477,500.00 477,500.00
1,028,899.00 1,028,899.00 1,028,899.00
2,121,000.00 2,187,195.00 2,187,195.00
19,800.00 19,800.00 19,800.00
11,502,891.00 11,1302,891.00 12,672.891.00
BUDGET
AS
ADOPTED
BUDGET
AS
ADJUSTED
FY 2002
FORECAST
AMOUNT
FAVORABLE/
(UNFAVORABLE) PERCENT
OTHER TAXES
Delinquent Tex - Prior Years
Trailer Tax
$ 800,000.00 $ 500,000.00
95,000.00 95,000.00
600,000.00 $
95,000.00
$ 895,000.00 $ 695,000.00 $ 695,000.00 $ 0.00%
BUDGETED RECEIPTS OTHER THAN TAXES
GENERAL FUND. STATE AND FEDERAL
Outside Agendas
TOTAL BUDGETED RECEIPTS
GENERAL FUND- STATE AND FEDERAL
CHARGES FOR SERVICES
County Executive Administration
Emergency Response & Preparedness
Auditing
Equalization
Reimbursement Division
Materiels Management - Auction
Support Services - AtImIn (Vending/Cafeteria)
Fadliges Engineering
Personnel
Human Services AdMin -FIA
Community Court Services
MSU Extension- Oaldand County
Medical Examiner
Animal Control
Development & Planning
C&E DevNVorldorce Development
County Clerk
Elections
Register of Deeds
IRSTREVAs
91,300.00 0.20% Convention Facility Tax intimated to be fav $498.800. However, this offset by the State's
reduction In estimated Court Equity to the County ($407,500).
91,300.00 0.20%
185.00 33.00% Per Diems for Directors who attend P & R and Bldg Authority meetings.
12,500.00 0.00% Revenue generated as a result of the County's sale of sirens to other Communities.
0.00%
• 0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
(22,000.00) -5.45% - Change In Court criteda eliminated participants once eligible for the Virtual Reality
Step Down program ($42.000), offset by fav. Contracted Services expenditure.
Fav. $20,000 in Step Forward Program.
0.00%
10,000.00 10.38% - Fav due to increased revenue from Autopsies offset by unfav. Medical Services
Autopsies expenditure.
0.00%
0.00%
0.00%
0.00%
0.00%
970,000.00 8.38% Fair due to favorable soon. cond6ons generating incr. refinancing of mortgages $1,000.000
and recording fees $400,000. Thls is offset by a reduction In Enhance Access Fee Rev.
02/27/2002
Treasurer
Circuit Court - Gen. Fund
District Court
12,000.00
BUDGET BUDGET AMOUNT
AS AS FY 2002 FAVORABLE/
ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT
of ($400,000), and lower Miscellaneous rev. of ($30,000), See Note: Incr. OT exp.
4,455,414.00 4,455,414.00 5,048,014.00 592,600.00 13.30% Fay due to receipt of one time Local Develop. Finance Auth. Assessment revenue,
also, fay. Relmb. Salaries, Sale of Publications, and higher Service Fee revenue.
3,548,481.00 3,963,387.00 3,963,387.00 0.00%
9208,060.00 9208,060.00 9,282.574.00 74,514.00 0.81% - Division I reflects newly authorized Court Cost Sobriety and DNA Assessment rev,
and higher caseloads lagenerating higher Refund of Oct. Attorney fees,
Probate Court 524,100.00 524,100.00 525,298.00 1,198.00 0.23% - Favorable due to receipt of unanticipated Crime Victims Right- County Portion revenue.
Prosecutor 227,500.00 266,100.00 286,100.00 - 0.00%
' Sheriffs Office 18,800.00 41,800.00 56,000.00 14,200.00 33.97% -Favoarable due to increase In Social Security incentive Payments
Administrative Services 1,000.00 1,000.00 13,000.00 12,000.00 1200.00% -Favorable due to Increase in Mileage Reimbursements
Corrective Services 4,971,089.00 4,971,069.00 6,229,489.00 258,400.00 5.20% -Favorable due to increase In Deferred Offender Reimbursements. A budget amendment
Is recommended.
Corrective Services - Satellltee
Patrol Services
Technical Services
Board of Commissioners
Library Board
Drain Commissioenr
1,515,900.00 1,515,900.00 1,515,900.00
22,097.310.00 22,471,267.00 22,483,287.00
495,940.00 601,043.19 601,043.19
8,000.00 8,000.00 8,000.00
184,022.00 184,022.00 184,022.00
588,224.00 588,224.00 588,224.00
0.00%
0.05% -Favorable due to Increase In County Auction Revenues
0.00%
0.00%
0.00%
0.00%
TOTAL CHARGES FOR SERVICES $ 67,131,066.00 $ 68,195,268.19 $ 70,130,843.19 $ 1,935,577.00 2.84%
GENERAL FUND
BUDGETED RECEIPTS GENERAL PURPOSE
GOV'T STATE AND FEDERAL (Outside Agencies)
Child Care Subsidy
State Match - Foster Care
$ 9,100,000.00 $ 9,100,000.00 $ 9,100,000.00 $
15,000.00 15,000.00 15.000.00
TOTAL BUDGETED FtECEIPTS GEN. PUFLPOSE $ 9,115,000.00 $ 9,115,000.00 $ 9,115,000.00 $- 0.00%
GOVT STATE AND FEDERAL
.. CHARGES FOR SERVICES
Emergency Management Services s - $ - $ - $
Health Division 6,591,836.00 8,591,836.00 8,591,836.00
Circuit Court - Juvenile Maintenance 1.030,000.00 1,030,000.00 1,030,000.00
Children's Village 3,145,761.00 3,145,761.00 3,033,261.00
$ 10,767,597.00 $ 10,767,597.00 $ 10,655,097.00 $
0.00%
0.00%
(112,500.00) 4.58% (Unfav) Out County Board & Care due to construction delays to the Secure Detention Facility
(.1 Bldg.) tentative completion 612002.
(112,500.00) -1.04%
"SCELLANEOUS REVENUE
indry $ 3,328,492.00 $ 3,328,492.00 $ 3.328,492.00 $ 0.00%
FIRSTREV.xls 2 02/27/2002
Investment Income
Nor Years Balance
19,900,000.00 19,900,000.00 19,900,000.00
250,000.00 1,609,928.00 1,609.926.00
0.00%
0.00% Reflects use of General Fund fund balance,
BUDGET BUDGET AMOUNT
AS AS FY 2002 FAVORABLE/
ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT
OPERATING TRANSFERS
$ 23,478,492.00 $ 24,833,418.00 S 24,838.419.00 5 0.00%
$ 43,974,316.00 $ 43,974,316.00 5 43,974,316.00 5 0.00%
TOTAL AVAILABLE RESOURCES
GENERAL FUND/GENERAL PURPOSE 5 393,287,348.00 S 395.711.474.19 $ 397,625,851.19 $ 1,914,377.00 0.48%
Less Operating Transfers (Out) $ (43,974,316.00) S (43,974,316.00) 8 (43,974,316.00) $ 0.00%
NET GF/GP RESOURCES $ 349,313,032.00 $ 351,737,158.19 5 353,551,535.19 S 1,914,377.00 0.54%
statscsmaccasese
wNlrlyVirsirntwkl
PIRSTREVAs 3 02/27/2002
COUNTY OF OAKLAND •
FY 2002 FIRST QUARTER FORECAST REPORT
EXPENDITURES
DISTRICT COURT
AMOUNT
ADOPTED AMENDED FY 2002 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
District Court Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$137,212.00 $137,212.00 $105,612.00
65,300.00 65,300.00 65,300.00
0.00 0.00 0.00
$31,600.00
0.00
0.00
23.03% - Turnover.
0.00% -
0.00% -
$202,512.00 $202,512.00 $170,912.00 $31,600.00 15.60%
Division 1 - Novi
Controllable Personnel
Controllable Operating
$3,057,654.00 $3,138,284.00 $3,115,664.00 $22,600.00 0.72% - Turnover.
866,555.00 874,755.00 952,855.00 (78,100.00) -8.93% - Unfav. due to increased number of defendants paying fines paid by credit card,
for which a service fee is charged per transaction. Also, higher than anticipated
Defense Attorney Fees and use of Interpreters.
Non-Controllable Operating 451,360.00 461,746.14 461,746.14 0.00 0.00% -
Division 2 • Clarkston
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Division 3 - Rochester Hills
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$4,375,569.00 94,474,785.14 $4,530,265.14 ($55,500.00) -1.24%
$1,075,157.00 $1,075,157.00 $1,064,157.00 $11,000.00 1.02% - Turnover.
341,109.00 341,109.00 341,109.00 0.00 0.00% -
159,221.00 163,414.81 164,414.81 (1,000.00) -0.61% - Unfav projected radio communications cost.
$1,575,487.00 $1,579,680.81 $1,569,680.81 $10,000,00 0.63%
$2,723,908.00 $2,723,908.00 $2,751,208.00 ($27,300.00) -1.00% - Unfav due to increase use of overtime, offset by turnover.
771,764.00 771,764.00 792,964.00 (21,200.00) -2.75% - Unfavorable due to Misc. Capital Outlay use for furniture.
341,320.00 349,275.43 349,275.43 0.00 0.00% -
$3,836,992.00 $3,844,947.43 $3,893,447.43 ($48,500.00) -1.26%
Division 4- Troy
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$1,908,498.00 $1,908,498.00 $1,900,298.00
526,978.00 526,976.00 527,076.00
385,432.00 385,811.27 385,811.27
$8,200.00 0.43% - Turnover.
(100.00) -0.02% • Unfav due to unbudgeted cash shortage.
0.00 0.00% -
$2,820,906.00 $2,821,285.27 $2,813,185.27 $8,100.00 0.29%
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$8,902,429.00 $8,983,039.00 $8,936,939.00
2,571,704.00 2,579,904.00 2,679,304.00
1,337,333.00 1,360,247.65 1,361,247.65
$46,100.00
(99,400.00)
(1,000.00)
0.51% -
-3.85%
-0.07%
$12,811,466.00 $12,923,190.65 $12,977,490.65 ($54,300.00) -0.42%
• • 02/27/2002
COUNTY OF OAKLAND
FY 2002 FIRSTOUARTER FORECAST REPORT
EXPENDITURES
CIRCUIT COURT
AMOUNT
ADOPTED AMENDED FY 2002 FAVORABLE
BUDGET. BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Judicial Administration
Controllable Personnel $5,492,971.00 $5,492,971.00 $5,492,971.00 $0.00 0.00% -
Controllable Operating 45,000.00 45,287.00 46,787.00 . ($1,500.00) -3.31% - Unfav due to purchase of expendable equipment
Non-Controllable Operating 179,381.00 194,177.77 195,177.77 ($1,000.00) -0.51% - Unfav misc. printing.
$5,717,352.00 $5,732,435.77 $5,734,935.77 ($2,500.00) -0.04%
Business Division
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$1,937,154.00 $2,070,833.00 $2,070,833.00 $0.00 • 0.00% -
116,700.00 129,000.00 66,500.00 • 62,500.00 48.45% - Fay due to postage, printing and expendable equipment expense charged to internal
services.
305,333.00 329,475.00 354,475.00 (25,000.00) -7.59% - Unfav due to shift of postage to internal service mail room.
$2,359,187.00 $2,529,308.00 $2,491,808.00
$1,641,282.00 $1,641,282.00 $1,641,282.00
11,515,065.00 11,553,880.00 11,555,380.00
Non-Controllable Operating 1,594,901.00 1,620,383.40 1,697,663.40
$37,500.00 1.48%
$0.00 0.00% -
(1,500.00) -0.01% - Unfav due to mail handling, offset by fay in Postage due to shift of postage to internal
service mall room.
(77,200.00) -4.76% - Unfav. due to higher than anticipated usage of Printing and IT Operations, as well as
an increase in usage of internal service mail room.
General Jurisdiction Division
Controllable Personnel
Controllable Operating
$14,751,248.00 $14,815,525.40 $14,894,225.40 ($78,700.00) -0.53%
$29,100.00
48,400.00
(33,800.00)
Family Division/Juvenile MaInt
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$11,149,261.00 $11,171,453.00 $11,142,353.00
8;431,470.00 8,436,010.00 8,387,610.00
1,566,969.00 1,575,960.00 1,609,760.00
0.26% - Fav Personnel due to vacancies and position turnover.
0.57% - Fay due to shift of postage to internal service mail room.
-2.14% - Unfav due to shift of postage to mail room, offset by misc. printing.
$21,147,700.00 $21,183,423.00 $21,139,723.00 $43,700.00 0.21%
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$20,220,668.00 $20,376,539.00 $20,347,439.00
20,108,235.00 20,164,177.00 . 20,056,277.00
3,646,584.00 3,719,976.17 3,856,976.17
$43,975,487.00 $44,260,692.17 $44,260,692.17
$29,100.00
107;900.00
(137,000.00)
$0.00 0.00%
0.14%
0.54%
-3.68%
03/08/2002
COUNTY OF OAKLAND
FY 2002 FIRST QUARTER FORECAST REPORT
EXPENDITURES
PROBATE COURT
AMOUNT
AKIPTED AMENDED FY 2002 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Judiclal/Administration
Controllable Personnel $1,678,438.00 $1,678,438.00 $1,858,338.00 20,100.00 1.20% - Turnover.
Controllable Operating 0.00 0.00 42,600.00 (42,600.00) 0.00% - Unfav primarily due to Expendable Equipment and Contracted Services. Note: Offset
Is In Judicial Supporrs Operating Expense.
Non-Controllable Operating 430,851.00 435,270.00 433,170.00 2,100.00 0.48% - Fey due to Telephone Communications expense lower than anticipated. Note: Offset in
Judicial Support's Non-Controllable Expense.
92,109,289.00 92,113,708.00 92,134,108.00 (920,400.00) -0.97%
Judicial Support
Controllable Personnel $1,853,397.00 $1,853,397.00 $1,803,297.00 $50,100.00 2.70% - Turnover.
Controllable Operating 668,414.00 668,653.00 643,653.00 25,000.00 3.74% - Fay primarily due to Expendable Equipment and Contracted Services expensed In
Administration. .
Non-Controllable Operating 439,080.00 456,953.31 482,053.31 (25,100.00) -5.49% - Unfav due largely to phones offset In Jud. Admin. Budget and postage shift to Mail Room
$2,960,891.00 $2,979,003.31 $2,929,003.31 $50,000.00 1.68%
Department Total
Controllable Personnel , $3,531,835.00 $3,531,835.00 $3,461,635.00 970,200.00 1.99%
Controllable Operating 668,414.00 688,653.00 888,253.00 (17,800.00) -2.63%
Non-Controllable Operating 889,931.00 892,223.31 915,223.31 (23,000.00) -2.58%
95,070,180.00 $5,092,711.31 $5,063,111.31 929,600.00 0.58% === .-7====2=i ===r.42
02/26/2002
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Litigation
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$0.00 0.00%
$185,200.00
5,000.00
2.62% - Turnover
4.88% - Personal Mileage
0.00%
$16,367,247.00 $16,537,572.03 $16,296,872.93 $240,700.00 1.46%
COUNTY OF OAKLAND
FY 2002 FIRST QUARTER FORECAST REPORT
EXPENDITURES
PROSECUTING ATTORNEY
AMOUNT
ADOPTED AMENDED FY 2002 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
$2,132,370.00 $2,179,057.00 $2,179,057.00
1,781,467.00 1,785,758.00 1,785,758.00
1,793,991.00 1,824,487.93 1,824,487.93
0.00%
0.00%
0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
$5,707,828.00 $5,789,302.93 $5,789,302.93
$7,074,440.00 $7,078,366.00 $6,893,166.00
56,492.00 102,488.00 $97,488.00
0.00 0.00 $0.00
$7,130,932.00 $7,180,854.00 $6,990,654.00 $190,200.00 2.65%
Warrants
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$2,027,327.00 $2,027,327.00 $1,999,827.00
2,758.00 41,358.00 41,358.00
0.00 0.00 0.00
$27,500.00 1.36% - Turnover
0.00%
0.00%
$2,030,085.00 $2,068,685.00 $2,041,185.00 $27,500.00 1.33%
Appellate
Controllable Personnel ' $1,491,517.00 $1,491,517.00 $1,468,517.00 $23,000.00 1.54% - Turnover
Controllable Operating 6,885.00 7,214.00 7,214.00 0.00%
Non-Controllable Operating 0.00 0.00 0.00 0.00%
$1,498,402.00 $1,498,731.00 $1,475,731.00 $23,000.00 1.53%
Department
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$12,725,654.00 $12,776,267.00 $12,540,567.00 $235,700.00 1.84%
1,847,602.00 1,936,818.00 1,931,818.00 5,000.00 0.26%
1,793,991.00 1,824,487.93 1,824,487.93 0.00 0.00%
3511i=".'.====r. ============
02/26/2002
Turnover $182,400, offset by Overtime ($85,000). 0.49% -
0.00%
0.00%
0.00%
Patrol Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Operating Transfer Out
Technical Services
Controllable Persomel
Controllable Operating
• Non-Controllable Operating
Operating Transfer Out
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Operating Transfer Out
18,1332,120.00 $8,675,733.00 $8,462,733.00 $213,000.00 2.46%.
1,741,163.00 1,749,972.19 805,172.19 944,800.00 53.99% -
COUNTY OF OAKLAND
FY 2002 FIRST QUARTER FORECAST REPORT.
EXPENDITURES
SHERIFF'S DEPARTMENT
Sheriff's Office
Controllable Personnel
Controllable Operating
Non-Controllable Operating
AdrrdnistratIve Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Corrective Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Operating Transfer Out
AMOUNT
ADOPTED AMENDED FY 2002 FAVORABLE
BUDGET BUDGET FORECAST UNFAVORABLE) PERCENT
$1,040,392.00 $1,144,198.00 $1,144,198.00 0.00%
492,738.00 517,736.00 517,736.00 0.00%
736,168.00 748,940.00 748,940.00 0.00%
.$2,269,296.00 $2,410,874.00 $2,410,874.00 $0.00 0.00%
$2,411,538.00 $2,414,283.00 $2,395,183.00 $19,100.00 0.79%
$19,702,6313.00 $19,771,220.00 $19,673,820.00 $97,400.00
8,828,722,00 6,828,722.00 8,828,722.00
6,242,729.00 6,340,670.18 6,340,670.18
98,000.00 98,000.00
$32,774,089.00 $33,038,612.18 $32,941,212.18 07,400.03 0.29%
EXPLANATION OF SIGNIFICANT VARIANCES
$1,111,179.00 $1,112,173.00 $1,093,073.00 119,100.00 1.72% - Turnover $21,300, offset by Overtime ($2,200).
811,417.00 813,170.00 813,170.00 0.00%
488,940.00 488,940.00 488,94400 0.00%
Corrective Services-Satellites
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$13,657,888.00 813,672,975.00 813,624,175.00 $48,1300.00
343,400.00 343,400.00 357,500.00 (14,100.00)
804,970.00 804,970.00 804,970.00
0.36% - Turnover unfav. ($6,900), offset by Overtime fair, $55,700.
-4.11% - Unfav. Dry Goods
0,00%
914,808,258.00 914,821,345.00 914,788,845.00 934,700.00 0.23% '
125,493,832.00 125,845,793.00 125,592,593.00 $253,200.00 0.98%. Fey. 'Salaries $204,900,Fringes $53,300 and Overtime $110,400 offset by
Unfav. Holiday Overtime ($115,400), offset by Increase in contract revenue for Patrol
Services.
262,025.00 262,025.00 262,025.00 0.00%
2,386,303.00 3,087,072.00 3,888,172.00 (821,100.00) -26.77% - Unfav. Sheriff Aviation offset by Fey. Controllable Personnel and Controllable Operating
in Sheriff Technical Services. Budget amendment Is requested.
137,790.00 137,790.00 $0.00 0.00%
$28,142,160.00 $29,312,680.00 $29,880,580.00 ($567,900.00) -1.94%
Fay. Salaries $223,700 and Fringes $18,700 offset by Unfav. Overtime (821,400) and
Holiday Overtime ($8,000) offset by Unfav. Non-Controllable Operating in Patrol Services.
Budget Amendment is requested.
Fay. $24,000 Capital Outlay, $980,600 Budgeted Projects offset by Unfav.Non-Controllable
Operating in Patrol Services,Dry Goods ($59,800) due to higher usage. Budget
amendment Is requested.
0.00% -
0.00% - Unfav. Offset by Fay. In Controllable Operating Capital Outlay. Budget Amendment is
requested.
$11,878,830.00 $11,931,078.73 $10,797,278.73 $1,133,800.00 9.50%
09,838,049.00 $70,222,092.00 $89,590,592.00 $831,500.00 0.90%
10,479,463.00 10,515,025.19 9,584,325.19 930,700.00 8.85%
12.184,457.00 12,955,965.72 13,777,065.72 (821,100.00) -6.34%
235,790.00 259,790.00 (24,000.00) -10.18%
890,281,969.00 $93,928,872.91 193,211,772.91 170,100.00 0.78%
====n13t=
1,505,347.00 1,505,373.54 1,505,373.54
24,000.00 ($24,000.00)
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$603,981.00
75,350.00
156,285.00
$603,981.00
75,350,00
157,410.42
584,281.00
53,950.00
185,410.42
$19,700.00
21,400.00
(28,000.00)
1,572,588.00
1,319,307.00
1,660,788.00
1,033,307.00
88,200.00
(226,000.00)
1,652,588.00
1,172,951.00
5.31% - Fay due to shift of postage to internal svc. mall room, and office supplies.
-20.67% - Unfav due to shift In postage to Internal service mall room.
Controllable Operating
Non-Controllable Operating
COUNTY OF OAKLAND
FY 2002 FIRST QUARTER FORECAST REPORT
EXPENDITURES
CLERIC/REGISTER OF DEEDS
AMOUNT
ADOPTED AMENDED FY 2002 FAVORABLE
BUDGET BUDGET FORECAST UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
3.26% - Fey Personnel due to vacancies and position turnover.
28.40% - Fay due to shlft of postage to internal service mail room.
-17.79% - Unfav due to shift In postage to Internal service mall room, and printing of
brochures.
$835,616.00 5838,741.42 51323,641.42 $13,100.00 1.57%
County Clerk
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$1,202,552.00 $1,202,552.00 51,163,052.00
203,545.00 203,545.00 198,545.00
311,493.00 311,493.00 311,693.00
$19,500.00
5,000.00
(200.00)
1.62% - Fay Personnel due to vacancies and position turnover.
2.46% - Fav due to shift of postage to Internal service mail room.
-0.06% - Unfav misc. printing.
$1,717,590.00 ' $1,717,590.00 $1,693,290.00 $24,300.00 1.41%
Elections .
Controllable Personnel $424,946.00 $424,946.00 $417,748.00 $7,200.00 1.69% - Fav Personnel due to vacancies and position turnover.
Controllable Operating 411,000.00 411,000.00 $405,300.00 5,700.00 1.39% - Fay due to shift of postage to internal service mall room.
Non-Controllable Operating 108,038.00 109,852.00 115,752.00 (5,900.00) -5.37% - Unfav due to shift In postage to Internal service mall room.
$841,982.00 $945,798.00 $938,798.00 $7,000.00 0.74%
Register of Deeds
Controllable Personnel $4,461,719.00 $4,608,524.00 $4,894,324.00 ($285,800.00) -6.20% - Volume of activity continued at a higher rate than anticipated with the
change in the economy, resulting In higher use of Overtime. The Increase
In expenditures is offset by an Increase In revenue for the same reason.
$7.287,258.00 $7,362,619.00 $7,788,219.00 ($423,600.00) -5.75%
Jury Commission
Controllable Personnel
Controllable Operaiing
Non-Controllable Operating
$14,683.00 $14,683.00 14,583.00 $100.00 0.68% - Fav Personnel due to vacancies and position turnover.
48,107.00 48,107.00 43,707.00 4,400.00 9.15% - Fav due to shift of postage to Internal service mail room.
53,677.00 81,857.36 72,157.36 (10,500.00) -17.03% - Unfav due to shift in postage to Internal service mail room.
$116,467.00 $124,447.38 $130,447.38 ($8,000.06) -4.82%
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$8,707,881.00 $8,854,686.00 $7,093,986.00 ($239,300.00) • -3.49%
$2,390,590.00 $2,398,790.00 $2,274,090.00 $124,700.00 5.20%
$1,800,442.00 $1,733,719.78 $2,004,319.78 ($270,600.00) -15.81%
$10,898,913.00 $10,987,195.78 $11,372,395.78 ($385,200.00) -3.51%
31:111Wilni.111.2n•=7:
02/27/2002
• COUNTY OF OAKLAND
FY 2002 FIRST QUARTER FORECAST REPORT
EXPENDITURES
COUNTY TREASURER
AMOUNT
ADOPTED AMENDED FY 2002 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$44,500.00
51,300.00
(50,000.00)
Administration
Controllable Personnel $2,581,264.00 $2,585,518.00 $2,541,018.00
Controllable Operating 224,218.00 224,218.00 $172,918.00
Non-Controllable Operatin 771,248.00 841,149.49 $891,149.49
1.72% - Fav personnel due to vacancies and position turnover
22.88% - Fav postage and cost of Twp & City Treas bonds lower than contracted
-5.94% - Unfav due to shift in postage cost to internal svc mail room.
Division Total $3,576,730.00 $3,650,885.49 $3,605,085.49 $45,800.00 1.25%
Department Total $3,576,730.00 $3,650,885.49 $3,605,085.49 $45,800.00 1.25%
2/25/2002
COUNTY OF OAKLAND
FY 2002 FIRST QUARTER FORECAST REPORT
EXPENDITURES
BOARD OF COMMISSIONERS
AMOUNT
ADOPTED AMENDED FY 2002 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Library Board
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
• Controllable Operating
Non-Controllable Operating
$1,865,148.00 $1,865,148.00 $1,855,848.00
475,659.00 477,093.00 477,093,00
322,924:00 323,368.29 $323,368.29
$2,663,731.00 $2,665,609.29 $2,656,309.29
$961,590.00 $961,590.00 $961,590.00
736,180.00 736,180.00 736,180.00
993,757.00 996,018.86 996,018.86
$2,691,527.00 $2,693,788.86 $2,693,788.86
$2,826,738.00 $2,826,738.00 $2,817,438.00
1,211,839.00 1,213,273.00 1,213,273.00
1,316,681.00 1,319,387.15 1,319,387.15
$5,355,258.00 $5,359,398.15 $5,350,098.15
$9,300.00 0.50% - Turnover
0.00 0.00% -
0.00 0.00%
$9,300.00 0.35%
$0.00 0.00%
0.00 0.00%
0.00 0.00%
$0.00 0.00%
$9,300.00 0.33%
0.00 0.00%
0.00 0.00%
$9,300.00 0.17%
02/27/2002
COUNTY OF OAKLAND
FY 2002 FIRST QUARTER FORECAST REPORT
EXPENDITURES
DRAIN COMMISSIONER
AMOUNT
ADOPTED AMENDED FY 2002 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
Drain Commissioner
Controllable Personnel $2,383,459.00 $2,383,459.00 $2,383,459.00 0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
Controllable Operating 174,961.00 178,309.00 210,357.00 (34,048.00) -19.31% Unfav Grant Match (4,500), Professional Services (25,000) and Legal Notices (4,548) for
Water Quality Grant and Drain Redistricting costs.
Non-Controllable Operating 825,930.00 838,494.58 838,494.58 0.00%
Transfers (Out) 56,165.00 58,185.00 32,117.00 24,048.00 42.82% Fay. due to lower than anticipated requirement for maintenance on Chapter 4 drains.
A budget amendment is recommended.
Total $3,440,515.00 $3,454,427.58 $3,464,427.58 (610,000.00) -0.29%
Department Total $3,440,515.00 $3,454,427.58 93,464,427.58 (310,000.00) -0.29%
.xls 02/27/2002
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Emergency Response & Preparedness
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Auditing
Controllable Personnel
Controllable Operating
Non-Controllabli Operating
Corporation Counsel
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$0.00
0.00
0.00
0.00%
0.00%
0.00%
$0.00
0.00
0.00
0.00%
0.00%
0.00%
$0.00
0.00
0.00
0.00%
0.00%
0.00%
$0.00
0.00
0.00
0.00%
0.00%
0.00%
$0.00
0.00
0.00
0.00%
0.00%
0.00%
COUNTY OF OAKLAND
FY 2002 FIRST QUARTER FORECAST REPORT
EXPENDITURES
COUNTY EXECUTIVE
AMOUNT
ADOPTED AMENDED FY 2002 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$2,026,394.00 $2,026,394.00 $2,026,394.00
269,968.00 ' 270,173.00 270,173.00
418,023.00 418,367.18 418,367.18
$2,714,385.00 $2,714,934.18 $2,714,934.18 $0.00 0.00%
$0.00 $489,840.00 $489,840.00
0.00 1,051,024.00 $1,051,024.00
0.00 238,624.00 $238,624.00
$0.00 $1,779,488.00 $1,779,488.00 $0.00 0.00%
$1,129,292.00 $1,129,292.00 $1,129,292.00
30,385.00 30,624.00 30,824.00
252,885.00 253,118.61 253,118.61
$1,412,562.00 $1,413,034.61 $1,413,034.61 $0.00 0.00%
$1,690,556.00 $1,690,556.00 $1,690,556.00
49,929.00 50,120.00 50,120.00
228,175.00 228,250.12 228,250.12
$1,968,660.00 $1,968,926.12 $1,968,926.12 $0.00 0.00%
$4,846,242.00 $5,336,082.00 $5,336,082.00
350,282.00 1,401,941.00 1,401,941.00
899,083.00 1,138,359.91 1,138,359.91
$6,095,607.00 $7,876,382.91 $7,876,382.91 $0.00 0.00%
02/19/2002
COUNTY OF OAKLAND
FY 2002 FIRST QUARTER FORECAST REPORT
EXPENDITURES
MANAGEMENT AND BUDGET
AMOUNT
ADOPTED AMENDED FY 2002 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
Administration
Controllable Personnel $298,501.00 $298,501.00 $298,501.00 $0.00 . 0.00%
Controllable Operating 11,300.00 11,300.00 11,300.00. 0.00 0.00%
Non-Controllable Operating 9,281.00 9,281.00 9,281.00 0.00 0.00%
$319,082.00 ;319,082.00 $319,082.00 $0.00 0.00%
Purchasing
Controllable Personnel $915,464.00 $915,464.00 $915,464.00 $0.00 0.00%
Controllable Operating 41,662.00 57,539.00 57,539.00 0.00 0.00%
Non-Controllable Operating 135,277.00 142,749.64 142,749.64 0.00 0.00%
$1,092,403.00 $1,115,752.64 $1,115,752.64 $0.00 0.00%
Equalization
Controllable Personnel $6,339,036.00 $8,339,036.00 $6,339,038.00 $0.00 0.00%
Controllable Operating 408,441.00 413,841.00 413,841.00 0.00 0.00%
Non-Controllable Operating 1,528,897.00 1,777,052.23 1,777,052.23 0.00 0.00%
$8,276,374.00 $8,529,929.23 $8,529,929.23 $0.00 0.00%
Fiscal Services
Controllable Personnel $4,962,075.00 $4,959,180.00 $4,959,180.00 $0.00 0.00%
Controllable Operating 193,647.00 193,647.00 193,647.00 $0.00 0.00%
Non-Controllable Operating 838,575.00 898,165.12 898,165.12 $0.00 0.00%
$5,992,297.00 $6,050,992.12 $6,050,992.12 $0.00 0.00%
Reimbursement
Controllable Personnel . $1,857,296.00 81,895,898.00 $1,895,898.00 0.00 0.00%
Controllable Operating 116,315.00 116,315.00 116,315.00 0.00 0.00%
Non-Controllable Operating 439,752.00 465,760.59 485,760.59 0.00 0.00%
$2,413,383.00 $2,477,973.59 $2,477,973.59 • $0.00 0.00%
Department Total
Controllable Personnel $14,372,372.00 $14,408,079.00 $14,408,079.00 $0.00 0.00%
Controllable Operating 771,365.00 792,642.00 792,642.00 0.00 0.00%
Non-Controllable Operating 2,949,782.00 3,293,008.58 3,293,008.58 0.00 0.00%
$18,093,519.00 $18,493,729.58 $18,493,729.58 $0.00 0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
02/27/2002
$174,593.00 $230,436.05 $230,436.05
$1,067,273.00 $1,067,273.00 $1,153,701.00
46,505.00 46,505.00 46,505.00
981,067.00 985,488.95 985,488.95
$0.00
0.00
0.00
0.00
$0.00
($86,428.00) - (Unfav) due to (1) one Chiefs position not budgeted for FY2002. A budget amendment
is recommended.
60.00
$0.00
COUNTY OF OAKLAND
FY 2002 FIRST QUARTER FORECAST REPORT
EXPENDITURES
CENTRAL SERVICES
11n1.1•••nn••n•••••nnn•
ADOPTED AMENDED
BUDGET BUDGET
oveweswaadoon••n••nnnn•••••n
AMOUNT
FY 2002 FAVORABLE
FORECAST (UNFAVORABLE) EXPLANATION OF SIGNIFICANT VARIANCES
$159,711.00
1,575.00
13,307.00
Administrative
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Operating Transfer Out
Support Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Operating Transfer Out
$159,711.00 $159,711.00
1,575.00 1,575.00
15,650.05 15,650.05
53,500.00 53,500.00
$2,094,845.00 $2,099,266.95 $2,185,694.95 ($86,428.00)
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Operating Transfer
$1,226,984.00 $1,226,984.00 $1,313,412.00
48,080.00 48,080.00 48,080.00
994,374.00 1,001,139.00 1,001,139.00
0.00 ' 53,500.00 53,500.00
$2,269,438.00 $2,329,703.00 $2,416,131.00
($86,428.00)
0.00
0.00
0.00
($86,428.00)
02/27/2002
COUNTY OF OAKLAND
FY 2002 FIRST QUARTER FORECAST
EXPENDITURES
FACILITIES MANAGEMENT
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Facilities Engineering
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
AMOUNT
ADOPTED AMENDED FY 2002 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$305,575.00 $305,575.00 $305,575.00 $0.00 0.00%
23,200.00 23,200.00 23,200.00 0.00 0.00%
77,711.00 77,711.00 77,711.00 0.00 0.00%
$406,486.00 $406,466.00 $406,486.00 $0.00 0.00%
$910,552.00 $910,552.00 $905,552.00 $5,000.00 0.55% - Fay. Overtime based on anticipated usage to monitor construction projects.
260,450.00 260,450.00 260,450.00 0.00 0.00%
92,161.00 93,088.82 93,088.82 0.00 0.00%
$1,263,163.00 $1,264,090.82 $1,259,090.82 $5,000.00 0.40%
$1,218,127.00 $1,216,127.00 $1,211,127.00 $5,000.00 0.41%
283,650.00 283,650.00 283,850.00 0.00 0.00%
169,872.00 170,799.82 170,799.62 0.00 0.00%
$1,669,649.00 $1,670,576.82 $1,685,678.82 $5,000.00 0.30%
A
02/21/2002
$1,027,143.00 $1,027,143.00 $1,027,143.00
Department Total
Controllable Personnel $3,190,000.00 $3,194,084.00 $3,194,084.00
Controllable Operating 802,575.00 802,575.00 802,575.00
Non-Controllable Operating 633,501.00 662,453.94 662,453.94
COUNTY OF OAKLAND
FY 2002 FIRST QUARTER FORECAST REPORT
EXPENDITURES
PERSONNEL
AMOUNT
ADOPTED AMENDED FY 2002 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
m•••n•••••n•nn•••
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$288,767.00
10,519.00
10,554.00
$288,767.00 $288,767.00
10,519.00 10,519.00
11,513.94 11,513.94
.$0.00 0.00%
$0.00 0.00%
$0.00 0.00%
$309,840.00 $310,799.94 $310,799.94
Human Resources
Controllable Personnel $2,289,780.00 $2,293,864.00 $2,293,864.00
Controllable Operating 546,278.00 546,278.00 546,278.00
Non-Controllable Operating 453,035.00 481,028.00 481,028.00
$3,289,093.00 $3,321,170.00 $3,321,170.00
$0.00 0.00%
$0.00 0.00%
$0.00 0.00%
$0.00 0.00%
$0.00 0.00%
Employee Relations
Controllable Personnel $611,453.00
Controllable Operating 245,778.00
Non-Controllable Operating 169,912.00
$611,453.00 $611,453.00
245,778.00 245,778.00
169,912.00 169,912.00
XIX) 0.00%
0.00 0.00%
0.00 0.00%
-
$0.00 0.00%
$0.00 0.00%
0.00 0.00%
0.00 0.00%
$4,626,076.00 $4,659,112.94 $4,659,112.94 $0.00 0.00%
02/27/2002
$0.00
0.00
0.00
0.00%
0.00%
0.00%
$323,300.00
0.00
0.00
0.00
0.96%
0.00%
0.00%
COUNTY OF OAKLAND
FY 2002 FIRST QUARTER FORECAST REPORT
EXPENDITURES
HUMAN SERVICES
AMOUNT
ADOPTED AMENDED FY 2002 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$330,299.00 $330,299.00 5176,999.00 5153,300.00 46.41% - (Fay) Salaries & Fringe Benefits due to abolishment of Healthy/Start Healthy Families
10-01-01, and deletion of Fringe Benefits for Chairperson and two regular Board members
for Family Ind. Agency. A budget amendment is recommended.
9,696,391.00 9,696,391.00 9,696,391.00 0.00 0.00%
17,836.00 17,946.25 17,946.25 0.00 0.00%
$10,044,526.00 $10,044,636.25 $9,891,336.25 $153,300.00 1.53%
Health
Controllable Personnel $23,183,728.00 523,183.728.00 $23,183,728.00
Controllable Operating 4,153,510.00 4,171,192.00 4,171,192.00
Non-Controllable Operating 3,122,996.00 ' 3,353,734.18 3,353,734.18
Operating Transfer Out 0.00
530,460,234.00 $30,708,654.18 $30,708,654.18 50.00 0.00% ,
•
Children's Village
Controllable Personnel 610,080,290.00 $10,060,290.00 59,910,290.00 $170,000.00 1.69% - (Fay) Salary 2 Fringe Benefits due to delay of expansion to the Secure Detention Facility
(J Bldg.) tentatively until 612002.
Controllable Operating 3,065,033.00 3,065,033.00 3,065,033.00 0.00%
Non-Controllable Operating 2,224,472.00 2,238,268.50 2,236,266.50 0.00%
$15,369,795.00 $15,353,591.50 $15,213,591.50 5170,000.00 1.11%
Department Total
Controllable Personnel $33,594,317.00 533,594,317.00 $33,271,017.00
Controllable Operating 16,914,934.00 16,932,616.00. 16,932,616.00
Non-Controllable Operating 5,365,304.00 5,609,948.93 5,609,948.93
Operating Transfer Out 0.00 0.00 0.00
$55,874,555.00 $56,136,881.93 $55,813,581.93 $323,300.00 0.58%
mismermatammas acmg.s.weestans sranusramecaase. cant
02/19/2002
Public Services - Admin.
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$147,253.00
7,800.00
7,908.00
$147,253.00
7,800.00
7,908.00
$147,253.00
7,800.00
7,908.00
$0.00
0.00
0.00
0.00%
0.00%
0.00%
Animal Control
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$1,449,774.00
120,888.00
518,440.00
$1,449,759.00
120,888.00
520,028.85
$1,432,159.00
120,888.00
520,028.85
$17,600.00
0.00
0.00
1.21% - Turnover
0.00%
0.00%
Circuit Cowl Probation
Controllable Personnel
- - Controllable Operating
Non-Controllable Operating
$0.00
51,539.00
849,763.00
$0.00
82,439.00
854,641.42
$0.00
82,439.00
854,641.42
0.00
0.00
0.00
0.00%
0.00%
0.00%
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
50.00 0.00%
$112,100.00
2,150.00
0.00
1.35%
0.11%
0.00%
COUNTY OF OAKLAND
FY 2002 FIRST QUARTER FORECAST REPORT
EXPENDITURES
PUBLIC SERVICES
AMOUNT
ADOPTED AMENDED FY 2002 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$162,961.00 $162,961.00 $162,961.00 $0.00 0.00%
Veteran's Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
*1,324,534.00 $1,324,534.00 $1,322,034.00
308,147.00 308,147.00 308,147.00
233,375.00 233,375.00 233,375.00
$2,500.00
0.00
0.00
0.19% - Turnover
0.00%
0.00%
$1,866,056.00 $1,866,056.00 $1,863,556.00 $2,500.00 0.13%
Community Corrections
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$2,631,998.00 $2,633,566.00 $2,547,566.00
797,635.00 797,832.00 755,832.00
415,115.00 417,551.02 417,551.02
$86,000.00 3.27% - Salary & Fringe fay. $93,000 due to turnover; partially offset by unbudgeted Overtime ($7,000)
42,000.00 5.26% - Change in court criteria eliminated participants once eligible for the Virtual Reality Step Down
program resulting In fay. Contractual Services $42,000; offset In unfav. Revenue.
0.00 0.00%
$3,844,748.00 $3,848,949.02 ' $3,720,949.02 $128,000.00 3.33%
MSU Ext. - Oakland County
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$684,324.00 $684,324.00 $678,324.00 $8,000.00 0.88% - Turnover
120,234.00 120,472.00 150,322.00 (29,850.00) -24.78% - Appropriation for Reoognition Events and Workshops & Meetings needed to generate revenue
351,340.00 351,837.56 351,837.56 0.00 0.00% through ticket sales and registration fees. A budget amendment is recommended.
Medical Examiner
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$1,155,898.00 $1,156,633.56 $1,180,483.56
$2,072,921.00 52072,921.00 52,072,921.00
608,512.00 608,51200 618,512.00
939,638.00 959,300.60 959,300.60
($23,850.00) -2.08%
0.00%
($10,000.00) -1.64%- Unfav. Medical Services Autopsies reflected in fay. Autopsies revenue.
0.00%
$3,621,069.00 $3,640,733.60 $3,650,733.60 ($10,000.00) -0.27%
$2,089,102.00 $2,090,875.85 52,073,075.85 $17,600.00 0.84%
$901,302.00 5117,080.42 5917,080.42
$8,310,804.00 $8,312,357.00 $8,200,257.00
2,014,755.00 2,026,090.00 2,023,940.00
3,315,577.00 3,344,642.41 3,344,642.45
$13,641,136.00 $13.683.089.45 $13,588,839.45 $114,250.00 0.83%
Sig111anWrig.i.=:512 itinr.11131.7t0==== in111.M.WO.SIMISMS-Mtrilt
02/21/2002
$2,862,124.00
678,589.00
756,898.80
$2,827,124.00
678,589.00
758,898.80
0.00% -
$0.00 0.00%
COUNTY OF OAKLAND
• FY 2002 FIRST QUARTER FORECAST REPORT
EXPENDITURES
COMMUNITY AND ECONOMIC DEVELOPMENT
AMOUNT
ADOPTED AMENDED FY 2002 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$504,549.00 $504,549.00 $504,549.00 0.00% -
469,605.00 469,605.00 489,605.00 0.00% -
49,690.00 51,202.00 61,202.00 0.00% -
$1,023,844.00 $1,025,356.00 81,025,356.00 $0.00 0.00%
Planning and Economic Development Services
Controllable Personnel $2,662,124.00
Controllable Operating 677,710.00
Non-Controllable Operating 755,977.00
$35,000.00 1.22% - - Salaries and Fringe Benefits fay, due to turnover and positions filled below budget.
0.00% -
0.00% -
$4,295,811.00 $4,297,611.80 $4,262,611.60 $35,000.00 0.81%
Community and Home Improvement
Controllable Personnel $0 $0 $0
Controllable Operating 335,250.00 335,250.00 335,250.00
Non-Controllable Operating 0 0 0
$335,250.00 $335,250.00 $335,250.00
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Operating Transfer
$3,366,673.00
1,482,565.00
805,667.00
0.00
$3,366,673.00
1,483,444.00
808,100.80
0.00
$3,331,673,00
1,483,444.00
8013,100.80
0.00
$35,000.00
0.00
0.00
0.00
1.04%
0.00%
0.00%
0.00%
$5,654,905.00 $5,658,217.80 $5,623,217.80 $35,000.00 0.62%
02/21/2002
COUNTY OF OAKLAND
FY 2002 FIRST QUARTER FORECAST REPORT
EXPENDITURES
COMMUNITY AND ECONOMIC DEVELOPMENT/WORKFORCE DEVELOPMENT
AMOUNT
ADOPTED AMENDED FY 2002 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
Workforce Development
Controllable Personnel $628,211.00 $628,211.00 $628,211.00 $0.00 0.00% -
Controllable Operating 303,706.00 303,907.00 $303,907.00 $0.00 0.00%
Non-Controllable Operating 94,982.00 94,982.00 $94,982.00 $0.00 0.00%
$1,026,899.00 $1,027,100.00 $1,027,100.00 $0.00 0.00%
Department Total
Controllable Personnel $628,211.00 $628,211.00 $628,211.00 $0.00 0.00%
Controllable Operating 303,706.00 303,907.00 303,907.00 0.00 0.00%
Non-Controllable Operating 94,982.00 94,982.00 . 94,982.00 0.00 0.00%
Operating Transfer 0.00 0.00 0.00 0.00 0.00%
$1,026,899.00 $1,027,100.00 $1,027,100.00 $0.00 0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
02/27/2002
BUDGET
AS
ADJUSTED
FY 2002
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
2 500 000.00
$ 15,781,718.00 $ 15,781,716.00 $15,781,716.00 $
2,500,000.00 , 2,500,000.00
COUNTY BUILDINGS (2200001320000) $ 3,027,997.00 $ 2,920,519.89 $2,920,519.89 $0.00 0.00%
-
(34,370.00)
(7,000.00)
(41,370.00)
(120,200.00)
BUDGET
AS
ADOPTED
NON-DEPARTARTMENT APPROPRIATIONS
COUNTY OPERATIONS
Property Taxes Expenditures (210000)
Ambulance
Doctors/Hospital
Insurance Surety Bonds 91,300.00
Road Convnission1Tri Party Agreement 2,250,000.00
Road Commission1Current Drain Assessment 1,300,000.00
GIS Automation -
Mental Health Authority 9,620,616.00
Senior Citizen Prescriptions
MAN/WAN
Total
$ 19,800.00
91,300.00 91,300.00
2,250,000.00 2,250,000.00
1,300,000.00 1,300,000.00
9,620,816.00 9,820,618.00
19,800.00 $ 19,800.00
STATE AND FEDERAL - COUNTY ASSOCIATIONS (230000)
(197,441.00)
Area Wde VVater Quality
Clinton River Watershed Council
Huron River Watershed Council
Michigan Assoc. of Counties
National Assoc. of Counties
Partnership for Saginaw River Watershed
Rouge River Watershed Council
S.E.M.C.O.G.
Traffic improvement Association
Total
SUNDRY EXPENSE (2400001270000)
RESERVED FOR TRANSFERS (290000)
Expenditures
Basic Readjustment
Contingency
$ 55.000.00 $ 55,000.00
5,141.00 5,141.00
2,706.00 2.706.00
62,000.00 62,000.00
20,800.00 20,800.00
$2,177.00 $2,177.00
2,276.00 2,276.00
481,000.00 481,000.00
23,000.00 23,000.00
$ 654,100.00 $ 654,100.00
$ 300,000.00 $ 300,000.00
$ 55,000.00 $
5,141.00
2,706.00
62,000.00
20,800.00
2,177.00
2,276.00
515,370.00
30,000.00
$ 695,470.00
420,200.00
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
-7.15% Due to Increase In membership dues. A budget amendment Is recommended.
-30.43% Based on actual charges for dues. A budget amendment is recommended.
-6.32%
-40.07% Prior Years Expense.
0.00%
-157.35% Due to several items requested by resolution during the 1st quarter, the Contingency
account is cumsntly reflecting a deficit. A budget amendment is recommended to
replenish thls account.
$ 932,496.00 $ 932,498.00 $ 932,496.00
248,321.00 125,478.00 322,919.00
52,000.00
265,000.00
400,000.00
195,200.00
6,393,808.00
239,959.00
1
Defense Attorney Fees
Fees/Per Diem
Insurance Reserve Expense
Juror Fees & Mileage
Legislative Expense
Info Tech Development
Classification and Rate Change
Frityraenefit Adjustment
52,000.00
265,000.00
400,000.00
195,200.00
5,462,433.90
163,788.00
(23,425.00)
52,000.00
265,000.00
400,000.00
195,200.00
5,482,433.90
163,786.00
(23,425.00)
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00% Projected negative expense as a transfer was made per MR #01332 tlys2p28eit
300,000.00 298,099.00
(90,110.00)
$3,122,200.00
5,035,000.00
289,500.00
5,000,000.00
55,700.00
1,408,000.00
$3,122,200.00 $
5,035,000.00
269,500.00
5,000,000.00
• 55,700.00
1,408,000.00
80.00 0.00%
24,200,893.18
15,043,548.50
15.000.00
$39,259,441.68
24,200,893.18
15,043,548.50
15,000.00
$39,259,441.68 $
0.00%
0.00%
0.00%
0.00%
TOTAL EXPENDITURES $ 84,320,311.00 S 83,266,858.47 $ 83,625,869.47 $ (359,011.00) -0.43%
Officers Association Labor Agreement. A budget amendment is recommended.
Office Automation
Salary Adjustment
Emergency Salaries
Overtime Appropriation
Summer Employees Salary Appropriation
Misc. Capital Outlay
Total
298,099.00
(90,110.00)
1,025,500.00 1,026,500.00 1,026,500.00 -
53,000.00 63,000.00 53,000.00 -
532,000.00 • 532,000.00 532,000.00 -
75,000.00 48,223.00 48,223.00 -
$ 10,711,282.00 $ 9,440,680.90 $ 9,638,121.90 $ (197,441.00)
0.00%
0.00% Projected negative expense as a transfer was made per MR #01332 for Command
Officers Association Labor Agreement. A budget amendment is recommended.
0.00%
0.00%
0.00%
0.00%
-2.09%
Transfers to Other Funds (Property Tax Transfers - 3100001
General Activities -
Transfer to Bldg Authority $3,122,200.00
Transfer to Bldg Fund 5,035,000.00
Information Technology Fund 250,000.00
Environmental Infrastructure 5,000,000.00
Oak. Enhancement-Community Partnership 55,700.00
Transfer to CLEMIS 1,408,000.00
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
Total $ 14,870,900.00 $14,910,400.00 $14,910,400.00
TOTAL NON-DEPT. APPROPRIATIONS $ 45,345,995.00 $ 44,007,416.79 $ 44,366,427.79 $ (359,011.00) -0.82%
t t =an ir,15==.71.===.,-ZU=1 flfl
TRANSFER TO GENERAL PURPOSE FUNDS (310000)
Health Fund 23,952,473.00
Juvenile Maintenance Fund 15,008,843.00
Social Welfare Fund 15,000.00
$38,974,316.00
90.xls 2 02/27/2002
EXPLANATION OF SIGNIFICANT VARIANCES
SHERIFF'S DEPARTMENT
INTERNAL SERVICE FUNDS
FY 2002 FIRST QUARTER FORECAST REPORT
ADOPTED
BUDGET
SHERIFF AVIATION #680
OPERATING REVENUES: '
Outside Revenue
AMENDED FY 2002 VARIANCE
BUDGET FORECAST FAVNUNFAVI
$0.00 $0.00
Inside Revenue
Total Revenue
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
NON-OPERATING REVENUE
OPERATING TRANSFERS IN
NET REVENUES OVER(UNDER)
649,532.00 1,770,680.00 1,470,680.00 ($300,000.00) - Based on estimated expenses. Note, favorabIllty In General Fund Sheriffs budget.
$649,532.00 $1,770,680.00 $1,470,680.00 ($300,000.00)
$449,532.00 $1,570,680.00 $1,033,180.00 $537,500.00 - Fav. Contollable Operating Expenditures
$200,000.00 $200,000.00 $437,500.00 $237,500.00
$0.00 $0.00 0.00 $0.00
$0.00 $0.00 $0.00 $0.00
EXPENSES $200,000.00 $200,000.00 $437,500.00 $237,500.00
=EMI
iffAviationForecastads 02127/2002
FY 2002 FIRST QUARTER FORECAST REPORT
INTERNAL SERVICE FUNDS
DEPARTMENT OF CLERK/REGISTER OF DEEDS
ADOPTED AMENDED FY 2002 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) EXPLANATION OF SIGNIFICANT VARIANCES
.•nnn Affin...•n•n•••••••••n••••••/fts..~.n• asow.o.o~a.rmemiookowar~~~...••n••nn•••n•••n••nnn••n~Ooratompronake
IMICROGRAPHICS FUND #654
REVENUES
Outside $200,000 $382,000 $382,000 $0
Inside 678,541 415,860 415,860 0
Total Revenues $878,541 $797,860 $797,860 $0
OPERATING EXPENSES $917,541 $917,541 $900,941 $16,600 Fav personnel due to vacancies and position turnover.
NET NON-OPERATING REV $39,000 $39,000 $39,000 $0
REVENUE OVER (UNDER)
EXPENDITURES $0 ($80,681) ($64,081) $16,600
MICROGRAPHICS.xls 2/25/2002
0.00 2,521,166.00 2,601,166.00 2,601,166.00 Total Revenue
OPERATING EXPENSES 3,532,338.00 3,612,338.00 3,612,338.00 0.00
DEPARTMENT OF DRAIN COMMISSIONER
DRAIN EQUIPMENT FUND
FY 2002 FIRST QUARTER FORECAST REPORT
OPERATING REVENUES:
Outside
ADOPTED AMENDED FY 2002 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)
2,271,166.00 2.351,166.00 2,351,166.00 0.00
EXPLANATION OF SIGNIFICANT VARIANCES
Inside 0.00 250,000.00 250,000.00 250,000.00
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
(1,011,172.00) (1,011.172.00) (1,011,172.00) 0.00
NON-OPERATING REVENUE/(EXPENSE) 74,592.00 74,592.00 74,592.00 0.00 .
OPERATING TRANSFER IN 936,580.00 936,580.00 0.00 (936,580.00) A budget amendment Is needed to transfer funds from Designated Fund Balance for Drain Records
conversion.
OPERATING TRANSFERS (OUT) 0.00 0.00 0.00 0.00 .
NET REVENUES OVER(UNDER) 0.00 0.00 (936,580.00) (936,580.00) .
' EXPENSES 311:C=..-,Z s__ _a IC= 1:21=MR.I.31K3= C. -------7.13
MAIN INTERNAL FOREads 2/26/2002
$4,322,974.00 $4,322,974.00 $4,322,974.00
RISK MANAGEMENT
INTERNAL SERVICE FUND
FY 2002 FIRST QUARTER FORECAST REPORT
ADOPTED
BUDGET
LIABILITY INSURANCE FUND (#677)
AMENDED FY 2002 VARIANCE
BUDGET FORECAST FAV/(UNFAV) EXPLANATION OF SIGNIFICANT VARIANCES
*REVENUE
OPERATING EXPENSE
CLAIMS PAID
TOTAL EXPENSES
NET REVENUES OVER/(UNDER)
EXPENSES
$4,322,974.00 $4,322,974.00 $3,322,974.00 ($1,000,000.00) (Unfav) due to reduction in charges to Depts.for administration of
self-insurance fund.
$1,515,452.00 $1,515,452.00
$0.00 Adjustment of Liability Insurance claim-year reserves will be determined
by fiscal year-end analysis of claims and reserve requirements.
$0.00
$0.00 $0.00 ($1,000,000.00) ($1,000,000.00)
$1,515,452.00 $0.00
$2,807,522.00 $2,807,522.00 $2,807,522.00 $2,807,522.00 $2,807,522.00 $2,807,522.00
• LIABILITY INSURANCE.xls 02/26/2002
OPERATING INCOME
NET NON-OPERATING REV (EXP)
($86,410.00) ($86,410.00) ($23,682.00) $62,728.00
$86,410.00 $86,410.00 $38,251.00 ($48,159.00) - Unfavorable interest income due to lower cash on hand
and lower interest rates.
DEPARTMENT OF MANAGEMENT AND BUDGET
INTERNAL SERVICE FUND
FY 2002 FIRST QUARTER FORECAST REPORT
OFFICE EQUIPMENT FUND (664)
OPERATING REVENUE-Inside
OPERATING EXPENSE
ADOPTED AMENDED FY 2002 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)
$545,472.00 $545,472.00 $607,008.00 $81,536.00
$631,882.00 $631,882.00 $630,690.00 $1,192.00
EXPLANATION OF SIGNIFICANT VARIANCES
•n•n•••••nnn••/./.......•••n••••••••n••n•,.....oweN•••••n•n•••n•nnn••n•n•••n••••n•••••nn•n•n•./...
Favorable-new Mailroom & Health rental less
mammography machine.
Operating Expense generally favorable with offsetting
unfavorable variance projected for Indirect Coss ($19,500).
INCOME (LOSS) BEFORE OPERATING
TRANSFERS
OPERATING TRANSFERS IN
OPERATING TRANSFERS OUT
• $0.00
$0.00
$0.00
$0.00 $14,569.00 $14,569.00
$0.00 $0.00 $0.00
$0.00 $0.00 $0.00
NET REVENUES OVER/(UNDER)
EXPENSES
$0.00 $0.00 $14,569.00 $14,569.00
EQUIPMENT INTERNAL FORE.xls 02/26/2002
REVENUE
RETIREES HOSPITALIZATION
RETIREMENT ADMINISTRATION
TUITION REIMBURSEMENT
EMPL. DEFERRED COMP. ADMIN.
EMPL. DEFERRED COMP. COUNTY
EMPLOYEE IN-SERVICE TRAINING
DEFINED CONTRIBUTION PLAN
DEFINED CONTRIBUTION ADMIN.
GROUP LIFE
HOSPITALIZATION
SOCIAL SECURITY
DENTAL INSURANCE
OPTICAL INSURANCE
DISABILITY INSURANCE
SHORT-TERM DISABILITY
FORFEITURES
WORKERS COMPENSATION
UNEMPLOYMENT COMPENSATION
FLEXIBLE BENEFIT DEDUCTIONS
INVESTMENT INCOME
TOTAL REVENUE
I EXPENSE
FRINGE BENEFITS FUND
INTERNAL SERVICE FUNDS
FY 2002 FIRST QUARTER FORECAST REPORT
ADOPTED AMENDED FY 2002 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) EXPLANATION OF SIGNIFICANT VARIANCES
$15,751,000 $15,751,003 $15,651,900 ($99,100)
3,751,972 3,751,972 3,724,072 (27,900)
318,250 318,250 313,350 (4,900)
42,275 42,275 42,275 0
720,765 720,765 • 720,765 0
1,658,001 1,658,001 1,631,901 (26,100)
8,945,200 8,945,200 8,895,600 (49,600)
11,400 11,400 11,400 0
837,900 837,900 820,500 (17,400)
22,619,500 22,819,500 22,619,500 0
13,708,500 13,708,500 13,708,500 0
2,812,950 2,812,950 2,835,050 22,100
410,210 410,210 404,910 (5,300) -
616,170 616,170 • 611,270 (4,900)
1,243,835 1,243,835 1,319,635 75,800
215,500 215,500 215,500 0 , "
2,176,260 2,176,260 2,176,260 0
213,750 213,750 208,750 (5,000)
277,400 277,400 555,300 277,900 -Employee contributions for enhanced coverage in the Flexible Benefits Program.
2,000,000 2,000,000 1,860,000 (140,000) -Interest rates lower than expected.
$78,330,838 $78,330,838 $78,326,438 ($4.400)
'FRINGE BENEFITS FUND (#678)
RETIREES HOSPITALIZATION
RETIREMENT ADMINISTRATION
SICK/ANNUAL LEAVE CASH-IN
TUITION REIMBURSEMENT
EMPL. DEFERRED COMP. ADMIN.
EMPL DEFERRED COMP. COUNTY
EMPLOYEE IN-SERVICE TRAINING
IN-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
CHILD CARE FACILITY
INDIRECT COSTS
TOTAL EXPENSE
$16,580,000 $16,580,000 $20,521,600 ($3,941,600) -Budget was established prior to receipt of latest actuarial calculation. Fringe Benefits Fund will absorb increase.
3,949,444 3,949,444 630,444 3,319,000 -Converted Investment advisory, actuarial, custodial fees, and incidental expenses per MR#01217.
1,250,000 1250,000 1,236,200 13,800
335,000 335,000 306,900 28,100
44,500 44,500 26,000 18,500
758,700 758,700 758,700 .(- 0 •
1,189,384 1,189,384 1,178,384 11,000
550,000 550.000 505,000 45,000
9,416,000 9,416,000 9,514,400 (98,400)
12,000 12,000 8,900 3,100 .
882,000 882,000 816,200 65,800
23,810,000 23,810,000 23,865,700 (55,706) ,
14;60,000 14,430,000 . 14,390,500 39,500
2,961,000 2,961,000 2,886,900 74,100
431,800 431,800 391,400 40,400
•
1,957,900 1,957,900 1,957,900 0
. 292,000 292,000 418,800 (126,800) -Payments to employees for reduced coverage in the Flexible Benefits Program.
156,000 229,435 214,435 15,000 .
2,290,800 2,290,800 2,103,500 187,300 -Adjustment of Workers Compensation claim-year reserves will be determined by fiscal year-end analysis
225,000 225,000 160,000 65,000 of claims and reserve requirements.
85,346 85,346 88,148 (2,800)
175,900 175,900 184,700 (8,800)
265,520 265,520 265,520 0
$82,048,294 $82,121,729 $82,430,029 ($308,300) -
REVENUE OVERI(UNDER) EXPENSE ($3,717,458) ($3,790,891) ($4,103,591) ($312,700)
FRINGE BENEFITS.xls 02/26/2002
DEPARTMENT OF CENTRAL SERVICES
INTERNAL SERVICE FUNDS
FY 2002 FIRST QUARTER FORECAST REPORT
ADOPTED
BUDGET
MOTOR POOL FUND 661
AMENDED
BUDGET
FY 2002
FORECAST
VARIANCE
FAVI(UNFAV) EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING REVENUE
OPERATING EXPENSE
OPERATING INCOME (LOSS)
NON-OPERATING REVENUE (EXPENSE)
65,501,206.00 65,584,871.00 $5,846,686.00 6261,815.00 - Favorable due to Billings higher than budgeted amounts.
6,163,710.00 6,439,240.00 6,548,894.00 (109,454.00) Unfavorable due to indirect costs
($662,504.00) ($854,369.00) ($702,008.00) $152,361.00
(38,093.00) - Unfavorable due to decrease In Interest Income. 550,000.00 550,000.00 511,907.00
NET INCOME (LOSS) BEFORE OPERATING
TRANSFERS
OPERATING TRANSFERS IN
NET INCOME (LOSS)
(112,504.00) (304,369.00) (190,101.00)
55,800.00 301,165.00 . 301,165.00
($56,704.00) ($3,204.00) $111,064.00
114,268.00
0.00
$114,268.00
MAILING, CONVENIENCE COPIER AND PRINTING FUND 667
$3,385,722.00 $3,385,722.00 $3,091,751.00 ($293,971.00) - Unfavorable ($517,500) due to transfer of stationery stock from Materials Management.
3,208,481.00
177,241.00
0.00
$177,241.00
2,954,922.00
136,829.00
0.00
$136,829.00
OPERATING REVENUE
OPERATING EXPENSE
OPERATING INCOME(LOSS)
NON-OPERATING REVENUE(EXPENSE)
NET INCOME (LOSS)
• 3,208,481.00
177,241.00
0.00
$177,241.00
$253,559.00 - Favorable due to turnover and lower usage of stationery stock than anticipated.
(40,412.00)
0.00
($40,412.00)
SUPPORT SERVICES.xls 02127/2002
grant funding of 20,600.
- Fay Salaries 175,000 and Fringe Benefits 70,000 for turnover; fay Natural Gas costs 97,560
based on current purchase contracts and anticipated usage; partially offset by unfav Indirect
Costs (99,900) which include costs for 3 positions previously charged to FM&O Fund salaries
and fringe benefits; unfav Maintenance Supplies (50,000) and Leased Vehicles (9,800) based
on current usage rates.
- Income from Investments less. than anticipated due to lower interest rates.
$0.00
$0.00
$0.00
OPERATING TRANSFERS IN
OPERATING TRANSFERS (OUT)
42,630.00 42,830.00 42,830.00 0.00
$0.00 $0.00 $0.00 $0.00
DEPARTMENT OF FACILITIES MANAGEMENT
INTERNAL SERVICE FUNDS
FY 2002 FIRST QUARTER FORECAST REPORT
ADOPTED
BUDGET
FACILITIES MAINTENANCE & OPERATIONS (#631)
AMENDED
BUDGET
FY 2002
FORECAST
VARIANCE
FAV/(UNFAV) EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING REVENUES:
Outside Revenue
Inside Revenue
Total Revenue
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
NON-OPERATING REVENUE
OPERATING TRANSFERS IN
NET REVENUES OVER(UNDER)
EXPENSES
$1,130,500.00 $1,130,500.00
22,625,082.00 22,625,082.00
$23,755,582.00 $23,755,582,00
$23,934,582.00 $23,934,582.00
($179,000.00)
$125,000.00
$54,000,00
$0.00
$1,033,000.00
22,833,382.00
$23,866,382.00 $110,800.00
$23,751,782.00 $182,800.00
$114,600.00
92,500.00
$54,000.00
$281,100.00 $261,100.00
($179,000.00)
$125,000.00
$54,000.00
$0.00
$293,600.00
($32,500.00)
$0.00
($97,500.00) - Renegotiation of lease contract with CMH to reflect reduced space occupied in CMH Center
facility will lower lease payments to the County.
208,300.00 - Based on projection of building space charges to departments and receipt of snow emergency
1PONTIAC MARKET (#261)
OPERATING REVENUES - OUTSIDE
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
$115,524.00 $115,524.00 $115,524.00
$158,354.00 $158,354.00 $158,354.00
($42,830.00) ($42,830.00) ($42,830.00)
NET REVENUES OVER(UNDER)
. EXPENSES
FACILITIES INTERNAL FOREAls 02/21/2002
2======
DEPARTMENT OF INFORMATION TECHNOLOGY
INTERNAL SERVICE FUNDS
FY 2002 FIRST QUARTER FORECAST REPORT
ADOPTED AMENDED FY 2002 VARIANCE
BUDGET BUDGET FORECAST FAVAUNFAV)
Information Technology. Operations (636)
COMMENTS
OPERATING REVENUES:
Outside 32,099,752.00 32.099,752.00 32,164,795.00 $65,043.00 - Fay. $20,823 IT Development rev, due to 111X bills, & $7,835 Income from investments & Interest
Inside 21.813,295.00 21,953,528.00 21,953,528.00 0.00 penalty as well as $36,385 gain on equipment.
Prior Years Balance 0.00 0.00 0.00 0.00 -
OPERATING TRANSFERS IN 250,000.00 289,500.00 ' 289,500.00 0.00 -
Total 24,163,047.00 24,342,780.00 24,407,823.00 65,043.00
OPERATING EXPENSES 35,105,504.00 35,264,237.00 35,230,267.00 33,970.00 - Fair. Due to salary & fringes $876,016 due to vacancies, compenstated by contractual services ($815,509),
commodities 01(313,522) reflects a high use of office supplies, and & ($13,014) for mail room expenses
that will be moved to the budget line item.
OPERATING TRANSFERS (OW)
OPERATING INCOME (LOSS)
0.00 0.00 0.00 0.00 -
($10,942,457.00) ($10,921,457.00) ($10,822,444.00) $99,013.00
112=OLGOIMM=.111 W=SIIMMIBIg.=1. ICIMM:12MMItiMMOIN WIRIMMISMIUSI=SIS
Information Technology.- Telephone Communications (676)
OPERATING REVENUES:
Outside
Inside
OPERATING TRANSFERS IN
$83,247.00 $83,247.00 $83,255.00 $0.00 .
4,492,786.00 4,492,786.00 3,643,575.00
0.00 0.00 0.00 '
(649,211.00) - Untav. largely due to Internal Sale of Phone Service ($849,211) the new line service charge had
0.00 not been implemented yet, IT Is waiting on Telesoft to paralell our billing cycle.
Total 4,576,033.00 4,576,033.00 3,726,830.00 (849,211.00)
OPERATING EXPENSES " , 4,576,033.00 4,576,033.00 4,559,118.00 16,895.00 - Fay. due to salaries and fringe benefits positions filled below the budget.
OPERATING TRANSFERS (OUT) 0.00 0.00 . 0.00 0.00
OPERATING INCOME (LOSS) $0.00 $0.00 ($832,308.00) ($832,316.00)
Information Technology. CLEMIS (635)
OPERATING REVENUES:
Outside
Inside
3PERATING TRANSFERS IN
$1,253,772.00 $1,253,772.00 $1,301,928.00
1,074,322.00
1,420,250.00 ,
$48,156.00 • Investment revenue Is still favorable due to monies being held back from Ameritech
(E-911equipment).
116,959.00 - Fay. rec'd $115,959 for non-cash capital contributions from COPS MORE Fund.
0.00 -
1,072,750.00
1,408,000.00
1,191,281.00
1,420,250.00
INFO TECH FORE.xls 1 03/0812002
ADOPTED
BUDGET
3,734,522.00
9,721,068.00
Fey. DUO to InVeStInant Of E-911 Surcharge revenue.
Fay. $26,579 due to additional monies collected from Zurich, $3,450 due to software loads on
MDC equipment being performed on Radio staff, $3,616 Is for rebilled charges.
Unfav, due to salary & fringes ($6,784) overtime and on-call expenses for multiple projects,
($123,260) largely due to equipment repairs for current system, ($22,531) largely due to expandable
equip and ($11,267) dye to the PBX system not being operational at the time period orinally planned.
Fay. Due to Investment of E-911 Surcharge revenue.
$4,247,974.00
$124,600,00
390,424.00
0.00
0.00 . 390,424.00 390,424.00
0.00 0.00 0.00
515,024.00 515,024.00 480,397.00 (34,627.00)
(127,158.00) 642,182.00 515,024.00 515,024.00
0.00 0.00 0.00 0.00
Total
OPERATING EXPENSES
OPERATING TRANSFERS (OUT)
Unfav, largely due to overtime pay, underbudgeted sal & frg. ($11,997), unfav. contracual services
of ($1,631), expendable equip ($3,008). IT programmer development ($106,704), and Telephone
Communication ($3,818).
' OPERATING INCOME (LOSS) $0.00 ($161,785.00) ($161,785.30) $0.00
DEPARTMENT OF INFORMATION TECHNOLOGY
INTERNAL SERVICE FUNDS
FY 2002 FIRST QUARTER FORECAST REPORT
Total
OPERATING EXPENSES
OPERATING INCOME (LOSS)
AMENDED FY 2002 VARIANCE
BUDGET FORECAST FAW(UNFAV)
3,748,344.00 3,913,459.00 165,115.00
9,722,640.00 10,073,638.00 (350,998.00)
($5,986,546.00) ($5,974,296.00) ($6,160,179.00) ($185,883.00)
COMMENTS
Unfav. due ($257,428) salary and fringes delays In the COPS MORE project, ($127) small tools
to provide the Livescan equip mad, ($93,443) internal services Is more than allowed under the
$900,000 cap. The additional amount Is for a vehicle and pagers to be used by the Uvescan
customer service technician.
Information Technology - Radio Communications (660)
OPERATING REVENUES - OUTSIDE $7,467,967.00
OPERATING REVENUES - INSIDE 996,531.00
TOTAL OPERATING REVENUE 8,464,498.00
OPERATING EXPENSE 4,256,524.00
OPERATING INCOME (LOSS) 4,207,974.00
NON-OPERATING REVENUE (EXPENSE) _ 40,000.00
NET INCOME (LOSS) BEFORE OPERATING 4,247,974.00
TRANSFERS
$7,467,967.00 7,567,967.00 100,000.00
1,008,390.00 1,042,035.00 33,645.00
8,476,357.00 8,610,002.00 • 133,645.00
4,268,383.00 4,432,225.00 (163,842.00)
4,207,974.00 4,177,777.00 (30,197.00)
40,000.00 200,000.00 160,000.00
4,247,974.00 4,377,777.00 129,803.00
OPERATING TRANSFERS IN 0.00 31,875.00 31,675.00 0.00
NET INCOME (LOSS)
Fire Records Management-Fund 531
OPERATING REVENUES:
Outside
Inside
OPERATING TRANSFERS IN
$4,279,649.00 $4,409,452.00 $129,803.00
$124,600.00 $89,973.00 ($34,627.00) - Unfav.($34,900) due to delay In Implementation, offset by fay. Invest. Income of $273.
1=====219.1 =2=11==== =G=17...121-42=
2 03/08/2002 INFO TECH FOREAls
FY 2002 BUDGET AMENDMENTS
FY 2002 BUDGET AS ADOPTED
BUDGET AMENDMENTS
M.R. #01239 - 9/20/2001
Sheriff, Prosecutor, Circuit Court, Community Corrections - Bryne Memorial Grant
M.R. #01260 - 10111/2001
M & B - Equalization Contract with Birmingham
M.R. #01266 - 10/11/2001
Sheriff - Bulletproof Vest Grant
M.R. #01253 - 10/11/2001
Sheriff - Contract with Oakland Township
M.R. #01274 - 10/25/2001
Clerk Register of Deeds - Two (2) Clerk II Positions
MR. #01261 - 10/2512001
Board of Commissioners/Library Board - New Mail Card Printer
M.R. #01262 - 10125/2001
Board of Commissioners/Library Board - new Server
M.R. #01277 - 10/25/2001
Prosecuting Attorney - Drug Awareness
M.R. #01267 - 10/25/2001
EMS - Brandon Township Tornado Warning System
M.R. #01270 - 10/25/2001 -
Information Technology/County Executive - Transfer EMS to County Executive
MR. #01284 - 11/08/2001
Sheriff - Use of Forfeited Funds/Drug Awareness
M.R. #01294 - 11129/2001
M & B - Transfer Medical Care Billing to Reimbursement
M.R. #01303 - 11/29/2001
Sheriff - Contract with Oxford Township
M.R. #01304 - 11129/2001
Sheriff - Contract with Brandon Township
M.R. #01302-11/29/2001
Sheriff - Contract with Royal Oak Township
$ 349,313,032.00
$ 98,000.00
8,939.00
7,103.19
$ 14,479.00
$ 66,195.00
$ 5,500.00
$ 34,000.00
38,600.00
$ 31,500.00
$ 500,000.00
$ 25,000.00
$ 36,318.00
$ 65,974.00
$ 65,974.00
$ 85,085.00
for Emergency Response Unit
- Eight (8) Support Positions
$ 142,445.00
$ 134,576.00
$ 414,906.00
M.R. #01326 - 12/1312001
Sheriff - Contract with Independence Township
M.R. #01327 - 12/1312001
Sheriff/County Executive - Create Captain Position
M.R. #01334 - 1211312001
Circuit Court, Prosecutor, Clerk/Register of Deeds
for JIMS Project
649,532.00 KR. #01315 - 1211312001
Sheriff - Second Helicopter for Aviation Unit
TOTAL AMENDED BUDGET AS OF 1213112001 (1ST QUARTER) $ 351,737,158.19
Interoffice
MEMORANDUM
to:
cc:
from:
re:
date:
Tim Soave, Fiscal Services •
Judi Lockhart, Reimbursement
Joyce Raczka, Reimbursement
Inmate Waived Report
February 1, 2002
Submitted for your review is the Inmate Report for 2001 for the Months of October,
November and December.
Number of Amount Waived
Accounts
October 01-035064 CZ 96 $ 234,889.00
November 01-035852 CZ 79 $ 177,257.00
December 01-036621 CZ 64 $ 120,617.00
TOTAL 239 . $ 532,763.00
From the desk of ....
Joyce Raczka
Reimbursement
1200 N Telegraph Road
Pontiac, Michigan 48343
te1:248-858-7368
fax:248-975-4288
rHE FOREGOING 4
4V/
,yreon, County Executive
G. William Caddell, County Clerk
Resolution #02093 April 18, 2002
Moved by Palmer supported by Amos the resolutions on the Consent Agenda be adopted, (with
accompanying reports being accepted).
AYES: Brian, Buckley, Causey-Mitchell, Coleman, Crawford, Dingeldey, Douglas, Garfield,
Gregory, Law, McPherson, Melton, Middleton, Moffitt, Moss, Obrecht, Palmer, Patterson, Sever,
Suarez, Webster, Amos. (22)
NAYS: None. (0)
A sufficient majority having voted therefore, the resolutions on the Consent Agenda, were adopted (with
accompanying reports being accepted).
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 April 18, 2002,
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 18th day of April, 2002.