HomeMy WebLinkAboutResolutions - 2002.09.19 - 27013MISCELLANEOUS RESOLUTION #02231 September 19, 2002
BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2002 THIRD
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, Section 23, which authorizes budget
amendments for variance between estimated revenue and projected
expenditures, adjustments are required; and
WHEREAS the Fiscal Year (FY) 2002 Third Quarter Financial Forecast
Report has identified several variances and budget amendments are
recommended; and
WHEREAS a budget amendment requesting utilization of the Prosecuting
Attorney's projected favorable variance in Controllable Personnel, to cover
connection fees related to replacement of obsolete Intergraph Desktops used
for warrant teleconferencing; and
WHEREAS the Sheriff's Department was approved to receive six (6) MDC
computers for Patrol Services contracts, and projected favorability, in the
Sheriff's General Fund Aviation account can be used to offset the MDC cost
and add funding to the Non-Department Contingency account; and
WHEREAS Information Technology is contracting for the development of
software to enhance the Equalization Division's Digital Photography program
to include the capability for field personnel to sketch buildings during
field assessments and sufficient funding is available within Equalization's
budget to transfer to Information Technology to cover the cost; and
WHEREAS the Clerk is continuing to reflect a favorable variance in
mortgage revenue, and a budget amendment is requested to utilize this
favorability to offset Record Retention's substantial increase in
microfilming and reproductions, as the volume is 80 96 higher than
anticipated; and
WHEREAS a budget amendment is requested to transfer funding from the
Human Resource Division to the Project Work Order Fund for the purchase of
furniture for vacated office space in the County Executive Office Building
and related renovations; funding was specifically set aside for this
project during the FY 2002 budget process and is available in the Personnel
Department's FY 2002 budget; and
WHEREAS Planning and Economic Development has funding as approved
with the FY 2002 budget to participate in the Oakland County Trail Study,
and a transfer of these funds from the Planning and Economic Development
Division budget to Parks and Recreation is requested as part of the
contribution to the Study; and
WHEREAS a budget amendment is requested to reallocate budget
appropriations in the FY 2002 Solid Waste Management unit to reflect actual
FY 2002 expenditures; and
WHEREAS a budget amendment is requested to reflect the funding of the
$250,000 "incentive" funding for non-52 District Courts approved pursuant
to M.R. #02147 from Public Act 189 not from Prior Year Balance; and
WHEREAS a budget amendment is requested to correctly classify charges
for Insurance Reserve Expense budgeted in Non-Departmental; and
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote with Causey-Mitchell and
Palmer absent.
WHEREAS the Sheriff's Aviation Unit recently acquired its second
helicopter, and a budget amendment is recommended to the Sheriff Aviation
Fund to more accurately reflect actual expenditures, with an offset to the
General Fund/General Purpose Sheriff's Department Patrol Services budget;
and
WHEREAS the Drain Commissioner is requesting to amend the Drain
Equipment Fund to reduce Transfer In and Professional Services for GIS
Record Conversion; funding for this project is available in the Designated
Fund Balance of the General Fund and will be appropriated as needed; and
WHEREAS $263,657 from prior year's operating transfers are included
in the Information Technology retained earnings and reserved for further
implementation of the GIS project, and of this amount, $155,064 will be
expended in FY 2002 for Software Rental/Lease Purchase and Software
Support/Maintenance, with the balance of $108,593 to be submitted for
appropriation in FY 2003; and
WHEREAS a reduction was made to departments for Building Liability
charges during the FY 2002 budget process, and it is recommended that the
Building Liability Fund be amended to reflect this reduction, offset by an
increase in Property Insurance due to the increase in cost; and
WHEREAS a budget amendment is requested to correctly reclassify the
charges for the Senior Citizen Prescription Program to the General Fund
Non-Department Senior Citizen Prescriptions account; and
WHEREAS MR #00065 authorized $9,179,000 for Phase II of the Judicial
Information Management System (JIMS), which designated funds from the DTRF
to be transferred over a three-year period ($5,000,000 - FY 2000;
$2,519,000 - FY 2001; and $1,660,000 - FY 2002); and
WHEREAS a transfer of $1,679,000 is requested from the DTRF in order
to complete the authorized transfer for the Phase II implementation and;
WHEREAS appropriations and expenditures for the 52-3 District
Court/Sheriff's Department Sub-Station Project require transfer of funds
from the Project Work Order Fund (#404) to the 52-3 District
Courthouse/Sheriff's Sub-Station Fund (#414) and the Building Improvement
Fund requires reimbursement from bond proceeds as authorized by M.R.
#01165.
NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts
the Fiscal Year 2002 Third Quarter Financial Forecast.
BE IT FURTHER RESOLVED that the Board authorizes amendments to the FY
2002 Budget as detailed on the resolution and 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 52-3 District Courthouse/Sheriff's Sub-Station 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 52-3 District Courthouse/Sheriff's
Sub-Station Project be transferred to the 52-3 District
Courthouse/Sheriff's Sub-Station Fund (#414).
BE IT FURTHER RESOLVED that the FY 2002 budget be amended to
correctly classify charges for the Senior Citizen Prescription Program
(#9407-081000) as follows:
90-190000-14000-1582 Prior Years Balance ($81,412)
90-210000-21000-9074 Senior Citizen Prescriptions 81,412
Total $ - 0 -
BE IT FURTHER RESOLVED that the FY 2002 Budget be amended, as
specified below, to utilize funds from the Delinquent Tax Revolving Fund to
complete the authorized transfer for the Judicial Information Management
System (JIMS) - Phase II implementation:
General Fund (101)
Revenue
90-360000-13000-1701 Del. Tax Rev. Fund $1,679,000
Expenditure
90-310000-40000-8000 Info Tech Fund Transfer 1,679,000
Total $ - 0 -
Information Technology Fund (636)
Revenue
18-636123-12000-1701 Transfer In $1,679,000
Expenditure
18-636122-12000-3348 Professional Services $ 820,049
18-636122-15000-3756 Travel & Conference 93,100
18-636142-15000-3597 Software Supp/Maint 617,760
$1,530,909
18-636113-10000-8005 Change in Fund Equity 148,091
Total $1,679,000
$ - 0 -
Chairperson, on behalf of the Finance Committee, I move the adoption
of the foregoing resolution.
1NANCE COMMITTEE
X.1
--
Clerk - Mortgages
Record Retention - Micro. & Reprod.
$ (83,992.00)
83,992.00
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2002 THIRD QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP) ACTIVITIES
ACCOUNT NUMBER ACCOUNT NAME
IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS
Prosecuting Attorney
Expenditures
41-221000-41700-2001 Salaries
41-211000-41700-6636 IT - Operations
Total
Sheriffs Department / Non-Department
Expenditures
43-023601-34300-6680 Sheriff Aviation
43-033601-30300-8001 Sheriff - Transfer Out to IT
90-290000-25000-2564 Non-Dept Contingency
Total
M & B - Equalization / Non-Department
Expenditures
12-240000-41950-2001 Salaries
12-240000-41950-2075 Fringe Benefits
12-240000-41950-3292 Personal Mileage
12-240000-41950-4100 FA Expendable Equipment Exp
90-310000-40000-8001 Non-Dept Transfer Out to IT Fund
Total
Clerk Reg. of Deeds / Record Retention
Revenue
21-140100-11000-0705
Expenditure
13-138203-15100-6654
FY 2002
AMENDMENT
$ (61,300.00)
61,300.00
$ (100,000.00)
23,148.00
76,852.00
$ (31,400.00)
(10,670.00)
(2,260.00)
(5,770.00)
50,100.00
$ 200,000.00
$ 200,000.00
Personnel / Human Resources
Expenditures
15-402200-10001-4100
15-403300-10001-8001
Expendable Equipment Expense
Transfer Out to PWO Fund
Total
$ (10,000.00)
$ 10,000.00
$ (250,000.00)
250,000.00
Expenditures
90-210000-21000-6677
90-290000-25000-2964
$ 131,595.00
Insurance Reserve Expense (131,595.00)
Insurance Fund
Community & Economic Development Admin.
19-210000-13500-2001
19-210000-13500-2074
19-210000-13500-3060
19-210000-13500-3324
19-210000-13500-3348
19-210000-13500-3756
19-210000-13500-3844
19-210000-13500-6666
Salaries
Fringe Benefits
Legal Services
Printing
Professional Services
Travel & Conference
Workshops & Meetings
Print Shop
$ (19,000.00)
(8,300.00)
(13,500.00)
(12,000.00)
27,300.00
6,000.00
7,500.00
12,000.00
Planning & Economic Development
19-221000-10000-3348 Professional Services
19-320000-10000-8801 Transfer Out to P & R.
Parks & Recreation
53-300208-10001-1701
53-201000-10001-2564
Non-Department
Revenues
90-190000-14000-1582
90-340000-14000-1701
Transfer In from General Fund
Parks & Rec. Contingency
Total
Prior Year Revenue
Transfer In from Public Act 189 Fund
Total
$ 10,000.00
10,000.00
83,992.00
83,992.00
50,100.00
155,064.00
205,164.00
204,169.00
995.00
205,164.00
Expenditure
18-636172-95000-3596
18-636172-95000-3597
Software Rental/Lease Purchase
Software Support/Maintenance
Total
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2002 THIRD QUARTER BUDGET AMENDMENTS
PROPRIETARY FUND ACTIVITIES
ACCOUNT NUMBER ACCOUNT NAME
FY 2002
AMENDMENT
SELF BALANCING AMENDMENTS
Sheriff Aviation Fund (680)
Revenue
43-136680-34300-0924
Expenditure
43-236680-34300-3965
Drain Equipment Fund (639)
Revenue
61-121317-10000-1701
Expenditure
61-22731 7-1 0000-2572
Rental Helicopters
Interest Expense
Total
Transfer In from General Fund
Contracted Services
Total
$ (100,000.00)
$ (100,000.00)
$ (936,580.00)
(936_580.00)
Project Work Order Fund (404)
Facilities Management
Revenue
14-310007-60983-1701 Transfer In from General Fund
Expenditure
14-210007-60983-8005 Change in Fund Equity
Total
Information Technology Fund (636)
Revenue
18-636173-95000-1701
18-636171-95000-1582
Total
Transfer In from General Fund
Prior Year Balance
Information Technology - CLEMIS Fund (635)
Revenue
23-635113-30001-1701 Transfer In
Expenditure
23-635152-30001-8005
$ 23,148.00
Change in Fund Balance $ 23,148.00
Building Liability Fund
Revenues
95-150107-01000-0639 Liability Insurance $ (1,000,000.00)
95-150107-01000-0818 Property Insurance Billings 420,000.00
Total $ (580,000.00)
Expenditures
95-250007-01000-2512 Claims Paid $ (1,000,000.00)
11-250007-01000-2976 Insurance 420,000.00
Total $ (580,000.00)
ri
OAKLAND* L. BROOKS PATTERSON, OAKLAND COUNTY EXECUTIVE
COUNTY MICHIGAN
DEPARTMENT OF MANAGEMENT AND BUDGET Laurie Van Pelt, Director
Edwin J. Poisson, Deputy Director
TO: Members of the Finance Committee
FROM: Laurie Van Pelt, Director, Management and Budget
Ed Poisson, Deputy Director, Management and Budget
Tim Soave, Manager, Fiscal Services
Nancy Fournier, Chief, Fiscal Services
LaVeme Smith, Supervisor of Fiscal Services
SUBJECT: Letter of Transmittal - Fiscal Year (FY) 2 -002 Third Quarter Financial Forecast — Revised
DATE: August 15, 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 favorability of $7,064,622 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 $2,180,600 less revenue than
budgeted (0.60%), and expending $9,245,222 less than budgeted (2.53%).
REVENUES
GF/GP revenues are forecasted to be 0.60% below budget or $2,180,600. This unfavorability reflects a
number of events.
A. GENERAL FUND - INTERGOVERNMENTAL REVENUE — Unfavorable: $1,150,000
This unfavorability results from a decrease in revenue sharing from the State. The County
is estimated to receive $22,350,000 for State Revenue Sharing, which is approximately
$1,357,232 less than what the County received in FY 2001: $23,707,232.
B. GENERAL FUND - CHARGES FOR SERVICES - Favorable: $6,907,900
This favorability primarily results from an unanticipated continuance of activity
regarding new mortgages and refmancing as reflected in the Clerk's revenue. An
estimated $4,147,200 in favorability is forecasted as a result. Favorability of $1,164,000
is forecasted in the Treasurer's Office due to a one-time collection from the Local
Development Financing Authority and TIFA and DDA recovery. Favorability of
$974,000 is expected in the Sheriff's Department mostly due to the increase of $500,000
for Board and Care payments and Deferred Offender Reimbursements of $400,000.
C. GENERAL FUND — MISCELLANEOUS REVENUE — Unfavorable: $8,400,000
This unfavorability results from the unanticipated drop in interest rates.
D. GENERAL PURPOSE FUNDS - CHARGES FOR SERVICES - Favorable: $461,500
Health Division revenue is favorable due to water supply and on-site sewerage permits
which is partially offset by unfavorable revenue for Out County Board and Care.
EXECUTIVE OFFICE BUILDING 34 EAST • 1200 N TELEGRAPH RD DEPT 409 • PONTIAC MI 48341-0409 • (248)858-2163 • FAX (248) 858 -9172
EXPENDITURES
In total, expenditures are anticipated to be 2.53% below budget or $9,245,222. 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. CLERIC/REGISTER OF DEEDS - The majority of unfavorability ($112,500) stems from
the continued high volume of activity within the Clerk's Office, in spite of the current
decline in the economy. There is a partial offset of favorability in Controllable personnel
is favorable $25,300 due to turnover and Controllable Operating of $119,200.
Fortunately, the revenue generated from this activity has also created a favorable variance
for the County as previously mentioned. Non — controllable operating is unfavorable
($257,000) due to mailroom charges (note offset in postage) IT Imaging operations and
print shop charges. Total favorability for Clerk's revenue of $4,147,200 more than
offsets unfavorability for expenditures.
B. CENTRAL SERVICES — Department is expected to be unfavorable ($187,000).
Micrographics is expected to be ($200,000) overbudget due to record retention project
which will help cleanup storage.
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 not necessarily related to any unfavorable variances. All amendment requests will be
presented at the next Finance Committee meeting on August 29, 2002.
REVENUES
GENERAL FUND
Taxes
Intergovernmental
Charges for Services
Miscellaneous Revenue
SUB-TOTAL GENERAL FUND
0.00%
-2.53%
9.92%
-36.16%
-0.80%
GENERAL PURPOSE FUNDS
Intergovernmental
Charges for Services
$13,515,000.00
6,367,597.00
$13,515,000.00
6,367,597.013
$13,515,000,00
6,829,097.00
$0.00
461,500.00
0.00%
7.25%
USE OF PRIOR YEAR FUND BALANCE $250,000.00 $14,089,784.99 $14,089,784.99 $0.00 0.00%
TOTAL GF/GP FUNDS $349,313,032.00 $365,781,936.18 $363,601,336.18 ($2,180,600.00) , -0.60%
TOTAL ADMIN. OF JUSTICE $61,857,133.00 $63,582,561.35 $61,665,061.35 $1,917,500.00 3.02%
TOTAL LAW ENFORCEMENT $108,649,216.00 $112,099,335.37 $108,363,035.37 $3,736,300.00 3.33%
-0.91%
6.38%
4.01%
-0.54%
1.17%
1.06%
1.68%
3.87%
-7.51%
1.66%
2.84%
3.27%
2.70%
2.23%
0.00%
0.00%
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NON-DEPARTMENTALS $ 45,345,995.00 $ 47,785,017.20 $ 47,761,417.20 $23,600.00 0.05%
TOTAL GOVERNMENTAL EXPENDITURES $349,313,032.00 $365,781,936.18 $356,536,714.18 $9,245,222.00 2.53%
FY 2002 THIRD QUARTER FORECAST REPORT
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
FY 2002
ADOPTED
BUDGET
$193,547,700.00
45,273,177.00
67.131,066.00
23,228,492.00
$329,180,435.00
BUDGET
AS
AMENDED
$193,547,700.00
45,391,949.00
69,641,413.19
23,228,492,00
$331,809,554.19
FY 2002
FORECAST
$193,547,700.00
44,241,949.00
76,549,313.19
14,228,492.00
$323,167,454.19
AMOUNT
FAVORABLE/
(UNFAVORABLE) PERCENT
60.00
(1,150,000.00)
6,907,900.00
_ (6,400,000,00)
(52,642,100.00)
SUB-TOTAL GP REVENUES $19 882 597.00 $19,882,597.00 $20,344,097.00 $461,500.00 2.32%
EXPENDITURES
ADMINISTRATION OF JUSTICE
• Circuit Court
52nd District Court
Probate Court
$43,975,487.00 $44,939,510.54 $43,992,710.54 $946,800.00
12,811,466.00 13,420,966.59 12.848,866.59 6572,100.00
5,070,180.00 5,222,084.22 4,823,484.22 $398,600.00
2.11%
4.26%
7.63%
LAW ENFORCEMENT
Prosecuting Attorney
Sheriff
$16,367,247.00 $16,677,189.62 615,861,489.62 $815,700.00
92,281,969.00 95,422,145.75 92,501,545.75 2,920,600.00
4.89%
3.06%
GENERAL GOVERNMENT
Clerk/Register of Deeds
Treasurer
Board of Commissioners
Library Board
Drain Commissioner
TOTAL GENERAL GOVERNMENT
COUNTY EXECUTIVE
County Executive Aamn.
Management and Budget
Central Services
Facilities Management
Personnel
Human Sys.
Public Services
Community & Economic Dev.
CLEMIS & Emergency Communications
Workforce Development
$10,898,913.00 $12,395,198.94 $12,507,698.94 ($112,500.00)
3,576,730.00 3,863,723.86 3,617,223,86 246,500.00
2,663,731.00 2,666,889.28 2,559,989.28 106,900.00
2,691,527.00 2,703,166.02 2,717,836.02 (14,670.00)
3,440,515.00 3,908,880.18 3,863,280.18 . 45,600,00
$23,271,416.00 $25,537,858.28 $25,266,028.26 $271,830.00
$6,095,607.00 $9,267,328.47 $9,111,528.47 $155,800.00
$18,093,519.00 $19,832,789.72 - $19,065,289.72 767,500.00
$2,269,438.00 $2,489,566.14 $2,676,566.14 (187,000.00)
$1,669,649.00 $1,750,691.70 $1,721,691.70 29,000.00
$4,626,076.00 $5,051,630.08 $4,908,338.08 143,292.00
$55,874,555.00 $57,266,213.07 $55,490,013.07 1,876,200.00
$13,641,136.00 $13,888,809.42 $13,513,609.42 375,200.00
$5,654,905.00 $6,103,035.38 $5,967,035.38 136,000.00
$1,237,488.00 $0.00 $0.00 0.00
$1,026,899.00 $1,027,100.00 100 00 $1,027 , . _ 0.00
TOTAL COUNTY EXECUTIVE
TOTAL DEPARTMENTS
$110,189,272.00
$303,967,037.00
$116,777,163.98 $113,481,171.98 83,295,992.00 2.82%
$317,996,918.98 $308,775,296.98 $9,221,622.00 2.90%
General Fund/General Purpose
Favorable/(Untavorable)$0 $0 $7 064 62100 $7,064,622.00 - ... _ _
1 0
0.00%
3ROPERTY TAXES
2001 Tax Levy $ 192,852,700.00 $ 192,852,700.00 $ 192,852,700.00 $
Elections
Register of Deeds
BUDGET BUDGET AMOUNT
AS AS FY 2002 FAVORABLE/
ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT
qET CURRENT PROPERTY TAX $ 192,852,700.00 $ 192,852,700.00 $ 192,852,700.00 $ 0.00%
Ti tER TAXES
Delinquent Tax - Prior Years
Tiler Tax
TOTAL PROPERTY AND OTHER TAXES
$ 600,000.00 $ 600,000.00 $ 600,000.00 $ 0.00%
95,000.00 95,000.00 95,000.00 0.00%
$ 695,000.00 $ 695,000.00 $ 695,000.00 $ 0.00%
$ 193,547,700.00 $ 193,547,700.00 $ 193,547,700.00 $ 0.00%
- BUDGETED RECEIPTS OTHER THAN TAXES
GENERAL FUND - STATE AND FEDERAL
Outside Agencies $ 45,273,177.00 $ 45,391,949.00 $ 44,241,949.00 $ (1,150,000.00) -2.53% Unfav. State Income Tax ($1,150,000) based on revised revenue sharing estimates.
TOTAL BUDGETED RECEIPTS $45,273,177.00 $45;391,949.00 $44,241,949.00 $ (1,150,000. 00) -2.53%
GENERAL FUND - STATE AND FEDERAL --------
CHARGES FOR SERVICES
County Executive Administration $ 500.00 $ 500.00 1,800.00 $ 1,300.00 260.00% Reimbursement to Directors for attendance at P&R and Bldg. Authority meetings.
Emergency Response & Preparedness 1,310.00 170,962.00 218,462.00 47,500.00 0.00% Revenue received from sale of thunderbolt sirens.
Auditing 80,000.00 80,000.00 80,000.00 - 0.00%
Equalization 2,142,536.00 2,170,668.00 2,170,668.00 . - 0.00%
Reimbursement Division 316,000.00 316,000.00 342,000.00 26,000.00 8.23% Revenue from Tax Intercept fees and 25% Court Ordered Board & Care higher than anticipated.
Materials Management - Auction 12,500.00 12,500.00 3,700.00 (8,800.00) -70.40% Proceeds lower than anticipated offset by fay. Auction Expense.
Support Services - Admin (Vending/Cafeteria) 65,000.00 65,000.00 65,000.00 - 0.00%
Facilities Engineering 25,000.00 25,000.00 - (25,000.00) -100.00% Engineering Services to Oakland County International Airport delayed to FY 2003.
Personnel 750.00 750.00 750.00 - 0.00%
Community Court Services 403,000.00 408,000.00 408,000.00 - 0.00%
MSU Extension- Oakland County 71,125.00 71,125.00 71,125.00 - 0.00%
Medical Examiner 96,500.00 113,000.00 123,000.00 10,000.00 8.85% Autopsies, Cremation Approval Fee and Misc. reflect Increased activity.
Animal Control 826,935.00 828,935.00 826,935.00 - 0.00%
Development & Planning 477,500.00 477,500.00 465,200.00 (12,300.00) -2.58% Lower map sales due to transition from hard copy products to digital products.
C&E DevNVorkforce Development 1 .028.899.00 1,026,899.00 1,026,899.00 - 0.00% .
County Clerk 2,121,000.00 2,187,195.00 2,230,295.00 43,100.00 1.97% Incr. In Certified copy fee, 10% Bond Fee, and photostat revenue.
11,602,891.00 11,702,401.00
19,800.00 19,800.00 43,000.00 23,200.00 117.17% Inced volume In Bd. Of Canvasser Service Fees, and Nominating Filing Forfeitures
15,783,301 00 4,080,900.00 34.87% Fay. Interest rates resulting In increased mortgages, transfer tax, and recording fees,
partially offset In reduction In Enhanced Access Fee projected rev.
FIRSTREV.xls 1 8/14/2002
Favorable/(Unfavorable) 52,754,774 0 2,539,488 1,476,211 7,064,622 -97.20% -41.87% 0
COUNTY OF OAKLAND
QUARTERLY FORECAST COMPARISON
FY 2002 THIRD QUARTER
FY 2001 FY 2002 FY 2002 FY 2002 1st FY 2002 2nd FY 2002 3rd % chg % chg
Actual Adopted Amended Qtr Forecast Qtr Forecast Qtr Forecast FY2001 pry frcst Comments
Revenue
Taxes
Taxes- One time adjust.
Intergovernmental
Charges for Services
Misc Revenue
sub-total General Fund
Intergovernmental
Charges for Services
sub-total General Purp
Prior Year Balance
Total General Fund/GP
180,474,873
41,755,923
41,492,054
69,274,134
25,131,083
358,128,067
12,516,329
7,632,724
20,149,053
0
378,277,120
193,547,700
0
45,273,177
67,131,066
23,228,492
329,180,435
13,515,000
6,367,597
19,882,597
250,000
349,313,032
193,547,700
0
45,391,949
69,641,413
23,228,492
331,809,554
13,515,000
6,367,597
19,882,597
14,089,785
365,781,936
193,547,700
0
45,364,477
70,130,843
23,228,492
332,271,512
9,115,000
10,655,097
19,770,097
1,609,926
353,651,535
193,547,700
0
45,150,177
74,670,720
16,628,492
329,997,089
13,515,000
6,221,058
19,736,058
8,280,468
358,013,615
193,547,700
0
44,241,949
76,549,313
14,828,492
329,167,454
13,515,000
6,829,097
20,344,097
14,089,785
363,601,336
7.24% 0.00%
-100.00% One time adj. accrue rev
6.63% -2.01% Dec in State Revenue Sharing
10.50% 2.52% Clerk/ROD inc 3 mil; Treas inc .5 mil; Sheriff inc .9 mil
-41.00% -10.82% Invest income dec 8.4 mil
-8.09% -0.25%
7.98% 0.00% Account adj (state Health sub)
-10.53% 9.77% Account adj (see offset above)
0.97% 3.08%
70.16% Use of fund bat for 1 time projects
-5.36% 1.23%
Expenditures
Ci, cult Court
District Court
Probate Court
Prosecuting Attorney
Sheriff Dept
Clerk
Treasurer
BOC
Libmry
Drain
County Executive
M & B
Central Services
Facilities Management
Personnel
Human Sys
Public Services
Community & Econ Dev
Workforce Dev
Non Dept
42,985,513 43,975,487 44,939,511 44,260,692
12,395,881 12,811,466 13,420,967 12,977,491
4,795,411 5,070,180 5,222,084 5,063,111
14,650,762 16,367,247 16,677,190 16,296,873
85,332,713 92,281,969 95,422,146 93,211,773
10,198,427 10,898,913 12,395,199 11,372,396
3,358,461 3,576,730 3,863,724 3,605,085
2,423,495 2,663,731 2,666,889 2,656,309
2,939,050 2,691,527 2,703,166 2,693,789
3,072,896 3,440,515 3,908,880 3,464,428
7,248,248 7,333,095 9,267,328 7,876,383
17,567,473 18,093,519 19,832,790 18,493,729
2,216,092 2,269,438 2,489,566 2,416,131
1,784,158 1,669,649 1,750,692 1,665,577
4,705,488 4,626,076 5,051,630 4,659,113
57,165,451 55,874,555 57,366,213 55,813,582
8,895,471 13,641,136 13,888,809 13,568,839
4,887,735 5,654,905 6,103,035 5,623,218
23,634 1,026,899 1,027,100 1,027,100
38,875,987 45,345,995 47,785,017 44,366,428
44,254,846
12,913,928
5,003,532
15,875,789
94,247,743
12,692,941
3,672,509
2,577,953
2,674,776
3,490,945
7,880,404
18,878,585
2,363,719
1,812,064
4,866,676
56,840,820
13,633,158
5,944,122
1,027,100
45,885,794
43,992,711
12,848,867
4,823,484
15,861,490
92,501,546
12,507,699
3,617,224
2,559,989
2,717,836
3,863,280
9,111,528
19,065,290
2,676,566
1,721,691
4,908,338
55,490,013
13,513,610
5,967,035
1,027,100
47,761,417
2.34%
3.65%
0.59%
8.26%
8.40%
22.64%
7.70%
5.63%
-7.53%
25.72%
25.71%
8.53%
20.78%
-3.50%
4.31%
-2.93%
51.92%
22.08%
4245.86%
22.86%
-0.59%
-0.50%
-3.60%
-0.09%
-1.85% Additional contracts less turnover
-1.46% ROD records conversion less turnover
-1.51%
-0.70%
1.61%
10.67% Watershed management Program
15.62% Emer Resp & Prep one time purchases
0.99%
13.24% Amendment in process for micrographics costs
-4.99% Project expenses charged back to projects
0.86%
-2.38% Turnover
-0.88% Medical Examiner trf to Public Services effective FY 2002
0.39%
0.00% Expenditure budget is offset by Revenue budget
4.09%
Total General Fund/GP 325,522,346 349,313,032 365,781,936 351,112,047 356,537,404 356,536,714 9.53% 1.55%
Although Emergency Response Program (ERP) was not transferred until FY 2002, it has been restated here in Co. Exec.
Prepared by Fiscal Services 8/15/2002
ST)
)
Memorandum
To: Tim Soave
Manager, Fiscal Services
From: George J. Miller, M.A.
Manager/Health Officer
Date: June 17, 2002
Gift Donation — Fund #233200-52000-2853-150013
Pursuant to Miscellaneous Resolution #83154, please be advised that
Matthews Media Group, Inc. 6101 Executive Boulevard, Suite 300,
Rockville, Maryland 20852 has donated $800 (check #30069) to the Oakland
County Cancer Risk Reduction Program. This donation was originated
through the National Cancer Institute and Wayne State University's Kidney
Cancer Study. There is no financial implication for Oakland County as a
result of accepting this donation.
GJM:cjs
Enclosure
Cc: Kathy Lane
Re:
3
COUNTY MICHIGAN
DEPARTMENT OF HUMAN SERVICES HEALTH DIVISION
George J. Miller, M.A., Manager
,/..-7-
\
7—
---"beorge J. Wier, M.A.
Manager/Health Officer
011 K: I Li I %I " " VIONS57311r
1•81121111W
L. BROOKS PATTERSON, OAKLAND COUNTY EXECUTIVE
June 17, 2002
Bridget Robinson, M.A., CHES
Sr. Account Director
Matthews Media Group, Inc.
6101 Executive Boulevard
Suite 300
Rockville, Maryland 20852
Dear Ms. Robinson:•
On behalf of the Oakland County Health Division, thank you for the $800 donation from
the Matthews Media Groups, Inc. (check #30069). This donation to the Cancer Risk
Reduction Program will be happily accepted.
We appreciated the opportunity to help with the kick-off for the National Cancer
Institute's and Wayne State University's Kidney Cancer Study. Your support will
enhance the Health Division's efforts to promote and protect the public's health
Sincerely,
OAKLAND COUNTY HEALTH DIVISION
Department of Human Services
GJM:cjs
BLDG 36 EAST 1200 N TELEGRAPH RD DEPT 432 250 ELIZABETH LK RD 27725 GREENFIELD RD 1010 E WEST MAPLE RD
PONTIAC MI 48241-0432 • PONTIAC MI 48341-1050 • SOUTHFIELD MI 48076-3625 • WALLED LAKE MI 48390-3538
3006
SEQUOIA BANK
BETHESDA, MARYLAND 20814
15-162-540
DATE CONTROL NO.
05/16/02 030069 *****800,00
OAKLAND COUNTY HEALTH DIV
27725 GREENFIELD RD:
:SOUTHFIELD MI 48076-;'
oh
H.0300690 1:0 S 1,00162E0: 069S0000a
MUST BE CASHED WITHIN 120 DAYS
TEOMMOMMIEMPEIMPInM*06.NOWMWOMV4
MATMEWS MEDIA GROUP, INC.
6101 EXECUTIVE BOULEVARD, SUITE 300
ROCKVILLE, MD 20852
301-984-7191
****-.*800 DOLLARS AND 09 CENTS**
PAY
TO THE
ORDER OF
AMOUNT
MATTHEWS MEDIA GROUP, INC.
3006S
OUR REF. Na 1 YOUR INVOICE NO. 1 INVOICE DATE 1 INVOICE AMOUNT 1 AMOUNT PAID 1 DISCOUNT TAKEN NET CHECK AMOUIN
028093 05082002 05/08/02 400.03 400.00 0.00 400.0
028094 05082002 05/08/02 400.03 400.03 0.00 400.0
TOTALS 800.03 800.03 0.00 800.0
•n
15
tALL
irla F. Kugler, NHA, Manager -
INTEROFFICE MEMORANDUM
TO: TIM SOAVE, MANAGER - FISCAL SERVICES
FROM: SHIRLA F. KUGLER, NHA, MANAGER - MEDICAL CARE FACILITY
SUBJECT: MEDICAL CARE FACILITY WM1E-OFFS
DATE: AUGUST 20, 2002
The following outstanding receivables have been determined as uncollectable and
therefore should be written off in accordance with Fiscal Services policies & procedures:
MR# 3324 Service Date: 10/99
Amount of Write Off:
Date of Write Off: 6/27/02
$151.14
This was for Speech Therapy and was denied by Medicare Part B. The
"Appointment of Representative" was not signed by the family and
therefore a review could not be requested (reviews must be requested by
the family). This was written off to the Bad Debt Account.
MR# 3390 Service Date: 04/00
Amount of Write Off:
Date of Write Off: 6/27/02
$227.79
This was for Speech Therapy and denied by Medicare Part B. The
"Appointment of Representative" was signed too late to request a
hearing. This was written off to the Bad Debt Account.
MR# 3520 Service Date: 06/01
Amount of Write Off:
Date of Write Off: 6/27/02
$374.38
This was for Occupational Therapy and went under Medical Review.
Partial payment was made. The review was not requested timely. This
was written off to the Bad Debt Account.
MR# 3365 Service Date: 01/00
Amount of Write Off:
Date of Write Off: 6/28/02
$223.89
This was for Physical Therapy and was a Medical Denial. The
"Appointment of Representative" was signed & submitted too late to
request a hearing This was written off to the Bad Debt Account.
I have reviewed these write-offs and respectfully submit them.
G. William Caddell, County Clerk
Resolution #02231 September 19, 2002
Moved by Douglas supported by Causey-Mitchell the resolution be adopted.
AYES: Coleman, Crawford, Dingledey, Douglas, Galloway, Garfield, Gregory, Law,
McPherson, Melton, Middleton, Moffitt, Moss, Obrecht, Palmer, Patterson, Sever, Suarez,
Taub, Amos, Appel, Causey-Mitchell. (22)
NAYS: None. (0)
A sufficient majority having voted therefore, 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 September
19, 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 th County of Oakland at Pontiac,
Michigan this 19th day of September, 2002.