Loading...
HomeMy WebLinkAbout2023-06-13; City Council; Resolution 2023-161RESOLUTION NO. 2023-161 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF CARLSBAD, CALIFORNIA, ADOPTING THE FINAL OPERATING BUDGET, STRATEGIC DIGITAL TRANSFORMATION INVESTMENT PROGRAM AND CAPITAL IMPROVEMENT PROGRAM FOR FISCAL YEAR 2023-24 FOR THE CITY OF CARLSBAD AND ESTABLISHING CONTROLS ON CHANGES IN APPROPRIATIONS FOR BUDGET FUNDS WHEREAS, the City Council of the City of Carlsbad, California, has reviewed the proposed final Operating Budget, Strategic Digital Transformation Investment Program and Capital Improvement Program for fiscal year (FY) 2023-24 and has held such public hearings as are necessary prior to adoption of the final budgets. NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of Carlsbad, California, as follows: 1.That the above recitations are true and correct. 2.That certain documents now on file in the Office of the City Clerk of the City of Carlsbad, entitled "Fiscal Year 2023-24 Preliminary Operating Budget, Strategic Digital Transformation Investment Program and Capital Improvement Program" presented at the Joint Special Meeting on May 23, 2023 as Exhibit 1 to Item No. 9, as amended, if necessary, in accordance with Attachments A-A3, 8-82, C and D to this Exhibit 4 are adopted as the final Operating Budget, Strategic Digital Transformation Investment Program and Capital Improvement Program for the City of Carlsbad for FY 2023-24 along with the program options and adjustments, if any, determined by the City Council as set forth in the minutes of this Joint Special Meeting on June 13, 2023. 3.That the amounts reflected as estimated revenues for FY 2023-24 as shown in Attachments A-A2 and B are adopted as the budgeted revenues for FY 2023-24. 4.That the amounts as designated as the FY 2023-24 Budget request in Attachments A-A3, 8-82 and D are appropriated to the department or fund for which they are designated, and such appropriation shall not be increased except as provided in this resolution. 5.That the items and amounts as shown in Attachment E are adopted as major capital outlay items for FY 2023-24. 6.That total appropriations for each fund may only be increased or decreased by the City Council by passage of a resolution amending the budget except as provided in this resolution. 7.That the following controls are placed on the use and transfer of budget funds: A.No expenditure of funds shall be authorized unless sufficient funds have been appropriated by the City Council or City Manager as described below. i.The City Manager may authorize all transfers of funds from account to account within any department. ii.The City Manager may authorize transfers of funds between departments within the same fund in an amount up to $100,000 per transfer. iii.The City Manager may authorize transfers of funds from the Housing Trust Fund to the Section 8 Housing Fund program administration to support the program's fund balance and aid in the expansion of the program if costs exceed budget related to administration, payroll, vouchers, and related costs. iv.The City Manager may authorize budget adjustments involving offsetting revenues and expenditures; the City Manager may authorize increases in an appropriation for a specific purpose where the appropriation is offset by unbudgeted revenue designated for the specific purpose. v.The City Manager may authorize budget adjustments to increase the appropriation for the Workers' Compensation and Risk Management Funds' operating budgets in an amount equal to the increases in costs of claims expenses or estimated losses and liabilities. vi.The City Manager may authorize increases of 15% or less to purchasing authority for capital outlay items requiring the City Council to act as the awarding authority approved in the budget process. vii.The City Manager may authorize budget adjustments to increase the appropriation for earned leave accrual expenses and liabilities. viii.The City Manager may authorize budget adjustments to increase the appropriation for unforeseen legal expenses and liabilities. ix.The City Manager may authorize budget adjustments to increase the appropriation for Mutual Aid expenses in an amount equal to the increases in amounts to be reimbursed by other agencies. x.The City Council must authorize all transfers of funds from the City Council's Contingency Account. xi.The City Manager may delegate any of the authority given to the City Manager under this resolution. B.The City Council must authorize any increase in the number of authorized permanent personnel positions above the level identified in Attachment C. C.The City Manager may authorize the hiring of temporary or part-time staff as necessary within the limits imposed by the controls listed above. 8.That the legal level of budgetary control is the fund level. Budgets may not legally be exceeded at the fund level without appropriate authorization by the City Council. 9.That interest earned on grants may be appropriated during the year for the purpose for which the grant was received. 10.That all appropriations in the Capital Improvement Program remaining unexpended at June 30, 2023, are appropriated to FY 2023-24 in their respective project budgets. 11.That all appropriations in the Strategic Digital Transformation Investment Program remaining unexpended at June 30, 2023, are appropriated to FY 2023-24 in their respective project budgets. 12.That.all appropriations in the Operating Budget remaining unexpended at June 30, 2023 related to developer deposits received for developer-funded studies not yet completed or grant awards received or expected for projects that are continuing into the next fiscal year are appropriated to FY 2023-24. 13.That all appropriations for outstanding encumbrances as of June 30, 2023, are continued into FY 2023-24 for such contracts or obligations. PASSED, APPROVED AND ADOPTED at a Joint Special Meeting of the City Council of the City of Carlsbad, the Board of Directors of the Carlsbad Municipal Water District, the Board of Directors of the Carlsbad Public Financing Authority, the Community Development Commission, and the City Council as Successor Agency to the Carlsbad Redevelopment Agency held on the 13th day of June, 2023, by the following vote, to wit: AYES: NAYS: ABSTAIN: ABSENT: Blackburn, Bhat-Patel, Acosta, Burkholder, Luna. None. None. None. KEITH BLACKBURN, Mayor LsHERRY FREISINGER, City Clerk t• -(SEAL) B‐23  SCHEDULE OF PROJECTED FUND BALANCE Projected Projected Beginning Ending Change as % of Fund Balance Estimated Estimated Fund Balance July 1, 2022 Fund July 1, 2022 Revenues Expenditures June 30, 2023 Fund Balance General Fund 122,554,527$     * 207,801,063$  212,492,054$  117,863,536$  *‐3.8% Special Revenue Funds   Affordable Housing 17,341,701   884,406  288,618    17,937,489      3.4%   Agricultural Mitigation Fee 1,186,588      13,500     392,687     807,401  ‐32.0%   Buena Vista Channel Maintenance District 1,527,280      119,095  195,245     1,451,130    ‐5.0%   Citizens' Option for Public Safety 389,368    287,200  265,705     410,863  5.5%   Community Activity Grants 1,079,163      12,000     ‐    1,091,163    1.1%   Community Development Block Grant 569,707    701,309   728,372     542,644  ‐4.8%   Cultural Arts Donations 334,071    28,424     85,489       277,006  ‐17.1%   Habitat Mitigation Fee ‐   52,002     52,002       ‐      0.0%   Library and Arts Endowments 259,307    2,500   4,000    257,807  ‐0.6%   Library Gifts and Bequests 1,692,630      136,500   275,041     1,554,089    ‐8.2%   Lighting and Landscaping District 2 4,825,153      759,743   335,033     5,249,863    8.8%   Local Cable Infrastructure 806,259    299,000   435,000     670,259  ‐16.9%   Median Maintenance District 315,473    1,316,900     1,476,870       155,503  ‐50.7%   Opioid Settlement Fund ‐   238,846   ‐    238,846  0.0%   Parking In Lieu Fee 1,146,591      13,000     53,000       1,106,591    ‐3.5%   Permanent Local Housing Allocation ‐   ‐       ‐   ‐      0.0%   Police Asset Forfeiture 239,638    2,368   105,869    136,137  ‐43.2%   Public Safety Grants 19,485       301,796   321,281    ‐       ‐100.0%   Recreation Donations 307,647    58,711     84,809       281,549  ‐8.5%   Rental Assistance 196,913    10,850,661  10,860,729    186,845  ‐5.1%   Senior Donations 299,770    20,646     43,500       276,916  ‐7.6%   Street Lighting Maintenance District 2,712,485      1,000,972    916,850    2,796,607    3.1%   Street Tree Maintenance District 255,061    920,500  1,075,168      100,393  ‐60.6%   Tyler Court Apartments 68,224      681,472  748,339    1,357      ‐98.0% Total Special Revenue Funds 35,572,514   18,701,551  18,743,607    35,530,458      ‐0.1% Enterprise Funds   Water Operations 31,998,456   46,727,000  48,000,000    30,725,456      ‐4.0%   Recycled Water Operations 4,335,400      8,787,905    9,000,000      4,123,305    ‐4.9%   Wastewater Operations 10,692,480   19,168,000  16,900,000    12,960,480      21.2%   Solid Waste Management 12,748,480   3,854,582    4,982,227      11,620,835      ‐8.9%   Golf Course 3,917,630      10,586,297  8,660,962      5,842,965    49.2% Total Enterprise Funds 63,692,446   89,123,784  87,543,189    65,273,041      2.5% Internal Service Funds   Workers' Compensation 1,084,141      14,008,855   6,267,000       8,825,996    714.1%   Risk Management (200,336)   4,971,351     5,155,035       (384,020)      91.7%   Vehicle Maintenance 150,341    4,725,118     4,017,238       858,221  470.9%   Vehicle Replacement 18,715,868   3,970,753     7,398,750       15,287,871      ‐18.3%   Information Technology 9,349,922      16,542,819  17,086,055    8,806,686    ‐5.8% Total Internal Service Funds 29,099,936   44,218,896  39,924,078    33,394,754      14.8% Successor Agency Housing Trust Fund 1,150,471      1,008,646     1,038,203       1,120,914    ‐2.6% Total Operating Funds 252,069,894$     360,853,940$  359,741,131$  253,182,703$  0.4% *For the General Fund only, this represents unassigned fund balance.  Attachment A B‐24  SCHEDULE OF PROJECTED FUND BALANCE Projected Projected Beginning Ending Change as % of  Fund Balance Estimated Adopted Fund Balance June 30, 2023 Fund June 30, 2023 Revenues Budget June 30, 2024 Fund Balance General Fund 117,863,536$       * 212,012,126$     211,709,604$     118,166,058$    *0.3% Special Revenue Funds   Affordable Housing 17,937,489   581,663   668,530  17,850,622   ‐0.5%   Agricultural Mitigation Fee 807,401   13,000   ‐    820,401    1.6%   Buena Vista Channel Maintenance District 1,451,130     116,000    195,245   1,371,885   ‐5.5%   Citizens' Option for Public Safety 410,863   252,500    295,298   368,065    ‐10.4%   Community Activity Grants 1,091,163     12,000   30,000   1,073,163   ‐1.7%   Community Development Block Grant 542,644   585,275    702,305   425,614    ‐21.6%   Cultural Arts Donations 277,006   3,424   148,750   131,680    ‐52.5%   Habitat Mitigation Fee ‐     ‐   ‐    ‐  0.0%   Library and Arts Endowments 257,807   2,500   6,000   254,307    ‐1.4%   Library Gifts and Bequests 1,554,089     90,500   462,785   1,181,804   ‐24.0%   Lighting and Landscaping District 2 5,249,863     854,900    367,500   5,737,263   9.3%   Local Cable Infrastructure 670,259   282,000    538,956   413,303    ‐38.3%   Median Maintenance District 155,503   1,400,000   1,396,580   158,923    2.2%   Opioid Settlement Fund 238,846   ‐   21,466   217,380    ‐9.0%   Parking In Lieu Fee 1,106,591     13,000   56,000   1,063,591   ‐3.9%   Permanent Local Housing Allocation ‐     1,119,126   1,119,126   ‐  0.0%   Police Asset Forfeiture 136,137   2,400   75,000   63,537    ‐53.3%   Public Safety Grants ‐     ‐   ‐    ‐  0.0%   Recreation Donations 281,549   49,200   81,200   249,549    ‐11.4%   Rental Assistance 186,845   11,334,677   11,339,700   181,822    ‐2.7%   Senior Donations 276,916    18,500  33,500  261,916    ‐5.4%   Street Lighting Maintenance District 2,796,607   1,024,754    1,100,077    2,721,284   ‐2.7%   Street Tree Maintenance District 100,393    1,005,000    1,004,763    100,630    0.2%   Tyler Court Apartments 1,357  774,967   604,523  171,801    12560.4% Total Special Revenue Funds 35,530,458  19,535,386  20,247,304   34,818,540    ‐2.0% Enterprise Funds   Water Operations 30,725,456   48,149,000   54,759,803   24,114,653   ‐21.5%   Recycled Water Operations 4,123,305   8,926,380    11,849,122   1,200,563   ‐70.9%   Wastewater Operations 12,960,480   22,356,000   23,068,138   12,248,342   ‐5.5%   Solid Waste Management 11,620,835   3,165,200    5,950,634    8,835,401   ‐24.0%   Golf Course 5,842,965   10,249,500   10,121,000   5,971,465   2.2% Total Enterprise Funds 65,273,041  92,846,080  105,748,697   52,370,424    ‐19.8% Internal Service Funds   Workers' Compensation 8,825,996   6,098,510    5,157,892    9,766,614   10.7%   Risk Management (384,020)  7,109,660    6,718,232    7,408    ‐101.9%   Vehicle Maintenance 858,221    3,632,863    3,696,339    794,745    ‐7.4%   Vehicle Replacement 15,287,871   4,311,539    1,068,564    18,530,846   21.2%   Information Technology 8,806,686   17,204,775   16,637,475   9,373,986   6.4% Total Internal Service Funds 33,394,754    38,357,347    33,278,502   38,473,599   15.2% Successor Agency Housing Trust Fund 1,120,914    ‐    1,059,500    61,414   ‐94.5% Total Operating Funds 253,182,703$        362,750,939$     372,043,607$     243,890,035$    ‐3.7% *For the General Fund only, this represents unassigned fund balance.  B‐25  SCHEDULE OF REVENUE ESTIMATES 2022‐23 2023‐24 Change as % Difference  2021‐22 Estimated Estimated of  2022‐23 2022‐23 to Revenue Source Actuals Revenue Revenue Estimated 2023‐24 General Fund Taxes    Property Tax 80,015,372$      81,509,276$     84,246,868$     3.4% 2,737,592$          Sales Tax 51,175,423  51,379,433  51,064,943   ‐0.6% (314,490)       Transient Occupancy Tax 32,402,771  32,500,000  32,861,193   1.1% 361,193      Franchise Tax 6,370,942  6,971,000  7,084,717  1.6% 113,717      Business License Tax 6,619,296  6,242,000  6,435,502  3.1% 193,502      Transfer Tax 2,178,717  1,570,000  1,624,950  3.5%54,950    Total Taxes 178,762,521  180,171,709   183,318,173   1.8% 3,146,464    Intergovernmental    Homeowners Exemption 338,265    353,000   353,000    0.0%‐      Other Intergovernmental 7,387,339  821,418   657,951    ‐19.9% (163,467)    Total Intergovernmental 7,725,604  1,174,418  1,010,951  ‐13.9% (163,467)    Licenses and Permits    Building Permits 1,691,494  1,800,000  1,250,000  ‐30.6% (550,000)       Other Licenses and Permits 1,054,108  867,980   850,500    ‐2.0% (17,480)    Total Licenses And Permits 2,745,602  2,667,980  2,100,500  ‐21.3% (567,480)    Charges for Services    Planning Fees 698,900    476,800   445,000    ‐6.7% (31,800)       Building Department Fees 863,329    1,008,000  860,000    ‐14.7% (148,000)       Engineering Fees 933,326    929,100   772,000    ‐16.9% (157,100)       Ambulance Fees 3,425,287  4,430,000  6,330,000  42.9% 1,900,000       Recreation Fees 2,701,108  2,529,837  2,598,600  2.7%68,763       Other Charges or Fees 1,715,034  1,202,575  1,584,245  31.7% 381,670   Total Charges For Services 10,336,984  10,576,312  12,589,845   19.0% 2,013,533    Fines and Forfeitures 342,948    355,770   276,200    ‐22.4% (79,570)    Income from Investments and Property (5,524,578)   6,021,288  5,948,225  ‐1.2% (73,063)    Interdepartmental Charges 5,314,617  5,375,335  5,746,232  6.9% 370,897   Other Revenue Sources 1,351,103  1,458,251  1,022,000  ‐29.9% (436,251)    Total General Fund 201,054,801$       207,801,063$     212,012,126$       2.0% 4,211,063$       * Interest is calculated on an amortized cost basis.  Attachment A2 B‐26  SCHEDULE OF REVENUE ESTIMATES 2022‐23 2023‐24 Change as %Difference  2021‐22 Estimated Estimated of  2022‐23 2022‐23 to Revenue Source Actuals Revenue Revenue Estimated 2023‐24 Special Revenue Funds Affordable Housing    Affordable Housing Fees 342,149$              247,946$              247,000$              ‐0.4%(946)$       Property Tax ‐‐     ‐               0.0%‐    Interest Income (491,215)            587,196 329,663       ‐43.9% (257,533)                 Other Revenue 1,112,930          49,264 5,000           ‐89.9% (44,264)                Total Affordable Housing 963,864              884,406                 581,663       ‐34.2% (302,743)              Agricultural Mitigation Fee    Agricultural Mitigation Fees 210,100              ‐     ‐               0.0%‐    Interest Income (49,135)               13,500 13,000         ‐3.7%(500)  Total Agriculutural Mitigation Fee 160,965              13,500 13,000         ‐3.7%(500)  Buena Vista Channel Maintenance    Assessment Fees 161,000              100,000 100,000       0.0%‐    Interest Income (61,578)               19,095 16,000         ‐16.2%(3,095)  Total Buena Vista Channel Maintenance 99,422                119,095                 116,000       ‐2.6%(3,095)  Citizens' Option for Public Safety    State Funding (AB3229)283,504              282,500 250,000       ‐11.5% (32,500)                   Interest Income (16,893)               4,700 2,500           ‐46.8%(2,200)  Total Citizens' Option For Public Safety 266,611              287,200                 252,500       ‐12.1% (34,700)                Community Activity Grants    Interest Income (45,969)               12,000 12,000         0.0%‐ Total Community Activity Grants (45,969)               12,000 12,000                0.0%‐ Community Development Block Grant    Federal Grant 1,036,043          508,874 545,490       7.2%36,616     Interest Income 50,419                10,047 10,147         1.0%100    Other Revenue 325,511              182,388 29,638         ‐83.8% (152,750)              Total Community Dev. Block Grant 1,411,973          701,309                 585,275       ‐16.6% (116,034)              Cultural Arts Donations    Donations 48,000                25,000 ‐               ‐100.0% (25,000)                   Interest Income (14,453)               3,424 3,424           0.0%‐ Total Cultural Arts Donations 33,547                28,424 3,424           ‐88.0% (25,000)                Habitat Mitigation Fee    Mitigation Fees 64,552                51,562 ‐               ‐100.0% (51,562)                   Interest Income 648 440    ‐               ‐100.0%(440)  Total Habitat Mitigation Fee 65,200                52,002 ‐               ‐100.0% (52,002)                B‐27  SCHEDULE OF REVENUE ESTIMATES 2022‐23 2023‐24 Change as % Difference  2021‐22 Estimated Estimated of  2022‐23 2022‐23 to Revenue Source Actuals Revenue Revenue Estimated 2023‐24 Special Revenue Funds ‐ Continued Library And Arts Endowment Fund    Interest Income (11,044)$          2,500$        2,500$              0.0%‐$           Total Library And Arts Endowment Fund (11,044)       2,500     2,500       0.0%‐      Library Gifts/Bequests    Gifts and Bequests 248,851      120,000       74,000     ‐38.3% (46,000)       Interest Income (73,328)       16,500   16,500     0.0%‐      Total Library Gifts/Bequests 175,523      136,500       90,500     ‐33.7% (46,000)    Lighting And Landscaping District 2    Assessment Fees 661,641      686,700       781,200   13.8%94,500         Interest Income (201,598)    73,043   73,700     0.9%657     Total Lighting And Landscaping Dist. 2 467,567      759,743       854,900   12.5%95,157      Local Cable Infrastructure Fund    Cable Fees 301,514      290,000       275,000   ‐5.2% (15,000)       Interest Income (32,840)       9,000     7,000       ‐22.2%(2,000)       Total Local Cable Infrastructure Fund 268,674      299,000       282,000   ‐5.7% (17,000)    Median Maintenance    Assessment Fees 346,058      365,000       365,000   0.0%‐         Other 952,289      951,900       1,035,000     8.7%83,100      Total Median Maintenance 1,298,347  1,316,900   1,400,000     6.3%83,100      Opioid Settlement Fund    Settlements ‐  238,846       ‐     ‐100.0% (238,846)        Total Median Maintenance ‐  238,846       ‐     ‐100.0% (238,846)        Parking In Lieu    Parking In Lieu Fees 44,960  ‐   ‐     0.0%‐         Interest Income (49,043)       13,000   13,000     0.0%‐      Total Parking In Lieu (4,083)   13,000   13,000     0.0%‐      Permanent Local Housing Allocation    Federal Grant ‐  ‐   1,119,126     0.0% 1,119,126      Total Police Grants ‐  ‐   1,119,126     0.0% 1,119,126      Police Asset Forfeiture    Asset Forfeitures 2,672    ‐   ‐     0.0%‐         Interest Income (10,275)       2,368     2,400       1.4%32       Total Police Asset Forfeiture (7,603)   2,368     2,400       1.4%32       Public Safety Grants    Federal Grant 171,776      301,796       ‐     ‐100.0% (301,796)        Total Police Grants 171,776      301,796       ‐     ‐100.0% (301,796)        Recreation Donations    Donations 67,052  55,981   46,500     ‐16.9%(9,481)          Interest Income (13,157)       2,730     2,700       ‐1.1%(30)      Total Recreation Donations 53,895  58,711   49,200     ‐16.2%(9,511)       B‐28  SCHEDULE OF REVENUE ESTIMATES 2022‐23 2023‐24 Change as %Difference  2021‐22 Estimated Estimated of  2022‐23 2022‐23 to Revenue Source Actuals Revenue Revenue Estimated 2023‐24 Special Revenue Funds ‐ Continued Rental Assistance    Federal Grant 8,933,219$       8,988,081$           9,035,487$       0.5%47,406$             Other Revenue 1,109,397   1,862,580    2,299,190     23.4% 436,610      Total Rental Assistance 10,042,616      10,850,661  11,334,677   4.5% 484,016      Senior Donations    Donations 3,035      6,400  5,000   ‐21.9%(1,400)        Interest Income (12,822)   3,500  3,500   0.0%‐        Other Revenue 11,137    10,746     10,000      ‐6.9%(746)   Total Senior Donations 1,350      20,646     18,500      ‐10.4%(2,146)     Street Lighting    Assessment Fees 739,284       740,000   740,000    0.0%‐        Other Revenue 155,790       228,222   254,754    11.6%26,532       Interest Income (117,704)     32,750     30,000      ‐8.4%(2,750)     Total Street Lighting 777,370       1,000,972    1,024,754     2.4%23,782    Street Tree Maintenance    Assessment Fees 471,860       470,000   470,000    0.0%‐        Other Revenue 440,239       450,500   535,000    18.8%84,500    Total Street Tree Maintenance 912,099       920,500   1,005,000     9.2%84,500    Tyler Court Apartments    Rental Income 649,402       680,000   772,982    13.7%92,982       Other Revenue 3,196      1,472  1,985   34.9%513       Interest Income 69       ‐      ‐  0.0%‐     Total Tyler Court Apartments 652,667       681,472   774,967    13.7%93,495    Total Special Revenue Funds 17,754,767$     18,701,551$         19,535,386$         4.5% 833,835$             B‐29  SCHEDULE OF REVENUE ESTIMATES 2022‐23 2023‐24 Change as %Difference  2021‐22 Estimated Estimated of  2022‐23 2022‐23 to Revenue Source Actuals Revenue Revenue Estimated 2023‐24 Enterprise Funds Water Operations    Water Sales 27,783,136$     27,012,000$       27,822,000$       3.0% 810,000$         Ready‐to‐Serve charge 12,737,089    13,462,000  13,866,000   3.0% 404,000       Property Tax 4,694,121   4,705,000    4,705,000   0.0%‐        New Account Charges 105,269    108,000     108,000    0.0%‐        Back‐Flow Program Fees 167,823    168,000     168,000    0.0%‐        Penalty Fees 189,399    391,000     411,000    5.1%20,000        Interest Income (1,498,707)  319,000     389,000    21.9%70,000        Engineering Overhead 95,307   155,000     155,000    0.0%‐        Service Connection Fees (13,700)     15,000    20,000   33.3%5,000       Other Revenue 3,679,732   392,000     505,000    28.8% 113,000    Total Water Operations 47,939,469    46,727,000  48,149,000   3.0% 1,422,000    Recycled Water Operations    Water Sales 6,924,934   7,103,000    7,210,000   1.5% 107,000       Ready‐to‐Serve charge 1,271,831   1,350,000    1,370,000   1.5%20,000        Interest Income 320,128    (89,600)   (80,000)     ‐10.7%9,600       Other Revenue 214,299    424,505     426,380    0.4%1,875    Total Recycled Water Operations 8,731,192   8,787,905    8,926,380   1.6% 138,475    Wastewater Operations    Service Charges 16,057,876    18,741,000  21,927,000   17.0% 3,186,000       Misc. Sewer 162,518    12,000    12,000   0.0%‐        Engineering Overhead 65,119   120,000     120,000    0.0%‐        Penalty Fees 61,779   120,000     120,000    0.0%‐        Interest Income (551,699)  108,000     110,000    1.9%2,000       Other Revenue 238,485    67,000    67,000   0.0%‐     Total Wastewater Operations 16,034,078    19,168,000  22,356,000   16.6% 3,188,000    Solid Waste Management    Recycling Fees (AB939)428,284    800,000     800,000    0.0%‐        Penalty Fees 32,307   1,500   ‐   ‐100.0%(1,500)         Trash Surcharge 3,223,792   1,900,000    1,300,000   ‐31.6% (600,000)      Interest Income (524,899)  132,260     125,200    ‐5.3%(7,060)         Other Revenue 578,967    1,020,822    940,000    ‐7.9% (80,822)   Total Solid Waste Management 3,738,451   3,854,582    3,165,200   ‐17.9% (689,382)   Golf Course Operations    Charges for Services 10,424,281    10,437,122  10,085,000   ‐3.4% (352,122)      Interest Income (103,721)  68,675    84,000   22.3%15,325        Other Revenue 102,878    80,500    80,500   0.0%‐     Total Golf Course Operations 10,423,438    10,586,297  10,249,500   ‐3.2% (336,797)   Total Enterprise Funds 86,866,628$     89,123,784$       92,846,080$       4.2% 3,722,296$        B‐30  SCHEDULE OF REVENUE ESTIMATES 2022‐23 2023‐24 Change as % Difference  2021‐22 Estimated Estimated of  2022‐23 2022‐23 to Revenue Source Actuals Revenue Revenue Estimated 2023‐24 Internal Service Funds Workers' Compensation    Interdepartmental Charges 4,524,120$         5,174,620$         5,908,510$     14.2% 733,890$          Interest Income (567,118)   190,000      190,000   0.0%‐      Other Revenue 849,077     8,644,235  ‐    ‐100.0% (8,644,235)     Total Workers' Compensation 4,806,079    14,008,855   6,098,510   ‐56.5% (7,910,345)     Risk Management    Interdepartmental Charges 3,305,532    3,890,450  7,069,660   81.7% 3,179,210         Interest Income (206,581)   40,000    40,000     0.0%‐      Other Revenue 49,453   1,040,901  ‐    ‐100.0% (1,040,901)     Total Risk Management 3,148,404    4,971,351  7,109,660   43.0% 2,138,309      Vehicle Maintenance    Interdepartmental Charges 3,038,651    3,272,355  3,605,863   10.2% 333,508        Interest Income (13,555)      10,807    7,000   ‐35.2%(3,807)         Other Revenue 67,848   1,441,956  20,000     ‐98.6% (1,421,956)     Total Vehicle Maintenance 3,092,944    4,725,118  3,632,863   ‐23.1% (1,092,255)     Vehicle Replacement    Interdepartmental Charges 3,574,152    3,575,367  3,948,539   10.4% 373,172        Interest Income (802,235)   220,386      213,000   ‐3.4%(7,386)         Other Revenue 1,505,548    175,000      150,000   ‐14.3% (25,000)   Total Vehicle Replacement 4,277,465    3,970,753  4,311,539   8.6% 340,786     Information Technology    Interdepartmental Charges 14,759,399  16,408,619   17,123,775    4.4% 715,156        Interest Income (355,281)   82,000    81,000     ‐1.2%(1,000)         Other Revenue 29,949   52,200    ‐    ‐100.0% (52,200)   Total Information Technology 14,434,067  16,542,819   17,204,775    4.0% 661,956        Total Internal Service Funds 29,758,959$       44,218,896$       38,357,347$       ‐13.3% (5,861,549)$      Trust Funds Sucssessor Agency Housing Fund    Property Tax Increment 848,207     954,059      ‐    ‐100.0% (954,059)       Interest Income 54,646   54,587    ‐    ‐100.0% (54,587)   Total Successor Agency Housing Fund 902,853     1,008,646  ‐    ‐100.0% (1,008,646)     Total Trust Funds 902,853$        1,008,646$         ‐$      ‐100.0% (1,008,646)$      Total Operating Funds 336,338,008$       360,853,940$       362,750,939$       0.5% 1,896,999$       B‐31  SCHEDULE OF BUDGET EXPENDITURES 2022‐23 Change as % 2020‐21 2021‐22 Estimated 2022‐23 2023‐24 of 2022‐23 Department Actuals Actuals Expenditures Budget Budget Budget General Fund Policy And Leadership Group City Council 487,977$         534,144$          546,770$        652,220$          607,078$          ‐6.9% City Attorney 2,036,466    2,081,883   2,000,000    2,033,508    2,115,596   4.0% City Clerk 1,207,035    1,296,312   1,300,000    1,394,162    1,274,455   ‐8.6% City Manager 1,939,537    2,013,122   2,058,720    2,156,145    2,184,823   1.3% City Treasurer 235,400     243,289     214,500   249,945     279,149     11.7% Communication & Engagement 1,493,938    2,037,551   2,029,500    1,979,186    1,953,098   ‐1.3% Total Policy And Leadership Group 7,400,353     8,206,301    8,149,490     8,465,166     8,414,199    ‐0.6% Administrative Services Administration ‐    706,556     741,397   747,797     784,107     5% Finance 5,810,863    5,623,094   5,300,000    5,472,176    5,323,368   ‐2.7% Human Resources 4,359,159    4,388,148   4,829,000    5,264,775    5,029,995   ‐4.5% Innovation & Economic Development 1,427,603    1,334,163   2,579,800    2,585,951    2,608,489   0.9% Total Administrative Services 11,597,625     12,051,961    13,450,197     14,070,699     13,745,959    ‐2.3% Community Services Community Services Administration 654,001     663,579     675,000   675,917     585,411     ‐13.4% Community Development 10,715,350   12,064,408   10,690,000    10,384,700    11,012,958   6.0% Housing & Homeless Services ‐    ‐    2,657,643    3,134,115    2,765,195   ‐12% Library & Cultural Arts 12,344,689   13,024,082   13,262,900    14,088,425    13,637,285   ‐3.2% Parks & Recreation 16,786,632   19,251,458   21,597,193    21,167,014    21,055,565   ‐0.5% Total Community Services 40,500,672     45,003,527    48,882,736     49,450,171     49,056,414    ‐0.8% Public Safety Fire 30,712,871   33,684,622   38,995,265    37,756,943    37,882,886   0.3% Police 47,615,546   50,824,125   56,456,326    51,240,884    55,615,155   8.5% Total Public Safety 78,328,417     84,508,747    95,451,591     88,997,827     93,498,041    5.1% Public Works Public Works Administration 1,808,997    1,760,326   1,414,235    1,440,649    1,562,272   8.4% Construction Management & Inspection 2,728,545    2,909,255   3,301,343    3,262,768    3,257,906   ‐0.1% Environmental Sustainability 1,030,453    1,238,207   1,030,986    1,159,789    1,178,783   1.6% Fleet & Facilities 5,341,736    6,297,998   8,001,952    6,768,736    7,497,115   10.8% Transportation 7,553,800    8,048,352   9,223,272    9,707,559    9,732,215   0.3% Total Public Works 18,463,531     20,254,138    22,971,788     22,339,501     23,228,291    4.0% Miscellaneous Non‐Departmental Expenditures Community Contributions 2,595     ‐    ‐     ‐     ‐    ‐ Dues & Subscriptions 72,714     75,069     80,000   80,000     80,000     0.0% Legal Services 755,312     519,683     275,000   1,000,000    750,000     ‐25.0% Professional Services 34,194     33,980     45,000   41,658     39,700     ‐4.7% Other Miscellaneous Expenditures 1,055,650    50,787     60,000   100,000     100,000     0.0% Personnel Related 184,337     155,595     144,000   1,050,000    1,637,000   55.9% COVID‐related 245,579     177,677     44,000   ‐     ‐    ‐ Vacancy savings ‐    ‐    (2,000,000)    (2,000,000)    (2,000,000)   0.0% Property Tax & Other Administration 759,165     725,588     730,000   750,000     750,000     0.0% Total Miscellaneous Non‐Departmental Expenditures 3,109,546     1,738,379    (622,000)      1,021,658     1,356,700    32.8% Attachment A3 B‐32  SCHEDULE OF BUDGET EXPENDITURES 2022‐23 Change as % 2020‐21 2021‐22 Estimated 2022‐23 2023‐24 of 2022‐23 Department Actuals Actuals Expenditures Budget Budget Budget General Fund ‐ Continued Transfers Transfer to General Capital Construction Fund 4,500,000$       13,283,056$      3,956,000$      3,956,000$       11,600,000$      0.0% Transfer to Infrastructure Replacement Fund 4,500,000    283,000   3,956,000    3,956,000   4,200,000     0.0% Transfer from Infrastructure Replacement Fund ‐    ‐   ‐    ‐   ‐    ‐ Transfer to Technology Investment Capital Fund 10,656,000    3,956,000    3,956,000   4,200,000      Transfer To LLD#1 (Medians & Trees)700,000    1,390,000   1,400,000    1,400,000   1,570,000     0.0% Transfer To Storm Water Program 281,040    322,000   332,000    332,000   340,000   0.0% Other Miscellaneous Transfers 47,031,506    993,748   10,608,252   ‐   ‐    ‐100.0% Total Transfers 57,012,546    26,927,804    24,208,252   13,600,000    21,910,000     61.1% Total Miscellaneous Non‐Departmental 60,122,092    28,666,183    23,586,252   14,621,658    23,266,700     59.1% Subtotal General Fund 216,412,690    198,690,857    212,492,054   197,945,022     211,209,604    6.7% Contingencies ‐    ‐    ‐     500,000    500,000   0.0% Total General Fund 216,412,690$      198,690,857$    212,492,054$     198,445,022$    211,709,604$    6.7% Special Revenue Funds Affordable Housing 4,674,625$       237,513$       288,618$      393,385$      668,530$      69.9% Agricultural Mitigation Fee ‐    ‐   392,687    ‐   ‐    ‐ Buena Vista Channel Maintenance 80,982   75,104    195,245    195,245   195,245   0.0% Citizens' Option For Public Safety 263,590    181,912   265,705    265,705   295,298   11.1% Community Activity Grants ‐    ‐   ‐    30,000    30,000   0.0% Community Development Block Grant 936,783    1,429,464   728,372    636,728   702,305   10.3% Cultural Arts Donations 25,447   37,840    85,489     131,750   148,750   12.9% Flower Fields Grant Program ‐    ‐   ‐    ‐   ‐    ‐ Habitat Mitigation Fee 16,961   14,535    52,002     ‐   ‐    ‐ Library And Arts Endowment Fund ‐    480     4,000    6,000   6,000    0.0% Library Gifts/Bequests 144,279    137,515   275,041    394,467   462,785   17.3% Lighting And Landscaping District 2 287,307    258,171   335,033    338,070   367,500   8.7% Local Cable Infrastructure Fund 336,001    403,843   435,000    395,006   538,956   36.4% Median Maintenance 1,036,374    1,067,645   1,476,870    1,329,900   1,396,580     5.0% Opioid Settlement Fund ‐    ‐   ‐    ‐   21,466   ‐ Parking In Lieu 48,244   49,674    53,000     53,000    56,000   5.7% Permanent Local Housing Allocation ‐    ‐   ‐    ‐   1,119,126     ‐ Police Asset Forfeiture 54,225   12,228    105,869    125,000   75,000   ‐40.0% Public Safety Grants 117,267    78,602    321,281    ‐   ‐    ‐ Recreation Donations 26,165   38,755    84,809     81,009    81,200   0.2% Rental Assistance 9,024,886    10,081,418    10,860,729   10,409,089    11,339,700    8.9% Senior Donations 5,367   37,796    43,500     50,500    33,500   ‐33.7% Street Lighting 777,332    927,419   916,850    1,065,393   1,100,077     3.3% Street Tree Maintenance 750,272    816,583   1,075,168    880,235   1,004,763     14.1% Tyler Court Apartments 474,209    915,040   748,339    540,716   604,523   11.8% Total Special Revenue Funds 19,080,316$        16,801,537$      18,743,607$       17,321,198$      20,247,304$      16.9% B‐33  SCHEDULE OF BUDGET EXPENDITURES 2022‐23 Change as % 2020‐21 2021‐22 Estimated 2022‐23 2023‐24 of 2022‐23 Department Actuals Actuals Expenditures Budget Budget Budget Enterprise Funds Water Operations 47,685,382$        44,316,249$      48,000,000$       49,715,832$      54,759,803$      10.1% Recycled Water Operations 7,603,103    8,124,171     9,000,000    11,206,521     11,849,122      5.7% Wastewater Operations 13,053,207     12,909,801      16,900,000    16,999,568     23,068,138      35.7% Solid Waste Management 5,003,349    4,744,618     4,982,227    5,801,402     5,950,634     2.6% Golf Course Operations 6,832,769    8,345,328     8,660,962    9,195,000     10,121,000      10.1% Total Enterprise Funds 80,177,810$        78,440,167$      87,543,189$       92,918,323$      105,748,697$    13.8% Internal Service Funds Workers' Compensation 3,408,864$          6,980,247$        6,267,000$         4,507,014$        5,157,892$        14.4% Risk Management 2,675,135    4,519,731     5,155,035    3,780,570     6,718,232     77.7% Self‐Insured Benefits 1,834,163    ‐      ‐    ‐     ‐      ‐ Vehicle Maintenance 3,239,389    3,523,778     4,017,238    3,506,140     3,696,339     5.4% Vehicle Replacement 2,342,065    2,494,913     7,398,750    5,293,745     1,068,564     ‐79.8% Information Technology 13,917,753     13,264,070      17,086,055    15,477,967     16,637,475      7.5% Total Internal Service Funds 27,417,369$        30,782,739$      39,924,078$       32,565,436$      33,278,502$      2.2% Trust Funds Successor Agency Housing Fund 239,902$          120,799$            1,038,203$         1,068,845$        1,059,500$        ‐0.9% Total Trust Funds 239,902$          120,799$         1,038,203$         1,068,845$        1,059,500$        ‐0.9% Total Operating Funds 343,328,087$      324,836,099$    359,741,131$     342,318,824$    372,043,607$    8.7% I-12 PROJECTED FUND BALANCES FOR FISCAL YEAR 2022-23 July 1, 2022 Projected June 30, 2023 Unreserved Projected Projected Debt Service Projected Fund Balance Revenues Expenditures Loans & Other Balance BTD#2 - Poinsettia Lane/Aviara Pkwy 587,724$ 1,881,644$ 38,730$ - 2,430,638$ BTD#3 - Cannon Road West 526,327 7,063 - - 533,390 CFD #1 - Citywide 96,751,249 3,504,178 774,991 15,984$ 99,464,452 Gas Tax 13,538,020 3,558,726 3,029,688 500,000 13,567,058 Gas Tax (Road Maint. & Rehab Acct.)6,546,359 2,709,681 5,606,349 - 3,649,691 General Capital Const.42,532,124 4,113,577 13,540,796 - 33,104,906 Grants - Federal 3,181 - 1,442 - 1,739 Grants - State - - - - - Infrastructure Replacement 118,511,911 5,557,667 11,027,079 - 113,042,499 Other 1,932,611 25,934 959,647 - 998,898 Park Fee Zones 5,13,16, 17, 18 4,798,572 166,666 - - 4,965,237 Park-In-Lieu NE 4,770,998 64,022 - - 4,835,020 Park-In-Lieu NW 2,580,013 484,137 106,743 - 2,957,406 Park-In-Lieu SE 1,783,139 422,162 62,000 - 2,143,301 Park-In-Lieu SW 809,275 40,561 - - 849,836 Planned Local Drainage Area A 1,002,649 13,444 51,586 - 964,507 Planned Local Drainage Area B 1,534,791 231,285 65,760 - 1,700,315 Planned Local Drainage Area C 1,590,152 21,333 31,827 - 1,579,658 Planned Local Drainage Area D 666,282 321,892 39,943 - 948,230 Public Facilities Fee 29,139,633 1,680,368 1,399,148 - 29,420,853 Sewer Connection 7,474,469 544,416 3,261,830 - 4,757,055 Sewer Replacement 19,137,934 5,538,049 8,119,066 - 16,556,916 Traffic Impact Fee 21,072,655 2,623,889 3,607,435 - 20,089,110 Transnet/Local 32,297,901 5,376,349 4,458,222 - 33,216,028 Water - Potable 36,615,366 1,228,365 151,270 - 37,692,461 Water - Recycled (10,898,586) - 1,817,501 - (12,716,086) Water Replacement - Potable 60,406,854 5,828,758 7,943,220 - 58,292,392 Water Replacement - Recycled 17,792,436 1,221,177 575,782 - 18,437,831 Total 513,504,037$ 47,165,341$ 66,670,055$ 515,984$ 493,483,340$ Attachment B I-13 PROJECTED FUND BALANCES FOR FISCAL YEAR 2023-24 July 1, 2023 June 30, 2023 July 01, 2023 2023-24 June 30, 2024 Projected Estimated Continuing New Total Projected Fund Balance Revenues Appropriations Appropriations Appropriations Balance BTD#2 - Poinsettia Lane/Aviara Pkwy 2,430,638$ - 401,346$ - 401,346$ 2,029,292$ BTD#3 - Cannon Road West 533,390 - - - - 533,390 CFD #1 - Citywide 99,464,452 3,345,149$ 33,545,577 37,452,000$ 70,997,577 31,812,024 Gas Tax 13,567,058 2,985,297 14,937,402 1,479,123 16,416,525 135,830 Gas Tax (Road Maint. & Rehab Acct.)3,649,691 2,857,289 3,256,447 3,070,000 6,326,447 180,533 General Capital Const.33,104,906 11,600,000 21,173,902 7,897,000 29,070,902 15,634,004 Grants - Federal 1,739 9,774,840 2,885,895 8,000,000 10,885,895 (1,109,316) Grants - State - 5,000,000 - 5,000,000 5,000,000 - Infrastructure Replacement 113,042,499 4,200,000 32,378,582 11,107,000 43,485,582 73,756,917 Other 998,898 - 323,489 - 323,489 675,409 Park Fee Zones 5,13,16, 17, 18 4,965,237 113,019 - - - 5,078,256 Park-In-Lieu NE 4,835,020 - 614,000 424,000 1,038,000 3,797,020 Park-In-Lieu NW 2,957,406 3,013,278 2,575,063 1,922,000 4,497,063 1,473,621 Park-In-Lieu SE 2,143,301 449,289 161,805 212,000 373,805 2,218,785 Park-In-Lieu SW 849,836 439,078 219,562 - 219,562 1,069,352 Planned Local Drainage Area A 964,507 30,974 46,208 - 46,208 949,274 Planned Local Drainage Area B 1,700,315 357,095 7,828 - 7,828 2,049,582 Planned Local Drainage Area C 1,579,658 283,664 31,335 75,000 106,335 1,756,986 Planned Local Drainage Area D 948,230 108,453 23,251 - 23,251 1,033,433 Public Facilities Fee 29,420,853 2,947,263 4,331,467 (47,000) 4,284,467 28,083,648 Sewer Connection 4,757,055 777,098 4,019,732 1,195,000 5,214,732 319,421 Sewer Replacement 16,556,916 10,445,506 28,077,191 6,152,500 34,229,691 (7,227,269) Traffic Impact Fee 20,089,110 4,743,682 17,505,669 3,590,000 21,095,669 3,737,122 Transnet/Local 33,216,028 5,886,000 27,489,757 5,640,000 33,129,757 5,972,270 Water - Potable 37,692,461 2,637,428 11,264,751 811,000 12,075,751 28,254,138 Water - Recycled (12,716,086) 15,998,990 2,957,903 - 2,957,903 325,000 Water Replacement - Potable 58,292,392 6,348,536 43,207,235 4,192,680 47,399,915 17,241,013 Water Replacement - Recycled 18,437,831 1,600,000 6,114,770 (494,600) 5,620,170 14,417,661 Total 493,483,340$ 95,941,926$ 257,550,167$ 97,677,703$ 355,227,870$ 234,197,396$ I-14 REVENUE PROJECTIONS SCHEDULE 2019-20 2020-21 2021-22 2022-23 2023-24 Actual Actual Actual Projected Estimated Fund Revenue Revenue Revenue Revenue Revenue BTD#2 - Poinsettia Lane/Aviara Pkwy 217,466$ 22,020$ (497,154)$ 1,881,644$ - BTD#3 - Cannon Road West 17,696 949 (21,419) 7,063 - CFD #1 - Citywide 5,736,415 2,286,479 (2,303,139) 3,504,178 3,345,149$ Gas Tax 3,118,353 2,733,074 2,195,851 3,558,726 2,985,297 Gas Tax (Road Maint. & Rehab Acct.)2,067,614 2,149,734 2,080,454 2,709,681 2,857,289 General Capital Const.5,111,500 4,654,470 13,296,442 4,113,577 11,600,000 Grants - Federal 41,175 256,529 34,140 - 9,774,840 Grants - State - - - - 5,000,000 Infrastructure Replacement 9,369,345 4,704,670 (4,498,884) 5,557,667 4,200,000 Other 65,369 3,384 (78,654) 25,934 - Park Fee Zones 5,13,16, 17, 18 255,028 78,182 (195,275) 166,666 113,019 Park-In-Lieu NE 347,407 451,497 (92,752) 64,022 - Park-In-Lieu NW 260,256 429,037 267,635 484,137 3,013,278 Park-In-Lieu SE 326,671 3,205 (55,340) 422,162 449,289 Park-In-Lieu SW 271,373 319,862 13,108 40,561 439,078 Planned Local Drainage Area A 48,111 27,489 (20,032) 13,444 30,974 Planned Local Drainage Area B 174,328 635,853 54,137 231,285 357,095 Planned Local Drainage Area C 53,875 2,779 (36,025) 21,333 283,664 Planned Local Drainage Area D 31,433 2,877 (12,992) 321,892 108,453 Public Facilities Fee 3,439,781 1,751,477 (556,423) 1,680,368 2,947,263 Sewer Connection 749,326 332,049 (159,776) 544,416 777,098 Sewer Replacement 5,682,839 4,390,568 3,959,756 5,538,049 10,445,506 Traffic Impact Fee 1,924,738 1,084,181 (399,069) 2,623,889 4,743,682 Transnet/Local 4,546,554 3,347,237 2,215,348 5,376,349 5,886,000 Water - Potable 2,188,356 713,234 (1,309,185) 1,228,365 2,637,428 Water - Recycled 2,815,693 59,190 - - 15,998,990 Water Replacement - Potable 7,885,252 6,378,189 1,734,930 5,828,758 6,348,536 Water Replacement - Recycled 1,995,701 1,083,332 726,017 1,221,177 1,600,000 Total 58,741,652$ 37,901,545$ 16,341,701$ 47,165,341$ 95,941,926$ I-15 BUDGET EXPENDITURE SCHEDULE 2020-21 2021-22 2022-23 2023-24 2023-24 2023-24 Actual Actual Estimated Continuing New Total FUND Expense Expense Expense Appropriations Appropriations Appropriations BTD#2 - Poinsettia Lane/Aviara Pkwy - 13,059,041$ 38,730$ 401,346$ - 401,346$ BTD#3 - Cannon Road West - -- - - - CFD #1 - Citywide 582,179$ 583,318 790,975 33,545,577 37,452,000$ 70,997,577 Gas Tax 2,911,799 2,605,882 3,529,688 14,937,402 1,479,123 16,416,525 Gas Tax (Road Maint. & Rehab Acct.)170,381 307,543 5,606,349 3,256,447 3,070,000 6,326,447 General Capital Const.5,086,290 12,606,427 13,540,796 21,173,902 7,897,000 29,070,902 Grants - Federal 260,820 26,669 1,442 2,885,895 8,000,000 10,885,895 Grants - State - - - - 5,000,000 5,000,000 Infrastructure Replacement 3,333,331 6,701,080 11,027,079 32,378,582 11,107,000 43,485,582 Other 8,868 2,587 959,647 323,489 - 323,489 Park Fee Zones 5,13,16, 17, 18 - - - - - - Park-In-Lieu NE - - - 614,000 424,000 1,038,000 Park-In-Lieu NW - - 106,743 2,575,063 1,922,000 4,497,063 Park-In-Lieu SE - 1,196 62,000 161,805 212,000 373,805 Park-In-Lieu SW 1,118 - - 219,562 - 219,562 Planned Local Drainage Area A 6,131 1,149 51,586 46,208 - 46,208 Planned Local Drainage Area B 1,510,279 77,250 65,760 7,828 - 7,828 Planned Local Drainage Area C 4,174 2,913 31,827 31,335 75,000 106,335 Planned Local Drainage Area D 49,311 12,358 39,943 23,251 - 23,251 Public Facilities Fee 164,847 2,635,240 1,399,148 4,331,467 (47,000) 4,284,467 Sewer Connection 810,372 611,405 3,261,830 4,019,732 1,195,000 5,214,732 Sewer Replacement 8,206,747 6,944,820 8,119,066 28,077,191 6,152,500 34,229,691 Traffic Impact Fee 1,196,826 2,806,082 3,607,435 17,505,669 3,590,000 21,095,669 Transnet/Local 2,152,292 1,922,954 4,458,222 27,489,757 5,640,000 33,129,757 Water - Potable 17,507 432,625 151,270 11,264,751 811,000 12,075,751 Water - Recycled 3,235,638 127,177 1,817,501 2,957,903 - 2,957,903 Water Replacement - Potable 5,224,472 1,467,222 7,943,220 43,207,235 4,192,680 47,399,915 Water Replacement - Recycled 792,286 2,531,036 575,782 6,114,770 (494,600) 5,620,170 Total 35,725,667$ 55,465,974$ 67,186,038$ 257,550,167$ 97,677,703$ 355,227,870$ I-17 15-YEAR CAPITAL IMPROVEMENT PROGRAM Project Name New Project District Score Funding ID Funding Source Current Appropriation Last Year (2022-23) Appropriated Year 1 (2023-24) Year 2 (2024-25) Year 3 (2025-26) Year 4 (2026-27) Year 6-10 (2029-33) Year 11-15 (2034-38) Total Funding Source Abandon Potable Services (New Recycled Services) NO Citywide Medium 52051 WATER REPL 925,825 50,000 250,000 500,000 - - - - 1,675,825 ADA Beach Access - Pine to Tamarack NO 1 Medium 60651 GCC 375,000 - - 2,500,000 - - - - 2,875,000 ADA Improvement Program NO Citywide High 60491 TRANSNET -LOC 3,155,000 715,000 175,000 715,000 175,000 715,000 2,225,000 2,225,000 9,560,000 Agua Hedionda Creek Maintenance NO 2 High 33381 PLDB 3,545,249 -14,645 - - - - - - 3,545,249 66291 IRF 213,000 80,000 80,000 85,000 90,000 95,000 520,000 585,000 1,768,000 Agua Hedionda Lift Station Biological Monitoring and Maintenance NO 2 Critical 55451 SEWER REPL 225,000 - - - - - - - 225,000 Alga Norte Park Medications NO 2 Medium 47331 GCC 314,000 -710,000 - - - - -1,024,000 Alga Norte Settlement Agreement YES 2 Null PA071 GCC - - 60,000 - - - - -60,000 Assessment District 97-1 Maintenance NO 3 Medium 60841 GCC 420,000 - - - - - - - 420,000 Avenida Encinas Coastal Rail Trail and NO 2,3 Critical 60041 TIF 5,177,903 3,177,000 -2,500,000 - - - - 7,677,903 Pedestrian Improvements 60042 FED GRANT 1,776,000 - - - - - - - 1,776,000 Aviara and Hidden Canyon Parks Playground Safety Resurfacing NO Citywide Low 47451 IRF 600,000 - - - - - - - 600,000 Aviara Reimbursement Agreement NO 2 Low 36491 PIL-SW 238,000 - - - - - - - 238,000 Barrio Street Lighting NO 1 High 40131 GCC 760,000 - - - - - - - 760,000 40133 GAS TAX 700,000 --550,000 - - - - -150,000 40134 TRANSNET -LOC 1,280,000 1,280,000 1,280,000 1,030,000 - - - - 3,590,000 40135 FED GRANT - - 1,000,000 - - - - -1,000,000 Beach Access Repair and Upgrades - NO 1 Critical 38961 IRF 5,912,750 1,800,000 700,000 - - - - -6,612,750 Pine Avenue to Tamarack 38962 GCC 6,199,000 -700,000 - - - - -6,899,000 Bridge Preventative Maintenance Program NO Citywide Medium 60661 IRF 2,477,511 250,000 500,000 700,000 900,000 900,000 - - 6,427,511 Buena Interceptor Sewer Access Road Improvements NO 3 High 55371 SEWER REPL 1,150,000 --650,000 650,000 - - - - 1,150,000 Buena Interceptor Sewer Improvements NO 2,3 High 55011 SEWER REPL 1,208,686 250,000 - - 2,950,000 2,950,000 3,540,000 -14,188,686 55012 SEWER CONN 550,000 - - - - - - - 550,000 Buena Interceptor Sewer Realignment - East Segment NO 2 High 55441 SEWER REPL 507,000 - - 1,200,000 1,200,000 2,400,000 - - 7,107,000 Buena Vista Creek Concrete Channel NO 1 Critical 66191 GCC 1,250,000 - - - 30,000 30,000 324,000 546,000 2,330,000 Maintenance at El Camino Real 66192 IRF 2,820,000 - - 500,000 - - - - 3,320,000 Business Park Recreational Facility (Partial Funding) (Zone 5 Park) NO 2 Low 19041 ZONE 5 - - - 1,500,000 - - 16,500,000 -18,000,000 C Tank Access Road and Electrical NO 2 Medium 52151 RECL REPL 250,000 250,000 -1,000,000 - - - - 1,250,000 Improvements 52152 RECL CONN 50,000 50,000 -325,000 - - - - 375,000 Calavera Hills Community Center Refurbishment NO 2 Medium 47461 IRF 1,985,000 1,300,000 - - - - - - 1,985,000 Calavera Hills Community Park Gateway Improvements NO 2 High 46011 GCC 1,407,850 - - - - - - - 1,407,850 Attachment B2 I-18 Project Name New Project District Score Funding ID Funding Source Current Appropriation Last Year (2022-23) Appropriated Year 1 (2023-24) Year 2 (2024-25) Year 3 (2025-26) Year 4 (2026-27) Year 6-10 (2029-33) Year 11-15 (2034-38) Total Funding Source Camino De Los Coches and La Costa Avenue Intersection Control NO 4 Critical 63251 GAS TAX 350,000 - - - 1,500,000 - - - 1,850,000 Camino Hills and Jackspar Drive Slope Stabilization NO 2 Medium 60301 GCC 859,400 - - - - - - - 859,400 Cannon Park Restroom NO 2 Low 47261 GCC 45,765 - - - - - - - 45,765 Cannon Road Lift Station Improvements NO 2 High 55521 SEWER REPL 715,000 565,000 50,000 - - - - -765,000 Carlsbad Boulevard and Tamarack NO 1 Critical 60581 GAS TAX 1,576,000 -195,000 445,000 2,000,000 - - - 4,216,000 Avenue Intersection Improvement 60583 TRANSNET -LOC 1,054,000 - - - - - - - 1,054,000 Carlsbad Boulevard Emergency Repair NO 3 Critical 60631 GAS TAX 841,000 - - - - - - - 841,000 Carlsbad Boulevard Lane Reduction and Edge Striping NO 2,3 High 60961 GAS TAX 300,000 - - - - - - - 300,000 Carlsbad Boulevard Median - Tamarack NO 1 Low 19071 Avenue to Pine Avenue GAS TAX - - - - - - - 2,763,000 2,763,000 Carlsbad Boulevard Pedestrian NO 1 High 60971 GAS TAX 1,055,888 - - - - - - - 1,055,888 Improvement Project 60972 FED GRANT - - - - - - - - - 60973 STATE GRANT 591,600 591,600 - - - - - - 591,600 Carlsbad Boulevard Pedestrian Lighting NO 1 High 60681 TRANSNET -LOC 1,325,000 - - - - - - - 1,325,000 Carlsbad Boulevard Realignment - Manzano Drive to Island Way NO 2 Low 19081 TIF - - - - - - - 932,000 932,000 Carlsbad Boulevard Realignment - NO 2 Low 19091 Manzano Drive to Island Way (RTCIP) TIF - - - - - - - 3,681,000 3,681,000 Carlsbad Boulevard Roadway Configuraton YES 1,2,3 High 24121 IRF - - 2,000,000 - - - - -2,000,000 Carlsbad Boulevard Waterline NO 2 Critical 50481 Replacement at Terramar WATER REPL 4,730,000 1,300,000 - - - - - - 4,730,000 Carlsbad Village Drive and Grand Avenue Pedestrian and Crossing Improvements NO 1 Medium 19121 TRANSNET -LOC - - - - -1,320,000 - - 1,320,000 Carlsbad Village Drive Reconfiguraton YES 1 High 24031 GCC - - 350,000 1,500,000 - - - - 1,850,000 Carlsbad Village Drive Widening - Pontiac Drive to Victoria Avenue NO Citywide High 19131 TIF - - - - - - - - - 19132 GAS TAX - - - - 700,000 2,500,000 - - 3,200,000 19133 TRANSNET -LOC - - - - - - - - - Carlsbad Water Recycling Facility (Encina Capital Projects) NO 3 High 52031 WATER REPL 599,944 - - - - - - - 599,944 52032 RECL REPL 4,057,710 366,000 767,000 949,000 1,992,000 237,000 1,325,000 1,325,000 10,920,710 Carlsbad Water Recycling Facility Irrigation and Landscape NO 3 High 52131 RECL REPL 175,000 --140,000 - - - - -35,000 Carlsbad Water Recycling Facility Roof Replacement NO 3 Low 47491 RECL REPL 225,000 -156,000 - - - - -381,000 Cathodic Protection Program NO Citywide Critical 50071 WATER REPL 1,796,700 190,000 190,000 190,000 190,000 190,000 260,000 280,000 3,286,700 50072 RECL REPL - - 100,000 100,000 - - - - 200,000 CFD#1 Administration NO 2,3 Low 19151 CFD#1 -110,000 110,000 110,000 110,000 110,000 - - 440,000 Chestnut Avenue Complete Street Improvements - Valley to Pio Pico NO 1 Medium 19161 TRANSNET -LOC - - - 1,080,000 - - - - 1,080,000 Chestnut Complete Street I-5 to NO 1 Medium 60691 Railroad Project Study TRANSNET -LOC - - 85,000 - - - - -85,000 I-19 Project Name New Project District Score Funding ID Funding Source Current Appropriation Last Year (2022-23) Appropriated Year 1 (2023-24) Year 2 (2024-25) Year 3 (2025-26) Year 4 (2026-27) Year 6-10 (2029-33) Year 11-15 (2034-38) Total Funding Source Chestnut Underpass Public Art Project NO 1 Medium 60981 GCC 400,000 150,000 - - - - - - 400,000 Chinquapin Lift Station Improvements NO 1 High 55541 SEWER REPL 300,000 300,000 920,000 - - - - -1,220,000 Christiansen Way Improvements NO 1 Medium 19171 TRANSNET -LOC - - - - 310,000 - - - 310,000 City Facility Accessibility Upgrades NO Citywide Medium 47271 GCC 500,000 - - - - - - - 500,000 City Facility Safety and Parking Lot NO Citywide High 60741 IRF 1,910,000 - - - - - - - 1,910,000 Lighting Assessment 60742 PIL-NW - - 200,000 - - - - -200,000 City Fire Stations Wash Water BMPs NO Citywide Medium 66161 GCC 280,000 - - - - - - - 280,000 City Hall Complex NO Citywide Critical 40081 CFD#1 1,028,105 - - - - -48,500,000 -51,028,105 City Hall Complex Refurbishment NO 1 Medium 47181 IRF 1,144,000 - - - - - - - 1,144,000 City Hall Exterior Refurbishment NO 1 Critical 47251 GCC 2,250,000 - - - - - - - 2,250,000 Citywide Drainage Improvement NO 1 High 66082 GAS TAX 6,090,594 - - - - - - - 6,090,594 Program 66083 IRF 5,581,500 900,000 300,000 950,000 300,000 500,000 2,500,000 2,500,000 12,931,500 Citywide Street Lighting Program NO Citywide Medium 60921 GAS TAX 150,000 - - - - - - - 150,000 Citywide Thermoplastic Pavement NO Citywide Critical 60931 Markings GAS TAX 50,000 - - - - - - - 50,000 Cole Library Expansion NO 1 Low 19211 CFD#1 - - - - - - - 5,488,000 5,988,000 19212 PFF - - - - - - - 11,936,000 11,936,000 19213 GCC - - - - - - - 1,000,000 1,000,000 Cole Library Security Fencing NO 1 Low 47501 IRF 170,000 130,000 - - - - - - 170,000 College Boulevard - Cannon Road to Badger Lane (375 Zone) NO 2 Low 50131 WATER CONN 278,383 28,200 -1,250,000 - - - - 1,528,383 College Boulevard - Cannon Road to NO 2 Low 50121 Badger Lane (490 Zone) WATER CONN 312,600 12,600 -1,250,000 - - - - 1,562,600 College Boulevard Extension NO 2 Low 36362 OTHER 1,713,002 - - - - - - - 1,713,002 36363 PLDB - - - - - - - - - 36364 TRANSNET -LOC 1,205,000 - - - - - - - 1,205,000 Concrete Repair/Replacement NO Citywide High 60132 GAS TAX 2,933,000 -200,000 220,000 250,000 290,000 1,850,000 1,850,000 7,933,000 Program 60133 RMRA 1,347,000 620,000 620,000 620,000 620,000 620,000 3,100,000 3,100,000 10,647,000 Coordinated Traffic Signal Program NO Citywide High 63261 TRANSNET -LOC 2,583,979 - - - - - - - 2,583,979 63264 TRANSNET -LOC 1,000,000 - - - - - - - 1,000,000 63265 IRF 800,000 - - - - - - - 800,000 Crestview Drive Transmission Main NO 1 Medium 50331 WATER REPL 321,000 21,000 284,000 - - - - -605,000 Desalinated Water Flow Control NO 2 High 50381 Facility No. 5 WATER CONN 10,811,601 707,301 758,000 - - - - -11,569,601 DMP Facility AAA (Jefferson Street) NO 1 Low 19231 PLDA - - - - - - - 290,000 290,000 I-20 Project Name New Project District Score Funding ID Funding Source Current Appropriation Last Year (2022-23) Appropriated Year 1 (2023-24) Year 2 (2024-25) Year 3 (2025-26) Year 4 (2026-27) Year 6-10 (2029-33) Year 11-15 (2034-38) Total Funding Source DMP Facility AAAA (Madison Street) NO 1 Medium 19241 PLDA - - - - - - - 417,000 417,000 DMP Facility AC (Highland Drive Drainage Project) NO 1 Medium 66091 PLDA - - - - - - - 922,000 922,000 DMP Facility AFA (Hidden Valley Drainage Restoration and Enhancement Project) NO 2 Low 19251 PLDA - - - - - - - 92,000 92,000 DMP Facility AFB (Calavera Hills Drainage Restoration and Enhancement Project) NO 2 Low 19261 PLDA - - - - - - - 164,000 164,000 DMP Facility BB 1 and 2 (Washington NO 1 Low 19271 Street) PLDB - - - - - - - 1,087,000 1,087,000 DMP Facility BCB (Magnolia Avenue) NO 1 Medium 19281 PLDB - - - - - - - 469,000 469,000 DMP Facility BFB-L and BFB-1 (Tamarack and El Camino Real Plda "B") NO 1 Low 19291 PLDB - - - - - - - 905,000 905,000 DMP Facility BFB-U (El Camino Real) NO 1 High 66221 PLDB 153,489 - - - - - - - 153,489 66222 IRF 850,000 100,000 -5,500,000 50,000 60,000 350,000 450,000 7,330,000 DMP Facility BL-L (College Boulevard Bridge Reimbursement Plda "B") NO 2 Low 19301 PLDB - - - - - - 1,817,000 -1,817,000 DMP Facility BL-U (College Boulevard) NO 2 Low 19311 PLDB - - - - - - - 385,000 385,000 DMP Facility BM (Cantarini/College Boulevard Box Culvert) NO 2 Low 19321 PLDB - - - - - - - 205,000 205,000 DMP Facility BQ (Sunny Creek) NO 2 Low 19331 PLDB - - - - - - - 132,000 132,000 DMP Facility BR (Cantarini/College Boulevard Pipe Drainage) NO 2 Low 19341 PLDB - - - - - - - 181,000 181,000 DMP Facility C2 (Paseo Del Norte) NO 3 Low 19351 PLDC - - - - - - - 728,000 728,000 DMP Facility CA (Avenida Encinas) NO 3 Low 19361 PLDC - - - - - - - 530,000 530,000 DMP Facility DBA (Poinsettia Village) NO 4 Low 19371 PLDD - - - - - - - 168,000 168,000 DMP Facility DBB (Avenida Encinas) NO 4 Low 19381 PLDD - - - - - - - 430,000 430,000 DMP Facility DFA (Batiquitos Lagoon NO 4 Low 19391 Stormwater Treatment) PLDD - - - - - - - 257,000 257,000 DMP Facility DH (Altive Place Canyon Restoration) NO 3 Low 19401 PLDD - - - - - - - 233,000 233,000 DMP Facility DQB (La Costa Town NO 4 Medium 19411 Center) PLDD - - - - - - - 746,000 746,000 DMP Facility DZ (Poinsettia Lane) NO 3 High 19421 PLDD - - - - - - - 643,000 643,000 Dove Library Lighting Improvements NO 3 Low 40811 GCC 225,000 - - - - - - - 225,000 Drainage Master Plan Update NO Citywide High 66231 PLDA 216,512 25,000 - - - - - - 216,512 66232 PLDB 583,000 25,000 - - - - - - 583,000 66233 PLDC 171,890 25,000 75,000 - - - - -246,890 66234 PLDD 234,598 - - - - - - - 234,598 El Camino Real and Agua Hedionda Creek Bridge Railing and Sidewalk NO 2 Critical 60561 IRF 210,000 - - - - - - - 210,000 El Camino Real and Cannon Road NO 2 Critical 60421 TIF 3,536,000 - - - - - - - 3,536,000 Intersection Improvements 60422 GAS TAX 837,000 --175,877 - - - - -661,123 El Camino Real Medians NO Citywide Low 36431 PFF 695,780 - - - - - - - 695,780 I-21 Project Name New Project District Score Funding ID Funding Source Current Appropriation Last Year (2022-23) Appropriated Year 1 (2023-24) Year 2 (2024-25) Year 3 (2025-26) Year 4 (2026-27) Year 6-10 (2029-33) Year 11-15 (2034-38) Total Funding Source El Camino Real Medians NO Citywide Low 36432 GAS TAX 904,530 - - - - - - - 904,530 El Camino Real Right Turn Lane to East Bound Alga Road NO 3 Low 19441 TIF - - - - - - 438,000 -438,000 El Camino Real Widening - Arenal Road to La Costa Avenue NO 4 High 39043 GAS TAX - - 1,450,000 - - - - -1,450,000 60511 TIF 3,250,000 -4,000,000 - - - - -7,250,000 60512 WATER REPL - - 1,000,000 - - - - -1,000,000 El Camino Real Widening - Poinsettia Lane to Camino Vida Roble NO 2 Critical 60721 TRANSNET -LOC 3,155,000 50,000 - - - - - - 3,155,000 60722 FED GRANT 1,440,000 - - - - - - - 1,440,000 El Camino Real Widening - Sunny Creek to Jackspar NO 2 Critical 60941 TRANSNET -LOC 5,010,000 1,010,000 - - - - - - 5,010,000 El Fuerte Lift Station Pump Addition NO 2 Medium 55531 SEWER CONN 180,000 -200,000 450,000 - - - - 830,000 Encina Capital Projects (EWPCF) NO Citywide Critical 58011 SEWER REPL 55,191,101 6,368,000 6,278,000 8,450,000 8,002,500 7,758,000 42,644,000 39,175,000 175,450,601 Faraday and El Camino Real Sewer Replacement - Orion to Palomar Airport Road NO 2 High 55391 SEWER CONN 1,740,000 1,600,000 1,100,000 - - - - -2,840,000 Faraday Avenue Improvements NO 2 High 60991 GCC 100,000 -175,000 500,000 - - - - 775,000 Faraday Center Refurbishment NO 2 Medium 47201 IRF 3,154,380 - - - - - - - 3,154,380 Fire Flow Capacity System NO 1 Medium 50431 Improvements WATER REPL 210,000 -1,500,000 415,000 2,000,000 2,500,000 3,000,000 - - 8,125,000 Fire Station 2 Replacement NO 4 High 40601 GCC 13,000,000 - - - - - - - 13,000,000 40602 IRF 1,433,882 - - - - - - - 1,433,882 Fire Station 7 YES 2 Medium 24131 GCC - - 100,000 200,000 - - - - 300,000 Fleet Fuel Island Upgrade NO 2 High 47471 IRF 2,263,800 500,000 1,800,000 400,000 400,000 100,000 - - 4,963,800 Fleet Maintenance Refurbishment NO 2 High 47141 IRF 2,574,000 500,000 -1,500,000 - - - - 4,074,000 47142 GCC 896,100 - - 700,000 - - - - 1,596,100 Foxes Landing Lift Station Wetwell and Pump Replacement NO 1 Critical 55261 SEWER REPL 6,392,000 700,000 - - - - - - 6,392,000 Grand Avenue Promenade NO 1 Medium 40612 GCC 200,000 200,000 100,000 -500,000 - - - 800,000 Guardrail Replacement and Improvement Program NO Citywide Medium 60871 GAS TAX 300,000 --150,000 - - - - -150,000 Harding Center Refurbishment NO 1 Low 47081 IRF 165,000 -140,000 - - - - -305,000 Headwall Replacement Program NO 1 Medium 66241 IRF 510,000 - - - - - - - 510,000 Hosp Grove Park Improvements NO 1 Low 47281 IRF 1,562,000 - - - - - - - 1,562,000 47282 PIL-NW 1,120,000 1,000,000 222,000 1,403,000 - - - - 2,745,000 Hydroelectric Generation at Water Facilities NO 2 Low 50591 WATER CONN 428,000 28,000 33,000 385,000 -1,225,000 - - 2,071,000 Intelligent Traffic Control Devices NO Citywide Low 66341 GAS TAX 200,000 - - - - - - - 200,000 Kelly Drive and Park Drive Complete NO 1 High Street Improvements 60751 TRANSNET -LOC 4,675,000 500,000 - - - - - - 4,675,000 60753 GAS TAX 130,000 - - - - - - - 130,000 I-22 Project Name New Project District Score Funding ID Funding Source Current Appropriation Last Year (2022-23) Appropriated Year 1 (2023-24) Year 2 (2024-25) Year 3 (2025-26) Year 4 (2026-27) Year 6-10 (2029-33) Year 11-15 (2034-38) Total Funding Source Kelly Drive and Park Drive Complete Street Improvements NO 1 High 60754 PFF 1,085,000 --87,000 - - - - -998,000 Kelly Drive Channel Repair NO 1 Medium 66061 IRF 1,541,000 500,000 -2,100,000 - - - - 3,641,000 La Costa Avenue Traffic Improvements NO 4 Medium 60761 GAS TAX 121,300 - - 100,000 141,000 500,000 - - 862,300 Laguna Drive Storm Drain NO 1 Medium 66281 GAS TAX 256,000 - - - 1,000,000 -1,494,000 -2,750,000 Lake Calavera Outlet Improvements NO 2 Critical 50541 GCC 1,436,001 - - - - - - - 1,436,001 Lake Calavera Reservoir Maintenance NO 2 High 50492 GCC 581,001 50,000 -160,000 50,000 50,000 250,000 250,000 1,391,001 Las Palmas Roof Replacement NO 2 Medium 47521 IRF 500,000 - - - - - - - 500,000 Las Palmas Trunk Sewer NO 2 High 55401 SEWER CONN 556,000 --255,000 255,000 1,320,000 1,320,000 - - 3,196,000 Leo Carrillo Ranch Park Phase 3 - NO 3 Low 46021 PFF 1,631,500 - - - - - - - 1,631,500 Stables Restoration and Restroom Construction 46022 PIL-SE 1,329,989 -4,111 - - - - - - 1,329,989 46023 PFF 288 -29,367 - - - - - - 288 Leo Carrillo Ranch Park Phase 3B NO 3 Medium 23071 PIL-SE - - - 540,000 540,000 1,484,000 - - 2,564,000 Leo Carrillo Ranch Roof Repairs NO 3 High 47481 IRF 1,450,000 - - - - - - - 1,450,000 Library Fire Alarm Panel Upgrades NO 1,3 Low 47411 IRF 180,000 - - - - - - - 180,000 Limited Access Pipeline Relocation NO 1,3 Critical 50351 Program WATER REPL 1,940,000 -761,000 -6,348,000 2,875,000 - - 11,924,000 Loan Repay - Park-in-Lieu NE to Public Facility Fee Fund NO Null Null PA041 PIL-NE - - - - - - - 4,550,000 4,550,000 Loan Repay - Park-in-Lieu SW to Public NO Null Null PA021 Facility Fee Fund PIL-SW - - - - - - - 1,100,000 1,100,000 Loan Repay - Sewer Conn to Sewer Repl NO Null High PA031 SEWER CONN - - - - - - - - - Maerkle Facility Improvements NO 2 Critical 50091 WATER REPL 2,735,200 500,000 800,000 - - - - -3,535,200 Maerkle Reservoir Solar Project NO 2 Medium 47222 WATER REPL 249,170 249,170 - - - - - - 249,170 Maerkle Reservoir Transmission Main NO 2 Medium 50011 WATER REPL 773,000 --578,000 244,000 2,130,000 2,023,000 - - 4,592,000 50012 WATER CONN - - - 236,000 1,660,000 1,567,000 - - 3,463,000 Marca Place Drainage Improvements NO 4 Medium 66141 GAS TAX 65,000 - - - - - - - 65,000 Melrose Drive Right Turn Lane to West Bound Palomar Airport Road NO 2 High 60341 TIF 911,000 - - - - - - - 911,000 Miscellaneous City Building NO Citywide Medium 47231 Improvements IRF 1,865,000 150,000 150,000 150,000 - - 750,000 750,000 3,665,000 Monroe Street Pool Replacement NO 1 High 47241 IRF 1,748,764 -4,438,236 - - - - - - 1,748,764 47242 GCC 236 -61,764 - - - - - - 236 47243 PIL-NW 1,561,764 1,561,764 1,500,000 - - - - -3,061,764 New Village Arts Building Roof and Exterior Refurbishment NO 1 Low 47391 IRF 313,626 - - - - - - - 313,626 New Village Arts Tenant Improvements NO 1 Medium 47551 GCC 613,000 - - - - - - - 613,000 Normally Closed Valve (Install NO 3 High 50501 Motorized Valve) WATER REPL 985,000 500,000 300,000 - - - - -1,285,000 I-23 Project Name New Project District Score Funding ID Funding Source Current Appropriation Last Year (2022-23) Appropriated Year 1 (2023-24) Year 2 (2024-25) Year 3 (2025-26) Year 4 (2026-27) Year 6-10 (2029-33) Year 11-15 (2034-38) Total Funding Source North Batiquitos Access Road Improvement NO 4 High 55471 SEWER REPL 363,800 113,800 26,000 - - - - -389,800 North Batiquitos Lift Station Forcemain Rehabilitation NO 4 High 55361 SEWER REPL 200,000 -750,000 -125,000 - - - - -75,000 Ocean Street Reconfiguration Concepts Study NO 1 Medium 60781 GCC - - - 200,000 - - - - 200,000 Ocean Street Restroom Facility NO 1 Medium 47291 GCC 775,000 - - - 63,000 - - - 838,000 Odor and Corrosion Prevention Program NO Citywide Medium 55201 SEWER REPL 320,000 - - - - - - - 320,000 Open Space and Trail Acquisition (Prop C) NO Citywide Medium 40831 GCC 4,015,000 - - - - - - - 4,015,000 Orion Center NO 2 High 35721 CFD#1 35,257,727 - - - - - - - 35,257,727 35722 WATER REPL 6,789,409 --6,289,409 6,290,000 - - - - 6,790,000 35723 SEWER REPL 4,078,500 --3,778,500 3,779,000 - - - - 4,079,000 35724 CFD#1 429 - - - - - - - 429 35725 RECL REPL 2,715,600 --2,515,600 2,516,000 - - - - 2,716,000 Orion Complex Energy Storage NO 2 Medium 23101 GCC - - - - -250,000 - - 250,000 Palomar Airport Road and Avenida Encinas Growth Management Plan Improvements NO 2,3 High 61021 GAS TAX 230,000 - - - - - - - 230,000 Palomar Airport Road and College NO 2 High 60281 Boulevard Improvements TIF 1,295,500 - - - - - - - 1,295,500 Palomar Airport Waterline Realignment NO 2 Critical 50551 WATER REPL 2,333,000 560,000 - - - - - - 2,333,000 Park Drive Street and Drainage NO 1 Critical 66111 GCC 717,439 - - - - - - - 717,439 Improvement 66112 GAS TAX 3,965,000 1,030,000 - - - - - - 3,965,000 Parking Lot Maintenance Program NO 1 Medium 60521 IRF 1,590,000 60,000 130,000 550,000 160,000 700,000 2,750,000 2,110,000 8,165,000 Pavement Management Program NO Citywide High 60011 TRANSNET -LOC 19,186,563 -1,150,000 1,650,000 1,650,000 1,650,000 8,250,000 8,250,000 43,436,563 60012 GAS TAX 7,930,850 - - - - - - - 7,930,850 60013 TRANSNET -LOC 16,346,476 2,200,000 950,000 950,000 950,000 950,000 4,750,000 4,750,000 30,596,476 60016 RMRA 10,336,000 2,300,000 2,450,000 2,450,000 2,450,000 2,700,000 13,500,000 13,500,000 50,086,000 Pine Avenue Park - Phase II NO 1 Medium 46031 PIL-NW 2,197,000 - - - - - - - 2,197,000 (Community Building) 46032 PFF 9,328,418 -687,622 - - - - - - 9,328,418 46033 PFF 123,300 -1 - - - - - - 123,300 Poinsettia Community Park - Phase 4 - NO 3 High 46081 PFF 2,838,140 - - - - - - - 2,838,140 Dog Park 46082 PFF - - - - - - - - - Poinsettia Lane - Cassia Road to Skimmer Court (Reimbursement Agreement) NO 3 High 50451 WATER CONN 600,000 - - - - - - - 600,000 Poinsettia Lift Station Rehabilitation NO 2 High 55561 SEWER REPL - - 650,000 -8,250,000 - - - 8,900,000 Police and Fire Headquarters NO 2 High 47151 IRF 10,122,342 129,292 2,427,000 - - - - -12,549,342 Renovation 47152 GCC 11,373,500 400,000 1,723,000 - - - - -13,096,500 I-24 Project Name New Project District Score Funding ID Funding Source Current Appropriation Last Year (2022-23) Appropriated Year 1 (2023-24) Year 2 (2024-25) Year 3 (2025-26) Year 4 (2026-27) Year 6-10 (2029-33) Year 11-15 (2034-38) Total Funding Source Pressure Reducing Station Program NO Citywide Critical 50201 WATER REPL 5,831,040 600,000 600,000 600,000 600,000 600,000 3,000,000 3,000,000 14,831,040 Public Beach Access Improvements NO 1 Low 60571 GCC 3,610,336 - - - - - - - 3,610,336 (Ocean Street) 60572 IRF 573,431 -153,252 - - - - - - 573,431 Public Works Storage Facility YES Citywide High 24011 GCC - - 99,000 - - - - -99,000 Rancho Carlsbad Groundwater Supply NO 2 Low 50611 WATER CONN 200,000 - - - 125,000 -1,425,000 -1,750,000 50612 WATER REPL 200,000 - - - 125,000 -1,425,000 -1,750,000 Rancho Santa Fe Trail Slope Improvements NO 4 Medium 60881 GCC 350,000 - - - - - - - 350,000 Recycled Water Condition Assessment Program NO Citywide High 52111 RECL REPL 750,000 50,000 50,000 50,000 50,000 50,000 280,000 310,000 1,590,000 Recycled Water Phase 3 - Reservoir NO 3 High 52101 WATER REPL 980,000 --800,000 - - - - -180,000 52102 RECL REPL 3,320,000 200,000 200,000 - - - - -3,520,000 Recycled Water Pipeline Replacement NO 2 Medium 52161 RECL REPL - - 350,000 350,000 350,000 350,000 2,150,000 2,910,000 6,810,000 Recycled Water Valve and Appurtenance Replacement Program NO Citywide High 52121 RECL REPL 380,000 120,000 -120,000 125,000 125,000 630,000 700,000 2,205,000 Reservoir Condition Assessment and NO Citywide High Repair Program 50241 WATER REPL 5,850,000 -2,040,000 - - - 3,070,000 3,610,000 14,570,000 50242 RECL REPL - - 200,000 - - - - -200,000 Retroreflectvity Sign Replacement Program NO Citywide Medium 60371 GAS TAX 1,000,000 - - - - - - - 1,000,000 Roadway Improvements - Coastal Area Analysis and Implementation NO Citywide Medium 60791 GCC 200,000 - - - - - - - 200,000 Roadway Slope Stabilization NO Citywide Medium 60811 GAS TAX 780,000 200,000 -500,000 - - - - 1,280,000 Robertson Ranch Park Development NO 2 High 38011 PIL-NE 614,000 214,000 424,000 - - - - -1,038,000 (Partial Funding) 38012 PFF - - - - - - - - - Romeria Drainage Improvements NO 4 High 66041 GCC 410,000 - - - - - - - 410,000 66042 GAS TAX 347,940 - - - - - - - 347,940 Safety Training Center Settlement NO 2 Low 47431 GCC 1,156,995 - - - - - - - 1,156,995 San Luis Rey Mission Basin NO Citywide Low Groundwater Supply 50441 WATER CONN --277,500 20,000 - - - 15,700,000 15,200,000 31,420,000 50442 WATER REPL --77,500 - - - - - - - Santa Fe II Inlet Pipeline NO Null High 50571 WATER REPL 529,650 34,650 -206,000 115,000 1,920,000 - - 2,770,650 Santa Fe II Reservoir Site Electrical Improvements NO 3 Medium 50461 WATER REPL 183,581 150,000 110,000 - - - - -293,581 SCADA Improvements NO Citywide Critical 55421 SEWER REPL 4,303,898 175,165 381,000 - - - - -4,684,898 55422 WATER REPL 7,132,600 3,209,200 2,413,000 611,000 - - - - 10,156,600 55423 RECL REPL 1,658,400 632,000 338,000 398,000 - - - - 2,394,400 Schulman Auditorium and Cannon Art Gallery NO 3 Medium 47531 IRF 350,000 150,000 1,300,000 - - - - -1,650,000 Senior Center Repairs and Roof NO 1 Medium 47381 Replacement IRF 1,848,000 600,000 1,310,000 - - - - -3,158,000 I-25 Project Name New Project District Score Funding ID Funding Source Current Appropriation Last Year (2022-23) Appropriated Year 1 (2023-24) Year 2 (2024-25) Year 3 (2025-26) Year 4 (2026-27) Year 6-10 (2029-33) Year 11-15 (2034-38) Total Funding Source Senior Center Security Fencing NO 1 Low 47541 IRF 78,000 58,000 - - - - - - 78,000 Sewer Condition Assessment NO Citywide Critical 55131 SEWER REPL 1,558,000 100,000 100,000 100,000 100,000 -500,000 500,000 2,958,000 Sewer Lift Station Repairs and Upgrades NO 2 Critical 38401 SEWER REPL 4,385,380 150,000 150,000 150,000 150,000 150,000 750,000 750,000 6,635,380 Sewer Line Capacity Improvements NO 1 High 55481 SEWER REPL 1,200,000 1,000,000 200,000 620,000 944,000 - - - 2,964,000 Sewer Modeling NO Citywide Medium 55461 SEWER CONN 300,000 --100,000 - - - - -200,000 Sewer Monitoring Program (Capacity) NO Citywide High 55041 SEWER CONN 642,000 - - 44,000 - - 154,000 110,000 950,000 Sewer System Rehabilitation and Replacement NO 1,2,3 High 55031 SEWER REPL 9,426,475 1,200,000 1,200,000 1,850,000 1,850,000 1,850,000 13,350,000 14,050,000 45,426,475 Sidewalk/Street Construction Program NO Citywide High 60021 TIF 3,800,000 --500,000 - - - - -3,300,000 60022 GAS TAX - - - 988,000 633,000 108,000 2,390,000 2,835,000 7,704,000 South Carlsbad Coastline NO 2,3,4 Medium 60311 TRANSNET -LOC 1,779,026 -1,000,000 - - - - -2,779,026 South Shore Agua Hedionda Lagoon Trail NO 2 High 40851 GCC 789,940 34,440 - - - - - - 789,940 Stagecoach Community Park NO 4 High 46111 Community Gardens PIL-SE 225,000 225,000 212,000 - - - - -437,000 Stagecoach Park Synthetic Turf Replacement NO 4 Low 47421 IRF 2,200,000 - - - - - - - 2,200,000 State Street and Grand Avenue Road NO 1 Medium 60821 Improvements TRANSNET -LOC - - - - 325,000 - - - 325,000 State Street Parking Lot Electric Vehicle Charging Stations NO 1 Medium 40901 PFF 300,000 -40,000 - - - - -340,000 Storm Drain Condition Assessment NO Citywide Medium 66201 IRF 870,000 270,000 -270,000 300,000 350,000 2,375,000 3,000,000 7,565,000 Storm Drain System Rehab and Repair Program NO Citywide Medium 66071 IRF 5,191,360 200,000 270,000 290,000 310,000 330,000 1,900,000 2,200,000 10,841,360 Street Lighting Replacement Program NO Citywide High 60621 GCC 319,269 - - - - - - - 319,269 60622 TRANSNET -LOC 3,325,000 - - - - - - - 3,325,000 Sustainable Mobility Plan Implementation Program NO Citywide High 61041 GAS TAX 510,566 510,566 200,000 - - - - -710,566 Temporary Fire Station 7 NO 2 High 40911 GCC 900,000 - - - - - - - 900,000 40912 PFF 1,122,000 - - - - - - - 1,122,000 Terramar Area Coastal Improvements NO 2 High 60541 TIF 6,650,001 - - 2,800,000 - - - - 9,450,001 60542 GCC 999,999 - - - - - - - 999,999 60543 TRANSNET -LOC 1,000,000 -1,000,000 - - - - -2,000,000 60544 SEWER REPL - - - - - - - - - 60545 PFF 2,450,000 - - - - - - - 2,450,000 The Crossings Golf Course Lake Liner NO 2 High 40841 GCC 835,500 - - - - - - - 835,500 Replacement 40842 GCC 200,000 - - - - - - - 200,000 Traffic Impact Fee Funds to CFD #1 NO Null Null PA051 TIF -90,000 90,000 90,000 90,000 90,000 450,000 450,000 1,350,000 Traffic Impact Fee Update NO Citywide High 60401 TIF 270,000 30,000 - - - - - - 270,000 I-26 Project Name New Project District Score Funding ID Funding Source Current Appropriation Last Year (2022-23) Appropriated Year 1 (2023-24) Year 2 (2024-25) Year 3 (2025-26) Year 4 (2026-27) Year 6-10 (2029-33) Year 11-15 (2034-38) Total Funding Source Traffic Improvement Program NO Citywide Critical 60701 GAS TAX 2,388,000 - - - - - - - 2,388,000 60702 GCC 400,000 400,000 600,000 400,000 - - - - 1,400,000 Traffic Monitoring Program NO Citywide High 60031 TIF 1,745,415 122,516 - - - - - - 1,745,415 60032 GAS TAX - - 200,000 170,000 - - - - 370,000 Traffic Signal - Maverick Way and Camino De Los Coches NO 4 Critical 63322 GAS TAX 380,000 240,000 110,000 - - - - -490,000 Traffic Signal - Tamarack Avenue and Valley Street NO 1 Medium 63351 GAS TAX 502,370 - - - - - - - 502,370 Traffic Signal Cabinet Upgrades YES Citywide Low 24141 GCC - - 180,000 - - - - -180,000 Traffic Signal Right Turn Overlaps NO 2,3,4 Low 66361 GAS TAX 150,000 150,000 - - - - - - 150,000 Trail Connectivity to Tamarack State NO 1 Low 40631 Beach (Prop C) GCC 152,156 - - - 3,544,000 - - - 3,696,156 Trash Amendment Compliance Program NO Citywide Medium 66261 IRF 630,000 100,000 -1,200,000 2,700,000 175,000 3,000,000 3,300,000 13,005,000 Tri-Agency Water Transmission NO 2 High 50081 Pipeline Replacement WATER REPL 3,618,970 --1,290,000 431,000 3,585,000 4,630,000 - - 10,974,970 Trieste Slope Repair Project NO 2 High 61071 GCC 362,600 362,600 2,000,000 - - - - -2,362,600 Tyler Street Traffic Circulation NO 1 Medium 61031 GCC 70,000 70,000 900,000 - - - - -970,000 Utility Undergrounding Program Study NO Citywide Medium 60831 GCC - - - 100,000 - - - - 100,000 Vallecitos Interceptor Sewer Cleaning NO 2,3 High 55491 and CCTV SEWER REPL 350,000 100,000 - - - - - - 350,000 Valley and Magnolia Complete Streets NO 1 High 60191 TIF 3,536,206 - - - - - - - 3,536,206 60192 WATER REPL 71,000 - - 650,000 - - - - 721,000 60193 TRANSNET -LOC 1,200,000 1,200,000 - - - - - - 1,200,000 60194 PFF - - - - 1,000,000 - - - 1,000,000 Valley Street Traffic Calming NO 1 Medium 19741 TRANSNET -LOC - - - - 1,645,000 - - - 1,645,000 Veteran's Memorial Park (All NO Citywide Critical 46091 CFD#1 4,369,450 1,257,250 37,342,000 - - - - -41,711,450 Quadrants) 46092 FED GRANT - - 3,000,000 - - - - -3,000,000 46093 STATE GRANT - - 5,000,000 - - - - -5,000,000 Village and Barrio Traffic Circles NO 1 Critical 40151 GCC 415,000 - - - - - - - 415,000 40152 TRANSNET -LOC 1,025,000 - - - - - - - 1,025,000 40153 SEWER REPL 160,000 -500,000 - - - - -660,000 40154 GAS TAX 4,159,000 1,400,000 - - - - - - 4,159,000 40155 FED GRANT - - 4,000,000 - - - - -4,000,000 Village H South Off Leash Dog Area and Trail Segment 5B NO 2 Medium 46101 PFF 682,500 160,500 - - - - - - 2,082,500 Village Intelligent Parking Implementation NO 1 Low 60891 GCC - - - - 300,000 - - - 300,000 Village Lighting - Carlsbad Village Drive NO 1 High 61051 from Harding Street to Ocean Street GCC 400,000 400,000 200,000 - - - - -600,000 I-27 Project Name New Project District Score Funding ID Funding Source Current Appropriation Last Year (2022-23) Appropriated Year 1 (2023-24) Year 2 (2024-25) Year 3 (2025-26) Year 4 (2026-27) Year 6-10 (2029-33) Year 11-15 (2034-38) Total Funding Source Village Lighting - Gateway Lighting NO 1 High 61081 GCC - - - - - - - - 950,000 Village Lighting - Hospitality District NO 1 High 24101 GCC - - - - -700,000 - - 700,000 Village Lighting - Pedestrian Lampposts Oak Avenue NO 1 High 61091 GCC - - - - 600,000 - - - 600,000 Village Lighting - Pedestrian Lighting at Village Outskirts NO 1 High 61101 GCC - - - - - - - - 950,000 Village Lighting - State Street, Madison, Roosevelt, and Washington NO 1 High 40161 GCC 1,103,853 400,000 - - - - - - 1,103,853 Village Lighting - Train Station Area NO 1 High 61061 GCC 500,000 500,000 -150,000 - - - - 650,000 Villas Sewer Lift Station Replacement NO 2 Critical 55501 SEWER REPL 1,254,000 100,000 75,000 - - - - -1,329,000 Vista Carlsbad Interceptor - Agua Hedionda LS and Forcemain NO 2 Critical 34921 SEWER CONN 33,190,973 -220,000 - - - - -33,410,973 (VC12-VC13) 34922 SEWER REPL - - - 104,000 75,000 75,000 - - 329,000 Vista Carlsbad Interceptor - Buena Vista Lift Station Improvements NO 1 High 55351 SEWER CONN 296,000 -100,000 - - 67,000 67,000 - - 430,000 55352 SEWER REPL - - 86,000 31,000 598,000 598,000 150,000 150,000 1,635,000 Vista Carlsbad Interceptor - Lagoon Bridge Replacement (VC11B) NO Citywide Critical 38861 SEWER CONN 9,464,833 - - - - - - - 9,464,833 Vista Carlsbad Interceptor - Reach VC3 NO 1 High 39501 SEWER CONN 100,000 -497,000 30,000 387,000 405,000 - - - 922,000 39502 SEWER REPL - - - - - - - - - Vista Carlsbad Interceptor - Reach VC14 To VC15 NO Citywide High 39491 SEWER CONN 21,362,390 - - - - - - - 21,362,390 Vista Carlsbad Interceptor - NO 2 Critical 55511 Rehabilitation (VC1 and VC2) SEWER REPL 141,000 -90,000 70,000 120,000 - - - 421,000 Vista/Carlsbad Interceptor - Point Repair Reaches (VC13 & VC14) NO 2,3 High 55551 SEWER REPL 200,000 200,000 -1,200,000 - - - - 1,400,000 Water Infrastructure Condition NO Citywide Critical 50511 Assessment Program WATER REPL 2,190,000 410,000 410,000 420,000 420,000 450,000 2,250,000 2,480,000 9,070,000 Water Loss Monitoring Program NO Citywide Low 50521 WATER REPL 350,000 --182,911 - - - - -167,089 Water Modeling NO Citywide Critical 50581 WATER CONN 375,000 25,000 - - - - - - 375,000 Water System Rehabilitation and Replacement NO Citywide Critical 39041 WATER REPL 12,258,366 2,690,000 2,800,000 3,000,000 3,000,000 3,000,000 19,890,000 21,080,000 68,028,366 Water Valve Repair/Replacement NO Citywide Critical 50191 Program WATER REPL 7,860,000 940,000 960,000 960,000 960,000 1,000,000 5,110,000 5,650,000 23,500,000 B-21 Adopted Adopted Adopted Preliminary Budget Budget Budget Budget Department 2020-21 2021-22 2022-23 2023-24 City Attorney 8.00 8.00 8.00 8.00 City Clerk Services 7.00 7.00 7.00 7.00 City Council 2.00 2.00 2.00 2.00 City Manager 7.00 7.00 7.00 7.00 City Treasurer 1.00 1.00 1.00 1.00 Communication & Engagement 7.00 7.00 9.00 9.00 Administrative Services - Administration 0.00 3.00 3.00 3.00 Finance 31.00 28.00 26.00 26.00 Human Resources 17.00 17.00 18.00 18.00 Information Technology 37.00 37.00 43.00 43.00 Innovation & Economic Development 4.00 4.00 9.00 9.00 Miscellaneous Non-departmental 0.00 0.00 0.00 0.10 Community Services - Administration 3.00 3.00 3.00 2.00 Community Development 61.75 53.00 52.00 52.00 Housing & Homeless Services 0.00 14.00 16.00 16.00 Library & Cultural Arts 52.50 52.50 51.00 53.00 Parks & Recreation 55.00 55.00 59.00 59.00 Fire 97.75 111.00 123.00 123.90 Police 184.00 186.00 187.00 187.00 Public Works 172.75 177.75 182.75 181.75 Total Full-Time Personnel 747.75 773.25 806.75 807.75 Hourly Full-Time Equivalent Personnel 186.59 193.81 180.90 167.84 Total 934.34 967.06 987.65 975.59 PERSONNEL ALLOCATIONS Attachment C H-28 FIVE-YEAR SCHEDULE OF PROJECTS BY FUND Connected Estimated Estimated Estimated Estimated Estimated Estimated Carlsbad Prior Year 2 Year 3 Year 4 Year 5 Year 5 Total Project Name Goal Appropriation 2023-24 2024-25 2025-26 2026-27 2027-28 Funding Technology Investment Capital Fund Audio Visual Upgrades FVCEC 725,000$ 100,000$ 100,000$ 100,000$ 100,000$ 100,000$ 1,225,000$ Business Process Automation BCDDM 150,000 150,000 - - - - 300,000 Civic Engagement with Open Data EAT 198,000 - 50,000 - - - 248,000 Command Central A/V Infrastucture PSSC - - 200,000 - - - 200,000 Computer Aided Dispatch (CAD)PSSC 1,580,000 - - - - - 1,580,000 Consolidation & Replacement of Core Systems PCDT 900,000 1,500,000 2,000,000 - - - 4,400,000 Cyber Security Program Development PSSC 450,000 100,000 100,000 100,000 100,000 100,000 950,000 Data Governance and Operational Analytics BCDDM 405,000 - 50,000 50,000 - - 505,000 Digital Information Network PCDT 5,025,584 500,000 500,000 - - - 6,025,584 Discovery Management Assessment BCDDM 30,000 - 140,000 - - - 170,000 Electronic Patient Care Reporting PSSC 50,000 (50,000) - - - - - Enterprise Asset Management System PCDT 1,600,000 - - - - - 1,600,000 Enterprise Digital Asset Management EAT 400,000 - - - - - 400,000 Facility Monitoring and Analytics BCDDM - 100,000 50,000 50,000 50,000 - 250,000 Facility Security Master Plan PSSC 200,000 - 721,000 311,000 438,000 222,000 1,892,000 Fleet Telematics PCDT 45,916 130,000 - - - - 175,916 Live 911 PSSC 66,380 - - - - - 66,380 Online Permitting/Electronic Reviews (E-Reviews)EAT 645,000 - - - - - 645,000 Outdoor Wireless Study FVCEC 100,000 - - - - - 100,000 Patron Print/Copy Management EAT 18,000 70,000 - - - - 88,000 Payment Works PSSC - 68,600 - - - - 68,600 Permit Process Automation BCDDM - -200,000 200,000 - - 400,000 Police Records Management Migration PSSC - -200,000 - - - 200,000 Police Body Camera Replacement PSSC - -500,000 - - - 500,000 Police In-car Video Replacement PSSC - -- - - 550,000 550,000 Professional Technical Services for Data Project Delivery BCDDM 70,000 70,000 70,000 70,000 70,000 70,000 420,000 Project Portfolio Management Tool & Consulting PCDT 500,000 - - - - - 500,000 Record Digitization EAT - 100,000 100,000 - - - 200,000 RFID Replacement PCDT - -600,000 - - - 600,000 Staff Managed Print PCDT - 700,000 - - - 800,000 1,500,000 Virtual Permitting Counter (OpenCounter)EAT 61,000 - 23,000 - - - 84,000 Expansion of Yardi EAT - 30,000 - - - - 30,000 Major Incident/Special Event Management System PSSC - -20,000 - - - 20,000 Next Generation Online Catalog EAT 40,000 (40,000) - - - - - Past Perfect Upgrade/Migration PCDT - 5,000 - - - - 5,000 Police Mobile Device IOS Transition PSSC - -5,000 - - - 5,000 Remote Hold Pickup Locker EAT - -40,000 - - - 40,000 Tightrope PCDT - -35,000 - - - 35,000 Technology Investment Capital Fund Total 13,259,880 3,533,600 5,704,000 881,000 758,000 1,842,000 25,978,480 Information Technology Replacement Fund Annual Hardware and Infrastructure Replacement PSSC 790,000 978,142 1,485,000 1,100,000 1,050,000 1,500,000 6,903,142 Exploration Hub Upgrade PCDT - 43,600 - - - - 43,600 Information Technology Replacement Fund Total 790,000 1,021,742 1,485,000 1,100,000 1,050,000 1,500,000 6,946,742 Utilities Enterprise Funds (Operating or Capital) Meter Data Management/Utility Analytics BCDDM - - 550,000 - - - 550,000 Regulatory Water Usage Analytics (Operating Funds)BCDDM 50,000 15,353 - - - - 65,353 Utility Billing Automation PCDT - - 75,000 - - - 75,000 Utility Billing Portal PCDT 90,000 - - - - - 90,000 Total Utilities Enterprise Funds (Operating or Capital)140,000 15,353 625,000 - - - 780,353 14,189,880$ 4,570,695$ 7,814,000$ 1,981,000$ 1,808,000$ 3,342,000$ 33,705,575$ Connected Carlsbad Goal Abbreviations Build Capacity for Data-driven Decision Making = BCDDM Enhance Accessibility and Transparency = EAT Foster a Vibrant Civic Engagement Culture = FVCEC Promote Security and Sustainability through Connectivity = PSSC Pursue Communitywide Digital Transformation = PCDT Funding Source ProjectsTotal Attachment D Exhibit E PLANNED MAJOR CAPITAL OUTLAY ITEMS FISCAL YEAR 2023-24 Department Item Description Quantity One-Time Cost Golf Course Driving Range Entertainment Project Planning 1 60,000 Kitchen & Banquet Equipment Package 1 50,000 Rough Mower 1 80,000 Utility Carts 4 40,000Bunker Renovation Phase 5 of 5 1 60,000 Canyons Patio Furniture Replacement 1 77,000 Cart Path Repairs (6-8 panels)1 60,000 Clubhouse and Surrounding Area Landscaping 1 60,000Fencing Replacement 1 60,000 Range Improvements/Supplies 1 60,000 Replace Artificial Turf on Driving Range Tee 1 60,000 Concrete Slab and Covers for #6 & #14 F&B Stations 1 39,960Replacement Swinging Kitchen Door in Fireside Room 1 15,000Starter Structure 1 60,000 Add Bunker on Hole #18 1 60,000 Waterfall Plant Material Improvements 1 30,000 Driving Range Netting 1 40,540Monument Sign 1 25,000 Carpeting for Offices and Golf Shop 1 42,500 AirWall System for Fireside Room 1 30,000 Golf Course Subtotal 23 $1,010,000 Fleet Replacement Fleet & Facilities: Pickup Truck 1 80,000 Fire: Pickup Truck 1 52,020 Parks & Recreation: Pickup Truck 1 48,725 Parks & Recreation: Tractor 1 55,784Parks & Recreation: Trailers 4 60,345 Police: Utility Vehicles 6 466,270 Police: Motorcycle 1 46,420 Police: Sedan 2 104,000Public Works: Compactor 1 80,000 Public Works: Loader 1 75,000 Fleet Replacement Subtotal 19 $1,068,564 Information Technology Replacement Servers 5 84,966Switches19 324,642 Information Technology Subtotal 24 $409,608 Grand Total Major Capital Outlay 66 $2,488,172 *Major Capital Outlay only includes items of $10,000 or greater. (Greater than $10,000)