HomeMy WebLinkAboutResolutions - 2001.09.06 - 26676MISCELLANEOUS RESOLUTION #01227 September 6, 2001
BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2001 THIRD QUARTER
FINANCIAL FORECAST AND BUDGET AMENDMENTS
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
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
amendments for variances between estimated revenue and projected
expenditures, adjustments are required; and
WHEREAS the Fiscal Year (FY) 2001 Third Quarter Financial Forecast has
identified several variances and budget amendments are recommended; and
WHEREAS the Circuit Court has favorability in Defense Attorney Fees due
to an unusual static caseload, this favorability is available to be used to
offset unfavorable variances in the Circuit Court's Non-Controllable
Operations; and
WHEREAS the 52'id District Court Divisions are experiencing favorability
in a number of revenue accounts due to increased activity, it is recommended
this favorability be used to offset unfavorable variances in the Controllable
and Non-Controllable Operations within the Court; and
WHEREAS Probate Court has additional Building Space Allocation funds
due to a recalculation of space, these additional funds can be used to offset
the Visiting Judges account which has increased due to judicial absences; and
WHEREAS Probate Court is also experiencing an increase in Gross Estate
Fees and Refund Fees from Defense Attorneys due to an increase in filings;
and
WHEREAS it is recommended this favorability be used to offset an
overage in Salaries due to court reorganization; and
WHEREAS the Clerk/Register of Deeds is receiving additional Forfeiture
of Bonds due to a streamlining of the bond collection process, it is
recommended that these funds be used to cover an unfavorable variance in Non-
Controllable Operations; and
WHEREAS the Drain Commissioner is requesting to increase the General
Fund / General Purpose revenues and expenditures by $159,000 due to the high
level of construction activity; and
WHEREAS a correction in the Human Services Administrative personnel
budget allocation is recommended; and
WHEREAS Health Division is projected to be favorable in Controllable
Personnel due to turnover, these funds can be used to offset increased
Medical Examiner's Controllable Operating expenses resulting from additional
workload related to autopsies and an adjustment in the contracted rate for
body transports; and
WHEREAS Public Services Administration is projected to be unfavorable
due to an unexpected conference and a higher than anticipated number of
service mementos distributed; and
WHEREAS Community Corrections is also projected to be unfavorable due
to a rapid expansion of various program operations and increased activity;
and
WHEREAS the expense for Professional Services within MSU/Co-Op
Extension is lower than anticipated due co the success of the Gypsy Moth
Suppression Program, these funds be used to offset the variances in Public
Services Administration and Community Corrections; and
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote with Taub absent.
Revenue
18-636113-95000-1701 Operating Transfer in
Expense
18-636122-15000-3348 Professional Services
$62,500
62,500
$ 0
Chairperson, on behalf of the Finance Committee, I move the adoption of
the foregoing resolution.
FINANCE COMMITTEE
ACCOUNT NUMBER ACCOUNT NAME
FY 2001
AMENDMENT
Revised per Finance Committee on August 30, 2001 Schedule A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2001 THIRD QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP) ACTIVITIES
GF/GP OPERATIONS - SELF BALANCING AMENDMENTS
Circuit Court
Expenditures
35-230000-21200-2640
35-210000-11000-6636
35-210000-11000-6675
35-220000-11000-4284
35-220000-11000-6105
35-220000-11000-6666
35-220000-11000-6667
35-230000-21200-6636
35-230000-21200-6675
Defense Atty Fees
Info Tech Operations
Telephone Comm
Postage
Convenience Copier
Stationary Stock
Print Shop
Info Tech Operations
Telephone Comm
$ (381,334)
14,119
2,590
40,626
36,653
26,546
38,600
175,200
47.000
District Courts
Revenues
32-201100-20006-0385
32-201100-20001-0501
32-201100-20001-0529
32-201100-20001-0849
32-301100-20001-0501
32-401100-20001-0501
32-401100-20006-0813
32-401100-20001-1013
32-501100-20001-0251
Expenditures
32-101200-20001-2001
32-101200-20001-3800
32-201200-20001-6636
32-201200-20001-6675
32-301200-20001-2988
32-301200-20001-4252
32-301200-20001-6675
32-401200-20001-3324
32-401200-20001-2548
32-401200-20001-2988
32-401200-20001-3360
Div I - Comm. Serv. Oversight
Div I - Filing Fees
Div I - Bond Forfeitures
Div I - Refund Def. Atty Fees
Div II - Filing Fees
Div III - Filing Fees
Div III - Probation Fees
Div III - State Law Costs
Div IV- 10% Bond Fees
Admin - Salaries
Admin - Visiting Judges
Div I - Info Tech Oeprations
Div I - Telephone Comm
Div II - Interpreters
Div II - Office Supplies
Div ll - Telephone Comm
Div III - Defense Atty Fees
Div III - Computer Research Svc
Div III - Interpreters
Div III - Property Taxes
56,026
37,000
33,000
31,500
11,000
15,000
92,000
36,598
36 ,271
348,395
(15,000)
15,000
166,812
20,159
1,270
3,911
2,705
19,454
1,500
16,000
10,500
43-023201-10000-6660 Admin. - Radio ,Corrint , . . 42,120
43-023201-21400-6660 ' • Admin. - Radio Comm. 42,120
43-023601-33000-6660 Patrol Svcs. - Radio Comm. 18,720
43-023901-40000-6660 Tech Svcs. - Radio Comm. 37,440
43-023901-41000-6660 Tech Svcs. - Radio Comm. 51,480
Total $ 468,000
County Executive - Administration
11-210100-01000-6018 Equip. Rental $ 1,555
11-210100-01000-6636 Info Tech Operations 22,000
11-210100-01000-6661 Leased Vehicles 18,985
11-210100-01000-6666 Print Shop 8,460
11-210100-01000-6667 Convenience Copier 4,500
11-210100-01000-6675 Telephone Comm. 33,000
Total $ 88,500
Auditing
11-220100-10000-6636
11-220100-10000-6675
Corporation Counsel
11-250100-20000-6636
11-250100-20000-6675
Info Tech Operations
Telephone Comm.
Info Tech Operations
Telephone Comm.
6,230
3,270
Total $ 9,500
13,600
7,900
Total $ 21,500
Personnel - Human Resources
15-415200-43110-3348 Professional Services 42,900
Total $ 42,900
Community & Economic Dev.
19-210000-13500-6636 Comm & Econ Dev Admin - Prof. Svcs. $ 134,000
Total $ 134,000
Non-Departmental
90-290000-25000-2564 Contingency
Total Expenditures
TOTAL GF/GP OPERATIONS
50,000
Total $ 50,000
Prepared by: Fiscal Services 08/30/01
ACCOUNT NUMBER ACCOUNT NAME
FY 2001
AMENDMENT
81,690
81,690
Schedule B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2001 THIRD QUARTER BUDGET AMENDMENTS
INTERFUND AMENDMENTS
Fringe Benefit Fund (Child Care Facility)
91-250100-20000-4252
91-250100-20000-6636
91-250100-20000-6675
91-250100-20000-8005
Liability and Insurance
11-250210-30000-2001
11-250210-30000-2075
11-250210-30000-8005
Info Tech Fund
Revenue
18-636111-81000-1701
Expenditures
18-636162-81000-3348
18-636162-81000-2540
18-636162-81000-2776
Office Supplies
Info Tech Operations
Telephone Communications
Changes in Fund Equity
Salaries
Fringe Benefits
Changes in Fund Equity
IT Operating Transfer In
IT - Professional Services
IT - Communications
IT - Equipment Repairs & Maintenance
1,303
20,000
2,217
(23,520)
94,359
31,041
(125,400)
2,000,000
1,428,835
321,165
250,000
2,000,000
Total $
IT- DISC
18-636113-10000-1701
18-636112-10000-8005
Operating Transfer In
Changes in Fund Equity
Circuit Court/Family Division
Revenue
35-341215-71000-1701
Expenditure
35-241215-71000-8001
Information Technology Fund
18-636113-10000-1701
Expenditure
18-636142-15000-8005
Info Tech - Sytem Dev & Supp
18-636122-26000-3348
18-636162-15000-3348
18-636172-26000-3348
Operating Transfer from FOC
Operating Transfer to IT
Operating Transfer from FOC
Changes in Fund Equity
Professional Services
Professional Services
Professional Services
(416,500)
(416,500)
(416,500)
(416,500)
(90,000)
(153,183)
90,000
PkVi sek S
‘,/ V II •••• .
$794,465.00 $789,700.00 $759,700.00 $30,000.00
28,348.00 49,540.46 49,540.46 0.00
137,702.00 143,817.74 146,817.74 (3,000.00)
$960,515.00 6983,058.20 $956,058.20 $27,000.00
$6,169,663.00 $6,302,877.00 $6,002,877.00
389,350.00 463,358.76 463,358.76
1,041,883.00 1,599,816.21 1,620,816.21
81,690.00 60,490.00 0.00
$7,682,586.00 $8,426,541.97 $8,087,051.97 $339,500.00
$3,889,665.00 $4,039,127.00 $4,009,127.00
163,534.00 260,253.68 285,153.68
752,446.00 1,574,692.94 1,579,792.94 ($5,100.00)
$4,805,645.00 $5,874,073.62 $5,874,073.62 $0.00
Purchasing
Controllable Personnel
Controllable Operating
Non-Controllable Operating
3.80% Vacancies
0.00%
-2.09% Unfav. Telephone Comm due to delay of PBX system installation
Equalization
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfers Out
Fiscal Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Reimbursement
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$300,000.00
0.00
(21,000.00)
60,500.00
$30,000.00
($24,900.00)
2.75%
4.76% Vacancies
0.00%
-1.31% Unfav. Telephone Comm due to delay of PBX system installation
0.00% Fav. Bal. of IT transfer. Misc. Res. #98309 for FY 1999 and FY 2000, not required in FY 2001
4.03%
0.74% Vacancies
-9.57% Unfav. Travel & Conference due to GASB 34 seminars/training, Unfav. Postage due to
Finance Committee mailings
-0.32% Unfav. Telephone Comm due to delay of PBX system installation
0.00%
$2,972,169.00 61,782,146.00 $1,782,146.00 0.00 0.00%
349,416.00 108,051.00 108,051.00 0.00 0.00%
743,670.00 496,257.61 496,257.61 0.00 0.00%
COUNTY OF OAKLAND
P12001 THIRD QUARTER FORECAST REPORT
EXPENDITURES
MANAGEMENT AND BUDGET
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
AMOUNT
ADOPTED AMENDED FY 2001 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$279,898.00 $279,898.00 $279,898.00 $0.00 0.00%
11,093.00 11,093.00 11,093.00 0.00 0.00%
10,771.00 10,771.00 10,771.00 0.00 0.00%
$301,762.00 $301,762.00 $301,762.00 $0.00 0.00%
$4,065,255.00 $2,386,454.61 $2,386,454.61 $0.00 0.00%
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfers Out
$14,105,860.00 $13,193,748.00 $12,833,748.00 $360,000.00 2.73%
941,741.00 892,296.90 917,196.90 (24,900.00) -2.79%
2,686,472.00 3,825,355.50 3,854,455.50 (29,100.00) -0.76%
81,690.00 60,490.00 0.00 60,500.00 100.02%
$17,815,763.00 $17,971,890.40 $17,605,400.40 $366,500.00 2.04%
08/28/2001
Administrative
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Support Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Operating Transfer out
$152,076.00
2,016.00
11,338.00
$165,430.00
$152,076.00 $153,876.00 ($1,800.00)
2,016.00 216.00 1,800.00
11,338.00 13,338,00 (2,000.00)
$165,430.00 $167,430.00 ($2,000.00)
$895,176.00 $1,028,244.00 $940,244.00 $88,000.00
50,531.00 52,642.14 53,642.14 (1,000.00)
921,221.00 966,759.41 1,046,759.41 (80,000.00)
0.00 31,515.00 31,515.00 0.00
$1,866,928.00 $2,079,160.55 $2,072,160.55 $7,000.00
COUNTY OF OAKLAND
FY 2001 THIRD QUARTER FORECAST REPORT
EXPENDITURES
CENTRAL SERVICES
ADOPTED AMENDED
BUDGET BUDGET
AMOUNT
FY 2001 FAVORABLE
FORECAST (UNFAVORABLE) EXPLANATION OF SIGNIFICANT VARIANCES
- (Unfav.) Fringe Benefits under appropriated.
- Fay. due to minimal mileage and travel & conference.
- (Unfav.) Telephone Comm. ($2,000),due to delay of implementation of PBX system.
- Fay. due to unfilled PTNE positions and vacant Clerk II position.
- (Unfav.) Equip. Rental due to (1) Postage Meter Rental Charge.
- (Unfav) I.T. Operations ($15,000) due to under appropriated budget. (Unfav.)
Telephone Comm. ($3,000), due to delay of implementation of PBX system.
(Unfav.) Microfilming & Reproductions ($53,000) due to Record Retention
project 80% higher than qualifying records for destruction.
(Unfav) Leased Vehicles ($3,000) Convenience Copier (4,000) and Print Shop
($2,000).
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Operating Transfer
$1,047,252.00 $1,180,320.00 $1,094,120.00
52,547.00 54,658.14 53,858.14
932,559.00 978,097.41 1,060,097.41
0.00 31,515.00 31,515,00
$86,200.00
800.00
(82,000.00)
0.00
$2,032,358.00 $2,244,590.55 $2,239,590.55 $5,000.00
08/28/2001
Inside
Total Revenue
0.00
218,000.00
DEPARTMENT OF DRAIN COMMISSIONER
DRAIN EQUIPMENT FUND
P1' 2001 THIRD QUARTER FORECAST
OPERATING REVENUES:
Outside
ADOPTED AMENDED FY 2001 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) EXPLANATION OF SIGNIFICANT VARIANCES
2,042,623.00 2,042,623.00 2,260,623.00 218,000.00 - Fay. equipment rentals of $127,000 due to new vehicle purchases, reimbursements of buildiiig
space $27,000, miscellaneous revenue $50,000 billed to Lyon Township tor repairs and
, Improvements, maintenance contract $14,000 for increased use for monthly Scada billing.
89,600.00 89,600.00 89,600.00
2,132,223.00 2,132,223.00 2,350,223.00
OPERATING EXPENSES 2,165,842.00 2,236,471.00 2,313,471.00 (77,000.00) - Unfav. professional services ($105,000) offset by appropriation for the drain records conversion
(MR #00314). Amendment is requested for the GIS project. Unfav. contracted services ($67,000)
for Lyon Township for temporary sanitary sewage removal. linfav. telephone communication and
IT charges due to delay In Implementation of the system. Fay. depr. exp $60,000 arid $35,000 other.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
(33,619.00) (104,248.00) 36,752.00 141,000.00
NON-OPERATING REVENUE/(EXPENSE) 62,335.00 62,335.00 135,335.00 73,000.00 - Fay. Increase in Investment income $39,000 based on amount invested and anticipated interest
rates and gain on sales of vehicles $34,000.
OPERATING TRANSFER IN 1,070,629.00 1,070,629.00 0.00
OPERATING TRANSFERS (OUT) 28,716.00 28,716.00 0.00 28,716.00 - Fay. due to accounting change for charge back of computers to projects.
NET REVENUES OVER(UNDER) 0.00 1,000,000.00 1,242,716.00 242,716.00
EXPENSES
61-REVISEDDRAINEQUIP3001.xls
= nn.
08/23/21)01
OPERATING REVENUE
OPERATING EXPENSE
OPERATING INCOME (LOSS)
DEPARTMENT OF CENTRAL SERVICES
INTERNAL SERVICE FUNDS
FY 2001 THIRD QUARTER FORECAST REPORT
ADOPTED AMENDED FY 2001 VARIANCE
BUDGET BUDGET FORECAST FAVAUNFAV) EXPLANATION OF SIGNIFICANT VARIANCES
'OAKLAND COUNTY INTERNATIONAL AIRPORT (#581)
$2,965,349.00 $2,965,349.00 $3,929,849.00 $964,500.00 - Fav. T-Hangar Rental 447,000; Land Lease 173,500; Landing Fees & Concessions 50,400;
and Car Rental Concessions 15,000 primarily due to the addition of the Oakland/Southwest Airport;
plus fav. U.S. Customs Service 280,000 (offset by costs). Unfav. Aviation Gas (20,000), resulting
from a reduced number of landings & departures due to the economic slowdown, partially offsets
revenue favorability.
3,355,349.00 3,689,349.00 4,216,549.00 (527,200.00) - Unfav. U.S. Customs Service (280,000), offset by reimbursement for the service; Professional
Services (170,000) for environmental assessment services at Oakland/International; Airport
($390,000.00) ($724,000.00) ($286,700.00) $437,300.00 Grounds Maintenance, partially offset by fav. Lands & Grounds Maintenance, (85,700) for new
landscaping at all three airports; Indirect Costs (60,000) for the fourth quarter of FY 2001;
Overtime (19,100) for snowplowing; Building Maintenance Charges for roof and other repairs
(36,200); Equipment Repairs & Maintenance (25,000); Depreciation (53,000); Property Tax
Tax (25,300); and IT Operations (21,000). Many of these unfavorable variances are due in part to
the addition of the Oakland/Southwest Airport In August 2000. Unfav. Partially offset by fav. Heat,
Lights, Gas and Water $30,000. Also, fav. Due to County's protion of $334,000 for Capital Project,
incomplete and cash outlay has not been incurred.
NON-OPERATING REVENUE(EXPENSE)
NET INCOME (LOSS)
390,000.00 390,000.00 506,500.00 116,500.00 -Fay. Investment Income is based on Investment base and expected interest rates.
$0.00 ($334,000.00) $219,800.00 $553,800.00
CENT_SVS.xls 08/2912001
In Testimony Whereof, I have hereunto set my hand and affixed the seal of the
County of Oakland at Pontiac, Michigan this 6t4oday qeSeptember, 2001.
111 II P I
I
Resolution #01227 September 6, 2001
Moved by Douglas supported by Brian the resolution be adopted.
AYES: Buckley, Causey-Mitchell, Coleman, Crawford, Dingeldey, Douglas,
Galloway, Garfield, Gregory, Law, McPherson, Melton, Millard, Moffitt, Moss,
Obrecht, Palmer, Patterson, Sever, Suarez, Taub, Webster, Amos, Appel, Brian.
(25)
NAYS: None. (0)
A sufficient majority having voted therefor, the resolution was
adopted.
FOREGOING RESOLUTI(
Date
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 6, 2001 with the original
record thereof now remaining in my office.
G. William Caddell, County Clerk