Loading...
City Council Packet - 09/28/2021 • ® City of Tigard gi • Tigard Business Meeting—Agenda TIGARD TIGARD CITY COUNCIL,LOCAL CONTRACT REVIEW BOARD, &TOWN CENTER DEVELOPMENT AGENCY MEETING DATE AND TIME: September 28,2021 -6:30 p.m.Business Meeting MEETING LOCATION: Remote participation only.See PUBLIC NOTICE below. PUBLIC NOTICE:In accordance with the City of Tigard's Emergency Declaration related to COVID-19 and Oregon House Bill 4212,this will be a virtual meeting where Council and staff will participate remotely.There will be no in-person public testimony during this meeting. How to comment: •Written public comment may be submitted electronically at www.tigard-or.gov/Comments.All comments must be submitted before noon the day of the meeting. •If you prefer to call in,please call 503-966-4101 when instructed to be placed in the queue.We ask that you plan on limiting your testimony to three minutes.If you would like to speak on public hearing items#6 or#7,please call prior to their estimated times. SEE ATTACHED AGENDA VIEW LIVESTREAM ONLINE:http://www.tigard-or.gov/city hall/council_meeting.php CABLE VIEWERS:The first City Council meeting of the month may be shown live on Channel 28 at 6: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 TIGARD CITY COUNCIL,LOCAL CONTRACT REVIEW BOARD, &TOWN CENTER DEVELOPMENT AGENCY MEETING DATE AND TIME: September 28,2021 -6:30 p.m.Business Meeting MEETING LOCATION: Remote participation only. 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. PUBLIC COMMENT A. Follow-up to Previous Public Comment B. Public Comment—Written C. Public Comment—Phone-In 3. CONSENT AGENDA: (Local Contract Review Board)The Consent Agenda is used for routine items including meeting minutes and approval of contracts or intergovernmental agreements.Information on each item is available on the city's website in the packet for this meeting.These items may be enacted in one motion without separate discussion.Council members may request that an item be removed by motion for discussion and separate action. Motion to: A. LOCAL CONTRACT REVIEW BOARD—CONTRACT AWARD FOR A WATER RECYCLER VEHICLE B. LOCAL CONTRACT REVIEW BOARD—CONTRACT AWARD FOR FREWING STREET SIDEWALK INFILL-COMMUNITY DEVELOPMENT BLOCK GRANT(CDBG) •Consent Agenda-Items Removed for Separate Discussion:Any items requested to be removed from the Consent Agenda for separate discussion will be considered immediately after the Council has voted on those items which do not need discussion. 4. PROCLAIM OCTOBER DOMESTIC VIOLENCE AWARENESS MONTH 6:45 p.m.estimated time 5. TIGARD PUBLIC LIBRARY STRATEGIC PLAN UPDATE PRESENTATION 6:50 p.m.estimated time 6. PUBLIC HEARING:CONSIDER A RESOLUTION APPROVING THE FY 2022 FIRST QUARTER BUDGET SUPPLEMENTAL 7:20 p.m.estimated time 7. TOWN CENTER DEVELOPMENT AGENCY-PUBLIC HEARING:CONSIDER A RESOLUTION APPROVING THE FIRST QUARTER TCDA BUDGET SUPPLEMENTAL 7:40 p.m.estimated time 8. WASHINGTON COUNTY LAND USE&TRANSPORTATION (LUT)BRIEFING ON MAJOR STREETS IMPROVEMENT PROGRAM(MSTIP)WORK PLAN 7:45 p.m.estimated time 9. NON-AGENDA ITEMS 10. ADMINISTRATIVE REPORT 11. 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. 12. ADJOURNMENT 8:30 p.m.estimated time 111111 ■ TIGARD ,t No Public Comment was received by the noon deadline for the September 28, 2021 Tigard City Council meeting. AIS-4730 3.A. Business Meeting Meeting Date: 09/28/2021 Length(in minutes): Consent Item Agenda Title: LOCAL CONTRACT REVIEW BOARD—CONTRACT AWARD FOR A WATER RECYCLER VEHICLE Prepared For: Christine Moody Submitted By: Machelle Stephens, Finance and Court Presented By: Item Type: Motion Requested Public Hearing Yes Newspaper Legal Ad Required?: Public Hearing Publication 09/03/2021 Date in Newspaper: Information ISSUE The Local Contract Review Board will consider awarding a contract to Owen Equipment for a Water Recycler. STAFF RECOMMENDATION /ACTION REQUEST The Contract team recommends that the Local Contract Review Board award a contract to Owen Equipment for the purchase of 2100i Water Recycler in the amount of$601,397.00 and direct the City Manager to take the steps necessary to execute the contract. KEY FACTS AND INFORMATION SUMMARY The Sanitary and Stormwater divisions are requesting the purchase of a replacement hydro-cleaning truck. The current truck was purchased in 2011 and is very near the end of its useful service life. To date,the city has spent$125,000 on maintenance for this vehicle. The maintenance cost will continue to increase as the aging equipment requires periodic"downtime"due to increased maintenance,downtime also reduces productivity and customer service as the equipment is out of service. In addition to phasing out the aging,maintenance-heavy vehicle#12-047,the new truck will include modifications that will allow for the recycling of water by pulling water from wet debris—a process that requires much more complex screens and will make the process much more environmentally conscientious. This will allow significant reduction in the number of materials going to dumpsites (dumpsites are becoming increasingly scarce with the closing of our dumpsite last year)and,in direct correlation, increased productivity by our teammates as they will lose less time driving back and forth from the dumpsites. During the budget process,our teammates were able to relay to the Council that this reduction in trips and their associated cost will ensure that the upgraded recycling modifications will save on the budget. Owen Equipment through Federal Signal Corp/Vactor Manufacuring holds a national cooperative contract through Sourcewell,a governmental service cooperative in which the City is a member. As such the City is eligible to make an Interstate Cooperative procurement per ORS 279A.215 and Tigard Public Contracting Rule 10.085 rather than conduct its own solicitation. This allows the City to obtain the best pricing and utilize an existing contract,saving time and money. The City has determined this is the most cost-effective way to purchase this item. OTHER ALTERNATIVES The Local Contract Review Board may choose to not utilize this contract and direct staff to issue a bid. This would extend the project timeframe and delay the purchase of the Water Recycler. COUNCIL GOALS,POLICIES,APPROVED MASTER PLANS 2020-2025 Strategic Plan: Priority 3.5 reduction in climate impacts. 2021-2022 Council Goals Goal 3:Limate and Resiliency Plan 3.3 Communicate our resiliency efforts to the community to encourage individuals and business to adopt new practices that support climate goals. DATES OF PREVIOUS COUNCIL CONSIDERATION N/A Fiscal Impact Cost: $601,397.0 Budgeted (yes or no): Yes Where budgeted?: Sanitary Sewer and Stormwater Funds Additional Fiscal Notes: This vehicle is appropriated evenly across the Sanitary Sewer and Stormwater funds through their respective operating divisional budgets.The upgraded recycling vehicle modifications were presented to and approved by the Council through a technical adjustment during the budget adoption on June 8,2021. Attachments No file(s)attached AIS-4724 3.B. Business Meeting Meeting Date: 09/28/2021 Length(in minutes): Consent Item Agenda Title: LOCAL CONTRACT REVIEW BOARD—CONTRACT AWARD FOR FREWING STREET SIDEWALK INFILL-CDBG Prepared For: Machelle Stephens Submitted By: Carol Krager,City Management Presented By: Item Type: Motion Requested Public Hearing Legal Ad Required?: Publication Date: Information ISSUE The Local Contract Review Board will consider the award of a contract for Frewing Street Sidewalk Infill. STAFF RECOMMENDATION /ACTION REQUEST The team ecommends that the Local Contract Review Board award a contract to Lee Contractors LLC for the Frewing Street Sidewall Infill in the amount of$582,000.00 and direct the City Manager to take the steps necessary to execute the contract. KEY FACTS AND INFORMATION SUMMARY The Frewing Street Sidewalk Infill project will provide safe and convenient access by providing a continuous sidewalk along one side of SW Frewing Street between SW Ash Avenue and SW Pacific Highway. Currently,pedestrians living in the apartments and single-family homes along Frewing Street are forced to walk in the roadway. The improvements are targeted to be equitable and sustainable. A formal Invitation to Bid was issued on August 9,2021. The City received six bids from the following firms: 1.Lee Contractors LLC-$582,000.00 2.Pacific Excavation Inc-$644,000.00 3.Brown Contracting Inc-$688,888.00 4.MJ Hughes Construction-$671,500.00 5.Moore Excavation Inc-$738,027.00 6.Kodiak Pacific Construction-$798,399.00 Staff reviewed the bids and determined that Lee Contractors LLC has submitted the lowest responsible bid,with the base bid.The company has no State of Oregon Contractor Construction Board violations and is not on the Bureau of Labor and Industries ineligible list. OTHER ALTERNATIVES The Local Contract Review Board may reject all bids and direct staff to evaluate and resolicit bids.This would extend the project timeframe and delay the installation of sidewalks. COUNCIL OR TCDA GOALS,POLICIES,MASTER PLANS 2020-2025 Strategic Plan: Priority Two—Create a well-connected attractive and accessible pedestrian network. DATES OF PREVIOUS CONSIDERATION N/A Fiscal Impact Cost: $582,000.00 Budgeted(yes or no): yes Where Budgeted(department/program):Varies Additional Fiscal Notes: Community Development Block Grant(partial) Facilities Capital Projects $148,703 Requested from Washington County Attachments No file(s)attached. AIS-4709 4. Business Meeting Meeting Date: 09/28/2021 Length(in minutes): 5 Minutes Agenda Title: Proclaim October Domestic Violence Awareness Month Prepared For: Kathy McAlpine,City Management Submitted By: Joanne Bengtson,City Management Presented By: Item Type: Update,Discussion,Direct Staff Public Hearing No Legal Ad Required?: Publication Date: Information ISSUE The City Council may proclaim October as Domestic Violence Awareness Month. STAFF RECOMMENDATION/ACTION REQUEST Issue the Proclamation in support of all the volunteers and emergency service personnel who serve victims of domestic violence. KEY FACTS AND INFORMATION SUMMARY Chief McAlpine would like to say a few words about Domestic Violence Awareness Month.Law enforcement works with the Washington County District Attorney's Office,Victim Assistance Program to end the cycle of domestic violence. The goal of this recognition campaign is to remind everyone that ending domestic violence starts with just one small action,whether that is seeking help or sharing resources.According to a CDC survey,20 Americans experience intimate partner physical violence every minute.That totals around 10 million victims per year. OTHER ALTERNATIVES N/A COUNCIL GOALS,POLICIES,APPROVED MASTER PLANS N/A DATES OF PREVIOUS COUNCIL CONSIDERATION This is the second year Council will consider issuing this proclamation. Attachments Domestic Violence Awareness Month Domestic Violence Awareness Month-Spanish ciff..) - . 1 41\i,' ::.::1 - 4. , ii - yi / I II Ot / / ./' {l f / 1. / i11,',t..:44 ii1 .- :. DOMESTIC VIOLENCE AWARENESS MONTH A j ., ;i WHEREAS,domestic violence is a serious crime that affects people of all races,ages,gender identities, I ` `ry i , socio-economic levels,religions,backgrounds,beliefs and abilities but often has a disproportionate effect '.' Y 4006-4 � on communities and groups impacted by inequity;and ' I WHEREAS,domestic violence includes physical,emotional,social,sexual,spiritual,financial and digital P: Ait II abuse;and can occur between family members,intimate partners and within dating relationships;and n� WHEREAS, more than one in three women and one in four men in the United States report having i experienced domestic violence,stalking,sexual assault or physical assault by an intimate partner during their lifetime;and a { i w '! WHEREAS, domestic violence impacts vulnerable victims including children. Approximately 50% of I Washington County children who are child abuse victims also live in homes with domestic violence;and `' s WHEREAS, multiple scientific and medical studies show that trauma, especially for children who ;;. 41 experience what is known as "Adverse Childhood Experiences" increases the likelihood the individual . ;i may struggle with addiction,mental health or other challenges later in life;and No. WHEREAS,the COVID-19 pandemic has had a continual tremendous impact on survivors seeking and w being able to access on-going services. In 2020, the Family Justice Center served a total of 1,466 : r IV survivors and the Domestic Violence Resource Center provided 12,236 crisis services to survivors ,e despite challenges due to the pandemic;and' t: WHEREAS the Washington County community has united to address the impact of all forms of family i violence4tok. ,including domestic violence,child abuse and neglect,and is working to establish a new facility called the Family Peace Center of Washington County;and 'a- WHEREAS,domestic violence incidents are some of the most complex and dangerous incidents that I. law enforcement respond to in our community,putting their lives at risk every day in the belief that a coordinated community response is necessary to support survivors,hold offenders accountable and ie work toward ending the cycle of violence;and � ` *1-1-- WHEREAS,Domestic Violence Awareness Month provides an excellent platform to show support for :3 the domestic violence advocates,crisis hotline staff,victim service organizations,the prosecutors who hold offenders accountable,and law enforcement officers in our community and provides the citizens of a v. k Washington County the opportunity to learn more about preventing domestic violence and show support for the numerous organizations and individuals who provide critical advocacy,resources,hope and t =' .. ..";..1,,,,-,,,4,- assistance to victims. -Ag�f NOW,THEREFORE, BE IT RESOLVED that the City of Tigard City Council does hereby proclaim oillie . the month of October 2021 as zy DOMESTIC VIOLENCE AWARENESS MONTH : It °- in Tigard,Oregon and urge all residents to show support for the victim service organizations and law �: enforcement officers in our community who provide critical assistance to victims. '. t.4+' • Dated this day of September 2021 7: �t IN WITNESS WHEREOF,I have hereunto set my hand and caused the Seal of the City of Tigard to be I affixed. ; ' Jason B.Snider,Mayor Attest: City of Tigard i'a? rti: i. Carol A.Krager,City Recorderp? 4.' .. .....—:... ... . ....... ........ .,.,„... -- w,, .: 4sYyYVY' Y�gYloWYi9 f ; . C' ,,,,,',,,, : -..k....-- 41--, Ag'-- N,-,---Nsi,-1,4-— •.1"-- • -4,----.L.._,_22_,-.'• '13::41...,r__^.,____2'-_,_---,._____._i'A'-'•,;De 4 i, i.: ,,,-.. ,..)7..,p,---"--'-'------------------ .--------.------------, . ,,,, „.. ,,,,,,„,.....,,.., , ...,,,,,,„.„, ,„ ii„.......,,,,, lit „ill t /(,) �/ i f ( ( (.r- i r if . ,,,,,.,t,„„ - , ..„ lit (f Tigard ii 014tk EL MES DE CONCIENTIZACION SOBRE LA VIOLENCIA DOMESTICA CONSIDERANDO QUE la violencia domestica es un delito grave que afecta a personas de todas las o k, razas,edades,identidades de genero,niveles socioeconomicos,religiones,origenes,creencias y capacidades,pero que con frecuencia tiene un efecto desproporcionado en las comunidades y grupos ?KF'tt afectados por la inequidad;y QUE la violencia domestica incluye abuso fisico,emocional,social,sexual,espiritual,financiero y S ,,„•,;,.,,,,. digital;y que puede ocurrir entre miembros de la familia,parejas intimas y dentro de relaciones de noviazgo;y ry QUE más de una de cada tres mujeres y uno de cada cuatro hombres en Estados Unidos denuncian ah haber experimentado violencia domestica,acoso,agresion sexual o agresion fisica por parte de una 9 , pareja intima en su vida;y .•s s 't'` QUE la violencia domestica afecta a victimas vulnerables,que incluyen ninos,ya que i aproximadamente el 50%de los ninos del Condado de Washington victimas de abuso infantil tambien A b-` vive en hogares con violencia domestica;y it 741104 QUE multiples estudios medicos y cientificos demuestran que el trauma,especialmente para ninos que ! > r . sufren to que se conoce como"experiencias adversas en la infancia”o"ACE"por su sigla en ingles, '• aumenta la probabilidad de que la persona pueda tener problemas de adiccion,salud mental u otros i_i @<, problemas más adelante en su vida;y1. VISTO QUE la pandemia del COVID-19 ha tenido un efecto enorme y continuo en los sobrevivientes y g en el acceso a servicios continuos;y �. QUE,en 2020,Family Justice Center(Centro de Justicia Familiar)atendio a un total de 1466 x. '�'' sobrevivientes y que Domestic Violence Resource Center(Centro de Recursos para la Violencia t Domestica)presto 12,236 servicios ante crisis a sobrevivientes a pesar de los problemas debido a la 1 . pandemia;y .. i QUE nuestra comunidad del Condado de Washington se ha reunido para atender los efectos de todas o r-1-.'',i ' las formas de violencia familiar,inclusive la violencia domestica y el abuso y abandono infantil,y este � ,, trabajando para establecer un centro nuevo llamado Centro para la Paz de la Familia del.Condado de P 'lir' Washington(Family Peace Center of Washington County);y �,,' QUE los incidentes de violencia domestica son unos de los incidentes mas complejos y más peligrosos 4C i(. a los que responder los funcionarios policiales en nuestra comunidad,que ponen sus vides en riesgo a li r. diario con la creencia de que es necesario tener una respuesta comunitaria coordinada para apoyar a los sobrevivientes,hacer responsables de sus actos a los agresores y trabajar para terminar con el Ir. ^} ,4- ciclo de violencia;y 1, ilk'''' EN VISTA DE QUE el Mes de concientizaciOn sobre la violencia domestica brinda una plataforma s excelente para mostrar el apoyo a los defensores contra la violencia domestica,el personal de la linea directa de crisis,las organizaciones de servicios para victimas,los fiscales que hacen responsables deii}t3 sus actos a los agresores y los funcionarios policiales en nuestra comunidad,y da a los ciudadanos del .::,::,::-4-;-, - Condado de Washington la oportunidad de aprender más sobre la prevencion de la violencia domestica : f (t ;<:, y demostrar el apoyo a las numerosas organizaciones y personas que brindan defensa,recursos, V :"' esperanza y asistencia fundamentales a las victimas. 3 ASI,POR LO TANTO,SE RESUELVE que el Ayuntamiento Ciudad de Tigard,por el presente declaroa que el mes de Octubre de 2021 es t EL MES DE CONCIENTIZACION SOBRE LA VIOLENCIA DOMESTICA 'Vigil'A ... Y3.4.,:,,.:44, Fechado este_dia de Septiembre 2021 -F 4 EN TESTIMONIO DE LO CUAL,he suscrito la presente y he hecho que se coloque el Sello de la ; "`' Ciudad de Tigard. a t a '..7,--'1 w Jason B.Snider,Alcalde Dar fe: Ciudad de Tigard. i. Carol A.Krager,Grabadora de la ciudad t', , , AIS-4687 5. Business Meeting Meeting Date: 09/28/2021 Length(in minutes): 30 Minutes Agenda Title: Tigard Public Library Strategic Plan Update Presentation Prepared For: Halsted Bernard,Library Presented By: Item Type: Update,Discussion,Direct Staff Public Hearing No Legal Ad Required?: Publication Date: Information ISSUE The Tigard Public Library has initiated our latest 5-year Srategic Plan.Library teammates,Halsted Bernard,Director of Library Services and Amber Bell,Readers Services Manager would like to present the Plan to the Council. STAFF RECOMMENDATION/ACTION REQUEST This presentation is a briefing,designed to familiarize the Council with the main points of the Library Strategic Plan in order to support the strategic priorities of the Library as the Library serves the community. KEY FACTS AND INFORMATION SUMMARY The Tigard Public Library's current 5-year strategic plan,which began on July 1 of this year,sets priorities that highlight access, equity,and community connection.A few key actions include enhancing outdoor spaces to extend learning and play beyond the building,increasing technology access to bridge the digital divide,and partnering with the school district to provide library cards for all TTSD students. The updated plan complements and aligns with the City's refreshed Strategic Plan,the newly adopted Council goals,and our Community Promise or 5"E"s. OTHER ALTERNATIVES N/A COUNCIL GOALS,POLICIES,APPROVED MASTER PLANS The Library's strategic plan supports Council goal strategy 2.2 to address the barriers that exist within the digital divide. DATES OF PREVIOUS COUNCIL CONSIDERATION This is the first time Amber Bell and Halsted Bernard have presented a newly published Library Strategic Plan. Attachments Presentation Tigard Public Library STRATEGIC PLAN ..,. . .''�—„ 2 21 �Imo n it 7 f'"'' V ", -- I Q rill iti/ '" A J • f . N't. Ili :4't 4' 11101"r' 't 11:-:'' Tigard Public Library .. .y, d Serving the public since 1963 • ' ' ' - ' * V I S I 0 N • • for theTigard Public Library - - _ • , A community hub for knowledge and enrichment • • where everyone feels welcome. • .11P go* 1111111 Indoor and Customer Service Updating Policies Outdoor Spaces ry m as - ',:'''','7,,',7i'/,/,' tOtiV w,,,,, 4,40A, Access to Materials Professional development Bridging the Digital Divide 010.1 I Filliviii) Support for Students Events Outreach and Job Seekers « »z \ / \ p} ® ° z « : / . s« ,e � ... \ , . » ��\�;r : \ v . . > y��� %°��\2 : ,,,,,„,,,,„. 4.1,4.: ? \ \ \ \ » \ . \ \ \ \ \ / > » » „ 2 , > ' } « %«m \ } � ( p .:! 6 , � + . ,,,i-.<a Library Reports Budget Narrative City Report Card Tigard Public Library Notb, STRATEGIC PLAN . --„=„----- ,_ 4.. ...k, ,,tt ....., , :" 4 ' . - t-7-w-------__ 0„-s' -: . ,, - - _ , - -.4 :?!.14;11-4117:18111111n7..:3 ul:_l' 711‘,1:1,1 PI °:\/".1k . 'dr.::k 4i, drip, .., ✓ �^ 1• '"Vosl „:, �e,w mow'--•.""^_' , „�:lmir_:-'1 :::,•':14. � , iit PLAN ESTRATEGICO 11111 de la biblioteca pUblica de Tigard OTigard Public Library "I Serving the public since 1963 13500 SW Hall Blvd • Tigard, OR 97223 503.684.6537•www.tigard-or.gov/library AIS-4705 6. Business Meeting Meeting Date: 09/28/2021 Length(in minutes): 20 Minutes Agenda Title: Public Hearing:Consider a Resolution Approving the FY 2022 First Quarter Budget Supplemental Presented By: Item Type: Public Hearing Legal Ad Required?: Publication Date: 09/23/2021 Information ISSUE Submitting the Fiscal Year(FY)2022 First Quarter Budget Supplemental to the City Council for review,consideration,and adoption. STAFF RECOMMENDATION/ACTION REQUEST Finance recommends that the City Council approve the FY 2022 First Quarter Budget Supplemental. KEY FACTS AND INFORMATION SUMMARY The following is the summary of items that require council action for FY 2022 First Quarter Budget Supplemental: Carryforwards and Technical Adjustments: Community Development(CD)—CD is requesting to carryforward three items;Economic Development's business support programs,Washington Square Regional Center update project,and Tigard MADE project phase II. The first two requests have seen a delay due to the COVID-19 pandemic and Tigard MADE project phase II is due to the splitting the project into two phases resulting in the project going into FY22. Finance and Information Services (FIS)—The first request is a technical adjustment for the increase of Risk Analyst's FTE from 0.80 FTE to 1.00 FTE. This request was approved in the FY21 Q3 Supplemental Budget but was omitted during the technical adjustment phase of the budget adoption. FIS is also requesting two carryforwards from Information Services Division,one for Tyler Project Implementation and one for additional conference room equipment which will allow the city to run hybrid Teams meetings more efficiently. The Tyler project team is requesting to carryforward unused Tyler project implementation funds due to timing such as Software as a Service(SaaS) fees,travel expenses,implementation fees,data conversion category dollars,and Limited Duration FTEs for GIS and HR/CM office dedicated to the Tyler implementation.The carryforward funds will be used for the exact same purpose at the same amount;the only thing that has changed is the timing of when the funds are needed(FY22 vs FY21) within the project.Teams equipment request is due to equipment arriving late. Police—Police has two carryforwards,and both are due to the supply chain delivery constraints. One request is for the annual ammunition purchase and the other is for the Traffic Unit office furniture. Public Works Operations—PW Operations has three carryforward requests,and all are related to the supply chain issues related to the COVID-19 pandemic. The requests are for vehicles,a transfer switch for reservoir#2,and professional services related to an overhaul of the city's Engineering Standards. New Requests: City Management(CM)—CM has two new budget appropriation requests. First one is for the Professional recruiting firm to assist in selecting a new Finance Director and an additional Assistant City Manager(ACM)to oversee a variety of departments that focus on infrastructure and investment,assist major initiatives around climate change,homelessness,and parks and recreation.The work will be accomplished through the lens of recently adopted Community Promise to improve internal alignment that enhances our teamwork and our strategic capacity.The second request is for a consulting service to conduct a high-level organizational assessment of Finance and Information Services functions,recommend internal service funds and methodologies,provide financial management advice to the finance team,managers and elected Officials,support implementation of Tyler ERP system,provide advice on debt issuance and administration,and review the city's latest long-range General Fund financial forecast. The budget requirements for this request will be partially offset by vacancy savings in FIS. Community Development(CD)—CD is requesting for a budget appropriation to launch a mobile business incubator,Launch Pod. Economic Development has secured$70,000 from Washington County and$12,000 from AARP grant for the Launch Pod business incubator.Total project request will be$107,000 and of the total,$25,000 will be the city's contribution. The city's contribution will be drawn from ARPA allocation,which the city council approved on August 10,2021. The requested funding will outfit two mobile business incubators.The Launch Pod is a mobile business incubator that creates a low-barrier-to-entry starting point from which food&beverage entrepreneurs can launch a business in Tigard.Entrepreneurs for this business incubator will be recruited from the city's network of business-advising partners focused on serving business owners from historically under-served and marginalized populations. Finance and Information Services(FIS)—Finance's request is for the Verizon Connect fleet management system. The system will help automate manual processes like preventative maintenance,vehicle error codes,Tyler integration,fleet usage,safety,risk management,carbon footprint reporting,data informed fleet management decisions.This request will be an ongoing annual cost for all city vehicles with Verizon Connect. Police(PD)—Police's request is for a replacement of a patrol vehicle.In July,an officer discovered that patrol vehicle#19-858 was damaged on the passenger side of the front door where the vehicle molding was displaced.The corresponding damage that caused the displaced molding was very low on the vehicle and not noticeable during daily inspections.The PD completed a due diligence investigation to determine causal factors,however no operator knew of an incident where the damage occurred.Other inspection processes also revealed no further information about a date,time or location for this significant damage.Fleet determined that the damage was severe enough that the vehicle would need to be removed from service and replaced. This request will be partially funded by the insurance payment and sale of the damaged patrol vehicle thru an auction. PW Capital Improvement Plan(CIP)—Carryforwards: •Facilities oCIP 91023 Public Works Field Staff Work Area and Breakroom—$25,000.Delay in contract award,largely due to teammates dedicated to needs and supply chain issues,has pushed entire project into FY 2022. •Parks •CIP 92059 Universal Plaza—$86,000. Construction did not start as scheduled;estimated cost requires the dollars remain available. •CIP 92016-08 Dirksen Nature Park-Off-Street Parking Lot—$46,000.Permitting through CWS has taken longer than expected,causing delay in the project. •CIP 92016-13 Dirksen Nature Park-Wetland Boardwalk and Walkway—64,500.Moved construction out one year to build the off-street parking lot and boardwalk as one project.Also,permitting through CWS has taken longer than expected,causing delay in the project. •CIP 92056 Park System Master Plan Update—$26,500.Due to additional work,which was added to the project last year,the project completion date is extended. No new appropriations are being requested. •Stormwater •CIP 94048 Oak Street Property Acquisition—$28,000.Additional permitting required due to the proximity of steep slopes.Hazardous materials(Asbestos and lead)have been found in the house which requires a Plans and Hazardous Building Material Survey to assist with proper removal of hazardous building materials. •Transportation •CIP 95063 Transportation System Plan Update—$51,500.The project has been delayed due to consultant team changes and COVID-19 related issues.An increase in contract scope to include additional active transportation network planning and legislative adoption tasks have also increased the project timeframe.The total project amount remains the same as the adopted CIP budget. •CIP 95065 Pacific Highway Street Lights—$226,160.IGA with ODOT is being adjusted to remove two intersections that were included in this project and another project that is being managed by ODOT.A third intersection,at Bull Mountain Road,has been added to the City of Tigard Project. This discrepancy led to the project being delayed. Total project cost remains the same as the adopted CIP budget. •Water •CIP 96055 Risk and Resilience Assessment and Emergency Response Plan—$36,000.The City of Tigard will participate in a regional tabletop emergency exercise with the City of Lake Oswego and the LO/T Water Treatment Plant.This exercise will not be completed until December 2021. OTHER ALTERNATIVES Do not approve the FY 2022 First Quarter Budget Supplemental. COUNCIL OR TCDA GOALS,POLICIES,MASTER PLANS DATES OF PREVIOUS CONSIDERATION This is the first time council has been presented with this information. Fiscal Impact Cost: $1,839,210 Budgeted(yes or no): No Where Budgeted(department/program):N/A Additional Fiscal Notes: The FY 2022 First Quarter Supplemental will increase the overall budget by$1.8M across 16 city funds. The increase in the expenditures is largely supported through unanticipated beginning fund balances as most requests are carryforwards with some support from various Federal and State grants,and contingency. This supplemental will not change reserves of the city. Please refer to Exhibits A and B which summarize the fiscal impact of the quarterly supplemental budget by fund. Attachments FY22 Q1 -Resolution FY22 Q1 Supplemental Summary FY22 Q1 Exhibit A_Revised FY22 Q1 Exhibit B Revised FY22 Q1 Exhibit C FY22 Q1 Supplemental Budget Presentation CITY OF TIGARD, OREGON TIGARD CITY COUNCIL RESOLUTION NO. 21- A RESOLUTION TO ADOPT THE FY 2022 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 2022 budget was adopted; and WHEREAS, the city recognizes approximately $1,839,210 of unanticipated budget in operations and transfers; and WHEREAS, the increase in budget is offset by unanticipated fund balance, miscellaneous revenue, reserve for future expenditures,and contingency. NOW,THEREFORE,BE IT RESOLVED by the Tigard City Council that: SECTION 1: The FY 2021-22 Budget is hereby amended as detailed in Exhibit B. SECTION: This resolution is effective immediately upon passage. PASSED: This day of 2021. Mayor-City of Tigard ATTEST: City Recorder-City of Tigard RESOLUTION NO. 21- Page 1 CITY OF TIGARD - BUDGET SUPPLEMENTAL 9/21/2021 FY 2021-2022 Quarter: 1 Item# Department Fund Division Request Title Request Funding Total Amount Detailed Description Source Q1CD01 Community 100-General Fund 3700-Economic Development Launch Pod-Mobile Business NEW Multiple $ 107,000 Economic Development has secured$70,000 from Washington County and$12,000 from AARP grant for the Launch Pod business Development Incubator incubator.Total project request will be$107,000 and of the total,$25,000 will be the city's contribution. The city's contribution will be drawn from ARPA allocation,which the city council approved on August 10,2021. The requested funding will outfit two mobile business incubators.The Launch Pod is a mobile business incubator that creates a low-barrier-to-entry starting point from which food&beverage entrepreneurs can launch a business in Tigard.Entrepreneurs for this business incubator will be recruited from the city's network of business-advising partners focused on serving business owners from historically under-served and marginalized populations. Q1CD02 Community 100-General Fund 3700-Economic Development Carryforward of prior year's business CARRYFORWA Unanticipated $ 42,600 This request is to carryforward various economic development related projects that were unable to finish in FY21,thus requesting to Development support programs RD Fund Balance carryforward to FY22. These programs were not completed last fiscal year due to our entire economic development program shifted into COVID-19 business assistance.The immediate effort of securing and distributing about$4M in business support took precedent over other projects and consumed almost all of our economic development capacity last year to the exclusion of several programs. Following are the list of projects: -Business Advising Contract w/MESO-Continuation of business advising program for Tigard based businesses owners and entrepreneurs with Micro Enterprise Services of Oregon. -Business Advising Contract(Spanish Language w/Adelante Mujeres)-Continuation of business advising program for Spanish speaking business owners and entrepreneurs in Tigard with Adelante Mujeres. -Opportunity Café Start Up-Startup costs for Opportunity Café business incubator at Tigard Library. -Workforce Training Program w/IRCO-Continuation of workforce training scholarship program for Tigard residents employed in Tigard with a career pathway through their existing employer.Program coordinated with Immigrant and Refugee Community Organization. Q1CD03 Community 100-General Fund 3000-Community Development Washington Square Regional Center CARRYFORWA Unanticipated $ 13,133 Carryforward of unused Washington Square Reginal Center Update project funds from FY21 to FY22. The WSRC Project is an active Development Planning update project-Carryforward Metro RD Fund Balance project,with an anticipated completion date by end of year.Final invoices from the consultant are expected to follow a month or so after Match completion,with Metro reimbursement following a month or so after final consultant invoices from the consultant.Both of the carryforwards identified below come with strings attached from Metro.These funds can only be spent on specific types of expenses. -Metro Match for Direct Expenses:Carryforward$3,133. The original SOW anticipated certain expenses related to in-person meetings that did not occur because of COVID,and the project has been in the process of repurposing those dollars to support engagement in different ways. -Additional Metro Match due to COVID-19 response:Carryforward$10,000.The original SOW did not anticipate the additional$10K from Metro,and the project is just now getting around to tapping into it. Q1CD04 Community 100-General Fund 3000-Community Development Tigard MADE project-Phase II carry CARRYFORWA Unanticipated $ 42,825 Tigard MADE project-Phase II of contract with Johnson Economics,LLC. At the start of the Tigard MADE project our discussions with the Development Planning forward. RD Fund Balance consultant team resulted in our splitting the work into a Phase I and Phase II for best results.That decision was made back in February, which meant that all of the budgeted funds for phase II would not be able to be spent in FY21 but would need to carry forward to FY22. Q1CM01 City Management 600-Central Services 1000-City Manager's Office Novak Consulting Group Recruitment NEW Contingency $ 50,000 Professional recruiting firm to assist in selecting a new Finance Director and an additional Asst City Manager to oversee a variety of Fund for 2nd Asst.City Manager departments that focus on infrastructure and investment,assist major initiatives around climate change,homelessness,and parks and recreation.The work will be accomplished through the lens of recently adopted Community Promise to improve internal alignment that enhances our teamwork and our strategic capacity. The ACM salary differential will be flagged for future discussion. Q1CM02 City Management 600-Central Services 2000-Finance&Info.Services Management Partners Financial NEW Contingency $ 62,500 Conduct high-level organizational assessment of Finance and Information Services(FIS)functions,recommend internal service funds and Fund Admin. Services methodologies,provide financial management advice to finance staff,managers and elected Officials,support implementation of Tyler ERP system,provide advice on debt issuance and administration,and review city's latest long-range General Fund financial forecast. The budget requirements for this request will be partially offset by vacancy savings in FIS. 1 of 4 CITY OF TIGARD - BUDGET SUPPLEMENTAL 9/21/2021 FY 2021-2022 Quarter: 1 Item# Department Fund Division Request Title Request Funding Total Amount Detailed Description Source Q1FIS01 Finance& 600-Central Services 1200-Risk Management Technical Adjustment:Increase Risk TECHNICAL Contingency $ 19,300 This request was approved during FY21 Q3 Supplemental Budget hearing,but was omitted in the Adopted Budget as a technical Information Fund Analyst FTE from 0.80 FTE to 1.00 adjustment. Below is the description from FY21 Q3: Services FTE Increase the Risk Analyst,PCN 5305,from a 0.80 FTE to a 1.00 FTE. In order to ensure OSHA compliance,a number of programs needed to be established and/or updated. This includes ongoing maintenance including annual testing,training,auditing and data reporting, which has translated to an increasing workload for the Risk Analyst position. Some of these program are MSDS,Hearing Conservation, Respirator,Silica Exposure,Return to work WC program,Safety Committee oversight,and misc.projects. In addition,the Risk Analyst position would spend more time learning about complex daims processing,to provide back-up to the Risk Manager;this will ensure greater resiliency in the city's ability to mitigate risks and respond when serious,hazardous situations occur. The cost for this fiscal year(effective date April 16,2021)is roughly$6,000 and will be offset by savings from professional and consulting services. Q1FIS02 Finance& 600-Central Services MULTIPLE Tyler Project Implementation Fund CARRYFORWA Unanticipated $ 284,000 At the time of FY21 Budgeting,a lot of the Tyler project funding was estimated based on the project timeline at that time. This resulted in Information Fund Carryforward RD Fund Balance some unused Tyler project implementation funds due to timing such as Software as a Service(SaaS)fees,travel expenses, Services implementation fees,data conversion category dollars,and Limited Duration FTEs for GIS and HR/CM office dedicated to the Tylper implementation.The carryforward funds will be used for the exact same purpose at the same amount,the only thing that has changed is the timing of when the funds are needed(FY22 vs FY21)within the project. Q1FIS03 Finance& 600-Central Services 2300-Information Technology Teams Conference Room Equipment CARRYFORWA Unanticipated $ 31,000 Budgeted funds in FY21 but the equipment did not arrive until July 2021. AV Equipment to equip all city meeting rooms with MS Teams Information Fund Carryforward RD Fund Balance hybrid conference capabilities. S-rvires Q1FISO4 Finance& 600-Central Services 2300-Information Technology Verizon Connect-Fleet Management NEW Contingency $ 42,000 Fleet management system for all city vehicles. The system will help automate manual processes like preventative maintenance,vehicle Information Fund System error codes,Tyler integration,fleet usage,safety,risk management,carbon footprint reporting,data informed fleet management Services decisions.This request will be an ongoing annual cost for all city vehicles with Verizon Connect. The IT and facilities teams have been exploring fleet management solutions for many years across multiple proof of concept projects. During FT21 the Verizon connect product was chosen for a larger 60 unit POC on the police feet that did not complete until after the budgeting process was closed for FY21.The results from the advanced mapping and telemetry data that is captured in the Verizon Connect system will be used to support the Data Informed Policing levy initiative and could be used for many other citywide projects and risk reductions.This success combined with the inherent fleet management system capabilities+Tyler EAM implementation would greatly benefit every vehicle and driver at Tigard.Unfortunately,the timing did not align with the FY22 budgeting process and has come out in a Q1 supplemental request. Q1PD01 Police 100-General Fund 4100-Police Operations Patrol Vehicle Replacement NEW Contingency $ 36,000 In July,an officer discovered that patrol vehicle#19-858 was damaged on the passenger side of the front door where the vehicle molding was displaced.The corresponding damage that caused the displaced molding was very low on the vehicle and not noticeable during daily inspections.The PD completed a due diligence investigation to determine causal factors,however no operator knew of an incident where the damage occurred.Other inspection processes also revealed no further information about a date,time or location for this significant damage.Fleet determined that the damage was severe enough that the vehicle would need to be removed from service and replaced. A new patrol vehicle has been quoted as$36,000—as this is outside of the planned purchases for the year,this additional purchase has not been budgeted.The City has received an insurance payment of$13,000 from our carrier CIS;additionally,at auction,the vehicle is likely to generate proceeds between$5,000 and$15,000.The PD requests$36,000 in appropriation from General Fund contingency,with the understanding that the GF will be reimbursed by new revenues between$18,000 and$28,000.We will coordinate the funding with Finance and Risk. Q1PD02 Police MULTIPLE 4100-Police Operations Ammo purchase-carryforward CARRYFORWA Unanticipated $ 11,200 In September 2020,the Police Department placed orders with several vendors for our annual ammunition purchase.All of these orders RD Fund Balance have been received,with the exception of 20k rounds of 223 duty ammo.The vendor has indicated that this type of ammunition is on back order. We should have more accurate delivery timeline in the next 6 to 12 months.Of the total,$1,231 is Levy funded and$9,969 is from the General Fund. Q1PD03 Police 240-Criminal 4050-Forfeiture-Local Traffic Mod furniture-carryforward CARRYFORWA Unanticipated $ 24,275 In May,PD ordered new office furniture for six(1)Traffic Unit employees to replace desks and cubicle walls.The existing furniture had Forfeiture Fund RD Fund Balance been reallocated from another PD unit several years ago.The desks and panels were more than 15 years old,were degrading,and past their useful lives.Employees now all have sit-stand desks for ergonomic purposes and panels help to block sound when officers are attending virtual court or other meetings.Additionally,the office was reconfigured to more efficiently utilize the existing mod space and accommodate the additional of the Evening Traffic Safety Officer recently assigned to the unit.The furnishings are all movable and can easily be relocated if needed.Due to current supply chain constraints,the shipment arrived in early July,just after the new fiscal year start.The funds had been allocated in FY21 within the Asset Forfeiture Fund,and we request to carryforward into FY22. 2 of 4 CITY OF TIGARD - BUDGET SUPPLEMENTAL 9/21/2021 FY 2021-2022 Quarter: 1 Item# Department Fund Division Request Title Request Funding Total Amount Detailed Description Source Q1PD04 Police 280-Police Levy Fund MULTIPLE One-time Levy start-up costs CARRYFORWA Unanticipated $ 12,205 Several levy start-up allocation items were ordered in FY21,but not received or completed by the fiscal year end due to the ongoing RD Fund Balance COVID-19 related supply chain issues.As a result,we request to carryforward into FY22.These items include the parts and labor associated with outfitting the two levy-funded patrol vehicles($8,205).The vehicles were received,but were not outfitted with lights, cages,radios until July 2021.Additionally,computer equipment related to the hiring of new non-sworn levy funded positions was ordered but has not yet been received.These final two vehicles did not complete outfittings until July 2021. The funds for these'one time' purchases had been allocated in FY21 within the Levy Fund and need to be carried forward to FY22. Q1PD05 Police 100-General Fund 4200-Support Services Parking lot security CARRYFORWA Unanticipated $ 159,700 During the FY21 Q1,Council approved a$170,000 appropriation increase for the Police Department's parking lot security needs.Due to RD Fund Balance the evolving nature of the City's conversations with Ziply and the adjacent property,the original security plan could not be implemented as initially developed.In order to provide some security in the meantime,a fence was placed behind the far corner of Town Hall building and behind the two"mods",effectively closing off access to the PD from the Fanno Creek trails.Additionally,privacy slats were added to the existing parking lot fencing.The cost of this work was$10.3K and was completed before June 30,2021.The PD is working collaboratively with Facilities to develop alternative security plan scenarios depending upon the City's ability to utilize the adjacent property. The PD is requesting to carryforward the remaining$159.7K balance in order to have secured funding available once a security plan has been finalized. Q1PW01 Public Works MULTIPLE MULTIPLE Carryforward for Vehicles CARRYFORWA Unanticipated $ 190,000 The COVID-19 pandemic has caused significant delays on goods and materials up and down the supply chain. The auto industry has been RD Fund Balance one of the hardest hit,especially with issues in getting a steady supply of computer chips,and the delivery of new vehicles is falling quarters behind not just weeks or a month or two. The Public Works department ordered for vehicles in FY21 that will now not be delivered until FY22(at best)and will need the encumbered funds from last fiscal year carried forward. The vehicles are as follows(all were purchased through an existing state contract with Landmark Ford): • A Ford F-150 Supercab w/an 8'box for PW Engineering that replaces vehicle#06-030. Carryforward amount is$35,000(Fund 640). PO#210108 issued on March 2,2021. • A Ford 350 4x2 PTC Flatbed for PW Streets Maintenance that replaces vehicle#04-002. Carryforward amount is$61,000(Fund 200). PO#210100 issued on February 19,2021. • A Ford F-250 4x4 Supercab w/an 8'box for the Water division that replaced vehicle#04-055. Carryforward amount is$31,000(Fund 530). PO#210101 issued on February 22,2021. • A Ford F-350 4x4 Supercab DRW PTC Service Body for the Water division that replaces#03-091. Carryforward amount is$63,000 (Fund 530). PO#210087 issued on January 25,2021. Q1PW02 Public Works 530-Water Fund 6500-Water Carryforward for 119th Automatic CARRYFORWA Unanticipated $ 15,400 This project was to install a turn-key replacement automatic transfer switch in the generator building at the reservoir#2. The COVID-19 Transfer Switch RD Fund Balance pandemic has caused significant delays on goods and materials up and down the supply chain. The city experienced this delay with a needed replacement of the automatic transfer switch(ATS)at Reservoir#2 at 119th Place. The Public Works department issued PO #P210128(issued on April 28th)for the work with an original understanding that it would all be completed within a few weeks. Issues with getting the actual part delivered however delayed the work by over two months and into a new fiscal year. As such,the encumbered funds from last fiscal year need to be carried forward into FY22. Q1PW12 PW Engineering 640-Public Works 6250-PW Engineering Engineering Design and Construction CARRYFORWA Unanticipated $ 70,000 Carryforward$70,000 of prior year appropriations encumbered to Contract#C200098. Internal constraints including COVID-19 related Engineering Fund Standards RD Fund Balance issues,reprioritization of projects,and teammate turnover,have delayed completion of the contract. Q1PW03 Capital 532-Water CIP Fund 8000-CIP/Contingency CIP 96055 Risk and Resilience CARRYFORWA Unanticipated $ 36,000 Carryforward$36,000 from prior year appropriations impacting the Water Fund(530). The City of Tigard will participate in a regional Improvement Assessment and Emergency RD Fund Balance tabletop emergency exercise with the City of Lake Oswego and the L0/T Water Treatment Plant.This exercise will not be completed until Program Response Plan December 2021. Q1PW04 Capital MULTIPLE MULTIPLE CIP 92059 Universal Plaza CARRYFORWA Unanticipated $ 86,000 Carryforward$86,000 from prior year appropriations impacting Parks SDC Fund(425)and$52,000 from Urban Renewal Capital Improvement RD Fund Balance Improvement Fund(940). Construction did not start as scheduled;estimated cost requires the dollars remain available. Prnaram Q1PW05 Capital MULTIPLE MULTIPLE CIP 91023 Public Works Field Staff CARRYFORWA Unanticipated $ 25,000 Carryforward$7,500 from prior year appropriations impacting Parks Utility Fund(270),$3,300 from Sanitary Sewer Fund(500),$5,700 Improvement Work Area and Breakroom RD Fund Balance from Stormwater Fund(510)and$8,500 from the Water Fund(530). Delay in contract award,largely due to teammates dedicated to Program needs and supply chain issues,has pushed entire project into FY 2022. Q1PW06 Capital MULTIPLE MULTIPLE CIP 92016-08 Dirksen Nature Park- CARRYFORWA Unanticipated $ 46,000 Carryforward$46,000 from prior year appropriations impacting Parks SDC Fund(425). Permitting through CWS has taken longer than Improvement Off-Street Parking Lot RD Fund Balance expected,causing delay in the project. Prnaram Q1PW07 Capital MULTIPLE MULTIPLE CIP 92016-13 Dirksen Nature Park- CARRYFORWA Unanticipated $ 64,500 Carryforward$64,500 from prior year appropriations impacting Parks SDC Fund(425). Moved construction out one year to build the off- Improvement Wetland Boardwalk and Walkway RD Fund Balance street parking lot and boardwalk as one project.Also,permitting through CWS has taken longer than expected,causing delay in the Program project. Q1PW08 Capital 510-Stormwater Fund 8000-CIP/Contingency CIP 94048 Oak Street Property CARRYFORWA Unanticipated $ 28,000 Carryforward$28,000 from prior year appropriations impacting the Stormwater Fund(510). Additional permitting required due to the Improvement Acquisition RD Fund Balance proximity of steep slopes.Hazardous material(Asbestos and lead)have been found in the house which requires a Plans and Hazardous Program Building Material Survey to assist with proper removal of hazardous building materials. 3 of 4 CITY OF TIGARD - BUDGET SUPPLEMENTAL 9/21/2021 FY 2021-2022 Quarter: 1 Item# Department Fund Division Request Title Request Funding Total Amount Detailed Description Source Q1PW09 Capital MULTIPLE MULTIPLE CIP 92056 Park System Master Plan CARRYFORWA Unanticipated $ 26,500 Carryforward$26,500 from prior year appropriations impacting Parks SDC Fund(425). The Parks Master Plan is in the final stages.Late Improvement Update RD Fund Balance stage edits will be incorporated in the report,which will be presented to council for adoption in late Fall 2021.Due to additional work, Program which was added to the project last year,the project completion date is extended. As such,this request will carryforward FY21's project appropriations to FY22. No new appropriations are being requested. Q1PW10 Capital MULTIPLE MULTIPLE CIP 95063 Transportation System CARRYFORWA Unanticipated $ 51,500 Carryforward$51,500 from prior year appropriations impacting Transportation SDC Fund(415). The project has been delayed due to Improvement Plan Update RD Fund Balance consultant team changes and COVID-19 related issues.An increase in contract scope to include additional active transportation network Program planning and legislative adoption tasks have also increased the project time-frame.The total project amount remains the same as the adopted CIP budget. Q1PW11 Capital MULTIPLE MULTIPLE CIP 95065 Pacific Highway Street CARRYFORWA Unanticipated $ 226,160 Carryforward$9,000 from prior year appropriations impacting Gas Tax(200)and$217,160 from State Fund Local Project Grant. IGA with Improvement Lights RD Fund Balance ODOT is being adjusted to remove two intersections that were included in this project and another project that is being managed by Program ODOT.A third intersection,at Bull Mountain Road,has been added to the City of Tigard Project. This discrepancy led to the project being delayed. Total project cost remains the same as the adopted CIP budget. 4of4 Exhibit A Q1CD01 -Launch Pod-Mobile Business Incubator Economic Development has secured$70,000 from Washington County and$12,000 from AARP grant for the Launch Pod business incubator.Total project request will be$107,000 and of the total,$25,000 will be the city's contribution. The city's contribution will be drawn from ARPA allocation,which the city council approved on August 10, 2021. The requested funding will outfit two mobile business incubators.The Launch Pod is a mobile business incubator that creates a low-barrier-to-entry starting point from which food& beverage entrepreneurs can launch a business in Tigard. Entrepreneurs for this business incubator will be recruited from the city's network of business-advising partners focused on serving business owners from historically under-served and marginalized populations. FY 2022 Qi Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 29,041,365 $ - $ 29,041,365 Property Taxes $ 18,452,556 $ - $ 18,452,556 Franchise Fees $ 6,701,356 $ - $ 6,701,356 Special Assessments $ - $ - $ - Licenses &Permits $ 1,132,119 $ - $ 1,132,119 Intergovernmental $ 7,316,572 $ 82,000 $ 7,398,572 Charges for Services $ 242,743 $ - $ 242,743 Fines&Forfeitures $ 2,128,301 $ - $ 2,128,301 Interest Earnings $ 300,675 $ - $ 300,675 Miscellaneous $ 356,432 $ - $ 356,432 Other Financing Sources $ - $ - $ Transfers In from Other Funds $ 244,000 S - $ 244,000 Total Resources $ 65,916,119 $ 82,000 $ 65,998,119 Requirements Community Development $ 4,410,334 $ 107,000 S 4,517,334 Community Services $ 27,417,691 $ - $ 27,417,691 Policy and Administration $ 1,676,325 $ - $ 1,676,325 Public Works $ - $ - $ Program Expenditures Total $ 33,504,350 $ 107,000 $ 33,611,350 Debt Service $ - $ - $ Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ - $ - $ Transfers to Other Funds $ 2,773,714 $ - $ 2,773,714 Contingency $ 1,600,000 000 > $ (25,000) $ 1,575,000 Total Budget $ 37,879,064 $ 82,000 $ 37,961,064 Reserve For Future Expenditure $ 28,037,055 $ - $ 28,037,055 Total Requirements $ 65,916,119 $ 82,000 $ 65,998,119 Exhibit A Q1CD02-Carryforward of prior year's business support programs This request is to carryforward various economic development related projects that were unable to finish in FY21,thus requesting to carryforward to FY22. These programs were not completed last fiscal year due to our entire economic development program shifted into COVID-19 business assistance.The immediate effort of securing and distributing about$4M in business support took precedent over other projects and consumed almost all of our economic development capacity last year to the exclusion of several programs. Following are the list of projects: -Business Advising Contract w/MESO-Continuation of business advising program for Tigard based businesses owners and entrepreneurs with Micro Enterprise Services of Oregon. -Business Advising Contract(Spanish Language w/Adelante Mujeres)-Continuation of business advising program for Spanish speaking business owners and entrepreneurs in Tigard with Adelante Mujeres. -Opportunity Café Start Up-Startup costs for Opportunity Café business incubator at Tigard Library. -Workforce Training Program w/IRCO-Continuation of workforce training scholarship program for Tigard residents employed in Tigard with a career pathway through their existing employer. Program coordinated with Immigrant and Refugee Community Organization. FY 2022 Q1 Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 29,041,365 $ 42,600 $ 29,083,965 Property Taxes $ 18,452,556 $ - S 18,452,556 Franchise Fees $ 6,701,356 $ - $ 6,701,356 Special Assessments $ - $ - $ - Licenses&Permits $ 1,132,119 $ - $ 1,132,119 Intergovernmental $ 7,316,572 $ - S 7,316,572 Charges for Services $ 242,743 $ - $ 242,743 Fines&Forfeitures $ 2,128,301 $ - S 2,128,301 Interest Earnings $ 300,675 $ - $ 300,675 Miscellaneous $ 356,432 $ - S 356,432 Other Financing Sources $ - $ - $ Transfers In from Other Funds $ 244,000 S - S 244,000 Total Resources $ 65,916,119 $ 42,600 $ 65,958,719 Requirements Community Development $ 4,410,334 $ 42,600 $ 4,452,934 Community Services S 27,417,691 $ - $ 27,417,691 Policy and Administration $ 1,676,325 $ - $ 1,676,325 Public Works $ - $ - $ Program Expenditures Total $ 33,504,350 $ 42,600 $ 33,546,950 Debt Service $ - $ - $ Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ - $ - $ Transfers to Other Funds $ 2,773,714 $ - $ 2,773,714 Contingency $ 1,600,000 $ - $ 1,600,000 Total Budget $ 37,879,064 $ 42,600 $ 37,921,664 Reserve For Future Expenditure $ 28,037,055 $ - $ 28,037,055 Total Requirements $ 65,916,119 $ 42,600 $ 65,958,719 Exhibit A Q1CD03 -Washington Square Regional Center update project- Carryforward Metro Match Carryforward of unused Washington Square Reginal Center Update project funds from FY21 to FY22. The WSRC Project is an active project,with an anticipated completion date by end of year. Final invoices from the consultant are expected to follow a month or so after completion, with Metro reimbursement following a month or so after final consultant invoices from the consultant. Both of the carryforwards identified below come with strings attached from Metro.These funds can only be spent on specific types of expenses. -Metro Match for Direct Expenses: Carryforward $3,133. The original SOW anticipated certain expenses related to in-person meetings that did not occur because of COVID,and the project has been in the process of repurposing those dollars to support engagement in different ways. -Additional Metro Match due to COVID-19 response: Carryforward $10,000.The original SOW did not anticipate the additional $10K from Metro, and the project is just now getting around to tapping into it. FY 2022 Q1 Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 29,041,365 $ 13,133 $ 29,054,498 Property Taxes $ 18,452,556 $ - $ 18,452,556 Franchise Fees $ 6,701,356 $ - $ 6,701,356 Special Assessments $ - $ - $ Licenses &Permits $ 1,132,119 $ - $ 1,132,119 Intergovernmental $ 7,316,572 316,572 $ - $ 7,316,572 Charges for Services $ 242,743 $ - $ 242,743 Fines& Forfeitures $ 2,128,301 $ - $ 2,128,301 Interest Earnings $ 300,675 $ - $ 300,675 Miscellaneous $ 356,432 $ - $ 356,432 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 244,000 $ - $ 244,000 Total Resources $ 65,916,119 $ 13,133 $ 65,929,252 Requirements Community Development $ 4,410,334 $ 13,133 $ 4,423,467 Community Services $ 27,417,691 $ - $ 27,417,691 Policy and Administration $ 1,676,325 $ - $ 1,676,325 Public Works $ - $ - $ Program Expenditures Total $ 33,504,350 $ 13,133 $ 33,517,483 Debt Service $ - $ - $ Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ - $ - $ Transfers to Other Funds $ 2,773,714 $ - $ 2,773,714 Contingency $ 1,600,000 $ - $ 1,600,000 Total Budget $ 37,879,064 $ 13,133 $ 37,892,197 Reserve For Future Expenditure $ 28,037,055 $ - $ 28,037,055 Total Requirements $ 65,916,119 $ 13,133 $ 65,929,252 Exhibit A Q1CD04 -Tigard MADE project-Phase II carry forward. Tigard MADE project- Phase II of contract with Johnson Economics, LLC. At the start of the Tigard MADE project our discussions with the consultant team resulted in our splitting the work into a Phase I and Phase II for best results.That decision was made back in February,which meant that all of the budgeted funds for phase II would not be able to be spent in FY21 but would need to carry forward to FY22. FY 2022 Q1 Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 29,041,365 $ 42,825 $ 29,084,190 Property Taxes $ 18,452,556 $ - $ 18,452,556 Franchise Fees $ 6,701,356 $ - $ 6,701,356 Special Assessments $ - $ - $ Licenses &Permits $ 1,132,119 $ - $ 1,132,119 Intergovernmental $ 7,316,572 316,572 $ - $ 7,316,572 Charges for Services $ 242,743 $ - $ 242,743 Fines &Forfeitures $ 2,128,301 $ - $ 2,128,301 Interest Earnings $ 300,675 $ - $ 300,675 Miscellaneous $ 356,432 $ - $ 356,432 Other Financing Sources $ - $ - $ Transfers In from Other Funds $ 244,000 $ - $ 244,000 Total Resources $ 65,916,119 $ 42,825 $ 65,958,944 Requirements Community Development $ 4,410,334 $ 42,825 $ 4,453,159 Community Services $ 27,417,691 $ - $ 27,417,691 Policy and Administration $ 1,676,325 $ - $ 1,676,325 Public Works $ - $ - $ Program Expenditures Total $ 33,504,350 $ 42,825 $ 33,547,175 Debt Service $ - $ - $ Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ - $ - $ Transfers to Other Funds $ 2,773,714 $ - $ 2,773,714 Contingency $ 1,600,000 $ - $ 1,600,000 Total Budget $ 37,879,064 $ 42,825 $ 37,921,889 Reserve For Future Expenditure $ 28,037,055 $ - $ 28,037,055 Total Requirements $ 65,916,119 $ 42,825 $ 65,958,944 Exhibit A Q1CM01 -Novak Consulting Group Recruitment for 2nd Asst. City Manager Professional recruiting firm to assist in selecting a new Finance Director and an additional Asst City Manager to oversee a variety of departments that focus on infrastructure and investment,assist major initiatives around climate change, homelessness,and parks and recreation.The work will be accomplished through the lens of recently adopted Community Promise to improve internal alignment that enhances our teamwork and our strategic capacity. The ACM salary differential will be flagged for future discussion. FY 2022 Q1 Revised Central Services Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 2,821,865 $ - $ 2,821,865 Property Taxes $ - $ - $ Franchise Fees $ - $ - $ Special Assessments $ - $ - $ - Licenses&Permits $ - $ - $ Intergovernmental $ - $ - $ - Charges for Services $ 12,428,617 $ - $ 12,428,617 Fines&Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ 90,000 $ - $ 90,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 1,025,710 S - S 1,025,710 Total Resources $ 16,366,192 $ - $ 16,366,192 Requirements Community Development $ - $ - S - Community Services $ - $ - S - Policy and Administration $ 14,537,452 $ 50,000 5 14,587,452 Public Works $ - S - S - Program Expenditures Total $ 14,537,452 $ 50,000 $ 14,587,452 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ Work-In-Progress $ - $ - $ - Transfers to Other Funds $ - $ - $ - Contingency S 500,000 $ (50,000) $ 450,000 Total Budget $ 15,037,452 $ - $ 15,037,452 Reserve For Future Expenditure $ 1,328,740 $ - $ 1,328,740 Total Requirements $ 16,366,192 $ - $ 16,366,192 Exhibit A Q1CM02 -Management Partners Financial Services Conduct high-level organizational assessment of Finance and Information Services(FIS)functions, recommend internal service funds and methodologies, provide financial management advice to finance staff, managers and elected Officials,support implementation of Tyler ERP system, provide advice on debt issuance and administration,and review city's latest long-range General Fund financial forecast. The budget requirements for this request will be partially offset by vacancy savings in FIS. FY 2022 Q1 Revised Central Services Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 2,821,865 $ - $ 2,821,865 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ 12,428,617 $ - $ 12,428,617 Fines&Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ 90,000 $ - $ 90,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 1,025,710 $ - $ 1,025,710 Total Resources $ 16,366,192 $ - $ 16,366,192 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ 14,537,452 $ 62,500 $ 14,599,952 Public Works $ - $ - $ - Program Expenditures Total $ 14,537,452 $ 62,500 $ 14,599,952 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ - $ - $ - Contingency $ 500,000 $ (62,500) $ 437,500 Total Budget $ 15,037,452 $ - $ 15,037,452 Reserve For Future Expenditure $ 1,328,740 $ - $ 1,328,740 Total Requirements $ 16,366,192 $ - $ 16,366,192 Exhibit A Q1FIS01-Technical Adjustment: Increase Risk Analyst FTE from 0.80 FTE to 1.00 FTE This request was approved during FY21 Q3 Supplemental Budget hearing, but was omitted in the Adopted Budget as a technical adjustment. Below is the description from FY21 Q3: Increase the Risk Analyst, PCN 5305,from a 0.80 FTE to a 1.00 FTE. In order to ensure OSHA compliance,a number of programs needed to be established and/or updated. This includes ongoing maintenance including annual testing,training, auditing and data reporting, which has translated to an increasing workload for the Risk Analyst position. Some of these program are MSDS, Hearing Conservation, Respirator,Silica Exposure, Return to work WC program,Safety Committee oversight,and misc. projects. In addition,the Risk Analyst position would spend more time learning about complex claims processing,to provide back-up to the Risk Manager;this will ensure greater resiliency in the city's ability to mitigate risks and respond when serious, hazardous situations occur. The cost for this fiscal year(effective date April 16, 2021) is roughly$6,000 and will be offset by savings from professional and consulting services. FY 2022 Q1 Revised Central Services Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 2,821,865 $ - $ 2,821,865 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ - $ - S Intergovernmental $ - $ - $ Charges for Services $ 12,428,617 $ - $ 12,428,617 Fines&Forfeitures $ - $ - $ - Interest Earnings $ - S - $ Miscellaneous $ 90,000 $ - $ 90,000 Other Financing Sources $ - S - S - Transfers In from Other Funds $ 1,025,710 $ - $ 1,025,710 Total Resources $ 16,366,192 $ - $ 16,366,192 Requirements Community Development $ - $ - $ - Community Services $ - S - $ - Policy and Administration $ 14,537,452 $ 19,300 $ 14,556,752 Public Works $ - S - $ Program Expenditures Total $ 14,537,452 $ 19,300 $ 14,556,752 Debt Service S - $ - $ Loan to TCDA S - $ - $ Work-In-Progress S - $ - $ Transfers to Other Funds S - S - $ - Contingency S 500,000 $ (19,300) $ 480,700 Total Budget $ 15,037,452 $ - $ 15,037,452 Reserve For Future Expenditure $ 1,328,740 $ - $ 1,328,740 Total Requirements $ 16,366,192 $ - $ 16,366,192 Exhibit A Q1FIS02-Tyler Project Implementation Fund Carryforward At the time of FY21 Budgeting, a lot of the Tyler project funding was estimated based on the project timeline at that time. This resulted in some unused Tyler project implementation funds due to timing such as Software as a Service (SaaS)fees,travel expenses, implementation fees, data conversion category dollars, and LD FTEs for GIS and HR/CM office dedicated to the Tylper implementation. The carryforward funds will be used for the exact same purpose at the same amount,the only thing that has changed is the timing of when the funds are needed (FY22 vs FY21)within the project. FY 2022 Q1 Revised Central Services Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 2,821,865 $ 284,000 $ 3,105,865 Property Taxes $ - $ - $ Franchise Fees $ - $ - 8 Special Assessments $ - $ - S Licenses &Permits $ - $ - $ Intergovernmental $ - $ - $ Charges for Services $ 12,428,617 $ - $ 12,428,617 Fines & Forfeitures $ - $ - $ Interest Earnings $ - $ - $ Miscellaneous $ 90,000 $ - S 90,000 Other Financing Sources $ - $ - S Transfers In from Other Funds $ 1,025,710 $ - $ 1,025,710 Total Resources $ 16,366,192 $ 284,000 $ 16,650,192 Requirements Community Development S - $ - $ Community Services $ - $ - $ Policy and Administration $ 14,537,452 $ 284,000 $ 14,821,452 Public Works S - $ - $ Program Expenditures Total $ 14,537,452 $ 284,000 $ 14,821,452 Debt Service $ - $ - $ Loan to TCDA $ - $ - S Work-In-Progress $ - $ - Transfers to Other Funds $ - $ - S Contingency $ 500,000 $ - S 500,000 Total Budget $ 15,037,452 $ 284,000 $ 15,321,452 Reserve For Future Expenditure $ 1,328,740 $ - $ 1,328,740 Total Requirements $ 16,366,192 $ 284,000 $ 16,650,192 Exhibit A Q1FIS03-Teams Conference Room Equipment Carryforward Budgeted funds in FY21 but the equipment did not arrive until July 2021. AV Equipment to equip all city meeting rooms with MS Teams hybrid conference capabilities. FY 2022 Q1 Revised Central Services Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 2,821,865 $ 31,000 $ 2,852,865 Property Taxes $ - S - $ Franchise Fees $ - $ - $ Special Assessments $ - $ - $ Licenses&Permits $ - $ - $ Intergovernmental $ - $ - $ Charges for Services $ 12,428,617 $ - $ 12,428,617 Fines& Forfeitures $ - $ - $ Interest Earnings $ - $ - $ Miscellaneous $ 90,000 $ - $ 90,000 Other Financing Sources $ - $ - $ Transfers In from Other Funds S 1,025,710 $ - S 1,025,710 Total Resources $ 16,366,192 $ 31,000 $ 16,397,192 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ Policy and Administration $ 14,537,452 $ 31,000 $ 14,568,452 Public Works $ - $ - S Program Expenditures Total $ 14,537,452 $ 31,000 $ 14,568,452 Debt Service $ - $ - $ Loan to TCDA $ - $ - $ Work-In-Progress $ - $ - $ - Transfers to Other Funds $ - $ - $ Contingency $ 500,000 $ - $ 500,000 Total Budget $ 15,037,452 $ 31,000 $ 15,068,452 Reserve For Future Expenditure $ 1,328,740 $ - $ 1,328,740 Total Requirements $ 16,366,192 $ 31,000 $ 16,397,192 Exhibit A Q1FISO4-Verizon Connect-Fleet Management System Fleet management system for all city vehicles. The system will help automate manual processes like preventative maintenance,vehicle error codes,Tyler integration,fleet usage,safety,risk management,carbon footprint reporting,data informed fleet management decisions.This request will be an ongoing annual cost for all city vehicles with Verizon Connect. The IT and facilities teams have been exploring fleet management solutions for many years across multiple proof of concept projects. During FT21 the Verizon connect product was chosen for a larger 60 unit POC on the police feet that did not complete until after the budgeting process was closed for FY21.The results from the advanced mapping and telemetry data that is captured in the Verizon Connect system will be used to support the Data Informed Policing levy initiative and could be used for many other citywide projects and risk reductions.This success combined with the inherent fleet management system capabilities+Tyler EAM implementation would greatly benefit every vehicle and driver at Tigard. Unfortunately,the timing did not align with the FY22 budgeting process and has come out in a 01 supplemental request. FY 2022 Q1 Revised Central Services Fund Adopted Amendment Qi Resources Beginning Fund Balance $ 2,821,865 $ - $ 2,821,865 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ - $ - $ - Intergovernmental $ - $ - $ - $ 12,428,617 $ - $ 12,428,617 Fines&Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ 90,000 $ - $ 90,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 1,025,710 $ - $ 1,025,710 Total Resources $ 16,366,192 $ - $ 16,366,192 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ 14,537,452 $ 42,000 $ 14,579,452 Public Works $ - $ - $ - Program Expenditures Total $ 14,537,452 $ 42,000 $ 14,579,452 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ - $ - $ - Contingency $ 500,000 $ (42,000) $ 458,000 Total Budget $ 15,037,452 $ - $ 15,037,452 Reserve For Future Expenditure $ 1,328,740 $ - $ 1,328,740 Total Requirements $ 16,366,192 $ - $ 16,366,192 Exhibit A Q1PD01-Patrol Vehicle Replacement In July,an officer discovered that patrol vehicle#19-858 was damaged on the passenger side of the front door where the vehicle molding was displaced.The corresponding damage that caused the displaced molding was very low on the vehicle and not noticeable during daily inspections.The PD completed a due diligence investigation to determine causal factors, however no operator knew of an incident where the damage occurred.Other inspection processes also revealed no further information about a date,time or location for this significant damage. Fleet determined that the damage was severe enough that the vehicle would need to be removed from service and replaced. A new patrol vehicle has been quoted as$36,000—as this is outside of the planned purchases for the year,this additional purchase has not been budgeted. The City has received an insurance payment of$13,000 from our carrier CIS;additionally,at auction,the vehicle is likely to generate proceeds between $5,000 and$15,000.The PD requests$36,000 in appropriation from General Fund contingency,with the understanding that the GF will be reimbursed by new revenues between$18,000 and$28,000.We will coordinate the funding with Finance and Risk. FY 2022 Q1 Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 29,041,365 $ - $ 29,041,365 Property Taxes $ 18,452,556 $ - $ 18,452,556 Franchise Fees $ 6,701,356 $ - S 6,701,356 - Special Assessments $ - $ $ Licenses&Permits $ 1,132,119 $ - $ 1,132,119 Intergovernmental $ 7,316,572 $ - $ 7,316,572 Charges for Services $ 242,743 $ - $ 242,743 Fines&Forfeitures $ 2,128,301 $ - $ 2,128,301 Interest Earnings $ 300,675 $ - $ 300,675 Miscellaneous $ 356,432 $ 12,712 S 369,144 Other Financing Sources $ - $ - S Transfers In from Other Funds $ 244,000 $ - $ 244,000 Total Resources $ 65,916,119 $ 12,712 $ 65,928,831 Requirements Community Development $ 4,410,334 $ - $ 4,410,334 Community Services $ 27,417,691 $ 36,000 $ 27,453,691 Policy and Administration $ 1,676,325 $ - S 1,676,325 Public Works $ - S $ Program Expenditures Total $ 33,504,350 $ 36,000 $ 33,540,350 Debt Service $ - $ - $ Loan to TCDA $ 1,000 $ - $ 1,000 - Work-In-Progress $ - $ - $ Transfers to Other Funds $ 2,773,714 $ - 5 2,773,714 Contingency $ 1,600,000 $ (23,288) $ 1,576,712 Total Budget $ 37,879,064 $ 12,712 $ 37,891,776 Reserve For Future Expenditure $ 28,037,055 $ - $ 28,037,055 Total Requirements $ 65,916,119 $ 12,712 $ 65,928,831 Exhibit A Q1PD02 -Ammo purchase - carryforward In September 2020,the Police Department placed orders with several vendors for our annual ammunition purchase. All of these orders have been received, with the exception of 20k rounds of 223 duty ammo.The vendor has indicated that this type of ammunition is on back order. We should have more accurate delivery timeline in the next 6 to 12 months. Of the total, $1,231 is Levy funded and $9,969 is from the General Fund. Fund 1 of 2 FY 2022 Q1 Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 29,041,365 $ 9,969 $ 29,051,334 Property Taxes $ 18,452,556 $ - $ 18,452,556 Franchise Fees $ 6,701,356 $ - $ 6,701,356 Special Assessments $ - $ - $ - Licenses & Permits $ 1,132,119 $ - $ 1,132,119 Intergovernmental $ 7,316,572 $ - $ 7,316,572 Charges for Services $ 242,743 $ - $ 242,743 Fines & Forfeitures $ 2,128,301 $ - $ 2,128,301 Interest Earnings $ 300,675 $ - $ 300,675 Miscellaneous $ 356,432 $ - $ 356,432 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 244,000 $ - $ 244,000 Total Resources $ 65,916,119 $ 9,969 $ 65,926,088 Requirements Community Development $ 4,410,334 $ - $ 4,410,334 Community Services $ 27,417,691 $ 9,969 $ 27,427,660 Policy and Administration $ 1,676,325 $ - $ 1,676,325 Public Works $ - $ - $ - Program Expenditures Total $ 33,504,350 $ 9,969 $ 33,514,319 Debt Service $ - $ - $ _ Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 2,773,714 $ - $ 2,773,714 Contingency $ 1,600,000 $ - $ 1,600,000 Total Budget $ 37,879,064 $ 9,969 $ 37,889,033 Reserve For Future Expenditure $ 28,037,055 $ - $ 28,037,055 Total Requirements $ 65,916,119 $ 9,969 $ 65,926,088 Exhibit A Q1PD02 -Ammo purchase - carryforward In September 2020, the Police Department placed orders with several vendors for our annual ammunition purchase. All of these orders have been received, with the exception of 20k rounds of 223 duty ammo. The vendor has indicated that this type of ammunition is on back order. We should have more accurate delivery timeline in the next 6 to 12 months. Of the total, $1,231 is Levy funded and $9,969 is from the General Fund. Fund 2 of 2 FY 2022 Q1 Revised Police Levy Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 322,952 $ 1,231 $ 324,183 Property Taxes $ 2,063,142 $ - $ 2,063,142 Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses & Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines & Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 2,386,094 $ 1,231 $ 2,387,325 Requirements Community Development $ - $ - $ - Community Services $ 2,128,599 $ 1,231 $ 2,129,830 Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ 2,128,599 $ 1,231 $ 2,129,830 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ - Total Budget $ 2,128,599 $ 1,231 $ 2,129,830 Reserve For Future Expenditure $ 257,495 $ - $ 257,495 Total Requirements $ 2,386,094 $ 1,231 $ 2,387,325 Exhibit A Q1PD03-Traffic Mod furniture-carryforward In May,PD ordered new office furniture for six(1)Traffic Unit employees to replace desks and cubicle walls.The existing furniture had been reallocated from another PD unit several years ago.The desks and panels were more than 15 years old,were degrading,and past their useful lives. Employees now all have sit-stand desks for ergonomic purposes and panels help to block sound when officers are attending virtual court or other meetings. Additionally,the office was reconfigured to more efficiently utilize the existing mod space and accommodate the additional of the Evening Traffic Safety Officer recently assigned to the unit.The furnishings are all movable and can easily be relocated if needed. Due to current supply chain constraints,the shipment arrived in early July,just after the new fiscal year start.The funds had been allocated in FY21 within the Asset Forfeiture Fund,and we request to carryforward into FY22. FY 2022 Q1 Revised Criminal Forfeiture Fund Adopted Amendment Qi Resources Beginning Fund Balance $ 570,840 $ 24,275 $ 595,115 Property Taxes $ - $ - $ Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ _ Licenses&Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines&Forfeitures $ 101,289 $ - $ 101,289 Interest Earnings $ - $ - $ - Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ _ Total Resources $ 672,129 $ 24,275 $ 696,404 Requirements Community Development $ - $ - $ - Community Services $ 362,719 $ 24,275 $ 386,994 Policy and Administration $ - $ _ S - Public Works $ - $ - S - Program Expenditures Total $ 362,719 $ 24,275 $ 386,994 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ _ Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 16 $ - $ 16 Contingency S - $ - $ - Total Budget $ 362,735 $ 24,275 $ 387,010 Reserve For Future Expenditure $ 309,394 $ - $ 309,394 Total Requirements $ 672,129 $ 24,275 $ 696,404 Exhibit A Q1PD04-One-time Levy start-up costs Several levy start-up allocation items were ordered in FY21,but not received or completed by the fiscal year end due to the ongoing COVID-19 related supply chain issues.As a result,we request to carryforward into FY22.These items include the parts and labor associated with outfitting the two levy- funded patrol vehicles($8,205).The vehicles were received,but were not outfitted with lights,cages,radios until July 2021.Additionally,computer equipment related to the hiring of new non-sworn levy funded positions was ordered but has not yet been received.These final two vehicles did not complete outfittings until July 2021. The funds for these'one time'purchases had been allocated in FY21 within the Levy Fund and need to be carried forward to FY22. FY 2022 Q1 Revised Police Levy Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 322,952 $ 12,205 $ 335,157 Property Taxes $ 2,063,142 $ - $ 2,063,142 Franchise Fees $ - $ $ Special Assessments $ - $ $ Licenses&Permits $ - $ $ Intergovernmental $ - $ - $ Charges for Services $ - $ - $ Fines&Forfeitures $ - $ - $ Interest Earnings $ - $ $ Miscellaneous $ - $ $ Other Financing Sources $ - $ - $ Transfers In from Other Funds $ - $ - $ Total Resources $ 2,386,094 $ 12,205 $ 2,398,299 Requirements Community Development $ - $ - $ Community Services $ 2,128,599 $ 12,205 $ 2,140,804 Policy and Administration $ - $ - $ Public Works $ - $ - $ Program Expenditures Total $ 2,128,599 $ 12,205 $ 2,140,804 Debt Service $ - $ - $ Loan to TCDA $ - $ _ S Work-In-Progress $ - $ - $ Transfers to Other Funds $ - $ - S Contingency $ - $ - $ Total Budget $ 2,128,599 $ 12,205 $ 2,140,804 Reserve For Future Expenditure $ 257,495 $ - $ 257,495 Total Requirements $ 2,386,094 $ 12,205 $ 2,398,299 Exhibit A Q1PD05-Parking lot security During the FY21 01,Council approved a$170,000 appropriation increase for the Police Department's parking lot security needs. Due to the evolving nature of the City's conversations with Ziply and the adjacent property,the original security plan could not be implemented as initially developed.In order to provide some security in the meantime,a fence was placed behind the far corner of Town Hall building and behind the two"mods",effectively closing off access to the PD from the Fanno Creek trails.Additionally,privacy slats were added to the existing parking lot fencing.The cost of this work was$10.3K and was completed before June 30,2021.The PD is working collaboratively with Facilities to develop alternative security plan scenarios depending upon the City's ability to utilize the adjacent property. The PD is requesting to carryforward the remaining$159.7K balance in order to have secured funding available once a security plan has been finalized. FY 2022 Q1 Revised General Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 29,041,365 $ 159,700 $ 29,201,065 Property Taxes $ 18,452,556 $ - $ 18,452,556 Franchise Fees $ 6,701,356 $ - $ 6,701,356 Special Assessments $ - $ - $ - Licenses&Permits $ 1,132,119 $ - $ 1,132,119 Intergovernmental $ 7,316,572 $ - $ 7,316,572 Charges for Services $ 242,743 $ - $ 242,743 Fines&Forfeitures $ 2,128,301 $ - $ 2,128,301 Interest Earnings $ 300,675 $ - $ 300,675 Miscellaneous $ 356,432 $ - $ 356,432 Other Financing Sources $ - $ - $ - Transfers In from Other Funds S 244,000 $ - $ 244,000 Total Resources $ 65,916,119 $ 159,700 $ 66,075,819 Requirements Community Development $ 4,410,334 $ - $ 4,410,334 Community Services $ 27,417,691 $ 159,700 $ 27,577,391 Policy and Administration $ 1,676,325 $ - $ 1,676,325 Public Works $ - $ - $ - Program Expenditures Total $ 33,504,350 $ 159,700 $ 33,664,050 Debt Service $ - $ - $ - Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 2,773,714 $ - $ 2,773,714 Contingency S 1,600,000 $ - $ 1,600,000 Total Budget $ 37,879,064 $ 159,700 $ 38,038,764 Reserve For Future Expenditure $ 28,037,055 $ - $ 28,037,055 Total Requirements $ 65,916,119 $ 159,700 $ 66,075,819 Exhibit A QIPW01-Carryforward for Vehicles The COVID-19 pandemic has caused significant delays on goods and materials up and down the supply chain. The auto industry has been one of the hardest hit,especially with issues in getting a steady supply of computer chips,and the delivery of new vehicles is falling quarters behind not just weeks or a month or two. The Public Works department ordered for vehicles in FY21 that will now not be delivered until FY22 (at best)and will need the encumbered funds from last fiscal year carried forward. The vehicles are as follows(all were purchased through an existing state contract with Landmark Ford): • A Ford F-150 Supercab w/an 8'box for PW Engineering that replaces vehicle#06-030. Carryforward amount is$35,000(Fund 640). PO #210108 issued on March 2,2021. • A Ford 350 4x2 PTC Flatbed for PW Streets Maintenance that replaces vehicle#04-002. Carryforward amount is$61,000(Fund 200). PO #210100 issued on February 19,2021. • A Ford F-250 4x4 Supercab w/an 8' box for the Water division that replaced vehicle#04-055. Carryforward amount is$31,000(Fund 530). PO#210101 issued on February 22,2021. • A Ford F-350 4x4 Supercab DRW PTC Service Body for the Water division that replaces#03-091. Carryforward amount is$63,000(Fund 530). PO#210087 issued on January 25,2021. Fund 1 of 3 FY 2022 Q1 Revised PW Engineering Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 2,155,989 $ 35,000 $ 2,190,989 Property Taxes $ - $ $ Franchise Fees $ - $ $ Special Assessments $ - $ - $ Licenses&Permits $ 870,000 $ - $ 870,000 Intergovernmental $ 153,369 $ $ 153,369 Charges for Services $ 3,420,918 $ - $ 3,420,918 Fines&Forfeitures $ - $ - $ Interest Earnings $ - $ $ Miscellaneous $ 5,094 $ - $ 5,094 Other Financing Sources $ - $ - $ Transfers In from Other Funds $ 667,710 $ - $ 667,710 Total Resources $ 7,273,080 $ 35,000 $ 7,308,080 Requirements - Community Development $ - $ - $ Community Services $ - $ - $ Policy and Administration $ - $ - $ Public Works $ 4,586,633 $ 35,000 $ 4,621,633 Program Expenditures Total $ 4,586,633 $ 35,000 $ 4,621,633 Debt Service $ - $ - $ Loan to TCDA $ - $ - $ Work-In-Progress $ - $ - $ Transfers to Other Funds $ - $ - $ Contingency $ 150,000 $ - $ 150,000 Total Budget $ 4,736,633 $ 35,000 $ 4,771,633 Reserve For Future Expenditure $ 2,536,447 $ - $ 2,536,447 Total Requirements $ 7,273,080 $ 35,000 $ 7,308,080 Exhibit A Q1PW01-Carryforward for Vehicles The COVID-19 pandemic has caused significant delays on goods and materials up and down the supply chain. The auto industry has been one of the hardest hit,especially with issues in getting a steady supply of computer chips,and the delivery of new vehicles is falling quarters behind not just weeks or a month or two. The Public Works department ordered for vehicles in FY21 that will now not be delivered until FY22(at best)and will need the encumbered funds from last fiscal year carried forward. The vehicles are as follows(all were purchased through an existing state contract with Landmark Ford): • A Ford F-150 Supercab w/an 8'box for PW Engineering that replaces vehicle#06-030. Carryforward amount is$35,000(Fund 640). PO#210108 issued on March 2, 2021. • A Ford 350 4x2 PTC Flatbed for PW Streets Maintenance that replaces vehicle#04-002. Carryforward amount is$61,000(Fund 200). PO#210100 issued on February 19,2021. • A Ford F-250 4x4 Supercab w/an 8'box for the Water division that replaced vehicle#04-055. Carryforward amount is$31,000(Fund 530). PO#210101 issued on February 22,2021. • A Ford F-350 4x4 Supercab DRW PTC Service Body for the Water division that replaces#03-091. Carryforward amount is$63,000(Fund 530). PO#210087 issued on January 25,2021. Fund 2 of 3 FY 2022 Q1 Revised Gas Tax Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 5,649,379 $ 61,000 $ 5,710,379 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ 65,965 $ - $ 65,965 Intergovernmental $ 4,613,760 $ - $ 4,613,760 Charges for Services $ - $ - $ - Fines&Forfeitures $ - $ - $ - Interest Earnings $ 61,800 $ - $ 61,800 Miscellaneous $ 62,818 $ - $ 62,818 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 283,500 $ - $ 283,500 Total Resources $ 10,737,222 $ 61,000 $ 10,798,222 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 3,509,585 $ 61,000 $ 3,570,585 Program Expenditures Total $ 3,509,585 $ 61,000 $ 3,570,585 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 2,467,104 $ - $ 2,467,104 Contingency $ 200,000 $ - $ 200,000 Total Budget $ 6,176,689 $ 61,000 $ 6,237,689 Reserve For Future Expenditure $ 4,560,533 $ - $ 4,560,533 Total Requirements $ 10,737,222 $ 61,000 $ 10,798,222 Exhibit A Q1PW01-Carryforward for Vehicles The COVID-19 pandemic has caused significant delays on goods and materials up and down the supply chain. The auto industry has been one of the hardest hit,especially with issues in getting a steady supply of computer chips,and the delivery of new vehicles is falling quarters behind not just weeks or a month or two. The Public Works department ordered for vehicles in FY21 that will now not be delivered until FY22(at best)and will need the encumbered funds from last fiscal year carried forward. The vehicles are as follows(all were purchased through an existing state contract with Landmark Ford): • A Ford F-150 Supercab w/an 8'box for PW Engineering that replaces vehicle#06-030. Carryforward amount is$35,000(Fund 640). PO #210108 issued on March 2,2021. • A Ford 350 4x2 PTC Flatbed for PW Streets Maintenance that replaces vehicle#04-002. Carryforward amount is$61,000(Fund 200). PO #210100 issued on February 19,2021. • A Ford F-250 4x4 Supercab w/an 8' box for the Water division that replaced vehicle#04-055. Carryforward amount is$31,000(Fund 530). PO #210101 issued on February 22,2021. • A Ford F-350 4x4 Supercab DRW PTC Service Body for the Water division that replaces#03-091. Carryforward amount is$63,000(Fund 530). PO#210087 issued on January 25,2021. Fund 3 of 3 FY 2022 Q1 Revised Water Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 37,914,231 $ 94,000 $ 38,008,231 Property Taxes $ - $ - $ Franchise Fees $ - $ $ Special Assessments $ - $ $ Licenses&Permits $ - $ $ Intergovernmental $ - $ $ Charges for Services $ 26,197,790 $ - $ 26,197,790 Fines&Forfeitures $ - $ $ Interest Earnings $ 375,525 $ $ 375,525 Miscellaneous $ 50,000 $ - $ 50,000 Other Financing Sources $ - $ - $ Transfers In from Other Funds $ 25,000 $ - $ 25,000 Total Resources $ 64,562,546 $ 94,000 $ 64,656,546 Requirements Community Development S - $ - $ Community Services S - $ $ Policy and Administration $ - $ - $ Public Works $ 10,646,000 S 94,000 $ 10,740,000 Program Expenditures Total $ 10,646,000 $ 94,000 $ 10,740,000 Debt Service $ - $ $ Loan to TCDA $ - $ $ Work-In-Progress $ 25,000 $ $ 25,000 Transfers to Other Funds $ 22 320,789 $ - $ 22,320 789 Contingency $ 475,000 $ - $ 475,000 Total Budget $ 33,466,789 $ 94,000 $ 33,560,789 Reserve For Future Expenditure $ 31,095,757 $ - $ 31,095,757 Total Requirements $ 64,562,546 $ 94,000 $ 64,656,546 Exhibit A Q1PW02 - Carryforward for 119th Automatic Transfer Switch This project was to install a turn-key replacement automatic transfer switch in the generator building at the reservoir#2. The COVID 19 pandemic has caused significant delays on goods and materials up and down the supply chain. The city experienced this delay with a needed replacement of the automatic transfer switch (ATS) at Reservoir#2 at 119th Place. The Public Works department issued PO#P210128 (issued on April 28th) for the work with an original understanding that it would all be completed within a few weeks. Issues with getting the actual part delivered however delayed the work by over two months and into a new fiscal year. As such,the encumbered funds from last fiscal year need to be carried forward into FY22. FY 2022 Q1 Revised Water Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 37,914,231 $ 15,400 $ 37,929,631 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses & Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ 26,197,790 $ - $ 26,197,790 Fines & Forfeitures $ - $ - $ - Interest Earnings $ 375,525 $ - $ 375,525 Miscellaneous $ 50,000 $ - $ 50,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 25,000 S - $ 25,000 Total Resources $ 64,562,546 $ 15,400 $ 64,577,946 Requirements Community Development S - $ - $ - Community Services S - $ - $ - Policy and Administration S - $ - $ - Public Works $ 10,646,000 $ 15,400 $ 10,661,400 Program Expenditures Total $ 10,646,000 $ 15,400 $ 10,661,400 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 25,000 $ - $ 25,000 Transfers to Other Funds $ 22,320,789 $ - $ 22,320,789 Contingency $ 475,000 $ - $ 475,000 Total Budget $ 33,466,789 $ 15,400 $ 33,482,189 Reserve For Future Expenditure $ 31,095,757 $ - $ 31,095,757 Total Requirements $ 64,562,546 $ 15,400 $ 64,577,946 Exhibit A O1PW12-Engineering Design and Construction Standards Carryforward$70,000 of prior year appropriations encumbered to Contract#C200098. Internal constraints including COVID-19 related issues, reprioritization of projects, and teammate turnover, have delayed completion of the contract. FY 2022 Q1 Revised PW Engineering Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 2,155,989 $ 70,000 $ 2,225,989 Property Taxes $ - $ $ Franchise Fees $ - $ - $ Special Assessments $ - $ - $ Licenses &Permits $ 870,000 $ - $ 870,000 Intergovernmental $ 153,369 $ - $ 153,369 Charges for Services $ 3,420,918 $ - $ 3,420,918 Fines &Forfeitures $ - $ - $ Interest Earnings $ - $ - $ Miscellaneous $ 5,094 $ - $ 5,094 Other Financing Sources $ _ $ - $ Transfers In from Other Funds $ 667,710 $ - $ 667,710 Total Resources $ 7,273,080 $ 70,000 $ 7,343,080 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ Policy and Administration $ - $ - $ Public Works $ 4,586,633 $ 70,000 $ 4,656,633 Program Expenditures Total $ 4,586,633 $ 70,000 $ 4,656,633 Debt Service $ - $ - $ Loan to TCDA $ - $ - $ Work-In-Progress $ - $ - $ Transfers to Other Funds $ - $ - $ Contingency $ 150,000 $ - $ 150,000 Total Budget $ 4,736,633 $ 70,000 $ 4,806,633 Reserve For Future Expenditure $ 2,536,447 $ - $ 2,536,447 Total Requirements $ 7,273,080 $ 70,000 $ 7,343,080 Exhibit A Q1PW03 - CIP 96055 Risk and Resilience Assessment and Emergency Response Plan Carryforward $36,000 from prior year appropriations impacting the Water Fund (530). The City of Tigard will participate in a regional tabletop emergency exercise with the City of Lake Oswego and the LO/T Water Treatment Plant.This exercise will not be completed until December 2021. Fund 1 of 2 FY 2022 Q1 Revised Water Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 37,914,231 $ 36,000 $ 37,950,231 Property Taxes $ - $ - $ _ Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses & Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ 26,197,790 $ - $ 26,197,790 Fines & Forfeitures $ - $ - $ - Interest Earnings $ 375,525 $ - $ 375,525 Miscellaneous $ 50,000 $ - $ 50,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 25,000 $ - $ 25,000 Total Resources $ 64,562,546 $ 36,000 $ 64,598,546 Requirements Community Development $ - $ - $ _ Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 10,646,000 $ - $ 10,646,000 Program Expenditures Total $ 10,646,000 $ - $ 10,646,000 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 25,000 $ - $ 25,000 Transfers to Other Funds $ 22,320,789 $ 36,000 $ 22,356,789 Contingency $ 475,000 $ - $ 475,000 Total Budget $ 33,466,789 $ 36,000 $ 33,502,789 Reserve For Future Expenditure $ 31,095,757 $ - $ 31,095,757 Total Requirements $ 64,562,546 $ 36,000 $ 64,598,546 Exhibit A Q1PW03 - CIP 96055 Risk and Resilience Assessment and Emergency Response Plan Carryforward $36,000 from prior year appropriations impacting the Water Fund (530). The City of Tigard will participate in a regional tabletop emergency exercise with the City of Lake Oswego and the LO/T Water Treatment Plant. This exercise will not be completed until December 2021. Fund 2 of 2 FY 2022 Q1 Revised Water CIP Fund Adopted Amendment Qi Resources Beginning Fund Balance $ 1,850,125 $ - $ 1,850,125 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 $ 15,090,000 $ 36,000 $ 15,126,000 Total Resources $ 16,940,125 $ 36,000 $ 16,976,125 Requirements Community Development $ - $ - $ _ Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ Loan to TCDA $ - $ - $ Work-In-Progress $ 15,090,000 $ 36,000 $ 15,126,000 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ Total Budget $ 15,090,000 $ 36,000 $ 15,126,000 Reserve For Future Expenditure $ 1,850,125 $ - $ 1,850,125 Total Requirements $ 16,940,125 $ 36,000 $ 16,976,125 Exhibit A Q1PW04 - CIP 92059 Universal Plaza Carryforward $86,000 from prior year appropriations impacting Parks SDC Fund (425) and $52,000 from Urban Renewal Capital Improvement Fund (940). Construction did not start as scheduled; estimated cost requires the dollars remain available. FY 2022 Q1 Revised Parks SDC Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 7,798,824 $ 86,000 $ 7,884,824 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ 1,495,466 $ - $ 1,495,466 Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines & Forfeitures $ - $ - $ - Interest Earnings $ 158,325 $ - $ 158,325 Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 180,000 $ - $ 180,000 Total Resources $ 9,632,615 $ 86,000 $ 9,718,615 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 $ 5,509,700 $ 86,000 $ 5,595,700 Contingency $ - $ - $ - Total Budget $ 5,509,700 $ 86,000 $ 5,595,700 Reserve For Future Expenditure $ 4,122,915 $ - $ 4,122,915 Total Requirements $ 9,632,615 $ 86,000 $ 9,718,615 Exhibit A QIPW05-CIP 91023 Public Works Field Staff Work Area and Breakroom Carryforward$7,500 from prior year appropriations impacting Parks Utility Fund(270),$3,300 from Sanitary Sewer Fund(500),$5,700 from Stormwater Fund(510)and$8,500 from the Water Fund(530). Delay in contract award, largely due to teammates dedicated to needs and supply chain issues,has pushed entire project into FY 2022. Fund 1 of 5 FY 2022 Q1 Revised Parks Utility Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 2,079,743 $ 7,500 $ 2,087,243 Property Taxes $ - $ $ Franchise Fees $ - $ $ Special Assessments $ - $ - $ Licenses&Permits $ 2,406,398 $ - $ 2,406,398 Intergovernmental $ - $ - $ Charges for Services $ 90,750 $ - $ 90,750 Fines&Forfeitures $ - $ - $ Interest Earnings $ 2,475 $ - $ 2,475 Miscellaneous $ - $ - $ Other Financing Sources $ - $ - $ Transfers In from Other Funds $ 2,437,500 $ - $ 2,437,500 Total Resources $ 7,016,866 $ 7,500 $ 7,024,366 Requirements Community Development $ - $ - $ Community Services $ - $ - $ Policy and Administration $ - $ - $ Public Works $ 4,604,613 $ - $ 4,604,613 Program Expenditures Total $ 4,604,613 $ - $ 4,604,613 Debt Service $ - $ - $ Loan to TCDA $ - $ - $ Work-In-Progress $ - $ - $ Transfers to Other Funds $ 105,402 $ 7,500 $ 112,902 Contingency $ 325,000 $ - $ 325,000 Total Budget $ 5,035,015 $ 7,500 $ 5,042,515 Reserve For Future Expenditure $ 1,981,851 $ - $ 1,981,851 Total Requirements $ 7,016,866 $ 7,500 $ 7,024,366 Exhibit A Q1PW05-CIP 91023 Public Works Field Staff Work Area and Breakroom Carryforward$7,500 from prior year appropriations impacting Parks Utility Fund(270),$3,300 from Sanitary Sewer Fund(500),$5,700 from Stormwater Fund(510)and$8,500 from the Water Fund(530). Delay in contract award,largely due to teammates dedicated to needs and supply chain issues,has pushed entire project into FY 2022. Fund 2 of 5 FY 2022 QI Revised Sanitary Sewer Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 7,592,586 $ 3,300 $ 7,595,886 Property Taxes $ - $ - $ _ Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ _ Licenses&Permits $ 92,200 $ - $ 92,200 Intergovernmental $ - $ - $ _ Charges for Services $ 3,412,921 $ - $ 3,412,921 Fines&Forfeitures $ - $ - $ - Interest Earnings $ 82,725 $ - $ 82,725 Miscellaneous $ 42,100 $ - $ 42,100 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 11,222,532 $ 3,300 $ 11,225,832 Requirements Community Development $ - $ - $ _ Community Services $ - $ - $ - Policy and Administration $ - $ - $ Public Works $ 2,654,197 $ - $ 2,654,197 Program Expenditures Total $ 2,654,197 $ - $ 2,654,197 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 100,000 $ - $ 100,000 Transfers to Other Funds $ 1,463,846 $ 3,300 $ 1,467,146 Contingency $ 200,000 $ - $ 200,000 Total Budget $ 4,418,043 $ 3,300 $ 4,421,343 Reserve For Future Expenditure $ 6,804,489 $ - $ 6,804,489 Total Requirements $ 11,222,532 $ 3,300 $ 11,225,832 Exhibit A Q1PW05-CIP 91023 Public Works Field Staff Work Area and Breakroom Carryforward$7,500 from prior year appropriations impacting Parks Utility Fund(270),$3,300 from Sanitary Sewer Fund(500),$5,700 from Stormwater Fund(510)and$8,500 from the Water Fund(530). Delay in contract award,largely due to teammates dedicated to needs and supply chain issues, has pushed entire project into FY 2022. Fund 3 of 5 FY 2022 Q1 Revised Stormwater Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 7,636,541 $ 5,700 $ 7,642,241 Property Taxes $ - $ $ Franchise Fees $ - $ $ Special Assessments $ - $ - $ Licenses&Permits $ - $ - $ Intergovernmental $ - $ - $ Charges for Services $ 5,653,512 $ - $ 5,653,512 Fines&Forfeitures $ - $ - $ Interest Earnings $ 104,925 $ - $ 104,925 Miscellaneous $ 5,000 $ - $ 5,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 1,395,000 $ - $ 1,395,000 Total Resources $ 14,794,978 $ 5,700 $ 14,800,678 Requirements Community Development $ - $ - $ - Community Services $ - $ _ $ - Policy and Administration $ - $ - $ - Public Works $ 3,828,774 $ - $ 3,828,774 Program Expenditures Total $ 3,828,774 $ - $ 3,828,774 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ Work-In-Progress $ 4,777,500 $ - $ 4,777,500 Transfers to Other Funds $ 347,528 $ 5,700 $ 353,228 Contingency $ 275,000 $ - $ 275,000 Total Budget $ 9,228,802 $ 5,700 $ 9,234,502 Reserve For Future Expenditure $ 5,566,176 $ - $ 5,566,176 Total Requirements $ 14,794,978 $ 5,700 $ 14,800,678 Exhibit A Q1PW05-CIP 91023 Public Works Field Staff Work Area and Breakroom Carryforward$7,500 from prior year appropriations impacting Parks Utility Fund(270),$3,300 from Sanitary Sewer Fund (500),$5,700 from Stormwater Fund(510)and$8,500 from the Water Fund(530). Delay in contract award,largely due to teammates dedicated to needs and supply chain issues,has pushed entire project into FY 2022. Fund 4 of 5 FY 2022 Q1 Revised Water Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 37,914,231 $ 8,500 $ 37,922,731 Property Taxes $ - $ - $ _ Franchise Fees $ - $ - $ _ Special Assessments $ - $ - $ _ Licenses&Permits $ - $ - $ _ Intergovernmental $ - $ - $ - Charges for Services $ 26,197,790 $ - $ 26,197,790 Fines&Forfeitures $ - $ - $ - Interest Earnings $ 375,525 $ - $ 375,525 Miscellaneous $ 50,000 $ - $ 50,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 25,000 $ - $ 25,000 Total Resources $ 64,562,546 $ 8,500 $ 64,571,046 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 10,646,000 $ - $ 10,646,000 Program Expenditures Total $ 10,646,000 $ - $ 10,646,000 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 25,000 $ - $ 25,000 Transfers to Other Funds $ 22,320,789 $ 8,500 $ 22,329,289 Contingency $ 475,000 $ - $ 475,000 Total Budget $ 33,466,789 $ 8,500 $ 33,475,289 Reserve For Future Expenditure $ 31,095,757 $ - $ 31,095,757 Total Requirements $ 64,562,546 $ 8,500 $ 64,571,046 Exhibit A O1PW05-CIP 91023 Public Works Field Staff Work Area and Breakroom Carryforward$7,500 from prior year appropriations impacting Parks Utility Fund(270),$3,300 from Sanitary Sewer Fund (500),$5,700 from Stormwater Fund(510)and$8,500 from the Water Fund(530). Delay in contract award,largely due to teammates dedicated to needs and supply chain issues,has pushed entire project into FY 2022. Fund 5 of 5 FY 2022 Q1 Revised Facilities Capital Projects Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,375,150 $ - $ 1,375,150 Property Taxes $ - $ - $ _ Franchise Fees $ - S - $ _ Special Assessments $ - $ - $ - Licenses&Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines&Forfeitures $ - $ - $ - Interest Earnings $ 14,175 $ - $ 14,175 Miscellaneous $ - $ - $ - Other Financing Sources $ 25,298,270 $ - $ 25,298,270 Transfers In from Other Funds $ 7,450,000 $ 25,000 $ 7,475,000 Total Resources $ 34,137,595 $ 25,000 $ 34,162,595 Requirements Community Development $ - $ - $ _ Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ _ Work-In-Progress $ 32,648,270 $ 25,000 $ 32,673,270 Transfers to Other Funds $ 45 $ - $ 45 Contingency $ - S - $ _ Total Budget $ 32,648,315 $ 25,000 $ 32,673,315 Reserve For Future Expenditure $ 1,489,280 $ - $ 1,489,280 Total Requirements $ 34,137,595 $ 25,000 $ 34,162,595 Exhibit A O1PW06 - CIP 92016-08 Dirksen Nature Park- Off-Street Parking Lot Carryforward $46,000 from prior year appropriations impacting Parks SDC Fund (425). Permitting through CWS has taken longer than expected, causing delay in the project. Fund 1 of 2 FY 2022 Q1 Revised Parks SDC Fund Adopted Amendment Qi Resources Beginning Fund Balance $ 7,798,824 $ 46,000 $ 7,844,824 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses & Permits $ 1,495,466 $ - $ 1,495,466 Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines & Forfeitures $ - $ - $ - Interest Earnings $ 158,325 $ - $ 158,325 Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 180,000 $ - $ 180,000 Total Resources $ 9,632,615 $ 46,000 $ 9,678,615 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 $ 5,509,700 $ 46,000 $ 5,555,700 Contingency $ - $ - $ - Total Budget $ 5,509,700 $ 46,000 $ 5,555,700 Reserve For Future Expenditure $ 4,122,915 $ - $ 4,122,915 Total Requirements $ 9,632,615 $ 46,000 $ 9,678,615 Exhibit A Q1PW06 - CIP 92016-08 Dirksen Nature Park- Off-Street Parking Lot Carryforward $46,000 from prior year appropriations impacting Parks SDC Fund (425). Permitting through CWS has taken longer than expected, causing delay in the project. Fund 2 of 2 FY 2022 Qi Revised Parks Capital Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 650,000 $ - $ 650,000 Property Taxes $ - $ - $ Franchise Fees $ - $ - $ Special Assessments $ - $ - $ Licenses & Permits $ - $ - $ Intergovernmental $ 151,945 $ - $ 151,945 Charges for Services $ - $ - $ - Fines & Forfeitures $ - $ - $ Interest Earnings $ - $ - $ Miscellaneous $ - $ - $ Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 8,977,500 $ 46,000 $ 9,023,500 Total Resources $ 9,779,445 $ 46,000 $ 9,825,445 Requirements Community Development $ - $ - $ _ Community Services $ - $ - $ Policy and Administration $ - $ - $ _ Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ Loan to TCDA $ - $ - $ Work-In-Progress $ 9,766,945 $ 46,000 $ 9,812,945 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ - Total Budget $ 9,766,945 $ 46,000 $ 9,812,945 Reserve For Future Expenditure $ 12,500 $ - $ 12,500 Total Requirements $ 9,779,445 $ 46,000 $ 9,825,445 Exhibit A Q1PW07 - CIP 92016-13 Dirksen Nature Park-Wetland Boardwalk and Walkway Carryforward $64,500 from prior year appropriations impacting Parks SDC Fund (425). Moved construction out one year to build the off-street parking lot and boardwalk as one project. Also, permitting through CWS has taken longer than expected, causing delay in the project. Fund 1 of 2 FY 2022 Q1 Revised Parks SDC Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 7,798,824 $ 64,500 $ 7,863,324 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses & Permits $ 1,495,466 $ - $ 1,495,466 Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines & Forfeitures $ - $ - $ - Interest Earnings $ 158,325 $ - $ 158,325 Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 180,000 $ - $ 180,000 Total Resources $ 9,632,615 $ 64,500 $ 9,697,115 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 $ 5,509,700 $ 64,500 $ 5,574,200 Contingency $ - $ - $ - Total Budget $ 5,509,700 $ 64,500 $ 5,574,200 Reserve For Future Expenditure $ 4,122,915 $ - $ 4,122,915 Total Requirements $ 9,632,615 $ 64,500 $ 9,697,115 Exhibit A Q1PW07 - CIP 92016-13 Dirksen Nature Park-Wetland Boardwalk and Walkway Carryforward $64,500 from prior year appropriations impacting Parks SDC Fund (425). Moved construction out one year to build the off-street parking lot and boardwalk as one project. Also, permitting through CWS has taken longer than expected, causing delay in the project. Fund 2 of 2 FY 2022 Q1 Revised Parks Capital Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 650,000 $ - $ 650,000 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses & Permits $ - $ - $ - Intergovernmental $ 151,945 $ - $ 151,945 Charges for Services $ - $ - $ - Fines & Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 8,977,500 $ 64,500 $ 9,042,000 Total Resources $ 9,779,445 $ 64,500 $ 9,843,945 Requirements Community Development $ - $ - $ _ Community Services $ - $ - $ _ Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 9,766,945 $ 64,500 $ 9,831,445 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ - Total Budget $ 9,766,945 $ 64,500 $ 9,831,445 Reserve For Future Expenditure $ 12,500 $ - $ 12,500 Total Requirements $ 9,779,445 $ 64,500 $ 9,843,945 Exhibit A O1PW08 - CIP 94048 Oak Street Property Acquisition Carryforward $28,000 from prior year appropriations impacting the Stormwater Fund (510). Additional permitting required due to the proximity of steep slopes. Hazardous material (Asbestos and lead) have been found in the house which requires a Plans and Hazardous Building Material Survey to assist with proper removal of hazardous building materials. FY 2022 Q1 Revised Stormwater Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 7,636,541 $ 28,000 $ 7,664,541 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses & Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ 5,653,512 $ - $ 5,653,512 Fines & Forfeitures $ - $ - $ - Interest Earnings $ 104,925 $ - $ 104,925 Miscellaneous $ 5,000 $ - $ 5,000 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 1,395,000 $ - $ 1,395,000 Total Resources $ 14,794,978 $ 28,000 $ 14,822,978 Requirements Community Development $ - $ - S - Community Services $ - $ - S - Policy and Administration $ - $ - $ - Public Works $ 3,828,774 $ - $ 3,828,774 Program Expenditures Total $ 3,828,774 $ - $ 3,828,774 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 4,777,500 $ 28,000 $ 4,805,500 Transfers to Other Funds $ 347,528 $ - $ 347,528 Contingency $ 275,000 $ - $ 275,000 Total Budget $ 9,228,802 $ 28,000 $ 9,256,802 Reserve For Future Expenditure $ 5,566,176 $ - $ 5,566,176 Total Requirements $ 14,794,978 $ 28,000 $ 14,822,978 Exhibit A Q1PW09 - CIP 92056 Park System Master Plan Update Carryforward $26,500 from prior year appropriations impacting Parks SDC Fund (425). The Parks Master Plan is in the final stages. Late stage edits will be incorporated in the report, which will be presented to council for adoption in late Fall 2021. Due to additional work, which was added to the project last year, the project completion date is extended. As such,this request will carryforward FY21's project appropriations to FY22. No new appropriations are being requested. Fund 1 of 2 FY 2022 Q1 Revised Parks SDC Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 7,798,824 $ 26,500 $ 7,825,324 Property Taxes $ - $ - $ Franchise Fees $ - $ - $ Special Assessments $ - $ - $ - Licenses & Permits $ 1,495,466 $ - $ 1,495,466 Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines & Forfeitures $ - $ - $ - Interest Earnings $ 158,325 $ . - $ 158,325 Miscellaneous $ $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 180,000 $ - $ 180,000 Total Resources $ 9,632,615 $ 26,500 $ 9,659,115 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 $ 5,509,700 $ 26,500 $ 5,536,200 Contingency $ - $ - $ - Total Budget $ 5,509,700 $ 26,500 $ 5,536,200 Reserve For Future Expenditure $ 4,122,915 $ - $ 4,122,915 Total Requirements $ 9,632,615 $ 26,500 $ 9,659,115 Exhibit A Q1PW09 - CIP 92056 Park System Master Plan Update Carryforward $26,500 from prior year appropriations impacting Parks SDC Fund (425). The Parks Master Plan is in the final stages. Late stage edits will be incorporated in the report, which will be presented to council for adoption in late Fall 2021. Due to additional work, which was added to the project last year,the project completion date is extended. As such,this request will carryforward FY21's project appropriations to FY22. No new appropriations are being requested. Fund 2 of 2 FY 2022 Q1 Revised Parks Capital Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 650,000 $ - $ 650,000 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ _ Licenses & Permits $ - $ - $ - Intergovernmental $ 151,945 $ - $ 151,945 Charges for Services $ - $ - $ - Fines & Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 8,977,500 $ 26,500 $ 9,004,000 Total Resources $ 9,779,445 $ 26,500 $ 9,805,945 Requirements Community Development $ - $ - $ - Community Services $ - $ - 8 - Policy and Administration $ - $ - $ _ Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 9,766,945 $ 26,500 $ 9,793,445 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ - Total Budget $ 9,766,945 $ 26,500 $ 9,793,445 Reserve For Future Expenditure $ 12,500 $ - $ 12,500 Total Requirements $ 9,779,445 $ 26,500 $ 9,805,945 Exhibit A 01PW10 - CIP 95063 Transportation System Plan Update Carryforward $51,500 from prior year appropriations impacting Transportation SDC Fund (415). The project has been delayed due to consultant team changes and COVID-19 related issues. An increase in contract scope to include additional active transportation network planning and legislative adoption tasks have also increased the project time- frame. The total project amount remains the same as the adopted CIP budget. Fund 1 of 2 FY 2022 Qi Revised Transportation SDC Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 6,489,549 $ 51,500 $ 6,541,049 Property Taxes $ - $ - $ Franchise Fees $ - $ - $ Special Assessments $ - $ - $ - Licenses & Permits $ 701,855 $ - $ 701,855 Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines & Forfeitures $ - $ - $ - Interest Earnings $ 108,000 $ - $ 108,000 Miscellaneous $ $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 104,700 $ - $ 104,700 Total Resources $ 7,404,104 $ 51,500 $ 7,455,604 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 $ 5,484,140 $ 51,500 $ 5,535,640 Contingency $ - $ - $ - Total Budget $ 5,484,140 $ 51,500 $ 5,535,640 Reserve For Future Expenditure $ 1,919,964 $ - $ 1,919,964 Total Requirements $ 7,404,104 $ 51,500 $ 7,455,604 Exhibit A Q1PW10 - CIP 95063 Transportation System Plan Update Carryforward $51,500 from prior year appropriations impacting Transportation SDC Fund (415). The project has been delayed due to consultant team changes and COVID-19 related issues. An increase in contract scope to include additional active transportation network planning and legislative adoption tasks have also increased the project time-frame. The total project amount remains the same as the adopted CIP budget. Fund 2 of 2 FY 2022 Q1 Revised Transportation CIP Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,947,526 $ - $ 1,947,526 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses & Permits $ - $ - $ - Intergovernmental $ 1,864,279 $ - $ 1,864,279 Charges for Services $ - $ - $ - Fines & Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 11,180,221 $ 51,500 $ 11,231,721 Total Resources $ 14,992,026 $ 51,500 $ 15,043,526 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ _ Work-In-Progress $ 13,269,500 $ 51,500 $ 13,321,000 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ _ Total Budget $ 13,269,500 $ 51,500 $ 13,321,000 Reserve For Future Expenditure $ 1,722,526 $ - $ 1,722,526 Total Requirements $ 14,992,026 $ 51,500 $ 15,043,526 Exhibit A Q1PW11 - CIP 95065 Pacific Highway Street Lights Carryforward $9,000 from prior year appropriations impacting Gas Tax(200) and $217,160 from State Fund Local Project Grant. IGA with ODOT is being adjusted to remove two intersections that were included in this project and another project that is being managed by ODOT. A third intersection, at Bull Mountain Road, has been added to the City of Tigard Project. This discrepancy led to the project being delayed. Total project cost remains the same as the adopted OP budget. Fund 1 of 2 FY 2022 Q1 Revised Gas Tax Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 5,649,379 $ 9,000 $ 5,658,379 Property Taxes $ - $ - $ Franchise Fees $ - $ - $ Special Assessments $ - $ - $ Licenses & Permits $ 65,965 $ - $ 65,965 Intergovernmental $ 4,613,760 $ - $ 4,613,760 Charges for Services $ - $ - $ Fines & Forfeitures $ - $ - $ - Interest Earnings $ 61,800 $ - $ 61,800 Miscellaneous $ 62,818 $ - $ 62,818 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 283,500 $ - $ 283,500 Total Resources $ 10,737,222 $ 9,000 $ 10,746,222 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 3,509,585 $ - $ 3,509,585 Program Expenditures Total $ 3,509,585 $ - $ 3,509,585 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 2,467,104 $ 9,000 $ 2,476,104 Contingency $ 200,000 $ - $ 200,000 Total Budget $ 6,176,689 $ 9,000 $ 6,185,689 Reserve For Future Expenditure $ 4,560,533 $ - $ 4,560,533 Total Requirements $ 10,737,222 $ 9,000 $ 10,746,222 Exhibit A Q1PW11 - CIP 95065 Pacific Highway Street Lights Carryforward $9,000 from prior year appropriations impacting Gas Tax(200) and $217,160 from State Fund Local Project Grant. IGA with ODOT is being adjusted to remove two intersections that were included in this project and another project that is being managed by ODOT. A third intersection, at Bull Mountain Road, has been added to the City of Tigard Project. This discrepancy led to the project being delayed. Total project cost remains the same as the adopted CIP budget. Fund 2 of 2 FY 2022 Qi Revised Transportation CIP Fund Adopted Amendment Q1 Resources Beginning Fund Balance $ 1,947,526 $ - $ 1,947,526 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses & Permits $ - $ - $ - Intergovernmental $ 1,864,279 $ 217,160 $ 2,081,439 Charges for Services $ - $ - $ - Fines &Forfeitures $ - $ - $ - Interest Earnings $ - $ - $ - Miscellaneous $ - $ - $ - Other Financing Sources $ - $ - $ _ Transfers In from Other Funds $ 11,180,221 $ 9,000 $ 11,189,221 Total Resources $ 14,992,026 $ 226,160 $ 15,218,186 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ _ Policy and Administration $ - $ - $ _ Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 13,269,500 $ 226,160 $ 13,495,660 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ - Total Budget $ 13,269,500 $ 226,160 $ 13,495,660 Reserve For Future Expenditure $ 1,722,526 $ - $ 1,722,526 Total Requirements $ 14,992,026 $ 226,160 $ 15,218,186 Exhibit B Total All Funds FY 2022 Q1 Revised Total All Funds Adopted Amendment Q1 Resources Beginning Fund Balance $ 185,496,761 $ 1,268,838 $ 186,765,599 Property Taxes $ 23,265,605 $ - $ 23,265,605 Franchise Fees $ 6,701,356 $ - $ 6,701,356 Special Assessments $ 50,000 $ - $ 50,000 Licenses&Permits $ 17,881,070 $ - $ 17,881,070 Intergovernmental $ 15,735,184 $ 299,160 $ 16,034,344 Charges for Services $ 56,719,220 $ - $ 56,719,220 Fines&Forfeitures $ 2,229,590 $ - $ 2,229,590 Interest Earnings $ 1,911,000 $ - $ 1,911,000 Miscellaneous $ 670,944 $ 12,712 $ 683,656 Other Financing Sources $ 25,298,270 $ - $ 25,298,270 Transfers In from Other Funds S 56,556,287 $ 258,500 S 56,814,787 Total Resources $ 392,515,287 $ 1,839,210 $ 394,354,497 Requirements Community Development $ 7,623,926 $ 205,558 $ 7,829,484 Community Services $ 29,909,009 $ 243,380 $ 30,152,389 Policy and Administration $ 19,248,996 $ 488,800 $ 19,737,796 Public Works $ 32,363,188 $ 275,400 $ 32,638,588 Program Expenditures Total $ 89,145,119 $ 1,213,138 $ 90,358,257 Debt Service $ 9,672,764 $ - $ 9,672,764 Loan to TCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ 78,517,215 $ 503,660 $ 79,020,875 Transfers to Other Funds $ 55,153,787 $ 344,500 $ 55,498,287 Contingency S 4,200,000 $ (222,088) $ 3,977,912 Total Budget $ 236,689,885 $ 1,839,210 $ 238,529,095 Reserve For Future Expenditure $ 155,825,402 $ - $ 155,825,402 Total Requirements $ 392,515,287 $ 1,839,210 $ 394,354,497 Exhibit B General Fund FY 2022 Revised General Fund Adopted Q1CD01 Q1CD02 Q1CD03 Q1CD04 Q1PD01 Q1PD02 Q1PD05 Q1 Resources Beginning Fund Balance $ 29,041,365 $ - $ 42,600 $ 13,133 $ 42,825 $ - $ 9,969 $ 159,700 $ 29,309,592 Property Taxes $ 18,452,556 $ - S - $ - $ - $ - $ - $ - $ 18,452,556 Franchise Fees $ 6,701,356 $ - S - $ - $ - $ - $ - $ - $ 6,701,356 Special Assessments $ - $ - S - $ - $ - $ - $ - $ - $ - Licenses&Permits $ 1,132,119 $ - S - $ - $ - $ - S - $ - $ 1,132,119 Intergovernmental $ 7,316,572 $ 82,000 $ - $ - $ - $ - $ - $ - $ 7,398,572 Charges for Services $ 242,743 $ - $ - $ - $ - $ - $ - $ - $ 242,743 Fines&Forfeitures $ 2,128,301 $ - S - $ - $ - $ - $ - $ - $ 2,128,301 Interest Earnings $ 300,675 $ - S - $ - $ - $ - $ - $ - $ 300,675 Miscellaneous $ 356,432 S - S - S - $ - $ 12,712 $ - $ - $ 369,144 Other Financing Sources $ - $ - S - 5 - $ - $ - $ - $ - $ - Transfers In from Other Funds $ 244,000 $ - $ - $ - $ - $ - $ - $ - $ 244,000 Total Resources $ 65,916,119 $ 82,000 $ 42,600 $ 13,133 $ 42,825 $ 12,712 $ 9,969 $ 159,700 $ 66,279,058 Requirements Community Development $ 4,410,334 $ 107,000 $ 42,600 $ 13,133 $ 42,825 $ - $ - $ - $ 4,615,892 Community Services $ 27,417,691 $ - $ - $ - $ - $ 36,000 $ 9,969 $ 159,700 $ 27,623,360 Policy and Administration $ 1,676,325 $ - $ - $ - $ - $ - $ - $ - $ 1,676,325 Public Works $ - $ - 5 - $ - $ - $ - $ - $ - $ - Program Expenditures Total $ 33,504,350 $ 107,000 $ 42,600 $ 13,133 $ 42,825 $ 36,000 $ 9,969 $ 159,700 $ 33,915,577 Debt Service $ - $ - $ - $ - $ - $ - $ - $ - $ - Loan to TCDA $ 1,000 $ - $ - $ - $ - $ - $ - $ - $ 1,000 Work-In-Progress $ - $ - $ - $ - S - $ - $ - $ - $ - Transfers to Other Funds S 2,773,714 $ - $ - S - S - $ - S - $ - $ 2,773,714 Contingency $ 1,600,000 $ (25,000) 5 - $ - $ - $ (23,288) $ - $ - $ 1,551,712 Total Budget $ 37,879,064 $ 82,000 $ 42,600 $ 13,133 $ 42,825 $ 12,712 $ 9,969 $ 159,700 $ 38,242,003 Reserve For Future Expenditure $ 28,037,055 $ - $ - $ - $ - $ - $ - $ - $ 28,037,055 Total Requirements $ 65,916,119 $ 82,000 $ 42,600 $ 13,133 $ 42,825 $ 12,712 $ 9,969 $ 159,700 $ 66,279,058 Exhibit B Gas Tax Fund FY 2022 Revised Gas Tax Fund Adopted QIPW01 Q1PW11 Q1 Resources Beginning Fund Balance $ 5,649,379 $ 61,000 $ 9,000 $ 5,719,379 Property Taxes S - $ - S - $ - Franchise Fees $ - $ - S - $ - Special Assessments $ - $ - $ - $ - Licenses&Permits $ 65,965 $ - $ - $ 65,965 Intergovernmental $ 4,613,760 $ - $ - $ 4,613,760 Charges for Services $ - $ - $ - $ - Fines&Forfeitures $ - $ $ - $ - Interest Earnings $ 61,800 $ S - $ 61,800 Miscellaneous $ 62,818 $ - S - $ 62,818 Other Financing Sources $ - $ $ - $ - Transfers In from Other Funds $ 283,500 $ - S - $ 283,500 Total Resources $ 10,737,222 $ 61,000 $ 9,000 $ 10,807,222 Requirements Community Development S - $ - $ - S Community Services $ - S - S - S - Policy and Administration $ - S - $ - $ - Public Works $ 3,509,585 $ 61,000 $ - $ 3,570,585 Program Expenditures Total $ 3,509,585 $ 61,000 $ - $ 3,570,585 Debt Service $ - $ - $ - $ - Loan to TCDA $ - $ - $ - $ - Work-In-Progress $ - $ - $ - $ - Transfers to Other Funds $ 2,467,104 $ - S 9,000 $ 2,476,104 Contingency $ 200,000 $ - $ - $ 200,000 Total Budget $ 6,176,689 $ 61,000 $ 9,000 $ 6,246,689 Reserve For Future Expenditure $ 4,560,533 $ - $ - $ 4,560,533 Total Requirements $ 10,737,222 $ 61,000 $ 9,000 $ 10,807,222 Exhibit B Police Levy Fund FY 2022 Revised Police Levy Fund Adopted Q1PD01 Q1PD04 Q1 Resources Beginning Fund Balance $ 322,952 $ 1,231 $ 12,205 $ 336,388 Property Taxes $ 2,063,142 $ - $ - $ 2,063,142 Franchise Fees $ - $ - $ - $ - Special Assessments $ - $ - $ - $ - Licenses&Permits $ - $ - $ - $ - Intergovernmental $ - $ - $ - $ - Charges for Services $ - $ - $ - $ Fines&Forfeitures $ - $ - $ - $ - Interest Earnings $ - $ - $ - $ - Miscellaneous $ - $ - $ - $ - Other Financing Sources $ - $ - $ - $ - Transfers In from Other Funds $ - $ - $ - S - Total Resources $ 2,386,094 $ 1,231 $ 12,205 $ 2,399,530 Requirements Community Development $ - $ - $ - $ Community Services $ 2,128,599 $ 1,231 $ 12,205 $ 2,142,035 Policy and Administration $ - $ - $ - $ - Public Works $ - $ - $ - $ - Program Expenditures Total $ 2,128,599 $ 1,231 $ 12,205 $ 2,142,035 Debt Service $ - $ - $ - $ - Loan to TCDA $ - $ - $ - $ - Work-In-Progress $ - $ - $ - $ - Transfers to Other Funds $ - $ - $ - $ - Contingency $ - $ - $ - $ - Total Budget $ 2,128,599 $ 1,231 $ 12,205 $ 2,142,035 Reserve For Future Expenditure $ 257,495 $ - $ - $ 257,495 Total Requirements $ 2,386,094 $ 1,231 $ 12,205 $ 2,399,530 Exhibit B Criminal Forfeiture Fund FY 2022 Revised Criminal Forfeiture Fund Adopted Q1PD03 Qi Resources Beginning Fund Balance $ 570,840 $ 24,275 $ 595,115 Property Taxes $ - $ - $ - Franchise Fees S - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines&Forfeitures $ 101,289 $ - $ 101,289 Interest Earnings $ - $ - $ - Miscellaneous S - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds S - S - $ - Total Resources $ 672,129 $ 24,275 $ 696,404 Requirements Community Development $ - $ - $ - Community Services $ 362,719 $ 24,275 $ 386,994 Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ 362,719 $ 24,275 $ 386,994 Debt Service S - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds S 16 $ - $ 16 Contingency $ - $ - $ - Total Budget $ 362,735 $ 24,275 $ 387,010 Reserve For Future Expenditure $ 309,394 $ - $ 309,394 Total Requirements $ 672,129 $ 24,275 $ 696,404 Exhibit B Parks Capital Fund FY 2022 Revised Parks Capital Fund Adopted Q1PW06 Q1PW07 Q1PW09 QI Resources Beginning Fund Balance $ 650,000 $ - $ - $ - $ 650,000 Property Taxes $ - $ - $ - S - S - Franchise Fees $ - $ - $ - $ - $ - Special Assessments $ - $ - $ - S - S - Licenses&Permits $ - $ - S - S - $ Intergovernmental $ 151,945 $ - $ - S - S 151,945 Charges for Services $ - $ - $ - $ - $ - Fines&Forfeitures $ - S - 5 - $ - $ - Interest Earnings $ - $ - $ - $ $ - Miscellaneous $ - $ - $ - $ - $ - Other Financing Sources $ - $ - $ - $ - $ - Transfers In from Other Funds 5 8,977,500 $ 46,000 $ 64,500 $ 26,500 5 9,114,50O Total Resources $ 9,779,445 $ 46,000 $ 64,500 $ 26,500 $ 9,916,445 Requirements Community Development $ $ - $ - S - S - Community Services $ - $ - S - S - $ - Policy and Administration $ - $ - S - $ -- $ Public Works $ - $ - 5 - 5 - $ - Program Expenditures Total $ - $ - $ - $ - $ - Debt Service $ - $ - $ - $ - $ - Loan to TCDA $ - $ - $ - S - $ - Work-In-Progress $ 9,766,945 $ 46,000 $ 64,50() S 26,500 $ 9,903,945 Transfers to Other Funds $ - $ - $ - $ - $ - Contingency $ - $ - $ - $ - $ - Total Budget $ 9,766,945 $ 46,000 $ 64,500 $ 26,500 $ 9,903,945 Reserve For Future Expenditure $ 12,500 $ - $ - $ - $ 12,500 Total Requirements $ 9,779,445 $ 46,000 $ 64,500 $ 26,500 $ 9,916,445 Exhibit B Parks Utility Fund FY 2022 Revised Parks Utility Fund Adopted Q1PW05 QI Resources Beginning Fund Balance $ 2,079,743 $ 7,500 $ 2,087,243 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ 2,406,398 $ - $ 2,406,398 Intergovernmental $ - $ - $ - Charges for Services $ 90,750 $ - $ 90,750 Fines&Forfeitures $ - $ - $ - Interest Earnings $ 2,475 $ - $ 2,475 Miscellaneous S - $ - $ - Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 2,437,500 $ - $ 2,437,500 Total Resources $ 7,016,866 $ 7,500 $ 7,024,366 Requirements Community Development S - S - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 4,604,613 S - $ 4,604,613 Program Expenditures Total $ 4,604,613 $ - $ 4,604,613 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 105,402 $ 7,500 $ 112,902 Contingency $ 325,000 $ - $ 325,000 Total Budget $ 5,035,015 $ 7,500 $ 5,042,515 Reserve For Future Expenditure $ 1,981,851 $ - $ 1,981,851 Total Requirements $ 7,016,866 $ 7,500 $ 7,024,366 Exhibit B Parks SDC Fund FY 2022 Revised Parks SDC Fund Adopted Q1PW04 Q1PW06 Q1PW07 Q1PW09 Q1 Resources Beginning Fund Balance $ 7,798,824 $ 86,000 $ 46,000 $ 64,500 $ 26,500 $ 8,021,824 Property Taxes $ - $ - $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - $ - $ - Special Assessments $ - $ - $ - $ - $ - $ - Licenses&Permits $ 1,495,466 $ - $ - $ - $ - $ 1,495,466 Intergovernmental $ - $ - $ - $ - $ - $ - Charges for Services $ - $ - $ - $ - $ - $ - Fines&Forfeitures $ - $ - $ - $ - $ - $ - Interest Earnings $ 158,325 $ - $ - $ - $ - $ 158,325 Miscellaneous $ - $ - $ $ - $ - $ - Other Financing Sources $ - $ - $ $ - $ - $ - Transfers In from Other Funds $ 180,000 $ - $ - $ - $ - $ 180,000 Total Resources $ 9,632,615 $ 86,000 $ 46,000 $ 64,500 $ 26,500 $ 9,855,615 Requirements Community Development S $ - $ $ - $ - S - Community Services S - $ - $ - S - $ - $ - Policy and Administration S - $ - $ - $ - $ - $ - Public Works $ - $ - $ - $ - $ - $ - Program Expenditures Total $ - $ - $ - $ - $ - $ - Debt Service $ - $ - $ - $ - $ - $ - Loan to TCDA $ - $ - $ - $ - S - $ - Work-In-Progress $ - $ - $ - $ - S - $ - Transfers to Other Funds S 5,509,700 $ 86,000 $ 46,000 $ 64,500 $ 26,500 $ 5,732,700 Contingency $ - $ - $ - $ - $ - $ - Total Budget $ 5,509,700 $ 86,000 $ 46,000 $ 64,500 $ 26,500 $ 5,732,700 Reserve For Future Expenditure $ 4,122,915 $ - $ - $ - $ - $ 4,122,915 Total Requirements $ 9,632,615 $ 86,000 $ 46,000 $ 64,500 $ 26,500 $ 9,855,615 Exhibit B Facilities Capital Projects Fund FY 2022 Revised Facilities Capital Projects Fund Adopted Q1PW05 Q1 Resources Beginning Fund Balance $ 1,375,150 $ - $ 1,375,150 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ - $ - $ - Fines&Forfeitures $ - $ - $ - Interest Earnings $ 14,175 $ - $ 14,175 Miscellaneous $ - $ - $ - Other Financing Sources $ 25,298,270 $ - $ 25,298,270 Transfers In from Other Funds $ 7,450,000 $ 25,000 $ 7,475,000 Total Resources $ 34,137,595 $ 25,000 $ 34,162,595 Requirements Community Development $ S - $ - Community Services S - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA S - $ - $ Work-In-Progress $ 32,648,270 $ 25,000 $ 32,673,270 Transfers to Other Funds 5 45 $ - $ 45 Contingency $ - $ - $ - Total Budget $ 32,648,315 $ 25,000 $ 32,673,315 Reserve For Future Expenditure $ 1,489,280 $ - $ 1,489,280 Total Requirements $ 34,137,595 $ 25,000 $ 34,162,595 Exhibit B Transportation CIP Fund FY 2022 Revised Transportation CIP Fund Adopted QIPW10 Q1PW11 Q1 Resources Beginning Fund Balance $ 1,947,526 $ - $ - $ 1,947,526 Property Taxes $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - Special Assessments $ - $ - $ - $ - Licenses&Permits $ - $ - $ - $ - Intergovernmental $ 1,864,279 $ - $ 217,160 $ 2,081,439 Charges for Services $ - $ - $ - $ - Fines&Forfeitures $ - $ - $ - $ - Interest Earnings $ - $ - $ - $ - Miscellaneous $ - $ - $ - $ - Other Financing Sources $ - $ - $ - $ - Transfers In from Other Funds $ 11,180,221 $ 51,500 $ 9,000 $ 11,240,721 Total Resources $ 14,992,026 $ 51,500 $ 226,160 $ 15,269,686 Requirements Community Development $ - $ - $ - $ - Community Services $ - $ - $ - $ - Policy and Administration $ - $ - $ - $ Public Works $ - $ - $ - $ - Program Expenditures Total $ - $ - $ - $ - Debt Service $ - $ - $ - $ - Loan to TCDA $ - $ - $ - $ - Work-In-Progress $ 13,269,500 $ 51,500 $ 226,160 $ 13,547,160 Transfers to Other Funds $ - $ - $ - $ - Contingency $ - $ - $ - $ - Total Budget $ 13,269,500 $ 51,500 $ 226,160 $ 13,547,160 Reserve For Future Expenditure $ 1,722,526 $ - $ - $ 1,722,526 Total Requirements $ 14,992,026 $ 51,500 $ 226,160 $ 15,269,686 Exhibit B Transportation SDC Fund FY 2022 Revised Transportation SDC Fund Adopted Q1PW10 Q1 Resources Beginning Fund Balance $ 6,489,549 $ 51,500 $ 6,541,049 Property Taxes $ - $ $ Franchise Fees $ - $ - S - Special Assessments $ - $ - S Licenses&Permits $ 701,855 $ - S 71)1,855 Intergovernmental $ - $ - S - Charges for Services $ - $ - $ - Fines&Forfeitures $ - $ - S - Interest Earnings $ 108,000 $ - S 11)8,000 Miscellaneous $ - $ - S Other Financing Sources $ - $ - $ Transfers In from Other Funds $ 104,700 S - $ 1(14,7(10 Total Resources $ 7,404,104 $ 51,500 $ 7,455,604 Requirements Community Development $ $ - $ Community Services $ - $ - S - Policy and Administration S - $ - S Public Works $ - $ S Program Expenditures Total $ - $ - $ - Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 5,484,140 $ 51,500 $ 5,535,640 Contingency $ - $ - $ - Total Budget $ 5,484,140 $ 51,500 $ 5,535,640 Reserve For Future Expenditure $ 1,919,964 $ - $ 1,919,964 Total Requirements $ 7,404,104 $ 51,500 $ 7,455,604 Exhibit B Sanitary Sewer Fund FY 2022 Revised Sanitary Sewer Fund Adopted Q1PW05 Q1 Resources Beginning Fund Balance $ 7,592,586 $ 3,300 $ 7,595,886 Property Taxes $ - $ - $ Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses&Permits $ 92,200 $ - $ 92,200 Intergovernmental $ - $ - $ - Charges for Services $ 3,412,921 $ - $ 3,412,921 Fines&Forfeitures $ - $ - $ - Interest Earnings $ 82,725 $ - $ 82,725 Miscellaneous $ 42,100 $ S 42,100 Other Financing Sources $ - $ - S - Transfers In from Other Funds S - $ - S Total Resources $ 11,222,532 $ 3,300 $ 11,225,832 Requirements Community Development $ - $ - S Community Services S - $ - $ - Policy and Administration $ - $ - S - Public Works $ 2,654,197 $ - $ 2,654,197 Program Expenditures Total $ 2,654,197 $ - $ 2,654,197 Debt Service S - $ - $ - Loan to TCDA S - $ - $ - Work-In-Progress S 100,000 $ - $ 100,000 Transfers to Other Funds $ 1,463,846 $ 3,300 $ 1,467,146 Contingency $ 200,000 $ - $ 200,000 Total Budget $ 4,418,043 $ 3,300 $ 4,421,343 Reserve For Future Expenditure $ 6,804,489 $ - $ 6,804,489 Total Requirements $ 11,222,532 $ 3,300 $ 11,225,832 Exhibit B Stormwater Fund FY 2022 Revised Stormwater Fund Adopted Q1PW05 Q1PW08 Q1 Resources Beginning Fund Balance $ 7,636,541 $ 5,700 $ 28,000 $ 7,670,241 Property Taxes S - $ - S S - Franchise Fees $ - $ - S - 5 - Special Assessments $ - $ - S - $ - Licenses&Permits $ - $ - $ - $ - Intergovernmental $ - $ - $ - $ - Charges for Services $ 5,653,512 $ - $ - $ 5,653,512 Fines&Forfeitures $ - $ - S - $ - Interest Earnings $ 104,925 $ - S - $ 104,925 Miscellaneous $ 5,000 $ - S - $ 5,000 Other Financing Sources S - $ - $ - S - Transfers In from Other Funds $ 1,395,000 $ - $ $ 1,395,000 Total Resources $ 14,794,978 $ 5,700 $ 28,000 $ 14,828,678 Requirements Community Development $ - $ S - S - Community Services $ - $ - S - $ Policy and Administration $ - $ - $ - $ - Public Works $ 3,828,774 $ - $ - $ 3,828,774 Program Expenditures Total $ 3,828,774 $ - $ - $ 3,828,774 Debt Service $ - $ - $ - $ - Loan to TCDA $ - $ - $ - $ - Work-In-Progress $ 4,777,500 $ - $ 28,000 $ 4,805,500 Transfers to Other Funds $ 347,528 $ 5,700 $ - $ 353,228 Contingency S 275,000 $ - $ - 5 275,000 Total Budget $ 9,228,802 $ 5,700 $ 28,000 $ 9,262,502 Reserve For Future Expenditure $ 5,566,176 $ - $ - $ 5,566,176 Total Requirements $ 14,794,978 $ 5,700 $ 28,000 $ 14,828,678 Exhibit B Water Fund FY 2022 Revised Water Fund Adopted Q1PW01 Q1PW02 Q1PW03 Q1PW05 Q1 Resources Beginning Fund Balance $ 37,914,231 $ 94,000 $ 15,400 $ 36,000 $ 8,500 $ 38,068,131 Property Taxes S - $ - S S - S - $ - Franchise Fees S - $ - S - S - S - $ - Special Assessments $ - $ - $ - S - $ - $ - Licenses&Permits $ - $ - $ $ S - $ - Intergovernmental $ - $ - S - S $ - $ - Charges for Services $ 26,197,790 $ - S - S - $ - $ 26,197,790 Fines&Forfeitures $ - $ - $ - $ - $ - $ - Interest Earnings $ 375,525 $ - $ - $ - S - $ 375,525 Miscellaneous $ 50,000 $ - S S - S - $ 50,000 Other Financing Sources S - $ - $ S - S - $ - Transfers In from Other Funds S 25,000 $ - $ - S S - $ 25,000 Total Resources $ 64,562,546 $ 94,000 $ 15,400 $ 36,000 $ 8,500 $ 64,716,446 Requirements Community Development S - $ S - S S - S - Community Services $ - $ - $ - S - $ - $ - Policy and Administration $ - $ - $ $ $ $ - Public Works $ 10,646,000 $ 94,000 $ 15,400 $ S - S 10,755,400 Program Expenditures Total $ 10,646,000 $ 94,000 $ 15,400 $ - $ - $ 10,755,400 Debt Service $ - $ - S - $ - $ - $ - Loan to TCDA $ - $ - $ - $ - $ - $ - Work-In-Progress S 25,000 $ - $ - $ - $ - $ 25,000 Transfers to Other Funds $ 22,320,789 $ - $ - $ 36,000 $ 8,500 $ 22,365,289 Contingency $ 475,000 $ - $ - $ - $ - $ 475,000 Total Budget $ 33,466,789 $ 94,000 $ 15,400 $ 36,000 $ 8,500 $ 33,620,689 Reserve For Future Expenditure $ 31,095,757 $ - $ - $ - $ - $ 31,095,757 Total Requirements $ 64,562,546 $ 94,000 $ 15,400 $ 36,000 $ 8,500 $ 64,716,446 Exhibit B Water CIP Fund FY 2022 Revised Water CIP Fund Adopted Q1PW03 Q1 Resources Beginning Fund Balance $ 1,850,125 $ - $ 1,850,125 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 $ 15,090,000 $ 36,000 $ 15,126,000 Total Resources $ 16,940,125 $ 36,000 $ 16,976,125 Requirements Community Development $ S - S - Community Services $ - S - $ - Policy and Administration $ - $ - $ Public Works $ - $ - $ Program Expenditures Total $ - $ - $ - Debt Service $ - $ - S - Loan to TCDA $ - $ - $ - Work-In-Progress $ 15,090,000 $ 36,000 $ 15,126,000 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ - Total Budget $ 15,090,000 $ 36,000 $ 15,126,000 Reserve For Future Expenditure $ 1,850,125 $ - $ 1,850,125 Total Requirements $ 16,940,125 $ 36,000 $ 16,976,125 Exhibit B PW Engineering Fund FY 2022 Revised Public Works Engineering Fund Adopted Q1PW01 Q1PW12 Q1 Resources Beginning Fund Balance $ 2,155,989 $ 35,000 $ 70,000 $ 2,260,989 Property Taxes S - $ - S - $ - Franchise Fees $ - $ - S - $ - Special Assessments $ - $ - S - $ - Licenses&Permits $ 870,000 $ - $ - $ 870,000 Intergovernmental $ 153,369 $ - $ - $ 153,369 Charges for Services $ 3,420,918 $ - $ - $ 3,420,918 Fines&Forfeitures $ - $ - S - $ - Interest Earnings $ - $ - S - $ - Miscellaneous $ 5,094 $ - S - $ 5,094 Other Financing Sources $ - $ $ - $ - Transfers In from Other Funds $ 667,710 $ $ $ 667,710 Total Resources $ 7,273,080 $ 35,000 $ 70,000 $ 7,378,080 Requirements Community Development S - $ $ S - Community Services $ - $ - S - $ Policy and Administration $ - $ - $ - $ - Public Works $ 4,586,633 $ 35,000 $ 70,000 $ 4,691,633 Program Expenditures Total $ 4,586,633 $ 35,000 $ 70,000 $ 4,691,633 Debt Service $ - S - S - S Loan to TCDA $ - $ - 5 5 - Work-In-Progress $ - $ - $ - $ - Transfers to Other Funds $ - $ - S - $ - Contingency $ 150,000 $ - S - S 150,000 Total Budget $ 4,736,633 $ 35,000 $ 70,000 $ 4,841,633 Reserve For Future Expenditure $ 2,536,447 $ - $ - $ 2,536,447 Total Requirements $ 7,273,080 $ 35,000 $ 70,000 $ 7,378,080 Exhibit B Central Services Fund FY 2022 Revised Central Services Fund Adopted Q1CM01 Q1CM02 QIFIS01 Q1FIS02 Q1FIS03 QIFISO4 Q1 Resources Beginning Fund Balance $ 2,821,865 $ - $ - $ - $ 284,000 $ 31,000 $ - $ 3,136,865 Property Taxes $ - $ - $ - $ - $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - $ - S - $ - $ - Special Assessments $ - $ - $ - S - S - S - $ - $ - Licenses&Permits $ - $ - $ - S - S - S - $ - $ - Intergovernmental $ - $ - $ - $ - $ - $ - $ - $ - Charges for Services $ 12,428,617 $ - $ - $ - $ - $ - $ - $ 12,428,617 Fines&Forfeitures $ - $ - $ - S - 5 - S - $ - $ - Interest Earnings $ - $ - $ - S - $ S - $ - $ - Miscellaneous S 90,000 $ - $ - S 5 - S - $ - $ 90,000 Other Financing Sources $ - $ - $ - $ - $ - S $ - $ - Transfers In from Other Funds $ 1,025,710 $ - $ - $ - $ - $ S - $ 1,025,710 Total Resources $ 16,366,192 $ - $ - $ - $ 284,000 $ 31,000 $ - $ 16,681,192 Requirements Community Development $ - $ - $ - $ - $ - $ - $ - $ - Community Services $ - $ - $ - $ - $ - $ - $ - $ - Policy and Administration 5 14,537,452 $ 50,000 $ 62,500 $ 19,300 $ 284,000 $ 31,000 S 42,000 $ 15,026,252 Public Works 5 - $ - 5 - 5 - $ - S - S - $ - Program Expenditures Total $ 14,537,452 $ 50,000 $ 62,500 $ 19,300 $ 284,000 $ 31,000 $ 42,000 $ 15,026,252 Debt Service $ - $ - $ - $ - $ - $ - $ - S - Loan to TCDA $ - S - 5 - $ - $ - 5 - 5 - $ - Work-In-Progress $ - $ - S - $ - $ - S - S - $ - Transfers to Other Funds $ - $ - $ - $ - $ - $ - $ - $ - Contingency $ 500,000 $ (50,000) $ (62,500) $ (19,300) $ - $ - $ (42,000) $ 326,200 Total Budget $ 15,037,452 $ - $ - $ - $ 284,000 $ 31,000 $ - $ 15,352,452 Reserve For Future Expenditure $ 1,328,740 $ - $ - $ - $ - $ - $ - $ 1,328,740 Total Requirements $ 16,366,192 $ - $ - $ - $ 284,000 $ 31,000 $ - $ 16,681,192 FY 2021-22 First Quarter Supplemental Budget Exhibit C CIP 96055-Risk and Resilience Assessment and Emergency Response Plan Project Need:Section 2013 of America's Water Infrastructure Action of 2018(AWIA)requires community water systems that serve more than 3,300 people to complete a risk and resilience assessment and develop an emergency response plan.Based on these regulations,the City of Tigard must conduct a risk and resilience assessment and submit certification of its completion to the U.S.EPA by December 31,2020.In addition,the city must also develop an emergency response plan and certify completion to the U.S.EPA by June 30,2021. Project Description:Complete a risk and resilience assessment and develop an emergency response plan. Adopted Revised Revised Revised Revised Revised Revised Actuals Budget This Budget Projected I Projected Projected Projected Projected Projected Projected Projected Projected Projected Project through FY2021 FY 2022 ' Change FY 2022 2023 2023 2024 2024 2025 2025 2026 2026 2027 2027 Total Internal Expenses Design and Engineering - - - - - - - - Project Management 22,643 7,000 7,000 - - - 29,643 Construction Management - - - - - - - - Total 22,643 - 7,000 7,000 - - - - - - - - - - 29,643 a -. _ — - _ • -- External Expenses Public Involvement - - - - - - - - Land/Right of Way Acquisition - - - - - - - - Design and Engineering 90,880 29,000 29,000 - - - - - - 119,880 Environmental Permit Comp. - Construction - - - - - Contingency I 119,880 Total 90,880 29,000 29,000 - - - - - - - - - I Total Project Expense 113,523 - - - - - - - 149,523 P I I 36,0001 36,0001 � I 1 I I I Revenue Funding Source 530-Water Fund 113,523 36,000 36,000 - - - 149,523 Other Revenue Source - - - - - - -• - Total Project Revenues 113,523 - 36,000 36,000 - - - - - - - - - 149,523 FY 2021-22 First Quarter Supplemental Budget Exhibit C CIP 92059 Universal Plaza Project Description:The Universal Plaza will provide an important public space amenity in downtown Tigard.It will be constructed on Town Center Development Agency-owned land and will provide a venue for large events like the Tigard Farmer's Market,Concerts in the Park,and Movies in the Park.The plaza may also feature a splash pad,interpretive artwork and installations,and a connection to the Fanno Creek Park. Adopted I Revised Revised Revised Revised Revised Revised Actuals Budget This Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project ;through FY2021 FY 2022 Change FY 2022 2023 2023 2024 2024 2025 2025 2026 2026 2027 2027 Total Internal Expenses Design and Engineering - _ - - - _ I - - Project Management 10,000 10,000 - - - 10,000 Construction Management - - - - - - - - Total - ! 10,000 - 10,000 - - - - - - - I - - - 10,000 External Expenses I I Public Involvement I - Land/Right of Way Acquisition 455,267 - - 1 - - I - - - 455,267 Design and Engineering 734,053 220,000 138,000 358,000 - - - .. - - 1,092,053 Environmental Permit Comp. 243,217 243,217 Construction 2,985,000 2,985,000 - - - 2,985,000 Contingency 1 190,000 190,000 - - - - - - 190,000 Total 1,432,537 3,395,000 138,0001 3,533,000 - - - - - - - - - i - 4,965,537 .1I•.- 1 i I I 1 I I I 1 Total Project Expense 1,432,537 1 3,405,000 j 138,000 1 3,543,000 I - 1 - I - 1 - I - 1 - I - I - I - I - I 4,975,537 Revenue Funding Source 425-Parks SDC Fund 617,722 1,571,000 86,000 1,657,000 - - - 2,274,722 Other Revenue Source - - - - - - - 940-Urban Renewal Cap.Imp. 814,815 1,834,000 52,000 1,886,000 - - - - - - 2,700,815 Total Project Revenues 1,432,537 3,405,000 138,000 3,543,000 - - - - --> - - - - - 4,975,537 I FY 2021-22 First Quarter Supplemental Budget Exhibit C CIP 91023 Public Works Field Staff Work Area and Breakroom Project Description:This project will plan,design,and construct internal improvements to the existing Public Works building.It will add field staff workstations to the crew lunchroom,add additional office space to the front area,and take advantage of unused front counter space. Adopted r Revised I Revised J Revised 1 Revised Revised Revised Actuals Budget This Budget Projected Projected Projected I Projected Projected Projected Projected Projected Projected Projected Project through FY2021 FY 2022 I Change ' FY 2022 2023 2023 2024 2024 2025 ' 2025 2026 2026 2027 2027 Total Internal Expenses Design and Engineering - - - - - - - - Project Management - - - - Construction Management - - - - - - - - Total - - - - - _ - - - - F - - _- - - I - - External Expenses I s Public Involvement - - - - - - - - Land/Right of Way Acquisition i - - - - - - - - Design and Engineering 25,000 25,000 - - - - - - 25,000 Environmental Permit Comp. 1 - Construction 100,000 I 100,000 - - - 100,000 • Contingency - - - - - - - - Total - 100,000 25,000 125,000 - - - - - - - - - - 125,000 I 1 1 I ! I 1 I 1 I T Total Project Expense - ! 100,000 25,000 125,000 I - - - - I - 1 - I - 1 - I 125,000 I Revenue Funding Source 270-Parks Utility Fund 30,000 7,500 37,500 - - - 37,500 500-Sanitary Sewer Fund 13,000 3,300 16,300 - - - - - 16,300 510-Stormwater Fund 23,000 5,700 28,700 1 28,700 530-Water Fund 34,000 8,500 42,500 - - - - - I - 42,500 Other Revenue Source Total Project Revenues - 100,000 25,000 125,000 - - - - - - - - I - 125,000 1 FY 2021-22 First Quarter Supplemental Budget Exhibit C CIP 92016-08 Dirksen Nature Park -Off-Street Parking Lot Project Description:Construction of a parking lot adjacent to Tigard Street.Amenities include a 5-foot wide perimeter sidewalk,landscaping,irrigation,and lighting. Adopted i Revised Revised ' Revised I Revised Revised ' Revised Actuals Budget This Budget Projected Projected Projected Projected Projected ! Projected Projected Projected Projected Projected Project through FY2021i FY 2022 Change I FY 2022 2023 2023 2024 2024 2025 2025 2026 2026 2027 2027 Total Internal Expenses 1 1 i 1 Design and Engineering - - - - - Project Management 19,032 40,000 40,000 - - - 59,032 Construction Management .. - - - - - - Total 19,032 40,000 - 40,000 - - - - - - - - - - 59,032 -‹ ®--® External Expenses Public Involvement - - - - - - - - Land/Right of Way Acquisition - - - - - - - - Design and Engineering 15,000 46,000 61,000 - - - - - - 61,000 Environmental Permit Comp. - Construction 310,000 310,000 - - - 310,000 Contingency 40,000 Total 365,000 46,000 40,000 - 40,000 411,000 - - - - - - - - -.sm..-- - 411,000 1 i i I 1 I I i Total Project Expense 19,032 I 405,000 1 46,000 ! 451,000 1 - - - - I - - I - - - I 470,032 Revenue Funding Source 425-Parks SDC Fund 19,032 405,000 46,000 ' 451,000 - - - 470,032 Other Revenue Source - - - - - - - - Total Project Revenues 19,032 405,000 46,000 451,000 - - - - - - - - - - 470,032 7 1 FY 2021-22 First Quarter Supplemental Budget Exhibit C CIP 92016-13 Dirksen Nature Park-Wetland Boardwalk and Walkway Project Description:The elevated wetland boardwalk will be centrally located in the park extending from the Fanno Creek Trail into the Fanno Greenway floodplain.The boardwalk surface will consist of galvanized steel grating.The walkway will be an 8-foot-wide hard surface pathway from Summer Creek Bridge at Fowler Middle School to the Fanno Creek Trail.The walkway and boardwalk will be Americans with Disabilities Act(ADA)accessible. Adopted Revised Revised Revised Revised Revised Revised Actuals Budget This Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project through FY2021 FY 2022 Change FY 2022 2023 2023 2024 2024 2025 2025 2026 2026 2027 2027 Total Internal Expenses Design and Engineering - - - - - - - - Project Management 47,964 20,000 I 20,000 - - - 67,964 Construction Management - _ - - - - - - - Total 47,964 20,000 - 20,000 - - - - - - - - - - 67,964 External Expenses Public Involvement - - - - - - - - Land/Right of Way Acquisition - - - - - - - - Design and Engineering 191,989 5,000 37,000 42,000 - - - - - - 233,989 Environmental Permit Comp. - Construction 20,233 310,000 27,500 337,500 - - - 357,733 Contingency 20,000 20,000 - - - - - - 20,000 Total 212,222 335,000 64,500 399,500 - - - - - - - - - - 611,722 I I I I I I Total Project Expense 260,186 355,000 64,500 419,500 I - - I - - I - - 679,686 Revenue Funding Source 425-Parks SDC Fund 260,186 355,000 64,500 419,500 - - - 679,686 Other Revenue Source 1 - - - _ - - Total Project Revenues 260,186 355,000 64,500 1 419,500 - - - 1 - - - - - - - 679,686 FY 2021-22 First Quarter Supplemental Budget Exhibit C CIP 94048 Oak Street Property Acquisition Project Description:The acquisition of this property is identified in the City's Stormwater Master Plan(Project ID:CIP 106). The home that sits on the property is dangerously close to Ash Creek and the streambank adjacent to the house has been eroding. Additional floodplain storage is needed at this location to slow runoff from upstream development and help reduce downstream erosion. The project will include the demolition of the existing house and provide native planting at the property. Future work(separate CIP)will include restoration and excavation within the floodplain to add more floodplain storage. Adopted Revised Revised ! Revised Revised Revised Revised Actuals Budget This Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project 'through FY2021 FY 2022 Change FY 2022 2023 2023 2024 2024 2025 2025 2026 2026 2027 2027 Total Internal Expenses Design and Engineering - - I - - - - ' - - Project Management 23,300 10,000 10,000 - - - 33,300 Construction Management - - - - - - - - Total 23,300 j 10,000 - 10,000 - - - - - - - j - - - 33,300 External Expenses Public Involvement ' - - - - - - - - Land/Right of Way Acquisition 281,713 - - - - - - - 281,713 Design and Engineering 22,056 - - - - - - - 22,056 Environmental Permit Comp. Construction 70,000 28,000 98,000 - - - 98,000 Contingency 10,000 10,000 - - - - - - 10,000 Total 303,769 80,000 28,000 108,000 - - - - _ - - - - - - 411,769 Total Project Expense 327,069 90,000' 28,000 118,000 - - - - - , - - - - - 445,069 • Revenue Funding Source 510-Stormwater Fund 327,069 90,000 28,000 118,000 - - - 445,069 Other Revenue Source - - - - - - - - Total Project Revenues 327,069 90,000 28,000 118,000 - - - - - - - - - - 445,069 I 1 FY 2021-22 First Quarter Supplemental Budget Exhibit C CIP 92056 Park System Master Plan Update Project Description:The Park System Master Plan Update will examine existing parks system 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 include a conditions assessment and prioritize the needs and desires for upgrading and creating new facilities and services. Adopted Revised Revised Revised 1 Revised Revised ' Revised Actuals Budget This Budget Projected Projected Projected Projected Projected ' Projected Projected Projected Projected Projected Project through FY2021 FY 2022 Change FY 2022 2023 2023 2024 2024 2025 2025 2026 i 2026 2027 2027 Total Internal Expenses Design and Engineering - - - - Project Management 67,086 3,000 3,000 - - - 70,086 Construction Management r - - - - - - - - Total 67,086 3,000 - 3,000 - - - - - - - - - - 70,086 e External Expenses Public Involvement - - - - - - - - Land/Right of Way Acquisition - - - - - - - - Design and Engineering 198,365 7,000 26,500 33,500 - - - - - - 231,865 Environmental Permit Comp. - Construction - - - - - Contingency - - - - - - - - Total 198,365 7,000 26,500 33,500 - - - - - - - - - - 231,865 1 I I I Total Project Expense 265,451 I 10,000 I 26,500 I 36,500 I - - I - J - F - [ - I - I - I 301,951 Revenue Funding Source 425-Parks SDC Fund 265,451 10,000 26,500 36,500 - - - 301,951 Other Revenue Source - - - - - - - - Total Project Revenues 265,451 10,000 26,500 36,500 I - - I - j 301,951 s 1 I I FY 2021-22 First Quarter Supplemental Budget Exhibit C CIP 95063 Transportation System Plan Update Project Description:Conduct appropriate community,traffic,and multi-modal transportation analysis.Prepare a draft plan,hold public meetings and hearings, and obtain city council adoption of the final plan. Adopted I Revised Revised 1 Revised Revised Revised Revised Actuals Budget This Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project through FY2021 FY 2022 Change FY 2022 2023 2023 2024 2024 2025 2025 2026 2026 2027 2027 Total Internal Expenses Design and Engineering - 1 - - - - - - - Project Management 10,241 10,000 10,000 1 - - - 20,241 Construction Management - - - - - - - - - Total 10,241 10,000 - 10,000 - - - - - - - - - - 20,241 External Expenses I , Public Involvement - - - - - - - - Land/Right of Way Acquisition - - - - - - - - Design and Engineering 208,366 47,500 51,500 99,000 - - - - - - 307,366 Environmental Permit Comp. - Construction - - - - - Contingency - - - - - - - - Total 208,388 47,500 51,500 99,000 - - - - - - - - - - 307,366 I 1 I I I I I I I I 1 Total Project Expense 218,607 57,500 I 51,500 109,000 I - I - I - I - I 327,607 Revenue Funding Source l 200-Gas Tax Fund 36,829 - - - - 36,829 415-Transportation SDC Fund 181,778 57,500 51,500 109,000 - - - - - - 290,778 Other Revenue Source - - - - - - - - Total Project Revenues 218,607 57,500 51,500 109,000 - - - - - - - - - - 327,607 a -- ► - FY 2021-22 First Quarter Supplemental Budget Exhibit C CIP 95065 Pacific Highway Street Lights Project Description:Install street lights at unlit quadrants of intersections where they do not already exist along Pacific Highway through the City of Tigard. Intersections include 72nd Avenue,Main Strcct/Johnaon Street,McKenzie Street,School Street,Wal�.n St eet,Frewing Street,Garrett Street,Park Street,Royalty Parkway,Durham Road,and Bull Mountain Road.Some lights will be added to existing signals and power poles,some will require new poles. Adopted Revised Revised 1 Revised Revised Revised Revised Actuals Budget This Budget Projected Projected Projected Projected Projected j Projected Projected Projected Projected Projected Project through FY2021 FY 2022 Change FY 2022 2023 2023 2024 2024 2025 2025 2026 2026 2027 I 2027 Total Internal Expenses 11 1 I Design and Engineering I - - I - - - - - Project Management 32,378 30,000 30,000 - - - 62,378 Construction Management - - - - - - - - Total 32,378 30,000 - 30,000 - , - - - - - - - - - 62,378 External Expenses i 1 Public Involvement - - I - - - - 1 - - Land/Right of Way Acquisition 102,000 102,000 i - - - - - - 102,000 Design and Engineering 88,500 52,000 124,160 176,160 - - - - - - 264,660 Environmental Permit Comp. I - Construction 672,000 672,000 - ' - j - 672,000 Contingency 41,000 41,000 j - J - - - - - 41,000 Total 88,500 j 765,000 226,160 991,160 - - - - - - - - - - 1,079,660 1 I 1 I 1 I I I I I 1 Total Project Expense 1 120,878 I 795,000 j 226,160 1 1,021,160 I - j - I - I - I - - I - - I - J - I 1,142,038 Revenue Funding Source 200-Gas Tax Fund 40,038 170,800 9,000 179,800 - - - 219,838 - I1 Other Revenue Source - - I - - - - - - State Fund Local Project 80,840 624,200 217,160 841,360 - - 922,200 Total Project Revenues 120,878 1 795,000 226,160 1 1,021,160 - - - - - j - - j - - l - 1,142,038 1 I 1 FY 2021-22 First Quarter Supplemental Budget Exhibit C CIP 96055-Risk and Resilience Assessment and Emergency Response Plan Project Need:Section 2013 of America's Water Infrastructure Action of 2018(AWIA)requires community water systems that serve more than 3,300 people to complete a risk and resilience assessment and develop an emergency response plan.Based on these regulations,the City of Tigard must conduct a risk and resilience assessment and submit certification of its completion to the U.S.EPA by December 31,2020.In addition,the city must also develop an emergency response plan and certify completion to the U.S.EPA by June 30,2021. Project Description:Complete a risk and resilience assessment and develop an emergency response plan. Adopted Revised Revised Revised Revised Revised Revised Actuals Budget This Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected li Projected Project through FY2021 FY 2022 Change FY 2022 2023 2023 2024 2024 2025 2025 2026 2026 2027 2027 Total Internal Expenses I Design and Engineering - - - - - - - - Project Management 22,643 7,000 7,000 - - - 29,643 Construction Management - - - - - - - - _ Total 22,643 - 1 7,000 7,000 - - - - - - - - - - 29,643 External Expenses Public Involvement - - - - - - - - Land/Right of Way Acquisition - - - - - - - - Design and Engineering j 90,880 j 29,000 i 29,000 - - - - - - 119,880 Permit Peit Comp. - Construction - - - - - Contingency - - Total 90,880 - 29,000 1 29,000 - - - - - - - _ - - - 119,880 -- I i ! I I I I I I I I Total Project Expense I 113,523 1 - I 36,000 36,000 1 - I - I - - I - I - I - I - I - I - 1 149,523 Revenue Funding Source 530-Water Fund 113,523 1 36,000 36,000 - - - 149,523 Other Revenue Source - - - - - - - - Total Project Revenues 113,523 - 36,000 36,000 - i - - - - - - - - 149,523 1 -- - - ® - - - FY 2021-22 First Quarter Supplemental Budget Exhibit C CIP 92059 Universal Plaza Project Description:The Universal Plaza will provide an important public space amenity in downtown Tigard.It will be constructed on Town Center Development Agency-owned land and will provide a venue for large events like the Tigard Farmer's Market,Concerts in the Park,and Movies in the Park.The plaza may also feature a splash pad,interpretive artwork and installations,and a connection to the Fanno Creek Park. Adopted Revised Revised Revised Revised Revised Revised Actuals Budget This Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project (through FY2021 FY 2022 Change FY 2022 2023 2023 2024 ' 2024 2025 1 2025 2026 2026 2027 2027 Total Internal Expenses Design and Engineering - 10,000 Project Management 10,000 10,000 Construction Management - - - - - - - Total - 10,000 - 10,000 - - - j - - - - - - - 10,000 External Expenses Public Involvement - - 1 - - - - - - Land/Right of Way Acquisition 455,267 - - - - - - - 455,267 Design and Engineering 734,053 220,000 138,000 358,000 - - - - - - 1,092,053 Environmental Permit Comp. 243,217 243.217 Construction 2,985,000 2,985,000 - - - 2,985,000 Contingency 190,000 190,000 - - - - - 190,000 Total 1,432,537 3,395,000 138,000 .. 3,533,000 - - - - - - - 4,965,537 1 I I I I I I Total Project Expense 1,432,537 I 3,405,000 I 138,000 I 3,543,000 I - - - - - 4,975,537 1 Revenue Funding Source 425-Parks SDC Fund 617,722 1,571,000 88,000 1,657,000 - - - 2,274,722 Other Revenue Source - - - - - - - - 940-Urban Renewal Cap.Imp. 814,815 1,834,000 52,000 1,886,000 - - - - - - 2,700,815 Total Project Revenues 1,432,537 j 3,405,000 138,000 3 543,000 - - - - - - r - - 4,975,537 FY 2021-22 First Quarter Supplemental Budget Exhibit C CIP 91023 Public Works Field Staff Work Area and Breakroom Project Description:This project will plan,design,and construct internal improvements to the existing Public Works building.It will add field staff workstations to the crew lunchroom,add additional office space to the front area,and take advantage of unused front counter space. Adopted Revised I Revised Revised Revised Revised Revised Actuals Budget This Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected I Projected Project through FY2021' FY 2022 Change FY 2022 2023 2023 2024 2024 2025 2025 2026 1 2026 2027 2027 Total Internal Expenses � I Design and Engineering - - - - - - - - Project Management - - - - - Construction Management - - - - - - - - Total - - - - - - - - - - - - - - - External Expenses Public Involvement - - - - - - - - Land/Right of Way Acquisition - - - - 1 - - - - Design and Engineering 25,000 25,000 - - - - - - 25,000 Environmental Permit Comp. - Construction 100,000 100,000 - - - 100,000 Contingency - - - - - - - - Total - 100,000 25,000 125,000 - - - - - - - - - - 125,000 1 I 1 I I I I 1 Total Project Expense - 100,000 25,000 1 125,000 1 - I - I - - I 125,000 Revenue Funding Source 270-Parks Utility Fund 30,000 7,500 37,500 - - - 37,500 500-Sanitary Sewer Fund 13,000 3,300 16,300 - - - - - - 16,300 510-Stormwater Fund 23,000 5,700 28,700 28,700 530-Water Fund 34,000 8,500 42,500 - - - - - - 42,500 Other Revenue Source - - - - - - - - Total Project Revenues - ' 100,000 25,000 125,000 - - - - - - - - - - 125,000 r FY 2021-22 First Quarter Supplemental Budget Exhibit C CIP 92016-08 Dirksen Nature Park -Off-Street Parking Lot Project Description:Construction of a parking lot adjacent to Tigard Street.Amenities include a 5-foot wide perimeter sidewalk,landscaping,irrigation,and lighting. Adopted Revised Revised Revised Revised Revised Revised Actuals Budget This Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project ,through FY2021', FY 2022 Change FY 2022 2023 2023 2024 2024 2025 2025 2026 2026 2027 2027 Total Internal Expenses Design and Engineering - - - - - - - - Project Management I 19,032 40,000 40,000 59,032 Construction Management - - - - - - - - Total' 19,032 . 40,000 - 40,000 - - - - - - - - - - 59,032 External Expenses Public Involvement - - - - - - - - Land/Right of Way Acquisition - - Design and Engineering 15,000 46,000 61,000 - - - - - - 61,000 Environmental Permit Comp. - Construction 310,000 310,000 - - - 310,000 Contingency 40,000 40,000 - • - - - - - 40,000 Total - 365,000 46,000. 411,000 - i - - - - - - - - - 411,000 I I 1 I 1 I I Total Project Expense 19,032 405,000 46,000 I 451,000 I - 1 - I - - I - - - - - - I 470,032 Revenue Funding Source 425-Parks SDC Fund 19,032 405,000 46,000 451,000 - - - 470,032 Other Revenue Source - - - - - - - Total Project Revenues 19,032 405,00046 000 451,000 - - - ' - - - - - - - 470,032 FY 2021-22 First Quarter Supplemental Budget Exhibit C CIP 92016-13 Dirksen Nature Park-Wetland Boardwalk and Walkway Project Description:The elevated wetland boardwalk will be centrally located in the park extending from the Fanno Creek Trail into the Fanno Greenway floodplain.The boardwalk surface will consist of galvanized steel grating.The walkway will be an 8-foot-wide hard surface pathway from Summer Creek Bridge at Fowler Middle School to the Fanno Creek Trail.The walkway and boardwalk will be Americans with Disabilities Act(ADA)accessible. Adopted ' Revised Revised Revised Revised Revised Revised Actuals Budget This Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected ! Projected Project through FY2021 FY 2022 Change I FY 2022 2023 ! 2023 2024 2024 2025 2025 2026 2026 2027 ! 2027 Total Internal Expenses •1 I Design and Engineering I - - - - - - I - - Project Management 47,964 , 20,000' 20,000 - - - I 67,964 Construction Management - _ - - - - - - - Total 47,964 20,000 - 20,000 - - - - - - - - - - 67,964 External Expenses j Public Involvement - - - - - - - - Land/Right of Way Acquisition - - - - - - - - Design and Engineering 191,989 5,000 37,000 42,000 - - - - - - 233,989 Environmental Permit Comp. Construction 20,233 310,000 27,500 337,500 - - - 357,733 Contingency 20,000 20,000 - - - - - - 20,000 Total 212,222 335,000 64,500 399,500 - - - - - - - - - - 611,722 1 I 1 I I I I- 1 Total Project Expense 260,186 I 355,000 I 64,500 1 419,500 1 - - I - _ - I - _ - I - i - I - 1 - I 679,686 Revenue Funding Source 425-Parks SDC Fund 260,186 355,000 64,500 419,500 - - - ! 679,686 Other Revenue Source - - - - 1 - - - - Total Project Revenues 260,186 355,000 64,500 419,500 - - - - - - - - - 679,686 FY 2021-22 First Quarter Supplemental Budget Exhibit C CIP 94048 Oak Street Property Acquisition Project Description:The acquisition of this property is identified in the City's Stormwater Master Plan(Project ID:CIP 106). The home that sits on the property is dangerously close to Ash Creek and the streambank adjacent to the house has been eroding. Additional floodplain storage is needed at this location to slow runoff from upstream development and help reduce downstream erosion. The project will include the demolition of the existing house and provide native planting at the property. Future work(separate CIP)will include restoration and excavation within the floodplain to add more floodplain storage. Adopted Revised Revised Revised Revised Revised Revised Actuals Budget This Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project through FY2021 FY 2022 Change FY 2022 2023 2023 2024 2024 2025 2025 2026 2026 2027 i 2027 Total Internal Expenses Design and Engineering Project Management 23,300 10,000 10,000 - - - I 33,300 Construction Management - - - - - - 1 - - Total 23,300 10,000 - 10,000 - - - - - - - - - ' - 33,300 External Expenses r ' Public Involvement - - - - - - - - Land/Right of Way Acquisition 281,713 - - - - - - - 281,713 Design and Engineering 22,056 - I - - - - - - 22,056 Environmental Permit Comp. 98,000 Construction 70,000 28,000 98,000 I - - Contingency 10,000 10,000 - - - - - - 10,000 Total 303,769 80,000 28,000 j 108,000 - - - - - - - - -.1 I - - � 411,769 _ Total Project Expense 327,069 - 90,000 L 28,000 118,000 1 - - - -----1 - - - I - ` - I 445,069 issRevenue Funding Source 510-Stormwater Fund 327,069 90,000 28,000 118,000 - - - 445.069 Other Revenue Source - - - - - - - - Total Project Revenues 327,069 90,000 28,000 118,000 - - - - - - - - - I - � 445,069 I - -- -t - _.0.- FY 2021-22 First Quarter Supplemental Budget Exhibit C CIP 92056 Park System Master Plan Update Project Description:The Park System Master Plan Update will examine existing parks system 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 include a conditions assessment and prioritize the needs and desires for upgrading and creating new facilities and services. i Adopted Revised Revised 1 Revised Revised ! Revised Revised Actuals Budget This Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project through FY2021 FY 2022 Change FY 2022 2023 2023 2024 2024 2025 I 2025 2026 2026 2027 2027 Total Internal Expenses F I I Design and Engineering - - - - - - - - Project Management 67,086 3,000 3,000 - - - 70,086 Construction Management - - - - - - - - Total 67,086 3,000 - 3,000 - - - - - - - - I - - 70,086 External Expenses Public Involvement - - Land/Right of Way Acquisition - - - - - - - - Design and Engineering 198,365 7,000 26,500 33,500 231,865 Environmental Permit Comp. - Construction - - - - - Contingency - - - - - - - - Total 198,365 7,000 26,500 33,500 - - - - - - - - I - - I 231,865 I I- I 1 1 Total Project Expense 265,451 10,000 j 26,500 36,500 I I - IT __� - - I - - I 301,951 Revenue Funding Source 425-Parks SDC Fund 265,451 10,000 26,500 36,500 - - - 301,951 Other Revenue Source - - - - - - _ - Total Project Revenues 265,451 10,000 26,500 36,500 - - - - - - - - I - - I 301,951 FY 2021-22 First Quarter Supplemental Budget Exhibit C CIP 95063 Transportation System Plan Update Project Description:Conduct appropriate community,traffic,and multi-modal transportation analysis.Prepare a draft plan,hold public meetings and hearings, and obtain city council adoption of the final plan. Adopted Revised Revised ' Revised 1 Revised Revised I Revised Actuals Budget This Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project through FY2021 FY 2022 Change FY 2022 2023 2023 2024 1 2024 2025 2025 2026 2026 2027 j 2027 Total Internal Expenses Design and Engineering - ' - - - - - - - Project Management 10,241 10,000 10,000 - - 20,241 Construction Management - - - - - - - - Total 10,241 10,0001 10,000 - _ 20,241 External Expenses Public Involvement Land/Right of Way Acquisition - - - - - - - - Design and Engineering 208,366 47,500 51,500 99,000 - - - - - - 307,366 Environmental Permit Comp. - Construction - - - - - Contingency - - - - - - - - Total 208,366 47,500� 51,500 99,000 o. 307,366 Total Project Expense 218,607 J 57,500 51,500 109,000 1 - - - I 1 - I - - I - - 327,607 Revenue Funding Source 200-Gas Tax Fund 36,829 - - - - 36,829 415-Transportation SDC Fund 181,778 57,500 51,500 109,000 - - - - - - 290,778 Other Revenue Source - - - - - - - - Total Project Revenues 218,607 57,500 51,500 109,000 - - - - - - - - - - I 327,607 I FY 2021-22 First Quarter Supplemental Budget Exhibit C CIP 95065 Pacific Highway Street Lights Project Description:Install street lights at unlit quadrants of intersections where they do not already exist along Pacific Highway through the City of Tigard. Intersections include 72nd Avenue, McKenzie Street,School Street,Walnut'StrcotC-___t,Frewing Street,Garrett Street,Park Street,Royalty Parkway,Durham Road,and Bull Mountain Road.Some lights will be added to existing signals and power poles,some will require new poles. Adopted Revised Revised Revised Revised Revised Revised Actuals Budget This Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project ,through FY2021 FY 2022 Change , FY 2022 2023 2023 2024 2024 2025 2025 2026 2026 2027 2027 Total Internal Expenses I ' Design and Engineering - - - - - - - - Project Management 32,378 30,000 30,000 - - - 62,378 Construction Management - - - - - - Total 32,378 30,000 - 30,000 - - 62,378 External Expenses Public Involvement - - - - - Land/Right of Way Acquisition 102,000 102,000 - - 102,000 Design and Engineering 88,500 52,000 124,160 176,160 - - - - - 264,660 Environmental Permit Comp. - Construction 672,000 672,000 - - - 672,000 Contingency 41,000 41,000 41,000 Total 88,500 765,000 226,160 991,160 - - - - - - - - - I 1,079,660 I I I I I I I Total Project Expense 120,878 I 795,000 I 226,160 1,021,160 - L 1,142,038 Revenue Funding Source 200-Gas Tax Fund 40,038 170,800 9,000 179,800 - - - 219,838 Other Revenue Source - - - - - - - State Fund Local Project 80,840 624,200 217,160 841,360 - - - - - - 922,200 Total Project Revenues 120,878 795,000 226,160 1,021,160 - - - - 1,142,038 A a. i I City Ol 1 1gard Respect and Care I Do the Right Thing I Get it Don FY 2021-2022 First Quarter Supplemental Budget September 28,2021as • TIGARD dpj City ofTigard Carryforwards/Technical Adjustment • Community Development • Police Department ► Economic Development Business ► Annual Ammunition Purchase Support Programs ► Traffic Unit Office Furniture ► Washington Square Regional Center • Public Works Operations Update Project Vehicles ► Tigard MADE project phase II 1 119th Automatic Transfer Switch • Finance and Information Services (Reservoir #2) Tech Adjustment of Risk Analyst, 0.20 ► Engineering Design and Construction FTE — Approved in FY21 Q3 Standards ► Tyler Project Implementation Carryforward City ofTigard PW Capital Improvement Plan (CIP) - Carryforwards Facilities: $25,000 • Stormwater: $28,000 CIP 91023 Public Works Field Staff Work Area and 1 CIP 94048 Oak Street Property Acquisition — Breakroom — $25,000 $28,000 Parks: $223,000 • Transportation: $227,660 CIP 92059 Universal Plaza — $86,000 ► CIP 95063 Transportation System Plan Update — / CIP 92016-08 Dirksen Nature Park - Off-Street $51,500. Parking Lot — $46,000 ► CIP 95065 Pacific Highway Street Lights — $226,16C CIP 92016-13 Dirksen Nature Park - Wetland • Water: $36,000 Boardwalk and Walkway — 64,500 CIP 96055 Risk and Resilience Assessment and CIP 92056 Park System Master Plan Update — Emergency Response Plan — $36,000 $26,500 City ofTigard • New Requests • City Management / Novak Consulting Group Recruitment for 2nd Asst. City Manager 1 Management Partners Financial Services • Community Development Launch Pod - Mobile Business Incubator • Finance and Information Services Verizon Connect - Fleet Management System • Police Department Patrol Vehicle Replacement City ofTigard Summary • The FY 2022 First Quarter Supplemental will increase the overall budget by $1.8M • No changes in reserves of the city (12lV1311 s S 0 nt) • ;MK/z!tap UL[[J opm.ayp oQ I a;ivo P' 33adsag AIS-4706 7. Business Meeting Meeting Date: 09/28/2021 Length(in minutes): 5 Minutes Agenda Title: TOWN CENTER DEVELOPMENT AGENCY-Public Hearing:Consider a Resolution Approving the First Quarter TCDA Budget Supplemental Presented By: Item Type: Motion Requested Resolution Public Hearing Public Hearing Yes Legal Ad Required?: Publication Date: 09/23/2021 Information ISSUE Submitting the Town Center Development Agency's FY 2022 First Quarter Budget Supplemental to the Board for review, consideration,and approval. STAFF RECOMMENDATION/ACTION REQUEST Finance recommends the Town Center Development Agency Board of Directors approve the FY 2022 First Quarter TCDA Budget Supplemental. KEY FACTS AND INFORMATION SUMMARY The following is the summary of items that require council action for FY 2022 First Quarter Budget Supplemental: •Carryforward of TIF Improvement Matching Grant Program funds—Carry forward$61,000 in unspent funds from FY 20-21 TCDA Budget for the TIF Improvement Program to fund three matching grants for facade/tenant improvements that were approved in FY20-21,but not completed,in some cases due to COVID-19. •CIP 92059 Universal Plaza—Carry forward$86,000 from prior year appropriations impacting Parks SDC Fund(425) and $52,000 from Urban Renewal Capital Improvement Fund(940). Construction did not start as scheduled;estimated cost requires the dollars remain available. OTHER ALTERNATIVES Do not approve the FY 2022 First Quarter TCDA Budget Supplemental. COUNCIL OR TCDA GOALS,POLICIES,MASTER PLANS DATES OF PREVIOUS CONSIDERATION This is the first consideration Fiscal Impact Cost: $199,000 Budgeted(yes or no): No Where Budgeted (department/program): N/A Additional Fiscal Notes: The FY 2022 First Quarter Supplemental will increase the overall budget by$199K. The increase in the expenditures is largely supported through unanticipated beginning fund balances. This supplemental will not change reserves of the city. Please refer to Exhibits A and B which summarize the fiscal impact of the quarterly supplemental budget by fund. Attachments FY22 Q1 TCDA-Resolution FY22 Q1 TCDA Supplemental Summary FY22 Q1 Exhibit A-TCDA FY22 Q1 Exhibit B-TCDA CITY OF TIGARD, OREGON TIGARD TOWN CENTER DEVELOPMENT AGENCY RESOLUTION NO. 21- A RESOLUTION TO ADOPT THE FY 2022 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 2022 budget was adopted;and WHEREAS,the TCDA recognizes approximately$199,000 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 2021-22 Budget is hereby amended Q1 Supplemental Summary Exhibit B. SECTION: This resolution is effective immediately upon passage. PASSED: This day of 2021. Chair-TCDA ATTEST: TCDA Recorder-TCDA RESOLUTION NO. 21- Page 1 TOWN CENTER DEVELOPMENT AGENCY- BUDGET SUPPLEMENTAL 9/14/2021 FY 2021-2022 Quarter: 1 Item# Department Fund Division Request Title Request Funding Total Amount Detailed Description Reason(if carry forward) Source QITCDA01 TCDA 940-City Center 9000-Urban Renewal Carryforward of TIF Improvement CARRYFORWA $ 61,000 Carry forward$61,000 in unspent funds from FY 20-21 TCDA Budget for the TIF Improvement Program to fund three matching grants for Capital Improvements Matching Grant Program funds RD facade/tenant improvements that were approved in FY20-21,but not completed,in some cases due to COVID-19. Q1TCDA02 TCDA 940-City Center 8000-CIP/Contingency CIP 92059 Universal Plaza CARRYFORWA $ 138,000 Carryforward$86,000 from prior year appropriations impacting Parks SDC Fund(425)and$52,000 from Urban Renewal Capital Capital Improvements RD Improvement Fund(940). Construction did not start as scheduled;estimated cost requires the dollars remain available. 1 oft Exhibit A Q1TCDA01 - Carryforward of TIF Improvement Matching Grant Program funds Carry forward $61,000 in unspent funds from FY 20-21 TCDA Budget for the TIF Improvement Program to fund three matching grants for facade/tenant improvements that were approved in FY20-21, but not completed, in some cases due to COVID-19. FY 2022 QI Revised City Center Capital Improvements Adopted Amendment Q1 Resources Beginning Fund Balance $ 2,312,600 $ 61,000 $ 2,373,600 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 $ 2,301,000 $ - $ 2,301,000 Total Resources $ 4,613,600 $ 61,000 $ 4,674,600 Requirements Community Development $ 215,000 $ 61,000 $ 276,000 Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ 215,000 $ 61,000 $ 276,000 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 4,373,000 $ - $ 4,373,000 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ - Total Budget $ 4,588,000 $ 61,000 $ 4,649,000 Reserve For Future Expenditure $ 25,600 $ - $ 25,600 Total Requirements $ 4,613,600 $ 61,000 $ 4,674,600 Exhibit A Q1TCDA02 - CIP 92059 Universal Plaza Carryforward $86,000 from prior year appropriations impacting Parks SDC Fund (425) and $52,000 from Urban Renewal Capital Improvement Fund (940). Construction did not start as scheduled; estimated cost requires the dollars remain available. FY 2022 Q1 Revised City Center Capital Improvements Adopted Amendment Q1 Resources Beginning Fund Balance $ 2,312,600 $ 52,000 $ 2,364,600 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 $ 2,301,000 $ 86,000 $ 2,387,000 Total Resources $ 4,613,600 $ 138,000 $ 4,751,600 Requirements Community Development $ 215,000 $ - $ 215,000 Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ - $ - $ - Program Expenditures Total $ 215,000 $ - $ 215,000 Debt Service $ - $ - $ - Loan to TCDA $ - $ - $ - Work-In-Progress $ 4,373,000 $ 138,000 $ 4,511,000 Transfers to Other Funds $ - $ - $ - Contingency $ - $ - $ - Total Budget $ 4,588,000 $ 138,000 $ 4,726,000 Reserve For Future Expenditure $ 25,600 $ - $ 25,600 Total Requirements $ 4,613,600 $ 138,000 $ 4,751,600 Exhibit B City Center Capital Improvements FY 2022 Revised City Center Capital Improvements Adopted Q1TCDA01 QITCDA02 Q1 Resources Beginning Fund Balance $ 2,312,600 $ 61,000 $ 52,000 $ 2,425,600 Property Taxes $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - Special Assessments $ - $ - S - $ - Licenses&Permits $ - $ - S - $ - Intergovernmental $ - $ - $ - $ Charges for Services S - $ - $ -- S - Fines&Forfeitures $ - $ - 5 - $ - Interest Earnings $ - $ - $ - $ - Miscellaneous $ - S - S - $ - Other Financing Sources S - S - $ - $ - Transfers In from Other Funds $ 2,301,000 $ - $ 86,000 $ 2,387,000 Total Resources $ 4,613,600 $ 61,000 $ 138,000 $ 4,812,600 Requirements TCDA $ 215,000 $ 61,000 $ - $ 276,000 Community Services $ - $ - $ - $ - Policy and Administration $ - $ - $ - $ - Public Works $ - $ - $ - $ - Program Expenditures Total $ 215,000 $ 61,000 $ - $ 276,000 Debt Service $ - $ - $ - $ - Loan to TCDA $ - $ - $ - $ - Work-In-Progress $ 4,373,000 $ - $ 138,000 $ 4,511,000 Transfers to Other Funds $ - $ - $ - $ - Contingency $ - $ - $ - $ - Total Budget $ 4,588,000 $ 61,000 $ 138,000 $ 4,787,000 Reserve For Future Expenditure $ 25,600 $ - $ - $ 25,600 Total Requirements $ 4,613,600 $ 61,000 $ 138,000 $ 4,812,600 AIS-4693 8. Business Meeting Meeting Date: 09/28/2021 Length(in minutes): 45 Minutes Agenda Title: Washington County LUT Briefing on MSTIP Work Plan Submitted By: Joanne Bengtson,City Management Presented By: Item Type: Update,Discussion,Direct Staff Public Hearing No Legal Ad Required?: Publication Date: Information ISSUE Council will receive a briefing from Washington County Staff on the next cycle of Major Streets Improvement Program(MSTIP) funds. STAFF RECOMMENDATION/ACTION REQUEST The team recommends Council receive the briefing and provide input to the Washington County team. KEY FACTS AND INFORMATION SUMMARY Washington County staff will share the work plan for allocating the next cycle of Major Streets Improvement Program(MSTIP) funds.MSTIP is funded by a countywide property tax and has been used to improve the transportation system since 1986.This work plan will guide the allocation for the 2023 to 2028 cycle.The allocation process involves public engagement,technical analysis, and financial forecasts in partnership with the cities of Washington County. Tigard projects receiving MSTIP funds in previous cycles have included urban upgrades to Walnut Street(116th to Tiedeman)and the Pacific Highway/Gaarde St/McDonald St intersection improvements (2012)and pending urban upgrades on SW 121st Ave (Tippit to Whistler's Loop)and a planned traffic signal at Bonita Rd and Sequoia Pkwy(2016).Further,Tigard has utilized MSTIP Opportunity Funds as leverage for several grant-funded projects and programs including Safe Routes to Schools and the upcoming Red Rock Creek Trail Alignment study. With guidance from existing plans and policies including the Tigard Strategic Vision,Complete Streets Policy,Transportation System Plan,and the Capital Improvement Plan,and with input from the Tigard Transportation Advisory Committee (1TAC),city staff will make recommendations for priority project(s)to be funded through the MSTIP program.Tigard staff will support the next MSTIP funding cycle work plan through participation on the technical analysis committee,through public engagement activities,and through membership on the Washington County Coordinating Committee(WCCC)Transportation Advisory Committee(TAC). OTHER ALTERNATIVES N/A COUNCIL GOALS,POLICIES,APPROVED MASTER PLANS 2021 Council Goals,Strategy 3.4:"Develop regional partnerships to help reduce carbon throughout the Portland metro." Tigard Strategic Plan Vision: "Tigard:An equitable community,that is walkable,healthy,and accessible for everyone." Tigard Strategic Plan Priority 2:"Create a well-connected pedestrian network that links all Tigard residents and businesses." Tigard Strategic Plan Objective 3.1: "Pursue land development that maximizes public health benefits while increasing connection between people and community destinations." Tigard Strategic Plan Objective 3.2: "Focus development-associated resources in parts of the city that have the capacity to serve, house,employ,and attract the most people with the least impact on Tigard's natural systems and the climate." Tigard Strategic Plan Objective 3.3: "Understand the effects of development on vulnerable Tigard residents and mitigate these impacts within projects and over time." Tigard Strategic Plan Objective 3.4: "Plan and create in a manner that reduces climate impacts to the maximum extent practicable, especially for those most vulnerable." DATES OF PREVIOUS COUNCIL CONSIDERATION N/A Attachments MSTIP Briefing Presentation PDF ci Q' `NGTO/v CQGa ORE'GO'N .,«7 f irp MSTIP 23 - 28f., �� 1 i:r,..;F-.4.1.;,,..„,,-.,,, ...„,,... Funding Allocation w .~ Work Plan .„.'"7:70,,,..., -"T. ti-4J-, 4-,' v w `l'h . , .,. TIGARD CITY COUNCIL BRIEFINGto .61 ase Sept. 28, 2021 Land Use & Transportation www.co.washington.or.us -4 Agenda for today Share Major Streets Transportation Improvement Program (MSTIP) background Share MSTIP 23-28 Funding Allocation Work Plan Seek input on outcomes, eligibility and engagement www.co.washington.or.us I Land Use&Transportation -4 MSTIP allocates dedicated funding The MSTIP allocation process is an important step in building our transportation system. Transportation iPrioritize Project Construction System Plan Funding Design iii .-) --) 61 4. fe cirno Set goals, objectives Select projects Start the project Product delivery and strategies and programs Facility need. mode, Implementation of Specific assessment of Final design refinement function and general plan goals engineering alternatives and construction location and engineering design We are here! www.co.washington.or.us I Land Use&Transportation -� MSTIP overview Major Streets Transportation Improvement Program Countywide property taxes improving major roads • Pay-as-you-go approach More than 150 projects funded since 1986 • More than $900 million • Five-year funding cycles w Project list recommended by Washington County Coordinating Committee (WCCC); approved by Board of Commissioners www.co.washington.or.us I Land Use&Transportation --* MSTIP history Voter-approved serial levies: 1986, 1989 and 1995 ( MSTIP 1-3) In 1997, the levy rate was reduced; became part of County's property tax rate Since 1997, County Commissioners have approved four MSTIP project and program funding cycles (MSTIP 3b through 3e) The upcoming MSTIP cycle will identify funding allocations for projects and programs for approximately 2023-2028 www.co.washington.or.us I Land Use&Transportation MSTIP 3e allocation , 2018 - 2023 Total Funding Allocation : $175 million ($35m/year) : • $160 million for 23 multi-modal road projects • $7.5 million Opportunity Fund set-aside • $7 million rural bridge replacement set-aside $500,000 Intelligent Transportation Systems (ITS) improvement set-aside www.co.washington.or.us I Land Use&Transportation -+ Active and completed MSTIP projects VANCOUVER 47 .. -.7-----..1-..-----Is.....\ NORTH P, I n /� 00 0 0 PORTLAND O \/ F OREST � GROVE H+L^LAISpORO , COR--NDLIUS % ,/ 0 `,�DE+AsVrE,RTON 8 26 011 , 0 4111 al '10 C7 '!�.' " Co ( ASTON 0 T1GAR�U LAKE 0 Active and Completed MSTIP Intersection/ o ala �,• OSWEGO Spot Improvements RI;V 0 0 1111 Active and Completed MSTIP Road Projects ., 401jA 4N RTP Equity Area I / • 05. POC or LEP, and Low Income SLIFd2W()01) \ll `4 it POC or LEP 99w Low Income ItEWBl;12( WILSON VILLE emcos\NAS\GISDATA\Workgroups\GISPlanning\?ranspo0WRIY�J t[TiP\2021_MSTIP\2021 MSTIPaprx,Layout MSTIP 44__RTP EpuRvPPf,Pont Date: ,O' www.co.washington.or.us I Land Use&Transportation 7 -4 Tigard -area MSTIP projects o iio Ell 0 0 HF,t'FRTI/,V- t J r J 5 1 <IT}. ® City of Tigard },I,, ' 0 Completed MSTIP Intersection/ ;z Spot Improvements HI coo e '• O Completed MSTIP Road Projects ° www.co.washingtOn.onus T 205 ""�� -rA+leas P Il 'i V°I"•ppm,laW 7P MSTIP Co .eJ • - .ate H RWOOD MSTIP 23 - 28 Funding Allocation Work Plan We are here Milestone 1 Milestone 2 Milestone 3 Milestone 4 Summer 2021 Fall 2021 Winter 2022 Summer 2022 • Confirm Work • Community • Evaluate projects • Board adoption Plan input on values • Identify • Project list • Develop equity • Identify eligibility programmatic • Programmatic framework and criteria and elements elements public evaluation • Release • Administrative engagement plan metrics prioritized list procedures • Initiate project and solicitation programmatic elements for public comment www.co.washington.or.us I Land Use&Transportation - Past eligibility criteria Past MSTIP cycle project eligibility criteria : • Meets multi-modal needs • On roadways of countywide significance • Ranks as high local priority • Geographically and financially balanced www.co.washington.or.us I Land Use&Transportation 10 - System of Countywide Interest C7 Washington County System of C67 Countywide Interest i It o& - lillic Primary Map 111 e Eligible Arterials/ , ;, Principal Arterials ,4,11L e Eligible Eated ,; sia4 mr 4 .tfri.ii gg ,., 4. "ii a Area i 110 , =County will,mpg .0tii oppl. r.. ., .„ ./ . , . . ,, .1 0. 144 , , „,.. - piocil_ r£ , ,,,.. , , I January 2016 A lir ' 1,0 fI This map illustrates the roadways lir I that are eligible for the MSTIP program. Project selection is i iv � I.e _ based on project evaluation 1u � criteria separate from this map. A :1":117::::: 41* mm, _.. nD,p.r 1 al Lad U.1,&Tra. ., n 11 uiµ•rn,l pwnkpnxnn Snn n.-o;„„n www.co.washington.or.us I Land Use&Transportation -+ Proposed MSTIP outcomes • Equity: Provide a robust community engagement process that focuses on equity and inclusion, responds to needs of historically excluded communities and informs the final project selection. • Safety: Provide a safe transportation system for all users. Economic Vitality: Provide a reliable transportation system that enhances the economic health of Washington County. -, Livability: Preserve and enhance Washington County's quality of life for all residents, workers and visitors. • Natural Environment: Create and maintain a transportation system that first avoids, then minimizes, then mitigates impacts to the natural environment. www.co.washington.or.us I Land Use&Transportation -> Community engagement approach Engagement consultant as a staff extension • Two community outreach phases: Tell us what is important to you in the transportation system (fall 21) Tell us which projects you like best (spring 22) • Targeted engagement with historically excluded communities • Working with established committees and organizations; city council updates as requested • Working with our city partners and their dedicated equity staff and committees www.co.washington.or.us Land Use&Transportation -� Questions or comments ? What are your priorities for future MSTIP funding allocations? What are your thoughts on our proposed approach and outcomes? Do you have feedback on our community engagement? 40 Do you have questions about the process? Is there anyone else you recommend we check in with? www.co.washington.or.us Land Use&Transportation -÷ Staff contact information Stephen Roberts, Director of Land Use & Transportation stephen_roberts@co.washington.or.us Chris Deffebach, Sr. Policy Analyst christina_deffebach@co.washington.or.us Erin Wardell, Principal Transportation Planner erin_wardell@co.washington.or.us www.co.washington.or.us I Land Use&Transportation \t‘GTONc �� OG 2A► °REGO Land Use & Transportation www.co.washington.or.us