HomeMy WebLinkAboutResolutions - 2009.09.02 - 9942,g
September 2, 2009
MISCELLANEOUS RESOLUTION #09185
BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON
:N RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2009 THIRD QUARTER
FINANCIAL FORECAST AND FY 2009 BUDGET AMENDMENTS
?0 THE OAKLAND COUNT? BOARD OF COMM:SSIONERS
Chairperson, Ladies and Gentiemen:
WHEREAS Public Act 621 of 1978, the Uniform Budget.ing and Accounting Act tor
Local Units of Government, provides for adjustments to the adopted budget; and
WHEREAS in accoraance with Oakland County General Appropriations Act Section
22, which authorizes budget amendments for variances between the budgeted revenue
and actua_ 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) 2009 Third Quarter Financial Forecast Report has
identified several variances and budget amendments are recommended; and
WHEREAS the Sheriff's Office is requesting a budget amendment to use $4,000 in
Forfeiture Funds (CI account #222430 - Law Enforcement Enhancement Funds) for the
repair of a Forward Looking :nfrared Camera FLIR) used in the Sheriff's Helicopter
for night vision; and
WHEREAS a balanced budget amendment in the amount of $173,218 is recommended
to reallocate fringe benefits from the Sheriff's Corrective Services Division to the
Sheriff's Office and Investigative Forensics Services Divisions to more accurately
reflect anticipated expenses; and
WHEREAS a budget amendment in the amount of $14,150 is recommended for Human
Resources - Administration to cover expense of printing revised Merit Rules approved
per MR #09047, Telephone Communication expense for added "hot line" and cell phones
due to increased activity during 312 Arbitration with Sheriff Deputies, and brief
use of motor poci vehicle; and
WHEREAS sufficient funding is projected in the Human Resources-Workforce
Management Division's Recruitment Expense to offset this additional expense; and
WHEREAS the Community Corrections Division is requesting a balanced budget
amendment of $60,000 to reallocate funds within their budget to more accurately .
account for actual expenses between salaries and contracted services; and
WHEREAS the Medical Examiner's Office is requesting a balanced budget
amendment of $3,00C to reallocate funds within their budget to more accurately
account for film processing; and
WHEREAS Economic Development Administration is requesting a reallocation of
funds in the amount of $9,500 within their budget to more accurately reflect
anticipated operating expenses for printing and telephone communication charges; and
WHEREAS a balanced budget amendment totaling $24,000 is requested for the
Children's Village Division budget to reallocate funds within their budget to more
accurately account for actual expenses for laundry and cleaning; and
WHEREAS Community Corrections is requesting a budget amendment to transfer
$5,000 to :nformation Technology Fund to cover costs associated with IT enhancements
for the Offender Link Interface; and
WHEREAS a budget amendment is recommended to the CLEMIS Fund in the amount of
$3,569,9:3 to correct the FY 2009 Amended Budget to reflect actual operating
expenses for depreciation, professional services and miscellaneous; and
WHEREAS a budget amendment of $94,001 is requested in the Building Liability
Fund due to unfavorability in insurance as the result of a rate increase; and
WHEREAS the Department of Information Technology has requested a budget
amendment in the amount of $1.5 million to authorize use of IT Equity for
professional services woring on IT Planned Maintenance and Upgrade projects through
September 30, 2009; and
Finance Committee Vote:
Motion carried unanimously on a roll call vote with Zack absent
lt
I
WHEREAS the Sheriff's Office has incurred significant overtime in the amount
of S179,748 to implement the IXACS System (Jail Management System) used to track
inmates, and funds are available in the Sheriff's Booking Fee Tran.tng Deferred
Revenue Account (GL account #222450- Law Enforcement Enhancement Funds; to offset
costs to implement this system, and a budge: amendment is recommended.
NOW THEREFORE BE :T RESOLVED that the Board of Commissioners accepts the
Fiscal Year 2009 Third Quarter Financial Report.
BE :T FURTHER RESOLVED that the FY 2009 Budget be amended pursuant to
Schedules A and B.
BE TT FURTHER RESOLVED that revenue for the Sheriff's Office Corrective
Servises (CF Account :022248W be recognized to offset overage in Overtime used to
implement new software for- tracking inmates as foLlows:
GENERAL F7.= #10108
Revenues
4030301-112620-670285 Enhancement Funa $17.9,748
Total Revenues 5179,748
Expenditures
4030301-112820-712C20 Overtime
Total Expenditures
5179,7 48
5179,7 48
Chairperson, on behalf of the Finance Committee, I move the adoption of the
foregoing resolution.
FINANCE COMMITTEE
1-7f)
Sheriffs Office
Revenues
4030601 116220 670285 Patrol Services - Enhancement Funds
Total Revenues
4,000.00
4,000 00
Public Services - Community Corrections Division
Expend:tures
1070401 1131130 730373 Contracted Services - Alter. Incarcer.
1074401 113060 702010 Salaries - WVVAM
1070401 113060 722790 Fringe Benefits/Soo. Sec - WWAM
1070401 113060 722750 Fringe Benefits/Workers Comp - WWAM
1070401 113060 722820 Fringe BenefitWUnemploy - WWAM
1070401 113060 722770 Fringe Benefits/Retirement - WVVAINA.
Total Expenditures
Med Svcs - Film & Processing
Med Svcs - Equipment Maintenance
Total Expenditures
Econ Dev - Admen -
Marketing & Comm
Econ Dev Admin -
Econ Dev - Adrntn -
Marketing & Comm
Marketing & Comm
Printing
- Printing
Motor Pool
Telephone Comm
- Print Shop
- Telepnorie Comm
7,000.00
(7.000.00)
17,000.00
117,000 CO)
SGHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2909 THIRD QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 200E
AMENDMENTS
_ SPI F RAI ANCING AMEDMENTS
GENERAL FUND (#10100)
Dept Program Acct Fund Af1(L...hi Account Narne
Expendttures
4030101 115140
4030101 112584
4034901 115240
4030301 112650
Human Resources
Expend:tures
1060101 183010
1050102 183010
1050102 183010
1050104 183020
788001 68000
722770
722770
702010
Transfer Out to Sheriff Aviaton Fund
Sheriffs Office - FB Retirement
Sheriff invest Forensic Svs - FB Ret:re/n.ent
Sheriff / Corrective Svs - FE Salaries
Total Expenditures
4.000.00
37.849.00
.35,369.00
(4 73,218.00)
4,000,00
150.00
3.000.00
11,000.00
(14.150.00)
60,000.00
(57,522.00)
(870.00)
(708 00)
(120.00)
(780.00)
776661 HR-Ad mm - Motor Pool
778675 HR-Labor Relations - Telephone Comm
776666 HR-Labor Relations - Print Shop
731570 FIR-Workforce Mgmt - Recruitment Exp
Total Expendkures.
Public Services - Medical Examiner's Office
Expendituren
1070601 132030 750162
1070601 132030 730646
Economic Development
Expenditures
1090101 171000 731386
1090108 171030 731388
1090101 171000 776661
1090101 171000 778675
1090108 171030 776666
1090108 171030 778675
3,000.00
(3,000.00)
(4.500 00)
(5,000.00)
1,000.00
1,000.00
5.000.00
2,500.00
Total Exdenditures
GENERAL PURPOSE FUND
Child Care Fund (#20293)
Health & Human Services - Children's Village Division
Expenditures
1060501 112100 731493
1060501 112100 750112
1060501 112100 730870
1060501 112090 731059
Psychological Services
Drugs
CV Med Svcs - Fringe Benefits - Hose
General CV Oper - Laundry & Cleaning
Total Expenditures
4
AMOUNT
,7AVORABLE:
fUNFAVORAB,,E PERCENT
$ 2.531.205.00
SUB-TOTAL GENERAL FUND/GENERAL PURPOSE $ 422,640.999 00 $ 425,909.471.00
PLANNED USE OF FUND F3Ai-ANCE (1) $ 3 769.210 00 $ 7 431 540 71 $ 7.431 540 71 0.00%
7.55%
3.95%
1_55%
5.33%
6.21,
1 60%
4.82%
2.59%
2.62%
3.15%
9.22%
5.13%
4.40%
205%
67%
15 51%
4_32%
4.35%
0.63%
3 52%
3_54%
3 74%
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NON-DEPARTMENTALS 5 54,667.304 00 5 44,4131.725.59 s 44 197,225 59 0 64% 284,500.00
TOTAL GOVERNMENTAL EXPENDITURES $ 426,410,209.00 S 434,341 ,011 .71 S 419.461,811.71 5 14,879,400.00 3.43%
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
FY 2009 BUDGE--
AD:10'E3 AS FY 2009
pUDCLI AMENDED FORECAST
REVENUES
GENERAL FLND
Taxes
Federal Grants
State Grarts
Other Intergovernmental Revenue
Charges ifcr Services
Indirect Cost ReCOvery
Investment IrIcame
Other Revenues
$ 249.631 790 00
511,456 00
18.300,81)7 00
11.263,363.00
89,752,889 00
8 495.310 00
3.570,500.00
41 015,352 [10
$ 249,631.290 00
591,120 00
19 335,529 00
1-.703,914 00
9).751.948 00
8,517,25000
3.399.949 no
41,913,441 90
252.162 495 00
59 t 120 00
18 797.829 OD
11.696,71400
84.767,824.03
9.217,280 00
2,276.549 00
42.188,78" ,00
$ 421,698,502.00
G537 7M 00;
167,2CC 00;
700,003.00
(1.123,400.00)
270,340.00
(5,210,870.001
G
-2 78%
-0 57%
-7.81%
8.22%
•33.04%
064%
-1 22%
TOTAL GF/GP FUNDS 5 426,410,209.00 5 434,341,011.71 $ 429,130,132.71 $ (5,210,879.001 .1.20%
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit court
52nd OStricl COJrt
Probate Court
TOTAL ADMIN. OF JUSTICE
LAW ENFORCEMENT
Prosacuiing Attorney
Snert41
-AW ENFORCEME T
GENERAL GOVERNMENT
ClarkfRogster of Deeds
Treasurer
Board of Commissioners
Library Boarc
Water Resources Commissioner
TOTA. GENERAL GOVERNMENT
COUNTY EXEC,..i7 IVE-
GoLdity Executive Admr.
Management and Budget
Central Services
Facilities Management
Human Resources
Health ono Fthman Services
Public Services
Economic Dev. aid Comm Affairs
TOTA._ COUNTY EXECUTVE
TOTAL DEPARTMENTS
$ 50,519.269.0o
17,224.366.00
6.313,667.00
$ 74,157.322 00
18.882.810.00
124.880.516.00
5 143,753,32600
12.146.010 00
3,672.745 00
3,052.055.00
2.567.666 00
5.426,109.00
$ 27.064.585 00
5,073,960.00
21.414,985.00
2.369.873.00
1,538.266.00
4,370,348 00
65,362,762.00
16,374581,00
7,252.917 00
$ 125,757,672 00
$ 371,742.905.00
$ 57.651652.01
17,400.927 31
6.400:824.47
5 81.459.643 79
20.204,635.52
128,177,548.63
$ 148,362.384 15
12,435.346 25
4,269,992,21
3.053,626,71
2.577 640 69
6,708.843.34
$ 29.045.449.21
$ 7.595.776 52
21,924.30767
2,467.277 90
1,538,255 00
4,66' .75860
65,117,110 1'2
16,793,695 43
7,873,616 47
$ 130,971,8013 97
5 380,859,256 12
$ 53 2a5 60), 01
16.70E1 504 31
6.300.959 47
$ 76.305.071 79
18.938,035.52
126,130,448 63
$ 145,058.484
1)835,34626
4.159.394 21
2.973.626 71
2 495.640 59
6.090,063.34
$ 27 554.09' .21
7.254.676 52
21 475 107.87
2,426.077.30
1.254.265 00
4 460,308.66
65 151.590 12
16.688695 43
7 596.016 47
126,336.738 97
5 375 264.356 12
4.356.264 00
692.423 00
105 365 00
$ 5,154.572.00
1,266,500 90
2,047.100.00
$ 3,3 3.9001)0
600.000 00
111)598 DJ
80 000 00
82.300 00
613 760 00
$ 1 491.358,00
341,10000
449.200 DC
41,200.00
254.000 00
201,450.00
2.965,520.00
105,000 00
277.600.1)0
$ 4:635,070.00
$ 14.594,90000
Genera; Fund/General Purpose
Favorable/(Orfavorable) $ 9.608.521.00 $ 9,668,521.00
(1) Note Mat report forecasts Planned Use of Pund Balance win a zero variance rr: order to show a balanced budget No revenue will actually be received
6
ACCOUNT NUMBER
PROPRIETARY / SPECIAL REVENUE FUNDS -SELF BALANCING AMENDMLUIL.
Dept ID Program Acct Fund Aff Oper Unit Account Name
Sheriffs Aviation Fund (#58000)
Revenues
4030601 1 1 6223 695500 10100
Total Revenues
Expenditures
4030601 1' 6220 730646 Equipment Maintenance
Teta, Expenditures
Community Corrections Grant (#2737q1
Excenditures
1070401 113000 773633 Non-Gov't IT Development
1070401 113000 788001 63600 Transfer Out to IT Fund
Total Expenditures
Transfer In from General Fur'
Information Technology (453600)
Revenue
1080101 152000 695500 27370
Expenditures
1080201 152010 731458
Information Technology - CLEMIS Fund (#53500)
Revenues
1080301 173080 631253
1060301 116020 631372
1080301 116020 655335
1080301 116020 690189
1080301 115150 665882
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2009 THIRD QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
730926
731346
731458
732018
750119
750413
761121
Building Liability Fund 1467700)
expenditures
1010502 182000 796500
1010502 182000 730940
Expenditures
1080305 116320
1080301 116020
1080305 116020
1080305 116020
1080305 116020
1080305 116150
1080305 116020
Transfer In from Comm Corr Grant Fund
Total Revenues
IT - Professional Services
Total Expenditures
Electronic Traffic Ticket
OC Depts Operations
Income Invesments
Cap.ta: ContriOutions
Prior Year Balance
Total Revenues
Inoirect Cost
Peronal Mileage
Professional Services
Travel & Conference
Dry Goods
Parts & Accessories
Depreciation
Total Expenditures
Budget Equity Adjustment
Insurance
Total Expenditures
FY 2009
AMENDMENTS
4.00030
4,000 00
4.000,00
4,000.0(1
$ (5,000.00)
5,000 00
5 00.:,.00
5.000:ao
5,000.00
5,000.00
$ (145.000.00)
413.000 00
(47.000 00)
356.502 00
(4.147.415 00)
$ (3569,913.00)
$ (26,024.00)
(1,500.00)
(750,000.00)
(5,000.00)
(2.250.00)
(66,250.00)
(2.718,889.00)
$ (3,569,913.00)
$ (94.001 00)
94.001.00
5 249,317,790.00 $ 249,317,790.0e $ 251.856,995.00 5 2,539,20500
98.500 00
120,900.00
95,000 00
249,631,290.00 $
68,000 00 $
82,000 00
46,000.00
70,488.00
245,000.00
511,488.00 1
- $
1,000.00
5,099,807.00
13,200,000.00
98,e00 00
120,000 CO
95,000 00
249,631,290.00 $
68,000 00 $
70,412.00
84,980.00
46,000.00
21,728.00
300,000.00
591,120.00 $
- $
1,000 00
84,980.00
5,089,300.00
14,160,249 00
98,500.00
170,000.00
8.1,00000
252,162.495.00 $
68,000.00 $
70,412 00
84,980.00
46,000.00
71,728 00
300,000.00
591,120.00 $
-
1,000.00
84,980.00
4,923,300.00
13,788.549.00
(teeite0C)
2,531,205.00
(166,000.00)
(371,700.00)
54,000.00 $ 54,000.00 $ 19,000.00 (35,000 00)
4,500.00
2,75000
300,000.00
1,962,113.00
$ 11263,363.00 $
4,500.00 4,500.00
2,150 00 2.750 00
330,000.00 347,800 00 17,800.00
1,962,113.00 1,962,113 (10
11,763,914,00 $ 11,696,714.00 $ (67,200.00)
Reduction in CPBC Contract
Ilefav variance is due to reduced spending within the Child
Care Fund The hiring freeze arid efforts in reducing
operating expenditures and capital purchases has reduced
spending within the fund creating savings within the
departments' budgets This results in less expenditures
being submitted to the State for reimbursement.
100.00%
0.00%
0.00%
0.00%
-3.76%
-2.62%
COUNTY OF OAKLAND
GENERAL FUND i GENERAL PURPOSE REVENUES
FY 2009 THIRD QUARTER REPORT
Adopted
Bud gel
Amended
Budget
FY 2009
FORECAST
Amount
Favorable
funfavorable) Percent Explanation of Significant Variances
OTHER INTER-GOVERNMENTAL REVENUES (620000 - 626999)
Noe-Departmental 3 8,940,000.00 $
TAXES (661000-601999J
Property Taxes - July Ta K Levy
Other Taxes - Delinquent Tax - Prior Years
7feasurer Payment in Lieu of Taxes
Other Taxes - Trailer lax
Total Taxes
FEDERAL GRANTS (610000-610999)
Sheriff - Patrol
Sheriff - Corrective Services
Prosecuting Attorney
Homeland Security - Disaster Control
Health Division
Children's Village
Total Federal Grants
STATE GRAN TS (615000-615999)
Sheriff - Patrol
State Match Foster Care
Prosecuting Attorney
ec.:on Development
Health Division
Outside Agencies - Child Care Subsidy
Total Slate Grants
MIS - Homeland Security
Circuit Colin
District Court
Sheriff
Non-Departmental
Total Other Intergovernmental Revenue
1 07% Fereeest is based on the 7009 April Equalization Report
Any favorability at year end will be designated for tax tribunal
changes.
0.00%
0.00%
.842% Deerease in number of mobile homes in the county.
1.01%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0,00%
-0.53% Decreased State Court Equity payments. The budget for
Cony Facility Tax will be amended alter final payment and
will include the offsetting budget amendment for Substance
Abuse
-64.81% (Unfav) due So limited funding by locals for the purchase o?
Tornado Sirens.
0.00%
0.00%
5 39% Additional funding ter a pimp boat acquisition.
0 OCI%
-0.57%
$ 18,300,807.00 $ 19,335,529.00 1 18.797.829.00 $ (537,700.00) -2.78%
9.410,551.00 $ 9.360,551.00 $ (50,000 00)
' Revenue variance is partially offset by an expenditure variance
CHARGES FOR SERVICES 1630000-5359991
Administration of Justice
Circuit Court - 3,162,304 00 $ 3,062,804.00 $ 2,933,137 00 f129,66700)
Circuit Court - Family Division 1,808,600 00 1,808,600.00 1,970,880.00 162,280.00
District Court - Division I (Novi) 4,183,804.00 4,183,804.00 4,009,20400 ( 174,600 00)
District Court - n ivision II (Clarkston) 2.775,309 00 2,242,623.00 2,029,623 00 (713.000 001
District Court - Division III (Rochester Hills)
D istrict Co - Division IV rfroy)
Probate Court - Estates and Mental Health
4,289,772.00
2,283,210.00
.56f .300.00
4,289, 712 00
2,283,210 00
566,300.00
4,037,772 00
2,061,060 00
576.300.00
(257,000 00)
(216,150 00)
(40,000 00)
COUNTY OF OAKLAND
GENERAL FUND GENERAL PURPOSE REVENUES
FY 2009 THIRD QUARTER REPORT
Amount
Adopted Amended FY 2009 Favorable
fludget Budget EgREcAST funfave•rabic) Percent Explanation of Significant Variances
-4 23% Unfav. variance is due to a decrease in Mediation fees
collected. The decrease in fees collected is due to an
increase n the public's use of alternative dispute resolution
other than Mediation Please note: Mediation payments
have a 100% offset expenditure account
8.91% Fay, variance is due to an increase in Defense Attorney fees
and Gov't Board and Care payments being collected
-4.17% Unfav, variance is due to defendants' inability to pay fees to
the court. The court is experiencing a decrease in their
ability to collect fees, fines arid costs due to rising
unemployment, the credit crisis and other negative
economic external factors. To mitigate the amount of
revenue shortfall, the Court implemented on April 1, 2000
the fee iiicreases the court purposed during the f•Y 7010
budget task, and on June I, 2009 the court implemented a
new fines and costs schedule The amounts shown include
a conservative financial effect of the above increases
-9 Unfav variance due to a reduction in State Law cases
resulting in a shortfall ($180,000.) State Police re-allocating
their resources to diner parts of the county and Governor
Granholm's Executive Order 2009-22 restricting State Police
in some of their functions to reduce cost are the primary
reasons for the State I aw case decrease (See Division I
Explanation).
-.5 87% Unfav. variance (See Division I explanation)..
-9.47% Unfav. variance (See Division I Explanation).
7.06% Untav due to loss hi Gross Estate Fees Gross Estate fees
are contingent on the gross value ,o1 the estate, ability to pay
the lees, and the number Ur cases filed.
Total Administration of Justice $ 18,519,859.00 $ 18,437113.00 8 17,573,975.00 $ 863.137 00)
Law Enforcem.nt
Prosecuting Attorney $ 213,300.00 $ 213,300.00 $ 254,600.00 $ 41,300.00 1935% Fay, due to yearly receipt of non-budgeted revenue. Class -
Fees, Fxtrachtion Recovery Fee, Microfilming, Welfare Fraud
Case Review This revenue is not budgeted due to the
intermittent and indetermiliate amount of receipts
Sheriffs Office 1,201,900.00 99,400.00 100,100.00 700.00 0.10% by due to receipt of Miscellaneous and Subpoena lee
revenue.
Sheriff - Administrative Services 197,100.00 314,600.00 312„200 00 (2,400.00) -016% Unfav. due to lower Reimbursement General revenue from
Iced service contract ARAMARK related to the closing of the
Jail Commissary Fund; partially offset by iocrease receipts of
Fingerprint revenue for teachers and yearly receipt of non-
budgeted revenue for Photographs. This revenue is not
budgeted due to the intermittent and indeterminate amount
of receipts.
• Revenue variance is partially offset by an expenditure variance.
Sheriff - Corrective Services Satellites
Sheriff - Emer Prep. '1 raining & Comm.
Sheriff - Patrol Services
Sheriff - Investigative Forensic Services
Total Law Enforcement
General Government
Clerk - County Clerk
267,166 00
12,445,200.00
269,091 00
12,445,200.00
269,091 00
9,111,200.00
15,918,631.00 $ (5237,962.00)
250,000.00 $ 50,000.00 75.00% Favorable ICMA rebate
30.000 00 0.00%
214,000.00 139,000.00 185 33% Increased activity from vendor reimbursement program.
0.00%
239.55% Fav. Reimb Salaries due to State of Michigan reinstating
funding for I. VPI operations 547,879 and the stipend for the
Director $4,800. Also Fav. Misc revenue $12,000 as a result
of more patrons printing material off the computer.
-26.21% Unfav Reimbursement General ($618,760) the result of
adchtional time needed for CAMS pioject
planningfrequirements phase: original estimate included
development/testing phase hours now expected in Fall
2009; offset by favorable salaries, fringes and drain
equipment unfav Soil Erosion Fees ($70.000) due to
decrease in building activitylpermits due to downturn in
housing market
-32.84% the Industrial Facilities Exemption Tax roll is collected and
recorded in the Treasurer's budget. If the Treasurer does
not collect the amount owed by the taxpayer on time, the IF T
exemption is revoked and falls hack to the general tax role.
This combined with re-valuations has decreased the amount
of revenue collected within the Treasurers budget.
Treasurer
Board of Commissioners
Library Board
Water Resources Commissioner
fetal General Government
County Executive
County Fxec - Administration
County Exec - Auditing
M&B Purchasing Division
3,291,641.00
1,100 00
27,000.00
1,169,113 00
20,297,454.00 $
200.000 00 $
30,000.00
/5,000.00
3,291,641 00
600 CO
27,000.00
2,627,427 00
21,156,503.00 $
200.000 00 $
30,000.00
/5,000.00
2,210.760 00 (1.080,881.00)
1,938,667.00 (588,760.00)
600.00
91,679 00 64,679.00
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FY 2009 THIRD QUARTER REPOR7
Sheriff - Corrective Services
Adopted Amended FY 2009
Budoet Budoet FORECAST
1,641,000.00 3,003266.00 3,065,366.00
Amount
Favorable
(unfavorable). Percent
62,100 00 2.01%
Explanation of Significant Variances
Fay Board and Care of $50,000 acid DUO_ Third Offense
revenue $16,000; oaritally offset by projected shortfall in
Misc revenue of (53,900)
000%
4.83%
0.03% Fay due to increased Inspection of Boat Livery and Misc
revenue receipts.
8.83% Fav due to increased Gun Registration revenues $19,700
and Refund Forensic t ab. Fees of $25,400
1,325,925.00 1,226„926.00 1,325,926.00 -
473,716.00 473,716.00 496,616.00 22,900.00
32,744,629.00 32,935,559.00 32,946,059.00 10,500.00
108,500.00 510,690.00 555,790.00 45,100.00
$ 37,901,071 00 $ 38,876,457.00 $ 39,056,857.00 $ 180,200.00
2,495,634.00 $ 2,495,634.00 $ 2,296.634 00 S (199,000.00) -7.97% Unfav. Appeals Appellate Court (54.000), Assumed Names
($30,000), Bond Fees ($30,000), Co Partnership New
($5,000), f orfeitue of Surety Ponds ($60,000), Jury Fees
($50,000) and Passport Fees (120,000) due to lower than
anticipated activity and downturn in the economy .
Clerk - Elections
Clerk - Register of Deeds & Micrographics
0.00%
(3,334,000.00) -26.79% Unfav. Land transfer Tax ($2,000,000), Mortgages
($1,000,000) and Recording Fees (5300.0.00) due to the
downturn in the housing market and Microlilming ($34,000).
due to a decrease in volume from outside users.
' Revenue variance is partially offset by an expenthture variance
Adopted
Budget
2,781.141.00
415,600.00
158,000.00
Amount
Amended FY 2009 Favorable
fiudoet FORECAST funfavorablei
2,779,541.00 2,779,641 00
415,600.00 4.15,600.00
158,000.00 153,000.00
Percent Explanation of Significant Variances
(100%
0.00%
-3.16% Decrease in proceeds from vending machines (5,000 00)
3,674,887.00
150,000.(1,0
3./14,667.00
150,000 00
7,665.247 00
300 00
2.879,530.00
413,000 00
66,360.00
300.00
3,019,530.00
392,000.00
66,360.00
30(100
2,974,530.00
302,000.00
46,555.00
303,000 00
785,887 00
2 (1,000 00
199,000 00
735,087 00
411,000.00
723,000.00
735,887 00
7 71,000 00
(45,000 00)
(19,805.00)
Fay. due to NO HA? Program reimbursement from
participating communities 3165,000, offset by corresponding
cosi increase, as wee as lower sale of maps caused by
housing market slowdown ($25,000)
000%
0.00%
1.40,000.00 51.66%
COUNTY OF OAKLAND
GENERAL FUND/ GENERAL PURPOSE REVENUES
FY 2009 THIRD QUARTER REPORT
M1,/l&B - Equalization Division
M&D - Fiscal Services Division
Central See/ices - Support Services
Facilities Engineering
[lumen Resources 800.00 800.00 1,800.00 1,000.00 125.00% HR received national SHRM (Society for Human Resources
Management) award of $1,000 for submitting the Oakland
County 2008 Voluntary Separation Incentive Program as an
innovative approach towards dealing with the economic
- downturn. The program included reorganizations and
rieetinns without any layoffs. Oakland County was one uf
15 recipients to receive this award nationwide.
1-11-15 - Administration
HF1S - Health Division
HHS - Homeland Security
HI-IS - Children's Village
Public Services - Community Corrections
Public Services - MSU Extension
Public Services - Medical Examiner
Public Services - Animal Control
Economic Dev. & Comm Affairs - Admin
Economic Dev. & Comm Affairs - PEDS
100.00%
(1,049,420.00) -28 25% (Unfav) t ab Charges ($177,000), Flu 3rd Party ($320,000),
Well Permits (,225,000), Sewerage Permits ($450,000),
Immunizations ($75,000), and Control Plats (814,000) drip In
slow economy. Also, the Health Division is no longer
receiving administration fees on immunizations which was
replaced by a fee structure Unfav variance offset by lay .
[nod Service License $206.580
000% -
-1.49% Decrease in out of home placements From other counties
0 00%
Untav. Reimbursement General iS57 ,805) due to fewer
participants in the Natural Sciences programs and the Foss
of the AmeriCorp reimbursement (51,000) from the State
which covered misc. expenses for an AmeriCorp employee.
Also, Unfav. Reimbutsernent Postage ($1,000) due to a
decrease iri postage reimbursement from Michigan State
University. Note expenditure offset.'
-10.75% Unfav. Autopsies ($25,000), Medical Services ($8,000) and .
Misc. ($10,000) due to lower than anticipated caseload;
partially offset by Fay. Cremation Approval Fees $35,000
due to a higher than anticipated caseload.
(24,000.00)
lotai County Executive
Non-Departmental
Non-Dept - Charges for Services
Total Non-Departmental
Total Charges for Services
5 12,034,505 00 $ 12,28 t,785 00 5 11,468,560 00 5 (813,275 00)
$ 1,000,000.00 $ 1.000,000 00 750,000 00 5 (250,000.00)
$ 1,000,000 00 S L000000 00 $ 750.000 00 S (250.000 00)
S 89,752,889.00 $ 91,/51,948.00 3 6,4,767,824.00 $ (6.984,124.00)
• 25.00% Unfav Commission due to decreased usage of pay phones.
-25.00%
-7.61%
• Revenue variance is partially offset 1y an expenditure variance.
20,500.00 $
150,000.00
3,500,000.00
$ 3,670,500.00 $
20,500 00 $
150,000 Cl)
3,229,449 00
3,399,949.00 $
142,600.00 $
34,826.00
419,340.00 $
611,780 00
20,395 00
1,000.00 1,000.00
4,300.00 4,300.00
16,000 00
60,000.00
417,500.00
3,500,000 00
44,000.00
60,000.00
41 -1,500.00
3,500,000 00
36,840,126 00 36,540.125 00
41,015,352.00 41,918,441.00
410,340.00 $
621.680.00 9,900.00
20,395.00
0.00%
1.62% Fav due to receipt of Refund of Prior Years Expenditures.
0.00%
439.00 Public Services
4400000
60,000 00
117,500.00
3,810,000 00
35,652628.00
42,188,781.00 $
5,357.00
1,000.00
56.00
30.00
4,300 00
728 00
231,330 00
3,769.210 00 $
3,769,210.00 $
2,991,694.11
4,439,646.00
7,431,540.71
0.00%
0.00%
426,410,209.00 -1.20% TOTAL GEN. FUND / GEN. PURPOSE REVENU 434.341,011.71 5 429,130,132.71 $0_ (5 210,87Ma
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FY 2009 THIRD QUARTER REPORT
Adopted
Budget
8,495,310.00 $
Amount
Amended FY 2009 Favorable
Budget FORECAST funfavorablel Percent Explanation of Significant Variances
8,517,280.00 S 9,217,280.00 $ 700,000.00 8.22% Final allocations were not available during budget process
and dici not anticipate ths level of grant awards, reimbursing
for indirect cost recovery
INDIRECT COST RECOVERY (640100)
INVESTMENT 11COME1655000-6559991
District Courts (Div. I - IV)
Clerk/Register of Deeds
Non-Departmental
Total Investment income
DJFIER REvvivEs. 070000-605500)
Prosecuting Attorney
Sheriff Office
Sheriff Office - Transfer In (Jail Pop Fund)
Circuit Court
District Court
Probate Court
Clerk/Register of Deeds
Treasurer
Library Board
Water Resources Commissioner
County Executive - EP Equipment
Management and Budget
Central Services - Support Services
Facilities Engineering
Health Division
Children's Village
Economic Development - Donation
Non Departmental - Donations
Non-Dept - Sundry
Treasurers' transfers
Nor-Dept - Transfers
Total Other Revenues
10,500 00 $ (10 000 0(1) .40.75% kInfav Otte to lower interest rates and volatile financial
markets.
66,000 00 (84,000 00) -56 00% Untav due to tower interest rates and volatile financial
markets.
2,200,049.00 (1,029,400.00) -31.88% Unfav due to lower interest rates and volatile financial
markets.
2,276,549.00 $ (1,123,400.00) -33.04%
5,357.00 100.00% Fay, due to cash overages.
100.00%
56.00 100.00% hav. due to cash overages.
30.00 100.00% Fay, due to cash overages.
0.00%
100.00%
0.00%
100.00%
100 00% Favorable Refuriti Prior Years Expenditure $230,752 and
County Auction $578
100.00% Favorable Refund Prior Years Fxpenditure and Cash
Overages
0.00%
0.00%
-71.86% Revenue not to expected as with previous year, which was
favorable due to prior year ad)llslments..
8.85% Total Property Tax Forfeiture Collections tees transferred in
from the DIRF are mole than originally anticipated The .
increase is due to a rise in deliquent tax collections in past
three years.
0.03%
0.64%
(10 000 0(1)
(84,000 00)
(1,029,400.00)
728.00
231,330.00
439.00
-
(300,000.00)
310,000 00
12,500.00
270.340.00
PLANNED USE OF FUND BALANCE (665000-065999)
Envoi) and Approp Carry Forward
General Fund - Prior Years Balance
Tote Planned Use of Fund Balance
2,991,694./1
4,430,846.00
7,431,540.71 $
' Revenue variance is partially offset by an expenditure variance.
26,974.00
261,245.00
26,974.00
267,344.37
Civil Criminal Division
Personnel Expenditures
Operating Expenditures 5,825,324.00 5076,10841 5,287,479.41 388,629.00
$ 2.,627,957.00 $ 2,624.921.34 $ 2,540,921.34 $ 84,000.00
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
CIRCUIT COURT
0.1....M.1,••nn•n•••••
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2009
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Judicial Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfer Out
Business Division
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 8,896,049.00 $ 8,825,266.05 $ 8,430,081.05 $ 395,185.00
4-4,017.00 344,592.48 344,592.48 -
222,888.00 526,024.32 526,024.32 -
$ 9,162,954.00 $ 9,695,882.85 $ 9,300,697.85 5 395,185.00
S 2,086,082.40 $ 2,092,011.69 $ 1,887,041.69 5 204,9 /0 00
26,974.00
725,484,37
4.48% - Fav. variance is due to the county wide hiring freeze and under flied
positions.
0.00% -
0.00% -
0.00%
4.08%
9.80% - Fav. variance is due to the county wide hiring freo7e, vacancies and
under filled positions
0.00% .-
15,66% - Fav. variance due to a decrease in phone rates and monthly Info
Tech department charges
41,860.00
$ 2,374,301.00 5 2,386,330.06 $ 2,135,900.06 $ 246,830.00 10.34%
Internal Support Expenditures
Transfers Out
2,409,621.00 2.571,536.90 2,571 536.90
19,212.00 10,212.00
$ 10)367,902.00 $ 10,891,778.65 $ 10,419,149.65 $ 472,629.00
3.20% - Fav. variance is due to the county wide hiring freem. vacancies and
under filled positions.
6.85% - Fav. variance is due to a decrease in Mediators and Appointed
Defense Attorneys. The Court is experiencing an increase in
alternative dispute methods of resolution other than mediation,
resulting in a reduction of expenditures. Please note: Mediation has
an unfavorable revenue line item that offsets the favorable
expenditure
0.00% -
0.00% -
4.34%
8.118t2009
I J
Operating Expenditures
Internal Support Expenditures
Transfer Out
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
CIRCUIT COURT
AMOUNT
ADOPTED AMENDED FY 2009 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Family Divislon/Juventle Maint.
Personnel Expenditures $ 13,651,164.00 $ 13,603,589.10 $ 12,185,989.10 $ 1,417,600.00 1042% - Fav. variance is due to the county wide hiring freeze. 17 FTE
positions are being filled with PTNE employees resulting in cost
savings in Fringe Benefits. Child Care fund positions are included in
these amounts, thereby resulting in a 50% revenue offset for
positions funded by the Child Care Fund.
12,817,652.00 13,927,292.68 12,804,222.68 1,123,07000 8.06% Fay. variance is due to a decrease in placements to State Institutions
of $1,572,122 ; offset by an increase in placements to Private
Institutions of ($449,052).
1,750,296.00 1,757,725.67 1,645,235.67 112,490.00 6.40% - Fay. variance due to a decrease in phone rates of $29,263 and
monthly Into Tech department charges of 583,227.
5,389,293.00 4,800,813.00 588,480.00 0.00% - Fav. variance is due to the Friend of the Court grant requiring less
than anticipated funding as a result of the county wide hiring freeze,
reduction in phone rates, reduction in info tech monthly department.
charges, and capital expenditure doticy. The FOC has 16 FTE
positions under filled wth PTNE positions.
$ 28,219,112.00 $ 34,677,900.45 $ 31,436260.45 $ 3,241,640.00 9.35%
Department Total
Personnel Expenditures $ 27,261,252.00 $ 27,145,788.18 $ 25,044,033.18 $ 2,101,755,00 7.74%
Operating Expenditures 18,713,967.00 19,974,967.57 18,463,268.57 1,511,699.00 7.57%
Internal Support Expenditures 4,644,050.00 5,122,631.26 4,968,281.26 '154,350.00 3.01%
Transfers Out &408.50500 4,820,025.00 588.480.00 10.88%
$ 50,619,269.00 $ 57,651,892.01 $ 53,295,608 01 $ 4,356,284 00 7.56%
8/18/2000
District Court Administration
Personnel Expenditures
Operating Expenditures
$ 49,279 00 $ 49,279.00 $
60,300.00 60,300.00
49,279.00 $
33,275.00 27,025.00
207,227.00 253,597 04
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
DISTRICT COURT
ADOPTED
BUDGET
AMENDED FY 2009
BUDGET FORECAST
AMOUNT
FAVORABLE
(UN FAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
0.00% -
44.82% - F-av variance of $21,000 due to the court discontinuing
the Mediation program and $6,025 due to a decrease in
use of the Visiting Judge line item.
Internal Support Expenditures
Transfers
Division 1 - Novi
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 109,579.00
$ 4,054,000.00
'1.083,641.00
466,381.00
$ 109,579 00 $ 82,554.00 $
$ 4,059,558.94 $ 3,963,558 94 $
1,088,641 00 1,057,141 00
429,611.59 63,000 00
0.00%
24.66%
2.36% -
7.89% -
12.79%
Fav. variance due to the county wide hiring freeze a r
under filled positions.
Fay. variance due to the department's effort to control
cost in printing of $10,000, Travel and Conference of
$5,000, Interpreter Fees of $6,500 and Postage and
Mailing of $10,000.
Fay, variance due to a decrease in phone rates and
monthly Info Tech Operations charges.
27,025.00
96,000.00
31,500.00
492,611.59
$ 5,604,022.00 $ 5,640,811.53 $ 5,450.311.53 $ 190,500.00 3.38% Total Division 1 - Novi
Division 2 Clarkston
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
Total Division 2 - Clarkston
$ 1,771,73.9.00 $. 1,779,533.90 $ 1,695,978.90 $ 83,710.00
628,950.00 628,950.00 579,950.00 49,000.00
235,597.04 18,000.00
55,557.00 72,811.00 72,811.00
$ 2,663,473.00 $ 2,735,046.94 $ 2,584,336.94 $ 150,710.00
4.70% - Fay. variance due to the county wide hiring freeze,
vacancies and under filled positions.
7.79% - Fav. variance due to the court's efforts on reducing
costs and a reduction in the amount of Court Appointed
defense attorneys being used.
7.10% - Fay. variance due to a decrease in phone rates and
monthly Info Tech Operations charges.
0.00% -
5.51%
71=--
8/18/2009
Division 3 - Rochester Hills
Personnel Expenditures
Operating Expenditures
$ 3.866,782.00 $ 3,871,324.00 $ 3,871324.00 $
416,912.00 416,912.00 298,489.00 118,423 00
Internal Support Expenditures 1,238,904.00 1,278,023.60 1,220,258 60 57,165.00
Division 4 - Troy
Personnel Expenditures $ 2,44.3,1316.00 $ 2,447,548.42 $ 2,396,548.42 $ 51,000.00
Operating Expenditures 521,458.00 516,458.00 471,458.00 45,000.00
Internal Support Expenditures 359,860.00 385,223.82 333,223.82 52,000.00
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
DISTRICT COURT
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2009
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
0.00% -
28 40% - Fay. variance due to the court's efforts to reduce overall
costs arid a reduction in the amount of Court Appointed
defense attorneys being used.
4.52% - Fay. variance due to a decrease in phone rates and
monthly Info Tech Operations charges.
$ 5,522,598.00 $ 5,566,259.60 $ 5,390,071.60 $ 176,188.00 3.17%
- lay, variance due to the county wide hiring freeze,
2.08% vacancies, and under filled positions.
8.71% - Fav. variance due to the court's efforts to reduce overall
costs and a reduction in the amount of Court Appointed
defense attorneys being used.
13.50% - Fay, variance due to less than anticipated amounts
needed in Print Shop of $7,008, Info Tech Operations
of $39,377, and Telephone of $5,615. Historically the
court has not spent the appropriated amounts within
their budget. The court does not foresee any changes
to current operations from prior years operations that
would result in additional spending.
$ 3,324,694.00 $ 3,349,230.24 $ 3,201,230.24 $ 148,000.00 4.42%
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 12,185,176.00
2,711,261.00
2,272,372.00
55,557.00
$ 12,207,399.26
2,711,261.00
2,409,456.05
72,811.00
$ 11,976,689 26
2,440,313.00
2,218,691.05
72,811.00
$ 230,710.00 1.89%
270,945 00 9.99%
190,765 00 7.92%
$ 17,224,366.00 $ 17,400,927 31 $ 16,708,504.31 $ 692,423.00 3.98%
8/18/2009
Estates/Mental Health
Personnel Expenditures
Operating Expenditures
$ 2,502,126.00
$ 2,257,729.00
714,072.00
$ 2,216,663.13 $ 2,216,663.13 $
737,323.00 652,313.00
0.00%
85,010.00 11,53%
$ 2,566,404.65 $ 2,481,852.65 $ 84,552 00 3.29%
Internal Support 839;760.00 886,433.69 950,130.69 (63,697.00) -7.19%
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
PROBATE COURT
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2009 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Judicial/AcIministration
Personnel Expenditures
Operating Expenditures
Internal Support
Transfer Out
$ 2,456,145.00
45.981.00
$ 2,465,851.65
99,431 00
122.00
$ 2,382,299.65 $ 84,552.00
99,431.00
122.40
3.43% Fav. variance is due to vacancies and under filled
positions.
Fay. variance is due to the effort to reduce capital
purchases as park of budget reductions and the
implementation of the Probate Court's new
Defense Attorney appointment system. The
system was approved during the FY 2009 budget
process
During the FY 2009 budget process a portion of
the Information Technology Operations line item
was inadvertently omitted, resutlIng in an unfav.
varrance
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support
Transfer Out
$ 3,811,561.00
$ 4,713,874.00
760,053.00
839,760 00
$ 6,313,687.00
$ 3,840,419.82
$ 4,683,514.78
836,754.00
886,555.69
$ 6,406,824.47
$ 3,819,106.82 $ 21,313.00 0.55%
$ 4,598,962.78 $ 84,552.00 1.81%
751,744.00 85,010.00 10.16%
950,252.69 (63,697.00) -7.18%
$ 6,300,959.47 $ 105,865 00 1.65%
8118/2009
Operating Expenditures 836,872.00 1,006,942,50 873,142 50 133,800.00
Internal Support Expenditures
Transfers
1,956,278.10
9,883.00
$ 5,650,949.26 $
1,956,278.10
9,883.00
5,258,649 26 $ 392,300,00
0.00%
0.00%
6.94%
1,893,005.00
$ 5,372,194,00
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
PROSECUTING ATTORNEY
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2009 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnei Expenditures $ 2,642,317..00 $ 2,61/.845.66 $ 2,419,345.66 $ 258,500.00 9.65% ray, due largely to vacant positions and under-fills,
13.29% Fav due to reduced use of Extradition Expense $75,517,
Expert Witness Fees and Mileage $19,580. and
Professional Services $25,000 used for phone call records
searches (Metro PCS), and interpreters. Prosecutor does
not plan to use Special Prosecutor line item $15,000.
There is also projected favorability in printing $9,661,
membership dues $10,000, microfilming $13,500, filing fees
$15,000, miscellaneous of $4,307, and travel and
conference $10,000; partially offset by increase in office
supplies ($39,965) and periodical and books ($12,000) due
to incoming new Prosecuting Attorney. Court Reporter •
Services unfav. ($12,000) due to expenses incurred which
are not currently budget.
Litigation
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
$ 9,645,800.00
$9,296.00
2,334.00
$ 9,603,798.84
59,296.00
2,334.00
1,090,063.00
$ 9,054,498.84
42,396.00
2,334.00
1,090,063 00
$ 549.300.00
16,900.00
5.72% Fav. due primarily to vacant positions and under-fills.
28.50% Fav due to lower personal mileage use.
0.00%
0.00%
$ 9,707,430.00 $ 10,755,491.84 $ 10.189,291.84 $ 566,200 00 5.26%
8/1812009
$ 2,100,825.00 $ 2,098,379.30 $ 1,954,279.30 $ 144,100.00
3.199.00 3,199.00 3,199.00
$ 2,104,024.00 $ 2,101.578.30 $ 1,957,478.30 $ 144,100.00
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
PROSECUTING ATTORNEY
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2009 FAVORABLE
FORECAST (UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
164,200 00
1,116,100.00
150,700 00
$ 1,699,162.00 $ 1,696,816.12 $ 1,532,616.12 $ 164,200.00
Warrants
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Appellate
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Department
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
$ 1,690,704.00 $ 1,688,358.12 $ L524,158.12 $
8,458.00 8,458.00 8,458.00
$ 16,079,646 OC $ 16,068.381.92 $ 14,952.281.02
907,825.00 1,077,895 50 027,195 50
1,895,339.00 1,958,612.10 1,958,612.10
1,099,946.00 1 099,946.00
6.87% Fay. due primer* to vacant positions and under-fills.
0.00%
0.00%
6.86%
9.73% Fay. due primarily to vacant positions and under-fills.
0.00%
0.00%
9.68%
6.95%
13.98%
0.00%
0.00%
6.27% $ 18,882,810.00 $ 20,204,835.52 $ 18.938,035.52 $ 1,266,800.00
li/18/2009
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2009
FORECAST
Internal Support Expenditures
Transfers
336,246.00 336,317.00 335.317 00 G.00%
0.00%
Administrative Services
Personnel Expenditures
Operating Expenditures
$ 1.843,127.00 $ 1.886,919.56 $ 1,809,019.56
879,842.00 932,956.76 752,856.76
77,900.00
180,100,00
Internal Support Expenditures
Transfers
367,589.00 367,589 00 367,589.00 0.00%
0.00%
Corrective Services
Personnel Expenditures
Operating Expenditures
$ 3,050.558.00
31,713,299.00
6,500,477.00
Corrective Services-Satellites
Personnel Expenditures
Operating Expenditures
$ 16,309,375.00 $ 16,460,843.00 S 16,207,143.00 $
310,800.00 327,700.01 331,400.01
7,820,265,00 8,262,507.36 8,262,507.36 0.00%
0.00%
5 46,034,041.00 $ 47,130,812 58 $ 46,110,412 58 $ 1,020,400.00 217%
Internal Support Expenditures
Transfers
1,540,879.00 1,544,664.98 1.544,664.98 0.00%
0,00%
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
SHERIFF'S OFFICE
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
- 0.00%
(6,300.00) -3.88%
Sheriff's Office
Personnel Expenditures
Operating Expenditures Unfav largely due to increased reimbursement of personal cell
phone usage, equipment maintenance, and rise of medical supplies.
$ 1,536,828.00 $ 1,533,463.05 5 1,533,463.05 S
47,202.00 162,282.00 168,582.00
$ 1,920,276.00 $ 2,032,062.05 $ 2,033,362.05 $ (6,300.00) -0.31%
4.13% Fay. due to underfills and vacancies (turnover).
19.30% Fay. largely due to reduced need for Uniform Cleaning $18,559,
Library Continuation $7,000, Office Supplies $18,041, Inmate
Recreational Supplies $6,500, and reduction in Uniform
Replacements $130,000 due to change in department policy.
$ 3,187,465 32 $
$ 31,886.633.93 $ 31,525,333.93
6,981,671 29 6,322,571.29
2,929,465.32 $ 258,000.00 8.09%
361,300.00
659,100.00
Internal Support Expenditures
Transfers
1.1.3% Fav. due to underfilis and vacancies (turnover)
9.44% Fay, largely due to Contracted Servloes of $309„442. Reduction in
jail population resulted in lower payments to food vendor
ARAMARK. Hospitalization of Prisoners line item $292,520
contracted with new hosptal at lower price Also, reduced need to
house prisoners outside of County $240,000. partially offset by
increased spending in Professional Services ($286,411) for
increased need for polygraph testing and Medical Exams of
($65,360). Favorable reductions in Bedding and Linen $30,000,
Culinary Supplies $20,000, Other Expendable Equipment of
$52,163 Groceries of $20,000, arid Medical Supplies of $46,749 are
all due to reduction in jail population.
753,700.00 1 54% Fav. due to underfills and vacancies (turnover)
(3,700.00) -113% 'inlay due to Personal Mileage and Travel Employee Taxable Meals
expenditures incurred by this division but budgeted in other
divisions.
%8,161,054,00 $ 18,333 207 99 $ 18,083,207.99 $ 250,000.00 1.36%
Emergency Prep., Tilling & Comm.
Personnel Expenditures 4,751,867 00 $ 4,788,613 00 $ 4.550,413.00 $ 738,200.00 4.97% ray. due lo underfills and vacancies (turnover). 8)18/2009
0.00%
0 00%
2395,762.00
$ 10,193,292.00
$ 40,315,253.00 $ 40.949,083.69 $ 40,181,683.60 S 167,400,00 0.41%
S 1,125.700 00
921,400 00
1.15%
9.10%
0.00%
0.00%
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
SHERIFF'S OFFICE
Operating Expenditure.s
ADOPTED AMENDED
BUDGET BUDGET
190,649.00 211,649.00
FY 2009
FORECAST
202,649.D0
AMOUNT
FAVORABLE
(UNFAVORABLE} PERCENT
15,000.00
EXPLANATION OF SIGNIFICANT VARIANCES
6.89% 1-av largely due to reductions in Employee Medical Exams, Officer
Fees, and Professional Services.
Internal Support Expenditures
Transfers
203,526 00
S 5,146,042.00 $
203,526.00 203,526.00
5,209,788 00 5 4,056,588 00 5 253,200.00 4.86%
Patrol Services
Personnel Expenditures
Operating Expenditures
Fa'. due to underfills and vacancies (turnover).
Unfav largely due to increased use of Office Supplies, Other
Expendable Equipment, Printing, and Personal Mileage.
$33,849,592 5 34,002,450.00 $ 33,807,K0.00 $
274,873.00 ,550,697..25 686,897.25
194,600.00 0.57%
(21,200.00) -4 12%
6,250,788.00 Internal Support Expenditures
Transfers
Investigative,Forensic Svcs
Personriel Expenditures
Operating Expend lures
Internal Support Fxpenditures
Transfers
6,286 935..44
2,397,352.00
605,828 00
$ 11,336,129.00 $
6.286,936.44
7,486,472.00 $
741,077 00 104,400.00
2,397,352.00
605,828.00
0.00%
0.00%
0.00%
12.35% Fay. due to lower usage of labatory supplies $31,275, expendable
equipment $29.150 travel and conference $3,777 fingerprint
supplies $3,000, software suuport rriainerlance $12,000 and drug
testing $25,198.
0.00%
0.00%
$ 7,280.860.00 $ 7,486,472.00 $
515,670.00 845,477.00
11,230,729.00 5 104,400.00 0.02%
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfer Out
97,244,948.00
8,720,513.00
18,915,055,00
$ 98,045,394.54
10,127,433.31
19.398,892.78
605.82800
$ 96,919,694 54
9,206,033.31
10,398.892 78
605,828.00
S 124,880,516 00 $ 128,111,548.63 $ 126,130,448.63 S 2,047,100,00 1.60%
8/18/2009
$ 727,779.00 $
40,382.00
193,369.00
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
727,779.00 $ 727,779.00 $- 0.00%
80,582.00 80,582.00 - 0.00%
202,050.26 202,050.26 - 0.00%
_ - - 0.00%
County Clerk (Vital Stets 8 Legal Rec's)
Personnel Expenditures $ 3,349,258.00 $
Operating Expenditures 297,408.00
3,349,057.00 $ 3,309,057.00 $ 40,000.00
299,333.48 264,333.48 35,000.00
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
CLERK/REGISTER OF DEEDS
AMOUNT
ADOPTED AMENDED FY 2009 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 961,530.00 $ 1,010,411.26 $ 1,010,411.26 $ 0.00%
1.19% Turnover.
11.69% Fay. Professional Services $20,000 reflective of a
software program for Vital Records that has not heen•
completed by an outside vendor and Court Transcripts
$15,000 duo to lower than anticipated activity.
Internal Support Expenditures 635,214.00 861,523,34 861,523.34 0.00%
Transfers 0.00%
$ 4,281,880.00 $ 4,509,913.82 $ 4,434,913.82 $ 75,000.00 1.66%
Elections
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 659,594.00 $
770,800.00
171,270.00
$ 1,601,664.00 $
659,594.00 $ 659,594.00 $0.00% -
772,725.00 772,725.00 - 0.00%
179,941.00 179,941.00 - 0.00%
- .. . 0.00%
1,612,260.00 $ 1,612260 00 $ 0.00%
8/18/2009
Register of Deeds (and Micrographics)
Personnel Expenditures $ 2,849,327,00 $
Operating Expenditures 1,361,611.00
2,834,113.70 $ 2,834,113.70 $ •-
1,361,611.00 836,611.00 525,000.00
Internal Support Expenditures
transfers
930.963.00 938,573.37 938,573.37 0.00%
0.00%
0.00% 168,463.11 $ 168,463.11 $ $ 159,035.00 $
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
CLERKJREGISTER OF DEEDS
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2009
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE} PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
0.00%
38.56% Fav. Professional Services $525,000 due to decrease
in the number of mortgage and title documents
processed by outside vendor., reflective of slowdown
in the housing industry. Note related revenue
unfavorability.*
Jury Commission
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 5,141,901 00 $
$ 19,006.00 $
6,161.00
133,868.00
19,006.00
6,161.00
143,296.11
$ 19,006.00 $
6,161 00
143,296.11
5,134,298.07 $ 4,609,298.07 $ 525,000.00 10.23%
0.00%
0.00%
0.00%
40,000.00
560,000.00
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 7,604,964.00 $
2,476,362.00
2,064,684.00
$ 12,146,010.00 $
7,589,549.70 $ 7.549.549.70 $
2,520,412.48 1 960 412.48
2,325,384.08 2,325,384.08
0.53%
22.22%
0.00%
0.00%
72,435,346_26 $ 11M35,346.26 $ 600,000.00 4.82%
Note revenue offset.
8/18/2009
i 3
Administration
Personnel Expenditures
Operating Expenditures
5 2,923.098.00 $ 2.928,098.00
254,578.00 273,466 50
5 2,850,000.00 $ 7.8,098.00
240,966.50 32,500.00
0.00% - 1,068,427.71
Division Total $ 3,872,745.00 $ 4,269,992.21 5 4,159,394.21 $ 110,598.00 2.59%
Department Total $ 3,872,745.00 $ 4,269,992.21 $ 4,159,394.21 $ 110,598.00 2..59%
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
COUNTY TREASURER
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2009
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNtFICANT VARIANCES
2.67% - Fav variance is due to the county wide hiring freeze in effect for
FY 2009 and the temporary vacated Investment Administrator
position.
11.88% - Fay. variance is due tc the department's eficrls to reduce
spending on travel $11,000, the discontinuation of Microfilming
and Reproductions $11,000, and lower activity in charge card
transactions than anticipated $17,000.
Internal Support Expenditure: 690,069.00 1,068,427.71
8:1812009
Administration
Personnel Expenditures
Operating Expenditures
$ 2,343,38.2.00 $ 2,342,282.00 $ 2,342,282.00 $
429,231.00 429,231.00 349,231.00 80,000.00
Internal Support Expenditures 279,442.00 282,113.71 282,113 71 000%
COUNTY OF OAKLAND
FY 2909 THIRD QUARTER REPORT
EXPENDITURES
BOARD OF COMMISSIONERS
ADOPTED AMENDED
BUDGET BUDGET
••••
AMOUNT
FY 2009 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VAREANCES
0.00%
18.64% - I- ay. Professional Services $50,000 due to temporary lapse in the Lobbyist
contract. Also fav. Travel & Conference $15,000, Workshops & Meetings
$10,000 and Legislative Expense $5,000 due to Commissioners making a
concerted effort to reduce expenditures in these areas.
$ 2,973,626 71 $ 80,000.00 2.62%
80,000.00
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 3,052,055,00
$ 2,343,382.00
429,231 00
279,442.00
$ 3,053,626.71
$ 2,342,282.00
429,231.00
282,113.71
$ 2,342,282.00 $
349,231.00
282,113.71
0 CO%
18 64%
0.00%
$ 3,052,055.00 $ 3,053,626.71 $ 2,973,626.71 $ 80,000.00 2.62%
8/18;2009
868,693.00
5,000.00
873,843.75
5,00.0.00
$ 2,567,666.00 $ 2,577,640.69
$ 1,011,169.00 $ 1,015 992.94
682,804.00 682,804.00
86869100 873,843.75
5,000.00 5,000.00
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
LIBRARY BOARD
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2009 FAVORABLE
FORECAST (UNFAVORABLE) PERCFNT EXPLANATION OF SIGNIFICANT VARIANCES
t6,000.00
1,000.00
Library Board
Personnel Expenditures
Operating Expentlittires
7.68% Turnover.
0 15% Fav. Travel E., Conference due to effort to reduce use and
c.ost
$ 1,011,169.00 $ 1,015,992.94
682,804.00 682,804.00
$ 7,i92.94 $
681,804.00
Internal Support Expenditures
Transfers
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
873,843.75
2,000.00
$ 2,495,640.69 $
5 937,992 94 5
681,804 00
873,843.75
2,000.00
0.00%
3,000 00 Fav. due to funding of Ti line less ttlan .arilicipated
82,000.00 3.18%
78,000.00
1,000.00
3,000.00
7,68%
0.15%
0.00%
$ 2,567,666.00 $ 2,577,640.69 $ 2,405,640.69 $ 82,000.00 310%
8/18/2009
Water Resource Commissioner
Personnel Expenitures $ 3,752,747.00 $ 4,365 469.04 $ 3.786,709.04 $ h18.160.00
Operating Expenditures 491,651.00 753,827.40 736,073.40 17,754.00
Internal Support Expenditures 1,125,546.00 1,525,881.90 1.503,635 90 22,246 00
Total
Department Total
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
WATER RESOURCES COMMISSIONER
AMOUNT
ADOPTED AMENDED FY 2009 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE 1 PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
13.26% Fay Salaries and Fringes $578,760 the result of additional time needed for
CAMS propel planning/requirements phase; original estimate included
development/testing phase hours now expected in Fall 2009.
2,36% Unfav - Recording Fees ($4,000) the result of recording liens at the Register of
Deeds office on properties that have not paid lor their soil erosion permit. Unfav .
Periodicals books Publ Sub ($2,400) used to purchase periodicals and
Communications ($300) for video coniterencing currently which have no
established budget line for these items. Unfav - Personal Mileage ($2,108) due
to underestimated budget to reimburse employees for mileage to inspect job
sites and attend outside meetings. ("av - Contracted Services $20,000, Laundry
& Cleaning $4,465 and Travel & Conference $2,927 is the Departments effort to
balance the budget.
1.46% Unfay - Convenience Copier ($17,754) the result of replacing a black arid while
copier with a color copier, Fav - Drain iquipment 540,000 the result of additional
time needed for CAMS project planning/requirements phase; original estimate
included development/testing phase hours now expected in Fall 2009.
Transte.rs 56,165.00 665..00 63,665.00 0.00%
$ 5,426,109.00 $ 6,708,843.34 $ 6,090,063.34 $ 618,760,00 9.22%
$ 5,426,109.00 $ 6,708,843.34 $ 6,090,083 34 $ 618,760.00 9.22%
8/1812009
Controllable Personnel $ 770.797.00 $
Controllable Operating
Internal Support Expenditures
Transfers
261,380.00
458,574 01)
$ 1,490,751.00 $ - - $
175,000.00
4,500,00
20,000.00
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
COUNTY EXECUTIVE
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2009 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
25,000.00
3,200.00
Administration
Controllable Personnel
Controllable Operating
Internal Support Expenditures
$ 2,010,367.00 $ 2,010,367.00 $ 1,985,367.00 $
224,173.00 1,201,243 00 1,198,043 00
589,160.31 589,180.31
1.24% - Turnover.
0.27% - Fav Contracted Services 51 .0(X), Equipment Maintenance 5200, and Personal
Mileage $2,000 due to effort to reduce costs.
0.00% - 582,310.00
$ 2,816,850.00 $ 3,800,790.31 5 3,772,590.31 $ 28,200.00 0.74%
Emergency Response & Preparedness
- Transfer of Emergency Response & Preparednesss to the Department of
Health and Human Services. MR 009109.
Auditing
Controllable Personnel
Controllable Operating
Internal Support Expenditures
$ 1,149,544.00 $ 1,155,097.13 $ 1,085,097.13 $
27,657.00 35,137.00 26,737.00
182,035.00 185,611 45 150,611.45 35,000 00
6.06% - Turnover.
23.91% - Favorable Membership Dues $600„ Travel and Conference $7,000 and
Personal Mileage due to limited cash audits and employee turnover.
18.86% - Fay. IT Operations.
70,000.00
8,400.00
$ 1,359,236.00 $ 1,375,845.58 $ 1,262,445.58 $ 113,400.00 8.24%
Corporation Counsel
Controllable Personnel
Controllable Operating
Internal Support Expenditures
$ 2,116,691.00 $ 2,125,574.60 $ 1,950,574.60 $
57,273.00 58,122.00 53,622.00
235,444.03 215,444.03
8.23% - Turnover Position #3200 and #7748,
7.74% - Favorable Library Continuations $1,500, FA Proprietary Equip Expense $1,000
arid Personal fylileage $2,900 due to limited travel replaced by tele-
conferencing.
8.49% - Fav tT Operations. 233,159.00
$ 2,419,140.63 $ 2,219,640.63 $ 199,500.00 8.25%
Department Total
Controllable Personnel
Controllable Operating
internal Support Expenditures
Transfers Out
$ 2,407,123.00
$ 6,047,399_00
570,483.00
'1,456,078.00
$ 5,291.038.73 $
1,294,502.00
1,010,235.79
0
5,021,038.73 $
1,278,402_00
955,235.79
0
270,000_00
16,100.00
55,000.00
5.10%
1.24%
5.44%
S 8,073,960.00 $ 7,595,776.52 $ 7,254,676.52 5 341,100 00 4.49%
8/18/2009
Operating Expenditures
Internal Support Expenditures
8,780.00 7,550.00
17,165.00 17,165.00
0.00%
0.00%
7,550.00
17,16.500
Purchasing
Personnel Expenditures
Operating Expenditures
$ 1,097,970.00 $ '1,00/,787.00 $ 2,001.78/.00 0.00%
35,081 00 35,081.00 35,081.40 0.00%
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
MANAGEMENT AND BUDGET
AMOUNT
ADOPTED AMENDED FY 2009 FAVORABLE
BUDGET BUDGET. FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expendilures $ 316,194.00 $ 292.113.00 $ 297,913.00 S (5,800 00) -1.99% -Linfau Retirement ring° Benefits due to actuals higher than prorated
Retirement budgel, which was based on a two-year old Salary and
Fringe Benefit forecast.
$ 402,139.00 $ 316,828.00 $ 322,628 00 $ (5,800.001 -1.83%
internal Support Expenditures
Transfers
187,913.00 188,517.68 188,517.63 0.00%
$ 1,320,973.00 $ 1,321,335.68 $ 1,321,385.68 $ 0.00%
Equalization
Personnel Expenditures S 7,920.121 00 S 7,774,447.14 • 7,444,447.14 $ 330,000.00 4.24 -F-'av. Variance due to county wide hiring ireeze
Operating Expenditures 237,591.00 237,702.72 237,702.72 0.00%
Internal Support Expenditures 1,287,345.00 1.662,156.75 1,662,156 75 0.00%
Transfers ,. 0.00%
$9,445,057.00 $9,674,306.61 S 9,344,305.61 $330,000.00 3.41%
Fiscal Services
Personnel Expenditures S 7,721,751.00 S 7,703,498.70 $ 1,5/6,498.70 $ 125,000.00 1.62% - Fav. Variance due to county wide hiring freeze.
Operating Expenditures 230,324.00 230,324.00 230,324.00 0.00%
Internal Support Lxpenditures 2,294.741 00 2,679,964.88 2,679,964.88 0.00%
-
$ 10,246,816.00 $ 10,811,787.58 $ 10,486,787.58 $ 125,000.00 1 18%
Department Total
Personnel Expenditures $ 17,116.045 00 $ 16,865,845 84 $ 16,416,64-5 84 $ 449.200.00 2.68%
operating Expenditures 511,778.00 510,657.72 510,657.72 - 0.00%
Internal Support Expenditures 3,737,164.00 4,547,304.31 4,547,804.31 0.00%
Transfers - - - 0.00%
21.414,985.00 8 21.924,307.87 $ 21,4 (5,10/.87 $ 440,200.00 2.05%
8118:2009
0.0C%
0.00%
0.00%
2.33%
17,60%
0.00%
0.00%
1.67%
Administrative
Personnel Expenditures
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
CENTRAL SERVICES
AMOUNT
ADOPTED AMENDED FY 2009 FAVORABLE
BUDGET BUDGET FORECAST iUNFAVORABLE) PERCENT
$ 204,142.00 $ 204,142.00 $ 204,142.00 0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
2.616.00
14,490.35
Operating Expenditures
Internal Support Expenditures
Transfers
2.610,00 2.016.00
14,235.00 14,490.35
220,993.00 $ 221,248.35 5 221,248.36 $
Support Services
Personnel Fxpendilures $ 1,134,950.00 $ 1,134,950.00 $ 1,103,750.00 $ 31,200.00 2.75% Fay. due lo actual charges for hospitalization costs greater than
standard average rate budgeted.
Operating Expenditures 53,828.00
Internal Support Expenditures 960.102 00
Transfers
54,210.00 44,210.00
1,050,869.55 1.055,869.55
10,000.00 18.45% Fay. Travel and Conference $4,000 and Office Supplies $6,000.
0.00%
0.00%
$ 2,148,880,00 $ 2246,029_55 $ 2,204,829.55 $ 41,200.00 .1.83%
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 1,339,092.00 $ 1,339,092.00 5 1,307,892,00 $
56,444 09 56,826.00 46,826.00
974,337.00 1,071,359.90 1,071.359 90
$ 2,369,873.00 $ 2,467,277.90 $ 2,426,077.90 $
31,200.00
10,000.00
41,200.00
8118/2009
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
Facilities Engineering
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 912,754 00 $ 912,154.00 $ 864,754.00 $ 48,000.00
116,888.00
/0.705.00
101,888.00
70,705.00
71,888.00
61,705.00
30,000 00
9,000.00
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
FACILITIES MANAGEMENT
AMOUNT
ADOPTED AMENDED FY 2009 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 395,310.00 $ 360,528.00 $ 707,725.00 $ 157.600 0C1 43,77% - Turnover, including vacant Director position far six months and filling of Property
Management Specialist FIE position by PTNE.
4,596.00 7.111.00 2,911.00 4.200.00 59 06% - Fav. Budget Transition $2,515 reflecting bridge( reductions at excess of Plihlic Works
Building Ground Floor Project renovation costs and fav. Memberships Dues and
Public.ations $1,500.
38,013.00 38,013.00 33,013.00 5,000 00 13.15% - Fat IT Operaticris based on required usage.
47,267,00 47,267.00 0.00%
$ 437,919.00 $ 452,919.00 $ 285,919 00 $ 167,000.00 36.87%
5.26% - Staff time charged to the 2009 Housing Demolition and Parks & Recreation roofing
projects. and fav. Overtime $3,000 due to reduced project activity.
29.44% - Fay. Professional Services due to reduced Capital Improvement Project activity.
12.73% - Fav. Motor Pool 52,500 and Telephone Communications $2.500 due to reduced
project activity arid fav. IT Operation's $4,000 based on required usage.
$ 1,100,341.00 $ 1,085,347.00 $ 998,347.00 5 87,000.00 8.02%
205,800.00
34.200.00
14,000.00
Department Total
Personnel Expenditures
Operating Expenditures
Internet Support Expenditures
Transfers Out
$ I ,308,064.00 $ 1,273,282.00 $
121,484.00 108,999.00
108,718.00 108,718.00
47,267.00
1,061,482.00 $
74,799.00
94,718.00
47,267.00
16.16%
31.38%
12.88%
0.00%
$ 1,538,266.00 $ 1,538,266.00 $ 1,284,766.00 $ 254,000.00 16.51%
8.'18'2009
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2009 FAVORABLE
FORECAST (UNFAVORABLE)PERCENT
Workforce Management
Personnel Expenditures
Operating Expenditures
$ 2,179,690.00
204,995 00
$ 2,125,289.72
205,145.00
$2,125,289.72 $
121,145 00 $
0.00%
84,000.00 40.95%
$ 668,241.00 $ 668,241,00 $ 668,241.00 0.00%
18,100.00 3.26% Fav. estimated Employee Med Exams ADA $2,000 due to decline in current employees
submitting requests for AIDA medical exams, a reduction in Fees - Fer Diem $10,000
due to fewer meetings, a reduction in Memberships and Periodicals $1,300 (as reflected
in historical usage), use of Travel and Conference $4,300, arid Workshop and
Meetings $500.
78,628 97 $ (14,150.00) -21.95% Unfavorable due to charges for use of Motor Pool ($150) and Telephone
Communications ($3,000). Additional lines for "hot line", as well as cell phones for
Deptuy Director and Supervisor to handle increased activity with 312 Arbitration.
However, budget was not adjusted to reflect this increase in expense. Also, Print Shop
charges unfavorable (.$ 11000) due to revised Merit Rules per MR ;409047,which were
printed and distributed to all departments. A budget amendment is recommended to
offset the unfavorable variance.
Internal Support Expenditures
$ 1,026,144.00 $ 1,284,225.97 $ 1,280,275.97 $ 3.950.00 031%
551,536 00 533,406.00 $ 301,506 00
56,397.00 64,478.97
Administration
Personnel Expenditures
Operating Expenditures
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
HUMAN RESOURCES
EXPLANATION OF SIGNIFICANT VARIANCES
Savings are projected in Equipment Maintenance $1,000, Freight & Express $150,
based on historical usage and Computer Supplies $2,000 and Expendable Equipment
$2,000 due to cutbacks in purchases. Plans for Travel and Conference will be lower
due to decline in PeopleSofl training resulting in estimated favorability of $9,000, as well
as Personal Mileage $1,000; offset by prior years expense for Intern Program invoice of
($1,085) charged to FY 2009 budget because invoice was not processed until after
closing for FY 2008. Due to the hiring freeze, expenses related to hiring, advertising,
testing and processing new employees are projected to be substantially favorable by
approx $70,000.
8/13!2009
Internal Support Expendilures 639,295 00 626,873.97 698,973.97 $
Operating Expenditures 16,552 00 16,552 00 5,952.00 $ 10,600 00
COUNTY Of- OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
HUMAN RESOURCES
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2009 FAVORABLE
FORECAST fUNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
27,900.30 4.45% Into Tech Operations projected fay. $13,600 as operating expense for PeopleSolt
upgrades less than anticipated. Convenience Copier projected to be $5,200 fay. and
Print Shop projected to be 'Ia.'. $14,600 due to lower usage , offset by unfav.Telephone
Communications expense ($3,500) as current monthly charges continue to coincide
with historical usage belcg higher than Inucioel.
$ 2,923,980.00 $ 2,95-1,308.69 $ 2,845,408.69 $ 111,900.00 3.78%
$ 232,275.00 $ 232,275.00 5 157,275.00 $ 75,000.00 32.29% Favorable due to redistribution of salaries and fringes for positions transferred to I IR-
Workforce Management per reorg in FY 2008 fM.R 408 1011, correction of account
code for Secretary II position 401689, which is now charged to HP- Admin Labor
Relations, and vacant PTNE Office Assistant I position (#100561.
Benefits Administration
Personnel Expenditures
64.04% Due to efforts to cur back in spending, a number of accounts are reflecting favorable
variances, such as Equipment Maintenance $100, Travel and Conference $3,200,
Software Support Maintenance $400, Expendable Equipment Expense $2,000, and
Office Supplies $4,900.
Internal Support Expenditures 171,397 00
$ 420,224.00
Department Total
Personnel Expendibires
Operating Expenditures
Internal Support Expenditures
$ 4,370,348 00
171.397 00
$ 420,224 00
$ 3,025,805.72
773,203 00
862,749,94
$ 4,661,758.66
171,39700 0.00%
$ 334,624.00 $ 85,600.00 20.37%
$ 2,950,805.72 $ 75,000.00 2.48%
660,503.00 112,700 00 14.58%
848,999.94 13,750.00 1.59%
54,460,308 66 $ 201.450 00 4.32%
$ '3.080206.00
523,053.00
767,089 00
8/18/2009
1,1
Operating Expenditures 4,641,776.00 5,667,138.29 5,052,538.29 614,600 00
$ 34,528,770.00 $35.536,581.55 $ 32,541,581.55 $ 2,995,000.00 8.43% 8/18/2009
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
HEALTH AND HUMAN SERVICES
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2009
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures
Operating Expenditures
$ 209,874.00 $ 209,874.00 $ 209,674 00
11,701,313.00 11,413,642.00 11,838,642.00 (425,000,00)
000% -
-3.72% - Anticipating (Unfav) Independent Living ($200,000) and
Private Institutions ($225,000) (Michigan Department of
Human Services) for costs incurred for the care of neglected
and abused wards of the court. Costs are based on caseload,
difficulty of care, and treatment of services (counseling, drug
screening etc.) ordered by the Court,
0.00% - Internal Support Expenditures
Transfers Out
1103200 11,032.00 11,032.00
$ 11 +922,219.00 $ 11,634,548.00 $ 12,059,548.00 $ (425,000 00) -3.65%
Health
Personnel Expenditures 8.55% - Favorable turnover due to retirements in FY2008 and
underlined positions.
$ 26,501,828 00 $ 25,798,604.45 $ 23,593,204.45 $ 2205,400.00
10.84% - Membership and Dues is favorable, $8,900, Personal Mileage
$101,000. Lab Supplies $90,500, Contracted Services
$121,000, Medical Supplies $53,300, Testing Materials
$6,500, X-rays $5,000, Drugs $39,000, Expend. Equip.
$26,000. Interpreter Fees $19,000, Communications $300,
Education Programs $45,000. Licenses & Permits $10,500,
Printing $9,000, TB Cases $5,000, Training $4,000, Training &
Ed. Supplies $26,800, Uniforms $1,800, Postage $3,000,
Photo. Supp. $400, Computer Stipp. $1,000, Lab Fees
$2,000, Equip. Maint. $4,400, Fees Per Diem $3,800,
Employee Med. Exams $1,900, laundry & Cleaning $2,600
and Travel and Conference $21,900 all due to containing _
costs and mimimizing expenses. ravorability is also expected
in Satellite Centers pending determination of final payment for
fiscal year 2009 from the State for Convention Facility Tax
distribution. It is unknown if we will have a carrylorward if final
payment is not received
Internal Support Expenditures
Transfers Out
3,385,166 00 4,070,838.81 3,895,838.81 175,000.00 4.30% - Fav IT Operations
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
HEALTH AND HUMAN SERVICES
AMOUNT
ADOPTED AMENDED FY 2009 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
8f 1812009
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2009
FORECAST
'Transfers Out 000 300 00 .00
0.00%
Homeland Security
Personnel Expenditures $ 775,898.00 $ 775,898.00 $
Operating Expenditures 260,038 99 207,518,99
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
HEALTH AND HUMAN SERVICES
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Children's Village
Personnel Expenditures $ 12.820,771.00 $ 13,118,672 28 $ 12,873.67228 $ 245,000.00 1.87% - Turnover.
Operating Expenditures
Internal Support Expenditures
$ 3,637,555.00 3,816,067.80
2,453,447.00 2,514,696.47
3,740,067.80 76,000.00
2,514,696.47
1.99% - Favorable Travel and Conference $5,000 and Security
Supplies $20,000. Favorable Laundry and Cleaning $35,000,
due to pilot program between Sheriffs Office and the
Department of Health and Human Services. Also, anticipating
Fay. Bedding and Linen $16,000, due to sufficent linen
inventory to date.
0.00% -
$ 18,911,773.00 $ 19,449,736.55 $ 19,128,736 55 $ 321,000.00 1.65%
52,520.00 20.20% - Favorable Tornado Siren Equipment due to limited local
funding for the purchase of sirens.
Internal Support Expenditures
Transfers Out
460,307.03 438,307.03
$ 1,495,244.02 $ 1,421,724.02 $
22,000.00
74,520.00
4.78% Fav IT Operations.
Depadment Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfers Cut
$ 39,532,473.00 $ 39,903,048.73
19,980,644 00 21,156,887 08
5,849,645.00 7,056,874.31
300.00
$ 37,452,648.73
20,838,767.08
6,859,874.31
300.00
$ 2,450,400 00
318,120.00
157,000.00
6.14%
1.50%
2.79%
100.00%
$ 65,362,762.00 $ 68,117,110.12 $ 65,151590.12 $ 2,965,520.00 4 35%
8/18/2009
!di
0.00% -
000% -
0.00% -
0.00%
1,483,741.28 $
219,090.00
1,528,741.28
227,090.00
$ 1,534,499.00 $
227,090.00
259,755.00
45,000.00
8,000.00
259,755.00 254,650.00
Veterans' Services
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
2.94% - Fav. due to the hiring freeze policy in effect for FY 2009.
3.52% - Fav. Soldier Burial due to lower than anticipated veteran
burials
0.00% -
0.00%
667,229.62 667,229.62
$ 4,822,309.00 $ 5,092,271.73 $ 5,092,271.73 $ 0.00%
MSU Ext. - Oakland County
Personnel Expenditures
Operating Expenditures
$ 763,160.00 5 766,697.39 $ 766,697.89 $
38,897.00 89,009.86 63,009.86 6,000.00
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
PUBLIC SERVICES
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2009
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Public Services - Admin.
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 187,479.00
4,800.00
6,589.00
$ 187,479.00 $
87,258.00
6,589.00
187,479.00 $
87,258.00
6,589.00
281,326.00 $ 198,868.00 $ $ 281,326.00 $
$ 2,016,239,00 $ 2,01b,b86.28 $ 1,962.586.23 $ 53,000 00 263%
Community Corrections
Personrel Expenditures
Operating Expenditures
internal Support Expenditures
Transfers
$ 3,438,647.00 $ 3,537,128.11 $ 3,597,128.11 $ (60,000.00)
887,914.00 827,914.00 60,000.00
-1.70% - Unfav. Salaries and Fringes due to multi-filling of PINEII f NE
• WWAM positions A budget amendment is recommended.
6.76% - Fay. Contracted Services due to effort to reduce costs. A
budget amendment is recommended.
0.00% -
0.00% -
827,198.00
556,464.00
0.00% -
6.74% - Fay, Professional Services $3.000 due to the use of MSU
Extension educators from other counties that don't charge fees
for teaching Master Gardener classes and Special Event
Program $3,000 due to efforts to reduce usage and costs.
Note related revenue unfavorability.*
358,315.00 Internal Support Expenditures 367,308.66 362,303 66 0.00% -
$ 1,210,372.00 $ 1,218,016.41 $ 1,212,016.41 $ 6,000.00 0.49%
See related revenue offset. 813t2009
Medical Examiner
Personnel Expenditures
Operating Expenditures
$ 3,426,491.00 $ 3,278,636.52 $ 3,278,636 52 $
521,788 00 522,161 33 490,161 33
Internal Support Expenditures 798,745.00
Transfers
837,049.82 837,049.82
S 4,747,024.00 $ 4.637,847.67 S 4,605,847.67 $
Animal Control
Personnel Expenditures $ 1,784,110.00 $ 1,784,110.00 $ 1,770,110.00 $
155,840.69
758,414.35
155,840.69
758,414.35
0.00%
0.00% -
(1,000.00)
106,000.00
-0.01%
5.27%
0.00%
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
PUBLIC SERVICES
AMOUNT
ADOPTED AMENDED FY 2009 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
0.00% -
32,000.00 6.13% - Fay. Transportation Service $25.000 and I uteri 8, Processing
$10,000 due to a decrease in caseload; partially offset by
unfav. Equipment Maintenance ($3,000) due to an increase in
equipment repairs.
• 0.00% -
32,000.00 0.69%
14,000,00 0.78% - Fay. Overtime $10,000, Holiday Overtime $2,500 due to
implementation of staggered work schedules in the Kennel to
eliminate overtime on Saturdays and On Call $1,500 as a result
of eliminating the afternoon shift for Road Patrol and
implementation of the 4/40 workweek.
Operating Expenditures 154,967.00
Internal Support Expenditures 592,293.00
Transfers
$ 2,531,370.00 $ 2,698,365.04 $ 2,684,365.04 $ 14,000.00 0.52%
Circuit Court Probation
Personnel Expenditures $ - - $ - $ - $ - 0.00%
Operating Expenditures 40,798.00 40,798.00 40,798.00 - 0.00%
Internal Support Expenditures 807,581.00 809,484.30 809,484.30 - 0.00%
$ 848,379.00 $ 850,282.30 $ 850,282.30 $ 0.00%
Department Total
Personnel Expenditures $11,134,386.00 $ 11,082,792.80 $ 11,083,792.80 $
Operating Expenditures 1,865,538.00 2,010,071.88 1,904,071.88
Internal Support Expenditures 3,374,637.00 3,700,830.75 3,700,830.75
Transfers
$16,374,561 00 $ 16,793,095.43 $ 16,688,695.43 $ 105,000.00 0.63%
• See related revenue offset. 8118/2009
Planning and Economic Development Services
Personnel Expenditures $ 3,893.545.00
Operating Expenditures 1,036,275.00
$ 3,899,373.30 $ 3,743,873.30 $ 155,500.00
1,444,749.27 1,423,049.27 21,700.00
0 . 00 % -
0.00%
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2009 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 1,114,290.00 $ 1,109,553.00 $ 1,078,453.00 $ 31,100.00
132,059.00 311,542.00 302,042.00 9,500.00
69,525.00 74,058.39 93,558.39 (9,500.00)
$ 1,315,874 00 $ 1,495,153.39 $ 1,464,053.39 $ 31,100 00
2.80% Turnover.
3.05% - Fay. Advertising for marketing activities.
-12.83% - Unfav. Print Shop and Telephone Communications based en
expected usage. A budget amendment is recommended
2.08%
3.99% Turnover..
1.50% - Fay. Operating, primarily Professional Services, as well as
Advertising, Punting, Travel & Conference, Legal Services, and
Workshops & Meetings for update of the Solid Waste
Management Plan, delayed pending reformatting of plan
guidelines by the State $143.100. Also fay. Printing $48.500 clue
to utilization of Print Shop rather than outside printing; and fav.
Freight & Express $5,000. Favorability is partially offset by NO
HAZ Program costs ($165,000), primarily Professional Services,
due to expansion of the program (NO HAZ Program revenues
will increase to cover this cost increase) and Personal Mileage
($12,500) required for Inc* economic development activities.
Internal Support Expenditures 981,603.00 1,008,720.51 939,420.51 69,300.00 6 97% - Fay. IT Operations based on required usage.
$ 5,911,423,00 $ 6,352,843.08 $ 6,106,343,08 $ 246,500,00 3.88%
Community and Home Improvement
Personnel Expenditures
Operating Expenditures
Transfers
Workforce Development
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
- $
$ 25,620.00 $ 25,620.00 $ 25,620 00 $
$ 25,620.00 $ 25,620.00 $ 25,620.00 $
F01812009
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
EXPENDITURES
ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2009 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Department Total
Personnel Expenclittires
Operating Expenditures
Internal Support Expenditures
Transfers
$ 5,033,455.00 $ 5.034,546.30
1,168,334.00 1,756,291.27
1,051,128.00 l,082,77890
$ 4,847,946.30
1,725,091.27
1,022,978,90
$ 186,600.00 3.71%
31,200.00 1.76%
59,800.00 5.52%
0.00%
$ 7,252,917.00 $ 7,873,616.47 $ 7,596,016.47 $ 277.60000 3.53%
8/18/2009
30,000.00
1,340,082.00
1,500,000.00
30,000 00 30,000.00
1 340,082.00 1,340,082.00
1,681,625.00 1,587,625.00
Provisions 30,000 00 30,000 00 30,000,00
Transfer to CEARA 9,620,616.00 9,620,616.00 9,620,616.00
Total $ 12,692,516.00 $ 12,880,141.00 $ 12,668,241_00 $
COUNTY BUILDINGS 3 3,293,605.00 S 2,776,648.34 $ 2,776,648.34
A budget amendment is in process to increase approp by
S750,000
0.00%
0.00%
0 00%
0.00%
(4,100 00)
16,000.00
-2.65%
94.67%
11,900.00
0.00%
0.00%
0.09%
(700 00)
62,000.00
10.00%
0.00%
0.00%
-2 92%
10.71%
0 00%
8.00% 61 .ann
55,000 00
1,700.00
70,700.00
74,000 00
579,000.00
30,000 00
760,400 00
STATE AND FEDERAL - COUNTY ASSOCIATIONS
Area Wide Water Quality
Assoc of Who Sewage Ayr:tildes
Michigan Assoc. of Counties
National Assoc of Counties
S E.M.C.O.G.
Traffic Improvement Association
Total
55,000 00 55,000 00
1,700.00 1,00.00
70,700.00 70,700 00
24,000.00 24,700 00
579,000 00 517,000.00
30,000 00 30,000 00
760,400 00 $ 699,100 00 $
0.00%
0.00% This budget will be reaPlocated to dept later this year.
0.00% - The budget of 57 mil is the offset lo departments Ludget task
commitments No actual funds will he expended from this
account
84.92%
0.00%
0.09%
0 00%
0.00%
000%
0 00%
0 CO%
100.00%
0.00%
0.00%
52,100 00
150,000 00
4 000 00
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
NON-DEPARTMENTAL EXPENDITURES
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2009
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION
NON-DEPARTARTNIENT APPROPRIATIONS
COUNTY OPERATIONS
Insurance Fund
Insurance Surety Ponds
Miscellaneous
Logos and Trademarks
Road CommissionTurrent Drain Assessment
Road Commission\Tri Party Agreernent
$ 154,918.00 $ 154,918.00 $ 159,018.00 3
16,900 00 16,900.00 900.00
SUNDRY EXPENSE $ 300,000.00 $ 300,001100 $ 300,001100
RESERVED FOR 'TRANS FIRS
Expenditures
Administrative Leave
Budget Transition
Basic Readjustment
Classification arid Rate Change
Contingency
Emergency Salaries
Grant Match
Info Tech Development
Legislative E xpense
Misc. Capital Outlay
Overtime Appropriation
Workshops arid Meetings
Fringe Benefit Adjustment
Summer Employees Salary Appropriation
90
5 (400,000.00) $ (27,497.00) (27,497.00)
7,045,534 00 7.045,634.00 1,045,634.00
52,162.00 52,162.00 62.00
190,904.00 '176,642.00 26,642.00
149.520 00 183,752.00 i 83 , 1 .57 00
1,320,709.00 622,4'14.52 622.414.52
6.748,257.00 530,578 00 530.5/8.07)
11..042,936.00 2,359,260.73 2,359,260.73
180,500.00 180,500 00 180,500.00
75.000.00 75,000.00 75,000.00
53,000.00 53,000.00 53,000.00
4 ,O00. 00 4,000.00 -
0.00 0.00 ..
353,738.00 289,031.00 289,031.00
This budget will be reallocated to dept later this year.
A budget amendment is recommended to recognize pending
grants.
This budget will he reallocated to dapt later this year.
8/1812009
FY 2009
FORECAST
15,000.00
11,353,377.25
AMOUNT
FAVORABLE
(UNFAVORABLE)
5,200.00
211,300.00
PERCENT
0.00%
1.00
1 83%
EXPLANATION
(145,704.00
11,485,466.00
1,479,070.00
200,000.00
413,997.00
515,809.00
1,389,117.00
70,6:16.00
$ 16,199,859.00 $
0.00%
0.00%
0.00%
o 00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
TOTAL NON-DEPT. APPROPRIATIONS $ 54,667,304.00 $ 44,481,725.59 $ 44,197,225.59 5 2134,500.00 0.64%
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
NON-DEPARTMENTAL EXPENDITURES
Transistion Expense
Transit Commuter Benefit Program
Total
Transfers In Other Funds
Jail Population Management Fund
Capital & Cooperative Initatives Revolving Fund
DeUt Service - West Wing Refunding
Project Work Order Fund
Fire Records Management
Radio Communicalioris
CLEM'S
Intern-Wien Technulogy
Facilities Mainenance & Operations
ADOPTED
BUDGET
5,200.00
21,821,560.00
645,764.00
11,505,466.00
1,419,070.00
200,000 00
413,997.00
165,809 00
1,389,117 00
0.00
0.00
S 15,799,223.00
AMENDED
BUDGET
15,000.00
5,200.00
$ 11,564,677.25
645,764.00
11,485,46600
1,479,070.00
200,000 00
413,997 00
515,809 00
1,389,117.00
70,636.00
0.00
$ 16,199,869 00
TRANSFER TO GENERAL PURPOSE FUNDS
Public Health Fund
Child Care Fund
Social Welfare Fund Foster Care
0,00%
0.00%
0.00%
0 00%
$ 25,678,851 00 $
23,421,591 00
1,000 00
$49,101,442.00
26,709,640.93
213,869,805.75
.t.000..00
$50,580,446.68
26,709.640 93
23,869,805.75
1,000.00
150..580,446,68 $
rif)14,1. EXPENDITURES $ 103,768,746.00 $ 95,062,172.27 $ 94,777,672.27 284,500.00 0.30%
9 0.xls 811827009
FY 2009 BUDGET AMENDMENTS
FY 2009 BUDGET AS ADOPTED - GENERAL FUND/GENERAL PURPOSE FUNDS $ 426,410,209.00
BUDGET AMENDMENTS
M.R. #08181 - 10/02/2008 S 20.395.00
Criminal Justice Coordinating Counsel - Expansion of Tethering Program Transfer from Jail
Population Management fund
M.R. #08191 -10/02/2008 S 700 00
County Clerk - Elections Division Board of Canvassers Agreement City of Farmington Hills
M.R. #08192 - 10/02/2008 S 6,708.00
Information Technology - interlocal Agreement with Lyon Township FRMS- Planned Use of
Fund Balance
59.013.00
$ 102.266 00
63.928.00
400.00
(11.588.00)
6,500.00
21.970.00
M.R. #08226 - 10/23/2008
Sheriffs Office - Automobile Theft Prevention Authority (ATPA) Grant Acceptance
M.R. #08227 - 1012312008
Sheriff's Office - Jail Alliance with Support for Inmates with Co-Occurring Disorders Program
M.R. #08233 - 11/06/2008
Management and Budget Transfer of Inmate Account Data from the Reimbursement Unit's
Legacy System and the Ja:1 Management Information System RDK, Inc.-Planned Use of FB
M.R. #08228 - 11/06/2008
County Clerk - Elections Division Board of Canvassers Agreement Independence Township'
M.R. #08246 - 11/06/2008
Sheriffs Office - State Criminal Alien Assistance Program (SCAAP)
M.R. #08252 - 1112012008
Snenffs Office - Addition of K-9 and Milk Bone Donation Acceptance
M.R. #08235 - 11/6/2008
Parks and Recreation Department - Reorganization
M.R. #08266 - 12/1112008
M&B FY 2008 Year End Report
Encumbrances $ 157.527.32
Carry Forwards $ 2,833,567.39
Appropriation of Designation - Sheriffs Call Taking Equip. $ 350,000.00 $ 3,341,694 71
825.00
(48.267.00)
43,155 00
M.R. #08261 - 12/11/2008
County Clerk - Elections Division Board of Canvassers Agreement Bloomfield Township
MIR #08268 - 12/11/2008
Health Division - MDEQ Contract
M.R. #08273 - 1211112008
Circuit Court - SCAO Grant Acceptance
M.R. #08275 - 12/11/2008
Sheriff's Office Prosecuting Attorney- NET Bryne Grant Acceptance
M.R. #08278 - 12/1112008
52-2 District Court - SCAO Grant Acceptance (Drug Court)
70,160.00
S 257,528.00
$ 17,254 00
M.R. #09013 - 2/5/2009 75,000.00
42
S 250,000.00
5 1.131.306.00
$ (100,000.00)
$ 60.000.00
$ (1.100 00)
$ 150,000.00
$ 29.000.00
$ 200.000 00
$ 858,314.00 $ 2.577.520.00
$ 391.374.00
18,500.00
30,000.00
$ 169.960.00
60.373 00
FY 2009 BUDGET AMENDMENTS
47 407.00 Sheriff - Contract Mtn Wayne County hr Warrant Enforcement Parole Absconders
MR. #09015 - 2/5/2009 8.003.00
Sheriff - Patrol Contract with Rochester Hills
MR. #09038 - 03/0512009 3,780.00
Health Division - 2009 Fetal Infant Mortality Data Abstraction Agreement
MR. #09023 - 315/2009 $ 122.554 00
Sheriff - Patrol Contract with Lyon Twp
MR. #09026 - 03/0512009 2,500.00
Sheriffs Office - Use of Donated Vehicle For Auto Theft Preventien Team
M.R. #09024 - 03/0512009 S 220.000.00
Sheriffs Office - Contract Extension for Private Food Service Vendor thru 2012
M.R. #09066 - 03/2612009 S 327.190.00
Sheriffs Office - Creation of the Results Breath Alcohol and Drug Testing Pilot Program
M.R. #09067 - 03/26/2009 $ (101.000.00)
Public Services - Reorganization
M,R, #09043 - 03/26/2009 25.000.00
Health Division - intergovernmental Agreement with Oakland Schools for Infant Toddler
Assessments
M.R. #09082 - 4/23/2009
M&B FY 2009 First Quarter Repol
Appropriation of Designation - HR Legal Expense
Chilcirens Village/Child Care Fund Revenue Adjustment
Circuit Court - Revenue Adjustment for Mediation
Sheriff - Revenue Adj. Diverted Felon/Board & Care
Board of Commissioners - Rev Adj for Pe.' Diem
Health and Human Services Admin - Adj Reim General
Economic Development
Non-Dept Revenue Adj. Interest, Gig Tax & St Court Eq
Water Resource Commissioner - Adj Reim General
M.R. #09071 - 4/23/2009
Sheriff - Use of Forfeiture funds for Equipment
M.R. #09081 - 4/23/2009
Equalization - Orion Twp contract
M.R. #09104 - 5/07/2009
Sheriffs Office - Marine Safety Grant
M.R. #09106 - 5/07/2009
Prosecuting Attorney - Title IV-E Client Services Contract
M/R #09122 - 6/11/2009
Sheriff - Patrol Contract Paint Creek Trail
TOTAL AMENDED BUDGET AS OF 6130/2009 Third Quarter $ 434,341,011.71
43
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
INTERNAL SERVICE FUNDS
SHERIFF'S OFFICE
ADOPTED AMENDED FY 2009 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
IEHERIFF AVIATION #6S000 ----
OPLF-ZAIING REVENUES'
Outside Revenue $0.00 $0.00 $0.00 $0.00 0.00%
Inside Revenue $ 1,767,1 1Z 00 $.1267,112.00 $ 1,76'i,112.00 $ - 0.00% -
Total Revenue $ 1,767,112.00 $1,767,112.00 $1,767,112_00 $0.00 0 00%
OPERATING EXPENSFS $1,329,612.00 $1,329,612.00 $ I 329,612.00 $ - 0.00% -
NET INCOME (LOSS) BEFORE $4.37,500.00 3437,500.00 3437,500 00 $0.00 0.00%
TRAN21ERS IN (OUT) $0.00 5000 $0.00 $ 0.00%
NON-OPERATING REVENUE $0_00 $0.00 16,300.00 $ 16,300 00 0.00% Represents income from investment of fund working capital
OPERATING TRANSFERS IN $0.00 $0.00 $0.00 $ - 0.00%
NET REVENUES OVER(UNDFR)
EXPFNSFS ' $437500:00 _ $437500.00 $453,800.00 $16,300.00 0.00% Funds necessary to cover repayment of 0 T Rf Loans
Total Net Assets - Beginning
'total Net Assets - Ending
$3,251 .599 56
$370539956
81812009
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
ENTERPRISE FUNDS
SHERIFF'S DEPARTMENT
ADOPTED AMENDED FY 2009 VARIANCE
BUDGET BUDGET FORECAST F AV1(UNF AV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
JAIL INMATE COMMISSARY FUND
(059900)
OPERATING REVENUE S 1,455,870 00 $ 757,816.00 S 751,816 00 5 . 0 00% - Operations were transferred to the General fund per MR W0502•4
OPERATING EXPENSE $ 1,455,870.00 5 757,816.00 $ 757,816.00 5 - 0.00% -
NET OPERATING INCOME (LOSS) $ . $ . 5 • $ .•
NON-OPERATING REVENUE (EXPENSE) $ - S - S 10,000.00 S 10,000.00 0.00%
TOTAL INCOME BEFORE
CONTRIBUTIONS AND TRANSFERS $ - $ - $ 10,000.00 $ 10,000 00 0.00%
TRANSFER OUT $ - $ • $ •. $ • 0.00%
CAPITAL CONTRIBUTION S - S - S - 5 • 0.00%
TOTAL NET INCOME (LOSS) $0 00 50.00 510,000.00 510,000.00 0.00%
TOTAL NET ASSETS - BEGINNING 5 119,660.19
TOTAL NET ASSETS. ENDING $12966019
8118/2009
$6,339,336.00 $15508311.00 $15,508,311.00 $21,847,641.00
643,541.000 10.200 000 00 10,200,000.00 2,556,453 00
$25,708.311.00 $25,708,311 00
$ 89,699 00
300,000.00
2,614211.00
3,500,000.00
$ 89,699.00
300,000 00
2,614,211 00
3,500,000.00
89,699.00
300,000 00
2,614,211 00
3,810,000.00 (310,000.00)
11,600 000 00
2,250.000.00
1,856,526 .00
2,082,600 00
I .4l5275.00
22,704.401.00
5 25.708,311.00
11..000,000.03
2,250,000.00
1,856,526 00
2.082.600.00
1,848,142.00
1,41,275.00
24 552 541.01)
5 27.556,453 00
11,603,000.00
2,250,000 00
1,856,526 00
2.082,600.00
1,848.142.00
1,415275.00
24,02,543.00 (310,000.001
$ 27,866,453.00 $ (310,000.00)
REVENUE OVER (UNDER)
EXPENDITURES $0.00 .....A1.8,142_n_ ...
Total Net Assets - Beginning 5222390..565.62
Total Net Assets - Ending 1221,128,212,62
($614,211.00)
Ending FY 2008 Designated Fund Balance
Designated - Debt Service
Designated - Projects
Designated - Delinq Taxes Receivable
Designated - Collection Fees
Undesignated - Fund Balance
Total Net Assets - Ending
$77,903,600.10
135,358,023.18
'1.866,589.34
$0 00
S221 .128,Z1.2.
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
ENTERPRISE FUND
TREASURERS OFFICE
ADOPTED
BUDGET
DELINQUENT TAX REVOLVING FUND 51600
AMENDED
BUDGET
FY 2009
Forecast
VARIANCE
FAVUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
REVENUES
Charges for Services
Other Revenues
Total Revenues
OPERA TING EXPENSES
Personnel Expenditures
Operating Expenditures
Internal Services
Transfer Oul to Other Funds:
General Fund - Collection Fees
OF Non-Departmental
OF- RCOC Tr-Party Agreement
Work Release Facility Debt Svc
Office Bldg Renovation Debt Svc
Into Tech Operations
52-3 District Court Debt Service
Total Transfer Out to Other Funds
Total Operating Expenses
40.88% Fay. vadance due to the increase in taxpayers inability to pay their
property taxes Collection fees and Interest on Deliquent taxes are
assesed in deliquen1 taxes, therefore as the taxpayer's inability to pay
increases, so does the revenue generated within the ID TIRF
-65.13% Unfav variance due to the economic downturn wilhin the investment
markets The DTRF's investment income will decrease due to the
econcony's investment market conditiens
0.00%
0.00%
-8.86% Fay, variance is due to more than anticipated amounts collected in
collection fees. This line item is directly correlated with the above
revenue and is transferred to the Treastier's budget at year and.
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
-1.26%
525,404.100.00 ($304 .211.00} -1.18%
CTFF *51600 Quarterly Forecast Kis 8.1812009
'OAKLAND COUNTY PARKS &
1RECREATION COMMISSION (50800)
OPERA ING REVENUE
OPERATING EXPENSE
NET OPERATING INCOME (LOSS)
NON-OPERATING REVENUE
(EXPENSE)
- $
1L5.4153,00) $
(3,51'(,000.00)
$
TOTAL NET ASSE - BEGINNING
TOTAL NET ASSE - ENDING
90,919 8E5.26
87,402,865.26
COUNTY OF OAKLAND
FY 2009 FIRST QUARTER REPORT
ENTERPRISE FUND
PARKS & RECREAIION
ADOPTED AMENDED FY 2009 VARIANCE
BUDGET BUDGET FORECAST FAW(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 8,151,454.00 $ 8,151,454.00 $ 8,151,454.00 $ 0.00% Revenue is seasonal with the majority of activity occurring in the third and fourth
Quarters,
$ 25,469,301.00 $ 2.5,460,301.00 $ 25,469,301 00 $ 0.00% Expanses are not expected to vary from the budget at this time.
$ (17,317,847.0(J) $ (17,317,847 00) $ (17.317,847.00) $ 000%
$ 15,33.5,000.00 $ 15,335,000.00 $ 15,335,00).00 $- 0.00% Fiscal Year 2009 property tax revenue for Partcs and Recreation is based on 2008-
Taxahle Value (Der erriner, 2008 levy) Thernfnre, the tax collection frinarast .• equals the bud pet estimate
0.00%
0.00%
CL00% Funds available fur 1Y2009 (IT Master Plan) and 1Y7010 Capital Program.
TOTAL INCOME BEFORE TRANSFERS 5 (1,982,847 00) 3 (1,982,847.00) 5 (1,982,047.00) 5
TRANSFERS IN 5 - 5 -
CAPITAL IMPROVEMENT PROGRAM $ _Z534,1531)91 _$ 0,534,153.001
I 01 AL NET INCOME (LOSS} $1:3,aLt.1_190,Ut) (3,51/SA0.90
'Please note: In the Adopted Budget this is the "Planned Use of Balance" Revenue line item and will provide funds for the FY2010 Capital Program..
El:17:2009
EXPLANATION OF SIGNIFICANT VARIANCES
759,521.00 759,521.00 201.830 00 ($557,691.00) Outside
OPERATING EXPENSES 4,609,032.00 4.669,032.00 3,762,826 00 846.206 00
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
INTERNAL SERVICE FUND
WATER RESOURCES COMMISSIONER
ADOPTED AMENDED FY 2009 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNF AV) PFRCFNT
[DRAIN EQUIPMENT !FUND (6390C)
OPERATING REVENUES:
Inside $3,781,611.00 $3,781,611.00 54 419,1392 ou 3637,481.00 1.6.86% Fay - Maintenance Contracts $24,200 the result of increased revenue for SCADA
maintenance charges. Fray - Rehr lied Charges $239,000 a result of rebut charges to
the CAMS Project for the CYT's data conversion component WRC staff is used for
Development and testing and then rebilled Unfav Reimbursement Bu•Iding Space
Cost ($67,847) due to the Pump Maintenance Building rate adjustment or
depreciation, electric, gas and other operating cost. Unfav - Reimbursement General
($338,050) a result of decreased spending on the GIS programs for the completion
of the GIS record conversion project, which will he offset by Salaries and Fringes.
Fav Vehicle Rental $780,17B a result of the rate increase to recover increasing
operating cost and replacement recovery cost.
• 13 43% Uinta v - External Rebilled Charges Revenue ($561,039) revenue is determined by
rebillabie repair jobs. Unfavorable amount offset by favorable Contracted Services.
Fa v - External Maintenance Contracts $3,348 the result of increased revenue for
SCADA maintenance charges
total Revenue 4,541132.00 4 541,132.00 4,620,922 00 f9.790 00 1 76%
36% Fay - Salaries and Fringes 5.338,050 the result of decrease spending on the 015
programs for the completion of the GIS record conversion project. No budget
amendment required as hours disbursed lo other systems. f:av • Contracted
Services $350,000 because of decrease in rebillable repairs. Fav - Indirect Cost
$59,784 due to Indirect cost rate tinaliFed after budget process. Fey Interest
Expense $5,000 a result of the decreasing principal balance and decrease in variable
interest rate related to the Drain Equip-rent Storage Bldg. Unfav - Maintenance
Department Charges ($16,800) 'for billing charges to Orion Township, West
Bloomfield Township and internal departments for SCADA equipment -
Equipment Repair Motor Vehicle $20,000, Material & Supplies $78,000, SI -rop
Supplies $13,800 and Drain Equipment $15,000 the result of actual spending being
less than anticipated budget projection Untav - 'telephone Communications
($13,805) a consequence of the budget not being set to actual historical usage.
NET INCOME (t 081.-:;) ar r oP,E; (67,00ct 00) (61,900 001 658,095 00 92•`,996 00 -1363 76%
8iI81.2009
TOTAL NET ASSETS- BEGINNING
TOTAL NET ASSETS - ENDING
2,516,160.74
$3,403.046 74
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
INTERNAL SERVICE FUND
WATER RESOURCES COMMISSIONER
ADOPTED AMENDED FY 2009 VARIANCE
BUDGET FIUDGET FORECAST FAVOCUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
-------
NON-OPERA IING RE VCNUFI(EXPENSE) 6 it $00.00 67.50.0C 28,800 00 (3.100.00) ray - Accrued Interest Adjustment 320,000 for accrued bookino adjustment for
investment inepne Up 112V Inc.orne from Investment ($50,000) the result of account
not earning any return due to the negative cash balance from the replacement of
vehicles !inlay - Gain on Sale of Vehicles (39,1C10,i for sale of user owned items at
County Auctions.
MANSE Lk IN 0 00 0.00 0.00 0 00 arr.%
TRANSFERS (OW ) 0.00 0.00 0 00 0.00 O.00
NET REVINUES OVEP(LINDER) S0.00 $O CO $886,856.00 $886,896 00
EXPENSES
Please note that in the Adopted Budget (line-item book} this is budgeted as "Planned Use of Fund Balance" in the revenue category.
6,1R.+200.9
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
INTERNAL SERVICE FUND
RISK MANAGEMENT
ADOPTED AMENDED FY 2009 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
[LIABILITY INSURANCE FUND 97700 I
OPERATING REVENUES.
Outside Revenue 284,537.00 S 264,500.00 - Fav. due to reimbursement pursuant to lawsutls.
Inside Revenue 2.579,244.60 2,579244.00 2,536,488.00 $ (42,700 00) -1.06% - Unfav rehilled property insurance ($33,760) due to lower premiums
than expected and rebilled charges tor medical exams ($9,000) difset
by decrease in employees medical exams and insurance expenses.
Total Operating Revenue $ 2,570,244.00 $ 257924400 S 2,82 I ,025.00 S .241.800.00
OPERATING EXPENSE $ 2,369.065 00 $ 2,440,985.00 $ 2,397,637.00 $ 4.3.400 (10 1.78% - Fay. employees medical exams $9,000 and insurance $33,700 due
to rower costs than anticipated and periodicals $750.
CLAIMS PAID 1,222,./e14.00 1,222,144 00 1,222,744.00 5
TOTAL OPERATING EXPENSES $ 3,591,809,00 $ 3,563, / 09.40 $ 3,020,351.00 $ 43,400.00 1.18%
OPERATING INCOME (LOSS i (1.012,565.00) 0,084,465.00) (799,326.60) 285,200 00
NON-OPERATING REVENUE (EXPENSE) 1,178,466.00 1,178,465.00 350,000.00 (818,500.00) -59.45% Untay, due to lower interest rates than anticipated.
NET REVENUES OVERICUNDFR)
EXPENSES S 165 901 00 $ 94 001 00 029,325 00)
TOTAL NET ASSETS - BEGINNING _ 0,113,661.08
1 0 Al Ni ASSL TS - ENDING I ,8/4,3b5.08
8' 18,2003
PFFICE EQUIPMENT FUND 66400 ,
OPERATING REVENUE - INSIDE
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
INTERNAL SERVICE FUND
MANAGEMENT AND BUDGET
ADOPTED AMENDED FY 2009 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING EXPENSE
$ 653,214.00 $ 653,214.00 5 666,20000 $ 13,000.00 1 99% Fay. due 10 purchase of new MDC units for Patrol cars. Monthly
rental to he charged to the Sheriffs budget.
E1l1J7R0fl 2,32.014.00 1,60C.00 $S81,€0000) -11.15% Unfay. indirect costs ($153,000) due to actual charges
developed after budget finalization maintenance
contracts (526.600) due to maintenance agreement on In
Car Cameras and depreciation ($13.0001 due to purchase of
MDC units. Fav. equipment maintenance $33,000 due
to fewer repairs than anticipated and equipment
replacements 380,000 due to fewer replacements requested.
OPERATING INCOME (LOSS) (38,554.00) (78,804.00) (47,400.00) _ (68,600.00)
NON-OPERATING REVENUE (EXPENSE) 78,800.40 78,800.00 50,100.00 S (28,700.00) -36.47% Unfav income on investments ($25,000) due to lower interest
rates than anticipated and gain on sale of equipment ($3,700)
due In decrease In }terns sold
NIT INCOME ILOSS} BEFORE
OPERATING TRANSFERS 40.236.00 000 (97,300.00) (97,300.00)
OPERATING 'TRANSFERS IN 0.00 0.00 0.00 $ -
NE T REVENUE OVERAUNDER)
EXPENSES (PLANNED USE OF FUND BAIT $40 236 40 $0.00 ($97,300.00) (§97,300 00),
101AL HEr ASS/. IS - BEGINNING 3.193 123.62
TOTAL NET ASSETS - ENDING 33 095 823.52
Please note that in the Adopted Budget (line-Item book) this is budgeted as 'Planned Use of Fund Balance' in the revenue category
8118..2000
[FRINGE BENEFITS FUND 67800
OPERATING REVENUE
RETIREES MFCICAL - VEBA DEBT
RETIREMENT ADMINISTRATION
DEFINED CONTRIBUTION PLAN
DEFINED cokr F21131.11 ION PLAN - PTNE
DEFERRED COMPENSATION - COUNTY
EMPLOYEE IN-SERVICE TRAINING
EMPLOYEE BENEFITS UNIT
TUITION REIMBURSEMENT
RETIREMENT HEALTH SAVINGS
GROUP LIFE INSURANCE
SOCIAL SECURITY
MEDICAL INSURANCE
DENTAI. INSURANCE
VISION INSURANCE
DISABILITY INSURANCE
SHORT-TERM DISABII1TY
WORKERS COMPENSA1 ION
UNEMPLOYMENT COMFLNSA-1 ION
INVESTMENT INCOME
E.X1- - Ft E.X BEN LIFE INSURANCE
- FLEX BEN OENTAI. INSURANCE
- FLEX BEN VISION INSURANCE
- FLEX BEN MEDICAL - EMPLOYEE
MEDICAL INSURANCE
- DENTAL INSURANDF
- VISION INSURANCE
- OWE! FURL OF DEPOSITS
- PRESCRIPTION DRUG REBATES
- TRAINING
- CHILD CARE FACILITY
- WELLNESS PROGRAM
TOTAL REVENUE
EX
EX'
EX
EX'
EX'
EX
EX
EX'
EX
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
ADOPTED AMENDED FY 2009 VARIANCE
BUDGET BUDGET FORECAST FAW(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
49,591,188 49,591, I 98 47,663,188 (1,923,00 ) -3.88% - Urtfaverableorteraling revenue for Retirees Medical and Defined Contribution
2,836.367 2836,367 2,734,367 (102,00 ) -3.60% due to the hrrrng freeze
14,363,000 14,363,000 13,997.000 (366.00) -2.55%
238,600
800,000 800,000 773,600 (26,401) -3.30%
1,431,118 1,431,118 1.382.115 (49.001) -3.42%
632,042 632.042 609,442 (27.60 ) -3.58%
350,000 360,000 345,000 (15,001 1 ) -4.17%
390,000 390,000 390,000 0.00%
643,400 643,400 648,400 5,0f 1 0,78% L 1
15,600,000 15,600,000 15,376,800 (223,2f 1 1 -1.43% •
32,720,000 32,720,000 32,640,000 180. ) -0.24% - Based on use of Blue Cross ilfustrative rates and prerniurris (Cr Health Alliance Plan. 1
3,242,000 3,242.000 .3,098.000 (144,0' ) -4.44% Based on use of Della Dental illus1rative rates.
212,500 212.500 227,500 15, 7.06% - Based on use of Uluo Cross illustrative rates.
840,000 840,000 819,200 (20, , ) -2.48%
6 .
(21, • .) -1,33%
2,674,542 2,674,542 2,869,542 195, 7.29%
1,584,000 1,584.000 1,563,000
450,000 450,000 439,000 (11, l o) -2.44%
2,436,328 2,436.328 1,015,3213 (1,421, 1 1) -58 33% - Unfavorable due to lower interest rates
105,000
110,1100
105,000
110,000
3961
103, p
97,0 0
(3, II ) -0.98%
(Ti, I I 1 -7.62% 1
400,000 400,000
(7, oil) -6.36%
Il"-t _k 9FOL _ I kn-F,,,,,F,1", reskle•ra mrs AI 11, In hi ri nn f romom a.
280.000 280,000 267.4, (12,6i I) -460% 1i
25,000 25,000 23,3 ., (1,7 I , I ) -6.80%
2,500 2.500 2,1 14111) -16.110%
10,000 10,000 15.51!1 5.511 55.00%
465.000 4E6,000 465,00 ii I 0.00%
0 0 7,5 nii 7,501 0.00%
0 0 9,5i1 9.51 i 0.00% I
o o 5,0,1 5,01i
138 375,585 136,375,596 131,685,685 11489.90k -3 29%
110,000 110,000
FRINGE BE NIFFITS ids 8.'181?009
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
ADOPTED AMENDED FY 2009 VARIANCE
'FRINGE BENEFITS FUND 678010 BUDGET BUDGET FORECAST FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING EXPENSE
RETIREES MEDICAL - VEBA DEBT PRINCIPAL 16,610,000 16,610,000 16,611:,000 o 0.00%
RETIREES MEDICAL - VEBA DEBT INTEREST 32.981,188 32,981,188 32.482,888 498,300 1.51% -Favorable due to change in the Fiscal Year payment from 100/1108.04101109 to 040109-
104113)9 Payment 10,111409 is $498,300 less than he earlier period.
RETIREMENT ADMINISTRATION 2,836,367 2,805,114 2,356, I 14 449,11 16.01% Reflects lower investifien1 fees caused by rnagketl downturn.
OFFINED CONTRIE3L) I ION PLAN 14,363,040 14,363,000 13,749,000 614,0 4 27% - Favorable due to hicins freeze.
DEFINED CONTRIBUflora PLAN - PTNE 236,803 236,600 204,100 32,5 33.74%
DEFERRED COMPENSATION - COUNTY 800,000 800,1.100 729,600 70.4 8.130%
DEFERRED COMPENSATION - AMAIN 64,800 64,800 44,000 20,8 32.10%
SICK AND ANNUAL LEAVE CASH-OUT 891,390 891,390 921,390 (30,0 ) -3.37%
EMPLOYEE IN-SERVICE TRAINING 1,081.118 1,112,371 1,050,371 56,0 5.03%
IN-SERVICE TRAINING - INFO TECH 350,000 354,000 332,300 17,7 506%
EMPLOYEE BENEFITS UNIT 632,042 632,042 616,042 16,1 2.53%
TUITION REIMBURSEMENT 360,000 360,000 312,000 48, 13.33%
GROUP LIFE INSURANCE 1,043,400 1,043.400 1,043,400 13.00%
SOCIAL SECURITY 15,603,000 15,600,000 15,268,000 332,0 2.13%
MEDICAL INSURANCE 29,600,000 29,600,000 27,515,000 2,085,0 7.04% - Favorable as result of settlement with BCBSM, Oakland County will not be charged
administrative fee in FY2009.
PRESCRIPTION COVERAGE 7,800,000 7,800,000 7,985,000 (185,0001 -2.37%
LIEN I AL INSURANCE 3,3 /2.000 3,372,1)110 3,111,400 260,600 P. /3%
VISION INSURANCE 325.000 325,000 296,000 29,00 i 8,92%
DISABILITY INSURANCE 2,424,000 2,424,000 2,289,300 134,70 5.56%
WORKERS COMPENSATION 2,674,542 2,674,542 2,674,542 I 0.00%
UNEMPLOYMENT COMPENSATION 450,000 450,000 647,400 (197,401) -43.87% - Unfavorable due to federal stimulus package allowing additional 20 weeks.
FLEXIBLE BENEFIT PAYMENTS 200,000 200,000 203,000 {3,011) -1.50%
ACCOUNTING SERVICES 109,761 109.761 107,661 2,101 1.91%
CHILD CARE FACILITY 193,1E17 153,187 190.187 3,00 1,55%
PROFESSIONAL SERVICES 300.000 300,000 300,000 0.00%
RETIREMENT HEAL TII SAVINGS 390,000 390,000 378,600 11.4 1 2.92%
WELLNESS PROGRAM 400,400 400,000 400,000 0.00%
INDIRECT COSTS 287,190 287,190 281,190 5,061 2.09%
.101AL EXPENSE 136,375,585 136,375,585 132,104,485 4,271,1 III 3,13%
NET REVENUE OVERr(UNDER) EXPENSES 0 0 (218,800) 1.218.,801))
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
13,407,454
i3 188,6540
FRINGE BENEFI TS.xls 8.'1812009
OAKLAND COUNTY INTERNATIONAL
AIRPORT (56500)
OPERA ['NG REVENUE
TOTAL INCOME BEFORE
CONTRIBUTIONS AND TRANSFERS
TRANSFERS IN
CAPITAL CONTRIBUTION
COUNTY OF OAKLAND
FY 2009 THRO QUARTER REPORT
ENTERPRISE FUNDS
CENTRAL SERVICES
ADOPTED AMENDED FY 2009 VARIANCE
BUDGET BUDGET FORECAST FAVi(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING EXPENSE
55,457,004.00 ¶5.457,064.00 54,807,084 00 (S950,000.00) -17 41% - llritay. 1-Hangar Rental ($450,000) die. tit a decrease in the rlYenhf!r pi r .
Hangars leased out arc Aviation Gas ($500,000) Cue to increase in cost and
as 5 result of the downturn in Hie economy.
$5,593,819.00 $5,b93.510.00 $5,843,519.00 ($250,000 00) -4.47% - Untav.Depreciation ($2.50,000) on recently completed projects See offset in
contributions LInLav Overtime ($25.,0001 and the fringe henefits associated
with it due to persurinel needed to clear heavy snowfall and Professional
Services (55,0001 duo to environmental consultant issues on lhe
partially offset by FEW Property I axes $80,000 due to lower than anticipated
properly ilexes for T-Harigars
NET OPERATING INCOME (LOSS) ($138,755 00) ($138,455.00) (51,330,455 00) ($1,700,000.00) 879.41%
NON-OPERATING REVENUE (EXPENSE) $ 3.584.00 $ 3,284.00 $ 3,284 00 $0.00 C 00%
(5133,171 00) ($133,171.00) $ (1,333,171.00) ($1,200,000 00)
$0.00 $0.00 $- $0.00
133,171.00 133,171.00 1.77.17100 $1.084,000 00 81399% Fay. C,apital Contributions doe lo the recording of Federal and FtMe. Grants
for projects that began in 2007 and completed in 20013 and recorded as
assets.
TOTAL NET INCOME (LOSS) $0,00 $0.0U ($116,000.00) _ ($116,000.00)
TO rAL NET ASSE IS - BEGINNING $ 08,287,949 83
TOTAL NET ASSETS- ENDING $68,17 3,949.84
8:18,'2009
'MOTOR POOL FUND 66100
OPLRA TING REVT-.NUE -
Outside Revenue $ 126,486 00 S 1 C6.500.0C 5 89,500.00 $ (11.000.00)
8.1377,865,00 6,959,165,00 $ (1,718,700 00) -'1961%
$ 8,667,713 00 $ 8,784,365 00 $ 7,048,665 00 $ (1,135,700 00)
9,024,365.00 7,585,865.00 $ 1.438,500.00
$ 61,20100 5 (240,000.00) $ (537,200.00) 5 (297,20000)
inside Revenue • Decrease in fuel revenue ($1222,000) due to lower fuel cost offset by 1 -re fay.
gasoline charges, decrease in leased equipment ($382,000) due to vet-rides turned
in Sy departments and reduction In vehicle mileage driven; reduced parts and
accessories revenue (5121,000) and productive labor 015,000) due to service less
than expected, partially offset by the fav. parts arid accessories expenses.
Fay. increase In sublet repairs $22,000 due to serf-ice more than expected.
Total Revenue
OPERATING EXPENSE
OPERATING INCOME (LOSS)
8,541,227 00
8,606,422.00 Fay selarylringe benefit reduced by S11,000 due to full time accounl clerk position
beiria filled with PTN E employee, reduced gasoline costs by $1,317,600 due to
lower fuel price; auction expenses were reduced by 514,700 due to reduction in sate
of vehicles in fall auction and increase sale of vehicles in Flint Auction . fleet
insurance 552,000 due to estimated premium savIng; decrease in insurance
reserve expense el $23500 due 10 le ss leased car accidents, reduced expenditures
in car wash 55,000 and parts and accessories $45,000
Fav, net decrease deprecation of 5139.000 due to departments holding old
vehicles longer and vehicles sold in auction before fully depreciated.
Increase in indirect costs ($187,600) due to actual charges developed after budget
finalization
240 000 00 240,000 00 74.700.00 5 (165,300.00) -68.88% - (3aini or sale of vehicles unfav ($159,500) due to sale proceeds less Mon salvage
value and increase in the meeage driven from 85K to tOOK
NON-OPERATING RF.VFNLIF (F.XPENSE)
$ (462,500.00) $ 1462,500 00)
0.00 $
$ (462,500 Cu) 5 (462,500100)
5 6.117.47943
7,74,97943
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
INTERNAL SERVICE FUNDS
CENTRAt SFRV10ES
AMENDED
BUDGET
ADOPTED
BUDGET
FY 2009 VARIANCE
FORECAST FAVOIUNFAV1 PERCENT FXPIE ANATION OF SIGNIFICANT VARIANCES
-15.96% - Reduced External Other Revenue {526,000) and Fxternal Pads and Accessories
Revenue ($6,500) due lo CVT services less than expected Fav External
Productive I abor Revenue $14.000 due to OVI services more than expected: offset
by increase in warranty reimbursement $1..500 due to GM rear axle warranty claims
handled in house.
N6 f INCOME (TOSS) BEFOF4-- OPERATING
TR4NS6ERS 5 301,291 00 5
TRANSFERS IN (Our) -
NET RFVFNUF OVERAUNDER)
EXPENSES (PLANNED USE OF FUND 8AL.) " $ 301,291.00
TOTAL N6T ASSETS 8EGINNING
TOTAL NET ASSE rS - f WING
•iTiscalSvc\Budgeld °recast. No.ifistipPORT SERVICFS.xis 8f16f20in
cri
TOTA1 NF1 ASS1- IS r-NIIING $ 282 302 12
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
INTERNAL SERVICE FUNDS
CENTRAL SERVICES
ADOPTED AMENDED FY 2009 VARIANCE
BUDGET BUDGET FORECAST FAV/IUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
—„--
MAILING, CONVENIENCE COPIER AND PRINTING FUND 66700
OPFRUING REVENIA
Outside Revenue
Inside Revenue
$ 512,500 00 $ .512,50000 $ 614.000 00 101,500 00 19.80% Fav due to increased CV I Ilirleterl postage $53,000 and stanclat"d mail $54,000
Unfav, decrease of CVT puntriJt-otrvice of ($5700 F due to less business than
expected.
3,073,528.00 3,073,528 00 2,795.528 00 $ (278,000 00) -9 04% - Unfav. due to decrease of printing revenue ($192,000) - less in-house printing jobs,
decreased metered postage $ I 18,000!1 dept less mailing partially offset by fay
convenience copier $10,000 due to more copies than expected, and increased
standard mall $26,000 dun to increasing department jobs
Total Revenue $ 3,586.028 00 $ 3,580,028 00 $ 3,409,528 00 $ (176,500 00)
3.595.228.00 (5,200.50)
$ 44.211 05 $ (4,000.00) $ (185,705.00) $ (151,100.00)
OPERATING EXPENSE
OKRA I1NG INCOME 0.,SS)
NON-OPERATING REVENUE (EXPENSE)
3 541,81? CO 3,595,02555
4.030.00 4,000 00
-0..14% - (inlay indirect costs of ($113,700) due 10 aclual charges developed after budget
Finalization, increase in standard mail ($127,c00) due lc increased CV I business &
departments jobs. I ay. salaries and fringe benefits decreased by S1.500 reduction
of summer help and overtime; reduced copier machine rental by $15,500 due to
It-',.ase on copy machine ending; decrease in printing for contracted services
$15,000, copy Charge 32,000, paper printing $54,000, printing supplies 36,000,
stationery stock $12,000 dime to less porting jobs. Fav metered postage $89,000
due to reducing department mailing business, decrease in business reply postage
Of $4,000 due to less deparlrneat business, offset by untav. busineSs reply Posl-Pgf'
revenue., reduced spending in parts and accessories of ¶2,000„ equipment
maintenance of $6,000, office supplies of $1..T00, maintenance contract of $9,900,
expendable equipment or ¶3,000, and training, travel & conference of $6.800
2,i00 00 (1,300 00) • 32.50% Onfair investment income doe to reduction of printing revenue.
NET REVENUE OVER/(UNDER)
FXPENSES (PLANNFD USE or F ONE) BAL ) $ t82150 $ $ (183,000.00) 3 (183,000 00).
TOTAL NET ASSETS BEGINNING $ 465,302.12
'Please note that in the Adopted Budget (line item budoel), Plant red 1.1se of hind Ralance appears listed with the revenue accounts.
tscal.SYCAtudgeriF °recast NeWi.SUPPORT -F;Ft ?VICES xls 8,1572009
CO
Inside Revenue 27,091,541.00 27,091,541 00 27,256,841.00 l65300.,00
FACILITIES INTERNAL FORE- xis 8/1812000
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
INTERNAL SERVICE FUND /ENTERPRISE FUND
FACILITIES MANAGEMENT
ADOPTED AMENDED FY 2009 VARIANCE
BUDGET BUDGET FORECAST FAV(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
FA-dILITIES MAINTENANCE & OPERATIONS (#63100)
OPERATING REVENUES:
Outside Revenue $570,638.00 $570,038.00 $570,638.00 0,00 0.00%
0.61% - Fav, Maintenance Department Charges to Departments based on requested level
of service $187,000. Refund of Prior Years Expenditure $39,700 to adjust project
repair costs, Contributions Operating $2,500, and Sale of Scrap $1,900; partially
offset by reduced Office Space Rental revenue based on lease agreement with
O.C. Road Commission for seam in the Information Technology Center (565,8001.
Total Revenue $27„662,179.00 527,662,179.00 $77,877,479.00 $165,300.00 0.60%
OPERATING EXPINSES 527,953,379.00 $27,891,453.00 $25,528,953.00 $2,362,500.00 8,47% - Pay Natural Gas/ Fuel Oil 5665.000 due to locking in of favorable long-term pricin§
contracts, turnover $750,000; fay. Overtime $50,000 due to moderate weather
conditions; lay. Sublet Repairs $400,000 due to County budgetary restraints 4
resulting in increased in-house repairs and reduction and/or deferral of requests;
fay. Electrical Service $600,000 due to lower cost third-party contracts; fav.
Depreciation $40,000 based on current depreciation schedule; and fay. Motor Pool
$85,000 and Telephone Communications 517.500 based on expected usage
requirements.
Favorability is partally offset by unfav. Water & Sewage Charges ($100,000) based
OR rate increase and projected usage; Indirect Costs ($75,600) due to
determination of costs subsequent to budget determination; Adjustment of Prior
Years Fxperise ($50,600) to reclassify maintenance project charges.: and IT
Operations (515,000) for replacement of plotter and laptops.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
NON-OPERATING REVENUE
TRANSFERS IN
TRANSFERS OUT
BUDGE I ED EQUITY ADJUSTMENTS
NET REVENUES OVER(UNDER)
EXPENSES`
($291,200.001 (5229,274.00) $2,298,576 00 52.527,830.00
$240,000.00 $240.000 00 $205,000.00 (535.000.00) -14.58% - Declining interest rates.
(200,000.00) (764,762.45) (764,762.45)- 0.00% - Transfers Out for Elevator Modernization Capital Project $402,836; Primary
Electrical System Maintenance Phase 1 Project $100,000; Maintenance
- - - - Projects 5200.000, and Public Works Building Ground Floor Renovation $61,926.
15251,200.00) (7754,036.45) $1,738,763.55 _$9.492,800 100
TOTAL NET ASSETS - BEGINNING $9,839,452.83
$11,518,716.38
'Please note that in the Adopted Budget (line-item hook) this is budgetec as "Planned Use of Fund Balance" in the revenue category.
TOTAL NET ASSETS - ENDING
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2009
BUDGET BUDGET FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCES
'Information Technology - Operatione (63600)
OPERATING REVENUES-
Outside $881,545.00 $861,545.00 S 183,845 00 ($17,700.00) -9.02% - Unfav.Outside Agencies ($74,000) due to reduction in external customer
requests; Deterred Land File Tax ($27,700) & Roimh 17.qi ..aii7ation Svcs
$8,800) as a result of change in billing procedures due to tax & assessment
software. Offset by Fav. Enhanced Access Fees $32,500 due to increase
customer usage.
Inside 26,888,807.00 26,888,807.00 23,060,907.00 (.3,827,900 00) - '4 24% - Utley. Dents OC Dept'i Dev & Ops ($3,523,300) &irn.aging Dev & Ops
($644,500) due to holding rates at prior year levels Clemis Oper Outside
038,466} subsequent to budget Partially offset by friv Non Govrl Dev & Oos
$3,7 8,100 due to increase in projects requested by Non-CIF.
fOTAL OPERATING REVENUE $21,150,352.00 $27,750,352 00 $23,844,752.00 t$3,905.600 OC) -14.07%
$34,168,463.00 52,419100.00 OPERATING EXPENSES $34.675,493 00 536,587,563 00 8.61% - Fay, primarily due to Deorec $1,074,400 for ir capital projects in progress not
fully operational ., Sal& FR $618000 due to vacancies; £459,600 Equipmen1
Maint due to lower than anticipated hardware maint costs, Communications
$1190,000, Service Bureau $75,000, Printing $11,000, Mem Dues 54,600 & ,
Auction $1.100 due to cost reductions: Software Lease $75,000 due to timing
of software license purchases; Internal Svcs $53,900 based on actual usage:
Travel $24,400 due to decline in staff attending conferences; Software Maint
$18,800 due to timing of actual costs for support:Parts/Access $130,000,
Contracted Svcs $53600 and Indirect Cost $18,800 due to ludget projection
slightly higher than actual rate: Prof Svcs 312,600 due to liming of previously
approved 1T projects. Partially offset by Expend Equip ($265,100) due to
equipment renlacements;Stion. lies (534,000); Acti Prior Yr Exp ($41,100):
Charge Care Fee ($03,700) credit card fees higher than anticipated. Charge
Card fees are offset by Elitianced Access revenue.
NET INCOME [LOSS) BEFOI-ZE.
OPERATING TRANSFERS (18,925,141 00) ($8,837 211 00) ($10,323,711 00) (S1,486,500 00)
NON-OPERATING REVENUE
TRANSFERS IN
fRANSFERS (OUT)
305,500.00 305,500.00 353,800.00 48,300.00 15.81% Fay. primarily due to Interest Income and higher cash balaricellian
anticipated
2,245,973.00 4,157.993 tX.I 4,1.57,990.00 0.00 0.00%
0.00 000 0.00 000 0.00%
NFT REVENUES OVER(UNDER) EXPENSE S' i$fl„373,718 (X)) ($4,30,718.00) ($5,811,918.00) $1 1‘0„).,
TOTAL NET ASSE -113kGINNING 30,489,810 57
'TOTAL NE I ASSETS - ENDING $24 677 592 57
'Please note that in the Adepten Huth iet (line-limo book i this is hiAgeted as "Manner.; Use or Fund Balance" in the revenue category
Ot)
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
5,236,841.11
$4,717,750. I 1
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
INTERNAL SERVICE FUNC)S ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2009
BUDGET BUDGET FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCES
'Information Technology - Telephone Communications (6 T500)
OPERATING REVENUES:
Oulsqle $32,000 00 $32,000.00 $31,300.00 ($70000 -2 19% Unfav Sale of Phone External due to decreased usage
Inside 3,297,400 00 3,297,400.00 3,161,300.00 (136,100 00) -4.13% Untav. Leased Equip ($9,300) due to decreased Use of pagers & Sale of
Pt!orie lnienal $120,800) due to reduction in telephone rates.
TOTAL OPERATING REVENUE $3,329,400.00 $3,329,400.00 $3,192,600.00 ($136,800.00) -4.11%
OPERATING EXPENSES $3,787,391.00 $3, M7,391.00 $3.777,991.00 ¶9,400,00 0.25% Fay Into Tech Ops 46,400 due to hiring of equT, replacements; Voice Mail
$1.500 & FACtorpool $900 due to decreased usage. Fay partially offset by
urifav. Sal & FB ($,1 001 due to average cost of salaries increases and fringe
benefits rates & Info "tech Dev 436,200) due to Telesoft upgrade.
NET INCOME (I OSS) BEFORE
OPERATING TRANSFERS ($457,991.00) ($457„991.00) 4585,391.001 ($1127,400.00)
NON-OPERATING REVENUE 30.000.00 30.000.00 66,300 00 36,300 00 121.00% Interest Income favorable due to higher cash balance than anticipated.
TRANSFERS IN 0.00 0.00 0.00 0.00 0.00%
TRANSFERS (OUT) 0.00 0.00 000 0.00 0.00%
NEf REVENUES OVER(UNDER) EXPENSES' 4427 93 0_)_0 ($519,091.00) 1$91.100.00)
Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" in the revenue category.
AMENDED
BUDGET
ADOPTED
BUDGET
!Information Technology:CLEMilS (53590)
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
FY 2009
FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING REVENUES.
Outside 53,609.172 00 53.282,914,00 53,528,914 00 5246,000.00 8.38% Fay. Parts & Access $213,100 due to Edge Modem upgrade installs;
Maintenance Contracts 5136.274 Livescan maint after warranty; Rebilled
Charges $108,300 due the additicnat crincectivity costs charged to the Tier
2.5 & 3.0 agencies, Partially offset by unfav.. Ext.Fteii ($125.000) 8. Enhanced
Access fees ($38.0001 due to timing ni implementation of Citation & F-Crash
programs, In-Oar Terminals External ($56,6001 due to budgeted MDC count
higher than actual MDC
Inside 429,404 00 429,404.00 2.336,304.00 1,906,900 00
TOTAL OPERA T ING REVENUE $4,038,576.00
OPERATING EXPENSES 511,996,054 00 511.860,054 00 $7,170,754.00 $4,095.300 00
53.20% F av. Prrnarily due lo Capital Asset Contributions for COPS MORE equip
purchases subsequent to budget projection and CLEWS support fur PSAPs
CAD equipment
34.51% Fay, Deprec 53,1 15,000 due to incorrect budget projection based on prior yrs,
capital budget plan; SaliFB 5797;100 due to underfilis & vacancies; Prof Svc.
$600,000 due to reduced contractual hours; Soft Maint $175,000 due to timr:ig
of anticipated maintenance costs; Indirect Cost $26000: Equip Maint $40,000
and Parts & Access $69,300 due to the replacement or livescan equip under"
warranty; f rave) & Cool $10,000 cosi redaction efforts. Offset by unfav,
Comm ($424,600) due to higher than anticipated MDC units; Rebillable
Services ($36.400:1 due to addil costs of the Tier 2.5 & 3 0 agencies; Software
purchases ($23,100) staff requiring development toots to complete various
CLEMIS rimier:As, Expend Equip ($250,000) due to Edgue modem upgrades.
53,712.318 00 $5,865,218.00 $2,152,900.00 8.39%
($1,905,536 001
10,000,00
1;589,11/.00
0.00
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
NON-OPERA I INC3 REVENUE
TRANSFERS IN
TRANSFERS (OUT )
NIT Rt-vE NUES OVER(UNDER) EXPENSES'
($7,907,478.00) (58,153,736.(10)
60,060.00
1,489,117 09
0.00
(56,408,361 00) ($6,604,619 00)
$6,240,700.00
(50,000.00) -83.33%
100.009,00 6.72%
r 0.00 0.00%
60,000 00
1,489,117.00
0.00
(5306,419.09) _ $6,298,2(10 09
lJnfav. Interest Income due to lower cash balance than anticipated.
TOTAL NET ASSETS - BEGINNING 9,456,89.48
TOTAL NET ASSETS - ENDING 59,150,170.48 _
Please note that in the Adopted Budget (line•item book) this is budgeted as "Planned use of Fund Balance" in the revenue category
¶5,019,7.00 $3,741,636.00 $5,670,036.00 S 1.928,400 00
•$5,340,242.00 $4,062,922.00
S7,337,333.00 S7.337,654.00
$6,519,122.09 52,456,200.00 60.45%
56,037,354.00 51,300,300.00 17.72%
($1,997,991.00)
150,000.00
165,809.00
(150,000 00)
($3,2"74, r32 .00)
150,000.00
515,809.00
(256„807 00)
$481,768.00
469,400 00
515,809.00
(256,807.001
51,230,170.00
53,756,500.00
339,400.00
0.00
0.00
54,095,900,00
226.27%
0.00%
0.00%
164.28% Favorable Internal Revenue for Leased Equiginent $463.700: Parts Access
$60,000 & Productive Labor $4,100 due to timing of the projected phase-cut
of the legacy system
320,965.00 321,286.00 M9,086 00 527,800.00 Inside
AMENDED
aVriGET
ADOPTED
BUDGET
'Information Technology - Radio Communications (53600
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
INTERNAL SERVICE FUNDS I ENTERPRISE FUND
INFORMATION TECHNOLOGY
FY 2009
FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCES
51.54% Fey. 5-911 $2,124,600 due to higher than anticipated revenue from wireless
co. & Outside Agency $135,900 due lo timing of phase out of legacy system.
Unfav, offset by Antenna Site Mot ($332,100) due to consolidation & paging
phase-out.
52.335.868.79
553,566,033.79
book) this is budgeted as 'Planned use ott und Balance" in the revenue oateuory.
NET REVENUES CVER(UNDER) EXPENSES' II2,86573=
OPERATING REVENUES:
Outside
TOTAL OPERATiNG REVENUE
OPERATING EXPENSES
NET INCOME {LOSS) BEFORE
OPERA( ING TRANSFERS
NON-OPERATING REVENUE
TRANSFERS IN
TRANSFERS (OUT)
tOTAt NET ASSETS - BEGINNING
TOTAL NE I ASSF I'S - ENDING
Please note that in the Adopted Budget (line-item
Fay. primarily due to Deprec $1,978.900 due to timing of implementation 41
new system, Special Projects $44,100 due to timing of exp;Parts & Accessn''
$63,000 doe to decreased costs: Utilities $38,840 based on seasonal usage:
Sal&FB $26,900 due to lower than artic.-ipated overtime; IT Oper 117.400 due
to decreased usage; Small Tools & Supplies 517.300 due to timing of
purchases: Indirect Cost $7,300, Motorpool $7,100 & Freight $2,600 due to
lower than anticipated usage. Fay. partially offset by untav.. CLEWS charges
($413,300) for CAD support tees for legacy system, Expendable Equip
(5327,100) due to NG911 equip replacernMs; Prof Svcs ($20,000) due to
increase conliactual costs; Equip Maint (5'111,400) due to maintenance of
legacy systermTower ($9,000) due to cuntractual increases for leased towers;
Comm (510,100) due to increased connectivity costs:Training Related
($4,800) for training and IT Dev (57,260) due to usage.
Fay. primarily due to Interest Income: higher cash baiance than anticipated
$199.689..00:
$159,685. .00
$C4.2.609.00
$206,515.00
$206,515.00
$649,317.00
$206,815.00
5206,815 00
$627,117.00
$300.00
$30000
$22,200.00
(5442,920.00) ($447,602 00) (5420,302.00) $22,500 00
2,000.00 2,000IU0 3,400.00 1,400 00 70.00% Interest Income favorable due to higher cash balance than anticipated.
438,705.00
0..00
($2,215.00)
445,413.00 445,413.00
0 00 0.00
$4,611.00 $28,511.00 523.4.9.0.012,,
0.00 0.00%
0.00 0.00%
ADOPTED
BUDGET
AMENDED
BUDGET
COUNTY OF OAKLAND
FY 2009 THIRD QUARTER REPORT
INTERNAL SERVICE FUNDS (ENTERPRISE FUND
INFORMATION TECHNOLOGY
FY 2009
FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCES
Fire Records Management ( 53100)
OPERATING REVENUES
Outside
o t AL OPERATING REVENUES
OPERA T ING EXPENSES
NFT 1NCOMF (LOSS) BEFORE
OPERATING TRANSFERS
NON-OPERATING REVENUE
TRANSFERS IN
TRANSFERS (OUT)
OPERATING INGOMF (LOSS)
0.15% Fav. primarily due to implementation of new agency.
0.15%
3.42% Fay, Equip Maint $20,000 duo lc negotiating Valcom contract to time &
materials flaSnS for hardware maint;Communications $9,200 delay in
connectivity costs relative In implementation at new agencies; Sal & FR
$7,200 due to On Call reduced salaries; 'Travel $2,000 & Personal Mileage
SI.'CO due to decreased demand fur ['dais to travel lc member sites.
Software Maintenance $1,400 due to decreased rates and Expend Equip
$7,600 decreased equip replacements. Fay. partially offset by unfav. Software
Purchase (12,100) due to the timing of software license purchases for new
member agencies ; IT Dev ($9,300) dire to programming services; Indirect
Cost ($2,900) & neprec ($2,200) due to purchase 1)1 server equip after -•
TOTAL NET ASSETS- BEGINNING 310,782.77
TOTAL NFT ASSFTS - ENDING $339,20.3 77
Please note that in the Adopled Budget (line-item book) this is budgeted as "Planned use of Fjrd Balanee" in the revenue category and Budgeted Equity Adj in F.gpenses
I HEREBY APPROVE THE FOREGOING RESOLUTION
h
Resolution #09185 September 2, 2009
Moved by Middleton supported by Nash the resolutions (with fiscal notes attached) on the Consent
Agenda. be adopted (with accompanying reports being accepted).
AYES: Burns, Capello, Coleman, Coulter, Douglas, Gershenson, Gingel., Gosselin, Greimel,
Hatchett. Jackson, Jacobsen, Long, McGillivray, Middleton, Nash, Potter, Potts, Runested,
Schwartz, Scott, Taub, Woodward, Zack, Bullard. (25)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the Consent
Agenda, were adopted (with accompanying reports being accepted).
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
September 2, 2009. 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 2nd day of September, 2009.
eat
Ruth Johnson. County Clerk
4,