Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Resolution No. 22-26
CITY OF TIGARD, OREGON TIGARD CITY COUNCIL RESOLUTION NO. 22- A RESOLUTION TO ADOPT THE FY 2023 FIRST QUARTER BUDGET SUPPLEMENTAL INCLUDING BUDGET ADJUSTMENTS TO THE CAPITAL IMPROVEMENT PLAN,COMMUNITY DEVELOPMENT, PUBLIC WORKS, POLICY AND ADMINISTRATION, AND COMMUNITY SERVICES. WHEREAS,the city acknowledges those items that were unknown at the time the FY 2023 budget was adopted; and WHEREAS,the city recognizes approximately$11,123,689 of unanticipated budget in operations and transfers; and WHEREAS, the increase in budget is offset by unanticipated fund balance, miscellaneous revenue, reserve for future expenditures,and contingency. NOW,THEREFORE,BE IT RESOLVED by the Tigard City Council that: SECTION 1: The FY 2022-23 Budget is hereby amended as detailed in Exhibit B. SECTION: This resolution is effective immediately upon passage. PASSED: This oZ 7 141 day of �e/2.1e•vitZ e y' 2022. Mayo - ' of Tigard ATTEST: 2%?-1e9/..54.�2 �� — City Recorder-City of Tigard RESOLUTION NO.22-,?‘ Page 1 Exhibit B Total All Funds FY 2023 Q1 Revised Q1 Total All Funds Adopted Amendment Budget Resources Beginning Fund Balance $ 205,317,371 $ 5,927,827 $ 211,245,198 Property Taxes $ 24,186,229 $ - S 24,186,229 Franchise Fees $ 7,367,594 $ - $ 7,367,594 Special Assessments $ - $ - $ - Licenses&Permits $ 18,847,467 $ - $ 18,847,467 Intergovernmental $ 21,198,231 $ 642,004 $ 21,840,235 Charges for Services $ 63,440,017 $ - $ 63,440,017 Fines&Forfeitures $ 2,138,329 $ - $ 2,138,329 Interest Earnings $ 1,881,000 $ - $ 1,881,000 Miscellaneous $ 457,678 $ - $ 457,678 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 82,095,105 $ 4,553,858 $ 86,648,963 Total Resources $ 426,929,021 $ 11,123,689 $ 438,052,710 Requirements Community Development $ 7,896,302 $ 195,000 $ 8,091,302 Community Services $ 33,533,415 $ 444,469 $ 33,977,884 Policy and Administration $ 23,606,825 $ 1,850,500 $ 25,457,325 Public Works $ 35,393,452 $ 527,000 $ 35,920,452 Program Expenditures Total $ 100,429,994 $ 3,016,969 $ 103,446,963 Debt Service $ 9,754,690 $ - $ 9,754,690 Loan to CCDA $ 900,000 $ - $ 900,000 Work-In-Progress $ 72,979,000 $ 5,089,862 $ 78,068,862 Transfers to Other Funds $ 83,913,105 $ 4,553,858 $ 88,466,963 Contingency $ 3,800,000 $ (1,189,000) $ 2,611,000 Total Budget $ 271,776,789 $ 11,471,689 $ 283,248,478 Reserve For Future Expenditure $ 155,152,232 $ (348,000) $ 154,804,232 Total Requirements $ 426,929,021 $ 11,123,689 $ 438,052,710 Exhibit B General Fund FY 2023 Revised Q1 General Fund Budget Q1PW04 Q1PD01 Q1PD03 Q1FINO2 Q1FINO3 Q1LIB01 Budget Resources Beginning Fund Balance $ 33,548,840 $ 70,000 $ 32,873 $ 42,596 $ - $ 690,000 $ - $ 34,384,309 Property Taxes $ 19,180,658 S - $ - $ - $ - $ - $ - $ 19,180,658 Franchise Fees $ 7,367,594 $ - $ - $ - $ - $ - $ - $ 7,367,594 Special Assessments $ - $ - $ - $ - $ - $ - $ - $ - Licenses&Permits $ 1,121,598 $ - $ - $ - $ - $ - $ - $ 1,121,598 Intergovernmental $ 7,215,734 $ - $ - $ - $ - $ - $ 4,000 $ 7,219,734 Charges for Services $ 234,742 $ - $ - $ - $ - $ - $ - $ 234,742 Fines&Forfeitures $ 2,037,040 $ - $ - $ - $ - $ - $ - $ 2,037,040 Interest Earnings $ 300,675 $ - $ - $ - $ - S - $ - $ 300,675 Miscellaneous $ 203,166 $ - $ - $ $ $ - $ - $ 203,166 Other Financing Sources $ - $ $ $ $ c - $ - 5 - Transfers In from Other Funds $ 189,000 $ $ - $ $ $ - $ - S 189,000 Total Resources $ 48,392,206 $ 70,000 $ 32,873 $ 42,596 $ - $ 690,000 $ 4,000 $ 49,231,675 Requirements Community Development $ 4,681,956 $ - $ - $ - 5 113,000 $ - $ 5 4,794,956 Community Services $ 30,726,267 $ $ 32,873 $ 42,596 $ 365,000 $ - S 4,000 $ 31,170,736 Policy and Administration $ 1,661,638 $ - $ - $ - $ 43,000 $ - S - $ 1,704,638 Public Works S 74,000 5 - $ - $ - $ - $ - $ - S 74,000 Program Expenditures Total $ 37,143,861 $ - $ 32,873 $ 42,596 $ 521,000 $ - $ 4,000 $ 37,744,330 Debt Service $ - S 5 - $ - $ - $ - $ - $ - Loan to ICDA $ - $ - $ - $ - $ - $ - S - $ - Work-In-Progress $ - $ S $ - $ - $ S - $ - Transfers to Other Funds $ 10,785,099 $ 70,000 $ - $ - $ - $ 690,00 5 11,545,099 Contingency $ 1,400,000 $ S $ - $ (521,000) $ - $ - S. 879,000 Total Budget $ 49,328,960 $ 70,000 $ 32,873 $ 42,596 $ - $ 690,000 $ 4,000 $ 50,168,429 Reserve For Future Expenditure $ 22,070,087 $ - $ - $ - $ - $ - $ - $ 22,070,087 Total Requirements $ 71,399,047 $ 70,000 $ 32,873 $ 42,596 $ - $ 690,000 $ 4,000 $ 72,238,516 Exhibit B Public Works Engineering Fund FY 2023 Revised Q1 Public Works Engineering Fund Budget Q1PW01 Q1PW02 Q1FIN02 Budget Resources Beginning Fund Balance $ 2,910,789 $ 54,000 $ 25,000 $ - $ 2,989,789 Property Taxes $ - $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - $ - Special Assessments $ - $ - $ - $ - $ - Licenses&Permits $ 1,000,000 $ - $ - $ - $ 1,000,000 Intergovernmental $ - $ - $ - $ - $ - Charges for Services $ 2,681,089 $ - $ - $ - $ 2,681,089 Fines&Forfeitures $ - $ - $ - $ - $ - Interest Earnings $ - $ - $ - $ - $ - Miscellaneous $ 5,094 $ - $ - $ - $ 5,094 Other Financing Sources $ - $ - $ - $ - $ - Transfers In from Other Funds $ 643,653 $ - S - $ - $ 643,653 Total Resources $ 7,240,625 $ 54,000 $ 25,000 $ - $ 7,319,625 Requirements Community Development S - $ - $ - $ - $ Community Services S - $ - $ - $ - $ - Policy and Administration $ - $ - $ - $ - $ - Public Works S 4,568,292 $ 54,000 $ 25,000 S 124,000 S 4,771,292 Program Expenditures Total $ 4,568,292 $ 54,000 $ 25,000 $ 124,000 $ 4,771,292 Debt Service $ - $ - $ - $ - S - Loan to CCDA $ - $ - $ - $ - S - Work-In-Progress $ - $ - $ - $ - $ - Transfers to Other Funds $ - $ - $ - $ - $ - Contingency $ 150,000 $ - $ - $ - S 150,000 Total Budget $ 4,718,292 $ 54,000 $ 25,000 $ 124,000 $ 4,921,292 Reserve For Future Expenditure $ 2,522,333 $ - $ - $ (124,000) $ 2,398,333 Total Requirements $ 7,240,625 $ 54,000 $ 25,000 $ - $ 7,319,625 Exhibit B Public Works Admin Fund FY 2023 Revised Q1 Public Works Admin Fund Budget Q1FIN02 Budget Resources Beginning Fund Balance $ 531,344 $ - $ 531,344 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ 3,003,163 $ - $ 3,003,163 Fines&Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 58,306 $ - $ 58,306 Total Resources $ 3,592,813 $ - $ 3,592,813 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 3,164,721 $ 62,000 $ 3,226,721 Program Expenditures Total $ 3,164,721 $ 62,000 $ 3,226,721 Debt Service $ - $ - $ - Loan to CCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ - $ - $ - Contingency $ 125,000 $ (62,000) $ 63,000 Total Budget $ 3,289,721 $ - $ 3,289,721 Reserve For Future Expenditure $ 303,092 $ - $ 303,092 Total Requirements $ 3,592,813 $ - $ 3,592,813 Exhibit B Street Maintenance Fund FY 2023 Revised Q1 Street Maintenance Fund Budget Q1PW13 Budget Resources Beginning Fund Balance $ 3,005,922 $ 680,000 $ 3,685,922 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ 3,363,343 $ - $ 3,363,343 Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines&Forfeitures $ - $ - $ - Interest Earnings $ 22,575 $ - $ 22,575 Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds S - S - $ - Total Resources $ 6,391,840 $ 680,000 $ 7,071,840 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to CCDA $ - $ - $ - Work-In-Progress $ 3,440,000 $ 680,000 $ 4,120,000 Transfers to Other Funds $ 331,003 $ - $ 331,003 Contingency $ - $ - $ - Total Budget $ 3,771,003 $ 680,000 $ 4,451,003 Reserve For Future Expenditure $ 2,620,837 $ - $ 2,620,837 Total Requirements $ 6,391,840 $ 680,000 $ 7,071,840 Exhibit B City Gas Tax Fund FY 2023 Revised Q1 City Gas Tax Fund Budget Q1PW20 Budget Resources Beginning Fund Balance $ 2,148,268 $ 865,000 $ 3,013,268 Property Taxes $ - $ - $ Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ - $ - $ - Intergovernmental $ 925,343 $ - $ 925,343 Charges for Services $ - $ - $ - Fines&Forfeitures $ - $ - $ - Interest Earnings $ 29,025 $ - $ 29,025 Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ Transfers In from Other Funds $ - S - S - Total Resources $ 3,102,636 $ 865,000 $ 3,967,636 Requirements Community Development $ - $ - S - Community Services $ - $ - S - Policy and Administration $ - $ - S - Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to CCDA $ - $ - $ - Work-In-Progress S - $ - $ - Transfers to Other Funds S 2,312,159 $ 865,000 $ 3,177,159 Contingency $ - $ - $ - Total Budget $ 2,312,159 $ 865,000 $ 3,177,159 Reserve For Future Expenditure $ 790,477 $ - $ 790,477 Total Requirements $ 3,102,636 $ 865,000 $ 3,967,636 Exhibit B Gas Tax Fund FY 2023 Revised Q1 Gas Tax Fund Budget Q1PW14 QIPW15 Q1FIN02 Budget Resources Beginning Fund Balance $ 6,976,462 $ 65,858 $ 35,000 $ - $ 7,077,320 Property Taxes $ - $ - $ - S - $ - Franchise Fees $ - $ - $ - S - $ - Special Assessments $ - $ - $ - $ - $ - Licenses&Permits $ 7,029 $ - $ - $ - $ 7,029 Intergovernmental $ 5,128,620 $ - $ - $ - $ 5,128,620 Charges for Services $ - $ - $ - S - $ - Fines&Forfeitures $ - $ - $ - $ - $ - Interest Earnings $ 61,800 $ - $ - S - $ 61,800 Miscellaneous $ 62,818 $ - $ - S - $ 62,818 Other Financing Sources $ - $ - $ - S - $ - Transfers In from Other Funds $ 208,500 $ - S - $ - $ 208,500 Total Resources $ 12,445,229 $ 65,858 $ 35,000 $ - $ 12,546,087 Requirements Community Development $ - $ $ - S - $ - Community Services $ - $ - $ - $ - $ - Policy and Administration $ - $ - $ - $ - $ - Public Works $ 3,754,762 $ - $ - $ 33,000 $ 3,787,762 Program Expenditures Total $ 3,754,762 $ - $ - $ 33,000 $ 3,787,762 Debt Service $ - $ - $ - $ - $ Loan to CCDA $ - $ - $ - $ - $ - Work-In-Progress $ - $ - $ - $ - $ - Transfers to Other Funds $ 3,771,764 $ 65,858 $ 35,000 $ - $ 3,872,622 Contingency $ 200,000 $ - $ - $ (33,000) $ 167,000 Total Budget $ 7,726,526 $ 65,858 $ 35,000 $ - $ 7,827,384 Reserve For Future Expenditure $ 4,718,703 $ - $ - $ - $ 4,718,703 Total Requirements $ 12,445,229 $ 65,858 $ 35,000 $ - $ 12,546,087 Exhibit B Building Fund FY 2023 Revised Q1 Building Fund Budget Q1FIN02 Budget Resources Beginning Fund Balance $ 11,212,606 $ - $ 11,212,606 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ 3,533,704 $ - $ 3,533,704 Intergovernmental $ 8,281 $ - $ 8,281 Charges for Services $ 7,000 $ - $ 7,000 Fines&Forfeitures $ - $ - $ - Interest Earnings $ 112,875 $ - $ 112,875 Miscellaneous $ 500 $ - $ 500 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 250,000 $ - $ 250,000 Total Resources $ 15,124,966 $ - $ 15,124,966 Requirements Community Development $ 2,814,346 $ 82,000 $ 2,896,346 Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ 2,814,346 $ 82,000 $ 2,896,346 Debt Service $ - $ - $ - Loan to CCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 293,125 $ - $ 293,125 Contingency $ 150,000 $ - $ 150,000 Total Budget $ 3,257,471 $ 82,000 $ 3,339,471 Reserve For Future Expenditure $ 11,867,495 $ (82,000) $ 11,785,495 Total Requirements $ 15,124,966 $ - $ 15,124,966 Exhibit B Parks Utility Fund FY 2023 Revised Q1 Parks Utility Fund Budget Q1FIN02 Budget Resources Beginning Fund Balance $ 2,966,144 $ - $ 2,966,144 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ 2,406,398 $ - $ 2,406,398 Intergovernmental $ - $ - $ - Charges for Services $ 90,750 $ - $ 90,750 Fines&Forfeitures $ - $ - $ - Interest Earnings $ 2,475 $ - $ 2,475 Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 2,250,000 $ - $ 2,250,000 Total Resources $ 7,715,767 $ - $ 7,715,767 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 4,957,532 $ 92,000 $ 5,049,532 Program Expenditures Total $ 4,957,532 $ 92,000 $ 5,049,532 Debt Service $ - $ - $ - Loan to CCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 968,724 $ - $ 968,724 Contingency $ 125,000 $ - $ 125,000 Total Budget $ 6,051,256 $ 92,000 $ 6,143,256 Reserve For Future Expenditure $ 1,664,511 $ (92,000) $ 1,572,511 Total Requirements $ 7,715,767 $ - $ 7,715,767 Exhibit B Facilities Capital Projects Fund FY 2023 Revised Q1 Facilities Capital Projects Fund Budget Q1PW03 Q1PW04 Budget Resources Beginning Fund Balance $ 939,000 $ - $ - $ 939,000 Property Taxes $ - $ - $ - S - Franchise Fees $ - $ - $ - $ Special Assessments $ - $ - $ - $ - Licenses&Permits $ - $ - $ - $ - Intergovernmental $ - $ - $ - $ - Charges for Services $ - $ - $ - $ - Fines&Forfeitures $ - $ - $ - $ - Interest Earnings $ 14,175 $ - $ - $ 14,175 Miscellaneous $ - $ - $ - $ - Other Financing Sources $ - S - $ - $ Transfers In from Other Funds $ 2,200,000 S 462,500 $ 70,000 S 2,732,500 Total Resources $ 3,153,175 $ 462,500 $ 70,000 $ 3,685,675 Requirements Community Development $ - $ - $ - $ - Community Services $ - $ - $ - $ - Policy and Administration $ - $ - $ - $ - Public Works $ - $ - S - $ Program Expenditures Total $ - $ - $ - $ - Debt Service $ - $ - $ - $ - Loan to CCDA $ - $ - $ - $ - Work-In-Progress $ 2,100,000 $ 462,500 $ 70,000 $ 2,632,500 Transfers to Other Funds $ 26 $ - $ - $ 26 Contingency $ - $ - $ - $ - Total Budget $ 2,100,026 $ 462,500 $ 70,000 $ 2,632,526 Reserve For Future Expenditure $ 1,053,149 $ - $ - $ 1,053,149 Total Requirements $ 3,153,175 $ 462,500 $ 70,000 $ 3,685,675 Exhibit B Parks Capital Fund FY 2023 Revised QI Parks Capital Fund Budget Q1PW05 QIPW06 QIPW07 QIPW08 QIPW09 QIPW10 QIPWII Q1PW12 QIPW21 Budget Resources Beginning Fund Balance $ 266,728 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 266,728 Property Taxes 8 - 8 - S - Si - $ - $ - $ - S - $ - $ - $ - Franchise Fees $ - 8 - 5 - S - $ - 5 - $ - $ - $ - $ - 8 - Special Assessments 8 - $ - $ - $ - $ - $ - 8 - $ - S - S - $ - Licenses&Permits S - $ - $ - $ - $ - $ - 8 - 5 - S - S - S - Intergovernmental S 4,696,695 $ - 5 - $ - $ - $ - $ - $ 46,711 $ - S - S 4,743,406 Charges for Services $ - $ - 8 - $ - $ - 8 - $ - $ - $ - $ - $ - Fines&Forfeitures $ - $ - S - $ - S - $ - $ - S - $ - 5 - 8 _ Interest Earnings $ - S - S - S - S - $ - 5 - 8 - 5 - 5 - $ - Miscellaneous $ - S - S - S - 8 - $ - $ - 8 - $ - S - $ - Other Financing Sources $ - $ - $ - $ - $ - 8 - S - $ - $ - 5 - $ _ Transfers In from Other Funds $ 9,136,000 $ 70,000 $ 40,000 $ 176,000 $ 142,000 $ 91,000 5 147,000 S 5 719,(100 $ 50,000 $ 11s71,000 Total Resources $ 14,099,423 $ 70,000 $ 40,000 $ 176,000 $ 142,000 $ 91,000 $ 147,000 $ 46,711 $ 719,000 $ 50,000 $ 15,581,134 Requirements Community Development 8 - 5 - S - S - $ - 5 - $ - $ - 8 - $ - S _ Community Services 8 - S - S - S - $ - $ - S - 8 - $ - $ - 8 - Policy and Administration $ - S - 8 - $ - 8 - $ - $ - $ - 5 - $ - S - PublicWorks 8 - $ - $ - $ - $ - $ - 8 - $ - $ - 8 - 5 _ Program Expenditures Total $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Debt Service $ - $ - 8 - 8 - $ - 8 - $ - $ - $ - 5 - $ - Loan to CCDA $ - $ - S - S - $ - $ - $ - $ - $ - $ - 8 - Work-In-Progress $ 13,817,500 $ 70,000 $ 40,000 $ 176,000 $ 142,000 $ 91,000 5 147,000 $ 46,711 $ 719,000 $ 50,000 8 15,299,211 Transfers to Other Funds $ - $ - 8 - 8 - $ - $ - Si - 8 - 5 - $ - $ - Contingency $ - $ - $ - $ - 5 - $ - 8 - $ - $ - $ - $ - Total Budget $ 13,817,500 $ 70,000 $ 40,000 $ 176,000 5 142,000 $ 91,000 $ 147,000 $ 46,711 $ 719,000 $ 50,000 $ 15,299,211 Reserve For Future Expenditure $ 281,923 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 281,923 Total Requirements $ 14,099,423 $ 70,000 $ 40,000 $ 176,000 $ 142,000 $ 91,000 $ 147,000 $ 46,711 $ 719,000 $ 50,000 $ 15,581,134 Exhibit B Parks SDC Fund FY 2023 Revised QI Parks SDC Fund Budget Q1PW05 Q1PW06 QIPW07 Q1PW08 QIPW09 Q1PW10 QIPW12 Q1PW21 Budget Resources Beginning Fund Balance $ 10,005,789 $ 70,000 $ 40,000 $ 176,000 $ 142,000 $ 91,000 $ 147,000 $ 719,000 $ - $ 11,390,789 Property Taxes 5 - S - S - S - 5 - S - S - S - $ - S - Franchise Fees 5 - 5 - 5 - S - 5 - S - S - S - S - S - Special Assessments $ - $ - S - S - S - S - S - S - S - $ - Licenses&Permits 5 1,495,466 5 - 5 - S - S - S - S - S $ - $ 1,495,466 Intergovernmental $ - $ - $ - $ - 5 - 5 - $ - $ - $ - $ - Charges for Services $ - 5 - 5 - 3 - 5 - S - S - S - $ - S - Fines&Forfeitures $ - $ - 5 - 5 - 3 - 5 - S - S - S - S - Interest Earnings $ 158,325 S - S - S - S - S - S - S - S - 5 158,325 Miscellaneous $ - S - S - S - S - S - S - S - 5 - 5 - Other Financing Sources $ - S - S - S - 5 - 5 - 5 - S - $ - $ - Transfers In from Other Fund 5 160,300 5 - 5 - 5 - 5 - 5 5 5 5 5 160,300 Total Resources $ 11,819,880 $ 70,000 $ 40,000 $ 176,000 $ 142,000 $ 91,000 $ 147,000 $ 719,000 $ - $ 13,204,880 Requirements Community Development S - S - 5 - 5 S - 5 S S - S 5 Community Services S - S - 5 - 5 s - S 5 ¢ - S Policy and Administration 5 - S - S - 5 - 5 - 5 - 5 - S - 5 - S - Public Works $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Program Expenditures Total $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Debt Service S - 3 - S - 5 - 5 - 5 - S - S - S - S - Loan to CCDA 5 - $ - 5 - 5 - 5 - 5 - 5 - 5 - 5 - S - Work-In-Progress S - $ - 5 - 5 - 5 - 5 - 5 - $ - $ - S - Transfers to Other Funds $ 8,506,295 $ "0,000 5 40,000 5 176,000 $ 142,000 5 91,000 $ 147,000 5 "19,000 5 50,000 $ 9,941 295 Contingency $ - $ - $ - $ - $ - $ - S - S - 5 - 5 - Total Budget $ 8,506,295 $ 70,000 $ 40,000 $ 176,000 $ 142,000 $ 91,000 $ 147,000 $ 719,000 $ 50,000 $ 9,941,295 Reserve For Future Expenditure $ 3,313,585 $ - $ - $ - $ - $ - $ - $ - $ (50,000) $ 3,263,585 Total Requirements $ 11,819,880 $ 70,000 $ 40,000 $ 176,000 $ 142,000 $ 91,000 $ 147,000 $ 719,000 $ - $ 13,204,880 Exhibit B Transportation CIP Fund FY 2023 Revised Q1 Transportation CIP Fund Budget Q1PW14 Q1PW15 Q1PW20 Budget Resources Beginning Fund Balance $ 2,272,752 $ - $ - $ - $ 2,272,752 Property Taxes $ - $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - $ - Special Assessments $ - $ - $ - $ - $ - Licenses&Permits $ - $ - $ - $ - $ - Intergovernmental $ 2,009,360 $ 256,293 $ - $ 243,000 $ 2,508,653 Charges for Services $ - $ - $ - $ - $ - Fines&Forfeitures $ - $ - $ - $ - $ - Interest Earnings $ - $ - $ - $ - $ - Miscellaneous $ - $ - $ - $ - $ - Other Financing Sources $ - $ - $ - $ - $ - Transfers In from Other Funds $ 15,283,140 $ 65,858 $ 35,000 $ 865,000 $ 16,248,998 Total Resources $ 19,565,252 $ 322,151 $ 35,000 $ 1,108,000 $ 21,030,403 Requirements Community Development $ - $ - $ - $ - $ - Community Services $ - $ - $ - $ - $ - Policy and Administration $ - $ - $ - $ - $ - Public Works $ - $ - $ - $ - $ - Program Expenditures Total $ - $ - $ - $ - $ - Debt Service $ - $ - $ - $ - $ - Loan to CCDA $ - $ - $ - $ - $ - Work-In-Progress $ 17,517,500 $ 322,151 $ 35,000 $ 1,108,000 $ 18,982,651 Transfers to Other Funds $ - $ - $ - $ - $ - Contingency $ - $ - $ - $ - $ - Total Budget $ 17,517,500 $ 322,151 $ 35,000 $ 1,108,000 $ 18,982,651 Reserve For Future Expenditure $ 2,047,752 $ - $ - $ - $ 2,047,752 Total Requirements $ 19,565,252 $ 322,151 $ 35,000 $ 1,108,000 $ 21,030,403 Exhibit B Sanitary Sewer Fund FY 2023 Revised Q1 Sanitary Sewer Fund Budget Q1FIN02 Budget Resources Beginning Fund Balance $ 8,717,503 $ - $ 8,717,503 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ 92,200 $ - $ 92,200 Intergovernmental $ - $ - $ - Charges for Services $ 3,560,731 $ - $ 3,560,731 Fines&Forfeitures $ - $ - $ - Interest Earnings $ 82,725 $ - $ 82,725 Miscellaneous $ 42,100 $ - $ 42,100 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 12,495,259 $ - $ 12,495,259 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 3,225,698 $ 25,000 $ 3,250,698 Program Expenditures Total $ 3,225,698 $ 25,000 $ 3,250,698 Debt Service $ - $ - $ - Loan to CCDA $ 900,000 $ - $ 900,000 Work-In-Progress $ 245,000 $ - $ 245,000 Transfers to Other Funds $ 3,067,150 $ - $ 3,067,150 Contingency $ 200,000 $ (25,000) $ 175,000 Total Budget $ 7,637,848 $ - $ 7,637,848 Reserve For Future Expenditure $ 4,857,411 $ - $ 4,857,411 Total Requirements $ 12,495,259 $ - $ 12,495,259 Exhibit B Stormwater Fund FY 2023 Revised Q1 Stormwater Fund Budget Q1FIN02 Budget Resources Beginning Fund Balance $ 9,506,606 $ - $ 9,506,606 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ 5,869,141 $ - $ 5,869,141 Fines&Forfeitures $ - $ - $ - Interest Earnings $ 104,925 $ - $ 104,925 Miscellaneous $ 5,000 $ - $ 5,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 2,155,500 $ - $ 2,155,500 Total Resources $ 17,641,172 $ - $ 17,641,172 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 4,377,319 $ 48,000 $ 4,425,319 Program Expenditures Total $ 4,377,319 $ 48,000 $ 4,425,319 Debt Service $ - $ - $ - Loan to CCDA $ - $ - $ - Work-In-Progress $ 7,939,000 $ - $ 7,939,000 Transfers to Other Funds $ 1,479,317 $ - $ 1,479,317 Contingency $ 275,000 $ (48,000) $ 227,000 Total Budget $ 14,070,636 $ - $ 14,070,636 Reserve For Future Expenditure $ 3,570,536 $ - $ 3,570,536 Total Requirements $ 17,641,172 $ - $ 17,641,172 Exhibit B Water SDC FY 2023 Revised Q1 Water SDC Fund Budget QIPW16 Q1PW17 Q1PW18 Budget Resources Beginning Fund Balance $ 13,925,586 $ 428,000 $ 168,000 $ 17,500 $ 14,539,086 Property Taxes $ - $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - $ - Special Assessments $ - $ - $ - $ - $ - Licenses&Permits $ 2,054,999 $ - $ - $ - $ 2,054,999 Intergovernmental $ - $ - $ - $ - $ - Charges for Services $ - $ - $ - $ - $ - Fines&Forfeitures $ - $ - $ - $ - $ - Interest Earnings $ 193,650 $ - $ - $ - $ 193,(6-0 Miscellaneous $ - $ - $ - $ - $ - Other Financing Sources $ - $ - $ - $ - $ Transfers In from Other Funds S - $ - $ - $ - S - Total Resources $ 16,174,235 $ 428,000 $ 168,000 $ 17,500 $ 16,787,735 Requirements Community Development S - $ - $ - $ $ - Community Services S - $ - $ - $ - $ - Policy and Administration S - $ - $ - $ - $ Public Works S - $ - $ - $ - $ - Program Expenditures Total $ - $ - $ - $ - $ - Debt Service $ - $ - $ - $ - $ - Loan to TCDA S - $ - S - $ - $ - Work-In-Progress $ - $ - $ - $ - $ - Transfers to Other Funds $ 8,124,345 $ 428,000 $ 168,000 $ 17,500 $ 8,737,845 Contingency S - $ - $ - $ - $ - Total Budget $ 8,124,345 $ 428,000 $ 168,000 $ 17,500 $ 8,737,845 Reserve For Future Expenditure $ 8,049,890 $ - $ - $ - $ 8,049,890 Total Requirements $ 16,174,235 $ 428,000 $ 168,000 $ 17,500 $ 16,787,735 Exhibit B Water CIP FY 2023 Revised Q1 Water CIP Fund Budget QIPW16 Q1PW17 Q1PW18 Q1PW19 Budget Resources Beginning Fund Balance $ 2,542,661 $ - $ - $ - $ - $ 2,542,661 Property Taxes $ - $ - $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - $ - $ - Special Assessments $ - $ - $ - $ - $ - $ - Licenses&Permits $ - $ - $ - $ - $ - $ - Intergovernmental $ - $ - $ - $ - $ - $ - Charges for Services $ - $ - $ - $ - $ - $ - Fines&Forfeitures $ - $ - $ - $ - $ - $ - Interest Earnings $ - $ - $ - $ - $ - $ - Miscellaneous $ - $ - $ - $ - $ - $ - Other Financing Sources $ - $ - $ - $ - $ - $ - Transfers In from Other Funds S 27,920,000 $ 428,000 S 420,000 $ 17,500 S 65,000 $ 28,850,500 Total Resources $ 30,462,661 $ 428,000 $ 420,000 $ 17,500 $ 65,000 $ 31,393,161 Requirements Community Development $ - $ - $ - $ - $ - $ - Community Services $ - $ - $ - $ - $ - $ - Policy and Administration $ - $ - $ - $ - $ - $ - Public Works $ - $ - $ - $ - $ - $ - Program Expenditures Total $ - $ - $ - $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA S - $ - Work-In-Progress S 27,920,000 $ 428,000 $ 420,000 $ 17,500 S 65,000 $ 28,850,500 Transfers to Other Funds S - S - $ - Contingency S - $ - Total Budget $ 27,920,000 $ 428,000 $ 420,000 $ 17,500 $ 65,000 $ 28,850,500 Reserve For Future Expenditure $ 2,542,661 $ - $ - $ - $ - $ 2,542,661 Total Requirements $ 30,462,661 $ 428,000 $ 420,000 $ 17,500 $ 65,000 $ 31,393,161 Exhibit B Central Services Fund FY 2023 Revised Q1 Central Services Fund Budget QIFIN01 QIFINO2 Q1FINO3 Q1CM01 Q1CM02 Q1IT01 QIITO2 Q1IT03 Budget Resources Beginning Fund Balance $ 3,011,061 $ 100,000 $ - $ - $ 30,000 $ 90,000 $ 238,000 $ 28,000 $ - $ 3,497,061 Property Taxes S - S - S - 5 - $ - S - 5 - 5 - 3 - S - Franchise Fees S - S - S - S - S - S - $ - S - S - S - Special Assessments $ - $ - $ - $ - S - $ - $ - $ - $ - S - Licenses&Permits S - $ - 5 - 5 - 5 - 5 - 5 - 5 - $ - 5 - Intergovernmental S - S - S - S - S - S - $ - S - 5 92,000 5 92,000 Charges for Services 5 14,630,084 5 - $ - $ - S - S - S - 5 - $ - 5 14,630,084 Fines&Forfeitures $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Interest Earnings $ - $ - $ - $ - $ - S - S - S - S - $ - Miscellaneous S 30,000 S S - S - S - S - S S - S - 5 30,000 Other Financing Sources S - $ - S - $ - S - 5 S 5 - 5 - $ - Transfers In from Other Funds 5 887,822 $ - 5 - $ 690,000 $ 5 5 5 - 5 5 1,577,822 Total Resources $ 18,558,967 $ 100,000 $ - $ 690,000 $ 30 000 $ 90,000 $ 238,000 $ 28,000 $ 92,000 $ 19,826,967 Requirements Community Development $ - 5 - 5 - $ - 5 - $ - 5 5 - 5 - 5 - Community Services $ - $ - S - 5 - S - $ - S - $ - S - S - Policy and Administration 5 17,006,162 $ 100,000 5 390,000 S (,90,000 S 30,000 5 90 000 S 238,000 5 28,000 S 92,000 5 18,664,162 Public Works 5 - $ - $ - $ - $ - S - $ - $ - S - Program Expenditures Total $ 17,006,162 $ 100,000 $ 390,000 $ 690,000 $ 30,000 $ 90,000 $ 238,000 $ 28,000 $ 92,000 $ 18,664,162 Debt Service S - $ - 5 - 5 - S - 5 - 5 - S - S - S - Loan to CCDA 5 - $ - S - $ - $ - S - $ - $ - $ - S - Work-In-Progress 5 - S - 5 - 5 - 5 - 5 - S - $ - 5 5 - Transfers to Other Funds 5 1,000,000 5 - 5 - 5 - 5 - S - S - S - 5 1,000,000 Contingency 5 300,000 5 - 5 (390,000) 5 - S - 5 - S - 5 - S - 5 110,000 Total Budget $ 18,506,162 $ 100,000 $ - $ 690,000 $ 30,000 $ 90,000 $ 238,000 $ 28,000 $ 92,000 $ 19,774,162 Reserve For Future Expenditure $ 52,805 $ - $ - $ - $ - $ - $ - $ - $ - $ 52,805 Total Requirements $ 18,558,967 $ 100,000 $ - $ 690,000 $ 30,000 $ 90,000 $ 238,000 $ 28,000 $ 92,000 $ 19,826,967 Exhibit B Water Fund FY 2023 Revised Q1 Water Fund Budget Q1PW03 Q1PW17 Q1PW19 Q1FIN02 Budget Resources Beginning Fund Balance $ 50,795,188 $ 462,500 $ 252,000 $ 65,000 $ - $ 51,574,688 Property Taxes $ - $ - $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - $ - $ - Special Assessments $ - $ - $ - $ - $ - $ - Licenses&Permits $ - $ - $ - $ - $ - $ - Intergovernmental $ - $ - $ - $ - $ - $ - Charges for Services $ 27,621,401 $ - $ - $ - $ - $ 27,621,401 Fines&Forfeitures $ - $ - $ - $ - $ - $ - Interest Earnings $ 375,525 $ - $ - $ - $ - $ 375,525 Miscellaneous $ 50,000 $ - $ - $ - $ - $ 50,000 Other Financing Sources $ - $ - $ - $ - $ - $ - Transfers In from Other Funds $ - $ - $ - $ - $ - $ - Total Resources $ 78,842,114 $ 462,500 $ 252,000 $ 65,000 $ - $ 79,621,614 Requirements Community Development $ - $ - S - $ - $ - $ - Community Services $ - $ - S - $ - $ - $ - Policy and Administration $ - $ - $ - $ - $ - $ - Public Works $ 11,271,128 $ - S - $ - $ 64,000 $ 11,335,128 Program Expenditures Total $ 11,271,128 $ - $ - $ - $ 64,000 $ 11,335,128 Debt Service $ - $ - $ - $ - $ - $ - Loan to CCDA $ - $ - $ - $ - $ - $ - Work-In-Progress $ - $ - $ - $ - $ - $ - Transfers to Other Funds $ 29,460,272 $ 462,500 $ 252,000 $ 65,000 $ - $ 30,239,772 Contingency $ 475,000 $ - $ - $ - $ (64,000) $ 411,000 Total Budget $ 41,206,400 $ 462,500 $ 252,000 $ 65,000 $ - $ 41,985,900 Reserve For Future Expenditure $ 37,635,714 $ - $ - $ - $ - $ 37,635,714 Total Requirements $ 78,842,114 $ 462,500 $ 252,000 $ 65,000 $ - $ 79,621,614 Exhibit B Fleet/Property Management Fund FY 2023 Revised Q1 Fleet/Property Management Fund Budget Q1FleetOl Q1FINO2 Budget Resources Beginning Fund Balance $ 1,400,836 $ 103,500 $ - $ 1,504,336 Property Taxes $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - Special Assessments $ - $ - $ - $ - Licenses&Permits $ - $ - $ - $ - Intergovernmental $ - $ - $ - $ - Charges for Services $ 3,064,063 $ - $ - $ 3,064,063 Fines&Forfeitures $ - $ - $ - $ - Interest Earnings $ - $ - $ - $ - Miscellaneous $ 5,000 $ - $ - $ 5,000 Other Financing Sources $ - $ - $ - $ - Transfers In from Other Funds S - $ - S - S - Total Resources $ 4,469,899 $ 103,500 $ - $ 4,573,399 Requirements Community Development $ - $ - Community Services $ - $ - Policy and Administration $ 3,252,535 $ 103,500 $ 46,000 $ 3,402,035 Public Works $ - S - Program Expenditures Total $ 3,252,535 $ 103,500 $ 46,000 $ 3,402,035 Debt Service $ - $ - $ - $ - Loan to CCDA S - $ - $ - $ - Work-In-Progress S - $ - $ - $ - Transfers to Other Funds S 1,000,000 $ - $ - $ 1,000,000 Contingency $ 125,000 $ - $ (46,000) $ 79,000 Total Budget $ 4,377,535 $ 103,500 $ - $ 4,481,035 Reserve For Future Expenditure $ 92,364 $ - $ - $ 92,364 Total Requirements $ 4,469,899 $ 103,500 $ - $ 4,573,399