Cities Index.
Exhibit 1 - All Funds Summary

Alameda City Council
May 10, 2022

Document
Exhibit 1 - All Funds Summary
Meeting
May 10, 2022
Body
Alameda City Council
Original file
167 KB
Text extracted from the city's file for reading and search. Open the original on legistar1.granicus.com. That file is the official record.

Exhibit 1
2020‐21
Beginning
Available Fund
Balance
2020‐21
Actual
Expenditures
2020‐21
Actual
Revenues
2020‐21
Available Fund
Balance
2021‐22
Revised
Expenditures
2021‐22
Projected
Revenues
2021‐22
Projected
Available Fund
Balance
2022‐23
Mid‐Cycle
Expenditures
2022‐23
Mid‐Cycle
Revenues
2022‐23
Projected
Available Fund
Balance
General Fund
100 General  Fund* 54,863,084           110,093,133         127,097,363         71,867,314          126,396,617        117,619,261        63,089,958          124,925,459        122,765,474        60,929,973 101 Police/Fire  Pension 1079 552,242                 819,163                 1,886,702             1,619,781            1,882,000            1,882,000            1,619,781            1,882,000            1,882,000            1,619,781 102 Police/Fire  Pension 1082 (1,076)                    32,512                   49,912                   16,324                  50,000                  50,000                  16,324                  50,000                  50,000                  16,324 103 Housing  Authority Reimbursable 1,976                     ‐                               256                         2,232                    ‐                              ‐                              2,232                    ‐                              ‐                              2,232 104 AMP  Reimbursable 4,860                     12,985,554           13,012,058           31,364                  83,282                  ‐                              (51,919)                 83,457                  ‐                              (135,376) General Fund Subtotal 55,421,086          123,930,362         142,046,291         73,537,016          128,411,899        119,551,261        64,676,378          126,940,916        124,697,474        62,432,936 Special Revenue Funds
201 HOME ‐                             530,782                 530,782                 ‐                              554,070                554,074                4                            525,000                525,000                4 202 HOME  Loan Repayment 40                           36,766                   36,871                   145                        50,000                  50,000                  145                        70,000                  70,000                  145 203 CDBG ‐                             947,995                 947,995                 ‐                              2,861,606            2,769,023            (92,583)                 1,532,485            1,532,400            (92,668) 204 CDBG  Loan Repayment 519,945                 266,209                 147,457                 401,193                330,400                80,400                  151,193                80,400                  80,400                  151,193 205 Special  CDBG Grants ‐                             855,959                 855,959                 ‐                              647,112                647,112                ‐                              647,112                647,112                ‐ 206 Housing  In‐Lieu 566,230                 157,988                 125,096                 533,338                428,429                783,500                888,409                418,600                783,500                1,253,309 207 Rent  Review/Stabilization 549,618                 1,703,952             1,685,482             531,147                2,224,474            2,198,803            505,476                2,162,173            2,135,554            478,857 208 Affordable  Housing 777,283                 349,861                 1,344,773             1,772,196            680,429                701,000                1,792,767            638,369                701,000                1,855,398 209 Planning/Bldg/Transportation 1,745,832             7,202,644             7,365,852             1,909,040            9,046,655            8,675,500            1,537,885            9,086,540            9,107,000            1,558,345 210 Alameda  Free Library 4,257,462             4,426,397             5,062,002             4,893,067            5,492,963            5,390,000            4,790,104            5,539,243            5,581,500            4,832,361 211 Gas  Tax 1,570,740             2,144,474             1,758,932             1,185,198            2,079,365            2,008,500            1,114,333            2,082,532            2,297,500            1,329,301 212 Road  Mtce and Rehab (RMRA) 2,554,988             2,881,868             1,495,868             1,168,988            1,850,000            1,550,000            868,988                1,850,000            1,750,000            768,988 213 Vehicle  Registration Fees 327,616                 520,000                 342,247                 149,863                320,000                305,000                134,863                320,000                305,000                119,863 216 Tidelands 2,568,583             896,525                 597,058                 2,269,116            969,329                809,000                2,108,787            867,590                809,000                2,050,197 217 Open  Space Improvement & Mtce 167,880                 97,415                   14,070                   84,535                  15,000                  ‐                              69,535                  15,000                  ‐                              54,535 219 Police  Asset Seizure 41,004                   28,046                   2,831                     15,789                  10,550                  1,500                    6,739                    10,550                  1,500                    (2,311) 220 Fire  Grants 2,039,127             1,693,787             1,173,833             1,519,174            2,397,947            2,398,522            1,519,748            1,992,337            900,376                427,787 221 Police  Grants 45,812                   787,739                 810,652                 68,725                  441,588                215,812                (157,051)              300,500                308,000                (149,551) 222 Grants ‐                             ‐                               ‐                               ‐                              1,117,530            1,117,530            ‐                              558,765                558,765                ‐ 230 County  Measure B Streets/Roads 1,065,149            413,846                 2,364,902             3,016,206            1,672,000            1,618,000            2,962,206            1,930,000            1,618,000            2,650,206 231 County  Measure BB Streets/Road 1,637,841            316,137                 2,230,874             3,552,579            2,849,024            2,495,000            3,198,555            3,325,000            2,495,000            2,368,555 232 County  Measure B Bike/Ped 524,098                 295,447                 307,033                 535,684                587,500                202,000                150,184                297,000                202,000                55,184 233 County  Measure BB Bike/Ped 366,801                 214,410                 250,249                 402,640                416,000                270,000                256,640                198,000                270,000                328,640 234 County  Measure B Paratransit 233,473                 203,670                 222,515                 252,318                317,700                150,000                84,618                  317,700                150,000                (83,082) 235 County  Measure BB Paratransit 101,587                 130,904                 219,557                 190,240                211,800                247,000                225,440                211,800                247,000                260,640 240 Commercial  Revitalization 2,164,341             805,161                 571,224                 1,930,404            1,431,242            621,300                1,120,462            975,424                624,115                769,153 241 Fleet  Industrial Supply Center 3,733,878             1,466,406             309,548                 2,577,020            1,389,718            185,000                1,372,302            972,539                10,000                  409,763 250 Golf (209,064)               72,555                   336,980                 55,361                  259,891                360,225                155,695                312,128                364,496                208,063 251 Mastick  Advisory Board 520,374                 57,158                   24,633                   487,848                130,150                44,000                  401,698                123,075                92,000                  370,623 252 Mastick  Senior Center Trust 863,352                 ‐                               1,191                     864,543                ‐                              ‐                              864,543                50,000                  ‐                              814,543 253 Adams  Street House 374,669                 ‐                               436                         375,106                ‐                              ‐                              375,106                ‐                              ‐                              375,106 260 Solid  Waste Surcharge 1,426,211             208,294                 225,426                 1,443,343            741,187                228,170                930,326                264,157                228,170                894,339 Citywide Budget
All Funds Summary
1 of 3
Exhibit 1
2020‐21
Beginning
Available Fund
Balance
2020‐21
Actual
Expenditures
2020‐21
Actual
Revenues
2020‐21
Available Fund
Balance
2021‐22
Revised
Expenditures
2021‐22
Projected
Revenues
2021‐22
Projected
Available Fund
Balance
2022‐23
Mid‐Cycle
Expenditures
2022‐23
Mid‐Cycle
Revenues
2022‐23
Projected
Available Fund
Balance
261 City  Waste Management Program 672,972                 1,450,634             562,969                 (214,692)              1,036,701            1,332,327            80,934                  1,042,572            1,332,327            370,689 262 Integrated  Waste ‐ Meas D 2,032,653             270,747                 (73,495)                  1,688,412            620,934                251,000                1,318,478            587,326                270,000                1,001,152 263 Curbside  Recycling 190,483                 ‐                               222                         190,705                ‐                              ‐                              190,705                ‐                              ‐                              190,705 264 Stormwater 2,385,197             4,412,657             4,872,101             2,844,642            5,044,230            5,315,598            3,116,010            4,962,213            5,215,134            3,368,931 265 Parking  Fees 2,203,125             970,518                 500,787                 1,733,394            1,918,048            1,950,000            1,765,346            2,730,196            2,133,000            1,168,150 266 Civic  Center Garage 555,095                 ‐                               ‐                               555,095                0                            ‐                              555,095                ‐                              ‐                              555,095 268 Oak  Tree in‐Lieu Fee 12,959                   ‐                               7,630                     20,589                  ‐                              8,500                    29,089                  ‐                              8,500                    37,589 270 Island  City Maint‐84‐2 Zone 1 39,237                   3,537                     4,773                     40,474                  25,652                  4,800                    19,622                  6,857                    4,800                    17,565 271 Island  City Maint‐84‐2 Zone 4 102,716                 122,609                 175,393                 155,501                266,623                186,698                75,576                  186,664                192,299                81,211 272 Island  City Maint‐84‐2 Zone 5 220,188                 1,132,837             970,859                 58,210                  769,338                1,003,654            292,526                779,953                1,033,763            546,336 273 Island  City Maint‐84‐2 Zone 6 1,542,794             773,810                 452,397                 1,221,381            763,407                473,685                931,659                709,741                487,896                709,814 274 Island  City Maint‐84‐2 Zone 7 113,850                 1,409                     4,065                     116,507                12,728                  ‐                              103,779                12,728                  3,900                    94,951 275 Island  City Maint‐84‐2 Zone 8 76,471                   79,679                   76,317                   73,109                  99,916                  78,787                  51,981                  98,418                  81,151                  34,714 276 Assessment  District Admin (91,618)                  350,753                 366,353                 (76,018)                 288,553                263,090                (101,481)              296,830                263,090                (135,221) 277 Marina  Cove Maintenance AD 103,458                 122,848                 114,400                 95,010                  210,852                117,460                1,618                    216,354                120,984                (93,752) 278 Marina  Cove Reserve 01‐01 235,188                 ‐                               274                         235,462                ‐                              ‐                              235,462                ‐                              ‐                              235,462 279 Alameda  Landing Muni SD 2,391,488             94,924                   511,923                 2,808,487            672,227                511,584                2,647,844            575,056                526,932                2,599,720 280 Bayport  Muni Services Dist 03 4,059,570             695,581                 700,361                 4,064,350            835,104                895,775                4,125,021            819,034                922,648                4,228,635 281 Alameda  Point Svc CFD 17‐1 208,132                 298,629                 590,344                 499,847                927,569                590,000                162,278                676,111                635,000                121,167 282 Marina  Village AD 89‐1 Refund 1,863,477             278                         2,109                     1,865,308            5,915                    ‐                              1,859,393            5,915                    ‐                              1,853,478 283 Harbor  Bay 92‐1 AD Matured 377,416                 7,989                     323                         369,751                89,916                  ‐                              279,835                89,916                  ‐                              189,919 284 CFD  13‐1 Alameda Landing (CPF) 29,887                   168,422                 170,000                 31,464                  203,761                172,000                (297)                      199,021                167,260                (32,058) 285 CFD  14‐1 Marina Cove II (CPF) 1,000,402             8,369                     224,534                 1,216,566            128,575                221,181                1,309,172            106,232                227,816                1,430,756 286 BFI  Dike Assmt District 93‐1 381,506                 ‐                               399                         381,905                50,000                  ‐                              331,905                ‐                              ‐                              331,905 287 Harbor  Transportation 2,436,346             1,341,623             729,986                 1,824,709            546,277                607,000                1,885,432            546,277                607,000                1,946,155 290 Alameda  Point 20,323,732           10,209,968           43,304,961           53,418,725          12,824,939          13,228,000          53,821,785          12,371,773          13,228,000          54,678,012 Special Revenue Funds Subtotal 74,001,599          52,230,214           85,632,312           107,403,698        68,864,925          63,887,110          102,425,882        64,693,206          61,855,888          99,588,564 Capital Projects Funds
301 Alameda  Point Capital Projects 32,048,471           29,758,167           381,930                 2,672,234            394,361                (250,000)              2,027,874            ‐                              ‐                              2,027,874 302 Construction  Impact Fees 1,775,425             428,680                 3,434,740             4,781,485            2,557,000            1,200,000            3,424,485            1,517,000            1,200,000            3,107,485 303 Dwelling  Unit 4,808                     11,542                   235,196                 228,462                ‐                              ‐                              228,462                ‐                              ‐                              228,462 305 Dev  Impact Fees ‐ Transp 1,680,855             295,231                 2,403,213             3,788,838            450,000                740,000                4,078,838            450,000                570,000                4,198,838 306 Dev  Impact Fees ‐ Rec/Park (53,589)                  ‐                               2,142,435             2,088,846            ‐                              2,500,000            4,588,846            ‐                              2,200,000            6,788,846 307 Dev  Impact Fees ‐ Public Facility 721,599                 ‐                               597,805                 1,319,404            ‐                              440,000                1,759,404            ‐                              300,000                2,059,404 308 Dev  Impact Fees ‐ Public Safety 939,522                 ‐                               919,686                 1,859,208            ‐                              680,000                2,539,208            ‐                              550,000                3,089,208 310 Capital  Improvement Projects 1,590,207             24,352,080           25,880,991           3,119,118            40,256,375          31,338,664          (5,798,592)           34,200,444          32,129,292          (7,869,744) 320 Transportation  Management 182,960                 126,802                 284,529                 340,686                130,000                130,000                340,686                130,000                130,000                340,686 330 Bayport   03‐01 Capital Reserve ‐                             ‐                               ‐                               ‐                              ‐                              ‐                              ‐                              ‐                              ‐                              ‐ 331 Alameda  Landing 13‐2 Capital Reserve ‐                             ‐                               ‐                               ‐                              ‐                              ‐                              ‐                              ‐                              ‐                              ‐ 332 Marina  Cove 14‐1 Capital Reserve ‐                             ‐                               ‐                               ‐                              ‐                              ‐                              ‐                              ‐                              ‐                              ‐ 333 Alameda  Point 17‐1 Capital Reserve ‐                             ‐                               ‐                               ‐                              ‐                              ‐                              ‐                              ‐                              ‐                              ‐ Capital Projects Funds Subtotal 38,890,258          54,972,502           36,280,526           20,198,281          43,787,735          36,778,664          13,189,210          36,297,444          37,079,292          13,971,058 2 of 3
Exhibit 1
2020‐21
Beginning
Available Fund
Balance
2020‐21
Actual
Expenditures
2020‐21
Actual
Revenues
2020‐21
Available Fund
Balance
2021‐22
Revised
Expenditures
2021‐22
Projected
Revenues
2021‐22
Projected
Available Fund
Balance
2022‐23
Mid‐Cycle
Expenditures
2022‐23
Mid‐Cycle
Revenues
2022‐23
Projected
Available Fund
Balance
Debt Service Funds
401 City  Debt Service 411,449                 1,939,573             1,939,664             411,541                2,000,725            2,001,200            412,016                1,653,600            1,652,940            411,356 410 2013  GO Library Bond 2003 1,035,756             623,169                 658,894                 1,071,481            626,500                626,500                1,071,481            624,500                626,500                1,073,481 420 2003  Alameda Point Rev Bonds 78,434                   481,473                 690,014                 286,975                843,000                783,000                226,975                873,000                873,000                226,975 Debt Service Funds Subtotal 1,525,640            3,044,214             3,288,572             1,769,997            3,470,225            3,410,700            1,710,472            3,151,100            3,152,440            1,711,812 Enterprise Fund
501 Sewer  Services 93,520,368           19,066,684           24,400,308           98,853,992          17,666,344          12,893,000          94,080,648          12,674,698          13,329,100          94,735,050 Enterprise Fund Subtotal 93,520,368          19,066,684           24,400,308           98,853,992          17,666,344          12,893,000          94,080,648          12,674,698          13,329,100          94,735,050 Internal Service Funds
601 Fleet  Maintenance & Replacement 9,342,699            3,602,320             4,714,445             10,454,825          6,627,345            4,895,081            8,722,561            6,030,062            4,745,081            7,437,580 603 Facility  Mtce & Replacement 4,424,014             1,704,001             2,942,265             5,662,277            6,260,486            4,877,315            4,279,106            4,855,393            4,581,890            4,005,603 605 Emergency  Operations Center 30,110                   134,879                 147,621                 42,852                  155,761                131,000                18,091                  157,000                131,000                (7,909) 606 Information  Technology 8,185,288             2,899,944             2,679,173             7,964,517            6,602,998            2,997,610            4,359,129            4,223,593            2,997,610            3,133,146 609 IT  Cable Equip Replace (PEG) 1,221,154             28,081                   161,874                 1,354,947            71,500                  170,000                1,453,447            71,500                  170,000                1,551,947 610 Worker's  Compensation (3,636,613)            3,062,186             3,851,313             (2,847,485)           4,364,457            4,340,000            (2,871,943)           4,708,943            4,687,200            (2,893,686) 611 General  Liability 167,267                 2,496,679             3,504,825             1,175,413            5,389,898            5,540,000            1,325,515            5,396,452            5,510,000            1,439,063 612 Unemployment  Insurance 560,934                 147,926                 (1,492)                    411,516                162,000                160,000                409,516                162,000                160,000                407,516 613 Post  Employment ‐ OPEB 7,612,056             4,513,871             4,726,621             7,824,807            4,350,000            4,175,000            7,649,807            4,537,000            4,362,000            7,474,807 Internal Service Funds Subtotal 27,906,911          18,589,887           22,726,645           32,043,669          33,984,446          27,286,006          25,345,229          30,141,943          27,344,781          22,548,067 Fiduciary Funds
701 Successor  Agency (40,740,912)          21,836,291           24,948,952           (37,628,251)         11,039,830          11,377,900          (37,290,181)         11,393,329          11,499,400          (37,184,110) 710 Misc&Safety  Pre‐1/1/2019 OPEB 15,328,975          ‐                               ‐                               15,328,975          80,000                  3,723,704            18,972,679          80,000                  1,420,000            20,312,679 711 Safety  Post‐1/1/2019 OPEB Trst ‐                             ‐                               ‐                               ‐                              ‐                              ‐                              ‐                              ‐                              ‐                              ‐ 712 PARS  Pension Rate Stabilizatn ‐                             ‐                               ‐                               ‐                              ‐                              ‐                              ‐                              ‐                              ‐                              ‐ 720 Pension  Reserve 6,829,664             28,416                   10,481,237           17,282,486          6,911,111            7,611,111            17,982,486          ‐                              700,000                18,682,486 Fiduciary Funds Subtotal (18,582,272)         21,864,707           35,430,190           (5,016,790)           18,030,941          22,712,715          (335,016)              11,473,329          13,619,400          1,811,055 Agency Funds
801 1998  Rev Bond Debt/Harbor Bay 55,144                   ‐                               (13,546)                  41,599                  ‐                              ‐                              41,599                  ‐                              ‐                              41,599 802 2010 ‐B Marina Village Bd Refi 811,166                 ‐                               3,116                     814,281                ‐                              ‐                              814,281                ‐                              ‐                              814,281 803 Harbor  Bay Assmt Dist CFD 1 182,471                 1,516                     (1,344)                    179,611                ‐                              ‐                              179,611                ‐                              ‐                              179,611 804 Marina  Villg Assmt Dist CFD 2 132,270                 ‐                               138                         132,408                ‐                              ‐                              132,408                ‐                              ‐                              132,408 805 Alameda  Landing CFD #13‐1 1,582,312             974,541                 946,437                 1,554,208            994,250                964,000                1,523,958            1,011,510            992,000                1,504,448 Agency Funds Subtotal 2,763,363            976,057                 934,802                 2,722,107            994,250                964,000                2,691,857            1,011,510            992,000                2,672,347 Totals 275,446,952        294,674,628         350,739,645         331,511,970        315,210,765        287,483,456        303,784,660        286,384,146        282,070,375        299,470,889 3 of 3

← All documents from this meeting