FYE_06.30.23_thru_06.30.25_Auto_Parking_Fund.pdf

10/27/2025 BUDGET REPORT FOR CITY OF ROYAL OAK

Calculations as of 06/30/2025

2022-23 2022-23 2022-23 2023-24 2023-24 2023-24 2024-25 2024-25 2024-25

ORIGINAL AMENDED ACTIVITY ORIGINAL AMENDED ACTIVITY ORIGINAL AMENDED ACTIVITY

GL NUMBER DESCRIPTION BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET THRU 06/30/25

Fund 516 - AUTO PARKING

ESTIMATED REVENUES

Dept 000 - NON-DEPARTMENTAL revenue 516-000-52800 FEDERAL GRANTS - OTHER revenue 516-000-52800.ARPA000 FEDERAL GRANTS - OTHER 1,000,000 revenue 516-000-53900 STATE GRANTS revenue 516-000-53900.MEDC000 STATE GRANTS 300,000 300,000 300,000 revenue 516-000-65101 PAY AND DISPLAY - FARMERS MARKET 2,920 2,920 19 100 100 224 300 300 revenue 516-000-65200 SEVENTH & MAIN LOT METERS revenue 516-000-65201 5TH & WILLIAMS LOT METERS 60,000 60,000 8,642 15,500 15,500 551 1,000 1,000 revenue 516-000-65202 SHERMAN DRIVE LOT METERS 200,000 200,000 15,557 26,200 26,200 25,000 25,000 revenue 516-000-65203 WILLIAMS LOT METERS 2,000 2,000 revenue 516-000-65204 SIXTH STREET LOT METERS 55,000 55,000 7,916 16,700 16,700 15,000 15,000 revenue 516-000-65205 SECOND STREET LOT METERS revenue 516-000-65206 4TH & LAFAYETTE STRUCTURE METER/LOT FEES revenue 516-000-65207 NORTH & SOUTH CENTER LOT METERS 7,000 7,000 1,035 1,500 1,500 4,218 3,000 3,000 3,564 revenue 516-000-65209 STREET METER FEES 1,800,000 1,800,000 1,554,317 1,512,000 1,797,000 1,825,785 1,880,000 1,880,000 1,766,739 revenue 516-000-65211 MONTHLY PARKING PERMIT FEES 4,000 4,000 360 2,705 revenue 516-000-65213 THIRD & WILLIAMS LOT METERS 70,000 70,000 22,955 38,400 38,400 30,000 30,000 revenue 516-000-65214 FARMERS MARKET LOT METERS 10,000 10,000 1,389 12,290 15,000 15,000 10,140 revenue 516-000-65215 MAIN & 7TH 129,000 129,000 31,114 28,700 28,700 35,835 38,000 38,000 33,660 revenue 516-000-65216 MAIN & 7TH (SOUTH OF 7TH) 4,775 9,700 9,700 645 1,000 1,000 revenue 516-000-65301 ATTENDANT PARKING - CENTER ST 760,000 760,000 373,089 341,700 341,700 446,518 591,100 416,100 416,162 revenue 516-000-65302 ATTENDANT PARKING - 4TH & LAFAYETTE 88,000 88,000 84,465 73,800 73,800 129,795 158,600 118,600 111,460 revenue 516-000-65303 ATTENDANT PARKING - 6TH & LAFAYETTE 380,000 380,000 191,896 199,700 199,700 180,941 213,600 173,600 170,694 revenue 516-000-65306 ATTENDANT PARKING -11 MILE 760,000 760,000 106,310 9,770 196,320 195,730 377,400 167,400 166,716 revenue 516-000-65401 PERMIT PARKING - CENTER ST 555,000 555,000 517,830 498,300 498,300 508,122 548,400 458,400 442,500 revenue 516-000-65402 PERMIT PARKING - 4TH & LAFAYETTE 440,000 440,000 253,180 254,900 254,900 259,214 273,000 198,000 211,140 revenue 516-000-65403 PERMIT PARKING - 6TH & LAFAYETTE 353,000 353,000 231,690 247,700 247,700 265,199 272,600 224,600 233,270 revenue 516-000-65404 PERMIT PARKING - LOT METERS 76,000 76,000 12,259 3,800 3,800 12,910 15,400 15,400 15,510 revenue 516-000-65405 PERMIT PARKING - FARMERS MARKET 100 100 revenue 516-000-65406 PERMIT PARKING - 11 MILE 285,000 285,000 233,210 168,000 313,000 328,040 416,900 321,900 371,765 revenue 516-000-65501 PARKING VALIDATION FEES 20,000 20,000 46,673 28,600 28,600 23,339 32,800 2,800 1,614 revenue 516-000-65502 AMTRAK PARKING FEES 3,000 3,000 1,655 2,100 2,100 1,290 1,600 1,600 1,350 revenue 516-000-65503 VALET PARKING FEES revenue 516-000-66500 INTEREST 1,000 1,000 2,047 4,620 4,620 21,136 48,692 revenue 516-000-66510 LEASE INTEREST 14,248 13,708 13,123 revenue 516-000-66708 TOWER LEASE 32,100 32,100 17,849 33,060 33,060 19,352 34,100 34,100 20,930 revenue 516-000-67000 LEASE REVENUE 6,420 6,420 4,280 6,420 6,420 6,420 6,700 6,700 6,420 revenue 516-000-67100 MISCELLANEOUS REVENUE 11,125 18,889 20,600 20,600 29,250 revenue 516-000-69301 GAIN ON SALE OF FIXED ASSETS revenue 516-000-69400 CASH OVER AND SHORT revenue 516-000-69498 TRANSFER FROM 498 500,000

