HomeMy WebLinkAboutResolutions - 2009.07.15 - 9777MISCELLANEOUS RESOLUT=ON /09132 June 15, 2009
BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON
IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2009 SECOND QUARTER
FINANCIAL FORECAST AND FY 2009 BUDGET AMENDMENTS
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
WHEREAS Public Act 621 of 1978, the Uniform Budgeting and Accounting Act for
Local Units of Government, provides for adjustments to the adapted 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) 2009 Second Quarter Financial Forecast Report has
identified several variances and budget amendments are recommended; and
WHEREAS the 52'1 District Courts request a budget amendment to reduce revenues
and expenditures due to a decline in revenue collections; and
WHEREAS the Sheriff is requesting a budget amendment to authorize use of
remaining Forfeiture Funds of $23,065 originally budgeted for motorcycles
UCR.#09071) to purchase traffic safety vests; and
WHEREAS the Sheriff's Office received notification from Groveland Township of
fire dispatch contract cancellation effective June 30, 2009 and a budget amendment
is recommended to acknowledge the revenue loss; and
WHEREAS a budget amendment is requested by the Library Board to re-appropriate
funds in the amcunt of $2,CDO from the Law Library to Library Administration for the
one-time set up fee for a Ti line, which will provide enternet access to members of
the public; and
WHEREAS a budget amendment is recommended to reallocate funds within the
Auditing Division to reflect the budget in the acCOunts where the actual expenses
are incurred; and
WHEREAS a budget amendment is recommended to reallocate funds within the
Homeland Security to reflect increased cost for Electrical Services for tornado
sirens and funding is available within the Division; and
WUTMEAS a budget amendment is recommended to recognize $31,000 in Fiscal
Services - Reimbursement Professional Services favorability to cover the Information
Technology expense of programming Account Receivable Files for the State Court of
Administrators' uffice; and
WHEREAS the Health Division is requesting an amendment to use $14,000 of
anticipated favorability in Clinic expenses to offset increased Professional
Services for activities in TB; and
WHEREAS Children's Village is requesting an amendment to use $10,000 of
anticipated favorabilety in Dry Goods and Clothing to offset a Professional Services
contract for nurses from Ameristaff in order to fill scheduling needs at Children's
Village; and
WHEREAS the MSU Extension Division is requesting a budget amendment of $1,000
to re-appropriate funds within their budget to more accurately account for actual
program expenses; and
WHEREAS the Medical Examiner is requesting a budget amendment of $2,000 to
reallocate funds within the budget, from Film and Processing to Equipment
Maintenance to more accurately account for actual expenses; and
WHEREAS Economic Development is requesting a budget amendment to reallocate
$26,000 in donation revenue appropriations within the department to more accurately
classify the donation, re-appropriate funds within the department's budget to
segregate marketing and planning activities, and an appropriation transfer of $1,551
in Economic Development to fully fund Worforce jevelopment grant costs not
chargeable to the grants; and
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote with Gingell absent.
A 6
ill ....
WHEREAS a budget amendment is recommended to transfer $750,000 from the
Delinquent Tax Revolving Fund (DTER) to the General Fund Non-Departmental account
for the FY 2009 Road Commission Tr-Party agreement; and
WHEREAS a budget amendment is recommended to correct a budget amendment per MR
#0909l for Human Resources Budget Task Reduction, by reallocating budget from
Administration to Training and Development within the Fringe Benefit Fund to more
accurately account for actual expenses; and
WHEREAS a budget amendment of $266,258 is recommended to correct budget
adjustment made during the FY 2009/FY 2010 Budget Process, which reallocated funds
to transfer two (2) positions from IT Fund to CLEMIS Fund and
WHEREAS M.R.#59082 amended the IT fund budget and the DTRF budget for the tax
collection software project and since this project was already budgeted in the DTRF,
the DTRF portion of the amendment needs to be reversed; and
WHEREAS due to cutbacks, the State of Michigan is no longer providing the
service of polygraph testing for the local police departments, and the Sheriff's
Office has been requested by the local police departments to provide polygraph
testing services, and a budget amendment is recommended to use funds from the
Capital Cooperative Initiatives Revolving Fund (#21150) which is already assigned
for Sheriff activities in the amount of $12,000 to offset the expense for providing
Polygraph Testing services through the Sheriff's Office; and
WHEREAS $350,500 was originally transferred to the Ratio Communications Fund
(#53600) per MR #08266 for the Sheriff's call taking equipment and a budget
amendment of $200,500 is recommended to authorize the return of the balance of funds
to the General Fund as other funds are available to cover the cost of the equipment.
Surcharge monies have been collected specifically for 911 call taking equipment and
also a minimal amount of grant funds has been received; and
WHEREAS the County has received additional donations for the Oakland County
Lady Justice Restoration Project in the amount of $525; and
WHEREAS Section 25 of the General Appropriations Act requires that the Board
of Commissioners receive a quarterly report regarding adjustments made to Inmates
accounts on transactions billed in excess of ability to pay as well as approve the
write-offs of any bad debts in excess of $1,000; and
WHEREAS after repeated efforts to collect money owed to Oakland County from
two (2) One Stop Shop customers, the Planning and Economic Development Services
Division has requested to write off these accounts as bad debts in the amount of
$69; and
WHEREAS the Department of Information Technology has requested write-offs
totaling $563.35 due to unsuccesSful attempts to collect on bad debts past due 90
days.
NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the
Fiscal Year 2003 Second Quarter Financial Report.
BE IT FURTHER RESOLVED that the FY 2009 Budget be amended pursuant to
Schedules A and B.
BE IT FURTHER RESOLVED that $12,000 from the Capital Cooperative Initiatives
Revolving Fund (CCIRF) be appropriated as follows:
GENERAL FT:1ND (41C100)
Expenditures
4030901-110060-735373 Sheriff Invest/Foren Svcs-Contracted Svcs $12,000
9010101-132320-786001-21150 Transfer Out to CCIRF (12,000)
Total Expenditures 0
CCIRF FUND ;#211t;U)
Revenue
9010101-132320-695500-1010 Transfer In from General Fund ($12,000)
1n•
Expenditure
4030601.-116200-760051 Boats (12,000;
Total 0
BE IT FURTHER RESOLVED that $200.000 be transferred from the Radio
Communications Fund to the General Fund as follows:
RADIO rorelYTUNICW:'IONS FUND 4S3600)
Revenue
1080310-115060-665082 Planned Use of Fund Balance ($200,000)
Expenditure
1080310-11SU60-788GJ1-10100 Transfer Out to General Fund
Total
($200,000)
GENERAL FUND ;#1010j)
Revenue
9010101-112710-69E500-53600 Transfer In from Radio Comm Fund $200,000
Expenditure
9010101-196030-74023 Non-Dept Budget Transition
Total
$200,000
0
BL IT FURTHER RESOLVED that donations be accepted for the Oakland County Lady
Justice Restoration Projec*.=.,
BE IT FURTHER RESOLVED that uncollectible debts for services rendered by the
Planning and Economic Development Services Division and the Department of
Information Technology are authorized to be written off.
Chairperson, on behalf of the Finance Committee, I itove the adoption of the
foregoing resolution.
FINANCE COMMITTEE
a oR
My o-
L. BROOKS PATTERSON, OAKLAND COUNTY EXECUTIVE COA K N D7
viem i so
Laurie van Poll, Director
/4 r
COUNTY MICHIGAN
DEDAraMMT ar mANAEEMENT AND BUDGET
TO: Members of the Finance Committee
FROM: Laurie Van Pelt, Direetor, Management and Budget ./".
Tim Soave, Manager, Fiscal Services
Nancy F0arnier, Chief. Fisca; Services
LaVerne Smith, Supervisor of Fiscal Services
SUBJECT; Letter of Transmittal - Fiscal Year 2009 Second Quarter Report
DATE: July 1, 2009
FY 2009 FORECAST
Attached please find the Fiscal Year (FY) 2009 Second Quarter Forecast Report. In total. Fiscal. Services forecasts
that the County will complete Fiscal Year 2009 with overall favorability of $4,264,484 in General Fund / General
Purpose (GP/GP) operations. CiFIGP includes all operations except grants, enterprise funds and internal service
funds. This overall favorability is split between receiving ($12,145,734) less revenue than anticipated and
projected favorability in expenditures of S16,410,218.
It is important to note, however, that the unfavorable revenue reflects Planned Use of Fund Balance of $7.431,541,
This appropriation authorizes the use of prior year surplus of $3,662,33, for encumbrances, carrylonvards and
one-time projects and the balance of $3,769,210, is the use of designations (budget transition) used to balarre
FY 2009 Adopted Budget,
The forecast report estimates FY 2009 activity, for General FuncliGeneral Purpose (GF/GP) operatioes (ail
operations except grant and internal service funds) as shown below:
Revenues over/(under) budget $(12,145,734)
Expenditures — (over)/under budget 16,40,238
Totai Officially Reported Estimated Favorability $ 4,264,44
However, a simple review of the bottom line does not reflect the true fiscal activity of the County. specifically.
because the amended revenue budget assumed the use of $7,431,541 in fund balance. Although use of fund balance
was budgeted, governmental accounting rules do not allow fund balance to be "recorded as revenue" leaving
budgeted revenue with no actual revenue showing as received. Such a presentation is proper according to generally
accepted accounting principles, but it also gives a misleading presentation of the forecasted FY 2009 activity. The
more relevant presentation is as follows:
Revenue Variance 5(12,145,734)
Add back — Planned use of Fund Balance . 7,431,541
Revenue Variance (Comparing Forecasted to Approved Plan)
Expenditure Variance $ 16,410,218
Planned Set Aside for Budget Transition C 7,045,634?
Expenditure Variance (Comparing Forecasted to Approved Plan)
Net Variance from FY 2009 Activity
($ 4.714,93)
9,3e4.584
4,391
EXECUTIVE OFFICE BUILDING 41 WEST - 2100 PONTIAC LAKE RD DEPT 409 • WATErIFORD A4I 48U29-0409 • (248) 858-21 S3 • FAX (248) 85B-9172
EMAIL vanvelti9oakgov.00m
ASSassment Fees
Anessment Fees and PSI
Con-ImsKy S'erVce and Oversigr'it
Drug Court Treatment Fee
Fin u Fees DCU
Garnishntent Feus
Late Penalty
Limense Reiristatmew Fee5
na-.6,J)oncoas
No insur3nw Frau! 7ee
Ord:nal-1de Fines and Ccsts
Probwon Fees
Refund Foes Pd to De Attorneys
State Law Costs
Drunk Drivilg Caseflow
Total Revenues
(08,000,03)
(27,030.00)
1U,000.00
10,000.30
'?4,000.00
45.00:AK;
(8,00C,00)
(5,000.00)
(60,a10.031
(57,C}00,00
15,000.00)
(70,000.00)
15.00063
(,1 -rz.i.600.03)
Budget Transitio-.
Total Exocriditures
$ V.76,X0.00)
$ (176,060.90)
Assessment Fees and PSI
CVR County PLInn
FJr1.7.; Fest-, Dc.,..;
Forfeiture of Bondo
GernisIrnent Fees
Late Penalty
Lircense Roinsta:ment Fees
MIscellaneuLs
OmnanLe Fines and COS`,5
Plubaticin
State Law Coots
Total Rverit;es
(';7400.00)
; °X.:0
27 :000.00
(4.000.00)
43,000.00
2000.00
(4,000.00)
6,030.00
(e0,000.00)
(55,002.00)
(94,002..0C)
$ (.163,000.001
B.,..dget 'Transit on
Tote. Exoe7dI:ure6
(153.000.05)
(153,000 00)
Msewriv.t Fee;
As6es.5.-nnt Foes and PSI
Rlirg Fees DCU
Forfelt4re of Dencis
Gatrrirnerri Fees
Umense peinstatrisnt Fees
NF5 Checic Fees
Ordinance Fines and Costs
FroOaliQ: Fees
Reful,-.'„ Fees Pd to Def Atorney$
StiAe Nn,. Costs
Income from Investmerr
Total Revenues
Trnsitio
Exoenclit.iret-:
1.00000
(25 003.00)
(25,0X.00)
13,037.01.1
(5,C30.0C;
(1,300.:4)
(33.250.00)
(120 000.00i
(30.00.; 001
(.3,750 ,::!":1r•
$ (252 000.0C)
(252,000.0C9
ISCHEDLILE A
OAKLAND COUNTY, MICI-i1GAN
FISCAL YEAR 2909 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE F/GP)
FY 2C:09
AMENOMENTS
NIWDMENTS OPERATIONS - SELF BALANCING
GtNERAL FUND (#101001
Dent Program iti;ct. Fund Aff. Op Unli
DIstrict Court - Division 1
Revenues
3020201 1132,W 630',
3023201 113290 630112
302201 113290 630329
3023201 121320 630fH5
3023201 121320 6.33721
3020201 121320 630826
3020201 121320 631054
3020201 121020 631083
3020201 121020 631253
3020201 121020 63123:.
3320201 121020 031421
302020 121C20 631535
3020201 121020 631736
3020231 121020 632170
3020201 121C20 530367
Experr.."iturus
3020201 12 -20 740323
District Court - Division II
Revenues
3020301 113233 63 ..r 12
3020301 121 13.20 630441
3020301 121020 530721
3020301 121020 630798
3020301 121026 630625
3020301 121020 631054
3023.301 121320 631025
302.;.301 121.320 631253
3020301 121020 631421
304301 113390 63150,0
3020301 121020 632170
Expenditure
3320301 121020 743023
District Court Division Ili
Revenues
3020401 121020 030105
3020401 1132E-.0 62012
3320401 121020 530721
1210213 $307 7,18
121020 630826
121020 531785
121020 031330
121023 631421
634.596
1211320 1:.;31736
121320 632
121320 555:305
ExOenditu -ei
3U2L401 12120 7403i3
3020401
3023401
3020401
3020401
a-)20401
30'20,43':
3023401
3020401
2020401
Account Name
11'3290
112200
121020
121C2
121023
12%20
1220
12"“:20
121320
121020
121120
121,520
121Z;20
13290
121323
121C20
121020
304501
3020501
3020501
3020501
3023501
3020501
3020501
3020501
3020501
3020501
3020501
3020501
3020501
3200 I
3020501
3020501
3020501
'5301 1:2
033191
6'..10441
6 -i-0551
680721
630,'9I3
639826
631015
63 1 U4
681(kS
6.30421
6.31 51)6
6317'36
632170
5-55385
Expenditure!:
302059r 121020 743323 Sucli Transtie5
iota: Expe neves
(10.300.00)
(O 700.00)
rfl, Ill
(1,000.00)
6,500.00
4,040.00
(3,000,00)
15.000 00
(1,000.00)
(10,030.00)
,000.001
(61.000.00)
(97,000.90)
(1'6.030.00)
(1.750.0!_y)
S (.217,750.00)
$
S i12 17.7•50 j0
Assessment Fee
Assessmunt Fee an PSI
•W% Bond Fees
CVR County PoliQn
Drug Cow i Treatment Foe
D runk Dtvirg Geseflow
Filog fees DC...I
Fcirei*,ure of Bona
GarriSfornent Fees
Jury Fees
Late Penalty
LinGense Rein ta:rtient Fees
CAlinanze Fiw.5 and Costs
prciL3Jtien Fees
Refund Fees Pd to Def Attorneys
State Law Casts
income frorn Inves'xnent
Total Reirerues
Expenditures
4030510 11E230 712920 9M-1.9
4030601 111000 76C188
4030001 110303 750070
BOG - Law Library
Expenditures
5010302 16K20 78E00.
:01-:30C 1680 774536
County Executive - Auditing Div s.ion
ExpenciLfros
03600
A
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2013a SECOND QUARTER BUOGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (OF(GP)
FY 2.00.9
AMENDMENTS
IGF1GP OPERATIONS SELF ..ALANCING &Li kb I
District Court Division II
Rove us
4
Shoriffs Office
Revenues
4030510 116230 E:.;0539 Fire Dispatch
Total Revenues (52 484,0c)
3
'310101
1310101
101 .310'.
1010101
1010101
1010101
1010201
1010232
1010203
1010202
1010203
1'316101
10 •:0101
181010
16131C
18:,9/0
181;:.10
191010
151010
151009
1810:io
18 303
151000
181C:::0
73L3
731 33
7314,r,)
73147
700049
702313
7:7;2010
702610
7'2023
7!J2010
722770
Overtime
Capital Outlay - Vehicles
DepLty Supplies
Total Fprditurea
Law Library - Transfers Out
Library Adniin - Operatio
Total ;:.--xpenditures
Member0ip5, Dues
Felodicals. Books, Pub Sub
Professinal SrrvinPs
Ccrruter Supplies
Supp:ie$
Su dries
Saiories
Salaries
Ovortirre
Overtime
Salahes
Fringe DeneNS
Total Expt nth -tures
(52,484.90)
(23,355.00)
23 06.5 C.,0
(2,003.0)
2,000.03
(000.00)
600.00
1.000.(10
(1.030.00)
1,00000
2.066
(66 812 00)
51 :57900
4500.03
14.415.00
11.250.00
860.:0
900.00)
40.00
(31,03C.00)
31,000:00
FS/Reimbusement -Professional Semces
03600 Transfer Crut to IT
Total Ewen i(ures
heath - CIiThc - Professitnal Svz-b
lieeith - TEl - Profe6sion41 Svcs
Total Expendiures
Dry Goods & Clot-dog
Profess;;rial Services
Tazi Pxpend,ti,res
MSU Ext. Natural Sciences - ()Etc S'Jppliss
MSU Ext - Ext Admiri Offee StipP-es
Total Expeildrturts
Medical Examiner - Film & Processing
Medical Examiner - Eqc,ipmeit Mai ntei i.ance
Tom. Expenditures
Econ Dev Atimin Dontato!ts
PEDS Emerging Sectors - Done: ons
Tolai .Revenues
1 0,000,00)
1,10.003,00
1,000 00
11,000.00)
(1,5M.00)
1 551 cc,
G200,000.30)
(M,000.00)
94,090.00'
25,000 00
4 1000.00
25,000.03
33 os
25,000.00
175.030.60
;
iN• SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2D119 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUNMENERAL PURPOSE (GF/GP)
iii6WITI NDMENTS
MS/Homeland Security
EXPUFI,;,1Ure
1X)C501 3C.:A0 73072
1Q50601!.30 730562
1Q50601 115390 73150
1060(301 11539Q 70018
1:;60L'0' ft5090 737;8
Tata) Expexiclitures
Management and Budget - FS Reimbursement I Non-Dept
Exper.clitures
1020050 1260u3 731455
1020650 129%000 788001
Ativert'sing
Electrical Services
Maintenance Contract
FA Prop Equip Exp
FOOS - Services
rY 20D9
AMENDMENTS
PUBLIC HEALTH FUND (#20221
HHS Health Division
Expemlitures
1060234 133990 73 1,455
105U235 1371: 731458
CHILD CARE FUNDift202931
HHS - Children's Village
Expenditures
1060501 112090 753119
10130501 112010 :731458
GENERAL FUND 1;001001
Public Services - MU Extentiun
Enenditwes
1070513 174170 750399
1070501 174000 750399
Public Serv/ces - Medical Exam;ner
Expend itures
370601 132030 750102
19/0601 132330 73645
Ecgnmic Develupinen1
Revenues
10W101 171300 550301
1090201 171: E 05330
C,4,'000.00`t
14.[,'00.50
2000.55
(2.000.00J
(26,300.06)
26,000.00
ExPe7"drrcs
1090204 172040 102019 Planning - $.Aarieb
1090101 170010 732240 Worttfore De v - Salary Adjustment
1093201 17 115 730235 PEDS Emerging Sector - Bus, Recr.iit
1090Z01 ffIfl5 731403 PEDS Emerging Sector - Prof. Svcs
90201 17000 73'.455 ?EDS - Professior.,a,Sv
13&0201 •" 77300 73 4_ 780 PEPS Software SL:pporl MainteranLu
10.c./0201 17133C! 75:01Y:: PEDS Dry GC:AE& Glor.ng
1090108 171020 .730072 Marketing & Comm - Advertisini;
1090108 1711:5 7109/2 Marketing & Comm Erner E=or3 Adva-tisiN
1090138 171039 731458 Mal$,arg & Corm - Professionel Svcs
10E0138 171115 73',158 M i<c1r9 a Comm Erne Secto:'.5 - Prof, Svr..s
TotzlExpionollfs
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2009 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GFIGP)
FY 2003
_AMENDMENTS
IGF/GP OPERATION qPi q.:41 f-,.:KANG AMENDMENTS _
Non-DepartmentaI
Revenue
9010101 185)40 6935UIJ 50C Transfer In from DTRF 750,03.C3
Total SeveriLes 750,CO3.00
Experitlitures
9010131 153010 740135 Road Commission -Tj Pw-ty .75.000.00
Total Expenditures 750.030.00
SCHESWLE B
OAKLAND COUNTY, MICHIGAN
FiSCAL YEAR 2009 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
1-1R/INt.)1.nes - Salaries
HRJWelIr'es - FB Worts Comp
FR/Wellness - FR GroJp Life
i-tRIWeliness FB Res.irmorr,.
HRIINellness - FB Ho pltlizalieii
HRAVVellness FB Strcia: 3ecti7ity
HRMellness FB Lent
HRNktellns - FB JiiIIty
- FB Linempluy 'Insurance
HR/Wellnes& - FR Optical
HreTraln:ng - Salaries
HiRrTrairtig - FB "1/1.1orKers Comp
HR71-raoing. - F ,..liroun Life
HRfl-raining - FB Retirement
HR./Trait-Ong - FU Hiosnitztization
1-1RrTrainin5 - FE Social Secenly
HR/Training - FE Denta!
HRITra'ning - FB Disability
FR/Training - Unem ploy Insurance
HRiTrairirtn - FB Optical
Total aperdtures
ACCOUNT NUMBER
I PROPR iTARY / SPECIAL R177 VE 111.1 FL,NDS - 5C.FBALANCING MAE \IDME-1...; T5
Dept ID Program Acct Fund Aft Oper Unit Account Name
Fringe Benefit Fund I Human Resources (461800)
Expendituies
1050W1 183192 70210
105050; 103"' 92 722750
1050531 123102 72270i)
350501 183102 722713
105U,501 183192 7227K
1050501 1E,3192 722790
1050601 183192 722600
1050501 181 92 722810
1050501 183192 772E20
1060501 183112 T22800
1(J0523 1051 '12 702010
1050525 1831,92 722753
1050525 183192 77270
1060525 18'3792 722770
1050525 183192 722760
1050525 183102 722790
1050525 183192 722620
1050625 183192 722610
1350525 183192 722920
1050525 182192 .122050
FY 2409
AMENDMFNT
$ (21 141,1:0)
(2' 1 00)
(52 00)
5.00)
12.35500)
t1.37t 00)
(255.00)
(68 00)
(35.G0)
(1G.00)
2i.11.00
211.03
32.0
5.51500
2,535 00
137500
255,00
68.0;
35
18,C0
Information Technology CLEWS
Revenues
10130201 1 ; 0C20 630266
1090301 11632j 065832
Delinquent Tax Revolving Fund (01600)
Revenues
J010110 155050 565892
Expenditures
7310110 196130
CLEIvIlE Operations OULSiGe
Planned Use of Foic Calance
Total Revenues
Planned Use of Fute Bafn;.e
Total Revenues
Info Tech i DeirConnient
Total Expenditures
773533
5 (266,250.00)
255,259.03
$ (350,757,00)
$ (366,757.20)
$ (358,757,00)
$ (365,757.00)
Information Tear ulogy -(#6364Q)
LeAerutA
1080201 152000 631 372
1080201 152C OC: 595500
Expenditures
1050201 152100
DC :Dept- OceEabons
-WOO Transfers %et Genea31Fun0
Total Revent.. es
Professional Services
Total Expenditures
2,l:00.t13
31,000_03
$ 31,000_0C
S 33.0133,03
$ 33 000,03
73 1.459
OAKLAND COUNTY LADY JUSTICE RESTORATION PROJECT
March 27, 2009
FROM: Penny Knope, Facilities Management
TO Lynn Sonkiss, Fiscal Services
Donations to the Lady Justice Restoration Project Fund
The following checks were received this week from donors to tne Lady Justice
Restoration Project. Please apply them to the Facilities Maintenance &
Operations Courthouse Sublet Repairs fund.
Check # Amount Name
0990 $25.00 Candace Rosado
21918 $100.00 Paul L. Nine
Total $125.00
Thank you,
Penny Knope
Facilities Management
Checks enclosed
Cc: R Bertolini
R. Larkin
S. Stanford
Project File
SUBJECT:
(05U -1 04 0 1?-5 - !4 05J0 - 50104 i0
*
I'
OAKLAND COUNTY LADY JUSTICE RESTORATION PROJECT
June 17, 2009
FROM: Penny Knope, Facilities Management
TO: Lynn Sonkiss, Fiscal Services
SUBJECT: Donations to the Lady Justice Restoration Project Fund
The following checks were received this week from donors to the Lady Justice
Restoration Project. Please apply them to the Facilities Maintenance &
Operations Courthouse Sublet Repairs fund.
Check # Amount Name
1314 $500.00 a Augustus Straker Bar Association
Total $500.00
Thank you,
Penny Knope
Facilities Management
Checks enclosed
Cc: P. Bertolini
R. Larkin
S. Stanford
Project File
bipe4 11_1•4 f-
(04 cl q-k"Y5co - V5 0104
IL
Planning & Economic
Development
Services
Memo
To: Tim Soave
From Dan Hunter, Manager PEDS
Date: 7/1/2009
Re: Request to write off amount owed by two One Stop Shop customers
At this time after repeated efforts to collect money owed to Oakland County, I am requesting
we write off the amounts owed to us from the following 2 entities:
1/ Landmax Properties; 440 Acorn Dr., Brighton MI 48116 Attn: C. Gratton
9/22/06 PED0000723 $3.00
10/18106 PED0000763 $8.00
TOTAL $11.00
at MCCI Realty Inc., 1258 Galloway Cir., Pontiac, MI 48340
2/27/08 PED0001372 $5.00
3/17/08 PED0001376 $15.00
4110/08 PED0001405 $ 3.00
8125/08 PED0001535 $15.00
9/11/08 PED0001541 $5.00
9/11/08 PE00001549 $12.00
10/2/08 PED0001565 $3.00
10/6/08 PED0001568 $3.00
TOTAL $61.00
Grand Total $69.00
Please let me know if you have any questions. Thanks.
• Page 1
12
aarlIM,.,- .n•n•. •MIInMl. .mlo n .MIEMMIPPMn,
MnMINIn=Er
APIs.
COUNTY MICHIGAN
,
,
WRITE-OFFS REQUESTED 09/{9/08:Revied 06/30/09- - I_ -
All et the account5 were deactivated at 90 da pet doe to prevent cuitonner access. ._, -,
-7- - + , USER NAME .STATU5 ACCOUNT HARE : AMOUNT !LAST ACTIVITY FISCAL YR
!
FERGUSON A FERGUSON. MAE T $ (26.05)* — Sep-07 '2007
GNDGROOM[N -GROUNDS GROOMING INC $ 0610101- IV,ar-06 2008
'GUARANTY N CO - $ ,L,7.50). „ILI 07 2007
HOFF ,R HOFFERT & ASSOCIATES! _ $ (65.00) _ Apr-07t 2007
INFINGRP A INDIGO FINANCIAL GROUP . , Sep-07 2007_ ,.. , — ,__ ZAMORANO A ZAMORA.NO, LUCIA ; $ (10 ni I May-07 200'i —
Credit$..aub-total _ I $ (307L70)
A -' ACTIVE ACCOUNT TT N a NOT ACTIVE ACCOUNT
REASON/7 .
STATUS ,
35O1 N KELLER WILLIAMS - $ 13.00 Jai-07. !.2007 .. _ ----____ - 3535 N MARCUS 8 MILLICHAP 15.00 May-07 2007 -- . . 3544 JTJ APPRAISALS I L 13.00, A-07 - 2007
I'-----MOT-.-XLn1 V UATION SERVICES $ 13.00 L Mar-07 2007
- 320 N 8. MR INTERNATIONAL i NC $ 9.00 - Jun-07 2007
3t 25 N ;REAL ESTATE SNE $ 39.00 Se. .7 2007
3541 N APPRAISAL SOLUTIONS $ 26 00 00-07 2007 & 200a
3553 N WELLS REAL ESTATE INVESTMENTS $ $7.50 , ' Jun-07 2007
.75:N ;TAYLOR IN STMENTS 11 $ 85 OT Oct-0 047 8 2008
3596 A GERSHAM BUSINESS PARTNERS $ / 50 Ju 1I-07 'iryp
0700 N LAKESIDE APPRAISAL I $ 13.00 JuW-7-27347
3719 A NATIONAL TITLE EXPRESS $ 1.50 . Aug-07 2007
3746 N JLS $ 13,00 Se .-07 2007
3762'N - BK AARON APPRAISAL $13..00 '
,
Feb-08 2008
-APPRGRP :N APPRAISAL GROUP $ 85.00 Jul-07 2007
BARAN.) 'N BARAN, JOSEPH S 264,00 Jun-07 2007
CONCORD N 'CONCORD R $ 9.50 Mar-07! 2007 M D 0 V V R T L N :LAND OWN R ITLE AGENCY 19. Sil 17 :2007
NEYVHOZRE N NEW HORIZON REALTY' 26.00 Au'-07 2007
PARKSAGE N CITY INSURANC MENCY 83.55 r-07 ! 2007
TREO N PRECISION APPFtAISAL CC) $ 39:00 Jun-08 2006
.I'ATELECT N - PO- - SMART PROPERTIES I $0 00 Feb-06 •2007 & 200d
STRCAPPR N STRUCTURE. APPRAISAL $ 13.00 Apr-07- '2:07
UAWLEGAL N UAW QM LEGAL SERVICES Pi-AN $ 13.00 Jai-0i 2:07
_11._______
Chia • zs 61,10 wail 671.05
MI
Teta' 1 $.-87---.35
A = ACME ACCOUNT
IBK 1-. BANKRUPTCY _ 4- _ IN = NOT ACTIVE ACCCUN —____,
I MR = MAIL RETURNED MARKED NOT DELIVERABLE
! PIF = CUSTOME -7-IN DEL-W30/09 I
I Re CUSTOMER CONTACTin6115/09 RWAT ACTIVE USE '-i;:tF ACCOUNT ,
13
$ 252.153,495.00
511,340.00
19,024,542.00
1' .683,014 co
64.663,742.00
9 217,20C 09
2.405,045 00
4-794.796 00
$ 421.525.071_00
5 2.532 205 OC 1 51%
5.200.00 1 03%
(15.8.300.00) 5 5%
(00,300.0c) ,c 43%
7.039.327 .CC -7 05%
730.300 CC 5 22%
994.0i00.00 .29 24%
257.729 0:7. 0434%
0,714.103.00) -1 11%
$ 7,431.540,7: 0.00%
$ 426,952,811.71 $ {4,714,193.06) -1.29%
General FLird/C,Ortera Pufpcle
Favorable/(Unfavorable) 4,050,391.00 $ 4.652.391.00
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
FY 2000
ADOPTED
BUDGET
BJDGET
AS
AMENDED
FY 2006
FORECAST
AMOUNT
pAvORABil•
'0AVORABLEI .PE.;:CENT
SUB-TOTAL GENERAL FUND/GENERAL PURPOSE
REVENUES
GLNERAL FUND
7axes
Federal QW:b
Slate Grants
caller 1ntef.gavemmelial F(esienue
...-..harges for Servcc
ndinaol Cu9t Recave-y
nvassment In wine
01110- Revenues
PLA,NNED USE OF PUND EALANC;E fl)
TOTAL GF/GP FUNDS
5 24973290.00 5 249.681.290.00
511.4113.00 506.140.00
18300.807.01) 19,250549.00
11,263,363.0C 11.733.914 00
89,752,8130.0C 81,673.075.00
5.495,310.00 8.5' 7.28000
16700.0C 3.399.940 00
41.315.302.00 41,527.0E7 00
$ 422.540140 oc. $ 425,239.28400
5 3 769,210 00 5 7,431.540,71
4Z8.40.20.03 $ 433,670,854 71
EXPENDITURES
ADMINI5TRATiON OF iLSTICE
Clre•ua Coart
52nd Drstrcl Court
Probate Court
TOTAL ADMIN. OF JUSTICE
LAW ENFORCEMENT
P.-04ocutIng Attorrwy
S.qeriff
TOTAL LAW ENFORCEMENT
GENERAL GOVERNMENT
Clerk/ Register of Dm%
Tr0asuror
Board af CornMiSsi.anerS
Lifxdry Board
Water Resources Cornmius•oner
TOTAL GENERAL GOVERNMENT
COUNTY EXECUEVE
County Exocutivo Admn.
Management and Budget
Central Services
Fauilities Ntanagement
.4urnon R9504/C&S
Health aria Human Serviuss
F9131838orticeu
Economic, Dev and Comm Affairs
TOJAL COUNTY EXECLIT/VE
TOTAL DEPARTMENTS
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NQ?-DEPARTMENTALS
TOTAL GOVERNMENTAL EXPENDITURE,S
87.619.2591)0
17,224.356 DO
6.3' 3.6E7 00
74,157,322 00
8,8.82.31000
124,880,518 00
9 43,763,32600
12.1 46,010.00
3.672,745.00
3.052.055.00
2.367.896.00
5.426,14.03
5 273064.555.03
$ 8,073.960 00
21.414.985.00
2,369,873 00
1,538.2615 OC
4,375 3413.46
55,362.762
111,37d 661.05
7,282,5' 7.00
126,787,87200
$ 371,742,905.00
54 607,304 00
426,416,209.20
5 57,477,558 ' 8 $ 54,088,556 18 s 3,369.000 00 5.90%
17,49,362.87 16.7E3.280.67 586 072 00 3 38%
5,390.860.24 6,221,366.24 169.000 00 2.04%
$ 81.217,771.09 5 77,073,609.09 $ 4.144.072.00 5 10%
25.01)5,894.14 19,125,194 14 383.730.00 4.42%
127.557.488 22 127,61 9.588 23 (253,130 00) -020%
Z 47566,38230 5 148.030.782,35 $ 530,830.00 0_43%
12,319.403 61 11.719,403.61 000.043.00 4.87%
4.112.600 41 4,075,606 41 37.000.00 090%
3.052.512 32 2,972,812 32 50 040.00 2.82%
2,875 47 0 52 2.494,410.52 81,000,30 3.15%
8.610 764 38 6610 754 38 . . . - 503%
5 25.670,709.24 5 27,872,759.24 E 798.000.39 2.75%
$ 8.111,71953 5 8,041 :71 9.63 $ 70,000 00 0.86%
21,925,242 22 21,378 :942.22 546,300 00 2.49%
2.410.595 79 2,392.995.79 22,600 00 0.04%
1,836.26600 1.341,666.00 190.800.00 12_78%
4,701,556.50 4,576,210 50 125,350 00 2.67%
67.001.0213 14 64,186,018.14 2,294,173 00 3.42%
16,651500,18 15,512.505.18 43,000.00 0.25%
7,866,764 10 7,505,315.10 271.449.00 3.45%
S. 130,275.801 .56 5 126,700279.68 5 . 3,569.412.00 2.74%
$ 387.733,604,35 5 3713,56e.520.38 $ 9,142.084.00 2.36%
45, w0,200..,it $ 45,7 f 7,700.32 $ 222.51)0.00 9.45%
$ 413,670,8114.71 $ 424,305.220.71 s 9,364,524.00
(1) Note that raporl foreCaStS Planned Use of Fund 531ance with a zero valiance in orner to show a balanced budget. No revenue will actually be remivel
[4
$ 249,317,790.00 $
98,500.00
120,000.00
95,t00.00
$ 249,331,290.00 $
249,317,790.00 $
98.500.00
120,000 00
95,000 00
249,631,290.00 $
251,356,995 00 5 2530,205.00
96,E:00.00
120,000 00
88,000.00 (7,(10flQj
252,163,495.00 $ 2,532,205.00
1.02% rorecast is based on the 2009 Apui Equali7elinn Report.
0.00%
0.00%
-7.37% Decrease in number of mobile homes in the county.
1.01%
68,000..00 $
82,000.00
46,000.00
68,000.00 $
70,412 00
46,000.00
68,000 00 5
75,612.00
46,000.00
0.00%
7.39%
0.00%
5,200.00
Health Division
Children's Vkage
Total Federal Grants
70,488 00
245,000.00
511,488.00 $
21,728 00
300 000.00
506,140.00
21,728 00
300,000.00
511,340.00 $
0.00%
0.00%
1.03% 5,200.00
- 3
1,000 00
4,923,300 00
14,160,249,00
19,084,549.00 $
9,360,551 00 $
(166,000.00)
(186,000.00)
(50,000.00)
District Court 2,750 00 2,750.00 2,750.00 n. no%
COUNTY OF OAKLAND
GENERAL FUND I GENERAL PURPOSE REVENUES
FY 2009 SECOND QUARTER REPORT
Adopted
Budget
Amended
Budget
FY 2009
FORECAST
Amount
Favorable
(unfavorable Percent Explanation of Significant Variances
AX.0 ge010Q(240199_91
Properly Taxes -July Tax Levy
Other [axes- Delinquent Tax - ['nor Years
Treasurur Payment in Lieu u Taxes
Other Taxes - Trailer Tax
Total Taxes
FEDERAL GRANTS (610000-6109991
Sheriff - Patrol
Sheriff - Corrective Services
County Executive - ERP Disaster Controk
54,000.00
4,500.00
STATE GRANTS (615000-615999)
Sheriff - Patrol
State Match Foster Cafe
Econ Development
Health Division
Outside Agencies - Child Care Subsidy
Total State Grants
OTHER INTER-GOVERNMENTAL REVENUES
Non-Departmenta!
County Executive
Circuit Court
1,000.00
5.099,807.00
1130200 000 00
$ 13,300,807.00
54,000.00 5
4,500.00
- 3
1,000.00
5,089,300.00
14,160,249.00
19,250,549.00 $
9,410,551.00 5
64,000.00 $
4,500.00
100.00%
0.00%
0.00%
-3.26% Reduction in CPBC Contract
0.00%
-0.86%
-0.53% Ue0reased State Court Equity payments from the State.
The budget for Cony Facility lax will be amended after final
payment and will include tl-To offsetting budget amendment
for Substance Abuse.
0.00%
0.00%
(620000 - 626999)
8,940.000 00
Sheriff
Non-Departmental
Total Other Intergovernmental Revenue
CLIARGES FOR seRvicEs (630000-635999
300.000 DC
1J:152,113.00_
.263..30
300,000 00
1,562,113.00
11,733,914.00 $
300,000 0
1 96;
11,68 (50,000 00)
0.00%
0.00%
-0,43%
• Revenue variance is partially offset by an expenditure v0 0-00-e
AcInninIstration of Justice
Circuit Court - Civil/Cnminel 3,162,804.00 $ 3,062,804.40 5 2,932,604.00 (130.000 00)
Circuit Court - f-amity Division 1,608,600.00 1,808,600.00 1.931,90000 123,e00.00
District Court - Division II (Clarkston) 2,225,369 ro 2,242,623 00 2,014,623.00 (228,000 00)
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FY 2009 SECOND QUARTER REPORT
Adopted
Budaet
Amended
Etudget
FY 2009
FOREGAST
Amount
Favorable
(unfavorable) Percent ExplanetIon of Significant Variances
-4.24% Unfav variance is due to a decrease in Mediation fees
collected. The decrease in fees collected is due to an
increase in the public's use of alternative dispute resolution
other than Mediation. Please note: Mediation payments
have an 100% offset expenditure account.
6 82% Fay. variance is due to an increase in Defense Attorney fees
and Gov't Board and Care payments heing collected
District Court - Division I (Novi) 4,183.804.00 4,183,804 00 4,007,204 00 (176,606.00; -422%
Unfav. variance is due to defendants' inahility to pay fees to
the court. The court is experiencing a decrease in their
ability to collect fees, fines and costs due to rising
unemployment, the credit cests and other negative
economic external factors. To mitigate the amount of
revenue shortfall the Court imolemented on April 1, 2009 the
tee increases the court purposed during the FY 2010 budget
task, and on June 1, 2009 the court implemented a riew
Flees end costs schedule. The amounts seown include a
conservative financial effect of the above increases.
-10.17% Unfae. Variance is due to defendants' inabitity to pay fees Ic
the court. The court is experienchrig a decrease in their
ability to coiled' fees, fines and costs due to rising
unemployment, the credit crisis and other negative
economic external factors. To mitigate the amount of
revenue shortfall the Court implemented on April 1, 2000 the
fee increases the court purposed during the FY 2010 budget
tase, and on June 1, 2000 the court implemented a new
fines and costs schedule, The amounts shown include a
conservative financial effect of the above increases. 52-2 is
experiencing a reelection in Stale eaw cases resulting in a
shortfall ($180,000.) Sate Police re-allocating their
resources to other parts of the ceunev and Governor
GranhoIrree Fxecittive Order 2009-22 restricting State Police
in some of their functioris to reduce cost are the primary
reasons for the State eaw case decrease.
District Court. Division III (Rochester I-I ills) 4,289,772.00 4,289,772.00 4.037,772.00 1252,000 00) -5.87%
Unfav. Variance is dee to defendants' inability to pay fees to
the court. The court is experiencing a decrease in their
ability to collect fees, fines and costs due to rising
unemployment, the credit crisis and other negative
economic external factors. To mitigate the amount of
revenue eticiefall the Court implemented on April 1, 2009 the
fee increases the court purposed during the FY 2010 budget
task, and on June 1. 2069 the court implemented a new
fines and costs schedule. The amounts shown include a
conservative finaricial effect of the above increases.
• Revenue variance is partially offset by an expenditure variance
Probate Court - Estates and Mental Health
Total Administration of Justice
Law Enforcement
Prosecuting Attorney
566,300.00
18,519,859.00 3
213,300 00 $
District Court - revision IV (Troy)
Adopted
Rudest
2,283,210 00
Amended
Dudoe1
2,233,210.00
FY 2009
FORECAST
2.067,060.00
566,300 00 566,300.00
30,600.00 213,300 00 $ 243,900.00 $
Sherifrs Office
Sheriff - Administrative Services
Sheriff - Corrective Services
Sheriff - Corrective Services Satellites
Sheriff - Emer. Prep. Traileigt & Conine
Sheriff - Patrol Services
Sheriff - Investigative Forensic Services
Total Law Enforcement
General Government
Clerk - County Clerk
Clerk - Elections
Clerk - Register of Deeds & Micrographics
1,201,900 00
192,100 00
1,641.000.00
1,325..926.00
473,716.00
32,744,629.00
108,500.00
37,901,071.00 3
2,495,634.00 $
267,166.00
12,445,200.00
99,400.00
314,600.00
99,900.00
335,600.00
3,003,266.00
1,325,926 00
473,716.00
32,875,186.00
3,009,266 00
1,325,926.00
473,116.00
33,112,886 (10
510,690 00
38,816,084.00 $
555,790.00
39,156,984 Or $
2,495,634.00 $ 2,296,634 00 $
265,091.00
12,445,200.00
269,091.00
9.111,200.00
237,700.00
45,100.00
340,900.00
(199,000.00)
(3,334,000 00)
COUNTY OF OAKLAND
GENERAL FUND I GENERAL PURPOSE REVENUES
FY 2009 SECOND QUARTER REPORT
Amount
Favorable
'unfavorable) Percent Explanation of Significant Variances
(716,150.00) -9 47%
Varrance is due to defendants' inability to pay lees to
the mint. The court is experiencing a decrease in their
ability to collect fees, fines and costs due to rising
unemployment. tee credit crisis and other negative
economic external factors. To mitigate the amount of
revenue shortfall the Court implemented en April 1, 2009 the
fee increases the court purposed during the FY 2010 budget
task, and on June 1, 2009 the court implemented a new
fines and costs schedule. The amounts shown include a
conservative financial effect of the above increases,
0.00%
18,437,113.00 17,557,663.00 $ (B79,450.00)
14.05% Fay. due to yearly receipt of non-budgeted revenue: Class
Fees, Extradition Recovery Fee, Microfilming, Welfare Fraud
Case Review. This revenue is not budgeted due to the
intermittent and indeterminate amount of receipts.
0.50% 1-av due to receipt of Miscellaneous revenue.
6,68% Fav. clue to increase receipts of Fingerprint revenue for
teachers and yearly receipt of non-budgeted revenue for
Photographs. This revenue is not budgeted due to the
intermittent and indeterminate amount of receipts.
6,000.00 0.20% Fav Diverted Felon and OUIL Third Offense revenue.
0.00%
0.00%
0e'2% Fay due to Reimbursement of Salaries for deputy patrol
services
8.83% Fay due to increased Gun Registration revenues.
-7 97% Unfav. Appeals Appellate Court ($4,000), Assumed Names
(330.000), Bond Fees ($30,040), Co Partnership New
($5.000), Forfeiture of Suety Rends ($60,000), Jury Fees
($50,000) and Passport Fees $20,000) due to lower than
anticipated activity and related to the downturn in the
economy.
0 0.11%
-26.79% Unfav tend Transler Talc ($2,000,000), Mortgages
($1,000,000) and Recording Fees ($300,000) due tre the
downturn in the housing market and Microfilming ($34,000)
due to a decrease in volume from outside 'Isere
500.00
21,000.00
Revenue variance is partially offset by an expenditure variance.
20,297,454.00 $ 21,156,593.00 $
200,000.00 $ 200,006 00 5
300.00 300.00
30,00100 30,000.00
75,000 00 75,000.00
2,761,141 00 2.761,141.00
415,600.00 415.600.00
158,000.00 1E8.,000..00
800.00 800.00
Treasurer
Board of Commissioners
Library Board
Water Resources Commissioner
Total General Government
County Executive
County Exec - Administration
County Exec - EP
County Exec - Aud it kng
M&B - Purchasing rtivision
M&13 - Equalization Division
M&B - Fiscal Services Division
Central Services - Support Services
Facilities Engineering
Human Resources
Adopted
Budget
3,291,641.00
Amended
Buduet
3,291441.00
1,760,113 00 2,627,427.00
1,700.00 600.00
27,000.00 27,000.00
FY 2009
FORECA§T
1,965,200.00
600.00
59,000.00
2,577,427 00 (50,000.00)
16,279,152.00 (4,877,441.00)
118.52% Fav. Reimb Salaries due to State of Michigan reinstating
funding for LVPI operations $21,000 and the stipend for the
Director $2,400. Also Fav. Miscellaneous revenue $8,000,
as a result of more patrons printing material off the
computer.
-1.90% Unfav Solt Erosion Fees (550,000) decrease in building
activity/permits due to downturn in housing market.
32,000.00
150.000.00
3,714,657.00
150,000.00
2,344,136.00
3,019,533.00
392,000.00
3,019,530.00
392,000.00
Human Services - Administration
Human Services - Health Division
Human Services - Children's Village
Public Services - Community Corrections
3,674,86 1.00
2,879,530.00
413,000.00
100.00%
(1,370,531.001 -36,90% (Unfav) Lab Charges ($180,000), Flu 3rd Party t$276,542),
Flu Vacinne Fees (151,810), Well Permits ($274,331) and
Sewerage Permits ($480,426), Immunizations ($200,000),
and Control Plats ($14,000) due to slow economy. Fav.
Food Service License $206,580. Also, the Health Division is
no longer receiving administration fees on immunizations
which was replaced by a tee structure. G112
0.00%
0 00%
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FY 2009 SECOND QUARTER REPORT
200,000.00
300.00
30,000.00
170,000.00
2,7E1 ,141 00
415,600.00
153,000.00
,800. 00
Amount
Favorable
iunfavora Wel Percent Explanation gf Significant Variances
(1,326,441.001 -40.30% Unfav.- The Industrial Facilities Exemption Tax role is
collected and recorded in the Treasurer's budget. If the
Treasurer does not collect the amount owed by the taxpayer
on time, the IFT exemption is revoked and falls back to the
general tax role. This combined with re-valuations has
decreased the amount of revenue collected within the
Treasurer's budget.
0.00%
0.00%
0.00%
0.00%
95,000.00 17t67% Increased activity from vendor reimbursernert program.
0.00%
0.00%
(5,000.00) -3.16% ilecrease in proceeds from vending machines.
100.00%
1,00000 125.00% I-IR received national SHRM (Society for Human Resources
Management) award of $1,000 for submitting the Oakland
County 2008 Voluntary Separation Incentive Program as an
innovative approach towards dealing with the economic
downturn. The program included reorganizations and
deletioes without any Layoffs. Oakland County was one of .
15 recipients to receive this award nationwide
Revenue variance is partially offset by an expenditure variance.
Adopted
Budget
06,360.00
Amended
Budget
66,360.00
FY 2009
FORECAST
40,555.00 Public Services - MSU Extension
Public Services - Medical Examiner 303,000.00 223,000.00 199,000.00
20,500.00 5
150,000.00
3,229,449 00
3,399,949.00 $
410,340.00 $
220,406.00
20,395.00
419,340.00 $
230,306.00
20,395.00
0.00%
9,900 00 4.40% eev due to receipt of Refund of Prior Year Expenditures.
0.00%
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FY 2009 SECOND QUARTER REPORT
Amount
Favorable
Junfavorablel Percent Explanation of Significant Variances
(19,805 00) -29.84% Unfav. Reimbursement General (517,805) due to fewer
participants in the Natural Sciences programs and the loss
of the AmeriCorp reimbursement ($1 ,000) from the State
which covered miscellaneous expenses for an AmeriCorp
employee. Also, Unfev Reimbursement Postage ($1,000)
due to a decrease in postage reimbursement from Micnigan
St8 to University. Note expenditure offset
(24,000.00) -10.76% klnfav. Autopsies ($15,000), Medical Services ($6,000) and
Miscellaneous ($22,000) duc to lower than anticipated
caseload: partially offset by Fay. Cremation Approval Fees
$20,000 due to a higher than anticipated caseload.
Public Services - Animal Control
Economic Dev. & Comm. Affairs - Aemin
Economic Dev. & Comm. Affairs - PEDS
total County Executive
Non-Departmental
Non-Dept - Charges for Services
Total Non-Departmental
Total Charges for Services
INDIRECT COST RECOVERY (640100)
785,887.00 785,887 00 785,887.00 -
71,000.00 271,000.00 251,000 00 (20,000.00)
$ 12,034,505.00 $ 12,263,265.00 5 10,919,945 00 5 (1,343,336.00)
5 1,000,000.00 i 1,000,000.00 $ 750,000.00 $ (250,000.00)
$ 1,000,000.00 3 1_000,000.00 5 150,000.00 $ (250,000.00)
$ 89,752,889.00 5 91,873,975.00 $ 84,683,748.00 $ (7,009,327.00)
$ 8,495,310.00 $ 8,517,280.00 $ 9,217,280.00 $ 700,000.00
0.00%
0.00%
-7.38% - Lower Sale of Maps caused by housing market slowdown.
-25.00% Unfav Commission due to decreased usage of pay phones.
-25-00%
-7.65%
8.22% Final allocations were not available during budget process
and did not anticipate this level of grant awards, reimbursing
for indirect cost recovery.
INVESTMENT INCOME 055000-85599V
District Courts Div. I - IV) 20,500.00 $
Clerk/Register of Deeds 150,000.00
Non-Departmental 3,500,000.00
Total Investment income 3.870.500.00 $
111500.00 $ (10,000.00) -48.76% Unfav. due to lower interest rates and volatile financial
markets.
66,000,00 (84,000.00) -56.00% Unfa e due to lower interest rates and volatile financial
markets.
2,229,449.00 (900,000.00) -27.87% -Unfav due to lower interest rates and volatile financial
markets.
2,405,949.00 5 (994,000.00) -29.241/4
OTNER nYkNUES (970D00-696,1901
Prosecuting Attorney
Sheriff Office
Sheriff Office - Transfer In (Jail Pop. Fund)
Circuit Court
District Court
Probate Cowl
Clerk/Register of Deeds
Treasurer
_Library Board
142,600.00 $
34,826.00
- _ 3,7 - re) 3,732.00 100.00% Fay. Due to cash overages
1,000.00 1,00000 1 100.00%
- - 54.00 100.00% Fay Due to cash overages.
• Revenue variance is partially offset by an expenditure variance.
Water Resources Commissioner
County Executive - ERP Equipment
Management and Budget
Central Senrices - Support Services
Facilities Engineering
Health Division
Children's Village
Public Services
Economic Development - Donation
Non Departmental - Donations
Non-Dept - Sundry
Treasurers' Transfers
Non-Dept - Transfers
Total Other Revenues
Amended
Udtlet
4,300.00
44,000.00
60,000.00
417,500.00
3,500,000.00
36,840,128.00
41,527,067,00
Adopted
Budge!
3,500,000.00
-
-15,000 00
60,000 00
417,500 00
4,300.00
36,840,126.0C
$ 41,015,352.00
36,852,625.00
41,794,796.00 $
FY 2005
FORECAST
30.00
4:30000
728.00
230,785.00
44,000.00
60,000 00
117,500.00
3,810,000.00
37610.00
3,769,210.00
2,991.694.71
4,439,846.00 $
7,431,540.71 $
2,991604.71
4,439,846.00
7,431,540.71 $
0.00%
0.00%
TOTAL GEN. FUND / GEN. PURPOSE REVENU 426 410 209.00 426 433 670, 604I1 426 956 611.71 4 714 193.00 p 4264956 611.71 1 4,714.193.001 -1.09%
COUNTY OF OAKLAND
GENERAL FUND! GENERAL PURPOSE REVENUES
FY 2(09 SECOND QUARTER REPORT
Amount
Favorable
(unfavorable) Percent
30.00 10000% Fay. Due to cash overages.
0.00%
100.00%
0 00%
728.00 100.00%
230,785.00 100.00% Favorable Refund Prior Years Expenditure.
100.00%
0.00%
-71.86% Previous year misc receipts were lavufable due to prior year
adjustments. No major adjustments are anticipated al this
time
8.86% Total Property Tax Forfeiture Collections fees transferred in
from the DTRF are more than originally entidpated The
Increase is due to a rise in doliquent tax collections in past
three years.
0.03%
0.64%
Explanation of Siunificant Variances
ii300,000 00)
310,000.00
12,500 00
267,729.00
PLANNED USE OF FUND BALANCE (665000-665999)
Encurn and Approp Carry Forward
General Fund - Prior Years Faience
Total Planned Use of Fund Balance
t
'Revenue variance is iparlialiy offset by an expenditure variance.
44,017.00
222,888.00
344,592.48
421,994.43
344.592.48
421,994.43
26,974.00
261,245.00
26,974.00
265,303.55
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
CIRCUIT COURT
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2009
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Judicial Administration
Personnel Expenditures
Operating Expenditures
Internet Support Expenditures
Transfer Out
Business Division
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 8,896,049 00 5 8,825,266.05 $ 8,700,266.05 5 125,000.00
S 9,162,954.00 $ 9,591,852.96 $ 9,466,852.96 $ 125,000.00
2.086,082.00 $ 2,092,011.69 $ 1,892,011.69 $ 200,000.00
26,974.00
222,30.3.55 43,000.00
1.42% - Fay. variance is due to the county wide hiring freeze and under filled
positions
0.00% -
0.00% - •
0.00%
1.30%
9.56% - Fey. variance is due to the county wide hiring freeze, vacancies and
under filled positions.
0.00% -
16.21% - Fee variance doe to a decrease in phone rates and monthly Info
Tech department charges.
$ 2,374,301.00 3 2,384,2e9.24 $ 2,141,289.24 $ 243,000.00 10.19%
Civil /Criminal Division
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
transfers Out
5 2,627,957.00 $ 2,624,921.34 5 2,504,921 34 $ 120,000.00
5,825,324.00 5,676,108.41 5,351,108.41
2,508,526.90 2,450,526,90 58,000.00
- 19,212.00 19,212,C0
$ 10,862,902.00 $ 10,828,768.66 $ 10,325,768.65 5
4.57% - Fay. variance is due to the county wide hiring freeze, vacancies and
under filled positions..
5.73% - Fav. variance is due to a decrease in demand for Mediators and
Appointed Defense Attorneys. The Court is experiencing en increase
in alternative dispute methods of resolution other than mediation,
resulting In a seduction expenditures. Please note: Mediation has an
unfavorable revenue line item that offsets the favorable eenenditure.
2.31% - Fay. variance due to a 'decrease in phone rates and monthly Info
Tech department charges.
0.00% -
325,000.00
2,409,621.00
5031000.00 4.65%
6129/2009
Operating Expenditures
Internal Support Expenditures
Transfer Out
12,817,652.00
1.750,296.00
13,927,292.68
1,7E5,334.55
5,386,431.00
13.371,292.68
1,683,334.55
4,796,431.00
1,300,000.00
5E8,000.00
72,000.00
590,000.00
Family DivIsionlJuvenlle Maint.
Personnel Expenditures $ 13,651,164.00 $ 13,603.589.10 $ 12,303,589.10 $
27,145,786.18
19,974,967.57
4,951,159 43
5,405,643.00
$ 25,400,788.18
19,093,967.57
4,778,159.43
4.815,643.00
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
CIRCUIT COURT
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2009
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
- Fay. variance is due to the county wide hiring freeze. 17 FIE
positions are being filled with PTNE employees resulting in cost
savings in Fringe Benefits. Child Care Fund positions are included in
these amounts therefore there is a 50% revenue offset for positions
funded by the Child Care Fund.
3.99% - Fav. variance is due to a decrease In placements to State
Institutions; offset by a increase in placements to Private Institutions.
4.10% - Fay. variance due to a decrease in phone rates and morithly Info
Tech department charges.
0.00% - Fey, variance is due to the Friend of the Court grant requiring less
than anticipated funding as a result of the county wide hiring freeze,
reduction in phone rates, reduction in info tech monthly department
charges, and capital expenditure policy. The FOC has 16 FTE
positions under filled with PTNE positions.
$ 28,219,112.00 $ 34,672,647.33 $ 32,154,647.33 $ 2,518,00000 7.26%
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
$ 27,261,252.00 $
18,713,967.00
4,644,050.00
-
-------------
$ 50,619,269.00 $
1,745,000.00 6.43%
881,000.00 4.41%
173,000.00 3.49%
590,00000 10.91%
$ 54,088,558.18 $ 3,389,000.00 5.90%
6/29/2009
207,22'1.00 237.917.94
0.00%
2.44% - lay.. variance cue to the county wide hiring freeze and
under filled positions.
2.30% Fav, variance due to the department's effort to control
cost in printing of $10,000, Travel and Conference al
$5,000 end Postage and Mailing of $10,000.
10.92% Fav. variance due to a decrease in phone rates and
monthly Into Tech department charges.
5 5,604,022,00 5 5,630,058.78 5 5,453,458.78 5 1 6D0.00 314%
1C9,579.0C $ 109,579.00 $ 109,579.00 $
$ 4,054,000.00 $ 4,059,556.94 $ 3,960,658.94 $ 99.000 00
1,083,641.00 1,088,641.00 7,063,641.00 25,000.00
466,381.00 481,868.84 429,258.84 52,600.00
COUNTY Or OAKLAN D
FY 2000 SECOND QUARTER REPORT
EXPENDITURES
DISTRICT COURT
ADOPTED
E1UDCET
AMOUNT
AMENDED FY 2009 FAVORABLE
BUDGET FORECAST (UNFAVORABLE) PERCENT EXPIATION OF SIGNIFICANT VARIANCES
District Court Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
Division 1 - Novi
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Total Division 1 - Novi
Division 2 - Clarkston
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
Total Division 2 Clarkston
$ 49,279 00 $ 49,279.00 $ 49,2 f9.00 $
60,300.00 60,300.00 60,300.00
3 1,771,719 CO $ 1,779,688.90 $ 1,689,838.90 $ 89,850.00
628,950.00 628.950.00 593,995.00 34,955.00
226,817.94 11:100,00
55,557 00 72,811.00
$ 2,663,473.00 $ 2,719,367134 $ 2,681,462.84 $ 135,905.00
-^ ---------- A ------------------- -----
0.00% -
0.00% -
0.00%
5.06% - Fay.. valance due to the county wide hiring freeze,
vacancies, and under filled powtions.
5.66% - Fa v. variance rlt;e to the court's efforts on reducing
costs and a reduction in the amount of Court Appointed
defense 'attorneys being used,
4.67% - F2V. vanance due to a decrease in phone rates and
monthly Info Tech department charges,
0.00% -
5.00%
72,811.00
4.JJ
6,29/2009
Division 3- Rochester Hilts
Personnel Expenditures
Operating Expenditures
$ 3,866,782.00 $ 3,871,324.00 $ 3,871,324.00 $
416,912.00 416,912.00 308,499.00 108,413.00
internal Support Expend:tures 1,238,904.00 1,262274 55 1,218,120.55 44,154.00
Division 4- Troy
Personnel Expenditures
Operating Expenditures
$ 2,443,376.00 $ 2,447,548.42 $ 2,407,548.42 $ 40,000.00
521,458.00 516,45,8.00 474,458.00 42,000.00
Internal Support Expenditures 359,860 00 375,830.08 336,830.08 39,000.00
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
DISTRICT COURT
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2009
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
0.00% -
26.00% - Fay. variance due to the court's efforts on reducing
costs and a reduction in tne amount of Court Appointed
defense attorneys being used.
3.50% - Fay. variance due to a decrease in phone rates and
monthly Info Tech department charges.
$ 5,522,598.00 $ 5,550,510.55 5 5,397,943.55 $ 152,567.00 2.75%
- Fay. variance due to the county wide hiring freeze,
1.63% vacancies, and under filled positions.
8.13% - Fav. variance due to the court's efforts on reducing
costs and a reduction in the amount of Court Appoii ted
defense attorneys being used.
10.38% - Fav. due to less than anticipated amounts budgeted in
the print shop line item, an reduction in Telephone
rates, and en reduction in Info Tech monthly charges.
Historically the court has not spent the appropriated
amounts within their budget. The court does not foresee
any changes to current operations from prior years
operations that would result in additional spending.
$ 3,324,694.00 $ 3,329,836 50 $ 3,218,836.50 $ 121,000.00 3.62%
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 12,185,176.00
2,711,261.00
2,272,372.00
55,557.00
$ 17,224,366.00
$ 12,207,399.26
2,711,261.00
2,357,861.41
72,811.00
$ 17,349,352.67
$ 11,978,549.26 $ 228,850.00 1.87%
2,500,893.00 210,368.00 7.76%
2,211,027.41 146,854.00 6.23%
72,811.00
5 16,763,280.67 $ 586,072 00 3 38%
6/29/2009
0.00%
0.00%
$2.502.126.00 52,512,832.65 $ 2.512,832.65 $ 0.00%
$2,257,729.00 $2,270,113.13 $2,136.113.13 $ 134,000.00
714,072.M 15,000.00
20,000,00
..... --
169.000.00 4.36%
134,000.00 2.82%
15,000.00 1.91%
20,000.00 2.30%
737,323.00 722,323.00
839,7fiC..00 870,591.46 650,591.46
$3.811,561.00 $3,878,027.5.9 $ 3,709,027.59 $
$ 4,713,874.00
760,053.00
83%7€0.00
$4,736,964.78 $ 4,602,964.78 $
783,304.00 766,304.00
870,591A6 350.591.46
$6,390,860.24 $ 6,221,860.24 $ 169,000.00 2.64% $ 6,313,687.00
Estates/Mental Health
Personnel Expenditures
Operating Expenditures
Internal Support
Department Total
Personnel Expendrtures
Operating Expenditures
Internal Support
Transfer Out
5.90% Fay. variance is due to the hiring freeze policy in
effect for FY 2009. Pusition #2490 will remain
vacant throughout 1-Y 2009. The Board of
Commissioners deleted position #9907 in May of
2009 and recognized the savings of $56,000 after
the 2nd quiter had ended. A budget amendmerit
was made reducing the favoraMity of $134,000 to
$78,000.
2.03% Fay. variance is due to the &tort to reduce capital
purchases as part of budget reductions.
2.30% FAv. variance is due to a decrease in Info Tech
monthly charges. The court historically has not
spent the amount appropriated.
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
PROBATE COURT
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2009 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
JudiclaltAdministration
Personnel Expenditures
Operating Expenditure
Internal Support
Transfer Out
$ 2,456%14t.0•
45,981.00
$2,466,851.65 $2,466,851.65 $
45.981.00 45,E-81.00
6129:2009
Operating Expenditures
Internal Support
134,000.00
15.000.00
20,000.00
2.83%
1.91%
2.30%
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
PROBATE COURT
AMOUNT
ADOPTED AMENDED FY 2009 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
------ --------
JudidallAdtrolnisfration
Personnel Expenditures $ 2,456.145.00 $ 2,466,851.65 5 2.466.851.65 $ - 0.00%
Operating Expenditures 45,981.00 45,981.00 45,981.00 0.00%
Internal Support - - . -
Transfer Out
$ 2.502,126.00 $ 2,512,832.65 $ 2,512,832.65 $ 0.00%
Estates/Mental Health
Personnel Expenditures
$ 2,257,729.00 $ 2,270,113.13 $ 2,136,113.13 $ 134,000.00 5.90% Fay. variance is due to the hiring freeze policy in
effect for FY 2009. Position #2490 will remain
vacant throughout FY 2009. The Board of
Commissioners deleted position #9907 in May of
2009 and recognized the savings of $56,000 after
the 2nd quarter had ended.. A budget amendment
was made reducing the favorability of $134,000 b
$78,000.
714,072.00 737,323.00 722.323.00 15,000.00 2.03% Fav. variance is due In the effort to reduce capital
purchases as part of budget reductions.
839,760.00 870,591.46 850,591.46 20,000.00 2.30% Fav, variance is due to a decrease in Info Tech
monthly charges. The court historically has not
spent the amount appropriated.
$ 3,811,561.00 $ 3,878,027.59 $ 3,709,027.59 $ 169,000.00 4.36%
Department Total
Personnel Expenditures $ 4,713,874.00 $ 4,736,964.78 $ 4,602,964.78 $
Operating Expenditures 760,053.00 783,304.00 768,304.00
Internal Support 839,760.00 870,591.46 850,591.46
Transfer Out
$ 6,313,687.00 $ 6,390,860,24 $ 6,221,860.24 $ 169,000.00 2.64%
6/2612009
Administration
Personnel Expenditures
Operating Expenditures
$ 2,642,317.00 $ 2,677,845.66 $ 2,321,145.66 $
036,872.00 836,982.50 800,882.50
356,700.00
26,100_00
1,803,005.00 1,938,523.72
9,883.00
$ 5,372,194.00 $ 5,463,234.88
1,938,523.72
9,883 00
$ 5,070,434.88 $ 392,800.00
Internal Support Expenditures
Transfers
0.00%
0.00%
7,19%
$ 2,100,825.00 $ 2,098,379.30 $ 1,981,879.30 $ 116,500.00
3,100.00 3,199.00 3,109.00
$ 2,104,024.00 $ 2,101,578.30 $ 1,985,078.30 $ 116,500.00
2.46%
30.02%
0.00%
0.00%
Fav. doo largely to vacant positions and underfPls.
Fay due to lower personal mileage use.
5.55% Fay, due largely to vacant positions and underfills.
0.00%
0.00%
5.54%
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
PROSECUTING ATTORNEY
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2009 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
13.32% Fay. due largely to vacant positions and underfills.
4.31% Fay due to Prosseculor does not plan to use Special
Prosecutor !ine item; and projected -favorability in printing,
membership dues, microfilming, fiiing fees; paritaily offset
by increase in office supplies due to incorn.ng new
Prosecuting Attorney.
Litigation
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
Warrants
Personnel Expenditures
Operaitlag Expend tures
Internal Support Expenditures
$ 9,646,800.00 $ 9,503,798.84
59,296.00 59,296.00
2,334.00 2,334.00
1,081,836.00
$ 9,707,430.00 $ 10,747,264.84
$ 9,367,698.84 $ 236,/00.00
41,496.00 17,800..00
2,334.00
1,081,836.00
$ 10,493,364.84 $ 253,900,00 2.36%
6/26.2009
5.16%
5.94%
0.00%
0.00%
829,800,00
53,900.00
$ 1,690,704.00 $ 1,688,358 12 $ 1,567,858.12 $ 120,500.00
8,458.00 8,458.00 8,458.00
$ 1,699,162.00 $ 1,696,816,12 $ 1,576,316.12 $ 120,500.00
7.14% Fav. due largely to vacant positions and underfills.
0.00%
0.00%
710%
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
PROSECUTING ATTORNEY
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2009 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Appellate
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Department
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
$ 16,079,646.00 $ 16,068,381.92 $ 15,238,581.92
907,825.00 907,935.50 854,035.50
1,895,339.00 1,940,857.72 1,940,857.72
1,091,719.00 1,091,719.00
$ 18,882,810.00 $ 20,008,894.14 $ 19,125,194.14 $ 883,700.00 4.42%
t •-)
1:18 6126/2009
Sheriff's Office
I'ersonnel Expenditures $ 1,536,828.00 $ 1,533,463.05 $ 1,575,263.05 $ (.41.800.00) -2.73%
Operating Expenditures
Internal Support Expendihres
Transfers
41,202.00
336,246.00
162,282.00
336,317.00
162:262.00
336,317.00
0.00%
0.00%
76,200.00
23,900.00
Fay. due to underlies and vacancies (turnover).
Fav due Office Stipples, and Postage-Standard Mailing.
4.04%
2.56%
0.00%
0.00%
$ 3,050,558.0(3 $ 3,187,488.32 $
Corrective Services
Personnel Expenditures
Operating Expenditures
31,713,299.00 $
6.500,477 00
31,886,633 93 $
6,981,671.29
31,764,43a93
6,694,171,29
122,200.00
287,500.00
Internet Support Expenditures
Transfers
7,82C,265,0( 6,110.073.83 8,110,013.83
0.00%
0.00%
W00%
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
SHERIFF'S OFFICE
FY 200n
FORECAST
ADOPTED AMENDED
BUDGET BUDGET
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANAIION OF SIGNIFICANT VARIANCES
Unfav due largely to retirement, hospitalization, and other fringe
benefits is in exc.t.,ryf laLic15e7; this is partially offset by overtime
usage projectec.: to be favorable. The Sheriffs budget for FY 2006
was :Amended at year end 41 recogoition of this disparity. A budget
amendment is not recommended at this time, situation will be
monitored and addressed at year end.
$ 1.920,276.00 $ 2,032,062.05 $ 2,073,862.05 $ 41,80O,00, -2.06%
Administrathhe Servrces
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 1,803,127.00
879,842.00
367,589.00
$ 1,886,919.56
932,956.76
367,589 00
$ 1,810,719.56
909,056.76
367,589.00
3,067,355.32 5 100,100.00 3.14%
0.38% Fey, due to underfills arid vacancies (turnovert
4.12% Fey, due largely to HosPealizetion of Prisoners line item, contracted
with new hos,Nal at lower priee.
Corrective Services-Satellites
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Trdrisfers
$ 46,034,041.00 $ 46,978,379.05 5
$ W309,37510 $ 16,460,843.00 $
310,500.00
1,540,879.00
46,568,679,05 $ 409,700.00 0.87%
16,597,543.00 $ (137,0001)0)
(31)00.00) -1.10%
1,543,845.09
Unfav. due largely to projinted overtime usage, retirement, and
hosoitalization is in excess of budget; this is partially offset by
favorable sa;aries due to several vacant deputy positions. The
Sheriffs budget for FY 2008 was amended at year end in
recognition of this disparity. budget amendment .s not
recommended arr this lime; situation will be monitored and
addressed at year end.
Unfav due to Perscnal Mileage Travel Employee Taxable Meals
expenditures ineurren by this division but budgeted ir other
divisions.
327,700.01
1,543,845.09
-0.83%
331,300.01
$ 18,161,054.00 5 18,332,386 10 S 18,4 72,^)88.10 (14' 'n 09) -0.77%
6/3012009
4,751,867.00 $
190,649.00
203,526.00
4,788,613.00
190,649.00
203,526 00
Patrol Services
Personnel Expenditures $33,849,592 $ 33,942,077.00 $ 34,542,177.00 $ (600,100.00) -1.77%
Operating Expenditures 274,873.00 324,473.25 352,273.25 (27,800.00) -8.57%
Investigative/Forensic Svcs
Personnel Expenditures $ 7,280,860,00 $ 7,486,472.00 $ 7,511,772.00 $
Operating Expenditures 516,670.00 816,327.00 824,427.00 (8,100.00) -0.99%
Internal Support Expenditures
Transfers
2,395,762 00 2,396,164.00
605.828.00
2,396,164.00
605,828.00
0.00%
0.00%
$ 10.193,292.00 $ 11,304,791.00
Department Total
Personnel Expenditures
Operating Expenditures
internal Support Expenditures
Transfer Out
$ 97,244,948.00
6,720,513.00
18,915,055.00
$ 97,985,021.54
9,736,059.31
19,230,579.37
605,828.00
$ 124,880,516.00 $ 127,557,486.22
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
SHERIFF'S OFFICE
AMENDED
BUDGET
ADOPTED
BUDGET
FY 2009
FOR
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 5,146,042.00 $ 5,182,788.00
Emergency Prep., Trning & Comm.
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 4,694,513.00 $ 94,100.00 1.97%
203,949.00 (13,300.00) -6.98%
203,526.00 0.00%
0.00%
$ 5,101,988.00 $ 80,800.00 1.56%
Fav due to undertills and vacancies (turnover).
Unfav due largely to increase expense for Office Supplies,
Equipment Rental, and Personal Mileage.
Unfav. due largely to salary and fringe benefits for retirement, arid
hospitalization in excess of budget. This variance is partially offset
by favorability in revenue of $237,700 in reimbursement of saiaries.
The Sheriffs budget for FY 2008 was amended at year end in
recognition of these disparities. A budget amendment is not
recommended at this time; situation .efil! be monitored and
addressed at year end.
Unfav due largely to increased use of Office Supplies, Other
Expendable Equipment, Printing, arid Personal Mileage,
$ 40,375,253.00 $ 40,539,614.70 $ 41,167,514.70 $
Internal Support Expenditures
Transfers
6,250,788.00 6,273,064.45 6,273,064,45 0.00%
0.00%
[627,900.00i -1.55%
(25, 300.0.1.1) •.0.34% Unfav. due largely to projected overtime usage, retirement and
hospitalization is in excess of budget; this is partially offset by
favorable salaries due to vacancies and turnover. The Sheriffs
budget for FY 2008 was amended at year end in recognition of this
disparity. A budget amendment is not recommended at this time;
situation will be monitored and addressed at year end.
Unfav due to Towing and Storage Fees, and Deputy Supplies
expenditures incurred by this division but budgeted in other
divisions.
$ 11,338,191.00 $ (33,400.00J -0.30%
$ 98,496,721.54 $ (511,700,00) -0.52%
9,477,459.31 258,600.00 2.66%
19.230,576.37 0.00%
605,828.00 0.00%
.................. .......... ______________.
$ 127,810,588.22 $ (253,100.00) -0.20%
6/30/2009
ADOPTED
BUDGET
AMENDED
BUDGET
1n•••n•••••n•••••n1
0.00%
0.00%
0.00%
0.00%
0.00%
County Clerk (Vital Stets & Legal Rees)
Personnel Expenditures $ 3,349,258.00 $
Operating Expenditures 297,408.00
3,349,067.00 $ 3,309,057.00 $
299,333.48 264,333.48
40,000,00
35,400.00
0.00%
0.00%
0.00%
0.00%
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
CLERKIREGISTER OF DEEDS
AMOUNT
FY 2009 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 727,7 /9 00 $
40,382.00
193,369.00
$ 961,530.00 $
727,779.00 $
40,382.00
198,170.76
966,331.76 $
721,779.00 5
40,382.00
198,170.76
966.331.76 $
1.19% Turnover
11.69% Fay. Professional Services $20,000 reflective of a
software program for Vital Records that has not been
completed by an outside vendcr and Court Transcripts
$15,000 due to lower than anticipated activity.
$ 4.281,880.00 $ 4,446,147.12 $ 4,371,147.12 $
lniernal Support Expenditures
Transfers
635,214.00 797,756.64 797,756 64 0.00%
0,00%
75,000.00 1.69%
Elections
Personnel Expenditures $ 659,594.00 $
Operating Expenditures 770,800.00
Internal Support Expenditures 171,270 00
Transfers
659,594.00 $ 659,594.00 $
772,725.00 772,726.00
176,326.00 176,326.00
$ 1,601,664.00 $ 1,606,645.00 $ 1,608,645.00 $ 0.00%
6/23/2009
Register of Deeds (and Micrographics)
Personnel Expenditures $ 2,849,327.00 $
Operating Expenditures 1,361.611.00
2,834,113.70 $ 2,834,113.70 5
1,361,611.00 836,611.00 525,000.00
4,608,471.26 $ 525,000.00 10.23%
937,746.56 0.00%
0.00%
0.00%
0.00%
0.00%
0.00% 164,808.47 $ 164,808.47 $ $ 159,035.00 $
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
CLERK/REGISTER OF DEEDS
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2009 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
0.00%
38.56% Fay. Professional Services $825,000 due to decrease
in the number of mortgage and title documents
processed by outside vendor, reflective of slowdown
in the housing industry. Note related revenue
unfavorability.*
Internal Support Expenditures 930,963.00
Transfers
$ 5,141,901.00 $
937,748.56
5,133471.26 $
Jury Commission
Personnel Expenditures
Operating Expenditures
intema4Support Expenditures
19 006 00 $
6,161.00
133,868.00
19,006.00 $
6,161.00
139,641.47
19,006.00 $
6,161.00
139,641.47
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 7,604,964.00 $
2,476,362.00
2,064,684,00
$ 12,146,010.00 $
7,689,549.70 5 7,549,549.70 $ 40,000.00
2,480,212.48 1,920,212.48 560,000.00
2,249,641.43 2,249,641.43
12,319,403,61 5 11,719,403.61 $ 600,000.00
0.53%
22.58%
0.00%
0.00%
4.87%
* Note revenue offset.
6!23/2009
2,928,098.00 $ 2,891,098.00 $ 37,000.00
$ 3.6/2,745.00 $ 4,112,608.41 $ 4,075,608.41 $
$ 3,872,745.00 $ 4.112,608.41 $ 4,075,608.41 $
37,000 00 0.90%
37,000.00 0.90%
Division Total
Department Total
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
COUNTY TREASURER
ADOPTED
MIDGET
AMENDED
!BUDGET
FY 2009
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures
Operating Expenditures
$ 2.9211,088.00 $
254,578.00
1.26% - Fay. variance is clue to the comity wide hiring freeze in effect for
FY 2009. One FIF position is being filled with a PTNE
empkoyee, creating cost savings of $17,000.
258,4E6.50 258,466.50 0.00%
690,900 0.00% - Internal Support Expenditure: 926,043.91 926,043.91
6/23/2009
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
BOARD OF COMMISSIONERS
ADOPTED AMENDED
BUDGET BUDGET
AMOUNT
FY 2009 FAVORABLE
FORECAST (UNFAVORABLE )PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures
Operatng Expenditures
Internal Support Expenditures
$ 2,342,282.00
429,231.00
270,44:200 280,999.32
$ 2,342,282.00 $
349,231.00 80,000.00
280,999.32
0.00% -
18.64% - Fay. Professional Services $50,000 due to vacancy in the Lobbyist contract.
Also Fay. Travel & Conference $16,000, Workshops & Meetings $10,000
and Legislative Expense $5,000 due to Commissioners making a concerted
effort to reduce expenthtures in these areas.
0.00% -
$ 2,343,332.00
429,231.00
$ 3.052,0f5.00 $ 3,052,512.32 $ 2,072,512.32 $ 80,000.00 2.62%
80,000.00
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 2,343,382.00
429,231 00
279,442 00
$2,342,282.00
429,231.00
280,999.32
$ 2,342,282 00 $
349,231.00
280,999.32
0.00%
18.64%
0.00%
2.62% $ 3,052,055.00 $3,052,512.32 $ 2,972,512.32 $ 80,000.00
6i25/2009
Library Board
Personne! Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
•8,000.00 7.66%
0.00%
0.00%
3,000.00
Turnover
Fay due to the Library Boards deds4:in to transfer funds of
$2,000 from the aw Library In Library Admit listralori for the one
time set up feo for a TI line which will rxavide internet access to
members of the public.
$ 1,C11,16E.00 $ 1,015,992.94 5 937,902.94 $
682,804.00 662,604.00 682,804.00
868,69.1 00 871,673.58 871,671E8
5,000.00 5,000.00 2,000.00
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
LIBRARY BOARD
ADOPTED
IriGET
AMOUNT
AMENDED FY 2009 FAVORABLE
BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 2,575_470.62 $ 2,494,470 52 $
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
2.567 ,06600
$ 1,011,169.00
662,804.00
868_60.00
5,000.00
------------
$ 2,567,666.00
$ 1,015,992.94
682,804.00
871,673.58
5,000.00
$ 2,575,470.52
$ 937,992.04
682,804.00
871,673.58
2,000.00
81,000.90 3.15%
$ 78,000.00
3,000.00
7.68%
0.00%
0.00%
$ 2,494,470 52 $ 81,000.00 3.15%
6/2:17009
Operating Expenditures 491.651.00 681,672.40
Internal Support Expenditures 1,125,546.00 1.427,802.94 1,445,556.94
0.00%
0.00%
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
WATER RESOURCES COMMISSIONER
AMOUNT
ADOPTED AMENDED FY 2009 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
Water Resource Commissioner
Personnel Expenitures $ 3,752,747.00 $ 4,437,624,04 $ 4,437,624.04 $ 0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
663,918.40 17,754.00 2.60% Unfav - Recording Fees ($4,000) the result of recording liens a; the Register of
Deeds office on properties that have not paid for their soil erosion permit LInfav -
Periodica's Books Publ Sub ($1,265) used to purchase periodicals and
Communications ($300) tor video conferencing currently no established budget
line for these items. Unfav - Personal Mileage ($2,108) due to underestimated
budget to reimburse employees for mileage to inspect job sites and attend
outside meetings. Fay - Contracted Services $20,000, Laundry & Cleaning
$2,500 and Travel & Conference $2,927 is the Departments effort to balance the
Budget. The Departments Controllable Operating favorable amount will be offset
by the unfavorable amount in the Non-Controflable operating section.
(17,754.00) -1.24% Unfav - Convenience Copier ($17,754) the result of replacing a black arid white
copier with a color copier.
Transfers 56,1155.00 63,665.00 83,665.00 0.00%
Total $ 5,426,109.00 $ 6,610,764.38 $ 6,610,764.38 $
Department Total $ 5,426,109.00 $ 6,610,764.38 $ 6,610,764.38 $
6123/2009
AMOUNT
FAVORABLE
/UNFAVORABLE) PERCENT EXPLANATION OF SIONIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
Internal Support Expenditure*
5 2,010,367.00 S 2,010,367.00
224,173.00 224,173.00
562,31C.00 588,568.57
$ 2,010,387.00
224,173.00
588,586.57 0.00%
ADOPTED
'BUDGET
AMENDED
BUDGET
ry 20139
FOR1ECAST
$ 2,816,850.00 $ 2,823,128,57 $ 2,823,128.57 $ 0.00%
770,797.00 S
261,380.00
458,57'4.00
774,438.00
261,498.99
460,066.76
$ 774,438.00
261,498 99
460,063.78
0.00%
-
0.00% -
1,490,751..0C $ 1,496,006.17 1,496,005.77 $ 0.00%
$ 6,047,399 00
570,483.00
1,456,078.00
5 6,073,960_00
$ 6,065,476_73 $
678,933.99
1,467,31191
0
$ 8,111,719.63 $
2,055,674.60 $
58,122.00
234,799.66
5,99476.73 $
578,930.99
1,467,311.91
0
6,041,719.53
70,000.00
70.00000
5 2,116,691.00 $ 2,125,574.60 $
57,273 00 58,122.00
233,159 00 234,799.68
70,000,00 :3.29% - 'Turnover Position 43200 and #7748
0.00%
0.00% -
1,149,544,00 8 1,155,097.13 5
27,657.00 35,137.00
182,035.00 183,854.90
$ 1,359,236.00 $ 1,374,089.03 $
1,155,097.13
35 137.00
163,854.90
1,3 /4,069.03 $
0.00% -
0.00% -
0.00% -
0.00%
1.15%
0.00%
0_00%
5 2,407,123,00 5 2,418,498.26 $ 2,348,496.26 8 70,000.00 2.89%
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EVENDITURES
COUNTY EXECUTIVE
Emergency Response & Preparedness
Controllable Per
Controllable Operating
Internal Support Expenditure%
Transfers
Auditing
ContraIlatile Personnel ,.
Controllable Operating
Internal Support ixpenditures
Corporation Counsel
Controllable Personnel
Controllable Operating
Internal Support Expenditures
Depertment Total
Controllable Personnel
Controllable Operating
internal Support Expenditures
Trarsfers Out
6/73,1200U.
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
0.00%
0.00%
0.57%
$ 21,414,985.00 $ 21,925,242.22 5 21,378,942.22 $ 546,300.00 2.49%
6/23/2009
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
MANAGEMENT AND BUDGET
AMOUNT
ADOPTED AMENDED FY 2009 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 376,194.00 $ 376,194.00 $ 292,124.00 9 84.070D0 22.35% -Reflects MR*09089 efforts to reduce department budget through
8.780.00 8,780.00 7.550.00 1.230.00 14.01% deletion of a position and reduction in Travel and Conference and
Personal Mileage line items.
47,165.00 17,165.00 17,165.00 0.00%
$ 402,139.00 5 402,139.00 $ 316,839.00 $ 65,300.00 21.21%
Purchasing
Personnel Expenditures $ 1,097,979 00 $ 1,097,767.00 $ 1,097,737.00 0.00%
Operating Expenditures 36,081.00 35,081.00 35,081.00 0,00%
Internal Support Expenditures
Transfers
187,913.00 186,476.28 188,476.28 0.00%
Equalization
Personnel Expenditures
$ 1,320,973.00 $ 1,321,344.28 $ 1,32 1,344.28 $ 0.00%
5 7,920.121.00 $ 7,902.638.14 5 7,501,838.14 5 401,000.00 5.07% -Reflects MR*09089 efforts to reduce department budget through
deletion of positions, $128.100. Additional Fay. Variance clue to county
wide hiring freeze.
237,702 72
1,530,874.01
Operating Expenditures 237,591.00
Internal Support Expenditures 1,287,345.00
Transfers
237,702.72 0.00%
1,530,874.01 0.00%
0.00%
$9,445,057.00 $9,671,214.87 $ 9,270,214.87 $401,000.00 4.15%
Fiscal Services
Personnel Expenditures $ 7,721,751.00 $ 7,735,504.70 $ 7,675,504.70 $ 60,000.00 0.78% -Reflects MR*09089 efforts to reduce department budget through
deletion of position, $34,000. Additional Fav. Variance due to county
wide hiring freeze.
Operating Expenditures 230.324,00 230,324.00 230.324,00
Internal Support Expenditures 2,294,741.00 2,564,715.3 2,584,715.37
$ 10,246,816.00 $ 10,530,544.07 $ 10,470,544.07 $ 60,000.00
Department Total
Personnel Expenditures $ 17,116,045.00 5 17,112,123.84 $ 16,567,053.84 $ 545,070.00 3.19%
Operating Expenditures 511,776.00 511,887.72 510,657.72 1,230.00 0.24%
Irternel Support Expenditures 3,787,164.00 4,301,230.66 4,301,230.66 - 0.00%
Transfers - - - - 0.00%
Administrative
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
0.00%
1.99% Fay. due to decrease in hospitalization costs..
0:00%
0.49%
0.04%
1.01.5%
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
CENTRAL SERVICES
AMOUNT
ADOPTED AMENDED FY 2009 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
$ 204,142.00 $ 204,142.00 $ 204,142.00 0.00%
2,616.00 2,616.00 2,6'6.00 0.00%
14 ,?'L00 14.348.31 14,346,31 0.00%
-
EXPLANATION OF SIOTORCANT VARIANCES
$ 220,993 00 $ 221,106 31 $ 221,106,31 $
Support Services
Personnel Expenditures $ 1,134,9$0.00 5. 1,134,960.00 $ 1,112,350.00 $ 22,600.043
Operating Expenditures 53.826.0C 54.210.00 54,210.GD
Internal Support Expenditures 960,1Cr2.00 1,005,329.48 1,005,329,48
Transfers
$ 2,148,880.00 5 2,194,489.48 $ 2,171,8a9.48 5 22,940.00
Department Total
Personnel Expendttures
Operating Expenditures
Internal Support Expenditures
Transiers
$ 1,339.092-00 $ 1,339,092.00 $ 1,316,492.04 $
56,444.00 56,826.09 56,826.00
974,337.00 1,019,677.79 1,019,677.79
22,600.00 1.69%
000%
0.00%
0.00%
$ 2,369,873.00 $ 2,415,595.79 $ 2.392.99539 $ 22,600.00
=.. • -
0.94%
6123/2009
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
facilities Engineering
Personnel Expendlures
Operating Expenditures
Internal Support Expenditures
COUNTY Of OAKLAND
FY 2009 SECOND QUARTER REPORT
EXi EN DITURES
FACILITIES MANAGEMENT
ADOPTED AMENDED
BUDGET BUDGET
AMOUNT
FY 2009 FAVORABLE
FORECAST {UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
ON.
$ 395,310.00 5 395,310.00
4,596.00 4,596.00
38,013.00 38,013.00
$ 437,919.00 5 437,919.00 $
234,610.00 160,700.00 40.65% - Vacant Director - Facilities Management position for uonths and filling of
Property Management Specialist FIE position by PTNE
4,596.00 0.00%
38,013.00 0.00%
277,719.00 5 160,700.00 36.70%
876,854.00 $
116,888.00
70,705 00
5 '912,754.00 $ 912,754.00 $
116,888.00 116,888_00
70,705.00 70,705.00
$ 1,100,347.00 $ 1,100,347.00
36,900.00 3.93% - Staff time charged to the 2009 Housing Demolition Project and fay Overtime due to
reduced project activity
0.00%
0.00%
3 1,064,447.00 $ 35,900.00 326%
Department Total
Personnel Expenditures
Cperating Expenditures
Internal Support Expenditures
51,308,064.00
121.484-00
108,718.00
$ 1,308,064.00
121,484.00
108,718.00
$ 1,111,464 00 $
121,484 00
108,718.00
15.03%
0:00%
0.00%
196,600.00
$ 1,538,266.00 $ 1,538,268.00 $ 1,341,06.00 $ 196,600.00 1278%
6123/2009
.....
$ 1,026,144.00 $ 1,282,513.20 $1,267,263.20 $ 15,250.00 1.19%
$ 2,119R30.00 $ 2,184,822,72 $2,184,822.72 $ 0.00%
Savings are projected in Equipment flitafreeeianoe 51,.&OP, Freght & Express $130,
based on historical usage end Computer Supplies $2,000 and Expendable
Equipment $2,000 due to cutbaeks in purchases. Plans for Travel and Conference
will be 'Lower dee to decline in PeopleSoft training reedline in estimated favorebility of
$6.000. as well as Personel Mileage 51,000; offset by prior years expense for Intern
Program invoice of ($1,08S) charged to FY 2009 budget txRcause invoice wss riot
processed until after closing for FY 2008 Due to the hiring freeze, expenses related
to hiring, advertising., testing and processing new employees are projected to be
substantially favorable by 589,040. Due to outdated equipment and the necessity to
maintain validated exams. HR is in the process of preparing RFP's to perchase
validated e earns ror ttie 2417 dep& wha do not fall order the hiring freeze and more
frequently utilize the ejarn process (..e.., Deputies. Dispatch, Youth Specialist, Office
Assistants, etc.) These verelors wold also score the exams and HR would not need
to replace their outdated equip.rnere
HR is anticipaileg the favorability from the hiring freeee will continue ard can be used
to offset the cost of Purcriesele the new eXarna Will report an update on this roller
wah 3rd Quarter Forecast
.204,996,00 205,145.00 166,745.00 5 38,400.00 18.72%
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
HUMAN RESOURCES
AMOUNT
ADOPTIED AMENDED FY 2009 FAVORABLE
BUOGET BUDGET FORECAST fUNFAVORABLE)PERCENT EXPLANATION OF SiGNiFICANI VARIANCES
.1 • 0.n •••n n••n•11a,••••...n ...................... ...............
Administration
Personnel Expenditures $ 668,241.00 $ 668,241.00 $ 668241.00 0.00%
Operating Expenditures
Internal Support Expenditures 56397..00
Workforce Management
Personnel Expenditures
Operating Expenditures
62.766,20 65,916.20 $ (3:150.00) -5.02% Due to charges for use oilMotor Pool (6.,150) and Telephone Cornaminicatrons
($3,000). Additional lines Er traneferred employee and *not line, as well as cell
phones for Deptuy Director and Superv'sor to haretie increased activity with 312
Arbitraticn. However, budget vets riot adjusted to reflect this increase ln expense.
301,506.017 551.506.00 513;106.00 3 18,400.00 3.34% Fav. estimated Employee Med Exams ADA $2,000 duo to decline in current
employees submitting requests for ADA medical 'weenie; a reducticr in Fees - Per
Dlern $9,500 due to fewer Meetings, e reduction in memberships and periodicals
$1.300 (as reflected in historical usage), use of iravel and Conference $4,800,
Personal Mileage $300 and Workshop arei Meetings Sf..'DC.
6/231200e
••••••••••..
Internal Support Expenditures 539,295.00 608,861.68 590,861.68 $ 18,000.00
$ 4,370,348.00 $ 4,701,566.60 $4576,216.60 $ 125,350.00 2.67%
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
HUMAN RESOURCES
ADOPTED AMENDED FY 2009
BUDGET BUDGET FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
2.96% Info Tech Operations projected fay. $20,000 due to lower expense and Convenience
Copier protected to be $4,000 far.. due to lower usage , offset by unfav.Telephorie
Communications expense ($6,000I as current monnly charges continue to coincide
with historical usage being higher than budget. Print Shop expenses currently low,
but department is preparing to update pages for the Merit Rule document, which will
require significant funds and ultimately use most of the allocation for Print Shop.
Benefits Administration
Personnel Expenditures
$ 2,923,900.00 $ 2,9913,829.40 82,942,429.40 $ 56,400.00 1.88%
20.67% Favorable due to redistribution of salaries and fringes for positions transferred to
Workforce Management per reorg in FY 2008 (MR.. #08101), correction of account
code for Secretary II position 401689, which !ts now charged to HR- Adrnin I labor
Relations, and vacant PTNE Office Assisterit I position (410656j.
6.700.00 34.44% Due to decrease in spending for Equipment Maintenance $100, Travel and
Conference $3,200, Software Support Maintenance $400 and Expendable
Equipment Expense $2,000.
0.00%
$ 232,276.00 $ 232,275.00 $ 184,275.00 $ 48,000.00
Operating Expenditures 16,552.00 16,552.00 10,852.00 $
Internal Support Expenditures 171,397.00 171,397.00 171,397.00 $
$ 420,224.00 5 420,224.00 $ 366,524.00 $ 53,700.00 12.78%
Department Total
Personnel Expenditures
Operating Expenditures
internal Support Expenditures
$ 3,080,206.00
523.053.00
767,089.00
$ 3,085,338.72 $3,037,338.72 $ 48,000.00
773,203.00 710,703.00 62,500.W
843,024.88 828,174.88 14,350.00
1.56%
8.08%
1.76%
16;2312009
11,032.00 11,032.00
11,634,548.00
26,617,369.45
5,667,138.29
11,205,356.00
$ 24 ,810,946 .45
5,654,138.29
3,845,704.69 3,845,704.69
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
HEALTH AND HUMAN SERVICES
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2009 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures
Operating Expenditures
$ 209,874.00 $ 209,874.00 $ 209,874.00
11,701,313.00 11,413,642.00 10,984,450.00 429,192.00
0.00% -
3.7696 Anticipating Favorable Private Institutions (Michigan
Department of Human Services) for costs incurred for the care
of neglected and abused wards of the court. Costs are based
on caseload, difficulty of care, and treatment of services
- (counseling, drug screening etc.) ordered by tne Court.
Internal Support Expenditures
Transfers Out
Health
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
11,032.00
$ 11,922,219.00 $
$ 26501,828.00 $
4,641,776.00
3,386,166.00
0.00% -
429,192.00 3.69%
$ 1,806,421.00 6.79% - Favorable turnover due to retirements in FY2008 and the
underfilling of positions.
13,000.00 0,23% - Interpreter Fees is favorable, $13,000, due to use of nextel
phones to call phone interpreter services versus using an on-
site interpreter. Favurability is expected in Satellite Centers
accounts but is committed for substance abuse services and
will be carried forward and therefore is not available for other
purposes.
0.00% -
Transfers Out
$ 34,528,770.00 536,130,212.43 $ 34,310,791.43 $ 1,819,421.00 5.04%
6129/2009
$ 12,820,771.00 $ 12,991,879.28 $ 12,991,879.28
$ 3,637,555.00 3,816,067.80 3,770,567.80
2,453,447.00 2,488,320.63 2,488,320.63
0.00
$ 39,532,473.00 $ 39,819,122.73 $ 38,012,701.73 $ 1,806,421.00
19,980,644.00 20,896,848.09 20,409,156.09 487,692.00
5,849,645.00 6,345,057.32 6,345,057 32
Children's Village
Personnel Expenditures 0.00% -
Operating Expenditures
Internal Support Expenditures
Transfers Out
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfers Out
45,500.00 1.19% - Favorable Transportation Service $11,500. Favorable
Laundry and Cleaning $20,000, due to pilot program between
Sheriffs Department and the Department of Health and
Human Services Also, anticipating Fay. Bedding and Linen
$14,000, due to previous years linen purchases.
0.00% -
4.54%
2.33%
0.00%
100.00%
$ 18,911,773.00 $ 19,296,267.71 $ 19,250,767.71 $ 45,500.00 0.24%
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
HEALTH AND HUMAN SERVICES
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2009 FAVORABLE
FORECAST fUNFAVORABLEI PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 65,362,762.00 $ 67,061,028.14 $ 64,766,915.14 $ 2,294,113.00 3.42%
6:29:20C9
ADOPTED
BUDGET
AMENDED
BUDGET
$ 198,868.00 5 281,326.00 $ 281,326.00 $ 0.00%
$ 2,016,239.00 $ 2,014,614.75 $ 1,989,614.75 $ 25,000.00 1.24%
$ 3,438,647.00 $ 3,537,128.11 $ 3,537,128.11 $
827,198.00 887,914.00 887,914.00
556,464.00 606,041.55 606,041 55
0.00% -
0.00% -
0.00% --
0.00%
$ 4,822,309.00 $ 5,031,083.66 $ 5,031,0133.86 $
MSU Ext. - Oakland County
Personnel Expenditures
Operating Expenditures
$ 763,160.00
88,897.00
$ 766,697.89 $
89,009.86
766,697.89 $
86,009.86 3,000.00
Internal Support Expenditures 358,315.00 361,284.85 361,284.85 0.00% -
S 4,747,024.00 5 4,624,892.49 $ 4,6
* See related revenue offset.
9 $ 0,00%
6126/2009
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
PUBLIC SERVICES
AMOUNT
FY 2009 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Public Services - Admin.
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 187,479.00 $ 187,4 f9.00
4,800.00 87,258.00
6,589.00 6,589.00
$ 187,479.00 $
87,258.00
6,589.00
ono% -
(Lai% - Amended budget includes a budget transition of $82,458.
0.00% -
25,000.00
Veterans' Services
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
Community Corrections
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 1,534,499.00 $ 1,528,741.28
227,090.00 227,090.00
254,650.00 258,783.47
1,503,741.28 $
227,090.00
258,783.47
1.64% - Fay. due to the hiring freeze policy in effect for FY 2009.
000%
-
0.00%
0.00%
0.00% -
3.37% - Fay. Professional Services due to the use of MSU Extension
educators from other counties that don't charge fees for
teaching Master Gardener classes. Note related revenue
$ 1,210,372.00 $ 1,216,992.60 $ 1,213,992.60 $ 3,000.00 0.25%
Medical Examiner
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 3,426,491.00 $ 3,278,636.52 $ 3,278,636.52 $
521,788.00 522,161.33 522,161.33
798,745.00 824,094.64 824 1.64
0.00% -
oma% -
0.00% -
• See related revenue offset 6/26/20105
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
PUBLIC SERVICES
AMOUNT
ADOPTED AMENDED FY 2009 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Animal Control
Personnel Expenditures $ 1,784,110.00 $ 1,784,110.00 $ 1,769,110.00 $ 15,000.00 0.84% - Fay. Overtime $10,000, Holiday Overtime $3,000 due to
implementation of staggered work schedules in the Kennel to
eliminate overtime on Saturdays and On Call $2,000 as a result
of eliminating the afternoon shift for Road Patrol and
implementation of the 4140 workweek.
Operating Expenditures
Internal Support Expenditures
Transfers
154,967.00
592,293.00
155,840.69
696,638.61
1 55,840.69
696,638.61
0.00% -
0.00% -
•$ 2,531,370 00 $ 2,636,589.30 $ 2,621,589.30 $ 15,000.00 0.57%
Circuit Court Probation
Personnel Expenditures $ - $ - $ - $ - 0.00%
Operating Expenditures 40,798.00 40,798.00 40,798.00 - 0.00%
Internal Support Expenditures 807,581.00 809,212.38 809,212.38 - 0.00%
$ 848,379.00 $ 850,010.38 $ 850,010.38 $ 0.00%
Department Total
Personnel Expenditures $11,134,386.00 $ 11,082,792.80 $ 11.042392.60 $ 40,000.00 0.36%
Operating Expenditures 1,865,538.00 2,010,071)38 2,007,071.88 3,000.00 0.15%
Internal Support Expenditures 3,374,637.00 3,562,644.50 3562:644.50 0.00%
Transfers -
$16,374,561,00 $ 16.655,509.18 $ 16,812,509.18 $ 43,000.00 0.26%
0.00%
0.00%
0.00%
0.00%
Planning and Economic Development Services
Personnel ExpendUries $ 3,893,545.00 $ 3,899,373.30 $ 3,742,173.30 $
Operating Expenditures 1.036,275.00 1,444,749.27 L328,949.27
157,200.00
115,800.00
COUNTY OF OAKLAND
FY nos SECOND QUARTER REPORT
EXPENDITURES
ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS
AMOUNT
ADOPTED AftilENDED FY 2009 FAVORABLE
BUDGET BUDGET FORECAST iUNFAVORABLE) IPERCENT
Administration
Personnel Expenditures $ 1,114,290.00 $ 1.109,E53.00 $ 1,109,553.00 $
Operating Expenditures 132,059.00 311,542.00 311,542 01:1
Internal Support Expenditures 69,525.00 71,922 e7 71 922.67
$ 1,315,874.00 5 ,493,017 87 5 1,4'23,017.87 $
EXPLANATION OF SIGNIFICANT VARIANCES
4.0% - Turnover
8.02% • Fav. Operating, primarily Professional Services, as well as
Advertising, Printing, Travel & Conference, Legal Services, and
Workshops & Meetings for update of the Solid Waste
Management Plan, delayed pending reformatting of plan
guidelines by the State $134,600. Also 1e v. Pzinting $25,000 due
to utilization of Print Stop rather than outside printirg.
Fa vorability is partlally offset by Software Support Maintenance
($25,000) for on-line customer tracing and economic modeling
software and by Dry Goods & Clothing ($19,000) for trade
mission promotional items and business diversification seminar
notebooks. A budget amendment is requested lc transfer
$300,000 from the Planning & Economic Development Services
Division Budget to the Marketing & Communications Program of
The Economic Development Administration Division to segregate
marketing and planning activities.
Internal Support Expenditures 981,603.00 " ,004,003.C6 1,004,003.66 0.00%
$ 5,911,423.00 $ 6,348,126.23 $ 6.075,126.23 $ 273,000.00 4.30%
Community ad Nome improvement
Personnel Expenditures S - $ - $
Operating Expenditures
Transfers
- $ - $
Workforce Davalopment
Personnel Fxpenditures
Operating Expenditures
Internal Support Expenditures
$ 25,6,20,00 5 .25,620.00 5 27,171.00 $ {1,551.00) -6.05% - Unallowable Worldcroe Development federal and state grant
costs paid by the County marginally exceeded 'midget estimate.
A Led•ji t amendment is requested.
$ 25,620.00 $ 25,620.00 $ 27,1 (1.5t 1.00) -6.05% Department Total 623/200'9
3.09%
6.59%
0.00%
0.00%
3.4.5%
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
EXPENDITURES
ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS
ADOPTED AMENDED
BUDGET BUDGET
AMOUNT
FY 2009 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 4,878,897.30
1,640,491.27
1,075,926.53
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
-transfers
$ 5,033,455.00 $ 5.034,546.30
1,168,334.00 1,766,291.27
1,051,128.00 1,075,926.53
$ 7,252,917.00 $ 7,866,764.10
$ 155,649.00
115,800.00
$ 7.595,315.10 $ 271,449.00
6/23/2009
-2.65% (4.100 00)
16,000.00 94 6 1,Ttyr,
11 ,900.00
0.00%
0.00%
0.00%
0.00%
0.00%
6.09%
COUNTY BUILDINGS $ 3,293.605..00 $ 2,921,309.81 $ 2,921,309.81 0.00%
1100 00 )
0.00%
0.00%
00(1%
-2.'512%
0.00%
0.00%
-0.09;T;
55,000.00
1,70000
70,700.10
24,000,00
579,000.M
30.00060
$ 760400.00 (100 .00)
STATE AND FEDERAL -COUNTY ASSOCIATIONS
Area Wide Water ObS111y
Assoc of Metro Sewage Agencies
Micriisan Assoc. of Counties
National ASSDC, of Counties
S.E.M Ci a
Traffic Improvement Association
Total
55,000.00 5500000
1,7(10.00 1,100.00
76,700 0(1 70,7(10 00
24,000.00 24,700.00
579,000.00 579,000.00
30,000.00 30,000.00
760,400.00 $ 761,100.00 $
0,00%
0.00% .1 kits budget will be reallocated to depl late' this year.
0.00% - The bidet of 7 ni s tile 0ffset to riepartmerta Oudget task
oornmitrnerits. No actual funds mfill be expended from this
acocont
84.-92%
U.01..1%
0.00%
00%
0.00%
0.00%
0 Or•
100 /0...
1.00"
0.00%
52,100.00
150,000.00
4,000 00
COUNTY OP OAKLAND
PY 2009 SECOND OUARTER REPORT
NON•DEPARTMENTAL EXPENDITURES
ADOPTED
BUDGET
A1AENDED
BUDGET
FY .2009
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION
30,0/10 CO
1,340,002.00
1,500,000.00
30,t)VO.00
9,620,616.00
$ 12,692,516.00
'154,918.00 $
16,900.00
NON-IDEPARTAR MEW APPROPRIATIONS
COUNTY OPERATIONS
Insurance Fund
Insurance Surety Bonds
Misceiteneou 5
Logos and Trademarks
Road Ccmmission \Current Drain Assessment
Road Ccrrouissiorari Party Agreement
r) rovisions
rranster to CMI-1A
Total
15U1.00 5
16,900.00
30,000.00 30,000,00
1,340,082.00 1,340,082.00
1.687,67E00 1,6E7,625.00
3o.onc.co ...o-oo..oc
5,620,616.00 9,620,516.00
$ 12,880.141.00 .$ 12,858,241.00 $
159,018.00 $
9U0.00
SUNDRY EXPENSE $ 300,000.00 $ 300,000.00 $ 10000.00
RESERVED FOR TRANSFERS
Expendflures
Administrative Leave
124.4e1 (ransition
BaSic Readjustment
ClassWoation and Rate Cbange
Contingency
Fmergency Fakaries
Grant Match
!nib Tech Development
Legislative Expet-15e
Misc. Capital Outlay
Overtime Appropriation
Workshops and Meetings
l-rince Benefit Adjustment
Summer Employees Salary Appropriation
$ (400,000.00) 5 (27,497.00) (27,497.00)
7,045,834.00 7,045,534.00 7,045,634.00
52,1E2.00 62,162 00 62.00
(90,004.00 176,642.00 76,642.00
149,52C.00 125,252.00 125,252.00
1,320.709.00 622,414.52 622,414.52
6,748.257.00 541,967.00 541,967.00
6,012,936.00 3,676,925.03 3,676,928.03
180,500 00 180,500.00 18(1.500.00
75,000.0C 75,000.00 75,000.00
53,000 00 53,000.00 '01,000.00
4.000.00 4,000.00 -
lb 00 0.01 -
353,738.00 332,288.11 '288.00
his budge: will be reallocat'erl dept later 110s year.
A budget amendment is rencnitne nd ed to recognize pending
grants
This budget will be reallocated to dept later this year.
90.xls 6;252,90.9
AMOUNT
FAVORABLE
(UNFAVORABLE
15,000.00
5,200.00 5,200.00
$ 12,878,490.55 $ 12.667,190.55 $ 211,300.00
ADOPTED
BUDGET
5,200.00
$ 21,821,560.00
AMENDED
BUDGET
FY 2009
FORECAST
15.000.00
645,764.00 645,764.00
11.505.466 00 11,485,46600
1,479,070.00 1,479.070.00
200,000.00 200,000.00
413,997.00 413,997.00
165,809.00 515,809.00
1,389,117 00 1,389.117.00
0.00 70,636.00
0.00 0.00
15.799,223.00 $ '16,199,659.00 $ 16.199,859.00 $
645,764.00
11.485,466.00
1,479,070.00
200,000.00
413,997.00
515,809.00
1,389,117.00
70.636.00
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
PERCENT
0.00%
1.00
1.64%
EXPLANATION
TOTAL NON-DEPT. APPROPRIATIONS $ 54,667,304.00 $ 45,940,200.36 5 45,717,700.36 5 222,500.00 0.48%
c-7.1
Oil vic 6/25/2009
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
NON-DEPARTMENTAL EXPENDITURES
Transistion Expense
Transit Commuter Benefit Program
Total
Transfers to Other Funds
Jail Population Management Fund
Capital & Cooperative initiatives Revolving Fund
Debt Service - West Wing Refunding
Project Work Order Fund
Fire Records Management
Radio Communications
CLEMIS
Trifwmation Technology
Facilities Mainenance & Operations
TOTAL EXPENOTURES 5103,768,746.00 $ 96,960,889.08 $
TRANSFER TO GENERAL PURPOSE FUNDS
Public Health Fund
Child Care Fund
Social Welfare Fund Foster Care
5 25,678,851.00 5 27,303,271.81
23,421,591.00 23,716,336.91
1,000 00 1,000.00
$49,101,442.00 $51,020,608.72
27,303,27t.81
23,716,336.91
1,000.00
$51..020,608.72 5
96,738,309.08
0.00%
0.00%
0.00%
222,500.00 0 23%
70.160.00
$ 257,528.00
17,254.00
Pf 2009 BUDGET AMENDMENTS
FY 2009 BUDGET AS ADOPTED - GENERAL FUND/GENERAL PURPOSE FUNDS $ 426,410.209.00
BUDGET AMENDMENTS
M.R. #08181 - 1010212008 20,395.00
Criminal Justice Coordinating Counsel - Expansion of Tethering Program Transfer from Jail
Population Management fund
M.R. #08191 -10/0212008 700.0D
County Clerk - Elections Division Board of Canvassers Agreement City of Farmington hills
M.R. #08192 • 10/0212008 5 6.736.00
information Technology - Interlocal Agreement with Lyon Township FRMS- Planned Use of
Fund Balance
KR. #08226 -10/23/2008 59,013.00
Sheriffs Office - Automobile Theft Prevention Authority (ATPA) Grant Acceptance
M.R. #08227 - 10123/2008 $ 102,286.00
Sheriffs Office - Jail Alliance wit') Support for Inmates with Co-Occurring Disorders Program
M.R. #08233 - 11/0612008 63,928.00
Management and Budget Transfer of Inmate Account Data from the Reimbursement Unit's
Legacy System and the Jail Management Information System RDK, Inc.-Planned Use of FB
M.R. #U8228 - 11/0612008 S 400.
County Clerk - Electiors Division Board of Canvassers Agreement Independence Township'
M.R. #08246 - 11)0612008 (11,588.00)
Sheriffs Office - State Criminal Alien Assistance Program (SCAAP)
M.R. #08252 - 11/20/2008 S 6.500.00
Sheriffs otricv - Addition of K-9 and Milk Bone Donation Acceptance
M.R. #08235 - 11/612008 21,970.00
Parks and Recreation Department - Reorganization
#08206 - 12/11/2008
M&B FY 2008 Year End Report
Encumbrances $ 15'7.82732
Carry Forwards $ 2.833.867.39
Appropriation of Designation - Sheriffs Call Taking Equip. $ 350,000.00 $ 3,341,0.S
825.00
148,267.00)
43,155.00
M.R, #08261 - 12/11/2008
County Clerk - Elections Division Board of Canvassers Agreement Bloomfield Township
KR #08268 - 1211112008
Health Division - ?ODE() Contract
M.R. #08273 - 1211112008
Circuit Court - SCA° Grant Acceptance
M.R. #08275 -1211112008
Sheriffs Office ProsecLting Attorney- NET Bryne Grant Acceotanoe
M.R. #08278 - 12/11/2008
52.2 District Court - SCAO Grant Acceptance (Drug Court)
TOTAL AMENDED BUDGET AS OF 12131/2008 (1ST QUARTER) $ 430,362,850.71
51
$ 250,000.00
$ 1,131,306.00
$ (100,000.00)
$ 60,000.00
$ (1,100.00)
$ 150.000.00
$ 29,000,00
$ 200,000.0G
5 858,314.00 $ 2,577.520.00
$ 433,670,804.71
FY 2009 BUDGET AMENDMENTS
M.R. #09013 • 2/512009 S 75,000.00
Sheriff - Contract with Wayne County for Warrant Enforcement Parole Absconders S 47,407.00
003.O0 M.R. #09015 - 215/2009
Shariff - Patrol Contra0 wilb Rod-iv.;ler Hills
TOTAL AMENDED BUDGET AS OF 2128/2009 $ 430,493,260.71
M.R. #09038 - 03105/2009 5 3.780.00
Health Divison - 2309 Petal Infant Mortality Data Abstraction Agreement
M.R. #09023 - 3/512009 $ 122,554.00
Sheriff - Patrol Contract with Lyon Two
M.R. #09026 - 03/0512009 2,500.00
Sheriffs Office - Use Of Donated Vehicle For Auto Theft Prevention Team
M.R. #09024 - 03105/2009 $ 220,000.00
Sheriffs Office - Contract Extension for Private Food Service Vendor thru 2012
M.R. #09066 • 03126/2009 $ 327,190.00
Sheriffs Office - Creation of the Results Breath Alcohol and Drug re$tifig Pilot Program
M,R, #09067 - 03/2612009 $ (101,000.00)
Public Services - Reorganization
M.R. #09043 - 03/2612009 25,000.00
Health Division - Intergovernmental Agreement witi Oakland So,nools for Infant Toddler
Assessments
M.R. #09xxx 412312009
M&B FY 2009 First Quarter Report
Appropriation of Designation - HR Legal Expense
Childrens Village/Child Care Fund Revenue Adjustment
Circuit Court - Revenue Adjustment for Mediation
Sheriff - Revenue Adj. Diverted Felon/Board & Care
Board of Commissioners - Rev Adj for Per Diem
Health and Human Services Admin - Adj Reim General
Ecdnomic Development
ion-Dept Revenue Adj. Interest, Gig Tax & St Court Es
Water Resource Commissioner - Adj Reim Genera!
TOTAL AMENDED BUDGET AS OF 313112009 Second Quarter
52
RE-VI-NtIFS
Charges for Services I1.5,5D8.31i0O $15,508,311.00 $20,450,400.00 $4,942,089 00
8,500.000.00 .3,54S,142.00 12,04e,142.00 Other Revenues 10,200,000.00
Total Revenues $25,708,311.00 $27,556,453.00 428,95000 00 $1,393,947.00 5.06%
8S,699.00 $
300,000.00
2,247,454.00 366,757.00
p10,003.120) 3,810,000.00
10.00 50.00 $1 450.704.00 $1.063.947 00
$223,590 565.62
$225,041,269.62
380.8:35 969.10
7C
133,r
10 id
6;2912009
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
ENTERPRISE FUND
TREASURERS OFFICE
ADOPTED AM ENDED FY Mos VARIANCE
BUDGET BUDGET Forecast FAVOUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
DELINQUENT TAX REVOLVING FUND 51600
31.87% Fev variancn dee to the increase in taxpayers inability lo pay their
property. taxes. Collectien foes and Interest on Deliquent taxes are
assesed in deliquent taxes, therefore as the taxpayer's inability to pay
increases .bIL1 dues the revenue generated within the DIRT
-29.45% Unfav. variance due to the economic downturn within the investment
M2rItels. The OTRF's investment income vittl decrease due to the
economies investment market cereteions. A budget amendment
epproved with the 1St Quarter forecast was incorrect. Tee Del tax re-
write project was already budgeted in the DTRF under Information
Tecenolgy De eelopernent, but was budgeted again with the 1st quarter
forecast A 2nd qtr amendment is. recommended to Teeerse
ince-erectly budgeted amounts. -This will reduce the unfaidaorable
variance trent 03,548,14'41n 03,181,285),
$ 69,699.00
300,000.00
2,614,211.00
3,500,000.00
OPERATING EXPENSES
Personnel Expenditures
Operating Expenditures
Internal Services
Transfer Out to Other Funds.
General Fund - Cotlection Fees
GF - Non-Departmental
GF - RCOC Tri-Party Agreement
Work Release Facility Debt Svc
Office Oldg Renovation Debt S
Into Tech Operetices
52-3 District Court Debt Service
Total Transfer Out to Other Funds
Total Operating Expenses
$ 89,699.00
.:305,000.00
2,614,211.M
3,500,000.00
I 1,6C0,000.01:1
2,250,000.00
1,656.b26.00
,e1.6,000 00
tI,415,275.130
22,04 ,401.00
$ 2:53-11i011 00
0.00%
0.00%
Fay Variance ts due to the Del-fax re-write peeect amendment in tel.
Quarter. A hudget amendment is recommended in the 2nd quarter
forecast to correct this error.
-3 86% Unfav, variance is due to more then cir licipated amounts collected in
collection fees tills line item directly correlated with the above revenue
and is transferred to the Treasuer's budget at year end
11,600,00D 00 11,600,000.00 - 0.00%
2,250,000.00 2,250,000.00 0.00%
1.856,526.00 1,856:526.00 - 0.00%
2,082,600.00 2.082,50000 0.00%
1,648,142.00 1,846,142.00 - 0.00%
1,415,275.00 1,41e,VVIO , 0.00%
24.552.543.00 24 ,862,54.00 (310,000.001 -1.26%
$ .27,556,453.00 $ 27,499,6.9600 $ (310,000.00) -1 12%
RFVFNUE OVER (UNDER)
EXPENDITURES
fetal Net Assets - Beginning
Total Net Assets - Ending
Lnding FY 2008 Designated Fund Balance
Designated - Debt Service
Designated - Projects.
Designated - Delinq 'itaxes Receivable
Designated - Collection Fees
Undesignatee - Fund Balance
:ffelal Net Assets - Ending
DTRF #51600 Quarterly Forecastels
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
ENTERPRISE FUNDS
SHERIFF'S DEPARTMENT
ADOPTED AMENDED FY 2009 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
JAiL INMATE COMMISSARY FUND
9159600)
OPERATING REVENUE $ 1,455,870.00 $ 1,455,870.00 $ 1,455,870.00 $- 0 00% - Operalierls were transferred to the General fund per MR ff00024.
OPERATING EXPENSE $ 1,455,870 00 5 1,455,670.00 $ 1,455,870.00 $ - 0.00% -
NET OPERATING INCOME (LOSS) $ - $$ - $ - -
NON-OPERATING REVENUE (EXPENSE) $ - $5 10,000.00 $ 10,000.00 0.00% -
TOTAL INCOME BEFORE
CONTRIBUTIONS AND TRANSFERS $ - $., 5 10,000.00 $ 10,000.00 0.00%
TRANSFER OUT $$ $ - $ - 0.00% - -
CAPITAL CONTRIBUTION 0.00%
TOTAL NET INCOME (LOSS) $0.00 50.00 $10,000.00 $110,000.00 0.00%
TOTAL NET ASSETS - BEGINNING $ 119,660.19
TOTAL NET ASSETS - ENOING St 2960.19
,111 6/26/2009
Totai Net Assets - Beginning
Total Net Assets - Ending
3.3,251,599.*5
$3.6139,099.66
Comm( OF OAKLAND
Fry 2009 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS
SHERFF'S OFFICE
ADOPTED AMENDED FY 2009 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
[SHFRIFF AVIATION 110000
OFERATING REVENUES.
$0.00 $0.00 $0.00 50.00 000%
Inside kevonue 5 1,7137, 112.00 $ 1_75.1 112.00 3 1,761,112.0C 5 - 0.00% -
Total Revenue 5 1,7E7,117..00 41 767,112.00 I) 767.112,,.00 $0.00 0.00%
OPERATING EXPENSES $1,329,512.00 51,329 (512.00 $1 129 612.00 5 - 0.00% -
NET INCOME (LOSS) BEFORE $4370000 U37,500.00 S437,500.00 50.00 0.00%
'/HANSFERS IN (OUT) $0.00 50.00 30.00 5 - 0.00%
NON-OPERATING RFVFNUE 50.00 50.00 0.0Q $ - 0.00%
OPERATING TRANSFERS IN 50.00 — $0.00 $000 5 - , 0.00% —
NET REVENUES OVER(UNDER)
FXPFNSES 5437,500.00 5437,500.00 5413/.500.00 $0.00 0.00% Funds necessLry to cover tepayinent of DTRIF Los.
Outside Revenue
'J. 64.26/2009
Outside
Total Revenue
OPERATING EXPENSES
TOTAL NET ASSETS.- BEGINNING
TOTAL NET ASSETS. ENDING
2,516 150.74
$3,423,542.74
COUNTY OF OAKLAND
FY 2000 SECOND QUARTER REPORT
INTERNAL SERVICE FUND
WATER RESOURCES COMMISSIONER
ADOPTED AMENDED Pr 200e VARIANCE
auDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
:12aAIN EQUIPMENT FUND (83900)
OPERATING REVENUES:
Inside 53,781,611.00 53,781,611 .00 $4,344,692.00 $3,281.00 14 00% Fey - Rebilled Charges $18g,01:10 a result of rebikl charges to the CAMS Project for
the CVT's data conversion cornoonerit. Unfav - Reimbursement leuricling Space Cost
(567,847) due to the Pump Maintenance Building rate adjustment for depreciation,
electric, gas and other operating cOSt. Unfav - Reimbursement Generel ($338,050) a
result of decreased spending on the GIS programs for the completion of the GIS
record conversion project, which will be offset by Salaries and Fringes. Fay - Vehicle
Rental $780,178 a result of the rate Increase to recover increasing operafing cost
and replacement recovery cost.
756,521.00 159,521.00 7:59,521.00 $0.00 0.00%
4,541,132 00 4.541,132.00 5,104,413.00 583,281,00 1240%
4,609,032.00 4,609,032.00 4,223,021.00 386,011.00 8.38% Fav SalatieS and Fringes $338,050 the result of decrease spending on the GIS
programs for the completion of the GIS record conversion project. No budget
amendment required as hours disbursed to other systems. Fav - Indirect Cost
$59,7/34 due to Indirect cost rate finalized after budget process. Unfav -
Maintenance Department Charges ($15,800 for billing charges to Orion Township,
West Bloomfield Township and infernai departments for SCADA equipment.
NET INCOME (LOSS) BEFORE (67,900.00) (87,900.00) 881,392.00 949,292 00 -1398.07%
NON-OPERATING REVENUEI(EXPENSE) 67,900.00 67,000.00 26,000.00 (41,P00 00) -61.71% Fav - Accrued Interest Adjustment $16,100 fur accrued booking adjustment for
investment income. Unfav - Income from Investment ($58,000) the result of account
not earning arty return due to the negative cash balance from the replacement of
vehicles.
TRANSFER IN 0.00 0.00 0.00 0.00 0.00%
TRANSILHS (OUT) O.400 0.00 0.00 0.00 0.00%
NFT REVENUES OVER(UNDER) 50-.00 PA) $907,392.00 $907,392.00
EXPENSES nn•nnn•nn=1.
Please note that in the Adopted Budget (line-Rem booki this is budgeted as "Planned Use of Fund Balance" in the revenue category.
6/23/2009
EXPLANATION OF SIGNIFICANT VANiANCES
COUNTY OF OAKLAND
FY 21199 SECOND QUARTER REPORT
INTERNAL SERVICE FUND
RISK MANAGEMENT
ADOPTED AMENDED FY 2099 VAJRIANCE
BUDGET BUDGET FORECAST FAV(LINFAV) PERCEN 1
------ —.---- — -,--- ----
Lli4131LIITY RANCE FUND 67700 1
OPERATING REVENUES
Outside Revenue - $ - S 284,537.00 $ na.soo.00 - Fay due to reimbursement of lavesu(ts
Inside Revenue r9,244.00 2,5r,244.00 2,536.468.CC $ (42,700.00) -1.66% - Uniav. rebilled property insoance t$33,7C0) due to lower premiums
than expected and sabilled charges tor medical exarns139,000) offset
by decrease in employees medical exams and irislirance expenses.
TotaI Opef-Aing Revenue S 25144.CC $ 2,579,244.00 '3 2,821,02S 00 S 241,800.00 9.37%
OPERATING EXPENSE S2,369.0€6.00 3 2,440,965.00 3 2,397,607.00 3 43,400.00 1.78% - Fav employees medical exams $9.,000 and insurance $33,700 cue
to lower costs than anticipated and periodicals
CLAIMS PAID 1S22 744.00 1,222,744_00 1,222,744.00 $
TOTAL OPFRATJNC1 f XPENSES i .", 5P1,809.00 3 3,663,71)9.00 5 3,,620 1.51. CC 1 45,400.00
OPERATING INCOMF (LOSS) (1.012,5f15.00) (1,084,48E00) (799,326.00) 2851.200.00
NON-OPERATING REVENUE (EXPENSE) 1,178,465.00 _ I 178 466.00 360 000 00 _ (813,500.00) -69.45% Urrfav. due to lower interest rates than anticiioatcd.
NET REVENUES OVEROUNDER)
EXPENSES
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
$ 165,901.00_ 5 914,031.00 On 320 $ (533,300.031
18, i13,b81,0t.
17,674..355.08
6/23(2009
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
INTERNAL SERVICE FUND
MANAGEMENT AND BUDGET
ADOPTED AMENDED FY 2009 VARIANCE
BUDGET BUDGET FORECAST FAV,(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
'OFFICE EQUIPMENT FUND 96400
OPERATING REVENUE - INSIDE $ 653,214.00 5 653,214.00 $ 656,20000 $ 13,000 00 1.00% Fav. due to purchase of new MDC units for Patrol cars. Monthly
rental 10 be charged to [he Sheriff
OPERATING EXPENSE 691 778.00 732,014.00 802,782.00 $ (70,800.001 -9.67% Unfav. indi(ect costs (5153,000i due to actual charges
developed after hodget finalization, maintenance
contracts ($17,800) due to maintenance agreement on In
Car Cameras and deprec.:iation ($13,0001due to purchase of
FilDC units. Fay. equipment maintenance $33,000 due
In fewer repairs than anficipateri and equipment
replacements $B0,000 due to fewer replacements requested.
OPERATING INCOME (LOSS) (38.564.00) (78,8001)0) 11130,582.00) (57,800.00)
NON-OPERATING REVENUE (EXPENSE .' 78,800.00 78,800.00 78,,00 $
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS 40,236.00 000 (57,782.00) (57,800.00)
OPERATING TRANSFERS IN 0.00 0.00 0.00 $ -
NET REVENUE OVERIUNDER)
EXPENSES PLANNED USE OF FUND HAL)* $4)236.00 $0.00 ($57,782.40)
TOTAL NET ASSETS - BEGINNING 3,193,123 52
TOTAL NET ASSETS - ENDING 33 135 341 52
Please note that in the Adopted Budget (Me-Item book) this is budgeted as "Planned Use of Fund Balance in the revenue category,
00 5:'26,2009
COUNTY OF OAKLAND
FY 200.0 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
ADOPTED AMINDIVI] PI 2009 VARIANCE
!FRINGE BENEFITS FUND 67800 I BUDGET aucuorr FORECAST FAVITUNF.AV) PERCENT EXPLANATION OF SIGNIT-ICANT VARIANCES
-----. n•••••n••••••••• —
OPERATING REVENUE
RETIREES Mt UICAL - VEBA DEBT 49,591,1E6 49,591,188 48,125,188 (1,465,001 -2.96% - untewooble aperatiric re vcnire for Retirens fvfedei...11 and Defined Contribilion
RETIREMENT ADMINISTRATION 2,835,367 2,838,367 2,794,367 f42„1, -1.48% due to the Iniring freeze
DEFINED CONTRIBUTION PLAN 14,353,000 14.363.000 13,997,000 (368,1 6 -2.55%
DEFINED CONTRIBUTION PLAN - PTNF 236,800 235.630 211P,808 06,6 d -7.10%
DEFERRED COMPENSATION - COUNTY 800,000 800,000 737,600 (62,40II -7.80%
EMPLOYEE 1N-SERVICE TRAINING 1,431.118 1,431,116 1,382,118 (40,40 -3.42%
EMPLOYEE BENEPTS UNIT 632,042 632,042 699,442 (7Z03 -3.58%
TUITION REIMBURSEMENT 360,090 360,000 345,000 cins I -4.17%
RETIREMENT HEALTH SAVINGS 390,000 300,000 3a2,eoc (7.41r -1.90%
GROUP LIFE INSURANCE 643,400 643,440 648,400 5,0s lc 0.78%
SOCIAL SECIJIRITY 15,800,000 16,600,000 15,325,830 (273, 1 -1.75%
MEDICAL INSURANC.IE 32,720,000 32,720,000 33,270,000 550,1 1 1.68% - based on use of Blue Cross illustrative rates and premiums for Health Arianos Plan
DENTAL INSURANCE 3,242,000 3,242,000 3,098,000 (144,1 I -4.44% - based on use or Derta Dental illustrative rates.
VISION INSURANCE 212,500 212.500 227,500 15,1 114 7.06% - bawd on use of Blue Cross illustrative rates.
DISABILITY INSURANCE 840,000 840,000 819,200 (20,1. I -2.46%
SHORT-TERM DISABILITY 1,584,000 1,584,000 1,574,000 (10,10 P i -0.63%
WORKERS COMPENSATION 2,874.542 2,674,542 2,880,542 195,m 7.29%
UNEMPLOYMENT COMPENSATION 450,000 450.000 4313,000 (11,2 } -2.44%
INVESTMENT INCOME 2,436,328 2,435.328 1,035,328 (1,401„..„1011 I ) -57. % - untavorabIe due to lower interest rates.
EX I- FLEX BEN LIFE INSURANCE 400,000 400,000 398,1 (1,MI, ) -0.4 % 1
E - FLEX BEN DENTA1 INSURANCE las,00la 105,000 100. (8,11175) -4, %
EX - FLEX BEN VISION INSURANCE 110,000 110,000 103, (7, 0 ) -6. %
EX - FLEX BEN MEDICAL - EMPLOYEE 3,935,000 3,935,040 3,889, 0 (248,••1) -6.2 % - unfavorable revenue die to hiring freeze.
EX - MEDICAL INSURANCE 280,000 280,030 267,4 (12,. Iii ) -4.5 %
EX - DNTAL INSURANCE 25,011Pq 25,0{30 21,21)3 (3,- il .1 -15.2 %
EX - VISION INSURANCE 2,5LI 2,500 2,1 0 (4 I} -16. '%
EX - FORrE)TURE OF DEPOSITS 10,800 10,000 10, 0 I 0. %
E - TRAINING
E - CHILD CARE FACILITY
485,001 455,000
0
0
465,0 n
6. 0
9, 0
6. 6
9..5%., 0. 945
I 0. u/o
0 eio
F - PRESCRIPTION DRUG REBATES
0 0 5 000 5 s 0. % EX - WELLNESS PROGRAM
TO REVENUE 138.375,585 1:18,3/5,585 132,977,685 {3,397, • I 1.1 -2.49%
FRINGE BENEFITS.xls 6,173120129
NET REVENUE OVER/TUNDERI EXPENSES 216,500 216.600
COUNTY OF OAXLAND
FY 2009 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
FRINGE BENEFITS FUND 87800
ADOPTED AMENDED FY 2009 VARIANCE
BUDGET BUDGET FORECAST FAVNUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING EXPENSE
RETIREES MEDICAL - VEBA DEBT PRINCIPAL 16,610,000 18,610,000 16,610,000 9 0.00%
RETIREES MEDICAL - VEBA DEBT INTEREST 32,981,188 32,981,188 32,462,888 496,300 1.51% - favorable due to change in the Fiscal Year payment from 10/01108-04/01109 to 04/01/09-
10/01109. Payment 10/01/09 is 5498,300 less than the earlier period
RETIREMENT ADMINISTRATION 2,836.387 2,836,367 2,356.067 480,soq 16.93% - reflects !ewer Investment tees caused by market downturn.
DEFINED CONTRIBUTION PLAN 14,363,000 14,363,000 13,980,000 383,00l 2.67% - favorable due to hiring free:7e.
!DEFINED CONTRIBUTION PLAN - PTNE 238,600 236,600 204,100 32,50l 13.74%
DEFERRED COMPENSATION - COUNTY 800.000 800,000 729,600 70, 880%
DEFERRED COMPENSATION -ACM 64.800 64,800 44,000 20,8CE 32.10%
SICK AND ANNUAL LEAVE CASH-OUT 891,390 891,390 900,490 (9,1 OCIO -1.02%
EMPLOYEE IN-SERVICE TRAINING 1,081,118 1,081,118 953,118 128.004 11.84%
IN-SERVICE TRAINING - INFO TECH 350.000 350,000 332,300 17.7045,06%
EMPLOYEE BENEFITS UNIT 632,042 632,042 616,042 16,004 2.53%
TUIIICN REIMBURSEMENT 360,000 360,000 312,000 48,0 13.33%
GROUP LJFE INSURANCE 1,043,400 1,043.400 1,009,400 34,300 3.29%
SOCIAL SECURITY 15,6.00,000 15,600,000 15.268,1300 332,000 2.13%
MEDICAL INSURANCE 29,600,000 20,600,000 28230,000 1,310,000 4.63% - favoratOe as result of sedlement with BCBSM, Oakland Cot int), will not be charged
administrative fee in FY2009.
PRESCRIPTION COVERAGE 7,800,000 7,600,000 7,800,000 0 0.00%
DENTAL INSURANCE . 3,372,000 3,372,000 3.210,000 162,001 4.80%
VISION INSURANCE 325,000 325.000 298,000 29,111 8.92%
DISABILITY INSURANCE 2,424,000 2,424,000 2,289,300 134,711 5.56%
WORKERS COMPENSATION 2,674,542 2.674.542 2.674.542 0.00%
UNEMPLOYMENT COMPENSATION 450,000 450,000 600.000 1150,000} -3133% - unfavorable due to federal stimulus package allowing additional 20 weeks.
FLEXIBLE BENEFIT PAYMENTS 200,000 200,000 200,000 0 0,00%
ACCOUNTING SERVICES 109,781 109.761 107,661 2,100 191%
CHILD CARE FACILITY 193,187 193,167 100,187 3,111 1.55%
PROFESSIONAL SERVICES 300,000 300,000 300,000 1 0.00%
RETIREMENT HEALTH SAVINGS 390,000 390,000 378,600 11,411 2.92%
WELLNESS PROGRAM 400,000 400,000 400,000 1 0.00%
INDIRECT COSTS 287 190 287 190 287 100 1 0.00%
TOTAL EXPENSE 136,375,585 136,375,565 132.761,185 3.014, ' ri 2.65%
TOTAL NET ASSETS - BEGINNING 13,407,454
TOTAL NET ASSETS - ENDING 13,623,954
FRINGE BENEFITS xls 6/23f2009
8.61 ,865.00 1,440,1e5.e0
$ 8.661.113.0o $ 8.7.114,365 00 $ 7,247,465 00 $ (1.536.900.00
Inside Ftevenue $ 11,531,700 00) -17.65% - Lenfav decrease in fuel revenue ;,$1,297,000) due to eerier fuel cost, offset by the
fay. gasoilee charges; decrease in leased equipment ($104,3001 due to eehicies
tumee In by departments and reduction ir vehicle mileage driven; reduced parts
and accessones revenue ($63,000) du t9 to service less than expected, partially
ctisel by the fa v. pees and acceseriries expenses.
Fav. increase in sublet repairs $23,000 cue to sereiee more than expected.
Tote Re rreinue
F,F141,227.00
111,63e.,422.00 9.024,365.00 OPERATING EXPENSE
NET INCOME (LOSS) EtFORE OPERATING
TF1ANSFERS $ (448,900.00) 5 1446,e00.00)
TRANSFERS IN iOUT) 000 $
NET REVENUE OVER/(Uee:1ER)
EXPENSES (PLANNED USE OF FUND MAL ) " S
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
$ (448,90000) $ (448,SDO 00)
$ 8,177,479.43
$ 7.72f1.57r9
JeFiscelSefeudeeelerecael eeke leERVICES. xis 6/23/2009
ree
ADOPTED
BUDGET
COUNTY OF OAKLANO
FY 200e SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS
CENTRAL SERVICES
AMENDED FY 2009 VARIANCE
BUDGET FORECAST FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
[MOTOR POOL FUND 88101)
OPERATING REVENUE:
Outside Revenue 5 126,486.00 5 108,50000 5 101 ,300.00 (6,200 00) -4.88r% - Unlav. reduced eeternal other revenue (514,000) and exterreeL parts and
eccesseees revenue (58.7e0) due to Oen' services less than expected FP u.
external productlee labor revenue $13,500 due In OUT services more lhar
expected increase in 'warranty reimbersenient $2,000 cue le CiM rear axle warranty
claims handled in-house
7,77,46500 $ 1,2511400 OD 13.87% - Fa. salary/fringe benefit reduced by $5.0 00 due to overtime reduction'. redireed
gasoline costs by $1,282,300 due to lower fuel price; auction expenses were
reduced by $13,000 due to reduction in sate of vehicles in tail auction and increase
sale at vehicles in Hint Auction; feet Insurance SWAIM due to estimated premium
saving; decrease in insurance reserve excrense of $35,000 due to less leased car
accidents; red weed expenditures in car wash 55030 and parts and accesscries
$30,000.
Fay. net decrease depreciation ot Stite300 due to deperteerets holding olc vetileles
longer and vehicles add in auction before fully depteciated.
Unfav. sublet repelre of 116.000) due ti incte.ase Internal service. UnIare increase
in indirect costs ($187,800,4due to actual clarges developed after budget
finalisation.
OPERATING INCOME (LOSS) $ 81,291.00 S (240,000,00) $ e525,000.00e $ (2115.000 00)
NON-OPERATING REVENUE (EXPENSE) 240,000.00 240,000.00 76,100.00 $ (163.900.00) -438.29% - Useav. gain on .sale of vehicles ($15s,00te duties sale proceeds less than salvage
value and Increase in the mileage cinven frnrn 65K to 1001.
[
OAKLAND couNTY INTERNATIONAL
AIRPORT (5650%
OPFRATINO REVENUE
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
ENTERPRISE FUNDS
CENTRAL SERVICES
ADOPTED AMENDED FY 2000 VARIANCE
BUDGET BUDGET FORECAST FAV/ILJNF.Avl PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
-
OPERATING EXPENSE
$5,457,064.00 $5,457,064.00 $4,507 064 00 ($950,000.00) -17 41% - Unfav. T-Haar Rental ($450,000) duo to a decrease in the nurnLer -r-
Hangars teased out and Aviation Gas 15)0,000) due to increase in COsl and
as a result of the downturn in the economy
$5_593,619.00 S5,593,519.00 $5,5413,519.00 $50,000.60 0.89% - Unfav.Overtime ($25,000) and the fringe benefits associated with it dirt to
personnel needed to clear heavy snowfwl and Pruti=ssional Services ($5,000"
due to environmental consultant issues on the airlield;4;am.aly offset b. Fav.
Property Taxes $80,000 due to lower than anticipated property taxes for T-
Hangars.
NET OPERATING INCOME (LOSS) ($136.755.00) ($136,455 OC) I$1,036,455.00) ($900,001).00 659.56%
NON-OPERATING REVENUE {EXPENSE) $ 3,584.00 $ 3,284.00 $ 3,284.00 $0.00 0.00%
TOTAL INCOME BEFORE
CONTRIBUTIONS AND TRANSFERS ($153,171.00) ($133,171.00) $ m033,171.00', ($900,000.00)
TRANSFERS IN $0.00 $0.00 $0_00
CAPITAL CONTRIBUTION 133,171.00 133,171.00 1,217,171.00 $1,084,000.00 813.99% Fay. Capital Contriblitions due to the recording of Federal and State Grants
for projects that began in 200; and completed in 2008 and recorded as
assets.
TOTAL NET INCOME (LOSS $0.00 $0.00 $184,000.00 $184,000.00
TOTAL NET ASSETS - BEGINNING $ 68,287,949.83
$68,471,949.63 TOTAL NET ASSETS - ENDING
I,') 6:2312009
Inside Revenue
Total Revenue
OPERATING EXPENSE
COUNTY OF OAKLAND
FY Ma SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS
CENTRAL SERVICES
ADOPTED AMENDED FY MS VARIANCE
BUDGET BUDGET FORECAST FAW{LINFAV) PERCENT
MAILING, CONVENIENCE COPIER AND PRINTING FUND 66700
EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING REVENUE:
Outside Revenue $ 512,500.00 $ 512,500.00 .5 bee,eLie.o0 $ 80,40u.oe 15.69% - FAY Chle till increased CV7 metered postage $40.200 and stanearri mail $43,'700.
Inlay. decrease of CVT printing service of ($9,000) due It. loss business than
expected.
3,073,578.00 3,073,e2e 00 2,8.54,228.00 $ (218,700.00) -7.12% - linfav. due 63 decrease & printing revenue ($167.0i)Oe less retiouse peel/ire? inns;
decreased metered postage ($91,0001- clepl less rnaili rag partially offset be lay
convenience copier $10,000 due to more copies thar expected, arid increased
standard mail 530.000 due to Inereasng department jobs
$ 3,56e5,028.00 5 3,5813,028.0e 5 0,447,728.00 5 (136,e00.00)
3,e-41,811.00 3,590,028.00 3,618,128.00 (28,100.00) 41.78% - Fav. reduced copier machine rental by 515,500 due to lease on copy machine
ending; decrease in printing for paper printing $49,000. printing supplies S5..000,
siatiortery stock 310,000 and maintenance contract S6J600 due to less prineng jobs.
Fay. metered postage 558,000 and mailing maintenance contract $3,200 due to
reducing depanmerrt mailing business, decrease lit business reply postage of
$3.700 due to less departments business, offset by unfav. business reply ppstace
revenue; reduceJ spending in training, travel & conference of $6,600 and
expendable equipment of e3.000. Uniav indirect costs of ($113,700) due to admit
charges developed after budget finalization, increase in standard matt ($19,(10fe
due to increased CATT business & depeilments jobs.
OPERATING INCOME (I OSS) $ 41:211 CO $ (4.000 00) $ (170,400.00) $ (168400.00
NON-OPERATING REVENUE (EXPENSE) 4,000.00 4,000.00 2)00.00 (1,300..0c) -32, f30% - Untav Investment income due to reduction of punting revenue
NET REVENUE OVER/CUNDER)
EXPENSE'S (PLANNED USE OF FUNC .) • 48 2'1'1..00 (167,700.00) 8, (167.700.00)
TOTAL NET ASSETS - EECINNING $ 465.302.12
TOTAL NET ASS E1 - ENaiNG $ 297,602.12
'Please note that iu the Adopted budget (line-item budget), Planned Use of Fund Balance appears listed with the revel eel accoente.
Ce. J.Wiscale Precast, NevASUPPORT SERVICESeee Ie2312009
OPERATING REVENUES:
Outside Revenue
Inside Revenue
Total Revenue
OPERATING EXPENSES
FACILITIES INTERNAL FORE.xls 6,r;31201i9
COUNTY OF OAKLAND
FY 2409 SECOND QUARTER REPORT
INTERNAL SERVICE FUND I ENTERPRISE FUND
FACILITIES MANAGEMENT
ADOPTED AMENDED FY 2009 VARIANCE
BUDGET BUDGET FORECAST FAV/(LINFAV) PERCENT
'FACILITIES MAJNTENANCE & OPERATIONS (015310U) I
EXPLANATION OF SIGNIFICANT VARIANCES
$570,638.00 5570,638.00 $568,738.00 18,100.00 3.17% - Fay, revenue for maintenance services provided primarily to 0. C. Road
Commission and receipt of insurance payments for incurred property damage.
27,091,541.00 27,091,541.00 27,117,341.00 25,800.00 0.10% - Fay. Maintenance Department Charges to Departments based on requested level
of service $50.000 and Refund of Prior Years Expenditure $38,200 to adjust project
repair costs, partially offset by reduced Office Space Rental revenue based on
lease agreement with O.C. Road Commission for space in the information
Technology Center ($85,S00).
$27,662,179.00 $27,662,179.00 $27,706,079.00 $43,900.00 0.16%
$27,953,379.00 $27,953,379.00 $27,241,279.00 $712,100.00 2.55% - Fay. Natural Gas/ Fuel Oil $300,000 due to favorable long-term pricing contracts;
turnover $275,000; fay. Sublet Repairs $200,000 due to County budgetary
restraints resulting in reduction andior deferral of requests for alterations; fay.
Electrical Service $100,000 due to lower cost third-party contracts; fav.
Depreciation $28,500 eased on current depreciation schedule; and fare Motor Pool
$40,000 eased on expected usage.
Favorability is partially offset by unfav Water & Sewage Charges ($100,000) based
on rate increase and projected usage; Indirect Costs ($75,600) due to
determination of costs subsequent to budget determination, and Adiustment of
Prior Years Fxpense ($50,646) to reclassify maintenance project charges.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS ($291,200.00) ($251,200.00) $464,800.00 $756,000.00
NON-OPERATING REVENUE $240,000.00 $240,000.00 $215,000.00 ($25,000.00) -10.42% Declining interest rates
TRANSFERS IN
TRANSFERS OUT (200.000.00) (7(12,836.45) (702,836.45) - 0.00% - Transfers Out for Elevator Modernization Capital Project $402,836; Primary
Electrical System Maintenance Phase I Project 5100,000; and Maintenance
BUDGETED EQUITY ADJUSTMENTS - - - - Projects $200,000.
NET REVENUES OVER(UNDER)
EXPENSES .=.10:1,2EM $731,000.00
TOTAL NET ASSETS - BEGINNING $9,839,952.83
TOTAL NET ASSETS - ENDING $9,816,916.38
IfAease note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category.
EXPLANATION OF SIGNIFICANT VARIANCES ylellANCE
OPERATING EXPENSES $34,675,493.00 $38587,663.00 $34,113.863 00
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS ENTERPRISE FUND
INFORMATION TECHNOLOGY
AnOPTIED AMENDED FY 2009
EFUDGFT BUDGET EQ RECAST
(atformstion Technology- Opera(lone Maga/
OPERATING REVENUES;
Outside
Inside
TOTAL OPERATING REVENUE
5861,545.00 $261,545 00 $737,145.00 ($1*24,400.00) -.14.44% - Urifev.Ouisi de agencies {$39,400) due to reduction in external custornar „-
requests: Deterred Land Fe Tax 027,000) & Reimb Equat..zaiion Svcs
($8,800) as a result of change In haling Procedures due to tax & ritssessrneal ... software; & Enhanced Access Fees (548,700) due to tinting of
implementation of E -Commerce online. .
26,888,807.00 26,888,807.00 23,671,20100 (3,217,6010.00) -11;07% - Urrtay. Cleats OC Dept' Dev & Ops 43,221,5001 & Imaging Dev & Ops
{5556,700) clue to holding rates at prior year levels. Clomts Otter Outside
($71,700) sUbsequent to budget. Partially offset by fa v. Non Goya; Day & ops
5832,300 duo to increase in projects requested by Non-OF.
527,750,352 00 $27,760,352.00 $24,406,2b2,00 ($3.342,000.0o -12.04%
$2,473,700.00 6.76% - Fa'. primanly due to Deprec 51,074,300 .fur IT capital projects in progress not
fully otlerational: Salary & FS 5566,800 due to vacancies; $460,900
Equipment laalat due to lower than arilkaPatea hardware maint costs;
Supplies $2.07,900, Communications 5100,000, Service Bureau 575,000,
Mem Dues $3,500 & Auction $1,700 dire-to cost reductions; Sofhvere Lease
$75•000 due to timlng of software license ouraiases; Internal Svcs $67,100
based on abtual maga; -Travel $23,100 due to decline in staff attending
conferences: Software Moire $16;000 due to timing of actual costs for
support: encore,:lad Svcs 562,600 & Indirect Cost $18,a00 due to budget
projection slightly higher than actual rate; Prof Svcs 513,500 duo to timing of
previously approved IT projects. Partially offset by Expend Equip ($310,100)
due to equitaneril replacements; Ad j Prior Yr Exp ($10.2.0C); Charge Card Fee
($63,500) credit card fees higher than anticipated.. Charge Card fees are
offset by Enhanced Access revenue.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (56,925,141.00) (58,837,211.00) ($9,705,511.00) (5008,300.00)
NON-OPERATING REVENUE 305,500 00 305,500.00 40/,900 .00 102,400,00 33.52% Fay. primarily due to Interest Income; ha.;her cash balance than anticipated,
TRANSFERS IN 2245,923.00 4.151,99100 4.1 57,993.00 (.013 o OC%
7NANSFER5 (OUT) 0.00 0.00 0.00 0,00 0.00%
NET REVENUES OVER(UNDER) EXPENSES' (54,373,718.00) 1.4,373,718.00) (55,139,6 18.00) (5765,900,001
TOTAL NET ASSETS - BEGINNING 30.489810.57
TraTAL NET ASSETS - ENDING I Please note note that in the Adopted Budget (line-item book) this is hadgeted as Planned Use of Fund r! trl me re vent*,
S.
OPERATING REVENUES:
Outside $3,609,172.00 $3,262,914.00 $3,422,614.00 5139,700.00 8.38%
429,404.00 429 404.00
$4,036,576.00 $2,712,318.00
511,996,054.00 $11,8136,054.00
47,957,478 00 I
60,000.00
1,459,117.00
1100
2,296,904.00 1,667,500.00 53.20%
$5,719,516.00 $2,007,200.00 9.29%
5845,800.00 7.13%
($5,300,736.00)
14,300.00
1,5E9,117.00
0.00
Inside Fay. primarily due to CAD support fee for Radios legacy system.
TOTAL OPERATING REVENUE
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
NON-OPERATING REVENUE
TRANSFERS IN
TRANSFERS (OUT)
($13,153,736.00)
60,000.00
1,489,117.00
0.00
511,020,254.00 Fey. $765,800 SallFB due to underfills & vacancies; Prof Svc $400,000 due to
reduced contractual hours; Soft Maint 5175.000 due to tirninp of anticipated
maintenance costs; Indirect Cost $26,000; Travel $3,000 & Workshops 5000
due to decreased usage; Parts & Access 571,800 due to the replacement of
livescan equip under warrerity; Info Tech Ops $45,800 based on historical
usage. Offset by unfav. Comm ($342,200) due to higher than anticipated
connectivity costs; Rebillable Services ($39,400) due to addti costs of the Tier
2.5 & 3.0 agencies; Software pachases ($23,100) staff requiring
development tools to complete various CLEMIS projects; Expend Equip
(5206,100) due to equipment costs for mueshot arid MDC operations & tofu
Tech Div, ($27,000) due to the addri assistance required for Records Mgt
Sys; and Bank Charges ($5,500) due to cost for payeel services for E-
Commerce transactions.
Unfav, Interest Income due to lower returns.
$2,853,000.00
(45,700.00)
100,000.00
0.00
-7617%
6..72%
0.00%
AM ENDED
DUDGET
ADOPTED
BUDGET
Information Technolggy - CLEIMIZ (53500) I
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
INTERNAL SERV)CE FUNDS I ENTERPRISE FUND
INFORMATION TECHNOLOGY
FY 2009
IFORIECAII VABIANOE EXPI-ANATIOV ciF SIGNIFICANT VARIAMCIES
Fey. Parts & Access $201,600 due to tech support svcs; Maintenance
Contracts $90,800 evescan equip under warranty; Rebilled Cearges $53,500
due the addiiional connectivity costs charged to the Tier 2.5 & 3.0 agencies;
Clemis Oper Outside $1,800 & Outside Agencies $9,700 due to actual FTE
count slightly higher than budget projection. Partially offset by unfav. Ext.Rev
($100,000) due to timing of implementation of E-Coresnerce; In-Cat Terminals
External ($88,300) diie to budgeted IVIDC count higher than actual MDC
participation & Enhanced Access Fees ($50,000).
NET REVENUES OVER(UNDER) EXPENSES M M1.9-04 614.00 (53,697,319.00) .._1322
TOTAL NET ASSETS - BEGINNING 9,456,569.48
TOTAL NET ASSETS - ENDING - $Z27048
.IPlease note that in the Adopted Budget (line-item hrbok) this is budgeted as "Planned use of Fund Balance" In the revenue category. cr+
()MENAI-1NQ REVENUES:
Outside
Inside
TOTAL OPERATING REVENUE
OPERATING EXPENSES
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
5,235,841.11
COUNTS OF OAKLAND
FY 2009 SECOND QUARTER REPORT
INTERNAL GERviCE FONDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2009
BUDGET KiggeT FORECAST vARLANCE EXPLANATION OF SIGASFicANT vARIANCE$
ilinforraation Trohnolosy - Tslophons Communications (67500)
532,000.00 532.000.00 531,500.00 ($500.00) -1.56% Linfav. Sale of Phone External due to decreased usage.
3.297,400 .00 3,297.400.00 3,161,700.00 (135,700 00) -4.12% Urfav. Leased Equip ($6,600) due to decreased use of pagers & Sale of
=hone Internal 41:20,S00) due le rechicion in:te/c.phone rates.
$1.32F. .400 00 53,329.400.00 53,193,200.00 ($13&,20000) -4.09%
53,787,391.00 p.757,391.00 $3,779,6c11.00 $7,760.00 0.20% Fay. into Tech Cps 40,400 due to timing of equip replacements S. Vinice Mail
$1,500 due to decreased usage. I-ay. partially offset by unfav. Sal & FB
412,300) due to average cost of salarfes increases and fringe benefits rates
& Info Tech De' ($30,600) due to Telesoft upgrade.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS ($457.991.00) (5457,991.0C) ($506.491.00) ($128,500.00
NON OPERATING REVENUE 30,000.00 30,000.00 59,000.00 20,000.00 96.67% Interest Income faverahle due to higher cash balance than antiicpated.
TRANSFERS IN 0.00 0.00 0.100 0.00 0.00%
•FRANFERS (01.1T) 0.00 0.00 9.00 9,00 006%
NET REVENUES OVER(UNDER) EXPENSFS'......91.00L 4427,99 .00) 4527,491.001 , ($90.600.00)
Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance' in the revenue category.
AMENDED
UDGET
OPERATING REVENUES:
Outside 55,019,277 00
Inslide 320,965.00
35,172,336.00 51,430,700.00
838,081100 516,800.00
$5,340,242.00
$7,337,333.00
(31,997,091.00)
150,000.00
165,809.00
Ji 50,000.00)
($3,274,732.00) $364,668.00 53,639,400 00
150,000.00 642,100.00 492,100.00 328,07% Fey, primarily due to Interest Income; higher cash balance than anticipated.
515,809.00 515,809.00 0.00 0.00%
(256,607.00) (256,807.00) 0 00 000%
TOTAL OPERATING !REVENUE
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
NON-OPERATING REVENUE
TRANSFERS IN
TRANSFERS (OUT)
$1,947,500.00 47,93%
23.06% Fay, primarily due to Depreciation $1,978,800 timing of implementation of
new system; Expendable Equip 5162,400 due to decrease in equip
replacements, Special Projects $50,000 due to timing of exp; Utilities $43,900
based on historical usage; Sal&FB 527,800 due to lower than anticipated
evertirre: IT Oper $17,400 eLe to decreased usage; Small Tools $15,000 &
Supplies $1,000 due to timing of purchases; Indirect Cost $7,300: & Freight
$2,900 due to lower then anticipated usage. Fay, partially offset by unfav.
CLEMIS charges ($413,300) for CAD support fees for legacy system; Prof
Sve.s ($59,300) due to increase contractual costs; Comm (544,500) due to
increased connectivity costs; Equip Meet (567,600) due to maintenance of
legacy system; & Tower Charges ($30,000) due to timing of contractual
increases for leased tower sites.
54,062,922 00 56,010,422.00
57,331,654.00 $5,645,754.00 $1,691,900.00
NET REVENUES OVER(UNDER) EXPENSES' (31.831,28200) (52,865,730.00) $1,265,770.00 fl.a.1Z.1516)=.0.00
ADOPTED
BUDGET
[Information Technology • Radio Cornmonloallo- ea (53E40)
COUNTY OF OAKLAND
FY 2009 SECOND QUARTER REPORT
INTERNAL SERViCE FUNDS I ENTERPRISE FUND
INFORMATION TECHNOLOGY
FY 2009
FORWAST VARIANCk EXPLANATION OF SIGNIFICANT yARIANCES
$3,741,636.00
321,286.00
38.24% Fav. E-911 $1,624,600 due to h-gher than anticipated revenue from wireless
co. & Outside Agency $138,200 due to timing of phase out al legacy system.
Unfav. offset by Antenna Site Mgt (3332,100) due to consolidation & paging
phase-out.
160.% Favorable Internal Revenue for Leased Equipment $464,000: Parts Access
349,900 & Productive Labor $2,900 due to timing of the projected phase-out
of the legacy system.
TOTAL NET ASSETS - BEGINNING 52,335,868.79
TOTAL NET ASSETS - ENDING $53..641.838.79,
Please note that in the Adopted Budget (line-item book) this is budgeted as Planned use of Fund &dance in the revenue category
cc
411.
COUNTY OF OAKLAND
FY 200a SECOND QUARTER REPORT
INTERNAL SERVICE FINDS I ElsITERPRISE FUND
INFORMATION TECHNOLOGY
ADOPT-ED AMENDED FY 2009
PUDG builgET FORECAST wAAIA.NCE EXPLANATION OF §IGNIFICANT VARIANCF4
[Fire Records Management ( 53109)
OPFFtATING REVENUES:
Outsioe
I-0-1AL OPERATING REVENUES
OPERATING EXPENSES
$100,689.00 $2003,515,00 $210,115 00 $3,,603.00 1.74% Fav. primarily due to impLementation of new agencies.
$1144,6119.00 $206515.00 $210,115.00 50,60000 1.74%
5E142,909.00 SCS3,928.00 $1151,026.00 $2.900.00 044% Fay.. Equip Main1$15,000 due to negetteting V atom contract to lime &
materials basis for hardware roaint; Cornmunicaticris $7,500 delay in
connectivity costs relative to implementation of new agencies, Personal
Mileage $-1,700 due to decreased demand for teens to travel to member sites,
Expend Equip $11.200 decrease equip replacements. Fay, partially offset by
uniev. Software Purchase (11100) due to he timing el software license
purchases for new member agencies Software Maintenance ($1.700) due to
incressed rates; IT Day (58,600) due to programming services; Indirect Cost
{$2.900); Deprec ($2,100) due to purchase of server equip after budget & IT
Ops (51.000) due to increased usage.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS ($44?,97100) ($44T,413.00) ($440,913.00) $ti,500.00
NON OPERATING REVENUE 2,000.00 2,000.00 5000.00 3,000.00 150.00% Interest income favorable due to higher cash balance than anticipated.
TRANSFERS IN 439,705 00 445.413 00 444.411.4)0 0.00 0.00%
TRANSFERS (OUT) V. 0.00 0.00 0.00 0.00%
OPERATING INCOME (LOSS1 ===M121.101 MD 00 Sr-CAC. 00 . $9.53 00
TOTAL NET ASSETS - BEGINNING 010,782.77
TOTAL NET ASSETS - ENDING $320,292.77
Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" rn the revenue category
'0 -
•
-
Resolution 409132 July 15, 2009
Moved by Cabello supported by Woodward the resolutions (with fiscal notes attached) on the Consent
Agenda be adopted (with accompanying reports bei rig accepted).
AYES: Burns, Capelio, Coleman, Coulter. Douglas, Gershenson, Gingell, Gosselin, Greimel,
Hatchett, Jackson, Jacobsen, Long, McGillivray, Middleton, Nash, Potter, Potts, Runestad,
Schwaitz, Scott, Taub, Woodward, Zack, Bullard. (25)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the Consent
Agenda were adopted (with accompanying reports being accepted).
I HEREBY APPROVE THE FOREGOING RESOLUTION
ACTING PURSUANT 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 July 15,
2009, with the original record thereof now remaining in my office.
In Testimony Whereof, I have hereunto set my hand and affixed the seal of the County of Oakland at
Pontiac. Michigan this 15th day of July, 2009.
eat
Ruth Johnson, County Clerk
• 4