Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Resolutions - 2021.09.29 - 34880
• BOARD OF COMMISSIONERS September 29, 2021 MISCELLANEOUS RESOLUTION #21-366 Sponsored By: Gwen Markham IN RE: Fiscal Year 2021 Third Quarter Financial Forecast And Budget Amendments Chairperson and Members of the Board: WHEREAS Public Act 621 of 4978, the Uniform Budgeting and Accounting Act for Local Units of Government, provides for adjustments to the adopted budget; and WHEREAS in accordance with Oakland County General Appropriations Act Section 22, which authorizes budget amendments for variances between the budgeted revenue and actual revenue, and Section 23, which authorizes budget amendments for variance between estimated revenue and projected expenditures, amendments are required; and WHEREAS the Fiscal Year (FY) 2021 Third Quarter Financial Forecast Report has identified several variances, and budget amendments are recommended; and WHEREAS a FY 2021 budget amendment totaling $32,000 is reconunended to reallocate funding from the Circuit Court General Jurisdiction Civil Mediation Payments account (10100-3010301421150-240201), with $22,000 to Judicial Administration's Expendable Equipment expense account to partially offset the expenditures for the replacement of furniture forjudicial chambers and $10,000 to the Judicial Administration's Professional Services expense account for the payment to the Oakland County Bar Association related to their assistance for case evaluation and Bench/Bar programs; and WHEREAS a FY 2021 budget amendment of $1,583 is recommended for the Circuit Court Civil Criminal Division to reallocate funding from the Office Supplies expenditure line item (Account 750399) to the Info Tech Operations expenditure line item (Account 774636) to fund the purchase of a new Developer Laptop; and WHEREAS a FY 2021 budget amendment is recommended for 52/1 Novi District Court correcting an entry referenced in M.R. 421019 52/1 Novi District Court -FY 2021 Michigan Drug Court Grant Program Acceptance in which the one-time request for use of Nun -Department Grant Match in the amount of $9,405 was not needed. The Grant Match was allocated between Salaries, Fringe Benefits and Contracted Services; and WHEREAS a FY 2021 budget amendment is recommended for 52/1 Novi District Court to recognize Amendment It to the FY 2021 Michigan Drug Court Grant Program (MDCGP) agreement which increases the award amount from $78,500 to $88,500 and allocates the additional funding of $10,000 to 52/1 (Novi) District Court's Drug Court Probation Fund (#27151) Special Revenue budget. Amendment #1 is within fifteen percent of the original award (MR. #21019); and WHEREAS the Sheriffs Office receipts 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 amount of $248,148 is being recognized for eligible personnel, forensic lab, and training costs for dispatchers and corrections officers; and WHEREAS a FY 2021 budget amendment of $7 is recommended for the Sheriffs Office to recognize a donation to be used for Deputy Supplies (Account 750070); and WHEREAS a FY 2021 budget amendment of $1 1,114 is recommended for the Sheriffs Office to recognize receipt of additional Public Safety Public Health Payroll Reimbursement (PSPHPR) funding for eligible contracted payroll costs. The amendment is within fifteen percent of the original award (M.R. 20439); and WHEREAS budget amendments for FY 2021 of $7,44 1 (prorated) and FY 2022 - FY 2024 of $30,245 are recormnended for the Sheriffs Office, reallocating the Rent budget (Account 731626) between departments as the Emergency Management and Homeland Security Department as well as the Health Division have relocated to a larger facility to warehouse their personal protection equipment (PPE) as it relates to the COVID-19 pandemic and other County emergency needs. The current facility will store Sheriff marine equipment; and WHEREAS a FY 2021 budget amendment of $13,309 is recommended for the Board of Commissioners (BOC) to reallocate funds from expenditure line -item Computer Research Service (Account 730338) to Internal Services expenditure line item 1T Operations (Account 774636) to purchase mobile laptops/docking stations to efficiently transition into their hybrid remote workplaces; and WHEREAS a FY 2021 budget amendment totaling $2,350 is recommended for the Animal Control Division to accept reimbursement funding of $1,450 from the December 9, 2020 — December 11, 2020 Bisset Pet Foundation's Empty the Shelter Event and $900 from the May 5, 2021 - May 9, 2021 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 date correction is recommended relating to the budget amendment that was included in the First Quarter Financial Forecast and Budget Amendment (M.R. #21091) which accepted reimbursement funding of $2,650 from the Bissel Pet Foundation's Empty the Shelter event. The dates referenced in M.R. #21091, December 9, 2020- December 11, 2020 were reflected in error and should have reflected the Bissel Pet Foundation's Empty the Shelter event as October 1, 2020 - October 2, 2020. A budget amendment is not required; and WHEREAS a FY 2021 budget amendment totaling $159,902 is reconmtended for the Veteran's Services Administration Division (1090401) to reallocate the budget from Salaries and Fringe Benefits to cover the costs of contracted services for outreach projects due to vacancies within the Division; and WHEREAS a FY 2021 budget amendment of $1,412 is recommended for the Emergency Management Division reallocating the budget for Maintenance Department Charges (Account 775754) as it was budgeted in error to the former Homeland Security Division (1060601) as homeland Security was retitled and became a County Executive Department (M.R. #20461); and WHEREAS a FY 2021 budget amendment totaling $35,221 is recommended for Emergency Management and Homeland Security to reallocate $27,196 from the Department and Health and Human Services Homeland Security Division, as the Division was transferred to Emergency Management. (M.R. 420461). Also, to accept grant funding in the amount of $8,025 for the FY2020-21 Hazardous Materials Emergency Preparedness (HMEP) Planning Program. Miscellaneous Resolution (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 2021 budget amendment is recommended to transfer funding in the amount of $34,803 from the Department of Public Communications to the Project Work Order Fund (#40400) for the replacement of conference center shades; and WHEREAS a budget amendment of $6,815,307 (FY 2021), $1,731,085 (FY 2022) and $1,041,385 (FY 2023) is recommended for the estimated impact of Voluntary Employee Separation Incentive Program (VESIP) and VESIP Schedule C Incentive Pay (separation incentive) which includes Incentive Pay and associated Fringe Benefits; and WHEREAS a FY 2021 budget amendment is recommended for the 52/2 (Clarkston) District Court to reallocate a total of $860 comprised of $610 from Travel and Conference (Account 732018) along with $250 from Incentives (Account 750245) to Drug Testing (Account 730458) to reflect Amendment #1 which is less than fifteen percent of the original award (MR. #21091 Management and Budget — Fiscal Year 2021 First Quarter Financial Forecast and Budget Amendments). The FY 2021 Michigan Drug Court Grant Program Acceptance was administratively approved through M.R. #21091 as the award was less than $10,000; and WHEREAS a FY 2021 budget amendment is recommended for the 52/3 (Rochester) District Court to reallocate funding in the amount of $1,805 from Drug Testing (Account 730458) of which $1,500 is reallocated to Special Event Program (Account 731818) and $305 is reallocated to Travel and Conference expenditure (Account 732018) to reflect a more accurate budget to actual under the FY 2021 Michigan Drug Court Grant Program agreement (MR. #20643); and WHEREAS a FY 2021 budget amendment totaling $658,110 is recommended for the Sheriffs Office special revenue fund Secondary Road Patrol (#27345) correcting the budgets from M.R. #20460 Sheriff s Office — FY 2021 Secondary Road Patrol Grant Acceptance and M.R. #20650 — Sheriff s Office — FY 2021 Secondary Road Patrol Grant Amendment Greater than 15%. The budget amendment reallocates the funds from grant project ID #GR0000000142 to grant project ID 4GR0000000981 as the FY 2021 award budget was inadvertently budgeted to the grant project relating to the FY 2020 award. There is no financial impact to the total FY 2021 grant award; and WHEREAS a FY 2021 budget amendment totaling $125,594 is recommended for the Health Division to recognize adjustments to the FY 2024 Fiscal Year 2021 Local Health Department (Comprehensive) Agreement to reflect Amendment #4, which is less than fifteen percent of the original agreement (MR. #20459); and WHEREAS the FY 2020 Nutrition and Healthy Lifestyles Grant/Prescription for a Healthy Pontiac (MR. #20118) was modified to reflect Amendment 41, which extends the reimbursement agreement end date from July 16, 2021, to August 8, 2022; a budget amendment is not required; and WHEREAS a FY 2021 budget amendment totaling $648,898 is recormnended for the Business Finance Corporation (BFC) Personnel Fund (421184) reallocating the budgets from Economic Development's Planning and Local Development Division (1090202) and Business Development Administration Division (1090301) to the Financial Services Division (1090305) as M.R.# 20462 Economic Development and Community Affairs — Reorganization of Divisions and Positions reallocated the budget in error to the incorrect divisions; and WHEREAS a Michigan Indigent Defense Commission (MIDC) Approved FY 2021 Budget Adjustment (Budget Adjustment #5) of $39,368 is recommended to reallocate the budgets from Expert Witness Fees and Mileage expenditure line item (Account 730688) to Professional Services expenditure line item (Account 731458) for 25% of the cost of the Public Defender Feasibility Study to be started in the last quarter of 2021. The remainder of the cost will occur in FY 2022 and will be included in the FY 2022 budget via a separate resolution; and WHEREAS a FY 2021 budget amendment totaling $43,000 is recommended to reallocate funds for the Community Corrections Special Revenue Fund (#27370) line items causing no impact to the total amount of funding for the FY 2021 Michigan Department of Corrections Comprehensive Corrections Plan; Amendment 11 is wuhin 1 5'!'� of Original Agreement authorized by M.R. #21022; and WHEREAS a FY 2021 budget amendment of $21,750 is recommended for the Radio Communications fund (#53600) to realign the budget between Planned Use of Balance (Account 665882) and Budgeted Equity Adjustment (Account 796500) to balance the fund; and WHEREAS a FY 2021 budget amendment totaling ($418,698) is recommended for the Parks and Recreation Fund (450800) to adjust revenues for the closure of Waterford Oaks Waterpark and Concessions ($491,500), to adjust for net sale of equipment and vehicles ($20,566) and unfavorable Investment Income ($20,000). Also, to adjust Delinquent Tax Prior Years and Property Tax Levy to reflect the current trend of delinquent tax revenue. Partially offset to reflect additional funds from the State of Michigan for the Local Community Stabilization Share $78,989, adjust Temporary Licenses for Holly Oaks Recreational Vehicle (RV) $23,500, adjust BMX revenue $3,379 for recent activity, and to accept $7,500 from the US Forest Service for the Reducing Runoff in the Rouge River Area of Concern (AOC) Grant. The funds will be used for plantings at Glen Oaks Golf Course to help curb stormwater runoff in the area. Additional adjustments are for expenses which include the closure of Waterford Oaks Waterpark and Concessions ($470,100), adjustment for Equipment and Ground Maintenance needed at Holly Oaks RV Park relative to excessive rainfall $91,107, Refund Prior Years Revenue $35,600 due to cancelled events in FY 2021 that were paid in FY 2020, adjust Contracted Services to reflect a new contract for sponsorship sales and management at the Holly Oaks RV Park $13,000, Adj Prior Years Exp for miscellaneous items $3,390, and to adjust the expense account Budgeted Equity Adjustments ($91,695) to offset recommended revenue budget amendments; and WHEREAS the Board of Commissioners authorized the creation of the Public Communications Department and reorganized positions between departments on August 5, 2021 (MR. #21323). The financial impact for FY 2021 GF/GP budget is $301,795 (prorated) and FY 2022 —FY 2024 is $730,714. The resolution also approved four (4) Special Revenue (SR) positions. The funding for the SR positions FY 2021 $48,399 (prorated) and FY 2022-FY 2024 $360,596 will be supported by the American Rescue Plan (ARP) Act Local Fiscal Recovery. The SR positions will sunset on December 31, 2024, which is based on the current known timeframe of the ARP Act Local Fiscal Recovery Act funding. In addition, $1,000,000 will be reallocated from the Emergency Management and Homeland Security Department's Public Information expenditure line item (Account 731500) to various line items within the Department's operating expenditure line -item budget; and WHEREAS the Department of Health and Human Services Health Division has requested write-offs in the amount of $33,153.58 for the period of October 2020 through June 2021 for rmcollectible transactions; and WHEREAS the Department of Public Services, Animal Shelter and Pet Adoption Center received donations for the period of April 2021 through June 2021 totaling $13,040.15; and WHEREAS the Department of Health and Human Services, Children's Village Division received donations for the period of April 2021 through June 2021 totaling $10,4 87.94 of which $2,100 was a cash donation; and WHEREAS the Parks and Recreation Commission received donations for the period of April 2021 through June 2021 totaling $2,095.00; and WHEREAS the Department of Health and Human Services Health Division received a donation for the period of April 2021 through June 2021 in the amount of $15.00. NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners accepts the Fiscal Year 2021 Third Quarter Financial Report. BE IT FURTHER RESOLVED that $32,000 be transferred in FY 2021 from the Circuit Court General Jurisdiction Civil Mediation Payments account (10100-3010301-121150-240201) to the following: $22,000 to judicial Adnnisnation's Expendable Equipment expense account to partially offset the expenditure, for the replacement of furniture forjudicial chambers and $10,000 to the Judicial Administration's Professional Services expense account for the payment to the Oakland County Bar Association related to their assistance for case evaluation and Bench[Bar programs. GENERAL FUND 010100) FY 2021 Revenue 3010301-121 t 50-630245 Circuit Court Gen Jury —Civil Mediation Payments $32,000 Total Revenue $32,000 Expenditures 3010101-121100-750154 Circuit Court Jud Admin Expendable Equip. $22,000 3010101-121100-731458 Professional Services 10,000 Total Expenditures $32,000 BE IT FURTHER RESOLVED that the uncollectible debts, as reconnnended by the Department of Management and Budget and detailed in the attached schedules, are authorized to be written off. BE IT FURTHER RESOLVED that the donations be recognized in the Animal Shelter and Pet Adoption Center, Children's Village Division, Parks and Recreation Commission, JIealth Division, and Sheriffs Office. BE 1T FURTHER RESOLVED that the FY 2021 - FY 2024 Budgets are amended pursuant to Schedules A, B, and C. Chairperson, the following Commissioners are sponsoring the foregoing Resolution: Gwen Markham. � dou a WMM1� Date: October 05, 2021 Hilarie Chambers, Deputy County Executive II 1( Date: October 07. 2021 Lisa Brown, County Clerk / Register of Deeds COMMITTEE TRACKING 2021-09-15 Finance - Recommend to Board 2021-09-29 Full Board VOTE TRACKING Motioned by Commissioner Yolanda Smith Charles seconded by Commissioner Penny Luebs to adopt the attached Budget Amendment: Fiscal Year 2021 Third Quarter Financial Forecast And Budget Amendments. Yes: David Woodward, Michael Gingell, Michael Spisz, Karen Joliat, Kristen Nelson, Eileen Kowall, Christine Long, Philip Weipert, Gwen Markham, Angela Powell, Thomas Kuhn, Charles Moss, Marcia Gershenson, William Miller III, Yolanda Smith Charles, Charles Cavell, Penny Luebs, Janet Jackson, Gary McGillivray, Robert Hoffman (20) No: None (0) Abstain: None (0) /`'bsent: (0) The Motion Passed. ATTACHMENTS FY 2021 3rd Qtr Financial Report and Budget Amendments STATE OF MICHIGAN) COUNTY OF OAKLAND) I, Lisa Brown, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true and accurate copy of a resolution adopted by the Oakland County Board of Commissioners on September 29, 2021, with the original record thereof now remaining in my office. In Testimony Whereof, I have hereunto set my hand and affixed the seal of the Circuit Court at Pontiac, Michigan on Wednesday, September 29, 2021. Lisa Brown, Oakland Coniq Clerk /Register oj'Dceds OAKLAND COUNTY EXECUTIVE DAVID COULTER TO: Members of the Finance Committee FROM: Kyle Jen, Director, Management and Budget Lynn Sonkiss, Manager, Fiscal Services Holly Conforti, Chief, Fiscal Services Ebru Adoglu-Jones, Supervisor of Fiscal Services SUBJECT: Letter of Transmittal - Fiscal Year 2021 Third Quarter Forecast DATE: September 15, 2021 FY 2021 THIRD QUARTER REPORT Attached please find the Fiscal Year (FY) 2021 Third Quarter Forecast Report. In total, Fiscal Services forecasts that the County will complete FY 2021 with an overall favorable variance of $42,026,047 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 $359,221 more revenue than anticipated and projected favorability in expenditures of $41,666,826. Accounting for adopted resolutions funded by Use of Fund Balance, this forecast projects that the General Fund balance will decrease by $2.9 million by the end of Fiscal Year 2021. REVENUES GF/GP revenues are 0.06% more than budget or $359,221. Major variances are the result of the following events: A. TAXES — Favorable: $450,000 Favorable Payment in Lieu of Taxes that reflects actual activity for payments from the State on Department of Natural Resources (DNR) land $250,000, and favorable Delinquent Tax — Prior Years $200,000 due to collection of previous years taxes. B. FEDERAL GRANTS — Unfavorable: ($135,000) Unfavorable due to decrease in Children's Village School Lunch program serving less due to decline in resident population. C. STATE GRANTS — Unfavorable: ($2,000,000) Unfavorable primarily due to less than anticipated reimbursement from the State on eligible childcare costs; offset by Child Care Fund expenditure favorability. D. OTHER INTERGOVNERMENTAL REVENUE — Favorable: $1,384,050 Favorable primarily due to excess Local Community Stabilization Share (personal property tax loss) distribution that was received from the State of $1,404,500 which is offset by the net difference between the budgeted amount and State's updated Revenue Sharing of ($50,000). E. CHARGES FOR SERVICES — Unfavorable: ($950,429) Unfavorable Ordinance Fines and Costs ($2,425,000), Probation Fees ($725,000) and State Law Costs ($125,000) across the District Courts for the reduction in caseloads due to 2100 Pontiac Lake Road I County Executive Building 41 W I Waterford, MI 48328 1 Fax (248) 452-9172 1 OakGov.com 1 marijuana legalization (making it a civil infraction), change in legislation, and COVID-19 pandemic; Sheriff's Office ($920,000) Diverted Felon, ($900,000) Drug Testing, ($800,000) Reimbursement Salaries, ($335,000) Commissions Contracts, ($190,000) Civil Action Service Fees, ($140,000) Fingerprints due to reduced activity; which is primarily due to the pandemic. Further reductions in activity due to the COVID-19 pandemic include Payments Other Than Anticipated ($900,000) due to no land sale activity for Treasurer's Office; Court Costs ($375,000), Mediation Fees ($200,000), and ($175,000) Jury Fees due to less than anticipated revenue within Circuit Court; ($400,000) Immunizations, ($200,000) Inspection Fees, ($100,000) Clinic Charges within Health and Human Services; ($293,000) Sale of Licenses projected for Animal Control; and ($140,000) Community Corrections Fee Income due to suspension of the Weekend and Weekday Alternative for Misdemeanants (WWAM) program. This is partially offset by favorable Clerk's Office $3,200,000 Land Transfer Tax, $2,000,000 Recording Fees, and Mortgages $500,000 due to increased activity; favorable Children's Village $2,200,000 Out County Board and Care and $400,000 Board and Care due to the Department of Health and Human Services placements. OTHER REVENUES — Favorable: $1,564,395 Favorable primarily due to $891,895 in Children's Village for payment from the state for FY 2020 childcare activity; $450,000 Clerk's — Elections due to prior year adjustment as State paid for Absent Voter County Board equipment; $100,000 Treasurer's Transfer In due to collection of delinquent taxes higher than anticipated. EXPENDITURES In total, expenditures are projected to be 6.53% under budget or $41,666,826 favorable. This amount is the net result of amending the budget to account for $6.8 million in General Fund costs for the Voluntary Employee Separation Incentive Program the County offered to its employees earlier this year and $48.8 million in net favorability across the budget. Many departments have experienced personnel savings due to turnover and under -filling of positions, resulting in a projected $22.4 million in total personnel favorability across all departments. Favorability from departments continuing to work to reduce their operating costs and other factors total $26.4 million, including $8 million from utilizing available federal funds in place of County General Fund revenue for pandemic response costs and $14.7 million in utilization of CARES Act funds for eligible public safety and public health personnel costs, including some costs incurred during FY 2020. There are two departments projected to be unfavorable at the end of the fiscal year (barring any amendments); Economic Development and Emergency Management and Homeland Security. Economic Development — Unfavorable: ($157,600) • The department is forecasted to be slightly unfavorable due to overall operational variances due to COVID-19 pandemic. No budget amendment is required at this time. 2100 Pontiac Lake Road i County Executive Building 41 W I Waterford, MI 48328 1 Fax (248) 452-9172 1 oakGov COm 2 Emergency Management and Homeland Security — Unfavorable: ($175,400) • The department is forecasted to be unfavorable primarily due to an increase in Overtime, On - call, and Professional Services due to COVID-19 response. These costs are expected to be reimbursed by FEMA. No budget amendment is required at this time. Note that while some individual divisions may be over budget, the budget is controlled at the department level. The General Appropriations Act requires that appropriations accumulate at the following three summary levels of expenditures within each County Department and are deemed maximum authorization for expenditures: Personnel Expenditures, Operating Expenditures, and Internal Support Expenditures. Required Renortinct Adiustments The Quarterly Forecast presents the County's financial position in relation to the amended budget (Budget perspective). This form of presentation is used so that users of this forecast can assess the true financial impact of County operations in comparison to the budget for the current fiscal year. However, it is important to note that this presentation style does not fully coincide with the accounting requirements of audited financial statements produced by the County. The County's financial statements are required to follow Generally Accepted Accounting Principles or GAAP. Forecast Presentation — Budgetary Perspective The presentation reflects the current best assessment of fiscal activity for FY 2021: Revenues - over/ (under) budget Expenditures — (over)/under budget Total Officially Reported Favorability $ 359,221 41,666,826 $42 026 047 GAAP Required Reporting Method Under GAAP, the Planned Use of Fund Balance is removed as a `revenue' source. The amended revenue budget assumes the use of $44,880,738 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 2021 adopted budget for the Planned Use of Fund Balance started out at $609,338 and there have been resolutions authorized during FY 2021 to bring it to the $44,880,738 level as of June 30, 2021. This includes approximately $14.1 million of carry forward requests that were approved with the FY 2020 Year End Report resolution (M.R. #20635). Also included in the use of fund balance are adopted resolutions containing one-time expenditures amounts for pandemic related funding, Radio System project investments, Financial and Human Capital Management system implementation project, Community Policing Innovations project, Strategic Planning and Equity Audit project, Restaurant Relief program funding, Human Resource Salary Administration Plan, Local Road Improvement program, and Tri-Party road projects. The equity section of the contingency packet contains a comprehensive summary of all the authorized resolutions. 2100 Pontiac Lake Road i County Executive Building 41 W i Waterford, MI 48328 1 Fax (248) 452-9172 1 OakGov.com 3 Thus, when Use of Fund Balance is removed from the revenue calculation, the impact on the County's official financial statements is: Revenue Variance $ 359,221 Reduce — Planned use of Fund Balance (44,880,738) Revenue Variance $(44,521,517) Expenditure Variance (Comparing Actual to Approved Plan) 41,666,826 GAAP Reported Effect on Fund Balance / 9 R54_691) It is important to analyze the forecast using both the Budget perspective and the GAAP perspective to accurately reflect the impact of fiscal activity generated from FY 2021 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 $2.9 million by the end of Fiscal Year 2021. It should be noted while the amended budget reflects the utilization of $44.9 million of Fund Balance, this forecast projects the use of Fund Balance ultimately needed to support FY 2021 activities will be $2.9 million, $42.0 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 subsequent funding opportunities provided by the federal or state resources will be leveraged to address the impact. 2100 Pontiac Lake Road i County Executive Building 41 W i Waterford, MI 48328 1 Fax (248) 452-9172 1 OakGov cOm 4 MISCELLANEOUS RESOLUTION #21XXX BY: Commissioner Gwen Markham, Chairperson, Finance Committee IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2021 THIRD QUARTER FINANCIAL FORECAST AND BUDGET AMENDMENTS To the Oakland County Board of Commissioners Chairperson, Ladies and Gentlemen: WHEREAS Public Act 621 of 1978, the Uniform Budgeting and Accounting Act for Local Units of Government, provides for adjustments to the adopted budget; and WHEREAS in accordance with Oakland County General Appropriations Act Section 22, which authorizes budget amendments for variances between the budgeted revenue and actual revenue, and Section 23, which authorizes budget amendments for variance between estimated revenue and projected expenditures, amendments are required; and WHEREAS the Fiscal Year (FY) 2021 Third Quarter Financial Forecast Report has identified several variances and budget amendments are recommended, and WHEREAS a FY 2021 budget amendment totaling $32,000 is recommended to reallocate funding from the Circuit Court General Jurisdiction Civil . Mediation Payments account (10100-3010301-121150- 240201), with $22,000 to Judicial Administration's Expendable Equipment expense account to partially offset the expenditures for the replacement of furniture for judicial chambers and $10,000 to the Judicial Administration's Professional Services expense account for the payment to the Oakland County Bar Association related to their assistance for case evaluation and Bench/Bar programs; and WHEREAS a FY 2021 budget amendment of $1,583 is recommended for the Circuit Court Civil Criminal Division to reallocate funding from the Office Supplies expenditure line item (Account 750399) to the Info Tech Operations expenditure line item (Account 774636) to fund the purchase of a new Developer Laptop; and WHEREAS a FY 2021 budget amendment is recommended for 52/1 Novi District Court correcting an entry referenced in M.R. #21019 52/1 Novi District Court -FY 2021 Michigan Drug Court Grant Program Acceptance in which the one-time request for use of Non -Department Grant Match in the amount of $9,405 was not needed. The Grant Match was allocated between Salaries, Fringe Benefits and Contracted Services; and WHEREAS a FY 2021 budget amendment is recommended for 52/1 Novi District Court to recognize Amendment #1 to the FY 2021 Michigan Drug Court Grant Program (MDCGP) agreement which increases the award amount from $78,500 to $88,500 and allocates the additional funding of $10,000 to 52/1 (Novi) District Court's Drug Court Probation Fund (#27151) Special Revenue budget. Amendment #1 is within fifteen percent of the original award (M.R. #21019); 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 amount of $248,148 is being recognized for eligible personnel, forensic lab, and training costs for dispatchers and corrections officers; and WHEREAS a FY 2021 budget amendment of $7 is recommended for the Sheriffs Office to recognize a donation to be used for Deputy Supplies (Account 750070); and WHEREAS a FY 2021 budget amendment of $11,114 is recommended for the Sheriffs Office to recognize receipt of additional Public Safety Public Health Payroll Reimbursement (PSPHPR) funding for eligible contracted payroll costs. The amendment is within fifteen percent of the original award (M.R. 20439); and WHEREAS budget amendments for FY 2021 of $7,441(prorated) and FY 2022 - FY 2024 of $30,245 are recommended for the Sheriffs Office, reallocating the Rent budget (Account 731626) between departments as the Emergency Management and Homeland Security department as well as the Health Division have relocated to a larger facility to warehouse their personal protection equipment (PPE) as it relates to the COVID-19 pandemic and other county emergency needs. The current facility will store Sheriff marine equipment; and WHEREAS a FY 2021 budget amendment of $13,308 is recommended for the Board of Commissioners (BOC) to reallocate funds from expenditure line -item Computer Research Service (Account 730338) to Internal Services expenditure line item IT Operations (Account 774636) to purchase mobile laptops/docking stations to efficiently transition into their hybrid remote workplaces; and WHEREAS a FY 2021 budget amendment totaling $2,350 is recommended for the Animal Control Division to accept reimbursement funding of $1,450 from the December 9, 2020 — December 11, 2020 Bissel Pet Foundation's Empty the Shelter Event and $900 from the May 5, 2021 - May 9, 2021 Bisset 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 date correction is recommended relating to the budget amendment that was included in the First Quarter Financial Forecast and Budget Amendment (M.R. #21091) which accepted reimbursement funding of $2,650 from Bissel Pet Foundation's Empty the Shelter event. The dates referenced in M.R. #21091, December 9, 2020- December 11, 2020 were reflected in error and should have reflected the Bissel Pet Foundation's Empty the Shelter event as October 1, 2020 - October 2, 2020. A budget amendment is not required; and WHEREAS a FY 2021 budget amendment totaling $159,902 is recommended for the Veteran's Services Administration division (1090401) to reallocate the budget from Salaries and Fringe Benefits to cover the costs of a contracted services for outreach projects due to vacancies within the division; and WHEREAS a FY 2021 budget amendment of $1,412 is recommended for the Emergency Management Division reallocating the budget for Maintenance Department Charges (Account 775754) as it was budgeted in error to the former Homeland Security division (1060601) as Homeland Security was retitled and became a County Executive Department (M.R. #20461); and WHEREAS a FY 2021 budget amendment totaling $35,221 is recommended for the Emergency Management and Homeland Security to reallocate $27,196 from the Department and Health and Human Services Homeland Security division as the division was transferred to Emergency Management, (M.R. #20461). Also, to accept grant funding in the amount of $8,025 for the FY2020-21 Hazardous Materials Emergency Preparedness (HMEP) Planning Program. Miscellaneous Resolution (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 2021 budget amendment is recommended to transfer funding in the amount of $34,803 from the Department of Public Communications to the Project Work Order Fund (#40400) for the replacement of conference center shades; and WHEREAS a budget amendment of $6,815,307 (FY 2021), $1,731,085 (FY 2022) and $1,041,385 (FY 2023) is recommended for the estimated impact of Voluntary Employee Separation Incentive Program (VESIP) and VESIP Schedule C Incentive Pay (separation incentive) which includes Incentive Pay and associated Fringe Benefits; and WHEREAS a FY 2021 budget amendment is recommended for the 52/2 (Clarkston) District Court to reallocate a total of $860 comprised of $610 from Travel and Conference (Account 732018) along with $250 from Incentives (Account 750245) to Drug Testing (Account 730458) to reflect Amendment #1 which is less than fifteen percent of the original award (M.R. #21091 Management and Budget — Fiscal Year 2021 First Quarter Financial Forecast and Budget Amendments). The FY 2021 Michigan Drug Court Grant Program Acceptance was administratively approved through M.R. #21091 as the award was less than $10,000- and WHEREAS a FY 2021 budget amendment is recommended for the 52/3 (Rochester) District Court to reallocate funding in the amount of $1,805 from Drug Testing (Account 730458) of which $1,500 is reallocated to Special Event Program (Account 731818) and $305 is reallocated to Travel and Conference expenditure (Account 732018) to reflect a more accurate budget to actual under the FY 2021 Michigan Drug Court Grant Program agreement (M.R. #20643); and WHEREAS a FY 2021 budget amendment totaling $658,110 is recommended for the Sheriffs Office special revenue fund Secondary Road Patrol (#27345) correcting the budgets from M.R. #20460 Sheriffs Office — FY 2021 Secondary Road Patrol Grant Acceptance and M.R. #20650 — Sherifrs Office — FY 2021 Secondary Road Patrol Grant Amendment Greater than 15%. The budget amendment reallocates the funds from grant project id number #GR0000000142 to grant project id #GR0000000981 as the FY C 2021 award budget was inadvertently budgeted to the grant project relating to the FY 2020 award. There is no financial impact to the total FY 2021 grant award; and WHEREAS a FY 2021 budget amendment totaling $125,594 is recommended for the Health Division to recognize adjustments to the FY 2021 Fiscal Year 2021 Local Health Department (Comprehensive) Agreement to reflect Amendment #4 which is less than fifteen percent of the original agreement (M.R. #20459); and WHEREAS the FY 2020 Nutrition and Healthy Lifestyles Grant/Prescription for a Healthy Pontiac (M.R. #20118) was modified to reflect Amendment #1 which extends the reimbursement agreement end date from July 16, 2021 to August 8, 2022; a budget amendment is not required; and WHEREAS a FY 2021 budget amendment totaling $648,898 is recommended for the Business Finance Corporation (BFC) Personnel Fund (#21184) reallocating the budgets from Economic Development's Planning and Local Development division (1090202) and Business Development Administration division (1090301) to the Financial Services division (1090305) as M.R.# 20462 Economic Development and Community Affairs — Reorganization of Divisions and Positions reallocated the budget in error to the incorrect divisions; and WHEREAS a Michigan Indigent Defense Commission (MIDC) Approved FY 2021 Budget Adjustment (Budget Adjustment #5) of $39,368 is recommended to reallocate the budgets from Expert Witness Fees and Mileage expenditure line item (Account 730688) to Professional Services expenditure line item (Account 731458) for 25% of the cost of the Public Defender Feasibility Study to be started in the last quarter of 2021. The remainder of the cost will occur in FY 2022 and will be included in the FY 2022 budget via a separate resolution; and WHEREAS a FY 2021 budget amendment totaling $43,000 is recommended to reallocate funds for Community Corrections Special Revenue fund (#27370) line items causing no impact to the total amount of funding for the FY 2021 Michigan Department of Corrections Comprehensive Corrections Plan; Amendment #1 is within 15% of Original Agreement authorized by M.R. #21022; and WHEREAS a FY 2021 budget amendment of $21,750 is recommended for the Radio Communications fund (#53600) to realign the budget between Planned Use of Balance (Account 665882) and Budgeted Equity Adjustment (Account 796500) to balance the fund; and WHEREAS a FY 2021 budget amendment totaling ($418,698) is recommended for Parks and Recreation Fund (#50800) to adjust revenues for the closure of Waterford Oaks Waterpark and Concessions ($491,500), to adjust for net sale of equipment and vehicles ($20,566) and unfavorable Investment Income ($20,000). Also, to adjust Delinquent Tax Prior Years and Property Tax Levy to reflecting current trend of delinquent tax revenue. Partially offset to reflect additional funds from the State of Michigan for the Local Community Stabilization Share $78,989, adjust Temporary Licenses for Holly Oaks Recreational Vehicle (RV) $23,500, adjust BMX revenue $3,379 for recent activity, and to accept $7,500 from the US Forest Service for the Reducing Runoff in the Rouge River Area of Concern (AOC) Grant. The funds will be used for plantings at Glen Oaks Golf Course to help curb stormwater runoff in the area. Additional adjustments are for expenses which include the closure of Waterford Oaks Waterpark and Concessions ($470,100), adjustment for Equipment and Ground Maintenance needed at Holly Oaks RV park relative to excessive rainfall $91,107, Refund Prior Years Revenue $35,600 due to cancelled events in FY 2021 that were paid in FY 2020, adjust Contracted Services to reflect a new contract for sponsorship sales and management at the Holly Oaks RV park $13,000, Adj Prior Years Exp for miscellaneous items $3,390, and to adjust the expense account Budgeted Equity Adjustments ($91,695) to offset recommended revenue budget amendments; and WHEREAS the Board of Commissioners authorized the creation of the Public Communications Department and reorganized positions between departments on August 5, 2021 (M.R. #21323). The financial impact for FY 2021 GF/GP budget is $301,795 (prorated) and FY 2022 — FY 2024 is $730,714. The resolution also approved four (4) Special Revenue (SR) positions. The funding for the SR positions FY 2021 $48,399 (prorated) and FY 2022- FY 2024 $360,596 will be supported by the American Rescue Plan (ARP) Act Local Fiscal Recovery. The SR positions will sunset on December 31, 2024, which is based on the current known timeframe of the ARP Act Local Fiscal Recovery Act funding. In addition, $1,000,000 will be reallocated from Emergency Management and Homeland Security department's Public Information expenditure line item (Account 731500) to various line items within the department's operating expenditure line -item budget; and 0 WHEREAS the Department of Health and Human Services Health Division has requested write-offs in the amount of $33,153.58 for the period of October 2020 through June 2021 for uncollectible transactions; and WHEREAS the Department of Public Services, Animal Shelter and Pet Adoption Center received donations for the period of April 2021 through June 2021 totaling $13,040.15; and WHEREAS Department of Health and Human Services, Children's Village Division received donations for the period of April 2021 through June 2021 totaling $10,187.94 of which $2,100 was a cash donation; and WHEREAS Parks and Recreation Commission received donations for the period of April 2021 through June 2021 totaling $2,095.00; and WHEREAS Department of Health Human Services Health Division received a donation for the period of April 2021 through June 2021 in the amount of $15.00. NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year 2021 Third Quarter Financial Report. BE IT FURTHER RESOLVED that $32,000 be transferred in FY 2021 from the Circuit Court General Jurisdiction Civil Mediation Payments account (10100-3010301-121150-240201) to the following: $22,000 to Judicial Administration's Expendable Equipment expense account to partially offset the expenditures for the replacement of furniture for judicial chambers and $10,000 to the Judicial Administration's Professional Services expense account for the payment to the Oakland County Bar Association related to their assistance for case evaluation and Bench/Bar programs. GENERAL FUND (#10100) Revenue 3010301-121150-630245 Circuit Court Gen Jury — Civil Mediation Payments Total Revenue Expenditures 3010101-121100-750154 3010101-121100-731458 FY 2021 $32 000 32 000 Circuit Court Jud Admin — Expendable Equip. $22,000 Professional Services 10,000 Total Expenditures 32,000 BE IT FURTHER RESOLVED that the uncollectible debts, as recommended by the Department of Management and Budget and detailed in the attached schedules are authorized to be written off. BE IT FURTHER RESOLVED that the donations be recognized in the Animal Shelter and Pet Adoption Center, Children's Village Division, Parks and Recreation Commission, Health Division, and Sheriffs Office. BE IT FURTHER RESOLVED that the FY 2021 — FY 2024 Budgets are amended pursuant to Schedules A, B and C. Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution. Commissioner Gwen Markham, District #9 Chairperson, Finance Committee E? OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) JGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#101001 Dept Program CIRCUIT COURT Expenditures 3010301 121130 3010301 121130 Acct Fund Aff. Op Unit Account Name 750399 Office Supplies 774636 Info Tech Operations Total Expenditures 5211 DISTRICT COURT (NOVI) Expenditures 9090101 196030 730800 9010101 112700 788001 27151 SHERIFF'S OFFICE Revenues 4030901 116240 4030901 110090 4030701 116230 4030301 112620 9010101 196030 Expenditures 4030901 116240 4030701 116230 4030301 112620 Grant Match Transfers Out Total Expenditures 695500 21340 Transfers In - Law Enforcement Enhance Lab Fees 695500 21341 Transfers In - Law Enforcement Enhance State 695500 21396 Transfers In - Sheriff Dispatch Training 695500 21397 Transfers In - Sheriff Booking Fee Training 665882 Planned Use of Baiance Total Revenues 750203 Forensic Lab Enhancement 731304 Officers Training (Dispatch) 731304 Officers Training (Corrections) T..a..l C........ d:a..�..n SCHEDULE A FY 2021 FY 2022 AMENDMENTS AMENDMENTS (1,583.00) 1,583.00 9,405.00 (9,405.00) 224,831.00 7,113.DO 6,395.00 9,809.00 (7,113.00) 241,035.00 224,831.00 6,395.00 9,809.00 N nA� no¢ nn OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) JGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#101001 Dept Program Acct Fund Aff. Op UniY Account Name Revenue SCHEDULE A FY 2021 FY 2022 AMENDMENTS AMENDMENTS F 4030501 110110 650301 Donations $ 7.00 Total Revenue $ 7.00 Expenditure 4030501 110110 750070 Deputy Supplies $ 7.00 Total Expenditure $ 7.00 Revenues Project 100000003267 Bud Ref 2021 Activity: GLB Analysis: GLB 4030601 133095 610313 40010 Federal Operating Grants 356.00 4030601 133095 610313 40030 Federal Operating Grants 669.00 4030601 133095 610313 40040 Federal Operating Grants 1,863.00 4030601 133095 610313 40060 Federal Operating Grants 786.00 4030601 133095 610313 40080 Federal Operating Grants 1,515.00 4030601 133095 610313 40090 Federal Operating Grants 504.00 4030601 133095 610313 40120 Federal Operating Grants 730.00 4030601 133095 610313 40130 Federal Operating Grants 1,476.00 4030601 133095 610313 40180 Federal Operating Grants 484.00 4030601 133095 610313 40440 Federal Operating Grants 2,731.00 Total Revenues $ 11,114.00 Expenditures 4030601 133095 731577 40010 Refund Prior Years Revenue 356.00 4030601 133095 731577 40030 Refund Prior Years Revenue 669.00 4030601 133095 731577 40040 Refund Prior Years Revenue 1,863.00 n nonr_ne nnnrn n_c..-J Il_:__ _..__.._ Tor nn SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) JGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Dept Program Acct Fund Aff. Op Unit Revenue 9010101 196030 665882 Exoenditures 4030601 110000 1060201 133150 1110101 115090 9010101 196030 FY 2021 FY 2022 AMENDMENTS AMENDMENTS f Account Name Planned Use of Balance $ $ 16,379 00 $ Total Revenue $ $ 16,379.00 $ 731626 Rent $ 7,441.00 $ 30,245.00 $ 731626 Rent (3,348.00) (13,866 00) 731626 Rent (4,093.00) - 796500 Budgeted Equity Adjustment Total Expenditures $ $ 16,379 0C $ BOARD OF COMMISSIONERS Expenditures 5010101 165015 774636 5010101 165015 730338 ANIMAL CONTROL Revenues 1070805 132130 1070805 114050 1070801 114115 1070805 114090 9010101 196030 Info Tech Operations Computer Research Service Total Expenditures 630028 Adoptions 630070 Animal Shots/Dog 630074 Animal Serlization Fees 631988 Sale of Licenses 665882 Planned Use of Balance Tntaf RP\/PniiPz E1 13,308.00 (13,308.00) 71.00 196.00 2,000.00 83.00 (2,350.00) SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2021 FY 2022 AMENDMENTS AMENDMENTS F IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Dept Program Acct Fund Aff. Op Unit Account Name EMERGENCY MANAGEMENT AND HOMELAND SECURITY Expenditures 1060601 115090 775754 Maintenance Department Charges $ (1,41200) 1110101 115090 775754 Maintenance Department Charges 1,412.00 Total Expenditures $ - EMERGENCY MANAGEMENT AND HOMELAND SECURITY Project ID 100000002372 Bud Ref: 2020 Analysis: Activity: GLB Analysis: GLB Revenue 1110101 115180 610313 Federal Operating Grants $ (15,718.00) 9010101 196030 665882 Planned Use of Balance (11,478,00) Total Revenues $ (27,196.00) Expenditures 1060601 115180 702010 Salaries Regular $ (25.103.00) 1060601 115180 722750 Workers Compensation (56.00) 1060601 115180 722770 Retirement (648.00) 1060601 115180 722790 Social Security (364.00) 1060601 115180 722820 Unemployment Insurance (25.00) 1060601 115180 730072 Advertising (1,000.00) Total Expenditures $ (27,196.00) OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) JGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Dept Program Acct Fund Aff. Op Unit Account Name SCHEDULE A FY 2021 FY 2022 AMENDMENTS AMENDMENTS EMERGENCY MANAGEMENT AND HOMELAND SECURITY Project ID 100000003462 Bud Ref: 2021 Analysis: Activity: GLB Analysis: GLB Revenues 1110101 115180 610313 Federal Operating Grants $ 8,025.00 9010101 196030 665882 Planned Use of Balance 27,196.00 Total Revenues $ 35,221.00 Expenditures 1110101 115180 702010 Salaries Regular $ 25;103.00 1110101 115180 722750 Workers Compensation 56.00 1110101 115180 722770 Retirement 648.00 1110101 115180 722790 Social Security 364.00 1110101 115180 722820 Unemployment Insurance 25.00 1110101 115180 730072 Advertising 9,025.00 Total Expenditures $ 35,221.00 PUBLIC COMMUNICATIONS Expenditures 1210101 181000 788001 40400 Transfer Out - Project Work Order $ 34,803.00 9090101 196030 760126 Capital Outlay Miscellaneous (34,803.00) Total Expenditures $ NON -DEPARTMENT Revenue anif) I()I Iaanzn akranl) oi�nno�+ i inn nF Ralo nro Q Fair'o7nn x 1711 nkrm^, c OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS PROPRIETARY / SPECIAL REVENUE FUNDS -SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name DRUG COURT DISTRICT 52/1 SCAO I#27151), Grant #GROOODD01 D16 Activity GLB, Analysis Type GLB, Budget Ref 2021 Revenues 3020205 121050 695500 10100 Transfers in 3020205 121050 615571 State Operating Grants Total Revenues Expenditure 3020205 121050 730373 Contracted Services Total Expenditure Sheriff - LAW ENFORCEMENT ENHANCE LAB FEES (#213401 Revenue 4030901 116240 665882 Planned Use of Balance Total Revenue Expenditures 4030901 116240 788001 10100 Sheriff - LAW ENFORCEMENT ENHANCE STATE 421341) Revenue 4030901 110090 665882 Expenditures 4030901 110090 788001 1D100 Transfers Out - General Fund Total Expenditures Planned Use of Balance Total Revenue Transfers Out - General Fund Total Expenditures FY 2021 AMENDMENTS $ (9,405.00) 10,000.00 $ 595.00 $ 595.00 $ 595.00 $ 224,831.00 $ 224,831.00 $ 224,831.00 $ 224,831.00 $ 7,113.00 $ 7,113.00 $ 7,113.00 $ 7,113,00 SCHEDULE B FY 2022 FY AMENDMENTS AMEN OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS 1PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Sheriff - SHERIFF DISPATCH TRAINING (#21396) Revenue 4030701 112630 665882 Planned Use of Balance Total Revenue Expenditures 4030701 112630 788001 10100 Sheriff - SHERIFF BOOKING FEE TRAINING (#213971 Revenue 4030301 112620 665882 Expenditures Transfers Out - General Fund Total Expenditures Planned Use of Balance Total Revenue 4030301 112620 788001 10100 Transfers Out - General Fund Total Expenditures PROJECT WORK ORDER (#40400). Project:100000003532 Shade Replacement LBP Conference Center; Activity: PROJ Revenue 1040801 148020 69500 10100 Transfer In Total Revenue Expenditure 1040101 148020 796500 Budgeted Equity Adjustment Total Expenditure FY 2021 AMENDMENTS $ 6,395.00 $ 6,395.00 $ 6,395.00 $ 6,395.00 $ 9,809.00 $ 9,809.00 $ 9,809.00 $ 9,809.00 $ 34,803.00 $ 34,803.00 $ 34,803.00 $ 34,803.00 SCHEDULE FY 2022 AMENDMENTS FY AMEN OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2021 AMENDMENTS 1PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name DRUG COURT DISTRICT 52 2 SCAO (#27160) Grant #GR0000001017 Activity GLB, Analysis Type GLB, Budget Ref 2021 Exoenditures 3020305 121050 730548 Drug Testing $ 860.00 3020305 121050 732018 Travel and Conference (610.00) 3020305 121050 750245 Incentives (250.00) Total Expenditures $ DRUG COURT DISTRICT 52 3 SCAO (#27165), Grant #GR0000000988 Activity GLB, Analysis Type GLB, Budget Ref 2021 Expenditures 3020405 121050 730548 Drug Testing $ (1,805.00) 3020405 121050 731818 Special Event Program 1,500.00 3020405 121050 732018 Travel and Conference 305.00 Total Expenditures $ - SHERIFF'S OFFICE - SECONDARY ROAD PATROL (#273451 Grant # GR0000000142 Activity: GLB Analysis: GLB Budget Reference 2021 Revenue 4030601 110110 615571 Federal Operating Grants (658,110.00) Total Revenue $ (658,110.00) Exoenditures 4030601 110110 702010 Salaries $ (376,248.00) 4030601 110110 722750 Workers Compensation (7,835.00) 4030601 110110 722760 Group Life (652.00) 4030601 110110 722770 Retirement (92,866.00) SCHEDULE B FY 2022 FY AMENDMENTS AMEN OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2021 AMENDMENTS 1PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 4030601 110110 722900 Fringe Benefit Adjustments (50,898.00) 4030601 110110 776659 Motor Pool Fuel Charges (40,978,00) Total Expenditures $ (658,110.00) SHERIFF'S OFFICE - SECONDARY ROAD PATROL (#27345? Grant # GR0000000981 Activity: GLB Analysis: GLB Budget Reference 2021 Revenue 4030601 110110 615571 Federal Operating Grants 658,110.00 Total Revenue $ 658,110.00 Expenditures 4030601 110110 702010 Salaries $ 376,248.00 4030601 110110 722750 Workers Compensation 7,835,00 4030601 110110 722760 Group Life 652.00 4030601 110110 722770 Retirement 92,866.00 4030601 110110 722780 Hospitalization 55,283.00 4030601 110110 722790 Social Security 22,998.00 4030601 110110 722800 Dental 4,807.00 4030601 110110 722810 Disability 4,744.00 4030601 110110 722820 Unemployment Insurane 373.00 4030601 110110 722850 Optical 428.00 4030601 110110 722900 Fringe Benefit Adjustments 50,898.00 4030601 110110 776659 Motor Pool Fuel Charges 40,978.00 Total Expenditures $ 658,110.00 MI HEALTH & WELLNESS 4X4 (4283201 GR0000001001 Bud Ref: 2021 Activity: GLB Analysis: GLB Revenue 1060241 133390 615571 State Operating Grants $ (13,084.00) Tntal Rcvcniis G /9'2 nqa nnl SCHEDULE B FY 2022 FY AMENDMENTS AMEN OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2021 AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS -SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 1060241 133390 730373 Contracted Services (3,732.00) 1060241 133390 730926 Indirect Costs (732.00) 1060241 133390 731346 Personal Mileage (236.00) 1060241 133390 731388 Printing (2,440,00) 1060241 133390 732165 Workshops and Meeting (1,000.00) 1060241 133390 750392 Metered Postage 643.00 1060241 133390 750399 Office Supplies (500.00) 1060241 133390 750567 Training -Educational Supplies (788.00) Total Expenditures $ (13,084.00) WOMEN INFANT CHILDREN (#285531 GR0000000995 Bud Ref: 2021 Activity: GLB Analysis: GLB Revenue 1060284 133271 610313 Federal Operating Grants $ 17,850.00 Total Revenue $ 17,850,00 Expenditures 1060284 133271 702010 Salaries Regular $ 683.00 1060284 133271 722740 Fringe Benefits (7,928.00) 1060284 133271 730072 Advertising 3,495.00 1060284 133271 730373 Contracted Services 1.380.00 1060284 133271 730926 Indirect Costs 68.00 1060284 133271 730982 Interpreter Fees 1,000.00 1060284 133271 731346 Personal Mileage 560.00 1060284 133271 731388 Printing 1,000.00 1060284 133271 731941 Training 1,000.00 1060284 133271 750294 Material and Supplies 250.00 1060284 133271 750301 Medical Supplies 2,000.00 SCHEDULE B FY 2022 FY AMENDMENTS AMEh4 SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2021 FY 2022 AMENDMENTS AMENDMENTS 1PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name HEALTH PHEP (#28610) GROOD0001053 Bud Ref: 2021 Activity: GLB Analysis: GLB Revenue 1060290 115010 610313 Federal Operating Grants $ 73,926.00 Total Revenue $ 73,926.00 Expenditures 1060290 115010 702010 Salaries Regular $ 40,561.00 1060290 115010 722740 Fringe Benefits 14,602.00 1060290 115010 730926 Indirect Costs 4,020.00 1060290 115010 731346 Personal Mileage 575,00 1060290 115010 731388 Printing 2,000.00 1060290 115010 750077 Disaster Supplies 7,006.00 1060290 115010 750399 Office Supplies 809.00 1060290 115010 774636 Info Tech Operations 3,598.00 1060290 115010 774637 Info Tech Managed Print Svcs 465.00 1060290 115010 774677 Insurance Fund 90.00 1060290 115010 778675 Telephone Communications 200.00 Total Expenditures $ 73,926.00 HEALTH PHEP (#28610) GR0000001054 Bud Ref: 2021 Activity: GLB Analysis: GLB Revenue 1060290 115035 610313 Federal Operating Grants $ 46,902.00 Total Revenue $ 46,902.00 Expenditures 1060290 115035 702010 Salaries Regular $ 25,323.00 1060290 115035 722740 Fringe Benefits 9,11&Do �nFnoan �gcnzr 74no9C. rinno FY AMEN SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2021 FY 2022 FY AMENDMENTS AMENDMENTS AMEN 1PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 1060290 115035 750399 Office Supplies 800.00 1060290 115035 774636 Info Tech Operations 1,632.00 1060290 115035 774677 Insurance Fund 69.00 1060290 115035 778675 Telephone Communications 735.00 Total Expenditures $ 46,902.00 BFC PERSONNEL (#21184) Revenues 1090202 171100 631869 Reimburse Salaries (649,313.00) 1090305 171100 631869 Reimburse Salaries 648,898.00 Total Revenues (415.00) Expenditure 1090301 171100 702010 Salaries Regular $ (387,824.00) 1090301 171100 722750 Workers Compensation (860.00) 1090301 171100 722760 Group Life (835.00) 1090301 171100 722770 Retirement (107,879.00) 1090301 171100 722780 Hospitalization (82,872.00) 1090301 171100 722790 Social Security (29,376.00) 1090301 171100 722800 Dental (6,567,00) 1090301 171100 722810 Disability (6,058.00) 1090301 171100 722820 Unemployment Insurance (383.00) 1090301 171100 722850 Optical (728.00) 1090301 171100 722900 Fringe Benefit Adjustment (415.00) 1090305 171100 702010 Salaries Regular 387,824.00 1090305 171100 722750 Workers Compensation 860.00 �nnnonr e�n�nn �on�cn c.,..,, i'F� ooc nn OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS 1PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 1090305 171100 722810 Disability 1090305 171100 722820 Unemployment Insurance 1090305 171100 722850 Optical Total Expenditures MIDC FUND #20260 Expenditures 9010101 121170 731458 Professional Services 3010301 121170 730688 Expert Witness Fee and Mileage Total Expenditures COMMUNITY CORRECTIONS COMPREHENSIVE GRANT (#273701 Grant #: GR0000000986 Activity: GLB Analysis Type: GLB Budget Reference: 2021 4030301 112620 731885 Support Services 1070401 113000 702010 Salaries 1070401 113000 722740 Fringe Benefits 1070401 113035 730373 Profession Services Total Expenditures RADIO FUND (#53600) Revenue 1080310 115150 Planned Use of Fund Balance Total Revenue Expenses 1080310 115150 796500 Budgeted Equity Adjustments Total Expenses FY 2021 AMENDMENTS 6,058.00 383.00 728.00 $ (415.00) q 39,368.00 (39,368.00) $ (43,000.00) 20,300.00 14,700.00 8,000.00 $ 21,750.00 $ 21,750.00 $ 21,750.00 $ 21,750.00 SCHEDULE B FY 2022 AMENDMENTS FY AMEN OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS 1PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff O er Unit Account Name 5060722 160210 632261 Temporary Licenses 5060101 160000 620573 Local Comm Stabalization Share 5060735 160210 630644 Entrance Fees Gen Admission 5060735 160210 631295 Rental Facilities 5060735 160210 630301 Commissi C t t 5060437 160044 5060720 160070 5060715 160070 5060805 160210 5060720 160070 5060101 160000 5060101 160000 5060101 160000 5060101 160000 Expenses 5060735 160210 5060735 160210 5060735 160210 5060735 160210 5060735 160210 5060735 160210 5060735 160210 5060735 160210 5060735 160210 5060735 160210 5060735 160210 5060735 160210 on on rac s 632037 Sales Retail 675356 Loss on Sale of Equipment 675356 Loss on Sale of Equipment 675660 Gain on Sale of Vehicles 675660 Gain on Sale of Vehicles 650106 Contributions -Federal Grants 601208 Delinquent Tax Prior Years 601637 Property Tax Levy 655385 Income from Investments Total Revenues $ 731689 Security Expense $ 730562 Electrical Service 731269 Natural Gas 750476 Recreation Supplies 732102 Water and Sewage Charges 750581 Uniforms 730814 Grounds Maintenance 731941 Training 750504 Small Tools 730247 Charge Card Fee 730646 Equipment Maintenance 750063 Custodial Supplies FY 2021 AMENDMENTS 23,500.00 78,989.00 (375,000.00) (3,000.00) (500,00) (113,000.00) (9,599.00) (21, 850.00) 10,300.00 583.00 7,500.00 393,500.00 (393,500.00) (20,000.00) (418,698.00) (22,000.00) (12,000.00) (12,000.00) (10,000.00) (7,000.00) (6,400.00) (5,000.00) (6,000.00) (5,000.00) (4,000.00) (4,000.00) (3,500.00) SCHEDULE B FY 2022 AMENDMENTS F )' AMEN OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2021 AMENDMENTS )PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 5060735 160210 731241 Miscellaneous (800.00) 5060735 160210 778675 Telephone Communications (800.00) 5060735 160210 775754 Maintenance Department Charges (500.00) 5060735 160210 750399 Office Supplies (400.00) 5060735 160210 731115 Licenses and Permits (300.00) 5060735 160210 702010 Salaries Regular (235,000.00) 5060735 160210 712020 Overtime (5,000.00) 5060735 160210 722740 Fringe Benefits (35,000.00) 5060437 160044 702010 Salaries Regular (42,000.00) 5060437 160044 750385 Merchandise (35,000.00) 5060437 160044 722740 Fringe Benefits (3,500.00) 5060437 160044 731059 Laundry and Cleaning (1,200.00) 5060437 160044 730198 Building Maintenance Charges (1,000.00) 5060437 160044 730247 Charge Card Fee (1,000.00) 5060437 160044 730429 Custodial Services (1,000.00) 5060437 160044 774636 Info Tech Operations (800.00) 5060437 160044 712020 Overtime (500.00) 5060437 160044 731941 Training (500.00) 5060437 160044 750063 Custodial Supplies (500.00) 5060437 160044 750581 Uniforms (500.00) 5060437 160044 731388 Printing (300.00) 5060437 160044 731115 Licenses and Permits (200.00) 5060437 160044 731241 Miscellaneous (100,00) 5060720 160070 730037 Adj Prior Years Exp 545.00 5060735 160070 730037 Adj Prior Years Exp 1,022.00 5060101 160000 730037 Adj Prior Years Exp 600.00 5060735 160070 730037 Adj Prior Years Exp 1,223.00 5060805 160210 731577 Refund Prior Years Revenue 550.00 5060837 160210 731577 Refund Prior Years Revenue 176.00 SCHEDULE B FY 2022 F)' AMENDMENTS AMEN OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS 1PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 5060805 160210 731577 Refund Prior Years Revenue 5060831 160210 731577 Refund Prior Years Revenue 5060720 160070 731577 Refund Prior Years Revenue 5060732 160070 731577 Refund Prior Years Revenue 5060805 160210 731577 Refund Prior Years Revenue 5060B31 160210 731577 Refund Prior Years Revenue 5060837 160210 731577 Refund Prior Years Revenue 5060725 160070 731577 Refund Prior Years Revenue 5060732 160070 731577 Refund Prior Years Revenue 5060831 160210 731577 Refund Prior Years Revenue 5060722 160210 730814 Grounds Maintenance 5060722 160210 730653 Equipment Rental 5060722 160210 730373 Contracted Services 5060101 160000 796500 Budgeted Equity Adjustments Total Expenses E1 FY 2021 AMENDMENTS 625.00 112.00 144.00 3,000.00 550,00 1,492.00 220.00 475.00 200.00 112.00 9,980.00 81,127.00 13,000.00 (91,695.00) (418,698.00) SCHEDULE B FY 2022 AMENDMENTS FY AMEN OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100). Dept Program Acct PUBLIC COMMUNICATIONS Revenue 9010101 196010 620573 Expenditures 9090101 9090101 1010105 1010105 1010601 1010601 1010602 1010602 1010602 1010602 1010602 1010602 1010602 1010602 1010602 1010602 1010603 1010603 InInFnz 196010 196030 181000 181000 181000 181000 181000 181000 181000 181000 181000 181000 181000 181000 181000 181000 181000 181000 1 R1 nnn 773630 730359 702010 722900 702010 722900 702010 702010 702010 702010 702010 722900 722900 722900 722900 722900 702010 702010 7ngnin Fund Aff. Op Unit Account Name Local Community Stabilization Share Total Revenue Non -Dept IT Dev Contingency Salaries Fringe Benefits Adj Salaries Fringe Benefits Adj Salaries Salaries Salaries Salaries Salaries Fringe Benefits Adj Fringe Benefits Adj Fringe Benefits Ad) Fringe Benefits Adj Fringe Benefits Adj Salaries Salaries C ah'i.c SCHEDULE C FY 2021 FY 2022 AMENDMENTS AMENDMENTS $ 101,027.00 $ $ 101,027.00 $ (20,630.00) (10,592.00) (16, 507.00 ) (8,605.00) (13,702,00) (8,988.00) (11,056,00) (13, 280.00) (12,799.00) (5,603.00) (4,236.00) (6,085.00) (5,041.00) (5,422.00) (13,280.00) (16,507,00) W) ARQ M\ F (287,680.0M $ (443,034.00) (126, 256.00 ) (64,823.00) (101,021.00) (52, 663.00) (83,857 00) (55,009,00) (671663.00) (81,274.00) (78, 329.00) (34,289.00) (25,927.00) (37,238.90) (30,852.00) (33,181,00) (81, 274.00) (101,021.00) (7R 107 nm SCHEDULE C OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2021 FY 2022 AMENDMENTS AMENDMENTS JGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Dept Program Acct Fund Aff. Op Unit Account Name 1050401 183010 702010 Salaries 2,742.00 16,780.00 1050401 183010 722900 Fringe Benefits Adj 548,00 3,354 00 1050401 183010 722900 Fringe Benefits Adj 148.00 903.00 1210101 181000 702010 Salaries 23,821.00 152,533.00 1210101 181000 722900 Fringe Benefits Adj 3,715.00 65,146.00 1210102 181000 702010 Salaries 60,306.00 369,077.00 121D102 181000 7D2010 Salaries 14,641,00 89,604 00 1210102 181000 702010 Salaries 5,884.00 36,009.00 1210102 181000 702010 Salaries 648,00 3,887.00 1210102 181000 722900 Fringe Benefits Adj 27,881 00 170,62 i.00 1210102 181000 722900 Fringe Benefits Adj 7,741.00 47,37I.00 1210102 181000 722900 Fringe Benefits Adj 317.00 1,9s7 00 1210102 181000 722900 Fringe Benefits Adj 248.00 1,4U9.,0 1210103 181000 702010 Salaries 16,142.00 98,788.00 1210103 181000 702010 Salaries 12,799.00 78,1129 00 1210103 181000 702010 Salaries 2,558.00 15,054 00 1210103 181000 702D10 Salaries 191.00 1,143.00 1210103 181000 702010 Salaries 225.00 1.351.00 1210103 181000 702010 Salaries 10,393.00 65,245 00 1210103 181000 702010 Salaries 10,393,00 65,245.00 1210103 181000 722900 Fringe Benefits Adj 8,482.00 51:911.00 1210103 181000 722900 Fringe Benefits Adj 5,422.00 33,161.00 1210103 181000 722900 Fringe Benefits Adj 138.00 842.00 1210103 181000 722900 Fringe Benefits Adj 101.00 503.00 1210103 181000 722900 Fringe Benefits Adj 95.00 572.00 1 )In 1M 'IP Innn 7'X)a1)n o,ai 1) a17 nn nj Gao nn F SCHEDULE C OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2021 FY 2022 AMENDMENTS AMENDMENTS E MGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Dept Program Acct Fund Aff. Op Unit Account Name 1210105 181000 722900 Fringe Benefits Adj 8,605.00 52,663.00 1210106 181000 702010 Salaries 16,507.00 101,021.00 1210106 181000 722900 Fringe Benefits Adj 8,532,00 52,213.00 1110101 115090 731500 Public Information - (1,000,OOO.CO) 1210101 181000 730072 Advertising - 200,000.00 1210101 181000 730373 Contracted Services - 150,000.00 1210101 181000 731213 Membership Dues - 10,000.00 1210101 181000 731339 Periodicals Books Publ Sub - 12,500.00 1210101 181000 731346 Personal Mileage - 10,000,00 1210101 181000 731388 Printing - 50,000.00 1210101 181000 731458 Professional Services - 188,900.00 1210101 181000 731773 Software Rental Lease Purchase - 47,600 00 1210101 181000 731780 Software Support Maintenance - 5,000.00 1210101 181000 731818 Special Event Program - 2,500.00 1210101 181000 731822 Special Projects - 200,000.00 1210101 181000 732018 Travel and Conference - 30,OOn.00 1210101 181000 732165 Workshops and Meeting - 5,000.00 1210101 181000 750154 Expendable Equipment - 20,00C.00 1210101 181000 750294 Material and Supplies - 30,000.00 1210101 181000 750392 Metered Postage - 10,000.00 1210101 181000 750399 Office Supplies - 5,000.00 1210101 181000 750511 Special Event Supplies - 5,000.00 1210101 181000 750581 Uniforms - 3,000,00 1210101 181000 774636 Info Tech Operations - 1 c 50� 00 Total Expenditures $ 101,027.00 $ SCHEDULE OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2021 FY 2022 AMENDMENTS AMENDMENTS < IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Dept Program Acct Fund Aft. Op Unit Account Name 1210103 181000 722900 Fringe Benefits Adj 2,717.00 27,204.00 1210104 181000 702010 Salaries 8,143.00 51,121.00 1210104 181000 722900 Fringe Benefits Adj 2,783.00 29,641.00 1210106 181000 702010 Salaries 10,913.00 68,507.00 1210106 181000 702010 Salaries 10,913.00 68,507,00 1210106 181000 722900 Fringe Benefits Adj 2,948.00 35,728.00 1210106 181000 722900 Fringe Benefits Adj 2,948.00 35,728.00 Total Expenditures $ 48,399.00 $ 360,596-00 $ INFORMATION TECHNOLOGY (#63600) Revenue 1080101 152000 665882 Planned Use of Balance $ (22,382.00) $ (136,981.00) $ 1080101 152000 665882 Planned Use of Balance (24,624.00) (150,699.00) Total Revenues $ (47,006.00) $ (287.680.00) $ Expenses 1080201 152020 702010 Salaries $ (14,641.00) $ (89,604.00) $ 1080201 121010 702010 Salaries (16,141.00) (98,788.00) 1080201 152020 722900 Fringe Benefits Ad) (7,742.00) (47,377.00) 1080201 121010 722900 Fringe Benefits Adj (8,482.00) (51,911.00) Total Expenses $ (47,006.00) $ (287,680 00) $ COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITt SUMMARY BY DEPARTMENT FY 2021 BUDGET ADOPTED AS F) BUDGET AMENDED FOF REVENUES GENERALFUND Taxes $ 251,108,729.00 $ 256,102,156.00 $ 2: Federal Grants 2,249,550.00 130,513,436.00 11 State Grants 20,836,991.00 21,552,132.00 Other Intergovernmental Revenue 45,977,607.00 46,041,107.00 Charges for Services 120,392,677.00 121,845,402.00 1: Indirect Cost Recovery 9,100,000.00 9,100,000.00 Investment Income 1,500,000.00 1,500,000.00 Other Revenues 5,734,000.00 6,272,562.00 SUB -TOTAL GENERAL FUND/GENERAL PURPOSE $ 456,899,554.00 $ 592,926,795.00 $ 5� PLANNED USE OF FUND BALANCE $ 609,338.00 $ 44,880,738.21 $ TOTAL GF/GP FUNDS $ 457,508,892.00 $ 637,807,533.21 $ 6i EXPENDITURES ADMINISTRATION OF JUSTICE Circuit Court $ 50,728,376.00 $ 53,257,932.44 52nd District Court 17,813,045.00 18,511,099.87 Probate Court 7,027,765.00 7,235,029.00 TOTAL ADMIN. OF JUSTICE $ 75,569,186.00 $ 79,004,061.31 $ f LAW ENFORCEMENT Prosecuting Attorney 21,782,301.00 22,722,703.00 Sheriff 166,768,499.00 170,430,915.86 1 f TOTAL LAW ENFORCEMENT $ 188,550,800.00 $ 193,153,618.86 $ V GENERALGOVERNMENT Clerk/Register of Deeds 10,461,273.00 11,815,077.00 Treasurer 8,236,139.00 8,671,655.00 Board of Commissioners 4,729,244.00 7,745,832.60 Water Resources Commissioner 7,798,886.00 8,000,891.00 TOTAL GENERAL GOVERNMENT $ 31,225,542.00 $ 36,233,455.60 $ COUNTY EXECUTIVE County Executive Admin. $ 7,099,684.00 $ 10,296,122.57 $ Management and Budget 22,891,222.00 24,154,239A3 Central Services 2,576,327.00 2,634,606.00 n AOa ona nn 1 aon 4 vl) 7n TAXES (601000-601999) Property Taxes - July Tax Levy Other Taxes - Delinquent Tax - Prior Years Treasurer Payment In Lieu of Taxes Other Taxes - Trailer Tax Total Taxes FEDERAL GRANTS (610000-610999) Sheriff - Sheriff's Office Sheriff - Patrol Sheriff - Corrective Services Sheriff - Investigative/Forensic Services Prosecuting Attorney Homeland Security- Disaster Control Emergency Management and Homeland Security Health Division Children's Village Non -Departmental Total Federal Grants STATE GRANTS (615000-615999) Sheriff - Patrol State Match Foster Care Prosecutina Attornev COUNTY OF OAKLAND GENERAL FUND GENERAL PURPOSE REVENUES FY 2021 THIRD QUARTER REPORT AMOUNT ADOPTED AMENDED FY2021 FAVORABL BUDGET BUDGET FORECAST (UNFAVORAB $ 250,498,729.00 $ 255,492,156.00 $ 255,492,156.00 $ 125,000,00 125,000.00 325,000.00 200.1 400,000.00 400,000.00 650,000.00 25J, 85,000,00 85,000.00 85,000.00 $ 251,108,729.00 $ 256,102,156.00 $ 256,552,156.00 $ 450,1 357,293.00 357,293.00 - 175,000.00 175.000.00 205,000.00 205,000.00 205,D00.00 70,718.00 - - - 70,718.00 70,718.00 654,727.00 649,493.00 649,493.00 300,000.00 300,000.00 165,000.00 135,1 1,019,105.00 128, 755, 932.00 128, 755, 932, 00 $ 2,249,550.00 $ 130,513,436.00 $ 130,378,436.00 $ (135, $ - $ 100,OOD.00 $ 100,000.00 $ 1,000.00 1,000.00 1,000.00 COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2021 THIRD QUARTER REPORT AMOUNT ADOPTED AMENDED FY2021 FAVORABL BUDGET BUDGET FORECAST (UNFAVORA6 OTHER INTER -GOVERNMENTAL REVENUES (620000 - 626999) Non -Departmental $ 43,681,573.00 $ 43,731,573.00 $ 45,086,073.00 $ 1,354, HHS - Homeland Security Emergency Management - Homeland Security Circuit Court District Court Sheriff Non -Departmental - Reimb Judges Salaries Total Other Intergovernmental Revenue CHARGES FOR SERVICES (630000-635999) Administration of Justice Circuit Court - Judicial/Administration Circuit Court - Civil/Criminal 9,000.00 - a, 4,500,00 4,500.00 4,500.00 1,800.00 1,800.00 1,800.00 286,550.00 300,050.00 313,600.00 13, 1,994,184.OD 1,994,184.OD 2,019,184.00 25, $ 45,977,607.00 $ 46,041,107.00 $ 47,425,157.00 $ 1,384, 2,406,000.00 2,649,200.00 2,049,200.00 (600" District Court - Division II (Clarkston) District Court - Division III (Rochester Hills) District Court - Division IV (Troy) Probate Court - Estates and Mental Health COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2021 THIRD QUARTER REPORT AMOUNT ADOPTED AMENDED FY2021 FAVORIBL BUDGET BUDGET FORECAST (UNFAVORAB 1,912,663.00 1,912,663.00 1,703,663.00 (209, 4,178,015,00 4,178,015.00 3,053,015.00 (1,125. 2,440,590.00 2,440,590.00 1,435,590.00 ('1,005, 561,600.00 561,600.00 546,600.00 (15,' Total Administration of Justice $ 17,485,121.00 $ 17,728,321.00 $ 13,579,321.00 $ COUNTY OF OAKLAND GENERAL FUND/GENERAL PURPOSE REVENUES FY 2021 THIRD QUARTER REPORT AMOUNT ADOPTED AMENDED FY2021 FAVORABL BUDGET BUDGET FORECAST (UNFAVORAB Sheriff -Corrective Services 2,961,000.00 3,182,236.00 1,822,236.00 (1,360,1 Sheriff - Corrective Services Satellites 584,855.00 586,098.00 366,098.00 (220. Sheriff - Emergency Response and Prep 322,500.00 300,000.00 130,000.00 Sheriff- Patrol Services 57,826,891.00 57,952,484.00 57,137,484.00 (815. Clerk - Elections Clerk - Register of Deeds & Micrographics Treasurer Board of Commissioners Water Resources Commissioner Total General Government County Executive County Exec - Corp Counsel COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2021 THIRD QUARTER REPORT AMOUNT ADOPTED AMENDED FY 2021 FAVORABL BUDGET BUDGET FORECAST (UNFAVORAB 93,700.00 93,700.00 223,700,00 130,1 11,492,500.00 11,492,500.00 17,192,500.00 5,700, 4,646,600.00 4,646,600.00 3,896,600.00 (750, 14,200.00 14,200.00 2,200.00 3,346,261.00 3,396,208.00 3,396,208.00 $ 21,772,361.00 $ 21,822,308.00 $ 27,300,308.00 $ 5,478, 1, 271.00 COUNTY OF OAKLAND GENERAL FUND I GENERAL PURPOSE REVENUES FY 2021 THIRD QUARTER REPORT AMOUNT ADOPTED AMENDED FY2021 FAVORABL BUDGET BUDGET FORECAST IUNFAVORAS HHS - Health Division 4,720,519.00 4,754,115.00 3,897,015.00 (857, HHS - MSU Extension - - Public Services - Community Corrections 155,000.00 155,000.00 15,000.00 �140, Public Services - Children's Village 3,164,097.00 3,164,097,00 5,884,097,00 2,720, Public Services - Medical Examiner 325,100.00 325,100.00 365,100.00 40,1 Public Services -Animal Control 1,138,514.00 1,149,664.00 856,664.00 (293, Public Services - Circuit Court Probation - - - Economic Development - Planning & Local Bus Dev. (FKA 404,071.00 404,071.00 324,071.00 (80,( PEDS) Clerk/Register of Deeds Economic Development Non -Departmental Total Investment Income OTHER REVENUES (670000-6955001 Circuit Court- Donations Circuit Court Circuit Court - Transfers In District Courts (Div. I - IV) Probate Court Prosecuting Attorney Sheriff Office Sheriff - Administrative Services Sheriff - Corrective Services Sheriff - Corrective Services -Satellites Sheriff - Emergency Resp and Prepare Sheriff - Patrol Services Sheriff - Patrol Services - Donations COUNTY OFOAKLAND GENERAL FUND/ GENERAL PURPOSE REVENUES FY 2021 THIRD QUARTER REPORT AMOUNT ADOPTED AMENDED FY2021 FAVORABL BUDGET BUDGET FORECAST (UNFAVORAB 2,500.00 2,500.00 48,705,00 46.' 1, 345, 300.00 1, 345, 300.00 1, 345, 300.00 $ 1,500,000.00 $ 1,500,000.00 $ 1,546,205.00 $ 46, 3,850,00 70.00 65,875.00 65, - 150.00 150.00 12,000.00 12,000.00 5,000.00 (7, - 12,500.00 12,500.00 COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2021 THIRD QUARTER REPORT AMOUNT ADOPTED AMENDED FY 2021 FAVORABL BUDGET BUDGET FORECAST (UNFAVORAB Water Resources Commissioner 25,043.00 25, County Exec - Compliance Office Management and Budget - Fiscal Services Central Services - Support Services 1,500,00 1,500.00 1,500.00 Human Resources - - Facilities Management Engineering _ _ _ Health Division - Donations - - 32.00 Health Division - - 122,200.00 122,', Health Division - Transfers In Children's Village Children's Village - Transfers In 25.00 25.00 Homeland Security _ - EMG - Homeland Security Public Services - Medical Examiner Public Services - Animal Control -Other Revenues Public Services - Animal Control -Transfers In Public Services - Children's Village - Other Revenues 894,309.00 894, Economic Development & Comm Affairs - Contributions Economic Development - Contributions _ _ Economic Development - Transfers In 50,000.00 50,000.00 Non Departmental - Donations Non -Dept - Sundry 417,500.00 417,500.00 317,500.00 (100, Sheriffs' Transfers In - 204,595.00 204,595.00 Judicial Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfer Out Business Division COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT $ 9,813,330.00 $ 10,348,121.00 $ 9,598,121.00 $ 750,000.00 7.25%- Fay. d 224,828.00 921,117.52 377,222.52 543,895.00 59.05% Fav, E Office Speci: Judicii projec Partia higher Varian 376,429.00 469,139.00 501,139.00 (32,000.00) -6.82% - Unfav equipr result Tech I use. T due to ------------------------------------------------------------------------- ------------------------------ $ 10,414,587.00 $ 11,738,377.52 $ 10,476,482.52 $ 1,261,895.00 10.75% Q 7 na7 CZ n nn Q 7 1 A I QnG nn Q 1 Rn 1 Qr)g nn Q Qnn nnn nn 1 n 01 0/ Internal Support Expenditures Transfers Out Civil / Criminal Division Personnel Expenditures Operating Expenditures Internal Support Expenditures COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT 243,687.00 243,687.00 250,687.00 (7,000.00) -2.87% - Unfav equipr result Tech! use. T due tc ------------------------------------------------------------------------- --- $ 2,483,727.00 $ 2,557,422.00 $ 2,166,922,00 $ $ 1,777,891.00 $ 1,824,112.00 $ 1,649,112.00 $ 1,821,589.00 1,821,589.00 1,146,589.00 2,323,443.00 3,056,397.00 3,031,397.00 ---------------- 390,500.00 15.27% 175,000.00 9.59% - Fay. d 675,000.00 37.06% - Fay. J Appel! Suppli than a Media overai COW 25,000.00 0.82% - Fay. li anticii; ($10,C higher varian Family Division/Juvenile Maint. Personnel Expenditures Operating Expenditures Internal Support Expenditures COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT $ 12,172,216.00 $ 12,508,897.00 $ 11,308,897.00 $ 9,305,257.00 2,183,332.00 9,307,734.92 2,196, 313.00 4,832,734.92 2,306,313.00 Transfer Out 6,377,343.00 6,379,928.00 6,379,928.00 -------------------------------------------------------------------------- --- $ 30,038,148.00 $ 30,392,872.92 $ 24,827,872.92 $ 1,200,000.00 4,475,000.00 (110,000.00) ------------------ 5,565,000.00 9.59% - Fay. d 48.08% - Fay. d $1,97: on cat orderE Guard due to Dept ( overai COW -5.01 °'o - Unfav equipr result Tech use. T due to 0§Y�11111 18.31 % COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES DISTRICT COURT AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCEN District Court Administration Personnel Expenditures $ 238,267.00 $ 261,659.00 $ 261,659.00 $ - 0.00` Operating Expenditures 10,300.00 10,300.00 300.00 10,000.00 97.09' Internal Support Expenditures 2,318.00 2,318.00 2,318.00 - 0.00` Transfers Out - - - ------------------------- 0.00` -------------------------- $ 250,885.00 ------------------------ $ 274,277.00 -------------------------- $ 264,277.00 $ 10,000.00 3.65` Division 1 - Novi Personnel Expenditures $ 4,600,355.00 $ 4,773,297.00 $ 4,373,297.00 400,000.00 8.381 Operating Expenditures 905,590.00 890,890.00 828,390.00 62,500.00 7.021 Internal Support Expenditures 428,311.00 448,283.00 418,283.00 30,000,00 6.691 Transfers Out - - - - 0.00` Division 3 - Rochester Hills Personnel Expenditures Operating Expenditures Internal Support Expenditures COUNTY OF OAKLAND FY2021 THIRD QUARTER REPORT EXPENDITURES DISTRICT COURT AMOUNT ADOPTED AMENDED FY2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCEN $ 4,090,212.00 $ 4,255,185.00 $ 3,655,185.00 278,427.00 327,369.87 269,869.87 857,122.00 879,820.00 849,820.00 Transfers Out -------------------------- -------------------------------------------------- --- $ 5,225,761.00 $ 5,462,374.87 $ 4,774,874.87 $ Division 4 - Troy Personnel Expenditures Operating Expenditures $ 2,568,798.00 $ 2,645,637.00 $ 2,470,637.00 447,072.00 469,396.00 428,396.00 600,000.00 57,500.00 30,000.00 687,500.00 175,000.00 41,000.00 Internal Support Expenditures 299,947.00 319,970.00 299,970.00 20,000.00 Judicial/Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfer Out Estates/Mental Health Personnel Expenditures Operating Expenditures COUNTY OFOAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES PROBATE COURT AMOUNT ADOPTED AMENDED FY2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT $ 2,562,648.00 $ 2,646,360.00 $ 2,546,360.00 $ 100,000.00 3.780io Fay. due to 22,481.00 22,481.00 7,481.00 15,000.00 66.72% Fay. Libras) Membersni, COVID-19 I restricticns 479,627.00 479,902.00 477,402.00 2,500.00 0.52410 Fay. Info TE to less than ------------------------ ------------------------------------------------- --- $ 3,064,756.00 $ 3,148,743.00 $ 3,031,243.00 $ $ 2,346,708.00 $ 2,431,826.00 $ 2,081,826.00 $ 1,007,943.00 1,007,943.00 958,943.00 ---------------- 117,500.00 3.73% 350,000.00 14.39% Fay. due to 49,000.00 4.86% Fay. Fees ( to a decrea Printing $1< anticipated due to the C Probate Ex; Unfay. Soft for the use Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLAW $ 2,7221,325.00 $ 2,759,510.00 $ 2,619,510.00 $ 140,000.00 5.07% Fav Salaries and F 524,666.00 2,107,108.00 751,111.00 2, 211, 303.00 576,111.00 2,311,303.00 $ 5,356,099.00 $ 5,721,924.00 $ 5,506,924.00 $ unfay. Overtime, ar offset by untay. Sta Rights Giant due tc 175,000.00 23.30% Fay. Professional Ic due to a prior convi 2021 and a carryfoi of the review. Also Expense $15,000, 1 Fees $8,000, Metei $1,500 due to less $30.000 which Is of Personnel Expend!' Membership Dues (100,000.00) -4.52% Unfay. Info Tech O operating charges I work from home dL Info Tech Managed Equipment Rental f Telephone Commu 0.00% ----------------- 215,000.00 3.76% COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANP Operating Expenditures 28,301.00 27,801.00 12,801.00 15,000.00 53,95% Fay. Personal Mde� Internal Support Expenditures 161,075.00 161,075.00 161,075.00 - 0.00% Transfers Out 975,027.00 975,027.00 975,027.00 0.00% -------------------------- $ 12,133,821.00 -------------------------- $ 12,552,451.00 ---------------------------- $ 11,737,451.00 ----------------------- ------- $ 815,000,00 6,49% _ Warrants Personnel Expenditures $ 2,274,794.00 $ 2,365,171.00 $ 2,115,171.00 $ 250,000.00 10.57% Fay. Salares anJ F Operating Expenditures 3,199.00 3,199.00 699.00 2,500.00 78.15% Fav Personal Mile< Internal Support Expenditures 32,213.00 32,213.00 32,213.00 - 0.00% Appellate Personnel Expenditures Operating Expenditures $ 2,310,206.00 $ 2,400,583.00 $ 2,148,083.00 $ $ 1,951,093.00 $ 2,017,163.00 $ 1,967,163.00 $ 4,000.00 3,500.00 2,000.00 252, 500.00 10.52 % 50,000.00 2.48% Fay. Salaries and F unfav Overtime. 1,500.00 42.86% Fay. Personal Mile COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE ------------ BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT Department Personnel Expenditures $ 17,919,630.00 $ 18,530,392.00 $ 17,290,392.00 $ 1,240,000.00 6.69% Operating Expenditures 560,166.00 785,611.00 591,611.00 194,000.00 24.69% Internal Support Expenditures 2,327,478.00 2,431,673.00 2,531,673,00 (100,000.00) -4.11% Transfers Out 975,027.00 -------------------------- 975,027.00 975,027.00 0.00% $ 21,782,301.00 ------------------------- $ 22,722,703.00 ---------------------------- $ 21,388,703.00 ------------------------------ $ 1,334,000.00 5.879% EXPLANP Sheriff's Office Personnel Expenditures Operating Expenditures Internal Support Expenditures Administrative Services Personnel Expenditures Operating Expenditures COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE AMOUNT ADOPTED AMENDED FY2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIG $ 1,842,596.00 $ 1,904,919.00 $ 1,364,919.00 $ 540,000.00 28.35% Fay. due to vacant positions, turnover a divisions. 93,020.00 95,545.00 60,545.00 35,000.00 36.63% Fay. Material and Supplies $15,000, Co Supplies $4,000 and Library Confinuatic 549,462,00 549,462.00 469,462.00 80,000.00 14.56% Fay. Info Tech Operations $68,000, Mot Communications $2,000 and Motor Poo anticipated use. $ 2,485,078.00 $ 2,549,926.00 $ 1,894,926.00 $ 655,000.00 25.69% $ 1,296,145.00 $ 1,338,391.00 $ 1,488,391.00 515,668.00 518,152.58 428,152.58 Internal Support Expenditures 153,188.00 153,188.00 156,188.00 (150,000.00)-11.21% Unfay. Salaries and Fringe Benefits due Overtime. 90,000.00 17.37% Fay. Printing $50,000, Deputy Supplies Library Continuations $20,000, Travel a Supplies $10,000 due to less than antic, Equipment ($47,100) due to upgrade to Uniforms ($43,000) both as a result of tf (3,000.00) -1.96% Unfay. Info Tech Operations ($9,000) di Tech Managed Print Services $4,500 at due to less than anticipated use. $ 1,965,001.00 $ 2,009,731.58 $ 2,072,731.58 $ (63,000.00) -3,13% Corrective Services Personnel Expenditures Operating Expenditures Internal Support Expenditures Corrective Services -Satellites Personnel Expenditures ADOPTED BUDGET 34, 659, 086.00 7,615,253.00 6,960,445.00 COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE AMOUNT AMENDED FY 2021 FAVORABLE BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIG 34,727,888.00 $ 34,492,888.00 235,000.00 0,68% Fay. Salaries and Fringe Benefits as a r officers in the academy and officers in tr contributed to additional leave unie. pan a portion is attributable to the COVID-1� 7,672,901.80 8,267,901.80 (595,000.00) -7.75% Unfay. Contracted Services ($565,000) above contracted rate due to COVID-19 American Rescue Plan (ARP) or FEMA, when lacking kitchen staff due to the pai ($64,050) for purchase of Jail CCTV as Adjustment Prior Year's Revenue ($36,� Health Network (OCHN) report required reimbursement of duplicate payment for Dry Goods and Clothing $17,000, Corm $15,000, Interpreter Fees $10,000, Culii Recreational Supplies $10,000 due to ie 7,186,698.00 7,201,698.00 (15,000.00) -0.21% Unfay. Info Tech Operations ($65,000), Telephone Communications ($7,000) dt Tech Managed Print Services $31,000, Fuel Charges $15,000 due to less than $ 49,234,784.00 $ 49,587,487.80 $ 49,962,487.80 $ (375,000.00) -0.76% $ 17,141,452.00 $ 17,358,906.00 $ 13,358,906.00 $ 4,000,000.00 23.04% Fay. Salaries and Fringe Benefits of whi pandemic and related court closures (p� Reimbursement Court Services). Also, t positions and Overtime. Operating Expenditures 135,797.00 139,797.00 109,797.00 30,000.00 21.46% Fay. Laundry and Cleaning $25,000, Eq ADOPTED BUDGET Emergency Response and Preparedness Personnel Expenditures $ 3,482,163.00 $ Operating Expenditures Internal Support Expenditures Transfers Out Patrol Services Personnel Expenditures Operating Expenditures Internal Support Expenditures 1, 058, 056.00 452,038.00 COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE AMOUNT AMENDED FY 2021 FAVORABLE BUDGET FORECAST (UNFAVORABLE) PERCENT 3,522,757.00 $ 5,522,757.00 $ (2,000,000,00)-56.77% 1,603,674.56 1,393,674.56 210,000.00 13.09% 452,646.00 447,646.00 5,000.00 1.10% 0.00% $ 4,992,257.00 $ 5,579,077.56 $ 7,364,077.56 $ (1,785,000.00)-31.99% EXPLANATION OF SIG Unfay. Salaries and Fringe Benefits due Overtime caused primarily by offering a( class size as it relates to the CGVID-19 Fay. Fees Civil Service $130,000 which revenue. Also fay. Professional Service: $35,000, Auction Expense $10,000 and less than anticipated use; partially offsei Equipment ($22,600) due to purchase o COVID-19 pandemic and Equipment M, Fay. Info Tech Managed Print Services use; partially offset by unfav Telephone Tech Operations ($2,000) due to increa $57,564,505 $ 57,988,387.00 $ 55,638,387.00 $ 2,350,000.00 4.05% Fay. Salaries and Fringe Benefits of whi related event cancellation (offset by unf; Salaries). Also, the favorabllity includes offset by unfay. Overtime of which a por pandemic, restart of events and political 1,373,277.00 2,171,033.00 2,026,033.00 145,000.00 6.68% Fay. Other Expendable Equipment $75, Rental $15,000, Office Supplies $11,501 Gasoline $7,000 due to less than anticit 6,477,499.00 6,561,257.00 6,096,257.00 465,000.00 7.09% Fay. Motor Pool $275,000, Motor Pool F Communications $30,000 and Radio Cc anticipated use; partially offset by unfav ADOPTED BUDGET Emergency Communications Operations Personnel Expenditures $ 9,673,179.00 $ Operating Expenditures Internal Support Expenditures Transfers Out Investigative/Forensic Svcs Personnel Expenditures Operating Expenditures Internal Support Expenditures 204,100.00 286,178.00 COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE AMOUNT AMENDED FY 2021 FAVORABLE BUDGET FORECAST (UNFAVORABLE) PERCENT 9,903,274.00 $ 10,328,274.00 $ (425,000.00) -4.29% 314,900.00 306,900.00 8,000.00 2.54% 286,178.00 242,178.00 44,000.00 15,38% 0.00% $ 10,163,457.00 $ 10,504,352.00 $ 10,877,352.00 $ (373,000.00) -3,55% $ 9,419,275.00 $ 9,6247575.00 $ 9,264,575.00 $ 360,000.00 985, 512.00 1,151, 579.92 1, 059, 579.92 3,046,076.00 3,046,076.00 3,178,076.00 3.74% 7.99% (132,000.00) -4.33% EXPLANATION OF SIG Unfay. Overtime of which a portion is atl turnover and emergency salary position related Fringe Benefits due to vacart pc Fay. Equipment Maintenance $27,000 c offset by unfay. Other Expendable Equil replacement. Fay. Radio Communications $45,000 ar due to less than anticipated ($3,000) due to usage Fay. Salaries and Fringe Benefits due tc Overtime and related Fringe Benefits. Fay. Laboratory Supplies $175,000 whic Drug Testing revenue from reduced hog program due to the COVID-19 pandemic Software Support Maintenance $15,000 Supplies $10,000, Expendable EqulpmE Extradition Expense $5,000, Liquor and Professional Services $5,000, Printing $ $2,000 due to less than anticipated use; ($153,500) for ballistic vest replacement Prior Years Exp. ($15,400) for lab suppl (FAT) cell phones. Unfay. Info Tech Operations ($140,000) usage; partially offset by fay. Motor Poo CI FMIR R17 nnn Tplpnhnnp Cnmmi mi, COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE AMOUNT ADOPTED AMENDED FY2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT Department Total Personnel Expenditures $ 135,078,401.00 $ 136,369,097.00 $ 131,459,097.00 $ 4,910,000.00 3.60% Operating Expenditures $ 11,980,683.00 $ 13,667,583.86 $ 13,652,583.86 $ 15,000.00 0.11% Internal Support Expenditures $ 19,238,134.00 $ 19,551,614.00 $ 19,077,614.00 $ 474,000.00 2.42% Transfers Out $ 471,281.00 $ 842,621.00 $ 842,621.00 $ - 0.00% $ 166,768,499.00 $ 170,430,915.86 $ 165,031,915.86 $ 5,399,000.00 3.17% EXPLANATION OF SIG COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES CLERKIREGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT Administration Personnel Expenditures $ 624,618.00 $ 674,076.00 $ 614,076.00 $ 60,000.00 8.90% Operating Expenditures 29,100.00 29,100.00 16,100.00 13,000.00 44.67% Internal Support Expenditures 91,893.00 92,056.00 76,056.00 16,000.00 17.38% Transfers Out ------------------------- - - - - 0.00% $ 745,611.00 --------------------------- $ 795,232.00 -------------------------- -------------------------- $ 706,232.00 $ 89,000.00 11.190r'C County Clerk (Vital Stats & Legal Rec's) Personnel Expenditures $ 3,702,187.00 $ 3,817,617.00 $ 3,367,617.00 $ 450,000.00 1.79% Operating Expenditures 274,660.00 324,660.00 271,660.00 53,000.00 16.32% COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT Operating Expenditures 791,723,00 1,263,786.00 963,786.00 300,000.00 23.740/c Internal Support Expenditures 289,583,00 330,542.00 330,542.00 0.00% Transfers Out - - - - 0.000/� ------------------------------------------------------------------------------ ------------------------- $ 2,039,271.00 $ 2,785,301.00 $ 2,175,301.00 $ 610,000.00 21.90°4 Register of Deeds (and Micrographics) Personnel Expenditures $ 2,498,095.00 $ 2,586,258.00 $ 2,036,258.00 $ 550,000.00 21.27% Operating Expenditures 212,494.00 212,494.00 $ 154,494.00 58,000.00 27.29%� Internal Support Expenditures 280,565.00 283,218.00 $ 283,218.00 - 0.00% Transfers Out - - - - 0.00%. COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT Department Total Personnel Expenditures $ 7,800,142.00 $ 8,287,213.00 $ 6,912,213.00 $ 1,375,000.00 16.590/� Operating Expenditures 1,325,912.00 1,847,975.00 1,414,475.00 $ 433,500.00 �3.4n% Internal Support Expenditures 1,335,219.00 1,679,889.00 1,688,889.00 $ (9,000 00) -0.549,b Transfers Out - - 0.000 $ 10,461,273.00 $ 11,815,077.00 $ 10,015,577.00 $ 1,799,500.00 15.23`/ Administration Personnel Expenditures Operating Expenditures COUNTY OFOAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES COUNTY TREASURER AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT $ 3,550,959.00 $ 3,662,533.00 $ 3,262,533.00 $ 3,433,770.00 3,433,770.00 1,684,270.00 Internal Support Expenditures 1,131,410.00 Transfers Out Division Total Department Total 1,455,352.00 1,315,352.00 400,000.00 1, 749, 500.00 140,000.00 120,000.00 120,000, 00 120,000.00 ----------------------------------------------------------------------- --------------------------- $ 8,236,139.00 $ 8,671,655.00 $ 6,382,155.00 $ 2,289,500.00 ----------------------------------------------------------------------- ---------------------------- $ 6,236,139.00 $ 8,671,655.00 $ 6,382,155.00 $ 2,289,500.00 10.92% - Fay. d 50.95% - Fay.7 Civil S Recor less tl- u; ifavc Lind C 0.00% Fay. d C unlrf $ ,0J( 0.00% 26.40% 26.40% Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out COUNTY OFOAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES BOARD OF COMMISSIONERS AMOUNT ADOPTED AMENDED FY2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT $ 3,229,714.00 $ 3,278,680.00 $ 3,128,680.00 $ 150,000.00 872,150.00 3,703,397.60 $ 3,567,997.60 135,400.00 627,380.00 737,797.00 $ 782,797.00 25,958.00 25,958.00 (45,000.00) $ 4,729,244,00 $ 7,745,832.60 $ 7,505,432.60 $ 240,400.00 4.58% - Fay. primarily due 3,66% - Fay. Computer ate Personal k/lileage Periodicals Books and Binding $ !;u( ($2,000). -6.10% Unfay. IT Operatic equipment/service partially offset by I anticipated use. 3,10% Department Total Personnel Expenditures $ 3,229,714.00 $ 3,278,680.00 $ 3,128,680.00 $ 150,000.00 4.58% Operating Expenditures 872,150.00 3,703,397,60 3,567,997.60 135,400.00 3.66% Internal Support Expenditures 627,380.00 737,797.00 782,797.00 (45,000.00) -6.10% Transfers Out - 25,958.00 25,958.00 $ 4,729,244.00 $ 7,745,832.60 $ 7,505,432.60 $ 240,400.00 3.10% ADOPTED AMENDED BUDGET BUDGET ---------- 18.00 $ 228,118.00 $ Water Resource CO '$ 228,1 ssioner Personnel Expenditures 287,975.00 operating Expenditures Internal Support Expenditures 7,226,628.00 257,975.00 COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES WATER RESOURCES COMMISSIONER AMOUNT FY 2021 FAVORABLE FORECAST N—MNNFAVORABL5,, PERCENT 228,118.00 $ 7,428,633.00 0 Unfav - Co' lt (6,640.00) 2.31°lo ract interceptor Com 294,615.00 Consultants ($1 Adjustment Prior paid in FY 2021 result to display Fav - Office Sup employees work Travel and Conf' Fav - Profession related to soli er result of Sail Erc soil erosion grog Equipment Expe anticipated budg 0.13°lo Fav - Drain Equi 7,418,633.00 10,000.00 anticipated budg p gym+n� onae` �xPenditures Pers OPerat�n9 ExPend�tures lnternatgupp ,Expenditures Iranster Out p0apTEo B0,DGf-'T r tAN� OF Pp'lER 2d21 q wollUREsNIS F`l e T- EX�Ct}tl oour1i GQ�N F �pak"E AO F� 2fl2� NNFp��Rpgt.�l pMEApf-D FpR�Gps� p0 gU� �E� 150,000. .. 2132168 p0 $ 2,63�'27g p0 $ 26B 351 p0 5 2,2g2,16$.00 2,3g051 p0 414,629'00 2,441,351.00 5'2g8,5pg.00 $ �43,5p0.00i 5,213 009 00 � .1.61G' �31,000 00) 5y50p .00 Corporation Counsel Personnel Expenditures Operating Expenditures Internal Support Expenditures COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES COUNTY EXECUTIVE AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENI $ 2,831,546.00 $ 2,940,475.00 $ 2,740,475.00 $ 81,045.00 313,925.00 87,045.00 369, 823.00 74,045.00 355.823,00 200,000.00 6.80`, 13,000.00 14.93° 14,000.00 0.79`, Transfer Out ---------------------------------------------------------------------------------- ----------------------------- $ 3,226,516.00 $ 3,397,343.00 $ 3,170,343.00 $ 227,000.00 Office of Public Communications Personnel Expenditures $ $ 1,039,799.00 $ 1,039,799.00 $ Operating Expenditures $ $ - $ - $ 6. W, COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES MANAGEMENT AND BUDGET AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT Administration Personnel Expenditures $ 194,170.00 $ 230,086.00 $ 200,086.00 $ 30,000.00 13.04% Fav beg'. Operating Expenditures 4,017.00 4,017.00 4,017.00 - 0.00% Internal Support Expenditures 65,970.00 65,970.00 65,970.00 0.0011110 ------------------------ $ 264,157.00 --------------------------- $ 300.073.00 ------------------------------------------------------- $ 270,073.00 $ 30,000.00 10.00% Equalization Personnel Expenditures $ 8,883,574.00 $ 9,144,411.00 $ 8,744,411.00 $ 400,000.00 4.37% Fav to vi Operating Expenditures 421,404.00 421,404.00 281,404.00 140,000.00 33.22% Fav P;:1 M e r less Internal Support Expenditures 994,099,00 1,287,971.00 1,287,971.00 0.00% Transfers Out ------------------------ - --------------------------- -------------------------- - ---------------------------- 0.00010 $10,299,077.00 $10,853,786.00 $ 10,313,786.00 $ 540,000.00 4.98% Fiscal Services Personnel Expenditures $ 8,290,188.00 $ 8,617,881.00 $ 8,067,881.00 $ 550,000.00 6,38% Fav to ti Internal Support Expenditures Transfers Out ADOPTED BUDGET 1,790,192.00 AMENDED BUDGET 2,057,804.00 COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES MANAGEMENT AND BUDGET AMOUNT FY 2021 FAVORABLE FORECAST (UNFAVORABLE) PERCENT 2,049,804.00 $ 8,000.00 0.39% Fav an-6 0.00% ---------------------------------- $ 10,434,680.00 $ 11,054,264.00 $ 10,503,864.00 $ 4.98% 550,400.00 Purchasing Personnel Expenditures $ 1,173,345.00 $ 1,216,535.00 $ 1,216,535.00 $ - 0.009; Operating Expenditures 12,225.00 20,654.43 $ 12,654,43 $ 8,000.00 38.73°,c F— use, Internal Support Expenditures 707,738.00 708,927.00 $ 706,927.00 $ 2,000.00 0.28% Fav anti( Transfers Out - - - - 0.00% --------------------------------------------------- $ 1,893,308,00 $ 1,946,116.43 ------------------------------------------------------- $ 1,936,116.43 $ 10,000.00 0.51% Department Total Personnel Expenditures $ 18,541,277.00 $ 19,208,913.00 $ 18,228,913.00 $ 980,000.00 5,10% Operating Expenditures 791,946.00 824,654.43 684,254.43 140,400.00 17.03% Internal Support Expenditures 3,557,999.00 4,120,672.00 4,110,672.00 10,000.00 0.24% Transfers Out - - 0.000,% $ 22,891,222.00 $ 24,154,239.43 $ 23,023,839.43 $ 1,130,400.00 4.68°ib Administrative Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out Support Services Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out COUNTY OFOAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES CENTRAL SERVICES AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT $ 236,503.00 $ 246,245.00 $ 246,245.00 $ O.OG;b 3,298.00 3,298.00 3,298.00 0.00O/C 11,743.00 11,743.00 8,643.00 3,100.00 26.403o - Fav ----------------------- $ 251,544.00 ------------------------ $ ------------------------- 261,286.00 $ 258,186,00 -------------------------- --- $ 3,100.00 --------------- 1.19°10 $ 1,250,533.00 $ 1,286,520.00 $ 1,129,920.00 $ 156,600.00 12.1790 - Fav part Pro( Sec 330,825.00 330,825.00 325,825.00 5,000.00 1.51 °,D - Fav anti( 743,425.00 755,975.00 755,975.00 - 0.00%0 ----------------------- - ------------------------ - ------------------------- - ------------------------------ 0.00% --------------- Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Facilities Engineering Personnel Expenditures Operating Expenditures Internal Support Expenditures Department Total COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES FACILITIES MANAGEMENT AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT $ 22-1,949.00 $ 231,691,00 $ 231,691,00 $ 0,00% 2,687.00 2,687.00 1,687,00 1,000.00 37.220,o Fav, Mlei as a rest 11,197.00 11,197.00 13,197.00 (2,000.00) -17.861/0 U nfay. p ---------------------- ---------------------- usage a: $ 235,833.00 $ 245,575.00 --------------------------- ------------------------- $ 246,575.00 $ (1,000.00) -0.41% $ 867,043.00 $ 905,855.00 $ 805,855.00 $ 100,000.00 11.04% Fav, due 276,027.00 617,996.70 500,496.70 117,500.00 19.01% Fay. Pro associat via M.R. Training pande ini 120,305.00 120,706.00 100,706.00 20,000.00 16.57% Fay. prin usage. $ 1,263,375.00 $ 1,644,557.70 $ 1,407,057.70 $ 237,500.00 14.44% N A noo nn0 nn 0` 4 40� CAC nn N A now CAn- nn a` Ann nnn nn O 7no/ ADOPTED BUDGET COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES HUMAN RESOURCES AMOUNT AMENDED FY 2021 FAVORABLE BUDGET FORECAST (UNFAVORABLE) PERCENT Administration Personnel Expenditures $ 749,996.00 $ 763,823.00 $ 618,823.00 $ 145,000.00 18.98% Fay voP (VE Operating Expenditures 251,243.00 701,243.00 381,243.00 320,000.00 45.63% Fa\, $1C anc acii Pat, Internal Support Expenditures 79,616.00 81,400.00 81,400.00 0.00% Transfers Out ------------------------------------------------------------------------------------------------------------------------ - - _ $ 1,080,855.00 $ 1,546,466.00 $ 1,081,466.00 $ 465,000.00 3 0. 0 % Workforce Management Personnel Expenditures $ 2,290,793.00 $ 2,383,419.00 $ 2,383,419,00 $ - 0.00% Operating Expenditures 314,358.00 356,116,00 251,116,00 105,000,00 29,48% Fae ExF anc anti for Internal Support Expenditures 1,109,056.00 1,234,585.00 1,234,585.00 U.00%, ------------------------------ $ 3,714,207.00 ------------------------------ $ 3,974,120.00 ------------------------------ $ -------------------------- 3,869,120.00 $ 105,000.00 2,64% ratroki re$ PAM.l , onexPen�rtu pets ce\ er��tures OPeratM(3 �XP A��Gel 4 ?36'668 p0 na\ SuPP° exPef\&kures \rater Ir3rNs{ers Out Ne Pe�sOn�e\ �xPer�\tures O p`K�'F� olkR' coul", QDp'R�� SR F`l ,Z421 I EXM JAok t R sr '41ces NEp,-IkA QND SUM PMpDtkl E CE O g4 pER \r� �,peNDF.D 230.g16 p0 4,343'Zg3 p0 FpvD RPg\-EI f OIR 230,g16 p0 $ 2,068'4©0 00 $ 22�4,B 00 13,41�' DO 16,416 p0 2,51C3 p0 "56 b,J34,00 $ $ 28 616 24 $ 4 33'116,24'f 00 2g711,122p0 A 9 3 Poo ,)0 2,0� 1 '4p0 00 4,5130 Poo 00 , 45.12°/° COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES AMOUNT FY 2021 FAVORABLE PERCENT ADOPTED AMENDED FORECAST (UNFAVORABLE) BUDGET BUDGET ---.,_---- ._--- ------ ~--------- .._-_-_Nw ------ ~-------- H~~~ 4-----5.00 ~~-- __7,165,004.25 3,830,604.25 3,334,400.00 46.54% Operating Expenditures Internal Support Expenditures 3,263,260.00 3,720,055.00 4,052,055.00 332,000.00) -8.92% ADOPTED BUDGET Operating Expenditures 294,667.00 Internal Support Expenditures 559,468.00 Transfers Out - -------------------------- $ --- 1,753,762.00 $ MSU Extension - Oakland County Personnel Expenditures $ 520,795.00 $ Operating Expenditures 303,035.00 Internal Support Expenditures 286,147.00 COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES AMOUNT AMENDED FY 2021 FAVORABLE BUDGET FORECAST (UNFAVORABLE) PERCENT $ - #Dl\1";01 1,412.00 $ 1,412.00 0.00% 1,412.00 $ 540,059,00 $ 303,035.00 286,230.00 1,412.00 $ 511,759.00 $ 290,535.00 270,730.00 28,300.00 12,500.00 15,500.00 0.00°/b 5.24% 4.12% 5.42% Transfers Out COUNTY OFOAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PER"CL NT Department Total Personnel Expenditures $ 31,352,718.00 $ 33,887,222.00 $ 29,358,922.00 $ 4,528,300.00 13.36% Operating Expenditures $ 9,297,305.00 $ 11,836,332.25 $ 6,421,032.25 $ 5,415,300.00 45.750/c Internal Support Expenditures $ 4,117,767.00 $ 4,024,113.00 $ 4,337,613.00 $ (313,500.00) -7.79% Transfers Out $ 589,161.00 $ 1,214,983.00 $ 1,214,983.00 $ - 0.00% $ 45,356,951.00 $ 50,962,650.25 $ 41,332,550.25 $ 9,630,100.00 18,Go,11,o Public Services - Admin. Personnel Expenditures Operating Expenditures Internal Support Expenditures Community Corrections Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPL $ 236,586.00 $ 246,328.00 218,328.00 $ 28,000.00 11.37% Fay. due to 4,800.00 4,800.00 1,800.00 3,000.00 62.50% Fay. d',:c'ro Conference than ant:16,1- 6,144.00 6,144.00 6,144.00 --------------------------------------------------- -------------------------------------------------- $ 247,530.00 $ 257,272.00 $ 226,272.00 $ 31,000.00 $ 4,046,942.00 $ 4,171,498.00 3,822,498.00 $ 349,000.00 472,025.00 472,025.00 288,025.00 184,000.00 531,711.00 613,628.00 663,628.00 (50,000.00) ----------------------------------------------------------------------------- ------------------------ $ 5,050,678.00 $ 5,257,151.00 $ 4,774,151.00 $ 483,000.00 0.00% 12.05% 8.37% Fay. due to 38.98% Fay. Ccci l,a( and Printing favorable Try restrictions a -8.15% Unfay. Info 1 Communical COVID 19 pi 0.00% - 9.19 Medical Examiner COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPL Operating Expenditures 394,286.00 837,806.00 687,246.00 150,560.00 17.97% Fay. Mainter Internal Support Expenditures Transfers Out Circuit Court Probation Personnel Expenditures Operating Expenditures Internal Support Expenditures Children's Village Personnel Expenditures 1,093,573.00 1,127,694.00 1,097,694.00 30,000.00 ----------------------------------------------------------------------------- ------------------------ $ 4,067,862.00 $ 4,661,915.00 $ 4,221,355.00 $ 440,560.00 54,326.00 569,149.00 54,326.00 569.674.00 remaining to Contracted longer havin, to clean shel than anticioe 2.66% Fay. Motor F Communicai $8,000 due t 9.45% 0.00% 13,326.00 41,000.00 75.47% Fav, Of;ce 11 Printing $5,0 544,674.00 25,000.00 4.39% Fay. info Tec anticipated u $ 623,475.00 $ 624,000.00 $ 558,000.00 $ 66,000.00 $ 18,702,310.00 $ 19,170,555.00 $ 16,670,555.00 $ 2,500,000,00 10.58% 13.04% Fav, due to \ being redepl tracing. Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES ECONOMIC DEVELOPMENT AMOUNT ADOPTED AMENDED FY2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT $ 1,683,096.00 $ 1,367,830.00 $ 1,317,830.00 $ 442,222.00 454,588.65 262,588.65 109,490.00 115,572.00 115,572.00 $ 2,234,808.00 $ 1,937,990.65 $ 1,695,990.65 $ 50,000.00 3.66% 192,000.00 42.24% 242,000.00 Local Business Development Division (FKA PEDS) Personnel Expenditures $ 4,182,544.00 $ 1,925,848.00 $ 1,925,848.00 $ Operating Expenditures 1,196,032.00 16,877,732.00 17,701,532.00 (823,800.00) 0.00% 12.49% Fay. due Fay. Prcfi Printing $ $12,OCO, Meetings anticipate Unfay. RE small bus $1,500,OC Also, unfE Purchase rnore that Services RecruitmE Advertisir $30,000, ADOPTED BUDGET Business Development Personnel Expenditures $ - Operating Expenditures Internal Support Expenditures Transfers Out COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT EXPENDITURES ECONOMIC DEVELOPMENT AMOUNT AMENDED FY 2021 FAVORABLE BUDGET FORECAST (UNFAVORABLE) PERCENT $ 2,042,427.00 $ 1,842,427.00 $ 300.00 23,000.00 1,300,000.00 1,300,000.00 $ - $ 3,342,427.00 $ 3,165,727.00 $ Workforce Development (Includes Veteran's Services) Personnel Expenditures $ 1,676,895.00 $ 1,782,179.00 $ 1,582,179.00 $ Operating Expenditures 189,624.00 1,965,460.00 1,919,960.00 $ Internal Support Expenditures Transfers Out 208,143.00 219,920.00 225,920.00 200,000.00 (300.00) (23,000.00) 176, 700.00 200,000.00 45,500.00 (6,000.00) Fay. due Unfay. PE Unfay. In! Communi Economic offset in L 0.00% 5.29% 11.22% Fay. due Fay. Due and Soidi anticipate Projects ( than antic Unfay. Ini anticipate less than (Z 7 n7a Fr,) nn Q 2 Qr,7 FFa nn G '2 7952 nFa nn Q 7`2a Fnn nn a naoi �mer�en�Y personne O9 eret�n9 Expenditures NU CpUN� ofCu TBRRBp�R� �C { N�MEt`�NU SAC, BNCY MAN�C'BMBN� PN ��a�N� E 0�,ar PoBNpED - """" 452 00 "" g6 , � 2g7 ,g43 00 nternai gupp°d' eOenditures 1 lransjers out FY 2p2� t�NpA��R�B �1A6,gp0 OOl 444,g43 p0 g07 ,315 p0 1 g6g ,710.00 2,045,110.00 `1 5p0 00) _ �17 5 4p0 00� _0 25°/° r- NON -DEPARTMENT APPROPRIATIONS COUNTY OPERATIONS Salary Turnover Factor $ Fringe Benefit Turnover Factor Insurance Fund Insurance Surety Bonds Logos Trademarks Intellect Property Road Commission\Current Drain Assessment Road Commission\Tri Party Agreement Professional Services Provisions Transfer to Community Mental Health Authority Transfer to Municipalities Total $ COUNTY BUILDINGS $ STATE AND FEDERAL - COUNTY ASSOCIATIONS Michigan Assoc. of Counties $ National Assoc. of Counties S.E.M.C.O.G. Traffic Improvement Association Total $ SUNDRY EXPENSE ADOPTED BUDGET (6,000,000.00) $ (4,000,000.00) 401,413.00 33.305.00 20,000.00 1,450,000.00 100.00 30,000.00 9,620,616.00 1,555,434.00 $ 2,492,736.00 $ 73,000.00 $ 24,100.00 540, 000.00 30, 000.00 667,100.00 $ 300,000.00 $ COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT NON -DEPARTMENTAL EXPENDITURES AMENDED BUDGET (6,000,000.00) (4, 000, 000.00) 401, 413.00 33,305.00 20,000.00 1,450, 000.00 3,009,242.00 175, 000.00 223, 530.00 9,620,616.00 31,945,983.00 36,879,089.00 $ 2,060,819.00 $ 73,000.00 $ 24,100.00 540, 000.00 30,000.00 667,100.00 $ 300,000.00 $ FY 2021 FORECAST (7,900,000.00) $ 401,413.00 3,305.00 20, 000.00 1,450,000.00 2, 509, 242.00 1,758,002.00 3,180, 860.00 9,620,616.00 31, 945, 983.00 42,989,421.00 $ 2,060,819.00 $ 73,000.00 $ 24,100.00 540,000.00 30,000.00 667,100.00 $ 300,000.00 $ AMOUNT FAVORABLE (UNFAVORABLE) 1,900,000.00 (4,000 000.60) 30.000.00 500,000,00 (1,583,002.00) (2,957,330.00) (6,110,3s2.00) Private Institutions Foster Care Private Institutions Residential Radio Communications Regranting Program Salary Adjustment Reserve Special Projects State Institutions Substance Abuse Coord Agency Summer Employees Salary Appropriation Supportive Services Total Transfers to Other Funds Fire Records Management CLEMIS Radio Communications Information Technology Bldg Auth Fac Infras IT Debt Project Work Order Fund Building Fund 52/1 District Court Probation Drug Court Grant HR - Financial System Replacement Project 52/3 District Court Probation Drug Court Grant TOTAL NON-DEPT. APPROPRIATIONS COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT NON -DEPARTMENTAL EXPENDITURES AMOUNT ADOPTED AMENDED FY2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) 365,144.00 365,144.00 365,144.00 105,356.00 105,356.00 105,356 00 975,000.00 (200,000,00) (200,000.00) - 49,245,389.00 49,245,389.00 500,000.00 - 10,000,000.00 2,000,000.00 8,000,000.00 604,971.00 604,971,00 604,971.00 4,787,165.00 4,787,165.00 4,787,165.00 - 250,000.00 231,296.00 231,296.00 29,849,847.00 29,849,847.00 - $ 11,052,985.00 $ 97,981,928.00 $ 87,047,185.00 $ 10,934,743.00 $ 507.699.00 $ 507,699.00 507,699.00 - 1,644,186.00 1,894,686.00 1,894,686.00 - 3,061,480.00 3,061,480.00 - 3,620,676.00 5,258,400.00 5,258,400.00 - 2,209,750.00 2,209,750.00 2,209,750.00 - 1,243,500.00 1,243,500.00 - 3,000,000.00 3,993,052.00 3,993,052.00 - 9,405.00 9,405.00 - 5,200,000.00 5,200,000.00 - 7,478.00 7,478.00 - $ 10,982,311.00 $ 23,385,450.00 $ 23,385,450.00 $ $ 27,050,566.00 $ 161,274,386.00 $ 156,449,975.00 $ 4,824,411,00 PER, FY 2021 BUDGET AMENDMENTS FY 2021 BUDGET AS ADOPTED - GENERAL FUND/GENERAL PURPOSE FUNDS BUDGET AMENDMENTS M.R.#20447 10/21/2020 BOC Tri-Party Road Improvement Program Fiscal Year 2021 Appropriation - Charter Township of Bloomfield - Resurfacing of Maple Road from Inkster Road to Franklin Road - Project No. 55341 M.R.#20452 10/21/2020 BOC School Drinking Water Station Program - Fiscal Year 2021 Appropriation and Reallocation of County CARES Act Coronavirus Relief Funds M.R.#20457 10/2112020 Sheriffs Office Contract Amendment #2 for Law Enforcement Services in the Charter Township of Lyon 2019-2021 M.R. #20458 10/21/2020 Clerk/Register of Deeds - Delete and Create Positions M.R.#20461 10/21/2020 County Executive - Transfer and Create the Emergency Management and Homeland Security Department Under the County Executive's Administration M.R.#20462 10/21/2020 Economic Development and Community Affairs - Reorganization of Divisions and Positions M.R. #20463 10/21/2020 County Executive - Acceptance of the County Executive Plan to Partner with the Community Foundation for Southeast Michigan on a Community Policing Innovations Fund for Oakland County Communities M.R. #20470 10/21/2020 Board of Commissioners - Expedited Acceptance of Grant Award from the Center of Civic Tech and Civic Life (CTCL) to Support County Preparation and Promotion of a Safe and Secure Election M.R.- 11/19/2020 Board of Commissioners - Tri-Party Road Improvement Program (Planned Use of Fund Balance) M.R. #20515 Charter Township of Bloomfield $ M.R. #20516 Township of Groveland $ M.R. #20517 Township of Waterford $ M.R. #20518 Township of Lyon $ M.R. #20523 11119/2020 Central Services Fleet Expansion of (1) Vehicle for Emergency Management and Homeland Security M.R. #20526 11/19/2020 Board of Commissioners Approval of Additional Appropriation for the 2020/2021 School Drinking Water Station Program M.R. #20557 11/19/2020 FIR - Water Resources Commissioner's Classifications Salary Adjustments $ M.R. #20559 11/1912020 County Executive/Information Technology Public Safety Transparency Dashboard Project (CLEMIS) M.R. #20564 11/19/2020 Prosecuting Attorney FY 2021 Crime Victim Rights Grant Acceptance FY 2021 BUDGET AMENDMENTS M.R.#20567 11/19/2020 Sheriffs Office FY 2021 Joint Terrorism Task Force (JTTF) - Grant Acceptance M.R. #20568 11/19/2020 Sheriffs Office - FY 2021 Oakland County Gang and Violent Crime Safe Streets Task Force (SSTF) - Grant Acceptance M.R. #20570 11/19/2020 Sheriffs Office - FY 2020 Bulletproof Vest Partnership (BVP) Program - Grant Acceptance M.R. #20575 11/19/2020 Animal Shelter and Pet Adoption On-line Dog License Fee Schedule M.R. #20577 11/19/2020 Economic Development and Community Affairs - United States Economic Development Administration (U.S. EDA) CARES Act Recovery Assistance Acceptance M.R. #20625 12/7/2020 County Executive Capital Improvement Program Study Ki E 11 M.R. #20632 12/7/2020 Management & Budget/Human Resources Department /County Executive - Compliance Office - Financial and Human Capital Management System Replacement Project Implementation Extension $ M.R. #20635 12/7/2020 Management & Budget FY 2020 Year End Report and Budget Amendments Encumbrances $ 571,910.21 Carry Forwards $ 14,074,942.00 Adjustments to Circuit Court $ 8,000.00 Adjustments to Children's Village $ 45,662.00 Adjustments to Health Division $ 31,143.00 Adjustments to Non -Departmental $ 127,533,618.00 $ M.R. #20638 12/7/2020 Board of Commissioners - Reorganization of Units and Positions $ M.R. #20369 12/7/2020 Health and Human Services/Health Division - Continuations of the Oakland Together School Nurse Program in Partnership with Oakland Schools M.R. #20647 12/7/2020 Sheriffs Office - Contract Amendment #2 for Law Enforcement Services in the Charter Township of Highland 2019 - 2021 M.R. #20648 1217/2020 Sheriffs Office - Contract Amendment #3 for Law Enforcement Services in the Charter Township of Lyon 2019 -2021 M.R. #20649 12/7/2020 Sheriffs Office - Contract Amendment #2 for Law Enforcement Services in the Charter Township of Orion 2019 -2021 M.R. #20653 12/7/2020 Sheriffs Office - 2020 Law Enforcement Services Agreement with the Somerset Collection LP I M.R. #20582 12/7/2020 Board of Commissioners - Authorization of a Forensic Audit of Management of County Property Tax Foreclosures FY 2021 BUDGET AMENDMENTS M.R.#20661 12/7/2020 County Executive - Approval of a Request for Proposal to Enter Into Professional Services Contracts for Strategic Planning and an Equity Audit to Improve County Government Services M.R. #20664 12/7/2020 Board of Commissioners — Reallocation of Coronavirus Relief Funds to Create Oakland Together Restaurant Rescue Program M.R.#21016 12/7/2020 Sheriffs Office - Contract Amendment #2 for Law Enforcement Services in the Charter Township of Oxford 2019 -2021 $ M.R.-2/04/2021 Board of Commissioners - Tri-Party Road Improvement Program (Planned Use of Fund Balance) M.R. #21025 Charter Township of West Bloomfield $ M.R. #21026 Charter Township of Oxford $ M.R.#21033 214/2021 County Executive Acceptance of the Michigan Department of Treasury Public Safety and Public Health Payroll Reimbursement Program Additional Grant Acceptance $ M.R.#21036 2/4/2021 Health and Human Services/Emergency Management and Homeland Security - 2021 Oakland Together Pandemic Response Intiative and Ad Hoc Committee $ M.R. #21040 2/18/2021 Board of Commissioners - Tri-Party Road Improvement Program Fiscal Year 2021 Appropriation - City of Auburn Hills - Traffic Signal Upgrade Work and Installation of a Pedestrian Crossing on Baldwim Road Adjacent to Great Lakes $ M.R. #21049 2/18/2021 Sheriffs Office - FY 2021 Traffic Safety Enforcement - Grant Acceptance $ M.R. #21052 2/18/2021 Facilities Management - Facilities Maintenance and Operatons/Prosecutor's Office - Various Prosecutor's Office Upgrades Project $ M.R. #21057 3/11/2021 Board of Commissioners - Partial Funding for Demolition of the Former Electro-plating Services Company Buildings Located at 901-959 East 10 Mile road in the City of Madison Heights $ M.R. #21058 3/11/2021 Board of Commissioners - Tri-Party Road Improvement Program (Planned Use of Fund Balance) M.R. #21058 Charter Township of Bloomfield $ M.R. #21060 3/1112021 Facilities Management - Facilities Planning and Engineering/Sheriffs Office - Approval of Lease Agreement for Expanded Use of Training Center Building M.R. #21068 3/1112021 Human Resources — Fiscal Year 2020 Wage Reopener for Employees Represented by the Governmental Employees Labor Councel (GELC) FY 2021 BUDGET AMENDMENTS M.R.#21081 3/11/2021 Information Technology - Approval of Public Safety Communications First Responder GPS Safety Channel and Governmental (Non -First Responder) Radios M.R. #21082 3/1112021 Information Technology - Approval of Public Safety Communications System Countywide Public Safety Answering Point Voice -Data -Audio Recording/Archive System M.R. #21056 3/11/2021 Board of Commissioners - Improve Access and Provide Express Delivery of Death Certificates Issued by the Oakland County Clerk's Office to Funeral Homes M.R.- 3/25/2021 Board of Commissioners - Tri-Party Road Improvement Program (Planned Use of Fund Balance) M.R. #21085 Charter Township of Milford M.R. #21086 Charter Township of White Lake M.R. #21091 - 03/25/2021 Management & Budget FY 2021 First Quarter Report Adjustments to Health $ (83,283.00) Adjustments to Child Care Fund $ 25.00 Adjustments to Sheriffs Office $ 28,139.00 Adjustments to Public Services - Animcal Control $ 385,020.00 Adjustments to Non -Departmental $ 50,000.00 $ M.R. #21096 3/25/2021 Human Resources - Fiscal Year 2020 Wage Reopener for Employees Represented by the Michigan American Federation of State, County, Municipal Employees, Council 25, Local 2437 (AFSCME) M.R.#21101 3/25/2021 Sheriffs Office - Establishment of Dispatch Services Agreement Rates - April 1, 2021 through March 31, 2024 M.R. #21131 3/25/2021 Facilities Management/Facilities Planning and Engineering - County Executive - Campus Sustainability, Planning Project $ M.R. #21136 4/29/2021 Board of Commissioners - Tri-Party Road Improvement Program Fiscal Year 2021 Appropriation - Township of Rose - Spreading Gravel and Chloride on Varaious Roads - Project No. 56212 M.R. #21153 4/29/2021 Sheriffs Office/Information Technology- Jail Closed Circuit Television (CCTV) Video Storage Improvements Project M.R.#21154 4/29/2021 Sheriff's Office - Acceptance of a Donation for the Purchase of a K-9 Dog M.R. - 5/13/2021 Board of Commissioners - Tri-Party Road Improvement Program (Planned Use of Fund Balance) M.R. #21178 - Charter Township of Highland M.R. #21174 5/13/2021 Board of Commissioners - "OAKSTEM 2021" Street Tree Enhancement Matching Grant Pilot Program M.R. #21194 5/26/2021 FY 2021 BUDGET AMENDMENTS M.R. #21195 5/26/2021 Economic Development/Workforce Development and Veterans Services Division - Reorganization of Positions M.R.#21204 5/26/2021 Central Services/Sheriffs Office - Fleet Changes and Expansion of Seven (7) Used Vehicles for Sheriffs Office Training $ M.R. #21203 5/26/2021 Human Resources and Management and Budget - Budget Amendment for Salary Administration Plan Approved with M.R. #20659 M.R.- 6/17/2021 Board of Commissioners - Tri-Party Road Improvement Program (Planned Use of Fund Balance) M.R. #21214 - Township of Addison $ 18,794.00 M.R. #21215 - City of Birmingham $ 72,068.00 M.R. #21216 - Township of Holly $ 25,000.00 M.R. #21217 - City of Troy $ 394,031.00 M.R. #21218 - Charter Twp of Waterford $ 300,000.00 M.R. #21219 - Charter Twp of West Bloomfield $ 50,000.00 $ M.R.- 6/17/2021 Board of Commissioners - Local Road Improvement Program (Planned Use of Fund Balance) M.R. #21220 - City of Auburn Hills $ 89,575.00 M.R. #21221 - City of Berkley $ 39,245.00 M.R. #21222 - Village of Beverly Hills $ 26,044.00 M.R. #21223 - City of Bloomfield Hills $ 15,767.00 M.R. #21224 - Village of Clarkston $ 3,050.00 M.R. #21225 - City of Clawson $ 29,588.00 M.R. #21226 - City of Farmington $ 20,241.00 M.R. #21227 - City of Farmington Hills $ 203,309.00 M.R. #21228 - City of Ferndale $ 55,844.00 M.R. #21229 - City of Hazel Park $ 53,074.00 M.R. #21230 - City of Huntington Woods $ 14,238.00 M.R. #21231 - City of Keego Harbor $ 5,182.00 M.R. #21232 - City of Lake Angelus $ 264.00 M.R. #21233 - Village Lake Orion $ 8,627.00 M.R. #21234 - City of Lathrup Village $ 21,761.00 M.R. #21235 - Village of Leonard $ 3,191.00 M.R. #21236 - City of Madison Heights $ 84,216.00 M.R. #21237 - Village of Milford $ 22,349.00 M.R. #21238 - City of Novi $ 121,445.00 M.R. #21239 - City of Oak Park $ 69,171.00 M.R. #21240 - City of Orchard Lake $ 5,215.00 M.R. #21241 - Village of Ortonville $ 5,119.00 M.R. #21242 - Village of Oxford $ 13,075.00 M.R. #21243 - City of Pleasant Ridge $ 9,497.00 M.R. #21244 - City of Pontiac $ 211,071.00 M.R. #21245 - City of Rochester $ 27,819.00 M.R. #21246 - City of Rochester Hills $ 126,268.00 M.R. #21247 - City of Royal Oak $ 207,080.00 M.R. #21248 - City of South Lyon $ 16,177.00 M.R. #21249 - City of Southfield $ 194,731.00 M.R. #21250 - City of Sylvan Lake $ 4,403.00 M.R. #21251 - City of Troy $ 210,238.00 FY 2021 BUDGET AMENDMENTS M.R. #21252 - City of Walled Lake M.R. 421253 - City of Wixom M.R. #21254 - Village of Wolverine M.R. #21259 - 06/1712021 Management & Budget FY 2021 Second Quarter Report Adjustments to Circuit Crt Adjustments to Board of Commissioners Adjustments to Sheriffs Office Adjustments to Public Services - Economic Development Adjustments to Non -Departmental M.R. #21261 06117/21 Sheriffs Office - 2021 High Intensity Drug Trafficking Areas (HIDTA) - Grant Acceptance M.R.#21277 06/17/21 15, 388.00 37,140.00 8,783.00 235,200.00 (300,000.00) 173,129.00 1,000, 000.00 52,627.00 $ Human Resources - Fiscal Year 2020 Wage Reopener for Employees Represented by the Oakland County Employees Union, Affiliated with International Brotherhood of Electrical Workers $ M.R.#21170 06/30/21 Board of Commissioners - Source of Income Protection to Prohibit Housing Discrimination in Oakland County M.R.#21285 06/30/21 Human Resources - Salary Administration Plan 2nd Quarterly Report for FY 2021 M.R.#21286 06/30/21 Board of Commissioners - Appropriation for the Apportionment of Oakland County Commissioner Districts Total Amended Budget as of June 30, 2021 $ GRANTS ACCEPTED $10,000 AND UNDER (approved administratively, per M.R. #19006) Department or Division Grant Title Award/Amendment IQuarter in Animal Control & Pet Adoption Bissell Empty the Shelters Grant May 5-7 2021 $ 1,500.00 Q3/FY21 Parks & Recreation 2021 US Forest Service Reducing Runoff in the Rouge River AOC Grant $ 7,500.00 03/FY21 Emergency Management and Homeland Security 2021 Hazardous Materials Emergency Preparedness Planning Program $ 8,025.00 Q3/FY21 COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT ENTERPRISE FUND TREASURER'S OFFICE ADOPTED AMENDED FY 2021 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) DELINQUENT TAX REVOLVING FUND 51600 REVENUES Charges for Services $10,600,000.00 $10,600,000.00 14,460,000.00 $ 3,860,000.00 Other Revenues 2,000,000.00 2,000,000.00 600,000.00 (1,400,000.00) Total Revenues $12,600,000.00 $12,600,000.00 $15,060,000.00 $ 2,460,000.00 OPERATING EXPENSES Personnel Expenditures $ 221,263,00 $ 232,886,00 $ 187,886.00 45,000 00 Operating Expenditures 394,555.00 394,555.00 264,555,00 130,000.00 Interest Expense 943,750,00 943,750,00 0.00 943,750.00 Transfer Out to Other Funds: General Fund - Collection Fees 2,300,000.00 2,300,000.00 2,300,000.00 - GF - Non -Departmental 3,000,000.00 3,000,000.00 3,000,000.00 - Work Release Facility Refunding Debt Svc 1,566,300,00 1,566,300.00 1,566,300.00 - Office Bldg Renovation Refunding Debt Svc 1,866,400.00 1,866,400.00 1,866,400.00 - 52-3 District Court Refunding Debt Svc 1,311,300.00 1,311,300.00 1,311,300.00 - 1 n nn n nnn nn Q An n A A nnn nn Q 4 n n n n nnn nn 2 ADOPTED AMENDED BUDGET BUDGET DELINQUENT PERSONAL PROPERTY TAX (51800) OPERATING REVENUE $508,689.00 $520,343.00 OPERATING EXPENSE NET OPERATING INCOME (LOSS) NON -OPERATING REVENUE (EXPENSE) TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS TRANSFERS OUT 513,689.00 ($5,000.00) 5,000.00 $0.00 525,343.00 ($5,000.00) 5,000.00 COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT ENTERPRISE FUNDS TREASURER FY 2021 FORECAST $570,343.00 401,343.00 $169, 000.00 $7,000.00 $0.00 $ 176,000.00 VARIANCE FAV/(U N FAV) $50,000.00 $124,000.00 $0.00 $2,000.00 $2,000.00 P E R C L I ADOP'�E BUDGE'T $ 10,903,416 00 'sue apERATiVAG REVENUE co\ of of D F� 02 ERA F p,MEtyDED FGREG�E $ 10 gp3,416O0 $ 23,082,76200 OpE-?, TJ NG EXPENSE $ 30,p75 093 00 1U r61 COUNTY OF OAKLAPID FY 2021 THIRD 01UARTER REPORT INTERNAL SEPVICE L"C WATERRESOURCE`SCOMMt5-- O' �E VARIANCE AMENDED FY 2021 P FAV!(UNFAV) ADOPTED FORECAST N -. - -- BUDGET .. ���.,��.,� - BUDGET --- - - --------- FUND ( fi3900) I 1 46,084,240.00 (160,000.N0) DRAIN EQUIPMENT 45,935,059'06,244,240.00 0 4 - RE VENUES. OpERAT1N Inside 250,100.0Q 250,100.00 �_ Outside NET INCOME (LOSS) BEFORE NON -OPERATING REVENUE/(EXPENSE; ADOPTED BUDGET ($2,376,383.00) $314,600.00 AMENDED BUDGET ($3,964,896.00) $314,600.00 COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT INTERNAL SERVICE FUND WATER RESOURCES COMMISSIOiv= FY 2021 FORECAST ($3,70B,603.00) $346,600.00 VARIANCE FAVI(UNFAV) $256,293.00 $32,000.00 P A.p®PTso By®GET PdMP�W L1AB1L1T� tN� �� �77a� �S, 11,8g6.00 OPER ATWO R�VENU $ Outside Revenue ,,side Revenue Total Operal�ng Revenue T-' ov couAK �rtT, G V BU®GET ✓��~FJdp err Pd 5,117,670 00 11 g46.00 $ 5,1p5 8-- 5,117,E�0.00 rw,.. 5,105,82 Q� NNNNNNNNNNNNNNNNNNNNNN�INNNNNNNNN TRANSFER INIOUT NET REVENUES OVER/(UNDER)` EXPENSES TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING NNNNNNNNNNN $ (1,196,849.00) COUNTY` r. .r r NNNNNNNNrNN (113,385.00) $ (1,331,033.00) FY 2021 FORECAST (1,539,249.0 N u iJ.32✓.G Please note that in the Adopted Budget (line -item book) this is budgeted as "Planned use of Fund Balance" in the revenue category 0 COUNTY OF OAKL FY 2021 THIRD QUARTEI INTERNAL SERVICE I FRINGE BENEFITS ADOPTED AMENDED FY 2021 VARIANCE FRINGE BENEFITS FUND 67800 BUDGET BUDGET FORECAST FAV/(UNFAV) OPERATING REVENUE RETIREES MEDICAL - VEBA DEBT 33,999,000 33,999,000 34,453,200 454,20( RETIREMENT ADMINISTRATION 3,122,532 3,122,532 3,150,900 28,33u RETIREMENT ADMINISTRATION - PTNE 350,000 350,000 194,500 (155,50( DEFERRED COMPENSATION -MATCH 2,500,000 2,500,000 2,759,300 259,30( DEFINED CONTRIBUTION PLAN 19,500,000 19,500,000 21,862,500 2,362,50( DEFINED CONTRIBUTION PLAN - PTNE 220,500 220,500 194,700 (25,80( EMPLOYEE IN-SERVICE TRAINING 1,523,416 1,523,416 1,542,600 19,182 EMPLOYEE BENEFITS UNIT 1,188,941 1,188,941 1,204,400 15,45� EMPLOYEE RECOGNITION 354,289 354,289 354,289 FLEX BENEFIT PLAN 85,500 85,500 85,500 WELLNESS UNIT 595,783 595,783 606,000 10,21 FRINGE BENEFITS 120,903 120,903 120,903 TUITION REIMBURSEMENT 350,000 350,000 350,000 RETIREMENT HEALTH SAVINGS 4,500,000 4,500,000 4,398,800 (101,20( GROUP LIFE INSURANCE 545,000 545,000 508,200 (36,80( SOCIAL SECURITY 19,833,000 19,833,000 20,100,800 267,80( FRINGE BENEFITS FUND 67800 PRIOR YEAR ADJUSTMENT ADOPTED BUDGET AMENDED BUDGET COUNTY OF OA€CL FY 2021 THIRD QUARTET INTERNAL SERVICE I FRINGE BENEFITS FY 2021 FORECAST 1,310,100 VARIANCE FAV/(UNFAV) 1,310,10( PRIOR YEARS REVENUE - - 2,100 2,10( REFUND PRIOR YEARS EXPENDITURE - - 4,500 4,50( TOTAL REVENUE 155,347,785 155,347,785 155,267,192 (80,59: OPERATING EXPENSE RETIREES MEDICAL - VEBA DEBT INT/AGING 7,394,000 7,394,000 7,394,000 RETIREMENT ADMINISTRATION 1,189,295 1,219,906 1,172,980 46,92( DEFERRED COMP -COUNTY PMTS (MATCH) DEFINED CONTRIBUTION PLAN 2,500,000 19,500,000 2,500,000 19,500,000 2,700,000 22,300,000 (200,00( (2,800,00( DEFINED CONTRIBUTION PLAN - PTNE 220,500 220,500 220,500 COUNTY OF OAKL FY 2021 THIRD QUARTET INTERNAL SERVICE I FRINGE BENEFITS ADOPTED AMENDED FY 2021 VARIANCE FRINGE BENEFITS FUND 67800 BUDGET BUDGET FORECAST FAVI(UNFAV) DISABILITY INSURANCE 3,750,000 3,750,000 3,750,000 WORKERS COMPENSATION 3,285,928 3,306,429 3,411,967 (105,53f UNEMPLOYMENT COMPENSATION 300,000 300,000 150,000 150,00( CHILD CARE FACILITY 229,991 229,991 430,991 (201,00( HEALTH INSURANCE PREMIUM TAX 25,000 25,000 15,000 10,00( MICHIGAN IPAA TAX 18,000 18,000 18,000 PATIENT CENTERED OUTCOME RESEARCH 22,000 22,000 22,000 INDIRECT COSTS 240,000 240,000 336,000 (96,00( ADJ PRIOR YEARS EXPENDITURE - - - TOTAL EXPENSE 135,211,506 135,284,795 139,449,085 (4,164,29( NET REVENUE OVER/(UNDER) EXPENSES 20,136,279.00 20,062,990.00 15,818,107 (4,244,88' TOTAL NET ASSETS - BEGINNING 210,488,589 TOTAL NET ASSETS - ENDING 226,306,696 ADOPTED BUDGET IOAKLAND COUNTY INTERNATIONAL AIRPORT (56500) OPERATING REVENUE $4,772,155.00 OPERATING EXPENSE 7,319,400.00 AMENDED BUDGET $4, 772,155.00 7,395,874.00 COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPOR-; ENTERPRISE FUNDS CENTRAL SERVICES FY 2021 FORECAST $4,836,155.00 6,920,174.00 NET OPERATING INCOME (LOSS) (2,547,245.00) ($2,623,719.00) ($2,084,019.00) NON -OPERATING REVENUE (EXPENSE', 302,400.00 302,400.00 302,400.00 TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS (2,244,845.00) ($2,396,319.00) $ (1,781,619.00) TRANSFERSIN TRANSFERS OUT (75,000.00) (75,000.00) /'A I'lIT 111 !�(�AITI"tll"f11T1l�AI VARIANCE FAV/(U N FAV) $64,000.00 475,700.00 $539,700.00 PERCI -2 539,700.00 -2. COUNTY OF OAKLAND FY 2021 THIRD QUARTER FORECAST INTERNAL SERVICE FUNDS CENTRAL SERVICES ADOPTED AMENDED FY 2021 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT JMOTOR POOL FUND 66100 OPERATING REVENUE: Outside Revenue $ 145,000.00 $ 145,000.00 145,000.00 $ 0.00°/b Inside Revenue 8,543,432.00 8,545,632.00 7,918,132.00 (627,500.00) -7.34% Unfay. Lease unfay. Gasoli! (partiaily Oi Sc less than antb due to lecs th Total Revenue 8,688,432.00 8,690,632.00 8,063,132.00 (627,500.00) OPERATING EXPENSE 9,283,224.00 9,338,986.00 9,097,488.00 241,498.00 2.59% Fay. Indirect finalization, G (offset by unf $30,000 due i offset by Exit-� the Comp Stu Depreciation I equipment co OPERATING INCOME (LOSS) (594,792,00) (648,354.00) (1,034,356.00) (386,002.00) NON -OPERATING REVENUE 467,700.00 467,700.00 892,700.00 425,000.00 90.87% Fay. Income,' (FXPFNSFI COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT INTERNAL SERVICE FUND FACILITIES MANAGEMENT ADOPTED AMENDED FY 2021 VARIANCE BUDGET BUDGET ACTUAL FAV/(UNFAV) PERCENT FACILITIES MAINTENANCE & OPERATIONS (#63100) OPERATING REVENUES: Outside Revenue $ 481,187.00 $ 481,187.00 $ 491,187.00 $ 10,000.00 2.081l0 - Fay. P Agen rci (uCli' Inside Revenue 25,156,605.00 25,156,605.00 25,056,605.00 (100,000.00) -0.40% Unfay. reques Total Revenue $ 25,637,792.00 $25,637,792,00 $ 25,547,792.00 $ (90,000.00) -0.35%0 OPERATING EXPENSES $ 28,616,264.00 $28,845,778.00 $ 28,032,778.00 $ 813,000.00 2,82% -Fay. S underfi usage; and sa $7 5,00 market ,urcha $55,00 equiprr decrea and we project service Paruall increa: ----------------------- NON-OPERATING REVENUE TRANSFERSIN TRANSFERS OUT NET REVENUES OVER(UNDER) EXPENSES" TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT INTERNAL SERVICE FUND FACILITIES MANAGEMENT ADOPTED AMENDED FY 2021 VARIANCE BUDGET BUDGET ACTUAL FAV((UNFAV) PERCENT $ 100,000.00 $ 100,000.00 $ 79,964.00 $ (20,036.00)-20.04% Unfay. Activity Unfay. mcomE investr $ $ $ 3,891.00 $ 3,891.00 0.00% Trarsfi $ $ (118,750.00) $ (118,750.00) $ - 0.00% $ (2,878,472,00 $ (3,226,736.00)- $ (2,519,881.00) $ 706,855.00 $ 10,187,408.20 $ 7,667,527.20 *Please note that in the Adopted Budget (line -item book) this is budgeted as "Planned use of Fund Balance" in the revenue category or Budge, COUNTY Q OA. p PORT TI1lRD GIUARTER RE ISE �k pY 2021 FUNDS I ENTERPR SERVMA1ce ION TECHNOLOGY iNTERNA INFORM FY 2021 AMENDED FORS ADOPTED BUS BU_UDG - 3,246,3p6 00 Opens (63600) 3 752,306.00 $ Technology Information REVENUES. 3,752,306 40 TING 33,441,336.00 OPERA 33,093,236 $ putside 402,00 33.074, Inside TOTAL OPERATING REVENUE OPERATING EXPENSES $ 36,826,708.00 48,443,043 V ARIANCE FAVI UNFAV PEA - 13.48 � (506,000.00) �687 ,642.00 36,845,542.00 $ 46,087,7g6.00 $ 49,521,986 $ 67 348,100.00 $ 3 434,200.00 1.03' - COUNTY OFOAKLAND FY 2021 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE Ft INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2021 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCEN"! Information Technology - Telephone Communications (67500) OPERATING REVENUES: Outside $ 12,000.00 $ Inside 3,525,876 TOTAL OPERATING REVENUE $ 3,537,876.00 $ OPERATING EXPENSES $ 3,753,648.00 $ NET INCOME (LOSS) BEFORE OPERATING TRANSFERS $ (215,772.00) $ NON -OPERATING REVENUE $ 30,000.00 $ 12,000.00 $ 3,525,876 $ 3,537,876.00 $ 3,765,984.00 $ (228,108.00) $ 30,000.00 $ 7,800.00 $ 3,499,376.00 $ 3,507,176.00 $ 4,386,484.00 $ (879,308.00) $ 14,200.00 $ (4,200.00) (26,500.00) (30,700.00) (620,500.00) (651,200.00) (15,800.00) -0.75' -0.87' -16.48' -52.67' ADOPTED AMENDED BUDGET BUDGET Information Technology - CLEMIS (53500) OPERATING REVENUES: Outside $ 4,757,701.00 $ 4,757,701.00 $ Inside 1,527,955.00 1,527,955.00 $ COUNTY OFOAKLAND FY 2021 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE F1 INFORMATION TECHNOLOGY FY 2021 VARIANCE FORECAST FAV/(UNFAV) PERCENT 5,173,701.00 $ 416,000.00 1,358,655.00 $ (169,300.00) 8.74' -11.08' TOTAL OPERATING REVENUE $ 6,285,656.00 $ 6,285,656.00 $ 6,532,356.00 $ 246,700.00 3.92' OPERATING EXPENSES $ 11,693,202.00 $ 12,048,651.00 $ 11,842,051.00 $ 206,600.00 1.71' ADOPTED AMENDED BUDGET BUDGET Information Technology - Radio Communications (53600) OPERATING REVENUES: COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISL Ft INFORMATION TECHNOLOGY FY 2021 VARIANCE FORECAST FAV/(UNFAV)PE_RC.QJi Outside $ 9,265,600.00 $ 9,265,600.00 $ 9,343,000.00 $ 77,400.00 i;.84 Inside $ 491,828.00 $ 491,828.00 $ 483,528.00 $ (8,300.00) 1. " TOTAL OPERATING REVENUE $ 9,757,428.00 $ 9,757,428.00 $ 9,826,528.00 $ 69,100.00 0.71' OPERATING EXPENSES $ 6,426,025.00 $ 6,741,520.00 $ 6,257,520.00 $ 484,000.00 7.18' COUNTY OF OAKLAND FY 2021 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE Ft INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2021 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT Fire Records Management ( 53100) OPERATING REVENUES: Outside $ 283,233.00 $ 283,233.00 $ 307,833.00 $ 24,600.00 9' TOTAL OPERATING REVENUES $ 283,233.00 $ 283,233.00 $ 307,833.00 $ 24,600,00 8,69, OPERATING EXPENSES $ 1,038,666.00 $ 1,057,208.00 $ 940,608.00 $ 116,600.00 1 1.G3' NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON -OPERATING REVENUE $ (755,433.00) $ (773,975.00) $ 3,000.00 $ 3,000.00 (632,775.00) $ 3.300.00 141,200.00 300.00 10.00, TRANSFERS IN $ 507,699.00 8 507,699.00 572,099.00 64,400.00 12.68' TRANSFERS (OUT) $ - $ - $ - $ - 0.00, DEPARTMENT OF HEALTH AND HUMAN SERVICES - HEALTH DIVISION - WRITE- OFFS - October 1, 2020 - June 30, 2021 WRITEOFF BAD DEBT (True MONTH (Contractual/ Writeoffs) Totals Internal) September 2020 October 2020 (553.91) (9,056,77) (9,610.68) November 2020 (225.45) (2,422.67) (2,648.12) December 2020 (103,12) (3,050.91) (3,154.03) January 2021 (38.40) (7,948.11) (7,986.51) February 2021 (85.78) (1,839.88) (1,925.66) March 2021 (81.61) (751.00) (832.61) April 2021 (32,19) (2,563.00) (2,595.19) May 2021 (89.73) (3,112.03) (3,201.76 June 2021 (346,02) (853.00) (1,199.02) July 2021 0.00 August 2021 0.00 September 2021 0,00 (1,556.21) (31,597.37) (33,153.58) im OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2021 3rd Quarter - April 1, 2021 - June 30, 2021 4/1/2021 Nicola Marcus 54673 $5.00 354973 4/1/2021 Bethany Ruffino 54680 $0.46 354973 4/1/2021 Nicole Meyer 54681 $5.00 354973 4/1/2021 Betty Thomas 54682 $50.00 354882 4/1/2021 Radhika Mengle 54686 $0.46 354973 4/1/2021 Patti Kuberski 54700 $32,50 354882 4/1/2021 Jimmy Gray 54704 $0.46 354973 4/1/2021 Luna Zhang 54715 $50.00 354973 4/1/2021 Elizabeth Boissonneault 54761 $0.64 354973 4/1/2021 Elizabeth Boissonneault 54762 $0.64 354973 4/1/2021 Christie Bollaert 54764 $0.64 354973 4/1/2021 Tammy Jimenez 54765 $5.00 354973 4/1/2021 Barbara Johnston 54766 $5.00 354973 4/1/2021 David Wendt 54770 $5.00 354973 4/1/2021 Kristine Lott 54775 $10.00 354973 4/1/2021 Cynthia Ortega 54776 $0.46 354973 4/2/2021 Scott Neumann 54734 $250.00 354963 4/2/2021 Karen Kolke 54737 $5.00 354973 4/2/2021 Colleen Walker 54779 $10,00 354973 4/2/2021 Doug Smith 54785 $20.00 354973 4/2/2021 Devon Tolen 54803 $5.00 354973_ 4/2/2021 Courtney Wood 54805 $0.18 354973 4/2/2021 Michael Sabol 54852 $0.64 354973 4/2/2021 Kathleen Collin 54853 $0.46 354973 4/2/2021 Kathy Graham 54856 $5.00 354973 4/2/2021 Rebecca Ulinski 54859 $5.00 354973 4/3/2021 Sandra Bowen 54810 $20.00 354973 4/3/2021 Ember Sebastian 54812 $0.92 354973 4/3/2021 Jejanette Chamboullides 54874 $5.00 354973 4/4/2021 Alan Hartz 54882 $5.00 354973 i0a OAKLAND COUNTY .ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2021 3rd Quarter - April 1, 2021- June 30, 2021 ,�`°. .l,+a.. ir". .-':-�.. .-, ta' - _ :d%a i'.'F.� r.i. .Y ..p `:✓^"'"�:':` .v krc�-':-:`fh'.:. �'Y`i✓ qi p \' "a".t Nx .;a:' 4/5/2021 Shelby Shelby 54832 $5.00' 355045 4/5/2021 Shelby Shelby 54833 $5.00 355045 4/5/2021 Alastair lronside 54834 $5.00 355045 4/5/2021 David Smith 54844 $5.00 355045 4/5/2021 David Smith 54845 $5.00 355045 4/5/2021 Susie Dai 54848 $5.00, 355045 4/5/2021 Andreas Seidel 54849 $10.00 355045 4/5/2021 Chayse Simon 54861 $0.18 355045 4/5/2021 Peter Spezia 54891 $0.18 355045 4/5/2021 Margaret Sam berg 54894 $20.00 355045 4/5/2021 Madison Hinkley 54896 $0.18 35SO45 4/5/2021 Melissa Powers Bavido 54911 $5.00 355045 4/5/2021 Kimberly Wilcox -Olsen 54913 $10.00 355045 4/5/2021 Nicole Dickson 54922 $0.46 355045 4/5/2021 Madeline Kettler 54926 $0.18 355045 4/6/2021 Dave Hudspeth 54936 $5.00 355206 4/6/2021 Shannon Kosiba 54937 $5.00 355206 4/6/2021 Gabriela Garcia 54947 $5.00 355206 4/6/2021 John Regole 54948 $5.00 3SS206 4/6/2021 Gerald Beelby 54953 $4.00 355127 4/6/2021 Angela Mikula 54963 $5.00 355206 4/6/2021 Bethany Beyer 54964 $0.46 355206 4/6/2021 Karolina Kaser 54974 $20.00 355206 4/6/2021 Ningxian Fan 54984 $0.46 355206 4/6/2021 Nicole Christensen 54997 $5.00 355206 4/6/2021 Erin Smith 54998 $0.64 355206 4/6/2021 Hannah Huehn 54999 $0.18 355465 4/7/2021 Sandy Smallish 55008 $20.00 355465 4/7/2021 Alison Chanley 55013 $10.00 355465 4/7/2021 Dana Miller 55017 $0.46 355465 104 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2021 3rd Quarter - April 1, 2021 - June 30, 2021 4/7/2021 Mary Kavutske 55022 $0.18 355465 4/7/2021 Harold Walker 55023 $58.00 355193 4/7/2021 Danielle Isenogle 55026 $0.64 355465 4/7/2021 Kyle Manston 55030 $0.92 355465 4/7/2021 Scott Mirkes 55032 $5.00 355465 4/7/2021 Deborah Russ 55041 $0.18 355465 4/7/2021 Diane LaHale 55042 $15.00 355465 4/7/2021 Antone Family 55051 $500.00 355268 4/7/2021 Shelby Shonce 55054 $0.64 355465 4/7/2021 Margaret Kienman 55055 $5.00 355465 4/7/2021 Daniel Seraphinoff 55057 $5.00 355465 4/7/2021 Michelle Phillips 55062 $0.18 355465 4/8/2021 Sheril Scimemi 55063 $5.00 355588 4/8/2021 Jill McBeth 55069 $0.64 355588 4/8/2021 Dianne Reeves 55086 $0.28 355588 4/8/2021 Kristen Neely 55091 $0.18 355588 4/8/2021 Scott Therrien 55092 $5.00 355588 4/8/2021 Jerrilyn Pahssen 55095 $10.00 355588 4/8/2021 Dave Girolamo 55097 $5.00 355588 4/8/2021 Osvaldo Perez-Rodrigue 55119 $5.00 355588 4/8/2021 Jeff Johns 55121 $10.00 355588 4/9/2021 Victor Coscarelli 55129 $0.64 355588 4/9/2021 Anna Berkovich 55137 $10.00 355588 4/9/2021 Sabrina Sutherland 55146 $1.46 355588 4/9/2021 Tara Drury 55158 $1.00 355588 4/9/2021 Phil Montez 55168 $5.00 355588 4/9/2021 Evelyn Huang 55187 $0.64 355588 4/9/2021 Jennifer Petrie 55188 $0.18 355588 4/9/2021 Bill Vibbert 55227 $50.00 355588 4/10/2021 Raye Hobson 55181 $5.00 355588 105 OAKLANDCOUNTY ANIMAL CONTROL AND PET ADOPTION CENTER restjctedFund(Legacy)Dvnatiuns- FYIO2l3rdQuarter - April 1/Z0ll June 3V,IOl1 4/10/2021Kri5dnaSuchyto 55193 $5.00 355588 4/10/l8I1 Marie Laurent 55200 $20.00 355588 4/11/10l1 Spencer Matthews 55215 $10.00 355619 4/11/1011 Daniel Brinkman 55216 $0.64 335619 4/l1/z0zz Wendy Richardson 55220 $5.00 355619 4/1l/10I1 Raymond [hnmpovx 55213 $5.00 355619 4/11/Z0l1 Emilie Lemond 55552 $5.80 355619 � 4/lI/ZDZ1KristaKirkpatrick 55233 $0J8 355619 «/1l/Z021 Jason Sckons 55138 $0.64 355619 4/1I/Z0l1TonyaRoss! 55250 $42.50 355448 u/1l/I0I1 Kevin Lindsey 55252 $0.96 355619 4/1l/Z0Il Karen Brooks 55I53 $9.18 355619 4/1l/Z0l1 Emily Lanzon 55267 $0.64 355619 4/1I/2UZ1 Raymond Wilhelm 55275 $5.00 355619 4/lZ/2Vl1 Tammy Strock 55287 $0.28 355619 4/1l/l021 June VVuopiu 55293 $036 355619 4/11/2011 June VVoopio 55294 $0.96 355619 u/1Z/l0Z1 Daryl Jamison 55304 $10.00 355619 4/13/l0ll Kristin Dailey 55311 $0.18 355759 u/1J/zo11 Tina Emiry 55313 $0.46 355759 4/13/Z021 Michele Cresmen 55315 $10.00 355759 u/z3/zozz Sarah Barrett 55328 $10.00 355759 4/13/I0l1 Stephen Bernstein 53331 $5.00 355759 4/13/Z0Z1GenaMeadows 55361 $10.18 335759 4/13/I0Z1 Patricia Vader 55362 $10.00 355759 4/14/20I1NaveenThnta 55364 $0.46 355759 4/14/Z0Z1 Betty Miller 55367 $5.00 355759 4/14/l0I1 Teresa [merine 55370 $10.00 355759 4/14/Z0Z1 Rhonda Long 55378 $0.18 355759 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2021 3rd Quarter - April 1, 2021- June 30, 2021 4/14/2021 Busy Bodies For Women 55385 $20.00 355536 4/14/2021 John Little 55388 $5.00 355536 4/14/2021 Clarkston Community Schools 55389 $190.00 355536 4/14/2021 Mary Laughlin 55390 $100.00 355536 4/14/2021 Lawrence Barnes 55391 $125.00 355536 4/14/2021 Stephanie & Philip Trapp 55392 $25.00 355536 4/14/2021 Alfred Demailo 55395 $100.00 355536 4/14/2021 Janet Brennecke 55396 $100.00 355536 4/14/2021 Oakland County Clerk/ROD 55399 $237.00 355536 4/14/2021 Michael Douglas 55403 $0.64 355759 4/14/2021 Beth Beyer 55407 $0.64 355759 4/14/2021 Kristin Fisher 55418 $5.0w 355759 4/14/2021 Deanna Moody 55424 $0.96 355885 4/14/2021 Ann ivory 55427 $10.00' 355759 4/14/2021 Therese Williams 55435 $20.00 355759 4/14/2021 Cassandra Fraser 55437 $0.46 355759 4/14/2021 Joanna Conteras 55440 $0.64 355885 4/15/2021 Laura Griffin 55442 $0.18 355885 4/15/2021 Ingrid Rein 55443 $0.64 355885 4/15/2021 Ann Ivory 55450 $10.00 355885 4/15/2021 Angelica Vachon 55468 $0.18 355885 4/15/2021 Crystal Brabbs 55473 $0.18 355885 4/15/2021 Kimberly Gladwin 55478 $10.00 355885 4/15/2021 Julie Frias 55489 $5.00 355885 4/15/2021 Scott Gabrielson 55491 $5.00 355885 4/16/2021 Judy Rockwell 55497 $7.00 355867 4/16/2021 Shawn Baker 55510 $0.64 355885 4/16/2021 Carla James 55513 $0.18 355885 4/16/2021 Carla James 55514 $0.18 355885 4/16/2021 Christopher Taylor 55518 $85.00 355867 U41M OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2021 3rd Quarter - April 1, 2021 - June 30, 2021 ri='� _ .�.- _ - -j 4" ' a..,s^ -; tZ: a' ;{];'.fi :� � 33���� `art^"" 'a: xi?d'.` '� ..'s+`*"T. ."k> �„9'� ✓: .,:,te •(: ''.J:�: u...,,� . 'N'i6� �;:.N ., ff qqjj .i •.'C..r �$«: a;4••" :. r..y^—"S.. 'h+iv' ':ed",.t : _ .::i•,.•.::' b"r: k'."''e, :. - v°�:-,:'.rpK `•?+' �:§ g.�,,'. � � -�:. 4.�i?_.¢r,.`';`;:', .ar s.''���'t..l j{�?'S :�y. �`v�E' i.. .....R(eli,:. �'S„ L` 1.r P�: :"b: 3ya} i3, � _ 'I:itr- aa'i' -...w' - cuaa.s' `:ii.S:..Nt�xd.'an :,..�. ,,..-i.ir^•.^d:t"c -~--..:.m.,v.4/16/2021 Alexandra Pecorelli 55519' $1.00 355885 4/16/2021 Sarah Carman 55521 $20.00 355885 4/16/2021 Sarah Carman SSS22 $20.00 355885 4/16/2021 John M oxley 55523 $0.18 355885 4/16/2021 Kaitlyn Baase 55524 $5.00 355885 4/16/2021 John Moxley 55525 $0.18 355885 4/16/2021 Jessica Lafave 55527 $5.00 355885 4/16/2021 Lora Hogan (Lo High School) 55532 $1,500.00 355885 4/16/2021 Laura Zanini Lima 55535 $10.00 355885 4/16/2021 Daniel Bickersteth 55542 $400.00 355969 4/16/2021 Allen Gough 55543 $100.00 355969 4/16/2021 Jeffrey Beck 55561 $5.00 355885 4/16/2021 Zoe Mendelson 55566 $5.00 355885 4/16/2021 Jennifer Belanger 55572 $5.00 355885 4/16/2021 Kelly Jackson 55574 $5.00 355885 4/17/2021 Nivedita Tiwari 55549 $5.00 355885 4/17/2021 Lynn Gordon 55579 $0.64 355885 4/17/2021 Amanda Grabowski 55582 $0.18 355885 4/17/2021 Monica McQuarrie 55586 $0.64 355885 4/17/2021 Rufus & Denise Morency 55587 $5.00 355885 4/17/2021 Amanda Stemmer 55594 $10.00 355885 4/18/2021 Traci Bastuba 55601 $0.64 356047 4/18/2021 Traci Bastuba 55602 $0.64 356047 4/18/2021 Kathleen Fox 55616 $0.28 356047 4/18/2021 Vivek Mehta 55617 $0.18 356047 4/18/2021 Bruce Gray 55618 $5.00 356047 4/19/2021 Teri Shermetaro 55554 $5.00 356047 4/19/2021 Teri Shermetaro 55624 $5.00 356047 4/19/2021 Aditya Chakraborti 55626 $0.96 356047 4/19/2021 Allie David 55642 $0.18 356047 .r. OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations a..''duai.'..u:=:iL: �frit*..y>k��..�:�;q?L:"•S_;.,.n:'? 4/19/2021 Blair Grose 4/19/2021 Linda Baker 4/19/2021 Robbie Easterbrook 4/19/2021 Wei Chen 4/19/2021 Michael Trudell 4/19/2021 Elizabeth Dow 4/19/2021 Jian Wang 4/19/2021 Serena Nash 4/19/2021 Paige Evans 4/20/2021 Lauren Belton 4/20/2021 Peggy Nelson 4/20/2021 Haley Pauley 4/20/2021 Sanjeev Kumar 4/20/2021 Christina Schroeder 4/20/2021 Kimberly Wyman 4/20/2021 Christi Blackburn 4/20/2021 Rachel Kammeyer 4/20/2021 Donation Box 4/20/2021 Alison Mallaney 4/20/2021 Grace Lee 4/20/2021 Susan Lindson 4/20/2021 Rebecca Kavanagh 4/20/2021 Echo Martin 4/20/2021 Jeffrey Hada 4/20/2021 Annette Raftery 4/21/2021 Kristen Kind 4/21/2021 Kristina Milosevski 4/21/2021 Taylor Bojeri 4/21/2021 Marc Watson 4/21/2021 Coleen Kurtz FY 2021 3rd Quarter - April 1, 2021 - June 30, 2021 55649 $5.00 356047 55620 $5.00 356047 55652 $0.46 356047 55653 $5.00 356047 55663 $0.64 356047 55665 $0.18 356047 55666 $10.00 356047 55667 $5.00 356047 55672 $0.18 356047 55683 $20.54 356047 55690 $5.00 356047 55699 $1.64 356047 55700 $0.18 356047 55703 $10.64 356047 55708 $0.64 356047 55709 $0.36 356047 55720 $0.64 356047 55724 $54.50 356317 55727 $150.00 356315 55728 $72.00 356047 55729 $5.00 356047 55730' $0.64 356047 55733 $5.00 356047 55734 $5.00 356047 55735 $5.00 356047 55743 $55.00 356470 55746 $5.00 356470 55763 $0.18 356470 55773 $10.00 356470 55775 $27.00 356317 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy] Donations - FY 2021 3rd Quarter - April 1, 2021 - June 30, 2021 R el 10, -16Z 4/21/2021 Alexis Buffone 55782 $0.64 356470 4/21/2021 Patricia Butler 55783 $1.46 356470 4/22/2021 Michael Gauthier 55786 $0,64 356470 4/22/2021 Jared Shroyer 55788 $10.00 356470 4/22/2021 Amanda Jackson 55792 $0.18 356470 4/22/2021 Marianne Rambaum 55799 $21.25 356317 4/22/2021 Krystal Murphy 55800 $0.46 356470 4/22/2021 Judy Phillips 55809 $50.00 356317 4/22/2021 Barbara Galecki 55810 $0.64 356470 4122/2021 Danish Ali 55911 $0.18 356470 4/22/2021 Craig Van Bibber 55817 $10.00 356470 4/22/2021 Pamela Stiles 55821 $10.00 356470 4/22/2021 Marilyn Loughead 55828 $40.00 356383 4/22/2021 Carrie Walters 55832 $17.50' 356383 4/22/2021 Lupe Salinas 55833 $115.00 356383 4/22/2021 Tracy Rodriguez 55870 $10.00 356470 4/22/2021 Mel Feng 55878 $10.00 356470 4/22/2021 Zachary Stephens 55879 $5.00 356470 4/23/2021 Robert Good 5SS36 $100.00 356383 4/23/2021 Lynne King 55843 $100.00 356385 4/23/2021 Allyson Button 55844 $0.00 356470 *5/17/2021 PER JOANTIL, S 10 82 TRANSFERRED TO LICENSE FEE. REFUND 339.18 DONATION TO LEGACY. 4/23/2021 Donation Box 55856 $34.50 356385 4/23/2021 Kelli Coulter 55887 $0.18 356470 4/23/2021 Kelli Coulter 55888 $0.64 356470 4/23/2021 Kathleen Dobbs 55891 $10.00 356470 4/23/2021 Katherine Coon 55894 $5.00 356470 4/23/2021 Allyson Button 55895 $20.00 356470 4/24/2021 Leah West 55858 $i.00 356638 4/24/2021 Leah West 55859 $1.00 356638 110 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2021 3rd Quarter - April 1, 2021 - June 30, 2021 4/24/2021 ZacharyStepphens 55862 $5.00 356638 4/24/2021 Carley Osterhout 55864 $5.00 356638 4/24/2021JiameiSun 55865 $5.00 356638 4/24/2021 Anne Marie Malysz 55917 $0.18 356638 4/24/2021 Matthew Smith 55920 $20.00 356638 4/24/2021 Brooks Lamb-Budny 55923 $5.00 356638 4/24/2021 Katherine Hamilton 55926 $5.00 3S6638 4/25/2021 Joseph Donnelly 55942 $5.00 356638 4/25/2021 Lauren Middleton 55948 $0.96 356638 4/25/2021 Cay-Lynn Coulter 55952 $5.00 356638 4/25/2021 Caroline Sadler 55953 $0.82 356638 4/75/2021 Carley Osterhout 56603 $5.00 356638 4/25/2021 Carley Osterhout 56604 $5.00 356638 4/26/2021 Sarah Piszczek 55963 $0.18 356638 4/26/2021 Andrew Bolin 55965 $0.46 356638 4/26/2021 Jenna Cyrocki 55968 $0.46 356638 4/26/2021 Alissa Moody 55975 $5.00 - 356638 4/26/2021 Timothy Lindberg 55986 $5.00 356638 4/26/2021 Haydn Person 56000 $57.50 356528 4/26/2021 Becky Ervin 56004 $5,00 356638 4/26/2021 Deborah Deplaunty 56007 $10.00 356638 4/27/2021 Lelah Green 56016 $50.00 356528 4/27/2021 Judith Drew 456019 $50.00 356528 4/27/2021 Elissa Staeuble 56020 $25.00 356528 4/27/2021 Carol Ann Carpenter 56027 $20.00 356528 4/27/2021 Jessica Uban 56044 $0.18 356638 4/27/2021 Dana Gale 56046 $0.64 356638 4/27/2021 Katherine Simoni 56048 $5.00 356638 4/27/2021 Stephanie Potrykus 56066 $0.64 356638 4/28/2021 Thirupathi Reddy Allaia 56072 $0A6 356638 III OAKLAND COUNTY ANIMAL CONTROL. AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2021 3rd Quarter - April 1, 2021 - June 30, 2021 ;R 4/28/2021 Paul Greer 56078 $10.00 356638 4/28/2021 Shadow Cat 56079 $5.001 356638 4/28/2021 Samantha Sage 56080 $10.00 356638 4/28/2021 Lisa Morse 56096 $40.00 356628 4/28/2021 Dereck Wonnacott 56110 $20.00 356638 4/28/2021 Greg Sapick 56117 $50.00 356638 4/28/2021 Laura Porto 56118 $0.46 356638 4/28/2021 Dereck Wormacott 56135 $20.00 356639 4/29/2021 John Ogger 56127 $0.18 3S6760 4/29/2021 Douglas Nabor 56139 $100.001 356752 4/29/2021 Elizabeth Henne 56157 $0.641 356760 4/29/2021 Byron Ho 56161 $5.001 356760 4/29/2021 Brent Higuchl 56167 $100.001 356760 4/30/2021 Lindsey Stahl 56175 $5.00 356853 4/30/2021 Kimberly Moore 56178 $5.00 356853 4/30/2021 Kaltlin Arteaga 56188 $0.46 356853 4/30/2021 Girl Scout Troop 76135 56203 $198.00 356836 4/30/2021 Deena Alam-Parks 56223 $10.00 356853 4/30/2021 Christina Bowers-Crabb 56230 $5.00 356853 4/30/2021 Andrew Nierescher 56231 $10.00 356853 4/30/2021 Peter Shinozaki 56232 $0.64 356853 April 2021Total $6,689.41 5/1/2021 Robert Schmaus 562111 $5.00 356853 5/1/2021 Tara Soyka 562381 $5.00 356853 5/1/2021 Tara Soyka 56239 $0.46 356853 5/1/2021 Tara Soyka 56240 $0.64 356853 5/1/2021 Tara Soyka 56241 $0.64 356853 5/1/2021 Cynthia Russ 56244 $5.00 356853 5/1/2021 Emily Paul 56246 $1.00 356853 5/1/2021 Faye Schuett 56253 $10.00 356853 1492 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2021 3rd Quarter - April 1, 2021 June 30, Z021 5/1/2021 Michael VanDoornik 56254 $4.18 356853 5/1/2021 Ashley Goforth 56256 $0.18 356853 5/1/2021 Steven Johnston 56261 $0.47 356853 S/1/2021 Steven Johnston 56262 $0.46 356853 5/2/2021 Joseph Wyderko 56266 $0.82 356920 5/2/2021 Dania Blain 56267 $0.64 356920 5/2/2021 Travis Hall 56272 $2.00 356920 5/2/2021 Kelly Lockitski 56276 $10,00 356920 5/2/2021 Asya Hubbard 56278 $0.46 356920 5/2/2021 Gary Domonkos 56279 $10.00 356920 5/2/2021 Paula Nawrocki 56283 $5.00 356926 5/2/2021 Jacqueline Cruz 56285 $0.64 356920 5/3/2021 Kalpak Kalvit 56294 $5.00 357055 5/3/2021 James Norton 56299 $5.00 357055 5/3/2021 Alison Smith 56313 $0.64 357055 5/3/2021 Sarah Urene 56318 $0.18 357055 5/3/2021 Morris Hinson 56320 $0.96 357055 5/3/2021 Renee Kavalar 56326 $0.47 357055 5/3/2021 Vernon Martin Jr 56341 $0.18 357055 5/3/2021 Vernon Martin Jr 56342 $0.18 357055 5/3/2021 Susan Moffitt 56348 $0.64 357055 5/3/2021 LeeAnn Zeliasko 56350 $0.18 357055 5/4/2021 Stephanie Wilson 56334 $75.00 356981 5/4/2021 Mark Mudd 56361 $5.00 356981 5/4/2021 Lori Newton 56363 $25.00 356981 5/4/2021 Beverly Snodgrass 56365 $100.00 356981 5/4/2021 Parkers Hilltop Brewery 56366 $320.00 356981 5/4/2021 Mike Bennett 56367 $20.00 356981 5/4/2021 Annette Armstrong 56368 $20.00 356981 5/4/2021 Tom & Kelly Schmidt 56369 $20.00 356981 113 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER ReuthctcdFund(Legacy)Dnontinns- FY2UIl]rdQuarter ' April 1,ZU2l jone}O,Z011 ~ ---'--'— J/4/I0Z18]anBia� 5�37Z �� ,DO 357055 5/4/l0I1Michelle Walsh 56387 $50.00 356983 5/4/10l1Sarah Smith 56399 s5.00 357055 5/4/zo21BisaHernandez 56405 $0.64 357055 s/4/202zKim Luepke ��4O6 ��0 .00 357055 5/4/10Z1Tina Garmo 56407 $0.64 35/055 5/4/20ZlDeborah Creech 56410 $2.00 357179 5/4/20210ksanaLurkivskyi 56416 $5,00 357055 5/4/l0l1Rickey Slier 56419 $O.46 357855 5/4/l011Kendra Merrell 56421 $0.46 357055 5/4/1011Leo Kukhar 56421 $0.64 357055 5/4/l0Z1Scott Hauoche, 56426 $10.00 357055 5/4/2021Adam Kaymer S6433 $0.18 35705S 5/4/28I1Kristen Gvra|oyk 56434 $10.00 357055 5/4/I021Cookie Sheikh 56436 $0.46 35705S 5/5/zoz1KabeStarn �6444 �0�47 �s70�� 5/5/2011Sarah Congdon 56450 $5.00 357055 5/5/l0l1Deanna Riogb �64�9 $Uy ,64 357055 5/5/20I1ArmondoG,anado 56465 $5.00 35705S 5/5/l0Z1Geu|aRapp 56479 �5 .UO 357055 5/5/2011Amanpreet8rar 56485 $10,00 357855 5/5/l0llAntonia Molina 56486 $5.08 357055 5/S/20l1James Botsford 56491 $10.08 357055 5/6/lAI1Tina Wilson 56493 $10.00 357342 5/6/IUI1��attFrench ��49� �ZO�U0 ��7�4l " 5/6/I0Z1Nanette Gold 56301 $5.V0 357342 5/6/Z0%1Katie 6aravag|in 56517 $0.64 357342 5/6/2021Kami|eD'Vn|entine 56519 $0.46 357342 Horton 5/6/2021TrinaHort S��3I �V .46 357342 5/6/1OI1��ackenzie8rox/n �65�4 . �100 ��7J41 ow- OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2021 3rd Quarter - April 1, 2021 - June 30, 2021 5/6/2021 Shaun Brautigan 56537 $10.00 357342 5/6/2021 James Smades 56544 $0.18 357342 5/6/2021 Brooke Plovie 56609 $5.00 357342 5/6/2021 Yuliya Gaydayenko 58610 $0.18 357342 5/6/2021 Robin Menke 56612 $10.00 357342 5/7/2021 Sarah Coga 56605 $0.18 357342 5/7/2021 Melissa Moore 56640 $5.00 357342 5/7/2021 Yolanda Giles 56643 $5.00 357342 5/7/2021 Cheryl Rasmussen 56654 $5.00 357342 5/7/2021 Veronica Dean 56657 $0.64 357342 5/7/2021 Amy Powrie 56658 $5.00 357342 5/7/2021 Jessica Dayringer 56663 $0.46 357342 5/7/2021 Geena Naegle 56667 $0.18 357342 5/7/2021 Tracy Guellec 56668 $5.00 357342 5/7/2021 Christy Gransden 56669 $0.46 357342 5/8/2021 Samanth Luber 56595 $5.00 357342 5/8/2021 Samanth Luber 56671 $10.00 357342 5/8/2021 Elizabeth Harris 56692 $10.00 357342 5/8/2021 Annette Raftery 56701 $5.00 357342 5/8/2021 Ann Mathieson 56703 $10.00 357342 5/8/2021 Ellen Kord 56706 $5.00 357342 5/9/2021 Jacqueline Maggioncalda 56715 $0.18 357561 5/9/2021 Deborah Hoyle 56716 $0.64 357561_ 5/10/2021 Donald Rogers 56637 $7.00 357320. 5/10/2021 Cheryl Kozell 56677 $100.00 357320 5/10/2021 Darsi Bell 56722 $20.00 357561 5/10/2021 Morgan Woolfolk 56726 $1.00 357561 5/10/2021 Linda Ryan 56729 $10.00 357561 5/10/2021 RachealHardy 56774 $5.00 357561 5/10/2021 Laura Beldin 56775 $10.00 357561 OAKLANDCOUNTY AM01ALCONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2021 3rd Quarter - April 1, 2021 - June 30, 2021 5/11/Z0I1Scott 0ppmann 56780 $5.00 357561 5/11/l01lSarah Johnson 56781 $10.00 357561 5/11/10l1Leslie Brow 56789 $10.00 357561 5/11/Z0I1|vanaVaughn 56796 $0.18 357561 5/11/2011Annette Okenon 56800 $5.00 357561 5/11/lo2zJanet Jennings 56881 $5.00 357561 s/11/1021Jennifer Phillips 56807 $5.00 357561 5/11/10I1Travis Daley 56840 $0.47 357561 5/11/lDl1Laura GrodzicN 56841 $036 357561 *Per TomhoToole, this (]6)was backed out- duplicate order. 5/11/I0l1Laura Grodzicki 56842 $836 357561 S/12/z021Sheilah [a|opidb 56850 $50.00 357547 5/1I/20l1Rebecca Malkin 56852 $0.64 357769 5/12/I0I1Kathleen Zi|| 56858 $5.00 357769 " 5/1I/l0Z1Sylvia Raleigh 56887 $5.00 357789 5/1Z/I021Judith [hious 56890 $13O 357545 5/1Z/20l1Melody Sharpe 56898 $5.00 357769 5/1I/ZDZ1Susan Leaver 56900 $0.64 357769 5/12/l0I1Laura Meacham 56904 $5.00 357769 5/1l/l8ZzLaura Meacham 56985 $5.00 357769 s/11/I011Jennifer Prankc 56986 $6.64 357769 5/1z/1o21Rebecca oiegas 56910 $0.18 357769 5/12/l0ZlPatricia [hetkovich 56911 $0.96 337769 5/1I/l0l1Shannon Garvin 56914 $0.64 35/769 5/1I/Z8l1John Konga|athv 56921 $5.00 35/769 5/13/l021Dustin Hagfun 56919 $018 357769 5/13/I021Debbie Shamfinski 56927 $5.64 357769 5/l3/ZDZ1Shirley Knight 56955 $100.00 357545 5/13/l0I1[)nd\Hopkins 569S9 $5.00 357769 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund /Legacy\Donations ' FY2O213rdQuarter ' April 1/ZOl1^June 3U/20I1 ux 5/13/I021Ricke|le]vszNewicz / i6965/ 5/13/2071Michelle Rets*l | 569991 $0.181 S/13/zU11Dan Priest | 57000 $8/7 5/13/l0l1Dan Priest 570V10V71 $U/R 5/13/2021Ryan Orhvis / 57 $I00| 5/13/I0I1Brandy Alden \ 571031 $5.00 5/l4/I021North American Lighting Inc | 569821 $381.00 5/14/l8Z1John Little 56987 $58V/ 5/14/Z8IlA}hedDecnal)u | 569OO| s100.00i 5/14/20210 Donation Box 56994 $0301 5/14/Z0I1Susan Lutz 57018 $0.64 5/14/Z8ZlKendra Allen ) 57031 $0.18 5/14/IOIlPeter Pohlman | 57836 $0.46| 5/14/I021]ackie So»,| | 57044| $5.18 5/14/Z0ZlCollin Adler 57860 S10.O0/ 5/14/ZP2lKetvrphSchacht | �7061| / / �10�V0� / 5/zu/1021Constance Litwin 57063 $5�00 5/l4/10Z1Amber Edmunds 57093 $2A8 5/15/2O1{Mark Paul � 57102 $0.18| | S/l5/lO2lMark Paul / | �7l03 �U1O� �� 5/15/ZU21Kimberly Lewe||en 57105 $5�00 5/15/2011[nr|ieIngraham � / �7l06| $0.18 5/15/2021chLry1uoudram 57107 $10�00| 5/15/I0Z1Chase Benins 57114 $5.00 5/15/Z0llThomas Kasper 57116| $0,64 3/1S/Z81lSusan HuUe 57117 $5.00| 5/15/2OZ1Max Eddy 57118 $0.46 5/15/l8l1EvernrdoTonesRudhquez 57lI1| $l00| 5/15/ZU2lGayle Mundt 57llZ| $0,18 5/1s/2U11Gayle y4undt | 57123 $0,18| 357769 ]57769 357769 357769 357769 357769 357713 357713 357713 357713 317769 3J7769 357709 357769 357769 3S7769 35/769 357769 ]E7769 357769 � 357769 35)769 357769 7769 357769 357769 357769 357769 357769 357769 ��7 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2021 3rd Quarter - April 1, 2021 - June 30, 2021 5/15/2021 Claudia Garcia 57127 $5.00 357769 5/15/2021 Renee Bates 57833 $50.00 357769 5/16/2021 Kevin Lupton 57085 $5.00 357769 5/16/2021 Mary Tempest 57129 $20.00 357769 5/16/2021 Richard Yang 57140 $5.00 357769 5/16/2021 Kelly Michalak 57146 $5.00' 357769 5/16/2021 Hannah Wendt 57150 $5.00 357769 5/16/2021 Erin Murphy 57161 $0.18 357769 5/17/2021 KunalChitnis 57086 $5.00 357802 5/17/2021 Kathy Plafchan 57176 $5.00 357802 5/17/2021 Donna Buchan 57177 $10.00 357802 5/17/2021 Team Smith 57181 $0.64 357802 5/17/2021 Karen Benjamin 57189 $0.64 357802 5/17/2021 AlexaJoh 57195 $0.46 357802 5/17/2021 Mark Feldman 57202 $0.64 357802 5/17/2021 Damodar Konda 57207 $5.00' 357802 5/17/2021 Sheilah Calopsis 57222 $40.00 357904 5/17/2021 Tanya Murray 57227 $30.00 357802 5/17/2021 Lauren Cpsasnick 57236 $0.46 357802 5/17/2021 Brenda Zuniga-Renteria 57237 $0.36 358468 5/18/2021 Tammy Metrick 57249 $0.64 358468 5/18/2021 Tammy Metrick 57250 $0.46 358468 5/18/2021 Allyson Coppock 57263 $0.64 358468 5/18/2021 Scott Gogolin 57266 $0.64 358468 5/18/2021 Gayla Bonner 57270 $0.36 358468 5/18/2021 Adria Catalano 57275 $2.50 357904 5/18/2021 Jennifer Taylor 57282 $5.46 358468 5/18/2021 Tom Dasovic 57291 $20.00 358468 5/18/2021 Megan Kelly 57295 $0.47 358468 5/18/2021 Nicholas Ball 57306 $0.18 358468 116 OAKL&NDCOUNTY ANIkUALCONTROL AND PET ADOPTION CENTER KcstridedFunU(LeXacy)Dooadons' F»I0Z13rd(}ua/ter April 1,IOZ1 June 3O,ZUZ1 .�� �u�����`up��^��—^^^.�`z������^;/'-`�'� S/18/l0l1James Tonkovich 57308 $10.00 358468 5/18/Z0l1Jessica Gearhart 57315 $0.46 358468 5/18/2021AmeyoShi|oh6upte 57316 �0 .64 358468 5/18/l0I1Cullen Smith 57320 $5.46 358468 5/l8/10Z1Dory ]o|io 57326 $10.00 358468 5/19/Z021Diane Ouottrndnohi 57333 $5.00 358468 Donation 5/19/2021Donah �73J7 �1 .00 358092 Linda 5/19/2021d �73�9 �15 .00 358092 5/19/2021E|ioaStaooh|e 57340 $15.00 358092 5/19/Z0I1Christopher Kuffn:r 57365 $50.00 358468 5/19/l0Z1Tim Burns 5/360 $U.96 358468 5/19/Z0l1Melissa DiVita 57377 $20.00 358468 5/19/Z0l1Angie Creger 57373 $10.00 3584b8 5/1g/I0I1Diane Smith 57382 $20.0V 358468 5/19/l0l1Trisha Shapiro S7408 $0.64 358468 5/19/lUl1Charlene Babb 57411 $0.64 358468 5/Z0/I071Jennifer Buell 57399 $5.00 358468 5/I0/IUI1Jane Pahoo 574Z6 �0 .18 358468 5/IO/I0Z1Patrick Pawbske 37427 $0.46 358468 5/Z0/Z021Cheryl Koze|| 57441 $50.00 358092 5/l0/ZUI1Ruth Iittritmh 57450 $50.00 358468 s/10/ZVI1Daniel Cline 57456 $0.18 358468 5/l0/l0l1Julie Pabzzo)a 57459 $5.00 358468 5/20/20Z1John Minder 57473 $10.00 358468 5/20/I811Debra Kernen 57477 $40.0O 358468 5/I0/I0Z1Brand! Wells 57534 $018 358468 5/IU/IVI1Andrea Hernandez 57535 $U,46 358468 5/1U/1AI1Bonnie [uthre|| 57540 $0.9I 358468 5/10/Z0l1��an/VVidth �7�41 �I0��u �S84�8 5/10/Z0l1Tny|orGudand 5754Z . �064 ��8468 im OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2021 3rd Quarter 5/20/2021 Angel Jaramillo 5/21/2021 Rajanish Rajan 5/21/2021 Donation Box 5/21/2021 Greg Moss 5/21/2021 Patricia Serafini 5/21/2021 Kelly Whatlen 5/21/2021 Angel Jaramillo 5/21/2021 Chelsea Parker-Kruppi 5/21/2021 Patricia Serafini 5/21/2021 Tera Miglio 5/21/2021 Tera Miglio 5/21/2021 Tera Miglio 5/21/2021 Julie Stevens 5/21/2021 Kaylynn Henke 5/21/2021 Kaylynn Henke 5/21/2021 Nancy Kattoula 5/21/2021 Susan Sargent * Per J.T. 5/28/2021 Refunded 8 .96 JE#358539 5/21/2021 Kristine McLonis 5/21/2021 Kristin Rzeznik 5/21/2021 Lisa Selwocki 5/21/2021 J Rimatzki 5/21/2021 Jeffrey Davis 5/21/2021 Jacqueline Gardner 5/21/2021 Brian Welsbacher 5/21/2021 Jason McCoy 5/21/2021 Ann Hornick 5/21/2021 Connie Johnson 5/21/2021 Brian Wilson 5/22/2021 Jason McCoy April 1, 2023. - June 30, 2021 57554 $5.00 358539 57487 $5.00 358539 57495 $68.25 358164 57501 $30.00 359162 57504 $10.00 358539 57517 $0.05 358539 57518 $5.00 358539 57527 $5.00' 358539 57528' $10.00 358539 57564 $0.64 358539 57565 $0.64 358539 57566 $0.64 358539 57572 $5.00 358539 57577 $0.64 358539 57578 $0.46 358539 57580 $0.64 358539 57583 $0.96 358539 57584 $5.00 358539 57585 $5.00 358539 57587 $5.00 358539 57589 $5.00 358539 57591 $0.18 358539 57597 $0.64 358539 57605 $5.00 358539 57607 $5.00 358539 57610 $5.00 358539 57611 $0.92 358539 57737 $5.00 358539 57522 $5.00 358539 WE OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2021 3rd Quarter - April 1, 2021 - June 30, 2021 5/22/2021 Melinda Oviatt 5/22/2021 Julia Klee 5/22/2021 Shannon Nalepa S/22/2021 Ernesta Durakovic 5/22/2021 Nicole Juszczakiewicz 5/22/2021 Sharon Taylor 5/23/2021 Jillian Wright 5/23/2021 Sunitha Jain 5/23/2021 Becca Segers 5/24/2021 John Lukacs 5/24/2021 Cynthia Martin 5/24/2021 Christian Swanson 5/24/2021 Stephaielsenbarg 5/24/2021 Melissa Dues_ 5/24/2021 Heidi Schmidt 5/24/2021 Kim Madsen 5/24/2021 Kevin Wilmot 5/24/2021 Ann Mellert 5/24/2021 Ty 8eltramo S/24/2021 Lon Shook 5/24/2021 Bernadette Abrams 5/24/2021 Michael Bahorski SJ24/2021 Jane Bacon 5/24/2021 Amanda Colon 5/24/2021 Brenda Radke 5/24/2021 Shavani Thota 5/24/2021 Susan Hillger 5/24/2021 Emily Wojciechowski 5/25/2021 Paula Boegner 5/25/2021 Garima Kumar 57525 $5.001 57526 $10.00 57624 $0.64 57628 $5.00 57639 $5.00 57650 $5.00 57665 $5.00� 57676 $5.00 57812 $5.00 57681 $0.47 57693 $0.18 57700 $100.00 57703 $0.46 57708 $0.64 57717 $0.64 57741 $5.00 57745 $0.46 57751 $10.0o1 57755 $5.00 57764 $10.00 57767 $5.001 57771 $0.18' 57777 $5.00 57783 $0.64 57789 $5.00 57791 $0.18, 57792 $0.181 - 57795 $10.001 57800 $0.18, 57806 $1.001 358539 358539 358539 358539 358539 358539 358539 358539 358535 358539 358539 358246 358539 358539 358539 358539 358539 358539 35BS39 358539 358539 358539 358539 358539 358539 358539 358539 358539 358539 358539 121 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2021 3rd Quarter - April 1, 2021 - June 30, 2021 5/25/2021 Jonathan Lopatin 57813 $0.64 358539 5/25/2021 Kelly Pena 57814 $5.00 358539 5/25/2021 Cheryl Kozell 57817 $25.00 358344 5/25/2021 Anthony Phillips 57826 $10.00 358539 5/25/2021 Victoria Apigo 57829 $5.00 358539 5/25/2021 Nora Plank 57849 $5,00 358539 5/25/2021 Amanda Bird 57855 $50.00 358342 5/25/2021 Francisco Hernandez 57862 $0.18 358539 5/25/2021 Nicholas Penrose 57866 $0.46 358539 5/25/2021 Cheryl Mack 57868 $5.00 358539 5/25/2021 Lisa Yott 57889 $0.18 358539 5/25/2021 Michelle Hackman 57895 $0.18 358539 5/25/2021 Michelle Hackman 57896 $0.18 358539 5/25/2021 Marcella Milwee 57898 $0.18 358539 5/25/2021 Kelly Farrow 57904 $5.00 358652 5/25/2021 Amy Jensen 57910 $5.00 358539 5/26/2021 Joe Ingweiller 57906 $0.64 358652 5/26/2021 St Hugo of the Hills 579231 $230.00 358523 5/26/2021 George Montano 57942 $5.00 358652 5/26/2021 Stephanie Powell 57944 $5.00 358652 5/26/2021 Brian Gesaman 57961 $5.00 358652 5/26/2021 Jamie Cischke 57962 $0.18 358652 5/26/2021 Andrew Green 57963 $0.46 358652 5/26/2021 Tammy Schick 579661 $5.00 358652 5/26/2021 Kim Placentini 57976 $0.36 358652 5/26/2021 Lorein Natzke 57997 $0.64 358652 5/26/2021 Lisa Davis 58000 $10.00 358652 5/26/2021 Cindy Bartholomew 58001 $5.00 358652 5/26/2021 Jill Harris 58003 $0.96 358652 5/26/2021 Debra Kennard 58016I $0.64 358652 '1 22 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2021 3rd Quarter - April 1, 2021 - June 30, 2021 5, — 5/27/2021 Andrea Roll 58041 $5.00, 358652 5127/2021 Tammle McVeight 58044 $10.00 358652 5/27/2021 Stephen AmoIsch 58050 $7.00 359523 5/27/2021 Melissa Atkinson 58054 $0.93 358652 5/27/2021 MJ Pawluchuk 58072 $5.00 358652 5/27/2021 Morgan Cerny 58074 $5.00 358652 5/27/2021 Chad Morgan 58086 $5.00 358652 5/27/2021 Jeanie Williams 58091 $5.00 358652 5/27/2021 Caron Adams 58105 $50.00 358652 5/27/2021 Nicole Ocholik 58114 $10.00 358652 5/27/2021 Teresa Spiess 58120 $5.00 358652 5/27/2021 Brittany Flores 58121 $0.64 358898 5/27/2021 Sharon Beetham 58122 $10.00 358652 5/27/2021 Nancy Roberts 58125 $0.64 358652 5/27/2021 Joe Millard 58129 $0.12 358652 5/27/2021 Kiran Gatla 58129 $0.18 358652 5/27/2021 Nancy Rhame 58132 $5.00 358898 5/27/2021 Nancy Rhame 58133 $5.00 358898 5/28/2021 Jamie Brown 58110 $0.64 358898 5/28/2021 Jeanne Jantzen 58137 $5.00 358898 5/28/2021 George Campbell 58138 $5.00 358898 5/28/2021 Scott Lindroth 58140 $10.00 358898 5/28/2021 Lynette Todd 58141 $0.64 358898 5128/2021 Sarah Kirk 59144 $0.18 358898 5/28/2021 Kris Walker 58145 $0.64 358898 5/28/2021 Molly Breitschuh 5/28/2021 Nancy Gorman 5/28/2021 Jessica Koch 5/28/2021 Abigail Crusen 5/2812021 Jennifer Lewis 58147 $0.18 358898 58157 $0.96 358898 58159 $0.18 358899 58163 $036 358898 58167 $5.00 358898 123 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations 5/28/2021 Troy Butzin 5/28/2021 Suzanne Crockett 5/28/2021 Kirstie Yu 5/28/2021 Catherine 011esheimer 5/28/2021 Madeline Maher-Hocevar 5/28/2021 Denise Bielis 5/28/2021 Jessica Hagan 5/28/2021 Julie Allinder 5/28/2021 Freda Malin 5/29/2021 Josh Vollstaedt 5/29/2021 Kimberly Mathers 5/29/2021 Scott Roberts 5/29/2021 Linda Brewington 5/29/2021 Shawn Durso 5/29/2021 Shawn Durso 5/29/2021 Christy Wilson 5/30/2021 Chad Nicefield 5/30/2021 Mary Joan Razalan 5/29/2021 Laura Bennett 5/29/2021 Victoria Hicks 5/29/2021 Magdalena Jackowski 5/31/2021 Adam Beernhaert 5/31/2021 Rachael Miller 5/31/2021 Jeanie Bay 5/31/2021 Lori Anderson 5/31/2021 Kara McLauchlin 5/31/2021 Liza Hennessy 5/31/2021 Liza Hennessy 5/31/2021 Liza Hennessy 5/31/2021 Amrit Kohli FY 2021 3rd Quarter - April 1, 2021 - June 30, 2021 58184 58201 58204 58208 58258 58329 58600 58611 58661 58231 58243 58288 58307 58310 58311 58316 58330 58375 58498 58499 58557 58246 58266 58282 58302 58305 58475 58476 58477 58510 $0.46 $5.00, $5.00 $10.00 $0.18 $0.82 $10.00 $0.64 $5.00 $5.00 $5.00 $0.64 $0.64 $0.18 $ 0.64 $ 0.64 $ 0.64 $0.64 $0.64 358898 358898 358898 358898 358898 358898 358898 358898 358898 358898 358898 358898 358898 35889E 358898 358898 358898 358898 358898 358898 358898 358898 358898 358898 358898 358898 358898 358898 358898 359004 124 O,AKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2021 3rd Quarter - April 1, 2021 - June 30, 2021 5/31/2021 Juliann Gallagher 58560 $0.92 5/31/2021 Brent Berman 58627 $5.00 5/31/2021 Brent Berman 58628 $0.18 5/31/2021 Elizabeth Beauchamp 58668 $0.18 5/31/2021 Amrit Kohlli 6/1/2021 Siddhesh Pimpale 6/1/2021 Douglas Berg 6/1/2021 Deborah Reynolds 6/1/2021 Linda Herald 6/1/2021 Kenzie Feeney 6/1/2021 David Lear 6/1/2021 Deborah Paladino 6/1/2021 Denise Palacios 6/1/2021 Denise Palacios 6/1/2021 Vicki Callison 6/1/2021 Jocelyn McGaffic 6/1/2021 Mallory Sharpe 6/1/2021 Susan Mencer 6/1/2021 Laura Dodd 6/1/2021 Dan Corcoran 6/1/2021 Jennifer Kadans 6/1/2021 Jennifer Kadans 6/1/2021 William Barrett 6/1/2021 Tiffany Giammarco 6/1/2021 Lawrence Starzyk 6/1/2021 Emily Luttenbacher 6/1/2021 Kendra Dorsey 6/1/2021 Caroline Jones 6/2/2021 Courtney Pachuta 58510 58268 58314 58353 58363 58377 58379 58397 58414 58415 58418 58437 58471 58479 58481 58486 58504 58505 58538 58578 58589 58598 58626 58634 58440 May 2021 Total $0.64 $5.00 $20.00 $5.00 $5.00 $0.28 $39.18 $10.00 $0.64 $0.64 $10.00 $0.36 $0.18 $5.00 $5.00 $10.00 $0.64 $0.64 $ 5.00 $ 5.00 $20.00 $5.00 $ 0.64 $0.18 $5.00 358898 358898 358898 358898 $3,551,63 359004 359004 359004 359004 359004 359004 359004 359004 359004 359004 359004 359004 359004 359004 359004 359004 359004 359004 359004 359004 359004 359004 359004 359004 359004 125 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2021 3rd Quarter - April 1, 2021 - June 30, 2021 5/2/2021 Aashika Shah 58466 $0.47 359004 6/2/2021 Cheryl Seiferlein 58514 $5.49 359004 6/2/2021 Loretta Kargol 58515 $5.00 359004 6/2/2021 Christopher Williams 58531 $10.00 359004 6/3/2021 Kevin Wisely 58593 $0.47 359230 6/3/2021 Ian Bonner 58620 $10.00 359230 6/3/2021 David Klott 58645 $0.11 359230 6/3/2021 Gustavo Perezrios 58670 $0.01 359230 6/3/2021 Mark Brummer 58696 $10.00 359230 6/4/2021 Hilary Binder 58714 $10.00 359230 - 6/4/2021 Donation Box 58717 $6.32 359313 6/4/2021 Susan Gartner 58718 $50.00 359313 6/4/2021 Mark Mudd 58723 $5.00 359313 - 6/4/2021 Vanessa Kangas 58726 $0.47 359230 6/4/2021 Vanessa Kangas 58727 $0.47 359230 6/4/2021 Emily Kelley 58732 $10.00 359230 6/4/2021 Karen Duguay 58734 $10.00 359230 6/4/2021 Christina Bailey 58745 $0,02 359230 6/4/2021 Terra Alexander 58750 $10.00 359230 6/4/2021 Adil Ashraf 58752 $10.00 359230 6/4/2021 Kathleen Sadler 58779 $5.00 6/4/2021 Kishore Tammineedi 58858 $5.00 359230 6/4/2021 Refund (-5.00) 359230 6/4/2021 Refund (-0.18) 359230 6/5/2021 Sarah Schrag 58794 $10.00 359230 6/5/2021 Ambika Puliyakote 58796 $1.00 359230 6/5/2021 Joanne Copeland 58800 $10.00 359230 6/612021 Trish Blascak 58805 $0.01 359230 6/6/2021 Brandi Middleton 58807 $0.01 359230 6/6/2021 Eric Martin 58809 $6.01 359230 Im OAKLANDCOUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund <Legacv\Donations ' FYl0213xi Quarter ' April l,l8ll'June J02021 aa— fj 6/7/I0I1Donation Box 58818 $20.00 359315 6/T/l0l1Tammy Bemis 58326 $10.0O 359565 6/7/Z0I1Terra Hoh/ 58848 $0.47 359565 6/7/ZOZ1Cheryl Koze|| 58862 $75.00 359313 6/7/I0l1Brenda Begley 58871 $18,00 359565 6/7/2Ol1Mark Santos 58879 $100.80 359430 6/7/2021Leted�N��|e S88O8 �z .00 359565 6/7/1Az1Sandra pedt �8800 �0 .94 35956s 6/7/20I1AkaenjiVViliams 58898 $O.0l 359565 6///20I1Darlene 8rukenshaw 58900 $5�00 359565 6/8/I021[rickaG|ennio 58902 $2.4/ 359565 6/8/1021HaiHuang 58903 $5.00 359565 6/8/10I1Claudia x|va,ndo'Everardn 58907 $8.01 359565 6/8/l0Z1Jane Carpenter 58910 $10.00 359565 6/8/10I1Donation Box 58916 $1J2 359418 6/8/l0I1Alfred Demai|o 58917 $100.00 359428 6/8/Z0llJames Bedor �89l8 �l0V .00 359428 6/8/lV21William Auquier 58919 $200.00 359428 6/8/I0llKendra Scott 58920 $84.31 359428 6/8/Z021Jessica Robinson 589I3 $30.00 359418 6/8/20l1DeannHawkins 58950 $5730 359430 6/8/10I1Donation Box 58964 $65.00 359430 6/8/zozzKimberly Blomberg 58975 s5.00 359565 6/8/20IlTmdeHoover 58977 $5.00 35956S 6/8/I0l1Becky VVo|ford 68993 $0.47 3S9565 6/8/I0l1�mi,hae|Cbrk �9Ull �0�47 ��956� 6/9/l0zzNorma Neumann 59030 $5.0O 359565 6/9/ZO11Wendy Reeves 58064 $0.V1 359565 6/9/20l1Danielle Gallo 59066 $O.01 359565 " 69/1011Karen Bray 59082 $50.00 359743 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (LeOary)Donations FYIVZ13rdQuarter ' April 1/1011'June 30,2OI1 6/9/20I1Jeffrey Loll 59085 $0.9* 359565 6/9/20I1kAo|isaNeff 59092 $5.00 359565 6/9/ZVZ1Julie Miller 59095 $3.48 359565 6/9/1A11Dustin Skavang 59108 $0.47 3S9565 6/10/2uzzCrystal Rosck 59107 $0.47 359811 6/10/20Z1(arhneHolliday-McNeill 59112 $0.47 3S9811 6/10/I0l1Daniel nathsbu,X 59117 $5.80 359811 6/1V/1A11Cheryl unze|! 59118 $75.00 359745 6/10/2Uz1Donation Box 59111 $20.00 359743 6/1U/I0Z1Sonya Kavnurns 59133 $0.01 359811 6/10/Z011Michelle 8orgre» 59148 $0.47 359811 6/10/IUZ1VYennnabBrown 59161 $50,00 359745 6/10/ZOIlJasmine Holing 59279 $0.01 3S98J_i 6/1U/I0l1Erin Molnar 59291 $5.00 359811 6/10/I0Z1Kimberly Stmde, 59306 $0.01 359911 6/10/1VzzJuan Lopez 59237 $5.00 359811 6/11/I02101haMarun/k 59187 $5m' 359811 6/l1/2011Kevin Locher 59196 $25.00 359852 6/11/I021Nico|e Summers 59219 $5.00 359811 6/11/202101haMo/osyk 5923S $5.00 359811 6/11/l021Heather DeUk»t 59237 $5.00 3S9811 6/11/1021]eff Strauss 59249 $10.00 359811 6/11/1U21Michael Klein 59268 $zuo 359811 6/1z/ZOl1Colleen 0dil 59357 $0.47 359811 6/11/Z01lFaith Zagoru NA '$0.47 359811 6/11/I0I1KoxieVVint N8 '$10.00 359811 6/1I/lU11Jeremy Scott 59226 $580 359811 6/1l/lU21Jeremy Scott 592I7 $5.00 359811 6/1Z/2011Dawn Dicker 59230 $0.47 359811 6/11/1021Ter,iKrasicky �9l39 �Z000 . �59811 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2021 3rd Quartet, - April 1, 2021 - June 30, 2021 `,``,�``-'�'-'`—`-=~'^^' ~-^~' --'-'-'- ---'--- 6/1Z/l0I16i&enaCananzaFoo|era 59260 $0.47 359811 6/12/2021Kimber|yYVamdey 59269 $5.00 359811 6/1l/2DZ1 Nina Fc|ide 59317 $5.00 359811 6/1I/l0Zl Brandon Stenger 59318 $10.00 359811 6/13/Z0l1 Stephanie Poulos 59267 $5.00 359811 6/13/1VZ1 Danielle Zobek 59278 $0.47 359811 6/l4/Z0Z1 Coleman Teach 59248 $10.00 359811 6/14/I0Z1Ki,stenMancini 59312 $lOO 359811 6/14/2011Puv|Hovun 59344 $5.00 359811 6/14/Z0I1 Lauren Todd 59353 $0.47 359811 6/zu/1Az1 Tammy Tayur-Teoin 59360 $0.94 359811 6/14/10l1 Karla Garcia Maio Lopez 59385 $0.01 360174 6/]4/20Z1Syd,aRamirez 59387 $5.00 360174 6/1u/l0Z1TonyaHooper 59395 $5.00 360174 6/14/l0Z1 Phillip Eddy 59397 $5.80 3t)0174 6/l5/2VZ1 Shane Phillips 59403 $5.00 3601/4 6/1S/20Z1 Nestor Esquer 59431 $0.01 360174 6/z5/zoz1 Daniel Sullivan 59443 $50.00 360054 6/15/l0Il Jeffery Camp 59465 $0.47 360174 6/15/ZOl1KhsdnaO'Brien 59468 $5,00 360174 6/15/IUZ1 Stephanie Terry 59476 $10.00 360174 6/15/ZDI1 Stephanie Terry 59477 $10.00 360174 6/15/1011 Stephanie Terry 59478 $10.00 360174 6/15/2811 Carole Ward 59486 $5.00/ 360174 6/15/2O21 Donna Martin 59488 $0.47 360174 6/16/z011 Chad Brooks 59489 $16.01 3601711 6/16/Z0Z1 Chad Brooks 59490 $16.01 360174 6/16/Z011[majaneMyers 59492 $0,01 360174 6/16/2021]iUinnMullins 59513 $0.47 360174 6/16/lAI1 Allan Mullins 59514 $0.01 360174 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations 21 Valerie Valentine 6/16/2021 Bailee Clanton 6/16/2021 Kathleen Phillips 6/16/2021 Victoria Schaap 6/16/2021 Denise Lund 6/16/2021 Kristi Beno 6/16/2021 Marlene De Andrade 6/16/2021 Diane Mabry 6/17/2021 Renee Kirkpatrick 6/17/2021 Elizabeth Raschke 6/17/2021 John Mager 611712021 Tara Saldana 6/17/2021 Sowjanya Kolli 6/17/2021 Cheryl Dunn 6/17/2021 Erin Ellsworth 6/17/2021 (5321 Old Cove) Murphy 6/17/2021 David Dlugosielski 6/17/2021 David Jennings 6/17/2021 Irene Servello 6/17/2021 Tiffany Greco 6/18/2021 Elizabeth Berry 6/18/2021 Phyllis Fangel 6/18/2021 Karen Draper 6/18/2021 Ronald Hicks 6/18/2021 Lupe Salinas 6/18/2021 Linsa Wyse 6/18/2021 Sharla DenOuden 6/18/2021 Sharla DenOuden 6/18/2021 Kuressa Reghi 6/19/2021 Laurie Hilligoss FY 2021 3rd Quarter - April 1, 2021 - June 30, 2021 59526 $5.00' 360174 59535 $0.01 360174 59544 $10.00 360174 59553 $0.47 360174 59555 $20.00 360056 59563 $0.01 360174 59568 $0.02 360174 59570 $0.01 360174 59584 $10.00 360174 59596 $0.47 360174 59600 $20.00 360174 59611 $10.00 360174 59613 $0.01 360174 59616 $5.00 360174 59624 $5.00 360174 59635 $0.47 360174 59637 $5.00 360174 59643 $5.00 360174 59647 $5.00 360174 59652 $20.00 360174 59655 $0.47 360174 59677 $0.01 360174 59684 $5.00 360174 59689 $1.00 360174 59700 $57.50 360217 59701 $25.00 360283 59717 $0.01 360174 59718 $0.01 360174 59864 $0.02 360174 59714 $50.00 360283 1a0 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (LeKacy)Donations ' FYJOZl3rdQuarter April 1,lOIl'June 38,IV2l 6/ID/Z02lTaylor Hill 59751 $5,00 360174 6/Z0/1o21Elizabeth Harris 59755 $10.00 360174 6/2V/10l1Danielle Braniecki 59756 $0.47 360174 6/20/z0Z1Kenneth vvozny 59759 $5.00 360174 6/71/1OZ1Cheryl Kozel[ 39753 $50.00 360283 6/Z1/7U11Sarah Hihhen 59806 $0.01 360524 6/21/lA11[hrista|Mendoza 59808 $0.47 360524 6/21/20I1Stephanie Boehnos 59809 $0.01 360514 6/Z1/Z0I1VCA[PA[Donation Box 59819 $2.47 360283 6/I1/I0Z1Raymond Lavigne 59827 $100.00 360581 6/l1/Z0l1Jessica Smith|ing 59839 $0.01 360524 6/Z1/1011Katherine Struh| 59840 $5.00 360524 6/21/20I1]ohnathanZampino 59843 $5.00 360524 6/l1/Z021Jeff Van Huuzen 59844 $0.01 360524 6/l1/Z8z1Gabby Hnn 59848 $0.01 360524 6/l1/l0l1Hannah Stephens 59853 $O.47 360524' 6/12/2021Shuyingkn 59860 $20.80 360524 6/I1/I021Steve VaUieres 59872 $10.00 360524 6/lI/IUl1Mark yenxu 59876 $5.00 360524 6/ZZ/1011Cindy Maude 59879 $10.00 360524 6/2z/1o2zK/isdonAgar 59911 $0.01 360524 6/11/I0IzKim Haidip 59942 $0.81 360524 6/II/20I1Danielle Jezdimir 59946 $0.0l 360524 6/23/2021Meghunienzcn 59957 $O.0l 360524 6/23/2021She|iahCa|npids 59961 $100.00 360579 6/I3/I021Kim Drayton 59966 $0.01 360524 6/I3/20I1Min&bviGiebd 59967 $50.00 360581 6/l3/l0Z1Susan Johnson 59981 $30.00 360579 6/I3/Z0l1Shawn Do|ato 59985 $0.47 360524 i31 OAKL40DCOUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Pvnd(LeFncy)Donations - FY207l3,dQuarter - April l,Z021'June 3[iZVIl 6/Z3/ZOIlMorgan Silva 59986 $0.01 360524 6/I3/I011Julie Pnbski 59988 $0.48 360524 6/23/Z0l10rstenTuttle 60019 $5.00 360524 6/l3/1011Kim Thompson 60824 $0.0I 36052* 6/23/2021cudixxattinson 60015 $0.01 360524 6/24/2021 Joanne Berry 60009 $50.00 368581 6/I4/I021John Little 60015 $5.00 360579 6/24/2021Wiroh|eVainner 60030 $20.00 360670 6/24/20I1)oXnnk«cKeuXh 60032 $5.00 360670 6/I4/l0llLisa Smith 60037 $5.80 360670 6/I4/I0I1Victor Tdia 60042 $5.00 360670 " 6/24/lOZ1loan Pop 60057 $5.00 360670 6/l4/z021Jake Spaccanxe||i 60102 $0.47 368670 6/l4/20Z1Daniel Ngvyen'Tran 6011I $0.47 360670 6/24/2021Sarah Bradford 60113 $0.02 360670 6/14/l011Taylor 8erth»ume 68115 $0.01 360670 6/l5/lOI1Mike Kahan 60138 $20.00 360670 6/I5/Z0Z1Lola Redmond 60142 $0,01 360670 6/25/2021ShaheAmbrey 60181 $20.00 360670 6/25/l8ZlSri Woods 60183 $5.00 300670 6/26/2021MeghanKosteo 60185 $580' 360670 6/26/l0Z1Ashley Rea 60188 $Um 360670 6/26/I0210sxaoOconnor 60198 $0.01 360670 6/26/I0I1Rebecca Haines 60192 $10.00 360670 6/1D/l0l1Brandon xXootervon 60I27 $0.47 361049 6/1S/1011Thomas VYi||hwft 60237 $0.47 361049 6/I8/Z021KristyFollett 60I42 $0.47 361049 6/28/Z071Larissa FreireLobo Nnchi 60258 $0.47 361049 6/l8/IVl1ShannaStamps 00281 $5.00 361049 6/28/I0I1Raymond Knrt 60183 $7.47 361049 132 D4KiAN0COUNTY AN|[0AlCONTROL AND P[TADO PT|0NCENTER Restricted Fund (Legacy)Donations FY%OIl3rdQuarter April l/I8Z1'June 3O.Z0ll 6/Z9/IVI1K8ichaeiClifford 60298 �10 ,00 361049 6/l9/1011Shannon Hukta 60311 $0.01 361049 6/29/ZOZ1Sal Goprisetty 60326 $10.00 36104-3 6/19/2VxzMichael Kxv/rish 60341 $100.00 360941 6/l9/20Z1��e|isaClark 60�44 �0�U1 �6104� 6/29/2021Lana Sinma 60350 $10.00 361049 6/29/2021Cpmi5iberson 60355 $0.03 361049 6/z9/1021Sarah Berry 60357 $5.00 3610*9 6/Z9/z011Leslie oiebo{ 60358 $0.01 361049 6/19/I8I1Christopher Bales 60671 $0.01 361049 6/29/1011Pnvhni|!un 60676 $0 .02 361049 6/30/z021Jacqueline Cruz 60372 10.47 �61049 Christensen 6/J0/ZAI1Lisa Chh 60�78 �0 .01 361849 6/30/l0Z1Sandra Sollars 60379 $0.47 361049 6/30/I0Z1Kelly Husted 60385 $0.47 361849 S/30/20l1Matthew Boyle 60397 $10.00 361049 6/]V/Z0ZlMikny|aDunn 60405 $0.01 361049 6/3n/z02zSheilah ca|opids 60415 $40.00 361074 6/30/20I1 Sheila Knoche 60421 $5.00 361049 6/JV/lUI1Kevin Terry 604I8 $l.01 361049" 6/3o/l021Ann Vermceoch 60431 $1.00 361049 6/30/Z021Cathleen K«nravvski 60432 $0.47 361049 6/30/2V11Alexandra peind| 60435 $I0.00 361049 6/3U/Z0l1Christopher Zbozien 61150 $0.47 361049 6/30/I0IlDawn Smith 60677 $5.0O 361049 6/30/1011TonyN��ox �0 .47 361049 June 2VI1Total $2,799,11 Department of Public Health Oakland County Children's Village Donation Tracking : Donation Period April 2021 to June 2021 Date: Donor: Cash/Check: 3/8/2021 CV "Foundation 4/1/2021 St. William Parish Youth Ministry 4/15/2021 Sweet Dreams for Kids 4/26/2021 Tome Ivezaj 5/4/2021 Daughter of Isabella 5/20/2021 Sweet Dreams for Kids 5/20/2021 CV Foundation 6/11/2021 CV Foundation 6/14/2021 Sweet Dreams for Kids 6/16/2021 CV Foundation 6/16/2021 CV Foundation 6/17/2071 Welcome Baptist Church 6/28/2021 St Mary Of The Hills 6/29/2021 Lucas Demont Check Items: Estimated Value: (2) Rocking Chairs - Mandy's Place $1,303.82 16 Easter Baskets $300.00 15 Pillow Cases $225.00 Amazon Gift Card - MP Aquarium $450.00 Pillow Cases $300.00 15 Pillow Cases $225.00 Diamond Craft Art Kits $1,040.12 Campus Ice Cream Truck Treats $1,524.00 15 Pillow Cases $225.00 Jeans/Tennis Shoe Purchase $2,100.00 Courtesy Driving School For Resident $325.00 Gift Cards For Pizza Party $155 00 Toiletries, Games, Art Supplies $1,215.00 Books and Amazon Gift Cards $800.00 Total: $10,187.94 134 OAKLAND COUNTY PARKS & RECREATION COMMISSION FY 2021 3Q Report for Contributions (Donations) - April 1, 2021- June 30, 2021 RNC Contribution - General Nature Center Silvia Enea $20.00 RNC Contribution - General Nature Center Park Patron $10.00 RNC Contribution - General Nature Center Park Patron $1.00 Red Oaks Nature Center -Total $31.00 IND Contribution - General Mark Whiting $ 20.00 Independence Oaks - Total $20.00 ADM Oak Hill Round -About Payment Road Commission for Oak. Co. $ 2,044.00 Administration Total $2,044.00 Grand Total $2,09S.00 DEPARTMENT OF HEALTH AND HUMAN SERVICES - HEALTH DIVISION FY 2021 3Cti Report for Contributions (Donations) - April 1, 2021- June 30, 2021 4/21/2021 Frances Kendall 15.00 $15.00 $15.O0 Grand Total $15.00 'i 36 . o,%ce , ) 0x1- }une 30 , 1p21