The URL can be used to link to this page

Home My WebLink AboutResolutions - 2022.02.24 - 35319• BOARD OF COMMISSIONERS February 24, 2022 MISCELLANEOUS RESOLUTION #22-048 Sponsored By: Kristen Nelson IN RE: Human Resources - Resolution for the Transfer of Positions and Deletion of the Central Services Department and for the Creation of Performance Management Positions Chairperson and Members of the Board: WHEREAS the County Executive will implement a performance management system to develop a strategic framework that focuses on both the external and internal efforts to better meet the needs of County residents; and WHEREAS each County Executive department will be required to establish department level and service level goals, including Key Performance Indicators (KPI); and WHEREAS the County Executive is requesting to create two (2) GF/GP Full Time Eligible positions to provide key support for data reporting, analysis, measurement, and general assistance in meeting KPI goals; total cost for FY 2022 $112,746 (prorated) and FY 2023 — FY 2024 $193,279; and WHEREAS the County Executive is requesting to create one (1) GF/GP Part Time Non -Eligible Project Advisor position to serve on the Airport and Parks & Recreation committees, total cost for FY 2022 is $21,337 (prorated) and for FY 2023 — FY 2024 $36,577; and WHEREAS the cost to create these positions will be offset by deleting the Director Central Services position; FY 2022 ($156,931) prorated and FY 2023 — FY 2024 ($269,025), a savings of $22,848 for FY 2022 and $39,169 for FY 2023 - FY 2024; and WHEREAS the savings from position changes will be used towards the operating support for the performance management positions for ongoing costs, such as computers, telephones, supplies, training, and software; total operating costs for FY 2022 are $21,550 (prorated) and for FY 2023 — FY 2024 $26,940; and WHEREAS the overall savings for FY 2022 is $1,298 (prorated) and for FY 2023 — FY 2024 $12,229. NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners approves to create the following new classifications: Classification Salary Plan Grade Merit Status FLSA Status Strategic Management Coordinator UNI 125 Merit Performance Management Data Analyst UNI 113 Merit BE IT FURTHER RESOLVED to create the following GF/GP positions: # Pos Status Classification FTE Strategic Management Coordinator FTE Performance Management Data Analyst PTNE 1,000 hours per year Project Advisor BE IT FURTHER RESOLVED to delete the Director Central Services position (#1030101-01499). Exempt Non -Exempt Dept/Div # 1010101 1010101 1010101 BE IT FURTHER RESOLVED to transfer the Support Services Division, and the following positions, from the Central Services Department to the Facilities Management Department, Support Services Division: From Dept # Position # Classification To Dept # 1030801 P00007373 Manager Support Services 1040201 1030803 P00001863 Office Supervisor11 1040201 1030801 P00002251 Office Support Clerk Senior 1040201 1030811 P00002735 Chief Support Services 1040210 1030803 P00000012 Mail & Distribution Clerk 1040202 1030803 P00000181 Record Retention Specialist 1040202 1030803 P00001463 Auction Coordinator 1040202 1030803 P00002023 Office Support Clerk Senior 1040202 1030803 P00002768 Mail & Distribution Clerk 1040202 1030803 P00002885 Mail & Distribution Clerk 1040202 1030803 P00005612 Office Support Clerk 1040202 1030803 P00007050 Office Leader 1040202 1030803 P00007168 Office Support Clerk Senior 1040202 1030803 P00007169 Office Support Clerk Senior 1040202 1030803 P00011189 Mail & Distribution Leader 1040202 1030803 P00011970 Mail & Distribution Leader 1040202 1030803 P00014471 General Helper 1040202 1030803 P00014472 General Helper 1040202 1030803 P00015426 General Helper 1040202 1030811 P00001067 Automobile Mechanic 1040210 1030811 P00001141 Garage Services Coordinator 1040210 1030811 P00001520 Automobile Mechanic II 1040210 1030811 P00001821 Automobile Mechanic Senior 1040210 1030811 P00002168 Automobile Mechanic Senior 1040210 1030811 P00002270 Garage Supervisor 1040210 1030811 P00002291 Automobile Mechanic II 1040210 1030811 P00002818 Automobile Mechanic Senior 1040210 1030811 P00002936 Communications Installer II 1040210 1030811 P00009267 Communications Installer II 1040210 1030811 P00009790 Automobile Mechanic 1 1040210 1030811 P00010479 Automobile Mechanic 1 1040210 1030811 P00011082 Automobile Mechanic 1 1040210 1030811 P00011468 Communications Installer II 1040210 1030811 P00011597 Garage Supervisor 1040210 1030811 P00011650 Financial Services Technician 111 1040210 1030811 P00012111 Garage Attendant 1040210 1030811 P00014523 General Helper 1040210 1030811 P00014524 General Helper 1040210 BE IT FURTHER RESOLVED to transfer the Aviation & Transportation Division, and the following positions, from the Central Services Department to the Economic Development Department Airport and Aviation Division. From Deot # Position # Classification To Dept # 1030701 P00002399 Manager Aviation & Transportation 1090501 1030701 P00000576 Airport Maintenance & Rescue Specialist 1 1090501 1030701 P00000580 Airport Operations Specialist 1090501 1030701 P00001559 Airport Maintenance & Rescue Specialist III 1090501 1030701 P00002187 Chief Airport Maintenance & Operations 1090501 1030701 P00002285 Airport Maintenance & Rescue Specialist I I 1090501 1030701 P00003035 Airport Maintenance & Rescue Specialist I I 1090501 1030701 P00003215 Airport Maintenance & Rescue Specialist I I 1090501 1030701 P00003291 Airport Maintenance & Rescue Specialist I I 1090501 1030701 P00003315 Airport Maintenance & Rescue Specialist I I 1090501 1030701 P00003509 Airport Maintenance & Rescue Specialist I I 1090501 1030701 P00003520 Airport Maintenance & Rescue Specialist I I 1090501 1030701 P00003634 Airport Maintenance & Rescue 1090501 Supervisor 1030701 P00004034 Laborer 1090501 1030701 P00004035 Laborer 1090501 1030701 P00004336 Laborer 1090501 1030701 P00004337 Laborer 1090501 1030701 P00004338 Summer Business Assistant 1090501 1030701 P00004448 Laborer 1090501 1030701 P00005614 Airport Maintenance & Rescue Specialist 11 1090501 1030701 P00006082 Financial Services Technician 11 1090501 1030701 P00007353 Office Support Clerk Senior 1090501 1030701 P00007780 Airport Maintenance & Rescue Specialist 11 1090501 1030745 P00010492 Airport Station Operator 1090502 1030745 P00010493 Airport Station Operator 1090502 1030745 P00010494 Airport Station Operator 1090502 1030745 P00010495 Airport Station Operator 1090502 1030750 P00010769 Airport Station Operator 1090503 1030750 P00010770 Airport Station Operator 1090503 1030750 P00010771 Airport Station Operator 1090503 1030701 P00010772 General Helper 1090501 1030701 P00012090 Maintenance Laborer 1090501 1030750 P00012179 Maintenance Laborer 1090503 1030701 P00012398 Airport Maintenance & Rescue Specialist 11 1090501 1030701 P00014546 Airport Administration Specialist 1090501 1030701 P00015348 Maintenance Laborer 1090501 BE IT FURTHER RESOLVED to delete the Central Services Department and subordinate division numbers (1030xxx). BE IT FURTHER RESOLVED to amend the FY 2022-FY 2024 Budgets as shown in the attached Schedule A. BE IT FURTHER RESOLVED that because of the timing of the reorganization during the fiscal year, additional clean up amendments may be required with subsequent FY 2022 quarterly forecast resolutions for the movement of operations between departments. Chairperson, the following Commissioners are sponsoring the foregoing Resolution: Kristen Nelson. 1 David Woodward, Commissioner OWL au L Hilarie Chambers, Deputy County Executive II k Lisa Brown, County Clerk / Register of Deeds Date: February 25, 2022 Date February 28, 2022 Date: March 01, 2022 COMMITTEE TRACKING 2022-02-08 Legislative Affairs & Government Operations - recommend and forward to Finance 2022-02-09 Finance - recommend to Board 2022-02-24 Full Board VOTE TRACKING Motioned by Commissioner Kristen Nelson seconded by Commissioner Michael Gingell to adopt the attached Resolution: for the Transfer of Positions and Deletion of the Central Services Department and for the Creation of Performance Management Positions. Yes: David Woodward, Michael Gingell, Michael Spisz, Karen Joliat, Kristen Nelson, Eileen Kowall, Christine Long, Philip Weipert, Gwen Markham, Angela Powell, Charles Moss, Marcia Gershenson, William Miller III, Yolanda Smith Charles, Charles Cavell, Penny Luebs, Janet Jackson, Gary McGillivray, Robert Hoffman (19) No: Thomas Kuhn (1) Abstain: None (0) Absent: (0) The Motion Passed. ATTACHMENTS 1. Schedule A - Budget Amendment 2. MEMO - Central Services Reorg and Stat positions 3. WRITE UP - Performance Management & Central Services 4. Job Description - Performance Mgmt Coordinator 5. Job Description - Performance Mgmt Data Analyst 6. Job Description - Project Advisor 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 February 24, 2022, with the original record thereof now remaining in my office. In Testimony Whereof, I have hereunto set my hand and affixed the seal of the Circuit Court at Pontiac_, Michigan on Thursday, February 24, 2022. Lisa Brown, Oakland Counh) Clerk % Register of Deeds Oakland County, Michigan COUNTY EXECUTIVE —TRANSFER OF POSITIONS AND DELETION OF CENTRAL SERVICES DEPARTMENT AND CREATION OF PERFORMANCE MANAGEMENT POSITIONS Schedule "A" DETAIL - GENERAL FUND - CENTRAL SERVICES ADMIN I COUNTY EXECUTIVE tin, I Fund Budget Prcixal FY 2022 FY 2023 FY 2024 R)E Fund Name Division Name FundN Division III _Pro ramif g IOperf AccountN Unit OU Affiliate Reference Unit Prcect# I I 1 Activi Anal sisL I ty Y Account Title Amendment Amendment Amendment R General Fund Non -Department 10100 9010101 196030 665882 Planned Use of Balance $ (7,034.00) $ (22,461.00) $ - Total Revenue $ ((,034.UU) $ (22,4bl.UU) $ - E General Fund Central Services Admm 10100 1030101 184000 702010 Salaries Regular $(110,473.00 S (189,383.00) $(189,383.00) E General Fund Central Services Admin 10100 1030101 184000 722750 Workers Compensation (121.00 (208.00) (208.00) E General Fund Central Services Admin 10100 1030101 184000 722760 Group Fife (239.00 (4%00) (410.00) E General Fund Central Services Admin 10100 1030101 184000 722770 Retirement (30,61700 (52,486.00) (52,486.00) E General Fund Central Services Admin 10100 1030101 184000 722780 Hospial¢ation (6,276.00 (10,762.00) (10,762.00) E General Fund Central Services Admin 10100 1030101 184000 722790 Social Security (6,76T00 (11,600.00) (11,600.00) E General Fund Central Services Admin 10100 1030101 184000 722800 Demal (529.00 (906.00) (906.00) E General Fund Central Services Admin 10100 1030101 184000 722810 Disability (1,743.00, (2,98800) (2,988.00) E General Fund Central Services Admin 10100 1030101 184000 T22820 Unemployment Insurance (110.00) 1189.00) (189.00) E Geneml Funtl Central Services Armin 10100 1030101 184000 722850 Optical (54.00) (9200) (92 00) E General Fund Central Services Admm 10100 1030101 184000 731213 Membership Dues (117.00) 1200.00) (200.00) E General Fund Central Services Admin 10100 1030101 184000 731S16 Personal Missed (68.00) (116.00) (11600) E General Fund Central Services Admin 10100 1030101 184000 732018 Travel and Conference (1,456.00) (2,500.00) 12,500.00) E General Fund Central Services Admin 10100 1030101 184000 750392 Metered Postage (281.00) (482.00) (482.00) E General Fund Central Services Adorn 10100 1030101 184000 770631 Bldg Space Cost Allocation (3,619.00) (6,601.00) (6,649.00) E General Fund Central Services Admin 10100 1030101 184000 774677 Insurance Fund (193.00) (33500) (333.00) E General Fund County Executive Admin 10100 1010101 181000 702010 Salaries Regular 93,609.00 160,472-00 160,472,00 E General Fund County Executive Admin 10100 101D101 181000 722900 Fringe Benefit Adjustments 40,474.00 69,385.00 69,38500 E General Fund County Executive Admin 10100 1010101 181000 750399 Office Supplies 2,000.00 2,000.00 2,000.00 E General Fund County Executive Admin 10100 1010101 181000 731941 Training 2,000.00 2,000.00 2,000.00 E General Fund County Executive Admin 10100 1010101 181000 7317BO Software Support Mtn 10,000.00 10,000.00 10,00000 E General Fund County Executive Admin 10100 1010101 181000 774636 Info Tech Operations 6,824.00 1105.00 11,695.00 E General Fund County Execute Admin 10100 1010101 181000 778675 Telephone Communication 726.00 1,245.00 1,245.00 E General Fund Noo-Depadddent 10100 9010101 196030 796500 Budgeted Equity Adjustment 22,507.00 Total Fxpend@ures $ (7,034.00) $ (22,461 00) $ - Oakland County, Michigan COUNTY EXECUTIVE -TRANSFER OF POSITIONS AND DELETION OF CENTRAL SERVICES DEPARTMENT AND CREATION OF Schedule "A" DETAIL -CENTRAL SERVICES SUPPORT SERVICES GFGP (#10100) POSITIONS (Funtl# (Division uperaing runs forger nolecr FY 2022 FY 2023 FY 2024 WE Fund Name Division Name #IProgam #lAecouM# Unit Atilliatel Reference l Unit Project# IActivilylAnalysis( Account Title Amendment Amendment Amendment R General Fund Support Svc Food Svc 10100 1030802 1840U5 63022 Commission Vending Machines (1750000) (30,00000) (3D,00600) R General Fund Support Svc Record Retention Mail 10100 1030803 184020 670228 County Auction (87500) (1,50000) (1,500.OD) R General Fund Support Svc Mail 10100 103092D 184020 631232 Metered Postage (35,583.00) (61,000.00) (61,000.00) R General Fund Support Svc Mail 10100 103082D 184020 632156 Standard Mail (131,250.0) (225,000.00) (225,000.00) $ (185,208.00) $ (317,500.00) $ (317,500.00) R General Fund Support Svc Food Svc 10100 1040203 184005 630322 Commission Vending Machines 17,500 00 30,000AO 30,000 00 R General Fund Support Svc Record Retention Mail 10100 1040204 184020 670228 County Auction 87500 1,500.00 1,50000 R Geneal Fund Support Svc Mail 10100 1M205 184020 631232 Metered Postage 35,583,00 61,0060D 61,OOO.OD R Geneal Fund Support Svc Mad 10100 1040205 1M020 632156 Standard Mail 131,250,00 225,00000 225,00000 $ 185,208.00 $ 317,500.00 $ 317,500.00 Total Revenues E Geneal Fund Support Svc Admit 10100 1030801 1W30 702010 Salaries $ (98,25300) $(168,434.00) $(168,434.00) E General Fund Support Svc Admin 10100 1030801 1W30 712020 Overruns (583.00) (1,00D 00) (1,ODD.oO) E General Fund Support Svc Admit 10100 1030801 184030 722750 Workers Compensation (10900) (18600) (18600) E General Fund Support Svc Admit 10100 1030801 184030 M760 Group Life (214.00) (36600) (366.00) E General Fund SupportSvc Admin 10100 1030501 184030 722770 Retirement (19,27300) (15,897.00) (15,89700) E General Fund Support Svc Admit 10100 1030801 184030 72980 Hosprtalaa0on (9,27300) (15,89T00) (15,89700) E General Fund Support Svc Armin 10100 1030801 184030 722780 Social Security (7,51600) (12,885.00) (12,885.00) E General Fund Support Svc Admin 10100 1030801 184030 72280D Dental (72.00) (1,32400) (1,324.OD) E General Fund Support Svc Admin 10100 1030801 184030 722810 Disability (1,550.OD) (2,65700) (2,657CO) E General Fund Support Svc Admit 1010D 1030801 1M030 72282D Unemployment l nsurance (9800) (16800) (168.00) E General Fund Support Svc Admit 10100 1030801 184030 722850 Optical (10200) (17600) (17500) E Geneal Fund Support Svc Admin 10100 1030801 184030 774677 Insurance (32800) (571.00) (56800) $ (135,544.00) $ (232,370.00) $ (232,367.00) E General Fund Support Svc Admin 10100 1M0201 184030 702010 Salaries 98,25300 168,43400 168,434XD E General Fund Support Svc Admit 10100 1040201 184030 712020 Overtime 58300 1,00000 1,ODD.D0 E General Fund Support Svc Admin 10100 1040201 184030 722750 Workers Compensation 109.00 186.00 18600 E General Fund Support Svc Admin 10100 1040201 184030 722760 Group Lde 214.00 36600 36600 E General Fund Support Svc Admin 10100 1040201 184030 722770 Retirement 16,746.00 28,70700 28,707.00 E General Fund Support Svc Admin 10100 1M201 1MO30 722780 Hospitalization 9,27300 15,89T00 15,89TOD E General Fund Support Svc Admin 10100 1040201 164030 72278D Social Security 7,516 DO 12,88500 12,885.00 E Geneal Fund Support Svc Admit 1010D 1040201 184030 722800 Dental 77200 1,324.00 1,32400 E General Fund SupportSvc Admin 10100 1040201 1W30 722810 Disability 1,550.00 2,65T00 2,65700 E General Fund SupportSvc Admin 10100 1M201 184030 722820 Unemployment Insurance 9&00 168.00 16800 E General Fund Support Svc Admit 10100 10,10201 184030 722850 Optical 10200 17500 175.OD E General Fund Support Svc Admin 10100 1040201 1W30 T46TT Insurance 32800 57100 568.OD $ 135,544.00 $ 232,370.00 $ 232,367.00 E General Fund Support Svc Food Svc 10100 1030801 1840D5 730646 Equipment Maintenance 158300) (1,000.00) (1,00000) E General Fund Support Svc Food Svc 10100 1030BOI 184005 731339 Periodicals Books Publ Sub (63900) (1,08D.OD) (1,080 00) E General Fund Support Svc Food Svc 10100 1030801 184005 770631 Bldg Space Cost Allocabon (110,669.00) (201,869.00) (203,32T.OD) E Seminal Fund Support Svc Food Svc 1010D 1030801 IM005 778675 Telephone Communications (424.OD) (726 00) (726.00) $ (112,306.00) $ (204,675.00) It (206,133.00) E Genial Fund Support Svc Food Svc 10100 1040203 184005 730646 Equipment Maintenance 583.00 1,000.00 1,000 00 E General Fund Support Svc Food Svc 10100 1W203 1W05 731339 Penci is Books Rub1 Sub 63000 1,08D.00 1,OBD 00 E General Fund Support Svc Food Svc 10100 1040203 184005 T70631 Bldg Space Cost Allocatmn 110,66900 201,869.00 203,32].00 E General Fund Support Svc Food Svc 10100 1040203 1W05 T78675 Telephone Communications 424 DO 72600 726.00 $ 112,306.00 $ 204,675.00 $ 206,133.00 E General Fund Support Svc Record Relenbon Mad 101DD 1030803 184020 702010 Salaries Regular (203,06T.00) (310,416,00) (271,96400) E General Fund Support Svc Record Retention Mail 1O1OD 1030803 184020 712D20 Overtime (4,375.00) (7,50D DO) (7,501OD) E Geneml Fund Support Svc Record Retention Mail 10100 1030803 1M020 722750 Workers Compensation (246CO) (422.00) (422CO) E General Fund Support Svc Record Retention Mad 10100 1030803 184020 72276D Group Life (490 00) (840 00) (840.00) E General Fund Support Svc Record Retention Mail 10100 1030803 184020 722770 Retirement (58,893 00) (99,063.00) (96,90300) E General Fund Support Svc Record Retention Mail 10100 1030803 184020 722780 Hospdaluation (41,581.00) (71,282A0) (71,282 00) E General Fund Support Svc Record Retention Mail 10100 1030B03 184020 722790 Social Security FTF184.00) (29,458.OD) (29,458CD) E General Fund Support Svc Record Retention Mail 10100 1030803 184020 722800 Dental (4,339 00) (7,439 00) (7,439.00) E General Fund Support Svc Record Retention Mad 10100 1030K3 184020 722810 Disability (3,544 00) (6,07600) (6,07600) E Geneal Fund Support Svc Record Retention Mail 10100 1030803 184020 722820 Unemployment Insurance (226.00) (387 (381.00) (387 (38] 00) E Gensal Fund Support Svc Record Retention Mail 10100 1030803 184020 722850 Optical (379.00) (&,am) (64900) E Geneml Fund Support Svc Record Retention Mail 10100 1030803 184020 730114 Auction Expense (146.00) (2500D) (25D.OD) E Geneal Fund Support Svc Record Retention Mail 10100 1030803 IB4020 730646 Equipment Maintenance (146 00) (250 00) (250.00) E General Fund Support Svc Record Retention Mail 10100 1030803 1M020 730653 Equipment Rental (583 DO) (1,000.00) (1,000 00) E General Fund Support Svc Record Retention Mal 10100 1030803 184020 731115 Licenses and Permits (1,75900) (3,000.00) (3,000m) E General Fund SupportSvc Record Ratentmn Mail 10100 1030803 184020 731150 Maintenance Contact (17,500.00), (30,000.OD) (3D,000.OD) Oakland County, Michigan COUNTY EXECUTIVE -TRANSFER OF POSITIONS AND DELETION OF CENTRAL SERVICES DEPARTMENT AND CREATION OF PERFORMANCE MANAGEMENT POSITIONS Schedule "A" DETAIL -CENTRAL SERVICES SUPPORT SERVICES GFGP (#10100) (- (Fund# (Division#(Program# .I 24 WE Fund Name Division Name ACCOYM# Unit (OU) AfFfMe RefeoreacelY Unit Prolec[# AMivity Analysis) Account Title Amendment Amendment Amend6menI E General Fund Support Svc Record Retention Mail 10100 1030803 184U20 731346 rersonal Mileage (53 00) (90.OD) (90 00) E General Fund Support Svc Record Retention Mail 10100 1030B03 184020 731388 Printing (131.00) (225 OD) (22500) E General Fund Support Svc Record Retention Mail 10100 1030903 184020 731773 Software Rental Lease Purchase (14,583.00) (25,000 OD) (25,00O.OD) E General Fund Support Svc Record Retention Mail 10100 1030803 184020 750154 Expendable Equipment (2,333CO) (4,000 00) (4,000.00) E General Fund Support Svc Record Retention Mail 10100 1030803 184020 750399 Office Supplies (6,708.00) (11,50000) (11,50OCO) E General Fund Support Svc Record Retention Mail 1010D 1030B03 184020 750581 Uniforms (1,674 00) - _ E General Fund Support Svc Record Retention Mail 10100 1030803 184020 770631 Bldg Space Cost Allocation (57,394 00) (104,689.00) (105,447 00) E General Fund Support By. Recent Retention Mai 10100 1030803 164020 714636 Info Tech Operations (35,65800) (62,842CD) (62,842 00) E General Fund Support Svc Record Retention Mail 10100 1030803 1M020 774677 Insurer. Fund (1,93000) (3,40900) (3,38800) E General Fund Support Svc Record Relenhori Mail 10100 1030803 184020 776659 Motor Pool Fuel Charges (2,293DO) (3.930DO) (393000) E General Fund Support Svc Record Retention Mail 10100 1030803 1M020 776661 Motor Pool (18,530 00) (31,765.00) (31,765,00) E General Fund Support Svc Record Retention Mail 10100 1030803 1M020 778675 Telephone Communications (4,16300) (7,137.00) (7,13700) $ (500,899.00) $ (822,619XO) $ (782,744.00) E General Fund Support Svc Record Retention Mad 10100 10402N 184020 702010 Salaries Regular 203,067 00 310,416 00 271,96400 E General Fund Support Svc Record Retention Mail 1010D 1040204 184020 712020 Overtime 4,37600 7,50000 7,500.00 E General Fund Support Svc Record Retention Mail 10100 1040204 184020 722750 Workers Compensation 246.00 422.00 422.00 E General Fund Support Svc Record Retention Mail 10100 1040204 184020 722760 Group Life 49D 00 840.00 Coo 00 E General Fund Support Svc Record Retention Mai 10100 1040204 184020 7227TO Retirement 58,893.00 99,06300 96,903 00 E General Fund Support Svc Record Retention Mail 10100 1N0204 IW20 72278D Hospitalization 41,5B1AD 71,28200 7128200 E General Fund Support Svc Record Retention Mail 10100 1040204 184020 722790 Social Security 17,184.00 29458 00 29,458CD E General Fund Support Svc Record Retention Mail 10100 IN0204 184020 722800 Dental 4,33900 7,439.00 7,439.00 E General Fund Support Svc Record Retention Mad 10100 1040204 1M020 722810 Disability 3,544 DO 6,07600 6,076.00 E General Fund Support Svc Record Retention Mai 10100 IW204 lS,02O 722820 Unemployment Insurance 226.00 3870D 38700 E General Fund Support Svc Record Retention Mail 1010D 1040204 184020 722850 Optical 379.00 64900 649 OD E General Fund Support Svc Record Retention Mail 10100 1040204 184020 T30114 Auction Expense 146.00 25000 25100 E General Fund Support Svc Record Retention Mail 10100 1040204 184020 730646 Equipment Maintenance 146,00 25DA0 250.00 E General Funtl Support Svc Record Retention Mail 10100 1040204 184020 730663 Equipment Rental OD E General Fund Support Svc Record Retention Mal 10100 1040204 18402D 731115 Licensesandnce 75OCO 3,O00 3,00000 300000 E General Fund Support Svc Record Retention Mad 10100 1040204 18402D 7311 Maintenance Contract 7,50O00 A,500.00 0.00000 30,OOo 0O 3D,0000D E General Fund Support Svc Record Retention Mail 10100 1040204 134020 13 7313W Personal Mileage age 5300 90.00 E General Fund Support Svc Record Retenton Mail 10100 1040204 184020 731388 Printing 13100 226U0 25.00 225.00 E General Fund Support Svc Record Retention Mail 10100 1040204 184020 731773 Software Rental Lease Purchase 14,583.00 25,OOD.O0 25,000 00 E General Fund Support Svc Record Retention Mail 10100 10402N 184020 750154 Expendable Equipment 2,3MCO 4.000 OD 4,00000 E General Fund Support Svc Record Retention Mail 10100 1040204 184020 750399 Office Supplies 6,70800 11,500 00 11,500 OD E General Fund Support Svc Record Retention Mad 10100 1040204 184020 750581 Umfairms 1,6T4 00 - _ E General Fund Support Svc Record Retention Mail 10100 1040204 184020 770631 Bldg Space Cost Allocation 57,394 00 104,689.00 105.447.00 E General Fund Support Svc Record Retenton Mad 10100 IN0204 184020 T74636 Info Tech Operations 36,65800 62,8420D 62,84200 E General Fund Support Svc Record Retenbon Mail 10100 10,10204 184020 774677 Insurance Fund 1,930.00 3,409 OD 3,38800 E General Fund Support Svc Record Retention Mail 1010D IN0204 1W20 T76659 Motor Pool Fuel Charges 2.29300 3,93000 3,93D OD E General Fund Support Svc Record Retention Mail 1010D 1040204 184020 776661 Motor Pool 18,53000 31,765.00 31,765.00 E General Fund Support Svc Record Retention Mai 10100 10402M 1M020 778675 Telephone Communications 4,163.00 7,13TOO 7,137DO $ 500,899.00 $ 822.619.00 $ 782,744.00 E General Fund Support Svc Record Retention Mail 10100 1030803 184025 702010 Salaries Regular (166,55700) (267,489 00) (249,09D.00) E General Fund Support Svc Record Retention Mail 10100 1030803 184025 712020 Overtime (2,91700) (5,00DOO) (S,OOD.OD) E General Fund Support Svc Record Retenton Mail 10100 1030803 184025 72275D Workers Compensation (51500) (B82DO) (882DO) E General Fund Support Svc Record Retention Mail 1010D 1030803 184025 722760 Group Gfe (317CO) (544.00) (544 00) E General Fund Support Svc Record Retention Mad 10100 1030803 184025 722770 Retirement (39,18300) (66,3640D) (55,53800) E General Fund Support Svc Record Retention Mail 10100 1030803 184025 722780 Hospitalization (23,578 00) (40,419 00) (40,419.00) E General Fund Support Svc Record Retenton Mail 10100 1030503 184025 722790 Social Security (11,599 DO (19SSTOO) U9,884CO) E General Fund Support Svc Record Retention Mail 10100 1030803 184025 722800 Dental (2239.00 (3,838.00) (3,83800) E General Fund Support Svc Record Retention Mai 10100 1030803 184025 722810 Disability (2,300.00 (3,942CO) (3,94200) E General Fund Support Svc Record Retention Mail 1010D 1030803 1M25 7UB20 Unemployment Insurance (17800 (30500) (305.00) E General Fund Support Svc Record Retention Mail 1010D 1030803 184025 722850 Optical (236-00 (405.00) (405.00) E General Fund Support Svc Record Retention Mal 10100 1030803 184025 730W Equipment Maintenance (146.00 (250 OO) (250.00) E General Fund Support Svc Recent Retention Mail 10100 1030803 184025 731388 Printing (117CO (2000D) (200 00) E General Fund Support Svc Record Retenbon Mail 10100 1030803 184025 750154 Expendable Equipment (583.00, (1,00000) (1,OOD 00) E General Fund Support Svc Record Retention Mail 10100 1030803 184025 750399 Office Supplies (87500) (1,500.00) (150ODD) E General Fund Support Svc Record Retention Mai 1010D 1030803 184025 750581 Uniforms (1,196.00) - - E General Fund Support Svc Record Retention Mail 1010D 1030803 184025 T70631 Bldg Space Cost Allocation (241,600CD) (440,699.00) (443,882 00) E General Fund Support Svc RecoN Retention Mal 10100 1030803 IM025 773630 Info Tech Development (5,420 00) - - E General Fund Support Svc Record Retention Mail 10100 1030803 184025 774636 Info Tech Operators (17,9A 00) (30,817.00) (30,81700) E General Fund Support Svc RecoN Retention Mail 10100 1030803 184025 774637 Info Tech Managed Print Svcs (6B1.00) (1,167.p0) (1,167.00) E General Fund Support Svc Record Retention Mai 10100 1030803 1M025 T746T7 Insurance Fund (1,10500) (1 S23 OD) (1,91200) E General Fund Support Svc Record Retention Mad 10100 1030803 184025 T78675 Telephone Communications (1,90500) (3,2660D), (3,26600) Oakland County, Michigan COUNTY EXECUTIVE —TRANSFER OF POSITIONS AND DELETION OF CENTRAL SERVICES DEPARTMENT AND CREATION OF PERFORMANCE MANAGEMENT POSITIONS Schedule"A"DETAIL -CENTRAL SERVICES SUPPORT SERVICES GFGP(#10100) Upe Fund euagei 'Unit WE Fund Name Division Name Fund# Division#Program# ([ing (r-,--I Account# Unit OU AfFliale Reference I Pro'ect# Aativi Anal sis Account Title 1 tyI Y E General Fund Support Svc Record Retention Mail 10100 1040202 184025 702010 Salaries Regular E General Fund Support Svc Record Retention Mail 10100 1040202 184025 712020 Overtime E General Fund Support Svc Record Retenfion Mail 10100 1040202 184025 722750 Workers Compensation E General Fund Support Svc Record Retention Mail 10100 1040202 184025 722760 Group Life E General Fund Support Svc Record Retenfion Mail 10100 1040202 184025 722770 Retirement E General Fund Support Svc Record Retention Mail 10100 1040202 18W25 722780 Hospitalization E General Fund Support Svc Record Retenfion Mail 10100 1040202 184025 722790 Social Security E General Fund Support Svc Record Retention Mall 10100 1040202 184025 722800 Dental E General Fund Support Svc Bacot Retention Mail 10100 1040202 184025 722810 Disability E General Fund Support Svc Record Retenfion Met 10100 1040202 18W25 722820 Unemployment Insurance E General Fund Support Svc Record Retention Mail 10100 1040202 181 722850 Optical E General Fund Support Svc Record Retention Mail 10100 1040202 18W25 730646 Equipment Maintenance E General Fund Support Svc Record Retention Mail 10100 1040202 18W25 731388 Printing E General Fund Support Svc Record Retention Mail 10100 1040202 184025 750154 Expendable Equipment E General Fund Support Svc Record Retention Mail 10100 1040202 184025 750399 Office Supplies E General Fund Support Svc Record Retention Mail 10100 1040202 184025 750581 Unrforms E General Fund Support Svc Record Retention Mail 10100 IM0202 184025 770631 Bldg Space Cost Allocation E General Fund Support Svc Record Retention Mail 10100 i0W202 18W25 773630 Info Tech Development E General Fund Support Svc Record Retention Mail 10100 IM0202 18W25 774636 Info Tech Operations E General Fund Support Svc Record Retention Mail 10100 1 M0202 184025 T74637 Info Tech Managed Print Svcs E General Fund Support Svc Recent Retention Mail 10100 IM0202 18W25 774677 Insurance Fund E General Fund Support Svc Record Retention Mail 10100 1040202 184025 778675 Telephone Communications E General Fund Support Svc Mail 10100 1030820 184020 730373 Con ne"' Services E General Fund Support Svc Mail 10100 1030820 184020 731143 Mail Handling- Postage Svc E General Fund Support Svc Mail 10100 1030820 184020 750392 Metered Postage E General Fund Support Svc Mail 10100 1M0205 1M020 730373 Contracted Services E General Fund Support Svc Mail 10100 1W205 184020 731143 Mal H.nd"ng-Postage Svc E General Fund Support Svc Mail 10100 1040205 184020 750392 Metered Postage Total Expenditures Amendment I Amendment I Amendment $ 1521.22400) $ (889,894.00( $ (873,8410(1) 166,55700 267,48900 249,09D OD 2,91700 5,00000 5,000.OD 515.OD 88200 882.00 317.OD 54400 544.00 39,183.00 66,364.00 65,53800 23,578.00 40,419.00 40,41900 11,599.00 19,884.00 19,884 00 2,23900 3,838.00 3,83800 2,30000 3,942.00 3,94200 17800 305 OD 30500 236.00 4050D 4050D 146.OD 25000 250.00 117OD 20000 200.00 583.00 1,000-00 1,000.00 875.00 11500-00 I S00.00 1,196 00 241,60000 440,699.00 443,88200 5420.00 - - 17,9T700 30,8170D 30,817.00 68L00 116700 1,167C0 1,105.OD 1,92300 1,912D0 1,905.00 3,26600 3,266.00 $ 521,224.00 $ 889,894.00 $ 873,841.00 (2,61300) (4,480.DD) (4,48000) (110,83300) (190,OOD.DO) (190,000DO) (32,D8300) (SS,000.00) (55,00000) $ (145,529.00) $ (20,480.00) $ (2A9,480.00) 2,613.OD 4,48000 4,480.00 11 D,833.00 1 190,000 00 190,OOD.OD 32,08300 55,00000 55,00900 $ 145,529.00 $ 249,480.00 $ 249,480.00 $ - $ - S - Oakland County, Michigan COUNTY EXECUTIVE -TRANSFER OF POSITIONS AND DELETION OF CENTRAL SERVICES DEPARTMENT AND CREATION OF PERFORMANCE MANAGEMENT POSITIONS Schedule "A" DETAIL- MOTOR POOL FUND (#66100) raise l WE l Fund Name l Division Name (,Fund #1 Division #I Proam#lA count#I U nit Affifatel ReferencelrUnit' PrRmA4 ActivitylAnalYsisl Account TNe Amendment Amendment Ame dment R Motor Pool GS-Support Svc -Leased Vehicles 66100 1030811 184010 630196 Car Wash S (52500 $ (900.00) $ (90000) R Motor Pool CS-SupportSvc-Leased Vehicles 66100 1030811 184010 630833 Gasoline Oil Grease Charges (1.237,640.00 (2j,10,881.00) (2,140,881 00) R Motor Pool CS -Support Svc -Leased Vehicles 66100 1030811 184010 631071 Leased Equipment (3.340.561.00 (5.TT6,149.00) (5,776,14900) R Motor Pool CS Support Svc -Leased Vehicles 66100 1030811 184010 631463 Paris and Accessones (195,718.00 (302,000.00) (302,00000) R Motor Pool CSSupportSvc-Leased Vehicles 66100 1030811 184010 631610 Productive Labor (213,441.00 (350,000.00) (350,00000) R Motor Pool CS-SupportSvc-Leased Vehicles 66100 1030811 184010 632198 Sublet Repairs (46,66700 (86500.00) (80,00000) R Motor Pool CS -Support Svc -Leased Vehicles 66100 1030811 184010 635530 Fxt-Other Revenue (26,25000 (45,00000) (45,00000) R Motor Pool CSSupportSvc-Leased Vehides 66100 1030811 184010 63555T EA -Paris and Accessones Rev (7,00000 (12,000.00) (12,00000) R Motor Pod CSSupportSvc-Leased Vatudes 66100 1030811 184010 635665 Ext-Productive Labor Rev (32.08300 (55,00000) (55,00000) R Motor Pool CS -Support Svo-Leased Vehides 66100 1030811 184010 635854 Ext-Warranty Reimbursements (10,50000 (18,00000) (18,00000) R Motor Pool CS-SupportSvo-Leased Vehicles 66100 1030811 184010 655385 Income from Investments (23,33300 140,000.00) (40,00000) R Motor Pool CS -Support Svo-Leased Vehides 66100 1030811 184010 665882 Planned Use of Balance - (229,39800) (319,05800) R Motor Pool GS_Support Svo-Leased Vehicles 66100 1030811 184010 670627 Sale of Equipment (29200) (FOG 00) (50000) R Motor Pool CS-SupportSvo-Leased Vehicles 66100 1030811 184010 670741 Sale of Scrap (1,28300) (220000) (2,20000) R Motor Pool CSSupport Svo-Leased Vehicles 66100 1030811 184010 675660 Gam on Sale of Vehcles (262,500.00) (450,00000) (450,00000) R Motor Pool CS -Support Svc Leased Vehicles 66100 1030811 184010 695500 10100 Transfers In (114,520.00) - - R Motor Pool C&Support Svo-Leased Vehicles 66100 1030811 184010 695500 63900 Transfers In (54,179.00) - - $ (5,566,492.00) $ (9,502,028.00) $ (9,591,688.00) R Motor Pool Facilmov-SupportSvo-Leased Vet66100 1040210 184010 630196 Car Wash $ 525.D0 $ 90000 $ 90000 R Motor Pool FacifteaSupport SonLeased Vet 66100 1040210 184010 630833 Gasoline Oil Grease Chi 1237,64000 2140,88100 2,140,88100 R Motor Pool Facildes-SupportSvo-Leased Vel66100 1040210 184010 631071 Leased Equipment 3,340,56100 5,776,14900 5,TT6,149.00 R Motor Pool FamlNecSupport Svo-Leased Vet 66100 1040210 189010 631463 Parts and Accessones 195,71800 302,000.00 302000.00 R Motor Pool Facddes-Support Svo-Leased Vet 66100 1040210 184010 631610 Productive Labor 213,44100 3501000.00 350,001 R Motor Pool Faclhhes-Support Svo-Leasetl Vet 66100 1040210 184010 632198 Sublet Repairs 46,66700 86000.00 80,000.00 R Motor Pool FaahhesSupport Svo-Leasetl Ve166100 1040210 184010 635530 Ed -Other Revenue 26,25000 45,000.00 45,00DA0 R Motor Pool F.dIhds-Support Svo-Leased Val 66100 1040210 184010 635557 Ext-Pads and Accessories Rev 7.00000 12000.00 12,000.00 R Motor Pont Facilities Support Svo-Leased Vat 65100 1040210 184010 635665 Ed -Productive Labor Rev 32,08300 551001 55,000.00 R Motor Pod Facilities -Support SvcLeased Vel 66100 1040210 184010 635854 Exl-Warranty Reimbursements 10,50000 18,000.00 16000.00 R Motor Pool Fadides-Support Svc -Leased Vet 66100 1040210 184010 655385 Income from Investments 23,33300 40,000 00 40,00000 R Motor Pool FacridesSupport SvcLeased Val 66100 1040210 184010 665882 Planned Use of Balance - 229,39800 319,05800 R Motor Pool FaaidtesSupport Svo-Leased Vet 66100 1040210 184010 67062T Sale of Equipment 292.00 50000 50000 R Motor Pool Facil'AesSupport Svc -Leased Vet 66100 1040210 184010 67O741 Said of Scrap 1,283.00 220D 00 2,20000 R Motor Pool FaciGtiesSupport Svo-Leased Vet 66100 1040210 184010 6T5660 Gain on Sale of Vehicles 262,50D00 450,00000 450,50000 R Motor Pool Fadl'NesSupped Svc -Leased Vet 66100 1040210 184010 695500 10100 Transfers In 114,520.00 - - R Motor Pool FacdNesSupport Svc -Leased Vet 66100 1040210 184010 695500 63900 Transfers In 54,179.00 - - $ 5.566,492.00 $ 9,502.028.00 $ 9.591.688.00 Total Revenues $ - $ - $ _ E Motor Pool CS -Support Svo-Leased Vehicles 66100 1030811 18a010 702010 Sultana. Regular $ (591,77800) $ (1,052,52700) $ (1,081054,00, E Motor Pool CS -Support Svo-Leased Vehicles 66100 1030811 184010 712020 Overtime (20,417.00) (35,000.00) (35.000.00) E Motor Pool CS -Support Svo-Leased Vehicles 66100 1030811 184010 712090 On Coll (IS,45800) (26,500.00) (26,50000) E Motor Pool CS Support SvcLeased Vehicles 66100 1030811 IM010 T22T50 Workers Compensation (12,02500) (20,614.00) (20,614,00) E Motor Pod CS -Support Svo-Leasetl Vehicles 66100 1030811 184010 722760 Group Life (1,25200) (C146.00) (2,146.00) E Motor Pool CSSupport Svo-Leased Vehicles 66100 1030811 1 M01 0 722770 Retirement (151.581 m) (259,853.00) (259,853.00) E Motor Pool CS -Support Svc -Leased Vehicles 66100 1030811 184010 722T80 llespRal¢abon (60,30900) (103,386.00) (103,386.00) E Motor Pool CS -Support Svc -Leased Vehides 66100 1030811 184010 722790 Social Security (44.O78.00) (T5,562.00) (75,562.00) E Motor Pool CS -Support Svc -Leased Vehicles 66100 1030811 184010 T22800 Rental (6,715O0) (11,511.00) (11,51100) E Motor Pool CS -Support Svc -Leased Vehicles 66100 1030811 184010 722810 Disability (9,09100) LI5,58400) (15,58400) E Motor Pool CS -Support SvcLeased Vehicles 66100 1030811 184010 722820 Unemployment insurance (578.50) (990 00) (990 00) E Motor Pool CSSupport SvcLeased Vehides 66100 1030811 184010 722850 Opecal (65D00) (1,11400) (1,11400) E Motor Pool CS -Support Svo-Leased Vehicles 66100 1030811 184010 722900 Fringe Benefit Adjustments (16,908.00) (42,30200) (52,28500) E Motor Pool C&Support Svo-Leased Vehicles 66100 1030811 184010 730114 Auction Expense (14,583.00) (25,00000) (25,00000) E Motor Pool CS -Support Svo-Leased Vehicles 66100 1030811 184010 730233 Car Wash (35,00000) (60,00000) (60,00000) E Motor Pool CS -Support Svo-Leased Vehicles 66100 1030811 184010 730646 Equipment Maintenance FOS 00) (1,000.00) (1,00000) E Motor Pool CS Support Svo-Leased Vehicles 66100 1030811 184010 730786 Garbage and Rubbish Disposal (1,45800) (2500.00) (2500.00) E Motor Pod CS -Support Svc -Leased Vehicles 66100 1030811 184010 730926 Indirect Costs (338.333.00) (580,000.00) (580,000.00) E Motor Pod CS -Support Svc-Leasetl Vehicles 66100 1030811 184010 730940 Insurance (288,106.00) (529,12100) (520,154.00) E Motor Pool CS -Support Svc -Leased Vehicles 66100 1030811 184010 73094T Insurance Reserve Expense (1T5,000.00) (300,000.00) (300,00000) E Motor Pool GS-Support Svc -Leased Vehicles 66100 1030811 184010 731059 Laundry and Cleaning (3,79200) (6,500.00) (6,50000) E Motor Pool CS -Support Svc -Leased Verdes, 66100 1030811 184010 731108 License Plates and Tia Fees (1,750.00) (3,00000) (3,00000) E Motor Pool CSSupport Svo-Leased Vehides 66100 1030811 184010 T31150 Maintenance Contract (14,583.00) (26,00000) (25,00000) E Motor Pool CS -Support Svo-Leased Vehides 66100 1030811 184010 731213 Membership Dues (1,167.00) (2,00000) (2,00000) E Motor Pool CSSupport Svo-Leased Vehicles 66100 1030811 184010 731311 Oil Grease and Solvents (21,000.00) (36.00000) (36,00000) E Motor Pool CS -Support Svo-Leased Vehicles 66100 1030811 184010 731339 Periodicals Books Publ Sub (58300) (1,00450) (1,00000) E Motor Pool CS -Support Svc -Leased Vehicles 66100 1030811 184010 731388 Painting (175.00) (300.00) (30000) E Motor Pool CS Support Svo-Leased Vehicles 66100 1030811 184010 731878 Sublet Repairs (87,50000) (150,000.09) (150,000.00) Oakland County, Michigan COUNWEXECUTIVE -TRANSFER OF POSITIONS AND DELETION OF CENTRAL SERVICES DEPARTMENT AND CREATION OF PERFORMANCE MANAGEMENT POSITIONS Schedule "A" DETAIL- MOTOR POOL FUND (#66100) Funo tluogex Yro)ett FY 2022 FY 2023 FY 2024 WE Fund Name Division Name Division#_Pro 9 ram#Accourrt# UnitOsman.9 UnitOU) Affiliate JReference Um[ Pro"eR# Activi Anal Account TiOe t ty, ysis Amendment Amendment Amendment E _ Motor Pool _Fund CSSupp0rtSvoLeased Vehicles 66100 1030811 1MO10 731920 Tool Allowance (3,033.00) (4,30000) (4,30000) E Motor Pool CSSupportSvo-Leased Vehicles 66100 1030811 184010 731934 Towing and Storage Fees (29200) (50000) 150000) E Motor Pool CSSuppod Svc -Leased Vehicles 66100 1030511 184010 732018 Travel and Conference (5833DIS (10,00000) (10,00000) E Motor Pool CS -Support Svc -Leased Vehicles 66100 1030811 184010 750063 Custodial Supplies (2625DO) (4,50000) (4,500DO) E Motor Pool CS -Support Svc -Leased Vehicles 66100 1030811 184010 750119 Dry Goods and Clothing (2,742.00) (1,50000) (1,500.00) E Motor Pool CS -Support Svc -Leased Vehicles 66100 1030811 184010 750140 Employee Footwear (2,56700) (1,00000) (1.000.00) E Motor Pool CSSupport Svc -Leased Vehicles 66100 1030811 1MO10 750210 Gasoline Charges (1,190,97300) (206D,861D0) (2,060,881DO) E Motor Pool CSSupport Svo-Leased Vehicles 66100 1030811 IM010 750392 Metered Postage (350.00) (60000) (600.00) E Motor Pool CS -Support Svo-Leased Vehicles 66100 1030811 184010 T50399 Office Supplies (1,400.00) (2,40000) (2,400.00) E Motor Pool CS-SupportSvc-Leased Vehide566100 1030811 189010 750413 Parts and Amonseones (369,55100) (600,00000) (600,00000) E Motor Pool CS -Support SvcLeased Vehicles 66100 1030811 184010 750497 Shop Supplies (45,500SO) (65,000.00) (65,000DO) E Motor Pool CS -Support Svo-Leased Vended 66100 1030811 1MO10 T50553 Tires and Tubes (128,33300) (220,000.00) 1220,00000) E Motor Pod CS -Support Svo-Leased Velnde566100 1030811 184010 761121 Depreciation Equipment (5,78600) (9,919DO) (a 802DO) E Motor Pool CSSupport SvoLeased Vehicles 66100 1030811 1MO10 761156 Depreciation Verdes (1,685,92700) (2894,992DO) (2,955,142.00) E Motor Pool CS -Support SvoLeased Vehicles 65100 1030811 184010 770631 Bldg Space Cost Allocation (949T8.00) (1T3,248D0) (174,499DO) E Motor Pool CS -Support SyrLeased Vehicles 66100 103DBll 184010 774636 Into Tech Operations (32,80900) (56.24,1.00) (56,244DO) E Motor Pool CS -Support Svo-Leased Vehicles 66100 103D811 184010 774637 Into Tech Managed Print Sv¢ (94400) (1,619DO) (1,619.00) E Motor Pool CS -Support Svo-Leased Vehicles 66100 1030811 184010 774677 Insurance Fund (10,78400) (19,423.00) (19,256.00) E Motor Pool CSSupport Svo-Leased Vehicles 66100 1030811 184010 775754 Maintenance Department Charg (29200) (500.00) (500TO) E Motor Pool CSSupport Sv,Leased Vehicles 66100 1030811 184010 777560 Radio Communications (1.60000) (2,742OD) (2,742.00) E Motor Pool CS -Support Svo-Leased Vehicles 66100 1030811 184010 778675 Telephone Communications (2,42100) (4,15000) (4,15000) E Motor Pool CSSupport Svo-Le..ad Vehicles 66100 1030811 184010 796600 Budgeted Equity Adjustments (63,29900) - - $ (5,566,492.00) $ DL502,028.00) $ (9,591.681 E Motor Pool Factions -Support S,,lumseed Vet 66100 1040210 184010 702010 Salaries Regular $ 591,778O0 $ 1,052,52700 $ 1,081.05400 E Motor Pool Fachi.Supp01 Svo-Leased Vet 66100 1040210 184010 T12020 Overtime 20,417.00 35,00000 35,00000 E Motor Pod Faa1'tes-Support Svc -Leased Vet 66100 1040210 184010 712090 On Call 15,458.00 26,50000 26.50000 E Motor Po01 FaCAtee-Support Svc -Leased Vet 66100 1040210 184010 722750 Workers Compensation 12025SO 2D614.00 20,614.00 E Motor Pool FacAtes-Support Svc -Leased Vet 66100 1040210 184010 722760 Group Life 1,252.00 2,146DO 2,146DO E Motor Pool Faciftes-Support Svo-Leased Val 66100 1040210 184010 722770 Retirement 151,5810D 259,853.00 259,85800 E Moto cool Factltes-Support Svc -Leased Ver 66100 1040210 1MO10 722780 Hospitalization 60,30900 103,386100 103,38600 E Motor P00l FacJtesSupport Svo-Leased Vet 66100 1040210 184010 T22790 Social Security 44.0]800 75,562DO 75,562DO E Motor Pool FaaldiesSupport Svc -Leased Ver 66100 10,10210 184010 72260D Dental 6,71500 11.511DI) 11,511.00 E Motor Pool FaalitiesSupport Svo-Leased Vet 66100 1040210 1MO10 T22810 Disabtty 9,09100 15,584.00 15,584.00 E Motor Pool FaciltesSupport Svo-Leased Vet 66100 IM210 184010 722520 Unemployment Insurance 57800 99000 99000 E Motor Pool FacidesSupport SimLeased Val 66100 1040210 184010 T22850 Optical 65000 111400 1,114.00 E Motor Pool FacilitlesSupport Svo-Leased Vol 66100 1040210 184010 722900 Fringe Benefit Adjustments 16,908.W 42,302.00 52,20500 E Motor Pool FaalOesSupport Svo-Leased Vet 66100 1040210 184010 730114 Auction Expense 14,580XI) 25,00000 25,00000 E Motor Pod Facntes-Support Svc -Leased Vet 66100 1040210 184010 730233 Car Wash 35,O1 60,00000 60,000.00 E Motor Pod Facltes-Support Svo-Leased Vet 65100 IND210 IM010 730646 Equipment Maintenance 583.00 1100000 1,00000 E Mot0r Pod Faciltes-Support Svo-Leased Vel 66100 1040210 184010 730786 Garbage and Rubbish Disposal 1,45800 2,50000 250000 E Moto Pool Fadhirm-Support Svo-Leased Vet 66100 1040210 IM10 730926 Indirect Costs 338,33300 580,00000 5B0,00000 E Motor Pool FacAitiee-Support Svo-Leased Vet 66100 IM210 184010 730940 Insurance 288,106SO 529,12100 520.15400 E Motor Pool FaalteSSapport Svc -Leased Vet 66100 1040210 IM010 73094T Insurance Reserve Expense 175,00000 300,00000 300.00000 E Motor Po0l FacAtes-Support Svo-Leased Vat 66100 1040210 IM010 731059 Laundry and Cleaning 3,792S0 6500.00 6.50000 E Motor Pool Faaltes-Support Svc -Leased Vel 66100 1040210 184010 731108 License Plates and Tile Fees 1,75000 3,000DO 3,00000 E Motor Pool FacAdies-Support Svc -Leased Vet 66100 1M0210 1MO10 731150 Maintenance Contract 14,58300 25,001 25,00000 E Motor Pool Facilities Support Svc -Leased Vet 66100 1040210 IM010 731213 Membership Dues 1,167 00 2,000.00 2000DD E Motor Pool FanlfiesSuppOrt Svc -Leased Ver 66100 1040210 184010 731311 Oil Grease and Solvents 21,000.00 35.000.00 36,000.00 E Motor Pod FacilNesSupport Svc -Leased Vehfi6100 1040210 IM10 731339 Penodirals Books Pub! Sub 583DI) 1,00000 1,000.00 E Motor Poo! Faci6hesSupport Svo-Leased Vet 66100 1040210 IM010 731388 Pnnting 175DO 30000 300.00 E Motor Poo! FactltesSupport Svo-Leased Vel 66100 1040210 IM010 731878 Sublet Repairs 87,500.00 150,00000 150,00000 E Motor Poo! Faaftas-Support Svo-Leased Ver 66100 1040210 IM010 731920 Too! Allowance 3,033.00 4,30000 4,30000 E Motor Poo! FacAOies.Support Svo-Leased Per 66100 1040210 184010 731934 Tovnng antl Storage Fees 29200 50000 50000 E Motor Pool Faclities-Support Sp -Leaved Vel66100 1040210 184010 73201B Travel and Conference 5,83300 10,I)GODO 10,00000 E Motor Poo! Faalitea-Support Svc -Leased Vet 66100 1040210 184010 750063 Custodial Supplies 22500 4,50000 4,50000 E Motor Pool FaaM1tes-Supp0rl Svo-Leased Vet 66100 1040210 1MO10 750119 Dry Goods and Clothing 2,74200 1,500.00 1,50000 E Motor Pod FacJtesSupport Svc -Leased Vel 66100 1040210 184010 750140 Employee Footwear 2,56700 1,001 1,000.00 E Motor Pool FaaltesSupport Svc -Leased Vel 66100 1040210 184010 750210 Coach.e Charges 1,190,973TO 2,060,88100 206g881.00 E Moto Pool FarAtes-Support Svc -Leased Vet 66100 1040210 184010 750392 Metered Postage 350.00 60000 600.0(3 E Motor Pool Faa0lies-Support Svc -Leased Vol 66100 1040210 184010 750399 Office Supplies 1,400.00 2,40000 2,40000 E Moto Food Faal'tes-Support Svc -Leased Vet 66100 IN0210 184010 750413 Parts and Accessories 369,55100 600,00000 600,00000 E Motor Poo! FacilteoSupport Svc -Leased Vet 66100 IM210 184010 750497 Shop Supplies 45,500.00 65,00000 65,00000 E Motor Poo! Faaltes-Support SvoLeased Vef 66100 1040210 184010 750553 Tres and Tubes 128,33300 220,00000 =S0000 E Motor Poo! FacAtes-Support Svo-Leased Vet 66100 1040210 184010 761121 Depredation Equipment 5,78600 9,919.00 8,80200 E Motor Pool FailNesSupport SvoLeased Vet 66100 1040210 184010 761156 Depredahon Veh,des 1,685,921.00 2894,99200 2,955,142.00 E Motor Pod FadltesSupport Svo-Leased Ver 66100 1040210 184010 770631 Bldg Space Cost Allocation 94,97800 173.248TO 17449900 E Motor Pool FacidesSupport Svo-Leased Vel 66100 1040210 184010 774636 Into Tech Operations 32,80900 56,24,tD0i 56,2"DI) Oakland County, Michigan AND DELETION OF CENTRAL SERVICES DEPARTMENT AND CREATION OF PERFORMANCE MANAGEMENT POSITIONS COUNTY EXECUTIVE —TRANSFER OF POSITIONS Schedule W DETAIL- MOTOR POOL FUND (966100) IFund#IDrvision I �peraba tuna nuogex rrojed Unit(OU) IAffiliatal Reference) Unit I Project# Acevity Analysis`Intu I ltle �12p`� Amentl y4400 ME Fund Name I_ Division Name #LPr_ogram#Account#I noonManaged rrm15vcs E _ Motor Pool Faalihes-Support SvcLeased Vet 66100 1040210 184010 Y1463Y Insurance Fund 10,78400 E Motor Pool Facifices-SuppOrt Svc -Leaned Vet 66100 1040210 164010 T4611 Mamtenance Department Charg 29200 E Motor Pool FaulNes-Supporl Svc -Leased Vet 66100 1040210 184010 7`75754 Radio Communications 1,600.00 E Motor Pool Faclinhas-Support Svc -Leased Ve166100 1040210 IM10 M560 Telephone Communications 2,421.00 E Motor Pool FaalOiesSupport Sv,Leasad Vet 66100 1040210 184010 ]]8675 Budgeted Fouty AdjuMtarfls 63299,00 E Motor Pool Faclift,Support Svc -Leased V066100 1040210 164010 Tm6 $ 5.566A92.00 $ Total Expenses $ - $ FY 2023 FY 2024 Amendment Amendment 1,619.00 1,619,00 19,423.00 19 256.00 50000 50000 2,74200 2,74200 4,15000 4,15000 9,502,028.00 $ 9,591,688.00 Oakland County, Michigan COUNTY EXECUTIVE -TRANSFER OF POSITIONS AND DELETION OF CENTRAL SERVICES DEPARTMENT AND CREATION OF PERFORMANCE MANAGEMENT POSITIONS Schedule "A" DETAIL -AIRPORT FUND Operating) Fund Budget Projectl FY 2022 FY 2023 FY 2024 WE Fund Name Division Name Fund# Division# Program # AccpuM# Unit (OD Affiliate Reference Unit PrActwi Anal sis Account Title I dY V Amendment Amendment Amendment R County Airport Aviation& Transport Administration 56500 1030701 164000 610900 Fed Grant - Interest Recovery $ (41,59Z.UU) $ (64,600.00) $ (64,60000) R CountyAirport Aviation& Transport Adminstrabon 56500 1030701 154000 655385 Income iron Investments (131,250.00) (225,00000) (225,00000) R County Airport Aviation& Transport Administration 56500 1030701 154010 630133 Aviation Gas (583,334.00) (1,000,DD0.00) (1,000,000-00) R County Aimed Aviation& Transport Administration 56500 1030701 1540ID 630189 Gar Rental Concessions (43,750.00) (75,000-00) (75,00000) R County Poryod Aviation& Transport Administration 56500 1030701 154DW 631036 Land Lease (91875000) (1,600,000.00) (1,600,000.00) R County Airport Aviation& Transport Adminrstrabou 56500 1030701 154010 631D50 Landing Fee Concessions (55,417CO) (95,000.00' (95,00D.0D) R County Airport Aviation& Transport Administration 56500 10301 154010 631D57 Lending Fees (17,50000) (30,000.O0 (30.00000) R County Airport Aviation& Transport Administration 56500 1030701 154010 631064 Late Penalty (2,62500) (4,500.00 (4,50000) R CountyNrport Aviation& Transport Administration 56500 1030701 IW10 631253 Miscellaneous (234.00) (400.00 (4C000) R County Airport Aviation& Transport Administration 56500 1030701 154010 631456 Parking Fees (875.00) (1.e0.00 (1,50000) R CountyAirport Aviation& Transport Administration 56500 1030701 154010 631925 Rental Facillties (292D0) (500.00 (50000) R County Airport Aviation& Transport Administration 56500 1030701 154010 632282 Tie Down (2,91T.00) (5.000100 (5,00000) R County Airport Aviation& Transport Administration 56500 1030701 154010 665882 Planned Use of Balance 11,249,785.00) (2,273,34500 (2.177,14900) R County Airport Aviation& Transport Administration 56500 1030701 15406D 632226 THangar Rental (1, 166.66700) (2,000,000.00 (2,000,00000) R County Airport Aviation & Transport Administration 55500 10 O701 15409D 63189T Reimb US Customs Service 0`i5ft oo) (300.000.00 (300,OOO Oo) $(4,360,822CO) $(7,674,045.00 $(7,578,64900) R County Airport Aviation& Transport Administration 56500 1090501 154000 610900 Fed Grant - Interest Recovery $ 41,59200 $ 64,60000 $ 64,600.00 R CouMy Airport Aviation& Transport Administration 55500 1090501 154009 655385 Income from Investments 131,250.00 225,00000 225,000.00 R County Airport Aviation& Transport Administration 56500 1090601 154010 630133 Aviation Gas 583.33400 1,000,00000 1,0001001 R County Airport Aviation& Transport Administration 56500 1090501 154010 630189 Car Rental Concessons 43,75000 75,000.00 75,00000 R County Airport Aviation& Transport Administration 56500 1090501 154010 631036 Land Lease 918.75000 1,600,000,00 1,600,000.00 R County Airport Aviation& Transport Admimstogon 56500 1090501 154010 631050 Lending Fee Concessons 55,417.00 95,00000 95.00000 R County Airport Aviation& Transport AdmmistmGon 56500 1090501 154010 631057 Landing Fees 1T,50O00 30,00000 30.000-00 R County Airport Aviation& Transport Administration 56500 1090501 154010 631064 Late Penalty 2.625.00 4,500.00 4,50000 R County Airport Aviation& Transport Administration 56500 1090501 154010 631253 Miscellaneous 23400 400-00 400.00 R County Airport Aviation& Transport Adoun straion 56500 1090501 15,1010 631456 Parking Fees 111 1,50000 1,500-0o R CountyAirport Aviation& Transport Administration 56500 1090501 15401D 631925 Rental FamRres 29200 500.00 50000 R CountyAirport Aviation& Transport Administration 56500 1090501 154010 632282 Tr. Down 2.91700 5,00000 51000.00 R County Airport Aviation& Transport Administration 56500 1090501 154010 665882 Planned Use of Balance 1,249,785.00 2,2T3345.00 2, 177, 14900 R County Airport Aviation& Transport Administration 56500 1090501 154060 63=6 THangar Rental 1,166,667C0 2,000,000.D0 2,000,ODD.00 R County Airport Aviation& Transport Administration 56500 1090501 154090 631897 Reimb US Customs Service 145,834.00 300.00000 30000000 $4,360,82200 $7,674,84500 $T,S78,649.00 Total Revenues $ - $ - $ - E County Arport Aviation and Transport Admin 56500 1030701 154000 702D10 Salaries Regular S (216,20100 $ (3B3,471.00) $ (392,81100) E County Arport Aviation and Transpout Minn 56500 1030701 1WOO 722750 Workers Compensation (2,76000 (4,730.00) (4,73000) E County Airport Aviation and Transport Atlmin 56500 1030701 154000 722760 Group Ede (37200 (63700) (63700) E County Airport Aviation and Transport Admin 56500 1030701 154000 722770 Retirement (46,44200 (79,61400) (79,614.00) E CountyAirport Aviation and Transport Admin 56500 1030701 154000 Y22780 Hospitalization (19,57800 (33,56200) (33,56200) E County Airport Aviation and Transport Admin 56500 1030701 154W0 722nO Soaal Security (13,43100 (23,02300) (23,023.00) E County Airport Aviation and Transport Admin 56500 1030701 154000 722800 Dental (1,97300 (3,38100) (3,381.00) E County Airport Aviation and Transport Admin 56500 1030701 154000 722810 Disability (2,698100 (4,62500) (4,625.00) E County Airport Aviation and Transport Admin 56500 1030701 154000 722820 Unemployment Insurance (19500 (33400 (334.00) E County Aimed Aviation and Transport Admin 56500 1030701 154000 72285) 01 (m.o0 (302.00 (30200) E County Airport Aviation and Transport Admin 56500 1030701 154000 noon Advertsng (700.00 (1,200.00 (120000) E County Airport Aviation and Transport Admin 56500 1030701 154000 730247 Charge Card Fee (17,50000 (30,000.00 (30,000.00) E County Arport Aviation and Transport Admin 55500 1030701 154000 730Yn Freight and Express (175.00 (300A0 (30000) E County Airport Aviation and Transport Admin 56500 1030701 154000 730926 Indirect Goss (240,217.00) (411,800,00 (411,80000) E County Airport Aviation and Transport Admin 56500 1030701 154000 731213 Membership Dues (1.284.00) (2,200.00 (2.20000) E CountyAirport Aviation and Transport Admin 56500 1030701 154000 7313M Paying Agents Fee Contractual (46T 00) 1800.00 (80000) E CountyAirport Aviation and Transport Admin 56500 1030701 151 731339 Penodirals Books Punt Sub (58400) (1,000.00 (1,00000) E County Airport Aviation and Transport Admin 56500 1030701 154000 731346 Personal Mileage (1,16700) (2,000DO) (2,00000) E County Airport Aviation and Transport Admin 56500 1030701 154000 732018 Travel and Conference (3,60000) (5,00000) (6,00000) E County Airport Aviation and Transport Admin 56500 1030701 154000 732165 Workshops and Meeting (116T 00) (2,00000) (2,000.00) E County Airport Aviation and Transport Admin 56500 1030701 154000 750392 Metered Postage (116700) (2,00000) (2,000.00) E County Airport Aviation and Transport Admin 56500 1030701 154000 750399 Office Supplies (2,334.00) (4,00000) (4,00000) E County Arport Aviation and Transport Admin 56500 1030701 154000 765031 Interest Expense (145,834.00) (250,00000) (25000000) E CountyAirport Aviation and Transited Admin 56500 1030701 154000 773630 Info Tech Development (4,084.00) (7,00DA0) (7,00000) E CountyAirport Aviation and Transport Admin 56500 1030701 154000 774636 Info Tech Operations (23,768.00) (40,745.00) (40,74500) E County Airport Aviation and Transport Admin 56500 1030701 154000 774637 Info Tech Managed Print Svcs (2,019.00) (3,461A0) (3,46100) E County Airport Aviation and Transport Admin 5650D 1030701 15400D 774677 Insurance Fund (bF,t&Oo) (9,828.00) 19,77300) E County Airport Aviation and Transport Admin 56500 1030701 IS4000 777MO Radio Communications (7,94Loo) (13,618.00) (13,61800) E County Airport Aviation and Transport Admm 55500 1030701 15400D 778675 Telephone Communications (6,53000) (11,193.00) (11,19300) E County Airport Aviation and Transport Achim 565W 1030701 15401D 702DIO Salaries Regular (591,52800) (1,045,384.00) (1,077,52900) E County Arport Aviation and Transport Admin 56500 1030701 154010 702130 Shift Premium (2.04200) (3,500.00). (3,50000). Oakland County, Michigan COUNTY EXECUTIVE - TRANSFER OF POSITIONS AND DELETION OF CENTRAL SERVICES DEPARTMENT AND CREATION OF PERFORMANCE MANAGEMENT POSITIONS Schedule "A" DETAIL -AIRPORT FUND Dpera[Ing YunO nugget Yfgett FT2@2 FY 2023 FY 2024 RIE Fund Name Division Name Funtl# Division#Pro .9 vim# Account# Unit (OU) Affiliate Reference UnH Project# Activil Analysis Account Tige Y Amentlment Amendment Amendment E County Airport Aviation and Transport Admin 56500 1030701 154010 T0218D Emergency Balance (6,592.00) (11,30000) (11,300.00) E County Airport Aviation and Transport Admin 56500 1030701 154010 712020 Overtime (55,41100) (95,00000) (95,000A0) E County Airport Aviation and Transport Admit 56500 1030701 154010 712040 Holiday Overtime (18,667.00) (32,00000) (320DD.OD) E Counly Anport Aviation and Transport Admit 56500 1030701 IW10 722750 Workers Compensation (11,608DO) (19,899.DO) (19,899.00) E County Airport Aviation and Transport Admit 56500 1030701 154010 722760 Group Life (1,20500) (2,065.00) (2,06500) E County Airport Aviation and Transport Admin 565M 1030701 IW10 722770 Retirement (144,30300) (247,375.00) 1247,37500) E County Airport Aviation and Transport Attain 56500 1030701 154010 722780 Hospitalization (88,26900) (151,318DO) (151,31800) E CountyAirport Aviation and Transport Admin 56500 1030701 154010 722790 Social Security (42,82400) (73,411AO) (73,411.00) E CountyAnport Aviation and Transport Admin 56500 1030701 154010 722800 Dental OBSS5 .00) (15,1T 00) (15,17ZOO) E CountyArport Aviation and Transport Admn 56500 1030701 154010 722810 Disability (8.746.00) (14,99300) (14,993DO) E County Airport Aviation and Transport Admin 56500 1030701 154010 7VB20 Unemployment Insurance (SOuDO) (1,00100) (1,00100) E Countyhupprt Aviation and Transport Admm 56500 1030701 154010 722850 optical (79OCO) (1,35300) (1,35300) E County Airport Aviation and Transport Admin 56500 1030701 154010 722900 Fringe Benefit Adjustments (18,761mo) (47,627.00) (62, 15200) E County Arpod Aviation and Transport Admin 56500 1030701 1WHO 730198 Building Maintenance Charges (49,58400) (BS,000AO) (BS00000) E County Again Aviation and Transport Admin 56500 1030701 154010 730324 Communications (2,33400) (4,00000) (4,00000) E County Airport Aviation and Transport Admin 56500 1030701 154010 730429 Custodial Services (7,58400) (13,00000) (13,00000) E County Airport Aviation and Transport Admin 56500 1030701 154010 730562 Electrical Service (122,500.00) (210,000.00) (210,000.00) E County Airport Aviation and Transport Admin 56500 1030701 154010 730611 Employees Medical Emma (46TDO) (80000) (800.00) E County Airport Aviation and Transport Admin 56500 1030701 154010 73D646 Equipment Maintenance (BT,500.00) (150,000.00) (15LOOOD0) E County Airport Aviation and Transport Admin 56500 1030701 154010 730786 Garbage and Rubbish Disposal (4,08400) (7,000.00) (7,OOD 00) E County Anport Aviation and Transport Admin 56500 1030701 154010 730814 Grounds Maintenance (163,33400) (280,000DO) (280.00000) E County Airport Aviation and Transport Admin 56500 1030701 154010 731059 Laundry and Cleaning (2,39200) (4,10ODO) (4,10000) E County Airport Aviation and Transport Admin 56500 1030701 154010 731115 Licenses and Permits (1,16700) (2,000DO) (2,000.00) E County Airport Aviation and Transport Admm 56500 1030701 154010 731458 Professional Services (5,834.00) (10,00000) (10,000.00) E CountyAmort Aviation and Transport Admin 56500 1030701 154010 T31654 Runway and Tasmay Repairs (23,334.00) (40,0000O) (40,000DO) E County Anport Aviation and Transport Admin 56500 1030701 154010 731689 Security Expense (11,667DO) (20,000.00) (2000ODO) E County Airport Aviation and Transport Admin 56500 1030701 154010 731941 Training (2,91T 00) (e,000.00) (5,00000) E County Airport Aviation and Transport Admm 56500 1030701 154010 732102 Water and Sewage Charges (32,66700) (56,000.00) (56,00000) E County Airport Aviation and Transport Admm 56500 1030701 154010 732151 Window Cleaving Service (2,91Z00) (5,000.00) (5,00000) E County Airport Aviation and Transport Admin 56500 1030701 1W10 750119 Dry Goods and Clothing (4,084.00) (5,O0000) (5,000.00) E County Airport Aviation and Transport Armin 56500 1030701 154010 750133 Electncal Supplies (17,500.00) (30,00000) (30,000.00) E County Airport Aviation and Transport Admin 56500 1030701 154010 750140 - Employee Footwear H.575.00) (70O00) (70ODO) E County Airport Aviation and Transport Admn 56500 1030701 154010 750196 Firefighbag Supplies (7,00000) (12,000.00) (12,00000) E CountyAmprt Aviation and Transport Admit 56500 1030701 154010 750210 Gasoline Charges (37,91700) (65,000.00) (65,00000) E CountyAirport Aviation and Transport Admin 565D0 1030701 1MO10 750224 Grounds Supplies (11,667-00) (20,000.00) (20,00000) E Gounty Airport Aviation and Transport Admm 56500 1030701 1MO10 750287 Maintenance Supplies (11,66TA0) (20,00000) (20,00000) E County Airport Aviation and Transport Admin 56500 1030701 154010 750504 Small Tools (2,917DO) (5,00000) (5,000.00) E County Airport Aviation and Transport Admin 56500 1030701 154010 750511 Special Event Supplies (2,91700) (S,000AD) (SO0000) E County Airport Aviation and Transport Admin 56500 1030701 154010 761007 Depreciation Land lmpmvemente (78.47500) (12T5,609.DO) (1,163,995,00) E County Airport Aviation and Transport Admin 56500 1030701 154010 761049 Depreciation Roads Parkitg Lot (212,299 DO) (219,904AO) (156,64900) E County Airport Aviation and Transport Atlmm 56500 1030701 154010 7610M Depreaation Buildings (471,67200) (819,213DO) (814,11700) E County Airport Aviation and Transport Admin 56500 1030701 154010 T61121 Depreciation Equipment (70,849.00) (378,73700) (378,49400) E County Airport Aviation and Transport Admin 56500 1030701 1W10 761156 Depreciation Vehndes (27,40800) (68,35500) (91,931.00) E County Airport Aviation and Transport Admin 56500 1030701 154D1D TT1639 Dram Equipment (1,16700) (2,000-00) (2,000.00) E County Airport Aviation and Transport Admin 56500 1030701 1W10 774637 I mo Tech Managed Print Svcs (3000) (5100) (51.00) E County Airport Aviation and Transport Admit 56500 1030701 154010 T467T Insurance Fund H10,54700) (197,602.00) (198,64800) E County Anport Aviation and Transport Admin 56500 1030701 154010 775754 Maintenance Department Chaigs (1,16700) (2.000.00) (2.00000) E CountyAirport Aviation and Transport Admin 56500 1030701 154010 776659 Motor Pool Fuel Charges (6300) (10700) (10700) E County Airport Aviation and Transport Admin 56500 1030701 1MO10 T/6E61 Motor Pool (6,561.00) H1,24700) (11,24TD0) E County Airport Aviation and Transport Admm 56500 1030701 154010 T8675 Telephone Communications (3,766.00) (6,45600) (6,456.00) E CountyAirport Aviation and Transport Admin 5650D 1OM701 154040 77B675 Telephone Communications (1m 00) (2,096A0) (2,09600) E County Airyort Aviation and Transport Admn 56500 1030701 154090 732067 US Customs Services (157,50000) (315,00000) (315,00000) E County Airport Aviation and Transport Admit 56500 1030701 1W90 732102 Water and Sewage Charges - _ - E County Airport Garland Troy Airport 56500 1030745 1WOO 774677 Insurance Fund (354.00) (61500) (61200) E CountyAirport Garland Troy Aimort M500 1030745 1W10 702010 Salaries Regular (39,55300) (69,16000) (70,543.00) E County Anport Oakland Troy Airport M500 1030745 154010 =50 Workers Compensation (77300) (1,324.00) (1,324DO) E County Airport Oakland Troy Airport 56500 1030745 154010 722770 Retirement (1,08800) (1,864.011) (1,864.00) E County Airport Oakland Troy Airport 56500 1030745 1MO10 722790 Social Security (574.00) (984.00) (98400) E County Anport Oakland Troy Airport 5650D 1030745 154010 722820 Unemployment Insurance (40.00) (6800) (6800) E County Airport Oakland Troy Airport 56500 1030745 154010 774636 Info Tech Operations (745DO) (12n 00) (12T7.00) E County Airyort Oakland Troy Airyort 56500 1030745 154010 774677 Insurance Fund (5,82600) (12,10100) (12,022DO) E Dounty Airport Oakland Troy Airport 56500 1030745 154010 y8675 Telephone Communications (88500) (1,516.00) (1,51600) E CountyAirport Oakland Southwest Airport 56500 1030750 15400D TT4677 Insurance Fund H5200) (611.00) (60800) E County Anport Oakland Southwest Airport 55500 1030750 154010 70201D Salaries Regular (56,567.00) (98,91200) (100,89100) E County hrport Oakland Southwest Airport 56500 1030750 1W10 72275D Workers Compensation (154000) (2,29600) (2,296.00) E County Airport Oakland Southwest Airport 56500 1030750 154010 T22760 Group Life (Sur 00) (95.00) (95.00) E County Airport Oakland Southwest Airport 56500 1030750 154010 72277D Retirement (8,18800) (14,036.00) (14,03600) Oakland County, Michigan COUNTY EXECUTIVE -TRANSFER OF POSITIONS AND DELETION OF CENTRAL SERVICES DEPARTMENT AND CREATION OF PERFORMANCE MANAGEMENT POSITIONS Schedule "A" DETAIL -AIRPORT FUND Operating Fund Budget Project FY 2022 FY 2023 FY 20U ME Fund Name Division Name Fund# Division# Pqoram# g Account# Unit OU Affibate Reference Unit Project# Activity Analysis Account Title 1 Y Y Amendment Amendment Amendment E CountyPorport OaNantl Southwest Airport 56500 1030750 154010 722780 Hospitaivation (2.73500) (4,68800: (4,68800) E County Arport Oakland Southwest Airport 56500 1030750 154010 722790 Social Security 12,38500) (4,08700} (4,08700) E County Arport Oakland Southwest Airport 56500 1030750 154010 722800 Dental (273.00) (46TOO;- (46700) E County Arport Oakland Southwest Airport 56500 1030750 154010 722810 Disability (402CO) (688O0y (688.00) E County Airport Oakland Southwest Airport 56500 1030750 154010 722820 Unemployment Insurance (56.00) (9600; (96.00) E County Airport Oakland Southwest Airport 56500 1030750 15401D 722850 Optical (3000) (5000) (5000) E County Airport Oakland Southwest Airport 56500 1030750 154010 774636 Info Tech Operations (3,59200) (6,157.00) (6,15TOO) E County Airport Oakland Southwest Airport 5650D 1030750 154010 774677 Insurance Fund (3,47500) (6,18500) (6,1 ut 00) E County Airport Oakland Southwest Airport 56500 1030750 154010 778675 Telephone Communications (21200) (36300) (36300) $(4,360860 00) $(7,674,845 DO;- $(7,578,649 00) E County Airport Aviation and Transport Admm 56500 1090501 154000 702010 Salanes Regular $ 216,20100 $ 383,471.00 $ 392,811.00 E County Airport Aviation and Transport Armin 56500 1090501 154000 722750 Workers Compensation 2,76000 4730DO 4,73ODO E County Arport Aviation and Transport Armin 56500 1090501 154000 722760 Group LRe 37200 63700 637.00 E County Airport Aviation and Transport Armin 56500 1090501 154000 722 Retirement 46,44200 79,61400 79,614.00 E CountyAirport Aviation and Transport Admin 56500 1090501 154000 722780 Hospralvaton 19,57800 33,56200 33,562.00 E CountyAirport Aviation and Transport Atlmin 56500 1090501 154000 722790 Social Secunty 13,43100 23,023.00 23,02300 E County Porport Aviation and Transport Admin 56500 1090501 154000 722800 Dental 1,97300 3,381CO 3.38100 E County Airport Aviation and Transport Admin 56500 1090501 154000 722810 DisabAiy 2,69800 4,62500 4,62500 E County Airport Avmtion and Transport Admin 66500 1090501 154000 M820 Unemployment Insurance 19500 33400 334.00 E CountyAirport Aviation and Transport Admin 56500 1090501 154000 722850 Optical 17700 30200 3020O E County Airport Aviation and Transport Admin 56500 1090501 154000 730072 Advertising 70000 1,200-00 1,200.00 E County Airport Aviation and Transport Achim 56500 1090501 154000 730247 Charge Card Fee 17,50000 30,DD0.00 30,00000 E CountyPorport Aviation and Transport Atlmm 56500 1090501 154000 730772 Freight ..it Express 17500 300.00 30000 E CountyArport Aviation and Transport Armin 56500 1090501 154000 730926 Indirect Costs 24021700 411,800.00 411,800 DO E CountyAirport Aviation and TransportArmin 56500 1090501 154000 731213 Membership Dues 1,284.00 2,200.00 220OCO E County Arport Aviation and TransportAdmin 56500 1090501 154000 731334 Paying Agents Fee Contrectual 46700 $0000 800-00 E County Airport Aviation and Transport Admin 56500 1090501 154000 731339 Pertodicals Books Publ Sub 58100 1,00000 1,000.00 E CountyAirport Aviation and Transport Admm 56500 1090501 15400 731346 Personal Mileage 1,16700 2,000.00 2,00000 E County Airport Aviation and Transport Admin 56500 1090501 154000 732018 Travel and Conference 3.50000 6,001 6,000.00 E County Aimed Aviation and Transport Admin 56500 1090501 154000 732165 Workshops and Meeting 1,16TOO 2,00000 2,00000 E CountyArport Aviation and Transport Armin 56500 1090501 154000 750392 Metered Postage 1,16700 2,00000 2,00000 E County Amort Aviation and Transport Admin 56500 1090501 154000 750399 Office Supplies 2,33400 4,00000 4,000.00 E County Amed Aviation and Transport Admin 56500 10905D1 154000 765031 Interest Expense 145,834.00 250,00000 250,000.00 E County Airport Aviation and TransportAdmin 56500 1090501 154000 773630 Info Tech Development 4,01100 7.00000 71000.00 E County Airport Aviation and Transport Admin 56500 1090501 154000 T4636 Info Tech Operations 23,76800 40,745.00 40,74500 E County Airport Aviation and Tarpon Admin 56500 1090501 154000 774637 Info Tech Managed Print Svcs 2,01900 3,461.00 3,46100 E County Airport Aviation and Transport Atlmm 56500 1090501 154000 T'46T7 Insurance Fund 5,648.00 9,82800 9.T7300 E County Airport Aviation and Transport Animist 56500 1090501 154000 M560 Radio Communications 7.941 13,61600 13,61800 E County Airport Aviation and Transport Admm 56500 1090501 154000 778675 Telephone Communications 6,53000 11,19300 11,19300 E CountyArport Aviation and Transport Admin 56500 1090501 154010 T02010 Salaries Regular 591,52800 1,045,38400 1.OA,52900 E County Airport Aviation and Transport Admm 56500 1090501 154010 702130 Shift Premium 2,04200 3,500.0D 3,50000 E CountyArport Aviation and Transport Admin 56500 1090501 154010 702180 Emergency Salaries 6,59200 11,300.00 11,30000 E County AiTcA Aviation and Transport Admin M500 1090501 154010 712020 Overtime 55,41700 95,000.00 95,00000 E County Airport Aviation and Transport Admin 56500 1090501 154010 712040 Holiday Overtime 18,667.00 32000DO 32000.00 E County Airport Aviation and Tansport Admin 56500 1090501 154010 722750 Workers Compensation 11,60800 19,89900 19S99DO E County Airport Aviation and Transport Atlmin 56500 1090501 154010 =760 Group Life 1,205.00 2,06500 2065.00 E CountyArport Aviation and Transport Atlmin 565M 1090501 1MO10 722T70 Retirement 144,303.00 247,375.00 247,375.00 E County Airport Aviation and TransportAdmm 56500 1090501 154010 722780 Hospitalization 88,269.00 151,318.00 151,318 On E County Arport Aviation and Transport Admit 56500 1090501 154010 722790 Social Security 42,824.00 73,41100 73,41100 E County Airport Aviation and Transport Admin 56500 1090501 154010 722800 Dental 8,85400 15,17700 15,177.00 E County Airport Aviation and Transport Admin 55500 1090501 154010 722810 Disability 8,746 DO 14,99300 14,99300 E County Airport Aviation and Transport Achim 56500 1090501 15ai 722620 Unemployment Insurance 58400 1,001.00 1,0010D E County Arport Avmtion and Transport Admin 56500 1090501 154010 172850 Optical 790.00 1,35300 1,35300 E OountyAirport Aviation and Transport Admin 56500 1090501 154010 722900 Fringe Benefit Adjustments 1876100 47,627-00 62,15200 E CountyArport Aviation and Transport Admin 56500 1090501 154010 73019E Building Maintenance Charges 49,584.00 85,00000 85,00000 E CountyPorport Aviation and Transport Admm 56500 1090601 154010 730324 Communications 2,33400 4,00000 4,00000 E County Airport Aviation and Transport Admin 56500 1090501 154010 730429 Custodial Services 758400 13,000.00 13.00000 E County Amort Aviation and Transport Admm M500 1090501 twin 730562 Electrical Service 122.500.D0 210,000.00 210,00000 E County Airport Aviation and Transport Admin 56500 1090501 154010 730611 Employees Medical Exams 46700 80000 Soo D0 E County Airport Aviation and Transport Admin 56500 1090501 154010 730646 Equipment Maintenance 87,50000 150,00000 150,00000 E County Arport Aviation and Transport Armin 56500 1090501 154010 730786 Garbage and Rubbish Disposal 4,08400 7,00000 7,00000 E County Airport Aviation and Transport Atlmin 56500 1090501 154010 730814 Grounds Maintenance 163,33400 280,00000 280,OD000 E County Airport Aviation and Transport Admin 56500 1090501 154010 731059 Laundry and Cleaning 2,392.00 4,10000 4,10000 E County Airport Aviation and Transport Atlmin 56500 1090501 154010 731115 Licenses and Permins 1,167.00 2,00000 200000 E County Arport Aviation and Transport Admin 56500 1090501 154010 73145E Professional Services 5,131 10,000DO 10.00000 Oakland County, Michigan COUNTY EXECUTIVE -TRANSFER OF POSITIONS AND DELETION OF CENTRAL SERVICES DEPARTMENT AND CREATION OF PERFORMANCE MANAGEMENT POSITIONS Schedule "A" DETAIL -AIRPORT FUND Operotin) Funtl Budget Yrotectl WE Fund Name Division Name Funtl# Division# Pro ram# g Account# Unit OU Affiliate Reference Unit I I E County Airport Aviation and Transport Admin 56500 1090501 154010 731654 E County Airport Aviation and Transport Admin 56500 1090501 154010 731689 E County Airport Aviation and Transport Admin 56600 1090501 154010 731941 E CountyArport Aviation and Transport Admin 56500 1090501 154010 732102 E County Airport Aviation and Transport Admin 56500 1090501 154010 732151 E County Arport Aviation and Transport Admin 56500 1090501 154010 750119 E CountyAirport Aviation and Transport Admin 56500 1090501 154010 750133 E County Arport Aviation and Transport Admin 56500 1090501 154010 750140 E CountyAryort Aviation and Transport Admin 56500 1090501 154010 750196 E County Airport Aviation and Transport Admin 56500 1090501 154010 750210 E County Airport Aviation and Transport Admin W500 1090501 154010 750224 E CountyAiryort Aviation and Transport Admin 56500 1090511 154010 750287 E County Aryort Aviation and Transport Admin 56500 1090501 1MO10 750504 E CountyAiryort Aviation and Transport Admin 56500 1090501 154010 750511 E CountyAryort Aviation and Transport Admin 56500 1090501 154010 761007 E County Airyort Aviation and Transport Admin 56500 1090501 154010 761049 E County Airport Aviation and Transport Admin 56500 1090501 154010 7610M E County Airport Aviation and Transport Admin 56500 1090501 154010 761121 E County Airport Aviation and Transport Achim 56500 1090501 154010 761156 E County Airport Aviation and Transport Achim 56500 1090501 154D10 TT1639 E County Airport Aviation and Transport Atlmm 56500 1090501 154010 774637 E County Airport Aviation and Transport Admin 56500 1090501 154010 TT46T7 E CountyAryort Aviation and Transport Admin 56500 10905DI 154010 775754 E County Arport Aviation and Transport Admin 56500 109MOI 154010 776659 E County Airport Aviation and Transport Atlmm 56500 1090501 154010 TT6661 E County Airport Aviation and Transport Admin 56500 1090501 154010 A8675 E CountyAryort Aviation and Transport Admin 56500 1090501 154040 778675 E County Achort Aviation and Transport Admm 56500 1090501 154C90 T32067 E County Airport Aviation and Transport Admin 56500 1090501 154090 732102 E CountyAirport Oakland Troy Airport 56500 1090502 154000 7746T E County Airport Oakland Troy Airport 56500 1090502 154010 702010 E County Airport Oakland Troy Airport 56500 1090W2 154010 722750 E County Airport Oakand Troy Airport 56500 1090502 154010 7=0 E Coumy Airport Oakland Troy Arport 56500 1090502 1WHO 722790 E County Airport Oakland Troy Arport 56500 1690502 154010 722820 E County Arport Oakland Troy Airport 56500 1090502 154010 TT4636 E County Airport Oakland Troy Airport 56500 1090502 154010 n4 n E CpurityAinard Oakland Troy Airport 56500 1090502 154010 7786T5 E County Airport Oakland Southwest Airport 56500 1090503 154000 7746TT E County Airport Oakland Southwest Airport 56500 1090503 154010 702010 E County Airport Oakland Southwest Airport 56W0 1090503 154010 722750 E CountyAryort Oakand Southwest Airport 56500 1090503 154010 722T60 E CountyAryort Oakland Southwest Arport 56500 1090503 154010 7=70 E County Airport Oakland Southwest Airport 56500 1090503 154010 722780 E Couny Arport Oakland Southwest Airport W500 1090503 154010 722790 E County Arport Oakland Southwest Arport 56500 1090503 15401D 722800 E County Airport Oakland Southwest Arport 56500 1090503 154010 722810 E County Airport Oakland Southwest Arport 56500 1090503 154010 T22820 E County Airport Oakland Southwest Arport 56W0 1090503 154010 M850 E County Aryort OeMand Southwest Airport 56W0 1090503 154010 T74636 E CountyAryort Oakland Southwest Airport 56500 1090503 154010 774677 E County Airport Oakland Southwest Arport 56500 1090503 154010 7T86T5 Project# Activity) Analysis) Account Title Amendment Amendment Amendment Runway and Taxiway Repairs 23.33400 40,000.00 40,000 GO Seconty Expense 11,66700 20,000.00 20,00000 Training 2,917 OD 5,00000 5,0ODDO Water and Sewage Charges 32,66700 56,000.00 56,000.00 Window Cleaning Service 2,91700 5,00000 5,00000 Dry Goods and Clothing 4,084.00 5000.00 5,00000 Electrical Supplies 17.50000 30,000.00 30,00000 Employee Footwear 1.57500 700.00 70000 Firefighting Supplies 7,00000 12,00000 12,000.00 Gasoline Charges 37,91700 65,00000 65,000.00 Grounds Supplies 11,66T 00 2OODCOO 20DOODO Maintenance Supplies 11,66T 00 20,00000 2000000 Small Tools 2,91700 5,00000 5.00000 Special Event Supplies 2,91700 5,ODOOD 5,000.00 Depreciation Land Improvement: 778,475.00 1,275,609.00 1,163.99500 Depreaahon Roads Parking Lot 212,299.00 219,904.OD 156,84900 Depmc.bon Bmldings 471,67200 819,21300 814,11700 Depreciation Equipment 70,84900 378,73700 378,4M 00 Depreciation Vehicles 27,40800 68,35600 91,931.00 Drain Equipment 1,16700 2,00000 2,00000 Into Tech Managed Print Svcs 30.00 51XO 5100 Insurance Fund 110,54700 197,60200 198,648.00 Maintenance Department Charge 1,16TOO 2,00.00 2.000.00 Motor Pool Fuel Charges 63.00 10700 10700 Motor Pool 6,56100 11,24TOO 11,247 00 Telephone Communicators 3,766.00 6,45600 6p5600 Telephone Communications TM 00 2,09600 2,096CO US Customs Serves 157,500.00 315,00DOO 315DDD.00 Water and Sewage Charges - Insurance Fund 354.00 61500 612.00 Salaries Regular 39,553 OD 69,160.00 70,5,300 Workers Compensation 77300 1,32400 1,324.00 Retirement 1108800 1,86400 1,BM 00 Social Security 574.00 984.00 9" 00 Unemployment Insurance 4000 6900 68CO I Ofo Tech Operations 74500 1,2A 00 1,2TL00 I nsurance Fund 6,92600 12,10100 12,022.00 Telephone Communications 885.00 1516CO 1,51600 Insurance, Fund 35200 611.00 60800 Salaries Regular 56,567.00 98,91200 100,89100 Workers Compensation 1.34000 2,29600 2,29600 Group Life W 00 95.00 95.00 Retirement 8,188.00 14CXOO 14,036.00 Hospitalntion 2,73500 4,68800 4,68800 Social Security 2,385.00 4,08700 4.08700 Dental 273.00 46700 46700 Disability 402.00 68800 68800 Unemployment Insurance 5600 96.00 96CO Optical 3000 50.00 50.00 Info Tech Operations 3,59200 6,157.00 5,15700 Insurance Fund 3,475.00 6,185CO 6,14400 Telephone Communications 21200 36300 36300 $ 4,360,860 00 $ 7 674 345 00 $ L578.649 00 Total Expenses $ - $ - $ - COUNTYfrOAKLANDY M ICHIGAN OAKLAND COUNTY EXECUTIVE DAVID COULTER To: Commissioner Kristen Nelson, LAGO Chair Commissioner Gwen Markham, Finance Chair Chairman Dave Woodward, Board of Commissioners From: April M. Lynch, Deputy County Executive Date: January 10, 2022 Re: Re -alignment of the Central Services Department Dave VanderVeen, Director of Central Services is retiring from Oakland County after 55 years of dedicated service. As we have been anticipating his retirement the Executive Office has been reviewing any possible adjustments due to his departure. It has been recommended that the following re -organization be implemented: • Transfer Support Services, which includes, the garage, mail room and records retention to Facilities Management. • Transfer the Airport to Deputy County Executive Sean Carlson to create more alignment with Economic Development Given these transfers we are recommending that we eliminate the Central Services Department and the Director of Central Services position. The Executive Office will continue to name Dave VanderVeen to the Parks and Recreation Board and the Airport Board and will continue to retain Mr. VanderVeen as a part-time advisor. Upon elimination of this director position, we are requesting to create two new positions that will focus on the County's strategic framework and key performance indicators. As we discussed during the last budgetyear process the Executive Office is developing a strategic framework that focuses both external and internal efforts to better meet the needs of our residents. As part of this process, each department will be establishing department level and service level goals. Key Performance Indicators (KPI) will be required of all departments within the Executive Office and will be required to support goals and superior customer service. KPI's will assist in alignment with resources and funding during the budget process and will be key into building a high performing organization. Performance management software will be utilized to create both internal and external dashboards. The public will be able to track the progress of the strategic framework KPIs. Attached is a request for two positions to support this new performance management system, a Strategic Management Coordinator, and a Data Analyst. These positions will be key support for our departments to assist in data reporting, analysis, measurement, and general assistance in ensuring that departments are meeting their goals. This unit will be responsible for all data management, the dashboard and reporting status. They will be key into implementing the Strategic Framework, to ensuring that our work is transparent and accountable to our residents, to creating training programs and strategies to address low performing areas and supporting our departments in moving Oakland County forward. Attached are the job descriptions for the new positions, both will be merit positions and will report to a Deputy County Executive. 2100 Pontiac Lake Rd, 41 W I Waterford, MI 48328 1 tel (248) 858-0480 1 fax (248) 452-9215 1 OakGov.com REQUEST: 1. Create two (2) new Merit classifications 2. Create two (2) FTE and one (1) PTNE GF/GP funded position 3. Delete one (1) FTE GF/GP Director Central Services position (#030101-01499) 4. Transfer the Support Services Division and all associated positions from the Central Services Department to the Facilities Management Department. 5. Transfer the Aviation & Transportation Division and all associated positions from the Central Services Department to the Economic Development Department. 6. Delete the Central Services Department PROPOSED FUNDING: Deletion of the Director Central Services position will offset the cost of this proposal. OVERVIEW: The Executive Office has been reviewing possible adjustments in respect to the retirement of the Director of Central Services. It has been recommended that the following re -organization be implemented: e Transfer Support Services, which includes, the garage, mail room and records retention to Facilities Management. e Transfer the Airport to Deputy County Executive Sean Carlson to create more alignment with Economic Development It is recommended to eliminate the Central Services Department and the Director of Central Services position. The Executive Office will continue to name Dave VanderVeen to the Parks and Recreation Board and the Airport Board and will continue to retain Mr. VanderVeen as a part-time advisor. Upon elimination of this director position, it is requested to create two new positions that will focus on the County's strategic framework and key performance indicators. As we discussed during the last budget year process the Executive Office is developing a strategic framework that focuses both external and internal efforts to better meet the needs of our residents. As part of this process, each department will be establishing department level and service level goals. Key Performance Indicators (KPI) will be required of all departments within the Executive Office and will be required to support goals and superior customer service. KPI's will assist in alignment with resources and funding during the budget process and will be key into building a high performing organization. Performance management software will be utilized to create both internal and external dashboards. The public will be able to track the progress of the strategic framework KPIs. COUNTY EXECUTIVE RECOMMENDATION: Recommended as Requested. PERTINENT SALARIES FY 2022 Class I Gr Freq 1 12 I 24 36 46 6 0 72 84 Director Central Services 337 Annual 138,353 145'069 151,785 158,501 165,217 171,933 178,649 185,365 Performance Management 1125 Annual 77,041 80,780 84,520 88,259 92,000 95,739 99,479 103,219 Coordinator Performance Management 1113 Annual 42,899 44,982 47,064 49,146 51,229 53,311 55,394 57,476 Data Analyst Project Advisor 1223 Hourly 33.5950 34.7140 135.8329 136.9523 38.0713 39.1902 *Note: Annual rates are shown for illustrative purposes only. SALARY AND FRINGE BENEFIT SAVINGS **Note: Fringe benefit rates displayed are County averages. Annual costs are shown for illustrative purposes only. Actual costs are reflected in the budget amendment. Delete one (1) FTE Director Central Services Salary at Grade 337 step 48 $165,217 Service Increment at 10% $16,522 Fringe Benefits at 35.01% $63,627 Direct Contract Charge $11,744 Savings ($257,110) Create one (1) FTE Performance Management Coordinator Salary at Grade 125 step 84 $103,219 Fringe Benefits at 35.01% $36,137 Direct Contract Charge $11,744 Cost $151,100 Create one (1) FTE Performance Management Data Analyst Salary at Grade 113 step 12 $42,839 Fringe Benefits at 35.01% $14,998 Direct Contract Charge $11,744 Cost $69,581 Create one (1) PTNE 1,000 hours/year Project Advisor Salary at Grade 223 step 36 $36,952 Fringe Benefits at 5.38% $1,988 Cost $38,940 TOTAL COST $2,511 DRAFT 12/03/21 OAKLAND COUNTY MICHIGAN Class Title: PERFORMANCE MANAGEMENT COORDINATOR Department: County Executive Administration Reports To: Deputy County Executive FLSA: Non -Exempt Salary Plan: UNI/118 or 121 GENERAL SUMMARY Responsible for updating and maintaining the Oakland County Strategic Plan, including development of the final report. Conducts qualitative and quantitative evaluations of program activities of County Executive departments to determine whether identified KPIs are being met and to determine program effectiveness and efficiency. Prepares and presents a comprehensive analysis, identifying areas where improvements could be made, and the best practices for accomplishing the task. Oversees the scheduling of all Performance Management meetings including agenda preparation and review, and development of presentation materials for meetings. Assists in conducting community outreach, collecting, and analyzing response data, and creating action plans to achieve goals identified as a result of this research. Oversee onboarding of software to track indictors, and the incorporation of performance dashboard on the County website. Conducts research best practices for conducting community surveys and provides recommendations to help design and carry out special projects as indicated by needs within assigned areas. Utilizes current Countywide and/or department specific software to complete assignments. SUPERVISION EXERCISED Functions as a leader over technical and paraprofessional staff. Instructs, assigns, and reviews the work product. ESSENTIAL JOB FUNCTIONS Acts as liaison between the County Executive and County Executive departments to oversee the successful coordination of department KPIs and Department Service KPI program objectives and initiatives. Coordinate training, implementation, and completion of the KPI project, including working with HR on available organization trainings. Monitor performance management implementation and recommend improvements Oversees the onboarding of software to track indictors and the incorporation of the performance dashboard on the website. CLASS TITLE: PERFORMANCE MANAGEMENT COORDINATOR Analyzes economic and demographic data provided by County Executive departments, summarizes results, and prepares multimedia reports and presentations. Oversee the scheduling of all Performance Management meetings including: • Weekly Executive Leadership meetings • Monthly Strategic Leadership meetings • Twice Monthly OakStat meetings • Goal Group meetings Prepares agendas and creates written and digital presentation materials for review by the County Executive. Oversees the update and maintenance of the Oakland County Strategic Plan to assist in determining future direction of assigned program. Works with Deputy County Executives in conducting community outreach, analyzing, and summarizing community indicator data, and assisting in creating actions plans to achieve goals. Research method used by other jurisdictions to determine (both how they handle their stat meetings, and how they handle their websites). Research entities that conduct the public survey on customer satisfaction and makes recommendations on best practices for obtaining this data point for Community Indicators. Utilizes current Countywide and/or department specific software to complete assignments ESSENTIAL MENTAL & PHYSICAL REQUIREMENTS. Ability to communicate to accurately convey information. WORKING CONDITIONS Work is performed in a typical office setting. IMPORTANT NOTE: The primary purpose of this job description is to set a fair and equitable salary range for this job classification. Generally, only those key duties necessary for proper job evaluation and/or labor market analysis have been included. Other duties and responsibilities will be assigned by the supervisor. CLASS TITLE: PERFORMANCE MANAGEMENT COORDINATOR EXPERIENCE, TRAINING. KNOWLEDGES. SKILLS & ABILITIES A. REQUIRED MINIMUM QUALIFICATIONS 1. Possess a Bachelor's degree from an accredited college or university with a preferred major in Business Administration, Public Administration, Political Science, or closely related field of study. 2. Have at least five (5) years of full-time professional work experience in market research, social science or public policy research or a closely related area. NOTE: Applicants possessing transcripts from a college or university outside of the United States will be required to provide documentation of degree equivalency from a member of the National Association of Credential Evaluation Services (httD://naces.ore/members.html). The degree evaluation will be required for application processing. NOTE: A Master's degree from an accredited college or university with a major in a field listed above may be substituted for two (2) years of the required work experience. 3. Pass the complete examination, including the employment medical, established for this classification. 4. Successfully complete the six-month probationary period. B. ADDITIONAL DESIRABLE QUALIFICATIONS 1. Considerable ability to develop and maintain effective working relationships with employees, representatives of other agencies, and the general public. 2. Considerable ability to plan and implement an on -going system of program evaluation activities. 3. Considerable knowledge of and ability to apply modern management practices and techniques to the collection and utilization of program data. 4. Considerable ability to prepare and present technical written and oral reports. 5. Considerable ability to prepare and present oral and written reports to supervisors. 6. Reasonable ability to utilize current word processing, spreadsheet, database, e-mail, and Internet software. 3 DRAFT 01/04/22 OAKLAND COUNTY MICHIGAN Class Title: PERFORMANCE MANAGEMENT DATA ANALYST Department: County Executive Administration Reports To: Performance Management Coordinator FLSA: Non -Exempt Salary Plan: UNI/113 GENERAL SUMMARY Responsible for implementation of a county performance management system. Supports the County Executive's leadership team in the effective use of data to make informed decisions on the County's programs and services. This position is responsible for collecting, analyzing, managing, and presenting data related to the County's priorities and key performance indicators (KPIs). Assists the scheduling of all Performance Management meetings including agenda preparation and review, and development of presentation materials for meetings. Works with County departments to develop KPI dashboards. Provides technical support to departments in the use of Performance Management software. Utilizes current Countywide and/or department specific software to complete assignments. SUPERVISION EXERCISED None ESSENTIAL JOB FUNCTIONS Assists in development of performance metrics for County departments and services. Collaborates with department leaders and staff to document data sets, data collection, and reporting requirements. Collects, analyzes, and interprets data and information from County Departments, information systems, and other sources. Monitors progress towards priorities, identifies problem areas and collaborates on potential solutions. Works with County departments and key program areas to develop dashboards to track key performance indicators. Assists Performance Management Coordinator in developing agendas and presentations for monthly OakStat meetings. CLASS TITLE: PERFORMANCE MANAGEMENT COORDINATOR Provides technical assistance to County departments on Performance Management software. Coordinates with other departments on integration of performance measurement dashboard on Oakgov.com. Utilizes current Countywide and/or department specific software to complete assignments. ESSENTIAL MENTAL & PHYSICAL REQUIREMENTS Ability to communicate to accurately convey information. WORKING CONDITIONS Work is performed in a typical office setting. IMPORTANT NOTE: The primary purpose of this job description is to set a fair and equitable salary range for this job classification. Generally, only those key duties necessary for proper job evaluation and/or labor market analysis have been included. Other duties and responsibilities will be assigned by the supervisor. EXPERIENCE. TRAINING, KNOWLEDGES, SKILLS & ABILITIES A. REQUIRED MINIMUM QUALIFICATIONS, 1. Possess a Bachelor's degree from an accredited college or university with a preferred major in Business Administration, Public Administration, Political Science, or closely related field of study. 2. Have at least two (2) years of full-time professional work experience in performing data analysis and interpretation, program evaluation, and/or process improvement or a closely related area. NOTE: Applicants possessing transcripts from a college or university outside of the United States will be required to provide documentation of degree equivalency from a member of the National Association of Credential Evaluation Services (htto://naces.orQ/members.html). The degree evaluation will be required for application processing. NOTE: A Master's degree from an accredited college or university with a major in a field listed above may be substituted for two (2) years of the required work experience. 3. Pass the complete examination, including the employment medical, established for this classification. 2 CLASS TITLE: PERFORMANCE MANAGEMENT COORDINATOR 4. Successfully complete the six-month probationary period. B. ADDITIONAL DESIRABLE QUALIFICATIONS 1. Considerable critical thinking and problem -solving skills. 2. Considerable ability to plan and organize projects and workload. 3. Considerable ability to conduct in-depth research. 4. Considerable ability to prepare and present oral and written reports to supervisors. 5. Considerable ability to utilize current word processing, spreadsheet, database, e-mail, and Internet software. 3 OAKLAND COUNTY MICHIGAN Class Title: PROJECT ADVISOR Department: Interdepartmental Reports To: Assigned Supervisor A. DESCRIPTION GENERAL SUMMARY Under direction, is responsible for preparing recommendations regarding proposals, projects, policies and procedures to departmental managers. Initiates, plans and recommends techniques and procedures for completing projects and assignments. Advises staff on the most effective process to complete assignments. Reviews and consults on day -to day problems, policies and procedures with appropriate supervision. Utilizes current county -wide and/or department specific software to complete assignments. SUPERVISION EXERCISED Functions as an advisor to departmental employees, management and contractors regarding departmental projects. Recommends to departmental supervisors improvement projects. TYPICAL DUTIES AND RESPONSIBILITIES Provides technical and general support for a division, section or unit of a department. Performs liaison duties between lower level employees, administrative personnel and contractors/ vendors. Answers a variety of public inquiries about divisional procedures by giving out information requiring general interpretations and familiarity with divisional operations. Provides advice to departmental representatives regarding projects and objectives according to established budgetary procedures. Provides assistance to assigned departmental representatives on various fiscal, business, and/or personnel issues in current and proposed programs. Determines and suggests new procedures to respond to changing needs and implements procedures. Confers with supervisor regarding division policies and procedures and ensures they are followed by staff. Conducts research, prepares reports, and writes proposals to obtain grant funding. Utilizes current county -wide and/or department specific software to complete assignments. WHEN ASSIGNED TO PARKS & RECREATION Assists in coordinating master planning efforts in assigned area. Verifies current maintenance standards are followed. Class Title: Project Advisor Page A2 Participates in cost recovery and gap analysis efforts within the Oakland County Parks and Recreation Department. Meets and reviews day-to-day operations, problems, policies, and procedures with various supervisors. Establishes and maintains park maintenance work schedules and procedures designed to minimize interference with the public using the County park. Conducts frequent inspections of park facilities, including beach, banquet rooms, restrooms, and camping areas to ensure that park personnel appear neat and are performing their duties, that park areas are clean and orderly, that park rules and regulations are being observed, and that construction work of outside contractors is being performed according to specifications. Advises communication staff with the design and implementation of media programs for classes, tours, and special events for the public or particular groups to promote usage, understanding and acceptance of Parks and Recreation properties, facilities, projects, programs and activities. Assists in the coordination of public information and advertising activities for the Parks and Recreation Division in various types of County -wide media such as newspapers, TV and radio broadcasts. Answers public inquiries including information about locations, activities and charges for park and other County parks. Speaks to civic organizations and interested citizens to inform the public of park regulations and available recreation facilities. Utilizes current county -wide and/or department specific software to complete assignments. APPROVED BY 4i DATE: 02/12/09 IMPORTANT NOTE: The primary purpose of this job description is to set a fair and equitable salary range for this job classification. Generally, only those key duties necessary for proper job evaluation and/or labor market analysis have been included. Other duties and responsibilities will be assigned by the supervisor. OAKLAND COUNTY MICHIGAN Class Title: PROJECT ADVISOR Department: Interdepartmental Reports To: Assigned Supervisor B. QUALIFICATIONS EXPERIENCE, TRAINING, KNOWLEDGES, SKILLS & ABILITIES A. REQUIRED MINIMUM QUALIFICATIONS 1. Possess a Bachelor's degree with a major in an area related to the function of the assigned department. 2. Have had at least five (5) years of full-time technical or professional level experience in an area related to the function of the assigned department. NOTE: Additional experience of the type described above may be substituted for the college degree on a year -for -year basis. 3. Possess a valid operator's or chauffeur's license. 4. Pass the complete examination including the employment medical established for this class. B. ADDITIONAL DESIRABLE OUALIFICATIONS Considerable knowledge of departmental operations. 2. Familiar with current word processing, spreadsheet, database, e-mail and Internet software. SPECIAL REOUIREMENTS Maintain a valid vehicle operator's or chauffeur's license. APPROVED BY: L?/ e PATE: 02/12/09