HomeMy WebLinkAboutResolutions - 2012.07.18 - 20441MISCELLANEOUS RESOLUTION #12179 July 18, 2012
BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON
IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2012 SECOND 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) 2012 Second Quarter Financial Forecast Report has identified several
variances and budget amendments are recommended; and
WHEREAS a budget amendment has been requested by the Circuit Court — General Jurisdiction in the
amount of $2,780 to reallocate funds to accurately account for actual expenditures; and
WHEREAS the State of Michigan has amended the County's Friend of the Court Cooperative
Reimbursement Program award (Amendment #2) resulting in a revenue reduction of ($221,959), and a budget
amendment is recommended to reduce revenue and expenditures within the Friend of the Court Fund (#27100)
and the associated portion of grant match required from the General Fund (#10100) to recognize Amendment #2;
and
WHEREAS a budget amendment is recommended for the 52 nd District Court — Division I (Novi) to reduce
Operating Expenditures in the amount of $22,000, due to a revenue shortfall for Refund of Fees for Defense
Attorneys for the FY 2012 Budget Task. Operating Expenditures will also be adjusted with the FY 2013 — FY
2015 Executive Recommended Budget; and
WHEREAS the 52 nd District Court — Division II (Clarkston) has requested a budget amendment to
reallocate projected favorability of $3,000 in their Defense Attorney Fees line-item to the Expendable Equipment
line-item for the purchase of a new document shredder for LEIN records; and
WHEREAS the 52 nd District Court — Division IV (Troy) has requested a budget amendment to reallocate
funds totaling $2,000 to more accurately account for actual expenditures; and
WHEREAS a budget amendment of $191,557 is recommended for the 52 nd District Courts to reallocate
funds from the Non-Departmental Information Technology — Development line-item to the four (4) District Courts'
Software Support Maintenance line-items for maintenance costs associated with the court management system
changeover to the State of Michigan Judicial Information Systems (JIS); and
WHEREAS a budget amendment in the amount of $3,500 is recommended for the Clerk's Office to
reallocate funds from the County Clerk's Division to the Administration Division to more accurately account for
actual expenditures; and
WHEREAS the Prosecuting Attorney is projected to be favorable in the Expert Witness Fees and Mileage
line-item and has requested a budget amendment to reallocate $17,863 from favorability to various line items
inadvertently reduced with prior amendments to meet the FY 2012 Budget Task; and
WHEREAS the Prosecuting Attorney is also requesting a reallocation of funds totaling $35,630 from
various accounts in the Litigation Division to the Administration Division to more accurately account for location of
the actual expenses; and
WHEREAS the Sheriff's Office is reflecting significant unfavorability in revenue primarily due to the State
of Michigan opting not to contract with the County for the use of the Frank Greenan Facility for the board and care
of inmates, offset by significant favorability projected in the Sheriffs operating expenses due to late start-up of
privatizing the jail health clinic, and a budget reduction of ($985,654) is recommended to the Sheriff's total
revenue and expenditure budget; and
WHEREAS the Water Resources Commissioner is requesting to amend salaries and fringe benefits
within the WRC General Fund, Drain Equipment Fund, Water and Sewer Trust Fund, and various Sewage
Disposal System Funds based on implementation of the Collaborative Asset Management System (CAMS) and
integration with the PeopleSoft Financial System, which has improved time and labor distribution for payroll
purposes and allows WRC employees to be paid from the Drain Equipment Fund versus charging individual
systems/funds; and
WHEREAS the Equalization Division is requesting a budget amendment to reallocate $10,000 from
projected favorability in Professional Services to Membership Dues for costs associated with certification of
personal property examiner cards; and
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote with Woodward and Quarles absent.
WHEREAS an amendment to reallocate $10,500 is requested by the Central Services-Mailroom to meet
United States Postal Service (USPS) Move Update compliance in order to process mail at a first class pre-sorted
rate and maintain the County's savings benefit with the USPS; and
WHEREAS a budget amendment is requested by the Community Corrections Division to reallocate
$8,000 from favorability in Contracted Services to Travel and Conference to provide certification for the staff
members with the National Association of Pretrial Services Agencies (NAPSA) and transfer $12,000 from
favorably forecasted Transportation of Clients and Ground Supplies to the Parks and Recreation Fund to cover
costs associated with the Community Service Garden Project for probationers; and
WHEREAS a budget amendment totaling $656,824 is recommended by the Health Division to reduce
funding for the Zero to Three grant reimbursement by $472,997 due to a replacement in funding source (Health
Nurse Family Partnership Program) and reduce funding $183,827 as Health Division did not receive anticipated
additional revenue from CPBC supplemental grant award, and reallocate $25,918 from various line-items within
the Health Personal and Preventive to Health Field Nursing in order to more accurately account for actual
expenses; and
WHEREAS a budget amendment is requested to transfer $11,825 inadvertently budgeted in the Circuit
Court's Michigan Mental Health Court Grant, Fund #27175 — Grant #0000000423, and should have been
budgeted in the Michigan Mental Health Grant ARRA, Fund #27177 — Grant #000000048; and
WHEREAS a budget amendment is requested to recognize additional revenue from the State of Michigan
for the Friend of the Court Access and Visitation Grant in the amount of $3,595; and
WHEREAS the Water Resources Commissioner is requesting to amend the Drain Equipment Fund
$37,655 to take into account the replacement of one (1) owned vehicle with one (1) leased vehicle; and
WHEREAS the Economic Development Corporation (EDC) Board has approved the FY 2012 Special
Revenue Budget for the EDC in the amount of $48,500, which includes a reduction ($21,000) in the transfer of
funds to the Business Finance Corporation, and a budget amendment is recommended to amend the FY 2012
Budget; and
WHEREAS the Health Division has received additional funding for the Comprehensive Planning,
Budgeting, and Contracting (CPBC) Agreement from the Michigan Department of Community Health (MDCH) in
the amount of $345,535 (less than 15% variance from the original award). However, a budget amendment of
$291,213 is requested, as the Health Division included the full amount of $108,646 in funds for the Sexually
Transmitted Diseases grant at the time of accepting the original award instead of the quarterly portion of $54,322
actually submitted to the County, due to the State's change in procedure for issuing certain grant payments; and
WHEREAS the Facilities Maintenance and Operations Division is requesting a transfer of funds totaling
$606,500 within the division's FY 2012 Budget to provide increased funding for required projects while reducing
appropriations for utilities based on FY 2012 forecasted expenditures; and
WHEREAS an amendment is recommended to the Information Technology Fund to reallocate funds in
the amount of $200,000 from Administration to Application Services for various projects such as the IT
Enhancement Budget Projects, which require technological enhancements to improve efficiency in operations;
and
WHEREAS a budget amendment is recommended for the Fringe Benefit Fund to account for reduction of
hospitalization rates as well as budget amendments to the various departmental budgets for the reduced
hospitalization rates; and
WHEREAS the Township of Highland Tr-Party project #49301 was administered by the Road
Commission of Oakland County (RCOC) under former Tr-Party Rules, and an additional $6,052 is needed from
the County for its 1/3 share for construction on White Lake Road west of Highland Hills Drive to Eagle Road.
Funding is available for this additional cost in the General Fund Designated Fund Balance for Tr-Party funding
(GL Account #383510); and
WHEREAS the Sheriff's Office has requested the use of Law Enforcement Enhancement Deferred
Revenue Funds (GL Account #222430) in the amount of $3,299 to replace one (1) M7300 radio in a used NET
vehicle for the Rochester Hills Interlocal Agreement (approved per MR #11140); and
WHEREAS the Parks and Recreation Commission received contributions (donations) in the amount of
$650 for the Rotary Park Pedestrian Bridge at the Springfield Oaks Golf Course, $712 for the Nature Center and
Ellis Barn Festival at the Independence Oaks Nature Center, and $150 for Dog Park Programs at the Lyon Oaks
Park, for a total of $1,512 in contributions; and
WHEREAS the Oakland County Department of Economic Development and Community Affairs has
attempted to collect funds from loan recipients for the Community Development Block Grant ($289,441.29) and
the Home Investment Partnership Act Accounts ($163,429.56), and recommends ($452,870.85) be written off in
uncollectable loans.
NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year 2012
Second Quarter Financial Report.
BE IT FURTHER RESOLVED that $6,052 from the FY 2012 Assigned Fund Balance for Tr-Party Road
Improvement Projects (GL Account #383510) be appropriated for additional costs associated with previously
approved Tr-Party Road Improvement Project No. 49301 for construction on White Lake Road west of Highland
Hills Drive to Eagle Road as follows:
GENERAL FUND (#10100)
Revenue
9010101-196030-665882
Expenditure
Planned Use of Fund Balance
Total Revenue
FY 2012
$6,052
$6,052
90101 01-1 53010-740135 Road Commission Tri- Party $6,052
Total Expenditure $6,052
BE IT FURTHER RESOLVED that the contributions made to the Parks and Recreation Commission are
accepted as previously detailed.
BE IT FURTHER RESOLVED that the uncollectible debts, as recommended by the Department of
Management and Budget and detailed in schedules are authorized to be written off.
BE IT FURTHER RESOLVED that the FY 2012 Budget is amended pursuant to Schedule A (General
Fund/General Purpose Budget Amendments), Schedule B (Proprietary and Special Revenue Budget
Amendments) and Schedule C (Hospitalization Departmental Reduction)
Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution.
itoselesammeetassont. .02111n11n1n11mEgarr nIII•11111111111110.1e
VESIMISIEr
COUNTY MICHIGAN
DEPARTMENT OF MANAGEMENT AND BUDGET
L. BROOKS PATTERSON, OAKLAND COUNTY EXECUTIVE
Laurie Van Pelt, Director
TO: Members of the Finance Committee
FROM: Laurie Van Pelt, Director, Management and Budget eze,f Tim Soave, Manager, Fiscal Services
Lynn Sonkiss, Chief, Fiscal Services
LaVerne Smith, Supervisor of Fiscal Services
SUBJECT: Letter of Transmittal - Fiscal Year 2012 Second Quarter Forecast
DATE: June 14, 2012
FY 2012 SECOND QUARTER REPORT
Attached please find the Fiscal Year (FY) 2012 Second Quarter Forecast Report. In total, Fiscal Services forecasts that
the County will complete Fiscal Year 2012 with overall favorable variance of $11,464,527 in General Fund / General
Purpose (GF/GP) operations, compared to the amended budget. GF/GP includes all operations except grants, enterprise
funds, and internal service funds. This overall favorability is split between receiving ($3,358,091) less revenue than
anticipated and projected favorability in expenditures of $14,822,618.
REVENUES
GF/GP revenues are 0.79% less than budget or ($3,358,091). Major variances are the result of the following events:
A. STATE GRANTS — Unfavorable: ($1,519,200)
Reduced state funding is the result of reduced Child Care fund costs. The revenue loss is more than offset by
projected reduced expenditures. Expenditures are estimated to be favorable for Foster Boarding Homes,
Private Institutions, and Foster Care totaling S2.9 million.
B. OTHER INTERGO\i'ERNNIENTAL REVENUE — Unfavorable: ($175,700)
Revenue from the State for Cigarette Tax Sales is projected to be lower than anticipated. Also, Circuit Court
judge salary reimbursement is unfavorable due to a vacancy (offset by salary favorability).
C. CHARGES FOR SERVICES — Unfavorable: ($795,647)
Primarily due to the unfavorable Board and Care revenue as the Sheriffs Office was not able to obtain a
contract with the Michigan Department of Corrections for unused space at the Frank Greenan facility. The
unfavorable Board and Care revenue is offset with favorable expenses in Corrective Services budget.
D. INVESTMENT INCOME — Unfavorable: ($764,000)
Investment income is unfavorable due to the decreased investment base and lower investment rates.
E. INDIRECT COST RECOVERY - Unfavorable: ($800,000)
Estimated forecast includes reduced activity from construction projects, grants, and proprietary funds. Several
internal service funds have been closed over the past few years, Microfilm, Jail Commissary, Sheriff Aviation,
Office Equipment and Printing and Mailing,
F. OTHER REVENUES — Unfavorable: ($329,300)
Non-Departmental Prior Year Adjustments.
EXPENDITURES
In total, expenditures are projected to be 3.49% under budget or $14.822,618 favorable.
EXECUTIVE OFFICE BUILDING 41 WEST • 2100 PONMAC LAKE RD DEPT 09 • WATERFORD MI 48328-0409 • (248) 858-2163 • FAX (248) 858-9172
EMAIL: vanppltl@oakgov.com
It is important to analyze the forecast using both the Budget perspective and the GAAP perspective to accurately reflect
the impact of fiscal activity generated from FY 2012 operations.
The Budget perspective recognizes the overall favorable operating budget variance and confirms the County's
continuing efforts to maintain long-term fiscal stability particularly through continuation of prudent fiscal policies, such
as budgeting for full employment of all authorized positions, the non-24/7 hiring freeze and the stringent scrutiny
applied to all requested expenditures. The forecasted favorable level of expenditures more than covers the anticipated
revenue reductions.
The GAAP perspective provides information as to the effect on fund balance. This forecast projects that General Fund
balance will decrease by $13.8 million by the end of Fiscal Year 2012. This is consistent with information provided to
the Finance Committee and the Board of Commissioners, as well as what is reflected in the FY 2012-2014 Triennial
Budget — the County PLANNED to use fund balance, which has increased over the past several years through
accelerated budget reductions, to support operations beginning in FY 2012.
3
$ 198,329,187.00
861,770.00
20,325,111.00
11,090,534.00
99,758,486.00
8.700.000.00
3,256,500.00
56,904,449.00
$ 399,226,037.00
$ 199.054,228.00
772,570.00
18,805,911.00
10,914,834.00
98,962,839.00
7,900,000.00
2,492.500.00
56,575,149.00
$ 395,478,031.00
BUDGET
AS
AMENDED
FY 2012
FORECAST
$ 25,304,543.76
$ 420,782,574.76
$ 52.056,623.59 $ 49,649,623.59
17,023,211.40 16,682,611.40
6,152,175.94 6,054,175.94
75,232,010.93 5 72,386,410.93
$ 17,508,009.00 $ 24.914.628.76
$ 416,237,573.00 $ 424,140,665.76
4.62%
2.00%
1.59%
3.78%
LAW ENFORCEMENT
Prosecuting Attorney
Sheriff
TOTAL LAW ENFORCEMENT
19.604,241.00
141,102,850.00
$ 160,707,091.00
19,957,716.67 18,403,816.67
142.125.790.79 140,042,490.79
S. 162,083,507.46 $ 158,446,307.46
1,553,900.00
2,083.300.00
$ 3.637,200.00
7.79%
1.47%
2.24%
GENERAL GOVERNMENT
Clerk/Register of Deeds
Treasurer
Board of Commissioners
Library Board
Water Resources Commissioner
378,100.00 3.32%
(363.300.00) -4.61°/0
160,600.00 5.21%
11,400.00 0.78%
(59,761.00) -1.15%
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
127,039.00 0.44%
125,000.00
1,110,000.00
216,600.00
160,300.00
341,100.00
4,386,800.00
889,400.00
949,900.00
$ 8,179,100.00
$ 14,788,939.00
11,318,945.00
7.647.233.00
3,063,647.00
1,465,669.00
5.065,948.00
$ 28,561,442.00
11,372,132.81
7,875,015.01
3,081,483.34
1,466,505.56
5,184,297.00
$ 28,979,436.72
10,994,032.81
8,238,315.01
2.920,883,34
1,455,108.56
5,244,058.00
$ 28,852,397,72
$ 5,771,364.00 $ 5,778,267.08 $ 5,653,267.08
21,096,363.00 21,377,564.13 20,267,564.13
2.650,177.00 2.669.841.43 2,453,241.43
1,267,122.00 1,267,912.01 1,107.612.01
3,971,493.00 4,097,516.11 3,756,416.11
65,792,522.00 70,704.257.89 66,317,457.89
18,478,8.49.00 16,707,949.83 15,618,549.83
7,287,536.00 7,769,580.25 6,819,680.25
$ 124,315,426.00 $ 130,372,888.73 $ 122,193,788.73
$ 388,242,924.00 9 396.667,843.84 $ 381,878,904.84
2.16%
5.19%
8.11%
12.64%
8.32%
6.20%
5.32%
12.23%
6.27%
3.73%
$ 27,439,142.92
$ 409,318,047.76
$ 11,464,527.00
($25,304.543.76)
($13,840,016.76)
33.679.00
14,822,618.00
$ 11,464,527.00
($25,304,543.76)
($13,840.016.76)
0.12%
3.49%
$ 27,994,649.00
$ 416,237,573.00
$ 27,472,821.92
$ 424,140.665.76
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER FORECAST
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
REVENUES
GENERAL FUND
Taxes
Federal Grants
State Grants
Other Intergovernmental Revenue
Charges for Services
Indirect Cost Recovery
Investment Income
Other Revenues
PLANNED USE OF FUND BALANCE
TOTAL GFIGP FUNDS
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court
52nd District Court
Probate Court
TOTAL ADMIN. OF JUSTICE
FY 2012
ADOPTED
BUDGET
$ 198,329,187.00
581,971.00
20,285.297.00
11,090,53440
100,473,693.00
8,700,000.00
3,256,500.00
56,012.382.00
$ 51,706,676.00
16,832,789.00
6,119.500.00
$ 74,658,965.00
AMOUNT
FAVORABLE/
(UNFAVORABLE) PERCENT
725,041.00 0.37%
(89,200.00) -10.35%
(1,519,200.00) -7.47%
(175,700.00) -1.58%
(795,647.00) -0.80%
(800,000.00) -9.20%
(764,000.00) -23.46°/a
(329,300.00) -0.58%
$ (3,748.006.00) -0.94%
389,915.00 1.57%
$ (3,358,091.00) -0.79%
2,407,000.00
340,600.00
98,000.00
2,845,600.00
SUB-TOTAL GENERAL FUND/GENERAL PURPOSE $ 398,729,564.00
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NON-DEPARTMENTALS
TOTAL GOVERNMENTAL EXPENDITURES
General Fund/General Purpose
Favorable/(Unfavorable) - Budget Perspective
GAAP Required Adjustment (eliminating use of fund balance "revenue")
GAAP • BASED REPORT (forecasted impact on Fund Balance)
31
GF/GP OPERATIONS - SELF BALANCING AMEND ENTS
Non-Dept / 52nd District Court - Division I (Novi)
Revenue
3020201 121020 631736
Expenditures
3020201
3020201
3020201
3020201
3020205
121020
121020
121020
121020
113290
730450
730982
731479
750399
730548
Non-Dept / Circuit Court - FOC Coop Reimb Program (CRP)
Expenditures
9010101 196030 730800 Non-Dept - Grant Match
3010404 126030 788001 27100 Non-Dept - Transfer Out to FOC Fund
Total Expenditures
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
GENERAL FUND (#10100)
Dept Program Acct Fund Aff. Op Unit
:ircuit Court
Expenditures
3020301 121200 731997
3020301 121200 731416
3010301 121200 732165
3010301 121200 750245
52nd District Court - Division II (Clarkston)
Expenditures
3020301 121020 730450
3020301 121020 750154
Account Name
Cir Crt Gen Jur - Transportation of Clients
Cir Crt Gen Jur - Priv Institutions - Residential
Cir Crt Gen Jur - Workshops and Meetings
Cir Crt Gen Jur - Incentives
Total Expenditures
Admin - Refund Fees PD Def Attorney
Total Revenues
Adrnin - Defense Atty Fees
Admin Interpreter Fees
Admin - Property Taxes
Admin - Office Supplies
Probation - Drug Testing
Total Expenditures
Administration - Defense Atty Fees
Administration - Expendable Equipment
Total Expenditures
FY 2012 FY 2013 FY 2014
AMENDMENTS AMENDMENTS AMENDMENTS
(2,780.00)
1,080.00
700.00
1,000.00
221,959.00
(221,959.00)
$ (22,000.00)
z_2,922T0
$ (5,000.00)
(5,000.00)
(2,000.00)
(3,000.00)
(7,000.00)
$ (222000.00)
$ (3,000.00)
3,000.00
FY2012_2nd_Quarter_Amendments_-__Forecast_Report.xlsx
4,819.00
25,811.00
5,000.00
(17,863.00)
10,000.00
(4,819.00)
(20,813.00)
(5,000.00)
Membership Dues
Printing
Professional Services
Expert Witness Fees and Mileage
Library Continuations
Membership Dues
Printing
Professional Services
Administration - Electrical Service
Administration - Interpreter Fees
Administration - Personal Mileage
Administration - Travel and Conference
Total Expenditures
(500.00)
(1,000.00)
(500.00)
2,000.00
Non-Dept - Into Tech Development
52-1 (Novi) - Software Support Maint
52-2 (Clarkston) - Software Support Maint
52-3 (Roch Hills) - Software Support Maint
52-4 (Troy) - Software Support Maint
Total Expenditures
(191,557.00)
64,927.00
32,745.00
64,927.00
28,958.00
County Clerk-Personal Mileage
County Clerk ROD Admin-Personal Mileage
Total Expenditures
(3,500.00)
3,500.00
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2012 FY 2013 FY 2014
AMENDMENTS AMENDMENTS AMENDMENTS
IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS
GENERAL FUND (#10100)
52nd District Court - Division IV (Troy)
Expenditures
3020501 121020 730562
3020501 121020 730982
3020501 121020 731346
3020501 121020 732018
Non-Dept1 52nd District Courts
Expenditures
9090101 196030 773630
3020201 121020 731780
03 3020301 121020 731780
3020401 121020 731780
3020501 121020 731780
Clerk/Register of Deeds
Expenditures
2010201 125000 731346
2010101 180000 731346
Prosecuting Attorneys Office
Expenditures
4010201 122050 731213
4010201 122050 731388
4010201 122050 731458
4010101 122050 730688
4010101 122050 731101
4010101 122050 731213
4010101 122050 731388
4010101 122050 731458
FY_2012_2nd_Ouarter Amendments__- Forecast _Report.xlsx
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2012 FY 2013 FY 2014
AMENDMENTS AMENDMENTS AMENDMENTS
IGF/GP OPERATIONS - SELF
GENERAL FUND (#10100)
4010101 122050 750392
ALANCING AME DMENTS
Metered Postage
Total Expenditures
2,865.00
Sheriff's Office
Revenues
4030601 110000 632093
4030601 110000 631869
4030601 116200 631869 Reimbursement of Salaries
4030401 112680 630875
4(130401 113380 630140
Sheriff Special Deputies
Reimbursement of Salaries
$ (873,894.00)
873,894.00
1,005.00
50,000.00
(1,036,659.00)
1_1985,654. acj)
Gun Registrations
Board and Care
Total Revenues
Expenditures
CD 4030301 112620 730373 Contracted Services $ (556,659.00)
4030601 116200 702010 Salaries Regular 1,005.00
4030601 110000 731626 Rent 10,000.00
4030301 112620 731059 Laundry and Cleaning 25,000.00
4030301 112620 731402 Outside Prisoner Housing (150,000.00)
4030301 112620 731199 Medical Services - Physician (300,000.00)
4030901 116240 731458 Professional Services (320,000.00)
4030301 112620 750063 Custodial Supplies 150,000.00
4030601 110000 750399 Office Supplies 30,000.00
4030301 112030 730817 Hospitalization of Prisoners 125,000.00
Total Expenditures $ (985,654.00)
Water Resources Commissioner
Expenditur es
6010101 155010 702010 Salaries $ (1,122,735.00)
6010101 149900 702010 Salaries (127,618.00)
6010101 174250 702010 Salaries (205,661 00)
6010101 174450 702010 Salaries (162,029.00)
6010101 155010 712020 Overtime 13,980.00
6010101 149900 712020 Overtime (9,000.00)
6010101 174250 712020 Overtime (25,251.00)
FY_2012_2nd_Quarter_Amendments_- Forecast Report.xlsx
Overtime
Worker Compensation
Worker Compensation
Worker Compensation
Worker Compensation
Group Life
Group Life
Group Life
Group Life
Retirement
Retirement
Retirement
Retirement
Hospitalization
Hospitalization
Hospitalization
Hospitalization
Social Security
Social Security
Social Security
Social Security
Dental
Dental
Dental
Dental
Disability
Disability
Disability
Disability
Unemployment Insurance
Unemployment Insurance
Unemployment Insurance
Unemployment Insurance
(6,701.00)
(9,630.00)
(2,255.00)
(3,720.00)
(2,910.00)
(1,593.00)
(498.00)
(775.00)
(597.00)
(202,946.00)
(52,517.00)
(84,079.00)
(64,113.00)
(165,285.00)
(38,515.00)
(63,178.00)
(48,406.00)
(40,922.00)
(10,151.00)
(16,071.00)
(12,476.00)
(10,617.00)
(2,594.00)
(4,237.00)
(3,201.00)
(1.761.00)
(427.00)
(676.00)
(525.00)
(1,901.00)
(507.00)
(805.00)
(622.00)
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2012 FY 2013 FY 2014
AMENDMENTS AMENDMENTS AMENDMENTS
GF/GP OPERATIONS - SELF BALANCING AMENDMENTS
GENERAL FUND (#101001
6010101 174450 712020
6010101 155010 722750
6010101 149900 722750
6010101 174250 722750
6010101 174450 722750
6010101 155010 722760
6010101 149900 722760
6010101 174250 722760
6010101 174450 722760
6010101 155010 722770
6010101 149900 722770
6010101 174250 722770
6010101 174450 722770
6010101 155010 722780
6010101 149900 722780
6010101 174250 722780
6010101 174450 722780
6010101 155010 722790
6010101 149900 722790
6010101 174250 722790
6010101 174450 722790
6010101 155010 722800
6010101 149900 722800
6010101 174250 722800
6010101 174450 722800
6010101 155010 722810
6010101 149900 722810
6010101 174250 722810
6010101 174450 722810
6010101 155010 722820
6010101 149900 722820
6010101 174250 722820
6010101 174450 722820
FY_2012_2rui_ Quarter,,Amendments__- Forecast_Report.xisx
6010101
6010101
6010101
6010101
6010101
6010101
6010101
6010101
155010
149900
174250
174450
155010
149900
174250
174450
722850
722850
722850
722850
771638
771638
771638
771638
Central Services - Support Services/Mailroom
Expenditures
1030820 184020 731115
1030820 184020 750154
1030803
1030803
1030803
1030803
184020 731115
184020 732018
184020 750154
184020 750399
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF1GP)
FY 2012 FY 2013 FY 2014
AMENDMENTS AMENDMENTS AMENDMENTS
GF/GP OPERATIONS - SELF BALANCING AMENDMENTS
GENERAL FUND (#10100)
M&B - Equalization Division
Expenditures maiteffi
1020501 186020 73121.3
1020501 186020 731458
Optical
Optical
Optical
Optical
Drain Equipment Labor
Diain Equipment Labor
Drain Equipment Labor
Drain Equipment Labor
Total Expenditures
Membership Dues
Professional Services
Total Expenditures
Licenses and Permits
Expendable Equipment
Licenses and Permits
Travel and Conference
Expendable Equipment
Office Supplies
Total Expenditures
(795.00)
(173.00)
(292.00)
(229.00)
1,544,205.00
244,255.00
404,745.00
301,809.00
$ 10,000.00
(10,000.00)
5,200.00
5,000.00
(5,000.00)
(3,200.00)
(1,000.00)
(1,000.00)
Public Services - Community Corrections
Expenditures
1070401
1070401
1070401
1070401
1070401
113000
113000
113000
113000
113060
732018
730373
750392
750399
731997
Travel and Conference
Contracted Services
Metered Postage
Office Supplies
Transportation of Clients
8,000.00
(8,000.00)
2,000.00
(2,000.00)
(8,000.00)
FY_2012_2nd Quarter_Arriendments_- Forecast Report.xlsx
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2012 FY 2013 FY 2014
AMENDMENTS AMENDMENTS AMENDMENTS
GE/GP OPERATIONS - SELF BALANCING AMENDMENTS
GENERAL FUND (#10100)
1070401 113060 750224
1070401 113061 788001 50800
Health & Human Services - Health Division
Revenues
1060201 133150 615675
1060220 134200 615571
1060220 134080 615571
1060236 133355 615571
Expenditures
1060201 134870
1060201 133150
1060212 133120
1060213 133130
1060220 134390
1060231 133215
1060231 133215
1060231 133215
1060231 133215
1060231 133215
1060231 133215
1060231 133215
1060231 133215
1060232 134850
1060236 133355
1060236 133355
1060236 133355
1060236 133355
1060236 133355
1060236 133355
1060236 133355
Ground Supplies
Transfer Out to Parks and Rec Fund
Total Expenditures
Health State Subsidy
State Operating Grants
State Operating Grants
State Operating Grants
Total Revenues
West Nile Virus
EA Proprietary Equipment
Laboratory Supplies
Professional Services
FA Proprietary Equipment
Interpreter Fees
Personal Mileage
Professional Services
Medical Supplies
Metered Postage
Office Supplies
Training-Educational Supplies
Insurance Fund
Medical Supplies
Salaries Regular
Retirement
Indirect Costs
Interpreter Fees
Personal Mileage
Printing
Training
740184
750168
750280
731458
750168
730982
731346
731458
750301
750392
750399
750567
774677
750301
702010
722770
730926
730982
731346
731388
731941
(4,000.00)
12,000.00
$ (147,029.00)
(21,343.00)
(15,455.00)
(472,997.00)
$ (6_5_62320)
$ (100,000.00)
(7,519.00)
(15,000.00)
(50,000.00)
(336.00)
(6,000.00)
(6,350.00)
(7,955.00)
(75.00)
(98.00)
(500.00)
(4,564.00)
(376.00)
(2,000.00)
(264,778.00)
(143,483.00)
(35,758.00)
(3,500.00)
(5,850.00)
(750.00)
(8,559.00)
FY_2012_2nd_Quarter_Arnendments_- Forecast_Report.xlsx
GENERAL FUND (#101001
1060236 133355 731997
1060236 133355 750294
1060236 133355 750301
1060236 133355 750399
1060236 133355 750448
1060236 133355 750567
1060236 133355 770667
1060236 133355 774677
1060236 133355 778675
1060236 133356 778675
1060236 133390 778675
1060236 133390 730982
1060236 133390 731346
1060236 133390 750301
1060236 133390 750392
1060236 133390 750399
1060236 133390 750567
Transportation of Clients
Material and Supplies
Medical Supplies
Office Supplies
Postage-Standard Mailing
Training-Educational Supplies
Convenience Copier
Insurance Fund
Telephone Communications
Telephone Communications
Telephone Communications
Interpreter Fees
Personal Mileage
Medical Supplies
Metered Postage
Office Supplies
Training-Educational Supplies
Total Expenditures
(96.00)
(1,000 00)
(75.00)
(800.00)
(100.00)
(4,500.00)
(200.00)
(1,500.00)
(2,689.00)
(669.00)
669.00
6,000.00
6,350.00
75.00
98.00
500.00
4,564.00
$ ..(824:0P
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2012 FY 2013 FY 2014
AMENDMENTS AMENDMENTS AMENDMENTS
IOF/GE OPERATIONS - SELF BALANCING AMENDMENTS
FY_2012___2nd_Quarter_Arnendments - Forecast_Report xlsx
FY 2012 FY 2013 FY 2014
AMENDMENTS AMENDMENTS AMENDMENTS
Grants State
Professional Services
Total Expenditures
3,595 00
3,595.00
3,595.00
3,595.00
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY I SPECIAL REVENUE FUNDS
ACCOUNT NUMBER
'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Alt Oper Unit Account Name
Circuit Court Michigan Mental Health Court Grant (MMHCGP) (#27175)
GR #0000000423
Revenues
3010301 121200 615571 Grants State (11,825 00)
$ (11,80j2)
• Expenditures
3010301 121200 731458 Professional Services $ (3,200.00)
3010301 121200 732018 Travel and Conference (4,125.00)
3010301 121200 750280 Laboratory Supplies (2,500 00)
3010301 121200 750399 Office Supplies (2,000.00)
Total Expenditures $ _ (11,825.00)
Circuit Court Michigan Mental Health Court Grant ARRA (MMHCGP) (#27177)
GR #0000000482
Revenues
3010301 121200 610313 Grants Federal 11,825.00
11,825.00
Expenditures
3010301 121200 731458 Professional Services $ 3,200.00
3010301 121200 732018 Travel and Conference 4,125.00
3010301 121200 750280 Laboratory Supplies 2,50000
3010301 121200 750399 Office Supplies 2,000.00
Total Expenditures $ 11,825 00
Friend of the Court - Access and Visitation Grant (#27120)
GR #0000000282
Revenues
3010404 126030 615571
Expenditures
3010404 126030 731458
FY_2012_2nd_Quarter_Amendments_- Forecast_Report.xlsx
FY 2013 FY 2014
AMENDMENTS AMENDMENTS
[PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Aft Oper Unit Account Name
Friend of the Court - Cooperative Reimbursement Program (#27100)
Revenues
3010404 126030 630434 CRP Contract
3010404 126030 625210 CRP
Total Revenues
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
FY 2012
AMENDMENTS ACCOUNT NUMBER
Expenditures
3010404 126030 722780
3010404 126050 722780
3010404 135140 722780
4030925 110070 722780
Drain Equipment Fund (#63900)
_a Revenues
al 6010101 149760
6010101 149760
6010101 149760
6010101 149800
Expenses
6010101 149760 702010
6010101 149760 712020
6010101 149760 722740
6010101 149760 722750
6010101 149760 722760
6010101 149760 722770
6010101 149760 722780
6010101 149760 722790
6010101 149760 722800
6010101 149760 722810
6010101 149760 722820
6010101 149760 722850
6010101 149760 771638
,FOC CS Enforce - Hospitalization
FCC Acctg/Banking - Hospitalization
FOC Family Counsel - Hospitalization
FOC Sheriff Invest/Forensic - Hospitalization
Total Expenditures
Rebilled Charges
Reimbursement General
Reimbursement Salaries
Ext - Rebilled Charges Revenue
Total Revenues
Salaries
Overtime
Fringe Benefits
Worker Compensation
Group Life
Retirement
Hospitalization
Social Security
Dental
Disability
Unemployment Insurance
Optical
Drain Equipment Labor
Total Expenses
$ (9,187,639.00)
8,965,680.00
$ 4221,959.00)
(129,195.00)
(38,581.00)
(36,733.00)
(17,450.00)
(221,959.00)
120,178.00
1,428,348.00
18,152,819.00
330,000.00
$ 20,031,345.00
$ 10,422,980.00
607,079 00
1,676,077.00
132,513.00
31,888.00
3,393,671.00
2,541,436.00
653,699.00
169,750.00
27,949.00
32,613.00
11,690.00
330,000.00
$ 20,031,345.00
631687
631827
631869
635692
FY_2012_2nd_Quarter_Amendments__- Forecast_Report.xlsx
FY 2012
AMENDMENTS
FY 2013 FY 2014
AMENDMENTS AMENDMENTS
(291,802.00)
(83,986.00)
(5,983.00)
(1,483.00)
(155,903.00)
(120,043.00)
(30,005.00)
(7,906.00)
(1,308.00)
(1,509.00)
(547.00)
700,475.00
Salaries
Overtime
Worker Compensation
Group Life
Retirement
Hospitalization
Social Security
Dental
Disability
Unemployment Insurance
Optical
Drain Equipment Labor
Total Expenses
Salaries
Overtime
Worker Compensation
Group Life
(495,361.00)
(26,599.00)
(7,449.00)
(1,926.00)
(203,110.00)
(153,956.00)
(38,786.00)
(10,166,00)
(1,676.00)
(1,940.00)
(706.00)
941,675.00
IPROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Aff Oper Unit Account Name
Evergreen Farmington S.D.S. Fund (#58410)
Expenses
6010101 149030 702010
6010101 149030 712020
6010101 149030 722(50
6010101 149030 722760
6010101 149030 722770
6010101 149030 722780
6010101 149030 722790
6010101 149030 722800
6010101 149030 722810
6010101 149030 722820
6010101 149030 722850
6010101 149030 771638
Salaries
Overtime
Worker Comper sation
Group Life
Retirement
Hospitalization
Social Security
Dental
Disability
Unemployment Insurance
Optical
Drain Equipment Labor
Total Expenses
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
ACCOUNT NUMBER
George W. Kuhn S.D.S. Fund (#58530)
Expenses
6010101 149030 702010
6010101 149030 712020
6010101 149030 722750
6010101 149030 722760
6010101 149030 722770
6010101 149030 722780
6010101 149030 722790
6010101 149030 722800
6010101 149030 722810
6010101 149030 722820
6010101 149030 722850
6010101 149030 771638
Clinton-Oakland S.D.S. Fund (#58600)
Expenses
6010101 149030 702010
6010101 149030 712020
6010101 149030 722750
6010101 149030 722760
(370,940.00)
(13,029_00)
(5,780.00)
(1,433.00)
FY_2012_2nd_Quarter_Amendments_- ForecastReport.xlsx
(149,856 00)
(110,621.00)
(28,757.00)
(7,434.00)
(1,224.00)
(1,443.00)
(507.00)
691,024.00
(15,773.00)
(141.00)
(276.00)
(62.00)
(6,522.00)
(4,903.00)
(1,251.00)
(324.00)
(54.00)
(63.00)
(22.00)
29,391.00
(5,647,921.00)
(337,533.00)
(94,510.00)
(23,521.00)
(2,474,625.00)
(1,836,529.00)
(475,280.00)
(123,271.00)
(20,298.00)
(23,823.00)
(8,419.00)
11,065,730.00
SCHEDULE B
ACCOUNT NUMBER
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
FY 2012
AMENDMENTS
FY 2013 FY 2014
AMENDMENTS AMENDMENTS
'PROPRIETARY / SPECIAL REVENUE FUNDS -SELF BAL ANCING AMENDMENTS
Dept ID Program Acct Fund Aft
6010101 149030 722770
6010101 149030 722780
6010101 149030 722790
6010101 149030 722800
6010101 149030 722810
6010101 149030 722820
6010101 149030 722850
6010101 149030 771638
Huron Rouge S.D.S Fund (#58700)
Expenses
6010101 149030 702010
6010101 149030 712020
6010101 149030 722750
6010101 149030 722760
6010101 149030 722770
6010101 149030 722780
6010101 149030 722790
6010101 149030 722800
6010101 149030 722810
6010101 149030 722820
6010101 149030 722850
6010101 149030 771638
Water and Sewer Trust Fund (#57010)
Expenses
6010101 149030 702010
6010101 149030 712020
6010101 149030 722750
6010101 149030 722760
6010101 149030 722770
6010101 149030 722780
6010101 149030 722790
6010101 149030 722800
6010101 149030 722810
6010101 149030 722820
6010101 149030 722850
6010101 149030 771638
Oper Unit Account Name
Retirement
Hospitalization
Social Security
Dental
Disability
Unemployment Insurance
Optical
Drain Equipment Labor
Total Expenses
Salaries
Overtime
Worker Compensation
Group Life
Retirement
Hospitalization
Social Security
Dental
Disability
Unemployment Insurance
Optical
Drain Equipment Labor
Total Expenses
Salaries
Overtime
Worker Compensation
Group Life
Retirement
Hospitalization
Social Security
Dental
Disability
Unemployment Insurance
Optical
Drain Equipment Labor
Total Expenses
FY_2012_2nd_Quarter_Amendments_-Forecast_Report.xlsx
ACCOUNT NUMBER
FY 2012 FY 2013 FY 2014
AMENDMENTS AMENDMENTS AMENDMENTS
7,323.00
30,332 00
37,655 00
SCHEDULE 13
, OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY SPECIAL REVENUE FUNDS
(PROPRIETARY /SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Aff Oper Unit Account Name
Drain Equipment Fund (#63900)
Revenues
6010101 149750 632401 26466 Vehicle Rental 7,32300
6010101 149750 665882 26466 Planned Use of Balance 30,332.00
Total Revenues 37,655 00
Expenses
6010101 149750 776661 26466 Motor Pool
6010101 149750 788001 66100 26466 Transfer Out to Motor Pool Fund
Total Expenses
Motor Pool Fund (#66100)
Revenues
1030811 184010 631071 Leased Equipment
1030811 184010 695500 63900 Transfer In from Drain Equip Fund
Total Revenues
7,323.00
30,332.00
37,655.00
—1 Expenses
I" 1030811 184010 761156 Depreciation Vehicles $ 7,323,00
1030811 184010 796500 Budgeted Equity Adjustment 30,332.00
Total Expenses $ _ 37,655.00
Economic Development Corporation (EDC) Fund (#21180) . .
Revenue
1090202 171110 630280 Closing Fee $ 35,000.00
Total Revenue $ 35,000.00 —
Expenditures
1090202 171110 730072 Advertising $ (4,500.00)
1090202 171110 730709 Fees - Per Diems (3,500.00)
1090202 171110 731241 Miscellaneous (1,000.00)
1090202 171110 731388 Printing (1,000.00)
1090202 171110 731507 Public Notices (4,000.00)
1090202 171110 731818 Special Event Program (1,000.00)
1090202 171110 732165 Workshops and Meetings (2,000.00)
1090202 171110 732018 Travel and Conference 3,500.00
1090202 171110 750399 Office Supplies (500.00)
1090202 171110 788100 21184 Transfer Out to BFC Fund (21,000.00)
Total Expenditures $ (35,000.00)
FY_2012_2nd j_Quarter_Amendments_-___Forecast_Reportxlsx
Expenditure
1090202 171100 796500 Budget Equity Adjustments
Total Expenditure
(21,000.00)
(21,000ç)
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
ACCOUNT NUMBER
FY 2012 FY 2013 FY 2014
AMENDMENTS AMENDMENTS AMENDMENTS
!PROPRIETARY I SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Aff Oper Unit Account Name
Business Finance Corp (BFC) Fund (#21184)
Revenue
1090202 171100 695500 21180 Transfer In from EDC Fund
Total Revenue
(2100000)
12100000)
HEALTH - Adolescent Screeninq (#283101
GR#0000000467
Revenue
1060234 133930 610313 Federal Operating Grants $ 36,500.00
Total Revenue $ 36,500(X)
Expenditures —.4
w 1060234 133930 702010 Salaries Regular $ 17,078.00
1060234 133930 722740 Fringe Benefits 1,140.00
1060234 133930 730926 Indirect Costs 2,589.00
1060234 133930 731031 Laboratory Fees 13,200.00
1060234 133930 731346 Personal Mileage 333.00
1060234 133930 732018 Travel and Conference 50.00
1060234 133930 750301 Medical Supplies 167.00
1060234 133930 750399 Office Supplies 42.00
1060234 133930 774636 Info Tech Operations 1,614.00
1060234 133930 774677 Insurance Fund 101.00
1060234 133930 778675 Telephone Communications 186.00
Total Expenditures $ 36,500.00
HEALTH - TB Control (#28556)
GR#0000000192
Revenue
1060235 133970 610313 Federal Operating Grants 5,763.00
Total Revenue 5,763.00
Expenditures
1060235 133970 730982 Interpreter Fees 100.00
1060235 133970 731031 Laboratory Fees 10,913.00
1060235 133970 731346 Personal Mileage 1,440.00
FY_2012_2nd_Quarter_Arnendments_- Forecast_Report.xisx
HEALTH - Aids Counseling (#28557}
GR#0000000194
Revenues
1060294 133940 610313 Federal Operating Grants
Total Revenues
248,950 00
248,950.00
SCHLL
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2012 SECOND 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
1060235 133970 731388 Printing
1060235 133970 731458 Professional Services
1060235 133970 731941 Training
1060235 133970 732018 Travel and Conference
1060235 133970 750245 Incentives
1060235 133970 750301 Medical Supplies
1060235 133970 750399 Office Supplies
Total Expenditures
FY 2012 FY 2013 FY 2014
AMENDMENTS AMENDMENTS AMENDMENTS
(100.00)
(200,00)
(1,700.00)
(750.00)
(1,250.00)
(2,000.00)
(690.00)
5,763.00
Expenditures CII
1060294 133940 702010 Salaries Regular
1060294 133940 722740 Fringe Benefits
1060294 133940 730072 Advertising
1060294 133940 730926 Indirect Costs
1060294 133940 730982 Interpreter Fees
1060294 133940 731346 Personal Mileage
1060294 133940 731388 Printing
1060294 133940 731941 Training
1060294 133940 731997 Transportation of Clients
1060294 133940 732018 Travel and Conference
1060294 133940 750280 Laboratory Supplies
1060294 133940 750301 Medical Supplies
1060294 133940 750392 Metered Postage
1060294 133940 750399 Office Supplies
1060294 133940 770631 Bldg Space Cost Allocation
1060294 133940 770667 Convenience Copier
1060294 133940 774636 Info Tech Operations
1060294 133940 774677 Insurance Fund
1060294 133940 778675 Telephone Communications
Total Expenditures
148,947.00
58,437.00
(18,569.00)
42,149.00
200.00
1,851.00
1,108.00
366.00
200.00
1,000.00
205.00
3,000.00
250.00
200.00
4,336.00
200.00
1,450.00
620.00
3,000.00
248,950.00
FY_2012_2nd__Quarter_Amendments__- Forecast_Report.xlsx
[PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Aft Oper Unit Account Name
HEALTH - MCH Block Grant (#28563)
GR#0000000207
Expenditures
133190
133190
133190
133190
133190
133190
133190
133190
1060291
1060291
1060291
1060291
1060291
1060291
1060291
1060291
Salaries Regular
Fringe Benefits
Indirect Costs
Interpreter Fees
Personal Mileage
Printing
Training-Educational Supplies
Info Tech Operations
Total Expenditures
702010
722740
730926
730982
731346
731388
750567
774636
(13,772.00)
(5,799.00)
(2,088.00)
1,900.00
2,370.00
2,000.00
4,189.00
11,200.00
(11.976.00)
(17,092.00)
2,078.00
6,900.00
2,200.00
(1,722.00)
4,200.00
300.00
11,200.00
3,912.00
SCHEDULE B
ACCOUNT NUMBER
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY !SPECIAL REVENUE FUNDS
FY 2012
AMENDMENTS
FY 2013 FY 2014
AMENDMENTS AMENDMENTS
HEALTH - Nurse Family Partnership (#286071
GR#0000000279
Expenditures
1060231 133215
1060231 133215
1060231 133215
1060231 133215
1060231 133215
1060231 133215
1060231 133215
1060231 133215
1060231 133215
1060231 133215
Facilities Maintenance & Operations Fund (#63100)
Expenditures
1040755 148399 730562
1040740 148100 730779
1040745 148199 731269
1040701 141000 788001 40400
Salaries Regular
Fringe Benefits
Interpreter Fees
Personal Mileage
Printing
Training
Incentives
Training-Educational Supplies
Info Tech Operations
Telephone Communications
Total Expenditures
Electrical Service
Fuel Oil
Natural Gas
Transfer Out to Project Work Order Fund
Total Expenditures
702010
722740
730982
731340
731388
731941
750245
750567
774636
778675
(206,500.00)
(200,000.00)
(200,000.00)
606,500.00
FY2012_2nd_Quarter_Amendments__- Forecast_Report.xlsx
12,000.00
12,000 00
12,000.00
12,000.00
Fringe Benefit Fund (#67800)
Revenues
9011501 183190
9011501 183190
9011501 183190
9011501 183190
9011501 183190
9011501 183190
630484
630490
630896
631583
631954
632114
SCHEDULE B
ACCOUNT NUMBER
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
FY 2012
AMENDMENTS
FY 2013 FY 2014
AMENDMENTS AMENDMENTS
[PROPRIETARY / SPECIAL REVENUE FUNDS- SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Aft Oper Unit Account Name
Project Work Order Fund #40400
Project # 100000001623- Jail Rooftop Air Handling Units
Project # 100000001624- Courthouse HIVAC System Term Boxes
Project # 100000001625- Courthouse - Replace Cooling Coils
Revenues
1040801 148020 695500
1040801 148020 695500
1040801 148020 695500
1040801 148020 796500
63100 Transfer In (Jail Rooftop Air Handling Units) $ 306,000 00
63100 Transfer In (Courthouse HVAC System Term.Boxes) 215,000.00
63100 Transfer In (Courthouse Replace Cooling Coils) 85,500.00
Budgeted Equity Adjustment (606,500 00)
Total Revenues
Information Technology Fund (#63600)
Expenditures
1080101 152000 731458 rt..)
ro 1080201 152010 731458
Admin - Professional Services (200,000,00)
Application - Professional Services 200,000.00
Total Expenditures
Parks and Recreation Fund (#50800)
Project #100000001597
Revenue
5060201 160930 695500
Expenditure
5060201 160930 796500
10100 Transfer In from General Fund (Comm. Corr.)
Total Revenue
Budgeted Equity Adjustments
Total Expenditure
Deferred Compensation - Match 110,100.00
Defined Contributions County (1,000,060.00)
Hospitalization Insurance (5,800,000.00)
Prescription Coverage Insurance (300,000.00)
Retirement Administration PTNE 320,000.00
Social Security (1,000,000.00)
Total Revenues $ _1:L669,90000)
FY2012_2nd_Oriarter _Amendments_-__Forecast_Report.xlsx
Dept ID Program
Expenditures
9011501 183190
9011501
9011501
9011501
9011501
9011502
183190
183190
183190
183190
183190
SCHEDULE B
ACCOUNT NUMBER
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
FY 2012
AMENDMENTS
FY 2013 FY 2014
AMENDMENTS AMENDMENTS
'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS J
Acct Fund Aft Oper Unit Account Name
730499 Deferred Comp - County Pymts
730506 Defined Contribution County Retirement
730870 Hospitalization
730872 IHospitalization Prescription Coverage
731766 Social Security Expense
730989 Investment Counsel
Total Expenditures
110,100.00
(1,000,000.00)
(5,800,000.00)
(300,000.00)
(1,000,000.00)
320,000.00
(7,669,900.00)
FY_2012_2nd_Quarter_Amenclments_- Forecast_Report.xlsx
SCHEDULE C
n Aar_ynt.=_
SECOND CliiARIER AMENDMENT TO REDUCE DEPARTMENT ACCOUNT 722102 HOSPITALIZATIO
USCTY BUDGET
USCTY BUDGET 10100 1010105 181000 722080
UDUTY BUDGET 10100 1010201 181010 022780
USCTY BUDGET 13102 1010501 181020 722780
USCTY BUDGET 10100 1020101 182010 122781
USCTY BUDGET 10100 1020401 182090 722700
LISCTY BUDGET 10100 1020E01 182100 722780
USC1 Y BUDGET 10100 1020401 182110 722780
05C1Y BUDGET 101011 1020501 173010 722780
USCTY BUDGET 10100 1020501 173020 722780
20018 BUDGET 10100 1020501 173030 722780
USCTY BUDGET 10100 1020501 173040 722780
USCTY BUDGET 10100 1020501 173050 722780
IISCTY BUDGET 10100 1020501 173000 722/80
USC TY BUDGET 10100 1020501 186000 722780
USCTY BUDGET 10100 1020501 186010 722780
USCTY BUDGET 10100 1020501 196020 122700,
USCTY BUDGET 10100 1020501 196030 722780
USCIY BUDGET 10100 1020001 182020 722790
USCTY BUDGET 10180 1020601 102040 722180
USCTY BUDGET 10100 102063I 182050 722780
USCTY BUDGET 10100 1020601 182080 722760
ASCII BUDGET 10100 1020650 126000 722780
USC.TY BUDGET 10100 1020650 121010 122780
USC I Y BUDGET 10100 1020650 126020 722780
USCTY BUDGET 10100 1030101 184000 722780
tISCTY BUDGET 10100 1030801 184038 722780
US/IT BUDGET 10100 1030803 184020 722780
USCTY BUDGET 10800 1030803 184025 722280
USGTY BUDGE( 10100 1040101 140000 722780
USCTY BUDGE] 10109 1040801 148020 722780
USCTY BUDGET 10100 1050101 183010 72276U
USC11 6002001 10100 1050102 183010 722780
USCTY BUDGET 10100 1050401 183010 722780
41,1 USCTY BUDGET 10100 1010402 183020 722780
US/TV BUDGET 10100 1050402 183030 722780
USCTY BUDGET 10100 1050415 183090 722780
US/TI BUDGET 10100 1050501 163010 722780
USCTY BUDGET 10100 10601(11 133000 722790
US/TV BUDGET /0700 1060201 133020 722790
USC17 BUDGET 10100 10611201 151150 722780
USCTY BUDGET 10100 1080201 133170 722780
USCTY BUDGET 10100 1060201 134390 722/80
USG I Y BUDGET 10100 1060211 133020 722780
USCTY BUDGET 10100 1060211 133150 722780
USC 1Y BUDGET 10100 1060211 133390 722780
USCIY BUDGET 10100 1060211 133900 722780
USCTY Bt1DGE1 10100 1010211 134390 722780
USGTY BUDGE1 10100 1060212 133120 722700
USCP( BUDGE1 10100 1060213 133130 722780
USCTY 45D0E1 10100 1060214 133150 722780
USCTY BUDGET 10100 1090218 133150 722760
USCTY BUDGET 10100 1060220 134190 722760
tiSCTY BUDGET 10100 1060220 13.4390 Z22/80
USCTY BUDGET 10100 1060231 133150 722780
USCTY BUDGET 10100 1060231 133390 722780
USCTY BUDGET 10100 1060231 133990 /22780
LISCTY BUDGET 10100 1060232 134850 722180
US/YE BUDGET 10100 1060233 133350 722780
USCTY BUDGET 10100 1060233 133210 722780
US/TI BUDGET 10100 1060233 133390 722790
USCTP BUDGET 10100 1060234 133990 722780
USC I Y BUDGET 12100 1060230 133300 Z22780
USt2TY BUDGE/ 10100 1060237 133300 722780
USCTY BUDGET 10100 1060237 131310 722780
USCTY BUDGET 10100 1060237 13370" 722/80
USC I Y BUDGET 12100 1040261 134790 722780
USCIY BtiDGET 10100 1060243 133120 722780
USCTY BUDGET 10100 1060601 115090 722780
Scenario . ' Roam) :/ett.31ptiort
D_51,1E NO 013,4351 001pila1.2,5,0 (1143512) (01,31120
C_AMEND (14,034) HospilaliEation (14,033.85) (35 020.00
C_AMEND (7021) Hosp7a0139.41 (7.020 51) 5294 TOO
1A1/COD (20,514) 11o91919',.k. 120513.71) 154692 00
C_AMEND /2074/ HaspitaMotion (2,601 52) 20.15300
('_A1.1END (15661) Hovilallzation (15 60971) 118,096 00
C_ANIEND (1.925) Howitalliation (1.92623) 14 5180,1
C AMEND (2.765) No5p4taliz1lion 02,765.18) 20.852.00
C_AMEND (29.915) Hospitalization 129 915 49) 225E90.00
C_AMEND (40 099) IloSINtailz91199 (49699 05) 374.776 00
Catorrlo (27,247) Hospitalization (27,24) 38) 205,4(0 (10
0 _AMEND (4.777) HospitaliEation (4,777 14) 36.024 00
CAMEND (7.827) Finspilalization (7.127.171 53,029.00
CAMEND (2.533) 110%/I 141,14711,1 (2,532.59) 14 008.50
i0_AMEND (11A51) Hos-pitalization (11.451.40) 70350/0
C_
AMEND (12.429) liospitalization (12,429 .10) 03(0900
QAMEND (7,080) Hospilatization (7 OM 31) 5338200
C_AMEND (3,854) Hospitalization (3 653,65) 29 050 00
C_AMEND (0,664) lio5pitailzatIon 1966422/ 72,877 00
Q AMEND (13,491) Hospitalizaton (13,491.21) 701.730/0
C_AMIND (34,950) HHspitailEatIon (34,95944) 263.62690
C_AMEND (46.500) Hovimlization (46A9956) 350640 00
CAMEND (22,758) HospitalMation (22,767131) 171.690 00
CAMEOS (20642) Ho'4,itaii,aiioo (20541 9E) 75400580
C_AMEND (5,374) Hospitalization (5,374 29) 40 527 10
C_AMEND (1,920) Hospitalization (1,925 23) 14 578 78
C_AIMEND (9.538) Hospitalization (4,53752) 34 217 00
CAME ND (114044) Hospitalization (11.043 76) 83,230.00
C_AMEND (0.378) Hospitalization (9177 15) 70,716 00
QAMEND (2533) Hospitalization 1201259/ 1503000
QAMEND (14.8)3) HOsp,lbatian (14 813 20) 111,70500
C_AMEND (2.7651 Hospitalization (2.76518) 20.552 00
C_AMEND (8919) •,.. pitaiMation (8.918 82) 67.25600
C_AMEND (1.925) "H..9.1,82,1.33 (1.92623) 14.518 00
C_ANIEND (1.925) Ho .9mli7010,0 (1,925.237 14.51800
C_AMEND (292)0) 1,.spitalization 20.26997) 7520') 00
C_AMEND (7,266) Hosoita)izatioti (7 295 37) 54 70500
C_ AMEND (837) H0spitalizat991 (33677) 6,310.00
C_AMEND (2533) Hospitalization (251250) /0.018/"
C_AMEND (12.241) Hospitalization (12241 in) 32,309 00
C _AMEND (17,951) 73o5pimli2ation (12,950.62) 135,364.001
C_AMENO (9523) H5spitalizalion (052200) 71.112 DD
C_AMEND (880) Hospitaliealion (810.13) 6637.00 .
C_AMEND (5.290) Novitalization (5.290 21) 35,603 00
e_AMEND (29,630) Hosmalization 129E29 85) 223,43500
C_ AMEND (5665) HospItalizatinn (5,165.17) 38 196 DO
C_AMEND (30,300) Hospitalization 3117846/ 226 493 00
C_AMEND (10,341) Hospitalization (10 39993) 77 98D 00
C_BMEND (8,311) Hospitalization (8311.46) 5207600
QAMEND (6.383) Hospl1ali1a8on (6,333.n) 48,134 00
C_AMEND (4 458) Hospitalizabon (4,45762) 33.616 00
C_AMEND (3933) Ho9pitall7alion (383335) 29,861 00
C_AMEND (4 458) Hospitalization (4.407 82) 33616 00
C AMEND (95,145) Hosptaliz2tio0 (35.144 76) 117478 00
C_AMEND (4,679) Hospilaimaticm (4673 75) 35,28200
C_ AMEND (1,925) Hospitafization (1.92523) 745/700
C AA1END (832) Hospitalization (632_39) 627' 00
C_AMEND (9039) HospitalizatIc30 (6.038 79) 45.536 00
QAMEND (12,816) HospitatBation (12615 83) 9004300
C_AMEND (6351) Hospitalization (6351 11) 02,975 00
C_AME HD (5,065) Hospitalization (506517) 17 196 00
.,_AMEND (54 834) Hospitalizalion (54.833 97) 413.498 00
C _AMEND (99.755) hlospitalizalion (99754.68) 752,241.00
C_/MEND (937) Hospitalization • ' ' (136.77) 6 310 00
0_AMEND (2.404) Hospitalization (2,411182.) 1812/ 00
C_AMEND (1.9251 Hospitalization (1.925 23) 14,51900
C_AMEND (4,458) llospitalinition (4.45/ 82) 33 616 00
C AMEND (2.762) t)nsplIalaation (2.76290) 2062900
QAMEND (10.847) NOapitatiTatIOn (10.847 23) 51 796 00
:30RIPTION REV AND /IS" ACCOUNTS I DRAFT 621712
10100 1610101 181000 (22860 0.22%
0.23%
12%
0.3E%
D.C.%
0.26%
0 03%
DO./'U
049%
0.81%
0 45%
0.0!1%
0 13%
0.04%
0 10%
0.20%
612%
Tools
0.16%
0.22%
0S75
079%
0.37%
034%
0.00%
003%
097%
018%
0,15%
0.09%
0.24%
0.05%
0.15%
003%
0.03%
0.33%
12%
0.01%
01(0',
0.2011
0 13%
0/177'
0)10%
0 40%
0/18')
019)%
1)7',
n 14%
BEG.
0 57%
036',
0 07%
1 56%
0757
0.03%
091%
910%
0.21%
914%
000
TOO
1 64%
001%
00475
A03%
001%
0 05%
0.18%
C.)Docurnexnls and Settin464.11,1,LoCai ump,iary Intern. 001,1,nle,101itiookltiA.Z7vEN1ACCT 722770 iiaspitcEmatipo BneMei Amendment 41..
SECOND QUARTER AMENDMEN I 1 REDUCE DEPARTMENT ACCOUNT 72278C ".10SPIIAOZATIONIFRINGE BENEFIT HOSPITA1 IZATION'PRESCRiti HON REV AND
liZEIZT=11. IMAM :ATTiroTact 1 OU iT-.1v1 l00ls,1-12.(!li
DRAFT 011412
SCHEDULE C
LTSCTY BUDGET 10100 1060601 115120 722780
USCTY BUDGET 10100 1070101 132020 722780
USCTY BUDGET 10100 1070301 132050 722780
USCTY BUDGET 10100 1070301 132080 722780
USCTY BUDGET 10100 1070401 113000 722780
USCTY BUDdEr 10100 1070402 113000 722780.
USCTY BUDGET 10100 1070402 115310 422180
0750.10 BUDGET 10106 1070402 113020 722750
USCTY BUDGET 10100 1070302 113050 722700
USCTY 0UDGE1 10100 1070402 113130 722760
USCTY BUDGET 10100 1070402 123000 722760
USCTY BUDGET 10100 1070402 123010 722780
USGTY BUDGET 10100 1070403 113050 722780
USCTY BUDGET 10100 1070403 113060 722780
USC 11 BUDGET 10100 1070403 123010 722780
USCTY BUDGET 10100 1070410 113000 722730
(SCOT BUDGE) 10100 1070410 113080 022700
USCTY BUDGET 10100 1070410 113130 722760
USG (Y BUDGET 10100 1070412 113120 722780
1,10210 BUDGET 10100 1070412 113140 722780
LISCIY BUDGET 10120 1070412 123000 722780
USCTY BUDGET 10730 1000412 123010 722780
USCTY BUDGET 101011 1070501 131030 722700
USCTY BUDGET 10100 1970501 132170 722750
1./SGTY BUDGET 10102 1070501 174000 722780
USCTY BUDGET 10100 1070510 174170 722480
US/TV BUDGE 10100 1070601 132030 722/80
USCTY BUDGET 10130 1070801 114000 722780
4)5010 BUDGET 10100 1070801 114090 722780
USCTY BUDGET 10100 1070805 114090 722700
uscry BUDGET 10100 1070E40 114100 122780
USGTY BUDGET 10100 1090101 171000 722180
ha)
USCTY MIDGET 10100 1090101 171030 722780
USCTY BUDGET 10100 1090100 171030 722780
USCTY BUDGET 10100 1090201 171000 722780
USCTY BUDGET 10100 1090201 171000 722780
USCTY BUDGET 10100 1090202 171100 722780
USCTY BUDGET 10100 1090224 172020 722780
USCTY BUDGET 10100 1090204 172040 722700
USC1 Y BUDGET 10100 1090204 113100 722780
USERS BUDGET 10100 1090204 174210 722780
USCTY BUDGET 10100 1090205 171010 722780
USCTY BUDGET 10100 1090205 171090 722780
USCTY BUDGET 10100 1090207 114230 722780
USCTY BUDGET 10100 1090650 132210 722780
USCTY BUDGET 10100 2010101 180000 122780
LISCTY BUDGET 10100 2010201 125000 722700
C_AA1END (58) Hospitallzalion
C _AMEND (2005). Hospitalizalion
41,1T ND (32.685) Has.pitalization
CT...AMEND (832) Hospitalization
C. atiiNND 0,0007 Hospitalization
C_AMEND (1.926) Hospitalization
C_AMEND (3 506) Hospitalizatkm
C_AMEND (6.990) Hospitalization
C_AME ND (1927) Hospitalization
Li...AMEND (1928) Hospitalization
(AMEND (637) Hospitalization
5671 00 (7,307) Hospitalization
D_AtIEND (1.925) Hospitalization
C_AMENO (3,457) Hospitalization
C_AMEN) (2,533) Hospitalization
c_AMEND (2033). 1.1ospilnlization
C. AMEND (3.369) Hospitalizatian
G_AATE ND (2.533) Hospilailzation
C,_AMEND (1.920) Hoapitallzation
C_AMEND (2.533) Hospitalization
C_AMEND 41 925) Hospitalizalion
C AMEND (7.598) Hospitalizanlon
C_AMIEND (6211) Hospilalization
AMEND ('065) Hospitalizadon
C_ AMEND (4,458) Hospitalization
C_AMEND (737) Hospitalization
C...78.1END on 017) Hospltalizatioii
C _AMEND (38)2) Hospitalization
C_AMEND (1 928) Hospitalization
C_AMEND 06397 Hospitalization
C_AMEND (267627 I inspitafization
C. AMEND (4,461) 1 lospitalizatim
C_AMEND (2,533) Hospitalizatian
C, AMEND (10,442) Hospitalization
C_ATTEND (I 006) Haspitalizalion
C. 741600 (43) Hosp(talizalion
C_AhAEND (1.925) Hospitalization
C_AMEND (2.533) Hospilalization
C_AMEND (8660) Finspitalization
.AMEND (5085) Hospitalization
C. AMEND (5.785) Hospitalization
C_AMEND (20 517) Hospitalization
71AMEND (11.455) Hospitalization
C_AMEND (5.644) Hospitalizallon
C_AWND (14) (inapitalization
C_AMEND (7.106) Hospitalization
C_AMEND (2.762) Hospitalization
_LEY 2012 ikinentilt0 B . _
(57.821, 0. 30 050'
•:04 93, 15 119 00 ROT',
(324.'5 Inn 445,416 DO 0 54%
(832.391 6277.00 0016
(000950) 60.324 00 0.13%
(1.925 23) 14.513 OD 0.03%
(1506.21) 26,440 00 0051
(695040) 52.71400 0.11%
(1,928 41) 14,542 00 003%
(1 928 41) 14 542.00 0 03%
(83).461 4 80700 0.01%
030055) 55 097 00 2.12
(1,925.23) 1451600 000/,
(3.457,28) 26071.00 0007
(2.532.59) 19,098 00 0045
(2532.59) 12.098 00 004'
(4,369 35) 25.404 li0 0.061,
(2.502.59) 16097 00 B.C4%
(1925.23) 14.817 00 0.030
(2 532 59) 19 005 00 0040
(1,925.23) 14.518 09 03%
(7.597.761 52.294.00 0.12%
(6211 75) 4773103 00.0'
(5.065 17) 38196 no 0.06N
(4.457 82) 33.516 00 0.072,
(035.77) 6 310 00 0.01%
(30816.84) 232 347 00 0.51%
(3.001 95) 27.162 00 026%
410)8401 11,4200 6030
(9639 16) 72,678 00 0.16%
42918229) 201,912 00 0.44%
(4.461 00) 33,640.00 0.07%
(2.53269) 152'l9 00 0.04%
(7144211 78 743 00 0,17%
(1,005.85) 7 585 00 0.02%
44136) 327 110 0.00%
(192523) 4451000 (103%
(253269) 7410000 0.045,
(4659.57) 65,301.00 0 14%
(5,065 17) 38,190 ,30 0.08%
(5,78.5 24) 43.626 00 0.09%
(20,51662) 154 714.00 004%
(11.454.59) 80.378 0.19%
15.643.75) 42,559.00 09%
(14.457 109.00 020'
17 406 04) 53,556 00 0.127
(2.762.00) 20,82800 0.05%
CilDuptanents and Sottingsisnalialaii 7706 SellingsilenIwravy Interne/ Fkles,Cont,,n1 Onitoc.011.AZ,VBNTACC1 723760 ito.spitnization 5709,1 74705)15201 411
SCHEDULE C
sEcoN0 QuARTER AMENDMENT TO 980( 30 UF,ABTMin:T ...,^.0, )1T 722780 HOSPITAIIZATIGNfr HINGE BENEFIT lIOSBN AL:,... 110Nil i•LSCRIPTIDN REV AND EXP ACCOUNTS f DRAFTS /1/12 . _ ,
lUnd .. 1,11:0211LEMD•pt .__.... Man Furid A Imo" Pi. Unit Ac11411.-: Anal Sls Reis 7 • Scenarlo . Round la $ .,_.(2),%1140114C7 '. ...„17_,... '' o1),.,_____.) r1)))11 . IF-Y.2012 8TJ
USE,)')' BUDGET 10100 2010205 1323(0 722790 C _ AMEND (17,204) Hospitalization (17.20363) 129 731 00 0.28%
. USCTY BUDGET 10100 2010210 125000 /22789 C_AMEND (61,103) 000508aliza110n (61.102 84) 450 771 00 I no,
USCTY 0L1DGET iotao 2010210 132300 722730 C AMEND (I928) HtMp02li0ali,,r, (1921 41) 14.512 00 0 039,
U//OTT BUDGET 10100 2010301 185010 722780 1' AMEND 813.477) 11050040740o0 113.477.42) 101632 00 0 22%
USCTY BUDGET 10100 2010401 172190 722750 C._AMEND (62639) 6000114t7041I00 (62.839.11) 473,864.00 1 03% .
usCTY BUDGET 10100 2010501 172190 722760 C_AMEND (11,596) Hospitalization (11,55.9.5) 814440) 0 1,93,
//SC /9BUDGET 10100 3010101 121100 722780 CAMEO()) (7,598) liospit4li4a56)1 (7.597.76) 51,294 00 a ,2%
USCTY BUDGET 10100 3010101 121120 722780 1/ AMEND (27.134) 110,p2t4ll041i4n (27,133.86) 204,614 00 0.44%
USG]," BUDGET 10100 3010101 121130 722780 GAS/END (105896) Ho,italization (105 698 39) 797062.00 1 n%
USGTY BUDGET 10100 3010101 121210 722700 C_AMEND (8.236) 1,5,03112,00m (3,238.26) 62,12400 0 '14%
USCTY BUDGET 10100 30)0101 121220 722780 C_AMEND (17224) Hospil4LI441i44n 8 )7,223.74) 129.1.03 00 0.28%
USG)) BUDGET 10100 3010201 121100 722780 C_AMEND 07,714)0017/0824/14')), (37 714 02) 284,394.03 0627,
USCTY 6UDGE1 10100 3010301 /21/00 722780 C_AMEND (3,385) Hospitar.allon (3,36498) 25,375.00 0.06%
USCTY BUDGE) 10100 3010301 12)130 722750 G_AMEND (4715) Hosplalizati,),1 (4.714.95) 39,555.00 au%
USCTY BUDGET 10)00 3010101 121140 722780 C_AMEND (9504) Hospitalizatiun (9503.09) 71 67000 0.10%
ASCII BUDGET 10100 3010301 121150 722780 C_AMEND (3,154) 6405pit0I474tI))0 (365365) 2005070 0,06%
USCTY BUDGET 10100 3010301 121180 722780 C_A.MEND 12.533) Hospitalization (2.532.59) 1302600 03/4)
USCTY BUDGET 10100 31310301 121170 722760 C_AMEND (2533) Hospitaitration (2 532 59) 8009600 0041'
USCLY BUDGET 10100 3010101 121130 120780 C_AMEND (6.506) Ho,pltalization (6,506 11) 49.062 00 0.11%
USG1 Y BUDGET 10100 3010301 121190 722780 CAMEND (2,765) Hospitalization (2,715 13) 20,852 00 0,257,
USCTY BUDGET 10100 3010402 111000 722780 0._08)1E74D (48,314) Hospilalizalfon (43,314 20) 304,333.00 0,79%
USC.TY BUDGET 10100 3010402 1211(0 722092 C_AMEND (837) )10,4,114l1131ion (836,77) 5,310 DO 0 71%
USCTY BUDGE1 10100 5010402 139160 722750 C_AMEND (44.716) Hos(lalizatkm (44.71596) 337 105)0 0.73%
USCTY BUDGE! 10100 30)0402 135070 722780 QAMEND (1.581) 7o:01011,60 (1.580.98) 11.922.00 0.03%
uSCTY BUDGET lnioo 30104)0 121100 722780 GAMEND (5.298) Hwitalization (5,207.77) 39 950 00 ))09%
USCTY BUDGET 10100 31710403 121230 722780 C AMEND (17,237) Flospitaftation (17 235.91) 129 932 DO 020)
uSCTY BUDGET 10100 3010403 121240 722760 1/_At..1END (46255) Hospitalization 146.255.301 348,017 00 0.760'
LISCIY BUDGET 10100 3010403 135080 722780 C_AMEND (8.912) Hospitalization (8912 19) 6720000 0)21),
USGTY BUDGET 10100 3020101 121020 722780 C_AMEND (173) I inspitaTuabon (173 45) 1,308 00 am%
8/SC1Y BUDGET 10100 3020201 121020 722780 C AMEND (58,535) flospiialization (53.535.12) 04 1.408 00 09/',
UsGTY BUDGET 80100 3020205 813290 722780 CAM,. (26517) Hospitafizatior) (26716631 210.551.00 7 47%
USCTY BUDGET 19100 3020301 121020 722780 C_AMEND (05681) Hospitalization 05,461 22) 270,577 00 0.59%
IN.3 USC)Y BUDGET 10100 3020305 113290 722780
USCTY BUDGET 10100 3020401 113290 722700
C_AMEND
C. AMEND
(5,524) )1osplIalination
(2.533) Hospttalization
(5,524.00)
(2,532.89)
41 656.00
1900E1 00
0.09%
004%
03 LiSCTY BUDGET 10100 1020401 121020 722780 1/AC/END (56604) Hospitazation {56,604 02) 428 354 00 0 93%
DECTY BUDGET 10107 0020405 113290 722780 C_AMEND (19.064) 605pitaliZa070 (19050 67) 143 682 00 0.31%
USCTY 6l1)30E2 10100 30211405 121020 722060 C_AMEND (2.005) Hospitalization /0074 93) 15,119 00 0.03%
USCTY BUDGET 10100 3020501 121020 722760 C_AMEND (36 240) Hospitalizahon (36239 79) 273.261 00 8597'
USCTY BUDGET 10100 3020505 113290 722780 C_AMTNO (0016/ Hospitalization (0985 64) 87,232 00 0.15%
USCTY BUDGET 10100 3020509 121020 722789 C_AMEND (837) Hospila)i,ation (436.77) 6.310 00 078%
USCTY BUDGET 10)00 3040101 121015 722780 C AMEND 037) Hospitalizatio, (836.77) 0.310 00 0.01%
LISCTY BUDGET 10100 3040101 120090 722780 C_AMEND (29,9141 10054,3141i1216,n (29,613 91) 224 824 00 0 40%
USCTY BUDGET 10100 3040101 121091 722780 C_AMEND 0,571) H0,4,412i170100 (8571 38) 64,638 00 0.14%
USC1 Y BUDGET 10100 3010403 121015 722780 1/ AMEND (6900) 00,11141 783(40 1669780/ 52 714 DO 0.11%
*SC TY BUDGET 10100 3040403 124015 722780 G_AMEND (40.410) HospitalBation (10 4)0.31)) 304 73/1)4 0.66N
USC TY BUDGET 10100 4010101 122000 722790 C_AMEND (12569) Howitalization (12866 51) 97.041 00 621%
USCn BUDGET 10100 4010101 125210 122780 CAE/END (11 833) Hospitalb)alim (11.698 19) 88.215 00 0 19%
CAGEY BUDGET 10100 4010101 135170 722780 C...AMEND (11 5417 Hospltali7alion (11.541 31) 87,032 00 0 19%
USCTY BUDGET 10100 4010201 122000 722780 C_AMEND 81 948) Howilali>ation (1.928 41) 11 542 71 0.03%
CADocuments and Set)ings)smilhla)l ocal Set)) pkTemporary Internet Files)Content Gollook)11AZT)/PN)ACCT 722780 Hospitalizalion 80,1901 Amendment xls
SCHEDULE C
SECOND WARIER AMENDMENT TO REDUCE DEPARTMENT A
[0a=edgii,47TEER:=11111.111' Pro9raa1 !Acct.
USCTY BUDGET 10100 401020) 122032 722780
USCTY BUDGET 10100 4010201 122041 727789
USGTY BUDGET 10100 4010201 122050 722780
USCIY BUDGET 10100 4010201 122060 722780
USC1 Y BUDGET 10100 4010201 122080 722780
1161.7.7Y BUDGET 10100 4010301 122050 722780
USCTY BUDGET 10100 4010301 122060 722780
USCTY BUDGET 12100 4010401 122050 727780
05004 BUDGET 10100 4030101 112580 722770
4113017 BUDGET 10102 4030201 112570 722780
USC I Y BUDGET 10100 4030201 113360 722780
1.10116 BUDGET 10)00 4030301 112590 722710
05016 BUDGET 10100 4030301 112620 722780
6/SCSI BUDGET 10100 4030301 112630 7227130
SOOTY BUDGET 10100 4030301 112650 722780
1.1.5066 BUDGET 10100 4030301 112870 722780
056)6 BUDGET 10100 4030401 112597 722780
I1SC IT BUDGET 10100 4030401 112617 722787
USCTY BUDGET 10100 4030401 113381 722780
uscrt BUDGET 10100 4030401 121290 722780
USGTY BUDGE) 10100 4030501 110110 7227110
USCTY BUDGE) 10100 4030501 116230 722780
USCTY BUDGET 10100 4030505 110110 722780
11.56.4`6 BUDGET 10100 4030510 116230 722780
USCTY BUDGET 10100 41130601 110000 772780
USCTY BUDGET 10100 4030601 I Icoio 722780
USG TY BUDGET 10100 4030601 110020 722780
USGTY Bil0GET 10100 4030601 110030 722780
USCTY BUDGET 10100 4030601 116070 722780
USCTY BUDGE 10100 4030601 116130 722730
USCTY BUDGE V 10100 4030601 116180 722780
3133676 000GE, 10100 4030601 116180 722780
USCTY BUDGET 10100 4030601 116180 772760
USCTY BUDGET 10100 4030801 116180 722780
L /SCTY BUDGET 10100 4030601 115180 722780
USC1Y BUDGET 10100 4030601 116130 722760
IJSCIY BUDGET 10100 4030601 116180 722780
USCTY BUDGET 10100 4030601 116180 722780
USG TY BUDGET 10100 4030601 116180 722780
057,49 BUDGET 10100 4030601 116160 722780
LIS0.TY 6U00E) 10100 4030601 116160 722790
1113775 BUDGET 10100 4032601 116180 722780
USCTY BUDGET 10100 4030801 116181 722780
115011 BUDGET 10100 4030601 116190 7227E10
LISCTY BUDGET 10100 4030631 116200 722750
USCIY BUDGET 10100 4030601 116215 722780
USCTY BUDGET 10100 40305(01 110040 722780
USCTY BUDGET 10100 4030901 110050 722760
USCTY BUDGET 10100 40349901 110060 722780
61501 BUDGET 10100 4030901 110090 722780
USCTY 6UDGE! 10100 4030901 110100 722790
1164C-1Y BUDGET 10100 4030901 116240 722780
USCTY BUDGE) 10100 4030901 116250 722780
7227E:1-16"5PIT A I I200ION4FRINGE BENEFIT 71000161 I2AT11,6ERESCRIPTION REV AND EXd ACCOUN1 S T DRAFT 6(0)2
„7-71_11t1, 1111u,943 A E1044Re1 ,12211006v1 gAralts_Typi la ..jR14nrid Desistlptior ,
1' 6111/40 (14,074) HosplialIzalion
C AMEND (7,003) Hospitalization
C_AMEND (60.7051 Hospitalizinion
C ND (241)3) Hospitalization
C_ AMEND (1925) Hospitalization
G_AMEND (30.232) Hospitalization
CAMEND (137) HospitalRation
C_AMEND (21872) tlospitalization
D_AMEND (23 707) Hospitalization
CAMEND (40.441) Hospitalization
C_A116410 72 762) Hospitalization
C_AME.NO (7284) 006pitali7.ation
C...AMEND (4629)7) Hospitalization
C_AMEND (16.354) Hospitalization
C_AMEND (99,493) HospilaltratIon
C21417110 (1.926) Hospitalization
C All (3.463) H0s141aliz16o5
C. AMEND (85.898) Hospitalization
41_07461.43 (70231) Hospitalization
CAMENO (20,853) Hospitalization
SAWN() (5 159) Hospitalizalion
666)E1113 (7626/ Flospi)alizalion
C_AMEND (12.4311 Hospitalization
C...AMEND (109.112)
C_AMEND (7.049) Hospitalization
C._,AMEND (9.0)6) Hospli4(4240n
17 ._AMEND (17.802) H5(50444l6056o5
C_AMF.1414 (24.983) Hospilalization
01Ak1END (1420703) HospitaiRation
4(020 C. AMEND (394) Hospitalization
40160 C_ AMEND (12,681) Hospitalization
400 )0 CAME)40 (16.989) Hospitalization
40120 C,...AMEND (21,791) ilospitalization
311036 C_AMEND (20.543) Hospilalization
40130 10AMSND (24.776) Hospitalization
40090 CA101END (21601) Hospitalization
40140 C_AMEND (29.684) Hospitalization
40060 C_.41.016 ND (30.923) Hospititlization
40130 C._AMEND (5).526) Hospitalization
40040 CC AMEND (55.571) Hospltalization
40080 CAM/ND (57.192) Horpltalizanon
40440 C_AMEND (123 632) Hospitallzalion
C_AMEND (6.135) Hospitalization
C AMEND (2.790) Hosailakration
C_AMEND (2.826) Hospilalization
CAMEND (6,464) Hospitalization
67.4111END (5,017) Hospilalizatlon
G_AMEND (23,507) HosPit44114.800
C_AMENU (21919) Hospitalization
C_AMEND (19 955) Hospitalization
G_AMEND (14,491) Hospitalizat(on
C _AMEND (18.064) Hospitalization
C _AMEND (11,7)4) N0501111220°0
(14 073 90) 1001300. 0.23%
(7.003 71) 52/1)10 0.1133
(81704 .) 006588.00 1.32%
(24.3)1041 187,167 GO 0.41%
0),925 23) 14.51100 0.03%
(10201 77) 227.97600 050%
(636477) 6431000 0.01%
(23.572 13) 1/01(761(0 0.3904
(23.706.56) 170 769 00 0.396,
(40.447 51) 305 011 00 0 F.,
(2 162 006 2090) Oil BOSS
(7 29) 27) 54 90000 0)76,
41280660) 1491.340 00 7 59%
(16 364 47) 123 403 00 0.2751
(99,493 17) 75(1,2139 00 1 63%
(1.325 23) 14.5)8 00 0.03%
(1163 24) 2)11661 006%
(856)7 60) 647,746 00 1.41%
(70.200 781 529.901.00 1.15%
(20.693 32) 157 253 00 0 340
(5.15916) 38 904 00 0006,
(2.62647) 10606.00 704%
(12 131 13) 0374000 0275,
1103 111 51) 822.803 00 1/9%
(7.949.31) 5934500 1413%
(9 015 89) 67.988 00 0, 1 5%
(17.801 57) 134.240 00 020%
(2468960) 186391.00 0.41%
(142,702 66) 1 076.108 00 234%
(3939)) 2)0)00 0.011
01681.36) 95 628 00 021%
00,94546) 120 116 70 028%
(21.180.734 164.247 00 0 36,
(20 543 09) 770.159 00 644%
(26.6)621) 201917 00 04,116
(28.801 33) 715 680 00 0416
(20E83 58) 223.641 OD 0.43%
(39,923 30) 301.05300 0.85%
(01.525 62) 388.55000 0.84%
(55.578.44) 419 112 00 0.91%
(57.192 17) 43(74)00 094%
(121682,17) 4137 239 00 2.03%
(6.134.50) 443 262 00 010%
/200225/ 2/04100 0051
(2,623 47) 19 806 00 0.04%
(6,463.57) 48,852.00 0.11%
/561107/ 37133.00 00/1,
(23,507 38) 177,267 00 0.30.%
(20110 70) 157.746 00 0 34%
(19154 89) 152.471,30 0 32%
(14.490 81) 1692/4 00 0 24%
(18.763,87) 10 211 00 030%
(11 764 366 68 714 00 019%
C-113oviandrils 564 SortingsAsmilhla1ocal 50/95(4,1'.. p. Internet Files)Coniard 0.805(40 1A2716N1ACCT 722700 Hospitalization Budget Ari,ndinant
SCHEDULE C
SECOND QUARTER AMENDM1NT 10 F1E-DUCE DEPARTNE 5 1 ACI.0 1.FIT 722760 HOSPITALIZATION/FRINGE BE.FIEFIT 1700911-71117ATI0 '919(' 1061SCRIPTION EY AND EXP ACCOUNTS I I DRAF1 91(12 . .... -
Ron 4/4
USC)Y BUDGET 10100 4030901 116260 722780 G_AMEND 03.748) 14oap6alRation
USCTY BUDGET 10100 4030901 116270 722780 C AMEND (2 6..6) Elospitaltc.ation
USCTY BUDGET 10100 5010101 180010 722790 C_AMEND (10 862) ti,nitalization
Ust3-113 BUDGE! 10100 5010101 180020 7227110 C_AMENC1 (31758) I lospitalizalion
USCTY BUDGET 10100 5010301 165010 722790 CA//END (1,674) Hospitalization
USCTY BUDGET 10100 5010304 165020 722780 C_AMEND (8.057) Hospitolt.atton
USCTY BUDGET 10100 5010303 165040 722780 C_AMITND (1A74) Hoop-ttalizalion
USGTY BUDGET 10100 6010101 1496110 122790 CAMEND (5,519) Hclopitalizallon
USG TY BUDGET 10100 5010101 155010 122700 C.40.517413 (44 960 HoN.961R01100
((SUIT BUDGET 12100 6010101 174250 722780 001IEN0 (9,4134) Pospitalt4ntiot,
USCTY BUDGET 10100 6010101 074450 722780 QAME ND (7,322) I lospilatRation
115010 BUDGET 10100 7010101 166040 722780 C_AMEND (10592) 000p6a4202ion
USCTY BUDGET 10100 7010101 180050 722780 C_AMEIJD (13 005) Hospitalization
05015 BUDGET 10100 7010101 186070 722780 C_AMENO (11A25) HnspitatRation
USC TY BUDGET 10100 7010101 106800 722763 0,__AMEND (10622) Hospitak anon
USC TY BUDGET 10100 7910101 186090 722780 C_AMEND (2.762) Hospitalization
USCTY BUDGET 10100 7010101 185100 122790 C_AMEND (5,065) I insprIalizolion
LISCIY BUDGET 10100 7010101 176130 722780 C._AMEND (7,598) FlospitallYallOn
USCTY BUDGET 20293 1050501 112010 722780 c_AMEND (24069) Hospitalization
)JSCTY BUDGET 20203 1060501 112020 722760 C04%1E-ND (9.358) Hospilalizollon
USCTY BUDGET 20293 1060501 112030 722760 . C_AMEND (11,552) Nospitollzalion
IFSGIY BUDGET 20293 1060001 112050 722780 QAMEND (53,993) HOSE' 21041(07 .
050)7 BUDGET 20293 1060501 112060 722780 C_AMENI.1 (1,928) Hospitalization
USCTY BUDGET 20293 1060501 112070 722780 c, AMEND (22.270) linsPita1Ro600
USCTY BUDGET 20293 1060501 112100 722780 C.,AMEND (13 128) liospitalizabon
USCTY BUDGET 20293 1060501 112140 722700 0_0t.1END (032) HospitalIyaorat
u07001 BUDGET 20293 1060501 1•12150 722780 C_AMEND (03001 )Iospitalizatton
USC1 Y BUDGET 20293 1060501 112170 722780 C_AEIEND (21.103) HoSPIta8Fafinn
1/SCOT BUDGET 20293 1060501 112190 722780 C__ AMEND (4,791) Hospilalization
00005 F311E/GE! 20293 1060501 112450 722780 QAMEND (23499) 00501181140)I110
USCIT BUDGET 20293 1060501 112470 722789 C_AMEND (12,285) Hospitalization
USC.TY BUDGET 20293 1090501 112480 122780 C_AMEND (16029) Hospitalizatican
C AMEND _
r113
UNITY BUDGET 20293 1050501 112500 722700
USC1Y BUDGET 20293 1060501 112520 722780 C_AMEND
(12,175) Heanitali4anon
(6931) 140spitalization
03 USCTY BUDGET 20293 1060501 112540 722780 C _AMEND (13 2)7) Hospitalization
USC TY BUDGET 20293 1060501 131000 722780 C_AMEND (6730) 11ctspitalizatton
USCAY BUDGET 20293 1060501 111010 722780 TAD/END (35066) Hospitalizalton
USCTY BUDGET 20293 3010402 113310 722780 C AMEND (13175) Hoapitalizalion
119010 BUDGET 20293 3010402 121200 722790 C_AMEND 1,9211 I Inspilalizalluit
USGTY BUDGET 20293 3010102 135120 722760 C_AMEND (84) Hospdalization
USCI 1' BLIDGET 10100 9010101 196030 765872 C_WEND 4003641 Planned Uao of Bolan66
USCTY BUDGE I- 67700 1010501 182000 722790 QAMEND (2,533) Hospitalization
USCTY 0600E1 67700 1010501 182000 796500 c_AMEND 2.533 Rodgeted Equity A2jtmlrt,1111.:
USG TY BUDGET 57700 1010502 162000 2227110 C_AMEND (10 844) Hospitolization
USCTY BUDGET 67700 1010502 182001 706500 , C_AMEND 10844 Budgeted Equlty Adtustrnent,
USCTY BUDGET 67800 1010502 183000 722780 C_AMEND (2504) Hospitalization
USCIY BUDGET 671300 1010502 103000 796500 C AMEND 2,500 Budgeted Eqully Adjustments
USCTY BUDGET 50800 1020601 112040 422740 1' AMEN)) 72.400) Fringe Benefits
t/SCTY BUDGET 57010 1020601 1E12070 722780 C_AMEND (907) HospilFtilation
USCTY 13111GE1 57010 1020601 172070 796500 • c,_AMEND 907 tiodgelon Enttity Adjust:wan,
USCTY BUDGE) 67800 1020615 162070 722770 C_AMEND (87) Hospitalization
USC I Y BUDGET 67800 1020615 1820110 797500 C_AMEND 67 00012014 Equity Adit(61cents
IISCTY BUDGET 57110 1020640 182080 722700 C' AMEND (1.1370) HospRaiization
USCTY BUDGET 57010 1020640 182080 796500 C_AMEND 1.870 Btolgoted Equity Anytstnns.nta
USC.TY BUDGET sotino 1020558 182080 222740 C_AMEND (1.400) Pray, Elanetils
USCTY BUDGET 50800 1020658 182050 722141 C_AMEND (2.500) Priogn (Innen.
USCTY BUDGET 50500 1030701 154000 722060 C_AMEND (10 844) Hospitalization
1JSCTY BUDGET 56500 1030/01 154001 796500 C .AMEND 10,844 Budgeted Equity Adlostments
USC IX BUDGET 56502 1230704 154010 722792 C_AMEND (233731 Hospitalization
1.1SC1Y BUDGET 56500 1030701 154010 796500 C AMEND 23.373 Budgeted EA ,ity A11tt9Imorits
USGTY BUDGET66100 1030811 164010 722780 C_AMEND (26 839) Hospilalization
1150173 BUDGE I 60100 1030811 184010 796500 C_AME ND 26.8)9 Budgeted E171110 146 (19655'F
• rr 2012 Amended B
(13340 21) 101674 00 0 23%
,202647 13_006.00 0.04%
(14.761 60) 1/207000 034%
(3235799) 247.02500 0.54%
(1 173 Ai) 12.610 00 003%
(9056.019 60.751.00 0.13%
(1 673 54) /207000 0,0381
(5.519.361 41621.00 0.090
(14 666 60) 339.335.00 0.740,
/9408 13) 71,510 DO 0.16%
(7.)2196) 5521200 0 121/,
(10,592.36) 7901100 0.171
(1)0050/0) 0007000 B21'/,
111 424 75) 65 153 00 7/40,
11)7217)) 81.606 02 0.17/9
(204200) 251280 0054
(5E66.17) 196.00 0.08%
(7.597 76) 57.294 00 0.12%
(24 065 96) 171 30200 4) 598
(9350.02) 70 568 00 01500
(11,552.32) 67 /1500 3.191
(51997.86) 411)4)00 0801,
(1,928 41) /4.S4200 003%
(22,269 99) 167936 00 037%
(13.12735) 99R96 OD 0 22%
(7)233) 727700 01 13,
(5 397 50) 45 243 00 01014
(21.103 01) 159.136.00 0 2.5%
(4.791.46) 36.132.00 008%
(2)49952) 117.201 00 0.39%
(12,284_99) 0264000 0.201
(16 028.57) 120 07707 0240
(12,174,66) 010,800 81>05
(5,9)2.09) 44,3'43 00 0(0%
(13.236.47) 9401500 0.22%
77107/) 5)8/600 0.11%
(35.065 93) 264,474 CD 0,57%
(13,174 80) 99,350 00 022%
1.02941 (14.542 00) 0(7)5
(8).54) 630.00 0.110%
4 661.543.10
(2.532.59) 190)6.00 0.040,
2.512 59
(10344 05) 81.774 77 019%
10,844 05
(2,525.93) 19707.00 0.04%
2.505.93
(2400.00) 35 153.028 00
(906.92) 670.1)0 0.01%
906.92
(80 7)) 654.00 0 0011
05.73
(1 870 46) 1410500 0.03%
1170.46
(140000) 1)0790000
250000) 08201/970
(10.844 05) 0/77400 0/0%
1014405
(2337291) 1/6253 nn 030%
23.372 01
(25.1130 54) 202387 00 0.44)1
2083954
C:10nruments and Sett1n9st5m111401L0n4t Settings1Ter17or41y Inlernot File51Cnntent Dittlook111A770PFOAC:CT 722764 Hospitalizatinn Btingel Anavidrnent
SCHEDULE C
BEGONE) QUARTER AMENDMENT TO REDUCE DEPARTMENT ACCOUNT 722760 HD3B1TALIZATION/FRI4OGE BENEFIT HOSPITALIZATION /PRESCRIPTION REV ANA E 5,05., lONTS 1 I DRAFT 6/111
.a.C .Und A =AIM= AM1Mly rno ReS.TWAL:Lenaino''- Re31 110 Descripfid Art101 2012 Arnened'
USCTY BUDGET 63100 1040701 140101 722780 C_AMEND (12.793) Hospitalization (12 791 32, 96 471 00 0.21%
UST/TV BUDGET 63100 1040702 14001D 665682 C_AMEND 274 956 Planned Use of Balootfe 279,056,413
(1ST/TV BUDGET 63100 1040718 140299 722780 C AMEND 464 531) Hospitatization (64500.65) 03) 435 TO 1.39%
USCTY BUDGE] 133100 1040719 140399 722180 C_ AMEND (94,107) Hospitalizalion (94 107 35) 709,655.00 I. 09%
USCIf BUDGET 63100 1040725 140599 722780 C. AMEND (24984) Hofipit,lizalion (24,974 304 164.905.00 ' 0415
USC I Y BUDGET 63100 1040730 132010 722780 CAMEND (262) Hospitalization ;261 90) 4.97504 0005
01ST/TA BUDGET 63100 1040740 148499 722790 '4 AMEND (13,865) I inspitalization (13.864 77) 104,553 00 0.23%
DOTTY BUDGET 63100 1040770 145100 722780 C_AMEND (37,579) Hnspilalmation (37.578 76) 283 178 00 0.670
DOTTY BUDGET 63100 1040601 140030 722780 CAMENB (9,636) Hnspitalization /980565) 51,547 00 0 11%
USC I Y BUDGET 67900 1050515 153160 722700 C (7,470) Hospitalization f7.470 0)) 54.131 00 012% •
llSCTY BUDGET 67800 1050515 183160 706500 C_AMEND 7470 Budgeled Equity Adjuslments 7,470 05
LISCTY BUDGET 67800 105052D 163160 722780 C_AMEND (6.435) Hospita(lzation (9.434 53) 63.504 00 014%
USCTY BUDGET 678DCI 1050520 163160 796500 C_AMEND 6,435 Budgeted Equity Adjustments . 6.934 53
01ST/TV BUDGE1 67800 1050525 183150 722780 C0100 ND (10 734) Hospitalization (10.213 460 60.5140/ 0.16%
USCTY BUDGE I 67800 1050525 183150 796500 CAMEND 10.734 Budgeted 6911114 Adjustments 10.73198
USCTY BUDGE). 67600 10)0525 183192 722790 C_AMEND (43) Hospitalization (43.36) 327)0 COD
1.1SCTY BUDGET 671100 1050525 183192 700500 C. AMEND 93 Budgeted Equity Adjustments 4136
i/SC TY BUDGET 63600 1080101 121000 722780 1. AMEND (1.920) Hospitalization (1926 41) 14,54200 7080,
USE,' BUDGET 63600 1080101 152000 722780 C_AMEND (31,300) Hospitalizalion (31,3na 07) 236.031 00 0.51%
USCTY BUDGET 63600 1080101 1520)0 722760 C_ AMEND (1,928) Hosnitalitatten (1,92841) 14 542.00 0 n344.
01ST/TO BUDGET 63600 1080101 152000 665052 C . AMEND 219,70) Planned Use of Balance 21971148)
USCTY BUDGET 67500 1080101 152070 722760 C _AMEND (3.654) Hospitalization (3,053 65) 25.0611 no 0 06%
ASCII BUDGET 69600 1080201 121010 722780 C..413/1440 (10,794) I iospItelization (19.794 15) 149.286 00 03:/S
USGIY BUDGET 63600 1050201 132200 722780 C_AMEND (41.628) Hospitalization (41 627 87) 311912 00 000%
USCTY BUDGET 63500 1060201 152000 722780 C_AMIND (6349) Hospitalization (6:6947) 46,182 on 0.10%
LISCTY BUDGE! 63500 1780701 152020 722781) 6:AMEND (8.565) HosVealization (8 )64 62) 64.585.00 314%
0S0151 BUDGE! 61600 10910201 152030 722780 G AMEND (9.406) Hospitalization 404)5 151 1054)00 0.15%
USCIY BLIDGE-1 63600 1080201 152190 722780 C_AMEND (II 097) Hospitalization (11 687.18) 68 1)2.00 0_19%
USCTY BUDGET 53100 1080301 415100 722780 1/AMINO) (7,5)8) Hospitafization 17,597 76) 57.294 00 0.12%
USCTY BUDGET 53500 1080301 116020 722760 A_ AMEND (416144) Huspilafization (41,644 03) 315.542 00 069%
U)CTY 9UDGE1 53500 1080301 116020 6608E2 C 41,844 Planned Use of Balance 41.844 03
USCTY BUDGET 53550 1060301 116155 722780 C_ AMEND (2_590) Hosplializalion (255000) 19,534 00 004%
ro USCTY BlIDGE I 53)00 1080301 115020 665082 0 AMEND 2,590 Planned Use of Balance
USCTY DODGE! 53500 1080310 118170 722700
_
C. AMEND E17,207) Hospitalization
(1 2,590 40
7,207 47) 129.760 00 079% .
Ca USCTY BUDGET 53600 1760310 115100 665682 G_AMEND 17 207 Planned Use of Baience 17,207 47
USCTY BUDGET 53100 1060329 115120 665802 C_.1650 7.598 Planned Use of Balance 7.597.76
USCTY BUDGET 63600 1080601 152000 722780 1/ 41,159(0 11 026) Hospitalization (1926411 14.542.00 003%
USCTY BUDGET 63600 10805131 152915 722780 C_AMEND (21,096) Hospitalization (21.746.101 45540 00
USCTY BUDGET 63600 1080001 152050 722740 C_AMEND (89.062) Hospitalization (64,051 904 463.095-00 1.05%
USCTY BUDGET 67604 1080601 152090 722760 C_AMEND (6990) Hospitalization (494040) 5271400 0.11%
USC-TY BuDGFT 67500 1080601 152010 665882 C_AMEND 10.844 Planned Use of Balance 14.44405
USCITY BUDGET 21184 1090202 171100 722760 C_AMEND (9.198) Hospitalizafion (0,197.96) 6016100 016%
USCTY BUDGET 21184 1090202 171100 796500 C_AMEND 9.198 Budgeted Egilily Adjustments 5.10196
USG 111 BUDGET 21175 1090207 174230 722780 C AMEND (1350) Hospitalization (1.349 Al) 10179 00 002%
USGTY BUDGET 21175 1090207 174230 796500 1551190 1.350 Budgeted E3114 A.4..,,,,.1. 1,349.84
60016 BUDGET 50800 5060101 160000 722740 C_AMEND (45,100) Fringe BeneMs 06.100 001 10 179 00
USC TY BUDGET 50800 5060201 160900 565682 C_AMEND 118,600 Planned Use of Balance 116.500 00
USC:TY BUDGET sneoa 5060326 160010 . 722740 CAMEND 13.611(o) Fringe Benefits (3.5041 00)
USCTY BUDGET 50500 5060327 100010 722040 CAME ND (5.1001 Fringe Benefits (51000(1
USCTY BUDGET 50800 5060328 190010 722740 C_AMF.N0 (2000) Fringe Benefits (2500044)
lISCIY BUDGET 50800 5060330 160010 722740 C. AMEND (3500) Fringe Benefrls (3 500 00)
01ST/TB BUDGET 50800 5060356 .160010 722740 G_AMEND (5,400) Fdnge Benefits (5 400 00)
USCT Y BUDGET 50800 5000650 160050 722740 C_AMEND (1800) Fringe Benefits (1.070 00)
USCTY BUDGET .501400 5060715 1603370 722740 1/ AMEND (5,)00) ;doge Benefits (5.500 00)
USCTY BUDGET 50800 50611717 160070 722740 0_ AMEND (500) Fringe Benefits (500 004
BOOTY BUDGET 50800 5060720 150070 722740 C_AMEND (3.500) Fringe Benefits (3 500 00)
USG11 BUDGET 50800 5050724 150070 722740 C_AMEND (6w) Fringe Benefits )57000)
USCTY BUDGET 50900 5060725 160070 722740 C. AMEND (4,500) Fringe Benefits (9,500 00)
00069 BUDGET 50800 5060729 100070 722740 C...,,,IEND (400) Forige Benefit. (400 03)
USCTY BUDGET 50600 5050732 100040 722740 0AmEND 11000) Fringe Benetii, (1 000 00)
uSETY BUDGET 50800 5060735 160210 722740 C_AMEND (50)) Efinge Benefits (50) on)
USCTY BUDGET 50800 5060715 -160070 722740 C_.AMEND (4,705) Fringe Benefits (1.701 00)
416c., BUDGET 50808 5060755 160070 722740 1/ 01,1503 (600) FrInge Benefits (600 DO)
USCTY BUDGET 50800 .50607E0 100070 722790 C_AMEND (100) Fringe BenefifS (100 )04
USC I Y BUDGET 50800 5060765 :16000 722740 C AMEND (100) Fringe BenefitS (100.00)
USCTY BUDGE I 90800 5060805 160210 722740 C.,AMEND (7,8)10) Fringe BenofitS (7,89)1(0)
USCTY BUDGET 50800 5060831 1E0210 722740 C_AM11ND (3.000) Fringe Benefits 0)00 00)
uSCTY BUDGET 50800 5060837 160210 722740 C_AMEND (2.000) Fringe Benefits (2.000 MD
',Content Oulloo1011A27VP3PACCT 722780 Hospitalization Budget Arnendnnent cts G1Dorornents and Settingsfsroithla1Local SnitinftdTernporary II'! '10/
SECOND QUARTER AMENDMENT Tr) REDUCE DEPARTMENT ACCOUNT 722760 HOSPITAL 1ZA
jtJnIt En3111130:11Npt
FRINGE 9E0E011 110SPITA1F;AT6.)!:i7F1 ,,CRIP1ION TAT AND EXP ACr, 011N S F u lii.I n Icr
1 DRAFT 0/1/12
II Amount ROUnd to s
(156755.90)
(38581 02)
(36.733 10)
(7745010)
(24952017)
I 112,082 00
29053000
277 001 00
13159000
2 37%
0.43%
0,30%
329%
SCHEDULE C
USCTY BUDGET 50800 5060840 160210 72274
USCTY BUDGET 50800 5060870 160010 722710
USCTY BUDGET 50600 5066510 160430 722740
USCTY BUDGET 57010 6010101 149030 722780
usCTY BUDGET 57010 0010101 149030 796500
USCTY BUDGET 58410 6010101 140030 722780
USCTY BUDGET 58410 6010101 1400317 796300
USCTY BUDGET 58530 6010101 119330 022700
CACTI BUDGET 58530 1010101 149030 796600
USCTY BUDGET 58100 6010101 145030 722780
USCTY BUDGET 54600 6010101 149030 796500
USCTY BUDGET 58700 6010101 149030 722780
USCTY BUDGET 58700 6010101 140030 795500
USCTY BUDGET 63900 6010101 110760 722780
USCTY BUDGET 13900 6010101 149750 665852
USCTY 9040GE! 51600 7010101 186050 722750
USCTY BUDGET 51600 7010101 1880r4 6554E7
USCTY BUDGET 51800 7010101 106060 722780
USCTY BUDGET 51000 7010110 106060 722780
USCTY BUDGET 51000 7010110 186060 6651382
QAMEND (200) Enrige Benefits
DAM) ND (300) Fringe 060e139
QAMEND (11.600) Fringe Bonet.
('_AMEND (272 794) Hospit017a10
C_AMEND 272.764 8udgote0 Equity Adiustments
CEMENT (18,718) Hr54111411za6o7
C_AMEND 15.718 Budgeled Equity Adjostmorrls
CAM E ND (22,427) I Insprialization
C_AMEND 22.427 Budgeled Equity Aojurnenls
C.AMEND (15.707) Hospitalization
C_Ak1END 15.707 Budgeted EgErity Adjustments
C AMEND (690) HosPrr40001139
CEMENT 698 Budgeted Equity Adjustment,
C....AMEND (18,718) Hospitalization
C _AMEND 18.118 Planned 060 (1 Bolan
AMEND (2.380) HnspitalizatIon
C_ AMEND 2.380 Planned Use of Bat4nre
C_AMEND (837) Hospitalization
C 95(E7,0 (9.092) I lospitaliration
C. AMEND 9929 Planned Use of Balance
(200 00)
(no ac)
(1 sac am
0272,783 55) 2017. D36 00 / 47%
272,783.55
(1871750) 141 150 (0 051%
16717_90
22425 61) 159,117 00 907%
22 420 61
115 727 26) 118,447 00 0,6
1700720
(05900) 520400 7115,
69000
(16717 90) 141,150 00 0.413
1071100
(237969) 17 0.0500 0,04%
7379.69
(331 17) 6310.00 0(11°C
(9 092 2)) 6450400 TON
392904
I USG,' BUDGET 27100 3010404 176030 727780
USCTY BUDGET 27100 3010404 176050 122780
: LJSCTY BUDGET 27100 3010104 135140 722780
USCTY BUDGET 27100 4030925 110(,70 7727130
C AMEND
C_AMEND
C_AMEND
G_AmEND
FCC WITH GRANT DO NOT POST
0156.756) H951,11a.,7tI3"
(38581) Hospitalization
(16.733) Hospitalization
(237.070) 46,0168760ion
p45.520)
i USC.TY BUDGET 27345 4030601 110010 722780 G90000000142 2012 GRANT A GI E3 C_AMEND (1) 570) tlospitaltza(tort 01570.19) 07,25200 0)9%
( USCTY BUDGET 27315 4010201 120070 122780 G00000000143 2012 GRANT A 00E3 C...A14END (39034) 0105pitali,4ti., (3a114 15) 294,353,00 0640)
(00011 BUDGET 28249 1080261 133950 722780 090000000203 2012 GRANT A GOB CEMENT (2015) (.5041010z840311 (2,015.14) 16,106 00 0.037,
($3
1 USCTY BUDGET 28249 106026) 133900 722780 GR00013000203 2012 GRANT A GOB C_AMEND (4,461) 80500/10H901100 (4461 00) 33 110 00 0015'
A IC 3 1 USCTY BUDGET 28249 1061)261 134790 722780 GR0000000203
1 USCTY BUDGET 21249 1000261 134705 722780 G00000005203
2012 GRANT
2012 GRANT
GOB
GLB
C_AMEND
G_ AMEND
(1,140) Hospitalization
(3657) .345talirratlo0
(1.140 31')
(3 85603)
059400
2908400
052%
0 06% A
( USCTY BUDGET 28249 1060261 134796 722780 000000000203 2012 GRANT A COON C_ AMEND 72005) Hospitalization (2004 93) 15,119.00 773%
I USCTY BUDGET 20240 1060261 134800 722780 G110000000205 2017 GRANT A GLEI C_ AMEND (14.102) Hospitaraatin o (14.101 71) 100.340 00 0257,
( ((SCOT BUDGET 26565 1060261 134805 722780. G80000000206 2012 GRANT A GLB C_AMEND (5,066) 905(0121004(30 (506563) 42.72000 000%
I USGTY BUDGET 27130 3010301 171200 722700 000000000233 2012 GRAS) A GLIS C. MEND (616) 41,,,pi0100091I90 (616 1)) 1546 00 007'
1 USGTY 0108)0E0 27140 3010102 121200 722709 G00000000236 2012 GRANT A GLB 0. EMEND (2.702) Hospitalization (2.261.03) 17054 0 001%
I USCTY BUDGET 27160 3070301 171050 722700 000000000243 2012 GRANT A BIB C_AMEND 359 Hospitali,retion 55852 (4 211 00) -0 01%
I USCIY BUDGET 27100 3020305 121050 722750 G100900000743 2012 GRANT A GLB C_AMEND (559) 007o113li761109 (558.02) 4 214 00 077%
1050007 BUDGET 29001 1020672 170000 772780 G00000000294 2011 GRAN1 A GLB C_AMEND (2,533) Viospilallzation (2532.50) 19 090 00 0.04%
( USCTY BUDGET 29801 100020) 1710(0 722780 G090000000294 2012 GRANT A • GOB G_AMEND (837) linspitalizatIon 0535771 630070 0.010)
1 LISCT Y BUDGET 29601 1090701 17U/10 722780 0001400000294 2012 GRANT A GOB C_AMEND (I4,069) H00pita1128(891 (14,008 86) 106092 GO 0.236
I USG I Y BUDGET 25720 2010401 172110 722780 GR0000003341 2012 GRANT A GOB C .AMEND ((49) 11650r:07a:010 049 05) 1.124 00 0 00%
' A I USCTY BUDGET 29701 1020622. 137003 722780 G40060000381 27003 2011 COMH1 00,E1 A C_AMEND ((59) Hospitalization (159.13) 1.200 00 0 00),
1 USCTY BUDGET 29701 1090611 132210 722780 090000000351 27004 2011 COMH1 A 13LB A C_AMEND (1.096) Hospitalization (1.089 09) 8.190 00 0 02%
1 USGTY BUDGET 29701 1090611 132200 727780 000000000381 27003 2011 GDMHI A 0L00,8 A C_ AMEND (18.270) Hospitalization (10,27919) 122.59250 0 220
1 USC.TY BUDGET 29701 1090611 177130 722780 000000000351 27002 2011. COMH1 A GOB A QAMEND (4,113) Hospilalizalon (4,113.30) 3),010.00 000'
( USCTY BUDGET 29701 (090660 132210 722780 G00000000391 27004 201) CC MH1 A GOB A C_AMENDAMES))(2,533) Hospitatitallon (2_53290) 19 101 00 0(04'
1 OSCTY BUDGE( 29340 1000001 115125 722780 GR0000000497 2012 GRANT A GOB C .AMEND 0 Hospilakatinn - 0.01109
- 1 USCTY BUDGET 29340 1060601 115127 722780 /000700705497RO000000497 2012 GRA A NT 0,09 QAMEND 0 Ho6pitaltzation • 0.004
1 UBCTY BUDGE I 20340 1360601 115125 722780 000000000517 20(2 GRAN)A 0/LB C_AMEND (1 928) Hospitall,ation (1 0284') 14542.00 003,,
1 USCTY BUDGET 29340 106000 115127 722780 G00000000561 2012 GRANT A GOB G MEND (4 458) HospitAlization (4,457.82) 33116110 0 07;
1 USC TY BUDGET 2(125 3010403 135080 722780 GR0000000578 2012 GRAN) 01.13. C_AMEND (530 Hospitati,ation (536.77) 08190 (1.01% A ___
GRANTS DO NOT POST (131.700) 1,135.699.81}
C4Docurnents and SolOngs 5990(084/) odd Soltir 80000 Intemet Ht6,3C.ontent Out170k111A270050000C1 722780 Hosplralation Budget Arn3ndment xis
PLANNED USE OF FUND BALANCE
TOTAL GF/GP FUNDS
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court
52nd District Court
Probate Court
TOTAL ADMIN. OF JUSTICE
LAW ENFORCEMENT
Prosecuting Attorney
Sheriff
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
$ 17.508,009.00 5 24,914,626.76
$ 416,237,573.00 $ 424,140,665.76
$ 72,386,410.93 $ 2,845,600.00 3.78%
18,403.816.67 1,553,900.00 7.79%
140,042,490.79 2,083,300.00 1.47%
$ 158,446,307.46 $ 3,637,200.00 2.24°A
11,464,527.00
($25,304,543.76)
($13,840,016.76)
$ 11,464,527.00
($25,304,543.76)
($13,840,016.76)
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER FORECAST
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
REVENUES
GENERAL FUND
Taxes
Federal Grants
State Grants
Other Intergovernmental Revenue
Charges for Services
Indirect Cost Recovery
Investment Income
Other Revenues .
FY 2012
ADOPTED
BUDGET
$ 198,329,187.00
581,971.00
20,285,297.00
11,090,534.00
100,473,693.00
8.700,000.00
3,256,500.00
56,012.382.00
51,706,676.00
16,832,789.00
6,119,500.00
74,658,965.00
19,604,241.00
141,102,850.00
$ 160,707.091.00
11,318,945.00
7,647,233.00
3,063,647.00
1,465,669.00
5.065,948.00
$ 28,561,442.00
$ 5,771,364.00
21.096,363.00
2,650.177.00
1,267,122.00
3,971,493.00
65,792.522.00
16,478,849.00
7.287,536.00
$ 124,315,426.00
$ 388.242,92400
$ 27,994.649.00
$ 416,237,573.00
BUDGET
AS
AMENDED
$ 198,329.187.00
861,770.00
20,325,111 00
11,090.534.00
99,758,486.00
8,700,000.00
3,256,500.00
56.904,449.00
$ 399,226,037.00
$ 52,056,623.59
17,023,211.40
6,152.175.94
$ 75,232,010.93
19,957,716.67
142,125,790.79
$ 162,083,507.46
11,372,132.81
7,875.015.01
3,081,483.34
1,466,508.56
5,184,297.00
$ 28,979,436.72
$ 5,778,267.08
21,377,564.13
2,669,841.43
1,267,912.01
4,097.516.11
70,704,257.89
16,707,949.83
7,769,580.25
$ 130,372,888.73
5 396,667,843.84
S 27,472,821.92
$ 424,140.665.76
FY 2012
FORECAST
$ 199,054,228.00
772,570.00
18,805,911.00
10,914,834.00
98,962,839.00
7,900,000.00
2,492,500.00
56,575,149.00
$ 395,478,031.00
$ 420,782,574.76
$ 49,649,623.59
16,682,611.40
6.054,175.94
10,994,032.81
8,238,315.01
2,920,883.34
1,455,108.56
5,244,058.00
$ 5,653.267.08
20,267,564.13
2,453,241.43
1.107,612.01
3,756,416.11
66,317,457.89
15,818,549.83
6,819,680.25
$ 122,193,788.73
$ 381,878,904.84
$ 27,439,142.92
$ 409,318,047.76
AMOUNT
FAVORABLE/
(UNFAVORABLE) PERCENT
725,041.00 0.37%
(89,200.00) -10.35%
(1,519.200.00) -7.47%
(175,700.00) -1.58%
(795,647.00) -0.80%
(800,000.00) -9.20%
(764,000.00) -23.46%
(329,300.00) -0.58%
(3,748,006.00) -0.94%
(3,358,091.00) -0.79%
9 2,407,000.00 4.629/0
340,600.00 2.00%
98,000.00 1.59%
378,100.00 3.32%
(363,300.00) -4.61%
160,600.00 5,21%
11,400.00 0.78%
(59,761.00) -1.15%
125,000.00 2.16%
1.110,000.00 5.19%
216,600.00 8.11%
160,300.00 12.64%
341,100.00 8.32%
4,386,800.00 6.20%
889,400.00 5.32%
949,900.00 12.23%
$ 8,179,100.00 6.27%
S 14,788,939.00 3.73%
$ 33,679.00 0.12%
$ 14,822,618.00 3.49%
SUB-TOTAL GENERAL FUND/GENERAL PURPOSE $ 398,729,564.00
$ 25,304,543.76 389,915.00 1.57%
28,852397.72 127,039.00 0.44%
General Fund/General Purpose
Favorable/(Unfavorable) - Budget Perspective
GAAP Required Adjustment (eliminating use of fund balance "revenue")
GAAP - BASED REPORT (forecasted impact on Fund Balance)
$
31
TAXES (601000-601999)
Property Taxes - July Tax Levy $ 198,066,687.00 $ 198,066,687.00 $ 198,808,728.00 $ 742,041.00
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
Ed Homeland Security - Disaster Control
Health Division
Children's Village
Total Federal Grants
STATE GRANTS (615000-615999)
Sheriff - Patrol
State Match Foster Care
Prosecuting Attorney
98,500 00
- $
82,000 00
129,243.00
49,000 00
21,728.00
300,000.00
581,971.00 $
- $
1,000.00
129,243.00
98,500.00
- $
82,000.00
129,243.00
63,233.00
287,294.00
300,000.00
861,770.00 $
2,160.00 $
1,000.00
129,243.00
98,500.00
- $
82,000.00
80,043.00
23,233.00
287,294.00
300,000.00
772,570.00 $
2,160.00 $
1,000.00
80,043.00
117,000.00)
725,041.00
(49,200.00)
(40,000.00)
(89,200.00)
(49,200.00)
Economic Development
Health Division
Non-Departmental - Child Care Subsidy
5,053,257.00
15,101,797.00
5,032,310.00
15,160,398.00
5,032,310.00
13,690,398.00 (1,470,000.00)
76,000.00 76,000.00 76,000.00
88,000,00 88,000.00 71,000.00
$ 198,329,187.00 $ 198,329,187.00 $ 199,054,228.00 $
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FY 2012 SECOND QUARTER REPORT
Adopted
Budget
Amended
Budget
FY 2012
FORECAST
Amount
Favorable
(unfavorable) Percent Explanation of Significant Variances
Total State Grants
0.37% Drop in taxable valuable ($161,859) offset by
reduction of increment financing offsets $903,900.
0.00% Return of tax dollars plus interest per the order of
the Michigan Tax Tribunal (MIT).
0.00%
-19.32% Reflects reduction in activity.
0.37%
0.00%
0.00%
-38.07% DHS contract billable service hours continues to
decline (50% Federal, 50"/. State); PA will address
budget task shortfall with an amendment
recognizing structural expense budget cuts.
-63.26% Unfav. Disaster Control Fed Subsidy due to delay
from the State in issuing the Emergency
Management Performance Grant (EMPG).
0.00%
0.00%
-10.35%
. 0.00%
0.00%
-38.07% DHS contract billable service hours continues to
decline (50% Federal, 50% State); PA will address
budget task shortfall with an amendment
recognizing structural expense budget cuts.
0.00%
0.00%
-9.70% Built into the Circuit Court Family Division, Human
Services Admin and Children's Village Budgets are
Child Care Fund expenditures. A favorable
variance within these expense areas reduces the
50% reimbursement the county receives.
Unfavorable revenue variance is offset by Child
Care Fund expenditure favorability.
20,285,297.00 $ 20,325,111.00 $ 18,805,911.00 $ (1,519,200.00) -7.47%
OTHER INTER-GOVERNMENTAL REVENUES (620000 - 626999)
*Revenue variance is partially offset by an expenditure variance. 1 of 7 6/12/2012
Non-Departmental
HHS - Homeland Security
Circuit Court
District Court
Sheriff
Non-Departmental - Reimb Judges Salaries
03 03 Circuit Court - Family Division
District Court - Division I (Novi)
District Court - Division II (Clarkston)
District Court - Division III (Rochester Hills)
2,024,500 00
4,616,600 00
1,887,500.00
4,134,000.00
3,021,500.00 $
2,024,500.00
4,616,600.00
1,887,500 00
4,134,000.00
2,094,500.00
4,433,600.00
1,767,700 00
4,005,500.00
CHARGES FOR SERVICES (630000-635999)
Administration of Justice
Circuit Court - Civil/Criminal 3,021,500.00 $ 2,851,500.00 $ (170,000.00)
(119,800 00)
(128,500.00)
70,000.00
(183,000.00)
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FY 2012 SECOND QUARTER REPORT
Adopted Amended FY 2012
Budget Budget FORECAST
8,600,000.00 $ 8,600,000.00 $ 8,477,500.00 $
54,000.00 54,000.00 59,400.00
4,500.00 4,500.00 4,500.00
2,500.00 2,500.00 2,300.00
468,840.00 468,840.00 498,440.00
1,960,694.00 1,960,694.00 1,872,694.00
Amount
Favorable
(unfavorable)
(122,500.00)
5,400.00
(200.00)
29,600.00
(88,000.00)
Percent Explanation of Significant Variances
-1.42% Unfav, due to decrease in Cigarette Tax sales.
10.00% Fay. Local Match due to higher than anticipared
revenue from the installation of sirens.
0.00%
-8.00% Unfav. Drug Case Management due to a degrease
in drug case filings.
6.31% Fav SSI Payments in excess of budget.
-4.49% Unfav due to Circuit Court Judge Salary reirnb
(judgeship vacancy) which is offset by salary
favorability.
Total Other Intergovernmental Revenue 11,090,534.00 $ 11,090,534.00 $ 10,914,834.00 $ (175,700.00) -1.58%
-5.63% Unfav, due to a reduction in the collections of Cool
Costs ($90,000) as well as a reduction in Refund
Fees PD Def Attorney ($80,000).
3.46% Fav. due to an increase in Refund Fees PD Def
Attorney collected.
-3.96% Unfav. Probation Fees ($161,000) due to a
• decrease in the public's ability to pay and Refund
Fees PD Def Attorney ($22,000) due to a decreasi
in the court's ability to collect the fees. *A budget
amendment is recommended for Refund Fees PD
Def Attorney revenues. See offset in expenditut
-6.35% Unfav. Ordinance Fines and Costs ($100,000) sec
Probation Fees ($30,000) due to a decline in
caseload and a decrease in the public's ability to
pay; Unfav. partially offset by Fav. Late Penalty
$15,000 due to the new JIS case management
system automatically assessing the 20% late
penalty fee to the cases as applicable.
-3.11% Unfav. Ordinance Fees and Costs ($75,000) and
Probation Fees ($50,000) due to a decline in
caseload and a decrease in the public's ability to
pay-
* Revenue variance is partially offset by an expenditure variance. 2 of 7 6/12/2012
Adopted
Budget
2,227,000.00
Amended
Budget
2,227,000.00
FY 2012
FORECAST
2,240,100.00 District Court - Division IV (Troy)
Sheriffs Office
c&heriff - Administrative Services
4:§
Sheriff - Corrective Services
Sheriff - Corrective Services Satellites
2,543,266 00 2,543,266.00 2,828,266.00
196,900.00
442,100.00
196,900.00
442,100.00
196,900 00
523,200 00
1,681,368.00 1,681,368.00 424,668.00
Sheriff - Emergency Response and Prepared.
Sheriff - Patrol Services
2,606,382.00
43,252,429.00
2,589,471.00
42,515,866.00
2,589,471.00
42,728,066.00
792,392.00
51,947,137.00 $
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FY 2012 SECOND QUARTER REPORT
Amount
Favorable
(unfavorable) Percent Explanation of Significant Variances
13,100.00 0.59% Fay. State Law Costs $40,000 due to an increase in
State violation caseload. Also Fav. Garnishment_
Fees $15,000 due to an increase in filings and
Miscellaneous $5,000 due to an increase in the cost
of certified mailings; partially offset by Unfav.
Ordinance Fines and Costs ($30,000) and
Probation Fees ($20,000) due to a decline in
caseload and the public's ability to pay.
Probate Court - Estates and Mental Health
Total Administration of Justice
Law Enforcement
Prosecuting Attorney
512,300.00 512,300.00 512,300.00
$ 18,423,400.00 $ 18,423,400.00 $ 17,905,200.00 $ (518,200.00) -2.81%
6,100.00 . 1.41% Fav due to receipt of unbudgeted Extradition'
Recovery Fee revenue of $4,600 and Microfilming
revenue of $1,500.
0.00%
81,100.00 18.34% Fav. Gun Registrations of $68,000; Photographs of
$2,000; Photostats of $20,000; Registration Fees of
$100; and Fingerprints of $16,000 reflecting
increasing requests for these products; partially
offset by lower anticipated receipts of Recovered
Indigent Monies of ($25,000).
285,000.00 11.21% Fav anticipated Diverted Felon receipts of
$400,000; partially offset by unfav. Board and Care
receipts of ($115,000).
(1,256,700.00) -74.74% Unfav. Board and Care, as Sheriffs Office was
unable to obtain contract with the Michigan
Department of Corrections for unused space in the
Frank Greenan facility; a budget amendment is
recommended. Offset by fay exp in Corrective
Svcs.
0.00%
432,300.00 $ 432,300.00 $ 438,400.00 $
0.00%
212,200.00 0.50% Fay. Reimbursement of Salaries of $300,000 due
to additional services requested; Wrecker Service
receipts of $6,000; and receipt of Liquor Control of
$6,200; partially offset by reduced OUIL Third
Offense revenue receipts of ($100,000).
Sheriff - Investigative Forensic Services
Total Law Enforcement
792,392.00 804,092.00 11,700.00 1.48% Favorable receipt Of Confiscated Property of $9,500
and Misc revenues of $2,200.
51,193,663.00 $ 50,533,063.00 $ (660,600.00) -1.29%
* Revenue variance is partially offset by an expenditure variance. 3 of 7 6/12/2012
Adopted
Budget Percent Explanation of Significant Variances
Amount
Favorable
(unfavorable)
FY 2012
FORECAST
Amended
Budget
General Government
Clerk - County Clerk
Clerk - Elections
Clerk - Register of Deeds & Micrographics
1 reasurer
2,730,493.00 $
175,000.00
7,900,200.00
4,922,918.00
2,730,493.00 $
175,450 00
7,900,200.00
4,922,918.00
2,871,093.00 $ 140,600.00
177,850.00
7,900,200 00
5,036,818.00
2,400 00
113,900 00
Board of Commissioners
Library Board
Water Resources Commissioner
600.00
27,000.00
1,368,112.00
600.00
43,700.00
1,350,031.00
16,700.00
(18,081.00) 1,368,112.00
600.00
27,000.00
Total General Government
County Executive
$ 17,124,323.00 $ 17,124,773.00 $ 17,380,292.00 $ 255,519.00 1.49%
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FY 2012 SECOND QUARTER REPORT
5.15% Fav. Certified copies $125,600, Photographs
$12,000 and passport fees $3,000 due to increased
activity.
1.37% Fay. Election Filing Fees $2,400 due to increased
collection efforts. May become more favorable in
future due to reimbursement from the State for
election primary. Also increased efforts to collect
late filing fees.
0.00%
2.31% Fav. primarily due to increased activity involving the
sale of foreclosed property (formerly reported under
the Land Sales Fund), as well as an increase in
Title Search Fees $200,000, Pilot State owned
Land $11,200, Tax Reverted Land Co Portion
$28,700, Recording Fee Forfeiture Certifications
$42,000 offset by projected unfav. expenditure,
Recording Fee Redemption Certification $42,000
offset by projected unfav. expenditure. Favorability
offset by unfav Industrial Facilities Tax ($210,000)
due to decreasing values.
0.00%
61.85% Fay. Reimb. Salaries $23,700 due to state aid.
Unfav Copier Machine Charges ($3,000) due to
online access, Misc ($4,001)) due to loss of
paralegal contracts.
-1.32% Unfav - Soil Erosion Fees ($20,000) decrease in
building activity/permits due to downturn in housing
market. Fav - Donations $1,919 for FY2012 due to
budget task salary reimbursement from Water
Resources Commissioner.
Revenue variance is partially offset by an expenditure variance. 4 of 7 6/12/2012
County Exec - Auditing
M&B - Purchasing Division
M&B - Equalization Division
M&B - Fiscal Services Division
Adopted
Budget
- $
170,000.00
3,193,904 00
415,600.00
Amended FY 2012
Budget FORECAST
- $ 34.00
170,000.00 200,000.00
3,201,164.00 3,275,164.00
415,600.00 511,600.00
Amount
Favorable
(unfavorable)
34.00
30,000.00
74,000.00
96,000.00
(120,800.00) 506,500.00 506,500.00 385,700.00 Central Services - Support Services
Human Resources
HHS - Administration
HHS - Health Division 3,154,638.00 3,178,195.00 2,968,295.00 (209,900.00)
800.00 800.00 800.00
NHS - Children's Village
HHS - Homeland Security
Public Services - Community Corrections
Public Services - MSU Extension
Public Services - Medical Examiner
Public Services - Animal Control
2,887,496.00
300,000.00
40,000.00
189,000.00
917,895.00
2,887,496.00
300,000.00
40,000.00
189,000.00
917,895.00
3,037,496.00
200.00
250,000.00
21,000.00
199,000.00
817,895.00
150,000.00
200.00
(50,000.00)
(19,000.00)
10,000.00
(100,000.00)
Public Services - Circuit Court Probation
Economic Dev. & Comm. Affairs - Admin
Economic Dev. & Comm. Affairs - PEDS 323,000.00 425,100.00 323,000.00 102,100.00
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FY 2012 SECOND QUARTER REPORT
Percent Explanation of Significant Variances
100.00%
17.65% Favorable Vendor Incentive Program,
" 2.31% Favorable -Increased contract billing
23.10% Favorable Late Penalty and Tax Intercept Fees due
to Reimbursements efforts for collections.
-23.85% Unfav. Printing ($34,000) & Standard Mail ($81,000)
due to loss of CVT business, offset by fay. printing
and mail handling-postage expenses. Fav.
Commission Vending revenue $5,000 due to more
than expected.
0.00%
0.00%
-6.60% Unfav. Flu Vaccine Fees 1:200,000) and Flu 3rd
Party ($35,000) due to decrease in demand as well
as Dental Service Fees Outside ($99,900) due to
privatization of Clinic within the Oakland County
Sheriff's Office Jail. Partially offset by Fav.
Inspection Fees $75,000 due to increase in demand
and Immunizations $50,000 due to administration of
new shots.
5.19% Fay. Out County Board and Care due to higher
population.
100.00% Fay. due to revenue received from CPR supplies
and equipment rental.
-16.67% Unfav. due to reduced number of Weekend
Alternative Program (WAM) work crews.
-47.50% Unfav. due to restructuring of the Master Gardener
Program.
5.29% Fay. due to increased number of cremation
requests $33,000, partially offset by decrease in
number of autopsies ($23,000).
-10.89% Unfav. in adoption activity and anticipated contract
rev due to downturn in the economy. Offset
reflected in fav personnel expense.
0.00%
0.00%
31.61% Fav. due to donation for GLRI Grant and transfer of
Community Partnership Fund to General Fund.
Total County Executive
Non-Departmental
12,098,833.00 $ 12,129,650.00 $ 12,092,284.00 $ (37,366.00) -0.31%
*Revenue variance is partially offset by an expenditure variance, 5 of 7 6/12/2012
Total Non-Departmental
Total Charges for Services
INDIRECT COST RECOVERY (640100)
880,000.00 $ 887,000.00 $
$ 100,473,693.00 $ 99,758,486.00 $
8,700,000.00 $ 8,700,000.00 $
Non-Dept - Charges for Services
Adopted Amended
Budget Budget
880,000.00 $ 887,000.00
INVESTMENT INCOME (655000-655999)
District Courts (Div. I - IV)
Sheriff Corrective Services
Sheriff Investigative/Technical Services
Treasurer CAI Clerk/Register of Deeds
Economic Development
Non-Departmental
Total Investment Income
OTHER REVENUES (670000-695500)
Circuit Court
District Court
Probate Court
Prosecuting Attorney
Sheriff Office
Sheriff - Administrative Services
Sheriff - Corrective Services
Sheriff - Corrective Services - Satellites
Sheriff - Emergency Preparation and Training
Sheriff - Patrol Services
Sheriff - Investigative/Forensic Svc
Clerk/Register of Deeds
6,000.00 $
43,000.00
2,500.00
5,000.00
3,200,000.00
3,256,500.00 $
351,305.00
10,545.00
18,718.00
19,745.00
6,000.00 $
43,000.00
2,500.00
5,000.00
3,200,000.00
3,256,500.00 $
50,000 00 $
339,889.00
693,033.00
18,718.00
190,740.00
1,000 00
(5,000.00)
(760,000.00)
(764,000.00)
21,300.00
600.00
(10,800.00)
26,700.00
3,100.00
1,052,000.00 $ 165,000.00 18.60%
98,962,839.00 $ (795,647.00) -0.80%
7,900,000.00 $ (800,000.00) -9.20% Unfav. due to lower than expected activity related to
construction projects, grants, and proprietary funds,
as well as closure of some internal service funds.
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FY 2012 SECOND QUARTER REPORT
Amount •
Favorable
(unfavorable) Percent Explanation of Significant Variances
165,000.00 18.60% Fav. reflects increase in commission on pay phones
$115,000 and Misc revenue budgeted in Non-Dept -
Sundry $50,000.
FY 2012
FORECAST
1,052,000 00
6,000.00 $
1,000.00
43,000.00
2,500.00
2,440,000.00
2,492,500.00 $
50,000.00 $
339,889_00
714,333,00
600.00
7,918.00
217,440.00
3,100.00
0.00%
0.00%
100.00%
0.00%
0.00%
-100.00%
-23.75% Unfav. due to income investment base and market
rate adjustments.
-23.46%
Favorable County Auction receipts of $16,500.
Budget is in Patrol Services Division, but actuals
are reflected in Sheriffs Office; and Enhancement
Funds of $4,800.
0.00%
0.00%
0.00%
100.00% Receipt of Adj of Prior Years Revenues, and
Refund Prior Years Expenditures.
-57.70% Unfav. due to actual County Auction receipts
recorded in Sheriff Office rather than Patrol
Services.
14.00% Receipt of Refund Prior Years Expenditures.
100.00% Due to Cash Overages
0.00%
0.00%
0.00%
0.00%
3.07%
* Revenue variance is partially offset by an expenditure variance. 6 of 7 6/12/2012
Treasurer
Library Board
Water Resources Commissioner
Management and Budget
Central Services - Support Services
Adopted
Budget
5,745.00
4,300.00
Amended
Budget
5,745.00
4,300.00
FY 2012
FORECAST
5,745.00
8,000.00
6,900.00
Facilities Management Administration
Health Division
900.00
3,100.00
8,900.00 Children's Village
153,000.00 153,000.00
417,500.00
6,300.00
(400,000.00) 417,500 00
(329,300.00)
5,656,048.00
49,375,476.00
$ s 56,904,449.00
Treasurers' Transfers 5,656,048.00
Non-Departmental - Transfers In 49,375,476.00
Total Other Revenues 56,012,382.00
7,464,234.76
17,508,009.00 $ 17,450,394.00 $
17,508,009.00 $ 24,914,628.76 $
0.00%
0.00%
4.12% Fav. donations for Business Roundtable event
0.00%
-95.81% Prior Years Adjustments anticipated to be lower
than budgeted.
0.00%
0.00%
-0.58%
0.00%
0.00%
0.00%
Homeland Security
Public Services
Economic Development - Donations
ea Non Departmental - Donations
Non-Dept - Sundry
PLANNED USE OF FUND BALANCE (665000-665999)
Encumbrances
Carryforwards and Use of Prior Yrs Fund Bal $
Total Planned Use of Fund Balance
159,300.00
17,500.00
5,656,048.00
49,375,476.00
56,575,149.00 $
7,464,234.76
17,840,309.00
25,304,543.76 $
COUNTY OF OAKLAND
GENERAL FUND I GENERAL PURPOSE REVENUES
FY 2012 SECOND QUARTER REPORT
Amount
Favorable
(unfavorable) Percent Explanation of Significant Variances
0.00%
0.00%
, 0.00%
8,000.00 100.00% Equalization prior year revenue.
2,600.00 60.47% Fav. printing materials auction due to closing
printing business and outsouiced to Oakland
Schools.
900.00 100.00% Refund Prior Years Expenditure
3,100.00 100.00% Fav, due to reimbursement for supplies/services
provided for Communities Health Needs
Assessments $2,800, County Auction $200, and
Cash Overages $100.
8,900.00 100.00% Fay, due to Donations $8,800 and County Auction
$100.
TOTAL GEN. FUND / GEN. PURPOSE REVENt $ 416,237,573.00 $ 424,140,665.76 $ 420,782,574.76 $ (3,748,006.00) -0.88%
* Revenue variance is partially offset by an expenditure variance. 7 of 7 6/12/2012
77,234.00
149,375.00
102,234 00
150,559 00
102,234.00
150,559.00
Civil / Criminal Division
Personnel Expenditures $ 2,000,808.00 $ 2,000,808.00 $ 1,815,808.00 $ 185,000.00
Operating Expenditures 5,261,944.00 5,262,414.80 4,902,414.80 360,000.00
Internal Support Expenditures 2,421,091.00 2,488,377.94 2,468,377.94
Transfers Out -
20,000.00
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
CIRCUIT COURT
AMOUNT
ADOPTED AMENDED FY 2012 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Judicial Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfer Out
$ 8,478,946.00 $ 8,478,946.00 $ 8,237,946.00 $ 241,000.00
130,840.95 180,000 00
325,293.00 348,171.68 348,171.68
50,000.00 50,000.00
2.84% - Fay. $75,000 due to underfilled and vacant positions and $166,000
due to a projected decrease in fringe benefit rates for hospitalization.
A budget amendment will be made for the decrease in the fringe rate
with the 2nd quarter forecast.
57.91% - Fay. Special Projects due to the distribution of Judicial Technology
funds from the State and Judges On-Line project (MR #9214) used
for courtroom technology improvements.
0.00% -
0.00%
92,176.00 310,840.95
$ 8,896,415.00 $ 9,187,958.63 $ 8,766,958.63 $
Business Division
Personnel Expenditures $ 1,659,943.00 $ 1,636,508.00 $ 1,598,508.00 $
ti.03
Operating Expenditures
Internal Support Expenditures
$ 1,886,552.00 $ 1,889,301.00 $ 1,851,301.00 $
421,000.00 4.58%
38,000.00 2.32% - Fav. due to a projected decrease in fringe benefit rates for
hospitalization. A budget amendment will be made with the 2nd
quarter forecast.
- 0.00% -
.. 0.00% -
38,000.00 2.01%
9.25% - Fay. $150,000 due to underfilled and vacant positions and $35,000
due to a projected decrease in fringe benefit rates for hospitalization.
A budget amendment will be made for the decrease in the fringe rate
with the 2nd quarter forecast.
6.84% - Fay. Defense Attorney Fee Payments $300,000 due to less activity.
These payments are dependent on caseload and the Circuit Court
fee structure. Also Fay. Juror Fees and Mileage $60000 due to a
decline in caseload.
0.80% - Fav. Equipment Rental due to tower than anticipated use.
$ 9,683,843.00 $ 9,751,600.74 $ 9,186,600.74 $ 565,000.00 5.79%
6/8/2012
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
CIRCUIT COURT
AMOUNT
ADOPTED AMENDED FY 2012 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Family Division/Juvenile Maint.
Personnel Expenditures $ 11,244,620.00 $ 11,228,909.00 $ 10,755,909.00 $ 473,000.00 4.21% - Fav. $300,000 due to undertilled and vacant positions and $173,000
due to a projected decrease in fringe benefit rates for hospitalization.
A budget amendment will be made for the decrease in the fringe rate
with the 2nd quarter forecast.
Operating Expenditures 13,230,661,00 13,230,661 00 12,340,661.00 890,000.00 6.73% - Fay. due to decrease in placements to State Institutions $600,000
and Private Institutions $100,000. Also Fay. Defense Attorney Fees
$100,000 and Fees Guardian Ad Litem $90,000 due to a decrease in
caseload.
Internal Support Expenditures 1,625,180.00 1,628,588.22 1,608,588.22 20,000.00 1.23% - Fay. Equipment Rental due to lower than anticipated use.
Transfer Out 5,139,405.00 5,139,605.00 5,139,605.00 0.00% -
$ 31.239,366.00 $ 31,227,763.22 $ 29,844,763.22 $ 1,383,000.00 4.43%
epartment Total
Cl/ Personnel Expenditures $ 23,384,317.00 $ 23,345,171.00 $ 22,408,171.00 $ 937,000.00 4.01%
Operating Expenditures 18,662,015.00 18,906,150.75 17,476,150.75 1,430,000.00 7.56%
Internal Support Expenditures 4,520,939.00 4,615,696.84 4,575,696.84 40,000.00 0.87%
Transfers Out 5,139,405.00 5,189,605.00 5,189,605.00 - 0.00%
$ 51,706,676.00 $ 52,056,623.59 $ 49,649,623.59 $ 2,4(17,000.00 4.62%
6/8/2012
Division 1 - Novi
Personnel Expenditures
Operating Expenditures
(1,400.00) -0.44%
$ 4,214,574.00 $ 4,214,574.00 $ 4,127,574.00 $ 87,000.00 2.06%
$ 211,203.00 $ 320,408.00 $ 321,808.00 $
990,659.00 990,682.75 968,682.75 22,000.00 2.22%
0.00% -
1.93%
2.10% -
6.45% -
$ 5,640,006.00 $ 5,651,661.40 $ 5,542,661.40 $
$ 1,952,079.00 $ 1,952,079.00 $ 1,911,079 00 $
Internal Support Expenditures
Transfers Out
197,474.00 222,389.79 222,389.79 0.00% -
0.00% -
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
DISTRICT COURT
ADOPTED
BUDGET
AMENDED FY 2012
BUDGET FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
District Court Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 205,903.00 $ 315,108.00 $ 315,108.00 $
5,300.00 5,300.00 6,700.00
0.00% -
(1,400.00) -26.42% Unfav. Visiting Judges due to a one-time medical issue.
0.00%
Fay. due to a projected decrease in fringe benefit rates
for hospitalization. A budget amendment will be made
with the 2nd quarter forecast.
Fay. Drug Testing $7,000 as a result of negotiating a
lower price for test cups and Interpreter Fees $5,000 due
to a reduced caseload. Also Fay, Defense Attorney
Fees $5,000 due to a procedural change that has
reduced costs, Property Taxes $2,000 due to a decrease
in property value and Office Supplies $3,000 due to a
conscious effort to reduce costs. A budget amendment
is recommended for these items in order to address the
budget task shortfall in revenues for the FY 2012 budget
task.
Internal Support Expenditures
Total Division 1 - Novi
Division 2 - Clarkston
Personnel Expenditures
Operating Expenditures
434,773.00
619,940.00
446,404.65 446,404.65
109,000.00
41,000.00
619,940.00 579,940.00 40,000.00
Fay. due to a projected decrease in fringe benefit rates
for hospitalization. A budget amendment will be made
with the 2nd quarter forecast.
Fay. Defense Attorney Fees due to restructured
schedule for defense attorneys.
Total Division 2 - Clarkston $ 2,769,493.00 $ 2,794,408.79 $ 2,713,408.79 $ 81,000 00 2.90%
6/8/2012
850,493.01 817,591.00 850,493 01
463,964.00
330,978.00
463,964.00
342,607.20
463,964.00
342,607.20
COUNTY OF OAKLAND
FY 2012 SIECOND QUARTER REPORT
EXPENDITURES
DISTRICT COURT
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2012
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Division 3 - Rochester Hills
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 3,797,977.00 $ 3,797,977.00 $ 3,717,977.00 $ 80,000.00
370,556.00 370,671.00 343,671.00 27,000.00
-
2.11% - Fay. due to a projected decrease in fringe benefit rates
for hospitalization A budget amendment will be made
with the 2nd quarter forecast.
7.28% - Fay. Defense Attorney Fees $15,000, Juror Fees and
Mileage $9,000 and Interpreter Fees $3,000 due to a
decrease in activity.
0.00% -
$ 4,986,124.00 $ 5,019,141.01 $ 4,912,141.01 $ 107,000.00 2.13%
Division 4 - Troy
Personnel Expenditures
kperating Expenditures
ternal Support Expenditures
$ 2,431,021.00 $ 2,431,021.00 $ 2,386,021.00 $
$ 3,225,963.00 $ 3,237,592.20 $ 3,192,592.20 $
45,000.00 1.85% - Fay. due to a projected decrease in fringe benefit rates
for hospitalization. A budget amendment will be made
with the 2nd quarter forecast.
0.00% -
- 0.00% -
45,000.00 1.39%
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
1.99%
3.57%
0.00%
$ 12,601,554.00 $ 12,710,759.00 $ 12,457,759.00 $
2,450,419.00 2,450,557.75 2,362,957.75
1,780,816.00 1,861,894.65 1,861,894.65
$ 16,832,789 00 $ 17,023,211 40 $ 16,682,611 40 $
253,000.00
87,600.00
340,600.00 2.00%
6/8/2012
292,984.00 292,984.00
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
PROBATE COURT
ADOPTED AMENDED
BUDGET BUDGET
FY 2012
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Judicial/Administration
Personnel Expenditures
Operating Expenditures
Internal Support
Transfer Out
i4•
4states/Mental Health
Personnel Expenditures
Operating Expenditures
Internal Support
$ 2,479,677.00 $ 2,479,677.00 $ 2,440,677.00 $ 39,000.00 1.57%
43,981.00 43,981.00 30,981.00 13,000.00 29.56%
292,984.00
$ . 2,816,642.00 $ 2,816,642.00 $ 2,764,642.00 $ 52,000.00 1.85%
$ 2,099,283.00 $ 2,099,283.00 $ 2,052,283.00 $ 47,000.00 2.24%
685,539.00 697,011.70 698,011.70 (1,000.00) -0.14%
518,036.00 539,239.24 539,239.24 - 0.00%
$ 3,302,858.00 $ 3,335,533.94 $ 3,289,533.94 $ 46,000.00 1.38%
Fav. due to a projected decrease in fringe benefit
rates for hospitalization. A budget amendment
will be made with the 2nd quarter forecast.
Fav. Library Continuations $9,000 due to
implemented cost containment measures and
Visiting Judges $4,000 due to a reduction in the
use of these services.
Fav. due to a projected decrease in fringe benefit
rates for hospitalization. A budget amendment
will be made with the 2nd quarter forecast.
Unfav. Medical Services Guardianship ($10,000)
due to a continued high demand for this item;
partially offset by Fav. Printing $5,000 and
Medical Services Probate Exam $4,000 where
demand has not yet occurred.
6/8/2012
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
PROBATE COURT
AMOUNT
ADOPTED AMENDED FY 2012 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Department Total
Personnel Expenditures $ 4,578,960.00 $ 4,578,960.00 $ 4,492,960.00 $ 86,000.00 1.88%
Operating Expenditures 729,520.00 740,992.70 728,992.70 12,000.00 1.62%
Internal Support 811,020.00 832,223.24 832,223.24 - 0.00%
Transfer Out - - - -
$ 6,119,500.00 $ 6,152,175.94 $ 6,054,175.94 $ 98,000.00 1.59%
4:s
4:s
6/8/2012
$ 4,691,263.00 $ 4,839,524.67 $ 4,659,824.67 $ 179,700.00
Transfers
4ai
01
0.00%
3.71%
Operating Expenditures 33,296.00 23,296.00 23,296.00 0.00%
Internal Support Expenditures
Transfers Out 855,589.00 1,070,803.00 1,070,803.00
$ 10,782,270.00 $ 10,987,484.00 $ 9,960,584.00 $ 1,026,900,00
0.00%
0.00%
9.35%
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
PROSECUTING ATTORNEY
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2012 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 2,354,757.00 $ 2,354,757_00 $ 2,168,057.00 $ 186,700.00
614,058.00 (7,000.00)
1,798,656.00 1,877,709.67 1,877,709.67
7.93% Favorable due largely to a number of underlined and vacant
positions; and positions assigned to this division but
actually working across divisional disciplines. A formal
reorganization is being implemented, and budget
amendments will be submitted upon completion. A budget
amendment of $36,108 is pending from Fringe Benefit
Administration to reflect the reduced Hospitalization rates.
-1.15% Unfav. due to payment of non-budgeted expenses for Aril of
Prior Years Expenses ($2,600); Dry Goods and Clothing of
($300); and Workshops and Meetings of ($4,100).
0.00%
537,850,00 607,058.00
Litigation
Personnel Expenditures $ 9,893,385.00 $ 9,893,385.00 $ 8,866,485.00 $ 1,026,900.00 10.38% Favorable due largely to a number of tinderfilled and vacant
positions; and positions assigned to this division but
actually working across divisional disciplines. A formal
reorganization is being implemented, and budget
amendments will be submitted upon completion. A budget
amendment of $130,548 is pending from Fringe Benefit
Administration to reflect the reduced Hospitalization rates.
6/8/2012
Operating Expenditures
Internal Support Expenditures
3,199.00 3,199.00
$ 2,319,731.00 $ 2,319,731.00 $ 2,117,631.00 $ 202,100 00
0.00%
0.00%
8.71%
3,199.00
Operating Expenditures
Internal Support Expenditures
8,458.00 8,458.00
$ 1,810,977.00 $ 1,810,977.00 $ 1,665,777.00 $ 145,200.00
0.00%
0.00%
8.02%
8,458.00
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
PROSECUTING ATTORNEY
AMOUNT
ADOPTED AMENDED FY 2012 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Warrants
Personnel Expenditures $ 2,316,532.00 $ 2,316,532.00 $ 2,114,432.00 $ 202,100.00 8.72% Favorable due largely to a number of underfilled and vacant
positions; and positions assigned to this division but
actually working across divisional disciplines. A formal
reorganization is being implemented, and budget
amendments will be submitted upon completion. A budget
amendment of $31,068 is pending from Fringe Benefit
Administration to reflect the reduced Hospitalization rates.
iepellate
cnersannel Expenditures $ 1,802,519.00 $ 1,802,519.00 $ 1,657,319.00 $ 145,200.00 8.06% Favorable due largely to a number of underfilled and vacant
positions; and positions assigned to this division but
actually working across divisional disciplines. A formal
reorganization is being implemented, and budget
amendments will be submitted upon completion. A budget
amendment of $23,872 is pending from Fringe Benefit
Administration to reflect the reduced Hospitalization rates.
Department
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
$ 16,367,193.00 $ 16,367,193.00 $ 14,806,293.00
582,803.00 642,011,00 649,011.00
1,798,656.00 1,877,709.67 1,877,709.67
855,589.00 1,070,803.00 1,070,803.00
1,560,900.00
(7,000 00)
9.54%
-1.09%
0.00%
0.00%
7.79% $ 19,604,241.00 $ 19,957,716.67 $ 18,403,816.67 $ 1,553,900.00
6/8/20 12
Sheriffs Office
Personnel Expenditures $ 1,738,929.00 $ 1,738,929.00 $ 1,698,529.00 $ 40,400.00 2.32%
Operating Expenditures
Internal Support Expenditures
Transfers
Administrative Services
Personnel Expenditures
Operating Expenditures
-FAk
-4 Internal Support Expenditures
Transfers
Corrective Services
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
Corrective Services -Satellites
Personnel Expenditures
66,236.00 75,236.00 77,236.00 (2,000.00) -2.66%
289,722.00 289,722.00 289,722.00 - 0.00%
- - - - 0.00%
$ 2,094,887.00 $ 2,103,887.00 $ 2,065,487.00 $ 38,400.00 1.83%
$ 2,028,924.00 $ 2,079,380.00 $ 1,979,680.00 99,700.00 4.79%
1,109,738.00 1,256,882.45 1,112,482.45 144,400.00 11.49%
56,988 00 56,988.00 56,988.00 0.00%
- - 0.00%
$ 3,195,650.00 $ 3,393,250.45 $ 3,149,150.45 $ 244,100.00 7.19%
36,273,686.00 $ 34,639,122.00 $ 35,610,822.00 (971,700.00) -2.81%
7,533 154.00 9,014,664.63 8,021,364.63 993,300.00 11.02%
7,473,520.00 7,778,292.97 7,778,292.97 0.00%
0.00%
$ 51,280,360.00 $ 51,432,079.60 $ 51,410,479.60 $ 21,600.00 0.04%
$ 11,509,309.00 $ 11,509,309.00 $ 12,860,609.00 $ (1,351,300.00) -11.74%
T.-0JUN I T 'Jr
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
SHERIFF'S OFFICE
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2012
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Fav due to a projected decrease in the overall fringe benefit rates,
largely in Hospitalization. A budget amendment of $23.700 is
pending from Fringe Benefit Administration to reflect the reduced
Hospitalization rates.
Unfav contracted services for Communications for reimbursemenl
of cell phone usage.
Fay due to a projected decrease in the overall fringe benefit rates,
largely in Hospitalization. A budget amendment of $43,200 is
pending from Fringe Benefit Administration to reflect the reduced
Hospitalization rates.
Fay due to departmental directed reduction in uniform
replacements; and Postage-Standard Mailing line item replaced by
Metered Postage.
Unfav. due to increased usage of overtime ($2,181,600) at the main
jail, caused by high number of vacant positions; partially offset by
favorable salaries and fringe benefits of $1,798,000 based an
vacancies and lower fringe benefit rates, largely in Hospitalization;
a budget amendment of $588,100 is pending.
Fav. due to slow start of the Jail Clinic contract $1,036,700 and
reduced usage of culinary supplies, groceries and provisions of
$78,700; paritally offset by increased usage of custodial supplies,
laundry and cleaning ($122,100) at the main jail. Fay exp offset by
unfav revenue for board and care.
Unfav. due to increased usage of overtime at the Satellites
Facilities ($1,136,600); caused by Hospital Watch, vacant
positions, prisoner transport, employee sick and other leaves, and
East Annex security; and unfav. fringe benefits of ($34,200) for
Retirement, Workers Compensation, and FICA benefits. A budget
amendment of ($180,500) to adjust Hospitalization is pending.
6/8/2012
ADOPTED
BUDGET
30,750 00
AMENDED
BUDGET
FY 2012
FORECAST
Operating Expenditures 30,750.00 86,350.00
0.00%
0.00%
Operating Expenditures
Internal Support Expenditures
Transfers
Patrol Services
Personnel Expenditures
424
03
Operating Expenditures
Internal Support Expenditures
Transfers
1,269,950.00
164,118.00
1,269,950.00
164,118.00
1,272,450.00
164,118.00
$ 8,444,253.00 $ 8,439,147.00 $ 8,102,047.00 $
$46,712,695 $ 46,523,514.00 $ 44,117,414.00 $
574,196.00
4,891,270.00
857,975.00
4,890,457.94
1,070,528.00 1,272,380.12 1,188,880.12
359,400.00
83,500.00
$ 7,937,554.00 $ 7,937,554.00 $ 7,578,154.00 $
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
SHERIFF'S OFFICE
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT
(55,600.00) -180.81% Unfav due to increased Satellite Jail related expenses (e.g. laundry
and cleaning, custodial supplies, and office supplies).
EXPLANATION OF SIGNIFICANT VARIANCES
Internal Support Expenditures
Transfers
997,602.00 1,000,776.36 1,000,776.36
$ 12,537,661.00 $ 12,540,835.36 $ 13,947,735,36 $ (1,406,900.00) -11.22%
Emergency Response and Preparedness
Personnel Expenditures $ 7,010,185.00 $ 7,005,079.00 $ 6,6135,479.00 $
339,600.00 4.85% Fay due to a projected decrease in the overall fringe benefit rates,
largely in Hospitalization. A budget amendment of $129,300 is
pending from Fringe Benefit Administration to reflect the reduced
Hospitalization rates.
(2,500.00) -0.20% Unfav Other Expendable Equipment.
- 0.00%
- 0.00%
Fay due to a projected decrease in the overall fringe benefit rates,
largely in Hospitalization (a budget amendment of $711,800 is
pending; also projected favorable overtime.
337,100.00 3.99%
2,406,100.00 5.17%
857,975.00 - 0.00%
4,890,457.94 - 0.00%
- - 0.00%
$ 52,178,161.00 $ 52,271,946.94 $ 49,865,846.94 $ 2,406,100.00 4.60%
Investigative/Forensic Svcs
Personnel Expenditures
Operating Expenditures
4.53"/. Fay due to a projected decrease in the overall fringe benefit rates,
largely in Hospitalization. A budget amendment of $130,100 is
pending from Fringe Benefit Administration to reflect the reduced
Hospitalization rates.
6.56% Fav due largely to lower purchases of Software Support
Maintenance $76,500; and Fingerprint Supplies $7,000.
Internal Support Expenditures
Transfers
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfer Out
2,029,710.00
334,086.00
$ 11,371,878.00
$ 113,211,282.00
11,654,552.00
15,902,930.00
334,086.00
2,029,748.32
704,962.00
$ 11,944,644.44
$ 111,432,887.00
13,777,838.20
16,210,103.59
704,962.00
2,029,748.32 0.00%
704,962.00 0.00%
$ 11,501,744.44 $ 442,900.00 3.71%
$ 110,510,687.00 $ 922,200.00 0.83%
12,616,738.20 1,161,100.00 8.43%
16,210,103.59 0.00%
704,962.00 0.00%
$ 141,102,850.00 $ 142,125,790.79 $ 140,042,490.79 $ 2,083,300.00 1.47%
6/8/2012
Operating Expenditures
Internal Support Expenditures
Transfers
91,137.00
116,073.00
91,137.00
122,817.00
91,137.00
122,817.00
0.00%
0.00%
0.00%
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
CLERK/REGISTER OF DEEDS
AMOUNT
ADOPTED AMENDED FY 2012 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures $ 790,359.00 $ 790,359.00 $ 768,259.00 $ 22,100.00 2.80% Fay. Turnover $15,000 and $7,100 due to a projected decrease
in Fringe Benefit rates for hospitalization. A budget amendment
will be made for the decrease in Fringe Benefit rate with 2nd
quarter Forecast.
$ 997,569.00 $ 1,004,313.00 $ 982,213.00 $ 22,100.00 2.20%
County Clerk (Vital Stats & Legal Rec's)
Personnel Expenditures $ 3,570,503.00 $ 3,570,503.00 $ 3,387,503.00 $ 183,000.00 5.13% Fav. $100,000 due to underfill and vacant positions. Also,
ED $83,000 due to a projected decrease in Fringe Benefit rates for
hospitalization. A budget amendment will be made for the
decrease in Fringe Benefit rate with 2nd quarter Forecast.
Operating Expenditures
Internal Support Expenditures
Transfers
309,342.00
629,096.00
320,698.60
674,279.67
320,698.60 0.00%
674,279.67 0.00%
0.00%
$ 4,508,941.00 $ 4,565,481.27 $ 4,382,481.27 $ 183,000.00 4.01%
Elections .
Personnel Expenditures $ 744,588.00 $ 744,588.00 $ 731,188.00 $ 13,400.00 1.80% Fay. Due to a projected decrease in Fringe Benefit rates for
hospitalization. A budget amendment will be made with 2nd quarter
forecast.
Operating Expenditures
Internal Support Expenditures
Transfers
787,878 00
252,922,00
788,328.00
256,869.00
788,328.00 0.00%
256,869.00 0.00%
0.00%
$ 1,785,388.00 $ 1,789,785.00 $ 1,776,385.00 $ 13,400.00 0.75%
6/8/2012
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
CLERK/REGISTER OF DEEDS
AMOUNT
ADOPTED AMENDED FY 2012 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Register of Deeds (and Micrographics)
Personnel Expenditures $ 3,156,803 00 $ 3,156,803.00 $ 3,008,803 00 $ 148,000.00 4.69% Fav. $85,000 due to underfill and vacant positions. Also,
$63,000 due to a projected decrease in Fringe Benefit rates for
hospitalization. A budget amendment will be made for the
decrease in Fringe Benefit rate with 2nd quarter Forecast.
Operating Expenditures 340,600.00 340,600.00 $ 340,600.00 0.00%
Internal Support Expenditures 404,606.00 407,161.41 $ 407,161.41 - 0.00%
Transfers - - - - 0.00%
$ 3,902,009.00 $ 3,904,564.41 $ 3,756,564.41 $ 148,000.00 3.79%
Jury Commission
Personnel Expenditures $ 23,315.00 $ 23,315.00 $ 11,715.00 $ 11,600.00 49.75% Fav. Due to a projected decrease in Fringe Benefit rates for
al hospitalization. A budget amendment will be made with 2nd quarter
C3 forecast.
Operating Expenditures 67,776.00 67,776.00 67,776,00 - 0.00%
Internal Support Expenditures 33,947.00 16,898.13 16,898.13 - 0.00%
$ 125,038.00 $ 107,989.13 $ 96,389.13 $ 11,600.00 10.74%
Department Total
Personnel Expenditures $ 8,285,568.00 $ 8,285,568.00 $ 7,907,468.00 $ 378,100.00 4.56%
Operating Expenditures 1,596,733.00 1,608,539.60 1,608,539.60 $ - 0.00%
Internal Support Expenditures 1,436,644.00 1,478,025.21 1,478,025.21 $ - 0.00%
Transfers - - - 0.00%
$ 11,318,945.00 $ 11,372,132.81 $ 10,994,032.81 $ 378,100.00 3.32%
6/8/2012
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
COUNTY TREASURER
AMOUNT
ADOPTED AMENDED FY 2012 FAVORABLE
BUDGET BUDGET FORCAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures $ 3,098,789.00 $ 3,098,789.00 $ 3,037,589.00 $
Operating Expenditures 3,871,640.00 3,880,249.12 4,304,749.12
61,200.00 1.97% - Fav. Due to a projected decrease in Fringe Benefit rates for
hospitalization. A budget amendment will be made with 2nd
quarter forecast.
(424,500.00) -10.94% - Unfav, largely due to increase in Fees Civil Service ($300,000)
activity Advertising of ($23,800), Miscellaneous of ($10,200),
Foreclosure notification ($32,000), Recording Fee-Forfeiture Cert
($40,000) offset by projected favorable revenue, Recording Fee-
Redemption Cert. ($22,000) partially offset by projected favorable
revenue. Register of Deeds expense of ($6,000). Also fay. offset
of Twp & City Trees Bonds $9,500.
Internal Support Expenditures
Transfers Out
Division Total
Department Total
775,976.89 0.00% -
120,000.00 120,000.00
$ 7,647,233.00 $ 7,875,015.01 $ 8,238,315.01 $
$ 7,647,233.00 $ 7,875,015 01 $ 8,238,315.01 $ (363,300.00) -4.61%
556,804.00 775,976.89
120,000.00
(363,300.00) -4.61%
618120 1 2
Administration
Personnel Expenditures $2,423,637.00 $ 2,423,637.00 $ 2,286,037.00 $ 137,600.00
$ 3,063,647.00 $ 3,081,483.34 $ 2,920,883.34 $ 160,600.00 5.21%
$ 3,063,647.00 $ 3,081,483.34 $ 2,920,883.34 $ 160,600.00 5.21%
COUNTY OF OAKLAND
FY 201,2 SECOND QUARTER REPORT
EXPENDITURES
BOARD OF COMMISSIONERS
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2012 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
5.68% - Fay. due to a projected decrease in Fringe Benefit rates for hospitalization.
A budget amendment will be made for the decrease in Fringe Benefit rate
with 2nd quarter Forecast,
430,368.00
209,642.00
Operating Expenditures
Internal Support Expenditures
430„399.50 $ 407,399.50
227,446.84 $ 227,446.84
23,000.00 5.34% - Fay. Travel and Conference $10,000 due to reduced travel. Workshops and
Meetings $10,000 due to reduced demand; Personal Mileage $3,000 clue to less
travel.
0.00% -
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 2,423,637.00
430,368 00
209,642.00
$ 2,423,637.00
430,399.50
227,446.84
$ 2,286,037.00 $
407,399,50
227,446.84
137,600.00
23,000.00
5.68%
5.34%
0.00%
6/8/2012
Library Board
Personnel Expenditures $ 709,237.00 $ 709,237.00 $ 697,837.00 $ 11,400.00
Operating Expenditures
Internal Support Expenditures
Transfers
249,092,00
507,340 00
249,092.00
508,179.56
249,092.00
508,179.56
0.00%
0.00%
$ 1,465,669.00 $ 1,466,508.56 $ 1,455,108.56 $ 11,400 00 0.78%
1.61%
0.00%
0.00%
11,400.00
$ 1,465,669.00 $ 1,466,508.56 $ 1,455,108.56 $ 11,400.00 0,78%
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
LIBRARY BOARD
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2012 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
1.61% Fay. Due to a projected decrease in Fringe Benefit rates
for hospitalization. A budget amendment will be made with
the 2nd quarter Forecast.
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 709,237.00 $ 709,237.00 $ 697,837.00 $
249,092.00 249,092.00 249,092.00
507,340.00 508,179.56 508,179.56
6/8/2012
Ul 4th Internal Support Expenditures 1,246,069.46 3,800,844.46 1,127,984 00
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
WATER RESOURCES COMMISSIONER
AMOUNT
ADOPTED AMENDED FY 2012 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Water Resource Commissioner
Personnel Expenditures $ 3,393,824.00 $ 3,393,824.00 $ 898,810.00 $ 2,495,014.00 73.52% A recommended second quarter budget amendment to revise the Water
Resources Commissioner budget for the implementation of the Collaborative
Asset Management System (CAMS). The CAMS implementation resulted in
favorable Salaries $1,618,043, Overtime $26,972 and Fringes $849,999 because
CAMS changes how Time and Labor Distribution is entered for Payroll
purposes. Effective 12/03/2011, all WRC employees are paid from the Drain
Equipment Fund and CAMS will track the detail labor by system/kind and bill
back the various system funds for labor expenses through the Drain Equipment
Labor account.
Operating Expenditures 487,975.00 488,238.54 488,238.54 0.00%
(2,554,775.00) -205.03% A recommended second quarter budget amendment to revise the Water
Resources Commissioner budget for the implementation of the Collaborative
Asset Management System (CAMS). The CAMS implementation resulted in
unfavorable Drain Equipment Labor ($2,495,014) for the offset of favorable
Salaries, Overtime and Fringes because CAMS changes how Time and Labor
Distribution is entered for Payroll purposes. Effective 12/03/2011. all WRC
employees are paid from the Drain Equipment Fund and CAMS will track the
detail labor by system/fund and bill back the various system funds for labor
expenses through the Drain Equipment Labor account. Utley - Drain Equipment
($16,600) the result of an under estimated budget forecast compared to actual
historical spending trend. Unfav - Info Tech Operations ($43,161) due to the
CAMS maintenance charge, some of the expenses will be offset in
Reimbursement General Revenue.
Transfers 56,165.00 56,165.00 56,165.00 0.00%
$ 5,065,948.00 $ 5,184,297.00 $ 5,244,058.00 $ (59,761.00) -1.15%
Department Total $ 5,065,948,00 $ 5,184,297.00 $ 5,244,058.00 $ (59,761.00) -1.15%
Total
6/8/2012
Auditing
Controllable Personnel
Controllable Operating
Internal Support Expenditures
al Transfer Out al
Corporation Counsel
Controllable Personnel
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
COUNTY EXECUTIVE
AMOUNT
ADOPTED AMENDED FY 2012 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
Administration
EXPLANATION OF SIGNIFICANT VARIANCES
Controllable Personnel $ 2,161,428.00 $ 2,161,428.00 $ 2,126,428.00 $ 35,000,00 1.62% - Fay due to underfill & fringe rate reduction. A budget amendment is pending
from Fringe Benefit Administration to reflect the reduced Hospitalization rates.
Controllable Operating 282,944.00 282,944.00 242,944.00 40,000.00 14.14% - Fay due to fewer anticipated printing projects
Internal Support Expenditures 378,912.00 385,116.71 385,116.71 - 0.00% -
Transfer Out -
$ 2,823,284.00 $ 2,829,488.71 $ 2,754,488.71 $ 75,000.00 2,65%
$ 489,903.00 $ 489,903.00 $ 489,903.00 $- 0.00% -
32,467.00 32,467.00 22,467.00 10,000 00 30.80% - Fay due to less need for external audit assistance than originally anticipated
71,006.00 71,006.00 71,006.00 - 0.00% -
$ 593,376.00 $ 593,376.00 $ 583,376.00 $ 10,000.00 1.69%
$ 2,093,839.00 $ 2,093,839.00 $ 2,053,839.00 $ 40,000.00 1.91% - Fay due to underfill & fringe rate reduction. A budget amendment is pending
from Fringe Benefit Administration to reflect the reduced I lospitalization rates.
Controllable Operating 59,133.00 59,133.00 59,133.00 - 0.00% -
Internal Support Expenditures 201,732.00 202,430 37 202,430.37 0 00% -
Transfer Out -
$ 2,354,704,00 $ 2,355,402.37 $ 2,315,402.37 $ 40,000,00 1.70%
Department Total
Controllable Personnel $ 4,745,170.00 $ 4,745,170.00 $ 4,670,170.00 $ 75,000.00 1.58%
Controllable Operating 374,544.00 374,544.00 324,544.00 50,000.00 13.35%
Internal Support Expenditures 651,650.00 658,553.08 658,553.08 - 0.00%
Transfers Out - - -
$ 5,771,364.00 $ 5,778,267.08 $ 5,653,267.08 $ 125,000.00 2.16%
6/8/2012
Operating Expenditures 431,404.00 431,404.00
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
MANAGEMENT AND BUDGET
AMOUNT
ADOPTED AMENDED FY 2012 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
$ 221,676.00 $ 221,676.00 $ 221,676.00
4,017.00 4,017.00 4,017.00
11,008.00 11,008.00 11,008.00
$ 236,701.00 $ 236,701.00 $ 236,701.00 $
0.00%
0.00%
0.00%
0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
Purchasing
Personnel Expenditures $ 1,148,698.00 $ 1,148,698.00 1,088,698.00 $
Operating Expenditures 16,785.00 16,785.00 16,785.00
@nternal Support Expenditures 138,064.00 138,124.20 138,124.20
Transfers - - -
$ 1,303,547.00 $ 1,303,607.20 $ 1,243,607.20 $
60,000.00 5.22% Fav due to underfill & fringe rate reduction. A budget amendment is
pending from Fringe Benefit Administration to reflect the reduced
Hospitalization rates.
0.00%
0.00%
60,000.00 4.60%
Equalization
Personnel Expenditures $ 8,393,823.00 $ 8,393,823.00 $ 7,693,823.00 $ 700,000.00 8.34% Fav turnover & fringe rate reduction. A budget amendment is pending
from Fringe Benefit Administration to reflect the reduced
Hospitalization rates.
371,404.00 60,000.00 13.91% Fay- Prof Services and Personal Mileage due to efforts to contain
costs
Internal Support Expenditures 1,000.201.00 1,163,922.43
Transfers
$9,825,428.00
1,123,922.43 40,000.00 3.44% Fav IT Operations
0.00%
8.01% $9,989,149.43 $ 9,189,149.43 $ 800,000.00
6/8/2012
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
MANAGEMENT AND BUDGET
AMOUNT
ADOPTED AMENDED FY 2012 FAVORABLE
BUDGET • BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Fiscal Services
Personnel Expenditures $ 8,071,971.00 $ 8,071,971.00 $ 7,821,971.00 $ 250,000.00 3.10% Fav turnover & fringe rate reduction. A budget amendment is pending
from Fringe Benefit Administration to reflect the reduced
Hospitalization rates.
Operating Expenditures 391,339.00 391,339.00 391,339.00 0.00%
Internal Support Expenditures 1,267,377.00 1,384,796.50 1,384,796.50 0.00%
Transfers - - 0.00%
$ 9,730,687.00 $ 9,848,106.50 $ 9,598,106.50 $ 250,000.00 2.54%
Department Total
Personnel Expenditures $ 17,836,168.00 $ 17,836,168.00 $ 16,826,168.00 $ 1,010,000.00 5.66%
Operating Expenditures 843,545.00 843,545.00 783,545.00 60,000.00 7.11%
Internal Support Expenditures 2,416,650.00 2,697,851.13 2,657,851.13 40,000.00 1.48%
Transfers - - - - 0.00%
LTI
--4 $ 21,096,363.00 $ 21,377,564.13 $ 20,267.564.13 $ 1,110,000 00 5.19%
6/8/2012
Administrative
Personnel Expenditures 214,937.00 $ 214,937.00 $ 213,037.00 $
$ 1,388,509.00 $
496,181.00
765,487.00
1,388,509.00 $ 1,282,609.00 $
504,362.00 393,662.00
776,970.43 776,970.43
7.63%
21.95%
0.00%
0.00%
8.11%
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
CENTRAL SERVICES
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2012
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
1,900.00 0.88% Fay, due to medical costs less than expected. Budget amendment
for medical costs will be presented with 2nd Qtr forecast
Operating Expenditures
Internal Support Expenditures
Transfers
3,098.00
13,558.00
3,098.00
13,558.00
3,098.00 0.00%
13,558.00 0.00%
Support Services
Personnel Expenditures
cJ
Operating Expenditures
$ 231,593.00 $ 231,593.00 $ 229,693.00 $ 1,900.00
$ 1,173,572.00 $ 1,173,572.00 $ 1,069,572.00 $ 104,000.00
493,083.00 501,264.00 390,564.00 110,700.00
Fay. due to FTE position filled with PTNE, and retirement and
medical costs less than expected. Budget amendment for medical
costs will be presented with 2nd Qtr forecast.
22.08% Fay. mail handling-postage $83,400, copy charge $4,000 due to
lost CVT business; reduction in metered postage $12,600 due to
spending less than expected.
Fay. reduce spending in travel $3,200, licenses & permits $6,000,
expendable equipment $1,000 & office supplies $1,000 for Move
Update compliance to meet USPS requirements. Budget
amendment will be presented with 2nd qtr forecast.
0.82%
8.86%
Internal Support Expenditures 751,929.00 763,412.43 763,412.43 0.00%
0.00%
214,700.00 8.81%
Transfers
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 2,418,584.00 $ 2,438,248A3 $ 2,223,548.43 $
$ 2,650,177.00 $ 2,669,841.43 $ 2,453,241.43 $
105.900.00
110,700.00
216,600.00
6/5/2012
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 238,460.00 $ 238,460.00 5
5,764.00
28,832.00 28,832 00
5,764.00
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
FACILITIES MANAGEMENT
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2012
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
235,060.00 $ 3,400.00 1.43% - Fay. Fringe benefits due to turnover. A budget amendment is recommended to reduce
Hospitalization by $2,533.
5,764.00 0.00%
21,932.00 6,900.00 23.93% - Fay. IT Operations $5,000 based on required usage and fav. Telephone
Communications $1,900 reflecting charges made to the FM8,0 Fund.
$ 273,056.00 $ 273,056.00 $ 262,756.00 $ 10,300.00 3.77%
Facilities Engineering
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 847,916.00 $ 847,916.00 $
86.482.00 87,010.50
59,668.00 59,929.51
697,916.00 $ 150,000.00
87,010.50
59,929.51
17.69% - Fay. due to turnover and staff time charged to Projects for engineering services.
A budget amendment is recommended to reduce Hospitalization by $14,813.
0.00%
0.00%
$ 994,066.00 $ 994,856.01 $ 844,856.01 $ 150,000.00 15.08%
Mpartrnent Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 1,086,376.00 $1,086,376.00 $
92,246.0C, 92,774.50
88,500.00 88,761.51
932,976.00 $ 153,400.00
92,774.50
81,861.51 6,900.00
14.12%
0_00%
7.77%
$ 1,267,122.00 $1,267,912.01 $ 1,107,612.01 $ 160,300.00 12.64%
6/8/2012
Workforce Management
Personnel Expenditures
co
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
HUMAN RESOURCES
AMOUNT
ADOPTED AMENDED FY 2012 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures $ 781,126.00 $ 781,126.00 $ 556,126.00 $ 225,000.00 28.80% Favorable due to unfilled positions/vacancies and fringe rate reductions. A budget
amendment is pending from Fringe Benefit Administration to reflect the reduced
Hospitalization rates.
Operating Expenditures 290,122.00 363,122.00 363,122.00 $0.00% -
Internal Support Expenditures 29,232.00 32,256.81 32,256.81 $- 0.00%
Transfer Out - - -
$ 1,100,480.00 $ 1,176,504.81 $ 951,504.81 $ 225,00(1.00 19.12%
$ 1,841,948.00 $ 1,841,948.00 $ 1,742,948.00 $ 99,000.00 5.37% Favorable due to unfilled positions/vacancies and fringe rate reductions. A budget
amendment is pending from Fringe Benefit Administration to reflect the reduced
Hospitalization rates.
198,795.00 198,795.00 188,795.00 $ 10,000.00 5.03% Fav Professional Services and Travel and Conference due to efforts to reduce spending Operating Expenditures
Internal Support Expenditures 510,912.00 560,910.30
Transfer Out
560,910.30 $ 0,00%
Benefits Administration
Personnel Expenditures
$ 2,551,655.00 $ 2,601,653.30 $2,492,653.30 $ 109,000,00 4.19%
$ 171,116.00 $ 171,116.00 $ 164,016.00 $ 7,100.00 4.15% Favorable due to unfilled positions/vacancies and fringe rate reductions. A budget
amendment is pending from Fringe Benefit Administration to reflect the reduced
Hospitalization rates.
Operating Expenditures
Internal Support Expenditures
Transfer Out
16,977.00
131,265.00
16,977.00
131,265.00
16,977.00 $ 0.00%
131,265_00 $ 0.00%
$ 319,358.00 $ 319,358.00 $ 312,258.00 $ 7,100.00 2.22%
Department Total
Personnel Expenditures $ 2,794,190.00 $ 2,794,190.00 $2,463,090.00 S 331,100.00 11.85%
Operating Expenditures 505,894.00 578,894.00 568,894.00 10,000.00 1.73%
Internal Support Expenditures 671,409.00 724,432.11 724,432.11 - 0.00%
Transfer Out - - -
6/8/2012
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
HUMAN RESOURCES
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2012 FAVORABLE
FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 3,971,493.00 $ 4,097,516.11 $3,756,416.11 $ 341,100.00 8.32%
6/8/2012
4,955,219.00 9,063,365.62 8,652,065.62 411,300.00
Internal Support Expenditures 3,097,249.00 3,481,078.85 3,471,078.85
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
HEALTH AND HUMAN SERVICES
AMOUNT
ADOPTED AMENDED FY 2012 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures $ 209,641 00 $ 209,641.00 $ 204,641.00 5,000.00 2.39% - Fav. due to fringe benefit rate. Budget amendment for
Medical costs will be presented with Second Quarter
Forecast.
7,710,134.00 2,050,000.00 Operating Expenditures
Internal Support Expenditures
Transfers Out
9,760,134.00 9,760,134.00
16,982.00 16,982.00
21.00% - Fay. Foster Boarding Homes $300,000. Fay. Private
Institutions Residential, Private Institutions Foster Care and
Private Institutions 1,600,000. Fay. Independent Living
$150,000. Costs are based on caseload, difficulty of care,
and treatment of services ordered by the Court. Fav. is
partially offset by (Unfav.) Non-Dept. Child Care Subsidy
Revenue (50% reimbursement).
16,982.00 - 0.00% -
Health
Personnel Expenditures
$ 9,986,757.00 $ 9,986,757.00 $ 7,931,757.00 $ 2,055,000.00 20.58%
$ 24,791,255.00 $ 24,867,859.00 $ 23,367,859.00 1,500,000.00 6.03% - Fay. due to turnover, under filled positions and fringe
benefit rate. Budget amendment for Medical costs will be
presented with Second Quarter Forecast.
Operating Expenditures 4.54% - Fay.. Professional Services $500,000 from dental program
primarily due to FY 2011 carry forward along with the new
contractor accepting Medicaid rates. Fav. Drugs $20,000
due to savings from reduced contract rates as well as
Medical Supplies $25,000 due to reduction in the need for
medical delivery systems (i.e. syringes). Partially offset by
unfav. Adj Prior Years Revenue ($133,700) for Zero to
Three Grant and Nurturing Parenting Program.
10,000.00 0.29% - Fay. Communications $10,000 due to decreased activity
and continued efforts to minimize expenses and contain
costs.
Transfers Out
$ 32,843,723.00 $37,412,303.47 $ .35,491,003.47 $ 1,921,300.00 5.14%
6/8/2012
Children's Village
Personnel Expenditures $ 14,711,970.00 $ 14,829,171.00 $ 14,529,171.00 $ 300,000.00
Operating Expenditures $ 3,716,357.00 3,816,072.08 3,781,072.08 35,000.00
289,680.00 289,680.00 257,180_00 32,500.00
Internal Support Expenditures 473,458.00 475,966.48 469,966.48
/...A.A.111 I T
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
HEALTH AND HUMAN SERVICES
AMOUNT
ADOPTED AMENDED FY 2012 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
2.02% - Fay. due to turnover, under filled positions and fringe
benefit rate. Budget amendment for Medical costs will be
presented with Second Quarter Forecast.
0.92% - Fay. Provisions $50,000 due to fluctuating commodity costs
and Equipment Maintenance $7,500 clue to limited repair
costs incurred. Partially offset by (Unfav.) Drugs ($10,000)
due to increased youth psychiatric medical needs, Training
and Educational Supplies ($7,500) due to the purchase of
materials for new treatment program and Travel and
Conference ($5,000) due to statewide Re-entry conference
partially sponsored by Children's Village along with staff
learning new treatment program.
Internal Support Expenditures 2,764,053.00 2,855,051.86 2,853,051.86 2,000.00 0.07% - Fay. Convenience Copier $10,000 due to decreased activity
and continued efforts to minimize expenses and contain
Cri costs. Partially offset by (Unfav.) Radio Communications
03 ($5,000) due to increased equipment costs and Motor Pool
($3,000) due to increased activity.
Transfers Out 248,000.00 280,732.00 280,732.00
Homeland Security
Personnel Expenditures
$ 21,440,380.00 $ 21,781,026.94 $ 21,444,026.94 $ 337,000.00 1.55%
$ 758,524.00 $ 758,524.00 $ 723,524.00 $ 35,000.00 4.61% - Fay. due to under filled positions and fringe benefit rate.
Budget amendment for Medical costs will be presented with
Second Quarter Forecast.
Operating Expenditures 11.22% - Fay. Equipment Maintenance $30,000 due to limited repair
costs incurred on specialty/hazmat vehicles and
Communications $2,500 due to continued efforts to
minimize expenses and contain costs.
6,000.00 1.26% - Fav. Insurance Fund $3,000 and Telephone
Communications $3,000 due to decreased activity and
continued efforts to minimize expenses and contain costs.
Transfers Out
$ 1,521,662.00 $ 1,524,170.48 $ 1,450,670.48 $ 73,500.00
6/8/2012
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
HEALTH AND HUMAN SERVICES
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2012
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Transfers Out
$ 40,471,390.00
18,721,390.00
6,351,742.00
248,000.00
$ 40,665,195 00
22,929,251.70
6,829,079.19
280,732.00
$ 38,825,195.00 $
20,400,451.70
6,811,079.19
280,732.00
1,840,000.00 4.52%
2,528,800.00 11.03%
18,000.00 0.26%
0.00%
$ 65,792,522.00 $ 70,704,257.89 $ 6(3,317,457.89 $ 4,386,800.00 6.20%
4>k
6/8/2012
4,800.00 4,800.00
4,965.00 4,965.00
1,437,931.00 $ 55,000.00
700.00 195,212.00
176,371.66
195,912.00
176,785.00
195,912.00
177,871.66 1,500.00
Veterans Services
Personnel Expenditures $ 1,492,931.00 $ 1,492,931.00
Operating Expenditures
Internal Support Expenditures
Transfers
3.68% - Fav due to fringe rate reduction. A budget amendment is pending from
Fringe Benefit Administration to reflect the reduced Hospitalization rates.
0.36% - Fav-based on per diem fees and # of meetings
0.00% - Fav-Telephone communications
0.00%
3,330,273.00 $ 300,000 00
438,510.00 112,000.00
2,000.00 601,524.96
Community Corrections
m Personnel Expenditures $ 3,630,273.00 $ 3,630,273.00
Operating Expenditures 502,025.00 550,510.00
Internal Support Expenditures 519,682.00 603,524.96
Transfers
8.26% - Fay due to underfilled positions/vacancies and fringe rate reductions A
budget amendment is pending from Fringe Benefit Administration to reflect ect
the reduced Hospitalization rates.
20.34% - Fay due to Contract Services-(number of offenders into treatment have
gone down). A budget amendment is recommended to rea,ppropriate
$12,000 for community service garden project.
0.33% - Fav-Telephone communications
0.00% -
89,689.00
255,444.71
49,689.00
246,444.71
40,000.00
9,000.00
Medical Examiner
Personnel Expenditures
Operating Expenditures 520,006.00 520,228.40 500,228.40 20,000.00
$ 3,228,666.00 $ 3,228,666.00 $ 3,128,666.00 $ 100,000.00
Internal Support Expenditures 1,042,046.00
Transferee ee related revenue offset.
1,054,825.69 1,054,825.69 0.00%
6/8/2012
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
PUBLIC SERVICES
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2012
FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT
198,059.00 $
4,800.00
4,965.00
$ 211,824.00 $ 211,824.00 $ 207,824.00 $
Public Services - Admin.
Personnel Expenditures $ 202,059.00 $ 202,059.00
Operating Expenditures
Internal Support Expenditures
4,000.00 1.98% - Fay due to fringe rate reduction. A budget amendment is pending from
Fringe Benefit Administration to reflect the reduced Hospitalization rates.
0.00% - -
- 0.00% -
4,000.00 1.89%
$ 1,865,628.00 $ 1,866,714.66 $ 1,809,514.66 $ 57,200.00 3.06%
MSU Ext. - Oakland County
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ '4,651,980.00 $ 4,784,307.96 $ 4,370,307.96 $ 414,000.00
842,459.00 $ 842,459.00 $ 802,459.00 $ 40,000.00
89,689.00
252,648.00
8.65%
4.75% - Fav due to underfilled positions/vacancies and fringe rate reductions. A
budget amendment is pending from Fringe Benefit Administration to reflect
the reduced Hospitalization rates.
44.60% - Fay car allowance and printing due to efforts to reduce spending
3.52% - Fav-Telephone communications and Info Tech Operations
$ 1,184,796.00 $ 1,187,592.71 $ 1,098,592.71 $ 89,000.00 7.49%
3.10% - Fay due to underfilled positions/vacancies and fringe rate reductions. A
budget amendment is pending from Fringe Benefit Administration to reflect
the reduced Hospitalization rates.
3.84% - Fav due to Lab supplies $41,000 partially offset by Transportation Service
($21,000)
3,049,527.63 $ 200,000.00 6.15%
214,732.00
881,432.63
(20,000.00)
0.00% -
0.00% -
-
54,326.00
549,936.78
54,126.00
544,936.78
699,000.00
172,900.00
17,500.00
6.04%
10.61%
0.50%
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
PUBLIC SERVICES
ADOPTED
BUDGET
AMENDED
BUDGET
AMOUNT
FY 2012 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT
Animal Control
Personnel Expenditures
$ 4,790,718.00 $ 4,803,720.09 $ 4,683,720.09 $ 120,000.00 2.50%
$ 2,173,363.00 $ 2,173,363.00 $ 1,973,363.00 $ 200,000.00 9.20% - Favorable due to underfilled positions/vacancies partially offset by unfav
revenue. A budget amendment is pending from Fringe Benefit
Administration to reflect the reduced Hospitalization rates.
Operating Expenditures
Internal Support Expenditures
Transfers
190,097.00
819,450 00
$ 3,182,910.00 $
214,732.00
881,432.63
(20,000.00)
3,249,527.63 $
54,326.00
536,667.00
$ 590,993.00 $
Circuit Court Probation
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
07
0.00%
200.00 0.37% Fav Equip Maintenance based on usage
5,000.00 0.91% Fav-Telephone communications and Info Tech Operations
604,262.78 $ 599,062.78 $ 5,200.00 0.86%
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 11,569,751.00 $ 11,569,751.00 $ 10,870,751.00 $
1,556,855.00 1,630,197.40 1,457,297.40
3,352,243.00 3,528,001.43 3,510,501.43
(20,000.00) (20,000.00)
5.32% $ 16,478,849.00 $ 16,707,949.83 $ 15,818,549.83 $ 889,400.00
* See related revenue offset. 6/8/2012
$ 1,195,903.00 $ 1,195,903.00 $ 1,114,603.00 $ 81,300.00
338,222.00 467,582.00 322,882.00 144,700.00
63,521.00 204,560.78 202,160.78 2,400.00
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
6.80% - FB Rate Adj
30.95% - Fay. Professional Services $116,000 due to utilization of PTNE
position to perform services previously obtained through
professional services; fay. Printing $16,900 and Travel $19,000
based on anticipated usage; partially offset by unfav. Workshops &
Meetings ($4,600) due to Business Roundtable Event and Supplies
($2,600).
1.17% Fav.Telephone Communications $1,700 and Motor Pool $300
based on expected charges.
Internal Support Expenditures 698,995.00 711,423 47 677,923.47
Transfers
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS
AMOUNT
ADOPTED AMENDED FY 2012 FAVORABLE
BUDGET BUDGET FORECAST UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 1,597,646.00 $ 1,868,045.78 $ 1,639,645.78 $ 228,400.00 12.23%
GI
Planning and Economic Development Services
Personnel Expenditures $ 3,688,943.00 $ 3,688,943,00 $ 3,396,843.00 $ 292,100.00
Operating Expenditures 1,188,080.00 1,387,296.00 991,396.00 395,900.00
7.92% FB Rate Adj
28.54% - Fay. primarily in Professional Services, for NO HAZ Program
$324,600 based on reduced resident participation (offset by
reduced program reimbursement), Mom Dues $6,400, Supplies
$12,300, Travel $4,900 & Printing $57,900 based on expected
usage; Software Maint $15,400 due to decrease maintenance
costs. Partially offset by unfav. Business Recruitment ($26,200)
due to level of local activity in regards to business retention and
expansion work.
33,500.00 4.71% Fay. IT Ops $27,800, Copier $3,000 & Telephone Comm $2,800
due to usage less than anticipated.
$ 5,576,018.00 $ 5,787,662.47 $ 5,066,162.47 $ 721,500.00 12.47%
6/8/2012
AMENDEID
BUDGET
AMOUNT
FY 2012 FAVORABLE
FORECAST 'UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Workforce Development
Personnel Expenditures 25,620.00 $ 25,620.00 $ 25,620.00 $ 0.00%
0.00% $ 25,620.00 $
$ 4,625,318.00
1,314,278.00
880,084.25
Operating Expenditures
Internal Support Expenditures
CI 03
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
$ 25,620.00
$ 4,998,718.00
1,854,878.00
915,984.25
$ 25,620.00
$ 4,998,718.00
1,526,302.00
762,516.00
$ 373,400.00 7.47%
540,600.00 29.14%
35,900.00 3.92%
0.00%
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
EXPENDITURES
ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS
ADOPTED
BUDGET
Community and Home Improvement
Personnel Expenditures $ 88,252.00 $
Operating Expenditures -
Transfers
88,252.00 $ 88,252,00 $ 0.00%
$ 88,252.00 $ 88,252.00 $ 88,252.00 $ 0.00%
12.23% $ 7,287,536.00 $ 7,769,580.25 $ 6,819,680.25 $ 949,900.00
6/8/2012
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION
0.00% $ 3,535,742.00 $ 3,227,057.97 $ 3,227,057.97 COUNTY BUILDINGS
0.26%
0.01%
6.70%
0.00%
5.37%
188.00
3.00
33,488.00
33,679.00
Fay. due to membership rate decrease.
0.00% $ 300,000.00 $ 300,000.00 $ 300,000.00 $ SUNDRY EXPENSE
166,099.00 $
319,745.00
1,310,000.00
777,577.00
3,957,838.95
36,400.00
75,000.00
51,736.00
250,000.00
6,944,395.95
166,099.00
319,745.00
1,310,000_00
777,577.00
3,957,838.95
36,400.00
75,000 00
51,736.00
250,000.00
6,944,395.95 $
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0,00%
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
NON-DEPARTMENTAL EXPENDITURES
NON-DEPARTMENT APPROPRIATIONS
COUNTY OPERATIONS
Insurance Fund
Insurance Surety Bonds
Logos Trademarks Intellect Property
Road Commission1Current Drain Assessment
Road Commission\Tri Party Agreement
Provisions
Transfer to Community Mental Health Authority
Total
ADOPTED
BUDGET
$ 359,787.00
27,910.00
18,000.00
1,400,000,00
100.00
30,000,00
9,620,616.00
AMENDED
BUDGET
359,787,00
27,910.00
18,000.00
1,524,349.00
1,864,761.00
30,000.00
9,620,616 00
FY 2012
FORECAST
$ 359,787.00
27,910.00
18,000.00
1,524,349.00
1,864,761.00
30,000,00
9,620,616.00
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00% $ 11,456,413.00 $ 13,445,423.00 $ 13,445,423.00 $
ED
STATE AND FEDERAL - COUNTY ASSOCIATIONS
Michigan Assoc. of Counties $ 73,000.00 $ 73,000.00 $ 72,812.00 $
National Assoc. of Counties 24,700.00 24,700.00 24,697.00
S.E.M.C.O.G. 500,000.00 500,000.00 466,512.00
Traffic Improvement Association 30,000.00 30,000.00 30,000.00
Total $ 627,700.00 $ 627,700.00 $ 594,021.00 $
RESERVED FOR TRANSFERS
Expenditures
Classification and Rate Change
Contingency
Emergency Salaries
Grant Match
Info Tech Development
Legislative Expense
Misc. Capital Outlay
Overtime Appropriation
Summer Employees Salary Appropria
Total
$ 154,469.00
300,000.00
1,310,000.00
1,160,000.00
5,815,600.00
36,400.00
75,000.00
53,000.00
on 250,000.00
$ 9,154,469.00 $
6/8/2012
TRANSFER TO GENERAL PURPOSE FUNDS
Child Care Fund
Social Welfare Fund Foster Care
$ 23,347,678 00 $ 23,612,469.86 $ 23,612,469 86 0.00%
1,000_00 1,00000 1,000.00 0.00%
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
NON-DEPARTMENTAL EXPENDITURES
AMOUNT
ADOPTED AMENDED FY 20112 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION
Transfers to Other Funds
Fire Records Management $ 430,185.00 $ 430,185.00 $ 430,185.00 0.00%
CLEMIS 1,844,000.00 1,844,000.00 1,844,000.00 0.00%
Information Technology 646,140.00 . 646,140.00 646,140.00 0.00%
Health WIC - 7,920.00 7,920.00 0.00°A
$ 2,920,325.00 $ 2,928,245.00 $ 2,928,245.00 $ 0.00%
TOTAL NON-DEPT. APPROPRIATIONS $ 27,994,649.00 $ 27,472,821 92 $ 27,439,142.92 $ 33,679.00 0.12%
$ 23,348,678.00 $ 23,613,469.86 $ 23,613,469,86 $ 0.00%
TOTAL EXPENDITURES $ 51,343,327.00 $ 51,086,291.78 $ 51,052,612.78 $ 33,679.00 0.07%
6/8/2012
M.R. #11279 - 11/30/2011
Sheriffs Office Patrol Contract with the City of Pontiac
60,466.00
$ 288,679.76
$ 7,175,555,00 $ 7,464,234.76
$ (221,985.00)
$ (186,155.00)
$ . (175,808.00)
(15,711.00)
FY 2012 BUDGET AMENDMENTS
FY 2011 BUDGET AS ADOPTED - GENERAL FUND/GENERAL PURPOSE FUNDS $ 416,237,573.00
BUDGET AMENDMENTS
M.R. #11219 - 10/5/2011 225.00
County Clerk - Elections Division Board of Canvassers Agreement City of Hazel Park
M.R. #11235 -10/512011 19,745.00
Health Inland Beach Grant Contract
M.R. #11239 - 10/5/2011 16,500.00
Sheriffs Office - Automobile Theft Prevention Authority
M.R. - 1012012011
Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance)
M.R. #11245 - Commerce Township $ 42,816.00
M.R. #11247 - Highland Township $ 19,962.00
M.R. #11248 - Independence Township $ 16,950.00 $ 79,728.00
M.R. #11244 - 10/20/2011 13,995.00
Sheriffs Office - Establishment of Law Enforcement Services Parks and Recreation
M.R. #11264 - 11/2/2011 225.00
Clerk/Register of Deeds Board of Canvassers
M.R. #11257 - 11/2/2011 7,920.00
HHS Heath Women Infant Children (WIC) Rent
M.R. #11263 - 11/2/2011 $ 245,821.00
HHS Prevention Pilot program
M.R. -1112/2011
Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance)
M.R. #11259 - City of Ferndale 24,836.00
M.R. #11286 - 11/3012011 $ 143,079.00
Sheriff Prosecuting Attorney NET Grant Acceptance
M.R. #11305 - 12/1512011
M&B FY 2011 Year End Report
Encumbrances
Carry Forwards
M.R. #11300 - 12/15/2011
Sheriff - Patrol Contract with Highland Township
M.R. #11301 - 12/15/2011
Sheriff - Patrol Contract with Lyon Township
M.R. #11319 - 12/15/2011
Sheriff - Patrol and Dispatch Contract with Orion Township
M.R. #11316 - 1/19/2012
Circuit Court Personal Protection Order Liaison
M.R. #12005 -2/1612012 50,000.00
Circuit Court Restore Foundation Donation
71
FY 2012 BUDGET AMENDMENTS
(1,898.00)
(16,911.00)
$ 682,488.00
$ (287,702.00)
M.R. #12000 - 2116/2012
Health and Human Service - Relocation of Positions to Children's Village
M.R. #12021 -2/16/2012
Shelf - Dispatch Contract Rates
M.R. #12021 -211612012
Shelf - Use of Forfeited Funds
M.R. #12021 - 2/16/2012
Sheiff - Inmate Health Care
M.R. #12xxx -3/2212012
HHS - Health Division Huron Valley School District Service Agreement
Reim Contract 2,610.00
Planned Use of Fund Balance $ (2,610.00) $
M.R. #12xxx -312212012
Facilities Management - Licensed Parking Bill Fox Chevrolet
Reim Contract 7,000.00
Planned Use of Fund Balance $ (7,000.00) $
M.R. #12xxx -3/2212012
Sheriffs Office - Off Road Vehicle Safety Education Program Grant
State Grant 2,160.00
Planned Use of Fund Balance $ (2,160.00) $
TOTAL AMENDED BUDGET AS OF 3/31/2012 $ 424,140,665.76
72
REVENUES
Charges for Services $25,000,000.00 $25,000,000.00 $25,000,000.00 $0.00 0.00%
$ 106,905.00
460,250.00
1,750,000.00
5,656,048.00
23,150,000.00
1,846,075.00
2,091,601.00
1 342 200.00
$ 34,085,924.00
$ 36,403,079.00
$ 106,905.00
460,250.00
1,750,000.00
5,656,048.00
23,150,000.00
1,846,075.00
2,091,601.00
1 342,200.00
$_ 34,085,924.00
$ 36,403,079.00
$ 106,905.00 $ 2,400.00
460,250.00
400,000.00
2.24% Fay. Due to a projected decrease in Fringe Benefit rates for
hospitalization. A budget amendment will be made with the
2nd quarter Forecast.
0.00%
1,350,000.00 77.14% Fav due to lower interest rates and level of debt.
FY 2012 SECOND QUARTER REvut-c I
ENTERPRISE FUND
TREASURERS OFFICE
ADOPTED
BUDGET
DELINQUENT TAX REVOLVING FUND 51600
AMENDED
BUDGET
FY 2012
FORECAST
VARIANCE
FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Other Revenues
Total Revenues
2,022,497 00
$27,022,497.00
2,022,497.00
$27,022,497.00
1,184,624.00
$26,184,624.00
j837,873.00)
($837,873.00)
-41.43% Unfav due to falling interest rates on investments.
-3.10%
OPERATING EXPENSES
Personnel Expenditures
Operating Expenditures
Interest Expense
Transfer Out to Other Funds:
General Fund - Collection Fees
GF Non-Departmental
Work Release Facility Debt Svc Cs) Office Bldg Renovation Debt Svc
52-3 District Court Debt Service
Total Transfer Out to Other Funds
Total Operating Expenses
5,656,048.00 0.00%
23,150,000.00 0.00%
1,619,050.00 227,025.00 12.30% Forecast changed to reflect latest refunding of debt obligation
1,941,232.00 150,369.00 7.19% Forecast changed to reflect latest refunding of debt obligation.
1,342,200.00 0.00 0.00%
$ 33,708,530.00 $ 377,394.00 1.11%
$ 34,675,685.00 $ 1,729,794.00 4.75%
REVENUE OVER (UNDER)
EXPENDITURES
Total Net Assets - Beginning
Total Net Assets - Ending
($9,380,582.00) (9,380,582.00) ($8,491,061.001
$218,687,420.89
$210,196,359.89
$891,921.00
Ending FY 2011 Designated Fund Balance:
Designated - Debt Service
Designated - Deling Taxes Receivable
Designated - Collection Fees
Undesignated - Fund Balance
Total Net Assets - Ending
$72,568,273.84
105,909,116.47
15,000,000.00
$16,718,969.58
DTRF 51600 Quarterly Forecast.xlsx 6/8/2012
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
98,188,963.00
95 057,263.00
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
ENTERPRISE FUND
PARKS & RECREATION
ADOPTED AMENDED FY 2012 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
[
OAKLAND COUNTY PARKS &
RECREATION COMMISSION (50800)
OPERATING REVENUE $ 8,291,300 00 $ 8,358,514,00 $ 8,358,514.00 $- 0.00%
OPERATING EXPENSE . $ 23,107,000.00 $ 23,174,214.00 $ 23,174,214.00 $- 0.00%
NET OPERATING INCOME (LOSS) $ (14,815,700.00) $ (14,815,700.00) $ (14,815,700.00) 8 - 0.00%
NON-OPERATING REVENUE $ 11,684,000.00 $ 11,684,000.00 $ 11,684,000.00 $- 0.00%
(EXPENSE)
--4
4=a,
TOTAL INCOME BEFORE TRANSFERS. $ (3,131,700.00) $ (3,131,700.00) $ (3,131,700.00) $
TRANSFERS IN $ $ - $
CAPITAL IMPROVEMENT PROGRAM $ $ - $ - $
TOTAL NET INCOME (LOSS)* $ (3,131,700 00) $ (3,131,700.00) $ (3,131,700.00) _$
0.00%
6/8/2012
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER FORECAST REPORT
INTERNAL SERVICE FUND
WATER RESOURCES COMMISSIONER
ADOPTED AMENDED FY 2012 VARIANCE
BUDGET BUDGET FORECAST FAV1(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
IDRAIN EQUIPMENT FUND ( 63900)
OPERATING REVENUES:
Inside $4,181,342.00 $4,181,342.00 $24,520,342.00 $20,339,000.00 486.42% A recommended second quarter budget amendment to revise the Water Resources
Commissioner budget for the implementation of the Collaborative Asset
Management System (CAMS). The CAMS implementation resulted in favorable
Rebilled Charges $120,178, Reimbursement General $1,428,348 and
Reimbursement Salaries $18,152,819 because CAMS changes how Time and Labor
Distribution is entered for Payroll purposes. Effective 12/03/2011, all WRC
employees are paid from the Drain Equipment Fund and CAMS will track the detail
labor by system/fund and bill back the various system funds for labor expenses
through the Drain Equipment Labor account. Fav - Reimbursement General
$600,000 the result of inventory being tracked through CAMS, the Drain Equipment
fund had to buy the inventory from the Water Sewer General Administrative fund
offset in expense Material and Supplies. Fav - Vehicle Rental $37,655 due to
second quarter budget amendment to replace 1 owned vehicle to leased vehicle.
$630,000.00 Outside 255,000.00 255,000.00 885,000.00 247.06% A recommended second quarter budget amendment to revise the Water Resources
Commissioner budget for the implementation of the Collaborative Asset
Management System (CAMS). The CAMS implementation resulted in favorable EXT.
Rebilled Charges $330,000 because CAMS changes how Time and Labor
Distribution is entered for Payroll purposes. Effective 12/03/2011, all WRC
employees are paid from the Drain Equipment Fund and CAMS will track the detail
labor by system/fund and bill back the various system funds for labor expenses
through the Drain Equipment Labor account. Also, favorable EXT-Rebilled Charges
$130,000 for MDOT Siphon Inspection project and $170,000 for SCADA Engineering
project, offset in Contracted Services expense.
Total Revenue 4,436,342.00 4,436,342,00 25,405,342.00 20,969,000.00 472.66%
6/8/2012
OPERATING EXPENSES 4,489,842.00 4,489,842.00 25,474,792.00 (20,984,950.00)
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
4,987,625.00
$4,953,343 00
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER FORECAST REPORT
INTERNAL SERVICE FUND
WATER RESOURCES COMMISSIONER
ADOPTED AMENDED FY 2012 VARIANCE
BUDGET BUDGET FORECAST FAV1(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
-467.39% A recommended second quarter budget amendment to revise the Water Resources
Corrmiissioner budget for the implementation of the Collaborative Asset
Management System (CAMS). The CAMS implementation resulted in unfavorable
Salaries, Overtime and Fringes ($19,701,345) and unfavorable Drain Equipment
Labor ($330,000) because CAMS changes how Time and Labor Distribution is
entered for Payroll purposes. Effective 12/0312011, all WRC employees are paid
from the Drain Equipment Fund and CAMS will track the detail labor by system/fund
and bill back the various system funds for labor expenses through the Drain
Equipment Labor account, Fav - Fringes $18,718 the result of lowering the
hospitalization illustrative rates by 10%. Fay - Communications $20,000 a result of
the Real Time Locating charges billed through Internal Service Telephone
Communications. Unfav Information Technology Development ($4,200) for
maintenance performed on the Automatic Meter Reading System_
Unfav - Material and Supplies ($600,000) the result ol inventory being tracked
through CAMS, the Drain Equipment fund had to buy the inventory if0111 the Water
Sewer General Administrative fund offset in revenue Reimbursement General.
Unfav - Contracted Services ($130,000) for MDOT Siphon Inspection project arid
cn ($170,000) for SCADA Engineering project, offset in EXT-Rebilled Charges. Unfav -
Indirect Cost ($23,600) due to indirect cost rate finalized after budget process.
Unfav - Protective Clothing arid Equipment ($20,000) due to maintenance on gas
detectors. Unfav Motor Pool ($7,323) second quarter budget amendment for the
rental cost to replace I owned vehicle to leased vehicle. Unfav - Telephone
Communications ($20,000) a result of billing the Real Time Locating system cost
(part of the cellphone bill), offset by favorable Communications line item, Unfav -
Shop Supplies ($4,500) and Small Tools ($8,000) the result of actual spending being
more than budget projection.
NET INCOME (LOSS) BEFORE (53,500.00) (53,500.00) (69,450.00) (15,950.00) 29.81%
NON-OPERATING REVENUE/(EXPENSE) 53,500 00 53,500.00 65,500.00 12,000 00 22.43% Fay - investment income $12,000 the result of fund earning a return due to a positive
cash balance.
TRANSFER IN - _ 0.00%
TRANSFERS (OUT)- - 30,332.00 (30,332.00) 0.00% Unfav - Transfer Out ($30,332) the result of a second quarter budget amendment for
the replacement cost of 1 owned vehicle to leased vehicle.
NET REVENUES OVER (UNDER) $0.00 $0.00 ($34,282 00) ($34,282.00)
EXPENSES
6/8/2012
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
INTERNAL SERVICE FUND
RISK MANAGEMENT
ADOPTED AMENDED FY 2012 VARIANCE
BUDGET BUDGET FORECAST FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
'LIABILITY INSURANCE FUND 67700
OPERATING REVENUES:
Outside Revenue - $ - $ - $
Inside Revenue
Total Operating Revenue
2,880,499.00 2,880,499.00 2,880.499.00 0.00%
$ 2,880,499 00 $ 2,880,499 00 $ 2,880,499 00 $ 0.00%
. OPERATING EXPENSE $ 3,044,161.00 $ 3,044,161.00 $ 3,044,161.00 $- 0.00% -
CLAIMS PAID 768,500.00 768,500.00 768,500.00 0.00%
TOTAL OPERATING EXPENSES $ 3,812,661.00 $ 3,812,661.00 $ 3,812,661.00 $ 0.00%
OPERATING INCOME (LOSS) (932,162.00) (932,162.00) (932,162.00)- 0.00%
NON-OPERATING REVENUE (EXPENSE) 400,000.00 400,000.00 400,000.00 0.00%
NET REVENUES OVERAUNDER)
EXPENSES $ 532,162.00) $ (532,162.00) (532,162.00)
TOTAL NET ASSETS - BEGINNING 17,934,456.77
TOTAL NET ASSETS - ENDING 17,402,294.77
6/6/2012
1,511,300 3.10% - Charges to departments favorable due to underestimated budget.
'141,600 3.36%
320,000 0.00% - Favorable due to PTNEs now contributing for retirement admin services.
(1,150,000) -7.49% - Unfavorable due to decrease in full time salaries.
0.00%
110,100 109.55% - Favorable due to settlement of bargaining unit. County match discontinued.
0.00%
- 0.00%
0.00%
0.00%
0.00%
0.00%
9.09%
-25.56% - Unfavorable due to change in payment processing.
-6.45% - Decreased charges to departments due to less full-time salaries.
-16.63% - Charges to departments reduced due to lower projected expenses.
-3.16% A budget amendment is recommended
0.00%
23,500 12.21%
0.00%
(300,000) -17.65% - Unfavorable due to change in short term disability plan.
0.00%
0.00%
0 00%
0,00%
0.00%
20.00%
0.00%
0.00%
-17.50%
0.00%
0.00%
10.00%
0.00%
100.00% •
0.00%
-4.41%
50,000
(230,000)
(1,000,000)
(5,806,700)
(300,000)
100,000
-
-
(70,000)
2,000
2,300
700
-
(6,595,200)
COUNTY OF OAKLAND
FY2012 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
ADOPTED AMENDED FY2012 VARIANCE A BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT [FRINGE BENEFITS FUND 67800 EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING REVENUE
RETIREES MEDICAL - VEBA DEBT
RETIREMENT ADMINISTRATION
RETIREMENT ADMINISTRATION - PTNE
DEFINED CONTRIBUTION PLAN
DEFINED CONTRIBUTION PLAN - PTNE
DEFERRED COMPENSATION - COUNTY
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
EXT - FLEX BEN MEDICAL - EMPLOYEE
EXT - MEDICAL INSURANCE
EXT - PRESCRIPTION DRUG REBATES
EXT - DENTAL INSURANCE
EXT - VISION INSURANCE
EXT - FLEX BEN LIFE INSURANCE
EXT - FLEX BEN DENTAL INSURANCE
EXT - FLEX BEN VISION INSURANCE
EXT - FORFEITURE OF DEPOSITS
EXT - TRAINING
EXT - WELLNESS
EXT - OTHER REVENUE - ICMA REBATES
TOTAL REVENUE
48,788,700 48,788,700 50,300,000
4,208,400 4,208,400 4,350,000
320,000
15,350,000 15,350,000 14,200,000
175,000 175,000 175,000
100,500 100,500 210,600
1,355,000 1,355,000 1,355,000
937,300 937,300 937,300
200,000 200,000 200,000
496,500 496,500 496,500
95,900 95,900 95,900
260,000 260,000 260,000
550,000 550,000 600,000
900,000 900,000 670,000
15,500,000 15,500,000 14,500,000
34,926,700 34,926,700 29,120,000
9,500,000 9,500,000 9,200,000
3,060,000 3,060,000 3,060,000
192,500 192,500 216,000
601,200 601,200 601,200
1,700,000 1,700,000 1,400,000
2,672,665 2,672,665 2,672,665
800,000 800,000 800,000
540,100 540,100 540,100
5,000,000 5,000,000 5,000,000
280,000 280,000 280,000
500,000 500,000 600,000
25,000 25,000 25,000
2,500 2,500 2,500
400,000 400,000 330,000
115,000 115,000 115,000
105,000 105,000 105,000
20,000 20,000 22,000
2,300
700
150,000 150,000 150,000
149,507,965 149,507,965 142,912,765
FRINGE BENEFII FY2012 Second Quarter Forecast xls 6/1212012
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
18,965,848
20,718,648
COUNTY OF OAKLAND
FY2012 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
ADOPTED AMENDED FY2012 VARIANCE
BUDGET BUDGET FORECAST FAVi(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES [FRINGE BENEFITS FUND 67800
OPERATING EXPENSE
RETIREES MEDICAL - VEBA DEBT PRING. 19,545,000 19,545,000 19,545,000 - 0.00%
RETIREES MEDICAL - VEBA DEBT INT, 29,243,700 29,243,700 29,243,700 _ 0.00%
RETIREMENT ADMINISTRATION 4,208,400 4,208,400 4,400,000 (191,600) -4.55% - Unfavorable due to fees based on increasing value of portfolio.
DEFINED CONTRIBUTION PLAN 15,500,000 15,500,000 14,200,000 1,300,000 8.39% - Favorable due to decrease in salaries for full-time staff
DEFINED CONTRIBUTION PLAN - PTNE 175,000 175,000 175,000 - 0.00%
DEFERRED COMPENSATION - COUNTY 100,500 100,500 210,600 (110,100) -109.55% - Unfavorable due to settlement of bargaining unit. County match discontinued.
EMPLOYEE IN-SERVICE TRAINING 1,005,000 1,005,000 1,005,000 - 0.00%
IN-SERVICE TRAINING - INFO TECH 350,000 350,000 350,000 . 0.00%
EMPLOYEE BENEFITS UNIT 937,300 937,300 937,300 - 0.00%
FLEXIBLE BENEFIT PAYMENTS . 200,000 200,000 200,000 - 0.00%
WELLNESS PROGRAM 496,500 496,500 496,500 0.00%
ACCOUNTING SERVICES 95,900 95,900 95,900 - 0.00%
TUITION REIMBURSEMENT 260,000 260,000 260,000 - 0.00%
RETIREMENT HEALTH SAVINGS 550,000 550,000 600,000 (50,000) -9.09%
GROUP LIFE INSURANCE 1,300,000 1,300,000 990,000 310,000 23.85% - Favorable due to change in payment processing.
SOCIAL SECURITY 15,500,000 15,500,000 14,500,000 1,000,000 6.45% - Based on decrease in full-time salaries.
MEDICAL INSURANCE 40,206,700 40,206,700 34,400,000 5,806,700 14.44% - Favorable due to projected costs less than budget projections. .-.1 CD PRESCRIPTION COVERAGE 10,000,000 10,000,000 9,700.000 300,000 . 3.00% - Favorable due to a decrease in projected costs for claims and administration fees.
DENTAL INSURANCE 3,200,000 3,200,000 3,200,000 - 0.00%
VISION INSURANCE 300,000 300,000 300,000 . 0.00%
DISABILITY INSURANCE 2,301,200 2,301,200 2,301,200 - 0.00%
WORKERS COMPENSATION 2,672,665 2,672,665 2,672,665 - 0.00%
UNEMPLOYMENT COMPENSATION 800,000 800,000 800,000 . 0.00%
CHILD CARE FACILITY 270,900 270,900 270,900 . 0.00%
INDIRECT COSTS 289,200 289,200 306,200 (17,004 -5.88% - Unfavorable due to actual charges developed after budget finalization,
TOTAL EXPENSE 149,507,965 149,507,965 141,159,965 8,348,000 5.58%
NET REVENUE OVER/(UNDER) EXPENSES 0.00 0.00 1,752,800 1,752,800
FRINGE BENEFIT FY2012 Second Quarter Forecast xis 6/12/2012
OAKLAND COUNTY INTERNATIONAL
AIRPORT (56500)
OPERATING REVENUE
1,037,683.00 1,037,683.00
$0.00 $0.00
COUNTY OF OAKLAND
Pt' 2012 SECOND QUARTER REPORT
ENTERPRISE FUNDS
CENTRAL SERVICES
ADOPTED AMENDED FY 2012 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING EXPENSE
$4,875,421.00 $4,875,421.00 $4,488,621.00 ($386,800.00) -7.93% - Unfav. land Lease ($141,000) due to lower than anticipated lease
concessions; reduced in T-Hangar rental ($200,000) due to a decrease in
number of T-Hangar leased.
6,191,848.00 6,191,848.00 8,899,248.00 (2,707,400.00) -43.73% - Unfev. adj prior years expenses ($609,000) due to closing prior years non-'
capital projects; increase in depreciation ($2,357.000) due to closing current
and prior years capital projects. Fav indirect cost $11,000 due to actual
charges developed after budget finalization; reduced Building Maintenance
Charges $40,000, Custodial Service $8,400 due to less maintenance for new
terminal building; decrease in personnel expense $186,000 due to one FTE
position filled with PTNE, one underfilled position, two positions filled with
employees with lower step, and retirement and medical costs less than
expected. Budget amendment for medical costs will be presented with the
2nd Qtr forecast.
T OPERATING INCOME (LOSS) ($1,316,427.00) ($1,316,427.00) ($4,410,627.00) ($3,094,200 00) 235.05%
NON-OPERATING REVENUE (EXPENSE) 278,744.00 278,744.00 278,744 00 0.00 0.00%
($1,037,683.00) ($1,037,683.00) $ (4,131,883.00) ($3,094,200 00)
TOTAL INCOME BEFORE
CONTRIBUTIONS AND TRANSFERS
TRANSFERS IN
CAPITAL CONTRIBUTION
TOTAL NET INCOME (LOSS)
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
14,988,683.00 $13,951,000 00
$10,856,600.00 $10,856,800.00
$ 67,851,058.94
$78,707,858.94
1344.44% Fay. capital asset contribution due to closing capital projects.
6/8/2012
MOTOR POOL FUND 66100
OPERATING REVENUE:
Outside Revenue
Inside Revenue
Total Revenue
OPERATING EXPENSE
03 —a
ADOPTED
BUDGET
$ 77,000.00
7,967,493.00
AMENDED
BUDGET
FY 2012
FORECAST
3.06% - Anticipated fay. leased equipment $200,000 due to new leased
vehicles under new billing method.
8.12% - Fav. personnel $40,000 due to retirement and medical costs
less than expected. Budget amendment for medical costs will
be presented with the 2nd Qtr forecast.
Fay. indirect cost $251,500 due to actual charges developed
after budget finalization; decrease in fleet insurance $298,000
due to premium saving; reduced spending in Expendable
Equipment $31,000 due to used vehicles purchase less than
expected.
Unfav. depreciation expenses ($37,000) due to more vehicles
purchased (including 10 vehicles in FY2011 Capital Budget
Plan) and total costs more than expected.
NON-OPERATING REVENUE
(EXPENSE)
140,000.00 140,000 00 140,000.00 $ 0.00%
FY 2012 SECOND QUARTER REPOR I
INTERNAL SERVICE FUNDS
CENTRAL SERVICES
7,806,928.00
PERCENT
-15.58%
OPERATING INCOME (LOSS)
VARIANCE
FAV/(UNFAV)
77,000.00 $ 65,000.00 $ (12,000.00)
8,011,857.00 8,256,857.00 $ 245,000.00
7,867,792.00 7,229,292.00 $ 638,500.00
EXPLANATION OF SIGNIFICANT VARIANCES
- Unfav. ext-parts and accessories revenue ($ 1,700) and ext-
productive labor revenue ($32,000) due to CVT requesting less
service, offset by fay. in warranty reimbursement $21,700 due
to GM warranty claims repaired in-house.
$ 8,044,493.00 $ 8,088,857.00 $ 8,321,857.00 $ 233,000.00
$ 237,565.00 $ 221,065.00 $ 1,092,565.00 $ 871,500.00
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
TRANSFERS IN / (OUT)
NET REVENUE OVER/(UNDER)
EXPENSES (PLANNED USE OF
FUND BAL.)
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
$ 377,565.00 $ 361,065.00 $ 1,232,565.00 $ 871,500.00
(483,500.00) (453,200.00) $ 30,300.00
$ 377,565.00 $ (122,435.00) 779,365.00 $ _901,800.00
$ 7,780,062.71
$ 8 559,427.71
Fav. transfer in $30,300 due to new leased vehicle to replace
WRC owned vehicle. Budget amendment is being included
with the 2nd Qtr forecast.
J:\FiscalSvc\Budget\Forecast_New\SUPPORT SERVICES.xls 6/8/2012
$404,540.00 $404,540.00
25,837,659.00 25,787,659.00
$26,242,199,00 $26,192,199.00
0.00 0.00%
,L50,000.001 -0.19%- Lower Maintenance Department Charges revenue based on expected level of
($50,000.00) -0.19% departmental requests.
8,36% - Fay. Natural Gas/ Fuel Oil $700,000 due to lock-in of favorable long-term pricing
contracts; fay. Electrical Service $500,000 due to lower-cost third-party contracts
and savings from energy conservation initiatives implemented by FM&O (a budget
amendment is recommended to provide $606,500 for maintenance projects while
reducing utilities appropriations based on forecasted expenditures); fay. Sublet
Repairs $150,000 due to more efficient management of building maintenance
related items and fewer required major repairs and project work; fay. Indirect Costs
$144,400 due to determination of costs subsequent to budget formulation; fav.
Salaries $75,000 due to turnover; fay. Fringe Benefits $600,000 due to turnover and
higher than required fringe benefit appropriations (a budget amendment is
recommended to reduce Hospitalization by $275,000); fay. Road Salt $100,000 due
to reduced road salt usage as a result Of moderate weather conditions and
implementation of new guidelines to reduce the amount of salt applied per run; fay.
Garbage & Rubbish Disposal $50,090 due to reduced volume caused by recycling
efforts; fay. Overtime $50,000 due to moderate weather conditions for snowplowing
activity; and fay. Maintenance Supplies $25,000-and Laundry & Cleaning $7,500
based on required usage.
Favorability is partially offset by unfav. IT Operations ($75,000) due to one-time
software charges and Security Supplies ($70,000) due to increased security
requirements and use of account (with reduced usage of Maintenance Supplies).
$26.968,241.00 $24,712,841.00 $2,255,400.00
($637,511.00) ($726,042.00) $1,479,358.00 $2,205,400.00
$192,500.00 $192,500,00 $132,500.00 ($60,000.00)
- 74,400.00 74,400.00
(900,000.00) (941,610.00) (981,095.00) (39,485.00)
($1,475,151001 $705,163.00 $2,180,315.00
$12,500,240.61
$13,205,403.61
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
NON-OPERATING REVENUE
TRANSFERS IN
TRANSFERS OUT
NET REVENUES OVER(UNDER)
EXPENSES*
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
($1,345,011.00)
-31.17% - Unfav, due to lower than anticipated rate of return on investments.
- Transfers In from Project Work Order Fund for closed Maintence projects
- Transfers Out to Project Work Order Fund to close Maintenance projects.
ADOPTED
BUDGET
AMENDED
BUDGET
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
INTERNAL SERVICE FUND
FACILITIES MANAGEMENT
FY 2012 VARIANCE
FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
FACILITIES MAINTENANCE & OPERATIONS (#63100)
OPERATING REVENUES:
Outside Revenue $532,540.00
Inside Revenue 25,834,874.00
Total Revenue $26,367,414.00
OPERATING EXPENSES $27,004,925.00
*Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category.
FACILITIES INTERNAL FORE.xlsx 6/8/2012
OPERATING REVENUES:
Outside
Inside
$735,492.00 $735,492.00
25,697,543.00 25,697,543.00
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2012
BUDGET BUDGET FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCES — Information Technology - Operations (63600)
$905,792.00 $170,300.00 23.15% - Fay. Enhanced Access Fees $115,900 due to increased customer usage.; Sale of Equip
$11,000 & Deferred Land File Tax $59,000 due to increased tax & assessment billings
Partially offset by unfav. Reirnb Equalization Services ($15,600).
21,764,643.00 (3,932,900.00) -15.30% - Unfav. OG Dept.' & Non Gov Dev ($3,370,400) due to rates remaining at prior year
levels & limited resources available to complete development due to vacancies; OG
Deptl Ops & Non Gov Ops ($509,200) actuals slightly lower than budget, which includes
rate increase of 18% beginning 10/1/11. Also, Clemis Ops unfav ($60,800) due to
budget including alloc for non-standard software that inay not be needed. Partially offset
by Equip Rental $7,600.
TOTAL OPERATING REVENUE $26,433,035.00 $26,433,035.00 $22,670,435.00 ($3,762,600.00) -14.23%
OPERATING EXPENSES $29,796,760.00 $29,794,180.00 $26,232,280.00 $3,561,900.00 11.96% - Fay. Sal & FB $3,248,800 due to vac & fb rate adj; Deprec $1,113,900 fully deprec equip
not reflected in budget projection; Equip Maint $272,800 due to lower than anticipated
hardware maint costs: Indirect Cost $274,400; Software Matra $21,500, Mem Dues
03 $4,400, Copier $119,000 & Communications $167,400 due to lower than anticipated
costs; Service Bureau $75,000 due to phasing out of microfiche costs; Travel $19,500
due to decline in staff attending conferences; Supplies $120,900, Mileage $5,900 &
Internal Svc $56,200 based on actual usage. Partially offset by unfav. Prof Svcs
($1,038,100) implementing projects in 11 FY 11-12 Master Plan due to current
vacancies; Expend Equip ($803,000) due to equip replacement,Contracted Svcs
($78,500) due to increase in cost & Charge Card Fees ($16,400) for increase of credit
card charges.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS ($3,363,725.00) ($3,361,145.00) ($3,561,845.00) ($200,700.00)
NON-OPERATING REVENUE 290,500.00 290,500.00 128,200.00 (162,300 00) -55.87% 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 (ou r)- 00%
CAPITAL CONTRIBUTION 0.00 0.00%
NET REV OVER(UNDER) EXP" ($2,166,549.001 ($2,163,969.00). ($2,526,969.00) ($363 10211R
TOTAL NET ASSETS - BEGINNING 23,384,307.04
TOTAL NET ASSETS - ENDING $20,857,338.04
*Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category.
OPERATING REVENUES:
Outside
Inside
TOTAL OPERA fING REVENUE
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
RkERATING TRANSFERS
.1;4* NON OPERATING REVENUE
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2012
BUDGET BUDGET FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCES
Information Technology - Telephone Communications (67500)
$30,000.00 $30,000.00 $11,400.00 $ (18,600.00) -62.00% Unfav. Sale of Phone External due to reduction in landline charges do to the closing of
Golden Oaks.
2,814,000.00 2,814,000.00 .2,654,000.00 (160,000.0a -5.69% Unfav. Sale of Phone Internal due to reduction in telephone landline rates.
TOTAL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
$2,844,000.00 $2,844,000.00 $2,665,400.00 ($178,600.00) -6.28%
$3,458,152.00 $3,458,152.00 $3,358,852.00 $99,300.00 2.87% Fay. Sal & FB $92,900 due to vac & lb rate ad); Indirect Cost $59,100; Tower Charges
$6,300 due to decreased pager usage; Deprec $96,400, Soft Maint $30.000 & Equip
Maint $3,900 subsequent to budget Partially offset by unfav. Comm ($185,500). Voice
Mail ($2,000) & Internal Svcs ($1,800) due to actual usage.
($614,152.00) ($614,152.00) ($693,452.00) ($79,300.00)
30,000 00 30,000.00 29,400.00 (600.00) -2.00% Unfav. Interest Income due to lower cash balance than anticipated.
0.00%
0.00%
($664,052.00) ($79,900 00)
4,054,863 42
$3,390,811.42
TRANSFERS IN -
TRANSFERS (OUT)- -
NET REV OVER(UNDER) EXP" ($584,152.00) ($584,152.00)
Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" in the revenue category.
1,951,050.00 1,951,050.00 2,141,850.00 190,800 00 Inside
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
INTERNAL. SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2012
BUDGET BUDGET FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCES -- Information Technology - CLEMIS (53500)
OPERATING REVENUES:
Outside $4,048,047.00 $4,048,047,00 $3,811,947.00 ($236,100.00) -5.83% Unfav. CLEMIS Crash ($150,000) due to less than anticipated agencies participating in
Crash program; Rebilled ($34,100) due to connectivity costs & In-Car Terminals Bite= nal
($263,100) due to reduction in fleet of CLEMIS agencies. Partially offset by fay Non-
Oakland Access Fees $55,600 due to increase in FTE count for US Customs & Border
Patrol; Maintenance Contracts $152,000 Livescan maint atter warranty and Parts &
Access $3,500 for CLEMIS Tech support.
9.78% Fav In-Car Terminals Internal $30,300 due to Mobile Data participation count higher than
budget projection & Reimb General $160,500 based on actuals for CLEMIS staff
supporting Sheriff projects.
TOTAL OPERATING REVENUE $5,999,097.00 $5,999,097.00 $5,953,797.00 ($45,300.00) -0.76%
OPERATING EXPENSES $8,609,138.00 $8,609,138.00 $7,136,038.00 $1,473,100.00 17.11% Fav.Sal/FB $702,800 due to vac & fb rate ad); Prof Svcs $199,100 due to contractual
03 services funded through grants for Records Management System upgrade; Equip
Maintenance $90,000 due to less than anticipated cost of repairs; Software Maint
$200,000; Travel $2,200 due to reduced traveling to conferences; COMM $41,800 due to
actual connectivity costs less than anticipated; Printing $7,000 for reduced printing
costs; Internal Svcs $379,300 based on actual usuage. Offset by unfav. Bank Charges
($70,000) due to cost for paypal services for E-Commerce transactions; Indirect Cost
($53,000); Supplies ($21,200); Ad) Pr Yr Exp ($19,700) includes reclass of unallowable
grant expense.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS ($2,610,041.00) ($2,610,041.00) ($1,182,241.00) $1,427,800 00
NON-OPERATING REVENUE 15,000.00 15,000.00 18,200.00 3,200.00 21.33% Fay. primarily due to interest Income; higher cash balance than anticipated.
TRANSFERS IN 2,044,186.00 2,044,186.00 2,044,186.00 - 0.00%
TRANSFERS (OUT) 0.00%
CAPITAL CONTRIBUTION 187,500.00 287,500.00 287,500.00 0.00 0.00%
NET REV OVER(UNDER) EXP* ($363,355.00) ($263,355.00) $1,167,645.00 $1431,000.00
TOTAL NET ASSETS - BEGINNING 14,978,635.46
TOTAL NET ASSETS - ENDING $16,146,280.46
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.
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS I ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2012
BUDGET BUDGET FORECAST VARIANCE EXPLANATION OF SIGNIFICANT VARIANCES
_
Information Technolouy - Radio Communications (53600)
OPERATING REVENUES:
Outside $7,036,277.00 $7,036,277.00 $6,822,577.00 ($213,700.00) -3.04% Unfav. Outside Agency Revenue ($200,000) due to fewer non-emergency agencies than
anticipated & Antenna Site Mgt ($70,000). Partially offset by fay. Refund Pr 'Yr Exp
$56,300 reimbursement of AT&T connectivity costs to towers.
Inside 289,253.00 289,253.00 342,353.00 53,100.00 18.36% Fay. Parts Access $56,900 & Productive Labor $2,900 due to MDC repaiis for OC
Agencies. Partially offset by unfav. Leased Equipment ($6,700) due to lower than
anticipated non-public users of the new system.
TOTAL OPERATING REVENUE $7,325,530 00 $7,325,530.00 $7,164,930.00 ($160,600.00) -2.19%
OPERATING EXPENSES $8,878,110.00 $8,878,110.00 $8,290,510.00 $587,600.00 6.62% Fav. Sal & FB $182,500 due to vac & fb rate adj; Maint Contract $178,000 & lndiiect
Cost $42,300 subsequent to budget projection; Comm $150,000 due lo lower
rates;Travel $15,000 due to decline in out-of-state training; Prof Svcs $47,200 due to
actual costs lower than budget projection; Laundry $800 & Internal Svcs $158,000 based
ao on actual usage. Partially offset by unfav. Equip Maint ($12,400) due to higher than
anticipated maintenance cost of new system; Tower Charges ($70,000) tower rent tor
add! sites due to coverage enhancements; Expendable Equip ($23,200) due to Next
Generation 911 equip replacements; Ad) Prior Yr Exp ($2,300) and Supplies ($78,300)
based on usage.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS ($1,552,580.00) ($1,552,580.00) ($1,125,580 00) $427,000.00
NON-OPERATING REVENUE 150,000.00 150,000.00 122,600 00 (27,400.00) -18.27% Unfav. Interest Income due to lower cash balance than anticipated.
TRANSFERS IN 0.00%
TRANSFERS (OUT) (486,000.00) (486,000.00) (486,000.00) 0.00%
CAPITAL CONTRIBUTION 0.00%
NET REV OVER(UNDER) EXP" ($1,888,580.00) ($188858000) ($1,488,980.00) $399,600 00
TOTAL NET ASSETS - BEGINNING 57,188,242.41
TOTAL NET ASSETS - ENDING $55,699,262A1
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.
ADOPTED
BUDGET
AMENDED
BUDGET
FY 2012
FORECAST VARIANCE
Fire Records Management ( 53100)
OPERATING REVENUES:
Outside
TO FAL OPERATING REVENUES
OPERATING EXPENSES
$205,995.00
$205,995.00
$649,097.00
$205,995.00 $196,295.00
$205,995.00 $196,295.00
$649,097.00 $619,297.00
($9,700.00) -4.71%
($9,700.00) -4.71%
$29,800.00 4.59%
TRANSFERS IN
TRANSFERS (OUT)
NET REV OVER(UNDER) EXP*
430,185.00 430,185.00 430,185.00
($10,917.011 ($10,917.00) $9,683.00
0.00 0.00%
0.00%
$20,600.00
COUNTY OF OAKLAND
FY 2012 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
EXPLANATION OF SIGNIFICANT VARIANCES
Unfav. primarily due to actual Rebilled Charges lower than anticipated.
Fav. Sal &FB $19,900 due to fb rate ad); Communications $10,000 due to savings in
connectivity costs; Travel $6,300 due to decrease in staff traveling to off site
conferences; Equip Maint $5,000 due to lower than anticipated server maintenance
charges; Exp. Equip $10,000 extending useful life of equip. Offset by unfav. Indirect Cost
($15,100); Software Rental ($600) due to the timing of software license purchases for
new member agencies; Software Maint ($2.600) due to increase in maintenance costs
and Internal Svcs ($3,100) due to actual usage.
INT INCOME (LOSS) BEFORE
CitiERAFING TRANSFERS ($443,102.00) ($443,102.00) ($423,002.00) $20,100.00
NON OPERATING REVENUE 2,000.00 2.000.00 2,500.00 500.00 25.00% Fay. primarily due to Interest Income: higher cash balance than anticipated
TO1AL NET ASSETS - BEGINNING
TOTAL NET ASSETS - ENDING
Please note that in the Adopted Budget (line
473,173.58
$482,856.58
em book) this is budgeted as "Planned use of Fund Balance" in the revenue category and Budgeted Equity Adj in Expenses.
Oaldandico
MEMO • • NDUM
To: Lynn Sonkiss, Fiscal Services
, Tim Soave, Fiscal Services
Frorn,/..AL) Dan Stencil, Parks and Recreation
Cc: (v. Jeff Phelps
Melissa Prowse
Re: Contributions Report — Q1FY2012
Date: April 5, 2012
Please find attached the Q1FY2012 Contributions Report for Parks and Recreation. Total
contributions for this quarter were $1,512.
88
--'
Oakland County Parks and Recreation Commission
Contributions (Donations) - October 1, 2011 - December 31, 2011
SPG !Rotary Park Pedestrian Bridge Laura Moreau $ 100.00
SPG Rotary Park Pedestrian Bridge Angela Spicer $ 50.00
SPG !Rotary Park Pedestrian Bridge , Tammie Sanders $ 50.00
SPG Rotary Park Pedestrian Bridge Worley Smith 50.00
SPG Rotary Park Pedestrian Bridge Matt Strickland $ 150.00
SPG Rotary Park Pedestrian Bridge Springfield Township P&R $ 150.00
SPG Rotary Park Pedestrian Bridge Mike Donnellon $ 50.00
SPG Rotary Park Pedestrian Bridge Daniel Stencil $ 50,00 ,
Springfield Oaks Golf Course Total $ 650.00
INC Nature Center Donation Misc (Outreach, Tuning Your Tot CD) $ 62.00
INC Ellis Barn Festival Donation OC Farm Bureau $ 650.00 _
Independence Oaks Nature Center Total $ 712.00
ILYP Dog Park Programs Tuffy's Pet Foods _ $ 150.00 ,
Lyon Oaks Park Total $ 150.00
Grand Total $1,512.00
8C-1
2012 UNCOLLECTABLE HOME IMPROVEMENT LOANS
I I
COMMUNITY DEVELOPMENT BLOCK GRANT .
I
:ASE # !HOMEOWNER BAL DUE ADLJKC,J
2352!Virginia Rose . $ 6,344.00 1 417 E Madge, Hazel Park 48030
39761Cynthia Sykes: $ 9,900.00 2685 Wakefield, Berkley 48072 ,
5280 William Waltner $ 8,828.22 200 E Cambourne, Ferndale 48220
5460,Felix & Helen Maslowsky $ 13,700.00 2650 Greenfield, Berkley 48072 1
5771 Sandra D Frederick $ 19,215.00 64 Orchard, Hazel Park 48030
,
5832 Frederick G Allen $ 15,990.00 23385 Stauber, Hazel Park 48030 ,
5885 Carrie A Loner° $ 18,661.49 30241 Palmer, Madison Hts 48071
6006 Kevin & Shannon Eskew $ 14,040.06 23099 Tawas, Hazel Park 48030 : 6041 Eric & Yvonne Johnson $ 18,802.25 683 Barclay, Troy 48085
6094 Tina L McCrae $ 23,084.27 8973 Lakeview Dr, White Lake 48386
6257 Michael A DePlanche $ 10,082.60 4851 Allingham Dr, White Lake 48383 _.
6353 Deborah Caron $ 7,089.16 1858 Browning, Madison Hts 48071
6426 Creighton & Angelite Crenshaw $ 18,082.00 21033 Westview Ave, Ferndale 48220 : ,
6525 Ronald & Deborah Oesterling $ 7,905.00 2297 S Sashabaw Ln, Ortonville 48462 '
6618 Bernadine Bell $ 16,351.90 2565 Armada Dr, Auburn Hills 48326
6677 James & Laurena VandeWeerd $ 12,393.34 1356 Bertha St, Rfemdale 48220
' 6841, Michael & Thresa Christenson $ 6,870.00 [6914 Dandison Blvd, W Bloomfield 48324
6843 Betty Thornppson $ 35,920.00 ,246 E Chesterfield St, Ferndale 48220
6847 Sharol Snapp $ 26,182.00 177 Wabash Rd, Rochester Hills 48307
. ; ,
_
TOTAL ` $ 289,441.29 ,
i I-- ,
z ,
,
1TOTAL AMOUNT UNCOLLECTIBLE
Write off 10/11 to 5/12
'*Client has more than one loan
Total Write offs: 19
1 ,
,
1
'
90
2012 UNCOLLECTABLE HOME IMPROVEMENT LOANS
HOME INVESTMENT PARTNERSHIP ACT ACCOUNTS
' 1
CASE # HOMEOWNER 1 BAL DUE ADDRESS
2-HP-031Lawrence Shekoski 24,000.00 441 E Maxlow Ave, Hazel Park 48030
*8582 t Harlan & Angel Hill $ 12,505.00 ,2190 Mapledale, Ferndale 48220
9516 Petula Alexander $ 18,935.00 12740 Albany, Oak Park 48237 .
9797 Jagtar Singh & Prilam Kaur $ 14,940.00 23071 Ithaca, Oak Park 48237
10224 Cammie J Garrett $ 16,264.82 440 Bunny Run Blvd, Lake Orion 48362
9873 Diana Rowland I $ 6,107.00 470 Neptune Dr, Ortonville 48462
*10251 Harlan & Angel Hill $ 20,715.00 2190 Mapledale, Ferndale 48220
10064 Ralph R & Bonnie W Bekaert $ 10,452.74 132W Browning, Hazel Park 48030
10145 Alesia L Love , $ 16,175.00 '71 Village Ct, Ortonville 48462
10577 Timothy Lane $ 22,735.00 3549 Arida Ave, Rochester Hills 48309
i
, , , ,
TOTAL , •-• 163,429.56
TOTAL AMOUNT UNCOLLECTIBLE 452,870.85
Write off 10/11 to 5/12 '
*Client has more than one loan I
Total Wr offs: 10 1 ,
Grand total write offs: 29
91
Resolution #12179 July 18, 2012
Moved by Dwyer supported by Quarles the resolutions (with fiscal notes attached) on the amended
Consent Agenda be adopted (with accompanying reports being accepted).
AYES: Covey, Crawford, Dwyer, Gershenson, Gingell, Jackson, Long, Matis, McGillivray, Middleton,
Nash, Nuccio, Potts, Quarles, River, Runestad, Scott, Taub, VVeipert, Woodward, Zack, Bosnic. (22)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the amended
Consent Agenda were adopted (with accompanying reports being accepted).
HE -! O'I LUTON
CH1E: EPUTY COUNTY L'XFOUTIVE
ACTINCI PLIFISLANT TO MCI. #1-5 ffEIA (7)
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 July 18,
2012, 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 18th day of July, 2012.
R,La
Bill Bullard Jr., Oakland County