Resolution No. 21-02 CITY OF TIGARD, OREGON
TIGARD CITY COUNCIL
RESOLUTION NO. 21-02
A RESOLUTION TO ADOPT THE FY 2021 SECOND QUARTER BUDGET SUPPLEMENTAL
INCLUDING BUDGET ADJUSTMENTS TO PUBLIC WORKS, POLICY AND ADMINISTRATION,
AND COMMUNITY SERVICES.
WHEREAS,the city acknowledges those items that were unknown at the time the FY 2021 budget was adopted;
and
WHEREAS, the city recognizes approximately $2,586,736 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 2020-21 Budget is hereby amended as detailed in Exhibit B.
SECTION 2: This resolution is effective immediately upon passage.
PASSED: This 26th day of January 2021.
< a-ft-%40-
Mayor- City of Tigard
ATTEST:
vooa�
Deputy City Recorder- ty of Tigard
RESOLUTION 21-02
Page 1
CITY OF TIGARD - BUDGET SUPPLEMENTAL 1'26'2021
FY 2020-2021 Quarter: 2
Item # Department Fund Division Request Title Request Funding Total Amount Detailed Description
Source
Q2CD01 Community 230-Building Fund 3100-Building Add 0.25 FTE assistant planner for New Contingency $ 19,400 Building is requesting to add 0.25 FTE to a current 0.75 FTE Assistant Planner position to create 1.00 FTE position.The additional 0.25 FTE
Development specialty housing types would help to assist building permit staff in processing and administering building permits for several new housing types approved in the
City.These housing types include Accessory Dwelling Units(ADU), Cottage Clusters, Quads,and other missing middle units.The
processing of building permits for these types of housing units has added a great deal of work for the Building Division to correctly
administer the planning and permitting process, requiring staff with detailed planning knowledge. Administering the System Development
Charges(including exemptions) has shown to be beyond what current staff is able to process.
Q2CD02 Community 100-General Fund 5900-Social Services Tigard CARES Business Assistance NEW Miscellaneous $ 985,800 Tigard CARES Business Assistance is expanding its services yet again through additional Federal grants.This request will allocate a grant
Development Grants IVb Revenue disbursement from Washington County through Federal CARES act funds to recapitalize a COVID-19 business assistance grant program.
Q2CM01 Multiple Multiple Multiple Supervisor Study Implementation NEW Multiple $ 65,300 In accordance with the Oregon Equal Pay Act, in FY2020,the city completed a range placement study and developed a pay matrix to
ensure consistent application of range placement in order to maintain compliance with the law. The one area that did not get addressed
in FY2020 was the supervisory group. In early 2020,concerns were raised that some supervisor positions may share comparable
character with other supervisors under the Oregon Equal Pay Act.To ensure compliance with the law,the city contracted an HR Consulting
firm to do a full review of our supervisory classifications and resulted in following adjustments.
•Accounting Supervisor FIS—Due to the position having a broader scope of duties, moved the position to the Principal Management
Analyst classification from M35 to M36(2.5%increase);from hourly to exempt.
•City Recorder CS—Due to being behind the market, moved the position up two ranges from M30 to M32(5%increase).
• Facilities Supervisor CS—Due to being behind the market, moved the position up three ranges from M29 to M32(7.5% increase);from
hourly to exempt.
• Public Works Supervisors—Due to being behind the market, moved the positions up three ranges from M29 to M32(7.5%increase);
from hourly to exempt.
• Library Acquisitions Supervisor—Due to being behind the market and for internal equity purposes, moved the position up four pay
ranges from M23 to M27(10%increase); keeping as hourly.
• Police Sergeants—While Sergeants were not part of the study,due to compression issue with Police Officers as discussed in TPOA
bargaining discussions, HR is recommending to move the position up one range from M38 to M39(2.5%)to address this issue.
Q2FIS01 Finance& 600-Central Services 2500-Contracts and Purchasing Equity Contracting NEW Multiple $ 10,000 As part of the City's Anti-Racism Action Plan, Finance&Information Services Department has identified partner organizations that focus on
Information Fund Membership/Sponsorship minority and women small businesses like Oregon Association of Minority Entrepreneurs, Professional Business Development Group,
Services National Association of Minority Contractors-Oregon and Latino Built to communicate about upcoming projects and contract opportunities.
For many of these organizations,there is a partnership/sponsorship contribution dues that allows the city to access their membership and
engage with associated businesses on Tigard contracting and business opportunities.
Q2FIS02 Finance& MULTIPLE MULTIPLE ROW Consulting Contract NEW Contingency $ 190,000 ROW Associates management consulting fee, historically,was budgeted in utility funds. Since the revenue associated with ROW Franchise
Information Fee is recorded in the General Fund,expenditures such as this consulting service fees should remain in the General Fund as well,which
Services will be in compliance with the accounting rules. Annualized service fee is$135K and requesting additional$55K for the true-up of FY20.
Q2PD01 Police 100-General Fund MULTIPLE TPOA Collective Bargaining increase NEW Contingency $ 272,700 City Council approved the Tigard Police Officers'Association's(TPOA)ratified Collective Bargaining Agreement on October 13, 2020.This
request reflects the 2.6%COLA and 0.5%market adjustment on salaries as well as wage-based benefits that were effective in FY 2020-
21.The provisions of the contract are retroactive to July 1, 2020 and are in effect for three years when the contract expires on June 30,
2023.TPOA members began receiving their new salary rates as of the Oct 29th pay period and received retroactive pay in their November
12th paycheck.The requested amount reflects the annualized cost of the contracted salary adjustments, but takes into account vacancies
at the time of contract ratification.This request adds appropriations in General Fund only. While Levy funded officers are also impacted,
previous and existing vacancies are able to accommodate the salary increase in the current fiscal year.The FY 2021-22 budget(General
Fund and Levy)will include updated salaries for all TPOA members as per contract provisions.
Q2PD02 Police 100-General Fund 4100-Police Operations K9 Private Donations NEW Miscellaneous $ 17,000 Throughout the years,the Police Department has received private donations in support of the Police K9 Unit. Primarily,these donations
Revenue have come from the Tigard Breakfast Rotary's annual fall"doggie fun run"in Cook Park and two very supportive community members.
These donations will finance the purchase of the PD's third police dog and one-time set up costs.These costs include,the dog,the outdoor
kennel, initial leash as well as related equipment and supplies.The department's existing police dogs, Diesel and Rico,were also
purchased with private community donations.Costs related to ongoing care and maintenance of the next police dog have been absorbed
within the PD's existing General Fund operating budget.This request increases appropriations to formally recognize the private donations
in PD's General Fund operating budget.
RESOLUTION 21-02 1 of 3
Page 2
CITY OF TIGARD - BUDGET SUPPLEMENTAL 1'26'2021
FY 2020-2021 Quarter: 2
Item # Department Fund Division Request Title Request Funding Total Amount Detailed Description
Source
Q2PD03 Police 100-General Fund 4100-Police Operations Transit Police Position Adjustment NEW Existing $ (250,160) TPD is re-evaluating its participation in the Transit Police program—a program where TriMet reimburses member law enforcement
Appropriations agencies for the salaries and benefits related to officers"loaned"to TriMet for policing the transit system across the region.Tigard has
partnered with TriMet in this program since 2004,with the number of Tigard officers dedicated to transit enforcement increasing over
time.As per the FY 2019-20 IGA with TriMet,TPD had dedicated five(5.0)officers and one(1.0)sergeant position to Transit Police.
As the current IGA set to expire on 12/31/2020,Tigard has the opportunity to reassess its level of participation in the Transit Police
program. Due to the unknowns associated with the administrative transition and TPD's current acute patrol staffing needs,all dedicated
Tigard officers will have officially returned to Tigard patrol duty by January 1, 2021.TPD's priority is to adequately staff each patrol shift,
which can be accomplished filling current GF vacancies with officers previously assigned to TriMet.TPD is anticipating that the future
Transit Police participation will be smaller than the current one dedicating no more than two(2.0)officers and one(1.0)sergeant position
when the TPD rejoins the Transit Police program later in FY 2021-22.This request cuts 3.0 FTE of existing 6.0 Transit FTE.The remaining
dedicated Transit Police positions will be left vacant in TPD's budget until the new fiscal year when a new scope has been determined and
a new IGA has been executed.
With the reduction staff comes with reduction in reimbursement revenues from TriMet,which makes this request a zero net impact to the
General Fund.
Q2PD05 Police 100-General Fund MULTIPLE Federal COVID-19 Grant NEW Miscellaneous $ 46,675 As part of the Federal Department of Justice, Bureau of Justice Assistance,the Police Department applied and was awarded following
Revenue grants.This supplemental request recognizes the Federal funding which will be drawn down later in the fiscal year.
BJA Grant 2020-VD-BX-1226—Equipment and Supplies, $34,575
A"BJA FY 20 Coronavirus Emergency Supplemental Funding Program"Grant in order to purchase equipment to support our operations
during the COVID-19 pandemic.We identified the purchase of seven (7) laptops to more outfit additional department staff with
ruggedized,CJIS compliant computers for remote work. We also requested funding for additional PPE.The grant has been awarded and
the laptops have been purchased.
BJA Grant 2020-DJ-BX-0976 2020—Consulting Services, $12,100
Edward Byrne Memorial Justice Assistance grant.The scope of our request was to hire an education consultant to collaboratively develop
training for members of the Public Safety Advisory Board, in addition to creating online training modules for new police recruits before
they are placed in the Police Academy.The grant has been awarded and the consultant has been hired.
Q2PW01 Capital 510-Stormwater Fund 8000-CIP/Contingency CIP-94048 Oak Street Property NEW Unanticipated $ 400,000 The property owner of a parcel identified in the Stormwater Master Plan (Project ID: CIP#106)has indicated they are ready to sell their
Improvement Acquisition Fund Balance property and the city has the opportunity to purchase it. If the city waits,the property could be bought and significant improvements could
Program be made increasing the value of the property and potentially leaving the property unavailable for purchase for a long time. Using
unanticipated fund balance,this project will purchase the property and demolish the building. a future CIP project will add more floodplain
storage.
Q2PW02 Capital 532-Water CIP Fund 8000-CIP/Contingency CIP-96056 Water SDC Study NEW Unanticipated $ - Budgeted in FY21 in the operating funds, however,due to accounting rules,the Water SDC Study needs to be moved to the capital fund
Improvement Fund Balance instead of the operating fund. Requesting the Water SDC Study reclassed to the Water CIP.
lPrnnram
Q2PW03 Capital 460-Transportation 8000-CIP/Contingency CIP-95064 Frewing Street Sidewalk NEW/CARRYFO Unanticipated $ 378,500 Carryforward of$52,000 from prior year appropriations impacting the Community Development Block Grant. In addition,there is a new
Improvement CIP Fund Infill -CDBG RWARD Fund Balance ask to cover unforeseen right of way expenses, increase in design,staff time,and construction costs. Because of the proposed stormwater
Program infrastructure changes and unit price increases,the sidewalk project has additional construction expenses, including higher mobilization
and contingency costs. The city will ask Washington County Community Development Block Grant to cover part of this project increase.
Remainder will come from the Transportation SDC Fund. This project cost increase was noted on the November CIP Update to Council.
Q2PW04 Capital 460-Transportation 8000-CIP/Contingency CIP-95054 Hall Boulevard/ Pfaffle NEW Unanticipated $ 19,000 ODOT is designing and constructing a footing to accommodate a future traffic signal pole as part of signalizing the Hall/Pfaffle
Improvement CIP Fund Street New Traffic Signal Fund Balance intersection in the future. ODOT's estimate requires an increase of$40,400 to reflect infrastructure requested by the City that makes
Program sense to have installed while the Hall Blvd overpass is replaced, saving money in the long term. $21,400 is Non-Budgetary Impact;
moving dollars appropriated in CIP#95068 Fiber Communication Networks Program to cover cost to install conduit the length of the
overpass that can accommodate future fiber cable installation. The remaining $19,000 is related to increased costs to construct a
foundation capable of supporting a signal pole with dual mast arms,which will save Tigard from constructing an entire additional footing,
as well as various junction boxes and items that will be needed when the intersection is signalized.
Q2PW05 Capital 460-Transportation 8000-CIP/Contingency CIP-95057 Fanno Creek Trail NEW Unanticipated $ 48,000 Narrowing down the trail alternatives to a singular route has proven to be more challenging than anticipated, in particular, in the vicinity of
Improvement CIP Fund Alignment Study(Bonita Road to Fund Balance where the trail would cross Bonita Rd and Durham Rd. The increase will allow the consultant to perform additional technical analysis in
Program Tualatin River) order to determine a preferred singular route,which will then be memorialized in a report format that was not originally scoped. In
addition,the second project open house was prepared virtually due to COVID-19 restrictions,which was very time consuming. This also
accounts for additional internal project management expense to work on the project for a longer duration than originally planned.
RESOLUTION 21-02 2 of 3
Page 3
CITY OF TIGARD - BUDGET SUPPLEMENTAL 1'26'2021
FY 2020-2021 Quarter: 2
Item # Department Fund Division Request Title Request Funding Total Amount Detailed Description
Source
Q2PW06 Capital 420-Parks Capital 8000-CIP/Contingency CIP-92056 Park System Master Plan NEW Unanticipated $ 25,000 The project has taken longer than originally anticipated and required additional project management time due to the input from public
Improvement Fund Update Fund Balance outreach and request from the Council to better address the equity in Parks.This request will cover additional internal and external
Pronrarn
Q2PW07 Public Works 200-Gas Tax Fund 6200-Street Maintenance Mini Excavator-replacement of Case NEW Multiple $ 100,000 Replace Case 580 Excavator with a model better suited to complete work for the Pavement Management Program. The excavator will be
580 Excavator purchased with$75,000 from fund 412-Street Maintenance Fund and $25,000 from 200-Gas Tax Fund,the purchase will be run through
the Street Maintenance Division.The funding from the Street Maintenance Fund will come from existing Work in Progress fund and
spending will be monitored to ensure the fund does not run over the lowered amount. Funding from the Gas Tax will come from
Contingency. This equipment was going to be targeted for inclusion in the FY22 budget...This action allows the city to avoid the rental of
a mini excavator for any work able to be completed in FY 21.
Q2PW08 Public Works 200-Gas Tax Fund 6200-Street Maintenance Ford F-450 Trucks- Received Late CARRYFORWA Unanticipated $ 131,000 Purchase of two(2) Ford F-450 Pickup Trucks for Street Maintenance division. These are replacements for two vehicles that have
Due to Manufacturing Backlog RD Fund Balance exceeded their life-cycle for the city. The trucks were budgeted in FY20 and a purchase order was issued in December. Due to a fire at
Caused by Fire the plant that manufactures the dashboards for the trucks, Ford experienced construction delays. This delays caused a back log and the
city's trucks weren't built for over six months post order leading to delivery after the new fiscal year in late July. Under accounting rules,
we need to apply the purchase to FY21 and move the budget appropriations forward.
Non-Bud e ary Im act Items
Item# Department Fund Division Request Title Request Funding Source Total Amount Detailed Description
Q2FIS03 Finance& 600-Central Services 2300-Information Technology Reduction of Computer Support TECHNICAL Existing $ - Tigard IT has moved in the direction of Managed Help Desk Services for tier I and II services instead of staffing this role with a City of
Information Fund Technician, 1.00 FTE,and increase Appropriations Tigard employee.The recent contract with BridgeTech LLC has eliminated the need for the 1.0 FTE position within the IT division.This
Services Managed Help Desk coverage request is to remove position number 6424-Computer Support Technician(1.0 FTE)from the FTE count for the IT division. All salary and
benefit funds associated with this position will be used in the current and subsequent fiscal years to fund the existing contract with
BridgeTech LLC.
RESOLUTION 21-02 3 of 3
Page 4
Exhibit B
Total All Funds
Revised version to include the General Fund Transfer portion of the Q1CM03 Supplemental Budget Request.
FY 2021 Q2 Revised
Total All Funds Revised Amendment Q2
Resources
Beginning Fund Balance 164,965,399 $ 1,051,921 $ 166,017,320
Property Taxes $ 22,631,803 $ - $ 22,631,803
Franchise Fees $ 6,615,979 $ - $ 6,615,979
Special Assessments $ 50,000 $ - $ 50,000
Licenses&Permits $ 16,804,763 $ - $ 16,804,763
Intergovernmental $ 21,647,140 $ 822,694 $ 22,469,834
Charges for Services $ 50,990,752 $ 17,000 $ 51,007,752
Fines&Forfeitures $ 2,359,632 $ - $ 2,359,632
Interest Earnings $ 2,538,000 $ - $ 2,538,000
Miscellaneous $ 765,850 $ - $ 765,850
Other Financing Sources $ 2,500,000 $ - $ 2,500,000
Transfers In from Other Funds $ 44,544,180 $ 710,921 $ 45,255,101
Total Resources 336,413,498 $
Requirements
Community Development $ 7,598,879 $ 19,400 $ 7,618,279
Community Services $ 31,325,271 $ 1,101,826 $ 32,427,097
Policy and Administration $ 17,484,810 $ 208,093 $ 17,692,903
Public Works $ 31,254,167 $ 218,396 $ 31,472,563
Program Expenditures Total $ 87,663,127 $ 1,547,715 $ 89,210,842
Debt Service $ 11,221,000 $ - $ 11,221,000
Loan to TCDA $ 1,000 $ - $ 1,000
Work-In-Progress $ 40,978,258 $ 910,500 $ 41,888,758
Transfers to Other Funds $ 46,544,180 $ 710,921 $ 47,255,101
Contingency $ 3,203,900 $ (582,400) $ 2,621,500
Total Budget $ 189,611,465 $ 2,586,736 $ 192,198,201
Reserve For Future Expenditure $ 146,802,033 $ 15,800 $ 146,817,833
Total Requirements $ 336,413,498 $ 2,602,536 $ 339,016,034
Exhibit B
General Fund
Revised version to include the General Fund Transfer portion of the Q1CM03 Supplemental Budget Request.
FY 2021 Revised
General Fund Revised Q2CD02 Q2CM01 Q2FIS02 Q2PD01 Q2PD02 Q2PD03 Q2PD05 Q2
Resources
Beginning Fund Balance $ 26,154,623 $ - $ - $ - $ - $ - $ - $ - $ 26,154,623
Property Taxes $ 17,753,872 $ - $ - $ - $ - $ - $ - $ - $ 17,753,872
Franchise Fees $ 6,615,979 $ - $ - $ - $ - $ - $ - $ - $ 6,615,979
Special Assessments $ - $ - $ - $ - $ - $ - $ - $ - $ -
Licenses&Permits $ 1,123,252 $ - $ - $ - $ - $ - $ - $ - $ 1,123,252
Intergovernmental $ 9,967,409 $ 961,600 $ - $ - $ - $ - $ (250,160) $ 46,675 $ 10,725,524
Charges for Services $ 253,132 $ - $ - $ - $ - $ 17,000 $ - $ - $ 270,132
Fines&Forfeitures $ 2,258,261 $ - $ - $ - $ - $ - $ - $ - $ 2,258,261
Interest Earnings $ 400,900 $ - $ - $ - $ - $ - $ - $ - $ 400,900
Miscellaneous $ 356,432 $ - $ - $ - $ - $ - $ - $ - $ 356,432
Other Financing Sources $ - $ - $ - $ - $ - $ - $ $ - $ -
Transfers In from Other Funds $ 354,000 $ - $ - $ - $ $ - $ - $ - $ 354,000
Total Resources $ 65,237,860 $ 961,600 $ - $ - $ i - $ 17,000 $ (250,160) $ 46,675 $ 66,012,975
Requirements
Community Development $ 4,908,874 $ - $ - $ - $ - $ - $ - $ - $ 4,908,874
Community Services $ 28,834,916 $ 985,800 $ 29,811 $ - $ 272,700 $ 17,000 $ (250,160) $ 46,675 $ 29,936,742
Policy and Administration $ 1,875,705 $ - $ - $ - $ - $ - $ - $ - $ 1,875,705
Public Works $ - $ - $ - $ - $ - $ - $ - $ - $ -
Program Expenditures Total $ 35,619,495 $ 985,800 $ 29,811 $ - $ 272,700 $ 17,000 $ (250,160) $ 46,675 $ 36,721,321
Debt Service $ - $ - $ - $ - $ - $ - $ - $ - $ -
Loan to TCDA $ 1,000 $ - $ - $ - $ - $ - $ - $ - $ 1,000
Work-In-Progress $ - $ - $ - $ - $ - $ - $ - $ - $ -
Transfers to Other Funds $ 2,771,615 $ - $ - $ 190,000 $ - $ - $ - $ - $ 2,961,615
Contingency $ 1,334,900 $ - $ (29,811) $ (190,000) $ (272,700) $ - 8 $ - 5 842,389
Total Budget $ 39,727,010 $ 985,800 $ - $ - $ - $ 17,000 $ (250,160) $ 46,675 $ 40,526,325
Reserve For Future Expenditure $ 25,510,850 $ (24,200) $ - $ - $ - $ - $ - $ - $ 25,486,650
Total Requirements $ 65,237,860 $ 961,600 $ - $ - $ - $ 17,000 $ (250,160) $ 46,675 $ 66,012,975
Exhibit B
Gas Tax Fund
FY 2021 Revised
Gas Tax Fund Revised Q2CM01 Q2PW07 Q2PW08 Q2
Resources
Beginning Fund Balance 2,707,010 $ - - $ 131,000 $ 2,838,010
Property Taxes $ - $ - $ - $ - $ -
Franchise Fees $ - $ - $ - $ - $ -
Special Assessments $ - $ - $ - $ - $ -
Licenses&Permits $ 65,965 $ - $ - $ - $ 65,965
Intergovernmental $ 4,915,000 $ - $ - $ - $ 4,915,000
Charges for Services $ - $ - $ - $ - $ -
Fines&Forfeitures $ - $ - $ - $ - $ -
Interest Earnings $ 82,400 $ - $ - $ - $ 82,400
Miscellaneous $ 62,818 $ - $ - $ - $ 62,818
Other Financing Sources $ - $ - $ - $ - $ -
Transfers In from Other Funds $ 226,000 $ - $ 75,000 $ - $ 301,000
Total Resources $ 8,059,193 $ - 75,000 $ 131,000 $ 8,265,193
Requirements
Community Development $ - $ - $ - $ - $ -
Community Services $ - $ - $ - $ - $ -
Policy and Administration $ - $ - $ - $ - $ -
Public Works $ 3,451,554 $ 3,830 $ 100,000 $ 131,000 $ 3,686,384
Program Expenditures Total $ 3,451,554 $ 3,830 $ 100,000 $ 131,000 $ 3,686,384
Debt Service $ - $ - $ - $ - $ -
Loan to TCDA $ - $ - $ - $ - $ -
Work-In-Progress $ - $ - $ - $ - $ -
Transfers to Other Funds $ 1,326,946 $ - $ - $ - $ 1,326,946
Contingency $ 175,000 $ (3,830) $ (25,000) $ - $ 146,170
Total Budget $ 4,953,500 $ - $ 75,000 $ 131,000 $ 5,159,500
Reserve For Future Expenditure $ 3,105,693 $ $ - $ - $ 3,105,693
Total Requirements $ 8,059,193 $ - $ 75,000 $ 131,000 $ 8,265,193
Exhibit B
Building Fund
FY 2021 Revised
Building Fund Revised Q2CD01 Q2
Resources
Beginning Fund Balance $ 10,369,604 $ As 10,369,604
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Special Assessments $ - $ - $ -
Licenses&Permits $ 3,533,704 $ - $ 3,533,704
Intergovernmental $ 8,281 $ - $ 8,281
Charges for Services $ 7,000 $ - $ 7,000
Fines&Forfeitures $ - $ - $ -
Interest Earnings $ 150,500 $ - $ 150,500
Miscellaneous $ 500 $ - $ 500
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ 250,000 $ - $ 250,000
ir Total Resources $ 14,319,589 $
Requirements
Community Development $ 2,260,005 $ 19,400 $ 2,279,405
Community Services $ - $ - $ -
Policy and Administration $ - $ - $ -
Public Works $ - $ - $ -
Program Expenditures Total $ 2,260,005 $ 19,400 $ 2,279,405
Debt Service $ - $ - $ -
Loan to TCDA $ - $ - $ -
Work-In-Progress $ - $ - $ -
Transfers to Other Funds $ - $ - $ -
Contingency $ 150,000 $ (19,400) $ 130,600
Total Budget $ 2,410,005 $ - $ 2,410,005
Reserve For Future Expenditure $ 11,909,584 $ $ 11,909,584
Total Requirements $ 14,319,589 $ - $ 14,319,589
Exhibit B
Parks Capital Fund
FY 2021 Revised
Parks Capital Fund Revised Q2PW06 Q2
Resources
Beginning Fund Balance $ 432,919 $ - $ 432,919
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Special Assessments $ - $ - $ -
Licenses&Permits $ - $ - $ -
Intergovernmental $ 360,500 $ - $ 360,500
Charges for Services $ - $ - $ -
Fines&Forfeitures $ - $ - $ -
Interest Earnings $ - $ - $ -
Miscellaneous $ - $ - $ -
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ 6,244,500 $ 25,000 $ 6,269,500
Total Resources $ 7,037,919 $ 25,000 $ 7,062,919
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ - $ - $ -
Public Works $ - $ - $ -
Program Expenditures Total $ - $ - $ -
Debt Service $ - $ - $ -
Loan to TCDA $ - $ - $ -
Work-In-Progress $ 6,605,000 $ 25,000 $ 6,630,000
Transfers to Other Funds $ - $ - $ -
Contingency $ - $ - $ -
Total Budget $ 6,605,000 $ 25,000 $ 6,630,000
Reserve For Future Expenditure $ 432,919 $ - $ 432,919
Total Requirements $ 7,037,919 $ 25,000 $ 7,062,919
Exhibit B
Parks Utility Fund
FY 2021 Revised
Parks Utility Fund Revised Q2CM01 Q2
Resources
Beginning Fund Balance $ 1,819,310 $ - $ 1,819,310
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Special Assessments $ - $ - $ -
Licenses&Permits $ 1,866,872 $ - $ 1,866,872
Intergovernmental $ - $ - $ -
Charges for Services $ 90,750 $ - $ 90,750
Fines&Forfeitures $ - $ - $ -
Interest Earnings $ 3,300 $ - $ 3,300
Miscellaneous $ - $ - $ -
Other Financing Sources $ 2,500,000 $ - $ 2,500,000
Transfers In from Other Funds $ 2,293,500 $ - $ 2,293,500
Total Resources $ 8,573,732 $ - $ 8,573,732
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ - $ - $ -
Public Works $ 4,551,954 $ 7,540 $ 4,559,494
Program Expenditures Total $ 4,551,954 $ 7,540 $ 4,559,494
Debt Service $ - $ - $ -
Loan to TCDA $ - $ - $ -
Work-In-Progress $ - $ - $ -
Transfers to Other Funds $ 100,333 $ - $ 100,333
Contingency $ 125,000 $ (7,540) $ 117,460
Total Budget $ 4,777,287 $ - $ 4,777,287
Reserve For Future Expenditure $ 3,796,445 $ aff$ 3,796,445
Total Requirements $ 8,573,732 $ - 10 8,573,732
Exhibit B
Parks SDC Fund
FY 2021 Revised
Parks SDC Fund Revised Q2PW05 Q2PW06 Q2
Resources
Beginning Fund Balance $ 9,658,083 $ 48,000 $ 25,000 $ 9,731,083
Property Taxes $ - $ - $ - $ -
Franchise Fees $ - $ - $ - $ -
Special Assessments $ - $ - $ - $ -
Licenses&Permits $ 1,495,466 $ - $ - $ 1,495,466
Intergovernmental $ - $ - $ - $ -
Charges for Services $ - $ - $ - $ -
Fines&Forfeitures $ - $ - $ - $ -
Interest Earnings $ 211,100 $ - $ - $ 211,100
Miscellaneous $ - $ - $ - $ -
Other Financing Sources $ - $ - $ - $ -
Transfers In from Other Funds $ - $ - $ - $ -
Total Resources $ 11,364,649 $ 48,000 25,000 $ 11,437,649
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 $ 6,045,300 $ 48,000 $ 25,000 $ 6,118,300
Contingency $ - $ - $ - $ -
Total Budget $ 6,045,300 $ 48,000 $ 25,000 $ 6,118,300
Reserve For Future Expenditure $ 5,319,349 $ - $ - $ 5,319,349
Total Requirements $ 11,364,649 $ 48,000 $ 25,000 $ 11,437,649
Exhibit B
Street Maintenance Fund
FY 2021 Revised
Street Maintenance Fund Revised Q2PW07 Q2
Resources
Beginning Fund Balance $ 2,243,376 $ 75,000 $ 2,318,376
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Special Assessments $ - $ $ -
Licenses&Permits $ 3,109,600 $ - $ 3,109,600
Intergovernmental $ - $ - $ -
Charges for Services $ - $ - $ -
Fines&Forfeitures $ - $ - $ -
Interest Earnings $ 30,100 $ - $ 30,100
Miscellaneous $ - $ $ -
Other Financing Sources $ - $ $ -
Transfers In from Other Funds $ - $ $ -
Total Resources $ 5,383,076 $ 75,000 $ 5,458,076
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ - $ - $ -
Public Works $ - $ - $ -
Program Expenditures Total $ - $ - $ -
Debt Service $ - $ - $ -
Loan to TCDA $ - $ - $ -
Work-In-Progress $ 2,740,000 $ - $ 2,740,000
Transfers to Other Funds $ 385,297 $ 75,000 $ 460,297
Contingency $ - $ - $ -
Total Budget $ 3,125,297 $ 75,000 $ 3,200,297
Reserve For Future Expenditure $ 2,257,779 $ - $ 2,257,779
Total Requirements $ 5,383,076 $ 75,000 $ 5,458,076
Exhibit B
Transportation CIP Fund
FY 2021 Revised
Transportation CIP Fund Revised Q2PW03 Q2PW04 Q2PW05 Q2
Resources
Beginning Fund Balance $ 923,402 $ - $ - $ - $ 923,402
Property Taxes $ - $ - $ - $ - $ -
Franchise Fees $ - $ - $ - $ - $ -
Special Assessments $ - $ - $ - $ - $ -
Licenses&Permits $ - $ - $ - $ - $ -
Intergovernmental $ 4,356,758 $ 64,579 $ - $ - $ 4,421,337
Charges for Services $ - $ - $ - $ - $ -
Fines&Forfeitures $ - $ - $ - $ - $ -
Interest Earnings $ - $ - $ - $ - $ -
Miscellaneous $ - $ - $ - $ - $ -
Other Financing Sources $ - $ - $ - $ - $ -
Transfers In from Other Funds $ 5,085,000 $ 313,921 $ 19,000 $ 48,000 $ 5,465,921
Total Resources $ 10,365,160 $ 378,500 $ 19,000 $ 48,000 $ 10,810,660
Requirements
Community Development $ - $ - $ - $ - $ -
Community Services $ - $ - $ - $ - $ -
Policy and Administration $ - $ - $ - $ - $ -
Public Works $ - $ - $ - $ - $ -
Program Expenditures Total $ - $ - $ - $ - $ -
Debt Service $ - $ - $ - $ - $ -
Loan to TCDA $ - $ - $ - $ - $ -
Work-In-Progress $ 9,441,758 $ 378,500 $ 19,000 $ 48,000 $ 9,887,258
Transfers to Other Funds $ - $ - $ - $ - $ -
Contingency $ - $ - $ - $ - $ -
Total Budget $ 9,441,758 $ 378,500 $ 19,000 $ 48,000 $ 9,887,258
Reserve For Future Expenditure $ 923,402 $ - $ - $ - $ 923,402
Total Requirements $ 10,365,160 $ 378,500 $ 19,000 $ 48,000 $ 10,810,660
Exhibit B
Transportation SDC Fund
FY 2021 Revised
Transportation SDC Fund Revised Q2PW03 Q2PW04 Q2
Resources
Beginning Fund Balance 8,305,038 $ 313,921 $ 19,000 $ 8,637,959
Property Taxes $ - $ - $ - $ -
Franchise Fees $ - $ - $ - $ -
Special Assessments $ - $ - $ - $ -
Licenses&Permits $ 701,855 $ - $ - $ 701,855
Intergovernmental $ - $ - $ - $ -
Charges for Services $ - $ - $ - $ -
Fines&Forfeitures $ - $ - $ - $ -
Interest Earnings $ 144,000 $ - $ - $ 144,000
Miscellaneous $ - $ - $ - $ -
Other Financing Sources $ - $ - $ - $ -
Transfers In from Other Funds $ - $ - $ - $ -
Total Resources $ 9,150,893--§M 313,921 $ 19,0 9,483,814
Requirements
Community Development $ - $ - $ - $ -
Community Services $ - $ - $ - $
Policy and Administration $ - $ - $ - $
Public Works $ - $ - $ - $ -
Program Expenditures Total $ - $ - $ - $ -
Debt Service $ - $ - $ - $ -
Loan to TCDA $ - $ - $ - $ -
Work-In-Progress $ - $ - $ - $ -
Transfers to Other Funds $ 3,555,862 $ 313,921 $ 19,000 $ 3,888,783
Contingency $ - $ - $ - $ -
Total Budget $ 3,555,862 $ 313,921 $ 19,000 $ 3,888,783
Reserve For Future Expenditure $ 5,595,031 $ - $ - $ 5,595,031
Total Requirements $ 9,150,893 $ 313,921 $ 19,000 $ 9,483,814
Exhibit B
Sanitary Sewer Fund
FY 2021 Revised
Sanitary Sewer Fund Revised Q2CM01 Q2
Resources
Beginning Fund Balance $ 6,015,718 $ - $ 6,015,718
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Special Assessments $ - $ - $ -
Licenses&Permits $ 92,200 $ - $ 92,200
Intergovernmental $ - $ - $ -
Charges for Services $ 3,333,205 $ - $ 3,333,205
Fines&Forfeitures $ - $ - $ -
Interest Earnings $ 110,300 $ - $ 110,300
Miscellaneous $ 42,100 $ - $ 42,100
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ 234,500 $ - $ 234,500
Total Resources $ 9,828,023 $ - $ 9,828,023
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ - $ - $ -
Public Works $ 2,342,147 $ 2,004 $ 2,344,151
Program Expenditures Total $ 2,342,147 $ 2,004 $ 2,344,151
Debt Service $ - $ - $ -
Loan to TCDA $ - $ - $ -
Work-In-Progress $ 1,079,000 $ - $ 1,079,000
Transfers to Other Funds $ 464,320 $ - $ 464,320
Contingency $ 200,000 $ (2,004) $ 197,996
Total Budget $ 4,085,467 $ - $ 4,085,467
Reserve For Future Expenditure $ 5,742,556 $ - $ 5,742,556
Total Requirements $ 9,828,023 $ $ 9,828,023
Exhibit B
Stormwater Fund
FY 2021 Revised
Stormwater Fund Revised Q2CM01 Q2PW01 Q2
Resources
Beginning Fund Balance $ 7,271,046 $ - $ 400,000 $ 7,671,046
Property Taxes $ - $ - $ - $ -
Franchise Fees $ - $ - $ - $
Special Assessments $ - $ - $ - $ -
Licenses&Permits $ - $ - $ - $ -
Intergovernmental $ - $ - $ - $ -
Charges for Services $ 4,044,297 $ - $ - $ 4,044,297
Fines&Forfeitures $ - $ - $ - $ -
Interest Earnings $ 139,900 $ - $ - $ 139,900
Miscellaneous $ 5,000 $ - $ - $ 5,000
Other Financing Sources $ - $ - $ - $ -
Transfers In from Other Funds $ 601,000 $ - $ - $ 601,000
Total Resources $ 12,06 $ 400,000 $ 12,461,243
Requirements
Community Development $ - $ - $ - $ -
Community Services $ - $ - $ - $ -
Policy and Administration $ - $ - $ - $ -
Public Works $ 3,509,897 $ 6,010 $ - $ 3,515,907
Program Expenditures Total $ 3,509,897 $ 6,010 $ - $ 3,515,907
Debt Service $ - $ - $ - $ -
Loan to TCDA $ - $ - $ - $ -
Work-In-Progress $ 2,288,000 $ - $ 400,000 $ 2,688,000
Transfers to Other Funds $ 442,866 $ - $ - $ 442,866
Contingency $ 225,000 $ (6,010) $ - $ 218,990
Total Budget $ 6,465,763 $ - $ 400,000 $ 6,865,763
Reserve For Future Expenditure $ 5,595,480 $ - $ - $ 5,595,480
Total Requirements $ 12,061,243 $ - $ 400,000 $ 12,461,243
Exhibit B
Water Fund
FY 2021 Revised
Water Fund Revised Q2CM01 Q2PW02 Q2
Resources
Beginning Fund Balance $ 38,763,141 $ - - $ 38,763,141
Property Taxes $ - $ - $ - $ -
Franchise Fees $ - $ - $ - $ -
Special Assessments $ - $ - $ - $ -
Licenses&Permits $ 170,000 $ - $ - $ 170,000
Intergovernmental $ - $ - $ - $ -
Charges for Services $ 22,738,411 $ - $ - $ 22,738,411
Fines&Forfeitures $ - $ - $ - $ -
Interest Earnings $ 500,700 $ - $ - $ 500,700
Miscellaneous $ 50,000 $ - $ - $ 50,000
Other Financing Sources $ - $ - $ - $ -
Transfers In from Other Funds $ - $ - $ - $ -
Total Resources $ 62,222,252 $ - - $ 62,222,252
Requirements
Community Development $ - $ - $ - $ -
Community Services $ - $ - $ - $ -
Policy and Administration $ - $ - $ - $ -
Public Works $ 10,479,533 $ 8,012 $ (40,000) $ 10,447,545
Program Expenditures Total $ 10,479,533 $ 8,012 $ (40,000) $ 10,447,545
Debt Service $ - $ - $ - $ -
Loan to TCDA $ - $ - $ - $ -
Work-In-Progress $ - $ - $ - $ -
Transfers to Other Funds $ 23,067,947 $ - $ - $ 23,067,947
Contingency $ 425,000 $ (8,012) $ - $ 416,988
Total Budget $ 33,972,480 $ - $ (40,000) $ 33,932,480
Reserve For Future Expenditure $ 28,249,772 $ JIF $ 40,000 $ 28,289,772
Total Requirements $ 62,222,252 $ - $ - $ 62,222,252
Exhibit B
Water SDC Fund
FY 2021 Revised
Water SDC Fund Revised Q2PW02 Q2
Resources
Beginning Fund Balance $ 13,046,147 $ 40,000 $ 13,086,147
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Special Assessments $ - $ $ -
Licenses&Permits $ 1,870,435 $ - $ 1,870,435
Intergovernmental $ - $ - $ -
Charges for Services $ - $ - $ -
Fines&Forfeitures $ - $ - $ -
Interest Earnings $ 258,200 $ - $ 258,200
Miscellaneous $ - $ $ -
Other Financing Sources $ - $ $ -
Transfers In from Other Funds $ - $ - $ -
Total Resources $ 15,174,782 $ 40,000 $ 15,214,782
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 $ 4,390,268 $ 40,000 $ 4,430,268
Contingency $ - $ - $ -
Total Budget $ 4,390,268 $ 40,000 $ 4,430,268
Reserve For Future Expenditure $ 10,784,514 $ - $ 10,784,514
Total Requirements $ 15,174,782 $ 40,000 $ 15,214,782
Exhibit B
Water CIP Fund
FY 2021 Revised
Water CIP Fund Revised Q2PW02 Q2
Resources
Beginning Fund Balance $ 1,671,726 $ - $ 1,671,726
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 $ 10,868,000 $ 40,000 $ 10,908,000
Total Resources $ 12,539,726 $ 40,000 $ 12,579,726
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ - $ - $ -
Public Works $ - $ - $ -
Program Expenditures Total $ - $ - $ -
Debt Service $ - $ - $ -
Loan to TCDA $ - $ - $ -
Work-In-Progress $ 10,868,000 $ 40,000 $ 10,908,000
Transfers to Other Funds $ - $ - $ -
Contingency $ - $ - $ -
Total Budget $ 10,868,000 $ 40,000 $ 10,908,000
Reserve For Future Expenditure $ 1,671,726 $ - $ 1,671,726
Total Requirements $ 12,539,726 $ 40,000 $ 12,579,726
Exhibit B
Fleet/Property Management Fund
FY 2021 Revised
Fleet/Property Management Fund Revised Q2CM01 Q2
Resources
Beginning Fund Balance $ 811,214 $ Is 811,214
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $
Special Assessments $ - $ - $ -
Licenses&Permits $ - $ - $ -
Intergovernmental $ - $ - $ -
Charges for Services $ 3,196,366 $ - $ 3,196,366
Fines&Forfeitures $ - $ - $ -
Interest Earnings $ - $ - $ -
Miscellaneous $ 5,000 $ - $ 5,000
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ - $ - $ -
Total Resources $ 4,012,580 $ 4,012,580
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ 3,014,543 $ 3,882 $ 3,018,425
Public Works $ - $ - $ -
Program Expenditures Total $ 3,014,543 $ 3,882 $ 3,018,425
Debt Service $ - $ - $ -
Loan to TCDA $ - $ - $ -
Work-In-Progress $ - $ - $ -
Transfers to Other Funds $ 1,000 $ - $ 1,000
Contingency $ 125,000 $ (3,882) $ 121,118
Total Budget $ 3,140,543 $ - $ 3,140,543
Reserve For Future Expenditure $ 872,037 $ 872,037
Total Requirements $ 4,012,580 $ - $ 4,012,580
Exhibit B
Central Services Fund
FY 2021 Revised
Central Services Fund Revised Q2CM01 Q2FIS01 Q2FIS02 Q2
Resources
Beginning Fund Balance 1,996,623 $ - $ - $ - 1,996,623
Property Taxes $ - $ - $ - $ - $ -
Franchise Fees $ - $ - $ - $ - $
Special Assessments $ - $ - $ - $ - $ -
Licenses&Permits $ - $ - $ - $ - $ -
Intergovernmental $ - $ - $ - $ - $ -
Charges for Services $ 11,512,129 $ - $ - $ - $ 11,512,129
Fines&Forfeitures $ - $ - $ - $ - $ -
Interest Earnings $ - $ - $ - $ - $ -
Miscellaneous $ 90,000 $ - $ - $ - $ 90,000
Other Financing Sources $ - $ - $ - $ - $ -
Transfers In from Other Funds $ 874,819 $ - $ - $ 190,000 $ 1,064,819
Total Resources 14,473,571 $ - $ 190,000 $ 14,663,571
Requirements
Community Development $ - $ - $ - $ - $ -
Community Services $ - $ - $ - $ - $ -
Policy and Administration $ 12,354,748 $ 4,211 $ 10,000 $ 190,000 $ 12,558,959
Public Works $ - $ - $ - $ - $ -
Program Expenditures Total $ 12,354,748 $ 4,211 $ 10,000 $ 190,000 $ 12,558,959
Debt Service $ - $ - $ - $ - $ -
Loan to TCDA $ - $ - $ - $ - $ -
Work-In-Progress $ - $ - $ - $ - $ -
Transfers to Other Funds $ - $ - $ - $ - $ -
Contingency $ 94,000 $ (4,211) $ (10,000) $ - $ 79,789
Total Budget $ 12,448,748 $ - $ - $ 190,000 $ 12,638,748
Reserve For Future Expenditure $ 2,024,823 $ - - $ - $ 2,024,823
Total Requirements $ 14,473,571 $ - $ - $ 190,000 $ 14,663,571
Exhibit B
Non-Budgetary Impact Items
Q2FIS03 - Reduction of Computer Support Technician, 1.00 FTE, and increase Managed Help Desk coverage
Tigard IT has moved in the direction of Managed Help Desk Services for tier I and II services instead of staffing this role with a City of
Tigard employee. The recent contract with BridgeTech LLC has eliminated the need for the 1.0 FTE position within the IT division. This
request is to remove position number 6424-Computer Support Technician (1.0 FTE) from the FTE count for the IT division.All salary and
benefit funds associated with this position will be used in the current and subsequent fiscal years to fund the existing contract with
BridgeTech LLC.
Exhibit B
General Fund
Revised version to include the General Fund Transfer portion of the Q1CM03 Supplemental Budget Request.
FY 2021 Revised
General Fund Revised Q2CD02 Q2CM01 Q2FIS02 Q2PD01 Q2PD02 Q2PD03 Q2PD05 Q2
Resources
Beginning Fund Balance $ 26,154,623 $ - $ - $ - $ - $ - $ - $ - $ 26,154,623
Property Taxes $ 17,753,872 $ - $ - $ - $ - $ - $ - $ - $ 17,753,872
Franchise Fees $ 6,615,979 $ - $ - $ - $ - $ - $ - $ - $ 6,615,979
Special Assessments $ - $ - $ - $ - $ - $ - $ - $ - $ -
Licenses&Permits $ 1,123,252 $ - $ - $ - $ - $ - $ - $ - $ 1,123,252
Intergovernmental $ 9,967,409 $ 961,600 $ - $ - $ - $ - $ (250,160) $ 46,675 $ 10,725,524
Charges for Services $ 253,132 $ - $ - $ - $ - $ 17,000 $ - $ - $ 270,132
Fines&Forfeitures $ 2,258,261 $ - $ - $ - $ - $ - $ - $ - $ 2,258,261
Interest Earnings $ 400,900 $ - $ - $ - $ - $ - $ - $ - $ 400,900
Miscellaneous $ 356,432 $ - $ - $ - $ - $ - $ - $ - $ 356,432
Other Financing Sources $ - $ - $ - $ - $ - $ - $ $ - $ -
Transfers In from Other Funds $ 354,000 $ - $ - $ - $ $ - $ - $ - $ 354,000
Total Resources $ 65,237,860 $ 961,600 $ - $ - $ i - $ 17,000 $ (250,160) $ 46,675 $ 66,012,975
Requirements
Community Development $ 6,837,474 $ - $ - $ - $ - $ - $ - $ - $ 6,837,474
Community Services $ 26,906,316 $ 985,800 $ 29,811 $ - $ 272,700 $ 17,000 $ (250,160) $ 46,675 $ 28,008,142
Policy and Administration $ 1,875,705 $ - $ - $ - $ - $ - $ - $ - $ 1,875,705
Public Works $ - $ - $ - $ - $ - $ - $ - $ - $ -
Program Expenditures Total $ 35,619,495 $ 985,800 $ 29,811 $ - $ 272,700 $ 17,000 $ (250,160) $ 46,675 $ 36,721,321
Debt Service $ - $ - $ - $ - $ - $ - $ - $ - $ -
Loan to TCDA $ 1,000 $ - $ - $ - $ - $ - $ - $ - $ 1,000
Work-In-Progress $ - $ - $ - $ - $ - $ - $ - $ - $ -
Transfers to Other Funds $ 2,771,615 $ - $ - $ 190,000 $ - $ - $ - $ - $ 2,961,615
Contingency $ 1,334,900 $ - $ (29,811) $ (190,000) $ (272,700) $ - $ $ - S 842,389
Total Budget $ 39,727,010 $ 985,800 $ - $ - $ - $ 17,000 $ (250,160) $ 46,675 $ 40,526,325
Reserve For Future Expenditure $ 25,510,850 $ (24,200) $ - $ - $ - $ - $ - $ - $ 25,486,650
Total Requirements $ 65,237,860 $ 961,600 $ - $ - $ - $ 17,000 $ (250,160) $ 46,675 $ 66,012,975
Exhibit B
Gas Tax Fund
FY 2021 Revised
Gas Tax Fund Revised Q2CM01 Q2PW07 Q2PW08 Q2
Resources
Beginning Fund Balance 2,707,010 $ - - $ 131,000 $ 2,838,010
Property Taxes $ - $ - $ - $ - $ -
Franchise Fees $ - $ - $ - $ - $ -
Special Assessments $ - $ - $ - $ - $ -
Licenses&Permits $ 65,965 $ - $ - $ - $ 65,965
Intergovernmental $ 4,915,000 $ - $ - $ - $ 4,915,000
Charges for Services $ - $ - $ - $ - $ -
Fines&Forfeitures $ - $ - $ - $ - $ -
Interest Earnings $ 82,400 $ - $ - $ - $ 82,400
Miscellaneous $ 62,818 $ - $ - $ - $ 62,818
Other Financing Sources $ - $ - $ - $ - $ -
Transfers In from Other Funds $ 226,000 $ - $ 75,000 $ - $ 301,000
Total Resources $ 8,059,193 $ - 75,000 $ 131,000 $ 8,265,193
Requirements
Community Development $ - $ - $ - $ - $ -
Community Services $ - $ - $ - $ - $ -
Policy and Administration $ - $ - $ - $ - $ -
Public Works $ 3,451,554 $ 3,830 $ 100,000 $ 131,000 $ 3,686,384
Program Expenditures Total $ 3,451,554 $ 3,830 $ 100,000 $ 131,000 $ 3,686,384
Debt Service $ - $ - $ - $ - $ -
Loan to TCDA $ - $ - $ - $ - $ -
Work-In-Progress $ - $ - $ - $ - $ -
Transfers to Other Funds $ 1,326,946 $ - $ - $ - $ 1,326,946
Contingency $ 175,000 $ (3,830) $ (25,000) $ - $ 146,170
Total Budget $ 4,953,500 $ - $ 75,000 $ 131,000 $ 5,159,500
Reserve For Future Expenditure $ 3,105,693 $ $ - $ - $ 3,105,693
Total Requirements $ 8,059,193 $ - $ 75,000 $ 131,000 $ 8,265,193
Exhibit B
Building Fund
FY 2021 Revised
Building Fund Revised Q2CD01 Q2
Resources
Beginning Fund Balance $ 10,369,604 $ As 10,369,604
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Special Assessments $ - $ - $ -
Licenses&Permits $ 3,533,704 $ - $ 3,533,704
Intergovernmental $ 8,281 $ - $ 8,281
Charges for Services $ 7,000 $ - $ 7,000
Fines&Forfeitures $ - $ - $ -
Interest Earnings $ 150,500 $ - $ 150,500
Miscellaneous $ 500 $ - $ 500
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ 250,000 $ - $ 250,000
ir Total Resources $ 14,319,589 $
Requirements
Community Development $ 2,260,005 $ 19,400 $ 2,279,405
Community Services $ - $ - $ -
Policy and Administration $ - $ - $ -
Public Works $ - $ - $ -
Program Expenditures Total $ 2,260,005 $ 19,400 $ 2,279,405
Debt Service $ - $ - $ -
Loan to TCDA $ - $ - $ -
Work-In-Progress $ - $ - $ -
Transfers to Other Funds $ - $ - $ -
Contingency $ 150,000 $ (19,400) $ 130,600
Total Budget $ 2,410,005 $ - $ 2,410,005
Reserve For Future Expenditure $ 11,909,584 $ $ 11,909,584
Total Requirements $ 14,319,589 $ - $ 14,319,589
Exhibit B
Parks Capital Fund
FY 2021 Revised
Parks Capital Fund Revised Q2PW06 Q2
Resources
Beginning Fund Balance $ 432,919 $ - $ 432,919
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Special Assessments $ - $ - $ -
Licenses&Permits $ - $ - $ -
Intergovernmental $ 360,500 $ - $ 360,500
Charges for Services $ - $ - $ -
Fines&Forfeitures $ - $ - $ -
Interest Earnings $ - $ - $ -
Miscellaneous $ - $ - $ -
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ 6,244,500 $ 25,000 $ 6,269,500
Total Resources $ 7,037,919 $ 25,000 $ 7,062,919
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ - $ - $ -
Public Works $ - $ - $ -
Program Expenditures Total $ - $ - $ -
Debt Service $ - $ - $ -
Loan to TCDA $ - $ - $ -
Work-In-Progress $ 6,605,000 $ 25,000 $ 6,630,000
Transfers to Other Funds $ - $ - $ -
Contingency $ - $ - $ -
Total Budget $ 6,605,000 $ 25,000 $ 6,630,000
Reserve For Future Expenditure $ 432,919 $ - $ 432,919
Total Requirements $ 7,037,919 $ 25,000 $ 7,062,919
Exhibit B
Parks Utility Fund
FY 2021 Revised
Parks Utility Fund Revised Q2CM01 Q2
Resources
Beginning Fund Balance $ 1,819,310 $ - $ 1,819,310
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Special Assessments $ - $ - $ -
Licenses&Permits $ 1,866,872 $ - $ 1,866,872
Intergovernmental $ - $ - $ -
Charges for Services $ 90,750 $ - $ 90,750
Fines&Forfeitures $ - $ - $ -
Interest Earnings $ 3,300 $ - $ 3,300
Miscellaneous $ - $ - $ -
Other Financing Sources $ 2,500,000 $ - $ 2,500,000
Transfers In from Other Funds $ 2,293,500 $ - $ 2,293,500
Total Resources $ 8,573,732 $ - $ 8,573,732
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ - $ - $ -
Public Works $ 4,551,954 $ 7,540 $ 4,559,494
Program Expenditures Total $ 4,551,954 $ 7,540 $ 4,559,494
Debt Service $ - $ - $ -
Loan to TCDA $ - $ - $ -
Work-In-Progress $ - $ - $ -
Transfers to Other Funds $ 100,333 $ - $ 100,333
Contingency $ 125,000 $ (7,540) $ 117,460
Total Budget $ 4,777,287 $ - $ 4,777,287
Reserve For Future Expenditure $ 3,796,445 $ aff$ 3,796,445
Total Requirements $ 8,573,732 $ - 10 8,573,732
Exhibit B
Parks SDC Fund
FY 2021 Revised
Parks SDC Fund Revised Q2PW05 Q2PW06 Q2
Resources
Beginning Fund Balance $ 9,658,083 $ 48,000 $ 25,000 $ 9,731,083
Property Taxes $ - $ - $ - $ -
Franchise Fees $ - $ - $ - $ -
Special Assessments $ - $ - $ - $ -
Licenses&Permits $ 1,495,466 $ - $ - $ 1,495,466
Intergovernmental $ - $ - $ - $ -
Charges for Services $ - $ - $ - $ -
Fines&Forfeitures $ - $ - $ - $ -
Interest Earnings $ 211,100 $ - $ - $ 211,100
Miscellaneous $ - $ - $ - $ -
Other Financing Sources $ - $ - $ - $ -
Transfers In from Other Funds $ - $ - $ - $ -
Total Resources $ 11,364,649 $ 48,000 25,000 $ 11,437,649
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 $ 6,045,300 $ 48,000 $ 25,000 $ 6,118,300
Contingency $ - $ - $ - $ -
Total Budget $ 6,045,300 $ 48,000 $ 25,000 $ 6,118,300
Reserve For Future Expenditure $ 5,319,349 $ - $ - $ 5,319,349
Total Requirements $ 11,364,649 $ 48,000 $ 25,000 $ 11,437,649
Exhibit B
Street Maintenance Fund
FY 2021 Revised
Street Maintenance Fund Revised Q2PW07 Q2
Resources
Beginning Fund Balance $ 2,243,376 $ 75,000 $ 2,318,376
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Special Assessments $ - $ $ -
Licenses&Permits $ 3,109,600 $ - $ 3,109,600
Intergovernmental $ - $ - $ -
Charges for Services $ - $ - $ -
Fines&Forfeitures $ - $ - $ -
Interest Earnings $ 30,100 $ - $ 30,100
Miscellaneous $ - $ $ -
Other Financing Sources $ - $ $ -
Transfers In from Other Funds $ - $ $ -
Total Resources $ 5,383,076 $ 75,000 $ 5,458,076
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ - $ - $ -
Public Works $ - $ - $ -
Program Expenditures Total $ - $ - $ -
Debt Service $ - $ - $ -
Loan to TCDA $ - $ - $ -
Work-In-Progress $ 2,740,000 $ - $ 2,740,000
Transfers to Other Funds $ 385,297 $ 75,000 $ 460,297
Contingency $ - $ - $ -
Total Budget $ 3,125,297 $ 75,000 $ 3,200,297
Reserve For Future Expenditure $ 2,257,779 $ - $ 2,257,779
Total Requirements $ 5,383,076 $ 75,000 $ 5,458,076
Exhibit B
Transportation CIP Fund
FY 2021 Revised
Transportation CIP Fund Revised Q2PW03 Q2PW04 Q2PW05 Q2
Resources
Beginning Fund Balance $ 923,402 $ - $ - $ - $ 923,402
Property Taxes $ - $ - $ - $ - $ -
Franchise Fees $ - $ - $ - $ - $ -
Special Assessments $ - $ - $ - $ - $ -
Licenses&Permits $ - $ - $ - $ - $ -
Intergovernmental $ 4,356,758 $ 64,579 $ - $ - $ 4,421,337
Charges for Services $ - $ - $ - $ - $ -
Fines&Forfeitures $ - $ - $ - $ - $ -
Interest Earnings $ - $ - $ - $ - $ -
Miscellaneous $ - $ - $ - $ - $ -
Other Financing Sources $ - $ - $ - $ - $ -
Transfers In from Other Funds $ 5,085,000 $ 313,921 $ 19,000 $ 48,000 $ 5,465,921
Total Resources $ 10,365,160 $ 378,500 $ 19,000 $ 48,000 $ 10,810,660
Requirements
Community Development $ - $ - $ - $ - $ -
Community Services $ - $ - $ - $ - $ -
Policy and Administration $ - $ - $ - $ - $ -
Public Works $ - $ - $ - $ - $ -
Program Expenditures Total $ - $ - $ - $ - $ -
Debt Service $ - $ - $ - $ - $ -
Loan to TCDA $ - $ - $ - $ - $ -
Work-In-Progress $ 9,441,758 $ 378,500 $ 19,000 $ 48,000 $ 9,887,258
Transfers to Other Funds $ - $ - $ - $ - $ -
Contingency $ - $ - $ - $ - $ -
Total Budget $ 9,441,758 $ 378,500 $ 19,000 $ 48,000 $ 9,887,258
Reserve For Future Expenditure $ 923,402 $ - $ - $ - $ 923,402
Total Requirements $ 10,365,160 $ 378,500 $ 19,000 $ 48,000 $ 10,810,660
Exhibit B
Transportation SDC Fund
FY 2021 Revised
Transportation SDC Fund Revised Q2PW03 Q2PW04 Q2
Resources
Beginning Fund Balance 8,305,038 $ 313,921 $ 19,000 $ 8,637,959
Property Taxes $ - $ - $ - $ -
Franchise Fees $ - $ - $ - $ -
Special Assessments $ - $ - $ - $ -
Licenses&Permits $ 701,855 $ - $ - $ 701,855
Intergovernmental $ - $ - $ - $ -
Charges for Services $ - $ - $ - $ -
Fines&Forfeitures $ - $ - $ - $ -
Interest Earnings $ 144,000 $ - $ - $ 144,000
Miscellaneous $ - $ - $ - $ -
Other Financing Sources $ - $ - $ - $ -
Transfers In from Other Funds $ - $ - $ - $ -
Total Resources $ 9,150,893--§M 313,921 $ 19,0 9,483,814
Requirements
Community Development $ - $ - $ - $ -
Community Services $ - $ - $ - $
Policy and Administration $ - $ - $ - $
Public Works $ - $ - $ - $ -
Program Expenditures Total $ - $ - $ - $ -
Debt Service $ - $ - $ - $ -
Loan to TCDA $ - $ - $ - $ -
Work-In-Progress $ - $ - $ - $ -
Transfers to Other Funds $ 3,555,862 $ 313,921 $ 19,000 $ 3,888,783
Contingency $ - $ - $ - $ -
Total Budget $ 3,555,862 $ 313,921 $ 19,000 $ 3,888,783
Reserve For Future Expenditure $ 5,595,031 $ - $ - $ 5,595,031
Total Requirements $ 9,150,893 $ 313,921 $ 19,000 $ 9,483,814
Exhibit B
Sanitary Sewer Fund
FY 2021 Revised
Sanitary Sewer Fund Revised Q2CM01 Q2
Resources
Beginning Fund Balance $ 6,015,718 $ - $ 6,015,718
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Special Assessments $ - $ - $ -
Licenses&Permits $ 92,200 $ - $ 92,200
Intergovernmental $ - $ - $ -
Charges for Services $ 3,333,205 $ - $ 3,333,205
Fines&Forfeitures $ - $ - $ -
Interest Earnings $ 110,300 $ - $ 110,300
Miscellaneous $ 42,100 $ - $ 42,100
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ 234,500 $ - $ 234,500
Total Resources $ 9,828,023 $ - $ 9,828,023
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ - $ - $ -
Public Works $ 2,342,147 $ 2,004 $ 2,344,151
Program Expenditures Total $ 2,342,147 $ 2,004 $ 2,344,151
Debt Service $ - $ - $ -
Loan to TCDA $ - $ - $ -
Work-In-Progress $ 1,079,000 $ - $ 1,079,000
Transfers to Other Funds $ 464,320 $ - $ 464,320
Contingency $ 200,000 $ (2,004) $ 197,996
Total Budget $ 4,085,467 $ - $ 4,085,467
Reserve For Future Expenditure $ 5,742,556 $ - $ 5,742,556
Total Requirements $ 9,828,023 $ $ 9,828,023
Exhibit B
Stormwater Fund
FY 2021 Revised
Stormwater Fund Revised Q2CM01 Q2PW01 Q2
Resources
Beginning Fund Balance $ 7,271,046 $ - $ 400,000 $ 7,671,046
Property Taxes $ - $ - $ - $ -
Franchise Fees $ - $ - $ - $
Special Assessments $ - $ - $ - $ -
Licenses&Permits $ - $ - $ - $ -
Intergovernmental $ - $ - $ - $ -
Charges for Services $ 4,044,297 $ - $ - $ 4,044,297
Fines&Forfeitures $ - $ - $ - $ -
Interest Earnings $ 139,900 $ - $ - $ 139,900
Miscellaneous $ 5,000 $ - $ - $ 5,000
Other Financing Sources $ - $ - $ - $ -
Transfers In from Other Funds $ 601,000 $ - $ - $ 601,000
Total Resources $ 12,06 $ 400,000 $ 12,461,243
Requirements
Community Development $ - $ - $ - $ -
Community Services $ - $ - $ - $ -
Policy and Administration $ - $ - $ - $ -
Public Works $ 3,509,897 $ 6,010 $ - $ 3,515,907
Program Expenditures Total $ 3,509,897 $ 6,010 $ - $ 3,515,907
Debt Service $ - $ - $ - $ -
Loan to TCDA $ - $ - $ - $ -
Work-In-Progress $ 2,288,000 $ - $ 400,000 $ 2,688,000
Transfers to Other Funds $ 442,866 $ - $ - $ 442,866
Contingency $ 225,000 $ (6,010) $ - $ 218,990
Total Budget $ 6,465,763 $ - $ 400,000 $ 6,865,763
Reserve For Future Expenditure $ 5,595,480 $ - $ - $ 5,595,480
Total Requirements $ 12,061,243 $ - $ 400,000 $ 12,461,243
Exhibit B
Water Fund
FY 2021 Revised
Water Fund Revised Q2CM01 Q2PW02 Q2
Resources
Beginning Fund Balance $ 38,763,141 $ - - $ 38,763,141
Property Taxes $ - $ - $ - $ -
Franchise Fees $ - $ - $ - $ -
Special Assessments $ - $ - $ - $ -
Licenses&Permits $ 170,000 $ - $ - $ 170,000
Intergovernmental $ - $ - $ - $ -
Charges for Services $ 22,738,411 $ - $ - $ 22,738,411
Fines&Forfeitures $ - $ - $ - $ -
Interest Earnings $ 500,700 $ - $ - $ 500,700
Miscellaneous $ 50,000 $ - $ - $ 50,000
Other Financing Sources $ - $ - $ - $ -
Transfers In from Other Funds $ - $ - $ - $ -
Total Resources $ 62,222,252 $ - - $ 62,222,252
Requirements
Community Development $ - $ - $ - $ -
Community Services $ - $ - $ - $ -
Policy and Administration $ - $ - $ - $ -
Public Works $ 10,479,533 $ 8,012 $ (40,000) $ 10,447,545
Program Expenditures Total $ 10,479,533 $ 8,012 $ (40,000) $ 10,447,545
Debt Service $ - $ - $ - $ -
Loan to TCDA $ - $ - $ - $ -
Work-In-Progress $ - $ - $ - $ -
Transfers to Other Funds $ 23,067,947 $ - $ - $ 23,067,947
Contingency $ 425,000 $ (8,012) $ - $ 416,988
Total Budget $ 33,972,480 $ - $ (40,000) $ 33,932,480
Reserve For Future Expenditure $ 28,249,772 $ JIF $ 40,000 $ 28,289,772
Total Requirements $ 62,222,252 $ - $ - $ 62,222,252
Exhibit B
Water SDC Fund
FY 2021 Revised
Water SDC Fund Revised Q2PW02 Q2
Resources
Beginning Fund Balance $ 13,046,147 $ 40,000 $ 13,086,147
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Special Assessments $ - $ $ -
Licenses&Permits $ 1,870,435 $ - $ 1,870,435
Intergovernmental $ - $ - $ -
Charges for Services $ - $ - $ -
Fines&Forfeitures $ - $ - $ -
Interest Earnings $ 258,200 $ - $ 258,200
Miscellaneous $ - $ $ -
Other Financing Sources $ - $ $ -
Transfers In from Other Funds $ - $ - $ -
Total Resources $ 15,174,782 $ 40,000 $ 15,214,782
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 $ 4,390,268 $ 40,000 $ 4,430,268
Contingency $ - $ - $ -
Total Budget $ 4,390,268 $ 40,000 $ 4,430,268
Reserve For Future Expenditure $ 10,784,514 $ - $ 10,784,514
Total Requirements $ 15,174,782 $ 40,000 $ 15,214,782
Exhibit B
Water CIP Fund
FY 2021 Revised
Water CIP Fund Revised Q2PW02 Q2
Resources
Beginning Fund Balance $ 1,671,726 $ - $ 1,671,726
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 $ 10,868,000 $ 40,000 $ 10,908,000
Total Resources $ 12,539,726 $ 40,000 $ 12,579,726
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ - $ - $ -
Public Works $ - $ - $ -
Program Expenditures Total $ - $ - $ -
Debt Service $ - $ - $ -
Loan to TCDA $ - $ - $ -
Work-In-Progress $ 10,868,000 $ 40,000 $ 10,908,000
Transfers to Other Funds $ - $ - $ -
Contingency $ - $ - $ -
Total Budget $ 10,868,000 $ 40,000 $ 10,908,000
Reserve For Future Expenditure $ 1,671,726 $ - $ 1,671,726
Total Requirements $ 12,539,726 $ 40,000 $ 12,579,726
Exhibit B
Fleet/Property Management Fund
FY 2021 Revised
Fleet/Property Management Fund Revised Q2CM01 Q2
Resources
Beginning Fund Balance $ 811,214 $ Is 811,214
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $
Special Assessments $ - $ - $ -
Licenses&Permits $ - $ - $ -
Intergovernmental $ - $ - $ -
Charges for Services $ 3,196,366 $ - $ 3,196,366
Fines&Forfeitures $ - $ - $ -
Interest Earnings $ - $ - $ -
Miscellaneous $ 5,000 $ - $ 5,000
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ - $ - $ -
Total Resources $ 4,012,580 $ 4,012,580
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ 3,014,543 $ 3,882 $ 3,018,425
Public Works $ - $ - $ -
Program Expenditures Total $ 3,014,543 $ 3,882 $ 3,018,425
Debt Service $ - $ - $ -
Loan to TCDA $ - $ - $ -
Work-In-Progress $ - $ - $ -
Transfers to Other Funds $ 1,000 $ - $ 1,000
Contingency $ 125,000 $ (3,882) $ 121,118
Total Budget $ 3,140,543 $ - $ 3,140,543
Reserve For Future Expenditure $ 872,037 $ 872,037
Total Requirements $ 4,012,580 $ - $ 4,012,580
Exhibit B
Central Services Fund
FY 2021 Revised
Central Services Fund Revised Q2CM01 Q2FIS01 Q2FIS02 Q2
Resources
Beginning Fund Balance 1,996,623 $ - $ - $ - 1,996,623
Property Taxes $ - $ - $ - $ - $ -
Franchise Fees $ - $ - $ - $ - $
Special Assessments $ - $ - $ - $ - $ -
Licenses&Permits $ - $ - $ - $ - $ -
Intergovernmental $ - $ - $ - $ - $ -
Charges for Services $ 11,512,129 $ - $ - $ - $ 11,512,129
Fines&Forfeitures $ - $ - $ - $ - $ -
Interest Earnings $ - $ - $ - $ - $ -
Miscellaneous $ 90,000 $ - $ - $ - $ 90,000
Other Financing Sources $ - $ - $ - $ - $ -
Transfers In from Other Funds $ 874,819 $ - $ - $ 190,000 $ 1,064,819
Total Resources 14,473,571 $ - $ 190,000 $ 14,663,571
Requirements
Community Development $ - $ - $ - $ - $ -
Community Services $ - $ - $ - $ - $ -
Policy and Administration $ 12,354,748 $ 4,211 $ 10,000 $ 190,000 $ 12,558,959
Public Works $ - $ - $ - $ - $ -
Program Expenditures Total $ 12,354,748 $ 4,211 $ 10,000 $ 190,000 $ 12,558,959
Debt Service $ - $ - $ - $ - $ -
Loan to TCDA $ - $ - $ - $ - $ -
Work-In-Progress $ - $ - $ - $ - $ -
Transfers to Other Funds $ - $ - $ - $ - $ -
Contingency $ 94,000 $ (4,211) $ (10,000) $ - $ 79,789
Total Budget $ 12,448,748 $ - $ - $ 190,000 $ 12,638,748
Reserve For Future Expenditure $ 2,024,823 $ - - $ - $ 2,024,823
Total Requirements $ 14,473,571 $ - $ - $ 190,000 $ 14,663,571
Exhibit B
Non-Budgetary Impact Items
Q2FIS03 - Reduction of Computer Support Technician, 1.00 FTE, and increase Managed Help Desk coverage
Tigard IT has moved in the direction of Managed Help Desk Services for tier I and II services instead of staffing this role with a City of
Tigard employee. The recent contract with BridgeTech LLC has eliminated the need for the 1.0 FTE position within the IT division. This
request is to remove position number 6424-Computer Support Technician (1.0 FTE) from the FTE count for the IT division.All salary and
benefit funds associated with this position will be used in the current and subsequent fiscal years to fund the existing contract with
BridgeTech LLC.
FY 2020-21 Second Quarter Supplemental Budget Exhibit C
CIP 94048 Oak Street Property Acquisition
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.
Actuals Adopted Revised Revised Revised Revised Revised Revised
through Budget This Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project
FY2020 FY 2021 Change FY 2020 2022 2022 2023 2023 2024 2024 2025 2025 2026 2026 Total
Internal Expenses
Design and Engineering - -
Project Management 25,000 25,000 25,000
Construction Management - -
Total 25,000 25,000 25,000
External Expenses
Public Involvement - -
Land/Right of Way Acquisition 280,000 280,000 280,000
Design and Engineering 30,000 30,000 30,000
Environmental Perniit Comp. -
Construction 45,000 45,000 45,000
Contingency 20,000 20,000 20,000
Total 375,000 375,000 375,000
Total Project Expense 400,000 400,000 400,000
Revenue Funding Source
510-Stormwater Fund 400,000 400,000 400,000
Other Revenue Source
Total Project Revenues 400,000 400,000 400,000
RESOLUTION 21-02
Page 23
FY 2020-21 Second Quarter Supplemental Budget Exhibit C
CIP 96056 Water System Development Charge SDC Stud
The Water System Development Charges(SDCs)was last updated in 2010.The SDC methodology needs to be updated to include water master planning
information provided in 2014,2018 and 2021.
The study will review the capital improvement requirements to meet current and future growth development needs and review the curret water SDC
charges.
Actuals Adopted Revised Revised Revised Revised Revised Revised
through Budget This Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project
FY2020 FY 2021* Change FY 2020 2022 2022 2023 2023 2024 2024 2025 2025 2026 2026 Total
Internal Expenses
Design and Engineering -
Project Management
Construction Management
Total
External Expenses
Public Involvement
Land/Right of Way Acquisition
Design and Engineering 40,000 40,000 40,000
Environmental Permit Comp. -
Construction -
Contingency - -
Total 40,000 40,000 40,000
Total Project Expense 40,000 40,000 40,000
Revenue Funding Source
531-Water SDC Fund 40,000 40,000 40,000
Other Revenue Source
Total Project Revenues 40,000 40,000 40,000
RESOLUTION 21-02
Page 24
FY 2020-21 Second Quarter Supplemental Budget Exhibit C
CIP 95064 Frewing Street Sidewalk Infill-CDBG
Currently,pedestrians living adjacent to Frewing Street are forced to walk in the roadway.
Construct sidewalks,curbs,Americans with Disabilities Act(ADA)curb ramps and drainage improvements on Frewing Street between Pacific Highway and
Ash Avenue.Storm drainage work includes providing inlets to collect street runoff.The project will result in improved northbound pedestrian access to
shopping areas and bus stops on Pacific Highway and southbound access to the Tigard Civic Center and the Public Library.This supports the vision
statement in the City of Tigard's Strategic Plan:"The most walkable community in the Pacific Northwest..."
Actuals Adopted Revised Revised Revised Revised Revised Revised
through Budget This Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project
FY2020 FY 2021* Change FY 2020 2022 2022 2023 2023 2024 2024 2025 2025 2026 2026 Total
Internal Expenses
Design and Engineering - -
Project Management 20,000 21,000 39,000 60,000 80,000
Construction Management -
Total 20,000 21,000 39,000 60,000 80,000
External Expenses
Public Involvement - -
Land/Right of Way Acquisition 20,000 20,000 20,000
Design and Engineering 18,000 21,000 72,500 93,500 111,500
Environmental Permit Comp. 285,500 200,000 485,500 485,500
Construction 5,000 5,000 5,000
Contingency 50,000 47,000 97,000 97,000
Total 18,000 361,500 339,500 701,000 719,000
Total Project Expense 38,000 382,500 378,500 761,000 799,000
Revenue Funding Source
200-Gas Tax Fund 19,975 39,500 39,500 59,475
415-Transportation SDC Fund 313,921 313,921 313,921
Other Revenue Source - -
Community Dev.Block Grant 18,025 343,000 64,579 407,579 425,604
Total Project Revenues 38,000 382,500 378,500 761,000 799,000
RESOLUTION 21-02
Page 25
FY 2020-21 Second Quarter Supplemental Budget Exhibit C
CIP 95054 Hall Boulevard/Pfaffle Street New Traffic Signal
Currently drivers can experience difficulty pulling out from Pfaffle Street onto Hall Boulevard especially during the morning and evening commute hours.
Congestion has increased with recent development in the area and Hall Boulevard is difficult for pedestrians to cross.
This project will construct a new traffic signal with appropriate illumination,crosswalks and lengthening and separation of the turn lanes on Pfaffle Street.
The project will be complicated by the proximity to the Hall Boulevard/Highway 217 Bridge and the fact that Hall Boulevard is an ODOT-controlled facility
necessitating agency approval and permits.Completion of these improvements will increase safety for vehicles,pedestrians and cyclists using the
intersection or traveling to and from the nearby school,Pacific Highway and Washington Square Regional Center.
Actuals Adopted Revised Revised Revised Revised Revised Revised
through Budget This Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project
FY2020 FY 2021* Change FY 2020 2022 2022 2023 2023 2024 2024 2025 2025 2026 2026 Total
Internal Expenses
Design and Engineering - -
Project Management 3,500 3,500 3,500
Construction Management - -
Total 3,500 3,500 3,500
External Expenses
Public Involvement - -
Land/Right of Way Acquisition
Design and Engineering
Environmental Permit Comp. - -
Construction 25,000 35,400 60,400 60,400
Contingency 5,000 5,000 5,000
Total 25,000 40,400 65,400 65,400
Total Project Expense 28,500 40,400 68,900 68,900
Revenue Funding Source
415-Transportation SDC Fund 28,500 19,000 47,500 47,500
Non-Budgetary Impact
415-Transportation SDC Fund 21,400 21,400 21,400
Other Revenue Source - - - - - - - -
Total Project Revenues 28,500 40,400 68,900 68,900
RESOLUTION 21-02
Page 26
FY 2020-21 Second Quarter Supplemental Budget Exhibit C
CIP 95057 Fanno Creek Trail Alignment Stud Bonita Road to Tualatin River
This final section of the Fanno Creek Trail was originally envisioned as an on-street alignment on SW 74th Avenue. Subsequent review suggests the
constrained width of the SW 74th right of way will not readily accommodate widening for the trail. This study will involve local stakeholders and other
partners in evaluating alignment options along Fanno Creek and result in a recommended trail alignment.
Actuals Adopted Revised Revised Revised Revised Revised Revised
through Budget This Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project
FY2020 FY 2021* Change FY 2020 2022 2022 2023 2023 2024 2024 2025 2025 2026 2026 Total
Internal Expenses
Design and Engineering - -
Project Management 56,000 25,000 28,000 53,000 109,000
Construction Management -
Total 56,000 25,000 28,000 53,000 109,000
External Expenses
Public Involvement - -
Land/Right of Way Acquisition - -
Design and Engineering 89,385 91,615 20,000 111,615 201,000
Environmental Permit Comp. -
Construction - -
Contingency 10,000 10,000 10,000
Total 89,385 101,615 20,000 121,615 211,000
Total Project Expense 145,385 126,615 48,000 174,615 320,000
Revenue Funding Source
415-Transportation SDC Fund 51,000 60,000 60,000 111,000
425-Parks SDC Fund 48,000 48,000 48,000
Other Revenue Source - -
Metro-Local Dollars 94,385 66,615 66,615 161,000
Total Project Revenues 145,385 126,615 48,000 174,615 320,000
RESOLUTION 21-02
Page 27
FY 2020-21 Second Quarter Supplemental Budget Exhibit C
92056 Park System Master Plan Update
The Park System Master Plan Update will examine existing recreational facilities,programs,and services.Community involvement and public input
will be a critical component of the process that will help determine the current and future parks and recreation service levels.The updated plan will
prioritize the needs and desires for upgrading and creating new facilities and services. The plan will focus on developing areas of Tigard such as
River Terrace and the Tigard Triangle in addition to existing parks and recreation services.
Actuals Adopted Revised Revised Revised Revised Revised Revised
through Budget Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project
FY2020 FY 2021 This Change FY 2020 2022 2022 2023 2023 2024 2024 2025 2025 2026 2026 Total
Internal Expenses
Design and Engineering - -
Project Management 27,000 30,000 15,000 45,000 72,000
Construction Management - -
Total 27,000 30,000 15,000 45,000 72,000
External Expenses
Public Involvement - -
Land/Right of Way Acquisition - -
Design and Engineering 77,000 133,000 10,000 143,000 220,000
Environmental Permit Comp. -
Construction - -
Contingency 10,000 10,000 10,000
Total 77,000 143,000 10,000 153,000 230,000
Total Project Expense 104,000 173,000 25,000 198,000 302,000
Revenue Funding Source
425-Parks SDC Fund 104,000 173,000 25,000 198,000 302,000
Other Revenue Source
Total Project Revenues 104,000 173,000 25,000 198,000 302,000
RESOLUTION 21-02
Page 28
FY 2020-21 Second Quarter Supplemental Budget Exhibit C
95001 Pavement Management Program
This project,funded by the Street Maintenance Fee,provides for the preservation or replacement of the asphaltic concrete by overlays,crack
sealing or slurry sealing.Streets maintenance treatments are determined based on traffic volume,pavement condition,opportunities to combine
with other projects and other factors in order to maximize the utilization of the funding available.This results in rehabilitation and preventive
maintenance on about 15 miles of streets each year to extend the usable service life of the pavement.This program also annually upgrades some
curb ramps to current Americans with Disabilities Act(ADA)standards when they are impacted by the overlay projects.
Actuals Adopted Revised Revised Revised Revised Revised Revised
through Budget Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Project
FY2020 FY 2021 This Change FY 2020 2022 2022 2023 2023 2024 2024 2025 2025 2026 2026 Total
Internal Expenses
Design and Engineering - -
Project Management 100,000 100,000 100,000
Construction Management - -
Total 100,000 100,000 100,000
External Expenses
Public Involvement - -
Land/Right of Way Acquisition
Design and Engineering -
Environmental Permit Comp. -
Construction 2,640,000 (75,000) 2,565,000 2,565,000
Contingency - -
Total 2,640,000 75,000 2,565,000 2,565,000
Total Project Expense 2,740,000 75,000 2,665,000 2,665,000
Revenue Funding Source
412-Street Maintenance Fund 2,740,000 (75,000) 2,665,000 2,665,000
Other Revenue Source
Total Project Revenues 2,740,000 75,000 2,665,000 2,665,000
RESOLUTION 21-02
Page 29