HomeMy WebLinkAboutResolutions - 2010.06.09 - 10153at
June 9 2010
MISCELLANEOUS RESOLUTION #10131
BY: FINANCE COMMITTEE.. TOM MIDDLETON, CHAIRPERSON
IN RE; DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2010 SECOND QUARTER
FINANCIAL FORECAST AND BUDGET AMENDMENTS
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
WHEREAS Publie Act 621 of 1978. the Uniform Budgeting and Accounting Act for Local Units of
Government, provides for adjustments to the adopted budget; and
WHEREAS in accordance with Oakland County General Appropriations Act Section 22. which authorizes
budget amendments for variances between the budgeted revenue and actual revenue, and Section 23, which
authorizes budget amendments for variance between estimated revenue and projected expenditures, amendments
are required: and
WHEREAS the Fiscal Year (FY) 2010 Second Quarter Financial Forecast Report has identifiea several
variances and budget amendments are recommended; and
WHEREAS the Circuit Court has requested a budget amendment to reappropriate the budget in various
line-items for revenues and expenditures to more accurately align with actual program expenses; and
WHEREAS revenues related to OWI (Operating While Under the Influence) cases and FOIA (Freedom of
Information Act) requests are projected to be significantly unfavorable in the Prosecutor's Office budget, as activity
has been much lower than originally projected, and a budget amendment is requested to reduce revenue by
$201.591. Expenditure budgets such as extradition and memberships will be reduced to offset the revenue
shortage: and
WHEREAS a budget amendment is requested to reappropriate $5,000 from the Prosecutor's Security
Supplies to Expendable Equipment Expense to cover the purchase of safety equipment; and
WHEREAS a budget correction is recommended to the Prosecuting Attorney's budget to recognize grant
match which was approved for the Victims of Crime Act (VOCA) Grant per MR#09217: and
WHEREAS a budget amendment in the amount of $24,000 is recommended to reappropriate funds from
the Sheriff's Patrol Servtes Division to the Sheriff's Emergency Preparedness Training & Communications Division
for Equipment Maintenance to more accurately reflect the budget where the actual expenses are incurred; and
WHEREAS a budget amendment in the amount of $4,995 is recommended to the Treasurer's Office
budget to authorize an appropriation for additional expenses incurred during transition; and
WHEREAS the Library Board is requesting a budget amendment to reappropriate Building &race
allocations and recognize updated space assignments as a result of the Library consolidation; and
WHEREAS the Water Resources Commissioner is requesting a budget amendment in the amount of
$682.368 to the General Fund buaget to reflect revenue and expenditures anticipated from the Coilaborative Asset
Management System (CAMS) Project. as well as amend various Sewage Disposal Services (SOS) Funds (58410,
58530, 58600. 58700 and 57010). due to revisions in the plans and budget for the CAMS project. Revenue and
related expenditures were budgeted in FY 2009. but due to project delay, activity is recorded in FY 2010: and
WHEREAS Personal Mileage within the County Executive's budget is projected to be unfavorable ($4,000)
due to increased usage as a result of turning in vehicles to Motor Pool, and a budget amendment is recommended
to reappropriate projected favorability from Office Supplies and Membership Dues to Personal Mileage to offset the
expense; and
WHEREAS Corporation Counsel is requesting a budget amendment totaling $4.170 to reappropriate funds
within their budget for office expenses, computer research and other misc. expenditures; and
WHEREAS the County has recently received additional supplemental funds in the amount of $8,155 from
the Hazardous Materials Emergency Preparedness (HMEP) Grant, and a budget amendment is recommended to
recognize the additional funding; and
WHEREAS the Veteran's Services Division is requesting a budget amendment totaing $3,635. to
reappropriate funds within their budget to cover Travel and Conference expense for training Veteran Counselors in
latest rules, regulations and laws pertaining to Veteran Affairs; and
WHEREAS MSU Extension originally processed registrations for the Master Gardener's Volunteer Program
directly. and Michigan State University has recently created a centralized Internet Paseo registration system, which
no longer requires MSal Extension tc process the registration or collect the fees. and therefore, a budget
amendment in the amount of $14,000 is requested to reduce revenues and expenditures to reflect this change; and
WHEREAS the Medical Examiner's Office (MEO) is requesting a budget amendment totaling $9,925 in
funds from the MEO's Memonai Fund and projected favorability in Laboratory Fees, as well as, recognize additional
revenue and expense in the Information Tecnnology Fund from the Medical Examiner's Memorial Fund to offset
expenses for updating microfilm records to digital storage: and
WHEREAS a budget amendment of $16,400 is recommended to appropriate funds for Animal Control
Division Radio Communications wnich was inadvertently omitted in the Adopted Budget: and
WHEREAS a budget amendment totaling $139_305 is recommended to reapprooriate funding within the
Circuit Count's Family Division revenues and expenditures oudget to more accurately reflect the Child Care Fund
• 4
contract with the state. Budget adjustments will increase Child Care Subsidy revenue $300.000. reduce State
Institutions ($300.000) and increase Private institutions $600.000 to reflect the significant reduction of children
placed in Private Institutions aria increase in State Wards: and
WHEREAS a budget amendment is recommended to reappropriate revenue and expenditures budgets
totaling $3.075 for the Fruits and Vegetables Grant award approved by MR#10001 from the Child Care Fund
(#20293) to grant fund (#28010).
WHEREAS projected favcrability cf 55.000 from the Children's Village Laundry and Cleaning account is
available for reappropnation to the Professional Services account to cover expenses for registered nurses
contracted through a temporary staffing agency; and
WHEREAS a budget amendment is recommended to reappropriate various line-items in the Community
Corrections Comprehensive Grant (Fund #27370) to reflect various actual program expenses within various line-
items: and
WHEREAS a budget amendment is requested by the Department of Information Technology to reallocate
$500,000 from CLEMIS-Enhanced Access Fees to CLEMIS-Crash. and $250,000 from CLEMIS - Miscellaneous to
CLEMIS-Citation for the implementation of new programs; and
WHEREAS the Parks and Recreation Commiss,on nes requested a budget amendment to recognize use of
fund balance in the amount of $1.539,717 increase Parks and Recreation Contingency by 51.800.004 for the
Information Technology Master Plan operating expenses. and reappropriate a net total of ($260,283) from Transfer
to Reserve ($550.000), Capital Improvement Program $798,122, and FA Proprietary Equipment Expense
($508,405) to appropriate for capital related expenses: and
WHEREAS authorization is requested to approve the transfer of $19,615 from the Drain Equipment Fund to
the Motor Pool Funo to replace one (1) department owned vehicle with one leased vehicle and $3.450 for Motor
Pool vehicle :ease costs charged to the Drain Equipment Fund; and
WHEREAS a budget amendment is recommended to the Sheriff's Office I Prosecutor's Office FY 2010
Highway Safety Grant Fund (#27345) to reappropriate $2000 grant revenue from the State revenue account to
Federal revenue to recognize funding source for the grant accepted per MR#10096: and
WHEREAS the Oakland County Board of Commissioners per MR #10076 authorized the extension of the
operating surcharge on telephone lines ; as defined by State statute. for the period of July 1. 2010 tnrougn June 30,
2010 to cover the operations. construction, and necessary provisions of the Radio Communications Fund in the
amount of $0,23 per line, and the FY 2011 — FY 2013 budget amendments will be included with the FY 2011 — FY
2013 budget process and
WHEREAS the Health Division received two donations from the American Lung Association of Michigan in
the amount of $500 each to provide incentives and enablers to the County's Tuberculosis Directly Observed
Therapy (TB DOT) Clients: and
WHEREAS efforts have Peen made to collect outstanding debts incurred by the County's Airport, but after
several attempts the County has had to eitner reach a settlement with a balance to write-off or deem the account
uncoilectible, and the Department of Management and Budget recommends that these accounts be written off; and
WHEREAS Miscellaneous Resoiution#09278 established the Oakland County Highland Township Well
Water Supply as autnorized by Act 342, Public Acts of Michigan 1939 with Highland Township responsible for all
project costs; anc
WHEREAS it has been determined that there are preliminary project costs that include outside design and
pre-construction engineering services that will be paid d.rectly by Highland Townsnip and some Water Resources
Commissioner services that will be paid from a $25.000 acvance from the Highland Township Well Water Fund
(#57107) to the Highland Township Weli Water Supp[y Project Fund (#26884) with both Highland Township and
Highland Township Well Water Fund to be reimbursed from bond proceeds after the bonds are sold circa late 2010.
WHEREAS Community Corrections is in the process of moving from leased space on Dixie Highway (the
current lease terminates this Fall) to Oakland Pointe, wrich has triggered a series of division moves to enhance
security and further foster economic development in Oakland County. and the total estimated cost for the division
moves is $268.992 ($33.700 from Generat Fund/General Purpose and $235,292 from other sources of funds):
• Workforce Develoornent wir be moving from Annex Ito the EOB (fourth floor). Estimated costs of $31.700
to relocate Workforce Development wil! be funded from various Workforce Development grants with actual
Project Work Order costs (e-128 Fund 40400 Project ID 100000001383) billed to Workforce Development
(29801-1090701-170010-731822-100000001382) on a monthly basis until relocation is complete.
• Fsca1Services staff located on the fourth for of the EOB will be shifting locations on the fourth floor for
Workforce Development. The estimated moving costs of $2,000 will be charged through normal
Maintenance Department Charges.
• The Federal Commerce Connect program will place five new employees with the Export Center staff. Both
the Commerce Connect and the Export Center will be moving into the space vacated by Workforce
Development at Annex I. The estimated costs of $111,427 to relocate Export Center staff will be billed on a
monthly basis to the International Trade Administration/U.S. Department of Commerce based on actual
Project Work Order costs (e-129 Fund 40400 Project ID 100000001384).
A
• The Sheriff's Office Drug Program will be moving from leased space on Dixie Highway into the space
vacated by the Tax Tribunal at Oakland Pointe West. Since Community Corrections is already in the
process of moving from Dixie Highway to Oakland Pointe, having the Sheriff's Office presence adjacent to
their operation will enhance security. The estimated cost of $117,310 will oe funded from the existing
Community Corrections Relocation Project (c-065 Fund 40400 Project I D 100000001288/insurance
reimbursement).
• The Tax Tribunal will be moving within Oakland Pointe West to the space vacated by the Export Center.
The estimated costs of $6 555 assnniated with this will be funded from trie existing Community Corrections
Relocation Project (c-065 Fund 40400 Project ID 100000001288/insurance reimbursement).
NOW THEREFORE BE IT RESOLVED that the Board of Comuisstoners—a.c-cer, ;Xs the Fiscal Year 2010
Second Quarter Financial Renort.
BE IT FURTHER RESOLVED that the FY 2010 Budget be amended pursuant to Schedules A and B.
BE IT FURTHER RESOLVED that tne Oakland County Board of Commissioners approves the transfer of
$4,541.35 from the Medical Examiner's Memorial Fund #21370 to the General Fund to close-out the fund.
BE IT FURTHER RESOLVED that donations be ciuuepted flurfi the American Lung Association of Michigan
to the Healtn Division
Chairpersor, on behalf of tne Finance Committee. I move the adoption of the foregoing resolution.
F:NANCE COMXITTEE ')CTE:
Mticn carried unanimo=17 cn a fon call vote
(17 CE COMMITTEE
0-L-P4 r
S (1,387,176)
3,319,776
$1,932,600
$ 25,339,053
( 19,463,004)
5,876,049
$ 7,808,649
Revenues - over./(under) budget
Expenditures — (over)/under budget
Total Officially Reported Pavorability
S( 1,387,176)
25.339,053
E2
111
OAKLAND
COUNTY MICH GAN
L. BROOKS PATTERSON, OAKLAND COUNTY EXECUTIVE
Laurie Van Pelt, Director
Wm. Art Holdswolh, Deputy Director DEPARTMENT CF mANA3EVEN" AND a LOGE-7
TO: Members of the Finance Committee
FROM: Laurie Van Pelt, Director, Management and Budget
Tim Soave, Manager, Fiscal Services
Nancy Fournier, Chief, Fiscal Services
La Verne Smith, Supervisor of Fiscal Services
SUBJECT: Letter of Transmittal - Fiscal Year 2010 Second Quarter Report
DATE: May 11, 2010
FY 2010 SECOND QUARTER REPORT
Attached please find the F i scal Year (FY) 2010 Second Quarter Forecast Report. In total, Fiscal Services forecasts that
the County will complete Fiscal Year 2010 with overall favorability of $7,808,649 in General Fund / General Purpose
(GFIGP) operations. GFIGP includes all operations except grants, enterprise funds and internal service funds. This
overall favorability is split between receiving $1,932,600 more revenue than anticipated and projected favorability in
expenditures of 55,876,049.
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)
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 General:y
Accepted Accounting Principals (GAAP). The variances, if presented purely according to GA AP would be:
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).
1. The amended revenue budget assumed the use of S3319,776 in fund balance. Although use of fund balance
was budgeted. GAAP does not allow fund balance to be "recorded as revenue" creating a negative variance
because :evenue is budgeted (anticipated), but not received (recorded). The required presentation ignores
that the County planned to use fund balance; in reality there is no negative variance.
2. Likewise, on the expenditure side, the budget included a planned positive variance of S19,463,004 which
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.
lEKECUT1VE OFFICE BUILDING 41 WEST • 2100 PONTIAC LAKE RD DEPT 409 • WATERFORD MI 49329-0409 • 248)8S8-21G3 • FAX (248} 452-9172 1
EMAIL: vanpelti@oakgov corn
A
REVENUES
GFIGP revenues are 0.47% more than budget or $1,932,600. The majority of the favorability is the result of the
following events:
A. TAXES - Favorable: $1,947,600
• Although the budget estimated a decline in taxable values, the decline for FY 20:0 is now expected to be less
than the projection used for the FY 2010 Adopted Budget. The forecast assumes a 12.25% reduction font FY
2009 taxable values.
B. CHARGES FOR SERVICES - Favorable: $405,000
• Children's Village is forecasted with $500,000 favorability mostly due to Board and Care revenue.
• Revenue for the Water Resource Commissioner is forecasted favorable $568,300 in reimbursement General
which is offset by unfavorable personnel costs in the General Fund for project related costs recovered thru cost
centers.
• District Court revenues are forecasted unfavorable ($560,000) due to a reduction in collections for multiple
accounts. Note that Revenues for the 52 nd District Court in Novi are forecasted $340,000 favorable with all
other courts forecasted unfavorable.
C. STATE GRANTS - Unfavorable: ($745,800)
• Reduced state funding is the result of reduced costs for the Child Care fund and increased Board and Care
revenue. The projected revenue loss is more than offset by projected reduced expenditures for Private
Institutions and other Child Care fund costs.
EXPENDITURES
In total, expenditures are projected to be 1.42% under budget or $5,876,049. Note that this favorable forecast includes
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 favorability may increase 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 Sheriff's Office, Water Resources Commissioner, and Central Services.
A. Sheriffs Office — Unfavorable: $(1418,300)
a The department is forecasted unfavorable mostly due to salaries and fringe benefits related to overtime and
holiday overtime. Overtime is used to cover vacancies and annual leave. Holiday overtime is unfavorable due
to arbitrator awarded salary increases.
B. Water Resources Commissioner — Unfavorable: $(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
with the quarterly forecast. Project related revenue and expenditures were budgeted in FY 2009 but due to
delay, the actual revenue and expenditures are recognized as FY 2010 activity.
C. Central Services — Unfavorable; $(12,100)
• Unfavorable personnel costs due to budget calculation error for retirement and FICA partially offset by
favorable Internal Services.
Expenditures
4010101
4010101
4010101
4U10101
tIL110101
122050
122050
122050
122050
122050
730688
/30695
730730
731213
731220
121100 750049 Business Div - Computer Supplies
121240 750049 Family Division - Computer Supplies
135060 750049 Family Division - Computer Supplies
121130 750049 Civil/Criminal - Computer Supplies
121130 732081 -Visiting Judge
121100 732081 Business Division - Visiting Judge
121240 731458 Family Division - Professional Services
135060 731458 Family Division - Professional Services
121260 731458 Family Division -Professional Services
112700 788001 20293 Non-Dept - Transfer Out to Child Care Fund
Total Circuit Court Expenditures
Expenditures
3010201
3010403
3010402
3010301
3010301
3010201
3010403
3010402
3010402
9010101
Prosecutor's Office
Revenues
4010101 122050
40'10101 122050
631827 Reimbursement - General
670285 Enhancement Funds
Total Prosecutor's Office Revenues
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2010 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND1GENERAL PURPOSE (GF/GP)
FY 2010
AMENDMEN I S
IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS
GENERAL FUND (#10100)
Dept Program Acct
Circuit Court / Non-Departmental
Revenues
3010101 121100 631010
3010301 121100 631010
Fund Aft. Account Name
..11.1(1 AcImin - Judge Online Revenue
Civil/Criminal - Judge Online Revenue
Total Circuit Court Revenues
Expert Witness Fee and Mileage
Extradition Expense
Filing Fees
Membership Dues
Microfilming and Reproductions
(3,000.00)
3,000.00
6,500.00
(1,500.00)
(1,000.00)
(4,000.00)
(85,000.00)
85,000.00
10,000.00
10,000.00
60,348.00
(80,348.00)
(80,000.00)
(121,591.012)
$ (201,591.00)
(5,591.00)
(75,000.00)
(8,000.00)
(13,000.00)
(15,000.00)
process of moving from Dixie Highway to Oakland Pointe, having the Sheriffs Office presence adjacent to
their operation will enhance security. The estimated cost of $117,310 will be funded from the existing
Community Corrections Relocation Project (c-065 Fund 40400 Project ID 100000001288/insurance
reimbursement).
• The Tax Tribunal will be moving within Oakland Pointe West to the space vacated by the Export Center.
The estimated costs of S6,555 essnninted with this will be funded from the existing Community Corrections
Relocation Project (c-065 Fund 40400 Project ID 100000001288/insurance reimbursement).
NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year 2010
Second Quarter Financial Report.
BE IT FURTHER RESOLVED that the FY 2010 Budget be amended pursuant to Schedules A and B.
BE IT FURTHER RESOLVED that the Oakland County Board of Commissioners approves the transfer of
$4,541.35 from the Medical Examiner's Memorial Fund #21370 to the General Fund to close-out the fund.
BE IT FURTHER RESOLVED that donations be accepted from the American Lung Association of Michigan
to the Health Division.
Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution.
FINANCE COMMITTEE
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2010 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GFiGP)
FY 2010
AMENDMENTS
IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS
(20,000.00)
(25,000.00)
(30,01)0.00)
(10,000.00)
(5,000.00)
5,000.00
(201 591.OQ)
4010101 122050 731346 Personal Mileage
4010101 122050 731388 Printing
4010101 122050 731458 Professional Services
4010101 122060 732018 Travel and Conference
4010101 122050 750490 Security Supplies
4010101 122050 750154 Expendable Equipment Expense
Total Prosecutor's Office Expenditures
Sheriff's Office
Expenditures
4030601 110000
4030501 1162 30
730646 Patrol Svcs - Equipment Main!.
730646 Erner Prop Trrg & Comm - Equip. TVIaint.
Total Sheriffs Office Expenditures
(24,000.00)
2400000
Non-Departmental / Prosecutor's Office
Expenditures
9090101 196030
4010201 135170
4010101 135 170
730800 Non-Dept - Grant Match
730695 Prosecutor - Extradition Expense
788001 27325 Prosecutor - Transfer Out to VCCA Grant
Total Expenditures
(10,300.00)
(10,896.00)
21.196.00
_
-4
Treasurer's Office
Lxoendtures
7010101 182025 731990
1010101 186040 775754
Library Board 1 Non-Departmental
Expenditures
6010302 1650 20 770631
5010301 165 000 770631
5010301 165 0 10 770631
5010303 165 040 /0631
911O161 1.48050 770631
Treasurer - Transition Expense
Treasurer - Maintenance Dept Charges
Total Treasurer's Office Expenditures
Law Library - Bldg Space Cost Alloc
Reference Library - Bldg Space Cost Akio
LVPI - Bldg Space Cost Alloc
Lib Bd Admin - Bldg Space Cost Moo
Non-Dept - Bldg Space Cost Moo
Total Library Board Expenditures
(4,995.00)
4,995.00
$ (359,925.00)
(118,461.00)
(205,163.00)
492,326.00
191,2 14.00
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2010 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2010
AMENDMENTS
IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS
GENERAL FUND #10100 (Continued)
Water Resources Commission (WRC)
Revenues
5010101 1550 .10 631827 Reimbursement - General
Total WRC Revenues
682,368.00
682,368.00
xpeneitures
6010101 155010 702010 Salaries $ 366,311.00
6010101 155010 722740 Fringe Benefits 189,866.00
6010101 155010 771639 Drain Equipment 126,185.00
total WRC Expenditures $ 682,388.00
County Executive - Administration
Expenditures
)010 .101 181000 /31346 Personal Mileage $ 4,000.00
1010101 181000 150399 Office Supplies (2,000.00)
1010101 181000 731213 Membership and Duos (2.000.00)
Total County Exec Admin Expenditures
County Executive - Corporation Counsel
Expenditures
1010501 181020 730338 Computer Research Services $ (3,000.00)
1010501 161020 731213 Membership and Dues 500.00
1410501 181020 731241 Miscellaneous 200.00
1010501 181020 731339 Periodcals nooks Public:aliens 500.00
1010601 181020 731346 Personal Mileage (580.00)
1010501 181020 731458 Professional Services (590.00)
1010501 181020 750049 Computer Supplies 882.00
1010501 181020 750154 Expendable Equipment 500.00
1010501 181020 750399 Office Supplies 1,488.00
1010501 181020 750488 Postage-Standard Mailing 100.00
Total Corporation Counsel Expenditures $
0%a
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2010 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2010
AMENDMENTS
IGFIGP OPERATIONS - SELF BALANCING AMENDIVIEN IS
GENERAL FUND #10100 (Continued)
HHS - Homeland Security Division I Non-Departmental
Revenues
1060601 112195 610313 Homeland Security Div - Fed °per Grants S 8,155.00.
13,155.00 Total Revenues
Enenditures
9090101 196030 730359 Non-Dept - Contingency
Total Expenditures
8,155.00
$ 8,155.00
Public Services - Veteran's Services
Expenditures
1070301 '132050 731818 Vets Client Svcs - Special Event Program $ (3,635.00)
1070301 1320 50 750399 Vets Client Svcs - Office Supplies 1,485.00
1070301 1320 70 732018 Vets Staff Dev - Travel & Conference 2,150.00
Total Veterans Svcs Expenditures $
Public Services - MSU Extension
Revenues
1070510 174120 631827 MSU Ext. Master Gardner - Reimb General $ (14,000.00)
Tota MSU Revenues $ (14,000,00 )
Exnendtures
1070510 114120 732165 NASU Ext. Master Gardner - Wrkshops & Mtgs $ (14,000.00)
Total IVISU Expenditures $ (14,000.00)
Public Services - Medical Examiners Office
Revenues
1070601 132 0 30 695500 21370 'Transfer In from ME Memorial Fund 4,541.00
Total MEO Revenues 4,541.00
ExPeorlitiges
1070601 132030 731031 MEC Services -Laboratory $ (5,384.00)
1070601 132030 788001 63600 rulE0 Sevices - Transfer Out to IT Fund 9,925.00
Total MEO Expenditures $ 4,541.00
,$)
Non-Deptartmental / Public Services - Animal Control
Vxpendituros
9C10101 196030 740023 Non- Dept - Budget Transition
1070801 114100 777560 Animal Control - Radio Communications
Total Expenditures
Non-Departmental
Expenditures
9010101 152010
9010101 152010
786001 63600 Transfer Out to Info Tech Fund
788001 53500 Transfer Out to CLEMIS Fund
Total Non-Dept Expenditures
CHILD CARE FUND (#20293k
Non-Departmental / Circuit Court - Family Division
Revenues
9010101 112/00
9090101 112700
615359 Non-Dept - Child Care Subsidy
695500 10100 Transfer in from General 1-und
Total Child Care Fund Revenues
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2010 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2010
AMENDMENTS
IG1-?GF OPERATIONS - SELF BALANCING AMENDMENTS
GENERAL FUND #10100 (Continued)
Exoenditure.s
3010402
3010402
3010402
3010402
3010402
3010402
3010402
.30.10402
1J l04)2
11257(1
135110
121200
121200
121200
1351 20
135120
135120
135120
131843
731416
730926
731458
750280
730926
750539
/31458
730226
Circuit Court - State Institutions
Circuit Court - Private Institutions
Circuit Court - Indirect Costs
Circuit Court - Professional Services
Circuit Court - Lab Supplies
Circuit Court - Indirect Costs
Circuit Court - Testing Materials
Circuit Court - Professional Services
Circuit Court - Car Allowance
(16,400.00)
16,400.00
(59,000.00)
59,000.00
$ 219,653.00
(80,348.00)
139,305.00
$ (300,000.00)
600,000 00
(1,710.00)
(5,970.00)
(37,000.00)
(72,395.00)
25,000 00
(17.2,652.30)
16,000.00
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2010 SECOND DUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GP/GP)
FY 2010
AMENDMEN IS
ICF/GP OPERATIONS - SELF BALANCING AMENDMENTS
3010402
3010402
3010402
113310 731458 Circuit Court- Professional Services
113310 731346 Circuit Court - Personal Mileage
113310 730926 Circuit Court - Indirect Costs
Total Child Care Fund Expenditures
69,852.00
24,200.00
(6,9241o3D
139,305. 00
$ (3,075.0C)
$ _0,075.00)
HI-Is Childrens Village Division - Fund #20293
Revenues
1060501 112195 610313 Federal Operating Grants
Total Children's Village Revenue
Ea< enditures
1060501 112195 750462 Provisions $ (3,075.00)
1060501 196030 730359 Laundry and Cleaning (5,000,00)
1060501 196030 731458 Professional Services 5,000.00
Total Children's Village Expenditure $ (3,075.0C))
41,
ACCOUNT NUMBER
FY 2410
AMENDMENTS
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2010 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY SPECIAL REVENUE FUNDS
'PROPRIETARY f SPECIA1 REVENUE FUNDS - SEt I- BA L ANCING AMENDMENTS
Dept ID Program Acct Fund Aff Oper Unit Account Name
Community Corrections Comprehensive Grant Fund #27370
Grant Detail - GR #0000000093; Activity - Agencies
Expenses
' 07 ti 13000
• 07 • 1 ' 13000
' 07 • " 13020
' 07 . i' ' 13020
' 07 A ' ' 13035
1 ' 13035
" 0/ i '
• 07 • I ' ' 23010
07[
i 23010
13000 702010
722740
7020 0
770631
7227 0
7020 0
7227 0
7020 0
7227 0
Comm Corr Adm - Salaries
Comm Corr Adm - Fringe Benefits
Comm Corr Adm - Bldg Space Rental
PTS Super-vision - Salaries
Electronic Monitoring - Salaries
PTS Supervision-Fringe Benefits
Electronic Monitoring - Fringe Benefits
D strict - Salaries
$
249,055.00
(16,314.00)
(38,769.00)
(30,296.00)
20,604.00
10,325.00
(8,451.00)
(27.00)
0 strict - Fringe Benefits 35,906.00
' 070 • ' •13120 7020 0 S.7 Sub Abuse Scr/Asse.ss - Salaries (6,800.00)
' 070 6" 13120 7227 0 S = Sub Abuse ScrfAssess - Fringe Benefits (10,757.00)
' 070. I' ' 13120 7303 3 SI". Sub Abuse Scr/Assess-Contracted Svcs 27.00
' 070. • ' ' 13130 702010 S = Case Mgrrit - Salaries 88,279.00
• 070.1," 13130 722740 S= Case Mgmt - Fringe Benefits 5,152.00
070 ' '' 13140 702010 S= Results-Salaries (12,873.00)
' 070 , 6 - 13140 722740 S = Results - Fringe Benefits (14,95.4.00)
1070401 113150 702010 Ouil III Case Mgmt - Salaries 11,273.00
'10/0401 113150 722740 °LOW Case Mgmt - Fringe Benefits 10,351.00
1010401 113185 730373 Drunk Driving Res - Contracted Svcs 334,089.00
1070401 113190 730373 Community Programs - Contracted Svcs (293,537.00)
1070401 112650 702010 Corr Support Svcs , Salaries 16,399.00
1070401 112650 722740 Corr Support Svcs - Fringe Benefits (43,916.00)
1070401 112652 1/02010 Corr Support Training - Salaries (185,863.00)
1070401 112652 722740 Corr Support Training - Fringe Benefits (163,886.00)
1070401 112051 702010 Corr Support Education - Salaries 19,419.00
1070401 112651 722740 Corr Support Education - Fringe Benefits 25,504.00
Total Comm Corr Grant Exp.
iii
FY 7010
AMENDMENTS ACCOUNT NUMBER
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2010 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY I SPECIAL REVENUE FUNDS
PROPRIETARY / SPECIAL REVENUE FUNDS - SEL F BALANCING AMENDMENTS
1_
I
Dept ID Program Acct Fund Aff Oper Unit Account Name
Information Technology - CLEMIS Fund #53500
Revenue
1080305 116026 630637 Access Fees $ 500,000.00
1080305 1 't6026 630263 CLEMIS Crash (500,000.00)
1060305 116025 631253 Miscellaneous 250,000 00
1080305 116025 630262 CLEMIS Citation (250,000.00)
Total CI EMIS Fund Revenues
Information Technology Fund #63600
Revenues
10801{11 152000 695500 10100 Transfers In From General Fund (MEO) 9,925,00
9,926.00
L.2_pk
1080201 152010 730373 Application Sys - Professional Services 9,925.00
Total Info Tech Fund Expenses 9,925.00
Total Change in Fund Equity - IT Fund
Parks and Recreation Commission - Fund #50800
Expenses
5060201 160000 730359 Contingency $ 1,800,000.00
5060201 160000 731969 Transfer To Reserve (550,000.00)
5060201 160000 740030 Capital Improvement Program 798,122.00
5060201 160000 150168 FA Proprietary Equipment Expense (508,405.00)
Total P&R Comm Expenses $ 1,539,717.00
Total Change in Fund Equity - P& R Fund $ _., (1,539,717.00)
Drain Equipment Fund #63900
Revenues
6010101 149750 632401 26466 Vehicle Rental 3,450.00
Total Drain Equipment Revenues $ 3,450.00
Expenses
6fti ClOi 149750 776661 26466 Motor Pool 3,450.00
6010101 149750 788001 26466 66100 Transfer Out to Motor Pool Fund 19,615.00
Total Drain Equipment Expenses $ 23,065.00
Total Change ill Fund Equity - Dra]n Equip (19,615.00)
Total Info -Tech Fund Revenues
k.)3
ACCOUNT NUMBER
FY 2010
AMENDMENTS
(47,766.00)
(25,642.00)
(13,291.00)
(8.833.00)
(47,766.00)
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2010 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
1PROPRIETARY I SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Aft ()per Unit Account Name
Motor Pool Fund #66100
Revenues
1030611 184010 631071 leased Equipment 3,450.00
1030811 184010 695500 63900 Transfer In From Drain Equipment Fund 19,615.00
Total Motor Pool Revenues S 23,065.00
Expenses
1030811 184010 761156 Depreciation Vehicles $ _ , _ 3,450.00
Total Motor Pool Expenses $ _ 3,450.00
Tot Chng in Fund Equity - Motor Pool Fund $ 19,615.00
Sewage Disposal Systems (SDS) Fund #58410 - Evergreen Farmington
Revenues
6010101 149030 632086
Total SDS Fund #58410 Revenues $ (49,664.0q)
EDenses
6010101 149030 702010 Salaries {25,642.00)
6010101 149030 722740 Fringe Benefits (15,169.00)
6010101 149030 771639 Drain Equipment
Total SDS Fund ff58410 Expenses $ 49,664.00)
Total Change in Fund Equity - EFSDS
Sewage Disposal Systems (SDS) Fund #58530 - Southeastern OC
Revenues
6010101 149030 632086 Sewage Disposal Services
Total SDS Fund 1158530 Revenues $ (47,766:DO)
Sewage Disposal Servir,es (10,664.00)
Expenses
6010101 149030 702010 Salaries
6010101 149030 722740 Fringe Benefits
6010101 149030 771639 Drain Equipment
Total SDS Fund #58530 Expenses
Total Change in Fund Equity - SOCSDS
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2010 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY/SPECIAL REVENUE FUNDS
AC,COUNT NUMBER
FY 2010
AMENDMENTS
'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Aff Oper Unit Account Name
Sewage Disposal Systems (SOS) Fund #513600 - Clinton Oakland
RE VMUCS
6010101 149030 632086 Sewage Disposal Services (34,118.00)
Total SOS Fund #58600 Revenues $ (34,118.00)
Exf?..e.nses
6010101 149030 702010 Salaries (18,316.00)
6010101 149030 722740 Fringe Benefits (9,493.00)
6010101 149030 771639 Drain Equipment
Total SDS Fund #58600 Expenses $ (34,118.09)
iota! Change in Fund Equity - COSOS $
Sewage Disposal Systems (SDS) Fund #58700 - Huron Rouge
Revenues
6010101 149030 632086 Sewage Disposal Services (6,624.00)
Total SOS Fund #58700 Revenues $ (6,824.00)
Enleriqs
6010101 149030 702010 Salaries $ (3,663.00)
6010101 149030 722740 Fringe Benefits (1,899.00)
6010101 149030 771639 Drain Equipment (1,262.00)
Total SOS Fund #58700 Expenses $ (6,824.00)
Total Change In Fund Equity - HRSDS $ -
Sewage Disposal Systems (SIDS) Fund #57010 - Water and Sewer Trust
Revenues
6010101 149000 632086 Sewage Disposal Services $ (271,998.100)
6010101 149030 632450 Water Sales General (271,998.00)
Total SOS Fund #57010 Revenues $ (543,996.00)
Expenses
0010101 149030 702010 Salaries $ (293,054.00)
6010101 149030 777740 Fringe Benefits (149,994.00)
6010101 149030 771639 Drain Equipment , (100,94800)
-total SDS Fund 457010 Expenses $ _ 043,996.00)
Total Change in Fund Equity - W&S Trust $ -
c.1\
FY 2010
AMENDMENTS ACCOUNT NUMBER
3,075.00
3,075.00
Fxpenes
1060501 112195 750462 Provisions
Total Child Care Grants Exp. $
Total Change in Fund Equity - Child Care Grnt $
3,075.00
3,075.00
(59.,000.00)
09,000.00
REVISED
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2010 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY SPECIAL REVENUE FUNDS
'PROPRIETARY f SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Aff Over Unit Account Name
Highway Safety Grant Fund #27345 - Project #GIR0000000332
Revenues
4030601 110000 615571 Sheriff - Grants State $ {2,000.00)
4030601 '110000 610313 Sheriff- Grants - Federal 2,000.00
Total Highway Safety Grant Rev. $ .,., :.—
Child Care Grants #28014
Revenues
1060501 112195 610313 Federal Operatng Grants
Total Child Care Grants Rev.
Radio Communication Fund #53640
Revenues
1080310 115060 630581 E-911 Surcharge 256,250.00 00
"Total Radio Comm Fund Rev 250,250.00
Expenses
1080310 115060 731780 Software Support Maintenance $ 73,000.00
1080310 115060 730324 Communications 123,500.00
1080310 115060 730645 Equipment Maintenance 16,250.00
1080310 115060 788041 63600 Transfer Out to info Tech Fund 59,000.00
Total Radio Comm Fund Fxp $ 271,750.00
1080310 115060 665882 Total Change in Fund Equity - Radio Comm $ (15,500.00)
Information Technology Fund #63600
Revenues
1080101 102000 695500 10100
1080101 152000 695500 53600
Transfer In froin General Fund
Transfer In from Radio Cornm Fund
total Info inch Fund Rev
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2010 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY I SPECIAL REVENUE FUNDS
FY 2010
ACCOUNT NUMBER AMENDMENTS
FPROPRIEIARY SPECIAL REVFNUE FUNDS - SEI F BALANCING AMENDMENTS
Dept ma Program Acct Fund Aft Oper Unit Account Name
CLEMIS Operating Fund #53500
Revenues
1060305 116020 695500 10100 Transfer In from General Fund
Total CLEMIS Fund Rev
1.
59,000.00
$ 59,000.00
Expenses
1080365 116020 731780 Software Support Maintenance $ (73,000.00)
1080305 116020 730324 Communications (123,500.00)
1080305 116020 730646 Equipment Maintenance _ '16,250.00)
Total CLEMIS Fund Exp $ _ Lq12,r5o.00)
1080314 115060 665882 Total Change in Fund Equity - CLEMIS $ _. 271,754.00
P•La.NNED LSE Cr LIND SA',..ANCE 150 000.00 $ 3,319_775.15 5 3,319,776.15
TOTAL GF:GP FUNDS $ 409.2,35.935.00 $ 412,440,615.15 5 414,373,235.15 3 1,932,500.00 0
TOTAL GOVERNMENTAL EXPENDITURES $ 409.835.938.00 5 412.440,615.15 $ 408,564,566,15 $ 5.576.049 00
•
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMAFRY BY DEPARTMENT
2013
AZXPTED
3,...1DGET
BUDGE7
AS
AMENDED
FY 2013
FORECAST
AMC.INT
FAVORAELE,',
:„.1NFAVQRAE.:L pLFLE
REVENUES
Taxei
Fede%iiGrI
State L;reon
Othe: ;n1efg0,..e7me-7.toRocnLe
-Dnarges for Sen., ces
:r.frec*,0001 Recovery
.rvestrneTt
Oher Re.ve71,:e:>
SUB-TOTAL GENERAL FUND/GENERAL PURPOSE It.
218,302,555.cc $ 275,302,555.00
687.675.0C 690,750.33
Y9 :26.244.06 18.609,180.03
:251,944.0t 11,2E1,944.00
94:149.466.30 83,21C,425.0
5,017,499.00 9,0E3,032_00
2,731,800.00 2,76 1 .500.00
64,576.753.00 62,031.163.00
220 :253.155 Jo
6130.550.30
8.063,350.30
11,261,944.30
83,610,425.30
9,303,:12.00
2,750.403 OC
55.145.293 03
$ 1,047,603.23 C
(.29,90; 331-..
(745,803.00)
4:5
250300.63
1"
$ 1 932 600 409,535,93533 5 439 120.939 CO 5 4 1 -1 .053.4 .00
EXPENDITURES
ACI,„; 1,,i1S-R.a.", ION OF ,(25TIGE
Ceurt
52'c Dibli1C1 C01.111.
P77uCate Ci
TOTA_A1..N.1!IN. OF JUSTICE
ENFORCEMEN7
F-0$6.cs.:71g Av:tc"ne.y
10-4L LAVV EN,F'09CEME7
GENERAL GOVERNMENT
.-.:;;e•KiRester of Daecs
Treasver
Scam of Co77.7.5;one's
Library. ED.ar0
Water e5c,:rfoes
T0TAL.1.;ENERA_ GOVERNMENT
CCUN7Y EAECLTIVE
Cc%/11); Executive Admr.
Maragemal 07%1 a,0,3eZ
CerTai f:lervLes
Facjities Maragemerr
RescAirces
!lear,h ana Hurian Servoes
Fb,iStv.vic8s
De.v. 2r zlrTIIll A!-VTS
TO-A- 2 OL,N7Y
TOTAL DEPARTMENTS
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NON-DEPARTMENTALS
$ '37.1393.00
!0,021.852
6,11822230
$ 73.g 7.767 00
18.038 215.00
22.698.361.00
$ 141.536.6'600
,538,251.00
5,503,775 00
2,077.944 00
,S32,861.03
5,312:346.30
20 175.177.00
$ 6.14C 464 CO
19.512.002.00
2.072 180.00
1.289.240 CC
4," 33,433 30
01.353,220.30
15,03" .024.33
7.289,434.30
$ 20.421 602:73
52.375580.00
16,164 756 00
6,137 842.00
$ 74,878 478 60
18.9q9,086,43
122.942,246.87
5 141 .941 333.27
11.675,784.50
3.814,761.04
2.915,716.00
3.930656.02
5,477.883.00
S 25.829,00.o4
S 6 201:708 CO
20 277 351 00
2.1' 1i,05.0)
1,250,517.20
4 229,400 CC
56.596,758 84
'5.693.930 50
7,630:246.00
$ 124.156,048.34
$ 50447,550 30
15_897,956_00
6.059442.00
$ 72.435.2(5.03
18.223.586.40
24 060.546.87
$ 142,284,133.27
11,332,23450
3,801 701.04
2.914 216 30
1.004.896 30
16c 251 30
20.053.400 54
5 6,180,035.03
19,692,351.00
2,123,145 00
1,189,6 7.03
4,042,5013.00
6-1,315,309.84
15.37" .124,50
7.19 CC
S 120 136.031 34
$ 3613.935.853.1.5
$ 1,925.30270: 3.6$.
266.800 CC
48.4;c.
$ 3
775.5%' 4
(1,115 L:(;)
(342,500 -C
376,500 3 222
' 3.003273 3
4,50
3CO3 02
(052.368 0..7)
(254.308 0C)
21 7 02.Cti
5500233.36
(12:
00
156 q:..J
2,351,4:1.) „3
2
497300.03
5 4.620 7
120 C
$ 361.'51,162_03 9 360634.902 15
5 48.654.776 (X 9 45.805.71503 40.655.7 5.33
'3enf:;-a . Fkr::.'Ove!.& Pripcse
7,808,649.00 7,8013.641.00
;1; N-cie that report 0cc301.0 7.f311ce3 of Funo Eal.ance wIn 3 7013 varialct C%ler IC slow a 044n0060 nJaget„ No reven,.:E; acwaH!..
$ 217,998,055.00 $
98,500.00
120.000.00
88,000 On
S 210,202,555.00 $
68,000 00 5
112,000 00
169.947.00
217,996,055.00 $
98,500.00
120,000.00
88,000.00
218,,302.,555.00 $
68,000.00
82,000 00
169,94/.00
219,947,855.00 $
98,500.00
120,000.00
84,000,00
220,250,155.00 $
68,000 00 $
82,000.00
95,047.00
1,951,non no
(4,000.U0
1,947,600,00
(74,900.00 t
46,000.00
21,728.00
300,000.00
46,000.00
21;728.00
303,075.00
46,000.00
21,728.00
348,075.00 45,000.00
687,675,00 $ 690,750.00 $
-
1,000.00
169,947.00
9,525.00 $
1,000.00
169,947 00
9,525.00 $
1,000.00
95,047.00 (74,900.00)
4,882,410.00
14.072,887.00
4,557,821.00
14,070,887.00
4,55 T,821.00
13,3937.30 (670,900.00)
19,126,244.00 $ 18,809,180.00 $ 18,063,380.00 $ (745,800.00)
8,940,000.00 $ 8,940,000.00
54,900.00 54,000.00
4,500.00 4,500.00
2,750.00 2,750.00
300,000.00 300,000 00
.960,694.00 1,260,694 (10
11,261,944.00 $ 11,261,944.00 $
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FY 2010 SECOND QUARTER REPORT
Adopted
Budget
Amended
Budget
FY 2010
FORECAST
Amount
Favorable
(unfavorable) Percent Explanation of Significant Variances
TAXES (601000-601909)
Property Taxes - July Tax Levy
Other Taxes - Delinquent fax - Prior Years
Treasurer Payment in Lieu or laxes
Other Taxes - Trailer fax
Total Taxes
FEDERAL GRANTS (610000-610999)
Sheriff - Patrol
Sheriff. Corrective Services
Prosecuting Attorney
Homeland Security - Disaster Control
Health Division
Children's Village
Total Federal Grants
STATE GRANTS (615000-615999)
Sheriff - Patrol
State Match Foster Care
Prosecuting Attorney
Econ Development
Health Division
Non-Departmeritai - Child Care Subsidy
Total State Grants
0 90% Drop in Taxable Value was less than anticipated.
0.00%
0.00%
0.69%
0.00%
0.00%
-4.4.07% Revenue from State DtiS for assistance in prosecuting child
abuse and neglect cases currently delayed clue to
cumpliance issues will] Stale requirements, which the
Prosecutor is working to attain.
0.00%
0.00%
14.85% Increase in revenue reimbursed for the school lunch
program due to increase in population at Children's Village.
0.00%
0.00%
-44.07% Revenue from State DNS for assistance in prosecuting child
abuse and neglect cases currently delayed due to
compliance issues with State requirements, which the
• Prosecutor is working to attain.
0.00%
0.00%
-4.77% Unfav. Variance is offset by Child Care Fund expenditure
favorability Ruilt into the Circuit Court Family Division,
Health Administration, and Children's Village E3udgets are
Child Care Fund expenditures. A favorable variance within
these areas reduces the 50% reimbursement the county
receives.
-3.97%
660,850.00 $ (29,900.00) -4.33%
OTNER INTER-GOVERNMENTAL REVENUES (620000 - 626999)
Non-Departmental
tit tS - Homeland Security
Circuit Court
District Court
Sheriff
Non-Departmental - Reim Judges Salaiiet;
otal Other Intergovernmental Revenue
C-HARGES FOR SERVICES (630000-635999)
Administration of Justice
•Re'ofmue variance is parti2.1Iy oilset by au expenditure variance.
8,940,000.00
54,000.00
4,500.00
2,750.00
300,000.00
1.000,09408
11,261,944.00
7a-
Amount
Adopted Amended FY 2010 Favorable
Budget Budget FORECAST funfavorable)
5 3,000.00 5 3,000.00 S 3,000.00 $
3,050,500.00 3,050,500.00 3,050,500.00
2,017,650.00 2,917.650 00 2,011,650.00
4,293,505.00 4,2U3,565.00 4,633,565 00
Circilit Court - Judicia&Administralion
Circuit Court - CivplJCriminal
Circuit Court - 1- arery Division
EIStFiCt Court L Division I (Novi) 340,000 00
District Court - Division II (Clarkslen) 2,321,056.00 2,321,056.00 1.981050.00 (340,000 00)
1)..stric1Court • Division III (Rochester Hills)
District Court - Division IV (Tioy)
E'retate Court • E: states and Mrntre F leaith
4,541,209.00 4,171,209 00 (370,000 00) 4,5.41,209.00
2.418,079.00 (190,000.00) 2,228,079 00 2,418,079.00
S66.300.00 (41.,(A)0.0e) .`125„3 00.00 566,300.00
Total AdMstistration of Justice IP211,359 00 S 19,211,359 00 $ 18,610,3!)9.00 $ (601,000.00)
COUR I Y OF- OAKLAND
GENERA! FUND 1 GENERAL PURPOSE REVENUES
FY 2010 SECOND QUARTER REPORT
Percent Explanation of Sianificant Variances
0..00%
0.00%
0.00%
1.92% lay. variance due to the cart's increased 'Fines and Costs
schedule. Garnishment fee revenue and caseload increase.
During 2009 the 52nd District Court implerrienteci a new
fines and costs schedule. the new schedule combined with
an increase in caseload has improved their revenue
collections.
-14.65% Unfav, variance due to a reallocation of slate law
enforcement resources and a decrease in defendarit6 . anitity
to pay. In July of 2009 a State Police post's resource.s wore
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 cur itributcd to the decline in
court revenue. The District Court's 2010 budget task
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. Management and Budget requested the court
submit plans to replace the last revenue shortage. The
court will be requesting approval of these plans from the
Board once they have been completed.
-8.15% Unfav, variance duo to a decline in caseload and decreased
ability for the public to pay. The Distri0 Court's 2010 budget
task Included an increase in its revenue by establishing a
now Default Fee, Show Cause Fee, Warrant Cost fee, and
Probation Report Cost fee. After reviewing historical and
current data, Management and Budget requested the court
submit plans to replace 'the last revenue shortage The
Court will be requesting approval of these plans from the
Board once they have been completed.
-7.86% 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 Probatier Report
Cost fee. After reviewing historical and current data,
Managerner it and Budget requested the court submit plans
to replace the last revenue shortage. The Court wilt be
requesting approval of these plans from the Beard once they
have been completed.
-1.24% Un rev. v:Lrioncr, is due to trio court experiencing a reduction
in Cross E state feesl,vfncli air: hosed on a percentage of an
estate's value. Fstate values are declining due to the
economic downturn and property values dropping
(Zn..n '' Hu:venue variance is partially offset by an expenditure variance.
Law Enforcement
Proseceung Attorney 80$,300.00 5 550,300.00 -$ 406,300.00 5 (54,000.001
Sheriff's Office
Sheriff - Administrative Services
-196,900.00
437,100.00
196,900 00
431,100 00
200.100.00 3,200,00
544,000.00 107,500..00
Sheriff - Corrective Services
Sheriff - Corrective Services Satellites
Sheriff - Emer. Prep.1 raining & Comm.
Sheriff - Patrol Services
Sheriff - Investigative Forensic Services
Total Law F-ukrcer Tient
General Government
Clerk - County Clerk
1, /43,266.00 1,743,266.00
1,325,926.00
591,611.00
33,342,194.00
792,392.09
1.325,926.00
591,611.00
32,414,863.00
792,392.00
:39,234,689.00 S
2,267,700 00 $
38,052,358.00 $ 3/%014,158.00 $ 038,200.00)
2,390,493.00 $ 2,425,893.00 $ 35,400.00
1,14/,/66.00 (595,500.00) -34,16%
1,329,726.00 3,800.00 0.29%
591,611.00 0.00'4
32,738,763 00 323,900.00 1.00%
865,292.00 72,000.00 9.20%
Clerk - Elections
Clerk - Register of Deeds & Microglephics
Treasurer
Board of Commissioners
L ibrary Board
260,000.00
7,200,200 00
1,923,530.00
660.00
21,000.00
260,375_00
7,200,200.00
1 ,94,530.00
000.00
21,0110.00
1,023,530.00
1,900 00 1,300.00
67,200.00 40,200.00
COUNTY OF OAKLAND
GENERAL FUND I GENERAL PURPOSE REVENUES
FY 2010 SECOND QUARTER REPORT
Amount
Adopted Amended FY 2010 Favorable
Budget Budget FORECAST funfavorablel Percent Explanation of Significant Variances
-9.81% (inlay. variance due to over estirnatod f ,CilA arid recovery of
prosecution revenue; partially offset by receipt of
intermittent, non-budgeted revenue that is not predictable -
such as Extradition Recovery Fees, Microfilming, arid
Wc...tfere Fraud C.ase Review.
1.63% Fay doe to receipt of misc. revenue
24.59% Fay, variance due to rising receipt of Gun Registrations; and
on-bus:tented revenues That are no4 p(edictani such as
Misc, Fee Income, and Photographs revenues.
Unfav. due to the indefinite cessation of Diverted Felon
payments frorn the State of Mich , partially offset by fay.
Hospital Cost Recovery receipts.
F-av. due to misc receipt of Reimbursement of Salaries
Fay due to im_reasing Reimhta-sement of Solaces, and
Sheriff Special Deputies.
Fav due to increased receipts of Confiscated Property,
Reimbursement of Salaries, and Misc revenues.
1.48% Fay. Certified Copies $82,600 and Gun Permits 590,000 due
to an increase in ectivitY: Partially offset hy unfav Forfeiture
of Bonds ($131 200) due to a decrease in counter activity. •
260,3/5_00 - 0.00%
1,358,200,00 158,000.00 2,19% Fav. Enhanced Access Pees $200,000 due to an increase in
on-line activity, partially offset by unfav. Photostats ($37,000)
due to a decrease in activity.
0.00%
216.67% Fay, Misc. due to Commissioner's voluntary 2.5% donation
to match non-union employee pay reductions
148.89% Fay, Reimhtirsement Salaries $41.000 due to the State of
Michigan reinstating state aid funding for LVPI operations
and Misc $6,200 as a result of more patrons printing Material -
off the computer than off the Copier Machine Charges
($9,000i.
' Revenue varance is parf4ally offset h' nexpenditure variance.
Amount
Favorable
/unfavorable) Percent
56.8,300.00
Explanation of Significant Variances
31,10% Fav - Misc. $2,551 for f Y2010 due to 2.5% salary
reimbursement from J McCulloch to be applied to
Watershed Councils. Fay - Reimbursement General
$082,368 due to CAMS proiert pluoirlingfrequiremunts
phase; original estimate included development/testing phase
hours now expected in 1 Y 2010; offset by unfavorable
salaries, fringes arid drain equipment Untav - Soil Erosion
Fees ($120,000) decrease in building ac:tivity7perrnits due In
downturn in housing market. Fay - Refund Prior Years
Expenditure $3,388 for Environmental Unit reclassification of-
invoices to he rebooked to a grant fund. A budget
amendment is recommended.
Public Services - Medical Examiner
Public Services - Animal Control
Luouornic Duv. & Cumin Affairs - .Admin
Economic Dev. & Comm. Affairs - PEDS
199,000.00
785,887 00
487,300 00
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FY 2010 SECOND QUARTER REPORT
Water FA:SOLEiCeS Commissinner
Adopted
Buddet
1.821,240.00
Amended
Buthiet
1,827,240.00
FY 2010
FORECAST
2,395,540.00
Total General Government
County Executive
' unty Exec - Administration
:ounhf Exec - Auditing
1&B - Purchasing Division
vt&B - Equalization Division
&B - Fiscal Services Division
antral Services - Support Services
acililies Fnpineering
uman Resources
14IS - Administration
IFtS - Health Division
1HS - Children's Village
INS -Ilomelanci Security
.-o
ublic Services - Community Corrections
ub14:. Services - MS1_, Extensien
5 .13,506,270.00 5 13,629,438.00 5 14,432,6.38.00 5 803,20000
3 200.000.00 $ - $ - $
30,000 00 30,000.00 30,000.00
170,000.00 170,000.00 170,000.00
2,827,141.00 2,997,378.00 2,997,318.00
415,600.00 415,600 00 415,600.00
153,000.00 153,000.00 153,000.00
800.00 800.00 800.00
2,812,337.00 2,921,691_06 2,92 I ,09t00
3,019,530.00 3,065,659.00 3,565,659.00
300,060.00 300,000.00 300,000.00
46,555.00 46,555.00 32,555 00
194,000.00
785,887 00
487,306 00
0.00%
0.00%
0..00%
0.00%
0.00%
0 00%
0 00%
0 00%
C 00%
500,000.00 16 31% Favorable Board arid Care due to higher population.
0.00%
0.00%
-30 07% Unfav. Reimbursement General ($14,000) due in change in
the Master Gardener Volunteer Program registration
process; offset by an expenditure reduction of the same
amount in Workshops and Meetings A budget amendment
is recomniondeil le recogni.ze favorable expenditures and
offset unfavorable revenues.'
7./3% Fav. Cremation Appruval Fee $15,000 doe to an increase in
caseload
0.00%
0.00%
(50,006.00) -10.26% Unfav. Reimbursement Salaries from Small Business Tech
Council ($35,000), which is instead providing part-time
staffing assistance to PEDS; and reduc.ed Reimbursement
General ($15,000) from new Main Street Program members
due to economic downturn.
209,000.00
785,881.00
437,300.00
(14,000 00)
15,000.00
-;I County- Lxccutive
Non-Depintrnental
NC11-Dept - Ci uijes fcr :3ervices
Int4 Non-Departmental
11,441,150.00
.750000 00
ific),000 00 5
11,507,270.00 S
150,000.00
750.000 00 $
12,018,270 60
640,000.00
640,000.00 -1
451,00.0.00
(1 10,000.00) 'ay phonic L.uiriiiiissiori is un(av. due to less activity at the
4110,000.00) -14.61%
' Rrneritie vandrice Is partially offset by an expenditure variance
142,600.00 5
105.,000,00
8,500,00
21,326.00
1 000 00
4,300.00
1/5,000.00 $
205,000.00
8,500.00
21,328.00
1,000.00
4,30000
250,000.00
(11,500.00)
100.00
(11,400.00)
(183,500.00)
10,600,00
35,200 00
3,300.00
8,900.00
22,600.00
200,000 00
117,100.00
PLANNED USE OF FUNID BALANCE (665000-665999)
Fncum and Approp Carry Forward 234,678.10 234,678 15
COUNTY OF OAKLAND
GENERAL FUND/ GENERAL PURPOSE REVENUES
FY 2010 SECOND QUARTER REPORT
Total Charges for Services
INDIRECT COST RECOVERY (640100)
INVESTMENT INCOME (655000-655999)
District Courts (Div, I - eft
Sheriff Corrective Services
ClerkiReg4ster of Deeds
Non-Departmental
Total Investment Income
OTHER REVENVES1870000.-695500)
Circuit Court
District Court
F-1rutiete Court
Prosecuting Attorney
Sneriff Office
Sheriff - Patrol Services
Sheriff - investigative/Forensic Svc
CleritfRegister of Deeds
Treasurer
Library Board
\Neter Resources Commissioner
County Executive - ERR Equipment
Management and Budget
Central Services - Support Services
Facilities PnOneering
Health Division
Children's Village
Public Services
Planning & Pain. Devel. Services - transfers
Economic Development - Donations
Non Departments) - DOD a tions
Non-Dept - Sundry
Treasurers' Transfers
Non-Department:II - i raiu.sfcrs In
Total Other Revenues
Adopted Amended
Budget Budgte.f.
84,149,468.00 5 63,210,425.00
8,517,499.00 $ 9,053,032.00 $
20,500.00 $
53,800.00 53,800.00
2,687,500.00 2,68 /,500.00
2,761,800.00 $ 2,761,800_00
20,000.00
417,500.00
4,500,000.00
50.673,52 1 01J 59,6/3,52100
64,878,753.00 $ 65,031,153.00
Amount
Favorable
(unfavorable)
5 405,000.00
9,303,032.00
9,000.00 $
101100
53,800.00
2,687,500.00
2,750,400.00 $
11,500.00 $
205,000.00
19,100.00
56,526.00
3,300.00
1,000.00
4,300.00
890000
22,600.00
20,000.00
417,500.00
4,7010,000.00
59,618.52 00
65,148,253.00 S
Explanation of 5Kmificant Variances
2.76% Allocation based on latest Indirect Cost study.
-56.10% .11-ie economic downturn arid poor investment market lies
reduced the Court investment income.
0.00% Fay receipt of investment income.
0 00'6
0.00%
-0.41%
thifav. CANI revenues are lower than anticipated; Prosecutor
lias identified offsetting expense budget reductions to
compensate for revenue shortfalls. Second quarter budget
amendments will be submitted.
0.00%
0.00% Fay, variance is due to the receipt of Refund Prior Years
Expenditures
100.05% lay, variance is due to the receipt of Refund Prior Years
Expenditures.
100.00% Fay. due to cash overages.
0.00%
0.00%
0.00%
0,00%
0.00%
0.00%
0.00% Fast variance is due to the receipt of Refund Prior Years
Expenditures.
0.00% Fa-v. variance is due to the reclassification of bia-med
invoices from October and June of 2009.
0.00%
100.00%
0.00%
0.00%
0.00%
0.00%
4.44% Fay, variance is due to the Collection Fees collected in the
1)1 Rt. Please.•- note these fees are kept in reserve for three
years before being transferred to the General Fund
0.011%
0.18%
20.500.00 $
417,500.00
4,500,000 00
FY 2010
FORECAST
83,615,425.00
Percent
049%
0.00%
0.00%
0.00%
-93,43%
(*""•,, ' Revenue varia5ice is partially off!set by an expenditure variance.
14.342
Generk0 Fund - F-'rinr Years Balance
Total Planned Use of Fund Balance
Adopted
Budget
150,000.00 $
150,000.00 $
COUNTY OF OAKLAND
GENERAL FUND GENERAL PURPOSE REVENUES
FY 2010 SECOND QUARTER REPORT
Amount
Amended FY 2010 Favorable
Budget FORECAST i'unfavorablel Percent
3,085.098.00 5 3,085,008 00 0.00%
3,319,776.15 5 3,319,776.15 $ 0.00%
Explanation of Significant Variances
TOTAL GEN. FUNI3 IGEN. PURPOSE REVENU $ 409,835,938.00 5 412,440 615.15 $ 414,373,215.15 $ 1 93L§00.00 0.47%
0 • Revenue variance iE parlia4 offsez by an expenditure variance
Judicial Administration
Persour icl Expenditures
OperatiN Expenditures
Internal Support Expenditures
99,975.00
277,867.00
356,858.00
327,969.00
356,858 00
307,969.00
60,000.00
20,000.00
$ 8,275,469.00 5 8,293,869.00 $ 3.233,869.00 $
Transfer Out 122,219 00
$ 8,703,331.00 $ 9,100,915.00 $
122.219.00
9,020,915.00
0.00%
80,000.00 0.88%
50,000.00
5 2,001,068 00 5 2,013,236.00 $ 1,990,236.00 $ 23,000.00 1.14%
$ 2,249,539 00 $ 2,257,348.00 $ 2,142,348 00 $
5,256,627.00 5,258,627.00 5,028,627.00
55,000.00 2,549,079.00
230,000.00
115,000.00
2,444,894.00 2,604,079.00
Civil I Criminal 1.1Ivision
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
5.09% - Fay. variance is due to county wide hiring freeze, underfilled
positions and vacancies.
4.37% - Fair. variance is due to less activity in Defense Attorney fee
payments of $230,000. These payments are dependent on
caseload, and the Circuit Court fee structure. During tde 2010
budget process the court made a number of changes to the Defense
Attorney Fees structure to reduce costs.
2.11% - Fay. variance is based on current IT equipment rentals and monthly
operations.
•$ 9,951,060.00 $ 10,120,054,00 $ 9,720,054.00 $ 400,000.00 3.95%
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
CIRCUIT COURT
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2010
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
0.72% - Fay. variance is due to county wide hiring freeie, urderfilled
positions and vacancies.
0.00% -
6.10% - Fav. variance is based on current IT equipment rentals and monthly
operations.
Business Division
Personnel Expenditures
Opuhatilig Expenditures
Internal Support Expenditures
$ 1,674,348.00
96,264.00
238,456.00
$ 1,678,866.00
96264.00
238,107.00
$ 1,678,865.00 5
96,264.00
215,107.00 23,000.00
0.00%
0.00% -
9.66% - Fay. variance is based on current IT equipment rentals and monthly
operations.
5/1212010
1,605,104.00
4,360,124.00
$ 31,116,234.00 $ 31,141,675.00 $ 29,716675.00 $
$ 23,532,047.00 $ 23,007.947.00 $
19,492,707.00 18,242,707.00
4,867.883.00 4,714,883,00
4492.34:3.00 4,482,343.00
$ 23,437,496 00
19,275,642.00
4,654,431.00
4,410,124.00
1,429,000.00 4.58%
525,000.00 2.23%
1,250,000.00 6.41%
153,000.00 3. 14%
0.00%
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
$ 51,777,693.00 $ 52,375,880.00 $ 50,447,880.00 $ 1,928,000.00 3.68%
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
CIRCUIT COURT
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2010 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT
-----
EXPLANATION OF SIGNIFICANT V.ARiANCES
Family Division/Juvenile Maint.
Personnel Expenditures
Operataig Expenditures
Internal Support Expenditures
Transfer Out
S 11,238,140.00 $ 11,302,865.00 $ 10,952,865.00 $ 350,000.00
13,822,776.00 13,780,958.00 12,700,958.00 1,020,000.00
1,697,728.00 1,642,728.00
4,360,124.00 4.360,124.00
3.10% - Fay. variance is due to county wide hiring freeze, underfilled
positions and vacancies.
7.40% - Fay. variance due to the court continuing to experience a shift from
piacernents in State Institutions (Fay. $1,7 million) to Private
Institutions (Unfav. $600,000). Private Institutions is Child Care
funded and is reimbursed from the state at 50%. The tavoratility
!rum the shift in State to Private Institutions is partially offset by a
unfavorable amount in personal mileage of ($80,0(0). During the
2010 budget process the court submitted as part of its budget tash, a
decrease in Personal Mileage. 'ibis decrease was contingent upon
the court and .gie bargaining unit agreeing on the reduction. The two
parties have been unsuccessfui at reaching the agreement, and the
Circuit Court is working inn additional reductions to replace their
previous submission.
- Fav. variance is based on current IT equipment rentals and monthly
operations.
0.00% -
65,000.00 3.24%
5/12;2010
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2010
FORECAST
$ 3,863,041.00 $ 3,863,041.00 $ 3,863,041.00 $
1,015,303.00 •1,015,303.00 991,303.00 24,000.00
426,096.00 461,930.00 441,930.00 20,000.00
$ 5,304,440.00 $ 5,340,274.00 $ 5,296,274.00 $ 44,000.00 0.82%
Division 1 - Novi
PersurInel Expenditures
Operating Expenditures
internal Support Expenditures
lintel Division 1 - Novi
0.00% -
2.36% - Fav, variance is due to the court working to reduce cost
in the following line items: Defense Attorney Fees of
$5,000, Juror Fees and Mileage of $6,500, and Postage
of $10,500.
4.33% Fav. variance is based on current equipment rentals
and monthly operations.
Division 2 - Clarkston
Personnel Expenditures
Operating Expenditures
$ 1,698,239.00 $ 1,713,908.00 $ 1,689,908.00 $ 24,000.00 1.40%
600,450 00 632,187.00 579,387.00 52,800.00 8.35%
$ 3.614,961.00 $
349,743.00
806,546.00
3,614.901.00 $ 3,583,961.00 $
349,743.00 329,743.00
842,338.00 822,338.00
96,800.00
31,000.00
20,000.00
20,000.00
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
DISTRICT COURT
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
District Court Administration
Porsunnel Expenditures
Operating Expenditures
internal Support Expenditures
Transfer
$ 197,739.00 $ 197,739.00 $ 187,739.00 $ 10,000.00
5,300.00 5,300.00 5,300.00
5.06% - Fav.. variance is due to underfitled positions.
0.00% -
0.00%
$ 203,039.00 $ 203,039.00 $ 193,039.00 $ 10,000.00 4.93%
internal Support Expenditures
Transfers Out
Total Division 2 - Clarkston
Division 3 Rochester Hills
Personnel Expenditures
Operating Expenditures
Intorno! Support Expenditures
- Fav. variance is du a to underfilled positions.
- Fav. variance is largely due to a reduction 41 Uefense
Attorney Fee payments of $35,000. Caseload dropped
in 2009 and Defense Attorney Fee payments are
contigent on caseload. In addition to thee 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.
- Fay. variance is based on current equipment rentals
and monthly operations.
244,971.00 224,971.00 20,000.00
72,811.00 33,415.00 33,415.00
$ 2,581,821.00 $ 2,624,481.00 $ 2,527,681.00 $
8.16%
0.00%
3.69%
0.86% - Fav.. variance is due to county wide hiring freeze,
underfilleci positions and vacancies.
5.72% - Fay. variance is due to Juror Fees and Mileage of
$12,000 and Professional Services of $8,000
2.37% - Fav. variance is based on current equipment rentals
and monthly operations.
210,321.00
$ 4,771,250,00 $ 4,807,042.00 $ 4,736,042.00 $ 71,000.00 1.48%
5/12/2010
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
DISTRICT COURT
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Division 4 - Troy
Persormel Expenditures $ 2,303,637.00 $ 2,304,505.30 $ 2,304,505.00 $ 0.00% -
Operating Expenditures 528.388 00 532,124.00 501,124.00 25,000.00 4.70% Fav. variance is due to the court working to reduce Lost
in the following line items: Pusrace of $5,000, Charge
Card Fee of $10,000, Defense Attorney Fees of $5,000,
Workshops and Meetings of $1,500, Library
Continuation's of $2,000 and Membership Dues of
$1,500.
Intern-al Support Expenditures 329277.00 353,291.00 333,291.00 20,000.00 5.66% - Fav. variance is based on current equipment rentals
and monthly operations.
---- $ 3,161,302.00 $ 3,189,920..00 $ 3,144,990.00 $ 4E,000.00 1.41%
Department Total
Personnel Expenditures $ 11,677,617.00 $ 11,694,154.00 $ 11,629,154,00 $ 65,000.00 0,56%
Operating Expenditures 2,499.184.00 2,534,6E7.00 2,412,851.00 121,800.00 4.81%
Internal Support Expenditures 1,772,240 00 1,902,530.00 1,822,530.00 80,000.00 4.20%
Transfers 72,811.00 33,415.00 33,415.00 -
$ 16,021,857.00 $ 16,164,756.00 $ 15,897,956 00 $ 266,800.00 '1.65% . •
09 51'1212010
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2010
FORECAST
2,163,022.00 $ 2,323,022.00 $ 2,323,022.00
43,981.00 43,981.00 35,581.00
$ 4,523,973.00 $ 4,508,973.00 $ 15,000.00 0.3'3%
713,505.00 705,105.00 6,400.00 1.18%
900,364.00 875,164.00 25,000.00 2.78%
$ 6,137,842.00 $ 6,089,442.00 $ 48,400.00 0.79%
Fav. variance ls due to a vacant Office Assistant
position. The court does not plan to fill this
position in 2010.
Fay. variance is based on current IT equipment
rentals and monthly operations.
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
PROBATE COURT
Judicial/Administration
Personnel Expenditures
Operating Expenditures
Internal Support
Transfer Out
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT
0.00%
8,400.00 19.10%
EXPLANATION OF SIGNIFICANT VARIANCES
Fav. variance due to the ccurt's effort to minimize
costs in areas such as Library Continuations
$5,900, and Travel $2,500.
Estates/Mental Health
Personnel Expenditures
Operating Expenditures
Internal Support
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support
Transfer Out
$ 2,207,003.00
$ 2,183,282.00
635,291.00
1,092,046.00
$ 3,611,219.00
S 4,346,304.00
679,272.00
1,092,646.00
$ 6,118,222.00
$ 2,367,003.00 $ 2,358,603.00 $
$ 2,200,951.00 $ 2,185,651.00 $
669,524.00
875,364 00
5 3,770,839.00 3,730,839.00 $
8,400.00 0.35%
15,000.00 0,68%
0.00%
25,000.00 2.78%
40,000.00 1.06%
669,524.00
900,364.00
5/1212010
Werra! Stipp-Uri FKIIP fltiih If VS
ra qsfors Out
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
PROSECUTING ATTORNEY
AMOUNT
ADOPTED AMENDED ir-V .2010 FAVOR.ABL F
BUDGET BUDGET FORF.CAST (UNFAVORABLE: PERCENT
--------------------
EXPLAMATiON OF SIGNIFICANT VARIANCES
Adreinislralion
Persurnol Expenditures
Operating ri.peric/Kures
$ 2,406.63.3.E $ 2,496583.00 3 2,929,283.00 $ (4.32,600.00) -17.23% Divisions are reflecting fait t ((Hirai') variances primarily due
to peisohmil charges within flie Pr cetera Office under
the new administration. Pians for a formal reorganization
will be preSesiled ai ii later date.
809,872 00 8:37,643.40 657,943.40 179 700.00 21.48% Reductions maws to offset unfav, revenues in vanou.s line-
ilEir'HS such as Fxtradition Expense. F xpert Witness Fee
and Mileage, Filing Ficus, Membeship Duos, Personal
Mlleage, Miurofilming & Reproductions, Printing,
Professional 5ervir.cei, Travel raid CWIfurerics, -.Security
Supplies, and Expendable Equipment Expense. A budget
amendment is recommended to reduce revenues and
Offsetting expenditures due lo tower lhan anticipated activity
related lc OWI cases.
Internal Support Expenditures 1,884,639.00 1,917,639%00 1,917.639.00 0.00% -
Transfers (10,598.00) 00,598.00j (10,598..00) 0.00%
$ 5.180,596.00 3 5,241 36/.40 $ 5,494,267.40 3 (252.900,00) -4.83%
Litigation
Personnel f xiriujiiiluires $ 05,082.00 .5 9,10.5,082 00 $ 8,328,382.00 5 7.16,700.00 13.83% LivisionD are reflecting for (i.rn fay) variances primarily due
to personncichartgas within the Prosecutor's Office under
Ille r VOW administration. Plans for a forrnal reorganization
will be presented at a later date.
cipaetit,g Expenditures 04;744 00 84,744.00 44,?-44,Ciu 20,000.00 30.89% Reductions made to otiset unfair. revernies, see
eKpianation under Administration Division's Operating
Expenditures.
2,036.00 2,536.00 2,536.00 0.00%
855,589.(10 855 589 00 855,969.00 0.00%
$10.1327,961 .00 $16,027,951.00 $ 0,231,251.00 $ 796,700.00 1.94%
Warrants
Personae) Exper,diures $ 2,079,224.00 3 2,079,224.00 3 2,002,824.00 $ 76,700.00 3.60% Divisions are reflecting by I ttinfav) variances primarily due
to personnel changes within the PTOSOCAlt0e3 Office under
the new arisnisoistroliars Plans tor a format recroo.nization
will be presented et a later date
OverrAing E-xpeintlitures 3,199.00 3,199.00 3,199.00 0.00%
In:or:gal Support Expen • ditures 0.00%
S 2,082.423.00 $ 2.082,423 00 $ 2,0115.723 00 3 76,7008)0 3
5/12:2010
ADOPTPO
BUDGFT
AMENDED
-BUDGET
Operating ExpenditiJrezn;
Internal Support Expenditurcs
$ 1,647,345.00 5 1447,345.00 $ 1,492,348.U0 10170.00
0.00%
0.00%
9 41%
8,458.00 8,456.00
3.7E%
21,80%
0.00%
0.00%
4.08%
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
PROSECUrING ATTORNEY
AMOUNT
FY 2010 FAVORABLE
FORECAST (UNFAVORABLE;' PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Appellate
Person let Expere!iiii nes $ 1433,687 00 $ 1,03.88700 $ 1,483,887 00 $ 1.55 000.00 9.46% Ulvision; iroreflecting fay li,untavt varizinres printaril7 clue
to personnel charis.es withi.i Ite Prosecutor's Office under
the new administration. Plans far a formal rourgmlization
t.vid tie presented et a later date.
Department
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
$15,319,876.00
1366,273 0C
1,881,175.00
644.991 UO
$18,936 3 f 5.0D $ I
$14,744,O ?0O0 575.800.60
714,344A0 100, P00.00
1.920,175.00
844,991.00
8,999.086.40 $18,223,586.40 $ 775,500.00
$ 1 tb,:319,876 00
044004440
1,920,175.00
344,091.00
ir.,±12,i2C10
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
SHERIFF'S OFFICE
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Sheriff's Office
Personnel Expenditures $ 1,607,016.00 $ 1,607,015.00 $ 1,629,215.00 $ (22,200.00) -1.38% Unfav. fringes for retirement due to salary forecast programming
complication which resulted in insuffleient allocation for retirement
and hospitalization, due to inurease in costs.
Operating Expenditures 126,236.00 131,880.00 131,880.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,995,367.00 $ 2,017,567 00 $ (22,200.00) -1.11%
Administrative Services
Personne/ Expenditures $ 1,920,418.00 $ 1,937,736.00 $ 2,043,136.00 (105,400.00) -5.44% Unfav. largely due to projected overtime charges in excess of
budget; holiday overtime is over budget due to arbitration awarded
salary increase.
Operating Expenditures 944,843.00 996,303.19 996,303.19 - 0.00%
Internal Support Expenditures 332,695.00 332,695.00 332,695.00 - 0.00%
Transfers - - 0.0C%
$ .3,197,956.00 $ 3,266,734.19 $ 3,372,134.19 $ (105,400.00) -3.23%
Corrective Services
Personnel Expenditures 32,635,993.00 $ 32,693,839.00 $ 32,927,639.00 (233,800.00) -0.72% Unfav. largely due to projected overtime charges in excess of
LucJget holiday overtime is over budget due to arbitration awarded
salary increase.
Operating Expenditures 7,228,273.00 7.301,406.35 7,301,406.35 - 0.00%
Internal Support Expenditures 7,696,603.00 7.968.705.00 7,968,705.00 - 0.00%
fransfers , - - - 0.00%
$ 47,560,869.00 $ 41,963,950.35 $ 48,191,750.35 $ (233,800.00) -0.49%
Corrective Services-Satellites
Personnel Expenditures $ 13,692,832,00 $ 13,692,832.00 $ 13,911,532.00 $ (218,700.00) -1.60% tinfav. largely clite to projected overtime charges in excess of
budget; holiday overtime is over budget due to arbitration awarded
salary increase.
Operating 'Expenditures 234,500.00 234,500.00 234,500.00 - 0.00%
intoinal Support Expenditures 1,014,166.00 1,066,211.00 1,066,211.00 - 0.00%
Q.) Trzinsfers - - - - 0.00%
1c.
5112/2010
0.00%
0.00%
0.00%
425,154.03
4,852,647.00
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
SHERIFF'S OFFICE
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 15,001,498.00 $ 14,993,543.00 $ 15,212,243.00 $ (218,700 00) -1.46%
Emergency Prep., Trning & Comm.
Personnel Expenditures $ 4,868,847.00 $ 4,864,141.00 $ 5,024,841.00 $ (160,700.00) -3.30% Unfav. largely due to projected overtime charges in excess of
budget; holiday overtime is over buclijet clue to arbitration awarded
salary increase.
Operating Expenditures 191,649.00 195,726.00 195,726.00 - 0.00%
Internal Support Expenditures 230,385.00 230,385.00 230,385.00 - 0.00%
Transfers . - - - 0.00%
$ 5,290,881.00 $ 5,290,252.00 $ 5,450,952.00 2 (160,700.00) -3.04%
Patrol Services
Personnel Expenditures $33,649,338 $ 32,771,318.00 $ 33,136,618m 2 (365,300.00) • 1.11% Unfav, largely due to projected overtime charges in excess of
budget; holiday overtime is over budget due to arbitration awarded
salary increase.
Operating Expenditures
Internal Support Expenditures
Transfers
Investigative/Forensic Svcs
Personnel Expenditures
481,858.24 481,856.24
4,803,875.00 4,803,875.00
$ 38,927,139.00 $ ,0s704&..24 $ 38,422,349.24 $ (365,300.00) -0.96%
$ 7,392,182.00 $ 7,492,182.00 $ 7,504,382.00 $ (12,200 001 -0.16% Unfav, largely due to projected overtime charges in excess of
budget; holiday overtime is over budget due to arbitratiot I awarded
salary increase.
Operating Expenditures 1,065,82t00 1,100,472.09 1,100,472.09 - 0.00%
Internal Support Expenditures 2,271,6E7.00 2,263,611.00 2,263,611.00 - 0.00%
Translers - 519,086.00 519,086.00 - 0.00%
$
10,729690.00 $ 11,3 15,351.09 $ 11,387,551.09 $ (12,200.00) -0.11%
Department Total
Personnel Experidtures
Operating Expenditures
Internal Support Expenditures
Transfer Out
$ 95,766,625.00 $ 95,059,063 00 $ 96,177,363.00 $ (1,118,300.00) -1.18%
10,216,476.00 10,442,143.87 10,442,143.87 0.00%
16,715,200.00 16,921,954.00 16,921,954.00 - 0.00%
519,086.00 519,086.00 - 0.00%
$ 122,698,301.00 $ 122,942,246.87 $ 124,050,546.87 $ ("I ,118,300.00) -0.91%
5;12;2010
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
CLERK/REGISTER OF DEEDS
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures $ 728,330.00 $ 732,962.00 $ 602,962.00 $ 40,000.00 5.46% Fay due to underlined and vacant positions.
Operating Expenditures 40,382.00 40,382.00 40,382.00 0.00%
Internal Support Expenditures 189,029.00 218,580.00 210,080.00 8,500.00 3.89% Fav. Motor Pool 86,000 arid Motor Pool Fuel Charge $2500 due
to decreased activity.
I ransfers - 0.00%
$ 957,741.00 $ 991,924.00 5 943,424.00 $ 48,500.00 4.89%
County Clerk (Vital Stets & Legal Rees)
Personnel Expenditiires $ 3,296,093.00 $ 3,296,093.00 $ 3.206,093.00 $ 90,000.00
Operating Expenditures 297,408.00 308,332 50 273,332.50 35,000.00
2.73% Fav, due to underfilled and vacant positions
11.35% Fay. Professional Services $20,000 and Travel & Conference
$2,000 due to effort to reduce usage and costs. Also Fay. In
Court Transcripts $20,000 due to lower than anticipated activity;
partially offset by Unfav. Office Supplies ($7,000) due to a higher
than anticipated use.
Internal Support Expenditures
Fransfar
656,625.00 732,783.00 632;183.00 100,000.00 13.65% Fay. Info Tech Imaging Operations $100,000 due to decreased
activity.
0,00%
$ 4,250,726.00 $ 4,337,208.50 $ 4,112,208.50 $ 225,000,00 5.19%
5i1 2;201 0
Transfers 0.00%
$ 2,817,747.00
$ 1,066,824.00
$ 30,000.00
68,000.00
2.12%
0.00%
0.00%
4.70% Pay, Info Tech Operations $5,000 due to decreased activity.
ADOPTED
BUDGET
AMENDED
BUDGET
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
CLERK/REG1sTER OF DEEDS
AMOUNT
FY2010 FAVORABLE
FORECAST UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Elections
Personnel Expenditures
Operatino Expenditures
Internal Support Expenditures
$ 685,056.00 $
772,475.00
131,340.00
687,749.00 $ f18 t, 749.00 $
772,850.00 772,850.00
131,948.00 131,948.00
0.00%
0.00%
0.00%
$ 1,592,547.00 $ 0.00% $ 1,588,8 /1.00 $ 1,592,547.00
Register of Deeds (and Micrographics)
Personnel Expenditures 2,847,747.00 $ 2,847,747.00
Operating Expenditures 1,134,824.00 1,134,824.00
1.05% Fay due to underfi1led and vacant position,
5.99% F-av, Material & Supplies $38,000 and Maintenance Contract
$30,000 due to lower than anticipated use.
Internal Support Expenditures
Transfers
589,706.00 633 150.00 $ 633,150.00 0.00%
0.00%
$ 4,572,277.00 $ 4,615,721.00 $ 4,517,721.00 $ 98,000.00
28,831.00 $
6,161.00
104,244.00
Jury Commission
Personnel xpenditures
Operating Expenditures
Internal Support Expenditures
$ 139,230.00
28,831.00
6,161.00
106,392.00
$ 141,354.00
$ 28,831.00 $
6,161.00
101,392.00 5,000.00
$ 136,384.00 5 5,000.00 3.54%
5.112.,2010
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
CL ERK/REGiSTER OF DEEDS
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Department Total
Personnel Expemdituves $ 7,586,057.00 $ 7,593,382.00 $ 7,433,382.00 $ 160,000.00 2.11%
Operating Expenditures 2,251,250.00 2,262,549.50 2,159,549.50 $ 103,000.00 4.55%
Internal Support Expenditures 1,670,944 00 1,822,853.00 1,709,353.00 $ 113,500.00 6.23%
-transfers - - - 0.00%
$ 11,508.251.00 $ 11.673,784.50 $ 11,302,284.50 $ 376,500.00 3.22%
Note revenue offset
511212010
Division Total
Department Total
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
COUNTY TREASURER
AMOUNT
ADOP 1ED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures $ 2,654,440.00 $ 2,664,440.00 $ 2,695,440.00 $ (45,000.00) -1.70% - Unfav. variance due to personnel changes since preparation of
the budget.
Operating Expenditures 189,920.00 193,460.04 -193,460.04 - 0.00% -
Internal Support Expenditures 650,415.00 966,861.00 908,861.00 58.000.00 6.00% - Fey. variance is based on current 1T equipment rentals and
monthly operations.
$ 3.503,775.00 $ 3,8 (4,761.04 $ 3,801,761.04 $ 13,000.00 0.34%
5 3,503,775.00 5 3,8 14,761.04 $ 3,801,761.04 5 1:3,00C 00 0.34%
5/1212010
Administration
Personnel Expenditures
Operating Expenditures
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
BOARD OF COMMISSIONERS
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Internal Support Expenditures
Department Total
Personnei Expenditures
Operating Expenditures
Internal Support Expenditures
$ 2,255,237.00 $ 2,255,237.00 $ 2,269,737.00 $ (14,500.00) -0,64% - Utley, due to increased Overtime ($3,500) to cover 80C night meetings.
Also unfav. Fringe Benefits ($11,000) associated with the overtime arid an
increase in costs for hospitalization.
402,181.00 402,181.00 $ 388,181.00 14,000 00 3.48% - Fav. Travel & Conference $8,000, Workshops and Meetings $5,000 and
Legal Services $5,000 due to effort to reduce usage and costs; parlially
offset by unfav. Prof Serv - Annual Audit ($4,000} due to an increase in the
contract.
260.62d.00 281,206.00 $ 256,298.00 6,000.00 1.91% - Favorable Motor Pool $3,000 and Motor Pool Fuol Charges $2,000 due to
decreased activity.
$ 2,917,944.00 $ 2,918,716.00 $ 2,914,216.00 $ 4,500,00 015%
$ 2,255,237.00 $ 2,255,237.00 $ 2,289,737.00 $ (14,500.00) -0.64%
402,181.00 402,181.00 388,181.00 14,000.00 3.48%
260,526 00 251,298.00 256,298,00 5,000.00 1.91%
$ 2 917,944.00 $2,918,716.00 $ 2,914,216.00 $ 4,500.00 0.15%
5t12r`2010
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
LIBRARY BOARD
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Library Board
Personnel Expenditures $ 794,157.00 $ 795,320.00 $ 761,320.00 $ 34,000.00 4.28% Ttirnaver
Cperalong Expenciitures 251,099.00 251,09.9 00 251,099.00 - 0.00%
Internal Support Experdifures 887,605.00 82.477.00 892,477.00 - 000%
Transfers -
$ 1,932,861.00 $ 1,938.896.00 $ 1,904,896.00 $ 34,000.00 175%
Department Total
Personnel Expenditures $ 794,157.00 $ 795,320.00 $ 781,320.00 $ 34,000.00 4.28%
Operating Expenditures 251,099.00 251,099.00 251,099 00 - 0.00%
Internal Support Expenditures 887,605.00 892,477.00 892,47700 - 0.00%
Transfers - - - -
$ 1,932,861.00 .$1,938,896.00 $ 1,904,896.00 $ 34,000.00
5/1Z2010
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
E XPENDITU RES
WATER RESOURCES COMMISSIONER
ANIOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Water Resource Commissioner
PFr5onnel Fxpendittures $ 3.677,188.00 $ 3,679,471.00 $ 4,235,654.00 $ (556,183.00) -15.12% Unfav - Salaries and Fringes ($556,183) due to CAMS project
planning/requirements phase; original estimate ticiuded development/testing
phase hours now expected in FY 2010. There is offsetting revenue related to this
project.
Operating Expendit ures 457,412.00 457,412.00 45 (,412.00 0.00%
1,411,020.00 (126,185.00) Internal Support Expenditures
Transfers
1,121,581.00 1,284,835.00
56,165.00 56,165.00
-9.82% lInfav - Drain Equipment ($126,1851 due to CANIS project planning/requirements
phase; original estimate included cJevolupmentlesting .F:hase hours now expected
in FY 2010 based on second quarter Budget Amendment. There is cifsetting
revenue related to this project.
56.165.00 0.00%
Total $ 5,312,346.00 $ 5,477,883.00 $ 0,160,251.00 $ (682,368.00) -12.46%
Department Total $ 5,312,346.00 $ 5,477,883.00 $ 6,160.251.00 $ (682,368.60) -12.46%
5,1.1212010
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
COUNTY EXECUTIVE
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECASI {UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARrANCES
Administration
Controllable Personnel $ 1,994,474.00 $ 2,001,798.00 $ 2,001,798.00 0.00% -
Controllable Operating 224,173.00 274,225.00 274,225.00 0.00% -
Internal Support Expenditures 602,689.00 605,231.00 605,281.00 0.00% -
Transfer Opt -
Auditing
Controllable Personnel
$ 2,821,336.00 $ 2,881,304.00 $ 2,881,304.00 $ 0.00%
$ 975,547.00 $ 975,547.00 $ 965,547.00 $ 10,000.00 1.03% - Turnover
Controllable Operating
Internal Support Expenditures
Transfer Out
27,657 00 27,657.00
106,930.00 106,030.00
15,895.00 11,762.00 42.53% - Favorable Membership Duos $1,000, Personal Mileage $1,762 and Travel
& Conference $9,000 due to turnover of staff.
106,930.00 0.00% -
$ 1,110,134.00 $ 1,1 I 0,134.00 $ 1,088,372.00 $ 21,762.00 1.96%
Corporation Counsel
Controllable Personnel $ 1,930,372.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 222,715.00 222,715.00 0.00% -
Transfer Out -
$ 2,208,994.00 $ 2,210,360.00 $ 2,210,360.00 $ 0.00%
Department Total
Controllable Personnel $ 4,900,393.00 $ 4,907,717.00 $ 4,897,717.00 $ 10,000.00 0.20%
Controllable Operating 309,103.00 359,155.00 347,393 00 11,762 00 3.27%
Intema. Support Expenditures 930,968.00 934,926.00 934,926.00 - 0.00%
Transfers Out - - -
$ 6,140,464.00 $ 6,201,798,00 $ 6,160,036 00 $ 21,762.00 0.35%
5/12/2010
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
MANAGEMENT AND BUDGET
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures
Operating Ekpenditures
Internal Support Expendituiec
Purchasing
Persorme.1 Expenditures
Operating Expenditures
internal Support Expenditures
Transfers
$ 204,186.00 $ 704,186 00 $ 201,186.00 $ (3,000.00) -1.47% (Unfav.) Fringes for retirement due to Salary Forecast programming
complication which resulted iii insufficie!it allocation for retirement.
5,580,00 5,580.00 5,580 00 0.00%
17,200.00 17,200.00 17200.00 0.00%
._
$ 220,966.00 $ 226 ,966.00 $ 229,966.00 $ (3,000.00) -1.32%
$ 1,050,154.00 $ 1,050,154 00 $ 550,154.00 $ 100,000.00 9.52% Fay. Salaries and Fringes duo to underlining of positions.
35,081.00 38,183.00 38,183.00 0.00%
199,061.00 .205,358.00 205,358.00 0.00%
$ '1284,296.00 $ 1.293,655.00 $ 1,193,695,00 $ 10(1,000.0G 173%
Equalization
Personnel Fxpenditures $ 1,495,811,00 $ 7 445,811.00 $ 1,157,811 00 $ 338,000.00 4.51% Fay. due to turnover.
Operating EKpenditures 737,591 00 213,011.00 273,011 00 0.00%
Internal Support Expenditures 1,127,615.00 1,486,495.00 1,486,495,00 0.00%
'1 monsters 0.00%
$8,861,0.17.00 $9,255.317.00 $ 8,91 /,317,00 $ 338,000.00 3.65%
Fiscal Services
Personnel Expenditures $ 7,396,583.00 $ 7,404.181.00 $ 7,254,181.00 $ 150,000.00 2.03% Fav. due to the undumfilling of positions.
Operating Fxpendthires 230,324.00 230,324.00 230.324.00 0.00%
internal Support Expenditure 1,612.816.00 1,1366,868.00 1,866,668.00 0.00%
- - Transfers - 0.00%
$ 9,23,723.00 $ 9,501,3 /3.00 $ 9,351,373.00 $ 150.000.00 1.58%
5112/2010
585,000.00 3.67%
0.00%
0.00%
0.00%
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
MANAGEMENT AND BUDGET
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Depar invent Total
Personnel Expenditures $ 16.146,734.00 $ 16,154,332.00 $ 15,569,332.00 $
Operatiny Expenditures 508.576.00 547,008.00 547,098.00
!liter-Rat Support Experiditure.s 956,692 00 357597i.00 3 75.92l.00
1 ran sfers
$ 19,612,002.00 $ .20277,30160 $ 19,602,351.00 $ 585,000.00 2.88%
502)2010
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENINTURES
CENTRAL SERVICES
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administrative
PUTSCAMOI Expunditurf2z,; 15 200,232.00 $ 200,202.00 $ 205,332.00 $ (6 100.00') -3.05% (tinfav.) Fringes for retirement due to Salary Forecast programming
complication which resulted in insufficient Acr.:ation fur retirement.
Operating Expenditures
Internal Support Expenditures
Transfers
2,616.00 2,616.00
14,595.00 16,238.00
2,616.00 0.00%
10,238.00 0.00%
$ 2 I 7,443.00 $ 219,086.00 $ 225,188,00 $ (6,100.00) -2.18%
Support Services
Personnel Expenditures $ 1,028,558.00 $ 1.028,658.00 $ 1,046,258.00 $ (1 T,T 00.00) -1.72% tinfav. hospitalization due to increase in costs.
Operating rxpenditures 53,828.00 53,828.00 53,828.00 0.00%
Internal Support Expenditures 772,356.00 809,573.00 797,873.00 11,700.00 1.45% Fay. IT Operations.
Transfers - - 0.00%
5 1.854,742.00 $ 1,891,959.00 $ '1,897,959.00 $ (6,000.00) -0.32%
Department Total
Personnel Expenditures $ 1,228,790 00 $ 1,228,790.00 $ 1,252,590 00 $ (23,800.00) -1.94%
Operatong Expenditures b6,444.00 56,444.00 56,444.00 0.00%
Internal Support Expenditures 766,951 00 825,811.00 814,111.00 11,700.00 1.42%
Transfers - - - - 0.00%
$ 2,072,185.00 $ 2,111,045.00 $ 2,123,145.00 $ (12,100.00) -0.57%
5/1212010
1,026,177.00 $
65,484.00
97,956.00
72,400.00
25,000,00
2,500.00
6.59%
27.63%
2.49%
COUNTY OF OAKLAND
FY 2410 SECOND QUARTER REPORT
EXPENDITURES
FACILITIES MANAGEMENT
AMOUNT
ADOPTED AMENDED FY 2410 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures $ 217,309.00 $ 217,309.00 $ 214,809.00 2,500.00 1.15% - Turnover
Operatinig Expenditures 4,596.00 4,596.00 4,596.00 - 0 00%
Internal Support Expenditures 31,732.00 31,732.00 29,232.00 2,000.00 1.88% - Fav. Information Technology Operations based on anticipated usage.
Transfers Out
$ 253,637.00 $ 253,637.00 $ 248,637.00 $ 5,000.00 1.97%
Facilities Engineering
Personnel Expenditures $ 881,268.00 $ 881,268.00 $ 811,368.90 $ 69,900.00 7.93% - Fay due to staff time charged to Oakland County International Airport and
Parks & Recreation projects for engineering services.
Operating Expenditures 85,886.00 85,888.00 60,888.00 25,000.00 29.11% - Fav. Professional Services due to reduced Capital improvement Program activity.
internal Support Expenditures 68,447.00 68,724.00 68,724.00 - 0.00%
S1,035,603 00 5 1,035,880.00 $ 940,980.00 $ 94,900.00 9.16%
Department Total
Personnel Ipenditures $1,098,677.00 $ 1,098.577.00 $
Operating Expenditures 90,484.00 90,484.00
Internal Support Fxperprlittires 100,179.00 100,456.00
Transfers Out
$ 1,289,240.00 $ 1,289,517.00 $ 1,189,617.00 5 99,900.00 7.75%
5/1 2.2010
Administration
Personnel Expenditures
Workforce Management
Posonnel Expenditures
Operating ExpeOditures
$ 1,085,935.00 $ 1,090,439.00 $1,025,739.00 $
5 1,9;38,502.00 $ 1,939,509 00 $1,866,009.00 $
204,995.00 204,995.00 132,295.00 $
5/12,'2010
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
HUMAN RESOURCES
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2010 FAVORABLE
FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 729,218.00 $ 729,218.00 $ 663,718.00 $ 45,500.00 6.24% Savings from underfilled PTNE Deputy Director position. Savings may fluctuate
should Deputy Director increase activity rotated to negotiations with unions that have
yet to settle and others union contracts scheduled for renewal in FY 2011.
Operating Expenditures
Internal Support Expenditures
301,506.00 301,506.00 282,306.00 $
56,211.00 59, /15.00 59,715.00 $
19,200.00 6.37% Favorability primarily in Per Diem Fees $10,700 due to fewer Personnel Appeal
Board I learings, Employee Mod Exams ADA $2,000 due to decline in requests for
exams, reduction in the use of Travel & Conference $4,800, Workshops and
Meetings $500, and a reduction in Membership, Dues and Periodical Books
subscriptions $1,200. Court Reporter Services, Legal Services, and Professional
Services all reflect substantial favorability as of 2nd Quarter. However, due to
pending negotiations, possible arbitrations, arid several contracts due for renewal
with various unions, the favorability will likely diminish to non existent or possibly
require additional funding
0.00%
transfer Out
64,700.00 5.93%
73,500 00 3.79% Due to underfilled positions.
72.700.00 35.46% Savings anticipated in Recruitment Expense $26,000 and Employee Medical Exams
$27.000 clue to hiring freeze. Savings are also anticipated in Membership Dues arid
Periodical subscriptions $1,100, Personal Mileage $1,100, Computer Supplies
$2,000, Expendable Equipment Expense $2,000, and Office Supplies $4,500 due to
cutbacks in usage and purchases. Travel & Conference lower due to decline in
PeopleSoft training $9,000.
Internal Support Lxpei iditures
'Transfer Out
551.057.00 041,51.3.0C 671,a13.00 $ 00,300.00} -4.72% ilnfav. primarily from Information Technology Operation experises ($34,300) due to
increase in rates, offset by fav. in Convenience Copier $1,090, Print Shop $2,000,
and Telephone Communications $1.000 due to decreased activity associated with
recruitment.
$ 7,694,554.00 5 2,786,017.GO $2,670,117.00 $ 115,900.00 4.16%
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
HUMAN RESOURCES
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Benefits Administration
Personnel Expenditures $ 1:5903 00 $ 15.9,C63 no $ 164,963.00 $ (5,300.00) -3.32% Budget reflects funding for Office Assistant I position. However, position is filled wItii
Office Assistant II, which is a permissable equivalent. Employee is at higher rate than
what is budgeted.
Operating Fxpenditures 16,552.00 16,552.00 4.952.00 $ 11,600.00 70.08% Savings anticipated primarily in Office Supplies $4,700, Travel and Conference
$3,700, Expendable Equipment Expense $2,000, Personal Mileage $800, Software
Support Maintenance $300, and Equipmerit Maintenance $100 due to efforts to
rediided spending.
Internal Support Expenditures 176,729.00 176,729.00 176,729.00 $- 0.00%
Transfer Out - -
$ 352,944.00 $ 352,944.00 $ 346,644.00 $ 6,300.00 1.78%
Department Total
Personnel Expenditures $2,827,383.00 $ 2,828,390.00 $2,714,690.00 $ 113,700.00 4.02%
Opeiatirig Expenditures 523,053.00 523,053.00 419,553.00 103,500.00 19.79%
Internal Support Expenditures 782,997.00 877,957.00 908,257.00 (30,300.00) -3.45%
Transfer Out
$4,133,433.00 $ 4,229,400.00 $4.042.500.00 $ 186,900 00 4.42%
- - -
5.12/2010
Administration
Personnel Expenditures 0.00% - $ 199,917.00 $ 198,129.00 $ 198,129.00
Operating Expenditures 4.778,762.00 5,936,343.40 5,833.093.40 103,250 00
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
HEALTH AND HUMAN SERVICES
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2010
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Operalint.) Expenditures 11,345,367.00 12,350,367.00 10,598,477.00 1,751,890.00 14.18% - The Budget includes a carryforward from 1Y2009 for Indigent
Ilospilalization. Favorable Private Institutions $1,751,890
(Michigan Human Services) for costs incurred for the care of
neglected and abused wards of the court. Costs are based on
caseload, difficulity of care, and treatment of services ordered by
the Court. lavorability is partially offset by unfavorable Nun-
Departmental Child Care Subsidy (60% reimbursement).
0.00% - Internal Support Expenditures
Transfers Out
16„457,00 16,4b7.06 16,457 00
$ 11,561,741.00 $ 12,564,953.00 8 10,813,063.00 $ 1,751,890.00 13.94%
Health
Personnel Expenditures $ 23,752,490 00 $ 23,119,799.00 $ 22,549,799.00 $ 570,000.00 2.47% - Favorable due to turnover, and underfilled positions.
1.74% - Favorable Mileage $28,000, Travel and Conference $5,000, I -A
Prop. iiliripment Exp. $20,750, t.aboratory Supplies $45,000 al id
Testing Materials $4,500 all due to efforts to contain costs,
minimize expenses. Further, reductions include additional actions
to increase efficiency and reduce costs.
3,580,376 00 0.00% - Internal Support Expenditures
Transfers Out
4,069,611.00 4,069,611.00
2.03% $ 32,111,628.00 $33,125,753.40 $ 32,452,503.40 $ 673,250.00
5,11220-10
Children's Village
Personnel Expenditures $ 12,767,601.00 $ 12,946,405.00 $ 12,946,406.00 $ 0,00%
$ 3,793,055 00 3,848,755.94 3,842,755.94 6,000.00
(34,661.00) 2,634,817.00 2,675,383.00 2,710,044.00
0.00
Operating Expenclikires
Internal Support Expenditures
Transfers Out
0.16% - Favorable due to the cancellation of maintenance contracts for
time-keeping (Kronos) and case management (Famcare) systems
replaced by support from Information Technology staff.
-1.30% - (Unfav) Radio Communications a budget amendment is
recommended.
ADOPTED
BUDGET
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
HEALTH AND HUMAN SERVICES
AMOUNT
AMENDED FY 2010 FAVORABLE
BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 19,195,473.00 5 19,470,544.94 $ 19,499,205 94 $ (28,661.00) -0.15%
Homeland Security
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Trar islets Out
$ 726,996.00 $ 725,955.00 $ 725,956.00
261,380.00 306,609.50 306,609.50
496,002.00 502,973.00
$ 1,484,378.00 $ 1,535,537 50 $ 1.550,537.50 $ (15,000.00)
0.00% -
0.00% -
-2.98% (1,1nfav) Radio Communications due to pendirg rate adjustment. 517,973.00 (15,000.00)
$ 37,447,004.00 $ 36,990289.00 $ 36,420,289.00 $ 570,000.00
20,178,564.00 22,442,075.84 20,580,935.84 1,861,140.00 8.29%
6,727,652.00 7,264,424.00 7,314,085.00 (49,601.00) -0,68%
- _ - - 100.00%
$ 64,353,220.00 $ 86,696,788.84 $ 64,315,309.84 $ 2,381,479.00 3.57%
.5)1212010
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2010
FORECAST
$ 188,043.00 $ 188,043.00 $ 188,043.00 5
4,800,00 4,80000 4,800.00
6,754.00 6;754.00 6,754.00
$ 199,597.00 $ 199,597.00 $ 199,597.00 $
Public Services - Admin.
Persortnel Expenditures
Operating Expenditures
Internal Support Expenditures
Veterans Services
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 1,366,623.00 $ 1,366,623.00
217.090.00 217,090.00
180,186.00 180,697.00
1,366,623 00 $
217,090.00
180,697.00
$ 1,763,899.00 $ 1764.410.00 $ 1,764,410.00 $
InternEd. Support Expenditures
Transfers
485,820.00 537,155.00 517,155.00
$ 4,589,240.00 3 4,686,099 50 $ 4,636,399.50 $
$ 759,536.00 $ 763,774.00 $ 763,774 00 S
88,897.00 88,897.00 71,897.00
MSU Ext. - Oakland County
Personnel Expenditures
Operating Expenditures
Community Corrections
Personnel Expenditures
Operating Expenditures
$ 3,397,913.00 $ 3,307,913.00 3.377,913.00 $
705,498.00 751,031 50 741,331.50
Internal Supped Expenditures 304,379.00 300,879.00 301,462.00
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPENDITURES
PUBLIC SERVICES
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
0.00% -
0.00% -
0.00% -
0.00%
0.00% -
0.00% -
0.80%
0.00%
0.00%
20,000.00 0.59% - Turnover
9,700.00 1.29% - Fay. Electrical Services $6,500 and Office Supplies $3,280 due
to effort to reduce usage and costs.
20,000.00 312% - Fay, Info Tech Operations $20,000 due to decreased activity.
- 0.00% -
49,700.00 1.06%
0.00% -
11,000.00 19.12% - Fay. Professional Services $3,000 due to the use of MSU
Extension educators from other counties that don't charge fees
for teaching Master Gardener classes, Also Fay. In Workshops
and Meetings $14,000 due to a change in the Master Gardener
Volunteer Program registration. A budget amendment is
recommended to recognize favorable expenditures in
Workshops and Meetings and used to offset unfavorable
revenues.*
3,500.00 1,15% - Fay, Motor Pool $1,500 arid Convenience Copier $2,000 due to
decreased activity.
S 1,149.805.00 $ 1,157,050.00 $ 1,136,550.00 $ 20,500.00 1.77%
• So related ruvpsi ffset. 511212010
COUNTY OF OAKLAND
FY 2010 SECOND 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,063,031.00 $ 3,063,631.00 $ 0.00% -
Operatmg Expenditurus 521.788.00 623,038.00 533,038.00 90,000.00 14.45% - Fav. Laboratory Fees $90,000 due to estimated costs for
workload net as high as expected.
tornal Support Expenditures 1,028,971.00 1,024,153.00 1,022,153.00 2,000.00 0.20% - Fay Print Shop $2,000 due to decreased activity .
1-1811s1ers
$ 4743,29400 $ 4,710,822.00 $ 4,618,822.00 $ 92,000.00 1.95%
Animal Control
Personnel Expenditures $ 1,661,152.00 $ 1,661,152.00 $ 1,547,052.00 $ 114,100.00 6.87% • Fav. Salaries and Fringe Benefits $90,000 duo to under -filled
positions, Overtime $20,000 and Hoilday Overtire $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 164,967.00 154,967.00 154,967.00 0.00% -
Internal Support Expenditures 660,744.00 742,675.00 699,199.00 43,476.00 5.85% -
'1 ransfors
$ 2,476,863.00 $ 2,558,794.00 $ 2,401,218.00 $ 157,576.00 6.16%
Circuit Court Probation
Personnel Expenditures $ - $ - $ - $ - 000%
Operating Expenditures 40,798.00 44,628.00 44,628.00 - 0,00%
Internal Support Expenditures 568,038.00 569,500.00 569,500.00 - 0.00%
$ 608.336.00 $ 614,128.00 $ 614,123.00 $ 0.00%
Dapartment Total
Personnel Expenditures $ 10,565,802.00 $ 10.441,136.00 $ 10,307,036.00 $ 134,100 .00 1.28%
Operatrng Expenditures 1,733,838.00 1,884,451.50 1,767,751.50 116,700.00 6.19%
Internal Support Expendilures 3,231,984.00 3,365,313.00 3,296,337.00 88 ,976 00 2.05%
Transfers
$15,531,624.00 $ 15,690,900 50 $ 15,3/1,124.50 $ 319 776.00 2.04%
• See related revenue offset. 5,12/2010
ADOPTED
BUDGET
AMENDED
BUDGET
Workforce Development
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
5 25,620.00 5 25,620.00 5 25 620.00 $ 0.00%
149.000 00
306,300.00
42,000.00
0.00%
3.11%
16.15%
3.95%
0.00%
5 7 289,434 00 $ 1,689.248 00 $ 1.191,948.00 5 497,300.00 6.47%
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
EXPFNDITURES
ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS
AMOUNT
FY 2010 FAVORABLE
FORFC.AST (UNFAVORABLk) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
F (misters
$ 1,097,503.00 $ 1,097,503.00
228,059.00 291,919.00
82,156.00 92,878.00
100,000 00
$ 1,407,718.00 5 1,588,300.00
$ 116,800.00
19,400.00
.'92,878.00
100,008 00
_
$ 1,452,103 00 $ 136,200.00
10.64% - Turnover
6.51% - Fay. Outside Printing due to use of County Print Shop and fay
Personal Mileage eased on usage requirements.
0.00%
8.56%
$ 980,703.00
278.519 00
Planning anti Economic Development Services
Person riei Ex.pendrtures 5 3,548.65a60 $ :3,574.104.00
Operating Expenditures 1.345,210.00 1.530,21G 00
962,228 00 911,014 00 929,01400
0.90% - turnover
18.Th% Pay. Operating 5151,300 for update of Solid Waste 'Management Plan
which is delayed pending reformatting of plan guidelines by the Slate,
primarily professional Services. Advertising, Printing, Legal Services,
Travel & Conference, and Membership Dues. Also fay. Business
Recruiirrient $55,000 due to fewer business recruitment missions for
senior management than anticipated and a higher level of local activity
with business retention and e.xpansion work; Professional Services
$50,000 due to reduced professional services for development of
Marketing materials and greater utilization of electronic formatting ;
Printing $9,500 due to exclusive use of the Print Shop; and Freight
Express 55,000 arid Drafting Supplies & Maps 5,000 based on expected
usage..
42,060.00 4.33% - Pay IT Operations based on current charges. Internal Support Expenditures
$ 3 541,904 00 5 32,20000
1,243 310.00 288,900.00
$ 5..856,006 CO 5 6.075,328.00 $ 5 714,228 Oci $ 351,100 00 5.94%
Community and Home Improvement
Personnel Expenditures
Operating Expen0Aures
Transfers
- $
Department Total
Personnel 5xpenditures
Operating Expenditures
Internal Support LKpendituws
I ransfers
$ 25,620.1.70 $ 25,620.00 $ 25,620.00
$ 4.691,227.00 $ 4,648,221.00
1,828,129.00 1,021.829.00
1,063,592.06 1.0 -21,892.00
130,000.00 1110,000 00
5 4,611,781.00
1 573,269.00
1,044,381.00
0..1 212010
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
5700%
0.00%
0.00%
0.00%
0.00%
.49.58% - Fay. less departments requesting neiiv programs.
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.51%
0.00
0,00%
0.00%
5112/2010
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
NON-DEPARTMENTAL EXPENDITURES
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE1 PERCENT EXPLANATION
NON-DEPARTARTMENT APPROPRIATIONS
COUNTY OPERATIONS
Insurance Fund $ 180,424.00 $ 180,424.00 $ 180,474,00 0.00%
tnsurance Surety Bonds 16,900.00 16,900.00 16,90C 00 0.00%
- Miscellaneous • . 0.00%
Logos arid Trademarks 30,000.00 30,000 00 30,000.00 0.00%
Road Cur iirnissior ISCurrent Drain Assessment 1,400,000.00 1,701,000 00 1,701,000 00 0.00% -
Road Commissionqd Party Agreement 100.00 100.00 100 00 000%
Provisions 30,000.00 30,000 00 30,000 00 0.00%
Telephone 14,000.00 14,000.00 14,000.00
Transfer to CMHA 9,620,616.00 9,620,616.00 9,620,616 00 0.00%
Total 5 11,292,040.00 $ 11,593,040.00 $ 11,593,040.00 $ , 0.00%
COUNTY BUILDINGS $ 2,894,173.00 $ 2,597,558.00 $ 2,597,558.00 0.00%
STATE AND FEDERAL - COUNTY ASSOCIATIONS
Area Wide Water Quality $ 55,000.00 5 55,000 00 $ 55,000.00
Assoc of Metro Sewage Agencies 1,700.00 1,700.00 $ 1,700.00
Michigar I Ft1.3(.1C. of Counties 70,700.00 70,700.00 $ 70,700.00
National Assoc. of Counties 24,000.00 24,000 00 5 24,000.00
S.E.M.C.0.0. 579,000.00 579,000 00 $ 579,000.00
Traffic Improvement Association 30,000.00 30.000.00 30,000.00
lotal 3 700,400.00 5 760,400.00 5 760,400.00 5
SUNDRY EXPENSE $ 300,000.00 $ 300,000.00 $ 300,000.00
RESERVED FOR TRANSFERS
Expenditures
Admiristrative Leave $ - S - $ -
Budget Transition 19,006,090.00 19,388,411 00 19,388,471.00
Classification and Rate Change 171,871.00 165;121.00 165721.00
Contingency 301,911.00 302,534.60 152,534.00 150,600.00
Emergency Salaries 1,309,945.00 912,111.00 912,111.00
Grant Match 1,989,437.00 1,655,351.00 1,655,351.00
biro Tech Develup rier it 5,803,133.00 3,286,479 00 3,286,429.00
Legislative Expense 120,400.00 120,400.00 120,400.00
Misc. Capital Outlay 75,000.00 63,330 00 63,330.00
Overtime Appropriation 53,000.00 53,000.00 53,000.00
Summer Employees Salary Appropriation 269,766.00 259,766.00 259.706 00
Fotal $ 29,090,559.00 $ 26,207,113.00 $ 26,057,113.00 $ 150,000.00
Traiisfers to Other Funds
Jail Population Management Fund
‘41/4.::•.‘ Capital & Cooperative Initiatives Revolving Fund
90. xls
90.:Kis 5/12/2010
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPOR
NON-DEPARTMENTAL EXPENDITURES
AMOUNT
ADOPTED AMENDED FY 2010 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
Debi Service - West. Wing Refunding 1,458,768.00 1,458, /68.00 1 .458,768 00 0.00%
Projemt Work Order f-und 0.00 0.00%
t ire Records Management 413,99/.00 413,99T 00 413,99/.00 0.00%
Radio Colorminicaiions 135.510.00 135,510.00 135,510.00 0.00%
CLEM'S 1,208,186 00 1,208,186,00 1,208.186.00 000%
Information Tectinolcgv 1,131,143,00 1,131,143.00 1,131.143.00 0.00%
Facinties Ma inonarice & Operaticins C CO 0.00 0.00 0.0()%
$ 4,347,604.00 $ 4,347.604,00 $ 4,341,604.00 $ - 1100%
TO IAL NON-DEP E. APPROPRIATIONS $ 48,684,776.00 $ 45,805,715.00 $ 45,65-5,715.00_ $ _ 150,000.00
EXPLAN TION
TRANSFER TO GENERAL PURPOSE FUNDS
Public Health Fond $ 24,395,153.00 $ 25,624,209.00 $ 25,624,209,00
Child Care I und 22,830,133.00 23.047,504.00 23.04(504.00
Social Welfare Fund Foster Care 1,000.00 1,000.00 1.003.00
$47,226,286.00 $48,672,713.00 $48,672,713.00 $
0.00%
0.00%
0.00%
0.00%
TOTAL EXPEND! TURES S 95 911 062 00 94,478,428.00 $ 94,328,426.00 $ —
150,000.00 0.16%
FY 2010 BUDGET AMENDMENTS
FY 2010 BUDGET AS ADOPTED - GENERAL FUND/GENERAL PURPOSE FUNDS $ 409,835,938.00
BUDGET AMENDMENTS
MR. #09236 - 10/14/2009 S 49,500.00
Heath Division - Intergovernmental Agreement with Oakland Schools for Infant Toddler
Assessments
S (325.206.00)
$ (124 747.00)
(2.000.00)
M.R. #09250 - 10129/2009
Health Division - 2009/2010 Comprehensive Planning, BJcigeting and Contracting (CPBC)
M.R. #09239 - 10/29/2009
Sheriff's Office - Contract Amendment #2 for Law Enforcement Services in Rochester Hills
M.R. #09273 - 11/12/2009
Circuit Court - Juvenile and Adult Drug Court Combined SCAO Grant
M.R. #09290 - 12/9/2009
M&B FY 2009 Year End Report
Encumbrances $ 234.678.15
Carry Forwards $ 2,881.575.00
Appropriation cf Designation - CRIMP funds 38,522.00 $ 3 54.775.15
MR. #09307 - 12/9/2009 $ (225,848.00)
Sheriff - Patrol Contract with Oakland Township
M.R, #09305 - 12/9/2009 S (581,087.00;
Sheriff - Patrol Contract with IndePendence Township
$ (244 ,040,00)
$ (229.849.00)
112.180.00
170 237.00
(4.500.00)
15.000,00
9.525.00
122.023.00
$ 244.040.00
3 :2.75.00
M.R. #09304 - 12/9/2009
Sheriff - Patrol Contract with Highland Township
M.R. #09303 - 12/9/2009
Sheriff - Patrol Contract with Commerce Township
M.R. #09313 - 12/912009
Sheriff - Patrol Contract with Rochester Hills
M.R. #09288 - 12/9/2009
Management and Budget - Equalization Contract with Orion Townshiop
M.R. #09274 - 12/9/2009
FIHS Health Division - Efficiency and Cost Reductions
M.R. #09280 - 12/9/2009
Prooate Court/ Sheriff - Pot Project IT interactive Video
MR. #10010 - 1/20/2010
Sheriff - ORV Safety Education Program
M.R. #10008 -1/20/2010
Sheriff - Patrol Contract 'with Highland Township
M.R. #10009 - 1/2012010
Sheriff - Patrol Contract with independence Township
M.R. #10001 - 1/20/2010
Health ono Human Services - Childrens Village Fresh Fruit and Vegetable Program
FY 2010 BUDGET AMENDMENTS
517.03
55,000.00
.375.00
6,754.30
M.R. #10003 - 112012010
Health and Human Services - MDEC
M.R. #10018 - 2102/2010
Health and Human Services - Kellogg Nurse ramly Partnership
MR. #10020 - 210212010
County Clerk - Eiecticins Division Board of Canvassers Agreement Oakland, Orion and Oxford
M.R. #10055 3/25/2010
Healn and Human Services - Kellogg Nurse Family Partnership
M.R. #10051 - 3/2512010
MO FY 2010 First Quarter Report
Pros. Attorney/Clerk - Enhance. Funds/ Forfeiture of Bonds
Children's Village - Adj Revenue est for Chita Care State aic
Media Examiner - Acfj Revenue est for Service Fees
Sheriff - Enhancement Funds - Drug Forfeiture/NET Grant
Economic Development - Accent Donation
Community Corrections - Fee income
on Dept - Adj Revenue est for Indirect Cost
$ (99,807.00)
46 129.00
(5,000.00)
$ 100,000.00
20,000.00
$ (200,000.00)
$ 535,533.00
$
TOTAL AMENDED BUDGET AS OF 3131/2010 $ 412,440.615.15
REVENUES
Charges for Services $20,000,000.00 $20,000,000.00 $24.500,000.00 $4,500,000.00
(7E0,000.00) -21.79% Unfav. variance due to decrease in projected irivestment base
$3,800,000.00 16.37%
0.00%
24.83% Fad. variance is due to Indirect Costs being lower than anticipated.
0.00%
-4.22% Unfav. variance is due to more than anticipated amoarits assessed
in collection fees. Collecton Fees are recorded in the DTRF and
transferred to the Treasurer's General Fund Budget at year end.
There is favorable revenue projected in the General Fund to offset -
unfavorable variance in DTRF.
0,00%
0.00%
0.04%
0-00%
(189,782.00) -0.60%
$ (75,562.00) -0.23%
$3 [24.418.00
114,200.00
(189,782.00)
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
ENTERPRISE FUND
TREASURER'S OFFICE
ADOPTED
BUDGET
DELINQUENT TAX REVOLVING FUND 51600
AMENDED
BUDGET
FY 2010
FORECAST
VARIANCE
FAVIIUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
22.50% Fav. variance due to the increase in delinquencies. Collection fees
arid interest are assessed on delinquent taxes. which have
increased.
3,212,900.00 3,212,900.00
$23,212,900.00 $23,212,900.00
Cther Revenues
Total Revenues
OPERATING EXPENSES
Personnel Expenditures
Operating Expenditures
Interest Expense
transfer Out to Other I-unds:
General Fund - Collection Fees
GE - Non-Departmental
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
REVENUE OVER (UNDER)
EXPENDITIIRES
Total Net Assets - Beginning
Total Not Assets - Ending
$ 97,308.00
460,000.00
1,500,000.00
4,500,000.00
21,650,000.00
1,862,625.00
2,096,852.00
1,385,600.00
31,495,077.00
$ 33,552,385,00
($10.339,485.00)
$ 97,308.00
400.000 00
1,500,000.00
4,500,000.00
21.650,000.00
1,862,625.00
2096.852.00
1,385,600,QQ
31 495,077.00
$ 33,552,385.00
$10,339,485.00t
2,512,900.00
$27,012,900.00
01,308.00
365,800.00
1,500,000 00
4,689,782.00
21,650,000.00
1,852.625.00
2,096,852.00
1,385,69Q,QQ
31,684,659.00
$ 33,627,967.00
$229,351,629.91
Ending FY 2010 Designated Fund Balance
Designated - Debt Service
Designated - Deli:1g Taxes Receivable
Designated - Collection Fees
Undesignated - Fund Balance
Total Not Assets - Ending
$72,568,273 84
105,909,116.47
15,000,000.00
V9,259,172,60
122222§562,91
DIRF #51600 Quarterly Forecast.xls 5[12,2010
1/4.-P••
4714-
5,1212010
COUNTY OF OAKLAND
ry 2010 SECOND QUM? TER REPORT
ENTERPRISE FUND
PARKS 8. RECREATION
ADOPTED AMENDED FY 2010 VARIANCE
BUDGET BUDGET FORECAST FAV1(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
[
OAKLAND COUNTY PARKS &
RFCRFATION COMMISSION (50800)
OPFRATING REVLNUE $ 6,906,205.00 $ 8,008,2&h.00 $ 8,908,2E5.00 $ 0.00% Revenue is seasonal with the majority of activity occurring in Ihe third and fourth
quartor-5,
OPERATING EXPENSE $ 2E783.80/.00 $ 26,783,807.00 5 28,583,807.00 $ (1,800,000.00) -fi 72% Operating Expenses are not expected to vary from the budget at this time.
However, a budget amendment is recommended to increase the contingency
account by 51.800,000 to recogrive operating nxpenses for the F Y 2010 IT Ntaster
Flan (year 2 of 3). —
NET OPERATING INCOME (LOSS) $ (17.S75,542.00) S (17,875,542.00) $ (19,67.5,542.00) $ (100,000.00) -10,07%
NON-OPERAT iNG REVFNUF $ 14,425,725.00 5 14,425,725.00 5 14,425,725 00 5 - 0.00% Fiscal Year 2010 property tax revenue for Parks and Recreation is based on 2009
(EXPENSE) Taxable Value (December, 2005 levy). The Rax cellectica forecast equals the
amended budget at this time.
TO f AL INCOME BET OFF TRANSFERS $ (3 ..449,817.00) $ (3,449,817.00) $ (5,249,.817.00) 5 (1,800,000 00) -52.18%
TRANSFERS IN $ 0.00%
CAPITAL IMPROVEMENI PROGRAM $ (260,283.00) $ (260283.00) $ $ 260,283.00 100 011% A budget amendment is recommended for $1,800,000 for FY 2010 IT Nlostar Plan
(year 2 of :3) operating expenses and for (5260,283) lb re-appropriate funds to
properly budget for capital related expenses arid properly recogni2e the Fund
Equity reduction.
TOTAL NE-I INCOME- FLOSS)" $ 0,710,10M_ $ T.1_11,100 (29i $ (5,249,817 00) ..:1241.72.a
TOTAL ra_ I A.SSE FS bEGINNING $94,235,354.91
TO fAL NI I ASSETS ENDING 68.985,537.9
'Please note: In the Budget thz is the "Planned Use cf Balance" Revenue line item. The $5,249,817 is comprised of:
• Non-cash Depreciation of $3.710.100 included in the Operating Expense category (these expenses do not decrease cash which leaves cash available for FY 2011 Capital Improvement Program)
• Fund Equity reduction 01 $1„539,717 (net adjustment for operating costs that decreases cash funds available for F. 1' 2011 Capital Improvement Program)
NET INCOME (LOSS) BE-ORE (67,000.00)
NON.OPrRATING RFVFNUF.l(FXPFNSP) 67,900.00
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
INTERNAL SERVICE FUND
WATER RESOURCES COMMISSIONER
ADOPTED AMENDED FY 2010 VARIANCE
BUDGET BUDGET FORECAST FAV1(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
PAIN EQUIPK-1ENT FUND( 63900) I
OPEKA-IING REVENUES:
Inside $4,268,263 00 $4,274,203.00 $4,391,328.00 5117,005,00 2.74% Fav Rebelled Charges $94,000 a result of rebill charges to the CAMS Project for the
CV T 'a data conversion component. Fay - Vehicle Rental $2:1,065 due to second
quarter budget amendment to replace 1 owhed vehicle to leased vehicle.
Outside 252,000.0G 252,000.00 252,000.00 $0.00 0.00%
Total Revenue 4.520,263.00 4,526,263:00 4:643,328.00 -- 117,665.0T 2 59%
OPERATING EXPENSES 4,588,163.00 .4,594,163.00 4,638,514.00 (44.351.00) -0.97% Untav - Equipment Repair Motor Vehicle ($16,000) the result of actual spending
being more than anticipated budget projection. Unfav - Information Technology
Development ($5,000) for maintenance performed on the Automatic Meter Reading
system Unfav - Maintenance Department Charges ($15 ..897) for billing charges ID
Ihe different internal departments for SCALIA equipment. Unfav - Motor Pool
($3.450) second quarter budget amendment for the rental cost to replace 1 owned
vehicle to leased vehide. Unfav - Radio Communications .;.$1,264) based on under
estirnaied hudgel forecast compared to actual spending
(67,000.00) 4,814.00 72.714.00 107.09%
67,900.00 59,132.00 (8,168.00) 42,03% Unfav - Accrued Interest Adjustment ($2231 for accrued booking adjustment for
investment income. Unfav - Income from investment ($7,045) the result of account
rid t uarriiwig any return due ID the negative cash balance from the replacement of
vehicles.
TRANSFER IN 0.00
TRANSFERS (OUT) 0.00
NET HLVENUES OVER(UNDER) $0.00
EXPENSES
[ AE NET ASSETS BEGINNING
TOTAL NET ASSE TS ENDING
0.00 0.00 0.00 0.00%
0.00 19,615.00 (19,615.00) 0.00% Unfav - Transfer Out ($19,615) the result of a second quarter budget amendment for
the replacement cost of 1 owned vehicle to leased vehicle
$0.00 $44.931 00 $44,93 I .00
:i,366,812 26
$3,411,743 25
5f12,2010
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
INTERNAL SERVICE FUND
RISK MANAGEMENT
ADOPTED AMENDED FY 2010 VARIANCE
BUDGET BUDGET FORECAST FAW(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
[LIABILITY INSURANCE FUND 67700 —1
OPERAT II' FiEVENUEEi
Ouisitle Re ve aue - s - $
Inside Rovierwe 2,375,561.00 2,3?5,561.D0 2.3 /5,t3€31.00 $ 0.00% -
Total Operating Revenue $ 2.875,561.00 $ 2.817e,561.00 $ 2,315,6E1.00 $ 0.00%
OPERATING EXPENSE 2,484.053.00 $ .2,484,053 00 $ 2,E01,853.00 $ (17,000.00) .0 1" - Unfav. hospitalization ($1.400) due In increae in costs, inditect
costs ($1,700) due to actual charges developed slier budget
finali.calion and a:weldable equipment ($14,700) One to purchase of
Defibri]lators
(3 AIMS PAID 291,508 00 291,508.00 211:31,508 00 5
tOTAL CIPFRATING EXPENSFS S 2.775,b61.00 5 2,715,501.00 $ 2,193,361.(kr $ (17,800.00) (l 07%
OPERATING INCOME (LO551 (400,000.00) (400,000.00) (417,860.00) (17,800.00l
- NON OPERATING REVENUE (EXPENSEI 400,1000.00 400.0U0 00 400,000.00 0.00%
NET REVENUES OVERi(UNDER)
1,1)(PFNSES - S (17,800.00) S. (17,800 60)
IOTA!. r4ET ASSETS - BEGINNING 15,872.:584..20
TCYI At NET ASSETS - NDING S 15.854.704 29
5112 ,120 TO
EXPLANATION OF SIGNIFICANT VARIANCES
TOTAL NET ASSETS BEGINNING
TICIAL NET ASSE IS - ENDINC5
3,084,012.11
$3, .012 880.11
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
INTERNAL SERVICE FUND
MANAGEMENT AND BUDGET
ADOPTED AMENDED FY 2010 VARIANCE
BUDGET BUDGET FORECAST FAVAUNFAV) PERCENT
OFFICE FUND 64156--1
ul,LRA I ING REVENUE INSIDE $ 77,7D7..00 $ /9 /1111 $ 776,797 00 $
OPERAIING EXPENSE 910,992.00 910,992.00 932,929.00 $ (21,900.00k -2..40% Un(av. indirect costs (521,900) due to actual charges
developed after budget finalization.
OPERATING INCOME (LOSS) (134,195 00;_ (134,195.0a (1b6,137 LJOI (71,900.00L
NON-OPERATING REVENUE (EXPENSE) 3f),000.00 35,000.00 35,000 00 S 0.00%
NEI INCOME (LOSS) BEFORE
OPERATING TRANSUERS
OPERATING TRANSFERS IN
(99,195.00) (99,195.00) (121,137.00) (21,900.00)
50.000.00 50,000.00 50,000.00 $
NFT REVENUE OVERF(UNDER)
EXPENSES (PLANNED USE OF FUND BAL) _$49,195.00) 411.2.1195.00 ($71,132.00) ($21,9100.00)
5112"2010
:{1-1GE--FiENEF ITS FUND 67800
FY2010 VARIANCE
FORECAST FAVTUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
AMENDED
BUDGET
ADOPTED
BUDGET
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
OPERATING REVENUE
RETIRE ES MEDICAL - VEDA CEBT
RETIREMENT ADMINISTRA [ION
DEFINED CONTRIBU I ION PLAN
DEFINED CONTE-0E311110N PLAN - FINE
DEFERRE 0 COMPENSATION COUN y
EMPLOYE E IN-SERVICE TRAINING
EMPLOYEE BT NET ITS UNIT
'TUITION REIMBURSEMENT
RETIREMENT HEALTH SAVINGS
GROUF' LIFE INSURANCE
SOCIAL SECURITY
MEDICAL INSURANCE
DENTAL INSURANCE
visioN INSURANCE
DISALTli ITY INSURANCE
SHORT-TERM DISABILITY
WOO:MFRS C; OMPENSA I ION
UNEMPLOYMENT COMPENSATION
INVES FM[ NT INCOME
T -FLEX BEN LIFE INSURANCE
EXT FLEX BIN DENTAL INSURANCE
EKE - F LEX BEN VISION INSURANCE
[-Kr - FLEX BEN MEDICAL - EMPLOYEE
EXT - MEDICAL INSURANCE
EKT - DET‘ITAL INSURANCE
EX T - VISION INSURANCE
EXT FORFEITURE OF DEPOSE IS
IK7 OTHER REVENUE- ICMA REBA FES
ExT PRESCRIPTION DRUG REBATES
DEFERRED COMPENSATION - AMAIN
FLEX BENEFIT PLAN
FRINGE BENEFITS
WELLNESS UNIF
EXT - TRAINING
Exr - CHILD CARE FACILITY
Exi. - WELL NESS PROGRAM
10-IAL REVENUE
49,046,8E113 49,046.688 49,046,888 0.00 0.00%
2.222,113 2,222.113 2,222,113 0.00 0.00%
1:1,99t,800 13,997,800 14,001,300 503,500 3.E0% - Favorable 503,500 due to settlement of bargaining units 09 and 10.
170,000 175,000 'I 75,000 0.00 0.00%
300.000 300,000 10,100 (289,900) -96.63% - Unfavorable due to County $300 match ending 12;31109.
1,421,262 1,421,282 1,421,282 000 0.00%
617,581 511,081 617,561 0.00 0.00%
300,1100 300,000 100,000 0,00 0.00%
425,000 425,000 451,000 32,000 l 53% - Favorable due to increase in number of empIrr.,rees saving $50 per pay
643,400 643,400 /08,000 64,600 10.04%
15,500,00(1 15,500,000 15,008,000 408,000 2.83%
32,695.000 32,695,000 34,000,000 1,305,000 3.99%
3,050,400 3,050,400 3.022,000 (28,400) -0,93%
177,500 117,500 185.400 7.000 4.45%
752,600 752,600 633,000 (119,100) -15.83%
1,493.600 1,.493,600 1,566,600 93,000 6.23%
2,662,248 2,662,248 2,662,248 0.00 0.00%
450,000 450,000 450.000 0 CIO 0.00%
1,540,960 1,540,960 1,000,300 (540,6d0) -35.08% - Unfavorable due to lower interest rates.
400,000 400.000 365,000 (.35,0 lit -8.75%
115,000 115,000 90,300 (24,7 0:I -21.48%
105,000 105,000 103,201) (1 ,8 0) -1 .71 %
3,540,000 3,540,000 4,466,800 928,8 0 26.24% .- I-two-able due to increase in COBRA rates.
2/5,000 275,000 282,100 7,1 0 2.5 %
25.000 25,000 21,000 2,0 0 8.0 %
2,500 2,500 1,900 (6 0) -24.01%
10,000 10.000 10,000 0. 0 0_0 %
0.00 200,000.00 200.000 0. 0 0.0 %
465,000.00 465,000.00 465,000 0. 0 0.00%
04,600 64,800 64.800 0. 0 0.0P%
200,000 200,000 181,000 (19, 0
101,233 101,233 101,233 0 0
490,064 400,054 490,064 0. 0 0.q3%
000 000 0.00 0. U 0.00%
0 00 0 00 7,200 7, 0 0.00%
000 0.00 0.00 0. LI . 0.00%
133,264,969 133,464,969 135,764,909 2,300, 0 1.72% - Favorat,le $2,124,200 duo to settlement of bargaining units 09 and 10.
- Favorable $408,000 due to the settlement o f bargaining units OD and 10
- Based on use of Blue Cross illustrative rates and premiums for Health Alfiarrcc Flan.
Based on use of Delta Dental illustratwe rates
.Based on use of Blue Coss illustrative rates
- Unfavorable based on second quarter actual
FRINGE bENFEITSAls 0,12;2010
AMENDED
BUDGET
17,590,000
31,456,888
2,222,113
14,197,800
'I 75,000
300,000
64,800
716,718
1,071,282
350,000
617,581
300,000
1,043,400
15.500.000
28,500,00p
0 010
8,475,000 00
3,190,00
285,0
2,246,2
2.662,2
i 450,0 0
200,0 0
101,2 3
251,0 0
300.0 0
425.0 0
490,064
283,212
133,464,969
0
0
8
'1 7,590,000
31,456.888
2,222 113
15,530 000
L 1'5,000
11,400
64,800
716,118
1,071,282
350,000
617,581
300,000
1,215,000
15,763.000
28,800,000
1,9
9,220,0
3,190,4
285,0
2,220 1
2,012,3
982,6
153,8
101,2
251,0
320,6
448,7
450,0
292,71
136,460,269
17,590,000
31,456,880
2,222,113
I 3,991,800
1 15,000
300,000
6.1,800
716,718
1,071,282
356,000
617.581
300,1.1)0
1,043,400
15.500,006
28,500,000
0.00
1 8,475,060. 0
3,196 4 0
285,0 0
2,246,2 0
2,662,2 8
450, 0
200,0 0
101,2 3
251,0 0
300,0 0
425,0 0
490,0 4
283,212
133 264,969
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
ADOPTED
BUDGET [FRINGE NEFS ND 67800
OPERATING EXPENSE
FY2010 VARIANCE
FORECAST FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
0.00%
0.00%
0.00%
-9.43% - Urfavorzble (Si ,338,200) due to settlement of bargaining units 05 and 10.
1
-ETIRFFS MEDICAL - VEBA DEBT 'PRINCIPAL
El-IRE:FS MEDICAL - VFBA DEBT INTEREST
FT IR E-MENT ADM1N IS IFIATION
LF-INED CONT RIELLU ION PLAN
FINL D CON F RIBUT ION PL AN - P FNE
EFFEzm o COMM NS ATION - COUNTY
EFERRED COMPENSATION - ADMIN
CI( AND ANNUAL LEAVE CASH-CUT
14PLOYEE IN SERVICE TRAINING
!-SERVICE TRAINING - INFO T ECh I
1IENEFI15 UNIT
ailoN141.11,11:1URS'LMINT
GROUP 111-E INSURANCE
SOCIAL SECURITY
MEDICAL INSURANCE
HOSPITAL IZATION MEDICARE REIMB
PRESCRIPT ION COVERAGE
DENTAL INSURANCE
VISICN INSURANCE
DISABILITY tNSURANGE
WORKERS COMPENSATION
UNLMPL OYME.N T COMPENSATION
FLEXIBLEEENEFI I PAYMENTS
ACCOUNTING SERVICES
CHILD CARE FACILITY
PROFESSIONAL SERVICES
RETIREMENT HEALTH SAVINGS
WELL NESS PROGRAM
INDIRECT COSTS
TOTAL EXPENSE
0.0
0.0
(1,338,201)
0.01 %
208,60 96.2 % - Favorable due to County $300 match ending 1231/09.
0.(i 0.0%
6.0 I 0.0 %
0.0 0.0 %
0.0%
00%
(171,6 ) -16.4 % due to increase in basic Ida insurance rates from .189(1000 or .25011000.
6 0.
0. 0.0 %
1263,0 r) -1.71% - Unfavorable ($093,900) due to settlement of bargaining units 09 and 10, also
- Favorable $330,900 due to Soc. Security tax alternative for PTNE employees (MR#0727
(300,00 ) -1.05% - Unfavorable due to increase in Blue Cross Blue Shield claims.
(1,90 1 0.00%
(745,0 ) -8.79% - Unfavorable due to increased pharmacy claims and admin fee from 2.25 to 2,32.
0. ow%
o. 0.00%
26,1 El 6% - Favorable due IC decrease in long term disability rates from .36/100 to .33/100.
45.9 1.87% - Favoiable excess workers comp insurance due to single broker on a fee bass.
(532,6 '1 -118.36% - Unfavorable due to federal stimulus package allowing additional weeks and FINE
46,2 23.10% and summer employees collect:rig after working their 1,000 hours.
0. 0.00%
0. 0.00%
1 )
(20.6 } -6.87%
(23,7 ) -5.58%
0. 0.00%
-3.35% t
(2,995,3 ) -2.24% - Unfavorable ($1,934,600) due to settlement cf bargaining units 09 and 10.
0.00 NE F REVENUE OVLHAUNDER)EXPE-NSES
TO FAL NE :1 ASSETS- BEGINNING
FOIAL ASSE IS - ENDING
0.00 (695,300) (605,30Q1
12,141,361
_ 11,446,061
Q3 FRINGE BENEF I rs.xls 01122010
OPERA] INC; REVENUE $5,45 T,064.00 V1,457,064.00 $4,361,004.00 ($1,098,000.00)
165,000 00 OPERA IING EXPENSE 5,164.708.00 5,599,708.00 5.595,141.00
302,62% ($931,000.00;
NON OPERATING REVLNUF (EXPLNSE) 3.584.00 000 C.00% 3,584.00 1584.00
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
ENTERPRISE FUNDS
CENTRAL SERVICES
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2010
FORECAS
VARIANCE
FAVi(DNFAV) PERCENT EXPLANATION OF SIGNiFICATIT VARIANCES
[
OAKLAND cOUNTy IINTERNATIONAI
AIRPORT' (5650LIe
-20.08% Unfavorable T-Hangar Rental ($550,000) due io a decrease in the mintier of
T-Hangars Imaseci, Aviation Gas i550(J,000), Landing ree Concesigr,
($20,000), Landing Fees (S16,000 said Car Rental Concession ($5(1,000) as
a resLit of less traffic and downturn in the economy.
2.86'4, Unfavorable Overtime ($10,000) and the fringe benefits associated will it duo
to personnel needed to clear heavy snowfall, offset by Favorable Property
Taxes $80,000 due to lower than anticipated property taxes for T-Hangars,
Managing Services $75,000 due to less than anticipated management
service needed at the OaklandiSouthwest Airport and U.S Customs Service
$20,000 due to one less inspector needed to perform the service.
($138,677.00) NE I OPERATING INCOME (LOSS) ($307,644.00) (51,238.644.00)
IQ I Pd INCOUL BEFORE
CON RIBUTIONS AND TRANSFERS
11-tMSFERS IN
CAPITAL CONTRIBUTION
TOTAL NET INCOME (LOSS /
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
($135,093.00) ($304,060.00) $ (1,235,060.00) t$931,000.00)
0.00 0.00 0.00 0.00
135,093.00 _ 804,06C.00 304 06C.00
$0.00 .193-...10.0(..1, _ ($931 000.001
$ C7,549,813.00
7$R.67.13:56-
$0.00
0.00%
5(12.21 I
[ildlOTOR?OOL FUND 66100 —1
OPERATING REVPNUF:
Outside Revenue
VARIANCE
FAV)(UNFAV)
126,486.00 $ 126,486.00 $ 42.986.00 $ (83,500.00)
PERCENT
-66.02%
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2010
FORECAST
Inside Revenue 8,123,1338.00 8,057,994.00 6,874,194.00 $ (1,183,800.00 )
240,000.00 90,000.00 $ (150,000.00) 240,000.00 -62.50% - Unfav, gain on sale of vehicles ($150,000) due to sale
proceeds less than salvage value and increase in the mileage
driven tram 85K to 100K before replacing.
NON-OPERATING REVENUE
(EXPENSE)
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS
CENTRAL SERVICES
EXPLANATION OF SIGNII-ICANT VARIANCES
Unfav. reduced external other revenue ($63,006), parts and
accessories revenue ($5,5001, and productive labor revenue
($14,500) due to CVT services less than expected.
-14.69% - I nfav. decrease in fuel revenue ($498,000) due to decrease
I led costs arid departments reduction of fuel usage, offset
y the fay. gasoline charges: decrease in leased equipment
$538,000) due to 32 vehicles turned in by departments,
eduction in vehicle miles driven, arid delay for replacement of
ew vehicles; reduced productive labor ($25,000), sublet
epair ($7,000), and parts and accessories revenue
$115,000) due to service less than expected, partially offset
y the fay, sublet repair and parts and accessories expenses.
total Revenue $ 8,250,124.00 $ 8,184,480.00 5 6,917,180.00 $ (1,267,300.00)
OPERATING EXPENSE 8,255,444.00 8,189,800.00 7,222,700.00 $ 967,100.00 11.81% - FaN#. personnel expenses reduced by $40,000 due to one
vacant Automobile Mechanic I position.. two rinderfilled
Automobile Mechanic II positions being filled with Automobile
Mechanic I employees; decrease in equipment rental $15,800
due to leased vehicle contract expiration; reduced gasoline
costs by $491,000 due to decrease in fuel price; auction
expenses were reduced by $10,000 due to elimination of fall
auction and increased sale of vehicles at Flint Auction; fleet
insurance $35,000 due to estimated premium saving; ieduced
spending in parts and accessories $137,000, sublet repair
$30,000, shop supplies $12,000.
Fay. depreciation of $309,000 due to vehicles sold in auction
before fully depreciated, and 20 vehicles purchased less than
in the capital plan.
Wiley. In expendable equipment ($94,000) due to more used
vehicles requested by departments; increase in indirect costs
($97,000) due to actual charges developed after budget
finalization.
OPERATING INCOME (LOSS $ (5,320.00) $ (5,320.00) $ (305,520.00) $ (300,200.00}
JAFiscalSvc1Budgefforecast r NeWSUFFORT SERVICES.xls 5;1212010
ADOPTED
'BUDGET
AMENDED
BUDGET
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS
CENTRAL SERVICES
FY 2010 VARIANCE
FORECAST PAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
NET INCOME (LOSS) BEFORE
°VERA riNG TRANSFERS
TRANSFERS IN IfOUT
NET REVENUE OVERiTUNDER)
EXPENSES (PLANNED USE OF
FUND I3AL.)
TO TAIL. NE AS5L IS• BEGINNING
TOTAL. NÉE ASSES - ENDING
$ 234.680.00 $ 234,680.00 $ (215,520.00) S (456,200.00)
138.000.00 $ 138,000.00
$ 234,680.00 $ 234.680.00 $ (71,520.00) r_S .012,200.001
S 7,055,276.78
$ 7 577 756 78
Fav. Transfer to cover purchase of vehicles which will be
leased to Water Resource Comm. These yoliicles replace
vehicles which had been owned by the Drain Equipment fund.
Budget amendments are recommended with 2 nd Qtr end 3rd
Otr reports.
J:\FiscalSvdeudgetTorecast ,New\SUPPOR F SERVICES.xls b112 /2010
3,450,233 00 3,450,213.00 3,306,213.00 144,000 00 OPERATING EXPENSE
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS
CENTRAL SERVICES
ADOPTED AMENDED FY 2010 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
F14176J-LING, CONVENIENCE COPIER AND PRINTING FUND 66700
OPERATING REVENUE7
Outside Revenue $ 620,500 00 $ 620,500.00 $ 576,500.00 $ (4.4,000.00) 7.09% - Unfav. due to decrease of external metered postage revenue
($37,000) and standard mail revenue ($7,000) due to CVT
services less [Ilan expected.
In:side Revenue 2,862,167.00 2,862,167.00 2,672,267.00 $ (189,900.00) -6_63% - Unfav. metered postage revenue ($59,000) and standard mail
revenue ($9,400) due to decrease in amount of departments'
outgoing mail; reduced punting revenue ($68,000) due to less
in-house printing jobs; decrease of equipment rental revenue
($48,000) due to departments' decrease in convenience
copier usage..
Totat Revenue $ 3,482,667.00 $ 3,482,667.00 $ 3,248,767.00 $ (233,900.00)
4.17% - Fav. personnel expenses for $51,000 due to vacant Printing
Equipment Oper III position; decrease in printing contracted
services $20,000, printing supplies and stationery stock
$41,500 due to decrease in printing jobs; reduced metered
postage by $31,000 due to decrease in departments' outgoing
mail; decrease in copier machine rental $10,000 due to
reduction in convenience copier usage.
Unfav. indirect costs increased by ($14,500) due to actual
charges developed after budget finalization.
OPERATING INCOME (LOSS) $ 32,434.00 $ 32,434_00 $ (57.466.00) $ (89,900.00)
NON OPERATING REVENUE
(EXPENSE)
NET REVENUE OVER/(UNDER
EXPENSES (PLANNED USE OF
FUND BAL..)
4,000.00 4,000.00 1,000.00 (3,000.00) -75.00% - Unfav. reduced interest income based on prior years' .actuals.
$ 3643400 $36 434 00 $ (56,466 00) $ (92 900 00)
_ _
TOTAL NET ASSETS - BEGINNING $ 366,765.42
101-At. NFT ASSFTS - FNDING $ 310 2. 99 42 _
*Please note that in the Adopted Budget (line-item budget), Planned Use of Fund Fialanc.e appears listed with the revenue accounts.
45-
,) J:4-iscalSvolBudgefsForecasl_New \SUPPORT SERVICES.xls 511212010
NE I REVENUES OVER(UNDER)
EXPENSE S" .15400,000.00) ($1,713,699.00) ._(§2,895,899.001 .($1,182,200.00)
TOTAL NEI ASSETS - BEGINNING
TOTAL NET ASSE IS • ENDING
$12,402,209.80
$050631080
ADOPTED
8UDGET
AMEND ED
BUDGET
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
INTERNAL SERVICE FUND
FACILITIES MANAGEMENT
FY 2010 VARIANCE
FORECAST FAVitUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
[FAC !LIT! ES rinAIN'T ENANGE & OPERATIONS (463100)]
$533,500.00 $533,500.00 $540,200 00
25,750.85.9.00
$26,264,35E30
$26,454,359.00
$26,284,359.00
$26,454,359.00
25,750.859.00
$24,074„559.00
23,525,359.00
($170,000.00)
$170,000.00
(400,000.001
$170,000.00
,71,3,69.00) (1,714,199.00)
$170,000.00
OPERATING REVENUES:
Outside Revenue
tr Istria Revenue
Total Revenue
OPERATING EXPENSES
NET INCOME (LOSS) BEFORF
OPERATING TRANSPERS
NOI\I-OPERATiNG REVENUE
TRANSFERS IN
TRANSFFRS OUT
15,700.00 2.94% - Insurance claims reimbursement for damage incurred at County buildings.
(2,225,500.00) -8.64% - Reduced Office Space Rental revenue due to one-time credit to Departments
(52,179,900) to reduce Fund equity. end beed an lease agreement with 0.0.
Road Commission for space in the IT Center ($45,600)
($2,209,800:00) -8T41%
$25,420,259.00 $1,028,100.00
(5170,000.00) (51,351 .700.00) ($1,181,700.00)
$0.00 0.00%
3.89% - Fay. Natural Gas/ Fuel Oil $600,000 due to lock-in of favorable long•-term pricing
contracts; fay. Electrical Service $350.000 due to lower-cast third-party connects
arid savings from energy conservation initiatives implemented by FM&O; fay.
Depreciation $75,000 based on depreciation schedule; fay, Overtime 550,000 due
to moderate winter conditions and snowplowing activity; Turnover $21,700, Motor
Pool $27,500, Laundry & Cleaning $10,000, and Expendable Equipment $10,000 -
based on usage requirements.
Favorability is partially offset by unfav, IT Development ($75,000) for prehininary
GAMS Work Order, Project Ivlanageinent, and Customer Request System costs
and vvebsite costs; Indirect Costs (517 ,730) due to determination of costs
subsequent to budget determination; and License & Permits ($10,000) for required
State licenses, and Rent ($18,400) required for furniture storage. WI I unfav. duo to
creation of new accounts to track these oasts.
(512000 0.03% - Variance is for transfer out to MO Fund for final invoice tor Maintenance project.
*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 FORF KIS 5ii2,2010
FO !AL OPERATING REVENUE
OPERATING EXPENSES
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS 1 ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2010
BUDGET BUDGET FORECAST VARIANCE UPLANATION OF SIGNIFICANT VARIANtaS ._
[information Technology - Operations (5)6001
OPERATING REVENUES:
Outside $931,545.00 $931,54b $844,845.00 ($86,700.001 -931% - Unfav. Enhanced Access Fees ($19,400) due to decreased customer usage; Outside
Agencies ($18,15001 due to reduction in external customer requests & Deferred Lard File
'Tax ($22,200) as a iesult of at:at -lye in biIiiigprocedures due to tax & osstissineril
software Partiality offset by fay Ext. Rev $31,400
Inside 25,244,004.00 25,244,064.00 21,629,364.00 {3,614,200.00) -14.32% - Unfav. Depts OC DWI Dev & Ops (53,115,700) & Imaging Dev & Ops ($709,200) due
to holding rates at prior year levels_ Partially offset by fav. Non Govt'l Dev & Ops
$205,100 due to increase in projects requested by Non GE- and Sale of Equipment
$1,500.
$20175609.00 $26,175,609.00 $22,474,709.00 ($3,700,900.00) -14 14%
$31,901,870 00 $31,961,870,00 $28,888,370.00 $3,073,500.00 9.62% - Fay. primarily due to Deprec $1,707,200 for Fl capital protects in progress not fully
operational; Sal & FO $860,700 due to vacancies; Equip Mint 5424,900 due to lower
than anticipated hardware maint costs: Service Bureau S125,000 & Part & Access
$149,400 due to decreased costs: Prof Svcs 560,700 due to timing of previously
approved IT projecio; Printing 537,300 due to coot reductforo: Travel $117,900 duo to
decline in staff attending conferences; Contracted Svcs $75,000 due to budget
projection slightly higher Than eobial tale, Infernal Svc $64,000 & Supp $67 :500 based
on actual usage. Partially offset by Expend Equip ($459,700) due to equip replacements.;
Software Maintenance ($103,100) due to increased costs, Prior Yr Fxp j,$$2,4115);
Charge Card Fee ($38,500) credit card fees higher than anticipated Charge Card fees
are offset by Enhanced Access revenue.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (55.785,261.00) ($5,786,261_00) ($6,413.861.00) ($5400..0U)
NON-OPERATING REVENUE 305,500.00 305,500.00 .217,600.00 (87,900,00) -28.77% Unfav. Interest Income due to lower cash balance than anticipated.
TRANSFERS IN 1,181,14100 1,181,143.00 1,181,143 00 000 000%
f RANSFFRS (OUT) (1.00 0.00 0.00 0.00 0.00%
NET REVENUES 0\7E1-Z1:UNDER) )184 299 618.001 299..618.00) (55,014.918.00) _(.$715,300.00t
TOTAL NE, F ASSETS BEGINNING 21,258,432.26
IO [AL NET ASSL ES -ENDING $22 243 514 26
Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use el Fund Balance" in the revenue category.
TOTAL OPERATING REVENUE
OPERATING EXPENSES
$3,287.912.00 $3,287,912.00
$3,761,689.00 $3 7i:11,689.00
$3.303;012 00
$3,496,889.00
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDFD FY 2010
BUDGET BULtaET FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCta
fin formation Technotow - Telapt rune Communications (6.1500
ON RATING RI.'VENUES
Outsicte $32,000.00 $32,000.00 $47,100 00 515,100.00 47.19% Fay. Sale of Phone External due to increased usage.
0.(',0 0.00% Inside 3,255,912.00 3,255,912.00 3,255M12 00
$15,100.00 0.46%
$264,800.00 7.04% Fay. Comm $142,800 due lo decreased rates, Indirect Cost $76,200; IT Op s $40,000 &
Maint Equip $26,900 subsequent lo budgetpotorpool 5000 due to actual usage. Fav
partially offset by unta v. Info Tech L.)ev t$16,300) due to Telesott upgrade and Deprec
($5.9001 purchase of capital equipment subsegi lent le budga2.
NET INCOME (LOSS) BEFORE
OPERATING -TRANSFERS ($473,777.00) ($473,777.00) ($193,877.00) $219,900.00
NON OPERATING REVENUE 30,000.00 30,000.00 32,200.00 2,200.00 7.33% Fay Interest Income due to higher cash balance than an ticlgated.
TRANSI ENS IN 0.00 0.00 0.00 0.00 (1.00%
1 FeANSFERS (OU f )0,00 01111 _ 0 0 OU 0.00 0.00%
_ _ _ .. __.
NET REVLNUES OVERS.INDERI EXP1 ($443,777 01_j_ _ . {$443.7(7 q.4 (s ? 61,6 (7.00) _ $287100.00
TOTAL NET ASSETS - BEGLNNING 4.949,453.09
TOTAL NET ASSETS - LNDING $4 787 776 09
, _ , .___
Please note %al in the Adopted budget (line-ilern Lock) this is budgeted as Planned use of Fund Balance." in the revenue category.
OPERATING REVENUES'
Outside $4,324,251.00 $4,324,251.00 $3,994,351..00 ($320,900.00) 8.33%
OPERATING EXPENSES 58,950,890.09 $8,835,890.00 S8,227,790.00 5608.100.00 6.88%
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS i ENTERPRISE FUND
INFORMATION TECHNOL OGY
ADOPTED
AUDGET
[information Technology - CLEWS (53500)
AMENDED FY 2010
BUDGET FORECAST VARIANCE EXPLANATION OF SpaNIFICANT VARIANCES
Ontay. CL EMIS Crash (5150:000) & CLEMIS Citation ($200,0(111) due to timing of
implementation of pzograrns; Outside Agencies ($8,100) due 10 actual FE count slightly
lower than budget projection; In-Car terminals External ($44,809) due to withdrawal of
Livingston County in MDC participation. Partially onset by fa v. Parts & Access $13,000 &
Labor $2,090 for CLEMIS Tech support; Maintenance Contracts $50,900 Livescar maint
after warranty; Retained Charges $8,000 due to additional Connectivity costs charged to
the Tier 2.5 & 3.0 agoilLies.
Irisiae 1,331,674.00 1,331,674.00
TOTAL OPERATING REVENUE $5,655,925.00 $5,655,925.00
1,391,974.00 60,300.00 53.20% Fay In-Car Terminals Interntal $5,300 dila to Nino count higher than budget projection
& CC Depts $55,000 for CLEMIS staff support C.]1 CAD/MOC to Radio
$5,386,325.00 (5269,600.00 8.39%
Fa v.Salif-B $324,100 due to underfills & vacancies; Software Maintenance $319,000
due to timing of anticipated maintenance costs; Comm $104,5()(1 due to lower than
anticipated coals; Indirect Cost $25,400; IT Dev $345,600. IT Ops $23,000, Motor Fool
519,500.Rebillable Services $4,000. F'rinl Shop $12,500 8.'1 de Comm $8,190 due lo
decreased costs. Offset by urfav. Deprec (5911,00D) due to equip that became
opeiaticnal subsequent to budget, Expend Equip (545,200) due to equipment needed for -
repairs; Bank Charges ($15.700) due to cost for paypal services for E-Commerce
transaction_
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS ($2,994,965 00)
NON-OPLFO4 TING REVENUE 15,000.00
TRANSF'ERS IN 1,404,184.00
TRANSFERS (OUT) 0.00
($3,179,965.00) ($2,841.465.00) $338,500 00
15,000.00 4,700.00 (10,300.00) -63.67% Unfa v. Interest Income due to lower cash balance than anticipated.
1.593,186.00 1,593,188 00 0.00 0.00%
0.00 0.00 0.00 0.00%
NET REVENUES OVER(UNDER) EXP1 ($1,571,779 00 t L$1,571779 00' ($1,243,579.00)._ $328 200.00
TOTAL NET ASSETS - BEGINNING 11 901702.80
10 tAL NET AssLrs ENDING $10,660.183oo
Please note that in the Adopted Budget (line, item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category,.
ADOPTED
BUDGET
[Information lechn-ology: Radio Car-rimunications ($300)
OPT RATING REVENUES:
OiJiSICSB
AMENDED FY 2010
BUDGET FORECAST VARIANCE
$5,266,277 00 55,554,677.00 5268,400.00 $5..26,6,277.00
Inside
TOTAL OPERA TING REVENUE
OPLRATING EXPENSES
320,965.00 189,965.00 169,000.(10 52.65%
55,561,242.00 56,024,642.00 5437,100.00 7.63%
$7,651,324.00 $8,521,921.00
320,965.00
- - —
St,581,24:2.00
S 1,694,324.00 ($827,600 001 -10.76%
($2,107,032.00)
10,000.00
136,510 00
Q50,000.00)
(52 107,082.00) (57,497,282,00)
150,000.00 269,6(10.00
135.510 00 135,510.00
(250,000.00) (250,000 Oil_ 0 00
($390,200.00)
119,600.00
0.00
79.13%
0.00%
0.00%
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS] ENTERPRISE FUND
INFORMATION TECHNOLOGY
EXPLANATION OF 51GNIFICANT VARIANCES
5.10% Fav. E-9 1 .1 $200,600 due to higher than anticipated revenue from wireless co & inc
Surcharge rate effective Jul 1, 2010 ; Outside Agency $63,200 due to timing of phase
out of legacy system & Antenna Site MO $5,300 due to additional equipment installed by
co lor.atorS.
Favorable Internal Revenue for Leased Equipment $144,000 & Paris Access $25,000
due to timing of the projected phase-out of the lecsacy system.
Unfav. Expandable Equip ($931,600) due to NG911 equip replatemnts; Travel (515,000)
& IT De v (54,100) due to usage & Prof Svcs 091,030 for training.Partially offset by fay
Sal & Ff3 $134,400 due to vacancy & fa v overtime; Special Projects $40,000 & Small
Tools & Supplies $11,000 due to decreased usage; frioirec:( Cost $29,000 subsequent to
todget projection.
NET 1NOOMF (1 OSS) BEFORE
OPERAT NO TRANSFERS
NON-OPFRAT iNG REVENUE
TRANSFERS IN
TRANSFERS (OUT
NET REVENUES OVER(UNDER) EXPI ($2,(l71,572_ 00) ($2,071 5'7? 0L0) ($2,342.172.00) 15270,600.00,1
Fay. primarily due to Interest Income; hieher cash balance than anticipated
TO IAL NET ASSETS - BEGINNING 56,468,326 41
TOTAI NET ASSETS - ENDING $51 12(1.154 41
Please note that iri the Adopted Budget (line, item book; this is budgeted a:-; "Planned use of Fund Balance" in the revenue ca Lego y
COUNTY OF OAKLAND
FY 2010 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS I ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2010
BUDGET BUDGET FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCES
[Fire Rocorcts Manaaenient (531001
OPERA IING REVLNUES:
Outside $207,112 00 $207.112.0() $209102.00 31,990.00 0.30% Eav. prir lady due to the addition of Nortnville Twp Fire Dept.
TO FAL OPERATING RCVENUES $207,112.00 $207,1 12 00 $200.102.00 $i,9900 0.96%
OPERATING FXPENSES $644,316.00 $644,316.00 $620,916.00 $23,400.00 3.63% Fav.Communicalions $11,900 savings in connectivity costs; 11 Ops $...0,100; Indirect
Cost 52,900:Travel $2,000 & Personal Mileage $1,400 duo to decreased demand for
techs to travel to member sites; Expend Equip $10300 decreased equip replacements.
Fast. partially offset by unfav. Software Purchase ($9,000) due to the timing of software
license purchases for now member agencies; IT Dev ($4,g00) duo to programming
services & Deprec (31,300) due to purchase of server equip after budget.
NET INCOME (LOSS) BEFORE
OPERA TING IHANSI-ERS
NON-OPERATING REVENUE
;$437,204.00) ($437,204.00) ($411,814.00) $25,390.00
2,000.00 2,000.00 4,000 00 2,000.00 100.00% Interest Income favorable due to higher cash balance than anticipated.
TRANSFERS IN 438,705,00 438,705.00 438,605.00 (10000) -CI 02% General Fund snare of operating costs includes withdrawal Huntington Wds Fire Opt.
TRANSFERS (OUT) 0.00 0.00 0.00 0.00 0.00%
OPERATING INCOME (LOSS) $3,501.00 $3,501.00 $30,791.00 $27,2000
TO FAL NFT ASSETS. BEGINNING 364,027.30
TOTAL NEt ASSETS-ENDING $394,818.30
Please note that in the Adopted Budget (line-item bcck) this is bud90;.d as "Planned Lise-of Fund Balance" in the revenue category and Budgeted Fguity Ad) in Expenses
). vire
OAKLAND COUNTY
EALTH DIVISIO
Memo
To: Linda Pearson
Fiscal Services
From: Kathy Forzley, R.S., M.P.A.
Manager/Health Officer
Health Division
Date: February 25, 2010
Re: Donations from The American Lung Association of Michigan
The Health Division has recently received two donations from The American Lung
Association of Michigan. These donations will be used to provide incentives and
enablers to our TB DOT clients.
The amount and account information for each deposit is as follows:
FY 2009 Health TB $500 20221 1060234 133970 650301
FY 2010 Health TB $500 20221 1060234 133970 650301
Thank you.
a Page 1
• 4. 1
OAKLAND COUNTY
INTERNATIONAL
AIRPORT
Memo
To Tim Soave
From: Karl Randall
CC: Carol Morin-Jablonski
Date: March 24,2010
Re: Airport Write Off Requests
3 - 2/4 - 2-C) 0
Attached is a spreadsneet fisting the requested write offs for 2 customers
Customer #351, Cougars account was placed in the hands of Corporation Counsel.
Corporations Counsel worked on this account for over 2 years to reach a settlement with
Cougars and to have them relinquisn the hangar. As a result of this worK a settlement of
$5,000 was reached and the hangar was vacated. This settlement leaves a balance on their
account of $4,596.80 that needs to be written off.
Customer #926, National Stonecrafters dissolved their company. We have been trying for
over a year to collect the balance owed on their account of $503.10. This is an uncollectible
account and needs to be written off.
1<
4 1
•
Write Off Requests
Custorner*AIR351 Cougars Inc
INVOICE # AMOUNT
AI R24810 $152.40
AIR25220 $27.10
AIR25784 $271.00
AIR25902 $27.10
AIR26196 $271.00
AIR26602 $27.10
AIR26871 $271.00
AI R27281 $27.10
AIR27525 $27100
AU 27925 $27.10
AlR28184 $271.00
AIR28577 $27.10
AIR28827 $271.00
AIR29229 $27.10
AIR29475 $271.00
AIR29869 $27.10
AIR30119 $271.00
AIR30515 $27.10
AIR30759 $271.00
AIR31155 $2710
AIR31412 $271.00
Al R31806 $27.10
AI R32061 $271.00
AIR32455 $27.10
AIR32716 $271.00
AIR33106 $27.10
AIR33359 $271.00
AIR33761 $27.10
AIR34009 $271.00
AIR34637 $271.00
TOTAL $4,596.80
Customer #AIR926 National Stonecrafters
INVOICE # AMOUNT
AIR27421 $156.60
AI R27940 $31.50
A1R28081 $315.00
TOTAL $503.10
1 10
Resolution #10131 June 9, 2010
Moved by Gosselin supported by Nash the resolutions (with fiscal notes attached) on the Consent
Agenda be adopted.
AYES: Burns, Capello, Coleman, Coulter, Douglas, Gershenson, Gingell, Gosselin, Greimel,
Hatchett, Jackson, Jacobsen, Long. McGillivray, Middleton, Nash, Potter, Potts, Runestad,
Schwartz, Scott, Taub, Woodward, Zack, Bullard. (25)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the Consent
Agenda were adopted.
cYr-44'
Eg APPROVE THE FOREGOING RESOLUTIN
ACTING PLRSUANT TO 1973 PA 139
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Ruth Johnson, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true
and accurate copy of a resolution adopted by the Oakland County Board of Commissioners on June 9,
2010, with the original record thereof now remaining in my office.
In Testimony Whereof, I have hereunto set my hand and affixed the seat of the County of Oakland at
Pontiac. Michigan this 9th day of June, 2010.
Gide
Ruth Johnson, County Clerk