Fresno City Council
July 21, 2022

MOU Analysis Unit 6 ATU
Impacts Impacts Impacts Impacts Impacts
FY 2023 FY 2024 FY 2025 Total FY 2026 FY 2027
Future
Deferred
Liabilities per
Year
(Cost/Savings)
FY 2023 No. Avg Salary Total Salary Roll-Ups Avg per Total 1 3% Wage Increase - Effective 10/26/2020 (FY21) Employees per Month per Month per Month Employee/ Yr Cost/ Yr ATU Total Budgeted Positions - All Funds 297 4,673 1,387,896 5,576 1,865 554,051 ATU Total Budgeted Positions - All Funds 297 4,673 554,051 1,108,103 554,051 554,051 2,216,205 554,051 554,051 FY 2023 No. Avg Salary Total Salary Roll-Ups Avg per Total 2 3% Wage Increase - Effective 6/21/2021 (FY22) Employees per Month per Month per Month Employee/ Yr Cost/ Yr ATU Total Budgeted Positions - All Funds 297 4,814 1,429,672 5,738 1,920 570,166 ATU Total Budgeted Positions - All Funds 297 4,814 570,166 1,140,332 570,166 570,166 2,280,663 570,166 570,166 FY 2023 No. Avg Salary Total Salary Roll-Ups Avg per Total 3 3% Wage Increase - Effective 6/20/2022 (FY23) Employees per Month per Month per Month Employee/ Yr Cost/ Yr ATU Total Budgeted Positions - All Funds 297 4,959 1,472,757 5,918 1,980 588,036 ATU Total Budgeted Positions - All Funds 297 4,959 588,036 588,036 588,036 588,036 1,764,108 588,036 588,036 FY 2023 No. Total Salary Roll-Ups Avg per Total
4 Longevity Step based on Productivity Employees per Month per Month Employee/ Yr Cost/ Yr ATU Total Budgeted Positions - All Funds 63 17,010 2,390 3,326 209,519 ATU Total Budgeted Positions - All Funds 63 17,010 209,519 209,519 209,519 209,519 628,557 209,519 209,519 FY 2024 No. Avg Salary Total Salary Roll-Ups Avg per Total 5 3% Wage Increase - Effective 6/19/2023 Employees per Month per Month per Month Employee/ Yr Cost/ Yr ATU Total Budgeted Positions - All Funds 297 5,108 1,517,068 6,086 2,036 604,762 ATU Total Budgeted Positions - All Funds 297 5,108 604,762 0 604,762 604,762 1,209,525 604,762 604,762 FY 2024 No. Total Salary Roll-Ups Avg per Total
6 Longevity Step based on Productivity Employees per Month per Month Employee/ Yr Cost/ Yr ATU Total Budgeted Positions - All Funds 1 243 273 3,326 3,326 ATU Total Budgeted Positions - All Funds 1 243 3,326 0 3,326 3,326 6,651 3,326 3,326 FY 2025 No. Avg Salary Total Salary Roll-Ups Avg per Total 7 3% Wage Increase - Effective 6/15/2024 Employees per Month per Month per Month Employee/ Yr Cost/ Yr ATU Total Budgeted Positions - All Funds 297 5,262 1,562,717 6,270 2,098 623,027 ATU Total Budgeted Positions - All Funds 297 5,262 623,027 0 0 623,027 623,027 623,027 623,027 FY 2025 No. Total Salary Roll-Ups Avg per Total
8 Longevity Step based on Productivity Employees per Month per Month Employee/ Yr Cost/ Yr ATU Total Budgeted Positions - All Funds 8 972 137 3,326 26,606 ATU Total Budgeted Positions - All Funds 8 972 26,606 0 0 26,606 26,606 26,606 26,606 Addition of One Holiday No. Hours Added
9 Employees per Year
ATU Total Budgeted Positions - All Funds 297 2,376 66,005 ATU Total Budgeted Positions - All Funds 297 2,376 0 0 0 0 0 0 HRA Benefit Expansion for Qualified Med. Exp & Value No. Avg Value 10 Employees per Employee
Average Employees Retiring per Year 10 4,631 46,306
Average Employees Retiring per Year 10 4,631 0 0 0 0 0 0 Special HRA No. Avg Value
11 Employees per Employee
Average Employees Retiring per Year 10 355 3,555
Average Employees Retiring per Year 10 355 0 0 0 0 0 0
Employee Incentive Time Off Elimination No. Avg Value
12 Employees per Employee
Average Employees Qualifying per Year 179 (394) (70,590) Average Employees Qualifying per Year 179 (394) 0 0 0 0 0 0 Platform Instructor Compensation No. Avg Value
13 Employees per Employee
Average Platform Instructors per Year 12 1,779 21,348
Average Platform Instructors per Year 12 1,779 0 0 0 0 0 0 Total MOU costs (savings) 3,045,989 2,529,860 3,179,492 8,755,342 3,179,492 3,179,492 66,624 Budget Cash Basis
2/17/2022
Summary Analysis of MOU Unit 6 ATU
FY 2023 FY 2023 FY 2024 FY 2025 Total FY 2026 FY 2026 Notes 1 3% Wage Increase - 10/26/2020 (FY21) 1,108,103 554,051 554,051 2,216,205 554,051 554,051 2 3% Wage Increase - 6/21/2021 (FY22) 1,140,332 570,166 570,166 2,280,663 570,166 570,166 3 3% Wage Increase - 6/20/2022 (FY23) 588,036 588,036 588,036 1,764,108 588,036 588,036 4 Longevity Step Based on Productivity 209,519 209,519 209,519 628,557 209,519 209,519 Subtotal 3,045,989 1,921,772 1,921,772 6,889,534 1,921,772 1,921,772 FY 2024 FY 2023 FY 2024 FY 2025 Total FY 2026 FY 2026
5 3% Wage Increase - 6/19/2023 0 604,762 604,762 1,209,525 604,762 604,762 6 Longevity Step Based on Productivity 0 3,326 3,326 6,651 3,326 3,326 Subtotal 0 608,088 608,088 1,216,176 608,088 608,088
FY 2025 FY 2023 FY 2024 FY 2025 Total FY 2026 FY 2026
7 3% Wage Increase - 6/17/2024 0 0 623,027 623,027 623,027 623,027 8 Longevity Step Based on Productivity 0 0 26,606 26,606 26,606 26,606 Subtotal 0 0 649,632 649,632 649,632 649,632
FY 2026 FY 2023 FY 2024 FY 2025 Total FY 2026 FY 2026
Subtotal 0 0 0 0 0 0
FY 2026 FY 2023 FY 2024 FY 2025 Total FY 2026 FY 2026
Subtotal 0 0 0 0 0 0
Total MOU costs (savings) 3,045,989 2,529,860 3,179,492 8,755,342 3,179,492 3,179,492 All Funds - Budget Cash Basis
2/17/2022
Department of Transportation
FY2023 - FY2025 Operating Proforma
Budget
Budget Summary - Operating Funds Only 2023 2024 Projections 2025 Projections 2026 Projections 2027 Projections Carryover
Carryover 26,205,000$ 35,747,811$ 24,881,954$ 15,361,594$ 3,389,009$ Revenues
TDA/LTF&STA 30,107,300$ 33,712,665$ 35,061,172$ 36,463,618$ 37,922,163$ Passenger Fares 2,773,000$ 3,188,950$ 3,667,293$ 4,217,386$ 4,849,994$ Measure C 16,172,100$ 15,641,955$ 16,267,633$ 16,918,339$ 17,595,072$ Federal Grants (5307) 7,206,100$ 10,000,000$ 10,000,000$ 10,000,000$ 10,000,000$ Federal Grants (CRRSAA) 5,605,200$ -$ -$ -$ -$ Federal Grants (ARPA) 28,944,700$ -$ -$ -$ -$ State/Federal One-Time Grants (LCTOP, CMAQ) 925,000$ 720,000$ -$ -$ -$ CMAQ Operating Grant (Rte 3, 20, 45, Industrial Park) 732,900$ 3,200,000$ 3,200,000$ -$ -$ State/Local Misc. Revenue 905,400$ 923,508$ 941,978$ 960,818$ 980,034$ Transfers In/Out - Current Capital Match (8,673,900)$ 415,000$ 415,000$ (344,400)$ (2,000,000)$ Transfers Out - Operating Reserve -$ -$ -$ -$ 9,472,200$ Transfers Out - Match Reserve for Existing Grants -$ -$ -$ -$ -$ Transfers Out - Match Reserve for ZEB -$ -$ -$ -$ -$ CNG Rebate 363,500$ 290,800$ 232,640$ 186,112$ 148,890$ LCFS/Renewable Energy Credits 1,200,000$ 1,080,000$ 1,000,000$ 1,000,000$ 1,000,000$ Interest 154,400$ 123,520$ 98,816$ 79,053$ 63,242$ Revenue Total 86,415,700$ 69,296,398$ 70,884,531$ 69,480,926$ 80,031,596$ Expenditures
51000 - Employee Services 45,429,200$ 50,520,814$ 51,377,176$ 52,168,590$ 53,026,181$ ATU Successor MOU 3,045,989$ 2,529,860$ 3,179,493$ 3,179,493$ 3,179,493$ 53000 - Purchased Prof and Tech 9,001,700$ 9,271,751$ 9,549,904$ 9,836,401$ 10,131,493$ 54000 - Purchased Property Services 3,808,300$ 3,922,549$ 4,040,225$ 4,161,432$ 4,286,275$ 55000 - Other Purchased Services 307,900$ 317,137$ 326,651$ 336,451$ 346,544$ 56000 - Supplies 4,896,000$ 5,042,880$ 5,194,166$ 5,349,991$ 5,510,491$ 57000 - Property 108,800$ 112,064$ 115,426$ 118,889$ 122,455$ 58000 - Other Objects 2,027,000$ 774,560$ 797,797$ 821,731$ 846,383$ 59000 - Interdepartmental Charges 8,248,000$ 7,670,640$ 7,824,053$ 7,980,534$ 8,140,145$ Implementation of Cost Saving Measures -$ -$ (2,000,000)$ (2,500,000)$ (2,500,000)$ Expenditure Total 76,872,889$ 80,162,255$ 80,404,891$ 81,453,511$ 83,089,460$ Net Operating Surplus/(Deficit) 35,747,811$ 24,881,954$ 15,361,594$ 3,389,009$ 331,145$ 7/11/2022 5:14 PM