N/A 516-000-69700 USE OF FUND BALANCE 1,649,736 196,835

transfers 516-000-69901 TRANSFER FROM GENERAL FUND 1,000,000 1,000,000 500,000 500,000 transfers 516-000-69902 TRANSFER FROM GRANTS transfers 516-000-69921 TRANSFER FROM MAJOR STREETS transfers 516-000-69941 TRANSFER FROM TIFA 581,000 581,000 594,548 586,600 2,086,600 2,086,554 586,000 1,289,000 1,288,459 transfers 516-000-69943 TRANSFER FROM CAPITAL PROJECTS 628,450 632,859 transfers 516-000-69946 TRANSFER FROM ARPA - 460 2,500,000 2,500,000 transfers 516-000-69962 TRANSFER FROM WC INSURANCE FUND transfers 516-000-69968 TRANSFER FROM MED INSURANCE transfers 516-000-69969 TRANSFER FROM GENERAL LIABILITY

TOTAL <None> - Unclassified 6,680,540 6,680,540 5,344,073 5,757,606 10,652,870 10,829,924 6,057,100 6,453,935 5,865,863 Totals for dept 000 - NON-DEPARTMENTAL 6,680,540 6,680,540 5,344,073 5,757,606 10,652,870 10,829,924 6,057,100 6,453,935 5,865,863

TOTAL ESTIMATED REVENUES 6,680,540 6,680,540 5,344,073 5,757,606 10,652,870 10,829,924 6,057,100 6,453,935 5,865,863

APPROPRIATIONS

Dept 316 - PARKING ENFORCEMENT personnel 516-316-70203 WAGES - PERMANENT 12,875 12,875 790 5,741 5,741 personnel 516-316-70204 WAGES - TEMPORARY 176,867 176,867 214,714 289,550 289,550 238,120 300,000 300,000 264,683 personnel 516-316-70300 WAGES - OVERTIME personnel 516-316-70401 LONGEVITY PAY personnel 516-316-70402 SICK LEAVE PAY 130 130 130 130 personnel 516-316-70500 DEFERRED COMP - EMPLOYER CONTRIBUTION 193 193 20 86 86 personnel 516-316-70602 RETIREMENT CONTRIBUTIONS - UNIFORM 4,137 4,137 429 580 580 personnel 516-316-70603 OPEB CONTRIBUTIONS 1,034 1,034 402 358 358 personnel 516-316-70605 PENSION - UAL - UNIFORM 7,537 7,537 521 2,947 2,947 personnel 516-316-70606 OPEB - UAL 1,102 1,102 278 802 802 personnel 516-316-70610 DEFINED CONTRIBUTION personnel 516-316-70902 UNIFORM/CLEANING ALLOWANCE 2,600 2,600 1,950 2,925 2,925 2,600 3,900 3,900 2,275 personnel 516-316-71101 FICA 14,169 14,169 16,586 22,670 22,670 18,415 22,000 22,000 20,384 personnel 516-316-71102 UNEMPLOYMENT COMPENSATION TAX 209 209 360 397 397 333 500 500 388 personnel 516-316-71201 GROUP MEDICAL INSURANCE 1,807 1,807 75 978 978 personnel 516-316-71203 GROUP DENTAL INSURANCE 118 118 57 57 personnel 516-316-71204 GROUP LIFE INSURANCE 21 21 1 10 10 personnel 516-316-71205 VISION INSURANCE 24 24 10 10 personnel 516-316-71206 WORKERS COMPENSATION INSURANCE 1,180 1,180 2,854 1,417 1,417 2,664 2,900 2,900 2,568 personnel 516-316-71207 SHORT AND LONG TERM DISABILITY 50 50 2 operating 516-316-73001 UNIFORM CLOTHING & GEAR 3,000 3,000 2,306 3,000 3,000 2,973 5,000 5,000 4,549 operating 516-316-79900 MISCELLANEOUS OPERATING SUPPLIES 10,000 10,000 3,014 10,000 10,000 2,280 10,000 10,000 3,188 operating 516-316-82500 CONTRACTED WORKER SERVICES 1,090,000 1,090,000 785,340 653,100 1,553,100 1,446,052 1,598,524 1,598,524 791,077 operating 516-316-83500 EQUIPMENT REPAIR & MAINTENANCE SERVICES 6,000 6,000 4,700 6,000 6,000 2,000 2,000 operating 516-316-92200 MOTOR POOL VEHICLE RENTALS 15,480 15,480 15,480 17,900 17,900 17,900 16,240 16,240 16,240

