Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Resolution No. 19-39
CITY OF TIGARD, OREGON TIGARD CITY COUNCIL RESOLUTION NO. 19--?q A RESOLUTION TO ADOPT THE FY 2020 FIRST QUARTER BUDGET SUPPLEMENTAL INCLUDING BUDGET ADJUSTMENTS TO PUBLIC WORKS, POLICY AND ADMINISTRATION, AND COMMUNITY SERVICES. WHEREAS,the city acknowledges those items that were unknown at the time the FY 2020 budget was adopted; and WHEREAS, the city recognizes approximately $2,348,558 of unanticipated budget in operations and transfers; and WHEREAS, the increase in budget is offset by unanticipated fund balance, miscellaneous revenue, and contingency. NOW,THEREFORE,BE IT RESOLVED by the Tigard City Council that: SECTION 1: The FY 2019-20 Budget is hereby amended as detailed in Exhibit B. SECTION: This resolution is effective immediately upon passage. PASSED: This /S day of�f�U(� -e—r' 2019. Mayor-City o d ATTEST: Cr.o�.•c.'I' �r % .T� City Recorder-City of Tigard RESOLUTION NO. 19- Page 1 Exhibit B Total All Funds FY 2020 Q1 Revised Total All Funds Adopted Amendment Q1 Resources Beginning Fund Balance $ 140,945,996 $ 842,166 $ 141,788,162 Property Taxes $ 19,507,041 $ - $ 19,507,041 Franchise Fees $ 6,254,627 $ - $ 6,254,627 Special Assessments $ 50,000 $ - $ 50,000 Licenses&Permits $ 13,319,103 $ - $ 13,319,103 Intergovernmental $ 15,475,617 $ 285,000 $ 15,760,617 Charges for Services $ 47,840,386 $ - $ 47,840,386 Fines&Forfeitures $ 1,655,957 $ $ 1,655,957 Interest Earnings $ 2,634,000 $ - $ 2,634,000 Miscellaneous $ 315,850 $ 346,226 $ 662,076 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 25,688,895 $ 875,166 $ 26,564,061 Total Resources $ 273,687,472 $ 2,348,558 $ 276,036,030 Requirements Community Development $ 5,736,099 $ 284,361 $ 6,020,460 Community Services $ 26,070,545 $ 160,501 $ 26,231,046 Policy and Administration $ 13,782,572 $ 609,468 $ 14,392,040 Public Works $ 29,565,895 $ 403,331 $ 29,969,226 Program Expenditures Total $ 75,155,111 $ 1,457,661 $ 76,612,772 Debt Service $ 11,659,000 $ - $ 11,659,000 Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ 21,813,009 $ 1,184,557 $ 22,997,566 Transfers to Other Funds $ 26,068,895 $ 875,166 $ 26,944,061 Contingency $ 4,703,450 $ (1,098,826) $ 3,604,624 Total Budget $ 139,400,465 $ 2,418,558 $ 141,819,023 Reserve For Future Expenditure $ 134,287,007 $ (70,000) $ 134,217,007 Total Requirements $ 273,687,472 $ 2,348,558 $ 276,036,030 Exhibit B General Fund FY 2020 Revised General Fund Adopted QlCM04 Q1FIS01 QlFIS03 QlFIS04 Q1FIS05 Q1PD01 QlPW04 Q1 Resources Beginning Fund Balance $ 21,824,486 $ - $ - $ - $ - $ - $ - $ 5,500 $ 21,829,986 Property Taxes $ 17,121,416 $ - $ - $ $ - $ $ $ - $ 17,121,416 Franchise Fees $ 6,254,627 $ - $ - $ $ - $ $ $ $ 6,254,627 Special Assessments $ - $ - $ - $ - $ - $ - $ - $ - $ - Licenses&Permits $ 1,186,521 $ - $ - $ $ - $ $ $ - $ 1,186,521 Intergovernmental $ 7,347,865 $ $ - $ $ - $ $ - $ - $ 7,347,865 Charges for Services $ 253,702 $ - $ - $ - $ - $ $ $ - $ 253,702 Fines&Forfeitures $ 1,654,498 $ - $ $ $ - $ $ - $ $ 1,654,498 Interest Earnings $ 500,900 $ $ $ - $ $ $ - $ - $ 500,900 Miscellaneous $ 56,432 $ - $ - $ $ 150,838 $ $ 8,200 $ $ 215,470 Other Financing Sources $ - $ $ $ - $ - $ $ - $ $ - Transfers In from Other Funds $ 292,900 $ - $ - $ $ - $ $ - $ $ 292,900 Total Resources $ 56,493,347 $ - $ - $ - $ 150,838 $ - $ 8,200 $ 5,500 $ 56,657,885 Requirements Community Development $ 3,613,352 $ 24,891 $ - $ 64,191 $ 150,838 $ $ - $ - $ 3,853272 Community Services $ 25,919,480 $ 10,899 $ $ 106,002 $ - $ $ 43,600 $ - $ 26,079,981 Policy and Administration $ 1,054,831 $ 2,859 $ $ 19,474 $ - $ 12,609 $ - $ - $ 1,089,773 Public Works $ - $ - $ - $ - $ - $ - $ - $ - $ - Program Expenditures Total $ 30,587,663 $ 38,649 $ - $ 189,667 $ 150,838 $ 12,609 $ 43,600 $ - $ 31,023,026 Debt Service $ - $ - $ $ - $ - $ - $ - $ - $ - Loan to TCDA $ 1,000 $ - $ $ $ - $ - $ $ - $ 1,000 Work-In-Progress $ 12,609 $ - $ $ $ - $ (12,609) $ - $ $ - Transfers to Other Funds $ 2,611,477 $ - $ 55,000 $ $ - $ $ $ 5,500 $ 2,671,977 Contingency $ 1,638,450 $ (38,649) $ (55,000) $ (189,667) $ $ - $ (35,400) $ - $ 1,319,734 Total Budget $ 34,851,199 $ - $ - $ - $ 150,838 $ - $ 8,200 $ 5,500 $ 35,015,737 Reserve For Future Expenditure $ 21,642,148 $ - $ - $ - $ - $ - $ - $ - $ 21,642,148 Total Requirements $ 56,493,347 $ - $ - $ - $ 150,838 $ - $ 8,200 $ 5,500 $ 56,657,885 Exhibit B Gas Tax Fund FY 2020 Revised Gas Tax Fund Adopted Q1FIS03 Q1PW04 Q1PW11 Q1 Resources Beginning Fund Balance $ 2,960,484 $ - $ 15,500 $ - $ 2,975,984 Property Taxes $ - $ - $ - $ - $ - Franchise Fees $ $ - $ - $ - $ - Special Assessments $ - $ - $ - $ $ - Licenses&Permits $ 65,965 $ $ $ $ 65,965 Intergovernmental $ 4,381,236 $ $ $ $ 4,381,236 Charges for Services $ - $ $ - $ $ - Fines&Forfeitures $ - $ - $ $ $ - Interest Earnings $ 82,400 $ - $ - $ - $ 82,400 Miscellaneous $ 62,818 $ - $ $ - $ 62,818 Other Financing Sources $ - $ - $ - $ - $ - Transfers In from Other Funds $ 158,000 $ $ - $ $ 158,000 Total Resources $ 7,710,903 $ - $ 15,500 $ - $ 7,726,403 Requirements Community Development $ - $ $ - $ $ - Community Services $ $ $ $ $ Policy and Administration $ - $ - $ - $ - $ - Public Works $ 3,760,480 $ 25,270 $ - $ 7,350 $ 3,793,100 Program Expenditures Total $ 3,760,480 $ 25,270 $ - $ 7,350 $ 3,793,100 Debt Service $ 577,230 $ - $ $ - $ 577,230 Loan to TCDA $ - $ $ $ $ - Work-In-Progress $ - $ $ - $ $ - Transfers to Other Funds $ 2,131,900 $ - $ 15,500 $ $ 2,147,400 Contingency $ 222,000 $ (25,270) $ - $ (7,350) $ 189,380 Total Budget $ 6,691,610 $ - $ 15,500 $ - $ 6,707,110 Reserve For Future Expenditure $ 1,019,293 $ - $ - $ - $ 1,019,293 Total Requirements $ 7,710,903 $ - $ 15,500 $ - $ 7,726,403 Exhibit 6 Transient Lodging Tax Fund FY 2020 Revised Transient Lodging Tax Fund Adopted Q1PW02 Q1 Resources Beginning Fund Balance $ 452,598 $ 29,166 $ 481,764 Property Taxes $ - $ - $ - Franchise Fees $ $ - $ Special Assessments $ - $ - $ Licenses&Permits $ - $ $ - Intergovernmental $ 683,920 $ $ 683,920 Charges for Services $ - $ - $ - Fines&Forfeitures $ - $ $ - Interest Earnings $ 4,800 $ - $ 4,800 Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 1,141,318 $ 29,166 $ 1,170,484 Requirements Community Development $ - $ - $ - Community Services $ $ - $ - Policy and Administration $ $ - $ Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ Loan to TCDA $ $ - $ Work-In-Progress $ - $ $ - Transfers to Other Funds $ 344,900 $ 29,166 $ 374,066 Contingency $ - $ - $ - Total Budget $ 344,900 $ 29,166 $ 374,066 Reserve For Future Expenditure $ 796,418 $ - $ 796,418 Total Requirements $ 1,141,318 $ 29,166 $ 1,170,484 Exhibit B Building Fund FY 2020 Revised Building Fund Adopted Q1FIS03 Q1 Resources Beginning Fund Balance $ 8,021,235 $ - $ 8,021,235 Property Taxes $ - $ - $ Franchise Fees $ - $ $ - Special Assessments $ - $ - $ - Licenses&Permits $ 2,322,956 $ - $ 2,322,956 Intergovernmental $ 8,281 $ - $ 8,281 Charges for Services $ 7,000 $ - $ 7,000 Fines&Forfeitures $ - $ - $ - Interest Earnings $ 150,500 $ - $ 150,500 Miscellaneous $ 500 $ - $ 500 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 250,000 $ $ 250,000 Total Resources $ 10,760,472 $ - $ 10,760,472 Requirements Community Development $ 2,122,747 $ 44,441 $ 2,167,188 Community Services $ - $ - $ - Policy and Administration $ $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ 2,122,747 $ 44,441 $ 2,167,188 Debt Service $ - $ - $ - Loan to TCDA $ - $ $ - Work-In-Progress $ $ - $ - Transfers to Other Funds $ $ $ - Contingency $ 295,000 $ (44,441) $ 250,559 Total Budget $ 2,417,747 $ - $ 2,417,747 Reserve For Future Expenditure $ 8,342,725 $ - $ 8,342,725 Total Requirements $ 10,760,472 $ - $ 10,760,472 Exhibit B Urban Forestry Fund FY 2020 Revised Urban Forestry Fund Adopted Q1PW01 Q1 Resources Beginning Fund Balance $ 1,015,203 $ - $ 1,015,203 Property Taxes $ - $ - $ - Franchise Fees $ $ - $ - Special Assessments $ $ - $ Licenses&Permits $ $ $ Intergovernmental $ $ - $ Charges for Services $ - $ $ - Fines&Forfeitures $ $ - $ - Interest Earnings $ 35,200 $ $ 35,200 Miscellaneous $ 15,000 $ - $ 15,000 Other Financing Sources $ - $ $ - Transfers In from Other Funds $ - $ $ - Total Resources $ 1,065,403 $ - $ 1,065,403 Requirements Community Development $ - $ - $ Community Services $ $ $ - Policy and Administration $ - $ $ - Public Works $ - $ $ - Program Expenditures Total $ - $ - $ - Debt Service $ $ $ - Loan to TCDA $ $ - $ - Work-In-Progress $ - $ - $ Transfers to Other Funds $ 148,900 $ 70,000 $ 218,900 Contingency $ - $ - $ - Total Budget $ 148,900 $ 70,000 $ 218,900 Reserve For Future Expenditure $ 916,503 $ (70,000) $ 846,503 Total Requirements $ 1,065,403 $ - $ 1,065,403 Exhibit B Parks Capital Fund FY 2020 Revised Parks Capital Fund Adopted Q1PW01 QlPW02 Q1PW03 Q1PW04 QlPW05 Q1PW06 Q1 Resources Beginning Fund Balance $ 880,000 $ - $ - $ - $ - $ - $ - $ 880,000 Property Taxes $ - $ - $ - $ $ $ $ - $ - Franchise Fees $ $ $ - $ - $ - $ $ $ - Special Assessments $ $ $ - $ - $ - $ $ - $ Licenses&Permits $ - $ $ $ - $ - $ $ $ - Intergovernmental $ 867,000 $ 112,000 $ 58,000 $ $ - $ - $ - $ 1,037,000 Charges for Services $ - $ - $ - $ $ - $ $ - $ - Fines&Forfeitures $ - $ $ $ - $ - $ $ $ - Interest Earnings $ - $ - $ - $ $ $ $ - $ - Miscellaneous $ - $ - $ $ - $ $ - $ - $ - Other Financing Sources $ - $ - $ $ $ - $ - $ - $ - Transfers In from Other Funds $ 3,707,000 $ 332,000 $ 29,166 $ 187,000 $ 30,000 $ 44,000 $ 22,000 $ 4,351,166 Total Resources $ 5,454,000 $ 444,000 $ 87,166 $ 187,000 $ 30,000 $ 44,000 $ 22,000 $ 6,268,166 Requirements Community Development $ - $ - $ - $ - $ - $ - $ - $ - Community Services $ - $ $ $ $ $ - $ - $ Policy and Administration $ - $ $ $ $ $ - $ $ Public Works $ - $ - $ $ $ $ - $ - $ - Program Expenditures Total $ - $ - $ - $ - $ - $ - $ - $ - Debt Service $ - $ $ $ - $ $ - $ $ Loan to TCDA $ - $ $ $ - $ $ $ - $ - Work-In-Progress $ 4,709,500 $ 444,000 $ 87,166 $ 187,000 $ 30,000 $ 44,000 $ 22,000 $ 5,523,666 Transfers to Other Funds $ - $ - $ - $ - $ - $ - $ - $ - Contingency $ - $ - $ - $ - $ - $ - $ - $ - Total Budget $ 4,709,500 $ 444,000 $ 87,166 $ 187,000 $ 30,000 $ 44,000 $ 22,000 $ 5,523,666 Reserve For Future Expenditure $ 744,500 $ - $ - $ - $ - $ - $ - $ 744,500 Total Requirements $ 5,454,000 $ 444,000 $ 87,166 $ 187,000 $ 30,000 $ 44,000 $ 22,000 $ 6,268,166 Exhibit B Parks Utility Fund FY 2020 Revised Parks Utility Fund Adopted Q1FIS03 Q1PW11 Q1 Resources Beginning Fund Balance $ 1,452,584 $ - $ - $ 1,452,584 Property Taxes $ - $ - $ $ - Franchise Fees $ - $ - $ $ - Special Assessments $ - $ $ - $ - Licenses&Permits $ 1,790,593 $ $ - $ 1,790,593 Intergovernmental $ - $ $ - $ - Charges for Services $ 90,750 $ - $ - $ 90,750 Fines&Forfeitures $ - $ - $ - $ - Interest Earnings $ 3,300 $ - $ - $ 3,300 Miscellaneous $ - $ - $ - $ - Other Financing Sources $ - $ - $ - $ - Transfers In from Other Funds $ 2,213,770 $ $ - $ 2,213,770 Total Resources $ 5,550,997 $ - $ - $ 5,550,997 Requirements Community Development $ - $ $ $ - Community Services $ - $ $ $ - Policy and Administration $ - $ - $ - $ - Public Works $ 3,807,739 $ 49,998 $ 14,700 $ 3,872,437 Program Expenditures Total $ 3,807,739 $ 49,998 $ 14,700 $ 3,872,437 Debt Service $ - $ - $ - $ - Loan to TCDA $ - $ $ - $ Work-In-Progress $ - $ $ - $ - Transfers to Other Funds $ 61,538 $ $ - $ 61,538 Contingency $ 135,000 $ (49,998) $ (14,700) $ 70,302 Total Budget $ 4,004,277 $ - $ - $ 4,004,277 Reserve For Future Expenditure $ 1,546,720 $ - $ - $ 1,546,720 Total Requirements $ 5,550,997 $ - $ - $ 5,550,997 Exhibit B Parks SDC Fund FY 2020 Revised Parks SDC Fund Adopted Q1PW01 Q1PW03 Q1PW04 Q1PW05 Q1PW06 Q1 Resources Beginning Fund Balance $ 8,532,863 $ 262,000 $ 109,000 $ 9,000 $ 44,000 $ 22,000 $ 8,978,863 Property Taxes $ - $ - $ - $ - $ - $ - $ - Franchise Fees $ $ $ - $ - $ $ - $ - Special Assessments $ - $ - $ - $ $ - $ - $ - Licenses&Permits $ 503,390 $ - $ $ $ - $ - $ 503,390 Intergovernmental $ - $ - $ - $ $ $ - $ - Charges for Services $ - $ - $ - $ $ - $ - $ - Fines&Forfeitures $ $ - $ - $ - $ - $ - $ - Interest Earnings $ 211,100 $ $ - $ $ $ - $ 211,100 Miscellaneous $ - $ - $ - $ - $ - $ - $ - Other Financing Sources $ $ $ - $ $ - $ $ Transfers In from Other Funds $ $ $ $ - $ $ $ - Total Resources $ 9,247,353 $ 262,000 $ 109,000 $ 9,000 $ 44,000 $ 22,000 $ 9,693,353 Requirements Community Development $ $ $ - $ - $ $ - $ - Community Services $ - $ $ $ - $ $ - $ Policy and Administration $ $ - $ - $ $ $ $ - Public Works $ $ $ $ - $ $ $ - Program Expenditures Total $ - $ - $ - $ - $ - $ - $ Debt Service $ $ - $ - $ $ $ $ - Loan to TCDA $ $ - $ - $ - $ - $ - $ - Work-In-Progress $ $ - $ - $ - $ $ $ - Transfers to Other Funds $ 2,847,400 $ 262,000 $ 109,000 $ 9,000 $ 44,000 $ 22,000 $ 3,293,400 Contingency $ - $ - $ - $ - $ - $ - $ - Total Budget $ 2,847,400 $ 262,000 $ 109,000 $ 9,000 $ 44,000 $ 22,000 $ 3,293,400 Reserve For Future Expenditure $ 6,399,953 $ - $ - $ - $ - $ - $ 6,399,953 Total Requirements $ 9,247,353 $ 262,000 $ 109,000 $ 9,000 $ 44,000 $ 22,000 $ 9,693,353 Exhibit B Transportation CIP Fund FY 2020 Revised Transportation CIP Fund Adopted Q1PW09 Q1 Resources Beginning Fund Balance $ 820,000 $ - $ 820,000 Property Taxes $ - $ $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ - $ - $ - Intergovernmental $ 1,038,200 $ 115,000 $ 1,153,200 Charges for Services $ - $ - $ - Fines&Forfeitures $ - $ $ Interest Earnings $ - $ $ Miscellaneous $ $ $ - Other Financing Sources $ $ - $ - Transfers In from Other Funds $ 4,093,200 $ 12,000 $ 4,105,200 Total Resources $ 5,951,400 $ 127,000 $ 6,078,400 Requirements Community Development $ - $ - $ Community Services $ - $ $ - Policy and Administration $ $ $ - Public Works $ $ $ Program Expenditures Total $ - $ - $ - Debt Service $ - $ $ - Loan to TCDA $ $ - $ - Work-In-Progress $ 5,231,400 $ 127,000 $ 5,358,400 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ - Total Budget $ 5,231,400 $ 127,000 $ 5,358,400 Reserve For Future Expenditure $ 720,000 $ - $ 720,000 Total Requirements $ 5,951,400 $ 127,000 $ 6,078,400 Exhibit B Transportation SDC Fund FY 2020 Revised Transportation SDC Fund Adopted Q1PW03 Q1PW09 Q1 Resources Beginning Fund Balance $ 7,289,996 $ 78,000 $ 12,000 $ 7,379,996 Property Taxes $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - Special Assessments $ - $ - $ - $ - Licenses&Permits $ 409,500 $ - $ $ 409,500 Intergovernmental $ - $ - $ - $ - Charges for Services $ - $ $ - $ - Fines&Forfeitures $ - $ $ - $ - Interest Earnings $ 144,000 $ - $ - $ 144,000 Miscellaneous $ - $ - $ - $ - Other Financing Sources $ - $ - $ $ Transfers In from Other Funds $ $ - $ $ - Total Resources $ 7,843,496 $ 78,000 $ 12,000 $ 7,933,496 Requirements Community Development $ $ - $ - $ - Community Services $ - $ - $ $ - Policy and Administration $ $ $ $ Public Works $ $ $ - $ Program Expenditures Total $ - $ - $ - $ - Debt Service $ - $ - $ $ - Loan to TCDA $ - $ - $ $ - Work-In-Progress $ $ - $ $ - Transfers to Other Funds $ 209,000 $ 78,000 $ 12,000 $ 299,000 Contingency $ - $ - $ - $ - Total Budget $ 209,000 $ 78,000 $ 12,000 $ 299,000 Reserve For Future Expenditure $ 7,634,496 $ - $ - $ 7,634,496 Total Requirements $ 7,843,496 $ 78,000 $ 12,000 $ 7,933,496 Exhibit B Sanitary Sewer Fund FY 2020 Revised Sanitary Sewer Fund Adopted QICM03 QlFIS03 Q1FIS05 Q1 Resources Beginning Fund Balance $ 4,903,060 $ - $ - $ - $ 4,903,060 Property Taxes $ - $ - $ - $ - $ - Franchise Fees $ - $ - $ $ - $ - Special Assessments $ - $ $ - $ $ - Licenses&Permits $ 92,200 $ $ - $ $ 92,200 Intergovernmental $ - $ $ $ - $ - Charges for Services $ 3,255,811 $ - $ $ - $ 3,255,811 Fines&Forfeitures $ - $ - $ - $ $ - Interest Earnings $ 110,300 $ - $ - $ - $ 110,300 Miscellaneous $ 42,100 $ $ $ $ 42,100 Other Financing Sources $ - $ $ $ - $ - Transfers In from Other Funds $ 243,750 $ - $ $ 74,000 $ 317,750 Total Resources $ 8,647,221 $ - $ - $ 74,000 $ 8,721,221 Requirements Community Development $ - $ $ - $ - $ - Community Services $ - $ - $ - $ - $ Policy and Administration $ $ - $ - $ - $ - Public Works $ 2,301,899 $ 5,965 $ 14,131 $ - $ 2,321,995 Program Expenditures Total $ 2,301,899 $ 5,965 $ 14,131 $ - $ 2,321,995 Debt Service $ - $ - $ - $ - $ - Loan to TCDA $ - $ - $ $ $ - Work-In-Progress $ 1,206,500 $ - $ - $ 74,000 $ 1,280,500 Transfers to Other Funds $ 659,200 $ - $ - $ - $ 659,200 Contingency $ 414,000 $ (5,965) $ (14,131) $ - $ 393,904 Total Budget $ 4,581,599 $ - $ - $ 74,000 $ 4,655,599 Reserve For Future Expenditure $ 4,065,622 $ - $ - $ - $ 4,065,622 Total Requirements $ 8,647,221 $ - $ - $ 74,000 $ 8,721,221 Exhibit B Stormwater Fund FY 2020 Revised Stormwater Fund Adopted Q1CM03 QlFIS03 Q1FIS05 Q1PW07 Q1PW08 Q1PW11 Q1 Resources Beginning Fund Balance $ 6,456,618 $ - $ - $ - $ 40,000 $ 126,000 $ - $ 6,622,618 Property Taxes $ - $ $ $ $ - $ $ - $ - Franchise Fees $ - $ $ - $ - $ - $ - $ - $ - Special Assessments $ $ $ - $ $ $ - $ - $ - Licenses&Permits $ $ $ $ - $ $ $ - $ - Intergovernmental $ $ $ $ $ $ $ - $ - Charges for Services $ 3,892,188 $ - $ $ - $ - $ $ - $ 3,892,188 Fines&Forfeitures $ - $ $ - $ $ - $ $ $ - Interest Earnings $ 139,900 $ $ - $ - $ - $ - $ - $ 139,900 Miscellaneous $ 5,000 $ $ - $ - $ - $ - $ $ 5,000 Other Financing Sources $ - $ - $ $ - $ $ - $ - $ - Transfers In from Other Funds $ 704,000 $ $ - $ - $ - $ - $ - $ 704,000 Total Resources $ 11,197,706 $ - $ - $ - $ 40,000 $ 126,000 $ - $ 11,363,706 Requirements Community Development $ - $ $ - $ $ - $ - $ - $ - Community Services $ $ $ $ - $ - $ $ - $ Policy and Administration $ $ $ $ - $ - $ $ - $ - Public Works $ 2,977,842 $ 5,818 $ 28,768 $ - $ - $ $ 7,350 $ 3,019,778 Program Expenditures Total $ 2,977,842 $ 5,818 $ 28,768 $ - $ - $ - $ 7,350 $ 3,019,778 Debt Service $ - $ - $ - $ $ - $ - $ - $ - Loan to TCDA $ - $ - $ $ $ - $ - $ - $ - Work-In-Progress $ 2,410,500 $ $ $ (74,000) $ 40,000 $ 126,000 $ - $ 2,502,500 Transfers to Other Funds $ 311,550 $ $ - $ 74,000 $ - $ - $ - $ 385,550 Contingency $ 225,000 $ (5,818) $ (28,768) $ - $ - $ - $ (7,350) $ 183,064 Total Budget $ 5,924,892 $ - $ - $ - $ 40,000 $ 126,000 $ - $ 6,090,892 Reserve For Future Expenditure $ 5,272,814 $ - $ - $ - $ - $ - $ - $ 5,272,814 Total Requirements $ 11,197,706 $ - $ - $ - $ 40,000 $ 126,000 $ - $ 11,363,706 Exhibit B Water Fund FY 2020 Revised Water Fund Adopted Q1CM03 QlFIS03 Q1PW10 Q1 Resources Beginning Fund Balance $ 30,807,424 $ - $ - $ 54,000 $ 30,861,424 Property Taxes $ - $ $ - $ - $ - Franchise Fees $ - $ $ - $ - $ - Special Assessments $ - $ - $ - $ $ - Licenses&Permits $ 170,000 $ $ - $ - $ 170,000 Intergovernmental $ 15,000 $ $ - $ - $ 15,000 Charges for Services $ 22,405,446 $ $ - $ - $ 22,405,446 Fines&Forfeitures $ - $ $ - $ - $ - Interest Earnings $ 500,700 $ $ - $ - $ 500,700 Miscellaneous $ 50,000 $ - $ - $ $ 50,000 Other Financing Sources $ - $ $ - $ - $ - Transfers In from Other Funds $ - $ $ - $ $ - Total Resources $ 53,948,570 $ - $ - $ 54,000 $ 54,002,570 Requirements Community Development $ - $ $ - $ - $ - Community Services $ $ $ $ - $ - Policy and Administration $ $ $ $ - $ - Public Works $ 10,246,079 $ 3,377 $ 40,201 $ - $ 10,289,657 Program Expenditures Total $ 10,246,079 $ 3,377 $ 40,201 $ - $ 10,289,657 Debt Service $ - $ - $ - $ - $ - Loan to TCDA $ $ $ - $ - $ - Work-In-Progress $ $ $ - $ - $ - Transfers to Other Funds $ 10,651,600 $ $ - $ 54,000 $ 10,705,600 Contingency $ 539,000 $ (3,377) $ (40,201) $ - $ 495,422 Total Budget $ 21,436,679 $ - $ - $ 54,000 $ 21,490,679 Reserve For Future Expenditure $ 32,511,891 $ - $ - $ - $ 32,511,891 Total Requirements $ 53,948,570 $ - $ - $ 54,000 $ 54,002,570 Exhibit B Water SDC Fund FY 2020 Revised Water SDC Fund Adopted Q1PW10 Q1 Resources Beginning Fund Balance $ 12,052,538 $ 36,000 $ 12,088,538 Property Taxes $ - $ - $ Franchise Fees $ - $ $ - Special Assessments $ - $ $ - Licenses&Permits $ 1,276,200 $ $ 1,276,200 Intergovernmental $ - $ $ - Charges for Services $ - $ $ - Fines&Forfeitures $ - $ - $ - Interest Earnings $ 258,200 $ - $ 258,200 Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 13,586,938 $ 36,000 $ 13,622,938 Requirements Community Development $ - $ - $ - Community Services $ - $ $ - Policy and Administration $ - $ $ - Public Works $ - $ $ Program Expenditures Total $ - $ - $ Debt Service $ - $ - $ Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 2,170,000 $ 36,000 $ 2,206,000 Contingency $ - $ - $ - Total Budget $ 2,170,000 $ 36,000 $ 2,206,000 Reserve For Future Expenditure $ 11,416,938 $ - $ 11,416,938 Total Requirements $ 13,586,938 $ 36,000 $ 13,622,938 Exhibit B Water CIP Fund FY 2020 Revised Water CIP Fund Adopted Q1PW10 Q1 Resources Beginning Fund Balance $ 1,530,000 $ - $ 1,530,000 Property Taxes $ - $ $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ - $ $ - Intergovernmental $ $ $ - Charges for Services $ $ - $ - Fines&Forfeitures $ $ - $ - Interest Earnings $ - $ - $ - N iscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 4,304,500 $ 90,000 $ 4,394,500 Total Resources $ 5,834,500 $ 90,000 $ 5,924,500 Requirements Community Development $ - $ - $ - Community Services $ - $ $ - Policy and Administration $ - $ $ Public Works $ $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ $ Loan to TCDA $ - $ $ - Work-In-Progress $ 4,304,500 $ 90,000 $ 4,394,500 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ - Total Budget $ 4,304,500 $ 90,000 $ 4,394,500 Reserve For Future Expenditure $ 1,530,000 $ - $ 1,530,000 Total Requirements $ 5,834,500 $ 90,000 $ 5,924,500 Exhibit B PW Engineering Fund FY 2020 Revised PW Engineering Fund Adopted Q1FIS03 Q1FIS04 Q1 Resources Beginning Fund Balance $ 541,296 $ - $ - $ 541,296 Property Taxes $ - $ $ $ - Franchise Fees $ - $ $ - $ Special Assessments $ - $ - $ - $ - Licenses&Permits $ 800,000 $ $ $ 800,000 Intergovernmental $ 145,128 $ - $ - $ 145,128 Charges for Services $ 2,920,852 $ - $ - $ 2,920,852 Fines&Forfeitures $ - $ $ $ - Interest Earnings $ - $ - $ $ - N iscellaneous $ - $ - $ 86,152 $ 86,152 Other Financing Sources $ - $ - $ - $ - Transfers In from Other Funds $ 640,718 $ - $ - $ 640,718 Total Resources $ 5,047,994 $ - $ 86,152 $ 5,134,146 Requirements Community Development $ - $ - $ - $ - Community Services $ - $ - $ $ Policy and Administration $ $ $ $ - Public Works $ 4,198,168 $ 72,838 $ 86,152 $ 4,357,158 Program Expenditures Total $ 4,198,168 $ 72,838 $ 86,152 $ 4,357,158 Debt Service $ - $ - $ - $ - Loan to TCDA $ - $ - $ $ Work-In-Progress $ - $ - $ - $ Transfers to Other Funds $ - $ - $ - $ - Contingency $ 170,000 $ (72,838) $ - $ 97,162 Total Budget $ 4,368,168 $ - $ 86,152 $ 4,454,320 Reserve For Future Expenditure $ 679,826 $ - $ - $ 679,826 Total Requirements $ 5,047,994 $ - $ 86,152 $ 5,134,146 Exhibit B PW Admin Fund FY 2020 Revised PW Admin Fund Adopted Q1CM03 Q1FIS03 Q1 Resources Beginning Fund Balance $ 316,216 $ - $ - $ 316,216 Property Taxes $ - $ - $ $ - Franchise Fees $ - $ - $ $ Special Assessments $ - $ - $ $ - Licenses&Permits $ $ - $ $ - Intergovernmental $ $ - $ $ - Charges for Services $ 2,262,895 $ - $ - $ 2,262,895 Fines&Forfeitures $ - $ - $ - $ - Interest Earnings $ - $ - $ - $ Miscellaneous $ - $ - $ - $ Other Financing Sources $ - $ - $ - $ - Transfers In from Other Funds $ 48,336 $ $ - $ 48,336 Total Resources $ 2,627,447 $ - $ - $ 2,627,447 Requirements Community Development $ - $ - $ $ - Community Services $ - $ - $ $ Policy and Administration $ - $ - $ $ - Public Works $ 2,273,688 $ 5,546 $ 35,867 $ 2,315,101 Program Expenditures Total $ 2,273,688 $ 5,546 $ 35,867 $ 2,315,101 Debt Service $ - $ - $ - $ - Loan to TCDA $ - $ $ $ - Work-In-Progress $ - $ - $ $ Transfers to Other Funds $ - $ $ $ - Contingency $ 135,000 $ (5,546) $ (35,867) $ 93,587 Total Budget $ 2,408,688 $ - $ - $ 2,408,688 Reserve For Future Expenditure $ 218,759 $ - $ - $ 218,759 Total Requirements $ 2,627,447 $ - $ - $ 2,627,447 Exhibit B Fleet/Property Management Fund FY 2020 Revised Fleet/Property Management Fund Adopted Q1CS01 Q1FIS03 Q1 Resources Beginning Fund Balance $ 610,063 $ - $ - $ 610,063 Property Taxes $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ Special Assessments $ - $ - $ - $ - Licenses&Permits $ - $ - $ $ Intergovernmental $ $ - $ - $ - Charges for Services $ 2,719,734 $ - $ - $ 2,719,734 Fines&Forfeitures $ - $ - $ - $ - Interest Earnings $ - $ - $ - $ - Miscellaneous $ 5,000 $ - $ - $ 5,000 Other Financing Sources $ - $ - $ - $ - Transfers In from Other Funds $ - $ - $ - $ - Total Resources $ 3,334,797 $ - $ - $ 3,334,797 Requirements Community Development $ - $ - $ - $ - Community Services $ - $ - $ - $ - Policy and Administration $ 2,512,309 $ 82,000 $ 26,418 $ 2,620,727 Public Works $ - $ - $ - $ - Program Expenditures Total $ 2,512,309 $ 82,000 $ 26,418 $ 2,620,727 Debt Service $ - $ - $ - $ - Loan to TCDA $ - $ - $ - $ Work-In-Progress $ $ - $ $ - Transfers to Other Funds $ $ - $ $ - Contingency $ 226,000 $ (82,000) $ (26,418) $ 117,582 Total Budget $ 2,738,309 $ - $ - $ 2,738,309 Reserve For Future Expenditure $ 596,488 $ - $ - $ 596,488 Total Requirements $ 3,334,797 $ - $ - $ 3,334,797 Exhibit B Insurance Fund FY 2020 Revised Insurance Fund Adopted Q1CM01 QlFIS03 Q1 Resources Beginning Fund Balance $ 1,117,330 $ - $ - $ 1,117,330 Property Taxes $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ Special Assessments $ - $ - $ $ Licenses&Permits $ - $ $ - $ Intergovernmental $ $ $ - $ - Charges for Services $ - $ $ - $ Fines&Forfeitures $ $ $ $ - Interest Earnings $ 26,500 $ $ - $ 26,500 Miscellaneous $ 39,000 $ - $ - $ 39,000 Other Financing Sources $ - $ - $ - $ - Transfers In from Other Funds $ - $ - $ - $ - Total Resources $ 1,182,830 $ - $ - $ 1,182,830 Requirements Community Development $ - $ $ - $ - Community Services $ - $ $ - $ - Policy and Administration $ 64,476 $ 2,820 $ 679 $ 67,975 Public Works $ - $ - $ - $ - Program Expenditures Total $ 64,476 $ 2,820 $ 679 $ 67,975 Debt Service $ - $ - $ - $ - Loan to TCDA $ - $ - $ $ - Work-ln-Progress $ - $ $ $ - Transfers to Other Funds $ - $ - $ - $ - Contingency $ 25,000 $ (2,820) $ (679) $ 21,501 Total Budget $ 89,476 $ - $ - $ 89,476 Reserve For Future Expenditure $ 1,093,354 $ - $ - $ 1,093,354 Total Requirements $ 1,182,830 $ - $ - $ 1,182,830 Exhibit B Central Services Fund FY 2020 Revised Central Services Fund Adopted QICM01 Q1CM02 QlCM03 QlCM04 Q1FIS01 Q1FIS02 QIFIS03 QlFIS04 Q1 Resources Beginning Fund Balance $ 1,773,564 $ - $ - $ - $ - $ - $ - $ - $ - $ 1,773,564 Property Taxes $ - $ $ $ $ $ $ $ $ $ - Franchise Fees $ $ $ - $ $ - $ $ $ $ $ Special Assessments $ $ $ - $ $ $ $ $ $ $ - Licenses&Permits $ $ $ $ $ $ $ $ $ $ Intergovernmental $ $ $ $ $ $ $ $ $ $ - Charges for Services $ 10,032,008 $ $ $ - $ $ $ $ $ $ 10,032,008 Fines&Forfeitures $ - $ $ $ $ $ $ - $ $ $ - Interest Earnings $ - $ $ $ $ $ $ $ $ - $ - Miscellaneous $ 30,000 $ - $ 12,500 $ $ $ $ $ $ 88,536 $ 131,036 Other Financing Sources $ - $ - $ - $ $ $ $ $ $ - $ - Transfers In from Other Funds $ 234,721 $ $ - $ $ $ 55,000 $ $ $ - $ 289,721 Total Resources $ 12,070,293 $ - $ 12,500 $ - $ - $ 55,000 $ - $ - $ 88,536 $ 12,226,329 Requirements Community Development $ - $ $ - $ - $ $ - $ - $ $ - $ - Community Services $ - $ $ - $ $ $ - $ $ $ - $ - Policy and Administration $ 10,150,956 $ 14,780 $ 12,500 $ 18,971 $ 32,500 $ 55,000 $ 59,000 $ 181,322 $ 88,536 $ 10,613,565 Public Works $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Program Expenditures Total $ 10,150,956 $ 14,780 $ 12,500 $ 18,971 $ 32,500 $ 55,000 $ 59,000 $ 181,322 $ 88,536 $ 10,613,565 Debt Service $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Loan to TCDA $ $ $ $ $ $ $ $ - $ - $ Work-In-Progress $ $ $ $ - $ $ - $ $ $ - $ Transfers to Other Funds $ - $ $ $ $ $ $ - $ $ $ - Contingency $ 429,000 $ (14,780) $ $ (18,971) $ (32,500) $ $ (59,000) $ (181,322) $ $ 122,427 Total Budget $ 10,579,956 $ - $ 12,500 $ - $ - $ 55,000 $ - $ - $ 88,536 $ 10,735,992 Reserve For Future Expenditure $ 1,490,337 $ - $ - $ - $ - $ - $ - $ - $ - $ 1,490,337 Total Requirements $ 12,070,293 $ - $ 12,500 $ - $ - $ 55,000 $ - $ - $ 88,536 $ 12,226,329