HomeMy WebLinkAboutResolutions - 2000.09.07 - 26257MISCELLANEOUS RESOLUTION #00223 September 7, 2000
BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2000 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, and Section 23, which
authorizes budget amendments for variances between estimated revenue
and projected expenditures, adjustments are required; and
WHEREAS the Fiscal Year (FY) 2000 Third Quarter Financial
Forecast has identified several variances and budget amendments are
recommended; and
WHEREAS the 52 nd District Court is projected to be unfavorable in
expenditures, primarily due to an increased usage of Information
Technology Operations, unappropriated utility costs associated with the
new building for Division IV (Troy), and an increase in caseload; and
WHEREAS revenue for the 52 nd District Court - Division III and IV
have increased due to an increase in caseload and activity, which can
be used to offset the unfavorable variances in expenditures; and
WHEREAS the Probate Court is reflecting unfavorable variances in
the Judicial Administration and Court Services divisions. However,
there is sufficient favorability within the Judicial Support division
to offset the unfavorable variances; and
WHEREAS the Sheriff's Department currently has an appropriation
in expendable equipment expense to refurbish a surveillance vehicle.
However, the Motor Pool is billing the Sheriff's Department for the
work, thus requiring the funds be transferred to an internal service
account; and
WHEREAS Facilities Engineering has expanded and upgraded computer
software capabilities and experienced higher Information Technology
Operations and Telephone Communications costs, which may be covered by
a favorable variance in Overtime; and
WHEREAS the Health Division has requested to have their remaining
CRIMP funds currently budgeted as an Operating Transfer Out, restored
to their Budgeted Projects line-item for future projects; and
WHEREAS the Medical Examiner's Office is projected to be
unfavorable primarily due to increased complexity in cases that require
additional analysis and testing, pathological services, and purchase of
specialized cameras for autopsy photos; and
WHEREAS the Health Division is reflecting a favorable variance
sufficient enough to offset the unfavorable variance in the Medical
Examiner's budget; and
WHEREAS additional funds are required to complete the base map
conversion project and other GIS initiatives, and funds are available
within the Remonumentation line-item to offset the cost; and
WHEREAS it is requested that $2,000,000 from the Designated Fund
Balance for Capital Improvement Replacement projects (9407-62000), be
transferred to Non-Departmental Building Fund as an Operating Transfer
to reinstate the amount reduced during the FY 1999 and FY 2000 budget
process; and
FINANCE COMMITTEE VOTE:
Motion carried unanimously on a roll call vote with Millard absent.
WHEREAS it is also requested that $250,000 from the Designated
Fund Balance - Financial System (9407-05000), be transferred to
Management and Budget - Fiscal Services Professional Services line-
item, to cover upgrade expenses related to the HRFIS Financial System;
and
WHEREAS the 52" District Court- Div III, Sheriff's Department,
and Clerk/Register of Deeds have received additional revenue for State
Law Costs, Deferred Offenders and Land Transfer Tax respectfully, and
can be used to support the following budget needs:
Probate Court - Primarily due to State Institution cost increase,
commitments and length of stay. Also, costs for Information Technology
Operations and Telephone communications averaging higher than
anticipated;
Clerk/Register of Deeds - Usage of Emergency Salaries and
Professional Services significantly high to help eliminate backlog in
document recordings;
Board of Commissioners - Due to large number of requests for
updated legal materials, which are not located on the Lexis-Nexis or
Westlaw. corn;
Corporation Counsel - Cost incurred for furniture/equipment due
to addition of new position;
County Executive Administration - Due to increased usage of
Professional Services for Equalization Services associated with the
Utility Defense Fund;
Fiscal Services - Postage expense for mailing payroll receipts,
and financial documents higher than anticipated;
Community and Economic Development Administration - Due to
insufficient funding budgeted for transfer of Solid Waste program from
Facilities Management to Community and Economic Development;
Emergency Management - Due to a need for repair and maintenance
on several sirens currently within the County;
Non-Departmental Contingency - To restore funding available for
FY 2000;
Non-Departmental Misc. Capital Outlay - To restore funding
available for FY 2000;
Information Technology - Operational expenses incurred by several
departments have been significantly higher than budgeted; and
WHEREAS the Personnel - Administration Division is reflecting an
unfavorable variance due to expenses incurred for People Soft
conferences, for which funding has been allocated within the Fringe
Benefit Fund. A transfer of Fringe Benefits funds to the General Fund
- Personnel Division is recommended; and
WHEREAS it is requested that $11,000,000 be transferred from the
Delinquent Tax Revolving Fund (DTRF) to the General Fund to restore
funds previously transferred from Designated Fund Balance to
Information Technology for OAKNet (MAN/WAN) and Court Replacement
Systems.
NOW THEREFORE BE IT RESOLVED that the Board of Commissioners
accepts the Fiscal Year 2000 Third Quarter Financial Forecast.
BE IT FURTHER RESOLVED that the Board authorizes amendments to
the FY 2000 Budget as detailed in attached Schedules A and B.
Chairperson, on behalf of the Finance Committee, I move the
adoption of the foregoing resolution.
FINANCE COMMITTEE
IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS -
52nd District Court
Revenues
Division III (Rochester Hills)
1-32-401100-20001-0297 Assessments
1-32-401100-20001-0501 Filing Fees
1-32-401100-20001-0529 Bond Forfeitures
1-32-401100-20001-0633 Late Penalty
1-32-401100-20001-0711 No Insurance
1-32-401100-20001-0753 Ordinance Fines and Costs
1-32-401100-20001-0813 Probation Fees
1-32-401100-20001-0849 Refund of Defense Atty Fees
Division IV (Troy)
1-32-501100-20001-0529 Bond Forfeitures
1-32-501100-20001-0753 Ordinance Fines and Costs
Total Revenues
Expenditures
Division I (Novi)
2-32-301200-20001-3476 Rent
Division III (Rochester Hills)
2-32-401200-20001-2608 Court Reporter Services
2-32-401200-20001-2640 Defense Attorney Fees
2-32-401200-20001-2988 Interpreter Fees
Division IV (Troy)
2-32-501200-20001-2608
2-32-501200-20001-2640
2-32-501200-20001-2900
2-32-505200-20006-3764
Court Reporters
Defense Attorney Fees
Heat, Lights, Gas, Water
Training, Psych, Medical
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2000 THIRD QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP) ACTIVITIES
ACCOUNT NUMBER
FY 2000 -
ACCOUNT NAME AMENDMENT
1,500
2,000
10,000
4,000
3,000
38,000
15,000
5,000
78,500
50,000
50,000
100,000
178,500
14,600
1,000
30,000
3,600
34,600
10,000
6,300
83,000
30,000
129,300
Total Expenditures $ 178,500
Expendable Equipment Exp.
Leased Vehicles
(44,820)
44,820
22
(25,500)
11,500
8,200
5,800
Overtime
Drafting Supplies
IT Operations
Telephone Communications
Judicial Support
Judicial Support
Judicial Support
Court Services -
Judicial Admin -
Judicial Admin -
Judicial Admin -
Judicial Admin -
Judicial Admin -
Judicial Admin -
Court Services -
- Salaries
- Fringe Benefits
- Building Space
Salaries
Salaries -
Fringe Benefits
Prof. Svcs.
Visiting Judges
Info. Tech. Oper.
IT - Imaging Oper.
Prof. Svcs.
$ (175,000)
(50,600)
(108,000)
(15,000)
20,000
7,000
6,200
30,400
223,000
22,000
40,000
Health/Env. Hlth - Salaries
Health/Field Nursing - Salaries
$ (35,000)
(101,600)
$ (136,600)
Expenditures
Probate Court
2-34-401200-40001-2001
2-34-401200-40001-2075
2-34-401200-40001-6631
2-34-701200-40001-2001
2-34-101200-40001-2001
2-34-101200-40001-2075
2-34-101200-40001-3348
2-34-101200-40001-3800
2-34-101200-40001-6636
2-34-101200-40001-6033
2-34-701200-40001-3348
Expenditures
Sheriffs Department
2-43-023915-20013-4100
2-43-023901-40000-6661
Expenditures
Facilities Engineering
2-14-280000-10000-2002
2-14-280000-10000-4060
2-14-280000-10000-6636
2-14-280000-10000-6675
Expenditures
Health Division
2-16-220200-67000-2001
2-16-236200-46000-2001
$ (23,520.85)
23,520.85
Human Services Department
Expenditures
Health Division
2-16-201300-10000-8001 Health - Operating Transfer Out
2-16-201200-10000-2448 Health - Budgeted Projects
Medical Examiner
2-16-912000-15000-3156 Medical Services Autopsies
2-16-912000-15000-3348 Professional Services
46,000
63,000
Expenditures
Non-Departmental
2-90-210000-21000-9069 Remonumentation
2-90-210000-21000-6053 GIS Automation
Revenue
District Court - Div III (Roch. Hills)
1-32-401100-20001-0251 10% Bond Fees
1-32-401100-20001-0753 State Law Costs
Total
Sheriffs Department
1-43-013301-20000-0431 Deferred Offender
Clerk/Register of Deeds
1-21-140100-01000-0625 Land Transfer Tax
2-16-912000-15000-4100 Exp. Equip. Expense
2-16-912000-15000-4240 Medical Supplies
10,400
17,200
136,600
Designated Fund Balance
Revenue
1-90-190000-14000-1582
Expenditure
2-90-310000-39000-8001
$ (399,520)
399,520
$0
Prior Years Balance - Cap. Improv. $ (2,000,000)
Building Fund - Oper. Trans. Out 2,000,000
$ (250,000)
250,000
Revenue
1-90-190000-14000-1582 Prior Years Balance
Expenditure
2-12-231000-53000-3348 Fiscal Services - Prof. Svcs.
GF/GP OPERATIONS - GENERAL AMENDMENTS
Expenditures
2-34-101200-40001-6675
2-34-301200-40009-3640
2-34-701200-40001-6636
2-21-240100-01000-2018
2-21-240100-01000-3348
2-51-232000-53300-3076
Total Revenues
Probate Court Telephone Comm
Probate Court - State Institutions
Probate Court - Info. Tech. Oper.
Clerk/Reg. of Deeds - Emerg. Sal.
Clerk/Reg. of Deeds - Prof. Svcs.
Law Library - Law Continuations
1,000
20,000
21,000
$ 1,097,998
$ 1,437,150
$ 2,556,148
8,000
500,000
51,700
116,600
434,000
92,000
2-11-210000-01000-9169
2-11-210100-01000-3348
2-12-231000-53000-4284
2-19-210000-13500-2001
2-23-221112-65001-3132
2-90-290000-25000-2564
2-90-290000-25000-9169
Schedule B
Corp. Counsel - Misc. Cap. Outlay
County Exec - Prof. Svs.
Fiscal Services - Postage
Comm & Econ Dev. - Salaries
EMS - Maintenance Contracts
Non-Dept. - Contingency
Non-Dept. - Misc. Capital Outlay
Information Technology Operations
Total Expenditures
7,850
24,000
29,000
10,000
50,000
125,000
10,000
1,097,998
$ 2,566,148
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2000 THIRD QUARTER BUDGET AMENDMENTS
INTERFUND AMENDMENTS
ACCOUNT NUMBER
FY 2000
ACCOUNT NAME AMENDMENT
Fringe Benefit Fund -
Expenditure
2-91-250100-10000-2740 FB - Employ. In-Service Trng. ($6,400)
2-91-350100-10000-8001 FB - Operating Transfer Out - GF $6,400
General Fund - Personnel Administration
Revenue
1-15-101300-10001-1701 Personnel - Oper. Trans. In - GF $6,400
Expenditure
2-15-101200-10001-3756 Personnel - Travel & Conference $6,400
Delinquent Revolving Fund (DTRF)
Revenue
1-22-221702-05000-8001 DTRF - Oper. Trans. Out - GF $ 11,000,000
Expenditure
2-xx-xxxxx-xxx)cx-)oax DTRF - Fund Balance (11,000,000)
$0
General Fund - Non-Departmental
Revenue
1-90-360000-13000-1701 Non-Dept - Oper. Trans. In - IT Dev $ 11,000,000
Expenditure
2-90-310000-40000-8001 Non-Dept - Oper. Trans. Out - GF 11,000,000
w/0 •Cfri 61..alEDU1k.:ii
_
..,
• . JUSTM [ _tY 2000 3r5BoJt
JEACTRTNEURMCBOERP6u6T3E6R- ISNEFRO TCECSH OBPUEDRAG TIONADS
ENT
-- - -- - _ -_
TOTAL YTD PROJECTED ESTIMATED • _ HRFIS HRFIS MONTH 3 MONTHS MONTH 9 3RD QTR. 4TH QTR. FY 2000 FY 2000 :. g g I c A • . Hi EUNIVEPTAI =AI PGA OBJECT AaLIAL ACTUAL ACTUAL. ACTUAL. ACTUAL ACTUAL
Cn . Exec. Adnin. 101 11 210100 01000 8636 40,807.00 34,222.00 38,229.00 111,058.00 38,229.00 . 147,287 $120 000.00
Exec Support 101 11 210500 10000 8636 3,801.00 2,112.00 2,178.00 8,091.00 2,178.00 10,289 $20,000.00 mirstoo
Auditln Admln .. 101 11 220100 01000 6638 30,491.00 24 257.00 _ 26,214.00 80,962.00 26,214.00 107,176 $75,000.00 •'7 . 10
CO # Counsel 101 11 250100 20000 8638 35,855.00 27,343.50 25,885.50 88,884.00 25,885.50 114,770'
B & WWI Instr. . 877 11 250207 30000 6636 15,685.00 11 199.50 10,864.50 37,729.00 10,864.50 48,594` $61,000.0011111Famtuu
6638 0.00 0 $0.00 WOO
SUB-TOTAL DEPARTMENT 11 $126,219.00 $99,134.00 $101,371.00 $326,724.00 $101,371.00 $428 096 $350,676.00 'SMARM XIX. OPAr IMPACT 11 5110,554.00 $87,934.50 $90,506.50 $288,995.00 $90,506.50 $379,501.50 $294,676.00 $84,625.50 --r-
.,
Mgt & Bud Admin 181 12 101200 10001 8638 0.00 0.00 0.00 0.00 0.00 0 $295.00 ($295.00 ...
Equalization Admin Exp. 101 12 240000 10000 6636 188,827.37 139,739.12 144,373.42 452,939.91 L 144,373.42' 597,313 E736,105.00 _15138,791.8
Purchasing Admin - 01 r 12 401200 140010 6836 __1___A___ 18,205.50 12,760.75 14,462.75 45,429.00 14,482.75 59,892 $70,000,00 ($10,108.25
Fiscal Sys Admin 101 12 601200 10001 8636 . 101 816.50 74,230.75 82,382.75 258,410.00 82,382.75- 340,773 -r- $333,000.00 $7 772.75 _
Financial Analysis & Planning 101 12 821200 . 26003 8638 18,330.00 14,508.00 14,224.00 47 080.00 14,224.00 , 61,284 $60,000,00 1,284.00
rIelFniiiir-sement 101 12 701200 10001 6636 - 9120100 70,341.00 78,401.09 239,943.09 7840109 318,344 $250,000.00 ' $08344.18 _
IChIld Su rt Acct FOC 215 12 705212 10001 6636 25,954.25 22526.25 19 124.25 r-- 67,804.75 ' 1912425' 86,729 $150,000.00 $63,271.00
Gen Rev Acc1g Hall Fund 221 12 522222 27001 8636 312.00 312.00 312 51 ,300.00 498040
GFGP Health Fund Exp 221 12 624221 10001 8636 282.00 282.00 564.00 ' 282.00 846 - $0.00 $848110
12 ,6636 0.00 0 $0.00 $0.00
SUB TOTAL DEPARTMENT 12 $424,646.62 $334,385.87 5353,230.28 $1,112,282.75 $353,230.26 $1,485,493 * $1,600,700A0 ANOKA!!
TOTAL GF/GP IMPACT 12 $424,646.62 5334,386.87 5353,230.26 51,112,262.75 $353,23(126 $1,465,493.01 $1,600,700.00 ($135206.99
'central Sys Admin 101 13 131002 00001 8636 0.00 0 $0.00 $0:00
OCIA-Aylation & Transp 681 13 137201 00050 6636 11,734.00 8,189.25 18,523.95 38,427.20 18,523.95 • 58,951 $19,970.00 $36,98I,15
Support Sys Admln Exp 101 13 138201 00010 8838 2,653.00 2,767.00 2512.00 7,932.00 251200' 10444 $14000.00 mom
Record Retention & Mall 101 13 138203 00010 8636 12,738.25 8,492.00 8,492.00 25,720.25 6,492.00 32,212 525,000.00 :r4lt.?.4
Materials Mgrrit Fund 633 13 833002 00020 8636 4586.00 3,740.75 3,570.75 11,997.50 3,57075 15568 $20,000.00 ' ($44116
Radio Communications 060 13 880200 00010 6636 11,129.00 14 858.12 . 25,787.12 25,787 $80,000.00 155trffititi
Leased Vehicle 881 13 681002 00010 8638 5,314.00 6,140.00 5,350.00 15,804.00 5,350.00- 21,154 $30,000.00 458,1011.00
Printing Exp 667 1$ 607302 00010 6638 3,702.00 3,006.00 2,008.00 8,714.00 2,006.00 '10,720 $19,000.00 Pi-2-9416
13 6636 0.00 0 $0.00 :';$;0O
SUB-TOTAL DEPARTMENT 13 _ $51,954.25 $43,973.12 $38,454.70, $134,382.07 $38,454.70 $172,837 $207 970.00 1$35;13323
TOTAL GF/GP IMPACT 13 515,3E19.25 $9,259.00 $9,004.00 , $33,652.25 $9,004.00 $42,656.25 $39,000.00 53,656.25 . - ,
Fac.ilitles Mgt Admin 101 14 210000 10000 6636 0.00 0 53,572.00 : ..( 3AtZ.00
FM&O Admin r 631 14 270000 10000 6838 90,949.50 82,157.00 75,115.00 248,221.50 75,115.00 323,337 $290,000.00 3t4tI
Facilities Engineering , 101 14 280000 10000 8638 15,586.00 11,873.00 10,880.00 37,939.00 10,680.00, 48,819 $441,013.00 L.a.',...• ,
NO Building Safely 831 14 296000 10000 6630 2,268.00 2,088.00 1305.00 5,861.00 1,305.00 6,986 $10,000.00 - 'T-4Y:f.lr.;',#)
14 0838 0.00 0
SUB-TOTAL DEPARTMENT 14 $108,803.50 $95,918.00 $57,100.00 6291,821.50 $97,100.00 $378,922 $344,585.00 . :I iggida
TOTAL GF.43P IMPACT 14 $15,586.00 $11,673.00 $10,680.00 $37,939.00 $10,680.00 $48,619.00 $44.586.00 $4,034.00
- - '• -
Personnel AdmIn 101 15, 101200 10001 8838 0.00 0 $0.00 - • - i: :' I ...,k,..i. „Human Resoutoss Admin 101 16 402200 10001 8638 97,123.25, 70,928.00 87,240.00 235,291.26 87,240.00 302,631 $350,000.00 . - .:r.t i_lii
15 8838 0.00 0
SUBTOTAL DEPARTMENT 16 . $97,123.25 $70,928.00 657,240.00 $235,291.25 $57,240.00 2302,631 $360,000.00 ...... ,- :. te . 1.
TOTAL GFA3P IMPACT 15 $97,123.25 570,92500 587,240.00 5235,291.25 567,240.00 $302,531.25 $350,000.00 047 488.7
Human Svs Adair' 101 18 121000 10000 8838 0.00 0 $298.00 -
Hlth Grnt lmmun Act Plan $ 275 16 155097 54100 6636 9,204.00 2,243.00 2,243.00 13,890.00 2,243.00 15,933 $38,872.00 • • . - ..Lt.,,,,,,1-7.,‘,.;,,,,)
Filth Gmt Fam Plan Sal 275 _ 18 155197 41400 8838 0.00 0 $8,378.00
-...,,manns-10 PM IT3DOADJ.WK4t 1
: E draVadjajag 0 T-•- lc s •
0 0 r QUA ER CO -P TER RVI E UDGE DJUS NT
11110.151.
_ TOTAL YTD PROJECTED ESTIMATED .11.. D.
HRF18 HRFIS MONTH 3 MONTHS MONTHS 3RD QTR. FY 2000 FY 2000 lalit:113IT-,
WM:LE PM 'ilia, 41F1-41.111.4•LII•1:-*14•111 ACTUAL AMIN. AQUI& ACTUAL oft ACTUAL BUDGET ID"Ffli 471
1-111b Gil Health WIC 97-8 Se 275 16 155397 41700 6636 0.00 0 $38,258.00 igr-u=
HI% Gmt Filth Wrk Corn 974 _
275 16 155497 50000 6636 0.00 0 $4,896.00 'IRO .00
Filth Grnt AIDS Courts! 97-8 S 275 16 155797 54300 6636 0.00 0 $5,928.00 . . ss 628.00
Health MCH Block Expendit 275 16 158397 41100 6838 0.00 0 $15,720.00 720:00
MCF Admin 521 18 301200 10000 0836 23 750.00 21,221.00 21,558.00 68,532.00 21,558.00 88,088 $82000.00
Childrens Village Admln Exp 293 18 501200 25001 8838 65 842.50 52,316.75 48,893.76 166 793.00 48 833.75 215,827 $304 380.00 1110.-Taa.10
Med Examiner Admin Ext 101 18 912000 15000 8538 52,205.00 46,274.00 49,129.00 157 808.00 49,129.00 206 737 $108 589.00 698 48.00
Health Div AdmIn Exp v '-- -221 18 201200 10000 8838 283 100.50 249,443.75 251192.75 783,837.00 251,292.75 1,035,130 $804180.00 $230749.75
SF/SC Non-TANF Exp oa-U 277 16 277300 11000 5636 2,880.00 1,223.00 •. 1,223.00 _5_126.00 1,223.00 8 549 $0.00 8,549,00
Environmental Health 221 16 220200 5 01 6836 - "Z3 452.00 - 33,522.00 _33_522..00 110 498.00 33,622.00 144,018 $248,300.00 $104 8200.
Clinic 2211 16 234200 54600 6636 758.00 756.130 756.00 2,268.00 758.00 3,024 $35,000.00 $31,978.00
Dental Serikeirxii - - - --. - ' -2-72i -- - 18 232200 74000 6836 0.00 0 $3,000.00 - $300000 ---, - _
Chlidren's Village Schoot Exp 293 le 555200 25050 8838 0.00 0 _ $65 000.00 $85000.00 - -- re Control Ex_p __ _ ____________ ______ _ 221 16 235200 54400 6836 0.00 0 $433.00 $33400
_ _ _ _
275 16 155997 10000 6636 0.00 0 $10404.00 . $1 ;404.00
_ _ Field NursingExii----------- ---- . - - - ----- 221 16 236200 46000 6636 -------2n.00----- •660.00 680.00 4 113.00 680.00 4 773 $44,420.00 $39647.00
Health Ed & Nutrition Exp 221 16 293200 45000 6836 0.00 0 930,584.00 $30,564.00
Jail Health Prog Exp ,.. 221 15 215200 75110 8636 312.00 - . 282_00 282.00 876.00 282.00 1 168 920,000.00 $18,842.00
Family Counseling Services 276 16 912500 16000 6636 0.00 0 $4,000.00 , $4 '0.00
18 8836 0.00 0 $0.00 . $0.00
SUB-TOTAL DEPARTMENT 16 $484,100.00 1407,941.50 6409,497.50 $1,311,539.00 6409,497.50 $1,721,037 $1,980114.00 1$2611,57TA0 i TOTAL GF/GP IMPACT 16 $458,261.00 $383254.50 $384 475.50 $1,225,991.00 $384,475.50 $1 610,465.50 $1,774 36200 $163,895.50
Public Services Admin 101 17 101200 10001 8838 040 0 82.328.00 IIININInarzri
Veterans Services Admhi 101 17 t•IiiiI.1 30001 8838 34 318.00 22027.00 21,890.00 78 233.00 21,890.00 100 123 $65,087.00 83038.00
Comm Corrections Grant 270 17 302201 10001 8638 90 439.75 8320.25 16 938.00 55,698.00 16938.00 72,035 $43,300.00 829 -
Pretrial Services 101 17 ''I 70111 8636 98,305.50 42,036.00 38 191.25 116 533.75 98 181.25 154,725 $18,000.00 IIIKILUOJEJ
Communl Court Servictp___ 101 17 403200 70231 6638 0.00 0 $8,180.00 $8180110
MSU Ext OC AdmIn . 101 17 501200 10001 6836 18,540.00 18 549.50 19,887.50 56,977.00 19,887.50 76 885 $59,654.00 117,2 .50'
MSU Ext G .3 Moth pro 101 17 502200 50130 8638 1,596.00 1,223.00 1,223.00 4,042.00 1223.00 5,285 $10,000.00 4,73 . 0
4H/CMH Pro. ram Ex. 101 17 520200 50800 5838 1,923.00 915.00 915.00 3,153.00 915.00 4,088 $2322.00 . ' 11 48.90
Animal Control Admin Exp - 101 17 802200 10001 6838 9,843.55 7 11 ,29325 11,378.25 32,315.05 11,378.25 43 693 $15,000.00 - 41 -6 ,00
Circuit Court Probation 101 17 801200 90001 6636 26,688.75 22,883.75 24,816.75 74,380.25 24,818.75 99,197 $87,013.00 4 4 i
Comm Corrections Grnt Pre 270 17 302202 97000 6638 5 334.50 4052.50 3533.50 12 920.50 3 533.50 16 454 $0.00 :$16,454,00
17 8836 0.00 0 $0.00
SUB-TOTAL DEPARTMENT 17 $164,189.05 $131,310.25 6138,773.25 $434,252.55 6138,773.26 6573,028 8310,884-00 ... '418.L141180
TOTAL GF/GP IMPACT 17 512:394.80 511:937.50 $118301.75 $36 634.05 5118,301.75 5483,935.80 5267,564.00 $215,371.80
IT Adrrdn ITF 838 18 836112 10000 6838 = 0.00 0 $0.00 ,..:.:,; • : I
Commutications D/C Oper 636 18 675142 10000 6638 8,913.00 7,328.00 5,922.00 22,163.00 6,92100 28,085 $18,000.00 ' '
8836 0.00 0 $0.00
SUB-TOTAL DEPARTMENT 18 $8,913.00 $7,328.00 $5,922.00 $22,163.00 66,922.00 $28,085 $18,000.00 - "
TOTAL GFIGP /MPACT 18 $aoo $0.00 $000 $0.00 $aoo • $0.00 $aw saoo
. • , .L. ....!..:.:; ....!, • ,17:
COMM & Econ DevAdm 101 19 210000 10000 8898 18 320.50 1691450 1404500 47 80.00 1404500 81 925 $3418300
Dev & Planning 101 10 221000 10000 8038 80117.00 73,431.75 74,105.75 237,054.50 74,1 .75 311,160 $320,000. ,
07-98 CDBG Admin 274 10 697101 80001 6538 0.00 0 $55.871.00 I .
99-00 COBG Admlit 274 10 809101 80001 8838 29,490.00' 20,424.25 19,319.25 60133.50 19119.25 88,553 80.00
99-00 Housing Counselor 274 19 609402 60008 6636 2,588.00 1,882.00 1,88100 8,332.00 1,882.00 8,214 $0.00 .__ _
19 we aoo o $0.00 r -
SUB-TOTAL DEPARTMENT 10 $137 85.50 $112 662.60 $109 2.00 $3511 .00 109 352_00 111111ELJUIA $410 054.00
08108/200003:10 PM IT3DOADJ.WIC41 2
CBJECT NUMBER 6638 - INFO TECH OPERATIONS
FY 2000 3ra QUARTER COI1PUTER SERVICES BUDGET ADJUSTMENT ..
_ _.._ IIIIIIIII.
- • • MIENNE n--- _......._
HRFIS HRFIS MONTH 3 MON TH
TOTAL YTD PROJECTED ESTIMATED
TH6 MON
9 3RD QTFL 4711 QTR. FY 2000 FY 2000 11116.-IYA110
' . B DOET
SIGAIITLE ELM DEPTalt fr,,A# 'ESA OBJECT ACTUAL ACTUAL =MAL ACTUAL ACTUAL MUM. BUDGET _ k, ITrii7 - . e
TOTAL GF/GP IMPACT 19 $105,837.50 $90,346.25 $88,150.75 $284,334.50 $88,150.75 $372,485.25 $354,183.00 $18,302.25
271 20 820982 11000 8838 0.00 0 $0.00 . so:00
OA - VVFD - Adrnin 271 20 872992 . 761-0-701 8836 12,597.00 12,208.00 13,994.00 38,799.00 13,994.00 52,793 ' $3490200 ' 2.fr sotto
20 8836 0.00 0 $0.00 ' $0.00
SUB-TOTAL DEPARTMENT 20 1 $12,597.00 $12,208.00 $13,994.00 $36,799.00 813,994.00 $52 783 $34,902.00 $17,891.00
TOTAL. GF/GP IMPACT 20 $0.00 , $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Clerk/Rag ot Deeds Admit' 101 21 210100 ' 01000 8838 - 0.00 0 $0.00 $0.00
Elections Adrnin Exp 101 21 230100 01000 6836 16,25 12,779.25 13,095.28 42,721.76 13,095.25 55 817 $40,000.00 915 817.00 _
Rmister of Deeds Admin 101 21 240100 01000 8636 t_ 141 352.70 72,030.50 67,975.50, 281,358.70 67,975.50 349,334 _ $500,000.00 2150,865.60
Jury Commisison Exp 101 21 260100 01000 6636 ' 9,658.37 10,252.25 10 377.25 30,287.87 10,377.25 40,865 $15,000.00 $25,666,121
Ad Cnty Clerk min Expend 101 21 220100 01000 8638 3,551.00 L Z620.00 4,506.0-07- 10,677.00 4,506.00 15,183 $18,000.00 ($2,817.00
Clerk VIM! Statistics Exp. 101. _ 21 20000 01000 6536 6,586.02 11,394.95 11,421.75 , 29,402.72 11,421.75 40,824 $25,000.00 $15,824.47 i
Clerk Legal Records Exp. ' 101 21 221000 01000 ' eau 10.506.68 8,271.04 8,292.21 27,089.93 8,292.21 35,362 535,000.00 $362.1.4 -n 21 6836 0.00 0 $0.00 $0.00
SUB TOTAL DEPARTMENT 21 $188,502.02 '---2-117,347.99 $115,667.98 5421,517.97 $115,,6 $537 186 $633,000.00 ($95,1114.01i
TOTAL GF/GP IMPACT 21 $188,502.02 $117,347.99 $115,887.96 $421,517.97 $115,667.96 $537,185.93 $633,000.00 ($95,814.07)
- Treasurer Admln Exp. 101 22 221120' 01000 6636 75,298.00 55,736.25 52,174.25 7 183,207.50 52,174.25 235,382 $240,000.00 44,651:04R .1
6836 0.00 0 $0.00
SUB-TOTAL DEPARTMENT 22 $75,298.00 $55,735.25 $62,174.25 , $183,207.50 $62,174.26 8236,382 $240,000.00 ($4;81/41 -1
TOTAL GF,GP IMPACT 22 $75,298.00. $55,735.25 $52,174.25 $183,207.50 $52,174.25 $235,381.75 $240,000.00 4618.25,
Health EMS 221 23 221112 65001 6836 18,388.00 16,563.00 24,088.00 57,035.00 24,086.00 81,121 $45,000.00 $98:121'.04
CLEM/Operations 635 23 635152 10010 6636 180,988.40 184,060.51 184,881.32 549,730.23 184,681.32 734,412 $736,618.00 • MASA
Voice Communications Exp 660 23'680712 10010 6636 11,833.00 11,833.00 11,833.00 23,688 $0.00 $23 .00 t.
8838 0.00 (Lop 0.00 0 $0.00 , $0410.
SUB-TOTAL DEPARTMENT 23 $197,374.40 $200,823.51 $220,600.32 $618,598.23 8220,600.32 8839,199 $781,818.00 " *$67,580.68
TOTAL GFP IMPACT 23 $16,388.00 $16,583.00 $24,086.00' $57,035.00 $24,088.00 $81,121.00 $45,000.00 $36,121.00
FOC Med Supp 97/98 Perso , 276, 31 004201 , 10004 6636 2,188.00 814.00 1,378.00 4,378.00 1,378.00 5,756 $15,082.00 9,325,0
Circuit Court Admin 101, 31 101200 10001 8636 232,960.99 170,110.27 174,267.50 677,358.76 174,267.60 761 626 5500 000.00
FOC Admin FOC Fund 215 31 201200 10004 6836 9743477 71,262.33 72,094.05 240,791.16 72,094.05 312885 $300,000.00 ' 4179
CC Judicial Exp 101 ' 31 105200 '10001 8638 ,---
0.00 o $12,777.00 '':.,'$*i77ijO
CC Judicial Law En? Grant Exp 270 31 001200 10002 6838 234.00 174.00 174.00 582.00 174.00 758 $2,910.00 :492'1151,1)
6836 0.00 o $0.00 -! ,. • •
SUB-TOTAL DEPARTMENT 31 $332,835.78 $242,350.60 $247,913.55 $823,109.81 8247,813.55 $1,071,023 $838,789.00 ........ z
TOTAL GFA3P IMPACT 31 $330,415.76 $241,372.60 $246,361.55 $818,149.91 $246,361.55 $1,064,511.46 $812,777.00 $251,734.46 . . . . , ..
DC Div I Admin 101 32'201200 20001 6838 108,869.65 84,368.18 80,92742 274,165.25 80,92742 355,093 $300,000.00 •
101 _ 32 205200 20006 6836 1,892.00 1,278.00 348.00 3,318.00 348.00 3,666 $7,000.00
DC Div II Admin 101 32 301200 20001 6830 43,181.43 33,028.62 32,897.75 108,687.70 32,897.75 141,585 $100,700.00 -71TP;-, 0
101 1- 32 305200 ' 20008 8838 858.00 738.00 735.00 2,334.00 735.00 3 072 $10000.00 , , -
.51 74,587.78 240,228.77 74,567.78 314,797 1280,000.00 DC Div ill Admin 101 32 401200 20001 ens 96,192.50 69468 i-
DC Div III Probadon 101 32 406200 20008 8838 1,092.00 912.00 912.00 2,918.00 912.00 3,828 $37,480.00 -
DC Div IV Admin 101 32 501200 20001 8838 74,024.75 57,817.27 87,495.82 199,337.04 67,495.81 288,834 9150,000.00 "
DC Div IV Probation 101 32 505200 20008 6636 18,528.00 14,595.00 10,915.00 44,138.00 10 915.00 55,053 $15,000.00 :. ,
32 8838 0.00 0 WOO - I. I:
SUB-TOTAL DEPARTMENT 32 $344,415.33 $282,305.48 $288,501.75 $875,325-68 $289,601.75 $1,143,927 $900,180.00 --",l''
TOTAL GFiGP IMPACT 32 . $344,418.33 $262,305.48 $288,601.75 $875,325.56 $268,601.75 $1,143,927.31 $904160.00 $243,747.31
nain8/200003:10 PM 3 ITSDOADJANK41
OBJECT NUMBER 6636 - INFO TECH OPERATIONS .... . FY 2000 3rd QUARTER COMPUTER SERVICES BUDGET ADJUSTMENT -
TOTAL YID PROJECTF-D ESTIMATED Fiti0k0.
HRFIS HRFIS MONTH 3 MONTH 6 MONTH 9 3RD QTR. 4TH QTR. FY 2000 FY 2000 - jrAling ElINDDEILM =Al Ka OBJECT AQUAL ACTUAL ACTUAL ACSUAL ' ACTUAL ACTUAL 131/00.EI ASIBBWr
PC JudiciaVAdmin 101 34 101200 40001 6838 161,798.75 165,114.00 158,283.00 473,175.75 156,283.00 029,439 $250,000.00 $370,4107
PC JudIdal/Support 101 34 401200 40001 6838 118,805.25 85,377.25 98,289.07 300,451.57 96,269.07 398,721 6420,000.00 (s2p27it3e
101 34 8838 0.00 0 $0.00 . . 00
SUB-TOTAL DEPARTMENT 34 $280,604.00 $240,491.25 ;252,532.07 ;773,527.32 $252,532.07 $1,026,159 $670,000.00 05;44
TOTAL GF/GP IMPACT - 34 $284604.00 $240,491.25 $252,532.07 $773,627.32 $252,532.07 $1,026,159.39 $670,000.00 $356,159.39 -t- -
Prosecutor Acimin 101 41 211000 10000 6636 270,311.25 182,090.501 189,852.50_ 842,254.25, 189,852.50 832,107 $800,00tiol 02,06.75
PA CRP 97/98 Other 272 41 294138 10000 6838 28,794.00 20.984.001 21 925.00 71_703.00 21,925.00 93,628 .1._ $0.00 49313E6.00 ._ _ _____
PA Auto Theft 97/08 Personnel 272 41 294018 10000 6638 0.00 0 $575.00 ift75. 0
PA CRP 97/98 Per. 272 4i'294118 10000 686:386 _ 0.00 0 $8,200.00 ($8,200.00,
41 0.00 0 $0.00 .$0,00
SUB-TOTAL DEPARTMENT 41 . 6299,105.25 $203,074.50 $211,777.60 $713,957.25 $211,777.50 $925,735 $608,775.00 _. ;118 969.75 I TOTAL GF/GP IMPACT 41 $270,311.25 $182,090.50 $189,852.50 $642,254.25 5189,852.50 5832,106.75 $800,000.00 $32,106.75 -
Admin Services Exg_ _ 101 43 023201 10000 6638 0.00 . -1 $0.00 $0:00
Corrective Svs Admin 101 '5'23301 21400 ' 8636 532,158.50 489,965.25 462 944.25 ' 1A85,066.00 ' 46Z94-472it 1 928,010 ---1. $369400 31,924,318,25
Detention Facilities Exp 101 43 23310 20021 6636 0.00 0 $1,806,191.00 ($1,800,101.00
Lovescan Phase IIIA 98 Exi._ 272 43 ' 971702 20020 6636
___ j 6638
0.00 0 $411,157.00 • ($411.157.00
_ 43 0.00 0 $0.00 0:00
SUB-TOTAL DEPARTMENT 43
'"
---._.- $532,1_,56.60 $469,965.25 $462,944.25 ;1,465,066.00 , $462,94425 $1,928,010 _42 221,042.00 . $29 031.71
TOTAL GF,GP IMPACT 43 5532,156.50f $469,965.25 $462,944.25 $1,465,066.00 $482,944.25 $1,928,010.25 $1,809,885.00 $118,125.25 -
Commissioners & Admin 101 51 211000 10000 6638 55 428.00 52 755.00 50,892.00 159,075.00 50,892.00 s 209,967 $126,000.00 , , $830167.00
Research Library_ 101 51 231000 53000 6838 52 828.00 40 146.00 38,010.00 130,984.00 38,010.00 168,994 50.00 160:99.1.04
Law Library - 101 51 232000'53300 6836 35,730.00 24,870.00 25,306.00 86,005.00 25,390.00' 111,401 $0.00 "1.121„*401:00-
Library Board GF 101 61 233000 63500 8638 1,580.00 2,206.00 1,410.00 5,175.00 1,410.00 6,585 $203,000.00 . ($101a0f4q
51 6838 0.00 0 $0.00 • - • MAO
SUB-TOTAL DEPARTMENT 51 $145,546.00 $119,985.00 $115,708.00 $381,239.00 $115,708.00 $496,947 $329,000.00 . t18/60117:00
TOTAL GP/GP IMPACT 51 $145,548.00 $119,985.00 $115,708.00 $381,239.00 $115,708.00' $496,947.00 5329,000.00 $167,947.00
. , . . .
Admin 208 63 201000 10001 6836 42,998.00 31,606.00 74,804.00 31,606.00 106,210 $164,483.00 ($580:13.00
_.. _ Recreation Section Admin 208 53 205000 10001 8636 11,084.00 8,730.00 19 814.00 8 730.00 28,544 $38,448.00 • 4,,toto
Addison Oaks 208 53, 215000 10001 6636 5,443.00 4,825.00 10 288.00 4 825.00 151)93 $29,98
Groveland Oaks 208 53 220000 10001 ' 6836 1,047.00 , 987.00 2,034.00 987.00 3,021 $6,500.00 7 ($6,479,430
Independence Oaks 208 53 225000 10001 8638 H 1,908.00 , 1,878.00 3,788.00 1,878.00 5,664 $16,656.00 • r • -..r
Waterford Oaks AC 208 53 235000 10001 ' 6638 1,534.00 1,318.00 2,850.00' 1,316.00 ' 4,168 $5,136.00 ( 1
Nature Program 208 63 250000 10001 8838 1,862.00 1,662.00 3,324.00 1,862.00 4,986 $10,538.00 t ....
White Lake Oaks GC 208 53 228000 10001 6838 2,880.00 2,184.00 5,044.00 2,164.00 7,208
Glen Oaks GC • 200 53 227000 10001 8836 2,880.00 2,184.00 5,044.00 2,104.00 7 208
$13,045.00 -•1-4,....-1,•'‘ ...v.t..1:!..
$13,045.00 --„,.. t,:__-.L
Red Oaks GC 208 63 228000 10001 8638 2,880.00 2,184.00 5,044.00 Z164.00 7 208 $13,045.00 ;,. L ' t r.:. _ ,
ItechnIcal Support Exp. 208 53 210000 10001 6838 3,759.00 3,298.00 7,055.00 3,298.00 10,351 $15,384.00 '''',. t 7-tr -: p.11 4-_-__ ---,-44.
'Springfield Oaks GC 208 53 230000 10001 6836 2,880.00 2,184.00 5,044.00 2,164.00 7,208 813,045.00 '" • t : ,-.1.r.in"_:4;)
53 8838 0.00 0 $10.00 •
SUB TOTAL DEPARTMENT 53 $0.00 $80,955.00 $62,958.00 $143,911.00 $82,958.00 $206,817 $339405.00 F--- .
TOTAL GFIGP IMPACT 53 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 30-00r
CMH Total 222 56 8636 0.00 0
6838 - -- r,..:-- --., --
0.00 0 $0.00 :,•-•-, •
SUB-TOTAL OTHER DEPARTMENTS $0.00 $0.00 $0.00 $0.00 $0.00 $0 $0.00
TOTAL GF,OP IMPACT 55 , $0.00, $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
08/06/200003:10 PM IT3DOADJ.VVK4 4
• BJECT NUMBER 6636 - INFO TECH OPERATIONS
FY 2000 3r. QUARTER COMPUTER S RVICES BUDGET ADJUSTMENT - _ EMS
_ • • 11111111111611111
TOTAL YTD PROJECTED ESTIMATED — a 4.qn n
— HRFIS HRFIS MONTH 3 MONTH 6 T MONTH 9 3RD QTR. 4TH QTR. FY 2000 FY 2000
- .-- MAME BIBB,DEPTA _RCM ECA OBJECT ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL — ACTUAL BUDGET .11'1.4:4
Gamine Fund Adrnin 101 61 211001 10000 6636 26,900.59 24,193.00 23,179.44 74,273.03 23,179.44 _ 97 462 $98,384.00 ,
Gan Adrian Drain & Sew Ma 701 61 227318 21100 6636 690.00 660.00 942.00 2,292.00 942.00 3 234 $4 829.00 11111111kiCAW.) -i--
81 6636 f 0.00 0 $0.00
SUB-TOTAL DEPARTMENT 61 $27,590.59 *24,853.001 $24,121.44 $76,565.03 $24,121.44 $100 686 1103 13.00 . $2.5
TOTAL GP/GP IMPACT 61 $26,900.69 $,i93.00i $23,179.44 $74,273.03 $23,179.44 $97,452.47 $98,384.00 $931.53
_ $0.00 12 808.00 Pro Tax___0(4___a Iturend e ---Tcri 90 210000 44310 6636 4,678.00 4,112.00 8,690.00 _j12.00 12 802 — .
8836 . 0.00 0 $0.00 $0.00
SUB-TOTAL DEPARTMENT 90 $0.00 $4,578.00 $4,112.00 $8 690.00 _ $4 112.00 F114102- ---1:- - — $0.00 - 1280200 - TOTAL GP,GP IMPACT 90 $0.00 $4,578.00 $4,112.00 $8,690.00 $4,112.00 $12,802.00 $0.00 $12,802.00
-
-GRAND TOTAL 3RD QUARTER BUD ET ADJUSTMENT FOR INFO-7 CH $4,049,852.02 $3,338,054.07 $3,364,043.80 $10,751,949.89 $3,364,043.80 $14,115,994 513 470 287.00 $645,728.69
TOTAL GF/GP IMPACT $3 566 330.87 $2,841,345.94 $2,876,808.63 , $9,284,485.34 $2,876,808.53 $12,161,293.87 $11,063 296.00 $1,097,997.87
061001200003:10 PM IT3DOADJ.VVK4
SUB-TOTAL GENERAL FUND
GENERAL PURPOSE FUNDS
Intergovernmental
Charges for Services
SUB-TOTAL GP FUNDS
TOTAL GF/GP FUNDS
Resources carried forward
$167,449,700.00
33,362,200.00
65,342,879.00
19,650,000.00
$167,449,700.00
34,375,771.00
67,896,667.00
19,650,000.00
$167,449,700.00
34,802,271.00
72,334,567.00
19,650,000.00
$285,804,779.00 $289,172,138.00 $294,238,538.00
$12,640,000.00 $12,640,000.00 $12,640,000.00
6,000,845.00 6,124,020.00 6,261,120.00
$24,902,270.00
11,131,134.00
22,664,421.00
$58,697,825.00
$15,582,811.00
79,744,321.00
$95,327,132.00
$9,801,841.00
3,079,564.00
2,339,864.00
2,695,910.00
3,191,621.00
$28,758,283.70
11,408,091.03
23,873,336.20
$15,780,531.03
82,723,240.36
$10,470,789.90
3,699,796.04
2,341,087.02
2,680,064.73
3,258,130.28
$26,462,583.70
11,657,891.03
24,225,038.20
$14,966,031.03
81,379,440.36
$10,624,969.90
3,667,896.04
2,291,087.02
2,815,064.73
3,258,130.28
$61,839,710.93 $62,345,510.93
$98,503,771.39 $96,345,471.39
$21,108,800.00 $22,449,847.97 $22,656,947.97
$5,167,170.00 $5,390,045.97 $5,440,045.97
18,473,200.00 17,537,672.42 17,808,772.42
1,682,735.00 1,725,707.16 1,602,007.16
1,739,822.00 1,742,408.53 1,664,608.53
3,973,851.00 4,134,764.59 4,141,184.59
54,204,803.00 56,596,300.69 55,377,500.69
7,562,236.00 7,901,821.45 7,458,721.45
757,400.00 905,787.07 909,587.07
4,360,068.00 4,598,520.04 4,489,420.04
$95,921,285.00 $100,531,027.92 $98,891,827.92
$295,700.00
(249,800.00)
(551,700.00)
($505,800.00) -0.82%
$814,500.00
1,343,800.00
$2,158,300.00 2.19%
($154,200.00)
32,100.00
50,000.00
(135,000.00)
0.00
($207,100.00) -0.92%
($50,000.00)
(271,100.00)
123,700.00
77,800.00
(6,400.00)
1,218,800.00
443,100.00
(3,800.00)
107,100.00
$1,639,200.00
1.11%
-2.19%
-2.33%
-1.47%
0.87%
2.14%
-5.04%
0.00%
-0.93%
-1.55%
7.17%
4.47%
-0.15%
2.15%
5.61%
-0.42%
2.33%
1.63%
5.16%
1.82%
TOTAL DEPARTMENTS $271,055,042.00 $283,324,358.21 $280,239,758.21 $3,084,600.00 1.09%
TOTAL GOVERNMENTAL EXPENDITURES $307,991,233.00 $334,135,102.27 $330,750,502.27 1.01% $3,384,800.00
FY 2000 THIRD QUARTER FINANCIAL REPORT
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
FY 2000
ADOPTED
BUDGET
BUDGET
AS
AMENDED
FY 2000
FORECAST
AMOUNT
FAVORABLE/
(UNFAVORABLE) PERCENT
REVENUE
GENERAL FUND
Taxes
Intergovernmental
Charges for Services
Miscellaneous Revenue
$18,640,845.00 $18,764,020.00 $18,901,120.00
$304,445,624.00 $307,936,158.00 $313,137,858.00
$3,545,609.00 $26,198,944.27 $26,198,944.27
TOTAL GOVERNMENTAL RESOURCES $307,991,233.00 $334,135,102.27 $339,336,802.27
$0.00 0.00%
426,500.00 1.24%
4,837,900.00 8.85%
0.00 0.00%
$5,064,400.00 1.75%
$0.00 0.00%
137,100.00 2.24%
$137,100.00 0.73%
$5,201,500.00 1.69%
$0.00 0.00%
$5,201,500.00 1.56%
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court
52nd District Court
Probate Court
TOTAL ADMIN. OF JUSTICE
LAW ENFORCEMENT
Prosecuting Attorney
Sheriff
TOTAL LAW ENFORCEMENT
GENERAL GOVERNMENT
Clerk/Register of Deeds
Treasurer
Board of Commissioners
Library Board
Drain Commissioner
TOTAL GENERAL GOVERNMENT
COUNTY EXECUTIVE
County Executive Admn.
Management and Budget
Central Services
Facilities Management
Personnel
Human Svs.
Public Services
Information Technology
Community & Economic Dev.
TOTAL COUNTY EXECUTIVE
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NON-DEPARTMENTALS $36,936,191.00 $50,810,744.06 $50,510,744.06 $300,000.00 0.59%
General Fund/General Purpose
Favorable/(Unfavorable) $0 $0 $8,586,100.00 $8,586,100.00 ------------ -
OAKLAND COUNTY LAW LIBRARY ROUTE CODES
Code Name How to Route
OL means Law Library
OLARC Law Library Closed Stacks Process and shelve on appropriate aisle
OLHELP Law Library Aisle 42 Process and shelve on appropriate aisle
OLMAIN Law Library Main Aisles Process and shelve on appropriate aisle
OLPERI Law Library Periodical Aisles Process and shelve on appropriate aisle
OLREF Law Library Reference Desk Process and shelve on appropriate aisle
ST means Satellite
STAIRP Oakland County Airport Mail to the attention of Karl Randall
STANDR Circuit Court Judge Andrews 1st Floor Ct. House 868-0360
STASGtsi Assignment Clerk Mail to Assignment Clerk
STBRCK Circuit Court Judge Breck 1st floor Ct. House 858-0336
STBTCK District Court 52/1 Judge Batchik They Pick Up
STCARN District Court 52/3 Judge CARNIAK They Pick up
STCCPR Circuit Court Probation Mail to Circuit Court Probation
STCHVL Children's Village Mail to Children's Village
STCIVL Visiting Civil Judge Deliver to Court Administration
STCLRK County Clerk Mail to County Clerk
STCOPR Circuit Court Judge Cooper 3rd floor Ct. House 868-0337
STCORP Corporation Council 3rd floor West Wing Extension
STCTAD Court Administrators Office 2nd floor West Wing Extension
STDCTA District Court 52/1 Pick up (call 305-6128)
STDCTB District Court 52/2 Pick up (call 635-4999)
STDCTC District Court 52/3 Pick up (call 858-6630
STDCTD District Court 52/4 Pick up (call 528-0406
STDRRY District Court 52/4 JUDGE DRURY Pick up
STDRUG Drug Judge 2nd floor Ct. House 858-9894
STELCT Elections Mail to Elections
STECILN Equalization Mail to Equalization
STESTS Probate & Estates Lisa Symula - stamp! Dean no stamp write 1st floor
STFOC Friend of Court Mail to Friend of the Court
STGLBT Circuit Court Judge Gilbert 5th floor Ct. House 858-5282
STGRAN Circuit Court Judge Nancy Grant 4th floor Ct. House 858-0358
STGRNT Probate Court Judge Berry Grant 1st floor Ct. House 858-0286.
STHALL Probate Court Judge Hallmark 2nd floor Ct. House
STHWRD Circuit Court Judge Howard 4th floor Ct. House 858-5284
routelist.xls Page 1 of 2 8/17/00
tifIX1.#11VD GUUNTY LAW LIBRARY ROUTE CODES
Code Name How to Route
STJLLB Jail - Brown Road East & West (2c) deliver to office in Research Lib. (by back door)
STJLLC Jail - trustee camp deliver to office in Research Lib. (by back door)
STJLLM Jail - 2nd floor annex, men deliver to office in Research Lib. (by back door)
STJLLP Jail - Main deliver to office in Research Lib. (by back door)
STJLLS Jail - Southfield Facility deliver to office in Research Lib. (by back door)
STJLLW Jail - 1st floor annex, women deliver to office in Research Lib. (by back door)
STJRCL Jury Clerk Mail to Jury Clerk
STKUHN Circuit Court Judge Kuhn 2nd floor Ct. House 858-0032
STLMOR Circuit Court Judge Langford-Morris 3rd floor Ct House 858-0363
STMCNL District Court 5212 Judge McNally Pick up
STMDON Circuit Court Judge McDonald 2nd floor CL House 858-0342
STMKNZ District Court 52/2 Judge MacKenzie Pick up
STMOOR Probate Judge Moore 1st floor Ct. House 858-0250
STMSTR Circuit Court Judge Mester 3rd floor Ct. House 858-0355
STNCLS Circuit Court Judge Nichols 5th floor Ct. House 858-0368
STNCSN District Court 62/3 Judge Nicholson Pick up
STNLSN District Court 52/3 Judge Nelson Pick up
STOBRC Circuit Court Judge Cohen O'Brien 4th floor Ct. House 452-2000
STPCTA Probate Court Administrator Bedlam - stamp / Harper no stamp write - deliver 2d floor
STPOTS Circuit Court Judge Potts 5th floor CL House
STPROS Prosecutors NO STAMP 3rd floor our building call before large del.
STPRTR Pretrial Services Mail to Pretrial services
STPWRS District Court 52/1 Judge Powers Pick up
STREGD Register of Deeds Mail to Register of Deeds
STRESA Research Attorneys ground level of this building DOOR IS LOCKED KNOCK
STRFRE Referees Mail to Referee Bob Martin
STRMBS Reimbursement Mail to Reimbursement
STSHHY District Court 5213 Judge Sheehy Pick up
STSHRF Sheriff Department Mail to Sheriffs Department
STSLVR Probate Court Judge Silver 1st floor Ct. House 858-2240
STSNLZ Circuit Court Judge Schnelz 1st floor Ct House 858-5280
STSSNK Circuit Court Judge Sosnik 2nd floor CL House 858-0340
STTOTL SATELLITE TOTALS Just information as to total # of copies for Sets.
STTYNR Circuit Court Judge Tyner 2nd floor CL House 858-2005
SUTRA Extra Copies Margaret will tell you were to shelve
SWUNG Circuit Court Judge Young 2nd floor Ct. House 858-0365
routelistxls Page 2 of 2 8/17/00
7
28
35
COUNTY OF OAKLANI _
FY 2000 THIRD QUARTER FINANCIAL "en ing!
TABLE OF CONTENTS
PAGE
1
to be delivered
3
TRANSMITTAL LETTER
SUGGESTED RESOLUTION (including amendments)
SUMMARY OF GENERAL FUND/GENERAL PURPOSE REVENUES
AND EXPENDITURES BY DEPARTMENT
FY 2000 THIRD QUARTER REVENUE EXPLANATIONS 4
Detailed sheets for each Department/Division showing
variances for general fund/general purpose revenue with
explanation of variance.
FY 2000 THIRD QUARTER EXPENDITURE EXPLANATIONS
Detailed sheets for each Department/Division showing
variances for general fund/general purpose expenditures,
with explanation of variance.
INTERNAL SERVICE FUND REPORTS
Summary of Revenues and Expenses with explanation of
variances from Budget.
BUDGET AMENDMENTS
List of Miscellaneous Resolutions authorizing amendments
to the Adopted Budget.
INMATE WAVIER REPORT 38
L. BROOKS PATTERSON, OAKLAND COUNTY EXECUTIVE
Jeffrey C. Pardee, Director
Laurie Van Pelt, Deputy Director
OAKLAND;
COUNTY MICHIGAN
DEPARTMENT OF MANAGEMENT AND BUDGET
TO:
FROM:
SUBJECT:
DATE:
Members of the Finance Committee
Jeff Pardee, Director of Management and Budget
Letter of Transmittal - Fiscal Year (FY) 2000 Third Quarter Financial Forecast
August 31, 2000
Attached please find the FY 2000 Third Quarter Financial Forecast. In total, the County is
forecasted to have, by the end of FY 2000, a $8,586,100 favorability in the General
Fund/General Purpose operations. This projected amount equals 2% of the FY 2000 General
Fund/General Purpose Amended Budget. The overall favorability includes receiving an
estimated $5,201,500 more revenue than budgeted (1.56%), and expending $3,384,600 less than
budgeted (1.01%).
REVENUES
General Fund/General Purpose revenues are estimated to be 1.56% above budget or $5,201,500.
This favorability reflects a number of events:
A. GENERAL FUND - INTERGOVERNMENTAL REVENUE (fav. $426,500)
This favorability results from an increase in the state payments received for
Cigarette Tax. The same as reported in the first and second quarter forecast.
B. GENERAL FUND- CHARGES FOR SERVICES (fav. $4,637,900)
This category is projected to be substantially favorable primarily due to the high
activity real estate activity as evidenced in increased revenue for the Register of
Deeds for Mortgages and Recording Fees (approx. $2.0 million). In addition,
revenue from the State for diverted felons is approximately $2.5 million favorable
due to active invoicing by Fiscal Services staff of prisoners whose offenses were
committed prior to 1/1/99.
EXPENDITURES
In total, expenditures are estimated to be 1.01% below budget, or $3,384,600. Primarily the
favorability reflects a decline in the Sheriff Department's hospitalization, housing expense and
medical services for prisoners (approximately $1.1 million). Almost the entire remaining
amount of favorability is related to vacant and underfilled positions (known as turnover).
At this time, the following departments are projected to be over budget by FY 2000 year-end:
EXECUTIVE OFFICE BUILDING 34 EAST • 1200 N TELEGRAPH RD DEPT 409 • PONTIAC MI 48341-0409 • (248) 858-0487 • FAX (248) 858-9172
1. District Court - For most of the divisions, it is primarily due to insufficient appropriation
for Information Technology Operations, in comparison to actual usage ($230,000).
2. Probate Court - State Institutions continue to be unfavorable ($500,000) due to the
increase in per diem rates (approximately 40%), the number of commitments and an
increase in the length of stay. In addition Professional Services is projected to be
unfavorable $40,000 due to the increase in domestic evaluations in Court Services.
3. Clerk/Register of Deeds - The total unfavorability ($154,200) is the result of substantial
usage of Emergency Salaries and Professional Services to eliminate the backlog in
recording documents (approximately $550,600 unfavorable). However, this is partially
offset by favorable Salaries and Fringe Benefits due to Imaging Conversion within the
County Clerk's division ($134,800), turnover in Elections and Register of Deeds
($100,000), and a reduction Information Technology Operations expense ($134,000).
4. Board of Commissioners - This is primarily due to a large number of requests for
updated legal materials (some are unavailable on Lexis-Nexis or Westlaw. Corn).
5. County Executive Administration - An increase in use of Professional Services
(approximately $24,000) associated with the Utility Defense Fund, which is primarily the
result of Equalization Services. Also, there has been an increase in acquisition of
computer equipment and employee training, resulting in an unfavorable variance of
$26,000.
6. Management and Budget - This is primarily due to program and training costs
associated with the Financial System upgrade (Performance Series 2.1). However, there
are funds available in the Designated Fund Balance for expenses related to the Financial
System and any upgrades.
7. Personnel - Travel and Conference is projected to be unfavorable as funds to cover
attendance to People Soft Conferences were not budgeted within the department.
However, there are funds budgeted in the Fringe Benefits Fund to cover this expense.
8. Emergency Management - Information Technology Operations are unfavorable due to
increased usage ($24,300), offset by favorable Overtime ($21,700) due to fewer
emergency calls than anticipated.
A budget amendment is recommended for these departments to make the total budget whole.
Please review the attached. Should you have any questions, please feel free to contact me, the
Financial Analyst involved with the department, our committee staff liaison, Tim Soave, or
Quarterly Forecast Coordinator, LaVerne Smith.
FY 2000 THIRD QUARTER FINANCIAL REPORT
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
FY 2000 BUDGET AMOUNT
ADOPTED AS FY 2000 FAVORABLE/
BUDGET AMENDED FORECAST (UNFAVORABLE) PERCENT
REVENUE
GENERAL FUND
Taxes $167,449,700.00 $167,449,700.00 $167,449,700.00 $0.00 0.00%
Intergovernmental 33,362,200.00 34,375,771.00 34,802,271.00 426,500.00 1.24%
Charges for Services 65,342,879.00 67,696,667.00 72,334,567.00 4,637,900.00 6.85%
Miscellaneous Revenue 19,650,000.00 19,650,000.00 19,650,000.00 0.00 0.00%
SUB-TOTAL GENERAL FUND $285,804,779.00 8289,172,138.00 $294,236,538.00 $5,064,400.00 1.75%
GENERAL PURPOSE FUNDS
Intergovernmental $12,640,000.00 $12,640,000.00 $12,640,000.00 $0.00 0.00%
Charges for Sen/ices 6,000,845.00 6,124,020.00 6,261,120.00 137,100.00 2.24%
SUB-TOTAL GP FUNDS $18,640,845.00 $18,764,020.00 $18,901,120.00 $137,100.00 0.73%
TOTAL GF/GP FUNDS $304,445,624.00 $307,936,158.00 $313,137,658.00 $5,201,500.00 1.69%
Resources carried forward $3,545,609.00 $26,198,944.27 $26,198,944.27 $0.00 0.00%
TOTAL GOVERNMENTAL RESOURCES $307,991,233.00 $334,135,102.27 $339,336,602.27 $5,201,500.00 1.56% .
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court
52nd District Court
Probate Court
TOTAL ADMIN. OF JUSTICE
$24,902,270.00 $26,758,283.70 $26,462,583.70 $295,700.00 1.11%
11,131,134.00 11,408,091.03 11,657,891.03 (249,800.00) -2.19%
22,664,421.00 23,673,336.20 24,225,036.20 (551,700.00) -2.33%
$58,697,825.00 $61,839,710.93 $62,345,510.93 ($505,800.00) -0.82%
LAW ENFORCEMENT
Prosecuting Attorney $15,582,811.00 $15,780,531.03 $14,966,031.03 $814,500.00 5.18%
Sheriff 79,744,321.00 82,723,240.36 81,379,440.36 1,343,800.00 1.62%
TOTAL LAW ENFORCEMENT $95,327,132.00 898,503,771.39 $96,345,471.39 $2,158,300.00 2.19%
GENERAL GOVERNMENT
Clerk/Register of Deeds $9,801,841.00 $10,470,769.90 $10,624,969.90 ($154,200.00) -1.47%
Treasurer 3,079,564.00 3,699,796.04 3,667,696.04 32,100.00 0.87%
Board of Commissioners 5,035,774.00 5,021,151.75 5,106,151.75 (85,000.00) -1.69%
Drain Commissioner 3,191,621.00 3,258,130.28 3,258,130.28 0.00 0.00%
TOTAL GENERAL GOVERNMENT $21,108,800.00 $22,449,847.97 $22,656,947.97 ($207,100.00) -0.92%
COUNTY EXECUTIVE
County Executive Admn. $5,167,170.00 $5,390,045.97 $5,440,045.97 ($50,000.00) -0.93%
Management and Budget 16,473,200.00 17,537,672.42 17,808,772.42 (271,100.00) -1.55%
Central Services 1,682,735.00 1,725,707.16 1,602,007.16 123,700.00 7.17%
Facilities Management 1,739,822.00 1,742,408.53 1,664,608.53 77,800.00 4.47%
Personnel 3,973,851.00 4,134,764.59 4,141,164.59 (6,40.00) -0.15%
Human Svs. 54,204,803.00 58,596,300.69 55,377,500.69 1,218,800.00 2.15%
Public Services 7,562,236.00 7,901,821.45 7,458,721.45 443,100.00 5.61%
Information Technology 757,400.00 905,787.07 909,587.07 (3,800.00) -0.42%
Community & Economic Dev. 4,360,068.00 4,596,520.04 4,489,420.04 107,100.00 2.33%
TOTAL COUNTY EXECUTIVE $95,921,285.00 $100,531,027.92 $98,891,827.92 $1,639,200.00 1.63%
TOTAL DEPARTMENTS $271,055,042.00 $283,324,358.21 $280,239,758.21 $3,084,600.00 1.09%
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NON-DEPARTMENTALS $36,936,191.00 $50,810,744.06 $50,510,744.06 $300,000.00 0.59%
TOTAL GOVERNMENTAL EXPENDITURES $307,991,233.00 $334,135,102.27 $330,750,502.27 $3,384,800.00 1.01%
General Fund/General Purpose
Favorable/(Unfavorable) $0 $0 $8,586,100.00 88,586,100.00
695,000.00 695,000.00 695,000.00
COUNTY OF OAKLAND
FY 2000 THIRD QUARTER REPORT
RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL
SPECIAL REVENUE AND PROPRIETARY FUNDS
FOR YEAR ENDING SEPTEMBER 30, 2000
BUDGET
AS
ADOPTED
BUDGET AMOUNT
AS FY 2000 FAVORABLE/
ADJUSTED FORECAST (UNFAVORABLE) PERCENT
REVENUE
PROPERTY TAXES
1999 Tax Levy
NET CURRENT PROPERTY TAX
OTHER TAXES
Other Taxes
TOTAL PROPERTY AND OTHER TAXES
BUDGETED RECEIPTS OTHER THAN TAXES
GENERAL FUND STATE AND FEDERAL
Outside Agencies
TOTAL BUDGETED RECEIPTS
GENERAL FUND STATE AND FEDERAL
6166,754,700.00 $166,754,700.00 $166,754,700.00
$166,754,700.00 6166,754,700.00 6166,754,700.00
6695,000.00 6695,000.00 6695,000.00
$167,449,700.00 $167,449,700.00 $167,449,700.00
$33,362,200.00 $34,375,771.00 $34,802,271.00
$33,362,200.00 $34,375,771.00 $34,802,271.00
$0.00 0.00%
$0.00 0.00%
$0.00 0.00%
0.00 0.00%
$0.00 0.00%
$426,500.00
$426,500.00 1.24%
1.24% Increased Cigarette Mix revenue.
CHARGES FOR SERVICES
County Executive Administration
Auditing
Corporation Counsel
Fiscal Services
Equalization
Reimbursement Division
Central Services Administration
Materials Management - Auction
Support Services - Admin (Vending/Cafeteria)
Facilities Mgt - Admin.
Facilities Engineering
Personnel
Human Services Admin - FL
Medical Examiner
Public Services
Animal Control
MSU Extension- Oakland County
Community Court Services
6250.00 $250.00 $31,950.00 $31,700.00
287,400.00 287,400.00 100,000.00 (187,400.00)
152,387.00 152,387.00 74,987.00 (77,400.00)
426,000.00 426,000.00 426,000.00 0.00
1,993,930.00 2,198,580.00 2,077,380.00 (121,200.00)
240,000.00 240,000.00 256,000.00 16,000.00
0.00 0.00 200.00 200.00
13,000.00 13,000.00 2,000.00 (11,000.00)
71,800.00 71,800.00 64,300.00 (7,500.00)
53,560.00 53,560.00 53,560.00 0.00
16,470.00 16,470.00 16,470.00 0.00
12,257.00 12,257.00 9,557.00 (2,700.00)
500.00 500.00 0.00 (500.00)
83,500.00 89,000.00 89,000.00 0.00
11,300.00 11,300.00 0.00 (11,300.00)
819,800.00 819,800.00 819,100.00 (700.00)
533,070.00 533,070.00 534,470.00 1,400.00
194,950.00 194,950.00 217,950.00 23,000.00
12680.00% -Reimbursement for FY 1999 Mich. Council for Arts 8, Cultural Affairs regranting receipted in FY 2000
-65.21% -Increased staff assigned to external auditors w/o capturing revenue. Decreased CMH Revenue
-50.79% -Reduction in billing associated with drain and information technology
0.00%
-5.51% Pontiac Assessing line item over budgeted.
6.67% -Increase in fees collected from 25% court ordered board
0.00% - Increased per diem revenue.
" 0.00% - Based on history.
-10.45% - Decrease in number of meals served in cafeteria.
0.00%
0.00%
-22.03% - Hospitalization Administrative charges no longer collectable.
0.00% - No revenue anticipated based on historical decline.
0.00%
-100.00% - Revenue from JTPA moved to Community Development
-0.09% - Decreased anirnal adoptions.
026% -Increased postage reimbursement revenue.
11.80% - Favorability in total USG of money for Grant Fees 8, Collections
08/25/200009:50 AMF I RSTREV.VVK4 1 08/25/2000
REVENUE -
Development & Planning 993,450.00 792,635.00 666,135.00 (126,500.00)
COUNTY OF OAKLAND
FY 2000 THIRD QUARTER REPORT
RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL
SPECIAL REVENUE AND PROPRIETARY FUNDS
FOR YEAR ENDING SEPTEMBER 30 2000
BUDGET BUDGET AMOUNT
AS AS FY 2000 FAVORABLE/
ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT
-15.96% -Unfav. Map Sales ($150,000) due to outdated maps partially offset by fay. Reimb. of
Salaries (Economic Developement Fees) $23,500 for positions associated with Economic
Development Corp. Positions are now in Oakland Enhancement Special Revenue Fund.
County Clerk 1,866,100.00 1,866,100.60 1,868,100.00 0.00 0.00%
Elections 197,740.03 197,740.00 197,740.00 0.00 0.00%
Register of Deeds 10,061,132.00 10,231,132.00 12,231,132.00 2,000,000.00 19.55% -Fair. Mortgages $200,000, Land Transfer Tax $1,500,000, Recording Fees $300,000
due to higher level of real estate activity.
Treasurer 4,320,287.00 4,320,287.00 4,320,287.00 0.00 0.00%
Circuit Court 2,904,553.00 3,008,215.00 2,883,215.00 • (125,000.00) -4.16% Civil Mediation Payment unfav. ($100,000) which is totally offset by fay. expenditures and
Mediation Fines unfav. ($25,000) due to reduction of mediated cases.
Friend of the Court 6,486,500.00 6,486,500.00 6,596,500.00 110,000.00 1.70% -Service Fees fav. $370,000 due to anticipated new distribution requirements not in affect;
Federal Incentive Payments unfav. ($260,000) due to decrease in ADC cases.
District Court 8,665,997.00 8,665,997.00 8,865,997.00 200,000.00 2.31% -Increased caseload and activity in Division III and Division IV
Probate Court 1,136,700.00 1,136,700.00 1,136,700.00 . 0.00 0.00% ,
Prosecutor 177,622.00 213,622.00 248,622.00 35,000.00 16.38% -Fay. Forensic Lab Fees $5,000, Prog. Inc. $5,000 & Welfare Fraud Rev. $25,000 not budgeted.
Sheriffs Office 368,241.00 806,596.00 806,596.00 0.00 0.00%
Administrative Services 1,000.00 1,000.00 1,000.00 0.00 0.00%
Corrective Services 1,764,365.00 2,433,569.00 5,232,569.00 2,799,000.00 115.02% -Fay, inmate bd & care $80,000 underestimated, deferred offender $2,500,000 due to more
prior 111/99 offenses than anticipated, prior years revenue $159,000 due to extra payment
from MDOC for FY 1999, board & care $20,000 for increase in detainers, reimb of court
services $40,000 budgeted as part of contract revenue in Patrol Svcs.
Corrective Services - Satellites 1,411,950.00 1,411,950.00 1,561,950.00 150,000.00 10.62% -Fay board & care $150,000 underestimated.
Patrol Services 18,890,351.00 19,754,356.00 19,754,356.00 0.00 0.00%
Technical Services 339,600.00 358,200.00 358,200.00 0.00 0.00%
Board of Commissioners 14,500.00 14,500.00 10,000.00 (4,500.00) -31.03% - Per diem collection lower than anticipated.
Library Board 182,896.00 182,896.00 162,896.00 (20,000.00) -10.94% - Reduction in copier usage due to the availability of online printable material.
Drain Administration 320,716.00 325,133.00 180,733.00 (144,400.00) -44.41% -Part of Watershed Management grant funding will not be received until FY 2001.
Engineering & Construction 329,005.00 369,215.00 480,915.00 111,700.00 30.25% -Fav. Soil Erosion Fees due to high level of construction activity. ,
TOTAL CHARGES FOR SERVICES $65,342,879.00 $67,696,667.00 $72,334,567.00 $4,637,900.00 6.85%
GENERAL FUND
4,637,900.00
$0.00 0.00%
$0.00 0.00%
BUDGETED RECEIPTS - GENERAL PURPOSE
GOVT STATE AND FEDERAL
Outside Agencies
TOTAL BUDGETED RECEIPTS - GEN. PURPOSE $12,640,000.00 $12,640,000.00 $12,640,000.00
GOV'T STATE AND FEDERAL
CHARGES FOR SERVICES
$12,640,000.00 $12,640,000.00 $12,640,000.00
08/25/200009:50 AMFIRSTREV.VVK4 2 - 08/25/2000
COUNTY OF OAKLAND
FY 2000 THIRD QUARTER REPORT
RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL
SPECIAL REVENUE AND PROPRIETARY FUNDS
FOR YEAR ENDING SEPTEMBER 30, 2000
BUDGET BUDGET AMOUNT
AS AS FY 2000 FAVORABLE/
ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT
REVENUE .
Emergency Management Services 2,210.(X) 2,210.00 310.00 ($1,900.00) -85.97% - EMS no longer receiving reimbursement - general reveunue, budget to be adjusted_
Health Division 1.910,935.00 2,034,110.00 2,248,110.00 214,000.00 10.52% Fay. primarily reflects volume of vaccinations and immunizations administered, $45,000.
Fay. 20 NonComm, On-site Sewerage and Evaluations $319,000 due to increased activity,
offset by unfav. Medicaid Full Cost reimb ($150,000)
Children's Village 2,680,500.00 2,680,500.00 2,605,500.00 (75,000.00) -2.80% Reflects decline in out-county residents.
Friend of the Court 427,200.00 427,200.00 427,200.00 0.00 0.00%
Probate Court 980,000.00 980,000.00 980,000 00 0.00 0.00%
$6,000,845.00 $6,124,020.00 $6,261,120.00 $137,100.00 2.24%
MISCELLANEOUS REVENUE
Sundry $1,050,000.00 $1,050,000.00 $1,050,000.00 $0.00 0.00%
Investment Income 18,600,000.00 18,600,000.00 18,600,000.00 0.00 0.00%
$19,650,000.00 $19,650,000.00 $19,650,000.00 $0.00 0.00%
RESOURCES CARRIED FORWARD
Prior Year's Balance $3,545,609.00 $26,198,944.27 $26,198,944.27 $0.00 0.00%
$3,545,609.00 $26,198,944.27 $26,198,944.27 $0.00 0.00%
OPERATING TRANSFERS $49,115,564.00 $49,130,646.34 $49,130,646.34 $0.00 0.00%
TOTAL AVAILABLE RESOURCES
GENERAL FUND/GENERAL PURPOSE $357,106,797.00 $383,265,748.61 $388,467,248.61 $5,201,500.00 1.36%
Less Operating Transfers ($49,115,564.00) ($49,130,646.34) ($49,130,646.34) $0.00 0.00%
NET GF/GP RESOURCES $307,991,233.00 $334,135,102.27 $339,336,602-27 $5.201,500.00 1.56%
08/25/200009:50 AMFIRSTREVINK4 3 08/25/2000
Friend of the Court
Controllable Personnel
Controllable Operating
Non-Controllable Operating
COUNTY OF OAKLAND
FY 2000 THIRD QUARTER FORECAST
EXPENDITURES
CIRCUIT COURT
AMOUNT
ADOPTED AMENDED FY 2000 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$8,499,556.00 $6,536,502.00 $6,431,502.00 $105,000.00 1.81% - Salary and Fringes fay. $105,000 due to vacant positions and turnover.
6,613,208.00 7,681,803.80 7,534,003.80 147,800.00 1.92% - Software Rental/Lease Purchase unfav. ($84,662.58); Professional Services fay. $84,662.58
due to carry forward appropriation for Jury System posted to Prof Svs but charged to Software
Rental/Lease Purchase; Attorney Fees Mediators fay. $100,000 due to reduction in cases;
mediated Juror Cost District Court Remand fay. $20,900 due to change in statutory requirements;
Grant Match fay. $50,000 due to overestimation; Publishing Court Calendar fay. $26,900 due to
cost not incurred this fiscal year, Visiting Judge unfav. ($50,000) additional judges for civil case.
backlog.
2,587,575.00 2,727,390.10 2,745,390.10 (18,000.00) -0.68% - Telephone Communications rate Increase.
$15,700,339.00 $16,945,695.90 $16,710,895.90 $234,800.00 1.39%
$7,018,252.00 $7,054,971.00 $6,993,671.00 $61,300.00 0.87% - Salary and Fringe fay. $88,300 due to turnover, Overtime unfav. ($20,000)
555,380.00 561,664.25 560,064.25 1,600.00 0.28% - Clothing Allowance fav. $2,086 due to change in contract and Transportation of Prisoners unfav.
$(500) due to after hours pick-up of prisoners.
1,628,299.00 2,195,952.55 2,197,952.55 (2,000.00) -0.09% - Telephone Communications unfav. ($22,000) due to implementation of voice response 800
. number and rate increase, Stationery Stores fay. $20,000
$9,201,931.00 $9,812,587.80 $9,751,687.80 $60,900.00 0.62%
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$13,517,808.00 $13,591,473.00 $13,425,173.00
7,168,588.00 8,243,468.05 8,094,068.05
4,215,874.00 4,923,342.65 4,943,342.65
$166,300.00
149,400.00
(20,000.00)
1.22%
1.81%
0.00%
$24,902,270.00 $26,758,283.70 $26,462,583.70 $295,700.00 1.11%
08/23/2000 4
Division 4 - Troy
Controllable Personnel
Controllable Operating
Non-Controllable Operating
COUNTY OF OAKLAND
FY 2000 THIRD QUARTER FORECAST
EXPENDITURES
DISTRICT COURT
AMOUNT
ADOPTED AMENDED FY 2000 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
District Court Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating.
$115,653.00 $98,413.00 $51,413.00 $47,000.00 47.76% - Positions not being expended from this division.
33,240.00 108,240.00 108,240.00 0.00 0.00%
0.00 0.00 0.00 0.00 0.00% -
$148,893.00 $208,653.00 $159,653.00 $47,000.00 22.74%
Division 1 - Novi
Controllable Personnel $2,642,578.00 $2,642,578.00 $2,602,678.00 $39,900.00 1.51% - Fay. Salary and Fringes $51,400 due to turnover. Overtime unfav. ($11,500) because
of the turnover.
Controllable Operating 919,198.00 926,301.36 946,901.36 (20,600.00) -2.22% - Def. Att'y Fees unfav, due to additional appointments; Expert Witness Fees unfav. ($1,000);
Juror Fees and Mileage fay. $10,000 number of jury days required less than anticipated.
Rent unfav. ($14,600) due to lease increase.
Non-Controllable Operating 386,285.00 412,133.24 474,133.24 (62,000.00) -15.04% - Info Tech unfav. ($50,000), Telephone Communications unfav. ($12,000).
$3,948,061.00 $3,981,012.60 $4,023,712.60 ($42,700.00) -1.07%
Division 2 - Clarkston
Controllable Personnel $977,492.00 $977,492.00 $937,492.00 $40,000.00 4.09% - Turnover
Controllable Operating 306,163.00 327,983.35 316,983.35 11,000.00 3.35% - Interpreter unfav. ($1,000) use higher than anticipated; Defense Ally Fees unfav. ($8,000)
due to increase in number of appointments; Visiting Judges fay. $20,000 because charges
. were made to Administration.
Non-Controllable Operating 154,952.00 189,432.36 210,432.36 (21,000.00) -11.09% - Info Tech-Oper unfav. ($30,000) Telephone Communications fay. $9,000
$1,438,607.00 $1,494,907.71 $1,464,907.71 $30,000.00 2.01%
Division 3 - Rochester Hills
Controllable Personnel $2,301,380.00 $2,301,380.00 $2,278,080.00 $23,300.00 1.01% - Salary and Fringe fay. $41,300, Overtime unfav. ($18,000)
Controllable Operating . 667,482.00 716,519.88 738,119.88 (19,600.00) -2.74% - Court Reporter Services unfav. ($1,000), Defense Att'y Fees unfav. ($30,000), Interpreter
Fees unfav. ($3,600) due to increase in caseload; Custodial and Data Processing Supplies
$3,000 appropriations not required; Postage fay. $10,000.
Non-Controllable Operating 377,303.00 426,517.71 426,517.71 0.00 0.00%
$3,346,165.00 $3,444,417.59 $3,440,717.59 $3,700.00 0.11%
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$1,632,332,00 $1,632,332.00 $1,632,332.00 $0.00 0.00% -
372,702.00 380,031.47 509,331.47 (129,300.00) -34.02% Court Reporter Services unfav. ($10,000), Defense Ally Fees unfav. ($6,300) due to caseload
increase; Heat, Lights unfav. ($83,000) no appropriation made for new building; Training,
Psych. Testing unfav. (30,000) increased usage
244,374,00 268,736.66 427,236.66 (158,500.00) -58.98% - Info Tech Operations unfav. ($150,000), Telephone Communications unfav. ($8,500),
$2,249,408.00 $2,281,100.13 $2,568,900.13 ($287,800.00) -12.62%
$7,669,435.00 $7,652,195.00 $7,501,995.00 $150,200.00 1.96%
2,298,785.00 2,459,076.06 2,617,576.06 (158,500.00) -6.45%
1,162,914.00 1,296,819.97 1,538,319.97 (241,500.00) -18.62%
$11,131,134.00 $11,408,091.03 $11,657,891.03 ($249,800.00) -2.19%
08/23/2000
Juvenile Maintenance
Controllable Operating
Non-Controllable Operating
Judicial Support
Controllable Personnel
Controllable Operating
Non-controllable Operating
Court Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
COUNTY OF OAKLAND
FY 2000 THIRD QUARTER FORECAST
EXPENDITURES
PROBATE COURT
AMOUNT
ADOPTED AMENDED FY 2000 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
JudIclaUAdmInIstration
Controllable Personnel $2,442,796.00 $2,424,357.00 $2,451,357.00 ($27,000.00) -1.11% - Salary and Fringe unfav, due to higher than expected service increments.
Controllable Operating 70,581.00 73,429.16 110,029.16 (36,600.00) -49.84% - Prof. Services unfav. ($6,200) due to extraordinary case using various experts and
professionals in processing of case through Court; Visiting Judges unfav. $(30,400) due to
Judge on sick leave.
Non-Controllable Operating 643,130.00 712,578.38 965,578.38 (253,000.00) -35.50% - Info. Tech Operations unfav. ($223,000), Imaging Operations unfav. ($22.000) and Telephone
Communications unfav. ($8,000) due to rate change.
63,156,507.00 $3,210,364.54 $3,526,964.54 ($316,600.00) -9.86%
4,081,392.00 4,981,392.00 5,481,392.00 (500,000.00) -10.04% - State Institutions unfav. due to increase in number of commitments, increase in per diem rates,
and Increase in length of stay.
33.00 33.00 33.00 0.00 0.00%
64,081,425.00 $4,981,425.00 $5,481,425.00 ($500,000.00) -10.04%
64,742,689.00 $4,763,343.00 $4,531,843.00 $231,500.00 4.86% - Salary and Fringe fay. $239,500 due to tumover, Overtime unfav. ($8,000) increase use;
1,733,738.00 1,734,023.75 1,734,023.75 0.00 0.00%
817,232.00 843,519.36 734,719.36 108,800.00 12.90% - Building Space fay. $125,800, Telephone Communications unfav. ($17,000) due to rate change.
$7,293,659.00 $7,340,886.11 $7,000,586.11 $340,300.00 4.64%
$7,363,613.00 $7,365,801.00 67,267,901.00 $97,900.00 1.33% - Turnover.
331547.00 333,561.10 374,361.10 (40,800.00) -12.23% - Professional Services unfav. ($40,000) due to increase domestic evaluations, Car Allowance
unfav. $800 - policy change requires non-employee interns to charge mileage to Car Allowance
437,670.00 441,298.45 573,798.45 (132,500.00) -30.03% - Building Space unfav. ($125,000). Telephone Communications unfav. ($7,500) due to rate
change.
$8,132,830.00 $8,140,660.55 $8,216,060.55 (675,400.00) -0.93%
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$14,549,098.00 $14,553,501.00 614,251,101.00
6,217,258.00 7,122,406.01 7,699,806.01
1,898,065.00 1,997,429.19 2,274,129.19
$22,664,421.00 $23,673,336.20 $24,225,036.20
$302,400.00
(577,400.00)
(276,700.00)
($551,700.00) -2.33%
2.08%
-8.11%
-13.85%
COUNTY OF OAKLAND
FY 2000 THIRD QUARTER FORECAST
EXPENDITURES
PROSECUTING ATTORNEY
AMOUNT
ADOPTED AMENDED FY 2000 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Litigation
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Warrants
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Appellate -
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$1,771,646.00 $1,771,646.00 $1,752,846.00 $18,800.00 1.06% -Fay. Overtime $11,100 and Salaries $3,800 and Fringes $3,900 due to underfilled positions.
1,616,522.00 1,764,436.62 $1,651,436.62 $113,000.00 6.40% -Fay. Ct. Transcripts $10,000, Extradition Expense $30,000, Filing Fees
$10,000, Professional Svcs. $10,000, Appeal Transcripts $8,000, Witness Fees and Mileage
$35,000 due to case requirements and dept. effort to control travel costs; Mem. Dues & Publ
$10,000..
2,159,616.00 2,209,421.41 $2,282,421.41 ($73,000.00) -3.30% -Unfav. Info Tech Oper. ($40,000) and Tele. Comm. ($33,000) due to underestimates.
$5,547,784.00 $5,745,504.03 $5,686,704.03 $58,800.00 1.02%
$6,472,065.00 $6,472,065.00 $6,110,365.00 $361,700.00 5.59% -Fay. Overtime $14,500 and Salary $246,600 Fringes $97,400 due to underfilled postions.
56,492.00 56,492.00 $36,492.00 $20,000.00 0.00% -Fay. Personal Mileage $20,000 due to decrease usage.
0.00 0.00 $0.00 $0.00 0.00%
$6,528,557.00 $6,528,557.00 $6,146,857.00 $381,700.00 5.85%
$2,017,000.00 $2,017,000.00 $1,772,500.00 $244,500.00 12.12% -Fay. Salary $174,600 & Fringes $69,900 due to undertilled postions.
2,758.00 2,758.00 $2,758.00 $0.00 0.00%
0.00 0.00 $0.00 $0.00 0.00%
$2,019,758.00 $2,019,758.00 $1,775,258.00 $244,500.00 12.11%
$1,479,827.00 $1,479,827.00 $1,350,327.00 $129,500.00 8.75% -Unfav. Overtime ($1,700) offset by fay. Salary $94,000 and Fringes $37,200 due to
6,885.00 6,885.00 $6,885.00 $0.00 0.00% underfilled positions.
0.00 0.00 $0.00 $0.00 0.00%
$1,486,712.00 $1,486,712.00 $1,357,212.00 $129,500.00 8.71%
Department
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$11,740,538.00 $11,740,538.00 $10,986,038.00
1,682,657.00 1,830,571.62 1,697,571.62
2,159,616.00 2,209,421.41 2,282,421.41
$754,500.00 6.43%
133,000.00 7.27%
(73,000.00) -3.30%
$15,582,811.00 $15,780,531.03 $14,966,031.03 $814,500.00 5.16%
08/24/2000
COUNTY OF OAKLAND
FY 2000 THIRD QUARTER FORECAST
EXPENDITURES
SHERIFF DEPARTMENT
AMOUNT
ADOPTED AMENDED FY 2000 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Sheriffs Office
Controllable Personnel
Controllable Operating
$759,348.00 $928,664.00 $941,264.00 ($12,600.00) -1.36% -Unfav. overtime ($9,800) and fringes ($2,800) due to new timellabor posting procedures.
241,886.00 567,784.02 $651,084.02 (83,300.00) -14.67% -Unfav. prof. svcs. ($46,000) partially offset in other divisions,
expend. equip. ($7,700) for office furniture and vehicle cap. outlay ($32,100) for command veh.
offset by fav. workshop and meetings $2,000 and data processing supplies $500.
Non-Controllable Operating 1,356,058.00 1,372,002.00 $1,372,002.00 0.00 0.00%
$2,357,292.00 $2,868,450.02 $2,964,350.02 ($95,900.00) -3.34%
Administrative Services
Controllable Personnel $1,069,505.00 $907,548.00 $847,648.00 $59,900.00 6.60% -Fay. salaries $56,000 and fringes $18,900 due to turnover and short-term disability, partially
offset by unfav. overtime ($15,000).
Controllable Operating 586,260.00 617,009.59 $646,609.59 (29,600.00) -4.80% -Unfav. employee med exams ($4,000) due to divers and extra academy lead poisoning physicals,
officer training ($17,500) due to more officers trained partially offset in other div., travel ($3,000)
and expend equip ($5,100).
Non-Controllable Operating 301,846.00 305,065.00 $352,765.00 (47,700.00) -15.64% -Unfav. micrographics ($10,200) and cony. copier ($2,500) not budgeted, and radio comm.
comm ($10,200) and print shop ($40,000) underestimated, offset by fay. stationery $5,000.
$1,957,611.00 $1,829,622.59 $1,847,022.59 ($17,400.00) -0.95%
Corrective Services
Controllable Personnel $18,207,808.00 $18,345,489.00 $17,610,489.00 $735,000.00 4.01% -Fay. salaries $1,200,000 and fringes $285,000 partially offset by unfav. overtime ($750,000)
due to vacancies.
Controllable Operating 5,198,282.00 5,463,340.91 $4,508,340.91 955,000.00 17.48% -Fay. hosp. of prisoners $900,000, insurance $30,000, prisoner housing $175,000, med. svcs.
physicians $60,000, transport prisoners $3,000, bedding $20,000 and cap. outlay $90,000, off-
set by unfav. data process supp. ($8,000), expend. equip ($15,000) and med. supp. ($300,000).
Non-Controllable Operating 7,756,386.00 8,002,628.26 $8,062,628.26 (60,000.00) -0.75% -Unfav, info tech oper ($135,000), radio comm ($25,000), leased veh. ($45,000) and cony.
copier ($5,000), offset by fay. provisions $150,000.
$31,162,474.00 $31,811,458.17 $30,181,458.17 $1,630,000.00 5.12%
Corrective Services-Satellites
Controllable Personnel $11,077,105.00 $11,147,734.00 $11,375,234.00 ($227,500.00) -2.04% -Unfav. OT ($375,000) and fringes ($27,500) offset by fay. salaries $175,000 due to turnover.
Controllable Operating 145,893.00 148,385.30 $129,885.30 18,500.00 12.47% -Fav. equip repair $5,000, laundry $4,000, bedding $8,000, and med supplies $1,500.
Non-Controllable Operating 967,715.00 967,715.00 $952,115.00 15,600.00 1.61% -Fay, radio comm $1,300 and leased veh $14,300 charged to other division.
$12,190,713.00 $12,263,834.30 $12,457,234.30 ($193,400.00) -1.58%
Patrol Services
Controllable Personnel $20,326,947.00 $21,163,107.00 $20,925,107.00 $238,000.00 1.12% -Fay. salaries $575,000 and fringes $113,000 due to turnover, offset by unfav. overtime
($450,000) partially due to mini-contracts offset by revenue.
Controllable Operating $153,098.00 $557,781.20 $544,481.20 13,300.00 2.38% -Fay. towing $4,000, uniform cing $2,000, diving supp $4,000, boats $5,300, marine equip $5,000,
and cap outlay $75,000 offset by equip repairs ($22,000), K-9 program ($20,000) to be reimbursed
from forfeited funds, north oak sub station ($2,500), untfomi replacement ($12,500) and expend
equip ($25,000).
Non-Controllable Operating 2,330,875.00 2,654,694.00 $2,796,894.00 (142,200.00) -5.36% -Unfav. info tech equip rental ($62,200) unbudgeted-request budget amd, radio comm ($20,000),
and leased vehicles ($60,000).
$22,810,918.00 $24,375,582.20 $24,266,482.20 $109,100.00 0.45%
Technical Services
Controllable Personnel $7,410,666.00 $7,589,383.00 $7,522,883.00 $66,500.00 0.88% -Fay. salaries $250,000 and fringes $41,500 due to turnover offset by unfav. overtime ($225,000)
fringes ($6,800) due to mini-contracts and Lake Orion homicide.
Controllable Operating 796,034.00 924,553.01 $1,003,253.01 (78,700.00) -8.51% -Fav. prof svcs $23,300, data Proo suppl $1,000, lab suppl $20,000 and photo suppl $3,000, off-
set by unfav. data processing dev ($8,000) due to increase in DSS contract and AFIS charges,
deputy suppl ($110,000), and expend equip ($10,000)
Non-Controllable Operating 1,058,613.00 1,060,357.07 $1,136,757.07 (76,400.00) -7.21% -Fay. micrographics $9,600 and cony copier $4,000 offset by unfav. tele comm ($90,000).
$9,265,313.00 $9,574,293.08 $9,662,893.08 ($88,600.00) -0.93%
Department Total
Controllable Personnel $58,851,377.00 $60,081,925.00 $59,222,625.00 $859,300.00 1.43%
Controllable Operating 7,121,451.00 8,278,854.03 7,483,654.03 795,200.00 9.61%
Non-Controllable Operating - 13,771,493.00 14,362,461.33 14,673,161.33 (310,700.00) -2.16%
$79,744,321.00 $82,723,240.36 $81,379,440.36 $1,343,800.00 1.62%
08/24/2000
COUNTY OF OAKLAND
FY 2000 THIRD QUARTER REPORT
EXPENDITURES
CLERK/REGISTER OF DEEDS
AMOUNT
ADOPTED AMENDED Pr' 2000 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel $382,577.00 $382,577.00 382,577.00 $0.00 0.00%
Controllable Operating 79,580.00 92,516.00 83,516.00 9,000.00 9.73% - Fav. County Directory printing cost less than expected.
Non-Controllable Operating - 109,624.00 114,458.53 134,858.53 (20,400.00) -17.82% - Unfav. Telephone Communications ($11,000) due to rate changes; Leased
Vehicles unfav. ($4,800) due to increased usage; and Equipment Rental unfav.
($5,000).
$571,781.00 $589,551.53 $600,951.53 ($11,400.00) -1.93%
County Clerk
Controllable Personnel $3,214,315.00 $3,194,315.00 $3,059,515.00 $134,800.00 4.22% - Salary and Fringe fav. due to turnover $148,300 Overtime unfav. ($13,500) due to
Imaging conversion.
appropriation not posted.
Controllable Operating 280,152.00 241,345.36 278,345.36 (37,000.00) -15.33% - Data Processing Supplies associated with Imaging System unfav ($42,000),
partially offset by Staples fay. $5,000.
Non-Controllable Operating 575,508.00 677,732.91 668,632.91 9,100.00 1.34% Info Tech Oper unfav. ($11,500) partially offset by Imaging Oper fay $20,600
$4,069,975.00 $4,113,393.27 $4,006,493.27 $106,900.00 2.60%
Elections
Controllable Personnel $436,986.00 $436.986.00 $386,986.00 $50,000.00 11.44% - Turnover.
Controllable Operating 591,544.00 616,847.06 $616,847.06 0.00 0.00%
Non-Controllable Operating 91,988.00 214,507.38 231,507.38 (17,000.00) -7.93% Info Tech Oper. unfav.
$1,120,518.00 $1,268,340.44 $1,235,340.44 $33,000.00 2.60%
Register of Deeds
Controllable Personnel $1,759,134.00 $1,851,634.00 $1,802,634.00 $49,000.00 2.65% - Salaries fay. due to turnover which is partially offset by unfav. Overtime ($6,000)
due to continued high real estate activity.
Controllable Operating 1,229,017.00 983,663.46 1,453,663.46 (470,000.00) -47.78% - Prof Svs. unfav. ($434,000) contracted document recording; Postage unfav.
($28,000); Office Supplies unfav. ($8,000) - all due to land transfer activity
Non-Controllable Operating 958,478.00 1,119,798.44 994,998.44 124,800.00 11.14% - Info Tech Oper fay.
$3,946,629.00 $3,955,095.90 $4,251,295.90 ($296,200.00) -7.49%
Jury Commission
Controllable Personnel $15,237.00 $15,237.00 15,237.00 $0.00 0.00%
Controllable Operating 44,363.00 44,363.00 29,383.00 15,000.00 33.81% Postage fav. due to decreased mailing activity.
Non-Controllable Operating 33,338.00 124,065.76 125,565.76 (1,500.00) -1.21% - Info Tech Oper unfav. ($11,500) partially offset by Printing fair. $10,000
$92,938.00 $183,665.76 $170,165.76 $13,500.00 7.35%
Department Total
Controllable Personnel $5,808,249.00 $5,880,749.00 $5,648,949.00 $233,800.00 3.98%
Controllable Operating 2,224,656.00 1,978,734.88 2,461,734.88 (483,000.00) -24.41%
Non-Controllable Operating 1,768,936.00 2,250,563.02 2,155,563.02 95,000.00 4.22%
Operating Transfer Out 0.00 360,723.00 360,723.00 0.00 0.00%
$9,801,841.00 $10,470,769.90 $10,624,969.90 ($154,200.00) -1.47%
COUNTY OF OAKLAND
FY 2000 THIRD QUARTER REPORT
EXPENDITURES
COUNTY TREASURER
ADOPTED
BUDGET
AMOUNT
AMENDED FY 2000 FAVORABLE
BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel -
Controllable Operating
$0.00 0.00%
225,523.00 446,163.94 414,063.94 $32,100.00 7.19%
Non-Controllable Operating 457,943.00 827,939.10 827,939.10 0.00 0,00%
Transfer Out 0.00 30,000.00 30,000.00 0.00 0.00%
Division Total $3,079,564.00 $3,699,796.04 $3,667,696.04 $32,100.00 0.87%
Department Total $3,079,564.00 $3,699,796.04 $3,667,696.04 $32,100.00 0.87%
$2,396,098.00 $2,395,693.00 $2,395,693.00
- Favorable due to lower than anticipated expenditures in professional
services. Billing for financial software was lower In FY2000 than anticipated.
08/23/2000
•
Administration
Controllable Personnel $1,593,073.00 $1,593,073.00
425,636.00
321,155,00
$2,339,864.00
425,709.08
322,304.94
$2,341,087.02
Controllable Operating
Non-Controllable Operating
Library Board
Controllable Personnel
Controllable Operating
$827,812.00
847,404.00
$828,025.00
831,272.00
Non-Controllable Operating 1,020,694.00 1,020,767.73
$2,680,064.73 $2,695,910.00
$2,420,885.00
1,273,040.00
1,341,849.00
$5,035,774.00
$2,421,098.00
1,256,981.08
1,343,072.67
-----------
$5,021,151.75
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
425,709.08 0.00 0.00%
322,304.94 0.00 0.00%
$2,291,087.02 $50,000.00 2.14%
COUNTY OF OAKLAND
FY 2000 THIRD QUARTER FORECAST
EXPENDITURES
BOARD OF COMMISSIONERS
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2000 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$1,543,073.00 $50,000.00
$828,025.00
923,272.00
1,063,767.73 (43,000.00)
$2,371,098.00 $50,000.00
1,348,981.08 (92,000.00)
1,386,072.67 (43,000.00)
$5,106,151.75 ($85,000.00)
3.14% - Favorable due to turnover causing position vacancies for
extended periods.
0.00%
-11.07% - Unfavorable due to increased spending in Library Continuations.
Large series publications supplied to satillite facilities are being
updated.
-4.21% - Unfavorable due to the acquistion of new computer equipment
and employees attending Microsoft Office training.
2.07%
-7.32%
-3.20%
-1.69%
$0.00
(92,000.00)
$2,815,064.73 ($135,000.00) -5.04%
08/23/2000
COUNTY OF OAKLAND
FY 2000 THIRD QUARTER FORECAST
EXPENDITURES
DRAIN COMMISSIONER
AMOUNT
ADOPTED AMENDED FY 2000 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
Drain Commissioner
Controllable Personnel $2,124,569.00 $2,169,196.00 $2,169,196.00 $0.00 0.00%
Controllable Operating _ 416,293.00 418,293.00 416,293.00 $0.00 0.00%
Non-Controllable Operating 850,759.00 672,641.28 672,641.28 $0.00 0.00%
Division Total $3,191,621.00 $3,258,130.28 $3,258,130.28 $0.00 0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
Department Total $3,191,621.00 $3,258,130.28 $3,258,130.28 $0.00 0.00%
:epared by: Budget Division 08/25/2000
357,959.80 357,959.80
$2,289,724.00 $2,347,261.80 $2,371,261.80
0.00 0.00%
($24,000.00) -1.02%
Non-Controllable Operating 353,836.00
COUNTY OF OAKLAND
FY 2000 THIRD QUARTER REPORT
EXPENDITURES
COUNTY EXECUTIVE
ADOPTED AMENDED
BUDGET BUDGET
AMOUNT
FY 2000 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
$1,701,658.00 $1,755,072.00 $1,755,072.00 $0.00 0.00%
234,230.00 234,230.00 258,230.00 (24,000.00) -10.25% - Unfavorable due to unanticipated charges from lobbying firm previously
billed to Equalization. Lobbyist is handling matters associated with the IGUDF
as well as other matters of interest to the county. Budget amendment
recommended to transfer from Equalization services.
Auditing
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Corporation Counsel
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfer Out
$1,191,565.00 $1,191,565.00 $1,191,565.00
22,796.00 22,796.00 22,796.00
152,848.00 153,206.52 179,206.52
$1,367,209.00 $1,367,567.52 $1,393,567.52
$1,284,101.00 $1,399,565.00 $1,399,565.00
29,941.00 55,430.35 55,430.35
196,195.00 210,213.30 210,213.30
0.00 10,008.00 10,008.00
$0.00 0.00%
0.00 0.00%
(26,000.00) -16.97%
($26,000.00) -1.90%
0.00% .
0.00%
0.00%
0.00%
$0.00
0.00
0.00
0.00
- Unfavorable due to increased acquisition of computer equipment and
employee training. The division has acquired additional notebooks, PC's,
and printers. Several employees attended the Microsoft Office Suite training
classes.
$1,510,237.00 $1,675,216.65 $1,675,216.65 $0.00 0.00%
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfer Out
$4,177,324.00 $4,346,202.00
286,967.00 312,456.35
702,879.00 721,379.62
0.00 10,008.00
$4,346,202.00
336,456.35
747,379.62
10,008.00
$0.00 0.00%
(24,000.00) -7.68%
(26,000.00) 0.00%
0.00
$5,167,170.00 $5,390,045.97 $5,440,045.97 ($50,000.00) -0.93%
08/23/2000
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$258,339,00 $258,339.00
10,188.00 10,656.63
9,329.00 9,329.00
$258,339.00
10,656.63
9,329.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%
Reimbursement
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfers Out
$0.00 0.00%
$46,200.00
(307,300.00)
(10,000.00)
0.00
($271,100.00)
0.35%
-28.67%
-0.32%
0.00%
-1.55%
$0.00
0.00
0.00
0.00%
0.00%
0.00%
COUNTY OF OAKLAND
FY 2000 THIRD QUARTER FORECAST
EXPENDITURES
MANAGEMENT AND BUDGET
AMOUNT
ADOPTED AMENDED FY 2000 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$277,856.00 $278,324.63 $278,324.63 $0.00 0.00%
Purchasing
Controllable Personnel $672,011.00 $672,011.00 $672,011.00 $0.00 0,00%
Controllable Operating 28,348.00 28,348.00 22,148.00 6,200.00 21.87% - Favorable due to lower than anticipated costs associated with adversiting. Non-Controllable Operating 145,437.00 148,137.70 148,137.70 0.00 0.00%
$845,796.00 $848,496.70 $842,296.70 $6,200.00 0.73%
Equalization
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfers Out
$5,527,877.00 $5,774,307.00 $5,774,307.00
318,247.00 484,832.10 484,832.10
1,037,581.00 1,197,797.47 1,197,797.47
0.00 81,690.00 81,690,00
$6,883,705.00 $7,538,626.57 $7,538,626.57
Fiscal Services
Controllable Personnel 3,666,420.00 3,734,259.00 $3,688,059.00 $46,200.00 1.24% -Favorable due to the grant supervisor position vacancy. The position was partially underfilled for
a short period of time.
Controllable Operating 134,484.00 140,955.50 454,455.50 (313,500.00) -222.41% - Unfavorable due to program and training costs associated with the Performance Series 2.1
Upgrade, postage, and the use of an outside vendor for the printing of the 1999 Popular Annual
Financial Report (PAFR). Funds have been set aside in designated fund balance for the
performance upgrade.
Non-Controllable Operating 711,042.00 991,649.60 1,001,649.60 (10,000.00) -1.01% - Unfavorable due to IT operations charges associated with new equipment_
$4,511,946.00 $4,866,864.10 $5,144,164.10 ($277,300.00) -5.70%
$2,862,333.00 $2,862,333.00 $2,862,333.00
387,093.00 407,232.65 407,232.65
704,471.00 735,794.77 735,794.77
$3,953,897.00 $4,005,360.42 $4,005,360.42
$12,986,980.00 $13,301,249.00 $13,255,049.00
878,360.00 1,072,024.88 1,379,324.88
2,607,860.00 3,082,708.54 3,092,708.54
0.00 81,690.00 81,690.00
$16,473,200.00 $17,537,672.42 $17,808,772.42
08/25/2000
Administrative
Controllable Personnel
Controllable Operating
Non-Controllable Operiting
Support Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
COUNTY OF OAKLAND
FY 2000 THIRD QUARTER FORECAST
EXPENDITURES
CENTRAL SERVICES
AMOUNT
ADOPTED AMENDED FY 2000 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) EXPLANATION OF SIGNIFICANT VARIANCES
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$141,834.00 $141,834.00 $141,834.00 $0.00
2,522.00 2,522.00 $2,522.00 0.00
10,590.00 10,590.00 10,190.00 400.00 Fay. in lease veh., print shop, and Mat'l Mgmt. Misc, charges incurred.
$154,946.00 $154,946.00 $154,546.00 $400.00
$861,722.00 $872,671.00 $764,471.00 $108,200.00 Favorable due to position turnover and vacancies.
26,683.00 26,683.00 11,583.00 15,100.00 Fay. due largely to lower expend. equip, personal mileage & equip. maint. chgs. incurred
639,384.00 671,407.16 671,407.16 0.00
$1,527,789.00 $1,570,761.16 $1,447,461.16 $123,300.00
$1,003,556.00 $1,014,505.00 $906,305.00 $108,200.00
29,205.00 29,205.00 14,105.00 15,100.00
649,974.00 681,997.16 681,597.16 400.00
$1,682,735.00 $1,725,707.16 $1,602,007.16 $123,700.00
08/0812000
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating.
Facilities Engineering
Controllable Personnel
Controllable Operating
Non-Controllable Operating
2000 14.VVK4
COUNTY OF OAKLAND
FY 2000 THIRD QUARTER FORECAST
EXPENDITURES
FACILITIES MANAGEMENT
AMOUNT
ADOPTED AMENDED FY 2000 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$483,238.00 $470,738.00 $401,038.00 $69,700.00 14.81% - Turnover
14,397.00 26,897.00 26,897.00 0.00%
46,651.00 46,651.00 40,151.00 6,500.00 13.93% - Fav. Information Technology Operations
$544,286.00 $544,286.00 $468,086.00 $76,200.00 14.00%
$873,269.00 $873,269.00 $846,169.00 $27,100.00 3.10% - Fav. Overtime costs.
223,766.00 224,463.81 $235,963.81 (11,500.00) -5.12% - Cost for expanded and upgraded Auto CAD computer software.
98,501.00 100,389.72 114,389.72 (14,000.00) -13.95% - Unfav. Information Technology Operations and Telephone Communications costs
based on current usage projections.
$1,195,536.00 $1,198,122.53 $1,196,522.53 $1,600.00 0.13%
$1,356,507.00 $1,344,007.00 $1,247,207.00 $96,800.00 7.20%
238,163.00 251,360.81 262,860.81 (11,500.00) -4.58%
145,152.00 147,040.72 154,540.72 (7,500.00) -5.10%
$1,739,822.00 $1,742,408.53 $1,664,608.53 $77,800.00 4.47%
COUNTY OF OAKLAND
FY 2000 THIRD QUARTER FORECAST
EXPENDITURES
PERSONNEL
AMOUNT
ADOPTED AMENDED FY 2000 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel $261,744.00 $261,744.00 $261,744.00 $0.00 0.00%
Controllable Operating • 7,319.00 7,319.00 11,819.00 ($4,500.00) -61.48% - Unfavorable due to travel & conference for staff to attend People Soft conference.
A budget amendment is recommended.
Non-Controllable Operating 7,007.00 8,341.91 10,241.91 ($1,900.00) -22.78% - Unfavorable due to printing associated with the new mentor program.
$276,070.00 $277,404.91 $283,804.91 ($6,400.00) -2.31%
Human Resources
Controllable Personnel $1,841,585.00 $1,843,459.00 $1,843,459.00 $0.00 0.00%
Controllable Operating 367,387.00 436,354.40 436,354.40 $0.00 0.00%
Non-Controllable Operating 517,324.00 581,721.33 581,721.33 $0.00 0.00%
$2,726,296.00 $2,861,534.73 $2,861,534.73 $0.00 0.00%
Employee Relations
Controllable Personnel $641,430.00 $641,430.00 $641,430.00 $0.00 0.00%
Controllable Operating 191,267.00 215,606.95 215,606.95 $0.00 0.00%
Non-Controllable Operating 138,788.00 138,788.00 138,788.00 $0.00 0.00%
$971,485.00 $995,824.95 $995,824.95 $0.00 0.00%
Department Total
Controllable Personnel $2,744,759.00 $2,746,633.00 $2,746,633.00 $0.00 0.00%
Controllable Operating 565,973.00 659,280.35 663,780.35 ($4,500.00) -0.68%
Non-Controllable Operating 663,119.00 728,851.24 730,751.24 ($1,900.00) -0.26%
$3,973,851.00 $4,134,764.59 $4,141,164.59 ($6,400.00) -0.15%
08123/2000
Children's Village
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Medical Examiner
Controllable Personnel
Controllable Operating
COUNTY OF OAKLAND
FY 2000 THIRD QUARTER FORECAST
EXPENDITURES
HUMAN SERVICES
AMOUNT
ADOPTED AMENDED FY 2000 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
Administration
Controllable Personnel $154,047.00 $154,047.00 $154,047.00 $0.00 0.00%
Controllable Operating 9,726,500.00 10,309,334.00 10,309,334.00 0.00 0.00%
Non-Controllable Operating 7,212.00 7,212.00 7.212.00 0.00 0.00%
$9,887,759.00 $10,470,593.00 $10,470,593.00 $0.00 0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
Health
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$21,063,257.00 $21,063,257.00 $19,863,257.00 $1,200,000.00 5.70% Fav. due to Turnover, offset by unfav. Overtime ($73,000) from high activity in Jail Health.
3,837,972.00 5,338,373.32 5,171,373.32 167,000.00 3.13% Fav. Professional Services, $ 150,000 due to lengthy time frame involved in the billing process.
Decrease in the number of TB cases contributed to favorable Medical Supplies, $12,000.
and Drugs $36,000, partially offset by unfav. Vaccines ($31,000) due to high volume. Unfav.
Educational Supplies due to increased demand for Food Service certification books, offset by
increased revenues.
2,569,726.00 2,680,517.16 2,882,517.16 (202,000.00) -7.54% Unfav Bldg Space Allocation ($202,000) due reassignment of building space.
$27,470,955.00 $29,082,147.48 $27,917,147.48 $1,165,000.00 4.01%
$8,932,920.00 $8,935,855.00 $8,765,855.00 $170,000.00 1.90% Fay. Salaries and Fringe benefits due to turnover.
2,628,972.00 2,694,073.28 2,684,073.28 10,000.00 0.37% Fay. Drugs due to efforts to take prescriptions to Poponea because of blanket contract, $20,000.
Offset by Unfav. Laundry ($10,000) due to policy change increasing frequency laundy is done.
2,112,255.00 2,187,110.56 2,187,110.56 0.00 0.00%
$13,674,147.00 $13,817,038.84 $13,637,038.84 $180,000.00 1.30%
$1,921,223.00 $1,921,223.00 $1,895,723.00 $25,500.00 1.33% Fav. due to turnover.
463,709.00 469,230.39 601,430.39 (132,200.00) -28.17% Unfav. Professional Services ($68,500) due to increased complexity of cases requiring additional
histology slides and/or toxicology testing in order to make accurate opinions.
Unfav. Medical Service Autopsies ($51,500) due to increase contractual pathologist services.
Unfav. Medical Supplies ($17,500) for Y2K preparedness and purchase of cameras for autopsies.
A Budget Amendment is recommended.
Unfav. Equipment Repairs ($5,100) to repair broken autopsy room equipment
787,010.00 836,067.98 855,567.98 (19,500.00) -2.33% Unfav Telephone Communications ($19,500) reflective of budget not being in line with occupation
of new facility. FY2001/FY2002 Budget is in-line with anticipated usage.
,
$3,171,942.00 $3,226,521.37 $3,352,721.37 ($126,200.00) -3.91%
$32,071,447.00 $32,074,382.00 $30,678,882.00 $1,395,500.00 4.35%
16,657,153.00 18,811,010.99 18,766,210.99 44,800.00 0.24%
5,476,203.00 5,710,907.70 5,932,407.70 (221,500.00) -3.88%
$54,204,803.00 $56,596,300.69 $55,377,500.69 $1,218,800.00 2.15%
COUNTY OF OAKLAND
FY 2000 THIRD QUARTER FORECAST
EXPENDITURES
PUBLIC SERVICES
AMOUNT
ADOPTED AMENDED FY 2000 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Public Services - Admin.
Controllable Personnel $134,150.00 $134,150.00 $132,650.00 $1,500.00 1.12% Unfav. due to low estimate of salaries and fringes.
Controllable Operating 3,343.00 3,343.00 6,043.00 (2,700.00) -80.77% Unfav. due to increased travel & conf. and service mementos.
Non-Controllable Operating 11,006.00 11,006.00 8,406.00 2,600.00 23.62% Fay. due to rental equipment no longer needed.
$148,499.00 $148,499.00 $147,099.00 $1,400.00 0.94%
Veteran's Services
Controllable Personnel $1,220,489.00 $1.220,489.00 $1,181,589.00 $38,900.00 3.19% Turnover.
Controllable Operating 284,843.00 289,625.00 185,125.00 104,500.00 36.08% - Fay, reflects reduced requests for Solider Burials.
Non-Controllable Operating 207,676.00 209,188.00 256,286.00 (47,100.00) -22.52% - Unfav. due to computer & bldg. space cost greater than anticipated.
51,713,008.00 $1,719,300.00 $1,623,000.00 $96,300.00 5.60%
Community Corrections
Controllable Personnel $1,488,402.00 $1,488,402.00 $1,448,402.00 $40,000.00 2.69% Fay. due to grant funded positions
Controllable Operating 110,359.00 375,053.00 111,453.00 263,600.00 70.28% Fav. due to decreased spending in professional services and contracted services
Non-Controllable Operating 138,702.00 188,702.00 290,702.00 (102,000.00) -54.05% Unfav. reflects increased usage among all internal service funds.
$1,737,463.00 $2,052,157.00 $1,850,557.00 $201,600.00 9.82%
MSU Ext. - Oakland County
Controllable Personnel 723,065.00 723,065.00 $668,165.00 $54,900.00 7.59% - Turnover.
Controllable Operating 344,484.00 344,819.80 186,219.80 158,600.00 46.00% - Fav. reflects reduced professional services contract obligations.
Non-Controllable Operating 213,003.00 214,227.00 231,927.00 (17,700.00) -8.26% - Unfav. due to computer services & leased veh. cost greater than anticipated.
$1,280,552.00 $1,282,111.80 $1,086,311.80 $195,800.00 15.27%
Animal Control
Controllable Personnel $1,289,113.00 $1,289,113.00 $1,334,913.00 ($45,800.00) -3.55% - Unfav. due to staff
Controllable Operating 111,107.00 111,107.00 91,907.00 19,200.00 17.28% - Fay. due largely to lower damage by dogs, and professional services demands.
Non-Controllable Operating 473,094.00 475,014.65 494,314.65 (19,300.00) -4.06% - Unfav. due to computer services & equipment rental cost greater than anticipated.
$1,873,314.00 $1,875,235.24 $1,921,134.65 ($45,900.00) -2.45%
Circuit Court Probation
Controllable Personnel $0.00 $0.00 $0.00 0.00 0.00%
Controllable Operating 39,570.00 46,746.00 53,446.00 (6,700.00) -14.33% - Unfav. due largely to higher expendable equip. and travel & conference
Non-Controllable Operating 769,830.00 777,773.00 777,173.00 600.00 0.08% - Fay, due to lower stationery stock & bldg. space cost
$809,400.00 $824,519.00 $830,619.00 ($6,100.00) -0.74%
Department Total
Controllable Personnel $4,855,219.00 $4,855,219.00 $4,765,719.00 $89,500.00 1.84%
Controllable Operating 893,706.00 1,170,693.80 634,193.80 536,500.00 45.83%
Non-Controllable Operating 1,813,311.00 1,875,908.65 2,058,808.65 (182,900.00) -9.75%
$7,562,236.00 $7,901,821.45 $7,458,721.45 $443,100.00 5.61%
08/24/2000
COUNTY OF OAKLAND
FY 2000 THIRD QUARTER FORECAST
EXPENDITURES
CLEMIS AND EMERGENCY MANAGEMENT
AMOUNT
ADOPTED AMENDED FY 2000 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
------- — — —
Emergency Management .
Controllable Personnel $367,689.00 $367,689.00 $345,989.00 $21,700.00 5.90% Overtime fay, due to emergency calls lower than anticipated.
Controllable Operating 149,645.00 295,645.00 $296,845.00 (1,200.00) -0.41% Unfav, due largely to contracted services related to volunteer programs.
Non-Controllable Operating 240,066.00 242,453.07 $266,753.07 (24,300.00) -10.02% Unfav. IT oper. ($36,100) printing of disaster broch. ($18,300) & Radio Corn ($12,000)
due to increase in Nextel radios issued, reducing telephone usage $42,100.
Division Total $757,400.00 $905,787.07 $909,587.07 ($3,800.00) -0.42%
Department Total $757,400.00 $905,787.07 $909,587.07 ($3,800.00) -0.42%
'8/24/200012:06 PM 23.VVK4
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
COUNTY OF OAKLAND
FY 2000 THIRD QUARTER FORECAST •
EXPENDITURES
COMMUNITY AND ECONOMIC DEVELOPMENT
AMOUNT
ADOPTED AMENDED FY 2000 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$258,763.00 $289,160.00 $299,160.00 ($10,000.00) -3.46% - Salaries and Fringes needed for transferred Solid Waste position was under estimated.
Amendment recommended.
186,069.00 226,708.25 $166,708.25 $60,000.00 26.47% - Appropriation transfer error.
65,480.00 65,648.68 $94,546.68 ($28,900.00) -44.02% - Info Tech Operations unfav.
$510,312.00 $581,514.93 $560,414.93 $21,100.00 3.63%
Planning and Economic Development Services
Controllable Personnel $2,442,218.00 $2,254,160.00 $2,254,160.00 $0.00 0.00% -
Controllable Operating 429,970.00 763,128.21 $707,128.21 $56,000.00 7.34% - Advertising fay. $35,500 due to Professional Services charged for expense; Photo Supplies fay.
$20,000 and Drafting Supplies fay. $5,000 due to technology changes associated with GIS and
Travel and Conference unfav. ($4,500) due to Main Street Program Project.
Non-Controllable Operating 678,543.00 698,466.90 $668,466.90 $30,000.00 4.30% - Print Shop over appropriated.
$3,550,731.00 $3,715,755.11 $3,629,755.11 $86,000.00 2.31%
Community and Home Improvement
Controllable Personnel
Controllable Operating 299,025.00 299,250.00 $299,250.00 0.00 0.00% •
Non-Controllable Operating
$299,025.00 $299,250.00 $299,250.00 $0.00 0.00%
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Operating Transfer
$2,700,981.00 $2,543,320.00 $2,553,320.00 ($10,000.00) -0.39%
915,064.00 1,289,086.46 1,173,086.46 116,000.00 9.00%
744,023.00 764,113.58 763,013.58 1,100.00 0.14%
0.00 0.00 0.00 0.00 0.00%
$4,360,068.00 $4,596,520.04 $4,489,420.04 $107,100.00 2.33%
BUDGET BUDGET AMOUNT
AS AS FY 2000 FAVORABLE
ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT EXPLANATION
•n••••*nn••wal.../.•,*•••••.•••••••n*•••n•n•••••n•n•••••/...wlw ..... ....•n•••••••••nnn ..... wy.orP.An••.n ...... ./.....•n•••••n•0....1..o.o.yemn•n••n•••
NON-DEPART. APPROPRIATIONS 1
COUNTY OPERATIONS
Financial System $0.00 $0.00 $0.00 $0.00 0.00%
State Institutions _ 667,000.00 667,000.00 667,000.00 0.00 0.00%
Ambulance 19,800.00 19,800.00 19,800.00 0.00 0.00%
Insurance and Surety Bonds 85,100.00 85,100.00 85,100.00 0.00 0.00%
Road Commission - Drain Assessment 1,172,000.00 1,172,000.00 1,172,000.00 0.00 0.00%
Road Commission - Tri-Party Agreement 1,250,000.00 1,250,000.00 1,250,000.00 0.00 0.00%
Remonumentation 0.00 461,586.73 461,586.73 0.00 0.00%
Tax Tribunial 0.00 2,500,000.00 0.00 2,500,000.00 100.00% Funds to be transferred to DTRF fund for Tax Tribunal Appeals.
MAN/WAN 1,500,000.00 0.00 0.00 0.00 0.00%
Info Tech - CLEMIS 1,408,000.00 1,408,000.00 1,408,000.00 0.00 0.00%
Mental Health Authority 9,620,616.00 9,620,616.00 9,620,616.00 0.00 0.00%
Grant Match 0.00 0.00 0.00 0.00 0.00%
GIS Automation 0.00 42,000.00 42,000.00 0.00 0.00%
$15,722,516.00 $17,226,102.73 $14,728,102.73 $2,500,000.00 14.51%
COUNTY BUILDINGS $2,889,722.00 $2,272,163.13 $2,272,183.13 $0.00 0.00%
COUNTY ASSOCIATIONS
S.E.M.C.O.G. $420,000.00 $453,431.00 $453,431.00 $0.00 0.00%
Association of Metro Sewage Groups 0.00 0.00 0.00 0.00 0.00%
Area Wide Water Quality 57,200.00 57,200.00 57,200.00 0.00 0.00%
Clinton River Watershed Council 5,141.00 5,141.00 5,141.00 0.00 0.00%
Huron River Watershed Council 2,706.00 2,706.00 2,706.00 0.00 0.00%
Partnership for Saginaw River Watershed 2,276.00 2,276.00 2,276.00 0.00 0.00%
Rouge River Watershed Council 2,177.00 2,177.00 2,177.00 0.00 0.00%
National Assoc. of Counties 19,600.00 19,600.00 19,600.00 0.00 0.00%
Michigan Assoc. of Counties 53,000.00 53,000.00 53,000.00 0.00 0.00%
Traffic Improvement Association 22,300.00 22,300.00 22,300.00 0.00 0.00%
$584,400.00 $617,831.00 $617,831.00 $0.00 0.00%
SUNDRY $674,300.00 $674,300.00 $674,300.00 $0.00 0.00%
RESERVED FOR TRANSFERS
Expenditures
Contingency $379,680.00 $37,802.00 $37,802.00 $0.00 0.00%
Infrastructure Improvements 0.00 0.00 0.00 0.00 0.00%
Salary Adjustment 279,678.00 74,330.00 74,330.00 0.00 0.00%
Legislative Expense 195,173.00 195,173.00 195,173.00 0.00 0.00%
Info Tech Development 3,433,000.00 995,736.83 3,195,738.83 (2,200,000.00) 0.00% Increased usage for projects.
Classification & Rate Change 172,311.00 70,775.00 70,775.00 0.00 0.00%
Overtime 53,000.00 33,000.00 33,000.00 0.00 0.00%
Summer Employment 424,200.00 424,200.00 424,200.00 0.00 0.00%
Emergency Salaries 814,000.00 814,000.00 814,000.00 0.00 0.06%
Fringe Benefit Adjustments 120,000.00 72,993.00 72,993.00 0.00 0.00%
Capital Outlay 75,000.00 (1,554.63) (1,554.83) 0.00 0.00%
Office Automation 1,200,000.00 357,471.00 357,471.00 0.00 0.00%
$7,146,042.00 0,073,926.20 $5,273,926.20 ($2,200,000.00) -71.57%
y: Budget Division 1 08/25/2000
$0.00
0.00
0.00
0.00
0.00
0.00%
0.00%
0.00%
0.00%
0.00%
BUDGET
AS
ADOPTED
BUDGET
AS
ADJUSTED
AMOUNT
FY 2000 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION
Transfiers_tcLOke_r_Funds
General Activities $0.00 $895,937.00 $895,937.00 $0.00 0.00%
Environmental Infrastructure 5,000,000.00 5,000,000.00 5,000,000.00 0.00 0.00%
Building Fund 3,242,911.00 3,242,911.00 3,242,911.00 0.00 0.00%
Building Authority 1,876,300.00 1,876,300.00 1,876,300.00 0.00 0.00%
Information Technology Fund 0.00 15,908,698.00 15,908,698.00 0.00 0%
Oak. Enhancement-Community Partnership 0.00 22,575.00 22,575.00 0.00 0%
$10,119,211.00 $26,946,421.00 $26,946,421.00 $0.00 0.00%
TOTAL NON-DEPT. APPROPRIATIONS $36,936,191.00 $50,810,744.06 $50,510,744.06 $300,000.00 0.59%
TRANSFER TO GENERAL PURPOSE FUNDS
Friend of the Court Fund
Health Fund
Juvenile Maintenance Fund
Social Welfare Fund
CRIMP Fund
$10,455,459.00 $11,060,228.99 $11,060,228.99
22,240,812.00 22,875,136.23 22,875,136.23
11,374,293.00 12,355,712.01 12,355,712.01
45,000.00 45,000.00 45,000.00
0.00 0.00 0.00
$44,115,564.00 $46,336,077.23 $46,336,077.23 $0.00 0.00%
,eyugevision • •d b• • Budget Di 2 08/25/2000
RISK MANAGEMENT
INTERNAL SERVICE FUND
FY 2000 THIRD QUARTER FORECAST
ADOPTED
BUDGET
LIABILITY INSURANCE FUND (#677)
AMENDED FY 2000 VARIANCE
BUDGET FORECAST FAV/(UNFAV) EXPLANATION OF SIGNIFICANT VARIANCES _
REVENUE $3,565,857.00 $3,565,857.00 $3,765,857.00 $200,000.00 - Favorable investment income $225,000 due to higher than expected
interest rates and investment base; partially offset by rebilled charges
($25,000) based on anticipated level of liability insurance policies obtained
from insurance companies.
OPERATING EXPENSE $874,639.00 $874,639.00 $861,139.00 $13,500.00 -Favorable due to insurance premium costs partially offset by maintenance
department charges.
CLAIMS PAID
TOTAL EXPENSES
NET REVENUES OVER/(UNDER)
EXPENSES
$2,691,218.00 $2,691,218.00 $2,691,218.00 $0.00
$3,565,857.00 $3,565,857.00 $3,552,357.00 $13,500.00
$0.00 $0.00 _ _$213,500.00 $213,500.00_
- Adjustment of Liability Insurance claim-year reserves will be determined
by fiscal year-end analysis of claims and reserve requirements.
ADOPTED AMENDED FY 2000 VARIANCE
BUDGET _ BUDGET FORECAST FAVI(UNFAVJ EXPLANATION OF SIGNIFICANT VARIANCES
$12,998,100 $12,998,100 $12,271,900 $726,200 -Budget was established prior to receipt of latest actuarial calculation.
3,268,800 3,268,800 3,268,800 0
1,250,000 1,250,000 1,162,000 88,000 -Payments for accumulated /VL and S/L days to employees separating from County service.
333,000 333,000 297,200 35,800
39,000 39,000 39,000 0
606,800 641,800 641,800 0
500,000 500,000 500,000 0
6,882,800 6,882,800 7,691,300 (808,500)-County contributions to ICMA increased from 5% to 7% for new employees and from 9% to 10%
for current employees effective 1-1-2000. Budget anticipated an increase to 6% for new employees.
Open enrollment period in 2000 will also increase costs over adopted budget level.
506,800 506,800 38,400 468,400 -Administration fees paid to ICMA were reduced from an asset-based fee to $12/participant/yr.
814,500 814.500 814,500 0
20,028,500 20,028,500 20,028,500 0 -Costs include actual daims costs, administration and stop loss charges from BC/BS and HMO premiums.
13,174,400 13,174.400 13,174,400 0 -FICA rate applied against actual salaries cost.
2,626,000 2,626,000 2,704,200 (78,200)-Cost based on actual daims and administration fee paid to Delta Dental.
315,300 315,300 300,300 15,000
1.987,800 1,987,800 1.787,800 200,000 -Long-term Disability rate was reduced beginning Oct. 1999, subsequent to budget development.
39,000 39,000 0 39,000 -Payments received from employees for enhanced coverages in the Flexible Benefits Program
currently exceed payments made to employees for reduced coverages.
123,600 123,600 123,600 0
3,290,800 3.290,800 3,290.800 0 -Adjustment of Workers' Compensation claim-year reserves will be determined by fiscal
225,000 225,000 200,000 25.000 year-end analysis of daims and reserve requirements.
70,000 70,000 72,500 (2,500)
669,080,200 $69,115,200 $68,407,000 $708,200
$419,300 $419,300 $2,280,200 $1,860,900
FRINGE BENEFIT FUND
INTERNAL SERVICE FUNDS
FY 2000 THIRD QUARTER FORECAST
[FRINGE BENEFIT FUND (0678)
r REVENUE
RETIREES' HOSPITALIZATION -
RETIREMENT ADMINISTRATION
SICK/ANNUAL LEAVE CASH-IN
TUITION REIMBURSEMENT
EMPL. DEFERRED COMP.-ADMIN.
EMPLOYEE IN-SERVICE TRAINING
DEFINED CONTRIBUTION PLAN
DEFINED CONTRIBUTION ADMIN.
GROUP LIFE
HOSPITALIZATION
SOCIAL SECURITY
DENTAL INSURANCE
OPTICAL INSURANCE
DISABILITY INSURANCE
SHORT-TERM DISABILITY
FORFEITURES
WORKERS COMPENSATION
UNEMPLOYMENT COMPENSATION
INVESTMENT INCOME
OPERATING TRANSFER IN
TOTAL REVENUE
EXPENSE
RETIREES' HOSPITALIZATION
RETIREMENT ADMINISTRATION
SICK/ANNUAL LEAVE CASH-IN
TUITION REIMBURSEMENT
EMPL. DEFERRED COMP. ADMIN.
EMPLOYEE 1N-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
TOTAL EXPENSE
REVENUE OVER/(UNDER) EXPENSE
$12,998,100 $12,998,100 $12,652,900
3,268,800 3,268,800 3,182,500
425,000 425,000 413,100
333,000 333,000 323,500
39,000 39,000 37,300
1,106,800 1,106,800 1,079,900
6,882,800 6,882,800 6,700,900
506,800 506,800 492,700
814,500 814,500 791,700
20,028,500 20,028,500 21,034,500
13,088,800 13,088,800 13,088,800
2,626,000 2,626,000 2,779,300
315,300 315,300 331,800
612,800 612,800 593,800
1,375,000 1,375,000 1,375,000
212,500 212,500 212,500
3,290,800 3,290,800 3,290,800
225,000 225,000 221,200
1,350,000 1,350,000 2,050,000
35,000 35,000
$69,499,500 $69,534,500 $70,687,200
(8345,200)-Approximately 97.4% of the Retirement revenue allocation is projected to be recovered in FY 2000
(86,300) based on recovery through June 2000. This percentage may increase by the end of the fiscal
(11.900) year as additional positions are added and salary merit increases are awarded.
(9,500)
(1,700)
(26,900)
(181,900)
(14,100)
(22,800)
1,006.000 -Increased number of employee health-care contracts and increased cobra and rider receipts.
0 -Social Security (FICA) revenue follows FICA expenditure.
153,300 -Increased number of employee dental contracts and increased receipts from cobra, riders & retirees.
16,500
(19,000)
0 -Departments are charged for actual short-term disability costs.
0 -Return of DC Plan contributions from ICMA for employees who separated from County service prior
0 to vesting and forfeiture of unused deposits for health & dependent care reimbursement accounts.
(3,800)
700.000 -Interest rates and investment base higher than expected.
0 -Transfer from Info Tech to purchase additional PeopleSoft training units.
$1,152,700
OPERATING INCOME
NET NON-OPERATING REV (EXP)
INCOME (LOSS) BEFORE OPERATING
TRANSFERS
OPERATING TRANSFERS IN
OPERATING TRANSFERS OUT
NET REVENUES OVER/(UNDER)
EXPENSES
DEPARTMENT OF MANAGEMENT AND BUDGET
INTERNAL SERVICE FUNDS
FY 2000 THIRD QUARTER FORECAST
OFFICE EQUIPMENT FUND (66400)
OPERATING REVENUE-Inside
OPERATING EXPENSE
ADOPTED AMENDED FY 2000 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)
$339,552.00 $339,552.00 $435,000.00 $95,448.00
$481,505.00 $481,505.00 $461,505.00 $20,000.00
($141,953.00) ($141,953.00) ($26,505.00) $115,448.00
$141,953.00 $141,953.00 $148,940.00 $6,987.00
$0.00 $0.00 $122,435.00 $122,435.00
$0.00 $0.00 $0.00 $0.00
($890,000.00) ($890,000.00) ($890,000.00) $0.00
----- ------
($890,000.00) ($890,000.00) ($767,565.00) $122,435.00
EXPLANATION OF SIGNIFICANT VARIANCES
- Favorable due to increased revenue from equipment
rental.
- Favorable due to lower equipment repairs & maintenance
costs.
- Investment income favorable due to fund balance and
economy. Over projected Interest from Municipalities will
offest a portion of that favorability.
08/01/2000
DEPARTMENT OF CENTRAL SERVICES
INTERNAL SERVICE FUNDS
FY 2000 THIRD QUARTER FORECAST
ADOPTED
BUDGET
[MATERIALS MANAGEMENT FUND 633
AMENDED
BUDGET
FY 2000 VARIANCE
FORECAST FAV/(UNFAV) EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING REVENUE
OPERATING EXPENSE
OPERATING INCOME(LOSS)
NON-OPERATING REVENUE(EXPENSE)
NET INCOME (LOSS)
$3,340,076.00
3,346,576.00
(6,500.00)
6,500.00
$0.00
$3,340,076.00
3,346,576.00
(6,500.00)
6,500.00
$0,00_
$3,407,321.00
3,347,793.00
59,528.00
31,005.00
$90.533.00
$67,245.00 Favorable due to increase in demand for meats and groceries
(1,217.00) Unfav. due to sal & frg turnover, Incr. demand for meats, groceries, & sta. stk.
66,028.00
24,505.00 Fav. due to increased investment & County auction income.
$90.533.00
[MAILING, CONVENIENCE COPIER AND PRINTING FUND 667
OPERATING REVENUE
OPERATING EXPENSE
OPERATING INCOME(LOSS)
NON-OPERATING REVENUE(EXPENSE)
NET INCOME (LOSS)
$2,418,437.00 $2,418,437.00 $2,464,166.00
2,446,937.00 2,446,937.00 2,625,290.00
(28,500.00) (28,500.00) (161,124.00)
28,500.00 28,500.00 (3,306.00)
$0.00 $0.00 ($164.430.00)
$45,729.00
(178,353.00)
(132,624.00)
(31,806.00) Unfav. due to deminishing fund bal, and less investment income, negative
gain on sale of equipment.
($164430.00)
Fay. due largely elimination of 2.5 cent presort discount, and copier
pro-rata billing to offset less than minimum copy usage.
Unfav. due to sal. & frg, copier rental, metered postage, partially offset by exce
copy charges, equip. repairs & maint. and internal services.
10001:12 PM MATMGT.VVIC4
ADOPTED
BUDGET
[OAKLAND COUNTY INTERNATIONAL AIRPORT 581
$2,694,821.00 $2,694,821.00 $3,543,356.00 $848,535.00 Fay. due largely to increased aviation gas sales, land lease & T-Hanger rev. under-budgeted.
3,094,821.00 3.2604.00 3 _648,976.00 (358,372.00) Fay. in sal & frg turnover $18k, grant match not spent $196k, offset by unfav. U. S. Customs
($389k) unfav. commod. ($29k) & internal svc ($38k) due to oper. growth.
and other contractual svcs. of ($116).
($400,000.00) ($595,783.00) ($105,620.00) $490,163.00
400,000.00 400,000.00 470,806.00 70,806.00 Fay. due to refund of prior years expend., and gain on sale of equipment.
$0.00 ($195,7EI3.Q0)M186.0eI560969.00
$4,188,906.00
4,743,906.00
($555,000.00)
355,000.00
($200,000.00)
$4,272,087.00
5,039,786.00
($767,699.00)
355,000.00
($412,699.00)
$4,396,736.00
5,337,299.00
($940,563.00)
726,137.00
($214,426.00)
$124,649.00
M97,513.00)
($172,864,00)
371,137.00
$198,273,00
Fay. due to increased reimb. of sal., Service fees, inreased gas, oil & grease sales.
Unfav. due to sal & frg, inced, insur. over est. bud., sub. repairs, gas, oil & grease, shop supplie
Fay. due to increased gain on sale of vehicles, sale of scrap, investment income.
0.00 248,506.00 248,506.00
_ ($200.000.00) _0164.193.00) $34.080.00 _ $198,273.00
$602,038.00 $602,038.00 $720,561.00 $118,523.00 Fay. due to increase in leased radios and antenna site fav. reflects more 3rd party contracts.
976,818.00 1,001,097.00 1,335,515.00 334,418.00 Fav. due to increase in leased radios and the revenue associated with increased installs.
$1,578,856.00 $1,603,135.00 $2,056,076.00 $452,941.00
1,930,366.00 1,954,645.00 $2,970,755.00 (1,016,110.00) Unfav largely in sal. & frg. ($70,564), OT ($105,000)..
also, unfav. claims pd. ($87,500), equip. repairs & maint ($444,599)
8. comrnod. ($215,559) for instal. of MDC radios.
0.00
OPERATING INCOME (LOSS) ($351,510.00) ($351,510.00) ($914,679.00) ($563,169.00)
NON-OPERATING REVENUE(EXPENSE)
NET INCOME(LOSS) BEFORE OPERATING
TRANSFERS ($344,010.00) ($344,010.00) ($805,609.00) ($461,599.00)
OPERATING TRANSFERS IN 0.00 104 880.00 104,880.00 0.00
NET INCOME (LOSS) ($344,010,00) 0239,130.00) ($700129,00) ($461.599,00)
7,500.00 7,500.00 $109,070.00 101,570.00 Fay. due to interest income & refund of prior yrs. exp. not budgeted.
DEPARTMENT OF CENTRAL SERVICES
INTERNAL SERVICE FUNDS.
FY 2000 THIRD QUARTER FORECAST
AMENDED FY 2000 VARIANCE
BUDGET FORECAST FAV/(UNFAV) EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING REVENUE
OPERATING EXPENSE
OPERATING INCOME (LOSS)
NON-OPERATING REVENUE(EXPENSE)
NET INCOME (LOSS)
[MOTOR POOL 661
OPERATING REVENUE
OPERATING EXPENSES
OPERATING INCOME (LOSS)
NON-OPERATING REVENUE(EXPENSE)
NET INCOME(LOSS) BEFORE OPERATING
TRANSFERS
OPERATING TRANSFERS IN
NET INCOME (LOSS)
[RADIO COMMUNICATIONS 661:i
OPERATING REVENUES - OUTSIDE
OPERATING REVENUES - INSIDE
TOTAL OPERATING REVENUE
OPERATING EXPENSES
_1/200010:14 AM CENT SVS.Vill<4%
$1,531,732.00
21,391,877.00
$22,923,609.00
$20,921,286.00
$2,002,323.00
$200,000.00
$54,000.00
($2,405,000.001
($148,677.00)
$2,002,323.00
$200,000.00
$54,000.00
($2,405,000.00)
($148,677.00)
$107,562.00 $114,062.00 $107,562.00 OPERATING REVENUES - OUTSIDE $6,500.00 - Fay. Daily Stall Rental fees based on current level of Market activity.
$0.00
NET REVENUES OVER(UNDER)
EXPENSES $0.00 ($32,400.00) ($32,400.00)
DEPARTMENT OF FACILITIES MANAGEMENT
INTERNAL SERVICE FUNDS
FY 2000 THIRD QUARTER FORECAST
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2000
FORECAST
VARIANCE
EAV/jUNFAV) EXPLANATION OF SIGNIFICANT_VARIAN.CES
!FACILITIES MAINTENANCE & OPERATIONS (#631)
OPERATING REVENUES:
Outside Revenue
Inside Revenue
Total Revenue
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
NON-OPERATING REVENUE/(EXPENSE)
OPERATING TRANSFERS IN
OPERATING TRANSFERS (OUT)
NET REVENUES OVER(UNDER)
EXPENSES
!PONTIAC MARKET (#261)
$1,531,732.00 $1,639,232.00 $107,500.00 - Revenue forecast is based on actual charges to Departments and Outside Agencies _
20,434,477.00 (957,400.00) through June 2000 plus anticipated charges for the remainder of FY 2000. Office space
charges to CMH were budgeted as Inside Revenue, but are now being receipted in the
$22,923,609.00 $22,073,709.00 ($849,900.00) the Outside Agencies account.
$20,921,286.00 $21,026,786.00 ($105,500.001 - Unfav. Sublet Repairs (600,000), Electrical Services (75,000), IT Operations (38,500),
Leased Vehicles (31,600), Telephone Communications (25,000) and Office Supplies
(22,500) all based on current usage projections; partially offset by fay. Controllable Personnel
costs 442,400 (primarily for Overtime), Material & Supplies and Maintenance Supplies 195,000,
$1,046,923.00 ($955,400.00) Depreciation - Equipment 33,700 and Laundry & Cleaning 15,000 based on historical
projections. FM&O Fund equity is sufficient to cover the projected variance.
$175,000.00 ($25,000.00) - Investment Income estimate is based on amount invested and anticipated interest rates.
$54,000.00 $0.00
(2,405,000.00) $0.00
($1,129,077.00) ($980,400.00)
21,391,877.00
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
OPERATING TRANSFERS IN
OPERATING TRANSFERS (OUT)
$107,562.00 $107,562.00 $146,462.00 ($38,900.00) - Unfav. Contracted Services for repairs to Market building (33,700) (Market Fund equity
is sufficient to cover this one-time expenditure) and overtime costs.
$0.00 $0.00 ($32,400.00) ($32,400.00)
08/07/200001:10 PM 1 FM0FORE.WK4%
ADOPTED AMENDED FY 2000
BUDGET BUDGET FORECAST
1,998,968.00 1,998,968.00 2,644,373.00
16,762,085.00 16,837,085.00 20,109,840.00
1,869,608.00 1,869,608.00 1,869,608.00
360,805.00 15,714,648.00 15,714,648.00
20,991,466.00 36,420,309.00 40,338,469.00
20,630,661.00 24,705,218.00 31,562,883.00
Information Technology - Operations (636)
OPERATING REVENUES:
Outside
Inside
Prior Years Balance
OPERATING TRANSFERS IN
Total
OPERATING EXPENSES
515,012.00 515,012.00 849,868.00
1,504,128.00 1,507,827.00 1,527,048.00
318,150.00 330,650.00
2,019,140.00 2,340,989.00 2,707,566.00
1,790,734.00 1,794,433.00 2,341,066.00
228,406.00 546,556.00 366,500.00
Information Technology - CLEMIS (695)
OPERATING REVENUES:
Outside
Inside
OPERATING TRANSFERS IN
Total
OPERATING EXPENSES
OPERATING INCOME (LOSS)
Total Fund:
334,856.00 - CLEMIS operations-outside fay. $65,564 due to new customers. In-car terminals fay. $51,539
due to more than anticipated billing. Interest on investments fav. $216,000.
19,221.00 -
12,500.00 - Represents operating transfers per Miscellaneous Resolution Nos. 99216; 99331; 99303; 99324;
00001; and transfer for FOC mugshot equipment
366,577.00
(546,633.00)- Unfav. due to expendable equipment expense, & depreciation over budget.
Misc. Res. #99331, and increased demand on professional svcs., and communications.
(180,056.00)
1,527,803.00 1,430,015.00 1,165,946.00
2,880,632.00 2,829,132.00 2,943,443.00
890,000.00 908,987.00 908,987.00
5,298,435.00 5,168,134.00 5,018,376.00
3,885,309.00 3,829,957.00 4,442,783.00
535,000.00 550,672.00 550,672.00
OPERATING REVENUES:
Outside
Inside
OPERATING TRANSFERS IN
Total
OPERATING EXPENSES
OPERATING TRANSFERS (OUT)
Total Fund:
(264,069.00)- Sale of service fay. $127,587 due to rate increase. Interest fay. $29,748. Unfav. commissions,
($248,482) due to overstated budget. Rental equip. is no longer collected.
114,311.00 - Rebilled charges no longer collected.
0.00 Increase is a transfer to purchase emergency phones for EMS.
(149,758.00)
(612,826.00)- Unfav. contractual services ($323,232) and commodities ($159,038) primarially due to new equipmen
and service contracts. Depreciation fav. $322,413 reflects equipment coming off depreciation
0.00 schedule.
DEPARTMENT OF INFORMATION TECHNOLOGY
INTERNAL SERVICE FUNDS
FY 2000 THIRD QUARTER REPORT
OPERATING TRANSFERS (OUT)
VARIANCE
FAV/(UNFAV)
Total Fund:
645,405.00 - Fav. billing to outside agencies $426,972 and fay. interest on investments $218,433 due to rates.
Land file tax bills fav. $19,523 reflects increased activity. Reimbursement for equalization services
unfav. ($105,901) reflects less than anticipated demand for service. Unfav, enhanced access,
($570,166) due to less than anticipated product availability.
3,272,755.00 - Few. operations $1,346,726 and development $2,582,573 due to increased usage and rates.
0.00 - Offset of I.T. fund balance to balance I.T. budget
0.00 - Represents operating transfers per Misc. Res. Nos. 99265; 99283; 99331; 00060; and 00065.
3,918,160.00
(6,857,665.00)- Unfav. depreciation ($5,246,780) denotes depreciation on previously purchased assets (non-cash)
expense). Unfav. communications ($213,818) due to increased cost of data lines. Unfav. equipment
repairs and maint. ($704,398) due to cost of maintenance contracts for new equipment. Software
support maint. unfav. ($1,958,684) is a new unbudgeted line item. Salary and fringes fav. $281,994
due to turnover and professional services fav. $666,309 due to project expenses not realized
COMMENTS
OPERATING INCOME (LOSS) 360,805.00 11,715,091.00 8,775,586.00 (2,939,505.00)
Information Technology - Telephone Communications (675)
OPERATING INCOME (LOSS) 1,948,126.00 787,505.00 24,921.00 (762,584.00)
FY 2000 BUDGET AMENDMENTS
FY 2000 BUDGET AT ADOPTED
BUDGET AMENDMENTS
$ 307,991,233.00
M.R. 99286 - 11/18/99 108,000.00
Management and Budget - Equalization Services for City of Ferndale
M.R. 99285 - 11/18/99 25,150.00
Management and Budget - Equalization Services for City of Birmingham
M.R. 99261 - 11/18/99 86,181.00
Sheriff Department - SCAAP Grant Acceptance
M.R. 99284 - 11/18/99 145,432.00
Management and Budget - Equalization Digital Photography Project
M.R. 99283 - 11/18/99 556,665.00
Information Technology - Assessing, Equalization and Tax Billing
M.R. 99303 - 12/16/99 20,000.00
Sheriff Department - Bomb Dog Vehicle
M.R. 99304 - 12/16/99 200,000.00
Community Corrections - Retail Fraud Program
M.R. 99340 - 12/16/99 500,000.00
Circuit Court/District Court/Probate Court -
Judicial Information Management System
M.R. 99333 - 12/16/99 22,921.00
Drain Commission - Recruitment and Retention Issues
M.R. 99331 - 12/16/99 15,050,205.27
Management and Budget - FY 1999 Year End Report
M.R. 99302 - 12/16/99 140,323.00
, Sheriff Department - Auxiliary Deputy Serv. City of Pontiac
M.R. 99326 - 12/16/99 (49,050.00)
Sheriff Department - Orion Township Contract Amendment
M.R. 99325 -12/16199 66,253.00
Sheriff - Department - 1999 -2003 Contract with Lyon Township
M.R. 99324 - 12/16/99 . 134,200.00
Sheriff Department - 1999 - 2003 Contract with Highland Township
M.R. 99334 - 12116/99
Drain Commission - Engineer Bonus
21,706.00
M.R. 99332 - 1/27/00 50,000.00
Health Division - Hepatitis A and B Vaccine Fee Schedule
M.R. 99344- 1/27/00 18,600.00
Sheriff Department - Fire Dispatch Service - Independence Township
M.R. 00001 - 1/27/00 552,279.00
Sheriff Department - 2000 - 2003 Contract with Oxford Township
M.R. 00008 - 1/27100 20,000.00
Management and Budget/Equalization - South Lyon Service Contract
M.R. 00014 - 1/27/00 315,000.00
Sheriff Department - Use of Forfeited Funds/Command Vehicle
M.R. 00015 -2124100 26,000.00
Prosecuting Attorney - Forfeited Funds for Drug Awareness Calendars
M.R. 00039 - 3/9/00 520,291.00
Management and Budget - FY 2000 First Quarter Financial Forecast
M.R. 00048 - 3/23/00 72,455.00
Circuit Court - Use of Mediation Funds
M.R. 00065 - 3/23/00 5,000,000.00
Circuit/District/Probate Courts - JIMS Phase II
M.R. 00076 - 5/4/00 3,500
Sheriff Dept. - Use of Automobile Theft Prevention Authority Forfeited Funds
(200,815) M.R. 00096 - 5/4/00
Community & Economic Dev. - Creation of the Oakland Enhancement
Special Revenue Fund
401,033 M.R. 00099 - 5/18/00
Probate Court/Estates and Mental Health Unit - Authorization to Implement
Probate Document Image Storage/Retrieval System
M.R. 00126 - 6/15/00
Prosecuting Attorney - Use of Forfeited Funds to Provide Financial Support
to the Troy Community Coalition
10,000
M.R. 00127 -6115100 10,000
Circuit Court - Use of Mediation Funds
M.R. 00130 - 6115100
Sheriff Dept. - Creation of Crime Lab Specialist II Position Funded by
P.A. 35 of 1994
46,755
73,100 M.R. 00131 - 6118/00
Sheriff Dept. - Use of Forfeited Funds/Southeastern Oakland County Resource
Team (SOCRT) and Continuation of One (1) Deputy II Position
MA. 00148 - 6115/00
Circuit Court - Acceptance of Oakland County Local Law Enforcement Block
Grant (Ongoing Grant)
MA. 00153 - 6/15/00
Department of Management and Budget - Fiscal Year 2000 Second Quarter
Financial Forecast and Budget Amendments
MA. 99309 - 6115100
CLEMIS and Emergency Management - Acquisitiion of Fire Records
Management System
21,207
1,376,478
800,000
AMENDED BUDGET AS OF 6130/00 $ 334,135,102.27
Interoffice
MEMORANDUM
to: Tim Soave, Fiscal Services
cc: Claudia Martell°, Reimbursement
from: Nancy R. Wagner, Reimbursement i 04)
re: Inmate Waived Report
date: July 21, 2000
Submitted for your review is the Inmate Report for 2000 for the Months of April, May, and June.
Number of Amount Waived
Accounts
April 00 022090 CZ 72 $ 147,619.60
May 00 022790 CZ 60 $ 187,955.40
June 00 023563 CZ 84 $ 193,468.40
TOTAL 216 $ 529,043.40
From the desk of ....
Nancy R. Wagner
Reimbursement
1200 N Telegraph Road
Pontiac, Michigan 48343
te1:248-858-1459
fax:248-975-4288
Resolution 400223 September 7, 2000
Moved by Douglas supported by Sever the resolution be adopted.
AYES: Causey-Mitchell, Coleman, Douglas, Galloway, Garfield, Gregory,
Jensen, Law, McPherson, Melton, Millard, Moffitt, Obrecht, Palmer, Patterson,
Sever, Suarez, Taub, Amos, Appel, Buckley. (21)
NAYS: None. (0)
A sufficient majority having voted therefor, the resolution
was adopted.
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, G. William Caddell, Clerk of the County of Oakland, do hereby certify that the
foregoing resolution is a true and accurate copy of a resolution adopted by the
Oakland County Board of Commissioners on September 7, 2000 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 7t441ay 0/September, 2000.
G. William Caddell, County Clerk