HomeMy WebLinkAboutResolutions - 2003.09.18 - 27342• •
MISCELLANEOUS RESOLUTION 103254 September 18, 2003
BY: FINANCE COMMITTEE, CHUCK MOSS, CHAIRPERSON
IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2003 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 variance between estimated revenue and
projected expenditures, amendments are required; and
WHEREAS the Fiscal Year (FY) 2003 Third Quarter Financial
Forecast Report has identified several variances and budget amendments
are recommended; and
WHEREAS the Probate Court is projected to be unfavorable
($66,000) in Fees for Guardian Ad Litem expenses due to an increase in
caseload; sufficient Salaries and Fringe Benefits are projected within
Probate Court's budget to offset the unfavorability; and
WHEREAS the Drain Commissioner is requesting to amend the General
Fund revenue and expenditure budget to increase Reimbursed Salaries
revenue $240,000 charged to projects for 80 96 of salaries and fringe
benefit expenditures for the Drainage District Legal Counsel, Drainage
District Insurance Administrator and Drain Community Liaison positions
and;
WHEREAS a budget amendment is necessary to reallocate budgets
within the County Executive's Administration Division budget for
Expendable Equipment Expenses $1,700 and Furniture and Fixtures
$19,061; and
WHEREAS a budget amendment of $35,000 is recommended for the
Health Division office renovations in the North Health Center, to
improve office efficiency and ensure privacy of health records and
funding is available within the division to transfer to the Project
Work Order Fund (404); and
WHEREAS Community Corrections is requesting an amendment to
increase revenues and expenditures for the Step Forward Program
$51,000, due to an increase in activity; and
WHEREAS the Public Services divisions request an amendment
to reclassify the budget allocations for Postage, Postage Fees, Mailing
Handling Services to Mail room, to reflect the use of in-house
services; and
WHEREAS the Solid Waste Program is utilizing the Print Shop for
its printing needs instead of outside printing as originally
anticipated; therefore a budget amendment is requested to reallocate
funding for this activity; and
WHEREAS an amendment is also necessary for Professional Services
for the Solid Waste Program's planning and implementation efforts and
additional work performed by the Environmental Program Coordinator for
the Gypsy Moth and West Nile Programs; funding is available within the
division's Controllable Personnel projected favorability to cover the
additional expense; and
WHEREAS Information Technology GIS is requesting to transfer
$5,000 from IT-Professional Services to the General Fund to assist
Planning and Economic Development with developing inventory of
sensitive natural areas that will be mapped using the County's GIS
System; and
FINANCE COMMITTEE: Motion carried unanimously on a roll call vote with
Moffitt and Gregory absent.
WHEREAS an amendment is recommended for the Non-Departmental
budget to move the appropriation for Community Mental Health Authority
($9,620,616) and Road Commission Tr-Party ($3,500,000) expenditures
into accounts in accordance with the proper GASB 37 account
classification; and
WHEREAS the Clerk's Office is projecting a favorable variance in
Mortgages; a budget amendment is recommended to recognize the
additional revenue to offset a projected unfavorable variance in the
Clerk's Jury Commission Division due to under budgeted personnel costs
($7,174), Emergency Response and Preparedness Controllable Personnel
($16,000) for On-Call charges, Tornado Siren Equipment replacement
($94,000), Probation Residential Centers Contracts ($200,000) due to
increase in activity, and Non-Departmental Transfer to IT for Phase III
of Jail Data Warehouse support ($148,000); and
WHEREAS an amendment is necessary to cover the cost of replacing
ten (10) owned vehicles with ten (10) leased vehicles under the
County's vehicle replacement guidelines for the Drain Commissioner in
the amount of $273,440, and funding is available within the Drain
Equipment Fund (639) to cover the cost; and
WHEREAS an amendment totaling $55,696 is recommended to fund the
cost of miscellaneous computer equipment per the requests of various
departments, which were not originally included in the Information
Technology Fund budget; sufficient funding is available with in the
departments' budgets to cover the cost of the equipment; and
WHEREAS several Proprietary Fund amendments are recommended as
attached in Schedules B through E for the following:
Schedule B - To reallocate Liability Insurance within the
departments to correspond with Budget Task amendment during Phase I.
Schedule C - To move Fringe Benefit Budget allocations into the
proper accounts to comply with GASB 34 reporting requirements.
Schedule D - To reduce Building Space Allocations per Budget Task
for Facilities Management.
Schedule E - To reallocate Information Technology Operations and
Telephone Communications budgets within various departments to
correspond with actual usage; and
WHEREAS an amendment is requested from the Designated Fund
Balance in the amount of $3,800 to fund the cost of a Project Work
Order to install privacy materials at the Health Clinic-South Office;
and
WHEREAS amendments are also requested by Information Technology
to transfer funds from Designated Fund Balance per M.R. #02319 for the
following:
• $1,000,000 - Replacement funding for future information
technology needs.
• $427,101 - Funding of E-Health operations.
• $165,525 - General Fund support (75%) of a Fire Records
• Management System for FY 2003; and
WHEREAS per Section 25 of the General Appropriations Act, the
Department of Management and Budget is informing the Board of the
uncollectable inmate expenditures, as well as recommending the "write-
off" of $306,249 in uncollectable Home Improvement Deferred Loans,
which have been processed through the Sheriff's Sale, the loans against
the Community Home Improvement Division have been removed, and the
properties have been sold.
NOW THEREFORE BE IT RESOLVED that the Board of Commissioners
accepts the Fiscal Year 2003 Third Quarter Financial Report.
BE IT FURTHER RESOLVED that the Board authorizes amendments to
the FY 2003 Budget as detailed in the resolution per Schedules A, B, C,
D, and E.
• V
BE IT FURTHER RESOLVED that the uncollectable debts, as
recommended by the Department of Management and Budget, and as listed
on Schedule F, are authorized to be written off.
BE IT FURTHER RESOLVED that $3,800 of the FY 2003 Designated Fund
Balance (GL Acct #9407-970000) be appropriated to the Health Division
Budget for the installation of cubical walls within Health Clinic -
South Office to maintain HIPPA compliance, as specified below:
GENERAL FUND
Revenue
90-190000-14000-1582 Planned Use of Fund Balance $3,800
Expenditure
16-233200-46000-6311 Health - Clinic $3,800
0
BE IT FURTHER RESOLVED that $1,592,626 of the FY 2003 Designated
Fund Balance be appropriated for Information Technology for replacement
funding for future information technology needs ($1,000,000 - GL Acct
#9407-021000), E-Health operations ($427,101 - GL Acct #031000) and FY
2003 General Fund support (75 96) of Fire Records Management System
($165,525 - GL Acct #061000) as specified below:
GENERAL FUND
Revenue
90-190000-14000-1582 Planned use of Fund Balance $1,592,626
Expenditure
90-310000-98636-8001 Transfer Out to IT $1,592,626
0
INFORMATION TECHNOLOGY FUND (636)
Revenue
18-636113-98101-1701 Transfer from General Fund $1,427,101
Expenditure
18-636122-15000-3348 Professional Services $ 427,101
Change in Fund Equity $1,000,000
FIRE RECORDS MANAGEMENT (531)
Revenue
23-531003-98101-1701 Transfer from General Fund
Change in Fund Equity
165,525
165,525
Chairperson, on behalf of the Finance Committee, I move the
adoption of the foregoing resolution.
FINANCE COMMITTEE
Af_P-
• .11
L. BROOKS PATTERSON, OAKLAND COUNTY EXECUTIVE
Laurie Van Pelt, Director
Wm, Art Holdsworth, Deputy Director
COAKILAND7
COUNTY MICHIGAN
DEPARTMENT OF MANAGEMENT AND BUDGET
TO: Members of the Finance Committee
FROM: Laurie Van Pelt, Director, Management and Budget
Art Holdsworth, Deputy Director, Management and Budget
Tim Soave, Manager, Fiscal Services
Nancy Fournier, Chief, Fiscal Services
LaVerne Smith, Supervisor of Fiscal Services
SUBJECT: Letter of Transmittal - Fiscal Year (FY) 2003 Third Quarter Report
DATE: August 28, 2003
FY 2003 FORECAST
Attached please find the FY 2003 Third Quarter Forecast. In total, Fiscal Services Division forecasts that the
County will complete Fiscal Year 2003 with favorability of $13,357,860 in the General Fund/General
Purpose Operations (GF/GP). This surplus is in addition to the $12,380,410 that was transferred to the
Budget Transition fund for use towards the FY 2004 Budget. GF/GP includes all operations except Grants,
Enterprise Funds and Internal Service Funds. This overall favorability is split between receiving $5,346,105
more revenue than budgeted (1.43%), and expending $8,011,755 less than budgeted (2.14%).
REVENUES
Actual GF/GP revenues are 1.43% more than budget or $5,346,105, detailed as follows:
A. GENERAL FUND — TAXES— Unfavorable: $1,740,000
This unfavorability results from an underestimation of budget reduction for tax exempt
properties (TIFAs and DDAs) of $1,740,000. This unfavorable amount is offset by the
Treasurer's office recaptured funds for TIFAs and DDAs.
B. GENERAL FUND — INTERGOVERNMENTAL — Favorable: $1,600,500
This favorability is due to State revenue sharing of $1,500,000 and Cigarette Tax Revenue
of $130,000 partially offset by decrease in Convention Facility Tax.
C. GENERAL FUND - CHARGES FOR SERVICES - Favorable: $10,037,682
This favorability primarily results from an unanticipated continuance of activity regarding
new mortgages and refinancing as reflected in the Clerk's revenue due to low mortgage
interest rates. The result is $7,585,800 in favorability. Favorability of $1,260,000 is
forecasted for the Sheriff's department for deferred offender, $500,000, special deputies of
$200,000, Board and Care $200,000 and other programs. The Treasurer reports an increase
in recovery of TIFA, DDA and Industrial Facility tax for a favorability of $720,200.
Favorability of $311,582, in the Drain Commissioner's budget is the result of additional
costs charged to various funds and projects.
D. GENERAL FUND — MISCELLANEOUS REVENUE — Unfavorable: $3,3000,000
This unfavorability results from the continued low interest rates affecting interest income.
E. GENERAL PURPOSE FUNDS — INTERGOVERNMENTAL - Unfavorable: $867,077
Health State subsidy is unfavorable ($867,077) due to the budgeting of MDEQ under
Health Division charges for services which is offset by Health expenditure favorability.
EXECUTIVE OFFICE BUILDING 34 EAST • 1200 N TELEGRAPH RD DEPT 409 • PONTIAC MI 48341-0409 • (248) 858-2163 • FAX (248) 858-9172
EXPENDITURPS
In total, expenditures are estimated to be 1.49% ($5,582,492) below budget. Favorability is related to the
county implemented a hiring freeze in the summer of 2002, which contributed significantly to the increase in
favorability from turnover. Four departments are projected to experience overall unfavorability: Clerk
/Register of Deeds, Drain Commissioner, Central Services and Public Services
A. CLERK/REGISTER OF DEEDS — The majority of unfavorability ($806,100) stems from
the continued high volume of activity within the Clerk/Registered of Deeds Office, in spite
of the current decline in the economy. The Professional Services contract for document
processing is expected to be ($1,300,000) over budget. Total favorability from Clerk's
revenue of $4,404,900 more than offsets the unfavorability from expenditures.
B. DRAIN COMMISSIONER — Total unfavorability of ($56, 211) is forecasted due to
increased overtime for Soil Erosion ($25,813) to meet increased inspection requirements,
Recognition Events ($52,000), Professional Services ($11,000). Revenue favorability
(reimbursements) and expenditure favorability for Radio Communications $66,670 offset
the unfavorable expenditures.
C. CENTRAL SERVICES — Unfavorability ($36,530) is mostly the result of Internal Service
charges for Micrographics ($32,100) for the one-time storage program for Record
Retention benefiting all departments.
D. PUBLIC SERVICES — Unfavorability ($27,000) stems from the anticipated State revenue
reduction which affects the Probation Residential Centers (PRC) estimated at ($200,000)
provided for alternative sentencing. Some favorability exists in the department due to
turnover $170,000.
FUND BALANCE
To date in FY 2003, $11.6 million was allocated from General Fund - fund balance. Therefore, the $13.5
million forecasted favorability will reimburse the General Fund for this year's activities. Of the $12.4
million Budget Transition fund, the County used $8.1 million to balance FY 2004 and FY 2005.
7
REVENUES
GENERAL FUND
Taxes
Intergovernmental
Charges for Services
Miscellaneous Revenue
SUB-TOTAL GENERAL FUND
USE OF PRIOR YEAR FUND BALANCE $16,469,748.00 $23,358,703.87 $23,358,703.87 $0.00 0,00%
TOTAL GRGP FUNDS $364 086 237.00 $374" „ . 840 951.87 $380 187 056 87 . $5,346,105.00 1.43%
103%
4.79%
7.01%
3.74%
$16,803,405.04 $16,192,805.04 $610,600.00
99,847,889.02 98,077,789.05 1,770,099.97
$116,651,274.08 $114,270,574.09 $2,380,699.97
$11,935,637.02 $12,549,337.02
3,960,525.31 3,473,125.31
2,637,659.52 2,571,481.52
2,677.691.90 2,677,691.90
4,294,851.17 4,377,927.17
($613,700.00) -5.14%
487,400.00 12.31%
66,178.00 2.51%
0.00 0.00%
(83,076.00). -1.93%
3,63%
1.77%
2.04%
$24,092,329.00 $25,508,384.92 $25,649,562.92 ($143,198.00) -0.58%
($66,347.00) -0.77%
468,000.00 2.34%
(38,500.00) -1.74%
99,800.00 6.38%
68,100.00 1.36%
2,230,300.00 4.02%
0.00 0.00%
255,900.00 4.15%
0.00 0.00%
$3,019,253.00 2.85%
2.39%
$ 46 225 030 00 $ 54,253,348.74 $ 53 910 148 74 $ 343 200 00 0.63%
TOTAL GOVERNMENTAL EXPENDITURES $364,086,237.00 $374,840,951.72 $366,829,196.75 $8,011,754.97 2.14%
General Fund/General Purpose
Favorable/(Unfavorable) $0 $0 $13,357,860.12 $13,357,859.97
7 'COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
GENERAL FUNDIGENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
GENERAL PURPOSE FUNDS
Intergovernmental
Charges for Servicps
SUB-TOTAL GENERAL PURPOSE FUND
FY 2003
ADOPTED
BUDGET
$206,090,050.00
42,576,050.00
88,337,932.00
9,972,380.00
$326,976,412.00
$14,155,215.00
6,484,862.00
$20,640.077.00
BUDGET
AS
AMENDED
$206,090,050.00
42,586,050.00
71,121,904.00
9,970,288.00
$329,768,292.00
$14,128,460.00
7,585,496.00
$21,713,956.00
FY 2003
FORECAST
$204,350,050.00
44,188,550.00
81,159,588.00
6,670,288.00
$336,366,474.00
$13,261,383.00
7,200,496.00
$20,481,879.00
AMOUNT
FAVORABLE/
(UNFAVORABLE). PERCENT
($1,740,000.00) -0.84%
1,600,500.00 3.78%
10,037,882.00 14.11%
(3,300,000.00) -33.10%
$8,598,182.00 2.00%
($867,077.00) -6.14%
(385,000.09 -5.08%
_01,252,077.00) -5.77%
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
Ubrary Board
Drain Commissioner
TOTAL GENERAL GOVERNMENT
COUNTY EXECUTIVE
County Execudve Main.
Management and Budget
Central Services
Facilities Management
Personnel
Human Sys.
Public Services
Community & Economic Day.
Workforce Development
TOTAL COUNTY EXECUTIVE
TOTAL DEPARTMENTS
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NON-DEPARTIVENTALS
$45,420,289.00
13,816,586.00
5,229,238.00
$64,268,113.00
$17,086,968.00
98,158,014.00
$115,244,982.00
$10,701,074.00
3,757,270.00
2,716,021.00
2,725,712.00
4,192,252.00
$7,785,883.00
$18,750,465.00
$2.264,256.00
$1,720,648.00
$4,658,189.00
$58,189,570.00
$14,015,190.00
$5,797,917.00
$1,075,865.00
$114,257,783.00
$317,861,207.00
$45,154,819.75
14,090,230.22
5,281,099.17
$64,506,149.14
$8,631,947.08
$20,006,350.21
$2,102,996.45
$1,564,758.81
$4,989,287.78
$55,489,756.36
$13,889,732.79
$6,173,320.38
$1.075,665.00
$113,923,814.86
$320,587,602.98
$43,786,819.75
13,415,230.22
4,892,299.17
$82,094,349.14
$8,698,294.08
$19,538,350.21
$2,139,496.45
$1,464,958.81
64,921,187.78
$53,259,456.36
$13,889,732.79
$5,917,420.38
$1,075,665.00
6110,904,561.86
$312,919,048.01
$1,368,000.00
$675,000.00
$368,800.00
$2,411,800.00
240,000.00
240,000.00
170,100.00
69,900.00
240,000.00
(1,500.00)
1,500.00
(200.00).
200.00
(19,061.00)
19,061.00
SUMUULk A ,
OAkLAND COUNTY', MICHIGAN
FISCAL YEAR 2003 THIRD QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP) ACTIVITIES
SELF BALANCING AMENDMENTS
ACCOUNT NUMBER
IGF/CP OPERATIONS -
Probate Court
Expenditures
34-403200-40001-2001
34-403200-40001-2074
34-403200-40001-2816
ACCOUNT NAME
Salaries
Fringe Benefits
Fees Guardian Ad Litem
FY 2003
AMENDMENT
$ (45,342.00)
(20,658.00)
66,000.00
Drain Commissioner/52nd District Ct.
Revenue
61-111001-10000-0907
Total Revenue
Expenditures .
61-221001-10000-2001 Salaries
61-211001-10000-2074 Fringe Benefits
Total Expenditures
County Executive - Emergency Response & Preparedness
Expenditures
11-101112-65001-4100 FA Expend. Equip. Exp.
11-101112-65001-4101 Expend. Equip. Exp.
11-101112-65001-4272 Photographic Supplies
11-101112-65001-4252 Expend. Equip. Exp.
11-101112-70001-9154 Computer Equipment
11-101112-65001-9160 Furniture & Fixtures
Total Expenditures
Reimbursement Salaries -
Human Services - Health Division
Expenditures
16-233200-46000-2700 Educational Programs
16-233200-46000-8001 Operating Transfer Out
Total Expenditures
$ (35,000.00)
35,000.00
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2003 THIRD QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP) ACTIVITIES
ACCOUNT NUMBER ACCOUNT NAME
[GEGL,OPERATIONS - SELF BALANCING AMENDMENTS (
Public Services - Community Corrections
Revenue
17-401100-70310-0209 Step Forward
Total Revenues
Expenditures '
17-402200-70310-4336 Testing Materials
Total Expenditures
FY 2003
AMENDMENT
$ 51,000.00
$ 51,000.00
$ 51,000.00
$ 51,000.00
Public Services
Expenditures ,
17-302200-30001-4284
17-302200-300001-6664
17-501200-50001-3114
17-501200-50001-3318
17-501200-50001-6664
17-802200-80001-4284
17-802200-80001-3114
17-802200-80001-3318
17-802200-80001-6664
17-901200-90001-4284
17-901200-90001-6664
17-912000-15000-4284
17-912000-15000-6664
Veterans Sys - Postage
Veterans Sys - Mail Room
MSU Ext. - Mail Handling Svcs
MSU Ext. - Postage Fees
MSU Ext. - Mail room
Animal Control - Postage
Animal Control - Mail Handling Svcs
Animal Control - Postage Fees
Animal Control - Mail Room
Circuit Court - Postage
Circuit Court - Mail Room
Med. Exam - Postage
Med. Exam - Mail Room
Total Expenditures
(415.00)
415.00
$ (2,500.00)
$ (6,000.00)
$ 8,500.00
-
$ (5,053.00)
(775.00)
$ 5,828.00
(100.00)
100.00
$ (1,000.00)
$ 1,000.00
Community & Economic Development
Expenditures
19-210000-13500-2001 Salaries
19-210000-135000-2077 Fringe Benefits - Retirement
19-210000-13500-3324 Printing
19-210000-13500-3348 Professional Services
19-210000-13500-6666 Print Shop
Total Expenditures
$ (12,500.00)
(10,000.00)
(20,000.00)
22,500.00
20,000.00
OAKLAND COUN FY, MIC:1-11LiAN
FISCAL YEAR 2003 'THIRD QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP) ACTIVITIES
ACCOUNT NUMBER ACCOUNT NAME
GF/GP OPERATIONS - SELF BALANCING AMENDMENTS
Planning & Economic Development
Revenue
19-224000-13020-1701 Transfer from IT
Expenditure
19-224000-13020-3348 Professional Services
FY 2003
AMENDMENT
$ 5,000.00
$ 5,000.00
Non-Departmental
Expenditures
90-310000-30500-8003
90-310000-37000-8003
90-210000-95100-9058
90-210000-95200-9007
$ (9,620,616.00)
(3,500,000.00)
9,620,616.00
3,500,000.00
Community Mental Health Authority
Road Commission Tr-Party
Community Mental Health Authority
Road Commission Tr-Party
Total Expenditures
GF/GP OPERATIONS - GENERAL AMENDMENTS
Clerk-Jury Comm - Salaries
Clerk-Jury Comm - Fringe Benefits
ERP - On Call
ERP - Tornado Siren Equipment
Comm. Corr. - Contracted Services
Transfer Out to IT-Jail Data Warehouse
Revenue
21-140100-11000-0705
Expenditures
21-250100-01000-2001
21-250100-01000-2074
11-101112-65001-2009
11-1 01112-65001-9 152
17-402200-70320-2572
90-310000-98636-8001
Clerk/ROD - Mortgages $ 465,174.00
$ 6,528.00
646.00
16,000.00
94,000.00
200,000.00
148,000.00
$ 465,174.00
35,000.00
35,000.00
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2003 THIRD QUARTER BUDGET AMENDMENTS
PROPRIETARY FUND ACTIVITIES
ACCOUNT NUMBER ACCOUNT NAME
'PROPRIETARY FUNDS - SELF BALANCING AMENDMENTS
Drain Equipment Fund (639)
Revenue
61-111317-46500-1103 Vehicle Rental
Total Revenue
FY 2003
AMENDMENT
273,440.00
273,440.00
Expenditures
61-211317-46500-6661 Leased Vehicles 24,700.00
61-311317-46500-8001 Operating Transfer Out 248,740.00
Total Expenditures 273,440.00
Change in Equity
Motorpool Fund (661)
Revenue
13-661001-00010-0635 Leased Equipment
13-661003-00010-1701 Operating Transfer In
Total Revenues
Expenditures
16-661002-00010-3903 Depreciation
16-661002-00010-8005 Change in Fund Equity
24,700.00
248,740.00
273,440.00
24,700.00
248,740.00
273,440.00
FM & 0 - Project Work Order Fund (404)
14-310007-61023-1701 Transfer In from Health Div. (Fund 221) $
14-210007-61023-8005 Change in Fund Equity
Information Technology Fund (686)
Revenues
18-636111-10000-0717 Non-Government Operating
18-636111-10000-0737 OC Departments Operations
43,981.00
11,715.00
55,696.00
t,
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2003 THIRD QUARTER BUDGET AMENDMENTS
PROPRIETARY FUND ACTIVITIES
ACCOUNT NUMBER ACCOUNT NAME
FY 2003
AMENDMENT
PROPRIETARY FUNDS - SELF BALANCING AMENDMENTS
Expenditures
18-636172-95900-3348
18-636113-10000-8001
18-636142-15000-4101
Professional Services
Transfer Out to PEDs
Expendable Equipment Expense
Total
(5,000.00)
5,000.00
55,696.00
55,696.00
26,725
2,557
896
4,067
17,523
365
324
324
1,000
15,154
(9)
(247)
(94)
(494)
(36)
(844)
(81)
(416)
(78)
(211)
(76)
(76)
(36)
(24)
(49)
(211)
(36)
(224)
(256)
(36)
(6,450)
(913)
(35)
(240)
(72)
(108)
(556)
(561)
(66)
(301)
(287)
(220)
(817)
(409)
(328)
(72)
(171)
(18)
(283)
Sc)eJiitJe B
FISCAL YEAR 2003 THIRD QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GFIGP) ACTIVITIES
LIABILITY INSURANCE FUND
FY 2003
ACCOUNT NUMBER DEPARTMENT/DIVISION AMENDMENT
Expenditures
16 201200 10000 6677 Human Servs.- Health Div. Adm
21 210100 10000 6677 Clerk Register of Deeds
22 221120 1000 6677 Treasurer Adm.
41 211000 41700 6677 Prosecuting Attny. Adm. - Gen. Prosec.
43 023101 10000 6677 Sheriff Office - Admin.
51 211000 10000 6677 Board of Comm. Adm.
51 232000 53300 6677 Library Board
51 231000 53000 6677 Bd of Commissioners Research Library
61 211001 10000 6677 Drain Commissioner Adm. GF Adm Exp
90 290000 25000 9006 Budget Task
68,935
11 101112 65001 6677 Emergency Response & Preparedness
11 210100 01000 6677 County Exe.Adm - Gen. Exe Serv.
11 220100 10000 6677 County Exe Auditing - Adm.
11 250100 20000 6677 County Exe. - Corporation Counsel
12 101200 10001 6677 Mgmt. & Budget Adm.
12 240000 44100 6677 Mgmt. & Budget Adm. Equalization Adm
12 401200 40010 6677 Mgmt. & Budget Purch. Adm. - Gen. Procurement
12 601200 10001 6677 Mgmt. & Budget - GE Fiscal Serv. Adm.
12 622200 10001 6677 Mgmt & Budget- Special Revenue Fiscal Serv- Adm
12 623200 10001 6677 Mgmt & Budget - Proprietary Funds Fiscal Serv. Adm
12 701200 30000 6677 Mgmt & Budget Reimbursement - Circuit Ct Collections
12 701200 31000 6677 Mgnnt & Budget- Reimbursement - Family Ct Collections
13 131002 00001 6677 Central Serv. Adm.
13 138502 15100 6677 Central Serv-Materials Mgmt GF
14 210000 10000 6677 Facilities Mgmt. Adm. GF
14 280000 80003 6677 Facilities Mgmt.- Faciilities Eng Proj. Mgmt.
15 101200 10001 6677 Personnel Adm.
15 402200 10001 6677 Personnel Human Resources Adm.
15 501200 10001 6677 Personnel -Empl. Relations Adm
16 121000 10000 6677 Human Serv. Adm.
16 201200 31100 6677 Human Servs.- Health Div. Adm
16 501200 25001 6677 Human Servs. Childrens Village Adm- CV Operations
17 101200 10001 6677 Public Serv. Adm.
17 302200 30001 6677 Public Serv.-Veterans Serv. Adm Client Srv.
17 402200 70001 6677 Public Serv-s. Community Corrections
17 501200 50001 6677 Public Serv.-MSU Ext. Adm.
17 802200 80001 6677 Public Servs. Animal Control Adm
17 912000 15000 6677 Public Servs. Medical Examiner Services
19 210000 10000 6677 Comm & Econ Dev- Adm.
19 210000 13500 6677 Comm & Econ Dev- Solid Waste pin.
19 221000 10000 6677 Comm. & Eco. Dev- Dev. & Plan Adm
20 200000 11000 6677 C&E Dev Workforce Dev. Adm.
21 210100 10000 6677 Clerk - Reg of Deeds - Adm.
22 221120 01000 6677 Treasurer Adm.
32 201200 20001 6677 District Court Div 1 Adm.
32 205200 20006 6677 District Court Div 1 Probation
32 301200 20001 6677 District Court - Div II Adm.
32 305200 20006 6677 District Court Div II Probation
32 401200 20001 6677 District Court Div III Adm.
(46)
(201)
(28)
(2,760)
(1,048)
(1,350)
(46,285)
(96)
(72)
(57)
(56)
(380)
(56)
(1,059)
(68,935)
FISCAL YEAR 2003 THIRD QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP) ACTIVITIES
FY 2003
ACCOUNT NUMBER DEPARTMENT/DIVISION AMENDMENT
Expenditures
32 405200 20006 6677 District Court Div III Probation
32 501200 20001 6677 District Court Div IV Adm.
32 505200 20006 6677 District Court Div IV Probation
34 403200 40005 6677 Probate Ct Estates/Mental Health-Probate Serv. Estates
35 220000 11000 6677 Circuit Court - Business Oper - Adm.
41 211000 41700 6677 Prosecuting Attny. Adm. - Gen. Prosec.
43 023101 10000 6677 Sheriff Office - Admin.
43 023601 33000 6677 Sheriff-Patorl Servs. - Marine
43 023201 10000 6677 Sheriff-Admin Services
43 023301 10000 6677 Sheriff-Corrective Svs. Adm.
51 233000 53500 6677 Bd of Commissioners Law Library
51 211000 10000 6677 Board of Comm. Adm.
51 231000 53000 6677 Bd of Commissioners Research Library
61 211001 10000 6677 Drain Commissioner Adm. GF Adm Exp
NET EFFECT
(300.00)
300.00
0,00
(500.00)
500.00
0.00
SCHEDULE C
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2003 THIRD QUARTER BUDGET AMENDMENTS
INTERFUND AMENDMENTS
ACCOUNT NUMBER
Fringe Benefits Fund
91-250100-10000-2054
91-250100-10100-2076
91-250100-10100-2078
91-250100-10100-2079
91-250100-10100-2080
91-250100-10100-2081
91-250100-10100-2082
91-250100-10100-2084
91-250100-10100-2085
91-250100-10100-2091
91-250100-10100-2098
91-250100:10000-3514
91-250100-10000-2881
91-250100-10000-2916
91-250100-10000-3594
91-250100-10000-2664
91-250100-10000-2682
91-250100-10000-3778
91-250100-10000-3574
91-250100-10000-3254
91-250100-10000-2841
91-250100-10000-2666
ACCOUNT NAME
Retiree Hospitalization General
Group Life
Hospitalization
Social Security
Dental
Disability
Unemployment Insurance
Sick & Annual Leave Cash-Out
Optical
Flex Benefits Plan Payments
Defined Contributions County
Retiree Hospitalization General
Group Life
Hospitalization
Social Security
Dental
Disability
Unemployment Insurance
Sick & Annual Leave Cash-Out
Optical
Flex Benefits Plan Payments
Defined Contributions County
FY 2003
AMENDMENT
$ (20,521,600.00)
(741,500.00)
(24,810,000.00)
(14,913,700.00)
(3,074,400.00)
(1,863,800.00)
(165,000.00)
(1,250,000.00)
(344,800.00)
(466,000.00)
(12,452,800.00)
20,521,600.00
741,500.00
24,810,000.00
14,913,700.00
3,074,400.00
1,863,800.00
165,000.00
1,250,000.00
344,800.00
466,000.00
12,452,800.00
0.00
Fringe Benefits Fund (Corp Counsel)
11-250209-31000-4100 FA Expendable Equipment Expense
11-250209-31000-4101 Expendable Equipment Expense
Fringe Benefits Fund (Training & Development)
15-525678-53000-4100 FA Expendable Equipment Expense
15-525678-53000-4101 Expendable Equipment Expense
To comply with GASB 34 reporting requirements.
SCHEDULE D
FISCAL YEAR 2003 THIRD QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE(GF/GP) ACTIVITIES
BUILDING SPACE ALLOCATIONS
FY 2003
AMENDMENT ACCOUNT NUMBER DEPARTMENT/DIVISION
GFIGP OPERATIONS - SELF BALANCING AMENDMENTS
Expenditures
90 290000 25000' 9006 Budget Task 245,048
11 210100 1000 6631
11 210100 41000 6631
11 210100 42000 6631
11 220100 10000 6631
11 250100 20000 6631
11 101112 65001 6631
12 101200 1000f 6631
12 401200 40010 6631
12 240000 41000 6631
12 240000 44100 6631
12 601200 26003 6631
12 601200 28000 6631
12 601200 27001 6631
12 701200 30000 6631
12 701200 31000 6631
13 131002 1 6631
13 138202 15100 6631
13 138203 12,000 6631
13 138203 15100 6631
13 138502 15100 6631
14 210000 10000 6631
14 280000 80003 6631
15 101200 10001 6631
15 402200 10001 6631
15 501200 10001 6631
16 121000 10000 6631
County Executive/ Admin.
Co. Exec./ Arts, Culture & Film
Co. Exec./Comm.Min.Affr/ S.Oak.Govt.
Auditing
Corporation Counsel
Emergency Response & Preparedness
Management & Budget Administration
Purchasing
Equalization
Equalization
Fiscal Services
Fiscal Services/ Accounting
Mgmt & Budget Accounting
Reimbursement/Circuit
Reimbursement/Family
Central Services Administration
Cafeteria
Mail Room
Record Retention
Property Records
Facilities Management Administration
Facilities Engineering
Personnel Administration
Personnel/ Human Resources
Personnel/Employee Relations
Human Services Administration
(4,336)
(103)
(268)
(2,053)
(3,313)
(2,791)
(176)
(1,735)
193,592
(199,596)
(1,972)
(4,276)
(946)
(1,550)
(1,550)
(171)
(4,997)
(10,076)
161,009
(962)
(494)
(1,068)
(171)
(3,691)
(5,169)
(363)
16 201200 33100 6631 Health Administration (30,264)
16 501200 24010 6631 Childrens' Village/ Unit A (5,752)
16 501200 24020 6631 Childrens' Village/ Unit J (29,234)
16 501200 25040 6631 Childrens' Village/ Unit K (2,491)
16 501200 26030 6631 Childrens' Village/ Unit H (6,082)
16 501200 28050 6631 Childrens' Village/ Unit B (2,666)
16 501200 28060 6631 Childrens' Village/ Unit C (2,666)
16 501200 28070 6631 Childrens' Village/ Unit D (2,666)
16 501200 28080 6631 Childrens' Village/ Unit G (3,987)
16 555200 25050 6631 Childrens' Village School (5,123)
17 101200 10001 6631 Public Services Administration (181)
11, •
FISCAL YEAR 2003 THIRD QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE(GF/GP) ACTIVITIES
BUILDING SPACE ALLOCATIONS
FY 2003
AZ:COUNT NUMBER DEPARTMENT/DIVISION AMENDMENT
17 302200 30001 6631 Veterans' Services (3,767)
17 402200 70111 6631 Community Corrections/Pretrial Serv. (203)
17 402200 70310 6631 Community Corrections (629)
17 402200 70211 6631 Community Corrections/Comm. Based (1,554)
17 501200 50001, 6631 MSU Extension (4,367)
17 802200 80340 6631 Animal Control (7,727)
17 901200 90001 6631 Circuit Court Probation (8,391)
17 901200 90002 6631 Circuit Court Probation (South Office) (7,706)
17 912000 15000 6631 Medical Examiner (16,438)
19 210000 10000 6631 Community & Econ. Devel. Admin. (176)
19 210000 11060 6631 Automation Alley (902)
19 210000 13500 6631 Solid Waste Planning (214)
19 221000 10000 6631 Development & Planning (8,873)
20 200000 11000. 6631 Workforce Development Admin. (1,228)
21 210100 10000 6631 Clerk/Register of Deeds Admin. 15,766
21 220100 1000 6631 County Clerk (6,015)
21 230100 31000 6631 Elections (1,234)
21 240100 11000 6631 Register of Deeds (4,777)
21 250100 1000 6631 Jury Commission (103)
22 221120 1000 6631 Treasurer 1,532
34 101200 31100 6631 Probate Ct/Judicial Adm/Family Judges (4,187)
34 101200 40002 6631 Probate Ct/Judicial Admin/Judicial Serv. (1,448)
34 403200 40005 6631 Probate Ct/Estates/Mental Health (3,203)
35 210000 11000 6631 Circuit Ct/Judicial/Admin. (5,724)
35 220000 11000 6631 Circuit Ct/Business Operations (3,156)
35 220000 12000 6631 JIMS Project (454)
35 230000 21100 6631 Circuit Ct/General Jurisdiction (37,600)
35 230000 22100 6631 Circuit Ct/Assignment (1,838)
35 230000 24000 6631 Circuit Court/Jury Operations (3,717)
35 242000 11000 6631 Circuit Ct/Court Services (244)
35 242000 41000 6631 Circuit Ct/Casework Services (6,315)
35 242000 42000 6631 Circuit Ct/Clinical Services (1,364)
35 242000 43000 6631 Circuit Court/Youth Assistance (2,783)
35 243000 33000 6631 Circuit Ct/Juvenile Support Services (3,540)
35 244000 31100 6631 Circuit Ct/Family Division (8,232)
41 211000 41700 6631 Prosecuting Attorney 1,901
43 23201 42200 6631 Sheriff/Admin. Services (1,106)
43 23301 21400 6631 Sheriff/Law Enforcement Complex 8,766
43 23401 21200 6631 Sheriff/Greenan Bldg. - Inmate Housing (4,228)
43 23401 21300 6631 Sheriffft" Building (2,537)
43 23401 21600 6631 Sheriff/Trusty Camp (5,639)
43 23401 21700 6631 Sheriff/Work Release Facility (11,242)
43 23401 42100 6631 Sheriff's Locker Room (208)
43 23401 42200 6631 Sheriff' g Detention Unit (4,677)
43 23601 33000 6631 Sheriff/Marine Division (3,330)
FISCAL YEAR 2003 THIRD QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE(GF/GP) ACTIVITIES
BUILDING SPACE ALLOCATIONS
ACCOUNT NUMBER
43 23901 41000
43 23901 43100
43 23901 44300
43 23901 44600
51 211000 10000 ,
51 231000 53000
51 233000 53000
51 231000 53100
51 233000 53100
51 232000 53300
51 233000 53300
51 233000 53500
61 211001 10000
90 220000 22000-
90 220000 22000
90 220000 22000
90 220000 22000
90 220000 22000
90 220000 22000
90 220000 22000
90 220000 22000
90 220000 22000
90 220000 22000
DEPARTMENT/DIVISION
6631 Sheriff/Communications
6631 Sheriffs Crime Lab
6631 Sheriffs Fugitive Apprehension Team
6631 Sheriff/NET
6631 Board of Commissioners
6631 Reference Library
6631 Reference Library
6631 Libr/ Vis. & Phys Impared
6631 Libr/ Vis. & Phys lmpared
6631 Law Library
6631 Law Library
6631 Library Board
6631 Drain Commissioner
6009 Courthouse
6012 Courthouse Auditorium
6078 North Office Building
6087 News Media
6093 Public Works Building
6099 Service Center Grounds
6108 Maintenance Building
6114 Administrative Annex ll
6631. Non-Dept/ County Buildings
6632 Central Services Building
Total General Fund/General Purpose Funds
Total
FY 2003
AMENDMENT
(2,189)
(2,691)
(1,157)
(3,539)
(1,474)
138,554
(142,851)
178,829
(184,375)
320,036
(329,962)
2,922
(7,605)
(3,372)
(4,024)
(506)
(121)
(9,499)
(18,026)
(274)
(491)
(17,445)
(4,339)
(245,048)
t
. •
General Fund/General Purpose: Internal Service Allocation Amendment
Information Technology - Fund 636
Third Quarter Amendment
SCHEDULE E
Fund 101 - General Fund, Object 6636
Dept OCA PA
11 101 1 12 65001 Emergency Response & Prepar
11 210100 01000 County Exec Admin
11 210500 01000 Executive Support
11 220100 10000 Auditing Admin
11 250100 20000 Corporation Counsel
12 240000 41000 Equalization Admin
12 401200 40010 Purchasing Admin
12 601200 10001 General Fund Fiscal Services
12 622200 28000 Special Revenue Fiscal Service
12 701200 34000 Reimbursement
13 138201 15100 Support Svs Admin
13 138203 12000 Record Retention & Mail
13 138502 15100 Materials Mgmt
14 210000 10000 Facilities Mgt Admin
• 14 280000 80003 Facilities Engineering
15 402200 10001 Human Resources Admin
17 302200 30001 Veterans Services Admin
17 402200 70111 Comm Corrections Admin
17 501200 50001 MSU Ext OC Admin
17 510200 50240 Natural Science Program
17 802200 80001 Animal Control Admin
17 901200 90001 Circuit Court Probation
17 912000 15000 Med Examiner
19 210000 11060 Comm & Econ Dev Adm
19 221000 10000 Dev & Planning
19 223000 14062 Marketing & Research
19 224000 12020 Planning
21 210100 10000 Clerk/Reg of Deeds Admin
21 220100 01000 County Clerk Admin
21 220100 10000 County Clerk Admin
21 220500 01000 Clerk Vital Statistics
21 220500 40000 Clerk Vital Statistics
21 221000 01000 Clerk Legal Records
21 230100 01000 Elections Admin
21 230100 31000 Elections Admin
21 240100 11000 Register of Deeds Admin
21 250100 01000 Jury Commission
22 221120 01000 Treasurer Admin
32 201200 20001 DC Div I Admin
32 205200 20006 DC Div I Probation
32 301200 20001 DC Div ll Admin
• 32 305200 20006 DC Div II Probation
32 401200 20001 DC Div Ill Admin
32 405200 20006 DC Div Ill Probation
32 501200 20001 DC Div IV Admin
32 505200 20006 DC Div iy Probation
34 101200 40001 PC Judicial/ Admin
34 403200 40005 PC Estates/Mental Hlth
35 210000 11000 Judicial/Admin
35 220000 11000 Business Oper
35 230000 31100 Gen Jurisdiction
35 242000 42000 Court Services
Current Final
Amended Budget Amendment Amended Budget
100,084.00 95,800.00 195,884.00
129,347.00 (12,020.00) 117,327.00
0.00 14,900.00 14,900.00
175,316.00 (86,910.00) 88,406.00
86,779.00 (2,310.00) 84,469.00
1,289,279.00 (404,960.00) 884,319.00
48,019.00 790.00 48,809.00
492,570.00 483,560.00 976,130.00
6,235.00 (6,235.00) 0.00
0.00 3,240.00 3,240.00
19,121.00 (15,040.00) 4,081.00
9,814.00 6,215.00 16,029.00
0.00 8,130.00 8,130.00
62,240.00 (44,220.00) 18,020.00
25,516.00 (3,470.00) 22,046.00
243,566.00 75,775.00 319,341.00
62,676.00 (5,235.00) 57,441.00
226,489.00 (5,230.00) 221,259.00
162,599.00 (36,490.00) 126,109.00
8,812.00 (4,200.00) 4,612.00
50,574.00 (5,260.00) 45,314.00
96,615.00 2,930.00 99,545.00
0.00 .131,425.00 131,425.00
0.00 24,950.00 24,950.00
419,993.00 31,360.00 451,353.00
0.00 18,500.00 18,500.00
0.00 2,300.00 2,300.00
15,872.00 (15,872.00) 0.00
110,534.00 (110,534.00) 0.00
(13,671.00) 29,410.00 15,739.00
168,842.00 (168,842.00) 0.00
0.00 38,615.00 38,615.00
209,676.00 (189,550.00) 20,126.00
49,950.00 (49,950.00) 0.00
0.00 43,090.00 43,090.00
369,585.00 76,240.00 445,825.00
35,594.00. (11,600.00) 23,994.00
581,757.00 (206,830.00) 374,927.00
281,614.00 39,860.00 321,474.00
21,932.00 (10,700.00) 11,232.00
125,979.00 8,340.00 134,319.00
0.00 5,500.00 5,500.00
274,194.00 (980.00) 273,214.00
0.00 3,280.00 3,280.00
212,226.00 23,530.00 235,756.00
39,270.00 (11,720.00) 27,550.00
96,159.00 (54,600.00) 41,559.00
202,670.00 (49,410.00) 153,260.00
8,270.00 6,270.00 14,540.00
54,884.00 41,750.00 96,634.00
198,209.00 336,660.00 534,869.00
0.00 28,100.00 28,100.00
Fund 101 - General Fund,
PCA
33000
31200
41100
10000
20000
45000
10000
53000
53300
Dept
35
35
41
43
43
43
51
51
51
51
61
90
OCA
243000
244000
211000
023101
023301
023901
211000
231000
232000
233000
211001
290000
Judicial Support
Family Div Admin
Prosecutor Admin
Sheriffs Office Adm
Corrective Sys Adm
Technical Sys Adm
Commissioners & Admin
Research Library
Law Library
53500 Library Board
10000 Drain Commissioner Admin
25000 Non Dept/IT Development 6030
Total Fund 101 - General Fund
Object 6636
Fund, Object 6636
33100 Health Div Admin
33100 Health Central Support
75110 Jail Health Program
67000 Environmental Health
33100 Personal & Prey Health
46000 CHPIS
54600 Clinic
46000 Field Nursing
Total Fund 221 - Health Fund
Fund 221 - Health
16 201200
16 211200
16 215200
16 220200
16 231200
16 233200
16 234200
16 236200
Fund 293 -Juvenile Maintenance Fund, Object 6636
16 501200 25001 thildrens Village Admin
35 242293 61000 Juv Maintenance
Total Fund 293 - Juvenile Maintenance
Fund 101 - General Fund,
101112
131002
138502
280000
402200
501200
121000
402200
210000
220100
101200
403200
023101
023201
023301
023401
023601
023901
65001
00001
15100
80003
10001
10001
33100
70111
13500
10000
40002
40005
10000
10000
20000
20000
30000
40000
11
13
13
14
15
15
16
17
19
21
34
34
43
43
43
43
43
43
32,880.00
550.00
2,800.00
2,320.00
(15,360.00)
15,250.00
120.00
49,330.00
1,930.00
550.00
(31,690.00)
31,690.00
7,920.00
19,960.00
705.00
3,840.00
10,630.00
(133,425.00)
0.00
32,880.00
1,002.00
2,800.00
17,610.00
44,701.00
15,250.00
120.00
72,162.00
3,990.00
550.00
44,052.00
31,690.00
8,897.00
19,960.00
705.00
3,840.00
10,630.00
643,861.00
954,700.00
Current
Amended Budget
134,053.00
65,061.00
606,977.00
0.00
2,247,021.00
0.00
91,858.00
97,406.00
46,072.00
8,159.00
114,627.00
1,850,787.00
12,021,211.00
Final
Amendment Amended Budget
39,530.00 173,583.00
(5,950.00) 59,111.00
34,330.00 641,307.00
1,070.00 1,070.00
294,760.00 2,541,781.00
7,725.00 7,725.00
(10,690.00) 81,168.00
(29,190.00) 68,216.00
22,770.00 68,842.00
(270.00) 7,889.00
66,370.00 180,997.00
(205,606.00) 1,645,181.00
283,201.00 12,304,412.00
1,140,852.00
0.00
1,632.00
140,276.00
0.00
0.00
2,020.00
2,641.00
1,287,421.00
145,977.00
. 49,221.00
195,198.00
(225,650.00)
1,100.00
(525.00)
(41,500.00)
9,210.00
2,370.00
(1,370.00)
(665.00)
(257,030.00)
23,050.00
(49,221.00)
(26,171.00)
915,202.00
1,100.00
1,107.00
98,776.00
9,210.00
2,370.00
650.00
1,976.00
1,030,391.00
169,027.00
0.00
169,027.00
Total Information Technology Fund (636) 13,503,830.00 0.00 13,503,830.00
Telephone Communications - Fund 675
Third Quarter Amendment
Object 6675
Emergency Response & Prepar
Central Sys Admin
Materials Mgrnt
Facilities Engineering
Human Resources Admin
Empl Relations Admin
Human Sys Admin
Comm Corrections Admin
Comm & Econ Dev Adm
Clerk's Office
PC Judicial/ Admin
PC Estates/Mental Hlth
Sheriffs Office Adm
Admin Services
Corrective Sys Adm
Corrective Sys Satellites
Patrol Services
Technical Sys Adm
0.00
452.00
0.00
15,290.00
60,061.00
0.00
0.00
22,832.00
2,060.00
0.00
75,742.00
0.00
977.00
0.00
0.00
0.00
0.00
777,286.00
954,700.00
1
UNCOLLECTABLE HOME IMPROVEMENT LOANS
CASE # HOMEOWNER OUTSTANDING BALANCE ADDRESS
8281 Schronak $9,900 633 N Washington, Clawson 48017
8433 Leece $11,980 713 E Sherman, Holly 48442
8460 Jones* $12690 23784 Dave, Hazel Park 48030
_. 8560 Norton $7,700 1312 E Meyers, Hazel Park 48030
8603 Mongeau $13,200 660 Jewell, Ferndale 48220
8828 Johnson/Caruso $13,184 10221 Coming, Oak Park 48237
8967 Douglas $15,805 21240 Westhampton, Oak Park 48237
9197 Behnke $4,500 23183 Tawas, Hazel Park 48030
1702 Nacy $7,175 ,1891 Henbert, W Bloomfield 48324
1854 Obremski $5,810 26146 Barrington, Madison Hts 48071
- 1885 Wood $6,177 23339 Carlisle, Hazel Park 48030
2226 Czechowski $6,754 1785 Pointe Dr, Commerce Twp 48382
2245 Miorana $4,934 28245 Edward, MadisonHts 48071
2483 Power $4,900 10250 Elizabeth Lk Rd, Milford 48042
2507 McDonald $7,700 :667 Bowers, Clawson 48017
2549 Derring $6,990 350 E Elmwood, Leonard 48038
2634 Miller $7,190 4146 CumMIngs, Berkley 48072
2977 Uplager $8,710 25716 Del, Madison Hts 48071
2978 Clare $3,280 3731 Navarra, Davisburg 48019
3028 Hurt $9,757 357W Meyers, Hazel Park 48030
3112 Jones* $7,438 23784 Davey, Hazel Park 48030
3120 Gray $7,656 21900 Ridgedale, Oak Park 48237
3253 McCall $7,700 21332 Parksidei, Femdale 48220
3572 Shannon $7,125 14440W Nine Mlle, Oak Park 48237
'4269 Walters $9,214 8223 Tindall, Davisburg 48350
4500 Caskey $17,281 117 Maudlin, Novi 48377
4984 Felt $12,223.10 6043 North Bay, Clarkston 48346
5157 Branum $12,000 1041 E Elza, Hazel Park 48030
5179 Barnes $15,815 1283 E Rowland, Madison Hts 48071
5287 Howell $13,200 1605 E Elza, Hazel Park 48030
5451 Betz " $12,357.34 934 Harvard, Berkley 48072
5878 Cobb $18,125.00 26676 Hales, Madison Hts 48071
•
32 TOTAL AMOUNT DUE $306,249
-
Writeoffs/excel
SCHEDULE F
• ,
Page 1 of 3
FY 2003 BUDGET AMENDMENTS
FY 2003 BUDGET AS ADOPTED $ 364,086,237.00
3
BUDGET AMENDMENTS
M.R. #02239 - 1011012002
Sheriff Dept. - Use of Forfeited Funds (SOCR -0
M.R. #02244 - 10/1012002
Circuit Court - Position Deletions (LLEBG) and Use of Mediation Funds
M.R. #02265 - 10/24/2002
Facilities & Operations - Security Design
M.R. #02248 - 1012412002
Clerk/Register of Deeds - Vital Records Imaging
M.R. #02254 - 10/24/2002
Circuit Court - Ude of Mediation Funds for Furniture
M.R. #02282 - 11121/2002
Human Services - MDEQ Reimbursement Agreement
M.R. #02310 - 1211212002
Sheriff Dept. - Lyon Township Contract
M.R. #02311 - 12/12/2002
Sheriff Dept - Oxford Township Contract
M.R. #02312 - 12112/2002
Sheriff Dept. - Springfield Township Contract
M.R. #02286 - 1211212002
Sheriff Dept. - Highland Township Contract
M.R. #02313 - 1211212002
52nd District Court - Michigan Sobriety Court
M.R. #02319 - 12/12/2002
FY 2002 Year End Report
Encumbrances of Purchase Orders
Use of Crimp Funds
I.T. HIPAA Project
Northwest Highway Extension
Clerk Counter Renovations
3,440.00
$ 33,690.00
$ 132,000.00
722,000.00
$ 142,360.00
$ 761,144.00
$ 65,367.00
$ 66,160.00
$ 74,860.00
$ (30,366.00)
$ 75,000.00
$ 2,252,083.87
121,213.00
200,000.00
2,000,000.00
77,000.00
M.R. #02321- 12/12/2002 $ 339,490.00
Human Services - Increase Fee Schedule
M.R. #02287 - 12/12/2002 $ 41,850.00
Sheriff Dept. - Use of Forfeited Funds
M.R. #02327 - 12/12/2002 $ 275,000.00
Sheriff Dept. - Use of Forfeited Funds for Armored Vehicle
TOTAL AMENDED BUDGET AS OF 12/31/2002 (1ST QUARTER) $ 371,438,528.87
MR. #03043 - 03/06/2003 $ 1,361,946.00
Phase I budget Task
M.R. #03028 - 03/06/2003
Sheriff Dept. - Use of Forfeited Funds for Tasers
M.R. #03057 - 03/2012003
Sheriff Dept. - Oakand Township Contract Amendment
M.R. #03058 - 03/20/2003
Sheriff Dept. - Brandon Township Fire Dispatch Contract
M.R. #03060 - 0312012003
West Nile Fund Disbursement Policy
$ 145,000.00
45,267.00
8,750.00
$ 500,000.00
TOTAL AMENDED BUDGET AS OF 3/31/2003 (2ND QUARTER) $ 373,499,491.87
M.R. #03066 - 04117/2003
Sheriff Dept. - Use of Forfeited Funds for Auto Theft Conference
M.R. #03079 - 04/17/2003
Emergency Response - Local Law Enforcement Block Grant
M.R. #03080 - 04/17/2003
Emergency Response - Hazardous Materials Grant Funding
M.R. #03083 - 04/17/2003
FY 2003 First Quarter Forecast
Fire Records Management System
Senior Citizen Prescriptions
Prior Year Carry Forwards
Jail Data Warehouse
M.R. #03091 - 04117/2003
Community & Economic Development - North O.C. Household
Hazardous Waste Consortium
3,000.00
(2,092.00)
$ 15,259.00
$ 91,950.00
40,591.00
621,118.00
97,000.00
$ 358,200.00
MR. #03082 - 05/08/2003 $ 34,000.00
M&B - Equalization Office Remodeling & Computer Purchase
a t Page 2 of 3
Page 3 of 3
7,184.00
6,000.00
$ 51,600.00
$ 16,250.00
1,400.00
M.R. #03103 - 0510812003
M&B - Equalization Services with Bloomfield Twp.
M.R. #03094 - 05/08/2003
52nd District Court - Division II - Community Service Garden Program
M.R. #03095 - 0510812003
Sheriff - Michigan Renassance Festival Contract
KR. #03124 - 0512912003
Clerk/Register of Deeds - Passsport Acceptance Facility
M.R. #03128 - 06/12/2003
Sheriff - Dispatch Serives for City of Lake Angelus
TOTAL AMENDED BUDGET AS OF 06/30/03 (3RD QUARTER) $ 374,840,951.87
TOTAL 252 $ 607,079.00
It+
Interoffice
MEMORANDUM
151
to:
cc:
from:
re:
date:
Nancy Fournier, Fiscal Services
Judi Lockhart, Reimbursement
Joyce Raczka, Reimbursement
Inmate Waived Report
July 11,2003
Submitted for your review is the Inmate Report for 2003 for the Months of Jan, Feb and
Mar.
Number of Amount Waived
Accounts
Jan 03 046421 CZ 70 $ 165,938.00
Feb 03 047186 CZ 84 . $ 248,607.00
Mar 03 047948 CZ 98 $ 192,534.00
From the desk of....
Joyce Raczka
Reimbursement
1200 N Telegraph Road
Pontiac, Michigan 48343
R3 Te1:248-858-7368
fax:248-975-4288
TOTAL 226 $ 498,337.00
Interoffice
MEMORANDUM
•&;;Ie
Ara
to:
cc:
from:
re:
date:
Nancy Fournier, Fiscal Services
Judi Lockhart, Reimbursement
Joyce Raczka, Reimbursement
Inmate Waived Report
July 11,2003
Submitted for your review is the Inmate Report for 2003 for the Months of Apr, May and Jun.
Number of
Accounts
Amount Waived
79 Apr 03 048682 CZ $ 173,058.00
May 03 049471 CZ 73 , $ 134,772.00
Jun 03 050163 CZ 74 $ 190,507.00
From the desk of....
Joyce Raczka
Reimbursement
1200 N Telegraph Road
Pontiac, Michigan 48343
Tel:248-858-7368014
fax:248-975-4288
0.00%
0.00%
0.00%
1,500.00 1,500.00
33,259.00 33.259.00
74,000.00 74,000.00
2,213,268.00 2.263,266.00
325,000.00 325,000.00
12,500.00 12,500.00
75,000.00 75,000.00
0.00%
0.00%
0.00%
50,000.00 2.26% - Favorable due to amendments to contracts for Cities. Villages and Townships (CVIS) for additional services.
0.00%
0.00%
0.00%
1,500.00
18,000.00
74,000.00
2,206,082.00
325,000.00
12,500.00
85,000.00
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL
SPECIAL REVENUE AND PROPRIETARY FUNDS
BUDGET
AS
ADOPTED
BUDGET
AS
ADJUSTED
AMOUNT
FY 2003 FAVORABLE/
FORECAST (UNFAVORABLE) PERCENT
PROPERTY TAXES
2002 Tax Levy
NET CURRENT PROPERTY TAX
OTHER TAXES
Delinquent Tax - Prior Years
Trailer Tax
TOTAL PROPERTY AND OTHER TAXES
$ 205,290,050.00 $ 205,290,050.00 $ 203,550,050.00 $ (1,740,000.00) -0.85% - Based on revised estimates. See offset under the Treasurer's revenue favorability.
205,290,050.00 205,290,050.00 $ 203,550,050.00 (1.740,000.00) -0.85%
$ 705,000.00 $ 705,000.00 $ 705,000.00 $
95,000.00 95,000.00 95,000.00
$ 800,000.00 $ 800,000.00 $ 800,000.00
$ 208,090,050.00 $ 206,090,050.00 $ 204.350,050.00 (1,740,000.00) -0.84%
BUDGETED RECEIPTS OTHER THAN TAXES
GENERAL FUND - INTER-GOVERNMENTAL
(STATE AND FEDERAL) & NON-CHARGES FOR SVCS
Non-Dept - Outside Agencies (Inter-Gov. Prog. Rev.) 1.884,718.00 $ 1,884,718.00 $ 1,884,718.00 0.00%
Non-Dept - Indirect Cost Recovery $ 7,589,054.00 8 7,589,054.00 $ 7,589,054.00
Non-Dept - Outside Agencies (Inter-Gov. Gen. Reimb. Rev.) $ 30,913,400.00 30,913,400.00 $ 32,482,900.00 $
0.00%
1,549,500.00 5.01% - Fay. Cigarette Tax Distribution $130,000, (Unfav.) Convention Facility Tax. ($80,500) and fay. State Revenue
Sharing $1,500,000.
County Exec Admln - ERP (Fed Grant & Inter-Gov. Gen Relmb $
Community Corrections - Court Services (Inter-Gov. Gen. Reim $
153,552.00 153,552.00 $ 153,552.00
403,000.00 $ 413,000 00 $ 464,000.00
0.00%
51,000.00 12.35% - Fav. due to increase in activity for Step Forward & WAM programs, offset by discontinued CLUB EM & Virtual
Reality programs. A budget amendment is recommended.
Workforce Development (Fed. Grant)
Treasurer (Special Assessments)
Circuit Court (Inter-Gov. Gan. Relmb. Rev)
District Courts Divs. I-IV (Inter-Gov. Gen. Reimb. Rev)
Sheriff - Admin. Svcs (Inter-Gov. Gen. Rev.)
Sheriff - Correct. Svcs (Fed. Grant)
Sheriff- Patrol Svcs (Inter-Gov. Gen. Reimb.)
TOTAL GENERAL FUND BUDGETED RECEIPTS
STATE! FEDERAL & NON-CHARGES FOR SVCS
$ 1,075,665.00 1.075,665.00 $ 1.075,665.00
61,000.00 $ 61,000.00 $ 61,000.00
17,950.00 8 17,950.00 $ 17,950.00
2.711.00 S 2,711.00 $ 2,711.00
$ 25,000.00 $ 25,000.00 $ 25,000.00
$ 250,000.00 $ 250,000.00 S 250,000.00
$ 200,000.00 200,000.00 $ 200,000.00
$ 42,578,050.00 $ 42,586,050.00 $ 44,186,550.00 $ 1,600,500.00 3.78%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
CHARGES FOR SERVICES (Inc. Transfers)-
GENERAL FUND
County Executive Administration
Emergency Response & Preparedness
Auditing
Equalization
Reimbursement Division
Materials Management - Auction
Support Services - Admin (Vending/Cafeteria)
FIRSTREVids 1 08/26/2003
• COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL
'SPECIAL REVENUE AND PROPRIETARY FUNDS
BUDGET BUDGET AMOUNT
AS AS FY 2003 FAVORABLE/
ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT
Facades Engineering 25,000.00 25,000.00 25,000.00 0.00%
Human Resources 800,00 800.00 18,800.00 18,000.00 2250.00% - Relmbuniement from Mediation Funds for Intern salaries.
MSU Extension- Oakland County 74,000.00 74,000.00 84,000.00 (10,000.00) -13.51% - Unfav, due to smaller class size as a result of limited space for current programs.
Medical Examiner 138,000.00 138,000.00 147,000.00 8,000.00 8.52% - Fey, due to new program initiated by judges ordering offenders (i.e., OM's) to take tour of Med. Exam. facility.
Animal Control 833,385.00 833,385.00 833,385.00 0.00%
Comm. & Econ Dev. - Admin 324,450.00 682,650.00 472,650.00 (210.000) -30.76% - Budget reflects full year of NO HAZ Program. Actual implementation occurred later. Unfav. Variance offset by fay.
expenditure budget
Planning and Economic Dev. Serv 175,000.00 175,000.00 130,000.00 (45,000.00) -25.71% - Lower map sales due to transition to digital products.
County Clerk 2,246,000.00 2,246,000.00 2,081,800.00 (164,200.00) -7.31% - Unfav largely due to non forfeiture of bond and surety bonds, lower collection of motion fees, civil action entry fees,
and lower marriage licenses Issued.
Elections 17,800.00 17,800.00 31,000.00 13,200.00 74.16% - Fay. Due to Nominating Filing Forfeiture, Bd. Of Canvasser Svc. Fee, and
- Election Filing Fees exceeding budget
Register of Deeds 10,983,800.00 11,300,050.00 18,885,850.00 7,585,800.00 67.13% - Increase in Mortgage and Recording Fee revenue due to Increase in refinancing activity.
Treasurer 4,488,029.00 4,488,029.00 5,208,229.00 720,200.00 16.05% - Fey. Due to TIFFA/DDA recovery, Industrial Facilities Tax, and Tax Statements, due to increasing level of industrial
development in Oakland County.
Circuit Court - Gen. Fund 4,078,293.00 4,279,343.00 4,481,943.00
District Courts (Divs. I - IV) 10,385,831.00 10,907,401.00 11,193,801.00
Probate Court 524,100.00 524,100.00 535,900.00
Prosecutor 249,369.00 227,500.00 227,500.00
Sheriffs Office 15,800.00 49,550.00 99,550.00
Administrative Services 1,000.00 9,100.00 22,100.00
Corrective Services 4,099,700.90 4,599,700.00 5,217,700.00
202,800.00 4.73% - Fay, due to chgs. In assessment procedures increased Cost rev. & Psych Eval. Fee Incr.
286,400.00 2.63% - Fay due to St Law Cost & Defense Atty & DCU Filing Fee revenue receipts over budget.
11,800..00 2.25% - Fay clue to Defense Atty. Fees receipts over budget
0.00%
50,000.00 100.91% - Increase In Social Security Incentive Payments $23,000 and DNA Testing Fees $2,000.
13,000.00 142.86% - Increase in Mileage reimbursement.
618,000.00 13.44% - Increase in inmate Board and Care $98,000, Deferred Offender $500,000 and Reimb. Salanes$20.000
Corrective Services - Satellites
Patrol Services
1,574,800.00 1,574,800.00 1,815,800.00 241,000.00 15.30% - Increase in Board and Care $200,000 and Special Deputy Contracts $41,000.
23,982,452.00 24,800,340.00 25,125,340.00 325,000.00 1.31% - Increased In Sheriff Special Deputies $200,000 and Reimbursement of Salaries for Dream Cruise $125,000
Technical Services
Board of Commissioners
Library Board
Drain Commissioner
656,727.00 673,317.00 686,317.00
8,000.00 8,000.00 6,300.00
187,021.00 187,021.00 187,021.00
566,493.00 566,493.00 878,075.00
13,000.00 1.93% - Increase in Dispatch Services $10,000 and Photostats $3,000.
(1,700.00) -21.25% - Decrease In per diem reimbursements.
0.00%
311,582.00 55.00% - Fay - Reimb. General $85,000 ISO 9000 cost spread to projects. Reimb. Salaries $240,000 cost spread to projects.
A budget amendment is recommended. Urdav - Reimb Personal Mileage ($14,000).
TOTAL CHARGES FOR SERVICES $ 68,337,932.00 $ 71,121,904.00 $ 81,159,585.00 $ 10,037,882.00 14.11%
GENERAL FUND
MISCELLANEOUS REVENUE (Non-Department)
Sundry $ 2,302,380.00 $ 2,302,380.00 $ 2,302,380.00 0.00%
Investment Income 7,670,000.00 7,657,908.00 4,387,908.00 (3,300,000.00) -43.04% - Reflects lower than expected returns on Investments due to decreased Interest rates
$ 9,972,380.00 $ 9,970,288.00 $ 6,670,288.00 $ (3,300.000.00) -33.10% -
Prior Yeats Balance/Reserve for Transfer $ 16,469,748.00 $ 23,358,703.87 $ 23,358,703.87 0.00%
2 08/26/2003 FIRSTREV.xls
FY 2003
FORECAST
BUDGET
AS
ADJUSTED
BUDGET
AS
ADOPTED
$ 343,448.160.00 $ 353,126,995.87 $ 359,725,177.87 $ 8,598,182.00
$ $.$4$04.00
239,800.00
3,532,923.00
109,898.00
15,000.00
S 9,363,964.00
239,800.00
4,400,000.00
109,696.00
15,000.00
$ $0$0.71$X0
$ 239,800.00
4,400,000.00
logAgem
15,000.00
AMOUNT
FAVORABLE/
(UNFAVORABLE) PERCENT
0.00%
0.00%
(887,077.00) -19.71% - (Unfav.) Michigan Dept. of Community Heatth State payments, offset by decrease in expenditures.
0.00%
0.00%
TOTAL GENERAL FUND RESOURCES
BUDGETED RECEIPTS- GENERAL PURPOSE
GOVT STATE AND FEDERAL (Outside Agencies)
Child Care Subsidy
Juv. Maint. - Refund School Meals
Health State Subsidy -
Health Grants State
State Match - Foster Care
TOTAL BUDGETED RECEIPTS - GEN. PURPOSE
GOVT STATE AND FEDERAL (Outside Agencies)
$ 14,155,215.00 8 14,128,460.00 $ 13,261,383.00 $ 0.00%
CHARGES FOR SERVICES - GENERAL PURPOSE
Health Division
Circuit Court - Juvenile Maintenance
Children's Village
0.00%
0.00% - Unfav due to reduction in cases of assessed Gov't Benefit Board and Care
-8.91% - (Unfav)'due to delay of Secure Detention Facility and reduction in referrals of Out County Board and Care, offset by
decrease in expenditures.
TOTAL CHARGES FOR SERVICES
GENERAL PURPOSE
OPERATING TRANSFERS
TOTAL AVAILABLE RESOURCES
GENERAL FUND 1GENERAL PURPOSE
Less Operating Transfers (Out)
NET GFIGP RESOURCES
$ 6,484,862.00 $ 7,585,496.00 ' 7,200,498.00 $ (385,000.00) -5.08%
S 405,233,943 00 S. 414,187,665.55 $ 419,533,770.55 $ 5,346,105.00 1.29%
$ (41,147,706.00) $ (39,346,713.68) $ (39,346,713.68) $ 0.00%
$ 384,086,237.00 $ 374,840,951.87 $ 3B0,187056.87 5,346,105.00 1.43%
$ 41,147,706.00 $ 39,346,713.68 $ 39,346,713.68 0.00%
2,032,140.00
1,030,000.00
3,422,722.00
3,132,774.00
1,030,000.00
3,422,722.00
3,132,774.00
950,000.00
3,117,722.00
(80,000.00)
(305,000.00)
Ck)
FIRSTREVids 3 081261200
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL
SPECIAL REVENUE AND PROPRIETARY FUNDS
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER REPORT
EXPENDITURES
CIRCUIT COURT
AMOUNT
ADOPTED AMENDED FY 2003 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCE.
Judicial Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Business Division
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$5,721,595.00 $6,075,443.00 $5,681,543.00 $393,900.00 6.48% - Turnover. .
45,067.00 111,732.52 108,132.52 $3,600.00 3.22% - Fay due to delay In start of Special Proj., and personal mileage.
206,426.00 255,317.77 250,117.77 $5,200.00 2.04% - Fay due to reduced rates Telephone Communications.
$5,973,088.00 $8,442,493.29 $6,039,793.29 $402,700.00 6.25%
$2,043,505.00 $1,930,604.41 $1,810,604.41 $120,000.00 6.22% - Turnover.
88,900.00 194,387.35 154,387.35 40,000.00 20.58% - Fay due to travel and conference, personal mileage, and expendable equipment.
314,313.00 337,651.90 385,051.90 (27,400.00) -8.11% - Unfav. Due to Info Tech Operations, partially offset by telephone communications.
$2,424,718.00 $2,462,643.66 $2,330,043.68 $132,800.00 5.38%
General Jurisdiction Division
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Family Division/Juvenile Malnt
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$1,860,786.00 $1,853,959.00 81,736,059.00
11,498,341.00 10,841,517.97 10,597,517.97
1,875,967.00 2,009,772.50 2,330,872.50
$15,235,094.00 $14,705,249.47 $14,664,249.47
811,501,762.00 $11,205,115.32 $10,531,315.32
8,579,534.00 8,817,508.84 8,585,008.84
1,706,093.00 1,721,809.17 1,836,409.17
$21,787,389.00 $21,544,433.33 $20,752,733.33
$21,127,848.00 $21,065,121.73 $19,759,521.73
20,189,842.00 19,765,146.68 19,445,046.68
4,102,799.00 4,324,551.34 4,582,251.34
$117,900.00 6.36% - Turnover.
244,000.00 2.25% - Fay Defense Atty. Fees, Juror Fees and Mileage, partially offset by Visiting Judge &
Expendable Equipment.
(320,900.00) -15.97% - Unfav, due to info Tech Oper usage, partially offset by Telephone Communications.
$41,000.00 0.28%
$673,800.00 6.01% - Turnover.
32,500.00 0.38% - Fay. Defense Atty fees, Transcripts, Wraparound., partially offset by Private institutions.
85,400.00 4.96% - Fay. due to Telephone Communications, CLEWS, & Equipment Rental.
$791,700.00 3,67%
$1,305,800.00 '-
320,100.00
(257,700.00)
6.20%
1.62%
-5.96%
$45,420,289.00 $45,154,819.75 $43,786,819.75 $1,368,000.00 3.03%
A8/1 3/2003
FY 2003 THIRD QUARTER REPORT
EXPENDITURES
DISTRICT COURT
AMOUNT
ADOPTED AMENDED FY 2003 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
District Court Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$265,038.00 $265,038.00 $144,838.00 $120,200.00 45.35% - Turnover.
70,300.00 70,300.00 64,600.00 5,700.00 8.11% - Fay. Due to contracted court reporter services not needed.
0.00 0.00 0.00 0.00 0.00% -
$335,338.00 $335,338.00 $209,438.00 $125,900.00 37.54%
Division 1 - Novi
Controllable Personnel $3,173,531.00 $3,238,160.55 $3,034,260.55 $203,900.00 6.30% - Turnover.
Controllable Operating 788,869.00 903,202.45 943,202.45 (40,000.00) -4.43% - Unfav. due to Def. Atty Fees amended, partially offset by Tmg Psych Exam & lower bank digs.
Non-Controllable Operating 526,876.00 561,473.89 462,073.89 99,400.00 17.70% - Fav Telephones, and projected CLEMIS assessment.
. . . . -
$4,489,276.00 $4,702,836.89 $4,439,536.89 $263,300.00 5.60%
Division 2- Clarkston
Controllable Personnel $1,083,842.00 $1,228,990.00 $1,170,490.00 $58,500.00 4.76% - Turnover.
Controllable Operating 492,083.00 499,324.79 523,024.79 (23,700.00) -4.75% - Unfav due to incr use of bank chgs, Interpreter fees, Tmg Psych Exam, & postage.
Non-Controllable Operating 184,549.00 231,342.43 219,042.43 12,300.00 5.32% - Fay Telephones, and projected CLEMIS assessment.
$1,760,474.00 $1,959,657.22 $1,912,557.22 $47,100.00 2.40%
Division 3 - Rochester Hills
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Division 4- Troy
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$2,869,558.00 $2,865,973.12 82,796,073.12 $69,900.00 2.44% - Turnover.
853,434.00 857,061.00 832,061.00 25,000.00 2.92% - Fay due to decr. use of office supplies & travel & conf, partially offset by Bank chgs.
396,554.00 452,057.34 418,957.34 33,100.00 7.32% - Fav Telephones, and projected CLEWS assessment
$4,119,546.00 $4,175,091.46 $4,047,091.46 $128,000.00 3.07%
$1,948,453.00 $1,939,825.02 $1,905,925.02 $33,900.00 1.75% - Turnover.
529,558.00 533,863.34 537,963.34 (4,100.00) -0.77% - Unfav due to incr bank chgs do to use of credit cards, Interpreter fees, & equip. rental.
433,941.00 443,618.29 362,718.29 80,900.00 18.24% - Fav Telephones, and projected CLEMIS assessment.
$2,911,952.00 $2,917,306.65 $2,806,606.65 $110,700.00 3.79%
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$9,340,422.00 $9,537,986.69 $9,051,586.69
2,734,244.00 2,863,751.58 2,900,851.58
1,541,920.00 1,688,491.95 1,462,791.95
$13,816,588.00 $14,090,230.22 $13,415,230.22
$486,400.00
(37,100.00)
225,700.00
$675,000.00 4.79%
5.10%
-1.30%
13.37%
8/13/2003
XL,
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER REPORT
EXPENDITURES
PROBATE COURT
• AMOUNT
ADOPTED AMENDED FY 2003 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCE 3
Judicial/Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Judicial Support •
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$1,772,699.00 $1,772,699.00 $1,691,599.00 81,100.00 4.57% - Turnover.
0.00 4,607.59 4,607.59 0.00 0.00%
456,812.00 509,984.45 362,684.45 147,300.00 28.88% - Fay. Info Tech Oper & Telephones.
$2,229,511.00 $2,287,291.04 $2,058,891.04 $228,400.00 9.99%
$1,901,208.00 $1,864,939.29 $1,675,839.29 $189,100.00 10.14% - Turnover.
654,981.00 656,719.00 723,319.00 (66,600.00) -10.14% Unfav due to Fees Guardian Ad Litem, a budget amendment is requested.
443,538.00 452,149.84 434,249.84 17,900.00 3.96% - Fair. Info Tech Oper & Micrographics, partially offset by Telephones.
$2,999,727.00 $2,973,08.13 $2,833,408.13 $140,400.00 4.72%
$3,673,907.00 $3,637,638.29 $3,367,438.29 $270,200.00 7.43%
654,981.00 661,326.59 727,926.59 (66,600.00) -10.07%
900,350.00 962,134.29 796,934.29 165,200.00 17.17%
$5,229,238.00 $5,261,099.17 $4,892,299.17 $368,800.00 7.01%
8/14/2003
51
1,977,880.81
0.00
1,932,280.81
0.00
$80,000.00 3.91% Turnover.
0.00 0.00%
0.00 0.00%
$80,000.00 3.91%
$0.00 •
0.00
0.00
$0.00 0.00%
0.00%
0.00%
0.00%
$335,000.00
230,000.00
45,600.00
0.00
2.63%
11.01%
2.31%
08/13/2003
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
EXPENDITURES
PROSECUTING ATTORNEY
AMOUNT
ADOPTED AMENDED FY 2003 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfer Out
$2,457,955.00 $2,457,955.00 $2,362,955.00 $95,000.00 • 3.87% Turnover.
2,064,290.00 2,018,737.10 1,788,737.10 230,000.00 11.39% Fay. Court Transcripts $10,000, Expert Witness Fees & Mileage $10,000,
Extradition Expense $60,000, Filing Fees $20,000, Professional Services
$20,000, Special Prosecuting Attorneys $10,000 and Witness Fees & Mileage
$50,000 due to case requirements. Fay. Library Continuations $30,000 and
Printing $20,000.
1,947,696.00 1,977,880.81 1,932,280.81 45,600.00 2.31% Fay. Micrographics & Reproduction $1,600 and Telephone
0.00 0.00 0.00 Communications $44,000 based on charges through June
$6,469,941.00 $6,454,572.91 $6,083,972.91 $370,600.00 5.74%
Litigation
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$7,005,438.00 $6,850,172.00 $6,690,172.00
59,824.00 59,824.00 59,824.00
0.00 0.00 0.00
$160,000.00
0.00
0.00
2.34% Turnover.
0.00%
0.00%
$7,065,262.00 $6,909,996.00 $6,749,996.00 $160,000.00 2.32%
Warrants
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Appellate
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfer Out
$2,089,131.00 $2,045,829.00 $1,965,829.00
2,758.00 2,758.00 2,758.00
0.00 0.00 0.00
$2,091,889.00 $2,048,587.00 $1,968,587.00
$1,452,585.00 $1,382,958.13 $1,382.958.13
7,291.00 7,291.00 7,291.00
0.00 0.00 0.00
$1,459,876.00 $1,390,249.13 $1,390,249.13
$13,005,109.00 $12,736,914.13 $12,401,914.13
2,134,163.00 2,088,610.10 1,858,610.10
1,947,698.00
0.00
$17,086,968.00 $16,803,405.04 $16,192,805.04 $610,600.00 3.63%
Administrative Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Corrective Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Operating Transfer Out
Corrective Services-Satellites
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Operating Transfer Out
Patrol Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$2,702,744.00
$1,104,429.00
801,706.00
535,886.00
$2,442,021.00
$20,322,209.00
6,835,221.00
6,696,387.00
27,000.00
$33,880,817.00
$14,027,767.00
370,500.00
956,152.00
0.00
$15,354,419.00
$27,245,907.00
262,025.00
4,726,585.00
$34,959,842.95
$13,813,538.00
380,174.58
956,152.00
0.00
$15,149,864.58
$27,387,423.00
761,988.82
4,735,338.00
Operating Transfer Out 58,226.00 58,226.00 0.00% 0.00
Technical Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Operating Transfer Out
$32,234,517.00
$8,991,369.00
736,663.00
1,815,464.00
0.00
$32,942,975.82
$9,024,020.00
739,033.86
1,789,368.26
8/26/2003
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
EXPENDITURES
SHERIFF'S DEPARTMENT
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2003 FAVORABLE
FORECAST UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Sheriffs Office
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$1,286,053.00 $1,286,053.00 $1,218,853.00
533,374.00 538,794.80 538,794.80
883,317.00 866,694.00 886,694.00
$67,200.00 5.23% Turnover.
0.00%
0.00%
$2,891,541.80
$1,108,271.16
915,112.59
527,838.00
$2,551,221.75
$20,322,209.00
7,827,818.75
$2,624,341.80 $67,200.00 2.50%
$1,108,271.16
915,112.59
527,838.00
$2,551,221.75 $0.00 0.00%
$20,322,209.00 $0.00 0.00% - Tumover fay. $317,000, offset by Unfav. OT($1,081,000), Hol OT ($218,100).
7,800,818.75 27,000.00 0.34% Fay. Out-County Prisoner Costs due to reduction in Out-County Prisoner placements.
$34,838,042.98 $27,000.00 0.08%
$13,813,538.00 $484,900.00 3.37% - Turnover fay. $736,200, offset by Unfav. OT ($175,400) and Hol OT ($95,900).
380,174.58 0.00%
956,152.00 0.00%
0.00 0.00%
$15,149,864.58 $464,900.00 3.07%
$26,639,523.00 $747,900.00 2.73% - Turnover fay. $400,000 Offset by OT $450,100 offset by Unfav. Hol OT ($102,200.)
761,988.82 0.00%
4,435,338.00 300,000.00 6.34% - Sheriff Aviation Fund operations projected to be fay. in Controllable Personnel $94,000,
Interest Expense $6,000 and Depreciation Expense $200,000.
0.00% -
0.00%
0.00%
6,782,815.20 6,688,015.23 0.00%
27,000.00 27,000.00 0.00%
$31,895,075.82 $1,047,900.00 3.18%
$8,490,820.00 $533,200.00 5.91% - Fav. Turnover $403,800, OT $119,200 and Hot. OT. $10,200.
739,033.86 0.00% -
1,789,368.26 0.00% -
0.00 0.00% -
—4A
./tffpartment Total
Controllable Personnel
Controllable Operating
$11,543,496.00
$72,977,734.00
9,539,489.00
$11,552,422.12 $11,019,222.12 $533,200.00 4.62%
$72,941,514.16 $71,593,214.16 $1,813,200.00 2.49%
11,162,923.40 11,135,923.40 27,000.00 0.24%
wovain I I %Jr WAISI6J,Z•Y
FY 2003 THIRD QUARTER FORECAST REPORT
EXPENDITURES
SHERIFF'S DEPARTMENT
AMOUNT
ADOPTED AMENDED FY 2003 FAVORABLE
BUDGET BUDGET FORECAST UNFAVORABLE PERCENT
Non-Controllable Operating 15,613,791.00 15,658,205.46 15,263,405.49 300,000.00 1.92%
Operating Transfer Out 27,000.00 85,226.00 85,226.00 0.00 0.00%
$98,158,014.00 $99,847,869.02 $98,077,769.05 $2,140,200.00 2.14%
EXPLANATION OF SIGNIFICANT VARIANCES
8/26/2003
$424,832.00
585,300.00
113,372.00
0.00
427,032.00
421,237.12
196,619.50
24,312.00
$424,832.00 $
561,937.12
201,519.50
24,312.00
($2,200.00)
140,700.00
4,900.00
0.00
$143,400.00 $1,123,504.00 $1,212,600.82 $1,069,200.62
$2,068,475.00 $2,044,779.89 $1,978,579.89 $66,200.00
787,598.00 789,843.40 2,093,743.40 (1,303, 900.00)
946,625.00 976,000.90 917,100.90 58,900.00
0.00 0.00 0.00 0.00
Elections
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfers Out
Register of Deeds
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfers Out
-0.52% - Overtime usage higher due to increase in election activity.
25.04% - Fay. election supplies, due to timing between purch. and usage of supplies
2.43% Fav due to decrease rates for Info Tech Oper. offset by fav. Mail Room.
0.00%
11.83%
3.24% - Turnover •
-165.08% - Unfav due to incr. mortgage activity for doc. Processing; see rev offset.
6.03% - Fay Micrographics based on lower rates.
0.00%
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
EXPENDITURES
CLERK/REGISTER OF DEEDS
ADOPTED
BUDGET
AMOUNT
FAVORABLE
UNFAVORABLE) PERCENT
AMENDED
BUDGET
FY 2003
FORECAST EXPLANATION OF SIGNIFICANT VARIANCES
$599,771.00
50,350.00
244,926.00
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfers Out
$623,574.41 $ 565,274.41
65,288.45 74,488.45
179,205.97 73,700.00
0.00
9.35% - Turnover
-14.09% - Unfav. Misc. Capital Outlay expense as renovation expanse higher than
anticipated. printing of Cnty. Directory due to size increase.
29.14% - Fay due to decrease rates for Info Tech Oper. and Telephones.
$58,300.00
(9,200.00)
252,905.97
0.00
13.04% $895,047.00 $941,768.83 $818,968.83 $122,800.00
$227,500.00
(12,100.00)
108,100.00
County Clerk (Vital Stets & Legal
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfers Out
Rec's)
$3,881,104.00
204,378.00
716,049.00
$3,880,318.07
215,549.26
971,999.80
799,000.00
$3,652,818.07
227,649.26.
863,899.80
799,000.00
5.86% - Turnover
-5.61% - Unfav. due to underbudgeted office supplies, offset by lower Ct. Transcripts.
11.12% Fay, due to lower rates for Info Tech Oper, offset by highter IT Imaging Oper.
5.51% $4,801,531.00 $5,866,865.13 $5,543,365.13 $323,500.00
$3,802,698.00 $3,810,624.19 $4,989,424.19 ($1,178,800.00) • -30.93%
$7,377.00
2,384.00
68,533.00
Jury Commission
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$7,377.00 11,377.00 ($4,000.00) -54.22% - Unfav. budget is understated due to misclassification of positions, a
a budget amendment is recommended.
6,036.84 5,336.84 700.00 11.60% Fay. Due to Postage usage shifted to Mail Room.
90,364.41 111,664.41 (21,300.00) -23.57% - Unfav. due to incr Mailings & Print Shop use, offset by IT Oper & Telephone.
$78,294.00 $103,778.25 $128,378.25 ($24,600.00) -23.70%
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfers Out
$6,981,559.00
$1,630,010.00
$2,089,505.00
$0.00
$6,980,879.37
$1,638,655.07
$2,492,790.58
$823,312.00
$6,635,079.37 $345,800.00
$2,822,455.07 ($1,183,800.00)
$2,268,490.58 $224,300.00
$823,312.00 $0.00
4.95%
-72.24%
9.00%
08/2712003 $10,701,074.00 $11,935,637.02 $12,549,337.02 ($613,700.00) -5.14%
ADOPTED
BUDGET
AMENDED
BUDGET
$2,562,356.00
238,625.00
1,159,544.31
$2,313,956.00
$195,725.00
$963,444.31
$248,400.00
42,900.00
196,100.00
$3,757,270.00
$3,757,270.00
$3,960,525.31
$3,960,525.31
$3,473,125.31
$3,473,125.31
$487,400.00 12.31%
$487,400.00 12.31%
Division Total
Department Total
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
EXPENDITURES
COUNTY TREASURER
AMOUNT
FY 2003 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Ilearioaar*IwItewaso........•nn•••n•nn ••n•n•••n•nn••n••••n•••••nn•
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operatin
$2,652,540.00
236,061.00
868,669.00
9.69% - Turnover.
17.98% - Fay, due to postage shifted to mail room, offset by unfav. Twp & City
Treasurer Bonding insurance requirements.
16.91% - Fay, due to lower rates for Info Tech and Telephone Communications.
08/12/2003
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Library Board
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
08/13/2003
.41
COUNTY OF OAKLAND
FY2003 THIRD QUARTERLY FORECAST
EXPENDITURES
BOARD OF COMMISSIONERS
ADOPTED AMENDED
BUDGET BUDGET
AMOUNT
FY 2003 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIAHCES
.10••••••••n•n•••nn•nn••n•••••n•••••••••••••••nnMoMeI.0
$1,906,037.00 $1,906,037.00 $1,839,859.00 $66,178.00
488,629.00 438,304.26 438,304.26 0.00 0.00%
321,355.00 293,318.26 $293,318.26 0.00 0.00%
$2,716,021.00 $2,637,659.52 $2,571,481.52 $66,178.00 2.51%
$986,936.00 $945,197.92 $945,197.92 $0.00 0.00%
790,112.00 790,112.00 790,112.00 0.00 0.00%
948,664.00 942,381.98 942,381.98 0.00 0.00%
$2,725,712.00 $2,677,691.90 $2,677,691.90 $0.00 0.00%
$2,892,973.00 $2,851,234.92 $2,785,056.92 $66,178.00 2.32%
1,278,741.00 1,228,416.26 1,228,416.26 0.00 0.00%
1,270,019.00 1,235,700.24 1,235,700.24 0.00 0.00%
$5,441,733.00 $5,315,351.42 $5,249,173.42 $66,178.00 1.25%
3.47% Turnover
Drain Commissioner
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$2,793,704.00
461,798.00
880,585.00 1,010,526.16 969,716.16
$ (25,813.00)
(98,073.00)
40,810.00
$2,594,802.00 $ 2,620,615.00
633,358.01 731,431.01
Transfer Out
Total
Department Total
56,165.00 $0.00 0.00%
$4,377,927.17 ($83,076.00) -1.93%
$4,192,252.00 $4,294,851.17 $4,377,927.17 ($83,076.00) -1.93%
56,165.00
$4,192,252.00
56,165.00
$4,294,851.17
08/25/2003
381
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER REPORT
EXPENDITURES
DRAIN COMMISSIONER
AMOUNT
ADOPTED AMENDED FY 2003 FAVORABLE
BUDGET BUDGET FORECAST UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
-0.99% - Unfav -Overtime ($25,813) Soil Erosion O.T. to meet inspection requ.rements.
-15.48% - Unfav - Prof. Ser. ($34,700), Recognition Events ($52,000) for ISO 9000 certification.
Unfav - Printing Supplies ($12,000) used outside vendor for new letterhead.
4.04% - Fay. - Radio Communications $66,670 not using radio system. Fav - Drain
Equipment $62,000 because of decrease in charges for copies being directly
charged to General Fund. Fay- Print Shop $9,138 used outside vendor for letterhead.
Unfav - Info. Tech. Oper. ($80,373) for data warehouse and GIS charges.
Unfav - Convenience Copier ($12,943) because allocation under estimated.
Unfav - Mail Room ($3,681) due to under estimated budget item.
SIG.= ===== =============.. ========
$2,184,627.00 $2,015,740.00 $1,989,687.00
301,954.00 301,988.15 301,988.15
439,620.00 439,254.73 439,254.73
62,926,201.00 $2,756,982.88 $2,730,929.88
$518,903.00 $530,603.00 $546,603.00 ($16,000.00) -3.02% - On Call (Unfav.) as usage higher than anticipated. A budget amendment is recommended.
575,150.00 1,639,051.85 1,733,051.85 (94,000.00) -5.74% - (Unfav.) due to reduction for the FY 2003 Tornado Siren Program
263,486.00 288,494.48 388,494.48 (100,000.00) -34.66% - I.T. Operations and Telephone Communications higher than anticipated.
$1,357,539.00 $2,458,149.33 $2,668,149.33 ($210,000.00) -8.54%
$1,159,050 $1,084,041.00 $1,064,041.00 $20,000.00 1.84% - Favorable due to staff utilization of Administrative Leave.
30,680.00 26,509.60 26,509.60 0.00%
266,977.00 268,434.99 268,434.99 0.00%
$1,456,707.00 $1,378,985.59 $1,358,985.59 $20,000.00 1.45%
$1,752,068.00 $1,738,484.55 $1,658,484.55 $80,000.00 4.60% - Favorable due to staff utilization of Administrative Leave
55,027.00 51,187.72 45,587.72 5,600.00 10.94% - Favorable due to less usage of Mileage $1,400, Reporter & Steno fees $2,500,
and Court Costs $1,700..
238,341.00 248,157.01 236,157.01 12,000.00 4.84% - Favorable Telephone Communications.
1.29% - Turnover.
0.00%
0.00%
$26,053.00
$26,053.00 0.94%
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
EXPENDITURES
COUNTY EXECUTIVE
AMOUNT
ADOPTED AMENDED FY 2003 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Emergency Response & Preparedness
Controllable PersOnnel
Controllable Operating
Non-Controllable Operating
Auditing
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Corporation Counsel
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$2,045,436.00 $2,037,829.28 $1,940,229.28 $97,600.00 4.79%
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$5,614,648.00 $5,368,868.55 $5,258,815.55
962,811.00 2,018,737.32 2,107,137.32
1,208,424.00 1,244,341.21 1,332,341.21
$110,053.00 2.05%
($88,400.00) -4.38%
($88,000.00) -7.07%
$7,785,883.00 $8,631,947.08 98,698,294.08 ($66,347.00) -0.77%
C.411)0
4000°P 08/19/2003
Purchasing
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Equalization
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfer Out
Fiscal Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Reimbursement
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfer Out
$943,574.00 $910,468.00 $875,468.00 $35,000.00 3.84% - Turnover
31,742.00 35,050.89 31,050.89 4,000.00 11.41% - Favorable travel and conference and mileage due to less than anticipated travel.
145,559.00 160,834.66 160,834.66 0.00%
$1,120,875.00 $1,106,353.55 $1,067,353.55 $39,000.00 3.53%
$6,527,098.00 $6,403,818.00 $5,903,818.00 $500,000.00 7.81% - Turnover.
378,265.00 361,515.20 161,515.20 200,000.00 55.32% - Favorable due to shifts in workload for better operational efficiencies.
1,638,213.00 2,470,316.51 2,470,316.51 0.00%
82,000.00 82,000.00 0.00%
$8,543,576.00 $9,317,649.71 $8,617,649.71 $700,000.00 7.51%
$5,125,918.00 $4,834,491.60 $4,819,491.60 $15,000.00 0.31% - Turnover.
168,547.00 153,547.00 104,547.00 $49,000.00 31.91% - Favorable due to training related reductions. .
924,207.00 1,697,452.74 2,097,452.74 ($400,000.00) -23.56% - . (Unfav) I.T. Operations, due to increased data warehouse activitiy for financial
- reporting.
$6,218,672.00 $6,685,491.34 $7,021,491.34 ($336,000.00) -5.03%
$1,924,959.00 $1,911,897.50 $1,861,897.50 50,000.00 . 2.62% - Turnover.
69,327.00 70,062.00 70,062.00 0.00%
552,185.00 583,980.56 583,980.56 0.00%
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfer Out
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
EXPENDITURES
MANAGEMENT AND BUDGET
AMOUNT
ADOPTED AMENDED FY 2003 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
$300,740.00 $300,740.00 $285,740.00 $15,000.00 4.99% - Turnover
11,100.00 21,221.55 21,221.55 0.00%
9,031.00 8,954.00 8,954.00 0.00%
$320,871.00 $330,915.55 $315,915.55 $15,000.00 4.53%
$2,546,471.00 $2,565,940.06 $2,515,940.06 $50,000.00 1.95%
$14,822,289.00 $14,361,415.10 $13,746,415.10 $815,000.00 4.28%
658,981.00 641,396.64 388,396.64 253,000.00 39.45%
3,269,195.00 4,921,538.47 5,321,538.47 (400,000.00) -8.13%
0.00 82,000.00 82,000.00 0.00 0.00%
$18,750,465.00 $20,006,350.21 $19,538,350.21 $468,000.00 2.34%
EXPLANATION OF SIGNIFICANT VARIANCES
410
08/13/200
0.00%
5.20%
-5.23%
07/30/2003
111
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
EXPENDITURES
CENTRAL SERVICES
AMOUNT
ADOPTED AMENDED FY 2003 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administrative
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Support Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$185,325.00 $165,325.00 $165,325.00 $0.00
3,075.00 3,075.00 1,975.00 1,100.00
12,846.00 14,244.98 21,244.98 (7,000.00)
$181,248.00 $182,844.96 $188,544.98 ($5,900.00)
$1,180,318.00 $1,139,828.00 $1,139,828.00 0.00
43,919.00 48,920.01 45,420.01 1,500.00
858,775.00 733,803.48 765,903.48 (32,100.00)
0.00%
35.77% - Reduction in overall expenses.
-49.14% - Increase In Internal Service expenditures.
-3.23%
0.00% -
3.20% - Reduction In overall expenses.
-4.37% - Increase in Micrographic charges for one time storage program.
- A budget amendment Is recommended.
or
$2,083,010.00 $1,920,351.49 $1,950,951.49 ($30,600.00) $0.00
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$1,345,841.00 $1,304,953.00 $1,304,953.00
46,994.00 49,995.01 47,395.01
871,621.00 748,048.44 787,148.44
$0.00
2,800.00
($39,100.00)
$2,264,256.00 $2,102,998.45 $2,139,498.45 ($36,500.00)
=========
$0.00
Facilities Engineering
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfers Out
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST
EXPENDITURES
FACILITIES MANAGEMENT
Administration
Controllable Personnel
Controllable Operating
AMOUNT
ADOPTED AMENDED FY 2003 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
$315,746.00 $315,746.00 $315,746.00 $0.00 0.00%
22,975.00 5,525.00 5,525.00 0.00 0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfers Out
83,742.00 83,714.00 39,514.00 44,200.00 52.80% - Fay Information Technology Operations based on charges through June.
$422,463.00 $404,985.00 $360,785.00 $44,200.00 10.91%
$942,286.00 $891,673.00 $859,673.00 $32,000.00 3.59% - Turnover $23,400 and fay Overtime due to reduced project activity.
206,650.00 118,240.00 94,640.00 23,600.00 19.96% - Fay Professional Services due to reduced project activity.
95,249.00 95,860.81 95,860.81 0.00 0.00%
54,000.00 54,000.00 54,000.00 0.00 0.00%
$1,298,185.00 $1,159,773.81 $1,104,173.81 $55,600.00 4.79%
$1,258,032.00 $1,207,419.00 $1,175,419.00 $32,000.00 2.65%
229,625.00 123,765.00 100,165.00 23,600.00 19.07%
178,991.00 179,574.81 135,374.81 44,200.00 24.61%
54,000.00 54,000.00 54,000.00 0.00 0.00%
$1,720,648.00 $1,564,758.81 $1,464,958.81 $99,800.00 6.38%
08/13/2003
Administration
Controllable Personnel
Controllable Operating
$298,171.00
10,219.00
$290,934.00 $286,934.00
10,219.00 6,519.00
15,958.63 14,958.63 Non-Controllable Operating 10,656.00
$319,046.00 $317,111.53 $308,411.53
Human Resources
Controllable Personnel $2,322,056.00
Controllable Operating 428,278.00
Non-Controllable Operating 490,130.00
$2,290,326.09 $2,248,926.09 $41,400.00
461,739.04 409,689.04 $52,050.00
826,664.14 854,664.14 ($28,000.00)
1.81%
11.27%
-3.39%
Employee Relations
Controllable Personnel
Controllable Operating
$676,724.00
225,278.00
$674,209.88 $672,809.88
225,278.00 216,728.00
08/13/2003,&
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
EXPENDITURES
PERSONNEL
ADOPTED AMENDED
BUDGET BUDGET
AMOUNT
P12003 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$4,000.00 1.37% - Turnover
$3,700.00 36.21% - Controllable Operating usage of Outside Printing $1,000, Travel & Conf. $2,000
Workshops & Meetings $400, and Office Supplies $300 lower than anticipated.
$1,000.00 6.27% - Mailroom fay. $200 and Print Shop fay. $800 due to lower usage than anticipated. •
$8,700.00 2.74%
- Due to turnover and reorganization per MR #03139
- Expense less than usual for recruiting $35,000, ID Supplies $5,000 and Office
Supplies $7,400 due to hiring freeze.
- IT Operating expense unfav. ($60,000) due to system upgrade; Print Shop unfav.
($6,300) due to higher usage than anticipated; Offset by fay. Telephone
Communications $38,800 and Equipment Rental $500, as cost lower than
anticipated.
$3,240,464.00 $3,578,729.27 $3,513,279.27 $65,450.00 1.83%
Non-Controllable Operating 196,677.00 193,959.00 209,959.00
$1,400.00 0.21% - Due to turnover and reorganization per MR #03139.
8,550.00 3.95% - Service Mememtos unfav. ($14,500) due to significant number of retirees participating
in the Early Retirement Program; Offset by less than anticipated usage for Travel
and Conference $12,000 and Court ReporterServices $2,200. Employee Medical
Exams fay $9,000 due to hiring freeze.
(16,000.00) -8.25% - Telephone Communications unfav. ($15,100) and Print Shop unfav. ($1,800) as
due to higher usage than anticipated; Offset by fav. Mailroom costs $900 from
lower usage.
$1,098,679.00 $1,093,446.88 $1,099,496.88 ($6,050.00) 10.55%
Department Total
Controllable Personnel $3,296,951.00
Controllable Operating 663,775.00
Non-Controllable Operating 697,463.00
$3,255,469.97 $3,208,669.97
697,236.04 632,936.04
1,036,581.77 1,079,581.77
$45,800.00 1.44%
64,300.00 9.22%
(43,000.00) -4.15%
$4,658,189.00 $4,989,287.78 $4,921,187.78 $68,100.00 1.35%
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$170,432.00
10,248,903.00
16,682.00
$170,432.00
7,591,778.00
16,677.00
$170,432.00
7,591,778.00
16,677.00
0.00%
0.00%
0.00%
$1,500,000.00
180,300.00
200,000.00
$31,418,580.99 $29,538,280.99 $31,431,911.00 $1,880,300.00 5.98%
$10,393,300.00
3,482,621.00
2,445,721.00
$9,981,300.93
3,533,084.88
2,427,902.56
$10,231,300.93
3,583,084.88
2,477,902.56
$250,000.00
50,000.00
50,000.00
Children's Village
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfer Out
2.44% - Turnover
1.40% - Favorable due to delay in completion of Secure Detention Facility.
2.06% - Favorable Telephone and Radio Communications due to delay in completion of
Secure Detention Facility.
08/13/2063
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
EXPENDITURES
HUMAN SERVICES
AMENDED
BUDGET
ADOPTED
BUDGET
AMOUNT
FY 2003 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$0.00 0.00%
Health
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfer Out
$10,436,017.00 $7,778,887.00 $7,778,887.00
$24,289,936.00 $23,802,607.37 $22,302,607.37
3,747,974.00 4,082,121.80 3,901,821.80
3,519,736.82 3,319,736.82
14,115.00 14,115.00
6.30% - Turnover.
4.42% - Favorable due to decrease in expenditure offset by decrease of Michigan Dept. of
Community Health Revenue.
5.68% - Favorable Telephone and I.T. Operations
0.00%
3,394,001.00
$16,321,642.00 $16,292,288.37 $15,942,288,37 $350,000.00 2.15%
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfer Out
$34,853,668.00
17,479,498.00
5,856,404.00
0.00
$34,204,340.30
15,256,984.68
6,014,316.38
14,115.00
$32,454,340.30
15,026,684.68
5,764,316.38
14,115.00
$1,750,000.00
230,300.00
250,000.00
0.00
5.12%
1.51%
4.16%
$58,189,570.00 $55,489,756.36 $53,259,456.36 $2,230,300.00 4.02%
Public Services - Admin.
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$152,111.00
7,800.00
6,602.00
$152,111.00
7,800.00
8,802.00
$152,111.00
7,800.00
6,602.00
$0.00
0.00
0.00
0.00%
0.00%
0.00%
COUNTY OF OAKLAND
FY 2003 THIRD QUARTERLY FORECAST
EXPENDITURES
PUBLIC SERVICES
AMOUNT
ADOPTED AMENDED FY 2003 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$166,513.00 $166,513.00 $168,513.00 $0.00 0.00%
Veteran's Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Community Corrections
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Operating Transfer Out
MSU Ext. - Oakland County
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Medical Examiner
Controllable Personnel
Controllable Operating
Non-Controllable Operating
ise8-%
$1,561,112.00 $1,440,428.00 $1,255,656.00 $184,772.00 12.83% - Turnover
298,400.00 298,400.00 $221,400.00 77,000.00 25.8% - Fay. Soldier Burial $75,000 dike to lower than anticipated number of qualifying soldier deaths;
Service Mementos $2,000 lower than anticipated use.
248,525.00 248,522.76 $238,522.76 10,000.00 4.02% - Fay. Telephone Communications lower than anticipated.
$2,108,037.00 $1,987,350.76 $1,715,578.76 $271,772.00 13.68%
$2,555,131.00 $2,557,149.50 $2,467,149.50 $90,000.00 3.52% - Turnover.
849,935.00 823,543.00 $1,074,543.00 (251,000.00) -30.46% - Unfav. ($200,000) from increase in PRC contracted expenses due to reduced State funding,
which impacts the General Fund because of higher usage as an alternate to incarceration.
A budget amendment is recommended. Unfav. Testing Material ($110,000) offset by fay.
Material and Supplies $48,000, Office Supplies $11,000 which also include a budget amendment
to increase revenue for the Step 'Forward Program.
415,930.00 499,605.22 $545,505.22 (46,000.00) -9.21% - Unfav. Telephone Communications due to purchase of nextel telephones. To be reviewed
0.00 250.00 $250.00 0.00 by IT including Radio Communication transfer to Telephone Communications.
$3,620,996.00 $3,880,447.72 $4,087,447.72 ($207,000.00) -5.33%
$872,663.00 $651,141.00 $646,141.00 $5,000.00 0.77% - Turnover
129,978.00 131,478.00 $103,278.00 28,200.00 21.45% - Fav. Car Allowance (MSU employees) $4,000 due to lower than anticipated costs; Mail
Handing $2,500 and Postage Fees $6,000 due to elimination of outside service now using
Mail Room; Recognition Events $4,3000 due to lower participation in various events; Rent
$4,400 due to office space available within MSU other class rooms; Workshops & Meetings
$4,000 due to lower than anticipated attendance; Data Processing Supplies $3,000 due to
lower than anticipated expenses. ,
424,694.00 424,038.17 $430,038.17 (6,000.00) -1.41% - Unfav. Print Shop due to increased usage.
$1,227,335.00 $1,206,657:17 $1,179,457.17 $27,200.00 2.25%
$2,502,735.00 $2,458,189.00 $2,456,189.00 $0.00 0.00% -
$452,912.00 452,972.00 $463,272.00 ($10,300.00) -2.27% - Unfav. Professional Services ($10,000) due to large number of cases that require use of
contracted toxicology lab testing; Transporting Service ($10,000) due to higher caseload;
Film & Processing ($8,300) due to higher film and developing costs. Fay. Medical Supplies
$18,000 lower than budgeted.
$747,251.00 770,348.23 $886,848.23 ($116,500.00) -15.12% - Unfav. Micro & Reprod. Budget understated ($1,500); info Tech Operations costs
($130,000) due to cost higher than anticipated. Fay. Telephone Communications $15,000
lower than anticipated.
$3,702,898.00 $3,679,509.23 $3,806,309.23 ($126,800.00) -3.45% 08125/2003 - -
Animal Control
ControHable Personnel
Controllable Operating
Non-Controllable Operating
Circuit Court Probation
Controllable Personnel
Controllable Operating
Non-Controllable Operating
40
08/25/2003
COUNTY OF OAKLAND
FY 2003 THIRD QUARTERLY FORECAST
EXPENDITURES
PUBLIC SERVICES
AMOUNT
ADOPTED AMENDED FY 2003 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$1,475,622.00 $1,442,281.00 $1,442,281.00 60.00 0.00% -
120,043.00 122,996.25 $116,168.25 6,828.00 5.55% - Fay. Travel & Conference $1,000; Mail Handling Service $5,053 and Postage Fees $775 due
due to previously mailed through post office, now handled by County Mailroom. Budget
amendment is In process for Mall Handling Service and Postage Fees.
531,579.00 536,438.98 6527,438.98 9,000.00 1.68% - Fay. Radio Communication $9,000 lower than anticipated.
$2,127,244.00 $2,101,716.23 $2,085,888.23 $15,828.00 0.75%
$0.00
. .
$0.00 $0.00 0.00 0.00%
42,639.00 42,668.02 $41,668.02 1,000.00 2.34% - Fay. Office Supplies $3,000 due to lower usage than anticipated, offset by use of interpreter
Fees ($2,000), not currently in the budget.
819,528.00 824,870.66 6806,870.66 18,000.00 2.18% - Fay. Convenience Copier $9,000 and Telephone Communication $9,000 lower than
anticipated.
$862,167.00 $867,538.68 $848,538.68 $19,000.00 2.19%
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Operating Transfer Out
$8,919,374.00 $8,699,299.50 $8,419,527.50 $279,772.00 3.22%
1,901,707.00 1,879,857.27 2,028,129.27 (148,272.00) -7.89%
3,194,109.00 3,310,326.02 3,441,826.02 (131,500.00) -3.97%
250.00 250.00 0.00
$14,015,190.00 $13,889,732.79 $13,889,732.79
ST.
$0.00 0.00%
$23,300.00 3.88% - Turnover
241,000.00 32.15% - Fav. Professional Services $210,000 for the North Oakland County Household Hazardous Waste
Collection Program, which will continue into FY 2004 (reimbursement of program costs from
participating local municipalities follows program costs); Note: Revenues are projected to be lower for
same reason. Fay. Legal Services $12,500 not anticipated to be expended for the Solid Waste
Program; fay. Printing $20,000 (offset by charges to the Print Shopline item); fay. Membership, Dues,
& Publications $16,000 due to reduced membership costs; and fay. Advertising costs $5,000; partially
offset by Professional Services ($22,500) for Solid Waste Program activities.
Unfav. Information Technology Operations ($24,900) based on charges through June and Print
Shop ($20,000) for Solid Waste Program (offset by fay. Outside Printing). A Budget amendment
is recommended to transfer funding for printing costs from Controllable Operating to Non-
Controllable Operating.
$604,330.00
406,245.00
$603,581.07
749,558.00
$580,261.07
508,558.00
94,860.00 123,590.84 168,490.84 (44,900.00) -38.33%
$1,105,435.00 $1,476,709.91 $1,257,309.91 $219,400.00 14.86%
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
EXPENDITURES
COMMUNITY AND ECONOMIC DEVELOPMENT
ADOPTED
BUDGET
AMOUNT
AMENDED FY 2003 FAVORABLE
BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Planning and Economic Development Services
Controllable Personnel $2,919,604.00 $2,847,850.08 $2,780,850.06 $87,000.00
Controllable Operating 609,375.00 677,718.68 670,316.68 7,400.00
Non-Controllable Operating 828,253.00 835,793.73 879,693.73 (43,900.00)
2.35% - Turnover
1.09% - Fay outside Postage due to charges to Mail Room line item.
-5.25% - Unfav. Information Technology Operations ($60,100) based on charges through June, partially
offset by fay. Telephone Communications $15,000.
$4,357,232.00 $4,361,360.47 $4,330,860.47 $30,500.00 0.70%
Community and Home Improvement
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$0 $0 $0 0.00
335,250.00 335,250.00 329,250.00 6,000,00
0 0 0 0.00
1.79% - Fay. Grant Match based on FY 2003 Consolidated Grant Award for CDBG, HOME, and ESG
Programs.
$335,250.00 $335,250.00 $329,250.00 $6,000.00 1.79%
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfer Out
$3,523,934.00
1,350,870.00
923,113.00
0.00
$3,451,411.13 $3,361,111.13 $90,300.00 2.62%
1,782,524.68 1,508,124.68 254,400.00 14.43%
959,384.57 1,048,184.57 (88,800.00) -9.26%
0.00 0.00 0.00 0.00%
4.15% $5,797,917.00 $8,173,320.38 $5,917,420.38 $255,900.00
===== ============= =============
08/13/20#7
$1,075,665.00 $1,075,665.00 $1,075,665.00 $0.00 0.00%
$0.00 0.00%
$0.00 0.00%
$0.00 0.00%
$644,415.00 $644,415.00
325,656.00 325,656,00
105,594.00 105,594.00
$644,415.00
325,656.00
105,594.00
Workforce Development
Controllable Personnel
Controllable Operating
Non-Controllable Operating
FY
COMMUNITY AND
COUNTY OF OAKLAND
2003 THIRD QUARTER FORECAST REPORT
EXPENDITURES
ECONOMIC DEVELOPMENTNVORKFORCE DEVELOPMENT
ADOPTED AMENDED
BUDGET BUDGET
AMOUNT
Pi' 2003 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfer Out
$644,415.00
325,656.00
105,594.00
0.00
$644,415.00
325,656.00
105,594.00
0.00
$644,415.00
325,656.00
105,594.00
0.00
$0.00 0.00%
0.00 0.00%
0.00 0.00%
0.00 0.00%
$0.00 0.00% $1,075,665.00 $1,075,665.00 $1,075,665.00
Lig08/13/2003
19,800.00 $ 19,800.00 $ 29,100.00 $ (9,300.00)
116,886.54 $ 116,886.54
154,697.00 154,697.00 S 154,697.00
15,000.00 15,000.00 $ 15,000.00
341,114.00 • $
1,201,000.00 1,201,000.00 $ 1,201,000.00
1,500,000.00 - $
40,591.00 $ 51,091.00 (10,500.00)
500,000.00 $ 500,000.00
9,279,502.00 13,120,616.00 13,120,616.00 -
$ 12,511,113.00 $ 15,168,590.54 $15,188,390.54 (19,800.00)
3,192,325.00 $ 2,761,886.90 $ 2,348,886.90 $ 413,000.00
(230000)
$ 55,000.00 $ 55,000.00 $ 55,000.00 $ -
1,700.00 1,700.00 1,700.00 -
65,000.00 65,000.00 65,000.00 -
20,800.00 20,800.00 20,800.00 -
546,300.00 546,300.00 546,300.00 ..
30,000.00 45,000.00 45,000.00 .
$ 718,800.00 $ 733,800.00 $ 733,800.00 -
$ 300,000.00 $ 300,000.00 300,000.00 .
0.00% Increased activity
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00% Reflects prescription activity.
0.00%
-0.13%
14.95% Reduction In Special Projects.
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
(600,000.00)
12,250,747.00 12,250,747.00
73,261.00 73,261.00
-
620,817.00 620,817.00
271,334.00 271:334.00
- -
1,008,650.01 858,850.01
1,850,786.29 1,850,788.29
265.000.00 265,000.00
400,000.00
168,605.00 168,605.00
32,042.00 32,042.00
300,000.00 300,000.00
41,300.00 41,300.00
The County will recognize in excess of $600,000. However, favorability currently appears
0.00% In departments. A budget amendment is in process.
0.00%
0.00%
0.00%
14.87% Based on current usage.
0.00%
0.00%
100.00% Based on usage. Budget for P12004 and P12005 has been reduced to S - 0 -.
0.00%
0.00%
0.00%
0.00%
8DIV/01
0.00%
-0.29%
(600,000.00)
406,152.00
221,599.00
641,390.00
761,734.00
328,031.00
1,267,500.00
234,389.00
6,053,992.00
265,000.00
400,000.00
168,605.00
44,806.00
300,000.00
53,000.00
108,419.00
553,300.00
$ 11,807,917.00 (50,000.00)
368,614.00 368,614.00
$ 17,051,356.30 $ 17,101,356.30 $
,„2,„..
150,000.00
400,000.00
, COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
EXPENDITURES
BUDGET
AS
ADOPTED
BUDGET
AS
ADJUSTED
P12003
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION
INON-DEPARTARTMENT APPROPRIATIONS i
COUNTY OPERATIONS
County Expenditures (210000)
Ambulance
GIS Automation
Insurance Fund
Insurance Surety Bonds
Professional Services
Road CommIssionlCurrent Drain Assessment
Road Commission Party Agreement
Senior Citizen Prescriptions
West Nile Virus
Transfer to Component Unit
Total
COUNTY BUILDINGS (220000/320000)
STATE AND FEDERAL- COUNTY ASSOCIATIONS
Area Wide Water Quality
Assoc of Metro Sewage Agencies
Michigan Assoc. of Counties
National Assoc. of Counties
S.E.M.C.O.G.
Traffic Improvement Association
Total
SUNDRY EXPENSE (240000/270000)
RESERVED FOR TRANSFERS (290000)
Expenditures
Administrative Leave
Budget Task
Circuit Court Proposed Judge 1
Circuit Court Proposed Judge 2
Classification and Rate Change
Contingency
District Court Proposed Judge
Emergency Salaries
Grant Match
Info Tech Development
Insurance Reserve Expense
Juror Fees & Mileage
Legislative Expense
Misc. Capital Outlay
Office Automation
Overtime Appropriation
Security Expense
Summer Employees Salary Appropriation
aseerVas'efti Total
n••••"...
90.xls
FY 2003
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION
5,000,000.00 $
8132,000.00
2,700,000.00
55,700.00
$6,731,175.00
2,000,000.00
113,840.00
97,000.00
1,408,000.00
818,237,715.00 $
0.00%
0.00%
0,00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
22,342,417.00
13,468,349.00
15 000.00
835,825,768.00
23,509,399.19
15,822,314.49
15,000.00
$39,346,713.68
23,509,399.19 $
15,822,314.49
15,000.00
$39,346,713.68
Health Fund
Juvenile Maintenance Fund
Social Welfare Fund
0.00%
0.00%
0.00%
0.00%
%Arun I Ltr UPLINLANU
FY 2003 THIRD QUARTER FORECAST REPORT
EXPENDITURES
BUDGET
AS
ADOPTED
Transfers to Other Funds (3100001
Environmental Infrastructure $ 5,000,000.00
General Activities -
Information Technology Fund 2,503,000.00
Oak. Enhancement-Community Partnership 55,700.00
Transfer to Bldg Authority (Debt) $6,731,175.00
Transfer to Bldg Fund (Capital Improvement IProg. 2,000,000.00
Transfer to Fire Records Management -
Transfer to Information Technology -
Transfer to CLEMIS 1,408,000.00
Total $ 17,694,875.00
BUDGET
AS
ADJUSTED
5,000,000.00
8132,000.00
2,700,000.00
55,700.00
$6,731,175.00
2,000,000.00
113,840.00
97,000.00
1,408,000.00
$18,237,715.00
TOTAL NON-DEPT. APPROPRIATIONS $ 46.225,030.00 $ 54,253,348.74 $ 53,910,148.74 $ 343,200.00 0.63%
TRANSFER TO GENERAL PURPOSE FUNDS (310000)
TOTAL EXPENDITURES $ 82,050,796.00 $ 93,600,062.42 $ 93,256,882.42 $ 343,200.00 0.37%
4166 8/22/2003 90.xls 2
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
INTERNAL SERVICE FUND
DEPARTMENT OF CLERK/REGISTER OF DEEDS
ADOPTED AMENDED FY 2003 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
!MICROGRAPHICS FUND (654)1
$667,250 $667,250.00 $350,850 ($316,400) -47.42% - Rates reduced in attempt to reduce fund balance. Per Fed Guidelines (A87
351,667 $351,667.00 243,267 (108,400) -30.82% Rates reduced in attempt to reduce fund balance. Per Fed Guidelines (A87 _
Total Revenues $1,018,917 $1,018,917.00 $594,117 ($424,800) -41.69% _
OPERATING EXPENSES $957,144 057,144.00 $724,544 • $232,600 • 24.30% - Fay due to turnover, lower depreciation, equipment repairs, contracted
microfilming & reproductions, indirect cost, and expendable equipment.
NET NON-OPERATING REV $39,000 $39,000.00 $33,600 c$5,400) -13.85% - Lower return on investments.
REVENUE OVER (UNDER)
EXPENDITURES $100,773 $100,773.00 ($96,827) ($197,600) , ,
REVENUES
Outside
Inside
la\ MICROGRAPHICS.xls 8/13/2003
51
EXPLANATION OF SIGNIFICANT VARIANCES
!DRAIN EQUIPMENT FUND ( 639)
OPERATING REVENUES:
Inside
Outside
Total Revenue
OPERATING EXPENSES
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
INTERNAL SERVICE FUND
DRAIN COMMISSIONER
ADOPTED AMENDED FY 2003 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT
--.-- ----.......-- --- ---
$2,194,968.00 $2,198,488.00 $2,012,584.00 (6185,924.00) -8.46% Fav - Maintenance Contracts $139,800 that Includes prior year charges.
Fay - Rebilled Charges $12928 due to increase in rebels to internal departments.
Unfav - Copier Machine Charges ($50,000) due to copy machines purchased
now leased from Copier Fund. Budget Amendment Included in second quarter forecast
Untev - Equipment Rental ($287,632) due to over estimate of billable equipment charges.
670,302.00 670,302.00 549,230.00 (121,072.00) -18.06% Unfav - Ext. Rebilled Charges Revenue lower than budgeted ($169,472). However, in
line with prior years. Fay - SCADA charges $48,400 from external services Dispatch
Service, Equipment Rental and Maintenance Contracts.
2,865,270.00 2,868,790.00. 2,561,794.00 (306,996.00) -10.70%
• 2,850,313.00 2,853,833.00 3,218,129.00 (364,296.00) -12.77% Fey - Contracted Services 650,000 because of decrease in rebillable repairs. Fav - Professional
Services $57,000 ISO Ellee Facilitators contract expires. Fay - Maintenance Vehicles $60,000
due to Increase in lease vehicles. Fay - Radio Communications $27,283 due to purchase of
Nextel phones replacing the use of radio's. Unfav - Indirect Costs ($73,700) due to new indirect costs
allocation Unfav - Expendable Equipment Expense ($22,752) due to increased capitalization threshold.
Unfav - Info. Tech. Operations ($214,560) due to increased leased computers, printers and software
from IT. Unfav - Motor Pool ($105,376) due to replacement and additional new leased vehicles.
Unfav - Material and Supplies ($142,191) due to increases in the following programs Sewage
Metering, Administrative, Miscellaneous Equipment and T.V. Vans.
NET INCOME (LOSS) BEFORE 14,957.00 14,957.00 (656,335.00) (671,292.00) -4488.15%
NON-OPERATING REVENUE/(EXPENSE) 94,450.00 94,450.00 46,350.00 (49,100.00) -51.99% Unfav - Gain On Sale of Assets ($12,900) due to lower than estimated. Unfav - income from
. Investments ($36.200) lower than anticipated investment returns.
TRANSFER IN 0.00 0.00 0.00 0.00
TRANSFERS (OUT) 109,407.00 128,025.00 128,025.00 .0.00 0.00%
NET REVENUES OVER(UNDER) $0.00 . ($18,618.00), ($739,010.00) ($720,392.00)
EXPENSES
u‘s 08/14/2003
08/13/2003
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
INTERNAL SERVICE FUND
RISK MANAGEMENT
ADOPTED AMENDED FY 2003 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
easammomraomsoa.••••••nn••••••n•n......wav....•••n•n•••n••n••••••n•n•••n•n• wer.o.....emewato•n••n••nn••nn
ILIABILITY INSURANCE FUND 677
n•n••••••n••n••MarION.I.MIN •nn••nn•n•n•n•••n•n••nn•• n••n••••n•nnn••nn•• liMiellasabAl••nn••n•nIamf 101nn••••••nn••••••••••nn••••••••••n••101.1%.*.i.e.••nn•nn••n
OPERATING REVENUE $2,979,729 $2,902,117 $2,603,617 ($298,500) -10.29% - Unfav. - reduced revenue due to return on investments
OPERATING EXPENSE 2,051,655 1,974,043 1,964,343 9,700 0.49% - Fay - due to AON actuarial study cost lower than expected
CLAIMS PAID 1,200,000 1,200,000 1,500,000 (300,000) -25.00% - Unfav - due to increase in claim settlements and administrative costs
TOTAL OPERATING EXPENSES 3,251,655 3,174,043 3,464,343 (290,300) -9.15%
NET REVENUES OVER/(UNDER)
EXPENSES ($271,926) ($271,926). ($860,726) , ($588,800)
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
INTERNAL SERVICE FUND
DEPARTMENT OF MANAGEMENT AND BUDGET
ADOPTED AMENDED FY 2003 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
•n••nn•••••n•••••nn
[OFFICE EQUIPMENT FUND 664
OPERATING REVENUE
OPERATING EXPENSE
$659,782 $659,782 $680,582 $20,800
700,782 700,782 712,782 (12,000)
3.15% - Purchase of new equipment for Medical Examiner.
-1.71% - Unfav. due to increase in purchases of items tinder
the capitalization threshhold amount
OPERATING INCOME (LOSS) (41,000) (41,000) (32,200) 8,800 21.46%
NET NON-OPERATING REV (EXP) 41,000 , 41,000 33,000 (8,000) -19.51% - Decline in interest rates
NET REVENUES OVER/(UNDER)
' EXPENSES $0 , $0 $800 $800 •
511
08/08/2003
COUNTY OP OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
INTERNAL SERVICE FUND
FRINGE BENEFITS FUND
ADOPTED AMENDED FY 2003 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
!FRINGE BENEFITS FUND 878
REVENUE
RETIREES HOSPITALIZATION $19,472,800 $19,472,800 17,938,500 ($1,536,300) -7.89% - Fringe Benefit revenue will be lower than expected due to the number of employees taking
RETIREMENT ADMINISTRATION 1,111,100 1,111,100 1012,900 (98,200) -8.84% advantage of the retirement incentive and administrative leave. The hiring freeze is also having
TUITION REIMBURSEMENT 318,300 318,300 289,900 (28,400) -8.92% an impact on Fringe Benefit revenue.
EMPL. DEFERRED COMP. ADMIN. 42,300 42,300 35,100 (7,200) -17.02%
EMPL. DEFERRED COMP. COUNTY 883,500 883,500 819,400 (64,100) -7.28%
EMPLOYEE IN-SERVICE TRAINING 1,763,400 1,763,400 1,623,800 (139,600) -7.92%
DEFINED CONTRIBUTION PLAN 12,092,800 12,092,800 11,123,900 (968,900) -8.01%
DEFINED CONTRIBUTION ADMIN. 11,400 11,400 9,700 (1,700) -14.91%
GROUP LIFE 741,500 741,500 665,800 (75,700) -10.21% .
HOSPITALIZATION 24,810,000 24,810,000 24,216,200 (593,800) -2.39%
SOCIAL SECURITY 14,913,700 14,913,700 14,857,800 (55,900) -0.37%
DENTAL INSURANCE 3,074,400 3,074,400 2,905,900 (168,500) -5.48%
OPTICAL INSURANCE . 344,800 344,800 369,400 24,600 7.13%
DISABILITY INSURANCE 616,200 616,200 553,500 (62,700) -10.18%
SHORT-TERM DISABILITY 1,247,600 1,247,600 1,247,800 0 0.00%
FORFEITURES 215,500 215,500 20,000 (195,500) -90.72%
WORKERS COMPENSATION 2,290,800 2,290,800 2,374,800 84,000 3.67%
UNEMPLOYMENT COMPENSATION • 165,000 165,000 148,500 (16,500) -10.00%
FLEXIBLE BENEFIT DEDUCTIONS 526,500 526,500 714,800 188,300 35.76%
INVESTMENT INCOME 1,460,000 1,480,000 856,300 (603,700) -41.35%
TOTAL REVENUE $86,101,600 $86,101,600 $81,781,800 ($4,319,800) -5.02%
EXPENSE
RETIREES HOSPITALIZATION $20,521,600 $20,521,600 $23,473,400 ($2,951,800) -14.38% Unfavorability was due to budget being established prior to receiving actuarial report calculation.
RETIREMENT ADMINISTRATION 1,169,520 1,169,520 954,920 214,600 18.35%
SICK/ANNUAL LEAVE CASH-IN 1,250,000 1.250,000 2,467,900 (1,217,900) -97.43% - Unfav. Payoff of sick and annual leave bank for employees leaving county service due to early retirement program.
TUITION REIMBURSEMENT 335,000 335,000 315,300 19,700 5.88%
EMPL. DEFERRED COMP. ADMIN. 44,500 44,500 3,000 41,500 93.26%
EMPL. DEFERRED COMP. COUNTY 930,000 930,000 820,000 110,000 11.83%
EMPLOYEE IN-SERVICE TRAINING 1,306,200 1,259,767 1,002,167 257,600 20.45%
IN-SERVICE TRAINING - INFO TECH 550,000 400,000 375,000 25,000 6.25%
DEFINED CONTRIBUTION PLAN 12,452,800 12,452,800 12,052,300 400,500 3.22%
DEFINED CONTRIBUTION ADMIN. 12,000 12,000 1,600 10,400 86.67%
GROUP LIFE 741,500 741.500 612,300 129,200 17.42% -
HOSPITALIZATION 24,810,000 24,810,000 25,367,000 (557,000) -2.25% - Unfav. Hospital costs continue to increase industry-wide.
SOCIAL SECURITY 14,913,700 14,913,700 14,865,700 48,000 0.32%
DENTAL INSURANCE 3,074,400 3,074,400 2,832,200 242,200 7.88%
OPTICAL INSURANCE 344,800 344,800 315,400 29,400 8.53%
DISABILITY INSURANCE 1.863,800 1,863,800 1,854,100 9,700 0.52%
FLEXIBLE BENEFIT PAYMENTS 466,000 466,000 443,100 22,900 4.91%
PROFESSIONAL SERVICES 240,000 240,000 169,400 70,600 29.42%
WORKERS COMPENSATION 2,290,800 2,290,800 2,290,800 0 0.00%
UNEMPLOYMENT COMPENSATION 165,000 165,000 283,100 (118,100) -71.58%
ACCOUNTING SERVICES 89,200 89,200 89,200 0 0.00% .
CHILD CARE FACILITY 246,764 . 246,764 259,264 (12,500) -5.07%
INDIRECT COSTS 390,000 390,000 341,900 48,100 12.33%
TOTAL EXPENSE $88,207,584 $88,011,151 $91,189,051 ($3,177,900) -3.61%
($2,105,984) ($1,909,551) ($9,407,251) ($7.497,700) REVENUE OVERffUNDER) EXPENSE
FRINGE BENEFITS.xls
56"
08/13/2003
ma••••n••n•n•nn•n•nn•n•nn•••nn••••••••*00
OAKLAND COUNTY INTERNATIONAL
AIRPORT (581)
ADOPTED AMENDED
BUDGET BUDGET
*ama.a...)./Aguysmo
NET OPERATING INCOME (LOSS) ($250,000.00) ($250,000.00) $535,206.00 ($635,206.00) 254.08%
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
ENTERPRISE FUNDS
DEPARTMENT OF CENTRAL SERVICES
FY 2003 VARIANCE
FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
n•••••01,01/.••n•••/•n•••n•••0000n00/0 0404/00•001•MYeaam/01•0.1
•
OPERATING REVENUE
OPERATING EXPENSE
$4,014,941.00 $4,014,941.00 $4,089,941.00 $75,000.00 1.87% - Fav. Aviation Gas $40,000 due to increased number of landing and
departures: Land Lease $30,000 due to additional land lease agreements an
bi-annual rate increases; Miscellaneous $20,000 due to higher than -
anticipated revenues. Unfav. Landing Fees ($15,000) in line with prior year.
$4,264,941.00 $4,264,941.00 $3,554,735.00 ($710,206.00) -16.65% - Unfav. Heat, Light, Gas & Water ($30,000) due to colder and longer winter;
Indirect Costs ($161,205) not expected to receive General Fund contributioi
as in prior year; Property Taxes ($30,000) higher based on current and
historical costs; Water and Sewage charges ($8,000) due to expanded
irrigation system to airport grounds; Expendable Equipment Expense of
($16,000) is higher due to change in capitalization policy; Depreciation
of ($465,000) is higher due to change in additional reporting of local an stat,
grants as required by GASB 34.
NON-OPERATING REVENUE
' •
250,000.00 250,000.00 277,000.00 27,000.00 10.80% Fav. Income from Investments $27,000 due to higher than anticipated •
investment returns.
TOTAL INCOME BEFORE
CONTRIBUTIONS AND TRANSFERS $0.00 $0.00 $608,206.00 ($608,206.00)
TRANSFER IN 0.00 0.00 0.00 0.00
CAPITAL CONTRIBUTION 0.00 0.00 0.00 0.00
TOTAL NET INCOME (LOSS) $0.00 $0.00 . $608,206.00 ($608,206.00)
08/13/2003
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2003
FORECAST
$5,904,112 $5,816,078 85,781,978
1MOTOR POOL FUND 661
OPERATING REVENUE
NET INCOME (LOSS) BEFORE OPERATING
TRANSFERS
OPERATING TRANSFERS IN
629,125 589,174 907,874 318,500
185,900 257,437 257,437 0 0.00%
08/13/2003
COUNTY OF OAKLAND
FY 2003 THIRD QUARTER FORECAST REPORT
INTERNAL SERVICE FUNDS
DEPARTMENT OF CENTRAL SERVICES
VARIANCE
FAV/(UNFAV) PERCENT' EXPLANATION OF SIGNIFICANT VARIANCES
($34,100) -0.59% - Unfav. due to reduction of rates by $.02 for all vehicles
except Sheriff Tahoes & special rates effective 01/01/03.
Install radios, cameras and MDC on fewer vehicles
effective 01/01/03.
OPERATING EXPENSE 5,794,987 5,748,902 _ 5,252,502 $494,400 8.60% - Fay. due to deletion of Garage Attendant position eff.
10/01/02 and extension of useful miles from 73,000 to
80,000 effective 01/01/03. (depreciation)
OPERATING INCOME (LOSS) 109,125 69,174 529,474 460,300 665.42%
NON-OPERATING REVENUE (EXPENSE) 520,000 520,000 378,200 (141,800) -27.27% - Unfav. due to reduction of gain from sale of vehicles.
(increase In salvage value of vehicles)
NET REVENUE OVER/(UNDER)
EXPENSES $795,025 $846,611 $1,165,111 $318,500
!MAILING, CONVENIENCE COPIER AND PRINTING FUND 667
$3,035,235 OPERATING REVENUE $3,023,798 $3,151,596 $127,800 4.23% - FAA. due to increased use of mailroom by departments
OPERATING EXPENSE
NET REVENUE OVER/(UNDER)
EXPENSES
2,914,186 3,055,024 3,286,024 (231,000)
$121,049 ($31,228) ($134,428) ($103,200)
-7.56% - Unfair. due to increased expense for Permit 14 postage
$1,237,100.00 $1,510,600.00
87,500.00
$166,000.00
$1,510,600.00 $1,510,600.00
$0.00
$0.00
$8,168.00 $138,122.00
$3,400.00 $138,122.00
$0.00 $11,568.00
$0.00 $11,568.00
08/13/2003
FY 2003 THIRD QUARTER FORECAST REPORT
INTERNAL SERVICE FUNDS
DEPARTMENT OF FACILITIES MANAGEMENT
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2003
FORECAST
VARIANCE
FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
IFACILMES MAINTENANCE & OPERATIONS (#631)
OPERATING REVENUES:
Outside Revenue
Inside Revenue
Total Revenue
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
NON-OPERATING REVENUE
TRANSFERS IN
NET REVENUES OVER(UNDER)
EXPENSES
$594,700.00 $594,700.00 $764,900.00 $170,200.00
23,181,727.00 22,509,727.00 22,565,527.00 55,800.00
$23,776,427.00 $23,104,427.00 $23,330,427.00 $226,000.00
$23,917,927.00 $23,377,927.00 $22,093,327.00 $1,284,600.00
($141,500.00) ($273,500.00)
$87,500.00 $87,500.00
$54,000.00 $186,000.00
$0.00 $0.00
28.62% - Fay. $278,500 for lease payments from CMH Authority, which will contii ue to lease space in the CMH
Center through FY 2003 (not anticipated in FY 2003 Budget); and fay. Maintenance charges $37,700,
primarily to Oakland Schools; partially offset by safety alarm charges ($1,6,000), which were
budgeted in Outside Revenue, but are being receipted in Inside Revenue, as per GASB guidelines.
0.25% - Fay. safety alarm charges (see above note), partially offset by Charges to Departments ($41,800) _
for space occupied by the O.C. Road Commission as per lease contract, and Maintenance Depart.
0.98% ment Charges ($50,000) based on charges through June.
5.49% - Fav. Salaries and Fringe Benefits due to turnover $475,500; fay. Overtime $82,000 based on snow; "
plowing activity; fay. Sublet Repairs $600,000, Maintenance Supplies $175,000, Electrical
Service $250,000, Water & Sewage Charges $50,000, Custodial Supplies $15,000, Equipment
Repair & Maintenance $17,500, Depreciation $39,900, IT Operations $50,000, Telephone
Communications $17,500, and Leased Vehicles $17,500 primarily due to a reduction in project activity
due to budget restraints and based on projection of current expenditure levels. Favorability is partially
offset by unfav. Indirect Costs ($272,200) due to a revision of the Indirect Cost charge subsequent to
Budget formulation and unfav energy costs for Fuel Oil and Natural Gas ($250,000) based on utility
usage and rates.
7
0.00% -
0.00%
1
IPONTIAC MARKET (#261)
OPERATING REVENUES - OUTSIDE
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
TRANSFERS IN
TRANSFERS OUT
$129,954.00 $129,954.00
$141,522.00 $141,522.00
($11,568.00) ($11,588.00
6.29% - Fav. Stall Rental from vendors based on anticipated activity and rental rate increase.
2.40% - Fay. Indirect Costs $2,100 due to revision of charges subsequent to Budget formulation and fav.
Building Space Cost Allocaton $1,300 reflecting reduced Facilities Maintenance & Operations costs.-
NET REVENUES OVER(UNDER)
EXPENSES ($11,568.00) ($11,568.00)
Q.\ cod. FACILITIES INTERNAL FORE.xls
$1,349,588.00 81549,566.00 $1,424,086.00 $74,500.00
23,069,042.00 22,251,958.00 21,853,358.00 (388,600.00)
2,570,007.00 3,655,372.00 3,635,272.00 (20,100.00)
OPERATING REVENUES:
Outside
Inside
OPERATING TRANSFERS IN
TOTAL OPERATING REVENUES
OPERATING EXPENSES
OPERATING TRANSFERS (OUT)
OPERATING INCOME (LOSS)
nfo rm anion Technology - Telephone Communications (675)
OPERATING REVENUES:
Outside
Inside
OPERATING TRANSFERS IN
Total
OPERATING EXPENSES
OPERATING TRANSFERS (OUT)
OPERATING INCOME (LOSS)
'Information Technology - CLEMIS (635)
OPERATING REVENUES:
Outside
Inside
Fay. primarily due to decreased costs: Communications $723,100, Equip. repairs $98,300. E911
3,855,049.00 1,207,400.00 24.83% - Tariff $150,090, Professional svcs. $204,900, Special projects deferred $68,300, Sublet repairs
$59,600, and Info Tech operations $106,000 all lower than anticipated; offset by Indirect Cost
0.00 0.00 0.00% (542,200) and Maintenance Equipment ($164,100) higher than anticipated.
($87,175.00) (5223,591.00). ($239,691.00) ($16100.00)
$50,247.00 (33,000.00) -39.64%
3,385,111.00 (1,190,500.00) -26.13%
0.00 0.00 0.00%
3,415,358.00 (1,223.500.00) -28.38%
- Unfav. due to deer. Interest Income: lower interest rates and tower cash balance avail, for investment.
- Budget reflects anticipated reyenue increase from implementation of new system; partially offset by
$723,100 decrease in Communication coal Unfav. due to E911 Tariff postponement ($150,000)
offset by equal fay. expenditure.
683,247.00
4,405,611.00
0.00
4,488,658.00
4,578,033.00
0.00
$83,247.03
4,555,611.00
0.00
4,638,858.00
4,862,449.00
0.00
$1,253,772.00 $1,403,759.00 $1,510,759.00 $107,000.00
370,534.00 374,745.00 1,154,945.00 780,200.00
1,408,000.00 1,431,308.00 1,431,308.00 0.00 0.00%
3,032,306.00 3,209,812.00 4,097,012.00 887,200.00 27.64%
9,721,068.00 11,825,651.00 11,058.751.06 766,900.00
...(failita......12.00 ($8,815,839.00) ($8,961,739.00) $1,654,100.00
OPERATING TRANSFERS IN
TOTAL OPERATING REVENUES
OPERATING EXPENSES
OPERATING INCOME (LOSS)
6.49% - Fav. primarily due to Communications $349,000 for reductions in CDPD Cost Recovery Fee per line;
Equipment Repairs & Maintenance $159,000; Prof. Svcs. $190,000. Software Support $179,000,
Travel & Conf. $11,700, and Internal SVCS $192,000. Favorability partially offset by unfav. Salaries and
Fringe ($246,200) due to COPS MORE staff working on CLEMIS items; Indirect Cost ($32,400);
Commodities ($38,400) parts and accessories for LiveScan mainL
FY 2003 THIRD QUARTER FORECAST REPORT
INTERNAL SERVICE FUNDS
DEPARTMENT OF INFORMATION TECHNOLOGY
AMENDED
BUDGET
ADOPTED
BUDGET
'Information Technology - Operations (830
FY 2003 VARIANCE
FORECAST FAV/(UNFAV) ERCENT EXPLANATION OF SIGNIFICANT VARIANCES
5.52% • Fey due to Inc Access Oakland usage $130,300; Deferred Land Tax $122,300; Interest Income
$119,400. Fay. partially offset by Outside Agencies ($204,800); Reimb Equalization Svcs ($82,900);
and projected gain on sale of equip ($10,000).
-1.75% - Unfav due to decrease In charges to CLEWS Oper ($275,000); OC Depth Development ($1,122,0^0)
partially offset by fay. Imaging Day. & Oper. $103,700; Non-Govt Dev & Oper $381,200; and OC Lap!
Oper. $523,700. OC Dept and Non-govt day & oper based on equip & svc provided to requesting depts
-0.55% -
28,988,615.00 27,258,906.00 26,922,708.00 (334,200.00) 1.23%
38,314,772.00 38,864,224.00 $37,089,224.00 1,775,000.00 4.57% - Fav. primarily due to Salaries & Fringe $484,700 unfilled vacancies; Contractual Svcs of $1,294,600
due to decreases In: Equip Repairs & Maint for network switches replaced w/ spares; Communications
for elimination of low use connections; Software Suppt for timing of renewal of contracts. Also fay.
Telephone Comm. $132,200, Printing $16,300 and Mailing $2,700. Favorability partially offset by
Commodities ($138,600) due to inc In Data Process Supplies & Expendable Equip for purchases under
capital threshold.
0.00 0.00 0.00 0.00 0.00% -
_L11,326,157.00) ($11,607,318.00) (810,166,518.00) 51,440800.00
7.62% - Fay. due to increased MDC usage $133,100; addl membership of DC agencies $8,400; and increase
investment income $1,100; offset by ($35,600) of non Oak Co agencies not fully operational
as anticipated.
208.19% - Fay. due to increased Contributions from COPS MORE grant recognized in the CLEMIS Fund
$857,900; offset by decrease in projected MDC usage by Sheriff ($45,500) and ($32,200) for the
projected amount to be billed to 52/2s, Reimb., Circuit Cl, & Pros. for CLEMIS membership.
69
Page 1 of 2 0805/2003 NABudgehForecastNevaNFO TECH FORE.xls
FY 2003 THIRD QUARTER FORECAST REPORT
INTERNAL SERVICE FUNDS
DEPARTMENT OF INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2003 VARIANCE
BUDGET BUDGET FORECAST FAVl(UNFAV) ERCENT EXPLANATION OF SIGNIFICANT VARIANCES
'Information Technology - Radio Communications (680)
OPERATING REVENUES:
Outaide
Inside
OPERATING TRANSFERS IN
TOTAL OPERATING REVENUES
OPERATING EXPENSES
OPERATING INCOME (LOSS)
FFIre Records Management ( 531)
OPERATING REVENUES:
Outside
OPERATING TRANSFERS IN
Total
OPERATING EXPENSES
OPERATING TRANSFERS (OUT)
Fay. primarily due to E-911 Surcharge revenue $92,700 and related Investment income $7:06,600
$7,507,967.00 $7,507,937.00 $7,815,567.00 $307,600.00 4.10% - which is restricted to the new radio system construction. Unfav. Antenna site rent ($58,600) is offset
by (av. Outside agency leased equipment $64,900.
1,008,757.00 1,011,748.00 972,748.00 (39,000.00) -3.85% - Unfav. leased equipment ($42,100) and Parts ($10,300) is partially offset by fav. Labor $17,700
0.00 10,372.00 10,372.00 0.00 0.00%
8,518,724.00 8,530,087.00 8,798,687.00 268,600.00 3.15%
Fay In Salary & fringe $37,700, Indirect cost $56,700, Contractual svcs: Licenses $10,000, Maint
4,053,467.03 3,607,138.00 3,295,138.00 312,000.00 8.65% - $40,000 and Prof. svcs $188,000; Depreciation $36,200 and Commodities: Parts. Tools & Supplies
$22,000 offset by unfav. Expend. equipment of ($116,200). Internal services fay. $38,900.
$4,463,257.00 $4,922,949.00 . $5,503,549.00 $580,600.00
$124,600.00 $129,568.00 $120,168.00 ($9,400.00) -7.25% - Fax due to Income from investments $2,500 offset by unfav. Agency rev. ($11,900) due to delay in.
Implementation.
373,800.00 487,640.00 374,840.00 (112,800.00) 0.00% Unfav, due to timing of transfer.
498,400.00 817,208.00 495,008.00 (122,200.00) -19.80%
Fay, due to Equip. repairs $20,000, Software support $112,800, and Info Tech. operations $117,500
648,561.00 659,511.00 516,411.00 143,100.00 21.70% - partially offset by unfav. Prior Year credit to Roch. Hills ($40,400) and Info Tech develop ($71,600).
17,000.00 17,000.00 0.00 17,000.00 0.00% Fay. due to Op. Trans. to CLEWS not required.
OPERATING INCOME (LOSS) ($165,161.00) (559,303.00) ($21,403.00) $37,900,00
40 0
Page 2 of 2 0812512003 NAEludgenForecastNewVNFO TECH FORE.xis
a
7 /2ifl(
In Testimony Whereof, I have hereunto set my hand and affixed th, seal gflhe County of Oakland at
Pontiac, Michigan this 18th day of September, 2003.
Resolution #03254 September 18, 2003
Moved by Moss supported by Suarez the resolution be adopted.
AYES: Coulter, Crawford, Douglas, Gregory, Hatchett, Jamian, Knollenberg, KowaII, Law, Long,
McMillin, Middleton, Moffitt, Moss, Palmer, Patterson, Potter, Rogers, Scott, Suarez, Webster,
Wilson, Zack, Bullard, Coleman. (25)
NAYS: None. (0)
A sufficient majority having voted therefore, the resolution was adopted.
'WIMP
I eV APPROVE THE FOREGINUESPLUTION
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 18, 2003, with the original record thereof now remaining in my office.
G. William Caddell, County Clerk