The URL can be used to link to this page

Resolution No. 20-49 CITY OF TIGARD, OREGON TIGARD CITY COUNCIL RESOLUTION NO. 20-49 A RESOLUTION TO ADOPT THE FY 2021 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 2021 budget was adopted; and WHEREAS,the City recognizes approximately-$243,115 of unanticipated budget in operations and transfers; and WHEREAS,the decrease 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 2020-21 Budget is hereby amended as detailed in Exhibit B. SECTION 2:This resolution is effective immediately upon passage. PASSED: This 13th day of October 2020. 2-- Mayor- City of Tigard ATTEST: — (; Cay Deputy City Recorder- ity of Tigard RESOLUTION NO. 20-49 Pagel Exhibit A Q1CD01-Washington Square Grant Funds (,Metro Grant from Metro awarded for Washington Square Regional Center(WSRC) Update project. The WSRC Update Project is primarily funded by a Metro 2040 Planning and Development Grant.The city signed an intergovernmental agreement(IGA)with Metro for a $250,000 grant award in November 2019. Metro amended the IGA in July 2020 to include an additional $10,000 in grant funds to support community engagement during COVID-19.As part of the city's grant application,the city pledged $60,000 in matching funds. The matching funds portion is in the form of staff time. In addition,the request includes carryforward from FY20,$17,500. FY 2021 Q1 Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance 25,980,423 $ 17,500 $ 25,997,923 Property Taxes $ 17,753,872 $ - $ 17,753,872 Franchise Fees $ 6,615,979 $ - $ 6,615,979 Special Assessments $ - $ - $ - Licenses&Permits $ 1,123,252 $ - $ 1,123,252 Intergovernmental $ 7,428,909 $ 260,000 $ 7,688,909 Charges for Services $ 253,132 $ - $ 253,132 Fines&Forfeitures $ 2,258,261 $ - $ 2,258,261 Interest Earnings $ 400,900 $ - $ 400,900 Miscellaneous $ 356,432 $ - $ 356,432 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 354,000 $ - $ 334,000 Total Resources $ 62,525,160 $ 277,500 $ 62,802,660 Requirements Community Development $ 4,190,174 $ 277,500 $ 4,467,674 Community Services $ 26,624,316 $ - $ 26,624,316 Policy and Administration $ 1,875,705 $ - $ 1,875,705 Public Works $ - $ - $ - Program Expenditures Total $ 32,690,195 $ 277,500 $ 32,967,695 Debt Service $ - $ - $ - Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 2,673,115 $ - $ 2,673,115 Contingency $ 1,650,000 $ - $ 1,650,000 Total Budget $ 37,014,310 $ 277,500 $ 37,291,810 Reserve For Future Expenditure $ 25,510,850 $ - $ 25,510,850 Total Requirements $ 62,525,160 $ 277,500 $ 62,802,660 Exhibit A Q1CD02-River Terrace Concept Planning Grant Funds River Terrace Concept Planning project is receiving two grant awards from Metro and State Department of Land Conservation and Development(DLCD). -The 2040 grant program from Metro is funded by their region-wide construction excise tax,and support planning work to prepare land for development.The city was awarded $300,000 in 2019 to perform concept planning work in River Terrace West and South.A supplemental$10,000 was provided by Metro in 2020 to cover additional community engagement needs during the COVID-19 public health emergency. -The technical assistance grant from the State Department of Land Conservation and Development(DLCD) is provided to support communities performing housing-related work in response to HB2001 and H132003.The city was awarded two grants totaling$60,000 in 2020;one in the amount of$42,000 to update its Housing Needs Analysis in conformance with the requirements of H62003,and the other in the amount of$18,000 to perform a Housing Market Analysis to assess supply and demand for the broader range of housing options allowed under Tigard's development code changes of 2018 and the requirements of H132001. FY 2021 Q1 Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 25,980,423 $ - $ 25,980,423 Property Taxes $ 17,753,872 $ - $ 17,753,872 Franchise Fees $ 6,615,979 $ - $ 6,615,979 Special Assessments $ - $ - $ - Licenses &Permits $ 1,123,252 $ - $ 1,123,252 Intergovernmental $ 7,428,909 $ 370,000 $ 7,798,909 Charges for Services $ 253,132 $ - $ 253,132 Fines &Forfeitures $ 2,258,261 $ - $ 2,258,261 Interest Earnings $ 400,900 $ - $ 400,900 Miscellaneous $ 356,432 $ - $ 356,432 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 354,000 $ - $ 354,000 Total Resources $ 62,525,160 $ 370,000 $ 62,895,160 Requirements Community Development $ 4,190,174 $ 370,000 $ 4,560,174 Community Services $ 26,624,316 $ - $ 26,624,316 Policy and Administration $ 1,875,705 $ - $ 1,875,705 Public Works $ - $ - $ - Program Expenditures Total $ 32,690,195 $ 370,000 $ 33,060,195 Debt Service $ - $ - $ - Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 2,673,115 $ - $ 2,673,115 Contingency $ 1,650,000 $ - $ 1,650,000 Total Budget $ 37,014,310 $ 370,000 $ 37,384,310 Reserve For Future Expenditure $ 25,510,850 $ - $ 25,510,850 Total Requirements $ 62,525,160 $ 370,000 $ 62,895,160 Exhibit A Q1CD03-Carryforward for City Center Futures Project The City Center Futures projects started in February 2020 and was anticipated to be completed in FY 20. Included in these projects are the assist with transit-oriented development;evaluate and plan for the City Center Urban Renewal Plan; and update the Leland downtown redevelopment report. The projects have taken longer and requesting that$71,200 for the contract with Johnson Economics be carried forward to FY21 FY 2021 Q1 Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 25,980,423 $ 71,200 $ 26,051,623 Property Taxes $ 17,753,872 $ - $ 17,753,872 Franchise Fees $ 6,615,979 $ - $ 6,615,979 Special Assessments $ - $ - $ - Licenses &Permits $ 1,123,252 $ - $ 1,123,252 Intergovernmental $ 7,428,909 $ - $ 7,428,909 Charges for Services $ 253,132 $ - $ 253,132 Fines&Forfeitures $ 2,258,261 $ - $ 2,258,261 Interest Earnings $ 400,900 $ - $ 400,900 Miscellaneous $ 356,432 $ - $ 356,432 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 354,000 $ - $ 354,000 Total Resources $ 62,525,160 $ 71,200 $ 62,596,360 Requirements Community Development $ 4,190,174 $ 71,200 $ 4,261,374 Community Services $ 26,624,316 $ - $ 26,624,316 Policy and Administration $ 1,875,705 $ - $ 1,875,705 Public Works $ - $ - $ - Program Expenditures Total $ 32,690,195 $ 71,200 $ 32,761,395 Debt Service $ - $ - $ - Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 2,673,115 $ - $ 2,673,115 Contingency $ 1,650,000 $ - $ 1,650,000 Total Budget $ 37,014,310 $ 71,200 $ 37,085,510 Reserve For Future Expenditure $ 25,510,850 $ - $ 25,510,850 Total Requirements $ 62,525,160 $ 71,200 $ 62,596,360 Exhibit A Q1CD04 -Tigard CARES Business Assistance Grants IVa and Ivb Tigard CARES Business Assistance is expanding its services through additional Federal and State grants. This program will be utilizing Community Development Financial Institutions(CDFI's)to deliver a combination of micro-loans, loans,grants and business-advising services. The distribution of these funds has already started. -A grant disbursement from Washington County through Federal CARES act funds to recapitalize a COVID-19 business assistance grant program for$1,631K. -Two allocated grants from the State of Oregon totaling$277.5K of state and federal funding for a COVID-19 business assistance program.Additional $20.1K is added to cover program administration costs, but is not part of the State/Federal grant award. FY 2021 Q1 Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 25,980,423 $ - $ 25,980,423 Property Taxes $ 17,753,872 $ - $ 17,753,872 Franchise Fees $ 6,615,979 $ - $ 6,615,979 Special Assessments $ - $ - $ - Licenses &Permits $ 1,123,252 $ - $ 1,123,252 Intergovernmental $ 7,428,909 $ 1,908,500 $ 9,337,409 Charges for Services $ 253,132 $ - $ 253,132 Fines&Forfeitures $ 2,258,261 $ - $ 2,258,261 Interest Earnings $ 400,900 $ - $ 400,900 Miscellaneous $ 356,432 $ - $ 356,432 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 354,000 $ - $ 354,000 Total Resources $ 62,525,160 $ 1,908,500 $ 64,433,660 Requirements Community Development $ 4,190,174 $ - $ 4,190,174 Community Services $ 26,624,316 $ 1,928,600 $ 28,552,916 Policy and Administration $ 1,875,705 $ - $ 1,875,705 Public Works $ - $ - $ - Program Expenditures Total $ 32,690,195 $ 1,928,600 $ 34,618,795 Debt Service $ - $ - $ - Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 2,673,115 $ - $ 2,673,115 Contingency $ 1,650,000 $ (20,100) $ 1,629,900 Total Budget $ 37,014,310 $ 1,908,500 $ 38,922,810 Reserve For Future Expenditure $ 25,510,850 $ - $ 25,510,850 Total Requirements $ 62,525,160 $ 1,908,500 $ 64,433,660 Exhibit A Q1CM01- City Manager Recruitment City manager is leaving in November and city council wishes to engage a national recruiting firm. This was an unanticipated expense made necessary for Council to find the next city manager. Existing staff do not have the capacity or expertise to perform a national search. FY 2021 Q1 Revised Central Services Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,996,623 $ - $ 1,996,623 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ 11,662,196 $ - $ 11,662,196 Fines&Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ 90,000 $ - $ 90,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 699,752 $ - $ 699,752 Total Resources $ 14,448,571 $ M $ 14,448,571 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ 12,023,748 $ 50,000 $ 12,073,748 Public Works $ - $ - $ - Program Expenditures Total $ 12,023,748 $ 50,000 $ 12,073,748 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ - $ - $ - Contingency $ 400,000 $ (50,000) $ 350,000 Total Budget $ 12,423,748 $ - $ 12,423,748 Reserve For Future Expenditure $ 2,024,823 $ - $ 2,024,823 Total Requirements $ 14,448,571 $ - 14,448,571 Exhibit A Q1CM02 - Communications consultant for Strategic Plan refresh Consultant services to help guide public outreach to promote the refreshed Strategic Plan.This unanticipated expense is based on the City Council's desire to expand public outreach on the refreshed Strategic Plan and its links to other city goals&initiatives.Current staffing levels do not meet the needs or expertise required. FY 2021 Q1 Revised Central Services Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,996,623 $ - $ 1,996,623 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ 11,662,196 $ - $ 11,662,196 Fines&Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ 90,000 $ - $ 90,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 699,752 $ - $ 699,752 Total Resources $ 14,448,571 $ $ 14,448,571 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ 12,023,748 $ 30,000 $ 12,053,748 Public Works $ - $ - $ - Program Expenditures Total $ 12,023,748 $ 30,000 $ 12,053,748 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ - $ - $ - Contingency $ 400,000 $ (30,000) $ 370,000 Total Budget $ 12,423,748 $ - $ 12,423,748 Reserve For Future Expenditure $ 2,024,823 $ - $ 2,024,823 Total Requirements $ 14,448,571 $ - 14,448,571 Exhibit A O1CM03- Consulting Services for Multi-Agency SRO Contract Discussion Multi-agency negotiation and discussion about School Resource Officers,future role,etc.This was not part of the approved budget given quickly-moving national events and calls for Police reform and defunding.This partnership between Tigard, Tualatin and School District will produce research and feedback on the public's desire for this program and next steps in implementation. FY 2021 Q1 Revised Central Services Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,996,623 $ - $ 1,996,623 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ 11,662,196 $ - $ 11,662,196 Fines&Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ 90,000 $ - $ 90,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds S 699,752 $ 25,000 $ 724,752 Total Resources $ 14,448,571 $ 25,000 $ 14,473,571 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ 12,023,748 $ 253000 $ 12,048,748 Public Works $ - $ - $ - Program Expenditures Total $ 12,023,748 $ 25,000 $ 12,048,748 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ - $ - $ - Contingency $ 400,000 $ - $ 400,000 Total Budget $ 12,423,748 $ 25,000 $ 12,448,748 Reserve For Future Expenditure $ 2,024,823 $ - $ 2,024,823 Total Requirements $ 14,448,571 $ 25,000 $ 14,473,571 Exhibit A O1CM03- Consulting Services for Multi-Agency SRO Contract Discussion Multi-agency negotiation and discussion about School Resource Officers,future role,etc.This was not part of the approved budget given quickly-moving national events and calls for Police reform and defunding.This partnership between Tigard,Tualatin and School District will produce research and feedback on the public's desire for this program and next steps in implementation. Fund 2 of 2 FY 2021 Q1 Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance 25,980,423 $ - $ 25,980,423 Property Taxes $ 17,753,872 $ - $ 17,753,872 Franchise Fees $ 6,615,979 $ - $ 6,615,979 Special Assessments $ - $ - $ - Licenses&Permits $ 1,123,252 $ - $ 1,123,252 Intergovernmental $ 7,428,909 $ - $ 7,428,909 Charges for Services $ 253,132 $ - $ 253,132 Fines &Forfeitures $ 2,258,261 $ - $ 2,258,261 Interest Earnings $ 400,900 $ - $ 400,900 Miscellaneous $ 356,432 $ - $ 356,432 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 354,000 $ - $ 354,000 Total Resources $ 62,525,160 $ 62,525,160 Requirements Community Development $ 4,190,174 $ - $ 4,190,174 Community Services $ 26,624,316 $ - $ 26,624,316 Policy and Administration $ 1,875,705 $ - $ 1,875,705 Public Works $ - $ - $ - Program Expenditures Total $ 32,690,195 $ - $ 32,690,195 Debt Service $ - $ - $ - Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 2,673,115 $ 25,000 $ 2,698,115 Contingency $ 1,650,000 $ (25,000) $ 1,625,000 Total Budget $ 37,014,310 $ - $ 37,014,310 Reserve For Future Expenditure $ 25,510,850 $ - $ 25,510,850 Total Requirements $ 62,525,160 $ - $ 62,525,160 Exhibit A Q1CM04 -Public Safety Advisory Board Management Analyst-1.00 FTE Requesting 1.00 FTE in the City Manager's Office.The position,a Management Analyst,would provide additional capacity to help implement several new and existing initiatives,some of which were unanticipated when the FY 2020-2021 budget was prepared. As the city continues to grow and as we work actively to address Council priorities and community needs,the City Manager's Office has remained a lean operation:staffing levels have remained the same though roles and responsibilities have evolved.The additional capacity provided by the Management Analyst would address immediate needs, help with implementation and continued process improvements throughout the city.This request is prorated for 8 months. FY 2021 Q1 Revised Central Services Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,996,623 $ - $ 1,996,623 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ 11,662,196 $ - $ 11,662,196 Fines&Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ 90,000 $ - $ 90,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 699,752 $ - $ 699,752 Total Resources $ 14,448,571 $ - $ 14,448,571 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ 12,023,748 $ 77,000 $ 12,100,748 Public Works $ - $ - $ - Program Expenditures Total $ 12,023,748 $ 77,000 $ 12,100,748 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ - $ - $ - Contingency $ 400,000 $ (77,000) $ 323,000 Total Budget $ 12,423,748 $ - $ 12,423,748 Reserve For Future Expenditure $ 2,024,823 $ - $ 2,024,823 Total Requirements $ 14,448,571 $ - $ 14,448,571 Exhibit A Q1CM05-Insurance Premium Increase FY21 Liability insurance premium final cost came in higher than anticipated due to high cost losses. Insurance Premium is calculated in large part based on the expected exposures which change over time.We did not have final costs until May,which was well after budgets closed.With increased liability claim reserves,we are seeing a commensurate increase in the insurance premium.That cost above budgeted is just under$85,000. FY 2021 Q1 Revised Central Services Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,996,623 $ - $ 1,996,623 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ 11,662,196 $ - $ 11,662,196 Fines&Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ 90,000 $ - $ 90,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 699,752 $ - $ 699,752 Total Resources $ 14,448,571 $ $ 14,448,571 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ 12,023,748 $ 85,000 $ 12,108,748 Public Works $ - $ - $ - Program Expenditures Total $ 12,023,748 $ 85,000 $ 12,108,748 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ - $ - $ - Contingency $ 400,000 $ (85,000) $ 315,000 Total Budget $ 12,423,748 $ - $ 12,423,748 Reserve For Future Expenditure $ 2,024,823 $ - $ 2,024,823 Total Requirements $ 14,448,571 $ 14,448,571 Exhibit A QlFIS01-Payroll Specialist-Add 1.00 FTE Requesting to increase 1.00 FTE in Financial Operations for a Payroll Specialist in order to appropriately fulfill the needs of payroll. A more common ratio of payroll staff to employees for a local government is one payroll person (1.00 FTE)to 250 employees,given that the city does in-house payroll and the payroll function includes providing many reports and reconciliations related to benefits,taxes, etc. This request is prorated for 8 months. FY 2021 Q1 Revised Central Services Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,996,623 $ - $ 1,996,623 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ 11,662,196 $ - $ 11,662,196 Fines&Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ 90,000 $ - $ 90,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 699,752 $ - $ 699,752 Total Resources $ 14,448,571 $ $ 14,448,571 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ 12,023,748 $ 64,000 $ 12,087,748 Public Works $ - $ - $ - Program Expenditures Total $ 12,023,748 $ 64,000 $ 12,087,748 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ - $ - $ - Contingency $ 400,000 $ (64,000) $ 336,000 Total Budget $ 12,423,748 $ - $ 12,423,748 Reserve For Future Expenditure $ 2,024,823 $ - $ 2,024,823 Total Requirements $ 14,448,571 $ - 14,448,571 Exhibit A Q1FIS02- St.Vincent De Paul Additional Contribution Expansion/Extension of the St.Vincent De Paul water customer financial assistance program coordination. FY 2021 Q1 Revised Water Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 38,694,831 $ - $ 38,694,831 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ 170,000 $ - $ 170,000 Intergovernmental $ - $ - $ - Charges for Services $ 22,738,411 $ - $ 22,738,411 Fines&Forfeitures $ - $ - $ - Interest Earnings $ 500,700 $ - $ 500,700 Miscellaneous $ 50,000 $ - $ 50,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 62,153,942 $ - $ 62,153,942 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 10,361,223 $ 50,000 $ 10,411,223 Program Expenditures Total $ 10,361,223 $ 50,000 $ 10,411,223 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 23,067,947 $ - $ 23,067,947 Contingency $ 475,000 $ (50,000) $ 425,000 Total Budget $ 33,904,170 $ - $ 33,904,170 Reserve For Future Expenditure $ 28,249,772 $ - $ 28,249,772 Total Requirements $ 62,153,942 $ - $ 62,153,942 Exhibit A Q1FIS03 - Indirect Cost Allocation Adjustments Various budget correction entries for indirect cost allocations,primary one being the reclass of UB cost allocation to Street Maintanace Fund from Street Maintenance Division in Gas Tax Fund. Fund 1 of 3 FY 2021 Q1 Revised Gas Tax Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 2,577,010 $ - $ 2,577,010 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ 65,965 $ - $ 65,965 Intergovernmental $ 4,915,000 $ - $ 4,915,000 Charges for Services $ - $ - $ - Fines&Forfeitures $ - $ - $ - Interest Earnings $ 82,400 $ - $ 82,400 Miscellaneous $ 62,818 $ - $ 62,818 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 226,000 $ - $ 226,000 Total Resources $ 7,929,193 $ - $ 7,929,193 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 3,576,621 $ (150,067) $ 3,426,554 Program Expenditures Total $ 3,576,621 $ (150,067) $ 3,426,554 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 1,196,946 $ - $ 1,196,946 Contingency $ 200,000 $ - $ 200,000 Total Budget $ 4,973,567 $ (150,067) $ 4,823,500 Reserve For Future Expenditure $ 2,955,626 $ 150,067 $ 3,105,693 Total Requirements $ 7,929,193 $ - $ 7,929,193 Exhibit A Q1FIS03 - Indirect Cost Allocation Adjustments Various budget correction entries for indirect cost allocations, primary one being the reclass of UB cost allocation to Street Maintanace Fund from Street Maintenance Division in Gas Tax Fund. FY 2021 Q1 Revised Street Maintenance Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 2,243,376 $ - $ 2,243,376 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ 3,109,600 $ - $ 3,109,600 Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines&Forfeitures $ - $ - $ - Interest Earnings $ 30,100 $ - $ 30,100 Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 5,383,076 $ - $ 5,383,076 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 2,740,000 $ - $ 2,740,000 Transfers to Other Funds $ 235,230 $ 150,067 $ 385,297 Contingency $ 100,000 $ (100,000) $ - Total Budget $ 3,075,230 $ 50,067 $ 3,125,297 Reserve For Future Expenditure $ 2,307,846 $ (50,067) $ 2,257,779 Total Requirements $ 5,383,076 $ - $ 5,383,076 Exhibit A Q1FIS03-Indirect Cost Allocation Adjustments Various budget correction entries for indirect cost allocations,primary one being the reclass of UB cost allocation to Street Maintanace Fund from Street Maintenance Division in Gas Tax Fund. Fund 3 of 3 FY 2021 Q1 Revised Central Services Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,996,623 $ - $ 1,996,623 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ 11,662,196 $ (150,067) $ 11,512,129 Fines&Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - N iscellaneous $ 90,000 $ - $ 90,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 699,752 $ 150,067 $ 849,819 now Total Resources $ 14,448,571 $ 14,448,571 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ 12,023,748 $ - $ 12,023,748 Public Works $ - $ - $ - Program Expenditures Total $ 12,023,748 $ - $ 12,023,748 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ - $ - $ - Contingency $ 400,000 $ - $ 400,000 Total Budget $ 12,423,748 $ - $ 12,423,748 Reserve For Future Expenditure $ 2,024,823 $ - $ 2,024,823 Total Requirements $ 14,448,571 $ $ 14,448,571 Exhibit A Q1PD01-Police Equipment Carryforward of Forfeiture Fund purchases ordered in FY 2020 but not received by June 30, 2020. •Treasury-$15,000. Police equipment purchases •Justice-$11,000. Night vision binoculars for TNT officer. • Local-$1,150. Office Furnitures. FY 2021 Q1 Revised Criminal Forfeiture Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 185,156 $ 27,150 $ 212,306 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines&Forfeitures $ 101,371 $ - $ 101,371 Interest Earnings $ - $ - $ - N iscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 286,527 $ 27,150 $ 313,677 Requirements Community Development $ - $ - $ - Community Services $ 277,246 $ 27,150 $ 304,396 Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ 277,246 $ 27,150 $ 304,396 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 15 $ - $ 1 Contingency $ - $ - $ - Total Budget $ 277,261 $ 27,150 $ 304,411 Reserve For Future Expenditure $ 9,266 $ - $ 9,266 Total Requirements $ 286,527 $ 27,150 $ 313,677 Exhibit A Q1PD02 -Parking lot security ub�rades The Police Department, in collaboration with Facilities, is in the process of scoping out security upgrades to the Police parking lot.The current parking lot is not secure. It is partially enclosed with a chain-link fence across the north and east borders but is open along the west and south.This configuration allows the public easy access to patrol vehicles as well as Police staff and personal vehicles. Based on the recommendations from the CIS parking lot security assessment and sensitive criminal justice data security concerns raised by the GIS audit,the preliminary scope includes installing fencing and automatic gates on the west side and south of the parking lot to enclose city property from the Fanno Creek trail system.The gates will have sensors to allow Police vehicles to'auto'open the gates. The scope also includes a secure personnel door and access panel.The existing and new fencing will have privacy slats installed. FY 2021 Q1 Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 25,980,423 $ - $ 25,980,423 Property Taxes $ 17,753,872 $ - $ 17,753,872 Franchise Fees $ 6,615,979 $ - $ 6,615,979 Special Assessments $ - $ - $ - Licenses &Permits $ 1,123,252 $ - $ 1,123,252 Intergovernmental $ 7,428,909 $ - $ 7,428,909 Charges for Services $ 253,132 $ - $ 253,132 Fines&Forfeitures $ 2,258,261 $ - $ 2,258,261 Interest Earnings $ 400,900 $ - $ 400,900 Miscellaneous $ 356,432 $ - $ 356,432 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 354,000 $ - $ 354,000 Total Resources $ 62,525,160 $ - $ 62,525,160 Requirements Community Development $ 4,190,174 $ - $ 4,190,174 Community Services $ 26,624,316 $ 170,000 $ 26,794,316 Policy and Administration $ 1,875,705 $ - $ 1,875,705 Public Works $ - $ - $ - Program Expenditures Total $ 32,690,195 $ 170,000 $ 32,860,195 Debt Service $ - $ - $ - Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 2,673,115 $ - $ 2,673,115 Contingency $ 1,650,000 $ (170,000) $ 1,480,000 Total Budget $ 37,014,310 $ - $ 37,014,310 Reserve For Future Expenditure $ 25,510,850 $ - $ 25,510,850 Total Requirements $ 62,525,160 $ - $ 62,525,160 Exhibit A Q1PD03-Police Vehicle outfitting As per Fleet,three(3)of the police vehicles purchased in FY 2019-20 were received so late in the fiscal year that they could not be scheduled for vehicle outfitting until August 2020.Outfitting includes the installation and labor for items such as wiring for a police radio, light bar, PIT bar,and secure custody area. Funding is not available in the current fiscal year for these installations;we request carryforward funds from the prior year to cover the estimated costs. FY 2021 Q1 Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 25,980,423 $ 12,000 $ 25,992,423 Property Taxes $ 17,753,872 $ - $ 17,753,872 Franchise Fees $ 6,615,979 $ - $ 6,615,979 Special Assessments $ - $ - $ - Licenses &Permits $ 1,123,252 $ - $ 1,123,252 Intergovernmental $ 7,428,909 $ - $ 7,428,909 Charges for Services $ 253,132 $ - $ 253,132 Fines&Forfeitures $ 2,258,261 $ - $ 2,258,261 Interest Earnings $ 400,900 $ - $ 400,900 Miscellaneous $ 356,432 $ - $ 356,432 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 354,000 $ - $ 354,000 Total Resources $ 62,525,160 $ 12,000 $ 62,537,160 Requirements Community Development $ 4,190,174 $ - $ 4,190,174 Community Services $ 26,624,316 $ 12,000 $ 26,636,316 Policy and Administration $ 1,875,705 $ - $ 1,875,705 Public Works $ - $ - $ - Program Expenditures Total $ 32,690,195 $ 12,000 $ 32,702,195 Debt Service $ - $ - $ - Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 2,673,115 $ - $ 2,673,115 Contingency $ 1,650,000 $ - $ 1,650,000 Total Budget $ 37,014,310 $ 12,000 $ 37,026,310 Reserve For Future Expenditure $ 25,510,850 $ - $ 25,510,850 Total Requirements $ 62,525,160 $ 12,000 $ 62,537,160 Exhibit A Q1PW01-Hi-Tor Generator Roll Over The city needs to replace the generator at Hi-Tor Reservoir as the current one is old and finding parts has become very difficult. The work was planned to be completed last fiscal year but delays in getting the replacement generator, due to the plant closures for some period of time, has caused the need for this carryforward. FY 2021 Q1 Revised Water Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 38,694,831 $ 68,310 $ 38,763,141 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ 170,000 $ - $ 170,000 Intergovernmental $ - $ - $ - Charges for Services $ 22,738,411 $ - $ 22,738,411 Fines&Forfeitures $ - $ - $ - Interest Earnings $ 500,700 $ - $ 500,700 Miscellaneous $ 50,000 $ - $ 50,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 62,153,942 $ 68,310 $ 62,222,252 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 10,361,223 $ 68,310 $ 10,429,533 Program Expenditures Total $ 10,361,223 $ 68,310 $ 10,429,533 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 23,067,947 $ - $ 23,067,947 Contingency $ 475,000 $ - $ 475,000 Total Budget $ 33,904,170 $ 68,310 $ 33,972,480 Reserve For Future Expenditure $ 28,249,772 $ - $ 28,249,772 Total Requirements $ 62,153,942 $ 68,310 $ 62,222,252 Exhibit A Q1PW02- Right-of-Way Mowing-Additional Locations Added to the Contract Additional right-of-way mowing locations were added to the city's previous contract for the service. This action, combined with a contract amendment will make the service whole. FY 2021 Q1 Revised Gas Tax Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 2,577,010 $ - $ 2,577,010 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ 65,965 $ - $ 65,965 Intergovernmental $ 4,915,000 $ - $ 4,915,000 Charges for Services $ - $ - $ - Fines&Forfeitures $ - $ - $ - Interest Earnings $ 82,400 $ - $ 82,400 Miscellaneous $ 62,818 $ - $ 62,818 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 226,000 $ - $ 226,000 Total Resources $ 7,929,193 $ - $ 7,929,193 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 3,576,621 $ 25,000 $ 3,601,621 Program Expenditures Total $ 3,576,621 $ 25,000 $ 3,601,621 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 1,196,946 $ - $ 1,196,946 Contingency $ 200,000 $ (25,000) $ 175,000 Total Budget $ 4,973,567 $ - $ 4,973,567 Reserve For Future Expenditure $ 2,955,626 $ - $ 2,955,626 Total Requirements $ 7,929,193 $ - 7,929,193 Exhibit A Q1PW03 - CIP - 95063 Transportation System Plan Update Carryforward of$79,500 from prior year appropriations impacting the Transportation SDC Fund.The project was funded by Gas Tax Fund initially, but has been moved to Transportation SDC.The project start was delayed because of the bidding and negotiations with consultant took longer than anticipated. In addition to the carryforward, there is a new ask of$48,000 impacting Transportation SDC Fund.This was due to the consultant contract coming in higher than anticipated and a portion of the project going toward the Hall Boulevard Jurisdictional Transfer Study, which was outside of the original project scope. Fund 1 of 2 FY 2021 Q1 Revised Transportation SDC Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 8,225,538 $ 79,500 $ 8,305,038 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses & Permits $ 701,855 $ - $ 701,855 Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines & Forfeitures $ - $ - $ - Interest Earnings $ 144,000 $ - $ 144,000 Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 9,071,393 $ 79,500 $ 9,150,893 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 $ 3,428,362 $ 127,500 $ 3,555,862 Contingency $ - $ - $ - Total Budget $ 3,428,362 $ 127,500 $ 3,555,862 Reserve For Future Expenditure $ 5,643,031 $ (48,000) $ 5,595,031 Total Requirements $ 9,071,393 $ 79,500 $ 9,150,893 Exhibit A Q1PW03 - CIP - 95063 Transportation System Plan Update Carryforward of$79,500 from prior year appropriations impacting the Transportation SDC Fund.The project was funded by Gas Tax Fund initially, but has been moved to Transportation SDC.The project start was delayed because of the bidding and negotiations with consultant took longer than anticipated. In addition to the carryforward,there is a new ask of$48,000 impacting Transportation SDC Fund.This was due to the consultant contract coming in higher than anticipated and a portion of the project going toward the Hall Boulevard Jurisdictional Transfer Study, which was outside of the original project scope. Fund 2 of 2 FY 2021 Q1 Revised Transportation CIP Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 923,402 $ - $ 923,402 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses & Permits $ - $ - $ - Intergovernmental $ 4,253,533 $ - $ 4,253,533 Charges for Services $ - $ - $ - Fines & Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 4,827,500 $ 127,500 $ 4,955,000 Total Resources $ 10041435 $ 127,500 $ 10,131,935 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 9,081,033 $ 127,500 $ 9,208,533 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ - Total Budget $ 9,0811033 $ 127,500 $ 9,208,533 Reserve For Future Expenditure $ 923,402 $ - $ 923,402 Total Requirements $ 10,004,435 $ 127,500 $ 10,131,935 Exhibit A Q1PW04 CIP-94044 Tigard Triangle Stormwater Implementation Plan/Predesign Carryforward of$18,500 from prior year appropriations impacting the Stormwater Fund. IGA with Clean Water Services determines the project schedule. Total Project Cost remains at$180,000. FY 2021 Q1 Revised Stormwater Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 7,252,546 $ 18,500 $ 7,271,046 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ 4,044,297 $ - $ 4,044,297 Fines&Forfeitures $ - $ - $ - Interest Earnings $ 139,900 $ - $ 139,900 Miscellaneous $ 5,000 $ - $ 5,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 601,000 $ - $ 601,000 Total Resources $ 12,042,743 $ 18,500 $ 12,061,243 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 3,509,897 $ - $ 3,509,897 Program Expenditures Total $ 3,509,897 $ - $ 3,509,897 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 2,269,500 $ 18,500 $ 2,288,000 Transfers to Other Funds $ 442,866 $ - $ 442,866 Contingency $ 225,000 $ - $ 225,000 Total Budget $ 6,447,263 $ 18,500 $ 6,465,763 Reserve For Future Expenditure $ 5,595,480 $ - $ 5,595,480 Total Requirements $ 12,042,743 $ 18,500 $ 12,061,243 Exhibit A Q1PW05 CIP-97028 Tigard Triangle Parks CIP 97028 is a Tigard Triangle Capital Improvement Fund project but was duplicated in the City of Tigard CIP project list. This request will eliminate duplicated entries. FY 2021 Q1 Revised Parks Capital Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 432,919 $ - $ 432,919 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ 350,000 $ - $ 350,000 Charges for Services $ - $ - $ - Fines&Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 10,004,000 $ (3,800,000) $ 6,204,000 Total Resources $ 10,786,919 $ (3,800,000) $ 6,986,919 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 10,354,000 $ (3,800,000) $ 6,554,000 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ - Total Budget $ 10,354,000 $ (3,800,000) $ 6,554,000 Reserve For Future Expenditure $ 432,919 $ - $ 432,919 Total Requirements $ 10,786,919 $ (3,800,000) $ 6,986,919 Exhibit A Q1PW06 CIP - 91022 City Hall Remodel Carryforward of$73,500 from prior year appropriations impacting the General Fund. The construction contract was executed in the middle of May but the actual construction did not start until June. Unspent dollars need to move to FY2021 to complete the construction. Total Project Cost remains at $627,000. Fund 1 of 2 FY 2021 Q1 Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 25,980,423 $ 73,500 $ 26,053,923 Property Taxes $ 17,753,872 $ - $ 17,753,872 Franchise Fees $ 6,615,979 $ - $ 6,615,979 Special Assessments $ - $ - $ - Licenses &Permits $ 1,123,252 $ - $ 1,123,252 Intergovernmental $ 7,428,909 $ - $ 7,428,909 Charges for Services $ 253,132 $ - $ 253,132 Fines &Forfeitures $ 2,258,261 $ - $ 2,258,261 Interest Earnings $ 400,900 $ - $ 400,900 Miscellaneous $ 356,432 $ - $ 356,432 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 354,000 $ - $ 354,000 Total Resources $ 62,525,160 $ 73,500 $ 62,598,660 Requirements Community Development $ 4,190,174 $ - $ 4,190,174 Community Services $ 26,624,316 $ - $ 26,624,316 Policy and Administration $ 1,875,705 $ - $ 1,875,705 Public Works $ - $ - $ - Program Expenditures Total $ 32,690,195 $ - $ 32,690,195 Debt Service $ - $ - $ - Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 2,673,115 $ 73,500 $ 2,746,615 Contingency $ 1,650,000 $ - $ 1,650,000 Total Budget $ 37,014,310 $ 73,500 $ 37,087,810 Reserve For Future Expenditure $ 25,510,850 $ - $ 25,510,850 Total Requirements $ 62,525,160 $ 73,500 $ 62,598,660 Exhibit A Q1PW06 CIP - 91022 City Hall Remodel Carryforward of$73,500 from prior year appropriations impacting the General Fund. The construction contract was executed in the middle of May but the actual construction did not start until June. Unspent dollars need to move to FY2021 to complete the construction. Total Project Cost remains at $627,000. Fund 2 of 2 FY 2021 Q1 Revised Facilities Capital Projects Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 336,071 $ - $ 336,071 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines &Forfeitures $ - $ - $ - Interest Earnings $ 18,900 $ - $ 18,900 Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 7,983,000 $ 73,500 $ 8,056,500 Total Resources $ 8,337,971 8,411,471 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 7,883,000 $ 73,500 $ 7,956,500 Transfers to Other Funds $ 42 $ - $ 42 Contingency $ 50,000 $ - $ 50,000 Total Budget $ 7,933,042 $ 73,500 $ 8,006,542 Reserve For Future Expenditure $ 404,929 $ - $ 404,929 Total Requirements $ 8,337,971 $ 73,500 $ 8,411,471 Exhibit A Q1PW07 CIP-95057 Fanno Creek Trail Alignment Study(Bonita Road to Tualatin River) Carryforward of$51,615 from prior year appropriations impacting the Parks Capital Fund. Deliverables tied to the grant(a Metro Grant)did not allow for some billings in FY2020 and require moving funding to FY2021. In addition, internals have increased slightly to allow for proper grant management.Total Project Cost has increased by$15,000 due to additional expenditures occurred in FY2020. FY 2021 Q1 Revised Transportation CIP Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 923,402 $ - $ 923,402 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ 4,253,533 $ 66,615 $ 4,320,148 Charges for Services $ - $ - $ - Fines&Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 4,827,500 $ - $ 4,827,500 Total Resources $ 10,004,435 $ 66,615 $ 10,071,050 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 9,081,033 $ 66,615 $ 9,147,648 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ - Total Budget $ 9,081,033 $ 66,615 $ 9,147,648 Reserve For Future Expenditure $ 923,402 $ - $ 923,402 Total Requirements $ 10,004,435 $ 66,615 $ 10,071,050 Exhibit A Q1PW08 CIP-95061 Wall Street /Tech Center Drive Connection Carryforward of$36,610 from prior year appropriations impacting the Transportation CIP Fund (a Metro RFFA Grant). Total Project Cost remains at$2,169,033. FY 2021 Q1 Revised Transportation CIP Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 923,402 $ - $ 923,402 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ 4,253,533 $ 36,610 $ 4,290,143 Charges for Services $ - $ - $ - Fines&Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - N iscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 4,827,500 $ - $ 4,827,500 Total Resources $ 10,004,435 $ 36,610 $ 10,041,045 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 9,081,033 $ 36,610 $ 9,117,643 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ - Total Budget $ 9,081,033 $ 36,610 $ 9,117,643 Reserve For Future Expenditure $ 923,402 $ - $ 923,402 Total Requirements $ 10,004,435 $ 36,610 $ 10,041,045 Exhibit A Q1PW09 - CIP -92062 Cook Park Softball and Baseball Infield Increase $30,000 of transfers from Transient Lodging Tax Fund due to the additional permitting requirements for the site required by the Project Manager, which have also resulted in increased permitting fees. Fund 1 of 2 FY 2021 Q1 Revised Transient Lodging Tax Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 929,327 $ - $ 929,327 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ 565,000 $ - $ 565,000 Charges for Services $ - $ - $ - Fines &Forfeitures $ - $ - $ - Interest Earnings $ 4,800 $ - $ 4,800 Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 1,499,127 $ - $ 1,499,127 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 $ 662,602 $ 30,000 $ 692,602 Contingency $ - $ - $ - Total Budget $ 662,602 $ 30,000 $ 692,602 Reserve For Future Expenditure $ 836,525 $ (30,000) $ 806,525 Total Requirements $ 1,499,127 $ - $ 1,499,127 Exhibit A Q1PW09 - CIP - 92062 Cook Park Softball and Baseball Infield Increase $30,000 of transfers from Transient Lodging Tax Fund due to the additional permitting requirements for the site required by the Project Manager, which have also resulted in increased permitting fees. Fund 2 of 2 FY 2021 Q1 Revised Parks Capital Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 432,919 $ - $ 432,919 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ 350,000 $ - $ 350,000 Charges for Services $ - $ - $ - Fines &Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 10,004,000 $ 30,000 $ 10,034,000 Total Resources $ 10,786,919 $ 30,000 $ 10,816,919 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 10,354,000 $ 30,000 $ 10,384,000 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ - Total Budget $ 10,354,000 $ 30,000 $ 10,384,000 Reserve For Future Expenditure $ 432,919 $ - $ 432,919 Total Requirements $ 10,786,919 $ 30,000 $ 10,816,919 Exhibit A Q1PW10 CIP - 92034-02 Tigard Street Heritage Plaza Outdoor Museum Carryforward of$21,000 from prior fiscal year. $10.5K from the Transient Lodging Tax Fund and $10.5K for a National Endowment for the Arts Grant. Final artists work could not be completed before the end of FY2020. Fund 1 of 2 FY 2021 Q1 Revised Transient Lodging Tax Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 929,327 $ 10,500 $ 939,827 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ 565,000 $ - $ 565,000 Charges for Services $ - $ - $ - Fines & Forfeitures $ - $ - $ - Interest Earnings $ 4,800 $ - $ 4,800 Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 1,499,127 $ 10,500 $ 1,509,627 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 $ 662,602 $ 10,500 $ 673,102 Contingency $ - $ - $ - Total Budget $ 662,602 $ 10,500 $ 673,102 Reserve For Future Expenditure $ 836,525 $ - $ 836,525 Total Requirements $ 1,499,127 $ 10,500 $ 1,509,627 Exhibit A Q1PW10 CIP - 92034-02 Tigard Street Heritage Plaza Outdoor Museum Carryforward of$21,000 from prior fiscal year. $10.5K from the Transient Lodging Tax Fund and $10.5K for a National Endowment for the Arts Grant. Final artists work could not be completed before the end of FY2020. Fund 2 of 2 FY 2021 Q1 Revised Parks Capital Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 432,919 $ - $ 432,919 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ 350,000 $ 10,500 $ 360,500 Charges for Services $ - $ - $ - Fines & Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 10,004,000 $ 10,500 $ 10,014,500 Total Resources $ 10,786,919 $ 21,000 $ 10,807,919 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 10,354,000 $ 21,000 $ 10,375,000 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ - Total Budget $ 10,3541000 $ 21,000 $ 10,375,000 Reserve For Future Expenditure $ 432,919 $ - $ 432,919 Total Requirements $ 10,786,919 $ 21,000 $ 10,807,919 Exhibit A Q1PW11 CIP - 95027 Pedestrian and Cyclist Connections Program Summer 2020 construction of RRFB signals and other crossing improvements at Tiedeman, Grant and Katherine could not be completed in June. Carryforward $130,000 of unspent appropriations from program that were tied only to the Brown Construction Contract for these crossing improvements. Fund 1 of 2 FY 2021 Q1 Revised Gas Tax Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 2,577,010 $ 130,000 $ 2,707,010 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ 65,965 $ - $ 65,965 Intergovernmental $ 4,915,000 $ - $ 4,915,000 Charges for Services $ - $ - $ - Fines &Forfeitures $ - $ - $ - Interest Earnings $ 82,400 $ - $ 82,400 Miscellaneous $ 62,818 $ - $ 62,818 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 226,000 $ - $ 226,000 Total Resources $ 7,929,193 $ 130,000 $ 8,059,193 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 3,576,621 $ - $ 3,576,621 Program Expenditures Total $ 3,576,621 $ - $ 3,576,621 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 1,196,946 $ 130,000 $ 1,326,946 Contingency $ 200,000 $ - $ 200,000 Total Budget $ 4,973,567 $ 130,000 $ 5,103,567 Reserve For Future Expenditure $ 2,955,626 $ - $ 2,955,626 Total Requirements $ 7,929,193 $ 130,000 $ 8,059,193 Exhibit A Q1PW11 CIP - 95027 Pedestrian and Cyclist Connections Program Summer 2020 construction of RRFB signals and other crossing improvements at Tiedeman, Grant and Katherine could not be completed in June. Carryforward $130,000 of unspent appropriations from program that were tied only to the Brown Construction Contract for these crossing improvements. Fund 2 of 2 FY 2021 Q1 Revised Transportation CIP Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 923,402 $ - $ 923,402 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ 4,253,533 $ - $ 4,253,533 Charges for Services $ - $ - $ - Fines &Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 4,827,500 $ 130,000 $ 4,957,500 Total Resources $ 10,004,435 $ 130,000 $ 10,134,435 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 9,081,033 $ 130,000 $ 9,211,033 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ - Total Budget $ 9,081,033 $ 130,000 $ 9,211,033 Reserve For Future Expenditure $ 923,402 $ - $ 923,402 Total Requirements $ 10,004,435 $ 130,000 $ 10,134,435 Exhibit B Total All Funds Revised version to include the General Fund Transfer portion of the Q1CM03 Supplemental Budget Request. FY 2021 Q1 Revised Total All Funds Adopted Budget Amendment Q1 Resources Beginning Fund Balance 164,457,239 $ 508,160 $ 164,965,399 Property Taxes $ 22,631,803 $ - $ 22,631,803 Franchise Fees $ 6,615,979 $ - $ 6,615,979 Special Assessments $ 50,000 $ - $ 50,000 Licenses&Permits $ 16,804,763 $ - $ 16,804,763 Intergovernmental $ 18,994,915 $ 2,652,225 $ 21,647,140 Charges for Services $ 51,140,819 $ (150,067) $ 50,990,752 Fines&Forfeitures $ 2,359,632 $ - $ 2,359,632 Interest Earnings $ 2,538,000 $ - $ 2,538,000 Miscellaneous $ 765,850 $ - $ 765,850 Other Financing Sources $ 2,500,000 $ - $ 2,500,000 Transfers In from Other Funds $ 47,797,613 $ (3,253,433) $ 44,544,180 Total Resourcc MV6,656,613 $ (243,115) $ 336,413,498 Requirements Community Development $ 6,880,179 $ 718,700 $ 7,598,879 Community Services $ 29,087,521 $ 2,137,750 $ 31,225,271 Policy and Administration $ 17,153,810 $ 331,000 $ 17,484,810 Public Works $ 31,260,924 $ (6,757) $ 31,254,167 Program Expenditures Total $ 84,382,434 $ 3,180,693 $ 87,563,127 Debt Service $ 11,221,000 $ - $ 11,221,000 Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ 44,274,533 $ (3,296,275) $ 40,978,258 Transfers to Other Funds $ 45,997,613 $ 546,567 $ 46,544,180 Contingency $ 4,000,000 $ (696,100) $ 3,303,900 Total Budget $ 189,876,580 $ (265,115) $ 189,611,465 Reserve For Future Expenditure $ 146,780,033 $ 22,000 $ 146,802,033 Total Requirements $ 336,656,613 $ (243,115) $ 336,413,498 Exhibit B General Fund Revised version to include the General Fund Transfer portion of the Q1CM03 Supplemental Budget Request. FY 2021 Revised General Fund Adopted Budget Q1CD01 Q1CD02 Q1CD03 Q1CD04 Q1CM03 Q1PD02 Q1PD03 Q1PW06 Q1 Resources Beginning Fund Balance $ 25,980,423 $ 17,500 $ - $ 71,200 $ - $ - $ - $ 12,000 $ 73,500 $ 26,154,623 Property Taxes $ 17,753,872 $ - $ $ - $ - $ - $ - $ - $ - $ 17,753,872 Franchise Fees $ 6,615,979 $ $ $ - $ - $ - $ - $ - $ - $ 6,615,979 Special Assessments $ - $ $ $ - $ - $ - $ - $ - $ - $ - Licenses&Permits $ 1,123,252 $ - $ $ - $ - $ - $ - $ - $ - $ 1,123,252 Intergovernmental $ 7,428,909 $ 260,000 $ 370,000 $ - $ 1,908,500 $ - $ - $ - $ - $ 9,967,409 Charges for Services $ 253,132 $ - $ - $ - $ - $ - $ - $ - $ - $ 253,132 Fines&Forfeitures $ 2,258,261 $ $ $ - $ - $ - $ - $ - $ - $ 2,258,261 Interest Earnings $ 400,900 $ $ $ - $ - $ - $ - $ - $ - $ 400,900 Miscellaneous $ 356,432 $ $ $ - $ - $ - $ - $ - $ - $ 356,432 Other Financing Sources $ - $ $ $ - $ - $ - $ - $ - $ - $ - Transfers In from Other Funds $ 354,000 $ $ $ - $ $ - $ - $ - $ - $ 354,000 Total Resources $ 62,525,160 $ 277,500 $ 370,000 $ 71,200 $ 1,908,500 $ JIU12,000 $ 73,500 $ 65,237,860 Requirements Community Development $ 4,190,174 $ 277,500 $ 370,000 $ 71,200 $ - $ - $ - $ - $ - $ 4,908,874 Community Services $ 26,624,316 $ - $ - $ - $ 1,928,600 $ - $ 170,000 $ 12,000 $ - $ 28,734,916 Policy and Administration $ 1,875,705 $ $ $ - $ - $ - $ - $ - $ - $ 1,875,705 Public Works $ - $ $ $ - $ - $ - $ - $ - $ - $ - Program Expenditures Total $ 32,690,195 $ 277,500 $ 370,000 $ 71,200 $ 1,928,600 $ - $ 170,000 $ 12,000 $ - $ 35,519,495 Debt Service $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Loan to TCDA $ 1,000 $ $ $ - $ - $ - $ - $ - $ - $ 1,000 Work-In-Progress $ - $ $ $ - $ - $ - $ - $ - $ - $ - Transfers to Other Funds $ 2,673,115 $ S $ - $ - $ 25,000 $ - $ - $ 73,500 $ 2,771,615 Contingency $ 1,650,000 $ S $ - $ (20,100) $ (25,000) $ (170,000) $ - $ - $ 1,434,900 Total Budget $ 37,014,310 $ 277,500 $ 370,000 $ 71,200 $ 1,908,500 $ - $ - $ 12,000 $ 73,500 $ 39,727,010 Reserve For Future Expenditure $ 25,510,850 $ - $ - $ - $ - $ - $ - $ - $ - $ 25,510,850 Total Requirements $ 62,525,160 $ 277,500 $ 370,000 $ 71,200 $ 1,908,500 $ - $ - $ 12,000 $ 73,500 $ 65,237,860 Exhibit B Gas Tax Fund FY 2021 Revised Gas Tax Fund Adopted Budget Q1FIS03 Q1PW02 Q1PW11 Q1 Resources Beginning Fund Balance $ 2,577,010 $ - $ - $ 130,000 $ 2,707,010 Property Taxes $ - $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - $ Special Assessments $ - $ - $ - $ - $ - Licenses&Permits $ 65,965 $ - $ - $ - $ 65,965 Intergovernmental $ 4,915,000 $ - $ - $ - $ 4,915,000 Charges for Services $ - $ - $ - $ - $ - Fines&Forfeitures $ - $ - $ - $ - $ - Interest Earnings $ 82,400 $ - $ - $ - $ 82,400 Miscellaneous $ 62,818 $ - $ - $ - $ 62,818 Other Financing Sources $ - $ - $ - $ $ - Transfers In from Other Funds $ 226,000 $ - $ - $ $ 226,000 Total Resources $ 7,929,193 $ - $ - $ 130,000 $ 8,059,193 Requirements Community Development $ - $ - $ - $ - $ - Community Services $ - $ - $ - $ - $ - Policy and Administration $ - $ - $ - $ - $ - Public Works $ 3,576,621 $ (150,067) $ 25,000 $ - $ 3,451,554 Program Expenditures Total $ 3,576,621 $ (150,067) $ 25,000 $ - $ 3,451,554 Debt Service $ - $ - $ - $ - $ - Loan to TCDA $ - $ - $ - $ - $ - Work-In-Progress $ - $ - $ - $ - $ - Transfers to Other Funds $ 1,196,946 $ - $ - $ 130,000 $ 1,326,946 Contingency $ 200,000 $ $ (25,000) $ - $ 175,000 Total Budget $ 4,973,567 $ (150,067) $ - $ 130,000 $ 4,953,500 Reserve For Future Expenditure $ 2,955,626 $ 150,067 $ - $ - $ 3,105,693 Total Requirements $ 7,929,193 $ - $ - I $ 130,000 $ 8,059,193 Exhibit B Transient Lodging Tax Fund FY 2021 Revised Transient Lodging Tax Fund Adopted Budget Q1PW09 Q1PW10 Q1 Resources Beginning Fund Balance 929,327 $ - 10,500 $ 939,827 Property Taxes $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - Special Assessments $ - $ - $ - $ - Licenses&Permits $ - $ - $ - $ - Intergovernmental $ 565,000 $ - $ - $ 565,000 Charges for Services $ - $ - $ - $ - Fines&Forfeitures $ - $ - $ - $ - Interest Earnings $ 4,800 $ - $ - $ 4,800 Miscellaneous $ - $ - $ - $ - Other Financing Sources $ - $ - $ - $ - Transfers In from Other Funds $ - $ - $ - $ - Total Resources $ 1,499,127 $ - 1,509,627 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 $ 662,602 $ 30,000 $ 10,500 $ 703,102 Contingency $ - $ - $ - $ - Total Budget $ 662,602 $ 30,000 $ 10,500 $ 703,102 Reserve For Future Expenditure $ 836,525 $ (30,000) $ - $ 806,525 Total Requirements $ 1,499,127 $ - $ 10,500 $ 1,509,627 Exhibit B Criminal Forfeiture Fund FY 2021 Revised Criminal Forfeiture Fund Adopted Budget Q1PD01 Q1 Resources Beginning Fund Balance $ 185,156 $ 27,150 $ 212,306 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ $ - Licenses&Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines&Forfeitures $ 101,371 $ - $ 101,371 Interest Earnings $ - $ - $ - Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 286,527 $ 27,150 $ 313,677 Requirements Community Development $ - $ - $ - Community Services $ 277,246 $ 27,150 $ 304,396 Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ 277,246 $ 27,150 $ 304,396 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 15 $ - $ 15 Contingency $ $ $ - Total Budget $ 277,261 $ 27,150 $ 304,411 Reserve For Future Expenditure $ 9,266 $ - $ 9,266 Total Requirements $ 286,527 $ 27,150 $ 313,677 Exhibit B Parks Capital Fund FY 2021 Revised Parks Capital Fund Adopted Budget Q1PW05 Q1PW09 Q1PW10 Q1 Resources Beginning Fund Balance $ 432,919 $ - $ - $ - $ 432,919 Property Taxes $ - $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - $ Special Assessments $ - $ - $ - $ - $ - Licenses&Permits $ - $ - $ - $ - $ - Intergovernmental $ 350,000 $ - $ - $ 10,500 $ 360,500 Charges for Services $ - $ - $ - $ - $ - Fines&Forfeitures $ - $ - $ - $ - $ - Interest Earnings $ - $ - $ - $ - $ - Miscellaneous $ - $ - $ - $ - $ - Other Financing Sources $ - $ - $ - $ - $ - Transfers In from Other Funds $ 10,004,000 $ (3,800,000) $ 30,000 $ 10,500 $ 6,244,500 Total Resources $ 10,786,919 $ (3,800,000) $ 30,000 $ 21,000 $ 7,037,919 Requirements Community Development $ - $ - $ - $ - $ - Community Services $ - $ - $ - $ - $ - Policy and Administration $ - $ - $ - $ - $ - Public Works $ - $ - $ - $ - $ - Program Expenditures Total $ - $ - $ - $ - $ - Debt Service $ - $ - $ - $ - $ - Loan to TCDA $ - $ - $ - $ - $ - Work-In-Progress $ 10,354,000 $ (3,800,000) $ 30,000 $ 21,000 $ 6,605,000 Transfers to Other Funds $ - $ - $ - $ - $ - Contingency $ - $ - $ - $ - $ - Total Budget $ 10,354,000 $ (3,800,000) $ 30,000 $ 21,000 $ 6,605,000 Reserve For Future Expenditure $ 432,919 $ - $ - $ - $ 432,919 Total Requirements $ 10,786,919 $ (3,800,000) $ 30,000 $ 21,000 $ 7,037,919 Exhibit B Facilities Capital Projects Fund FY 2021 Revised Facilities Capital Projects Fund Adopted Budget Q1PW06 Q1 Resources Beginning Fund Balance $ 336,071 $ - $ 336,071 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ Special Assessments $ $ - $ Licenses&Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines&Forfeitures $ - $ - $ - Interest Earnings $ 18,900 $ - $ 18,900 Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 7,983,000 $ 73,500 $ 8,056,500 Total Resources $ 8,337,971 $ 73,500 $ 8,411,471 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 7,883,000 $ 73,500 $ 7,956,500 Transfers to Other Funds $ 42 $ - $ 42 Contingency $ 50,000 $ - $ 50,000 Total Budget $ 7,933,042 $ 73,500 $ 8,006,542 Reserve For Future Expenditure $ 404,929 $ - $ 404,929 Total Requirements $ 8,337,971 $ 73,500 $ 8,411,471 Exhibit B Street Maintenance Fund FY 2021 Revised Street Maintenance Fund Adopted Budget Q1FIS03 Q1 Resources Beginning Fund Balance $ 2,243,376 $ - $ 2,243,376 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ Special Assessments $ - $ - $ - Licenses&Permits $ 3,109,600 $ - $ 3,109,600 Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines&Forfeitures $ - $ - $ - Interest Earnings $ 30,100 $ - $ 30,100 Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 5,383,076 $ - $ 5,383,076 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 2,740,000 $ - $ 2,740,000 Transfers to Other Funds $ 235,230 $ 150,067 $ 385,297 Contingency $ 100,000 $ (100,000) $ - Total Budget $ 3,075,230 $ 50,067 $ 3,125,297 Reserve For Future Expenditure $ 2,307,846 $ (50,067) $ 2,257,779 Total Requirements $ 5,383,076 $ - $ 5,383,076 Exhibit B Transportation CIP Fund FY 2021 Revised Transportation CIP Fund Adopted Budget Q1PW03 Q1PW07 Q1PW08 Q1PW11 Q1 Resources Beginning Fund Balance 923,402 $ - $ - - - 923,402 Property Taxes $ - $ - $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - $ - $ - Special Assessments $ - $ - $ - $ - $ - $ - Licenses&Permits $ - $ - $ - $ - $ - $ - Intergovernmental $ 4,253,533 $ - $ 66,615 $ 36,610 $ - $ 4,356,758 Charges for Services $ - $ - $ - $ - $ - $ - Fines&Forfeitures $ - $ - $ - $ - $ - $ - Interest Earnings $ - $ - $ - $ - $ - $ - N iscellaneous $ - $ - $ - $ - $ - $ - Other Financing Sources $ - $ - $ - $ - $ - $ - Transfers In from Other Funds $ 4,827,500 $ 127,500 $ - $ - $ 130,000 $ 5,085,000 ir Total Resources $ 66,615 $ 36,610 $ 130,000 $ 10,365,160 Requirements Community Development $ - $ - $ - $ - $ - $ - Community Services $ - $ - $ - $ - $ - $ - Policy and Administration $ - $ - $ - $ - $ - $ - Public Works $ - $ - $ - $ - $ - $ - Program Expenditures Total $ - $ - $ - $ - $ - $ - Debt Service $ - $ - $ - $ - $ - $ - Loan to TCDA $ - $ - $ - $ - $ - $ - Work-In-Progress $ 9,081,033 $ 127,500 $ 66,615 $ 36,610 $ 130,000 $ 9,441,758 Transfers to Other Funds $ - $ - $ - $ - $ - $ - Contingency $ - $ - $ - $ - $ - $ - Total Budget $ 9,081,033 $ 127,500 $ 66,615 $ 36,610 $ 130,000 $ 9,441,758 Reserve For Future Expenditure $ 923,402 $ - $ - $ - $ - $ 923,402 Total Requirements $ 10,004,435 $ 127,500 $ 66,615 $ 36,610 $ 130,000 $ 10,365,160 Exhibit B Transportation SDC Fund FY 2021 Revised Transportation SDC Fund Adopted Budget Q1PW03 Q1 Resources Beginning Fund Balance $ 8,225,538 $ 79,500 $ 8,305,038 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ $ - Licenses&Permits $ 701,855 $ - $ 701,855 Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines&Forfeitures $ - $ - $ - Interest Earnings $ 144,000 $ - $ 144,000 Miscellaneous $ - $ $ - Other Financing Sources $ $ $ - Transfers In from Other Funds $ $ $ - Total Resources $ 9,071,393 $ 79,500 $ 9,150,893 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 $ 3,428,362 $ 127,500 $ 3,555,862 Contingency $ - $ - $ - Total Budget $ 3,428,362 $ 127,500 $ 3,555,862 Reserve For Future Expenditure $ 5,643,031 $ (48,000) $ 5,595,031 Total Requirements $ 9,071,393 $ 79,500 $ 9,150,893 Exhibit B Stormwater Fund FY 2021 Revised Stormwater Fund Adopted Budget Q1PW04 Q1 Resources Beginning Fund Balance $ 7,252,546 $ 18,500 $ 7,271,046 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ 4,044,297 $ - $ 4,044,297 Fines&Forfeitures $ - $ - $ - Interest Earnings $ 139,900 $ - $ 139,900 Miscellaneous $ 5,000 $ - $ 5,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 601,000 $ - $ 601,000 Total Resources $ 12,042,743 $ 18,500 $ 12,061,243 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 3,509,897 $ - $ 3,509,897 Program Expenditures Total $ 3,509,897 $ - $ 3,509,897 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 2,269,500 $ 18,500 $ 2,288,000 Transfers to Other Funds $ 442,866 $ - $ 442,866 Contingency $ 225,000 $ - $ 225,000 Total Budget $ 6,447,263 $ 18,500 $ 6,465,763 Reserve For Future Expenditure $ 5,595,480 $ - $ 5,595,480 Total Requirements $ 12,042,743 $ 18,500 $ 12,061,243 Exhibit B Water Fund FY 2021 Revised Water Fund Adopted Budget Q1FIS02 Q1PW01 Q1 Resources Beginning Fund Balance $ 38,694,831 $ - 68,310 $ 38,763,141 Property Taxes $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - Special Assessments $ - $ - $ - $ - Licenses&Permits $ 170,000 $ - $ - $ 170,000 Intergovernmental $ - $ - $ - $ - Charges for Services $ 22,738,411 $ - $ - $ 22,738,411 Fines&Forfeitures $ - $ - $ - $ - Interest Earnings $ 500,700 $ - $ - $ 500,700 Miscellaneous $ 50,000 $ - $ - $ 50,000 Other Financing Sources $ - $ - $ - $ - Transfers In from Other Funds $ - $ - $ - $ - Total Resources $ 62,153,942 $ - $ 68,310 $ 62,222,252 Requirements Community Development $ - $ - $ - $ - Community Services $ - $ - $ - $ - Policy and Administration $ - $ - $ - $ - Public Works $ 10,361,223 $ 50,000 $ 68,310 $ 10,479,533 Program Expenditures Total $ 10,361,223 $ 50,000 $ 68,310 $ 10,479,533 Debt Service $ - $ - $ - $ - Loan to TCDA $ - $ - $ - $ - Work-In-Progress $ - $ - $ - $ - Transfers to Other Funds $ 23,067,947 $ - $ - $ 23,067,947 Contingency $ 475,000 $ (50,000) $ - $ 425,000 Total Budget $ 33,904,170 $ - $ 68,310 $ 33,972,480 Reserve For Future Expenditure $ 28,249,772 $ $ - $ 28,249,772 Total Requirements $ 62,153,942 $ - $ 68,310 $ 62,222,252 Exhibit B Central Services Fund FY 2021 Revised Central Services Fund Adopted Budget Q1CM01 Q1CM02 Q1CM03 Q1CM04 Q1CM05 Q1FIS01 Q1FIS03 Q1 Resources Beginning Fund Balance 1,996,623 $ - - $ - $ - $ - - $ 1,996,623 Property Taxes $ - $ - $ - $ - $ - $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - $ - $ - $ - $ - $ - Special Assessments $ - $ - $ - $ - $ - $ - $ - $ - $ - Licenses&Permits $ - $ - $ - $ - $ - $ - $ - $ - $ - Intergovernmental $ - $ - $ - $ - $ - $ - $ - $ - $ - Charges for Services $ 11,662,196 $ - $ - $ - $ - $ - $ - $ (150,067) $ 11,512,129 Fines&Forfeitures $ - $ - $ - $ - $ - $ - $ - $ - $ - Interest Earnings $ - $ - $ - $ - $ - $ - $ - $ - $ - Miscellaneous $ 90,000 $ - $ - $ - $ - $ - $ - $ - $ 90,000 Other Financing Sources $ - $ - $ - $ - $ - $ - $ - $ - $ - Transfers In from Other Funds $ 699,752 $ - $ - $ 25,000 $ - $ - $ - $ 150,067 $ 874,819 Total Resources $ 14,448,571 $ - $ 25,000 $ $ - $ 14,473,571 Requirements Community Development $ - $ - $ - $ - $ - $ - $ - $ - $ - Community Services $ - $ - $ - $ - $ - $ - $ - $ - $ - Policy and Administration $ 12,023,748 $ 50,000 $ 30,000 $ 25,000 $ 77,000 $ 85,000 $ 64,000 $ - $ 12,354,748 Public Works $ - $ - $ - $ - $ - $ - $ - $ - $ - Program Expenditures Total $ 12,023,748 $ 50,000 $ 30,000 $ 25,000 $ 77,000 $ 85,000 $ 64,000 $ - $ 12,354,748 Debt Service $ - $ - $ - $ - $ - $ - $ - $ - $ - Loan to TCDA $ - $ - $ - $ - $ - $ - $ - $ - $ - Work-In-Progress $ - $ - $ - $ - $ - $ - $ - $ - $ - Transfers to Other Funds $ - $ - $ - $ - $ - $ - $ - $ - $ - Contingency $ 400,000 $ (50,000) $ (30,000) $ - $ (77,000) $ (85,000) $ (64,000) $ - $ 94,000 Total Budget $ 12,423,748 $ - $ - $ 25,000 $ - $ - $ - $ - $ 12,448,748 Reserve For Future Expenditure $ 2,024,823 $ - - $ - $ - $ 2,024,823 Total Requirements $ 14,448,571 $ - $ 25,000 $ - - $ 14,473,571 Exhibit B Non-Budgetary Impact Items Q1CS01-Increase Digital Communications Coordinator FTE by 0.05 The slight FTE increase will be offset by funds that were budgeted for the Latino Festival.The event was scheduled for August but did not happen because of COVID-19. The Digital Communications Coordinator is expanding our digital presence and growing the city's connections in the Latino community.As our social media reach increases by 5%to 10%on each platform (Facebook,Instagram,and Twitter),the position is tasked with responding to more comments and responding to direct messages in a timely manner. The position is also responsible for launching`Somos Tigard'a social media page specifically for Spanish speaking members of the community. In just a couple of month,the page has gained 130 members through live chats,videos,and timely information sharing. As we continue to implement our Language Access Plan,this position is translating more documents (i.e:Mayor's Corner,Popular Annual Finance Report,and Tigard CARES information) for every department. Without the additional hours,the city will use a third-party service to translate all city documents.This will be an additional cost to departments and result in a longer turnaround time (five to 10 days) in translating documents into Spanish. Q1CS02-Increase judge FTE by 0.40 The FY 20/21 budget assumed the presiding judge would continue as a 0.25 FTE position and pro tem judges would be utilized for additional court hours. This allowed flexibility to increase hours for arraignments and trials as the court began receiving additional photo traffic enforcement cases. In July,the court began receiving photo speed citations and caseload has increased over 500%. With COVID-19 pandemic continues,the court is not allowed to have in-person hearings. Arraignments are being held by phone and trials are being held virtually. Also a court rule allows court clerks,within the rule guidelines,to help customers resolve their citations. These methods have allowed a significant number of cases to be processed during the pandemic. However,citation arraignments have been pushed into FY2021 with the hope in-person hearings will be possible.As we prepare for more on-line hearing options and eventually in-person hearings,the court would require more judicial time to process the workload. As a result,the court is requesting authorization to increase the judge's position by 0.40 FTE to 0.65 FTE. Exhibit B General Fund Revised version to include the General Fund Transfer portion of the Q1CM03 Supplemental Budget Request. FY 2021 Revised General Fund Adopted Budget Q1CD01 Q1CD02 Q1CD03 Q1CD04 Q1CM03 Q1PD02 Q1PD03 Q1PW06 Q1 Resources Beginning Fund Balance $ 25,980,423 $ 17,500 $ - $ 71,200 $ - $ - $ - $ 12,000 $ 73,500 $ 26,154,623 Property Taxes $ 17,753,872 $ - $ $ - $ - $ - $ - $ - $ - $ 17,753,872 Franchise Fees $ 6,615,979 $ $ $ - $ - $ - $ - $ - $ - $ 6,615,979 Special Assessments $ - $ $ $ - $ - $ - $ - $ - $ - $ - Licenses&Permits $ 1,123,252 $ - $ $ - $ - $ - $ - $ - $ - $ 1,123,252 Intergovernmental $ 7,428,909 $ 260,000 $ 370,000 $ - $ 1,908,500 $ - $ - $ - $ - $ 9,967,409 Charges for Services $ 253,132 $ - $ - $ - $ - $ - $ - $ - $ - $ 253,132 Fines&Forfeitures $ 2,258,261 $ $ $ - $ - $ - $ - $ - $ - $ 2,258,261 Interest Earnings $ 400,900 $ $ $ - $ - $ - $ - $ - $ - $ 400,900 Miscellaneous $ 356,432 $ $ $ - $ - $ - $ - $ - $ - $ 356,432 Other Financing Sources $ - $ $ $ - $ - $ - $ - $ - $ - $ - Transfers In from Other Funds $ 354,000 $ $ $ - $ $ - $ - $ - $ - $ 354,000 Total Resources $ 62,525,160 $ 277,500 $ 370,000 $ 71,200 $ 1,908,500 $ $ 12,000 $ 73,500 $ 65,237,860 Requirements Community Development $ 4,190,174 $ 277,500 $ 370,000 $ 71,200 $ 1,928,600 $ - $ - $ - $ - $ 6,837,474 Community Services $ 26,624,316 $ - $ - $ - $ - $ - $ 170,000 $ 12,000 $ - $ 26,806,316 Policy and Administration $ 1,875,705 $ $ $ - $ - $ - $ - $ - $ - $ 1,875,705 Public Works $ - $ $ $ - $ - $ - $ - $ - $ - $ - Program Expenditures Total $ 32,690,195 $ 277,500 $ 370,000 $ 71,200 $ 1,928,600 $ - $ 170,000 $ 12,000 $ - $ 35,519,495 Debt Service $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Loan to TCDA $ 1,000 $ $ $ - $ - $ - $ - $ - $ - $ 1,000 Work-In-Progress $ - $ $ $ - $ - $ - $ - $ - $ - $ - Transfers to Other Funds $ 2,673,115 $ S $ - $ - $ 25,000 $ - $ - $ 73,500 $ 2,771,615 Contingency $ 1,650,000 $ S $ - $ (20,100) $ (25,000) $ (170,000) $ - $ - $ 1,434,900 Total Budget $ 37,014,310 $ 277,500 $ 370,000 $ 71,200 $ 1,908,500 $ - $ - $ 12,000 $ 73,500 $ 39,727,010 Reserve For Future Expenditure $ 25,510,850 $ - $ - $ - $ - $ - $ - $ - $ - $ 25,510,850 Total Requirements $ 62,525,160 $ 277,500 $ 370,000 $ 71,200 $ 1,908,500 $ $ - $ 12,000 $ 73,500 $ 65,237,860 Exhibit B Gas Tax Fund FY 2021 Revised Gas Tax Fund Adopted Budget Q1FIS03 Q1PW02 Q1PW11 Q1 Resources Beginning Fund Balance $ 2,577,010 $ - $ - $ 130,000 $ 2,707,010 Property Taxes $ - $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - $ Special Assessments $ - $ - $ - $ - $ - Licenses&Permits $ 65,965 $ - $ - $ - $ 65,965 Intergovernmental $ 4,915,000 $ - $ - $ - $ 4,915,000 Charges for Services $ - $ - $ - $ - $ - Fines&Forfeitures $ - $ - $ - $ - $ - Interest Earnings $ 82,400 $ - $ - $ - $ 82,400 Miscellaneous $ 62,818 $ - $ - $ - $ 62,818 Other Financing Sources $ - $ - $ - $ $ - Transfers In from Other Funds $ 226,000 $ - $ - $ $ 226,000 Total Resources $ 7,929,193 $ - $ - $ 130,000 $ 8,059,193 Requirements Community Development $ - $ - $ - $ - $ - Community Services $ - $ - $ - $ - $ - Policy and Administration $ - $ - $ - $ - $ - Public Works $ 3,576,621 $ (150,067) $ 25,000 $ - $ 3,451,554 Program Expenditures Total $ 3,576,621 $ (150,067) $ 25,000 $ - $ 3,451,554 Debt Service $ - $ - $ - $ - $ - Loan to TCDA $ - $ - $ - $ - $ - Work-In-Progress $ - $ - $ - $ - $ - Transfers to Other Funds $ 1,196,946 $ - $ - $ 130,000 $ 1,326,946 Contingency $ 200,000 $ $ (25,000) $ - $ 175,000 Total Budget $ 4,973,567 $ (150,067) $ - $ 130,000 $ 4,953,500 Reserve For Future Expenditure $ 2,955,626 $ 150,067 $ - $ - $ 3,105,693 Total Requirements $ 7,929,193 $ - $ - I $ 130,000 $ 8,059,193 Exhibit B Transient Lodging Tax Fund FY 2021 Revised Transient Lodging Tax Fund Adopted Budget Q1PW09 Q1PW10 Q1 Resources Beginning Fund Balance 929,327 $ - 10,500 $ 939,827 Property Taxes $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - Special Assessments $ - $ - $ - $ - Licenses&Permits $ - $ - $ - $ - Intergovernmental $ 565,000 $ - $ - $ 565,000 Charges for Services $ - $ - $ - $ - Fines&Forfeitures $ - $ - $ - $ - Interest Earnings $ 4,800 $ - $ - $ 4,800 Miscellaneous $ - $ - $ - $ - Other Financing Sources $ - $ - $ - $ - Transfers In from Other Funds $ - $ - $ - $ - Total Resources $ 1,499,127 $ - 1,509,627 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 $ 662,602 $ 30,000 $ 10,500 $ 703,102 Contingency $ - $ - $ - $ - Total Budget $ 662,602 $ 30,000 $ 10,500 $ 703,102 Reserve For Future Expenditure $ 836,525 $ (30,000) $ - $ 806,525 Total Requirements $ 1,499,127 $ - $ 10,500 $ 1,509,627 Exhibit B Criminal Forfeiture Fund FY 2021 Revised Criminal Forfeiture Fund Adopted Budget Q1PD01 Q1 Resources Beginning Fund Balance $ 185,156 $ 27,150 $ 212,306 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ $ - Licenses&Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines&Forfeitures $ 101,371 $ - $ 101,371 Interest Earnings $ - $ - $ - Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 286,527 $ 27,150 $ 313,677 Requirements Community Development $ - $ - $ - Community Services $ 277,246 $ 27,150 $ 304,396 Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ 277,246 $ 27,150 $ 304,396 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 15 $ - $ 15 Contingency $ $ $ - Total Budget $ 277,261 $ 27,150 $ 304,411 Reserve For Future Expenditure $ 9,266 $ - $ 9,266 Total Requirements $ 286,527 $ 27,150 $ 313,677 Exhibit B Parks Capital Fund FY 2021 Revised Parks Capital Fund Adopted Budget Q1PW05 Q1PW09 Q1PW10 Q1 Resources Beginning Fund Balance $ 432,919 $ - $ - $ - $ 432,919 Property Taxes $ - $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - $ Special Assessments $ - $ - $ - $ - $ - Licenses&Permits $ - $ - $ - $ - $ - Intergovernmental $ 350,000 $ - $ - $ 10,500 $ 360,500 Charges for Services $ - $ - $ - $ - $ - Fines&Forfeitures $ - $ - $ - $ - $ - Interest Earnings $ - $ - $ - $ - $ - Miscellaneous $ - $ - $ - $ - $ - Other Financing Sources $ - $ - $ - $ - $ - Transfers In from Other Funds $ 10,004,000 $ (3,800,000) $ 30,000 $ 10,500 $ 6,244,500 Total Resources $ 10,786,919 $ (3,800,000) $ 30,000 $ 21,000 $ 7,037,919 Requirements Community Development $ - $ - $ - $ - $ - Community Services $ - $ - $ - $ - $ - Policy and Administration $ - $ - $ - $ - $ - Public Works $ - $ - $ - $ - $ - Program Expenditures Total $ - $ - $ - $ - $ - Debt Service $ - $ - $ - $ - $ - Loan to TCDA $ - $ - $ - $ - $ - Work-In-Progress $ 10,354,000 $ (3,800,000) $ 30,000 $ 21,000 $ 6,605,000 Transfers to Other Funds $ - $ - $ - $ - $ - Contingency $ - $ - $ - $ - $ - Total Budget $ 10,354,000 $ (3,800,000) $ 30,000 $ 21,000 $ 6,605,000 Reserve For Future Expenditure $ 432,919 $ - $ - $ - $ 432,919 Total Requirements $ 10,786,919 $ (3,800,000) $ 30,000 $ 21,000 $ 7,037,919 Exhibit B Facilities Capital Projects Fund FY 2021 Revised Facilities Capital Projects Fund Adopted Budget Q1PW06 Q1 Resources Beginning Fund Balance $ 336,071 $ - $ 336,071 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ Special Assessments $ $ - $ Licenses&Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines&Forfeitures $ - $ - $ - Interest Earnings $ 18,900 $ - $ 18,900 Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 7,983,000 $ 73,500 $ 8,056,500 Total Resources $ 8,337,971 $ 73,500 $ 8,411,471 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 7,883,000 $ 73,500 $ 7,956,500 Transfers to Other Funds $ 42 $ - $ 42 Contingency $ 50,000 $ - $ 50,000 Total Budget $ 7,933,042 $ 73,500 $ 8,006,542 Reserve For Future Expenditure $ 404,929 $ - $ 404,929 Total Requirements $ 8,337,971 $ 73,500 $ 8,411,471 Exhibit B Street Maintenance Fund FY 2021 Revised Street Maintenance Fund Adopted Budget Q1FIS03 Q1 Resources Beginning Fund Balance $ 2,243,376 $ - $ 2,243,376 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ Special Assessments $ - $ - $ - Licenses&Permits $ 3,109,600 $ - $ 3,109,600 Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines&Forfeitures $ - $ - $ - Interest Earnings $ 30,100 $ - $ 30,100 Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 5,383,076 $ - $ 5,383,076 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 2,740,000 $ - $ 2,740,000 Transfers to Other Funds $ 235,230 $ 150,067 $ 385,297 Contingency $ 100,000 $ (100,000) $ - Total Budget $ 3,075,230 $ 50,067 $ 3,125,297 Reserve For Future Expenditure $ 2,307,846 $ (50,067) $ 2,257,779 Total Requirements $ 5,383,076 $ - $ 5,383,076 Exhibit B Transportation CIP Fund FY 2021 Revised Transportation CIP Fund Adopted Budget Q1PW03 Q1PW07 Q1PW08 Q1PW11 Q1 Resources Beginning Fund Balance 923,402 $ - $ - - - 923,402 Property Taxes $ - $ - $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - $ - $ - Special Assessments $ - $ - $ - $ - $ - $ - Licenses&Permits $ - $ - $ - $ - $ - $ - Intergovernmental $ 4,253,533 $ - $ 66,615 $ 36,610 $ - $ 4,356,758 Charges for Services $ - $ - $ - $ - $ - $ - Fines&Forfeitures $ - $ - $ - $ - $ - $ - Interest Earnings $ - $ - $ - $ - $ - $ - N iscellaneous $ - $ - $ - $ - $ - $ - Other Financing Sources $ - $ - $ - $ - $ - $ - Transfers In from Other Funds $ 4,827,500 $ 127,500 $ - $ - $ 130,000 $ 5,085,000 ir Total Resources $ 66,615 $ 36,610 $ 130,000 $ 10,365,160 Requirements Community Development $ - $ - $ - $ - $ - $ - Community Services $ - $ - $ - $ - $ - $ - Policy and Administration $ - $ - $ - $ - $ - $ - Public Works $ - $ - $ - $ - $ - $ - Program Expenditures Total $ - $ - $ - $ - $ - $ - Debt Service $ - $ - $ - $ - $ - $ - Loan to TCDA $ - $ - $ - $ - $ - $ - Work-In-Progress $ 9,081,033 $ 127,500 $ 66,615 $ 36,610 $ 130,000 $ 9,441,758 Transfers to Other Funds $ - $ - $ - $ - $ - $ - Contingency $ - $ - $ - $ - $ - $ - Total Budget $ 9,081,033 $ 127,500 $ 66,615 $ 36,610 $ 130,000 $ 9,441,758 Reserve For Future Expenditure $ 923,402 $ - $ - $ - $ - $ 923,402 Total Requirements $ 10,004,435 $ 127,500 $ 66,615 $ 36,610 $ 130,000 $ 10,365,160 Exhibit B Transportation SDC Fund FY 2021 Revised Transportation SDC Fund Adopted Budget Q1PW03 Q1 Resources Beginning Fund Balance $ 8,225,538 $ 79,500 $ 8,305,038 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ $ - Licenses&Permits $ 701,855 $ - $ 701,855 Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines&Forfeitures $ - $ - $ - Interest Earnings $ 144,000 $ - $ 144,000 Miscellaneous $ - $ $ - Other Financing Sources $ $ $ - Transfers In from Other Funds $ $ $ - Total Resources $ 9,071,393 $ 79,500 $ 9,150,893 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 $ 3,428,362 $ 127,500 $ 3,555,862 Contingency $ - $ - $ - Total Budget $ 3,428,362 $ 127,500 $ 3,555,862 Reserve For Future Expenditure $ 5,643,031 $ (48,000) $ 5,595,031 Total Requirements $ 9,071,393 $ 79,500 $ 9,150,893 Exhibit B Stormwater Fund FY 2021 Revised Stormwater Fund Adopted Budget Q1PW04 Q1 Resources Beginning Fund Balance $ 7,252,546 $ 18,500 $ 7,271,046 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ 4,044,297 $ - $ 4,044,297 Fines&Forfeitures $ - $ - $ - Interest Earnings $ 139,900 $ - $ 139,900 Miscellaneous $ 5,000 $ - $ 5,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 601,000 $ - $ 601,000 Total Resources $ 12,042,743 $ 18,500 $ 12,061,243 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 3,509,897 $ - $ 3,509,897 Program Expenditures Total $ 3,509,897 $ - $ 3,509,897 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 2,269,500 $ 18,500 $ 2,288,000 Transfers to Other Funds $ 442,866 $ - $ 442,866 Contingency $ 225,000 $ - $ 225,000 Total Budget $ 6,447,263 $ 18,500 $ 6,465,763 Reserve For Future Expenditure $ 5,595,480 $ - $ 5,595,480 Total Requirements $ 12,042,743 $ 18,500 $ 12,061,243 Exhibit B Water Fund FY 2021 Revised Water Fund Adopted Budget Q1FIS02 Q1PW01 Q1 Resources Beginning Fund Balance $ 38,694,831 $ - 68,310 $ 38,763,141 Property Taxes $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - Special Assessments $ - $ - $ - $ - Licenses&Permits $ 170,000 $ - $ - $ 170,000 Intergovernmental $ - $ - $ - $ - Charges for Services $ 22,738,411 $ - $ - $ 22,738,411 Fines&Forfeitures $ - $ - $ - $ - Interest Earnings $ 500,700 $ - $ - $ 500,700 Miscellaneous $ 50,000 $ - $ - $ 50,000 Other Financing Sources $ - $ - $ - $ - Transfers In from Other Funds $ - $ - $ - $ - Total Resources $ 62,153,942 $ - $ 68,310 $ 62,222,252 Requirements Community Development $ - $ - $ - $ - Community Services $ - $ - $ - $ - Policy and Administration $ - $ - $ - $ - Public Works $ 10,361,223 $ 50,000 $ 68,310 $ 10,479,533 Program Expenditures Total $ 10,361,223 $ 50,000 $ 68,310 $ 10,479,533 Debt Service $ - $ - $ - $ - Loan to TCDA $ - $ - $ - $ - Work-In-Progress $ - $ - $ - $ - Transfers to Other Funds $ 23,067,947 $ - $ - $ 23,067,947 Contingency $ 475,000 $ (50,000) $ - $ 425,000 Total Budget $ 33,904,170 $ - $ 68,310 $ 33,972,480 Reserve For Future Expenditure $ 28,249,772 $ $ - $ 28,249,772 Total Requirements $ 62,153,942 $ - $ 68,310 $ 62,222,252 Exhibit B Central Services Fund FY 2021 Revised Central Services Fund Adopted Budget Q1CM01 Q1CM02 Q1CM03 Q1CM04 Q1CM05 Q1FIS01 Q1FIS03 Q1 Resources Beginning Fund Balance 1,996,623 $ - - $ - $ - $ - - $ 1,996,623 Property Taxes $ - $ - $ - $ - $ - $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - $ - $ - $ - $ - $ - Special Assessments $ - $ - $ - $ - $ - $ - $ - $ - $ - Licenses&Permits $ - $ - $ - $ - $ - $ - $ - $ - $ - Intergovernmental $ - $ - $ - $ - $ - $ - $ - $ - $ - Charges for Services $ 11,662,196 $ - $ - $ - $ - $ - $ - $ (150,067) $ 11,512,129 Fines&Forfeitures $ - $ - $ - $ - $ - $ - $ - $ - $ - Interest Earnings $ - $ - $ - $ - $ - $ - $ - $ - $ - Miscellaneous $ 90,000 $ - $ - $ - $ - $ - $ - $ - $ 90,000 Other Financing Sources $ - $ - $ - $ - $ - $ - $ - $ - $ - Transfers In from Other Funds $ 699,752 $ - $ - $ 25,000 $ - $ - $ - $ 150,067 $ 874,819 Total Resources $ 14,448,571 $ - $ 25,000 $ $ - $ 14,473,571 Requirements Community Development $ - $ - $ - $ - $ - $ - $ - $ - $ - Community Services $ - $ - $ - $ - $ - $ - $ - $ - $ - Policy and Administration $ 12,023,748 $ 50,000 $ 30,000 $ 25,000 $ 77,000 $ 85,000 $ 64,000 $ - $ 12,354,748 Public Works $ - $ - $ - $ - $ - $ - $ - $ - $ - Program Expenditures Total $ 12,023,748 $ 50,000 $ 30,000 $ 25,000 $ 77,000 $ 85,000 $ 64,000 $ - $ 12,354,748 Debt Service $ - $ - $ - $ - $ - $ - $ - $ - $ - Loan to TCDA $ - $ - $ - $ - $ - $ - $ - $ - $ - Work-In-Progress $ - $ - $ - $ - $ - $ - $ - $ - $ - Transfers to Other Funds $ - $ - $ - $ - $ - $ - $ - $ - $ - Contingency $ 400,000 $ (50,000) $ (30,000) $ - $ (77,000) $ (85,000) $ (64,000) $ - $ 94,000 Total Budget $ 12,423,748 $ - $ - $ 25,000 $ - $ - $ - $ - $ 12,448,748 Reserve For Future Expenditure $ 2,024,823 $ - - $ - $ - $ 2,024,823 Total Requirements $ 14,448,571 $ - $ 25,000 $ - - $ 14,473,571 Exhibit B Non-Budgetary Impact Items Q1CS01-Increase Digital Communications Coordinator FTE by 0.05 The slight FTE increase will be offset by funds that were budgeted for the Latino Festival.The event was scheduled for August but did not happen because of COVID-19. The Digital Communications Coordinator is expanding our digital presence and growing the city's connections in the Latino community.As our social media reach increases by 5%to 10%on each platform (Facebook,Instagram,and Twitter),the position is tasked with responding to more comments and responding to direct messages in a timely manner. The position is also responsible for launching`Somos Tigard'a social media page specifically for Spanish speaking members of the community. In just a couple of month,the page has gained 130 members through live chats,videos,and timely information sharing. As we continue to implement our Language Access Plan,this position is translating more documents (i.e:Mayor's Corner,Popular Annual Finance Report,and Tigard CARES information) for every department. Without the additional hours,the city will use a third-party service to translate all city documents.This will be an additional cost to departments and result in a longer turnaround time (five to 10 days) in translating documents into Spanish. Q1CS02-Increase judge FTE by 0.40 The FY 20/21 budget assumed the presiding judge would continue as a 0.25 FTE position and pro tem judges would be utilized for additional court hours. This allowed flexibility to increase hours for arraignments and trials as the court began receiving additional photo traffic enforcement cases. In July,the court began receiving photo speed citations and caseload has increased over 500%. With COVID-19 pandemic continues,the court is not allowed to have in-person hearings. Arraignments are being held by phone and trials are being held virtually. Also a court rule allows court clerks,within the rule guidelines,to help customers resolve their citations. These methods have allowed a significant number of cases to be processed during the pandemic. However,citation arraignments have been pushed into FY2021 with the hope in-person hearings will be possible.As we prepare for more on-line hearing options and eventually in-person hearings,the court would require more judicial time to process the workload. As a result,the court is requesting authorization to increase the judge's position by 0.40 FTE to 0.65 FTE. FY 2020-21 First Quarter Supplemental Budget Exhibit C CIP 95063 Transportation System Plan Update Tigard is required by state administrative rule to have a current transportation plan,which is typically updated every five years.The most recent transportation plan update was prepared in 2008-09.Conduct appropriate community,traffic and multi-modal transportation analysis.Prepare a draft plan, hold public meetings and hearings and obtain city council adoption of the final plan. Actuals Adopted Revised Revised Revised Revised Revised Revised through Budget Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project FY2020 FY 2021* This Change FY 2020 2022 2022 2023 2023 2024 2024 2025 2025 2026 2026 Total Internal Expenses Design and Engineering - - - - - - - - Project Management 4,500 25,000 20,000 45,000 - - - 49,500 Construction Management - - - - - - - - Total 4,500 25,000 20,000 45,000 49,500 External Expenses Public Involvement - - - - - - - - Land/Right of Way Acquisition - - - - - - - - Design and Engineering 31,000 140,000 107,500 247,500 - - - - - - 278,500 Environmental Permit Comp. - Consttnction - - - - Contingency - - Total 31,000 140,000 107,500 247,500 278,500 Total Project Expense 35,500 165,000 127,500 292,500 328,000 Revenue Funding Source 200-Gas Tax 35,500 - - - - 35,500 415-Transportation SDC 165,000 127,500 292,500 - - - - - - 292,500 Other Revenue Source - - - - - - - - Total Project Revenues 35,500 165,000 127,500 292,500 RESOLUTION NO. 20-49 Page50 FY 2020-21 First Quarter Supplemental Budget Exhibit C CIP 94044 Tigard Triangle Stormwater Implementation Plan/Predesign As identified in the Tigard Stormwater Master Plan,a regional plan for stormwater management in the Tigard Triangle is needed to support redevelopment plans for the area and to address stream erosion problems.The new lean development code for the Tigard Triangle is anticipated to work best using a regional stormwater management approach in which most of the volume of runoff generated by new and re-development would be handled in a series of floodplain restoration areas along Red Rock Creek. Using stormwater data and general storm facility location/sizing information generated in the citywide Stormwater Master Plan project,an implementation plan for regional stormwater management in the Tigard Triangle will be completed.Site-specific preliminary design for regional facilities,floodplain restoration,trail alignment,right-of-way/easement acquisition needs and storm conveyance infrastructure will be included in the plan. Actuals Adopted Revised Revised Revised Revised Revised Revised through Budget Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project FY2020 FY 2021* This Change FY 2020 2022 2022 2023 2023 2024 2024 2025 2025 2026 2026 Total Internal Expenses Design and Engineering - - - - - - - - Project Management 6,500 15,000 15,000 - - - 21,500 Construction Management - - - - - - - - Total 6,500 1 15,000 15,000 - - - - - 21,500 External Expenses Public Involvement - - - - - - - - Land/Right of Way Acquisition - - - - - - - - Design and Engineering 87,000 53,000 18,500 71,500 - - - - - - 158,500 Environmental Permit Comp. - Construction - - - - - Contingency - - - - - - - - Total 87,000 1 53,000 18,500 1 71,500 1 158,500 Total Project Expense 93,500 68,000 18,500 86,500 - - - - - - 180,000 Revenue Funding Source 510-Stormwater Fund 93,500 68,000 18,500 86,500 - - - 180,000 Other Revenue Source - - - - - - - - Total Project Revenues 93,500 68,000 18,500 86,500 180,000 RESOLUTION NO. 20-49 Page51 FY 2020-21 First Quarter Supplemental Budget Exhibit C CIP 97028 Tigard Triangle Parks Project Need:The Tigard Triangle currently has no park land.As more residents move into the Triangle area,parks and open space will be essential. Project Description:Acquire park land in the Tigard Triangle.This was ranked as a near-term priority in A New Tigard Triangle:Planning for Equitable Development Implementation Strategy. Operations and Maintenance Impact:Minor impact for low level maintenance of purchased,undeveloped lands.There will be significant impact if the park is developed. Total Project Cost:$3,800,000 Actuals Adopted Revised Revised Revised Revised Revised Revised through Budget Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project FY2020 FY 2021* This Change FY 2020 2022 2022 2023 2023 2024 2024 2025 2025 2026 2026 Total Internal Expenses Design and Engineering - - - - - - - Project Management - - - - Construction Management - - - - - - - Total - - - - - - - - External Expenses Public Involvement - - - - - - - - Land/Right of Way Acquisition 3,800,000 3,800,000 - - - - - - 3,800,000 Design and Engineering - _ _ _ _ _ _ _ Environmental Permit Comp. _ Construction - - - - - Contingency - - - - - - - - Total 3,800,000 3,800,000 3,800,000 Total Project Expense 3,800,000 3,800,000 - - - 3,800,000 Revenue Funding Source Other Revenue Source - - - - - - - - 940-Urban Renewal 3,800,000 3,800,000 - - - - - - 3,800,000 Total Project Revenues 3,800,000 3,800,000 3,800,000 RESOLUTION NO. 20-49 Page52 FY 2020-21 First Quarter Supplemental Budget Exhibit C City Hall Remodel to accommodate additional staff related to photo red light program and situate work stations within work groups for better workflow and efficiency. Actuals Adopted Revised Revised Revised Revised Revised Revised through Budget Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project FY2020 FY 2021* This Change FY 2020 2022 2022 2023 2023 2024 2024 2025 2025 2026 2026 Total Internal Expenses Design and Engineering - - - - - - - - Project Management - - - - - Construction Management - - - - - - - - Total - - - - - - - - - - - - - - - External Expenses Public Involvement - - - - - - - - Land/Right of Way Acquisition - - - - - - - - Design and Engineering - - - - - - - Environmental Permit Comp. Construction 370,500 183,000 73,500 256,500 - - - 627,000 Contingency - - - - - - - - Total 370,500 1 183,000 1 73,500 256,500 - - - - 627,000 Total Project Expense 370,500 183,000 73,500 256,500 627,000 Revenue Funding Source 100-General Fund 370,500 183,000 73,500 256,500 - - - 627,000 Other Revenue Source - - - - - - - - Total Project Revenues 370,500 183,000 73,500 256,500 627,000 RESOLUTION NO. 20-49 Page53 FY 2020-21 First Quarter Supplemental Budget Exhibit C This final section of the Fanno Creek Trail was originally envisioned as an on-street alignment on SW 74th Avenue.Subsequent review suggests the constrained width of the SW 74th right of way will not readily accommodate widening for the trail.This study will involve local stakeholders and other partners in evaluating alignment options along Fanno Creek and result in a recommended trail alignment. Actuals Adopted Revised Revised Revised Revised Revised Revised through Budget Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project FY2020 FY 2021* This Change FY 2020 2022 2022 2023 2023 2024 2024 2025 2025 2026 2026 Total Internal Expenses Design and Engineering - - - - - - - - Project Management 56,000 15,000 10,000 25,000 - - - 81,000 Construction Management - - - - - - - - Total 56,000 1 15,000 1 10,000 1 25,000 1 81,000 External Expenses Public Involvement - - - - - - - - Land/Right of Way Acquisition - - - - - - - - Design and Engineering 89,385 35,000 56,615 91,615 - - - - - - 181,000 Environmental Permit Comp. - Constmction - - - - - Contingency 10,000 10 000 - - - - - - 10,0001 Total 89,3851 45,000 1 56,615 161,6151 191,000 Total Project Expense 145,385 60,000 66,615 126,6151 1 1 1 1 1 272,000 Revenue Funding Source 415-Transportation SDC Fund 51,000 60,000 60,000 - - - 111,000 Other Revenue Source - - - - - - - - Metro-Local Dollars 94,385 66,6151 66,615 - - - - - - 161,000 Total Project Revenues 145,385 60,000 66,615 126,6151 i i 1 1 272,000 RESOLUTION NO. 20-49 Page54 FY 2020-21 First Quarter Supplemental Budget Exhibit C CIP 95061 Wall Street/Tech Center Drive Connection Completion of a street system from Tech Center Drive to SW Wall Street.The project supports development of adjacent undeveloped lands to achieve higher levels of employment.This street segment was divided off from the Hunziker Industrial Core/Wall Street project(#95047)to allow for project phasing and different funding sources. Actuals Adopted Revised Revised Revised Revised Revised Revised through Budget Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project FY2020 FY 2021* This Change FY 2020 2022 2022 2023 2023 2024 2024 2025 2025 2026 2026 Total Internal Expenses Design and Engineering - - - - - - - - Project Management 50,000 40,000 40,000 - - - 90,000 Construction Management - - - - - - - - Total 50,000 40,000 40,000 - - - - - - - 90,000 External Expenses Public Involvement - - - - - - - - Land/Right of Way Acquisition - - - - - - - - Design and Engineering 255,000 230,000 36,610 266,610 - - - - - - 521,610 Environmental Permit Comp. - Construction 1,490,000 1,490,000 - - - 1,490,000 Contingency 67,533 67,533 - - - - - - 67.533 Total 255,000 1 1,787,533 1 36,610 1 1,824,1431 1 1 1 1 1 1 1 1 1 2,079,143 Total Project Expense 305,000 1,827,533 36,610 1,864,1431111 1 1 2,169,143 Revenue Funding Source Other Revenue Source - _ _ _ _ _ _ _ RFFA -Metro 221,000 - - - - - - - 221,000 State Appropriation 84,000 36,610 36,610 - - - - - - 120,610 Total Project Revenues 305,000 36,610 36,610 341,610 RESOLUTION NO. 20-49 Page55 FY 2020-21 First Quarter Supplemental Budget Exhibit C CIP 92062 Cook Park Softball and Baseball Infield Completion of a street system from Tech Center Drive to SW Wall Street.The project supports development of adjacent undeveloped lands to achieve higher levels of employment.This street segment was divided off from the Hunziker Industrial Core/Wall Street project(#95047)to allow for project phasing and different funding sources. Actuals Adopted Revised Revised Revised Revised Revised Revised through Budget Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project FY2020 FY 2021* This Change FY 2020 2022 2022 2023 2023 2024 2024 2025 2025 2026 2026 Total Internal Expenses Design and Engineering - - - - - - - - Project Management 5,000 20,000 25,000 - - - 25,000 Construction Management - - - - - - - - Total 5,000 1 20,000 1 25,000 1 25,000 External Expenses Public Involvement - - - - - - - - Land/Right of Way Acquisition - - - - - - - - Design and Engineering 5,000 10,000 15,000 - - - - - - 15,000 Environmental Permit Comp. - Construction 340,000 340,000 - - - 340,000 Contingency 15,000 15,000 - - - - - - 15,000 Total 360,000 10,000 1 370,000 1 370,000 Total Project Expense 365,000 30,000 395,0001111 11 395,000 Revenue Funding Source 210-Transient Lodging Tax 365,000 30,000 395,000 - - - 395,000 Other Revenue Source - - - - - - - - Total Project Revenues 365,000 30,000 395,6001 i i 1 1 395,000 RESOLUTION NO. 20-49 Page56 FY 2020-21 First Quarter Supplemental Budget Exhibit C CIP 92034-02 Heritage Trail Outdoor Museum Tigard's Outdoor Musdum is a three-quarter-mile linear museum that connects a new public plaza on Main Street in Downtown Tigard to employment and housing areas.The museum will artistically interpret the history of Tigard and the surrounding region through the commn thread of rail history.The project will include four major competitively selected artworks and a series of smaller connective pieces. Actuals Adopted Revised Revised Revised Revised Revised Revised through Budget Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project FY2020 FY 2021* This Change FY 2020 2022 2022 2023 2023 2024 2024 2025 2025 2026 2026 Total Internal Expenses Design and Engineering - - - - - - - - Project Management - - - - - Construction Management - - - - - - - - Total - - - - - - - - - - - - - - - External Expenses Public Involvement - - - - - - - - Land/Right of Way Acquisition - - - - - - - - DesignandEngineering 132,000 21,000 21,000 - - - - - - 153,000 Environmental Permit Comp. - Construction - - - - - Contingency - Total 132,000 21,000 21,000 1 153,000 Total Project Expense 132,000 21,000 21,000 153,000 Revenue Funding Source 210-Transient Lodging Tax 49,327 10,500 10,500 - - - 59,827 Other Revenue Source - - - - - - - - National Endowment/Arts 47,673 10,500 10,500 - - - - - - 58,173 WACO Visitors Assoc. 35,000 - - - - - - - 35,000 Total Project Revenues 132,000 21,000 21,6001 153,000 RESOLUTION NO. 20-49 Page57 FY 2020-21 First Quarter Supplemental Budget Exhibit C Missing sections of sidewalks and bike lanes and difficult crossings are located citywide.Projects may include sidewalk/bike lane/pathway construction, crosswalk treatments and minor intersection modifications.Projects will typically cost less than$50,000.Funds from this program can also be used to cover matching funds for eligible grant projects benefitting pedestrians and cyclists. Actuals Adopted Revised Revised Revised Revised Revised Revised through Budget Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project FY2020* FY 2021* This Change FY 2020 2022 2022 2023 2023 2024 2024 2025 2025 2026 2026 Total Internal Expenses Design and Engineering - - - - - - - - Project Management 40,000 40,000 - - - 40,000 Construction Management - - - - - - - Total 40,000 40,000 - 1 40,000 External Expenses Public Involvement - - - - - - - - Land/Right of Way Acquisition _ _ _ _ _ _ _ _ Design and Engineering 50,000 50,000 - - - - - - 50,000 Environmental Permit Comp. - Construction 210,000 130,000 340,000 - - - 340,000 Contingency - - - - - - - - Total 260,000 130,000 390,000 390,000 Total Project Expense 300,000 130,000 430,000 430,000 Revenue Funding Source 200-Gas Tax 300,000 130,000 430,000 - - - 430,000 Other Revenue Source - - - - - - - - Total Project Revenues 300,000 130,000 430,000 430,000 This is a program.Actuals through prior years are not calculated.Did not include future year projected amounts RESOLUTION NO. 20-49 Page58