TOTAL <None> - Unclassified 1,348,533 1,348,533 1,049,822 1,018,658 1,918,658 1,731,337 1,961,064 1,961,064 1,105,352 Totals for dept 316 - PARKING ENFORCEMENT 1,348,533 1,348,533 1,049,822 1,018,658 1,918,658 1,731,337 1,961,064 1,961,064 1,105,352

Dept 570 - AUTO PARKING personnel 516-570-70203 WAGES - PERMANENT 215,829 215,829 192,021 224,464 224,464 230,342 202,567 202,567 227,529 personnel 516-570-70204 WAGES - TEMPORARY personnel 516-570-70300 WAGES - OVERTIME 40,000 40,000 66,213 45,000 45,000 67,943 68,000 68,000 59,965 personnel 516-570-70401 LONGEVITY PAY 8,266 8,266 7,405 8,234 8,234 8,993 8,651 8,651 9,263 personnel 516-570-70402 SICK LEAVE PAY 4,230 4,230 3,706 2,200 2,200 2,544 3,900 3,900 4,053 personnel 516-570-70407 DUPLICATE HEALTH CARE BENEFITS PAY personnel 516-570-70500 DEFERRED COMP - EMPLOYER CONTRIBUTION 176 176 181 185 185 195 210 210 160 personnel 516-570-70601 RETIREMENT CONTRIBUTIONS - GENERAL 7,497 7,497 4,356 5,757 5,757 55,453 7,394 7,394 48,057 personnel 516-570-70603 OPEB CONTRIBUTIONS 5,202 5,202 15,037 7,232 7,232 (543,183) 11,830 11,830 (142,703) personnel 516-570-70604 PENSION - UAL - GENERAL 10,250 10,250 9,393 10,302 10,302 15,288 18,731 18,731 17,745 personnel 516-570-70606 OPEB - UAL 5,829 5,829 6,424 8,138 8,138 9,873 16,759 16,759 9,506 personnel 516-570-70610 DEFINED CONTRIBUTION 11,931 11,931 9,398 12,735 12,735 11,396 10,137 10,137 10,317 personnel 516-570-70620 RETIREE HSA 3,977 3,977 4,157 5,660 5,660 5,065 4,265 4,265 4,585 personnel 516-570-70901 MEAL ALLOWANCE 300 300 180 250 250 250 250 personnel 516-570-70902 UNIFORM/CLEANING ALLOWANCE 300 300 300 300 300 400 300 300 400 personnel 516-570-70904 DRIVERS LICENSE ENDORSEMENT REIMBURS personnel 516-570-71101 FICA 14,008 14,008 20,164 17,952 17,952 23,160 20,435 20,435 22,239 personnel 516-570-71102 UNEMPLOYMENT COMPENSATION TAX 73 73 104 101 101 98 182 182 109 personnel 516-570-71201 GROUP MEDICAL INSURANCE 54,035 54,035 33,044 45,026 45,026 38,271 34,997 34,997 30,085 personnel 516-570-71203 GROUP DENTAL INSURANCE 3,098 3,098 2,449 3,063 3,063 2,268 2,007 2,007 1,978 personnel 516-570-71204 GROUP LIFE INSURANCE 661 661 548 681 681 632 558 558 512 personnel 516-570-71205 VISION INSURANCE 611 611 310 394 394 330 310 310 249 personnel 516-570-71206 WORKERS COMPENSATION INSURANCE 3,720 3,720 3,552 2,699 2,699 3,345 2,989 2,989 3,397 personnel 516-570-71207 SHORT AND LONG TERM DISABILITY 1,312 1,312 1,138 1,364 1,364 1,399 1,026 1,026 1,286

