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.03.25 - 34250
MISCELLANEOUS RESOLUTION #21091 March 25, 2021 BY: Commissioner Gwen Markham, Chairperson, Finance Committee IN RE: MANAGEMENT AND BUDGET - FISCAL YEAR 2021 FIRST QUARTER FINANCIAL FORECAST AND BUDGET AMENDMENTS To the Oakland County Board of Commissioners Chairperson, Ladies and Gentlemen: WHEREAS Public Act 621 of 1978, the Uniform Budgeting and Accounting Act for Local Units of Government, provides for adjustments to the adopted budget; and WHEREAS in accordance with Oakland County General Appropriations Act Section 22, which authorizes budget amendments for variances between the budgeted revenue and actual revenue, and Section 23, which authorizes budget amendments for variances between estimated revenue and projected expenditures, amendments are required; and WHEREAS the Fiscal Year (FY) 2021 First Quarter Financial Forecast Report has identified several variances and budget amendments are recommended; 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 $24,785 is being recognized for eligible personnel, forensic lab and training costs for dispatchers and corrections officers; and WHEREAS a FY 2021 — FY 2023 budget amendment of $4,000 is recommended for the Sheriff's Office to reallocate the budgets between expenditure line items to accurately reflect the budgets with actual activity; and WHEREAS a FY 2021 budget amendment totaling $142,540 is recommended for the Sheriff's Office to reallocate the expenditures budget from Other Expendable Equipment (Account 750170) $77,540 and Equipment Maintenance (Account 730646) $65,000 to Expendable Equipment (Account 760157) for the purchase of additional Oakland County Astro P25 Radio System mobile, portable and control station radios as part of the OpenSky Public Safety Radio System replacement (over the allotted project allocation); and WHEREAS a budget amendment totaling $5,000 is recommended for the Sheriff's Office to recognize FY 2020 High Density Drug Trafficking Area (HIDTA) Amendment #1 and Amendment #2. Amendment #1 reallocates $806 from Overtime expenditure line item (Account 712020) to the Communications expenditure line item (Account 730324) causing no financial impact to the original award. Amendment #2 recognizes additional funding in the amount of $5,000 from the Michigan State Police to be used for overtime costs for Narcotics Enforcement Team (NET) commander. Also, Amendment #2 extends the deadline to use the additional funds and reporting to September 30, 2021. Amendments #1 and 2 are less than fifteen percent of the original agreement (M.R. #20226); and WHEREAS a FY 2022 — FY 2023 budget amendment is recommended for General Fund/General Purpose Non -Departmental Grant Match (Account 730800) in the amount of $262,090 and Sheriff's Office Drug Policy Grant Fund (#27320) totaling $479,170, reversing the FY 2022 and FY 2023 budgets reflected in M.R. #20566 FY 2021 Oakland County Narcotics Enforcement Team (NET) Byrne Grant Acceptance (grant project GR0000000985) as the award period is October 1, 2020 through September 30, 2021; and WHEREAS a FY 2021 budget amendment of $2,500 is recommended for the Sheriff's Office to recognize a donation from Snelson Companies to be used for the Chaplain's Corp; and WHEREAS a FY 2021 — FY 2023 budget amendment totaling $30,134 is recommended for the Clerk/Register of Deeds Department correcting the department number referenced in M.R. #20458 County Clerk/Register of Deeds — Delete and Create Positions, reallocating a portion of the salaries and fringe benefit budgets from County Clerk/Elections Division (2010301) to to County Clerk/Register of Deeds Administration Unit (2010101) as the resolution created a Part -Time Non -Eligible 1,000 hour County Clerk Communications and External Affairs Coordinator position for the County Clerk/Register of Deeds Administration Unit; and WHEREAS a FY 2022 — FY 2023 budget amendment is recommended for the Board of Commissioners adjusting Salaries and Fringe Benefits due to the Stipend Increase for the Chairperson of the Board, Vice Chairperson of the Board, and the Majority and Minority Chairperson(s) (per M.R. #20662 - Board of Commissioners -Compensation Adjustments for Elected Officials); and WHEREAS a FY 2021 — FY 2023 budget amendment of ($83,283) is recommended for the Health Division to adjust Health State Subsidy revenue line item (Account 615675) as the actual funding received from the Michigan Department of Health and Human Services is lower than the budget (M.R. #20331). Also, to offset and reallocate the budget between expenditure line items as the budget referenced in M.R. #20331 Health and Human Services/Health Division — Michigan Department of Health and Human Services Local Community Stabilization Authority Funding was inadvertently recorded to Personal Mileage expenditure line item (Account 731346) rather than Professional Services expenditure line item (Account 731458); and WHEREAS a FY 2021 — FY 2023 budget amendment totaling $3,276 is recommended for the Emergency Management and Homeland Security correcting the department identification number referenced in M.R. #20523 Central Services — Fleet Expansion of One Vehicle for Emergency Management and Homeland Security; and WHEREAS a FY 2021 budget amendment is recommended for Public Service's Animal Control Division to accept reimbursement funding of $2,650 from the December 91h, 2020 through December 11th, 2020 Bissel Pet Foundation's Empty the Shelter event. Miscellaneous Resolution (M.R.) #19006 authorizes Management and Budget to administratively process grant agreements and 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 of $385,020 is recommended for Public Service's Animal Control Division to cover the costs of a cleaning contract to clean the Animal Control Shelter and animal cages and to cover the cost of supplies. This contract has been initiated due to the COVID-19 pandemic as Sheriff Inmate trustees are no longer able to clean daily; and WHEREAS a FY 2021 budget amendment is recommended for Non -Department General Fund/General Purpose fund (#10100) for the return of unused County funds in the amount of $113,385 from the Building & Liability fund (#67700) for the Water Main Extension Greencastle Subdivision- Farmington Hills project (M.R. #17254); and WHEREAS a budget amendment is recommended for Non -Department General Fund/General Purpose fund (#10100) correcting the Classification and Rate Change budgets in the amount of $50,000 for FY 2021; $57,285 for FY 2022 and $58,017 for FY 2023; and WHEREAS a FY 2021 budget amendment of $9,450 is recommended for Non -Department General Fund/General Purpose fund (#10100) reallocating the budget between department identification numbers as the incorrect department identification number was referenced in M.R. #21019 - 52/1 (Novi) District Court Michigan Drug Court Grant agreement; and WHEREAS a FY 2021 budget amendment is recommended within the Children's Village Division in the amount of $25 to transfer funding from the Children's Village Donations Fund (#21330) to the Child Care Fund (#20293) which properly accounts for expenditures eligible for Children's Village Donation funding; and WHEREAS a FY 2021 budget amendment is recommended within the Child Care Fund to reallocate the budgets between revenue line items to accurately reflect the Carry Forward as it was referenced incorrectly within the FY 2020 Year End Report and Budget Amendments (M.R. #20635); and WHEREAS a FY 2021 budget amendment is recommended for the Circuit Court to accept funding in the amount of $10,000 for the FY 2021 Michigan Drug Court Grant Program — Veteran's Treatment Court agreement for the period of October 1, 2020 through September 30, 2021. Miscellaneous Resolution (M.R.) #19006 authorizes Management and Budget to administratively process grant agreements and 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 of ($20,000) is recommended for the Circuit Court as FY 2020 Michigan Drug Court Grant Program — Veteran's Treatment Court agreement was for the period of October 1, 2019, through September 30, 2020; and WHEREAS a FY 2021 budget amendment is recommended for the 52/2 (Clarkston) District Court to accept funding in the amount of $9,000 for the FY 2021 Michigan Drug Court Grant Program agreement for the period of October 1, 2020 through September 30, 2021. Miscellaneous Resolution (M.R.) #19006 authorizes Management and Budget to administratively process grant agreements and 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 of ($10,000) is recommended for 52/2 (Clarkston) District Court as the FY 2021 Michigan Drug Court Grant Program agreement was for the period of October 1, 2019, through September 30, 2020; and WHEREAS a FY 2021 budget amendment (Budget Adjustment #1) is recommended to transfer funding in the amount of $24,000 from the MIDC Fund (#20260) to the Project Work Order Fund (#40400) (Project # 100000003337) (Will be required under MIDC Standard #5) in order to engage in the design services located in the Legal Resource Center; per Miscellaneous Resolution #15231 which allows administrative approval of capital improvement program projects under $30,000, and WHEREAS the Economic Development Corporation (EDC) Board has approved the FY 2021 Special Revenue Budget for the EDC Fund (#21180) in the amount of $12,400, a budget amendment totaling ($3,500) is required to amend the FY 2021 — FY 2023 budgets; and WHEREAS a FY 2021 budget amendment of $14,411 is recommended for the Health and Human Services division to reallocate the budget between expenditure line items accounts for the Children's Special Health Care Services Care Coordination (CSHCS) Outreach and Advocacy grant (#28563) correcting the budget entry referenced in M.R. #20459 Health and Human Services/Health Division — Fiscal Year 2021 Local Health Department (Comprehensive) Agreement; and WHEREAS a FY 2021 — FY 2023 budget amendment of $5,550 is recommended for the Health and Human Services division to reallocate the budget between expenditure line item accounts for the HIV Prep Clinic Grant (#28629) as the budget referenced in M.R. #20459- Health and Human Services/Health Division — Fiscal Year 2021 Local Health Department (Comprehensive) Agreement was inadvertently made to Material Supplies expenditure (Account 750294) rather than to Incentives expenditure line item (Account 750245); and WHEREAS a FY 2021 budget amendment of $7,203 is recommended for the Neighborhood and Housing Development (formerly Community & Home Improvement) to recognize the second round of funding for Comprehensive Housing Counseling Grant Program. The funding will be used for counseling services. Miscellaneous Resolution (M.R.) #19006 authorizes Management and Budget to administratively process grant agreements and 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 budget amendment totaling ($1,429) is recommended for the Neighborhood and Housing Development's Community Development Block Grant (CDBG) to reduce the budget allocation per Housing and Urban Development (HUD) October 22, 2020 Correction Notice; and WHEREAS a FY 2021 budget amendment is recommended for Facilities Maintenance & Operations to reallocate $9,721 from Salaries Regular expenditure line item (Account 702010) and $1,050 from Fringe Benefit Adjustments expenditure line item (Account 722900) under FMO Building Safety (Department 1040770) to Salaries Regular expenditure line item (Account 702010) and Fringe Benefit Adjustments expenditure line item (Account 722900) under Building Safety Division (Department 1110102) due to reorganization of departments (M.R. #20461 Transfer of Homeland Security and Building Safety); and WHEREAS a budget amendment totaling $513,520 is recommended to Information Technology Fund (#63600) to reallocate funds between divisions due to the FY 2021-2022 Master Plan priorities established by the Leadership Groups, and WHEREAS a FY 2021 budget amendment is recommended for the Information Technology fund (#63600) in the amount of $230,000 to cover the annual IT software maintenance costs for the Sheriff's Jail Management System; and WHEREAS a FY 2021 - FY 2023 budget amendment totaling $35,700 is recommended for the Fringe Benefit fund (#67800) of which $28,500 is being reallocated to correct the department identification numbers due to Children Village's change in reporting structure (M.R. #20202 Human Resources - Transfer of Division between County Executive Departments) and an amendment of $7,200 is recommended to increase the expense line item for Travel and Conference to realign the budget to more accurately reflect the budget due to historical trends and anticipated future travel costs for FY 2021 - FY 2023; and WHEREAS a FY 2021 budget amendment totaling $5,379,840 is recommended for Parks and Recreation fund (#50800) which consists of adjusting the Property Tax Levy revenue line item $7,846,300 to reflect the passage of a .35 10-year millage; offsetting the use of Planned Use of Balance ($2,412,046). Also, includes the reduction of Income from Investments revenue line item ($100,000) based on projected returns on investments and Prior Years Adjustments of $43,559 for the reclassification of expenses for CIP#3324 RWP Splash Pad Family Restroom project and amend Refund Prior Year Expense $2,027 reflecting credit on a statement for Bartlett Learning LLC for bus lease deposit. The amendment also includes adjustments for operating expenses: increase in Transfer to Municipalities for the lapsed funding of $521,250 for Normandy Oaks (M.R. #19042); increase Depreciation $414,500 for buildings, park improvements and equipment based on completed projects; amend General Program Administration $29,796 for asset removal program related to Greenhouse deconstruction and White Lake Golf Course rental house removal; amend BMX operations for $5,250 for anticipated activities; amend Adj. Prior Years Exp $3,058 for a credit applied to Consumers Energy and parts for a John Deere loader; offset by $4,405,986 Budgeted Equity Adjustments to balance the fund; and WHEREAS the Parks and Recreation Commission has requested write-offs totaling $418 for the period of October 1, 2020 through December 31, 2020 for uncollectible transactions; and WHEREAS the Human Resources Department has requested a write-off totaling $81.98 of which for the period of October 1, 2020 through December 31, 2020 for uncollectible healthcare contributions due to benefit contributions arrearages-post separation; and WHEREAS Department of Public Services, Animal Shelter and Pet Adoption Center received donations for the period of October 2020 through December 2020 totaling $36,575.61; and WHEREAS Department of Health and Human Services, Children's Village Division received donations for the period of October 2020 through December 2020 totaling $28,365.16 of which $3,601 was a cash donation; and WHEREAS a donation is recognized in the Water Resources Commissioner (WRC) in the amount of $5,400 for check #25820, dated 12/29/2020 from Argus Industrial Co. LLC to assist City of Pontiac residents for past due water bills owed to WRC; and WHEREAS Parks and Recreation Commission received donations for the period of October 2020 through December 2020 totaling $1,600. NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year 2021 First Quarter Financial Report. 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, Water Resources Commissioner, Sheriff's Office and Parks and Recreation Commission. BE IT FURTHER RESOLVED that the FY 2021 — FY 2023 Budgets are amended pursuant to Schedules A and B. Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution. 4", /�"ice Commissioner Gwen Markham, District #9 Chairperson, Finance Committee FINANCE COMMITTEE VOTE: Motion carried unanimously on a roll call vote. OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) JGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND W101001 Dept Proqram Acct Fund Aff. Op Unit Revenues 4030901 110090 695500 21341 4030701 116230 695500 21396 4030301 112620 695500 21397 9010101 196030 665882 Expenditures 4030701 116230 731304 4030301 112620 731304 Expenditures Account Name Transfers In - Law Enforcement Enhance State Transfers In - Sheriff Dispatch Training Transfers In - Sheriff Booking Fee Training Planned Use of Balance Total Revenues Officers Training (Dispatch) Officers Training (Corrections) Total Expenditures SCHEDULE A FY 2021 FY 2022 FY 2023 AMENDMENTS AMENDMENTS AMENDMENTS $ 4,146.00 6,175.00 14,464.00 (4.146.00) $ 20,639 00 $ 6,175.00 14,464.00 $ 20,639.00_ 4030501 110110 730646 Equipment Maintenance $ 4,00000 $ 4,000.00 $ 4,00000 4030301 112620 730548 Drug Testing (2,000.00) (2,000.00) (2,000.00) 4030901 110060 750049 Computer Supplies (2,000.00) (2,000.00) (2,000.00) Total Expenditures $ - $ - $ - Expenditures 4030201 112580 750170 4030301 112620 750170 4030601 110000 750170 4030701 116240 730646 4030901 116240 750170 4030701 116230 760157 Other Expendable Equipment Other Expendable Equipment Other Expendable Equipment Equipment Maintenance Other Expendable Equipment Expendable Equipment Total Expenditures $ (25,000.00) (15,500.00) (35,000 00) (65,000,00) (2,040 00) 142,540 00 0 OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) JGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Dept Program Acct Fund Aff. OpUnit Account Name SHERIFF'S OFFICE Grant Project: 100000003086 Budget Ref 2020 Activity: GLB Analysis: GLB Revenue 4030901 110090 610313 53600 Federal Operating Grants Total Revenue Expenditures 4030901 110090 712020 Overhme 4030901 110090 712020 Overtime 4030901 110090 730324 Communications SHERIFF'S OFFICE Expenditures 9090101 196030 730800 4030901 110090 788001 27320 Revenue 4030601 110000 650301 Expenditure 4030601 110000 731241 Total Expenditures Grant Match Transfers Out Total Expenditures Donations Total Revenue Miscellaneous Total Expenditure SCHEDULE A FY 2021 FY 2022 FY 2023 AMENDMENTS AMENDMENTS AMENDMENTS 5,000.00 5.00000 5,000.00 (806.00) 806.00 $ - $ 262,090.00 $ 262,090.00 - (262,090 00) (262,090.00) $ 2,500.00 $ 2,500.00 $ 2,500.00 5 SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 FIRST 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 COUNTY CLERKIREGISTER OF DEEDS Expenditures 2010301 185010 702010 2010301 185010 722900 2010101 185010 702010 2010101 185010 722900 BOARD OF COMMISSIONERS Expenditures 9090101 196030 740142 5010101 180020 702010 5010101 180020 722900 FY 2021 FY 2022 FY 2023 AMENDMENTS AMENDMENTS AMENDMENTS I Account Name Salaries $ (28,628 00) $ (28,628.00) $ (28,628.00) Fringe Benefit Adjustment (1,50600) (1,506.00) (1,506.00) Salaries 28,628.00 28,628.00 28,628.00 Fringe Benefit Adjustment 1,506.00 1,506.00 1,506.00 Total Expenditures $ - $ - $ - _ Salary Adjustment Reserve $ - $ (15,097.00) $ (15,097.00) Salaries - 11,125.00 11,125.00 Fringe Benefit Adjustment - 3,972.00 3,972.00 Total Expenditures $ - $ - $ - HEALTH AND HUMAN SERVICES - HEALTH DIVISION Project #: 100000003242 Budget Reference 2021 Activity GLB Analysis GLB Revenue 1060201 133150 615675 Health State Subsidy Total Revenue Expenditures 1060201 133150 731346 1060201 133150 731458 $ (83,283) $ $ (83,283) $ Personal Mileage $ (729,381) $ Professional Services 646,098 Total Expenditures $ (83,283) $ (83,283) $ (83,283) (83,283) $ (83,283) (729,381) $ (729,381) 646,098 646,098 (83,283) $ (83,283) 6 OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Dept Program Acct Fund Aff. Oo Unit Account Name EMERGENCY MANAGEMENT AND HOMELAND SECURITY Expenditures 1110102 115120 731164 Maintenance Vehicle 1110102 115120 750210 Gasoline Charges 1110102 115120 730940 Insurance 1110101 115120 731164 Maintenance Vehicle 1110101 115120 750210 Gasoline Charges 1110101 115120 730940 Insurance PUBLIC SERVICES - ANIMAL CONTROL DIVISION Revenues 1070805 132130 630028 1070805 114050 630070 1070801 114115 630074 1070805 114090 631988 9010101 196030 665882 Revenue 9010101 196030 665882 Expenditure 1070801 114090 731150 Total Expenditures SCHEDULE A FY 2021 FY 2022 FY 2023 AMENDMENTS AMENDMENTS AMENDMENTS E (300.00) $ (2,360.00) (616 00) 300.00 2,360.00 616.00 Adoptions $ 3000 Animal Shots/Dog 128.00 Animal Sterilization Fees 2,450.00 Sale of Licenses 42.00 Planned Use of Balance (2,650.00) Total Revenues $ - Planned Use of Balance $ 385,020.00 Total Revenue $ 385,020.00 Maintenance Contract $ 385,020.00 Total Expenditure $ 385,020.00 (300.00) $ (300.00) (2,360.00) (2,360.00) (616.00) (616.00) 300.00 300.00 2,360.00 2,360.00 616.00 616.00 7 OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) JGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#101001 Dept Program Acct Fund Aff. Op Unit NON -DEPARTMENT Revenues 9010101 196030 695500 67700 9010101 196030 665882 Revenue 9010101 196010 620534 Expenditure 9090101 196030 740037 Expenditures 9090101 112700 788001 10100 9010101 112700 788001 10100 CHILD CARE FUND (#20293). Revenue 1070701 112255 695500 21330 Expenditure 1070701 112255 750476 Account Name Transfer In - Building Liab Fund Planned Use of Balance Total Revenues Revenue Sharing Total Revenue Classification and Rate Change Total Expenditure SCHEDULE A FY 2021 FY 2022 FY 2023 AMENDMENTS AMENDMENTS AMENDMENTS $ 113,385.00 (113,385.00) $ 50,000.00 $ 57,285.00 $ 58,017.00 $ 50,000.00 $ 57,285 00 $ 58,017.00 $ 50,00000 $ 57,285.00 $ 58,017.00 $ 50,000 00 $ 57,285.00 $ 58,017.00 Transfers Out $ (9,405.00) Transfers Out 9,405.00 Total Expenditures $ - Transfer In - Children's Village Donations Fund $ 25.00 Total Revenue $ 25.00 Recreation Supplies $ 25.00 Total Expenditure $ 2500 H OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) jGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND W10100), Dept Program Acct Fund Aff. Op Unit Account Name Revenues 9090101 112700 695500 10100 Transfer In 9010101 196030 665576 Encumb and Approp Carry Forward Total Revenues SCHEDULE A FY 2021 FY 2022 AMENDMENTS AMENDMENTS. $ (5,000.00) $ 5,000.00 FY 2023 AMENDMENTS 0 SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY I SPECIAL REVENUE FUNDS FY 2021 FY 2022 FY 2023 AMENDMENTS AMENDMENTS AMENDMENTS 1PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Sheriff - LAW ENFORCEMENT ENHANCE STATE (#213411 Revenue 4030901 110090 665882 Planned Use of Balance Total Revenue Expenditure 4030901 110090 788001 10100 Transfers Out -General Fund Total Expenditure Sheriff -SHERIFF DISPATCH TRAINING (#21396) Revenue 4030701 112630 665882 Planned Use of Balance Total Revenue Expenditure 4030701 112630 788001 10100 Sheriff - SHERIFF BOOKING FEE TRAINING (#213971 Revenue 4030301 112620 665882 Expenditure 4030301 112620 788001 10100 Transfers Out - General Fund Total Expenditure Planned Use of Balance Total Revenue Transfers Out - General Fund Total Expenditure $ 4,146.00 $ 4,14600 $ 4,146.00 $ 4,14600 $ 6,175.00 $ 6,175.00 $ 6,175.00 $ 6,175.00 14,464.00 14,464.00 14,464.00 14,464.00 m SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2021 FY 2022 FY 2023 AMENDMENTS AMENDMENTS AMENDMENTS 1PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Druo Policv Grant Fund (#273201 Grant# GR0000000985 Activity: GLB Analysis: GLB Budget Reference 2021 Revenues 4030901 110090 610313 Federal Operating Grants $ - $ (217,08000) $ (217,080.00) 4030901 110090 695500 10100 Transfers In - General Fund - (262,090.00) (262,090.00) Total Revenues $ - $ (479,170.00) $ (479,170.00) Expenditures 4010201 122080 702010 Salaries $ - $ (109,451.00) $ (109,45100) 4010201 122080 722740 Fringe Benefits - (55,448 00) (55,448.00) 4030901 110090 702010 Salaries - (195,137.00) (195,137.00) 4030901 110090 722740 Fringe Benefits - (119,134,00) (119,134.00) Total Expenditures $ - $ (479,17000) $ (479,170.00) BUILDING & LIABILITY FUND (#67700) DRAIN Project ID #100000002662 Activity: GLB Analysis Type: GLB Budget Reference 2017 Expenses 9015501 182210 665882 Planned Use of Balance $ 113,385.00 Total Revenue $ 113,385.00 9015505 182210 788001 10100 Transfer Out- General Fund 113,385 00 Total Expenses $ 113,385.00 CHILDREN'S VILLAGE DONATIONS FUND (#213301 Revenue 9010101 112255 665882 Planned Use of Balance $ 25.00 Total Revenue $ 25.00 Expenditure 9010101 112255 788001 20293 Transfer Out - Child Care Fund $ 2500 Total Expenditure $ 2500 17 OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS 1PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name CIRCUIT COURT - VETERANS TREATMENT COURT FUND (#271911 Grant #GR0000001020 Activity GLB, Analysis Type GLB, Budget Ref 2021 Revenue 3010301 121200 615571 State Operating Grants Total Revenue Expenditures 3010301 121200 702010 3010301 121200 722740 Salaries Fringe Benefits Total Expenditures FY 2021 AMENDMENTS $ 10,000.00 $ 10,000.00 $ 9,500.00 500.00 $ 10,000 00 CIRCUIT COURT - VETERANS TREATMENT COURT FUND (#27191) Grant #GR0000000913 Activity GLB, Analysis Type GLB, Budget Ref 2021 Revenue 3010301 121200 615571 State Operating Grants $ (20,000.00) Total Revenue $ (20,000.00) Expenditures 3010301 121200 702010 Salaries $ (17,065.00) 3010301 121200 722740 Fringe Benefits (1,020.00) 3010301 121200 730450 Defense Atty Fees (1,915.00) Total Expenditures $ (20.000.00) DRUG COURT DISTRICT 52-2 SCAO FUND (#271601 Grant #GR0000001017 Activity GLB, Analysis Type GLB, Budget Ref 2021 Revenue 3020305 121050 615571 State Operating Grants $ 9,000.00 Total Revenue $ 9,000.00 Expenditures 3020305 121050 730548 Drug Testing $ 5,990.00 3020305 121050 732018 Travel and Conference 610.00 3020305 121050 750245 Incentives 2,400.00 Total Expenditures $ 9,000.00 SCHEDULE B FY 2022 FY 2023 AMENDMENTS AMENDMENTS 12 OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2021 FY 2022 FY 2023 AMENDMENTS AMENDMENTS AMENDMENTS 1PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name DRUG COURT DISTRICT 52-2 SCAO FUND (#271601 Grant #GR0000000810 Activity GLB, Analysis Type GLB, Budget Ref 2021 Revenue 3020305 121050 615571 State Operating Grants $ (10,000.00) Total Revenue $ (10,000.00) Expenditures 3020305 121050 730548 Drug Testing $ (6,685.00) 3020305 121050 732018 Travel and Conference (915.00) 3020305 121050 750245 Incentives (2,400.00) Total Expenditures $ (10,000.00) MIDC FUND (#20260) Expenditures 3010301 121170 730450 Defense Attorney Fees $ (24,000.00) 9010101 121170 788001 40400 Transfer Out 24,000.00 Total Expenditures $ - PROJECT WORK ORDER FUND (#404001 PCBU: FACMG, Project 100000003337, Activity PROJ Revenue 1040101 148020 695500 20260 Transfer In- Building Imp Fund $ 24,000.00 Total Revenue $ 24,000.00 Expenditure 1040101 148020 76500 Budgeted Equity Adjustments $ 24,000.00 Total Expenditure $ 24,000.00 ECONOMIC DEVELOPMENT CORPORATION (#211801 Revenues 1090202 171110 630098 Application and Admin Fee $ (1,000.00) $ (1,000.00) $ 1090202 171110 630280 Closing Fee (11,900.00) (11,900.00) 1090202 171110 632058 Second Administrative Fee (1,000.00) (1,000.00) (1,000 00) (11,900.00) (1,000 00) 13 OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2021 AMENDMENTS 1PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS SCHEDULE B Dept ID Program Acct Fund Aff Oper Unit Account Name 1090202 171110 632275 Third Administrative Fee (1,000.00) 1090202 171110 655385 Income from Investments (1,000.00) 1090305 171110 630098 Application and Admin Fee 500.00 1090305 171110 630280 Closing Fee 10,000.00 1090305 171110 632058 Second Administrative Fee 500.00 1090305 171110 632275 Third Administrative Fee 50000 1090305 171110 655385 Income from Investments 900.00 Total Revenues $ (3,500.00) $ Expenditures 1090202 171110 730065 Administrative Overhead $ (10,000.00) $ 1090202 171110 731507 Public Notices (3,500.00) 1090202 171110 732165 Workshops and Meeting (2,400.00) 1090305 171110 730065 Administrative Overhead 10,000 00 1090305 171110 731507 Public Notices 2,00000 1090305 171110 732165 Workshops and Meeting 400.00 Total Expenditures $ (3,500.00) $ CSHCS OUTREACH AND ADVOCACY FUND (#285631 GR0000000996 Budget Referenece 2021 Activity: GLB Anlaysis: GLB Revenue 1060291 134420 615463 Grant Fees and Collections $ 14,411.00 Total Revenue $ 14,411.00 Expenditures 1060291 134420 702010 Salaries Regular $ 19,239 00 1060291 134420 731346 Personal Mileage (100.00) 1060291 134420 731388 Printing (750.00) 1060291 134420 750392 Metered Postage (2,228.00) 1060291 134420 750399 Office Supplies (1,750.00) Total Expenditures $ 14,411.00 FY 2022 FY 2023 AMENDMENTS AMENDMENTS (1,000.00) (1,000.00) (1,000.00) (1,000.00) 500.00 500.00 10,000.00 10,000 00 500.00 500.00 500.00 500.00 900.00 900.00 (3,500 00) $ (3,500.00) (10,000.00) $ (10,000.00) (3,500.00) (3,500.00) (2,400.00) (2,400.00) 10,000.00 10,000.00 2,000.00 2,000.00 400.00 400.00 (3,500.00) $ (3,500.00) 14 OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 FIRST 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 HIV PREP (#28629) GR0000001007 Budget Referenece 2021 Activity GLB Anlaysis: GLB Expenditures 1060294 133990 750294 Materials and Supplies 1060294 133990 750245 Incentives Total Expenditures HOUSING COUNSELING GRANT (#297061 GR0000000940 COMHI Budget Referenece 2020 Activity. GLB Anlaysis: GLB Resource Type: A Revenue 1090680 132210 610313 Federal Operating Grants Total Revenue Expenditures 1090680 132210 702010 Salaries Regular 1090680 132210 722740 Fringe Benefits Total Expenditures COMMUNITY DEVELOPMENT BLOCK GRANT (#29701) GR0000000934 Budget Referenece 2020 Activity: GLB Anlaysis: GLB Revenue 1060703 172160 610313 Federal Operating Grants Total Revenue Expenditure 1060703 172160 731745 Sidewalks Total Expenditure SCHEDULE B (5,550.00) $ 5,550.00 $ 7,203.00 $ 7,203.00 $ 4,633.00 2,570.00 $ 7,203 00 $ (776.00) $ $ (776.00) $ $ (776.00) $ $ (776.00) $ FY 2022 FY 2023 AMENDMENTS AMENDMENTS I (5,550.00) $ (5,550.00) 5,550.00 5,550.00 (776.00) $ (776 00) (776.00) $ (776 00) (776.00) $ (776 00) (776.00) $ (776 00) OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS (PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name HOME INVESTMENT PARTNERSHIP GRANT (#29711) GR0000000936 Budget Refereneoe 2020 Activity GLB Anlaysis: GLB Revenue 1060704 132230 610313 Federal Operating Grants Total Revenue 6Yy:14Bill 4:1:1 FY 2021 FY 2022 AMENDMENTS AMENDMENTS $ (653.00) $ (653.00) $ $ (653 00) $ (653.00) $ FY 2023 AMENDMENTS (653.00) (653.00) Expenditure 1060704 132230 730891 Housing Rehab Special $ (653.00) $ (653.00) $ (653.00) Total Expenditure $ (653.00) $ (653 00) $ (653.00) FACILITIES MAINT AND OPERATIONS FUND (#631001 Expenses 1040770 145100 702010 Salaries Regular $ (9,721.00) 1040770 145100 722900 Fringe Benefit Adjustments (1,050.00) 1110102 145100 702010 Salaries Regular 9,721.00 1110102 145100 722900 Fringe Benefit Adjustments 1,050.00 Total Expenses $ - INFORMATION TECHNOLOGY FUND (#63600), Expenses 1080101 152000 731458 Professional Services $ (145,028.00) $ (145,028.00) 1080201 152010 731458 Professional Services (368,492.00) (368,492.00) 1080601 152100 731458 Professional Services 513,520.00 513,520.00 Total Expenses $ - $ - INFORMATION TECHNOLOGY FUND (#63600) Revenue 1080101 152000 665882 Planned Use of Fund Balance $ 230,000.00 Total Revenue $ 230,000 00 16 SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2021 FY 2022 FY 2023 AMENDMENTS AMENDMENTS AMENDMENTS (PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Expenses 1080301 152010 731780 Software Support/Maintenance $ 230,000.00 Total Expenses $ 230,000.00 FRINGE BENEFITS FUND (#678001 Expenses 1060501 183190 731458 Professional Services $ (8,500,00) $ (8,500.00) $ (8,500.00) 1070701 183190 731458 Professional Services 8,500.00 8,50000 8,500.00 1060501 183190 730576 Employee In -Service Training (20,000.00) (20,000.00) (20,000.00) 1070701 183190 730576 Employee In -Service Training 20,000.00 20,000.00 20,000 00 1050515 183165 732018 Travel and Conference 7,200.00 7,200.00 7,200.00 9011501 183190 796500 Budgeted Equity Adjustment (7,200.00) (7,200.00) (7,200.00) Total Expenses . $ - $ - $ - PARKS AND RECREATION FUND (#508001i Revenues 5060666 160666 665882 Planned Use of Balance $ (2,412,046.00) 5060101 160000 670570 Refund Prior Years Expenditure 2,02700 5060101 160000 655385 Income from Investments (100,000.00) 5060101 160000 601637 Property Tax Levy 7,846,300.00 5060831 160210 670456 Prior Years Adjustments 43,559.00 Total Revenues $ 5,379,840.00 Expenses 5060845 160210 702010 Salaries Regular $ 5,000.00 5060845 160210 722740 Fringe Benefits 25000 5060910 160430 730037 Adj. Prior Years Exp 2,060.00 5060417 160044 730037 Adj. Prior Years Exp 99800 5060910 160430 730653 Rental Equipment 10,610.00 5060910 160430 730789 General Program Administration 29,796.00 5060910 160430 730789 General Program Administration (82,797.00) 17 OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS 1PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Ooer Unit Account Name 5060910 160430 730789 General Program Administration 5060910 160431 730789 General Program Administration 5060326 160010 730814 Grounds Maintenance 5060330 160010 730814 Grounds Maintenance 5060715 160070 730814 Grounds Maintenance 5060720 160070 730814 Grounds Maintenance 5060722 160210 730814 Grounds Maintenance 5060724 160070 730814 Grounds Maintenance 5060725 160070 730814 Grounds Maintenance 5060735 160070 730814 Grounds Maintenance 5060751 160070 730814 Grounds Maintenance 5060755 160070 730814 Grounds Maintenance 5060760 160070 730814 Grounds Maintenance 5060765 160070 730814 Grounds Maintenance 5060326 160010 730814 Grounds Maintenance 5060755 160070 730814 Grounds Maintenance 5060720 160070 730814 Grounds Maintenance 5060326 160010 761042 Depreciation Park Improvements 5060327 160010 761042 Depreciation Park Improvements 5060328 160010 761042 Depreciation Park Improvements 5060330 160010 761042 Depreciation Park Improvements 5060356 160010 761042 Depreciation Park Improvements 5060417 160044 761042 Depreciation Park Improvements 5060420 160044 761042 Depreciation Park Improvements 5060427 160044 761042 Depreciation Park Improvements 5060456 160044 761042 Depreciation Park Improvements 5060715 160070 761042 Depreciation Park Improvements 5060720 160070 761042 Depreciation Park Improvements 5060722 160210 761042 Depreciation Park Improvements 5060724 160070 761042 Depreciation Park Improvements 5060725 160070 761042 Depreciation Park Improvements 5060732 160070 761042 Depreciation Park Improvements 5060751 160070 761042 Depreciation Park Improvements SCHEDULE B FY 2021 FY 2022 FY 2023 AMENDMENTS AMENDMENTS AMENDMENTS 20, 000.00 70,000.00 540.00 1,704.00 940.00 15,767 00 540.00 12,569.00 14,794.00 5,245.00 540.00 540.00 540.00 540.00 17,928.00 2,00000 1,00000 6,500.00 24,200.00 (300.00) 15,300.00 2,500.00 1,100.00 900.00 27,800.00 500.00 34,200.00 48,000.00 (9,700.00) 4,500.00 12,400.00 24,100 00 10000 11K SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2021 FY 2022 AMENDMENTS AMENDMENTS 1PROPRIETARY / SPECIAL REVENUE FUNDS -SELF BALANCING AMENDMENTS Dept ID Prooram Acct Fund Aff Doer Unit Account Name 5060755 160070 761042 Depreciation Park Improvements 80000 5060831 160210 761042 Depreciation Park Improvements 15,000.00 5060326 160010 761084 Depreciation Buildings 1,000.00 5060328 160010 761084 Depreciation Buildings (100.00) 5060330 160010 761084 Depreciation Buildings 1,000.00 5060417 160044 761084 Depreciation Buildings 700.00 5060420 160044 761084 Depreciation Buildings 300.00 5060427 160044 761084 Depreciation Buildings 2,300.00 5060430 160044 761084 Depreciation Buildings 7,200.00 5060437 160044 761084 Depreciation Buildings 1,000.00 5060715 160070 761084 Depreciation Buildings 4,10000 5060720 160070 761084 Depreciation Buildings 15,300.00 5060724 160070 761084 Depreciation Buildings 400.00 5060725 160070 761084 Depreciation Buildings 3,900.00 5060732 160070 761084 Depreciation Buildings 2,400.00 5060735 160070 761084 Depreciation Buildings 3,200.00 5060751 160070 761084 Depreciation Buildings 21,200.00 5060765 160070 761084 Depreciation Buildings 500.00 5060831 160210 761084 Depreciation Buildings (6,700.00) 5060910 160430 761084 Depreciation Buildings 2,200.00 5060226 160044 761121 Depreciation Equipment 1,900.00 5060256 160044 761121 Depreciation Equipment 700.00 5060326 160010 761121 Depreciation Equipment 34,200.00 5060327 160010 761121 Depreciation Equipment 7,500.00 5060328 160010 761121 Depreciation Equipment (3,600.00) 5060330 160010 761121 Depreciation Equipment 32,200 00 5060356 160010 761121 Depreciation Equipment 14,500 00 5060420 160044 761121 Depreciation Equipment 1,10000 5060715 160070 761121 Depreciation Equipment 20,200 00 5060720 160070 761121 Depreciation Equipment 20,900 00 5060724 160070 761121 Depreciation Equipment 3,100.00 5060725 160070 761121 Depreciation Equipment 16,800.00 5060732 160070 761121 Depreciation Equipment 2,300.00 FY 2023 AMENDMENTS 19 OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2021 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS (PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 5060735 160070 761121 Depreciation Equipment 5060805 160210 761121 Depreciation Equipment 5060870 160210 761121 Depreciation Equipment 5060910 160430 761121 Depreciation Equipment 5060910 160431 761121 Depreciation Equipment 5060805 160210 761156 Depreciation Vehicles 5060102 160012 762011 Transfer to Municipalities 5060101 160000 796500 Budgeted Equity Adjustments 5060101 160000 796500 Budgeted Equity Adjustments 5060101 160000 796500 Budgeted Equity Adjustments Total Expenses FY 2021 AMENDMENTS 7,800.00 (9,600 00) (1,300,00) 3,200 00 15,100.00 (20,300,00) 521,250.00 4,405,986.00 (23,000 00) (70,000.00) 5,379,840.00 FY 2022 AMENDMENTS FY 2023 AMENDMENTS 20 COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES SUMMARY BY DEPARTMENT FY 2021 BUDGET ADOPTED AS FY 2021 BUDGET AMENDED FORECAST REVENUES GENERALFUND Taxes $ 251,108,729.00 Federal Grants 2,249,550 00 State Grants 20,836,991 00 Other Intergovernmental Revenue 45,977,607 00 Charges for Services 120,392,677.00 Indirect Cost Recovery 9,100,000 00 Investment Income 1,500,000.00 Other Revenues 5,734,000 00 SUB -TOTAL GENERAL FUND/GENERAL PURPOSE $ 456,899,55400 PLANNED USE OF FUND BALANCE TOTAL GFIGP FUNDS EXPENDITURES ADMINISTRATION OF JUSTICE Circuit Court 52nd District Court Probate Court u<.�11f1r,�Tanrlc•�;irn>;3iL.r= LAW ENFORCEMENT Prosecuting Attorney Sheriff TOTAL LAW ENFORCEMENT GENERAL GOVERNMENT Clerk/Register of Deeds Treasurer Board of Commissioners Water Resources Commissioner TOTAL GENERAL GOVERNMENT COUNTY EXECUTIVE County Executive Admn Management and Budget Central Services Facilities Management Human Resources Health and Human Services Public Services Economic Dev and Comm Affairs Emergency Management & Homeland Security TOTAL COUNTY EXECUTIVE TOTAL DEPARTMENTS AMOUNT FAVORABLE/ (UNFAVORABLE) PERCENT $ 251,108,729.00 $ 251,108,72900 $ - 0.00% 130,292,067.00 130,237,06700 (55,00000) -004% 21,280,29000 19,480,29000 (1,800,00000) -846% 45,977,607.00 46,495,94400 518,33700 113% 121,289,90200 115,732,021.00 (5,557,88100) A68% 9,100,00000 9,100,00000 - 000% 1,500,00000 1,542,07500 42,07500 281% 5,891,907.00 5,931,89900 39,99200 068% $ 586,440,50200 $ 579,628,02500 $ (6,812,47700) -116% $ 609,33800 $ 29,769,03321 $ 29,769,03321 $ - 000% $ 457,508,892.00 $ 616,209,535.21 $ 609,397,058.21 $ (6,812,477.00) -1.11% $ 50,728,37600 $ 51,549,58244 44,665,58244 $ 6,884,000.00 1335% 17,813,04600 17,901,65187 17,084,651.87 817,00000 456% 7,027,76500 7,039,39500 6,632,89500 406,500.00 677% $ 76,569,186.00 $ 76,490,629.31 $ 68,383,129.31 $ 8,107,500.00 10.60% 21,782,30100 21,821,29900 21,818,79900 2,500.00 0.01% 166,768,49900 168,223,33286 168,175,33286 48,000.00 003% $ 188,550,800.00 $ 190,044,631.86 $ 189,994,131.86 $ 50,500.00 0.03% 10,461,273.00 11,370,53600 11,316,536.00 54,000.00 047% 8,236,13900 8,309,212.00 6,989,21200 1,320000.00 1589% 4,729,244.00 7,797,912.60 7,769,51260 28,400.00 036% 7,798,886.00 7,890,79700 7,890,79700 - 0.00% $ 31,226,542.00 $ 35,368,457.60 $ 33,966,057.60 $ 1,402,400.00 3.97% $ 7,099,68400 $ 9,737,65557 $ 9,725,855.57 $ 11,80000 012% 22,891,22200 23, 131,68943 22,251,68943 850,00000 368% 2,576,32700 2,582,22300 2,582,22&00 - 000% 1,499,208.00 1,841,40570 1,747,405.70 94,00000 510% 4,795,06200 5,333,25200 5,188,25200 145,00000 272% 45,356,951.00 49,757,45325 51,025,35325 (1,267,90000) -255% 40,326,55200 40,551,12484 40,146,12484 405,00000 100% 10,567,79200 27,788,44065 27,788,44065 - 0.00% - 1,788,06400 1,788,06400 - 000% $ 135,112,798.00 $ 162,481,308.44 $ 162,243,408.44 $ 237,900.00 0.15% $ 430,458,32600 $ 464,385,027.21 $ 454,586,72721 $ 9,798,30000 211% NON -DEPARTMENTAL APPROPRIATIONS TOTAL NON -DEPARTMENTAL $ 27,050,666.00 TOTAL GOVERNMENTAL EXPENDITURES $ 457,508,892.00 General Fund/General Purpose Favorable/(Unfavorable)- Budget Perspective $ - GAAP Required Adjustment (eliminating use of fund balance "revenue") GAAP - BASED REPORT (Impact on Fund Balance includes Encumbrances) $ 151,824,50800 $ 132,520,00800 $ 19,304,500.00 12.72% $ 616,209,535.21 $ 587,106,736.21 $ 29,1022800.00 4.72% $ - $ 22,290,323.00 $ 22,290,323.00 $ (29,769,03321) ($7,478,710.21) 21 GENERAL FUND GENERAL PURPOSE REVENUES FY 2021 FIRST QUARTER REPORT AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ,XES/601000-6019991 Imperty Taxes - July Tax Levy $ 250,496,72900 $ 250,498,729.00 $ 250,498,72900 $ - 0.00% Dither Taxes -Delinquent Tax - Prior Years 125,00000 125,000.00 125,000.00 - 0.00% Treasurer Payment in Lieu of Taxes 400,000.00 400,000.00 400,000.00 - 000% Dther Taxes -Trailer Tax 85,000.00 55,000.00 85,000.00 - O.DO% Total Taxes $ 251,108,729.00 $ 251,108,729.00 $ 2,51,108,729.00 $ - 0.00% :DERAL GRANTS (610000-610999) ienff- Shenffs Office $ - $ - $ - $ - 000% ienff - Patrol - 11,704.00 11,704.00 - 0.00% ieriff- Corrective Services - - - - 0.00% ienff- Investigative/Forensic Services - - - - 000% osecuting Attorney 205,000.00 205,000.00 205,OOD OD - 000% rmeland Security- Disaster Control 70,718.00 - - - 0.00% regency Management and Homeland Security - 70,718.00 70,718.00 - 0.00% aalth Division 654,727 00 648,713 00 648,713.00 - 0.00% iildren's Village 300,000 00 300,000 00 245,000.00 (55,000.00) -18 33% Unfav School Lunch program serving less than anticipate due to decline in population of residents m-Departmental 1,019,105.00 129,055,932.00 129,055,93200 - 000% Total Federal Grants $ 2,249,550.00 $ 130,292,067.00 $ 130,237,067.00 $ (55,000.00) -0.04% 'ATE GRANTS (615000-615999) ieriff- Patrol $ - $ - $ - $ - 0.00% ate Match Foster Care 1,00000 1,000.00 1,00000 - 0.00% osecuting Attorney - - - - 000% gnomic Development - - - - 0.00% ealth Division 6,233,963.00 6,636,600.00 6,636,60000 - 0.00% star Resources Commissioner - - - - 000% nnomic Development- Veteran's Services - - - - 0.00% m-Departmental - Child Care Subsidy 14,602,028 00 14,642,690 00 12,842,690.00 (1,800,000.O0) AL29% Unfay. due to less than anticipated reimbursement from tr State on eligible child care costs, offset by Child Care Fun expenditure favorability Total State Grants $ 20,836,991.00 $ 21,280,290.00 $ 19,480,290.00 $ (1,800,000.00) -8.46% fHER INTER -GOVERNMENTAL REVENUES (620000-626999) m-Departmental $ 4301.573.00 $ 43,681,573.00 $ 44,176,360 00 $ 494,787.00 1 13% Fa¢ Primarily due to State's updated Revenue Sharing projection. iS- Homeland Security 9,000.00 - - - 000% nergency Management- Homeland Security - 9,00000 9,000.00 - 0 00 % rcu0 Court 4,50000 4,50000 4,500.00 - 0.00% 5tnct Court 1,80000 1,800.00 1,800.00 - 0.00% ren[f artmentat -Rermb yudgas Salaries er lnter9pJerame^tat Revenue �n peP 'iota[Oth 6 0 635999 ice iP3=GE5 FOR n uvsbC S1brstrafion ImtnietrdmyudlGapAdm CouM1 - Inal � Wlt Court' cmIIGnm -Curt court' FamdY �vi5ion strict Court -Drvrson l (Novrl pid,Court-D�Nsion ll (Cla[kston) WOPTED B OGET coo655D. ...+ten` � "�pURPOSEORVEktUES GEfdERA� 2p2� F RS QUARTER REP AµENDED 8U 550 DO 994,164 DQ 2CPSS GR 3101W� 1 9g4.1PA 00 $ 2 414 000 00 2.406 000.DD 17 50" 4214753p0 1 a12,003 p0 1,771 500 00 4,214,755 00 912 663 00 1GNIFtCAt'�T V�tpx4CE> F dueto 5rtmg of FY ry ZG 'IN nca^ FAMORp81.6 pER2„/o Fay. Map^ea aa11Y °fY�e550uday.5 dal $eyes in lad due by 5inrt oaym enks ($50 000) 0 Fonda are odleCta�onr0m 1 UNFAV 2g 550.00 pepeoD- andemlfor Cost O,nca� 9P tmm�es r,,emog SS 2164 00" 00 1 6g1 50000 g, 1475300 642 663 04 I250 000.d (60 1000 00) in to cha nesll9rFees Court�un ie CI$ U1," d feenuson 6 rUntay. Jury 0 0 om Stake. parSaUY _1p 36°(o Unfay. anbc`.Pydue do in c°to Wor than in9 of PaYmentAn g225,000 Jon oryse[ Mc � e n a u 1 eydnd �y is a s due o tie G C vartancaa't}e 19 Pa^demsc are (`�75 000) along Wim 0 100 000,0M 12,0 000 001 J G"A BaneSt 0 0001 d to a ded� ProbaSo^ n Unfa Court SerNC° ,,seload ptl�ef '4 52°/o Board and Care Uri mba5°meY 525 000 teimblmementio a redodion n Oe Atto Fees PO 0ttsetn )W Refund Lam' in ae5" is i$g00,000)i aeba%I an Increase es and Cos Fin d proba5on Fees (5100 Ordmance {rom m36lua I9 is als 26 10`lo Costs ($2p0, d,cb an n caseloaCdduSe of the variances due to the reduction The ovynd'MIC. Probation legakiza5o VIO-19 P 225,000)PSl ($1lon due to CO Fines and Costs [$ a gyp); as wieiu"F'ss� me eload from m ntay 9412a� Unfav Ordnance to the ooabaitdue to the I:00 decreased numbr fees (g1d coon Tne PegaiI7 Uon and Bonds 16 000) due is s also due to COVID' an IFodeiture ohs°^adn9 to aPPanebce reme oerar,Carng cause of the 19 Fandemn o estar Hr1ls) -tnd OpOR _ pMSioP t11 (RgCn Selo, CoOd 01NS1011W C roY) abate Coon Estates and KWntal Hyahtn Total PdmmisttaCron of �osGce 0 entorceA�� y nt osydirtm9 �entPs pt(rcz �enff � Adm`nratranve Sorvaps reran . cvaecbve SeM°Qs y` J� o R ENV 5 E� E FUNSGIse N Q Uy,RtERREpOKt GENERPFY y021 FIRST M�ptEN BV801500 povoeD gU�G, - 015 00 FY 2p21 F� 314801505 ANOES n VGNIFIUAN 5 oOY, Plobat'o VA t9 and PSI wt'I Cr�C r�. 09sIA ,a 5%nes an��sessr"enmanl asCOVI outAl Fp nOP.ABA°/° Fefe� o$ a paM1aVVy d ycnon) and e yv.l2te pey p00 d" to 0 NF P Vt,030000 ' ($3aKin9 Ra o pamal{Y °8aet0aV AdortraY $2 ln` ndem�c. Pees PO 1a wall as R�1�ron efforts °ortIN 5y0000)pa�ea oa` 0100000) 1 550 5g0 00 14AO 59000 2 q40 590 00 56,1600p0 278000.00 $ 2,9g0 p0 363 500 00 296t 00D 00 561 6p0 00 816,6g9 00 290000 363,500 00 31� 236 p0 491 600 00 786 489 00 $ 27 gpp00 183 5p0 p0 1 882.236 00 qp 900 00) _364i°t° Unftaav �dnAo C caDload mlc( o000)f o "0 as a tpyrUalhy doo JAe p00), Stag 1$70,as 000) dIe P ($ Fees PD ce m Pandemic. due to a dea, 0 WD1 000) Ged 1240°b Urals a ltskUl nav� tees hr nntY Padqd A Y Ins ftl e to a decra a decreas e "' an Inc rea�ed above 1s a l$VOph o taisU 0 avanm,F ide fovyrarchin9 O 1p.t0 Pande doeto the Is Icx _yt 09°t° $25 000) atd�e to less °thy as (30 p00 00) 25 000,00 (180 000,01]) (t 3000p0001 _367°/o UadRR D 9 F derr+l OIdle pO) abandoned ve vlt 0 $2 5 000 , 8620�°b Fa cb f b Ge�ryV ram hotosloets I yoias a ao on. 160,0 0 red RresUcto 0 of C U 9$Pa �md ODOI dDe io a� often", to WaIved Ualav o'of nmates l30� Dr.den;i Inmate yMTha ' to n avas n In ao. m8 0 o�dUG a 9e 3oP°°) tled �aeon mrCis 0ffannerrts, CtrNceior dlrnlc ser" �V1D 19 P an nO to f6 ytes m r �p°o(� io nUmbet of ntnbnUn9 ttre ma)°r d° ieriff - Corrective Services Satellites ienff- Emergency Response and Prep tariff - Patrol Services ienff - Emergency Communications Operations ienff - Investigative Forensic Services Total Law Enforcement eneral Government ark - County Clerk ark - Elections ark - Register of Deeds & Micrographics =_asurer ,ard of Commissioners later Resources Commissioner GENERAL FUND I GENERAL PURPOSE REVENUES FY 2021 FIRST QUARTER REPORT AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 584,855.00 586,09800 321,09800 (265,000.00) -45.21% Unfav Reimb Court Services($215,000) for court securr} to non 52nd District Courts which are realizing lower mud activity due to COVID-19 pandemic partially offset by reduced personnel costs relating to part-time non -eligible court security personnel and vacant positions Also unfav Board and Care ($50,ODO) due to a reduction in the numb of eligible inmates housed at the jail in response to COVII 19 pandemic 322,500 00 322,500.00 142,500.00 (180,000 00) -55 81% Unfay. Civil Action Service Fees ($200,000) due to a reduction in services due to COVID-19 pandemic, partiall) offset by reduced operating expenditures and fav Reimbursement General $18,000 due to unbudgeted training fees. 57,826,89100 57,858,34100 56,853,341.00 (1,005,000.00) -1.74% Unfav pnmanly due to Reimbursement Salaries ($1,000,000) due to uncertainty of events at venues such as DTE Energy Music Theatre and Meadow Brook Amphitheatre due to COVI D-19 pandemic. This will be offset by less overtime for cancelled events Also unfay. Impound Fees ($5,000) due to lower activity 2,318,40800 2,318,40800 1, 215, 000.00 1, 253, 360.00 $ 65,873,054.00 $ 66,703,832.00 $ $ 2,179,100.00 $ 2,179,100.00 $ 93,700 00 11,492,500.00 4,646,600.00 14,200 00 3,346,261 00 93,700 00 11,492,500 00 4,646,600.00 14,200.00 3,396,208 00 2,318,408.00 - 653,360.00 (600,000 00) 63,168,83200 $ (3,535,000.00) 2,449,100.00 $ 270,000.00 93,700.00 - 13,342,500 00 1,850,000.00 4,646,600.00 14,2DO.DD 3,421,327 00 25,119 00 Total General Government $ 21,772,361 00 $ 21,822,308.00 $ 23,967,42T 00 $ 2,145,119 00 0 00% -47.87 % Unfay.pnmanly due to Drug Testing ($600,000) as the Results testing program was shut down due to COVID-19 pandemic. It has reopened and is experiencing a lower number of clients. Partially offset by favorable operating expenditures -5 30% 12.39% Fay. Certified Copies $110,000, Photostats $100,000, Jur Fees $40,000 and Forfeiture of Bonds $20,000 due to increased activity 0 00% 1610% Fav, Land Transfer Tax $1,000,000, Recording Fees $500,000 and Mortgages $350,000 due to increased activity. 000% 0.00% Fav - Refund Prior Years Expenditure $25,043 due to Cares Act money Water Resources Commission received for labor costs requiring an allocation to various systems f reimbursement, money should have been received in FY 2020. 9.83% ounty Executive >unty Exec - Corp Counsel aunty Exec - Admin ;B - Equalization Division ;B - Fiscal Services Division 3B - Purchasing Division mtral Services - Support Seances iman Resources IS - Administration IS - Health Division AS - MSU Extension iblic Services - Community Corrections iblic Services - Children's Village iblic Services - Medical Examiner iblic Services -Animal Control iNic Services - Circuit Court Probation :onomic Dev & Comm Affairs - PEDS Total County Executive >n-Departmental >n-Dept - Charges for Services Total Non -Departmental Total Charges for Services GENERAL FUND GENERAL PURPOSE REVENUES FY 2021 FIRST QUARTER REPORT AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE), PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 3,348,985.00 3,348,98500 3,348,985.00 - 0.00% 505,600 00 505,600 00 475,600 00 (30,000,00) -5 93% Unfay. Court Ordered Board and Care due to timing of court activity. 265,690.00 265,690.00 265,69000 - 000% 316,000.00 316,000 00 301,000.00 (15,000.00) -4.75% Unfav Commission Vending Machines due to limited stafl at County buildings during the pandemic. _ _ - - 000% - 0.00% 4,720,51900 4,720,519.00 4,720,519.D0 - 0.00% _ - - - a00% 155,000.00 155,000 00 15,000.00 (140,000.00) -90 32% Unfav Fee Income ($140,000) due to less than anticipate referrals from judges to the Weekend and Weekday Alternative for Misdemeanants (WWAM) Program. In addition, the program is suspended due to the COVID-19 pandemic. 3,164,097.00 3,164,097.00 3,164,09700 - 0.00% 325,100.00 325,100.00 325,10000 - 0.00% 1,138,514.00 1,147,014 00 854,014 00 (293,000.00) -25 54% Unfay. due pnmanly Sale of Licenses ($293,000) due to less than anticipated activity _ _ - 000% 404,071.00 4D4,07100 404.071.00 - 0.00% $ 14,343,576.00 $ 14,352,076.00 $ 13,874,076 00 $ (478,000.00) -3.33% $ 918,565 00 $ 918,565 00 918,565 00 - 000% $ 918,565.00 $ 918,565 00 $ 918,565 00 $ - 0.00% $ 120,392,677.00 $ 121,289,902.00 $ 115,732,021.00 $ (5,557,881.00) 4.58% GENERAL FUND GENERAL PURPOSE REVENUES FY 2021 FIRST QUARTER REPORT AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST fUNFAVORABLEI PERCENT EXPLANATION OF SIGNIFICANT VARIANCES DIRECT COST RECOVERY (640100) $ 9,100,000.00 $ 9,100,000.00 $ 9,100,000.00 $ - 0.00% VESTMENT INCOME f655000-655999) strict Courts (Div. I - IV) 2,200.00 2,200.00 2,200 00 - 000% ienff Corrective Services - - - - 000% ieriff Investigative/Technical Services - - - - 000% easurer 150,000.00 150,000.00 150,00000 - 000% ark/Register of Deeds 2,50000 2,50000 44,575.00 42,075 00 1683.00% Fav Interest on Investments $42,075 due to investment base and market rate fluctuations. :onomic Development - - - - 0.00% m-Departmental 1,345,300.00 1345,300.00 1,345,300,00 - 0.00% Total Investment Income $ 1,500,000.00 $ 1,500,000.00 $ 1,542,075.00 $ 42,075.00 2.81% -HER REVENUES (670000-695500) -curt Court- Donations $ - $ - $ - $ - 000% -cult Court - - - - 000% ,curt Court -Transfers In - - - - 000% stnct Courts (Div I - IV) - - - - 000% obate Court - - - - 000% osecuting Attorney - - - - 0.00% ienff Office - - 200.00 200 OD 100.00% Fav Enhancement Funds due to unbudgeted cash recovery from evidence. ieriff- Administrative Services - - - - 0.00% ieriff- Connective Services - - 39,792 00 39,792 00 100.00% Fav Prior Years Revenue $39,715 Leased Beds and Alternatives (LBA) reimbursement of MDOC inmates due COVID and $77 Jail Alliance With Support (JAWS) /Medication Assisted Treatment (MAT) reimbursements fc FY 2020 ienff- Corrective Services -Satellites - - - - 0.00% ienff - Emergency Resp and Prepare - - - - 000% ienff - Patrol Services 12,000.00 12,000 00 12,000.00 - 000% ienff - Patrol Services - Donations - - - - 000% ienff- Emergency Communications Operations - - - - 000% ienff- Investigaflve/Forensic Svc 3,000.00 3,00000 3,000.00 - 000% ark/Register of Deeds - - - - 000% =_asurer - - - - 000% asurer- Donations - - 000% yard of Commissioners - - - - 000% GENERAL FUND I GENERAL PURPOSE REVENUES FY 2021 FIRST QUARTER REPORT AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST IUNFAVORABLEI PERCENT ,ard of Commissioners -Contributions - 157,90Z00 157,907.00 - 000% @ter Resources Commissioner - - - - 000% runty Exec -Compliance Office - - - - 0.00% magemerd and Budget- Fiscal Services - - - - 0.00% antral Services - Support Services 1,50000 1,500.00 1,50000 000% inner Resources - - - - 000% elites Management Engineering - - - - 000% Palth Division - Donations - - - - 000% aalth Division - - - - 0.00% aIth Division -Transfers In - - - - 0.00% uldren's Village - - - - 000% iidren's Village - Transfers In - - - - 000% )meland Security - - - - 000% AG - Homeland Security - - - - 000% iblic Services- Medical Examiner - - - - 000% ityc Services -Animal Control -Other Revenues - - - - 0.00% Iblic Services - Animal Control -Transfers In - - - - 0.00% :onomic Development & Comm Affairs -Contributions - - - - 0.00% :onomic Development - Contributions - - - - 0.00% rn Departmental - Donations - m-Dept-Sundry 417,50000 417,500.00 417,500.00 - 000% ieriffs' Transfers In - - - - 000% easurers'Transfers In 2,300,000.00 2,300,00000 2,300,000.00 - 000% m-Departmental - Transfers In 3,000,000.00 3,000,00000 3,000,000.00 - 000% Total Other Revenues $ 5,734,000.00 $ 5,891,907.00 5,931,899.00 $ 39,992.00 0.68% ANNED USE OF FUND BALANCE (665000-665999) cumbrances and Carry forwards - 14,651,85221 14,651,85221 - 0.00% re of Prior Yrs Fund Balance $ 609,33800 $ 15,117,18100 15,117,181.00 - 000% dal Planned Use of Fund Balance $ 609,338.00 $ 29,769,033.21 $ 29,769,033.21 $ - 0.00% )TAL GEN. FUND I GEN. PURPOSE REVENUE $ 457,508,892.00 $ 616,209,535.21 $ 609,397,058.21 $ (6,812.477.001 $ (0.081 EXPLANATION OF SIGNIFICANT VARIANCES COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES, Judicial Administration Personnel Expenditures $ 9,813,330.00 $ 9,813,330 00 $ 9,238,330.00 $ 575,000 00 5.86%- Fay. due to underfilled and vacant positions Operating Expenditures 224,828.00 685,917.52 280,917.52 405,000.00 59.05% Fav Expendable Equipment $275,000; Training $60,000; and Office Supplies $25,000 due to lower than anticipated use. Fay. Special Projects $75,000 due to the unused distribution of Judicial Technology funds from the State and Judge On -Line project (MR #09017) for courtroom technology improvements. Partially offset by unfav Library Continuations ($20,000) and Professional Services ($10,000) due to higher than anticipated use. The overarching cause of the variances identified above is due to the pandemic. Internal Support Expenditures 376,429.00 405,577.00 408,577 00 (3,000.00) -0.74% - Unfay. Info Tech Operations ($5,000) due to ongoing equipment costs which allow employees to work remotely as a result of the pandemic. Partially offset by fay. Info Tech Managed Print Svcs $2,000 due to lower than anticipated use. The overarching cause of the variances identified above is due to the pandemic. Transfer Out - - - - $ 10,414,587.00 $ 10,904,824.52 $ 9,927,824.52 $ 977,000.00 8.96% Business Division Personnel Expenditures $ 2,067,610.00 $ 2,068,850.00 $ 1,593,850.00 $ 475,000.00 22.96% - Fay. due to underfilled and vacant positions. Operating Expenditures 172,430.00 172,430.00 82,430.00 90,000.00 52.20% - Fay. Visiting Judges $75,000 and Professional Services $15,000 due to lower than anticipated use. The overarching cause of the variance identified above is due to the pandemic. Internal Support Expenditures 243,687 00 243,687 00 246,687.00 (3,000.00) -1.23% - Unfay. Info Tech Operations ($5,000) due to ongoing equipment costs which allow employees to work remotely as a result of the pandemic. Partially offset by fay. Info Tech Managed Print Svcs $2,000 due to lower than anticipated use. The overarching cause of the variances identified above is due to the pandemic. Transfers Out - - - - $ 2,483,727.00 $ 2,484,967.00 $ 1,922,967.00 $ 562,00000 22.62% 29 COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Civil / Criminal Division���� Personnel Expenditures $ 1,777,891.00 $ 1,777,891.00 $ 1,677,891 00 $ 100,000 00 5.62% - Fay. due to underfilled and vacant positions. Operating Expenditures 1,821,589.00 1,821,589 00 1,101,589.00 720,000 00 39.53% - Fay. Juror Fees and Mileage $425,000; Defense Atty Fees Appellate $150,000; Transcript on Appeals $70,000; Office Supplies $50,000; and Interpreter Fees $25,000 due to lower than anticipated use. The overarching cause of the variance identified above is due to the pandemic. Internal Support Expenditures 2,323,443.00 2,583,518.00 2,533,518.00 50,000 00 1.94% - Fay. Info Tech Operations $50,000 due to lower than anticipated use The overarching cause of the variance identified above is due to the pandemic. Transfers Out 1,868,991.00 1,881,162.00 1,881,162.00 - $ 7,791,914.00 $ 8,064,160.00 $ 7,194,160.00 $ 870,000.00 10.79% Family Division/Juvenile Maint Personnel Expenditures $ 12,172,216.00 $ 12,222,878.00 $ 11,222,878.00 $ 1,000,000.00 8.18%- Fay. due to underfilled and vacant positions. Operating Expenditures 9,305,257.00 9,307,734.92 5,857,734.92 3,450,000.00 37.07% - Fay. due to decrease in placements to State Institutions $1,500,000 and Priv Institutions Residential $1,250,000 based on caseload, difficulty of care, and treatment of services ordered by the Court. Fay. Defense Atty Fees $350,000; Fees Guardian Ad Litem $250,000; Professional Services $100,000 due to lower than anticipated use. Offset by unfavorable Non - Dept Child Care Subsidy Revenue (50% Reimbursement). The overarching cause of the variance identified above is due to the pandemic. Internal Support Expenditures 2,183,332.00 2,185,090 00 2,160,090.00 25,000.00 1.14% - Fay. Info Tech Managed Print Svcs $25,000 due to lower than anticipated use. The overarching cause of the variance identified above is due to the pandemic Transfer Out 6,377,343.00 6,379,928.00 6,379,928.00 - 0.00°% - $ 30,038,148.00 $ 30,095,630.92 $ 25,620,630.92 $ 4,475,00000 14.87% 30 COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT Department Total Personnel Expenditures $ 25,831,047.00 $ 25,882,949.00 $ 23,732,949.00 $ 2,150,000.00 8.31% Operating Expenditures 11,524,104.00 11,987,671.44 7,322,671.44 4,665,000.00 38.91% Internal Support Expenditures 5,126,891.00 5,417,872.00 5,348,872.00 69,000.00 1.27% Transfers Out 8,246,334 00 8,261,090 00 8,261,090.00 - 0 00% $ 50,728,376.00 $ 51,549,582.44 $ 44,665,58244 $ 6,884,000.00 13.35% EXPLANATION OF SIGNIFICANT VARIANCES 31 FY 2021 FIRST QUARTER REPORT EXPENDITURES DISTRICT COURT AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES District Court Administration Personnel Expenditures $ 238,267.00 $ 238,267.00 $ 238,267.00 $ - 0 00% - Operating Expenditures 10,300.00 10,300.00 2,800.00 7,500.00 72.82% Fay. Visiting Judges $7,500 due to lower than anticipated use. The overarching cause of the variance identified above is due to the pandemic. Internal Support Expenditures 2,318.00 2,318.00 2,318.00 - 0.00% Transfers Out - - - - 0.00% $ 250,885.00 $ 250,885.00 $ 243,38500 $ 7,500.00 2.99% Division 1 - Novi Personnel Expenditures $ 4,600,355.00 $ 4,600,355.00 $ 4,400,355.00 200,000.00 4.35% - Fay. due to turnover and undentlled positions/vacancies Operating Expenditures 905,590.00 905,590.00 848,090.00 57,500.00 6.35% - Fay. Software Support Maintenance $15,000; Electrical Service $10,000; Interpreter Fees $10,000; Juror Fees and Mileage $5,000; Office Supplies $5,000; as well as Postage Standard Mailing $5,000 due to lower than anticipated use. Fay. Travel and Conference $7,500 due to imposed travel restrictions. The overarching cause of the variance identified above is due to the pandemic. Internal Support Expenditures 428,311.00 435,386 00 410,386.00 25,000.00 5.74% - Fay. Telephone Communications $25,000 due to lower than anticipated use. The overarching cause of the variance identified above is due to the pandemic. Transfers Out - - - - 0 00% - Total Division 1 - Novi $ 5,934,256.00 $ 5,941,331.00 $ 5,658,831.00 $ 282,500.00 475% Division 2 - Clarkston Personnel Expenditures $ 2,286,220.00 $ 2,286,220.00 $ 2,211,220.00 75,000.00 3.28% - Fav due to turnover and underfilled positions/vacancies. Operating Expenditures 548,083.00 548,083.00 531,083.00 17,000.00 3.10% - Fav Juror Fees and Mileage $7,000; Interpreter Fees $5,000; and Electrical Service $5,000 due to lower than anticipated use. The overarching cause of the variance identified above is due to the pandemic Internal Support Expenditures 252,023.00 274,123.00 259,123.00 15,000.00 5.47% - Fav Telephone Communications $15,000 due to lower than anticipated use. The overarching cause of the variance identified above is due to the pandemic. Transfers Out - - - - 0.00% - Total Division 2 - Clarkston $ 3,086,326.00 $ 3,108,426 00 $ 3,001,426.00 $ 107,000.00 3.44% FY 2021 FIRST QUARTER REPORT EXPENDITURES DISTRICT COURT AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Division 3 - Rochester Hills Personnel Expenditures $ 4,090,212.00 $ 4,090,212.00 $ 3,890,212 00 200,000.00 4.89% - Fay. due to turnover and underfilled positions/vacancies. Operating Expenditures 278,427 00 327,369.87 277,369.87 50,000.00 15.27% - Fay. Juror Fees and Mileage $15,000; Office Supplies $15,000; Interpreter Fees $10,000, as well as Postage Standard Mailing $10,000 due to lower than anticipated use. The overarching cause of the variances identified above is due to the pandemic. Internal Support Expenditures 857,122.00 862,099.00 837,099 00 25,000 00 2.90% - Fay. Telephone Communications $25,000 due to lower than anticipated use. The overarching cause of the variance identified above is due to the pandemic. Transfers Out - - - - 0 00% $ 5,225,761.00 $ 5,279,68087 $ 5,004,680.87 $ 275,000.00 5.21% Division 4 - Troy Personnel Expenditures $ 2,568,798.00 $ 2,568,798.00 $ 2,468,798.00 100,000.00 3.89% - Fay. due to turnover and underfilled positions/vacancies. Operating Expenditures 447,072.00 447,072.00 422,072.00 25,000.00 5.59% - Fay. Interpreter Fees $15,000, Office Supplies $5,000; as well as Juror Fees and Mileage $5,000 due to less than anticipated use. The overarching cause of the variance identified above is due to the pandemic. Internal Support Expenditures 299,947.00 305,459 00 285,459.00 20,000.00 6.55% - Fay. Telephone Communications $20,000 due to lower than anticipated use. The overarching cause of the variance identified above is due to the pandemic. $ 3,315,81700 $ 3,321,329.00 $ 3,176,329.00 $ 145,000.00 4.37% Department Total Personnel Expenditures $ 13,783,852.00 $ 13,783,852.00 $ 13,208,852.00 $ 575,000.00 4.17% Operating Expenditures 2,189,472.00 2,238,414.87 2,081,41487 157,000.00 Z01% Internal Support Expenditures 1,839,721.00 1,879,385.00 1,794,385.00 85,000.00 4.52% Transfers Out - - - - $ 17,813,045.00 $ 17,901,651.87 $ 17,084,651.87 $ 817,000.00 456% idic ial/Adm in istratio n ersonnel Expenditures perating Expenditures eternal Support Expenditures ransfer Out itates/Mental Health ersonnel Expenditures perating Expenditures eternal Support Expenditures apartment Total ersonnel Expenditures perating Expenditures eternal Support Expenditures ransfer Out FY 2021 FIRST QUARTER REPORT EXPENDITURES PROBATE COURT AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT $ 2,562,648.00 $ 2,562,648 00 $ 2,512,648.00 $ 50,000.00 1.95% 22,481.00 22,481.00 15,98100 6,500.00 28.91% 479,627.00 479,62700 474,627.00 $ 3,064,756.00 $ 3,064,756 00 $ 3,003,256.00 $ $ 2,346,708.00 $ 2,346,708.00 $ 2,071,708.00 $ 1,007,943.00 1,007,943.00 922,943.00 608,358.00 619,988.00 634,988.00 $ 3,963,009.00 $ 3,974,639.00 $ 3,629,639.00 $ 5,00000 1.04% 61,500.00 201% EXPLANATION OF SIGNIFICANT VARIANCES Fay. due to turnover and underfilled positions/vacancies. Fay. Library Continuations $3,000; Court Reporter Services $2,000; as well as Membership Dues $1,500 due to lower than anticipated use as it relates to the pandemic. Fay. Info Tech Operations $3,000 and Telephone Communications $2,000 due to less than anticipated use 275,000.00 11.72% Fay. due to turnover and underfilled positions/vacancies. 85,000.00 8.43% Fav Fees Guardian Ad Litem $60,000 and Defense Attorney Fees $50,000 due to a decreased number of case filings and lower demand for these services. Fay. Expendable Equipment $10,000 due to lower than anticipated use. The overarching cause of the variances identified above is also due to the pandemic Partially offset by unfay. Medical Services Probate Exam ($20,000) due to continued high demand for these services. Unfav Software Support Maintenance ($15,000) due to variable rate increases for the use of services from the State of Michigan (15,000.00) -2.42% Unfay. Info Tech Operations ($20,000) due to ongoing equipment costs which allow employees to work remotely as a result of the pandemic. Partially offset by fay. Telephone Communications $5,000 due to less than anticipated use. 345,000.00 8.68% $ 4,909,356.00 $ 4,909,35600 $ 4,584,356.00 $ 325,000.00 6.62% 1,030,424.00 1,030,424.00 938,924.00 91,500.00 8.88% 1,087,985.00 1,099,615.00 1,109,615.00 (10,000.00) -091% $ 7,027,765.00 $ 7,039,395.00 $ 6,632,895 00 $ 406,500.00 5.77% Administration Personnel Expenditures Operating Exidendrtures Internal Support Expenditures Transfers Out Litigation Personnel Expenditures Ope bng Expenditures Internal Support Expenditures Transfers Out COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 2,724,325.00 $ 2,684,82600 $ 2,714,826.00 $ (30,00000) -1.12% Unfay. Overtime 524,666.00 595,611 00 570,611.00 25,000 00 4.20% Fav Extradition Expense $2D, 000, Printing $10, 000, Witness Fees and Mileage $10,000, Filing Fees $7,000, Expert Witness Fee and Mileage $5,000, Expendable Equipment$5,000, Metered Postage $4,000 and Postage Standard Mailing $1,500 due to less than anticipated use; partially offset by unfay. Library Continuations ($40,000) due to increased use. 2,107,10800 2,115,660.00 2,165,660.00 (50,00000) -2.36% Unfay. Info Tech Operations($115,000) partially offset by Fav Info Tech Managed Print Services $45,000, Equipment Rental $5,500, Motor Pool Fuel Charges $4,000, Telephone Communications $3,500 and Motor Pool $2,000 due to less than anticipated use. $ 5,356,099.00 $ 5,396,097,00 $ 5,451,09700 It (55,D0000) -1.02% $ 10,969,418.00 $ 10,969,41800 $ 10,899,418.00 $ 28,30100 27,801.00 17,80100 161,07500 161,075 00 161,075 00 975.027.00 975,02700 975,02700 $ 12,133,82100 $ 12,133,32100 $ 12,053,321.00 $ 7000000 0.64% Fav due to vacant position. 10,000.00 35 97% Fay. Personal Mileage due to less than anLapated use 0 00% 0.00% 80,000.00 0.66% 35 COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT Warrants Personnel Expenditures $ 2,274,794.00 $ 2,274,794.00 $ 2,274,79400 $ Operating Expenditures 3,199.00 3,19900 2,199.00 Internal Support Expenditures 32,213.00 32,213.00 32,213.00 $ 2,310,20600 $ 2,310,206.00 $ 2,309,20600 $ Appellate Personnel Expenditures $ 1,951,09300 $ 1,951,093.00 $ 1,976,093.00 $ Operating Expenditures 4,000.00 3,50000 2,000.00 Internal Support Expenditures 27,082.00 27,082.00 27,082.00 $ 1,982,175.00 $ 1,981,67500 $ 2,005,17500 $ Department Personnel Expenditures $ 17,919,630.00 $ 17,880,131 00 $ 17,865,131.00 $ Operating Expenditures 560,166.00 630,111 00 592,611 00 Internal Support Expenditures 2,327,478.00 2,336,03000 2,386,03000 Transfers Out 975,027.00 975,027 00 975,027 00 $ 21,782,30100 $ 21,821,299.00 $ 21,818,79900 $ 000% EXPLANATION OF SIGNIFICANT VARIANCES 1,000.00 31 26% Fay. Personal Mileage due to less than anticipated use - 0.00% 1,00000 004% (25,00000) -1.28% Unfav due to Overtime. 1,500.00 42 8fi % Fay. Personal Mileage due to less than anticipated use. - 0.00% (23,500.00) -1.19% 15,000.00 008% 37,500 00 5 95% (50,000,00) -2.14% - 0.00% 2,50000 0.01 % Biri Sheriffs Office Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out Administrative Services Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out Corrective Services Personnel Expenditures Operating Expenditures COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 1,842,596 00 $ 1,842,596 00 $ 1,742,596,00 $ 100,000.00 5 43% Fay. $100,000 due to a vacant position and Overtime which is offset in other divisions. 93,020 00 95.545.00 75,545 00 20,000.00 20 93% Fay. Contracted Services $10,000, Office Supplies $4,000, Communications $2,000 and Workshops and Meetings $2,000 due to less usage. 549,46200 549,462.00 499,46200 50,00000 9.10% Fay. Info Tech Operations$50,000 due to less than anticipated use. _ - - 0 00% $ 2,485,078.00 $ 2,487,603.00 $ 2,317,603.00 $ 170,00000 6.83% $ 1,296,145 00 $ 1,296,145.00 $ 1,396,145 00 (100,000 00) -7.72% Unfav Overtime of which a portion is attributable to COVID-19 pandemic 515,668.00 543,152 58 516,15258 27,000 00 4 97% Fay. Travel and Conference $10,000, Library Continuations $10,000 and Office Supplies $10,000 due to less than anticipated use. 153,18800 153,188.00 153,18800 - 0.00% - - 0 00% $ 1,965,00100 $ 1,992,485.58 $ 2,065,48558 $ (73,00000) -366% 34,659,08600 34,659,086.00 $ 35,659,086.00 (1,000,000.00) -2S9% Unfav Overtime of which a portion is attributable to COVID-19 pandemic; partially offset by fay Salaries and Fringe Benefits as a result of vacant positions, turnover, officers in the academy and officers in training. Also, COVID- 19 pandemic has contributed to additional leave time. 7,615,253 00 7,650,678 80 7,645,678 80 5,00000 0 07% Fav Contracted Services $75,000, Inmate Recreational Supplies $10,500, Interpreter Fees $10,000, Bedding and Linen $10,000, Indigent Orders $8,500, Laundry and Cleaning $8,000, Prisoner Housing Outside County $8,000, Transportation of Prisoners $6,000, Computer Supplies $5,000 and Culinary Supplies $5,000 due to less than anticipated use; partially offset by unfav Equipment ($106,600) for purchase of Jail CCTV and Upgrade to Media Room remote services as a result of COVID-19 pandemic and Adjustment Prior Years Revenue ($35,200) due to delayed Oakland County Health Network (OCHN) report required to request reimbursement 37 COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Internal Support Expenditures 6,960,445.00 7,023,305 00 6,953,305.00 '-` 70,000.00 y4 1 00% Fav Info Tech Managed Print Services $32,000, Motor Pool $26,ODO, Radio Communications $25,000 and Motor Pool Fuel Charges $16,OOO due to less than anticipated use; partially offset by unfay. Info Tech Operations ($28,000) due to usage. Transfers Out _ $ 49,234,78400 $ 49,333,069.80 $ 50,258,08980 $ (925,000.00) -186% Corrective Services -Satellites Personnel Expenditures $ 17,141,452.00 $ 17,141,452.00 $ 17,491,452.00 $ (350,000 00) -2 04 % Unfav Overtime partially offset by fay. Salaries and Fringe Benefits due to vacant positions Operating Expenditures 135,797.00 139,797 00 131,797.00 8,00000 5 72% Fav Laundry and Cleaning $9,000 and Printing $3,000 due to less than anticipated use, partially offset by unfav Office Supplies ($3,300) due to usage. Internal Support Expenditures 1,313,248.00 1,314,301.00 1,284,301 00 30,000.00 2.28 % Fay. Motor Pool $20,000 and Motor Pool Fuel Charges $10,000 due to less than anticipated use. Transfers Out _ $ 18,590,49700 $ 18,595,55000 $ 18,907,55000 $ (312, 000.00) -166% Emergency Response and Preparedness Personnel Expenditures $ 3,482,16300 $ 3,482,163.00 $ 3,982,163.00 $ (500,00000) -1436% Unfav Overtime and related Fringe Benefits Operating Expenditures 1,058,056 00 1,498,943 56 1,358,943 56 140,000 00 9.34% Fay. Fees Civil Service $130,000 which is offset in corresponding unfavorable revenue. Also fay. Employees Medical Exams $10,000 due to less than anticipated use. Internal Support Expenditures 452,038 00 452,206.00 458,206.00 (6,000 00) -1.33% Unfay. info Tech Operators ($16,000) due to increased usage; partially offset by fav Info Tech Managed Print Services $10,000 due to less than anticipated use. Transfers Out _ $ 4,992,25700 $ 5,433,312.56 $ 5,799,312.56 $ (366,000.00) -6.74% 38 Patrol Services Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out Emergency Communications Operations Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT $57,564,505 $ 57,616,86700 $ 56,616,86700 $ 1,000,000.00 1,373,277.00 1,884,516.00 1,844,51600 40,OD000 6,477,499 00 6,513,211 00 5,978,211 00 535,000.00 14,500.00 14,50000 - $ 65,415,28100 $ 66029,094.00 $ 64,454,09400 $ 1,575,000.00 EXPLANATION OF SIGNIFICANT VARIANCES 1.74% Fay. Salaries and Fringe Benefits of which a portion is due to the pandemic and related event cancellation (offset by unfavorable revenue for Reimbursement Salaries). Also, the favorability, includes vacant positions and turnover, partially offset by unfay. Overtime of which a portion is attnbutable to COVID-19 pandemic and political candidate security detail 2 12% Fav Equipment Rental $15,000, Office Supplies $9,D00, North Oakland Substation $5,000, Gasoline Charges $5,000 and Material and Supplies $5,000 due to less than anticipated use. 8 21 % Fay. Motor Pool Fuel Charges $250,000, Motor Pool $240,000, Radio Communications $30,000 and Telephone Communications $30,000 due to less than anticipated use, partially offset by unfav Info Tech CLEMIS ($20, 000) due to usage. 0.00% 2.39% $ 9,673,179 00 $ 9,673,179 00 $ 9,773,179.00 $ (100,000 00) -1 03% Unfav Overtime of which a portion is attributable to COVID-19 pandemic. partially offset by fav Salaries and related Fringe Benefits due to vacant positions 204,100.00 205,100.00 204,100.00 1,00000 049% Fav Office Supplies$1,000 due to less than anticipated use. 286,178 00 286,178.00 243,178 00 43,OD0.00 15 03% Fav Radio Communications $47000 due to less than anticipated use: partially offset by unfay. Info Tech Operations ($4,000) due to usage. 0.00% $ 10,163,457.00 $ 10,164,45700 $ 10,220,45T00 $ (56,00000) -0.55% 39 Investigative/Forensic Svcs Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES SHERIFFS OFFICE AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 9,419,275 00 $ 9,457,635 00 $ 9,532,635 00 $ (75,000 00) -0 79 % Unfay. Overtime and related Fringe Benefits. 985,512 00 950.678.92 860.678.92 90,000,00 9A7 % Fay. Laboratory Supplies $50000 which is offset in corresponding unfavorable Drug Testing revenue from reduced hours of the RESULTS drug testing program due to COVID-19 Also fav Software Support Maintenance $15,000, Drug Testing $7,000, Extradition Expense $5,000, Liquor and Gambling Evidence $5,000 and Office Supplies $5,000 due to less than anticipated use 3,046,076 00 3,046,076 00 3,026,076 00 20,000 DO 0 66 % Fay. Motor Pool Fuel Charges $37,000, Equipment Rental $22,000, Info Tech CLEMIS $17,000, Telephone Communications $14.00D and Info Tech Managed Print Services $7,000 due to less than anticipated use; partially offset by unfay. Motor Pool ($50,000) and Info Tech Operations ($28,000) due to usage. 471,281.D0 733,371.00 733,371.00 0 OD% $ 13,922,144.00 $ 14,187,760 92 $ 14,152,760 92 $ 35,00000 0 25% Department Total Personnel Expenditures $ 135,073,40100 $ 135,169, 12300 $ 136,194,123.00 $ (1,025,000.00) -076% Operating Expenditures $ 11 980,683.00 $ 12,968,411 86 $ 12,637,411 86 $ 331,000.00 2.55% Internal Support Expenditures $ 19,238,134.00 $ 19,337,92700 $ 18,595,927 OD $ 742,00000 384% Transfers Out S 471,281.00 $ 747,871 00 $ 747,871.00 $ - D 00% $ 166,768,499.00 $ 168,223,33286 $ 168,175,33286 $ 48,000.00 0.03% 40 COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES iinistration ersonnel Expenditures $ 624,618.00 $ 624,618.00 $ 624,618.00 $ - 0.00% perating Expenditures 29,100.00 29,100.00 25,100.00 4,000.00 13.75% Fay. Office Supplies $4,000 due to less than anticipated use. ternal Support Expenditures 91,893.00 91,893.00 91,893.00 - 0.00% ransfers Out - - - - 0.00% $ 745,611.00 $ 745,611.00 $ 741,611.00 $ 4,000.00 0.54% inty Clerk (Vital Stats & Legal Rec's) ersonnel Expenditures $ 3,702,187.00 $ 3,734,640.00 $ 3,734,640.00 $ - 0.00% perating Expenditures 274,660.00 274,660.00 274,660.00 - 0.00% ternal Support Expenditures 672,992.00 757,921.00 757,921.00 - 0.00% ransfers Out - - - - 0.00% $ 4,649,839.00 $ 4,767,221.00 $ 4,767,221.00 $ - 0.00% Aions ersonnel Expenditures $ 957,965.00 $ 1,206,535.00 $ 1,206,535.00 $ - 0.00% perating Expenditures 791,723.00 1,263,786.00 1,263,786.00 - 0.00% ternal Support Expenditures 289,583.00 326,933.00 326,933.00 - 0.00% ransfers Out - - - - 0.00% $ 2,039,271.00 $ 2,797,254.00 $ 2,797,254.00 $ 0.00% COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT isterof Deeds (and Micrographics) ersonnel Expenditures $ 2,498,095.00 $ 2,530,881.00 $ 2,480,881.00 $ 50,000.00 EXPLANATION OF SIGNIFICANT VARIANCES 1.98% Fay. due to turnover and underfilled positions. perating Expenditures 212,494.00 212,494.00 $ 212,494.00 - 0.00% ternal Support Expenditures 280,565.00 281,594.00 $ 281,594.00 - 0.00% ransfers Out - - - - 0.00% $ 2,991,154.00 $ 3,024,969.00 $ 2,974,969.00 $ 50,000.00 1.65% r Commission ersonnel Expenditures $ 17,277.00 $ 17,277.00 $ 17,277.00 $ - 0.00% perating Expenditures 17,935.00 17,935.00 17,935.00 - 0.00% ternal Support Expenditures 186.00 269.00 269.00 - 0.00% $ 35,398.00 $ 35,481.00 $ 35,481.00 $ - 0.00% artment Total ersonnel Expenditures $ 7,800,142.00 $ 8,113,951.00 $ 8,063,951.00 $ 50,000.00 0.62% perating Expenditures 1,325,912.00 1,797,975.00 1,793,975.00 $ 4,000.00 0.22% ternal Support Expenditures 1,335,219.00 1,458,610.00 1,458,610.00 $ - 0.00% ransfers Out - - - 0.00% $ 10,461,273.00 $ 11,370,536.00 $ 11,316,536.00 $ 54,000.00 0.47% Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out Division Total Department Total COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES COUNTYTREASURER AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 3,550,959.00 $ 3,550,959.00 $ 3,355,959.00 $ 195,000.00 5.49% - Fay. due to turnover, undehlls and vacant positions. 3,433,770.00 3,433,770.00 2,308,770.00 1,125,000.00 32.76% - Fay. Title Search $650,000, Contracted Services $200,000, Fees Civil Service $200,000 and Foreclosure Notification $75,000 due to less than anticipated use. 1,131,410.00 1,204,483.00 1,204,483.00 - 0.00% 120,000.00 120,000.00 120,000.00 - 0.00% $ 8,236,139.00 $ 8,309,212.00 $ 6,989,212.00 $ 1,320,000.00 15.89% $8,236,139.00 $ 8,309,212.00 $ 6,989,212.00 $ 1,320,00000 15.89% 4dministration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out FY 2021 FIRST QUARTER REPORT EXPENDITURES BOARD OF COMMISSIONERS AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $3,229,714.00 $3,194,65400 $3,194,65400 0.00% - 872,150.00 31946,273 60 $ 3,917,873.60 28,400.00 0 72% - Fay. Workshops and Meetings $10,000, Personal Mileage $5,000, Periodicals Books Pub Sub $5,000, Travel and Conference $5,000, Equipment Maintenance $1,800 and Binding $1,600 due to decreased activity. 627,380.00 656,985.00 $ 656,985.00 0.00% $4,729,244.00 $7,797,912.60 $7,769,512.60 $ 28,400.00 0.36% $3,229,714.00 $3,194,65400 $3,194,654.00 $ - 0.00% 872,150 00 3,946,273 60 3,917,873.60 28,400.00 0.72% 627,380.00 656,985 00 656,985 00 - 0.00% $ 4,729,244.00 ------------ ------------ $ 7,797,912 60 ------------ ------------ $ 7,769,512.60 =----------- ------------ $ 28,400.00 ------------- ------------- 0.36% COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES WATER RESOURCES COMMISSIONE AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST [UNFAVORABLE) PERCENT Water Resource Commissioner Personnel Expenditures $ 228,118.00 $ 228,118.00 $ 228,118.00 $ - 0.00% Operating Expenditures 287,975.00 287,975 00 287,975.00 - 0.00% Internal Support Expenditures 7,226,628.00 7,318,539.00 7,318,539.00 Transfers 56,165.00 56,165.00 56,165.00 Division Total $ 7,798,886.00 $ 7,890,797.00 $ 7,890,797.00 $ Department Total $ 7,798,886.00 $ 7,890,797.00 $ 7,890,797.00 $ 0 00% 0.00% 0.00% 0.00% EXPLANATION OF SIGNIFICANT VARIANCES Aration nnel Expenditures Sting Expenditures al Support Expenditures fer Out knee Office nnel Expenditures rting Expenditures AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 2,637,279.00 $ 2,084,185.00 2,084,185 00 0.00% 268,357.00 2,398,357.00 2,443,057.00 (44,700.00) -1.86% Unfay. Contracted Services ($40,000), Advertising ($3,700), Library Continuations ($3,000) due to increased activity; partially offset by Personal Mileage $2,000 due to reduced travel. 414,629.00 451,786.00 474,786.00 (23,000.00) -5.09% Unfay. Info Tech Operations ($30,000) due to greater than anticipated usage; partially offset by IT Managed Print Services $4,000 and Motor Pool $3,000 based on decreased activity. $ 3,320,265.00 $ 4,934,328.00 $ 5,002,028 00 $ $ 454,292.00 $ 454,292.00 $ 454,292 00 $ 21,653.00 25,060.57 25,060 57 al Support Expenditures 76,958.00 76,958.00 76,958.00 fer Out - - - $ 552,903.00 $ 556,310.57 $ 556,310.57 $ (67,700.00) -137% 0 00% 0.00% 0.00% 0.00% rtion Counsel nnel Expenditures ding Expenditures al Support Expenditures far Out f Public Communications nnel Expenditures rting Expenditures al Support Expenditures fers Out lent Total nnel Expenditures Sting Expenditures al Support Expenditures fers Out AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ._..__________ _____.._..___._ - _...,._...----------- ___-________w._._-- _____..___ _�...._ $ 2,831,546 00 $ 2,831,546.00 $ 2,771,546.00 $ 81,045.00 87,045.00 70,545.00 313,925.00 337,143.00 334,143 00 60,000.00 2.12% Fay. Salaries and Fringe Benefits primarily due to vacancies. 16,500.00 18.96% Fay. Software Support Maintenance $4,000, Travel and Conference $4,000, Library Continuations $3,000, Office Supplies $2,000, Personal Mileage $1,500, Computer Supplies $1,000 and Periodicals Book Pub] 1,000 due to less than anticipated use 3,000.00 0.89% Fay. Info Tech Managed Print Services ($3,000) due to decreased activity. $ 3,226,516.00 $ 3,255,73400 $ 3,176,234.00 $ 79,500.00 2.44% $ - $ 991,283.00 $ 991,283.00 $ - $ - $ 991,283.00 $ 991,283.00 $ - $ 5,923,117.00 $ 6,361,306.00 $ 6,301,306 00 $ 60,000.00 0.94% 371,055.00 $ 2,510,462.57 2,538,662.57 (28.200.00) -1.12% 805,512.00 865,887 00 885,887.00 (20,000.00) -2,31% $ 7,099,684.00 $ 9,737,655.57 $ 9,725,855.57 $ 11,800.00 0.12% (ministration Personnel Expenditures Operating Expenditures Internal Support Expenditures lualization Personnel Expenditures Operating Expenditures MANAl LIWLN 1 ANIJ GUUIit 1 AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT $ 194,170.00 $ 194,170.00 $ 194,170.00 $ - 0.00°/ 4,017.00 4,017.00 4,017.00 - 0.00°/ 65,970.00 65,970 00 65,970.00 - 0.00% $ 264,157.00 $ 264,157.00 $ 264,157.00 $ - 0.00^i $ 8,883,574.00 $ 8,883,574.00 $ 8,483,574.00 $ 400,000.00 421,404.00 421,40400 421,404.00 - Internal Support Expenditures 994,099.00 1,079,927.00 1,079,927.00 Transfers Out >cal Services Personnel Expenditures Operating Expenditures $10,299,077.00 $10,384,905.00 $ 9,984,905.00 $ 400,000.00 EXPLANATION OF SIGNIFICANT VARIANCES 4.50% Fay. Salaries and Fringe Benefits primarily due to vacancies. 0.00% 0.00% 0.00% 3.85% $ 8,290,188.00 $ 8,290,188.00 $ 7,790,188 00 $ 500,000.00 6.03% Fay. Salaries $325,000 and Fringe Benefits $176,000 due to turnover. 354,300.00 378,579.00 428,579.00 $ (50,000.00)-13.21% Unfay. Contracted Services ($80,000) due to vacancy in position #3557. Partially offset by fay. Metered Postage $15,000, Professional Service $7,000, Office Supplies $3,500, Software Rental Lease Purchase $1,500, Membership Dues $1,000, Periodicals Books Publ Sub $1,000, and Personal Mileage $1,000 being less than anticipated ternal Support Expenditures Transfers Out irchasing Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out Ipartment Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out MANAGtMMN I ANU UUUUC 1 AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT 1,790,192.00 1,881,649.00 1,881,649.00 $ - 0.00% _ 0.00% $ 10,434,680.00 $ 10,550,416.00 $ 10,100,416.00 $ 450,000 00 4.27% $ 1,173,345.00 $ 1,173,345.00 $ 1,173,34500 $ - 0.00% 12,225.00 20,654.43 $ 20,654.43 $ - 0.00% 707,738.00 708212.00 $ 708,212.00 $ - 0.00% _ _ - - 000% $ 1,893,308 00 $ 1,902,211.43 $ 1,902,211.43 $ - 0.00% $18,541,27700 $ 18,541,277.00 $ 17,641,277.00 $ 900,000.00 4.85% 791,946.00 824,654.43 874,654.43 (50,000.00) -6.06% 3,557,999.00 3,735,758 00 3,735,758.00 - 0.00% - - 000% $22,891,222.00 $ 23,101,689.43 $ 22,251,689.43 $ 850,000.00 3.68% EXPLANATION OF SIGNIFICANT VARIANCES COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES CENTRAL SERVICES AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT administrative Personnel Expenditures $ 236,503 00 $ 236,503.00 $ 236,503.00 $ - 0.00% Operating Expenditures 3,298.00 3,298.00 3,298.00 - 0.00% Internal Support Expenditures 11,743.00 11,791 00 11,791.00 - 0.00% Transfers Out - - - - $ 251,544.00 $ 251,592.00 $ 251,592.00 $ - 0.00% iupport Services Personnel Expenditures $ 1,250,53300 $ 1,250,533.00 $ 1,250,533.00 $ - 0.00% Operating Expenditures 330,825.00 330,825.00 330,825.00 - 0.00% Internal Support Expenditures 743,425 00 749,273.00 749,273.00 - 0.00% Transfers Out - - - - 0.00% $ 2,324,783 00 $ 2,330,631 00 $ 2,330,631.00 $ - 0 00% )epartment Total Personnel Expenditures $ 1,487,036.00 $ 1,487,036.00 $ 1,487,036.00 $ - 0.00% Operating Expenditures 334,123.00 334,123.00 334,123.00 - 0.00% Internal Support Expenditures 755,168.00 761,064.00 761,064.00 - 0.00% Transfers Out - - - - 0.00% ----- $ 2,576,327 00 $ 2,582,223.00 $ 2,582,223.00 $ 0.00% EXPLANATION OF SIGNIFICANT VARIANCES COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES FACILITIES MANAGEMENT AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 221.949.00 $ 221,949.00 $ 221,949.00 $ - 0.00% Operating Expenditures 2,687.00 2,687.00 3,687.00 (1,000.00) -37.22% Unfay. Travel and Conference ($2,000) due to a duplicate payment made by the County. Offset by revenue account Reimb General for the refund. The overall unfavorability is partially offset by fay. Membership Dues $1,000 due to less than anticipated usage as a result of COVID-19 Internal Support Expenditures 11,197.00 11,197.00 11,197.00 - 000% $ 235,833.00 $ 235,833.00 $ 236,833.00 $ (1,000.00) -0.42% Facilities Engineering Personnel Expenditures $ 867,043 00 $ 867,043.00 $ 792,043.00 $ Operating Expenditures 276,027.00 617,996 70 597,996.70 Internal Support Expenditures 120,305.00 120,533.00 120,533.00 $1,263,375.00 $1,605,572.70 $ 1,510,572.70 $ Department Total Personnel Expenditures $1,088,992.00 $1,088,99200 $ 1,013,992.00 $ Operating Expenditures 278,714.00 620,683.70 601,683.70 Internal Support Expenditures 131,502.00 131,730.00 131,730 00 $ 1,499,208.00 $ 1,841,405 70 $ 1,747,405 70 $ 75,000.00 8.65% Fay. due to turnover/vacant positions 20,000.00 3.24% Fay. Training $10,000 as well as Travel and Conference $10,000 due to travel restrictions as a result of COVID-19. - 0.00% 95,000.00 5.92% 75,000.00 6 89% 19,000.00 3.06% - 0,00% 94,000.00 5.10% Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out Workforce Management Personnel Expenditures Operating Expenditures COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES HUMAN RESOURCES AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 749,996.00 $ 749,996.00 $ 704,996 00 $ 45,000.00 6 00% Fay. due to vacancies and turnover. 251,243 00 701,243.00 601,243.00 100,000 00 14.26% Fay. Professional Services $100,000 due to less than anticipated activity 79,616.00 79,809.00 79,809.00 - 0.00% $ 1,080,855.00 $ 1,531,048.00 $ 1,386,048.00 $ 145,000.00 9.47% $ 2,290,793 00 $ 2,290,793.00 $ 2,290,793.00 $ - 0.00% 314,358.00 356,116.00 356,116.00 - 000% Internal Support Expenditures 1,109,056.00 1,155,295.00 1,155,295.00 - 0 00% $ 3,714,207.00 $ 3,802,204.00 $ 3,802,204.00 $ - 0.00% Department Total Personnel Expenditures $ 3,040,789.00 $ 3,040,789.00 $ 2,995,789.00 $ 45,000.00 1.48% Operating Expenditures 565,601.00 1,057,359.00 957,359.00 100,000.00 9.46% Internal Support Expenditures 1,188,672.00 1,235,104 00 1,235,104.00 - 0.00% Transfers Out - - _ - - $ 4,795,062.00 $ 5,333,25200 $ 5,188,25200 $ 145,000.00 2.72% 52 administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out iealth Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES AMOUNT ADOPTED AMENDED FY2021 FAVORABLE BUDGET --------------- BUDGET _______________ FORECAST (UNFAVORABLE) PERCENT _______________ ________________ -------- $ 221,174.00 $ 221,174.00 $ 221,174.00 $ 0.00% 4,336,668.00 4,343,293.00 4,343,293.00 0.00% 8,892.00 8,892.00 8,892.00 ----------------------- $ 4,566,734.00 $ 4,573,359.00 $ 4,573,359.00 $ $ 29,711,122.00 $ 32,142,126.00 $ 31,742,126.00 $ 4,362,935.00 7,248,287.25 8,960,187.25 3,263,260.00 3,450,291.00 3,450,291.00 0.00% 0.00% EXPLANATION OF SIGNIFICANT VARIANCES 400,000.00 1.24% Fay. Salary and Fringe Benefits due to vacancies. (1,711,900.00)-23.62% Unfay. Laboratory Fees ($1,580,000) due to COVID testing and Vehicles ($131,900) that will be partially covered with CARES Act Funding (which is budgeted in Non -Department General Fund General Purpose budget) as well as other subsequent grant funding. 0.00% $ 37,337,317.00 $42,840,704.25 $ 44,152,604.25 $ (1,311,900.00) -3.06% iomeland Security' Personnel Expenditures Operating Expenditures ADOPTED BUDGET $ 899,627.00 $ 294,667.00 COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES AMOUNT AMENDED FY 2021 FAVORABLE BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ $ - #DIV/0! Per M.R. #20461 County Executive — Transfer of Homeland Security and Building Safety department budgets _ moved to Emergency Department division (1110101). $ - #DIV/0! Internal Support Expenditures 559,468.00 18,430.00 $ 18,430.00 Transfers Out - - - $ 1,753,762.00 $ 18,430.00 $ 18,430.00 $ IASU Extension - Oakland County Personnel Expenditures $ 520,795.00 $ 520,795.00 $ 490,795.00 $ Operating Expenditures 303,035.00 303,035.00 289,035 00 0.00% A first quarter budget amendment totaling $18,430 is recommended to move the budget to the Emergency Management division (1110101). 0.00% 30,000.00 5.76% Fay. Due to vacant positions. 14,000.00 4.62% Fay. Workshop and Meeting $4,000, Personal Mileage $2,000, Travel and Confernce $2,000, and Special Event Program $1,000 due to COVID restrictions, Office Supplies $2,700 and Metered Postage $2,300 due to less than anticipated use. Internal Support Expenditures 286,147.00 286,147.00 286,147.00 Transfers Out - - - - $ 1,109,977.00 $ 1,109,977.00 $ 1,065,977.00 $ 44,000.00 0.00% 3.96% COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT Veighborhood & Housing Dev Personnel Expenditures $ - $ - $ - $ - #DIV/0! Operating Expenditures - - $ - - #DIV/0! Internal Support Expenditures $ - #DIV/0! Transfers Out 589,161.00 1,214,983.00 $ 1,214,983.00 - $ 589,161.00 $ 1,214,983,00 $ 1,214,983.00 $ - 0.00% department Total Personnel Expenditures $ 31,352,718.00 $ 32,884,095.00 $ 32,454,095.00 $ 430,000.00 1.31% Operating Expenditures $ 9,297,305.00 $ 11,894,615.25 $ 13,592,515.25 $ (1,697,900.00)-14.27% Internal Support Expenditures $ 4,117,767.00 $ 3,763,760.00 $ 3,763,760.00 $ 0.00% Transfers Out $ 589,161.00 $ 1,214,983.00 $ 1,214,983.00 $ 0.00% $ 45,356,951.00 $ 49,757,453.25 $ 51,025,353.25 $ (1,267,900.00) -2.55% EXPLANATION OF SIGNIFICANT VARIANCES AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Services -Admin. >nnel Expenditures $ 236,586.00 $ 236,586.00 236,586.00 $ - 0 00% sting Expenditures 4,800.00 4,800.00 4,800.00 - 0.00% ial Support Expenditures 6,144.00 6,144.00 6,144.00 - 0.00% $ 247,530.00 $ 247,53000 $ 247,530.00 $ - 0.00% mity Corrections mnel Expenditures $ 4,046,942.00 $ 4,046,942.00 4,046,942.00 $ - 0.00% ating Expenditures 472,025.00 472,025.00 472,025.00 - 0.00% ial Support Expenditures 531,711.00 562,398.00 562,398.00 - 0.00% fers Out - - - - 0.00% - $ 5,050,678.00 $ 5,081,365.00 $ 5,081,365 00 $ - 0 00% I Examiner mnel Expenditures $ 3,571,748.00 $ 3,571,748.00 $ 3,571,748.00 $ - 0.00% ating Expenditures 645,219.00 645,219.00 645,219.00 - 0.00°% ial Support Expenditures 828,661.00 839,508.00 839,508.00 - 0.00% ;fers Out - - - - $ 5,045,628.00 $ 5,056,47500 $ 5,056,475.00 $ - 0.00% Control )nnel Expenditures $ 2,580,003.00 $ 2,580,003 00 $ 2,580,003.00 $ - 0.00% ating Expenditures 394.286.00 452,786.00 452,786 00 - 0.00% ial Support Expenditures 1,093,573.00 1,109,369.00 1,109,369.00 - 0.00% ;fers Out - - - - $ 4,067,862.00 $ 4,142, 15800 $ 4,142,158.00 $ - 0.00% AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Court Probation )nnel Expenditures $ - $ - $ - $ - 0.00% ating Expenditures 54,326.00 54,326.00 54,326.00 - 0.00% ial Support Expenditures 569,149.00 569,465.00 569,465.00 - 0.00% _ $ 623,475 00 $ 623,791.00 $ 623,791.00 $ - 0.00% n's Village )nnel Expenditures $ 18,702,310.00 $ 18,778,258 00 $ 18,528,258.00 $ 250,000.00 0.00% Fay. due to vacant and underfilled positions as well as staff being redeployed to Health Department to assist with contact tracing. ating Expenditures 3,945,872.00 3,962,445.84 3,807,445.84 155,000.00 3.91 % Fay. due to Contracted Services $100,000 and Drugs $55,000 due to less than anticipated activity. ial Support Expenditures 2,643,197.00 2,659,102.00 2,659,102.00 - 0.00% ;fers Out - - - - $ 25,291,379.00 $ 25,399,80584 $ 24,994,805.84 $ 405,000.00 1.59% rent Total mnel Expenditures $ 29,137,589 00 $ 29,213,537 00 $ 28,963,537.00 $ 250,000.00 0.86% ating Expenditures $ 5,516,528.00 $ 5,591,601.84 $ 5,436,601.84 $ 155,000.00 2.77% ial Support Expenditures $ 5,672,435.00 $ 5,745,986.00 $ 5,745,986.00 $ - 0.00% sfers Out $ - $ - $ - $ - $ 40,326,552.00 $ 40,551,124.84 $ 40,146,124.84 $ 405,000.00 1.00% COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT Administration Personnel Expenditures $ 1,683,096.00 $ 1,422,902.00 $ 1,422,902.00 $ - 0.00% Operating Expenditures 442,222.00 454,588.65 454,588.65 - 0.00% Internal Support Expenditures 109,490.00 111,465.00 111,465.00 - 0.00% Transfers Out - - - - $ 2,234,808.00 $ 1,988,955.65 $ 1,988,955.65 $ - 0 00% Local Business Development Division (FKA PEDS) Personnel Expenditures $ 4,182,544.00 $ 1,844,05800 $ 1,844,058.00 $ - 0.00% Operating Expenditures 1,196,032.00 15,777,732.00 15,777,732.00 - 0.00% Internal Support Expenditures 879,746.00 889,796.00 889,796.00 - 0 00% Transfers Out - - - - $ 6,258,322 00 $ 18,511,586.00 $ 18,511,586.00 $ - 0.00% Business Development Personnel Expenditures $ - $ 1,972,369.00 $ 1,972,369.00 $ - Operating Expenditures - - - - Internal Support Expenditures - - - - Transfers Out - 1,300,000.00 1,300,000.00 - 0.00% $ - $ 3,272,369 00 $ 3,272,369.00 $ - 0.00% Workforce Development (Includes Veteran's Services) Personnel Expenditures $ 1,676,895.00 $ 1,840,912.00 $ 1,840,912.00 $ - 0.00% Operating Expenditures 189,624.00 1,965,460.00 1,965,46000 $ - InternalSupportExpenditures 208,14300 209,158.00 209,158.00 - Transfers Out - - - - $ 2,074,662.00 $ 4,015,530.00 $ 4,015,530.00 $ - 0.00% EXPLANATION OF SIGNIFICANT VARIANCES COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT Department Total Personnel Expenditures $ 7,542,535.00 $ 7,080,241.00 $ 7,080,241.00 $ - 0.00% Operating Expenditures $ 1,827,878.00 18,197,780.65 18,197,780.65 $ - 0.00% Internal Support Expenditures $ 1,197,379.00 1,210,419.00 1,210,419.00 $ - 0.00% Transfers $ - 1,300,000.00 1,300,000.00 $ - 0.00% $ 10,567,792.00 $ 27,788,440.65 $ 27,788,440.65 $ - 0.00% EXPLANATION OF SIGNIFICANT VARIANCES COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT EXPENDITURES EMERGENCY MANAGEMENT AND HOMELAND SECURITY AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT Emergency Management Personnel Expenditures $ $ 930,653.00 $ 930,653.00 $ 0.00% Operating Expenditures - 297,943.00 297,943.00 - 0.00% Internal Support Expenditures - 559,468.00 559,468.00 - 0.00% Transfers Out - - $ - $ _ 1,788,064.00 $ 1,788,064.00 $ - 0.00% 3uilding Safety* )epartment Total Personnel Expenditures $ - $ 930,653.00 $ 930,653.00 $ - 0.00% Operating Expenditures $ - $ 297,943.00 $ 297,943.00 $ - 0.00% Internal Support Expenditures $ - $ 559,468.00 $ 559,468.00 $ - 0.00% Transfers Out $ - $ - $ - $ - #DIV101 ------------------------ $ $ 1,788,064.00 $ 1,788,064.00 $ - 0.00% EXPLANATION OF SIGNIFICANT VARIANCES * Building Safety is part of the Facilities Management & Operations fund #(63100) NON -DEPARTMENTAL EXPENDITURES 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 Commission7li Party Agreement Professional Services Provisions Transfer to Community Mental Health Authority Transfer to Municipalities Total COUNTY BUILDINGS AMOUNT ADOPTED AMENDED FY 2D21 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT S (6,000,000.00) $ (6,000,00000) (6,000,00000) $ (4,000,00000) (4,000,000.00) (4,000,00000) 401,413 DO 401,41300 401,41&00 33,305.00 33,305 00 33,305.00 20,00000 20,1)00.00 20,00000 1,450,000 00 1,450,000.00 1.450 000 00 100.00 1, 705, 782, 00 1 705, 782.00 - 175,00000 956,000.00 30,000.00 223,53000 1,108,53000 9,620,616.00 9,620,616 00 9,620,616.00 - 31,945,983.00 31945,98300 $ 1,555,434.00 $ 35,575,629.00 $ 37,241,629.00 $ $ 2,492,736.00 $ 2,333,909.00 S 2,333,909.00 $ 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 RESERVED FOR TRANSFERS Expenditures Classification and Rate Change Contingency Disaster Recovery Emergency Salaries General Fund Contingency Grant Match Info Tech Development Juvenile Resentencing Legislative Expense Local Road Funding Program Misc Capital Outlay Overtime Reserve Private Institutions Foster Care Private Institutions Residential Radio Communications Regranting Program Salary Adjustment Reserve State Institutions Substance Abuse Coord Agency 73,000.00 $ 24,100.00 540,000.00 30,000 00 667,100-00 $ 300,000.00 $ 73,000 00 $ 24,100.00 540,000.00 30,000.00 667,100.00 $ 300,000.00 $ 73,000 00 $ 24,100.00 540,000 00 30,000 00 667,100.00 $ 300,000.00 $ EXPLANATION 000% 0.00% 0.00% 0.00% 0 DO% 000% 0.00% (781,000 00) -446 29% Unfav due to external vendor resources working on COVID-19 activities Ile. COVID-19 Help Hotline) (885,000,00) -395.92% Unfay. due to county departmental costs for COVID-19 activities 000% 0.00% (1,666,000,00) -84221% 0.00% 0.00% 000% o.DO% Om% 0.00% 0.00% 5 11,87100 $ 11,87L00 $ 11,87100 $ - 000% 273,262.00 228,762.00 228,76200 - 000% 300,000.00 300,00000 300,00000 - 0.00% 252,97600 252,97600 252,97&00 - 0.00% (6,000,00000) (6,000,000m) (6,000,000.00) - 0.00% 273,644.00 47,335.00 47,335.OD - 000% 7,454,96100 6,326,30900 6,326,30900 - 000% - 1,127 000 00 627,000.00 500 000.00 44.37% Fay. Expected due to Prosecutor's Office recent fling of resentencing notices for 22 individuals 8,600.00 8,600.00 8,60000 - 000% 100 1.00 100 - 000% 315,034.00 838,693.00 838,693.00 - 0.00% 575,000 00 575,000 00 575,000.00 - 0.00% 365,144 00 365,144 00 - 365,144,00 100 DO % Fav due to budgeted amount not expected to be used 105,356.00 105,356.00 - 105,356 00 100 00% Fav due to budgeted amount not expected to be used 975,000.00 975,00000 975,00000 - 49,245,389 00 39,245,389.00 10,000,000 00 20.31% Fay. due to use of CARES Act funds utilization for eligible Public Health and Public Safety personnel costs. 500,000.00 5,265,814.00 5,265,81400 - 000% 604,97100 604,971.00 604,97100 - 000% 4,787,165.00 4,787,16500 4,787,16500 - 0.00% NON -DEPARTMENTAL EXPENDITURES AMOUNT ADOPTED AMENDED FY 2021 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) Summer Employees Salary Appropriation 250,000 00 231,296 00 231,296.00 - Supportive Services 29,849,847 00 19,849,84TOO 10,000,000.00 Total $ 11,052,985.00 $ 95,146,529.00 $ 74,176,029.00 $ 20,970,500.00 PERCENT EXPLANATION 000% 22 04 % Transfers to Other Funds Fire Records Management $ 507,699.00 $ 507,699 00 507,699.00 - 0 00 % CLEMIS 1,644,186.00 1,894,68600 1,894,686.00 - 0.00% Information Technology 3,620,676.00 3,620,676A0 3,620,576.00 - 0.00% Bldg Auth Fac Infras IT Debt 2,209,750.00 2,209,750.00 2,209,750 00 - 000% Project Work Order Fund - 368,000.00 368,000.00 - 0 00 % Building Fund 3T0001000 00 3,993,05200 3,993,052.00 - 0 DO% HR - Financial System Replacement Project - 5,200,000 00 5,200,000.00 - 0.00% 52/3 District Court Probation Drug Court Grant - 7,47&00 7,47800 - 0 00% $ 10,982,311.00 $ 17,801,341.00 $ 17,801,341.00 $ - 0.00% TOTAL NON-DEPT. APPROPRIATIONS $ 27,050,566.00 $ 151,824,508.00 $ 132,520,008.00 $ 19,304,500.00_ 12.72% Fav due to use of CARES Act funds utilization for eligible Public Health and Public Safety personnel costs. TRANSFER TO GENERAL PURPOSE FUNDS Child Care Fund $ 19,533,991.00 $ 19,590,558.00 $ 15199OT558 00 $ 3,600,000 00 18 38% Fav due to less than anticipated amount needed for the Child Care Fund based on lower overall Child Care expenditures for FY 2021 Social Welfare Fund Foster Care 1,000.00 1,00000 - 1,000 00 100.00 % $ 19,534,991.00 $ 19,591,558.00 $ 15,990,558.00 $ 3,601,000.00 18.38% TOTAL EXPENDITURES $ 46,585,557.00 $ 171,416,066.00 $ 148,510,566.00 $ 22,905,500.00 13.36% FY 2021 BUDGET AMENDMENTS FY 2021 BUDGET AS ADOPTED - GENERAL FUND/GENERAL PURPOSE FUNDS $ 457,508,892.00 BUDGET AMENDMENTS M.R.#20447 10/2112020 BOC Tri-Party Road Improvement Program Fiscal Year 2021 Appropriation - Charter Township of Bloomfield - $ 91,818 00 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 $ 600,000.00 Coronavirus Relief Funds M.R.#20457 10/21/2020 Sheriffs Office Contract Amendment #2 for Law Enforcement Services in the Charter Township of Lyon 2019-2021 $ (268,127,00) M.R.#20458 10/2112020 Clerk/Register of Deeds - Delete and Create Positions $ 209,136.00 M.R.#20461 10/21/2020 County Executive - Transfer and Create the Emergency Management and Homeland Security Department Under the $ 31,026 00 County Executive's Administration M.R.#20462 10/21/2020 Economic Development and Community Affairs - Reorganization of Divisions and Positions $ (42,809.00) M.R. #20463 10/21/2020 County Executive - Acceptance of the County Executive Plan to Partner with the Community Foundation for Southeast $ 1,000,000.00 Michigan on a Community Policing Innovations Fund for Oakland County Communities M.R.#20470 10/2112020 Board of Commissioners - Expedited Acceptance of Grant Award from the Center of Civic Tech and Civic Life (CTCL) $ 157,907.00 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 $ 70,424.00 M.R. #20516 Township of Groveland $ 57,924.00 M.R. #20517 Township of Waterford $ 121,424.00 M.R. #20518 Township of Lyon $ 140,167.00 M.R. #20523 11/19/2020 Central Services Fleet Expansion of (1) Vehicle for Emergency Management and Homeland Security $ 3,276.00 M.R. #20526 11/19/2020 Board of Commissioners Approval of Additional Appropriation for the 2020/2021 School Drinking Water Station $ 60,000.00 Program M.R.#20557 11119/2020 HR - Water Resources Commissioner's Classifications Salary Adjustments $ 49,947.00 M.R.#20559 11/19/2020 County Executive/Information Technology Public Safety Transparency Dashboard Project (CLEMIS) $ 250,500.00 M.R. #20564 11/1912020 Prosecuting Attorney FY 2021 Crime Victim Rights Grant Acceptance $ (25,070 00) 63 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 11119/2020 Sheriffs Office - FY 2020 Bulletproof Vest Partnership (BVP) Program - Grant Acceptance M.R. #20575 11/1912020 Animal Shelter and Pet Adoption On-line Dog License Fee Schedule M.R.#20577 11/1912020 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 $ 19,180.00 $ 19,180.00 $ 11,704.00 $ 8,50000 $ 1,300,00000 $ 325,000.00 M.R. #20632 12/7/2020 Management & Budget/Human Resources Department /County Executive - Compliance Office - Financial and Human $ 5,200,000.00 Capital Management System Replacement Project Implementation Extension M.R. #20635 12/7/2020 Management & Budget FY 2020 Year End Report and Budget Amendments Encumbrances Carry Forwards Adjustments to Circuit Court Adjustments to Children's Village Adjustments to Health Division Adjustments to Non -Departmental $ 571,910.21 $ 14,074,942 00 $ 8,000.00 $ 45,662.00 $ 31,143.00 $ 127,533,618.00 $ 142,265,275.21 M.R. #20638 12/712020 Board of Commissioners - Reorganization of Units and Positions $ (35,060.00) M.R. #20369 12/7/2020 Health and Human Services/Health Division - Continuations of the Oakland Together School Nurse Program in $ 1,495,117.00 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- $ 104,902.00 2021 M.R. #20648 12/712020 Sheriffs Office - Contract Amendment #3 for Law Enforcement Services in the Charter Township of Lyon 2019 -2021 $ 109,418.00 M.R. #20649 12/712020 Sheriffs Office - Contract Amendment #2 for Law Enforcement Services in the Charter Township of Orion 2019 -2021 $ 99,522.00 M.R. #20653 12/7/2020 Sheriffs Office - 2020 Law Enforcement Services Agreement with the Somerset Collection LP $ 2,86200 M.R. #20582 12/7/2020 Board of Commissioners - Authorization of a Forensic Audit of Management of County Property Tax Foreclosures $ 937,500.00 64 FY 2021 BUDGET AMENDMENTS M.R. #20661 121712020 County Executive - Approval of a Request for Proposal to Enter Into Professional Services Contracts for Strategic $ 1,330,000.00 Planning and an Equity Audit to Improve County Government Services M.R. #20664 1217/2020 Board of Commissioners — Reallocation of Coronavirus Relief Funds to Create Oakland Together Restaurant Rescue $ 3,000,000.00 Program TOTAL AMENDED BUDGET AS OF 12/31/2020 $ 616,209,635.21 65 mnt,al Contrµ me Improvement Dommort vok Cook ER 10,000 ANC �e6oard at CCEplf-D S a roved b G�St eoryntsPoic m aceordance DeG°ltt 2020 Grant-Roond2 R font�tUmp theSbe)tetssvetNoosingGooveteans.treatmentD0U 6lssell E 020 DovWeben Grant program 20 2 M \9a D00 D g co rtGrantPr°9ram ,�artliN...- 65U v� t 2, g00 ptIFY2 $ 10400 p� C1 FFY21 $ gp00 m UENT TAX REVOLVING FUND 51600 JES as for Services ADOPTED AMENDED BUDGET BUDGET $10,600,000.00 $10,600,000.00 FY 2021 VARIANCE FORECAST FAV/(UNFAV) PERCENT 10,600,000.00 $ - 0 00% Revenues 2,000,000 00 2,000,000 00 2,000,000 00 - 0.00% otal Revenues $12,600,000.00 $12,600,000.00 $12,600,000.00 $ - 0.00% TING EXPENSES inel Expenditures $ 221,263.00 $ 221,263.00 $ 221,263.00 - 0.00% Ling Expenditures 394,555.00 394,555 00 394,555.00 - 0.00% ;t Expense 943,750.00 943,750.00 943,750.00 - 0.00% er Out to Other Funds: !ral Fund - Collection Fees 2,300,000.00 2,300,000.00 2,300,000.00 - 0.00% Non -Departmental 3,000,000.00 3,000,000.00 3,000,000.00 - 0 00% Release Facility Refunding Debt Svc 1,566,300.00 1,566,300.00 1,566,300.00 - 0.00% Bldg Renovation Refunding Debt Svc 1,866,400.00 1,866,400.00 1,866,400.00 - 0.00% District Court Refunding Debt Svc 1,311,300.00 1,311,300 00 1.311.300.00 - 0.00% Transfer Out to Other Funds $ 10,044,000.00 $ 10,044,000 00 $ 10,044,000 00 $ - 0.00% rerating Expenses $ 11,603,568.00 $ 11,603,568.00 $ 11,603,568.00 $ - 0.00% JE OVER (UNDER) NDITURES* $996,432.00 $996,432.00 $996,432 00 $0.00 t Position - Beginning $205,648,048.12 t Position - Ending $206,644,480.12 -Y 2020 Designated Net Position**: es - Designated - Debt Service $57,877,280.00 as - Designated - Delinq Taxes Receivable 141,888,395.57 es - Designated - Collection Fees 5,882,372.55 :signated - Net Position $996.432.00 t Position - Ending $206.644 480.12 note that in the Adopted Budget (line -item book) this is budgeted as'Planned Use of Balance" in the revenue category a note the designated equity amounts are adjusted at year-end only EXPLANATION OF SIGNIFICANT VARIANCES FY 2021 FIRST QUARTER REPORT ENTERPRISE FUNDS TREASURER ADOPTED AMENDED FY 2021 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES WENT PERSONAL PROPERTY 1800) 1 \TING REVENUE $508,689.00 $508,689.00 $428,689.00 ($80,000.00) -15.73% Unfay. Administration Fees ($80,000) due to decreased collect fees due to COVID-19 pandemic resulting in unopened busine \TING EXPENSE 513,689.00 513,689.00 430,689.00 $83,000 00 16.16% Fay. Controllable Personnel $80,000 due to vacant and underf positions Also fay. Metered Postage $3,000 due to less than anticipated use PERATING INCOME (LOSS) ($5,00000) ($5,000.00) ($2,000.00) $0.00 iPERATING REVENUE (EXPENSE) 5,000.00 5,000.00 $5,000.00 $0.00 INCOME BEFORE RIBUTIONS AND TRANSFERS $0.00 $0.00 $ 3,000.00 $0.00 ;FERS OUT - - - - NET INCOME (LOSS)* $0.00 $0.00 $3,000.00 Saw NET POSITION - BEGINNING 900,560.96 NET POSITION - ENDING $903,560.96 e note that in the Adopted Budget (line -item book) this is budgeted as'Planned Use of Balance" in the revenue category 0.00% 0.00% COUNTY 4UAR�RtREpORT Fy 2021EtNRTERPRISE FCAW, PARKS gREGR GEf A RUNS AMENDED ADOPTED BUDGET ^Y BUDGET n N COM 1O 00 $ 10 903,g16 00 MISS N PARKS S RECREA $ 10 gp3,416 $ 28,08276200 =NUE $ 28,082,16200 NSE INCOME (I-OSS) REVENUE(ExPENSE) $ (17,17g 34600) $ 14,568 301100 FY y021 FORE�A�T„ $ 117 179 346 OD) S 14,767,30000 10,9034,600 28 p82 762 00 (2 412 p46.00) OF SAGNIFIGAN^TVA,,,,, �p�NAS1ON�Y�,,,,,,�,---^ 0 p0°/° nation of fu, jud e the reaPProP ount of $5 dgars cpafnees on completed Ludes AdIPPno nd $99 $414500 bpurcha� 1orAhe °hn Deere loader pctober and November of e4uiPm 70, bOUaget $ Oonsuimers Energy bills in ed burns of $ 2 acqurs crib e program Natural Resources PrMainto Gre nhouse deconstN°t'c activity $ $29 7g6 elated e removal. TO s Golf course rental hom - p p0°Jo 01,A79,p,00% 1q,767,3p0 00 (2 412 046 00) � $ 241204600 85,20 8A,277 82 1,046 EFORET�NSFERS $$ 26- 279 gE�PIp,NNED USE OF BALANCE (LOS 'ION - BEO,iNNiNC' e revenue category ION - ENDING d Balance , in tt ok) this is budgeted as "Planned Use of F an _ net the Adopted Bud inaeasin9 Property Ta o dments lfl'�Ude and Recreation creasing a si Budget amen passage of the Parks d increasing to the of Balance (tints $a 05,986. Th00e a 0) eihE d EQuitY Adlusb" Irom investments ($10 es,, Refund planned Bartle gud9eie of incomedue o lower inieaaredst rfrom reductkon deposit, related Yo prolected ea jot b e of expenses ddureforbusleas ion $43,559 $2 027 and the re'c gestfo ro)ect; SPlash Pad Fam y Restroom P p 00°/° V�Fpo FY 2021 FIRST aUARTERF NDR7 INTERNAL Se" CIOMM ISSYOH£R IryAT£R RESDURC£S CO OF SIGNIFICANT VARIANCES OPLANATION �rT�Y�w�r VARVAN PERCENT FY 2021 FAVI(UNFA`11 AMENDED TED ADOP BUDGET due to unallocate BUDGET r - 000) vorable Sat ant Salaries ($2 000, offset in fa R d va les s, eimbursem � ositron Unfav es for turnover an 00(00) fan;es. D ( 9900) 44,24424p.00 EaU1PMEN7 FUN 46,244 240 00 45,535 .05900 _ d vaca 00 000 duetur Hover 500 due STING REVENU 2501p0 _ , are gg11, 250.100--00 4.30°I° Fringes $26o uter SO - Come DA) system co 1000p t2 Opp 000 00) Salaries and radiation Ac4wsdlon (SCAo$et by unfavmP 250, Fav - DeP q 19°t° posifions. d Data a trally d relatk ntrol an 2021. P neede proj isory C n 19 FY en were d n FY 2021 A6? $2,p46,3g4Op Ustrn Sup ect not be g booked 4 000 ad2 de $46,622 629 00 venue ($ 2 �''�� 0 0 but enter entatio eco 15y �� Prior Years Re entfrom FY It of rmPte �avorab dh? 46 185 g,48,869 223 00 bur se t l$40,000) a rasa set bs Cares Act reim an (CAMP}, off F�peat% ( U2 g 561'S42.W Info Tech Develop j - pAdluskff% Pnor Year eratrn9 ri1i at Revenue anagem the oP ant R Capital Asset M nfav " lion entry tO mcl Unfav - equ on aging VYING EXPENSES to Corr Revenue U allte F keep t of a fate FY 2020 invoidairs for uP acting a aced rep ,olecrecei f ult of unanficip ($10 000) the res - equipn1ent. 00 due to Cares Act _195% 52,0 uiring enditure or costs re h $45 394.00 ears Exp ived for lat. b money ould 1176°!o Fav- - Rees,uvres C ms ems for e mburfor purchases cha Lged a- 00) ($2374 a83O0) $37 p00O0 Natef on to Yr2ozp5yAlso, a correction _- ($2 376 383. $351 600 00 received In F GOME (LOSS) BEFORE $314,60p 00 v4 600 00 --- -- -- - rPERA7ING REVENUEIIEXPENSE', — - - ADOPTED BUDOET 15 000 Op AMENDED BUDGET 190 ppp 00 00 INTERNAL- SERVICE FUND WATER RESOURCES COMMlSS10NER VARIANCE PERCENT �( 2021 FA`11tUNFAVI ^ram FORECAST Y^ S190 000 00 278,385 00 278 3i� $g3,394 00 160 342 W >FER IN $2 p65,274.00) ;FERS IOUTI �y2148,,6�00) �$2 207,125 00) 0 00% �PUp,NpT10N OF SIGNIFICANT VARIANCES VENUES OVER NNDER) S 29,418,218.29 erases' ISES' uitY pd) in ExP $ 27S 3cate9oty and Budgeted Eq BVG NNING Balance' M the revenue NET POSITION -planned use of Fund .NET pOSITION -ENDING item bOOK) th�a �s budgeted as ;thatin the Adopte note d Budget pine- ANCE FUND 67700 IENUES: ue RISK MANAGEMENT ADOPTED AMENDED FY 2021 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT $ 11,846.00 $ 11,846.00 $ 11,846.00 $ 5,105,824.00 5,105,824.00 5,105,824.00 )erating Revenue $ 5,117,670.00 $ 5,117,670.00 $ 5,117,670.00 $ ,ENSE $ 4,689,019.00 $ 4,689,019.00 $ 4,689,019.00 $ 1,775, 500.00 1,775, 500.00 1, 856, 800.00 0.00% 0.00% 0.00% 0.00% EXPLANATION OF SIGNIFICANT VARIANCES (81,300.00) -4.58% - Unfay. Adj Prior Year Expense due to timing of FY 2020 invoices received and paid in FY 2021. NG EXPENSES $ 6,464,519.00 $ 6,464,519.00 $ 6,545,819.00 $ (81,300.00) -1.26% DME (LOSS) (1,346,849.00) (1,346,849.00) (1,428,149.00) (81,300.00) 6.04% 3 REVENUE (EXPEI 150,000.00 150,000.00 100,000.00 (50,000.00) -33.33% - Unfay. due to lower than expected available cash balance. JT 0.00 (113,385.00) (113,385.00) 0.00% OVER/(UNDER)- $ (1,196,849.00) $(1,196,849.00) (1,441,534.00) $ (131,300.00) =TC M=l IKIKJIKJ1 CC A fl 1A ADOPTED AMENDED FY 2021 VARIANCE D 67800 `----------- BUDGET ------ ---- BUDGET --------- FORECAST --------- FAV/(UNFAV) ----------- PERCENT --,.._------ EXPLANATION OF SIGNIFICANT VARIANCE ---- "------------------------------------------- - VEBA DEBT 33,999,000 33,999,000 32,776,026 (1,222,974.00) -3.60% - Unfay. due to projected revenues less than budget projections STRATION 3,122,532 3,122,532 2,965,569 (156,963 00) -5.03% - Unfay. due to projected revenues less than budget projections STRATION - PTNE 350,000 350,000 156,369 (193,631.00) -55.32% - Unfav due to projected revenues less than budget projections. SATION-MATCH 2,500,000 2,500,000 2,500,000 0.00% PION PLAN 19,500,000 19,500,000 20,791,500 1,291,500.00 6.62% - Fay. due to projected revenues more than budget projections. FION PLAN - PTNE 220,500 220,500 158,942 (61,558-00) -27.92% - Unfay. due to projected revenues less than budget projections CE TRAINING 1,523,416 1,523,416 1,461,645 (61,771.00) -4.05% - Unfay. due to projected revenues less than budget projections. 3 UNIT 1,188,941 1,188,941 11141,803 (47,138.00) -3.96% - Unfay. due to projected revenues less than budget projections ITION 354,289 354,289 354,289 - 0.00% 85,500 85,500 85,500 - 0 00% 595,783 595,783 595,783 - 0.00% 120,903 120,903 120,903 - 0.00% MENT 350,000 350,000 350,000 - 0.00% -I SAVINGS 4,500,000 4,500,000 4,500,000 - 0.00% NICE 545,000 545,000 545,000 - 0.00% 19,833,000 19,833,000 19,833,000 - 0 00% 34,677,000 347677,000 34,677,000 - 0.00% =RAGE INSURANCE 12,000,000 12,000,000 12,000,000 - 0.00% 3,278,500 3,278,500 3,600,061 321,561.00 9.81 % - Fay. due to projected revenues more than budget projections. 252,500 252,500 327,065 74,565 00 29.53% - Fay. due to projected revenues more than budget projections. CE 3,750,000 3,750,000 3,394,422 (355,578.00) -9.48% - Unfay. due to projected revenues less than budget projections. 3ATION 3,283,921 3,283,921 2,358,154 (925,767.00) -28.19% - Unfay. due to projected revenues less than budget projections MPENSATION 300,000 300,000 252,326 (47,674.00) -15.89% - Unfay. due to projected revenues less than budget projections. E 1, 500, 000 1,500,000 1,500,000 0.00% ANCE 15,000 15,000 15,000 0.00% EARAGES - - - - TAL INSURANCE 6.500 6,500 151,000 144,500.00 2223 08% - Fav due to projected revenues more than budget projections. INSURANCE 455.000 455,000 455,000 - 0.00% ICAL - EMPLOYEE 5,333,000 5,333,000 5,333,000 - 0 00% )N INSURANCE 6,000 6,000 143,000 137,000 00 2283.33% - Fay. due to projected revenues more than budget projections. RANCE 180,000 180,000 180,000 - 0.00% UE - - - - I DRUG REBATES 1,500,000 1,500,000 1,500,000 - 0.00% 10,000 10,000 10,000 - 0.00% ONCE 1,500 1,500 1,500 - 0.00% VENUE 10,000 10,000 10,000 - 000% 155,347,785 155,347,785 154,243,857 (1,103,928.00) -071% - VEBA DEBT INT/AGING 7,394,000 7,394,000 7,394,000 0 00% D 67800 BUDGET BUDGET FORECAST FAW(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCE RATION 226,599 226,599 226,599 - 0.00% 5 UNIT 1,079,941 1,079,941 1,029,346 50,595.00 4.68% - Fay. due to lower than projected Professional Services AYMENTS 85,500 85,500 85,500 - 0.00% M 596,552 596,552 596,552 - 0.00% ITION 355,790 355,790 239,018 116,772.00 32.82% - Fay. Personnel due to vacant position within Employee Recognitiol ES 121,714 121,714 121,714 - 0.00% MENT 350,000 350,000 225,000 125,000.00 35.71% - Fay. due to lower than projected tuition costs. H SAVINGS 4,500,000 4,500,000 4,276,430 223,570.00 4.97% - Fay. due to the use of Retiree Health Saving forfeitures held by Prl offset current expenses. NCE 1,000,000 1,000,000 1,000,000 - 000% =AVE CASH -OUT 2,175,000 2,175,000 3,300,000 (1,125,000.00) -51.72% - Unfay. due to projected Sickand Annual Leave Cash -Out more the 19,833,000 19,833,000 20,045,719 (212,719.00) -1.07% - Unfay. due to projected Social Security expense more than budget 47,625,000 47,625,000 46,600,000 1,025,000.00 2.15% - Fay. due to projected medical expenses less than budget projectio -RAGE 13, 500, 000 13, 500, 000 13, 500, 000 0.00% 3,300,000 3,300,000 3,300,000 0.00% 260,000 260,000 260,000 - 0.00% CE 3,750,000 3,750,000 3,950,000 (200,000 00) -5.33% - Unfav due to projected expenses more than budget projections. 3ATION 3,285,928 3,285,928 3,138,439 147,489.00 4.49% - Fay. Personnel and Fringe $105,000 due to vacant position within Insurance $83,500 for policy lower than budgeted Unfay.($41,94E received after fiscal year end close MPENSATION 300,000 300,000 300,000 - 000% Y 229,991 229,991 250,991 (21,000 00) -9.13% - Unfay. due to pandemic response to COVID. PREMIUM TAX 25,000 25,000 25,000 - 0.00% 18,000 18,000 18,000 - 0.00% OUTCOME RESEARCH 22,000 22,000 22,000 - 0.00% 240,000 240,000 240,000 - 0,00% 135,211,506 135,192,563 134,727,486 465,077.00 0.34% INDER) EXPENSES 20,136,279.00 20,155,222.00 19,516,371 (638,851.00) BEGINNING 210,488,589 ENDING 230, 004, 960 ed Budget (line -item book) this is budgeted as "Budgeted Equity Adjustment" in the expense category I is responsible for the Retiree Healthcare Debt. The principal and interest payments are included in the fringe benefit rate but the principal portion is required to be accounted for through a liability :count. The FY 2021 principal amount is $26,605,000 r T LUL"I rIRJ I wuU m I am mcvvm I ENTERPRISE FUNDS CENTRAL SERVICES ADOPTED AMENDED FY 2021 VARIANCE BUDGET BUDGET FORECAST FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES DUNTY INTERNATIONAL .500) 3 REVENUE $4,772,155.00 $4,772,155 00 $4,775,664.00 $3,509.00 0.07% - Fay. Car Rentals $61,600 and Landing Fees $46,300 due to an incre; domestic travel. Fav Land Lease 7,400; Partially offset by unfav U.S Customs Reimbursement ($111,000) due to restricted international tr due to COVID, along with an increase in inspector rates; offset by a reduction in one Customs agent in July. 3 EXPENSE 7,069,400.00 7,069,400 00 7,069,400.00 - - ITING INCOME (LOSS) (2,297,245.00) (2,297,245.00) (2,293,736.00) 3,509.00 -0.15% 4TING REVENUE (EXPENSE) 302,400.00 302,400.00 302,400.00 - )ME BEFORE -IONS AND TRANSFERS ($1,994,845 00) ($1,994,845 00) $ (1,991,336.00) $3,509.00 -0.18% SIN )NTRIBUTION - - - - INCOME (LOSS) ($1 994,845.00) ($1,994,845.00) $ (1,991,336 00) ASSETS -BEGINNING $ 80,387,344.61 ASSETS -ENDING $ 78,396,008.61 $3,509.00 that in the Adopted Budget (line -item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category MOTOR POOL FUND 66100 OPERATING REVENUE: Outside Revenue Inside Revenue Total Revenue OPERATING EXPENSE ADOPTED AMENDED BUDGET BUDGET $ 145,000.00 $ 145,000 00 8,543,432.00 8,542,632.00 8,688,432.00 8,687,632.00 FY 2021 First Quarter Report INTERNAL SERVICE FUNDS CENTRAL SERVICES FY 2020 VARIANCE FORECAST FAV/(UNFAV) PERCENT 145,000.00 $ - 0.00% EXPLANATION OF SIGNIFICANT VARIANCES 7,713,632.00 (829,DD0.00) -9.70% - Unfay. Gasoline, Oil & Grease Charges ($470, 000) due to current fuel costs (partially offset by favorable Gasoline expense) and Leased Equipment ($359,00 due to actual activity trends to date. 7,858,632.00 (829,000 00) 9,283,224.00 9,282,024.00 8,615,424.00 666,600.00 7.18% - Fay. Gasoline Charges $455,000 due to market fluctuations and miles driven (ofi OPERATING INCOME (LOSS) (594,792.00) (594,392.00) (756,792.00) (162,400.00; NON -OPERATING REVENUE 467,700.00 467,700.00 467.700.00 - (EXPENSE) NET INCOME (LOSS) BEFORE OPERATING TRANSFERS (127,092.00) (126,692.00) (289,092.00) (162,400.00) TRANSFERS IN / (OUT) 160,342.00 278,385 00 278,385.00 - CAPITAL CONTRIBUTIONS - - _ _ NET REVENUE OVER/(UNDER) EXPENSES (PLANNED USE OF FUND BAL.) - $ 33,250.00 $ 151,693.00 $ (10,707.00) $ (162,400.00) TOTAL NET ASSETS - BEGINNING $ 11.488.403.62 TOTAL NET ASSETS - ENDING $ 11,477,696.62 0 00% 0.00% by unfavorable Gasoline, Oil Grease Charges revenue), Indirect Costs $107,600 due to the development of actual charges after budget finalization, Hospitalizatioi $52,000 due to less than anticipated hospital costs and Parts and Accessories $52,000 due to newer vehicles having fewer repairs. 'Please note that in the Adopted Budget (line -item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category. COUNTY OF OAKLAND FY 2021 FIRST QUARTER REPORT INTERNAL SERVICGEN7 pp SIGNIFICAN C�ES^^'^- FACILITIES MANA EXpLANp`TIOPI — VARIANCE PERCENT -�"" antfdpated Outside F( 2021 FAVINNF than ork AMENDED ACTUAL y due to more min nit Health Netw "ram RevenuePrimaril u ADOPTED BUDGET N,,,,,,,.,---^'^ Other es for Oakland Co gUDGEt _-.,�--^ 520% _ Fay. Ext- Charges pepartment requests $ 25,00000 AgencN Maintenance es based on . #63100)(OGH ). har9 third Par __--^_--g OPERATIONS ( $ 506,187 00as from _t 00 $ 187A0 o Unfay. Maintenance Dep natural 9 enefa ^-S MAINTENANCE A81, 0 99 Jo chasing d Fringe S pCILITIE 481,A87 250,000 001 8 ES: $ 00 $ (225, 00 00) PERATING 24 906 605. 0 13°! Revenue 2g,156,605 00 $ 25 412,792 00 0D 00 2_ Outside 605 00 92 00 $ 610 0 25156. $25,637,7 $ 28,006,264.01) $ 25 637,792 00 Revenue $28,616264 00 Inside $ 28 616,264.00 Total Revenue PFWING EXPENSES ��—_�, $ (2$ 9— $ — 00) $ 385 000 00 (25 E (LOSS) BEFORE $ 2,9 ta,4' 2, PYEIRATONG YRAgygFERS 000 due to PUT r Salanes an $ewa9 Gas $400, mild wrote; Water & Fay. Natural lower m nces and underf'illed Positions, 2500 pD u arket p 1 Service $ sources, due to turnover ad�al usage, Electrfca from FM& enerc $300,000 based on s and saving 55 000 based c Charges $250ODD contract MafintenancR $ ment and special cost third -Party Equipment a res� to lower- repa'rlmainto f equip anon initiafrves; {ewer purchases as consery d use of internal staff t0 000 due to actual usage ar d Supplies $6 000 based du to a decrease increase Road Salt $35, vehic , Matenat an Icl ment $3D, pOVID It, s; - Develop of the Info Yedi $475 0001 based on weather condifioI Supplies to reopen demand for seMceS v Maintenance d internally nd producr unfa ices performe 19 pandemic aepartment partially set of meerials for a VID- a result of the due to increase in increased use rations as us ($150, Grounds suppliesa County wid90 pe Sublet tiRe G its (SI Pandemic, testing sites as pricy increases; to setup $40,pp0) due to a result of d use of ser0c O erations ( one-ume [ requests as increase Into Tech P along with 000) based °n 1g pandemic,, maintenance ($65, COVID- 000) due to increase fn VII result of tA�oCAD and Kroril software ($3D, a result of the GO eg 01 POrr ases',c req es,e' b department as nested by ncrease special cleaning se wdh Product Prue 19 pandemic along tPNGEs �r"„r UNn OF oP pyt(E REvOR� ON OF Sk f\ .o a eft etur p12) due Vi 2p?.-, 'LSER CG fk3EtSt FJtpuA r 'ts$� O�banfiaPateddaustment�$2, %toeol x"eS M PFttPNGE PERCE � �pme yd to d e to bg unfa a as � t nent 02A FP lkk3t' ,A "'..-�' 991� Fa0Ome d�sv�bpa�acede\Sa Y 2 n° ents. en acu Et1DE0 PCB "' r $ 22'ge8 p4 FY 2020 Yeat to e ptED 0 D P_BVoG,..-�'r $�~ 122,9�'0 BVOG�r $ 1p0 p0040 0 �Oor(a 00 o� ppERP�\NG RE�EN�E $ 2 qi0 ASA p0 $ 401 9g8 00 $$ 1 Y j1 g2b 20 „-n the revenue °ate9°ry' FERS fN�T R) 2,6?8 4 2 00 Satan z NNSFERS o S p�lERttS�oE ed us ET REVNSEg" gEGtNNfNG tins fe dgeted as„p\ann bu P. NE post i otk pd P ed gud9et lXlll ten book) tease note tha rT NCI rIKDI UUAK I GKKCYUKI INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2020 VARIANCE BUDGET BUDGET FORECAST FAV1(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES chnoloSy - Operations (63600) VENUES: $ 3,757,306.00 $ 3,757,306.00 $ 3,636,606.00 $ (120,700.00) -3.21% - Unfay. Outside Agencies ($130,300) due to reduction of customer activity. F offset fay. by Sale of Equipment $9,500 due to the sale of assets at the coui 33,074,402.00 33,093,236.00 $ 32,191,736.00 $ (901,500.00) -2.72% - Unfay. OC Depts Development Support & Non Governmental Development due to limited resources to complete development due to vacancies. Also, u Depts Operations & Non Governmental Operations ($384,800) due to increa and unfay. Equipment Rental ($28,300) due to decreased rebllls to departm maintenance charges on IT Office Equipment items. TING REVENUE $ 36,831,708.00 $ 36,850,542.00 $ 35,828,34200 $ (1,022,20000) {PENSES 48,443,043 $ 48,461,87700 $ 47,431,477.00 $ 1,030,400.00 _OSS)BEFORE 2ANSFERS $ (11,611,335.00) $ (11,611,335.00) $ (11,603,135.00) $ NG REVENUE $ 70,500.00 $ 70,500.00 $ 20,300.00 $ I $ 3,906,676.00 $ 3,906,676 00 $ 3,906,676.00 $ )UT) $ - $ - $ - $ 'RIBUTION $ - $ - $ - $ 8,200.00 (50,200.00) 2(UNDER) EXP* $ (7,634,159 00) $ (7,634,159.00) $ (7,676,159.00) $ (42,000.00) )SITION - BEGINNING $ 34,704,876.64 )SITION- ENDING $ 27,028,717.64 It in the Adopted Budget (line -item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category. -2.77% 2.13% - Fay. Depreciation $4,091,700 for IT capital projects in progress not fully ope Travel $51,300 due to travel restrictions as a result of the COVID-19 pandei Garbage Disposal $6,400, Printing $1,400, Mileage $1,000, Freight $800 an $400 due to usage. Also, Internal Services overall fay. of $26,900 is primaril Insurance Fund $60,600, Telephone Communications $29,900, Motorpool C $2,600 and Motorpool $5,300 based on usage, partially offset by unfay. Mai Dept. Charges ($71,000) The overall favorability is paritally offset by unfay. Professional Services ($1,710,800) due to projects previously approved in p Parts and Accessories ($344,200), Software Rental ($803,500) and Softwar Maintenance ($154,600) due to higher than anticipated costs, Contracted Si ($120,000) due to increased activity; Employee Training IT ($9,800) and Un Receivable ($7,300). -0.07% -71.21 % Unfay. Interest Income ($50,200) due to less than anticipated level of cash investments. 0.00% 0.00% r M ADOPTED AMENDED BUDGET BUDGET chnology- Telephone Communications (67500) EVENUES: TING REVENUE {PENSES -OSS)BEFORE :ZANSFERS NG REVENUE $ 12,000.00 $ 12,000.00 $ 3,525,876 3,525,876 $ $ 3,537,876.00 $ 3,537,876.00 $ $ 3,753,648.00 $ 3,753,648.00 $ r i NLl r[KD I WUH I CM KCYUR I INTERNAL SERVICE FUNDS I ENTERPRISE FUND INFORMATION TECHNOLOGY FY 2020 VARIANCE FORECAST FAVJIUNFAV) PERCENT 7,810.00 $ (4,190,00) 3,439,276.00 $ (86,600.00) 3,447,086.00 $ (90,790.00) 5,039,948.00 $ (1,286,300 00) $ (215,772.00) $ (215,772.00) $ (1,592,862.00) $ (1,377,090,00) $ 30,000.00 $ 30,000 00 $ 28,100.00 $ (1,900.00) J $ $ $ $ - 'RIBUTION $ - $ _ $ _ $ _ )UT) $ - $ _ $ _ $ _ 2(UNDER) EXP- $ (185,772 00) $ (185,772.00) $ (1,564,762.00) $ (1,378,990,00) )SITION - BEGINNING $ 2,463,351 31 ISITION - ENDING $ 898,589.31 It in the Adopted Budget (line -Rem book) this is budgeted as "Planned use of Fund Balance" in the revenue category. -34.92% -2.46% -2 57% -34.27% -6.33% 0.00% 0.00% 0.00% EXPLANATION OF SIGNIFICANT VARIANCES Unfav Sale of Phone External due to decreased usage of land lines. Unfay. Sale of Phone Internal due to increased cell phone usage. Unfav Communications ($855,400) and Maintenance Equipment ($321,400 higher than anticipated cost, Indirect Cost ($44,900) due to actual charges t developed after budget finalization; Internal Services ($59,500) primarily due Tech Operations ($21,200) and Telephone ($41,400) based on actual usac Equipment Repairs and Maintenance ($10,000) due to costs being higher th budget projection. Fay.Travel $5,000 due to less than anticipated use. Unfay. Interest Income due to less than anticipated level of cash available fc investments. r i LULL rIKJ I UUA I CK KCYUK I INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2020 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES chnolo�y - CLEMIS (53500) EVENUES: $ 4,757,701.00 $ 4,757,701.00 $ 5,145,901.00 $ 388,200.00 8.16% Fay. In -Car Terminals (External) $170,800 for fleet of CLEMIS agencies; Ai Non Oakland $160,500 due to updated law enforcement Full Time Equivale used for billing; Access Fees Oakland $43,800 and Maintenance Contracts due to higher than anticipated activity. Also fay., Rebilled Charges $21,300; Citation $132,500, Crime Mapping $1,500, CLEMIS Parking $1,000 due to ii usage by Oakland and non -Oakland agencies. Partially offset by unfay. CLE ($162,400) and Parts and Accessories ($5,000) due to decreased activity. 1,527,955.00 1,527,955.00 $ 1,491,855.00 $ (36,100.00) -2 36% Unfay. Service Fees ($187,500) due to staff resources supporting Sheriff pr Partially offset by fav Reimb General $73,800 based on actuals for CLEMIS supporting Sheriff projects; In -Car Terminal $45,900 due to participation co than budget projection and OC Depts Operations $31,700 based on anticipe CLEMIS staff resources supporting Sheriff projects TING REVENUE $ 6,285,656.00 $ 6,285,65600 $ 6,637,756.00 $ 352,100.00 5.60% {PENISES $ 11,693,202 00 $ 11,943,702.00 $ 11,680,902.00 $ 262,800.00 2.20% Fay. Depreciation $323,500 based on depreciation schedule; Internal Servic $253,700 primarily due to IT Development due to usage and Travel $14,20C travel restrictions related to the COVID-19 pandemic. Partially offset by unfE Professional Services ($135,300) due to higher than anticipated contractual staffing services; Indirect Cost ($81, 100) due to actual charges determined finalization; Rebillable Services ($74,700) based on actual connectivity cost! and 3.0 agencies and Software Rental Lease ($37,700) due to less than ant activity. _OSS) BEFORE 2ANSFERS $ (5,407,546.00) $ (5,658,046.00) $ (5,043,146.00) $ 614,900.00 NG REVENUE $ 35,000.00 $ 35,000.00 $ 27,400.00 $ (7,600 00)-21.71% Unfay. Interest Income due to less than anticipated level of rash available ft investments. ( $ 1,644,186.00 $ 1,894,68600 $ 1,894,686.00 $ - 0.00% )UT) $ - $ - $ - $ - 0.00% -RIBUTION $ - $ - $ - $ - 0.00% 2(UNDER) EXP* $ (3,728,360.00) $ (3,728,360.00) $ (3,121,060.00)_ $ 607,300.00 )SITION - BEGINNING $ 14,025,717 67 )SITION- ENDING _$ 10,904,657.67 I in the Adopted Budget (line -item book) this is budgeted as "Planned use of Fund Balance" in the revenue category and Budgeted Equity Adj in Expenses. ADOPTED AMENDED BUDGET BUDGET chnology - Radio Communications (53600) EVENUES: rT (VLT rIKDI UUHK I CKKLYUKI INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY FY 2020 VARIANCE FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 9,265,600 00 $ 9,265,600.00 $ 8,331,300.00 $ (934,300.00)-10.08% Unfay. E911 Surcharge ($907,700) due to volume of users/receipt of 911 s and Outside Agencies Revenue ($26,600) due to higher non -emergency ag, — anticipated. $ 491,828 00 $ 491,828.00 $ 452,628.00 $ (39,200.00) TING REVENUE $ 9,757,428.00 $ 9,757,428.00 $ 8,783,928.00 $ (973,500.00) (PENSES $ 6,426,025.00 $ 6,426,025.00 $ 7,065,025.00 $ (639,000.00) _OSS)BEFORE 2ANSFERS $ 3,331,40300 $ 3,331,403.00 $ 1,718,903.00 $ (1,612,500.00) NG REVENUE )UT) $ 300,000.00 $ 300,000.00 $ $ - $ 14,500.00 $ $ (286,000.00) $ (300,500.00) $ -T97% Unfay. due to Parts and Accessories ($58,900) due to lower than anticpatec reimbursement by participating agencies for equipment replacement and ( fay. Producive Labor $10,100 due to Mobile Data Computer repairs for Oak Agencies and Leased Equipment $9,600 due to lower than anticipated non -I users. 9.98% -9.94% Unfay. Other Expendable Equipment ($501,200) for equipment replacement Expense ($317,600); Utilities ($153,300), Tower Charges ($75,800) and Sul ($7,800) due to usage. Depredation (545,300) based on depreciation sched Partially offset by fav Parts and Accessories $250,300; Internal Services $ primanly due to Info Tech CLEMIS based on usage and Software Support 1u $60,000 due to timing of Emergency Services IP Network Project and Trave due to travel restrictions related to the COVID-19 pandemic. 264,900.00 $ (35,100.00) -1170% - $ (14,500.00) 0.00% (286,000.00) $ 14,500.00 0.00% Unfay. Interest Income due to less than anticipated level of cash available fc investments. 2(UNDER) EXP- $ 3,345,403.00 $ 3,345,403.00 $ 1,697,803.00 $ (1,647,600.00) )SITION- BEGINNING $ 39,691,044.99 )SITION- ENDING $ 441388,847.99 I in the Adopted Budget (line -item book) this is budgeted as "Planned use of Fund Balance" in the revenue category and Budgeted Equity Adl in Expenses. rT LULI rIKJI WUAK I CKKCYVKI INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2020 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT lanagement (53100) EVENUES: $ 283,233.00 $ 283,233.00 $ 298,933.00 $ 15,700.00 TING REVENUES $ 283,233.00 $ 283,233.00 $ 298,933 00 $ 15,700.00 (PENSES $ 1,038,666.00 $ 1,038,666.00 $ 1,056,466.00 $ (17,800.00) _OSS)BEFORE 2ANSFERS $ (755,433.00) $ (755,433.00) (757,533.00) $ NG REVENUE $ 3,000.00 $ 3,000 00 2,600.00 EXPLANATION OF SIGNIFICANT VARIANCES 5.54% Fav primarily due to Participation Fees for Oakland and Non -Oakland Ager 5 54% -1.71% Unfay. Professional Services ($61,900) due to increased activity. Partially o Depreciaton $20,100 based on depreciation schedule and Internal Services primarily due to IT Development (2,100.00) (400.00)-13.33% Unfay. Interest Income due to less than anticipated level of cash available fc investments. J $ 507,699.00 $ 507,699.00 555,810.00 48,111.00 9 48% Fay. due to less than budget anticipated need. )UT) $ - $ - $ - $ - 0.00% -RIBUTION $ - $ - $ - $ - 0.00% 2(UNDER) EXP* $ (244,734 00) $ (244,734.00) (199,123.00) 45,611.00 )SITION- BEGINNING $ 1,670,802.89 )SITION- ENDING $_ 1,471,679.89 at in the Adopted Budget (line -item book) this is budgeted as "Planned use of Fund Balance" in the revenue category and Budgeted Equity Adj in Expenses N 00Mry\\SStON RECREpT\��s 'Ot �pyCtAN�CO p2aDe �ncol�Z�`o �muew��2p2� cd 7lN 3'jg89 a pe rp+9 #r:�'. Gcedd Gatd jp310 uP tO �1,Qp0W.hte it+:: y Ke�\n) Gced then amounts mtsskor`ers Guceton. bb\e, hoard °{ Gom s unco\\ec the tt iris detenns P\\'Note off d oaGomn Ss 0(r aPPrOva\. gervtces pO.r of �iSoak l 1`000 rerdu\re boa Oaktand Coup tope, t e fike {5 to excess °f O reta `y oleGast rep°d' Author\zed by 11261202t °'�3 PM SA O�pR tlncol\eGib\e Deot '- ,- Ge ��NS �SNGp s oONte.00o \NGE B�N�1 %P °P GtDe Amgen 31' 2�2 FR FY 202 C Res " a tJon pdmin`Stc )..�2p21 p aenefs Para on Onc,me es we'av pCOC,e � ../ ° pte, teen oTted to re taTeoyvab\P\\Wr e'oo00heiapeeQoaTdoi s dete mind Fps a\ $es eXGess t SeN\G� P otva of tpe�osn epof sg �Tite °tt ntY Ftsoa off py ) Jape y FO �1$121 OaK�and Gmay be wTT0e with tr )e e Q M9s , NR 2 �oTnTntsappTova\. 6oacd issonefs comet A�notiZed by 86 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Fund (Legacy) Donations - FY 2021 First Quarter September- December 10/1/2020 Teresca Milan 477461 $17.S01 3427371 10/2/2020 Michael Finnerty I 477471 $2.501 343064I 10/2/2020IJanlne Kaznowski 477791 $8.001 343066I 10/2/2020IElise Jones 477801 $50.001 343064 10/2/2020I Edward Hawkins I 477821 $12.50I 343064 10/2/2020 Jack Palmer 478121 $17.501 3430641 10/5/2020 Michael Tilley 478291 $57.50 3430641 10/5/2020ISally Bacon 478341 $100.00 343064] 10/5/2020IMark Mudd 47840 $5.00 3440661 10/5/2020I Kathryn Moody 478431 $2.501 3430641 10/5/2020 Kathryn Moody I 478441 $50.001 3430641 10/6/2020 John Cecil) 478811 $100.001 3433211 10/7/2020I Donation Box 478911 $41.00 3433211 10/8/2020jNancy Harvey I 479211 $75.001 343529I 10/8/2020 Deborah Savalle 479271 $35.001 3435291 10/12/2020 Particia Odonnell 479661 $50.00 3438001 10/12/2020IWIIliam Bond I 479861 $25.00 3438021 10/13/2020IAnne Burns 480091 $20.001 343800 10/14/2020IJacob Kalo ( 48032� $177.001 344148' 10/16/2020Ilames Knibbe 48071 $30.00I 344514 10/19/202011ohn Llittle 48102 $5.001 3445141 10/19/2020 James & Lisa Bannasch 481071 $50.001 - 3445141 10/19/2020 Suzanne Robinson 481081 $40.001 3445141 1D/19/2020 Mary Saple 481091 $300.00' 3445141 10/19/2020I Lori Dushaw 481101 $100.00 3445141 10/20/2020 Petfinder Foundation 48120( $11Z.50 3448901 10/21/20201 Steven Skorski 481491 $27.001 3448821 10/21/2020IJames Smith I 481561 $22.001 3448821 10/21/20201Jolanda Rodriguez 48172] $60.001 3453331 10/22/20201 Cheryl Kozell 481751 $50.00 345331 10/22/2020IDonation Box I 481781 $17.001 3453311 10/23/20201 Mark Crier 481891 $20.001 345333 10/26/2020IStephen Caramagno 482201 $200.00 345615' 10/27/2020IMr. & Mrs. Clay Janssen I 482231 $100.001 3456151 10/28/2020IAnthony Hoff 482521 $3.001 3459061 10/30/2020IAnn Kargetta I ) 482921 $200.001 3459541 - I - - -. Octoher 2020 Total .$2,005.00 6e Ba 11/2/2020 Mark Mudd 48306 $5.00 345954 11/2/2020IElissa StaeubJe 48308]!!] $25.00 345954I 11/2/2020I Robert Wilson 48314I $25.00 345954, 11/2/2_020IDawe Lewandowski I 48316 $75.00 3459541 11/2/2020I Wendell Stringer 483171 $50.00i 3459541 11/2/2020I North Meadows Condo Association I 483181 $35.001 3459541 11/5/20201 Roy Kartakis 483941 $100.001 346211I 11/5/20201 Debra Jett 483901 $25.001 3462091 86 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Fund (Legacy) Donations - FY 2021 First Quarter September- December 11/6/2020 Kim DePalma 48391 $100.00 3464011 11/9/2020 Jackson National Life Ins 48399 $12538.52 3463991 11/10/2020 Cheryl Kozell 48459 $50.00 346654{ 11/10/2020 Michigan State Univ Federal Credit Union 48463 $1967.63 346652111 11/10/2020 MSUFCU & OUCU Desk Drawer Fund 48464 $9950.37 3466521 11/12/2020 Dorothy Kjajenke 48485 $20.00 3466541 11/12/2020 Karen Semaan 48492 $25.00 3466541 11/12/2020 John Fitzgerald 48502 $50.00 3466541 11/12/2020 Robert Barns 48505 $50.00 3466541 11/13/2020 Donation Box 48516 $12.25 3469461 11/13/2020 Bill Alliston 48520 $100.00 3469461 11/13/2020 Kimberly Zazula 48523 $50.00 3469461 11/13/2020 Serena Bianchi 48530 $2.50 3469441 11/13/2020 Ginny Wright 48534 $27.00 346946 11/16/2020 John Little 48545 $5.00 346944 11/16/2020 John Schmidt 48550 $100A0 346944 11/16/2020 Gail Bowser 49552 $50.00 3469461 11/16/2020 Chet Fenlon 48553 $20.00 3469441 11/16/2020 North American Lighting 48554 $528.00 346944 11/16/2020 Patricia McBride 48556 $50.00 346944 11/16/2020 Rachar Rachar 48557 $60.00 3469441 11/17/2020 Kathleen Salathiel 48583 $100.00 3469441 11/17/2020 Jordan Nizza 48600 $42.50 3471501 11/18/2020 Lucy Doty 49603 $57.00 3471521 11/20/2020 David Abbott 48641 $10.00 347326 11/20/2020 Jack &Joyce Dolcourt 48655 $50.00 347324 11/20/2020 Sean Coleman 48661 $21.00 3473261 11/20/2020 Jamie Fenner 48666 $50.00 3473241 11/23/2020 Seema Terry 48681 $500.00 3473261 11/24/2020 Samantha Maki 48702 $27.00 3474231 11/27/2020 Nicole Miller (online) 48746 $5.00 3475391 11/27/2020 Robert Fisher (online) 48748 $0.64 347783 11/29/2020 Angela Kundmger (online) 48750 $0.47 347938 11/29/2020 Lisa DiVito (online) 49752 $0.18 347938 11/29/2020 Connor O'Leary (online) 48753 $0.18 347938 11/30/2020 Mark Mudd 48759 $5.00 347563 11/30/2020 Elissa Staeuble 48764 $25.00 3475631 11/30/2020 Jennifer Truitt 48769 $25.00 347563, 11/30/2020 Nick LaGarde(online) 48775 $0.18 347986 11/30/2020 Angela Coffman (online) 48781 $0.64 3479861 11/30/2020 Donation Box 48782 $4.00 3475651 11/30/2020 Mihalich Charitable Foundations 48791 $1000.00 3475631 November V, 20 Total' Donation Box 488031 $12.90 347719l Laurel Bissinger 498331 $0.64 3479871 Tom Gaydos 488351 $5.00 3479871 87 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2021 First Quarter September- December 12/1/2020 Holly Llewellyn 488361 yu.8t s4"81 12/2/2020 Julia Fallis 488491 $20.00 347717 12/2/2020 Roe Green 488671 $150.00 3477191 12/2/2020 Margaret Rosenthal 488701 $17.00 3479071 12/2/2020 Gabriele Sandhaus 48873' $0.46 3471191 12/2/2020 Sarah Miller/Erik Stillwell 48877 $5.00 347819 12/3/2020 Meghan Enders 48889 $0.64 3477601 12/3/2020 Neil Krohn 48899 $20.00 3477601 12/3/2020 Mahesh Jalukuri 48905 $0.46 34776011 12/3/2020 Traci Hynes 48911 $50.00 3479051 12/3/2020 William Davey 49914 $10.00 347760i 12/3/2020 Nicole Roofner 48917 $0.18 3477601 12/4/2020 Fred Nuttall 48923 $180.00 347905] 12/4/2020 Dean & Nina Googasian 48924 $150.00 3479051 12/4/2020 Aimee Neikart 48927 $0.64 3478771 12/4/2020 Cathleen LaLonde 48939 $10.00 3477751 12/4/2020 Jacqueline Sloan 48963 $10.00 3478771 12/5/2020 Steven Siko 48969 $10.00 3480261 12/5/2020 James Godden 48970 $5.00 3480261 12/5/2020 Jennifer Tanner 48971 $0.18 3480261 12/5/2020 Max McCain 48976 $0.64 3480261 12/5/2020 Brian Penney 48977 $20.00 3480261 12/5/2020 Sarah Reese 48978 $1.46 3480261 12/5/2020 Lisa Graff 49985 $10.00 3479881 12/7/2020 Daniel Riegel 48979 $0.18 3479951 12/7/2020 Sua Choi 48995 $0.18 3479951 12/7/2020 Mary Bournias 48996 $5.00 3479951 12/7/2020 Ann St Germaine 48997 $5.00 3479951 12/7/2020 Leslie Wilson 49007 $5.00 3479951 12/7/2020 Katie Washko 49025 $0.64 3479951 12/7/2020 Alfredo Reyes 49031 $2.50 3480611 12/7/2020 Timothy Gilbert 49037 $0.46 3479951 12/8/2020 Jean Wilbanks 49042 $0.64 348025 12/8/2020 Annette Lindsay 49043 $20.00 348025 12/8/2020 Megan Koch 49051 $5.00 348025 12/8/2020 Jesse Pifko 49056 $0.18 348025 12/8/2020 Jenica Topp 49057 $5.00 3480251 12/8/2020 Peyton Schmid 49060 $0.18 3480251 12/8/2020 Sean Foley 49067 $5.00 3480251 12/8/2020 Lisa Cook 49072 $0.64 3490251 12/8/2020 Marjorie Frazier 49079 $20.00 3480611 12/8/2020 Michael Quinlan 49085 $20.00 3480251 12/8/2020 Tara Saldana 49092 $5.00 3480961 12/8/2020 Livia Walker 49094 $10.00 3480251 12/9/2020 Elizabeth Gets 49111 $0.18 3480961 12/9/2020 Julie Cetlinski 49122 $5.00 3480961 12/9/2020 Nicholas Wilson 49135 $0.64 3480961 12/9/2020 Heather Brzezinski 49139 $195.00 3482441 12/9/2020 Anna Abromovich 49144 $0.18 3480961 88 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2021 First Quarter September- December 12/9/2020 Ravi Bhattiprolu 49152 $10.001 3480961 12/10/2020 Angus Mackay 4915C $20.181 3482071 12/10/2020 Darlene Myers 49157 $100.001 3482441 12/10/2020 Jennifer Day 49167 $40.001 3482441 12/10/2020 Jennifer Meyers 49171 $5.001 348207I I 12/10/2020 Ashley Malewski 49184 $0.641 348207I 12/10/2020 Barb Rogers 49185 $0.46 3482071 12/10/2020 Jerami King 49198 $5.00 3482071 12/10/2020 Edward Peters 49205 $10.00 3482071 I 12/11/2020 Jessica King 49211 $5.00 3492881 12/11/2020 Verne Vackaro 49217 $500.00 3483921 I 12/11/2020 Tiana Clemons 49228 $1.46 3482881 12/11/2020 Mike Gaff 49229 $100.00 348390I 12/11/2020 Cynthia Dunn 49232 $0.96 3482881 12/11/2020 Jim Nardecchia 49239 $50.00 3482881 12/11/2020 Richard Lyyski 49240 $50.00 348390I I 12/11/2020 Diana Bowes 49255 $65.00 3483901 I 12/11/2020 Dagmar Henn 49264 $0.64 3482881 12/11/2020 Autumn Netter 49265 $0.46 3482901 12/12/2020 Backe Forbes 49258 $5.00 3482901 12/12/2020 Michael Schuster 49268, $5.00 3492901 12/12/2020 Ramkrishna Bhat 49275 $1.00 3482901 12/12/2020 Kathleen Gorski 49277 $10.00 3482901 12/12/2020 Eva Ames 49283 $0.54 3482901 12/13/2020 A Belme-Kennedy 49289 $20.00 3482921 12/13/2020 Kate Richardson 49289 $0.64 3482921 I 12/13/2020 Joy Lucas 49294 $0.64 3492921 12/14/2020 Stephanie Jordan 49295 $0.28 3414211 12/14/2020 Preetha Ravtkumar 49296 $0.46 348425 I 12/14/2020 Sarah McCarthy 49298 $5.00 348425 12/14/2020 Lonna Huynh 49306 $0.18 348425 12/14/2020 Tom Pavelich 49320 $5.00 348425 I 12/14/2020 Susan McGraw-Mangner 49328 $300.00 3483921 12/14/2020 ]an Siekkinen 49330 $10.00 3484251 12/15/2020 Kimberly Noble 49349 $10.00 3492791 12/15/2020 Barbara Fritsch 49357 $5.00 3492791 12/15/2020 Alex Nelson 49362 $5.64 3492791 12/15/2020 Linda Pohutski 49364 $5.00 3492791 12/15/2020 Linda Pohutski 49365 $5.00 3492791 12/15/2020 Anna Dew 49368 $0.18 3492791 I 12/15/2020 David Parmann 49371 $3.00 3492791 12/15/2020 Gary August 49377 $0.64 3492791 12/15/2020 Dennis Mirku 49380 $250.00 3485461 I 12/15/2020 John Little 49382 $5.00 3485461 12/15/2020 Paula Phillis 49387 $100.00 3492791 12/15/2020 Terri Medor 49392 $5.36 349279 12/15/2020 Kevin Salisbury 49397 $0.46 349279 12/15/2020 Nikki Spencer 49401 $5.00 3492791 12/16/2020 Amy Lalich 49404 $5.00 3492791 89 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER lRestricted Fund (Legacy) Donations - FY 2021 First Quarter September- December 12/16/2020 Howard Sikora 49405 $100.00 3485461 12/16/2020 Ramona Nave 49406 $1400.00 3485461 12/16/2020 Cecelia Whapham 49407 $200.00 3485461 12/16/2020 Elizabeth Purdy 49408 $5.50 3485461 12/16/2020 Jeff Perry 49409 $0.46 3492791 12/16/2020 Donation Box 49424 $91.75 3485481 12/16/2020 Angelina Bracey 49450 $0.28. 3492791 12/16/2020 Rachel Baril 49451 $10.00 3492791 12/16/2020 Nancy Morrow 49454 510.00 3492791 12/17/2020 Rich Byczek 49452 $5.00 3492791 12/17/2020 Matt Yessian 49461 $0.64 3492791 12/17/2020 Debbie Vernest 49467 $100.00 3487191 12/18/2020 Kevin Congdon 49490 $10.00 3492791 12/18/2020 Erin Kaplan 49501 $250.00 3487211 12/18/2020 Fred Parsons 49510 $5.00 3492791 12/18/2020 Kathleen Baker 49511 $20.00 3492791 12/18/2020 Mark Schlebold 49517 $1.46 3492791 12/18/2020 Frederick Nestrock 49518 $25.00 3487191 12/18/2020 Birmingham Bloomfield Credit Union 49519 $311.44 3487191 12/18/2020 Paula Heisler 49520 $150.00 3487191 12/18/2020 Debra Brown 49523 $57.50 3487191 12/18/2020 Damien Coleman 49528 $0.64 349279 12/19/2020 Janice Harding 49542 $10.00 3492791 12/21/2020 Matthew Hanson 49557 $5.00 349279 12/21/2020 Bailey Ernst 49566 $0.46 3492791 12/21/2020 David Trott 49572 $150.00 3487931 12/21/2020 Judy Moschet 49574 $10.00 3492791 12/21/2020 Patty Dolengowski 49578 $10.00 3492791 12/21/2020 Clifford Harrell 49582 $50.00 3487951 12/21/2020 Steven Keller 49584 $100.00 3487931 12/21/2020 Kevin Phillips 49600 $25.00 3488851 12/21/2020 Enrique Palomares 49773 $0.47 3492791 12/21/2020 Nicholas McGowan 49775 $0.18 3492791 12/27/2020 Kristin Kozlowski 49777 $0.18 3492811 12/21/2020 Rebecca Denton 49794 $0.64 3492791 12/21/2020 Andrew Seurynck 49801 $5.18 3492791 12/21/2020 Dave Dork 49804 $0.46 3492811 12/22/2020 Sarina Nailamothu 49807 $0.46 3492811 12/22/2020 Johanna Slanga 49810 $5.00 3492811 12/22/2020 Lana Ton 49811 $4.00 3491381 12/22/2020 Howard Cutler 49815 $20.00 3492811 12/22/2020 Nicole Betzler 49820 $0.64 3492811 12/23/2020 Todd Heimler 49647 $100.00 3488951 12/23/2020 Elisangela Previte 49657 $200.00 3488851 12/23/2020 Jennifer Allen 49838 $50.00 3492811 12/23/2020 Michael Peri 49841 $10.00 3492811 12/23/2020 Christopher Mucke 49850 $0.64 3492811 12/23/2020 Christopher Mucke 49851 $0.47 3492811 12/23/2020 Jeremy Newth 49852 $15.00 3492811 90 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2021 First Quarter September- December 12/23/2020 Tim Eeuby 12/23/2020 Craig Huddleston 12/23/2020 Kristopher Westley 12/24/2020 Steven Petty 12/24/2020 Jamie Fenner 12/24/2020 Keith Reid 12/24/2020 Brandon Mason 12/28/2020 Ana Haduck 12/28/2020 Glenn Briggs 12/28/2020 Jennifer Sais 12/28/2020 Michele Wilson 12/29/2020 Tessa Clardy 12/28/2020 Erika Jefferson 12/29/2020 Kathy Reno 12/29/2020 Karan)it Soh! 12/29/2020 Jayne Cale 12/29/2020 Carlton Stauss 12/29/2020 Cristln Spille 12/29/2020 Jill McBeth 12/29/2020 Bridget Millar 12/29/2020 Lorinda Kingins 12/29/2020 Cecilia Brown 12/29/2020 Ivana Vaughn 12/30/2020 Kevin Phillips 12/30/2020 Donation Box 12/30/2020 Dawn Galbraith 12/30/2020 Charles Durst 12/30/2020 Vicki Zaroukian 12/30/2020 Kelley Stramaglia 12/30/2020 Thomas Pecheniuk 12/31/2020 James Scott Moseley 12/31/2020 Jane] Edwards 12/31/2020 Carly Snyder 12/31/2020 Virginia Niewoehner 49857 49859 49694 49707 49865 49870 49868 49905 49917 49983 49985 49988 50006 50017 50022 50032 50044 50125 50128 50132 50139 50142 50079 50080 50125 50148 50150 50153 50156 50118 50174 50177 50195 $0,18 $0.18 $60.00 $25.00 $5.00 $0.18 $0.18 $5.00 $5.00 $5.00 $0.64 $0.46 $5.00 $0.18 $0.64 $177.00 $0.18 $0.64 $4.18 $4.18 $0.96 $10.00 $50.00 $58.00 $0.64 $0.96 $0.82 $10.00 $0.18 $20.00 $20.00 $0.46 $14.18 Deeemig r,2020 Total - - - Q1 FY'2021 Total 3492811 3492811 3492191 3492191 3492811 3492811 3492811 3492811 3492811 3492,811 3492811 349219 1 3491381 349219111 I 1 1 1 '$5r550:55 $36,575.61 91 Department of Public Services Oakland County Children's Village Donation Tracking : Donation Period October 2020 - December 2020 Date: Donor: Cash/Check: Items: Estimated Value: University Presbyterian Church Frozen Birthday Cakes (3) Months $495.00 10/1/2020 OCCVF Personal Radios $683.06 10/2/2020 OCCVF Volleyball Trainingfor Resident $90.00 10/5/2020 Maira Danna Yarn $20.06 10/20/2020 Melissa Reid Yarn and Craft Items $50.00 11/17/2020 Senior Men's Club of Birmingham Check $3,601.00 11/20/2020 OCCVF 72 Earbuds $76.00 11/23/2020 St. Mary of The Hills Coats $600.00 11/23/2020 OCCVF Coats/Hats $3,475.22 11/26/2020 Marie Crimaldi Clothing $15.06 12/1/2020 Sweet Dreams (15) Pillow Cases $225.00 12/1/2020 Ann Williams Group Craft Kits $980.06 12/2/2020 T. Guzzy Clothing $10.00 12/2/2020 OCPO Backpacks, Lunch Boxes, T-Shirts $750.00 12/2/2020 Brandon School District Books $50.00 12/4/2020 St. Mary of The Hills Gift Cards $1,320.00 12/4/2020 St. Anne Church Quilts,Gloves,Socks,Games,Gift Cards $500.06 12/7/2020 OCCVF Drive Thru Holiday Light Show $100.00 12/8/2020 Kirk In The Hills (12) Backpacks $240.06 12/9/2020 Pam Dorris (20) Doz Cookies $120.00 12/10/2020 Christ Church of The Redeemer Clothing, Sporting Goods & Games $750.00 12/10/2020 Lennon Caruso Jeans $6,000.00 12/10/2020 OCCVF Craft Supplies $1,200.00 12/11/2020 K. Smith Socks, Granola Bars, Soap $50.00 12/11/2020 The Well of Waterford Art Activities $1,000.00 12/11/2020 Prince of Peace -Youth Ministry Gift Card, Slippers,Games, & Candy $250.00 12/11/2020 St. William Parish Gift Card, Slippers,Games, & Candy $250.06 92 Department of Public Services Oakland County Children's Village Donation Tracking : Donation Period October 2020 - December 2020 Date: Donor: Cash/Check: Items: Estimated Value: 12/14/2020 St. Patrick Parish Swe atshi rts,Socks, Bas ketba lls, Food $300.00 12/14/2020 Our Lady of The Snows Games,Snacks,Gift Card $150.06 12/14/2020 St. Daniel Church Games,Snacks,Gift Card $150.00 12/14/2020 B. Gaida Clothes, Games, Toiletries $150.06 12/14/2020 OCCVF Popcorn $74.88 12/14/2020 Christ Church of Cranbrook Toys and Gifts $1,000.00 12/14/2020 United Way Amazon Code - MP Sensory Room $250.0c 12/16/2020 Our Lady of Refuge Sweatshirts,Games,Snacks,Gift Card $250.06 12/16/2020 L. Fish Puzzles and Action Figures $45.00 12/17/2020 B. Larsen Toys and Clothing $15.00 12/18/2020 OCCVF Coats $120.00 12/18/2020 Marie Crimaldi Clothing $5.00 12/21/2020 K. McBroom Books $250.Oc 12/21/2020 L. Simon (8) Pumpkin Pies & (5) Cool Whips $100.00 12/21/2020 L.Cadreau (47)Paperbacks $300.Oc 12/21/2020 S. Ross Coats & Hoodies $30.06 12/21/2020 OCCVF Mt. Holly Gift Card for Resident $250.06 12/22/2020 S. Boyd Toys and Books $5.00 12/22/2020 K. Desantos Toiletries $300.06 12/22/2020 Mt. Zion Church Radios, Earbuds, Coats and Toiletries $500.00 12/23/2020 S. Gupta/Rebuild Rochester Toiletries, Clothes, Puzzles, and Radios $500.O6 12/23/2020 Kicks for Kids New Nike Shoes MP Residents $720.06 TOTAL $28,365.16 93 Form DC-001 OAKLAND COUNTY MEMORANDUM WATER RESOURCES COMMISSIONER TO: Department of Management and Budget, Fiscal Services FROM: Kelsey Cooke, Legal Counsel SUBJECT: Gift Donation to WRC DATE: January 8, 2021 This office has received a gift donation from Argus Industrial Co., LLC, 16 West Huron Street, Pontiac, Michigan, 48342, by Al Skoropa, in the amount of $5,400 paid to O.C. W.R.C. via check number 25820 dated December 29, 2020, with no match requirement or other financial implication to Oakland County. Mr. Skoropa's purpose for the gift donation is to assist residents in the City of Pontiac with past -due water bills owed to the WRC to ensure they do not have their water service shut off or face other collection methods for non-payment. Mr. Skoropa has agreed to defer to the work and discretion of Commissioner Nash and his staff to provide the information required to identify households in need, to consider the amount of the arrearage and the length of time the account is past due, and the total amount of the gift for households identified to be in need. He understands that to make a significant impact for residents in need, the donation may not affect every resident in need. The WRC will use the donation money solely for the purpose of paying identified past due water bills, will notify the selected residents of the gift, and will prepare a report for Mr. Skoropa upon completion of applying the donation funds listing the service addresses benefited and the amount of the monetary benefit for each. Please report this donation with the FY2021 Q I forecast resolution in accordance with Miscellaneous Resolution #83204, OAKLAND COUNTY WATER RESOURCES COMMISSIONER Page 1 of 1 Rev.: 11/05/08 94 l'AJ.'1►4w.'wIw1k11y1NIlk 1 � i I it 1,�= OAKLAND COUNTY PARKS & RECREATION COMMISSION AGENDA MARCH 3, 2021 AGENDA ITEM No. FOR ADMIN'S USE PLANNING &RESOURCE DEVELOPMENT To: Chairman McGillivray and Commission Members From: Daniel J. Stencil, Executive Officer Melissa Prowse, Supervisor of Planning & Resource Development Submitted: March 4, 2021 Subject: FY 2021 1st Quarter Contributions Report INTRODUCTION AND HISTORY Attached is the FY 2021 15t Quarter report for contributions received from October 1, 2020 through December 31, 2020. ATTACHMENTS FY 2021 1st Quarter Contributions Report STAFF RECOMMENDATION Staff recommends the Commission receive and file the FY2021 151 Quarter Contributions Report. MOTION Move to receive and file the FY 2021 1st Quarter Contributions Report. 95 Paky l of i Out Account #: - COMPANIES, INC. jgndotCodv- SNE► SON SNEW©N OOMPASH S 1N to pd� ND COUNT ERIFF Re tion Remy pm0uatFaid R - 0,00 Cpaoiainscoms J� _ �' . PedbY- OAI�-A - 328962 idto:- piscount 2y00.00 Chack: 10t01t20 Inv. Amount 0.00 mow' 2150000 IobNum' - 2y00.00 0.00 Amount: Invoice No. CORPS 0.00 ?5 00 (v tiAPIptiNS 2 y00.00 O9t16120 � eck?is ' 1 .f • . - Ox pFCNO- y_r`� �Y pSEN,ENT A�aoUNt oAT� 3 gg62 Benue �t� 3289�2 te p�le5.t ..(Attt �1 APVWAi1M' - -UI50 _ - - gotW WAyg2ga ..2,y00.00 V9oolleY, , t 100 OOISP RS' NUNpREp ANp 4tNC j OIiSA�p Five ON COi,1PANFS, "Twotti PAY- .� OOUNTY SHEIvppARO OAKLSANpNp MICHAE4 A 0 oEa PONP�E�- - l 1 1 OAKLAND COUNTY PARKS & RECREATION COMMISSION FY 2021 1Q Report for Contributions (Donations) - October 1, 2020 - December 31, 2020 ADM Contribution - General Lawrence Larson $100.00 ADM Contribution - General Twelve Oaks Mall LLC $500.00 IND Contributions- Comemmorative Program Helga Weber $1,000.00 R ecreatwriProgramsar�dSernces dotal .'. $1,b00:00 Grand Total $1,600.00 V111 Resolution #21091 March 25, 2021 Moved by Weipert seconded by Luebs the resolutions on the amended Consent Agenda be adopted. AYES: Charles, Gershenson, Gingell, Hoffman, Jackson, Joliet, Kochenderfer, Kowall, Kuhn, Long, Luebs, Markham, McGillivray, Miller, Moss, Nelson, Powell, Spisz, Weipert, Woodward, Cavell. (21) NAYS: None. (0) A sufficient majority having voted in favor, the resolutions on the amended Consent Agenda were adopted. I HEREBY APPROVE THE FOREGOING RESOLUTION STATE OF MICHIGAN) COUNTY OF OAKLAND) I, Lisa Brown, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true and accurate copy of a resolution adopted by the Oakland County Board of Commissioners on March 25, 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 this 251h day of March 2021. Lisa Brown, Oakland County