HomeMy WebLinkAboutResolutions - 2013.03.21 - 20740MISCELLANEOUS RESOLUTION #13064 March 21, 2013
BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON
IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2013 FIRST QUARTER
FINANCIAL FORECAST AND BUDGET AMENDMENTS
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
WHEREAS Public Act 621 of 1978, the Uniform Budgeting and Accounting Act for Local Units of
Government, provides for adjustments to the adopted budget; and
WHEREAS in accordance with Oakland County General Appropriations Act Section 22, which authorizes
budget amendments for variances between the budgeted revenue and actual revenue, and Section 23, which
authorizes budget amendments for variance between estimated revenue and projected expenditures,
amendments are required; and
WHEREAS the Fiscal Year (FY) 2013 First Quarter Financial Forecast Report has identified several
variances and budget amendments are recommended; and
WHEREAS a budget amendment totaling $280,000 is recommended to reallocate funds from the Circuit
Court General Jurisdiction's Defense Attorney Fees account to the Violation Probation Attorney Fees account to
more accurately reflect the budget with the actual expenses; and
WHEREAS a budget amendment totaling $50 ;000 is recommended to reallocate funds from the Circuit
Court General Jurisdiction's Civil Mediation Payments revenue account to the Judicial Administration's
Expendable Equipment expense account to allow funding to replace or repair broken, torn, unusable, unsafe
furniture and equipment; and
WHEREAS a budget amendment totaling $2,310 is recommended to reallocate funds from the MMHCGP
Grant Fund/Circuit Court General Jurisdiction Travel and Conference account to the Transportation account to
more accurately reflect the budget with the actual expenses; and
WHEREAS a budget amendment totaling $21.000 is recommended to reflect the District Court 52-3
Sobriety Court Treatment Grant which ended on September 30, 2012: and
WHEREAS a budget amendment in the amount of $80,000 is recommended to reappropriate designated
funds in assigned fund balance for HR Compensation Study; and
WHEREAS a budget amendment is required to transfer Animal Control Legacy Funds in the amount of
$30,500 to the General Fund to cover expenditures in various account line items; and
WHEREAS a budget amendment of 579,731 is recommended to reallocate revenue from County Exec
Compliance Purchasing to Management and Budget Purchasing in regards to the Auditing/Purchasing
Reorganization; and
WHEREAS Planning and Economic Development Services received donations at the end of FY 2012 and
in early FY 2013 in the amount of $134,131 for operating expenditures related to the InnoVention Conference
held on 10/4/12 and requests an amendment to accept these donations; and
WHEREAS Planning and Economic Development Services received a $5,002 contribution from Michigan
Economic Development Corporation for software support with Salesforce and requests an amendment to accept
this donation; and
WHEREAS the Economic Development & Community Affairs received a $24,000 contribution for
operating expenditures for the Business Roundtable and requests an amendment to accept this donation; and
WHEREAS the Economic Development Corporation (EDC) Board has approved the FY 2013 Special
Revenue Budget for the EDC in the amount of $30,500, a reduction of $18,000 from FY 2012; a budget
amendment is required to amend the FY 2013 Special Revenue budget; and
WHEREAS the Convention Facility Liquor Tax revenue line item be increased by $740,000 from
$2,900,000 to $3,640,000 for FY 2013, FY 2014 and FY 2015 to reflect anticipated receipts from the State of
Michigan of which $1,820000 (one-half) is already included in the FY 2013, FY 2014 and FY 2015 budget to be
used for Health Division Substance Abuse Programs; and
WHEREAS a budget amendment totaling $157,207 is recommended to reallocate funds from the County
Clerk Forfeiture of Bonds account to Photographs, Certified Copies, and County Clerk Register of Deeds Land
Transfer Tax Accounts to more accurately reflect the budget with actual revenues; and
WHEREAS a budget amendment totaling 52,000 is recommended for the County Clerk to reallocate
funds to more accurately reflect actual expenditures; and
WHEREAS a budget amendment of $186,711 is recommended to move the Info Tech Operations budget
from County Clerk Register of Deeds to the Automation Fund 21160; and
WHEREAS a budget amendment totaling S30,000 is recommended to reflect transition expense of
$15,000 for the Water Resources Commissioner and $15,000 for the County Clerk/Register of Deeds authorized
per M.R. 12319 and M.R. 12320; and
FINANCE COMMITTEE VOTE:
Motion carried unanimously on a roll call vote with Scott absent.
WHEREAS the Parks and Recreation Commission entered into a construction license agreement with
Enbridge Energy at their October 22, 2012 Commission meeting and received an unbudgeted compensation
package of $151,540 for use of park property and construction activity; and
WHEREAS Parks and Recreation Building Space Allocation rent in the amount of $35,721 for 2,558
square feet at the South Oakland Health Center was inadvertently omitted during the FY2013 budget process;
and
WHEREAS a budget amendment of $12,000 is recommended to correct the Parks and Recreation Fees
Day Use revenue account which was inadvertently budgeted to Entrance Fees Gen Admission at the Red Oaks
Nature Center; and
WHEREAS Parks & Recreation received donations totaling $1,572 for various programs; and
WHEREAS a budget amendment is recommended to transfer funding in the amount of $15,000 from the
Professional Services line item within the Health and Human Services Admin Division to the Training-Educational
Supplies line item within the Children's Village Division to cover costs associated with a research based staff
training being incorporated into residential programming; and
WHEREAS a budget amendment is recommended to recognize that the Health Division has received
additional funding from MDCH through the Comprehensive Planning, Budgeting, and Contracting (CPBC)
Agreement in the amount of $710,806 which is less than fifteen percent of the original agreement required to
accept each of the amendments via separate resolution. Funding in the amount of $40,000 relating to Tobacco
Retailer Inspections will be budgeted in the General Fund as the grantor is allowing the County to bill on a fixed
fee for service; and
WHEREAS the Department of Information Technology has requested a budget amendment to more
accurately reflect Professional Services budgets between divisions; and
WHEREAS the Prosecutor's Office includes Enhancement Funds revenue budget of $50,608 to reflect
use of forfeiture/enhancement funds that were previously posted to a liability account (deferred revenue) within
the General Fund; due to the implementation of GASB 63, the deferred revenue account can no longer be used
for this activity and these funds are to be accounted in separate restricted funds that will require a transfer to the
General Fund for use of the monies. The Enhancement Funds revenue line item will no longer be used to
recognize use of the restricted monies and requires the Enhancement Funds budget to be zeroed out; and
WHEREAS a budget amendment in the amount of $36,000 is recommended in the Prosecutor's Office to
reflect a decrease in Program Income revenue due to diminishing revenues in the Bad Check Program which is
offset by an increase in Federal and State Operating grants; and
WHEREAS the Sheriff's Office receipt of forfeiture/enhancement funds were previously posted to a
liability account (deferred revenue) within the General Fund; due to the implementation of GASB 63, the deferred
revenue account can no longer be used for this activity and these funds were moved to separate restricted funds
that will require a transfer to the General Fund for use of the monies. The Enhancement Funds revenue line item
will no longer be used to recognize use of the restricted monies and requires the Enhancement Funds budget to
be zeroed out. Transfers In from the various restricted funds in the amount of $126,993 is being recognized for
eligible forensic lab, dispatch, and training costs; and
WHEREAS a budget amendment is recommended to transfer Sheriff restricted funds to CLEMIS for
Forensic Lab Enhancements in the amount of $25,455; and
WHEREAS a budget amendment totaling $75 ;700 is recommended to transfer Sheriff restricted funds;
$62,700 for authentication, storage, processing and management of digital evidentiary assets and $13,000 for
DNA capability assessments; and
WHEREAS it is the policy of the Oakland County Board of Commissioners to permit the Sheriff's Office to
enter into contracts with townships, villages and cities for the purpose of providing Sheriff patrol services; and new
contract rates were approved with MR #12265 for the three (3) year period commencing January 1,2013, through
December 31, 2015; with preliminary contract rates calculated during the last budget process updated after the
budget was adopted to reflect lower fringe benefit rates; and
WHEREAS a budget amendment is recommended for the FY 2013 - FY 2015 budget to reflect the
addition of one new position created by MR #12264 and continued by MR #12310 to service the Charter
Township of Commerce but not yet reflected in the FY 2013 — 2015 budget for one (1) GFGP FTE Patrol
Investigator position, which increases contract revenue by $97,961 for FY 2013 and $130,608 for FY 2014 -2015;
and
WHEREAS a budget amendment is recommended for the FY 2013 - FY 2015 budget to reflect the rate
change impact and the creation of two new positions per MR #12305 by the Charter Township of Highland
contract creating one (1) GFGP FTE Patrol Investigator, and one (1) GFGP FTE Deputy II (No/fill) positions,
which increases contract revenue by $192,905 for FY 2013 and $257,202 for FY 2014— FY 2015;
WHEREAS a budget amendment is recommended for the FY 2013- FY 2015 budget for the creation and
addition of two new positions per MR #12334 by the Charter Township of Oxford contract creating one (1) GFGP
FTE Patrol Investigator, and one (1) GFGP FTE Deputy II (No/fill) positions, which increases contract revenue by
$192,905 for FY 2013 and $257,202 for FY 2014— FY 2015; and
FINANC E OTVIMITTED
r.)
WHEREAS a budget amendment is recommended for the FY 2013 - FY 2015 budget to reflect that
Springfield Township has requested that nine (9) Deputy II (No/Fill) status positions continued per MR #12317 be
converted to Deputy II (With/Fill) status which increases revenue from this contract by $197,874 and is reflected in
the overall Sheriff Special Deputies revenue.
NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year 2013
First Quarter Financial Report.
BE IT FURTHER RESOLVED that $80,000 be re-appropriated from assigned fund balance (10100-
9010101-383449) for HR Compensation Study as follows:
GENERAL FUND (#10100)
Revenues
9010101-196030-665882
Expenditures
1050102-183010-731458
Planned Use of Balance
Total Revenues
HR Admin — Professional Services
Total Expenditures
FY 2013
$80,000
$80,000
$80,000
$80,000
BE IT FURTHER RESOLVED that $50,000 be transferred in FY 2013 from General Fund Circuit Court
Civil Mediation Payments (10100-3010301-121150-240201) to Circuit Court Expendable equipment to support
furniture and equipment replacement as follows:
GENERAL FUND (#10100)
Revenues
3010101-121150-630245
Expenditures
3010101-121100-750154
Cir Crt Gen Jur — Civil Mediation Payments
Total Revenues
Cir Crt Jud Admin — Expendable Equipment
Total Expenditures
FY 2013
$50,000
$5p,000
$50,000
$50,000
BE IT FURTHER RESOLVED that the uncollectible debts, as recommended by the Department of
Management and Budget and detailed in the attached schedules are authorized to be written off.
BE IT FURTHER RESOLVED that the donations be recognized in the Economic Development &
Community Affairs and Parks and Recreation Department.
BE IT FURTHER RESOLVED that the FY 2013— FY 2015 Budgets are amended pursuant to Schedules
A and B.
Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution.
ITEM 17
L BROOKS PATTERSON, OAKLAND COUNTY EXECUTIVE 1A.MAND_
COUNTY MICHIGAN
DEPARTMENT OF MANAGEMENT AND BUDGET Laurie Van Pelt, Director
TO:
FROM:
SUBJECT:
DATE:
Members of the Finance Committee
Laurie Van Pelt, Director, Management and Budget
Tim Soave, Manager, Fiscal Services
Lynn Sonkiss, Chief, Fiscal Services
Gain Piir, Supervisor of Fiscal Services
Letter of Transmittal - Fiscal Year 2013 First Quarter Forecast
March 14, 2013
FY 2013 FIRST (WARIER REPORT
Attached please find the Fiscal Year (FY) 2013 First Quarter Forecast Report. In total, Fiscal Services forecasts that
the County will complete FY 2013 with an overall favorable variance of $12,410,788 in General Fund/General
Purpose (GFIGP) 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 ($597,172) less revenue than
anticipated and projected favorability in expenditures of $13,007,960.
REVENUES
GF/GP revenues are 0.14% less than budget or ($597,172). Major variances are the result of the following events:
A. STATE GRANTS — Unfavorable: ($1,994,000)
Reduced state funding is the result of reduced Child Care fund costs. The revenue loss is more than off y
projected reduced expenditures. Expenditures are favorable for Foster Boarding Homes, Private Institutions,
and Foster Care.
B. OTHER 1N1ERCiOVERNMENTAL REVENUE —Favorable: $725,700
Favorable revenue from the State for Convention Facility Liquor Tax revenue of $740,000; partially offset by
unfavorable Cigarette Tax Distribution ($14,000).
C. CHARGES FOR SERVICES — Favorable: $1,072,800
Primarily due to favorability in the County Clerk budget for Land Transfer Tax, Mortgages, Recording Fees,
and Certified Copies revenue line items,
D. INVESTMENT INCOME — Unfavorable: ($1,001,100)
Investment income is unfavorable due to lower investment rates.
E. INDIRECT COST RECOVERY - Unfavorable: ($200,000)
Unfavorable due to reduced activity related to construction projects, grants, and proprietary funds,
;F. OTHER REVENUTES $750,4.28
Primarily due to the repayment of the Remonumentation advance that was approved with MR#12336.
EXPENDITURES
In total, expenditures are projected to be 3.09% under budget or $13,007,960 favorable.
EXECUTIVE OFFICE BUILDING 41 WEST • 2100 PONTIAC LAKE RD DEPT 4)9 • WATERFORD MI 48329-0409 • (248)858-2163 • FAX (248) 858-9172
EMAIL: vanpeIll@oakgov.com
Many departments have experienced personnel savings as the result of the hiring freeze, turnover, and under-filling of
positions. As the year progresses this overall net favorability may increase as departments continue to work to reduce
their costs and reorganize.
There is one dem tijient projected to be unfavorable at the end of the fiscal year (barring any amendments); Sheriff's
Office.
A. Sheriff— Unfavorable: ($157,600)
• The department is forecasted to be unfavorable due to increased internal service charges; primarily charges
from the Motor Pool Fund as a result of the FY 2013 budget set lower than FY 2012 actual charges and higher
fuel costs.
Note that while individual divisions may be over budget, the budget is controlled at the department level. The General
Appropriations Act requires that appropriations accumulate at the following three summary levels of expenditures
within each County Department and are deemed maximum authorization for expenditures: Personnel Expenditures,
Operating Expenditures, and Internal Support Expenditures.
Required Reporting Adjustments
The Quarterly Forecast presents the County's financial position in relation to the amended budget (Budget perspective).
This form of presentation is used so that users of this forecast can assess the true financial impact of County operations
in comparison to the budget for the current fiscal year. However, it is important to note that this presentation style does
not fully coincide with the accounting requirements of audited financial statements produced by the County. The
County's financial statements are required to follow Generally Accepted Accounting Principles or GAAP.
Forecast Presentation — Budgetary Perspective
The presentation reflects the true fiscal activity of the County for FY 2013:
Revenues - over/ (under) budget
Expenditures — (over)/under budget
Total Officially Reported Favorability
$( 597,172)
13,007,960
$ 12 410.788
GAAP Required Reporting Method
Under GAAP, the Planned Use of Fund Balance is removed as a "revenue" source. The amended revenue budget
assumed the use of $39,742,665 in fund balance. Fund balance is budgeted, and if available can be used as a funding
source, however GAAP does not allow fund balance to be "recorded as revenue". This is because Fund Balance is the
residual of revenue and expenditures accumulated over the years, revenue cannot be recognized as income more than
once. Thus when Use of Fund Balance is removed from the revenue calculation, the impact on the County's official
financial statements is:
Revenue Variance
Reduce Planned use of Fund Balance
Revenue Variance
$ ( 597,172)
(39,742,665)
$( 40,339,837)
Expenditure Variance (Comparing Actual to Approved Plan) 13,007,960
GAAP Reported Effect on Fund Balance 3L-==)77
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 2013 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
2
as budgeting for full employment of all authorized positions, the non-2417 hiring freeze and the stringent scrutiny
applied to all requested expenditures, The Budget perspective shows that the County was favorable by $12.4 million
when comparing budget to actuals. 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 the General
Fund balance will decrease by $27.3 million by the end of Fiscal Year 2013. The use of Fund Balance is consistent
with information provided to the Finance Committee and the Board of Commissioners, as well as what is reflected in
the FY 2013-2015 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 2013. However, it should
be noted that this forecast projects the use of Fund Balance needed to support FY 2013 activities is $10.3 million Less
than originally planned.
3
SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2013 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2013 FY 2014 FY 2015 AMENDMENTS AMENDMENTS AMENDMENTS GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Dept Program Acct Fund Aft Op Unit Circuit Court Expenditures Account Name 3010301 121130 730450 Cir Crt Gen Jur - Defense Atty Fees $ (280,000.00) $ (280,000.00) $ (280,000,00) 3020301 121130 732080 Cir Crt Gen Jur - Violation Prob Ally Fees 280,000,00 280,000.00 280,000.00 Total Expenditures Public Services•Animal Control Revenue 1070801 114000 695500 Transfer In $ 30,500.00 Total Revenue $ 30,500.00 Expenditures 1070801 1070801 1070805 114000 114000 114090 731458 731818 750014 Professional Services Special Event Program Animal Supplies Total Expenditures $ 23,000.00 2,500.00 5,000.00 $ 30,500.00 County Exec Purchasing / Management and Budget Purchasing Revenue 1010210 182090 631743 CE Pur -Refunds Miscellaneous $ (79,731.00) 1020401 182090 631743 MB Pur -Refunds Miscellaneous 79,731.00 Total Expenditures 102 FY_2013_1st_Outte.r_Amendments.xlsx
SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2013 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2013 FY 2014 FY 2015 AMENDMENTS AMENDMENTS AMENDMENTS GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Economic Development Revenue 9010101 193030 665882 1090205 171125 632065 1090205 171125 631757 Planned Use of Balance Seminars/Conferences Registration Fees Total Revenue $ 100,000.00 16,233.00 17,898.00 $ 134,131.00 Expenditures 1090205 171125 732165 1090205 171125 730205 Workshops and Meetings Business Recruitment Total Expenditures $ 98,744.00 35,387.00 $ 134,131 00 Revenue 1090205 171030 631827 Expenditures 1090205 171030 731780 Reimb General Total Revenue Software Support Maintenance Total Expenditures 5,002.00 5,002.00 5,002.00 5,002.00 Revenue 1090101 171000 650301 Donations Total Revenue 24,000.00 $ 24,000.00 Expenditures 1090101 171000 731458 Professional Services 24,000.00 Total Expenditures $ 24,000.00 102 FY_2013_1st_ _Amendments xlsx
SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2013 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2013 FY 2014 FY 2015 AMENDMENTS AMENDMENTS AMENDMENTS 1GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Non-Departmental Revenue 9010101 196030 665882 Planned Use of Fund Balance $ (740,000.00) $ (740,000.00) $ (740,000.00) 9010101 196010 620302 Convention Facility Liquor Tax $ 740,000.00 $ 740,000.00 $ 740,000.00 Total Revenue - $ - $ County Clerk/Register of Deeds Revenue 2010201 125000 630798 County Clerk- Forfeiture of Bonds $ (157,207.00) 2010201 132300 631519 County Clerk-Photographs 10,000.00 2010201 125000 630210 County Clerk-Certified Copies 10,000.00 2010201 172190 631043 County Clerk ROD-Land Transfer Tax 137,207.00 Total Revenue Expenditures 2010201 2010401 2010101 125000 730772 County Clerk-Freight and Express 172190 731346 County Clerk ROD-Personal Mileage 180000 731346 County Clerk Admin-Personal Mileage Total Expenditures (2,000.00) 1,000.00 1,000.00 Revenue 9010101 196030 665882 Planned Use of Balance Total Revenue (186,711.00) $ (186,711.00) 2010401 172190 774636 County Clerk ROD-Info Tech Operations $ (186,711.00) Total Expenditures $ (186,711.00) 102 FY_2013_1st QuFfterAmendments.xlsx
SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2013 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2013 FY 2014 FY 2015 AMENDMENTS AMENDMENTS AMENDMENTS 173.OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) County Clerk/Register of Deeds I Water Resources Commissioner Expenditures 6010101 2010101 9010101 155010 180000 196030 731990 731990 730359 Expenditures 1060501 112090 750567 Transition Expense - Clerk Transition Expense - WRC Contingency Total Expenditures Professional Services Transfers Out Total Expenditures Child Care Subsidy Transfers In Total Revenue Training-Educational Supplies Total Expenditures 15,000.00 15,000.00 (30,000.00) $ (7,500.00) $ (7,500.00) $ (15,000.00) 7,500.00 $ (7,500.00) 7,500.00 7,500.00 $ 15,000.00 $ 15,000,00 $ 15,000.00 Expenditures 1060101 133000 731458 9010101 112700 788001 20293 CHILD CARE FUND (#20293) Revenue 9010101 112700 615359 9090101 112700 695500 10100 Human Services Admin / Children's Village/Child Care Fund GENERAL FUND (#10100) Revenue 9010101 196030 665882 20293 Planned Use of Balance Total Revenue ts.xlsx
SCHEDULE A OAKLAND COUNTY; MICHIGAN FISCAL YEAR 2013 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) Federal Operating Giants Planned Use of Balance Total Revenue Enhancement Funds Planned Use of Fund Balance Total Revenue Federal Operating Grants State Operating Grants Program Income Total Revenue Transfers In Transfers In Transfers In Enhancement Funds Enhancement Funds Enhancement Funds FY 2013 FY 2014 FY 2015 AMENDMENTS AMENDMENTS AMENDMENTS $ 40,000.00 $ (40,000.00) $ (50,608.00) $ 50,608.00 18,000.00 18,000.00 (36,000.00) $ 34,183.00 $ 34,289.00 $ 58,521.00 $ (2,500.00) $ (10,218.00) $ (271,280.00) IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Health Division GENERAL FUND (#10100) Revenue 1060220 134385 610313 9010101 196030 665882 Prosecuting Attorney's Office Revenue 4010101 122050 670285 9010101 196030 665882 Revenue 4010101 122050 610313 4010101 122050 615571 4010101 122050 631617 Sheriffs Office Revenue 4030901 116240 695500 21340 4030501 116230 695500 21396 4030301 112580 695500 21397 4030601 116210 670285 4030601 112580 670285 4030901 116240 670585 102 FY_ 2013 •nandments.xlsx
Revenue 4030101 116270 695500 21341 Transfer In Total Revenue Expenditures 4030101 116270 633430 53500 Transfer Out - to CLEMIS Total Expenditures Revenue 4030901 116240 695500 21340 Transfer In Total Revenue Expenditures 4030901 116240 750203 Forensic Lab Enhancement Total Expenditures Revenue 4030601 116180 632093 40699 Sheriff Special Deputies 9010101 196030 665882 Planned Use of Balance Total Revenue SCHEDULE A OAKLAND COUNTY. MICHIGAN FISCAL YEAR 2013 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND1GENERAL PURPOSE (GF/GP) FY 2013 FY 2014 FY 2015 AMENDMENTS AMENDMENTS AMENDMENTS GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) 4030901 116270 670285 4030901 110090 670285 9010101 196030 665882 Enhancement Funds Enhancement Funds Planned Use of Fund Balance Total Revenue 1,581.00 (21,326.00) 176,750.00 $ 25,455.00 $ 25,455.00 $ 25,455.00 25,455.00 $ 75,700.00 75,700.00 $ 75,700.00 75,700.00 (59,740.00) 589,124.00 1,276,710.00 543,511.00 55,888.00 (631,698.00) $ 483,771.00 $ 645,012.00 $ 645,012.00 102 FY ,L _ 'i.nriendrrients.xlsx
SCHEDULE A OAKLAND COUNTY. MICHIGAN FISCAL YEAR 2013 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2013 FY 2014 FY 2015 AMENDMENTS AMENDMENTS AMENDMENTS GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Expenditures - Commerce Township 40040 40040 40040 40040 40040 40040 40040 40040 40040 40040 40040 40040 40040 40040 40040 40040 40040 Total Expenditures 4030620 4030620 4030620 4030620 4030620 4030620 4030620 4030620 4030620 4030620 4030620 4030620 4030620 4030620 4030620 4030620 4030620 116180 116180 116180 116180 116180 116180 116180 116180 116180 116180 116180 116180 116180 116180 116180 116180 116180 702010 712020 722790 722770 722780 722760 722750 722810 722820 722800 722850 750070 750581 774677 776661 777560 773535 Salaries Overtime Social Security Retirement Hospitalization Group Life Workers Comp Disability Unemployment Dental Optical Deputy Supplies Uniforms Insurance Fund Leased Vehicles Radio Comm CLEMIS $ 44,274.00 7,528.00 3,387.00 16,356.00 10,480.00 138.00 549.00 624.00 164.00 572.00 83.00 292.00 354.00 695.00 8,280.00 4,056.00 129.00 $ 97,961.00 $ 59,032.00 10,037.00 4,516.00 21,807.00 13,973.00 183.00 732.00 832.00 218.00 762.00 110.00 389.00 472.00 926.00 11,040.00 5,408.00 171.00 $ 130,608.00 $ 59,032.00 10,037.00 4,516.00 21,807.00 13,973.00 183.00 732.00 832.00 218.00 762.00 110.00 389.00 472.00 926.00 11,040.00 5,408.00 171.00 $ 130,608.00 Expenditures - Highland Township 4030621 116180 702010 40060 4030621 116180 712020 40060 4030621 116180 722790 40060 4030621 116180 722770 40060 4030621 116180 722780 40060 4030621 116180 722760 40060 4030621 116180 722750 40060 4030621 116180 722810 40060 Salaries Overtime Social Security Retirement Hospitalization Group Life Workers Comp Disability 88,548.00 $ 12,045.00 6,774 00 32,710.00 20,960.00 275.00 1,098.00 1,249.00 118,064.00 $ 118,064.00 16,059.00 16,059.00 9,032.00 9,032.00 43,613.00 43,613.00 27,946.00 27,946.00 366.00 366.00 1,464.00 1,464.00 1,665.00 1,665.00 102 FY 2013 is i_Annendments.xlsx
Expenditures - Oxford Township 4030626 116180 702010 40140 4030626 116180 712020 40140 4030626 116180 722790 40140 4030626 116180 722770 40140 4030626 116180 722780 40140 4030626 4030626 4030626 4030626 4030626 4030626 116180 116180 116180 722760 40140 722750 40140 722810 40140 116180 722820 40140 116180 722800 40140 116180 722850 40140 4030626 4030626 4030626 4030626 4030626 4030626 116180 116180 116180 116180 116180 116180 750070 750581 774677 776661 777560 773535 40140 40140 40140 40140 40140 40140 SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2013 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2013 FY 2014 FY 2015 AMENDMENTS AMENDMENTS AMENDMENTS Unemployment Dental Optical Deputy Supplies Uniforms Insurance Fund Leased Vehicles Radio Comm CLEMIS Total Expenditures Salaries Overtime Social Security Retirement Hospitalization Group Life Workers Comp Disability Unemployment Dental Optical Deputy Supplies Uniforms Insurance Fund Leased Vehicles Radio Comm CLEMIS Total 328.00 437.00 437.00 1,143.00 1,524.00 1,524.00 165.00 220.00 220.00 584.00 778.00 778.00 708.00 944.00 944.00 1,389,00 1,852.00 1,852.00 16,560.00 22,080.00 22,080.00 8,112.00 10,816.00 10,816.00 257.00 342.00 342.00 192,905.00 $ 257,202.00 $ 257,202.00 88,548.00 $ 118,064.00 $ 118,064,00 12,045.00 16,059.00 16,059.00 6,774.00 9,032.00 9,032.00 32,710.00 43,613.00 43,613.00 20,960.00 27,946.00 27,946.00 275.00 366.00 366.00 1,098.00 1,464.00 1,464.00 1,249.00 1,665.00 1,665.00 328.00 437.00 437.00 1,143.00 1,524.00 1,524.00 165.00 220.00 220.00 584,00 778.00 778.00 708 00 944.00 944.00 1,389.00 1,852.00 1,852.00 16,560.00 22,080.00 22,080.00 8,112.00 10,816.00 10,816.00 257.00 342.00 342.00 192,905,00 $ 257,202.00 $ 257,202.00 IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) 4030621 116180 722820 40060 4030621 116180 722800 40060 4030621 116180 722850 40060 4030621 116180 750070 40060 4030621 116180 750581 40060 4030621 116180 774677 40060 4030621 116180 776661 40060 4030621 116180 777560 40060 4030621 116180 773535 40060 102 FY 2013 rnents.rix
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2013 AMENDMENTS FY 2014 FY 2015 AMENDMENTS AMENDMENTS 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aft °per Unit Account Name Circuit Court Michigan Mental Health Court Grant (MMHCGP) (#27175; GR #0000000423 Budget Ref 2013 Expenditures 3010301 121200 732018 3010301 121200 732011 Cir Crt Gen Jur - Travel & Conference Cir Crt Gen Jur - Transportation Service Total Expenditures (2,310.00) 2,310.00 District Court 52-3 Sobriety Court Treatment Grant Fund #27165 - GR0000000468 Bud Ref 2012 Revenue 3010405 121050 615571 State Operating Grants Total Revenue (21,000.00) $ (21,000.00) $ (21,000.00) $ (21,000.00) $ (21,000.00) (21,000.00) Expenditures 3010405 3010405 3010405 3010405 3010405 121050 121050 121050 121050 121050 730548 731346 731458 732018 750294 Public Services-Animal Control Legacy Fund (#21310) Revenue 9010101 114110 665882 21310 Expenditures 9010101 114110 788001 21310 Drug Testing Personal Mileage Professional Services Travel and Conference Material and Supplies Total Expenditures Planned Use of Balance Total Revenue Transfer Out Total Expenditures $ (4,320.00) $ (4,320.00) $ (4,320.00) (765.00) (765.00) (765.00) (12,560.00) (12,560.00) (12,560.00) (825.00) (825.00) (825.00) (2,530.00) (2,530.00) (2,510E1 (21,000.00) $ (21,000.00) $ (21,000.00) 30,500.00 30,500.00 30,500.00 30,500.00 71 7 102 FY_2013_1st_ _Amendments xlsx
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2013 AMENDMENTS FY 2014 FY 2015 AMENDMENTS AMENDMENTS ""IAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Economic Development Corporation Fund (#21180) Revenue 1090202 171110 630280 1090202 171110 630098 1090202 171110 632058 1090202 171110 632275 1090202 171110 655385 (14,700) (500) (500) (500) (1,800) (18,000) Expenditures 1090202 171110 1090202 171110 1090202 171110 1090202 171110 1090202 171110 1090202 171110 1090202 171110 1090202 171110 1090202 171110 730072 730709 731241 731388 731507 731818 732165 732018 750399 (2,500) (1,000) (1,000) (1,000) (2,000) (5,000) (2,000) (3,000) (500) (18,000) County Clerk/Register of Deeds Automation Fund (#21160; Revenues 2010401 172220 665882 Planned Use of Balance 186,711.00 Total Revenues 186,711.00 Expenditures 2010401 172220 774636 Info Tech Operation Total Expenditures 186,711.00 186,711.00 Parks & Recreation (#50800) Revenues 5060760 160070 632261 5060201 160900 665882 Temporary Licenses Planned Use of Balance Total RevenuoF 151,540.00 (151,540.00) 102 F .-!ndments.xlsx
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2013 AMENDMENTS FY 2014 FY 2015 AMENDMENTS AMENDMENTS 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Acct Fund Aff Oper Unit Account Name Revenues 5060201 160900 665882 Expenditures 5060805 160210 770631 Revenues 5060651 160050 630644 5060651 160050 630700 Planned Use of Balance Total Revenues Building Space Allocation Total Expenditures Entrance Fees Gen Admission Fees Day Use Total Revenues 35,721.00 35,721.00 35,721.00 35,721 00 (12,000.00) 12,000.00 HEALTH - CDC Imm Grants (#28549) GR0000000628 Revenues 1060201 133170 610313 Federal Operating Grants 10,000.00 Total Revenues 10,000 00 Expenditures 1060201 133170 702010 Salaries Regular 7,765.00 1060201 133170 722740 Fringe Benefits 354.00 1060201 133170 730926 Indirect Costs 1,091.00 1060201 133170 731388 Printing 540.00 1060201 133170 750399 Office Supplies 250.00 Total Expenditures 10,000.00 102 FY_2013_1st_01, _Amendments.xlsx
SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS ACCOUNT NUMBER FY 2013 AMENDMENTS FY 2014 FY 2015 AMENDMENTS AMENDMENTS 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name HEALTH - Communities Planning (#2832.0) GR0000000562 Revenues 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 133380 133380 133380 133380 133380 133380 133380 133380 133380 133380 133380 133380 133380 133380 133380 133380 133380 702010 722740 730555 730926 731346 731388 731458 732165 750462 750448 750294 750567 778675 774677 750245 770667 774636 Federal Operating Grants Total Revenues Salaries Regular Fringe Benefits Education Programs Indirect Costs Personal Mileage Printing Professional Services Workshops & Meetings Provisions Postage Materials & Supplies Educational Supplies Telephone Communications Liability Insurance Incentives Convenience Copier IT Operations Total Expenditures 47,000.00 47,000.00 14,819.00 677.00 1,100.00 2,082.00 616.00 6,717.00 4,470.00 800.00 2,000.00 2,112.00 5,980.00 1,165.00 112.00 300.00 3,250.00 100.00 700.00 47,000.00 1060233 133380 610313 Expenditures 102 FY 2013 dments.xlsx
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2013 AMENDMENTS FY 2014 FY 2015 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID l'ocruarri Acct Fund Aff()per Unit Account Name HEALTH - Communities Planning (#28320) GR0000000562 Revenues 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 133390 133390 133390 133390 133390 133390 133390 133390 133390 133390 133390 133390 133390 133390 133390 133390 133390 133390 133390 133390 133390 702010 722740 730072 730926 730982 731115 731346 731388 732018 732165 750245 750294 750448 750462 750399 750567 770631 770667 774636 774677 778675 Federal Operating Grants Total Revenues Salaries Regular Fringe Benefits Advertising Indirect Costs Interpreter Fees License & Permits Personal Mileage Printing Travel and Conference Workshops & Meetings Incentives Materials & Supplies Postage Provisions Office Supplies Training-Educational Supplies Contracted Services Convenience Copier Info Tech Operations Insurance Fund Telephone Communications Total Expenditures 105,063.00 105,063.00 21,170.00 967.00 8,600.00 2,974.00 1,995.00 200.00 138.00 3,251.00 3,500.00 310.00 1,760.00 13,153.00 300.00 3,000.00 4,071.00 13,225.00 16,854.00 200.00 6,519.00 300.00 2,576.00 105,063.00 1060233 133390 610313 Expenditures 102 FY_2013_1st_ _Amendments xisx
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2013 AMENDMENTS FY 2014 FY 2015 AMENDMENTS AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 1060294 1060294 1060294 1060294 1060294 1060294 1060294 1060294 1060294 1060294 1060294 1060294 1060294 1060294 1060294 1060294 1060294 1060294 133940 133940 133940 133940 133940 133940 133940 133940 133940 133940 133940 133940 133940 133940 133940 133940 133940 133940 702010 722740 730072 730926 730982 731346 731388 731997 732018 750280 750301 750392 750399 770631 770667 774636 774677 778675 Federal Operating Grants Total Revenues Salaries Regular Fringe Benefits Advertising Indirect Costs Interpreter Fees Personal Mileage Printing Transportation of Clients Travel and Conference Laboratory Supplies Medical Supplies Metered Postage Office Supplies Bldg Space Cost Allocation Convenience Copier Info Tech Operations Insurance Fund Telephone Communications Total Expenditures 373,425.00 373,425.00 206,952.00 111,311.00 2,272.00 28,315.00 300.00 2,098.00 525.00 75.00 225.00 400.00 1,500.00 150.00 150.00 6,420.00 100.00 8,400.00 1,084.00 3,148.00 373,425.00 HEALTH - Aids Counseling (#28557) GR0000000194 Revenues 1060294 133940 610313 Expenditures 102 FY_2013_1s: ._Amendments.xlsx
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2013 AMENDMENTS FY 2014 FY 2015 AMENDMENTS AMENDMENTS 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID jgraiij Acct IFund Aff per Unit Account Name HEALTH - PHEP (#28610) GR0000000611 Revenues 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 115010 115010 115010 115010 115010 115010 115010 115010 115010 115010 115010 115010 115010 702010 722740 730072 730926 730646 731346 731388 750077 750392 750399 750567 774677 778675 Federal Operating Grants Total Revenues Salaries Regular Fringe Benefits Advertising Indirect Costs Equipment Maintenance Personal Mileage Printing Disaster Supplies Metered Postage Office Supplies Training-Educational Supplies Insurance Fund Telephone Communications Total Expenditures 64,070.00 64,070.00 13,510.00 16,915.00 3,750.00 (60.00) 2,250.00 1,249.00 1,125.00 20,116.00 169.00 572.00 1,500.00 7.00 2,967.00 64,070.00 1060290 115010 610313 Expenditures 102 FY_2013_1st_r. _Amendments xlsx
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2013 AMENDMENTS FY 2014 FY 2015 AMENDMENTS AMENDMENTS 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name HEALTH - PHEP (#28610) GR0000000611 Revenues 1060290 115035 610313 Federal Operating Grants 71,248.00 Total Revenues 71,248.00 Expenditures 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 115035 115035 115035 115035 115035 115035 115035 115035 115035 115035 115035 115035 702010 722740 730926 731346 731388 732018 750077 750392 750399 750567 770631 774677 Salaries Regular Fringe Benefits Indirect Costs Personal Mileage Printing Travel & Conference Disaster Supplies Metered Postage Office Supplies Training-Educational Supplies Bldg Space Cost Allocation Insurance Fund Total Expenditures 18,508.00 10,690.00 1,147.00 2.00 750.00 1,509.00 31,813.00 750.00 4,500.00 1,575.00 2.00 2.00 71,248.00 Information Technology (#63620) 1080101 152000 731458 1080201 152010 731458 1080601 152090 731458 Professional Services Professional Services Professional Services Total Expenditures (58,105.00) 321,819.00 (263,714.00) 102 FY 2013lendrrients.xl x
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2013 AMENDMENTS FY 2014 FY 2015 AMENDMENTS AMENDMENTS 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff per Unit Account Name Sheriff - LAW ENFORCEMENT ENHANCE LAB FEES (#21340) Revenue 4030901 116240 6651382 Planned Use of Fund Balance Total Revenue 34,183 00 34,183.00 Expenditures 4030901 116240 788001 10100 Sheriff - SHERIFF TRAINING (#21396) Revenue 4030501 116230 665882 Expenditures 4030501 116230 788001 10100 Transfer Out - to Sheriff Total Expenditures Planned Use of Fund Balance Total Revenue Transfer Out - to Sheriff Total Expenditures 34,183.00 34,183.00 34,289.00 34,289.00 34,289.00 34,289.00 Sheriff - SHERIFF BOOKING FEE TRAIN (#21397) Revenue 4030301 112580 665882 Expenditures 4030301 112580 788001 10100 Planned Use of Fund Balance Total Revenue Transfer Out - to Sheriff Total Expenditures 58,521.00 58,521.00 58,521.00 58,521 00 ,7 -- 102 FY_2013_1st -_Amendments.xlsx
SCHEDULE B ACCOUNT NUMBER Expenditures 4030101 116270 633430 10100 CLEMIS (#53500) Revenue 1080301 116020 695500 10100 Expenditures 1080305 115060 771773 Expenditures 4030101 112580 788001 10100 OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2012 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SIPECIAL REVENUE FUNDS FY 2013 FY 2014 FY 2015 AMENDMENTS AMENDMENTS AMENDMENTS 25,455.00 25,455.00 Transfer Out - to Sheriff 25,455.00 Total Expenditures 25,455.00 Transfers In 25,455.00 25,455.00 Software 25,455.00 Transfer Out - to Sheriff 75,700.00 Total Expenditues 75,700.00 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Sheriff - LAW ENFORCEMENT ENHANCE (#21341) Revenue 4030101 116270 665882 Planned Use of Balance Total Revenue Total Expenditures 25,455.00 Sheriff - LAW ENFORCEMENT ENHANCE LAB FEES (#21340) Revenue 4030101 112580 665882 Planned Use of Fund Balance 75,700.00 Total Revenue 75,700.00 102 FY 201 31st_C _Amendments xlsx
COUNTY OF OAKLAND
FY 2013 FIRST QUARTER FORECAST
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
FY 2013 BUDGET AMOUNT
ADOPTED AS FY 2013 FAVORABLE/
BUDGET AMENDED FORECAST (UNFAVORABLE) PERCENT
REVENUES
GENERAL FUND
Taxes
Federal Grants
State Grants
Other Intergovernmental Revenue
Charges for Services
Indirect Cost Recovery
Investment Income
Other Revenues
$ 196,508,241.00
595,650.00
19,012,519.00
10,764,295.00
100,580,715.00
7,900,000.00
2,849,000.00
42,823,244.00
$ 196,508,241.00
595,650.00
19,019,679.00
10,764,295.00
100,731,109.00
7,900,000.00
2,849,000.00
42,851,588.00
$ 381,219.562.00
$ 196,539,241.00
613,650.00
17,025,679.00
11,489,995.00
101,803,909.00
7,700,000.00
1,847,900.00
43,602.016.00
$ 380,622,390.00
31,000.00
18,000.00
(1,994,000.00)
725,700.00
1,072,800.00
(200,000.00)
(1,001,100.00)
750,428.00
(597,172.00) -0.16% SUB-TOTAL GENERAL FUND/GENERAL PURPOSE $ 381.0 3,664.00
0.02%
3.02%
-10.48%
6.74%
1.07%
-2.53%
-35.14%
1.75%
PLANNED USE OF FUND BALANCE 37,621,540.00 S 39,742.665.34 $ 39,742,665.34 0.00%
TOTAL GF/GP FUNDS 418.655.204.00 $ 420,962.227.34 5 420.365,055.34 $ (597,172.00) -0.14%
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court
52nd District Court
Probate Court
TOTAL ADMIN. OF JUSTICE
LAW ENFORCEMENT
Prosecuting Attorney
Sheriff
19,170,797.00
137,852,544.00
19,372.809.07
139,098,840.26
47,790,897.00
16,388.089.00
5,795,490.00
69,974,476.00
18,694,409.07
139,256,440.26
3.592,000.00
434,000.00
167,000.00
$ 4,193,000.00
678,400.00
(157,600.00)
51,069,895.00 $ 51,382,897.00
16,704,458.00 16,822,089.00
5,952,855.00 5,962,490.00
$ 73,727,208.00 $ 74,167,476.00
6.99%
2.58%
2.80%
5.65%
3.50%
-0.11%
TOTAL LAW ENFORCEMENT $ 157,023,341.00 $ 158,471,649.33 $ 157,958,849.33 520,800.00 0.33%
GENERAL GOVERNMENT
Clerk/Register of Deeds
Treasurer
Board of Commissioners
Library Board
Water Resources Commissioner
11,065,784.00
8,415,531.00
2,842,277.00
1,413,328.00
5,124,599.00
10,652,706.00
8,529.674.00
2,882,310.00
1,417,060.00
5,217,826.00
10,054,606.00
8,187,474.00
2,840,810.00
1,372,300.00
5,217,826.00
598,100.00
342,200.00
41,500.00
44,760.00
5.61%
4.01%
1.44%
3.16%
0.00%
TOTAL GENERAL GOVERNMENT $ 28,861,519.00 $ 28,699,576.00 $ 27,673,016.00 $ 1,026,560.00
3.58%
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
$ 5,764,229.00
20,605,499.00
2,551,330.00
1,215,276.00
3,946,184.00
64,180,829.00
16,279,103.00
7,131,296.00
$ 6,846,194.00
19,530,557.00
2,574,552.50
1,215,780.00
3,961,548.00
64,424,410.02
16,431,039.49
7,364,141.00
$ 6,846,194.00 $
18,575,557.00
2,519,152.50
1,204,280.00
3,845.548.00
60,649,410.02
16,291,039.49
7,010,741.00
955,000.00
55,400.00
11,500.00
116,000.00
3.775,000.00
140,000.00
353,400.00
0.00%
4.89%
2.15%
0.95%
2.93%
5.86%
0.85%
4.80%
4.42%
2.91%
$ 121,673,746.00 $ 122,348,222.01 $ 116,941,922.01 $ 5,406,300.00
$ 381,285,814.00 $ 383,686,923.34 $ 372,540.263.34 S 11,146,660.00
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NON-DEPARTMENTALS $ 37,369.390.00 37,275,304.00 35,414.004.00 $ 1.861,300.00 4.99%
TOTAL GOVERNMENTAL EXPENDITURES $ 418,655,204.00 5 420,962,227.34 $ 407.954,267.34 5 13.007,96000 3.09%
General Fund/General Purpose
Favorable/(Unfavorable) - Budget Perspective 12,410,788.00 12,410,788.00
GAAP Required Adjustment (eliminating use of fund balance "revenue") $ (39,742,665.34) $ (39,742,665.34)
GAAP - BASED REPORT (forecasted impact on Fund Balance) ($27,331,877.34) ($27,331,877.34)
25
COUNTY OF OAKLAND GENERAL FUND 1 GENERAL PURPOSE REVENUES FY 2013 FIRST QUARTER REPORT Amount Adopted Amended FY 2013 Favorable Budget Budget Forecast (unfavorable) Percent Explanation of Significant Variances TAXES (601000-601999) Property Taxes - July Tax Levy 196,245,741.00 $ 196,245,741 00 $ 196,245,741.00 $ 0.00% Other Taxes - Delinquent Tax - Prior Years 98,500.00 98,500.00 98,500 00 0.00% 18,000.00 18,000.00 Treasurer Payment in Lieu of Taxes Other Taxes - Trailer Tax Total Taxes FEDERAL GRANTS (610000-610999) Sheriff - Patrol Sheriff - Corrective Services Sheriff - Invesigative/Forens c Services Prosecuting Attorney Homeland Security - Disaster Control Health Division Children's Village Total Federal Grants STATE GRANTS (615000-615999) Sheriff - Patrol State Match Foster Care Prosecuting Attorney 76,000.00 88,000.00 196,508,241.00 $ - $ 82,000.00 71,412.00 67,500.00 53,010.00 21,728.00 300,000.00 595,650.00 $ - $ 1,000.00 67,500.00 76,000.00 88,000.00 196,508,241.00 $ 82,000.00 71,412.00 67,500.00 53,010.00 21,728.00 300,000.00 595,650.00 $ 2,160.00 S 1,000.00 67,500.00 107,000.00 88,000.00 196,539,241.00 $ - $ 82,000 00 71,412.00 85,500.00 2,160.00 $ 1,000.00 85,500.00 40.79% Fay. Receipt of Payment in excess of budget. 0.00% 0.02% 0.00% 0.00% 0.00% 26.67% Fay, for legal assistance provided to DHS. Offset by unfav. charges for services revenue budget. A budget amendment is recommended. 0.00% 0.00% 26.67% Fav. for legal assistance provided to DHS. Offset by unfav. charges for services revenue budget. A budget amendment is recommended. 31,000.00 31,000.00 53,010.00 0.00% 21,728.00 0.00% 300,000.00 0.00% 613,650.00 $ 18,000.00 3.02% Economic Development Health Division Non-Departmental - Child Care Subsidy 4,375,486.00 14,568,533.00 4,380,486.00 14,568,533.00 4,380,486.00 12,556,533.00 (2,012,000.00) 0.00% 0.00% -13.81% Built into the Circuit Court Family Division, Human Services Administration and Children's Village budgets are Child Care Fund expenditures. A favorable variance within these expense areas reduces the 50% reimbursement the county receives. Unfav, revenue variance is offset by Child Care Fund expenditure favorability. Total State Grants 19,012,519.00 $ 19,019.679.00 $ 17,025,679.00 $ (1,994,000.00) -10.48% * Revenue variance is 1 of 8 3/7/2013
COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2013 FIRST QUARTER REPORT Amount Adopted Amended FY 2013 Favorable Budget Budget Forecast (unfavorable) Percent Explanation of Significant Variances OTHER INTER-GOVERNMENTAL REVENUES (620000 - 626999) Non-Departmental 8,477,000.00 $ 8,477,000 00 $ 9,203,000.00 $ 726,000.00 8.56% Fav $740,000 for convention facility liquor tax revenue; a budget amendment is recommended. This is partially offset by unfav Cigarette Tax Distribution ($14,000). HHS - Homeland Security 54,000.00 54,000.00 54,000.00 0.00% Circuit Court 4,500.00 4,500.00 4,500.00 0.00% District Court 2,300.00 2,300.00 2,000.00 (300.00) -13.04% Unfav. Drug Case Management due to a decrease in drug case filings 300,000.00 300,000.00 300,000.00 1,926,495.00 1,926,495.00 1,926,495.00 - $ 10,764,295.00 $ 10,764,295.00 $ 11,489,995.00 $ 725,700.00 CHARGES FOR SERVICES (630000-635999) Administration of Justice Circuit Court - Civil/Criminal 2,967,000.00 $ Sheriff Non-Departmental - Reimb Judges Salaries Total Other Intergovernmental Revenue Circuit Court - Family Division District Court - Division I (Novi) District Court - Division II (Clarkston) District Court - Division III (Rochester Hills) District Court - Division IV (Troy) Probate Court - Estates and Mental Health Total Administration of Justice 0.00% 0.00% 6.74% -3.03% Unfav. due to a reduction in the collection of Court costs. 0.00% 0.00% -4.53% Unfav. Ordinance Fines and Costs ($40,000), Probation Fees ($30,000) and Refund Fees PD Def Attorney ($10,000) due to a decline in caseload and a decrease in the public's ability to pay. 2,967,000.00 $ 2,877,000.00 $ (90,000.00) 2,032,500.00 2,032,500.00 2,032,500.00 4,435,600.00 4,435,600.00 4,435,600.00 1,767,700.00 1,767,700.00 1,687,700.00 (80,000 00) 3,830,000.00 3,830,000.00 3,900,000.00 70.000.00 1.83% Fav. Probation Fees $50,000 due to new collection initiatives, Garnishment Fees $13,000 as a result of the public filing more State tax garnishments to collect judgments and CVR County Portion $7,000 as a result of new legislation. 2,240,100.00 2,240,100 00 2,248,100.00 8,000.00 0.36% Fav. Late Penalty $5,000 and Show Cause Fee $3,000 due to the implementation of the new Judicial Information System (MS) case management system. 520,300 00 520,300.00 520,300.00 0.00% 17,793,200.00 $ 17,793,200 00 $ 17,701,200.00 $ (92,000 00) -0.52% * Revenue variance is partially offset by an expenditure variance. 27 2 of 8 3/7/2013
COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2013 FIRST QUARTER REPORT Amount Adopted Amended FY 2013 Favorable Budget Budget Forecast (unfavorable) Percent Explanation of Significant Variances Law Enforcement Prosecuting Attorney Sheriffs Office Sheriff - Administrative Services Sheriff - Corrective Services Sheriff - Corrective Services Satellites Sheriff - Emergency Response and Prepared. Sheriff - Patrol Services Sheriff - Investigative Forensic Services Total Law Enforcement -10.74% The Prosecutor's Office has discontinued participating in the Bad Check Restitution Program ($46,900). Proceeds received are as a result of open cases prior to terminating the relationship with vendor. Revenues here are dependent upon the number of NSF checks referred to this program by merchants. There has been a downward trend over the past 3 years. Forensic Lab Fees revenues ($2,100) are discontinued due to changes in the law; the fee assessments are no longer provided to the Prosecutor's Office. Offset by fav Federal and State revenue. A budget amendment is recommended. 700.00 0.36% Receipt of miscellaneous revenues. 47,600.00 10.15% Favorable due to increased receipts for Fee Income of $14,000; Fingerprints receipts of $14,000; Photostats of $30,000; partially offset by projected lower Recovered Indigent Monies of ($10,400) 0.00% 0.00% -24.37% Unfav. Civil Action Service Fees due to declining number of foreclosures and request for civil services. See corresponding reduction in Fees Civil Service expense, representing vendor cost to serve notices. -0.12% Unfav. Sheriff Special Deputies line item ($75,600) due to updated patrol contracts/rates approved in December 2012 (preliminary contract rates calculated during the last budget process were adjusted after budget was adopted to reflect lower fringe benefit rates). Offset by fav, amount of $22,700 to reflect pending City of Pontiac patrol contract amendment adding one Patrol Investigator position. A budget amendment is recommended. 456,300.00 $ 456,300 00 $ 407,300.00 8 (49,000.00) 196,900.00 196.900.00 197,600.00 469,100.00 469,100.00 516,700.00 2,868,266.00 2,996,892.00 2,996,892.00 481,368.00 481,368.00 481,368.00 2,425,011.00 2,425,011.00 1,834,011.00 (591,000.00) 44,366,995.00 44,388.763.00 44,335,863.00 (52,900 00) 783,391.00 783,391 00 799,891 00 16,500.00 2.11% Fav due to projected Reimbursement of Salaries revenue. 52,047,331.00 $ 52,197,725.00 $ 51,569,625.00 $ (628,100 00) -1.20% * Revenue variance is partially offset by an expenditure variance. 28 3 of 8 3/7/2013
COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2013 FIRST QUARTER REPORT Amount Adopted Amended FY 2013 Favorable Budget Budget Forecast (unfavorable) Percent Explanation of Significant Variances General Government Clerk - County Clerk Clerk - Elections Clerk - Register of Deeds & Micrographics Treasurer Board of Commissioners 9.09% Fav. Certified Copies$ 425,600, CVR County Portion $8,800, Garnishment Fees $71,200, Gun Permits $7,700, Jury Fees $17.700, Marriage Licenses $7,100, Passport Fees $6,200 and Photographs $37,100 due to increased activity. Partially offset by Unfav. Assumed Names ($6,800), Bond Fees ($42,400), Miscellaneous ($17,200), Notary Commission ($12,100) and Photostats ($77,120) due to decreased activity. Also, unfavorable, Forefeiture of Bonds ($157,200) which is dependent on the timing to file motions to collect. 1.70% Fav. Election Filing Fees Late $5,800 due to Corporation Counsel's efforts to collect on late filers. Partially offset by unfav. Photostats ($2,800) due to less activity. 24.09% Fay. Land Transfer Tax $1,000.000, Mortgages $700,000, Recording Fees $250,000 due to increased activity. Also, Fav. Reimb. General $7,800 for Monument Repair by OC Road Commission. Partially offset by unfav. Chattel Mortgages ($11,300), Fed Tax Liens Cert of Release ($20,000), Miscellaneous ($13,900) and Remonumentation Fee ($4,200) due decreased activity. -7.51% Unfav. Delinquent Per Prop Tax Admin ($27,400) due to less activity. Also, unfav., Industrial Facilities Tax ($258,000), TIFA/DDA Recovery Ad Valorem ($215,000) and TIFA/DDA Recovery IFT ($52,000) due to decreasing taxable values and Miscellaneous ($73,300) due to less anticipated use. Partially offset by favorable, Foreclosure Notification Fee $65,000, Recording Fee Forfeiture Certifications$45,000, Recording Fee Redemption Certification $45,000 due to increased activity. Also, favorable Tax Reverted Land Co Portion $44,600. 0.00% 2,730,493.00 S 2,730,493.00 $ 2,978,793.00 $ 248,300.00 176,200.00 176,200 00 179,200.00 3,000.00 7,900,200.00 7,900,200.00 9,803,200.00 1,903,000.00 5,657.918.00 5,657,918 00 5,233,018 00 (424,900.00) 600.00 600.00 600.00 * Revenue variance is partially offset by an expenditure variance. 4 of 8 3/7/2013
COUNTY OF OAKLAND GENERAL FUND I GENERAL PURPOSE REVENUES FY 2013 FIRST QUARTER REPORT Amended Budget 25,000.00 3,021,904.00 2,912,496.00 230,000.00 21,000.00 189,000.00 917,895.00 282,256.00 11,957,619.00 $ 210,833.00 $ 19,167.00 3,233,968.00 500,000.00 418,300.00 1,400,154.00 800.00 Library Board Water Resources Commissioner Total General Government County Executive County Exec - Auditing County Exec - Purchasing M&B - Purchasing Division M&B - Equalization Division M&B - Fiscal Services Division Central Services - Support Services Human Resources HHS - Administration HHS - Health Division HHS - Children's Village HHS - Homeland Security Public Services - Community Corrections Public Services - MSU Extension Public Services - Medical Examiner Public Services - Animal Control Public Services - Circuit Court Probation Economic Dev. & Comm. Affairs - Admin Economic Dev. & Comm. Affairs - PEDS Total County Executive Adopted Budget 25,000.00 1,400,154.00 17,890,565 00 $ 230,000.00 3,233,968.00 500,000.00 418,300.00 800.00 3,021,904.00 2,912,496.00 230,000,00 21,000.00 189,000.00 917,895.00 282,256.00 11,957,619.00 $ FY 2013 Forecast 67,600.00 1,400,154.00 800.00 3,071,904.00 2.912,496.00 230,000.00 21.000.00 189,000 00 917,895.00 282,256.00 11,978,519.00 $ Amount Favorable (unfavorable) Percent Explanation of Significant Variances 42,600.00 170.40% Fay. Reimb. Salaries $49,000 due to unanticipated receipt of state aid to public libraries. Partially offset by unfav Copier Machine Charges ($3,400) and Misc ($3,000) due to increased on-line functionalities of downloading and e-mailing documents. 0.00% 0.00% 0.00% 50,000 00 1.65% Fav. Clinic Charges $75,000; On Site Sewerage Permits $50,000; and Wells $50,000 due to increased demand. Partially offset by unfav Flu Vaccine Fees $50,000 and Flu 3rd Party $25,000 due to changing environment of vaccine distribution. Unfav. Hepatitis Vaccine $40,000 due to reduced demand. Unfav. Education Fees $10,000 due to training courses for food manager certifications not up for renewal. Renewal for food manager certifications generally occurs every three years. 20,900 00 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.17% 17,890,565.00 $ 19,662,565.00 $ 1,772,000.00 9.90% 700.00 $ 210,833.00 $ 19,167.00 3,233,968.00 500,000.00 388,500.00 700.00 (29,800.00) 100.00% Fav Salary Reimbursements. 0.00% 0.00% 0.00% 0.00% -7.12% Unfav. Standard Mail ($31,000), Printing ($1,500) due to revenue less than expected, offset by fav. Metered Postage $3,000. Also, offset by lay. operating expenditures. * Revenue variance is partially Offset hy an expenditure varinc..;,?. 5 of 8 3/7/2013
892,000.00 $ 892,000.00 $ 892,000.00 892,000.00 $ 892,000.00 892,000.00 $ $ 100,580,715.00 $ 100,731,109.00 $ 101,803,909.00 $ COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2013 FIRST QUARTER REPORT Adopted Budget Amended Budget FY 2013 Forecast Amount Favorable (unfavorable Percent Explanation of Significant Variances Non-Departmental Non-Dept - Charges for Services Total Non-Departmental Total Charges for Services INDIRECT COST RECOVERY (640100) INVESTMENT INCOME (655000-655999) District Courts (Div. I - IV) Sheriff Corrective Services Sheriff Investigative/Technical Services Treasurer 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 0.00% 0.00% 1,072,800.00 1.07% 7,700,000.00 $ (200,000.00) -233% Unfav. due to lower than expected activity relating to construction projects, grants and proprietary funds. (1,100.00) -31.43% Unfav. due to income investment base and market rate adjustments. 0.00% 0.00% 0.00% (48,100.00) -95.04% Unfav. for the removal of the Enhancements Funds revenue line item; in previous years this budget reflected forfeiture funds transferred to the General Fund to meet NET Grant match obligation. The grant match is now met from other sources within the PA's GE budget. Offset by fay. $2,500 for donations received Oct-Dec from PA personnel who voluntarily accepted the 4% pay reduction tasked to all elected officials. A budget amendment is recommended. 0.00% 0.00% 7,900,000.00 $ 7,900,000.00 $ 43,000.00 43,000.00 2,500.00 2,500.00 2,800,000.00 2,800 000 00 2,849,000.00 $ 2,849,000.00 $ 3,500.00 $ 3,500.00 $ 2.400.00 $ 0.00% 0.00% 43,000.00 0.00% 2,500.00 0.00% 0.00% 1,800,000.00 (1,000,000.00) -35.71% Unfav due to low investment market rates. 1,847,900.00 $ (1,001,100.00) -35.14% 28,344 00 $ 28,344.00 $ 50,608.00 50.608 0 2,508.00 5,000.00 5,000 00 5,000 00 • Revenue variance is partially offset by an expenditure variance. 31 6 of 8 3/7/2013
Sheriff - Corrective Services Sheriff - Corrective Services - Satellites Sheriff - Emergency Preparation and Training Sheriff - Patrol Services Sheriff - Investigative/Forensic Svc 2,679.00 2,679.00 100.00% Voluntary donation of elected official's salary $1,250 and cash overages $1,429. 200.00 200.00 1,449.00 1,249.00 624.50% Voluntary donation of elected official's salary $1,249. 3,800.00 3,800.00 3,800.00 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2013 FIRST QUARTER REPORT Amount Favorable (unfavorable) Percent Explanation of Significant Variances 58,500.00 100.00% Fav. for transfer from Sheriff Booking Fee Training restricted fund (#21397) based on 1st qtr activity. Offset by unfav. variance in other divisions for the removal of the Enhancements Funds revenue line item (enhancements funds are now accounted for in a separate restricted fund). A budget amendment is recommended. 0.00% 34,300.00 100.00% Fay. for transfer from Sheriff Booking Fee Training restricted fund (#21396) based on 1st qtr activity. Offset by unfav, variance in other divisions for the removal of the Enhancements Funds revenue line item (enhancements funds are now accounted for in a separate restricted fund). A budget amendment is recommended. (12,700.00) -67.85% Unfav due to the removal of the Enhancements Funds revenue line item (enhancement funds are now accounted for in a separate restricted fund). Offset by fay. variances for Transfer In line item for other Sheriff divisions. A budget amendment is recommended. (250,500.00) -86.08% Unfav, due to the removal of the Enhancements Funds revenue line item (enhancement funds are now accounted for in a separate restricted fund). Offset by fay. County Auction receipts in this division of $6,300. Also, offset by fay. variances for Transfer In line item for this division and other Sheriff divisions. A budget amendment is recommended. Adopted Amended FY 2013 Budget Budget Forecast 58.500 00 18,718.00 291,025.00 18,718.00 291,025.00 34 300 00 6,018.00 40,525.00 Clerk/Register of Deeds Treasurer Board of Commissioners Library Board Water Resources Commissioner County Executive - Auditing Management and Budget Central Services - Support Services Facilities Management Administration Health Division Children's Village Homeland Security * Revenue variance is partially offset by an expenditure variance. 7 of 8 3/7/2013
COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2013 FIRST QUARTER REPORT Amount Adopted Amended FY 2013 Favorable Budget Budget Forecast (unfavorable) Percent Explanation of Significant Variances Public Services 0.00% Public Services - Animal Control 0.00% Economic Development - Donations 44,400.00 44,400.00 44,400.00 0.00% Non Departmental - Donations 0.00% Non-Dept - Sundry 417,500 00 417,500.00 1,382,500.00 965,000 00 231.14% Fav due to prior year adjustments for repayment of Remonumentation advance that was approved with MR #12336 and FY 2012 check that was cancelled in FY 2013. Treasurers' Transfers 5,658,923.00 5,658,923.00 5.658,923.00 0.00% Non-Departmental - Transfers In 36,333,070.00 36,333,070.00 36,333,070.00 0.00% Total Other Revenues 42,823,244.00 $ 42,851,588,00 43.602,016,00 $ 750,428.00 1.75% PLANNED USE OF FUND BALANCE (665000-665999) Encumbrances and Carryforwards 2,486,767.34 2,486,767.34 0.00% Use of Prior Yrs Fund Balance 37,621,540.00 $ 37.255,898.00 37,255.898.00 0.00% Total Planned Use of Fund Balance 37,621,540.00 $ 39,742,665.34 $ 39,742,665.34 $ 0.00% TOTAL GEN. FUND / GEN. PURPOSE REVENUE $ 418,655,204.00 $ 420,962,227.34 $ 420,365,055.34 $ (597,172.00) -0.14% * Revenue variance is partially offset by an expenditure variance. 8 of 8 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 250,000.00 180,000.00 Judicial Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfer Out Business Division Personnel Expenditures Operating Expenditures $ 8,302,959.00 $ 8,272.529.00 $ 8,022.529.00 $ 92,176.00 280,826.00 100,826.00 321,792.00 337.339.00 337,339.00 28,344.00 28,344.00 $ 8,716,927.00 $ 8,919.038.00 $ 8,489,038.00 $ $ 1,641,464.00 $ 1,641 464.00 $ 1,641,464.00 $ 77,234.00 85.284.00 48,284.00 3.02% - Fay, due to underfilled and vacant positions. 64.10% - 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% 430,000.00 4.82% 0.00% - 37,000.00 43.38% - Fay. due to a reduction in the use of Visiting Judges $25,000 and Professional Services $3,000. Also Fav. Equipment Expense $3,000 due to conscious effort to reduce costs and Metered Postage $6.000 due to lower than anticipated use. Internal Support Expenditures 156,372.00 157,313.00 157,313.00 0.00% - 37,000.00 1.96% 60,000.00 565,000.00 Civil I Criminal Division Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 1,875,070.00 $ 1,884,061.00 $ 1,847,061.00 $ $ 2,003,804.00 $ 2,003,804.00 $ 1,943,804.00 $ 5,221,944.00 5,221,944.00 4,656,944.00 2,329,459.00 2.430228.00 2,430,228.00 $ 9,555,207.00 $ 9,655,976.00 $ 9,030,976.00 $ 2.99% - Fay. due to underfilled and vacant positions. 10.82% - 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 $200,000, Transcript on Appeals $20,000 due to a decline in caseload. In addition, Fav. Printing $30,000 and Metered Postage $15,000 due to lower than anticipated use. 0.00% - 625,000.00 6.47% 3/7/2013
400,000.00 2,100,000.00 3.61% - Fav. due to underfilled and vacant positions. 15.87% - Fay. due to decrease in placements to State Institutions $2,000,000. Also Fav. Fees Guardian Ad Litem $100,000 due to a decrease in caseload. 0.00% - 0.00% - 2,500,000.00 8.08% 710,000.00 3.09% 2.882,000.00 15.31% 0.00% 0.00% COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENIDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Family Division/Juvenile Maint. Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfer Out Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 23,040,913.00 $ 23,010,483.00 18,622,015.00 18,818,715.00 4,314,888.00 4,433,276.00 5,092,079.00 5,120,423.00 $ 22,300.483.00 $ 15,936,715.00 4,433,276.00 5,120,423.00 $ 11,092,686.00 S 11,092,686.00 $ 10,692,686.00 $ 13,230,661.00 13,230,661.00 11,130,661.00 1,507,265.00 1,508,396.00 1.508,396.00 5,092,079.00 5,092,079.00 5,092,079.00 $ 30,922,691.00 $ 30,923,822.00 $ 28.423,822.00 $ $ 51,069,895.00 $ 51,382,897.00 $ 47,790,897,00 $ 3,592000.00 6.99% 3/7/2013
ADOIPTED BUDGET AMENDED BUDGET COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES DISTRICT COURT AMOUNT FY 2013 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Internal Support Expenditures $ 204.527.00 $ 232,639.00 $ 232,639.00 $ 5.300.00 5,300.00 5,300.00 $ 209,827.00 $ 237,939.00 $ 237,939.00 $ $ 4.166.098.00 $ 4,166,098.00 $ 4,076,098.00 $ 90,000,00 1,072,586.00 1,083,376.00 1.058,376.00 25,000.00 449,082.00 463,100.00 443,100.00 20,000.00 0.00% - 0.00% 0.00% 0.00% 2.16% - Fay. due to turnover and underfilled positions. 2.31% - Fay. Drug Testing $10,000 as a result of negotiating a lower price for test cups and Defense Attorney Fees $2,000 due to a procedural change that has reduced costs. Also Fav. Postage-Standard Mailing $5,000, Juror Fees and Mileage $4,000 and Professional Services $4,000 due to lower than anticipated use. 4.32% - Fay. Info Tech Operations due to lower than anticipated use. District Court Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Division 1 - Novi Personnel Expenditures Operating Expenditures Total Division 1 - Novi $ 5,687,766.00 $ 5,712,574.00 $ 5,577,574.00 $ 135,000.00 2.36% 3.13% - Fay. due to turnover and underfilled positions. 8.76% - Fay. Defense Attorney Fees $40,000 due to restructured schedule for defense attorneys. Also Fay. Interpreter Fees $8,000. Printing $5,000 and Travel and Conference $5,000 due to a decrease in activity. Division 2 - Clarkston Personnel Expenditures $ 1,914,604.00 $ 1,914,604.00 $ 1,854,604.00 $ 60,000.00 Operating Expenditures 655,474.00 662,217.00 604,217.00 58,000.00 Internal Support Expenditures 210,400.00 229,031.00 229,031.00 0.00% - Transfers Out 0.00% - Total Division 2 - Clarkston $ 2,780,478.00 $ 2,805,852.00 $ 2,687,852.00 $ 118,000.00 4.21% 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES DISTRICT COURT AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Division 3 - Rochester Hills Personnel Expenditures Operating Expenditures $ 3,722,442.00 $ 3,722,442.00 $ 3,642,442.00 $ 80,000.00 2.15% 420,483.00 420,483.00 384,483.00 36,000.00 8.56% 812,505.00 828,604.00 818,604.00 10,000.00 1.21% - 0.00% $ 4,955,430.00 $ 4,971,529.00 $ 4,845,529,00 $ 126,000.00 2.53% Fav. due to turnover and underfilled positions. Fav. Defense Attorney Fees $20,000, Juror Fees and Mileage $10,000, Expendable Equipment $3,000 and Computer Research Service $3,000 due to a decrease in activity. Fav. Info Tech Operations due to lower than anticipated use. Internal Support Expenditures Transfers Out Division 4 - Troy Personnel Expenditures Operating Expenditures Internal Support Expenditures Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 2,251.368.00 $ 2,251,368.00 $ 2,231,368.00 $ 492,607.00 502,047.00 487,047.00 326,982.00 340,780.00 320,780.00 $ 3,070,957.00 $ 3,094,195.00 $ 3,039,195.00 $ $ 12,259,039.00 $ 12,287,151.00 $ 12,037.151.00 $ 2,646,450.00 2,673,423.00 2,539.423.00 1,798,969.00 1,861,515.00 1,811,515.00 $ 16,704,458.00 $ 16,822,089.00 $ 16,388,089.00 $ 20,000.00 0.89% - Fav. due to turnover and underfilled positions. 15,000.00 2.99% - Fav. Electrical Service due to lower than anticipated 20,000.00 5.87% - Fay. Info Tech Operations due to lower than anticipated use. 55,000.00 1.78% 250,000.00 2.03% 134,000.00 5.01% 50,000.00 2.69% 434.000.00 2.58% 37 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES PROBATE COURT AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Judicial/Administration Personnel Expenditures Operating Expenditures Internal Support Transfer Out $ 2,388,531.00 $ 2,388,531.00 $ 2,303,531.00 $ 85,000.00 3.56% Fay. due to turnover and underfilled positions. 29,481.00 29,481.00 19,481.00 10,000.00 33.92% Fay. Visiting Judges $5,000 due to a reduction in the use of these services and Library Continuations $5,000 due to implemented cost containment measures. 285,201.00 285,201.00 282,201.00 3,000.00 1.05% Fay. Info Tech Operations $3,000 due to lower than anticipated use. Estates/Mental Health Personnel Expenditures Operating Expenditures $ 2,703,213,00 $ 2,703,213.00 $ 2,605,213.00 $ 98,000.00 3.63% $ 1,927,857.00 $ 1,927,857.00 $ 1,837,857.00 $ 90,000.00 4.67% 709,943.00 709,943.00 730,943.00 (21,000.00) -2.96% Fay. due to turnover and underfilled positions. Unfav. Medical Services Guardianship ($25,000) and Defense Attorney fees ($20,000) due to a continued high demand for this item; partially offset by Fay. Printing $10,000, Medical Services Probate Exam $8,000 and Fees Guardian Ad Litem $6,000 where demand has not yet Internal Support 611,842.00 621,477.00 621,477.00 0.00% $ 3,249,642.00 $ 3,259,277.00 $ 3,190,277.00 $ 69,000.00 2.12% 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES PROBATE COURT AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE I3UDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Department Total Personnel Expenditures Operating Expenditures Internal Support Transfer Out $ 4,316,388.00 $ 4,316,388.00 $ 4,141.388.00 $ 739,424.00 739,424.00 750,424.00 897,043.00 906,678.00 903,678.00 175,000.00 4.05% (11,000.00) -1.49% 3,000.00 0.33% $ 5,952,855.00 $ 5,962,490.00 $ 5,795,490.00 $ 167,000.00 2.80% 3/7/2013 10
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 2,194,559.00 $ 2,194,559.00 $ 2,159,659.00 $ 34,900.00 1.59% Favorable due largely to a number of under filled and vacant positions; and positions assigned to this division but actually working across divisional disciplines. A formal reorganization is being considered. Operating Expenditures 505,799.00 438,025.07 438,025.07 0.00% Internal Support Expenditures 1,782,792.00 1,802.159.00 1,802,159.00 0.00% Transfers 19,414.00 118,839.00 118,839.00 0.00% Litigation Personnel Expenditures $ 4,502,564.00 $ 4,553,582.07 $ 4,518,682.07 $ 34,900.00 $ 9,716,109.00 $ 9,716,109.00 $ 9,092,109.00 $ 624,000.00 0.77% 6.42% Favorable due largely to a number of under filled and vacant positions; and positions assigned to this division but actually working across divisional disciplines. A formal reorganization is being considered. Operating Expenditures 23,296.00 23,296.00 23,296.00 0.00% Internal Support Expenditures 0.00% Transfers Out 855,589.00 1,026,583.00 1,026,583.00 0.00% $ 10,594,994.00 $ 10,765,988.00 $ 10,141,988.00 $ 624,000.00 5.80% 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Warrants Personnel Expenditures $ 2,241,524.00 $ 2,221,524.00 $ 2,230,524.00 $ (9,000.00) -0.41% Unfavorable due to positions budgeted/assigned to other PA divisions but charged to this division; staff actually working across divisional disciplines. A formal reorganization is being considered. Operating Expenditures 3,199.00 3,199.00 3,199.00 0.00% Internal Support Expenditures 2,305,00 2305.00 2,305.00 0.00% $ 2,247,028.00 $ 2,227.028.00 $ 2,236,028.00 $ (9,000.00) -0.40% Appellate Personnel Expenditures $ 1,817,753.00 $ 1,817,753.00 $ 1,789,253.00 $ 28,500.00 1.57% Favorable due largely to a number of under filled and vacant positions; and positions assigned to this division but actually working across divisional disciplines. A formal reorganization is being considered. Operating Expenditures 8,458.00 8,458.00 8,458.00 0.00% Internal Support Expenditures 0.00% $ 1,826,211.00 $ 1,826,21 00 $ 1,797,711.00 $ 28,500.00 1.56% Department Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 15,969,945.00 $ 15,949,945.00 $ 15,271,545.00 540,752.00 472,978.07 472,978.07 1,785,097.00 1,804,464.00 1,804,464.00 875,003.00 1,145,422.00 1,145,422.00 678,400.00 4.25% 0.00% 0.00% 0.00% $ 19,170,797.00 $ 19,372,809.07 $ 18,694.409.07 $ 678,400,00 3.50% 3/7/2013 41
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Sheriffs Office Personnel Expenditures $ 1,727,341.00 $ 1,727,341.00 $ 1,727,341.00 S Operating Expenditures 66,236.00 72,310.00 73,610.00 Internal Support Expenditures 337,515.00 337,515.00 337,515.00 Transfers $ 2,131,092.00 $ 2,137,166.00 $ 2,138,466.00 (1,300 00) 0.00% -1.80% 0.00% 0.00% -0.06% Unfavorable due largely to Equipment Maintenance, Administrative Services Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Corrective Services Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 2,094,688.00 $ 2,094,688.00 $ 2,047,488.00 1,109,738.00 1,191,582.90 1,190,082.90 286,816.00 286,816.00 280,916.00 $ 3,491,242.00 $ 3,573,086.90 $ 3,518,486.90 S 32,384,498.00 $ 32,513,124.00 $ 33,673,624.00 8,878,414.00 9,114,614.69 8,847,314.69 7,153,581.00 7,249,258.00 7,246,958.00 --------- ------------ ------ --------- 9, 2.25% Favorable due largely to lower fringe benefit rates. 0.13% Favorable Commodities largely in Office Supplies; partially offset by unfavorable Library Continuations. 2.06% Favorable Radio Communications, partially offset by unfavorable Info Tech Operations; Internal Service analysts will be contacted to review actual charges and budget allocations. 0.00% 1.53% 000) -3.57% Unfav. due to increased usage of overtime ($2,345,000) at the main jail, related to the high number of vacant positions; partially offset by favorable regular salaries of $1,184,000 due to vacancies and turnover. 2.93% Favorable due to projected savings for Main Jail food services from negotiated reduction in per meal cost from $.925 to $.715 cents per meal; paid to vendor ARAMARK. The projected savings for the remaining nine months of FY 2013 is $290,000. This is partially offset by unfavorable variance of ($22,700) for final payment of invoices related to the closing of the Jail Clinic (e.g. Hospitalization of Prisoners, Medical Exams, Medical Svcs. Physicians, and Professional Svcs). 0.03% Favorable overall due to variances between divisions; the Internal Service Analyst will be contacted to review actual charges and budget allocations. 0.00% $ 48,416,493.00 $ 48,876,996.69 $ 49,767,896.69 -1.82% 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Corrective Services-Satellites Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 11,618,034.00 $ 11,618,034.00 $ 12,714,534.00 $ (1 ,00r.,500 00) -9.44% Unfav. due to increased usage of overtime at the Satellites Facilities ($865.100); caused by Hospital Watch, vacant positions, prisoner transport, employee sick and other leaves, and East Annex security; and unfav. fringe benefits of ($305,200) related to overtime fringes for Retirement, Workers Compensation, and FICA benefits. Partially offset by favorable regular salaries of $73,800 30.750.00 35.184.84 74,284.84 -111.13% Unfav due to expenses charged to the Satellite Jail (e.g. laundry and cleaning, travel and employee taxable meals, culinary supplies, custodial supplies, computer supplies, office supplies, dry goods and clothing) but are budgeted in the Main Jail. 994,138.00 994,525.00 1,046,525.00 (52,000 00) -5.23% Unfavorable due to under budgeting of motor pool charges and unfavorable motor pool fuel charges due to higher fuel costs; the Internal Service Analyst will be contacted to review actual charges and budget allocations. 0.00% $ 12,642,922.00 $ 12,647,743.84 $ 13,835,343.84 $ Emergency Response and Preparedness Personnel Expenditures $ 6,933,667.00 $ 6,933,667.00 $ 6,371,467.00 $ Operating Expenditures 1,268,950.00 1,347,307.00 1,128,607.00 Internal Support Expenditures 150,484.00 150,484.00 173,284.00 Transfers $ 8,353,101.00 $ 8,431,458.00 $ 7,673,358.00 $ -9.39% 8.11% Favorable due to turnover, overtime and lower fringe benefit rates. 16.23% Favorable Fees Civil Service of $192,400 related to decrase in papers served (see offsetting unfav. variance in Civil Action Service Fees revenue), this variance is due to the decline in the number of foreclosures, and civil service requests. Employee Medical Exams of $34,000. Officer Training $9,000; partially offset by unfavorable Equipment Maintenance of ($2,300), and Office Supplies of ($14,400). -15.15% Unfavorable due to under budgeting of Equipment Rental; the Internal Service Analyst will be contacted to review actual charges and the budget allocation. 0.00% 8.99% 3/7/2013 '1.
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES .674 000 00, 3.69% Favorable due to projected lower overtime $739,700 and lower fringe benefit rates of $934,300. 210030 0.24% Favorable Equipment Maintenance, Towing and Storage Fees, Uniforms; partially offset by unfavorable and Photographic Supplies, and Adjustment of Prior Years Revenue. (516,300 00) -9.64% Unfavorable due to under budgeting of motor pool charges ($341.600), motor pool fuel charges as a result of higher fuel costs ($255.800), and Radio Communications of ($14,100); partially offset by favorable Insurance Fund of $67.900 and Equipment Rental of $27,300; the Internal Service Analyst will be contacted to review actual charges and budget allocations. Patrol Services Personnel Expenditures $45,335,574 $ 45,354,274.00 $ 43,680,274.00 $ Operating Expenditures 635,585.00 879,161.35 877,061.35 Internal Support Expenditures 5,344,238.00 5,356,201.00 5,872,501.00 Transfers 97,395.00 97,395.00 0.00% $ 51,315,397.00 $ 51,687,031.35 $ 50,527,231.35 2.24% 1.01% Favorable due to lower fringe benefit rates. 1.70% Favorable largely in Evidence Fund NET and Professional Services. -7.25% Unfavorable due to under budgeting of Motor Pool; the internal Service Analyst will be contacted to review actual charges and the budget allocation. Investigative/Forensic Svcs Personnel Expenditures $ 8,094,887.00 $ 7,984,638.00 $ 7,904,338.00 $ Operating Expenditures 1,020,413.00 1,070,869.48 1,052,669.48 Internal Support Expenditures 2,052,911.00 2,052,911.00 2,201,711.00 Transfers 334,086.00 636,939.00 636,939.00 0.00% 106 467,4"..1 (731 Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfer Out $ 108,188,689.00 $ 108,225,766.00 13,010,086.00 13,711,030,26 16.319,683.00 16,427,710.00 334,086.00 734,334.00 $ 108,119,066.00 13,243,630.26 17,159,410.00 734,334.00 -0.43% 0.10% 3.41% -4.45% 0.00% ------- _a-- ------------ ----------- ------------ $ 11,502,297.00 $ 11,745,357.48 $ 11,795,657.48 $ $ 137,852,544.00 $ 139,098,840.26 $ 139,256,440.26 $ (157,600.00) -0.11% 3/7/2013
ADOPTED BUDGET AMENDED BUDGET COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT FY 2013 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 746,277.00 $ Operating Expenditures 89.137.00 Internal Support Expenditures 116,957.00 Transfers 746,277.00 $ 746,277.00 89,137.00 89,137.00 120,685.00 120,685.00 0.00% 0.00% 0.00% 0.00% $ 952,371.00 $ 956,099.00 $ 956,099.00 $ 0.00% 4.27% Fav. Due to underfilled positions, vacancies and turnover. 25.32% Fav. Due to Court Transcripts $74,000 as prosecutors are ordering less transcripts in duplicates, Equipment Maintenance $4,000 due to less anticipated use. Partially offset by unfav. Charge Card Fees ($7,500) due to increased activity. County Clerk (Vital Stats & Legal Rec's) Personnel Expenditures $ 3,513,823.00 $ 3,513,823.00 $ 3,363,823.00 $ 150,000.00 Operating Expenditures 284,342.00 284,342.00 212,342.00 72,000.00 Internal Support Expenditures 604,413.00 633,159.00 633,159.00 0.00% Transfers 0.00% $ 4,402,578.00 $ 4,431,324.00 $ 4,209,324.00 $ 222,000.00 5.01% Elections Personnel Expenditures $ 749,748.00 $ 813,158.00 $ 763,158.00 $ 50,000.00 6.15% Fav. due to vacancies. Operating Expenditures 779,078.00 779,078.00 779,078.00 0.00% Internal Support Expenditures 259,992 00 261,212.00 261,212.00 0.00% Transfers 0.00% $ 1,788,818.00 $ 1,853,448.00 $ 1,803,448,00 $ 50,000.00 2.70% Register of Deeds (and Micrographics) Personnel Expenditures $ 3,054,295.00 $ 2,543,806.00 $ 2,543,806.00 0,00% 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS 320,600.00 $ 192,600.00 128,000.00 39.93% Fay. Professional Services $133,000 as charges for Land Records Management are now charged to the Automation Fund, #21160. Also fay. Printing $3,392 due to less anticipated use. Partially offset by unfav. Adj Prior Years Exp ($8,256) due to transferring some of prior year's expenditures from the Remonumentation Grant to the General Fund. 43.53% Fay. IT Operations $186,100 as expenditures were moved to the Automation Fund, #21160; a budget amendment is recommended. Operating Expenditures ADOPTED BUDGET ---------- 320,600.00 AMENDED FY 2013 BUDGET FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Internal Support Expenditures 427,209.00 427,516.00 $ 241,416.00 186,100.00 Transfers 0.00% $ 3,802,104.00 $ 3,291,922.00 $ 2,977,822.00 $ 314,100.00 9.54% Jury Commission Personnel Expenditures Operating Expenditures Internal Support Expenditures $ 16,879.00 $ 68,776.00 34,258.00 16,879.00 $ 68,776.00 34.258.00 16,879.00 56,776.00 34,258.00 12,000.00 0.00% 17.45% Fav. metered Postage $12,000 due to less than anticipated 0.00% $ 119,913.00 $ 119,913.00 $ 107,913.00 $ 12,000.00 10.01% Department Total Personnel Expenditures $ 8,081,022.00 $ 7,633,943.00 $ 7,433,943.00 $ Operating Expenditures 1,541,933.00 1,541,933.00 1,329,933.00 $ Internal Support Expenditures 1,442,829.00 1,476,830.00 1,290,730.00 $ Transfers 200,000.00 2.62% 212,000.00 13.75% 186.100.00 12.60% 0.00% $11,065,784.00 $ 10,652,706.00 $ 10,054,606.00 $ 598,100.00 5.61% 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES COUNTY TREASURER AMOUNT ADOPTED AMENIDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 3,129,377,00 $ 3,129,377.00 $ 3,000,577.00 $ 128,800.00 4.12% - Fay. due to turnover, underfilled positions, and vacancies. Operating Expenditures 4,606,640.00 4,606,640.00 4,393,240.00 213,400.00 4.63% - Fav. Layout and Staking $56.000, Mail Handling-Postage Svc $153,000 due to less than anticipated use. Also, favorable, Charge Card Fees $5,800, Membership Dues $2,900 and Workshops and Meetings $1,500 due to less activity. Partially offset by Register of Deeds line item ($5,900) due to increased activity. Internal Support Expenditures 559,514.00 673,657.00 673,657.00 0.00% - Transfers Out 120,000,00 120,000.00 120,000.00 0.00% Division Total $ 8,415,531,00 $ 8,529,674.00 $ 8,187,474.00 $ 342,200.00 4.01% Department Total $ 8.415.531.00 $ 8,529,674.00 $ 8,187.474.00 $ 342,200.00 4.01% 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES BOARD OF COMMISSIONERS AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $2,199,320.00 $ 2,199,320.00 $2,199,320.00 0.00% - Operating Expenditures 436,868.00 473,268.00 $ 440,968.00 32,300.00 6.82% - Fay. Personal Mileage $3,453 due to reduced travel, Printing $6,400, Legal Services $8,000, Legislative Expense $8,000, Special Event Program $1,600, Expendable Equipment $1,000 and Communications $1,000 due to less than anticipated use. Internal Support Expenditures 206,089.00 209,722.00 $ 200,522.00 9,200.00 4.39% - Fay. IT Operations $9,200 based on actual usage. $2,842,277.01) $2,882,310.00 $2,840,810.00 $ 41,500.00 1.44% Department Total Personnel Expenditures $2,199,320.00 $ 2,199,320.00 $2,199,320.00 $ 0.00% Operating Expenditures 436,868.00 473,268.00 440,968.00 32.300.00 6.82% Internal Support Expenditures 206,089.00 209,722.00 200,522.00 9,200.00 4.39% $2,842,277.00 $2,882,310.00 $2.840,810.00 $ 41,500.00 1.44% 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES LIBRARY BOARD AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Library Board Personnel Expenditures $ 558,854.00 $ 558,854.00 $ 539,554.00 $ 19,300.00 3.45% Fav. due to turnover. 364,220.00 364,220.00 365,660.00 490,254.00 493,986.00 467,086.00 $1,413,328.00 $ 1,417,060.00 $1,372,300.00 $ $ 558,854 00 $ 558,854.00 $ 539,554.00 $ 364,220.00 364,220.00 365,660.00 490,254.00 493,986.00 467,086.00 $ 1,413,328.00 $ 1,417,060.00 $1,372,300.00 $ Operating Expenditures Internal Support Expenditures Transfers Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers (1,440.00) -0.40% Unfav. Library Continuations ($2,700) as materials are continuously updated due changes in the laws and court decisions. The unfavorability is offset by Special Projects $1,266 due to less than anticipated use. 26,900.00 5.45% Fav. IT Operations $25,821 due to actual expenditures will be lower than budget because of LVPI transferring to Rochester Hills Library. Also fav. Telephone Communications $1,000 for reduced phone lines due to LVPI transferring to Rochester Hills Library. 44,760.00 3.16% 19,300.00 3.45% (1,440.00) -0.40% 26,900.00 5.45% 44,760.00 3.16% 3/7/2013 49
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES WATER RESOURCES COMMISSIONER AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Water Resource Commissioner Personnel Expenditures $ 226,413.00 $ 226,413.00 $ 226,413.00 $ 0.00% Operating Expenditures 487.975.00 488,300.00 488,300.00 0.00% Internal Support Expenditures 4,354.046.00 4,446,948.00 4,446,948.00 0.00% Transfers 56,165.00 56,165.CIO 56,165.00 0.00% Division Total $ 5.124,599.00 $ 5,217,826.00 $ 5,217,826.00 $ 0.00% Department Total $ 5.124,599.00 S 5,217,826.00 $ 5,217,826.00 $ 0.00% 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES COUNTY EXECUTIVE AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel $ 2,158,743.00 $ 2,158,743.00 $ 2,158,743.00 $ 0.00% - Controllable Operating 282,944.00 282,944.00 282,944.00 0.00% - Internal Support Expenditures 420,434.00 431,509.00 431,509.00 0.00% - Transfer Out Compliance Office Admin Controllable Personnel Controllable Operating Internal Support Expenditures Transfer Out $ 2,862,121.00 $ 2,873,196.00 $ 2,873,196.00 $ $ 488,211.00 S 259,095.00 $ 259,095.00 $ 32,467.00 2,705.00 2,705.00 $ 66,945.00 3,502.00 3,502.00 $ 18,170.00 18,170.00 $ $ 587,623.00 S 283,472.00 $ 283,472.00 $ 0.00% 0.00% 0.00% 0.00% 0.00% 0,00% Auditing Controllable Personnel Controllable Operating Transfer Out $ 229,617.00 $ 29,762.00 229,617.00 $ 29,762.00 59,991.00 0.00% - 0.00% - 0.00% - Internal Support Expenditures 59,991.00 $ 319,370.00 $ 319,370.00 $ 0.00% 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES COUNTY EXECUTIVE AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Purchasing Controllable Personnel Controllable Operating Internal Support Expenditures Transfer Out 898,535.00 $ 898,535.00 $ 15,389.00 15,389.00 141,571.00 141,571.00 $ 1,055,495.00 $ 1,055,495.00 $ 0.00% 0.00% 0.00% 0.00% Corporation Counsel Controllable Personnel $ 2,050,766.00 $ 2,050,766.0(1 $ 2,050,766.00 $ 0.00% - Controllable Operating 59,133.00 59,133.00 59,133.00 0.00% - Internal Support Expenditures 204,586.00 204,762.00 204,762.00 0.00% - Transfer Out $ 2,314,485.00 $ 2,314,661.00 $ 2,314,661.00 $ 0.00% Department Total Controllable Personnel Controllable Operating Internal Support Expenditures Transfers Out $ 4,697,720.00 374,544.00 691,965.00 $ 5,596,756.00 $ 389,933.00 841,335.01) 18,170.00 5,596,756.00 $ 389,933.00 841,335.00 18,170.00 0.00% 0.00% 0.00% $ 5,764,229.00 $ 6,846,194.00 $ 6.846,194.00 $ 0.00% 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES MANAGEMENT AND BUDGET AMOUNT FY 2013 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ADOPTED AMENDED BUDGET BUDGET Administration Personnel Expenditures $ 224,006.00 $ 224,006.00 $ 224,006.00 $ 0.00% Operating Expenditures 4,017.00 4,017.00 4,017.00 $ 0.00% Internal Support Expenditures 13,164.00 13,164.00 13,164.00 $ 0.00% $ 241,187.00 $ 241,187.00 $ 241,187.00 $ 0.00% Purchasing Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 1,149,603.00 $ 16,785.00 154,903.00 95,299.00 1,396.00 9,604.00 95,299.00 $ 1,396.00 9,604.00 0.00% 0.00% 0.00% $ 1,321,291.00 $ 106,299 00 $ 106,299.00 $ 0.00% $ 8,264,023.00 $ 8,264,023.00 $ 7,764,023.00 $ 500,000.00 6.05% Favorable due to vacancies and underfill/turnover. 431,404.00 431,404.00 396,404.00 35,000.00 8.11% Favorable Professional Services due to efforts to contain costs. 891,979.00 977,378.00 977,378.00 0.00% - - 0.00% $9,587,406.00 $9,672,805.00 $ 9,137,805.00 $ 535,000.00 5.53% Equalization Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers 3/7/2013 53
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES MANAGEMENT AND BUDGET AMOUNT FY 2013 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ADOPTED AMENDED BUDGET BUDGET Fiscal Services Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 17,462,934.00 S 16,408,630.00 $ 15,508,630.00 $ 843,545.00 828,156.00 773,156.00 2,299,020.00 2,293,771.00 2,293,771.00 $ 20,605,499.00 $ 19,530,557.00 $ 18,575,557.00 $ 900,000.00 5.48% 55,000.00 6.64% 0.00% 0.00% 955,000.00 4.89% S 7,825,302.00 $ 7,825,302.00 $ 7,425.302.00 $ 400,000.00 5.11% Favorable due to vacancies and underfill/turnover. 391,339.00 391,339.00 371,339.00 20,000.00 5.11% Favorable Professional Services due to efforts to contain costs. 1,238,974.00 1,293,625.00 1,293,625.00 0.00% - - - 0.00% 5 9,455,615.00 $ 9,510,266.00 $ 9,090,266.00 $ 420.000.00 4.42% 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES CENTRAL SERVICES Administrative Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Support Services Personnel Expenditures Operating Expenditures ADOPTED BUDGET 217,642.00 3,098.00 14,006.00 AMOUNT FAVORABLE (UNFAVORABLE) PERCENT AMENDED FY 2013 BUDGET FORECAST $ 217,642.00 $ 217.642.00 $ 0.00% 3,098.00 $ 3,098.00 0.00% 14,006.00 $ 14,006.00 0.00% EXPLANATION OF SIGNIFICANT VARIANCES $ 234,746.00 $ 234,746.00 $ 234,746.00 $ 0.00% $ 1,167,200.00 $ 1,167,200.00 $ 1,150,000.00 $ 17,200.00 1.47% Fay. due to FTE position filled with PINE. 422,538.00 426,455.50 $ 388,255.50 38,200.00 8.96% Fay, mail handling-postage $40,000 and printing copy charge. paper & supplies $750 due to lost CVT business, offset by unfav. standard mail & printshop revenue due to printing business being outsourced to Oakland Schools. Unfav. Licenses and Permits ($4,600) due to increase costs in UMove license and annual fees. Internal Support Expenditures 726,846.00 746,151.00 $ 746,151.00 0.00% Transfers 0.00% $ 2,316.584.00 $ 2,339,806.50 $ 2,284.406.50 $ 55,400.00 2.37% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 1.384,842.00 $ 1,384,842.00 $ 1,367,642.00 $ 425,636.00 429,553.50 391.353.50 740,852.00 760,157.00 760.157.00 17,200.00 38.200.00 1.24% 8.89% 0.00% 0.00% $ 2,551.330.00 $ 2,574,552.50 $ 2,519,152.50 $ 55,400.00 2.15% 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES FACILITIES MANAGEMENT AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 235,568.00 $ 235,568 00 $ 224,068 00 $ 11,500.00 4.88% - Favorability due to underfilled positions/vacancies. Operating Expenditures 5,764.00 5,764.00 5,764.00 0.00% - Internal Support Expenditures 18.310 00 18,310 00 18,310.00 0.00% - $ 259.642.00 $ 259,642.00 $ 248,142.00 $ 11,500.00 4.43% Facilities Engineering Personnel Expenditures $ 811,247.00 $ 811,247.00 $ 811,247.00 $ 0.00% - Operating Expenditures 86,482.00 86,482.00 86,482.00 0.00% - Internal Support Expenditures 57,905.00 58,409.00 58,409.00 0.00% - $ 955,634.00 $ 956,138.00 $ 956,138.00 $ 0.00% Department Total Personnel Expenditures $ 1 046,815.00 $ 1,046,815.00 $ 1,035,315.00 $ 11,500.00 1.10% Operating Expenditures 92,246.00 92,246.00 92,246.00 0,00% Internal Support Expenditures 76,215.00 76,719.00 76,719.00 0.00% $ 1,215,276.00 $ 1,215,780.00 $ 1,204.280.00 $ 11,500.00 0.95% 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES HUMAN RESOURCES AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 738,928.00 $ 738,928.00 $ 638,928.00 $ 100,000.00 13.53% Favorable due to underfilled positions/vacancies. Operating Expenditures 290,122.00 290,122.00 283,122.00 $ 7,000.00 2.41% Favorable Membership Dues $4,000 and Travel and Conference $3,000 due to efforts to reduce spending. Internal Support Expenditures 34,367.00 35,722.00 35,722.00 $ 0.00% Transfer Out $ 1,063,417.00 $ 1,064,772.00 $ 957,772.00 $ 107.000.00 10.05% Workforce Management Personnel Expenditures $ 1,851,765.00 $ 1,851,765.00 $1,851,765.00 $ 0.00% Operating Expenditures 198,795.00 198,795.00 192,795.00 $ 6,000.00 3.02% Favorable Travel and Conference $5.000 and Expendable Supplies $1,000 due to efforts to reduce spending. Internal Support Expenditures 491,743.00 505,752.00 505,752.00 $ 0.00% Transfer Out - $ $ 2,542,303.00 $ 2.556,312.00 $2,550,312.00 $ 6,000.00 0.23% Benefits Administration Personnel Expenditures $ 169,398.00 $ 169,398.00 9; 169,398.00 $ 0.00% Operating Expenditures 16,977.00 16,977.00 13,977.00 $ 3,000.00 17.67% Favorable Travel and Conference $1,000 and Office Supplies $2,000 due to efforts to reduce spending. Internal Support Expenditures 154,089.00 154,089.00 154,089.00 $ 0.00% Transfer Out $ 340,464.00 $ 340,464.00 9; 337,464.00 $ 3,000.00 0.88% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfer Out $ 2,760,091.00 S 2,760,091.00 505,894.00 505,894.00 680,199.00 695,563.00 $2,660,091.00 489,894.00 695,563.00 $ 100,000 00 3.62% 16 000 00 3.16% 0.00% $ 3,946,184.00 $ 3,961,548.00 $3,845,548.00 $ 116,0 0.09 7.93% 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 202,769.00 $ 202,769.00 $ 202,769.00 0.00% - Operating Expenditures 9,760,134.00 9,760,134.00 7,835,134.00 1,925,000.00 19.72% - Fay. Foster Boarding Homes $300,000. Fav. Private Institutions Residential and Private Institutions Foster Care $1,250,000. Fav. Independent Living $375,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). Internal Support Expenditures 14,014.00 14,014.00 14,014.00 0.00% - Transfers Out $ 9,976,917.00 $ 9,976,917.00 $ 8,051,917.00 $ 1,925,000.00 19.29% Health Personnel Expenditures $ 23,903,572.00 $ 23,903,572.00 $ 22.403,572.00 1,500,000.00 6.28% - Fay, due to turnover and under filled positions. 155,000.00 Internal Support Expenditures 2,819,550.00 4,741,834.02 4,586,834.02 3,002,066.00 2,927,066.00 3.27% - Fav. Professional Services $100,000 due to contractor accepting Medicaid rates. Fay. Medical Supplies $30,000 due to reduction in the need for medical delivery systems (i.e. syringes). Fay. Drugs $25,000 due to discounted prices through Centers for Disease Control. Operating Expenditures 4,737,185.00 75,000.00 2.50% - Fav. Telephone Communications $50,000 and Equipment Rental $25,000 based on usage. Transfers Out 8,640.00 8,640.00 8,640.00 $ 31,468,947.00 $31,656,112.02 $ 29,926,112.02 $ 1,730,000.00 5.46% Children's Village Personnel Expenditures $ 14,847,367.00 $ 14.847,367.00 $ 4.847,367.00 $ 0.00% - Operating Expenditures $ 3,741,357.00 3,754,589.00 3,724,589.00 30,000.00 0.80% - Fay. Provisions $30,000 due to fluctuating population and commodity costs. 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES -------------- ^,- --pry- MN-- ----------------- ^V - A -N., NA, Internal Support Expenditures 2,606,055.00 2,633,603.00 2,668,603.00 (35,000.00) -1.33% - Unfav. Info Tech Operations $25,000 and Radio Communications $10,000 based on usage. Transfers Out $ 21,194,779.00 $ 21,235,559.00 $ 21,240,559.00 $ (5,000.00) -0.02% Homeland Security Personnel Expenditures $ 766,497.00 $ 766,497.00 $ 706,497.00 $ 60,000.00 7.83% - Fay. due to underfilled positions. Operating Expenditures Internal Support Expenditures Transfers Out 289,680.00 484,009.00 304,363.00 484,962.00 279,363.00 444,962.00 25,000.00 40,000.00 8.21% - Fay. Equipment Maintenance $25,000 due to limited repair costs incurred on specialty/hazmat vehicles. 8.25% - Fay. Info Tech Operations $35,000 and Telephone Communications $5,000 based on usage. $ 1,540,186.00 $ 1,555,822.00 $ 1,430,822.00 $ 125,000.00 Department Total Controllable Personnel Controllable Operating Non-Controllable Operating Transfers Out $ 39,720,205.00 $ 39,720,205.00 $ 38,160,205.00 $ 18,528,356.00 18,560,920.02 16,425,920.02 5,923,628.00 6,134,645.00 6,054,645 00 8,640.00 8,640.00 8,640.00 1,560,000.00 3.93% 2,135,000.00 11.50% 80,000.00 1.30% 0.00% $ 64,180,829.00 $ 64,424,410.02 $ 60,649,410.02 $ 3,775,000.00 5.86% 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT Public Services -Admin. Personnel Expenditures $ 200.685.00 $ 200,685.00 200,685.00 $ 0.00% - Operating Expenditures 4,800.00 4,800.00 4,800.00 0.00% - Internal Support Expenditures 5.922.00 5,922.00 5,922.00 0.00% - $ 211,407.00 $ 211,407.00 $ 211,407.00 $ 0.00% Veterans Services Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 1,506,056.00 $ 1,506,056.00 195,912.00 195,912.00 171,173.00 171,372.00 1,506,056.00 $ 195,912.00 171,372.00 0.00% - 0.00% - 0.00% - 0.00% $ 1,873.141.00 $ 1,873,340.00 $ 1,873,340.00 $ 0.00% Community Corrections Personnel Expenditures $ 3,582,750.00 $ 3,582,750.00 3,542,750.00 $ 40,000.00 1.12% - Favorable due to undertilliturnover. Operating Expenditures 502,025.00 573,987.00 533,987.00 40,000.00 6.97% - Favorable Contracted Services due to efforts to reduce spending. Internal Support Expenditures 522,072.00 557,893.00 557,893.00 0.00% - Transfers Out 0.00% - $ 4,606,847.00 $ 4,714,630.00 $ 4,634,630.00 $ 80,000.00 1.70% MSU Ext. - Oakland County Personnel Expenditures $ 831,877.00 $ 831,877.00 $ 831,877.00 S 0.00% - Operating Expenditures 89,689.00 89,689.00 89,689.00 0.00% - Internal Support Expenditures 242,089.00 242,932.00 242,932.00 0.00% - $ 1,163,655.00 $ 1,164,498.00 $ 1,164,498.00 $ 0.00% See related revenue offset. 3/712013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT Medical Examiner Personnel Expenditures $ 3,211,406.00 $ 3,211,406.00 $ 3,211,406.00 $ 0.00% - Operating Expenditures 520,006.00 530,119.74 520,119.74 10,000.00 1.89% - Favorable Lab Supplies due to efforts to reduce costs. Internal Support Expenditures 958,305.00 969,087.00 969,087.00 0.00% - Transfers $ 4,689,717.00 $ 4,710,612.74 $ 4,700,612.74 $ 10,000.00 0.21% 50,000.00 Animal Control Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 2,120,779.00 $ 2,120,779.00 $ 2,070,779.00 $ 190.097.00 191,210.75 191,210.75 841,553.00 862,494.00 862,494.00 2.36% - Favorable due to underfilled positions/vacancies. 0.00% - 0.00% - $ 3,152,429.00 $ 3,174,483.75 $ 3,124,483.75 $ 50,000.00 1.58% Circuit Court Probation Personnel Expenditures - - 0.00% Operating Expenditures 54,326.00 54,326.00 54,326.00 0.00% Internal Support Expenditures 527,581.00 527,742.00 527,742.00 0.00% $ 581,907.00 $ 582,068.00 $ 582,068.00 S 0.00% Department Total Personnel Expenditures $ 11,453,553.00 $ 11,453,553.00 Operating Expenditures 1,556,855.00 1,640,044.49 Internal Support Expenditures 3,268,695.00 3,337,442.00 Transfers Out $ 11,363,553.00 $ 1,590,044.49 3,337,442.00 90,000.00 50,000 00 0.79% 3.05% 0.00% $ 16,279,103.00 $ 16,4 039.49 $ 16.291,039.49 $ 140,000.00 0.85% ,3 * See related revenue offset. 3f7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS AMOUNT ADOPTED AMENIDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST :UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 1,187,734.00 $ 1,187,734.00 $ 1,162,734.00 $ 25,000.00 338,222.00 396,146.00 323,246.00 72,900.00 65,339.00 90,708.00 83,908.00 6,800.00 2.10% - Turnover and underfilled positions. 18,40% - Fay. Professional Services $34,600 due to utilization of PTNE position to perform services previously obtained through professional services; fay. Printing $18,900, Periodicals Books $5,200, Mileage $6,200 and Travel $8,400 based on usage. Partially offset by unfav. Supplies ($400) based on usage. 7.50% Fay. IT Ops $6,000 & Motor Pool $800 based on usage. $ 1,591,295.00 $ 1,674,588.00 $ 1,569,888.00 $ 104,700.00 6.25% Planning and Economic Development Services Personnel Expenditures $ 3,674,447.00 $ 3,674,447.00 $ 3,456,247.00 $ 218,200.00 Operating Expenditures 1,002,713.00 1,146,459.00 1,116,959.00 29,500.00 5.94% Turnover and underfilled positions. 2.57% - Fay. primarily in Professional Services, for NO HAZ Program $10,500 based on reduced resident participation (offset by reduced program reimbursement); Supplies $7,000, Workshop & Meetings $14,300 & Printing $40,400 based on actual usage. Partially offset by unfav. Software Maint ($6.800) due to increased maintenance costs; Adj Prior Yr ($35,400). 0.14% Fav. IT Ops $15,200 due to usage less than anticipated. Partially offset by unfav. Telephone Comm ($10,500) & Copier ($3,700) due to usage. Internal Support Expenditures 728,867.00 734,673.00 733,673.00 1,000.00 Transfers .10 $ 5,406,027.00 $ 5,555,579.00 $ 5,306,879.00 $ 248,700.00 4.48% 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT EXPENDITURES ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST :UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Community and Home Improvement Personnel Expenditures $ 108,354.00 $ Operating Expenditures Transfers 108,354.00 $ 108,354.00 $ 0.00% 0.00% $ 4,996,155.00 1,340,935.00 794,206.00 Workforce Development Personnel Expenditures Operating Expenditures Internal Support Expenditures Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 4,996,155.00 $ 4,752,955.00 $ 243,200.00 1,542,605.00 1.440,205.00 102, 400 00 825,381.00 817,581.00 7,800.00 $ 108,354.00 $ 108,354.00 $ 108,354.00 $ $ 25,620.00 $ 25,620.00 $ 25,620.00 $ $ 25,620.00 $ 25,620.00 $ 25,620.00 $ 0.00% 0.00% 4.87% 6.64% 0.95% 0.00% $ 7,131,296.00 $ 7,364,141.00 $ 7,010,741.00 $ 353,400.00 4.80% 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT NON-DEPARTMENTAL EXPENDITURES NON-DEPARTMENT APPROPRIATIONS COUNTY OPERATIONS Insurance Fund Insurance Surety Bonds Logos Trademarks Intellect Property Road Commission\Current Drain Assessment Road Commission1Tri Party Agreement ADOPTED BUDGET $ 269,649.00 30,599.00 18,000.00 1,400,000.00 100.00 AMENDED BUDGET $ 269,649.00 30,599.00 18,000.00 1,400,000.00 1,410,746.00 FY 2013 FORECAST $ 269,649.00 $ 30,599.00 18,000,00 1,400,000.00 1,410,746.00 AMOUNT FAVORABLE UNFAVORABLE) PERCENT 0.00% 0.00% 0.00% 0.00% 0.00% EXPLANATION Disaster Supplies 3,141.00 3,1,11 00 0.00% Provisions 30.000.00 30,000.00 30,000 00 0.00% Transfer to Community Mental Health Authority 9,620,616.00 9,620,616.00 9,620,616 00 0.00% Total $ 11,368,964.00 $ 12,782,751.00 $ 12,782,751.00 $ 0.00% COUNTY BUILDINGS $ 3,355,178.00 $ 3,197,006.00 $ 3,197,006.00 $ 0.00% STATE AND FEDERAL - COUNTY ASSOCIATIONS Michigan Assoc. of Counties $ 73,000.00 $ 73,000.00 $ 73,000 00 $ 0.00% National Assoc. of Counties 24,700.00 24,700.00 24,700.00 0.00% S.E.M.C.O.G. 500.000.00 500,000.00 500,000 00 0.00% Traffic Improvement Association 30,000.00 30,000.00 30,000,00 0.00% Total $ 627,700.00 $ 627,700.00 $ 627,700.00 $ 0.00% SUNDRY EXPENSE 300,000.00 $ 300,000.00 $ 300,000.00 $ 0.00% RESERVED FOR TRANSFERS Expenditures Classification and Rate Change Contingency Emergency Salaries Fringe Benefit Reserve Grant Match Info Tech Development Legislative Expense Misc. Capital Outlay Overtime Appropriation Summer Employees Salary Appropriation $ 137,521.00 348,366.00 1,310,000.00 5,400,000.00 1,160,000.00 5,816,400.00 36,400.00 75,000.00 53,000.00 250,000.00 137,521.00 $ 137,521.00 $ 245,971.00 245,971.00 1,310,000.00 1,310,000.00 5,400,000.00 5,400,000.00 846,449.00 846,449.00 4,912,759.00 4,912,759.00 36,400.00 36,400.00 44,886.00 44,886.00 53,000.00 53,000 00 250,000.00 250,000.00 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 64 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT NON-DEPARTMENTAL EXPENDITURES AMOUNT ADOPTED AMENDED FY 2013 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION Total $ 14,586,687.00 $ 13,236,986.00 $ 13,236,986.00 $ 0.00% 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 2,356,676.00 2,356,676.00 2,356,676.00 0.00% Bldg Auth Fac Infras IT Debt 2,200,000.00 2,200,000.00 338,700.00 1,861,300.00 84.60% Fay. due to budget anticipating a full year for debt service; actual debt schedule reflects that only one interest payment will be due in FY 2013. Building Fund 300,000 00 300,000.00 300,000.00 0.00% $ 7,130,861.00 $ 7,130,861.00 $ 5,269,561.00 $ 1,861,300.00 26.10% TOTAL NON-DEPT. APPROPRIATIONS $ 37,369,390.00 $ 37,275,304.00 $ 35,414,004.00 $ 1,861,300.00 4.99% TRANSFER TO GENERAL PURPOSE FUNDS Child Care Fund $ 22,568,532.00 $ 22,609,312.00 $ 22,609,312.00 $ 0.00% Social Welfare Fund Foster Care 1,000.00 1,000.00 1,000.00 0.00% $ 22,569,532.00 $ 22,610,312.00 $ 22,61 12.00 $ 0.00% TOTAL EXPENDITURES $ 59,938,922.00 $ 59,885,616.00 $ 58,024,316.00 $ 1,861,300.00 3.11% 3/7/2013
FY 2013 BUDGET AMENDMENTS
FY 2013 BUDGET AS ADOPTED - GENERAL FUND/GENERAL PURPOSE FUNDS
BUDGET AMENDMENTS
M.R. #12249 - 10/18/2012
Sheriffs Office - OCCMHA Agreement Continuation of Expanded JAWS & Related Positions
M.R. #12257 - 11/01/2012
County Executive - Auditing and Purchasing Reorganization
M.R. 11/01/2012
Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance)
$ 418,655,204.00
$ 128,626.00
$ (145,228.00)
M.R. #12270 - Springfield Twp.
M.R. #12271 - Brandon Twp.
M.R. #12272 - Orion Twp.
M.R. #12273 - Bloomfield Twp.
M.R. #12274 - Oakland Twp.
M.R. #12264 11/01/2012
Sheriffs Office - Contract Amendment for Law Enforcement Contract in Commerce Twp.
$ 24,279.00
$ 22,000.00
$ 22,333.00
$ 48,177.00
$ 31,235.00 $ 148,024.00
$ 21,768.00
M.R. 1112812012
Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance)
M.R. #12282 - Independence Twp. $ 50,000.00
M.R. #12283 - Highland Twp. $ 19,564.00
M.R. #12284 - City of Troy $ 46,667.00 $ 116,231.00
M.R. #12294 1112812012 $ 9,404.00
Circuit Court -2013 Michigan Drug Court Grant Program (Juvenile Treatment Court) Grant Acceptance
M.R. #12295 11128/2012 18,940.00
Circuit Court -2013 Michigan Drug Court Grant Program (Adult Treatment Court) Grant Acceptance
M.R. #12322 12/1312012
Management & Budget Fiscal Year 2012 Year-End Report and Budget Amendments
Encumbrances
Carry Forwards
M.R. #12304 12/13/2012
Circuit Court - FY 2013 Circuit Court Position Changes
M.R. #12336 12/13/2012
Clerk/Register of Deeds - Position Funding Changes and Creation of New Position
TOTAL AMENDED BUDGET AS OF 12/31/2012
$ 369,357.34
$ 2,117,410.00 $ 2,486,767.34
(30,430.00)
(44(,079.00)
$ 420,962,227.34
66
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT ENTERPRISE FUND TREASURER'S OFFICE ADOPTED AMENDED FY 2013 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES DELINQUENT TAX REVOLVING FUND 51600 REVENUES Charges for Services Other Revenues Total Revenues $25,000,000.00 $25,000,000.00 2,022,497.00 2,022,497.00 $27,022,497.00 $27,022,497.00 $18,750,000.00 ($6,250,000.00) -25.00% Unfav. Collection Fees ($2,000,000) due to lower number of parcels turned over as delinquent for tax year 2011. The number 01 delinquencies for the 2012 tax year is expected to be lower; to be determined in March 2013. Also, unfav. Interest on Delinquent Taxes ($4,250,000) due to slower collection rate for older delinquencies as well as decreasing number of older delinquencies. 1,946,797.00 (75,700.00) -3.74% Unfav. Income from Investments ($1,075,700) due to falling interest rates on investments. Offset by fay. Prior Years Adjustments $1000000 due to interest charges on older delinquencies; Michigan Tax Tribunal Decisions and local unit corrections during March, July and December Boards of Review. $20,696,797.00 ($6,325,700,00) -23.41% OPERATING EXPENSES Personnel Expenditures $ 106,968.00 $ 106,968.00 $ 106,968.00 0.00% Operating Expenditures 460,250.00 460,250.00 315,650.00 144,600.00 31.42% Fav. Indirect Costs due to actual charges determined after budget finalization. Interest Expense 1,750,000.00 1,750.000.00 100,000.00 1,650,000.00 94.29% Fay, related to lower debt interest rates/level of debt. Transfer Out to Other Funds: General Fund - Collection Fees 5,658,923.00 5,658,923.00 5,658,923.00 0.00% GF - Non-Departmental Work Release Facility Refunding Debt Svc Office Bldg Renovation Refunding Debt Svc 52-3 District Court Refunding Debt Svc Total Transfer Out to Other Funds Total Operating Expenses 10,800,000.00 1,620,900.00 1;873,699.00 1,305,800.00 $ 21.259,322.00 $ 23,576,540.00 10,800;000.00 1,620;900.00 1,873,699.00 1,305.800.00 21,259,322.00 $ 23,576,540.00 10,800,000.00 1,620,900.00 1,873,699.00 1.305,800.00 $ 21.259,322.00 $ 21,781,940.00 0.00% 0.00% 0.00% 0.00% 0.00% 7.61% - $ 1,794,600 00 REVENUE OVER (UNDER) EXPENDITURES* Total Net Assets - Beginning Total Net Assets - Ending $3,445,957.00 $3,445,957.00 ($1;085,143.00) $206,370,154,03 $205,285,011.03 ($4,531,100.00) Ending FY 2012 Designated Fund Balance*": NP-UnRes - Designated - Debt Service NP-UnRes - Designated - Delinq Taxes Receivable NP-UnRes - Designated - Collection Fees Undesignated - Fund Balance Total Net Assets - Ending $50,766,956 00 144,567,825 50 11,035,372.53 ($1,085.1,13 Oa) A.20.5,3„45,1, * Please note that in the Adopted Budget (line-item book) this is budgeted as 'Budgeted Equity Adjustwc, isa ,ategory. "* Please note the designated equity amounts are adjusted at year-end only 125 DTRF 51600 Quarterly Forecast.xlsx 3/7/2013
FY 2013 FIRST QUARTER REPORT ENTERPRISE FUNDS TREASURER ADOPTED AMENDED FY 2013 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES DELINQUENT PERSONAL PROPERTY TAX (51800) OPERATING REVENUE $1,017,158.00 $1,017.158.00 $519,558.00 ($497,600.00) -48.92% - Unfav. Administration Fees ($382,800) due to fewer delinquencies as well as finding more businesses that are not active as a going concern. Also,unfav. Miscellaneous rev line item ($114,858) due to budget established but no activity expected. OPERATING EXPENSE 1,078,477.00 1.078.477.00 1,045,377.00 33,100.00 3.07% - Fav. Controllable Personnel due to underfilled position. Also, favorable Professsional Services $95,600 due less activity, Postage-Standard Mailing $10.000 due to less anticipated use. Partially offset by unfav. Indirect Costs ($146,800) due to actual charges determined after budget finalization. NET OPERATING INCOME (LOSS) ($61,319.00) ($61,319.00) ($525,819.00) ($464,500.00) 757.51% NON-OPERATING REVENUE (EXPENSE) 125,000.00 125,000.00 11,500.00 (113,500.00) -90.80% Unfav. Income from Investments is due to lower cash balance and reduced rates. TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS $63,681.00 $63,681.00 $ (514,319.00) ($578,000.00) TRANSFERS OUT TOTAL NET INCOME (LOSS)* $63,681.00 $63,681.00 ($514,319.00) ($578,000.00) TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING 760,801 00 $246,482.00 * Please note that in the Adopted Budget (line-item book) this is budgeted as 'Budgeted Equity Adjustments" in the expense category. 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT ENTERPRISE FUND PARKS & RECREATION ADOPTED AMENDED FY 2013 VARIANCE BUDGET BUDGET FORECAST FAN(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OAKLAND COUNTY PARKS & RECREATION COMMISSION (50800) OPERATING REVENUE $ 8,650,623.00 $ 8,660,623.00 $ 8,660,623.00 0.00% OPERATING EXPENSE $ 22,958,010.00 $ 22,958,010.00 $ 22,958,010.00 $ 0.00% NET OPERATING INCOME (LOSS) $ (14,307,387.00) $ (14,297,387.00) $ (14,297,387.00) $ 0.00% NON-OPERATING REVENUE 9; 11,512,650.00 $ 11,512,650.00 $ 11,512,650.00 $ 0.00% (EXPENSE) TOTAL INCOME BEFORE TRANSFERS $ (2,794,737.00) $ (2,784,737.00) $ (2,784,737.00) $ 0.00% TRANSFERS IN $ - S - 8 $ CAPITAL IMPROVEMENT PROGRAM $ $ S TOTAL NET INCOME (LOSS)* $ (2,794,737.00) $ (2,784,737.00) $ (2,784,737.00) $ TOTAL NET ASSETS - BEGINNING 98,859,474.00 TOTAL NET ASSETS - ENDING 96,074,737.00 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT INTERNAL SERVICE FUND WATER RESOURCES COMMISSIONER ADOPTED AMENDED FY 2013 VARIANCE BUDGET BUDGET ACTUAL FAW(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES DRAIN EQUIPMENT FUND ( 63900) OPERATING REVENUES: Inside $27,831,635.00 $27,831,635.00 828,303 5 00$47200000 1.70% Fav - Reimbursement General $472,000 the result of inventory being tracked ,. through CAMS, offset by unfavorable Material and Supplies expense. -7.04% Unfav - External Dispatch Services ($5,000), External Equipment Rental ($10,000) and External Maintenance Contracts ($10,000) due to the SCADA billing for West Bloomfield Township ending because they are now on their own system. 1.59% -1.73% Unfav - Material and Supplies ($472,000) the result of inventory being tracked through CAMS, offset by favorable Reimbursement General revenue. Unfav - Laboratory Supplies ($4,000) a result that a budget needs to be developed for Idexx laboratory supply charges. Unfav - Drain Equipment Materials ($2,800) a result of no budget for materials that are being tracked through CAMS for use in rebillable repair jobs. Unfav - Information Technology Development ($9,000) for maintenance performed on the Automatic Meter Reading System. Outside 355,000.00 355,000.00 330.0 0 00 ($25,000.00) Total Revenue 28,186,635 00 28.186,635.00 28,633,635.00 447,000.00 OPERATING EXPENSES 28,254,135.00 28,254,135.00 28,742.035.00 (487,900 00) NET INCOME (LOSS) BEFORE (67,500.00) (67,500.00) (108,400.00) (40,900 00) 60.59% NON-OPERATING REVENUE/(EXPENSE) TRANSFER IN TRANSFERS (OUT) NET REVENUES OVER (UNDER) EXPENSES TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING 67,500.00 67,500.00 66,520.00 (1.000.00) -1.48% Unfav - Accrued Interest Adjustment for accrued booking adjustment for investment income. 0.00% 0.00% $0.00 $0.00 ($41,880.00) ($41,900.00) 4,553,906.66 $4,512,026.56 3/7/2013
CLAIMS PAID TOTAL OPERATING EXPENSES OPERATING INCOME (LOSS) $ 4,609,442.00 $ 4,609,442.00 $ 4,609,442.00 S (1,911,183.00) (1,911,183.00) (1,911.18:100) 768,500.00 768,500.00 768,500.00 0.00% 0.00% 0.00% COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT INTERNAL SERVICE FUND RISK MANAGEMENT ADOPTED AMENDED FY 2013 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 'LIABILITY INSURANCE FUND 67700 OPERATING REVENUES: Outside Revenue Inside Revenue 2,698,259.00 2,698,259.00 2,698,259.00 0.00% Total Operating Revenue $ 2,698,259.00 $ 2,698,259.00 $ 2,698,259.00 $ 0.00% OPERATING EXPENSE $ 3,840,942.00 $ 3,840,942.00 $ 3,8 0,942.00 0.00% - NON-OPERATING REVENUE (EXPENSE) 400,000.00 400,000.00 400,000.00 0.00% NET REVENUES OVER/(UNDER) EXPENSES $ (1,511,183.00) $ (1,511,183.00) (1,511.1 00) $ TOTAL NET ASSETS - BEGINNING 16,470,258.00 TOTAL NET ASSETS - ENDING 14,959,075.00 3/7/2013
COUNTY OF OAKLAND FY2013 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND !FRINGE BENEFITS FUND 67800 ADOPTED AMENDED BUDGET I3UDGET FY2013 VARIANCE FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OPERATING REVENUE RETIREES MEDICAL - VEBA DEBT 48,561,700 48,661,700 50,200,000 1,63 00 3.37% - Charges from departments favorable due to underestimated budget. RETIREMENT ADMINISTRATION 2,103,500 2,103,500 2,103,500 0.00% RETIREMENT ADMINISTRATION - PTNE 300,000 300,000 300,000 0.00% DEFINED CONTRIBUTION PLAN 14,350,000 14 350,000 14,350,000 0.00% DEFINED CONTRIBUTION PLAN - PTNE 175,000 175,000 175,000 0.00% EMPLOYEE IN-SERVICE TRAINING 1,361,000 1,361,000 1,361,000 0.00% EMPLOYEE BENEFITS UNIT 842,000 842,000 842,000 0.00% FLEX BENEFIT PLAN 200,000 200,000 200,000 0.00% WELLNESS UNIT 498,800 498,800 498,800 0.00% FRINGE BENEFITS 95,500 95,500 95,500 0.00% TUITION REIMBURSEMENT 260,000 260,000 260.000 0.00% RETIREMENT HEALTH SAVINGS 800.000 800,000 800,000 0,00% GROUP LIFE INSURANCE 650,000 650,000 550,000 0.00% SOCIAL SECURITY 15.000,000 15,000,000 15,000,000 0.00% MEDICAL INSURANCE 31,820,000 31 820,000 31,820 000 0.00% PRESCRIPTION COVERAGE INSURANCE 10,000,000 10 000,000 9,600,000 (400,000) -4.00% - Unfavorable due to increase in employee prescription co-pays. Offset by favorable expense. DENTAL INSURANCE 3,316,000 3,316,000 3,000 000 (316,000) -9.53% - Unfavorable due to projected costs less than budget projections. Offset by favorable expense. 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 216,500 216,500 216.500 2,500,000 2,500,000 2,500 000 10,500 10,500 2,683 800 2,683 800 2,683,800 800,000 800,000 800,000 542,900 542.900 542,900 5,000,000 5,000,000 5,000,000 280,000 280,000 280.000 600,000 600,000 600,000 25,000 25,000 25,000 2.500 2,500 2,500 350,000 350.000 350,000 115,000 115.000 116,000 105,000 105,000 105,000 20,000 20,000 920,000 900,000 2,000 2,000 4,000 4,000 150,000 150.000 150,000 143,624,200 143,624.200 145,463,000 1.838,800 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - Favorable due to International City Management Association (ICMA) forfeitures. 0.00% 0.00% 0.00% 1,28% 130 FRINGE BENEFIT FY2013 First Quarer Forecast.xls 3/7/2013
COUNTY OF OAKLAND FY2013 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND ADOPTED AMENDED FY2013 VARIANCE UDGET BUDGET FORECAST FAVI(UNFAV) PERCENT 'FRINGE BENEFITS FUND 67800 EXPLANATION OF SIGNIFICANT VARIANCES OPERATING EXPENSE RETIREES MEDICAL - VEBA DEBT PRINC. 20.520,000 20,520,000 RETIREES MEDICAL - VEBA DEBT INT. 28,041,700 28,041,700 RETIREMENT ADMINISTRATION 2,403,500 2,403,500 DEFINED CONTRIBUTION PLAN 14,500,000 14,500,000 DEFINED CONTRIBUTION PLAN - PTNE 175,000 175,000 EMPLOYEE IN-SERVICE TRAINING 1,011,000 1,011,000 IN-SERVICE TRAINING - INFO TECH 350,000 350,000 EMPLOYEE BENEFITS UNIT 842,000 842,000 FLEXIBLE BENEFIT PAYMENTS 200,000 200,000 WELLNESS PROGRAM 498,800 498,800 ACCOUNTING SERVICES 95,500 95,500 TUITION REIMBURSEMENT 260,000 260.000 RETIREMENT HEALTH SAVINGS 800.000 800,000 GROUP LIFE INSURANCE 900,000 900,000 SOCIAL SECURITY 15,000.000 15,000,000 MEDICAL INSURANCE 37,100.000 37,100,000 PRESCRIPTION COVERAGE 10,600,000 10,600,000 DENTAL INSURANCE 20,520,000 28,041,700 2,403,500 14,500 000 175.000 1,011,000 360.000 842,000 200.000 498,800 95,500 260,000 800,000 900,000 15.000,000 37,100,000 10.200,000 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 400.000 3.77% - Favorable due to increase in employee prescription co-pays Offset by unfavorable revenue. 316,000 9.14% - Favorable due to projected costs less than budget projections. Offset by unfavorable revenue. 3,456,000 3,456,000 3,140,000 VISION INSURANCE DISABILITY INSURANCE WORKERS COMPENSATION UNEMPLOYMENT COMPENSATION CHILD CARE FACILITY INDIRECT COSTS TOTAL EXPENSE 324.000 324,000 2,500,000 2,500,000 2,683,800 2,683,800 800,000 800,000 262,900 262,900 300.000 300,000 143,624,200 143,624,200 0.00% 0.00% 0.00% 0.00% 0.00% 49.500 16.50% - Favorable due to actual charges developed after budget finalization. 765.500 0.53% 324,000 2 500,000 2.683,800 800,000 262,900 250,500 142,858,700 NET REVENUE OVER/(UNDER) EXPENSES 0.00 0.00 2,604,300 2,604,300 TOTAL NET ASSETS - BEGINNING 25,084,093 • TOTAL NET ASSETS - ENDING 27,688,393 130 FRINGE BENEFIT FY2013 First Quarter Forecast.xls 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT ENTERPRISE FUNDS CENTRAL SERVICES ADOPTED AMENDED FY 2013 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OAKLAND COUNTY INTERNATIONAL AIRPORT (56500) OPERATING REVENUE $4,875,421.00 $4,875,421.00 $4,512,521.00 ($362,900.00) -7.44% - Unfav. T-hangar rental ($350,000) due to a decrease in number of T-hangars leased. OPERATING EXPENSE 6,646,949.00 6,646,949.00 6,595,749.00 51,200.00 0.77% - Fav; indirect cost $69,000 due to actual charges developed after budget finalization; unfav ad) prior years expense ($15,000) due to FY2012 expenses paid in FY2013. NET OPERATING INCOME (LOSS) ($1,771,528.00) ($1,771,528.00) ($2,083,228.00) ($311,700.00) 17.59% NON-OPERATING REVENUE (EXPENSE) 278,744.00 278,744.00 278,744 00 0.00 0.00% TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS ($1,492,784.00) ($1,492,784.00) $ (1,804,484.00) ($311,700.00) TRANSFERS IN CAPITAL CONTRIBUTION 1,586,804.00 1,586,804.00 1,586,804.00 $0.00 0.00% TOTAL NET INCOME (LOSS) $94,020.00 $94,020.00 ($217,680.00) ($311,700.00) TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING $ 82,639,500 00 $82,421,820.00 3/7/2013
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS CENTRAL SERVICES ADOPTED BUDGET AMENDED BUDGET FY2013 FORECAST VARIANCE FAVi(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES MOTOR POOL FUND 66100-1 OPERATING REVENUE: Outside Revenue 50,000.00 $ 50,000.00 $ 78,000.00 $ 28,000.00 56.00% - Fav. increase warranty reimbursement $25,500 due to GM warranty claims handled in-house; increase ext-productive labor $2,500 due to higher than expected CVT service. Inside Revenue 8,043,391.00 # 8,087,551.00 8,087,551.00 $ 0.00% Total Revenue S 8,093,391.00 $ 8,137,551.00 $ 8,165,551.00 $ 28,000.00 OPERATING EXPENSE 7,730,220.00 7,774,380.00 7,689,380.00 $ 85,000.00 1.09% - Fay. indirect cost $85,000 due to actual charges developed after budget finalization. OPERATING INCOME (LOSS) $ 363,171.00 $ 363,171.00 $ 476,171.00 $ 113,000.00 NON-OPERATING REVENUE (EXPENSE) 472,977.00 472,977.00 472,977.00 $ 0.00% NET INCOME (LOSS) BEFORE OPERATING TRANSFERS $ 836,148.00 $ 836,148.00 $ 949,148.00 113 000.00 TRANSFERS IN / (OUT) 79,000.00 79,000.00 $ NET REVENUE OVER/(UNDER) EXPENSES (PLANNED USE OF FUND BAL.)* $ 836,148.00 $ 915,148.00 S 1,028,148.00 $ 113,000.00 TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING S 8,984,238.00 S 10,012,386.00 3/7/2013
ADOPTED BUDGET AMENDED BUDGET COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT INTERNAL SERVICE FUND FACILITIES MANAGEMENT FY 2013 VARIANCE FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES FACILITIES MAINTENANCE & OPERATIONS (#63100) OPERATING REVENUES; Outside Revenue $353,000.00 $353,000.00 $330,300.00 (22,700.00) -6.43% - Lower External Agencies lease revenue for first quarter prior to Memorandom of Agreement with U.S. Dept. of Commerce for Commerce Connect & Export Assistance space located in Adm. Annex I ($13,100) and lease agreement with Road Commission at IT ($9,600) which was finalized subsequent to budget determination. 25,782,904.00 25.782,904.00 25,782,904.00 0.00% - $26,135,904.00 $26,135,904.00 $26,113,204.00 (822,700.00) -0.09% 825,352,415.00 $25,352,415.00 $24,457,615.00 $894,800.00 3.53% -Fav. Natural Gas/ Fuel Oil $450,000 due to lock-in of favorable long-term pricing contracts and moderate weather conditions: fay. Electrical Service $50,000 due to lower-cost third-party contracts and savings from energy conservation initiatives implemented by FM&O; fay. Indirect Costs $218,700 due to determination of costs subsequent to budget formulation; fay. Fringe Benefits $200,000 due to turnover; fay. Road Salt $25.000 reflecting expected road salt usage and implementation of new guidelines to reduce the amount of salt applied per run: fay. Garbage & Rubbish Disposal $60,000 due to reduced volume caused by recycling efforts: fav. Overtime $25,000 due to moderate weather conditions for snowplowing activity; and fav. Maintenance Supplies and Material & Supplies $20,000 based on required usage. Inside Revenue Total Revenue OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS $783,489.00 $783,489.00 $1,655,589.00 $872 00.00 Favorability is partially offset by unfav. Security Supplies ($40,000) due to increased security requirements and usage of account (with reduced usage of Maintenance Supplies account); Water and Sewage Charges ($50,000) based on required usage and settlement of past billings; Rent ($24,500) due to continuation of equipment storage; IT Development ($10,000) primarily for website enhancements: Motor Pool and Gasoline Charges ($17,500) based on required usage; and Drain Equipment charges ($15,000) for increased storm drain maintenance. NON-OPERATING REVENUE $137,500.00 $137,500.00 $112,500.00 ($25,000.00) -18.18% - Unfav. Investment Income due to low rate of return. TRANSFERS IN 0.00% - TRANSFERS OUT (2,266,000.00) (2,266,000.00) (2,266,000.00) 0.00% - NET REVENUES OVER(UNDER) EXPENSES* ($1,345,011.00) ($1,345,011.00) ($497,011 00) $847,100 00 TOTAL NET ASSETS - BEGINNING $12,415,135.56 TOTAL NET ASSETS - ENDING $11,917,224.56 133 FACILITIES INTERNAL FORE.xlsx 76 3/7/2013
($5,012,834.00) ($5,012,834.00) ($1,196,834.00) $3,816,000.00 180,500.00 180,500.00 137.600.00 (42,900.00) -23.77% Unfav. Interest Income due to lower rates and cash balance than anticipated. 2,406,676.00 2,411,871.00 2,411,871.00 0.00 000% OPERATING EXPENSES $30.911,401.00 $30,911,401.00 $25,596.201.00 $5,315,200.00 17.19% - Fav. Sal & FB $2,694,900 due to vacancies; Deprec $1,915.500 fully deprec equip not reflected in budget projection; Equip Maid t $374,100 due to lower than anticipated hardware maint costs; Indirect Cost $557,900: Communications $205,800 due to rate reductions; Software Lease $333,500, Copier $209,000 and Mem Dues $7,300 due to lower than anticipated costs; Service Bureau $75,000 due to phasing out of microfiche costs; Software Maint $17,500 due to timing of software support; Travel $58,500 due to decline in staff attending conferences; Supplies $112,100, Mileage $6,700 & Internal Svc $7,700 based on actual usage. Partially offset by unfav. Prof Svcs ($715,400) for previously approved IT projects; Expend Equip ($376,500) due to equip replacement & Contracted Svcs ($169,000) due to increase in costs, NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE TRANSFERS IN COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS! ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET AMENDED BUDGET FY 2013 FORECAST VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Information Technology - Operations (63600) OPERATING REVENUES: Outside Inside TOTAL OPERATING REVENUE $848,992 00 $848,992.00 $1,279,192.00 $430,200.00 50.67% - Fay. Enhanced Access Fees $147,200 due to increased customer usage; Sale of Equip $13,400 and Outside Agencies $270,600 due to external customer requests. 25,049,575.00 25,049,575.00 23,120,175.00 (1,929,400.00) -7.70% - Unfav. 00 Dept'l & Non Gov Dev ($1,698,000) due to rates remaining at prior year levels & limited resources available to complete development due to vacancies; OC Deptl Ops & Non Gov Ops ($800) actuals slightly lower than budget and Equip Rental ($230,500). $25,898,567.00 $25,898,567.00 $24,399,367.00 ($1,499,200.00) -5.79% TRANSFERS (OUT) 0 00% CAPITAL CONTRIBUTION 0.00 0.00% NET REV OVER(UNDER) EXP" ($2,425.658.00) $2,420,463.00) $1,352,637.00 $3,773,100.00 TOTAL NET ASSETS - BEGINNING 21,490,918.81 TOTAL NET ASSETS - ENDING $22,843,555.81 "Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of FundBalance" in the revenue category.
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS I ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET AMENDED BUDGET FY 2013 FORECAST VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Information Technology - Telephone Communications (67500) OPERATING REVENUES: Outside $30,000.00 $30.000.00 $14,600.00 $ (15,400.00) -51.33% Unfav. Sale of Phone External due to reduction in landline charges due to the closing of Golden Oaks. Inside 2,814000.00 2,814 000 00 2,632,700 00 (181,300 00) -6.44% Unfav. Sale of Phone Internal due to reduction in telephone landline rates. TOTAL OPERATING REVENUE $2,844,000 00 S2,844,000.00 $2,647,300.00 ($196,700 00) -6.92% OPERATING EXPENSES $3,316,247.00 $3,316.247.00 $2,856,247.00 $460,000.00 13.87% Fay. Indirect Cost $65,800: Tower Charges $5,300 due to decreased pager usage; Deprec $185,300; Sublet Repairs $40,000 due to lower than anticipated repair volume; Comm $172,000 subsequent to budget. Partially offset by unfav. Voice Mail ($10,500) due to higher than anticipated costs & Internal Svcs $6,400 due to actual usage. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE TRANSFERS IN TRANSFERS (OUT) NET REV OVER(UNDER) EXP* TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING 11.67% Fav. primarily due to Interest Income: higher cash balance than anticipated. 0.00% 0.00% ($472,247.00) ($472,247.00) 208,947 00) $263,300 00 30,000.00 30,000.00 33,500.00 3,500 00 ($442,247.00) ($442,247.00) ($175,447.00) $266,800.00 3,825,960 19 $3,650,513.19 Please note that in the Adopted Budget (line -item book) this is budgeted as "Planned use of Fund Balance" in the revenue category.
COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS! ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET AMENDED BUDGET FY 2013 FORECAST VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Information Technology - CLEMIS (53500) OPERATING REVENUES: Outside $3,720,978.00 $3,720,978.00 $3,822.878.00 $101,900.00 2.74% Fay. Maintenance Contracts $20,000 Livescan maint after warranty; Access Fee Oakland $27,800 due to actual law enforcement FTE count used for billing higher than budget projection; In-Car Terminals External $48,900 due to increase in fleet of CLEMIS agencies and Clemis Citation $35,200 due to increased usage by Oakland and non-Oakland agencies. Partially offset by unfav. CLEMIS Crash ($30,000) due to less than anticipated agencies participating in Crash program. Inside 2,118,396.00 2,118,396.00 2,090,196.00 (28,200.00) -1.33% Unfav. Reimb General ($32,000) based on actuals for CLEMIS staff supporting Sheriff projects Partially offset by fav In Car Terminals Internal $3,000 due to Mobile Data participation count higher than budget projection & OC Dept Ops $800 TOTAL OPERATING REVENUE $5,839.374.00 $5,839,374.00 $5,913,074.00 $73,700 00 1.26% OPERATING EXPENSES $8,165,042.00 $8,210,042.00 $7,571,742.00 $638,300.00 7.77% Fay. Sal & FB $678,000 due to vacancies; Fay. Prof Svcs $206,000 due to contractual services funded through grants for Records Management System upgrade; Rebill Svcs $15,000; Equip Maintenance $71,800 due to less than anticipated cost of repairs; Software Maint $150,000 due to timing of maintenance costs; Travel $1,000 due to reduced traveling to conferences; Comm $279,600 due to actual connectivity costs less than anticipated; Internal Svcs $1,900 based on actual usage. Offset by unfav. Bank Charges ($49,200) due to cost for paypal services for E-Commerce transactions; Indirect Cost ($14.400); Supplies ($2,400) based on usage; Deprec ($573,100) due to equipment that is fully depreciated; Software Lease ($126,000) for software purchases required by CLEMIS tech support. ($2,325,668.00) 35,000.00 2,044,186.00 NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE TRANSFERS IN ($2,370,608.00) ($1,658,668.00) $712,000.00 35,000.00 65,800.00 30,800.00 88.00% Fay. primarily due to Interest Income; higher cash balance than anticipated. 2,089,186 00 2,089,186 00 0.00% TRANSFERS (OUT) 0.00% CAPITAL CONTRIBUTION 0.00 0.00 0.00 0.00 0.00% NET REV OVER(UNDER) EXP* ($246,482.00) ($246,482.00) $496,318 00 $742,800 00 TOTAL NET ASSETS - BEGINNING 15,685,376.01 TOTAL NET ASSETS - ENDING $16,181,694.01 Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" in the revenLie cntngory and Budgeted Equity Ad) in Expenses.
Inside TOTAL OPERATING REVENUE OPERATING EXPENSES OPERATING REVENUES: Outside $6,303,139.00 $6,303,139.00 $6,300,139.00 ($3,000.00) -0.05% Unfav. Outside Agency Revenue ($54,900) due to fewer non-emergency agencies than anticipated and 6-911 ($228,100) due to decreased volume of users. Partially offset by fay. Refund Pr. Yr Exp $153,500 due to reimbursement of AT&T connectivity costs to towers and Antenna Site Mgt $126,600. 311,000.00 311.000.00 376,000 00 65,000.00 20 90% Fav. Parts Access $65,000 due to reimbursement by participating agencies for equip replacement $6,614,139.00 $6,614,139.00 $6,676,139.00 $62,000.00 0.94% $1024768200 $10,247,682.00 $9,204,782.00 $1,042,900.00 10.18% Fav. Sal & FB $98,800 due to FB rate; Deprec $1,826,900 due timing of additional capitalized costs for coverage enhancements at cell tower sites; Indirect Cost $27,900 subsequent to budget projection; Travel $5,000 due to decline in out-of-state training; Special Projects $20,000; Rebillable Svcs $500; Supplies $2,000, Printing $200, Util $21.000 & Internal Svcs $18,700 based on actual usage. Partially offset by unfav. Prof Svcs ($630,000) due to CAD Upgrade project; Tower Charges ($12,200) tower rent for addl sites due to coverage enhancements; Expendable Equip ($35.800) due to Next Generation 911 equip replacements; Mileage ($1,500) due to usage; Software Maint ($100,000) due to reclassification of E911 related costs & Software Lease ($199,300) due to the timing of software license purchases for new member agencies. COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2013 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Information Technology - Radio Communications (53600) NET INCOME (LOSS) BEFORE OPERATING TRANSFERS ($3.633,543.00) ($3,633.543.00) ($2,528,643.00) $1,104,900 00 NON-OPERATING REVENUE TRANSFERS IN TRANSFERS (OUT) CAPITAL CONTRIBUTION NET REV OVER(UNDER) EXP* 53,200.00 (126,800.00) 13.200.00 (486,000.00) -70 44% Unfav Interest Income due to lower cash balance than anticipated. 0.00% 0.00% 0.00% 180,000 00 180,000 00 13,200 00 (486,000 00) (486,000 00) ($3,939,543.00) ($3,926,343.00) ($2,948,243 00) $97810000 TOTAL NET ASSETS - BEGINNING 55,650,673.95 TOTAL NET ASSETS - ENDING $52,702,430.95 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.
$197,000.00 $197,000.00 $638,927.00 $197,000.00 $197,000.00 $638.927.00 COUNTY OF OAKLAND FY 2013 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS I ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET AMENDED BUDGET FY 2013 FORECAST VARIANCE FAV4UNFAVI PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ($441,927.00) ($441,927 00) Fire Records Management ( 53100) OPERATING REVENUES: Outside TOTAL OPERATING REVENUES OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE $207,800.00 $10,800.00 $207,800.00 $1080000 $637.927.00 $1,000 00 ($430,127 00) $11,800.00 5.48% Fay, primarily due to Outside Agencies participation. 5.48% 0.16% Fay. Sal & FE $22,100 due to vacancies; Software Maint $1,400 due to decrease in maintenance costs: Mileage $300 and Travel $500 due to decrease in staff traveling to off site conferences. Offset by unfav. Indirect Cost ($15,100); Deprec ($3,700) and Internal Svcs ($4,500) due to actual usage. 3,000.00 3,000.00 2,800.00 (200.00) -6.67% Unfav. Interest Income due to ower rates and cash balance than anticipated. TRANSFERS IN TRANSFERS (OUT) NET REV OVER(UNDER) EXP* 430,185.00 ($8,742.00 430,185 00 ($8,742.00) 430,185.00 $2,858.00 0.00% 0.00% $11,600 00 TOTAL NET ASSETS - BEGINNING 467,255.37 TOTAL NET ASSETS - ENDING $470,113.37 Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" In the revenue category and Budgeted Equity Ad) in Expenses.
2013 UNCOLLECTABLE HOME IMPROVEMENT LOANS
COMMUNITY DEVELOPMENT BLOCK GRANT
,
, CASE # HOMEOWNER BA DUE ADDRESS
964 Sandra Ward 1,643.17 7831 Highland Rd, White Lake 48383
I 1612 Russell Wozniak 6,993.00 8751 Troy, Oak Park 48237
2043 Lester & Jean Purdy $ 7,375.00 3315 Donley, Rochester Hills 48309 ,
2889 Helen Bolin $ 7,145.00 710 E Grand Traverse, Commerce Twp 4838',
Daniel & Linda Richards , , 3451 $ 7,000.00 2001 VanCourtland, Troy 48083 ,
3663 Theresa Walzer (Mazzie) $ 7,133.00 1506 Fumwall St, Orchard Lk 48324 ,
4053 Gracie Goss 9,878.00 540 Farnsworth, White Lake 48386
4396 David Richards 8,037.00 27670 Dartmouth, Madison Hts 48071
4522 Karen Adcock 9,600.00 439 E Glass, Ortonville 48462 ,
4637 Linda Mathews $ 8,415.00 27815 Brush, Madison Hts 48071
4657 _ Candice Riley $ 10,829.00 23049 Easterling Ave, Hazel Park 48030
5037 Christina I Mrock $ 14,748.33 2536 Massena, Commerce Twp 48382
5193 *Jamie & Sherry Nix $ 12,000.00 1684 University, Ferndale 48220
5229 Janice Abugow $ 11,189.00 1704 E Meyers, Hazel Park 48030
: 5390 Lisa Dulong $ 7,931.58 1695 E Hazelhurst, Ferndale 48220
5499 Monica M Trevas $ 13,339.00 6131 Borowy, Commerce Twp 48382
5538 Lavera G Knapp $ 13,685.00 1112 E Goulson, Hazel Park 48030
5860 Mary E Burns $ 15,496.00 23160 Cayuga Ave, Hazel Park 48030 I
5885 Carrie A Lonero $ 18,661.49 30241 Palmer, Madison Hts 48071
5943 Jerry & Antoinette Allan $ 15,021.68 33218 Meadowlark St, Farmington 48336 ;
5996 Marge Bedford $ 7,145.64 3012 Greenfield, Berkley 48072
6070 Debra S Zirwes 19,654.50 6340 Eastlawn, Clarkston 48346
6221 John & Linda Fura 13,865.92 230 Allen, Ferndale 48220
6274 Patricia Gray $ 22,585.25 2200 W Drahner Rd, Oxford 48371
6387 Leonard Switras 17,298.96 6 S Andrews St, Lake Orion 48362
6534 Karen A McCoy 3,935.00 4930 Mohawk, Clarkston 48348
6730 Rick & Susan Weaver 22,530.00 609 Elkinford, White Lake 48383
6609 Christopher & Lindsay Parsell $ 12,249.80 4044 Middlebury, Troy 48085
6873 Carlos & Marcia Gross 3,775.00 5360 Barkley, Commerce Twp 48382
6783 Larry & Karen Rohrback 17,145.00 906 Pinecrest, Ferndale 48220
6902 Emmanuel & Nouhad Najor $ 14,400.00 54 Hillsdale Rd, Bloomfield Hills 48302
6977 Bryan J & Tamara L Wilson $ 6,121.00 264 Oriole St, Commerce Twp 48382
6953 Stephen & Cecilia Matheson $ 26,777.00 4001 Groveland Rd, Ortonville 48462
7004 Alisa Planck $ 20,515.00 8760 Cooley Beach Dr, White Lake 48386
7007 Clinton Riley $ 18,261.00 3551 Newgate Dr, Troy 48084
,
TOTAL 432,379.32
,
Write offs 2013
Total Write offs: 35
82
2013 UNCOLLECTABLE HOME IMPROVEMENT LOANS
HOME INVESTMENT PARTNERSHIP ACT ACCOUNTS
CASE # HOMEOWNER BAL DUE ADDRESS
8140 Ronda L Cushing 9,855.00 3052 Garden Ct, Auburn Hills 48326
8219 Mary F Taylor 9,859.00 536 Donald, Clawson 48017
8528 Christa Sharp 12,322.00 23832 Harding, Hazel Park 48030
8547 Bobbie Jo Smith 13,101.00 135W Madge, Hazel Park 48030
8682 Brian Wright/Nicole Berge! 11,975.00 1820 E Madge, Hazel Park 48030
8709 Robert L Delaney 13,200.00 23415 Melville, Hazel Park 48030
8792 Marrie K Williams 2,000.00 27128 Barrington, Madison Hts 48071
8862 Loretta Hope Blankenship 14,975.00 5894 Dvorak St, Clarkston 48346 ,
9094 William Feschuk $ 19,460.00 2393 Vermont, Troy 48083
9746 Ricky & Rosemarie Meyers $ 6,370.00 5197 Westview, Clarkston 48346 f 9791 Rosa Jones 17,760.00 15251 Pearson, Oak Park 48237
9916 Shirley Haley 17,585.00 3160 Crooks Rd, Rochester Hills 4830.c,-
10050 Gustave Rinz $ 5,400.00 340 W Maplehurst, Ferndale 48220 .
10115 Michael & Carmela Wood 4,815.00 5091 Frankwill Ave, Clarkston 48346
10122 Gail M Rader. 12,375.00 10640 Saratoga, Oak Park 48237
10300 Sarah E Flum 10,300.00 729 E Pearl, Hazel Park 48030
10311 *Jamie & Sherry Nix 10,580.00 1684 University, Ferndale 48220
10347 James & Wanda Hurst 12225.00 23471 Oneida, Oak Park - 37
10513 Darlene A Dover 3,873.00 1628 E Jarvis Ave, Haze;
1 0528 Lindsay Robinson 19,985.00 375W Pearl Ave, Hazel Par - 48030
,
TOTAL 248, 15.00 ,
,. ,
774. g
TOTAL AMOUNT UNCOLLECTIB E 68 ,394.32
. Write o7/12 to 12/12
*Client has more than one loan
Total Write offs: 20
Grand total write offs: 55
83
Memorandum
To: Monica Tinsley
From: Dan Hunter
Date: February 25,2013
Re: 1st Qtr '13 Budget Amendment
Revenues from FY 2012 and the Medical Main Street inaugural InnoVention
conference held on 10-4-12 should be included in this quarter. The program
sponsors who made donations by 9-30-12 are as follows:
PNC Bank
Oakland Co. Medical Society
DMC- Huron Valley Hospital
Huntington Bank
Karmanos Cancer Institute
Oakland University
St. Joseph Mercy Oakland County
I'vIcLaren-Oakland
Beringea, LLC
Oakland Community College
Clark Hill
Beaumont Hospitals
Health Alliance Plan
Detroit Chamber of Commerce
City of Southfield DDA
Henry Ford Health System
The amount sponsored by the above entities totals $100,000.
Other sponsors whose checks were received after 9-30-12 and thus in the current
EAT 1 1 atc.
St. John Providence
Verizon Wireless
Ticket Leap
These sponsorships total $34,131.04 -
Thanks for your assistance.
Memorandum
To: Monica Tinsley
From: Dan Hunter
Date: February 26, 2013
Re: MEDC Reimbursement Check
We received a check for S5001.75 from the Michigan Economic Development
Corporation to offset some of our costs within Planning & Economic Development
Services whereby additional user licenses were obtained for staff Please do a first
quarter budget amendment to transfer the money to software maintenance
(#731780).
Let me know if you have any questions and thanks for you assistance.
Economic Development &
Community Affairs
Marketing & Communications
MEMORANDUM
To:
From:
CC:
Re:
Date:
Monica Tinsley — Fiscal Services
Steve Huber, Marketing & Communications Officer
Matt Gibb, Irene Spanos, Dan Hunter, Tim Soave
Fifth Third Bank/Business Roundtable Sponsorship
Feb. 27, 2013
The Department of Economic Development & Community Affairs is
charged with administration of the Oakland County Business Roundtable.
The roundtable, which is comprised of members from business, education,
government and the community, holds an annual meeting each year. Fifth
Third Bank sponsors the annual meeting breakfast, which was held Dec. 7,
2012 at the Troy Marriott. The bank pays for the entire event, which
includes food, a small gift for each attendee, the printing of the annual
report and the cost of having WJR and Paul W. Smith broadcast live from
the event. In exchange, the bank is credited as the event sponsor. The
bank issued a check for $24,000 to the department.
U1N INC Nature Center Donation Misc (nutreach, Tuning Your Tot CD) $5.00 INC Nature Center Donation Misc (Outreach, Tuning Your Tot CD) $5.00 Independence Oaks Nature Center Total $5.00 LYE PoochPeople, Inc. Howl-O-Ween Bash - FY2013 $250.00 LYP Pawsitive Steps, LLC Howl-O-Ween Bash - FY2013 $100.00 LYP Roadside Veterinary Howl-O-Ween Bash - FY2013 $250.00 LYP Great Lakes Caring Howl-O-Ween Bash - FY2013 $50.00 LYP Lyon Veterinary PLLC Howl-O-Ween Bash - FY2013 $100.00 LYP Fetchin Stixx Howl O-Ween Bash - FY2013 $50.00 Lyon Oaks Park Total $800.00 REC 2013 Paraolympic Programming Contribution United State Olympic Committee $500.00 REC Adaptive Services - Youth Abilities Program Anne Taglione $250.00 Recreation Programs & Services Total $500.00 RNC Nature Center Donation General Operating Donation - Greeting Card Program $10.00 RNC Nature Center Donation General Operating Donation (Feed for Animals) $2.00 Red Oaks Nature Center Total $12.00 _ ,........ Grand Total $1,572.00 Par,;_firof 1
Resolution #13064 March 21, 2013
Moved by Hoffman supported by McGillivray the resolutions (with fiscal notes attached) on the amended
Consent Agenda be adopted (with accompanying reports being accepted).
AYES: Dwyer, Gershenson, Gingell, Gosselin, Hatchett, Hoffman, Jackson, Long, Matis,
McGillivray, Middleton, Quarles, Runestad, Scott, Spisz, Taub, Weipert, Woodward, Zack,
Bosnic, Crawford. (21)
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).
HEREBY APPROVE THIS RESOLUTION
U'_:-1:11 COUNTY EXECUTIVE
ACTING PURSUANT TO MCL 45.559A (7)
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Lisa Brown, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true and
accurate copy of a resolution adopted by the Oakland County Board of Commissioners on March 21,
2013, 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 21 st day of March, 2013.
Xfrge e/
Lisa Brown, Oakland County