07/01/2022 - 06/30/2023 07/01/2023 - 06/30/2024 07/01/2024 - 06/30/2025 operating 516-570-72701 OFFICE SUPPLIES 1,200 1,200 276 1,200 1,200 585 1,200 1,200 501 operating 516-570-72702 OFFICE EQUIP/FURNITURE (NON-CAPITALIZED) operating 516-570-73001 UNIFORM CLOTHING & GEAR 750 750 296 750 750 2,167 1,500 1,500 782 operating 516-570-73002 SAFETY CLOTHING & GEAR 1,500 1,500 500 1,500 1,500 510 1,500 1,500 1,567 operating 516-570-73002.COVID19 SAFETY CLOTHING & GEAR operating 516-570-73200 CLEANING & JANITORIAL SUPPLIES 750 750 359 750 750 194 750 750 247 operating 516-570-73300 BUILDING REPAIR & MAINTENANCE SUPPLIES 6,000 6,000 12,255 10,000 10,000 21,001 20,000 20,000 10,809 operating 516-570-73500 EQUIPMENT REPAIR & MAINTENANCE SUPPLIES 6,000 6,000 2,479 6,000 6,000 2,404 6,000 6,000 2,065 operating 516-570-73600 TOOLS & HARDWARE 1,000 1,000 800 1,000 1,000 751 1,000 1,000 1,006 operating 516-570-73800 ELECTRICAL & LIGHTING SUPPLIES 10,000 10,000 3,680 10,000 10,000 1,459 5,000 5,000 1,548 operating 516-570-74500 TREES, SHRUBS & PLANTS operating 516-570-75200 ROAD SALT & ICE MELT COMPOUNDS 10,000 10,000 10,245 10,000 10,000 12,852 10,000 10,000 operating 516-570-75800 PARKING METER PARTS 15,000 15,000 4,127 5,000 5,000 (746) 5,000 5,000 (7,941) operating 516-570-79900 MISCELLANEOUS OPERATING SUPPLIES 30,000 30,000 21,275 30,000 30,000 16,797 30,000 30,000 6,864 operating 516-570-80800 AUDIT SERVICES 2,160 2,160 2,204 2,170 2,170 2,251 2,485 2,485 2,258 operating 516-570-80902 COIN COUNTING SERVICES 8,000 8,000 5,261 8,000 8,000 5,687 8,000 8,000 5,569 operating 516-570-81201 PROPERTY & CASUALTY INSURANCE SERVICES 31,200 31,200 35,489 34,100 34,100 28,847 37,500 37,500 40,038 operating 516-570-81401 CONSTRUCTION ENGINEERING SERVICES operating 516-570-81402 CONSULTING ENGINEERING SERVICES operating 516-570-82500 MISC CONTRACTED SERVICES 520,000 520,000 575,293 520,000 520,000 647,665 620,668 620,668 741,801 operating 516-570-82701 COPIER REPAIR & MAINTENANCE SERVICES operating 516-570-83200 CLEANING & JANITORIAL SERVICES operating 516-570-83301 HEATING/COOLING REPAIR & MAINT SERVICES 233 17,700 operating 516-570-83303 ELEVATOR REPAIR & MAINTENANCE SERVICES 40,000 40,000 105,724 60,000 60,000 60,275 65,000 65,000 80,840 operating 516-570-83399 MISC BUILDING REPAIR & MAINT SERVICES 10,000 10,000 21,469 110,000 110,000 106,153 32,500 32,500 18,467 operating 516-570-83500 EQUIPMENT REPAIR & MAINTENANCE SERVICES 3,000 3,000 255 3,000 3,000 1,200 3,000 3,000 22,690 operating 516-570-84000 GROUNDS REPAIR & MAINTENANCE SERVICES 1,000 1,000 13 66 operating 516-570-85101 ELECTRIC 150,000 150,000 165,416 180,000 180,000 179,676 211,900 211,900 171,275 operating 516-570-85103 GAS 1,600 1,600 611 1,600 1,600 499 600 600 647 operating 516-570-85105 WATER 3,200 3,200 1,304 3,200 3,200 1,997 2,250 2,250 3,864 operating 516-570-85107 TELEPHONE SERVICE 972 1,000 1,000 1,099 1,000 1,000 1,040 operating 516-570-85300 BUILDING SECURITY SERVICES 4,500 4,500 5,146 5,500 5,500 7,289 6,500 6,500 6,671 operating 516-570-85600 PRINTING & DOCUMENT DUPLICATING 300 300 231 300 300 300 300 operating 516-570-86101 TRAINING & EDUCATION 1,227 500 500 195 operating 516-570-89201 PARKING STRUCTURE LEASE operating 516-570-90200 OPEB COST DISTRIBUTION operating 516-570-90201 GROUP MEDICAL INSURANCE (RETIREMENT) operating 516-570-92200 MOTOR POOL VEHICLE RENTALS 30,190 30,190 30,190 26,830 26,830 26,830 32,290 32,290 32,290 isf 516-570-92600 ADMINISTRATIVE CHARGES 87,300 87,300 87,300 87,930 87,930 87,930 103,400 103,400 103,400 isf 516-570-92800 INFORMATION SYSTEMS SERVICE CHARGES 78,100 78,100 78,100 29,840 29,840 29,840 30,390 30,390 30,390 transfers 516-570-93101 TRANSFER TO GENERAL FUND transfers 516-570-93360 TRANSFER TO DEBT FUND-CIBS 2007 transfers 516-570-93498 TRANSFER TO CAPITAL PROJECTS transfers 516-570-93636 TRANSFER TO INFORMATION SYSTEMS transfers 516-570-93661 TRANSFER TO MOTOR POOL operating 516-570-96000 DEPRECIATION 1,230,000 1,230,000 1,236,158 1,240,000 1,240,000 1,239,052 1,240,000 1,240,000 1,239,052 operating 516-570-96100 AMORTIZATION 28,840 28,840 28,837 28,840 28,840 28,837 28,840 28,840 28,837 operating 516-570-96400 BANK SERVICE CHARGES & FEES 400,000 400,000 140,017 400,000 400,000 108,125 160,000 160,000 103,213 operating 516-570-96800 MISCELLANEOUS EXPENDITURES

