HomeMy WebLinkAboutResolutions - 2010.03.25 - 10181MISCELLANEOUS RESOLUTION #13.051 March 25, 2010
BY. FINANCE COMMITTEE. TOM MIDDLETON, CHAIRPERSON
IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2010 FIRST QUARTER FINANCIAL
FORECAST AND FY 2010 — FY 2012 BUDGET AMENDMENTS
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
WHEREAS Public Act 621 of 1978, the Uniform Budgeting and Accounting Act for Local Units of
Government, provides for adjustments to the adopted budget; and
WHEREAS in accordance witi Oakland County General Appropriations Act Section 22, which authorizes
budget amendments for variances between the budgeted revenue and actual revenue, and Section 23, which
authorizes budget amendments for variance between estimated revenue and projected expenditures, amendments
are required: and
WHEREAS the Fiscal Year (FY) 2010 First Quarter Financial Forecast Report has identified several
variances and budget amendments are recommended; and
WHEREAS the Fringe Benefit — Retirement budget for the Probate Judges was inadvertently omitted and
the budget for Probate Court's Information Technology — Imaging Operations was inadvertently duplicated by
$237,861, and a budget amendment is recommenaed to Probate Courts budget to reallocate $160,000 from Into
Tech Imaging Operations to Frrige Benefits — Retirement and the remaining $77,861 to the Non-Departmental
Budget Transition account; and
WHEREAS the Treasurer's Office exceeded the $15,000 allotment apprcved by the Board per MR #09117
for transitional expenses, and a budget amendment is requested to reallocate a total of $4,283 from the Treasurers
Capital Outlay account ($1,414) and projected favorability in Township & City Treasurer's Bonds ($2.869) to the
Treasurer's Transition Expense account in the amount of $3,499 and the remaining $784 to Non-Departmental
Budget Transition account to balance the accounts; and
WHEREAS the Sheriff's Office is requesting a budget amendment to reduce allocation for Motor Pool and
Motor Pool Fuel Charges by $65.644 to reflect a reduction in the number of vehicles per the budget task for FY
2010, FY 2011 and FY 2012; and
WHEREAS grant funding for the Sheriffs Narcotics Enforcement Team Unit (NET) was reduced, and the
Sheriff has requested a budget arnendrneet to utilize $100,000 in Forfeiture Funds to offset increased expense in,
Overtime for the NET Unit and avoid layoffs; and
WHEREAS a budget amendment is recommended in the Sheriffs Office to reallocate $60,000 from
Medical Supplies in the Administration Division to the Corrections Division to reflect budget with the actual
expenses: and
WHEREAS a transfer in the amount of $185,000 is requested from the Sheriff's investigative/Forensic
Division to the CLEMIS Fund (#53500) for the purpose of updating software technology within the Sheriff's Forensic
Laboratory: and
WHEREAS use of revenue collected from the Prosecutor's Operating While Intoxicated (OVVI) Program for
001L's is only allowed for program enhancements, and a budget amendment is requested by the Prosecutor's
Office to reallocate $175.000 from the OUIL Third Offense account to the Enhancement Funds for OWI account to
more appropriately account for the revenue; and
WHEREAS a budget amendment is recommended to reallocate the following budgets funds to more
accurately account for actual expenses:
- $36.000 from NSF Check Fees revenues to Program Income revenue.
-$5,000 from Expendable Equipment expenses to Security Supplies expenses for purchase of bulletproof
vests; and
WHEREAS the Prosecutor's Drug Forfeiture Funds (GL Account #222440) had been used to offset the
expense for the Prosecutor's Narcotics Enforcement Team (NET) position, and with depletion in available funds,
they are no longer sufficient to continue funding the NET position; and
WHEREAS the Prosecutor has found excess funds through the Budget Transition to offset the loss of
revenue, and a budget amendment is recommended to reduce the Prosecutor's Enhancement Fund revenue (from
Forfeiture Funds) and the f‘tan-Deoartrnental Budget Transition by ($142,600). The Prosecutor olans to offer long-
term structural reductions at a later date; and
WHEREAS the budget for Forfeiture of Bonds revenue is budgeted in tne Prosecutor's Office Budget as
wed as the Clerk a Office Budget. However, the Clerk's Office receives the actual revenue, and a budget
amendment is recommended to consolidate revenue from the Prosecutor's Office Budget ($80.000) with the Clerk's
Office to correspond the budget with the appropriate department due to the Prosecutor's increased efforts in
recovery of forfeited bonds, and increase the Non-Departmental Budget Transition by $42,793 to reflect the
favorabirity in Forfeiture Bonds from the Clerk's Office; and
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote with Long absent.
WHEREAS a budget amendment is recommended in the Auditing Division to reallocate $1,000 from both
the Training and Computer Supplies accounts to Professional Services and Office Supplies accounts to more
appropriately account for actual expenses, and
WHEREAS Human Resources Workforce Management Division has initiated a request for proposal (RFP)
to purcnase new examinations to update and validate testing for Youth Specialists Correction Deputies and Road
Patrol Deputies, as existing need updating. A budget amendment is requested by the Woreforce Management
Division to reallocate 524.000 from projected savings in Recruitment Expense to Examination Materials to cover the
cost of the new exams. anc
WHEREAS due to rate increases publishing notices and electrical services within the Homeland Security
Division, the budget is projecting an unfavorable variance estimated at $10,900, and sufficient funding is available
within the Division's other operating expenditures to offset the unfavorable variance; and
WHEREAS a budget amendment totaling $11,917, is recommended to correct the line-item account for an
amendment previously approved per MR #09172 ; which reappropriated Salaries to Per Diems for the Michigan
Department of Human Services — Oakland County Board within the Health and Human Services Department
budget; and
WHEREAS an adjustment is recommended in the Children's Village Division budget in the amount of
$46,129 to reflect the current Children's Village School Operating Contract per Amendment #3; and
WHEREAS the Circuit Court Probation Division is requesting a budget amendment of $1,518 to reallocate
funds within their budget to more accurately account for actual expenses; and
WHEREAS a budget amendment is recommended in the Medical Examiner's Office tc reduce revenues
and expenditures by $5,000 (FY 2010) and $10,000 (FY 2011 and FY 2012) due to the discontinuation of contracts
wan other municipaiities, aria reallocate funds in various accounts to more accurately reflect the budget with actual
expenses; and
WHEREAS the Economic Development Administration Division received a $20,000 contribution for
operating expenditures for the Business Roundtable and reauests an amendment to accept this donation; and
WHEREAS M.R. #09223 approved the creation of the Oakland Micro-Loan Program for Oakland County
and established a midget cf $100,000 within Me General Fund (#10100), and after further review by Corporation
Counsel, it has been recommended that the budget be transferred to the Economic Development Corporation
Special Revenue Fund (#21180); and
WHEREAS Planning and Economic Development Services is requesting a reallocation of funds in the
amount of $30.000 witnin the division's budget to more accurately reflect the budget appropriation with anticipated
operating expenditures; and
WHEREAS a budget amendment is recommended to transfer ICMA revenue in the amount of $200,000 for
Defined Contributions from the General Fund to the Fringe Benefit Fund (#67800) to more accurately reflect the
budget with the actual revenue; anc
WHEREAS a budget amendment is recommended for the Community Corrections Division in the amount
of $34.533 to appropriate funds approved per MR #0e157 for contract with vendor to develop an objective pretrial
assessment tool; and
WHEREAS costs associatPri with Drain Assessments are projected tc be unfavorable approximately
$331.000 due to one-time construction assessments expected to be assessec in FY 201C for the Franklin Sub-
Watershed drainage district; and
WHEREAS Indirect Cost in the Non-Departmental budget is projecting favorable revenue, and a budget
amenament is recommended to recognize the increased revenue in Indirect Cost by $335.533 to offset tie contract
for developing a pretrial assessment tool in Community Corrections and the increase in Drain Assessments; and
WHEREAS a budget amendment is recommended to the Prosecutor's Cooperative Reimbursement
Program (CRP) Fund (#27315) to reallocate $7,000 from the Motor Pool account to the Motor Pool Fuel Charges
account to more accurately reflect the budget with the actual expenses; and
WHEREAS the Community Corrections Division is requesting a budget amendment to reallocate $10,797
from Fringe Benefits to Contracted Services within the Community Corrections Comprehensive Grant Fund
(#27370) to correct the budget appropriation created with grant acceptance as approved per M.R. #10007; and
WHEREAS a budget amendment is recommended to transfer a total of $190,000 in Bio-Terrorism Grant
funds (#28605) from the FY 20091FY 2010 CPBC Agreement to the Project Work Order Fund (#40400) to upgrade
building security for preparedness purposes; and
WHEREAS the Children's VIllage Screening Grant (previously under Fund #28002 by a separate grant)
has been incorooratea with tie FY 200912010 Comprehensive, Planning, Budgeting, and Contracting (CPBC)
Agreement under Fund #28310 - Health Adoiescent Screening in the amount of $73,000 as approved per MR
#09250. while Fund #28002 is still reflecting a budget of $73,000, and a budget amendment is recommended to
delete the duplicate budget from Fund #28002; and
WHEREAS the Economic Development Corporation (EDC) Board has approved the FY 2010 Special
Revenue Budget for the EDC, and a budget amendment is recommended to amend tne FY 2010-2012 Special
Revenue Budget in the amount of $12,000 for the Economic Development Corporation Fund (#21180) and also
recognize $100,000 from the General Fund per the recommendation of Corporation Counsel for the Oakland Micro-
Loan Program approved per MR #09220; and
WHEREAS budget amendments are recommended for the CDBG-R Grant — Fund #29715 ($1,015,800),
Neighborhood Stabileation Program Grant -#29733 ($17 383,776), and Homelessness Prevention and Rapid Re-
Housing Grant — Fund #29720($1,553.232), for FY 2011 and FY 2012 to recognize grant funding has not been
authorized beyond FY 2010; and
WHEREAS an amendment is recommended to the Information Technology Fund (#63600) tc reallocate
funds in the amount of $98,820 from Administration to Application Services for various projects such as the IT
Enhancement Budget Projects and Second Generation Access Oakland Land Projects Program, which require
technological enhancements to improve efficiency in operations; and
WHEREAS a budget amendment is requested to the Fire Records Management System Fund (#53130) to
reallocate $11,200 from Equipment Maintenance to Software Maintenance for system maintenance; and
WHEREAS a budget amendment for $168.967 in FY 2010, $113,067 in FY 2011, and $10,468 in FY 2010
is recommended in the Airport Fund (#56500) to update the depreciation budget and recognize additional Capital
Asset Contributions to match current estimates; and
WHEREAS the Department of Facilities Management will replace the Maximo Work Order System with
Azteca Collaborative Asset Management System (CAMS) Work Order, Project Management, and Customer
Request System in order to leverage the existing Oakland County CAMS Infrastructure. The cost to implement
CAMS for the Department of Facilities Management is $893,824, which includes $839,029 for IT Development
services, $30,000 for software. $16.670 for hardware, and $8,125 for training. Funding of $8,125 is available in the
Fringe Benefit Fund (#67800) Employee In-Service Training Unit's Information Technology account to fund the
training, requiring no budget amendment and $885,699 ;s available within tne Facilities Maintenance and
Operations Fund (#63100) Equity to fund IT Development services, software, and hardware, and a budget
amendment is recommended to transfer the funds from FM8i0 Fund to the Collaborative Asset Management
System Fund; and
WHEREAS the George W. Kuhn (GWK) Drainage Board approved the loan of $893,305 at the February
23, 2013 Drainage Board Meeting from available monies in the GWK Drainage Fund (#58510) to the Drain
Equipment Fund (#63900) in order to be able to replace two (2) vector trucks and one (1) jetter truck baseo on the
following stipulations.
- The Drain Equipment Fund is to repay the GVVK Drainage Fund over a five-year period, and is to pay
interest based on the investment pool interest rate as determined by the County Treasurer.
- The Drain Eauiprnent Fund would charge out far the use of the equipment to various sewer and drains
sewers in order to recover the revenue necessary to repay the principal and interest.
- The estimated interest for FY 2010 is $10,000, and the Drain Equipment Fund already has an amount
budgeted in the interest expense line item #765031 in order to cover a portion of the FY 2010 interest
expense: and.
WHEREAS a budget amendment is recommended for FY 2010 to budget the Interest Expense and
revenue fcr Vehicle Rental in the amount of $6.000 in the Drain Equipment Fund (#63100) and budget $10,000 in
the GWK Fund (#58510) for Interest Credited: and
WHEREAS a budget amenarrent of $118.000 is recommended to reappropriate funds within the Capital
Cooperative initiative Revolving Fund (CCIRF — Fund #21150) for continued collaborative projects; and
WHEREAS the County has received adcitional Gentians for the Oaklano County Lady Justice Restoration
Project in the amount of 3300 and OLHSA donated a TV. DVDNCR, and cart to the Sheriffs Work Release Facility
TO improve the deivery of services to the populaticn assigned to Work Release:
NOW THEREFORE BE IT RESOLVED that tne Board of Commissioners accepts the Fiscal Year 2010
First Quarter Financial Report.
BE If FURTHER RESOLVED that the FY 2010— FY 2012 Budget be amended pursuant to Schedules A
and B.
BE IT FURTHER RESOLVED that donations be accepted for the Economic Development Business
Roundtable, Oakland County Lady Justice Restoration Project. and Sheriffs Work Release Facility
Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution
?MANGE gaVIMITTEE
JrPARTMEN -
TO:
FROM:
Lexie Van Pelt Director
Vik (5111--'
$ 19,721,953
( 19,440,689)
281,264
$ 4,48_1
irOAKIAIND*-8 L. BROOKS PATTERSON, OAKLAND COUNTY EXECUTIVE
OUNTY MICHIGAN
SUBJECT;
DATE:
O MANAGEMEN- AND BLIEIET
Members of the Finance Committee
Laurie Van Pelt, Director, Management and Budget
Tim Soave. Manager, Fiscal Services
Nancy Fournier, Chief, Fiscal Services
LaVerne Smith, Supervisor of Fiscal Services
Letter of Transmittal - Fiscal Year 2010 First Quarter Report
March 1,2010
A
FY 2010 FIRST QUARTER REPORT
Attached please find the Fiscal Year (FY) 2010 First Quarter Forecast Report. In total. Fiscal Services forecasts that
the County will complete Fiscal Year 2010 with overall favorability of V,481 in General Fund / General Purpose
(CIF/GP) operations. CIFIGP includes all operations except grants, enterprise funds and internal service funds. This
overall favorability is split between receiving ($276,783) less revenue than anticipated and projected favorability in
expenditures of S281.264.
The variances listed above are presented to reflect the true fiscal activity of the County for FY 2010 as detailed below:
Revenue Variance
Add back -- Planned use of Fund Balance
Revenue Variance (Comparing Actual to Approved Plan)
$( 3,596,559)
3,319,776
S( 276,783)
Expenditure Variance
Planned Set Aside for Budget Transition
Expenditure Variance (Comparing Actual to Approved Plan)
Net Variance from FY 2010 Activity
The above presentation differs from the County's financial reports, which are prepared in accordance with Generally
Accepted Accounting Principals (GAAP). The variances, if present rxl purely according to GAAP would be:
Revenues - over/(under) budget S( 3,596,559)
Fxpenditures (over)/under budget 19,721,953
Total Officially Reported Favorability $ 16,125.34
The differences in the presentation revolve around the Planned Use of Fund Balance (on the revenue side) and the
Planned Set Aside for Budget Transition (on the expenditure side).
I . The amended revenue budget assumed the use of $3,319,776 in fund balance. Although use of fund balance
was budgeted, GAAP does not allow fund balance to be "recorded as revenue - leaving a large negative
variance because revenue is budgeted (anticipated), but not received (recorded). Such a presentation
ignores the reality that the County planned to use fund balance; in reality there is no negative variance.
2. Likewise, on the expenditure side, the budget inc1aded a planned positive variance of $19,440,689 whic'e
reflects "credits - provided for each elected official based upon the fact that they accelerated budget
reductions. These credits will be reappropriated in future fiscal years in order to smooth the process of
structural budget reductions. These positive variances were planned before the fiscal year began and
therefore do not reflect expenditure favorability from reduced expenditures experienced during FY 2010.
By removing these planned negative and positive variances from the forecast presentation, the presentation will more
accurately reflect the impact of fiscal activity generated from FY 2010 operations.
EXECUTIVE OFFICE I3ULDING 41 WEST • 2100 PONTIAC LAKE RD DEFT 400 • WATERFORD MI 48328-0409 • (248) 858-2163 FAX (2415') 452-9172
EMAIL; varipem 00Etk,govzom
REVENUES
GF/GP revenues are (0.07%) less than budget or ($276,783). The majority of the unfavorability is the result of the
following events:
A. CHARGES FOR SERVICES - Unfavorable: ($1,152,399)
• Circuit Court revenues are forecasted unfavorable ($252,000) related to court costs and reimbursement of
defense attorney tees as a result of inability to pay.
• District Court revenues are forecasted unfavorable ($800,000) due to a reduction in collections for multiple
accounts.
• The Sheriffs Office is unfavorable ($589,000) mostly due to Diverted Felon reimbursement from the State
which was discontinued after development of the budget.
• Revenue for the Water Resource Commissioner is forecasted favorable $565,756 in reimbursement General
which is offset by unfavorable personnel costs in the General Fund.
B. INDIRECT COST RECOVERY - Favorable: $800,000
• Rates were approved after the FY 201.0 budget recommendation. Revenue budget estimates anticipated a
decrease in grants and a decrease in expenses that are allocated for indirect costs,
C. OTHER REVENUE - Favorable: $91,116
• Other Revenues anticipates favorability in the Treasurer's Office due to increased coltection fees which are
transfen-ed to the General fund from the Deiinquent Tax Revolving fund (DTRF).
EXPENDITURES
In total, expenditures are projected to be 0.07% under budget or $281,264. Note this total favorability, includes
$389.647 of accelerated reductions which will be used to offset future budget shortfalls. Many departments have
experienced personnel savings as the result of hiring freeze, turnover and under-filling of positions.
As the year progresses this overall net unfavorability may change to favurability as departments continue to work to
reduce their costs and reorganize. The only departments projected to be unfavorable at the end of the fiscal year
(barring any amendments) are the Sheriffs Office, Water Resources Commissioner, Non-Departmental and Li orary
Board.
A. Sheriffs Office — Unfavorable: $(4.359,700)
• The department is forecasted unfavorable mostly due to the final ruling as a result of union arbitration. The
ruling approved a higher salary increase than non-union employees. Overtime is unfavorable due to the
updated salary rates and vacancies.
B. Water Resources Commissioner Unfavorable: S(682,368)
• Increased Salary and Fringe Benefits are related to the Collaborative Asset Management System project
(CAMS). Note that increased costs are offset by increased revenue. A budget amendment will be presented at
a later date.
C. Non-Departmental Budget — Unfavorable: $(151.000)
• The General Fund is assessed a portion of Water Resources Commissioner construction Chapter 20 project.
This is a one time cost unlike most Drain Assessments which are for maintenance of storm drains.
D. Library Board — Unfavorable: $(13,268) ▪ Internal Services expenses have not decreased as much as estimated,
2.
(237,861.00) $
160,000.00
77,861.00
(237,861.00)
160,000.00
77,861 00
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2010 12011 / 2012 FIRST QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2010
AMENDMENTS
GF/GP OPERATIONS - SEt I-. BALANCING AMENDMENTS
GENERAL FUND (#10100)
Dept Program Acct Fund Att. Account Name
FY 2011 FY 2012
AMENDMENTS AMENDMENTS
124015 773633 Probate Ct. Into Tech - Imaging Operations
121091 722770 Probate Ct. - Retirement
196030 740023 Non-Dept - Budget Transition
Total Expenditures
Probate Court
Expenditures
3040403
3040101
9010101
Treasurer*s Office
ExPenditures
7010101 182025
7010101 185040
7010101 186070
9010101 196030
731990 Treasurer - Transition Expense
760126 Treasurer - Capital Outlay
732039 Treasurer - Twp & City Treasurer Bonds
740023 Non-Dept - Budget Transition
(237,861.00) $
160,000.00
77,861.00
- $
3,499.00
(1,414.00)
(2,869,00)
784.00
Sheriffs Office
Expenditures
4030101 112620
4030601 112620
4030301 112620
4030401 112590
4030401 112670
4030601 110010
4030901 110090
4030601 116220
740023 Admin - Budget I ransition
776659 Patrol Svcs Motor Pool Fuel Charges
776661 Corr Svcs - Motor Pool
776661 Corr Svcs Sat - Motor Pod
776661 Corr Svcs Sat - Motor Pool
77666 fi Patrol Svcs - Motor Pool
776661 invest/Forensic Svc - Motor Pool
776661 Patrol Svcs - Motor Pool
Total Sheriffs Office Expenditures
$ 65,644.00 $ 65,644.00 $ 65,644.00
(12,238.00) (12,238 00) (12,238 00)
(10,320.00) (10,320.00) (10,320.09)
(4,560 00) (4,660.00) (4,060.00)
(5,160.00) (5,160.00) (5,160.00)
(16,345.00) (16,345.00) (16,345.00)
(11,118.00) (11,118.00) (11,118 00)
(5,993.00) (5,903.00) (5,903.00)
$ - $ - $ _
4--
Y 2011
AMENDMENTS
FY 2012
AMENDMENTS
Prosecutor's Office
Revenues
4010101 122050
4010101 122050
Prosecu1or's Office
Revenues
4010101 122050
4010191 122050
Expenditures
4010101 122050
4010101 122050
(175,000.00) $
175,000.00
_
(36,000.00) $
36,000.00
(5,000.00)
5,000.05
(175,000.00)
175,000.00
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 201012011 12012 FIRST QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GFIGP)
FY 2010
AMENDMENTS
IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS
GENERAL. FUND (#10100)
Dept Program
Sheriffs Office
RevenUeS
4030101 110090 670285 Enhancement Funds
Total Sheriffs Office Revenue
$ 100,000.00
$ 100,000.00
Acct Fund All, Account Name
Expenditures
4030101
4030301
4030901
4030901
4030901
(50,000.00)
60,000.00
112630 750301 Admin - Medical Supplies
112830 750301 Corr Svcs - Medea/ Supplies
110090 712020 InvestiForensic - Overtime
110040 750203 Forensic Lab Equipment
110040 788001 5'3500 I ranster Out to CLEMIS Fund
Total Sheriffs Office Expenditures
(60.000.00) $
60,000.00
100,000.00
(185,000.00)
185,000.00
100,000.00 $
(60,000.00) $
60,000,00
631428 OUR_ Thifd Offense
670285 Enhancement Funds (from OVV I Program)
Total Prosecutor's Office Revenues
531330 Prosecutor .Admin - NSF Cheek Fees
631617 Prosecutor Admin Program Income
Total Prosecutor's evenues
750154 Prosecutor Admin - Expendable Equipment
750490 Prosecutor Admin - Security Supplies
Total Prosecutor's Expenditures
$ (175,500.00) $
175,000.00
(36,000.00) $
36,000.00
(5,000.00)
5,000.00
- $
(36,000.0C)
36,000:00
(5,000,00)
5,000.00
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2010 / 2011 2012 FIRST QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (CF/GP)
FY 2011
AMENDMENTS
FY 2012
AMENDMENTS
FY 2010
AMENDMENTS
IGF/GP OPERATIONS - SEll BAI ANCING AMENDMENTS
GENERAL FUND (#10100)
Dept Program Acct Fund Aff. Account Name
Prosecutor's Office I Non-Departmental
Revenue
4010101 123030 670285 Pros. Off - Enhance. Funds (Forfeiture Funds) $ (142,600.00) $ (142,800 00) $ (142,600.00)
Total Prosecutor's Revenue $ (142,600.00) $ (142,000.00) (142,600.00)
Expenditure
P010101 182200 740023 Non-Dept - Budget Transition
Total Non-Dept Expenditure
$ (j42,600.00) $ (142,600.00) $ (142,600.00)
$ (142,600.00) $ (142,600.00) (142,600.00)
Prosecutor's Office / Clerk's Office
Revenues
4010101 122050 630798 Prosecutor Admin - Forefeiture at Bonds $ (80,000.00) $ (80,000.00) $ (80,000.00)
2010201 125000 630812 Cleric's Office - Forefeiture of Surety Bonds .. 122,793 00 122,793.00 122,793.00
Total Revenues $ 42,793.00 $ 42,/93.00 $ 42,793.00
rxpencliture
9010101 182200 740023 Non-Dept - Budget Transition
Total Non-Dept Expendilure
42,793.00 $ 42,793.00 $ 42,793.00
42,793.00 $ 42,793.00 42,793.00
County Executive - Auditing Division
Expenditures
1010201 181010 731458 Professional Services $ 1,000.00 $ 750.00 $ 500.00
1010201 181010 731941 Training (1,000.00) (750.00) (500.00)
1010201 181010 750049 Computer Supplies (1,000.00) (1,000.00) (700.00)
1010201 181010 750399 Office Supplies 1,000.00 1,000.00 700.00
Total Auditing Division E.y.pendituEes
Human Resources
Expenditures
1.050402 183020 731.570 HR Wrkforce Mgmt - Recruitment Exp $ (24,000.00)
1050402 183030 730681 HR Wrkforce Mgmt - Examination Materials 24,000.00
403 Total HR Dept Expenditures $ - -
FY 2011 FY 2012
AMENDMENTS _AMENDMENTS
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2010 F 2011 / 2012 FIRST QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF1GP)
FY 2010
AMENDMENTS
[GF/GP OPERATIONS - SELF BALANCING AMENDMENTS
GENERAL FUND (#1010Sa
avl Program Acct Fund Aff. Accoun1 Name
Health and Human Services
Homeland Security Division
xperiditures
1060601 115090 730072
1060601 112100 730562
1060601 112100 731150
1060001 112100 750168
1060601 112100 730716
Advertising $ 900.00 $ 900.00 $
Electrical Service 10,000.00 10,000.00
Maintenance Contract (10,240.00) (10,240.00)
FA Prop Equip Exp (900.00) (900.00)
Fees Civil Service 240.00 240.00
Total Health & Human Svcs - Expenditures $ - $ - $
900.00
10,000.00
(10,240.00)
(900.00)
240.00
Administration Division
Expenditures
1060102 135000
1060102 135000
1060102 135000
1060601 115090
1060601 115090
1060601 133000
1060601 135000
/ Homeland Security Division
702010 1-IHS Admin - Salaries $ (1,750.00) $ (1,750.00) $ (1,750 00)
722810 HHS Admin - Disability (38.00) - -
730709 1-IHS Admin - Fees Per Diem 5,000.00 5,000.00 5,000.00
702110 Homeland Security - Per Diem (5,000.00) (5,000.00) (5,000.00)
722770 Homeland Security - FB - Retirement (5,129.00) (5,167.00) (5,167.00)
722770 I lomeland Security - FB - Retirement 1,917.00 1,917.00 1,917.00
702010 Homeland Security - Salaries 5,000.00 5,000.00 5,000.00
Total Health & Human Svcs Expenditures $ - $
----- - $ _
Childrens' Village Division - Fund #20293
Revere
1060501 112090 630224 Child Care State Aid
Total Children's Village Revenue
$ 46 129 qo S.
46,129.00 $
46,129.00 $ 46,129,00
46,129.00 $ 46,12900
Expenditure
1060555 112210 731899 Teachers' In-Service 46,129.00 $ 46,129.00 $
Total Children's Village Expenditure 46,129 00 $ 46,129.00 $
46 129.00
46,129.00
Expenditures
1070601
1070601
1070601
1070601
1070601
1070601
1070601
1070601
1070601
1070601
1070601
1070601
1070501
1070601
1070601
1070601
1070801
1010101
132030 730373
132030 730646
132330 733653
132030 731031
132030 731115
132030 731213
132030 731241
132030 731339
132030 731941
132030 732011
132030 732018
132030 750182
132030 750280
132030 750301
132030 750399
132030 776659
132030 776651
181000 740023
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2010/ 2011 1 2012 FIRST QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2010
AMENDMENTS
FY 2011
AMENDMENTS
FY 2012
AMENDMENTS
IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS
GENERAL FUND (#101Q
Dept Program Acct Fund Aft. Account Name
Public Services - Circuit Court Probation
E_x_penditures
1070901 113270 750049 CCP/Pontiac Supv. - Computer Supplies $ (1,518.00) $ (1,51E000) $ (1,518.00)
1070901 113270 750399 CCP/Pontiac Supv - Office Supplies 1,518.00 1,518.00 1,518.00
Total Circuit Court Probation Expenditures $ - $ - $ -
Public Services - Medical Examinees Office
Revenue
1070601 132030 632079 ME Services - Service Fees
Total MEG Revenue
(5,000.00) $ (10,000.00) $ (10,000.00)
(5,000.00) $ (10,000.00) $ (10,000.00)
ME Svcs - Contracted Services $ 300.00 $ 300.00 $ 300.00
ME Svcs - Equipment Maintenance 2,000.00 2,000.00 2,000.00
ME Svcs - Equipment Rental (1,000.00) (1,000.00) (1,000 00)
ME Svcs - Laboratory Fees 13,998.00 13,998.00 13,998.00
ME Svcs - Licenses and Permits (1,300.00) (1,300.00) (1,300.00)
ME Svcs Membership Dues (3,000.00) (3,000.00) (3,000.00)
ME Svcs - Miscellaneous 300.00 300.00 300,00
ME Svcs - Periodicals, Books Pub, and Sub 2,000.00 2,000.00 2,000.00
ME Svcs - Training (8,950.00) (8,950.00) (8,950.00)
ME Svcs - Transoortalion Service (18,000,00) (18,000.00) (18,000.00)
ME Svcs • Travel 8. Conference (2,000.00) (2,000.00) (2,000.00)
ME Svcs - Film & Processing (19,000.00) (10,000.00) (19,000.00)
ME Svcs - Laboratory Supplies 15,000.00 15,000.00 15,000.00
ME Svcs - Medicat Supplies (10,000.00) (10,000.00) (10,000.00)
ME Svcs - Office Supplies (1,500,00) (1,500.00) (1,50100)
ME Svcs - Motor Fool Fuel Charges (4,400.00) (4,400.00) (4,400.00)
ME Svcs - Motor f'ool (19500.00) (19,500.00) (19,500.00)
County Exec - Budget Transition _ 50,052.00 _45,0.52.00 . 45,0_52.00
Total MEO Expenditures $ (5,000.00) $ (10,000.00) $ (10,000.00)
(30,000.00)
30,000.00
$ (200,000.00) $ (200,000.00) $ (200,000.00)
S35,533.00 200,000.00 zaosoo.00
$ 335,533.00 $ _ - $
34,533.00
301,000.00
335,533.00
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2010 12011 / 2012 FIRST QUARTER BUDGET AMENDMENTS
GENERAL FUND1GENERAL PURPOSE (GF/GP)
FY 2010
AMENDMENTS
FY 2011 FY 2012
AMENDMENTS AMENDMENTS
GF/GP OPERATIONS - SELF BALANCING AMENDMENTS
GENERAL FUND (#10100)
Dept Proaram Acct Fund An. Account Name
Economic Development - AdministratCon
Revenue
1090101 171000 650301 Admin - Donations
Total Econ Dev - Acknin Revenue
20,000.00
20,000.00
Expenditures
1090101
1090101
1090101
1090101
171000 732165 Admin - Workshops and Meetings
171000 731458 Admin - Professional Services
171000 731969 Admin - Transfer to Reserve
171000 7E13001 21180 Admin Transier Out to EDC Fund
Total Eoon Dev - Admin Expenditures
20,000.00
(25,000.00)
(75.000.00)
100,000.00
20,000 00
Economic Development. Planning and Economic Development Services
Exponitures
1090201 171000 731458 PEPS - Professional Svcs
1090201 171115 731780 PEDS - Software Support Maintenance
Total PEDS Expenditures
Non-Departmental / County Executive/ Community Corrections Division
[Revenues
1010101 181000 631743 County Exec Admin - Refunds Misc
9010101 182200 640100 Indirect Costs
Total Revenues
Expenditures
1070401 113000 731458 Comm Corr Admin - Professional Svcs
9010101 155080 740044 Drain ,Assessments
Total Expenditures
(7,000.00) $
7,000.00
- $
(7,000.00) $ (7,000.00) -
7,000.00 7,000.00
-
SCHEDULE B
ACCOUNT NUMBER
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2010 12011 / 2012 FIRST QUARTER BUDGET AMENDMENTS
PROPRIETARY! SPECIAL REVENUE FUNDS
FY 2010
AMENDMENTS
FY 2011 FY 2012
AMENDMENTS AMENDMENTS
1PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS 1
Dept ID Program Acct fund Aft Oper Unit Account Name
Central Services - Motor Pool Fund #66100
Revenues
1030811 100000 630833 Gasoline Oil Grease Charges
1030811 100000 631071 Leased Equipment
Total Motor Pool Fund Rev.
$ (12,238.00) $ (12,238.00) $ (12,238.00)
(53,406.00) (53,406.00) (53,406.00)
$ (65,644.00) $ (65,644.00) $ (65,644.00)
Expenses
1030811 100000 750210 Gasoline Charges
1030811 100000 761156 Depreciation Vehicles
Total Motor Pool Fund Exp.
Prosecutor's Office - Cooperative Reimbursement Program (CRP) Fund #27315
Grant- Detail - GR#0000000143
Expenditures
4010201 126070 776661 Litigation - Motor Pool
4010201 126070 776659
Total Prosecutor CRP Fund Exps
Litigation - Motor Pool Fuel Charges
$ (l223800) $ (12,238.00) $ (17,238.00)
(53,406.00) (53,406.00) (53,406.00)
$ (65,644.00) $ (65,644.00) $ (65,644.00)
Community Corrections Comprehensive Grant Fund #27370
Grant Detail - GR #0000000093; Activity - Agencies
Expenses
1070401 113035
1070401 113035
722740 Comm Corr Electronic Monitor - Fringe Ben
730373 Electronic Monitoring - Contracted Svcs
Total Comm Corr Grant Exps
$ (10,797.00) $ (10,797.00) $ (10,797.00)
10,797.00 10,797.00 10,797.00
$ - $ - $ _
Health Bio-Terrorism Grant Fund #28605
Grant Detail - GR #0000000277
Expenses
1060290 133915 730373
1060290 133916 730373
1060290 133915 788001 40400
1060290 133916 788001 40400
Health Div - Contracted Services (125,000.00)
liealth Div - Contracted Services (65,000.00)
Health Div - Transfer Out 125,000.00
Health Div - Transfer Out 65,000.00
Total Bio Terrorism Grant Exps
E_xuenses
060501
060501
060501
060501
060501
060501
060501
060501
060501
060501
00 702010
00 722750
00 722770
00 722790
00 722820
00 730926
00 731241
00 731458
00 732018
00 750399
1 2
2
2
2
2
2
2
2
2
2
15,000.00 $
(3,000,00)
15,000.00
(3,000 00)
12,000.00 $ 12,000.00
2,000.00 $
1,000 00
1,500.00
5,000.00
2,500.00
12,000.00 S
2,000.00
1,000.00
1,500.00
5,000.00
2,500.00
12,000.00
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2010 / 2011 12012 FIRST QUARTER BUDGET AMENDMENTS
PROPRIETARY I SPECIAL REVENUE FUNDS
ACCOUNT NUMBER
!PROPRIETARY I SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID prociram Acct Fund Aff Octer Unit Account Name
Children's Village - Children's Village Screening Fund #28002
Grant Detail GR #0000000114
Revenue
1060501 112100 610313 Grants- State
Total CV Grant Revenues
1Y 7010 FY 2011 FY 2012
AMENDMENTS AMENDMENTS AMENDMENTS
(73,000.0_0) (73,000 00) $ (73,000.00)
(73,000.00) $ (73,000.00) $ (73,000.0)
Salaries (50,924.00 $ (56,924.00 $ (56,924.00)
FB - Worker's Compensation (336.00 (336.00 (336.00]
FB - Retirement (371.00 (371.00 (371.00:
FS - Social Security (413.00 (413.00 (413.00:
FB - Unemployment Insurance (57.00 (57.00 157.00:
Indirect Costs (7,217.00 (7,217.00 (7,217.00:
Miscellaneous (1,400.00 11,400.00 (1,400.00:
Professional Services 15,000.00 15,000.00 15,000.00:
travel & Conference (1,000.00 (1,000 00 (1,00100
(
Office Supplies 282,00 282.00 (282.00
Total CV Grant Expenses (73,000.00) $ _ 73,000.00 $ (73,000.00)
Economic Development Corporation (EDC) Fund #21180
Revenues
1090202 171110 630280 Closing I Re $ 15,000.00 $
1090202 171110 655385 income From Investments (3.000.00)
1090202 171110 695500 10100 Transfer In From GF 100.000.00 _
Total EDC Fund Revenues $ 112,000.00 $
Expenses
1090202 171110 739709 Foes/Per Diern $ 2,000.00 $
1090202 171110 731213 Membership Dues 1,000.00
1090202 171110 731388 Printing 1,500.00
1090202 171110 731458 Professional Services 100,000.00
1090202 171110 731507 Public Notices 5,000.00
1090202 171110 732165 Workshops & Meetings 2,500.00 0•
Total EDC Fund Expenses $ — 112,000,00 $
expenses
1090601
1090601
1-090601
Revenues
1090601 172135 610313
1090601 172170 610313
172135 702010 Salaries
172135 722740 Fringe Benefits
172170 7'31498 Public Facirty & improvment's - General
Total COBG-R Grant Expenses
Federal Operating Grants
Federal Operating Grants
Total CDBG R Grant Revenues
Activity A; Source Type A; Operating Unit 27008
Federal Operating Grants
Federal Operating Grants
Federal Operating Grants
Federal Operating Grants
10131NSP Grant Fund Revenues
Salaries
Fringe Benefits
Down Payment Assistance
salaries
Fringe Benefits
Acguistion Rehab Resale 120
Total NSP Grant Fund Expenses
$ (650,000 00) $ (650,000.00)
(4,998,467.00) (4,998,467.00)
(1,738,377.00) (1,738,377.00)
(9,996,932.00j (9,996,932.00)
$ (17,383,776.00) $ (17,383,776 00)
$ (390,000.00)
(260,000.00)
(4,998,467.00)
(1,043,026 00)
(695,351.00)
(9,996,932.00)
$ (17,383,776.09)
(390,000.00)
(260,000.00)
(4,998,467.00)
(1,043,026.00)
(695,351.00)
(9,996,932.00)
$ (17,383,776.00)
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 20101 2011 I 2012 FIRST QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
FY 2010
AMENDMENTS ACCOUNT NUMBER
FY 2011 FY 2012
AMENDMENTS AMENDMENTS
'PROPRIETARY/ SPECIAL REVENUE FUNDS SELF BALANCING AMENDMENTS
Dent ID program Acct Fund Aft Oyer Unit Account Name
Community Affairs & Home Improvements - CDBG - R Grant Fund #29715
Grant Detail - OR #0000000443, Project Bus Unit - COMHI; Activity A; Source Type A; Operating Unit 27012
$ (101,580.00) $ (101,580.00)
(914,220.00) (914,220.00)
$ (1,015,800.00) $ (1,015,800.00)
(60,948.00) $ (60,948.00)
(40,632.00) (40,632.00)
(914,220.00) (914,220.00)
$ (1,015.800.000) $ (1,015,800.00)
Neighborhood Stabilization Program Grant Fund #29730
Grant Detail - GR #0000000411, Project Bus Unit - COMHI;
Revenues
1090601 132210 610313
1090601 132231 610313
1090601 172131 610313
1090601 172134 610313
Expenses
1090601 132210 702010
1090601 132210 722740
1090601 132231 730860
1090601 172131 702010
1090601 172,131 722740
1090601 172134 730007
Homelessness Prevention & Rapid Re-Housing Grant Fund #29720
Grant Detail - GR #0000000442; Project Bus Unit - COMHI; Activity A; Source Type A; Operating Unit 27011
Revenues
1090207 172133 610313 Federal Operating Grants
1090659 132221 610313 Federal Operating Grants
Total HPRR Grant Revenues
(77,661.00) $ (77,661.00)
(1,475,571.99) (1475,571.011
$ (1,553,232.00) $ (1,553,232.00)
Program Fund Aff Oper Unit Account Name Acct
(46,597.00)
(31,064.00)
(1,475,57100)
$ (1,553,232.00)
Information Technology • CLEM'S Fund #53500
Revenue
1080301 116020 695500 10100
xpense
1080305 116020 731773
Information Technology Fund #63600
Expenses
1080101 152000 731458
1080101 152010 731458
Fire Records Management System (FRMS) Fund #53100
Lxpenses
1080325 115100 730646
1080325 115190 731780
Expenses
1030701 154010
1030701 154010
1030701 154010
1030701 154010
761007
761049
761084
761121
SCHEDULE B
ACCOUNT NUMBER
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2010 12011/ 2012 FIRST QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
FY 2010 FY 2011
AMENDMENTS AMENDMENTS
FY 2012
AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID
Expenses
1090207 172133 702010 Salaries
1090207 172133 722740 Fringe Benefits
1090659 132221 737808 South Oakland Shelter
Total HPRR Grant Expenses
(46,597.00)
(31,064.00)
(1,475,571.00)
$ (i322)
Airport Fund #56500
Revenues
1030701 154010
1030701 154010
Transfer In From General Fund (Sheriff)
Total CLEMIS Fund Revenues
Software Rental Lease Purchase
Total CLEMIS Fund Expenses
Admin - Professional Services
Application Svs - Pro1essional Services
Total Info Tech F-und Expenses
Equipment Maintenance
Software Maintenance
Total FRMS Fund Expenses
Depreciation - Land Improvements
Depreciation - Roads Parking Lots
Depreciation - Buildings
Depreciation - Equipment
185,000.00
185,000.00
185,000.00
185,000.00
(98,820.00)
98,820.00
(11,200.00)
11,200.00
$ (135,093.00) $ (135,093.00) $ (135,093.00)
304,060.00 248,160.00 145,501.00
$ 168,967.00 $ 113,067.00 $ 10,468.00
$ 1,013,181.00 $ 965,629.00 $ 891,324 00
5,840.00 5,840.00 5,840.00
605,572.00 597,224.00 593,685 00
(1,570,137.00) (1,570,137.00) (1.587,865.00)
650104 Contributions Operating
690189 Capital Assets Contributions
Total Airport Fund Revenues
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2010 2011 12012 FIRST QUARTER BUDGET AMENDMENTS
PROPRIETARY! SPECIAL REVENUE FUNDS
ACCOUNT NUMBER
[PROPRIETARY SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
FY 2010 FY 2011 FY 2012
AMENDMENTS AMENDMENTS 'AMENDMENTS
Dept ID Program Acct
1030701 154010 761156
Fund Aff Oper Unit Account Name
Depreciation - Vehicles
Total Airport Fund Expenses 168,967.00 $ 113,067.00 $ 10,468.00
114,511.00 114,511.00 107,484.00
Facilities Maintenance and Operations Fund #63100
Revenue
1040701 140101 665882 Planned Use of Fund Balance
Total FMO Fund Revenue
885,699.00
885,699.00
ppense
1040701 140101 788001 42050 Transfer Out to CAMS Fund
Total F-MO Fund Expense
885,699.00
885,699.00
Collaborative Assest Management System Fund #42050 - Proj Bus Unit MAJOR, Project #100000001347
Revenue
9016001 152130 695500 63100 Transfer In From FM0 Fund
Total CAMS Fund Revenue
$ 885,699.00
885,699.00
Expenses
9016001 152130 731773 Software Purchase $ 30,000.00
9016001 152130 760132 Computer Equipment 16,670.00
9016001 152130 731458 Professional Services 502,797.00
9016001 152130 773630 IT Development 336,232.00
Total GAMS I mil I xpenses $ 88b,899.00
Drain Equipment Fund #63900
Revenue
6010101 149760 632401 Vehicle Rental 6,000.00
Total Drain Equipment Revenue $ 6 UU0 00
Expense
6010101 149760 765031
George IN, Kuhn Fund #58510
Revenue
6010101 149030 655616
Expense
Interest Expense 6,000.00
Total Drain Equipment Expense $ 6,000.00
Interest Credited 10.000.00
Total George W. Kuhn Fund Rev $ 10.000.00
6010101 149030 796500 Budgeted Equity Adj.
Total George W. Kuhn Fund Exp
10,000.00
10,000.00
FY 2010
AMENDMENTS
FY 2011 FY 2012
AMENDMENTS AMENDMENTS
Expense
9010101 132320 731458 Professional Services
Total CCIRF Expense
118,000.00
118,000,00
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 20101 2011 12012 FIRST QUARTER BUDGET AMENDMENTS
PROPRIETARY I SPEC1AL REVENUE FUNDS
ACCOUNT NUMBER
[PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENis
Dept rp Program Acct Fund AN Oper Unit Account Name
Capital Cooperative initiative Revolving Fund (CCIRF) #21150
Revenue
9010101 132320 655385 Interest Income 118,000.00
Total CCIF-0 Revenue 118,000.00
Fringe Benefit Fund Immo
Rfflvenue
9011501 133190 635530 Ext. Other Revenue $ 200,000.00 $ 150,000.00 $ 150,000.00
Total Fringe Benefit Fund Revenue $ 200,000 00 $ _ 150,000.00 $ 150,000.00
Expense
9011501 183190 730506 Defined Contribution County Retirement $ 200,000.00 $ 150,000.00 $ 150,000.00,
$ 200,000.00 $ 150,000.00 $ 150,000.00
Genera' Fund/General Purpose
Favorable/(Unfavorable1 4,481.04 4.481.06 •
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
GENERAL FUNDIGENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
FY 2010
ADOPTED
BUDGET
BUDGET
AS
AMENDED
FY 2010
FORECAST
AMOUN7
FAVORABLE;
'UNFAVORABLE PERCENT
REVENUES
5ENERAL FUND
Taxes
Feder& Grants
Stale Grants
Other intergovernmental Revenue
Charges for Services
indeed Cosi Recovery
investment income
Otrier Revenues
PLANNED USE OF FUND BALANCE C.)
TOTAL GF/GP FUNDS
5 218.302 555.00 $ 218.302,655.00
607 675.00 667475.00
9.126.244 00 '3,799.038.00
11.261 944 00 11,261,844.00
84.149.466 00 83,07t31400
8.517,499.00 8,517499.00
2.761,800.00 2,761.800.00
64.878,753 00 64.878.753.00
150 000 00 $ 3,319 776.15
$ 409,835,838.00 $ 411,800454.15
5 216,298.555 03 $ 4D00.00
687,675 03
16.799.058.00
11.281,94.O3
61.918.915.00 (1,152,399 001
9,317.499 00 800,000 00
2.750.300 00 (1,50000)
64,969,869.00 91.115.00
$ 406.003,785M $ (276,763 0o; -0.07%
5 3.319,776.15 $ 0.00%
$ 411,323,571.15 $ 1276.783,00) -0.07%
SUB•TOTAL GENERAL FUNDiGENERAL PURPOSE $ 409,685 :936.00 5 408,280,678.00
000%
0.00%
0.00%
0 00%
-1.39%
9 39%
-0_42%
0.74%
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court
52nd District Court
PfClaate Court
TOTAL ADMIN, OF JUS7CE
LAW ENFORCEMENT
Prosecuting Attorney
Sheriff
TOTAL LAW ENFORCEMENT
GENERAL GOVERNMEN-
Clerk/Register of Deeds
Treasurer
Board of Con misstoners
Library Board
Water Resources Commissioner
TOTAL GENERAL GOVERNMENT
COUNTY EXECUTNE
County Executive Admn
Management and Budget
Central Services
Facilities Management
Humar Resources
Hearth and Human Services
Public Services
Economic Dev. and Comm Afteirs
TOTAL COUNTY EXECUTIVE
TOTAL DEPARTMENTS
NON-DEPARTMENTAL APPROPRATIQNS
TOTAL NON-DEPARTMENTALS
TOTAL GOVERNMENTAL EXPENDITURES
$ 51,777 693 00 $ 52,120.031.00 5 50,189,031.00 5 1,931.000 00 370%
16,021.852 00 15,038.071.00 15.807,271.00 260 800 40 1.75%
6.118,222.00 8.110,01300 5.001,6" 3.0C 168 400 00 2.73%
5 73.917,757.00 $ 74.378.115.00 5 71,997.9' 5.DC $ 2.330.200 00 3.20%
18,938,315.00 18.975,153,40 18.463.653 40 511,500.00 2.70%
122,698,301.00 122,251,083.87 126.610,783 87 (4,359,700.00 -3.57%
S 141,636.61600 $ 141,226.237.27 5 145,074.437 27 $ (3,843.200 00', -2.72%
11,506.251 00 11,510,922.50 10.838.422.50 772.000,00 6.65%
3,503.775 00 1573,254.04 3.657,254.04 16.000 40 044%
2.917,944.00 2.917,986.00 2,883,486.00 34.500,00 1,13%
1,932.861.00 1,933.532.00 1.946,850.00 {13,268 00) -0 69%
5,312,346 00 5.384,030.00 8.067.348 00 {662.368 M -12.67%
$ 25,175,177 00 $ 25,520.724.64 $ 25.393,360 54 5 127.36460 0.50%
$
6.140,454.00 5 5,141,729 00 5 6.048,729.00 5 95:000.00 1.55%
19,612.002.00 19,988.056,00 19,353,058.00 535.000.00 3.18%
2.072,18500 2,091,177.00 2,085,177 04 5.00030 0.24%
1.289:24000 1.289,247.00 1.2.55.547.DC 32 70C. 00 2 54%
4,133,433.00 4,184,48300 4.002.253 00 122.200 40 2.92%
04,353,220.00 66,116,837.84 65,520,337 84 500 :500.00 089%
15,531,624.00 15.623,755.60 15,588,155.54 37.600.04 0.24%
7.289.434 00 . 7.633,942.00 7.379.042.00 254,900.00 3.34%
S 120,421,602.00 $ 123,069.197.34 5 121.296,297.34 5 1,772.900 00 144%
5 361,151,152.00 $ . 364.194,27418 5 363,762,000o 5 5 432.264.00 0.12%
6 48,684,776.00 5 47,406,080.00 5 47,5.57.300.00 5 (151 .000 D0) -0 32%
$ 409,335,938 00 $ 411,600,364.15 $ 41'1.319,080.15 $ 281,284.00 0,07%
(1) Note that report forecasts Planned Use of Fund Balance with a zero vanance in order to show a balanced budget. No revenue will actually De received.
Li
FY 2010
FORECAST
217,995,055.00
98,500.00
1,0,000.00
84,000.00
218,298,555.00 $
68,000.00 $
82,000.00
169,947.00
46,000.00
21,728.00
300 000,00
687,675.00 $
- $
1,000.00
169,947.00
4,557,204.00
14,070,887.00
18,799,038.00 $
Amount
Favorable
fu nfavorable)
(4.000.00)
(4,000.00)
Amended
Budget
217,996,055.00 $
98,500.00
120,000.00
88,000.00
218,302,555.00 $
68,000 00 $
82,000.00
169,947.00
46,000.00
21,728 00
300,000.00
687,875-00 $
- $
1,000.00
169,947.00
4.557,204.00
14,070,887 00
16,799,038.00 $
8,940,000.00
54,000.00
4,500.00
2,750.00
300,000.00
1,960,094.00
11,261,944.00
8,940.000 00
54,000.00
4,500.00
2,75000
300,000.00
1,960,894.00
11,261,944.00 $
$ 217,996,055.00 $
98,500.00
120,000.00
88,000.00
$ 218,302,555.00 $
66.000.00 $
82,000.00
169,947.00
46,000.00
21,728.00
300,000.00
CHARGES FOR SERVICES (630000-635999)
Administration of Justice
Cimuil Court - Judicial/Adnninrstration
Circuit Court - Civil/Cnminal
1000.00 $
3,050,500.00
3.000,00 $
3,050,500.00
3,000.00 $
2,820,500.00 (230,000 00)
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FY 2010 FIRST QUARTER REPORT
TAXES (601000-6019991
Property Taxes - July Tax Levy
Other Taxes - Delinquent Tax - Prior Years
Treasurer Payment in Lieu of Taxes
Other Taxes - Trailer Tax
Total Taxes
FEDERAL GRANTS (810000-610999)
Sheriff - Patrol
Sheriff - Corrective Services
Prosecuting Attorney
Homehand Security - Disaster Control
Health Division
Children's Village
Total Federal Grants
STATE GRANTS f615000415999)
Sheriff - Patrol
State Match Foster Care
Prosecuting Attorney
Econ Development
Health Division
Non-Departmental - Child Care Subsidy
Total State Grants
Non-Departmental
HHS - Homeland Security
Circuit Court
Datrict Court
Sheriff
Non-Departmental - Reim Judges Salaries
Total Other Intergovernmental Revenue
Adapted
Buds
667,675.00 $
8,940,000.00
54,000.00
4,500.00
2,75000
300.000.00
1,960,694 00
11,281,944.00
Percent
0.00%
0.00%
000%
-4 55%
0.00%
0.00%
0.00%
0.00%
000%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
$
1,000.00
169,947.00
4,882.410,00
14,072.887.00
$ 19,126,244.00 $
OTHER INTER-GOVERNMENTAL REVENUES (620000 - 826999)
Explanation of Significant Variances
000%
-7.54% Unfav. variance is due to the shortfall in Court Casts of
($200,000) and Defense Attorney Fee payments of
($60,000) . Statewide the ability for the public to pay has
fallen due to the economic downturn and high
unemployment rates. These amounts are offset by the
increased activity in the Circuit Court's e-filing program of
$30,000.
Revenue variance is partially offset by an expenditure variance
District Court - Division III (Rochester Hills) 4,541,209.00 4,541,209.00 4,171,209.00 (370,000.00)
COUNTY OF OAKLAND
GENERAL FUND GENERAL PURPOSE REVENUES
FY 2010 FIRST QUARTER REPORT
Amount
Adopted Amended FY 2010 Favorable
elteleet Etudeet FORECAST (unfavorable) Percent explanation of Significant Variances
Circuit Coue - Family Division 2,017,650.00 2,017,650.00 1,995,650 00 (22,000.00) -1.09°A, Unfav variance is due to a slow start in collecting some new
fees established as part of he Circuit Court's 2010 budget
task eihmission of (M3,000) offset by a ire!ease le
collections of Defense Attorney Fee payments 0( 53,000 and
Court Services Fees Probation of $11,000. The Court
submitted within its 2010 budget task a plan to generate now
revenue streams by instituting some new lees, however, to
date this new revenue has been slow in materialielng due to
some initial procedural issues being worked ow by the court,
Reimbursement,and clients.
District Court - Division I (Novi) 4,293,565.00 4,293.565.00 4,393,565.00 100,000.00 2.33% Fav. variance due to the court's increased Fines and Costs
schedule, Garnishment fee revenue and caseload increase.
During 2009 the 52nd District Court implemented a new
fines and costs schedule. The new schedule combined with
an increase in caseload has improved their revenue
collections. During economic downturns the public's ability
to pay their bills drops resulting In an increase in legal
remedies include-rg garnishments.
District Court - Division II (Clarkston) 2,321,056.00 2,321,056 00 1,961,056.00 (360,000,00) -15.51% Unfav. variance due to a reallocation al state law
enforcement resources and a decrease in deleerdants' ability
to pay. le July of 2009 a Stale Police poses resources were
reallocated causing fewer patrols and less cases entering
into the court. The caseload drop combined with the public's
decrease in ability to pay have contributed to the decline in
court revenue The District Court's 2010 budget lase
included an increase in its revenue by establishing a Default
Fee, Show Cause Fee, Warrant Cost fee and increase its
Probation Report cost fee. After reviewing historical and
current data the Department of Management budget
requested the court submit plans to replace the revenue
increases. The court will be requesting approval of these
plans from the Board once they have been completed.
Unfav. variance due to a decilitre in caseload and decreased
ability for the public to pay. The District Court's 2010 budget
task included an increase in its revenue by esteblishing a
new Default Fee, Show Calise Fee, Warrant Cost lee, and
Probation Report Cost fee After reviewing historical and
current data the Department of Management and Budget
requested the court submit plans to replace the revenue
increases. The Court will be requesting approval of these
plans from the Board once they have been completed.
Revenue variance is partially offset by an expenditure variance.
Adapted
Budget
2,418,079.00 District Court - Division IV (Troy)
Probate Court - Estates and Mental Health 556,300 00
Total Administration of Justice
Law Enforcement
- PreserAtting Attorney
$ 19,211,359.00 $
805,300.00 $
Sheriffs Office
Sheriff - Administrative Services
Sheriff - Corrective Services
Sheriff - Corrective Services Satellites
Sherifi - Emer. Prep. Training & Comm.
Sheriff - Patrol Services
Sheriff - Investigative Forensic Services
196,900.00
437,100.00
1,743,266.00
1,325,926 00
591,611 00
33,342,194 00
792,392 00
196,900.00
441,800.00
1,111,266 00
1,329,726.00
591,611.00
32,046,803.00
825,692.00
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FY 2010 FIRST QUARTER REPORT
Amount
Amended FY 2010 Favorable
Budget FORECAST (unfavorable} Percent Explanation of Significant Variances
2,418,079.00 2,248,079.00 (170,000.00) -.7.03% Unfav, variance due to a decrease in the public's ability to
pay. The District Court's 2010 budget task included an
increase in its revenue by establishing a new Default Fee,
Show Cause Fee, Warrant Cost fee, and Probation Report_
Cost fee. Afier reviewing historical and current data the
Department of Managemere and Budget requested the court
submit plans to replace the revenue increases. The Court
will be requesting approval ot these plans from the Board -
once they have been completed.
566,300.00 525,300.00 (41,000 00) -7.24% Unfav variance is due to the cloud experiencing a reduction
in Gross Estate lees which are based on a percentage of an
estate's value Estate values are declining due to the
economic downturn and property values dropping.
19,211,359.00 $
805,300.00 $
196,900.00
437,100.00
1,743,266 00
1,325,926.00
591,611 00
32,046,803.00
792,392.00
18,118,359.00 S (1,093,000.00)
3.23% Fay, variance due to receipt of intermittent, non-budgeted
revenue that is not predictable such as Extradition Recovery
Fees, Microfilming, and Welfare Fraud Case Review
revenue receipts,
0.00%
4,700.00 1.08% Fey, variance due to receipt of intermittent, non-budgeted
revenue that is not predictable such as Misc, and
Photographs revenue receipts.
(632,000.00) -36.25% Unfav. due to the indefinite cessation of Diverted Felon ,
payments from the State of Mich., partially offset by lay.
Hospital Cost Recovery receipts.
3,800.00 0.29% Fav due to rnisc receipt cif Reimbursement of Salaries not
budgeted in this division
0.00%
0.00%
4.33% Fav. due to increased receipts of Confiscated Property,
Reimbursement of Salaries, and Misc revenues in excess of
budgeted amounts
831,300.00 $ 26,000.00
34,300,00
$ 39.234,689.00 $ 37,941,298.00 $ 37,378,098.00 $ (563,200 00) 1 otal Law Enforcement
General Government
Clerk - County Clerk
Clerk: - Elections
Clerk - Register of Deeds & Micrographics
Treasurer
Board of Commissioners
Library Board
2,257,700 00 $
260,000.00
7,200,200.00
1,923,530 00
600.09
27.00.0.00
2,261,700 $
260,000 00
7,200,200 00
i ,923,530 00
600.00
27,000.00
2,418,909 00 $ 151,700.00
260,000.00
7,358,200.00
1,923,530.00
800.00
27,000.00
6.67% Fay Forfeiture of Surely Bonds $122,793 due to
Prosecuting Attorney pursuing old bonds, Certified Copies
$82,634 and Gun Permits $76,000 due la an increase in
activity; patially ollset by unfav. Forfeiture of Bonds
($137,207) due to a decrease in counter activity.
0.00%
2.19% Fay Fnhanced Access Fees $200,000 due to an increase in
on-line activity, partially offset by unfav. Photostats ($37,000)
due to a decrease in activity
0 OD%
0.00%
0.00%
158,000.00
• Revenue variance is partially offset by an expenditure variance.
Adopted
Budget
1,827,240.00
Amended
Budget
1,821,240.00
FY 2010
FORECAST
2,392,096.00
Amount
Favorable
junfaivorablel Percent
565,756.00 30.96%
13,S06,2t0.00 $ 13,506,270.00 $
200,000.00 $
14,381,226 00 $
- $ 200,000.00 $
Untav. Reimbursement Salaries from Small Business 1 ech
Council (535.000), which is instead providing part-time staff
assistance to PEDS; and reduced Reirnbursemeut General
($15,000)11pm new Main Street Program membefs due Io
economic downturn.
0.00%
0.00%
-10.26%
-14.67% Pay phone commission is unfav. due to less activity at the
jail
-14.67%
COUNTY OF OAKLAND
GENERAL FUND I GENERAL PURPOSE REVENUES
FY 2010 FIRST QUARTER REPORT
Water Resources Commissioner
Explanation of Significant Variances
F av - Reimbursement General $682,365 due to CAMS
projent planning/requirements phase; original estimate
included development/testing phase hours now expected in
FY 2010; offset by unfavorable salaries, hinges and drain
equipment Linfav - Soil Erosion Fees ($120,000) due to
decrease in building activity/permits due to downturn in
housing market.
Total General Government
County Executive
County Exec - Administration
874,956.00
(200,000.00) -100.00% Revenue is received under the Fringe Benefit Fund. A
budget amendment is recommended to move revenue from
General Fund to Fringe Benefit Fund.
(6,155.00)
(5,000 00)
450,000.00)
County Exec - Auditing
&B - Purchasing Division
&B - Equalization Division
&B - Fiscal Services Division
BervkattS - Support Services
actlities Engineering
uman Resources
HS - Administration
HS - Health Division
HS - Children's Village
HS • Homeland Security
ublic Services - Community Corrections
ublic Services - MSU Extension
Public Services - Medical Examiner
Public Services - Animal Control
Economic Dev. & Comm. Affairs - Admin
Economic Dev. & Comm. Affairs - PE DS
30,000.00
170,000.00
2,827,141.00
415,600.00
153,000.00
800.00
2,812,337 00
3.019,530.00
300,000.00
46,555.00
199,000.00
785,887 00
487,300.00
30,000.00
170,000.00
2,997,378.00
415,600.00
153,000.00
800.00
2,857,337.00
3,019,530.00
300,000.00
46,555.00
199,000.00
785,887.00
487,300.00
30,000.00
170,000.00
2,997,378 00
415,600.00
153,000.00
800.00
2,857,337 00
3,019,530.00
300,000.00
40,400.00
194 ,000.00
785,887.00
437,300.00
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
-13.22% Llefav. Reimbursement General ($3,095) due to fewer
participants in Natural Sciences programs and
Reimbursement Postage ($3,060) due lc Michigan State
University no longer reimbursing MiSU Extension for
postage. A budget amendment is recommended to
recognize favorable expenditures and offset unfavorable
revenues.
-2.51% Unfav. Service Fees ($5,000) due to loss of toxicology
contracts with Saginaw and Lapeer Counties. A budget
amendment is recommended.
Total County Executive
Non-Departmental
Non-Dept - Charges for Services
I otal Nan-Departmental
Total Charges for Services
$ 11,447,150.00 $ 11,662,387.00 $ 11.401,232.00 $ (261,155.00)
5 750,000.00 5 750,000.00 640,000 00 (110,000 00)
$ 750,000.00 5 750,000.00 $ 640,000.00 5 1110,000.05j
$ 84,149,468.00 $ 83,071,314.00 5 81,918,915.00 $ 0,152,399.001 -1.39%
" Reveitue variance is partially offset by an expenditure variance.
INDIRECT COST RECOVERY (840100)
INVESTMENT INCOME (655000-855999)
District Courts (Div. I - IV)
Sheriff Corrective Services
Dario+Register of Deeds
Non-Departmental
Total investment Income
OTHER REVENUES 167000049550M
Circuit Court
District Court
Probate Court
Prosecuting Attorney
Adopted
Budget
8,511,499.00 $
20,500.00 S
53,800.00
2,687,500.00
2,761,800.00 $
142,600.00 $
Amended
Budoet
8.517,499.00 $
20,500 00 $
53,500.00
2,587,500.00
2,761,800.00 $
142,600.00 $
Sheriff Office
Sheriff - Patrol Services
Sheriff - Investigative/Forensic Svc
Clerki Register of Deeds
Treasurer
Library Board
Water Resources Commissioner
County Executive - ERP Equipment
Management and Budget
Central Services - Support Services
Facilities Engineering
1-4.eatth Division
Children's Village
Public Services
Planning & Econ. Devel. Services - Transfers
Economic Development - Donations
Non Departmental - Donations
Non-Dept - Sundry
Treasurers Transfers
105,000.00
6,500.00
21,326.00
1,000.00
4,300.00
417,500.00
4,500,000 00
105,000.00
8.500.00
21,326.00
1,000,00
4,300 00
417,500 00
4,500,000.00
Non-Departmental - 'Transfers In
Total Other Revenues
59,678,527.00
64,878,753.00
59,678,527.00
64,878,753,00
105,000.00
8,500.00
53,376.00
1,661 00
1,000.00
34.00
ty,
21.00
417,500 00
4,700,000 00
59,678,527 00
150,000 00 $
150,000.00 5
234.5;13.15
3,085,098.00 $
3,319,776.15 $
0 00%
0.00%
TOTAL GEN. FUND / GEN. PURPOSE REVENU $ 409,835,938.00 $ 411,8011354.15 $ 411.323,571.15 $ [276 783 00) -0.07% 411.800.354.15 $
COUNTY OF OAKLAND
GENERAL FUND /GENERAL PURPOSE REVENUES
FY 2010 FIRST QUARTER REPORT
Amount
FY 2010 Favorable
FORECAST (unfavorable Percent Explanation of Sianificant Variances
9,317,499.00 $ 800,000.00 9.39% Arlocation based on latest Indirect Cost study.
200,000.00
64,969,869.00 $ 91,116 00
9,000 00 $ 111,500 00)
53,800.00
2,637,500.00
2,750,300.00 $
-56,10% The economic downturn and poor investment market has
reduced the Court investment income.
0.00%
13.00%
0.00%
-0.42% (11,500.00)
0.00%
0.00%
0.00%
$ (142,600.00) -100.00% Unfav. Forfeiture Funds for NET postion. The Prosecutors
Office has found replacement funds in excess Budget
Transition to offset revenue. Prosecutor plans to present
tong-tem structural reductions at a later date.
0.00%
0.00%
32,000.00 150.05% Fav. variance is due to the receipt of Refund Prior Years
Expenditures.
1661.00 109.cr% Fav. due to cash overages.
34.00 11.E%
. %
. %
4,300.00
. %
. %
21.00 10 . %
Ok
0.Cri%
4 44% ray variance is due to the Collection Fees collected rn the
DTRF Please onte these, fees ore kept in reser.,e for three
years before being transferred to the General Fund.
0 00%
0.14%
PLANNED USE OF FUND BALANCE (685000-865999)
Encum and Approp Carry Forward
General Fund - Prior Years Balance
Total Planned Use of Fund Balance
234,578.15
3,055,098.00
3,319,776.15 $
‘64 * Revenue variance is partially offset by an expenditure variance
$ 8,275,469.00 $ 8,275,469.00 $ 8,180,469.00 $ 95,000.00
99,975.00
277,887.00
349,018.00
291,363.00
349,018.00
272,363.00 19,000.00
50,000.00 50,000.00 50,000.00
$ 8,703,331 X10 $ 8,965,850.00 $ 8,851,850.00 $ 114,000.00
$ 1,674,348.00
96,264.00
236,456.00
$ 1,674,348.00
96,264.00
237,683.00
$ 1,674,348.00 $
96,264.00
214,683.00 23,000.00
$ 2,249,539.00 $ 2,249,539.00 $ 2,134,539.00 $ 115,000.00
5,256,627.00 5,258,627.00 5,128,627.00 130,000.00
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
CIRCUIT COURT
ADOPTED
BUDGET
AMENDED
BUDGET
•n•••n••••.01041nn••nn•• .......••n•••••••••••••n
FY 2010
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 2,007,068.00 $ 2,008,295.00 $ 1,985,295.00 $ 23,000.00
Judicial Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfer Out
Business Division
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Civil / Criminal Division
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
1.15% - Fay. variance is due to county wide hiring freeze, under filled
positions and vacancies.
0.00% -
6.52% - Fay. variance is based on current IT equipment rentals and monthly
operations.
0.00%
1.27%
0.00% -
0.00% -
9.68% - Fay. variance is based on current $T equipment rentals and monthly
operations.
1.15%
5.11% - Feu. variance is due to county wide hiring freeze, under filled
positions and vacancies.
2.47% - Fay. variance is due to less activity In Defense Attorney fee
payments of $130.000. These payments are dependent on
caseload, and the Circuit Court fee structure. During the 2010
budget process the court made a number of changes to the defense
attorney fee structure to reduce costs.
2.19% - Fav. variance is based on current IT equipment rentals and monthly
operations.
2,444,894.00 2,516,852.00 2,461,852.00 55,000 00
$ 9,951,060.00 $ 10,025,018.00 $ 9,725,018,00 $ 300,000.00 2.99%
3/10010
55,000.00 324% 1,641,716.00
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
CIRCUIT COURT
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2010
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES -
.... p.n....dm, ..... mom,.
Family Divisionkluvenile Maint.
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfer Out
$ 11,238,140.00 $ 11,283,070.00 $ 10,844,070.00 $ 439,000.00
13,822,776.00 13,780,958.00 12,780,958.00 1.000,000.00
1,695,194.00 1,696,716.00
4,360,124.00 4,360,124.00 4.360,124.00
3.89% Fay. variance is due to county wide hiring freeze, under fined -
positions and vacancies.
7.26% - Fay. variance due to the court continuing to experience a shift from
placements in State Institutions i,Fav. 1.3 million) to Private
Institutions (Unfav. $300,000). Private Institutions is child care
funded and is reimbursed from the state at 50%. The favorability
From the shift in State to Private Institutions is offset by a unfavorable
amount in personal mileage of ($80,000), During the 2010 budget
cycle the court submitted as part of its budget task a decrease in
personal mileage This decrease was contingent upon the court and
the bargaining unit agreeing on the reduction. The two parties have
been unsuccessful at reaching the agreement, and the Circuit Court
is working on additional reductions to replace their previous
submission.
- Pay. variance is based on current IT equipment rentals and monthly
operations.
0.00% -
$ 31,116,234.00 $ 31,120,868.00 $ 29,626,868.00 $
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
$ 23,437,496.00
19,275,642.00
4,654,431.00
4,410,124.00
$ 23,482,425 00
19,484,867.00
4,742,614 00
4.410.124.00
22,833,426.00
18,354,867.00
4,590,614.00
4,410,124.00
$ 50.189,031.00
1,494,000.00 4.80%
649,000.00 2.78%
1,130,000.00 5.80%
152,000.00 3.20%
0.00%
1,931,000.00 3.70% $ 51,777,693.00 $ 52,120,031.00
3/1/2010
District Court Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
Division 1 - Nevi
Personnel Expenditures
Operating Expenditures
Total Division 1 - Novi $ 5,304,440.00 $ 5,324,811.00 $ 5,280,811.00 $ 44,000.00 0.83%
Division 2 - Clarkston
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
Total Division 2 - Clarkston
Division 3 - Rochester Hills
Personnel Expenditures
Operating Expenditures
internaf Support Expenditures
226,209.00 210,321.00
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
DISTRICT COURT
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2010
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Internal Support Expenditures
$ 197,739.00 $ 197,739.00 $ 197,739.00
5,300.00 5,300.00 5,300.00
$ 203.039.00 $ 203,039.00 $ 203,039.00 $
$ 3,863,041.00 $ 3,863,041.00 $ 3,863,041,00
1,015,342.00 991,303.00
426,467 00 20,000.00
•nnnnnnnnn.* ..... ..... .......
0.00% -
0.00% -
0.00%
0.00%
0.00% -
2.36% - Fav. variance is due to Defense Attorney fee of $5,000,
Juror Fees and fvlilage of $6,500, and Postage of
$10,500.
4.48% Fay. variance is based on current equipment rentals
and monthly operations.
1,015,303.00 24,000.00
426,096.00 446,467.00
$ 1,698,239.00 $ 1,705,898.00 $ 1,681,898.00 $
600,450.00 632,187.00 579,387.00
206,209.00 20,000.00
72,511.00 33,415.00 33,415.00
$ 2,581,821.00 $ 2,597,709.00 $ 2,500,909.00 $ 96,800 00
$ 3,614,961.00 $ 3,614,961.00 $ 3,583,961.00 $ 31,000.00
349,743.00 349,743.00 329,743.00 20,000.00
806,546.00 821,306.00 801,306.00 20,000.00
$ 4,771,250.00 $ 4,786,010.00 $ 4,715,010.00 $ 71,000.00
1.41% - Fay. variance is due to urxlerfilled positions.
8.35% Fav. variance is largely due to a reduction in Defense
Attorney fee payments of $35,000. Caseload dropped
in 2009 and Defense Attorney fee payments are
contigent on caseload. In addition to the favorability in
Defense Attorney fee payments, favorable variances in
Juror fees of $4,800, Drug Testing of $4,000, travel and
conference of $7,000 and membership and dues of
$2,000 are forecasted.
8.84% - Fay. variance is based on euirent equipment rentals
and monthly operations.
0.00%
3 73%
0.66% - Fav. variance is due to county wide hiring freeze, under
filled positions and vacancies.
5.72% - Fav. variarroe is due id Juror Fees and Mileage of
$12,000 and Professional Services of $8,000
2.44% - Fay. variance is based on current equipment rentals
and monthly operations.
1.48%
24,000.00
52,800.00
to, Division 4 - Tray
3.2/2010
528,388.00 532,124.00 507,124.00
329,277.00 340,741.00 320.741.00
$ 3,161,302.00 $ 3,176,502 00 $ 3,107,502.00 $
$ 11,606,276.00 $
2,412,857.00
1,754,723.00
33,415.00
$ 15,807,271.00 $
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
DISTRICT COURT
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2010
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 2,303,637.00 S 2,303,637.00 $ 2,279,637.00 $
$ 11,677,617.00 $ 11,685,276.00
2,499,184.00 2,534,657.00
1,772,240.00 1,834,723.00
72,811.00 33,415.00
$ 16,021,852.00 $ 16,088,071.00
24,000.00 1.04%
25,000.00 4.70%
20,000.00 5.87%
69,000.00 2.17%
79,000.00 0.68%
121,800.00 4,81%
80,000.00 4.36%
280,800.00 1.75%
Fav. variance is due to county wide hiring freeze, under
filled positions and vacancies
Fav. variance is due to Postage of $5,000, Charge Card
Fee of $10,000, Defense Attorney Fee oi $5,000,
Workshops and Meetings of $1,500, Library
Continuations of $2,000 and Membership Dues oi
$1,500.
Fay. variance is based on current equipment rentals
arid monthly operations.
312/2010
Judicial/Administration
Personnel Expenditures
Operating Expenditures
Internal Support
Transfer Out
$ 2,163,022.00 $ 2,163,022.00 $ 2,363,022.00 $ (200,000.00) -9.25%
43,981.00 43,981.00 35,581.00 8,400.00 19.10%
$ 2,183,282,00 $ 2,183,282.00 $ 2,113,282.00 $ 70,000.00
Estates/Mental Health
Personnel Expenditures 3.21% Fay, variance is due to a vacant Deputy Register
position The court does not plan to fill this
position in 2010.
Operating Expenditures
Internal Support
B35,291.00
1,092,646.00
669,524.00
1,110,204.00
669,524 00
820,204.00
0.00%
290,000.00 26.12%
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
PROBATE COURT
ADOPTED
BUDGET
$ 2,207,003.00
AMENDED
BUDGET
$ 2,207,003,00
AMOUNT
FY 2010 FAVORABLE
FORECAST IUNFAVORABLE) PERCENT
$ 2,398,603.00 $ (191,600.00) -8.68%
EXPLANATION OF SIGNIFICANT VARIANCES
Unfav. variance due to Judges retirement
expense inadvertantly omitted from the budget. A
budget amendment is recommended.
Fav. variance due to the court's effort to minimize
costs in areas such as Library Continuations
$5,900, and Travel $2,500.
Fav. variance is due to a budgeting error. The IT
operations line item was budgeted twice, once in
IT Imaging Operations and once in IT Operations
A budget amendment is recommended.
$ 3,603,010 00 $ 360,000.00 9.08%
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support
Transfer Out
$ 3,911,219.00
$ 4,346,304.00
679272.00
1,092,645.00
$ 6,118,222.00
$ 3,963,010.00
$ 4,3,16,304.00
713,505 00
1,110,204.00
$ 6,170,013.00
$4,476,304.00 $
705,105.00
820,204.00
(130,000.00)
8,400 00
290,000 00
-2.99%
1.18%
26.12%
$ 6,001,613.00 $ 168,400.00 2.73%
3/2t2010
EXPLANATION OF SIGNIFICANT VARIANCES
Mr.
Operating Expenditures
Internal Suppori Expenditures
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
PROSECUTING ATTORNEY
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
WI•n••••••••n••n•n•••nn•••••n•
Administration
Personnel Expenditures $ 2,496,683.00 $ 2,495,683.00 $ 2,920,383.00 $ (423,700.00) -16.97% Divisions are reflecting fay (unfav) variances primarily due
to personnel changes within the Prosecutor's Office under
the new administration. Plans for a formal reorganiration
will be presented at a later date.
Operating Expenditures 809,872.00 837,643.40 837,643.40 - 0.00%
Internal Support Expenditures 1,884,639.00 1,893,706.00 1,893,706.00 - 000%
Transfers (10,598.00) (10,598.00) (10,598.00)- 0.00%
$ 5,180,596.00 $ 5,217,434.40 $ 5,641,134.40 $ (423,700.00) -8.12%
Litigation
Personnel Expenditures $ 9,105,082.00 $ 9,105,082.00 $ 8,416,882.00 $ 688,200.00 7.56% Divisions are reflecting fav / (unfav) variances primarily due
to personnel changes within the Prosecutor's Office under
the new administration. Plans for a formal reorganization
will be presented al. a later date.
Operating Expenditures 64,744.00 64,744.00 64,744.00 - 0.00%
Internal Support Expenditures 2,536.00 2,536.00 2,536.00 - 0.00%
Transfers Out 855,589.00 855,589.00 855,589.00 - 0.00%
$ 10,027,951.00 $ 10,027,951.00 $ 9.339,751 .00 $ 688,200.00 6.86%
Warrants
Personnel Expenditures $ 2,079,224.00 $ 2,079,224.00 $ 2,002,524.00 $ 76,700.00 3.69% Divisions are reflecting fay I (unfav) variances primartly due
lo personnel changes within the Prosecutor's Of-lice under
the new administration. Plans for a formal reorganization
will be presented at a later date.
3,199.00 3,199.00 3,199.00 - 0.00%
_ _ _ 0.00%
$ 2,082,423.00 $ 2,082,423.00 $ 2,005,723.00 $ 76,700 00 3.68%
2/1912010
ADOP1ED
BUDGET
AMENDED
BUDGET
8,458.00 8,458.00 8,458.00 - U.00%
000%
$ 1,647,345.00 $ 1,647,345.00 $ 1,477,045.00 $ 170,300.00 10.34%
COUN1 Y OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
PROSECUTING ATTORNEY
AMOUNT
FY 2010 FAVORABLE
FORECAST (UNFAVORABLE' PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Appellate
Personnel Expenditures S 1,638,1387.00 $ 1,638,887.00 $ 1,468,587.00 $ 1/0,300.00 10.39% Divisions are reflecting fay I (unfavli variances primarily due
to personnel charges within the Prosecutors Office under
the new adminfstration. Plans for a formal reorgani.zation
will be presented at a later date
Operating Expenditures
Internet Support Expenditures
De partment
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
1 ransters Out
$ 15,319,876.00
886,273.00
1,887,175.00
844 1991.00
$ 15,319,876.00 $ 14,808,376.00
914,044.40 914,044.40
1,896,242.00 1,896,242.00
844,991.00 844,991.00
511,600.00 3.34%
0.00%
0.00%
0..00%
2.70% $ 16,938,315.00 $ 18,975,153.40 $ 18,463,653.40 $ 511,500.00
0.50 2/19/2010
EXPLANATION OF SIGNIFICANT VARIANCES
• .•
Internal Support Expenditures 7,696,803.00 7,842,088.00 7,361,588.00 480,500.00
Corrective Services-Satellites
Personnel Fxpenditures $ 13.692,832.00 $ 13,692,832.00 $ 14,679,632.00 $
COUNTY OF OAKLAND
FY 2010 FORECAST REPORT
EXPENDITURES
SHERIFF'S OFFICE
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
SherifFs Office
Personnel Expenditures $ 1,607,015 00 $ 1,607,015.00 $ 1,638,715.00 $ (31,700.00) -1.97% Uniav. salaries, fringe benefits, and overtime; a budget amendment
will be submitted and corrections to the salary budget are
anticipated.
Operating Expenditures 125,236.00 126,236.00 126,236.00 - 0.00%
Internal Support Expenditures 257,017,00 256,472.00 256,472.00 - 0.00%
Transfers - - - 0.00%
$ 1,990,268.00 $ 1,989,723.00 $ 2,021,423.00 $ (31,700.00) -1,59%
Administrative Services
Personnel. Expenditures $ 1,920,418.00 $ 1,921,592.00 $ 2,057,292.00 (135,700.00) -7,08% Unfav. salaries, fringe benefits, and overtime; a budget amendment
will be submitted and cocrecbons to the salary budget are
anticipated.
Operating Expenditures 944,843.00 996,303.19 995,303.19 - 0.00%
Internal Support Expenditures 332,695.00 332,695.00 332,695.00 0.00%
Transfers - 0.00%
$ 3,197,956.00 $ 3,250,590.19 5 3,386,290.19 $ (135,70000) -4.17%
Corrective Services
Personnel Expenditures 32,635,993,00 $ 32,635,993.00 $ 33,123,493.00 (487,500.00) -1.49% Unfav. salaries, fringe benefits, and overtime, a budget amendment
will be submitted and corrections to the salary budget are
anticipated as a result of the arbitration ruling.
Operating Expenditures 7,228,273 00 7,241,406.35 7,241,406.35 0.00%
6.13% Fav. Info Tech Oper. $452,500 due to rate and usage reduction:
fav. Motor Pool Fuel Charges of $28,000 reflects per galloit fuel
reduction and departmental efforts to reduce the number of miles
driven.
Transfers
$ 47,560,1369.00 $ 47,719,487.35 $ 47,726,487 35 $
0,00%
(7,000.00) -0.01%
(985,800.00) -7.21% Unfav. salaries, fringe benefits, and overtime: a budget amendment
will be submitted and corrections to the salary budget are
anticipated as a result of the arbitration ruling.
4,63 Operating Expenditures 234,500.00 234,500.00 234,500.00 0.00%
2/22/2010
Operating Expenditures 425,154.00 478,739.24 478,739.24 0.00%
Internal Support Expenditures 4,852,847.00 4,804,129.00 4,392,329.00 411,800.00
I ransters
Investigative/Forensic Svcs
Personnel Expenditures
COUNTY OF OAKLAND
FY 2010 FORECAST REPORT
EXPENDITURES
SHERIFF'S OFFICE
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
.••••••••••n•••mmoamm arm.,
EXPLANATION OF SIGNIFICANT VARIANCES
Internal Support Expenditures 1,074,166.00 1,074,732.00 1,074)32.00 0.00%
Transfers - - - - 0.00%
$ 15,001.498.00 $ 15,002,064.00 $ 15,988,864.00 $ (985..800.00) -5.53%
Emergency Prep., TrnIng & Comm.
Personnel Expenditures $ 4,858,847.00 $ 4,86/1,141.00 $ 5,046,241.00 $ (182,100.00) -3.74% Unfav. salaries, fringe benefits, and overtime; a budget amendment
will be submitted and corrections to the salary forecast are
anticipated.
Operating Expenditures 191,640.00 195,726.00 195,726.00 - 0.00%
eternal Support Expenditures 230,385.00 230,385.03 230,385.00 - 0.00%
Transfers - - - , 0.00%
$ 5,290,881.00 5 5,290,252.00 $ 5,472,352.00 5 (182,100.00) -3.44%
Patrol Services
Personnel Expenditures $33,649,338 $ 32,430,644.00 $ 35,688.144.00 $ (3,257,500.00) -10.04% Untev. salaries, fringe benefits, and overtime; a budget amendment
will be submitted and corrections to the salary budget are
anticipated as a result of the arbitration ruling.
8.57% Fay. Lease Vehicles al $182,500 due to rate and usage reduction
and accelerated vehicle deletions; fay. Motor Pool Fuel Charges cf
$229,300 reflects per gallon lite! reditetion, vehicle deletions, and
departmental efforts to reduce the number of miles driven.
0.00%
5 38,927,13900 $ 37,713,51224 $ 40,559,212.24 $ (2,845,700.00) -7.55%
$ 7,392,182.00 $ 7,392,132.00 $ 7,726,692.03 $ (334,500.00) -4.53% Unfav. salaries, fringe benefits, and overtime; a budget a mendment
will be submitted and corrections to the salary budget are
anticipated as a result at the arbitration ruling.
Operating Expenditures 1,065,821.00 1,285,472.09 1,285,472.09 0.00%
Internal Support Expenditures 2,271,687.00 2,273,715.00 2,109,915.00 103,800.00 7.20% Fay. Radio Communications ol $193,800 due to reduction in
number of patrol car radios and reduced usage rate.
Transfers 334,086.00 334,088.00 0.00%
$ 10.729,690.00 $ 11,285,455.09 $ 11.458,155.09 S 1170,700.00) -1.51%
'Department Total 2/22/2010
COUNTY OF OAKLAND
FY 2010 FORECAST REPORT
EXPENDITURES
SHERIFF'S OFFICE
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfer Out
ADOPTED
BUDGET
S 95,766,625 00
10,216,476.00
16,715,200.00
AMENDED
BUDGET
$ 94,544,399.00
10,558,382.87
16,814,216.00
334,086.00
FY 2010
FORECAST
$ 95,960,199.00
10,558,382.87
15,758,116.00
334,086.00
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT
$ (5,415,800.00) -5.73%
0.00%
6.29%
0.00%
1,056,100.00
EXPLANATION OF SIGNIFICANT VARIANCES
$ 122,698,301.00 122,251,083.87 $ 126,610,783.87 $ (4,359,700 00) -3.57%
2/22/2010
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
CLERKIREGISTER OF DEEDS
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures $ 728,330.00 $ 728,330.00 $ 728,330.00 $ 0.00%
Operating Expenditures 40,382.00 40,382.00 40,382.00 0.00%
Internal Support Expenditures 189,029.00 214,069.00 205,569.00 8,500.00 3.97% Fav Motor Pool $8,000 and Motor Pool Fuel Charges $2,500
due to decreased activity.
- Transfers 0.00%
$ 957,741.00 $ 982,781.00 $ 974,281.00 $ 8,500.00 0.86%
County Clerk IVital Stats & Legal Rees)
Personnel Expenditures $ 3,296.093.00 $ 3,296,093.00 $ 3,231,093 00 $ 65,000.00
Operating Expenditures 297,408.00 308,332.50 282,332.50 26,000.00
1.97% Fax'. due to underfilled and vacant positions
8.43% Fay. Professional Servic.es $20,000 and Travel & Conference
$2,000 due to effort to reduce usage and costs. Also lay. In
Court Transcripts 120,000 due to lower than anticipated activity,
partially ofIset by untav. Office Supplies ($16,000) due to a
higher than anticipated use.
Internal Support Expenditures
Transfers
656,625.00 699,696.00 599,596.00 100.000.00 14.29% Fay, Info Tech Imaging Operations $100,000 clue to decreased
activily,
0.00%
$ 4,250,126 00 $ 4,304,121.50 $ 4,113,121.50 $ 191,000.00 4.44%
2/22/2010
0.00%
0.00%
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
OLERK/REGFSTER OF DEEDS
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Elections
Personnel Expenditures $ 685,056.00 $ 685,056.00 $ 685.055 00 $
Operating Expenditures 772,475.00 772,475.00 772,475.00
Internal Support Expenditures 131,340.00 131,718.00 131,718.00
Transfers
$ 1,588,871.00 5 1,589,249.00 S 1,589,249.00 $
0.00%
0.00%
0.00%
Register of Deeds (and Micrographics)
Personnel Expenditures $ 2.847,747.00 $ 2,847,747.00 $ 2,847,747.00 $ 0.00%
Operating Expenditures 1,134,824.00 1,134,824.00 $ 566,824.00 568,000.00 50.05% Fair. Professional Services $500,000 due to a decrease in the
number of mortgage and title documents processed by an
outside vendor (ACS) and reflective of the slowdown in the
housing industry, Material & Supplies $38,000, Maintenance
Contract $30,000 due to lower than anticipated use.
Internal Support Expenditures 589,706.00 610,877.00 $ 610,877.00 0.00%
Transfers 0.00%
$ 4,512,277.00 $ 4,593,448.00 $ 4,025,448.00 $ 568,000.00 12.37%
Jury Commission
Personnel Expenditures $ 28,831.00 $ 28,831.00 $ 28,831.00 $
Operating Expenditures 6,161.00 6,161.00 6,161.00
Internal Support Expenditures 104,244.00 106,331.00 101,331 00
0.00%
0.00%
5,000.00 4.70% Ea./. Into loch Operations $5,000 Cue to decreased activity.
$ 139,236 00 $ 141,323.00 $ 136,323.00 $ 5,000.00 3.54%
ssk 2/7.2+2010
COUNTY OF OAKLAND
FY 2018 FIRST QUARTER REPORT
EXPENDITURES
CLERK/REGISTER. OF DEEDS
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Department Total
Personnel Expenditures $ 7,586,057.00 $ 7,586,057.00 $ 7,521,057.00 $ 55000.00 066%
Operaling Expenditures 2,251,250.00 2,262,174.50 1,6613,174.50 594,000.00 26.26%
Internal Support Expenditures 1,670,944.00 1,762,691.00 1,649,191.00 113,500.00 6.44%
Transfers - - - 0.00%
$11,508,251.00 $ 11,610,922.50 $ 10,838,422.50 $ 772,500.00 6.65%
• Note revenue offset.
, '771
7127)2010
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
COUNTY TREASURER
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures $ 2,654,440.00 $ 2,654,440.00 $ 2,699,440.00 (45,000.00) -1.10% - Unfav, variance due to personnel changes since preparation of
the budget.
Operating Expenditures 189,920.00 194,24404 191,244.04 3,000.00 1.54% - Fay. due to Twp and City Bonds favorability of $3.000. A budget
amendment is recommended to use this favorability to offset the
Treasurers budget transition expenses.
Internal Support Expenditures 659,415.00 824,570.00 756,570.00 58,000.00 7,03% - Fay. variance is based on current IT equipment rentals and
monthly operations.
Division Total $ 3,503,775.00 $ 3,673,254.04 $ 3,057,254.04 $ 16,000.00 0.44%
Department Total $ 3,503,775.00 $ 3,673,254.04 $ 3,657,254.04 $ 16,000.00 0.44%
3/212010
Administration
Personnel Expenditures
Operating Expenditures
$ 2,255,237.00 $ 2,255,237.00 $ 2,258,737.00 $
402,151.00 402,181.00 364,181.00
(3,500.00)
14,000.00
260,526.00 260,568.00
$ 2,917,944.00 $ 2,917,985.00
260,568.00 0.00% -
$ 2,883,486.00 $ 10,500.00 0.36%
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
BOARD OF COMMISSIONERS
ADOPTED AMENDED
BUDGET BUDGET
AMOUNT
FY 2010 FAVORABLE
FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
-0.16% - !inlay Overtime ($3,500) due to night meetings.
348% - Fay_ Travel & Conference $8,000, Workshops and Meetings $5,000 and
Legal Services $5,000 due to elicit to reduce usage and costs; partially
offset by unfav. Prof Sera - Annual Audit ($4,000) due to an increase in the
contract.
Internal Support Expenditures
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 2,255,237_00
402,181 00
260,526.00
$ 2,255,237.00
402,181.00
260,568.00
$ 2,258,737.00
364.151 00
260,568 00
$ (3,500.00) -0.16%
14,000.00 3.48%
0.00%
$ 2,917,944.00 $ 2,917,986.00 $ 2,883,486.00 $ 10,500.00 0.36%
c-et. 3,'2/2010
Library Board
Personnel Ex penditures
Operating Expenditures
Internal Support Expenditures
Transfers
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures.
Transfers
0.000/0
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
LIBRARY BOARD
ADOPTED AMENDED
BUDGET BUDGET
AMOUNT
FY 2010 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ i9415700 $ 794,157.00 $ 794,154 00 $
251,099.00 251,099.00 251,099.00
887,505.00 888.326 00 888,326.00
5 4,932,861.00 5 1,933,582.00 $ 1.933,582.00 $
$ 794,157,00 $ 794,157.00 $ 794,157.00 $
251,099.00 251,099.00 251,099.00
887,605 00 888,326.00 858,326 00
$ 1,932,861.00 $ 1.933,582.00 $ 1,933,582.00 $
. _ .
3)212010
Operating Expenditures
Internal Support Expenditures
0.00% 56,165.00 56,165.00 56,165.00 Transfers
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
WATER RESOURCES COMMISSIONER
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Water Resource Commissioner
Personnel Expenditures $ 3,677,188 00 $ 3,679,471.00 $ 4,235,654.00 $ (556,183.00) -1S.12% Untav - Salaries and Fringes ($556,183) due to CAMS project
planning/requirements phase; original estimate included development/testing
phase hours now expected in FY 2010, Note. See revenue offset.
457,412.00 457,412.00 457,412.00 000%
1,121,581.00 1,191,932.00 1,318,117.00 (126,185.00) -10.59% Unfav - Drain Equipment ($126,183) due to CAMS project planning/requirernents
phase; original estimate included developmenthesting phase hours now expected
in EY 2010.
Total $ 5,312,346.00 $ 5,384,980.00 $ 6,067,348.00 $ (682,368.00) -12.67%
Department Total $ 5,312,346.00 $ 5,384,980.00 $ 6,067,348.00 $ (682,368,00) -12.67%
c• 2/2212010
EXPLANATION OF SIGNIFICANT VARIANCES
95,000.00 1.94%
0.00%
0.00%
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
COUNTY EXECUTIVE
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
Administration
Controllable Personnel $ 1,994,474.00 $ 1,994,474.00 $ 1,994,474 00 3.00% -
Controllable Operating 224,173.00 224,173.00 224,173.00 0.03% -
Internal Support Expend ilures 602,689.00 603,459.00 603,469.00 0.00% -
Transfer Out -
$ 2,821,336.00 $ 2,822,116.00 $ 2,822,116.0G $ 0.00%
Auditing
Controllable Personnel $ 975,547.00 $ 915,541.00 $ 880,547.00 $ 95,000.00 9.74% - Turnover
Controllable Operating 27,657.00 27,657.00 27,657.00 0.00% -
Internal Support Expenditures 106,930.00 106,930.00 106,930.00 0.00% -
Transfer Out -
$ 1,110,134.00 $ 1,110,134.00 $ 1,015,134.00 $ 95,000.00 8.56%
Corporation Counsel
Controllable, Personnel $ 1,930,3/2.00 $ 1,930,372.00 $ 1,930,372.00 0.00% .
Controllable Operating 57.273.00 57,273.00 57,273.00 0.00% -
Internal Support Expenditures 221,349.00 221,834.00 221,834.00 0.00% -
Transfer Out -
$ 2,208,964.00 $ 2,209,479.00 $ 2,209,470.00 $ 0.00%
Department Total
Controllable Personnel
Controllable Operating
Internal Support Expendilures
Transfers Out
$ 4,900,393.00 $ 4,900,393.00 $ 4,805,393.00 $
309,103.00 309,103.00 309,103.00
930,968.00 932,233.00 932,233.00
$ 6,140,464 00 $ 6,141,729.00 $ 6,046,729.00 S 95,000.00 1.55%
2/1912010
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
MANAGEMENT AND BUDGET
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Admirpistration
Personnel Expenditures
Operating Expenditures
Internal Supporl Expenditures
$ 204,186 00 $ 204,186.00 $ 207,186.00 $ 13,000.30) -1.47% (...Infav.) Fringes for retirement calc.
5,580.00 5,580.00 5,580.00 0.00%
17,200.00 17,200.00 17,200,00 0.00%
$ 226,956.00 $ 226,966.00 $ 229,966.00 $ (3,000.00) -1.32%
Purchasing
Personnel Expenditures $ 1,050,154.00 $ 1,050,154.00 $ 950,154 .00 $ 100,000.00 9.52% Favorable Salaries and Fringes due to underfilling of positions.
Operating Expenditures 35,081.00 38,183.00 38,183.00 0.00%
Internal Support Expenditures 199,061.00 199,061.00 199,061.00 0.00%
Transfers - - -
S 1,284,295.00 $ 1,287,398.00 $ 1,187,398.00 $ 100,000.00 7.77%
Equalization
Personnel Expenditures $ 7,495,811.00 $ 7,495,811.00 $ 7,157,811.00 $ 338,000.00 4.51% Fay. Due to turnover,
Operating Expenditures 237.591.00 273,011.00 273,011.00 0.00%
Internal Support Expenditures 1,127,615.00 1,309,454.00 1,309,454.00 0.00%
Transfers - 0.00%
58,861,017.00 $9,078,276.00 $ 8,740,276 00 $ 338,000.00 3.72%
Fiscal Services
Personnel Expenditures $ 7,395,583.00 $ 7,396,583.00 $ 7,196,583.00 $ 200,000 00 2.70% Favorable due to the unclerfilling of positions.
Operating Expenditures 230,324.00 230,324.00 230,324.00 0.00%
Internal Support Expenditures 1,612,816.00 1,768,509.00 1,768,509.00 0.00%
Transfers - .. - 0.00%
$ 9,239,723.00 $ 9,395,415.00 $ 9,195,416.00 $ 200,000.00 2.13%
3/2/2010
COUNTY OF OAKLAND
FY 2011) FIRST QUARTER REPORT
EXPENDITURES
MANAGEMENT AND BUDGET
'
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST tUNFAVORABLE) PERCENT
Department Total
Personnel Expenditures $ 16,146,734.00 $ 15,146,734.00 $ 15,511,734.00 $ 635,000.00 3.93%
Operating Expenditures 508,576.00 547,098.00 547,098.00 0.00%
Internal Support Expenditures 2,956,692.00 3,294,224.00 3,294,224-00 - 0.00%
Transfers - _ - - 0.00%
$ 19,612,002.00 $ 19,988,056.00 $ 19,353,050_00 $ 635,000.00 3.18%
EXPLANATION OF SIGNIFICANT VARIANCES
-.C. v.)
3/2/2010
5,000.00 0.24%
5,000.00
0.00%
0.00%
0.62%
0.00%
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
CENTRAL SERVICES
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administrative
Personnel Expenditures $ 200,232.00 $ 200,232.00 $ 200,232.00 0.00%
Operating Expenditures 2,616.00 2,616.00 2,616.00 0.00%
Internal Support Expenditures 14,595 00 14,595.00 14.595 00 0.00%
Transfers - -
5 217,443.00 $ 217,443.00 5 217,443,00 $ 0.00%
Support Services
Personnel Expenditures $ 1,028,558.00 $ 1,028558.00 $ 1,028,558.00 0.00%
Operating Expenditures 53,828.00 53,828.00 53,828.00 0.00%
Internal Support Expenditures 772,356.00 791.348.00 786,348.00 5,000.00 0.63% Favorable IT Operations.
Transfers - - 0.00%
$ 1,854,742.00 5 1,873,734.00 5 1,868.734.00 $ 5,000.00 0.27%
Department Total
Personnel Expenditures $ 1228.790.00 $ 1,228,790.00 $ 1,228,790.00 $
Operating Expenditures 56,444.00 56,444.00 56,444.00
Internal Support Expenditures 786,951.00 805,943.00 800,943.00
Transfers
$ 2,072,185.00 $ 2,091,177,00 $ 2,086,177.00 $
2/22t2010
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
FACILITIES MANAGEMENT
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERC:ENT
Administration
Personnel Expenditures $ 217,309.00 $ 217,309.00 $ 217,309.00 - 0.00% -
Operating Expenditures 4,596.00 4,596,00 4,596.00 - 0.00% -
Internal Support Expenditures 31,732.00 31,732.00 31,132.00 - 0.00% -
- - Transfers Out , -
$ 253,637.00 $ 253,637.00 $ 753,637.00 $ 0.00%
EXPLANATION OF SIGNrEICANT VARIANCES
Facilities Engineertng
Personnel Expendrtures
Operating Expenditures
Internal Support Expenditures
$ 681,268.00 $ 881.268.00 $ 848,568.00 $ 32,700.00 3.71% - Fay. due to staff time c,harged to Oakland County International Airport and
Parks & Recreation projects for engineering services.
65,888.00 85,888.00 85,888.00 - 0,00% -
68,447.00 68,454.00 68,454.00 - 0.00% -
$ 1,035.603.00 $ 1,035.610.00 $ 1.002,910.00 $ 32,700.00 3.16%
Department Total
Personnel Expenditures $ 1,098,577.00 $ 1,098,577.00 $ 1,065,877.00 $ 32,700.00 2.98%
Operating Fxpendiiures 90,484.00 90,484.00 00,484.00 0.00%
Internal Support Expenditures 100,179,00 100,186.00 100,180.00 0.00%
Transfers Out - . - i
$1,289,240.00 $ 1,28924700 $ 1,756,547.00 $ 32,700.00 2.54%
te % 2/1612010
Administration
Personnel Expenditures
Operating Expenditures
$ 729,2/8.00 $ 729,218.00 $ 705,718.00 $
301,506.00 301,506.00 281,606,00 $
Workforce Management
Personnel Expenditures
Operating. Expenditures
$ 1,085.935.00 $ 1,089,626.00 51,046,226.00 $
$ 1,938,502.00 $ 1,938,502.00 $1,916,802.00 $
204,995_00 204,995.00 161,895.00 $
43,400.00
21,700.00
43,100.00
Internal Support Expenditures
1 ransfor Out
551,057.00
2,694,554.00 $ 2,741,883.00 $2,670,883.00 $ 71,000.00 2.59%
$ 159.663.00 $ 159,663.00 $ 159,663.00 $ 0.00%
16,552.00 16,552.00
-C
C.
Benefits Administration
Personnel Expenditures
Operating Expenditures 8,752.00 5 7,800.00 47.12%
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
HUMAN RESOURCES
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2010 FAVORABLE
FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
23,500.00 3.22% SavinQs underfillect PINE Deputy Director position.
19,900.00 6.60% Favorability primarily in Per Diems Fees $10,200 due to fewer meetings, Employee
Med Exams ADA $2,000 due to decline in requests for exams, reduction in the use
of Travel & Conference $5,500, Workshops and Meetings $600, and a reduction in
Membership, Dues and Periodical Books subscriptions $1,500.
55,211.00 0.00% Internal Support Expenditures
Transfer Out
58,902 00 58,902 00 $
3.98%
1.12% Due to underfille.d positions.
21.02% Savings anticipated in Recruitment Expense $52,300 due to hiring freeze. HR Dept
currently preparing RFP to purchase additional exams (estimated cost is $24,000)
and will utilize a portion of the Recruitment Expense savings to offset the cost for
these exams. Savings are also anticipated in Equipment Maintenance $1,000,
Membership Dues, and Periodical subscriptions $1,100, Personal Mileage $1,200,
Computer Supplies $2,000 and Expendable Equipment Expense $2,000 due to
cutbacks in usage and purchases. Travel & Conference lower due to decline in
PeopleSott training $7,500.
598,386.00 592,186.00 $ 6,200.00 1.04% Favorability anticipated for Convenience Copier $2,000, Pf hi Shop $2,800, and
Telephone Communications $1,400 due to decreased activity associated with
recruitment.
Savings anticipated primarily in Office Supplies $4,500, Expendable Equipment
Expense $2,000, Personal Mileage $800, Software Support Maintenance 5400, and
Equipment Maintenance $100 due to efforts to reduced spending
3/212010
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
HUMAN RESOURCES
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST {UNFAVORABLE) PERCENT
Internal Support Expenditures 176,729.00 176,729.00 176,729.00 $ 0.00%
Transfer Out
$ 352,944.00 $ 352,944.00 5 345,144.00 S 7,800.00 2.21%
Department Total
Personnel Expenditures 5 2,827,383 00 $ 2,827,383.09 $2,782,183.00 $ 45,200.00 1.60%
Operating Expenditures 523,053.00 523,053.00 452,253,00 70,800.00 13.54%
Internal Support Expenditures 782,997 00 834,017.00 827,817.00 6,200.00 0.74%
Transfer Out
$4,133,433.00 $ 4,184,453.00 54,062,253.00 S 122,200.00 2.92%
EXPLANATION OF SIGNIFICANT VARIANCES
3.2.+2010
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
HEALTH AND HUMAN SERVICES
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDG ET FORECAST (UNFAVORABLE) PERCENT
Administration
Personnel Expenditures $ 199,917 00 S 199,917.00 $ 199,917.00 0.00% -
Operating Expenditures 11,345,367.00 12,345,367.00 12,345,367.0(1 0.00% -
Internal Support Expenditures 16,457.00 16,457.00 16,457.00 0.00% -
Transfers Out - -
$ 11,561,741.00 $ 12,561,741.00 $ 12,561,7'41.00 $ 0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
Health
Personnel Expenditures
Operating Expenditures
$ 23.752.490.00 $ 23,059,751 00 $ 22,234,751.00 $ 825,000.00 3.58% - Favorable Turnover and underfilled positions
95,500.00 1.61% - Favorable Mileage $30,000, Travel and Conlerence $5,000, FA Prop.
Equipment Exp. $20,000, Laboratory Supplies $40,000 and Uniforms
$500 all due to efforts to contain costs, minimize expenses. Further,
reductions include addrtional actions to increase efficiency and reduce
costs.
4,778,762.00 5,921,743.40 5,826,243.40
Internal Support Expenditures
Transfers Out
3,580,376.00 3,817,98.00 3,817.998.00 0.00% -
Children's Village
Personnel Expenditures
$ 37,111.628.00 532,799.492.40 5 31,878,992.40 5 920,500.00 2.81%
$ 12,767,601.00 $ 12,767,601.00 $ 13,082,601.00 $ (315,000 00) -2.47% - lUniav) Overtime due lo state required resident-to-staff ratio including
the filling of scheduling needs (50% recoverable from State Child Care
Fund reimbursement).
Operating Expenditures $ 3,793,055.00 3,799,551.94 3,799.551.94 0.00% -
Internal Support Expenditures 2,634,817.00 2,653,512 00 7,653,512.00 0.00% -
T ransters Out 0.00 - -
$ 19,195,473.00 5 19,220,664.94 $ 19,535,664.94 $ (315,000.00) -1.64%
Homeland Security
Personnel Expenditures S 776,996.00 $ 726,996.00 S 726,996.00 0.00% -
Operating Expenditures 261,380.00 306,50'f0 306,609.50 0.00% - (Unlav) Electrical Service ($10,000), Advertising ($900) and Fees - Civil
Service (5240) due to rate increases, offset by favorable Mainrenanue
Contracts $10,240 and Fquipment Expense $900. A sell-balancing
budget amendment is recommended.
Internal Support Expenditures 496,002.00
Transfers Out
501.334.00 516,334.00 (15,000.00) 2.99% (Untav) Radio Communications due to pending rate adjustment.
3/212010
$ 3.397,913.00 $ 3,397,913.00 $ 3,412,913.00 $
705,498.00 716,498 50 716,498.50
485,829.00 517,185.00 497,185.00
$ 199,597.00 $ 199,597.00 $ 199,597.00 $ 0.00%
$ 1,763,899.00 $ 1,764,368.00 $ ,764,368.00 0.00%
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
PUBLIC SERVICES
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2010 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 188,043.00 $ 188,043.00 $ 188,043.00 $
4,800.00 4,800.00 4,800.00
6,754.00 6,754.00 6,754.00
1,366,623.00 $
217,090.00
180,655.00
Public Services - Admin.
Personne Expenditures
Operating Expenditures
Internal Support Expenditures
Veterans' Services
Personnel Expenditures
Operatihg Expenditures
Internal Support Expenditures
Transfers
Community Corrections
Personner Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
0.00% -
0.00% -
0.00% -
0.00% -
0.00% -
0.00% -
0.00%
-0.44% - Turnover
0.00% -
20,000.00 3.87% - Favorable Info Tech Operations $24,000 due to decreased
activity.
0.00% -
$ 1,366,623,00 $ 1,366,623.00
217,090.00 217,090.00
180,186.00 180,655.00
(15,000.00)
$ 4,589,240.00 $ 4,631,596.50 $ 4,626,596.50 $ 5,000.00 0.11%
MSU Ext. - Oakland County
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 759,536.00 $ 759,536.00 $ 759,536.00 $
88,897.00 88,897.00 85,897.00
302,840.00 299,340.01)
$ 1,149,895.00 $ 1,151,273.00 S 1,144,773.00 $
0.00% -
9,155.00 10.30% - Favorable 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. Also fay. In Workshops
and Meetings $6,155 due to effort to reduce usage and costs.
A budget amendment is recommended lo recognise favorable
expenditures in Workshops and Meetings and used to offset
unfavorable revenues.*
3,500.00 1.16% - Favorable Motor Pool $1,500 and Convenience Copier $2,000
duo to decreased activity.
1.2,655.00 1.10%
301,462.00
• See related revenue Oise!, 2s18/2010
$ 199,597.00 $ 199,597.00 $ 199,597.00 $ 0,00%
$ 1,763,899.00 $ 1,764,368.00 $ 1,764,368.00 $ 0.00%
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
PUBLIC SERVICES
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2010
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Public Services - Admin.
Personnel Expenditures
Operating Expenditures
Internet Support Expenditures
$ 188,04300 $
4,800.00
6,754.00
138.043.00 $ 188,043.00 $
4,800.00 4,800.00
6,754.00 6,754.00
0.00%
0,00% -
0.00% -
1,366.623.00 $
217,090.00
180,655.00
$ 3,397,913.00 $ 3,397,913.00 $ 3,412,913.00 $
705,498.00 716,498.50 716,498.50
435,879.00 517,185.00 497,185.00
Veterans' Services
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
Community Corrections
Personnel Expenditures
Operating Expenditures
Intennal Stripped Expenditures
Transfers
$ 1,365,623.00 $ 1,366,523 00
217,090.00 217,090.00
180,186.00 180,655.00
0.00% •
0.00% -
0.00% -
0.00%
(15,000.00) -0.44% - Turnover
0.00% -
20,000.00 3.67% - Favorable Into Tech Operations $20,000 due to decreased
activity.
0.00% -
$ 4,580,240.00 $ 4,631,596.50 $ 4,626,596.50 $ 5,000.00 0.11%
MSLI EVA, Oakland County
Personnel Expenditures
Operating Expenditures
$ 759,536.00 $ 759,536.00 $ 759,536.00 $
88,897.00 88,897.00 85,897.00
Internal Support Expenditures
0.00%
9,155.00 10.30% - Favorable Professional Services $3,000 due to the use of MSU
Extension educators from other counties that don't ellarge fees
for teaching Master Gardener classes. Also lay. In Workshops
and Meetings $6,155 due to effort to reduce usage and costs.
A budget amendment is recommended to recognize favorable
expenditures in Workshops and Meetings and used to offset
unfavorable revenues.'
Favorable Motor Pool $1,500 and Conveirienue Copier $2,000
due to decreased activity.
301,462.00 302,840.00 299,340.00 3,500.00 1.16% -
$ 1,149,895.00 $ 1,151,273.00 $ 1,144,773.00 $ 12,655.00 1.10%
• See related revenue offset. 2,18.42010
154,967.00
699,199.00
154,967.00
699,199.00
0.00% -
0.00% -
0.00%
0.00%
0.00%
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
PUBLIC SERVICES
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Medical Examiner
Personnel Expenditures $ 3,192,535.00 $ 3,060,133.00 $ 3,060,133.00 $
Operating Expenditures 521,783.00 654,190.00 654,190.00
Internal Support Expenditures 1,028,971.00 1,038,068.00 1,036,068 00
Transfers
- 0.00% -
- 0.00% -
2,000.00 0.19% Favorable Print Shop $2,000 due to decreased activity.
Animal Control
Personnel Expenditures
$ 4,743,294.00 $ 4,752,391.00 $ 4,750,391.00 $ 2,000.00 0.04%
$ 1,661,152.00 $ 166l,152.00 $ 1,637,052.00 $ 24,100.00 1.45% - Favorable Overtime $20,000 and Holiday Overtime $2,000 due
to implementation of staggered work schedules in the Kennel to
eliminate overtime on Saturdays and holidays, and On Call
$2.100 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 660,744.00
Transfers
$ 2,476,863.00 $ 2,515,318.00 $ 2,491,218.00 $ 24,100 00 0.96%
Circuit Court Probation
Personnel Expenditures $ - $ -
Operating Expenditures 40,798.00 40,798.00 40,798.00
#nternal Support Expenditures 568,038.00 568,414.00 568,414.00
$ 608,836.00 $ 609,212.00 $ 609,212.00 $ 0.00%
Department Total
Personnel Expenditures $10,565,802.00 $ 10,433,400 00 $ 10,424,300.00 $ 9,100.00
Operating Expenditures 1,733,838.00 1,877,240.50 1,874,240.50 9,155.00
Internal Support Expenditures 3,231,984.00 3,313,115.00 3,287,615.00 25,500.00
Transfers -
515 1531,624.00 $ 15,623,755.50 $ 15,586,155.50 $ 43,755.00 0.28%
0.09%
0.49%
0.77%
• See related revenue offset. 2118/2010
Internal Support Expenditures 82,156.00 86,763.00
$ 1,407,718.00 5 1,562,185.00
86,763.00
----------- --
$ 1,467,785.00 $
0.00%
94,400.00 6.04%
$ 3,548,658 00
1,530,210.00
$ 3,523,158.00 $ 25,500 00
1,445,210.00 85,000.00
Workforce Development
Personnel Expenditures
Operating Expenditures
Internal S upport Expenditures
0.00% - 25,620 00 $ 25,620.00 $ 25,620.00 $
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
EXPENDITURES
ECONOMIC DEVELOPM ENT AND COMMUNITY AF FAiRS
ADOPTED AMENDED FY 2010
BUDGET BUDGET FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE 1 PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures
Operating Expenditures
7.13% - -Turnover
4.29% - Fav. Outside Printing due to use of County Print Shop and fay.
Personal Mileage based on usage requirements.
$ 1,097,503,00 $ 1.097503.00
228,059 00 377,919.00
$ 1,019,303.00 $ 78,200.00
361,719 00 16,200.00
Planning and Economic Development Services
Personnel Expenditures $ 3,548,658.00
Operating Expenditures 1,345,210.00
962,22E1.00 967,269.00 917,269.00 50,000 00
0.72% - Turnover
5.55% - Fav. Operating $85,000 tor update of Solid Waste Management Plan
which is delayed pending reformatting of plan guidelines by the State,
primarily Professional Services, Advertising, Printing, Legal Services,
Travel & Conference, and WM5414110 Clues.
5.17% - Fea IT Operations based on current charges. Internal Support Expenditures
$ 5,856,096.00 $ 6,040,137.00 $ 5,885,637.00 5 160,500.00 2.65%
Community and Home Improvement
Personnel Expenditures.
Operating Expenditures
Transfers
- s - $
. 00 % S 25 620 00 $ 25620.00 $ 25,620.00 $
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
T ransfers
S 4,671,781.00
1,573,259.00
1,044,384.00
$ 4,671,781.00
1,908,129.00
I ,054 ,032.00
$ 4,568,081 00
1,806,929.00
1,004,032.00
$ 103,700.00
101,200.00
50,000.00
2.22%
5.30%
.174%
0.00%
S 7,289,434.00 5 7,533,942.00 S 7,378,042.00 $ 254,900.00 3.34%
3120010
0.00%
0.00%
0.00%
0.00%
-21.50% (301,000.00)
30,000.00
1,400,000.00
30,000.00
1,430,000.00
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
NON-DEPARTMENTAL EXPENCIITURES
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION
NON-DEPARTARTMENT APPROPRIATIONS
COUNTY OPERATIONS
Insurance Fund
Insurance Surety Bonds
Miscellaneous
Logos and Trademarks
Road CommissionlCurrent Drain Assessment
$ 180,424.00 5 180,424.00 $ 180,424.00
16,900.00 16,900.00 16,900.00
30,000 00
1.701,000.00 Uniav Current Drain Assessment ($301,000) 'the shortfall is
related to additional one-lime drainage district construction
assessments that are expected to be assessed in FY 7010.
The majority of the construction assessment increase is related
to the Franklin Sub-Watershed drainage district whereby there
are several assessments tor various projects in the Franklin
Sub-Watershed and the apportionment percentage to Oakland
County, on behalf of County roads, ranges up to approxlrnately
25%. A budget amendment is recommended to recognin a
porton of Indirect Cost Recovery revenue favorability to offset
the shortfall in Drain Assessments.
Road Commission\Tri Party Agreement 100.00 100.30 100.00 0.00%
Provisions. 30,000.00 30,000.00 30,000.00 0.00%
Telephone 14,000.03 14.000.00 14,000.00
1ransfer to CMI1A 9,520,516.00 9,620,616.00 9,620,616.00 0.00%
Total $ 11,292,440.04 $ 11,292,040.00 $ 11,593,040.00 $ (301,000.00) -2.57%
COUNTY BUILDINGS $ 2,894,173.00 $ 2,775,147.00 $ 2,775,147.00 0.00%
STATE AND FEDERAL - COUNTY ASSOCIATIONS
Area Wide Water Quality $ 55,000.00 $ 55,000.00 $ 55,030.00
Assoc of Metro Sewage Agencies 1,700 00 1,700 00 $ 1,700.00
Michigan Assoc. of Counties 70,700.00 70,700.00 $ 70,700.00
National Assoc. of Counties 24,000.00 24,000.00 $ 24,000.00
S.E.M.C.O.G. 579,000 00 579,000.00 $ 579,000.00
1raffic Improvement Association 30,000.00 30,000.00 30.000.00
Total $ 760,400.00 $ (60,400.00 5 (60,400.00 $
0.00%
0.00%
0.00%
0.00%
0.00%
0 00%
0 .00%
$ 300,000.00 $ 300,000.00 5 300,000.00 0.00%
150,001) 00
SUNDRY EXPENSE
RESERVED FOR TRANSFERS
Expenditures
Administrative Leave
Budget 1 ransition
Classification and Rate Change
Contingency
Emergency Salaries
Grant Match
Info Tech Develoornen1
90. xis
19.006,090 00
171,871.00
301,917.00
1,309,945 00
1,989,437.00
5,803,133.00
- $
19,481,8.52.00
168,414.00
301,91(.00
1,309,945.00
1,655,351.00
4,505,244.00
19.451,55210
158,414.00
151,91f 00
1,309,945.00
1,655,351 .00
4,505,244 .00
3.33%
0_00%
0.00%
49,68%
0..00%
4.03%
0.00%
2i25Q010
1,458,768.00 1,458,768.00
413,997.00 413,991.00
135,510.00 135,510.00
1,208,186.00 1,208,186.00
1,131,143.00 1,131,143.00
0.00
1,458,768.00
0.00
413,997 00
135,510.00
1,208,186.00
1,131,143.00
0.00%
0_00%
0.00%
0.00%
000%
0.00%
0.00%
0.00%
0.00%
0.00% $ 4,347,604.00 $ 4,347,604.00 $ 4,347,604.00 $
.11k
90.xls 2125/2 01 0
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
NON-DEPARTMENTAL EXPENDITURES
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
Legislative Expense 120,400.00 120.400.00 120,400.00 0.00%
Misr, Capital Outlay 75,000.00 TS,000 00 75,000.00 0.00%
Overtime Appropriation 53,000.00 53,000.00 53,00000 0.00%
Summer Employees Salary Approprialion 259,766 00 259,156.00 259,766 DC -
Total $ 29,090,559.00 5 27,930.889.00 $ 27,750,889.00 $ 150,000.00 0.54%
EXPLANATION
Transfers to Other Funds
Jail Population Management Fund
Capital & Cooperative Initiatives Revolving Fund
Debt Service - West Wing Refunding
Project Work Order Fund
Fire Records Management
Radio Communications
CLEMIS
Information Technology
Facilities Ma Menem.° & Operations
TOTAL NON-DEPT. APPROPRIATIONS $ 48.684,776.00 $ 47,406,000.00 $ 47,557,080.00 $ (151,000.00) -0 32%
TRANSFER TO GENERAL PURPOSE FUNDS
Public Health Fund $ 24,395,153.00 $ 25,362,319.00 $ 25.362,319.00 0.00%
Child Care Fund 24830,133.00 22,546.828 00 22.846,828.00 000%
Social Welfare Fund Foster Care 1,000.00 1,000.00 1,000.00 0 00%
$47,226,286.00 $48,210,147.00 $48,210,147.00 $ - 0.00%
TOTAL EXPENDITURES $ 95 911 062 00 $ 95 616 227 00 S 95,767,227.00 5 151,O00.00 -0 16%
EXPLANATION OF SIGNIFICANT VARIANCES
.....
REVENUES
Charges for Services $20,000,000.00 $20,000.000.00 $74,500,000.00 $4,500,000.00
OPERATING EXPENSES
Personnel Expenditures
Operating Expenditures
Interest Expense
Transfer Out to Other Funds!
General Fund - Collection Fees
$ 97,308.00
460,000.00
1,500.000 00
4,500,000.00
$ 97,308.00
460,000.00
1,500,000,00
4,500,000.00
97,308.00
345,800.00
1,500,000,00
4,689.782.00
0.00%
114,200.00 24.83%
0.00%
(189./82.00) -4.22%
COUNTY Of OAKLAND
FY 2010 FIRST QUARTER REPORT
ENTERPRISE FUND
TREASURERS OFFICE
ADOPTED
BUDGET
1.141JNCILIENT TAX REVOLVING FUNGI 51800
AMENDED
BUDGET
FY 7010
FORECAST
VARIANCE
FAV/(UNFAV) PERCENT
22.50% I-ay. variance due to the increase in delinquencies. Collection fees
arid inteleiM are assessed on deFriquent. (axes, which have
increased.
Other Revenues
Total Revenues
3,212,900.00
$23,212,900.00
3,212,90000 7,517,900.00
$23,212,900.00 $27,012,900.00
(700,000.00)
$3,800,000.00
-21.79% Unrav. variance due to decrease in projected investment base.
16.37%
Fay, variance is due to Indirect Costs being lower than anticipated.
Unfav. variance is due to more than anticipated amounts assessed
in collection tees. Collectron lees are recorded in the DIRF and
transferred to the Treasurer's General Fund Budget at year end.
Gr - Non-Departmental
Work Release Facility Petit Svc
Office Bldg Renovation Debt Svc
57-3 District Court Debt Service
Total Transfer Out to Other Funds
Total Operating Expenses
REVENUE OVER (UNDER}
EXPENDITURES
Total Net Assets - Beginning
rotal Net Assets - Ending
21,650,000,00 21,550,000.00
1)162.695 00 1,862,625.00
2,096,852 00 2,096,852.00
1.385,600.00 1,385,600,00
31.49,077..00 31.495.077.00
$ 33,552,385.00 $ 33,552,385.00
21,650,00000
1,862,625,00
2,096,852.00 -
1385,600.00
31..684,859.00 (1139,782.00j
$ 33,627,967.00 $ (75,582.00)
0.00%
0.00%
0.00%
-0.60%
-0.23%
A1SL331,40151KA .1.$10,339,4 (i6,615,067.00). $3,724,418.0
$229,351,629.91
$222,736,562.91
Ending FY 2010 Designated Fund Balance:
Designated - Debt Service
Designated - Delinq Taxes Receivable
Designated - Collection Fees
Undesignated - Fund Balance
Total Net Assets - Ending
$72.568,273.84
105,909,116,47
15,000,000.00
$29 269,172.60
222.73Q,0$62.91
)13 DT RF 451600 Quarterly Forecast.xls 312f2010
PERCENT EXPLANATION or SIGNIFICANT VARIANCES
22.50% Fay. variance doe to the increase in delinquencies. Collection fees
and Interest are assessed on delinquent taxes, which have
increased,
3,212,900.00 3,212,900.00 2,512,900.00 (7_00,000.00), -21.79% Unfav variance due to decrease in protected investment base.
$23,212,900.00 $23.212,900.00 $27,012,900.00 $3,800,000,00 16.37%
$ 97.308.00
460,000.00
,500,000.00
$ 97,308.00
460,000.00
1,500,000.00
0.00%
114,200.00 24.83% Fay, variance is due to Indirect Costs being lower than anticipated.
0.00%
97,308.00
345,800.00
1.500,000.09
Unlav. variance is due to more than anticipated amounts assessed
in collection fees. Collection Fees are recorded in thc Dr RI- and
transferred to the Treasures General Furef Budget at year end
4,689,782.00 (189,782.001 -4.72%
21,650,000.00
1,852,675.00
2,096,852.00
1.385.600 00
31 495,077.00
$ 33,552,385.00
21,650,000.00
1,862,625.00
2,096,852.00
1,385.600.00
31.495 077.0
$ 33,552385.00
21,650,000.00
1,862,625.00
2,096,852.00
la35,600.00
31,684.859-00
$ 33,627,967.00 $ (75,582.001
0.00%
0.00%
0,00%
0.00%
-0.23%
1189.762S32)
$3,724418:00
$229,351,629.91
$222,736,562.01
SiC.L3.31411.U.01
54,500,000.00 $24.500,000 00 $20,000,000.00 $20,000,000.00
4,500,000.00 4,500,000.00
$72,558.273.84
105,909,116.47
15,000.000.00
$29 259,172.60
.1221.12LIAL21_
COUInITY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
ENTERPRISE FUND
TREASURERS OFFICE
ADOPTED
BUDGET
DELINQUENT TAX REVOLVING hUND 51600
AMENDED FY 2010 VARIANCE
BUDGET FORECAST FAV1(UNFAV)
REVCNUES
Charges for Services
Other Revenues
Total Revenues
OPFRATING EXPENSES
Personnel Expenditures
Operating Expenditures
Interest Expense
Transfer Out to Other Funds:
General turd - Cottection Fees
GF - Non Deparlmentai
Work Release Facility Debt Svc
Office Bldg Renovation Debt Svc
52-3 District Court Debt Service
Total Transfer Out to Other Funds
Total Operating Expenses
R.FVF NUF. OVER (UNDER)
EXPENDITURES
Total Net Assets - Beginning
Total Net Assets - Ending
Friding FY 2010 Designated Fund Balance:
Designated - Debt Service
Designated - DON 'taxes Receivable
Designated - Collection Fees
Undesignated - Fund Balance
Total Net As-sels - Ending
DIRP *51600 Ouarlerly Forecast.xls 31217010
[LIABILITY INSURANCE FUND 07700
OPERATING REVENUES:
Outside Revenue $ - $ - s
Total Operating Revenue 2,375,561.00 $ 7,375,56100 5 2,315,561 i S 0.00%
NET REVENUES OVER4UNDER)
EXPENSES - $ (1,726.00) $ (1,700.00)
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
INTERNAL SERVICE FUND
RISK MANAGEMENT
ALIO*, TED AMENDED EY 2010 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Inside Revenue 2 375 581.00 2,315,561.00 2,315,561110 $ 0.00% -
OPERATING EXPENSE
CLAIMS PAID
TOTAL OPERATING EXPENSES
OPERATING INCOME (LOSS)
$ 2,484,1./b3.1.)0 $ 2,484,0b3.00 $ 2,485,779.00 5 (1,700.00) -0.07% - Uniav indired: uusts ($1,700) due t tuaI charjes developed
after budget finalization.
791,508 00 291,508.00 S
2,777,287110 $ (1,700.00) -0.07%
(400,000 00) (400,000.00) (401,726.001 (1,700110)
291,508.00
$ 15,561.00 $ 2,775,561.00 $
NON-OPE RA1 ING REVENUE (EXPENSE) 409,000110 400,000,00 400,000.00 0.00%
TOTAL NET ASSETS - BEGINNING 15,872,684,29
101AI NET ASSETS - ENDING 5 15370,838.29_
2117/7010
NET REVENUES OVER/(UNDER)
ExPEN:SES (1,725.00) S j1M.0.94
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
INTERNAL SERVICE FUND
RISK MANAGEMENT
• ADOPTED AMENDED FY 2010 VARIANCE
BUDGET BUDGET FORECAST FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
LIABILITY INSURANCE FUND 67700
OPERAT ING REVENUES
Outside Revenue - $ - $
Inside Revenue 2,375,561.00 2,375,561.00 2,375,561.00 $ 0.00%
Total Operating Revenue
OPERATING EXPENSE
5 2,375,561.00 $ 2,375,561.00 5 2,375,561.00 $ 0.00%
$ 2,4134,053.00 5 2,484,053.00 $ 2,485,779.00 5 (1,700.00) -0 Oi% - Unfav Indirect costs (51,700) due to actual charges devokved
alter budget finelizelion.
CLAIMS PAID 291,508.00 291,508.00 291,508 00 $ -
TOTAL OPERATING EXPENSES $ 2,775,551 DO $ 2,775,561.00 $ 2,777,287,00 $ (1,700.00) 0.07%
OPERATING INCOME (LOSS ) (400,000 00) (400,000.00) (401,726.00) (1,700.00)
NON-OPERATING REVENUE (LXPENSE) 400,000.00 400.0D0 00 400,000 00 0.00%
1 0 T AL NE1 ASSETS - BE- GINNING 15,872 564.29
TOTAL NET ASSETS - ENDING $ - 15 870 838.29
2/17/2010
910 992.1X) OPERATING EXPENSE
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
INTERNAL SERVICE FUND
MANAGEMENT AND BUDGET
ADOPTED AMENDED FY 2010 VARIANCE
BUDGET BUDGET FORECAS1- FA.VAUNF AV) PERCENT EXPLANATION OF SIGNSF MANI VARIANCES
ipEFICE EQUIPMENT FUND 66400
OPERATING REVENUE - INSIDE 776,70T.00 $ 776,797.00 $ 716,797.00 $ 0.00%
910 992.00 932,94.00 $ (21.900.00). -2.40% Uniav indired (:r)sTs [521,900) due to actual charges
developed after livdcreli
OPERATING INCOME (LOSS) __034.195.00L (134,195.00) (156,132.00) (21,900.00)
NON-OPERATING REVENUE (EXPENSE) 35,000.00 35 000.00 35,000.00 $ 0.00%
NET INCOME (LOSS) BEFORE
OPFRATiNG TRANSFERS
OPERATING TRANSFERS IN
(90.195.00) (99 195.00) (121,132.00) (21,900.00)
50,000 00 5000000 50,000.00 $
NET REVENUE OVERJ(UNDER)
FAPENSES (PLANNED USE 01- FUND SAL)' (S49,195.001 (571.132 00) ($21.900.00)
TOTAL NET ASSETS - BEGINNING 3,00,1012,11
TOTAL NE1 ASSETS - ENDING $3,012,680.11
%ON
.00 N2/2010
, COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
ADOPTED AMENDED FY2010 VARIANCE
ITIiii+JGE BENEFITS FUND 67800 BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING REVENUE
REIT REES MEDICAL - VEBA DEBT. 49,046,888 49,046.88-9 49,046,888 , 0.00%
RETIREMENT ADMINISTRATION 2,222,113 2,222,113 2,222, 13 0.00%
DEFINED CONTRIBUTION PLAN 13,997,800 13,997,800 14,383,1 0 385,600 2,75% - Favorable based on first quarter actual
DEFINED CONTRIBUTION PLAN - PINE 175,000 17'5,000 152,110 (23,000) -13.14%
DEFERRED COMPENSATION - COUNTY 340,000 300,000 50,111 (250,000) -83.33% - Unfavorable due to County $300 match- ending 12+31709
EMPLOYEE 1N-SERVICE: TRAINING 1,421,282 1,471,282 1,421,.
• 2 0.00% i ! EMPLOYEE BENEFITS UNIT 617,581 617,581 6I7,' • I - 0.00% i TUITION REIMBURSEMENT 300,000 300,000 300.1 1 I 0.00% t RETIREMENT HEALTH SAVINGS 425,000 425,000 II 492 I
' II 67,000 15.76%
GROUP LIFE INSURANCE 643,400 643,400 740,114 96,600 15.01% ,I 1 SOCIAL SECURITY 15,500,000 15,500,000 15 690, 1 14 ' - II 1 190,900 1.23% .• Favorable based on first quarter actual
MEDICAL INSURANCE. 32,695,000 32,695.000 34,000,111 1,305,000 3.99% - Based on use of Blue Cross Illustrative rates and premiums ksr Health Alliance Plan, I 1 DENTAL INSURANCE. 3,050,400 3,050,400 3,312,11I 1 261,600 8.58% - Based on use of Delta Dental illustrative rales. i VISION INSURANCE 177,500 177,500 236.111 58,500 32.96% - Based on use of Blue Cross illustrative rates.
DISABILITY INSURANCE 752,600 752,600 752, i 0.00%
SHORT-TERM DISABILITY 1,493,600 1,493,600 1,442,01i (51,600) -3.45%
FVORKERS COMPENSATION 2,862,248 2,662,248 2,662 2 - 1 - 0.00%
IJNEMPLOYMENT COMPENSATION 450,0 450,0 489,611 39,000 8.67% ti i NVE.STME.NT INCOME 1,540,9 1,540,9 1,000. • 1 (540,690) -35 co% • Unfavorable due lo lower interest rates. I :X- - FLEX BEN LIF .E INSURANCE 400,0 400, 421,11 21,800 5,45%
.X-. - FLEX BEN DENTAL INSURANCE 115, 115,0 115,041 , 0.00%
F. K - FLEX BEN VISION INSURANCE 105,0 105, 112,- I I 7,900 7.52%
- - FLEX BEN MEDICAL - EMPtOYEE 3,540,0 3,540,0 II
4,413,1,01 673,000 24.66% - Favorable due 10 increase in COBRA rates.
X- - MEDICAL. INSURANCE 275,00 275,00 op
275,1,11 0.00%
X-. - DENTAL INSURANCE 25,00 26,00 251 0.00% - i X" - VlS1ON INSURANCE 2,50 2,50 0.03% -
X- - FORFEITURE OF DEPOSITS 10,00 13,00
2,-1,
10, ilti 0.00% -
- OTHER REVENUE - ICMA REBAT ES 200, n: 200,000 1L:MA Rebates formerly receipted into the General Fund,
.X' - PRESCRIPTION DRUG REBATES 455,0 465,0 465, I 14 0.00%
E l ERRED COMPENSATION - AMAIN 64,80 64,8 64,t; :1 a00% -
LEA BENEFIT PLAN 200,00 200,00 200, 0.00%
RINC3E BENEFITS 1-01,23 101,23 101,23 0.00% -
ELI NESS UNIT 490.064 490,06 490,06- 0.00% -
..XI -- TRAINING 50 500 0.00%
AT - CHILD CARE FACILITY 720' 7.200 0.00% - -
-XI INLLINESS PROGRAM - 5,00 _ .. 5,000_ 0.00% -
I TAL REVENUE 133,264,969 133,264,959 135,919,36* 2,654,400 1.99%
0 FRINGE BENEFITS.xls 3r312010
COUNTY OF OAKLAND
FY 7010 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
ADOPTED AMENDED FY2010 VARIANCE
iFRINGE BENEFITS FUND 67800 I BUDGET BUDGET FORECAST F AVilUNFAV) PERCENT
----
EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING EXPENSE
RETIREE.S MEDICAL - VLBA DEBT PRINCIPAL
RETIREES MEDICAL - VEBA DEBT INTEREST
RETIREMENT ADMINISTRATION
DEFINED CONTRIBUTION PLAN
DEFINED CONTRIBUTION PLAN • P1 NF
DEFERRED COMPENSATION - COUNTY
DEFERRED COMPENSATION - ADMIN
SICK AND ANNUAL LEAVE CASH-OUT
EMPLOYEE IN-SERVICE TRAINING
IN-SERVICE TRAINING - fl4F0 TECH
EMPLOYEE BENEFITS UNIT
TUITION REIMBURSEMENT
GROUP LIFE INSURANCE
SOCIAL SECURITY
MEDICAL INSURANCE
PRESCRIPTION COVERAGE
DENTAL INSURANCE
VISION INSURANCE
ISABILITY INSURANCE.
ORKERS COMPENSATION
NEMPLOYMENT COMPENSATION
LEXIBLE BENEFIT PAYMENTS
CCOUNTING SERVICES
HILL/ CARE FACILITY
ROFESSIONAL SERVICES
.ETIREME NT HEALTH SAVINGS
El L NESS PROGRAM
NDIRECT COSTS
TOTAL EXPENSE
17,590,000 17,590,000 17,590,000 - 000%
31,456,888 31,456,888 31,456,888 - 0.00%
2,222,113 2,222,113 2,222,113 - 0.00%
13,997,800 13,997,800 14,768,700 (770,903) -5.51%
175,000 175,000 143,500 31,503 1 00%
300.000 300.000 50,000 250,000 8 33%
64,800 64,800 64,800 00%
716,718 716,718 716,718 .00% •
1,071,282 1,071,282 1,071,282 00% -
350,000 350,000 350,000 - .00%
617,581 617,581 617,581 . .00%
300, 300,000 300,00 - .00%
1.043,4 1,043,400 1,216,00 (172,600) -1 54%
15.500, 15,000.000 16,076,3 (576,300) - -72%
28,500,00 28,500,000 29,000, (500,000) -1.75%
8,475,0 8,475.000 9,250,00 (775,000) -9.14%
3,130, 3,190,400 3,190,4 0.00%
255,00 285,000 285,00 - 0.00%
2,246,2 2,246,200 2,196,40 49,800 2.22%
2,562,24 2,667,248 2,662,24 - 000%
450,00 450,000 967,20 (517,200) -114 93%
200,0 200,000 181,00 19,000 9.50%
101.23 101,233 101,23 - 000%
251.03 251.030 251.03 - 0.00%
300,00 300,000 300,000 - 0.00%
425,000 425.000 447.800 (22.800) -5•36%
490,064 490,004 490.064 0.00%
283,212 283,212 292,712 (9,500)_ -3.35%
133,204.969 133.254,969 136,258,969 (2.994 000) 2.25%
lintavorable based on first quarter actual. A budget amendment is recommended..
- Favorable due to County $300 match ending 17131i09
- Unfavorable due to increase in basic life atsurance rates.
- Unfavorable based on first quarter actual.
- Unfavorable due to increase in BCBS and HAP premiums.
- Unfavorable due to increase in prescription claims and admin fee.
- Unfavorable due to federal stimulus package allowing additional weeks
NET REVENUE OVER/(UNDER) EXPENSES
101AL NET ASSETS -BEGINNING
TOTAL NE 1' ASSETS - ENDING
00 . (339,600)
12,141,361
11.801,761
tw 1'312010 FRINGE BENEFIT S.xls
OPERATING REVENUE $5,457.064.00 55,457,064.00 54,361,064 00 (S1,096,000.00)
50,000.00 OPERATING EXPENSE 5,595,441.00 5,595,741 00 5,545,441.00
NET OPERATING INCOME (LOSS) (1138.877.00) ($138.371..00) ($1,184,377 00) ($1,046+000.00)
NON-OPERATING REVENUE (EXPENSE) 3,584.00 3,284,00 1284:00 000%
0.00%
($135,093.00)
0.00
135,093.00
$0.00
($-135,093.00)
0.00
135,093 00
$0.00
10 r AL INCOME BEFORE
CON1 RIBU1 IONS AND I RANSFEFIS
TRANSFERS IN
CAPITAL CONTRIBUTION
TOTAL NET INCOME (LOSS)
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
$ (1,181,093.00) ($1,046,000.00)
0.00 0.00
135,093.00
J$1,046,000.001 ($1,046,000.00)
$ 67,549,813.00
$66,503,813.00
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
ENTERPRISE FUNDS
CENTRAL SERVICES
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2010
FORECAS1
VARIANCE
1-AV/(LINFAV) PERCENT EXPLANATION OF SIGNIFICANT VAFHANCLS
OAKLAND COUNTY INTERNATIONAL
AIRPORT (56500)
-20.08% - Unfavorable T-Idangar Rental ($550,000) due to a decrease in the number of
I-Hangars leased, Aviation Gas Commission (5540,000), Landing Fee
Concession ($20,000), Landing Fees ($16,000) and Car Rental Comession
($10,000) as a result of less traffic and downturn in the economy.
0.89% - Unfavorable Overtime ($40,000) and the fringe benefits associated with it due
to personnel needed to clear heavy snowfall; offset by Favorable Properly
Taxes $90,000 due to lower than anticipated property taxes for T-Haogars
755.91%
3/3/2010
Inside Revenue 8,123,638.00 8,123,638.00 7,106,138.00 $ (1,017,500 00)
Total Revenue
OPERATING EXPENSE
$ 8,250,124,00 $ 8,250,12.4.00 $ 7,184,624.00 $ (1,065,500.00)
8,255,444.00 8,255,444.00 7,666,344.00 $ 589,100.00
OPERATING INCOME (LOSS)
NON-OPERATING REVENUF
(EXPENSE)
$ (5,320.00). $ (5,320.00) $ (481,720.00) $ (476,400.00)
240,000.00 240,000.00 90,300.00 $ (149,700.00)
iro
ADOPTED
BUDGET
MOTOR POOL FUND 66100
AMENDED
BUDGET
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS
CENTRAL SERVICES
FY 2010 VARIANCE
FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING REVENUE:
Outside Revenue -37.95% - Unfav. reduced external other revenue ($44,000) due to CVT
services less than expected.
$ 126,456.00 $ 126,486.00 $ 78,486.00 $ (48,000.00)
-12.53% - Unfav. decrease in fuel revenue ($357,000) due to lower fuel
costs and dept. reduction of fuel usage, offset by the fay.
gasoline charges; decrease in leased equipment ($500,000)
due to vehicles turned in by departments, reduction in vehicle
miles driven, and delay for replacement of new vehicles;
reduced parts and accessories revenue ($132,000) due to
service less than expected, partially offset by the fay. parts and
accessories expenses.
7.14% - Fay. salary/fringe benefit reduced by $13,000 due to two
under-filled automobile mechanic II positions being filled with
automobile mechanic !employees and overtime less than
expected; decrease in equipment rental $15,000 due to leased
vehicle contract expiration; reduced gasoline costs by
$349,000 due to lower fuel price; auction expenses were
reduced by $14,000 due to elimination of fafl auction and
increased sale of vehicles at Flint Auction, fleet insurance
$36,000 due to estimated premium saving, reduced spending
in parts and accessories $137,000, shop supplies $17,000.
Fay. depreciation of $100,000 due to operating vehicles being
held longer and vehicles sold in auction before fully
depreciated.
Unfav. increase in indirect costs ($97,000) due to actual
charges developed after budget finalization. Budget
amendment is recommended.
-62.38% - Unfav. gain on sate of vehicles ($150,000) due to sale
proceeds less than salvage value and increase on the mileage
driven from 85K to 100K before replacing.
J:\FiscalSvc\BudgetlForecast NevASUPPORT SERVICES.xls 3/2/2010
TRANSFERS IN (OUT) 0.00 $
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
$ 7,655,276.78
7 263 856 78 mmm•I s
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS
CENTRAL SERVICES
ADOPTED AMENDED FY 2010 VARIANCE
BUDGET BUDGET FORECAST FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS $ 234,580.00 $ 234,680.00 $ (391,420.00) $ (826,100.00)
NET REVENUE OVER/(UNDER)
EXPENSES {PLANNED USE OF
FUND BAL.)* $ 234.680.00 $ 234.680.00 $ (391,420.00) $ (626,100.00)
JAFisealSvc1BudgetWorecast New\SUPPORT SERVICES.xls 312/2010
2,862,167.00 Inside Revenue
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
366,765.42
351,199.42
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS
CENTRAL SERVICES
ADOPTED
BUDGET
AMENDED FY 2010 VARIANCE
BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
'MAILING, CONVENIENCE COPIER AND PRINTING FUND 66700
OPERATING REVENUE
Outside Revenue $ 620,500.00 $ 620,500.00 $ 620,500.00 $- 0.00% -
2,862,167.00 2,783,167.00 $ (79,000,00) -2.76% - Unfav, due to decrease of printing revenue ($73,500) - less in-
house printing jobs
Total Revenue $ 3,482,667.00 $ 3,482,667.00 $ 3,403,667.00 $ (79,000.00)
OPERATING EXPENSE 3,450,233.00 3,450,233.00 3,420,233.00 30,000.00 0.87% - Fay. decrease in printing for contracted servic:es $20,000,
printing supplies and stationery stook $17,000 due to less
printing jobs
Unlav, indirect costs increased by ($15,000) due to actual
charges developed after budget finalization. Budget
amendment is recommended.
OPERATING INCOME (LOSS) $ 32,434.00 $ 32,434.00 $ (16,566.00) $ (49,000.00)
NON-OPERATING REVENUE
(EXPENSE)
4,000.00 4,000.00 1,000.00 (3,000.00) -75,00% - Unfav. reduced interest income based on prior years' actuals.
NET REVENUE OVER1(UNE:1ER)
EXPENSES (PLANNED USE OF
FUND BAL.)* $ 35,434.00 $ 36,434.00 $ (15,566.00))10 _
'Please note that in the Adopted Budget (line-item budget), Planned Use of Fund Balance appears listed with the revenue accounts.
J.WiscalSvc‘Budget‘Forecasl_NevOSUPPORT SERVICPS.xis 3/2/2010
de*
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
INTERNAL SERVICE FUND! ENTERPRISE FUND
FACILITIES MANAGEMENT
ADOPTED AMENDED FY 2010 VARIANCE
BUDGET BUDGET FORECAST FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
rff.CILITIES MAINTENANCE & OPERATIONS (#63100)1
OPERATING REVENUES:
Outside Revenue
Inside Revenue
$533,500.00 $533,500.00 $533,500.00 0,00 0.00%
25,750,859.00 25,750,859.00 25,705,259.00 (45,600.00) -0.18% - Reduced Office Space Rental revenue based on lease agreement with O.C. Road
Commission for space in the IT Center.
Total Revenue $26,284,359.00 $26,284,359.00 $26,238,759.00 ($45,600.00) -0.17%
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
NON-OPERA1ING REVENUE
1RANSF-ERS IN
TRANSFERS OUT
NE1 REVENUES OVER(UNDER)
EXPENSES*
$26,454,359.00 $26,454,359.00 $75,732,359.00 $722,000.00 2.73% - Fay. Natural Gas/ Fuel Oil $350,000 due to lock-in of favorable iong-term pricing
contracts; fay. Electrical Service $250,000 due to lower cost third-party contracts
and savings from energy conservation initiatives implemented by EM&O; fay.
Depreciation $70,000 based on depredation schedule; and fav. Water & Sewage
Charges $25,000, Motor Pod $25,000 and Laundry & Cleaning 15,000 based on
usage requirements; fav, Software Rental & Support $16,000 due to conversion to
in-house CAMS program; and fay. Overtime $15,000 due to less snowplowing
activity,
Favorability is partially offset by unfav, Indirect Costs ($17,750) due to
determination oi costs subsequent to budget determinatiori: and License 8 Permits
($9,750) for required State licenses, and Rent ($6,000) required for furniture
storage, both unfav, due to creation of new accounts to track these costs.
($170,000.00) ($170,000.00) $506,400.00 $616,400.00
$170,000.00 $170,000.00 $17000000 $0.00 0 00%
(400,000.00) (400,000.00) (400,500.00) (500-00) 0.13% - Variance is for transfer out to PWO Fund for final invoice for Maintenance project.
($40000000) ($400,000.001. $275,9.00.00 $675,900.00
TOTAL NET ASSETS - BEGINNING $12,402,209.80
TOIAL NET ASSETS • ENDING $12,678,109,80
'Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category.
FACILITIES INTERNAL FORE.xls 2/22/2010
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS 1 ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2010
BUDGET BUDGET FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCES
I Fire Records Management ( 53100) I
OPERATING REVENUES:
Outside
TOTAL OPERATING REVENUES
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
NON-OPERATING REVENUE
TRANSFERS IN
TRANSFERS (OUT)
OPERATING INCOME (LOSS)
$207 112 00 $207,112.00 $210,712.00 $3,600 00 1.74% Fay. primarily due to the implementation of new agencies.
$207,112.00 $20711200 $21071200 $3,600 00 1.74%
$644,316.00 $644,316.00 $622,216.00 $22,100.00 343% Fay Communications $12,200 savings in connectivity costs; IT Ops $10,100; Indirect
Cost $2.900,Travel $2,000 & Personal Mileage $1,400 due to decreased demand for
techs to travel to member sites; Expend Equip $10,300 decreased equip replacements.
Fay, partially offset by unfav Software Purchase (9,000) due to the liming of software
license purchases for new member agencies ; tT Dev ($5,800) due to programming
services/. Dewed ($2,100) due to purchase of server equip after budget.
($437,204.00) ($437,204.00) ($411,504.00) 325,700 00
2,000.00 2,000.00 3,40000 1,400.00 70.00% Interest Income favorable due to higher cash balance than anticipated.
435,70500 438,705 00 435,705.00 0.00 0.00%
0.00 000 0.00 0.00 0.00%
$3,501.00 $3 .501 00 $30,601.00 $27,100.00*
TOTAL NET ASSETS - BEGINNING 364,027.30
TOTAL NET ASSETS - ENDING __$394,628 30
Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" in Me revenue category and Budgeted Equity Adj in Expenses.
AMENDED
BUDGET
$4,324,251.00 ($208,900 00) 838% $4,324,251.00
ADOPTED
BUDGET
lInformation Technology - OLEMIS (5_3500
OPERATING REVENUES'
Outside
FY 2010
FORECAST VARIANCE
$4,115,351.00
($2,994,965.00) ($2,446,665.00) $548,300.00
15,000.00 9,900.00 (5,100.00) -34.00% Unfav, Interest Income due to lower cash balance than anticipated.
1,409,188.00 1,408,188.00 0.30 0.00%
0.00 0.00 0.00 0.00%
TOTAL OPERATING REVENUE $565592500
OPERATING EXPENSES $8,650,890.00
Inside 1,331,674.00
NET INCOME {LOSS} BEFORE
OPERATING TRANSFERS ($2,994,965.00)
NON-OPERATING REVENUE 15,000.00
TRANSFERS IN 1,408,186.00
TRANSFERS (OUT) 0.00
Fav. Primarily due to In-Car Terminals Inlemtal $11,090 due to MDC count higher than
budget projection.
Fav.SallFB $343,100 due to uriderfills & vacancies; Comm $8,400 due to lower than
anticipated costs; indirect Cost $25,400; IT Dev $343,600, IT Ops $23,000; Motor Pool
$20,300; Print Snap $7,500 & Tele Comm $6.800 due to decreased costs. Offset by
unlay .Expend Equip ($3,100) due to equipment, needed for repairs; R.ebillable Services
($15,700) due to addtl costs ol the Tier 2.5 & 3.0 agencies; Bank Charges ($12,800) due
to cost for paypal services for [-Commerce transactions
1,331,674.00 1,342,774 OG 11,100 00 53.20%
$5,655,925.00 $5,458,125.00 ($197,800.00) 8.39%
$8.650.89C1.00 $7,904,790.00 $746,100 00 8.62%
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS I ENTERPRISE FUND
INFORMATION TECHNOLOGY
EXPLANATION OF SIGNIFICANT VARIANCES
Untav. CLEMIS Crash ($150,000) & CLEWS Citation ($200,000) due to timing ol
implenieritation of programs. Partially ofiset by lay. Parts & Access $7,500 & Labor
$1,000 for CL EMS Tech support; Maintenance Contracts $49,700 Livescan maint after
warranty; Rehilled Charges $25,700 additional connectivity cosls charged to the Tier 25
& 3.0 agencies; In-Car Terminals External $57,104 due to MDC count higher then
budget projection.
NET REVENUES OVER(UNDER) EXPI ($1,571 779.00) ($1,57 .04). 1 779 ($1,028,579 00) -- $543 200.00 ----,..i.......:—.
TOTAL NET ASSETS - BEGINNING 11 903,162.90
TOTAL NET ASSETS - ENDING j.10187_52.81
Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use 01 Fund Balance" in the revenue category.
COUNTY OF OAKLAND
FY lOf 0 FORST QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED F(2010
BUDGET MIDGET FORECAST VARIANCE RXPLANATION OF SIGNIFICANT VARIANCES
cinformation Technology - Radio Communications (53600}
OPERATING REVENUES.
Outside $5,266,277.00 $5,266,277.00 S5,695,377.00 $429,100.00 8.15% Fay. E-911 $303,000 due to higher than anticipated revenue from wireless Co; Outside
Agency $120,800 due to timing of phase out of legacy system & Antenna Site Mgt
$5,300 due to additional equipment installed by co-locators.
Inside 320,965.00 320,965.00 489,965.00 169,000,00 52.65% Favorable Internal Revenue torl eased Equipment $144,000 & Parts Access $25,000
due to timing of the projected phase-out 01 the legacy system
TOTAL OPERATING REVENUE $5,587,242.00 $5,587,242.00 $6,185,342.00 $598,100.00 1010%
OPERATING EXPENSES $7,694,324.00 $7,694,324.00 $8,031,624.00 ($337,300.00) -4,38% Fav. primarily due to Saf&FB $136,000 due to tower than anticipated overtime; Special
Projects $40,000 due to liming of exp; Sma.II Tools & Supplies $11.000 due to timing of
purchases; Indirect Cost $29,000. Fay, partially offset by untav. Expendable Equip
f$500,700) due to NG911 equip replacemnts; Travel ($15,000) & IT Dev ($6,300) due to
usage & Prof Svcs (S32,000) for training.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS ($2.107,052.00) ($2,107,082.00) ($1,646,262.00) $260,800.00
NON-OPERATING REVENUE 150,000 00 150,000.00 250,000.00 100,000 00 66.67% Fav. primarily due to Interest Income; nigher cash balance than anticipated.
TRANSFERS IN 135,510 00 135,510.00 135,510.00 0.00 0.00%
TRANSFERS (OUT) (250,000.00) 250,000.00) 4250,000 R. 0.00 0.00%
NET REVENUES OVER(UNDER) FXPIOL1.4.22.2.) (S2,071,572.001 ($1,710,772 00) $360,800.00
101AL. NET' ASSETS - BEGINNING 56,468,326 41
TOTAL NET ASSETS - F.NDING
Please note that in the Adopted Budge( (line-item book) this is budgeted as "Planned use of Fund Balance" in the revenue category.
COUNTY OF OAKLAND
FY 2010 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2010
gylg) EI BUDGET POREC_AST VARIANCE EXPLANATION OF SIGNIFICANT VARIANQLS
[Information Technology - Operations (63600)
OPERAT iNt RF.VE.NLIEST
Outside $931,545.00 $931,545.00 $867,945.00 ($63,530.00) -6.83% - Unfav. Enhanced Access Fees ($18.00) due to decreased customer . [Jsage; Outside
Agencies 531 ,100) due. to r ucltr toexkeinal customer rests & Deierre.dt.and Fite
Tax ($13,400) as a result of charge in billing procedures due to tax & asseSsment
software.
Inside 25,244,064.00 25,244,064.00 21,963,164 00 (3,280,900.00) -13.00% - Unlav.. Depts OC Deer! Dev & Dos ($2,633,700) & Imaging Dev & Ops ($590,700) due
to holding rates at prior -year levels. Partially OW by fay. Non Govfl Dev & Gas $50,900
due to increase in projec.ls requested by Non-GF and County AUG11111) $1,500.
TOTAL OPERATING REVENUE $26,175,609.00 $26.175,609 00 522,831,109 00 (3,344,500 00) -12.78%
OPERATING EXPENSES $31.961,870.00 $31.961,8/0.00 $29,684,2/0 00 52,277,600.00 7.13% Fay. primarily due to Degree $1,093,300 for IT capital projects in progress not fully
operational; Sal & FB $724,300 due to vacancies; Equip Maint $419,200 due to lower
than anticipated hardware main' costs; Service Bureau $35,000, Printing $10,000 due to
cost reductions; Travel $10,900 due to decline in staff attending conterences; Contracted
Svcs $25,000 due to budget projection slightly higher than actual rate; &tap $20,000
due to decreased usage. Partially offset by Expend Equip ($34,300)due to equip
replacemenIsProf Svcs 54,700); Comm ($9,200) due to increased usage; Charge Card
Fee ($11,400) credit card lees higher than anticipated. Charge Card fees are offset by
Enhanced Access revenue.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS 55,786,261 .00) 55,786,261.00) ($6,853,161.00) 51.066,960 00)
NON OPERATING REVENUE 305,500.00 305,500.00 302,700.00 (2,800 00) -0.92% Urifav. Interest Income due in lawer cashudlance than antic.igated
TRANSFERS IN 1,181.143.00 1,181,143 00 1,181,143.00 0.00 0.00%
TRANSFERS (OUT) 0.00 0,00 0.00 1)00 0.00%
NET REVENUES OVER(UNDER) E.XPI 54,299,618101 (55,369,318.00) $1,0690+00.00)
TOTAL NEF ASSETS - BE.GINNING 27,256032.26
TOTAL NET ASSETS - ENDING $21 889 114.26
'Please note that in tile Adopted Budget (line-ilern troolk) this is budgeted as "Planned Use di Fund Balance" in the revenue category.
TOTAL OPERATING REVENUE
OPERATING EXPENSES
TO1AL NET ASSETS - BEGINNING
1-01 At NET ASSETS - ENDING
4,949,453.09
$4,1358,676.09
COUNT OF OAKLAND
FY 2010 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS] ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2010
BUDGET BUDGE.' FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCES
!Information Technelogy.L. Telephono Communications 07500)
OF:PRATING REVENUES:
Outside $32,000.00 $32,000.00 539,800.00 57,600.00 23.75% Fav. Sale of Phone External due to ncreased usage.
Inside 3,255,912.00 3,255.912 00 3,102,512.00 _153.400.00) 4.71% Unta v. Sale of Phone fritemal due to ieduction in telephone rates,
$3,287,912.00 53,257,912.00 53,142,112.00 (5145,800.00) 4.43%
53,781,599.00 $3,701,689.00 53,262589.00 $499,100,00 13.27% Fav. Coihrn $366.90C due to decreased rates; Indirect Cost $76.200.; IT Ops $40,000 &
Maint Equip $35,900 subsequent to budget & Motorpool $1000 clue to actual usage.
Fray. partietlyeffset by unfav. Info Tech Dev (V5,0130 clue to Telesofl upgrade and
Deprec (55,900) purchase of capital equipment subsequent to budget.
NET INCOME (LOSS) REFORE
OPERATING ITLANSFFIRS ($473.777.00) ($473,777.00) I5120.4 11 .0% 5353,300.00
NON-OPERATING REVENUE 30,000.00 30.000 00 29,700.00 000.00) -1.00% Way. Interest Income due to lower rash balance than anticipated.
TRANSFERS IN 0.00 0.00 000 0.00 0.00%
TRANSFERS (OUT) 0.00 000 0.00 0.00 0.00%
NET R.EVFNUES OVER(UNDER) EXPI_IpalIZZLCM. ($443,777.00) (590,777,00) ..._§.353,0.0:11,
Please note that in the Adopted Budget itine item book) thks is Pudgeted as 'Planned use ot Fund Balance' in the revenue category.
$ 234,678.15
$ 2.881.576,00
$ 38.522.00 S 3,154.775 -15
$ (225.848.00)
S (551 .057 00)
S (24404000)
$ (22:.849,00)
S 12,18D.00
$ 170.237.00
(4,50c.on)
15.000.00
FY 2010 BUDGET AMENDMENTS
FY 2010 BUDGET AS ADOPTED - GENERAL FUND/GENERAL PURPOSE FUNDS $ 409,835,938.0C
BUDGET AMENDMENTS
M.R. 409236 - 10/14/2009 49.500.00
Health Division - Intergovernmental Agreement with Oakland Schools for Infant Toddler
Assessments
M.R. 409250 - 10/2912009 $ (325,206.00)
Health Division - 200912010 Comprehensive Pianning, Budgeting and Contracting (CPBC)
$ ('.24.747.00)
$ .409,435,485.00
(2,000.00)
M.R. 409239 - 10/2912009
Sheriffs Office - Contract Amendment #2 for Law Enforcement Services in Rochester Hil s
TOTAL AMENDED BUDGET AS OF 1013112009
M.R. 409273 - 11/12/2009
Circuit Court - Juvenile and Adult Drug Court Combined SCAO Grant
TOTAL AMENDED BUDGET AS OF 1113012009 $ 409,433,485.00
M.R. 409290 - 12/912009
Ni188 FY 2009 Year End Report
Encumbrances
Carry Forwards
Appropriation of Designation - CRIMP funds
M.R. 409307 - 12/9/2009
Sheriff - Patrol Contract with Oakland Township
M.R. 409305 - 12/9/2009
Sheriff - Patrol Contract with Independence Township
MAR. 409304 - 12/9/2009
Sheriff - Patrol Contract with Highland Township
M.R. 409303 - 12/9/2009
Sheriff - Patrol Contract with Commerce Townsitp
M.R. 409313 .1219(2009
Sheriff - Patrol Contract with Rochester Hills
M.R. 409288 - 12/9/2009
Management and Budget - Equalization Contract with Orion Townshiop
M.R. 409274 - 121912009
HHS Health Division - Efficiency and Cost Reductions
M.R. 409280 - 12/9/2009
Probate Court / Sheriff - Pilot Project IT interaave Video
TOTAL AMENDED BUDGET AS OF 12/3112009 Si 411,600,354.15
OAKLAND COUNTY LADY JUSTICE RESTORATION PROJECT
October 2, 2009
FROM: Penny Knope, Facilities Management
TO Lynn Sonkiss, Fiscal Services
SUBJECT: Donations to the Lady Justice Restoration Project Fund
The following check were received this week from donors to the Lady Justice
Restoration Project. Please apply them to the Facilities Maintenance &
Operations Courthouse Sublet Repairs fund.
Check # Amount Name
13929 $100.00 Schnelz Wells, P.C.
Total $100.00
Thank you,
Penny Knope
Facilities Management
Check enclosed
Cc: P. Bertolini
H. Larkin
S. Stanford
Project File
opkii ut
1ut • (Q1-4 2,65- IL{ C451,1; 13
OAKLAND COUNTY LADY JUSTICE RESTORATION PROJECT
October 7, 2009
FROM: Penny Knape, Facilities Management
TO: Lynn Sonkiss, Fiscal Services
SUBJECT: Donations to the Lady Justice Restoration Project Fund
The following check was received this week from donors to the Lady Justice
Restoration Project. Please apply them to the Facilities Maintenance &
Operations Courthouse Sublet Repairs fund.
Check # Amount Name
4290 $200.00 Edward Pappas
Total $200.00
Thank you,
Penny Knope
Facilities Management
Check enclosed
Cc: P. Bertolini
R. Larkin
S. Stanford
Project File
pi Lt
-1104c? 7, c LS-kr- i 071 1.4k
• I
TO: FINANCE COMMITTEE
FROM: STEVE HUBER/ Marketing & Communications Officer
Department of Economic Development & Community Affairs
DATE: 2-24-2010
RE: Fifth Third Bank sponsorship of O.C. Business Roundtable
The Oakland County Department of Economic Development &
Community Affairs received a one-time donation of $20,000 from
Fifth Third Bank for sponsorship of the FY 2010 Oakland County
Business Roundtable (OCBRT) and its annual meeting, which was
held in December 2009.
In exchange, Fifth Third was able to call itself the sponsor of the
Roundtable. The Fifth Third logo was placed on the gift that went
to all Roundtable members as a "Thank You" for their service, the
logo and an a full-page advertisement were included in the
OCBRT annual report, the bank president/CEO was given 10
minutes during the annual meeting for remarks, the bank was given
10 seats to the breakfast and permitted to distribute promotional
materials. That is extent of the agreement.
The donation was used to cover the cost of the breakfast, gifts to
OCBRT members and the keynote speaker, kickoff breakfast for
the OCBRT committee chairs and printing costs for the annual
report, which totaled about $10,000.
The remaining S10,000 was paid to News Talk 760/WIR Radio,
which broadcast the Paul W. Smith Show live from the annual
meeting.
The bank has expressed interest in sponsoring the December 2010
BRT (FY2011) but there has been no discussion about the amount
of donation/sponsorship.
COUNT? OF OAKLAND
OFFICE OF THE SHERIFF
MICHAEL J. BOUCHARD
Timothy Soave
Manager Fiscal Services
2100 Pontiac Lake Road
Executive Office Building
Waterford, MI 48328
Mr. Soave,
On February 25, 2010 1 received an e-mail from Kathie Flanery from the Oakland Livingston
Human Services Agency (OLFISA) in Pontiac. In her message Ms. Flanery states OLHSA
wishes to make a donation of a TV, DVD/VCR and cart for use in a program she runs in our
Work Release Facility, The Oakland County Sheriffs Office has been partnering with OLHSA
for at least the last 6 years for inmate programming within the jail. Acceptance of this donation
is a way to improve the delivery of services to that population. Dale Cunningham instructed me
to contact you to process acceptance of this donation.
Please let me know if you need additional information, and any action I need to take in
processing this donation. My phone number is 975-4441,
Sincerely,
Mark W. Metalski
Chief, Jail Program Services
1201 N TELEGRAPH RD PONTIAC MI 48341-1044 • 248/858-5008
Resolution #10051 March 25, 2010
Moved by Schwartz supported by Potter the resolutions (with fiscal notes attached) on the amended
Consent Agenda be adopted (with accompanying reports being accepted.)
AYES: Burns, CapeIlo, Coleman, Coulter. Douglas, Gershenson, GingeII, GussetIn, Greimei,
Hatchett, Jackson, Jacobsen, Long, McGillivray, Middleton, Nash, Potter, Potts, Runestad,
Schwartz, Scott. Taub, Zack, Bullard. (24)
NAYS: None. (0)
A sufficient majority having voted in favor, the resoiutions (with fiscal notes attached) on the amended
Consent Agenda were adopted (with accompanying repurtb buij ki4.:(;Cp1ed.)
HEREBY APPROVE THE FOREGOING RESOLUTION
ACTM PURSUANT TO 1973 FA 139
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Ruth Johnson. Clerk of the County of Oakland, do hereby certify that the foregoing resoiution is a true
and accurate copy of a resolution adopted by the Oakland County Board of Commissioners on March 25,
2010, 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, Rchigari this 25th day of March, 2010.
Ruth Johnson, County Clerk