HomeMy WebLinkAboutResolutions - 2022.03.24 - 35385<.@
POakr r
COUNTY MICHIGAN
BOARD OF COMMISSIONERS
March 24,2022
MISCELLANEOUS RESOLUTION #22-093
Sponsored By:Gwen Markham
IN RE:Managementand Budget -M&B Quarterly Report Fiscal Year 2022 First Quarter Financial
Forecast and Budget Amendments
Chairperson and Membersof the Board:
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 variances between estimated revenue and projected expenditures,amendments are required;and
WHEREAS the Fiscal Year (FY)2022 First Quarter Financial Forecast Report has identified several variances and budget
amendments are recommended;and
WHEREAS a FY 2022 budget amendment of $1,900 is recommended for the Prosecutor's Office to reallocate a portion ofthesalariesbudgettotheexpenditurelineitemforContractedServices(Account 730373)as the summer Law Clerk
position (PO00015060)has been frozen.The Prosecuting Attorneys Association of Michigan (PAAM)is providing the
summer law clerk services;and
WHEREAS the Sheriffs Office receipt of forfeiture/enhancement funds are recorded in separate restricted funds that
require a transfer to the General Fund for use of the monies.Transfers-In from the various restricted funds in the amountof$31,093 is being recognized for eligible personnel,forensic lab and training costs for dispatchers and correctionsofficers,of which $10,000 is being returned as a donation was received in FY 2021 to purchase a K-9.Therefore,restricted funds of $10,000 werenot utilized in FY 2021;a refund of $10,000 is being returned to the K-9 Program;and
WHEREAS a FY 2022 budget amendment of $5,000 is recommended for the Sheriff's Office to recognize an additionalallocationfromtheOfficeofNationalDrugControlPolicyforthe2020HighIntensityDrugTraffickingAreas(HIDTA)grant,amendment #3.The money will be used to purchase supplies for detectives to use during their investigations andoperationinthefield($4,103.00)and Cellular Telephone Services ($897.00).The amendment also extends the deadlinetousethesefundsandreportingtoDecember31,2021.Amendment #3 is less than fifteen percent of the originalagreement(M.R.#20226):and
WHEREAS a FY 2022 -FY 2024 budget amendment of $1,354,697 is recommended for the Sheriff's Office to reallocatebudgetsbetweendivisionsandprogramstomoreaccuratelyreflectthebudgetswithactualactivity;and
WHEREAS a FY 2022 -FY 2024 budget amendment of $895,697 is recommended for the Sheriffs Office to reallocatebudgetsbetweenprogramstomoreaccuratelyreflectthebudgetswithactualactivity;and
WHEREAS a FY 2022 budget amendment is recommended to transfer funding in the amount of $29,133 from the BoardofCommissionersGeneralFundbudgettotheProjectWorkOrderFundforofficespacemodifications.The project fallsunderthe$30,000 threshold for capital improvement projects per Miscellaneous Resolution #15231 and allowsadministrativeapprovalbyboththeDirectorofFacilitiesManagementandtheFiscalOfficer(or designee)if funding isavailable.Funding of $29,133 is available in the Board of Commissioners Library Continuations line-item budget (Account731101)as $60,000 was carried forward from the FY 2021 Year End Report for office space modifications as the LibraryResourceCenteriswindingdown;and
WHEREAS a FY 2022 —FY 2024 budget amendment of $300,000 is recommended for the Board of Commissioners toreallocatethebudgetfromProfessionalServicesexpenditureline-item (Account 731458)to Special Projects expenditureline-item (Account 731822):and
WHEREAS a budget amendment totaling $10,909 for FY 2022,$16,036 for FY 2023 and $16,839 for FY 2024,is
recommended for Compliance Office and Fiscal Services for the ongoing costs of annual software licenses;and
WHEREAS a FY 2022 —FY 2024 budget amendment totaling $1,700 is recommended for the Health Division to
reallocate the Medical Supplies expenditure line-item budget (Account 750301)from the Health Hearing and Vision unit
(1060237)to the Health Clinic unit (1060234);and
WHEREAS a FY 2022 budget amendment totaling $1,719,344 is recommended for the Health Division to reclassify the
Local Community Stabilization Authority carryforward budget to grant project number 100000003577;and
WHEREAS a FY 2022 -FY 2024 budget amendment totaling ($694,931)is recommended for the Health Division
removing the budgets for the 2021 Local Community Stabilization Authority (LCSA)Health Distribution grant project
100000003242 as the grant funding has ended;and
WHEREAS a FY 2022 budget amendment totaling $961,102 is recommended to recognize the receipt of funding for the
FY 2022 LCSA Health Distribution (grant project 100000003577);and
WHEREAS a FY 2022 — FY 2024 budget amendment totaling $1,916,175 is recommended for the Health Division
removing the salaries and fringe benefits of sixty part-time non-eligible 1,000-hour Public Health Nurse II positions which
had a sunset date of July 30,2021.The position budgets were created to provide nurses to County school districts to
mitigate COVID concerns (M.R.#20639);and
WHEREAS a FY 2022 —FY 2024 budget amendment totaling $570,072 is recommended for the Health Division to
transfer position budgets from Health Promotion Services (1060241)to Public Health Nursing Services (1060230);and
WHEREAS a FY 2022 —FY 2024 budget amendment totaling $3,174,276 is recommended for the Health Division
correcting the revenue budgetsto reflect their respective grant projectidentification numbers;and
WHEREAS a FY 2022 —FY 2024 budget amendment totaling $16,000 is recommended for the Health Division to
reallocate expenditure line-item budgets for Equipment Maintenance (Account 730646),Interpreter Fees (Account
730982),Membership Dues (Account 731213)and Personal Mileage (Account 731346)from the Health Promotion unit
(1060241)to the Field Nursing unit (1060230);and
WHEREAS a FY 2022 -FY 2024 budget amendment of $77,596 is recommended for the Health Division removing the
General Fund budget for the Interlocal Agreement with Oakland Intermediate School District (M.R.#21014)as Oakland
Schools has terminated the contract;and
WHEREAS a FY 2022 budget amendment is recommended for the Animal Control Division to accept reimbursement
funding of $1,750 from the October 4th -10th Bissel Pet Foundation's Empty the Shelter event.M.R.#19006 authorizes
Management and Budget to administratively process grant agreements and grant amendments of $10,000 or less,after
review and approval by Management and Budget,Human Resources,Risk Management and Corporation Counsel when
the grant does not require an associated interlocal agreement,there are no position changes,and the grantor does not
require a separate resolution;and
WHEREAS a FY 2022 budget amendment totaling $62,067 is recommended for the Economic Development Division toreallocatethebudgetfromtheformerMarketing&Communications unit (1090108)to the Planning and Local Business
Development Admin unit (1090201);and
WHEREAS a FY 2022 budget amendment in the amount of $6,026.52 is recommended for the Veteran Services Divisiontoreallocatethebudgetforencumbrancesfromtheinactiveunitof1090702tothenewunitnumberof1090401asVeteranServiceswasreorganizedandtransferredfromWorkforceDevelopmentdivision(M.R.21195 EconomicDevelopment/Workforce Development and Veterans Services Division —Reorganization of Positions);and
WHEREAS an acknowledgement of acceptance of $3,500 is recommended for the Veterans Services Division for the FY2021reimbursementfromtheMichiganVeteransAffairsAgency(MVAA)for the FY 2021 training.The training ensuresthatcountycounselorsreceivetherequiredContinuedEducationUnits(CEU's)on veteran’s benefits,laws,andprocedures.M.R.#19006 authorizes Management and Budget to administratively process grant agreements and grantamendmentsof$10,000 or less,after review and approval by Management and Budget,Human Resources,RiskManagementandCorporationCounselwhenthegrantdoesnotrequireanassociatedinterlocalagreement,there are nopositionchanges,and the grantor does not require a separate resolution.A budget amendment is not required as thereimbursementwasreceivedinFY2021:and
WHEREAS a FY 2022 budget amendment totaling $61,242 is recommended for Emergency Management and Homeland
Security Health Division correcting the funding from grant project number 100000003595 to grant project number
100000003305;and
WHEREAS a FY 2022 budget amendment of $12,988 is recommended for the Children's Village Division correcting the
Info Tech Operations expenditure line-item budgets as the budget was inadvertently made to inactive unit of 1060501.Per
M.R.#20202 Human Resources —Transfer of Divisions between County Executive Departments,Children's Village
transferred from the Department of Health and Human Services to the Department of Public Services;and
WHEREAS a FY 2022 -FY 2024 budget amendment of $209,650 is recommended for Non-Department correcting Grant
Match (Account 730800)as the budget was posted to the Juvenile Sentencing expenditure account (740084)in error.The
grant match is for the Prosecuting Attorney's FY 2021 Cooperative Reimbursement Program (CRP)Grant award
referenced in Management and Budget's Year End Report (M.R.#21507).The Year End Report’s Schedule A had a
typographical error in which the Account Title for Grant Match was reflected correctly,however it referenced the incorrect
account number of 740084;and
WHEREAS a FY 2022 budget amendment totaling $4 is recommended for the County Executive's Office of Public
Communication division (10106)correcting the budget for Fringe Benefit Adjustment as too much was taken out.
Organizationally,the division is no longer under the County Executive as it became its own department and retitled as
Department of Public Communications (M.R.#21323);and
WHEREAS a budget amendment totaling $153,375 FY 2022 and $150,260 for FY2023 -FY 2024 is recommended for the
Workforce Development Division (1090701)correcting the Salaries Regular (Account 702010)and Fringe Benefit
Adjustments (Account 722900)due to the timing of the budget development and reorganization of the department (M.R.
#21195):and
WHEREAS the Mandated Indigent Defense Commission (MIDC)(Budget Adjustment #1)authorized an increase of
$28,240.27 for salaries and fringe benefits for the Director of Indigent Defense Office and (Budget Adjustment #2)
authorized an increase of $6,357.28 for salaries and fringe benefits for the Indigent Defense Office Supervisor.The
adjustments are less than five percent of the entire salaries and fringe benefit category.A budget amendment is not
required as there is sufficient favorability within the County’s Mandated Indigent Defense Fund (#20260)Controllable
Personnel category to cover the increase in salaries and fringe benefits;and
WHEREAS Amendment #1 to the Sheriffs Office FY 2021 Edward Byrne Memorial Justice Assistance Grant (JAG)
Program adds 2 additional personal computers and 12 additional monitors for the Emergency Communications
Operations division based on the updated quote.This amendment has no impactto the overall grant award amount and
therefore a budget amendment is not required;and
WHEREAS a FY 2022 budget amendment of $14,195 is recommended for the Sheriffs Office to recognize Amendment#1 to the FY 2020 DNA Capacity Enhancement and Backlog Reduction (CEBR)grant which is under 15%.The
amendment is reallocating the budget between salaries and fringe benefits,causing no impact to the overall FY 2020
grant award;and
WHEREAS a FY 2022 budget amendment totaling $61,587 is recommended for the Health Division to recognizeAmendment#2 to the FY 2022 Emerging Threats Local Health Department Agreement increasing total funding from$10,615,940 to $10,677,527 (M.R.#21347).Amendment #2 is under 15%of the original agreement (M.R.#21347);and
WHEREAS a FY 2022 budget amendment totaling $2,342,656 is recommended for the Health Division correcting thebudgetsoftheLocalHealthDepartment(Comprehensive Grant)(M.R.#21435);and
WHEREAS a FY 2022 budget amendment of $4,382 is recommended for Central Services Airport and Aviation Fund(#56500)to reallocate the expenditure line-item budget from Professional Services (Account 731458)to Info TechOperations(Account 774636)for the one-time purchase of a laptop to accommodate working remotely.Also,the FY2023-FY 2024 budgetstotaling $3,352 is amended for ongoing Information Technology support;and
WHEREAS a budget amendment of ($95,000)for FY 2022,($115,000)for FY 2023,and ($136,000)for FY 2024 isrecommendedforCentralServicesAirportandAviationFund(#56500)correcting the Interest Expense expenditure line-item budget as the debt for the Oakland County International Airport Terminal debt was refinanced in 2020:and
WHEREAS a FY 2022 -FY 2024 budget amendment of $477,808,$468,438,and 468,438,respectively,is recommended
for the Workforce Development Fund (#29801)correcting the transposition error for expenditure line-item budgets,
Program (Account 731465)and Retirement Health Savings (Account 731645);and
WHEREAS a FY 2022 budget amendment is recommended for Facilities Maintenance &Operations (#63100)to
reallocate $12,979 from Radio Communications expenditure line item (Account 777560)under FMO Building Safety
(Department 1040770)to Radio Communications expenditure line item (Account 777560)under Building Safety Division
(Department 1110102)due to reorganization of departments (M.R.#20461 Transfer of Homeland Security and Building
Safety);and
WHEREAS a FY 2022 budget amendment totaling $8,581 is recommended for Parks and Recreation Commission
(#50800)to adjust the following:Revenues:Refund Prior Year Expenditure of $3,631 for an overbilled item and reflect a
gain on the sale of equipment of $4,950.Adjustments to expenses include the following:window replacement $228,690,
golf cart purchases $136,059,building maintenance $31,500,and slide pool marcite replacement activity $32,250
approved by the Parks Commission during the first quarter of FY 2022.Also,to allocate funds from the General Program
Administration account $41,589 to various parks incurring maintenance project costs during the first quarter of FY 2022
and to adjust the Transfer to Municipalities account to reflect payment made in FY 2021 for the Normandy Oaks Park
partnership program ($213,080)as well as to reflect the discontinuance of the auditing function at Parks and Recreation
($40,385);partially offset by Budget Equity Adjustments of ($208,042);and
WHEREAS a FY 2022 budget amendment of $378,217 is recommended for Radio Communications Fund (#53600)
increasing Interest Expense as the budgetis not sufficient to cover the interest portion of the debt payment;and
WHEREAS the Department of Public Services,Children’s Village Division received donations for the period of October
2021 through December 2021 totaling $31,156.60,of which $2,755 was a cash donation;and
WHEREAS the Parks and Recreation Commission received donations for the period of October 2021 through December
2021 totaling $26,305.26;and
WHEREAS the Department of Public Services,Animal Shelter and Pet Adoption Center received donations for the period
of October 2021 through December 2021 totaling $21,794.18;and
WHEREAS the Oakland County Department of Economic Development,Neighborhood Housing Division has attempted to
collect funds from loan recipients for the Home Investment Partnership Act Accountstotaling $18,095 and recommends it
be written off as an uncollectible loan;and
WHEREAS the Parks and Recreation Commission has requested write-offs totaling $4,317 for the period of October 1,
2021,through December 31,2021,for uncollectible transactions;and
WHEREAS the Human Resources Department has requested a write-off totaling $1,809.16,of which $763.74 is for FY
2022 for the period of October 1,2021,$159.35 for FY 2021 Second Quarter (February 16,2021 -through March 1,
2021),$599.77 is for FY 2021 Third Quarter (May 4,2021 through June 22,2021),and $286.30 FY 2021 Fourth Quarter
(Year End August 10,2021 through September 14,2021)for uncollectible healthcare contributions due to benefitcontributionsarrearages-post separation.
NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year 2022 First Quarter
Financial Report.
BE IT FURTHER RESOLVED that the donations be recognized by the Children’s Village Division,Animal Shelter and Pet
Adoption Center,and the Parks and Recreation Commission.
BE IT FURTHER RESOLVED that the uncollectible debts,as recommended by the Department of Management andBudgetanddetailedintheattachedschedules,are authorized to be written off.
BE IT FURTHER RESOLVED that the FY 2022 —FY 2024 Budgets are amended pursuant to Schedules A and B.
Chairperson,the following Commissioners are sponsoring the foregoing Resolution:Gwen Markham.
J;Date:March 24,2022
David Woodward,Commissioner
7 (haw Date:March 28,2022
Hilarie Chambers,Deputy County Executive II
‘
/
Lisa Brown,County Clerk /Register of Deeds
Date:March 29,2022
COMMITTEE TRACKING
2022-03-16 Finance Committee -recommend to Board
2022-03-24 Full Board
VOTE TRACKING
Motioned by Commissioner Gwen Markham seconded by Commissioner Philip Weipert to adopt the attached
M&B Quarterly Report:Fiscal Year 2022 First Quarter Financial Forecast and Budget Amendments.
Yes:Michael Gingell,Michael Spisz,Karen Joliat,Kristen Nelson,Eileen Kowall,Christine Long,Philip
Weipert,Gwen Markham,Angela Powell,Marcia Gershenson,William Miller III,Yolanda Smith Charles,
Charles Cavell,Penny Luebs,Janet Jackson,Gary McGillivray,Robert Hoffman,Adam Kochenderfer (18)
No:Thomas Kuhn,Charles Moss (2)
Abstain:None(0)
Absent:(0)
The Motion Passed.
ATTACHMENTS
1.lst QUARTER FORECAST
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 andaccuratecopyofaresolutionadoptedbytheOaklandCountyBoardofCommissionersonMarch24,2022,with
the original record thereof now remaining in myoffice.
In Testimony Whereof,I have hereunto set my hand and affixed the seal of the Circuit Court at Pontiac,
Michigan on Thursday,March 24,2022.
Lisa Brown,Oakland County Clerk /Register ofDeeds
matin &
POaKu S
COUNTY MICHIGAN OAKLAND COUNTY EXECUTIVE DAVID COULTER
MANAGEMENT &BUDGET
|
TO:Members of the Finance Committee
FROM:Kyle Jen,Director,Management and Budget
Lynn Sonkiss,Manager,Fiscal Services
Holly Conforti,Chief,Fiscal Services
Kymberly Coy,Chief,Fiscal Services
Ebru Adoglu-Jones,Supervisor of Fiscal Services
SUBJECT:Letter of Transmittal -Fiscal Year 2022 First Quarter Forecast
DATE:March 16,2022
FY 2022 FIRST QUARTER REPORT
Attached please find the Fiscal Year (FY)2022 First Quarter Forecast Report.In total,Fiscal Services
forecasts that the County will complete FY 2022 with an overall favorable variance of $10,317,333
General Fund/General Purpose (GF/GP)operations,compared to the amended budget.GF/GP
includes all operations except grants,enterprise funds,and internal service funds.This overall
favorability is the net result of receiving ($5,113,067)less revenue than anticipated and projected
favorability in expenditures of $15,430,400.
Accounting for planned Use of Fund Balance included in the adopted FY 2022 budget and adopted
resolutions funded by Use of Fund Balance,this forecast projects that the county’s General Fund
balance will decrease by $23.1 million by the end of Fiscal Year 2022.
REVENUES
GF/GP revenues are .99%less than budgetor ($5,113,067).Major variances are the result of the
following events:
A.STATE GRANTS —Unfavorable:($2,905,248)
Unfavorable primarily due to less than anticipated reimbursement from the State on eligible
childcare costs;this is offset by Child Care Fund expenditure favorability.
B.OTHER INTERGOVERNMENTAL REVENUE -Favorable:$177,483
Favorable primarily due to the State’s updated Revenue Sharing increase of $487,483,offset by
unfavorable ($250,000)State Court Disbursement PA 189,and Sheriff's Social Security Income
payment ($60,000)because of reduction in inmate population.
C.CHARGES FOR SERVICES —Unfavorable:($684,800)
Unfavorable Ordinance Fines and Costs ($2,075,000),Probation Fees ($760,000)and State
Law Costs ($150,000)across the District Courts for the reduction in caseloads due to COVID-19
pandemic;Sheriffs Office ($800,000)Diverted Felon,($750,000)Drug Testing,($350,000)
Commissions Contracts,($195,000)Civil Action Service Fees,and ($160,000)Fingerprints and
Photostats due to reduced activity;which is primarily due to the pandemic.Further reductions in
activity due to the COVID-19 pandemic include Court Costs ($100,000),Mediation Fees
($100,000)Jury Fees,and ($100,000)Board and Care due to less than anticipated revenue
2100 Pontiac Lake Road |County Executive Building 41W |Waterford,MI 48328 |Fax (248)452-9172 |OakGov.com 4
within Circuit Court;and ($145,000)Community Corrections Fee Income due to suspension of
the Weekend and Weekday Alternative for Misdemeanants (WWAM)program.
This is partially offset primarily due to favorability in the Clerk’s Office $3,000,000 Land Transfer
Tax and $100,000 Mortgages due to increased activity;and $2,000,000 Children’s Village Out
County Board and Care due to Department of Health and Human Services placements.
D.INVESTMENT INCOME —Unfavorable:($1,634,549)
Unfavorable due to investment base and market rate adjustment.
EXPENDITURES
In total,expenditures are projected to be 2.99%under budget or $15,430,400 favorable.Many
departments have experienced personnel savings as the result of turnover and under-filling of
positions.There is a $6.2 million personnel favorability factor and a $4.8 million operating expenditure
favorability factor already included in the budget under non-departmental General Fund.As the year
progresses this overall net favorability may increase as departments continue to work to reduce their
costs and streamline operations.Below is a summary of the budget to actual comparison for the
General Fund/General Purpose operations.Detail sheets for each Department/Division showing
variances with explanations is contained in the FY 2022 Expenditure Explanation section of this report.
TOTAL DEPARTMENTS
Expenditures Adopted Budget Amended Budget Actual Fav.(Unfav.)%
Personnel $318,546,546.00 $320,120,426.00 $309,650,626.00 $10,469,800.00 3.27%
Operating $54,124,394.00 $73,814,829.10 $66,409,129.10 $7,405,700.00 10.03%
Internal $62,473,394.00 $63,895,615.00 $64,140,715.00 $(245,100.00)-0.38%
Transfers $10,582,464.00 $12,858,879.00 $12,858,879.00 $-0.00%
Total Department Expenditures $445,726,798.00 $470,689,749.10 $453,059,349.10 $17,630,400.00 3.75%
Total Non Departmental $45,996,218.00 $46,190,609.03 $48,390,609.03 ($2,200,000.00)4.76%
Total Governmental Expenditures $491,723,016.00 $516,880,358.13 $501,449,958.13 $15,430,400.00 2.99%
There are no departments forecasted to be unfavorable at the overall department level at the end of the
fiscal year.However,there will likely be adjustments between the controllable budget categories.Note
that while individual divisions may be over budget,the budget is controlled at the departmentlevel.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 budgetfor 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.
2100 Pontiac Lake Road |County Executive Building 41W |Waterford,MI 48328 |Fax (248)452-9172 |OakGov.com 2
Forecast Presentation —Budgetary Perspective
The presentation reflects the current best assessment offiscal activity for FY 2022:
Revenues -over/(under)budget $(5,113,067)
Expenditures —(over)/under budget 15,430,400
Total Officially Reported Favorability $10,317,333
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 $33,432,819 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.The FY 2022
adopted budget for the Planned Use of Fund Balance started out at $16,544,257 and there have been
resolutions authorized during first quarter of FY 2022 to bring it to the $33,432,819 level as of
December 31,2021.This includes approximately $12.2 million of carry forward requests and
encumbrances.In addition,there was $2,250,000 for estimated settlements related to the Rafaeli Case
and $600,000 initial support of County’s response to the Oxford High School shooting incident that
were both approved with the FY 2021 Year End Report resolution (M.R.#21507).Furthermore,there
was use offund balance related to the Board of Commissioner's appropriation of $2,059,796 for the
body warn camera policy and implementation program (M.R.#21529).Thus,when Use of Fund
Balance is removed from the revenue calculation,the impact on the County’s official financial
statementsis:
Revenue Variance $(5,113,067)
Reduce —Planned use of Fund Balance (33,432,819)
Revenue Variance $(38,545,886)
Expenditure Variance (Comparing Actual to Approved Plan)15,430,400
GAAP Reported Effect on Fund Balance $(23,115,486)
It is important to analyze the forecast using both the Budget perspective and the GAAP perspective to
accurately reflect the impactof fiscal activity generated from FY 2022 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 and the stringent scrutiny applied to all requested expenditures.
The GAAP perspective provides information as to the effect on Fund Balance.This forecast projects
that the General Fund balance will decrease by $23.1 by the end of Fiscal Year 2022.It should be
noted while the amended budgetreflects the utilization of $33.4 million of Fund Balance,this forecast
projects the use of Fund Balance ultimately needed to support FY 2022 activities will be $23.1 million,
$10.3 million less than planned.It is also important to note that on-going expenditures associated with
the COVID-19 pandemic continue to be monitored and appropriate funding sources utilized as needed.
2100 Pontiac Lake Road |County Executive Building 41W |Waterford,MI 48328 |Fax (248)452-9172 |OakGov.com 3
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSGENERALFUND/GENERALPURPOSE(GF/GP)FY2022AMENDMENTSSCHEDULEA FY2023FY2024AMENDMENTSAMENDMENTS [GF/GPOPERATIONS-SELFBALANCINGAMENDMENTSGENERALFUND(#10100DeptProgram Acct PROSECUTINGATTORNEY Expenditures40104014010101122050122050SHERIFF'SOFFICERevenue4030901403070140303019010101 110090116230112620196030Expenditures4030701403060140303014030601116230116210112620116210SHERIFF'SOFFICERevenue 100000003086BudRef2020Activity:GLBAnalysis:GLB4030901110090Expenditures40309014030901110090110090702010730373695500695500695500665882731304731024731304788001610313750070730324FundAff.OpUnit21341213962139721341AccountName SalariesContractedServicesTotalExpendituresTransfersIn-LawEnforcementEnhanceStateTransfersIn-SheriffDispatchTrainingTransfersIn-SheriffBookingFeeTrainingPlannedUseofBalanceTotalRevenueOfficersTraining(Dispatch)K-9OfficersTraining(Corrections)TransfersOut-LawEnforcementEnhanceStateTotalExpendituresFederalOperatingGrantsTotalRevenuesDeputySuppliesCommunicationsTotalExpenditures $(1,900.00)1,900.00$- 5,524.0022,073.003,496.005,524.00$25,569.00| 22,073.00(10,000.00)3,496.00410,000.0025,569.00, $5,000.00$5,000.00 $4,103.00897.00$5,000.00 _
FISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSOAKLANDCOUNTY,MICHIGANGENERALFUND/GENERALPURPOSE(GF/GP)SCHEDULEA FY2022FY2023FY2024AMENDMENTSAMENDMENTSAMENDMENTS |GF/GPOPERATIONS-SELFBALANCINGAMENDMENTSGENERALFUND(#10100DeptProgramAcct SHERIFF'SOFFICEExpenditures40301011125807303734030301112590730373403030111262073037340303011126307303734030301112650730373 SHERIFF'SOFFICERevenues4030601110000631869403060111618163186940306011161816318694030601116200631869 BOARDOFCOMMISSIONERS50101011650207880015010101165020731101BOARDOFCOMMISSIONERS50101011650207314585010101165020731822 FundAff.OpUnit40400AccountName ContractedServicesContractedServicesContractedServicesContractedServicesContractedServicesTotalExpenditures40030ReimbSalariesReimbSalariesReimbSalariesReimbSalariesTotalRevenuesTransfersOut-ProjectWorkOrderFundLibraryContinuationsTotalExpendituresProfessionalServicesSpecialProjectsTotalExpenditures |$(10,000.00)$(523,609.00)(67,074.00)1,354,697.00(754,014.00)$-$(10,000.00)$(10,000.00)(523,609.00)(523,609.00)(67,074.00)(67,074.00)1,354,697.00—_1,354,697.00(754,014.00)(754,014.00)-§-$(733,166.00)$(733,166.00)$(733,166.00)733,166.00733,166.00733,166.00(162,531.00)(162,531.00)(162,531.00)162,531.00462,531.00162,531.00$-$-$-$29,133.00(29,133.00)3$(300,000.00)$(300,000.00)$(300,000.00)300,000.00300,000.00300,000.00$-3-_$-10
SCHEDULEA OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSGENERALFUND/GENERALPURPOSE(GF/GP)FY2022FY2023FY2024AMENDMENTSAMENDMENTSAMENDMENTS[GF/GPOPERATIONS-SELFBALANCINGAMENDMENTS| GENERALFUND(#10100DeptProgramAcctFundAff.OpUnitAccountNameCOMPLIANCEOFFICE/FISCALSERVICESRevenue90101011960303665882PlannedUseofBalanceTotalRevenueq eelsHF10,909.00$16,036.00416,839.0010,909.00$16,036.00$16,839.00 ee
Expenditures1010205181010774636InfoTechOperations$6,545.00$11,454.00$12,028.001020601182020774636InfoTechOperations4,364.004,582.004,811.00TotalExpenditures$10,909.00$16,036.00$16,839.00HEALTHDIVISIONExpenditures1060237133390750301MedicalSupplies$(1,700.00)$(1,700.00)$(1,700.00)1060234133300750301MedicalSupplies850.00850.00850.001060234133310750301MedicalSupplies850.00850.00850.00TotalExpenditures$-_§$-_$- HEALTHDIVISIONExpenditures1060201133150731458ProfessionalServices(1,709,544.00)1060201133150 760160FurnitureandFixtures(9,800.00) GRANT:100000003577BudRef:2022Activity:GLBAnalysis:GLBExpenditures1060201133150731458ProfessionalServices1,709,544.001060201133150760160FurnitureandFixtures9,800.00TotalExpenditures- 11
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSGENERALFUND/GENERALPURPOSE(GF/GP)|GF/GPOPERATIONS-SELFBALANCINGAMENDMENTS DeptProgramAcctFundAff.OpUnitAccountNameHEALTHDIVISIONRevenues9010101196030665882 PlannedUseofBalanceGRANT:100000003242BudRef:2021Activity:GLBAnalysis:GLBRevenues1060201133150615675HealthStateSubsidyTotalRevenuesExpenditures1060201133150722900FringeBenefitAdjustment1060201133150731458ProfessionalServices1060201133150778675TelephoneCommunicationsTotalExpendituresHEALTHDIVISIONRevenues9010101196030665882 PlannedUseofBalanceRevenuesGRANT:100000003577BudRef:2022Activity:GLBAnalysis:GLB1060201133150615675HealthStateSubsidyTotalRevenuesExpenditures1060201133150702010SalariesRegular1060201133150722900FringeBenefitAdjustment1060201133150731458ProfessionalServices1060201133150774636InfoTechOperations1060201133150778675TelephoneCommunicationsTotalExpendituresSCHEDULEA FY2022FY2023FY2024AMENDMENTSAMENDMENTSAMENDMENTS $350,139.00$350,139.00$350,139.00(1,045,070.00)__(1,045,070.00)_(1,045,070.00)(694,931.00)$(694,931.00)$(694,931.00)eg $(47,582.00)$(47,582.00)$(47,582.00)(646,098.00)(646,098.00)(646,098.00)(1,251.00)(1,251.00)(1,251.00)(694,931.00)$(694,931.00)$(694,931.00)co $(83,968.00)1,045,070.00$961,102.00 $417,176.00213,666.00299,532.0026,864.003,864.00$961,102.00 12
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSGENERALFUND/GENERALPURPOSE(GF/GP)FY2022AMENDMENTSSCHEDULEA FY2023FY2024AMENDMENTSAMENDMENTS IGF/GPOPERATIONS-SELFBALANCINGAMENDMENTSGENERALFUND(#10100DeptProgram HEALTHDIVISIONRevenues9010101196030 ExpendituresAcct665882FundAff.OpUnitAccountName PlannedUseofBalanceTotalRevenuesProject#10000003210BudRef2020Activity:GLBAnalysis:GLB10602011330951060201133095106020113309510602011330951060201133095702010722750722770722790722820SalariesRegularWorkersCompensationRetirementSocialSecurityUnemploymentInsuranceProject#10000003323BudRef2021Activity:GLBAnalysis:GLB10602011330951060201133095106020113309510602011330951060201133095HEALTHDIVISIONExpenditures1060241133370106024113337010602301333701060230133370 702010722750722770722790722820702010722900702010722900SalariesRegularWorkersCompensationRetirementSocialSecurityUnemploymentInsuranceTotalExpendituresSalariesRegularFringeBenefitAdjustmentsSalariesRegularFringeBenefitAdjustmentsTotalExpenditures (1,916,175.00)$_(1,916,175.00)(30,304.00)(594.00)(833.00)(439.00)(30.00)$(1,773,018.00)(34,749.00)(48,747.00)(25,706.00)(1,755.00)$_(1,916,175.00)$(385,969.00)(184,103.00)385,969.00184,103.00$= |(1,916,175.00)_(1,916,175.00)$_(1,916,175.00)$(1,916,175.00)(30,304.00) (30,304.00)(594.00)(594.00)(833.00)(833.00)(439.00)(439.00)(30.00)(30.00)$(1,773,018.00)$(1,773,018.00)(34,749.00)(34,749.00)(48,747.00)(48,747.00)(25,706.00)(25,706.00)(1,755.00)(1,755.00)$(1,916,175.00)$(1,916,175.00)$(385,969.00)$(385,969.00)(184,103.00)(184,103.00)385,969.00385,969.00184,103.00184,103.003=§:13
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSGENERALFUND/GENERALPURPOSE(GF/GP)FY2022AMENDMENTSSCHEDULEA FY2023FY2024AMENDMENTSAMENDMENTS IGF/GPOPERATIONS-SELFBALANCINGAMENDMENTSGENERALFUND(#10100DeptProgramAcctFundAff.OpUnit HEALTHDIVISIONRevenues10602011331506103131060283133930610313106022013400061557110602201340806155711060220134200615571106023713330061557110602371333106155711060283133930615571 FederalOperatingGrantsFederalOperatingGrantsStateOperatingGrantsStateOperatingGrantsStateOperatingGrantsStateOperatingGrantsStateOperatingGrantsStateOperatingGrantsGRANT100000003559BUDREF2022ACTIVITY:GLBANALYSIS:GLBRevenues1060201133150610313FederalOperatingGrantsGRANT100000003560BUDREF2022ACTIVITY:GLBANALYSIS:GLBRevenues10602831339306103131060283133930615571FederalOperatingGrantsStateOperatingGrantsGRANT100000003565BUDREF2022ACTIVITY:GLBANALYSIS:GLBRevenues1060220134000615571StateOperatingGrantsGRANT100000003564BUDREF2022ACTIVITY:GLBANALYSIS:GLBRevenues10602201340806155711060220134200615571StateOperatingGrantsStateOperatingGrantsAccountName $(434,420.00)(33,418.00)(1,176,612.00)(413,718.00)(571,324.00)(253,969.00)(253,968.00)(36,847.00)434,420.0033,418.0036,847.001,176,612.00413,718.00571,324.00 $(434,420.00)$(33,418.00)(1,176,612.00)(413,718.00)(571,324.00)(253,969.00)(253,968.00)(36,847.00)434,420.0033,418.0036,847.001,176,612.00413,718.00571,324.00|(434,420.00)(33,418.00)(1,176,612.00)(413,718.00)(571,324.00)(253,969.00)(253,968.00)(36,847.00)434,420.0033,418.0036,847.001,176,612.00413,718.00571,324.0014
SCHEDULEA OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSGENERALFUND/GENERALPURPOSE(GF/GP)FY2022FY2023FY2024AMENDMENTSAMENDMENTSAMENDMENTS|GF/GPOPERATIONS-SELFBALANCINGAMENDMENTS| GENERALFUND(#10100DeptProgramAcctFundAff.OpUnitAccountNameGRANT100000003566BUDREF2022ACTIVITY:GLBANALYSIS:GLBRevenues1060237133300615571StateOperatingGrants253,969.00253,969.00253,969.00 GRANT100000003567BUDREF2022ACTIVITY:GLBANALYSIS:GLBRevenues1060237133310615571StateOperatingGrants253,968.00253,968.00253,968.00TotalRevenues$2$#$-HEALTHDIVISIONExpenditures1060241133370730646EquipmentMaintenance$(300.00)$(300.00)$(300.00)))) 1060241133370730982InterpreterFees(2,000.00)(2,000.00(2,000.00)41060241133370731213MembershipDues(1,700.00)(1,700.00(1,700.00)1060241133370731346PersonalMileage(12,000.00)(12,000.00(12,000.00)1060230133370730646EquipmentMaintenance300.00300.00300.001060230133370730982InterpreterFees2,000.002,000.002,000.001060230133370731213MembershipDues1,700.001,700.001,700.001060230133370731346PersonalMileage12,000.0012,000.0012,000.00TotalExpenditures$-$-$-HEALTHDIVISIONRevenues1060240133390631869ReimbSalaries$(77,596.00)$(77,596.00)$(77,596.00)9010101196030665882PlannedUseofBalance77,596.0077,596.0077,596.00TotalRevenues$-$-$- 15
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSGENERALFUND/GENERALPURPOSE(GF/GP)FY2022AMENDMENTS SCHEDULEA FY2023FY2024AMENDMENTSAMENDMENTS |GF/GPOPERATIONS-SELFBALANCINGAMENDMENTSGENERALFUND(#10100DeptProgramAcct ANIMALCONTROLDIVISIONRevenues107080513213063002810708051140506300701070805114115630074107080111400063125310708051140906319889010101196030665882 ECONOMICDEVELOPMENTExpenditures1090108171030750399109010817103075042710901081710307706311090108171030773630109010817103077867510902011710007503991090201171000750427109020117100077063110902011710007736301090201171000778675 VETERANSERVICESExpenditures10907021320607303731090401132060730373 FundAff.OpUnitAccountName AdoptionsAnimalShots/DogAnimalSerlizationFeesMiscellaneousSaleofLicensesPlannedUseofBalanceTotalRevenuesOfficeSuppliesPhotographicSuppliesBldgSpaceCostAllocationInfoTechDevelopmentTelephoneCommunicationsOfficeSuppliesPhotographicSuppliesBldgSpaceCostAllocationInfoTechDevelopmentTelephoneCommunicationsTotalExpendituresContractedServicesContractedServicesTotalExpenditures $188.00128.001,350.0042.0042.00(1,750.00)$= $(1,450.00)(200.00)(53,360.00)(226.00)(6,831.00)1,450.00200.0053,360.00226.006,831.00$w $(6,026.52)6,026.52$as |16
SCHEDULEA OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSGENERALFUND/GENERALPURPOSE(GF/GP)FY2022FY2023FY2024AMENDMENTSAMENDMENTSAMENDMENTS |GF/GPOPERATIONS-SELFBALANCINGAMENDMENTSGENERALFUND(#10100DeptProgramAcct FundAff.OpUnitAccountName EMERGENCYMANAGEMENTANDHOMELANDSECURITYDIVISIONGRANT:100000003595;BudRef2022Activity:GLBAnalysis:GLBExpenditures1110101115120610210DisasterControlFedSubsidyGRANT:100000003305;BudRef2022Activity:GLBAnalysis:GLBExpenditures1110104115120610210DisasterControlFedSubsidyTotalExpendituresGENERALFUND(#10100Expenditures10605011120109010101112700 77463678800120293InfoTechOperationsTransfersOutTotalExpendituresCHILDCAREFUND(#20293Revenue9090101112700 69550010100TransfersInTotalRevenuesExpenditure1070701112010774636InfoTechOperationsTotalExpendituresNON-DEPARTMENTExpenditures90901011960309090101196030 730800740084GrantMatchJuvenileSentencingTotalExpenditures $(61,242.00)$61,242.00$= $12,988.00(12,988.00)a $(12,988.00)$(12,988.00)$(12,988.00)$(12,988.00)$(209,690.00)209,690.00$=$$|(209,690.00)$(209,690.00)209,690.00$209,690.0017
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSGENERALFUND/GENERALPURPOSE(GF/GP)|GF/GPOPERATIONS-SELFBALANCINGAMENDMENTS DeptProgramAcctFundAff.OpUnitAccountNameCOUNTYEXECUTIVE-OFFICEOFPUBLICCOMMUNICATIONRevenues9010101196030665882PlannedUseofBalanceTotalRevenuesExpenditures1010601181000722900FringeBenefitAdjustment1010602181000722900FringeBenefitAdjustment1010603181000722900FringeBenefitAdjustmentTotalExpendituresWORKFORCEDEVELOPMENTRevenue9010101196030665882PlannedUseofBalanceTotalRevenueExpenditures1090701170010702010SalariesRegular1090701170010722900FringeBenefitAdjustments9010101196030796500BudgetedEquityAdjustmentTotalExpendituresSCHEDULEA FY2022FY2023FY2024AMENDMENTSAMENDMENTSAMENDMENTS_ $4.00 $4.00$2.001.001.00 153,375.00$150,260.00$- BIE|153,375.00$150,260.004'
Lp. $99,414.00$97,464.00$97,464.0053,961.0052,796.0052,796.00--(150,260.00)18
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSPROPRIETARY/SPECIALREVENUEFUNDSFY2022AMENDMENTSSCHEDULEB FY2023AMENDMENTSFY2024AMENDMENTS |PROPRIETARY/SPECIALREVENUEFUNDS-SELFBALANCINGAMENDMENTSDeptIDProgramAcctFundAffOperUnitAccountNameSheriff-LAWENFORCEMENTENHANCESTATE(#21341)Revenue4030901PlannedUseofBalanceTotalRevenue110090665882Expenditures4030901TransfersOut-GeneralFundTotalExpenditures11009078800110100SheriffK9-LAWENFORCEMENTENHANCESTATE(#21341)Revenue40306014030601116210116210665882695500PlannedUseofBalanceTransfersIn-GeneralFundTotalRevenueSheriff-SHERIFFDISPATCHTRAINING(#21396)Revenue4030701665882PlannedUseofBalanceTotalRevenue112630Expenditures4030701TransfersOut-GeneralFundTotalExpenditures11263078800110100Sheriff-SHERIFFBOOKINGFEETRAINING(#21397)Revenue4030301665882PlannedUseofBalanceTotalRevenue112620$5,524.005,524.00 AR
$5,524.005,524.00 An
$(10,000.00)10,000.00ee $22,073.00$22,073.00 $22,073.00$22,073.00 $3,496.00$3,496.00 _|19
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSPROPRIETARY/SPECIALREVENUEFUNDSFY2022AMENDMENTSSCHEDULEB FY2023AMENDMENTSFY2024AMENDMENTS [PROPRIETARY/SPECIALREVENUEFUNDS-SELFBALANCINGAMENDMENTSDeptIDProgramAcctFundAffOperUnitAccountName Expenditures403030178800110100TransfersOut-GeneralFundTotalExpenditures112620PROJECTWORKORDERFUND(40400)PCBU:FACMG,Project:100000003654;Activity:PROJRevenue1040101TransfersIn-GeneralFundTotalRevenue14802069550010100Expenditure1040101148020796500BudgetEquityAdjustmentTotalExpendituresSHERIFF'SOFFICE-DNABACKLOGREDUCTION(#27351)Grant#GR0000001035Activity:GLBAnalysis:GLBBudRef2020Expenditures40309014030901702010722900SalariesFringeBenefitAdjTotalExpenditures116240116240HEALTHDIVISION-ENVIROMENTHEALTHGRANTS(#28597)GR0000001152BudRef:2022Activity:GLBAnalysis:GLBRevenue1060220134220610313FederalOperatingGrantsTotalRevenueExpenditures1060220730373ContractedServicesTotalExpenditures134220$3,496.00$3,496.00 $29,133.00$29,133.00 $29,133.00$29,133.00 $(14,195.00)14,195.00$- $60,390.00$60,390.00 $60,390.00$60,390.00 20
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSPROPRIETARY/SPECIALREVENUEFUNDSFY2022AMENDMENTSSCHEDULEB FY2024AMENDMENTSFY2023AMENDMENTS |PROPRIETARY/SPECIALREVENUEFUNDS-SELFBALANCINGAMENDMENTSDeptIDProgramAcctFundAffOperUnitAccountName HEALTHDIVISION-ENVIROMENTHEALTHGRANTS(#28597)GR0000001153BudRef:2022Activity:GLBAnalysis:GLBRevenue1060220134220610313TotalRevenuesFederalOperatingGrantsExpenditures1060220134220730373TotalExpendituresContractedServicesHEALTHDIVISION-IMMUNIZATIONACTIONPLAN(#28550)GR0000000991BudRef:2021Activity:GLBAnalysis:GLBRevenue10602181339106103131060218133910615463FederalOperatingGrantsGrantFeesandCollectionsTotalRevenuesExpenditures106021813391070201010602181339107227401060218133910730646106021813391073092610602181339107313461060218133910750392106021813391075039910602181339107706311060218133910774636106021813391077463710602181339107746771060218133910778675SalariesRegularFringeBenefitsEquipmentMaintenanceIndirectCostsPersonalMileageMeteredPostageOfficeSuppliesBldgSpaceCostAllocationInfoTechOperationsInfoTechManagedPrintSvcsInsuranceFundTelephoneCommunicationsTotalExpendituresAR1,197.001,197.00 ea
$1,197.001,197.00 a
$501,895.0025,480.00$527,375.00 $284,306.00176,081.00200.0033,719.002,501.002,000.00500.008,249.0012,243.003,860.00666.003,050.00$527,375.00 _|21
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSPROPRIETARY/SPECIALREVENUEFUNDSFY2022AMENDMENTSSCHEDULEB FY2023AMENDMENTSFY2024AMENDMENTS [PROPRIETARY/SPECIALREVENUEFUNDS-SELFBALANCINGAMENDMENTSDeptIDProgramAcctFundAffOperUnitAccountName HEALTHDIVISION-IMMUNIZATIONACTIONPLAN(#28550)GR0000001093BudRef:2022Activity:GLBAnalysis:GLBRevenue1060218133910610313FederalOperatingGrants1060218133910615463GrantFeesandCollectionsTotalRevenuesExpenditures1060218133910702010SalariesRegular1060218133910722740FringeBenefits1060218133910730646EquipmentMaintenance1060218133910730926IndirectCosts1060218133910731346PersonalMileage1060218133910750392MeteredPostage1060218133910750399OfficeSupplies1060218133910770631BldgSpaceCostAllocation1060218133910774636InfoTechOperations1060218133910774637InfoTechManagedPrintSvcs1060218133910774677InsuranceFund1060218133910778675TelephoneCommunicationsTotalExpendituresHEALTHDIVISION-AIDSCOUNSELINGTESTING(#28557)GR0000000993BudRef:2021Activity:GLBAnalysis:GLBRevenue1060294133940610313FederalOperatingGrants1060294133940615571StateOperatingGrantsTotalRevenuesExpenditures1060294133940702010SalariesRegular1060294133940722740FringeBenefits1060294133940730072Advertising1060294133940730926IndirectCosts$(501,895.00)(25,480.00)$(527,375.00) $(284,306.00)(176,081.00)(200.00)(33,719.00)(2,501.00)(2,000.00)(500.00)(8,249.00)(12,243.00)(3,860.00)(666.00)(3,050.00)$527,375.00 130,789.00321,456.00452,245.00 216,562.00115,041.009,500.0025,684.00|22
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSPROPRIETARY/SPECIALREVENUEFUNDSFY2022AMENDMENTSSCHEDULEB FY2023AMENDMENTSAMENDMENTS [PROPRIETARY/SPECIALREVENUEFUNDS-SELFBALANCINGAMENDMENTSDeptID106029410602941060294106029410602941060294106029410602941060294106029410602941060294106029410602941060294106029410602941060294HEALTHDIVISION-AIDSCOUNSELINGTESTING(#28557)GR0000001096BudRef:2022Activity:GLBAnalysis:GLBRevenue10602941060294Expenditures1060294106029410602941060294106029410602941060294Program133940133940133940133940133940133940133940133940133940133940133940133940133940133940133940133940133940133940133940133940133940133940133940133940133940133940133940Acct730982731031731346731388731997732018732165750245750280750301750392750399750567770631774636774637774677778675610313615571702010722740730072730926730982731031731346FundAffOperUnitAccountNameInterpreterFeesLaboratoryFeesPersonalMileagePrintingTransportationofClientsTravelandConferenceWorkshopsandMeetingIncentivesLaboratorySuppliesMedicalSuppliesMeteredPostageOfficeSuppliesTraining-EducationalSuppliesBldgSpaceCostAllocationInfoTechOperationsInfoTechManagedPrintSvcsInsuranceFundTelephoneCommunicationsTotalExpenditures FederalOperatingGrantsStateOperatingGrantsTotalRevenuesSalariesRegularFringeBenefitsAdvertisingIndirectCostsInterpreterFeesLaboratoryFeesPersonalMileage600.001,324.006,308.006,000.005,072.005,500.00500.003,200.001,963.0010,000.001,000.003,500.002,400.0010,882.0019,131.004,152.001,055.002,871.00452,245.00 $(130,789.00)(321,456.00)$(452,245.00) $(216,562.00)(115,041.00)(9,500.00)(25,684.00)(600.00)(1,324.00)(6,308.00)_|23
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSPROPRIETARY/SPECIALREVENUEFUNDSFY2022AMENDMENTSSCHEDULEB FY2023AMENDMENTSFY2024AMENDMENTS [PROPRIETARY/SPECIALREVENUEFUNDS-SELFBALANCINGAMENDMENTSDeptIDProgramAcctFundAffOperUnitAccountName1060294133940731388Printing1060294133940731997TransportationofClients1060294133940732018TravelandConference1060294133940732165WorkshopsandMeeting1060294133940750245Incentives1060294133940750280LaboratorySupplies1060294133940750301MedicalSupplies1060294133940750392MeteredPostage1060294133940750399OfficeSupplies1060294133940750567Training-EducationalSupplies1060294133940770631BldgSpaceCostAllocation1060294133940774636InfoTechOperations1060294133940774637InfoTechManagedPrintSvcs1060294133940774677InsuranceFund1060294133940778675TelephoneCommunicationsTotalExpenditures HEALTHDIVISION-HEALTHVACCINESFORCHILDREN(#28560)GR0000000994BudRef:2021Activity:GLBAnalysis:GLBRevenue1060234133910615571StateOperatingGrantsTotalRevenuesExpenditures1060234133910702010SalariesRegular1060234133910722740FringeBenefits1060234133910730926IndirectCosts1060234133910731346PersonalMileage1060234133910750294MaterialandSupplies1060234133910774677InsuranceFundTotalExpenditures(6,000.00)(5,072.00)(5,500.00)(500.00)(3,200.00)(1,963.00)(10,000.00)(1,000.00)(3,500.00)(2,400.00)(10,882.00)(19,131.00)(4,152.00)(1,055.00)(2,871.00)$(452,245.00) $105,347.00$105,347.00 $55,476.0041,925.006,579.00757.00461.00149.00$105,347.00 24
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSPROPRIETARY/SPECIALREVENUEFUNDSFY2022AMENDMENTSSCHEDULEB FY2023AMENDMENTSFY2024AMENDMENTS [PROPRIETARY/SPECIALREVENUEFUNDS-SELFBALANCINGAMENDMENTSDeptIDProgramAcctFundAffOperUnitAccountName HEALTHDIVISION-HEALTHVACCINESFORCHILDREN(#28560)GR0000001097BudRef:2022Activity:GLBAnalysis:GLBRevenue1060234133910615571StateOperatingGrantsTotalRevenuesExpenditures1060234133910702010SalariesRegular1060234133910722740FringeBenefits1060234133910730926IndirectCosts1060234133910731346PersonalMileage1060234133910750294MaterialandSupplies1060234133910774677InsuranceFundTotalExpendituresHEALTHDIVISION-HEALTHBIOTERROISM(#28605)GR000000997BudRef:2021Activity:GLBAnalysis:GLBRevenue1060290115140610313FederalOperatingGrantsTotalRevenuesExpenditures1060290115140702010SalariesRegular1060290115140722740FringeBenefits1060290115140730926IndirectCosts1060290115140750280LaboratorySupplies1060290115140774677InsuranceFund1060290115140778675TelephoneCommunicationsTotalExpenditures$(105,347.00)$105,347.00 (55,476.00)(41,925.00)(6,579.00)(757.00)(461.00)(149.00)$(105,347.00) $ 15,000.00$15,000.00 $3,490.002,080.00414.008,414.0027.00575.00$15,000.00 _|25
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSPROPRIETARY/SPECIALREVENUEFUNDSFY2022AMENDMENTSSCHEDULEB FY2023AMENDMENTSAMENDMENTS [PROPRIETARY/SPECIALREVENUEFUNDS-SELFBALANCINGAMENDMENTSDeptIDProgramAcctFundAffOperUnitAccountName HEALTHDIVISION-HEALTHBIOTERROISM(#28605)GR0000001116BudRef:2022Activity:GLBAnalysis:GLBRevenue1060290 115140610313FederalOperatingGrantsTotalRevenuesExpenditures106029011514070201010602901151407227401060290115140730926106029011514075028010602901151407746771060290115140778675SalariesRegularFringeBenefitsIndirectCostsLaboratorySuppliesInsuranceFundTelephoneCommunicationsTotalExpendituresHEALTHDIVISION-NURSEFAMILITYPARTNERSHIP(#28607)GR0000000998BudRef:2021Activity:GLBAnalysis:GLBRevenue10602301332156103131060230133215615571FederalOperatingGrantsStateOperatingGrantsTotalRevenuesExpenditures106023013321570201010602301332157227401060230133215730373ContractedServices1060230133215731346PersonalMileage1060230133215731941Training1060230133215750245Incentives1060230133215750399OfficeSupplies1060230133215750567Training-EducationalSupplies1060230133215770631BldgSpaceCostAllocationSalariesRegularFringeBenefits$(15,000.00)$(15,000.00) $(3,490.00)(2,080.00)(414.00)(8,414.00)(27.00)(575.00)$(15,000.00) $385,524.00257,016.00$642,540.00 $355,509.00209,895.0018,312.006,469.002,876.002,000.00507.003,320.0014,329.00_|26
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSPROPRIETARY/SPECIALREVENUEFUNDSFY2022AMENDMENTSSCHEDULEB FY2023FY2024AMENDMENTSAMENDMENTS [PROPRIETARY/SPECIALREVENUEFUNDS-SELFBALANCINGAMENDMENTSDeptIDProgramAcctFundAffOperUnitAccountName1060230133215774636InfoTechOperations1060230133215774637InfoTechManagedPrintSvcs1060230133215774677InsuranceFund1060230133215778675TelephoneCommunicationsTotalExpenditures HEALTHDIVISION-NURSEFAMILITYPARTNERSHIP(#28607)GR0000001101BudRef:2022Activity:GLBAnalysis:GLBRevenue1060230133215610313FederalOperatingGrants1060230133215615571StateOperatingGrantsTotalRevenuesExpenditures1060230133215702010SalariesRegular1060230133215722740FringeBenefits1060230133215730373ContractedServices1060230133215731346PersonalMileage1060230133215731941Training1060230133215750245Incentives1060230133215750399OfficeSupplies1060230133215750567Training-EducationalSupplies1060230133215770631BldgSpaceCostAllocation1060230133215774636InfoTechOperations1060230133215774637InfoTechManagedPrintSvcs1060230133215774677InsuranceFund1060230133215778675TelephoneCommunicationsTotalExpenditures16,320.007,860.00875.004,268.00$642,540.00 $(385,524.00)(257,016.00)$(642,540.00) $(355,509.00)(209,895.00)(18,312.00)(6,469.00)(2,876.00)(2,000.00)(507.00)(3,320.00)(14,329.00)(16,320.00)(7,860.00)(875.00)(4,268.00)$(642,540.00) _|27
OAKLANDCOUNTY,MICHIGANSCHEDULEB FISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSPROPRIETARY/SPECIALREVENUEFUNDSFY2022AMENDMENTSFY2023AMENDMENTSFY2024AMENDMENTS [PROPRIETARY/SPECIALREVENUEFUNDS-SELFBALANCINGAMENDMENTSDeptIDProgramAcctFundAffOperUnitAccountNameHEALTHDIVISION-HEALTHPHEP(#28610)GR0000001109BudRef:2022Activity:GLBAnalysis:GLBRevenue10602901060290 115010115035610313610313FederalOperatingGrantsFederalOperatingGrantsTotalRevenuesExpenditures106029010602901060290106029010602901060290106029010602901060290106029010602901060290106029010602901060290106029010602901060290106029010602901060290115010115010115010115010115010115010115010115010115010115010115010115035115035115035115035115035115035115035115035115035115035702010722740730926731346731388750077750399774636174637774677778675702010722740730926731346731388750077750399774636774677778675SalariesRegularFringeBenefitsIndirectCostsPersonalMileagePrintingDisasterSuppliesOfficeSuppliesInfoTechOperationsInfoTechManagedPrintSvcsInsuranceFundTelephoneCommunicationsSalariesRegularFringeBenefitsIndirectCostsPersonalMileagePrintingDisasterSuppliesOfficeSuppliesInfoTechOperationsInsuranceFundTelephoneCommunicationsTotalExpenditures$(222,088.00)(151,699.00)$(373,787.00) $(107,748.00)(38,790.00)(12,779.00)(1,090.00)(2,000.00)(42,917.00)(2,500.00)(10,794.00)(1,400.00)(270.00)(1,800.00)(71,710.00)(25,816.00)(8,505.00)(1,000.00)(1,160.00)(35,200.00)(1,000.00)(4,896.00)(207.00)(2,205.00)$(373,787.00) _|28
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSPROPRIETARY/SPECIALREVENUEFUNDSFY2022AMENDMENTSSCHEDULEB FY2023AMENDMENTSFY2024AMENDMENTS {PROPRIETARY/SPECIALREVENUEFUNDS-SELFBALANCINGAMENDMENTSDeptIDProgramAcctFundAffOperUnitAccountName HEALTHDIVISION-HEALTHPHEP(#28610)GR0000000989BudRef:2021Activity:GLBAnalysis:GLBRevenue10602901150106103131060290115035610313 FederalOperatingGrantsFederalOperatingGrantsTotalRevenuesExpenditures1060290115010702010SalariesRegular1060290115010722740FringeBenefits1060290115010730926IndirectCosts1060290115010731346PersonalMileage1060290115010731388Printing1060290115010750077DisasterSupplies1060290115010750399OfficeSupplies1060290115010774636InfoTechOperations1060290115010774637InfoTechManagedPrintSvcs1060290115010774677InsuranceFund1060290115010778675TelephoneCommunications1060290115035702010SalariesRegular1060290115035722740FringeBenefits1060290115035730926IndirectCosts1060290115035731346PersonalMileage1060290115035731388Printing1060290115035750077DisasterSupplies1060290115035750399OfficeSupplies1060290115035774636InfoTechOperations1060290115035774677InsuranceFund1060290115035778675TelephoneCommunicationsTotalExpenditures$$222,088.00151,699.00373,787.00 107,748.0038,790.0012,779.001,090.002,000.0042,917.002,500.0010,794.001,400.00270.001,800.0071,710.0025,816.008,505.001,000.001,160.0035,200.001,000.004,896.00207.002,205.00373,787.00 29
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSPROPRIETARY/SPECIALREVENUEFUNDSFY2022AMENDMENTSSCHEDULEB FY2023AMENDMENTSFY2024AMENDMENTS |PROPRIETARY/SPECIALREVENUEFUNDS-SELFBALANCINGAMENDMENTSDeptIDProgramAcctFundAffOperUnitAccountName HEALTHDIVISION-EMERGINGTHREATSHEPC(#28624)GR0000001106BudRef:2022Activity:GLBAnalysis:GLBRevenue1060234Expenditures106023410602341060234106023410602341060234106023410602341060234106023410602341060234106023410602341060234133405133405133405133405133405133405133405133405133405133405133405133405133405133405133405133405615571702010722740730072730926730982731346731388732018750245750399750448750567774636774677778675StateOperatingGrantsTotalRevenuesSalariesRegularFringeBenefitsAdvertisingIndirectCostsInterpreterFeesPersonalMileagePrintingTravelandConferenceIncentiveOfficeSuppliesPostage-StandardMailingTraining-EducationalSuppliesInfoTechOperationsInsuranceFundTelephoneCommunicationsTotalExpenditures$(76,221.00)$(76,221.00) $(35,310.00)(1,858.00)(20,000.00)(4,188.00)(250.00)(1,725.00)(2,500.00)(1,000.00)(1,000.00)(1,475.00)(830.00)(2,500.00)(3,172.00)(101.00)(312.00)$(76,221.00) _|30
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSPROPRIETARY/SPECIALREVENUEFUNDSFY2022AMENDMENTSSCHEDULEB FY2023AMENDMENTSFY2024AMENDMENTS [PROPRIETARY/SPECIALREVENUEFUNDS-SELFBALANCINGAMENDMENTSDeptIDProgramAcctFundAffOperUnitAccountName HEALTHDIVISION-EMERGINGTHREATSHEPC(#28624)GR0000001005BudRef:2021Activity:GLBAnalysis:GLBRevenue1060234133405615571StateOperatingGrants$76,221.00TotalRevenues$76,221.00 Expenditures1060234133405702010SalariesRegular$35,310.001060234133405722740FringeBenefits1,858.001060234133405730072Advertising20,000.001060234133405730926IndirectCosts4,188.001060234133405730982InterpreterFees250.001060234133405731346PersonalMileage1,725.001060234133405731388Printing2,500.001060234133405732018TravelandConference1,000.001060234133405750245Incentive1,000.001060234133405750399OfficeSupplies1,475.001060234133405750448Postage-StandardMailing830.001060234133405750567Training-EducationalSupplies2,500.001060234133405774636InfoTechOperations3,172.001060234133405774677InsuranceFund101.001060234133405778675TelephoneCommunications312.00TotalExpenditures$76,221.00 HEALTHDIVISION-HIVPREP(#28629)GR0000001007BudRef:2021Activity:GLBAnalysis:GLBRevenue1060294133990610313FederalOperatingGrants$118,800.001060294133990615571StateOperatingGrants1,200.00TotalRevenues$120,000.00 _|31
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSPROPRIETARY/SPECIALREVENUEFUNDSFY2022AMENDMENTSSCHEDULEB FY2023AMENDMENTSAMENDMENTS |PROPRIETARY/SPECIALREVENUEFUNDS-SELFBALANCINGAMENDMENTSDeptIDProgramAcctFundAffOperUnitAccountName Expenditures1060294133990702010SalariesRegular1060294133990722740FringeBenefits1060294133990730926IndirectCosts1060294133990731346PersonalMileage1060294133990731997ClientTransportatoin1060294133990750294MaterialandSupplies1060294133990774636InfoTechOperations1060294133990778675TelephoneCommunications1060294133990731031LaboratoryFees1060294133990774677InsuranceFundTotalExpendituresHEALTHDIVISION-HIVPREP(#28629)GR0000001108BudRef:2022Activity:GLBAnalysis:GLBRevenue1060294133990610313FederalOperatingGrants1060294133990615571StateOperatingGrantsTotalRevenuesExpenditures1060294133990702010SalariesRegular1060294133990722740FringeBenefits1060294133990730926IndirectCosts1060294133990731346PersonalMileage1060294133990731997ClientTransportatoin1060294133990750294MaterialandSupplies1060294133990774636InfoTechOperations1060294133990778675TelephoneCommunications1060294133990731031LaboratoryFees1060294133990774677InsuranceFundTotalExpenditures$78,871.0016,586.009,354.001,700.001,532.005,500.004,740.00888.00665.00164.00$120,000.00 $(118,800.00)1,200.00$(120,000.00) $(78,871.00)(16,586.00)(9,354.00)(1,700.00)(1,532.00)(5,500.00)(4,740.00)(888.00)(665.00)(164.00)$(120,000.00) _32
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSPROPRIETARY/SPECIALREVENUEFUNDSFY2022AMENDMENTSSCHEDULEB FY2023AMENDMENTSFY2024AMENDMENTS [PROPRIETARY/SPECIALREVENUEFUNDS-SELFBALANCINGAMENDMENTSDeptIDHEALTHDIVISION-WESTNILESURVEILLANCE(#28690)GR0000001002BudRef:2021Activity:GLBAnalysis:GLBRevenue1060220Expenditures10602201060220106022010602201060220HEALTHDIVISION-WESTNILESURVEILLANCE(#28690)GR0000001104BudRef:2022Activity:GLBAnalysis:GLBRevenue1060220Expenditures10602201060220106022010602201060220Program134870134870134870134870134870134870134870134870134870134870134870134870Acct610313702010722740730926750539774677610313702010722740730926750539774677FundAffOperUnitAccountNameFederalOperatingGrantsTotalRevenuesSalariesRegularFringeBenefitsIndirectCostsTestingMaterialsInsuranceFundTotalExpendituresFederalOperatingGrantsTotalRevenuesSalariesRegularFringeBenefitsIndirectCostsTestingMaterialsInsuranceFundTotalExpenditures10,000.00$10,000.00 4,868.003,168.00577.001,373.0014.00$10,000.00 (10,000.00)$(10,000.00) (4,868.00)(3,168.00)(577.00)(1,373.00)14.00___(14.00)$(10,000.00)_|33
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSPROPRIETARY/SPECIALREVENUEFUNDSFY2022AMENDMENTSSCHEDULEB FY2023AMENDMENTSFY2024AMENDMENTS [PROPRIETARY/SPECIALREVENUEFUNDS-SELFBALANCINGAMENDMENTSDeptIDProgramAcctFundAffOperUnitAccountName HEALTHDIVISION-HEALTHTBOUTREACH(#28556)GR0000001095BudRef:2022Activity:GLBAnalysis:GLBRevenue1060235Expenditures106023510602351060235106023510602351060235106023510602351060235HEALTHDIVISION-HEALTHTBOUTREACH(#28556)GR0000000992BudRef:2021Activity:GLBAnalysis:GLBRevenue1060235Expenditures10602351060235106023510602351060235133970133970133970133970133970133970133970133970133970133970133970133970133970133970133970133970610313702010722740730926731031731346731997750245750448774677610313702010722740730926731031731346FederalOperatingGrantsTotalRevenueSalariesRegularFringeBenefitsIndirectCostsLaboratoryFeesPersonalMileageTransportationofClientsIncentivesPostage-StandardMailingInsuranceFundTotalExpendituresFederalOperatingGrantsTotalRevenueSalariesRegularFringeBenefitsIndirectCostsLaboratoryFeesPersonalMileage$(20,141.00)$(20,141.00) (11,198.00)(589.00)(1,328.00)(5,060.00)(575.00)(100.00)(1,000.00)(250.00)(41.00)$(20,141.00) $20,141.00$20,141.00 11,198.00589.001,328.005,060.00575.00_34
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSPROPRIETARY/SPECIALREVENUEFUNDSFY2022AMENDMENTSSCHEDULEB FY2023AMENDMENTSFY2024AMENDMENTS [PROPRIETARY/SPECIALREVENUEFUNDS-SELFBALANCINGAMENDMENTSDeptIDProgramAcctFundAffOperUnitAccountName1060235133970731997TransportationofClients1060235133970750245Incentives1060235133970750448Postage-StandardMailing1060235133970774677InsuranceFundTotalExpenditures AIRPORTFUND(#56500Expenses103070115400075039910307011540007314581030701154000774636 OfficeSuppliesProfessionalServicesInfoTechOperationsTotalExpensesAIRPORTFUND(#56500Revenue1030701154000665882 PlannedUseofBalanceTotalRevenuesExpense1030701154000765031InterestExpenseTotalExpenseWORKFORCEDEVUNDISTRIBUTED(#29801)GR0000000294BudRef:2022Activity:GLBAnalysis:GLBExpenditures1090701170010731465Program1090701170010731645RetirementHealthSavingsTotalExpenditures100.001,000.00250.0041.00 20,141.00 $(1,030.00)(3,352.00)4,382.00(95,000.00)(95,000.00)(95,000.00)(95,000.00)477,808.00(477,808.00)-$(3,352.00)3,352.00-$(115,000.00)$(115,000.00)(115,000.00)$(115,000.00)468,439.00$(468,439.00)-§$_|(3,352.00)3,352.00(136,000.00)(136,000.00)(136,000.00)(136,000.00)468,439.00(468,439.00)35
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSPROPRIETARY/SPECIALREVENUEFUNDSFY2022AMENDMENTSSCHEDULEB FY2023AMENDMENTSFY2024AMENDMENTS [PROPRIETARY/SPECIALREVENUEFUNDS-SELFBALANCINGAMENDMENTSDeptIDExpenses10407701110102PARKSANDRECREATION(#50800)Revenues5060725506091150607225060715 Expenses1010205101020510102051010205506042750604175060715506072050603285060330506073550609115060911506091050609105060760506033050607555060327Program145100145100160070160431160210160070181010181010181010181010160044160044160070160070160010160010160070160431160432106430160431160070160010160070160010Acct777560777560670570670570670570675354702010712020722740722900730198730198730198730198730198730198730198130789730789730789730789730814730814730814730814FundAffOperUnitFACILITIESMAINTANDOPERATIONSFUND(#63100) AccountName RadioCommunicationsRadioCommunicationsTotalExpensesRefundPriorYearsExpenditureRefundPriorYearsExpenditureRefundPriorYearsExpenditureGainonSaleofEquipmentTotalRevenuesSalariesRegularOvertimeFringeBenefitsFringeBenefitAdjustmentsBuildingMaintenanceBuildingMaintenanceBuildingMaintenanceBuildingMaintenanceBuildingMaintenanceBuildingMaintenanceBuildingMaintenanceGeneralProgramAdministrationGeneralProgramAdministrationGeneralProgramAdministrationGeneralProgramAdministrationGroundsMaintenanceGroundsMaintenanceGroundsMaintenanceGroundsMaintenance$(12,979.00)12,979.00$s$579.002,984.0068.004,950.00$8,581.00 $(29,040.00)(1,000.00)(1,700.00)(248.00)228,690.004,500.002,000.009,000.003,500.004,500.004,500.00(77,961.00)(18,345.00)(1,425.00)41,589.00379.00398.00633.001,362.00$$(12,979.00)$12,979.00$_|(12,979.00)12,979.0036
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSPROPRIETARY/SPECIALREVENUEFUNDSFY2022AMENDMENTSSCHEDULEB FY2023AMENDMENTSAMENDMENTS [PROPRIETARY/SPECIALREVENUEFUNDS-SELFBALANCINGAMENDMENTSDeptID5060720506071550607245060735506072050607655060911506072550607355060831101020510102051010205506032650603275060328506033050603565060911506010210102051010205506066650606665060666506066650606665060101Program160070160070160070160070160070160070160432160070160070160210181010181010181010160010160010160010160010160010160431160102181010181010160666160666160666160666160666160000Acct730814730814730814730814730814730814730814730814730814730814731213731346732018750154750154750154750154750154750511762011774636(78675796500796500796500796500796500796500FundAffOperUnitAccountName GroundsMaintenanceGroundsMaintenanceGroundsMaintenanceGroundsMaintenanceGroundsMaintenanceGroundsMaintenanceGroundsMaintenanceGroundsMaintenanceBuildingMaintenanceGroundsMaintenanceMembershipDuesPersonalMileageTravelandConferenceExpendableEquipmentExpendableEquipmentExpendableEquipmentExpendableEquipmentExpendableEquipmentSpecialEventSuppliesTransfertoMunicipalitiesInfoTechOperationsTelephoneCommunicationsBudgetedEquityAdjustmentsBudgetedEquityAdjustmentsBudgetedEquityAdjustmentsBudgetedEquityAdjustmentsBudgetedEquityAdjustmentsBudgetedEquityAdjustmentsTotalExpenses1,425.003,797.008,453.009,326.0011,414.0014,483.0018,345.0025,816.003,500.0032,250.00(380.00)(200.00)(1,500.00)(95,914.00)141,464.0064,867.00109,178.00(83,536.00)1,900.00(213,080.00)(5,597.00)(720.00)(74,469.00)(228,690.00)(41,589.00)(31,500.00)(32,250.00)200,456.00$8,581.00 _|37
OAKLANDCOUNTY,MICHIGANFISCALYEAR2022FIRSTQUARTERBUDGETAMENDMENTSPROPRIETARY/SPECIALREVENUEFUNDSFY2022AMENDMENTSSCHEDULEB FY2023AMENDMENTSFY2024AMENDMENTS RADIOCOMMUNICATIONS[PROPRIETARY/SPECIALREVENUEFUNDS-SELFBALANCINGAMENDMENTSFundAffOperUnitAccountName FUND(#53600)InterestExpense$378,217.00BudgetedEquityAdjustments(378,217.00)TotalExpenses$- |38
COUNTY OF OAKLAND
FY 2022 FIRST QUARTER REPORT
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
REVENUES
GENERAL FUND
Taxes
Federal Grants
State Grants
Other Intergovernmental Revenue
Chargesfor Services
Indirect Cost Recovery
Investment Income
Other Revenues
SUB-TOTAL GENERAL FUND/GENERAL PURPOSE $475,178,759.00
PLANNED USE OF FUND BALANCE
TOTAL GF/GP FUNDS
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court
52nd District Court
Probate Court
TOTAL ADMIN.OF JUSTICE
LAW ENFORCEMENT
Prosecuting Attorney
Sheriff
TOTAL LAW ENFORCEMENT
GENERAL GOVERNMENT
Clerk/Register of Deeds
Treasurer
Board of Commissioners
Water Resources Commissioner
TOTAL GENERAL GOVERNMENT
COUNTY EXECUTIVE
County Executive Admn.
Management and Budget
Central Services
Facilities Management
Human Resources
Health and Human Services
Public Services
Economic Development
Emergency Management &Homeland Security
Public Communication
TOTAL COUNTY EXECUTIVE
TOTAL DEPARTMENTS
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NON-DEPARTMENTAL
TOTAL GOVERNMENTAL EXPENDITURES
General Fund/General Purpose
Favorable/(Unfavorable)-Budget Perspective
GAAPRequired Adjustment(eliminating use of fund balance "revenue")
GAAP-BASED REPORT(Impact on Fund Balance includes Encumbrances)
SUMMARY BY DEPARTMENT
FY 2022 BUDGET AMOUNTADOPTEDASFY2022FAVORABLE/BUDGET AMENDED FORECAST UNFAVORABLE)PERCENT
$264,560,789.00 $264,560,789.00 $ 264,560,789.00 $“0.00%1,225,211.00 8,434,251.00 8,349,616.00 (84,635.00)-1.00%21,101,639.00 21,113,550.00 18,208,302.00 (2,905,248.00)—_-13.76%46,157,193.00 46,157,193.00 46,334,676.00 177,483.00 0.38%124,145,227.00 125,193,056.00 124,508,256.00 (684,800.00)-0.55%9,100,000.00 9,100,000.00 9,100,000.00 2 0.00%3,154,700.00 3,154,700.00 1,520,151.00 (1,634,549.00)51.81%5,734,000.00 5,734,000.00 5,752,682.00 18,682.00 0.33%
$483,447,539.00 $478,334,472.00 $(5,113,067.00)-1,06%
$16,544,257.00 $33,432,819.13 $33,432,819.13 $-0.00%
S$_491,723,016.00 _$ 516,880,358.13 $511,767,291.13 $_(5,113,067.00)0.99%
$51,483,753.00 $ 52,535,314.92 46,315,314.92 $6,220,000.00 11.84%18,084,217.00 18,153,546.02 17,769,046.02 384,500.00 2.12%
vend200,250.00 7,303,591.00 7,135,091.00 168,500.00 2.31%
$ 76,838,220.00 $77,992,45194 $71,219,451.94 $6,773,000.00 8.68%
23,753,893.00 24,864,170.00 23,319,170.00 1,545,000.00 6.21%170,508,156.00 174,968,626.66 170,070,626.66_4,898,000.00 2.80%
$194,262,049.00 $199,832,796.66 $193,389,796.66 $ 6,443,000.00 3.22%
10,726,108.00 10,900,852.72 10,342,852.72 558,000.00 5.12%8,595,290.00 11,087,609.00 10,407,609.00 680,000.00 6.13%5,199,945.00 6,428,068.00 6,407,368.00 20,700.00 0.32%7,819,313,00 7,848,018.00 7,848,018.00 -0.00%
$ 32,340,656.00 $36,264,547.72 $35,005,847.72 $1,258,700.00 3.47%
$ 6,994,204.00 $7,318,54579 $7,307,345.79 $11,200.00 0.15%23,680,886.00 24,265,402.21 23,974,102.21 291,300.00 1.20%2,691,218.00 2,705,442.00 2,503,042.00 202,400.00 7.48%1,518,242.00 1,615,851.00 1,487,351.00 428,500.00 7.95%5,130,104.00 5,650,046.50 5,465,046.50 185,000.00 3.27%45,178,627.00 48,365,312.00 47,963,012.00 402,300.00 0.83%41,894,439.00 42,090,955.76 40,155,955.76 1,935,000.00 4.60%10,431,676.00 12,709,347.52 12,709,347.52 -0.00%1,904,226.00 9,008,767.00 9,008,767.00 :0.00%
_2,862,251.00 2,870,283.00 2,870,283.00 :0.00%
$142,285,873.00 $156,599,952.78 $153,444,252.78 _$ 3,155,700.00 2.02%
$445,726,798.00 $470,689,749.10 $ 453,059,349.10 _$_17,630,400.00 3.75%
S$___45,996,218.00 $__46,190,609.03 $$__48,390,609.03_$__(2,200,000.00)—_-4.76%
_$_491,723,016.00 $_516,880,358.13 $—_501,449,958.13 $_15,430,400.00 2.99%
$-$_:$10,317,333.00 _$10,317,333.00
$__(33,432,819.13)_
($23,115,486.13 39
TAXES(601000-601999PropertyTaxes-JulyTaxLevy$OtherTaxes-DelinquentTax-PriorYearsMarijuanaTaxTreasurerPaymentinLieuofTaxesTrailerTax TotalTaxes$FEDERALGRANTS(610000-610999)Sheriff-Sheriff'sOffice$Sheriff-PatrolSheriff-CorrectiveServicesSheriff-Investigative/ForensicServicesProsecutingAttorneyHomelandSecurity-DisasterControlEmergencyManagementandHomelandSecurityHealthDivisionChildren'sVillageTotalFederalGrants$STATEGRANTS(615000-615999)Sheriff-Patrol$StateMatchFosterCareProsecutingAttorneyEconomicDevelopmentHealthDivisionWaterResourcesCommissionerEconomicDevelopment-Veteran'sServicesNon-Departmental-ChildCareSubsidyADOPTEDBUDGET263,900,789.00125,000.0050,000.00400,000.0085,000.00264,560,789.00205,000.0070,718.00649,493.00300,000.001,225,211.001,000.006,585,607.0014,515,032.00$$COUNTYOFOAKLANDGENERALFUND/GENERALPURPOSEREVENUESFY2022FIRSTQUARTERREPORTAMENDEDBUDGET263,900,789.00125,000.0050,000.00400,000.0085,000.00264,560,789.0055,823.0038,744.00205,000.007,185,894.00648,790.00300,000.008,434,251.001,000.006,586,310.0014,526,240.00FY2022FORECAST263,900,789.00125,000.0050,000.00400,000.0085,000.00264,560,789.0055,823.0054,109.00205,000.007,185,894.00648,790.00200,000.008,349,616.001,000.006,586,310.0011,620,992.00AMOUNTFAVORABLE(UNFAVORABLE)15,365.00(100,000.00)(84,635.00)(2,905,248.00)PERCENT TotalStateGrants$OTHERINTER-GOVERNMENTALREVENUES(620000-626999)Non-Departmental$HHS-HomelandSecurityEmergencyManagement-HomelandSecurity21,101,639.0043,847,659.009,000.00$21,113,550.0043,847,659.009,000.0018,208,302.0044,085,142.009,000.00(2,905,248.00)237,483.00EXPLANATIONOFSIGNIFICANTVARIANCES0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%39.66%Fav.duetotiming ofgrantpaymentfortheHighIntensityDrugTraffickingAreas(HIDTA)Grant.0.00%0.00%0.00%0.00%-33.33%Unfav.SchoolLunchprogramservinglessduetodeclineinpopulationofresidents;offsetbyfavorableexpenditures.-1.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%-20.00%UnfavorabilityduetolessthananticipatedreimbursementfromtheStateoneligiblechildcarecosts;offsetbyChildCareFundexpenditurefavorability.-13.76%0.54%FavorabilityisduetotheState'supdatedRevenueSharingincreaseof$487,483,offsetbyunfavorabilityinStateCourtFundDisbursementPA189.0.00%0.00%40
CircuitCourtDistrictCourtSheriffNon-Departmental-ReimbJudgesSalariesTotalOtherIntergovernmentalRevenueCHARGESFORSERVICES(630000-635999)AdministrationofJusticeCircuitCourt-Judicial/AdministrationCircuitCourt-Civil/CriminalCircuitCourt-FamilyDivisionDistrictCourt-DiDistrictCourt- ion|(Novi) ADOPTEDBUDGET4,500.001,800.00300,050.001,994,184.00COUNTYOFOAKLANDGENERALFUND/GENERALPURPOSEREVENUESFY2022FIRSTQUARTERREPORTAMENDEDBUDGET4,500.001,800.00300,050.001,994,184.00FY2022FORECAST4,500.001,800.00240,050.001,994,184.00AMOUNTFAVORABLE(UNFAVORABLE)(60,000.00) 46,157,193.002,162,000.001,671,500.004,214,753.001,912,663.00$46,157,193.00$-2,162,000.001,671,500.004,214,753.001,912,663.00$46,334,676.00$s2,067,000.001,456,500.003,264,753.001,752,663.00177,483.00(95,000.00)(215,000.00)(950,000.00)(160,000.00)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES0.00%0.00%-20.00%Unfav.SocialSecurityIncentivePayments($60,000)asaresultofareductioninthenumberofinmatesinresponsetoCOVID-19pandemic.FundsarecollectedfromjailinmatesreceivingSSIforcostofincarceration.0.00%0.38%0.00%-4.39%Unfav.CourtCosts($125,000)duetochangesinlegislation,reducedcaseloadandCOVID-19pandemic.Unfav.JuryFees($100,000)duetotimingofpaymentfromState.Unfav.CivilMediationPayments($75,000)duetoreductionincaseevaluationactivity.Unfav.MediationFines($70,000)duetolowerthananticipatedrevenue.Partiallyoffsetbyfav.RefundFeesPDDefAttorney$275,000duetoanincreaseinactivityandfees.TheoverarchingcauseofthevariancesidentifiedaboveisalsoduetotheCOVID-19pandemic.-12.86%Unfav.BoardandCare($100,000)alongwithGovtBenefitBoardandCare($65,000)duetoadecreaseinreimbursement.Unfav.RefundFeesPDDefAttorney($30,000)duetoadecreaseinactivity.Unfav.CourtServiceFeesProbation($20,000)duetoareductioninprobationcaseload.TheoverarchingcauseofthevariancesidentifiedaboveisalsoduetotheCOVID-19pandemic.-22.54%Unfav.OrdinanceFinesandCosts($700,000);ProbationFees($150,000);andStateLawCosts($100,000)partiallyduetothereductionincaseloadfrommarijuanalegalizationandpartiallyduetochangeinlegislation.TheoverarchingcauseofthevariancesisalsoduetoCOVID-19pandemic.-8.37%Unfav.OrdinanceFinesandCosts($100,000);ProbationFees($35,000);AssessmentsandPSI($15,000);aswellasRefundFeesPDDefAttorney($10,000)partiallyduetothereductionincaseloadfrommarijuanalegalization,partiallyduetochangeinlegislationandpartiallyduetothepandemic.TheoverarchingcauseofthevariancesisalsoduetoCOVID-19pandemic.41
DistrictCourt-DivisionIII(RochesterHills)DistrictCourt-DivisionIV(Troy)ProbateCourt-EstatesandMentalHealthTotalAdministrationofJusticeLawEnforcementProsecutingAttorneySheriff'sOfficeSheriff-AdministrativeServicesADOPTEDBUDGET4,178,015.002,440,590.00561,600.00COUNTYOFOAKLANDGENERALFUND/GENERALPURPOSEREVENUESFY2022FIRSTQUARTERREPORTAMENDEDBUDGET4,178,015.002,440,590.00561,600.00FORECASTAMOUNTFY2022FAVORABLE(UNFAVORABLE)PERCENT3,213,015.00(965,000.00)-23.10%1,505,590.00(935,000.00)-38.31%634,100.0072,500.0012.91% 17,141,121.00815,549.002,900.00363,500.0017,141,121.00$820,349.002,900.00363,500.0013,893,621.00$(3,247,500.00)-18.95%760,349.00$(60,000.00)-7.31%7,700.004,800.00165.52%203,500.00(160,000.00)44.02%EXPLANATIONOFSIGNIFICANTVARIANCESUnfav.OrdinanceFinesandCosts($700,000)aswellasProbationFees($325,000)partiallyduetochangeinthemarijuanastatute(makingitacivilinfraction),partiallyduetochangeinlegislationandpartiallyduetotheCOVID-19pandemic.Partiallyoffsetbyfav.RefundFeesPDDefAttorney$25,000;LatePenalty$20,000;aswellasStateLawCosts$15,000duetocontinuedcollectionefforts. Unfav.OrdinanceFinesandCosts($575,000)partiallyduetothereductionincaseloadfrommarijuanalegalizationandpartiallyduetoCOVID-19pandemic.Unfav.ProbationFees($250,000);RefundFeesPDDefAttorney($60,000);aswellasStateLawCosts($50,000)partiallyduetochangeinlegislationandpartiallyduetothepandemic.Fav.GrossEstateFees$35,000duetoaincreaseinfeespaid.Fav.CertifiedCopies$25,000andPhotostats$20,000duetoanincreaseinactivity.PartiallyoffsetbyUnfav.RefundFeesPDDefAttorney($7,500)duetoadecreaseinfeescollected.TheoverarchingcauseofthevariancesidentifiedaboveisalsoduetotheCOVID-19pandemic.Unfav.StateAppropVictimWitness($38,000)primarilyduetounplannedspendingofCrimeVictimRightsgrantfundingfordirectvictimneeds;offsetbyoperatingexpenditureProfessionalServicesfavorability.Also,unfav.ReimbGeneral($14,000)at46thDistrictCourtandExtraditionRecoveryFee($8,000)duetolessactivityas aresultoftheCOVID-19pandemic.Fav.primarilyReimbGeneralduetoabandonedvehicleauctionreimbursementfromtheStateofMichigan. Unfav.Fingerprints($150,000),Photostats($20,000)andRegistrationFees($20,000)duetoreducedactivityasaresultoftheCOVID-19pandemic;partiallyoffsetbyfav.FOIAFees$25,000andFeeIncome$4,000duetoincreasedactivity.42
Sheriff-CorrectiveServicesSheriff-CorrectiveServicesSatellitesSheriff-EmergencyResponseandPrepSheriff-PatrolServicesSheriff-EmergencyCommunicationsOperationsSheriff-InvestigativeForensicServicesTotalLawEnforcementGeneralGovernmentClerk-CountyClerkClerk-ElectionsADOPTEDBUDGET2,961,000.00587,012.00300,000.0059,251,411.002,785,992.001,215,000.00COUNTYOFOAKLANDGENERALFUND/GENERALPURPOSEREVENUESFY2022FIRSTQUARTERREPORTAMENDEDBUDGET2,961,000.00587,012.00321,816.0060,270,296.002,785,992.001,215,000.00FY2022FORECAST1,680,000.00527,012.00126,816.0060,260,296.002,785,992.00465,000.00AMOUNTFAVORABLE(UNFAVORABLE)(1,281,000.00)(60,000.00)(195,000.00)(10,000.00)(750,000.00) 68,282,364.002,216,100.0093,700.00$69,327,865.002,216,100.0093,700.00$66,816,665.002,446,100.0093,700.00(2,511,200.00)230,000.00PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES-43.26%Unfav.DivertedFelon($800,000)duetoareductioninthenumberofinmatesthatmeetreimbursementcriteria.Also,unfav.CommissionsContracts($350,000)duetolimitedcommissaryavailabilityduringpandemic,OUILThirdOffense($65,000)duetonotbeingabletobillforassessmentswhentheoffenderisnolongerincustody,InmateBoardandCare($25,000)andClinicCharges($20,000)bothfrominmatesinabilitytoreimburseforboardandclinicservices,TransportationofPrisoners($7,000)duetoareductionininmatesneedingtransportandDentalServicesFee($3,000)duetoinmantesinabilitytoreimbursefordentalservices.ThereductioninthenumberofinmatesisinresponsetoCOVID-19pandemicandisamajorcontributingfactorinthevariances. -10.22%Unfav.BoardandCare($42,000)duetolessthananticipatedreferralsfromjudgestothetetherprogram.Alsounfav.ReimbCourtServices($18,000)forcourtsecuritytonon52ndDistrictCourtswhicharerealizinglowercourtactivityduetotheCOVID-19pandemicandpartiallyoffsetbyfavorablepersonnelcostsrelatingtopart-timenon-eligiblecourtsecuritypersonnelandvacantpositi-60.59%Unfav.CivilActionServiceFees($195,000)duetoareductioninservicesduetotheCOVID-19pandemicandlessactivity;partiallyoffsetbyreducedoperatingexpenditures.-0.02%Unfav.ImpoundFees($10,000)duetolessactivity. 0.00%-61.73%Unfav.primarilyduetoDrugTesting($750,000)astheResultstestingprogramwasshutdownduetotheCOVID-19pandemic.Ithasreopenedandisexperiencingalowernumberofclients.Partiallyoffsetbyfavorableoperatingexpenditures.-3.62%10.38%Fav.Photostats$130,000,CertifiedCopies$60,000,JuryFees$40,000duetoincreasedactivity.0.00%43
ADOPTEDBUDGETClerk-RegisterofDeeds&Micrographics13,492,500.003,395,600.007,200.00TreasurerBoardofCommissionersWaterResourcesCommissioner3,446,278.00COUNTYOFOAKLANDGENERALFUND/GENERALPURPOSEREVENUESFY2022FIRSTQUARTERREPORTFY2022FORECAST16,592,500.00AMENDEDBUDGET13,492,500.003,395,600.007,200.003,395,600.002,200.003,446,278.003,446,278.00AMOUNTFAVORABLE(UNFAVORABLE)3,100,000.00(5,000.00) TotalGeneralGovernment$22,651,378.00CountyExecutiveCountyExec-CorpCounsel-CountyExec-Admin-3,382,475.00505,600.00M&B-EqualizationDivisionM&B-FiscalServicesDivision415,690.00316,000.00M&B-PurchasingDivisionCentralServices-SupportServicesHumanResourcesHHS-Administration2%HHS-HealthDivision4,754,115.00HHS-MSUExtension-PublicServices-CommunityCorrections155,000.00PublicServices-Children'sVillage3,314,097.0022,651,378.00$25,976,378.00$-1,400.003,382,475.00421,600.003,382,475.00505,600.00415,690.00316,000.00415,690.00287,200.00-4,000.004,756,443.004,757,743.00155,000.0010,000.003,314,097.005,314,097.003,325,000.001,400.00(84,000.00)(28,800.00)4,000.001,300.00(145,000.00)2,000,000.00PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES22.98%Fav.LandTransferTax$3,000,000andMortgages$100,000duetoincreasedactivity.0.00%-69.44%Unfav.MiscellaneousRevenue($3,000)duetolowerbooksalesrevenueandCopierMachineCharges($2,000)duelowercomputerprintoutrevenueasaresultofpubliccomputersnotbeingavailableduringCOVID-19pandemic.14.68%Fav.primarilyforFOIAFees.0.00%-16.61%Unfav.CourtOrderedBoardandCare($70,000),LatePenalty($4,000),andTaxInterceptFee($10,000)duetocourtactivity.0.00%-9.11%Unfav.CommissionVendingMachines($28,800)duetolimitedstaffatCountybuildingsduringCOVID-19restrictionsandnewvendorcontractinAprilof2021.0.00%100.00%Fav.DuetoStateofMichiganreceiptsforpsychologicalevaluations.0.03%Fav.DuetoFOIAfees.0.00%-93.55%Unfav.FeeIncome($145,000)duetolessthananticipatedreferralsfromjudgestotheWeekendandWeekdayAlternativeforMisdemeanants(WWAM)Program.Inaddition,theprogramissuspendedduetotheCOVID-19pandemic.60.35%Fav.OutCountyBoardandCare$2,000,000duetoDepartmentofHealthandHumanServicesplacement.AG
PublicServices-MedicalExaminerPublicServices-AnimalControlPublicServices-CircuitCourtProbationEconomicDevelopment-Planning&LocalBusDev.(FKAPEDS)TotalCountyExecutiveNon-DepartmentalNon-Dept-ChargesforServicesTotalNon-DepartmentalTotalChargesforServicesINDIRECTCOSTRECOVERY(640100)INVESTMENTINCOME(655000-655999)DistrictCourts(Div.|IV)SheriffCorrectiveServices SheriffInvestigative/TechnicalServicesTreasurerClerk/RegisterofDeedsEconomicDevelopmentNon-DepartmentalTotalInvestmentIncome CircuitCourt-DonationsCircuitCourtCircuitCourt-TransfersInDistrictCourts(Div.|-IV)DistrictCourts(Div.|-IV)ProbateCourtProsecutingAttorneySheriffOfficeADOPTEDBUDGET445,100.001,447,014.00416,708.00COUNTYOFOAKLANDGENERALFUND/GENERALPURPOSEREVENUESFY2022FIRSTQUARTERREPORTAMENDEDBUDGET445,100.001,447,014.00416,708.00FY2022FORECAST445,100.001,447,014.00416,708.00AMOUNTFAVORABLE(UNFAVORABLE) 15,151,799.00918,565.0015,154,127.00918,565.00$16,903,027.00918,565.001,748,900.00 AR918,565.00124,145,227.00Pr Ff |F®OH HF
9,100,000.002,200.00150,000.002,500.003,000,000.00918,565.00125,193,056.009,100,000.002,200.00150,000.002,500.003,000,000.00$918,565.00$124,508,256.00$9,100,000.002,200.00150,000.002,500.001,365,451.00(684,800.00)(1,634,549.00) 3,154,700.00$3,154,700.00$1,520,151.00$(1,634,549.00)PERCENT0.00%0.00%0.00%0.00%11.54%0.00%0.00%-0.55%0.00%0.00%0.00%0.00%0.00%0.00%0.00%-54.48%-51.81%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%EXPLANATIONOFSIGNIFICANTVARIANCESUnfav.duetoinvestmentbaseandmarketrateadjustments.Sheriff-AdministrativeServices----0.00%Sheriff-CorrectiveServices----0.00%Sheriff-CorrectiveServices-Satellites“--.0.00%Sheriff-EmergencyRespandPrepare-Donations----0.00%Sheriff-PatrolServices12,000.0042,000.0012,000.00-0.00%Sheriff-PatrolServices-Donations----0.00%Sheriff-EmergencyCommunicationsOperations----0.00%45
COUNTYOFOAKLANDGENERALFUND/GENERALPURPOSEREVENUESFY2022FIRSTQUARTERREPORTAMOUNTADOPTEDAMENDEDFY2022FAVORABLEBUDGETBUDGETFORECAST(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCESSheriff-Investigative/ForensicSvc3,000.003,000.0013,782.0010,782.00359.40%Fav.RefundPriorYearsExpenditures$13,782forreimbursementofFY2021SheriffsovertimefortheOrganizedCrimeDrugEnforcementTaskForce(OCDETF);partiallyoffsetbyunfav.CountyAuction($3,000)duetoCOVID-19pandemic.Clerk-Elections----0.00%Clerk-RegisterofDeeds&Micrographics----0.00%Treasurer----0.00%BoardofCommissioners----0.00%BoardofCommissioners-Contributions----0.00%WaterResourcesCommissioner-a-.0.00%CountyExec-ComplianceOffice----0.00%ManagementandBudget-FiscalServices----0.00%CentralServices-SupportServices4,500.001,500.001,500.00-0.00%HumanResources----0.00%FacilitiesManagementEngineering----0.00%HealthAdministration--6,300.006,300.00100.00%Fav.DuetoPriorYearsRevenuetorecognizecurrentyearPsychEvaluationrevenuevsprioryear. HealthDivision-Donations--100.00100.00100.00%Fav.DuetoCountyDonationsreceived.--800.00800.004100.00%Fav.PriorYearsRevenueforcorrectionofFY2021estimatedadministrationoverheadcostdistributionforLocalHealthDepartmentGrant(formerlyComprehensivePlanning,Budgeting,andContractinggrant). HealthDivision-TransfersIn----0.00%Children'sVillage----0.00%Children'sVillage-TransfersIn----0.00%HomelandSecurity----0.00%EMG-HomelandSecurity--700.00700.00100.00%Fav.DuetoPriorYearsRevenuefromHazardousMaterialsEmergencyPreparedness(HMEP)grant.PublicServices-MedicalExaminer----0.00%PublicServices-AnimalControl-OtherRevenueszé-20.00%PublicServices-AnimalControl-TransfersInés-2s.0.00%PublicServices-Children'sVillage-OtherRevenues----0.00%EconomicDevelopment&CommAffairs-Contributions*x-és0.00%EconomicDevelopment-Contributions“%a70.00%EconomicDevelopment-TransfersIn----0.00%NonDepartmental-Donations---0.00%46
Non-Dept-SundrySheriffs'TransfersInTreasurers'TransfersInNon-Departmental-TransfersInTotalOtherRevenuesPLANNEDUSEOFFUNDBALANCE(665000-665999)EncumbrancesandCarryforwardsUseofPriorYrsFundBalanceTotalPlannedUseofFundBalanceTOTALGEN.FUND/GEN.PURPOSEREVENUEADOPTEDBUDGET417,500.002,300,000.003,000,000.00COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTAMENDEDBUDGET417,500.002,300,000.003,000,000.00FY2022FORECAST417,500.002,300,000.003,000,000.00GENERALFUND/GENERALPURPOSEREVENUESAMOUNTFAVORABLE(UNFAVORABLE) AIA5,734,000.0016,544,257.0016,544,257.00491,723,016.005,734,000.0012,251,787.1321,181,032.0033,432,819.13516,880,358.13$5,752,682.0012,251,787.1321,181,032.0033,432,819.13511,767,291.1318,682.00(5,113,067.00)PERCENT0.00%0.00%0.00%0.00%0.33%0.00%0.00%0.00%-0.99%EXPLANATIONOFSIGNIFICANTVARIANCES47
JudicialAdministrationPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransferOutBusinessDivisionPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOutCOUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESCIRCUITCOURTAMOUNTADOPTEDAMENDEDFY2022FAVORABLEBUDGETBUDGETFORECAST(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES$10,278,596.00$10,278,596.00$10,028,596.00$250,000.002.43%-Fav.duetounderfilledandvacantpositions.224,828.00874,610.50294,610.50580,000.0066.32%Fav.ExpendableEquipment$475,000andTraining$30,000duetolowerthananticipateduse.Fav.SpecialProjects$75,000duetotheunuseddistributionofJudicialTechnologyfundsfromtheStateandJudgeOn-Lineproject(MR#09017)forcourtroomtechnologyimprovements.TheoverarchingcauseofthevariancesidentifiedaboveisduetotheCOVID-19pandemic.437,261.00462,588.00537,588.00(75,000.00)-16.21%-Unfav.InfoTechOperations($75,000)duetohigherthanpateduse.Theoverarchingcauseofthevariancesidentifiedaboveisduetothepandemic. $10,940,685.00$11,615,794.50$10,860,794.50$755,000.006.50%$2,131,215.00$2,131,215.00$2,121,215.00$10,000.000.47%-Fav.duetounderfilledandvacantpositions.149,871.00139,871.00104,871.0035,000.0025.02%-Fav.VisitingJudges$15,000duetolowerthananticipateduse.Fav.TravelandConference$20,000duetolimitingtravelas aresultofCOVID.TheoverarchingcauseofthevariancesidentifiedaboveisduetotheCOVID-19pandemic.253,311.00253,311.00263,311.00(10,000.00)-3.95%-Unfav.InfoTechOperations($10,000)duetohigherthananticipateduse.Theoverarchingcauseofthevariancesidentifiedaboveisduetothepandemic. $2,534,397.00$2,524,397.00$2,489,397.00$35,000.001.39%48
COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESCIRCUITCOURTAMOUNTFAVORABLE(UNFAVORABLE)ADOPTEDBUDGETAMENDEDBUDGETFY2022FORECASTPERCENTEXPLANATIONOFSIGNIFICANTVARIANCES Civil/CriminalDivisionPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOutFamilyDivision/JuvenileMaint.PersonnelExpendituresOperatingExpenditures1,668,749.00$1,286,589.00$1,666,184.00$1,698,749.00$1,821,589.001,761,589.0030,000.00475,000.002,348,914.002,624,552.002,674,552.00(50,000.00)1,867,162.001,850,703.001,850,703.00- $7,703,849.00$7,935,593.00$7,480,593.00$455,000.005.73%$12,166,169.009,304,941.00$12,324,593.009,300,143.42$11,824,593.00$4,550,143.42500,000.004,750,000.001.77%-Fav.duetounderfilledandvacantpositions.26.96%-Fav.JurorFeesandMileage$300,000;TranscriptonAppeals$100,000;DefenseAttyFeesAppellate$70,000;andOfficeSupplies$40,000duetolowerthananticipateduse.Partiallyoffsetbyunfav.AttorneyFeesMediators($35,000)duetoincreaseinactivity.TheoverarchingcauseofthevariancesidentifiedaboveisduetotheCOVID-19pandemic.-1.91%-Unfav.InfoTechOperations($35,000)andTelephoneCommunications($15,000)duetohigherthananticipateduse.TheoverarchingcauseofthevariancesidentifiedaboveisduetotheCOVID-19pandemic.4.06%-Fav.duetounderfilledandvacantpositions.51.07%-Fav.duetodecreaseinplacementstoStateInstitutions$2,500,000andPrivInstitutionsResidential$1,500,000basedoncaseload,difficultyofcare,andtreatmentofservicesorderedbytheCourt.Fav.DefenseAttyFees$400,000,FeesGuardianAdLitem$225,000,ProfessionalServices$125,000duetolowerthananticipateduse.OffsetbyunfavorableNon-DeptChildCareSubsidyRevenue(50%Reimbursement).TheoverarchingcauseofthevariancesidentifiedaboveisduetotheCOVID-19pandemic.49
COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESCIRCUITCOURTAMOUNTADOPTEDAMENDEDFY2022FAVORABLEBUDGETBUDGETFORECAST(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCESInternalSupportExpenditures2,265,050.002,266,132.002,541,132.00(275,000.00)-12.14%-Unfav.InfoTechOperations($275,000)duetohigherthananticipateduse.Theoverarchingcauseofthevarianceidentifiedaboveisduetothepandemic.TransferOut6,568,662.006,568,662.006,568,662.00-0.00%- $30,304,822.00$30,459,530.42$25,484,530.42$4,975,000.0016.33%DepartmentTotalPersonnelExpenditures$26,242,164.00$26,433,153.00$25,643,153.00$790,000.002.99%OperatingExpenditures11,501,229.0012,076,213.926,236,213.925,840,000.0048.36%InternalSupportExpenditures5,304,536.005,606,583.006,016,583.00(410,000.00)-7.31%8,419,365.00-0.00% $51,483,753.00$52,535,314.92$46,315,314.92$6,220,000.0011.84%
ADOPTEDBUDGETAMENDEDBUDGETCOUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESDISTRICTCOURTFY2022FORECASTAMOUNTFAVORABLE(UNFAVORABLE)PERCENT DistrictCourtAdministrationPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOutDivision1-NoviPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOutTotalDivision1-Novi247,868.0010,300.002,329.00$247,868.0010,300.002,329.00$247,868.002,800.002,329.007,500.00 260,497.004,638,850.00883,715.00424,011.00$260,497.00$4,638,850.00883,715.00439,052.00252,997.004,638,850.00898,715.00421,552.00$7,500.00(15,000.00)17,500.00 5,946,576.00$5,961,617.005,959,117.00$2,500.000.00%72.82%0.00%0.00%2.88%0.00%-1.70%3.99%0.00%0.04%EXPLANATIONOFSIGNIFICANTVARIANCES Fav.VisitingJudges$7,500duetolowerthananticipateduse.TheoverarchingcauseofthevarianceidentifiedaboveisduetotheCOVID-19pandemic.Unfav.BuildingMaintenanceCharges($40,000)primarilyduetoupgradeinsecuritycamerasystem.Partiallyoffsetbyfav.SoftwareSupportMaintenance$10,000,OfficeSupplies$5,000,LibraryContinuations$5,000,aswellasElectricalService$5,000duetolowerthananticipateduse.TheoverarchingcauseofthevariancesidentifiedaboveisduetotheCOVID-19pandemic.Fav.TelephoneCommunications$25,000duetolowerthananticipateduse.Partiallyoffsetbyunfav.InfoTechOperations($7,500)duetohigherthananticipateduse.TheoverarchingcauseofthevariancesidentifiedaboveisduetotheCOVID-19pandemic.51
COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESDISTRICTCOURTAMOUNTADOPTEDAMENDEDFY2022FAVORABLEBUDGETBUDGETFORECAST(UNFAVORABLE)PERCENT Division2-ClarkstonPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOutTotalDivision2-ClarkstonDivision3-RochesterHillsPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOut2,494,928.00$2,494,928.00$2,394,928.00100,000.004.01%557,759.00577,216.52564,716.5212,500.002.17%249,434.00264,911.00262,911.002,000.000.75%- ---0.00% $3,302,121.00$3,337,055.52$ 3,222,555.52$114,500.003.43%3,929,093.00$3,929,093.00$3,779,093.00150,000.003.82%278,427.00278,427.00243,427.0035,000.0012.57%924,917.00934,720.00919,720.0015,000.001.60%- - - -0.00% 5,132,437.00$5,142,240.00$4,942,240.00$§$200,000.003.89%EXPLANATIONOFSIGNIFICANTVARIANCES Fav.duetoturnoverandunderfilledpositions/vacancies.Fav.ElectricalService$5,000aswellasJurorFeesandMileage$2,500duetolowerthananticipateduse.Fav.BankCharges$2,500duetolowerthananticipatedcosts.Fav.TravelandConference$2,500duetolimitingtravelasaresultofthepandemic.TheoverarchingcauseofthevariancesidentifiedaboveisduetotheCOVID-19pandemic.Fav.TelephoneCommunications$17,000duetolowerthananticipateduse.Partiallyoffsetbyunfav.InfoTechOperations($15,000)duetohigherthananticipateduse.TheoverarchingcauseofthevariancesidentifiedaboveisduetotheCOVID-19pandemic.Fav.duetoturnoverandunderfilledpositions/vacancies.Fav.OfficeSupplies$15,000,PostageStandardMailing$10,000,aswellasJurorFeesandMileage$10,000duetolowerthananticipateduse.TheoverarchingcauseofthevariancesidentifiedaboveisduetotheCOVID-19pandemic.Fav.TelephoneCommunications$20,000duetolowerthananticipateduse.Partiallyoffsetbyunfav.InfoTechOperations($5,000)duetohigherthananticipateduse.TheoverarchingcauseofthevariancesidentifiedaboveisduetotheCOVID-19pandemic.52
Division4-TroyPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresDepartmentTotalPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOutADOPTEDBUDGET$ 2,698,725.00447,072.00296,789.00AMENDEDBUDGET$2,698,725.00449,740.50303,671.00COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESDISTRICTCOURTFY2022FORECAST$ 2,673,725.00429,740.50288,671.00AMOUNTFAVORABLE25,000.0020,000.0015,000.00 $ 3,442,586.00$14,009,464.002,177,273.001,897,480.00$3,452,136.50$14,009,464.002,199,399.021,944,683.00$ 3,392,136.50$13,734,464.002,139,399.021,895,183.00$60,000.00$275,000.0060,000.0049,500.00 $18,084,217.00$18,153,546.02$17,769,046.02$384,500.00 (UNFAVORABLE)PERCENT0.93%4.45%4.94%1.74%1.96%2.73%2.55%2.12%EXPLANATIONOFSIGNIFICANTVARIANCES Fav.duetoturnoverandunderfilledpositions/vacancies.Fav.InterpreterFees$17,500andOfficeSupplies$2,500duetolessthananticipateduse.TheoverarchingcauseofthevarianceidentifiedaboveisduetotheCOVID-19pandemic.Fav.TelephoneCommunications$15,000duetolowerthananticipateduse.TheoverarchingcauseofthevarianceisduetotheCOVID-19pandemic.53
COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESPROBATECOURTAMOUNTADOPTEDAMENDEDFY2022FAVORABLEBUDGETBUDGETFORECAST(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES Judicial/AdministrationPersonnelExpenditures$2,708,080.00$2,708,080.00$2,583,080.00$125,000.004.62%Fav.duetounderfilledpositions/vacancies.OperatingExpenditures22,481.0022,481.008,981.0013,500.0060.05%Fav.LibraryContinuations$10,000;CourtReporterServices$2,000;aswellasMembershipDues$1,500duetolowerthananticipateduseasitrelatestotheCOVID-19pandemic.InternalSupportExpenditures483,138.00483,138.00493,138.00(10,000.00) -2.07%Unfav.InfoTechOperations($10,000)duetomorethananticipateduse.---- $3,213,699.00$3,213,699.00$3,085,199.00$128,500.004.00%Estates/MentalHealthPersonnelExpenditures$2,437,030.00$2,451,025.00$2,376,025.00$75,000.003.06%Fav.duetounderfilledpositions/vacancies.OperatingExpenditures1,007,943.001,014,343.001,024,343.00(10,000.00) -0.99%Unfav.MedicalServicesProbateExam($55,000)duetocontinuedhighdemandfortheseservices.Partiallyoffsetbyfav.DefenseAttorneyFees$45,000duetoadecreasednumberofcasefilingsandlowerdemandfortheseservices.TheoverarchingcauseofthevariancesidentifiedaboveisalsoduetotheCOVID-19pandemic.InternalSupportExpenditures611,578.00624,524.00649,524.00(25,000.00) -4.00%Unfav.InfoTechOperations($25,000)duetomorethananticipateduse. $4,056,551.00$4,089,892.00$4,049,892.00$40,000.000.98%DepartmentTotalPersonnelExpenditures$5,145,110.00$5,159,105.00$4,959,105.00$200,000.003.88%OperatingExpenditures1,030,424.001,036,824.001,033,324.003,500.000.34%InternalSupportExpenditures1,094,716.001,107,662.001,142,662.00(35,000.00) -3.16%TransferOut---- $7,270,250.00$7,303,591.00$7,135,091.00$168,500.002.31%
COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESPROSECUTINGATTORNEYADOPTEDAMENDEDFY2022FAVORABLEBUDGETBUDGETFORECAST(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES AdministrationPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOutLitigationPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOutWarrantsPersonnelExpendituresOperatingExpendituresInternalSupportExpenditures3,397,894.00$3,371,891.00$3,121,891.00$250,000.007.41%565,611.00701,623.00556,623.00145,000.0020.67%2,186,442.002,227,485.002,267,485.00(40,000.00)-1.80%----0.00% 6,149,947.00$6,300,999.00$5,945,999.00$355,000.005.63%12,275,096.00$12,427,881.00$11,527,881.00$900,000.007.24%27,801.00630,051.00615,051.0015,000.002.38%47,295.0047,295.00 47,295.00-0.00%1,010,567.001,220,257.0041,220,257.00-0.00% 13,360,759.00$14,325,484.00$13,410,484.00$915,000.006.39%2,123,380.00$2,123,380.00$2,003,380.00$120,000.005.65%3,199.003,199.001,199.002,000.0062.52%7,295.007,295.007,295.00-0.00% 2,133,874.00$2,133,874.00$2,011,874.00$122,000.005.72%Fav.SalariesandFringeBenefitsduetovacanciesandturnover;partiallyoffsetbyunfav.Overtime.Fav.ProfessionalServices$38,000duetolessthananticipateduse.Also,fav.LibraryContinuations$30,000,WitnessFeesandMileage$25,000,Printing$15,000,ExtraditionExpense$10,000,ExpertWitnessFeeandMileage$10,00,FilingFees$9,000,ComputerEquipment$4,800andOfficeSupplies$3,500duetolessthananticipateduse.Unfav.InfoTechOperations($91,000)andTelephoneCommunications($13,500)duetousage;partiallyoffsetbyfav.InfoTechManagedPrintServices$45,000,MotorPool$9,800,EquipmentRental$5,480andRadioCommunications$4,000duetolessthananticipateduse.Fav. SalariesandFringeBenefitsduetovacanciesandturnover;partiallyoffsetbyunfav.Overtime.Fav.PersonalMileageduetolessthananticipateduse.Fav.SalariesandFringeBenefitsduetoturnover.Fav.PersonalMileageduetolessthananticipateduse.55
ADOPTEDBUDGETAMENDEDBUDGETCOUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESPROSECUTINGATTORNEYFY2022FORECASTFAVORABLE(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES AppellatePersonnelExpendituresOperatingExpendituresInternalSupportExpendituresDepartmentPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOut2,099,680.003,500.006,133.00$2,094,180.003,500.006,133.00$1,944,180.00500.006,133.00150,000.003,000.00 $2,109,313.0019,896,050.00600,111.002,247,165.001,010,567.00$$2,103,813.0020,017,332.001,338,373.002,288,208.001,220,257.00$$1,950,813.0018,597,332.001,173,373.002,328,208.001,220,257.00153,000.001,420,000.00465,000.00(40,000.00) 23,753,893.00$24,864,170.00$23,319,170.001,545,000.007.16%85.71%0.00%7.27%7.09%12.33%-1.75%0.00%6.21%Fav.SalariesandFringeBenefitsduetovacanciesandturnover;partiallyoffsetbyunfav.Overtime.Fav.PersonalMileageduetolessthananticipateduse.56
COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESSHERIFF'SOFFICEAMOUNTADOPTEDAMENDEDFY2022FAVORABLEBUDGETBUDGETFORECAST(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES Sheriff'sOfficePersonnelExpenditures$ 2,018,597.00$2,018,597.00$1,618,597.00$400,000.0019.82%Fav.duetoturnoverandOvertime.OperatingExpenditures93,020.0093,020.0053,020.0040,000.0043.00%Fav.ContractedServices$12,000,LibraryContinuations$10,000,OfficeSupplies$6,000,MaterialandSupplies$5,000,Communications$2,500,WorkshopsandMeeting$2,000andMembershipDues$1,500duetolessthananticipateduse.InternalSupportExpenditures862,229.00862,229.00532,229.00330,000.0038.27%Fav.InfoTechOperations$340,000andTelephoneCommunications$2,500duetolessthananticipateduse;partiallyoffsetbyunfav.MotorPool($9,000)andMotorPoolFuelCharges($3,500)duetousage. $2,973,846.00$2,973,846.00$2,203,846.00$770,000.0025.89%AdministrativeServicesPersonnelExpenditures$1,328,216.00$1,328,216.00$1,228,216.00100,000.007.53%Fav.duetovacantpositionsandturnover.OperatingExpenditures515,668.00563,668.00478,668.0085,000.0015.08%Fav.Printing$55,000,LibraryContinuations$20,000,UniformCleaning$10,000andTravelandConference$5,000duetolessthananticipateduse;partiallyoffsetbyunfav.Uniforms($10,000)duetousage.InternalSupportExpenditures171,233.00171,233.00175,233.00(4,000.00) -2.34%—_Unfav.Info.TechOperations($8,000)andTelephoneCommunications($2,000)duetousage;partiallyoffsetbyfav.InfoTechManagedPrintServices$6,000duetolessthananticipateduse. $2,015,117.00$2,063,117.00$1,882,117.00$181,000.008.77%CorrectiveServicesPersonnelExpenditures36,190,938.0036,431,180.00$36,231,180.00200,000.000.55%Fav.SalariesandFringeBenefitsasaresultofvacantpositions,turnover,officersintheacademyandofficersintraining.Also,COVID-19pandemichascontributedtoadditionalleavetime;partiallyoffsetbyunfav.OvertimeofwhichaportionisattributabletoCOVID-19pandemic.OperatingExpenditures7,631 ,253.007,736,098.007,606,098.00130,000.001.68%Fav.BeddingandLinen$20,500,OtherExpendableEquipment$19,000,IndigentOrders$14,000,InterpreterFees$10,300,EquipmentMaintenance$10,000,ComputerSupplies$10,000,CulinarySupplies$10,000,LaundryandCleaning$9,000,OfficeSupplies$8,200,PrisonerHousing-Outside$8,000andTransportationofPrisoners$5,000duetolessthananticipateduse.57
COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESSHERIFF'SOFFICEAMOUNTADOPTEDAMENDEDFY2022FAVORABLEBUDGETBUDGETFORECAST(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES InternalSupportExpenditures8,099,869.008,194,490.008,059,490.00135,000.001.65%Fav.RadioCommunications$100,000,InfoTechOperations$43,000andInfoTechManagedPrintServices$34,000duetolessthananticipateduse;partiallyoffsetbyunfav.TelephoneCommunications($22,000),MotorPool($14,000)andMotorPoolFuelCharges($11,000)duetousage. $51,922,060.00$52,361,768.00$51,896,768.00$465,000.000.89%CorrectiveServices-SatellitesPersonnelExpenditures$15,183,977.00$15,183,977.00$10,683,977.00$4,500,000.0029.64%Fav.SalariesandFringeBenefitsofwhichaportionisduetotheCOVID-19pandemicandrelatedcourtclosures(partiallyoffsetbyunfav.revenueforReimbursementCourtServices).Favorabilityisalsoattributabletovacantpositions,turnoverandOvertime.OperatingExpenditures139,797.00140,503.0085,503.00 55,000.0039.15%Fav.LaundryandCleaning$25,000,CustodialSupplies$20,000,EquipmentMaintenance$10,000,TravelEmployeeTaxableMeals$3,500andPrinting$3,000duetolessthananticipateduse.InternalSupportExpenditures1,735,262.001,735,262.001,746,262.00(11,000.00) -0.63%Unfav.MotorPoolFuelCharges($5,000),TelephoneCommunications($3,500)andInfoTechOperations($2,000)duetousage. $17,059,036.00$17,059,742.00$12,515,742.00$4,544,000.0026.64%EmergencyResponseandPreparednessPersonnelExpenditures$ 3,903,500.00$4,050,399.00$6,300,399.00§$(2,250,000.00)-55.55%—_Unfav.Salaries,FringeBenefitsandOTduetoadditionaltrainingclassesandinstructorsduetoreducedclasssize(COVID)aswellastheongoingresponsetoincreasedthreatsasrelatedtoschoolsandthecommunity.OperatingExpenditures1,223,056.003,514,610.343,464,610.3450,000.001.42%Fav.FeesCivilService$100,000whichisoffsetincorrespondingunfavorablerevenue.Alsofav.ProfessionalServices$50,000andEmployeesMedicalExams$40,000duetolessthananticipateduse;partiallyoffsetbyunfav.OfficersTraining($105,000)duetousageandElectricalService($26,000)andNaturalGas($11,000)duetoadditionaluseoftheBrandontrainingfacilityforOxfordHighSchoolshootingincidentdebriefings.InternalSupportExpenditures531,142.00531,142.00521,142.0010,000.001.88%Fav.InfoTechManagedPrintServices$9,000andInfoTechCLEMIS$2,800duetolessthananticipateduse;partiallyoffsetbyunfav.TelephoneCommunications($1,200)duetoincreasedusage. $ 5,657,698.00$8,096,151.34$10,286,151.34$(2,190,000.00)-27.05%58
COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESSHERIFF'SOFFICEAMOUNTADOPTEDAMENDEDFY2022FAVORABLEBUDGETBUDGETFORECAST(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES PatrolServicesPersonnelExpenditures$57,154,089$57,503,390.00$56,103,390.00$1,400,000.002.43%Fav.SalariesandFringeBenefitsduetovacantpositionsandturnoverandaportionwhichisduetothepandemicandrelatedeventcancellation;partiallyoffsetbyunfav.Overtime.OperatingExpenditures1,465,857.001,867,109.711,767,109.71100,000.005.36%Fav.OtherExpendableEquipment$50,000,GasolineCharges$20,000,EquipmentRental$19,500andCommunications$7,800duetolessthananticipateduse.InternalSupportExpenditures7,444,860.007,457,395.007,657,395.00(200,000.00) -2.68%Unfav.MotorPoolFuelCharges($281,000),OfficeEquipmentRental($53,500),InfoTechOperations($53,000)andInfoTechEquipmentRental($20,000)duetousage;partiallyoffsetbyfav.MotorPool$165,300,InfoTechManagedPrintServices$18,000,TelephoneCommunications$17,000andRadioCommunications$8,000duetolessthananticipateduse.TransfersOut-116,241.00116,241.00-0.00% $66,064,806.00$66,944,135.71$65,644,135.71$1,300,000.001.94%EmergencyCommunicationsOperationsPersonnelExpenditures$10,100,907.00$10,134,745.00$10,834,745.00$(700,000.00)-6.91% Unfav.OvertimeofwhichaportionisattributabletoCOVID-19pandemic;partiallyoffsetbyfav.SalariesandrelatedFringeBenefitsduetovacantpositionsandturnover.OperatingExpenditures205,100.00205,100.0090,100.00115,000.0056.07%Fav.EquipmentMaintenance$115,000andCommunications$1,100duetolessthananticipateduse;partiallyoffsetbyunfav.TravelandConference($3,000)duetousage.InternalSupportExpenditures292,778.00292,778.00254,778.0038,000.0012.98%Fav.RadioCommunications$47,700duetolessthananticipateduse;partiallyoffsetbyunfav.InfoTechOperations($10,000)duetousage.TransfersOut-12,433.0012,433.00-0.00% $10,598,785.00$10,645,056.00$11,192,056.00$(547,000.00)-5.14%59
ADOPTEDBUDGETAMENDEDBUDGETCOUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESSHERIFF'SOFFICEFY2022FORECASTAMOUNTFAVORABLE(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES Investigative/ForensicSvcsPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOutDepartmentTotalPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOut$ 9,612,485.00935,012.003,335,225.00334,086.00$ 9,653,868.00950,837.613,335,225.00884,880.00$ 9,353,868.00800,837.613,410,225.00884,880.00$300,000.00150,000.00(75,000.00) $14,216,808.00$135,492,709.00$12,208,763.00$22,472,598.00$334,086.00$14,824,810.61$136,304,372.00$15,070,946.66$22,579,754.00$ 1,013,554.00$14,449,810.61$132,354,372.00$14,345,946.66$22,356,754.00$ 1,013,554.00375,000.003,950,000.00725,000.00223,000.00 $170,508,156.00$ 174,968,626.66$170,070,626.664,898,000.00 3.11%15.78%-2.25%0.00%2.53%2.90%4.81%0.99%0.00%2.80%Fav.SalariesandFringeBenefitsduetoturnover.Fav.LaboratorySupplies$100,000whichisoffsetincorrespondingunfavorableDrugTestingrevenueduetoreducedhoursoftheRESULTSdrugtestingprogramasaresultoftheCOVID-19pandemic.Alsofav.SoftwareSupportMaintenance$20,000,DrugTesting$10,700,OfficeSupplies$10,500andExtraditionExpense$5,000duetolessthananticipateduse.Unfav.InfoTechOperations($139,000),MotorPoolFuelCharges($30,000),InfoTechCLEMIS($19,000)andTelephoneCommunications($15,000)duetousage;partiallyoffsetbyfav.MotorPool$109,000,RadioCommunications$11,000andInfoTechManagedPrintServices$8,000duetolessthananticipateduse.60
ADOPTEDBUDGETAMENDEDBUDGETCOUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESCLERK/REGISTEROFDEEDSAMOUNTFAVORABLE(UNFAVORABLE)PERCENTFY2022FORECASTEXPLANATIONOFSIGNIFICANTVARIANCES Administration673,778.0029,100.00PersonnelExpenditures$OperatingExpendituresInternalSupportExpenditures90,127.00TransfersOut-673,778.0029,100.0090,222.000.00%27.49%673,778.00$21,100.008,000.0090,222.00-0.00%0.00% $793,005.00CountyClerk(VitalStats&LegalRec's)PersonnelExpenditures$3,776,130.00OperatingExpenditures302,660.00InternalSupportExpenditures687,461.00TransfersOut=793,100.003,776,130.00302,660.00828,045.00785,100.00$8,000.001.01%3,451,130.00$325,000.008.61%0.00%0.00%0.00%302,660.00=828,045.00- $4,766,251.00ElectionsPersonnelExpenditures$1,027,684.00OperatingExpenditures960,223.00InternalSupportExpenditures304,777.00TransfersOut-4,906,835.001,027,684.00983,625.72313,882.004,581,835.00$325,000.006.62%12.16%0.00%0.00%0.00%902,684.00$125,000.00983,625.72-313,882.00- $ 2,292,684.00RegisterofDeeds(andMicrographics)PersonnelExpenditures$2,335,065.00OperatingExpenditures212,494.00InternalSupportExpenditures289,361.00TransfersOut-2,325,191.722,335,065.00212,494.00290,919.00AA2,200,191.72$125,000.005.38%2,235,065.00$100,000.004.28%0.00%0.00%0.00%212,494.00-290,919.00- $ 2,836,920.002,838,478.002,738,478.00$100,000.003.52%Fav.TravelandConference$4,000andPrinting$4,000duetolessthananticipateduse.Fav.duetoturnover,vacantandunderfilledpositions.Fav.duetoturnover,vacantandunderfilledpositions.Fav.duetoturnover,vacantandunderfilledpositions.61
JuryCommissionPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresDepartmentTotalPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOutADOPTEDBUDGET19,150.0017,935.00163.00$AMENDEDBUDGET19,150.0017,935.00163.00COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESCLERK/REGISTEROFDEEDSFY2022FORECAST$19,150.0017,935.00163.00AMOUNTFAVORABLE(UNFAVORABLE) 37,248.007,831,807.001,522,412.001,371,889.00$$37,248.007,831,807.001,545,814.721,523,231.00$37,248.00$ 7,281,807.001,537,814.721,523,231.00AAA550,000.008,000.00 10,726,108.00$10,900,852.72$10,342,852.72558,000.00 PERCENT0.00%0.00%0.00%0.00%7.02%0.52%0.00%0.00%5.12%EXPLANATIONOFSIGNIFICANTVARIANCES62
ADOPTEDBUDGETAdministrationPersonnelExpenditures$3,649,792.00OperatingExpenditures3,408,770.00InternalSupportExpenditures1,416,728.00TransfersOut120,000.00AMENDEDBUDGET$3,649,792.005,658,770.001,539,047.00240,000.00COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESCOUNTYTREASURERAMOUNTFAVORABLE(UNFAVORABLE)FY2022FORECAST$ 3,469,792.00$180,000.005,158,770.00500,000.001,539,047.00-240,000.00- DivisionTotal$8,595,290.00$11,087,609.00$10,407,609.00$680,000.00 DepartmentTotal$8,595,290.00$11,087,609.00$10,407,609.00$680,000.00 PERCENT4.93%8.84%0.00%0.00%6.13%6.13%EXPLANATIONOFSIGNIFICANTVARIANCESFav.duetoturnover,underfillsandvacantpositions.Fav.ContractedServices$200,000,FeesCivilService$200,000andForeclosureNotification$100,000duetolessthananticipateduse.63
AdministrationPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOutDepartmentTotalPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOutADOPTEDBUDGET$3,227,687.001,206,710.00765,548.00AMENDEDBUDGET$3,243,191.002,409,817.00775,060.00FY2022FORECAST(UNFAVORABLE)PERCENT$3,243,191.00$2,400,417.00$763,760.00COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESBOARDOFCOMMISSIONERS$AMOUNTFAVORABLE9,400.0011,300.00 $5,199,945.00$3,227,687.001,206,710.00765,548.00$6,428,068.00$3,243,191.002,409,817.00775,060.00$6,407,368.00$3,243,191.002,400,417.00763,760.00$20,700.009,400.0011,300.00 $5,199,945.00$6,428,068.00$6,407,368.0020,700.00 0.00%-EXPLANATIONOFSIGNIFICANTVARIANCES0.39%-Fav.PrimailyduetoPeriodicalsBooksPublishingduetolessthananticipateduse.1.46%0.32%0.00%0.39%1.46%0.32%Fav.primarilyduetoInfoTechManagedPrintServices$16,000duetoremotework.PartiallyoffsetbyunfavorableTelephoneCommunications($4,700)duetoincreaseduse.64
ADOPTEDBUDGETCOUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESWATERRESOURCESCOMMISSIONERAMOUNTAMENDEDFY2022FAVORABLEBUDGETFORECAST(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES WaterResourceCommissionerPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersDivisionTotalDepartmentTotal$226,282.00287,975.007,248,891.0056,165.00$226,282.00$226,282.00$-0.00%287,975.00287,975.00-0.00%7,277,596.007,277,596.00-0.00%56,165.0056,165.00-0.00% $7,819,313.00$7,848,018.00$7,848,018.00$-0.00% $7,819,313.00$7,848,018.00$ 7,848,018.00$-0.00% 65
COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESCOUNTYEXECUTIVEAMOUNTADOPTEDAMENDEDFY2022FAVORABLEBUDGETBUDGETFORECAST(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES AdministrationPersonnelExpenditures$2,277,890.00$2,277,890.002,277,890.00$-0.00%OperatingExpenditures318,357.00502,680.79502,680.79-0.00%InternalSupportExpenditures502,604.00529,797.00543,397.00(13,600.00)-2.57%Unfav.InfoTechOperations($22,000)duetousage.PartiallyoffsetbyfavorableInfoTechPrintManagedServices$9,000duetolessanticipateduse.TransferOut-3 . . $ 3,098,851.00$3,310,367.79$3,323,967.79$(13,600.00)-0.41%ComplianceOfficePersonnelExpenditures$183,291.00$183,291.00$183,291.00$-0.00%OperatingExpenditures271,653.00271,653.00271,653.00-0.00%InternalSupportExpenditures71,982.0071,982.0054,982.0017,000.0023.62%Fav.primarilyInfoTechOperations$17,000duetousage.TransferOut-- 7 a $526,926.00$526,926.00$509,926.00$17,000.003.23%
COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESCOUNTYEXECUTIVEAMOUNTADOPTEDAMENDEDFY2022FAVORABLEBUDGETBUDGETFORECAST(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES CorporationCounselPersonnelExpenditures$3,005,692.00$3,005,692.00$3,005,692.00$-0.00%OperatingExpenditures81,045.0081,045.0066,545.0014,500.0017.89%Fav.TravelandConference$7,500,OfficeSupplies$2,800,PersonalMileage$1,200,andComputerSupplies$1,000duetolessthananticipateduse.InternalSupportExpenditures281,694.00294,394.00301,094.00(6,700.00)-2.28%Unfav.InfoTechOperations,($12,000)duetousage;partiallyoffsetbyfavorableInfoTechManagedPrintServices$5,300duetodecreasedactivityasaresultofworkingremotely.TransferOut=ais - $ 3,368,431.00$3,381,131.00$3,373,331.00$7,800.000.23%OfficeofPublicCommunicationsPersonnelExpenditures$(4.00)$(4.00)$(4.00)$-Afirstquarterbudgetamendmentwillbemadecorrectingthepersonnelbudgets.ThisdivisionisnolongeraunitwithinCountyExecutive.ItwasreorganizedtobeanewdepartmenttitledDepartmentofPublicCommunications.OperatingExpenditures$-§-§$-$-InternalSupportExpenditures$~$-$.$.TransfersOut$-$-$-$- $(4.00)$(4.00)$(4.00)$:
ADOPTEDBUDGETCOUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTAMENDEDBUDGETEXPENDITURESCOUNTYEXECUTIVEFY2022FORECASTAMOUNTFAVORABLE(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES IndigentDefenseServicesPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOutDepartmentTotalPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOut90,040.0010,085.0090,040.0010,085.00 Ce Ff fF FI 5,466,869.00671,055.00856,280.00re Ft F&F AIF100,125.00$5,556,909.00$855,378.79906,258.00FA Ff FB HI Ww100,125.005,556,909.00840,878.79909,558.00Cr F&F FA FIA 30.00%14,500.001.70%(3,300.00)—_-0.36% 6,994,204.00$ 7,318,545.797,307,345.7911,200.000.15%68
ADOPTEDBUDGETAMENDEDBUDGETCOUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESMANAGEMENTANDBUDGETFY2022FORECASTAMOUNTFAVORABLE(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES AdministrationPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresEqualizationPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOutFiscalServicesPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOut$263,716.004,017.00172,981.00$263,716.004,017.00172,981.00$263,716.004,017.00172,981.00 $440,714.00$8,837,931.00421,404.00984,573.00$$440,714.008,891,456.00451,588.001,107,699.00$440,714.00$ 8,821,456.00451,588.001,107,699.00$70,000.00 $10,243,908.00$8,720,197.00652,800.001,732,709.00$$10,450,743.008,913,111.00756,540.211,813,241.00$10,380,743.00$ 8,713,111.00740,240.211,808,241.00$70,000.00$200,000.00$16,300.00$5,000.00 $11,105,706.00$11,482,892.21$11,261,592.21$221,300.000.00%0.00%0.00%0.00%0.79%0.00%0.00%0.00%0.67%2.24%2.15%0.28%0.00%1.93%Favorableduetovacancy.Favorableduetoturnoverandtiming ofreplacements.Fav.MeteredPostage$20,000,Printing$2,000,OfficeSupplies$2,000,andProvisions$1,000duetopandemic.PartiallyoffsetbyReimbursementPriorYearsRevenue($4,400)andFilingFees($4,300)duetomorethananticipatedactivity. FavorableInfoTechManagedPrintServicesduetoremotework.69
COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESMANAGEMENTANDBUDGETAMOUNTADOPTEDAMENDEDFY2022FAVORABLEBUDGETBUDGETFORECAST(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES PurchasingPersonnelExpenditures$1,167,261.00$1,167,261.00$1,167,261.00$-OperatingExpenditures11,925.0011,925.00$11,925.00$-InternalSupportExpenditures711,372.00711,867.00$ 711,867.00$-TransfersOut===we $1,890,558.00$1,891,053.00$1,891,053.00$-DepartmentTotalPersonnelExpenditures$18,989,105.00$19,235,544.00$18,965,544.00$270,000.00OperatingExpenditures1,090,146.001,224,070.211,207,770.2116,300.00InternalSupportExpenditures3,601,635.003,805,788.003,800,788.005,000.00TransfersOut---- $23,680,886.00$24,265,402.21$23,974,102.21$291,300.00 0.00%0.00%0.00%0.00%0.00%1.40%1.33%0.13%0.00%1.20%70
AdministrativePersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOutSupportServicesPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOutCOUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESCENTRALSERVICESAMOUNTFAVORABLE(UNFAVORABLE)ADOPTEDBUDGETAMENDEDBUDGETFY2022FORECASTPERCENT$269,024.00$269,024.00$74,224.00$194,800.0012.41%-3,298.003,298.0098.003,200.0097.03%-6,534.006,547.002,147.004,400.0067.21%-$278,856.00$278,869.00$76,469.00$202,400.0072.58%$1,232,842.00$1,232,842.00$1,232,842.00$-0.00%329,825.00334,745.00334,745.00-0.00%849,695.00858,986.00858,986.00-0.00%0.00% $2,412,362.00$2,426,573.00$2,426,573.00$-0.00%EXPLANATIONOFSIGNIFICANTVARIANCESFav.duetoretirementofdepartmentdirector.MiscellaneousResolution#22048titledHumanResources-ResolutionofPositionsandDeletionofCentralServicesDepartmentandfortheCreationofPerformanceManagementPositionswasapprovedbytheBOCinFebruary2022.TheresolutiondeletedtheCentralServicesDirectorposition/relatedoperatingcostsandwasusedtooffsetthecreationoftwoGeneralFundpositionsthatwillprovidesupportfortheCountyExecutive'simplementationofaperformancemanagementsystem.Fav.duetoretirementofdepartmentdirector.MiscellaneousResolution#22048titledHumanResources-ResolutionofPositionsandDeletionofCentralServicesDepartmentandfortheCreationofPerformanceManagementPositionswasapprovedbytheBOCinFebruary2022.TheresolutiondeletedtheCentralServicesDirectorposition/relatedoperatingcostsandwasusedtooffsetthecreationoftwoGeneralFundpositionsthatwillprovidesupportfortheCountyExecutive'simplementationofaperformancemanagementsystem.Fav.duetoretirementofdepartmentdirector.MiscellaneousResolution#22048titledHumanResources-ResolutionofPositionsandDeletionofCentralServicesDepartmentandfortheCreationofPerformanceManagementPositionswasapprovedbytheBOCinFebruary2022.TheresolutiondeletedtheCentralServicesDirectorposition/relatedoperatingcostsandwasusedtooffsetthecreationoftwoGeneralFundpositionsthatwillprovidesupportfortheCountyExecutive'simplementationofaperformancemanagementsystem.71
DepartmentTotalPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOutCOUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESCENTRALSERVICESAMOUNTADOPTEDAMENDEDFY2022FAVORABLEBUDGETBUDGETFORECAST(UNFAVORABLE)$1,501,866.00$1,501,866.00$1,307,066.00$194,800.00333,123.00338,043.00334,843.003,200.00856,229.00865,533.00861,133.004,400.00PERCENT12.97%0.95%0.51%0.00% $ 2,691,218.00$2,705,442.00$2,503,042.00$202,400.00 EXPLANATIONOFSIGNIFICANTVARIANCES72
COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESFACILITIESMANAGEMENTAMOUNTADOPTEDAMENDEDFY2022FAVORABLEBUDGETBUDGETFORECAST(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES AdministrationPersonnelExpenditures$250,505.00$250,505.00$250,505.00$-0.00%OperatingExpenditures2,687.002,687.001,687.001,000.0037.22%Fav.TravelandConference$500duetolimitingtravelasaresultofCOVID-19pandemic.Fav.MembershipDues$500duetolessthananticipatedusageasaresultofCOVID-19pandemic.InternalSupportExpenditures10,726.0010,726.0010,726.00-0.00% $263,918.00$263,918.00$262,918.00$1,000.000.38%FacilitiesEngineeringPersonnelExpenditures$909,096.00$909,096.00$809,096.00$100,000.0011.00%Fav.duetoturnover/vacantpositions.OperatingExpenditures232,467.00327,552.00300,052.0027,500.008.40%Fav.ProfessionalServices$25,000duetolessthananticipatedpreliminarycostsforfutureprojects.Fav.TravelandConference$7,500duetolimitingtravelasaresultofCOVID-19pandemic.Partiallyoffsetbyunfav.MembershipDues($5,000)duetothepurhcaseofacountylevelICLEI(InternationalCouncilforLocalEnvironmentalInitiatives)membershipincoordinationwiththeEnvironmentalandSustainabilityOfficer.InternalSupportExpenditures112,761.00115,285.00115,285.00-0.00% $1,254,324.00$1,351,933.00$1,224,433.00$127,500.009.43%DepartmentTotalPersonnelExpenditures$1,159,601.00$1,159,601.00$1,059,601.00$100,000.008.62%OperatingExpenditures235,154.00330,239.00301,739.0028,500.008.63%InternalSupportExpenditures123,487.00126,011.00126,011.00-0.00% $1,518,242.00$1,615,851.00$1,487,351.00$128,500.007.95%
COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESHUMANRESOURCESAMOUNTADOPTEDAMENDEDFY2022FAVORABLEBUDGETBUDGETFORECAST(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES AdministrationPersonnelExpenditures$927,344.00$927,344.00$842,344.00$85,000.009.17%Fav.duetovacanciesandturnover.OperatingExpenditures251,243.00671,243.00671,243.00-0.00%InternalSupportExpenditures26,102.0027,610.0027,610.00-0.00%TransfersOut----$1,204,689.00$1,626,197.00$1,541,197.00$85,000.005.23%WorkforceManagementPersonnelExpenditures$2,503,436.00$2,503,436.00$2,503,436.00$-0.00%OperatingExpenditures314,358.00393,995.50393,995.50-0.00%InternalSupportExpenditures1,107,621.001,126,418.001,026,418.00100,000.008.88%Fav.InfoTechOperationsduetolessthananticipateduse. $3,925,415.00$4,023,849.50$3,923,849.50$100,000.002.49%DepartmentTotalPersonnelExpenditures$3,430,780.00$3,430,780.00$3,345,780.00$85,000.002.48%OperatingExpenditures565,601.001,065,238.501,065,238.50-0.00%InternalSupportExpenditures1,133,723.001,154,028.001,054,028.00100,000.008.67%TransfersOut----5,130,104.00$5,650,046.50$5,465,046.50$185,000.003.27%bea
ADOPTEDBUDGETAMENDEDBUDGETCOUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESHEALTHANDHUMANSERVICESFY2022FORECASTAMOUNTFAVORABLE(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES AdministrationPersonnelExpenditures$250,005.00OperatingExpenditures4,236,668.00InternalSupportExpenditures 10,372.00TransfersOut-$250,005.004,236,668.0033,589.00$250,005.004,236,668.0033,589.00$ $ 4,497,045.00HealthPersonnelExpenditures$31,593,640.00OperatingExpenditures4,043,164.00InternalSupportExpenditures3,391,377.00TransfersOut-$ 4,520,262.00$31,677,608.006,999,772.003,528,703.00$ 4,520,262.00$31,277,608.006,997,472.003,528,703.00$400,000.002,300.00 $39,028,181.00$42,206,083.00$41,803,783.00$402,300.000.00%0.00%0.00%0.00%1.26%0.03%0.00%0.95%Fav.SalaryandFringeBenefitsduetoCOVID-relatedgrantsandvacancies.Fav.Printing$10,000duetolowerthananticipateduse.PartiatllyoffsetbyUnfav.Adj.PriorYearsExpenditurs($700),Adj.PriorYearsRevenue($1,200),PeriodicalsBooksPublSubscription($2,000),andWorkshopandMeeting($3,800).75
ADOPTEDBUDGETAMENDEDBUDGETCOUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESHEALTHANDHUMANSERVICESFY2022FORECASTAMOUNTFAVORABLE(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES MSUExtension-OaklandCountyPersonnelExpenditures$OperatingExpendituresInternalSupportExpendituresTransfersOut429,915.00$301,435.00309,217.00429,915.00§$301,435.00311,067.00429,915.00301,435.00311,067.00$-0.00%-0.00%-0.00% Neighborhood&HousingDev.PersonnelExpenditures$OperatingExpendituresInternalSupportExpendituresTransfersOut1,040,567.00$625,822.001,042,417.00$609,538.00$1,042,417.00609,538.00$-0.00%#DIV/0!1
A #DIV/0!-#DIV/0!-0.00% $625,822.00$609,538.00$609,538.00$-0.00%76
ADOPTEDBUDGETAMENDEDBUDGETCOUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESHEALTHANDHUMANSERVICESFY2022FORECASTAMOUNTFAVORABLE(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES DepartmentTotalPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOut32,273,560.008,581,267.003,697,978.00625,822.0032,357,528.0011,537,875.003,860,371.00609,538.00HAA SH31,957,528.0011,535,575.003,860,371.00609,538.00400,000.002,300.00 HAA SH a45,178,627.00HAA SH An48,365,312.0047,963,012.00RAAA GS A402,300.00 1.24%0.02%0.00%0.00%0.83%77
COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESPUBLICSERVICESAMOUNTADOPTEDAMENDEDFY2022FAVORABLEBUDGETBUDGETFORECAST(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES PublicServices-Admin.PersonnelExpenditures$153,144.00$153,144.00238,144.00$(85,000.00) -55.50%OperatingExpenditures4,800.004,800.004,800.00-0.00%InternalSupportExpenditures6,911.006,911.006,911.00-0.00% $164,855.00$164,855.00$249,855.00$(85,000.00) -51.56%CommunityCorrectionsPersonnelExpenditures$4,345,842.00$4,345,842.004,145,842.00$200,000.004.60%OperatingExpenditures472,025.00520,160.10 520,160.10-0.00%InternalSupportExpenditures524,765.00565,412.00715,412.00(150,000.00) -26.53%TransfersOut-- - -0.00%$5,342,632.00$5,431,414.10$5,381,414.10$50,000.000.92% MedicalExaminerPersonnelExpenditures$3,655,229.00$3,655,229.00$3,515,229.00$140,000.003.83%OperatingExpenditures690,219.00690,219.00690,219.00-0.00%InternalSupportExpenditures852,004.00858,709.00858,709.00-0.00%TransfersOut“ - -- $5,197,452.00$5,204,157.00$5,064,157.00$140,000.002.69%AnimalControlPersonnelExpenditures$2,824,400.00$2,824,400.00$2,824,400.00$-0.00%OperatingExpenditures402,786.00403,950.00 403,950.00-0.00%InternalSupportExpenditures1,492,157.001,502,283.001,502,283.00-0.00%TransfersOut= - = a $4,719,343.00$4,730,633.00$4,730,633.00$-0.00%Unfav.duetopositionbeingunderfilledattimeofbudgetdevelopment.Fav.duetovacanciesandturnover.Unfav.PrimarilyduetoInfoTechOpertationsasaresultofincreaseduse.Fav.duetovacanciesandturnover.78
COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESPUBLICSERVICESAMOUNTADOPTEDFAVORABLEBUDGETAMENDEDBUDGETFY2022FORECAST(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES CircuitCourtProbationPersonnelExpendituresOperatingExpenditures54,326.0054,326.0024,326.0030,000.00InternalSupportExpenditures629,350.00629,433.00629,433.00- $683,676.00$683,759.00$653,759.00$30,000.00Children'sVillagePersonnelExpenditures$18,829,786.00$18,829,786.00$17,029,786.00$1,800,000.00OperatingExpenditures3,945,872.004,001,852.664,001,852.66-InternalSupportExpenditures3,010,823.003,044,499.003,044,499.00-TransfersOut- - - - $25,786,481.00$25,876,137.66$24,076,137.661,800,000.00DepartmentTotalPersonnelExpenditures$29,808,401.00$29,808,401.00$27,753,401.00OperatingExpenditures$5,570,028.00$5,675,307.76$5,645,307.76InternalSupportExpenditures$6,516,010.00$6,607,247.00$6,757,247.00TransfersOut$.$=$si2,055,000.0030,000.00(150,000.00) wn ARAA SH ed
$41,894,439.00$42,090,955.76$40,155,955.761,935,000.00 0.00%55.22%0.00%4.39%9.56%0.00%0.00%6.96%6.89%0.53%-2.27%4.60%Fav.OfficeSupplies$20,000,MeteredPostage$5,000andPrinting$5,000duetolessthananticipateduse.Fav.duetovacantandunderfilledpositionsaswellasstaffbeingredeployedtoHealthDepartmenttoassistwithCOVIDcontacttracing.AfirstquarterbudgetamendmentisrecommendedcorrectingtheInfoTechOperationsexpenditureline-itemasthebudgetof$12,988wasinadvertenlybudgetedtoaninactiveunit1060501.PerM.R.#20202HumanResources—TransferofDivisionsbetweenCountyExecutiveDepartmentsChildren'sVillagetransferredfromtheDepartmentofHealthandHumanServicestothePublicServicesDepartment.79
ADOPTEDBUDGETAMENDEDBUDGETCOUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESECONOMICDEVELOPMENTFY2022FORECASTAMOUNTFAVORABLE(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES AdministrationPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOut$1,368,284.00442,222.00157,936.00$1,368,284.00117,581.00166,217.00$1,368,284.00117,581.00166,217.00$=0.00%-0.00%-0.00% $1,968,442.00$LocalBusinessDevelopmentDivision(FKAPEDS)PersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOutBusinessDevelopmentPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOutWorkforceDevelopmentPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOut$1,975,560.001,208,670.00867,945.00$1,652,082.001,975,560.002,467,975.00893,892.00$1,652,082.00$1,975,560.002,467,975.00893,892.00$-0.00%$-0.00%-0.00%-0.00% 4,052,175.002,293,411.0039,694.005,337,427.002,293,411.0039,694.001,300,000.00$5,337,427.00$2,293,411.0039,694.001,300,000.00$-0.00%-0.00% 2,333,105.001,412.00$3,633,105.001,412.00$3,633,105.00$1,412.00$-0.00%$-0.00%$-#DIV/0!-#DIV/0! 1,412.00$1,412.00$1,412.00$-0.00%AfirstquarterbudgetamendmentisrecommendedcorrectingControllablePersonnelbudgetforsalariesandfringebenefitduetothetimingofthebudgetdevelopmentandreorganizationofthedepartment(M.R.#21195).80
COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESECONOMICDEVELOPMENTAMOUNTADOPTEDAMENDEDFY2022FAVORABLEBUDGETBUDGETFORECAST(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCESVeteran'sServicesPersonnelExpenditures$1,670,669.00$1,670,669.00$1,670,669.00$-0.00%OperatingExpenditures189,624.00195,650.52195,650.52-0.00%InternalSupportExpenditures216,249.00219,002.00219,002.00-0.00%TransfersOut----#DIV/O! $2,076,542.00$2,085,321.52$2,085,321.52$-DepartmentTotalPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfers-0.00%-0.00%0.00%-0.00%7,309,336.00$7,309,336.00$7,309,336.001,840,516.002,781,206.522,781,206.521,281,824.001,318,805.001,318,805.00-1,300,000.001,300,000.00 1
HAAS cd
HAA HA A10,431,676.00$12,709,347.52$12,709,347.52-0.00%
ADOPTEDBUDGETAMENDEDBUDGETCOUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESEMERGENCYMANAGEMENTANDHOMELANDSECURITYFY2022FORECASTAMOUNTFAVORABLE(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES EmergencyManagementPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOutBuildingSafety*DepartmentTotalPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOut$1,023,712.00309,337.00571,177.00$1,023,712.007,398,837.00586,218.00$1,023,712.007,398,837.00586,218.00$-0.00%-0.00%-0.00% 1,904,226.001,023,712.00309,337.00571,177.00AAA SH9,008,767.001,023,712.007,398,837.00586,218.009,008,767.001,023,712.007,398,837.00586,218.00-0.00%-0.00%-0.00%-0.00%-#DIV/0! RASA SH a1,904,226.00FR9,008,767.00AAA SH FR9,008,767.00RAGA SH A-0.00% *BuildingSafetyispartoftheFacilitiesManagement&Operationsfund#(63100)82
COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTEXPENDITURESDEPARTMENTOFPUBLICCOMMUNICATIONSAMOUNTADOPTEDAMENDEDFY2022FAVORABLEBUDGETBUDGETFORECAST(UNFAVORABLE)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES PublicCommunicationsPersonnelExpenditures$1,862,251.00$1,862,251.00$1,862,251.00$-0.00%OperatingExpenditures984,500.00984,500.00984,500.00-0.00%InternalSupportExpenditures15,500.0023,532.0023,532.00-0.00%TransfersOut2=2 - $2,862,251.00$2,870,283.00$2,870,283.00§$-0.00%DepartmentTotalPersonnelExpendituresOperatingExpendituresInternalSupportExpendituresTransfersOut-0.00%-0.00%0.00%-#DIV/O!1,862,251.001,862,251.00984,500.00984,500.00$1,862,251.00$15,500.00$23,532.00$$984,500.0023,532.00 1
RAAH An
ARAA SH A2,870,283.00-0.00%RAAA SH eo2,862,251.002,870,283.00 83
NON-DEPARTMENTAPPROPRIATIONSCOUNTYOPERATIONSSeparationIncentiveSalaryTurnoverFactorSocialSecurityFringeBenefitTurnoverFactorAdjustPriorYearsExpBankChargesContractedServicesInsuranceFundInsuranceSuretyBondsLaboratoryFeesLogosTrademarksIntellectPropertyOfficeSuppliesRoadCommission\CurrentDrainAssessmentRoadCommission\TriPartyAgreementProvisionsSecuritySuppliesTransfertoCommunityMentalHealthAuthorityTotalCOUNTYBUILDINGSSTATEANDFEDERAL-COUNTYASSOCIATIONSMichiganAssoc.ofCountiesNationalAssoc.ofCountiesS.E.M.C.O.G.TrafficImprovementAssociationTotalSUNDRYEXPENSERESERVEDFORTRANSFERSExpendituresClassificationandRateChangeContingencyEmergencySalariesReserveFringeBenefitReserveGeneralFundContingencyGrantMatchInfoTechDevelopmentJuvenileResentencingLegislativeExpenseLocalRoadFundingProgramMisc.CapitalOutlay$ADOPTEDBUDGET1,731,085.00(3,000,000.00)(2,000,000.00)435,308.0033,305.0020,000.001,450,000.002,000,100.0030,000.009,620,616.0010,320,414.002,271,828.0073,000.0024,100.00550,000.0030,000.00677,100.00300,000.0045,166.001,156,966.00252,976.00(2,250,000.00)(6,000,000.00)349,148.009,212,320.008,600.002,000,001.00315,034.00$$$AMENDEDBUDGET1,731,085.00(3,000,000.00)(2,000,000.00)33,467.63435,308.0033,305.0015,000.0020,000.00484.001,558,401.003,343,458.0039,143.003,573.409,620,616.0011,833,841.032,100,327.0073,000.0024,100.00550,000.0030,000.00677,100.00300,000.0018,254.00325,391.00252,976.00(2,250,000.00)(6,000,000.00)747,553.008,028,755.00(209,690.00)8,600.002,000,001.00860,599.00COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTNON-DEPARTMENTALEXPENDITURESFY2022FORECAST1,731,085.00(2,400,000.00)(1,600,000.00)33,467.63435,308.0033,305.0015,000.0020,000.00484.001,558,401.003,343,458.0039,143.003,573.409,620,616.0012,833,841.032,100,327.0073,000.0024,100.00550,000.0030,000.00677,100.00300,000.0018,254.00325,391.00252,976.00(2,250,000.00)(4,800,000.00)747,553.008,028,755.00(209,690.00)8,600.002,000,001.00860,599.00$AMOUNTFAVORABLE(UNFAVORABLE)(600,000.00)(400,000.00)(1,000,000.00)(1,200,000.00)PERCENT0.00%20.00%0.00%20.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%40.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%20.00%0.00%0.00%0.00%0.00%0.00%0.00%EXPLANATIONUnfavorabletopartiallyreflectthefavorabilityforecastedintheindividualdepartments.Unfavorabletopartiallyreflectthefavorabilityforecastedintheindividualdepartments.Unfavorabletopartiallyreflectthefavorabilityforecastedintheindividualdepartments.84
OvertimeReserveSpecialProjectsSubstanceAbuseCoordAgencyTechnologyProjects-OneTimeTotalTransferstoOtherFundsFireRecordsManagementCLEMISInformationTechnologyBldgAuthFacInfrasITDebtBuildingFundProsCoopReimbursementMulti-FunctionDeviceReplacementProjectTOTALNON-DEPT.APPROPRIATIONSTRANSFERTOGENERALPURPOSEFUNDSChildCareFundSocialWelfareFundFosterCareTOTALEXPENDITURESADOPTEDBUDGET300,000.001,000,000.004,766,565.003,500,000.0014,656,776.00507,699.001,644,186.007,805,164.002,222,125.003,000,000.001,100,000.001,490,926.0017,770,100.00COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTNON-DEPARTMENTALEXPENDITURESAMENDEDBUDGET300,000.001,000,000.004,766,565.003,500,000.0013,349,004.00507,699.001,644,186.007,965,401.002,222,125.003,000,000.001,100,000.001,490,926.0017,930,337.00FY2022FORECAST300,000.001,000,000.004,766,565.003,500,000.00$14,549,004.00507,699.001,644,186.007,965,401.002,222,125.003,000,000.001,100,000.001,490,926.00$17,930,337.00AMOUNTFAVORABLE(UNFAVORABLE)$(1,200,000.00)PERCENT0.00%0.00%0.00%0.00%-8.99%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% 45,996,218.0018,949,745.001,000.0018,950,745.0046,190,609.0318,979,581.001,000.0018,980,581.00$48,390,609.03$15,679,581.001,000.00$15,680,581.00$(2,200,000.00)$3,300,000.00$3,300,000.004.76%17.39%0.00%17.39% 64,946,963.0065,171,190.03$64,071,190.03$1,100,000.001.69%EXPLANATIONFav.duetolessthananticipatedamountneededfortheChildCareFundbasedonloweroverallChildCareexpendituresforFY2022.85
FY 2022 BUDGET AMENDMENTS
FY 2022 BUDGET AS ADOPTED -GENERAL FUND/GENERAL PURPOSE FUNDS $491,723,016.00
BUDGET AMENDMENTS
M.R.#21410 10/13/2021 $7,089,500.00
Homeland Security -Appropriation for FEMA Reimbursable Pandemic Response Activities
M.R.#21403 10/13/2021 $302,704.00
Sheriff's Office -Temporary Increase in Rate of Overtime Pay to Reduce Employee Mandatory Overtime Hours
M.R.#21424 10/28/2021
Health -Fiscal Year 2022-Fiscal Year 2025 Collective Bargaining Agreement with the Michigan Nurses Association (MNA)$77,171.00
for Public Health Nurses
M.R.#21426 10/28/2021
Board of Commissioners -Agreement with the City of Southfield for Police Officers Drivers Training $10,908.00
M.R.#21427 10/28/2021
Board of Commissioners -Agreement with the Charter Township of Shelby for Police Officers Drivers Training $10,908.00
M.R.#21428 10/28/2021 $2,627.00
Sheriff's Office -2021 Law Enforcement Services Agreement with the Somerset Collection LP
M.R.#21430 10/28/2021 $(22,828.00)
Prosecuting Attorney -FY 2022 Crime Victim Rights Grant Acceptance
M.R.#21436 10/28/2021 $83,968.00
Health -FY 2022 Creation of Health Program Coordinator Position
M.R.#21451 11/10/2021 $158,424.00
Oakland County Circuit Court/Family Court -Fiscal Years 2022, 2023,2024 and 2025 Collective Bargaining Agreement
for Employees Represented by the Michigan American Federation of State,County and Municipal Employees (AFSCME),
Council 25,Local 2437,Representing Circuit Court/Family Court Employees
M.R.#21452 11/10/2021 $13,995.00
Oakland County Probate Court -Fiscal Year 2022-2024 Supplemental Collective Bargaining Agreement for Supervisory
and Non-Supervisory Employees Represented by the United Auto Workers,Local 889 (UAW),of the Probate Court
M.R.#21459 11/10/2021 $19,372.00
FY 2022 Joint Terrorism Task Force (JTTF)
M.R.#21460 11/10/2021 $19,372.00
FY2022 Gang and Violent Crime Safe Streets Task Force (SSTF)
M.R.#21475 12/9/2021 $250,000.00
Board of Commissioners -Oakland County Invasive Moth (Lymantria dispart)Program
M.R.#21489 12/9/2021 $55,823.00
Sheriff's Office -FY 2022 Traffic Safety Enforcement
M.R.#21528 12/9/2021 $264,866.00
Board of Commissioners -Extension of Temporary Increase in Rate of Overtime Pay to reduce Employee Mandatory
Overtime Hours
M.R.#21529 12/9/2021 $ 2,056,796.00
Board of Commissioners -Funding Transfer Appropriation for Body-Worn Camera Policy and Implementation Program
M.R.#21507 -12/09/2021
Management &Budget Fiscal Year 2021 Year-End Report and Budget Amendments
Encumbrances $776,770.13
Carry Forwards $11,475,017.00
Adjustments to Non-Departmental $2,511,949.00 $14,763,736.13
TOTAL AMENDED BUDGETASOF 12/31/2021 $516,880,358.13
86
GRANTSACCEPTED$10,000ANDUNDER(approvedadministratively,inaccordancewiththeGrantsPolicyapprovedbytheBoardattheirJanuary21,2021meeting.)[DepartmentorDivision|GrantTitle|Award/Amendment[Quarterincluded(QTRIFY)|VeteranServices2021MichiganVeteransAgencyCountyTrainingReimbursement$3,500.00Qi/FY22AnimalControlBisselPetFoundationEmptytheShelter$1,750.00Qi/FY2287
DELINQUENTTAXREVOLVINGFUND51600REVENUESChargesforServicesOtherRevenuesTotalRevenuesOPERATINGEXPENSESPersonnelExpendituresOperatingExpendituresInterestExpenseTransferOuttoOtherFunds:GeneralFund-CollectionFeesGF-Non-DepartmentalWorkReleaseFacilityRefundingDebtSvcOfficeBldgRenovationRefundingDebtSvc52-3DistrictCourtRefundingDebtSvcTotalTransferOuttoOtherFundsTotalOperatingExpensesREVENUEOVER(UNDER)EXPENDITURES*TotalNetPosition-BeginningTotalNetPosition-EndingEndingFY2021DesignatedNetPosition**:NP-UnRes-Designated-DebtServiceADOPTEDBUDGET$10,500,000.002,000,000.00AMENDEDBUDGET$10,500,000.002,000,000.00COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTENTERPRISEFUNDTREASURER'SOFFICEFY2022FORECAST$10,500,000.002,000,000.00VARIANCEFAV/(UNFAV)PERCENT$-0.00%-0.00% $12,500,000.00$245,060.00418,389.001,000,000.002,300,000.003,000,000.001,508,000.001,860,850.001,291,500.009,960,350.00$ 11,623,799.00$876,201.00NP-UnRes-Designated-DelingTaxesReceivableNP-UnRes-Designated-CollectionFeesUndesignated-NetPositionTotalNetPosition-Ending$12,500,000.00245,060.00418,389.001,000,000.002,300,000.003,000,000.001,508,000.001,860,850.001,291,500.009,960,350.0011,623,799.00$876,201.00$12,500,000.00$245,060.00418,389.001,000,000.002,300,000.003,000,000.001,508,000.001,860,850.001,291,500.00$__9,960,350.00$11,623,799.00$876,201.00$208,089,434.68$208,965,635.68$53,276,854.00148,733,472.226,079,108.46$876,201.00$208,965,635.68$-0.00%$-0.00%-0.00%-0.00%-0.00%-0.00%-0.00%-0.00%-0.00%$:0.00%$-0.00%*PleasenotethatintheAdoptedBudget(line-itembook)thisisbudgetedas'PlannedUseofBalance"intherevenuecategory.**Pleasenotethedesignatedequityamountsareadjustedatyear-endonlyEXPLANATIONOFSIGNIFICANTVARIANCES
DELINQUENTPERSONAL PROPERTYTAX(51800) OPERATINGREVENUEOPERATINGEXPENSENETOPERATINGINCOME(LOSS)NON-OPERATINGREVENUE(EXPENSE)TOTALINCOMEBEFORECONTRIBUTIONSANDTRANSFERSTRANSFERSOUTTOTALNETINCOME(LOSS)*TOTALNETPOSITION-BEGINNINGTOTALNETPOSITION-ENDINGADOPTEDBUDGET$506,136.00553,199.00($47,063.00)5,000.00AMENDEDBUDGET$506,136.00553,199.00($47,063.00)5,000.00COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTENTERPRISEFUNDSFY2022FORECAST$576,136.00450,199.00$125,937.00$5,000.00TREASURERVARIANCEFAV/(UNFAV)$70,000.00$103,000.00$0.00$0.00 ($42,063.00)($42,063.00)($42,063.00)($42,063.00)$130,937.00$130,937.001,133,473.33$0.00$0.00$1,264,410.33*PleasenotethatintheAdoptedBudget(line-itembook)thisisbudgetedas‘PlannedUseofBalance"intherevenuecategory.PERCENT13.83%18.62%0.00%0.00%EXPLANATIONOFSIGNIFICANTVARIANCESFav.AdministrationFeesprimarilyduetoincreasedcollectionactivity.Fav.ControllablePersonnel$85,000duetovacantandunderfilledpositions.Alsofav.ProfessionalServices$15,000andMeteredPostage$3,000duetolessthananticipateduse.89
OAKLANDCOUNTYPARKS&RECREATIONCOMMISSION(50800) OPERATINGREVENUEOPERATINGEXPENSENETOPERATINGINCOME(LOSS)NON-OPERATINGREVENUE(EXPENSE)TOTALINCOMEBEFORETRANSFERSBUDGETEDEQUITYADJUSTMENTTRANSFERSINTOTALNETINCOME/PLANNEDUSEOFBALANCE(LOSS)*TOTALNETPOSITION-BEGINNINGTOTALNETPOSTION-ENDINGADOPTEDBUDGET$11,087,375.00$32,354,515.00FY2022FIRSTQUARTERREPORTAMENDEDBUDGET$11,087,375.00$32,354,515.00COUNTYOFOAKLANDENTERPRISEFUNDPARKS&RECREATIONFY2022FORECAST11,087,375.0032,354,515.00VARIANCEFAV/(UNFAV) $(21,267,140.00)A21,267,140.00$(21,267,140.00)$21,267,140.00(21,267,140.00)21,267,140.00 1,843,160.001,843,160.002,285,523.002,285,523.00AA A ||2,285,523.002,285,523.0091,888,245.4694,173,768.46PERCENT0.00%0.00%0.00%0.00%0.00%EXPLANATIONOFSIGNIFICANTVARIANCESBudgetamendmentsincludethetransfertoMunicipalitiesforNormandyOaksintheamountof$213,080whichwasactuallymadeinFY2021.*PleasenotethatintheAdoptedBudget(line-itembook)thisisbudgetedas“PlanneduseofFundBalance"intherevenuecategoryandBudgetedEquityAdjinExpenses.90
ADOPTEDBUDGETCOUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTINTERNALSERVICEFUNDWATERRESOURCESCOMMISSIONERAMENDEDFY2022FORECASTVARIANCEBUDGETFAVI(UNFAV)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES DRAINEQUIPMENTFUND(63900) OPERATINGREVENUES:InsideOutsideTotalRevenueOPERATINGEXPENSESNETINCOME(LOSS)BEFORENON-OPERATINGREVENUE/(EXPENSE)$49,522,721.00310,100.00$49,520,048.00$47,070,048.00$(2,450,000.00)-4.95%310,100.00310,100.00-0.00% 49,832,821.00$52,656,471.00($2,823,650.00)$312,600.0049,830,148.0047,380,148.00(2,450,000.00)-4.92%$52,653,798.00$50,154,098.00$2,499,700.004.75%($2,823,650.00)($2,773,950.00)$49,700.00-1.76%$312,600.00$298,652.00($13,948.00)-4.46%Unfav.ReimbursementSalaries($2,500,000)duetounallocatedpayrollchargesforturnover,vacantpositionsandemployeestakingVoluntaryEmployeeSeparationIncentiveProgram(VESIP),offsetinSalariesandFringes.Fav-RebilledCharges$50,000revenueisdeterminedbyaincreaseinrebillablerepairjobs,offsetbyunfavorableexpensespertainingtotherepairjobs.Fav.primarilyfromSalariesandFringes$2,500,000duetoturnover,vacantpositionsandemployeestakingVoluntaryEmployeeSeparationIncentiveProgram(VESIP).Unfav.primarilyfromIncomefromInvestment($15,000)duetoinvestmentbaseandmarketratefluctuations.91
ADOPTEDBUDGETCOUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTINTERNALSERVICEFUNDWATERRESOURCESCOMMISSIONERAMENDEDFY2022VARIANCEBUDGETFORECASTFAV/(UNFAV)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES TRANSFERIN275,000.00TRANSFERS(OUT).275,000.00$275,000.00-0.00%75,299.0075,299.00-0.00% NETREVENUESOVER(UNDER)($2,236,050.00)EXPENSES*($2,311,349.00)($2,275,597.00)$35,752.00 TOTALNETPOSITION-BEGINNINGTOTALNETPOSITION-ENDING$__33,101,306.80$30,825,709.80*PleasenotethatintheAdoptedBudget(line-itembook)thisisbudgetedas"PlanneduseofFundBalance"intherevenuecategoryandBudgetedEquityAdjinExpenses.92
COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTINTERNALSERVICEFUNDRISKMANAGEMENTADOPTEDAMENDEDFY2022VARIANCEBUDGETBUDGETFORECASTFAVI(UNFAV)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES [LIABILITYINSURANCEFUND67700 OPERATINGREVENUES:OutsideRevenue$ 13,030.00§$13,030.00$13,030.000.000.00%InsideRevenue8,656,856.008,656,856.008,656,856.000.000.00% TotalOperatingRevenue$8,669,886.00$8,669,886.00$ 8,669,886.000.000.00%OPERATINGEXPENSE$5,090,226.00$5,090,226.00$5,090,226.000.000.00%CLAIMSPAID3,653,436.003,653,436.003,653,436.000.000.00% TOTALOPERATINGEXPENSES$8,743,662.00$8,743,662.00§$8,743,662.000.000.00%OPERATINGINCOME(LOSS)(73,776.00)(73,776.00)(73,776.00)0.000.00%NON-OPERATINGREVENUE(EXPENSE)150,000.00150,000.00100,000.00(50,000.00)-33.33%-Unfav.IncomefromInvestments($50,000)duetolowerthanexpectedavailablecashbalance.TRANSFERIN/OUT----#DIV/O!NETREVENUESOVER/(UNDER)*EXPENSES$76,224.00$76,224.0026,224.00$(50,000.00)TOTALNETASSETS-BEGINNING104,960.18TOTALNET ASSETS-ENDING$131,184.18*PleasenotethatintheAdoptedBudget(line-itembook)thisisbudgetedas“PlannedUseofFundBalance"intherevenuecategory.
[FRINGEBENEFITSFUND67800 OPERATINGREVENUERETIREESMEDICAL-VEBADEBTRETIREMENTADMINISTRATIONRETIREMENTADMINISTRATION-PTNEDEFERREDCOMPENSATION-MATCHDEFINEDCONTRIBUTIONPLANDEFINEDCONTRIBUTIONPLAN-PTNEEMPLOYEEIN-SERVICETRAININGEMPLOYEEBENEFITSUNITEMPLOYEERECOGNITIONFLEXBENEFITPLANWELLNESSUNITFRINGEBENEFITSTUITIONREIMBURSEMENTRETIREMENTHEALTHSAVINGSGROUPLIFEINSURANCESOCIALSECURITYMEDICALINSURANCEPRESCRIPTIONCOVERAGEINSURANCEDENTALINSURANCEVISIONINSURANCEDISABILITYINSURANCEWORKERSCOMPENSATIONUNEMPLOYMENTCOMPENSATIONINVESTMENTINCOMEEXT-DENTALINSURANCEEXT-FLEXBENARREARAGESEXT-FLEXBENDENTALINSURANCEEXT-FLEXBENLIFEINSURANCEEXT-FLEXBENMEDICAL-EMPLOYEEEXT-FLEXBENVISIONINSURANCEEXT-MEDICALINSURANCEEXT-PRESCRIPTIONDRUGREBATESEXT-TRAININGEXT-VISIONINSURANCEEXT-WELLNESSREVENUEADOPTEDBUDGETAMENDEDBUDGETCOUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTINTERNALSERVICEFUNDSFRINGEBENEFITSFUNDFY2022FORECASTVARIANCEFAV(UNFAV)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES 33,998,1693,728,825350,0002,852,00023,000,000200,0001,498,4651,094,463212,11789,000487,003125,412350,0003,800,000580,00021,168,50034,946,00012,000,0003,005,00098,5003,950,0003,316,562300,0001,500,00020,000175,000520,0005,333,000150,000180,0002,000,00010,0001,50010,00033,998,1693,728,825350,0002,852,00023,000,000200,0001,498,4651,094,463212,11789,000487,003125,412350,0003,800,000580,00021,168,50034,946,00012,000,0003,005,00098,5003,950,0003,316,562300,0001,500,00020,000175,000520,0005,333,000150,000180,0002,000,00010,0001,50010,00033,998,169.003,210,025.00152,000.002,852,000.0023,000,000.00200,000.001,498,465.001,094,463.00212,117.0089,000.00403,003.00125,412.00290,000.003,910,000.00390,000.0018,500,000.0020,548,000.008,000,000.003,550,000.00280,000.003,072,700.002,260,562.00232,000.00750,000.0020,000.00175,000.00520,000.005,333,000.00150,000.00180,000.002,000,000.0010,000.001,500.0010,000.00(518,800.00)(198,000.00)(84,000.00)(60,000.00)410,000.00(190,000.00)(2,668,500.00)(14,398,000.00)(4,000,000.00)545,000.00181,500.00(877,300.00)(1,056,000.00)(68,000.00)(750,000.00) TOTALREVENUEOPERATINGEXPENSERETIREESMEDICAL-VEBADEBTINT/AGINGRETIREMENTADMINISTRATION161,049,5166,413,1691,050,357161,049,5166,413,1691,050,357137,017,416.006,413,169.00926,676.00(24,032,100.00)123,681.000.00%-13.91%-56.57%0.00%0.00%0.00%0.00%0.00%0.00%0.00%-17.25%0.00%-17.14%2.89%-32.76%-12.61%-41.20%-33.33%18.14%184.26%-22.21%-31.84%-22.67%-50.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%-14.92%0.00%11.78%-Unfav.duetoprojectedrevenuelessthanbudgetprojections.-Unfav.duetoprojectedrevenuelessthanbudgetprojections.-Unfav.duetoprojectedrevenuelessthanbudgetprojections.-Unfav.duetoprojectedrevenuelessthanbudgetprojections.-Fav.duetoprojectedrevenuemorethanbudgetprojections.-Unfav.duetoanincreaseinparticipantsthroughTheHartfordInsuranceprogram.-Unfav.duetoprojectedrevenuemorethanbudgetprojections.-Unfav.duetoprojectedrevenuelessthanbudgetprojectionsaswellasareductiontoratestoreducefundbalance.-Unfav.duetoprojectedrevenuelessthanbudgetprojections.-Fav.duetoprojectedrevenuemorethanbudgetprojections.-Fav.duetoprojectedrevenuemorethanbudgetprojections.-Unfav.duetoprojectedrevenuelessthanbudgetprojections.-Unfav.duetoprojectedrevenuelessthanbudgetprojections,partiallyoffsetbyWorkersCompensationExpense.-Unfav.duetoprojectedrevenuelessthanbudgetprojections,partiallyoffsetbyUnemploymentCompensationExpense.-Unfav.duetoprojectedrevenuelessthanbudgetprojections.-Fav.duetovacantpositionwithinRetirementUnit94
ADOPTEDBUDGET [FRINGEBENEFITSFUND67800| AMENDEDBUDGETCOUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTINTERNALSERVICEFUNDSFRINGEBENEFITSFUNDFY2022FORECASTVARIANCEFAVI(UNFAV)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES DEFERREDCOMP-COUNTYPMTS(MATCH)DEFINEDCONTRIBUTIONPLAN2,985,50023,000,000DEFINEDCONTRIBUTIONPLAN-PTNEEMPLOYEEIN-SERVICETRAININGIN-SERVICETRAINING-INFOTECHPROFESSIONALSERVICESBENEFITSADMINISTRATIONEMPLOYEEBENEFITSUNITFLEXIBLEBENEFITPAYMENTSWELLNESSPROGRAMEMPLOYEERECOGNITIONACCOUNTINGSERVICESTUITIONREIMBURSEMENTRETIREMENTHEALTHSAVINGSGROUPLIFEINSURANCESICKANDANNUALLEAVECASH-OUTSOCIALSECURITYMEDICALINSURANCE200,0001,166,465275,00057,00056,9361,065,99589,000491,453212,117125,412350,0003,800,0001,100,0003,000,00021,168,50047,625,000PRESCRIPTIONCOVERAGE14,000,000DENTALINSURANCEVISIONINSURANCEDISABILITYINSURANCEWORKERSCOMPENSATION3,200,000250,0003,950,0003,325,236UNEMPLOYMENTCOMPENSATION300,000CHILDCAREFACILITYHEALTHINSURANCEPREMIUMTAXMICHIGANIPAATAXPATIENTCENTEREDOUTCOMERESEARCHINDIRECTCOSTS415,58225,0009,00026,000273,8003,433,50023,000,000200,0001,173,003275,00057,00056,9361,072,72389,000512,278212,117125,412350,0003,800,0001,100,0003,000,00021,168,50047,625,00014,000,0003,200,000250,0003,950,0003,325,236300,000415,58225,0009,00026,000273,8003,433,500.0026,500,000.00200,000.00913,281.00275,000.0057,000.0056,936.001,072,723.0089,000.00512,278.00105,617.00125,412.00350,000.003,800,000.001,100,000.003,000,000.0021,168,500.0050,125,000.0015,160,000.003,200,000.00250,000.003,950,000.003,124,336.00250,000.00415,582.0025,000.009,000.0026,000.00199,700.00(3,500,000.00)259,722.00106,500.00(2,500,000.00)(1,160,000.00)200,900.0050,000.0074,100.00 TOTALEXPENSE140,006,522NETREVENUEOVER/(UNDER)EXPENSES21,042,994.00TOTALNETASSETS-BEGINNINGTOTALNETASSETS-ENDING140,488,61320,560,903.00146,833,710.00(9,816,294.00)(30,377,197.00)386,553,154.51376,736,860.51(6,345,097.00)*PleasenotethatintheAdoptedBudget(line-itembook)thisisbudgetedas“BudgetedEquityAdjustment"intheexpensecategory.Note:TheFringeBenefitFundisresponsiblefortheRetireeHealthcareDebt.Theprincipalandinterestpaymentsareincludedinthefringebenefitratebuttheprincipalportionisrequiredtobeaccountedforthroughaliabilityaccountversusanexnenseaccaunt.TheFY2022orincinalamountis$975850000.00%-15.22%-0.00%22.14%-0.00%0.00%0.00%0.00%0.00%0.00%50.21%-0.00%0.00%0.00%0.00%0.00%0.00%-5.25%-8.29%-0.00%0.00%0.00%6.04%-16.67%-0.00%0.00%0.00%0.00%27.06%-4.52%Unfav.duetoprojectedcostsmorethanbudgetprojection-increaseinnewhireswhoparticipateintheDefinedContributionPlan.Fav.duetolowerthanprojectedtrainingcosts.Fav.duetovacantpositionwithinEmployeeRecognitionUnit.-Unfav.duetoprojectedMedicalInsuranceexpenseshigherthanbudgetprojections.Unfav.duetoprojectedexpensesmorethanbudgetprojections.Fav.duetovacantpositionwithinRiskManagement,offsetbyWorkersCompensationRevenue.Fav.duetocreditsprovidedbytheMichiganUnemploymentInsuranceAgency(UIA)duetoCOVID-19,offsetbyUnemploymentCompensationrevenue.-Fav.duetoprojectedchargesdevelopedafterbudgetfinalization.95
ADOPTEDBUDGETAMENDEDBUDGETCOUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTENTERPRISEFUNDSCENTRALSERVICESVARIANCEFAV/(UNFAV)FY2022FORECASTPERCENTEXPLANATIONOFSIGNIFICANTVARIANCES OAKLANDCOUNTYINTERNATIONALAIRPORT(56500) OPERATINGREVENUE$5,036,900.00OPERATINGEXPENSE7,471,688.00$5,036,900.007,475,688.00$5,167,660.00$130,700.007,375,688.00100,000.00 NETOPERATINGINCOME(LOSS)(2,434,788.00)NON-OPERATINGREVENUE(EXPENSE;296,300.00TOTALINCOMEBEFORECONTRIBUTIONSANDTRANSFERS(2,138,488.00)TRANSFERSINTRANSFERSOUT-CAPITALCONTRIBUTION-($2,438,788.00)296,300.00($2,142,488.00)($2,208,028.00)$230,700.00296,300.00-$(1,911,728.00)230,700.00 TOTALNETINCOME(LOSS)($2,138,488.00)TOTALNETASSETS-BEGINNINGTOTALNETASSETS-ENDING($2,142,488,00)$(1,911,728.00)$230,700.00$_79,045,166.97$_77,133,438.972.59%1.34%-9.46%-10.77%-Fav.CarRentalConcession$89,000andLandingFees$41,700duetorateincreases.-Fav.InterestExpense$100,000duetobondsaleandre-issueatalowerinterestrateinSeptember2020.*PleasenotethatintheAdoptedBudget(line-itembook)thisisbudgetedas“PlanneduseofFundBalance"intherevenuecategoryandBudgetedEquityAdjinExpenses.96
ADOPTEDBUDGETAMENDEDBUDGETCOUNTYOFOAKLANDFY2022FirstQuarterReportINTERNALSERVICEFUNDSCENTRALSERVICESFY2022FORECASTVARIANCEFAV/I(UNFAV)PERCENTEXPLANATIONOFSIGNIFICANTVARIANCES [MOTORPOOLFUND66100|OPERATINGREVENUE:OutsideRevenueInsideRevenue$130,000.008,649,930.00$130,000.008,630,660.00130,000.000.00%-0.91%-Unfav.LeasedEquipment($399,100)duetoactualactivitytodate,partiallyoffsetbyfavorableGasoline,Oil&GreaseCharges$320,400duetocurrentfuelcosts(partiallyoffsetbyunfavorableGasolineexpense).8,551,960.00(78,700.00) TotalRevenueOPERATINGEXPENSE8,779,930.009,418,351.008,760,660.009,434,045.008,681,960.00(78,700.00)-1.19%-Unfav.GasolineCharges($78,400)duetomarketfluctuationsandmilesdriven(offsetbyfavorable Gasoline,OilGreaseChargesrevenue)andIndirectCosts($34,200)duetothedevelopmentofactualchargesafterbudgetfinalization.9,546,645.00(112,600.00) OPERATINGINCOME(LOSS)NON-OPERATINGREVENUE(EXPENSE)(638,421.00)492,700.00(673,385.00)492,700.00(864,685.00)(191,300.00)492,700.00-0.00% NETINCOME(LOSS)BEFOREOPERATINGTRANSFERSTRANSFERSIN/(OUT)CAPITALCONTRIBUTIONS(145,721.00)80,079.00(180,685.00)289,198.00(371,985.00)(191,300.00)289,198.00-0.00% NETREVENUEOVER/(UNDER)EXPENSES(PLANNEDUSEOFFUNDTOTALNETASSETS-BEGINNINGTOTALNETASSETS-ENDING$(65,642.00)$108,513.00$(82,787.00)$11,703,052.75$11,620,265.75$(191,300.00)*PleasenotethatintheAdoptedBudget(line-itembook)thisisbudgetedas"PlannedUseofFundBalance"intherevenuecategory.97
COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTINTERNALSERVICEFUNDFACILITIESMANAGEMENTFY2022FORECASTVARIANCEFAV/(UNFAV)PERCENTADOPTEDBUDGETAMENDEDBUDGET [FACILITIESMAINTENANCE&OPERATIONSOPERATINGREVENUES:OutsideRevenue(#63100)|473,298.00$473,298.00$488,298.00$15,000.0027332,234.0027,332,234.0027,132,234.00(200,000.00) -0.73%InsideRevenue 27,805,532.00-0.67%29,345,742.00$27,805,532.00$29,351,334.00$27,620,532.00$28,301,334.00$(185,000.00)$1,050,000.00TotalRevenueOPERATINGEXPENSES NETINCOME(LOSS)BEFOREOPERATINGTRANSFERS$(1,540,210.00)$(1,545,802.00)$(680,802.00)865,000.00NON-OPERATINGREVENUE100,000.00$100,000.00§$65,000.00$(35,000.00)-35.00%-0.00%-0.00%-$-(45,079.00)$(45,079.00)A
TRANSFERSINTRANSFERSOUTNETREVENUESOVER(UNDER)EXPENSES*ASA
AA$(45,079.00) 1,485,289.00)_$(1,490,881.00)$(660,881.00)$830,000.00TOTALNETPOSITION-BEGINNING$_8,674,481.47TOTALNETPOSITION-ENDING$8,013,600.47*PleasenotethatintheAdoptedBudget(line-itembook)thisisbudgetedas"PlannedUseofFundBalance"intherevenuecategory.EXPLANATIONOFSIGNIFICANTVARIANCES3.17%-Fav.Ext-OtherRevenueduetomorethananticipatedOutsideAgenciesMaintenanceChargesforOaklandCommunityHealthNetwork(OCHN)-ResourceCrisisCenter.Unfav.primarilyduetoMaintenanceDeptChargesbasedonDepartmentrequests.3.58%-Fav.SubletRepairs$400,000duetomoreefficientmanagementofgrounds,custodial,andmaintenanceoperations;Water&SewageCharges$325,000basedonactualusage;ElectricalService$175,000duetolower-costthird-partycontractsandsavingsfromFM&Oenergyconservationinitiatives;SalariesandFringeBenefits$150,000duetoturnoverandunderfilledpositions;MaterialandSupplies$50,000duetoadelayedleadtimeformaterialsimpactingdeliveryofgoods;FuelOil$50,000duetothelackofsupply/availabilityofspecializedfuelgrade.Partiallyoffsetbyunfav.MaintenanceSupplies($75,000)basedonincreaseduseofmaterialsforservicesperformedinternallytoreopenCountywideoperationsasaresultoftheCOVID-19pandemicandproductpriceincreases;GroundsSupplies($25,000)basedonincreaseduseofservicestosetuptestingsitesasaresultoftheCOVID-19pandemic.Unfav.IncomefromInvestmentsduetoinvestmentbaseandmarketrateadjustments.98
InformationTechnology-Operations(63600)OPERATINGREVENUES:OutsideInsideTOTALOPERATINGREVENUEOPERATINGEXPENSESNETINCOME(LOSS)BEFOREOPERATINGTRANSFERSNON-OPERATINGREVENUETRANSFERSINTRANSFERS(OUT)CAPITALCONTRIBUTIONNETREVOVER(UNDER)EXP*TOTALNETPOSITION-BEGINNINGTOTALNETPOSITION-ENDING$ADOPTEDBUDGET3,456,603.0032,737,499.00COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTINTERNALSERVICEFUNDS/ENTERPRISEFUNDAMENDEDBUDGET$ 3,456,603.0032,737,499.00$INFORMATIONTECHNOLOGYFY2022FORECAST3,202,203.00$34,536,099.00VARIANCEFAV/(UNFAV)(254,400.00)1,798,600.00 $36,194,102.0054,048,296$36,194,102.0054,208,533$37,738,302.00$57,558,733.00 $$$$$$(17,854,194.00)75,500.008,091,164.00(9,687,530.00)$(18,014,431.00)$75,500.00$8,251,401.00$%$ (9,687,530.00)RA $(19,820,431.00)$12,600.00$8,251,401.00$-$(11,556,430.00)$ 38,113,054.0326,556,624.03*PleasenotethatintheAdoptedBudget(line-itembook)thisisbudgetedas"PlannedUseofFundBalance"intherevenuecategory.1,544,200.00(3,350,200.00)(1,806,000.00)(62,900.00)1,868,900.00PERCENT-7.36%5.49%4.27%-6.18%10.03%-83.31%0.00%0.00%0.00EXPLANATIONOFSIGNIFICANTVARIANCESUnfav.primarilyforManagedPrintServicesduetocustomeractivity.Fav.OCDeptsOperations&NonGovernmentalOperations$1,096,000andOCDeptsDevelopmentSupport&NonGovernmentalDevelopment$577,700duetoincreasedrates.Fav.EquipmentRental$124,900duetorebillstodepartmentsformaintenancechargesonITOfficeEquipmentitamsUnfav.ProfessionalServices($2,672,000)duetoprojectspreviouslyapprovedinprioryear,itisanticipatedathirdquarterbudgetamendentwillbeneeded;FreightandExpress($272,400)Depreciation($181,700)forITcapitalprojectsinprogressnotfullyoperational;InternalServicesoverallunfav.of($161,000)isprimarilyduetofav.MaintenanceDept.;PartsandAccessories($115,500),Communications($12,000)duetohigherthananticipatedcosts;ContractedServices($10,400),MaintenanceContracts($5,200)duetoincreasedactivity.Partiallyoffsetbyfav.TravelandConference$71,200andMileage$1,900duetotravelrestrictionsasaresultoftheCOVID-19pandemic;Supplies$4,100duetousage;BankCharges$1,300forpaypalservicesandAuction$1,500.Unfav.InterestIncomeduetolessthananticipatedlevelofcashavailableforinvestments.99
InformationTechnolo OPERATINGREVENUES:OutsideInsideTOTALOPERATINGREVENUEOPERATINGEXPENSESNETINCOME(LOSS)BEFOREOPERATINGTRANSFERSNON-OPERATINGREVENUETRANSFERSINCAPITALCONTRIBUTIONTRANSFERS(OUT)NETREVOVER(UNDER)EXP*TOTALNETPOSITION-BEGINNINGTOTALNETPOSITION-ENDING-TelephoneCommunications(67500$$$ADOPTEDBUDGET12,000.003,525,8763,537,876.003,583,850.00$$$COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTINTERNALSERVICEFUNDS/ENTERPRISEFUNDAMENDEDBUDGET12,000.003,525,8763,537,876.003,583,850.00INFORMATIONTECHNOLOGYFY2022FORECASTVARIANCEFAV/(UNFAV)7,700.00$3,930,076.00$404,200.003,937,776.00$399,900.003,876,250.00$(4,300.00)(292,400.00) AA(45,974.00)30,000.00(15,974.00)a PR PAA!&(45,974.00)30,000.00(15,974.00)$61,526.00$107,500.0030,000.00$-91,526.001,908,586.532,000,112.53 *PleasenotethatintheAdoptedBudget(line-itembook)thisisbudgetedas"PlanneduseofFundBalance"intherevenuecategory.107,500.00PERCENT-35.83%11.46%11.30%-8.16%0.00%0.00%0.00%0.00%EXPLANATIONOFSIGNIFICANTVARIANCESUnfav.SaleofPhoneExternalduetodecreasedusageoflandlines.Fav.SaleofPhoneduetocellphoneusage.Unfav.Communications($934,800)andMaintenanceEquipment($320,100)duetohigherthananticipatedcost;EquipmentRepairsandMaintenance($145,900);InternalServices($59,300)primarilyduetoInfoTechOperations($14,900)andTelephone($44,700)basedonactualusage;IndirectCost($36,900)duetoactualchargesbeingdevelopedafterbudgetfinalizationandMembershipDues($1,500)duetocostsbeinghigherthanthebudgetprojection.PartiallyoffsetbyFav.ContractedServices$999,800duetolessthananticipatedactivity;Depreciation$192,600basedondepreciationschedulesandTowerCharges$13,800duetodecreased100
InformationTechnology-CLEMIS(53500)OPERATINGREVENUES:OutsideInsideTOTALOPERATINGREVENUEOPERATINGEXPENSESNETINCOME(LOSS)BEFOREOPERATINGTRANSFERSNON-OPERATINGREVENUETRANSFERSINTRANSFERS(OUT)CAPITALCONTRIBUTIONNETREVOVER(UNDER)EXP*TOTALNETPOSITION-BEGINNINGTOTALNETPOSITION-ENDING$ADOPTEDBUDGET5,031,206.001,531,237.00COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTINTERNALSERVICEFUNDS/ENTERPRISEFUNDAMENDEDBUDGET$§,031,206.001,531,237.00$INFORMATIONTECHNOLOGYVARIANCEFAV/(UNFAV)FY2022FORECAST5,270,306.00$239,100.001,758,437.00227,200.00 $$6,562,443.0012,382,410.00$ 6,562,443.00$ 12,382,410.00A7,028,743.00$466,300.0011,729,610.00$652,800.00 $$$$$$(5,819,967.00)35,000.001,644,186.00(4,140,781.00)$ (5,819,967.00)$35,000.001,644,186.00A AA ww(4,140,781.00)Ge AA wF a $(4,700,867.00)$ 1,119,100.0035,000.001,644,186.00(3,021,681.00)11,650,398.078,628,717.07 1,119,100.00 PERCENT4.75%14.84%7.11%5.27%0.00%0.00%0.00%0.00%EXPLANATIONOFSIGNIFICANTVARIANCESFav.In-CarTerminals(External)$212,900forfleetofCLEMISagencies;AccessFeesNonOakland$22,000duetoupdatedlawenforcementFullTimeEquivalentcountusedforbilling;.Alsofav.CrimeMapping$5,000,CLEMISParking$700duetoincreasedusagebyOaklandandnon-Oaklandagencies.Partiallyoffsetbyunfav.PartsandAccessories($1,500)duetodecreasedactivity.Fav.ReimbGeneral$102,200basedonactualsforCLEMISstaffsupportingSheriffproject;In-CarTerminal$54,700duetoparticipationcounthigherthanbudgetprojectionandOCDeptsOperations$70,300basedonanticipatedCLEMISstaffresourcessupportingSheriffprojects. Fav.Depreciation$691,500basedondepreciationschedule;SalariesandFringes$288,900duetovacancies;InternalServices$82,900primarilyduetoITDevelopmentduetousage.Partiallyoffsetbyunfav.SoftwareLease($154,500)andIndirectCost($137,800)duetoactualchargesdeterminedafterbudgetfinalization.Also,unfav.RebillableServices($118,100)basedonactualconnectivitycoststoTier2.5and3.0agencies.PleasenotethatintheAdoptedBudget(line-itembook)thisisbudgetedas"PlanneduseofFundBalance"intherevenuecategoryandBudgetedEquityAdjinExpenses.101
ADOPTEDBUDGET InformationTechnology-RadioCommunications(53600) OPERATINGREVENUES:Outside$ 9,265,600.00Inside$491,828.00rnAMENDEDBUDGET9,265,600.00491,828.00a ACOUNTYOFOAKLANDFY2022FIRSTQUARTERREPORT
INTERNALSERVICEFUNDS/ENTERPRISEFUNDINFORMATIONTECHNOLOGYFY2022FORECAST9,271,000.00406,728.00VARIANCEFAV/(UNFAV)5,400.00(85,100.00) TOTALOPERATINGREVENUE$ 9,757,428.00OPERATINGEXPENSES$ 6,835,932.00a9,757,428.006,835,932.009,677,728.006,988,232.00(79,700.00)(152,300.00) NETINCOME(LOSS)BEFOREOPERATINGTRANSFERS$ 2,921,496.00NON-OPERATINGREVENUE$100,000.00TRANSFERSIN$-TRANSFERS(OUT)$(286,000.00)NETREVOVER(UNDER)EXP*$_2,735,496.00TOTALNETPOSITION-BEGINNINGTOTALNETPOSITION-ENDINGan2,921,496.00100,000.00(286,000.00)2,735,496.00$$$ 2,689,496.00100,000.00(286,000.00)2,503,496.0043,227,512.6145,731,008.61(232,000.00)(232,000.00)PERCENT0.06%-17.30%-0.82%-2.23%0.00%0.00%0.00%EXPLANATIONOFSIGNIFICANTVARIANCESFav.OutsideAgenciesduetovolumeofusers/receiptof911surcharge.Unfav.PartsandAccessories($91,800)duetolowerthananticpatedreimbursementbyparticipatingagenciesforequipmentreplacementpartiallyoffsetbyReimbGeneral$6,700.Unfav.InterestExpense($230,300)duetointerestofbondmoney;TowerCharges($160,000);ElectricalService($44,600)duetousageandContractedServices($900)duetohigherthananticipatedcosts.Partiallyoffsetbyfav.EquipmentMaintenance$195,200;InternalServices$63,200primarilyduetoInfoTechCLEMISbasedonusage;Depreciation$18,900basedondepreciationscheduleandFreightandExpress$6,500basedonusage.PleasenotethatintheAdoptedBudget(line-itembook)thisisbudgetedas"PlanneduseofFundBalance"intherevenuecategoryandBudgetedEquityAdjinExpenses.102
ADOPTEDAMENDEDBUDGETBUDGET FireRecordsManagement(53100)OPERATINGREVENUES:Outside$291,730.00$291,730.00COUNTYOFOAKLANDFY2022FIRSTQUARTERREPORTINTERNALSERVICEFUNDS/ENTERPRISEFUNDINFORMATIONTECHNOLOGYFY2022FORECAST291,730.00VARIANCEFAV/(UNFAV)PERCENT-0.00% TOTALOPERATINGREVENUES$291,730.00$291,730.00OPERATINGEXPENSES$1,199,137.00$1,199,137.00291,730.001,188,637.00-0.00%10,500.000.88% NETINCOME(LOSS)BEFOREOPERATINGTRANSFERS$(907,407.00)$(907,407.00)NON-OPERATINGREVENUE$3,000.00$3,000.00522,930.00TRANSFERSINTRANSFERS(OUT)CAPITALCONTRIBUTION522,930.00AAA
AAG An
NETREVOVER(UNDER)EXP*(381,477.00)A(381,477.00)TOTALNETPOSITION-BEGINNINGTOTALNETPOSITION-ENDINGAA $$__1,170,190.08_(896,907.00)400.00522,930.00(373,577.00)1,543,767.08170,190.0810,500.00(2,600.00)-86.67%-0.00%-0.00%-0.00%7,900.00EXPLANATIONOFSIGNIFICANTVARIANCESFav.IndirectCosts$9,000duetoactualchargesdeterminedafterbudgetfinalization.Also,fav.InternalServices$1,500primarilyduetoITOperationsduetousage.Unfav.primarilyInterestIncomeduetolessthananticipatedlevelofcashavailableforinvestments.*PleasenotethatintheAdoptedBudget(line-itembook)thisisbudgetedas"PlanneduseofFundBalance"intherevenuecategoryandBudgetedEquityAdjinExpenses.103
Date:DepartmentofPublicServicesOaklandCountyChildren'sVillageDonationTracking:DonationPeriodOctober2021-December2021Donor:Cash/Check:Items:EstimatedValue: 10/4/20212St.PerpetuaPillowCases$375.00 10/5/2021WaterfordSeniorCenter8pillows$40.00 10/15/2021OCCVFPumpkins$87.50 10/21/2021CatholicCommunityResposeTeamUniforms$600.00 10/22/2021SweetDreamsofKids15Pillowcases$225.00 10/27/2021R.Hunter5BagsofLadiesClothing$250.00 11/2/2021St.PerpetuaPillowCases$450.00 11/4/2021CarusoCaruso363PairsofJeans$4,356.00 11/9/2021K&AHubertyCheck$1,000.00 11/10/2021E.ChatmanClothes&Shoes$300.00 11/18/2021SweetDreamsofKidsPillowCases$225.00 11/22/2021AmerisureInsuranceSweatshirts,GiftBags,Snacks,Games$1,200.00 11/23/2021R.TankClothing$200.00 11/24/2021S.HollingsheadClothing$300.00 11/24/2021J.HollingsheadClothing$500.00 11/29/2021VibeCUCheck$500.00 12/1/2021MDHHS-OCSouthfieldDistrictClothing$800.00 12/1/2021OCCVFCrafts,Radios,Earbuds,PlayingCards$1,988.10 12/3/2021ClarkstonUnitedMethodist20ChristmasGiftsforGNS$160.00 12/4/2021ChristTheRedeemerClothes,SportsEquip,Crafts,Games,Toieltries$3,500.00 12/6/2021M.CampbellCoat$60.00 12/7/2021ALittleQuiltShopQuilts&Books$200.00 12/7/2021St.PerpetuaPillowCases$375.00 12/8/2021P.Dorris24DozCookies$100.00 12/8/2021E.EaglenCheck$155.00 12/9/2021OCCVFGasCards$50.00 12/9/2021SweetDreamsofKidsPillowCases$225.00 12/9/2021St.Mary'sClothes,SportsEquip,Crafts,Games,Toieltries$2,000.00 12/10/2021OurLadyofRefugeParishGiftCards,BakedGoods,Candy$250.00 12/10/2021St.MaryParishBlankets,Games,Soda,Cookies$510.00 12/10/2021St.PatrickChurchGifts&MealforBTS$500.00 12/13/2021 ChristChurchCranbrook Toys,Games,Toiletries,Books $1,900.00 104
Date:DepartmentofPublicServicesOaklandCountyChildren'sVillageDonationTracking:DonationPeriodOctober2021-December2021Donor:Cash/Check:Items:EstimatedValue: 12/13/2021ChristChurchCranbrookCheck$100.00 12/13/2021HathEqicMinistries100ChristmasBags$100.00 12/15/2021WelcomeBaptistChurch25BagsofSocks&Toiletries$500.00 12/15/2021KicksforKidsNikeandVan'sSneakers$1,000.00 12/15/2021Sheriff'sOfficeBagofGiftsforEachMPResidient$2,500.00 12/15/2021LakesVicaritiesBlankets,Games,Soda,Cookies&PizzaGiftCard$600.00 12/15/2021C.GravesCandy,toiletries,Socks,Pajamas$300.00 12/15/2021D.BakerCandy,toiletries,Socks,Pajamas$300.00 12/15/2021J.BoykinsCandy,toiletries,Socks,Pajamas$300.00 12/15/2021St.Mary'sofMilfordBlankets,Games,Soda,&JimmyJohnsGiftCard$275.00 12/15/2021J.RossCoats,Gloves,&Pajamas$100.00 12/20/2021OPFIUCheck$1,000.00 12/21/2021A.SusallnGames,Toys,SprotsEquip$300.00 12/23/2021J.McCurdyChristmasGiftBags,Toiletries&Candy$400.00 Total: $31,156.60 105
INDINDINDINDINDINDINDINDINDINDINDINDINDINDINDORNRNCRNCRNCSACBudgetCenterProject/Program -Contribution-CommemorativeBench___Contribution-GeneralContribution-GeneralContribution-DisabilityDirtDayContribution-DisabilityDirtDayContribution-INDSensoryGardenProjectContribution-INDSensoryGardenProjectContribution-INDSensoryGardenProjectContribution-INDSensoryGardenProjectContribution-INDSensoryGardenProjectContribution-INDSensoryGardenProjectContribution-INDSensoryGardenProjectContribution-INDSensoryGardenProjectContribution-INDSensoryGardenProjectContribution-INDSensoryGardenProjectContribution-INDSensoryGardenProjectContribution-INDSensoryGardenProjectContribution-INDSensoryGardenProjectContribution-INDSensoryGardenProjectContribution-CommemorativeBenchContribution-GeneralContribution-GeneralContribution-GeneralContribution-GeneralContribution-EllisBarnRelocationlayneMller“OAKLANDCOUNTYPARKS&RECREATIONCOMMISSIONFY20221QReportforContributions(Donations)-October1,2021-December31,2021Amount$1,000.00AddisonOaksTotal$50.00SourceVictoriaJodway Kurt&MauraJungieeeADMTotal$20.00$250.00HollyOaksORVParkTotal$50.00$50.00$75.00$15.00$100.00$100.00$150.00$20.00$100.00$30.00$50.00$20.00$50.00$100.00$1,000.00IndependenceOaksTotal$50.00OrionOaksTotalAnonymous$50.00Anonymous$0.83Anonymous$5.00RedOaksNatureCenterTotal$10,000.00SpringfieldOaksTotalAnonymousWilliamVickersJohnFirettoJim&BarbaraReedGeraldMcNallyBerlFalbaumRobertHaarCatherineGenoveseDavidDouthatDeborahSarsfieldDennisRitterGeorgeWhiteLeighElceserLindaGuzmanMichaelPapinFloyd&JoanKopietzMichaelStefaniakLayneMillerRBI33LLC/KirkGibsonGrandTotal$26,305.26$12,969.43$1,000.00$13,019.43$270.00$1,910.0050.00$55.83$10,000.00 106
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy)Donations -FY 2022 First Quarter (October 2021 -December 2021)
poyeyRS ColaPlo Latetacoya Sear)Dyess Receipt Number Amount helt drcin iil sie
10/1/2021|Donation Box 64874 367689
10/1/2021]Amanda Paavo 64917 $21.01 368566
10/1/2021)Ashley Jackson 64920 $0.47 368566
10/2/2021}Lynette Damian 64922 $0.01 368566
10/3/2021]Heidi Johnson 64921 $5.00 368566
10/3/2021]Xandrea Kirk 64934 $0.01 368566
10/4/2021]N Palmer 64947 $40.00 368566
10/4/2021]Nicholas DePalma 64957 $5.00 368566
10/4/2021)Jaimie Danno 64964 $5.00 368566
10/4/2021)}Karen Unholz 64967 $5.00 368566
10/4/2021}John Swanson 64983 $1.01 368566
10/5/2021|Benard Dorer 65000 $50.00 368113
10/6/2021}Amanda Berney 65022 $1.00 368566
10/6/2021]Dennis Denver 65029 $2.00 368111
10/6/2021]Ramandeep Malhi 65096 $5.00 368566
10/7/2021]John Little 65061 $5.00 368461
10/7/2021]Alfred Demailo 65062 $100.00 368461
10/7/2021]Elissa Staeuble 65067 $25.00 368461
10/7/2021]Donation Box 65069 $1.53 368461
10/7/2021]Marilisa Plata 65082 $44.00 368461
10/7/2021)Kanesia Gage 65088 $1.00 368461
10/8/2021)Cynthia Miller 65122 $76.00 368461
10/8/2021]Edward Dougherty 65148 $5.00 368566
10/8/2021}Alex Grodzicki 65152 $0.01 368566
10/9/2021|Pamela Ward 65141 $40.00 368534
10/9/2021]Madhusudhana Prabhu Bolantur 65157 $5.00 368566
10/10/2021]Noah Skovron 65170 $5.00 368566
10/11/2021}Paula Suddon 65173 $0.47 368566
10/12/2021]Nick Baldwin 65222 $0.01 369053
10/12/2021|Joyce Dawson 65232 $0.12 368853
10/12/2021|Independent Bank Farm Hills Branch 65340 $1500.00 368853
10/14/2021]Kelli Donegan 65280 $5.00 369053
10/14/2021|Nina Coppola 65281 $0.01 369053
10/14/2021]Linda Burris 65294 $100.00 369020
10/14/2021}Andrew Coffey 65295 $5.00 369053
10/14/2021]Reina Foster 65305 $0.02 369053
10/14/2021]Madhusudan Suryanarayanan 65306 $0.01 369798
10/15/2021]Deena Wierzbicki 65312 $0.47 369798
10/15/2021)Corina Hopkins 65319 $10.00 369798
10/16/2021|Tyler Vecere 65336 $0.01 369798
10/16/2021|Jenna Giragosian 65337 $0.01 369798
10/16/2021]Ryan Schultz 65338 $0.47 369798
10/17/2021]Rebekah Catlett 65345 $0.47 369798
10/18/2021]Brett Rosenberg 65354 $0.47 369798
10/18/2021]Lindsey Leppek 65361 $0.47 369798
10/18/2021]Mark Holsworth Sr 65363 $25.00 369363
10/18/2021)Peter Shillingford 65377 $5.00 369798
10/19/2021]Mark Mudd 65390 $5.00 369534
10/19/2021)Robert Gallette 65391 $40.00 369534
10/19/2021|Kathryn Smith 65392 $100.00 369534
107
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy)Donations -FY 2022 First Quarter (October 2021 -December 2021)
10/19/2021]Pet Supplies Plus 65393 $156.00 369534
10/19/2021|Igive 65398 $103.51 369534
10/19/2021|John Little 65399 $5.00 369534
10/19/2021)Alfred Demailo 65402 $100.00 369534
10/19/2021/Elissa Staeuble 65405 $25.00 369534
10/20/2021)Michael Whitlock 65437 $5.00 369798
10/21/2021]Brian Brown 65501 $0.47 370516
10/22/2021]Nola DiVico 65487 $200.00 370281
10/25/2021]Sarah Callahan 65511 $100.00 370279
10/25/2021}Donation Box 65543 $147.00 370769
10/25/2021]LindaWeingart 65703 $5.00 370849
10/26/2021]Ellen McKay 65548 $25.00 370767
10/26/2021] Olga Lovell 65549 $35.00 370767
10/26/2021)Bridget McArdle 65550 $50.00 370767
10/26/2021]Tina Easley 65551 $25.00 370767
10/26/2021)Lorna Place 65552 $25.00 370767
10/26/2021|Carl Rose 65553 $100.00 370767
10/26/2021]Mark Mudd 65554 $5.00 370767
10/26/2021]North American Lighting 65555 $381.00 370767
10/26/2021|James Scribner 65560 $50.00 370767
10/26/2021|Susan Ring 65561 $40.00 370767
10/26/2021|The Taubman Company 65562 $3500.00 370767
10/26/2021)Charles Fortinberry 65563 $100.00 370767
10/26/2021|Joseph Gates 65564 $50.00 370767
10/26/2021]The Cabinet Gallery,Inc 65567 $50.00 370767
10/26/2021]Mary Dooley 65568 $100.00 370767
10/26/2021]Ubs Financial Services 65572 $50.00 370767
10/26/2021|Katie Bowers 65584 $5.00 370849
10/26/2021|Stephanie Roberts 65585 $5.00 370849
10/28/2021|Jamie LaFerle 65621 $0.47 370849
10/29/2021)Cheryl Kozell 65629 $50.00 371094
10/29/2021]Quamain Spann 65656 $1.00 371096
"October 2021 Total $7,825.51
Date of Donation Person Donating Receipt Number Amount areVeT eI Talef=1g
11/1/2021|Maha Aldaghma 65659 $43.00 ve a 0gG
11/1/2021]Cheryl Kozell 65661 $50.00 371094
11/1/2021]Donation Box 65692 $170.00 371307
11/1/2021]Martha Skoglund 65713 $0.01 371681
11/2/2021]Ramona Nave 65707 $2000.00 371305
11/2/2021]Gabriel Vanhouten 65715 $2.50 371305
11/3/2021|Deanna Damore 65731 $5.00 371681
11/3/2021}Jennifer Phillips 65733 $1.00 371305
11/4/2021]Hiro Shepard 65748 $10.00 371681
11/4/2021)Allison Tyler 65750 $10.00 371681
11/5/2021]Valerie Whalen 65827 $5.00 371681
11/6/2021}Larry Bezak 65797 $2.00 371681
11/8/2021]Olivia Maynard 65802 $500.00 371640
11/8/2021]Darris &Renee Lazoen 65806 $40.00 371640
11/8/2021]Laurie Bolton-Gregg 65833 $30.00 371848
11/9/2021]Elaine McCants 65848 $2.00 371848
108
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy)Donations -FY 2022 First Quarter (October 2021 -December 2021)
11/9/2021|Sherri Brazel 65855 $57.50 371848
11/9/2021|Stephen caramagno 65858 $200.00 371850
11/10/2021|Jessica Essayan 65882 $100.00 371981
11/10/2021]Neil Krohn 65895 $10.00 371905
11/10/2021)Mitch Frank 65925 $1.00 371905
11/12/2021]Lisa Russell 65907 $100.00 371983
11/12/2021}Lisa Russell 65908 $150.00 371983
11/14/2021]Danielle Barey 65943 $1.00 372099
11/15/2021|Stephan Poag 65933 $100.00 372170
11/15/2021}Irvin Products 65938 $700.00 372170
11/16/2021|James Okelley 65969 $100.00 372170
11/17/2021)Julia Judge 66004 $20.00 372328
11/17/2021]Amanda Vartanian 65984 $42.50 372366
11/17/2021]Bailey Lake Elementary 65986 $150.00 372366
11/17/2021|John Judge 66004 $20.00 372328
11/18/2021)Shirley Knight 66009 $50.00 372364
11/18/2021]Bernadette Tomko 66014 $100.00 372364
11/19/2021]Donation Box 66021 $75.25 372546
11/20/2021]Colette Franklin 66121 $0.02 372905
11/22/2021|Karyn Walack-Otani 66054 $50.00 372546
11/23/2021]Larry Tracy 66082 $24.00 372667
11/28/2021|Darlene Mihelich 66110 $25.00 372812
11/29/2021]Carol Smith 66118 $3.50 372812
11/29/2021]Melissa Clark 66126 $100.00 372812
11/30/2021|Judith Ashley 66137 $8.00 372977
11/30/2021]Mike Packard 66144 $20.00 372905
11/30/2021|Rebecca Buffa 66145 $500.00 372905
November 2021Total —«$5,578.28
Date of Donation PyvexelsM Bolegl 3 Receipt Number Amount Journal Number
12/1/2021]Stephanie Zaleski 66175 $5.00 373234
12/1/2021]Anne Breuch 66176 $5.00 373234
12/1/2021]Richard Davis 66178 $5.00 373234
12/1/2021]Mitch Suddendorf 66180 $0.25 373234
12/2/2021]Michael Telgheder 66195 $0.80 373234
12/2/2021]Donation Box 66200 $87.00 373154
12/2/2021]Alla Gushcha 66203 $20.00 373152
12/2/2021]Tracy Pearcy 66209 $5.00 373234
12/2/2021|Tony Garcia 66213 $5.00 373234
12/2/2021|Kacey Skala 66224 $5.00 373234
12/2/2021]Mitch Suddendorf 66243 $0.25 373234
12/2/2021|Sarah Brunet -66244 $0.80 373234
12/3/2021]Rachel Tanielian 66233 $50.00 373152
12/3/2021]Elissa Staeuble 66234 $25.00 373152
12/3/2021]Nina Felicie 66236 $50.00 373152
12/3/2021]Brighthouse Life Insurance Co 66281 $560.00 373152
12/3/2021]Huijuan Wang 66297 $5.00 373234
12/4/2021]Marina Josifovski 66304 $5.00 373234
12/4/2021]Tina Emiry 66306 $0.50 373234
12/4/2021)Phillip Chapman 66307 $5.00 373234
12/4/2021]Renata Olivari Tumonis 66352 $0.55 373234
109
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy)Donations -FY 2022 First Quarter (October 2021 -December 2021)
12/5/2021]Allyson Veasey 66309 $3.80 373234
12/5/2021|Kayla Conner 66312 $5.00 373234
12/6/2021]Cindy McConnell 66285 $100.00 373372
12/6/2021]Colleen Buggia 66328 $10.00 373234
12/6/2021]|Kathlyn Shady 66331 $0.80 373234
12/6/2021||lsabela CormenzanaORojas 66333 $4.40 373372
12/6/2021|Amey Sawant 66370 $3.00 373234
12/7/2021)Caitlin Hall 66373 $0.55 373965
12/7/2021]Lekeya Hoosman 66389 $5.00 373965
12/7/2021|Mary Doyle 66393 $0.80 373965
12/7/2021)Philip Arbit 66403 $5.00 373965
12/7/2021]Philip Cunningham 66416 $0.80 373965
12/7/2021]Nicholas Streng 66418 $0.25 373965
12/7/2021)Kelli Kaczmarek 66420 $10.00 373965
12/8/2021]Elizabeth Anderson 66423 $10.00 373965
12/8/2021]Michelle Wiater 66446 $0.25 373965
12/8/2021]Michelle Bird 66451 $125.00 373965
12/8/2021|Kelsey Bryer 66452 $0.80 373965
12/9/2021]Susan Demaggio 66465 $100.00 373537
12/9/2021|Anne Burns 66476 $20.00 373539
12/9/2021]Alana Nobile 66486 $0.60 373965
12/9/2021|Jenai Olmos 66490 $5.00 373965
12/9/2021|James Godden 66493 $5.00 373965
12/10/2021]LuAnn Rase 66512 $0.80 373965
12/10/2021]Arielle Golden 66413 $0.80 373965
12/10/2021]Brooke Schemers 66517 $5.00 373965
12/10/2021}Karen Molloy 66520 $200.00 373722
12/10/2021]Richard Kuss 66542 $50.00 373965
12/10/2021|Jean Claude Azar 66547 $5.00 373965
12/10/2021|Sachin Prabhu 66550 $0.80 373965
12/11/2021|Janet Yosick 66543 $25.00 373965
12/11/2021|Joanne Dupuis 66553 $27.90 373965
12/11/2021]Aubri Hayali 66561 $0.85 373965
12/11/2021|Jennifer Smith 66579 $5.00 373965
12/12/2021|Jon Ballard 66562 $5.00 373965
12/12/2021}Cathryn U 66568 $0.90 373965
12/13/2021|Margot Surridge 66581 $50.00 373722
12/13/2021|Cynthia Fiser 66590 $0.55 373965
12/13/2021]|Luis Abreu 66592 $5.00 373965
12/13/2021]Brett Walker 66595 $5.00 373965
12/13/2021|Takami Skarakis 66609 $5.00 373965
12/14/2021|Katherine Hardy 66627 $25.00 373915
12/14/2021]Ashley Stoecker 66642 $0.55 373965
12/14/2021}Carol Terrien 66645 $0.80 373965
12/14/2021|Anne Robinson 66648 $10.00 373965
12/14/2021]Maureen Thai-Tang 66656 $20.00 373965
12/14/2021)Nancy Isken 66657 $0.90 373965
12/15/2021|Jeffrey Davis 66658 $0.55 373965
12/15/2021|Deborah Warburton 66664 $100.00 373915
12/15/2021|Sharon Lanzetta 66675 $5.00 373965
12/15/2021]Michael Spisz 66685 $150.00 373965
110
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy)Donations -FY 2022 First Quarter (October 2021 -December 2021)
12/15/2021|Matthew Reimann 66686 $5.00 373965
12/15/2021]Edwina McKenzie-Madison 66687 $5.00 373965
12/16/2021|Alfred Demailo 66683 $100.00 374072
12/16/2021]Alfred Demailo 66684 $125.00 374072
12/16/2021]Crystalyn Houston 66690 $10.00 373965
12/16/2021|Jaehak Bae 66692 $5.00 373965
12/16/2021}Sarah Scheeres 66694 $0.25 373965
12/16/2021]Alyson Skelton 66703 $100.00 373965
12/16/2021|Jennifer Sais 66704 $0.80 373965
12/16/2021]Wayne Facca 66708 $100.00 374074
12/16/2021]Delaney Mitchell 66712 $5.00 373965
12/16/2021|Jennifer Soldan 66720 $0.55 373965
12/16/2021|Susan Vela 66723 $0.25 373965
12/16/2021]Margaret Pauly 66728 $0.80 373965
12/17/2021]Xavier Delossantos 66726 $5.00 374388
12/17/2021}Fred Koehler 66733 $50.00 374072
12/17/2021}Jenica Topp 66746 $5.00 374388
12/17/2021]Maria Salmons 66767 $10.00 374388
12/17/2021]Austin Wright 66770 $0.25 374388
12/18/2021}Paula Heisler 66760 $150.00 374245
12/18/2021|Cassandra Mosley 66776 $5.00 374388
12/18/2021]Eric Rassmussen 66782 $8.80 374388
12/18/2021]Bruce Gwinn 66805 $5.00 374388
12/18/2021]Leslee Statfield 67218 $20.00 374388
12/19/2021]Charlotte Lyons 66766 $0.50 374388
12/19/2021}Ken James 66786 $0.90 374388
12/19/2021]Bailey Jones 66787 $0.15 374388
12/19/2021]Elizabeth Boyd 66789 $25.00 374388
12/20/2021]Kunal Chitnis 66790 $0.55 374388
12/20/2021)Alicia Rajhel 66804 $10.00 374388
12/20/2021]Anca Nastasa 66810 $5.00 374388
12/20/2021]Amy Garabedian 66827 $10.00 374388
12/21/2021]Carey May :66835 $5.00 374388
12/21/2021|John Lacks 66842 $0,90 374388
12/21/2021|John Lacks 66844 $0.90 374388
12/21/2021|James Glidden 66846 $500.00 374245
12/21/2021)Raviraj Nayak 66861 $5.00 374388
12/21/2021]Dawn Kelly 66871 $5.00 374388
12/21/2021]Andreas Keuper 66885 $0.55 374388
12/21/2021]Andrew Green,CDP 66886 $0.25 374388
12/21/2021]Amanda Paavo 66889 $20.00 374388
12/21/2021]Emily Fisher 66893 $0.55 374388
12/21/2021]Amanda Wilt 66898 $0.80 374388
12/21/2021}Joseph Affeldt 66899 $42.50 374245
12/21/2021]Dawn Barber 66905 $0.55 374388
12/21/2021]Abby Slager 66911 $0.55 374388
12/21/2021]Mark Schiebold 66913 $0.80 374388
12/21/2021]Melissa Hallman 66914 $0.10 374388
12/21/2021)Tingting Yan 66916 $0.55 374388
12/21/2021]Dereck Wonnacott 66921 $20.00 374388
12/21/2021|Lisa Graff 66926 $10.00 374388
111
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy)Donations -FY 2022 First Quarter (October 2021 -December 2021)
12/21/2021|Stephen Bernstein 66927 $5.00 374388
12/21/2021]Paul Bonfiglio 66933 $0.58 374388
12/21/2021]Barb Rogers 66935 $0.80 374388
12/21/2021|Scott Aderhold 66938 $10.00 374388
12/21/2021}Andrew Durren 66941 $5.00 374388
12/21/2021|Jennifer Naami 66943 $0.80 374388
12/21/2021]Linda Plotkin 66945 $20.00 374388
12/21/2021)Cathy Kraepel 66950 $0.55 374388
12/21/2021]Mary Parise 66960 $10.00 374388
12/21/2021]Hale Wells 66964 $0.55 374388
12/21/2021]Harshavardhan Nilakantan 66987 $5.00 374388
12/21/2021]Dawn Kingstrom 66992 $0.10 374388
12/21/2021]Maddie Wingle 66997 $10.00 374388
12/21/2021] Kathleen Alayan 67001 $5.00 374388
12/21/2021|Deana Derocha 67010 $5.00 374388
12/21/2021}Kristina Dunne 6011 $10.00 374388
12/21/2021]Stephen Harris 67026 $0.55 374388
12/21/2021|Fe Quicho 67029 $5.00 374388
12/21/2021}Dan Corcoran 67030 $5.00 374388
12/21/2021]Denise Rose 67040 $0.55 374388
12/21/2021}Samantha Curnett 67042 $3.25 374388
12/21/2021|Julie Marsili 67047 $0.55 374388
12/21/2021]Adela Cindrak 67057 $0.55 374388
12/21/2021]Whitney Gootee 67066 $1.00 374388
12/21/2021|Cathy Brush 67073 $5.00 374388
12/21/2021)William Barrett 67081 $10.00 374388
12/21/2021]Morris Hinson 67083 $50.00 374388
12/21/2021]Eden Hartley 67098 $5.00 374388
12/21/2021]Kurt Geiger 67101 $5.00 374388
12/21/2021|Jeffery Thiele 67109 $25.00 374388
12/21/2021]Shan Sundaram 67189 $5.00 374388
12/21/2021|Eric Ward 67191 $0.25 374388
12/21/2021]|Julia Thomas 67199 $0.55 374388
12/21/2021|Kara Rucinski 67201 $0.80 374388
12/21/2021|Alesandra Muncie 67211 $5.00 374388
12/21/2021]Marie Laurent 67235 $50.00 374388
12/21/2021}Lauren Gasparotto 67250 $0.90 374388
12/21/2021]Amber Edmunds 67361 $0.80 374388
12/21/2021]Alexandra Peindl 67430 $10.00 374388
12/22/2021|Cathleen LaLonde 66939 $20.00 374388
12/22/2021]Amy Walsh 66991 $0.55 374388
12/22/2021]Kristen Gazdecki-Hardi 67013 $40.00 374367
12/22/2021)Brittany Ferguson 67103 $0.25 374388
12/22/2021]Karen Keller 67263 $0.55 374388
12/22/2021]Mark Brummer 67267 $8.80 374388
12/22/2021]Anna Dew 67273 $0.55 374388
12/22/2021]Lisa Burrell 67274 $0.90 374388
12/22/2021)Christopher Jones 67282 $0.55 374388
12/22/2021)Ellie Phillips 67370 $0.35 374388
12/22/2021]Frank Schuster 67372 $20.00 374388
12/22/2021]Kimberly Wilcox-Olsen 67374 $10.00 374388
112
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy)Donations -FY 2022 First Quarter (October 2021 -December 2021)
12/22/2021]Karen Burmann 67384 $5.00 374388
12/22/2021]Patti Harpenau 67390 $20.00 374388
12/22/2021|Janet Knieper 67393 $10.00 374388
12/22/2021|Shannon Soliven 67396 $0.55 374388
12/22/2021]David Case 67403 $5.00 374388
12/22/2021)Michelle Visser 67405 $10.00 374388
12/22/2021|Jan Waun 67409 $0.55 374388
12/22/2021)Peter Fredrickson 67419 $0.90 374388
12/22/2021]Sharon Taylor 67433 $5.00 374388
12/22/2021]Kaci Solinski 67434 $0.55 374388
12/22/2021}Heather Sullivan 67449 $8.80 374388
12/22/2021|Kaitlyn King 67461 $0.55 374388
12/22/2021]Michael Watson 67523 $0.58 374388
12/22/2021|Carolyn Dayton 67526 $10.00 374388
12/22/2021|Paige Gutowski 67528 $0.90 374388
12/22/2021}Alan Goodwin 67536 $0.55 374961
12/22/2021|Suzan Kucukarslan 67537 $10.00 374961
12/22/2021]Karen Schroeder 67544 $0.13 374388
12/22/2021]Neil Morris 67552 $0.55 374388
12/22/2021}John Heslop 67555 $5.00 374388
12/22/2021]David Barks 67567 $4.55 374388
12/22/2021]Cindy Ross 67568 $10.00 374388
12/22/2021|Breanne Elko 67578 $5.00 374388
12/22/2021|Geoff Zimmermann 67580 $0.80 374388
12/22/2021]Robert Sharp 67581 $5.00 374388
12/22/2021]Mike Yetter 67589 $5.00 374388
12/22/2021]Katie Hubbell 67592 $0.55 374388
12/22/2021]Dianna Schleben 67595 $0.55 374388
12/22/2021]Alexander Breuning 67596 $0.25 374388
12/22/2021]Henry Kerr 67598 $0.89 374388
12/22/2021]|Katie McMillan 67602 $0.80 374388
12/22/2021}Joshua Arbogast 67607 $0.80 374388
12/22/2021]Ashley Asmar 67611 $5.00 374388
12/22/2021) David Manwell 67618 $10.00 374388
12/22/2021|Tony D'Agostino 67624 $5.00 374388
12/22/2021|Suzanne Guffy 67635 $5.00 374388
12/22/2021|Nancy Morrow 67641 $10.00 374388
12/22/2021]}Amer Melick 68044 $0.90 374388
12/23/2021|Jessica Smithling 67118 $5.00 374367
12/23/2021]Ed Zaleski 67122 $25.00 374367
12/23/2021|Celeste Thomson 67129 $100.00 374367
12/23/2021|Donation Box 67146 $115.25 374675
12/23/2021|Nicole Fink 67151 $57.50 374675
12/23/2021|Jim Ghormley 67181 $20.00 374961
12/23/2021)J Fitzgerald 67182 $30.00 374961
12/23/2021]Austin Kowalczyk 67269 $0.25 374961
12/23/2021|Breanne Rrumbullaku 67652 $5.00 374961
12/23/2021|Joseph Dudak 67658 $0.08 374961
12/23/2021|Richard McConnell 67676 $5.00 374961
12/23/2021|Jon Singhoffer 67690 $0.80 374961
12/23/2021]Mackenzie Roberts 67694 $0.55 374961
113
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy)Donations -FY 2022 First Quarter (October 2021 -December 2021)
12/23/2021|Kathleen Dickenson 67701 $20.00 374961
12/23/2021|Deborah Woodman 67705 $5.00 374961
12/23/2021|Lorinda Kingins 67707 $4.55 374961
12/23/2021|Holly Fuchs 67710 $5.00 374961
12/23/2021|Dan Brownrigg 67711 $0.80 374961
12/23/2021|Julie Palmer 67713 $0.55 374961
12/23/2021)Neil Cronk 67720 $5.00 374961
12/23/2021]Amber Blair 67724 $0.80 374961
12/23/2021]Matt Crandell 67727 $0.55 374961
12/23/2021}Gabriel Vaz-Gonzales 67736 $0.80 374961
12/23/2021]Gabriel Vaz-Gonzales 67737 $0.80 374961
12/23/2021|Sharon Walden 67740 $5.00 374961
12/23/2021|Sharon Walden 67741 $5.00 374961
12/23/2021]Sheryl Bienstock 67743 $5.00 374961
12/23/2021]Achim Lohner 67744 $5.00 374961
12/23/2021]Dale Milford 67745 $10.00 374961
12/23/2021|Mark Richardson 67752 $10.00 374961
12/23/2021)Rich Byczek 67754 $10.00 374961
12/23/2021|Derek Diederich 67761 $5.00 374961
12/23/2021}Tom Mohan 67764 $5.00 374961
12/23/2021]Aaron Buck 67766 $20.00 374961
12/23/2021|Claudia Alvarado-Everardo 67767 $0.80 374961
12/23/2021]Elayne Peters 67768 $0.55 374961
12/23/2021]Leo Selvaraj 67769 $0.80 374961
12/23/2021|Eduardo Hernandez 67772 $0.25 374961
12/23/2021]Amber Trombetta 67775 $0.80 374961
12/23/2021]Lisa Castle 67779 $0.55 374961
12/23/2021)Rachel Hachigian 67782 $0.55 374961
12/23/2021|James Botsford 68468 $100.00 374961
12/23/2021|James Botsford 68469 $20.00 374961
12/23/2021]Heather Yousef 69381 $0.80 374961
12/23/2021|Heather Yousef 69382 $0.90 374961
12/24/2021]Lucas Walker 67180 $500.00 374961
12/24/2021]Michelle Pace 67788 $0.55 374961
12/24/2021]Devon Schwalm 67789 $25.00 374961
12/24/2021]Courtney Hicks 67796 $10.00 374961
12/24/2021|Stephen Drouillard 67809 $0.55 374961
12/24/2021]Michelle Clegg 67811 $5.00 374961
12/24/2021)Brian Keith Frierson 67813 $5.00 374961
12/24/2021)Susan Sargent 67821 $0.89 374961
12/24/2021]Melissa Clark 67831 $5.00 374961
12/24/2021]Brenda Johnson 67838 $0.80 374961
12/24/2021|Ryan Gavin 67841 $0.80 374961
12/24/2021]TakAKO Funaki 67847 $10.00 374961
12/25/2021]David Kinzer 67163 $10.00 374961
12/25/2021|Kimberly Noble 67852 $20.00 374961
12/25/2021|James Norton 67858 $20.00 374961
12/25/2021|Erin Murphy 67863 $5.00 374961
12/25/2021]Edward Berger 67868 $0.55 374961
12/26/2021]Rohan Repale 67876 $0.80 374961
12/26/2021|Carrin Tunney 67881 $5.00 374961
114
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy)Donations -FY 2022 First Quarter (October 2021 -December 2021)
12/26/2021]Paul Moulder 67886 $5.00 374961
12/26/2021]Paul Moulder 67887 $5.00 374961
12/26/2021|Julie Ferus 67897 $5.00 374961
12/26/2021|Katherine Russell 67900 $0.89 374961
12/26/2021]Monica Reesman 67903 $20.00 374961
12/26/2021}Alison Bulloch 67905 $0.80 374961
12/26/2021]Christine Harding 67906 $0.55 374961
12/26/2021]}Emma Burek 67909 $0.25 374961
12/26/2021|Veronica Nowasielski 67910 $0.80 374961
12/26/2021]Damodar Konda 67918 $5.00 374961
12/26/2021]Wendy Friend 67919 $0.35 374961
12/26/2021)Jill Smith 67922 $5.00 374961
12/26/2021]Danielle Nelson 67924 $5.00 374961
12/26/2021]Matt Hogan 67965 $0.80 374961
12/26/2021]Tai Gerkin 68207 $0.25 374961
12/27/2021]Daniel Blower 67426 $0.89 374961
12/27/2021]Michael Lazzarotti 67936 $0.55 374961
12/27/2021|Laura Markle 67960 $0.80 374961
12/27/2021|Terri Krasicky 67970 $10.00 374961
12/27/2021]Danielle Gratopp 67971 $0.90 374961
12/27/2021\Jessica Steffes 67978 $0.55 374961
12/27/2021|Jessica Steffes 67979 $0.55 374961
12/27/2021]Nate Lewalski 67985 $0.80 374961
12/27/2021]Michelle Weeks 67988 $0.80 374961
12/27/2021]Alastair Ironside 67991 $0.58 374961
12/27/2021|Bruce Calmer 67995 $10.00 374961
12/27/2021]Kathy Hall 67999 $0.55 374961
12/27/2021|Kara Dean 68006 $5.00 374961
12/27/2021|Ty Bowman 68018 $0.55 374961
12/27/2021|Clelyne Babcock 68022 $0.80 374961
12/27/2021]Emesta Durakovic 68023 $5.00 374961
12/27/2021}Team Smith 68038 $0.80 374961
12/27/2021]Aureo Sibuya 68053 $0.80 374961
12/27/2021|Beata Kochanek 68057 $5.00 374961
12/27/2021]Kaitlyn Barbas 68061 $0.80 374961
12/27/2021}Allyson Button 68066 $30.00 374961
12/27/2021]Dillon Forrest 68075 $0.25 374961
12/27/2021]Emanueta Serwach 68081 $0.55 374961
12/28/2021]Leslie Hoskyns 67167 $100.00 374675
12/28/2021]Mark Mudd 67168 $5.00 374675
12/28/2021]Raymond James 67170 $50.00 374675
12/28/2021|Dean &Nina Googasian 67176 $150.00 374675
12/28/2021|Ramona Nave 67179 $500.00 374675
12/28/2021]Barb Petkwitz 67234 $150.00 374675
12/28/2021|Deborah Teasdle 67259 $300.00 374674
12/28/2021|Norma Matheny 67291 $42.50 374675
12/28/2021|Jeffrey Nancarrow 67973 $0.25 374961
12/28/2021|Karla Garcia Malo Lopez 68024 $0.55 374961
12/28/2021 Dan Kelly 68096 $8.80 374961
12/28/2021)|Karen Barbash 68098 $4.55 374961
12/28/2021]Michael Mayo-Moyle 68100 $0.80 374961
115
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy)Donations -FY 2022 First Quarter (October 2021 -December 2021)
12/28/2021)Patrick McKay 68114 §0.55 374961
12/28/2021)Patrick McKay 68115 $0.55 374961
12/28/2021]|Sharon Pizzuti Mom 68124 $0.80 374961
12/28/2021}Irene Lietz 68128 $5.00 374961
12/28/2021)Tyler Hanson 68130 $5.00 374961
12/28/2021]Margaret Samberg 68131 $20.00 374961
12/28/2021}Valerie Viaentine 68133 $5.00 374961
12/28/2021]Edward Peters 68135 §20.00 374961
12/28/2021|Amber Plee 68137 $0.80 374961
12/28/2021]samantha Raska 68156 $0.55 374961
12/28/2021)Betty Rowder 68158 $5.00 374961
12/28/2021|Angus Mackay 68166 $50.00 374961
12/28/2021}Emily Douglas 68168 $20.00 374961
12/28/2021]Kristi Beno 68172 $0.58 374961
12/28/2021|Dawn Gunn 68183 $5.00 374961
12/28/2021 Jillian Mufins 68184 $0.25 374961
12/28/2021|Timothy Kalil 68221 $5.00 374961
12/28/2021|Timothy Kalil 68222 $5.00 374961
12/28/2021|Sharon Myatt 68223 $50.00 374961
12/28/2021]Eugenia Yee 68224 $5.00 374961
12/29/2021|Johanna Shuler 67309 $300.00 374675
12/29/2021|Toni Fahey 67465 $0.90 374961
12/29/2021]Erica Woodrow 67478 $50.00 374961
12/29/2021|Thomas Keith 68215 $0.50 374961
12/29/2021|Linda Ban 68248 $5.00 374961
12/29/2021]Rebecca Hayman 68261 $10.00 374961
12/29/2021}Tommy Lam 68262 $5.00 374961
12/29/2021)Kristi Gattinger 68265 $0.80 374961
12/29/2021)Theira Hyttinen 68266 $10.00 374961
12/29/2021}Lauren Bowering 68267 $5.00 374961
12/29/2021)Alysha vincent 68271 $0.25 374961
12/29/2021|Lynn Marchini 68277 $5.00 374961
12/29/2021}Lynn Marchini 68278 $5.00 374961
12/29/2021]Diane LaHaie 68282 $20.00 374961
12/29/2021]Yelena Tretyakova 68284 $27.90 374961
12/29/2021]Michael Carpenter 68293 $5.00 374961
12/29/2021]Courtney Bernard 68296 $0.55 374961
12/29/2021}Jeremy Wilson 68316 $0.80 374961
12/29/2021)Sarah Hein 68317 $0.55 374961
12/30/2021|Judith Moses 67328 $75.00 374675
12/30/2021|Walter Mrozek 67456 $10.00 374961
12/30/2021]Yvette Thrush 67471 $100.00 374961
12/30/2021]Michael Youga 68326 $5.00 374961
12/30/2021]Donna Zarzycki 68327 $20.00 374961
12/30/2021|Renee Dicicco 68330 $0.80 374961
12/30/2021)Bruce Pierce 68332 $5.00 374961
12/30/2021|Jessica Rogacki 68336 $5.00 374961
12/30/2021|Marissa Hernandez-lbanez 68343 $0.25 374961
12/30/2021|Michael Inglis 68346 $5.00 374961
12/30/2021|Rhona MacKinnon 68360 $5.00 374961
12/30/2021|Sarah Rooks 68361 $0.55 374961
116
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy)Donations -FY 2022 First Quarter (October 2021 -December 2021)
12/30/2021]Tom Rowen 68365 $0.89 374961
12/30/2021]Amanda Lind 68372 $0.80 374961
12/30/2021|Nicolas Mercer 68387 $0.55 374961
12/30/2021|Jameson Irabon 68391 $10.00 374961
12/30/2021}Hannah Sheridan 68393 $0.55 374961
12/30/2021]Michelle Lemanek 68399 $5.00 374961
12/30/2021|Gloria Denomme 68405 $0.58 374961
12/30/2021)Cory Nummer 68409 $0.80 374961
12/30/2021|Terri Medor 68412 $20.60 374961
12/30/2021)Steven Hattey 68414 $0.58 374961
12/30/2021|Kyle Sasena 68416 $5.00 374961
12/30/2021|Karin Bogacz 68422 $5.00 374961
12/30/2021|Merisa Candic 68424 $0.55 374961
12/30/2021)Emily Scroggie 68427 $0.80 374961
12/30/2021)Christina McGraw 68436 $1.00 374961
12/30/2021|Christina McGraw 68437 $1.00 374961
12/30/2021|Reshmi Saha 69346 $0.80 374961
12/30/2021]Reshmi Saha 69347 $0.80 374961
12/31/2021]Shirley Vanrenterghem 67339 $500.00 374891
12/31/2021)Elyse Sakuta 67474 $100.00 374891
12/31/2021|Roe Green 67476 $150.00 374891
12/31/2021]Gwen Rosenthal 67477 $25.00 374891
12/31/2021|Rebecca Noeske 67495 $5.00 374891
12/31/2021]Phillip Hayes 68440 $5.00 374891
12/31/2021]shyamkumar Jani 68446 $0.25 374891
12/31/2021]Mark Rompetzki 68447 $4.55 374891
12/31/2021]Barbara Davis 68458 $10.00 374891
12/31/2021|sierra Ellis 68462 $10.00 374891
12/31/2021)}Jen Craven 68463 $0.90 374891
12/31/2021|Marko Josten 68464 $20.00 374891
12/31/2021|Larry Kinney 68489 $7.90 374891
12/31/2021]Cindy Hem 68496 $0.80 374891
12/31/2021|Cathy Broses 68497 $0.80 374891
12/31/2021]Patrick Whyte 68507 $5.00 374891
12/31/2021]Eric Kerr 68508 $10.00 374891
12/31/2021}Juergen Viereck 68511 $10.00 374891
12/31/2021]Rodrigo Ludke de Oliveira 68527 $0.55 374891
12/31/2021]Ann Hornick 68542 $8.80 374891
December 2021 Total $8,390.39
Q1 FY 2022 Total $21,794.18
117
OAKLANDCOUNTYCOMMUNITY&HOMEIMPROVEMENTDIVISION REQUESTFORAUTHORIZATIONTORECOGNIZEUNCOLLECTIBLEHOMEiMPROVEMENTLOANS AstQUARTERFY2021 IO}GRANTZIPCODECASENO.CDBG/HOMEDATE|REHAB|CONTRACT.LOANNAME__|__ADDRESSCOMMUNITYDATEDEEMED"FORECLOSURETYPE;TAX/MORTGAGE/OTHERWRITEGFFAMOUNTTOTAL WRITEOFFAMOUNT AMOUNTUNCOLLECTIBLE Joseph&NancyWatts(148W.Morehouse‘HazelPark480306399CDBG4/14/2005$18,095.0012/14/2021 $18,095.00$18,095.00 MortgageTotal TaxTotal OtherTotal$18,095.00 TOTALUNCOLLECTIBLES $18,095.00 *Chapter13Bankruptcycompletedwhichstrippedourloan| i4i:DATE:December22,2021 PREPAREDBY:i:C.gs‘é“aasvi>MadiWdroWIAfrShamekaDavenportoifoeTashawnaBurtonSupervisor Cf?2ae7.WaPUA DATE:December22,2021 LoanClosingOfficeri+0A/,i/soft&andlWanChBLASAPPROVEDBY: 118
OAKLANDCOUNTYPARKS&RECREATIONCOMMISSIONFY2022UncollectibleDebtWrite-offsOctober1,2021-December31,2021 Name(Last,First)OR~lastfourdigitsofcreditcard#TypeofDebtCaseNumber(ifcreditcard)DescriptionofRevenueOwed—{BudgetCenterTransactionDateOCBoCApprovalDate(if>$1000)Amount.MonthWritten-off 1385CreditCard712463051501WaterparkentryfeesRWP.09/10/21a51.0011/24 9739CreditCardORIGINALCASEWaterparkentryfeesRWP.08/18/21n/a34.0011/21 6124CreditCard812434205601WaterparkentryfeesRWP.09/03/2196.0011/21 4274CreditCard812523006401P15ADD09/14/21108.0011/21 9463CreditCard712573555801WaterparkentryfeesRWP09/16/21216.0011/21 1296CreditCard712543627601P56LYG09/16/2172.0011/21 4298CreditCard812573615101WaterparkentryfeesRWP09/17/21340.00)11/21 2042CreditCard812595020301WaterparkentryfeesRWP09/20/21136.0011/21 9101CreditCard712603265601WaterparkentryfeesRWP09/21/21102.0011/21 5939CreditCard712723323001WaterparkentryfeesRWP.10/01/21850.0011/21 9038CreditCard712500002701WaterparkentryfeesRWP10/06/2185.0011/21 9465CreditCard812530014701WaterparkentryfeesRWP10/08/2185.0011/21 0094CreditCard712560034101WaterparkentryfeesRWP10/13/21204.0011/21 1248CreditCard712560063101WaterparkentryfeesRWP.10/13/21833.0011/21 1248CreditCard812580035001WaterparkentryfeesRWP10/14/21272.0011/21 0550CreditCard712863566401WaterparkentryfeesRWP10/15/21680.00:11/21 9593CreditCard812620061901WaterparkentryfeesRWP10/19/21153.0011/21 OaklandCountyFiscalServicesPolicy:Ifitisdeterminedthatareceivableisuncollectible,thenamountsupto$1,000maybewrittenoffbyapprovalofthemanagerofFiscal Services.Allwrite-offsshallbeTotalreportedtotheBoardofCommissionerswiththequarterlyforecastreport.Write-offsinexcessof$1,000requireBoardofCommissioners’approval.Authorizedby: $4,317.00119
OaklandCountyFiecatSericasPoticyiitiethatariuncE .enupto$1000maybowatianoffbyepproveofthemanagerofFiecalSermcesAftwrite-offsshallboreportedtotheBoardofCommisaonerswiththequartedyforwcastreportWitleoffsinexcessof51,000requireBoardofCommissonesapproval ienireBani,MoosOTR FY2021HowthcersConrautom,UnodiecttsieSenefContbuicaAsrearbhgesPottSaparsiionProcessTeam3OKXXAWW(QTRibHumanResourcorBensiitsAdmingimtionOec-21]4 $763.74 TotsforQuarter4S76374 FY2O21HealthcareConrbutons,UncollectiteBenefitCanmbitionArresrege-PostSeperationProcessTermBOXXX34/2021(QTRZ)HumanResources/BenefitsAdminisiahooDec-21|2$5600 FYIO21HeafibcarsContrOutoreUncotecttieBenetCawdision|ArretragesPostSeperationProcamTermDEKKK282021(OTR2)HumanResourcesBenefitsAdmimstrehonOsc-2142$109.35 YotalforQuartet2:BIBSAG FY2021HeaiihcereCortrbutonsUnontectbisBenefContiwosAreurages-PostSeomatonProcessTermB2XXKOS16/2021(OTR3HumanResources/BenehitsAdministation$42.00) FY2021HealthcareConrtutonsUneotioctaieBenattConriitionArreaBges-PostSeaniationProcess.Tam_[22XKX08472021(OTRHumanReaources/BenofitsAdministrationDec-21}3$44694 FY2ONHewthearsConr@utions,UnoolectiieBanetkCothioutenArreoreges-PostSeparationProcess.YormBIXKX,BRYDAMOTR HumanResoutces/Benalits Adminstration $11083 TotaltocQusnar3:88977 FY2021HealthcarsConirbutonaUncollecthieBeneftContributesAsresrages-PostSeparetonProtas.Tom32KXX.OOO1/2021(QTR4)HumanReecurcanBenchisAdministrationDec-21}439885) FYZ025HeathcareConnt«torUnooliecableBeraftConrmuticn|Arrearegee-PostSepeatenProcesaTemJ2KXX__JOMIBZAW(QTR4yHumanRoepourcen/BonahitsAdministravonDec-2414__317273 FY2023HealthcareConuthutons.UneoliacthieBeneitConitutionArrearagea.PostSonaratonProcessTecm2BXXKBNO22710TR4HumanResources/BenefiteAgmintsirationDer214__B4148 FYZ02tHealthcareConrutiocsUnodiiecthisBeneflConttitionAsramregea-PoaSeparatonProcessTerm27KXKBr2021(QTR4) HumanRevourcesBenohis Administration Meo2th $344 HieBeieiL:bsAuttigarodby"eePS‘TotalforQuartier4 TotalforFY2024::Geyrerviswe$79839,£4,059.19120