N/A 516-570-96901 INCREASE IN FUND BALANCE 1,245,700 1,245,700 3,995,264 178,165

capital 516-570-97000 CAPITAL OUTLAY 150,000 150,000 25,000 25,000 capital 516-570-97000.MEDC000 CAPITAL OUTLAY 575,000 capital 516-570-97001 CAPITAL OUTLAY-NON-QUALIFIED 450,000 450,000 capital 516-570-97001.MEDC000 CAPITAL OUTLAY-NON-QUALIFIED 25,040 168,072 debt srvc 516-570-99131 PENSION PRINCIPAL 8,100 8,100 8,500 8,500 8,600 8,600 debt srvc 516-570-99136 OPEB PRINCIPAL 22,500 22,500 23,100 23,100 23,900 23,900 debt srvc 516-570-99531 PENSION DEBT INTEREST 7,800 7,800 6,785 6,600 6,600 6,534 6,300 6,300 6,258 debt srvc 516-570-99536 OPEB DEBT INTEREST 19,000 19,000 18,835 18,500 18,500 18,139 17,500 17,500 17,370 debt srvc 516-570-99600 PARKING BONDS - INT 925,000 925,000 924,479 861,000 861,000 842,152 751,000 751,000 750,667 debt srvc 516-570-99800 LONG-TERM DEBT AGENCY FEES 1,000 1,000 1,000 1,000 1,000 318 1,000 1,000 1,000

TOTAL <None> - Unclassified 5,331,995 5,331,995 3,907,681 4,738,947 8,734,211 3,466,161 4,096,036 4,492,871 3,902,150 Totals for dept 570 - AUTO PARKING 5,331,995 5,331,995 3,907,681 4,738,947 8,734,211 3,466,161 4,096,036 4,492,871 3,902,150

TOTAL APPROPRIATIONS 6,680,528 6,680,528 4,957,503 5,757,605 10,652,869 5,197,498 6,057,100 6,453,935 5,007,502

NET OF REVENUES/APPROPRIATIONS - FUND 516 12 12 386,570 1 1 5,632,426 858,361

BEGINNING FUND BALANCE 17,922,358 17,922,358 17,922,358 18,308,929 18,308,929 18,308,929 23,941,353 23,941,353 23,941,353 ENDING FUND BALANCE 17,922,370 17,922,370 18,308,928 18,308,930 18,308,930 23,941,355 23,941,353 23,941,353 24,799,714

BudgetReport