HomeMy WebLinkAboutResolutions - 2005.06.16 - 278704 •
MISCELLANEOUS RESOLUTION 405107 June 16, 2005
BY: FINANCE COMMITTEE, CHUCK MOSS, CHAIRPERSON
IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2005 SECOND 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) 2005 Second Quarter Financial Forecast
Report has identified several variances and budget amendments are
recommended; and
WHEREAS an amendment is recommended to the 52 nd District Court budget,
due to projected unfavorable variance in Probation Training, Psychological
and Medical Exams ($14,300) and Telephone Communications ($54,500), and
sufficient favorability is projected in Salaries and Fringe Benefits to
offset the variance ; and
WHEREAS a budget amendment in the amount of $6,800 is recommended for
the Clerk's Jury Commission salaries, which are under budgeted, and
additional Election Filing Late Fee revenue is projected sufficient enough to
offset the unfavorable salaries; and
WHEREAS the Treasurer's Office is projected to be unfavorable in
Township and City Treasury Bonds ($10,000)and Charge Card Fees ($28,500)and a
budget amendment is recommended to reappropriate excess projected Salaries
and Fringe Benefit Budget to cover the projected unfavorable Controllable
Operating expenditures; and
WHEREAS the Human Resources-Administration Division is projected to be
unfavorable in Legal Services ($14,000) due to arbitration and in the
Employee Benefits Service Mementos ($5,000) due to increase in eligibility of
County employees, for which a budget amendment is recommended to
reappropriate projected Salaries and Fringe Benefits Budget into said
accounts; and
WHEREAS a budget amendment is recommended to the Health Division's
budget in the amount of $669,311 to properly reclassify various revenues
between accounts to recognize revenue source; and
WHEREAS the Community Corrections Division is projected to be
unfavorable in Contracted Services ($135,000); additional state funding is no
longer available; and
WHEREAS the Animal Control Division's Professional Services ($21,000)
due to prior year expense for Veterinarian Services, since several Public
Services Divisions are projected to be favorable in Salaries and Fringe
Benefits due to turnover, a budget amendment is recommended to reappropriate
funds for Contracted Services within the Public Services Department; and
WHEREAS the Planning and Economic Development Division is projected to
be unfavorable in Telephone Communications in the amount of ($9,500), and
sufficient funding is projected in Salaries and Fringe Benefits due to
turnover; a budget amendment is recommended to transfer the favorable
turnover to Telephone Communications; and
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote.
Prior Year Balance
Transfer Out to IT Fund
Total General Fund
$521,725
$521,725
WHEREAS the Clerk's Office is reflecting a favorable variance in
Mortgage and Land Transfer Tax revenue $1,500,000, as activity has remained
higher than anticipated; and
WHEREAS the Sheriff's Office is projected to be favorable in Diverted
Felon revenue $892,000, as changes in State law have not effected this
revenue to date, offset by the unfavorable Corrective Services Division and
Satellite Division's Overtime ($700,000) primarily due to overcrowding; and
WHEREAS the Circuit Court's State and Private Institutions is projected
to be unfavorable approximately ($2.4 million) due to past billing and
Guardian Ad Litem Fees ($120,000) unfavorable due to increased caseload; and
WHEREAS a budget amendment is recommended to appropriate the excess
revenues for Sheriff's Diverted Felon payments $359,000 and Clerk's Office
Mortgages $1,000,000 and Land Transfer Tax $500,000; and
WHEREAS a budget amendment is recommended to reappropriate Circuit
Court's projected favorable Salaries and Fringe Benefits $707,000 to Circuit
Court's State and Private Institution accounts and Guardian Ad Litem; and
WHEREAS an amendment is recommended to the Information Technology Fund
to appropriate funds for the following:
$46,200 - Office furniture and equipment due to the recent Information
Technology Department Reorganization per MR #05026
$4,500 - Professional Services relating to the PeopleSoft & Radio
projects, offset by revenue billable to the projects
$40,000 - Reserved funds for Data Warehouse enhancements per M.R.
#97136 for consulting services to review performance, recoverability, and
growth of data warehouse infrastructure
$20,000 - for Jail Task Force Support; and
WHEREAS an amendment is recommended to the Information Technology Fund
to appropriate funds in the amount of $521,725 from the Designation Fund
Balance (GL #9407-21000) for existing and future operations.
NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts
the Fiscal Year 2005 Second Quarter Financial Forecast.
BE IT FURTHER RESOLVED that $521,725 from the Designated Fund Balance
(GL #9407-21000) account be appropriated as follows:
GENERAL FUND (101)
Revenue
90-190000-14000-1582
Expenditure
90-310000-98636-8001
IT FUND (636)
Revenue
18-636113-98101-1701
Expenditures
18-636162-15000-3348
18-636162-15000-4101
18-636172-24000-3596
18-636172-24000-3348
Transfer from General Fund
Professional Services
Expendable Equipment Exp.
Software Purchases
Professional Services
Change in IT Fund Equity
$521,725
$ 38,325
326,000
13,000
68,200
$496,550
Chairperson, on behalf of the Finance Committee, I move the adoption of
the foregoing resolution.
FINANCE COMMITTEE
aze
L. BROOKS PATTERSON, OAKLAND COUNTY EXECUTIVE COAKLANDS
Em /3
COUNTY MICHIGAN
DEPARTMENT OF MANAGEMENT AND BUDGET Laurie Van Pelt, Director
Wm. Art Holdsworth, Deputy Director
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 2005 Second Quarter Forecast Report
DATE: May 18, 2005
FY 2005 FORECAST
Attached please find the Fiscal Year (FY) 2005 Second Quarter Forecast Report. In total, Fiscal Services
forecasts that the County will complete Fiscal Year 2005 with overall favorability of $3,217,840 in General
Fund / General Purpose (GF/GP) operations. GF/GP includes all operations except grants, enterprise funds
and internal service funds. This overall favorability is split between receiving $2,244,162 more revenue than
anticipated, and expending $973,678 less than budgeted.
REVENUES
Forecasted GF/GP revenues are estimated to be 0.57% more than budget or $2,244,162. The majority of the
favorability is the result of the following events:
A. GENERAL FUND - CHARGES FOR SERVICES - Favorable: $2,880,162
• This favorability primarily results from an unanticipated continuance of activity regarding
new mortgages and refinancing as reflected in the Clerk's Register of Deeds revenue. The
result is favorability of S1,500,000.
• Favorability in the Sheriffs Office of $1,733,980, is due to State Funding for housing of
Diverted Felons. This is partially offset by unfavorability revenues ($159,424) in the
Patrol Services and ($200,000) in Corrective Services Satellite Division for Board and Care
reimbursement.
• Drain Commissioner's revenue is expected to fall short approximately ($200,000) for Soil
Erosion fees due to less permits than originally estimated.
• Commission on Public Telephones is expected to fall short ($200,000) due to change in
contractor.
B. GENERAL FUND — INVESTMENT INCOME - Favorable: $149,000
• Slight increase in investment earnings due to interest rates.
C. GENERAL PURPOSE FUNDS — CHARGES FOR SERVICES - Unfavorable: ($805,000)
• Less than anticipated Out County Board and Care at Children's Village due to the delay in
startup of the Secure Detention facility ($750,000) and reduced board and care for Circuit
Court Child Care ($55,000.) 1
EXECUTIVE OFFICE BUILDING 34 EAST • 1200 N TELEGRAPH RD DEPT 409 • PONTIAC MI 48341-0409 • (248) 858-2163 • FAX (248) 858-9172
EXPENDITURES
In total, expenditures are estimated to be 0.25% less than budget or $973,678 as a result of personnel
turnover in numerous departments. This is partly offset by unfavorable contractual expenses. Those
departments which are projected to be unfavorable at the end of the fiscal year (barring any amendments) are
Circuit Court, Sheriff and Cleric/Register of Deeds.
A. CIRCUIT COURT Unfavorability ($961,300) is mostly the result of more children
ordered to State and Private Institutions residential centers. Length of stay ordered and
increased daily rates are also factors. This is partially offset by favorability in the
department due to turnover. Amendments are recommended.
B. SHERIFF — Unfavorability ($205,000) is mostly due overtime in Corrective Services both
at the main jail and at Satellite facilities due to a higher prisoner population. This is
partially offset by favorable administrative expenditures for prisoner hospitalization and
turnover in the Emergency Prep, Training and Communications Division. Total
favorability from Sheriff's revenue more than offsets the unfavorability from expenditures.
C. CLERK/REGISTER OF DES — Unfavorability ($156,822) stems from the costs
associated with supplies for the May election. Revenue favorability more than offsets
unfavorable expenditures.
couNry OF OAKLAND
, FY 2005 SECOND QUARTER FORECAST REPORT
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
FY 2005 BUDGET AMOUNT
ADOPTED AS FY 2005 FAVORABLE/
BUDGET AMENDED FOR CAST LUNFAVORABLE1 PERCENT
REVENUES
GENERAL FUND
Taxes $ 225,515,000.00 $ 225,515,000.00 $ 225,515,000.00 $- 0.00%
Federal Grants 113,652.00 124,752,00 124,752.00 -
Intergovernmental 33,393,557,00 33,464,130.00 33,464,130.00 - 0,00%
Indirect Cost Recovery 9,364,000.00 9.364,000.00 9,364,000.00 -
Charges for Services 76,726,228.00 77,403,856.00 80,284,018.00 2,880,162L0 3.72%
Investment Income 1,430,200.00 1,430,200.00 1,579.200.00 149,000.00
Other Revenues 236,19400 379,347.07 379,347.07 0.00% -
Transfers 5.040,332.00 6,118,584.00 6,118,584.00 -
SUB-TOTAL GENERAL FUND $ 352,819,153,00 $ 353,799,869.07 $ 356,829,031.07 $ 3,029,162.00 0.86%
GENERAL PURPOSE FUNDS
Intergovernmental $ 13,597,419.00 $ 13,597,419,00 $ 13,617,419.00 $ 20,000.00 0.15%
Charges for Services 7,329,089.00 7,414,834.00 6,609,834.00 (805,000.00) -10.86%
Other Revenues 0,00 0,00 0.00 000% . . . ... . .
SUB-TOTAL GENERAL PURPOSE FUND $20,926,508.00 $21,012,253.00 $20,227,253.00 ($785,000.00) -3.74%
.. . .
PLANNED USE OF FUND BALANCE $ 3,099,668.00 $ 15.650.291.21 $ 15,650,291.21 $0.00 0.00%
TOTAL OF/OP FUNDS 5 376,845,339,00 $ 390,462,413,28 $ 392,706,575.28 2,244,162.00 0.57%
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court
52nd District Court
Probate Court
TOTAL ADMIN. OF JUSTICE
$ 42,353,337.00
15,514.204.00
5,468,628.00
$ 63,336,169.00
$ 47,701,821.59
15,675.952.13
5,710,124.63
$ 69,087,898.35
$ 48,663,121.59 $ (961,300.00) -2.02%
15,258,752.13 417,200.00 2.66%
5,480,124.63 230,000.00 4.03%
$ 69,401,998.35 $ (314,100.00) -0,45%
LAW ENFORCEMENT
Prosecuting Attorney 17,082,462.00 18,169,471.11 17,959,471.11 210.000,00 1.16%
Sheriff 112 298 859 00 , , - 114,239,299.45 2 4 114 44 99 45 . (205,000.00)
• . •. , -0,18%
TOTAL LAW ENFORCEMENT $ 129,381,321.00 $ 132.408,770.56 $ 132,403,770.56 5,000.00 0.00%
GENERAL GOVERNMENT
Clerk/Register of Deeds 12,237,298.00 11,180,000.26 11,336.822.26 (156,822.00) -1.40%
Treasurer 3,483,342 00 3,546,451.92 3,402,451.92 144,000.00 4.06%
Board of Commissioners 2,865,580.00 2,880,344.95 2,798,644.96 81,700.00 2.84%
Library Board 2,592.714.00 2,654,377.32 2,536,477,32 27,900.00 1.05%
Drain Commissioner 4,892,780.00 6,479,753.38 6,479,753.38 - 0.00% . .. .. .. ..
TOTAL GENERAL GOVERNMENT $ 26.071,714.00 $ 26,750,927.54 $ 26,654,149.84 $ 96,778.00 0.36%
COUNTY EXECUTIVE
County Executive Admn. $ 7,783.417.00 $ 8,036,152,16 $ 8,036,152.16 $- 0.00%
Management and Budget 19,964,546.00 20,504,525 77 20,409,528,77 395,000.00 1.90%
Central Services 2,457,168.00 2,655,864.95 2,655,864.95 .. 0,00%
Facilities Management 1,546.033.00 1,550,775.39 1,550,775.39 - 0.00%
Human Resources 4,799,219.00 4,993,683.98 4,933,983.98 59,700.00 1.20%
Health and Human Services 55,295,626.00 56.579,017.73 56,344,017.73 235,000.00 0.42%
Public Services 15,081,104.00 15,437,179.99 15,199,279.99 237,900,00 1.54%
Economic Dev. and Comm Affairs 6,620,267.00 6,911,389.37 6,652.989.37 258,400.00 3.74%
Workforce Development 3500000 . . 35,000.00 35.000.00 0.00% -
TOTAL COUNTY EXECUTIVE $ 113.592,380.00 $ 117,003,592.34 $ 115,817,592.34 $ 1,186,000.00 1.01%
TOTAL DEPARTMENTS $ 332,381,584.00 $ 345,251,189.09 $ 344,277,511,09 $ 973,678.00 0.28%
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NON-DEPARTMENTALS
TOTAL GOVERNMENTAL EXPENDITURES
44,463,755.00 $ 45,211,224.19 $ 45,211,224.19 0.00%
376,845,339.00 S 390,462,413 28 $ 389,488,735.28 973,678.00 0.25%
General Fund/General Purpose
Favorable/(Unfavorable) - • $ 3,217,840.00 $ 3,217,840.00
SCHEDULE A
(9,800.00)
(4,500.00)
14,300.00
14,500.00
(37,300.00)
(17,200.00)
54,500.00
$ 14,500.00
$ (13,200.00)
(5,800.00)
14,000.00
5,000.00
, OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2005 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2005
AMENDMENTS ACCOUNT NUMBER ACCOUNT NAME
GF/GP OPERATIONS - SELF BALANCING AMENDMENTS
52nd District Court
Revenue
32-301100-20001-0849
Expenditures
32-201200-20001-2001
32-201200-20001-2074
32-205200-20006-3764
32-301200-20001-2640
32-401200-20001-2001
32-401200-20001-2074
32-401200-20001-6675
Clerk's Office
Revenue
21-130100-31000-0905
21-130100-31000-0465
Expenditures
21-230100-31000-4084
21-250100-01000-2001
Treasurer
Expenditures
21-221120-01000-2001
21-221120-01000-2074
21-221120-15000-3776
21-221120-20000-2502
Human Resources
Expenditures
15-101200-10000-2001
15-101200-10000-2074
15-105200-10001-3060
15-520200-53500-3568
Div. II - Refund PD Def. Atty Fees
Div. I - Admin. - Salaries
Div. I - Admin. - Fringe Benefits
Div. I - Probation - Trng, Psych & Med. Exams
Div. II - Def. Atty Fees
Div. lii - Salaries
Div. III - Fringe Benefits
Div. Ill - Telephone Communications
Total Expenditures
Elections - Reimbursement - General
Election Filing Fee-Late
Total Revenues
Election Supplies
Jury Comm. - Salaries
Total Expenditures
Admin. - Salaries
Admin. - Fringe Benefits
Labor/EEO - Legal Services
Employee Benefits - Service Mementos
Total
$ 14,500.00
$ 150,000.00
6,800.00
$ 156,800.00
$ 150,000.00
6,800.00
$ 156,800.00
Salaries $ (26,400.00)
Fringe Benefits (12,100.00)
Twp. & City Treas. Bonds 10,000.00
Charge Card Fees 28,500.00
$ (16,200.00)
(7,400.00)
(25,900.00)
(11,900.00)
(4,950.00)
(2,300.00)
(45,450.00)
(20,900.00)
(14,400.00)
(6,600.00)
135,000.00
21,000.00
(6,500.00)
(3,000.00)
9,500.00
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2005 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2005
AMENDMENTS ACCOUNT NUMBER ACCOUNT NAME
GF/GP OPERATIONS - SELF BALANCING AMENDMENTS
Health Division (Fund 221)
Revenues
16-220100-64100-0255
16-220100-64200-0255
16-220100-64100-0171
16-220100-64200-0171
16-220100-64200-0745
16-220100-64200-0171
16-220100-64300-0827
16-220100-64300-0171
16-220100-63400-0836
16-220100-63400-0113
16-220100-63400-0171
16-220100-64100-1125
16-220100-64100-0113
16-220100-64400-1125
16-220100-64400-0171
Public Services
Expenditures
17-302200-30001-2001
17-302200-30001-2074
17-402200-70001-2001
17-402200-70001-2074
17-501200-50000-2001
17-501200-50000-2074
17-912000-15000-2001
17-912000-15000-2074
17-802200-80001-2001
17-802200-80001-2074
17-402200-70330-2572
17-802200-80400-3348
Community and Economic
Expenditures
19-221000-10000-2001
19-221000-10000-2074
19-221000-10000-6675
2b NonComm Water Suppy - State
2b NonComm Water Suppy - State
Grants - State
Grants - State
On-Site Sewerage Permits
Grants - State
Public Swimming Pools - State
Grants - State
Radon Testing
Grants - Federal
Grants - State
Water Sample Tests
Grants - Federal
Water Sample Tests
Grants - State
Total
Veteran Services - Salaries
Veteran Services - Fringe Benefits
Comm. Corr. - Salaries
Comm. Corr. - Fringe Benefits
MSU Ext. - Salaries
MSU Ext. - Fringe Benefits
Med. Exam. - Salaries
Med. Exam. - Fringe Benefits
Animal Control - Salaries
Animal Control - Fringe Benefits
Comm. Corr. - Contracted Services
Animal Control - Professional Services
Total
Develoment
PEDs - Salaries
PEDs - Fringe Benefits
PEDs - Telephone Communications
Total
$ (158,394.00)
(510,917.00)
158,394.00
510,917.00
(369,975.00)
369,975.00
(29,715.00)
29,715.00
(15,000.00)
7,500.00
7,500.00
(76,450.00)
76,450.00
(71,736.00)
71,736.00
{F/GP OPERATIONS - GENERAL AMENDMENTS
General Fund (101)
Revenues
21-140100-11000-0705
21-140100-11000-0625
43-013301-20000-0452
Clerk / ROD - Mortgages
Clerk / ROD - Land Transfer Tax
Sheriff - Diverted Felons
Total General Fund Revenues
$ 1,000,000,00
500,000.00
504,000.00
$ 2,004,000.00
Total General Fund
Juvenile Maintenance Fund (293)
Revenue
90-430000-98101-1701 Non-Dept. - Juvenile Maint. Transfer In
Expenditures
35-242293-51400-3344
35-242293-51400-3640
35-242293-62000-3348
Cir. Ct. Family Div. - Private Institutions
Cir. Ct. Family Div. - State Institutions
Cir. Ct. Family Div. - Professional Services
, OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2005 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
ACCOUNT NUMBER ACCOUNT NAME
FY 2005
AMENDMENTS
GF/GP OPERATIONS - GENERAL AMENDMENTS
General Fund (101)
Expenditures
35-210000-21200-2001
35-210000-21200-2074
35-230000-22100-2001
35-230000-22100-2074
35-240000-43000-2001
35-240000-43000-2074
35-243000-33000-2816
43-023301-21400-2002
90-310000-98293-8001
Cir. Ct. Judicial Admin - Salaries
Cir. Ct. Judicial Admin - Fringe Benefits
Cir. Ct. General Jurisdiction - Salaries
Cir. Ct. General Jurisdiction - Fringe Benefits
Cir. Ct. Family Division - Salaries
Cir. Ct. Family Division - Fringe Benefits
dr. Ct. Family Division - Fees - Guard. Ad Litem
Sheriff /Corr. Svcs. - Overtime
Non-Dept. - Transfer to Juv. Maint. Fund
Total General Fund Expenditures
(171,250.00)
(78,750.00)
(45,900.00)
(21,100.00)
(267,150.00)
(122,850.00)
120,000.00
205,000.00
$ 2,386,000.00
$ 2,004,000.00
$ 2,386,000.00
$ 350,000.00
2,000,000.00
36,000.00
$ 2,386,000.00
Total Juvenile Maintenance Fund
, OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2005 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUND ACTIVITIES
SCHEDULE B
ACCOUNT NUMBER ACCOUNT NAME
!PROPRIETARY FUNDS - SELF BALANCING AMENDMENTS
Information Technology Fund (636)
18-636162-15000-4101 Expendable Equipment Expense
18-636172-24000-3348 Professional Services
18-636172-25100-3348 Professional Services
FY 2005
AMENDMENTS
$ 42,600.00
4,500.00
60,000.00
Change in Fund Equity $ 107,100.00
0.00%
0.00%
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
GENERAL FUND / GENERAL PURPOSE REVENUES
Amount
Adopted Amended FY 2005 Favorable
Budget Budget Forecast (unfavorable) Percent Explanation of Significant Variances
GENERAL FUND
TAXES
Property Taxes -2003 Tax Levy $ 224,910,000.00 $ 224,910,000.00 $ 224,910,000.00 0.00%
Delinquent Tax - Prior Years 500,000.00 500,000.00 500,000.00 0.00%
Trailer Tax 105,000.00 105,000.00 105,000.00 0.00%
Special Assessment - - - - 0.00%
Total Property and Other Taxes $ 225,515,000.00 $ 225,515,000.00 $ 225,515,000.00 $- 0.00%
FEDERAL AND STATE GRANTS
Emergency Response and Preparedness $ 43,652.00 $ 52,352.00 $ 52,352.00 $- 0.00%
Sheriff 70,000.00 72,400,00 72,400.00 0.00%
Total General Fund - Federal Grants $ 113,652.00 $ 124,752.00 $ 124,752.00 $ 0.00%
INTERGOVERMENTAL REVENUES
Governmental Program Revenues
Emergency Response & Preparedness $ 109,900.00 $ 109,900.00 $ 109,900.00 $- 0.00%
Community Corrections - Admin 380,000.00 380,000.00 380,000.00 0.00%
Veterans' Services - - .. 100.00%
Comm. & Econ Dev. - - -
Circuit Court - Gen. Jurisdiction 17,950.00 17,950.00 17,950.00 0.00%
District Courts 2,880.00 2,880.00 2,880.00 0.00%
Sheriff 260,000.00 260,000.00 260,000.00 0.00%
Non-Departmental - Judges Salaries 2,005,827.00 2,005,827.00 2,005,827.00 0.00%
General Reimb. Revenues (Non-Dept) 30,617,000.00 30,687,573.00 30,687,573.00 0.00% Assumes appropriate transfer from Revenue Sharing Reserve
Total General Fund - Intergov't Revenue $ 33,393,557.00 $ 33,464,130.00 $ 33,464,130.00
INDIRECT COST RECOVERY $ 9,364,000.00 $ 9,364,000.00 $ 9,364,000.00 $
CHARGES FOR SERVICES
County Executive Administration $ 151,500.00 $ 151,500,00 $ 151,500.00
Emergency Response & Preparedness 3,000.00 3,000.00 3,000.00
Auditing 74,000.00 74,000.00 70,000.00
Equalization
Purchasing
Reimbursment
Support Services
Human Resources
MSU Extension
Animal Control
Medical Examiner
Comm. & Econ. Development - Admin
Planning & Economic Development Svcs.
Clerk - County Clerk
Clerk - Elections
2,434,347.00 2,454,322.00 2,474,297.00
14,900.00 14,900.00 31,500.00
325,000.00 325,000.00 325,000.00
143,000.00 143,000.00 143,000.00
800.00 800.00 800.00
66,100.00 68,100.00 68,100.00
662,385.00 662,385.00 662,385.00
975,400.00 975,400.00 975,400.00
380,806.00 317,292.00 317,292.00
150,000.00 150,000.00 167,500.00
2,396,900.00 2,396,900.00 2,476,708.00
17,800.00 17,800.00 174,800.00
Clerk - Register of Deeds
Treasurer
Circuit Court - AdminiGeneral Jurisdiction 3,236,090.00 3,359,490.00 3,455,390.00
Circuit Court - Court Services
Circuit Court - Judicial Support
District Court - Division I
District Court - Division II
310,000.00 310,000.00 310,000,00
418,700.00 418,700.00 418,700.00
3,723,800.00 3,723,800.00 3,755,100.00
1,746,638.00 1,765,388.00 1,852,888.00
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
GENERAL FUND / GENERAL PURPOSE REVENUES
Adopted
Budget
Amended
Budget
FY 2005
Forecast
Amount
Favorable
(unfavorable t Percent Explanation of Significant Variances
2,825,680.00 2,825,680.00 2,741,180.00
0.00%
0.00%
(4,000,00) -5.41% Unfav due to accounting change for purchasing card rebate.
See Purchasing.
19,975.00 0.81% Contract wih Brandon Twp. for Equalization services
16,600.00 111.41% Rebates
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
17,500.00 11.67% Fay. Sale of Maps, including new Street Maps & Atlas in One-
Stop Shop.
79,808.00 3.33% Fay. Due to change in state law for gun permits. Photostat
purchases higher than anticipated.
157,000.00 882.02% Fay. Due to an increase in election documents that were filed
late and reimbursement from local school districts for
conducting the annual May election.
11.77% Fay. Due to land transfer tax and mortgage revenue being
higher than anticipated.
(84,500.00) -2.99% Unfav- ($74,118) Industrial Fac. Tax adj fcst to reflect actual
tax abatement role. ($20,082) TIFA/DDA Recovery CFT act
expired, ($1,841) Supplemental Warrants adj fcst to expected
actual. Partially offset by Alternate Energy receipts $11,514.
95,900.00 2.85% Fay due to increasing court cost charges to offenders,
unbudgeted DNA revenue received, Video Copying, and
Misc.
0.00%
0.00%
31,300.00 0.84% Fav due increasing Ordinance Fine and Cost receipts, partially
offset by unfav Forfieture of Bonds.
87,500.00 4.96% Fay in multiple line items due to addition of new judge and two
townships, new Sobriety fee and increased Probation revenue.
12,747,800.00 12,747,800.00 14,247,800 00 1,500,000.00
District Court - Division III
District Court - Division IV
4,267,863.00 4,267,863.00 4,267,863.00
2,255,352.00 2,255,352.00 2,334,752.00
0.00%
79,400.00 3.52% Fay due to Filling Fees DCU, Miscellaneous, Court Cost
Sobriety, & 3rd Admin. Fee revenues,
i BIRO
ill IM I NM
Probate Court
Prosecuting Attorney
Sheriffs Office
Sheriff - Administration
Sheriff - Corrective Services
Sheriff - Corrective Services Satellite
Sheriff - Patrol Services
Sheriff - Technical Services
214,600.00 214,600.00 214,600.00 -
10,800.00 10,800.00 10,800.00
1,000.00 1,000.00 9,700.00 8,700.00
2,304,206.00 2,411,817_00 4,145,797.00 1,733,980.00
2,357,900.00 2,357,900.00 2,157,900.00
27,816,038.00 28,268,044.00 28,108,620.00
707,102.00 707,102.00 609,438.00
(200,000.00)
(159,424 00)
(97,664.00)
Adopted Amended
Budget Budget
524,100.00 524,100.00
FY 2005
Forecast
527,600.00
(200,000.00)
2,880,162.00
-12.90%
3.72%
8,000.00
31,800 00
1,870,821.00
8,000.00
51,200.00
1,870,821.00
8,000,00
51,200.00
1,665,408.00
0.00%
-27.03% Unfav due to low interest rates and smaller investment base.
10.71% Fay. Due to moderate increase in interest rates.
10.42%
0.00%
0.00%
100.00%
100.00%
100.00%
(1,000.00)
150,000.00
149,000.00
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
GENERAL FUND / GENERAL PURPOSE REVENUES
Amount
Favorable
(unfavorablel Percent
3,500.00 0.67%
Explanation of Significant Variances
Fav due to miscellaneous unbudgeted revenue receipts e.g.
Ancillary Fees, CVR Cnty Portion, and Marriage Ceremony
rev. Also, increased Statement & Proof of Claim rev.
0.00%
0.00%
870.00% Fav due to mileage reimbursement being higher than
anticipated related to process serving.
71.90% Fav due to diverted felon payments being higher than
anticipated. Changes in state law have not yet effected this
revenue.
-8.48% Unfav due to Board and Care recovery being less than
anticipated. Work release facility is not at full capacity.
-0.56% Unfav due Reimb. Salaries being less than anticipated offset
by expense.
-13.81% Unfav due to dispatch revenue being less than anticipated.
The county no longer provides fire dispatching for Holly Tvvp.
0.00%
0.00%
(205,413.00) -10.98%
Board of Commissioners
Library Board
Drain Commissioner
Non-Departmental 1,550,000.00 1,550,000.00 1,350,000.00
Total General Fund - Charges for Services $ 76,726,228.00 $ 77,403,856.00 $ 80,284,018.00 $
Unfav - Plat Service Fees ($2,500) decrease due to change
from subdivision construction to condominium site
development. Unfav - Reimb Personal Mileage ($3,900)
based on mileage not being fully reimbursed. Unfav - Soil
Erosion Fees ($200,000) continued escalation of accounts to
the new permit fee system will fall short of previous anticipated
forecast.
Reduced revenue from Commission on public telephones.
INVESTMENT INCOME
District Courts $ 26,500.00 $ 26,500.00 $ 26,500.00 $
Clerk/Register of Deeds 3,700.00 3,700.00 2,700.00
Non-Departmental 1,400,000.00 1,400,000.00 1,550,000.00
Total General Fund - Investment Income $ 1,430,200.00 $ 1,430,200.00 $ 1,579,200.00 $
OTHER REVENUES
Emergency Response & Preparedness $ 15,000.00 $ 15,000.00 $ 15,000.00
Support Services - Materials Mgmt 6,000.00 6,000.00 6,000.00
Community Corrections - Admin - - -
Animal Control - - _
Planning & Econ Dev - - -
Clerk - Register of Deeds - - -
Treasurer
District Court
Circuit Court
Probate Court
Prosecuting Attorney
Sheriff
Drain Commissioner
Non-Departmental
Total General Fund - Other Revenues
Adopted
Budget
1,000.00
214,194.00
$ 236,194.00 $
0.00%
0.00%
0.15% 20,000.00
0.00%
0.00%
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
GENERAL FUND! GENERAL PURPOSE REVENUES
Amount
Amended FY 2005 Favorable
Budget Forecast (unfavorable) Percent
1,000.00 1,000.00 - 0.00%
- - - 100.00%
- - - 100.00%
- - - 100.00%
55,510.92 55,510.92 - 100.00%
301,836.15 301,836.15 0.00%
- - 100.00%
- - 0.00%
379,347.07 $ 379,347.07 $ 0.00%
Explanation of Significant Variances
TRANSFERS
Treasurer
Library Board
Human Resources
Non-Dept. - Investments (DIRF)
Total General Fund - Transfers
SUB-TOTAL GENERAL FUND
$ 2,352,101.00
88,231.00
3,600,000.00
$ 6,040,332.00
352,819,163.00
$ 2,352,101.00 $ 2,352,101.00 $
112,531.00 112,531.00
53,952.00 53,952.00
3,600,000.00 3,600,000.00
$ 6,118,584.00 $ 6,118,584.00 $
0.00%
0.00%
0.00% Due to HR reorganization per MR #04339.
0.00%
0.00%
$ 353,799,869.07 $ 356,829,031.07 $ 3,029,162.00 0.86%
GENERAL PURPOSE FUNDS
INTERGOVERNMENTAL
Health Fund
Health State Subsidy
Health Grant - State Reimbursement
Total Health Fund
$ 3,532,923.00 $ 3,532,923.00 $
109,696.00 109,696.00
$ 3,642,619.00 $ 3,642,619.00 $
3,532,923.00
109,696.00
3,642,619.00 $
0,00%
0.00%
0.00%
Juvenile Maintenance Fund
Children's Village - Refund School Meals $ 239,800.00 $
Non-Department - Child Care Subsidy 9,700,000.00
Total Juvenile Maintenance Fund $ 9,939,800.00 $
239,800.00 $ 259,800.00 $ 20,000.00 8.34% Favorable due to increase in Oakland County resident
population.
9,700,000.00 9,700,000.00 0.00%
9,939,800.40 $ 9,959,800.00 $ 20,000.00 0.20%
Social Welfare Fund
Foster Care - State Match 15,000.00
Total Social Welfare Fund 15,000.00
Total General Purpose - intergov't Revenuf $ 13,597,419.00
$ 15,000.00 $ 15,000.00
$ 15,000.00 $ 15,000.00 $
$ 13,597,419.00 $ 13,617,419.00 $
CHARGES FOR SERVICES
Health Fund
Health Division
Total Health Fund
$ 3,126,248.00 $ 3,211,993.00 $ 3,211,993.00
$ 3,126,248.00 $ 3,211,993.00 $ 3,211,993.00 $
Juvenile Maintenance Fund
73,1
Circuit Court
Children's Village
Total Juvenile Maintenance Fund
Total General Purpose - Charges for Svcs. $
INVESTMENT INCOME
Social Welfare Fund
Total General Purpose - investment Incom $
0.00% - $
- $
OTHER REVENUES
Health Fund
Health Division
Total Health Fund
0.00%
0.00%
20,926,508.00 $ 21,012,253.00 $ 20,227,253.00 $ (785,000.00) -3.74%
24,046,218.00 $ 24,322,577.21 $ 24,322,577.21
16,302,953.00 16,379,343.92 16,379,343.92
15,000.00 15,000.00 15,000.00
40,364,171.00 $ 40,716,921.13 $ 40,716,921.13 $
(40,364,171.00) $ (40,716,921.13) $ (40,716,921.13) $
- S 875,967.81 $ 875,967.81
3,099,668.00 14,571,405.05 14,571,405.05
171,844.19 171,844.19
31,074.16 31,074.16
3,099,668.00 $ 15,650,291.21 $ 15,650,291.21 $
0.00%
0.00% Use of Budget Transition and approved projects.
0.00%
0.00%
0.00%
- $
- $ 0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
GENERAL FUND / GENERAL PURPOSE REVENUES
Adopted Amended FY 2005
Budget Budget Forecast
1,030,000.00 $ 1,030,000.00 3 975,000.00
3,172,841.00 2,422,841.00
4,202,841.00 $ 4,202,841.00 $ 3,397,841.00
7,329,089.00 $ 7,414,834.00 $ 6,609,834.00
Amount
Favorable
(unfavorable)
$ (55,000 00)
(750,000.00)
$ (805,000.001
$ (805,000.00)
Percent Explanation of Significant Variances
-5.34% Unfav due to lower Gov't Benefit Ad & Care, partially offset by
increasing Bd & Care receipts.
-23.64% (Unfav.) due to delay in construction of Secure Detention
Facility.
-19.15%
-10.86%
3,172,841.00
Juvenile Maintenance Fund
Circuit Court
Children's Village
Total Juvenile Maintenance Fund
Total General Purpose - Other Revenues $
SUB-TOTAL GENERAL PURPOSE FUNDS $
TRANSFERS (In)
Non-Department - Health Fund
Non-Department - Juvenile Maintenance Ft.
Non-Department - Social Welfare Fund
Total General Purpose - Transfers In (Oul $
Less: Non-Departmental Transfers In (Out $
PLANNED USE OF FUND BALANCE
General Fund - Encumbs & Carried Fwds $
General Fund - Prior Years Balance
Gen. Purpose - Encumbs & Carried Fwds - PH
Gen. Purpose - Encumbs & Carried Fwds - JM
Total Planned Use of Fund Balance $
TOTAL GOVERNMENTAL RESOURCES _$ 376,845,339.00 $ 390,462,413.28 $ 392,706,575.28 $ 2,244,162.00 0.57%
47e.'
$ 6,904,895.00 $ 8,017,769.00 $ 7,484,569.00 $ 533,200.00
45,067.00 217,500.74 217,500.74 -
192,090.00 227,260.37 227,260.37
$ 7,142,052.00 $ 8,462,530.11 $ 7,929,330.11 $ 533,200.00 6.30%
6.65% Turnover.
0 00%
0.00%
6.17% Turnover.
0.00%
0.00%
135,500.00
$ 12,272,975.00 $ 12,295,703.00 $ 11,518,503.00 $
8,401,014.00 8,409,559.03 10,891,259.03
777,200.00
(2,481,700.00)
Non-Controllable Operating 1,732,382.00 1,768,879.96 1.768,879.96 0.00%
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
CIRCUIT COURT
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2005
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Judicial Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Business Division
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$ 1,983,481.00 $ 1,983,481 00 $ 1,915,581.00 $
43,200 00 44,718.89 38,118.89
351,742.00 358,622.97 358,622.97
67,900.00 3.42% Turnover.
6,600.00 14.76% Fav due to Data Proc. and Office Supplies, and Dry Goods and Clothing.
0.00%
$ 2,378,423.00 $ 2,386,822.86 $ 2,312,322.86 $ 74,500.00 3.12%
General Jurisdiction Division
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$ 2,195,512.00
6,000,571.00
2,230,408.00
$ 10,426,491.00
$ 2,195,512 00
9,805,343.88
2,377,470.75
$ 14,378,326.63
$ 2,060,012.00 $
9,805,343.88
2,377,470.75
$ 14,242,826.63 $ 135,500.00 0.94%
Family Division/Juvenile Maint.
Controllable Personnel
Controllable Operating
6.32% Turnover.
-29.51% Unfav due to under budgeted State and Private Institutions Residential expense. Judges are
assigning more children to institutional custody. Also, length of stay and datily rates have
increased. A budget amendment is recommended.
$ 22,406,371.00 $ 22,474,141.99 $ 24,178,641.99 $ (1,704,500.00) -7.58%
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$ 23,356,863.00 $ 24,492,465.00 $ 22,978,665.00
14,489,852 00 18,477,122.54 20,952,222.54
4,506,622.00 4,732,234.05 4,732,234.05
$ 1,513,800.09 6.18%
(2,475,100.00) -13.40%
0.00%
$ 42,353,337.00 $ 47,701,821.59 $ 48,663,121.59 $ (961,300.00) -2.02%
5/17/2005
District Court Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$ 139,420.00 $ 139,420 00 $ 123,020.00 $
70,300.00 70,300.00 60,300.00
16,400 00
10,000.00
Division 1 - Novi
Controllable Personnel
Controllable Operating
$ 3,603,107.00 $ 3,603,107.00 $ 3,485,007.00 $
922,450.00 925,867.00 940,167.00
118,100.00
(14,300.00)
$ 4,833,830.23 $
$ 2,081,937.00 $
534,493.00
$ 10,563,454.00 $
2,561,824.77
2,133,473.36
$ 15,258,752.13 $
6.40% - Turnover.
-2.44% - Unfav. Due to increasing use of Defense Afty Fees for Court appointed atty., partially offset
by lower Juror Fees & Mileage, savings in small tools and provisions due to
discontinuance of the Garden Program. A budget amendment is recommended.
0.00%
6.09% - Turnover.
- Unfav. due to Charge Card Fee more payments being made by credit cards, partially offset
0.98% by favorable office supplies.
0.00%
4.50%
4.39%
-0.53%
-2.62%
2.66%
5/17/2005
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
DISTRICT COURT
AMOUNT
ADOPTED AMENDED FY 2005 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 209,720.00 $ 209,720.00 $ 183,320.00 $
11.76% - Turnover.
14.22%
0.00%
3.28% - Turnover.
-1.54% - Unfav. Due to Property Tax (assessment incr.), Trng Psych & Med Exam court orders,
Charge Card Fee more payments being made by credit cards, Grounds Supplies clue to
relocation of Community Garden Prog, partially offset by favorable Bank Charges. A
budget amendment is recommended.
Fay visiting judge espense.
26,400 00 12.59%
Non-Controllable Operating
Total Division 1 - Novi
Division 2 - Clarkston
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Total Division 2- Clarkston
Division 3 - Rochester Hills
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Division 4 -Troy
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
460,074.61 460,074.61
$ 4,959,863.00 $ 4,989,048.61 $ 4,885,248.61 $
$ 1,643,630.00 $ 1,643,630.00 $ 1,538,430.00 $
554,457.00 593,685.79 608,185.79
231,632.25 231,632.25
$ 2,391,183.00 $ 2,468,948.04 $ 2,378,248.04 $
$ 3,445,560 00 $ 3,445,560.00 $ 3,335,060.00 $
416,172.00 418,678.98 418,678.98
999,317.00 1,025,591.25 1,080,091.25
$ 4,861,049.00 $ 4,889,830.23
$ 2,216,937.00 $ 2,216,937.00
533,558.00 539,793.00
361,675.25 361,675.25
$ 3,092,389.00 $ 3,118,405.25 $ 2,978,105.25 $
$ 11,048,654.00 $ 11,048,654.00
2,496,937.00 2,548,324.77
1,968,613.00 2,078,973.36
$ 15,514,204.00 $ 15,675,952.13
0.00%
103,800.00 2.08%
105,200.00
(14,500.00)
90,700.00 3.67%
110,500.00
-
(54,500.00)
56,000.00 1.15%
135,000.00
5,300.00
140,300.00
485,200.00
(13,500.00)
(54,500.00)
417,200.00
434,306.00
193,096.00
341,894.00
3.21% - Turnover.
0.00% -
-5.31% - Unfav telephones due to increase in number of lines. A budget amendment is
recommended.
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
PROBATE COURT
Judicial/Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Estates/Mental Health
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
AMOUNT
ADOPTED AMENDED FY 2005 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
$ 1,934,196.00 $2,107,089.00 $1,997,089.00 $ 110,000.00 5.22% - Turnover.
9,258.58 9,258.58 0.00%
324,624.00 363,561.45 363,561.45 - 0.00% -
$2,258,820.00 $2,479,909.03 $2,369,909.03 $ 110,000.00 4.44%
$2,066,290.00 $2,066,290.00 $1,946,290.00 $ 120,000.00 5.81% - Turnover.
704,981.00 705,692.83 705,692.83 0.00% -
438,537.00 458,232.77 458,232.77 - 0.00% -
$3,209,808.00 $3,230,215.60 $3,110,215.60 $ 120,000.00 3.71%
$4,000,486.00 $4,173,379.00 $3,943,379.00 $ 230,000.00 5.51%
704,981.00 714,951.41 714,951.41 0.00%
763,161.00 821,794.22 821,794.22 0.00%
$5,468,628.00 $5,710,124.63 $5,480,124.63 $ 230,000.00 4.03%
EXPLANATION OF SIGNIFICANT VARIANCES
was, 5/17/2005
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfer Out
Litigation
Controllable Personnel
Controllable Operating
Non-Controllable Operating
0.00%
0.00%
0.00%
0.00%
0.00%
200,000,00
10,000.00
---------
210,000.00
2.41% Turnover
20.07% Fav. Personal Mileage due to less than anticipated usage
0.00%
2.52%
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
PROSECUTING ATTORNEY
AMOUNT
ADOPTED AMENDED FY 2005 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 2,218,525.00 5 2,218,525.00 $ 2,218,525.00
835,408.00 1,823,284.14 $ 1,823,284.14
1,850,201.00 1,882,317.97 $ 1,882,317.97
14,000.00 $ 14,000.00
$ 4,904,134.00 $ 5,938,127.11 $ 5,938,127.11 $
$ 8,285,413.00 $ 8,286,921.00 $ 8,086,921.00 $
49,824.00 49,824.00 39,824.00
6,146.00 6,146.00 6,146.00
$ 8,341,383.00 $ 8,342,891.00 $ 8,132,891,00 $
Warrants
Controllable Personnel $ 2,294,947.00 $ 2,296,455.00 $ 2,296,455.00 0.00%
Controllable Operating 2,758.00 52,758.00 52,758.00 0.00%
Non-Controllable Operating - - - 0.00%
$ 2,297,705.00 $ 2,349,213.00 $ 2,349,213.00 $ 0.00%
Appellate
Controllable Personnel $ 1,531,949.00 $ 1,531,949.00 $ 1,531,949.00 0.00%
Controllable Operating 7,291.00 7,291.00 7,291.00 0.00%
Non-Controllable Operating - - - 0.00%
$ 1,539,240.00 $ 1,539,240.00 $ 1,539,240.00 $ 0.00%
Department
Controllable Personnel $ 14,330,834.00 $ 14,333,850.00 $ 14,133,850.00 $ 200,000.00 1.40%
Controllable Operating 895,281.00 1,933,157.14 1,923,157.14 10,000.00 0.52%
Non-Controllable Operating 1,856,347.00 1,888,463.97 1,888,463.97 - 0.00%
Transfer Out - 14,000.00 14,000.00 - 0.00%
$ 17,082,462.00 $ 18,169,471.11 $ 17,959,471.11 $ 210,000.00 1.16%
7" 5/17/2005
$ 1,576,521 00 $ 1,454,625.00 $ 1,454,625.00
87,074.00 124,084.00 124,084.00
1,148,229.00 1,152,111.00 1,152,111.00
$ 2,811,824.00 $ 2,730,820.00 $ 2,730,820.00 $
$ 1,345,143.00 $
806,477.00
625.184.00
Sheriffs Office
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Administrative Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
0.00%
0.00% -
0.00%
0 00%
000%
50,000.00 6.55% - Fav $50,000 due to the volume of uniform cleaning being less than anticipated.
0.00% -
1,549,234.00
763,438.00
588,920.00
$ 1,549,234.00
713,438.00
588,920.00
Corrective Services
Controllable Personnel $ 27,134,580.00 $ 27,134,580.00 $ 27,634,580 00 $ (500,000.00) -1.84%
Controllable Operating 8,155,146.00 8,233,982.58 8,088,982.58 145,000 00 1.76%
0.00%
0.00%
Controllable Operating
Non-Controllable Operating
t ransfer Out
368,800.00
1,053,086.00
375 782 97
1,053.086 00
375.782.97
1,053,086.00
0.00%
0.00%
0.00%
$ 34,750,053.00 $ 35,718,067.29 $ 35,718,067.29 $ 0.00%
$ 10,829,110.00 $ 6,395,865.00 $ 6,395,865.00
691,152.00 1,182,878 43 1,182,878.43
1,327,735.00 1,173,405.92 1,173,405.92
0.00%
0.00%
0.00%
0.00%
- $ 4,606,125.40 $ 4,306,125.40 $ 300,000.00 6,51%
05/18/2005
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
SHERIFFS OFFICE
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2005
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 2,776,804.00 $ 2,901,592.00 $ 2,851,592.00 $ 50,000.00 1.72%
Unfav overtime due to the lock replacement program extending into the beginning of this fiscal
year and a high prisoner population This is partially offset by favorability from position
vacancies.
Fay $145,000 due to the elimination of BCBS in prisoner hospitalization administration.
County's contract with NOMC has a greater discount and no administration fee.
Non-Controllable Operating
Transfer Out
6,507,947.00 6,772,039.86
68,452.00
6,772,039.86
68,452.00
$ 41,797,673.00 $ 42,209,054.44 $ 42,564,054.44 $
Corrective Services-Satellites
Controllable Personnel $ 15,892,622.00 $ 15,892,622.00 $ 16,092,622.00 $
(355,000.00) -0.84%
(200,000.00) -1.26% Unfav overtime due a high prisoner population. This is partially offset by favorability from
position vacancies. A budget amendment is recommended.
$ 17,314,508 00 $ 17.321,490.97 $ 17,521,490.97 $ (200,000.00) -115%
Patrol Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfer Out
Technical Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfer Out
$ 30,261,751.00 8 30,665.103.00 $ 30,665,103.00
225,536.00 586,752.30 586,752 30
4,231,763.00 4,280,667.99 4,280,667.99
31,003.00 185,544.00 185,544.00
0.00%
0.00% -
0.00% -
0.00%
$ 12,847,997.00
Emergency Prep,, Training 8, Comm.
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfer Out
$ 8,752,149.35 $ 8,752,149.35 $ 0.00%
$ 4,326,021.00 $ 4,026,021.00 $ 300,000.00
89,407.40 89,407.40
190,697.00 190,897.00
6.93%
0.00%
0.00%
0.00%
Fay overtime due to a low turnover.
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
SHERIFF'S OFFICE
Department Total
Controllable Personnel
Controllable OperatIng
Non-Controllable Operating
Transfer Out
AMOUNT
ADOPTED AMENDED FY 2005 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
$ 87,039,727.00 $ 8,418,050.00 $ 87,818,050.00 $ (400,000.00) -0.46%
10,334,185.00 5 11,356,325.68 $ 11,161,325.68 195,000.00 1 72%
14,893,944 00 $ 15,210,927.77 $ 15,210,927.77 0 00%
31,003.00 $ 253,996.00 253,996.00 0.00%
$112,298,859.00 $ 114,239,299.45 $ 114,444,299.45 $ (205,000.00) -0.18%
EXPLANATION OF SIGNIFICANT VARIANCES
05/18/2005
ADOPTED
BUDGET
AMENDED
BUDGET
0,00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0:00%
0.00%
0.00% 137,474.00
0.00%
137,474.00 Non-Controllable Operating
Transfers Out
109,498.00
0.00
-12.39%
0.00%
0-00%
0.00%
0.00%
0.00%
$ 7,831,543.00 $ 6,545,776.00 $ 6,552,598.00 $ (6,822.00)
2,251,368.00 2,252,662.35 2,402,662.35 (150,000.00)
2,154,387.00 2,381,561.91 2,381,561.91
-0.10%
-6.66%
0.00%
0:00%
14,280.00 $
6,009,00
130,223.78
$ 12,237,298.00 $ 11,180,000.26 $ 11,336,822.26 $ (156,822.00) -1.40% 5/17/2005
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
CLERK/REGISTER OF DEEDS
AMOUNT
FY 2005 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfers Out
$ 643,886.00 $ 643,886.00 $ 643,886.00
56,350.00 56,350.00 56,350.00
196,878.00 207,142.57 207,142.57
$ 897,114.00 $ 907,378.57 $ 907,378.57
County Clerk (Vital Stats & Legal Rees)
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfers Out
$ 4,414,103.00
239,378.00
614,799.00
$ 3,128,336.00 $ 3,128,336.00
240,501.83 240,501.83
784,828.36 784,828.36
Elections
Controllable Personnel
Controllable Operating (150,000.00)
$ 5,268,280 00 $ 4,153,666.19 $ 4,153,666.19 $
$ 487,766.00 $ 487,766.00 $ 487,766.00
585,300.00 585,470.52 735,470.52
0.00%
-25.62% - Unfavorable due to election supplies purchased for the May election. This
cost is offset by reimbursement revenue received from local school
districts A budget amendment is recommended.
Register of Deeds
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfers Out
$ 1,182,564.00 $ 1,210,710 52 $ 1,360,710.52 $ (150,000.00)
$ 2,278,330.00 $ 2,278,330.00 $ 2,278,330.00
1,364,331.00 1,364,331.00 1,364,331.00
1,112,429.00 1,121,893.20 1,121,893.20
$ 4,755,090.00 $ 4,764,554 20 $ 4,764,554.20 $
Jury Commission
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfers Out
7,458.00 $ 7,458.00 $
6,009.00 6,009.00
120,783.00 130,223.78
$ 134,250.00 $ 143,690.78 $
(6,822.00) -91.47% - Salary and fringes for Jury Commission members were incorrectly loaded
at the beginning of the fiscal year. A budget amendment is recommended.
0.00%
0.00%
150,512.78 $ (6,822.00) -4.75%
Administration
Controllable Personnel
Controllable Operating
$ 2,650,124.00
183,290.00
$ 2,650,124.00
183,999.60
$ 2,470,024.00
220,099.60
$ 3,483,342.00
$ 3,483,342_00
$ 3,546,451.92
$ 3,546,451.92
$ 3,402,451.92 $ 144,000.00 4.06%
$ 3,402,451.92 $ 144,000.00 4.06%
Division Total
Department Total
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
COUNTY TREASURER
ADOPTED AMENDED
BUDGET BUDGET
FY 2005
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
180,100.00 6.80% Turnover.
(36,100.00) -19.62% Unfav. due to cost of Twp. & City Treas. Bonds increases, & charge
card fee charges. A budget amendment is recommended.
Non-Controllable Operatin. 649,928.00 712,328.32 712,328.32 0.00%
5/17/2005
63,000.00
18,700.00
328,074.00 329,478.98
5/17/2005
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
BOARD OF COMMISSIONERS
ADOPTED AMENDED
BUDGET BUDGET
AMOUNT
FY 2005 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$ 2,103,900.00 $ 2,111,900.00 $ 2,048,900.00 $
433,606.00 438,965.98 420,265.98
329,478.98
2.98% - Turnover
4.26% - Fay. Memento $1,000, Communications $3,100, Memberships
$600, Professional Services $9,000 and Postage $5,000 all
resulting from lower usage.
0.00%
$ 2,798,644.96 $ 81,700.00 2.84%
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$ 2,865,580.00
$ 2,103,900.00
433,606.00
328,074.00
$ 2,865,580.00
$ 2,880,344.96
$ 2,111,900.00
438,965.98
329,478.98
$ 2,880,344.96
$ 2,048,900.00 $
420,265.98
329,478.98
$ 2,798,644.96 $
63,000.00 2.98%
18,700.00 4.26%
0.00%
81,700.00 2.84%
1.05%
2.74%
0.00%
0.00%
0.00%
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
LIBRARY BOARD
ADOPTED AMENDED
BUDGET BUDGET
AMOUNT
FY 2005 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Library Board
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfer Out
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfer Out
$ 1,016,417.00
663,464.00
907,833.00
5,000.00
$ 2,592,714.00
$ 1,016,417.00
663,464.00
907,833.00
5,000.00
$ 2,592,714.00
$ 1,016,417.00
664,034.00
909,826.32
74,100.00
$ 1,016,417.00
664,034.00
909,826.32
74,100.00
$ 2,664,377.32
$ 988,517.00 $
$ 664,034.00
$ 909,826.32 -
$ 74,100.00
$ 988,517.00
664,034.00
909,826.32
74,100.00
$ 2,664,377.32 $ 2,636,477.32 $
27,900.00 2.74% Turnover
0.00%
0.00%
0.00%
27,900.00
$ 27,900.00
$ 2,636,477.32 $ 27,900.00 1.05%
511712005
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
DRAIN COMMISSIONER
AMOUNT
ADOPTED AMENDED FY 2005 FAVORABLE
BUDGET BUDGET FORECAST UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Drain Commissioner
Controllable Personnel $ 3,414,457.00 $ 3,414,457.00 $ 3,414,457.00 0.00%
Controllable Operating $ 382,475.00 $ 1,876,500.05 $ 1,876,500.05 0.00% Unfav - Freight & Express ($86) the result of the Clinton Watershed program mailing
invitations and newsletters. Unfav - Insurance ($767) for SCADA electrical systems
should be charged to appropriate Drain or Lake level project. Unfav - Laundry &
Cleaning ($9,000) new uniform program for Soil Erosion staff. Unfav - Licenses and
Permits ($2,800) substantial increase in State of Michigan's DEQ Storm Water Discharge
Permit Fee. Unfav - Printing ($3,156) spending on printing of annual report, letterhead
and envelopes. Unfav - Protective Clothing & Equipment ($190) spending on gloves and
hardhats for Inspection Unit. Unfav - Stream Gage Program ($8,400) required State of
Michigan DEQ bill increased for this program. Unfav - Uniforms ($572) spending on new
jackets and overhauls for uniform program.
Non-Controllable Operating $ 1,039,683.00 $ 1,132,631.33 $ 1,132,631.33 0.00%
Transfer Out 56,165.00 56,165.00 $ 56,165.00 0.00%
Total $ 4,892,780.00 $ 6,479,753.38 $ 6,479,753.38 $ 0.00%
Department Total $ 4,892,780.00 $ 6,479,753.38 $ 6,479,753.38 $ 0.00%
05/10/2005
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
Auditing
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Corporation Counsel
Controllable Personnel
Controllable Operating
Non-Controllable Operating
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
5/17/2005
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
COUNTY EXECUTIVE
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
AMOUNT
ADOPTED AMENDED FY 2005 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
$ 1,966,416.00 $ 2,113,013.00 $ 2,113,013.00
301,954.00 378,124 89 378,124.89
479,271.00 482,054.24 482,054.24
$ 2,747,641.00 $ 2,973,192.13 $ 2,973,192.13 $
EXPLANATION OF SIGNIFICANT VARIANCES
Emergency Response & Preparedness
Controllable Personnel $ 643,140.00 $ 655,560.00 $ 655,560.00
Controllable Operating 475,150.00 477,190.00 477,190.00
Non-Controllable Operating 367,811.00 377,664.63 377,664.63
$ 1,486,101.00 $1,510,414.63 $1,510,414.63 $
$ 1,109,228 00 $ 1,109,228.00 $ 1,109,228 00
26,180.00 26,180.00 26,180.00
176,684 00 176,928.00 176,928.00
$ 1,312,092.00 $ 1,312,336.00 $ 1,312,336.00 $
$ 1,951,963.00 $ 1,951,963.00 $ 1,951,963.00
47,485.00 47,857 60 47,857.60
238,135.00 240,388.80 240,388.80
$ 2,237,583.00 $ 2,240,209.40 $ 2,240,209.40 $
Department Total
Controllable Personnel $ 5,670,747.00 $ 5,829,764.00 $ 5,829,764.00 $- 0 00%
Controllable Operating 850,769.00 929,352.49 929,352.49 0.00%
Non-Controllable Operating 1,261,901.00 1,277,035.67 1,277,035.67 0.00%
$ 7,783,417.00 $ 8,036,152.16 $ 8,036,152.16 $ 0.00%
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Purchasing
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Fiscal Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Reimbursement
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfer Out
395,000.00 2.50%
0.00%
0.00%
0.00%
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
MANAGEMENT AND BUDGET
AMOUNT
ADOPTED AMENDED FY 2005 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
$ 335,028.00 $ 335,028.00 $ 335,028.00
7,900.00 7,900.00 7,900.00
7,934.00 7,934.00 7,934.00
$ 350,862.00 $ 350,862.00 $ 350,862,00 $ 0.00%
$ 977,087.00 $ 977,087,00 $ 977,087.00
31,742.00 33,818.40 33,818.40
144,992.00 149,425.64 149,425.64
$ 1,153,821.00 $ 1,160,331.04 3 1,160,331.04 $ 0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
Equalization
Controllable Personnel $ 7,075,113.00 $ 7,075,113 00 $ 6,800,113.00 $ 275,000.00 3.89% Turnover
Controllable Operating 266,265.00 371,231 87 371,231.87 0.00%
Non-Controllable Operating 1,412,424.00 1,734,049.07 1,734,049.07 0,00%
Transfer Out - 0.00%
$8,753,802.00 $9,180,393.94 $8,905,393.94 $275,000.00 3.00%
$ 5,255,788.00 $ 5,255,788.00 $ 5,155,788.00 $ 100,000.00 1.90% Turnover
149,665.00 208,745 80 208,745.80 0.00%
1,500,767.00 1,815,435.84 1,815,435.84 0.00%
$ 6,906,220.00 $ 7,279,969 64 $ 7,179,969.64 3 100,000.00 1.37%
$ 2,144,968.00 $ 2,144,968.00 $ 2,124,968 00 $ 20,000.00 0.93% Turnover
79,610.00 85,067 00 85,067.00 0.00%
575,263.00 602,937.15 602,937.15 0.00%
-
$ 2,799,841.00 $ 2,832,972.15 $ 2,812,972.15 $ 20,000.00 0.71%
Department Total
Controllable Personnel $ 15,787,984.00 $ 15,787,984.00 $ 15,392,984.00 $
Controllable Operating 535,182.00 706,763.07 706,763.07
Non-Controllable Operating 3,641,380.00 4,309,781 70 4,309,781 70
Transfer Out -
$ 19,964,546.00 $ 20,804,528.77 $ 20,409,528.77 $ 395,000.00 1.90%
5/17/2005
ADOPTED
BUDGET
FY 2005
FORECAST
AMENDED
BUDGET
183,866.00 $
2,800.00
22,895.38
183,866 00 $
2,800.00
22,895.38
PERCENT
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
COUNTY OF OAKLAND
FY2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
CENTRAL SERVICES
Administrative
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Operating Transfer Out
Support Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Operating Transfer Out
AMOUNT
FAVORABLE
(UNFAVORABLE)
$ 183,866 00 $
2,800.00
13,744.00
$ 200,410.00 $ 209,561.38 $ 209,561.38 $
$ 1,153,956.00 $ 1,163,956 00
34,783.00 147,422.85
1,003,019.00 1,059,924.72
15,000.00 75,000.00
$ 1,163,956.00
147,422.85
1,059,924.72
75,000.00
$ 2,266,758.00 $ 2,446,303.57 $ 2,446,303.57 $ 0.00%
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Operating Transfer Out
$ 1,337,822.00 $ 1,347,822.00 $
37,583.00 150,222.85
1,016,763.00 1,082,820.10
75,000.00 75,000.00
1,347,822.00 $
150,222.85
1,082,820.10
75,000.00
0.00%
0.00%
0.00%
0.00%
$ 2,467,168.00 $ 2,655,864 95 $ 2,655,864.95 $ 0.00%
5/17/2005
$ 352,818.00 $ 352,818.00 $
9,525.00 9,525.00
352,818.00 $
9,525.00
0.00% -
0.00% -
52,584.00 56,232.00 56,232.00
-
$ 414,927.00 $ 418,575.00 $ 418,575.00 $
$ 931,774.00 $ 931,774.00 $
107,400.00 107,400.00
931,774.00 $
107,400.00
0.00% -
0.00% -
91,932 00 93,026.39 93,026.39
--
$ 1,131,106.00 $ 1,132,200.39 $ 1,132,200.39 $
0.00% -
0.00%
0.00% -
0.00%
$ 1,284,592.00 $ 1,284,592.00 $ 1,284,592.00 $ -
115,925.00 116,925.00 116,925.00 -
144,516.00 149,258.39 149,258.39 -
0.00%
0.00%
0.00%
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
FACILITIES MANAGEMENT
AMOUNT
ADOPTED AMENDED FY 2005 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Facilities Engineering
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$ 1,546,033.00 $ 1,550,775.39 $ 1,550,775.39 $ 0.00%
5/17/2005
Controllable Operating 229,528.00 266,498.00 271,498.00
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
HUMAN RESOURCES
AMOUNT
ADOPTED AMENDED FY 2005 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
Administration
Controllable Personnel $ 298,754.09 $ 607,112.00 $ 537,112.00 $ 70,000.00 11.53% Turnover,
EXPLANATION OF SIGNIFICANT VARIANCES
Controllable Operating 10,219_00 187,009.00 (14,000.00) -8.09% Legal Services projected to be unfav, due to union settlements. A budget
173,009.00 amendment is recommended,
Non-Controllable Operating 9,090.00 16,645.56 16,645.56
$ 318,063.00 $ 796,766.56 $ 740,766.56 $ 56,000.00 7.03%
Human Resources - General
Controllable Personnel $ 2,309,003.00 1,478,491.00 $ 1,478,491.00 $ - 0.00% -
Controllable Operating 406,678 00 221,517.31 212,817.31 8,700.00 3.93% - Projected favorability in Examination Material account.
Non-Controllable Operating 534,170.00 655,028.11 655,028.11 - 0.00% -
$ 3,249,851.00 $ 2,355,036.42 $ 2,346,336.42 $ 8,700.00 0_37%
Compensation & Benefits
Controllable Personnel $ 738,746.00 $ 1,314,852.00 $ 1,314,852.00 $ 0.00%
0.00%
(5,000.00) -1.88% Service Mementos unfav. ($10,000) due to increase in number of employees
eligible for service awards as a result of change in policy; Employee Med. Exam -
Returning account fav. $5,000 as current usage reflecting same trend as recent
historical usage. A budget amendment is recommended.
Non-Controllable Operating 263,031.00 260,531.00 260,531.00 - 0.00%
$1,231,305.60 $ 1,841,881.00 $ 1,846,881.00 $ (5,000.00) -0.27%
Department Total
Controllable Personnel $ 3,346,503.00 $ 3,400,455_00 $ 3,330,455.00 $ 70,000.00 2.06%
Controllable Operating 646,425.00 661,024.31 671,324.31 (10,300.00) -1.56%
Non-Controllable Operating 806,291.00 932,204.67 932,204.67 0.00%
$ 4,799,219.00 $ 4,993,683 98 $4,933,983.98 $ 59,700.00 1.20%
cio 5/17/2005
0.00% -
0.00% -
0.00% -
0.00%
0.00%
0.00%
0.00%
0.00%
235,000.00 0.68%
0.00% -
05/17/2005
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
HEALTH AND HUMAN SERVICES
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2005 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$ 189,028.00 $ 189,028.00 $ 189,028.00
7,473,634.00 8,116,612.25 8,116,612.25
10,835.00 10,835.00 10,835.00
$ 7,673,497.00 $ 8,316,475.25 $ 8,316,475.25 $
Health
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$ 23,497,338.00 $ 23,497,338.00 $ 23,262,338.00
4,389,282.00 4,730,857.29 4,730,857.29
2,928,465.00 3,120,838.11 3,120,838.11
$ 235,000.00 1.00% - Turnover
0.00% -
0.00% -
$ 30,815,085.00 $31,349,033.40 $31,114,033.40 $ 235,000.00 0.75%
Children's Village
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
$ 11,093,760.00 $ 11,093,760 00
3,294,561.00 3,355,885.16
2,418,723.00 2,463,863.92
-------------- -
$ 16,807,044.00 $ 16,913.509.08
$ 34,780,126.00 $ 34,780,126.00
15,157,477.00 16,203,354.70
$ 11,093,760,00
3,355,885.16
2,463,863.92
_
$ 16,913,509.08 $
$ 34,545,126.00 $
16,203,354.70
Non-Controllable Operating 5,358,023.00 5,595,537.03 5,595,537 03 0.00%
$ 55,295,626.00 $ 56,579,017.73 $ 56,344,017.73 $ 235,000.00 0.42%
Veteran's Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
PUBLIC SERVICES
Public Services - Admin.
Controllable Personnel
Controllable Operating
Non-Controllable Operating
AMOUNT
ADOPTED AMENDED FY 2005 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
$ 168,608.00 $ 168,608.00 $ 168,608.00 $
7,800.00 7,800.00 $ 7,800.00
6,727.00 6,727.00 $ 6,727.00
$ 183,135.00 $ 183,135.00 $ 183,135.00 $ 0.00%
$ 1,852,662.00 $ 1,906,254.26 $ 1,847,354.26 $ 58,900.00 3.09%
0.00%
0 00%
0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
$ 1,364,299.00 $ 1,417,026.00 $ 1,369,826.00 $ 47,200.00 3.33% - Turnover.
254,380 00 254,380.00 $ 242,680 00 11,700 00 4.60% - Fay. Soldier Burial $10,000 as number of qualifying deaths is lower than anticipated and
'transport Service $1,700.
233,983.00 234,848.26 $ 234,848.26 0.00%
Community Corrections
Controllable Personnel
Controllable Operating
$ 3,058,318.00 $ 3,060,944.00 $ 2,985,344.00 $ 75,600.00 2.47% - Turnover.
600,498.00 694,051.30 829,051.30 (135,000.00) -19.45% - Contracted Services increase in Probation Residential Centers (PRC) expense due to State
reduction in funding, which impacts the General Fund because of higher usage as an alternative
to incarceration. A budget amendment is recommended.
Non-Controllable Operating 478,383.00 546,361.37 546,361.37 0.00%
Transfer Out - 0.00%
$ 4,137,259.00 $ 4,301,356.67 $ 4,360,756.67 $ (59,400.00) -1.38%
MSU Ext. - Oakland County
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Medical Examiner
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfer Out
$ 714,908.00 $ 714,908.00 $ 700,408.00 $ 14,500.00 2.03% - Turnover.
104,978.00 105,010.75 99,010.75 6,000.00 5.71% - Fay. Professional Services 85,000 and Recognition Events $1,000 based on actual usage.
396,117 00 398,487 04 398,487.04 0.00%
$ 1,216,003.00 $ 1,218,405.79 $ 1,197,905.79 $ 20,500.00 1.68%
$ 3,039,615.00 $ 3,039,615.00 $ 2,947,615.00 $ 92,000.00 3.03% - Fay. Turnover $110,600 primarily due to new underfilled positions for startup of the Genesee
County contract; Offset by Unfav. Overtime ($18,600) due to increase case load from Genesee
County while new positions are being filled.
574,183.00 590,554.11 582,554.11 8,000.00 1.35% - Fay. Transport Services due to lower than anticipated caseload.
902,489.00 957,451.43 957,451.43 0.00%
60,000.00 75,500.00 75,500.00
4,576,287.00 $ 4,663,120.54 $ 4,487,620.54 $ 100,000.00 2.14%
Animal Control
Controllable Personnel
Controllable Operating
$ 1,691,742.00 S 1,691,742.00 $ 1,628,342.00 $
69,385.00 86,961.92 107,961.92
548,066.91 548,066.91
63,400.00 3.75% - Turnover.
(21,000.00) -24.15% - Unfav. Professional Services ($21,000) due to prior year veterinary services. A budget
amendment is recommended.
0.00% Non-Controllable Operating 519,357.00
$ 2,280,484.00 $ 2,326,770.83 $ 2,284,370.83 $ 42,400.00 1.82%
44Circuit Court Probation
Controllable Personnel - $ - $ - $ 0.00% 5/17/2005 rel
5717/2005
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
PUBLIC SERVICES
Controllable Operating
Non-Controllable Operating
AMOUNT
ADOPTED AMENDED FY 2005 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
42,539.00 43,625.19 43,625.19 0.00%
792,735.00 794,511.71 794,511,71 0.00%
$ 835,274.00 $ 838,136.90 $ 838,136,90 $ 0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Operating Transfer Out
$ 10,037,550.00 $ 10,092,843.00 $ 9,800,143.00 $ 292,700.00 2.90%
1,653,763.00 1,782,383.27 1,912,683.27 (130,300.00) -7.31%
3,329,791.00 3,486,453.72 3,486,453.72 0.00%
60,000.00 75,500.00
$ 15,081,104 00 $ 15,437,179.99 $ 15,199,279.99 $ 162400.00 1.05%
Administration
Controllable Personnel
Controllable Operating
$ 1,295525.00 $ 1,149529.00 $ 1,083,629.00 $
617,454.00 622,201.00 492,501,00
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS
AMOUNT
ADOPTED AMENDED FY 2005 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
86,000.00 5.74% - Turnover
129.700.00 20.85% - Fay. Professional Services, Printing, Legal Services, Information Supplies and Advertising for the
Solid Waste Resource Management Unit, reflecting the level of program activity.
Non-Controllable Operating 180,250 00 190,702.35
$ 2,093,229.00 $ 1,962,532,35
Planning and Economic Development Services
Controllable Personnel $ 3,010,763.00 $ 3,010,763,00
Controllable Operating 732,290.00 1,136,981,09
172,402.35 18,300.00 9.60% - Fav. Print Shop for Solid Waste Resource Management Unit. A budget amendment is recommended.
$ 1,748,532.35 $ 214,000.00 10.90%
$ 2,956,863 00 $ 53,900.00 1.79% - Turnover
1,136,981.09 0.00% -
Non-Controllable Operating
Community and Home Improvement
Controllable Personnel
Controllable Operating
Non-Controllable Operating
783,985.00 801,112.93 810,612.93 (9,500.00) -1.19% - Telephone Communications cost due to increased business recruitment activity.
$ 4,527,038.00 $ 4,948,857,02 $ 4,904,457.02 $ 44,400.00 0.90%
- $
- $
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfer Out
$ 4,306,288.00 $ 4,160,392.00 $ 4,040,492.00 $
1,349,744.00 1,759,182.09 1,629,482.09
964,235.00 991,815.28 983,015.28
119,900.00
129,700.00
8,800.00
2.88%
7 37%
0.89%
0.00%
$ 5,520,267.00 $ 6,911,389.37 $ 6,652,989.37 $ 258,400.00 3,74%
f1/4W
5/17/2005
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS/WORKFORCE DEVELOPMENT
AMOUNT
ADOPTED AMENDED FY 2005 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
Workforce Development
Controllable Personnel $ - $ - $ - $ -
Controllable Operating 35,000.00 35,000.00 35,000.00 - 0.00%
Non-Controllable Operating - - - -
------------ ----------------- ------------ ------------
$ 35,000.00 $ 35,000.00 $ 35,000.00 $ - 0.00%
Department Total
Controllable Personnel $ - $ - $ - $ -
Controllable Operating 35,000.00 35,000.00 35,000.00 - 0.00%
Non-Controllable Operating - - - -
$ 35,000.00 $ 35,000.00 $ 35,000.00 $ 0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
5/17/2005
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION
Amended budget includes funding for NW Highway extension.
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
COUNTY BUILDINGS (220000/320000) $ 3,950,95,3.00 $ 3,582,762.99 $ 3,582,762.99 0.00%
SUNDRY EXPENSE (240000/270000) $ 300,000.00 $ 300,148.20 $ 300,148.20 0.00%
Funds will be used for Budget Transition,
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.40%
0.00%
0.00%
0.00%
0.00%
0.00%
90.xls 5/17/2005
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
NON-DEPARTMENTAL
NON-DEPARTARTMENT APPROPRIATIONS
COUNTY OPERATIONS
County Expenditures (210000)
Ambulance
GIS Automation
Insurance Fund
Insurance Surety Bonds
Road Commission\ Current Drain Assessment
Road Commission\Tri Party Agreement
Senior Citizen Prescriptions
Transistion Expense
Transfer to CMHA
West Nile Virus Program
Total
BUDGET
AS
ADOPTED
19,800.00 $
201,184.00
15,000.00
1,202,300.00
1,500,000.00
150,000.00
9,620,616 00
$ 12,708,900.00 $
BUDGET
AS
ADJUSTED
19,800.00
1,258.78
201,184.00
15,000.00
1,202,300.00
3,500,000.00
150,000.00
15,000,00
9,620,616.00
500,000.00
15,225,158.78
FY 2005
FORECAST
19,800.00
1,258.78
201,184.00
15,000.00
1,202,300.00
3,500,000.00
150,000.00
15,000.00
9,620,616.00
500,000.00
$ 15,225,158.78 $
STATE AND FEDERAL COUNTY ASSOCIATIONS (230000)
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
55,000.00
1,700.00
65,000.00
20,800.00
579,000.00
30,000.00
$ 751,500.00
55,000.00
1,700.00
65,000.00
20,800.00
579,000.00
30,000.00
751,500.00
55,000.00
1,700.00
65,000.00
20,800.00
579,000.00
30,000.00
$ 751,500 00
0.00%
0.00%
0.00%
0.00% -
0.00%
0.00%
0.00%
RESERVED FOR TRANSFERS (290000)
Expenditures
Administrative Leave
Budget Task
Classification and Rate Change
Contingency
Emergency Salaries
Grant Match
Info Tech Development
Legislative Expense
Misc. Capital Outlay
Overtime Appropriation
Workshops and Meetings
Summer Employees Salary Appropriation
Total
(600,000.00)
188,244.00
209,041.00
268,997.00
1,267,500.00
6,999,314.00
6,164,375.00
180,495.00
75,000.00
53,000.00
4,000.00
372,431.00
$ 15,182,397,00
(600,000.00) (600,000.00)
188,244.00 188,244.00
196,379.00 196,379.00
275,192.00 275,192.00
1,267,500.00 1,267,500.00
1,796,713.00 1,796,713.00
4,129,549.22 4,129,549.22
180,495.00 180,495.00
51,155.00 51,155.00
43,000 00 43,000.00
4,000.00 4,000.00
372,431.90 372,431.00
7.904,658.22 $ 7,904,858 22 $
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
EXPLANATION
TOTAL NON-DEPT. APPROPRIATIONS $ 44,463,755.00 $ 45,211,224.19 $ 45,211,224.19 $ 0.00%
0.00%
0.00%
0.00%
0.00%
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
EXPENDITURES
NON-DEPARTMENTAL
Transfers to Other Funds (310000)
Bldg Authority (Debt)
Capital Improvement Prog. And Capital Acquisition
CLEMIS
Information Technology
Fire Records Management
Oak. Enhancement-Community Partnership
Total
BUDGET
AS
ADOPTED
$1,440,000.00
5,500,000.00
1.616,500.00
2,584,000.00
373,800.00
55,700.00
$ 11,570,000.00
BUDGET
AS
ADJUSTED
$1,440,000.00
9,779,996.00
1,634,860.00
4,162,640.00
373,800.00
55,700.00
$17,446,996.00
FY 2005
FORECAST
$1,440,000.00
$9,779,996.00
$1,634,860.00
$4,162,640.00
$373,800.00
55,700.00
$17,446,996.00 $
TRANSFER TO GENERAL PURPOSE FUNDS (310000)
Health Fund $ 24,046,218.00 $ 24,322,577.21 $ 24,322,577.21
Juvenile Maintenance Fund 16,302,953.00 16,379,343.92 16,379,343.92
Social Welfare Fund 15,000.00 15,000.00 15,000.00
$40,364,171.00 $40,716,921.13 $40,716,921.13
TOTAL EXPENDITURES $ 84,827,926.00 $ 85,928,145.32 $ 85.928,145.32 $ 0.00%
90.xls sii7onns
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
INTERNAL SERVICE FUNDS
SHERIFF'S OFFICE
ADOPTED AMENDED FY 2005 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT -------- --------- —_---- ----- -----
'SHERIFF AVIATION #680
OPERATING REVENUES:
EXPLANATION OF SIGNIFICANT VARIANCES
Outside Revenue $0.00 $0.00 $0.00 0.00%
Inside Revenue $ 1.971,048.00 $ 1,971,048.00 $ 1,943,148.00 $ (27,900.00) -1.42% - Reduced revenues based on lower forecasted expenditures.
Total Revenue $1,971,048.00 $1,971,048.00 $1,943,148.00 ($27,900.00) -1.42%
OPERATING EXPENSES $1,533,548.00 $1,533,548.00 $1,505,648,00 $ 27,900.00 1_82% - Fay. Turnover $20,400, Interest Expense $1,100, Fuel $20,000 offset
by Unfav. Training ($13,600).
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS $437,500.00 $437,500,00 $437,500.00 $ - 0.00%
NON-OPERATING REVENUE $0.00 $0.00 0.00 $ - 0.00%
OPERATING TRANSFERS IN $0.00 $0.00 $0.00 $ - 0.00%
NET REVENUES OVER(UNDER)
EXPENSES
Total Net Assets - Beginning
Total Net Assets - Ending
$437,500.00 $437,500.00 $437,500.00 $ 0.00%
$1,312,500.00
$1,750,000.00
5/17/2005
-5.68% - Unfav. due to increase of $68,092 for indirect cost charge,
100.00% - Fav. due to favorable interest rates.
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
INTERNAL SERVICE FUND
DEPARTMENT OF CLERK/REGISTER OF DEEDS
ADOPTED AMENDED FY 2005
BUDGET BUDGET FORECAST
VARIANCE
FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
MICROGRAPHICS FUND (654)
REVENUES
Outside
Inside
Total Revenues
OPERATING EXPENSES
NET NON-OPERATING REV
REVENUE OVER (UNDER)
EXPENDI TURES
Total Net Assets - Beginning
Total Net Assets - Ending
$255,056.00 $255,056.00 $255,056.00 $0.00
475,562.00 475,562.00 475,562.00 0.00
$730,618.00 $730,618.00 $730,618.00 $0.00
1,198,330.00 1,198,330.00 1,266,422.00 (68,100.00)
5,000.00 5,000.00 10,000.00 5,000.00
($462,712.00) ($462,712.00) ($525,804.00)
$1,331,150.00
$805,346.00
11/443
amp MICROGRAPHICS.xls 5/17/2005
$2,776,892,00 $2,776,892.00 $2,628,445.00 ($148,447.00) -5.35% Fav - Dispatch Services $2,252 more SCADA systems in service
resulting in more dispatch calls. Unfav - Equipment Rental ($194,565)
due to delay in rate increase. Fay - Rebilied Charges $19,293 for
increase in rebills to Internal Departments. Fav - Reimbursement
Building Space Cost $12,600 a new rate increase will be implemented for
the pump maintenance building. Fay - Prior Year Adjustments $5,662 for
payroll correction of a rebill chargeable to another project. Fay - Prior
Year Revenue $6,000 for reclassification of a water deposit.
738,230.00 738,230.00 698,230.00 ($40,000.00) -5.42% Unfav - Equipment Rental ($40,000) because project to convert microfilm
to computer disk will not occur in year 2005.
3,515,122 00 3,515,122.90 3,326,675.00 (188,447 00) -5.36%
3,468,613.00 3,468,613,00 3,420,427 00 48,166.00 1.39% Unfav - Equipment Rental ($1,805) for specialty equipment needed for
drain projects. Unfav - Equip. Repair Motor Vehicle ($3,572) actual
spending increased because of aging vehicle fleet. Unfav - Gas Natural
($2,100) increased for new pump maintenance storage building. Fay -
Microfilming & Reproductions $40,000 because project to convert
microfilm to computer disk will not OCCUr in year 2005. Unfav - Protective
Clothing & Equip ($22,600) purchased new and replaced some old gas
detectors. Fay - Uniforms $51,870 result of charging Systems directly
instead of Drain Equipment Fund. Unfav - Depreciation Equipment
($14,336) now includes automatic vehicle location equipment.
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
INTERNAL SERVICE FUND
DRAIN COMMISSIONER
ADOPTED AMENDED FY 2005 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
'DRAIN EQUIPMENT FUND ( 639)
OPERA TING REVENUES:
Inside
Outside
Total Revenue
OPERATING EXPENSES
Fay - Dry Goods And Clothing $14,760 and Employee Footwear $9,570
because charging Systems directly instead of Drain Equipment Fund.
Unfav - Shop Supplies ($14,317) due to under estimated budget. Unfav -
Maintenance Dept Charges ($8,112) for SCADA dispatch charges to be
re-billed to lakes and drains at year end for revenue will offset expense.
NET INCOME (LOSS) BEFORE
NON-OPERAT INC REVENUE/(EXPENSE)
TRANSFER 1N
TRANSFERS (OUT)
46,509.00 46,599.00 (93,752.00)
77,182.00 77,182.00 77,633,00
(140,261.00) -301.58%
451.00 0.58% Fay - Accrued Interest Adjustment $451.
0.00 0.00 0.00 0.00 0.00%
123,691.00 123,691.00 123,691.00 0.00 0.00%
NET REVENUES OVER(UNDER) $0.00 $0.00 ($139,810.001 ($139,810.001
EXPENSES
TOTAL NET ASSE IS - BEGINNING 3,915,499.00
TOTAL NET ASSETS - ENDING $3,775,669.00
5/18/2005
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
INTERNAL SERVICE FUND
RISK MANAGEMENT
ADOPTED AMENDED FY 2005 VARIANCE
BUDGET BUDGET FORECAST FAV1(UNF AV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
'LIABILITY INSURANCE FUND 677
OPERATING REVENUES:
Outside Revenue $- $ - $ - $ -
Inside Revenue $ 3,069,664.00 $ 3,069,664.00 $ 3,069,664.00 $ - 0.00%
Total Revenue $ 3,069564.00 $ 3,069,664.00 $ 3,069,664.00 $ -
OPERATING EXPENSE $ 2,510,298.00 $ 2,510,298.00 $ 2,465,881.00 $ 44,400.00 1.77% - Fay. due to decrease in indirect costs and turnover.
CLAIMS PAID $ 1,500,000.00 $ 1,500,000.00 $ 5,500,000.00 $ (4,000,000.00) -266.67% Unfav. due to claim settlement. A reserve for the $4,000,000
was established in FY 2004 for this settlement.
TOTAL OPERATING EXPENSES $ 4,010,298.00 $ 4,010,298.00 $ 7,965,881.00 $ (3,955,600.00) -98.64%
OPERATING INCOME (LOSS) $ (940 534.00) $ (940,634.00) $ (4,896,21 1.00) $ (3,955,600.00)
NON-OPERATING REVENUE (EXPENSE) $ 400,000.00 $ 400,000.00 $ 346,000.00 $ (54,000.00) -13.50% Increase in interest rates are less than originally anticipated.
NET REVENUES OVER/(UNDER)
EXPENSES $ (540,634.00) $ (540,634.001 $ (4,550,217.00) $ (4,009,600.00)
TOTAL NET ASSETS - BEGINNING 9,959,291.00
TOTAL NET ASSETS - ENDING 5,409,074.00
5/17/2005
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
INTERNAL SERVICE FUND
MANAGEMENT AND BUDGET
ADOPTED AMENDED FY 2005 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
'OFFICE EQUIPMENT FUND 664 I
OPERATING REVENUE- INSIDE $ 642,186.00 $ 642,186.00 $ 642,186.00 $ - 0.00%
OPERATING EXPENSE 673,486.00 673,486.00 768,563.00 $ (95,000.00) -14.11% Unfav, due to increase in indirect cost rates.
OPERATING INCOME (LOSS) (31,300.00) (31,300.00) $ (126,377.00) (95,000.00) 303.51%
NON-OPERATING REVENUE (EXPENSE) 31,300.00 31,300.00 31,300.00 0.00%
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS 0.00 0.00 (95,077.00) (95,000.00)
OPERATING TRANSFERS IN 0.00 49,500.00 49,500.00 $ 100.00%
NET REVENUE OVERi(UNDER)
EXPENSES $0.00 $49,500.00 (45,577.00) ($95,000.00)
TOTAL NET ASSETS - BEGINNING 3,578,139.00
TOTAL NET ASSETS - ENDING $3,532,562.00
5/1712005
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
'FRINGE BENEFITS FUND 678
ADOPTED AMENDED FY 2005 VARIANCE
1 BUDGET BUDGET FORECAST FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING REVENUE
RETIREES MEDICAL - VEBA 28,777,510 28,777,510 27,923,710 (853,800) -2.97%
RETIREMENT ADMINISTRATION 1,351,700 1,351,700 1,310,100 (41,600) -3.08%
TUITION REIMBURSEMENT 350,000 350,000 340,600 (9,400) -2.69%
ENIPL. DEFERRED COMP. ADMIN. 1,500 1,500 1,500 0 0.00%
EMPL. DEFERRED COMP. COUNTY 748,500 748,500 730,090 (18,500) -2.47%
EMPLOYEE 1N-SERVICE TRAINING 1,715,100 1,715,100 1,664,800 (50,300) -2.93%
DEFINED CONTRIBUTION PLAN 15,554,300 15,554,300 15,351,000 (203,300) -1.31%
GROUP LIFE 680,000 680,000 689,000 9,000 1.32%
MEDICAL INSURANCE 28,705,200 28,705,200 28,955,200 250,000 0.87% - Using Blue Cross illustrative rates and actual premium for Health Alliance Plan
SOCIAL SECURITY 15,785,000 15,785,000 15,621,600 (163,400) -1.04%
DENTAL INSURANCE 3,246,200 3,248,200 3,146,000 (102,200) -3.15%
OPTICAL INSURANCE 368,000 368,000 349,600 (18,400) -5.00%
DISABILITY INSURANCE 861,600 861,600 860,900 (700) -0.08%
SHORT-TERM DISABILITY 1,455,000 1,455,000 1,530,000 75,000 5.15%
FRINGE BENEFITS 101,000 101,000 95,400 (5,600) -554%
WORKERS COMPENSATION 2,790,800 2,790,800 2,838,000 47,200 1.69%
UNEMPLOYMENT COMPENSATION 360,000 360,090 361,200 1,200 0.33%
SICK AND ANNUAL LEAVE CASII-OUT 841,390 841,390 817,490 (23,900) -2.84%
EXT - FLEX BENEFIT DEDUCTIONS 435,000 435,000 531,500 96,500 22.18%
EXT - FLEX BEN MEDICAL DEDUC IIONS 1,600,000 1,600,000 1,589,209 (10,800) -0.68%
EXT - MEDICAL INSURANCE 200,000 200,000 216,004 16,000 8.00%
EXT - DENTAL INSURANCE 20,000 20,000 24,200 4,200 21.00%
EXT - OPTICAL INSURANCE 2,000 2,000 2,200 200 10.00%
EXT - FORFEITURES 10,000 10,000 1,000 (9,000) -90 00%
EXT - CHILD CARE FACILITY 0 0 23,500 23,500 0.00%
INVESTMENT INCOME 554,700 554,700 385,600 (169,100) -30.48%
TOTAL REVENUE 106,516,500 106,516,500 105,359,300 (1,157,200) -1.09%
OPERATING EXPENSE
RETIREES MEDICAL - VEBA 28,777,510 28,777,510 28,777,510 0 0.00%
RETIREMENT ADMINISTRATION 1,351,700 1,351,700 1,329,000 22,700 1.68%
SICK AND ANNUAL LEAVE CASH-OUT 841,390 841,390 841,390 0 0.00%
TUITION REIMBURSEMENT 350,000 350,000 339,000 11.000 3.14%
EMPL. DEFERRED COMP. ADMIN. 1,000 1,000 55,800 (54,800) -5480.00% -Deferred Compensation Plan Document update and fund performance review
EMPL. DEFERRED COMP. PRINTING 500 500 0 500 100.00%
EMPL. DEFERRED COMP. COUNTY 748,500 748,500 740,000 8,500 1.14%
EMPLOYEE IN-SERVICE TRAINING 1,315,100 1,261,148 981,848 279,300 22.15%
IN-SERVICE TRAINING - INFO 7E01 400,000 409,000 350,000 50,000 12.50%
DEFINED CONTRIBUTION PLAN 15,554,300 15,554,300 14,500,000 1,054,300 6.78%
GROUP LIFE 680.000 680,000 671,500 8,500 125%
MEDICAL INSURANCE 30,505,200 30,505.200 30,205,200 300,000 0.98%
SOCIAL SECURITY 15,785,000 15.785.000 15,800,000 (15,000) -0.10%
DENTAL INSURANCE 3,268,200 3,268,200 3,162,300 105,900 3.24%
OPTICAL INSURANCE 370,000 370,000 349,000 21,000 5.68%
DISABILITY INSURANCE 2,316,600 2,316,600 2,441,700 (125,100) -5.40%
FLEXIBLE BENEFIT PAYMENTS 310,000 310,000 225,600 84,400 2723%
PROFESSIONAL SERVICES 125,000 125,000 119,000 6,000 4.80%
WORKERS COMPENSATION 2,790,800 2,790,800 2,790,800 0 0.00%
UNEMPLOYMENT COMPENSATION 360,000 360,000 372,000 (12,000) -3.33%
ACCOUNTING SERVICES 101,000 101,000 99,609 1,400 1.39%
CHILD CARE FACILITY 264,700 264,700 259,400 5,300 2.00%
INDIRECT COSTS 300,000 300,000 312.000 (12,000) -4.00%
TOTAL EXPENSE 106,516,500 106,462,548 104,722,648 1,739,900 1.63%
TRANSFER OUT 0 (53,952) (53,952) 0 -Due to Human Resources reorganization per Miscellaneous Resolution #04339
NET REVENUE OVERAUNDER) EXPENSE 0 0 582,700 582,700
TOTAL NET ASSETS - BEGINNING 16,091,298
TOTAL NET ASSETS - ENDING 16,673,998
FRINGE BENEFITS.xls 5117/2005
1N1OTOR POOL FUND 661
OPERATING REVENUE:
Outside Revenue 114,430.00 114,430.00 114,430.00 $0.00 0.00%
3,361,191.00 3,361,191.00 3,464,180.00 (103,000.00)
253,284.00 253,284.00 223,762.00 (29,500.00)
-3.06% - Unfav, due to increase of indirect costs of $62,100 and $40,000 for contracted
services offset by revenue.
$276,533.00 $276,533.00 $350,000.00 $73,500.00
3,337,942.00 3,337,942.00 3,337,942.00 0.00 0.00%
$3,614,475.00 $3,614,475.00 $3,687,942.00 $73,500.00
26.58% - Fav. due to increase of cities, villages and townships utilizing county mail room
and print shop.
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
INTERNAL SERVICE FUNDS
CENTRAL SERVICES
ADOPTED AMENDED FY 2005 VARIANCE
BUDGET BUDGET FORECAST FAVALINFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Inside Revenue
Total Revenue
OPERATING EXPENSE
OPERATING INCOME (LOSS)
NON-OPERATING REVENUE (EXPENSE)
NET INCOME (LOSS) BEFORE OPERATING
TRANSFERS
OPERATING TRANSFERS IN
NET REVENUE OVERi(UNDER)
EXPENSES
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
4,819,205.00 4,881,275.00 4,927,333.00 46,000.00 0.94% - Fav. due to increase in parts and accessories provided on vehicles.
4,933,635.00 4,995,705.00 5,041,763.00 46,000.00
6,010,394.00 6,072,464.00 6,342,640.00 (270,200.00) -4.45%
(1,076,759.00) (1,076,759.00) (1,300,877.00) (224,200.00) -20.82%
430,000.00 430,000.00 430,000.00 0.00 0.00%
(546,759.00) (646,759.00) (870,877.00) (224,200.00) -34.67%
123,691.00 348,825.00 348,825.00 0.00 0.00%
(523,068.00) (297,934.00) (522,052.00) (224,200.00)
6,802,573.00
$6,280,521.00
- Unfav. due to increase in car wash ($5,900), increase in indirect cost rate ($63,100)
and increase in gas, oil & grease ($201,000).
'MAILING, CONVENIENCE COPIER AND PRINTING FUND 667
OPERATING REVENUFS:
Outside Revenue
Inside Revenue
Total Revenue
OPERATING EXPENSE
OPERATING INCOME (LOSS)
NON-OPERATING REVENUE (EXPENSE)
NET REVENUE OVERAUNDER)
EXPENSES
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
2,770.00 2,770.00 500000 2,200.00
$256,054.00 $256,054.00 228,762.00 ($27,300.00)
839,896.00
$1_068 658 00
79.42% - Fav. due to increased interest on investments.
5/17/2005
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
NON-OPERATING REVENUE
TRANSFERS IN
TRANSFERS OUT
NET REVENUES OVER(UNDER)
EXPENSES
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
($65,000.00) ($85,000.00)
$85,000.00 $85,000.00
($390,200.00)
$0.00 t$390,200.00)
($58,900.00) $26,100.00
$85,000.00 -
(5390,200.00
($364,100 00). $26,100 00
OPERATING REVENUES - OUTSIDE $149,344.00
$149,344.00
$0.00
$149,344.00
$149,344.00
$0.00
$149,344.00
$149,344.00
$0.00
$0.00 0.00%
$0.00 0.00%
$0.00 0.00%
0.00%
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
TRANSFERS IN
f RANSFERS OUT
$0.00 $0.00
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2005
FORECAST
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS
FACILITIES MANAGEMENT
VARIANCE
FAVONFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$265,900.00 $265,900.00 $265,900.00 $0.00
24,174,666.00 24,174,666.00 24,357,266.00 182,600.00
$24,440,566.00 $24,440,566.00 $24,623,166.00 $182,600.00
$24,525,566.00 $24,525,566.00 $24,682,966.00 ($156,500.00)
$10,179,780.23
$9,815,680.23
0.00% -
0.76% - Fav. Maintenance Department Charges $239,000 based on departmental requests; partially offset by
reduced Office Space Rental revenue ($56,400) as per lease agreement for office space charges
0.75% for the 0 C. Road Commission at the Information Technology Center.
-0.64% - Unfav. Sublet Repairs costs ($250,000) based on maintenance and repair costs provided by outside
vendors, including replacement of two generators at County facilities: Fuel Oil and Natural Gas costs
($250,000) due to rate increases; Water & Sewage Charges ($25,000) due to water rate increase;
Grounds Supplies ($20,000) due to reclassification of supplies costs; Motor Pool ($45,300), and
Telephone Communications ($11,600) based on anticipated usage.
Unfav. Is partially offset by fay. Overtime $25,000 based on level of Snowplowing activity; fay. Indirect Cost
Charges $247,600 due to determination of Indirect Cost Charges subsequent to budget formulation;
lay. Maintenance Supplies & Materials $110,000 due primarily to reclassification of supplies costs,
fay. Depreciation $30,000 based on current depreciation schedule; and fay. Information Technology
30.71% Operations $25,000; and Garbage Disposal costs $15,000 based on anticipated usage.
0.00% -
'FACILITIES MAINTENANCE & OPERATIONS (#631) I
OPERATING REVENUES:
Outside Revenue
Inside Revenue
Total Revenue
OPERATING EXPENSES
!PONTIAC MARKET (#261)
NET REVENUES OVER(UNDER)
EXPENSES
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
$0.00
$10,756.89
$10 756 89
$0.00 0.00%
FACILITIES INTERNAL FORE.xls orell. 5/17/2005
%IT\
OAKLAND COUNTY INTERNATIONAL
AIRPORT (581)
OPERATING REVENUE
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
$ 62,055,392.00
$62,125,392.00
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
ENTERPRISE FUNDS
CENTRAL SERVICES
ADOPTED AMENDED FY 2005 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$4,283,332.00 $4,283,332.00 $4,403,332.00 $120,000.00 2.80% - Favorable Reimb US Customs Service $50,000 due to rate increase and
service to larger aircraft; Land Leases $70,000 increase due to rate increases,
OPERATING EXPENSE $4,662,503.00 $4,662,503.00 $4,662,503.00 $0.00 0.00% -
NET OPERATING INCOME (LOSS) ($379,171.00) ($319,171.00) ($259,171.00) $120,000.00 -31.65%
NON-OPERATING REVENUE $ 271,795.00 $ 271,795.00 $ 221,795.00 $ (50,000.00) -18.40% - Increase in Investment Income less than anticipated.
TOTAL INCOME BEFORE
CONTRIBUTIONS AND TRANSFERS ($107,376.00) ($107,376.00) $ (37,376.00) $70,000.00
TRANSFER IN 0.00 0.00 0.00 0.00 0.00%
CAPITAL CONTRIBUTION 107,376.00 107,376.00 107,376.00 $0.00 0.00% Contributed capital to be posted at year end for projects.
TOTAL NET INCOME (LOSS) $0.00 $0.00 $70,000.00 $70,000.00
05/17/2005
OPERATING REVENUES'
Outside $1,416,066.00 $1,416,066.00 $1,139,366.00 ($276,700.00)
$3474100 534,747.00
3,836,470.00 3,836,470.00
0.00 000
3,871,217.00 3,871,217 00
3,816,870.00 3,816,870.00
0.00 0.00
554.347.00
$42,147.09
4,224,970.00
0.00
4,267,117.00
3,909,270.00
0.00
$7,400.00 21 30%
388,500.00 10.13%
0.00 0.00%
395,900.00 10.23%
(92,400.00) -2.42%
0.00 0.00%
554.347.00 5357,847 00 $303,500.00
3,456,344.04
$3,814,191.04
OPERATING REVENUES:
Outside
Inside
OPERATING TRANSFERS IN
Total
OPERATING EXPENSES
OPERATING TRANSFERS (OUT)
OPERATING INCOME (LOSS)
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
Favorable interest income $18,100 due to improved returns and higher cash balance; offset by decreased
usage by external customers ($10,800).
Favorable due to increased telephone usage $387,500 including re-billed Expendable equipment and
increased pager usage $1,000.
Communications 5320,200 favorable due to rate reductions; unfavorable Maint. Equip. ($61,000) and Sublet
Repairs ($5,200) partially offset by fav. Equip. Repairs $20,000. Unfavorable Software Purchase ($12,700)
due to unanticipated required upgrade; Tower Charges $10,000 favorable due to lower than anticipated
usage; Travel and Conference $5,000 favorable due to cost cutting; non-controllable Indirect cost urrfav.
($141,200); unfavorable Expendable equipment ($200,000) offset by rebilled revenue; unfavorable
Depreciation ($19,200)due to capital equipment additions. Non-controllable ISF unfavorable ($7,900).
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
INTERNAL SERVICE FUNDS
INFORMATION TECHNOLOGY
AMENDED
BUDGET
ADOPTED
BUDGET
!Information Technology - Operations (636) I
FY 2005
FORECAST
VARIANCE
FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
-19.54% - Unfavorability due to less than projected estimate of Deferred Land File Tax ($175,000) & Access Oakland
($138,000) on-line usage of new products offered through @ccess Oakland program; ($64,000) decrease
external customers requests; ($13,500) Gain on Sale of Equip. due to extending life of PC. Unfav. offset by
interest on past due accounts $12,350 & favorable Interest Income $101.000
Inside
OPERATING TRANSFERS IN
TOTAL OPERATING REVENUES
OPERATING EXPENSES
OPERATING TRANSFERS (OUT)
OPERATING INCOME (LOSS)
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
24,350,443,00 24,452,461.00 23,716,961.00 (735,500.00)
2,625,000 00 7,101,740.00 7,101.740.00 1)00
28,391,509.00 32,970,267.00 31,958,067.00 (1,012,200.00) -3.07%
35,427,915.00 38,634,925.00 536,965,080.00 1,669,845.00 4.32%
0.00 11,055.00 11,055.00 0.00 0.00%
157,036,406.00), ($5,675,713.00) ($5018,068.00) $657,645.00
23,974,989.00
$18 956 921 00
Favorability primarily due to Salary & FB $657,400 turnover, Contractual Svcs $1,232,310 for efforts to
reduce communication costs by eliminating low use connections & reducing maintenance on network
equipment Favorable Commodities $4,400 for reduction in printing supplies due to anticipated items
printed locally. Favorability partially offset by increase in projected Internal Svcs ($215,915).
-301% - Unfav due to decrease in charges to OC Dept Development ($2,150,675) & Imaging Oper & Vey ($115,404)
Urdav. Partially offset by favorable Non-GovFI Development $1,521,432 & Dept. Operations $10,000.
0 00%
Information Technology - Telephone Communications (675)
58,061,241.00 58,061,241.00
771,726.00 775,528.00
0.00 28,827.09
8,832,967.00 8,865,596.00
4,934,696.00 4,949,167.00
150,000.00 150,000.00
$3,748,271.00 $3,766,409.00
$1,960,268.00
2,850,165.00
1,716,500.00
6,526,933.00
8,946,482.00
000
31,960,268.00
2,850,819.00
1,760,092 00
6,571,179.00
8,947,136 00
0.00
0 00%
8 39%
-2.43%
0.00 0.00%
Far. Primarily due to Software Maint $400,000 antidpated support on the Records Mgmt Syst.
Favorability partially offset by unfav. Indirect Cost ($75,700) subsequent to budget projection; unfav.
Equip maint ($24,000) & Parts & Accessories ($77,000) due to increase in maint for aging LiveScan equip
Unfav 1SF Info tech Development ($88,000) due to addl assistance for Mugshot & Field Base Reporting.
0.00
160,246 00
132,800.00
Unfavorable E911 Surcharge due to slow growth in land lines ($300,000) designated for new system.
Favorable External agency $307,500 due to timing of new system implementation, offset by unfavorable
($500,900) delay of Gain on sale of old system. Favorable Interest Income $90,000 due to improved return
and available cash. Favorable Leased equipment revenue $100,000 and Parts & accessories revenue
$154,500 also due to timing of implementation of new system.
($402,500,00) -4.99%
254,500,00 32.82%
0.00 0.00%
(148,000.00) 27.82%
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
INTERNAL SERVICE FUNDS
INFORMATION TECHNOLOGY
AMENDED
BUDGET
ADOPTED
BUDGET
'Information Technology - CLEWS (635) I
FY 2005
FORECAST
VARIANCE
FAMI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$2,087,268.00
2,884,065.00
1,760,092.00
6,731,425.00
8,814,336 00
0.00
($2,082,911.00)
12,135,402.39
$10,052,491.39.
$7,658,741 00
1,030,028 00
26,827.00
8,717,596.00
3,968,287.00
150,000.00
64,599,309.00
32,840,064.93
$37,439,373.93
Information Technology - Radio Communications 1660)
OPERATING REVENUES:
Outside
Inside
OPERATING TRANSFERS IN
TOTAL OPERATING REVENUES
OPERATING EXPENSES
OPERATING TRANSFERS (OUT)
OPERATING INCOME (LOSS)
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
OPERATING REVENUES.
Outside
Inside
OPERATING TRANSFERS IN
TOTAL OPERATING REVENUES
OPERAtING EXPENSES
OPERATING TRANSFERS (OUT)
OPERATING INCOME (LOSS)
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
5127,000.00 8.38% Favorable due to increase CLEMIS membership $49,660; inc Rebelled chgs $57,300 & LiveScan Maint
$12,630. Fay. Interest Income $7,500 due to improved returns.
33,246.00 53.20% Favorable due to increased Sheriff Contracted Services $33,246.
$293,046.00
Overtime (512,000) unfavorable due to implementation of new system: Utilities ($10,000) unfavorable due to
timing of tower construction; Indirect cost 643,200 favorable. Unfavorable Rent ($35,000) offset by equal
980,900.00 19.82% Tower Charges favorability, lease classification; Equip Repairs ($25,000), Expendable Equip. ($20,000)
and Parts ($95,800) unfavorable due to maintenance of old system, offset by revenue and favorable Small
Tools $10,000. Professional Svcs. $75,000 favorable due to lower than anticipated expense of new system.
(1(10% Unfav. Office supplies ($2,000) due to increased usage for new system. Favorable depreciation $772,000
due to timing of deployment of new system. Interest on debt $300,000 favorable due to extension of E911
surcharge. ISF Maintenance charges ($20,000), Info Tech Operations ($12,000), Motor Pool ($14,700),
Print Shop ($2,000) and Telephone ($5,1000) all unfavorable due to expenses related to new system.
($2,419,549.00) ($2,375,957.00)
0.00
$832,900.00
($1,100.00) -0.72%
0.00 0.00%
(1,100.00) -0.21%
12,500.00 2.14%
0.00 0.00%
($47,477.00) $11,400.00
'Fire Records Management ( 531)
OPERATING REVENUES:
Outside
OPERATING TRANSFERS IN
TOTAL OPERATING REVENUES
OPERATING EXPENSES
OPERATING TRANSFERS (OUT)
OPERATING INCOME (LOSS)
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
Favorable Outside Agency revenue $4,100 due to addition of member agency; unfavorable Rebilled charges
($6,800) due to timing of connectivity billing offset by favorable communication cost. Favorable Interest
income $1,600 due to improved returns and higher CaSh balance.
Favorable Salaries and Fringes $22,500 due to decreased overtime and on call salaries. Communication
cost favorable $6,800 offset by Rebilled charge revenue; Equipment Repairs 8 Maintenance $15,400 and
Personal Mileage $1,400 favorable due to decreased usage. Software unfavorable ($5,600) for new agency
offset by revenue and favorable Software support $2,600 Non-controllable Indirect cost ($30,800)
unfavorable. Travel and Conference $5,000 favorable due to cost cutting. ISF Into Tech Development
($11,700) unfavorable due to unanticipated usage, partially offset by favorable Info Tech Operations $7,200.
$152,700.00
373,800.00
526,500.00
585,377.00
0.00
I$58,877.00
$152,700.00
373 800.00
526,500.00
585,377.00
0.00
11581877.001
$151,600.00
373,800.00
525,400 00
572,877.00
0.00
496,363.61
$448,886.61
COUNTY OF OAKLAND
FY 2005 SECOND QUARTER FORECAST REPORT
INTERNAL SERVICE FUNDS
INFORMATION TECHNOLOGY
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2005
FORECAST
VARIANCE
FAW(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
FY 2005 BUDGET AMENDMENTS
FY 2005 BUDGET AS ADOPTED $ 376,845,339.00
BUDGET AMENDMENTS
M.R. #04287 - 10/21/2004 *
Management & Budget - E-Financial System - Phase II
M.R. #04317 - 11/18/2004
Human Services - SAMSHA Grant Acceptance
M.R. #04318 - 11/18/2004
Human Services - MDEQ Reimbursement Agreement
M.R. #04313 - 11/18/2004
Board of Commissioners - Alliance of Coalitions of Healthy Communities
M.R. 04329 - 11/18/2004
Sheriff & Human Services - FY 2005 Jail Alliance Grant Acceptance
M.R. #04311 - 11/18/2004
Sheriff - Patrol Contract Amendment #2 Commerce Twp.
MR. #04312 - 11/18/2004 *
Public Services - OMNI Data Capture Project
MR. #04335 - 11/18/2004 *
Information Technology - CLEMIS Community Crimewatch
M.R. #04356 - 12/09/2004 *
Board of Commissioners - Law Library Computer Equipment Grant
M.R. #04341 - 12/09/2004
Community & Economic Development - Delete Account Clerk II Position
M.R. #04344 - 12/09/2004
52nd District Court Division II - Sobriety Court Fee
M.R. #04349 - 12/0912004 *
Sheriff - Emergency Communications Center Renovation & Equipment
M.R. #04367 - 12/09/2004
County Executive/ERP - Hazardous Materials - Emergency Planning Grant Accept.
$ 3,671,938.00
$ 17,500.00
$ 68,245.00
$ 50,000.00
$ 72,978,00
$ 378,647.00
$ 60,000.00
$ 675.000.00
$ 44,800.00
8 (63,514.00)
$ 18,750.00
$ 725,000.00
8,700.00
60
M.R. #04369 - 12/0912004
FY 2004 Year End Report *
Drain Commission - Water & Sewer Master Plan $ 1,493,924.31
Board of Commissioners - Computers for Library 24,300.00
Carry Forwards $ 2,813,355.74
Encumbrances $ 1,078,886.16
$ 5,410,466.21
M.B. #04339 - 12/09/2004
Human Resources - Reorganization
M.R. #04347 - 12/09/2004
Sheriff - Patrol Contract with Oxford Township
M.R. #04346 - 121D912004
Sheriff- Use of Forefeiture Funds/Equip., DARE, Internet and Drug Awareness
$ 53,952.00
$ 73,359.00
$ 35,000.00
TOTAL AMENDED BUDGET AS OF 12/31/2004 (1ST QUARTER) $ 388,146,160.21
* Denotes use of Designated Fund Balance
M.R. #05011 - 01/2712005
Sheriff - FY 2005 Off-Road Vehicle Grant
M.R. #05021 - 02/17/2005
Sheriff - 2005 Auto Theft Prevention Grant Amendment
MR. #05032 - 03/10/2005
Circuit Court - Use of Mediation Funds
M.R. #05061 - 03/24/2005
FY 2005 First Quarter Forecast & Budget Amendments
Info Tech - Future Tech. Replacement $ 362,000.00 $ 2,182,072.07
Sheriff - Oakforce Reimbursement 5,111.15
M & B _C.R.I.M.P. 1,649.00
Non-Dept. - West Nile Virus 500,000.00
Sheriff - Transport Van Upgrade 68,452.00
County Executive - Emergency Center Upgrades 2,040.00
Human Services - Doctors/Hospitals (Indigents) 500,000.00
Circuit Court - Settlement Week Videos 14,150.00
Prosecutor - New Laptop Computers 30,510.92
M 8, B _ Equalization GPS Cell Phones 19,975.00
M & B _ Convention Facility Tax 70,573.00
Sheriff - Diverted Felons 107,611.00
TOTAL AMENDED BUDGET AS OF 03/3112005 (2ND QUARTER) $ 390,462,413.28
2,400.00
$ 22,531.00
$ 109,250.00
6k
Number of
Accounts
Amount Waived
TOTAL 200 $521,787.65
Interoffice
MEMORANDUM
to: Nancy Fournier, Fiscal Services
cc: Judi Lockhart, Reimbursement
from: Joyce Raczka, Reimbursement
re: Inmate Waived Report
date: April 5, 2005
Submitted for your review is the inmate Report for 2005 for the Months of Jan, Feb and
Mar.
JAN
FEB
MAR
05 063332 CZ 68 $138,682.65
05 063989 CZ 74 $194,234.00
05 064611 CZ 58 $ 188,871.00
From the desk of....
Joyce Raczka
Reimbursement
1200 N Telegraph Road
Pontiac, Michigan 48343
40e Te1:248-858-7368
fax:248-975-4288
L ,
Number of
Accounts
Amount Waived
TOTAL 171 $ 377,927.00
Interoffice
MEMORANDUM
to: Nancy Fournier, Fiscal Services
cc: Judi Lockhart, Reimbursement
from: Joyce Raczka, Reimbursement
re: Inmate Waived Report
date: April 5, 2005
Submitted for your review is the Inmate Report for 2004 for the Months of Oct, Nov and
Dec.
OCT
NOV
DEC
04 061502 CZ 46 $ 87,500.00
04 062110 CZ 67 $ 147,537.00
04 062679 CZ 58 $ 142,890.00
From the desk of....
Joyce Raczka
Reimbursement
1200 N Telegraph Road
Pontiac, Michigan 48343
Tel:248-858-7368
fax:248-975-4288 63
Resolution #05107 June 16, 2005
Moved by Wilson supported by Coleman the resolutions on the Consent Agenda be adopted (with
accompanying reports being accepted).
AYES: Coleman, Coulter, Crawford, Douglas, Gershenson, Gregory, Hatchett, Jamian, KowaII,
Long, Melton, Middleton, Molnar, Moss, Nash, Palmer, Patterson, Potter, Rogers, Scott, Suarez,
Wilson, Woodward, Zack, Bullard. (25)
NAYS: None. (0)
A sufficient majority having voted therefore, the resolutions on the Consent Agenda were adopted (with
accompanying reports being accepted).
9.10
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Ruth Johnson, 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 June 16,2005 with
the original record thereof now remaining in my office.
In Testimony Whereof, I have hereunto set my hand and affixed the seal of the County of Oakland at
Pontiac, Michigan this 16th day of June, 2005.
RutfrJohnsoff County Clerk