HomeMy WebLinkAboutResolutions - 2011.04.21 - 18202MISCELLANEOUS RESOLUTION • #11068 pril 21, 2011
BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON
IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2011 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) 2011 First Quarter Financial Forecast Report has identified several variances
and budget amendments are recommended; and
WHEREAS A project work order for furniture in the Circuit Court - Juvenile Intake Unit was approved by the
Budget Task Force in FY 2010, and was carried forward into FY 2011 Budget per MR #10312 (FY 2010 Year-End
Report), and a budget amendment is recommended to transfer $10,106 from the Circuit Court to the Project Work Order
Fund (#40400) to complete the project; and
WHEREAS a budget amendment of $215,858 is recommended to transfer funds from the IT Fund (#63600) to the
General Fund 52nd Administration Division Budget to complete the court's implementation and conversion of the
Mainframe Enhancement project; and
WHEREAS the 52/2 District Court - Clarkston budget includes a grant match budget of $72,811 derived from
sobriety fees for the SCAO Drug Court Grant which ended on September 30, 2010. A budget amendment is requested to
recognize the ending of this grant and the related effect on the General Fund, with these funds to be credited towards the
52/2 District Court - Clarkston's Budget Task and to close out the remaining budget of $47,415 in the grant fund; and
WHEREAS a budget amendment is requested by the 52/4 District Court — Troy to reallocate $4,123 from
favorable Defense Attorney Fees to Expendable Equipment Expense to purchase new chairs for the judge per the review
and approval of the County Executive's Budget Task Force; and
WHEREAS an amendment is recommended to the Board of Commissioners' Budget to reallocate $2,000 from the
Membership Dues account to the Periodicals, Books, Publications, Subscriptions account to more accurately reflect the
budget with the account of the actual expenses; and
WHEREAS the Water Resources Commissioner (WRC) is requesting to amend the General Fund budget based
on revised projected revenue, as the Collaborative Asset Management System (CAMS) Project (per MR #07293) will
increase Reimbursement General revenue by $505,592 and expenditures of Salaries by $249,105, Fringes by $121,035
and Drain Equipment by $135,452. Planning, development, and testing phase hours is now expected in FY 2011 due to
project delay with an offset in reduced revenues and expenses in Sewage Disposal System Funds;
WHEREAS WRC also requests a $15,000 budget amendment to Reimbursement revenue to offset increase in
Salaries and Fringes for employee time allocated to various systems not covered by the Energy Efficient Conservation
Block Grant; and
WHEREAS the salaries and fringe benefits in the amount of $300,697 for the Prosecuting Attorney and staff were
inadvertently reduced in the budget, which is offset by voluntary pay reduction of elected officials, and a budget
amendment is recommended to reflect the appropriate salaries and fringes, with the offset in donations; and
WHEREAS the Prosecuting Attorney has requested a budget reduction of $10,000 in Library Continuation and
$12,096 in Telephone Communications due to cutbacks and consolidation of efforts to use these savings towards their
assigned budget tasks; and
WHEREAS the Sheriff's Office has requested the use of funds from Law Enforcement Deferred Revenue
accounts for the following purposes: $555 for Smart Bus tickets for transporting inmates (GL Acct #228105 --Jail Chapel
Deposits); $12,000 for payment of K-9 inserts (GL Acct #220430 — NET forfeitures); $16,030 for the purchase of two (2)
GPS Tracking devices ($7,563.75 from GL Acct #222460 Sheriff Training and $8,466.25 from GL Acct #222475 Crime
Suppression Task Force); and
WHEREAS due to an accounting change, the Sheriff's Office is anticipating an increase in Civil Action Service
Fees expense of $1,380,000, which is offset by an increase in Civil Action Service Fee revenue; and
WHEREAS the Sheriff's Office is anticipating $1.7 million in additional revenue for Diverted Felons from the State,
and wishes to increase donations by $5,545 to offset salaries and fringes due to the elected official voluntary pay
reduction, offset by ($68,000) reduction in Federal Operating State Grant revenue no longer received for patrol grant, and
($100,000) reduction in revenue in Inmate Board and Care, due to increase in use of Tethering Program; and
WHEREAS the Treasurer's Office has requested an amendment of $5,545 to recognize donated revenue to
reflect the elected official voluntary pay reduction; and
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote.
WHEREAS the revenue budget for the Equalization Division is overstated by $341,-o99 as a result of duplicate
posting of some municipal equalization contracts, which had been planned for renewal and included in the adopted
budget, but then approved by various misc. resolutions at time of renewal; and
WHEREAS the Planning and Economic Development Services Division (PEDS) is requesting amendments for the
following:
-$12,180 in revenues and expenditures for an expanded economic forecast for the Economic Growth Alliance with
costs reimbursed by the Alliance members.
-Reallocate total of $189,003 from PEDS Emerging Sectors to PEDS Administration to more accurately reflect
program operating expenditures.
-Reallocate $65,000 from Marketing & Communications' Professional Services to Advertisement to more
accurately reflect anticipated operating expenditures; and
WHEREAS a budget amendment is recommended for FY 2011 and FY 2013 to correct data entry of budget
allocations for the Health Division's Zero to Three Secondary Prevention Grant previously approved per MR #10137; and
WHEREAS a budget amendment is recommended to the Children's Village budget to reallocate favorability of
$19,900 from Laundry and Cleaning to Incentives (rewards to children for good behavior) and Professional Services
(contracted nursing) to more accurately reflect actual costs; and
WHEREAS the Prosecutor is in need of hiring additional experts to assist with the complexity of the medical
marijuana legal enforcement issues and is requesting $25,000 to cover initial expenses; and
WHEREAS the Board of Commissioners' Per Diems was inadvertently omitted from the budget in the amount of
$5,600, and
WHEREAS Property Tax Revenue is projected to be favorable in FY 2011, and a budget amendment is
recommended to cover some increased expenses; and
WHEREAS a budget amendment is recommended in revenue and expenditures to delete the Circuit Court's
Bureau of Juvenile Justice Grant Fund budget (#27195) totaling $62,500, which ended September 30, 2010; and
WHEREAS a budget amendment is recommended to reallocate funds of $12,600 within the Children's Village
Division's Second Chance Act Adult and Juvenile Offender Reentry Demonstration Projects Grant from Contracted
Services to Expendable Equipment Expense to purchase office equipment for grant funded positions; and
WHEREAS the Economic Development Corporation (EDO) Board has approved the FY 2011 Special Revenue
Budget for the EDC (#21180) in the amount of $83,500 which is an increase of $10,500 from the FY 2011 Adopted
Budget. The updated budget includes a Transfer Out amount not to exceed $21,000 to the Business Finance Corporation
Fund (#21184), and a budget amendment is recommended to reflect the $83,500 budget approved by the EDC for FY
2011-FY 2013, as well as include the transfer of funds in the amount of $21,000 to the Business Finance Corporation
Fund (#21184); and
WHEREAS a budget amendment is recommended in the amount of $7,802 for the Building Liability Fund
(#67700) to reflect the budget where expense is incurred for purchase of defibrillator supplies; and
WHEREAS a reappropriation of $115,910 in the Office Equipment Fund (#66400) for Indirect Cost is
recommended, as the original budget was based on estimated costs and has since been revised with more accurate
information; and
WHEREAS the Motor Pool Fund (#66100) has increased the number of purchases of used vehicles rather than
new vehicles to save costs in Law Enforcement operations, and it is recommended a budget amendment of $40,000 be
made to adjust the revenue and expense accounts for these purchases; and
VVHEREAS an amendment is recommended for the CLEMIS Fund (#53500) to accept a contribution in the
amount of $77,788 from Washtenaw County 911 for the development, operation, and support of the Computer Aided
Dispatch which is an allowable expense under the Emergency 911 Service Committee's published report; and
WHEREAS the Department of Information Technology has requested a budget amendment in the amount of
$278,026 to reappropriate funds previously approved by the Board of Commissioners for various IT projects such as
Medical Examiner's and CAMS where implementation is continuing in FY 2011, and funding is available in the IT Fund
Net Assets-Designated for Projects Fund Balance; and
WHEREAS it is requested the Facilities Management & Operations Fund (#63100) be amended to reallocate a
total of $240,000 within the fund's operational budget to segregate the Road Salt and Security Supplies; and
WHEREAS a budget amendment of $64,800 is requested in the Fringe Benefit Fund (#67800) to reflect the
merger of the Deferred Compensation Board and the Retirement Board as one unit; and
WHEREAS a budget amendment of ($12,096) is recommended to the Telephone Communications Fund
(#67500) to reflect the savings in revenue and expense for the Prosecutor's efforts, and
WHEREAS the Rose Township Tr-Party Party Project #50482, was originally approved per MR #10179 at a total
project cost of $10,557 of which the County agreed to fund $3,519. On November 15, 2010, the Rose Township Board of
Trustees approved a revised project total to $38,337 thus changing the County's total share to $12,779 for gravel on Fish
Lake Road. Funding for the additional $9,260 (county share) is available in the General Fund Designated Fund Balance
for Tr-Party funding (GL acct #371510); and
WHEREAS the Sheriff's budget for Aviation Fuel is insufficient by $20,000 to support the increase in fuel cost for
the Sheriff's helicopter, and funding is available in the General Fund Designations for Fuel/Mileage Increase (GL Acct
#371463); and
GENERAL FUND (10100)
Revenues
9010101-196030-665882
Expenditures
9010101-153010-740135
4030601-116220-750210
1050525-183192-788001-67800
1090201-171000-788001-21180
9010101-134860-788001-20221
ECONOMIC DEVELOPMENT CORPORATION FUND (21180)
Revenues
1090202-171110-695500-10100
Total EDC Fund Rev
Transfer In from General Fund
Expenditures
1090202-171110-731458 Professional Services
Total EDC Fund Exp
WHEREAS an amendment is requested to transfer $50,000 designated in the General Fund Balance for Wellness
for Dependents (GL Acct #371513) to the Human Resources Wellness Program to fund the expansion of Health
Screening to County employees' dependents; and
WHEREAS MR #10248 authorized a designation of $100,000 in the General Fund Balance for FY 2011 for the
Oakland Micro-Loan Program (GL acct #371468) which requires a transfer from the General Fund to the Economic
Development Corporation Special Revenue Fund (#21180); and
WHEREAS per MR #11024, the Department of Health and Human Services and Department of Information
Technology identified upgrades that will save costs and improve the functionality of the eHealth Foods software previously
developed to accommodate food service establishment licensing inspection and complaint enforcement responsibilities at
a project cost of $607,751. Funding will be provided by favorability in Health Personnel of $353,260 and the balance of
funding of $254,491 from the General Fund Designation for Operational Improvements (GL Acct #371350) and a budget
amendment is recommended; and
WHEREAS the Health Division is in need of new countertops in the Public Health Laboratory, and funds were
transferred from favorability within the Health Division's Bioterrorism Grant Fund (#28605) to the Project Work Order Fund
(#40400) in FY 2010, at a cost of $8,751, and authorization is requested to proceed with the project work order; and
WHEREAS a multi-workout station was donated to the Sheriff's Office for the workout room at the Oakland
Township Substation.
NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year 2011 First
Quarter Financial Report.
BE IT FURTHER RESOLVED that the FY 2011, FY 2012, and FY 2103 Budgets be amended pursuant to
Schedules A and B.
BE IT FURTHER RESOLVED funds totaling $433,751 from the FY 2011 Designated Fund Balance be
appropriated for Rose Township Tr-Party Project #50482 — additional funding $9,260, Oakland County Micro-Loan
Program $100,000, Expansion of Health Screening — Wellness for Dependents $50,000, Sheriff's Aviation Fuel Expense
$20,000, and eHealth Foods Software Project $254,491 as follows:
FRINGE BENEFIT FUND (67800)
Revenue
1050525-183192-695500-10100
Expense
1050525-183192-731458
FY 2011
Planned Use of Fund Balance $433,751
Total GF Revenues $433,751
Non-Dept - Tr-Party $ 9,260
Sheriff's Patrol Svcs — Gasoline Charges 20,000
Transfer Out to Fringe Benefit Fund 50,000
Transfer Out to EDC Fund 100,000
Transfer Out to Health Fund 254,491
Total GE Expenditures
$ 50,000
Total Fringe Benefit Fund Rev $ 50.000
$ 50,000
Total Fringe Benefit Fund Exp $ 50,000
Transfer In from General Fund
Professional Services
HEALTH FUND (20221)
Revenues
9090101-134860-695500-10100 Transfer In from General Fund
Total Health Fund Rev
FY 2011
$100,000
$100.000
$100,000
$100. 000
$254,491
$254,491
Transfer In from Health Fund
Total Info Tech Fund Rev
Expense
1080201-152010-731458 Professional Services
Total Info Tech Fund Exp
INFORMATION TECHNOLOGY FUND (63600)
Revenue
1080101-152000-695500-20221 $607,751
W07,751
$607,751
$607,751
Expenditures
1060236-133390-702010
1060236-133390-722740
1060201-133150-788001-63600
Field Nursing — Salaries
Field Nursing — Fringe Benefits
Admin Transfer Out to Info Tech
Total Health Fund Exp
($214,958)
( 138,302)
607,751
$254,491
BE IT FURTHER RESOLVED that the donation be accepted for the Sheriff's Office multi-workout station.
Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution,
FINANCE COMMITTEE
Ito i(q2)
41692SSIMMIISIVDM
Laurie Van Pelt, Director
S 3,003,750
6,493.290
$ 9,497,040
$ (1,044,372)
953,191
( 91,181)
S 9.405,859
Revenues - over/ (under) budget
Expenditures -- (over)/under budget
Total Officially Reported Favorability
S 3,006,150
(1.044,372)
S_1,961,778
L. BROOKS PATTERSON, OAKLAND COUNTY EXECUTIVE
COUNTY MICHIGAN
DEPARTMENT OF MANAGEMENT AND BUDGET
TO: Members of the Finance Committee
FROM: Laurie Van Pelt, 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 2011 First Quarter Report
DATE: March 15, 2011
FY 2011 FIRST QUARTER REPORT
Attached please find the Fiscal Year (FY) 2011 First Quarter Forecast Report. in total. Fiscal Services forecasts that
the County will complete Fiscal Year 2011 with overall favorability of $9,405,859 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 $9,497,040 more revenue than anticipated and projected unfavorability in
expenditures of ($91,181).
The variances listed above are presented to reflect the true fiscal activity of the County for FY 2011 as detailed below:
Revenue Variance
Add back — Planned use of Fund Balance
Revenue Variance (Comparing Actual to Approved Plan)
Expenditure Variance
Planned Set Aside for Budget Transition
Expenditure Variance (Comparing Actual to Approved Plan)
Net Variance from FY 2011 Activity
The above presentation differs from the County's financial reports, which are prepared in accordance with Generally
Accepted Accounting Principals (GAAP), The variances, if presented purely according to G-AAP would he:
The differences in the presentation revolve around the Planned.. Use of Fund Balance (on the revenue side) and the
Planned Set Aside for Budget Transition (on the expenditure side).
The amended revenue budget assurried the use of $6,493,290 in fund balance. Although use of fund balance
was budgeted, GAAP does not allow fund balance to be "recorded as revenue" creating a negative variance
because revenue is budgeted (anticipated), but not received (recorded). The required presentation ignores
that the County planned to use fund balance; in reality there is no negative variance.
Likewise, on the expenditure side, the budget included a planned positive variance of $953,191 which
reflects "credits" provided for each elected official based upon the fact that they accelerated budget
reductions. These credits will be reappropriated in future fiscal years in order to smooth the process of
structural budget reductions. These positive variances were planned before the fiscal year began and
therefore do not reflect expenditure favorability from reduced expenditures experienced during FY 2011.
7.
By removing these planned negative and positive variances from the presentation, the presentation will more accurately
reflect the impact of fiscal activity generated from FY 2011 operations.
EXECUTIVE OFFICE BUILDING 41 WEST • 2100 PONTIAC LAKE RD DEPT 409 • WATERFORD MI 48328-0409 (248) 858-2163 • FAX (248) 452-9172
EMAIL: vanpelti@oakgov.ccm P1
REVENUES
GE/GP revenues are 2.44% more than budget or $9,497,040. Favorability is forecasted for Property Taxes and
Charges for Services while most other areas are expected to be unfavorable at year end. Major variances are the result
of the following events:
A. TAXES - Favorable: $6,845,800
• The budget estimated a decline of 12% in taxable values; the decline in taxable values is less than estimated at
budget time.
B. CHARGES FOR SERVICES — Favorable: $3,205,340
• Sheriff: Diverted Felon revenue is expected to be $1.7 million. Favorability from the civil processing contract
of $1.5 million will be offset by unfavorable expenditures. Favorability from Deputy contracts is offset by loss
of revenue from jail board and care.
• Clerk: Favorability of $309,600 is anticipated primarily from Enhanced Access program fees, $200,000,
Certified Copies, $105,000 and Gun Permits, $125,000 and a partial offset for Forfeiture of Bonds ($100,000).
9 Water Resources Commissioner: $520,600 favorable for CAMS program (Collaborative Asset Management
system) for expenditures due to program delay. See Expenditure offset.
• Management and Budget/Equalization: Unfavorable forecast of ($368,000) due to duplication in counting of
contracts.
C. STATE GRANTS — Unfavorable: ($750,000)
• Reduced state funding is the result of reduced Child Care fund costs. The revenue is more than offset by
projected reduced expenditures. Expenditures are estimated to be favorable for Foster Boarding Homes,
Private Institutions Residential and Foster Care totaling $1.5 million.
D. OTHER INTERGOVERNMENTAL REVENUE — Unfavorable: ($228,600)
• Cigarette Tax revenue is anticipated to be ($340,000) unfavorable which is partially offset by forecasted
favorability for sheriff Marine income from local CVTs for lake patrols.
E. INDIRECT COST RECOVERY - Unfavorable: ($300,000)
• Estimated forecast includes reduced activity from construction projects, grants and proprietary funds. Funding
from proprietary funds is less due to the closing of the Printing Mailing and Copier fund.
EXPENDITURES
In total, expenditures are projected to be (0.02%) over budget or ($91,181). Note that this favorable forecast includes
accelerated reductions which will be used to offset future budget shortfalls.
It will be noticed that a number of departments or divisions are forecasted to exceed their personnel appropriation's. It is
important to note, the these projected variances and NOT the result of overall personnel expenditures being higher
than anticipated — in fact personnel related cost continue to fall. The issue, as is explained below, is a result of the
fringe benefit budget, particularly related to retirement and hospitalization cost, not being adequate enough to account
for the anticipated expenditures. Essentially — this is a situation where the individual department's budgets are
inaccurate — NOT a situation where the costs have increased
Regarding retirement, the negative variance does NOT reflect an increase in retirement cost, rather it appears that the
appropriations provided for Elected Officials and Departments did not sufficiently account for the large number of
vacancies and positions filled at less than full capacity. The County charges actual fringe benefit cost to each
department; unfortunately the rate used for budgeting purposes did not appropriately reflect the true charge.
This is a similar situation regarding hospitalization charges. In this situation the County pays the actual cost of care out
of the Fringe Benefit Fund. In order to obtain sufficient revenue to pay the actual charge, Elected Officials and
Departments are charged "illustrative rates"; based upon an employee's family status and particular plan. Unfortunately
the illustrative rates are not reflecting the actual use of this benefit. It is important to note that the cost of this benefit
P2
has been basically flat for the last couple of years, with a slight inflationary increase; the illustrative rates charged to
departments are not adequate to cover the actual charges.
In both cases, review of the rates and costs are being conducted. Fiscal Services wishes to evaluate the situation for at
least one more quarter and will recommend amendments with the second quarter financial forecast.
As the year progresses this overall net favorability may increase as departments continue to work to reduce their costs
and reorganize. The only departments projected to be unfavorable at the end of the fiscal year (barring any
amendments) are the Sheriff's Office, Board of Commissioners, Library Board, Water Resources Commissioner,
County Executive and Public Services.
A. Sheriff's Office — Unfavorable: $(4,828,700)
• The department is forecasted unfavorable due to salaries and fringe benefits related to overtime and holiday
overtime and fringe benefits for medical and retirement. Overtime is used to cover vacancies and annual leave.
Holiday overtime is unfavorable due to arbitrator awarded salary increases. Operating Expenditures is
forecasted as unfavorable by $1.5 million for civil processing costs (offset by increased revenue).
B. Board of Commissioners — Unfavorable: $(5,600)
• Unfavorable personnel costs due to increased medical and retirement partially offset by favorahility from
turnover.
C. Library Board — Unfavorable: $(6,000)
• Unfavorable personnel cost due to increased medical and retirement.
D. Water Resources Commissioner — Unfavorable: $(520,592)
• Unfavorable personnel and internal service costs due to Collaborative Asset Management System project
(CAMS). One time project costs were budgeted in FY 2010 but due to delay actual costs are being incurred in
FY 2011. Note offsetting favorability in revenue.
E. County Executive Administration Division — Unfavorable: $(4,700)
▪ Unfavorable personnel costs due to increased medical and retirement partially offset by favorability from
turnover. Favorability of $27,000 is expected in Professional Services.
F. Public Services — Unfavorable: $(81,500)
• Unfavorable personnel cost due to increased medical and retirement.
Note that while individual divisions may be over budget, the budget is controlled at the department level. The General
Appropriations Act requires that appropriations accumulate at the following three summary levels of expenditures
within each County Department and are deemed maximum authorization for expenditures: Personnel Expenditures,
Operating Expenditures and Internal Support Expenditures.
P3
PLANNED USE OF FUND BALANCE (1) 200,000 00 $ 6,493,290 13 $ 6,493,290.13 0.00%
TOTAL GE/GP FUNDS S 383.199.390.00 388,742.013.13 S 398.239.053.13 $ 9,497.040.00 2.44%
9,405,859.00 9,405,859.00
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
SUB-TOTAL GENERAL FUND/GENERAL PURPOSE
REVENUES
GENERAL FUND
Taxes
Federal Grants
State Grants
Other Intergovernmental Revenue
Chaeges for Services
Indirect Cost Recovery
Investment Income
Other Revenues
FY 2011
ADOPTED
BUDGET
$ 192,809,210.00
938,320 00
20,077,106.00
11,277,284.00
81,520,438.00
9,317,500.00
2,616,300.00
64,443,232.00
$ 382.999,390.00
BUDGET
AS
AMENDED
$ 192,809,210.00
907,616.00
19,900,748.00
11,348,534.00
80,827,753.00
9,317,500 00
2,616,300.00
64,521,362.00
$ 382,248,723.00
FY 2011
FORECAST
$ 199,655,010.00
839,616.00
19,150,748.00
11,119,934.00
84,033,093.00
9,017,500.00
3,015,300.00
64,914,562.00
391,745,763.00
Afv1OHNT
FAVORABLE/
(UNFAVORABLE) PERCENT
6,845,800.00 3.55%
(68,033.00) -7.49%
(750,000.00) -3.77%
(228,600.00) -2.01%
3,205,340.00 3.97%
(300,000.03) -3.22%
399,000,00 15.25%
393,500.00 0,61%
$ 9,497,040.00 246%
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court
52nd District Court
Probate Court
TOTAL ADMIN. OF JUSTICE
LAW ENFORCEMENT
Prosecuting Attorney
She riff
TOTAL LAW ENFORCEMENT
GENERAL GOVERNMENT
Clerk/Register of Deeds
Treasurer
Board of Commissioners
Library Board
Water Resources Commissioner
TOTAL GENERAL GOVERNMENT
COUNTY EXECUTIVE
County Executive Admn.
Management and Budget
Central Services
Facilities Management
Human Resources
Health and Human Services
Public Services
Economic Dev. and Comm Affairs
TOTAL COUNTY EXECUTIVE
TOTAL DEPARTMENTS
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NON-DEPARTMENTALS
TOTAL GOVERNMENTAL EXPENDITURES
$ 50,877,852.00
16,919,493.00
6,092,206.00
$ 72,839,551.00
18,514,269.00
119,660,893.00
$ 138;175,162.00
10,723,498.00
3,523,869.00
2,913,354.00
1,421,119.00
4,936,145.00
$ 23,517,985.00
$ 5,705,589.00
19,761,465.00
2;026,525.00
1,304,046.00
4,071,409.00
64,078,741.00
15,215,429.00
7,089,816.00
$ 119,253,020.00
$ 353,835,718.00
$ 29,363,672.00
$ 383,199,390.00
51,239,458.00
15,977,006.00
6,115.666.00
$ 73,332,130.00
18,703.971 40
119,454.148 53
S 138,158,119.93
10,764,673.00
3,640,748.00
2,914,378.00
1,421.485.00
4,971,870.00
$ 23,713,154.00
$ 5,711,335.00
19,898,768.00
. 2,033,488 00
1,304,117.00
4,124,556.00
66,885,943.76
15,263,771.44
7,415,859.00
$ 122,641,143.20
$ 357,844.547.13
$ 30,897,466.00
$ 388 742,013,13
$ 50,835,458.00 $ 404,000.00 0.79%
15,679,495.00 297,511.00 1.86%
6,097,666.00 18,000.00 0.29%
72,612,619.00 719,511.00 0.98%
18,367,571.40 336,400.00 1.80%
124,282,548.53 (4,828,700.00) -4.04%
$ 142,650,419.93 S (4,492,300.00) -3.25%
10,423,173.00 341,500.00 3.17%
3,631,448.00 9,300.00 0.26%
2,919,978.00 (5,600.00) -0.19%
1,427,485.00 (6,003.00) -0.42%
5,492.462.00 (620,592.00) -10.47%
23,894,546.00 $ (181.392.00) -0.76%
5,716,035.00 $ (4,700.00) -0.08%
19,632,368.00 266,400.00 1.34%
2,033,488.00 0.03%
1,255,417.00 48,700.00 3.73%
4,034,856.00 90,000.00 2.18%
63,795,648.76 3,057,300.00 4.62%
15,345,271.44 (81,500.00) -0.53%
6,962,059.00 450,800.00 6.16%
118,778,143.20 $ 3,863,000.00 3.15%
357,935.728.1.3 5 (91,181.00;1 -0.03%
30.597,466.00 0.03%
388 833 194.13 S (91,181.00) -0.02%
General Fund/General Purpose
Favorable/(Unfavorable)
(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.
P20
1GF/GP OPERATIONS - SELF BALANCING AMENDMENTS
GENERAL FUND (#10100)
Dept
Circuit Court
Expenditures
Program Fund Aff. Account Name Acct
(10,106.00) $
10,106.00
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2011 / 2012 12013 FIRST QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2011
AMENDMENTS
FY 2012 FY 2013
AMENDMENTS AMENDMENTS
3010101 121100 750154 Circuit Court Admin - Exp Equip Exp
3010101 121100 788001 40400 Transfer Out to Project Work Orders
Total Circuit Court Expenditures
52nd District Court - Administration
Revenue
3020101 121021 695500 63600 Transfer In From Info Tech Fund
Total Dist Court - Admin Rev
$ 215,858.00 _$ -
$ 215,858.00 $
Expenditures
3020101
3020101
3020101
3020101
3020101
3020101
3020101
3020101
3020101
3020101
3020101
3020101
3020101
3020101
3020101
3020101
3020101
3020101
3020101
3020101
3020101
121021
121021
121021
121021
121021
121021
121021
121021
121021
121021
121021
121021
121021
121021
121021
121021
121021
121021
121021
121021
121021
702180 21427
712020 21427
722750 21427
722770 21427
722790 21427
722820 21427
702180 21454
712020 21454
722750 21454
722770 21454
722790 21454
722820 21454
702180 21426
712020 21426
722750 21426
722770 21426
722790 21426
722820 21426
702180 21420
712020 21420
722750 21420
Emergency Salaries (Dist Ct - I)
Overtime
Worker's Compensation
Retirement
Social Security
Unemployment
Emergency Salaries (Dist Ct - II)
Overtime
Worker's Compensation
Retirement
Social Security
Unemployment
Emergency Salaries (Dist Ct - Ill)
Overtime
Worker's Compensation
Retirement
Social Security
Unemployment
Emergency Salaries (Dist Ct - IV)
Overtime
Worker's Compensation
26,734.00 $
28,084.00
331.00
16,173.00
4,111.00
118.00
26,734.00
3,927.00
331.00
2,518.00
909.00
118.00
53,468.00
9,125.00
552.00
5,756.00
1986,00
236.00
26,734.00
3,927.00
331.00
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2011 / 2012 / 2013 FIRST QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2011
AMENDMENTS
FY 2012 FY 2013
AMENDMENTS AMENDMENTS
GENERAL FUND (#10100)
Dept Program Acct Fund Aft Account Name
3020101 121021 722770 21420 Retirement
3020101 121021 722790 21420 Social Security
3020101 121021 722820 21420 Unemployment
Total Dist Court Admin Exp.
2,518.00
909.00
118.00
$ 215,858.00 S - $ _ . -
52nd District Court - Division II (Clarkston)
Expenditures
3020305 113290 788001 27160 Transfer Out to SCAO Drug Court Grant $ (72,811.00) $ (72,811.00) $ (72,811.00)
3020301 121020 740023 Budget Transition $ 20,000.00 5 20,000.00 $ 20,000.00
9010101 196030 740023 Budget Transition 52,811.00 52,811.00 52,811.00
Total 52-2 District Court Exp. - $ - $
52nd District Court - Division IV (Troy)
Expenditures
3020501 121020 730450 Defense Attorney Fees (4,123.00) $
3020501 121020 750154 Expendable Equipment Expense 4,123.00
Total 52-4 District Court Exp. $ _ - $
Board of Commissioners - Administration
Expenditures
5010101 180010 731213 Membership Dues $ (2,000.00) $ (2,000.00) $ (2,000.00)
5010101 180010 731329 Periodicals Books Publications Subs 2,000.00 2,000.00 2,000.00
Total BOC Administration Exp $ - $ _ - $ -
Water Resources Commissioner
Revenue
6010101 155010 631827 Reimbursement - General $ 520,592.00 $ - $ -
Total Water Resources Comm Rev $ 520,592.00 $ - $ .....7___
Expenditures
6010101 155010 702010 Salaries $ 258,480.00 $ - $
6010101 155010 722740 Fringe Benefits 126,660.00
6010101 155010 771639 Drain Equipment 135,452.00 - _
Total Water Resources Comm Exp $ 520,592.00 $ - $ -
(10,000.00)
10,000.00
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2011! 2012 / 2013 FIRST QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2011
AMENDMENTS
GE/GP OPERATIONS - SELF BALANCING A -
GENERAL FUND (110100)
Dept Program Acct Fund Aff. Account Name
ENDMENTS
FY 2012 FY 2013
AMENDMENTS AMENDMENTS
Prosecuting Attorney
Revenues
4010101 122000
4010201 122050
4010301 122050
4010401 122050
650301 Admin - Donations
650301 Litigation - Donations
650301 Warrants - Donations
650301 Appellate - Donations
Total Prosecuting Attorney Revenues
18,193.00 $
205,353.00
39,358.00
37,793.00
300,697.00 $
18,193.00 $
205,353,00
39,358.00
37,793.00
300.697,00 $
Expenditures
4010101
4010201
4010301
4010401
4010101
4010101
9010101
122000 702010 Admin - Salaries
122050 702010 Litigation - Salaries
122050 702010 Warrant - Salaries
122050 702010 Appellate - Salaries
122050 731101 Admin - Library Continuation
122000 778675 Admin - Telephone Communications
196030 740023 Non-Dept - Budget Transition
Total Prosecuting Attorney Expenditures
18,193.00 $
205,353.00
39,358.00
37,793.00
(10,000.00)
(12,096.00)
22,096.00
300,697,00 $
18,193.00 $
205,353.00
39,358.00
37,793.00
(10,000,00)
10,000,00
300,697.00 $ _
Sheriffs Office
Revenues
4030401 112650
4030601 116210
4030901 116270
670285 Corrective Svcs Satellite - Enhance Funds $ 555.00 $
670285 Patrol Svcs - Enhancement Funds 12,000.00
670285 Investigative/Forensic - Enhancement Funds 16,030.00
Total Sheriffs Office Revenues $ 28,585.00 $
Expenditures
4030301
4030601
4030901
112620 724024 Corrective Services - Transp of Prisoners
112580 750170 Patrol Svcs - Other Expendable Equip
116270 760157 Investigative/Forensic - Capital Equipment
Total Sheriff's Office Expenditures
555.00 $
12,000.00
16,030.00
28,585,00 $
FY 2013
AMENDMENTS
3,861.00 $
1,684.00
5,545.00 $
3,861.00 $
1,684.00
5,545.00 $
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2011 / 2012 / 2013 FIRST QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2011 FY 2012
AMENDMENTS AMENDMENTS
5,545.00 $
1,700,000.00
1,380,000.00
(100,000.00)
(68,000.00)
2,917,545.00 $
GF/GP OPERATIONS- SELF BALANCING AMENDMENTS
Acct Fund Aff. Account Name
650301 Admin - Donations
630553 Corrective Services - Diverted Felons
630238 Corrective Svcs - Civil Action Svc Fees
630959 Corrective Svcs - Inmate Board & Care
610313 Patrol Svcs - Federal Operating Grants
Total Sheriffs Office Revenues
5,545.00 $
1,700,000.00
1,380,000.00
(100,000.00)
(68.000,00)
2,917,545.00 $ 1,212,000.00
GENERAL FUND #10100)
Dept Program
Sheriffs Office
Revenues
4030101 112580
4030301 112620
4030301 112590
4030301 112590
4030601 110000
1,380,000.00
(100,000.00)
(68,000,00)
1,212,000.00
Expenditures
4030301
4030101
4030101
9010101
112590 730716 Corrective Svcs - Fees Civil Service
112580 702010 Sheriff Salaries
112580 722000 Sheriff Fringes
196030 740023 Non-Dept - Budget Transition
Total Sheriffs Office Expenditures
$ 1,380,000.00 $ 1,380,000.00
3,861.00 $ 3,861.00
1,684.00 $ 1,684.00
1,532,000.00 1,532,000.00
$ 2,917,545.00 $ 2,917,545.00
$ 1,380,000.00
(168,000.00)
$ 1,212,000.00
Treasurers Office
Revenue
7010101 186040 650301 Admin - Donations
Total Treasurer's Office Revenues
5,545.00 $
5,545.00 $
5,545.00 $
5,545.00 $
Expenditures
7010101
7010101
186040 702010 Treasurer's Salaries
186040 722000 Treasurer's Fringe Benefits
Total Treasurer's Office Expenditures
M&B - Equalization Division
Revenue
1020501 186020 631813 Reimbursement - Equalization Services
Total M&B - Equalization Division Rev,
(341,899.00) $ (341,899,00) $ (341,899.00)
(341,899.00) $ 341,899.00j $ (341,899.00)
Expenditure
9010101 196030 740023 Non-Departmental - Budget Transition
Total M&B - Equalization Division Exp.
$ (341,899.N) $ (341,899.00) $ (341,899 00)
(341,899.00) 5 (341,899.00) $ (341,899.00)
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2011/ 2012/ 2013 FIRST QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2011
AMENDMENTS
IGF/GP OPERATIONS-SELF BALANCING AMENDMENTS
FY 2012 FY 2013
AMENDMENTS AMENDMENTS
GENERAL FUND (#10100)
Dept Program Acct Fund Aff.
Economic Development Administration
Revenue
1090201 171000 631827
Account Name
PEDS / Reimbursement General
Total PEDS Revenue
12,180.00 $ 12,180.00 $ 12,180.00
12,180.00 $ 12,180.00 $ 12,180.00
Expenditures
1090108
1090108
1090201
1090201
1090201
1090201
1090201
1090201
1090201
1090201
1090201
1090201
1090201
1090201
1090201
1090201
1090201
1090201
1090201
1090201
1090201
1090201
1090201
1090201
1090201
1090201
171030 730072 Marketing & Comm / Advertising
171030 731458 Marketing & Comm / Professional Services
171000 731213 PEDS / Membership Dues
171000 731339 PEDS / Periodicals Books Publ Sub
171000 731458 PEDS / Professional Services
171000 731780 PEDS / Software Support Maintenance
171000 730072 PEDS / Advertising
171000 730205 PEDS / Business Recruitment
171000 730772 PEDS / Freight & Express
171000 731346 REDS! Personal Mileage
171000 731388 PEDS / Printing
171000 732018 PEDS / Travel & Conference
171000 732165 PEDS / Workshops & Meetings
171000 750119 PEDS / Dry Goods & Clothing
171115 730072 Emerging Sectors/Advertising
171115 730205 Emerging Sectors / Business Recruitment
171115 730772 Emerging Sectors / Freight & Express
171115 731213 Emerging Sectors! Membership Dues
171115 731339 Emerging Sectors Periodicals Books Pub
171115 731346 Emerging Sectors/Personal Mileage
171115 731.388 Emerging Sectors / Printing
171115 731458 Emerging Sectors! Professional Svcs
171115 731780 Emerging Sectors/Software Support Maint
171115 732018 Emerging Sectors/Travel & Conference
171115 732165 Emerging Sectors / Workshops & Meetings
171115 750119 Emerging Sectors / Dry Goods & Clothing
Total Econ Dev Exp
65,000.00
(65,000.00)
6,530.00
(275.00)
(4,075.00)
37,713.00
25,000.00
108,680.00
5,500.00
4,060.00
9,500.00
3,000.00
2,550.00
3,000.00
(25,000.00)
(108,680.00)
(5,500.00)
(1,530.00)
(4,725.00)
(4,060.00)
(9,500.00)
(13,745.00)
(7,713.00)
(3,000.00)
(2,550.00)
(3,000.00)
12 180 00 , .
65,000.00 65,000.00
(65,000.00) (65,000.00)
6,530.00 6,530.00
(275.00) (275.00)
(4,075.00) (4,075.00)
37,713.00 37,713.00
25,000.00 25,000.00
108,680.00 108,680.00
5,500.00 5,500.00
4,060.00 4,060.00
9,500.00 0,500.00
3,000.00 3,000.00
2,550.00 2,550.00
3,000.00 3,000.00
(25,000.00) (25,000.00)
(108,680.00) (108,680.00)
(5,500.00) (5,500.00)
(1,530.00) (1,530.00)
(4,725.00) (4,725.00)
(4,060.00) (4,060.00)
(9,500.00) (9,500.00)
(13,745.00) (13,745.00)
(7,713.00) (7,713.00)
(3,000,00) (3,000.00)
(2,550.00) (2,550,00)
(3,000,00) _ _(3,000.00_)
12,180.00 S 12,180.00 _
GENERAL FUND (#10100)
Revenue
9010101 196000 601637 Non-Departmental - Property Tax Levy
Total GE/GP Rev
Expenditures
4010101 122050
5010101 180010
731458 Prosecuting Attorney - Professional Svcs
702110 BOG- Per Diems
Total GF/GP Exp
5,600.00 $
5,600.00 $
- $
5,600.00
5,600.00 $
30,600.00 $
30,600.00 $
25,000.00 $
5,600.00
30,600.00 $
5,600.00
5,600.00
5,600.00
5,60000
Non-Departmental
Expenditures
9010101 134860
9090101 196030
HEALTH FUND (#20221)
Revenues
9090101 134860
1060236 133355
1060231 133215
(237,123.00) $
237,123.00
- $ 448,780.00
(448,780.00)
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2011/ 2012 /2013 FIRST QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2011
AMENDMENTS
GF/GP OPERATIONS - SELF BALANCING AMEN
GENERAL FUND (#10100)
Dept Program Acct Fund Aft. Account Name
ENTS
FY 2012 FY 2013
AMENDMENTS AMENDMENTS
788001 20221 Transfer Out to Health Fund
730800 Non-Dept Grant- Match
Total Non-Dept Expenditures
695500 10100 Transfer from General Fund
615571 Health State Operating
615571 Health State Operating
Total Health Fund Revenues
$ (237,123.1)0) $ - $ 448,780.00
272,740,00 - (472,997.00)
(40,519.00)
$ 35,617.00_ $ _ - $ (64,736.09)
Expenditures
1060236
1060236
1060236
1060236
. 1060236
1060236
1060235
1060236
1060236
LI)
133355 702010 Health Div Field Nursing - Salaries
133355 722770 Health Div Field Nursing - Fringes
133:355 730926 Health Div Field Nursing - Indirect Cost
133355 730982 Health Div Field Nursing - Interpreter Fees
133355 731346 Health Div Field Nursing - Personal Mileage
133355 731388 Health Div Field Nursing - Printing
133355 731941 Health Div Field Nursing - Contracted Serv.
133355 731997 Health Div Field Nursing Transp of clients
133355 750301 Health Div Field Nursing - Medical Supplies
153,571.00 $
83,552.00
16,152 00
2,030.00
3,386.00
437.00
8,559.00
44.00
(264,778.00)
(143,483.00)
(35,758.00)
(3,500.00)
(5,850.00)
(750.00)
(8,559.00)
(96.00)
(75.00)
467.00
58.00
2,975.00
(1,256.00)
117.00
870.00
1,778.00
(153,571.00)
(83,552.00)
35,617.00 $
(800.00)
(100,00)
(4,500.00)
-
(200.00)
(1,500.00)
(3,048.00)
264,778.00
143,483.00
(64,736.00)
(19,900.00) $
10,000.00 $
9,900.00
- $
(19,900.00) $
10,000.00 $
9,900.00 _
- $
(19,900.00)
10,000.00
9,900.00
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2011 1 201212013 FIRST QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
.a
1GF/GP OPERATIONS- SELF BALANCING A
FY 2011
AMENDMENTS
END MENTS
FY 2012 FY 2013
AMENDMENTS AMENDMENTS
Fund Aff.
GENERAL FUND (#10100)
Dept Prom Acct
1060236 133355 750399
1060236 133355 750448
1060236 133355 750567
1060236 133355 770631
1060236 133355 770067
1060236 133355 774677
1060236 133355 778675
1060236 133390 702010
1060236 133390 722770
CHILD CARE FUND (#20293)
HHS - Children's Village Division
Expenditures
1060501 112090 731059
1060501 112100 731458
1050501 112090 750245
Account Name
Health Div Field Nursing - Office Supplies
Health Div Field Nursing - Postage
Health Div Field Nursing - Training/Ed Supp
Health Div Field Nursing - Bldg Space cost
Health Div Field Nursing - Cony Copier
Health Div Field Nursing - Insurance Fund
Health Div Field Nursing - Tele Comm
Health Div Field Nursing - Salaries
Health Div Field Nursing - Fringes
Total Health Fund Exp
CV - Laundry & Cleaning
CV - Professional Services
CV - Incentives
Total Children's Village Division Exp
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2011 / 2012 / 2013 FIRST QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
ACCOUNT NUMBER
PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Aff Oper Unit Account Name
Circuit Court Family court Services - Bureau of Juvenile Justice Grant Fund (#27195)
Grant Detail GR #0000000400
Revenue
3010402 121200 645571 Cir Ct - Drug Ct - State Operating Grants
Total Cir Ct Drug Court Grant Rev
FY 2011 FY 2012 FY 2013
AMENDMENTS AMENDMENTS AMENDMENTS
(62,500.00) $ (62,500.00) $ (62,500,00)
(62,500,00) $ (62,500.00) $ (62,500.00)
Expenses
3010402
3010402
3010402
121200 730373 Cir Ct - Drug CL - Contracted Service
121200 732018 Cir Ct - Drug Ct. - Travel & Conference
121200 750280 Cit Cl - Drug Ct. - Laboratory Supplies
Total Cir Ct Drug Court Grant Exp
(51,400.00) $ (51,400.00) $ (51,400.00)
(4,883.00) (4,883.00) (4,883.00)
(6,217.00) (6,217.00) (6,217.00)
(62,500,00) $ (62,500,00) $ (62,500.00)
52/2 District Court SCAO Drug Court Grant Fund (#27160) .
Grant Detail GR #0000000243 . .
Revenues
3020301 121050 615571 State Operating Grants $ (14,000,00) $ (14,000.00) $ (14,000.00)
3020301 121050 695500 10100 Transfer In from General Fund (33,415.00) (33,415.00) (33,415.00)
Total 52/2 DC SCAO Drug Ct Rev $ (47,415.00) $ (47,415.00) $ (47,415.00)
Expenses
3020301 121050 702010 Salaries Regular $ (27,441.00) $ (27,441.00) $ (27,441,00)
3020301 121050 722750 FB - Worker's Compensation (61.00) (61.00) (61.00)
3020301 121050 722760 FB - Group Life (99.00) (99.00) (99.00)
3020301 121050 722770 FB - Retirement (8,971.00) (8,971.00) (8,971.00)
3020301 121050 722780 FB - Hospitalization (4,214.00) (4,214.00) (4,214.00)
3020301 121050 722790 FB - Social Security (2,100.00) (2,100.00) (2,100.00)
3020301 121050 722800 FB - Dental (398.00) (398.00) (398.00)
3020301 121050 722810 FB - Disability (107.00) (107.00) (107.00)
3020301 121050 722820 FB - Unemployment Insurance (55„00) (55.00) (55.00)
3020301 121050 722850 FB - Optical (19.00) (19,00) (19.00)
3020301 121050 732018 Travel & Conference . (1,000.00) (1,000.00) (1,000.00)
3020301 121050 750280 Laboratory Supplies _ (2,950.00) (2,950.00) _ (2,950.00)
Total 52/2 Dist Ct SCAO Drug Ct Grant Exp $ (47,415.00) $ _ (47,415.00) $ _ (47,415.00)
Second Chance Act Adult and Juvenile Offender Reentry Demonstration Projects Grant Fund (28014)
Bud Ref 2011 / GR0000000537
Expenses
1060501 112090 730373 Contracted Services (12,600.00) $ - $
1060501 112090 750154 Expendable Equipment 12,600.00
Total Grant Fund Expenses - $ - $
FY 2011 FY 2012 FY 2013
AMENDMENTS AMENDMENTS AMENDMENTS
21,000.00 $ 21,000.00
21,000.00 $ 00
21,000.00 $ 21,000,00
21,000.00 $ 21,000.00
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2011 / 2012 / 2013 FIRST QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
ACCOUNT NUMBER
I PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Aff Oper Unit Account Name
Economic Development Corporation (EDC) Fund (#21180)
Revenues
1090202 171110 630280
1090202 171110 655385
Closing Fee
Income From Investments
Total EDC Fund Revenues
$ 10,000.00 $ 10,000.00 $ 10,000.00
500.00 500.00 500.00
$ 10 500 00 $ 10 500 00 $ ..L.,—_- . —_, .... ' ' _ 10r500'00
Expenses
1090202 171110 730072 Advertising $ (2,500.00) $ (2,500.00) $ (2,500.00)
1090202 171110 731213 Membership Dues (1,000.00) (1,000.00) (1,000,00)
1090202 171110 731388 Printing (1,000.00) (1,000.00) (1,000.00)
1090202 171110 731507 Public Notices (3,000.00) (3,000.00) (3,000.00)
1090202 171110 731818 Special Event Program (3,000,00) (3,000.00) (3,000.00)
1090202 171110 788100 21184 Transfer Out to Bus. Finance Corp Fund 21,000.00 21,000.00 21,000.00
Total EDC Fund Expenses $ 10,500.00 $ 10,500.00 $ 10,500.00
Business Finance Corporation Fund (#21184)
Revenue
1090202 171100 695500 21180 Transfer In from EDC Fund $ 21,000.00 $
Total BFC Fund Rev $ 21 000 00 $ , _
Expense
1090202 171100 796500 Budget Equity Adjustments $ 21,000,00 $
Total BFC Fund Exp $ 21,000.00 $
Building Liability Fund (#67700)
Expenses ,
1010502 182000 760126 Capital Outlay $ (7,802.00) $ - $
1010502 182000 750154 Expendable Equipment 7,802.00 - _
Total Bldg Liability Fund Exp $ l
Office Equipment Fund (#66400)
Expenses
1020640 182060 730926 Indirect Costs (115,910.00)
1020640 182060 796500 Budgeted Equity Adjustment 115,910.00 -
Total Office Equipment Fund Exp $ — - $ - $ - _
Motor Pool Fund (#661001
Revenue
1030811 184010 675660 Gain on Sale of Vehicles $ 40,000.00 $ - $ -
Total Motor Pool Fund Rev $ 40,000.00 $ - $
Expenses
1030811 184010 730114 Auction Expense $ 5,000.00 $ - $ -
—0 1030811 184010 730726 Indirect Costs (10,638.00) - -
--I 1030811 184010 730840 Insurance (3,100.00)
015
77,788.00 $
77,788.00 $
77,788.00 $
77,788.00 $
- $
- $
- $
- $
- $
10,106.00 $
10,106.00 $
10,106.00 $
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2011 / 2012 / 2013 FIRST QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
ACCOUNT NUMBER
IPROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Aff Oper Unit Account Name
1030811 184010 731150 Maintenance Contract
1030811 184010 750154 Expendable Equipment
. Total Motor Pool Fund Exp
Change in Fund Equity
FY 2011
AMENDMENTS
3,100.00
45,538.00
40,000.00 $
- $
FY 2012 FY 2013
AMENDMENTS AMENDMENTS
Info Tech - CLEMIS Fund (#53500)
Revenue
1080305 116020 690189
Expense
1080305 116020 731458 Professional Services
Total CLEMIS Fund Expense
Change in Fund Equity
Contributions
Total CLEMIS Fund Revenue
Information Technology Fund (#63600)
Revenue
1080101 152000 6565882 Planned Use of Fund Balance
Total Info Tech Fund Revenue
493,884.00 $
493,884.00
Expenses
1080201
1080201
1080101
152010 731773 Software Rental
152010 731458 Professional Services
152000 788001 10100 Transfer Out to GF-Dist Ct Admin
Total Info Tech Fund Expenses
Change in Fund Equity
15,899.00 $
262,127.00
215,858.00
493,884.00 $
- $
Facilities Maintenance and Operations Fund (#63100)
Expenses
1040725 140500 750485
1040770 145000 750490
1040725 140500 750224
1040719 141000 750287
FM&O/Road Salt
FM&O / Supplies
FM&O / Grounds Supplies
Fl1/1&0 / Maintenance Supplies
Total FM&O Fund Exp
150,000.00 $ 150,000.00 $
90,000.00 90,000.00
(80,000.00) (80,000 00)
(160,000,00) (160,000.00)
- $
150,000.00
90,000.00
(80,000.00)
(160,000.00)
FM&O - Project Work Orders Fund (#40400)
Project ID #100000001456 Project Activity: PROJ - Juvenile Intake Furniture
Revenue
1040801 148020 695500 10100 Transfer In from General Fund - Circuit Court
Total FM&O - PWO Fund Rev;
Change in Fund Equity
- $
SOS Fund (#586001
Revenue
6010101 149030 632086 (30,335.00) $
(30,335.00) $
Sewage Disposal Services
Total SDS Fund #58600 Rev
(14,946.00) $
(7,262.00)
(8,127.00)
$ (30,335.00) $ _ -
(209,132.00) $ - $
(209,133.00)
(418,265.00) $
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2011! 2012/ 2013 FIRST QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
ACCOUNT NUMBER
FY 2011 FY 2012 FY 2013
AMENDMENTS AMENDMENTS AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Aff Oper Unit Account Name
SOS Fund (#58410)
Revenue
6010101 149030 632086 Sewage Disposal Services (41,657.00) $ - $
Total SDS Fund #58410 Rev $57 41 (.6.00) $ . _ _ - $
Expenses
6010101 149030 702010 Salaries (19,928.00) $ - $
6010101 149030 722740 Fringe Benefits (10,893.00)
6010101 149030 771639 Drain Equipment (10,836.00)
Total SDS Fund #58410 Exp $ (41,657.00) $
SDS Fund (#58530}
Revenue
6010101 149030 632086 Sewage Disposal Services (30,335.00) $
Total SDS Fund #58530 Rev $ (30,335.00) $
Expenses
6010101 149030 702010 Salaries
6010101 149030 722740 Fringe Benefits , 6010101 149030 771639 Drain Equipment
Total SDS Fund #58530 Exp
(14,946.00) $
(7,262,00)
(8,127.00)
(30,335.00) $
Expenses
6010101 149030 702010 Salaries
6010101 149030 722740 Fringe Benefits
6010101 149030 771639 Drain Equipment
Total SDS Fund #58600 Exp
SDS Fund (#570101
Revenues
6010101 149030 632086 Sewage Disposal Services
6010101 149030 632450 Water Sales General
Total SDS Fund #57010 Rev
FY 2011 FY 2012 FY 2013
AMENDMENTS AMENDMENTS AMENDMENTS
ii
- $ - $ Change in Fund Equity
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2011 12012/ 2013 FIRST QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
ACCOUNT NUMBER
[PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Aff Oper Unit Account Name
Expenses
6010101 149030 702010 Salaries $ (208,560.00) $ - $
6010101 149030 722740 Fringe Benefits (101,243.00)
6010101 149030 771639 Drain Equipment (108,362.00) -
Total SDS Fund #57010 Exp $ (418,265.00) $ _ - $
Fringe Benefit Fund (#67800)
Revenues
9011501 183190 630483 Deferred Comp $ (64,800.00) $ (64,800.00) $ (64,800.00)
9011501 183190 631953 Retirement Administration 64,800.00 64,800.00 64,800.00
Total Fringe Benefit Fund Revenues $ - $ - $ -
Expenses
9011501 183185 731073 Deferred Comp - Legal Services $ (10,000,00) $ (10,000.00) $ (10,000.00)
9011501 183185 731213 Deferred Comp - Membership Dues (500.00) (500.00) (500.00)
9011501 183185 731248 Deferred Comp - Monitoring Services (50,000.00) (50,000.00) (50,000.00)
9011501 183185 731339 Deferred Comp - Periodicals, Books Publ Sub (200.00) (200,00) (200.00)
9011501 183185 732018 Deferred Comp - Travel & Conf (3,500.00) (3,500.00) (3,500.00)
9011501 183185 750399 Deferred Comp - Office Supplies-Awards (100.00) (100.00) (100.00)
9011501 183185 776666 Deferred Comp - Print Shop (500.00) (500.00) (500.00)
9011502 183190 731073 Retirement Admin - Legal Services 10,000.00 10,000.00 10,000.00
9011502 183190 731213 Retirement Adrnin - Membership Dues 500.00 500.00 500.00
9011502 183190 731248 Retirement Admin - Monitoring Svcs 50,000.00 50,000.00 50,000.00
9011502 183190 731339 Retirement Admin - Periodicals, Books, Pub 200.00 200.00 200.00
9011502 183190 731388 Retirement Admin - Printing 500.00 500.00 500.00
9011502 183190 732018 Retirement Admin - Travel & Conf 3,500.00 3,500.00 3,500.00
9011502 183190 750399 Retirement Admin - Office Supplies-Awards 100.00 100.00 100.00
Total Fringe Benefit Fund Exps $ - $ - $ -
Telephone Communications Fund (#67500)
Revenue
1080601 152000 632009 Sale of Plione Service Internal $ (12,096.00) $ - $
Total Telephone Comm Fund Rev $ (12,096.00) $ - $
Expense
1080601 152000 730324' Communications $ (12,096.00) $ - $
Total Telephone Comm Fund Exp. $ (12,096.00) $ - $
Change in Fund Equity - $ - $
FY 2011
FORECAST
Adopted
Budget
Amended
Budget
(750,000.00)
68,000.00
82,000.00
169,947.00
46,000.00
272,373.00
300,000.00
938,320.00 $
192,546,710.00 $
98,500.00
76,000.00
88,000.00
192,809,210.00 $
199,397,010.00 $
98,500.00
76,000 00
83,500.00
199,655,010.00 $
- $ (68,000.00) -100.00% Budget loaded in error.
82,000.00 0.00%
139,243.00 0.00%
46,000.00 0.00%
272,373.00 0.00%
300,000.00 0.00%
839,616.00 $ (68,000.00) -7.49%
8,940,000,00
125,250.00
4,500.00
2,500.00
315,590.00
1,960,694.00
11,348,534.00
8,600,000.00 $
125,250.00
4,500.00
2,500.00
426,990.00
1,960,694.00
$ 11,119,934.00 $
(340,000.00) -3.80% Unfav Cigarette Tax Revenue.
0.00%
0.00%
0.00%
111,400.00 35.30% Fav due to add' patrols on county lakes.
- 0.00%
(228,600,00) -2.01%
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FY 2011 FIRST QUARTER REPORT
Amount
Favorable
(unfavorable) Percent Explanation of Significant Variances
6,850,300.00
(4,500.00)
6,845,800,00
TAXES (601000-601999)
Property Taxes - July Tax Levy
Other Taxes - Delinquent Tax - Prior Years
Treasurer Payment in Lieu of Taxes
Other Taxes - Trailer Tax
Total Taxes
FEDERAL GRANTS (610000-610999)
Sheriff - Patrol
Sheriff - Corrective Services
Prosecuting Attorney
Homeland Security - Disaster Control
Health Division
Children's Village
Total Federal Grants
STATE GRANTS (615000-615999)
Sheriff - Patrol
State Match Foster Care
Prosecuting Attorney
Economic Development
Health Division
Non-Departmental - Child Care Subsidy
192,546,710.00 $
98,500.00
76,000.00
88,000.00
192,809,210.00 $
1,000.00
169,947.00
4,947,460.00
14,958,699.00
68,000.00 $
82,000.00
139,243.00
46,000.00
272,373.00
300,000.00
907,616.00
3,750.00 $ 3,750.00 $
1,000.00 1,000.00
139,243.00 139,243.00
4,798,056.00 4,798,056.00
14,958,699.00 14,208,699.00
3.56% Drop in Taxable Value was less than anticipated.
0.00%
0.00%
-5.11% Reflects reduction in activity.
3.55%
0.00%
0.00%
0.00%
0.00%
0.00%
-5.01% Unfav. variance is offset by Child Care Fund expenditure
favorability. Built into the Circuit Court Family Division,
Health Administration, and Children's Village Budgets
are Child Care Fund expenditures. A favorable variance
within these areas reduces the 50% reimbursement the
county receives.
Total State Grants 20,077,106.00 $ 19,900,748.00 $ 19,150,748.00 $ (750,000.00) -3.77%
OTHER INTER-GOVERNMENTAL REVENUES (620000 - 626999)
Non-Departmental 8,940,000.00 $
HHS - Homeland Security 54,000.00
Circuit Court 4,500.00
District Court 2,500.00
Sheriff 315,590.00
Non-Departmental - Reim Judges Salaries 1,960,694.00
Total Other Intergovernmental Revenue $ 11.277,284.00 $
r%3 Revenue variance is partially offset by an expenditure variance.
FY 2011
FORECAST
Adopted
Budget
Amended
Budget
3,040,000.00
1,941,000.00
4,501,600.00
3,040,000.00
1,941,000.00
4,501,600.00
3,040,000.00
1,941,000.00
4,501,600.00
1,865,500.00
4,204,000.00
1,865,500.00
4,204,000.00
2,227,000.00 2,227,000.00
515,300.00 515,300.00
$ 18,294,400.00 $ 18,294,400.00
500,300.00 $ 420,300.00 $
1,379,136.00
704,900.00
32,372,002.00
1,379,136 00
804,928.00
31,633,189.00
196,900.00
442,100.00
1,043,266.00
196,900.00
442,100.00
1,043,266.00
792,392.00 792,392.00
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FY 2011 FIRST QUARTER REPORT
Amount
Favorable
(unfavorable) Percent Explanation of Significant Variances
CHARGES FOR SERVICES (630000-635999)
Administration of Justice
Circuit Court - Civil/Criminal
Circuit Court - Family Division
District Court - Division I (Novi)
0.00%
0.00%
0.00%
37,430,996.00 $
District Court - Division II (Clarkston)
District Court - Division III (Rochester Hills)
District Court - Division IV (Troy)
Probate Court - Estates and Mental Health
Total Administration of Justice
Law Enforcement
Prosecuting Attorney
Sheriff's Office
Sheriff - Administrative Services
Sheriff - Corrective Services
Sheriff - Corrective Services Satellites
Sheriff - Emergency Response and Prepard.
Sheriff - Patrol Services
Sheriff - Investigative Forensic Services
Total Law Enforcement
1,865,500.00
4,134,000.00
2,227,000.00
515,300.00
18,224,400.00 $ (70,000.00)
422,300.00 $ 2,000.00
196,900 00
442,100.00
2,548,566 00
710,036.00 (669,100.00)
2,384,928.00 1,580,000.00
32,220,389.00 587,200.00
793,992.00 1,600.00
36,712,211.00 $ 39,719,211.00 $ 3,007,000 00
0.00%
-1.67% Unfav. Probation Fees due to a decline in caseload and
a decrease in the public's ability to pay.
0.00%
0.00%
0.48% Fav. variance due to receipt of intermittent, non-
budgeted revenue that fluctuates year to year such as
Extradition Recovery Fees, Microfilming, and Welfare
Fraud Case Review.
0.00%
0.00%
144.29% Fav. due to anticipated receipts of Diverted Felon
revenue $1,690,300, partially offset by unfav Board and
Care of ($85,000) and Inmate Board and Care of
($100,000). Roth reductions are attributable to the
Tether program.
-48.52% Unfav, reflects decline in revenue for Board and Care
due to increase in use of the Tether program.
196.29% Fay due to establishment of Civil Action Service and
Processing Fee revenue. A budget amendment is
recommended to recognize this increase and offsetting
exp.
1.86% Fav due to net increase in billable patrol contract deputy
positions of $584,500 and receipt of Liquor Control fee
revenue of $2,700.
0.20% Fay, due to increased receipts of Confiscated Property '
revenues in excess of budgeted amount.
(70,000.00)
1,505,300.00
CO ' Revenue variance is partially offset by an expenditure variance.
rta
Adopted
Budget Percent Explanation of Significant Variances
Amount
Favorable
(unfavorable
FY 2011
FORECAST
Amended
Budget
2,420,493.00 $ 2,420,493.00 $
260,375.00 260,375.00
7,200,200.00 7,200,200.00
1,985,100.00
600.00
27,000.00
1,498,295.00
1,985,100.00
600.00
27,000.00
1,498,295.00
174,975.00 (85,400.00)
285,000.00 7,485,200.00
7,400.00
520,600 00
GENERAL FUND / GENERAL PURPOSE REVENUES
FY 2011 FIRST QUARTER REPORT
13,392,063.00 S 13,392,063.00 $
General Government
Clerk - County Clerk
Clerk - Elections
Clerk - Register of Deeds & Micrographics
Treasurer
Board of Commissioners
Library Board
Water Resources Commissioner
Total General Government
2,530,493.00 $ 110,000.00
1,992,500.00
600.00
27,000.00
2,018,895.00
14,229,663.00 $ 837,600.00
4.54% Fav. Certified Copies $105,000 and Gun Permits
$125,000 and Garnishment Fees $20,000 due to an
increase in activity; partially offset by Unfav. Forfeiture of
Bonds ($100,000), Bond Fees ($20,000) and Notary
Commission ($20,000) due to a decrease in counter
activity.
-32.80% Unfav. Reimbursement General due to local school
election consolidation.
3.96% Fav. Enhanced Access Fees $200,000 due to an
increase in online activity. Also Fav. Land Transfer Tax
$15,000, Deeds $20,000, Mortgages 930,000 and
Recording Fees $20,000 due to an increase in housing
activity.
0.37% Fav Misc Rev. $2,000, Reimbursement of Salaries
$3,200, and Alternate Energy $2,200; actual revenue
received for these accounts greater than anticipated.
0.00%
0.00%
34.75% Fav - Reimbursement General $505,592 due to the
Collaborative Asset Management System (CAMS)
project planning/requirements phase; original estimate
included developmenbtesting phase hours now
expected in FY 2011; offset by unfavorable salaries,
fringes and drain equipment. Also, Fav -
Reimbursement General $15,000 for WRC employees
time allocated to various systems not covered by the
Energy Efficient Conservation Block Grant, which will be
offset by unfavorable salaries and fringes. A budget
amendment is recommended to reflect the updated
revenue estimates from the CAMS project.
" Revenue variance is pnnialty ofIset by an expenditure variance.
03
FY 2011
FORECAST
Amended
Budget
Adopted.
Budget
County Executive
County Exec - Administration
County Exec - Corp Counsel
M&B - Purchasing Division
M&B - Equalization Division
170,000.00
3,545,714.00
170,000.00
3,571,814.00
M&B - Fiscal Services Division
Central Services - Support Services
Facilities Engineering
Human Resources
HHS - Administration
HHS - Health Division
HHS - Children's Village
HHS - Homeland Security
Public Services - Community Corrections
Public Services - MSU Extension
Public Services - Medical Examiner
Public Services - Animal Control
Economic Dev. & Comm. Affairs - Admin
Economic Dev. & Comm. Affairs - PEDS
800.00
150,000.00
2,747,837.00
800.00
150,000.00
2,747,837.00
2,887,496.00 2,887,496.00
415,600.00
121,350.00
415,600.00
121,350.00
300,000.00
29,495.00
189,000.00
785,887.00
419,800.00
300,000.00
29,495.00
189,000.00
785,887.00
419,800.00
COUNTY OF OAKLAND
GENERAL FUND! GENERAL PURPOSE REVENUES
FY 2011 FIRST QUARTER REPORT
Amount
Favorable
(unfavorable) Percent Explanation of Significant Variances
0.00%
1,800.00 100.00% Recovery on a judgement.
0.00%
(368,000.00) -10..30% (Unfav) as budget inadvertently overstated for CVT
Board approved contracts which were also included in
the adopted budget. A budget amendment is
recommended.
415,600.00 0.00%
44,990.00 (76,360.00) -62.93% Unfav vending machines sales ($70,300).
0.00%
0.00%
(150,000.00) -100.00% Receipt of funding depends or contract termination and
insurance payment.
(81,700.00) -2.97% Unfav. Dental Service Fees ($20,000) due to lower fees
charged. Unfav. Reirith Contracts ($61,716) due to
nonrenewal of Southfield contract.
0.00%
0.00%
300,000.00 0.00%
29,495.00 0.00%
189,000.00 0.00%
785,887.00 0.00%
0.00%
294,800.00 (125,000.00) -29.78% Unfav. reimbursement for NO HAZ Program due to
reduced resident participation (NO HAZ costs are
correspondingly fav).
1,800.00
170,000.00
3,203,814.00
(76,360.00)
800.00
2,666,137.00
2,887,496.00
Total County Executive
Non-Departmental
Non-Dept - Charges for Services
Total Non-Departmental
Total Charges for Services
INDIRECT COST RECOVERY (640100)
11,762,979.00 $
640,000.00 $
640,000.00 $
81,520,438.00 $
9,317,500.00 $
11,789,079.00 $ 10,989,819.00 $ (799,260.00)
640,000.00 870,000.00 230,000.00
640,000.00 $ 870,000.00 S 230,000.00
80,827,753.00 $ 84,033,093.00 $ 3,205,340,00
9,317,500.00 $ 9,017,500.00 $ (300,000.00)
35.94% Fav. reflects Value Added Communications (VAC)
contract for commissions on pay phones.
35.94%
3.97%
-3.22% Unfav. due to lower than expected activity related to
construction projects, grants, and proprietary funds. In
addition, discontinuance of the Print Shop.
INVESTMENT INCOME (655000-655999)
District Courts (Div. I - IV)
Sheriff Corrective Services
Clerk/Register of Deeds
Non-Departmental
Total Investment Income
6,000.00 $
69,300.00
2,541,000.00
2,616.300.00 $
6,000.00 $
-
69,300.00
2,541,000.00
2,616,300.00 S
6,000 00 $
9,300.00
3,000,000 00 459,000 00
3,015,300.00 $ 399,000.00
. 0.00%
0.00%
-86.58% Unfav.due to decreasing rates and reduced investment
base.
18.00%
15.25%
(60,000 00)
" Revenue variance is partially offset by an expenditure variance.
Adopted
Budget Percent Explanation of Significant Variances
Amount
Favorable
(unfavorable)
FY 2011
FORECAST
Amended
Budget
OTHER REVENUES (670000-695500)
Circuit Court 19,300.00 $ 19,300.00
District Court
Probate Court
Prosecuting Attorney
Sheriff Office
Sheriff - Patrol Services
Sheriff - Investigative/Forensic Svc
Clerk/Register of Deeds
Treasurer
50,608.00 $
5,000.00
8,500.00
21,326.00
200.00
82,624.00 $
5,000.00
8,500.00
67,140.00
200.00
383,324.00 $
13,300,00
27,400.00
106,340.00
1,200.00
6,000.00
Library Board
Water Resources Commissioner
Homeland Security
Management and Budget -
Central Services - Support Services 4,300.00
Facilities Engineering
Health Division
Children's Village
Public Services
PEDS - Transfers
Economic Development - Donations 15,000.00
Non Departmental - Donations
Non-Dept Sundry 417,500.00
Treasurers' Transfers 5,300,000.00
Non-Departmental - Transfers In 58,620,798.00
Total Other Revenues 64,443,232.00
PLANNED USE OF FUND BALANCE (665000-665999)
Encumbrances
Carryeforwards and Use of Prior Yrs Fund Bal $
Total Planned Use of Fund Balance
200,000.00
200,000.00
153,953.13
6,339,337.00 $
6,493,290.13 $
153,953.13
6,339,337.00
6,493,290.13 S
4,300.00 4,300.00
100.00 100.00
15,000.00 15,000.00
417,500.00
5,300,000.00
58,620,798.00
64,521,062.00
417,500.00
5.300,000,00
58,620,798.00
64,914,562.00 $ 393,500.00
TOTAL GEN. FUND / GEN. PURPOSE REVENU $ 383.199,390.00 $ 388,742,013.13 $ 398,239,053.13 $ 9,497,040.00 2.44%
GENERAL FUND / GENERAL PURPOSE REVENUES
FY 2011 FIRST QUARTER REPORT
0.00% Primarily due to donation of $18,900 received from the
Restore Foundation (per MR ((11015) which will help
operate the Adult Treatment Court in FY 2011.
0.00%
0.00%
Fav due to projected receipts of Donation revenues from
elected official voluntary pay reduction of 4%; a budget
amendment is recommended.
Fav. receipt of Enhancement Funds from drug forfeiture
account $2,800 and receipt of voluntary pay reduction of
elected official's salary of $5,500.
Fav. variance is due to the receipt of Refund Prior Years
Expenditures.
Fav, variance is due to the receipt of Refund Prior Years
Expenditures.
Fay. due to cash overages.
Fav. receipt of Refund of Prior Years Expenditures $300
and receipt of voluntary pay reduction of elected official's
salary of $5,500.
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
100.00% Fay. due to cash overages.
0.00%
100.00%
0,00%
0.00%
0,00%
0.00%
0.00%
0.00%
0.61%
0.00%
0.00%
300,700.00 363.94%
8,300.00 166.00%
18,900.00 0.00%
39,200.00 58.39%
1,200.00 100.00%
5,800.00 0.00%
1:1 Revenue variance is partially offset by an expenditure variance.
C31
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
CIRCUIT COURT
AMOUNT
ADOPTED AMENDED FY 2011 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Judicial Administration
Personnel Expenditures $ 8,085,116.00 $ 8,085,116.00 $ 8,086,616.00 $ (1,500.00) -0.02% - Unf ay. Medical and Retirement due to increase in costs.
Operating Expenditures 99,975.00 335,748.00 335,748.00 0.00% -
Internal Support Expenditures
Transfer Out
319,239.00
150,000.00
339,323,00
200,000.00
339,323.00
200,000.00
- 0.00%-
0.00%
Business Division
Personnel Expenditures
Operating Expenditures
5 8,654,330.00 $ 8,960,187.00 $ 8,961,687.00 $
$ 1.496,438.00 $ 1,496,438.00 $ 1.501,438.00 5
187,764.00 187,764.00 127,764.00
167,130.00 167,130.00
(1,500.00) -0.02%
(5,000.00) -0.33% - Unf ay. Medical and Retirement due to increase in costs.
60,000.00 31.96% - Fav. Visiting Judge $60,000 due to a reduction in the use of this
service.
0.00% - Internal Support Expenditures 166,859.00
$ 1,851,061.00 $ 1,851,332.00 $ 1,796,332.00 $
Civil / Criminal Division
Personnel Expenditures $ 2,100,787.00 $ 2,100,787.00 $ 2,043,287.00 $
Operating Expenditures 5,167,627.00
55,000.00 2.97%
57,500.00 2.74% - Fav. $60,000 due to county wide hiring freeze, underfilled positions
and vacancies; partially offset by Unfav. ($2,500) Medical and
Retirement due to increase in costs.
140,000,00 2.70% - Fav. variance is due to less activity in Defense Attorney fee
payments of 6100,000. These payments are dependent on
caseload, and the Circuit Court fee structure. Also Fay. Juror Fees
and Mileage $40,000 due to a decline in caseload.
5,177,627.00 5,037,627.00
Internal Support Expenditures 2,426,755.00 2,471,439.00
Transfers Out
2,471,439.00 0.00% -
$ 9,695,169.00 $ 9,749,853.00 $ 9,552,353.00 $ 197,500.00 2.03%
3/11/2011
Family Division/Juvenile Maint.
Personnel Expenditures $ 11,102,869.00 S 11,102,869.00 $ 10,957,869.00 $ 145,000.00
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
CIRCUIT COURT
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2011
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
1.31% - Fay. 8150,000 due to county wide hiring freeze, uncierfilled positions
and vacancies; partially offset by unfav. ($5,000) Medical and
Retirement due to increase in Costs.
Operating Expenditures
Internal Support Expenditures
Transfer Out
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
13,569.838.00
1,644,461.00
4,360,124.00
$ 30,677,292.00
S 22,785,210.00
19,025,204.00
4,557,314.00
4,510,124.00
$ 50,877,852.00
13,569,964.00
,1,645,129.00
4.360,124.00
$ 22,785,210.00
19,271,103.00
4,623,021.00
4,560,124.00
$ 51,239,458.00
3,569,964.00
1,637,129.00
4,360,124.00
$ 22,589,210.00 $
.19,071,103.00
4,615,021.00
4,560,124.00
$ 50,835,458.00 $
0.00% -
8,000.00 0.49% - Fay. Mail Room $8,000 due to less than anticipated use.
- 0.00% -
153,000.00 0.50%
196,000.00 0.86%
200,000.00 1.04%
8,000.00 0.17%
0.00%
404,000.00 0.79%
$ 30,678,086.00 $ 30,525,086.00 $
3/11/2011
Division 1 - Novi
Personnel Expenditures
Operating Expenditures 1,013,988.00 1,013,988.00 981,988.00 32,000 00
$ 3,912,768.00 5 3,912,768.00 $ 3,894,768.00 $ 18,000.00
Internal Support Expenditures 431,349.00 440,558.00 415,558.00 25,000.00
75,000.00 1.40%
(1.500.00)
44,500.00
-0.08% -
7.45% -
218,772.00 0.00% -
100.00% -
218,772.00
72,811.00
Internal Support Expenditures
Transfers Out 72,811.00
204,087.00
72,811.00 Transfers Out (Grant Match) will be corrected with 1st
quarter to recognize the end of the cycle for the 52-2
SCAO Drug Court Grant on September 20, 2010.
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
DISTRICT COURT
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2011
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
(6,000.00)
District Court Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
185,182.00 S
5,300.00
185,182.00 $ 191,182.00 $
5,300.00 5,300.00
-3.24% - Unfav. Medical and Retirement due to increase in costs.
0.00% -
0.00%
S 190,482.00 S 190,482.00 $ 196,482.00 $ (6,000.00) -3.15%
0.46% - Fav. $20,000 due to underfillect positions; partially offset
by Unf ay. ($3,000) Medical and Retirement due to
increase in costs.
3.16% - Fay. Defense Attorney Fees $20,000 due to an internal
restructuring in scheduling. Also Fav. Juror Fees and
Mileage $3,000 and Postage of $9,000 due to a
cfecrease in activity.
5.67% - Fay. IT Operations $20,000 and Telephone
Communications $5,000 due to decreased activity.
Total Division 1 - Novi
Division 2 - Clarkston
Personnel Expenditures
Operating Expenditures
$ 5,358,105.00 $ 5,367,314.00 $ 5,292,314.00 $
$ 1,769,141.00 $ 1,769,141.00 $ 1,770,641.00 $
597,450.00 597,450.00 552,950.00
Unfav. Medical and Retirement due to increase in costs.
f=av. Defense Attorney Fees $35,000 due to an internal
restructuring in scheduling defense attorneys. Also Fay.
Juror Fees and Mileage $4,500 and Travel and
Conference $5,000 due to a decrease in activity.
Total Division 2 - Clarkston $ 2,643,489.00 S 2,658,174.00 $ 2,542,363.00 $ 115,811.00 4.36%
3/11/2011
822,172.00 797,887.00
345,161.00 325,161.00
1.10%
0.05%
5.73%
4.11%
ADOPTED
BUDGET
AMENDED
BUDGET
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
DISTRICT COURT
AMOUNT
FY 2011 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Division 3 - Rochester Hills
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Division 4 - Troy
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 3,550,712.00 $ 3,550,712.00 $ 3,553,212.00 $
377,643.00 377.643.00 325,643.00
792,172.00
$ 4,726,242.00 $ 4,750,527.00 $ 4,671,027.00 $
$ 2,155,760.00 $ 2,155,760.00 $ 2,157,560.00 $
509,588.00 509,588.00 494,588.00
335,827.00
$ 3,001,175.00 S 3,010,509.00 $ 2,977,309.00 $
$ 11,573,563.00 $ 11,573,563.00 $ 11,567,363.00 $
2,503,969.00 2,503,969.00 2,360,469.00
1,769,150.00 1,826,663.00 1,751,663.00
72,811.00 72,811.00
(2,500.00)
52,000 00
30,000.00
79.500.00
(1,800 00)
15,000.00
20,000 00
33,200.00
6,200.00
143,500.00
75,000.00
72,811.00
-0.07% - Unfav. Medical and Retirement due to increase in costs.
13.77% - Fay. Defense Attorney Fees of $40,000 due to a
decrease in the amount paid to public defenders_ Also
Fay. Juror Fees and Mileage $12,000 due to a decrease
in activity.
3.65% - Fay. IT Operations due to less than anticipated usage.
1.67%
-0.08% - Unfav. Medical and Retirement due to increase in costs.
2.94% - Fav. Defense Attorney Fees of $15,000 due to a -
decrease in the amount paid to public defenders.
5.79% - Fay. IT Operations due to less than anticipated usage.
$ 15,919,493.00 $ 15,977,006.00 $ 15,679,495.00 $ 297,511.00 1.86%
3/11/2011
Judicial/Administration
Personnel Expenditures
Operating Expenditures
Internal Support
Transfer Out
Estates/Mental Health
Personnel Expenditures
Operating Expenditures
Internal Support
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT REPORT
EXPENDITURES
PROBATE COURT
AMOUNT
ADOPTED AMENDED FY 2011 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 2,435,200.00 $ 2,435,200.00 8 2,439,700.00 $ (4,500.00) -0.18% Unfav. Medical and Retirement due to increase in
costs.
43,981.00 43,981.00 29,981.00 14,000.00 31.83% Fav. due to the Court's effort to minimize costs in
areas such as Library Continuations $9,000,
Membership Dues $2,000 and Travel $3,000.
278,617.00 278,813.00 278,813.00
50,000.00 50,000.00 50,000.00 -
$ 2,807,798.00 $ 2,807,994.00 $ 2,798,494.00 $ 9,500.00 0.34%
$ 2,086,106.00 $ 2,086,106.00 S 2,090,106.00 $ (4,000.00) -0.19% Unfav. Medical and Retirement due to increase in
costs.
635,291.00 651,801.00 651,801.00 0.00%
.563,011.00 569,765.00 557,265.00 12,500.00 2.19% Fav. IT Operations $10,000 and Telephone
Communications $2,500 due to less than
anticipated usage.
$ 3,284,408.00 $ 3,307,672.00 $ 3,299,172.00 $ 8,500.00 0.26%
• ' Department Total
Personnel Expenditures $ 4,521,306.00 $ 4,521,306.00 $ 4,529.806.00 S (8,500.00) -0.19%
Operating Expenditures 679,272.00 695,782.00 681,782.00 14,000.00 2.01%
Internal Support 841,628.00 848,578.00 836,078.00 12,500.00 1.47%
Transfer Out 50,000.00 50,000.00 50,000.00 -
$ 6.092,206_00 $ 6,115,666.00 $ 6,097,666.00 $ 18,000.00 0.29%
3/11/2011
Operating Expenditures
Internal Support Expenditures
Transfers
529.181.00 593,951.40 593,951.40
1,839,404.00 1,865,177.00 1,865,177.00
17,671.00 17,671.00
0 00%
0.00%
0.00%
Internal Support Expenditures
Transfers Out
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
PROSECUTING ATTORNEY
AMOUNT
ADOPTED AMENDED FY 2011 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures $ 2,264,589.00 $ 2,181,639.00 $ 2,965,439.00 S (783,800.00) -35.93% Divisions are reflecting fav / (unfav) variances primarily due
to personnel within the Prosecutors Office working across
divisional disciplines. A formal reorganization is pending
(see offset in Litigation Division).
$ 4,633,174.00 $ 4,658.438.40 $ 5,442.238.40 $ (783,800.00) -16.83%
Litigation
Personnel Expenditures $ 9,175,610.00 $ 9,117,152.00 $ 8,145,852.00 $ 971,300.00 10.65% Divisions are reflecting fav / (unfav) variances primarily due
to personnel within the Prosecutor's Office working across
divisional disciplines. A formal reorganization is pending
(see offset in Administration Division).
Operating Expenditures 39,296.00 28,208.00 28,208.00 0.00%
- - 0.00% -
855,589.00 1,089.573.00 1,089.573.00 - 0.00%
$ 10,070,495.00 $ 10,234,933.00 $ 9,263,633.00 $ 971,300.00 9.49%
3/11/201 1
Operating Expenditures 3,199.00
Internal Support Expenditures
$ 2.125,380.00 $ 2,125,380.00 $ 2,152,380.00 $ (27,000.00)
3,199.00 3,199.00 0.00%
0.00%
-1.27%
Operating Expenditures
Internal Support Expenditures
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
PROSECUTING ATTORNEY
AMOUNT
ADOPTED AMENDED FY 2011 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Warrants
Personnel Expenditures $ 2,122,181.00 $ 2,122,181.00 $ 2,149,181.00 $ (27,000.00) -1.27% Unfav primarily in fringe benefits due to rising cost of
retirement and medical benefit costs.
Appellate
Personnel Expenditures $ 1,676,762.00 $ 1,676,762.00 $ 1,500,862.00 $ 175,900.00 10.49% Divisions are reflecting fay (unfav) variances primarily due
to personnel within the Prosecutor's Office working across
ciivisionai disciplines. A formal reorganization is pending
(see partial offset in Administration Division).
Department
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
8,458.00 8,458.00 8,458.00 0.00%
0.00%
$ 1,685,220.00 $ 1,685,220.00 $ 1,509,320.00 $ 175,900.00 10.44%
$ 15,239,142.00 $ 15,097,734.00 S 14.761,334.00 336,400.00 2.23%
580,134.00 633,816.40 633,816.40 0.00%
1,839,404.00 1,865,177.00 1,865,177.00 0.00%
855,589.00 1,107,244.00 1.107,244.00 0.00%
$ 18,514,269.00 $ 18,703,971.40 $18,367,571.40 $ 336,400.00 1.80%
3/11/2011
Operating Eyponitilures 944,843.00 981,658.85 986,058.85
Internal Support Expenditures
Transfers
FY 20 '1 (it :7:
EXPENDITURES
SHERIFF'S OFFICE
AMOUNT
ADOPTED AMENDED FY 2011 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
- ------------ - ------- ----------- ------- ------ ------------ ------
Sheriff's Office
Personnel Expenditures $ 1,618,606.00 $ 1,618,606.00 $ 1,650,306.00 $ (31,700.00) -1.96% Unfav. fringes for retirement and hospitalization due to increased
costs.
Operating Expenditures 131,880.00 131,880.00 131,880.00 - 0.00% -
Internal Support Expenditures 260,409.00 260,409.00 260,409.00 - 0.00%
Transfers - - 0.00%
$ 2,010,895.00 S 2,010,895.00 $ 2,042,595.00 $ (31,700.00) -1.58%
Administrative Services
Personnel Expenditures $ 1,942,055.00 $ 1,942,055.00 $ 1,962,755.00 (20,700.00) -1.07% Unfav. fringes for retirement and hospitalization due to increased
costs.
(4,400.00) -0.45% Unfav. largely due toiintitudgeted Misceilaneous expense of
($1,700); Other Expendable Equipment of ($1,000) nut budgeted in
this division; and Groceries, Custodial Supplies, and Dry Goods
and Clothing of ($1,700) not budgeted in this division.
Internal Support Expenditures
Transfers
Corrective Services
Personnel Expenditures
251,423.00 (1,100.00) -0.44% Unfav Radio Communications charges act covered by E911
funding.
0.00%
3.137,221,00 S 3;174,036.85 S 3,200,236.85 $ (26,200.00) -0.83%
33,628,137.00 $ 33,628,137.00 $ 34,831,637.00 (1,203,500.00) -3.58% Unfav fringes for retirement and hespitaibration due to increased
costs. Also, Overtime is projected to do unfavorable.
250,323.00 250,323.00
Operating Expenditures 7,208,906.00 7,242,718.22 7,248,518.22 (5,800.00) -0.08% Unfav. Officer Training e - of (95,700); and Indic-rent Orders
of ($100).
7,334,522.00 7,419,189.00 7,419,189.00 - 0.00%
- - - 0.00%
$ 48,171,565.00 $ 48,290,044.22 $ 49,499,344.22 $ (1,209,300.00) -2.50%
3/11/2011
EXPLANATION OF SIGNIFICANT VARIANCES
Unfav. fringes for retirement and hospitalization due to increased
costs. Also, Overtime is projected to be unfavorable.
Operating Expenditures
Internal Support Expenditures
Transfers
876,802.00 877.526.00 877,526.00
(824,000.00)
(53,200.00)
Operating Expenditures 193,649.00 197,240.50 1,684,740.50 (1,487,500.00) -754.16%
Internal Support Expenditures
Transfers
Patrol Services
Personnel Expenditures
152,760.00 (2,200.00) -1.46%
- - - - 0.00%
$ 5,554,714.00 $ 5,658,333.50 $ 7,201,233.50 $ (1,542,900.00) -27.27%
$33,269,489 $ 32,564,088.00 $ 33,700,588.00 $ (1,136,500.00) -3.49%
150,560.00 150,560.00
COUNTY OF T. s 1 ' :2
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
SHERIFF'S OFFICE
AMOUNT
ADOPTED AMENDED FY 2011 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
Corrective Services-Satellites
Personnel Expenditures $ 11,136,934.00 $ 11,136,934.00 $ 11,937,834.00 $ (800,900.00) -7.19%
26,500.00 30,698.32 53,798.32 (23,100.00) -75.25% Unfav personal mileage, and Travel Employee Taxable Meals of
($2,100); Custodial Supplies and Office Supplies of ($21,000)
0.00%
0.00%
-6.84%
-1.00%
$ 12,040,236.00 $ 12,045,158,32 $ 12,869,158.32 $
Emergency Response and Preparedness
Personnel Expenditures $ 5,210,505.00 $ 5,310,533.00 $ 5,363,733.00 $ Unfav. fringes for retirement and hospitalization due to increased
costs. Also, Overtime is projected to be unfavorable.
Unfav largely due to Auction Expense of ($3,900), Personal
Mileage of ($1,800), Taxable Employee Meals ($300), Office
Supplies of ($1,600), and Fee Civil Service of ($1,450,000) (a 1st
qfr. budget amendment is pending).
Unfav Radio Communications charges not covered by E911
funding.
Fay largely due to lower projected overtime $500,000 for patrol
officers. Retirement and Hospitalization is unfav. ($1,636,500) due
to rate increase.
Operating Expenditures
Internal Support Expenditures
Transfers
412,442.00 421,008.64 462,008.64
4,332,789.00 4,320,505.00 4,326,005.00
(41,000.00) -9.74%
0.00%
Unfav (20,000) for helicop1er gasoline and also due to negative
budget in Equipment Rental a budget amendment is proposed;
and unfav. Office Supplies.
(5,500.00) -0.13% Unfav Radio Communications charges not covered by 5911
funding.
$ 38,014,720.00 $ 37,305,601.64 $ 38,488,601.64 $ (1,183,000.00) -3.17%
3/11 /2011
.1=6
1,085,109.00
1,969,247.00
Transfers 334,086.00 556,642.00 556,642.00 0.00%
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
SHERIFF'S OFFICE
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2011
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Investigative/Forensic Svcs
i Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 7,370,681.00 $ 7,370,681.00 $ 7,370,681.00 $
1,065,428.00 1,081,409.00
1,961,347.00 1,961,347.00
0.00%
(3,700.00) -0.34% Unfav. Largely due to Deputy and Office Supplies.
(7,900.00) -0.40% Unfav Radio Communications charges not covered by E911
funding.
$ 10,731,542.00 $ 10,970,079.00
Department Total
Personnel Expenditures $ 94,176,407.00 $ 93,571,034.00
Operating Expenditures 9,983,648.00 10,086,613.53
Internal Support Expenditures 15,166,752.00 15,239,859.00
Transfer Out 334,086.00 556,642.00
$ 10,981,679.00 $ (11,600.00) -0.11%
$ 96,817,534.00 $ (3,246,500.00) -3.47%
11,652,113.53 (1,565,500.00) -15.52%
15,256,559.00 (16,700.00) -0.11%
556,642.00 0.00%
$ 119,660,893.00 $ 119,454,148.53 $ 124,282,848.53 $ (4,828,700.00) -4.04%
cp3 3/11/2011
Personnel Expenditures $ 3,312,180.00 $ 3,312,180.00 $ 3,196,680.00 $ 115,500.00
Operating Expenditures 287,408.00 287,408.00 230,408.00 57,000.00
Internal Support Expenditures
Transfers
597,238.00 629,975.00 609,975.00 20,000.00
$ 1,619,376.00 $ 1,622,988.00 $ 1,619,988.00 $ 0.18% 3,000.00
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
CLERK/REGISTER OF DEEDS
AMOUNT
ADOPTED AMENDED FY 2011 FAVORABLE
BUDGET BUDGET FORECAST UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
------ ------ -- ----- ------- -------- ----- -----
• Administration
Personnel Expenditures S 704,437.00 $ 704,437.00 $ 670,937.00 $ 33,500.00 4.76% Fav. $35,000 due to underfilled and vacant positions; partially
offset by Unfav. ($1,500) Medical and Retirement due to
increase in costs.
Operating Expenditures 40,382.00 40,382.00 39,882.00 500.00 1.24% Fay. Travel and Conference $3,000 due to effort to reduce
costs; partially offset by Unfav. Office Supplies ($2,500) due to
a higher than anticipated use.
Internal Support Expenditures 172,580.00 179,599.00 175,099.00 4,500.00 2.51% Fay. Telephone Communications $4,500 due to a lower than
anticipated use.
Transfers - 0.00%
$ 917,399.00 $ 924,418.00 $ 885,918.00 $ 38,500.00 4,16%
County Clerk (Vital Stats & Legal Rec's)
3.49% Fav. $120,000 due to underfilled and vacant positions; partially
offset by Unfav, ($4,500) due to increase in costs.
19.83% Fav. Professional Services $20,000 and Travel St Conference
$3,000 due to conscious effort to reduce costs. Also Fay, in
Court Transcripts $40,000 as there is no longer a need to print
duplicate copies of court transcripts for co-ciefendents; partially
offset by Unfav. Charge Card Fee ($6,000) due to an increase
in the public paying for services with a credit card.
' 3.17% Fay. Info Tech Imaging Operations $20,000 due to decreased
activity.
' 0.00%
$ 4,196,826.00 $ 4,229,563.00 $ 4,037.063.00 $ 192,500.00 4.55%
Elections
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 717,454.00 $
772,850.00
129.072.00
717,454.00 5 717,454.00 $
772,850.00 772.850.00
132,684.00 129,684.00
0.00%
0.00%
3,000.00 ! 2.26% Fav, Info Tech Operations $3,000 due to a decrease in activity.
Transfers 0.00%
3/11/2011
Ca
CY3
Register of Deeds (and Micrographics)
Personnel Expenditures $ 2,894,670.00 $ 2,894,670.00 $ 2,842,170.00 $ 52,500.00
Operating Expenditures
Internal Support Expenditures
Transfers
503,311.00
459,398.00
503,311.00 $ 453.311.00
457,205.00 $ 457,205.00
50,000.00
25,295.00 $
3,725.00
103,498.00
25,295.00 $
3,725.00
98,498.00
0.00%
0.00%
4.83% Fav. Mail Room $5,000 due to a decrease in activity. 5,000.00
132,518.00 $ 127,518.00 $ 5,000.00 3.77%
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
CLERK/REGISTER OF DEEDS
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2011
FORECAST
AMOUNT
FAVORABLE
UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
1.81% Fay. $55,000 due to underfilled and vacant positions; partially
offset by Unfav. ($2,500) Medical and Retirement due to
increase in costs.
9.93% Fay. Maintenance Contract $30,000 as a result of a vendor
change for maintenance on their machines. Also Fav.
Professional Services $20,000 due to lower than anticipated
activity.
0.00%
, 0.00%
$ 3.857,379.00 $ 3,855,186.00 $ 3,752.686.00 $ 102,500.00 2.66%
Jury Commission
Personnel Expenditures $ 25,295.00 $
Operating Expenditures 3,725.00
Internal Support Expenditures 103,498.00
$ 132,518.00 $
Department Total
Personnel Expenditures $ 7,654,036.00 $ 7,654,036.00 $ 7,452,536.00 $ 201,500.00
Operating Expenditures 1,607,676.00 1,607,676.00 1,500,176.00 $ 107,500.00
Internal Support Expenditures 1.461,786.00 1,502,961.00 1,470,461.00 $ 32,500.00
Transfers -
$ 10,723,498,00 $ 10,764,673.00 $ 10,423,173.00 $ 341,500.00 3.17%
Note revenue offset,
2.63%
6.69%
2.16%
0.00%
3/11/2011
Operating Expenditures 199,920.00 199,920.00 190,620.00
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
COUNTY TREASURER
AMOUNT
ADOPTED AMENDED FY 2011 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures $ 2,720,610.00 $ 2,720,610.00 $ 2,720,610.00 $ 0.00% -
9,300.00 4.65% - Fav largely due to Township & City Treasury Bonds expense
$10,700 payment for the year is less than budget allocation;
partially offset by unbudgeted Miscellaneous expense of
($1,400).
Internal Support Expenditures 603,339.00 720,218.00 720,218.00 - 0.00% -
Division Total $ 3,523,869.00 $ 3,640,748.00 $ 3,631,448.00 $ 9,300.00 0.26%
Department Total $ 3,523,869.00 $ 3,640,748.00 $ 3,631,448.00 $ 9,300.00 0.26%
3/11/2011
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
BOARD OF COMMISSIONERS
AMOUNT
ADOPTED AMENDED FY 2011 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
2,267,166.00 $2,267,166.00 $ 2,272,766.00 $ (5,600.00) -0.25%- (Unfav) Per Diem ($5,600), Unfav, Medical and Retirement due to increase
in costs which are offset by Pam. Salaries due to turnover and 5% pay
reduction for Commissioners effective 111/2011. Per Diem budaet
inadvertently omitted during budget process.
428,181.00 428,181.00 $ 428,181.00 0.00% -
218,007.00 219.031.00 $ 219,031.00 - 0.00% -
$ 2,913,354.00 $2,914,378.00 $ 2,919,978.00 $ (5,600.00) -0.19%
Department Total
Personnel Expenditures $2,267,166.00 $2,267,166.00 $2,272,766.00 $ (5,600.00) -0.25%
Operating Expenditures 428,181.00 428,181.00 428,181.00 0.00%
Internal Support Expenditures 218,007.00 219,031.00 219,031.00 0.00%
$2,913,354.00 $ 2,914,378.00 $2,919,978.00 $ (5,600.00) -0.19%
3/1112011
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
LIBRARY BOARD
AMOUNT
ADOPTED AMENDED FY 2011 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Library Board
Personnel Expenditures $ 657,249.00 $ 657,249.00 $ 663,249.00 S (6,000.00) -0.91% (Untav) Medical and Retirement due to costs increase.
Operating Expenditures 248,699.00 248,699.00 248,699.00 0.00%
Internal Support Expenditures 515,171.00 515,537.00 515,537.00 - 0.00%
Transfers - - -
$ 1,421,119.00 $ 1,421,485.00 $ 1,427,485.00 $
Department Total
Personnel Expenditures $ 657,249.00 $ 657,249.00 $ 663,249.00 $
Operating Expenditures 248,699.00 248,699.00 248,699.00
Internal Support Expenditures 515,171.00 515,537.00 515,537.00
Transfers -
$1,421,119.00 $ 1,421,485.00 S1,427,485.00 $
(6,000.00) -0.42%
(6,000.00) -0.91%
0.00%
0.00%
(6,000.00) -0.42%
3/11/2011
Internal Support Expenditures 1,171,791.00 1,207,516.00 1,342,968.00 (135,452.00)
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER FORECAST REPORT
EXPENDITURES
WATER RESOURCES COMMISSIONER
AMOUNT
ADOPTED AMENDED FY 2011 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Water Resource Commissioner
Personnel Expenditures $ 3,250,777.00 $ 3,250,777.00 $ 3,635,917.00 $ (385,140.00) -11.85% Unfav - Salaries and Fringes ($385,140) due to \A/RC employees time allocated
to various systems not covered by the Energy Efficient Conservation Block
Grant and the CAMS project planning/requirements phase; original estimate
included development/testing phase hours now expected in FY 2011 based on
first quarter Budget Amendment. Expenses all offset in Reimbursement
General Revenue.
Operating Expenditures 457,412.00 457,412.00 457,412.00 0.00%
-11_22% Unfav - Drain Equipment ($135,452) due to CAMS project
planning/requirements phase; original estimate included development'testing
phase hours now expected in FY 2011 based on first quarter Budget
Amendment. Expenses all offset in Reimbursement General Revenue.
Transfers 56,165.00 56,165.00 56,165.00 0.00%
Total $ 4,936,145.00 $ 4,971,870.00 $ 5,492,462.00 $ (520,592.00) -10.47%
Department Total $ 4,936,145.00 $ 4,971,870.00 $ 5,492,462.00 $ (520,592.00) -10.47%
3/11/2011
—C1
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
COUNTY EXECUTIVE
AMOUNT
ADOPTED AMENDED FY 2011 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel $ 2,010,498.00 $ 2,010,498.00 $ 1,976,298.00 $ 34,200.00 1.70% - Favorable due to turnover.
Controllable Operating 224,173.00 224,173.00 -197,173.00 27,000.00 12.04% - Fav. Professional Services for Lobbyist
Internal Support Expenditures 490,473.00 491,178.00 491,178.00 0.00% -
Transfer Out
$ 2.725,144.00 $ 2,725,849.00 S 2,664,649.00 $ 61,200.00 2.25%
Auditing
Controllable Personnel $ 593,560.00 $ 593,560.00 $ 627,460.00 $ (33,900.00) -5.71% - (Unfav) Medical ($15,400) and Retirement (518,500) due to increase in
costs.
Controllable Operating 88,323.00 88,323.00 , 88,323.00 0.00% -
Internal Support Expenditures 88,210.00 88,210.00 88,210.00 - 0.00% -
Transfer Out -
5 770,093.00 $ 770,093.00 $ 803,993 00 $ (33,900.00) -4.40%
Corporation Counsel
Controllable Personnet $ 1,954,122.00 $ 1,954,122.00 $ 1,986,122.00 $ (32,000.00) -1.64% - (Unfav) Salaries, Medical (813,000) and Retirement ($19,000) due to
increased costs.
Controllable Operating 57,273.00 60,273.00 60,273.00 .. 0.00% -
Internal Support Expenditures 198,957.00 200,998.00 200,998.00 - 0.00% -
Transfer Out
$ 2,2101352.00 $ 2,215,393.00 $ 2,247,393.00 S (32,000.00) -1.44%
Department Total
Controllable Personnel
Controllable Operating
Internal Support Expenditures
Transfers Out
S 4,558,180.00 $ 4,558,180.00 $ 4,589,880.00 $
369,769.00 372,769.00 345,769.00
777,640.00 780,386.00 780,386.00
(31,700.00) -0.70%
27,000.00 7.24%
0.00%
5,705.589.00 $ 5,711,335.00 $ 5,716,035.00 $ (4,700.00) -0.08%
3/11/2011
(Untav) Retirement ($6,000) and Medical ($4,400) and due to
increase in costs.
Favorable Office Supplies $800, Travel & Conference $600, and
Membership, Dues $400, due to efforts to contain costs
$ 1,266,820.00 $ 1,274,152.00 $ 1,229,152.00 $ 45,000.00 3.53%
$ 7,709,453.00 $ 7,709,453.00 $ 7,584,453.00 $ 125,000.00
237,591.00 237,591.00
1,234,683.00 1,313,230.00 1,313,230.00
$9,181,727.00 $9,260,274.00 $ 9,135,274.00 $
237,591.00
125,000.00
1.62% Turnover
0.00%
0.00%
0.00%
1.35%
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
MANAGEMENT AND BUDGET
AMOUNT
ADOPTED AMENDED FY 2011 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 206,587.00 $ 206,587.00 $ 216,987.00 $ (10,400 00) -5.03%
5,580.00 5,580.00 3,780.00 $ 1,800.00 32.26%
15,410.00 15,410.00 15,410.00 S - 0.00%
$ 227,577.00 $ 227,577.00 $ 236,177.00 $ (8,600.00) -3.78%
Purchasing
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
'Transfers
Equalization
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 1,071,475.00 $ 1,071,475.00 1,026,475.00 $ 45,000.00
35,081.00 35,081.00 35,081.00 -
160,264.00 167,596.00 167,596.00 -
4.20% Favorable due to underfilling of positions with part time staff.
0.00%
0.00%
3/11/2011
-0
266,400.00 1.34%
259,600.00
6.800.00
1.58%
1.34%
0.00%
0.00%
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
MANAGEMENT AND BUDGET
AMOUNT
ADOPTED AMENDED FY 2011 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Fiscal Services
Personnel Expenditures $ 7,464,238.00 $ 7,464,238.00 $ 7,364,238.00 $ 100,000.00 1.34% Favorable due to underlining positions.
Operating Expenditures 230,324.00 230,324.00 225,324.00 5,000.00 2.17% '
Internal Support Expenditures 1,390,779.00 1,442,203.00 1,442,203.00 - 0.00%
Transfers - - - 0.00%
$ 9,085,341.00 $ 9,136,765,00 $ 9,031,765.00 $ 105,000.00 1.15%
Department Total
Personnel Expenditures $ 16,451,753.00 S 16,451,753.00 $ 16,192,153.00 $
Operating Expenditures 508,576.00 508,576.00 501,776.00
Internal Support Expenditures 2,801,136.00 2,938,439.00 2,938,439.00
Transfers
$ 19 ,761,465.00 $ 19,898,768.00 $ 19,632,368.00 $
3/11/2011
la%
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%
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
CENTRAL SERVICES
AMOUNT
ADOPTED AMENDED FY 2011 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administrative
Personnel Expenditures $ 201,649.00 $ 201,649.00 $ 201,649.00 0.00%
Operating Expenditures 2,616.00 2,616.00 2,616.00 0.00%
Internal Support Expenditures 15,202.00 15,202.00 15,202.00 0.00%
Transfers - -
$ 219,467.00 $ 219,467.00 $ 219,467.00 $ 0.00%
• Support Services
Personnel Expenditures $ 1,076,116.00 $ 1,076,116.00 $ 1,076,116.00 0.00% Anticipated closing of Mailing & Print Fund during 2nd half of the
year which will result in transferring operations to OR Budget
amendment will be recommended to reflect the changes in the
operating budgets of each departmental budget.
53,828.00 53,828.00 53,828.00
677,114.00 684,077.00 684,077.00
- -
S 1,807,058.00 $ 1,814,021.00 $ 1,814,021.00 $
$ 1,277,765.00 $ 1,277,765.00 $ 1,277,765.00 S
56,444.00 56,444.00 56,444.00
692,316.00 699,279.00 699,279.00
$ 2,026,525.00 $ 2,033,488.00 $ 2,033,488.00 $
3/11/2011
cri
1,068,268.00 $
90,484.00
96,665.00
48,700.00 4.36%
0.00%
0.00%
$1,304,046.00 $1,304,117.00 $ 1,255,417.00 $
COUNTY
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
FACILITIES MANAGEMENT
AMOUNT
ADOPTED AMENDED FY 2011 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures $ 223,208.00 $ 223,208.00 $ 223,208.00 - 0.00%
Operating Expenditures 4,596.00 4,596.00 4,596.00 - 0.00%
Internal Support Expenditures 29,758.00 29,758.00 29,758.00 - 0.00%
Transfers Out . - - -
$ 257,562.00 $ 257,562.00 $ 257,562.00 $ 0.00%
Facilities Engineering
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 893,760.00 $ 893,760.00 $ 845,060.00 $ 48,700.00 5.45% - Fav. due to turnover and staff time charged to project work order projects for
engineering services.
85,888.00 85,888.00 85,888.00 - 0.00%
66,836.00 66,907.00 66,907.00 - 0.00%
$1,046,484.00 $1,046,555.00 S 997.855.00 $ 48,700.00 4.65%
Department Total
Personnel Expenditures $ 1,116,968.00 S 1,116,968.00 S
Operating Expenditures 90,484.00 90,484.00
Internal Support Expenditures 96,594.00 96,665.00
Transfers Out
48,700.00 3.73%
3/11/2011
cn
S 671,232.00 $
275,506.00 $
54,434.00 $
60,000.00 8.21% Favorable underfilled position
0.00%
0.00%
$ 1,930,016.00
220,295.00
567,013.00
$1,900,016.00
220.295.00
567,013.00
30,000.00 Favorable underfilled positions 1.55%
0.00%
0.00%
$ 168,076.00
16,552.00
161,732.00
$ 168,076.00
16,552.00 $
161,732.00 $
$ 346,360.00 $ 346,360.00 $ 346,360.00 $ 0.00%
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
HUMAN RESOURCES
AMENDED
BUDGET
731,232.00
275,506.00
54,434.00
S 731,232.00 $
ADOPTED
BUDGET
Administration
Personnel Expenditures
Operating Expenditures 275,506.00
Internal Support Expenditures 52,757.00
Transfer Out -
AMOUNT
FY 2011 FAVORABLE
FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 1,059,495.00 $ 1,061,172.00 51,001,172.00 $ 60,000.00 5.65%
Workforce Management
Personnel Expenditures $ 1,930,016.00
Operating Expenditures 190,295.00
Internal Supped Expenditures 545,243.00
Transfer Out
S 2,665,554.00 S 2,717,324.00 $2,687,324.00 $ 30,000.00 1.10%
Benefits Administration
Personnel Expenditures $ 168,076.00
Operating Expenditures 16,552.00
Internal Support Expenditures 161,732.00
Transfer Out
0.00%
0.00%
0.00%
Department Total
Personnel Expenditures $ 2,829,324.00
Operating Expenditures 482,353.00
Internal Support Expenditures 759,732.00
Transfer Out
$ 2,829,324.00
512,353.00
783,179.00
$2,739,324.00 $ 90,000.00 3.18%
512,353.00 0.00%
783,179.00 0.00%
$ 4,071,409.00 $ 4,124,856.00 $4,034,856.00 $ 90,000.00 2.18%
3/11/2011
Administration
Personnel Expenditures
Operating Expenditures
16,863.00
Operating Expenditures 4,962,672.00 7,420,900.92 6,890,900.92 530,000 00
Internal Support Expenditures 3,263,807,00 3,525,957.00 3,415,457.00 110,500.00
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2011 FIRST
EXPEND`TURES
HEALTH AND HUN SER \LCES
AMOUNT
FY 2011 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 194,989.00 $ 194,989.00 $ 201,389.00 $ (6,400.00) -3.28% - (Unfav,) fringes for Hospitalization and Retirement primarily due
to increase in costs.
11,348,067.00 11,348,067.00 9,548,067.00 1,800,000.00 15.86% - Favorable Foster Boarding Homes $250,000, Favorable Private
Institutions Residential and Foster Care $1,269,0°5 (Michigan
Department of Human Services). Costs are based on caseload,
difficulty of care, and treatment of services °Ili,. • the Court.
Fav. is partially offset by (Unfav.) Nun-Dept. CHI ., Care Subsidy
Revenue (50% reimbursement). Favorable Management
Services $r.:00,000 due to change in contract for Mgmt of Golden
Oaks, par"Plly offset by (Unfav.) insurance premium,
Internal Support Expenditures
Transfers Out
18,063.00 18,063.00 1,200.00 6.64% - Into Tech Operations.
S 11,561,119.00 $ 11,561,119.00 $ 9,766,319.00 $ 1,794,800 00 15.52%
Health
Personnel Expenditures
2.70% - Fav. due to turnover and under filled positions, IP:- nffset by
(Unfav.) fringes for Hospitalization and Retirerm -n' due to
increase in costs,
$ 22,569.724.00 $ 22,569,724.00 $ 21,960,724.00 $ 609,000.00
7.14% - Fay. Contracted Services $125,000, Profession.H Sert ,icas
$350,000, Travel and Conference $5,000, D• • , -; • 025,000, FA
Prcp:fiety Equipment Exp $20,000, and Training '$ducalional
Supplies $5,000 based on current usage and ce ,iitinited Efforts to
minimize expenses and contain costs.
3.13% - Fay. IT Operations $174,000 duo to efforts to minimize expenses
and contain casts. Partially offset by (Untav.) Motor Pool
($12,000) and Telephone Communications ($51,500).
Transfers Out
5 30,796,263.00 533,516,581.92 $ 32,267,081.92 $ 1,249,500.00 3.73%
3/11/2011
EXPLANATION OF SIGNIFICANT VARIANCES
FY 2011 :7
EXPENDITURES
HEALTH AND HUMArl SERVICES
AMOUNT
ADOPTED AMENDED FY 2011 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
Children's Village
Personnel Expenditures $ 13,882,311.00 $ 13,882,311.00 $ 13,914,311.00 $ (32,000.00) -0.23% - (Unfav.) fringes for Hospitalization and Retirement mostly duo to
rate increase. Partially offset by Fay. due turnover and under
filled positions.
Operating Expenditures $ 3,648,695.00
Internal Support Expenditures 2,696,087.00
Transfers Out
3,658,737.84 3,598,737.84 60,000.00 1.64% - Fay. Laundry and Cleaning $40,000 along with Dry Goods and
Clothing $20,000 due to efforts to minimize expenses and
contain costs.
2,723,122.00 2,753,122.00 (30,000.00) -1.10% - (Unfav.) IT Operations ($5,700), Motor Pool Fuel Charges
($4,000) and Motor Pool ($20,200).
Homeland Security
Personnel Expenditures
$ 20,227,093.00 $ 20,264,170.84 $ 20,266,170.84 $ (2,000.00) -0.01%
$ 745,213.00 $ 745,213.00 $ 736,213.00 $ 9,000.00 1.21% - Pay. due to under filled position. Partially offset by (Unfav.)
fringes for Hospitalization and Retirement mostly duo to costs
increase.
Operating Expenditures 261,380.00 310,379.00 310,379.00 0.00% -
Internal Support Expenditures
Transfers Out
487,673.00 488,485.00 452,485.00 36,000.00 7.37% - Fay. IT Operations $42,000 due to efforts to minimize expenses
and contain costs. Partially offset by (Unfav.) Telephone
Communications ($6,100).
$ 1,494,266.00 $ 1,544,077.00 $ 1,499,077.00 S 45,000.00
Department Total
Controllable Personnel .$ 37,392,237.00 S 37,392,237.00 $ 36,812,637.00 $ 579,600.00 1.55% '
Controllable Operating 20,220,814.00 22,738,084.76 20,348,084.76 2,390,000.00 10.51%
Non-Controllable Operating 6,465,690.00 6,755,627.00 6,637,927.00 117,700.00 1.74%
Transfers Out - - - 0.00%
$ 64,078,741.00 $ 66,885,948.76 $ 63,798,648.76 $ 3,087,300.00 4.62%
3/11/2011
4,800.00
6.164.00
207,090.00
174,124.00
207,090.00
174,182.00
Operating Expenditures
Internal Support Expenditures
Transfers
524,370.00
520,867.00
MSU Ext. - Oakland County
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
•
$ 771,944.00 $
70,451.00
286,927.00
1:1
3/11/2011 See re.:ated revenue offset.
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
PUBLIC SERVICES
AMOUNT
FY 2011 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Public Services - Admin.
Personnel Expenditures $ 188,480.00 $
Operating Expenditures 4,800.00
Internal Support Expenditures 6,164.00
188,480.00 $ 196,980.00 $ (8,500.00)
4,80000
6,164.00
-4.51% - (Unfav) Medical ($2,500) and Retirement ($6,000) due to increased
costs.
0.00% -
0.00% -
$ 199,444.00 $ 199,444.00 $ 207,944.00 $ (8,500.00) -4.26%
Veterans' Services
Personnel Expenditures 1,339,468.00 S 1,339,468.00
Operating Expenditures
Internal Support Expenditures
Transfers
1,351,968.00 $ (12,500.00) -0.93% - (Untav) Medical ($2,500) and Retirement ($10,000) due to
increased costs,
207,090.00 0.00% -
174,182.00 0.00% -
0,00%
$ 1,720,682.00 5 1,720,740.00 5 1,733,240.00 $ (12,500.00) -0.73%
Community Corrections
Personnel Expenditures $ 3,365.777.00 S 3,365,777.00
3,405,777.00 $ (40,000.00) -1.19% - (Unfav) Medical ($15,000) and Fletirement ($25,000) due to
increased costs.
524,370.00 524,370.00 0.00% -
543,264.00 543,264.00 0.00% -
- 0.00% -
$ 4,411,014.00 S 4,433,411.00 S 4,473,411.00 S (40,000.00) -0.90%
771,944.00 $ 787,444.00 $ (15,500.00) -2.01% - (Untav) Medical ($5,500) and Rctirement ($10,000) due to
increased costs.
70,451.00 70,451.00 0.00% -
287,913.00 287,913.00 0.00% -
$ 1,129,322.00 $ 1,130.308.00 $ 1,145,808.00 $ (15,500.00) -1.37%
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
PUBLIC SERVICES
AMOUNT
ADOPTED AMENDED FY 2011 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Medical Examiner
Personnel Expenditures $ 3,069,072.00 $ 3,069,072.00 $ 3,094,072.00 $ (25,000.00) -0.81% - (L.Infav) Medical ($.10.000) and Retirement (15,(100) due to
increased costs.
Operating Expenditures 559,070.00 559,070.00 559,070.00 0.00% -
Internal Support Expenditures 1,035,171.00 1,046,913.00 1,046,913.00 0.00% -
Transfers
$ 4,663,313.00 $ 4,675,055.00 $ 4,700,055.00 $ (25,000.00) -0.53%
Animal Control
Personnel Expenditures $ 1,678,894.00 , $ 1,678,894.00 $ 1,658,894.00 $ 20,000.00 1.19% - Favorable due to temporary vacancies.
Operating Expenditures 154,967.00 157,624.44 157,624.44 - 0.00% -
Internal Support Expenditures 684,385.00 694,408.00 694,408.00 - 0.00% -
Transfers -
$ 2,518,246.00 $ 2,530,926.44 $ 2,510,926.44 $ 20,000.00 0.79%
Circuit Court Probation
Personnel Expenditures S ' - $ - $ • - $- 0.00%
Operating Expenditures - 40,798.00 40,798.00 40,798.00 0.00%
Internal Support Expenditures 532,610.00 533,089.00 533,089.00 0.00%
$ 573,408.00 $ 573,887.00 $ 573,887.00 $ 0.00%
Department Total
Personnel Expenditures $10,413,635.00 $ 10,413,635.00 $ 10,495,135.00 $ (81,500.00) -0.78%
Operating Expenditures 1,561,546.00 1,564,203.44 1,564,203.44 0.00%
Internal Support Expendltures 3,240,248.00 3,285,933.00 3,285,933.00 0.00%
Transfers
$15,215,429.00 $ 15,263,771.44 $15,345,271.44 $ (81,500.00) -0.53%
7:1
Ell ' See related revenue offset 3/1 1 /2011
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2011 FAVORABLE
FORECAST ;UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration .
Personnel Expenditures $ 1,094,176.00 $ 1,094,176.00 $ 965,776.00 $ 128,400.00
Operating Expenditures 328,059.00 529,043.00 522,543.00 6,500.00
Internal Support Expenditures 81,288.00 85,008.00 85,008.00 -
Transfers - - - -
11.73% - Turnover
1.23% - Fay. Personal Mileage based on expected usage,
0.00%
$ 1,503,523.00 $ 1,708,227.00 $ 1,573,327.00 $ 134,900.00 7.90%
3,900.00
268,000.00
50,000.00
Planning and Economic Development Services
Personnel Expenditures $ 3,476,089.00 $ 3,476,089.00 $ 3,472,189.00 $
Operating Expenditures 1,060,890.00 1,230,210.00 962,210.00
Internal Support Expenditures 939,694.00
0.11% - Turnover
21.78% - Fav. Operating $95,500 for update of Solid Waste Management
Plan, which is delayed pending reformatting of plan guidelines by
the State, primarily Professional Services, Advertising, Printing,
Legal Services, Travel & Conference, and Membership Dues. Also
fav. operating, primarily in Professional Services, for NO HAZ
Program $125,000 based on reduced resident participation (offset
by reduced program reimbursement), and fay. Business
Recruitment $50,000 due to an increased. level of local activity in
regards to business retention and expansion work.
5.59% - Fav. IT Operations based on current activity level. 894,713.00 844,713.00
.5.75% $ 5,476,673.00 $ 5,601,012.00 $ 5,279,112.00 $ 321,900.00
3/11/2011
84,000.00 $ 84,000.00 $
0.00%
$ 4,547,585.00
1,484,753.00
929,721.00
$ 4,679,885.00
1,759,253.00
979,721.00
$ 4,679,885.00
1,388,949.00
1,020,982.00
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 132,300.00 2.83%
274,500.00 15.60%
50,000.00 5.10%
- 0.00%
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
EXPENDITURES
ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2011 FAVORABLE
FORECAST :UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Community and Home Improvement
Personnel Expenditures $ 84,000.00 $
Operating Expenditures -
Transfers
Workforce Development
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 84,000.00 $ 84,000.00 $ 84,000.00 $
25,620.00 $ 25,620 00 S 25,620.00 $
$ 25,620.00 $ 25,620.00 $ 25,620.00 $ 0.00%
$ 7,089,816.00 $ 7,418,859.00 $ 6,962,059.00 $ 456,800.00 6.16%
3/11/2011
C31
03
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
FY 2011 ,-i.RST OBAFf OR REPORT
NON-DEP., 7.77f 7NTAL EXPEVDITURES
NON-DEPARTARTMENT APPROPRIATIONS
COUNTY OPERATIONS
Insurance Fund
Insurance Surety Bonds
Logos and Trademarks
Road Commission\Current Drain Assessment
Road Comrnissicrari Party Agreement
Provisions
Transfer to CMHA
Total
ADOPTED
BUDGET
$ 194,932.00
16,900.00
30,000.00
1,400,000.00
100.00
30,000.00
9,620,616.00
$ 11,292,548.00
AMENDED
BUDGET
194,932.00
16,900.00
30,000.00
1,534,000.00
2,592,763.00
30,000.00
9,620,616.00
14,019,211.00
AMOUNT
FY 2011 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT
194,932.00
16,900,00
30,000.00
1,534,000.00
2,592,763.00
30,000.00
9,620,616.00
14,019,211.00
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
EXPLANATION
COUNTY BUILDINGS $ 3,239,304.00 $ 3,132,269.00 $ 3,132,269.00 0.00%
STATE AND FEDERAL - COUNTY ASSOCIATIONS
Michigan Assoc. of Counties
National Assoc. of Counties
S.E.M.C.O.G.
Traffic Improvement Assoct . id•oi
Total
SUNDRY EXPENSE
73,000.00
24,700,00
520,000.00
30.000.00
647,700.00 S
300,000.00 $
73,000.00 S
24,700.00 $
520,000.00 $
30,000.00
647,700.00 $
300,000.00 5
73,000.00
24,700.00
520,000.00
30,000.00
647,700.00 S
300,000.00
RESERVED FOR TRANSFERS
Expenditures
Budget Transition
Classification and Rate Change
Contingency
Emergency Salaries
Grant Match
Info Tech Development
Legislative Expense
Misc. Capital Outlay
On:airtime Appropriation
Summer Employees Salary Appropriation
Total
829,417.00
162,709.00
301,917.00
1,309,945.00
2,073.515.00
5,897,170.00
36,400.00
75,000.00
53,000.00
250,000.00
$ 10,989,073.00
907,547.00
162,709.00
301,917.00
1,309,945.00
1,760,156.00
5,054,367.00
36,400.00
67,198.00
53,000.00
250,000.00
$ 9,903,239.00
907,547.00
162,709.00
301,917.00
1,309,945.00
1,760,156.00
5,054,367.00
36,400.00
67,198.00
53,000 00
250,000 00
$ 9,903,239.00
Transfers to Other Funds
Fire Records Management
CLEM IS
Information Technology
0.00%
0.00%
0.00%
0.00%
430,185.00
1,608,186.00
856,676.00
$ 2,895,047.00 $
430,185.00
1,608,186.00
856,676.00
2,895,047.00
430,185.00
1,608,186.00
856,676.00
$ 2,896,047.00
TOTAL NON-DEPT. APPROPRIATIONS S. 29,363,672.00 $ 30,897,466.00 $ 30,897,466.00 $ 0.00%
(71
JAI 90.xls 3/11 /2011
PERCENT
0.00%
0.00%
0.00%
0.00%
0.00%
EXPLANATION
ADOPTED
BUDGET
AMENDED
BUDGET
3/11/2011 90.xls
FY 2011 FIRST QUARTER REPORT
NON-DEPTMENTAL E.XPENnITURES
AMOUNT
FY 2011 FAVORABLE
FORECAST (UNFAVORABLE)
$ 22,828,593.00 $ 25.696,911.00 $ 25,696.911.00
23,641,834.00 23,668,869.00 23,668,869 00
1,000.00 1,000 00 1,000.00
$46,471,427.00 $49,366,780.00 $49,366,780.00 $
TOTAL EXPENDITURES $ 75,835,099.00 $ 80,264,246.00 $ 80,264,246.00 $
TRANSFER TO GENERAL PURPOSE FUNDS
Public Health Fund
Child Care Fund
Social Welfare Fund Foster Care
FY 2011 BUDGET AMENDMENTS
FY 2011 BUDGET AS ADOPTED - GENERAL FUND/GENERAL PURPOSE FUNDS $ 383,199,390.00
BUDGET AMENDMENTS
M,R. #10272 - 10/21/2010 5 26,100.00
Management and Budget - Equalization Contract with the City of the Village of Orchard Lake
MR. #10260 - 10/21/2010 5 100,028.00
Sheriff - Amendment to Police Dispatch Contract with Oakland Community College
M.R. #10263 - 10121/2010 296,900.00
Sheriff - Law Enforcement Contract with Oakland County Parks and Recreation
M.R. #10283 - 11/3/2010
Board of Comm. - Tr-Party Road Improv Frog City of Novi (Planned Use of Fund Balance)
M.R. #10288- 11/3/2010
Sheriff/Prosecutor NET Byrne Grant Acceptance
Sheriff - Enhancement Funds 45,814.00
Prosecutor Enhancement Funds 5 32,016.00
505,851 00
M.R. #10293 -11/18/2010
Prosecutor Attorney - Revisions of the FY 2011, FY 2012 and FY 2013 Budgets
NI.R. #10312 - 12/9/2010
M&B FY 2010 Year End Report
Encumbrances
Carry Forwards
77,830.00
(141,408.00)
5 153,953.13
5 5,633,486.00 $ 5,787,439.13
(149,404.00)
69,000.00
2,250.00
(103,509.00)
(41,114.00)
(164,459.00)
82,229.00
(254,065.00)
3,750.00
(122,373.00)
M.R. #10323 - 12/9/2010
Health Division - 2010/2011 Comprehensive Planning, Budgeting and Contracting (CPBC)
M.R. #10306- 1219/2010
HHS Homeland Security Tornado Warning Siren for Commerce Township
M.R. #10315 - 12/9/2010
HHS Homeland Security Tornado Warning Siren for Springfield Township
M.R. #10331 - 12/9/2010
Sheriff - Patrol Contract with Oakland Township
M.R. #10329 - 12/9/2010
Sheriff - Patrol Contract with Independence Township
M.R. #10328 - 12/9/2010
Sheriff - Patrol Contract with Highland Township
M.R. #10327 - 1219/2010
Sheriff - Patrol Contract with Commerce Township
M.R. #10334 - 12/9/2010
Sheriff - Patrol Contract with Rochester Hills
M.R. #10321 - 12/9/2010
Sheriff - ORV Grant Acceptance (Off Road Vehicle)
M.R. #10326 - 12/9/2010
Sheriff - Patrol Contract with Brandon Township
P56
TOTAL AMENDED BUDGET AS OF 12/3112010 388,742,013.13
FY 2011 BUDGET AMENDMENTS
(B2,228.00)
(246,685.00)
(103509.00)
M.R. #10330 - 1219/2010
sheriff - Patrol Contract with Lyon Township
M.R. #10332 - 1219/2010
Sheriff - Patrol Contract with Orion Township
M.R. #10333 - 12/9/2010
Sheriff - Patrol Contract with Oxford Township
P57
1901
Michael .T. Bouchard
Oakland County Sheriff
Sinceljely4
/
COUNTY OF OAKLAND
OFFICE OF MIE SHE
MICHAEL J. BOUCHARD
,
M
M M
December 7, 9010
Bernard Lepage
1201 Creekview Ct.-
Oakland Township, MI 483
RE: New
• ( Dear Mr. Le
Task VnIp.41,k ut 'Station
17 A I, W
The Sheriff's OffiXfilanks you for your donation of the new multi-task workout station for the
workout room at the Oakland Township Substation. Personal fitness is a priority with our
department and another piece of equipment that assists the staff in keeping in good physical
condition is always welcome.. The equipment will be utilized on a regular basis. Again, we
thank you for your support in helping to keep our workout room updated and maintaining the
physical fitness of our .officers.
c: Tim Soave, Manger, Fiscal Services
1200 N. Telegraph Road * Pontiac, Michigan 48341-1044 * (248) 858-5000 P58
0 00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00%
0.00%
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER FORECAST REPORT
INTERNAL SERVICE FUND
WATER RESOURCES COMMISSIONER
ADOPTED AMENDED FY 2011 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
'DRAIN EQUIPMENT FUND ( 63900)
OPERATING REVENUES:
Inside $4,251,282.00 $4,251,282_00 $4,251,282.00 50.00 0.00%
Outside 252,000.00 252,000.00 252,000.00 $0.00 0.00%
Total Revenue 4,503,282.00 4,503,282.00 - 4,503,282.00 0.00 0.00%
OPERATING EXPENSES 4,559,782.00 4,559,782.00 4,498,992.00 60,790.00 1.33% Fav - Drain Equipment $80,000 the result of actual spending being less tnan
anticipated budget prolection. Unfav Information Technology Development ($2,500)
for maintenance performed on the Automatic Meter Reading System. Unfav -
Maintenance Department Charges ($16,500) for billing charges to the different
internal departments for SCADA equipment.
NET INCOME (LOSS) BEFORE (513,500.00) (56,500.00) 4,290.00 60,790 00 -107.59%
NON-OPERATING REVENUE/(EXPENSE) 58,500_00 56,500.00 59,259.00 2,759.00 4.88% Fay - Accrued Interest Adjustment $517 for accrued hooking adjustment for
investment income. Fav - Income from Investment $872 the moult of account
earning a return due tea positive cash balance. Fav - Sale of Scrap $1,370 for sale
of miscellaneous equipment as Scrap.
TRANSFER IN
TRANSFERS (OUT)
NET REVENUES OVER (UNDER) $0.00
EXPENSES
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
$0.00 $63,549.00 $63,549.00
3,939,908.00
$4,003,457.00
3/11/2011
EXPLANATION OF SIGNIFICANT VARIANCES
REVENUES
Charges for Services $25,000,000.00 $25,000,000.00 $25,000,000.00 $0.00 0.00%
(221,600 00) Other Revenues 2,512,900.00 2,291,300.00 2,512,900.00
($221,600.00) -0.81%
Fay. variance duo to decrease in interest rates on debt obligations,
and lower outstanding debt (see corresponding reduction to
interest ihcome).
500,000.00
0.00%
0.00%
33.33%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
1.40%
DIRE 1151600 Quarterly Forecast,xls 3/11/2011
FY 2011 7 --
ENTERPRISE FUND
TREASUEr'S OFFICE
ADOPTED
BUDGET
DELINQUENT TAX REVOLVING FUND 51600
AMENDED FY 2011 VARIANCE
BUDGET FORECAST FAVAUNFAV) PERCENT
-8.82% ',inlay, variance due to decrease in interest rates on E ,ve,stments,
and projected investment base ($500,000): :IThet by
favorable Prior Years Revenue adjustment at $ ;YR.) -,ed
Accrued Interest Adjustment of $124,600.
Ending FY 2011 Designated Fund Balance:
Designated - Debt Service
Designatod - Doling Taxes Receivable
Designated Collection Pees
Undesignated - Fund Balance
Total Net Assets - Furling
Total Revenues
OPERATING EXPENSES
Personnel Evrsndit.:res
Operating Expen:litiires
Interest Expense
Transfer Out to Other Funds:
General Fund - Collection Fees
OF - Non-Departmental
Work Release Facility Debt Svc
Office Bldg Renovation Debt Svc
52-3 Dstrict Court Debt Service
Total Transfer Out to Other Funds
Total Operating Expenses
REVENUE OVER (UNDER)
EXPENDITURES
Total Net Assets - Beginning
Total Net Assets - Ending
$27,512,900.00
$ 97,308.00
460,250.00
1,500,000.00
5,299,976.00
23,150,000.00
1,842,300 00
2,083,132.00
1,400,875.00
33,776,783 00
$ 35,834,341.00
($8,321,441.00)
$27,512,900.00
$ 97,308 00
460,250.00
1,500,000.00
5,299,976.00
23,150,000.00
1,842,800.00
2,083,132.00
1,400 875.00
33,776 783.00
$ 35,834,341.00
($8,321,441.00)
$27,291,300.00
97,308.00
460,250.00
1,000,000 00
($8,043,041.00)
$225,028,3-70.35
$216,985,329.35
$72,568,273.84
105,909,116.47
15,000,000.00
$23,507,939.04
1216,98529.35
$278,400.00
5,299,976.00
23,150,000.00
1,842,600.00
2,083,132.00
1 400_875.00
33,776,783.00 0.00
$ 35,334,341.00 $ 500,000.00
'2:1•
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
ENTERPRISE FUND
PARKS & RECREATION
ADOPTED AMENDED FY 2011 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
OAKLAND COUNTY PARKS &
RECREATION COMMISSION (50800)
OPERATING REVENUE $ 8,489,513.00 S 8,489,513.00 $ 8,489,513.00 $- 0.00% Revenue is seasonal with the majority of activity occurring in the third and fourth
quarters.
OPERATING EXPENSE $ 25,003,813.00 $ 25,003,813.00 $ 25,003,813.00 $ 0.00% Expenses are not expected to vary from the budget at this time.
NET OPERATING INCOME (LOSS) $ (16,514,300.00) $ (16,514,300.00) $ (16,514,300.00) $- 0.00%
NON-OPERATING REVENUE $ 12,862,500.00 $ 12,862,500.00 $ 12,862,500.00 $- 0.00% Fiscal Year 2011 property tax revenue for Parks and Recreation is based on
(EXPENSE) 2010 Taxable Va!ue (December, 2010 levy).
TOTAL INCOME BEFORE TRANSFERS $ (3,651,800.00) $ (3,651,800 - .00) $ (3,651,800.00) $ 0.00%
TRANSFERS IN $ $ - $ ' - $- 0.00%
TRANSFERS OUT $ S - $ $ 0.00% _
TOTAL NET INCOME (LOSS)* $ (3,651,800.00) $ (3,651,800.00) $ (3,651,800.00) $
TOTAL NET ASSETS - BEGINNING 95,624,784.32
TOTAL NET ASSETS - ENDING 91,972,984.32
3/11/2011
NET REVENUES OVERAUNDER)
EXPENSES (45,500 00) $ (45,500.00)
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
INTERNAL SERVICE FUND
RISK MANAGEMENT
ADOPTED AMENDED FY 2011 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
'LIABILITY INSURANCE FUND 67700
OPERATING REVENUES:
• Outside Revenue $ . 23,500.00 $ 23,500.00 - Fey, due lo reimbursements from 3rd parties pursuant to I:awsuiis.
Inside Revenue 2,486,481.00 2,486,481 00 2,486,481.00 0.00%
Total Operating Revenue $ 2,466,481.00 $ 2,486,481.00 $ 2,509.981.00 $ 23,500 00 0.95%
OPERATING EXPENSE $ 2,597,026.00 $ 2,604,828.00 2,673,828_00 $ (69,000.00) -2.65% - Unfav. indirect costs due to actual charges developed after budget
finalization.
CLAIMS I'AID 289,455.00 289,455 00 289,455.00 0.00%
TOTAL OPERATING EXPENSES $ 2,885,481.00 S 2,894,283.00 $ 2,963,283.00 $ (69,000.00) -2.38%
OPERATING INCOME (LOSS) (400,000.00) (407,802.00) (453,302.00) (45,500.00) 11.16%
NON-OPERATING REVENUE (EXPENSE) 400,000.00 400,000.00 400,000.00 - 0.00%
OPERATING TRANSFERS IN 0.00 7,802.00 7,802.00 0.00 0.00%
TOTAL NET ASSETS - BE6INNIN3 15,922,335.89
TOTAL NET ASSEI S - ENnING 15,876,835.89
3/11/2011
COUNTY OF OAKLAND
FY2011 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
[FRINGE BENEFITS FUND 67800
ADOPTED AMENDED FY2011 VARIANCE
BUDGET BUDGET FORECAST FAW(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING REVENUE
RETIREES MEDICAL - VEBA DEBT
RETIREMENT ADMINISTRATION
DEFINED CONTRIBUTION PLAN
DEFINED CONTRIBUTION PLAN - PTNE
DEFERRED COMPENSATION - COUNTY
DEFERRED COMPENSATION - ADMIN
EMPLOYEE IN-SERVICE TRAINING
EMPLOYEE BENEFITS UNIT
FLEX BENEFIT PLAN
WELLNESS UNIT
FRINGE BENEFITS
TUITION REIMBURSEMENT
RETIREMENT HEALTH SAVINGS
GROUP LIFE INSURANCE
SOCIAL SECURITY
MEDICAL INSURANCE
PRESCRIPTION COVERAGE INSURANCE
DENTAL INSURANCE
VISION INSURANCE
DISABILITY INSURANCE
SHORT-TERM DISABILITY
WORKERS COMPENSATION
UNEMPLOYMENT COMPENSATION
INVESTMENT INCOME
PRIOR YEARS ADJUSTMENTS
EXT - FLEX BEN MEDICAL - EMPLOYEE
EXT - MEDICAL INSURANCE •
EXT - PRESCRIPTION DRUG REBATES
EXT - DENTAL INSURANCE
EXT - VISION INSURANCE
FAT - FLEX BEN LIFE INSURANCE
EXT - FLEX BEN DENTAL INSURANCE
EXT - FLEX BEN VISION INSURANCE
EXT - FORFEITURE OF DEPOSITS
EXT - TRAINING
EXT - OTHER REVENUE - ICMA REBATES
TOTAL REVENUE
48,699,588 48,699,588 • 46,899,588
2,242,467 2,242,467 2,160,467
12,200,000 12,200,000 13,900,000
175,000 175,000 175,000
100,500 100,500 100,500
64,800 64,800 64,800
1,330,306 1,330,306 1,330,306
629,143 629,143 607,443
200,000 200,000 200,000
497,067 497,067 480,067
90,103 90,103 90,103
260,000 260,000 260,000
450,000 450,000 480,000
859,000 859,000 859,000
15,300,000 15,300,000 15,300,000
24,220,000 24,220,000 25,975,000
8,957,000 8,957,000 9,600,000
3,051,000 3,051,000 3,120,000
177,500 177,500 177,500
601,200 601,200 580,000
1,586,700 1,586,700 1,700,000
2,658,075 2,658,075 2,860,075
950,000 950,000 905,000
1,550,087 1,550,087 390,087
1,400
5,000,000 5,000,000 5,000,000
280,000 280,000 280,000
465,000 465,000 465,000
25,000 25,000 25,000
2,500 2,500 2,500
400,000 400,000 400,000
115,000 115,000 115,000
105,000 105,000 105,000
2,110,000 2,110,000 2,110,000
700
150,000 150,000 150,000
135,502,036 135,502,036 136,869,536
(1,800,000) -3.70% - Unfavorability offset by ICMA refund of non-vested employee retirement benefits.
(82,000) -3.66%
1,700,000 13.93% - Favorable due to increase in ICMA contributions, offset by expense.
0.00%
- 0.00%
0.00%
0.00%
(21,700) -3.45%
0.00%
(17,000) -3.42%
0.00%
0.00%
30,000 6,67% - Favorable due to increase in contributions, offset by expense.
0.00%
0.00%
1,755,000 7.25% - Based on use of Blue Cross illustrative rates and premiums for Health Alliance
643,000 7.18% - Favorable due to an increase in Navitus pharmacy claims,
69,000 2.26% - Based on use of Delta Dental illustrative rates.
0.00%
(21,200) -3.53%
113,300 7.14% - Favorable due to an increase in short term disability claims, offset by expense.
202,000 7.60%
(45,000) -4.74%
(1,160,000) -74.83% - Unfavorable clue to lower interest rates.
1,400 0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
700 0.00%
0.00%
1,367,500 1.01%
FRINGE BENEFITS ST OTR FORECAST .xis
c.13
3/11./2011
COUNTY OF OAKLAND
FY2011 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
ADOPTED AMENDED FY2011 VARIANCE
1 BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 1FRINGE BENEFITS FUND 67800
OPERATING EXPENSE
RETIREES MEDICAL - VEBA DEBT BRING. 18,320,000 18,320,000 18,320,000 - 0.00%
RETIREES MEDICAL - VEBA DEBT INT. 30,379,588 30,379,588 30,379,588 . 0.00%
RETIREMENT ADMINISTRATION 2,242,467 2,242,467 2,242,467 - ' 0.00%
DEFINED CONTRIBUTION PLAN 14,450,000 14,450,000 14,450,000 - 0.00%
DEFINED CONTRIBUTION PLAN - PINE 175,000 175,000 175,000 . 0.00%
DEFERRED COMPENSATION - COUNTY 100,500 100,500 100,500 - 0.000/0
DEFERRED COMPENSATION - ADMIN 64,800 64,800 64,800 _ 0.00%
EMPLOYEE IN-SERVICE TRAINING 980,306 980,306 980,306 - 0.00%
IN-SERVICE TRAINING - INFO TECH 350,000 350,000 350,000 - 0.00%
EMPLOYEE BENEFITS UNIT 629,143 629,143 629,143 - 0.00%
FLEXIBLE BENEFIT PAYMENTS 200,000 200,000 200,000 0.00%
WELLNESS PROGRAM 497,067 497,067 497,067 - 0.00%
ACCOUNTING SERVICES 90,103 90,103 90,103 - 0.00%
TUITION REIMBURSEMENT 260,000 260,000 260,000 . 0.00%
RETIREMENT HEALTH SAVINGS 450,000 450,000 480,000 (30,000) -6.67% - Unfavorable due to increase in contributions, offset by revenue.
GROUP LIFE INSURANCE 1,259,000 1,259,000 1,259,000 0.00%
SOCIAL SECURITY 15,300,000 15,300,000 15,329,000 (29,000) -0.19%
MEDICAL INSURANCE 29,500,000 29,500,000 29,840,500 (340,500) -1.15% - Unfavorable due to increase in Blue Cross Blue Shield claims.
HOSPITALIZATION MEDICARE REIMB - - 1,000 (1,000) 0.00%
PRESCRIPTION COVERAGE 9,422,000 9,422,000 9,422,000 0.00%
DENTAL INSURANCE 3,191,000 3,191,000 3,191,000 _ 0.00%
VISION INSURANCE 285,000 285,000 285,000 - 0.00%
DISABILITY INSURANCE 2,187,900 2,187,900 2,301,200 (113,300) -5.18% - Unfavorable due to increase in short term disability claims, offset by revenue.
PROFESSIONAL SERVICES 300,000 300,000 325,000 (25,000) -8.33%
WORKERS COMPENSATION 2,658,075 2,658,075 2,619,475 38,600 1.45% - Favorable due to use excess workers comp insurance,
ADJUSTMENT PRIOR YEARS EXPENSE - 449,600 (449,600) 0.00% - Unfavorable due to pay ending 1018/10 vouchers nol partially accrued in FY2010.
UNEMPLOYMENT COMPENSATION 950,000 950,000 950,000 - 0.00%
CHILD CARE FACILI FY 249,009 249,009 249,009 - 0.00% ,
INDIRECT COS FS 292,725 292,725 285,725 7,000 2.39% - Favorable due to actual charges developed after budget finalization,
SICK AND ANNUAL LEAVE CASH-OUT 718,353 718,353 765,353 (47,000) -6.54%
TOTAL EXPENSE 135,502,036 135,502,036 136,491,836 (989,800) -0.73%
377,700 NE] REVENUE OVER/(UNDER) EXPENSES
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
0.00 0.00 377,700
12,743,506
13,121,206
FRINGE BENEFITS 1ST 0TH FORECAST.xls
Z41
3/1112011
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
INTERNAL SERVICE FUND
MANAGEMENT AND BUDGET
ADOPTED AMENDED FY 2011 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
(OFFICE EQUIPMENT FUND 66400
OPERATING REVENUE - INSIDE $ 872,224.00 $ 872,224.00 $ 872,224.00 $ 0.00%
OPERATING EXPENSE 988.247.00 1,038,247.00 922,347.00 $ 115,900.00 11.16% Pay. indirect costs due to actual charges developed after
budget finalization. Budget amendment recommended.
OPERATING INCOME (LOSS) (116,023 00) (166,023.00) (50,123.00) 115,900 00
NON-OPERATING REVENUE (EXPENSE) 35,000.00 35.000.00 35,000.00 $ 0.00%
NET INCOME (LOSS) BEFORE .
OPERATING TRANSFERS (81,023.00) (131,023.00) (15,123.00) 115,900.00
OPERATING TRANSFERS IN 200.000.00 250,000,00 250,000.00 -
NET REVENUE OVER/(UNDER)
EXPENSES (PLANNED USE OF FUND BAL) $118,977.00 $118,977.00 $234,877.00 $115,900.00
TOTAL NET ASSETS - BEGINNING 3,001,675.20
TOTAL NET ASSETS - ENDING $3,236,552.20
3/11/2011
OPERATING REVENUE $5,084,167.00 $5,084,167.00 $4,428,667.00 ($655,500.00)
OPERATING EXPENSE 5,705,192 00 5,705,192.00 5,520.992.00 184,200.00
75.89%
0.00%
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
ENTERPRISE FUNDS
CENTRAL SERVICES
ADOPTED AMENDED FY 2011 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
.________- ----- ----------
OAKLAND COUNTY INTERNATIONAL
AIRPORT (56500)
-12.89% Unfavorable T-Hangar Rental ($360,000) due to a decrease in the number of
T-Hangars leased, Aviation Gas ($148,000), Land Lease ($84,700), Landing
Fee Concessions ($16,000), Landing Fees ($15,200), Reimburse Customs
($12,900), Late Penalties received from tenants ($11,100) as a result of less
traffic and downturn in the economy, Car Rental Conc,,-,cHons ($4,200), and
Terminal Space Rental ($3,400), due to terminal construction.
3.23% - Favorable Grounds and Custodial Maintenance, SP7,00o, due to new
• terminal building construction, Overtime and associaled Fringe Benefits fav.
$54,500, as less maintenance needed will' higher T-Honour vacancies and
less snow plowing due to lower than normal snowfalls in year; rvianaging
Sc.:Moos lay. $31,200. due to less than anticipated ino,r,..-::•,,ent newice
needed at the Oakland/Southwest Airport; Electric:.it Sr i. .r iv, $12,700,
due to less energy needed for unleasoci units.; Office SLI• ‘haS, fay $3,800, -
due to less than anticipated needs.
NET OPERATING INCOME (LOSS) ($621,025.00) (5621,025.00) ($1,092,325.00) ($471,300.00)
NON-OPERATING REVENUE (EXPENSE)._ (224,516.00) (224,516.00) (224,516.00) 0,00
TOTAL INCOME BEFORE
CONTRIBUTIONS AND TRANSFERS ($845,541.00) ($845,541.00) $ (1,316,841.00) ($471,300.00)
TRANSFERS IN 0.00 0.00 0.00 0.00
CAPITAL CONTRIBUTION 845,541.00 845,541.00 845,541.00 $0.00
TOTAL NET INCOME (LOSS) $0,00 $0.00 (5471,300.00) _ ($471.300.00)
TOTAL NET ASSETS - BEGINNING $ 67,851,059.00
TOTAL NET ASSETS - ENDING $67,379,759.00
0.00%
3/11/2011
L's7i
'MOTOR POOL FUND 66100
OPERATING REVENUE:
Outside Revenue $ 77,000.00 $ 77,000.00 $ 55,000.00
Total Revenue
OPERATING EXPENSE
1 FIRST -I- • R. '.•.$ -
INTERNAL SERVCE FL DS
CENTRAL SER`IICES
ADOPTED AMENDED FY 2011 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ (22,000.00) .-28.57% - Unfav. reduced prodcutive labor ($28,000), pa:- and
accessories revenue ($1,000) due Ti, ('VT
services, offset by warranty reimbursemer•
warranty claims handled ri-house.
C
Inside Revenue 7,422,548.00 # 7,422,548.00 7,382,548.00 S (40,000.00) -0.54% - Unfav_ reducF.1 productive labor (330,000), sublet repair
(510,000) duo to servi,.-;E: less than expected, off.3e..t by: the fay
sublet repair.
OPERATING INCOME (LOSS)
$ 7,499,548.00 $ 7,499,548.00 5 7,437,548.00 5 (62,000.00)
7,589,548.00 7,589,548.00 7,388,748.00 $ 200,800.00 2.65% - Fay, fleet insurance $105,700 due to premium saving;
reduced spending in parts and accessories 5112,000 due to
'He in purchase of light barslre,duction in car wash
$14,100 due to spending less than expected.
Fay decrease in indirect costs $10,638 due to actual charges
developed after budget fin/dization.
Unfav. auction expenses were increased by ($5,000) due to
recognize auction expense for Eli/ Niction, offset by fay. gain
on sale of vehicles; increase in zsne.ndable egui,oment
($45,700) due to more USE. m.-iLiested by
departments; maintenance ' increased by
(S3,100) (tie tc annual &rime 'or fuel control system.
$ (90,000.00) S (90,000.00) $ 48,800.00 $ 138,800 00
NON-OPERATING REVENUE
(EXPENSE)
90,000.00 90,000.00 130,000.00 $ 40,000.oc 44.44% - Fay, gain on sale of Ychi• :as $40,000 due to increaze deme/id
for used vehicles and rz•• auction expense for Flint
Auction. Budget an-'t ic recommended.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS S 178,800.00 $ 178,800 00
TRANSFERS IN ((OUT) 119,000.00 $ 119,000.00
NET REVENUE OVERI/UNDER)
EXPENSES (PLANNED USE OF
FUND BAL.) $ 297,800.00 $ 297,800 00
To-rAL NET ASSETS - BEGINNING S 8,079,964.52
TOTAL NET ASSETS - EN" MG $ 8,377,764.52
The FY 2011 budget as.sumed increazed rates In' casoline. Note that departments are using fewer gallons than budgeted.
Transfer from GE tor vehicles purchased for Animal Control
MR#11017; budget amenc',01ent made after Board approved
reolutien 01/20/11.
or) ,1•\ FiscalSvc Bi idget Forecast_Nevy SUPFORT SERVICES xlsx 3111/2011
FY .1.:.0-;1 FiF1T'T :'• • T.' '."
INTFFMAL SERVICE F!.:,,IDS
CENTRAL SERVICES
ADOPTED AMENDED FY 2011 VARIANCE
BUDGET BUDGET FORECAST FAVA(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
MAILING, CONVENIENCE COPIER AND PRINTING FUND 66700
OPERATING REVLNUE:
Outside ReVent
Inside Revenue
5 583,500.00 $ 583,500.00 $ 281,200.00 $ (302,300.00) -51.81% - Untav, decrease in external metered postage revenue
(522,000), standard mail reve,nue (11511,800) due to
anticipated closing of Printing,1"...1ing rind Cony_ Copier fund
dttring 2nd half of year 'vi 'h fv7.111t in transferring
mailroom operation to OF; printirid revenue is reduced by
($120,000) due to printing lobs on rscid to Oakland
Schools
2,728,000 00 2,728,000,00 812,200.00 S (1,915,800,00) -70.23% - Unfav metered post- :ici.tien1 le 0000 and standard
mail revenue ($2, .• ce in amount of
departments' outgoinc. partial offs,E by by metered
postage and standard m :1 expenses; reduced printing
revenue ($1,101,600) due i;c. p6nting ions cutsourced to
Oakland Schools; reduction in business rep') ;
metered postage ($375.000), standard mail (544,0. iiT;i due to
anticipated fund closing Gee note above). Unfav.
rental 1.1 -ic,7-1) due to anticipated transfer of Convenience.
Conier to IT.
Total Revenue,
OPERATING EXPENSE
OPERATING INcomE (LOSS)
3,311,500 00 S 3,311,500.00 $ 1,093,400.00 $ (2,218,100 00)
3,385,396.00 3,385,396.00 1,155,896.00 2,229,500,00
S (/3,896.00) $ (73,896.00) $ (62,496.00) 5 11,400.00
65.865o - Fav. mail handling-standard mail $7,000 anti metered postage
expense 5.72,500 due to decrease in departments outgoing
mail; decrease in software, rental lease ptirchase 552,500 duo.
to no s.oftware update this year; reduced s.nencling $5,300 for
training and traveconforciince,
Fav. decrease in business reply 84,500. mail handling-
postage $170,000, metered postage $363,800, ih.riuiomtiint
maintenance 53,000, license A permit 57.000 P:.,intenance
contract S11 ,200 due to anticipated fund closl• , :• •-•-• note
above); Fav copier machine. rental t" hiea
anticipated transfer of Convenience CO • id IT
Fay. decrease in salary end fringe heilacil nr duo to
kind closing; reduced in dopreeicticm. •-•:-;:iliincul .1.1211,
contracted sentioes $263,000, ii.eer ih list! '78,400,
copy charges $26;000, eqdlpment -
indirect cost 5140700, Paper Firli "83,000., pii.
supplies 57,700, sf. mainten too
contract 55,900, and chamids " .fue
to printing jobs '0 0,•• •i to CH:iand Schools.
NON-OPERATING REVENUE 1,000.00
(EXPENSE)
1,000 00 (200.00) (1,200,00) -120.00% - Unfav. reduced interest income title to less cash available for
investing.
NET REVENUE OVER/(UNDER)
EXPENSES (PLANNED USE OF
FUND RAT.) " S (72,896 00) (72,896.00) S (62,696.00) $ 10,200.00
TO1AL Ni ASSETS - 6E1,T1NING $ 206,577.15
TO T AL_ NET ASSETS - [N "IC $ 143,881.15
'Please note that in the Adopted Budget (line item budget), Pli:mned Use of Fund R,Tlance appears listed with the, revenue aocio
JaFiscalSvc\Faidgct`,Forecast_New\SUPPORT SERVIOES.xlsx 3/11/2011
Total Revenue
OPERATING EXPENSES
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
INTERNAL SERVICE FUND
FACILITIES MANAGEMENT
ADOPTED AMENDED FY 2011 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$521,514.00 $552,714.00
!FACILITIES MAINTENANCE & OPERATIONS (463100)1
OPERATING REVENUES:
Outside Revenue $468,800.00 31,200.00 5,98% - Fav. External Other Revenue for reimbursement of utilities costs by Ciena
Healthcare due to delayed move from Medical Care Facility to private techl
Inside Revenue 25,094,064.00 25,041,350.00 24,970,250.00 (71,100.00) -0.28% - Reduced Office Space Rental revenue based on lease agreement with 0.0. Road
Commission for leased space in the IT Center ($50,400); lower Maintenance
Department Charges based on anticipated level of departrneillai requests
($50,000); and Refund of Prior Years Expenditure $29,300 for reclassification of
FY 2010 Charges from the Facilities Maintenance & Operatic:us Fund to the
Project Work Order Fund.
$25,562,864.00 $25,562,864.00 $25,522,964.00 ($39,900.00) -0.16%
$26,257,308.00 $26,257,308.00 $25,386,308.00 $871,000.00 3.32% - Fay. Natural Gas/ Fuel Oii $250,000 due to lock-in of favorable long-term pricing
contracts; fay. Electrical Service $250,000 due to lower-cost third-party contracts
and savings from energy conservation initiatives implemented by FM&O; fay,
Sublet Repairs $300,000 due to more efficient management of building
maintenance related items and fewer major repairs and project work required;
Turnover $51,600; fay. Depreciation $10,000 based on depreciation schedule; [av.
Indirect Costs $23,400 due to determination of costs subsequent to budget
determination; and fav. Laundry & Cleaning $5,000 based on usage requirements.
Favorability is partially offset by unfav. IT Operations (511,100); and Rent
($15,000) required for furniture storage.
NET INCOME (LOSS) BEFORE
OPERATING I HANSEL:RS
NON-OPERATING REVENUE
TRANSFERS IN
TRANSFERS OUT
NET REVENUES OVER(UNDER)
EXPENSES'
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
($694,444.00) ($694,444.00) $136,656.00 $831,100.00
$150,000.00 $150,000.00 $150,000.00 $0.00 0.00%
(900,000.00) (900,000.00) (900,000.00) 0.00% - Transfer Out to Project Work Order Fund for Maintenance projects.
(S1 ,444,444.06) ($1,444,444.00) ($613,344.001 $831,100.00
$11,199,110.99
$10,585,766.99
"Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category.
FACILITIES IN fERNAL FORE.xls 3/11;2011
24,776,239.00 24,776,239.00 21,042,639.00 (3,733,600.00) Inside
OPERATING EXPENSES $31,546,529.00 $31,546.529.00 $29,039,829.00 $2,506,700.00
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2011
BUDGET BUDGET FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCES
Information Technology - Operations (0-600)
OPERATING REVENUES:
Outside $931,545.00 , $931,545.00 $763,345.00 ($168,200.00) -18.06% - Unfav. Enhanced Access Fees ($43.900) due to decreased customer usage & Outside
Agencies ($198,700) due to reduction in external customer requests. Partiality offset by
fay. Reimb Equalization Svc 530,200 & Deferred Land File Tax $41,900 due to
increased tax & assessment billings & $2,500 Auction due to sale of aged equip.
-15.07% - Unfav, Depts OC, Dept'l Dev & Ops ($304610018 Imaging Dev & Ops ($701,600) due
to holding rates at prior year levels & Non Govt'l Dev & 0o,s (5222,600) due to increase
in projects eciucted by Non-OF. Partialty offset by fay. Equip Rental $236,700 for •
anticipated budget amendment to trot cony copier to IT.
TOTAL OPERATING REVENUE $25,707,784.00 $25,707,784.00 $21,805,984.00 ($3,901,800.00) -15.18%
7.95% - Fav. primarily due to Sal & FB $1,418,000 due to vacancies: Equip k'aint due
to lower than anticipated hardware maint costs: Software Maid $1Z.0.000 rolls actual
costs; Indirect Cost $241,800; Software Rental $107,000 & Corner OTtlt.8CJ0 .1 ,) to
lower than antic:pated costs: Service Bureau $125,000 due to phrasing cut of 141n.roliche
costs; Supplies $210,000, Contracted Svcs $6,100, Erieght $3,400 & Mem Duos $4,100
due to decreased costs; Mileage $8,600 & Travel $69,100 clue to dr--'ne in staff
attending conferences; Printing $24,000 & Internal Svc $85.300 on actual usage.
Partially offset by urtev. Expend Equip (5565,400) due to equip I. i-Hcani•ifits; Copier
Machine Rental ($210,000) an anticipated budget amendment to Iv cony copier to IT;
Prof Svcs ($43,500) for previously approved IT projects & Bank ChaT.as ($9,400) based
on actual usage.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS ($5,838,745.00) ($5,838,745.00) ($7,233,845.00) ($1,395,100.00)
NON-OPERATING REVENUE 305,500.00 305,500.00 155,500.00 (150,000.00) -49,10% Unfav. Interest Income due to lower cash balance than anticipated.
TRANSFERS IN 906,676.00 906,676.00 906,676.00 0.00 0.00%
TRANSFERS (OUT) 0.00 0.00 0.00 0.00 0.00%
NET REV OVER(UNDER) EXP* ($4,626,569.00) ($4,626,569.001 ($6,171,669.00) ($1,545,100.00)
TOTAL NET ASSETS - BEGINNING - 22,549,538.00
TOTAL NET ASSETS - ENDING $16,377.869.00
*Please note that in the Adopted 134Idget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category.
C.1
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2011
FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCES
Information Technology - Telephone Communications (67500)
OPERATING REVENUES:
Outside $32,000.00 $32,000.00 $29,700.00 (52,300.00) -7.19% Unfav. Sale of Phone External due to decreased usage.
Inside 3,037,760.00 3,037,760.00 3,027,760.00 (10,000.00) -0.33% Unfav. Leased Equip due to decreased use of pagers.
TOTAL OPERATING REVENUE
OPERATING EXPENSES
$3,069,760.00 $3,069,760.00 $3,057,460.00 ($12,300.00) -0.40%
$3,493,560.00 $3,493,560.00 $3,285,360.00 $208,200.00 5.96% Fav. Indirect Cost $63,500; Sublet Repairs $30,000 due to lower than anticipated repair
volume performed by outside vendors; Tower Charges $37,800 due to decreased pager
usage; Exp Equip $66,500 due to decreased equip replacements; Maint Equip $10,300
subsequent to budget & Motorpool $800 due to actual usage. Fay, partially off set by
unfav. Peprec ($900) purchase of capital equipment subsequent to budget.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
NON-OPERATING REVENUE
TRANSFERS IN
TRANSFERS (OUT)
NET REV OVER(UNDER) EXP*
TOTAL NET ASSETS - BEGINNING
TO AL NET ASSETS - ENDING
($423,800.00) ($423,800.00) ($227,900.00)
30,000.00 30,000.00 34,300.00
0.00 0.00 0.00
0.00 0.00 0.00
($393,800.00) ($393,800,00) ($193,600.00) $200,200.00
4,658,228.00
$4,464,628.00
14.33% Fay. Interest Income due to higher cash balance than anticipated.
0.00%
0.00%
$195,900.00
4,300.00
0.00
0.00
'Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund HAVOC in the revenue category.
OPERATING EXPENSES $7,116,125.00 $7,116,125.00 $6,484,125.00 $632,000.00
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2011
BUDGET BUDGET FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCES
Information Technology - CLEMIS (53500)
OPERATING REVENUES:
Outside $4,290,370.00 $4,290,370.00 $4,331,670.00 $41,300.00 0.96% Fay. CLEMIS Crash $100,000 due to implementing addt'l agencies; Parts & Access
$8,900 for CLEMIS Tech support;Outside Agencies $89,800; Maintenance Contracts
$174,600 Livescan maint after warranty. Partially ollset by untav.CLEMIS Citation
($100,000) agencies utilizing programs less than anticipated, cLErois Op, (5100,000)
due to delay of implementing U.S. Customs and Border Patrol 8.. In-Car Terminals
External ($132,100) duo to MOC count lower than budget projection.
Inside 1,629,465.00 1,629,465.00 1,479,265.00 (150,200.00) -9.22% Unfav. ($162,700) due to capital contributions & OC Depts ($5,300) lor CLEMIS staff
support of CADIMDC to Radio. Padially offset by fav.In-Car Terminals 517,800
due to MDO mint higher than budget projection.
TOTAL OPERATING REVENUE $5,919,835.00 $5,919,835.00 85,810,935.00 ($108,900.00) -1.84%
8.88% Fav.Sal/FB $265,600 due to unclerfills & vacancies; Prof Svcs $293,100 due to
contractual services funded through grants for Records Management System
upgrade:Rebillable Services $47,000 based en actual connectivity costs to Tier 2.5 &
3.0 agencies; IT Ops $58,400 based on actual usuage. Offset by befav, Indirect Cost
($23,900); Bank Charges ($15,000) due to cost for paypal services for (:-Commerce
transactions.
NE1 INCOME (LOSS) BEFORE
OPERATING TRANSFERS ($1,196,290.00) ($1,196,290.00) ($673,190.00) $523,100.00
NON-OPERATING REVENUE 15,000.00 15,000.00 17,300.00 2,300.00 15.33% Fay. Interest income due to higher cash balance than anticipated.
TRANSFERS IN 2,044,186.00 2,044,186.00 2,044,186.00 0.00 0.00%
TRANSFERS (OUT) • 0.00 0.00 0.00 0.00 0.00% .
NET REV OVER(UNDER) EXP" $862,896.00 S862,896.00 $1,388,296.00 5525,400.00
TOTAL NET ASSETS - BEGINNING 11,589,079.00
TOTAL NET ASSETS - ENDING $12,977,366.00
't Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" in the revenue category and Budgeted Equity Ad) in Expenses.
Inside
TOTAL OPERATING REVENUE
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
NON-OPERATING REVENUE
TRANSFERS IN
TRANSFERS (OUT)
NET REV OVER(UNDER) EXP 4
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2011
BUDGET BUDGET FORECAST VARIANCE
Information Technology - Radio Communications (53600)
OPERATING REVENUES:
Outside $6,261,277.00 $6,261,277.00 36,415,477.00 $154,200.00
EXPLANATION OF SIGNIFICANT VARIANCES
2.46% Fav. E-911 $320,400 due to higher than anticipated revenue item Communication
& includes Surcharge rate effective Jul 1, 2010, Partially offset by unfav.Outside
Agencies ($166,300) due to fewer non-emergency agencies than anticipated
290,965.00 290,965.00 292,365.00 1,400.00
$6,552,242.00 $6,552,242.00 $6,707,842.00 $155,600.00
$8,706,070.00 38,706,070.00 S8,364,670.00 $341,400.00
($2,153,828.00) ($2,153,828.00) ($1,656,828.00) $497,000.00
. 150,000.00 150,000.00 412,300.00 262,300.00
0.00 0.00 0.00 0.00
(486,000.00) (486,000.00) (486,000.00) 0.00
($2,489,828.00) ($2,489,828.00) ($1,730,528.00) 3759 300 00 , . _
0.48% Fav.due to sale of equipment.
2.37%
3.92% Fay. Sal & FB .3,165,200 duo to vacancies; Indirect Cost $80.100 sub ,enuont to budget
projection; Equip Maint $20,000 due to lower than anticipated maint ,: -,ace cost of CAD
equipment; Special Project $40,000 due to postponement of pintE ..DW-4-S; Parts &
Access $115,000 due to warranty coverage of new system; Srrw)" 500 due to
decreased costs; Freight $1,200, 390,000, Laundry $800 & 'treat Svcs
$184,200 based cn actual usF.u..,. ,.ffset by unfav. Deprec '46,600);
Expendable Equip ($46,300) due to Next Generation 911 equip repla.cernonts.
174.87% Fay. primarily due to Interest Income; higher cash balance than anticipated.
0.00%
0.00%
TOTAL NET ASSETS - BEGINNING . 57,236,617.00
TOTAL NET ASSETS - ENDING 355,506,089.00
„).,- Please note that in the Adopted Budget (line-Rein book) this is budgeted as "Planned use of Fund Balance" in the revenue category.
COUNTY OF OAKLAND
FY 2011 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2011
. BUDGET BUDGET FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCES
Fire Records Management ( 53100)
OPERATING REVENUES:
Outside
OTAL OPERATING REVENUES
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
NON-OPERATING REVENUE
$200,002.00 $200,002.00 $196,402.00 ($3,600.00) -1.80% Unfav. primarily due to actual Rebilled Charges lower than anlicipa
$200,002.00 $200,002.00 $196,402.00 (53,600.00) -1.80%
$628,553.00 $628,553.00 $608,953.00 $10,600.00 3.12% Fay. Sal 600 518,500 due lo lay.overlime & on call; Communications $15,100 duo to
savings in connectivity costs & IT Ops $3,000 due to actual usage. Offset by unlav.
Software Maint ($7,600) due to increase in maintenance costs & Indirect Cost ($9,000),
(S428,551.00) ($428,551.00) ($412,551.00) $16,000.00
2,000.00 2,000.00 3,500.00 1,500.00 75.00% Interest Income favorable due to higher cash balance than anticipated.
TRANSFERS IN 430,185.00 430,185.00 430,185,00 0.00 0.00%
TRANSFERS (OUT) 0.00 0.00 0.00 0.00 0.00%
NET REV OVER(UNDER) EXP" $3,634.00 $3,634.00 $21,134.00 $17,500.00
TOTAL NET ASSETS - BEGINNING 445,104.00
TOTAL NET ASSETS - ENDING $466,238.00
Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" in the revenue category and Budgeted Equity Adj in Expenses.
Resolution #11068 April 21, 2011
Move by Covey supported by Long the resolutions (with fiscal notes attached) on the Consent Agenda be
adopted (with accompanying reports being accepted).
AYES: Crawford, Dwyer, Gershenson, Gingell , Gosselin, Greimel, Hatchett, Hoffman, Jackson,
Long, Matis, McGillivray, Middleton, Nash, Nuccio, Potts, Quarles, Runestad, Scott, Taub,
Weipert, Woodward, Zack, Bosnic, Covey. (25)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the Consent
Agenda were adopted (with accompanying reports being accepted).
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Bill Bullard Jr., 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 April 21,
2011, 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 21st day of April, 2011.
E,La
Bill Bullard Jr., Oakland County