HomeMy WebLinkAboutResolutions - 2007.03.22 - 28460MISCELLANEOUS RESOLUTION #. 07047 March 22, 2007
BY: FINANCE COMMITTEE, MIKE ROGERS, CHAIRPERSON
IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2007 FIRST
QUARTER FINANCIAL FORECAST AND BUDGET AMENDMENTS
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
WHEREAS Public Act 621 of 1978, the Uniform Budgeting and Accounting
Act for Local Units of Government, provides for adjustments to the adopted
budget; and
WHEREAS in accordance with Oakland County General Appropriations Act
Section 22, which authorizes budget amendments for variances between the
budgeted revenue and actual revenue, and Section 23, which authorizes
budget amendments for variance between estimated revenue and projected
expenditures, amendments are required; and
WHEREAS the Fiscal Year (FY) 2007 First Quarter Financial Forecast
Report has identified several variances and budget amendments are
recommended; and
WHEREAS a budget amendment is requested by the 52 nd District Court-
Division III in the amount of $3,100, as funds were approved in FY 2006 for
a safe for which funds were not carried forward; and
WHEREAS the 52''d District Court - Division IV has requested a budget
amendment in the amount of $10,000 to offset expenses for Charge Card Fees;
and
WHEREAS MR #96131 authorized the creation of one secretary position
to be funded by the Library Fund, and a transfer of $27,209 is budgeted in
FY 2007 as though from an outside fund, and since the Library Fund was
closed and transferred to the General Fund, the funds are now recorded in
the General Fund as a designated fund balance, and a budget amendment is
recommended to reflect funding as "Planned Use Fund Balance"; and
WHEREAS an amendment to decrease the Auditing Division revenue budget
$29,750 is recommended as it is anticipated there will not be an audit for
the Community Development Block Grant in FY 2007; and
WHEREAS the Equalization Division is requesting a budget amendment to
recognize an increase in revenue in the amount of $21,997 to offset
expenses related to the Warrant and Settlement System enhancements for the
capture of spread tax rates, via an input file from BSA-Tax, which will
reduce manual efforts in the Equalization Division and allow both
Equalization and the Treasurer's Office to view spread rates by CVT before
accepting and finalizing them; and
WHEREAS a budget amendment in the amount of $7,666 is required in the
Veterans' Services Division budget to increase appropriations for the
Soldier's Relief line-item to be in accordance with the requirements of
Public Act 214 of 1899, as amended, which authorizes .0004 mills Current
Tax Levy to be designated for the purpose of funding Veterans' Services
Soldier Relief; and
WHEREAS the County is obligated to pay for license fees to recording
artists for music played in County buildings or at County events (i.e.,
Dream Cruise, Parks and Recreation), which is estimated to cost $20,000 for
FY 2007, and a budget amendment is based on projected favorability to
offset Logos and Trademarks Expense in the Non-Departmental Sundry Expense
for license fees; and
WHEREAS the Health Division is requesting a budget amendment in the
amount of $70,681 to reduce salaries and fringe benefits in the Health Fund
for a Grant funded position that was budgeted in error in the Health Fund;
and
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote.
WHEREAS an accounting correction is necessary to a portion of the
allocations proposed in the FY 2007 grant amendment for the Health
Division's Michigan Department of Environmental Quality (MDEQ)
Reimbursement Agreement, approved by Board of Commissioners per MR #06217,
and a budget amendment totaling $7,475 is recommended to the Health Fund;
and
WHEREAS the expense for private institutions for residential and
foster care is projected to be unfavorable due to an increase in the number
of cases and the degree of difficulty for care and treatment services such
as counseling and drug screening, offset by a projected increase in revenue
for Child Care Subsidy, and a budget amendment in the amount of $1,546,167
is recommended to account for the increase in revenue and expenditures; and
WHEREAS the transfer of $24,917 from Facilities Maintenance and
Operations Fund (FM&O) #63100 to the Motor Pool Fund #66100 is necessary to
cover additional upgrades and accessories related to the replacement of a
lease 1996 dump truck used by FM&O with the new dump truck being owned by
FM&O Fund and $108,917 is the transfer of the capital asset from the Motor
Pool fund to the FM&O Fund (non-related cash); and
WHEREAS a budget amendment is recommended to the Radio Communications
Fund to appropriate $400,000 in anticipated Income from Investments, as
well as to allocate operational costs associated with the new radio system;
and
WHEREAS various amendments are recommended to reappropriate funds
from Planned Use of Fund Balance within the Information Technology Fund to
continue or complete a number of projects, such as the IT Service Center
($213,890), which was completed after the FY 2006 appropriation, $818,176
for equipment replacement purchases completed after FY 2006 appropriation
per MR #06175, $55,642 for professional services for security systems audit
of PCI Security Metrics ($8,558), Telecommunications & Technology Toolkit
for Wireless Oakland Initiative ($15,216), Economic Development Website
($31,868) and the reappropriation of funding in the amount of $513,846 for
various projects previously approved (i.e. Data Warehouse enhancements,
PeopleSoft Phase II, BS&A Receivable Migration, Delinquent Tax Receivable
System, GIS Enhancements and Community Crimewatch); and
WHEREAS Information Technology Administration requests budget
amendments totaling $474,747 to reallocate professional services within IT
divisions based on the FY 2007 IT Master Plan priorities, which was
completed after the FY 2007 budget projection; and
WHEREAS MR #06160 revised the @ccess Oakland Mater Fee Schedule, and
an amendment to the Department of Information Technology budget is
requested to reflect the anticipated reduction of $60,000 in revenue for
Recorded Document Profile Fees; and
WHEREAS the Health Division's FY 2006/FY 2007 Comprehensive Planning,
Budgeting and Contracting (CPBC) Agreement was approved per MR #06200 with
the budget amendment pending final detail at the time, and based on final
detail, a budget amendment is requested to reflect the grant award in the
amount of $8,316,949; and
WHEREAS the following departments have requested budget amendments to
reallocate funds within their budgets for such accounts as FA Proprietary
Equipment Expense, Expendable Equipment Expense, Drug Testing, Medical
Exams, Membership Dues, Periodicals and Books, Print Shop, Payment in Lieu
of Assessments, Community Correction Fees, Charges for Services and others,
to more accurately account for actual expenses and do not require
additional funding:
Department/Division Total Amendments
52nd District Courts $ 25,085
Treasurer's Office $ 110,000
Board of Commissioners $ 3,500
Library Board $ 1,750
Equalization Division $ 2,000
Purchasing Division $ 2,000
Fiscal Services Division $ 2,000
Reimbursement Division $ 5,000
Community Corrections Division $ 380,000
MSU Extension Division $ 1,056
Non-Departmental Sundry $ 417,500
Sheriff / Non-Dept / Health Division (GF/GP Transfers)$ 141,667
CLEMIS Fund $ 3,000
IT Fund $ 144,600
Circuit Court/FOC Fund $ 5,210,472
Circuit Court/SCAO Drug Court Grant $ 170,000
Circuit Court/Byrne Drug Court Grant $ 170,000
Sheriff / Health Division - Drug Policy Grant $ 167,216
Prosecuting Attorney - NET Grant $ 1,183
Medical Care Facility $ 28,428
Parks and Recreation $ 19,350
; and
WHEREAS the Human Resources Department is continuing to experience
significant expenses related to increased legal actions filed by the
Oakland County Deputy Sheriff's Association, as well as anticipated legal
expenses associated with ACT 312 proceedings, for which a budget amendment
is necessary to recognize $200,000 in funds from the Designated Fund
Balance account for HR-Legal Expense (GL Account 4371450) to the Human
Resources Administration - Legal Services account to offset these costs;
and
WHEREAS an amendment is recommended to the Information Technology
Fund to appropriate funds in the amount of $500,000 for the Image Document
Storage System that was designated in the Non-Departmental General Fund (GL
account 4371452); and
WHEREAS an amendment is recommended to the Information Technology
Fund to appropriate funds in the amount of $432,000 for workstation
replacements necessary for the XP upgrades, server upgrades, and services
for planned maintenance projects for the first part of FY 2007, and funding
is available in the General Fund Designated Fund Balance (GL account
4371448) for Future Technology Replacements; and
WHEREAS pursuant to MR 401249, the Board of Commissioners authorized
the elimination of the separate County Library fund and required that the
remaining balance in that fund including accrued interest be transferred to
the General Fund and that interest be applied to the Designated Fund
Balance which for FY 2006 is $3,097.38 and Undesignated Fund Balance will
be reduced accordingly; and
WHEREAS a donation was received by the Health Division totaling
$1,901.65 from RMHC Babies to purchase safety and developmental toys and
items for use in the Nurse Family Partnership Program; 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 adjustments made to the Inmate Accounts for FY 2007 during
the period of October through December totaled $395,893.15; and
INFORMATION TECHNOLOGY FUND (#63600)
Revenue
1080101-152000-695500-10100 Transfer In from General Fund $932,000
Total IT Revenue $932,000
WHEREAS several uncollectible accounts have been identified, totaling
$8,330.99, and an approval to write off bad debts as identified in Schedule
C is requested.
NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts
the Fiscal Year 2007 First Quarter Financial Report.
BE IT FURTHER RESOLVED that $200,000 from the HR-Legal Services
Designated Fund Balance account be appropriated as follows:
GENERAL FUND (#10100)
Revenue
9010101-196030-665882 Planned Use of Fund Balance $200,000
Total General Fund Revenue $200,000
Expenditure
1050102-183010-731073 Human Resources - Legal Services $200,000
Total Gen. Fund Expenditure $200,000
Total General Fund 0
BE IT FURTHER RESOLVED that $500,000 from the Image Document Storage
System Designated Fund Balance and $432,000 from the Future Technology
Replacement Designated Fund Balance account, for a total of $932,000 be
appropriated as follows:
GENERAL FUND (#10100)
Revenue
9010101-152000-665882
Expenditure
9010101-152000-788001-63600
Planned Use of Fund Balance
Total General Fund Revenue
$932,000
$932,000
Transfer Out to Info Tech Fund $932,000
Total Gen. Fund Expenditure $932,000
0
Expenditure
1080201-152010-731458
1080101-152010-731458
1080201-152010-731458
1080601-152010-731458
1080701-152020-731458
1080601-152010-750170
Professional Services $500,000
Professional Services 12,050
Professional Services 21,600
Professional Services 112,250
Professional Services 1,700
Expendable Equipment Expense 284,400
Total IT Expenditures $932,000
Total Change in Fund Balance 0
BE IT FURTHER RESOLVED that Designated Fund Balance for County
Library (#10100-9010101-371472) be increased by $3,097.38 and decrease
Undesignated Fund Balance (#10100-9010101-390100)to reflect FY 2006
interest earnings.
BE IT FURTHER RESOLVED that the uncollectible debts, as identified in
Schedule C, are authorized to be written off.
Chairperson, on behalf of the Finance Committee, I move the adoption
of the foregoing resolution.
FINANCE COMMITTEE
COUNTY MICHIGAN
DEPARTMENT OF MANAGEMENT AND BUDGET FISCAL SERVICES DIVISION
Timothy J. Soave, Manager
/
L. BROOKS PATTERSON, OAKLAND COUNTY EXECUTIVE
TO: Members of the Finance Committee
FROM: Laurie Van Pelt, Director, Management and Budget
Art Holdsworth, Deputy Director, Management and Budget
Tim Soave, Manager, Fiscal Services
Nancy Fournier, Chief, Fiscal Services
LaVerne Smith, Supervisor of Fiscal Services
SUBJECT: Letter of Transmittal - Fiscal Year 2007 First Quarter Forecast Report
DATE: March 1, 2007
FY 2007 FORECAST
Attached please find the Fiscal Year (FY) 2007 First Quarter Forecast Report. In total, Fiscal Services forecasts that
the County will complete Fiscal Year 2007 with overall favorability of $12,406,201 in General Fund! General
Purpose (GF/GP) operations. GF/GP includes all operations except grants, enterprise funds and internal service
funds. This overall favorability is split between receiving $15,361,540 more revenue than anticipated and
expending $2,955,339 more than budgeted.
REVENUES
Forecasted GF/GP revenues are estimated to be 3.09% more than budget or $15,361,540. The majority of the
favorability is the result of the following events:
A. TAXES- Favorable: $13,410,000
• FY 2007 forecast is more than budget since it is based on updated estimated April 2007 Taxable
Value (TV) for the July 2007 levy. The FY 2007 budget was based on April 2006 TV for both
December 2006 levy and July 2007 levy.
B. STATE GRANTS —Favorable: $1,562,296
• The Child Care Subsidy from the State is expected to be favorable $1,544,004 due to the
significant number of State ward cases. This is offset by unfavorability in expenses for private
institutions and independent living.
C. OTHER REVENUE - Favorable: $581,919
• Other Revenue is favorable due to receipts prior year adjustments and is partially offset by Sundry
Revenue which was budget in Charges for Services. A budget amendment is recommended.
EXPENDITURES
In total, expenditures are estimated to be 0.59% more than budget or ($2,955,339), housing of prisoners and
housing of county wards. This is partly offset by favorable personnel expenses within departments due to turnover
of staff. Departments that are projected to be unfavorable at the end of the fiscal year (barring any amendments) are:
Public Services.
A. SHERIFF — Unfavorability of ($2,514,000) is forecasted mostly the result of salary and fringe
benefit costs related to jail overcrowding and hospital watch.
B. HUMAN RESOURCES — Operating expenditures are expected to exceed budget for legal costs
associated the union negotiations and arbitration hearings for Sheriff's deputies. A budget
amendment is recommended.
C. HEALTH AND HUMAN SERVICES (HHS) - HHS Administration is forecasted to be
unfavorable $1,546,167 at year end due to Private Institutions — Residential, Foster Care and
Independent Living. Children's Village is forecasted to be unfavorable for Teachers Services and
Expense for FY 2006 expenses. Revenue favorability offsets expenditures (See State Grant
Revenue - Child Care Subsidy. A budget amendment is recommended.
EXECUTIVE OFFICE BUILDING 34 EAST • 1200 N TELEGRAPH RD • PONTIAC MI 48341 -0403 • (248) 858-0807 • FAX (248) 452-9467
1
_ • , COUNTY OF OAKLAND „
FY 2007 FIRST QUARTER FINANCIAL REPORT
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
FY 2007 BUDGET AMOUNT
ADOPTED AS FY 2007 FAVORABLEJ
BUDGET AMENDED FORECAST (UNFAVORABLE) PERCENT
REVENUES
GENERAL FUND
Taxes $ 330,988,400.00 $ 330,988,400.00 $ 344,398,400.00 $ 13,410,000.00 4.05%
Special Assessments 110,000.00 110,000.00 - (110,000.00) -100.00%
Federal Grants 564,075.00 519,300.00 499,300.00 (20,000.00) -3.85%
State Grants 15,893,090.00 16,066,495.00 17,628,791.00 1,562,296.00 9.72%
Intergovernmental General Reimbursement 9,118,000.00 9,118,000.00 9,118,000.00 - 0.00%
Intergovernmental Program Revenue 2,795,550.00 2,795,550.00 2,865,550.00 70,000.00 2.50%
Charges for Services 90,176,504.00 90,192,398.00 89,923,723.00 (268,675.00) _0.30%
Indirect Cost Recovery 8,200,000.00 8,200,000.00 8,200,000.00 - 0.00%
Investment Income 5,012,000.00 5,012,000.00 5,148,000.00 136,000.00 2.71%
Other Revenues 28,436,419.00 28,481,169.00 29,063,088.00 581,919.00 2.04%
SUB-TOTAL GENERAL FUND/GENERAL PURPOSE $ 491,294,038.00 $ 491,483,312.00 $ 506,84.4,852.00 $ 15,361,540.00 3.13%
PLANNED USE OF FUND BALANCE (1) 21,333.00 $ 5,766,152.04 $ 5,766,152.04 $0.00 0.00%
TOTAL GF/GP FUNDS $ 491,315,371.00 $ 497,249,464.04 $ 512,611,004.04 $ 15,361,540.00 3.09% „ _ „ „
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court $ 51,622,089.00 $ 52,231,789.12 $ 52,149,589.12 $ 82,200.00 0.16%
52nd District Court 16,817,574.00 16,896,073.72 16,880,773.72 15,300.00 0.09%
Probate Court 6,185,357.00 6,252,602.88 6,151,902.88 100,700.00 1.61%
TOTAL ADMIN. OF JUSTICE $ 74,625,020.00 $ 75,380,465.72 $ 75,182,265.72 $ 198,200.00 0.26%
LAW ENFORCEMENT
Prosecuting Attorney 18,949,242.00 19,176,744.42 19,120,744.42 56,000.00 0.29%
Sheriff 121,837,151.00 122,252,718.59 _ ..124,766,718.59_ _ .._ _ (2,514,000,00) -2.06%
TOTAL LAW ENFORCEMENT $ 140,786,393.00 $ 141,429,463.01 $ 143,887,463.01 $ (2,458,000.00) -1.74%
GENERAL GOVERNMENT
Clerk/Register of Deeds 11,792,760.00 12,292,382.03 11,697,882.03 594,500.00 4.84%
Treasurer 3,784,452.00 3,888,563.74 3,888,563.74 - 0.00%
Board of Commissioners 2,924,820.00 2,927,529.27 2,927,529.27 - 0.00%
Library Board 2,572,722.00 2,574,115.77 2,574,115.77 - 0.00%
Drain Commissioner 5,209,913.00 5,847,904.23 5,847,904.23 - 0.00%
TOTAL GENERAL GOVERNMENT $ 26,284,667.00 $ 27,530,495.04 $ 26,935,995.04 $ 594,500.00 2.16%
COUNTY EXECUTIVE
County Executive Admn. $ 7,857,193.00 $ 7,966.687.44 $ 7,793,687.44 $ 173,000.00 2.17%
Management and Budget 20,859,881.00 21,283,466.55 21,226,466.55 57,000.00 0.27%
Central Services 2,706,959.00 2,734,203.81 2,734,203.81 - 0.00%
Facilities Management 1,609,762.00 1,609,879.00 1,575,179.00 34,700.00 2.16%
Human Resources 4,900,512.00 5,053,129.60 5,253,129.60 (200,000.00) -3.96%
Health and Human Services 60,872,712.00 61,454,953.24 62,897,392.24 (1,442,439.00) -2.35%
Public Services 16,137,611.00 16,333,007.83 16,313,007.83 20,000.00 0.12%
Economic Dev. and Comm Affairs 6,900,849.00 7,579,726.89 7,512,026.89 6770 . . .._„ _. . . ,0.00 . . . . . . .. .. .. . . 0.89%
TOTAL COUNTY EXECUTIVE $ 121,845,479.00 $ 124,015,054.36 $ 125,305,093.36 $ (1,290,039.00) -1.04%
TOTAL DEPARTMENTS $ 363,541,559.00 $ 368,355,478.13 $ 371,310,817.13 $ (2,955,339.00) -0.80%
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NON-DEPARTMENTALS $ 127,773,812.00 $ 128,893,985.91 $ 128,893,985.91 0.00%
TOTAL GOVERNMENTAL EXPENDITURES $ 491,315,371.00 $ 497,249,464.04 $ 500,204,803.04 $ (2,955,339.00) -0.59%
General Fund/General Purpose
Favorable/(Unfavorable) $ 12,406,201.00 $ 12,406,201.00
(1) Note that report forecasts Planned Use of Fund Balance with a zero variance in order to show a balanced budget. No revenue will actually be received.
Property Taxes - Tax Acceleration
Other Taxes - Delinquent Tax - Prior Years
Treasurer Payment in Lieu of Taxes
80,239,199.00
(891,500.00)
101,500.00
Total Taxes $ 330,988,400.00
Other Taxes - Trailer Tax
FEDERAL GRANTS (610000-610999)
Sheriff - Patrol
Sheriff - Corrective Services
County Executive - ERP
Health Division
Children's Village
Total Federal Grants
STATE GRANTS (615000-615999)
Sheriff - Patrol
County Executive - ERP
68,000.00 $
82,000.00
49,000.00
120,075.00
245,000.00
564,075.00 $
- $
68,000.00 $
82,000.00
49,000.00
75,300.00
245,000.00
519,300.00 $
12,000.00 $
(110,000.00)
(110,000.00)
(20,000.00)
(20,000.00)
18,296.00
68,000.00
82,000.00
49,000.00
55,300.00
245,000.00
499,300.00 $
12,000.00
18,296.00
SPECIAL ASSESSMENTS (605000-605999)
Payment in Lieu of Assessments-Treasurers
Total Treasurers Office
110,000.00 $ 110,000.00 $
110,000.00 $ 110,000.00
4,490,995.00
11,563,500.00
16,066,495.00
9,118,000.00
9,118,000.00
1,544,000.00
$ 1,562,296.00
67,500.00
530,000.00 150,000.00
67,500.00 $
380,000.00
INTERGOV'T PROGRAM REV. (625000-626999)
County Executive 67,500.00 $
Public Services - Community Corrections 380,000.00
0.00%
39.47% Fav.Testing Fee revenues as a result of the referral of former clients back into the
program. Increased revenue of $150.000 more than offsets the increase in
expenditures of $20,000.*
0
0
(80,000.00)
70,000.00
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FY 2007 FIRST QUARTER REPORT
Adopted
Budget
Amount
Amended FY 2007 Favorable
Budget FORECAST (unfavorable) Percent Explanation of Significant Variances
TAXES (601000-601999)
Property Taxes - 2006 Tax Levy 2.90% Revised estimate based on update tax base. Original projection for July collection
was base on April 2006 value and should have been based on April 2007 base.
$ 251,539,201.00 $ 251,539,201.00 $ 258,839,201.00 $ 7,300,000.00
86,239,199.00
(891,500.00)
110,000.00
101,500.00 101,500.00
$ 330,988,400.00 $ 344,398,400.00
6,000,000.00 7.48% Estimate is calculated with update tax base.
0.00%
110,000.00 #DIV/0! A budget amendment is recommended to reflect actual collection which was
budgeted under Special Assessments.
0.00%
13,410,000.00 4.05%
80,239,199.00
(891,500.00)
-100.00% A budget amendment is recommended to reflect actual collection which is posted in
Taxes.
-100.00%
0.00%
0.00%
0.00%
-26.56% (Unfav.) due to reduced activity for well operator certification.
0.00%
-3.85%
0.00%
fiDIV/0! Fav. for the submittal of updated plans based on local communities right-to-know on
extremely hazardous substances in local communities. The purpose is for
enhancing hazardous material response planning. (HMPG) Hazardous Materials
Planning Grant.
Health Division
Outside Agencies - Child Care Subsidy
Total State Grants $
INTERGOV'T GEN. REIMB. REV. (620000-620999)
Non-Departmental
Total Intergov't Gen. Reimb. Rev.
4,492,090.00
11,401,000.00
15,893,090.00 $
9,118,000.00 $
9,118,000.00 $
4,490,995.00
13,107,500.00
$ 17,628,791.00
$ 9,118,000.00
$ 9,118,000.00
0.00%
13.35% Revenue is based on increased expenditures and current reimbursement formula.
9.72%
0.00%
0.00%
Circuit Court
District Court
Sheriff
Non-Departmental
Total intergov't Program Rev.
4,500.00 4,500.00
2,850.00 2,850.00
300,000.00 300,000.00
2,040,700.00 2,040,700.00
$ 2,795,550.00 $ 2,795,550.00 $
4,500.00
2,850.00
300,000.00
1,960,700.00
2,865,550.00
0.00%
0.00%
0.00%
-3.92% Based on current reimbursement for Circuit, District and Probate judges.
2.50%
" Revenue variance is partially offset by an expenditure variance.
CHARGES FOR SERVICES (630000-635999)
Administration of Justice
Circuit Court - Civil/Criminal
Circuit Court - Family Division
$ 3,317,690.00 $ 3,317,690.00 $ 3,426,990.00 $ 109,300.00
1,700,050.00 1,700,050.00 1,778,650.00 78,600.00
District Court - Division I
District Court - Division II
District Court - Division III
District Court - Division IV
Probate Court - Judicial Support
4,106,570.00 4,106,570.00 4,078,570.00
2,297,900.00 2,297,900.00 2,297,900.00
4,407,876.00 4,407,876.00 4,407,876.00
2,282,510.00 2,282,510.00 2,282,510.00
540,300.00 540,300.00 561,700.00
(28,000.00)
21,400.00
Total Administration of Justice
Law Enforcement
Prosecuting Attorney
18,652,896.00 $ 18,652,896.00 $ 18,834,196.00 $ 181,300.00
215,900.00 $ 215,900.00 $ 212,800.00 $ (3,100.00)
8,000.00 8,000.00 8.000.00 0.00%
31,800.00 31,800.00 73,800.00 42,000.00 132.08% Payment by State of Michigan to cover a portion of the Blind and Physically
Handicapped Library operations.
General Government
Clerk - County Clerk
Clerk - Elections
Clerk - Register of Deeds
Treasurer
Board of Commissioners
Library Board
Unfav Industrial Facilities Tax of ($635,900) due to Board of Review legislative
changes in assessment amount, and expired certification, assessments are set at
local level contingent upon number assessments issued which have been
decreasing in the last three yrs., TIFA/DDA Recovery Ad Valorem of ($117,300) due
to slowing of new industrial development in OC, assessments are controlled at the
local level; and Alternate Energy receipts of ($6,400) due to decrease in capture
amount, assessed by local authority to attract energy conservation Industries.
$ 2,627,420.00 $ 2,627,920.00 $ 2,627,920.00 $
196,475.00 197,000.00 197,000.00
14,678,000.00 14,678,000.00 14,678,000.00
3,897,980.00 3,897,980.00 3,138,380.00
0.00%
0.00%
- 0.00%
(759,600.00) -19.49%
COUNTY OF OAKLAND
GENERAL FUND! GENERAL PURPOSE REVENUES
FY 2007 FIRST QUARTER REPORT
Adopted
Budget
Amended
Budget
FY 2007
FORECAST
Amount
Favorable
(unfavorable) Percent Explanation of Significant Variances
3.29% Fav increase in Refund Fees PD Defense Atty. Fees reflective of Increased usage of
court appointed attorneys, and better collections, partially offset by increase expense
for Defense Atty Fees.
4.62% Fay increase in Refund Fees PD Defense Atty. Fees of $26,800 reflective of
increased usage of court appointed attorneys, and better collections, partially offset
by increase expense for Defense Atty Fees; and favorable Board and Care revenue
of $51,800 reflective of better collection efforts, and increased number of kids
ordered wards of the County.
-0.68% Unfav due to over assessment of Sobriety Court Cost fee revenue, rate recently
increased but number of cases is less than anticipated.
0.00%
0.00%
0.00%
3.96% Fav increase In Refund Fees PD Defense Atty. Fees of $10,000 reflective of
increased usage of court appointed attorneys, and better collections, partially offset
by increase expense for Defense Ally Fees; and favorable Certified Copy revenue of
$15,000 reflective of increase request for certified document copies; plus smaller
favorable variance of $400 in Foreign Letters Ancillary fees, Marriage Ceremony
fees, and CVR County Portion revenues; this was partially offset by unfavorable
Miscellaneous Petitions of ($4,000) which has declined in recent years.
-1.44% Unfav Welfare Fraud Case Review due to reduction in cases referred by the State
2368.42% Collection of Social Security incentive payments for eligible inmates.
0.00%
0.00%
0.00%
0.00%
0.45% Reimbursement of Salaries
0.00%
Sheriff's Office
Sheriff - Administrative Services
Sheriff - Corrective Services
Sheriff - Corrective Services Satellites
Sheriff - Emer. Prep. Training & Communication
Sheriff - Patrol Services
Sheriff - Investigative Forensic Services
Total Law Enforcement
1,900.00 1,900.00
85,100.00 85,100.00
3,291,000.00 3,291,000.00
2,313,314.00 2,313,314.00
300,000.00 305,357.00
29,841,556.00 29,743,370.00
319,791.00 319,791.00
$ 36,368,561.00 $ 36,275,732.00
46,900.00 45,000.00
85,100.00
3,291,000.00
2,313,314.00
305,357.00
29,878,370.00 135,000.00
319,791.00
$ 36,452,632.00 $ 176,900.00
Revenue variance is partially offset by an expenditure variance.
Amount
Adopted Amended FY 2007 Favorable
Budget Budget FORECAST (unfavorable)
1,781,728.00 1,786,448.00 1,861,401.00 74,953.00 Drain Commissioner
Total General Government
County Executive
County Exec - Administration
County Exec - ERP
County Exec - Auditing
M&B - Purchasing Division
M&B - Equalization Division
M&B - Reimbursement
Central Services - Support Services
I 'Liman Resource
Human Services - Health Division
Human Services - Children's Village
50,150.00 50,150.00
2,452,768.00 2,476,918.00
349,500.00 349,500.00
185,700.00 185,700.00
18,800.00 18,800.00
2,570,879.00 2,570,879.00
2,574,587.00 2,574,587.00
50,150.00
2,476,918.00
349,500.00
185,700.00
18,800.00
2,570,879.00
3,040,609.00 466,022.00
$ 23,221,403.00 $ 23,227,148.00 $ 22,584,501.00 $ (642,647.00)
$ 201,500.00 $ 201,500.00 $
1,000.00 1,000.00
60,500.00 60,500.00
201,500.00
1,000.00
30,750.00 (29,750.00)
Public Services - Community Corrections
Public Services - MSU Extension
Public Services - Medical Examiner
Public Services - Animal Control
25,000.00
64,100.00
910,200.00
755,010.00
25,000.00
64,100.00
989,028.00
755,010.00
25,000.00
64,100.00
994,028.00
772,010.00
5,000.00
17,000.00
Economic Dev. & Comm. Affairs - Admin
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)
$ 1,417,500.00 $ 1,000,000.00 $
$ 1,417,500.00 $ 1,417,500.00 $ 1,000,000.00 $
$ 90,176,504.00 $ 90,192,398.00 $ 89,923,723.00 $
8,200,000.00 8,200,000.00 $ 8,200,000.00
(25,000.00)
433,272.00
(417,500.00)
(417,500.00)
(268,675.00)
Non-Departmental
Total Investment Income
5,000,000.00 5,000,000.00 5,000,000.00
$ 5,012,000.00 $ 5,012,000.00 $ 5,148,000.00 $ 136,000.00
136,450.00
1150,000.00
$ 10,516,144.00
$ 1,417,500.00
136,450.00
160,000.00
$ 10,619,122.00 $
136,450.00
135,000.00
11,052,394.00 $
INVESTMENT INCOME (655000-6559991
District Courts (Div. I - IV)
Clerk/Register of Deeds
10,000.00 $ 10,000.00 $ 10,000.00 $
2,000.00 2,000.00 138,000.00 136,000.00
COUNTY OF OAKLAND
GENERAL FUND! GENERAL PURPOSE REVENUES
FY 2007 FIRST QUARTER REPORT
Percent Explanation of Significant Variances
4.20% Unfav - Plat Service Fees ($3,500) decrease in business activity resulting in less
fees being collected. Fav - Reimb. General $575,045 and Unfav - Reimb. Salaries
($396,592) for a net favorable effect of $178,453 the result of charging out drain
equipment along with two additional administrative staff and a increase in the
amount to be allocated out by the Environmental unit. Unfav - Soil Erosion Fees
($100,000) decrease In building activity/permits due to downturn in housing market.
0.00%
0.00%
-49.17% (Unfav.) due to Community Development Block Grant (CDGB) no longer being
monitored. A budget amendment is recommended.
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
18.10% Favorable Child Care State Aid $516,022 offset by unfavorable expenditure in
Teachers Services and Expense due to one-time overlap of payment in fiscal year
and (Unfav) Out County Board and Care ($50,000) for revenue paid to O.C. for care
of juveniles who are wards of other counties not placed at C.V.
0.00%
0.00%
0.51% Fav. Cremation Approval Fees due to increased caseload.
2.25% Fav. Animal Sterilization Fees $12,000 reflects an increase in the number of animals
being sterilized. Fav. Pound Fees $5,000 due to an increase in animal count and
fees. Increased revenue of $17,000 more than offsets the increase of expenditures
of $10,000.*
0.00%
-15.63% Reduced Sale of Maps caused by housing market slowdown.
-29.45% A budget amendment is recommended to move sundry from "Charges for Services"
to "Other Revenue."
-29.45%
-0.30%
0.00%
0.00%
6800.00% Fav Interest on Investments income of $136,000 due to rising interest rates on
Investments.
0.00%
2.71%
* Revenue variance is partially offset by an expenditure variance.
21 333.00
21,333.00
0.00%
0.00%
COUNTY OF OAKLAND
GENERAL FUND GENERAL PURPOSE REVENUES
FY 2007 FIRST QUARTER REPORT
Adopted
Budget
Amended
Budget
FY 2007
FORECAST
Amount
Favorable
(unfavorable) Percent Explanation of Significant Variances
DTHER REVENUESA70000-695500)
Prosecuting Attorney
Sheriff Office
Donations - All departments
Treasurer
County Executive
Emergency Response and Preparedness
Support Services
Health Division
Children's Village
District Court
Public Services
Library Board Transfers
Non-Dept - Sundry
Animal Control Transfers
Economic Development Transfers
Treasurers' Transfers
Non-Dept - Transfers
Total Other Revenues
$ 135,500.00
53,309.00
32,000.00
1,000.00
5,000.00
4,300.00
27,209.00
2,352101.00
25 826 000 00
$ 28,436,419.00
$ 156,576.00
76,983.00
32,000.00
1,000.00
5,000.00
4,300.00
27,209.00
2,352,101 00
25,826,000.00
$ 28,481,169.00
$ 156,576.00
76,983.00
51,000.00
1,000.00
5,000.00
4,300.00
30,009 00
560,119.00
2,352,101.00
25,826,000.00
29,063,088.00 $
0.00%
0.00%
19,000.00 59.38% Recording of prior year revenue for reimbursement of Cemetery Road at Great Lake
National Cemetery
0.00%
#01V/01
0.00%
0,00%
100.00%
100.00%
100.00%
100.00%
2,800.00 10.29%
560,119.00 #0IV/0! Budgeted under Charges for Services: a budget amendment is recommended.
#DIVIOI
#DIV/0!
0.00%
0.00%
581,919.00 2.04%
PLANNED USE OF FUND BALANCE (665000-665999)
General Fund - Prior Years Balance
Total Planned Use of Fund Balance
$ 5,766,152.04
$ 5,766,152.04 $
5,766,152.04
5,766,152.04 $
$ 15,361,540.00 3.09% TOTAL GEN. FUND 1 GEN. PURPOSE REVENUE $ 491,315,371.00 $ 497,249,464.04 $ 512 611,004.04 $ 15,361,540.00 $ 497 249,464.04 $ 512,611,004.04
* Revenue variance is partially offset by an expenditure variance.
8,505,749.00 $
274,629.58
213,080.29
8,993,458.87 $
29,900.00
29,900.00
0.35% Turnover.
0.00%
0.00%
0.33%
0.00%
0.00%
0.00%
2.71% Turnover.
0.00%
0.00%
67,200.00
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
CIRCUIT COURT
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2007
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Judicial Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Business Division
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 8,413,930.00 $ 8,535,649.00 $
41,485.00 274,629.58
191,932.00 213,080.29
$ 8,647,347.00 $ 9,023,358.87 $
$ 2,075,008.00 $ 2,006,746.00 $ 2,006,746.00 $
30,642.00 30,691.00 30,691.00
277,973.00 284,406.32 284,406.32
$ 2,383,623.00 $ 2,321,843.32 $ 2,321,843.32 $ 0.00%
Civil / Criminal Division
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
$ 2,416,898.00 $ 2,484,052.00 $
5,695,893.00 5,696,008.89
2,152,198.00 2,198,577.20
3,852,035.00 3,884,887.00
2,416,852.00 $
5,696,008.89
2,198,577.20
3,884,887.00
Family Division/Juvenile Maint.
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
$ 14,117,024.00 $ 14,263,525.09 $ 14,196,325.09 $
$ 13,229,255.00 $ 13,241,478.00 $ 13,229,278.00 $
11,557,285.00 11,689,818.27 11,716,918.27
1,687,555.00 1,691,765.57 1,691,765.57
$ 26,474,095.00 $ 26,623,061.84 $ 26,637,961.84 $
$ 26,135,091.00 $ 26,267,925.00 $ 26,158,625.00 $
17,325,305.00 17,691,147.74 17,718,247.74
4,309,658.00 4,387,829.38 4,387,829.38
3,852,035.00 3,884,887.00 3,884,887.00
$ 51,622,089.00 $ 52,231,789.12 $ 52,149,589.12 $
67,200.00 0.47%
12,200.00
(27,100.00)
0.00%
(14,900.00) -0.06%
109,300.00 0.42%
(27,100.00) -0.15%
0.00%
82,200.00 0.16%
0.09% Turnover.
-0.23% Unfav due largely to Personal Mileage of ($17,500) in use of personal
autos for case work and other client service , ($5,800) of Workshops &
Meetings, ($10,100) Refund of Prior Years Revenues; partially offset by
Court Transcripts of $6,300.
* See related revenue offset. 2/27/2007
$ 1,724,318.00 $ 1,724,318.00 $ 1,703,718.00 $
638,430.00 616,575.00 622,375.00
20,600.00
(5,800.00)
285,007.52 285,007.52
vision 2 - Clarkston
ersonnel Expenditures
perating Expenditures
ternal Support Expenditures 226,360.00
1.19% - Turnover.
-0.94% - Unfav of ($5,700) due to rent increase per lease agreement, plus an increase
of ($100) for custodial services.
0.00%
0.00% -
0.00% -
0.00% -
tision 4 - Troy
ersonnel Expenditures
perating Expenditures
$ 2,374,733.00 $ 2,374,733.00 $ 2,372,533.00 $
520,590.00 520,856.00 522,556.00
2,200.00
(1,700.00)
iternal Support Expenditures 367,903.00 374,995.72 374,995.72
LAJUN I Y OF OAKLAND
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
DISTRICT COURT
AMOUNT
ADOPTED AMENDED FY 2007 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
I drict Court Administration
ersonnel Expenditures $ 63,717.00 $ 63,717.00 $ 63,717.00 $- 0.00% -
perating Expenditures 62,800.00 62,800.00 62,800.00 - 0.00%
ternal Support Expenditures - 0.00%
$ 126,517.00 $ 126,517.00 $ 126,517.00 $ 0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
rision 1 - Novi
ersonnel Expenditures
perating Expenditures
ternal Support Expenditures
Total Division 1 - Novi
$ 3,934,185.00 $ 3,934,185.00 $ 3,934,185.00 $
1,026,133.00 1,034,605.00 1,034,605.00
480,109.00 489,022.97 489,022.97
0.00% -
0.00% -
0.00%
$ 5,440,427.00 $ 5,457,812.97 $ 5,457,812.97 $ 0.00%
Total Division 2- Clarkston $ 2,589,108.00 $ 2,625,900.52 $ 2,611,100.52 $ 14,800.00 0.56%
tision 3 - Rochester Hills
ersonnet Expenditures
perating Expenditures
1ernal Support Expenditures
$ 3,791,337.00 $ 3,791,337.00 $ 3,791,337.00 $
416,288.00 425,238.32 425,238.32
1,190,671.00 1,198,683.19 1,198,683.19
$ 5,398,296.00 $ 5,415,258.51 $ 5,415,258.51 $ 0.00%
0.09% - Turnover.
-0.33% - Unfav due to charge card fees as more people pay fines and court cost by
charge cards; a budget amendment is recommended.
0.00%
$ 3.263,226.00 $ 3,270,584.72 $ 3,270,084.72 $ 500.00 0.02%
partment Total
ersonnel Expenditures $ 11,888,290.00 $ 11,888,290.00 $ 11,865,490.00 $ 22,800.00 0.19%
perating Expenditures 2,664,241.00 2,660,074.32 2,667,574.32 (7,500.00) -0.28%
ternal Support Expenditures 2,265,043.00 2,347,709.40 2,347,709.40 - 0.00%
0
$ 16,817,574.00 $ 16,896,073.72 $ 16,880,773.72 $ 15,300.00 0.09% 2/27/2007
Judicial/Administration
Personnel Expenditures
Operating Expenditures
Internal Support
Estates/Mental Health
Personnel Expenditures
Operating Expenditures
Internal Support
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support
AMOUNT
FY 2007 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT
$2,175,016.00 $ 70,600.00 3.14% - Turnover
7,752.00 0.00%
310,244.00 0.00% -
$2,493,012.00 $ 70,600.00 2.75%
$2,256,293.00 $ 30,100.00 1.32% - Turnover
851,099.99 0.00% -
551,497.89 0.00% -
$3,658,890.88 $ 30,100.00 0.82%
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
PROBATE COURT
ADOPTED
BUDGET
$2,245,616.00
310,244.00
$2,555,860.00
$2,237,908.00
846,150.00
545,439.00
$3,629,497.00
$4,483,524.00
846.150.00
855,683.00
-----------
$6,185,357.00
AMENDED
BUDGET
$2,245,616.00
7,752.00
310,244.00
$2,563,612.00
$2,286,393.00
851,099.99
551,497.89
$3,688,990.88
$4,532,009.00
858,851.99
861,741.89
------------
$6,252,602.88
$4,431,309.00
858,851.99
861,741.89
$6,151,902.88
$ 100,700.00 2.22%
0.00%
0.00%
.......... n
$ 100,700.00 1.61%
EXPLANATION OF SIGNIFICANT VARIANCES
2/27/2007
0.00%
0.00%
0.00%
0.00%
$ 1,617,969.00 $ 1,618,327.00 $ 1,618,327.00 $ 0.00%
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
PROSECUTING ATTORNEY
ADOPTED AMENDED FY 2007
BUDGET BUDGET FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
kc tinistration
P sonnet Expenditures
C arating Expenditures
4-nal Support Expenditures
T nsfers
$ 2,494,667.00 $ 2,494,667.00 $ 2,494,667.00
841,194.00 851,544.25 851,544.25
1,794,142.00 1,810,573.17 1,814,573.17 (4,000.00)
0.00%
0.00%
-0.22% Unfavorable Motor Pool due to the increased use of a daily rental to
deliver subpoenas for the Juvenile Division.
0.00%
$ 5,130,003.00 $ 5,156,784.42 $ 5,160,784.42 $ (4,000.00) -0.08%
it
Ir
ration
sonnet Expenditures
erating Expenditures
:rnal Support Expenditures
nsfers Out
rants
sonnet Expenditures
erating Expenditures
rnal Support Expenditures
$ 9,306,866.00 $ 9,306,866.00
49,824.00 52,272.00
4,326.00 4,326.00
783,694.00 981,474.00
---------------- ---------- ---------
$ 10,144,710.00 $ 10,344,938.00
$ 9,246,866.00 $ 60,000.00
52,272,00
4,326.00
981,474.00
$ 10,284,938.00 $ 60,000.00
0.64% Turnover
0.00%
0.00%
0.00%
0.58%
0.00%
0.00%
0.00%
$ 2,053,802.00 $ 2,053,802.00 $ 2,053,802.00
2,758.00 2,893.00 2,893.00
ellate
7 -sonnet Expenditures
= erating Expenditures
r !mai Support Expenditures
$ 2,056,560.00 $ 2,056,695.00 $ 2,056,695.00 $
$ 1,610,678.00 $ 1,610,678.00 $ 1,610,678.00
7,291.00 7,649.00 7,649.00
: artment
sonnet Expenditures
erating Expenditures
!mai Support Expenditures
nsfers Out
$ 15,466,013.00
901,067.00
1,798,468.00
783,694.00
$ 18,949,242.00
$ 15,466,013.00
914,358,25
1,814,899.17
981,474.00
$ 15,406,013.00 $
914,358.25
1,818,899.17
981,474.00
60,000.00
(4,000.00)
56,000.00 0.29% $ 19,176,744.42 $ 19,120,744.42 $
0.39%
0.00%
-0.22%
0.00%
2/27/2007
EXPLANATION OF SIGNIFICANT VARIANCES
AMENDED
BUDGET
ADOPTED
BUDGET
FY 2007
FORECAST
1,557,586.00 $
67,444.92
261,602.00
$ 1,568,586.00 $
65,916.00
261,602.00
1,568,586.00 $
67,444.92
261,602.00
$ 1,896,104.00 $ 1,897,632.92 $ 1,886,632.92 $
$ 1,666,893.00
526,224.00
327,234.00
$ 1,666,893.00 $ 1,631,893.00
549,142.68 549,142.68
327,234.00 327,234.00
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT
11,000.00 0.70% Favorable overtime and related fringe benefits.
0.00%
0.00%
11,000.00 0.58%
35,000.00 2.10% Favorable due to overtime and fringe benefits due to rate changes.
0.00%
0.00%
ieriff's Office
'ersonnel Expenditures
)perating Expenditures
iternal Support Expenditures
, ImInIstrative Services
'ersonnel Expenditures
)perating Expenditures
iternal Support Expenditures
)perating Expenditures
iternal Support Expenditures
transfers
6,646,999.00
7,381,239.00
6,656,962.98
7,549,753.11
6,656,962.98
7,549,753.11
0.00%
0.00%
0.00%
)perating Expenditures
lternal Support Expenditures
ran s fers
374,818.00
1,379,726.00
379,348.40
1,382,148.61
379,348.40
1,382,148.61
0.00%
0.00%
0.00%
•-• 4.• • s VI,I,s-4,41i
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
SHERIFF'S OFFICE
wrective Services
'ersonnel Expenditures
$ 2,520,351.00 $ 2,543,269.68 $ 2,508,269.68 $
29,466,329.00 $ 29,466,329.00 $ 31,398,329.00
35,000.00 1.38%
(1,932,000.00) -6.56% Overtime and related fringes to cover hospital watch, high prisoner population and
increased fringe benefit costs which were not budgeted.
nrective Services-Satellites
'ersonnel Expenditures
$ 43,494,567.00 $ 43,673,045.09 $ 45,605,045.09 $ (1,932,000.00) -4.42%
$ 17,155,517.00 $ 17,155,517.00 $ 18,385,517.00 $ (1,230,000.00) -7.17% Overtime and related fringes to cover hospital watch, high prisoner population and
increased fringe benefit costs which were not budgeted.
$ 18,910,061.00 $ 18,917,014.01 $ 20,147,014.01 $ (1,230,000.00) -6.50%
ttrol Services
'ersonnel Expenditures
)perating Expenditures
lternal Support Expenditures
I ransfers
$ 34,874,091.00
257,150.00
5,890,238.00
$ 34,794,273.00
267,696.02
5,904,383.10
$ 33,512,273.00 $
267,696.02
5,904,383.10
1,282,000.00 3.68% Turnover.
0.00%
0.00%
0.00%
$ 41,021,479.00 $ 40,966,352.12 $ 39,684,352.12 $ 1,282,000.00 3.13%
2/27/2007
4,468,663.00
95,421,354.00
8,689,505.00
17,726,292.00
4,112,674.00
128,000.00
227,989.00
$ 4,113,466.00
130,283.92
227,989.00
—ouNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
SHERIFF'S OFFICE
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2007
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$6,577,264
690,398.00
2,258,264.00
estigative & Forensic Serv.
ersonnel Expenditures
perating Expenditures
ternal Support Expenditures
ransfers
ersonnel Expenditures
perating Expenditures
tternal Support Expenditures
-ransfers
partment Total
F.z.rsonnel Expenditures
)erating Expenditures
ernal Support Expenditures
ansfer Out
$ 6,586,090.00 $ 7,130,090.00 $ (544,000.00) -8.26% Unfavorable due to overtime and related fringe benefits.
740,246.28 740,246.28 0.00%
2,258,359.57 2,258,359.57 0.00%
198,970.00 198,970.00 0.00%
---------
(544,000.00) -5.56%
$ 4,249,466.00 $ (136,000.00) -3.31% Unfavorable due to overtime and related fringe benefits.
130,283.92 0.00%
227,989.00 0.00%
0.00%
4,471,738.92 $ 4,607,738.92 $ (136,000.00) -3.04%
95,351,154.00 $ 97,865,154.00 $ (2,514,000.00) -2.64%
8,791,125.20 $ 8,791,125.20 0.00%
17,911,469.39 $ 17,911,469.39 0.00%
198,970.00 198,970.00 0.00%
$ 9,525,926.00 $ 9,783,665.85 $ 10,327,665.85 $
lergency Prep., Training & Comm.
$ 121,837,151.00 $ 122,252,718.59 $ 124,766,718.59 $ (2,514,000.00) -2.06%
:tions
ersonnel Expenditures
perating Expenditures
kernel Support Expenditures
ansfers
0.00%
0.00%
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
CLERK/REGISTER OF DEEDS
AMOUNT
ADOPTED AMENDED FY 2007 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
ninistration
'ersonnel Expenditures $ 709,561.00 $ 709,561.00 $ 709,561.00 $ - 0.00%
)perating Expenditures 53,350.00 53,359.00 53,359.00 - 0.00%
lternal Support Expenditures 216,505.00 227,463.35 227,463.35 - 0.00%
ransfers - 0.00%
$ 979,416.00 $ 990,383.35 $ 990,383.35 $ 0.00%
nity Clerk (Vital Stats & Legal Rec's)
'ersonnel Expenditures $ 3,293,093.00 $ 3,293,093.00 $ 3,293,093.00 $ - 0.00%
)perating Expenditures 297,408.00 310,203.00 310,203.00 - 0.00%
lternal Support Expenditures 600,588.00 854,572.00 854,572.00 - 0.00%
ransfers - - - - 0.00%
$ 4,191,089.00 $ 4,457,868.00 $ 4,457,868.00 $ 0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
$ 594,575.00 $ 594,575.00 $ 594,575.00 $ - 0.00%
759,888.00 914,727.35 612,427.35 302,300.00 33.05% Fay. Election Supplies line item due to lower unpaid balance owed on new
equipment in election room.
122,073.00 165,014.00 173,114.00 (8,100.00) -4.91% Unfav telephone usage to prepare for upcoming elections.
- - 0.00%
$ 1,476,536.00 $ 1,674,316.35 $ 1,380,116.35 $ 294,200.00 17.57%
ster of Deeds
rsonnel Expenditures $ 2,454,737.00 $ 2,454,737.00 $ 2,454,737.00 $ - 0.00%
erating Expenditures 1,209,827.00 1,209,836.00 909,536.00 300,300.00 24.82% Fay. Professional Services due to decrease in number of documents
recorded.
.rnal Support Expenditures
nsfers
1,352,257.00 1,370,639.20 1,370,639.20
$ 5,016,821.00 $ 5,035,212.20 $ 4,734,912.20 $ 300,300.00 5.96%
9/97onn7
ADOPTED
BUDGET
AMENDED
BUDGET
$ 128,898.00 $ 134,602.13 $ 134,602.13 $
$ 7,066,822.00 $ 7,066,822.00 $ 7,066,822.00 $
2,326,298.00 2,494,053,35 1,891,453.35
2,399,640,00 2,731,506.68 2,739,606.68
602,600.00
(8,100.00)
0.00%
0.00%
0.00%
0.00%
0.00%
24.16%
-0.30%
0,00%
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
CLERK/REGISTER OF DEEDS
AMOUNT
FY 2007 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Ji y Commission
'ersonnel Expenditures
)perating Expenditures
iternal Support Expenditures
o )artment Total
'ersonnel Expenditures
)perating Expenditures
lternal Support Expenditures
ransfers
$ 14,856.00 $ 14,856.00 $
5,825.00 5,928.00
108,217.00 113,818.13
14,856.00 $
5,928.00
113,818.13
$ 11,792,760.00 $ 12,292,382.03 $ 11,697,882.03 $ 594,500.00 4.84%
2/27/2007
0.00% -
0.00% -
0.00% -
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
COUNTY TREASURER
AMOUNT
ADOPTED AMENDED FY 2007 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures $ 2,816,946.00 $ 2,816,946.00 $ 2,816,946.00 $
Operating Expenditures 257,121.00 257,145.00 257,145.00
Internal Support Expenditure: 710,385.00 814,472.74 814,472.74
Division Total
Department Total
$ 3,784,452.00 $ 3,888,563.74 $ 3,888,563.74 $ 0.00%
$ 3,784,452.00 $ 3,888,563.74 $ 3,888,563.74 $ 0.00%
2/27/2007
ADOPTED
BUDGET
AMENDED
BUDGET
$ 2,924,820.00 $ 2,927,529.27 $ 2,927,529.27 $ 0.00%
$ 2,924,820 00 $ 2,927,529.27 $ 2,927,529.27 $ 0.00%
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
BOARD OF COMMISSIONERS
AMOUNT
FY 2007 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 2,229,228.00
434,148.00
261,444.00
$ 2,229,228.00 $ 2,229,228.00
435,709.00 435,709.00
262,592.27 262,592.27
0.00% -
0.00% -
0.00%
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 2,229,228.00
434,148.00
261,444.00
$ 2,229,228.00 $ 2,229,228.00 $
435,709.00 435,709.00
262,592.27 262,592.27
0.00%
0.00%
0.00%
2/27/2007
Library Board
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
LIBRARY BOARD
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2007 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 1,043,766.00 $ 1,043,766.00 $ 1,043,766.00
699,622.00 699,749.00 699,749.00
824,334.00 825,600.77 825,600.77
5,000.00 5,000.00 5,000.00
$ 2,572,722.00 $ 2,574,115.77 $ 2,574,115.77 $
$ 1,043,766.00 $ 1,043,766.00 $ 1,043,766.00 $
699,622.00 699,749.00 699,749.00
824,334.00 825,600.77 825,600.77
5,000.00 5,000.00 5,000.00
$ 2,572,722.00 $ 2,574,115.77 $ 2,574,115.77 $
2/27/2007
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
DRAIN COMMISSIONER
AMOUNT
ADOPTED AMENDED FY 2007 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
Drain Commissioner
Personnel $ 3,612,096.00 $ 3,626,012.00 $ 3,626,012.00 $- 0.00%
Operating 406,959.00 964,639.00 964,639.00 - 0.00%
Internal Support 1,134,693.00 1,201,088.23 1,201,088.23 - 0.00%
Transfers 56,165.00 56,165.00 56,165.00 - 0.00%
Total $ 5,209,913.00 $ 5,847,904.23 $ 5,847,904.23 $ 0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
Department Total $ 5,209,913.00 $ 5,847,904.23 $ 5,847,904.23 $ 0.00%
2/27/2007
$ 1,404,683.00 $ 1,470,978.75 $ 1,477,978.75 $ (7,000.00) -0.48%
$ 1,322,523.71 $ 130,000.00 8.95%
130,000.00 10.37% - Turnover
0.00%
0.00%
$ 1,123,692.00 $
27,291.00
171,540.71
50,000.00 2.17%
180,000.00 2.99%
0.00%
(7,000.00) -0.54%
173,000.00 2.17%
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
COUNTY EXECUTIVE
ministration
1:ontrollable Personnel
Is.ontrollable Operating
nternal Support Expenditures
ADOPTED
BUDGET
$ 2,025,904.00
223,373.00
468,874.00
AMENDED
BUDGET
$ 2,025,904.00
248,412.00
468,937.71
AMOUNT
FY 2007 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT
$ 2,025,904.00
248,412.00
468,937.71
0.00%
0.00%
0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
$ 2,718,151.00
E lergency Response & Preparedness
$ 2,743,253.71 $ 2,743,253.71 $ 0.00%
7;ontrollable Personnel
ontrollable Operating
nternal Support Expenditures
fransfers Out
$ 715,470.00 $
265,090.00
424,123.00
715,470.00 $
328,290.80
427,217.95
715,470.00
328,290.80
434,217.95
0.00%
0.00%
(7,000.00) -1.64% - (Unfav) Radio Communications.
I diting
I;ontrollable Personnel
ontrollable Operating
nternal Support Expenditures
C rporation Counsel
S.ontrollable Personnel
i:ontrollable Operating
nternal Support Expenditures
partment Total
3ontrollable Personnel
-f,ontrollable Operating
nternal Support Expenditures
fransfers Out
$ 1,253,692.00
27,130.00
171,172.00
$ 1,451,994.00
$ 2,018,313.00
49,893.00
214,159.00
$ 2,282,365.00
$ 6,013,379.00
565,486.00
1,278,328.00
0
$ 7,857,193.00
$ 1,253,692.00
27,291.00
171,540.71
$ 1,452,523.71
$ 2,018,313.00
58,768.25
222,850.02
$ 2,299,931.27
$ 6,013,379.00
662,762.05
1,290,546.39
0
$ 7,966,687.44
$ 1,968,313.00 $
58,768.25
222,850.02
$ 2,249,931.27 $
$ 5,833,379.00 $
662,762.05
1,297,546.39
0
$ 7,793,687.44 $
0
50,000 00 2.48% - Turnover
0.00%
0.00%
2/27/2007
ADOPTED
BUDGET
AMENDED
BUDGET
$ 1,121,082.00 $ 1,121,082.00 $ 1,121,082.00
46,323.00 46,410.00 46,410.00
133,199.00 133,199.00 133,199.00
$ 1,300,604 00 $ 1,300,691.00 $ 1,300,691.00 $
$ 6,953,316.00 $ 7,229,390.94 $ 7,229,390.94 $ 0.00%
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
MANAGEMENT AND BUDGET
$ 356,511.00 $ 356,511.00
8,588.00 8,646.00
8,438.00 8,438.00
Al ninistration
ersonnel Expenditures
Iperating Expenditures
iternal Support Expenditures
FY 2007
FORECAST
$ 356,511.00
8,646.00
8,438.00
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT
0.00%
0.00%
0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
$ 373,537.00 $ 373,595.00 $ 373,595.00 $ 0.00%
Pi chasing
ersonnel Expenditures
)perating Expenditures
iternal Support Expenditures
E( ialization
ersonnel Expenditures
/perating Expenditures
Iternal Support Expenditures
ransfers
Fl :al Services
ersonnel Expenditures
)perating Expenditures
iternal Support Expenditures
$ 7,497,844.00
229,742.00
1,524,618.00
$9,252,204.00
$ 5,452,287.00
138,240.00
1,362,789.00
$ 7,497,844.00 $ 7,440,844.00 $ 57,000.00
237,027.68 237,027.68
1,648,210.48 1,648,210.48
$9,383,082.16 $ 9,326,082.16 $57,000.00
$ 5,452,287.00 $ 5,452,287.00 $
138,351.00 138,351.00
1,638,752.94 1,638,752.94
0.00%
0.00%
0.00%
0.00%
0.76% Turnover
0.00%
0.00%
0.00%
0.61%
0.00%
0.00%
0.00%
2/27/2007
57,000.00
$ 20,859,881.00 $ 21,283,466.55 $ 21,226,466.55 $
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
MANAGEMENT AND BUDGET
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2007
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Ri mbursement
'ersonnel Expenditures
)perating Expenditures
Iternal Support Expenditures
ransfers
D. mrtment Total
'ersonnel Expenditures
)perating Expenditures
Iternal Support Expenditures
ransfers
$ 2,336,398.00
89,200.00
554,622.00
$ 2,980,220.00
$ 16,764,122.00
512,093.00
3,583,666.00
$ 2,336,398.00 $
89,204.00
571,105.45
$ 2,996,707.45 $
$ 16,764,122.00 $
519,638.68
3,999,705.87
2,336,398.00 $
89,204.00
571,105.45
2,996,707.45 $
16,707,122.00 $
519,638.68
3,999,705.87
0.00%
0.00%
0.00%
0.00%
0.34%
0.00%
0.00%
0.00%
57,000.00 0.27%
2/27/2007
0.00%
0.00%
0.00%
0.00%
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
CENTRAL SERVICES
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2007
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administrative
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 195,895.00 $
2,600.00
14,697.00
$ 213,192.00 $
195,895.00 $
2,604.00
15,082.68
213,581.68 $
195,895.00 $
2,604.00
15,082.68
213,581.68 $ 0.00%
0.00%
0.00%
0.00%
Support Services
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 1,216,033.00 $
38,515.00
1,239,219.00
1,216,033.00
40,375.00
1,264,214.13
$ 1,216,033.00 $
40,375.00
1,264,214.13
0.00%
0.00%
0.00%
0.00%
$ 2,493,767.00 $ 2,520,622.13 $ 2,520,622.13 $ 0.00%
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 1,411,928.00 $ 1,411,928.00 $
41,115.00 42,979.00
1,253,916.00 1,279,296.81
1,411,928.00 $
42,979.00
1,279,296.81
$ 2,706,959.00 $ 2,734,203.81 $ 2,734,203.81 $ 0.00%
2/26/2007
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
FACILITIES MANAGEMENT
AMOUNT
ADOPTED AMENDED FY 2007 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Facilities Engineering
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 375,465.00 $ 375,465.00 $ 375,465.00 0.00%
9,500.00 9,529.00 9,529.00 0.00%
41,508.00 41,508.00 41,508.00 0.00%
$ 426,473.00 $ 426,502.00 $ 426,502.00 $ - 0.00%
$ 980,101.00 $ 980,101.00 $ 945,401.00 $ 34,700.00 3.54% - Fav. Salaries and Fringe Benefits for productive time charged to the Airport
T-Hangar Capital Project.
116,600.00 116,688.00 116,688.00 0.00%
86,588.00 86,588 00 86,588.00 0.00%
$ 1,183,289.00 $ 1,183,377.00 $ 1,148,677.00 $ 34,700.00 2.93%
$ 1,355,566.00 $ 1,355,566.00 $ 1,320,866.00 $ 34,700.00 2.56%
126,100.00 126,217.00 126,217.00 - 0.00%
128,096.00 128,096.00 128,096.00 - 0.00%
$ 1,609,762.00 $ 1,609,879 00 $ 1,575,179.00 $ 34,700.00 2.16%
2/26/2007
Operating Expenditures 301,394.00 301,428.00 501,428.00
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
HUMAN RESOURCES
AMOUNT
ADOPTED AMENDED FY 2007 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
Administration
Personnel Expenditures $ 638,844.00 $ 638,844.00 $ 638,844.00 0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
(200,000.00) -66.35% Due to continued Sheriff Deputy union contract negotiations and anticipated ACT 312
hearing costs. A budget amendment is recommended. Funds are available within the
Designated Fund Balance for HR- Legal Services to offset the projected expense.
Internal Support Expenditures 6,333 00 6,772.21 6,772.21 0.00%
$ 946,571.00 $ 947,044.21 $ 1,147,044.21 $ (200,000.00) -21.12%
Human Resources - General
Personnel Expenditures $ 1,472,587.00 $ 1,472,587.00 $ 1,472,587.00 0.00%
Operating Expenditures 194,947.00 226,243.20 226,243.20 0.00%
Internal Support Expenditures 500,491.00 621,279.19 621,279.19 0.00%
$ 2,168,025.00 $ 2,320,109.39 $ 2,320,109.39 $ - 0.00%
Compensation & Benefits
Personnel Expenditures $ 1,355,300.00 $ 1,355,300.00 $ 1,355,300.00 0.00%
Operating Expenditures 225,954.00 226,014.00 226,014.00 0.00%
Internal Support Expenditures 204,662.00 204,662.00 204,662.00 0.00%
$ 1,785,916.00 $ 1,785,976.00 $ 1,785,976.00 $ 0.00%
Department Total
Personnel Expenditures $ 3,466,731.00 $ 3,466,731.00 $ 3,466,731.00 $ - 0.00%
Operating Expenditures 722,295.00 753,685.20 953,685.20 (200,000.00) -26.54%
Internal Support Expenditures 711,486.00 832,713.40 832,713.40 - 0.00%
$ 4,900,512.00 $ 5,053,129.60 $ 5,253,129.60 $ (200,000.00) -3.96%
2/27/2007
C Idren's Village
'ersonnel Expenditures
lperating Expenditures
k•tar_ril I r vr lAHML-A1811J
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
HEALTH AND HUMAN SERVICES
AMOUNT
ADOPTED AMENDED FY 2007 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
A ninistration
'ersonnel Expenditures
iperating Expenditures
$ 201,148.00 $ 201,148.00 $ 201,148.00 0.00%
(1,546,167.00) -16.07% (Unfavorability) projected for Independent Living ($250,000),
Private Institutions Residential ($496,167) and Foster Care
($800,000). The costs incurred are for the care of neglected
and abused wards of the court and payment is state
mandated. Costs are based on caseload, difficutly of care and
treatment of services (Counseling, drug screening etc.)
ordered by the Court. A budget amendment is
- recommended.
9,612,646.00 9,620,191.00 11,166,358.00
Iternal Support Expenditures
ransfers Out
6,872.00 6,872.00 6,872.00 0.00%
H tRh
'ersonnel Expenditures
/perating Expenditures
iternal Support Expenditures
$ 9,820,666.00 $ 9,828,211.00 $ 11,374,378.00 $ (1,546,167.00) -15.73%
$ 25,037,810.00 $ 25,037,810.00 $ 24,287,810.00 $ 750,000.00 3.00% - Turnover
4,741,747.00 4,929,462.23 4,929,462.23 0.00%
3,231,261.00 3,555,531.67 3,555,531.67 0.00%
$ 33,010,818.00 $33,522,803.90 $ 32,772,803.90 $ 750,000.00 2.24%
$ 12,290,491.00 $ 12,290,491.00 (10,000.00) -0.08% (Unfav) due to Children's Village maintaining state mandated
$ 12,300,491.00 - ratio of staff to
residents at all times.
$ 3,515,304.00 3,557,851.33 4,194,123.33 (636,272.00) -17.88% (Unfav) Teachers Services and Expense due to payment of
- prior year expense. See Revenue offset*.
iternal Support Expenditures 2,235,433.00 2,255,596.01 2,255,596.01 0.00%
$ 18,041,228.00 $ 18,103,938.34 $ 18,750,210.34 $ (646,272.00) -3.57%
D oartment Total
:ontrollable Personnel $ 37,529,449.00 $ 37,529,449.00 $ 36,789,449.00 $ 740,000.00 1.97%
:ontrollable Operating 17,869,697.00 18,107,504.56 20,289,943.56 (2,182,439.00) -12.05%
Ion-Controllable Operating 5,473,566.00 5,817,999.68 5,817,999.68 0.00%
- 100.00%
CY, $ 60,872,712.00 $ 61,454,953.24 $ 62,897,392.24 $ (1,442,439.00) -2.35%
2/27/2007
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
PUBLIC SERVICES
AMOUNT
ADOPTED AMENDED FY 2007 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
F iblic Services - Admin.
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 179,518.00 $ 179,518.00 $ 179,518.00
4,800.00 4,800.00 4,800.00
6,157.00 6,157.00 6,157.00
0.00%
0.00%
0.00%
$ 190,475.00 $ 190,475.00 $ 190,475.00 $ 0.00%
15,000.00
1 terans' Services
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 1,595,750.00 $ 1,595,750.00
213,550.00 218,109.00
243,488.00 243,645.81
1,580,750.00 $
218,109.00
243,645.81
0.94% - Turnover
0.00%
0.00%
0.00%
$ 2,052,788.00 $ 2,057,504.81 $ 2,042,504.81 $ 15,000.00 0.73%
(20,000.00)
( )mmunity Corrections
Personnel Expenditures
Operating Expenditures
$ 3,337,041.00 $ 3,337,041.00 $ 3,337,041.00
823,622.00 824,475.96 844,475.96
574,690.06 574,690.06
0.00%
-2.43% - Unfav. Drug Testing ($20,000) offset by Fay. Testing revenues
of $150,000.*
0.00%
0.00%
Internal Support Expenditures 523,145.00
Transfers
$ 4,683,808.00 $ 4,736,207.02 $ 4,756,207.02 $ (20,000.00) -0.42%
I' ill Ext. - Oakland County
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 774,766.00 $ 774,766.00 $ 774,766.00
87,853.00 88,172.00 88,172.00
339,845.00 342,320.54 342,320.54
0.00%
0.00%
0.00%
$ 1,202,464.00 $ 1,205,258.54 $ 1,205,258.54 $ 0.00%.
S-) CT)
" See related revenue offset. 2/27/2007
iimal Control
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
PUBLIC SERVICES
AMOUNT
ADOPTED AMENDED FY 2007 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
15,000.00
I adical Examiner
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 3,417,937.00 $ 3,496,765.00 $ 3,481,765.00 $
633,010.00 633,421.64 633,421.64
760,683.00 788,747.47 788,747.47
0.43% - Turnover
0.00%
0.00%
$ 4,811,630.00 $ 4,918,934.11 $ 4,903,934.11 $ 15,000.00 0.30%
$ 1,754,363.00 $ 1,754,363.00 $ 1,734,363.00 $ 20,000.00 1.14% - Turnover
133,893.00 133,907.00 143,907.00 (10,000.00) -7.47% Unfav. Due to an increase in sterilization and medical needs
offset by Fav. Animal Sterilization Fees of $12,000.*
514,219.00 540,699.85 540,699.85 0.00%
$ 2,402,475.00 $ 2,428,969.85 $ 2,418,969.85 $ 10,000.00 0.41%
rcuit Court Probation
Personnel Expenditures $ - $ - $ - 0.00%
Operating Expenditures 44,838.00 44,925.00 44,925.00 0.00%
Internal Support Expenditures 749,133.00 750,733.50 750,733.50 0.00%
$ 793,971.00 $ 795,658.50 $ 795,658.50 $ 0.00%
I ?partment Total
Personnel Expenditures $ 11,059,375.00 $ 11,138,203.00 $11,088,203.00 $ 50,000.00 0.45%
Operating Expenditures 1,941,566.00 1,947,810.60 1,977,810.60 (30,000.00) -1.54%
Internal Support Expenditures 3,136,670.00 3,246,994.23 3,246,994.23 0.00%
Transfers
$ 16,137,611.00 $ 16,333,007.83 $16,313,007.83 $ 20,000.00 0.12%
See related revenue offset. 2/27/2007
$ 3,453,172.00
1,281,847.94
35,000.00
20,000.00
-3.24% - Unfav. Print Shop ($20,000) due to greater utilization of Print
Shop for division's printing requirements and unfav.
Telephone Communications ($6,500) due to increased
economic development activities.
(26,500.00)
---------
28,500.00 0.51%
- $ - $
$ 25,620.00 $ 0.00%
$ 4,752,748.00
1,747,229.98
1,012,048.91
74,200.00 1.54%
20,000.00 1.13%
(26,500.00) -2.69%
0.00%
00
$ 6,900,849.00 $ 7,579,726.89 $ 7,512,026.89 $ 67,700.00 0.89%
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2007 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
ninistration
ersonnel Expenditures
perating Expenditures
$ 1,313,156.00 $ 1,313,156.00 $ 1,273,956.00 $
463,434.00 465,382.04 465,382.04
39,200.00 2.99% - Turnover.
0.00%
Iternal Support Expenditures 127,843.00 168,575.70 168,575.70 0.00%
$ 1,904,433.00 $ 1,947,113.74
' nning and Economic Development Services
$ 1,907,913.74 $ 39,200.00 2.01%
ersonnel Expenditures
perating Expenditures
$ 3,488,172.00 $ 3,488,172.00
713,775.00 1,301,847.94
1.00% - Turnover.
1.54% - Fav. Outside Printing due to increased utilization of the County's
Print Shop.
Iternal Support Expenditures 768,849.00
$ 4,970,796.00 $ 5,606,993.15 $ 5,578,493.15 $
: Timunity and Home Improvement
ersonnel Expenditures
perating Expenditures
ransfers
816,973.21 843,473.21
rkforce Development
ersonnel Expenditures
perating Expenditures
iternal Support Expenditures
$ 25,620.00 $ 25,620.00 $ 25,620.00 $ 0.00% -
$ 25,620.00 $ 25,620.00
3artment Total
ersonnel Expenditures $ 4,826,948.00 $ 4,826,948.00
perating Expenditures 1,177,209.00 1,767,229.98
rternal Support Expenditures 896,692.00 985,548.91
ransfers
* See related revenue offset. 2/27/2007
FY 2007 FIRST QUARTER REPORT
EXPENDITURES
NON-DEPARTMENTAL
BUDGET BUDGET AMOUNT
AS AS FY 2007 FAVORABLE
ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT EXPLANATION
I g-DEPARTARTMENT APPROPRIATIONS r
: JNTY OPERATIONS
:ounty Expenditures
Insurance Fund $ 256,844.00 $ 256,844.00 $ 256,844.00 0.00%
Insurance Surety Bonds 16,900.00 16,900.00 16,900.00 0.00%
Road Commission\Current Drain Assessment 1,306,536.00 1,306,536.00 1,306,536.00 0.00%
Road Commission\Tri Party Agreement 1,553,333.00 3,500,000.00 3,500,000.00 0.00%
Senior Citizen Prescriptions 150,000.00 150,000.00 150,000.00 0.00%
Equipment - 400,000.00 400,000.00 0.00%
Transfer to CMHA 9,620,616.00 9,620,616.00 9,620,616.00 0.00%
Total $ 12,904,229.00 $ 15,250,896.00 $ 15,250,896.00 $- 0.00%
JNTY BUILDINGS $ 3,325,393.00 $ 3,142,340.67 $ 3,142,340.67 0.00%
; 1TE AND FEDERAL - COUNTY ASSOCIATIONS
'a Wide Water Quality $ 55,000.00 $ 55,000.00 $ 55,000.00 0.00%
a i0C of Metro Sewage Agencies 1,700.00 1,700.00 1,700.00 0.00%
1 higan Assoc. of Counties 70,700.00 70,700.00 70,700.00 0.00%
N .ional Assoc. of Counties 24,000.00 24,000.00 24,000.00 0.00% -
E :.M.C.O.G. 579,000.00 579,000.00 579,000.00 0.00%
I ffic Improvement Association 30,000.00 30,000.00 30,000.00 0.00%
Total $ 760,400.00 $ 760,400.00 $ 760,400.00 - 0.00%
,IDRY EXPENSE $ 300,000.00 $ 300,000.00 $ 300,000.00 0.00%
t ;ERVED FOR TRANSFERS
xpenditures
Administrative Leave $ (300,000.00) $ (300,000.00) $ (300,000.00) 0.00% Offsetting favorability appears within departments.
Basic Readjustment 351,220.00 351,220.00 351,220.00 $- 0.00% Pending review of internal service fund rates.
Budget Task - - - #DIV/0! -
Classification and Rate Change 349,452.00 328,779.00 328,779.00 0.00%
Contingency 339,158.00 308,313.00 308,313.00 0.00%
Emergency Salaries 1,305,500.00 1,625,500.00 1,625,500.00 0.00%
Grant Match 2,954,771.00 2,419,585.00 2,419,585.00 0.00%
Info Tech Development 6,033,819.00 4,314,405.24 4,314,405.24 0.00%
Legislative Expense 180,500.00 180,500.00 180,500.00 0.00% -
Misc. Capital Outlay 75,000.00 67,677.00 67,677.00 0.00%
Overtime Appropriation 53,000.00 53,000.00 53,000.00 0.00%
Workshops and Meetings 4,000.00 4,000.00 4,000.00 0.00%
Salary Adjustment 0.00 0.00 - #DIV/Ol
Summer Employees Salary Appropriation 376,500.00 376,500.00 376,500.00 0.00% iv co Total $ 11,722,920.00 $ 9,729,479.24 $ 9,729,479.24 $ 0.00%
90.xls 2/27/2007
EXPENDITURES
NON-DEPARTMENTAL
BUDGET BUDGET AMOUNT
AS AS FY 2007 FAVORABLE
ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT EXPLANATION
-ransfers to Other Funds
tevenue Sharing Reserve Fund 75,861,063.00 75,861,063.00
all Population Management Fund 1,198,475.00 1,198,475.00
;apital & Cooperative Initiatives Revolving Fund 13,865,879.00 13,865,879.00
)ebt Service - West Wing Refunding 1,463,763.00 1,463,763.00
)ebt Service - Computer Center Refunding 1,082,463.00 1,082,463.00
Iroject Work Order Fund 400,000.00 400,000.00
'ire Records Management 401,940.00 501,940.00
tadio Communications 0.00 250,000.00
;LEMIS 1,619,000.00 1,619,000.00
itedical Care Facility 2,812,587.00 2,812,587.00
Vork Release/Jail Mgmt Project 0.00 600,000.00
)akland Enhancement 55,700.00 55,700.00
Total $ 98,760,870.00 $ 99,710,870.00
$ 75,861,063.00 0.00%
1,198,475.00 0.00%
13,865,879.00 0.00%
1,463,763.00 0,00%
1,082,463.00 0.00%
400,000.00 0.00%
501,940.00 0.00%
250,000.00 0.00%
1,619,000.00 0.00%
2,812,587.00 0.00%
600,000.00 0.00%
55,700.00 -
$ 99,710,870.00 $ 0.00%
Ti 'AL NON-DEPT. APPROPRIATIONS
TI 1NSFER TO GENERAL PURPOSE FUNDS
I blic Health Fund
, venile Maintenance Fund
cial Welfare Fund
TOTAL EXPENDITURES
$ 127,773,812.00 $ 128,893,985.91 $ 128,893,985.91 $ 0.00%
$ 25,827,774.00 $ 26,284,088.99 $ 26,284,088.99
21,747,997.00 21,931,325.01 21,931,325.01
1,000.00 1,000.00 1,000.00
$47,576,771.00 $48,216,414.00 $48,216,414.00 $
$ 175,350,583.00 $ 177,110,399.91 $ 177,110,399.91 $ 0.00%
0.00%
0.00%
0.00%
0.00%
90.xls 2/27/2007
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS
SHERIFF'S OFFICE
ADOPTED AMENDED FY 2007 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
••n•• n•••••n•n•n••••
I RIFF AVIATION #68000
1 .RATING REVENUES:
utside Revenue $0.00 $0.00 $0.00 $0.00 0.00%
Iside Revenue $ 1,823,443.00 $ 1,823,443.00 $ 1,823,443.00 $ - 0.00% -
Total Revenue $1,823,443.00 $1,823,443.00 $1,823,443.00 $ - 0.00%
11 :RATING EXPENSES $1,385,943.00 $1,385,943.00 $1,385,943.00 $ - 0.00% -
'I INCOME (LOSS) BEFORE
/I .RATING TRANSFERS $437,500.00 $437,500.00 $437,500.00 $ - 0.00%
I( J-OPERATING REVENUE $0.00 $0.00 0.00 $ - 0.00%
)1 :RATING TRANSFERS IN $0.00 $0.00 $0.00 $ - 0.00%
II REVENUES OVER(UNDER)
:XPENSES $437,500.00 $437,500.00 $437,500.00 $ 0.00%
c 1 Net Assets - Beginning
1 Net Assets - Ending
$2,376,599.56
$2,814,099.56
CO
2/28/2007
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
ENTERPRISE FUNDS
SHERIFF'S DEPARTMENT
ADOPTED AMENDED FY 2007 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
L INMATE COMMISSARY FUND
Moo)
: ERATING REVENUE $1,447,411.00 $1,447,411.00 $1,500,000.00 ($19,000.00) -1.31% - Increased Sales.
: ERATING EXPENSE $1,447,411.00 $1,447,411.00 $1,475,000.00 $50,000.00 3.45% - Increased Sales.
\ T OPERATING INCOME (LOSS) $0.00 $0.00 $25,000.00 $31,000.00 #DIV/0! 1
N-OPERATING REVENUE (EXPENSE) $ 5,000.00 #DIV/0! Increased investment base and increased interest rates.
I FAL INCOME BEFORE
: NTRIBUTIONS AND TRANSFERS $0.00 $0.00 $ 30,000.00 $31,000.00
. NSFER OUT 0.00 0.00 0.00
: ,ITAL CONTRIBUTION 0.00 0.00 0.00
FAL NET INCOME (LOSS) $0.00 , $0.00 , $30,000.00 , $31,000.00
rAL NET ASSETS - BEGINNING $ 55,270.32
TAL NET ASSETS - ENDING $85,270.32
#DIV/0!
0
2/28/2007
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
INTERNAL SERVICE FUND
CLERK/REGISTER OF DEEDS
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2007
FORECAST
VARIANCE
FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
'MICROGRAPHICS FUND (#65400)1
REVENUES
Outside
Inside
Total Revenues
OPERATING EXPENSES
NET NON-OPERATING REV
REVENUE OVER (UNDER)
EXPENDITURES
$7,500.00 $7,500.00 $95,000.00 $87,500.00
896,058.00 896,178.00 613,530.00 (282,648.00)
$903,558.00 $903,678.00 $708,530.00 ($195,148.00)
964,002.00 964,002.00 1,020,802.00 (56,800.00)
42,872.00 42,872.00 43,872.00 1,000.00
($17,572.00) ($17,452.00) ($268.400.00) ($250,948.00)
1166.67% - Favorable External Laminating and Photostats due to new agreements with
the Road Commission who purchases laminated documents.
-31.54% - Unfavorable internal Copier Charges, Laminating, Microfilming, and
Photostats due to a decrease in anticipated volume from county
departments.
-5.89% - Unfavorable due to delay in elimination of part-time clerical staff (Pos.
#09843, 09844, 09845 and 09846); partially offset by favorable Indirect
Cost allocation.
2.33% - Favorable due to the continued gradual increase in interest rates.
Total Net Assets - Beginning
Total Net Assets - Ending
Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" in the revenue category.
$388,820.28
$120,420.28
MICROGRAPHICS.xls 2/28/2007
$13,131,317.00 $13,131,317.00 $20,028,217.00
3,200,000.00 3,200,000.00 3,200,000.00
2,100,000.00 2,100,000.00 2,100,000.00
1,500,000.00 1,500,000.00 1,500,000.00
1,900,000.00 1,900,000.00 1,900,000.00
1,900,000.00 1,900,000.00 1,900,000.00
1,400,000.00 1,400.000.00 1,400,000.00
12,000,000.00 12,000,000.00 12,000,000.00
$ 13,131,317.00 $ 13,131,317.00 $ 13,142,517.00
[ RF FUND 51600
i'VENUES
2.harges for Services
Dther Revenues
Total Revenues $6,896,900.00 52.52%
DERATING EXPENSES
Administrative Expenses
Indirect Costs
Transfer Out to Other Funds:
General Fund - Collection Fees
GE Other
RCOC Tr-Party Agreement
Work Release Facility Debt Svc
Office Bldg Renovation Debt Svc
52-3 District Court Debt Service
Total Transfer Out to Other Funds
ital Operating Expenses
0.00 0.00%
0.00 0.00%
0.00 0.00%
0.00 0.00%
0.00 0.00%
0.00 0.00%
0.00 0.00%
$ (11,200.00)
$ 581,317.00 $ 581,317.00 $ 592,517.00 $ (11,200.00) -1.93% Unfav. ($11,200) due to Info-Tech Development, not budgeted.
550,000.00 550,000.00 550,000.00 0.00 0.00%
$10,500,000.00
2,631,317.00
$10,500,000.00
2,631,317.00
$11,700,000.00
8,328,217.00
11.43% Fay. Collection Fees due to increased volume of collections.
216.50% Fay. due to Income From Investments, Interest Credited, Interest
Accrued, and Prior Years Adjustments of $5,696,900 due to increasing
ROI reflective of rising interest rates on investments, and other interest
and revenues credited.
$1,200,000.00
5,696,900.00
LAJt.111 I I WAMI-P111L/
FY 2007 FIRST QUARTER REPORT
DELINQUENT TAX REVOLVING FUND
ENTERPRISE FUND
TREASURERS OFFICE
ADOPTED AMENDED FY 2007 VARIANCE
BUDGET BUDGET ACTUAL FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
EVE NUE OVER (UNDER)
EXPENDITURES $0.00 $0.00 $6,885,700.00 $6,885,700.00
)tal Net Assets - Beginning $205,358,390.60
tel Net Assets - Ending $212,244,090.60
)ding FY 2006 Designated Fund Balance:
Designated - Debt Service $88,615,077.62
Designated - Projects 3,598,564.00
Designated - Delinq Taxes Receivable 104,809,207.25
Designated - Collection Fees 8,335,541.73
Undesignated - Fund Balance 6,885,700.00
dal Net Assets - Ending Augaiumg_
2/28/2007 DTRF #51600 Quarterly Forecast.xls
$ 16,331,873.00
$0.00
0.00
0.00
$0.00
0.00
0.00
$0.00
($487,936.00)
$0.00
$0.00
$0.00
-5.26%
0.00%
0.00%
0.00%
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
ENTERPRISE FUND
PARKS & RECREATION
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2007 VARIANCE
FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
AND COUNTY PARKS &
: ZEATION (50800)
RATING REVENUE
= RATING EXPENSE
OPERATING INCOME (LOSS)
1 -OPERATING REVENUE
; EN SE)
AL INCOME BEFORE
C TRIBUTIONS AND TRANSFERS
R \ISFER IN
P ITAL CONTRIBUTION
C 4L NET INCOME (LOSS)
C AL NET ASSETS - BEGINNING
C 4L NET ASSETS - ENDING
$9,277,316.00 $9,277,316.00 $9,277,316.00
$25,609,189.00 $25,609,189.00 $25,609,189.00
($16,331,873.00) ($16,331,873.00) ($16,331,873.00)
$ 16,331,873.00 $ 16,331,873.00
$0.00 $
0.00
0.00
$0.00
$ 81,412,330.82
$81,412,330.82
$0.00
0.00 0.00%
$0.00 0.00%
$0.00
CT
2/28/2007
Total Revenue
WERATING EXPENSES
IET INCOME (LOSS) BEFORE
ION-OPERATING REVENUE/(EXPENSE)
OTAL NET ASSETS - BEGINNING
OTAL NET ASSETS - ENDING
3,363,647.53
$3,299,881.53
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
INTERNAL SERVICE FUND
DRAIN COMMISSIONER
ADOPTED AMENDED FY 2007 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
iRAIN EQUIPMENT FUND ( 63900)
)PERATING REVENUES:
Inside $2,804,322.00 $2,804,322.00 $2,844,803.00 $40,481.00 1.44%
Outside 767,845.00 767,845.00 767,845.00 $0.00 0.00%
3,572,167.00 3,572,167.00 3,612,648.00 40,481.00 1.13%
3,660,305.00 3,660,305.00 3,768,397.00 (108,092.00) -2.95% Unfav - Equip. Repair Motor Vehicle ($34,000) for using outside vendor for
maintenance that inside mechanic is not certified to perform. Unfav - Interest
Expense ($10,281) for payment of interest on the loan for the construction of the new
Drain Equipment Storage Bldg. Unfav - Drain Equipment ($63,472) the result of
Mapping Operations Unit equipment and staff charging to Drain Rebill Projects,
maintenance of equipment offset by revenue equal to this amount.
(88,138.00) (88,138.00) (155,749.00) (67,611.00) 76.71%
108,381.00 108,381.00 141,285.00 32,904 00 30.36% Unfav - Income from Investments ($10,531) the result of fund not earning any return
due to the negative cash balance from the replacement of vehicles. Fav - Sale of
Equipment $43,100 for sale of Drain Equipment iitems at County Auctions.
RANSFER IN 0.00 0.00 11,422.00 11,422.00 0.00% Fav - Transfer In $11,422 for reimbursement of unspent money not used in
remodeling the Drain Office.
RANSFERS (OUT) 60,724.00 60,724.00 60,724.00 0.00 0.00%
IET REVENUES OVER(UNDER) ($40,481.00) ($40,481.00) ($63)766.00) ($23,285.00)
XPENSES
lease note that in the Adopted Budget (line-Item book) thls is budgeted as "Planned Use of Fund Balance" in the revenue category.
2/28/2007
4,049,364.00 4,049,364.00 4,049,364.00 0.00%
$ 4,049,364.00 $ 4,049,364.00 $ 4,050,764.00 $ 0.00%
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
INTERNAL SERVICE FUND
RISK MANAGEMENT
ADOPTED AMENDED FY 2007 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
!LIABILITY INSURANCE FUND 67700
OPERATING REVENUES:
Outside Revenue
Inside Revenue
Total Operating Revenue
- $ 1,400.00 $ 1,400.00 - Fay. due to refund of prior year's insurance policy expense.
OPERATING EXPENSE $ 2,556,622.00 $ 2,556,622.00 $ 2,556,622.00 $ 0_00%
CLAIMS PAID 2,172,742.00 2,172,742.00 2,172,742.00 - 0.00%
TOTAL OPERATING EXPENSES $ 4,729,364.00 $ 4,729,364.00 $ 4,729,364.00 $- 0.00%
OPERATING INCOME (LOSS) (680,000.00) (680,000.00) (678,600.00) 1,400.00 -0.21%
NON-OPERATING REVENUE (EXPENSE) 680,000.00 680,000.00 900,000.00 220,000.00 32.35% - Fav. interest rates as compared to budget and previous years.
NET REVENUES OVERAUNDER)
EXPENSES - $ 221,400.00 $ 221,400.00
TOTAL NET ASSETS - BEGINNING 11,380,371 92
TOTAL NET ASSETS - ENDING 11,601,771.92
2/28/2007
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
INTERNAL SERVICE FUND
MANAGEMENT AND BUDGET
ADOPTED AMENDED FY 2007 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
) 'ICE EQUIPMENT FUND 66400
ERATING REVENUE - INSIDE $ 643,947.00 $ 643,947.00 $ 643,947.00 $ 0.00%
ERATING EXPENSE 1,084,265.00 1,084,265.00 1,084,265.00 0.00%
=RATING INCOME (LOSS) (440,318.00) (440,318.00) $ (440,318.00) -
\I-OPERATING REVENUE (EXPENSE) 79,200.00 79,200.00 79,200.00 0.00%
r INCOME (LOSS) BEFORE
=RATING TRANSFERS (361,118.00) (361,118.00) (361,118.00)
I REVENUE OVER/(UNDER)
'ENSES (PLANNED USE OF FUND BAL)' ($361,118.00) ($361,118.00) ($361,118.00), , $0.00
FAL NET ASSETS - BEGINNING 3,343,211.30
FAL NET ASSETS - ENDING $2,982,093.30
Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category.
2/28/2007
'FRINGE BENEFITS FUND 67800
OPERATING REVENUE
RETIREES MEDICAL - VEBA
RETIREMENT ADMINISTRATION
DEFINED CONTRIBUTION PLAN
DEFERRED COMPENSATION - COUNTY
DEFERRED COMPENSATION - ADMIN
EMPLOYEE IN-SERVICE TRAINING
EMPLOYEE BENEFITS UNIT
TUITION REIMBURSEMENT
GROUP LIFE
SOCIAL SECURITY
2/27/2007 FRINGE BENEFITS.xls
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
ADOPTED AMENDED FY 2007 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
41,000,000 41,000,000 40,343,000 (657,000) -1.60%
2,627,662 2,627,662 2,568,662 (59,000) -2.25%
14,954,600 14,954,600 14,726,000 (228,600) -1.53%
850,000 850,000 798,500 (51,500) -6.06%
66,300 66,300 63,600 (2,700) -4.07%
1,545,532 1,545,532 1,496,332 (49,200) -3.18%
433,528 433,528 413,928 (19,600) -4.52%
360,000 360,000 347,000 (13,000) -3.61%
850,000 850,000 789,000 (61,000) -7.18%
17,015,800 17,015,800 16,887,700 (128,100) -0.75%
- Based on use of Blue Cross illustrative rates and actual premium for Health MEDICAL INSURANCE 31,684,900 31,684,900 31,950,000 265,100 0.84% Alliance Plan.
DENTAL INSURANCE 3,324,800 3,324,800 3,216,300 (108,500) -3.26% - Based on use of Delta Dental illustrative rates.
OPTICAL INSURANCE 377,700 377,700 358,700 (19,000) -5.03% - Based on use of Blue Cross illustrative rates.
DISABILITY INSURANCE 953,800 953,800 953,800 0 0.00%
SHORT-TERM DISABILITY 1,732,300 1,732,300 1,686,900 (45,400) -2.62%
WORKERS COMPENSATION 2,802,614 2,802,614 2,802,614 0 0.00%
UNEMPLOYMENT COMPENSATION 450,000 450,000 450,000 0 0.00%
INVESTMENT INCOME 1,499,000 1,499,000 1,588,000 89,000 5.94%
EXT - FLEX BENEFIT DEDUCTIONS 520,120 520,120 530,720 10,600 2.04%
EXT - FLEX BEN MEDICAL-EMPLOYEE 1,700,000 1,700,000 1,750,400 50,400 2.96%
EXT - MEDICAL INSURANCE 300,000 300,000 300,000 0 0.00%
EXT - DENTAL INSURANCE 30,000 30,000 30,000 0 0.00%
EXT - OPTICAL INSURANCE 3,000 3,000 3,000 0 0.00%
EXT - FORFEITURES 10,000 10,000 10,000 0 0.00%
EXT - RETIREMENT HEALTH SAVINGS 0 0 100,000 100,000 0.00%
EXT - WELLNESS PROGRAM 0 0 3,500 3,500 0.00%
TOTAL REVENUE 125,091,656 125,091,656 124,167,656 (924,000) -0.74%
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
FRINGE BENEFITS FUND 67800
ADOPTED AMENDED FY 2007 VARIANCE
BUDGET BUDGET FORECAST FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING EXPENSE
RETIREES VEBA - GENERAL NON-UNION 33,184,713 33,184,713 33,184,713 0 0.00%
RETIREES VEBA - GENERAL UNION 2,171,314 2,171,314 2,171,314 0 0.00%
RETIREES VEBA - COMMAND OFFICERS 1,558,647 1,558,647 1,558,647 0 0.00%
RETIREES VEBA - DEPUTIES 6,085,326 6,085,326 6,085,326 0 0.00%
RETIREMENT ADMINISTRATION 2,627,662 2,627,662 2,539,662 88,000 3.35%
DEFINED CONTRIBUTION PLAN 14,954,600 14,954,600 14,954,600 0 0.00%
DEFERRED COMPENSATION - COUNTY 850,000 850,000 845,000 5,000 0.59%
DEFERRED COMPENSATION - ADMIN 66,300 66,300 61,500 4,800 7.24%
SICK AND ANNUAL LEAVE CASH-OUT 841,390 841,390 865,390 (24,000) -2.85%
EMPLOYEE IN-SERVICE TRAINING 1,195,532 1,195,532 1,195,532 0 0.00%
IN-SERVICE TRAINING - INFO TECH 350,000 350,000 350,000 0 0.00%
EMPLOYEE BENEFITS UNIT 433,528 433,528 424,928 8,600 1.98%
TUITION REIMBURSEMENT 360,000 360,000 350,000 10,000 2.78%
GROUP LIFE 850,000 850,000 850,000 0 0.00%
SOCIAL SECURITY 17,015,800 17,015,800 16,960,800 55,000 0.32%
MEDICAL INSURANCE 33,684,900 33,684,900 33,914,900 (230,000) -0.68%
DENTAL INSURANCE 3,354,800 3,354,800 3,321,800 33,000 0.98%
OPTICAL INSURANCE 380,700 380,700 365,700 15,000 3.94%
DISABILITY INSURANCE 2,686,100 2,686,100 2,640,700 45,400 1.69%
WORKERS COMPENSATION 2,802,614 2,802,614 2,802,614 0 0.00%
UNEMPLOYMENT COMPENSATION 450,000 450,000 450,000 0 0.00%
FLEXIBLE BENEFIT PAYMENTS 205,000 205,000 205,000 0 0.00%
ACCOUNTING SERVICES 105,099 105,099 105,099 0 0.00%
CHILD CARE FACILITY 174,431 174,431 173,631 800 0.46%
PROFESSIONAL SERVICES 140,000 140,000 385,000 (245,000) -175.00%
RETIREMENT HEALTH SAVINGS 195,000 195,000 195,000 0 0.00%
WELLNESS PROGRAM 0 0 100,000 (100,000) 0.00%
INDIRECT COSTS 368,200 368,200 368,200 0 0.00%
TOTAL EXPENSE 127,091,656 127,091,656 127,425,056 (333,400) -0.26%
NET REVENUE OVERAUNDER) EXPENSE (2,000,000) (2,000,000) (3,257,400) (1,257,400)
TOTAL NET ASSETS - BEGINNING 25,796,309
TOTAL NET ASSETS - ENDING 22,538,909
- Budget established prior to entering into contracts for healthcare review
$95,000 and $150,000 dated 8/30/06.
FRINGE BENEFITS.xls 2/27/2007
C ERATING REVENUE $5,447,313.00 $5,447,313.00 $5,428,313.00 ($19,000.00)
$5,560,304.00 $5,560,304.00 $5,510,304.00 $50,000.00 C ERATING EXPENSE
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
ENTERPRISE FUNDS
CENTRAL SERVICES
ADOPTED AMENDED FY 2007 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
C KLAND COUNTY INTERNATIONAL
A PORT (56500)
-0.35% - Unfav. T-Hanger Rental ($100,000) reflects decrease in the number of T-
Hangers leased out due to the increased rental rates and economy, partially
offset by Fay. Reimb US Customs Service $75,000, Landing Fee
Concession $3,500 and Car Rental Concessions $2,500 due to rate
increases and slight increase in car rentals.
0.90% - Fay. Property Taxes $75,000 due to lower cost than anticipated in property
taxes for T-Hangers. Unfav. Professional Services ($25,000) due to
environmental consultant issues on the airfield.
N OPERATING INCOME (LOSS) ($112,991.00) ($112,991.00) ($81,991.00) $31,000.00 -27.44%
N N-OPERATING REVENUE (EXPENSE) $ 4,540.00 $ 4,540.00 $ 4,540.00 0.00%
T [AL INCOME BEFORE
C NTRIBUTIONS AND TRANSFERS ($108,451.00) ($108,451.00) $ (77,451.00) $31,000.00
T \NSFER OUT 0.00 0.00 0.00
C 'ITAL CONTRIBUTION 108,451.00 108,451.00 108,451.00
T [AL NET INCOME (LOSS) $0.00 $0.00 $31,000.00 $31,000.00
T [AL NET ASSETS - BEGINNING $ 63,826,385.00
T [AL NET ASSETS - ENDING $63,857,385.00
0.00%
2/27/2007
___....
FY 2007 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS
CENTRAL SERVICES
ADOPTED AMENDED FY 2007 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 126,486.00 $ 126,486.00 $ 126,486.00 $ - 0.00%
;ide Revenue 6,338,778.00 6,338,778.00 6,338,778.00 - 0.00%
Total Revenue $ 6,465,264.00 $ 6,465,264.00 $ 6,465,264.00 $ -
II RATING EXPENSE 7,404,644.00 7,404,644.00 7,404,644.00 0.00 0.00%
I -iRATING INCOME (LOSS) $ (939,380.00) $ (939,380.00) $ (939,380.00) $ 0.00%
4-OPERATING REVENUE (EXPENSE) 477,453.00 477,453.00 477,453.00 0.00 0.00%
INCOME (LOSS) BEFORE OPERATING
,NSFERS $ (461,927.00) $ (461,927.00) $ (461,927.00) $ 0.00%
I rOR POOL FUND 66100
RATING REVENUE:
ttside Revenue
ERATING TRANSFERS IN 60,724.00 60,724.00 60,724.00 0.00
REVENUE OVER/(UNDER)
'ENSES (PLANNED USE OF FUND BAL.) • $ (401,203.00) $ (401,203.00) $ (401,203.00) $
AL NET ASSETS - BEGINNING $ 6,780,198.02
AL NET ASSETS - ENDING $ 6,378,995.02
ace note that in the Adopted Budget (line-item budget), Planned Use of Fund Balance appears listed with the revenue accounts.
2/28/2007
FY 2007 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS
CENTRAL SERVICES
ADOPTED AMENDED FY 2007 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
A LING, CONVENIENCE COPIER AND PRINTING FUND 66700
) ERATING REVENUE:
Aside Revenue
side Revenue
Total Revenue
) ERATING EXPENSE
) ERATING INCOME (LOSS)
$ 432,500.00 $ 432,500.00 $ 532,500.00 $100,000.00 23.12% - Fav. due to increase of mail room and printing services to CVT's.
2,891,653.00 2,891,653.00 3,041,653.00 150,000.00 5.19% - Fav. due to increase of printing by departments.
$ 3,324,153.00 $ 3,324,153.00 $ 3,574,153.00 $ 250,000.00
3,396,038.00 3,396,038.00 0.00 0.00%
$ (71,885.00) $ (71,885.00) $ 178,115.00 $ 250,000.00
3,396,038.00
'J-OPERATING REVENUE (EXPENSE) 7,000.00 7,000.00 0.00 (7,000.00) -100.00% - Unfav, reduced cash flow due to increased inventory of postage.
REVENUE OVER/(UNDER)
E 'ENSES (PLANNED USE OF FUND BAL.)* $ (64,885.00) $ (64,885.00) $ 178,115.00 $ 243,000.00
I-1 -AL NET ASSETS - BEGINNING $ 413,194.53
Ii -AL NET ASSETS - ENDING $ 591,309.53
F ase note that in the Adopted Budget (line-item budget), Planned Use of Fund Balance appears listed with the revenue accounts.
CD
2/28/2007
nside Revenue 24,828,235.00 24,828,235.00 24,542,035.00 (286,200.00)
Total Revenue $25,058,235.00 $25,058,235.00 $24,772,035.00 ($286,200.00) -1.14%
: ERATING EXPENSES
I F INCOME (LOSS) BEFORE
ERATING I RANSFERS ($270,000.00) ($270,000.00) ($662,800.00) ($392,800.00)
$25,328,235.00 $25,328,235.00 $25,434,835.00 ($106,600.00) -0.42% - Unfav. Indirect Cost Charges ($235,800) due to determination of indirect cost charge
subsequent to budget formulation; unfav. Electrical Services costs ($100,000) based
on higher costs to producers to generate electricity from gas fired plants; Information
Technology Operations ($24,300) and Telephone Communications ($10,000) based
on usage requirements. Unfavorability is largely offset by Turnover $165,000;
Overtime $25,000 due to reduced snowplowing activity; fay. Water & Sewage
Charges $50,000; fav. Garbage & Rubbish Disposal $15,000 and fay. Maintenance
and Grounds Supplies $10,000 all due, in part, to pending opening of new Executive
Office Building.
-1.15% - Reduced Office Space Rental revenue ($148,600) based on lease arrangement for
O.C. Road Commission at the Information Technology Center and reduced
Maintenance Department Charges to Departments ($137,600) based on, in part,
reduced activity pending departmental relocations to the new Executive Office
Building (former Oakland Schools Administration Building).
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
INTERNAL SERVICE FUND / ENTERPRISE FUND
FACILITIES MANAGEMENT
ADOPTED AMENDED FY 2007 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
;ILITIES MAINTENANCE & OPERATIONS (#63100)
ERATING REVENUES:
lutside Revenue $230,000.00 $230,000.00 $230,000.00 $ 0.00%
I \J-OPERATING REVENUE $270,000.00 $270,000.00 $420,000.00 150,000.00 55.56% - Fav. Investment Income based on higher interest rates.
\ NSFERS IN
\NSFERS OUT ($400,000.00) ($600,000.00) ($600,000.00)- 0.00% - Transfer to Project Work Order Fund to fund Maintenance Projects.
I I REVENUES OVER(UNDER)
EXPENSES* ($400,000.00) , ($600,000.00) ($842,800.00)‘ ($242,800.00)
[AL NET ASSETS - BEGINNING $10,012,268.96
FAL NET ASSETS - ENDING $9,169,468.96
.ase note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category.
FACILITIES INTERNAL FORE.xls 2/28/2007
1, -AL NET ASSETS - BEGINNING
P -AL NET ASSETS - ENDING
$15,704.49
$15,704.49
FY 2007 FIRST QUARTER REPORT
INTERNAL SERVICE FUND / ENTERPRISE FUND
FACILITIES MANAGEMENT
ADOPTED AMENDED FY 2007 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
3, ,ITIAC MARKET (#56100) I
D ERATING REVENUES - OUTSIDE $159,653.00 $159,653.00 $159,653.00 $0.00 0.00%
D ERATING EXPENSES $159,653.00 $159,653.00 $159,653.00 $0.00 0.00%
- INCOME (LOSS) BEFORE
• ERATING TRANSFERS $0.00 $0.00 $0.00 $0.00 0.00%
• ,NSFERS IN - - - 0.00%
T1 1,NSFERS OUT
- REVENUES OVER(UNDER)
EXPENSES $0.00 $0.00 $0.00 $0.00 0.00%
CTI
FACILITIES INTERNAL FORE.xls 2/28/2007
J en Oaks Medical Care Facility 52100
F RATING REVENUE $10,796,066.00 $7,983,479.00
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
ENTERPRISE FUND
HEALTH AND HUMAN SERVICES
AMOUNT
ADOPTED AMENDED FY 2007 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
F RATING EXPENSE $10,796,066.00 $10,796,066.00
$7,078,913.65 ($1,232,600.00) -15.44% - (Unfavorable) due to decreased daily patient census currently at 65-70%
occupancy rate.
$8,981,260 90 $1,143,231.00 10.59% - Favorable Operating Expenses due to Turnover $1,257,500. Favorable
Professional Services $285,731, due to a change in contract provider for Food
Service, Medical Director and minimal use of Medical Record consultant.
Favorable expenses are partially offset by (unfavorable) variance in
Uncollectible Accounts Receivables ($400,000), based on activity prior to
2004.
OPERATING INCOME (LOSS)
-OPERATING REVENUE
2 AL INCOME BEFORE
TRIBUTIONS AND TRANSFERS
\ISFEB IN
$0.00 ($2,812,587.00) ($1,902,347.25) $910,239.75
$0.00 ($2,812,587.00) $ (1,902,347.25) $ 910,239.75
0 00 2,812,587.00 2,812,587.00 $0.00 0.00% Transfer from General Fund.
AL NET INCOME (LOSS) $0.00 $0.00 $910,239.75 $910,239.75
: AL NET ASSETS - BEGINNING $ 1,312,018.57
AL NET ASSETS - ENDING $2,222,258.32
CD
2/28/2007
rmation Technology - Operations (63600)
ERATING REVENUES:
utside
[RATING TRANSFERS IN
[AL OPERATING REVENUES
[RATING EXPENSES
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS! ENTERPRISE FUND
INFORMATION TECHNOLOGY
FY 2007 FY 2007 FY 2007
ADOPTED AMENDED FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCES
side
$918,066.00 $918,066.00 $1,192,866.00 $274,800.00 29.93% - Fay. primarily due to increase Interest Income $525,00 from improved rates &
higher than anticipated cash balance. Fav. Offset by unfavorable Deferred
Land File Tax Reimb Equalization Svcs ($69,867) from change in billing
procedures due to BSA technology; Unfav. ($105,836) Outside Agencies due to
fewer projected estimate of external customers requests; and Unfav. ($81,121)
Enhanced Access Fees due to less than projected on-line customer activity.
25,925,252.00 25,925,252.00 24,438,511.00 (1,486,741.00) -5.73% - Unfav primarily due to Prior Year Balance (5,396,659) which reflects offset to
expense to balance 07 budget. Unfav. OC Dept'l Dev & Ops ($464,973) &
Unfav. Non Govt'l Dev & Ops ($1,345,490) due to decrease in charges; partially
offset by Fav. Imaging Day & Ops $331,208.
2,550,000.00 2,550,000.00 2,550,000 00 0.00 0.00% Budgeted Transfer from General Fund for OAKNet Support and capital
equipment replacement needs.
29,393,318.00 29,393,318.00 28,181,377.00 (1,211,941.00) -4.12%
34,789,977.00 34,789,977.00 31,980,877.00 2,809,100.00 8.07% - Favorability primarily Depreciation $1,405,065 for IT projects in progress not
fully operational; Salary & FB $713,403 vacancies & turnover; Fay. $590,005
equipment maint due to negotiating lower cost of hardware maint & $534,261
software maintenance due to reducing Oracle true-up costs. Fay. data proc &
print supplies $184,465 due to decrease in ext. printing requests.Partially offset
by Unfav. ($618,072) Expendable Equip. due to increase in capital equip
requests for replacements & upgrades.
[RATING TRANSFERS (OUT) 0.00 000 0.00 0.00 0.00%
[RATING INCOME (LOSS) ($5,396,659.00) ($5,396,659.00) ($3,799,500.00) $1,597,159.00
[AL NET ASSETS - BEGINNING 33,735,703.30
[AL NET ASSETS - ENDING $29,936,203.30
t se note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category.
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
FY 2007 FY 2007 FY 2007
ADOPTED AMENDED FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCES
.rmation Technology - Telephone Communications (67500) I
• ERATING REVENUES:
utside $46,000.00 $46,000.00 $91,000.00 $45,000.00 97.83% Interest income $45,000 favorable due to improved rates and higher cash
balance.
side 3,974,200.00 3,974,200.00 3,969,200.00 (5,000.00) -0.13% Unfavorable Leased Equipment due to decreased pager usage ($5,000).
ERATING TRANSFERS IN 0.00 0.00 0.00 0.00 0.00%
FAL OPERATING REVENUES 4,020,200.00 4,020,200.00 4,060,200.00 40,000.00 0.99%
=RATING EXPENSES 3,687.627.00 3,687,627.00 3,935,700.00 (248,073.00) -6.73% Unfav. FR ($10,000) due to increased rates. Non-controllable Indirect Cost is
$7,000 favorable. Unfav. Equip. Maintenance ($35,000) offset by fay. Sublet
Repairs $30,000 due to categories of repair costs. Fav. Software Maintenance
$8,000 due to improved contract rates. Tower Charges $10,000 fay, due to
decreased pager use. Unfav. Expendable equipment ($160,000) is rebilled to
customers. Info Tech Operations unfav. ($98,000) due to increased usage.
Transfer to Reserve forecast is $124,500 , which is ($208,100) less than
budgeted amount.
ERATING TRANSFERS (OUT) 0.00 0.00 0.00 0.00 0.00%
RATING INCOME (LOSS) $332,573.00 $332,573.00 124,500.00 ($208,073 00)
-AL NET ASSETS - BEGINNING $4,654,841.09
-AL NET ASSETS - ENDING $4,779,341.09
Ise note that in the Adopted Budget (line-item book) this is budgeted as "Transfer to Reserve" in the expense category.
)
: ERATING TRANSFERS IN
- -AL OPERATING REVENUES
E RATING EXPENSES
) ERATING TRANSFERS (OUT) 0.00 0.00 0.00 0.00 0.00%
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS! ENTERPRISE FUND
INFORMATION TECHNOLOGY
FY 2007 FY 2007 FY 2007
ADOPTED AMENDED FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCES
r mation Technology - CLEMIS (53500) I
: 1,RATING REVENUES:
utside $2,532,237.00 $2,532,237.00 $2,791,837.00 $259,600.00 8.38% Fav. In-Car Terminals (External) $219,805 due to increase in MDC devices for
ext. agencies; Rebilled Charges $59,020 for Communications costs to Outside
OC agencies & Edge Modem installs; Income from Investments $45,000 due to
improved returns. Maint Contr. $25,900 due to additional agencies interested in
Mugshot Capture Station Maint. Partially offset by Unfav. Clemis Ops Outside
($90,167) due to delay in implementation or Non- Oakland agencies.
side 1,881,749.00 1,881,749.00 2,865,610.00 983,861.00 53.20% Unfav. primarily due to Planned Use Balance ($2,780,161) which reflects the
offset of expense to balance FY 07 budget; partially offset by fav Capital Asset
Contributions $1,000,000 for add .' COPS MORE equip purchases - an
amendment will be requested for first qtr.
1,719,000.00 1,719,000.00 1,719,000.00 0.00 0.00% Budgeted Transfer from Radio deferred until new system operational.
6,132,986.00 6,132,986.00 7,376,447.00 1,243,461.00 8.39%
8,913,147.00 8,913,147.00 9,654,147.00 (741,000.00) -2.43% Unfavorable primarily due to increase Depreciation ($626,216) includes
CopsMore purchases put into service subsequent to budget; Expendable
Equipment for technology upgrade ($40,531); Parts & Supplies ($153,851) due
to repairs on aging LiveScan equip & MDC equipment; ISF Info Tech
Developmnt & Ops ($229,847) due to add! assistance for Records Mgmt
System; ($85,848) Software Purchases due to staff requiring development
tools for projects. Partially offset by favorable Sal/FO due to underfills &
vacancies; Equip Repairs $26,743 cost reductions for HP Servers &
workstation maint; Maint Contracts $50,800 reduced cost due to returned E911
equip; Professional Svcs $200,000 fay, due to timing of Oak Video from
implementation to support & maint.
) :RATING INCOME (LOSS) ($2,780,161.00) ($2,780,161.00) ($2,277,700.00) $502,461.00
'AL NET ASSETS - BEGINNING 12,463,981 92
-AL NET ASSETS - ENDING $10,186,281.92
' Ise note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" in the revenue category.
927,998.00
250,000 00
6,452,308.00
2,933,408.00 3,714,900.00
(346,000.00) 15.45%
183,000.00 24.56% Favorable Internal revenue for Leased Equipment $48,000 and Parts &
Accessories $135,000 due to continued billing for legacy system.
0 00 0 00% Operating Transfer per M.R. 06254 for purchase of radios for non public safety
departments.
55.88% Salaries and FB $10,000 favorable overall. Communications ($30,000) unfav.
due to increased cost of connectivity for new system. Equip Repair ($125,000)
unfav. due to ongoing maintenance cost of legacy system. Non-controllable
Indirect Cost ($127,000) unfav. Prof. Svcs. $25,000 fav. due to capitalized cost
of new system. Depreciation $3,996,000 fay, due to timing of start of new
system. Internal Services are ($34,000) unfav. overall: Maintenance Dept.
$5,000 fav. due to decreased usage; Info Tech Operations ($33,000), Motor
Pool ($4,000) and Telephone Commun. ($2,000) all unfav. due to cost of
implementing new system.
$0.00 $0.00 3,368,900.00 $3,368,900.00 :RATING INCOME (LOSS)
•AL NET ASSETS - BEGINNING
•AL NET ASSETS - ENDING
44,179,950.00
47,548,850.00
FY 2007 FY 2007
ADOPTED AMENDED
rmation Technology-Radio Communications (53600)
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS (ENTERPRISE FUND
INFORMATION TECHNOLOGY
FY 2007
FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCES
5,274,310.00 ($529,000.00)
'iRATING REVENUES:
Aside
;ide
RATING TRANSFERS IN
-AL OPERATING REVENUES
:RATING EXPENSES
$5,803,310.00 $5,803,310.00
744,998.00 744,998.00
0.00 250,000.00
6,548,308.00 6,798,308 00
6,398,308.00 6,648,308.00
-9.12% Unfavorable Antenna Site Management revenue ($35,000) due to timing of
addition of collocator. Unfav. E911 revenue ($813,000) due to decrease in
surcharge after adoption of budget. Favorable Outside Agency revenue
$219,000 due to continued billing for legacy system pending start-up of new
system. Fay. interest income $600,000 due to improved rates. Unfav.
($500,000) Gain on Sale of Asset due to continued operation of legacy system.
150,000.00 RATING TRANSFERS (OUT) 150,000.00 150,000.00 0.00 0.00% Operating Transfers out budgeted to CLEMIS $100,000 and IT funds $50,000
for operations of new radio system.
FY 2007
ADOPTED
FY 2007
AMENDED
COUNTY OF OAKLAND
FY 2007 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
FY 2007
FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCES
Records Management 53100)
:RATING REVENUES:
utside
ERATING TRANSFERS IN
FAL OPERATING REVENUES
ERATING EXPENSES
ERATING TRANSFERS (OUT)
ERATING INCOME (LOSS)
FAL NET ASSETS - BEGINNING
rAL NET ASSETS - ENDING
$183,770.00 $183,770.00
401,940.00 501,940.00
585,710.00 685,710.00
585,710.00 685,710.00
0.00 0.00
$0.00 $0.00
$188,770.00
501,940.00
690,710.00
690,710.00
0.00
$0.00
208,683.08
$208,683.08
$5,000.00 2.72%
0.00 0.00%
5,000.00 0.73%
(5,000.00) -0.73%
0.00 0.00%
$0.00
Favorable Interest income $5,000 due to improved rates and higher cash
balance.
Budgeted Transfer from General Fund for operating support; Operating
Transfer per M.R. 06254 for ongoing development and mobile fire inspection
Non-controllable Indirect Cost is $2,300 favorable, Equipment Repair is $4,000
favorable due to fewer service calls. Internal Services are ($11,200) unfav.
overall: IT Development unfav. ($4,300) due to programming cost; !Tech
Operations ($6,900) unfav. due to increased usage.
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2007 FIRST QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2007
AMENDMENTS
GF/GP OPERATIONS - SELF BALANCING AMENDMENTS
GENERAL FUND (#10100)
Dept Program Acct
52nd District Courts
Expenditures
3020201 121020 731185
3020205 113290 731185
3020201 121020 730548
3020205 113290 730548
3020201 121020 731213
3020201 121020 731339
3020201 121020 750168
3020201 121020 750154
3020201 121020 776666
3020205 113290 776666
3020301 121020 750168
3020301 121020 750154
3020301 121020 731213
3020301 121020 731339
3020401 121020 731213
3020401 121020 731339
Fund Aff. Account Name
Div. I - Medical Exams
Div. I - Medical Exams
Div. I - Drug Testing
Div. I - Drug Testing
Div. I - Membership Dues
Div. I - Periodicals, Books, Public Subscrip.
Div. I - FA Proprietary Equipment Exp.
Div. I - Expendable Equipment Exp.
Div. I - Print Shop
Div. I - Print Shop
Div. II - FA Proprietary Equipment Exp.
Div. II - Expendable Equipment Exp.
Div, II - Membership Dues
Div, II - Periodicals, Books, Public Subscrip.
Div. III - Membership Dues
Div. III - Periodicals, Books Public Subscrip.
Total Expenditures
$ (6,000.00)
6,000.00
(10,000.00)
10,000.00
(500.00)
500.00
(2,217.00)
2,217.00
(315.00)
315.00
(3,000.00)
3,000.00
(553.00)
553.00
(2,500.00)
2,500.00
52nd District Courts / Non-Departmental
Expenditures
9090101 196030 760126
3020401 121020 750168
3020401 121020 750154
Non-Department - Misc. Capital Outlay
Div. III - FA Proprietary Equipment Exp.
Div. III - Expendable Equipment Exp.
Total Expenditures
$ (3,100.00)
(4,180.00)
7,280.00
9090101 196030 730359
3020501 121020 730247
Treasurer's Office
Revenues
7010101
7010101
Library Board/Non-Departmental
Revenues
5010301 165000 695500 10100
9010101 195030 665882
Non-Department - Contingency
Div. IV - Charge Card Fees
Total Expenditures
Payment in Lieu of Assessments
Payment in Lieu of Taxes
Total Revenues
Library - Transfer In
Planned Use of Fund Balance
Total Revenues
186070 605263
186070 601525
$ (10,000.00)
10,000.00
$ (110,000.00)
$ 110,000.00
$ (27,209.00)
27,209.00
BOG/Library Board
Expenditures
5010101 180010
5010101 180010
5010302 165020
5010302 165020
750154
750168
750154
750168
$ (29,750.00)
$ (29,750.00)
M & B - Equalization Division
Revenues
1020501 Reimbursement - Equalization Services
Total Revenues
$ 21,997.00
$ 21,997.00
186020 631813
M & B - Purchasing Division
Expenditures
1020401 182090
1020401 182110
1020401 182090
1020401 182110
750154
750154
750168
750168
Expenditures
1020501
1020501
1020501
186020 750154
186020 760126
186020 750168
$ 5,797.00
18,200.00
(2,000.00)
$ 21,997.00
$ 1,500.00
500.00
(1,500.00)
(500.00)
M & B - Fiscal Services
Expenditures
1020601 182020
1020601 182040
1020615 182080
1020640 182080
1020601 182020
1020601 182040
1020615 181080
1020640 182080
750154
750154
750154
750154
750168
750168
750168
750168
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2007 FIRST QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2007
AMENDMENTS
1GF/GP OPERATIONS - SELF BALANCING AMENDMENTS
BOC - Expendable Equipment Expense $ 3,500.00
BOC - FA Prop. Equipment Expense (3,500.00)
Lib. Bd. - Expendable Equipment Expense 1,750.00
Lib. Bd. - FA Prop. Equipment Expense (1,750.00)
Total Expenditures
County Executive - Auditing Division
Revenues
1010201 181010 631869
Expenditures
9090101 196030 730359 Contingency
Reimbursement - Salaries
Total
Expendable Equipment Expense
Captial Outlay
FA Prop. Equipment Expense
Total Expenditures
Expendable Equipment Expense
Expendable Equipment Expense
FA Prop. Equip. Expense
FA Prop. Equip. Expense
Total Expenditures
Expendable Equipment Expense
Expendable Equipment Expense
Expendable Equipment Expense
Expendable Equipment Expense
FA Prop. Equip. Expense
FA Prop. Equip. Expense
FA Prop. Equip. Expense
FA Prop. Equip, Expense
Total Expenditures
500.00
500.00
500.00
500.00
(500.00)
(500.00)
(500.00)
(500.00)
Co
Pub. Svcs - Veterans' Services Division / Non-Departmental
Expenditures
9090101 196030 730359
1070301 132090 731801
Pub. Svcs - Community Corrections Division
Revenues
1070401
1070401
1070401
1070401
Non-Dept. Contingency
Soldier's Relief
Total Expenditures
Step Forward - Community Corrections
Step Forward - Fee Income
WWAM - Community Corrections
WWAM - Fee Income
Total Revenues
113060 625109
113060 630686
113080 625109
113140 630686
182200 631743
182200 670456
196020 655385
196030 731136
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2007 FIRST QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2007
AMENDMENTS
GF/GP OPERATIONS - SELF BALANCING AMENDMENTS
M & B - Reimbursement Division
Expenditures
1020701 126000 750154
1020701 126010 750154
1020701 126000 750168
1020701 126010 750168
Expendable Equipment Expense
Expendable Equipment Expense
FA Prop. Equip. Expense
FA Prop. Equip. Expense
Total Expenditures
$ 2,500.00
2,500.00
(2,500.00)
(2,500.00)
$ (7,666.00)
7,666.00
27320
27320
20221
Pub. Svcs - MSU Extension Division
Expenditures
1070501 132120 731213
1070501 132120 731339
1070501 132110 731339
1070501 131030 731339
1070501 174000 750168
1070501 174000 750170
Non - Departmental
Revenues
9010101
9010101
Revenues
9010101
Expenditures
9010101
Sheriffs Office / Non-Departmental
Expenditures
4030301 112650 788001
4030301 112620 788001
9010101 134860 788001
Membership Dues
Periodicals, Publications, & Subscriptions
Periodicals, Publications, & Subscriptions
Periodicals, Publications, & Subscriptions
FA Proprietary Equipment Expense
Other Equipment Expense
Total Expenditures
Refunds Misc
Prior Years Adjustments
Total Revenues
Income from Investments
Logos and Trademarks
Total
Transfer Out to Drug Policy Grant Fund
Transfer Out to Drug Policy Grant Fund
Transfer Out to Health Fund
Total Expenditures
$ (189,000.00)
189,000.00
(191,000.00)
191,000.00
$ (310.00)
150.00
85.00
75.00
(746.00)
746.00
$ (417,500.00)
417,500.00
-
$ 20,000.00
$ 20,000.00
$ 58,608.00
(141,667.00)
83.059.00
-_
Health Fund (#22100)
Revenues
1060220 134170
1060220 134190
1060220 134060
1060220 134080
1060220 134170
1060220 134190
1060220 134220
1060220 134230
9090101 134860
610313
615571
615571
615571
615571
615571
615571
615571
695500
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2007 FIRST QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2007
AMENDMENTS
GF/GP OPERATIONS - SELF BALANCING AMENDMENTS
Expenditures
9090101 196030 730359
9010101 134860 788001 20221
Non-Departmental
Revenues
9090101 134860 695500 10100
Health Division
Expenditures
1060261 134440 788001 27320
Contingency
Transfer Out to Health Fund
Total Expenditures
Transfer In from General Fund
Total Revenues
Transfer Out to Drug Policy Grant Fund
Total Expenditures
Total Change in Health Fund
$ 70,681.00
(70,681.00)
•••
$ 83,059.00
$ 83,059.00
$ 83,059.00
$ 83,059.00
Non-Departmental
Revenues
9090101 133390 695500
Health Division
Expenditures
1060294 133390 702010
1060294 133390 722740
10100 Transfer In from General Fund
Health Division - Salaries
Health Division - Fringe Benefits
Total Expenditures
Total Change in Health Fund
$ (70,681.00)
$ (50,780.00)
(19,901.00)
$ (70,681.00)
Health Division - Radon Testing $ (7,500.00)
Health Division - Grants - State 4,600.00
Health Division - Water Sewerage Evaluations 1,950.00
Health Division - On Site Sewage Permits 3,756.00
Health Division - Radon Testing (7,500.00)
Health Division - 2B Non-Comm Water Supp, (3,356.00)
Health Division - Water Sample Tests 25.00
Health Division - Campground Requirement 550.00
10100 Transfer In from General Fund 7,475.00
Total Health Revenues
General Fund (#10100)
Expenditures
9090101 196030 730539
9010101 134860 788001 20221
Non-Dept Contingency
Transfer Out to Health Fund
Total General Fund Expenditures $
$ (7,475.00)
7,475.00
CHILD CARE FUND (#20293)
Revenues
9010101 112700 615359 $ 1,544,004.00 Child Care Subsidy
1GF/GP OPERATIONS - SELF BALANCING AMENDMENTS
3010402 121240 630140
1060501 112010 631435
Circuit Court - Board and Care
CV - Out County Board and Care
Total Revenues
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2007 FIRST QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2007
AMENDMENTS
52,163.00
(50,000.00)
$ 1,546,167.00
Expenditures
1060102 135000 730919
1060102 135000 731409
1060102 135000 731416
Human Services - Independent Living $ 250,000.00
Human Services - Priv. Inst. - Foster Care 800,000.00
Human Services - Priv. Inst. - Residential 496,167.00
Total Expenditures $ 1,546,167.00
Total Child Care Fund
FY 2007
AMENDMENTS
Radio Communications - Fund #53600
Revenues
1080310 116170 655385
Expenditures
1080310 115150 731150
1080310 116170 730646
1080310 116170 730926
1080310 116170 774677
CLEMIS Fund - #53500
Expenditures
1080301 116020 776661
1080305 116020 776661
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2007 FIRST QUARTER BUDGET AMENDMENTS
PROPRIETARY I SPECIAL REVENUE FUNDS
ACCOUNT NUMBER
PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Oper Unit Account Name
#63100
Dept ID Program Acct Fund Aff
Facilities Maintenance and Operations - Fund
Revenues
1040702 Captial Asset Contributions
Transfer Out to Motor Pool
Budgeted Equity Adjustment
Total Expenditures
Total Change in Fund Equity
140599
Expenditures
1040702 140599 788001 66100
1040702 140599 796500
690189 $ 108,917.00
$ 24,917.00
84,000.00
$ 108.917.00
63100
Motor pool - Fund #66100
Revenues
1030811 184010 665882
1030811 184010 695500
1030811 184010 675356
Planned Use of Fund Balance
Transfer in from FM & 0 Fund
Loss on Sale of Equipment
Total Revenues
Income from Investments
Maintenance Contract
Equipment Maintenance
Indirect Costs
Insurance
Total Expenditures
Total Change in Fund Equity
Motorpool
Motorpool
Total Expenditures
$ 84,000.00
24,917.00
$ (108,917.00)
$ 400,000.00
195,773.00
61,000,00
127,227.00
16,000.00
400,000.00
$ (13,000.00)
13.000.00
Information Technology Fund - #63600
Revenues
1080101 152000 665882
1080101 173080 635179
1080101 173080 630910
1080101 173080 631372
1080101 173080 631309
Planned Use of Fund Balance $ 1,601,554.00
Enhanced Access (60,000.00)
Imaging Operations 3,000.00
OC Depts. Operations 48,000.00
Non-Govfl Operations 9,000.00
Total Revenues $ 1,601,554.00
Expenditures
1080101
1080601
1080601
1080201
1080201
1080201
1080201
1080601
1080701
152010 731458 Professional Services $ 438,467.00
152010 750170 Expendable Equipment Expense 818,176.00
152010 731458 Professional Services (144,600.00)
152010 731458 Professional Services 617,786,00
152010 731773 Software Purchases 39,230.00
152010 750170 Expendable Equipment Expense 950.00
152010 750413 Parts and Accessories 950.00
152010 731458 Professional Services (168,747.00)
152020 731458 Professional Services (658.00)
Total Expenditures $ 1,601,554.00
Total Change in Fund Equity $ -
"D
121200
121200
121200
121200
702010
722740
731458
750280
Cir. Ct. - Grant Match
Cir. Ct. - Operating Transfer In
Total Revenues
Grants - State
Total Revenues
Expenditures
3010301
3010301
3010301
3010301
121200
121200
121200
121200
702010
722740
731458
750280
Sheriffs Office / Health Division
Revenues
4030301 112620 610313
4030301 112650 695500
4030301 112620 631799
4030301 112653 631799
1060261 134440 615571
1060261 134440 610313
1060261 134440 695500
Salaries
Fringe Benefits
Professional Services
Lab Supplies
Total Expenditures
Total Bryne Drug Court Grant Fund
Drug Policy Grant Fund - #27320
$ 59,871.00
29,935.00
72,000.00
8,194.00
$ 170,000.00
Expenditures
4030301
4030301
4030301
4030301
4030301
4030301
112620
112650
112620
112650
112620
112650
702010
702010
722740
722740
731458
731458
$ (94,797.00)
94,797.00
(37,385.00)
37,385.00
(35,034.00)
35,034.00
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2007 FIRST QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
FY 2007
AMENDMENTS ACCOUNT NUMBER
PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Circuit Court / Friend of the Court - Fund #27100
Revenues
3010404 126030 620467
3010404 126030 695500
Circuit Court - SCAO Drug Court Grant - Fund #27130
Revenues
3010301 121200 615571
Expenditures
3010301
3010301
3010301
3010301
Circuit Court - Bryne Drug Court Grant - Fund #27190
Revenues
3010301 121200 615571
Salaries
Fringe Benefits
Professional Services
Lab Supplies
Total Expenditures
Total SCAO Drug Court Grant Fund
$ (5,210,472.00)
5,210,472.00
$ (170,000.00)
$ (170,000.00)
$ (59,871.00)
(29,935.00)
(72,000.00)
(8,194.00)
$ (170,000.00)
Grants - Federal $ 170,000.00
Total Revenues $ 170,000.00
Sheriff - Grants - Federal $ 58,608.00
10100 Sheriff - Transfer In from Gen. Fund 58,608.00
Sheriff - Reimbursement Contracts (50,000.00)
Sheriff - Reimbursement Contracts 50,000.00
Health Division - Grants - State (141,667.00)
Health Division - Grants - Federal 83,059.00
20221 Health Div.- Trans. In from Gen. Fund (58,608.00)
Total Revenues
Sheriff - Salaries
Sheriff - Salaries
Sheriff - Fringe Benefits
Sheriff Fringe Benefits
Sheriff - Professional Sys,
Sheriff- Professional Svs.
Total Expenditures
Total Change in Fund Equity
I I
FY 2007
AMENDMENTS
Medical Care Facility
Expenditures
1060370 136270
1060370 136270
1060370 136270
1060360 136260
1060301 136320
1060360 136260
Fund -#52100
770631
774636
778675
770631
774636
778675
Parks and Recreation Fund - #50800
Revenues
5060831 160210 632135
5060831 160210 670114
Expenditures
5060715
5060732
5060839
5060720
5060715
5060732
5060839
5060805
160070
160070
160210
160070
160070
160070
160210
160260
750511
750511
750511
730814
731458
731458
731458
750511
Expenditures
1060290
1060290
1060290
1060290
115010 702010
115010 722750
115010 730926
115010 731213
Salaries
Fringe Benefits
Indirect
Membership Dues
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2007 FIRST QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
ACCOUNT NUMBER
PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Narcotics Enforcement Team (NET) Grant - Fund #27320
Expenditures
4010201 122080 722740
4030901 110090 722740
Prosecutor - Fringe Benefits
Sheriff - Fringe Benefits
Total Expenditures
$ 1,183.00
(1,183.00)
Building Space Cost Allocation
17. Operations
Telephone Communications
Building Space Cost Allocation
I.T. Operations
Telephone Communications
Total Expenditures
Special Contracts
Cash Overages
Total Revenues
$ 16,253.00
9,901.00
2,274.00
(16,253.00)
(9,901.00)
(2,274.00)
$ 3,000.00
(3,000.00)
Health Division - CPBC Grants
AIDS/HIV Fund (#28557) - Grant #gr000000194
Expenditures
1060294 133940 702010
1060294 133940 722750
1060294 133940 730926
1060294 133940 731346
1060294 133940 750399
1060294 133940 770631
1060294 133940 774636
Special Events
Special Events
Special Events
Ground Maintenance
Professional Services
Professional Services
Professional Services
Special Events
Total Expenditures
Total Change in Fund Equity
Salaries
Fringe Benefits
Indirect
Mileage
Office Supplies
Bldg. Space Alloc.
IT Oper.
Total Expenditures
$ 15,500.00
750.00
100.00
3,000.00
(15,500.00)
(750.00)
(100.00)
(3,000.00_)
$ (27,821.00)
19,340.00
7,847.00
(143.00)
(13.00)
791.00
(1,00)
Health Bioterrorism Fund (#28605) - Grant #gr0000000277
Revenue
1060290 115010 610313
Total Revenues
$ J20.906.00)
$ (20,906.00)
$ (39,414.00)
(17,359.00)
2,761.00
2,000,00
Grants - Federal
"1
ACCOUNT NUMBER
PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Salaries
Fringe Benefits
Indirect
Interpreter Fees
Mileage
Expendable Equip.
Travel & Conf.
Other Expend. Equip.
Medical Supplies
Training-Educational Supplies
Bldg. Space
Convenience Copier
IT Oper
Insurance Fund
Mail Room
Print Shop
Telephone Comm.
Total Exependitures
Total Change in Fund
702010
722750
730926
730982
731346
750154
732018
750170
750301
750567
770631
770667
774636
774677
775667
776666
778675
702010
722750
730373
730646
730926
731346
732018
750399
750567
770667
Salaries
Fringe Benefits
Contractual Svs,
Equip Repairs
Indirect
Mileage
Travel & Conf.
Office Supplies
Training-Educational Supp
Convenience Copier
Child Lead Poisoning Fund (#29529) - Grant #gr0000000284
Revenues
1060201 133100 610313
1060231 133200 610313
Grants - Federal
Grants - Federal
Total Revenues
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2007 FIRST QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
731458 Prof. Serv.
731941 Training
750077 Disaster Supplies
750170 Other Expend Equip
770631 Bldg. Space
772618 Equip Rental
774636 IT Oper
775667 Mall Room
776666 Print Shop
778675 Telephone Comm
Total Expenditures
Total Change in Fund
Fund (#28605) - Grant #gr0000000277
Grants - Federal
Total Revenue
Cities Readiness Initiative
Revenue
1060290 115035 610313
1060290
1060290
1060290
1060290
1060290
1060290
1060290
1060290
1060290
1060290
Expenditures
1060290
1060290
1060290
1060290
1060290
1060290
1060290
1060290
1060290
1060290
1060290
1060290
1060290
1060290
1060290
1060290
1060290
Expenditures
1060231
1060231
1060231
1060231
1060231
1060231
1060231
1060231
1060231
1060231
115010
115010
115010
115010
115010
115010
115010
115010
115010
115010
115035
115035
115035
115035
115035
115035
115035
115035
115035
115035
115035
115035
115035
115035
115035
115035
115035
133200
133200
133200
133200
133200
133200
133200
133200
133200
133200
FY 2007
AMENDMENTS
(3,400.00)
(19,850.00)
20,000.00
25,137.00
423.00
(4,460.00)
2,372.00
1,654.00
500.00
8,730.00
(20,906.00)
$ (11,291.00)
$ (11,291.00)
$ (26,348.00)
681.00
(442.00)
(1,500.00)
(1,212.00)
9,201.00
(14,978.00)
(29,944.00)
66,050.00
(4,385.00)
6,316.00
(125.00)
(10,424.00)
(170.00)
(1,000.00)
(200.00)
(2,811.00)
$ (11.291.00)
$ (70,000.00)
70,000.00
$ (19,547.00)
(13,447.00)
30,402.00
(500.00)
(1,145.00)
(100.00)
587.00
10.00
(10.00)
500.00
/3
FY 2007
AMENDMENTS
133200 776666 1060231 3,250.00 Print Shop
Total Expenditures
Total Change in Fund
CSHCS Outreach and Advocacy Fund (#28563) -
Revenue
1060291 134420 610313
1060291 134420 615463
Expenditures
1060291
1060291
1060291
1060291
1060291
1060291
1060291
1060291
1060291
1060291
134420 702010
134420 722750
134420 730926
134420 730982
134420 731346
134420 750154
134420 732018
134420 750399
134420 770631
134420 776666
Expenditures
1060218
1060218
1060218
1060218
1060218
1060218
1060218
1060218
133910 702010
133910 722750
133910 730926
133910 731346
133910 770631
133910 770667
133910 774636
133910 775667
$ (1,516.00)
11,000.00
$ 9,484.00
(9,025.00)
18,263.00
(918.00)
248.00
57.00
850.00
15.00
(6.00)
$ 9,484.00
$ 5,271.00
6,000.00
$ 11,271.00
$ 6,882.00
(2,108.00)
6,211.00
100.00
659.00
(100.00)
125.00
500.00
333.00
(1,331.00)
$ 11,271.00
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2007 FIRST QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
ACCOUNT NUMBER
PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Immunization Action Plan Fund (#28550) - Grant #gr0000000182
Revenue
1060218 133910 610313
1060218 133910 615463
Grants - Federal
Grants Fees & Collections
Total Revenues
Salaries
Fringe Benefits
Indirect
Mileage
Bldg Space Alloc
Convenience Copier
IT Operations
Mail Room
Total Expendiitures
Total Change in Fund
Grant #gr0000000207
Grants - Federal
Grants Fees & Collections
Total Revenues
Salaries
Fringe Benefits
Indirect
Interpreter Fees
Mileage
Expendable Equip.
Travel & Conf.
Office Supplies
Bldg Space
Print Shop
Total Expenditures
Total Change in Fund
Infant Mortality Coalition Support Fund (#28547) - Grant #gr0000000285
Expenditures
1060231 133200 702010
1060231 133200 722750
1060231 133200 730072
1060231 133200 730926
1060231 133200 731346
1060231 133200 731458
1060231 133200 774677
1060231 133200 776666
$ 22,019.00
20,944.00
(35,340.00)
4,737.00
(5,563.00)
1,910.00
342.00
(9,049.0Q)
Salaries
Fringe Benefits
Advertising
Indirect
Mileage
Professional Svs.
Insurance Fund
Print Shop
Total Expenditures
Expenditures
1060291
1060291
1060291
1060291
1060291
133190 702010
133190 722750
133190 730926
133190 730982
133190 770631
Salaries
Fringe Benefits
Indirect
Interpreter Fees
Bldg. Space
Total Expenditures
Total Change in Fund
Health TB Outreach Fund (#28556) - Grant #gr0000000192
Revenue
1060201 133970 610313
1060235 133970 610313
Grants - Federal
Grants - Federal
Total Revenues
BT Lab Fund (#28605) - Grant #gr0000000277
Revenue
1050290 115140 610313
Expenditures
133970 702010
133970 722750
133970 730926
133970 731213
133970 731346
133970 750301
133970 750567
133970 774677
Salaries
Fringe Benefits
Indirect
Membership Dues
Mileage
Medical Supplies
Training-Educational Supp
Insurance Fund
Total Expenditures
Total Change in Fund
115140 702010
115140 722750
115140 730926
115140 731458
115140 732018
115140 750154
115140 750301
115140 778675
Salaries
Fringe Benefits
Indirect
Prof. Serv.
Travel & Conf.
Expend Equip
Medical Supplies
Telephone Comm
Total Expenditures
Total Change in Fund
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FiSCAL YEAR 2007 FIRST QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
ACCOUNT NUMBER
PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
MCH Maternal & Infant Support Fund (#28563) - Grant #gr0000000207
Revenue
1060291 133190 610313
Total Revenues
FY 2007
AMENDMENTS
$ (5,271.00)
$ (5,271.00)
$ (13,118.00)
746.00
4,550.00
1,662.00
889.00
$ (5,271.00)
Grants - Federal
Grants - Federal
Total Revenues
Expenditures
1060235
1060235
1060235
1060235
1060235
1060235
1060235
1060235
1060290
1060290
1060290
1060290
1060290
1060290
1060290
1060290
$ (49,724.00)
44,752.00
$ (4,972.00)
$ (5,869.00)
7,142.00
320.00
(494.00)
538.00
(6,750.00)
87.00
54.00
$ (4,972.00)
$ 7,198.00
$ 7,198.00
$ 3,898.00
3,146.00
2,999.00
3,500.00
(3,000.00)
(3,813.00)
293.00
175.00
$ 7,198.00
Vaccine Replacement/Handling Fund (#28560) - Grant #gr0000000200
Revenue
1060234 133990 610313 Grants-Federal
Total Revenues
$ (1,626.00)
$ (1,626.00)
$ (3,314.00)
4,598.00
(337.00)
(147.00)
Expenditures
1060234
1060234
1060234
1060234
133990 702010
133990 702010
133990 730926
133990 731346
Salaries
Fringe Benefits
Indirect Cost
Personal Mileage
FY 2007
AMENDMENTS
770631 133990
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2007 FIRST QUARTER BUDGET AMENDMENTS
PROPRIETARY I SPECIAL REVENUE FUNDS
ACCOUNT NUMBER
PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
1060234 Bldg. Space
Total Expenditures
Total Change in Fund
f2,426.00)
(1,626.00)
Nurse Family Partnership Fund (#28607) - Grant #gr0000000279
Expenditures
1060231 133200 702010
1060231 133200 722750
1060231 133200 730926
1060231 133200 730982
1060231 133200 731346
1060231 133200 731458
1060231 133200 732018
1060231 133200 770531
$ 16,559.00
9,878.00
(27,506.00)
(5,000.00)
(492.00)
1,399.00
5,000.00
162.00
Salaries
Fringe Benefits
Indirect Cost
Interpreter Fees
Mileage
Professional Serv.
Travel & Conference
Bldg. Space
Total Expenditures
WIC Fund (#28553) - Grant #gr0000000205
Revenue
1060284 133270 610313
1060284 133275 610313
1060284 133276 610313
Expenditures
1060284
1060284
1060284
1060284
1060284
1060284
1060284
1060284
1060284
1060284
1060284
1060284
1060284
1060284
1060284
1060284
1060284
1060284
1060284
$ 40,901.00
44,166.00
4,000.00
$ 89,067.00
$ 20,368.00
56,016.00
(48,746.00)
44,166.00
100.00
2,072.00
300.00
500.00
(2,340.00)
(500.00)
1,000.00
4,000.00
280.00
4,002.00
(500.00)
349.00
5,500.00
1,000.00
1,500.00
$ 89,067.00
133270 702010
133270 722750
133270 730373
133275 730373
133270 730646
133270 730926
133270 730982
133270 931059
133270 731346
133270 732018
133270 750154
133276 750170
133270 750301
133270 750399
133270 750567
133270 770631
133270 770667
133270 774666
133270 778675
Grants - Federal
Grants - Federal
Grants - Federal
Total Revenues
Salaries
Fringe Benefits
Contractual Svs.
Contractual Sys,
Equip Repairs
Indirect Cost
Interpreter Fees
Laundry & Cleaning
Mileage
Travel & Conf
Expendable Equip
Other Expendable Equip
Medical Supplies
Office Supplies
Training-Educational Supp
Bldg Space
Mail Room
Print Shop
Telephone Comm.
Total Expenditures
Total Change in Fund
BT Pan Flu (#28605) - Grant #gr0000000277
Revenue
1050290 133095 610313
133095 702010
133095 712020
133095 722750
133095 730926
133095 731941
133096 732165
133095 750077
Expenditures
1060290
1060290
1060290
1060290
1060290
1060290
1050290
Grants - Federal
Total Revenues
Salaries
Overtime
Workers Comp
Indirect Cost
Training-Educational Supp
Workshops and Meetings
Disaster Supplies
$ 339,830.00
$ 339,830.00
$ 48,826.00
79,774.00
4,444.00
14.702.00
37,548.00
850.00
29,873.00
1060290
1060290
1060290
1060290
1060290
1060290
1060290
1060290
133095
133095
133095
133095
133095
133095
133095
133095
1060211 133020 731346
1060211 133020 732018
Mileage
Travel & Conference
Total Expenditures
Total Change in Fund
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2007 FIRST QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
ACCOUNT NUMBER
PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
750154 Expendable Equip.
770631 Bldg. Space
774636 IT Oper
770667 Convenience Copier
774677 Insurance Fund
775667 Mail Room
776666 Print Shop
778675 Telephone Comm.
Toral Expenditures
Total Change in Fund
Disease (EWID) (#28307) - Grant #gr0000000277
Grants - Federal
732018 Travel & Conference
Total Change in Fund
Infectious Disease (EWID) (#28307) - Grant #gr0000000307
FY 2007
AMENDMENTS
25,970.00
7,600.00
2,308.00
125.00
335.00
9,000.00
78,000.00
475.00
339—t330.00
$ (5,000.00)
$ (5,000.00)
$ 4,640.00
$ 4,640.00
500.00
4,140.00
$ 4,640.00
Early Warning Infectious
Revenue
1060211 133020 610313
Expenditures
1060211 133020
Early Warning
Revenue
1060211 133020 610313
Expenditures
Grants - Federal
Total Revenues
/7
OAKLAND COUNTY
HEALTH DIVISION
Memo
Tim Soave
Manager
Fiscal Services
From: Tom Fockler, M.B.A.
Administrator
Public Health Administrative Services
Date: February 23, 2007
Re: Donation Acceptance
Per our conversation, the Health Division has accepted a donation in the amount of
$1,901.65 from RMHC Babies to purchase safety and developmental toys and items
for use in the Nurse Family Partnership Program. The requirements of this donation
are attached for your records.
Thank you.
TF:ch
Attachment
To:
21
Phone:
Email:
Fax:
(248) 424-7059
mcdanielsl@oakgov.com
(248) 424-7144
Required Response Form
RIVIIIC BABIES & NFP National Service Office
Please fax to Michelle Stapleton 303-3274260 by Friday, February -23, 2007
The Oakland County NFP will receive approximately $1901.65 (based on client
numbers) from RMHC BABIES to use toward the purchase of safety and developmental
toys and items as specified by the RMHC BABIES guidelines.
Please check the box below:
Yes! Oakland County NFP will participate in R_MHC BABIES
No. Oakland County NFP declines participation in RMHC BABIES
Primary contact for RMHC BABIES at Oakland County NFP:
Name: Lynn McDaniels
Maihng;axidress: Oakland County Health Division
27725 Greenfield Road, Southfield MI 48076
Agency check should be made payable to:
Name of Agency: count y of Oakland
Mailing address: 1200 N. Telegraph Road, Pontiac, MI 48341-0432
Phone: (248) 424-7059
FEIN: . FEIN 38-6004876.
An answer of 'Yes!' above and completion of this form means the NFP National Service
Office (NSO) will mail you a check to be spent on items described in the RMHC
BABIES guidelines, to be spent out by November 16,2007. It also requires a full
reporting of the funds spent to the NFP NSO.
Questions? Please contact Michelle Stapleton at 303-327-4277 or
mic.helle.stapleton®nursefamilypartnership.org
Please fax completed form to Michelle Stapleton at •
303-327-4260 no later than February 23,2007
77
Roan wit:Dm:Auk !Ulf CHARMS
0 7 . Pnrn,1,7*
N Partnership
RMHC BABIES
Dear NFP Team,
This letter is being sent to you to continue the good news about the Ronald McDonald House
Charities (RMHC) BABIES (Building a Better Infant Environment Safely) program for NFP
children. I am sure you can tell we are excited about it at the Nurse-Family Partnership (NFP)
National Service Office (NSO) and hopefully you are pleased as well.
RMHC BABIES will provide NFP agencies with funds to provide NFP children with essential
and safety items and developmental toys and books.
The grant period is March 1 through November 16, 2007.
Enclosed with this letter are two forms:
• RMHC BABIES Required Response Form
o Your check will be sent upon NFP NSO's receipt of all Response Forms
This form is due at NFP NSO no later than Feb. 23, 2007 — please fax
• Fund Usage Guidelines Form
o Provides a list of approved items to be purchased with the funds
o Provides a sample reporting format for tracking the expenditures
It has been an honor and a privilege to work with our friends at Ronald McDonald House
Charities (RMHC) and it is important that we all know about the work they do on behalf of
children.
Ronald McDonald House Charities, a non-profit, 501(c)(3), creates, finds and supports programs
that directly improve the health and well being of children worldwide. Its' goal is to make
an immediate, positive impact on as many children as possible through its global network of local
Chapters in 49 countries.
In addition to its cornerstone Ronald McDonald House program and the Ronald McDonald
Family Room and Ronald McDonald Care Mobile programs, the Charity makes grants to not-for-
profit organizations to help children everywhere. To date, Ronald McDonald House Charities and
its global network of local Chapters have awarded more than $440 million in grants to children's
programs worldwide.
We look forward to receiving your response form and moving forward with the RMHC BABIES
program. Please don't hesitate to contact us with any questions you may have.
Sincerely,
AL,A. • t •
Nan Butler
Chief Development Officer
Nurse-Family Partnership National Service Office
23
RMHC BABIES
Fund Usage Guidelines
Approved items to purchase:
• Diapers
• Formula
• Car seats
• Booster seats
• Strollers
• High chairs
• Infant seats
• Safety gates
• Safety locks
• Smoke/CO2 detectors
• Play yards
• Cribs and mattresses
• Child development equipment
• Early learning toys
• Books
All other items must be approved first by calling Michelle Stapleton at
303-327-4277 or emailing at
michelle.stapletonPnursefamilypartnership.org
All money must be spent by 11/16/2007 and a full reporting of how funddl
were spent must be mailed, faxed or emailed to Nurse-Family
Partnership National Service Office
Total Amount Received =
Item Brand & Description Amount Date of Expenditure Name of Store
Total:
96
NFP NSO Mailing: 1900 Grant Street, Suite 400 — Denver, CO 80203;
Fax: 303-327-4260; email:
michelle.stapleton@nursefamilypartnership.org
25
TOTAL 251' $395,893.15
Interoffice
MEMORANDUM
to: LaVerne Smith, Fiscal Servicees
cc: Judi Lockhart, Reimbursement
from: Joyce Raczka, Reimbursement
re: Inmate Waived Report
date: Feb 2007
Submitted for your review is the Inmate Report for 2006 for the Months of Oct, Nov and
Dec.
Number of Amount Waived
Accounts
OCT
NOV
DEC
06 077749 CZ 102 $187,354.00
06 078521 CZ 65 $83,296.15
06 079193 CZ 84 $125,243.00
From the desk of....
Joyce Raczka
Reimbursement
1200 N Telegraph Road
Pontiac, Michigan 48343
26
SCHEDULE C
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2007 FIRST QUARTER FINANCIAL REPORT
UNCOLLECTIBLE ACCOUNTS
Department
Economic Development
Information Technology
Vendor/Company Amount
Nomadica Development Co. 455.00
Total 455.00
Walter Quillico of Title Giant $ 1,165.89
Action Bail Bonds 1,000.00
First Advantage 610.64
Omega Research 303.62
Vista, Inc. 1,801.84
Countrywide Home Loans 2,090.00
Penisular Title Co. 704.00
Total $ 7,675.99
Total Uncollectible Accounts $ 8,130.99
97
FISCAL SERVICES DIVISION
Timothy J. Soave, Manager
COAKLAND; L BROOKS PATTERSON, OAKLAND COUNTY EXECUTIVE
COUNTY MICHIGAN
DEPARTMENT OF MANAGEMENT AND BUDGET
To: Nancy Fournier, Chief— Fiscal Services
From: Tim Soave, Manager — Fiscal Services
In Re: Write Off
Date: February 22, 2007
Please consider this authorization to write-off $455.00 owed the County by Nomadica
Development Co. It has been determined that this amount is uncollectible.
Page 1 of 4
LaVerne Smith
From: Timothy Soave [soavet@oakgov.com]
Sent: Tuesday, January 23, 2007 1:55 PM
To: 'Foumier, Nancy'; 'Smith, Laveme'
Subject: FW: Denied usage of Access Oakland (Walter Quillico/Home Title Connect)
Possible write off for quarterly forecast.
Original Message---
From: Mike Blaszczak [mailto:blaszczakm@oakgov.corri]
Sent: Tuesday, January 23, 2007 1:50 PM
To: 'Usa Oppmann'
Cc: Soave, Tim; Linda Spiekerman-Harvey; Poisson, Edwin; Cunningham, Judy; Lerminiaux, Keith
Subject: RE: Denied usage of Access Oakland (Walter Quillico/Home Title Connect)
Lisa,
If I understood your e-mail and phone message, the Registered Agent (i.e., Walter
Quillico) of World Wide Financial Title Company of Michigan, LLC., (doing business with
the County under its assumed name "Title Giant," Michigan Corporate ID# 24396)
resigned on 5/1/2006. Title Giant (which we are no longer doing business with) owes
the County $1165.89 in Access Oakland charges.
The voice mail you forwarded from Ann, at the State of Michigan, confirms what is on
the State's web site (http://www.dleg.state.mi.us/bcs_corp/dt_11c.asp?
id_nbr=1324396&name_entity=TITLE 0/020GIANT), that a successor Registered Agent has
not been appointed.
What I told you about the law requiring each domestic corporation to have a
"Registered Agent" was correct.
MCL 450.1241 Registered office and resident agent required.
Each domestic corporation and each foreign corporation authorized to
transact business in this state shall have and continuously maintain in this
state both of the following:
(a) A registered office which may be the same as its place of business.
(b) A resident agent, which agent may be either an individual resident in this
state whose business office or residence is identical with the registered
office, a domestic corporation, or a foreign corporation authorized to transact
business in this state and having a business office identical with the
registered office.
MCL 450.1243 Resignation of resident agent.
A resident agent of a domestic or foreign corporation may resign by filing a
written notice of resignation with the president or a vice president of the
corporation and with the administrator. The corporation shall promptly
appoint a successor resident agent. The appointment of the resigning agent
terminates upon appointment of a successor or upon expiration of 30 days
after receipt of the notice by the administrator, whichever first occurs. Upon
the resignation becoming effective, the business or residence address of the
resigned agent shall no longer be the registered office of the corporation.
Therefore, it appears that Title Giant neither pays its bills nor pays much attention to
29
Page 2 of 4
the state law.
Under the circumstances we discussed in November, I am not overly optimistic about
our chances of collecting this $1165.89 from Title Giant, or possibly even Walter
Quillico, (or the cost/benefit of trying) our possible recovery on this debt would now
seem to require a lawsuit (see my 11/13/06 e-mail, below).
The only possible alternative to filing a lawsuit at this time might be to send this debt to
the Reimbursement Division for its possible collection. Reimbursement has many tools
and techniques that you may not have available to you. Not only that, there are laws
regulating the collection of bad debts, that Reimbursement will have a better handle
than I.T. After all, this is what the Reimbursement Div. does.
--Original Message----
From: Usa Oppmann [mailto:oppmannl@oakgov.com]
Sent: Wednesday, January 17, 2007 10:05 AM
To: 'Mike Blaszczak'
Subject: RE: Denied usage of Access Oakland (Walter Quillico/Home Title Connect)
Mike,
Were you able to find out anything on this? I would like to respond back to the State. Thanks
----Original Message
From: Lisa Oppmann [mailto:oppmannl@oakgov.com]
Sent: Wednesday, January 10, 2007 4:48 PM
To: 'Mike Blaszczak'
Subject: FW: Denied usage of Access Oakland (Walter Quillico/Home Title Connect)
Mike,
This is the detail for the voice mail message I forwarded to you. I send the State of Michigan
DLEG the attached letter and the voice mail message is their response. I thought you had
mentioned that an active company was required to provide the name of their Resident Agent.
Please advise. Thank you.
-----Original Message-----
From: Mike Blaszczak [mailto:blaszczakm@oakgov.com]
Sent: Monday, November 13, 2006 3:26 PM
To: Oppmann, Lisa
Cc: 'Sharon Cullen'; Phil Bertolini; Wilk, Mike; Poisson, Edwin; Lerminiaux, Keith; Cunningham,
Judy; Davis, Patricia
Subject: RE: Denied usage of Access Oakland (Walter Quillico/Home Title Connect)
Lisa,
Per our earlier telephone conversation, and as you verified on the State Dept. of Labor
& Economic Growth website (http://www.dleg.state.mi.us/bcs_corp/sr_corp.asp),
Walter Quillico is the apparent C.E.O. of both the TITLE GIANT and HOME TITLE
corporations.
Further, the County contracted and is doing business with the companies and not Mr.
Quillico, personally.
30
Page 3 of 4
Thus, unless we can prove fraud etc., legally we cannot hold HOME TITLE responsible
(i.e., deny it service when its account balance is current) for the $1165.89 past due
debt of TITLE GIANT.
If Phil agrees, we might be able to pursue TITLE GIANT'S debt in court. Phil can
contact Keith Lerminiaux if he wishes to pursue this matter.
PRIVILEGED AND CONFIDENTIAL - ATTORNEY CLIENT COMMUNICATION
This e-mail is intended only for those persons to whom it is specifically addressed. It is confidential and is protected by the
attorney-client privilege and work product doctrine. This privilege belongs to the County of Oakland, and individual addressees
are not authorized to waive or modify this privilege in anyway. Individuals are advised that any dissemination, reproduction or
unauthorized review of this information by persons other than those listed above may constitute a waiver of this privilege and is
therefore prohibited. If you have received this message in error. please notify the sender immediately. If you have any questions.
please contact the Department of Corporation Counsel at (248) 858-0550. Thank you for your cooperation.
---Original Message
From: Sharon Cullen [mailto:cullensh@oakgov.com]
Sent: Monday, November 13, 2006 9:59 AM
To: 'Lisa Oppmann'
Cc: 'Blaszczak, Mike'; 'Davis, Patricia'; 'Lerminiaux Keith'; 'Cunningham, Judy';
'McCracken, Elaine'; 'Mike Wilk'; 'Janette McKenna'; 'Miller, Norma'
Subject: RE: Denied usage of Access Oakland (Walter Quillico/Home Title Connect)
Thanks Lisa,
I understand I will watch for the fax.
Sharon
Original Message-----
From: Lisa Oppmann [mailto:oppmannl@oakgov.corn]
Sent: Monday, November 13, 2006 9:56 AM
To: 'Sharon Cullen'
Cc: 'Blaszczak, Mike'; 'Davis, Patricia'; 'Lerminiaux Keith'; 'Cunningham, Judy';
'McCracken, Elaine'; 'Mike Wilk'; 'Janette McKenna'; 'Miller, Norma'
Subject: RE: Denied usage of Access Oakland (Walter Quillico/Home Title
Connect)
Sharon,
Yes, I did speak with Walter Quillico regarding his delinquent/deactivated
Access Oakland account. He had asked to speak with someone in the
Corporation Counsel department - I did not refer him. I will fax the
corresponding information to you. I have brought this to the attention of Mike
Wilk, but understand that he is not in the office today.
Please let me know if you need anything further. Thank you.
Lisa M. Oppmann
Supervisor, IT Internal Services
Oakland County Information Technology
1200 N. Telegraph Road, Bldg 49W
Pontiac, MI 48341-0421
(248) 858-1681
Original Message
From: Sharon Cullen [mailto:cullensh@oakgov.com]
Sent: Monday, November 13, 2006 9:44 AM
31
Page 4 of 4
To: Oppmann, Lisa
Cc: Blaszczak, Mike; Davis, Patricia; Lerminiaux Keith; Cunningham,
Judy; McCracken, Elaine
Subject: Denied usage of Access Oakland (Walter Quillico/Home Title
Connect)
Importance: High
Lisa,
I received a call this morning from Walter Quillico of Home Title Connect
(586-243-8577) indicating that he had spoken with you this morning
about his company being denied usage of Access Oakland and that
you asked him to contact Corporation Counsel. At this time I am unable
to locate any information regarding his issue and Mr. Quillico did not talk
with one of our attorneys, but I did indicate to him that someone from
this office will contact him as soon as possible.
If you have requested assistance from our office on this matter, can you
provide to me the name of the person you sent this information too? If
you haven't sent us any request yet, then please do so either by email
or by fax. I would like to make sure we are able to assist you in a timely
manner and answer Mr. Quillico's questions.
Thanks,
Sharon
OAKLANDT
COUNTY MICHIGAN
Sharon L. Cullen, Technical Assistant
Department of Corporation Counsel
1200 N. Telegraph Road, Bldg. 14 East
Courthouse West Wing Extension, 3rd Floor
Pontiac, MI 48341
Phone Number: (248) 858-1946
Fax Number: (248) 858-1003
E-mail: cullensh@oakgov.com
PRIVILEGED AND CONFIDENTIAL - ATTORNEY CLIENT
COMMUNICATION
This e-mail is intended only for those persons to whom it is specifically addressed. It is
confidential and is protected by the attorney-client privilege and work product doctrine. This
privilege belongs to the County of Oakland, and individual addressees are not authorized to
waive or modify this privilege in anyway. Individuals are advised that any dissemination.
reproduction or unauthorized review of this information by persons other than those listed above
may constitute a waiver of this privilege and is therefore prohibited. If you have received this
message in error, please notify the sender immediately. If you have any questions, please
contact the Department of Corporation Counsel at (248) 858-0550. Thank you for your
cooperation.
32
MEMORANDUM
To: Ed Poisson, Director
Information Technology
From: Jemarice Simpson
Subject: Request to Write-Off 2006 Delinquent Account
Date: January 22, 2007
Attached are delinquent accounts that LT. and Fiscal Services has made numerous
attempts to collect from without success. I am requesting your authorization to write-off
these accounts for 2006.
Thank you. -
Z a 0000000091-"*.N,ZM:01 -10/W0:01 LOCg OZ umacumms
MEMORANDUM
To: Fiona Brenner
Fiscal Services Division
From: Ed Poisson, Director
Information Technology
Subject: Action Bail Bonds
Date: January 22, 2007
Accept this as authorization to write off $1,200.00 charged to Action Bail Bonds,
Thank you.
34 •••••••....."0 nosa 4 000040009 4,ZM:OL'aSZOS:OL 400Z OZ OaACOMM)
MEMORANDUM
To: Fiona Brenner
Fiscal Services Division
From: Ed Poisson, Director
Information Technology
Subject: First Advantage
Date: January 22, 2007
Accept this as authorization to write off $610.64 charged to First Advantage.
Thank you.
MEMORANDUM
To: Fiona Brenner
Fiscal Services Division
From: Ed Poisson, Director
Information Technology
Subject: Omega Research
Date: January 22, 2007
Accept this as authorization to write off $303.62 charged to Omega Research.
Thank you.
MEMORANDUM
To: Fiona Brenner
Fiscal Services Division
From: Ed Poisson, Director
Information Technology
Subject: Vista Inc
Date: January 22, 2007
Accept this as authorization to write off $1,801.84 charged to Vista Inc.
Thank you.
m mmmemanaosit .mNVZS:01•15,CS:01 „LG.= OZ SMA(UMM)
• •
MEMORANDUM
To: Fiona Brenner
Fiscal Services Division
From: Ed Poisson, Director
Information Technology
Subject: Countywide Home Loans
Date: January 22, 2007
Accept this as authorization to write off $2,090.00 charged to Countrywide Home
Loans.
Thank you.
MEMORANDUM
mocsmeasstrArsssulawasserai
TO: FIONA BRENNER, FISCAL SVCS DIVISION
FROM: ED POISON. DIRECTOR INFORMATION TECHNOLOGY
SUBJECT: PENINSULAR TITLE CC)
DATE :1127/2007
CC: ii CON FORT', SUPERVISOR MSC-NI-SVCS, J. SIMPSON, INFO TECH-INTERNAL SVCS
Accept this as a-uthorization to write off $704.00 charged to Peninsular Title Co. as information
Technology and Fiscal Services has made numerous attempts to collect outstanding balance without
success.
Thank you
...4-•••• ...fa I..... I I 341.141•1 m imadm000loms-•ftess:01%Ls'esma Loom aim smacamm,
I 113E8y AppRovE FOREG RESOLONN
Resolution #07047 March 22, 2007
Moved by Rogers supported by Zack the resolutions (with fiscal notes attached) be adopted (with
accompanying reports being accepted).
AYES: Burns, Coleman, Coulter, Crawford, Douglas, Gershenson, Gingell, Gosselin, Gregory,
Greimel, Hatchett, Jacobsen, KowaII, Long, Middleton, Nash, Potter, Potts, Rogers, Scott,
Spector, Suarez, Woodward, Zack, Bullard. (25)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) were adopted (with
accompanying reports being accepted).
1111.••n.
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 March 22, 2007,
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 22nd day of March, 2007.
Ruth Johnson, County Clerk