Loading...
TCDA Packet - 10/15/2019 City of Tigard Tigard Business Meeting—Agenda TIGARD CITY COUNCIL & TOWN CENTER DEVELOPMENT AGENCY MEETING DATE AND TIME: October 15,2019 - 6:30 p.m. Business Meeting MEETING LOCATION: City of Tigard-Town Hall- 13125 SW Hall Blvd.,Tigard,OR 97223 PUBLIC NOTICE: Anyone wishing to speak on an agenda item should sign on the appropriate sign-up sheet(s). If no sheet is available,ask to be recognized by the Mayor at the beginning of that agenda item. Citizen Communication items are asked to be two minutes or less. Longer matters can be set for a future Agenda by contacting either the Mayor or the City Manager. Times noted are estimated;it is recommended that persons interested in testifying be present by 7:15 p.m. to sign in on the testimony sign-in sheet. Business agenda items can be beard in any order after 7:30 p.m. Assistive Listening Devices are available for persons with impaired hearing and should be scheduled for Council meetings by noon on the Monday prior to the Council meeting. Please call 503-718-2419, (voice) or 503-684-2772 (TDD -Telecommunications Devices for the Deaf). Upon request,the City will also endeavor to arrange for the following services: • Qualified sign language interpreters for persons with speech or hearing impairments;and • Qualified bilingual interpreters. Since these services must be scheduled with outside service providers,it is important to allow as much lead time as possible. Please notify the City of your need by 5:00 p.m. on the Thursday preceding the meeting by calling: 503-718-2410 (voice) or 503-684-2772 (TDD -Telecommunications Devices for the Deaf). SEE ATTACHED AGENDA VIEW LIVE VIDEO STREAMING ONLINE: httr)://www.tiizard-or.gov/city hall/council meetine oho CABLE VIEWERS: The regular City Council meeting is shown live on Channel 28 at 7:30 p.m.The meeting will be rebroadcast at the following times on Channel 28: Thursday 6:00 p.m. Sunday 11:00 a.m. Friday 10:00 P.M. Monday 6:00 a.m. City of Tigard Tigard Business Meeting—Agenda TIGARD CITY COUNCIL&TOWN CENTER DEVELOPMENT AGENCY MEETING DATE AND TIME: October 15,2019 - 6:30 p.m. Business Meeting MEETING LOCATION: City of Tigard-Town Hall- 13125 SW Hall Blvd.,Tigard, OR 97223 6:30 PM 1. BUSINESS MEETING A. Call to Order B. Roll Call C. Pledge of Allegiance D. Call to Council and Staff for Non-Agenda Items 2. CITIZEN COMMUNICATION (Two Minutes or Less,Please) A. Follow-up to Previous Citizen Communication B. Citizen Communication—Sign Up Sheet 3. CONSIDER RESOLUTION ON TIGARD SOUTHWEST CORRIDOR AFFORDABLE HOUSING PREDEVELOPMENT PROJECT WORKPLAN 6:35 p.m. estimated time 4. CONSIDER APPROVAL OF AN AGREEMENT WITH METROPOLITAN LAND GROUP FOR URBAN RESERVE AREA PLANNING 6:45 p.m. estimated time 5. PUBLIC HEARING TO CONSIDER APPROVAL OF RESOLUTION FOR FIRST QUARTER SUPPLEMENTAL BUDGET 7:10 p.m. estimated time 6. PUBLIC HEARING TO CONSIDER APPROVAL OF RESOLUTION FOR THE FIRST QUARTER TOWN CENTER DEVELOPMENT AGENCY BUDGET SUPPLEMENTAL 7:35 p.m. estimated time 7. NON AGENDA ITEMS 8. EXECUTIVE SESSION: The Tigard City Council may go into Executive Session. If an Executive Session is called to order,the appropriate ORS citation will be announced identifying the applicable statute.All discussions are confidential and those present may disclose nothing from the Session. Representatives of the news media are allowed to attend Executive Sessions,as provided by ORS 192.660(4),but must not disclose any information discussed. No Executive Session may be held for the purpose of taking any final action or making any final decision. Executive Sessions are closed to the public. 9. ADJOURNMENT 7:45 p.m. estimated time AGENDA ITEM NO. 2 B - CITIZEN COMMUNICATION DATE: October 15, 2019 (Limited to 2 minutes or less,please) The Council wishes to hear from you on other issues not on the agenda and items on the agenda, but asks that you first try to resolve your concerns through staff. This is a City of Tigard public meeting, subject to the State of Oregon's public meeting and records laws. All written and oral testimony becomes part of the public record. The names and addresses ofpersons who attend or participate in City of Tigard public meetings will be included in the meeting minutes, which is a public record. NAME,ADDRESS & PHONE TOPIC STAFF Please Print CONTACTED Name: Also,please spell your name as it sounds,if it will 0 x& help the presiding officer pronounce: 0 Address (� City `j P State Zip Phone No. Name: Also,please spell your name as it sounds,if it will help the presiding officer pronounce: Address City State Zip Phone No. Name: Also,please spell your name as it sounds,if it will help the presiding officer pronounce: Address City State Zip Phone No. CITIZEN COMMUNICATION I:\ADM\CITY RECORDERS\000 City Recorder-Records Resources and Policies\CCSignup\2019\2C Citizen Communication1doc AIS-3958 3, Business Meeting Meeting Date: 10/15/2019 Length (in minutes): 10 Minutes Agenda Title: Consider Resolution on Tigard Southwest Corridor Affordable Housing Predevelopment Project Workplan Submitted By: Sean Farrelly,Community Development Item Type: Resolution Meeting Type: Council Business Meeting -Main Public Hearing: No Publication Date: Information ISSUE Consider a resolution to adopt a workplan to implement the recommendations of the Tigard Southwest Corridor Affordable Housing Predevelopment Project(Senior Center Affordable Housing.) STAFF RECOMMENDATION / ACTION REQUEST Staff recommends approval of the resolution. KEY FACTS AND INFORMATION SUMMARY In 2017,work started on the Metro Equitable Housing Planning and Development Grant- funded Tigard Southwest Corridor Affordable Housing Predevelopment Project. This work sought to address the potential impacts that the Southwest Corridor project could have on unsubsidized affordable housing in the Tigard Town Center. The first phase of the project was to engage with Tigard residents at risk of being displaced by rising rents. The City engaged Unite Oregon,a community-based organization to do door to door canvassing,and lead four community meetings. The second phase of the project was to identify an affordable housing opportunity site in proximity to a proposed SW Corridor light rail station. This phase was postponed for several months due to the uncertainty of the light rail alignment. In late 2018,staff identified the city-owned Tigard Senior Center site as a promising site to study,as it is publicly owned and near amenities like the Tigard Public Library and Fanno Creek Trail. Utilizing the grant funds, staff engaged architects,affordable housing finance specialists,and land use planners to determine if a project was feasible on the site.They determined that a building with approximately 50 units adjacent to the Senior Center in the rear parking lot area was architecturally and financially feasible.A meeting with Washington County Housing Authority staff indicated that such a project would be a good candidate for Housing Bond funding. Staff issued a Request for Information for developers.Three organizations were interviewed by a committee of stakeholders,Northwest Housing Alternatives (NHA) was selected to negotiate a development agreement. The final milestone of the Metro Equitable Housing Planning and Development Grant is for Council to consider the adoption of a workplan to "implement funding strategies and recommendations" from the Feasibility Assessment Report.The work plan is attached to the resolution. The workplan will guide and inform the development of affordable senior housing on the Tigard Senior Center site. Much of the activity will be led by NHA. The work plan indicates the City's involvement. OTHER ALTERNATIVES Council could recommend changes to the work plan. COUNCIL GOALS, POLICIES,APPROVED MASTER PLANS Tigard City Council Goals 2019-21 Goal 2: Invest and connect key areas of the city to promote economic growth and community vitality Strategy 2.2 Continue to make Downtown Tigard a place people want to be by making substantial progress on projects that attract new residential and business investment Cultivate more relationships with future developers that share our multigenerational transit-oriented development vision. Goal 3: Ensure Tigard grows and develops in a smart and inclusive manner. Strategy 3.2: Complete an Affordable Housing Plan and adopt recommended strategies to promote the development and retention of affordable housing in Tigard. Increase advocacy at the regional level for housing that is affordable, funding strategies,and consider an excise tax. Tigard Comprehensive Plan Housing Goal 10.1: Provide opportunities for a variety of housing types to meet the diverse housing needs of current and future City residents. Special Planning Areas-Downtown Goal 15.2: Facilitate the development of an urban village. Policy 6: New housing in the downtown shall provide for a range of housing types,including ownership, workforce,and affordable housing in a high-quality living environment. Tigard Strategic Plan Goal 2: Ensure development advances the vision DATES OF PREVIOUS COUNCIL CONSIDERATION August 13,2019: Receive Update on Senior Center Affordable Housing Project June 4,2019: Senior Center Affordable Senior Housing Briefing Attachments Resolution Exhibit A CITY OF TIGARD, OREGON TIGARD CITY COUNCIL RESOLUTION NO. 19- A RESOLUTION ADOPTING A WORKPLAN TO IMPLEMENT THE STRATEGIES AND RECOMMENDATIONS OF THE TIGARD SOUTHWEST CORRIDOR AFFORDABLE HOUSING PREDEVELOPMENT PROJECT WHEREAS, the City of Tigard was awarded a Metro Equitable Housing Planning and Development Grant to perform the Tigard Southwest Corridor Affordable Housing Predevelopment Project;and WHEREAS,the Tigard Southwest Corridor Affordable Housing Predevelopment Project included a Feasibility Assessment Report that analyzed the feasibility of building affordable senior housing on the Tigard Senior Center site;and WHEREAS,the City,acting on the report recommendations released a Request for Information for developers interested in building on the site;and WHEREAS, the City selected Northwest Housing Alternatives with which to negotiate a development agreement;and WHEREAS, the City has developed a work plan to guide the implementation of the project, the adoption of which is a milestone of the grant. NOW,THEREFORE,BE IT RESOLVED by the Tigard City Council that: SECTION 1: The Tigard City Council hereby adopts the work plan (Exhibit A) to guide and inform the development of affordable senior housing on the Tigard Senior Center site, which was the result of the Tigard Southwest Corridor Affordable Housing Predevelopment Project. SECTION 2: This resolution is effective immediately upon passage. PASSED: This day of 2019. Mayor-City of Tigard ATTEST: City Recorder-City of Tigard RESOLUTION NO 19- RESOLUTION NO. 19- Page 1 EXHIBIT A Senior Center Affordable Senior Housing Work Plan This is an estimate of timelines and milestones as the parties understand them as of September 23, 2019. Action Anticipated Lead City Timeline involvement Formation of Advisory Committee September 2019 NHA Advisory Committee meetings October 2019- NHA Participant March 2020 Exclusive Negotiating Agreement October 2019 City Council consideration Negotiation of Development October 2019- City and Staff/Attorneys Agreement and Lease January 2020 NHA negotiate Design Charette November 2019 NHA Participant Development Agreement/Lease January 2020 City Council Execution consideration Monitor Development Agreement January 2020- City and Review May 2022 NHA Agreement Milestones Construction Begins I April 2021 NHA Construction Concludes May 2022 NHA AIS-3972 4. Business Meeting Meeting Date: 10/15/2019 Length (in minutes): 25 Minutes Agenda Title: Consider Approval of an Agreement with Metropolitan Land Group for Urban Reserve Area Planning Prepared For: Marty Wine Submitted By: Marty Wine, City Management Item Type: Motion Requested Meeting Type: Council Business Meeting- Main Public Hearing No Newspaper Legal Ad Required?: Public Hearing Publication Date in Newspaper: Information ISSUE Will the Council authorize the City Manager to enter into an agreement with Metropolitan Land Group for Urban Reserve Area Planning? STAFF RECOMMENDATION / ACTION REQUEST Staff recommends authorizing the City Manager to sign the agreement. KEY FACTS AND INFORMATION SUMMARY City Council Goal 3 is to "Ensure Tigard grows and develops in a smart and inclusive manner." One objective says that the city will"Secure external resources to: *Accomplish all planning and outreach activities necessary to expand the City's urban growth boundary to include the South River Terrace Area. •Complete Title 11 compliance,apply to Metro for UGB expansion,and annex South River Terrace. Prepare a concept plan for West River Terrace. •The city will direct all work under this goal,which is contingent on: oAll direct,indirect and overhead costs necessary to make South River Terrace "development-ready" funded by private sector partners and/or through grants prepared at the expense of the private sector partner. oThe continuation of existing city plans and projects such that they are neither slowed nor disrupted by River Terrace planning. oThe inclusion of equitable development principles in River Terrace planning." Metropolitan Land Group (MLG) and city staff prepared an application for a Metro Urban Reserve Planning grant for Urban Reserve Area planning for River Terrace and were notified of the $300,000 grant award in July. The City and MLG representatives have been negotiating an agreement to meet the parameters of this goal. In order to ensure the concept plan is complete by June 2021,that private sector partners and grants fund the work,and that no existing staff work is disrupted,an agreement has been drafted that specifically outlines the work and each party's role in carrying it out. The agreement states the intent of both parties to work together to prepare concept plans for River Terrace South and West.The scope of work attached to the agreement describes the studies to be prepared to meet Metro's Title 11 that will allow Tigard to complete an application for UGB expansion in June 2021. The scope of work (Exhibit A) outlines specifically what each party,MLG and the City,will do to reach the point in 2021 when a UGB expansion application can be submitted. The City has prepared an estimate of time and tasks to complete the concept plan work that can be billed hourly on a time and materials basis. The intent is to spend the Metro grant funds first and then the hours of work to be completed by city staff will be billed by the hour to MLG. Based on the estimate of hours to complete the work,three city staff will need to be hired. These include a full-time Senior Planner who will be the project manager for the concept planning effort;a Senior Management Analyst in Finance&Information Services to work on the financial plan and infrastructure aspects of the concept and community plan;and a Senior Project Engineer position who will work approximately half-time on the Concept Planning effort. City Attorney services are estimated and assumed to be completed on contract.Hourly rates were estimated using the combined salary,benefits,materials and services,and indirect costs attributable to the individual staff person. Staff acknowledges that one aspect of the Council goal that cannot be met is not disrupting the work plans of senior staff(Assistant Directors and Department Directors),which is why the approach using the hourly rate was used. In this way,the costs of those staff contributing toward completing the concept plan can also be recovered. A request to authorize the funding and staff for this work is included in the first quarter supplemental budget request. OTHER ALTERNATIVES Tigard could choose to complete concept planning or fund the staffing of this work another way. Tigard could delay concept planning for a later time. COUNCIL OR TCDA GOALS, POLICIES,MASTER PLANS Council Goal 3: Ensure Tigard develops in a smart and inclusive manner. Strategy 3.1 is listed above. DATES OF PREVIOUS CONSIDERATION City Council developed 2019-21 goals in February 2019. This is the first consideration of an agreement for URA planning. Attachments MLG URA Agreement URA Planning Scope-Exhibit A Exhibit A-Cost and Hours Estimate RIVER TERRACE SOUTH and WEST URBAN GROWTH BOUNDARY EXPANSION AGREEMENT This Agreement is entered into by and between the City of Tigard, an Oregon municipal corporation ("City") and Metropolitan Land Group, LLC, an Oregon limited liability company("MLG"), individually referred to as a Party and collectively as the Parties. RECITALS WHEREAS,the Tigard City Council's adopted goals for 2019-20 includes Goal 3,which is to ensure Tigard grows and develops in a smart and inclusive manner. Strategy 3.1 of that goal further aims to: Secure external resources to: •Accomplish all planning and outreach activities necessary to expand the City's urban growth boundary to include the South River Terrace Area. Complete Title 11 compliance, apply to Metro for UGB expansion, and annex South River Terrace. • Prepare a concept plan for West River Terrace. The City will direct all work under this goal,which is contingent on: • All direct, indirect and overhead costs necessary to make South River Terrace "development-ready"funded by private sector partners and/or through grants prepared at the expense of the private sector partner. •The continuation of existing city plans and projects such that they are neither slowed nor disrupted by River Terrace planning. •The inclusion of equitable development principles in River Terrace planning. WHEREAS, MLG has an interest in the South and West River Terrace UGB expansion and is committed to providing the resources necessary for the City to perform the work, as provided by Council's goals. WHEREAS, both parties recognize that the opportunity may exist to consider and submit an application for UGB expansion that would include both South and West River Terrace. AGREEMENT NOW THEREFORE, in consideration of the mutual covenants and agreements contained herein, it is agreed by and between the Parties as follows: 1. Scope of Work. The Parties agree to perform such tasks identified on Exhibit A, attached hereto and incorporated by this reference(the "Work"). Both parties will use reasonable best efforts and good faith to effectuate this agreement in the most cost-effective manner. 2. Term. This Agreement is effective , 2019 and will remain in effect through December 31, 2024, unless terminated or amended by the Parties, as provided for in this Agreement. 3. City Responsibilities. City will: a. Determine,taking into account cost-efficiency and the cost estimates appearing on Exhibit A, all staffing and support needs to perform the Work, including the ability to hire temporary, limited duration, permanent,or contract employees; and hire and manage contractors. Costs for employees and contractors will be reimbursed by MLG for time spent on Work. The parties agree that the costs in Exhibit A are estimates only and that reimbursements will be based on actual work performed. b. Take all measures to complete the Work and each task comprising the Work in as cost- effective a manner as possible. c. Review tasks in other planning projects being conducted by City to determine whether cost-efficiencies may be achieved by completing tasks for such planning project in conjunction with the Work. d. Before seeking reimbursement from MLG for any costs, satisfy any cost associated with the Work from the funds awarded to City under the Metro 2040 grant for all costs for which such grant funds may be used. e. Provide cost breakdowns of prior monthly City costs to MLG to be reviewed at monthly project management meetings of City and MLG as described in Exhibit A,Task 1, and quarterly invoiced to MLG. Such costs shall include staff, materials,and consultants determined by City to be necessary to complete the Work. City agrees to include only the hourly staffing costs attributable to the Work as presented in Exhibit A. f. Timely submit a letter of interest and full proposal for UGB expansion for Metro's 2020- 2021 planning cycle, on deadlines to be announced by Metro. 4. MLG Responsibilities. MLG will: a. Meet in monthly project management meetings with City as outlined in Exhibit A,Task 1 to discuss the Work tasks to be completed in the upcoming month and the projected costs of such tasks, and the tasks completed in the previous month and the detailed cost breakdowns provided by City for such tasks. b. Review quarterly invoices provided by City, and reimburse City for invoiced costs within 30 days of receiving invoice (including reimbursement for City's costs in preparing the Metro 2040 grant application incurred prior to the effective date of this Agreement). MLG has no duty to reimburse City for any cost not confirmed by City to be directly attributable to the Work. c. Participate in the Work as requested by City. Notwithstanding, MLG agrees that it has no authority or control over City staff or consultants and may not direct any part of the Work, except as expressly provided in this Agreement. 5. Breach. A Party is deemed in breach of this Agreement if the Party violates any material provision of this Agreement, fails to perform an obligation required to be performed, or otherwise breaches this Agreement. The breaching Party has 14 days from the date the nonbreaching Party sends written notice to cure or reasonably commence to cure the breach. Failure to cure or make reasonable progress to cure will be grounds for termination as provided in Section 6. 6. Termination. This Agreement may be terminated as provided: a. For breach: Upon material breach of this Agreement,the aggrieved Party may seek all remedies available at law or in equity, including termination of this Agreement. b. Mutual agreement: At any time,the Parties may mutually agree to terminate this Agreement, including for any legal or policy development that indicates that a UGB expansion decision will not be made by Metro in 2021. c. UGB Decision: If Metro does not act to bring South River Terrace into the UGB in the next planning cycle (decision expected in 2021),this Agreement will terminate 30 days following such final decision by Metro, unless otherwise agreed to by the Parties. 7. Indemnification. MLG agrees to indemnify, defend, and hold harmless the City and its officers, agents, employees,and volunteers against all liability, loss, and costs arising from actions, suits, claims, or demands attributable in whole or in part to the acts or omissions of MLG. To the maximum extent permitted by law and subject to the limitations of the Oregon Tort Claims Act, ORS Chapter 30, and the Oregon Constitution, City agrees to indemnify, defend, and hold harmless MLG and its officers, agents, and employees, against all liability, loss, and costs arising from actions,suits, claims, or demands attributable in whole or in part to the acts or omissions of City. 8. Dispute Resolution. The Parties will attempt to informally resolve any dispute concerning any Party's performance or decisions under this Agreement, or regarding the terms, conditions or meaning of this Agreement. The Parties agree that in the event of an impasse in the resolution of any dispute,the issue will be submitted to the executive officers of the disputing parties for recommendation or resolution. If resolution cannot be reached, a neutral third party may be used if the Parties agree to facilitate these negotiations. 9. Amendments. Amendments to this Agreement must be made in writing and approved by all Parties. 10. No Partnership. The City and MLG are not partners orjoint venturers. Neither Party is responsible for the actions of the other. 11. Non-Assignment. This Agreement may not be assigned by any Party without written consent of the other Party. 12. Authority to Execute. The City and MLG represent that the person signing this Agreement has authority to do so and to bind their respective Party. 13. Entire Agreement. This Agreement contains the entire understanding among the Parties and supersedes any prior understandings or written or oral agreements among them. 14. Severability. Should any provision of this Agreement be rendered invalid by a court of competent jurisdiction or arbitrator with authority to render a provision invalid, it is agreed that every other part of the Agreement will remain in full force and effect. 15. Non-waiver. Failure of any Party at any time to require performance of any provision of this Agreement may not limit the Party's right to enforce the provision, nor will any waiver of any breach of any provision be a waiver of any succeeding breach of the provision,a waiver of the provision itself,or any other provisions. 16. Notices. Any notice herein required or permitted to be given will be given in writing, be effective when actually received,and may be given by hand delivery or by United States mail,postage prepaid, addressed to the Parties as follows: City of Tigard Metropolitan Land Group Attn: Marty Wine, City Manager Attn:John O'Neil 13125 SW Hall Blvd. 17933 NW Evergreen Parkway, Suite 300 Tigard,OR 97223 Beaverton, OR 97006 The Parties hereto are responsible to notify each other of changes and to keep this list current. 17. Attorney Fees. In any claim, action,suit,or proceeding involving this Agreement,the Parties will bear their own fees and costs, including attorney fees. CITY OF TIGARD METROPOLITAN LAND GROUP, LLC By: By: Name: Name: Its: Its: Exhibit A Tigard River Terrace Urban Reserve Areas Title 11 Concept Planning Scope of Work Introduction The West and South River Terrace Urban Reserve Areas (URAs) in Tigard are at the center of a significant amount of ongoing planning and development activity. Ongoing and near-term planning studies being conducted by King City and Washington County will further define the location and orientation of land uses and infrastructure on properties adjacent to these URAs. By developing concept plans for these URAs concurrent with those studies,the City of Tigard can best integrate its land use, transportation, utility, open space and other priorities with neighboring plans. This scope of work describes the anticipated tasks by both MLG (Consultant) and the City of Tigard (City) needed to conceptually plan these URAs to satisfy Metro's Title 11 criteria for new urban growth areas and to lay an appropriate foundation for successful community planning in the future. 2018 Metro Grant Application Task 1: Letters of Intent and Pre-Application Conference The consultant will prepare narrative responses for a Draft Letter of Intent (LOI) to be submitted by City of Tigard staff to Metro for the Cycle 7 2040 Planning and Development Grants program. The grant request is for funding to support concept planning efforts in the West and South River Terrace URAs. This task also includes one pre- application meeting with Metro to discuss the Draft LOI. Based on feedback from that meeting, the consultant will prepare Final LOI responses for City staff to submit to Metro. Consultant Deliverables: • Draft and final letters of intent • Pre-application conference with Metro Task 2: Full Grant Application The consultant will prepare narrative responses, a project budget, graphics for the full grant application to Metro. This task includes one round of review by City staff for comment and revision. This task assumes City staff will be responsible for entering the narrative into Metro's online grant application system. Consultant Deliverables: • Draft and final narrative responses, budget table and graphics City Staff Scope of Work.The City staff role in this task is to review the letter of intent and project budget produced by the consultant,attend the Metro pre-application meeting, and enter data into the online grant application system. Concept Planning Task 1: Project Initiation and Coordination It is assumed that this scope of work will occur over the course of a 24-month period (June 2019 through June 2021) and that project team meetings will occur once a month during this time.The consultant will prepare for and attend team meetings throughout this period. The city will prepare and manage the meetings and project schedule over this period. Consultant Deliverables: • Preparation and attendance at project team meetings Page 1-Tigard River Terrace URA Concept Plan Scope Exhibit A • Project schedule Est. Budget:$43,000 City Staff Scope of Work.The city staff role in this task assumes project kick-off together with the consultant, document review,schedule development,and 1.5-hour project team meetings once per month for 24 months (some of these meetings will include the consultant per their scope of work, some will be city staff only for project coordination).The coordination element of this task runs throughout the project through UGB application. Community Development's role in this task is to provide project oversight for an average of 10 hours/week for 24 months for the following tasks,with most tasks performed by City PM (Senior Planner in Community Development) and will involve other CD staff(such as in the project oversight task). Other city department staff will attend regular project coordination meetings. Work in this task includes: • Metro grant administration(IGA, Council approval, midterm/final report, invoicing) • Consultant contracting(RFP,Council approval,contracting, amendments) • Project management(consultant/staff coordination;contract management; project file management; project meeting logistics; project data compilation transmission, and management) • Project oversight (minimum of 1 meeting/week with PM, director, assistant director=312 hours) • PC and CC briefings(minimum of 2 briefings each) • CAC and TAC invitation,formation, and management of committee process • Finance—Sr. Management Analyst, Director and Asst. Director meeting monthly(1 hour/meeting)for Departmental coordination and it may include Revenue Manager on occasion. Sr. Management Analyst will attend the monthly project coordination meeting spending 3 hours per meeting. • Public Works—City Engineer,Assistant City Engineer, Principal Engineer and Senior Engineer meet approx. monthly for 1 hour to coordinate, and Senior Engineer to attend monthly full project coordination meetings,3 hours per meeting including travel. Task 2:Agency/Service Provider Engagement It is assumed that the consultant and city will prepare for and attend up to six meetings with regional agency/service providers over the course of the project to obtain information regarding the availability of utility services and service capacity. It is also assumed that the city will prepare for and attend at least six additional meetings with King City and Washington County. Agency consultation will include Washington County, King City, Clean Water Services, Tualatin Valley Fire& Rescue, school districts,Tigard Water District,and potentially state and federal agencies (wildlife refuge and Department of State Lands). The consultant will prepare meeting minutes from these meetings and will coordinate with the providers to obtain relevant data necessary to present findings of service capacity as noted in Task 5 of this scope of work. Deliverables: • Preparation and attendance at 12,2-hour agency and service provider meetings • Agency meeting minutes Est. Budget:$13,000 City Staff Scope of Work. Consultants will meet and gather information about service providers and availability of utility services and service capacity to produce findings of service capacity(see special studies task 5).Assumes that engagement with and information from agencies/service providers will require review by city staff for consistency of current plans and to confirm and document service capacity.City staff time is also assumed to coordinate beyond meetings.This task will likely require internal city meetings outside of consultant work with other agencies to track and manage issues that emerge in these meetings that are outside the concept planning scope. It's assumed that during the Concept Phase, issues related to King City and Washington County will need to be resolved such as future city boundaries and updating Tigard Urban Services Area Agreement and Urban Planning Area Agreements, including Page 2-Tigard River Terrace URA Concept Plan Scope Exhibit A the resolution of road alignments such as Roy Rogers Road intersections, Beef Bend Road, and alignment of Tile Flat road.Staffing assumptions include: • New Senior Planner(72 hours):Adds 6 meetings to MLG's baseline of 6 meetings for a total of 12 meetings. All additional meetings are assumed to be with King City,Washington County,or both to discuss Beef Bend Rd,Tile Flats Rd extension,and jurisdictional boundary issues.Assumes 4 hours/meeting(prep,travel time) for baseline 6 meetings and 8 hours/meeting(meeting logistics,internal coordination,travel time,follow-up tasks)for additional 6 meetings. • Existing Senior Planners (Land Use&Transportation):Assumes 20 hours total for ad hoc consultation and support for King City and Washington County meetings. • Asst CD Director(24 hours):Assumes 4 hours/meeting(prep/travel time)for additional 6 meetings with King City and Washington County • CD Director(24 hours):Assumes 4 hours/meeting(prep/travel time)for additional 6 meetings with King City and Washington County • Finance will be primarily involved in work related to coordination with other agencies. Beef Bend Road realignment is a known issue, including potential challenges with King City/County with realignment. There may be other issues. Of the 12 agency and service provider meetings,finance is estimating 2 finance staff to attend at least half with follow-up analysis and council coordination. Each meeting is estimated 2 hours plus potential travel time to equal 3 hours per meeting plus prep and post work estimate of 3 hours per meeting per person plus 8 hours for a Council item. • Public Works: Senior Engineer to prepare for,attend,and disseminate information from 6 meetings to discuss transportation, sanitary sewer,stormwater and other relevant infrastructure topics. Task 3: Preliminary Land Use Plan—South River Terrace URA Prior to completion of preliminary infrastructure plans for the South River Terrace URA, it is anticipated that an update to the plan for the South River Terrace URA portion of the West Bull Mountain Concept Plan will be required. It is anticipated that the consultant will develop up to two master plan alternatives that may derive from the West Bull Mountain Concept Plan, but that also integrate more recent land use planning efforts occurring in the project vicinity. This task assumes that two plan iterations will be developed and a single plan iteration will be selected and refined for final determination of land uses and development intensity occurring on the site. Deliverables: • Existing Conditions Plan • Two Draft Master Plan Alternatives • Final Master Plan Alternative Est. Budget:$20,000 City Staff Scope of Work. • Multiple CD staff will review consultant deliverables and meet to discuss as needed. PM will solicit and consolidate all department comments and follow-up with staff and consultant as needed. • Finance staff to attend 1 CAC meeting. Sr. Management Analyst to spend 5 hours to prepare the finance update. Senior Management Analyst to spend 10 hours on preparing analysis of commercial node in light of Tigard City Council Goal 3.3 and review/discuss market strategy with CD. Additionally, Finance Director to spend 3 hours on minor oversight time. • Public Works: Senior Engineer will provide back-up information, review and comment on documents, and coordinate with CD on scenarios, infrastructure needs/limitations/impacts and comments. Page 3-Tigard River Terrace URA Concept Plan Scope Exhibit A Task 4: Preliminary Land Use Plan—West River Terrace URA Prior to completion of preliminary infrastructure plans for the West River Terrace URA, a concept land use plan will be required for the West River Terrace URA. Using an existing conditions plan developed from available GIS data and environmental reconnaissance mapping created with this concept planning effort, the consultant will create up to three master plan alternatives for the site. It is anticipated that one alternative land use plan will be selected and refined for the purpose of final infrastructure assessments associated with the plan area. Consultant Deliverables: • Existing Conditions Plan • Three Draft Master Plan Alternatives • Final Master Plan Alternative Est. Budget:$45,000 City Staff Scope of Work. • Multiple CD staff will review consultant deliverables and meet to discuss as needed. PM will solicit and consolidate all department comments and follow-up with staff and consultant as needed. • Finance — Finance staff to attend 1 CAC meeting. Sr. Management Analyst to spend 8 hours on preparing the finance update. Senior Management Analyst to spend 40 hours on preparing analysis of commercial node in light of Tigard City Council Goal 3.3 and review/discuss market strategy with CD. Additionally, Finance Director will be involved in close oversight of the task and spending 20 hours. • Public Works: Senior Engineer will provide back-up information, review and comment on documents, and coordinate with CD on scenarios, infrastructure needs/limitations/impacts and comments. Task 5: Special Studies Task 5a. Traffic Impact Analysis — South River Terrace URA. An analysis of the transportation system will be conducted to identify public and private street connectivity needs within the planning area. The study will assess potential off-site infrastructure improvements in the study area triggered by the proposed urban growth that is attributable to trips generated from Area 6C. It is anticipated that this effort will incorporate data created by and for the King City transportation system plan update and other relevant studies, such as the Washington County Urban Reserve Transportation Study. Consultant Deliverables: • Up to 3 project team meetings • South River Terrace URA Traffic Impact Study • Internal street alignments and roadway classifications and street cross sections • Beef Bend Road alignment • Intersection treatments along study area boundaries • Pedestrian and bicycle facilities needs and locations Est. Budget:$25,800 Task 5b. Traffic Impact Analysis — West River Terrace URA. An analysis of the transportation system will be conducted to identify public and private street connectivity needs within the planning area. The study will assess potential off-site infrastructure improvements in the study area triggered by the proposed urban growth that is attributable to trips generated from Area 6C. Consultant Deliverables: Page 4-Tigard River Terrace URA Concept Plan Scope Exhibit A • Up to 3 project team meetings • West River Terrace URA Traffic Impact Study • West River Terrace URA internal street alignments and roadway classifications and street cross sections • Intersection treatments along study area boundaries • Pedestrian and bicycle facilities needs and locations Est. Budget:$35,800 Task 5c. Environmental Analysis. The consultant will conduct an assessment, including field verification and associated property access as needed, of areas qualifying for protection under Titles 3 and 13 of the Urban Growth Management Functional Plan (UGMFP) and City of Tigard Significant Tree Grove regulations. The consultant will prepare a technical memorandum with associated mapping and assessment findings. Assessment should be sufficiently detailed to avoid the need to negotiate additional property access at a later stage. Consultant Deliverables: • Technical memorandum summarizing existing conditions, analysis methods and findings for Title 3 and 13 areas within the South River Terrace URA and preliminary resource mapping for this area. • Technical memorandum summarizing existing conditions, analysis methods and findings for Title 3 and 13 areas within the West River Terrace URA and preliminary resource mapping for this area. Est. Budget:$35,800 Task 5d. Utility Master Plan Analysis. The consultant will prepare a technical memorandum that provides a summary of existing water, sanitary sewer, stormwater, parks, and private utilities in the vicinity of the URAs and will include descriptions of preliminary capital facility improvements necessary for sanitary sewer,water and stormwater service. This task assumes that additional utility analyses will be needed to properly size and route water and sewer systems and locate stormwater facilities. Systems data will also be available from utility providers and existing documents to create a composite memorandum of anticipated utility capital improvements for the West and South River Terrace URAs. Some field verification should be anticipated. Preliminary rough order of magnitude (ROM) cost estimates for these utility capital facility improvements will be included with this technical memorandum.This task assumes a single round of outside review. Consultant Deliverables: • Utility Master Plan Memorandum for the South River Terrace URA Including: o Existing Conditions Analysis—Water o Existing Conditions Analysis—Sewer o Existing Conditions Analysis—Stormwater o Existing Conditions Analysis-Parks o Preliminary Sanitary Sewer Master Plan o Preliminary Water System Master Plan o Preliminary Stormwater Master Plan o Preliminary Parks Master Plan • Utility Master Plan Memorandum for the West River Terrace URA Including: o Existing Conditions Analysis—Water o Existing Conditions Analysis—Sewer Page 5-Tigard River Terrace URA Concept Plan Scope Exhibit A o Existing Conditions Analysis—Stormwater o Existing Conditions Analysis-Parks o Preliminary Sanitary Sewer Master Plan o Preliminary Water System Master Plan o Preliminary Stormwater Master Plan o Preliminary Parks Master Plan Est. Budget:$60,800 City Staff Scope of Work. • Multiple CD staff will review consultant deliverables and meet to discuss as needed. PM will solicit and consolidate all department comments and follow-up with staff and consultant as needed. • Engineering staff assumes that additional utility modeling may be needed to determine future system capacity and that city staff will be requested to generate data about utility systems to inform the analysis for this task. See the end of this section for additional description of the work. Tigard will be undertaking the Water System Master Plan at the same time as the development of the Concept Plan and the city assumes data and modeling from that effort will inform Concept Plan. • Finance Staff to attend task-related meetings to stay informed. The information will be used to perform the future task,Task 6(funding strategy). Water/Sewer/Storm/Parks is 4X Transportation. Task 5e. Housing Market Analysis. The consultant will prepare a technical memorandum that documents how the residential development of the West and South River Terrace URAs will meet the housing needs in Tigard, Washington County and the metro area by product type and price range. The housing market analysis will consider: • The implications of current and future demographics and socioeconomic characteristics of Tigard's residents, within the regional context,for housing demand in the River Terrace area. • Market demand for a range of housing types,tenure, and price points to address the Tigard's housing needs. This analysis will include analysis of housing types built and sold in Tigard (and maybe more broadly in the west side of the Portland Region) in recent years. • Opportunities for developing a mix of housing types to address housing needs affordable both for moderate-income households, as well as housing needs for higher-income households. • Range of residential capacity in the West and South River Terrace URAs based on the analysis of unconstrained buildable land at a range of densities appropriate for Tigard. • Forecast of housing growth and absorption in the West and South River Terrace URAs to estimate potential buildout of the area. • Strategies to support development of the types of housing identified in the housing market analysis, within the broader context of the concept plan. The product will be a technical memorandum that summarizes the housing market analysis and strategies for providing a range of housing types. Consultant Deliverables: • Housing Needs Analysis Est. Budget:$20,800 Page 6-Tigard River Terrace URA Concept Plan Scope Exhibit A City Staff Scope of Work. • Coordinate work with other city housing initiatives, particularly affordable housing. • Senior Management Analyst to perform the financial Analysis of Housing Needs Analysis in light of Council Strategy 3.3 and review/discuss market strategy w/CD for 30 hours. Finance Director will be involved in close oversight of the task. City Staff Scope of Work for Tasks 3,4, 5 Preliminary Land Use Plans for South and West RT,Special Studies(Traffic Impact Analysis,Environmental Analysis,Utility Master Plan Update,Housing Market Analysis).The City staff role in these tasks are for the city PM to attend all project team meetings,and for all city staff to review consultant study findings. In this task,City staff will need to understand and make connections among every existing technical memorandum to allow for a coordinated analysis within the draft Concept Plan,and for consistency with existing city Master Plans,and neighboring jurisdiction planning efforts.Technical memoranda will form the basis to update all city infrastructure master plans (which assumes 30 Engineering staff review hours for review of each storm,water and sewer analysis and 10 Parks staff hours for the parks analysis).City staff time(primarily Public Works staff) is anticipated to collect, collate,format,and explain existing data and reports that will be needed for preparation of existing conditions and master plan reports. Because these analyses affect all of the city's existing infrastructure system plans and will further inform future infrastructure assessments,coordination with FIS forfuture infrastructure and funding studies is needed.All studies are likely to include consideration of off-site improvements related to King City and this is another task that will help complete needed updates to planning agreements required by Washington County. Hours of work for city staff in this task assume collection, collation,delivery and discussion of existing background information with consultant team. In addition,city staff hours assume review of: • All consultant deliverables (two master plan alternatives);consider adjacent land uses and conditions in context; consult with neighboring and affected jurisdictions as needed; • In Transportation tasks, Planning and Engineering staff will review the Traffic Impact Analyses in context of the existing transportation system and existing transportation plans as it relates to the area's future development. Street alignments and classifications and review draft traffic impact analysis. Planning and Engineering staff will also review and coordinate comments with Washington County and King City • For Utilities master plans, Public Works staff will review reports and underlying analyses and assumptions, coordinate comments with other agencies (e.g.CWS). • Additional meetings will be scheduled to refine consultant-generated alternatives as needed; • Environmental analysis requiring a more detailed analysis to avoid duplicate negotiations of property access in a later phase, plus mapping of Tigard Significant Tree Groves. This task will require city staff data generation. • Finance Staff to attend task related meetings to stay informed. The information will be used to perform the future task,Task 6(funding strategy). • City staff PM (Community Development)will solicit and consolidate all department comments and have follow-up conversations with consultant as needed. • Consultation with legal counsel as needed. Task 6. Funding Strategy A second technical memorandum will be prepared that will identify an Infrastructure Funding Plan for the West and South River Terrace URAs. This document will outline how infrastructure costs within these expansion areas would be paid for and identify potential public and private funding sources, and what additional systems development charge (SDC) revenues will be generated by development in the area, and available to pay for infrastructure elsewhere in the region. This memo will compile the most up-to-date estimates of costs for water, sanitary sewer, stormwater, parks and transportation capital facilities that are deemed necessary to serve the concept plan area, as determined under Page 7-Tigard River Terrace URA Concept Plan Scope Exhibit A Tasks 5a, 5b and 5d. The memo will also calculate the amount of SDC revenue that would be generated by new development in the area. It will identify what portion of the project costs would be eligible to receive SDC credits. It will explore the possibility of funding the non-SDC eligible portion of project costs with other public funding mechanisms (e.g.,supplemental SDCs, local improvement districts, utility fees, etc.), versus funding this portion of the costs through non-SDC-creditable developer contributions. Consultant Deliverables: • Funding Strategy Est. Budget:$40,000 City Staff Scope of Work. City staff work in this task assumes review of technical memoranda produced by consultants and close coordination and integration with the existing River Terrace Finance Strategy as it pertains to updating system development charges (SDC)studies,SDC credit policies and their administration, and utility fees, particularly around how these strategies have been working and whether it makes sense to replicate them or develop other or new funding options.This will require the PM,coordinated with FIS staff,to understand the financial implications of urban growth expansion development through discussions with staff across city departments. Public Works staff will review consultant cost estimates and assumptions for funding options and SDC strategies for various infrastructure. Finance Staff will work closely on the Funding Strategy. The Funding Strategy will identify potential funding sources and explore viability of funding sources. Finance Staff will coordinate with developers on viability of sources and develop funding scenarios for each infrastructure system.The staff will review and approve the compilation of capital facility estimates provided in the consultant reports and review the SDC revenue estimates,determine their sufficiency for existing and other funding mechanisms and determine the options to be prepared for concept plan consideration. Determination of preferred scenario and implementation will be done at the Community Plan phase. Task 7: Concept Plan Summary Report The consultant will compile concept plan documents and will incorporate the existing conditions and analysis sections of the technical memoranda prepared under this scope of work into a cohesive planning document. The concept plan will also address the existing conditions and planning needs of other public facilities including schools, fire, police, library and parks. These sections will be completed after coordination with representatives from these districts as conducted under Task 2 of this scope of work. Consultant Deliverables: • Draft Concept Plan Summary Report(assume 2 drafts at a minimum) • Final Concept Plan Summary Report Est. Budget:$13,000 City Staff Scope of Work. In this task,city staff will review consultant deliverables,attend meetings to discuss as needed, solicit and consolidate department comments and refine the report. City staff work in this task will rely on the draft consultant-produced reports and final technical memoranda from other tasks to be assembled into an application-ready report.The consultant work is compiled into a cohesive planning document that is substantially prepared to meet Metro submittal requirements. It is assumed that city staff will be involved in two iterations of review and comment on each deliverable and report. Task 8: Plan Adoption Process It is anticipated that the City of Tigard will prepare the staff reports necessary for local adoption of the final plan. It is also anticipated that the consultant will meet with Metro planning staff up to two times during the development of the concept plan to keep Metro staff apprised of concept plan development. Following local adoption of the concept Page 8-Tigard River Terrace URA Concept Plan Scope Exhibit A plan, the consultant will prepare a summary of the residential capacity created through the concept plan adoption consistent with a Goal 14 analysis. Per UGMFP 3.07.1120(d), this must occur"within 30 days after adoption of new land use regulations for the area." Consultant Deliverables • Prepare for and attend up to two meetings with the City Planning Commission • Prepare for and attend City Council adoption hearing(s) • Prepare for and attend up to two meetings with Metro planning staff Est. Budget:$4,000 City Staff Scope of Work. City staff work during this task includes 2 Planning Commission (PC) meetings and 1 City Council(CC) meeting. CD staff assumes 50 hours/meeting(hours assumed among multiple staff) plus 10 hours for 2 Metro meetings. PC and CC meeting preparation involves the following tasks most, but not all,of which are performed by CD staff: • Reserve PC and CC meeting dates • Prepare and route staff report for review • Prepare and route PowerPoint for review • Prepare and route resolution for review • Create Agenda Item Summary (AIS)for CC meeting • Prepare and send public notices • Respond to and manage public comment (includes discussion with other staff as needed) • Suggest changes to concept plan based on public comment as needed • Coordinate with consultant on presentations and any proposed concept plan changes • CD, Public Works, and Finance Staff will support Project Manager with the adoption process including attending Council briefings and meetings. Task 9: Public Involvement Consultant will prepare for and attend 3 public meetings over the course of the plan preparation process. The consultant assumes it will be responsible for organizing, noticing, preparing for and facilitating the meetings, which are assumed to occur in an open house format. Deliverables • Advisory Committees o Facilitate 4 Technical Advisory Committee(TAC) meetings o Facilitate 5 Community Advisory Committee (CAC) meetings • Public Meeting#1, including: o Existing Conditions GIS Exhibits(3) o Meeting Facilitation o Meeting Notice and Announcement • Public Meeting#2, including: o Preliminary Concept Plan GIS Exhibits (3) o Meeting Facilitation o Meeting Notice and Announcement • Public Meeting#3, including: Page 9-Tigard River Terrace URA Concept Plan Scope Exhibit A o Refined Concept Plan GIS Exhibits (3) o Meeting Facilitation o Meeting Notice and Announcement Est. Budget:$24,000 City Staff Scope of Work.Assumes an average of 12+hours/week for 24 months for the following tasks. Most tasks will be performed by Community Development PM and will also involve other CD staff as well,with FIS and PW- Engineering staff on call for these tasks based on the level of public inquiry about infrastructure funding or planning and development for infrastructure systems.The city's role will include: • Develop public engagement plan • Identify stakeholders and methods of communication • Develop project branding and messaging • Develop public materials, e.g. FAQs, project business cards • Develop and maintain website content • Publicize and promote meetings through city communication channels • Attend and coordinate with consultant to prepare for at least 3 public open house meetings • Attend and coordinate with consultant to prepare for at least 5 CAC meetings • Attend and coordinate with consultant to prepare for at least 4 TAC meetings • Attend and prepare for other community meetings as needed: Washington County Board of Commissioners, King City Council, CPO 46,CPO 4K, River Terrace Homeowner Associations • Respond to all public inquiries (may include discussion with other staff as needed) • Finance Staff will be addressing the expectation of a finance role in public meetings around the topic of "development supporting itself and why it doesn't." Also Finance Staff will consider communications regarding Council Strategy 3.3. Specifically, Finance will be supporting content for branding, public materials,and website(30 hours). Finance Staff to attend and prepare for all 12 meetings listed for CAC, TAC, and open houses(2 staff attend at 3 hours/meeting(including travel)plus 3 hours prep/post meeting work for both staff combined). Addressing public inquiries is estimated at 20 hours. 2021 Metro UGB Application The consultant will prepare and facilitate submittal of an application to Metro for UGB expansion.This task includes a letter of intent, resolution for City adoption,and an application narrative to address required Metro criteria. Consultant Deliverables • Letter of intent • City resolution • Application package, including narrative Est. Budget:$19,000 City Staff Scope of Work. The City staff role in this task is to review the application package, attend any meetings needed to complete the submittal. Page 10-Tigard River Terrace URA Concept Plan Scope Exhibit •. Cost Estimate 0 ConsultantTask FIS PW CD CA Grant Application Task 1:L01 and PreApp 1,480 - 1,480 Task 2:Full Grant App - - 1,480 - 1,480 Concept Planning Task 1:Project Initiation/Coordination 23,724 31,968 157,092 9,850 43,000 265,634 Task 2:Agency/Service Provider Engagemt 11,748 5,370 21,824 - 6,500 45,442 Task 3:Land Use Plan-RT South 2,424 4,296 9,060 20,000 35,780 Task 4:Land Use Plan-RT West 9,452 4,296 9,060 - 45,000 67,808 Task Sa:Traffic Impact Analysis-South 777 8,392 8,970 985 25,800 44,924 Task 5b:Traffic Impact Analysis-West 777 8,392 8,970 985 35,800 54,924 Task 5c:Environmental Analysis - 3,180 8,970 1,576 60,800 74,526 Task 5d:Utility Master Plan Analysis 3,108 65,004 14,980 1,576 115,800 200,468 Task 5e:Housing Market Analysis 6,315 2,227 8,970 1,576 20,800 39,888 Task 6:Funding Strategy 16,410 13,240 12,020 1,576 137,000 180,246 Task 7:Concept Plan Summary Report 2,812 7,834 6,010 - 13,000 29,656 Task 8:Plan Adoption Process 7,688 5,142 23,860 4,000 40,690 Task 9:Public Involvement 21,948 26,976 187,076 48,000 284,000 Metro UGB Application 2,960 10,000 12,960 Total Cost 107,1831 186,317 1 482,782 1 18,124 1 585,500 1.379,906 ConsultantEstimated Hours Grant Application Task 1:L01 and PreApp 10 - 10 Task 2:Full Grant App - - 10 - 10 Concept Planning Task 1:Project Initiation/Coordination 173 168 1,040 50 1,431 Task 2:Agency/Service Provider Engagemt 80 30 140 - 250 Task 3:Land Use Plan-RT South 18 24 60 102 Task 4:Land Use Plan-RT West 68 24 60 - 152 Task 5a:Traffic Impact Analysis-South 6 46 60 5 117 Task 5b:Traffic Impact Analysis-West 6 46 60 5 117 Task 5c:Environmental Analysis - 17 60 8 85 Task 5d:Utility Master Plan Analysis 24 348 100 8 480 Task 5e:Housing Market Analysis 45 12 60 8 125 Task 6:Funding Strategy 120 70 80 8 278 Task 7:Concept Plan Summary Report 20 42 40 102 Task 8:Plan Adoption Process 56 28 160 244 Task 9:Public Involvement 158 144 1,2721 1,574 Metro UGB Application 20 20 Total Estimated Hours 774 999 31232 92 5,097 Hours estimates include estimates of work by: Community Development staff:Senior Planner,CD Director,Assistant CD Director,Administrative Specialist Public Works/Engineering:Senior Project Engineer,City Engineer,Assistant City Engineer,Principal Engineer Finance&Information Services:Senior Management Analyst,Finance Director,Assistant Finance Director,Revenue Manager City Attorney advisory services on contract AIS-3992 5, Business Meeting Meeting Date: 10/15/2019 Length (in minutes): 25 Minutes Agenda Title: Public Hearing to Consider Approval of Resolution for First Quarter Supplemental Budget Prepared For: Steve Kang Submitted By: Steve Kang, Finance and Information Services Item Type: Motion Requested Meeting Type: Council Resolution Business Public Hearing- Informational Meeting- Main Public Hearing Yes Newspaper Legal Ad Required?: Public Hearing Publication 10/10/2019 Date in Newspaper: Information ISSUE Shall the Tigard City Council adopt a FY 2020 First Quarter Budget Supplemental? STAFF RECOMMENDATION /ACTION REQUEST Staff recommends the City Council approve the FY 2020 First Quarter Budget Supplemental. KEY FACTS AND INFORMATION SUMMARY The following is a summary of items that require council action for FY 2020 in the First Quarter Budget Supplemental: City Management Human Resources—HR has three requests. One request is to increase 0.20 FTE for the HR Business Partner position and increase 0.20 FTE for the HR/Risk Assistant position. Both positions were reduced from 1.00 FTE to 0.80 FTE in FY2018,but with increased workload and operational demands,HR is needing additional FTE to meet current organizational requirements for HR services. The request also serves to implement a recent recommendation in the Citywide Performance Audit study to increase HR staffing capacity.The second request is the retirement investment advisor consultant. The city receives administrative fees from our retirement plan record keeper,MassMutual and this fee is primarily used to pay the cost of the Financial Investment Advisors who work with the city to ensure fiduciary responsibilities are being met relative to the plans. The third request is in response to the Oregon's Equal Pay Act. In an effort to comply with new law, the city conducted the review of the citywide pay review and this review resulted in pay increase for 20 staff members. City Management—City Management is requesting to increase CFM's existing lobbying services contract by $32,500 for state-level advocacy for a 99W corridor study. Central Services Property Management is requesting an increase in budget appropriation to cover Senior Center Elevator upgrades including the work required to meet current ADA and safety standards.This was originally budgeted in FY19,but shifting priorities and the contractor availability required the work to be moved to FY20. Finance and Information Services. Information Technology—IT has two requests. One request is for the software upgrade to the city's computer systems and infrastructure components to increase the security posture. This request originated from the Police Department's recent Criminal Justice Information System(CJIS) audit. The other request is additional funding for the consultant to perform the data analytics and data discovery. This phase will assist the city's ultimate goal to develop a program for data informed business decisions that is standardized across all business units. Finance—First request from Finance is to increase the appropriation to accommodate the 3.5% COLA increase for the SEIU and non-represented staff. The second request is a budget correction entry. The second request is for River Terrace South and West Urban Reserve Area (URA) planning.A request to authorize 3.00 FTE is requested to add staff in Finance Admin, CD Planning,PW Engineering,and (funding for) City Attorney services to perform the work to concept-plan these URAs, satisfy Metro Title 11 requirements,and apply for UGB expansion in 2021.The requested staff and funding will plan for new urban growth areas and create an appropriate foundation for successful community planning in the future. Police Department Police has a request to increase appropriations to install additional fencing and gating around PD parking lot, and to replace a police vehicle. Parking lot fencing is the direct response to the CJIS audit. Public Works PW has one request to plan for Parks and Street Manager's vacation cashout. Parks and Street Manager is planning a retirement in Q2 and has 462 hours in his PTO bank. Capital Improvement Plan (CIP) CIP Carryforward of Prior Year Appropriations—Carryforward of prior year appropriations for various CIP projects impacting General Fund,Gas Tax,Parks SDC,Parks Capital,Transportation SDC,Water CIP,and Water Fund. •92034 Tigard Street Heritage Trail($31,000) •92034-02 Tigard Street Heritage Plaza Outdoor Museum($87,166) •92046 Fanno Creek Trail Connection (RFFA Grant) ($187,000) •92055 Americans with Disabilities Act Transition Plan ($30,000) •92056 Park System Master Plan ($44,000) •95057 Fanno Creek Alignment Study($127,000) •96050 Fonner Street/ 121 st Avenue Valve and Piping Improvements ($54,000) 92034 Tigard Street Heritage Trail—Construction contract bid came in higher than anticipated. New ask from Parks SDC Fund,$231,000 and Urban Forestry Fund,$70,000. 94038 124th Avenue /Ann Court Culvert Replacement—Construction contract bid came in higher than anticipated. New ask from Stormwater Fund, $40,000. 94041 Frewing Street Stormline Replacement—Scope of project has increased to provide for a more complete stormwater management project. This increased scope will require land acquisition,increased design and increased construction costs. New ask from Stormwater Fund,$126,000. 96050 Fonner Street/ 121st Avenue Valve and Piping Improvements—Design costs were higher than anticipated. New ask from Water Fund,$11,000 and Water SDC Fund,$36,000. Project needs to be coordinated with 121st Avenue improvements and must meet the County's design time line. OTHER ALTERNATIVES Do not approve the FY 2020 First Quarter Budget Supplemental. COUNCIL OR TCDA GOALS, POLICIES, MASTER PLANS N/A DATES OF PREVIOUS CONSIDERATION This is the first time the City Council has been presented with this information. Fiscal Impact Cost: $2,348,558 Budgeted (yes or no): No Where Budgeted (department/program): Multiple Additional Fiscal Notes: The FY 2020 First Quarter Supplemental will increase the budget by$2.3 million across 20 city funds. The expenditure increases are largely supported through unanticipated beginning fund balances and contingency. This supplemental will decrease the reserves of the city by$70,000. Please refer to Exhibits A and B which summarize the fiscal impact of the quarterly supplemental budget by fund. Attachments FY20 Q1-Resolution FY 20 Q1 Supplemental Summary FY20 Q1 Exhibit A FY20 Q1 Exhibit B FY20 Q1 Exhibit C CITY OF TIGARD, OREGON TIGARD CITY COUNCIL RESOLUTION NO. 19- A RESOLUTION TO ADOPT THE FY 2020 FIRST QUARTER BUDGET SUPPLEMENTAL INCLUDING BUDGET ADJUSTMENTS TO PUBLIC WORKS, POLICY AND ADMINISTRATION, AND COMMUNITY SERVICES. WHEREAS,the city acknowledges those items that were unknown at the time the FY 2020 budget was adopted; and WHEREAS, the city recognizes approximately $2,348,558 of unanticipated budget in operations and transfers; and WHEREAS, the increase in budget is offset by unanticipated fund balance, miscellaneous revenue, and contingency. NOW,THEREFORE,BE IT RESOLVED by the Tigard City Council that: SECTION 1: The FY 2019-20 Budget is hereby amended as detailed in Exhibit B. SECTION: This resolution is effective immediately upon passage. PASSED: This day of 2019. Mayor-City of Tigard ATTEST: City Recorder-City of Tigard RESOLUTION NO. 19- Page 1 CITY OF TIGARD-BUDGET SUPPLEMENTAL w/9/2019 FY 2019-2020 Quarter: 1 Item# Department Fund Division Request Title Request Funding Total Amount Detailed Description Source Q1CM01 City Management MULTIPLE MULTIPLE Add 0.40 FTE-Human Resources NEW Contingency $ 17,600 HR Business Partner Business Partner and HR/Risk Increase the HR Business Partner from 0.80 FTE to 1.00 FTE. This position was previously at a 1.00 FTE.Due to budget reduction needs Assistant in FY2018,this position was reduced and the work was restructured to reduce costs.Driven by the operational demands,this reduction in staff was deemed unsuccessful,resulting in an inability to completely service business partners and sustain other citywide HR initiatives.In order to meet organizational needs for HR services,we are requesting the reinstatement of this position to full time. HR/Risk Assistant Increase the HR/Risk Assistant from 0.80 FTE to 1.00 FTE.In FY2018,the HR Recruitment Specialist position was reduced to 0.80 FTE from a 1.00 FTE,and some of the more transactional work was transferred to the assistant position to support this decrease.With the current increasing demands for accurate data tracking and analysis,along with the move to more automated systems requiring regular and accurate data input,the work at this level has increased.Increasing this position will alleviate some of the transactional work for the HR Business Partners and Risk Management staff,in addition to improving the department's ability to provide data to meet organizational decision making needs. Both positions are prorated for 8.5 months. QlCM02 City Management 600Central Services 1100-Human Resources Retirement Investment Advisor NEW Miscellaneous $ 12,500 The city receives an administrative fee from our retirement plan record keeper,MassMutual.This fee is dedicated to city administrative Fund Consultant Revenue costs for the employee retirement plans.The fee is primarily used to pay the Lost of the Financial Investment Advisors who work with the city to ensure fiduciary responsibilities are being met relative to the plans.The Investment Advisory contract is paid out of the HR Consultant line Rem.The actual cost of the contract is$27,500,which is$12,500 more than the budget.The request is to increase the HR Consultant line Rem by an additional$12,500 to fully cover the cost of the contract.This increase will be offset by revenue coming from the MassMutual via the administrative fee. QICM03 City Management MULTIPLE MULTIPLE Equal Pay Act-Pay Equity NEW Contingency $ 78,326 In an effort to comply with Oregon's Equal Pay Act,the city established a matrix to help determine a systematic,non-discriminatory Adjustments method to set pay at the most appropriate step within the range for individuals.The matrix provides points for qualifications above the minimums listed in a job classification.The qualifications considered in the most recent 10 years of experience are;special skills and/or abilities;and education and/or certification levels. Based on this matrix approach,it resulted in roughly 20 staff members needing an increase within their range in order to ensure pay equity with other similarly situated staff and new hires.This increase will be effective 7/1/2019. Q1CM04 City Management 600-Central Services 1000-City Management Increase CFM contract for state-level NEW Contingency $ 32,500 Request to increase CFM's existing lobbying services contract by$32,500 for state-level advocacy for a 99W corridor study. Fund advocacv Q1CS01 Central Services 650-Fleet/Property 6450-Property Management Senior Center Elevator Modernization NEW Contingency $ 82,000 Senior Center Elevator upgrades including the work required to meet current ADA and safety standards.Originally budgeted in FY39,but Management Fund shifting priorities and the contractor availability required the work to be moved to FY20. Q1FIS01 Finance& 600-Central Services 2300-Information Technology Security Event Information NEW Multiple $ 55,000 During the most recent Criminal Justice Information System(CIIS)audit(July 2019),Tigard Police was cited deficient in not being able to Information Fund Management(SEIM) automatically parse,report,and respond to malicious events on R's computer systems,security,and networking components,which is Services required for compliance.Tigard IT has researched and identified software systems that will monitor,report,and automatically respond to security events.These systems will assist IT staff using automation and will ultimately increase the security posture across all computer systems and infrastructure components including the mandated UIS systems of the Tigard Police department.This will be a$35,000 annual increase to the IT budget and in addition to the annual fee,this request includes$20,000 in the initial year for professional services to deploy and configure the systems for our complex computing environments. QlFIS02 Finance& 600-Central Services 2300-Information Technology Data Analytics and Data Discovery NEW $ 59,000 This request is in response to the Citywide Performance Audit and implementing one of the recommendations from the IT Strategic Plan. Information Fund This would be the discovery phase of a multi-year project of developing a centralized Data Informed Decision Making Program(DIDMP). Services The city will hire a professional service to assist with developing the requirements and resources needed for a successful citywide implementation of DIDMP.This discovery phase may include: -Meet with stakeholders and define requirements of the program. -Identify/map citywide data locations,data owners,and examine/document the meaning of each data source. -Identify and plan for the needed resources for a consistent centralized DIDMP. -Present findings to stakeholders and department leaders and determine next steps. -Create data policies and program policies for the DIDMP. QIFIS03 Finance& MULTIPLE MULTIPLE COLA Adjustment for SEIU and NEW Contingency $ 709,600 As per the SEIU labor contract provisions effective July 1,2019,the city must increase appropriation to accommodate the 3.5%COLA Information Management increase for the SEIU and non-represented staff.COLA is based on the CPI-w West Urban Index. 1 of CITY OF TIGARD-BUDGET SUPPLEMENTAL 0/9/2019 FY 2019-2020 Quarter: 1 Item# Department Fund Division Request Title Request Funding Total Amount Detailed Description Source Q1FISO4 PW Engineering 640-PW Engineering 6250-PW Engineering River Terrace South and West Urban NEW Miscellaneous $ 325,526 This will allow us to develop concept plans for the West and South River Terrace Urban Reserve Areas(URAs)in accordance with the Fund Growth Area Planning Revenue Tigard's City Council Goal 3. MLG and the City of Tigard have agreed on the tasks needed to conceptually plan these URAs to satisfy Metro's Title 11 criteria for new urban growth areas and to lay an appropriate foundation for successful community planning in the future. Following are requests for resources needed to satisfy the city portion of the tasks: City Attorn -The city will contract for attorney services to perform the legal work associated with the project on an on-call basis. Finance Admin-A new full-time Senior Management Analyst is needed to support the River Terrace South and West expansion plan. This position will work on the financial plan and other financial aspects surrounding the River Terrace South and West Concept Plan. CD Planning-A new full-time Senior Planner position is needed in Community Development in order to take on the project management responsibilities for the development of the River Terrace South and West Concept Plan. PW Engineering-Engineering position to support urban growth expansion.Estimated need is approximately half-time,remainder of position would be utilized for either Southwest Corridor Light Rail support and/or project management for new,unplanned,currently unfunded capital projects.Recent hires suggest that we will need to bring them in at the top of the pay scale,based on this,the Total Amount assumes half-year salary and benefits at top of Sr.Project Engineer pay scale and one-time expenses like office space(computer, monitors,desk,chair,phone,etc.)and travel training. QlFIS05 Finance& MULTIPLE MULTIPLE Correction Budget Entries NEW Existing $ - Reclass 2 budget entries to correct fund/division/object code. Information Appropriations -Entry to correct an indirect allocation entry incorrectly entered as a capital expenditure item in General Fund.This entry will reclass to Services Program Expenditures. -CIP 93057's capital expenditure was inadvertently split into two funds. Entry to move the capital expenditure in Stormwater Fund to Sanita Sewer Fund. QlPD01 Police 100-General Fund 4100-Police Operations PD parking lot fencing and PD vehicle NEW Contingency $ 43,600 Parking Lot Fencing replacement The Police Department will be installing additional fencing and gating around the PD parking lot both for the patrol and personal vehicle areas.The partial enclosure of the parking lot is in direct response to a recent Criminal Justice Information Services(CIIS)audit conducted by the Oregon State Police.In order to safeguard sensitive and confidential information related to investigations as well as personnel,all police departments must comply with strict CIIS standards.By installing two gates and additional fencing,the Police Department can move closer to adhering to CIIS best practices. Police Vehicle Replacement In the early morning of August 20th,police vehicle#14-826 was involved in a crash during a police matter.No one was hurt,however the vehicle was almost past its useful life and sustained enough damage that the City's Fleet Manager recommends replacement Our insurance carrier,CIS,is willing to pay out based on estimated repairs of$8,200,net of the$500 deductible.The total cost to replace the vehicle will be$35,100.After accounting for the insurance proceeds,the request from the general fund contingency is$26,900. QIPW01 Capital MULTIPLE 8000- CIP 92034 Tigard Street Heritage NEW/CARRYFO Multiple $ 444,000 Construction contract came in higher than anticipated.New ask from Parks SDC(425),$231,000 and Urban Forestry(260),$70,000. Improvement CIP/Transfers/Contingency Trail RWARD Program Carryforward grant dollars-$112,000 and unspent Parks SDC(425)-$31,000. QIPW02 Capital 420-Parks Capital 8000- CIP 92034-02 Tigard Street Heritage CARRYFORWA Multiple $ 87,166 Contract was executed in FY19 but the vast majority of the work be performed in FY20. Improvement Fund CIP/Transfers/Contingency Plaza Outdoor Museum RD QlPW03 Capital 420-Parks Capital 8000- CIP 92046 Fanno Creek Trail CARRYFORWA Unanticipated $ 187,000 Carryforward of prior year appropriations impacting Transportation SDC(415)and Parks SDC(425). Required partner payments to ODOT Improvement Fund CIP/Transfers/Contingency Connection(RFFA Grant) RD Fund Balance were delayed due to the revision in the 30%plans to meet project budget constraints,delaying the 60%and 90%phases. QIPW04 Capital 420-Parks Capital 8000- CIP 92055 Americans with Disabilities CARRYFORWA Unanticipated $ 30,000 Carryforward of prior year appropriations impacting General Fund(100),Gas Tax(200)and Parks SDC(425). Project finalization and Improvement Fund CIP/Transfers/Contingency Act Transition Plan RD Fund Balance adoption process took longer than expected,requiring a carryforward. QIPW05 Capital 420-Parks Capital 8000- CIP 92056 Park System Master Plan CARRYFORWA Unanticipated $ 44,000 Carryforward of prior year appropriations impacting Parks SDC(425). Project start was delayed due to staff workload constraints. Improvement Fund CIP/Transfers/Contingency RD Fund Balance Q1PW06 Capital 420-Parks Capital 8000- CIP 92057 Fanno Creek Trail CARRYFORWA Unanticipated $ 22,000 Carryforward of prior year appropriations impacting Parks SDC(425).This project is connected to the Fanno Creek Trail CIP 92046,which Improvement Fund CIP/Transfers/Contingency Amenities RD Fund Balance was delayed. Q1PW07 Capital 510-Stormwater Fund 8000- CIP 94038 124th Avenue/Ann Court NEW Unanticipated $ 40,000 Construction contract came in higher than anticipated.New ask from Stormwater(510). Improvement CIP/Transfers/Contingency Culvert Replacement Fund Balance 2of3 CITY OF TIGARD-BUDGET SUPPLEMENTAL 10/9/2019 FY 2019-2020 Quarter: 1 Item# Depardnent Fund Division Request Title Request Funding Total Amount Detailed Description Source Q1PW08 Capital 510-Stormwater Fund 8000- CIP 94041 Frewing Street Stormline NEW Unanticipated $ 126,000 Scope of project has increased to provide for a more complete Stormwater management project.This increased scope will require land Improvement CIP/Transfers/Contingency Replacement Fund Balance acquisition,increased design and increased construction costs.New ask from Stormwater(510).This project will also require an additional Program appropriation in FY2021. QIPW09 Capital 420-Parks Capital 8000- CIP 95057 Fanno Creek Alignment CARRYFORWA Unanticipated $ 127,000 Carryforward of prior year appropriations impacting a Metro Grant and Transportation SDC(415). Project was delayed because PM was on Improvement Fund CIP/Transfers/Contingency Study(Bonita Road to Tualatin River)RD Fund Balance leave. Pro— Q1PW10 Capital 532-Water CIP Fund 8000- CIP 96050 Former Street/121st NEW/CARRYFO Unanticipated $ 90,000 Carryforward of prior year appropriations impacting Water(530). Improvement CIP/Transfers/Contingency Avenue Valve and Piping RWARD Fund Balance Program Improvements Design costs were higher than anticipated.New ask from Water(530)-$11,000 and Water SDC(531)-$36,000. Project needs to be coordinated with 121st Avenue improvements and must meet the County's design time line. Q1PW11 Multiple MULTIPLE MULTIPLE vacation Cashout for Parks and NEW Contingency $ 29,400 Cashout of PTO of long time Parks and Street Manager. Split between Parks Utility,Gas Tax,and Stormwater. Assumes full PTO balance Streets Manager of 462 at a rate of$51.07. 3 of Exhibit A 01CM01-Add 0.40 FTE -HR Business Partner&HR/Risk Assistant HR Business Partner Increase FTE from 0.80 FTE to 1.00 FTE. Due to budget reduction needs in FY2018,this position was reduced to 0.80 from 1.00 FTE and the work was restructured to reduce costs. Driven by the operational demands,this reduction in staff was deemed unsuccessful,resulting in an inability to completely service business partners and sustain other citywide HR initiatives. Requesting the reinstatement of this position to full time. HR/Risk Assistant Increase the HR/Risk Assistant from 0.80 FTE to 1.00 FTE.Increasing this position will alleviate some of the transactional work for the HR Business Partners and Risk Management staff, in addition to improving the department's ability to provide data to meet organizational decision making needs. Both positions are prorated for 8.5 months. Fund 1 of 2 FY 2020 Q1 Revised Central Services Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,773,564 $ - $ 1,773,564 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ Special Assessments $ - $ - $ _ Licenses&Permits $ - $ - $ Intergovernmental $ - $ - $ - Charges for Services $ 10,032,008 $ - $ 10,032,008 Fines&Forfeitures $ - $ - $ _ Interest Earnings $ - $ - $ - Miscellaneous $ 30,000 $ - $ 30,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 234,721 $ - $ 234,721 Total Resources $ 12,070,293 $ - $ 12,070,293 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ 10,150,956 $ 14,780 $ 10,165,736 Public Works $ - $ - $ _ Program Expenditures Total $ 10,150,956 $ 14,780 $ 10,165,736 Debt Service $ - $ - $ Loan to TCDA $ - $ _ $ _ Work-In-Progress $ - $ - $ Transfers to Other Funds $ - $ - $ - Contingency $ 429,000 $ (14,780) $ 414,220 Total Budget $ 10,579,956 $ - $ 10,579,956 Reserve For Future Expenditure $ 1,490,337 $ - $ 1,490,337 Total Requirements $ 12,070,293 $ - $ 12,070,293 Exhibit A 01CM01-Add 0.40 FTE-HR Business Partner& HR/Risk Assistant HR Business Partner Increase FTE from 0.80 FTE to 1.00 FTE. Due to budget reduction needs in FY2018,this position was reduced to 0.80 from 1.00 FTE and the work was restructured to reduce costs.Driven by the operational demands,this reduction in staff was deemed unsuccessful, resulting in an inability to completely service business partners and sustain other citywide HR initiatives. Requesting the reinstatement of this position to full time. HR/Risk Assistant Increase the HR/Risk Assistant from 0.80 FTE to 1.00 FTE. Increasing this position will alleviate some of the transactional work for the HR Business Partners and Risk Management staff, in addition to improving the department's ability to provide data to meet organizational decision making needs. Both positions are prorated for 8.5 months. Fund 2 of 2 FY 2020 Q1 Revised Insurance Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,117,330 $ - $ 1,117,330 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines&Forfeitures $ - $ - $ - Interest Earnings $ 26,500 $ - $ 26,500 Miscellaneous $ 39,000 $ - $ 39,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 1,182,830 $ - $ 1,182,830 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ 64,476 $ 2,820 $ 67,296 Public Works $ - $ - $ - Program Expenditures Total $ 64,476 $ 2,820 $ 67,296 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ _ Work-In-Progress $ - $ - $ - Transfers to Other Funds $ - $ - $ - Contingency $ 25,000 $ (2,820) $ 22,180 Total Budget $ 89,476 $ - $ 89,476 Reserve For Future Expenditure $ 1,093,354 $ - $ 1,093,354 Total Requirements $ 1,182,830 $ - $ 1,182,830 Exhibit A QlCM03 - Retirement Investment Advisor Consultant The city receives an administrative fee from our retirement plan record keeper, MassMutual. This fee is dedicated to city administrative costs for the employee retirement plans.The fee is primarily used to pay the cost of the Financial Investment Advisors who work with the city to ensure fiduciary responsibilities are being met relative to the plans.The Investment Advisory contract is paid out of the HR Consultant line item.The actual cost of the contract is$27,500, which is$12,500 more than the budget.The request is to increase the HR Consultant line item by an additional$12,500 to fully cover the cost of the contract. This increase will be offset by revenue coming from the MassMutualin via the administrative fee. FY 2020 Q1 Revised Central Services Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,773,564 $ - $ 1,773,564 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ 10,032,008 $ - $ 10,032,008 Fines &Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ 30,000 $ 12,500 $ 42,500 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 234,721 $ - $ 234,721 Total Resources $ 12,070,293 $ 12,500 $ 12,082,793 Requirements Community Development $ - $ - $ _ Community Services $ - $ - $ _ Policy and Administration $ 10,150,956 $ 12,500 $ 10,163,456 Public Works $ - $ - $ _ Program Expenditures Total $ 10,150,956 $ 12,500 $ 10,163,456 Debt Service $ - $ - $ _ Loan to TCDA $ - $ - $ _ Work-In-Progress $ - $ - $ _ Transfers to Other Funds $ - $ - $ _ Contingency $ 429,000 $ - $ 429,000 Total Budget $ 10,579,956 $ 12,500 $ 10,592,456 Reserve For Future Expenditure $ 1,490,337 $ - $ 1,490,337 Total Requirements $ 12,070,293 $ 12,500 $ 12,082,793 Exhibit A Q1CM04 - Equal Pay Act- Pay Equity Adjustments In an effort to comply with Oregon's Equal Pay Act,the city established a matrix to help determine a systematic, non- discriminatory method to set pay at the most appropriate step within the range for individuals.The matrix provides points for qualifications above the minimums listed in a job classification. The qualifications considered in the most recent 10 years of experience are;special skills and/or abilities;and education and/or certification levels. Based on this matrix approach, it resulted in roughly 20 staff members needing an increase within their range in order to ensure pay equity with other similarly situated staff and new hires. This increase will be effective 7/1/2019. Fund 1 of 6 FY 2020 Q1 Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 21,824,486 $ - $ 21,824,486 Property Taxes $ 17,121,416 $ - $ 17,121,416 Franchise Fees $ 6,254,627 $ - $ 6,254,627 Special Assessments $ - $ - $ - Licenses &Permits $ 1,186,521 $ - $ 1,186,521 Intergovernmental $ 7,347,865 $ - $ 7,347,865 Charges for Services $ 253,702 $ - $ 253,702 Fines & Forfeitures $ 1,654,498 $ - $ 1,654,498 Interest Earnings $ 500,900 $ - $ 500,900 Miscellaneous $ 56,432 $ - $ 56,432 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 292,900 $ - $ 292,900 Total Resources $ 56,493,347 $ - $ 56,493,347 Requirements Community Development $ 3,613,352 $ 24,891 $ 3,638,243 Community Services $ 25,919,480 $ 10,899 $ 25,930,379 Policy and Administration $ 1,054,831 $ 2,859 $ 1,057,690 Public Works $ - $ - $ - Program Expenditures Total $ 30,587,663 $ 38,649 $ 30,626,312 Debt Service $ - $ - $ - Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ 12,609 $ - $ 12,609 Transfers to Other Funds $ 2,611,477 $ - $ 2,611,477 Contingency $ 1,638,450 $ (38,649) $ 1,599,801 Total Budget $ 34,851,199 $ - $ 34,851,199 Reserve For Future Expenditure $ 21,642,148 $ - $ 21,642,148 Total Requirements $ 56,493,347 $ - $ 56,493,347 Exhibit A Q1CM04- Equal Pay Act- Pay Equity Adjustments In an effort to comply with Oregon's Equal Pay Act,the city established a matrix to help determine a systematic, non- discriminatory method to set pay at the most appropriate step within the range for individuals.The matrix provides points for qualifications above the minimums listed in a job classification. The qualifications considered in the most recent 10 years of experience are;special skills and/or abilities; and education and/or certification levels. Based on this matrix approach, it resulted in roughly 20 staff members needing an increase within their range in order to ensure pay equity with other similarly situated staff and new hires. This increase will be effective 7/1/2019. Fund 2 of 6 FY 2020 Q1 Revised Sanitary Sewer Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 4,903,060 $ - $ 4,903,060 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ 92,200 $ - $ 92,200 Intergovernmental $ - $ - $ - Charges for Services $ 3,255,811 $ - $ 3,255,811 Fines &Forfeitures $ - $ - $ - Interest Earnings $ 110,300 $ - $ 110,300 Miscellaneous $ 42,100 $ - $ 42,100 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 243,750 $ - $ 243,750 Total Resources $ 8,647,221 $ - $ 8,647,221 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 2,301,899 $ 5,965 $ 2,307,864 Program Expenditures Total $ 2,301,899 $ 5,965 $ 2,307,864 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 1,206,500 $ - $ 1,206,500 Transfers to Other Funds $ 659,200 $ - $ 659,200 Contingency $ 414,000 $ (5,965) $ 408,035 Total Budget $ 4,581,599 $ - $ 4,581,599 Reserve For Future Expenditure $ 4,065,622 $ - $ 4,065,622 Total Requirements $ 8,647,221 $ - $ 8,647,221 Exhibit A QlCM04- Equal Pay Act- Pay Equity Adjustments In an effort to comply with Oregon's Equal Pay Act,the city established a matrix to help determine a systematic, non- discriminatory method to set pay at the most appropriate step within the range for individuals.The matrix provides points for qualifications above the minimums listed in a job classification. The qualifications considered in the most recent 10 years of experience are;special skills and/or abilities;and education and/or certification levels. Based on this matrix approach, it resulted in roughly 20 staff members needing an increase within their range in order to ensure pay equity with other similarly situated staff and new hires. This increase will be effective 7/1/2019. Fund 3 of 6 FY 2020 Q1 Revised Stormwater Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 6,456,618 $ - $ 6,456,618 Property Taxes $ - $ _ $ _ Franchise Fees $ - $ _ $ _ Special Assessments $ - $ _ $ _ Licenses &Permits $ - $ _ $ _ Intergovernmental $ - $ _ $ _ Charges for Services $ 3,892,188 $ - $ 3,892,188 Fines &Forfeitures $ - $ - $ _ Interest Earnings $ 139,900 $ - $ 139,900 Miscellaneous $ 5,000 $ - $ 5,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 704,000 $ - $ 704,000 Total Resources $ 11,197,706 $ - $ 11,197,706 Requirements Community Development $ - $ - $ _ Community Services $ - $ - $ _ Policy and Administration $ - $ _ $ _ Public Works $ 2,977,842 $ 5,818 $ 2,983,660 Program Expenditures Total $ 2,977,842 $ 5,818 $ 2,983,660 Debt Service $ - $ _ $ _ Loan to TCDA $ - $ _ $ _ Work-In-Progress $ 2,410,500 $ - $ 2,410,500 Transfers to Other Funds $ 311,550 $ - $ 311,550 Contingency $ 225,000 $ (5,818) $ 219,182 Total Budget $ 5,924,892 $ - $ 5,924,892 Reserve For Future Expenditure $ 5,272,814 $ - $ 5,272,814 Total Requirements $ 11,197,706 $ - $ 11,197,706 Exhibit A Q1CM04- Equal Pay Act- Pay Equity Adjustments In an effort to comply with Oregon's Equal Pay Act,the city established a matrix to help determine a systematic, non- discriminatory method to set pay at the most appropriate step within the range for individuals.The matrix provides points for qualifications above the minimums listed in a job classification. The qualifications considered in the most recent 10 years of experience are;special skills and/or abilities;and education and/or certification levels. Based on this matrix approach, it resulted in roughly 20 staff members needing an increase within their range in order to ensure pay equity with other similarly situated staff and new hires. This increase will be effective 7/1/2019. Fund 4 of 6 FY 2020 Q1 Revised Water Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 30,807,424 $ - $ 30,807,424 Property Taxes $ - $ _ $ _ Franchise Fees $ - $ _ $ _ Special Assessments $ - $ _ $ _ Licenses &Permits $ 170,000 $ - $ 170,000 Intergovernmental $ 15,000 $ - $ 15,000 Charges for Services $ 22,405,446 $ - $ 22,405,446 Fines & Forfeitures $ - $ _ $ _ Interest Earnings $ 500,700 $ - $ 500,700 Miscellaneous $ 50,000 $ - $ 50,000 Other Financing Sources $ - $ - $ _ Transfers In from Other Funds $ - $ - $ _ Total Resources $ 53,948,570 $ - $ 53,948,570 Requirements Community Development $ - $ _ $ _ Community Services $ - $ _ $ _ Policy and Administration $ - $ - $ _ Public Works $ 10,246,079 $ 3,377 $ 10,249,456 Program Expenditures Total $ 10,246,079 $ 3,377 $ 10,249,456 Debt Service $ - $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ - $ _ $ _ Transfers to Other Funds $ 10,651,600 $ - $ 10,651,600 Contingency $ 539,000 $ (3,377) $ 535,623 Total Budget $ 21,436,679 $ - $ 21,436,679 Reserve For Future Expenditure $ 32,511,891 $ - $ 32,511,891 Total Requirements $ 53,948,570 $ - $ 53,948,570 Exhibit A Q1CM04- Equal Pay Act- Pay quity Adjustments In an effort to comply with Oregon's Equal Pay Act,the city established a matrix to help determine a systematic, non- discriminatory method to set pay at the most appropriate step within the range for individuals.The matrix provides points for qualifications above the minimums listed in a job classification. The qualifications considered in the most recent 10 years of experience are;special skills and/or abilities;and education and/or certification levels. Based on this matrix approach, it resulted in roughly 20 staff members needing an increase within their range in order to ensure pay equity with other similarly situated staff and new hires. This increase will be effective 7/1/2019. Fund 5 of 6 FY 2020 Q1 Revised Central Services Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,773,564 $ - $ 1,773,564 Property Taxes $ - $ _ $ _ Franchise Fees $ - $ _ $ _ Special Assessments $ - $ _ $ _ Licenses &Permits $ - $ _ $ _ Intergovernmental $ - $ _ $ _ Charges for Services $ 10,032,008 $ - $ 10,032,008 Fines &Forfeitures $ - $ _ $ _ Interest Earnings $ - $ _ $ _ Miscellaneous $ 30,000 $ - $ 30,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 234,721 $ - $ 234,721 Total Resources $ 12,070,293 $ - $ 12,070,293 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ 10,150,956 $ 18,971 $ 10,169,927 Public Works $ - $ _ $ _ Program Expenditures Total $ 10,150,956 $ 18,971 $ 10,169,927 Debt Service $ - $ _ $ _ Loan to TCDA $ - $ _ $ _ Work-In-Progress $ - $ _ $ _ Transfers to Other Funds $ - $ - $ _ Contingency $ 429,000 $ (18,971) $ 410,029 Total Budget $ 10,579,956 $ - $ 10,579,956 Reserve For Future Expenditure $ 1,490,337 $ - $ 1,490,337 Total Requirements $ 12,070,293 $ - $ 12,070,293 Exhibit A Q1CM04- Equal Pay Act- Pay Equi1y Adjustments In an effort to comply with Oregon's Equal Pay Act,the city established a matrix to help determine a systematic, non- discriminatory method to set pay at the most appropriate step within the range for individuals.The matrix provides points for qualifications above the minimums listed in a job classification. The qualifications considered in the most recent 10 years of experience are;special skills and/or abilities;and education and/or certification levels. Based on this matrix approach, it resulted in roughly 20 staff members needing an increase within their range in order to ensure pay equity with other similarly situated staff and new hires. This increase will be effective 7/1/2019. Fund 6 of 6 FY 2020 Q1 Revised PW Admin Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 316,216 $ - $ 316,216 Property Taxes $ _ $ _ $ - Franchise Fees $ _ $ _ $ _ Special Assessments $ - $ _ $ _ Licenses &Permits $ - $ _ $ _ Intergovernmental $ _ $ _ $ - Charges for Services $ 2,262,895 $ - $ 2,262,895 Fines &Forfeitures $ - $ _ $ _ Interest Earnings $ _ $ _ $ _ Miscellaneous $ _ $ _ $ _ Other Financing Sources $ - $ _ $ _ Transfers In from Other Funds $ 48,336 $ - $ 48,336 Total Resources $ 2,627,447 $ - $ 2,627,447 Requirements Community Development $ - $ _ $ _ Community Services $ _ $ _ $ _ Policy and Administration $ - $ _ $ _ Public Works $ 2,273,688 $ 5,546 $ 2,279,234 Program Expenditures Total $ 2,273,688 $ 5,546 $ 2,279,234 Debt Service $ _ $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ - $ _ $ _ Transfers to Other Funds $ - $ _ $ _ Contingency $ 135,000 $ (5,546) $ 129,454 Total Budget $ 2,408,688 $ - $ 2,408,688 Reserve For Future Expenditure $ 218,759 $ - $ 218,759 Total Requirements $ 2,627,447 $ - $ 2,627,447 Exhibit A QlCM05 - Increase CFM contract for state-level advocacy Request to increase CFM's existing lobbying services contract by$32,500 for state-level advocacy for a 99W corridor study. FY 2020 Q1 Revised Central Services Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,773,564 $ - $ 1,773,564 Property Taxes $ - $ - $ _ Franchise Fees $ - $ - $ _ Special Assessments $ - $ - $ _ Licenses &Permits $ - $ - $ _ Intergovernmental $ - $ - $ _ Charges for Services $ 10,032,008 $ - $ 10,032,008 Fines &Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ 30,000 $ - $ 30,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 234,721 $ - $ 234,721 Total Resources $ 12,070,293 $ - $ 12,070,293 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ 10,150,956 $ 32,500 $ 10,183,456 Public Works $ - $ - $ - Program Expenditures Total $ 10,150,956 $ 32,500 $ 10,183,456 Debt Service $ - $ - $ _ Loan to TCDA $ - $ - $ _ Work-In-Progress $ - $ - $ Transfers to Other Funds $ - $ - $ - Contingency $ 429,000 $ (32,500) $ 396,500 Total Budget $ 10,579,956 $ - $ 10,579,956 Reserve For Future Expenditure $ 1,490,337 $ - $ 1,490,337 Total Requirements $ 12,070,293 $ - $ 12,070,293 Exhibit A Q1CS01- Senior Center Elevator Modernization Senior Center Elevator upgrades including the work required to meet current ADA and safety standards. Origianlly budgeted in FY19, but shifting priorities and the contractor availablity required the work to be moved to FY20. FY 2020 Q1 Revised Fleet/Property Management Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 610,063 $ - $ 610,063 Property Taxes $ _ $ _ $ _ Franchise Fees $ _ $ _ $ _ Special Assessments $ _ $ _ $ _ Licenses &Permits $ _ $ _ $ _ Intergovernmental $ _ $ _ $ _ Charges for Services $ 21719,734 $ - $ 2,719,734 Fines &Forfeitures $ _ $ _ $ _ Interest Earnings $ - $ _ $ _ Miscellaneous $ 5,000 $ - $ 5,000 Other Financing Sources $ _ $ _ $ _ Transfers In from Other Funds $ - $ _ $ - Total Resources $ 3,334,797 $ - $ 3,334,797 Requirements Community Development $ - $ _ $ _ Community Services $ - $ _ $ _ Policy and Administration $ 2,512,309 $ 82,000 $ 2,594,309 Public Works $ _ $ _ $ _ Program Expenditures Total $ 2,512,309 $ 82,000 $ 2,594,309 Debt Service $ _ $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ _ $ _ $ _ Transfers to Other Funds $ - $ _ $ _ Contingency $ 226,000 $ (82,000) $ 144,000 Total Budget $ 2,738,309 $ - $ 2,738,309 Reserve For Future Expenditure $ 596,488 $ - $ 596,488 Total Requirements $ 3,334,797 $ - $ 3,334,797 Exhibit A Q1FIS01- Security Event Information Management (SEIM) During the most recent Criminal Justice Information System (CJIS)audit(July 2019),Tigard Police was cited deficient in not being able to automatically parse, report,and respond to malicious evens on it's computer systems,security,and networking components,which is required for compliance.Tigard IT has researched and identified software systems that will monitor, report,and automatically respond to security events.These systems will assist IT staff using automation and will ultimately increase the security posture across all computer systems and infrastructure components including the mandated GIS systems of the Tigard Police department. This will be a$35,000 annual increase to the IT budget and in addition to the annual fee,this request includes$20,000 in the initial year for professional services to deploy and configure the systems for our complex computing environments. Fund 1 of 2 FY 2020 Q1 Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 21,824,486 $ - $ 21,824,486 Property Taxes $ 17,121,416 $ - $ 17,121,416 Franchise Fees $ 6,254,627 $ - $ 6,254,627 Special Assessments $ - $ - $ _ Licenses &Permits $ 1,186,521 $ - $ 1,186,521 Intergovernmental $ 7,347,865 $ - $ 7,347,865 Charges for Services $ 253,702 $ - $ 253,702 Fines &Forfeitures $ 1,654,498 $ - $ 1,654,498 Interest Earnings $ 500,900 $ - $ 500,900 Miscellaneous $ 56,432 $ - $ 56,432 Other Financing Sources $ - $ - $ _ Transfers In from Other Funds $ 292,900 $ - $ 292,900 Total Resources $ 56,493,347 $ - $ 56,493,347 Requirements Community Development $ 3,613,352 $ - $ 3,613,352 Community Services $ 25,919,480 $ - $ 25,919,480 Policy and Administration $ 1,054,831 $ - $ 1,054,831 Public Works $ - $ _ $ _ Program Expenditures Total $ 30,587,663 $ - $ 30,587,663 Debt Service $ - $ _ $ _ Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ 12,609 $ - $ 12,609 Transfers to Other Funds $ 2,611,477 $ 55,000 $ 2,666,477 Contingency $ 1,638,450 $ (55,000) $ 1,583,450 Total Budget $ 34,851,199 $ - $ 34,851,199 Reserve For Future Expenditure $ 21,642,148 $ - $ 21,642,148 Total Requirements $ 56,493,347 $ - $ 56,493,347 Exhibit A QlFIS01- Security Event Information Management (SEIM) During the most recent Criminal Justice Information System (UIS)audit(July 2019),Tigard Police was cited deficient in not being able to automatically parse, report,and respond to malicious evens on it's computer systems,security,and networking components,which is required for compliance.Tigard IT has researched and identified software systems that will monitor, report,and automatically respond to security events.These systems will assist IT staff using automation and will ultimately increase the security posture across all computer systems and infrastructure components including the mandated GIS systems of the Tigard Police department. This will be a$35,000 annual increase to the IT budget and in addition to the annual fee,this request includes$20,000 in the initial year for professional services to deploy and configure the systems for our complex computing environments. Fund 2 of 2 FY 2020 Q1 Revised Central Services Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,773,564 $ - $ 1,773,564 Property Taxes $ - $ - $ _ Franchise Fees $ - $ - $ _ Special Assessments $ - $ - $ Licenses &Permits $ - $ - $ - Intergovernmental $ - $ - $ _ Charges for Services $ 10,032,008 $ - $ 10,032,008 Fines& Forfeitures $ - $ - $ _ Interest Earnings $ - $ _ $ _ Miscellaneous $ 30,000 $ - $ 30,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 234,721 $ 55,000 $ 289,721 Total Resources $ 12,070,293 $ 55,000 $ 12425,293 Requirements Community Development $ - $ - $ _ Community Services $ - $ _ $ _ Policy and Administration $ 10,150,956 $ 55,000 $ 10,205,956 Public Works $ - $ _ $ _ Program Expenditures Total $ 10,150,956 $ 55,000 $ 10,205,956 Debt Service $ - $ _ $ _ Loan to TCDA $ - $ _ $ _ Work-In-Progress $ - $ _ $ _ Transfers to Other Funds $ - $ - $ - Contingency $ 429,000 $ - $ 429,000 Total Budget $ 10,579,956 $ 55,000 $ 10,634,956 Reserve For Future Expenditure $ 1,490,337 $ - $ 1,490,337 Total Requirements $ 12,070,293 $ 55,000 $ 12,125,293 Exhibit A QlFIS02- Data Analytics and Data DiscovM The city needs assistance with developing a program for data informed business decisions that is standardized across all business units.The first step in this process is utilizing professional services to assist the city leadership in determining goals for this new centralized program and a process for measuring success.Additionally, departments will identify what data exists across the city,the vendor will assist with organizing and normalizing the data in a single location that is accessible for cross departmental use. Finally, this process will give examples of how this data could relate to current city initiatives and key departmental needs.This discovery phase is critical to developing a thorough standardized program driven with leadership input that all departments must utilize when analyzing data for decision making. FY 2020 Q1 Revised Central Services Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,773,564 $ - $ 1,773,564 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ Special Assessments $ - $ - $ Licenses &Permits $ - $ - $ _ Intergovernmental $ - $ - $ - Charges for Services $ 10,032,008 $ - $ 10,032,008 Fines &Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - N iscellaneous $ 30,000 $ - $ 30,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 234,721 $ - $ 234,721 Total Resources $ 12,070,293 $ - $ 12,070,293 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and administration $ 10,150,956 $ 59,000 $ 10,209,956 Public Works $ - $ - $ - Program Expenditures Total $ 10,150,956 $ 59,000 $ 10,209,956 Debt Service $ - $ - $ - Loan to TCDA $ - $ _ $ _ Work-In-Progress $ - $ - $ _ Transfers to Other Funds $ - $ - $ - Contingency $ 429,000 $ (59,000) $ 370,000 Total Budget $ 10,579,956 $ - $ 10,579,956 Reserve For Future Expenditure $ 1,490,337 $ - $ 1,490,337 Total Requirements $ 12,070,293 $ - $ 12,070,293 Exhibit A Q1FIS03 -COLA Adjustment for SEIU and Management As per the SEIU labor contract provisions effective July 1,2019,the city must increase appropriation to accommodate the 3.5%COLA increase for the SEIU and non-represented staff. COLA is based on the CPI-w West Urban Index. Fund 1 of 12 FY 2020 Q1 Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 21,824,486 $ - $ 21,824,486 Property Taxes $ 17,121,416 $ - $ 17,121,416 Franchise Fees $ 6,254,627 $ - $ 6,254,627 Special Assessments $ _ $ _ $ - Licenses&Permits $ 1,186,521 $ - $ 1,186,521 Intergovernmental $ 7,347,865 $ - $ 7,347,865 Charges for Services $ 253,702 $ - $ 253,702 Fines&Forfeitures $ 1,654,498 $ - $ 1,654,498 Interest Earnings $ 500,900 $ - $ 500,900 Miscellaneous $ 56,432 $ - $ 56,432 Other Financing Sources $ - $ _ $ - Transfers In from Other Funds $ 292,900 $ - $ 292,900 Total Resources $ 56,493,347 $ - $ 56,493,347 Requirements Community Development $ 3,613,352 $ 64,191 $ 3,677,543 Community Services $ 25,919,480 $ 106,002 $ 26,025,482 Policy and Administration $ 1,054,831 $ 19,474 $ 1,074,305 Public Works $ - $ _ $ _ Program Expenditures Total $ 30,587,663 $ 189,667 $ 30,777,330 Debt Service $ _ $ - $ _ Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ 12,609 $ - $ 12,609 Transfers to Other Funds $ 2,611,477 $ - $ 2,611,477 Contingency $ 1,638,450 $ (189,667) $ 1,448,783 Total Budget $ 34,851,199 $ - $ 34,851,199 Reserve For Future Expenditure $ 21,642,148 $ - $ 21,642,148 Total Requirements $ 56,493,347 $ - $ 56,493,347 Exhibit A Q1FIS03-COLA Adjustment for SEIU and Management As per the SEIU labor contract provisions effective July 1,2019,the city must increase appropriation to accommodate the 3.5%COLA increase for the SEIU and non-represented staff. COLA is based on the CPI-w West Urban Index. Fund 2 of 12 FY 2020 Q1 Revised Gas Tax Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 2,960,484 $ - $ 2,960,484 Property Taxes $ - $ _ $ _ Franchise Fees $ - $ _ $ _ Special Assessments $ - $ _ $ _ Licenses&Permits $ 65,965 $ - $ 65,965 Intergovernmental $ 4,381,236 $ - $ 4,381,236 Charges for Services $ - $ _ $ _ Fines &Forfeitures $ - $ _ $ _ Interest Earnings $ 82,400 $ - $ 82,400 Miscellaneous $ 62,818 $ - $ 62,818 Other Financing Sources $ - $ _ $ _ Transfers In from Other Funds $ 158,000 $ - $ 158,000 Total Resources $ 7,710,903 $ - $ 7,710,903 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ _ Policy and Administration $ - $ - $ - Public Works $ 3,760,480 $ 25,270 $ 3,785,750 Program Expenditures Total $ 3,760,480 $ 25,270 $ 3,785,750 Debt Service $ 577,230 $ - $ 577,230 Loan to TCDA $ - $ _ $ _ Work-In-Progress $ - $ _ $ _ Transfers to Other Funds $ 2,131,900 $ - $ 2,131,900 Contingency $ 222,000 $ (25,270) $ 196,730 Total Budget $ 6,691,610 $ - $ 6,691,610 Reserve For Future Expenditure $ 1,019,293 $ - $ 1,019,293 Total Requirements $ 7,710,903 $ - $ 7,710,903 Exhibit A Q1FIS03-COLA Adjustment for SEIU and Management As per the SEIU labor contract provisions effective July 1,2019,the city must increase appropriation to accommodate the 3.5%COLA increase for the SEIU and non-represented staff. COLA is based on the CPI-w West Urban Index. Fund 3 of 12 FY 2020 Q1 Revised Building Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 8,021,235 $ - $ 8,021,235 Property Taxes $ _ $ _ $ - Franchise Fees $ _ $ _ $ _ Special Assessments $ _ $ _ $ - Licenses&Permits $ 2,322,956 $ - $ 2,322,956 Intergovernmental $ 8,281 $ - $ 8,281 Charges for Services $ 7,000 $ - $ 7,000 Fines&Forfeitures $ - $ _ $ _ Interest Earnings $ 150,500 $ - $ 150,500 Miscellaneous $ 500 $ - $ 500 Other Financing Sources $ - $ _ $ - Transfers In from Other Funds $ 250,000 $ - $ 250,000 Total Resources $ 10,760,472 $ - $ 10,760,472 Requirements Community Development $ 2,122,747 $ 44,441 $ 2,167,188 Community Services $ - $ _ $ _ Policy and Administration $ - $ _ $ _ Public Works $ - $ _ $ _ Program Expenditures Total $ 2,122,747 $ 44,441 $ 2,167,188 Debt Service $ - $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ _ $ _ $ _ Transfers to Other Funds $ - $ _ $ _ Contingency $ 295,000 $ (44,441) $ 250,559 Total Budget $ 2,417,747 $ - $ 2,417,747 Reserve For Future Expenditure $ 8,342,725 $ - $ 8,342,725 Total Requirements $ 10,760,472 $ - $ 10,760,472 Exhibit A QlFIS03- COLA Adjustment for SEIU and Management As per the SEIU labor contract provisions effective July 1,2019,the city must increase appropriation to accommodate the 3.5% COLA increase for the SEIU and non-represented staff. COLA is based on the CPI-w West Urban Index. Fund 4 of 12 FY 2020 Q1 Revised Parks Utility Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,452,584 $ - $ 1,452,584 Property Taxes $ _ $ _ $ - Franchise Fees $ _ $ _ $ _ Special Assessments $ _ $ _ $ - Licenses&Permits $ 1,790,593 $ - $ 1,790,593 Intergovernmental $ _ $ _ $ - Charges for Services $ 90,750 $ - $ 90,750 Fines&Forfeitures $ _ $ _ $ _ Interest Earnings $ 3,300 $ - $ 3,300 Miscellaneous $ _ $ _ $ _ Other Financing Sources $ - $ _ $ _ Transfers In from Other Funds $ 2,213,770 $ - $ 2,213,770 Total Resources $ 5,550,997 $ - $ 5,550,997 Requirements Community Development $ - $ _ $ _ Community Services $ _ $ _ $ _ Policy and Administration $ - $ _ $ - Public Works $ 3,807,739 $ 49,998 $ 3,857,737 Program Expenditures Total $ 3,807,739 $ 49,998 $ 3,857,737 Debt Service $ _ $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ _ $ _ $ - Transfers to Other Funds $ 61,538 $ - $ 61,538 Contingency $ 135,000 $ (49,998) $ 85,002 Total Budget $ 4,004,277 $ - $ 4,004,277 Reserve For Future Expenditure $ 1,546,720 $ - $ 1,546,720 Total Requirements $ 5,550,997 $ - $ 5,550,997 Exhibit A 01FIS03-COLA Adjustment for SEIU and Management As per the SEIU labor contract provisions effective July 1,2019,the city must increase appropriation to accommodate the 3.5%COLA increase for the SEIU and non-represented staff. COLA is based on the CPI-w West Urban Index. Fund 5 of 12 FY 2020 Q1 Revised Sanitary Sewer Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 4,903,060 $ - $ 4,903,060 Property Taxes $ - $ - $ _ Franchise Fees $ - $ _ $ _ Special Assessments $ - $ _ $ _ Licenses&Permits $ 92,200 $ - $ 92,200 Intergovernmental $ - $ _ $ _ Charges for Services $ 3,255,811 $ - $ 3,255,811 Fines&Forfeitures $ - $ - $ _ Interest Earnings $ 110,300 $ - $ 110,300 Miscellaneous $ 42,100 $ - $ 42,100 Other Financing Sources $ - $ - $ _ Transfers In from Other Funds $ 243,750 $ - $ 243,750 Total Resources $ 8,647,221 $ - $ 8,647,221 Requirements Community Development $ - $ _ $ _ Community Services $ - $ - $ _ Policy and Administration $ - $ - $ _ Public Works $ 2,301,899 $ 14,131 $ 2,316,030 Program Expenditures Total $ 2,301,899 $ 14,131 $ 2,316,030 Debt Service $ - $ _ $ _ Loan to TCDA $ - $ _ $ _ Work-In-Progress $ 1,206,500 $ - $ 1,206,500 Transfers to Other Funds $ 659,200 $ - $ 659,200 Contingency $ 414,000 $ (14,131) $ 399,869 Total Budget $ 4,581,599 $ - $ 4,581,599 Reserve For Future Expenditure $ 4,065,622 $ - $ 4,065,622 Total Requirements $ 8,647,221 $ - $ 8,647,221 Exhibit A QIFIS03-COLA Adjustment for SEIU and Management As per the SEIU labor contract provisions effective July 1,2019,the city must increase appropriation to accommodate the 3.5%COLA increase for the SEIU and non-represented staff. COLA is based on the CPI-w West Urban Index. Fund 6 of 12 FY 2020 Q1 Revised Stormwater Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 6,456,618 $ - $ 6,456,618 Property Taxes $ - $ _ $ _ Franchise Fees $ - $ _ $ _ Special Assessments $ - $ _ $ _ Licenses&Permits $ - $ _ $ _ Intergovernmental $ _ $ _ $ _ Charges for Services $ 3,892,188 $ - $ 3,892,188 Fines&Forfeitures $ - $ _ $ _ Interest Earnings $ 139,900 $ - $ 139,900 Miscellaneous $ 5,000 $ - $ 5,000 Other Financing Sources $ - $ _ $ _ Transfers In from Other Funds $ 704,000 $ - $ 704,000 Total Resources $ 11,197,706 $ - $ 11,197,706 Requirements Community Development $ - $ _ $ _ Community Services $ _ $ _ $ _ Policy and Administration $ - $ _ $ _ Public Works $ 2,977,842 $ 28,768 $ 3,006,610 Program Expenditures Total $ 2,977,842 $ 28,768 $ 3,006,610 Debt Service $ _ $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ 2,410,500 $ - $ 2,410,500 Transfers to Other Funds $ 311,550 $ - $ 311,550 Contingency $ 225,000 $ (28,768) $ 196,232 Total Budget $ 5,924,892 $ - $ 5,924,892 Reserve For Future Expenditure $ 5,272,814 $ - $ 5,272,814 Total Requirements $ 11,197,706 $ - $ 11,197,706 Exhibit A 01FIS03- COLA Adjustment for SEIU and Management As per the SEIU labor contract provisions effective July 1,2019,the city must increase appropriation to accommodate the 3.5%COLA increase for the SEIU and non-represented staff. COLA is based on the CPI-w West Urban Index, Fund 7 of 12 FY 2020 Q1 Revised Water Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 30,8072424 $ - $ 30,807,424 Property Taxes $ - $ _ $ - Franchise Fees $ _ $ _ $ _ Special Assessments $ _ $ _ $ - Licenses&Permits $ 170,000 $ - $ 170,000 Intergovernmental $ 15,000 $ - $ 15,000 Charges for Services $ 22,405,446 $ - $ 22,405,446 Fines&Forfeitures $ - $ _ $ _ Interest Earnings $ 500,700 $ - $ 500,700 Miscellaneous $ 50,000 $ - $ 50,000 Other Financing Sources $ - $ _ $ _ Transfers In from Other Funds $ - $ _ $ _ Total Resources $ 53,948,570 $ - $ 53,948,570 Requirements Community Development $ - $ _ $ _ Community Services $ - $ _ $ _ Policy and Administration $ - $ _ $ _ Public Works $ 10,246,079 $ 40,201 $ 10,286,280 Program Expenditures Total $ 10,246,079 $ 40,201 $ 10,286,280 Debt Service $ _ $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ - $ _ $ _ Transfers to Other Funds $ 10,651,600 $ - $ 10,651,600 Contingency $ 539,000 $ (40,201) $ 498,799 Total Budget $ 21,436,679 $ - $ 21,436,679 Reserve For Future Expenditure $ 32,511,891 $ - $ 32,511,891 Total Requirements $ 53,948,570 $ - $ 53,948,570 Exhibit A 01FIS03-COLA Adjustment for SEIU and Management As per the SEIU labor contract provisions effective July 1,2019,the city must increase appropriation to accommodate the 3.5%COLA increase for the SEIU and non-represented staff. COLA is based on the CPI-w West Urban Index. Fund 8 of 12 FY 2020 Q1 Revised Central Services Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,773,564 $ - $ 1,773,564 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ _ Special Assessments $ - $ - $ Licenses&Permits $ - $ - $ _ Intergovernmental $ - $ - $ _ Charges for Services $ 10,032,008 $ - $ 10,032,008 Fines&Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ _ Miscellaneous $ 30,000 $ - $ 30,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 234,721 $ - $ 234,721 Total Resources $ 12,070,293 $ - $ 12,070,293 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ 10,150,956 $ 181,322 $ 10,332,278 Public Works $ - $ - $ - Program Expenditures Total $ 10,150,956 $ 181,322 $ 10,332,278 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ Work-In-Progress $ - $ - $ _ Transfers to Other Funds $ - $ - $ - Contingency $ 429,000 $ (181,322) $ 247,678 Total Budget $ 10,579,956 $ - $ 10,579,956 Reserve For Future Expenditure $ 1,490,337 $ - $ 1,490,337 Total Requirements $ 12,070,293 $ - $ 12,070,293 Exhibit A QlFIS03- COLA Adjustment for SEIU and Management As per the SEIU labor contract provisions effective July 1,2019,the city must increase appropriation to accommodate the 3.5% COLA increase for the SEIU and non-represented staff. COLA is based on the CPI-w West Urban Index. Fund 9 of 12 FY 2020 Q1 Revised PW Admin Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 316,216 $ - $ 316,216 Property Taxes $ _ $ _ $ _ Franchise Fees $ - $ _ $ _ Special Assessments $ - $ _ $ _ Licenses&Permits $ - $ _ $ _ Intergovernmental $ _ $ _ $ - Charges for Services $ 2,262,895 $ - $ 2,262,895 Fines &Forfeitures $ _ $ _ $ _ Interest Earnings $ - $ _ $ _ Miscellaneous $ _ $ _ $ _ Other Financing Sources $ - $ _ $ - Transfers In from Other Funds $ 48,336 $ - $ 48,336 Total Resources $ 2,627,447 $ - $ 2,627,447 Requirements Community Development $ - $ _ $ _ Community Services $ _ $ _ $ _ Policy and Administration $ - $ _ $ - Public Works $ 2,273,688 $ 35,867 $ 2,309,555 Program Expenditures Total $ 2,273,688 $ 35,867 $ 2,309,555 Debt Service $ - $ - $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ - $ _ $ _ Transfers to Other Funds $ - $ _ $ - Contingency $ 135,000 $ (35,867) $ 99,133 Total Budget $ 2,408,688 $ - $ 2,408,688 Reserve For Future Expenditure $ 218,759 $ - $ 218,759 Total Requirements $ 2,627,447 $ - $ 2,627,447 Exhibit A O1FIS03-COLA Adjustment for SEIU and Management As per the SEIU labor contract provisions effective July 1,2019,the city must increase appropriation to accommodate the 3.5%COLA increase for the SEIU and non-represented staff. COLA is based on the CPI-w West Urban Index. Fund 10 of 12 FY 2020 Q1 Revised PW Engineering Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 541,296 $ - $ 541,296 Property Taxes $ _ $ _ $ _ Franchise Fees $ - $ _ $ _ Special Assessments $ _ $ _ $ _ Licenses&Permits $ 800,000 $ - $ 800,000 Intergovernmental $ 145,128 $ - $ 145,128 Charges for Services $ 2,920,852 $ - $ 2,920,852 Fines&Forfeitures $ _ $ _ $ _ Interest Earnings $ - $ _ $ _ Miscellaneous $ - $ _ $ _ Other Financing Sources $ - $ _ $ _ Transfers In from Other Funds $ 640,718 $ - $ 640,718 Total Resources $ 5,047,994 $ - $ 5,047,994 Requirements Community Development $ - $ - $ _ Community Services $ - $ _ $ _ Policy and Administration $ - $ _ $ _ Public Works $ 4,198,168 $ 72,838 $ 4,271,006 Program Expenditures Total $ 4,198,168 $ 72,838 $ 4,271,006 Debt Service $ _ $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ - $ _ $ _ Transfers to Other Funds $ - $ _ $ _ Contingency $ 170,000 $ (72,838) $ 97,162 Total Budget $ 4,368,168 $ - $ 4,368,168 Reserve For Future Expenditure $ 679,826 $ - $ 679,826 Total Requirements $ 5,047,994 $ - $ 5,047,994 Exhibit A 01FIS03-COLA Adjustment for SEIU and Management As per the SEIU labor contract provisions effective July 1,2019,the city must increase appropriation to accommodate the 3.5%COLA increase for the SEIU and non-represented staff. COLA is based on the CPI-w West Urban Index. Fund 11 of 12 FY 2020 Q1 Revised Fleet/Property Management Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 610,063 $ - $ 610,063 Property Taxes $ - $ _ $ _ Franchise Fees $ - $ _ $ _ Special Assessments $ - $ _ $ _ Licenses&Permits $ - $ _ $ _ Intergovernmental $ - $ _ $ _ Charges for Services $ 2,719,734 $ - $ 2,719,734 Fines&Forfeitures $ - $ _ $ _ Interest Earnings $ - $ _ $ _ Miscellaneous $ 5,000 $ - $ 5,000 Other Financing Sources $ - $ _ $ _ Transfers In from Other Funds $ - $ - $ _ Total Resources $ 3,334,797 $ - $ 3,334,797 Requirements Community Development $ - $ - $ _ Community Services $ - $ _ $ _ Policy and Administration $ 2,512,309 $ 26,418 $ 2,538,727 Public Works $ - $ _ $ _ Program Expenditures Total $ 2,512,309 $ 26,418 $ 2,538,727 Debt Service $ _ $ _ $ _ Loan to TCDA $ - $ _ $ _ Work-In-Progress $ - $ _ $ _ Transfers to Other Funds $ - $ _ $ _ Contingency $ 226,000 $ (26,418) $ 199,582 Total Budget $ 2,738,309 $ - $ 2,738,309 Reserve For Future Expenditure $ 596,488 $ - $ 596,488 Total Requirements $ 3,334,797 $ - $ 3,334,797 Exhibit A Q1FIS03-COLA Adjustment for SEIU and Management As per the SEIU labor contract provisions effective July 1,2019,the city must increase appropriation to accommodate the 3.5%COLA increase for the SEIU and non-represented staff. COLA is based on the CPI-w West Urban Index. Fund 12 of 12 FY 2020 Q1 Revised Insurance Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,117,330 $ - $ 1,117,330 Property Taxes $ - $ - $ _ Franchise Fees $ - $ - $ Special Assessments $ - $ - $ _ Licenses&Permits $ - $ - $ _ Intergovernmental $ - $ _ $ _ Charges for Services $ - $ - $ _ Fines&Forfeitures $ - $ - $ _ Interest Earnings $ 26,500 $ - $ 26,500 Miscellaneous $ 39,000 $ - $ 39,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 1,182,830 $ - $ 1,182,830 Requirements Community Development $ - $ - $ _ Community Services $ - $ - $ - Policy and Administration $ 64,476 $ 679 $ 65,155 Public Works $ _ $ _ $ - Program Expenditures Total $ 64,476 $ 679 $ 65,155 Debt Service $ - $ - $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ - $ _ $ _ Transfers to Other Funds $ - $ _ $ _ Contingency $ 25,000 $ (679) $ 24,321 Total Budget $ 89,476 $ - $ 89,476 Reserve For Future Expenditure $ 1,093,354 $ - $ 1,093,354 Total Requirements $ 1,182,830 $ - $ 1,182,830 Exhibit A Q1FISO4- River Terrace South and West Urban Growth Area Planning This will allow us to develop concept plans for the West and South River Terrace Urban Reserve Areas (URAs). MLG and the City of Tigard have agreed on the tasks needed to conceptually plan these URAs to satisfy Metro's Title 11 criteria for new urban growth areas and to lay an appropriate foundation for successful community planning in the future Requesting total of 3.0 FTE(1.0 FTE per division in the Finance Admin, CD Planning, and PW Engineering)to assist the development activity. Fund 1 of 3 FY 2020 Q1 Revised PW Engineering Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 541,296 $ - $ 541,296 Property Taxes $ - $ _ $ _ Franchise Fees $ - $ _ $ _ Special Assessments $ - $ _ $ _ Licenses &Permits $ 800,000 $ - $ 800,000 Intergovernmental $ 145,128 $ - $ 145,128 Charges for Services $ 2,920,852 $ - $ 2,920,852 Fines &Forfeitures $ - $ _ $ _ Interest Earnings $ - $ _ $ _ Miscellaneous $ - $ 86,152 $ 86,152 Other Financing Sources $ - $ _ $ _ Transfers In from Other Funds $ 640,718 $ - $ 640,718 Total Resources $ 5,047,994 $ 86,152 $ 5,134,146 Requirements Community Development $ - $ _ $ _ Community Services $ - $ _ $ _ Policy and Administration $ - $ _ $ _ Public Works $ 4,198,168 $ 86,152 $ 4,284,320 Program Expenditures Total $ 4,198,168 $ 86,152 $ 4,284,320 Debt Service $ _ $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ - $ _ $ _ Transfers to Other Funds $ - $ _ $ _ Contingency $ 170,000 $ - $ 170,000 Total Budget $ 4,368,168 $ 86,152 $ 4,454,320 Reserve For Future Expenditure $ 679,826 $ - $ 679,826 Total Requirements $ 5,047,994 $ 86,152 $ 5,134,146 Exhibit A 01FIS04 - River Terrace South and West Urban Growth Area Planning This will allow us to develop concept plans for the West and South River Terrace Urban Reserve Areas(URAs). MLG and the City of Tigard have agreed on the tasks needed to conceptually plan these URAs to satisfy Metro's Title 11 criteria for new urban growth areas and to lay an appropriate foundation for successful community planning in the future Requesting total of 3.0 FTE (1.0 FTE per division in the Finance Admin, CD Planning, and PW Engineering)to assist the development activity. Fund 2 of 3 FY 2020 Q1 Revised Central Services Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,773,564 $ - $ 1,773,564 Property Taxes $ - $ _ $ _ Franchise Fees $ - $ _ $ _ Special Assessments $ - $ _ $ _ Licenses &Permits $ - $ - $ _ Intergovernmental $ - $ _ $ _ Charges for Services $ 10,032,008 $ - $ 10,032,008 Fines &Forfeitures $ - $ _ $ _ Interest Earnings $ - $ - $ _ Miscellaneous $ 30,000 $ 88,536 $ 118,536 Other Financing Sources $ - $ _ $ - Transfers In from Other Funds $ 234,721 $ - $ 234,721 Total Resources $ 12,070,293 $ 88,536 $ 12,158,829 Requirements Community Development $ - $ _ $ _ Community Services $ - $ _ $ _ Policy and Administration $ 10,150,956 $ 88,536 $ 10,239,492 Public Works $ - $ _ $ _ Program Expenditures Total $ 10,150,956 $ 88,536 $ 10,239,492 Debt Service $ - $ - $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ - $ _ $ _ Transfers to Other Funds $ - $ - $ _ Contingency $ 429,000 $ - $ 429,000 Total Budget $ 10,579,956 $ 88,536 $ 10,668,492 Reserve For Future Expenditure $ 1,490,337 $ - $ 1,490,337 Total Requirements $ 12,070,293 $ 88,536 $ 12,158,829 Exhibit A QlFISO4 - River Terrace South and West Urban Growth Area Planning This will allow us to develop concept plans for the West and South River Terrace Urban Reserve Areas(URAs). MLG and the City of Tigard have agreed on the tasks needed to conceptually plan these URAs to satisfy Metro's Title 11 criteria for new urban growth areas and to lay an appropriate foundation for successful community planning in the future Requesting total of 3.0 FTE (1.0 FTE per division in the Finance Admin, CD Planning, and PW Engineering)to assist the development activity. Fund 3 of 3 FY 2020 Q1 Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 21,824,486 $ - $ 21,824,486 Property Taxes $ 17,121,416 $ - $ 17,121,416 Franchise Fees $ 6,254,627 $ - $ 6,254,627 Special Assessments $ _ $ _ $ - Licenses &Permits $ 1,186,521 $ - $ 1,186,521 Intergovernmental $ 7,347,865 $ - $ 7,347,865 Charges for Services $ 253,702 $ - $ 253,702 Fines &Forfeitures $ 1,654,498 $ - $ 1,654,498 Interest Earnings $ 500,900 $ - $ 500,900 Miscellaneous $ 56,432 $ 150,838 $ 207,270 Other Financing Sources $ - $ _ $ - Transfers In from Other Funds $ 292,900 $ - $ 292,900 Total Resources $ 56,493,347 $ 150,838 $ 56,644,185 Requirements Community Development $ 3,613,352 $ 150,838 $ 3,764,190 Community Services $ 25,919,480 $ - $ 25,919,480 Policy and Administration $ 1,054,831 $ - $ 1,054,831 Public Works $ - $ - $ _ Program Expenditures Total $ 30,587,663 $ 150,838 $ 30,738,501 Debt Service $ _ $ _ $ _ Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ 12,609 $ - $ 12,609 Transfers to Other Funds $ 2,611,477 $ - $ 2,611,477 Contingency $ 1,638,450 $ - $ 1,638,450 Total Budget $ 34,851,199 $ 150,838 $ 35,002,037 Reserve For Future Expenditure $ 21,642,148 $ - $ 21,642,148 Total Requirements $ 56,493,347 $ 150,838 $ 56,644,185 Exhibit A Q1FIS05-Budget Correction Entries Reclass 2 budget entries to correct fund/division/object code. -Entry to correct an indirect allocation entry incorrectly entered as a capital expenditure item in General Fund. This entry will reclass to Program Expenditures. -CIP 93057's capital expenditure was inadvertently split into two funds. Entry to move the capital expenditure in Stormwater Fund to Sanitary Sewer Fund. Fund 1 of 3 FY 2020 Q1 Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 21,824,486 $ - $ 21,824,486 Property Taxes $ 17,121,416 $ - $ 17,121,416 Franchise Fees $ 6,254,627 $ - $ 6,254,627 Special Assessments $ _ $ _ $ _ Licenses&Permits $ 1,186,521 $ - $ 1,186,521 Intergovernmental $ 7,347,865 $ - $ 7,347,865 Charges for Services $ 253,702 $ - $ 253,702 Fines&Forfeitures $ 1,654,498 $ - $ 1,654,498 Interest Earnings $ 500,900 $ - $ 500,900 Miscellaneous $ 56,432 $ - $ 56,432 Other Financing Sources $ - $ Transfers In from Other Funds $ 292,900 $ - $ 292,900 Total Resources $ 56,493,347 $ - $ 56,493,347 Requirements Community Development $ 3,613,352 $ - $ 3,613,352 Community Services $ 25,919,480 $ - $ 25,919,480 Policy and Administration $ 1,054,831 $ 12,609 $ 1,067,440 Public Works $ _ $ - $ _ Program Expenditures Total $ 30,587,663 $ 12,609 $ 30,600,272 Debt Service $ _ $ _ $ _ Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ 12,609 $ (12,609) $ - Transfers to Other Funds $ 2,611,477 $ - $ 2,611,477 Contingency $ 1,638,450 $ - $ 1638,450 Total Budget $ 34,851,199 $ - $ 34,851,199 Reserve For Future Expenditure $ 21,642,148 $ - $ 21,642,148 Total Requirements $ 56,493,347 $ - $ 56,493,347 Exhibit A Q1FIS05-Budget Correction Entries Reclass 2 budget entries to correct fund/division/object code. -Entry to correct an indirect allocation entry incorrectly entered as a capital expenditure item in General Fund. This entry will reclass to Program Expenditures. -CIP 93057's capital expenditure was inadvertently split into two funds. Entry to move the capital expenditure in Stormwater Fund to Sanitary Sewer Fund. Fund 2 of 3 FY 2020 Q1 Revised Stormwater Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 6,456,618 $ - $ 6,456,618 Property Taxes $ - $ _ $ _ Franchise Fees $ - $ _ $ _ Special Assessments $ - $ _ $ _ Licenses&Permits $ - $ _ $ _ Intergovernmental $ - $ _ $ _ Charges for Services $ 3,892,188 $ - $ 3,892,188 Fines&Forfeitures $ - $ _ $ _ Interest Earnings $ 139,900 $ - $ 139,900 Nliscellaneous $ 5,000 $ - $ 5,000 Other Financing Sources $ - $ _ $ _ Transfers In from Other Funds $ 704,000 $ - $ 704,000 Total Resources $ 11,197,706 $ - $ 11,197,706 Requirements Community Development $ - $ _ $ - Community Services $ - $ _ $ _ Policy and Administration $ - $ _ $ - Public Works $ 2,977,842 $ - $ 2,977,842 Program Expenditures Total $ 2,977,842 $ - $ 2,977,842 Debt Service $ - $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ 2,410,500 $ (74,000) $ 2,336,500 Transfers to Other Funds $ 311,550 $ 74,000 $ 385,550 Contingency $ 225,000 $ - $ 225,000 Total Budget $ 5,924,892 $ - $ 5,924,892 Reserve For Future Expenditure $ 5,272,814 $ - $ 5,272,814 Total Requirements $ 11,197,706 $ - $ 11,197,706 Exhibit A Q1FIS05-Budget Correction Entries Reclass 2 budget entries to correct fund/division/object code. -Entry to correct an indirect allocation entry incorrectly entered as a capital expenditure item in General Fund. This entry will reclass to Program Expenditures. -CIP 93057's capital expenditure was inadvertently split into two funds. Entry to move the capital expenditure in Stormwater Fund to Sanitary Sewer Fund. Fund 3 of 3 FY 2020 Q1 Revised Sanitary Sewer Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 4,903,060 $ - $ 4,903,060 Property Taxes $ - $ _ $ _ Franchise Fees $ _ $ _ $ _ Special Assessments $ - $ _ $ _ Licenses&Permits $ 92,200 $ - $ 92,200 Intergovernmental $ - $ _ $ _ Charges for Services $ 3,255,811 $ - $ 3,255,811 Fines&Forfeitures $ - $ _ $ _ Interest Earnings $ 110,300 $ - $ 110,300 Miscellaneous $ 42,100 $ - $ 42,100 Other Financing Sources $ - $ - $ _ Transfers In from Other Funds $ 243,750 $ 74,000 $ 317,750 Total Resources $ 8,647,221 $ 74,000 $ 8,721,221 Requirements Community Development $ - $ - $ - Community Services $ - $ _ $ _ Policy and Administration $ - $ _ $ _ Public Works $ 2,301,899 $ - $ 2,301,899 Program Expenditures Total $ 2,301,899 $ - $ 2,301,899 Debt Service $ - $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ 1,206,500 $ 74,000 $ 1,280,500 Transfers to Other Funds $ 659,200 $ - $ 659,200 Contingency $ 414,000 $ - $ 414,000 Total Budget $ 4,581,599 $ 74,000 $ 4,655,599 Reserve For Future Expenditure $ 4,065,622 $ - $ 4,065,622 Total Requirements $ 8,647,221 $ 74,000 $ 8,721,221 Exhibit A QlPD01-PD parking lot fencing and PD vehicle replacement Parking Lot Fencine The Police Department will be installing additional fencing and gating around the PD parking lot both for the patrol and personal vehicle areas.The partial enclosure of the parking lot is in direct response to a recent Criminal Justice Information Services(CJIS)audit conducted by the Oregon State Police. In order to safeguard sensitive and confidential information related to investigations as well as personnel,all police departments must comply with strict CAS standards. By installing two gates and additional fencing,the Police Department can move closer to adhering to CAS best practices. Police Vehicle Replacement In the early morning of August 20th, police vehicle#14-826 was involved in a crash during a police matter. No one was hurt,however the vehicle was almost past its useful life and sustained enough damage that the City's Fleet Manager recommends replacement.Our insurance carrier,CIS,is willing to pay out based on estimated repairs of$8,200,net of the$500 deductible.The total cost to replace the vehicle will be$35,100.After accounting for the insurance proceeds,the request from the general fund contingency is$26,900. FY 2020 Q1 Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 21,824,486 $ - $ 21,824,486 Property Taxes $ 17,121,416 $ - $ 17,121,416 Franchise Fees $ 6,254,627 $ - $ 6,254,627 Special Assessments $ - $ _ $ - Licenses&Permits $ 1,186,521 $ - $ 1,186,521 Intergovernmental $ 7,347,865 $ - $ 7,347,865 Charges for Services $ 253,702 $ - $ 253,702 Fines&Forfeitures $ 1,654,498 $ - $ 1,654,498 Interest Earnings $ 500,900 $ - $ 500,900 Miscellaneous $ 56,432 $ 8,200 $ 64,632 Other Financing Sources $ _ $ _ $ _ Transfers In from Other Funds $ 292,900 $ - $ 292,900 Total Resources $ 56,493,347 $ 8,200 $ 56,501,547 Requirements Community Development $ 3,613,352 $ - $ 3,613,352 Community Services $ 25,919,480 $ 43,600 $ 25,963,080 Policy and Administration $ 1,054,831 $ - $ 1,054,831 Public Works $ _ $ - $ _ Program Expenditures Total $ 30,587,663 $ 43,600 $ 30,631,263 Debt Service $ _ $ - $ _ Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ 12,609 $ - $ 12,609 Transfers to Other Funds $ 2,611,477 $ - $ 2,611,477 Contingency $ 1,638,450 $ (35,400) $ 1,603,050 Total Budget $ 34,851,199 $ 8,200 $ 34,859,399 Reserve For Future Expenditure $ 21,642,148 $ - $ 21,642,148 Total Requirements $ 56,493,347 $ 8,200 $ 56,501,547 Exhibit A Q1PW01- CIP 92034 Turd Street Heritage Trail Construction contract came in higher than anticipated. New ask from Parks SDC(425), $231,000 and Urban Forestry (260),$70,000. Carryforward grant dollars-$112,000 and unspent Parks SDC(425)-$31,000. Fund 1 of 3 FY 2020 Q1 Revised Urban Forestry Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,015,203 $ - $ 1,015,203 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines &Forfeitures $ - $ - $ - Interest Earnings $ 35,200 $ - $ 35,200 Miscellaneous $ 15,000 $ - $ 15,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 1,065,403 $ - $ 1,065,403 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 148,900 $ 70,000 $ 218,900 Contingency $ - $ - $ - Total Budget $ 148,900 $ 70,000 $ 218,900 Reserve For Future Expenditure $ 916,503 $ (70,000) $ 846,503 Total Requirements $ 1,065,403 $ - $ 1,065,403 Exhibit A Q1PW01- CIP 92034 Tigard Street Heritage Trail Construction contract came in higher than anticipated. New ask from Parks SDC(425),$231,000 and Urban Forestry (260),$70,000. Carryforward grant dollars-$112,000 and unspent Parks SDC(425)-$31,000. Fund 2 of 3 FY 2020 Q1 Revised Parks SDC Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 8,532,863 $ 262,000 $ 8,794,863 Property Taxes $ - $ _ $ _ Franchise Fees $ - $ _ $ _ Special Assessments $ - $ - $ _ Licenses &Permits $ 503,390 $ - $ 503,390 Intergovernmental $ - $ _ $ _ Charges for Services $ - $ - $ _ Fines &Forfeitures $ - $ - $ _ Interest Earnings $ 211,100 $ - $ 211,100 Miscellaneous $ - $ - $ _ Other Financing Sources $ - $ - $ _ Transfers In from Other Funds $ - $ - $ - Total Resources $ 9,247,353 $ 262,000 $ 9,509,353 Requirements Community Development $ - $ - $ _ Community Services $ - $ - $ _ Policy and Administration $ - $ - $ _ Public Works $ - $ - $ _ Program Expenditures Total $ - $ - $ _ Debt Service $ - $ - $ _ Loan to TCDA $ - $ _ $ _ Work-In-Progress $ - $ - $ _ Transfers to Other Funds $ 2,847,400 $ 262,000 $ 3,109,400 Contingency $ - $ _ $ _ Total Budget $ 2,847,400 $ 262,000 $ 3,109,400 Reserve For Future Expenditure $ 6,399,953 $ - $ 6,399,953 Total Requirements $ 9,247,353 $ 262,000 $ 9,509,353 Exhibit A 01PW01- CIP 92034 Tigard Street Heritage Trail Construction contract came in higher than anticipated. New ask from Parks SDC(425), $231,000 and Urban Forestry (260), $70,000. Carryforward grant dollars-$112,000 and unspent Parks SDC(425) -$31,000. Fund 3 of 3 FY 2020 Q1 Revised Parks Capital Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 880,000 $ - $ 880,000 Property Taxes $ - $ _ $ _ Franchise Fees $ - $ _ $ _ Special Assessments $ - $ _ $ _ Licenses &Permits $ - $ _ $ _ Intergovernmental $ 867,000 $ 112,000 $ 979,000 Charges for Services $ - $ _ $ _ Fines &Forfeitures $ - $ _ $ _ Interest Earnings $ - $ _ $ _ Miscellaneous $ - $ _ $ _ Other Financing Sources $ - $ _ $ _ Transfers In from Other Funds $ 3,707,000 $ 332,000 $ 4,039,000 Total Resources $ 5,454,000 $ 444,000 $ 5,898,000 Requirements Community Development $ - $ - $ _ Community Services $ - $ _ $ _ Policy and Administration $ - $ - $ _ Public Works $ - $ - $ _ Program Expenditures Total $ - $ _ $ _ Debt Service $ - $ _ $ _ Loan to TCDA $ - $ _ $ _ Work-In-Progress $ 4,709,500 $ 444,000 $ 5,153,500 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ - Total Budget $ 4,709,500 $ 444,000 $ 5,153,500 Reserve For Future Expenditure $ 744,500 $ - $ 744,500 Total Requirements $ 5,454,000 $ 444,000 $ 5,898,000 Exhibit A 01PW02- CIP 92034-02 Tigard Street Heritage Plaza Outdoor Museum Contract was executed in FY19 but the vast majority of the work be performed in FY20. Fund 1 of 2 FY 2020 Q1 Revised Transient Lodging Tax Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 452,598 $ 29,166 $ 481,764 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ 683,920 $ - $ 683,920 Charges for Services $ - $ - $ - Fines &Forfeitures $ - $ - $ - Interest Earnings $ 4,800 $ - $ 4,800 Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 1,141,318 $ 29,166 $ 1,170,484 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 344,900 $ 29,166 $ 374,066 Contingency $ - $ - $ - Total Budget $ 344,900 $ 29,166 $ 374,066 Reserve For Future Expenditure $ 796,418 $ - $ 796,418 Total Requirements $ 1,141,318 $ 29,166 $ 1,170,484 Exhibit A Q1PW02 - CIP 92034-02 Tigard Street Heritage Plaza Outdoor Museum Contract was executed in FY19 but the vast majority of the work be performed in FY20. Fund 2 of 2 FY 2020 Q1 Revised Parks Capital Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 880,000 $ - $ 880,000 Property Taxes $ - $ _ $ _ Franchise Fees $ - $ - $ Special Assessments $ - $ - $ _ Licenses &Permits $ - $ - $ _ Intergovernmental $ 867,000 $ 58,000 $ 925,000 Charges for Services $ - $ - $ _ Fines &Forfeitures $ - $ - $ _ Interest Earnings $ - $ _ $ _ Miscellaneous $ - $ - $ _ Other Financing Sources $ - $ - $ _ Transfers In from Other Funds $ 3,707,000 $ 29,166 $ 3,736,166 Total Resources $ 5,454,000 $ 87,166 $ 5,541,166 Requirements Community Development $ - $ - $ _ Community Services $ - $ - $ Policy and Administration $ - $ - $ _ Public Works $ - $ - $ _ Program Expenditures Total $ - $ - $ _ Debt Service $ - $ - $ _ Loan to TCDA $ - $ - $ - Work-In-Progress $ 4,709,500 $ 87,166 $ 4,796,666 Transfers to Other Funds $ - $ - $ _ Contingency $ - $ - $ - Total Budget $ 4,709,500 $ 87,166 $ 4,796,666 Reserve For Future Expenditure $ 744,500 $ - $ 744,500 Total Requirements $ 5,454,000 $ 87,166 $ 5,541,166 Exhibit A Q1PW03 - CIP 92046 Fanno Creek Trail Connection (RFFA Gran Carryforward of prior year appropriations impacting Transportation SDC and Parks SDC. Required partner payments to ODOT were delayed due to the revision in the 30% plans to meet project budget constraints, delaying the 60%and 90% phases. Fund 1 of 3 FY 2020 Q1 Revised Transportation SDC Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 7,289,996 $ 78,000 $ 7,367,996 Property Taxes $ _ $ - $ - Franchise Fees $ _ $ _ $ Special Assessments $ _ $ _ $ _ Licenses &Permits $ 409,500 $ - $ 409,500 Intergovernmental $ - $ _ $ - Charges for Services $ _ $ _ $ _ Fines &Forfeitures $ _ $ _ $ _ Interest Earnings $ 144,000 $ - $ 144,000 Miscellaneous $ _ $ _ $ _ Other Financing Sources $ _ $ _ $ _ Transfers In from Other Funds $ - $ _ $ _ Total Resources $ 7,843,496 $ 78,000 $ 7,921,496 Requirements Community Development $ - $ _ $ _ Community Services $ _ $ _ $ _ Policy and Administration $ - $ _ $ _ Public Works $ _ $ _ $ _ Program Expenditures Total $ - $ _ $ _ Debt Service $ _ $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ - $ _ $ - Transfers to Other Funds $ 209,000 $ 78,000 $ 287,000 Contingency $ _ $ _ $ - Total Budget $ 209,000 $ 78,000 $ 287,000 Reserve For Future Expenditure $ 7,634,496 $ - $ 7,634,496 Total Requirements $ 7,843,496 $ 78,000 $ 7,921,496 Exhibit A Q1PW03 - CIP 92046 Fanno Creek Trail Connection (RFFA Grant) Carryforward of prior year appropriations impacting Transportation SDC and Parks SDC. Required partner payments to ODOT were delayed due to the revision in the 30%plans to meet project budget constraints, delaying the 60%and 90% phases. Fund 2 of 3 FY 2020 Q1 Revised Parks SDC Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 8,532,863 $ 109,000 $ 8,641,863 Property Taxes $ - $ - $ - Franchise Fees $ _ $ _ $ _ Special Assessments $ _ $ _ $ - Licenses &Permits $ 503,390 $ - $ 503,390 Intergovernmental $ _ $ _ $ _ Charges for Services $ _ $ _ $ _ Fines &Forfeitures $ _ $ _ $ _ Interest Earnings $ 211,100 $ - $ 211,100 Miscellaneous $ _ $ _ $ _ Other Financing Sources $ - $ _ $ _ Transfers In from Other Funds $ - $ _ $ _ Total Resources $ 9,247,353 $ 109,000 $ 9,356,353 Requirements Community Development $ - $ _ $ _ Community Services $ _ $ _ $ _ Policy and Administration $ _ $ _ $ _ Public Works $ _ $ _ $ _ Program Expenditures Total $ _ $ _ $ _ Debt Service $ _ $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 2,847,400 $ 109,000 $ 2,956,400 Contingency $ _ $ _ $ - Total Budget $ 2,847,400 $ 109,000 $ 2,956,400 Reserve For Future Expenditure $ 6,399,953 $ - $ 6,399,953 Total Requirements $ 9,247,353 $ 109,000 $ 9,356,353 Exhibit A Q1PW03 - CIP 92046 Fanno Creek Trail Connection (RFFA Grant) Carryforward of prior year appropriations impacting Transportation SDC and Parks SDC. Required partner payments to ODOT were delayed due to the revision in the 30% plans to meet project budget constraints, delaying the 60%and 90% phases. Fund 3 of 3 FY 2020 Q1 Revised Parks Capital Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 880,000 $ - $ 880,000 Property Taxes $ - $ _ $ _ Franchise Fees $ - $ - $ _ Special Assessments $ - $ - $ _ Licenses &Permits $ - $ - $ _ Intergovernmental $ 867,000 $ - $ 867,000 Charges for Services $ - $ - $ _ Fines &Forfeitures $ - $ _ $ _ Interest Earnings $ - $ - $ _ Miscellaneous $ - $ _ $ _ Other Financing Sources $ - $ - $ _ Transfers In from Other Funds $ 3,707,000 $ 187,000 $ 3,894,000 Total Resources $ 5,454,000 $ 187,000 $ 5,641,000 Requirements Community Development $ - $ - $ - Community Services $ - $ _ $ _ Policy and Administration $ - $ - $ _ Public Works $ - $ _ $ _ Program Expenditures Total $ - $ - $ _ Debt Service $ - $ - $ _ Loan to TCDA $ - $ - $ _ Work-In-Progress $ 4,709,500 $ 187,000 $ 4,896,500 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ _ Total Budget $ 4,709,500 $ 187,000 $ 4,896,500 Reserve For Future Expenditure $ 744,500 $ - $ 744,500 Total Requirements $ 5,454,000 $ 187,000 $ 5,641,000 Exhibit A Q1PW04- CIP 92055 Americans with Disabilities Act Transition Plan Carryforward of prior year appropriations impacting General Fund,Gas Tax,and Parks SDC. Project finalization and adoption process took longer than expected, requiring a carryforward. Fund 1 of 4 FY 2020 Q1 Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 21,824,486 $ 5,500 $ 21,829,986 Property Taxes $ 17,121,416 $ - $ 17,121,416 Franchise Fees $ 6,254,627 $ - $ 6,254,627 Special Assessments $ - $ _ $ _ Licenses &Permits $ 1,186,521 $ - $ 1,186,521 Intergovernmental $ 7,347,865 $ - $ 7,347,865 Charges for Services $ 253,702 $ - $ 253,702 Fines &Forfeitures $ 1,654,498 $ - $ 1,654,498 Interest Earnings $ 500,900 $ - $ 500,900 Miscellaneous $ 56,432 $ - $ 56,432 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 292,900 $ - $ 292,900 Total Resources $ 56,493,347 $ 5,500 $ 56,498,847 Requirements Community Development $ 3,613,352 $ - $ 3,613,352 Community Services $ 25,919,480 $ - $ 25,919,480 Policy and Administration $ 1,054,831 $ - $ 1,054,831 Public Works $ - $ _ $ _ Program Expenditures Total $ 30,587,663 $ - $ 30,587,663 Debt Service $ _ $ _ $ _ Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ 12,609 $ - $ 12,609 Transfers to Other Funds $ 2,611,477 $ 5,500 $ 2,616,977 Contingency $ 1,638,450 $ - $ 1,638,450 Total Budget $ 34,851,199 $ 5,500 $ 34,856,699 Reserve For Future Expenditure $ 21,642,148 $ - $ 21,642,148 Total Requirements $ 56,493,347 $ 5,500 $ 56,498,847 Exhibit A Q1PW04- CIP 92055 Americans with Disabilities Act Transition Plan Carryforward of prior year appropriations impacting General Fund,Gas Tax,and Parks SDC. Project finalization and adoption process took longer than expected, requiring a carryforward. Fund 2 of 4 FY 2020 Q1 Revised Gas Tax Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 2,960,484 $ 15,500 $ 2,975,984 Property Taxes $ - $ _ $ - Franchise Fees $ - $ - $ _ Special Assessments $ - $ - $ - Licenses &Permits $ 65,965 $ - $ 65,965 Intergovernmental $ 4,381,236 $ - $ 4,381,236 Charges for Services $ - $ - $ _ Fines &Forfeitures $ - $ - $ _ Interest Earnings $ 82,400 $ - $ 82,400 Miscellaneous $ 62,818 $ - $ 62,818 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 158,000 $ - $ 158,000 Total Resources $ 7,710,903 $ 15,500 $ 7,726,403 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 3,760,480 $ - $ 3,760,480 Program Expenditures Total $ 3,760,480 $ - $ 3,760,480 Debt Service $ 577,230 $ - $ 577,230 Loan to TCDA $ - $ _ $ _ Work-In-Progress $ - $ - $ _ Transfers to Other Funds $ 2,131,900 $ 15,500 $ 2,147,400 Contingency $ 222,000 $ - $ 222,000 Total Budget $ 6,691,610 $ 15,500 $ 6,707,110 Reserve For Future Expenditure $ 1,019,293 $ - $ 1,019,293 Total Requirements $ 7,710,903 $ 15,500 $ 7,726,403 Exhibit A Q1PW04 - CIP 92055 Americans with Disabilities Act Transition Plan Carryforward of prior year appropriations impacting General Fund,Gas Tax,and Parks SDC. Project finalization and adoption process took longer than expected, requiring a carryforward. Fund 3 of 4 FY 2020 Q1 Revised Parks SDC Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 8,532,863 $ 9,000 $ 8,541,863 Property Taxes $ _ $ _ $ _ Franchise Fees $ _ $ _ $ _ Special Assessments $ _ $ _ $ _ Licenses &Permits $ 503,390 $ - $ 503,390 Intergovernmental $ - $ _ $ _ Charges for Services $ _ $ _ $ _ Fines &Forfeitures $ _ $ _ $ _ Interest Earnings $ 211,100 $ - $ 211,100 Miscellaneous $ - $ _ $ _ Other Financing Sources $ _ $ _ $ _ Transfers In from Other Funds $ - $ _ $ _ Total Resources $ 9,247,353 $ 9,000 $ 9,256,353 Requirements Community Development $ - $ - $ _ Community Services $ _ $ _ $ _ Policy and Administration $ _ $ _ $ _ Public Works $ _ $ _ $ _ Program Expenditures Total $ _ $ _ $ _ Debt Service $ _ $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ _ $ _ $ _ Transfers to Other Funds $ 2,847,400 $ 9,000 $ 2,856,400 Contingency $ - $ - $ _ Total Budget $ 2,847,400 $ 9,000 $ 2,856,400 Reserve For Future Expenditure $ 6,399,953 $ - $ 6,399,953 Total Requirements $ 9,247,353 $ 9,000 $ 9,256,353 Exhibit A Q1PW04- CIP 92055 Americans with Disabilities Act Transition Plan Carryforward of prior year appropriations impacting General Fund, Gas Tax,and Parks SDC. Project finalization and adoption process took longer than expected, requiring a carryforward. Fund 4 of 4 FY 2020 Q1 Revised Parks Capital Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 880,000 $ - $ 880,000 Property Taxes $ _ $ _ $ - Franchise Fees $ _ $ _ $ Special Assessments $ _ $ _ $ _ Licenses &Permits $ _ $ _ $ Intergovernmental $ 867,000 $ - $ 867,000 Charges for Services $ _ $ _ $ _ Fines&Forfeitures $ _ $ _ $ Interest Earnings $ _ $ _ $ _ Miscellaneous $ _ $ _ $ _ Other Financing Sources $ _ $ _ $ - Transfers In from Other Funds $ 3,707,000 $ 30,000 $ 3,737,000 Total Resources $ 5,454,000 $ 30,000 $ 5,484,000 Requirements Community Development $ - $ _ $ _ Community Services $ _ $ _ $ _ Policy and Administration $ _ $ _ $ _ Public Works $ _ $ _ $ _ Program Expenditures Total $ _ $ _ $ _ Debt Service $ _ $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ 4,709,500 $ 30,000 $ 4,739,500 Transfers to Other Funds $ - $ _ $ _ Contingency $ _ $ _ $ _ Total Budget $ 4,709,500 $ 30,000 $ 4,739,500 Reserve For Future Expenditure $ 744,500 $ - $ 744,500 Total Requirements $ 5,454,000 $ 30,000 $ 5,484,000 Exhibit A Q1PW05 - CIP 92056 Park System Master Plan Carryforward of prior year appropriations impacting Parks SDC. Project start was delayed due to staff workload constraints. Fund 1 of 2 FY 2020 Q1 Revised Parks SDC Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 8,532,863 $ 44,000 $ 8,576,863 Property Taxes $ _ $ - $ - Franchise Fees $ _ $ _ $ _ Special Assessments $ _ $ _ $ - Licenses &Permits $ 503,390 $ - $ 503,390 Intergovernmental $ _ $ _ $ _ Charges for Services $ _ $ _ $ _ Fines &Forfeitures $ _ $ _ $ _ Interest Earnings $ 211,100 $ - $ 211,100 Miscellaneous $ - $ _ $ _ Other Financing Sources $ - $ _ $ _ Transfers In from Other Funds $ - $ _ $ _ Total Resources $ 9,247,353 $ 44,000 $ 9,291,353 Requirements Community Development $ - $ _ $ _ Community Services $ _ $ _ $ _ Policy and Administration $ _ $ _ $ _ Public Works $ _ $ _ $ _ Program Expenditures Total $ _ $ _ $ Debt Service $ _ $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ _ $ _ $ - Transfers to Other Funds $ 2,847,400 $ 44,000 $ 2,891,400 Contingency $ _ $ _ $ - Total Budget $ 2,847,400 $ 44,000 $ 2,891,400 Reserve For Future Expenditure $ 6,399,953 $ - $ 6,399,953 Total Requirements $ 9,247,353 $ 44,000 $ 9,291,353 Exhibit A Q1PW05 - CIP 92056 Park System Master Plan Carryforward of prior year appropriations impacting Parks SDC. Project start was delayed due to staff workload constraints. Fund 2 of 2 FY 2020 Q1 Revised Parks Capital Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 880,000 $ - $ 880,000 Property Taxes $ - $ _ $ - Franchise Fees $ - $ _ $ _ Special Assessments $ - $ _ $ _ Licenses &Permits $ - $ _ $ _ Intergovernmental $ 867,000 $ - $ 867,000 Charges for Services $ - $ _ $ - Fines &Forfeitures $ - $ _ $ Interest Earnings $ - $ _ $ _ Miscellaneous $ - $ _ $ _ Other Financing Sources $ - $ - $ _ Transfers In from Other Funds $ 3,707,000 $ 44,000 $ 3,751,000 Total Resources $ 5,454,000 $ 44,000 $ 5,498,000 Requirements Community Development $ - $ - $ _ Community Services $ - $ _ $ _ Policy and Administration $ - $ _ $ _ Public Works $ _ $ _ $ _ Program Expenditures Total $ _ $ _ $ Debt Service $ _ $ _ $ _ Loan to TCDA $ - $ _ $ _ Work-In-Progress $ 4,709,500 $ 44,000 $ 4,753,500 Transfers to Other Funds $ - $ _ $ - Contingency $ - $ - $ - Total Budget $ 4,709,500 $ 44,000 $ 4,753,500 Reserve For Future Expenditure $ 744,500 $ - $ 744,500 Total Requirements $ 5,454,000 $ 44,000 $ 5,498,000 Exhibit A 01PW06 - CIP 92057 Fanno Creek Trail Amenities Carryforward of prior year appropriations impacting Parks SDC. This project is connected to the Fanno Creek Trail CIP 92046,which was delayed. Fund 1 of 2 FY 2020 Q1 Revised Parks SDC Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 8,532,863 $ 22,000 $ 8,554,863 Property Taxes $ _ $ _ $ _ Franchise Fees $ _ $ _ $ _ Special Assessments $ _ $ _ $ _ Licenses &Permits $ 503,390 $ - $ 503,390 Intergovernmental $ - $ _ $ - Charges for Services $ - $ _ $ _ Fines &Forfeitures $ _ $ _ $ _ Interest Earnings $ 211,100 $ - $ 211,100 Miscellaneous $ _ $ _ $ _ Other Financing Sources $ - $ _ $ _ Transfers In from Other Funds $ - $ - $ - Total Resources $ 9,247,353 $ 22,000 $ 9,269,353 Requirements Community Development $ - $ _ $ _ Community Services $ - $ _ $ _ Policy and Administration $ _ $ _ $ _ Public Works $ _ $ _ $ _ Program Expenditures Total $ _ $ _ $ _ Debt Service $ _ $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ _ $ _ $ - Transfers to Other Funds $ 2,847,400 $ 22,000 $ 2,869,400 Contingency $ _ $ - $ - Total Budget $ 2,847,400 $ 22,000 $ 2,869,400 Reserve For Future Expenditure $ 6,399,953 $ - $ 6,399,953 Total Requirements $ 9,247,353 $ 22,000 $ 9,269,353 Exhibit A 01PW06 - CIP 92057 Fanno Creek Trail Amenities Carryforward of prior year appropriations impacting Parks SDC. This project is connected to the Fanno Creek Trail CIP 92046,which was delayed. Fund 2 of 2 FY 2020 Q1 Revised Parks Capital Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 880,000 $ - $ 880,000 Property Taxes $ - $ _ $ - Franchise Fees $ - $ _ $ _ Special Assessments $ - $ _ $ _ Licenses &Permits $ - $ _ $ _ Intergovernmental $ 867,000 $ - $ 867,000 Charges for Services $ - $ _ $ _ Fines &Forfeitures $ - $ _ $ _ Interest Earnings $ _ $ _ $ _ Miscellaneous $ - $ _ $ Other Financing Sources $ - $ _ $ _ Transfers In from Other Funds $ 3,707,000 $ 22,000 $ 3,729,000 Total Resources $ 5,454,000 $ 22,000 $ 5,476,000 Requirements Community Development $ - $ - $ _ Community Services $ - $ _ $ Policy and Administration $ - $ _ $ _ Public Works $ - $ _ $ _ Program Expenditures Total $ - $ _ $ _ Debt Service $ _ $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ 4,709,500 $ 22,000 $ 4,731,500 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ - Total Budget $ 4,709,500 $ 22,000 $ 4,731,500 Reserve For Future Expenditure $ 744,500 $ - $ 744,500 Total Requirements $ 5,454,000 $ 22,000 $ 5,476,000 Exhibit A Q1PW07 - CIP 94038124th Avenue / Ann Court Culvert Replacement Construction contract came in higher than anticipated. New ask from Stormwater. FY 2020 Q1 Revised Stormwater Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 6,456,618 $ 40,000 $ 6,496,618 Property Taxes $ _ $ _ $ - Franchise Fees $ _ $ _ $ _ Special Assessments $ _ $ _ $ _ Licenses &Permits $ _ $ _ $ _ Intergovernmental $ _ $ _ $ _ Charges for Services $ 3,892,188 $ - $ 3,892,188 Fines &Forfeitures $ _ $ _ $ _ Interest Earnings $ 139,900 $ - $ 139,900 Miscellaneous $ 5,000 $ - $ 5,000 Other Financing Sources $ _ $ _ $ _ Transfers In from Other Funds $ 704,000 $ - $ 704,000 Total Resources $ 11,197,706 $ 40,000 $ 11,237,706 Requirements Community Development $ _ $ _ $ - Community Services $ _ $ _ $ _ Policy and Administration $ _ $ _ $ - Public Works $ 2,977,842 $ - $ 2,977,842 Program Expenditures Total $ 2,977,842 $ - $ 2,977,842 Debt Service $ _ $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ 2,410,500 $ 40,000 $ 2,450,500 Transfers to Other Funds $ 311,550 $ - $ 311,550 Contingency $ 225,000 $ - $ 225,000 Total Budget $ 5,924,892 $ 40,000 $ 5,964,892 Reserve For Future Expenditure $ 5,272,814 $ - $ 5,272,814 Total Requirements $ 11,197,706 $ 40,000 $ 11,237,706 Exhibit A 41PW08 - CIP 94041 Frewing Street Stormline Replacement Scope of project has increased to provide for a more complete stormwater management project. This increased scope will require land acquisition, increased design and increased construction costs. New ask from Stormwater.This project will also require an additional appropriation in FY2021. FY 2020 Q1 Revised Stormwater Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 6,456,618 $ 126,000 $ 6,582,618 Property Taxes $ _ $ _ $ - Franchise Fees $ _ $ _ $ _ Special Assessments $ _ $ _ $ _ Licenses &Permits $ _ $ _ $ _ Intergovernmental $ _ $ _ $ _ Charges for Services $ 3,892,188 $ - $ 3,892,188 Fines &Forfeitures $ _ $ _ $ _ Interest Earnings $ 139,900 $ - $ 139,900 Miscellaneous $ 5,000 $ - $ 5,000 Other Financing Sources $ _ $ _ $ - Transfers In from Other Funds $ 704,000 $ - $ 704,000 Total Resources $ 11,197,706 $ 126,000 $ 11,323,706 Requirements Community Development $ _ $ _ $ - Community Services $ _ $ _ $ _ Policy and Administration $ _ $ _ $ - Public Works $ 2,977,842 $ - $ 2,977,842 Program Expenditures Total $ 2,977,842 $ - $ 2,977,842 Debt Service $ _ $ _ $ _ Loan to TCDA $ - $ _ $ _ Work-In-Progress $ 2,410,500 $ 126,000 $ 2,536,500 Transfers to Other Funds $ 311,550 $ - $ 311,550 Contingency $ 225,000 $ - $ 225,000 Total Budget $ 5,924,892 $ 126,000 $ 6,050,892 Reserve For Future Expenditure $ 5,272,814 $ - $ 5,272,814 Total Requirements $ 14197,706 $ 126,000 $ 11,323,706 Exhibit A Q1PW09 - CIP 95057 Fanno Creek Alignment Study Bonita Road to Tualatin River) Carryforward of prior year appropriations impacting a Metro Grant and Transportation SDC. Project was delayed because PM was on leave. Fund 1 of 2 FY 2020 Q1 Revised Transportation SDC Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 7,289,996 $ 12,000 $ 7,301,996 Property Taxes $ - $ - $ - Franchise Fees $ - $ _ $ Special Assessments $ - $ _ $ - Licenses &Permits $ 409,500 $ - $ 409,500 Intergovernmental $ _ $ _ $ - Charges for Services $ - $ _ $ _ Fines &Forfeitures $ - $ - $ - Interest Earnings $ 144,000 $ - $ 144,000 Miscellaneous $ - $ _ $ - Other Financing Sources $ - $ _ $ _ Transfers In from Other Funds $ - $ - $ _ Total Resources $ 7,843,496 $ 12,000 $ 7,855,496 Requirements Community Development $ - $ _ $ _ Community Services $ - $ _ $ _ Policy and Administration $ - $ _ $ _ Public Works $ _ $ _ $ _ Program Expenditures Total $ - $ _ $ _ Debt Service $ _ $ _ $ _ Loan to TCDA $ - $ _ $ _ Work-In-Progress $ _ $ _ $ - Transfers to Other Funds $ 209,000 $ 12,000 $ 221,000 Contingency $ _ $ - $ - Total Budget $ 209,000 $ 12,000 $ 221,000 Reserve For Future Expenditure $ 7,634,496 $ - $ 7,634,496 Total Requirements $ 7,843,496 $ 12,000 $ 7,855,496 Exhibit A Q1PW09 - CIP 95057 Fanno Creek Alignment Study (Bonita Road to Tualatin River) Carryforward of prior year appropriations impacting a Metro Grant and Transportation SDC. Project was delayed because PM was on leave. Fund 2 of 2 FY 2020 Q1 Revised Transportation CIP Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 820,000 $ - $ 820,000 Property Taxes $ _ $ _ $ - Franchise Fees $ _ $ _ $ _ Special Assessments $ _ $ _ $ _ Licenses &Permits $ _ $ _ $ _ Intergovernmental $ 1,038,200 $ 115,000 $ 1,153,200 Charges for Services $ _ $ _ $ - Fines & Forfeitures $ _ $ _ $ _ Interest Earnings $ _ $ _ $ _ Miscellaneous $ _ $ _ $ _ Other Financing Sources $ _ $ _ $ - Transfers In from Other Funds $ 4,093,200 $ 12,000 $ 4,105,200 Total Resources $ 5,951,400 $ 127,000 $ 6,078,400 Requirements Community Development $ - $ _ $ _ Community Services $ - $ _ $ _ Policy and Administration $ - $ _ $ _ Public Works $ _ $ _ $ _ Program Expenditures Total $ - $ _ $ _ Debt Service $ _ $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ 5,231,400 $ 127,000 $ 5,358,400 Transfers to Other Funds $ - $ _ $ _ Contingency $ _ $ _ $ _ Total Budget $ 5,231,400 $ 127,000 $ 5,358,400 Reserve For Future Expenditure $ 720,000 $ - $ 720,000 Total Requirements $ 5,951,400 $ 127,000 $ 6,078,400 Exhibit A Q1PW10 - CIP 96050 Former Street / 121st Avenue Valve and Piping Improvements Carryforward of prior year appropriations impacting Water Fund. New ask from Water, $11k and Water SDC Fund,$36k driven by higher than anticipated design costs. Project needs to be coordinated with 121st Avenue improvements and must meet the County's design time line. Fund 1 of 3 FY 2020 Q1 Revised Water Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 30,807,424 $ 54,000 $ 30,861,424 Property Taxes $ - $ - $ _ Franchise Fees $ - $ - $ Special Assessments $ - $ - $ _ Licenses &Permits $ 170,000 $ - $ 170,000 Intergovernmental $ 15,000 $ - $ 15,000 Charges for Services $ 22,405,446 $ - $ 22,405,446 Fines &Forfeitures $ - $ - $ _ Interest Earnings $ 500,700 $ - $ 500,700 Miscellaneous $ 50,000 $ - $ 50,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ _ Total Resources $ 53,948,570 $ 54,000 $ 54,002,570 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ _ Policy and Administration $ - $ - $ - Public Works $ 10,246,079 $ - $ 10,246,079 Program Expenditures Total $ 10,246,079 $ - $ 10,246,079 Debt Service $ - $ _ $ _ Loan to TCDA $ - $ _ $ _ Work-In-Progress $ - $ _ $ _ Transfers to Other Funds $ 10,651,600 $ 54,000 $ 10,705,600 Contingency $ 539,000 $ - $ 539,000 Total Budget $ 21,436,679 $ 54,000 $ 21,490,679 Reserve For Future Expenditure $ 32,511,891 $ - $ 32,511,891 Total Requirements $ 53,948,570 $ 54,000 $ 54,002,570 Exhibit A Q1PW10- CIP 96050 Former Street / 121st Avenue Valve and Piping Improvements Carryforward of prior year appropriations impacting Water Fund. New ask from Water, $11k and Water SDC Fund, $36k driven by higher than anticipated design costs. Project needs to be coordinated with 121st Avenue improvements and must meet the County's design time line. Fund 2 of 3 FY 2020 Q1 Revised Water SDC Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 12,052,538 $ 36,000 $ 12,088,538 Property Taxes $ - $ _ $ - Franchise Fees $ _ $ _ $ _ Special Assessments $ - $ _ $ - Licenses &Permits $ 1,276,200 $ - $ 1,276,200 Intergovernmental $ - $ _ $ - Charges for Services $ _ $ _ $ _ Fines &Forfeitures $ - $ _ $ _ Interest Earnings $ 258,200 $ - $ 258,200 Miscellaneous $ _ $ _ $ _ Other Financing Sources $ - $ _ $ _ Transfers In from Other Funds $ - $ _ $ _ Total Resources $ 13,586,938 $ 36,000 $ 13,622,938 Requirements Community Development $ - $ - $ - Community Services $ - $ _ $ _ Policy and Administration $ _ $ _ $ _ Public Works $ _ $ _ $ _ Program Expenditures Total $ _ $ _ $ _ Debt Service $ _ $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ _ $ - $ - Transfers to Other Funds $ 2,170,000 $ 36,000 $ 2,206,000 Contingency $ _ $ - $ - Total Budget $ 2,170,000 $ 36,000 $ 2,206,000 Reserve For Future Expenditure $ 11,416,938 $ - $ 11,416,938 Total Requirements $ 13,586,938 $ 36,000 $ 13,622,938 Exhibit A Q1PW10 - CIP 96050 Former Street / 121st Avenue Valve and Piping Improvements Carryforward of prior year appropriations impacting Water Fund. New ask from Water, $11k and Water SDC Fund, $36k driven by higher than anticipated design costs. Project needs to be coordinated with 121st Avenue improvements and must meet the County's design time line. Fund 3 of 3 FY 2020 Q1 Revised Water CIP Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,530,000 $ - $ 1,530,000 Property Taxes $ _ $ _ $ - Franchise Fees $ _ $ _ $ _ Special Assessments $ _ $ _ $ _ Licenses &Permits $ - $ _ $ _ Intergovernmental $ _ $ _ $ _ Charges for Services $ - $ _ $ _ Fines &Forfeitures $ - $ _ $ _ Interest Earnings $ _ $ _ $ _ Miscellaneous $ - $ _ $ _ Other Financing Sources $ - $ _ $ - Transfers In from Other Funds $ 4,304,500 $ 90,000 $ 4,394,500 Total Resources $ 5,834,500 $ 90,000 $ 5,924,500 Requirements Community Development $ - $ _ $ _ Community Services $ - $ _ $ _ Policy and Administration $ - $ _ $ _ Public Works $ _ $ _ $ _ Program Expenditures Total $ _ $ _ $ _ Debt Service $ _ $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ 4,304,500 $ 90,000 $ 4,394,500 Transfers to Other Funds $ - $ _ $ _ Contingency $ _ $ _ $ _ Total Budget $ 4,304,500 $ 90,000 $ 4,394,500 Reserve For Future Expenditure $ 1,530,000 $ - $ 1,530,000 Total Requirements $ 5,834,500 $ 90,000 $ 5,924,500 Exhibit A Q1PW11-Vacation Cashout for Parks and Streets Manager Cashout of PTO of long time Parks and Street Manager. Split between Parks Utility, Gas Tax, and Stormwater. Fund 1 of 3 FY 2020 Q1 Revised Gas Tax Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 2,960,484 $ - $ 2,960,484 Property Taxes $ - $ - $ _ Franchise Fees $ - $ _ $ _ Special Assessments $ - $ - $ _ Licenses &Permits $ 65,965 $ - $ 65,965 Intergovernmental $ 4,381,236 $ - $ 4,381,236 Charges for Services $ - $ _ $ _ Fines &Forfeitures $ - $ - $ _ Interest Earnings $ 82,400 $ - $ 82,400 Miscellaneous $ 62,818 $ - $ 62,818 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 158,000 $ - $ 158,000 Total Resources $ 7,710,903 $ - $ 7,710,903 Requirements Community Development $ - $ - $ Community Services $ - $ _ $ _ Policy and Administration $ - $ - $ _ Public Works $ 3,760,480 $ 7,350 $ 3,767,830 Program Expenditures Total $ 3,760,480 $ 7,350 $ 3,767,830 Debt Service $ 577,230 $ - $ 577,230 Loan to TCDA $ - $ _ $ _ Work-In-Progress $ - $ _ $ _ Transfers to Other Funds $ 2,131,900 $ - $ 2,131,900 Contingency $ 222,000 $ (7,350) $ 214,650 Total Budget $ 6,691,610 $ - $ 6,691,610 Reserve For Future Expenditure $ 1,019,293 $ - $ 1,019,293 Total Requirements $ 7,710,903 $ - $ 7,710,903 Exhibit A 01PW11-Vacation Cashout for Parks and Streets Manager Cashout of PTO of long time Parks and Street Manager. Split between Parks Utility, Gas Tax, and Stormwater. Fund 2 of 3 FY 2020 Q1 Revised Parks Utility Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,452,584 $ - $ 1,452,584 Property Taxes $ - $ - $ _ Franchise Fees $ - $ - $ _ Special Assessments $ - $ - $ _ Licenses &Permits $ 1,790,593 $ - $ 1,790,593 Intergovernmental $ - $ _ $ - Charges for Services $ 90,750 $ - $ 90,750 Fines &Forfeitures $ - $ _ $ _ Interest Earnings $ 3,300 $ - $ 3,300 Miscellaneous $ - $ _ $ _ Other Financing Sources $ - $ - $ _ Transfers In from Other Funds $ 2,213,770 $ - $ 2,213,770 Total Resources $ 5,550,997 $ - $ 5,550,997 Requirements Community Development $ - $ - $ - Community Services $ - $ _ $ _ Policy and Administration $ - $ - $ _ Public Works $ 3,807,739 $ 14,700 $ 3,822,439 Program Expenditures Total $ 3,807,739 $ 14,700 $ 3,822,439 Debt Service $ _ $ _ $ _ Loan to TCDA $ - $ _ $ _ Work-In-Progress $ - $ _ $ _ Transfers to Other Funds $ 61,538 $ - $ 61,538 Contingency $ 135,000 $ (14,700) $ 120,300 Total Budget $ 4,004,277 $ - $ 4,004,277 Reserve For Future Expenditure $ 1,546,720 $ - $ 1,546,720 Total Requirements $ 5,550,997 $ - $ 5,550,997 Exhibit A 01PW11-Vacation Cashout for Parks and Streets Manager Cashout of PTO of long time Parks and Street Manager. Split between Parks Utility, Gas Tax, and Stormwater. Fund 3 of 3 FY 2020 Q1 Revised Stormwater Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 6,456,618 $ - $ 6,456,618 Property Taxes $ - $ _ $ _ Franchise Fees $ - $ _ $ _ Special Assessments $ - $ _ $ _ Licenses &Permits $ - $ _ $ _ Intergovernmental $ - $ _ $ _ Charges for Services $ 3,892,188 $ - $ 3,892,188 Fines &Forfeitures $ - $ _ $ _ Interest Earnings $ 139,900 $ - $ 139,900 Miscellaneous $ 5,000 $ - $ 5,000 Other Financing Sources $ - $ - $ _ Transfers In from Other Funds $ 704,000 $ - $ 704,000 Total Resources $ 11,197,706 $ - $ 11,197,706 Requirements Community Development $ - $ - $ _ Community Services $ - $ _ $ _ Policy and Administration $ - $ _ $ _ Public Works $ 2,977,842 $ 7,350 $ 2,985,192 Program Expenditures Total $ 2,977,842 $ 7,350 $ 2,985,192 Debt Service $ - $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ 2,410,500 $ - $ 2,410,500 Transfers to Other Funds $ 311,550 $ - $ 311,550 Contingency $ 225,000 $ (7,350) $ 217,650 Total Budget $ 5,924,892 $ - $ 5,924,892 Reserve For Future Expenditure $ 5,272,814 $ - $ 5,272,814 Total Requirements $ 11,197,706 $ - $ 11,197,706 Exhibit B Total All Funds FY 2020 Q1 Revised Total All Funds Adopted Amendment Q1 Resources Beginning Fund Balance $ 140,945,996 $ 842,166 $ 141,788,162 Property Taxes $ 19,507,041 $ - $ 19,507,041 Franchise Fees $ 6,254,627 $ $ 6,254,627 Special Assessments $ 50,000 $ - $ 50,000 Licenses&Permits $ 13,319,103 $ - $ 13,319,103 Intergovernmental $ 15,475,617 $ 285,000 $ 15,760,617 Charges for Services $ 47,840,386 $ - $ 47,840,386 Fines&Forfeitures $ 1,655,957 $ $ 1,655,957 Interest Earnings $ 2,634,000 $ $ 2,634,000 Miscellaneous $ 315,850 $ 346,226 $ 662,076 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 25,688,895 $ 875,166 $ 26,564,061 Total Resources $ 273,687,472 $ 2,348,558 $ 276,036,030 Requirements Community Development $ 5,736,099 $ 284,361 $ 6,020,460 Community Services $ 26,070,545 $ 160,501 $ 26,231,046 Policy and Administration $ 13,782,572 $ 609,468 $ 14,392,040 Public Works $ 29,565,895 $ 403,331 $ 29,969,226 Program Expenditures Total $ 75,155,111 $ 1,457,661 $ 76,612,772 Debt Service $ 11,659,000 $ - $ 11,659,000 Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ 21,813,009 $ 1,184,557 $ 22,997,566 Transfers to Other Funds $ 26,068,895 $ 875,166 $ 26,944,061 Contingency $ 4,703,450 $ (1,098,826) $ 3,604,624 Total Budget $ 139,400,465 $ 2,418,558 $ 141,819,023 Reserve For Future Expenditure $ 134,287,007 $ (70,000) $ 134,217,007 Total Requirements $ 273,687,472 $ 2,348,558 $ 276,036,030 Exhibit B General Fund FY 2020 Revised General Fund Adopted Q1CM04 QlFIS01 Q1FIS03 Q1FIS04 QIFIS05 Q1PD01 Q1PW04 Q1 Resources Beginning Fund Balance $ 21,824,486 $ - $ - $ - $ - $ - $ - $ 5,500 $ 21,829,986 Property Taxes $ 17,121,416 $ - $ $ $ $ $ $ - $ 17,121,416 Franchise Fees $ 6,254,627 $ - $ $ $ $ $ $ $ 6,254,627 Special Assessments $ - $ $ $ - $ $ - $ $ $ - Licenses&Permits $ 1,186,521 $ $ - $ $ $ $ $ $ 1,186,521 Intergovernmental $ 7,347,865 $ $ $ $ $ $ $ $ 7,347,865 Charges for Services $ 253,702 $ $ $ $ $ $ $ $ 253,702 Fines&Forfeitures $ 1,654,498 $ $ $ $ $ $ $ $ 1,654,498 Interest Earnings $ 500,900 $ $ $ $ $ $ $ $ 500,900 Miscellaneous $ 56,432 $ $ $ $ 150,838 $ $ 8,200 $ $ 215,470 Other Financing Sources $ - $ $ $ $ - $ $ - $ $ - Transfers In from Other Funds $ 292,900 $ $ $ $ - $ $ - $ $ 292,900 Total Resources $ 56,493,347 $ - $ - $ - $ 150,838 $ - $ 8,200 $ 5,500 $ 56,657,885 Requirements Community Development $ 3,613,352 $ 24,891 $ - $ 64,191 $ 150,838 $ $ - $ - $ 3,853,272 Community Services $ 25,919,480 $ 10,899 $ - $ 106,002 $ - $ $ 43,600 $ $ 26,079,981 Policy and Administration $ 1,054,831 $ 2,859 $ $ 19,474 $ $ 12,609 $ - $ $ 1,089,773 Public Works $ - $ - $ - $ - $ $ - $ - $ $ - Program Expenditures Total $ 30,587,663 $ 38,649 $ - $ 189,667 $ 150,838 $ 12,609 $ 43,600 $ - $ 31,023,026 Debt Service $ - $ - $ $ - $ - $ - $ - $ - $ - Loan to TCDA $ 1,000 $ $ $ $ $ - $ - $ $ 1,000 Work-In-Progress $ 12,609 $ - $ $ $ $ (12,609) $ - $ $ - Transfers to Other Funds $ 2,611,477 $ - $ 55,000 $ - $ $ - $ - $ 5,500 $ 2,671,977 Contingency $ 1,638,450 $ (38,649) $ (55,000) $ (189,667) $ $ - $ (35,400) 5 - $ 1,319,734 Total Budget $ 34,851,199 $ - $ - $ - $ 150,838 $ - $ 8,200 $ 5,500 $ 35,015,737 Reserve For Future Expenditure $ 21,642,148 $ - $ - $ - $ - $ - $ - $ - $ 21,642,148 Total Requirements $ 56,493,347 $ - $ - $ - $ 150,838 $ - $ 8,200 $ 5,500 $ 56,657,885 Exhibit B Gas Tax Fund FY 2020 Revised Gas Tax Fund Adopted Q1FIS03 Q1PW04 Q1PW11 Q1 Resources Beginning Fund Balance $ 2,960,484 $ - $ 15,500 $ - $ 2,975,984 Property Taxes $ - $ $ - $ - $ Franchise Fees $ - $ $ $ - $ - Special Assessments $ - $ $ $ - $ - Licenses&Permits $ 65,965 $ $ $ - $ 65,965 Intergovernmental $ 4,381,236 $ $ $ $ 4,381,236 Charges for Services $ - $ - $ $ $ - Fines&Forfeitures $ - $ - $ - $ $ - Interest Earnings $ 82,400 $ - $ - $ $ 82,400 Miscellaneous $ 62,818 $ - $ - $ $ 62,818 Other Financing Sources $ - $ - $ $ - $ - Transfers In from Other Funds $ 158,000 $ $ - $ - $ 158,000 Total Resources $ 7,710,903 $ - $ 15,500 $ - $ 7,726,403 Requirements Community Development $ - $ $ - $ $ - Community Services $ $ $ $ - $ - Policy and Administration $ - $ - $ $ $ - Public Works $ 3,760,480 $ 25,270 $ - $ 7,350 $ 3,793,100 Program Expenditures Total $ 3,760,480 $ 25,270 $ - $ 7,350 $ 3,793,100 Debt Service $ 577,230 $ - $ $ - $ 577,230 Loan to TCDA $ - $ $ $ $ - Work-In-Progress $ - $ $ - $ $ - Transfers to Other Funds $ 2,131,900 $ $ 15,500 $ - $ 2,147,400 Contingency $ 222,000 $ (25,270) $ - $ (7,350) $ 189,380 Total Budget $ 6,691,610 $ - $ 15,500 $ - $ 6,707,110 Reserve For Future Expenditure $ 1,019,293 $ - $ - $ - $ 1,019,293 Total Requirements $ 7,710,903 $ - $ 15,500 $ - $ 7,726,403 Exhibit B Transient Lodging Tax Fund FY 2020 Revised Transient Lodging Tax Fund Adopted Q1PW02 Q1 Resources Beginning Fund Balance $ 452,598 $ 29,166 $ 481,764 Property Taxes $ - $ - $ - Franchise Fees $ $ $ - Special Assessments $ - $ $ - Licenses&Permits $ - $ $ Intergovernmental $ 683,920 $ $ 683,920 Charges for Services $ - $ $ - Fines&Forfeitures $ - $ $ - Interest Earnings $ 4,800 $ $ 4,800 Miscellaneous $ - $ $ - Other Financing Sources $ - $ $ Transfers In from Other Funds $ $ $ - Total Resources $ 1,141,318 $ 29,166 $ 1,170,484 Requirements Community Development $ - $ - $ - Community Services $ $ $ - Policy and Administration $ $ $ - Public Works $ $ $ - Program Expenditures Total $ - $ - $ - Debt Service $ $ $ Loan to TCDA $ $ $ - Work-In-Progress $ - $ $ - Transfers to Other Funds $ 344,900 $ 29,166 $ 374,066 Contingency $ - $ - $ - Total Budget $ 344,900 $ 29,166 $ 374,066 Reserve For Future Expenditure $ 796,418 $ - $ 796,418 Total Requirements $ 1,141,318 $ 29,166 $ 1,170,484 Exhibit B Building Fund FY 2020 Revised Building Fund Adopted Q1FIS03 Q1 Resources Beginning Fund Balance $ 8,021,235 $ - $ 8,021,235 Property Taxes $ - $ - $ - Franchise Fees $ $ - $ - Special Assessments $ $ - $ - Licenses&Permits $ 2,322,956 $ - $ 2,322,956 Intergovernmental $ 8,281 $ - $ 8,281 Charges for Services $ 7,000 $ - $ 7,000 Fines&Forfeitures $ - $ - $ - Interest Earnings $ 150,500 $ - $ 150,500 Miscellaneous $ 500 $ - $ 500 Other Financing Sources $ - $ $ - Transfers In from Other Funds $ 250,000 $ $ 250,000 Total Resources $ 10,760,472 $ - $ 10,760,472 Requirements Community Development $ 2,122,747 $ 44,441 $ 2,167,188 Community Services $ - $ - $ - Policy and Administration $ $ $ - Public Works $ $ - $ - Program Expenditures Total $ 2,122,747 $ 44,441 $ 2,167,188 Debt Service $ - $ - $ Loan to TCDA $ - $ $ - Work-In-Progress $ $ - $ Transfers to Other Funds $ $ - $ - Contingency $ 295,000 $ (44,441) $ 250,559 Total Budget $ 2,417,747 $ - $ 2,417,747 Reserve For Future Expenditure $ 8,342,725 $ - $ 8,342,725 Total Requirements $ 10,760,472 $ - $ 10,760,472 Exhibit B Urban Forestry Fund FY 2020 Revised Urban Forestry Fund Adopted Q1PW01 Q1 Resources Beginning Fund Balance $ 1,015,203 $ - $ 1,015,203 Property Taxes $ - $ $ - Franchise Fees $ - $ $ - Special Assessments $ - $ $ Licenses&Permits $ $ $ Intergovernmental $ $ $ - Charges for Services $ $ $ - Fines&Forfeitures $ $ $ - Interest Earnings $ 35,200 $ $ 35,200 Miscellaneous $ 15,000 $ $ 15,000 Other Financing Sources $ - $ $ - Transfers In from Other Funds $ - $ $ - Total Resources $ 1,065,403 $ - $ 1,065,403 Requirements Community Development $ - $ $ Community Services $ $ $ - Policy and Administration $ $ $ Public Works $ $ $ - Program Expenditures Total $ - $ - $ - Debt Service $ $ $ - Loan to TCDA $ $ $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 148,900 $ 70,000 $ 218,900 Contingency $ - $ - $ - Total Budget $ 148,900 $ 70,000 $ 218,900 Reserve For Future Expenditure $ 916,503 $ (70,000) $ 846,503 Total Requirements $ 1,065,403 $ - $ 1,065,403 Exhibit B Parks Capital Fund FY 2020 Revised Parks Capital Fund Adopted Q1PW01 QlPW02 Q1PW03 Q1PW04 QlPW05 Q1PW06 Q1 Resources Beginning Fund Balance $ 880,000 $ - $ - $ - $ - $ - $ - $ 880,000 Property Taxes $ - $ $ $ $ $ - $ $ - Franchise Fees $ - $ $ $ - $ $ - $ - $ - Special Assessments $ - $ $ $ - $ $ - $ - $ Licenses&Permits $ - $ $ $ $ - $ - $ $ - Intergovernmental $ 867,000 $ 112,000 $ 58,000 $ $ $ - $ $ 1,037,000 Charges for Services $ - $ - $ - $ - $ $ - $ $ - Fines&Forfeitures $ - $ $ $ $ $ - $ - $ - Interest Earnings $ - $ $ - $ $ - $ - $ $ - Miscellaneous $ - $ - $ $ $ - $ - $ $ - Other Financing Sources $ $ - $ $ $ - $ - $ $ - Transfers In from Other Funds $ 3,707,000 $ 332,000 $ 29,166 $ 187,000 $ 30,000 $ 44,000 $ 22,000 $ 4,351,166 Total Resources $ 5,454,000 $ 444,000 $ 87,166 $ 187,000 $ 30,000 $ 44,000 $ 22,000 $ 6,268,166 Requirements Community Development $ - $ - $ - $ - $ - $ - $ - $ - Community Services $ $ $ $ - $ $ $ $ - Policy and Administration $ $ $ $ $ $ $ $ - Public Works $ $ $ $ $ - $ $ $ - Program Expenditures Total $ - $ - $ - $ - $ - $ - $ - $ Debt Service $ $ $ $ $ - $ $ $ - Loan to TCDA $ - $ $ - $ $ $ $ - $ - Work-In-Progress $ 4,709,500 $ 444,000 $ 87,166 $ 187,000 $ 30,000 $ 44,000 $ 22,000 $ 5,523,666 Transfers to Other Funds $ - $ - $ - $ - $ - $ - $ - $ - Contingency $ - $ - $ - $ - $ - $ - $ - $ - Total Budget $ 4,709,500 $ 444,000 $ 87,166 $ 187,000 $ 30,000 $ 44,000 $ 22,000 $ 5,523,666 Reserve For Future Expenditure $ 744,500 $ - $ - $ - $ - $ - $ - $ 744,500 Total Requirements $ 5,454,000 $ 444,000 $ 87,166 $ 187,000 $ 30,000 $ 44,000 $ 22,000 $ 6,268,166 Exhibit B Parks Utility Fund FY 2020 Revised Parks Utility Fund Adopted Q1FIS03 Q1PW11 Q1 Resources Beginning Fund Balance $ 1,452,584 $ - $ - $ 1,452,584 Property Taxes $ - $ $ $ - Franchise Fees $ $ - $ $ Special Assessments $ $ $ $ - Licenses&Permits $ 1,790,593 $ $ $ 1,790,593 Intergovernmental $ - $ $ $ - Charges for Services $ 90,750 $ - $ $ 90,750 Fines&Forfeitures $ - $ - $ $ - Interest Earnings $ 3,300 $ $ - $ 3,300 :Miscellaneous $ - $ $ - $ - Other Financing Sources $ - $ - $ $ - Transfers In from Other Funds $ 2,213,770 $ $ $ 2,213,770 Total Resources $ 5,550,997 $ - $ - $ 5,550,997 Requirements Community Development $ - $ $ $ - Community Services $ $ $ $ Policy and Administration $ $ $ $ - Public Works $ 3,807,739 $ 49,998 $ 14,700 $ 3,872,437 Program Expenditures Total $ 3,807,739 $ 49,998 $ 14,700 $ 3,872,437 Debt Service $ - $ - $ - $ - Loan to TCDA $ $ $ - $ - Work-In-Progress $ $ $ $ - Transfers to Other Funds $ 61,538 $ - $ $ 61,538 Contingency $ 135,000 $ (49,998) $ (14,700) $ 70,302 Total Budget $ 4,004,277 $ - $ - $ 4,004,277 Reserve For Future Expenditure $ 1,546,720 $ - $ - $ 1,546,720 Total Requirements $ 5,550,997 $ - $ - $ 5,550,997 Exhibit B Parks SDC Fund FY 2020 Revised Parks SDC Fund Adopted Q1PW01 Q1PW03 Q1PW04 Q1PW05 Q1PW06 Q1 Resources Beginning Fund Balance $ 8,532,863 $ 262,000 $ 109,000 $ 9,000 $ 44,000 $ 22,000 $ 8,978,863 Property Taxes $ - $ - $ - $ - $ - $ - $ - Franchise Fees $ $ $ - $ - $ - $ - $ - Special Assessments $ $ $ - $ - $ - $ - $ - Licenses&Permits $ 503,390 $ $ - $ $ - $ - $ 503,390 Intergovernmental $ - $ - $ - $ $ - $ $ - Charges for Services $ $ - $ - $ $ - $ $ Fines&Forfeitures $ - $ - $ - $ $ - $ $ - Interest Earnings $ 211,100 $ $ - $ $ - $ $ 211,100 Miscellaneous $ - $ - $ - $ $ - $ $ - Other Financing Sources $ - $ $ $ $ - $ $ Transfers In from Other Funds $ - $ $ $ $ - $ $ - Total Resources $ 9,247,353 $ 262,000 $ 109,000 $ 9,000 $ 44,000 $ 22,000 $ 9,693,353 Requirements Community Development $ - $ - $ - $ - $ - $ - $ - Community Services $ $ $ $ $ - $ - $ Policy and Administration $ $ $ - $ $ - $ - $ Public Works $ $ $ - $ $ - $ - $ Program Expenditures Total $ - $ - $ - $ - $ - $ - $ Debt Service $ $ $ $ $ $ - $ Loan to TCDA $ $ $ $ $ $ $ - Work-In-Progress $ - $ $ - $ - $ $ $ - Transfers to Other Funds $ 2,847,400 $ 262,000 $ 109,000 $ 9,000 $ 44,000 $ 22,000 $ 3,293,400 Contingency $ - $ - $ - $ - $ - $ - $ - Total Budget $ 2,847,400 $ 262,000 $ 109,000 $ 9,000 $ 44,000 $ 22,000 $ 3,293,400 Reserve For Future Expenditure $ 6,399,953 $ - $ - $ - $ - $ - $ 6,399,953 Total Requirements $ 9,247,353 $ 262,000 $ 109,000 $ 9,000 $ 44,000 $ 22,000 $ 9,693,353 Exhibit B Transportation CIP Fund FY 2020 Revised Transportation CIP Fund Adopted Q1PW09 Ql Resources Beginning Fund Balance $ 820,000 $ - $ 820,000 Property Taxes $ - $ $ - Franchise Fees $ - $ $ Special Assessments $ - $ $ - Licenses&Permits $ - $ $ - Intergovernmental $ 1,038,200 $ 115,000 $ 1,153,200 Charges for Services $ - $ - $ - Fines&Forfeitures $ $ $ - Interest Earnings $ $ $ - N iscellaneous $ $ $ - Other Financing Sources $ $ $ - Transfers In from Other Funds $ 4,093,200 $ 12,000 $ 4,105,200 Total Resources $ 5,951,400 $ 127,000 $ 6,078,400 Requirements Community Development $ - $ $ Community Services $ $ $ Policy and Administration $ $ $ Public Works $ $ S - Program Expenditures Total $ - $ - $ Debt Service $ - $ $ - Loan to TCDA $ - $ $ - Work-In-Progress $ 5,231,400 $ 127,000 $ 5,358,400 Transfers to Other Funds $ - $ $ - Contingency $ - $ $ - Total Budget $ 5,231,400 $ 127,000 $ 5,358,400 Reserve For Future Expenditure $ 720,000 $ - $ 720,000 Total Requirements $ 5,951,400 $ 127,000 $ 6,078,400 Exhibit B Transportation SDC Fund FY 2020 Revised Transportation SDC Fund Adopted Q1PW03 Q1PW09 Q1 Resources Beginning Fund Balance $ 7,289,996 $ 78,000 $ 12,000 $ 7,379,996 Property Taxes $ - $ - $ - $ - Franchise Fees $ $ - $ $ Special Assessments $ $ - $ $ - Licenses&Permits $ 409,500 $ $ $ 409,500 Intergovernmental $ - $ $ $ - Charges for Services $ $ $ $ - Fines&Forfeitures $ $ $ $ - Interest Earnings $ 144,000 $ - $ $ 144,000 Miscellaneous $ - $ $ $ - Other Financing Sources $ $ $ - $ - Transfers In from Other Funds $ $ $ $ - Total Resources $ 7,843,496 $ 78,000 $ 12,000 $ 7,933,496 Requirements Community Development $ - $ - $ - $ Community Services $ $ $ - $ Policy and Administration $ $ $ - $ Public Works $ $ $ - $ Program Expenditures Total $ - $ - $ - $ - Debt Service $ - $ $ - $ - Loan to TCDA $ - $ $ - $ Work-In-Progress $ - $ $ - $ Transfers to Other Funds $ 209,000 $ 78,000 $ 12,000 $ 299,000 Contingency $ $ - $ - $ - Total Budget $ 209,000 $ 78,000 $ 12,000 $ 299,000 Reserve For Future Expenditure $ 7,634,496 $ - $ - $ 7,634,496 Total Requirements $ 7,843,496 $ 78,000 $ 12,000 $ 7,933,496 Exhibit B Sanitary Sewer Fund FY 2020 Revised Sanitary Sewer Fund Adopted Q1CM03 Q1FIS03 QlFIS05 Q1 Resources Beginning Fund Balance $ 4,903,060 $ - $ - $ - $ 4,903,060 Property Taxes $ - $ $ $ - $ - Franchise Fees $ - $ $ $ - $ Special Assessments $ - $ $ $ - $ - Licenses&Permits $ 92,200 $ $ $ $ 92,200 Intergovernmental $ - $ - $ $ - $ - Charges for Services $ 3,255,811 $ - $ - $ - $ 3,255,811 Fines&Forfeitures $ - $ $ - $ - $ - Interest Earnings $ 110,300 $ $ - $ - $ 110,300 Miscellaneous $ 42,100 $ - $ - $ $ 42,100 Other Financing Sources $ - $ - $ - $ $ - Transfers In from Other Funds $ 243,750 $ $ $ 74,000 $ 317,750 Total Resources $ 8,647,221 $ - $ - $ 74,000 $ 8,721,221 Requirements Community Development $ - $ $ $ - $ - Community Services $ - $ - $ $ $ - Policy and Administration $ $ - $ $ $ - Public Works $ 2,301,899 $ 5,965 $ 14,131 $ $ 2,321,995 Program Expenditures Total $ 2,301,899 $ 5,965 $ 14,131 $ - $ 2,321,995 Debt Service $ - $ - $ - $ - $ - Loan to TCDA $ - $ $ $ - $ - Work-In-Progress $ 1,206,500 $ - $ $ 74,000 $ 1,280,500 Transfers to Other Funds $ 659,200 $ - $ $ - $ 659,200 Contingency $ 414,000 $ (5,965) $ (14,131) $ - $ 393,904 Total Budget $ 4,581,599 $ - $ - $ 74,000 $ 4,655,599 Reserve For Future Expenditure $ 4,065,622 $ - $ - $ - $ 4,065,622 Total Requirements $ 8,647,221 $ - $ - $ 74,000 $ 8,721,221 Exhibit B Stormwater Fund FY 2020 Revised Stormwater Fund Adopted Q1CM03 Q1FIS03 Q1FIS05 Q1PW07 Q1PW08 Q1PW11 Q1 Resources Beginning Fund Balance $ 6,456,618 $ - $ - $ - $ 40,000 $ 126,000 $ - $ 6,622,618 Property Taxes $ - $ - $ - $ - $ - $ - $ - $ - Franchise Fees $ - $ $ - $ $ - $ - $ $ - Special Assessments $ - $ - $ - $ $ - $ - $ - $ - Licenses&Permits $ - $ - $ - $ - $ - $ - $ - $ - Intergovernmental $ - $ $ - $ - $ - $ - $ - $ - Charges for Services $ 3,892,188 $ $ - $ - $ - $ - $ - $ 3,892,188 Fines&Forfeitures $ - $ $ - $ - $ - $ - $ - $ - Interest Earnings $ 139,900 $ - $ - $ - $ - $ - $ - $ 139,900 Miscellaneous $ 5,000 $ - $ - $ - $ - $ - $ - $ 5,000 Other Financing Sources $ - $ - $ - $ - $ - $ - $ - $ - Transfers In from Other Funds $ 704,000 $ - S S S - S - $ - $ 704,000 Total Resources $ 11,197,706 $ - $ - $ - $ 40,000 $ 126,000 $ - $ 11,363,706 Requirements Community Development $ - $ - $ - $ - $ - $ - $ - $ - Community Services $ - $ $ - $ $ - $ - $ - $ Policy and Administration $ - $ - $ - $ - $ - $ - $ - $ - Public Works $ 2,977,842 $ 5,818 $ 28,768 $ - $ - $ - $ 7,350 $ 3,019,778 Program Expenditures Total $ 2,977,842 $ 5,818 $ 28,768 $ - $ - $ - $ 7,350 $ 3,019,778 Debt Service $ - $ - $ - $ - $ - $ - $ - $ - Loan to TCDA $ - $ - $ - $ - $ - $ $ $ - Work-In-Progress $ 2,410,500 $ - $ - $ (74,000) $ 40,000 $ 126,000 $ - $ 2,502,500 Transfers to Other Funds $ 311,550 $ - $ - $ 74,000 $ - $ - $ - $ 385,550 Contingency $ 225,000 $ (5,818) $ (28,768) $ - $ - $ - $ (7,350) $ 183,064 Total Budget $ 5,924,892 $ - $ - $ - $ 40,000 $ 126,000 $ - $ 6,090,892 Reserve For Future Expenditure $ 5,272,814 $ - $ - $ - $ - $ - $ - $ 5,272,814 Total Requirements $ 11,197,706 $ - $ - $ - $ 40,000 $ 126,000 $ - $ 11,363,706 Exhibit B Water Fund FY 2020 Revised Water Fund Adopted QlCM03 QlFIS03 Q1PW10 Q1 Resources Beginning Fund Balance $ 30,807,424 $ - $ - $ 54,000 $ 30,861,424 Property Taxes $ - $ $ - $ - $ - Franchise Fees $ - $ - $ - $ $ Special Assessments $ $ - $ - $ $ - Licenses&Permits $ 170,000 $ $ $ $ 170,000 Intergovernmental $ 15,000 $ $ $ $ 15,000 Charges for Services $ 22,405,446 $ $ $ $ 22,405,446 Fines&Forfeitures $ - $ $ $ $ - Interest Earnings $ 500,700 $ $ - $ $ 500,700 Miscellaneous $ 50,000 $ $ - $ - $ 50,000 Other Financing Sources $ - $ $ $ - $ - Transfers In from Other Funds $ - $ $ $ $ - Total Resources $ 53,948,570 $ - $ - $ 54,000 $ 54,002,570 Requirements Community Development $ - $ $ $ - $ Community Services $ $ $ $ $ - Policy and Administration $ $ $ $ $ - Public Works $ 10,246,079 $ 3,377 $ 40,201 $ $ 10,289,657 Program Expenditures Total $ 10,246,079 $ 3,377 $ 40,201 $ - $ 10,289,657 Debt Service $ - $ - $ - $ $ - Loan to TCDA $ $ $ - $ $ - Work-In-Progress $ $ $ - $ $ - Transfers to Other Funds $ 10,651,600 $ $ - $ 54,000 $ 10,705,600 Contingency $ 539,000 $ (3,377) $ (40,201) $ - $ 495,422 Total Budget $ 21,436,679 $ - $ - $ 54,000 $ 21,490,679 Reserve For Future Expenditure $ 32,511,891 $ - $ - $ - $ 32,511,891 Total Requirements $ 53,948,570 $ - $ - $ 54,000 $ 54,002,570 Exhibit B Water SDC Fund FY 2020 Revised Water SDC Fund Adopted Q1PW10 Q1 Resources Beginning Fund Balance $ 12,052,538 $ 36,000 $ 12,088,538 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ $ - Licenses&Permits $ 1,276,200 $ $ 1,276,200 Intergovernmental $ - $ $ - Charges for Services $ - $ $ - Fines&Forfeitures $ - $ $ - Interest Earnings $ 258,200 $ - $ 258,200 Miscellaneous $ - $ - $ - Other Financing Sources $ $ $ - Transfers In from Other Funds $ $ $ Total Resources $ 13,586,938 $ 36,000 $ 13,622,938 Requirements Community Development $ - $ - $ - Community Services $ $ S - Policy and Administration $ $ $ - Public Works $ $ $ - Program Expenditures Total $ - $ - $ - Debt Service $ $ $ - Loan to TCDA $ - $ $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 2,170,000 $ 36,000 $ 2,206,000 Contingency $ - $ - $ - Total Budget $ 2,170,000 $ 36,000 $ 2,206,000 Reserve For Future Expenditure $ 11,416,938 $ - $ 11,416,938 Total Requirements $ 13,586,938 $ 36,000 $ 13,622,938 Exhibit B Water CIP Fund FY 2020 Revised Water CIP Fund Adopted Q1PW10 Q1 Resources Beginning Fund Balance $ 1,530,000 $ - $ 1,530,000 Property Taxes $ - $ $ Franchise Fees $ - $ - $ - Special Assessments $ $ $ - Licenses&Permits $ $ $ - Intergovernmental $ $ $ Charges for Services $ - $ $ Fines&Forfeitures $ $ $ Interest Earnings $ $ $ - Miscellaneous $ - $ $ - Other Financing Sources $ - $ $ - Transfers In from Other Funds $ 4,304,500 $ 90,000 $ 4,394,500 Total Resources $ 5,834,500 $ 90,000 $ 5,924,500 Requirements Community Development $ - $ - $ Community Services $ $ $ Policy and Administration $ - $ - $ Public Works $ $ - $ Program Expenditures Total $ - $ - $ - Debt Service $ $ - $ Loan to TCDA $ $ $ - Work-In-Progress $ 4,304,500 $ 90,000 $ 4,394,500 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ - Total Budget $ 4,304,500 $ 90,000 $ 4,394,500 Reserve For Future Expenditure $ 1,530,000 $ - $ 1,530,000 Total Requirements $ 5,834,500 $ 90,000 $ 5,924,500 Exhibit B PW Engineering Fund FY 2020 Revised PW Engineering Fund Adopted Q1FIS03 Q1FISO4 Q1 Resources Beginning Fund Balance $ 541,296 $ - $ - $ 541,296 Property Taxes $ - $ $ $ - Franchise Fees $ $ $ $ - Special Assessments $ $ $ - $ - Licenses&Permits $ 800,000 $ $ $ 800,000 Intergovernmental $ 145,128 $ $ $ 145,128 Charges for Services $ 2,920,852 $ $ $ 2,920,852 Fines&Forfeitures $ - $ $ - $ - Interest Earnings $ $ $ - $ - N iscellaneous $ $ $ 86,152 $ 86,152 Other Financing Sources $ $ $ - $ - Transfers In from Other Funds $ 640,718 $ $ - $ 640,718 Total Resources $ 5,047,994 $ - $ 86,152 $ 5,134,146 Requirements Community Development $ - $ - $ - $ - Community Services $ $ - $ - $ - Policy and Administration $ - $ - $ - $ - Public Works $ 4,198,168 $ 72,838 $ 86,152 $ 4,357,158 Program Expenditures Total $ 4,198,168 $ 72,838 $ 86,152 $ 4,357,158 Debt Service $ - $ - $ - $ Loan to TCDA $ $ $ - $ Work-In-Progress $ $ $ $ - Transfers to Other Funds $ $ $ $ - Contingeency $ 170,000 $ (72,838) $ $ 97,162 Total Budget $ 4,368,168 $ - $ 86,152 $ 4,454,320 Reserve For Future Expenditure $ 679,826 $ - $ - $ 679,826 Total Requirements $ 5,047,994 $ - $ 86,152 $ 5,134,146 Exhibit B PW Admin Fund FY 2020 Revised PW Admin Fund Adopted Q1CM03 Q1FIS03 Q1 Resources Beginning Fund Balance $ 316,216 $ - $ - $ 316,216 Property Taxes $ - $ - $ - $ - Franchise Fees $ $ - $ - $ - Special Assessments $ $ - $ $ - Licenses&Permits $ $ - $ $ - Intergovernmental $ $ - $ $ - Charges for Services $ 2,262,895 $ $ $ 2,262,895 Fines&Forfeitures $ - $ $ $ - Interest Earnings $ - $ - $ - $ - Miscellaneous $ - $ - $ - $ - Other Financing Sources $ $ - $ - $ - Transfers In from Other Funds $ 48,336 $ - $ $ 48,336 Total Resources $ 2,627,447 $ - $ - $ 2,627,447 Requirements Community Development $ - $ - $ $ - Community Services $ - $ $ $ Policy and Administration $ - $ $ - $ - Public Works $ 2,273,688 $ 5,546 $ 35,867 $ 2,315,101 Program Expenditures Total $ 2,273,688 $ 5,546 $ 35,867 $ 2,315,101 Debt Service $ - $ - $ - $ - Loan to TCDA $ - $ $ - $ - Work-In-Progress $ - $ - $ $ - Transfers to Other Funds $ - $ - $ - $ - Contingency $ 135,000 $ (5,546) $ (35,867) $ 93,587 Total Budget $ 2,408,688 $ - $ - $ 2,408,688 Reserve For Future Expenditure $ 218,759 $ - $ - $ 218,759 Total Requirements $ 2,627,447 $ - $ - $ 2,627,447 Exhibit B Fleet/Property Management Fund FY 2020 Revised Fleet/Property Management Fund Adopted Q1CS01 QlFIS03 Q1 Resources Beginning Fund Balance $ 610,063 $ - $ - $ 610,063 Property Taxes $ - $ $ $ - Franchise Fees $ - $ - $ $ Special Assessments $ - $ - $ $ Licenses&Permits $ - $ $ $ Intergovernmental $ - $ $ $ - Charges for Services $ 2,719,734 $ - $ $ 2,719,734 Fines&Forfeitures $ - $ - $ $ - Interest Earnings $ - $ $ $ - Miscellaneous $ 5,000 $ - $ $ 5,000 Other Financing Sources $ - $ - $ $ - Transfers In from Other Funds $ - $ - $ $ - Total Resources $ 3,334,797 $ - $ - $ 3,334,797 Requirements Community Development $ - $ $ $ - Community Services $ $ $ $ - Policy and Administration $ 2,512,309 $ 82,000 $ 26,418 $ 2,620,727 Public Works $ - $ - $ - $ - Program Expenditures Total $ 2,512,309 $ 82,000 $ 26,418 $ 2,620,727 Debt Service $ - $ - $ - $ - Loan to TCDA $ $ $ $ Work-In-Progress $ - $ - $ $ Transfers to Other Funds $ - $ - $ $ - Contingency $ 226,000 $ (82,000) $ (26,418) $ 117,582 Total Budget $ 2,738,309 $ - $ - $ 2,738,309 Reserve For Future Expenditure $ 596,488 $ - $ - $ 596,488 Total Requirements $ 3,334,797 $ - $ - $ 3,334,797 Exhibit B Insurance Fund FY 2020 Revised Insurance Fund Adopted Q1CM01 Q1FIS03 Q1 Resources Beginning Fund Balance $ 1,117,330 $ - $ - $ 1,117,330 Property Taxes $ - $ $ $ - Franchise Fees $ - $ $ $ Special Assessments $ - $ $ $ Licenses&Permits $ - $ $ - $ - Intergovernmental $ - $ - $ $ - Charges for Services $ $ $ $ - Fines&Forfeitures $ $ $ $ - Interest Earnings $ 26,500 $ - $ - $ 26,500 Miscellaneous $ 39,000 $ $ $ 39,000 Other Financing Sources $ - $ - $ $ - Transfers In from Other Funds $ - $ $ $ - Total Resources $ 1,182,830 $ - $ - $ 1,182,830 Requirements Community Development $ - $ $ $ - Community Services $ - $ $ - $ - Poliry and Administration $ 64,476 $ 2,820 $ 679 $ 67,975 Public Works $ - $ - $ - $ - Program Expenditures Total $ 64,476 $ 2,820 $ 679 $ 67,975 Debt Service $ - $ - $ - $ - Loan to TCDA $ $ - $ $ Work-In-Progress $ $ $ - $ - Transfers to Other Funds $ - $ - $ - $ - Contingency $ 25,000 $ (2,820) $ (679) $ 21,501 Total Budget $ 89,476 $ - $ - $ 89,476 Reserve For Future Expenditure $ 1,093,354 $ - $ - $ 1,093,354 Total Requirements $ 1,182,830 $ - $ - $ 1,182,830 Exhibit B Central Services Fund FY 2020 Revised Central Services Fund Adopted Q1CM01 Q1CM02 QICM03 Q1CM04 Q1FIS01 Q1FIS02 QlFIS03 Q1FIS04 Q1 Resources Beginning Fund Balance $ 1,773,564 $ - $ - $ - $ - $ - $ - $ - $ - $ 1,773,564 Property Taxes $ - $ $ $ - $ $ $ $ - $ $ - Franchise Fees $ $ $ $ - $ $ $ $ $ - $ Special Assessments $ $ $ $ - $ $ $ $ $ - $ Licenses&Permits $ $ - $ $ - $ $ $ $ $ - $ Intergovernmental $ $ - $ - $ $ $ $ $ $ $ - Charges for Services $ 10,032,008 $ $ - $ - $ $ $ $ $ $ 10,032,008 Fines&Forfeitures $ - $ - $ - $ - $ - $ - $ $ $ $ - Interest Earnings $ - $ $ $ - $ - $ - $ $ $ $ - N iscellaneous $ 30,000 $ $ 12,500 $ $ $ - $ $ $ 88,536 $ 131,036 Other Financing Sources $ - $ $ - $ - $ $ - $ $ $ - $ - Transfers In from Other Funds $ 234,721 $ $ - $ $ $ 55,000 $ $ $ - $ 289,721 Total Resources $ 12,070,293 $ - $ 12,500 $ - $ - $ 55,000 $ - $ - $ 88,536 $ 12,226,329 Requirements Community Development $ - $ $ - $ - $ - $ - $ $ - $ - $ - Community Services $ - $ $ - $ - $ $ - $ $ - $ - $ - Policy and Administration $ 10,150,956 $ 14,780 $ 12,500 $ 18,971 $ 32,500 $ 55,000 $ 59,000 $ 181,322 $ 88,536 $ 10,613,565 Public Works $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Program Expenditures Total $ 10,150,956 $ 14,780 $ 12,500 $ 18,971 $ 32,500 $ 55,000 $ 59,000 $ 181,322 $ 88,536 $ 10,613,565 Debt Service $ - $ - $ - S - $ - $ - $ - S - $ - $ - Loan to TCDA $ - $ $ S - $ - $ $ S $ - $ Work-In-Progress $ - $ $ $ - $ - $ $ $ $ - $ Transfers to Other Funds $ - $ $ $ - $ - $ $ $ $ - $ - Contingcncy $ 429,000 $ (14,780) S $ (18,971) $ (32,500) $ $ (59,000) $ (181,322) $ - $ 122,427 Total Budget $ 10,579,956 $ - $ 12,500 $ - $ - $ 55,000 $ - $ - $ 88,536 $ 10,735,992 Reserve For Future Expenditure $ 1,490,337 $ - $ - $ - $ - $ - $ - $ - $ - $ 1,490,337 Total Requirements $ 12,070,293 $ - $ 12,500 $ - $ - $ 55,000 $ - $ - $ 88,536 $ 12,226,329 FY 2019-20 First Quarter Supplemental Budget Exhibit C 92034 Tigard Street Heritage Trail and Public Space(Tigard Street from Main Street to Tiedeman The city has signed a lease for the use of the inactive railroad corridor from'Tiedeman Avenue to Main Street.The City was awarded a Connect Oregon VI Grant and Washington County MSTIP funding to assist with the development of a 3/4 mile,12'wide multi-use pathway with amenities including fencing,lighting,landscape,and art features. A public open space will be created adjacent to Main Street and the Tigard Chamber of Commerce building. This project is related to LQC 98009 which used porous paving material to create a temporary pathway in advance of the full project. Adopted Revised Revised Revised Revised Revised Revised Budget This Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project FY 2020 Change FY 2020 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 Total Internal Expenses Design and Engineering Project Management 40,000 40,000 40,000 Construction Management Total 40,000 - 40,000 - - - - - - - - - - 40,000 External Expenses Public Involvement - Land/Right of Way Acquisition - - Design and Engineering 10,000 10,000 10,000 Construction 710,000 545,000 1,255,000 1,255,000 Contingency 115,000 83,000 32,000 32,000 Total 835,000 1 462,000 1 1,297,000 1,297,000 Total Project Expense 875,000 1 462,000 1 1,337,000 1 1,337,000 Revenue Funding Source 425-Parks SDC Fund 60,000 262,000 322,000 322,000 260-Urban Forestry Fund 70,000 70,000 70,000 Other Revenue Funding - - Connect Oregon VI 560,000 140,000 700,000 700,000 Urban Renewal Capital Imp. 156,000 18,000 174,000 174,000 Washington Cry.MSTIP 99,000 (28,000) 71,000 71,000 Total Project Revenues 875,000 1 462,000 1 1,337,000 1,337,000 FY 2019-20 First Quarter Supplemental Budget 92034-02 Tigard Street Heritage Plaza Outdoor Musuem 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 cotutnn thread of rail history.The project will include four major competitn ely selected artworks and a series of smaller connective pieces. Adopted Revised Revised Revised Revised Revised i.. Revised Budget Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project FY 2020 This Change FY 2020 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 'Dotal Internal Expenses Design and Engineering - _ _ _ _ _ _ _ Project Management 500 1,000 1,500 - - - - - - 1,500 Construction Management Total 500 1 1,000 1,500 1,500 External Expenses Public Involvement - _ _ _ _ _ _ _ Land/Right of Way Acquisition - _ _ _ _ _ _ _ Design and Engineering 103,500 1 86,166 189,666 - - - - - - 189.666 Construction - Contingency _ Total 103,500 86,166 189,666 189,666 Total Project Expense 104,000 87,166 191,1661 1 1 191,166 Revenue Funding Source 210-Transwcu:Lodging Tax Fund 52,000 29,166 81,166 - - - - - - 81,166 Other Revenue Source - _ _ _ _ _ _ _ National Endowment for the Arts 52,000 23,000 75,000 _ _ _ _ _ _ 75,000 Washington Cry.Visitors Assoc. 35,000 35,000 - - - - - - 35,000 Total Project Revenues 104,000 87,166 191,166 - 191,166 FY 2019-20 First Quarter Supplemental Budget 92046 Fanno Creek Trail Connection PFA Grant This project constructs four segments of the Fanno Creek Trail.Segment 1-Grant Avenue to Woodard park;Segment 2-Ash Avenue to Hall Boulevard;Segment 3-City Library to Bonita Road;Segment 4-85th_avenue(south of Durham Road)to the Tualatin River.The Regional Flexible Funds(RFFA)grant federal dollars will require coordination with Metro and Oregon Department of Transportation.Transportation SDC Fund and Parks-SDC Fund will be used as match. Adopted Revised Revised Revised Revised Revised Revised Budget Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected FY 2020 This Change FY 2020 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 Project Total Internal Expenses Design and Engineering - - - - - - - - Project Management 75,000 13,000 88,000 75,000 40,000 - - - - - - 203,000 Construction Management - - - - - Total 75,000 1 13,000 1 88,000 - 75,000 - 40,000 - - 203,000 External Expenses Public Involvement - - - - - - - - Land/Right of Way Acquisition 100,000 100,000 - - - - - - 100,000 Design and Engineering 34,000 34,000 - - - - - - 34,000 Environmental Permit Comp. 25,000 Construction 150,000 150,000 150,000 100,000 - - - - - - 400,000 Contingency 110,000 40,000 150,000 150,000150,000 - - - - 450,000 Total 260,000 1 174,000 1 434,000 1 300,000 275,000 - 984,000 Total Project Expense 335,000 187,000 522,000 375,000 - 315,000 - 1,187,000 Revenue Funding Source 415-Transportation SDC Fund 185,000 78,000 263,000 150,000 65,000 - - - - - - 478,000 425-Parks SDC Fund 150,000 109,000 259,000 225,000 250,000 - - - - - - 734,000 Other Revenue Source - - - - - - - - Total Project Revenues 335,000 187,000 522,000 j 375,000 315,0001 1,212,000 FY 2019-20 First Quarter Supplemental Budget 92055 Americans with Disabilities Act Transition Plan The city must complete an up-to-date Americans with Disabilities Act(ADA)Transition Plan. The ADA Transition Plan will focus primarily on accessibility and barrier removal needs in the city transportation,parks,and facilities(buildings)system.The city has previously completed accessibility and condition inventories of some parts of these systems.This data will be utilized in this effort. The Plan will also integrate and coordinate the schedule of needed improvements with ongoing and planned projects such as the Pavement Management Program. Adopted Revised Revised Revised Revised Revised Revised Budget Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected FY 2020 This Change FY 2020 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 Project Total Internal Expenses Design and Engineering - - - - - - - - Project Management 10,000 10,000 - - - - - - 10,000 Construction Management Total 10,000 10,0001 10,000 External Expenses Public Involvement - - - - - - - - Land/Right of Way Acquisition - - - - - - - - DesignandEngineering 20,000 20,000 - - - - - - 20,000 Environmental Permit Comp. Construction - - - - - - - - Contingency - Total 20,000 20,000 - 20,000 Total Project Expense 30,000 30,000 - - - 30.000 Revenue Funding Source 100-General Fund 5,500 5,500 - - - - - - 5.500 200-Gas Tax Fund 15,500 15,500 - - - - - - 15500 425-Parks SDC Fund 9,000 9,000 - _ _ _ _ - 9,000 Other Revenue Source - - - - - - - - Total Project Revenues 1 30,000 1 30,0001 1 i - - - - - 30,000 FY 2019-20 First Quarter Supplemental Budget 92056 Park System Master Plan Update The Park System Master Plan Update will examine existing recreational facilities,programs,and services.Community involvement and public input will be a critical component of the process that will help determine the current and future parks and recreation service levels.The updated plan will prioritize the needs and desires for upgrading and creating new facilities and services. The plan will focus on developing areas of Tigard such as River Terrace and the Tigard Triangle m addition to existing parks and recreation services. Adopted Revised Revised Revised Revised Revised Revised Budget Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected FY 2020 This Change FY 2020 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 Project Total Internal Expenses Design and Engineering - - - - - - - - Project Management 20,000 16,000 36,000 - - - - - - 36,000 Construction Management Total 20,000 1 16,000 1 36,000 1 36,000 External Expenses Public Involvement - - - - - - - - Land/Right of Way.Acquisition - - - - - - - - Design and Engineering 180,000 28,000 208,000 - - - - - - 208,000 Environmental Permit Comp. Construction - - - - - - - - Contingency 20,000000 20,000 20,000 Total 200, 1 28,000 1 228,000 - - 228,000 Total Project Expense 220,000 44,000 264,000 - 264,000 Revenue Funding Source 425-Parks SDC Fond 220,000 44,000 264,000 - - - - - - 264,000 Other Revenue Source - Total Project Revenues 220,000 1 44,000 264,000 - - 264,000 I FY 2019-20 First Quarter Supplemental Budget 92057 Fanno Creek Trail Amenities This is a companion project to#92046,which uses Federal funds to construct new and rebuilt sections of the Fanno Creek Trail. This locally funded project will add amenities along the new trail sections such as interpretive signage,overlooks,benches and artwork to enhance the experience of trail users. Adopted Revised Revised Revised Revised Revised Revised Budget Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected FY 2020 This Change FY 2020 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 Project Total Internal Expenses Design and Engineering - Project management 20,000 15,000 35,000 20,000 20,000 - - - - - - 75,000 Construction Management Total 20,000 15,000 35,000 20,000 20,000 75,000 External Expenses Public Involvement - Land/Right of Way Acquisition - _ _ _ _ _ _ _ Design and Engineering 40,000 7,000 47,000 40,000 30,000 - - - - - - 117,000 Environmental Permit Comp. Construction - 150,000 250,000 - - - - - - 400,000 Contingency 20,000 20,000 40,000 60,000 120,000 Total 60,000 7,000 1 67,000 1 230,000 340,000 - 637,000 Total Project Expense 80,000 1 22,000 102,000 250,000 360,000 712,000 Revenue Funding Source 425-Parks SDC Fund 80,000 22,000 102,000 250,000 360.000 - - - - - - 712,000 Other Revenue Source Total Project Revenues 80,000 22,000 102,000 250,000 360,000 - 712.000 FY 2019-20 First Quarter Supplemental Budget 94038 124th Avenue/Ann Court Culvert Replacement An existing 30-inch storm culvert is failing and undersized and related erosion is threatening the structureal integrity of the road crossing.During heavy rain events,stormwater will flow onto 124th Avenue.This project will replace approximately 85 lineal feet of 30-inch stomtline with a 60- inch wide box culvert.The project is also providing an opportunity to aedd sidewalk where a gap exists on 124th Avenue at the creek crossing. Adopted Revised Revised Revised Revised Revised Revised Budget Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected FY 2020 This Change FY 2020 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 Project Total Internal Expenses Design and Engineering - - - _ _ _ _ - Project Management 12,000 12,000 - - _ _ _ - 12,000 Construction Management Total 12,000 - 12,000 - - 12,000 External Expenses Public Involvement - _ _ _ _ _ _ _ Land/Right of Way Acquisition - _ _ _ _ _ _ _ Design and Engineering 15,000 15,000 - - _ _ _ - 15,000 Environmental Permit Comp. 5,000 Construction 382,000 40,000 422,000 - - - - - - 422,000 Contingency 10,000 10,000 10,000 Total 412,000 40,000 447,000 - 447,000 Total Project Expense 424,000 40,000 459,000 459,000 Revenue Funding Source 200-Gas Tax Fund 30,000 30,000 - - - - - - 30,000 510-Stomtwater Fund 394,000 40,000 434,000 - - - - _ - 434,000 Other Revenue Source Total Project Revenues 424,000 1 40,000 1 464,000 464,000 FY 2019-20 First Quarter Supplemental Budget 94041 Frewing Street Stormline Replacement Existing 12-inch and 24-inch stormlines in Frewing Street east of Pacific Highwy axe in poor condition and include pipe bends that require replacement.This project will replace 235 lineal feet of damaged smrmline,eliminate the bend and replace two catch basins with manholes. Adopted Revised NEW Revised Revised Revised Revised Revised Budget Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected FY 2020 This Change FY 2020 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 Project Total Internal Expenses Design and Engineering - Project Management 27,000 27,000 20,000 - - - - - - 27,000 Construction Management Total 27,000 27,000 20,000 1 27,000 External Expenses Public Involvement - _ _ _ _ _ _ _ Land/Right of Way Acquisition 20,000 20,000 - - - - - - 20,000 Design and Engineering 20,000 106,000 126,000 30,000 - - - - - - 126,000 Environmental Permit Comp. Construction 127,000 127,000 183,000 - - - - - - 127,000 Contingency 25,000 25,000 25,000 - - - 25,000 Total 172,000 126,000 298,000 238,000 298,000 Total Project Expense 199,000 126,000 325,000 258,000 325,000 Revenue Funding Source 510-Stormwater Fund 199,000 126,000 325,000 258,000 !i - - - - - - 325,000 Other Revemre Source Total Project Revenues 199,000 1 126,000 325,000 1 258,000 - 325,000 FY 2019-20 First Quarter Supplemental Budget 95057 Fanno Creek Alignment Stud (Bonita Road to Tualatin River This final section of the Finn Creek Trail was originally envisioned as an on-street alignment on SW 74th Avenue. Subsequent review suggests the constrained width of die 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 Farino Creek and result in a recommended trail alignment. Adopted Revised Revised Revised Revised Revised Revised Budget Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected FY 2020 This Change FY 2020 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 Project Total Internal Expenses Design and Engineering - - - - - - -Project Management 15,000 18,000 33,000 - - - - - - 33,000 Construction Management - - Total 15,000 18,000 1 33,000 33,000 External Expenses Public Involvement - - - - - - - - Land/Right of Way Acquisition - - - - - - - - Design and Engineering 45,000 109,000 154,000 - - - - - - 154,000 Environmental Permit Comp. Construction - - - - - - - - Contingency 10,000 10,000 - 10,000 Total 55,000 1 109,000 1 164,000 164,000 Total Project Expense 70,000 127,000 1 197,000 197,000 Revenue Funding Source 205-City Gas Tax Fund 24,000 12,000 36,000 - - - - - - 36,000 Other Revenue Source - - - - Iii - - - - Wtro-Local Dollars 46,000 115,000 161,000 - - - - - - 161,000 Total Project Revenues 70,000 127,000 197,000 1 197,000 FY 2019-20 First Quarter Supplemental Budget 96050 Former Street/121st Avenue Valve and Piping Improvements Based on current and future population growth on the western ede of the Tigard Water Service Area(River Terrace),the existing water distribution system will not be able to efficiently supply water to this area.This project was identified during the planning stage of the fake Oswego/Tigard Water Partnership.The project includes the design and construction of a pressure-reducing valve,approximatry 900 feet of pipe and associated appurtenances.This project will be constructed as part of the 121 st Avenue Improvement project CIP#95050. Adopted Revised Revised Revised Revised Revised Revised Budget Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected FY 2020 This Change FY 2020 2021 2021 2022 2022 2023 2023 2024 2024 2025 2025 Project Total Internal Expenses Design and Engineering - Project Management 20,000 50,000 70,000 30,000 - - - j - - - 100 000 Construction Management - Total 20,000 50,000 1 70,000 30,000 100,000 External Expenses Public Involvement - - - - - - - - Iand/Right of Way Acquisition - - - - - - - - Design and Engineering 160,000 20,000 180,000 - - - - - - 180,000 Environmental Permit Comp. Construction - 800,000 - - - - - - 800,000 Contingency 20,000 20,000 195,000 - - 215,000 Total 160,000 40,000 1 200,000 995,000 1,195,000 Total Project Expense 180,000 90,000 1 270,000 1,025,000 1,295,000 Revenue Funding Source 530-Water Fund 108,000 54,000 162,000 615,000 - - - - - - 777.000 531-Water SDC Fund 72,000 36,000 108,000 410,000 - - - - - - 518,000 Other Revenue Source - - - - - - - Total Project Revenues 180,000 90,000 270,000 1 1,025,000 1,295,000 AGENDA ITEM No. 5 Date: OCTOBER 15, 2019 TESTIMONY SIGN-UP SHEETS Please sign on the following page(s) if you wish to testify before City Council on: CONSIDER APPROVAL OF RESOLUTION FOR FIRST QUARTER SUPPLEMENTAL BUDGET This is a City of Tigard public meeting, subject to the State of Oregon's public meeting and records laws. All written and oral testimony become part of the public record and is openly available to all members of the public. The names and addresses of persons who attend or participate in City of Tigard public meetings will be included in the meeting minutes, which is a public record. Due to Time Constraints City Council May Impose A Time Limit on Testimony AGENDA ITEM No. 5 Date: OCTOBER 15, 2019 PLEASE PRINT This is a City of Tigard public meeting, subject to the State of Oregon's public meeting and records laws. All written and oral testimony become part of the public record and is openly available to all members of the public. The names and addresses ofpersons who attend or participate in City of Tigard public meetings will be included in the meeting minutes, which is a public record. Pro onent— Speaking In Favor Opponent—(Speaking Against) Neutral Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. AIS-3993 6. Business Meeting Meeting Date: 10/15/2019 Length (in minutes): 10 Minutes Agenda Title: Public Hearing to Consider Approval of Resolution for the First Quarter TCDA Budget Supplemental Prepared For: Steve Kang Submitted By: Steve Kang, Finance and Information Services Item Type: Motion Requested Meeting Type: Town Center Resolution Development Public Hearing- Informational Agency Public Hearing No Newspaper Legal Ad Required?: Public Hearing Publication 10/10/2019 Date in Newspaper: Information ISSUE Shall the Town Center Development Agency adopt a FY 2020 First Quarter Budget Supplemental? STAFF RECOMMENDATION /ACTION REQUEST Staff recommends the Town Center Development Agency approve the FY 2020 First Quarter TCDA Budget Supplemental. KEY FACTS AND INFORMATION SUMMARY The following is a list of items that require council action for FY 2020 in the First Quarter Budget Supplemental: •01TCDA01 CIP 92034 Tigard Street Heritage —Carryforward of prior year appopriations impacting Urban Renewal. •QlTCDA02 CIP 92034-01 Heritage Trail / Rotary Plaza Restroom—Construction contract bid came in higher than anticipated requiring new ask from Urban Renewal for$80k and carryforward of prior year appropriations for$23k. •01TCDA03 Carryforward of UR Improvement Program Opportunity Fund Matching Grant—Carry forward$10,500 in unspent funds from FY 18-19 TCDA Budget for the Urban Renewal Improvement Program Opportunity Fund to fund matching grants for facade improvements that were approved,but not completed. New request for$1,255 for Urban Renewal Improvement Program Opportunity Fund for bike rack program. OTHER ALTERNATIVES Do not approve the FY 2020 First Quarter TCDA Budget Supplemental. COUNCIL OR TCDA GOALS, POLICIES, MASTER PLANS N/A DATES OF PREVIOUS CONSIDERATION This is the first consideration. Fiscal Impact Cost: $253,755 Budgeted (yes or no): No Where Budgeted (department/program): Urban Renewal Additional Fiscal Notes: The FY 2020 First Quarter Supplemental will increase the budget by$254K across two TCDA funds. The expenditure increases are supported through unanticipated beginning fund balances. This supplemental will not change the reserves of the TCDA. Please refer to Exhibits A and B which summarize the fiscal impact of the quarterly supplemental budget by fund. Attachments FY20 Q1 TCDA-Resolution FY20 Q1 TCDA Supplemental Summary FY20 Q1 Exhibit A-TCDA FY20 Q1 Exhibit B-TCDA AgendaQuick©2005-2019 Destiny Software Inc.,All Rights Reserved CITY OF TIGARD, OREGON TIGARD TOWN CENTER DEVELOPMENT AGENCY RESOLUTION NO. 19- A RESOLUTION TO ADOPT THE FY 2020 FIRST QUARTER BUDGET SUPPLEMENTAL INCLUDING BUDGET ADJUSTMENTS TO TOWN CENTER DEVELOPMENT AGENCY (ICDA) URBAN DEVELOPMENT. WHEREAS, the TCDA acknowledges those items that were unknown at the time the FY 2020 budget was adopted;and WHEREAS,the TCDA recognizes approximately$253,755 of unanticipated budget in operations and transfers; and WHEREAS, the increase in budget is offset by unanticipated fund balance, miscellaneous revenue, and contingency. NOW,THEREFORE,BE IT RESOLVED by the Tigard Town Center Development Agency that: SECTION 1: The FY 2019-20 Budget is hereby amended Q1 Supplemental Summary Exhibit B. SECTION: This resolution is effective immediately upon passage. PASSED: This day of 2019. Chair-TCDA ATTEST: TCDA Recorder-TCDA RESOLUTION NO. 19- Page 1 CITY OF TIGARD—BUDGET SUPPLEMENTAL '°""°'s FY 2019-2020 Quarter: 1 Item# Department Fund Division Request Title Request Funding Total Amount Detailed Description Source QITDCA01 Capital MULTIPLE 8000- CIP 92034 Tigard Street Heritage CARRYFORWA Multiple $ 18,000 Carryforward of prior year appropriations impacting Urban Renewal. Improvement CIP/Transfers/Contingency Trail RD QITCDA02 Capital MULTIPLE 8000- CIP 92034-01 Heritage Trail/Rotary NEW/CARRYF Multiple $ 103,000 Construction contract bid came in higher than anticipated requiring new ask from Urban Renewal for$80k and carryforward of prior year Improvement CIP/Transfers/Contingency Plaza Restroom ORWARD appropriations for$23k. QlTCDA03 TCDA MULTIPLE MULTIPLE Carryforward of UR Improvement NEW/CARRYF $ 11,755 Carry forward$10,500 in unspent funds from FY 18-19 TCDA Budget for the Urban Renewal Improvement Program Opportunity Fund to fund Program Opportunity Fund Matching ORWARD matching grants for facade improvements that were approved,but not completed.New request for$1,255 for Urban Renewal Improvement Program I oft Exhibit A QlTCDA01- Carryforward of CIP 92034 Tigard Street Heritage Trail Carryforward of prior year appropriations impacting Urban Renewal. FY 2020 Q1 Revised Urban Renewal Debt Service Adopted Amendment Q1 Resources Beginning Fund Balance $ 148,000 $ 18,000 $ 166,000 Property Taxes $ 560,000 $ - $ 560,000 Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines &Forfeitures $ - $ - $ - Interest Earnings $ 11,100 $ - $ 11,100 Miscellaneous $ - $ - $ - Other Financing Sources $ 792,000 $ - $ 792,000 Transfers In from Other Funds $ - $ - $ - Total Resources $ 1,511,100 $ 18,000 $ 1,529,100 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ _ $ _ Program Expenditures Total $ - $ - $ - Debt Service $ 1,011,350 $ - $ 1,011,350 Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 153,000 $ 18,000 $ 171,000 Contingency $ - $ - $ - Total Budget $ 1,164,350 $ 18,000 $ 1,182,350 Reserve For Future Expenditure $ 346,750 $ - $ 346,750 Total Requirements $ 1,511,100 $ 18,000 $ 1,529,100 Exhibit A 01TCDA01- Carryforward of CIP 92034 Tigard Street Heritage Trail Carryforward of prior year appropriations impacting Urban Renewal. FY 2020 Q1 Revised Urban Renewal Capital Improvements Adopted Amendment Q1 Resources Beginning Fund Balance $ 390,050 $ - $ 390,050 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ - $ - $ Charges for Services $ - $ - $ - Fines &Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ - $ - $ - Other Financing Sources $ 6,208,000 $ - $ 6,208,000 Transfers In from Other Funds $ 533,000 $ 18,000 $ 551,000 Total Resources $ 7,131,050 $ 18,000 $ 7,149,050 Requirements Community Development $ 153,000 $ - $ 153,000 Community Services $ - $ - $ - Policy and Administration $ - $ - $ _ Public Works $ - $ _ $ - Program Expenditures Total $ 153,000 $ - $ 153,000 Debt Service $ - $ _ $ - Loan to TCDA $ - $ _ $ - Work-In-Progress $ 1,504,500 $ 18,000 $ 1,522,500 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ - Total Budget $ 1,657,500 $ 18,000 $ 1,675,500 Reserve For Future Expenditure $ 5,473,550 $ - $ 5,473,550 Total Requirements $ 7,131,050 $ 18,000 $ 7,149,050 Exhibit A QlTCDA01- CIP 92034-01 Heritage Trail / Rotary Plaza Restroom Construction contract came in higher than anticipated requiring new ask from Urban Renewal for$80k and carryforward of prior year appropriations for$23k. FY 2020 Q1 Revised Urban Renewal Debt Service Adopted Amendment Q1 Resources Beginning Fund Balance $ 148,000 $ 103,000 $ 251,000 Property Taxes $ 560,000 $ - $ 560,000 Franchise Fees $ - $ _ $ _ Special Assessments $ - $ _ $ _ Licenses &Permits $ - $ _ $ _ Intergovernmental $ _ $ _ $ _ Charges for Services $ - $ _ $ _ Fines &Forfeitures $ - $ _ $ _ Interest Earnings $ 11,100 $ - $ 11,100 Miscellaneous $ - $ _ $ _ Other Financing Sources $ 792,000 $ - $ 792,000 Transfers In from Other Funds $ - $ - $ - Total Resources $ 1,511,100 $ 103,000 $ 1,614,100 Requirements Community Development $ - $ _ $ _ Community Services $ - $ _ $ _ Policy and Administration $ - $ _ $ _ Public Works $ - $ _ $ _ Program Expenditures Total $ - $ _ $ - Debt Service $ 1,011,350 $ - $ 1,011,350 Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ - $ _ $ _ Transfers to Other Funds $ 153,000 $ 103,000 $ 256,000 Contingency $ - $ _ $ - Total Budget $ 1,164,350 $ 103,000 $ 1,267,350 Reserve For Future Expenditure $ 346,750 $ - $ 346,750 Total Requirements $ 1,511,100 $ 103,000 $ 1,614,100 Exhibit A QlTCDA01- CIP 92034-01 Heritage Trail / Rotary Plaza Restroom Construction contract came in higher than anticipated requiring new ask from Urban Renewal for$80k and carryforward of prior year appropriations for$23k. FY 2020 Q1 Revised Urban Renewal Capital Improvements Adopted Amendment Q1 Resources Beginning Fund Balance $ 390,050 $ - $ 390,050 Property Taxes $ _ $ _ $ _ Franchise Fees $ - $ _ $ _ Special Assessments $ - $ _ $ _ Licenses &Permits $ - $ _ $ _ Intergovernmental $ _ $ _ $ _ Charges for Services $ - $ _ $ _ Fines &Forfeitures $ - $ _ $ _ Interest Earnings $ - $ - $ _ Miscellaneous $ - $ _ $ _ Other Financing Sources $ 6,208,000 $ - $ 6,208,000 Transfers In from Other Funds $ 533,000 $ 103,000 $ 636,000 Total Resources $ 7,131,050 $ 103,000 $ 7,234,050 Requirements Community Development $ 153,000 $ - $ 153,000 Community Services $ - $ - $ _ Policy and Administration $ - $ _ $ _ Public Works $ - $ _ $ _ Program Expenditures Total $ 153,000 $ - $ 153,000 Debt Service $ - $ _ $ _ Loan to TCDA $ - $ _ $ _ Work-In-Progress $ 1,504,500 $ 103,000 $ 1,607,500 Transfers to Other Funds $ - $ - $ _ Contingency $ - $ _ $ _ Total Budget $ 1,657,500 $ 103,000 $ 1,760,500 Reserve For Future Expenditure $ 5,473,550 $ - $ 5,473,550 Total Requirements $ 7,131,050 $ 103,000 $ 7,234,050 Exhibit A 01TCDA03 - Carryforward of UR Improvement Program 01212ortuniiy Fund Matching Grant Carry forward$10,500 in unspent funds from FY 18-19 TCDA Budget for the Urban Renewal Improvement Program Opportunity Fund to fund matching grants for facade improvements that were approved, but not completed. New request for$1,255 for Urban Renewal Improvement Program Opportunity Fund for bike rack program. FY 2020 Q1 Revised Urban Renewal Capital Improvements Adopted Amendment Q1 Resources Beginning Fund Balance $ 390,050 $ 11,755 $ 401,805 Property Taxes $ - $ _ $ _ Franchise Fees $ - $ _ $ _ Special Assessments $ - $ _ $ _ Licenses &Permits $ - $ _ $ _ Intergovernmental $ - $ _ $ _ Charges for Services $ - $ - $ _ Fines &Forfeitures $ - $ _ $ _ Interest Earnings $ - $ - $ _ Miscellaneous $ _ $ _ $ _ Other Financing Sources $ 6,208,000 $ - $ 6,208,000 Transfers In from Other Funds $ 533,000 $ - $ 533,000 Total Resources $ 7,131,050 $ 11,755 $ 7,142,805 Requirements Community Development $ 153,000 $ - $ 153,000 Community Services $ - $ _ $ _ Policy and Administration $ - $ _ $ _ Public Works $ _ $ _ $ _ Program Expenditures Total $ 153,000 $ - $ 153,000 Debt Service $ _ $ _ $ _ Loan to TCDA $ _ $ _ $ _ Work-In-Progress $ 1,504,500 $ 11,755 $ 1,516,255 Transfers to Other Funds $ - $ - $ - Contingency $ - $ _ $ _ Total Budget $ 1,657,500 $ 11,755 $ 1,669,255 Reserve For Future Expenditure $ 5,473,550 $ - $ 5,473,550 Total Requirements $ 7,131,050 $ 11,755 $ 7,142,805 Exhibit B Urban Renewal Debt Service FY 2020 Revised Urban Renewal Debt Service Adopted QITCDA01 QlTCDA02 Q1 Resources Beginning Fund Balance $ 148,000 $ 18,000 $ 103,000 $ 269,000 Property Taxes $ 560,000 $ - $ - $ 560,000 Franchise Fees $ - $ $ - $ - Special Assessments $ $ - $ - $ Licenses&Permits $ $ $ $ Intergovernmental $ - $ $ $ Charges for Services $ $ $ $ Fines&Forfeitures $ $ $ $ -- Interest Earnings $ 11,100 $ $ $ 11,101) Miscellaneous $ - $ $ $ - Other Financing Sources $ 792,000 $ $ $ 792,000 Transfers In from Other Funds $ - $ $ $ - Total Resources $ 1,511,100 $ 18,000 $ 103,000 $ 1,632,100 Requirements Community Development $ - $ - $ - $ - Community Services $ $ $ $ - Policy and Administration $ $ $ $ - Public Works $ - $ $ $ - Program Expenditures Total $ - $ - $ - $ - Debt Service $ 1,011,350 $ - $ - $ 1,011,350 Loan to TCDA $ - $ $ - $ Work-In-Progress $ - $ - $ $ Transfers to Other Funds $ 153,000 $ 18,000 $ 103,000 $ 274,000 Contingency $ - $ - $ - $ - Total Budget $ 1,164,350 $ 18,000 $ 103,000 $ 1,285,350 Reserve For Future Expenditure $ 346,750 $ - $ - $ 346,750 Total Requirements $ 1,511,100 $ 18,000 $ 103,000 $ 1,632,100 Exhibit B Urban Renewal Capital Improvements FY 2020 Revised Urban Renewal Capital Improvements Adopted QlTCDA01 QlTCDA02 QITCDA03 Q1 Resources Beginning Fund Balance $ 390,050 $ - $ - $ 11,755 $ 401,805 Property Taxes $ - $ $ - $ - $ - Franchise Fees $ - $ $ - $ $ Special Assessments $ - $ $ - $ $ - Licenses&Permits $ - $ $ - $ $ - Intergovernmental $ $ $ $ $ - Charges for Services $ - $ $ $ $ - Fines&Forfeitures $ - $ $ $ $ - Interest Earnings $ $ $ - $ - $ - Miscellaneous $ - $ $ - $ $ - Other Financing Sources $ 6,208,000 $ $ $ - $ 6,208,000 Transfers In from Other Funds $ 533,000 $ 18,000 $ 103,000 $ $ 654,000 Total Resources $ 7,131,050 $ 18,000 $ 103,000 $ 11,755 $ 7,263,805 Requirements Community Development $ 153,000 $ - $ - $ - $ 153,000 Community Services $ - $ $ - $ - $ - Policy and Administration $ - $ $ - $ $ Public Works $ - $ $ - $ - $ - Program Expenditures Total $ 153,000 $ - $ - $ - $ 153,000 Debt Service $ - $ $ $ $ - Loan to TCDA $ - $ $ $ $ - Work-In-Progress $ 1,504,500 $ 18,000 $ 103,000 $ 11,755 $ 1,637,255 Transfers to Other Funds $ - $ - $ - $ - $ - Contingency $ - $ - $ - $ - $ - Total Budget $ 1,657,500 $ 18,000 $ 103,000 $ 11,755 $ 1,790,255 Reserve For Future Expenditure $ 5,473,550 $ - $ - $ - $ 5,473,550 Total Requirements $ 7,131,050 $ 18,000 $ 103,000 $ 11,755 $ 7,263,805 AGENDA ITEM No. 6 Date: OCTOBER 15, 2019 TESTIMONY SIGN-UP SHEETS Please sign on the following page(s) if you wish to testify before City Council on: CONSIDER APPROVAL OF RESOLUTION FOR TOWN CENTER DEVELOPMENT AGENCY (ICDA) FIRST QUARTER SUPPLEMENTAL BUDGET This is a City of Tigard public meeting,subject to the State of Oregon's public meeting and records laws. All written and oral testimony become part of the public record and is openly available to all members of the public. The names and addresses of persons who attend or participate in City of Tigard public meetings will be included in the meeting minutes, which is a public record. Due to Time Constraints City Council May Impose A Time Limit on Testimony AGENDA ITEM No. 6 Date: OCTOBER 15, 2019 PLEASE PRINT This is a City of Tigard public meeting, subject to the State of Oregon's public meeting and records laws. All written and oral testimony become part of the public record and is openly available to all members of the public. The names and addresses ofpersons who attend or participate in City of Tigard public meetings will be included in the meeting minutes, which is a public record. Pro onent—(Speaking In Favor Opponent—(Speaking Against) Neutral Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No. WEEEM� J Name,Address&Phone No. Name,Address&Phone No. Name,Address&Phone No.