Resolution No. 17-21 CITY OF TIGARD, OREGON
TIGARD CITY COUNCIL
RESOLUTION NO. 17- ,21
A RESOLUTION TO ADOPT THE FY 2017 THIRD 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 2017 budget was adopted;
and
WHEREAS, the city recognizes approximately $2,261,269 of unanticipated budget in operations and transfers;
and
WHEREAS, the increase in budget is offset by unanticipated fund balance, miscellaneous revenue, and
contingency.
NOW,THEREFORE,BE IT RESOLVED by the Tigard City Council that:
SECTION 1: The FY 2016-17 Budget is hereby amended as detailed in Exhibit A.
SECTION: This resolution is effective immediately upon passage.
PASSED: This oZ f`` day of 2017.
Mayou City of Tigard
ATTEST:
City Recorder-City of Tigard
RESOLUTION NO. 16-02 J
Page 1
Q3FIN01 - Software Licensing and Storage Hardware Upgrade - $214,519
T has taken a deep look into software licensing and software maintenance agreements. This evaluation has
discovered a large annual deficit in software and software maintenance charges for all existing software the city
Blies on for daily business. Also through this process,we have a discovered a major non-compliant licensing
issue with our Microsoft Enterprise Licensing Agreement. This agreement licenses all of our servers, desktop,
nd laptop computers with the needed Microsoft software and operating systems for internal use, and external
facing data. If not brought up to compliance the city will be forced to reduce software that city staff relies on
for daily business and remote connections, eliminate public facing data (GIS,Permitting,Payments), and will be
pen to large fines for non-compliant software licensing. In addition the city is finding itself in the position of
of having adequate storage systems for the growing data. The storage hardware option will allow us to grow
e storage in the short term to meet the growing data demands.
Revised Q2 Q3 Revised Q3
Fund 1 of 1 Budget Amendment Budget
Central Services
Resources Beginning Fund Balance $ 910,819 $ 107,570 $ 1,018,389
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Licenses & Permits $ 35,566 $ - $ 35,566
Intergovernmental $ 70,600 $ - $ 70,600
Charges for Services $ 7,447,703 $ - $ 7,447,703
Fines &Forfeitures $ - $ - $ -
Interest Earnings $ 22,593 $ - $ 22,593
Miscellaneous $ 13,400 $ - $ 13,400
Other Financing Sources $ - $ -
Transfers In from Other Funds $ 642,701 $ - $ 642,701
Total Resources $ 9,143,382 $ 107,570 $ 9,250,952
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ 8,643,849 $ 214,519 $ 8,858,368
Public Works $ - $ - $ -
Program Expenditures Total $ 8,643,849 $ 214,519 $ 8,858,368
Debt Service $ - $ - $ -
Loans $ - $ - $ -
Work-In-Progress $ - $ - $ -
Transfers to Other Funds $ - $ - $ -
Contingency $ 250,000 $ (106,949) $ 143,051
Total Budget $ 8,893,849 $ 107,570 $ 9,001,419
Reserve For Future Expenditure $ 249,533 $ - $ 249,533
Total Requirements $ 9,143,382 $ 107,570 $ 9,250,952
FY17 Q3 - Exhibit A with part 1 of B
Q3FIN02 - Utility Billing FTE Increase - $25,859
Over the past five years Utility Billing services have increased yet staff levels have remained the same
By extending two key staff positions from .80 to 1.00 Utility Billing will have the resources necessary t
maintain key services to our customers. Without the increase in hours the employees will be required t
work longer hours at overtime rates.
Revised Q2 Q3 Revised Q3
Fund 1 of 4 Budget Amendment Budget
Central Services
Resources Beginning Fund Balance $ 910,819 $ - $ 910,819
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Licenses &Permits $ 35,566 $ - $ 35,566
Intergovernmental $ 70,600 $ - $ 70,600
Charges for Services $ 7,447,703 $ 25,859 $ 7,473,562
Fines &Forfeitures $ - $ - $ -
Interest Earnings $ 22,593 $ - $ 22,593
Miscellaneous $ 13,400 $ - $ 13,400
Other Financing Sources $ - $ -
Transfers In from Other Funds $ 642,701 $ - $ 642,701
Total Resources $ 9,143,382 $ 25,859 $ 9,169,241
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ 8,643,849 $ 25,859 $ 8,669,708
Public Works $ - $ - $ -
Program Expenditures Total $ 8,643,849 $ 25,859 $ 8,669,708
Debt Service $ - $ - $ -
Loans $ - $ - $ -
Work-In-Progress $ - $ - $ -
Transfers to Other Funds $ - $ - $ -
Contingency $ 250,000 $ - $ 250,000
Total Budget $ 8,893,849 $ 25,859 $ 8,919,708
Reserve For Future Expenditure $ 249,533 $ - $ 249,533
Total Requirements $ 9,143,382 $ 25,859 $ 9,169,241
Q3FIN02 - Utility Billing FTE Increase - $25,859
Revised Q2 Q3 Revised Q3
Fund 2 of 4 Budget Amendment Budget
Sanitary Sewer Fund
Resources Beginning Fund Balance $ 3,609,850 $ - $ 3,609,850
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Licenses &Permits $ 42,200 $ - $ 42,200
Intergovernmental $ 383,000 $ - $ 383,000
Charges for Services $ 1,664,796 $ - $ 1,664,796
Fines &Forfeitures $ - $ - $ -
Interest Earnings $ 100,333 $ - $ 100,333
Miscellaneous $ 143,091 $ - $ 143,091
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ - $ - $ -
Total Resources $ 5,943,270 $ - $ 5,943,270
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ - $ - $ -
Public Works $ 2,242,353 $ 5,090 $ 2,247,443
Program Expenditures Total $ 2,242,353 $ 5,090 $ 2,247,443
Debt Service $ - $ - $ -
Loans $ - $ - $ -
Work-In-Progress $ 1,160,111 $ - $ 1,160,111
Transfers to Other Funds $ 164,726 $ - $ 164,726
Contingency $ 338,900 $ (5,090) $ .333,810
Total Budget $ 3,906,090 $ - $ 3,906,090
Reserve For Future Expenditure $ 2,037,180 $ - $ 2,037,180
Total Requirements $ 5,943,270 $ - $ 5,943,270
Q3FIN02 - Utilijy Billing FTE Increase - $25,859
Revised Q2 Q3 Revised Q3
Fund 3 of 4 Budget Amendment Budget
Stormwater Fund
Resources Beginning Fund Balance $ 4,396,232 $ - $ 4,396,232
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Licenses &Permits $ - $ - $ -
Intergovernmental $ - $ - $ -
Charges for Services $ 2,676,445 $ - $ 2,676,445
Fines &Forfeitures $ - $ - $ -
Interest Earnings $ 7,936 $ - $ 7,936
Miscellaneous $ 3,100 $ - $ 3,100
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ 93,500 $ - $ 93,500
Total Resources $ 7,177,213 $ - $ 7,177,213
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ - $ - $ -
Public Works $ 2,007,369 $ 1,386 $ 2,008,755
Program Expenditures Total $ 2,007,369 $ 1,386 $ 2,008,755
Debt Service $ - $ - $ -
Loans $ - $ - $ -
Work-In-Progress $ 1,479,611 $ - $ 1,479,611
Transfers to Other Funds $ 229,566 $ - $ 229,566
Contingency $ 192,450 $ (1,386) $ 191,064
Total Budget $ 3,908,996 $ - $ 3,908,996
Reserve For Future Expenditure $ 3,268,217 $ - $ 3,268,217
Total Requirements $ 7,177,213 $ - $ 7,177,213
Q3FIN02 - Utility Billing FTE Increase - $25,859
Revised Q2 Q3 Revised Q3
Fund 4 of 4 Budget Amendment Budget
Water Fund
Resources Beginning Fund Balance $ 6,795,798 $ - $ 6,795,798
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Licenses &Permits $ 74,808 $ - $ 74,808
Intergovernmental $ - $ - $ -
Charges for Services $ 19,667,528 $ - $ 19,667,528
Fines & Forfeitures $ - $ - $ -
Interest Earnings $ 30,644 $ - $ 30,644
Miscellaneous $ 10,933 $ - $ 10,933
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ 58,751 $ - $ 58,751
Total Resources $26,638,462 $ - $26,638,462
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ - $ - $ -
Public Works $ 7,306,263 $ 19,382 $ 7,325,645
Program Expenditures Total $ 7,306,263 $ 19,382 $ 7,325,645
Debt Service $ - $ - $ -
Loans $ - $ - $ -
Work-In-Progress $ - $ - $ -
Transfers to Other Funds $ 11,406,027 $ - $ 11,406,027
Contingency $ 43,980 $ (19,382) $ 24,598
Total Budget $18,756,270 $ - $18,756,270
Reserve For Future Expenditure $ 7,882,192 $ - $ 7,882,192
Total Requirements $26,638,462 $ - $26,638,462
03CM01 - Leave Accrual- $36,000
This will provide the appropriations for payment of accruals due at the time of staff retirement. This is
anticipated to be$36,000.
Revised Q2 Q3 Revised Q3
Fund 1 of 1 Budget Amendment Budget
Central Services
Resources Beginning Fund Balance $ 910,819 $ - $ 910,819
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Licenses & Permits $ 35,566 $ - $ 35,566
Intergovernmental $ 70,600 $ - $ 70,600
Charges for Services $ 7,447,703 $ - $ 7,447,703
Fines &Forfeitures $ - $ - $ -
Interest Earnings $ 22,593 $ - $ 22,593
Miscellaneous $ 13,400 $ - $ 13,400
Other Financing Sources $ - $ -
Transfers In from Other Funds $ 642,701 $ - $ 642,701
Total Resources $9,143,382 $ - $9,143,382
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ 8,643,849 $ 36,000 $ 8,679,849
Public Works $ - $ - $ -
Program Expenditures Total $8,643,849 $ 36,000 $8,679,849
Debt Service $ - $ - $ -
Loans $ - $ - $ -
Work-In-Progress $ - $ - $ -
Transfers to Other Funds $ - $ - $ -
Contingency $ 250,000 $ (36,000) $ 214,000
Total Budget $8,893,849 $ - $8,893,849
Reserve For Future Expenditure $ 249,533 $ - $ 249,533
Total Requirements $9,143,382 $ - $9,143,382
Q3PD01 -Vehicle #14-827 Replacement- $32,045
Police Vehicle #14-827 was totaled during a pursuit. The vehicle has been declared 'totaled' and the
City's insurance carrier, CIS, will provide the majority of funding of the replacement vehicle. The City
will likely bare only the cost of police equipment reinstallation which can be absorbed by the
department's current appropriations.
Revised Q2 Q3 Revised Q3
Fund 1 of 1 Budget Amendment Budget
General Fund
Resources Beginning Fund Balance $ 11,191,655 $ - $ 11,191,655
Property Taxes $ 14,762,850 $ - $ 14,762,850
Franchise Fees $ 6,112,431 $ - $ 6,112,431
Licenses &Permits $ 3,375,552 $ - $ 3,375,552
Intergovernmental $ 5,784,415 $ - $ 5,784,415
Charges for Services $ 2,568,504 $ - $ 2,568,504
Fines &Forfeitures $ 807,789 $ - $ 807,789
Interest Earnings $ 103,722 $ - $ 103,722
Miscellaneous $ 56,432 $ 32,045 $ 88,477
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds S 54,125 S - $ 54,125
Total Resources $44,817,475 $ 32,045 $44,849,520
Requirements
Community Development $ 3,827,643 $ - $ 3,827,643
Community Services $ 23,221,480 $ 32,045 $ 23,253,525
Policy and Administration $ 837,595 $ - $ 837,595
Public Works $ 4,372,438 $ - $ 4,372,438
Program Expenditures Total $32,259,156 $ 32,045 $32,291,201
Debt Service $ - $ - $ -
Loans $ - $ - $ -
Work-In-Progress $ - $ - $ -
Transfers to Other Funds $ 1,965,439 $ - $ 1,965,439
Contingency $ 965,000 $ - $ 965,000
Total Budget $35,189,595 $ 32,045 $35,221,640
Reserve For Future Expenditure $ 9,627,880 $ - $ 9,627,880
Total Requirements $44,817,475 $ 32,045 $44,849,520
Q3PW01-Project Coordinator for Water Projects - $19,000
The proposed Engineering Division Water Project Coordinator will assist with the large Water Program
in the Proposed Six-Year Capital Improvement Plan. The immediate need is internal support for the
Senior Project Engineer who is responsible for the completion of the $20 Million dollar Cach Reservoir
and Pump Station Design project.
Mid-term and long-term,the position will continue as support on the anticipated projects that develop
from the Water Master Plan. These projects will include earthquake resiliency,an evaluation of the
ding water system and other water projects deemed necessary from continuing population growth.
The FY 17 impact is for up to six week of the position being filled. The position is reflected in the FY
18 proposed budget.
Revised Q2 Q3 Revised Q3
Fund 1 of 1 Budget Amendment Budget
General Fund
Resources Beginning Fund Balance $ 11,191,655 $ - $ 11,191,655
Property Taxes $ 14,762,850 $ - $ 14,762,850
Franchise Fees $ 6,112,431 $ - $ 6,112,431
Licenses&Permits $ 3,375,552 $ - $ 3,375,552
Intergovernmental $ 5,784,415 $ - $ 5,784,415
Charges for Services $ 2,568,504 $ - $ 2,568,504
Fines&Forfeitures $ 807,789 $ - $ 807,789
Interest Earnings $ 103,722 $ - $ 103,722
Miscellaneous $ 56,432 $ - $ 56,432
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ 54,125 $ - $ 54,125
Total Resources $44,817,475 $ - $44,817,475
Requirements
Community Development $ 3,827,643 $ - $ 3,827,643
Community Services $ 23,221,480 $ - $ 23,221,480
Policy and Administration $ 837,595 $ - $ 837,595
Public Works $ 4,372,438 $ 19,000 $ 4,391,438
Program Expenditures Total $32,259,156 $ 19,000 $32,278,156
Debt Service $ - $ - $ -
Loans $ - $ - $ -
Work-In-Progress $ - $ - $ -
Transfers to Other Funds $ 1,965,439 $ - $ 1,965,439
Contingency $ 965,000 $ (19,000) $ 946,000
Total Budget $35,189,595 $ - $35,189,595
Reserve For Future Expenditure $ 9,627,880 $ - $ 9,627,880
Total Requirements $44,817,475 $ - $44,817,475
Q3PW02 - Lighter, Quicker, Cheaper- 130th Stairs - $19,860
This proposal is to replace the deteriorating railroad tie steps that connect several neighborhood trails
between 13728 and 13746 SW 130`'Place. These stairs present a high risk factor due to the likelihood of
someone's foot going through the rotting railroad ties and causing a fall. The lack of a sturdy rail may
crease the severity of injury resulting from a fall.
Revised Q2 Q3 Revised Q3
Fund 1 of 2 Budget Amendment Budget
General Fund
Resources Beginning Fund Balance $ 11,191,655 $ - $ 11,191,655
Property Taxes $ 14,762,850 $ - $ 14,762,850
Franchise Fees $ 6,112,431 $ - $ 6,112,431
Licenses &Permits $ 3,375,552 $ - $ 3,375,552
Intergovernmental $ 5,784,415 $ - $ 5,784,415
Charges for Services $ 2,568,504 $ - $ 2,568,504
Fines &Forfeitures $ 807,789 $ - $ 807,789
Interest Earnings $ 103,722 $ - $ 103,722
Miscellaneous $ 56,432 $ - $ 56,432
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds S 54,125 $ - $ 54,125
Total Resources $44,817,475 $ - $44,817,475
Requirements
Community Development $ 3,827,643 $ - $ 3,827,643
Community Services $ 23,221,480 $ - $ 23,221,480
Policy and Administration $ 837,595 $ - $ 837,595
Public Works $ 4,372,438 $ - $ 4,372,438
Program Expenditures Total $32,259,156 $ - $32,259,156
Debt Service $ - $ - $ -
Loans $ - $ - $ -
Work-In-Progress $ - $ - $ -
Transfers to Other Funds $ 1,965,439 $ 19,860 $ 1,985,299
Contingency $ 965,000 $ (19,860) $ 945,140
Total Budget $35,189,595 $ - $35,189,595
Reserve For Future Expenditure $ 9,627,880 $ - $ 9,627,880
Total Requirements $44,817,475 $ - $44,817,475
Q3PW02 - Lighter, Quicker, Cheaper- 130th Stairs - $19,860
Revised Q2 Q3 Revised Q3
Fund 2 of 2 Budget Amendment Budget
Parks Utility Fund
Resources Beginning Fund Balance $ 156,757 $ - $ 156,757
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Licenses &Permits $ - $ - $ -
Intergovernmental $ - $ - $ -
Charges for Services $ 1,000,000 $ - $ 1,000,000
Fines &Forfeitures $ - $ - $ -
Interest Earnings $ - $ - $ -
N iscellaneous $ - $ - $ -
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ 1,535,000 $ 19,860 $ 1,554,860
Total Resources $ 2,691,757 $ 19,860 $ 2,711,617
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ - $ - $ -
Public Works $ 2,470,432 $ 19,860 $ 2,490,292
Program Expenditures Total $ 2,470,432 $ 19,860 $ 2,490,292
Debt Service $ - $ - $ -
Loans $ - $ - $ -
Work-In-Progress $ - $ - $ -
Transfers to Other Funds $ - $ - $ -
Contingency $ 90,150 $ - $ 90,150
Total Budget $ 2,560,582 $ 19,860 $ 2,580,442
Reserve For Future Expenditure $ 131,175 $ - $ 131,175
Total Requirements $ 2,691,757 $ 19,860 $ 2,711,617
Q3PW03 -Water Transfers - $2,095,795
This transfer is needed to reconcile the water CIP fund. At the conclusion of FY2016 project
payments for the LO/Tigard Water Partnership project were made in late August from the Water
IP Fund. The corresponding transfers from the Water Fund and the Water SDC Fund to the
Water CIP Fund were not made prior to the end of the fiscal year,leaving the Water CIP Fund short
y nearly$2.1 million. This budget amendment will carryforward the appropriations from FY16 to
FY 17 to make the Water CIP Fund whole from a cash basis. There is no impact the appropriations
the Water CIP Fund for FY17.
Revised Q2 Q3 Revised Q3
Fund 1 of 2 Budget Amendment Budget
Water Fund
Resources Beginning Fund Balance $ 6,795,798 $ 1,312,035 $ 8,107,833
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Licenses & Permits $ 74,808 $ - $ 74,808
Intergovernmental $ - $ - $ -
Charges for Services $ 19,667,528 $ - $ 19,667,528
Fines &Forfeitures $ - $ - $ -
Interest Earnings $ 30,644 $ - $ 30,644
Miscellaneous $ 10,933 $ - $ 10,933
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ 58,751 $ - $ 58,751
Total Resources $26,638,462 $ 1,312,035 $27,950,497
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ - $ - $ -
Public Works $ 7,306,263 $ - $ 7,306,263
Program Expenditures Total $ 7,306,263 $ - $ 7,306,263
Debt Service $ - $ - $ -
Loans $ - $ - $ -
Work-In-Progress $ - $ - $ -
Transfers to Other Funds $ 11,406,027 $ 1,312,035 $ 12,718,062
Contingency S 43,980 $ - $ 43,980
Total Budget $18,756,270 $ 1,312,035 $20,068,305
Reserve For Future Expenditure $ 7,882,192 $ - $ 7,882,192
Total Requirements $26,638,462 $ 1,312,035 $27,950,497
Q3PW03 -Water Transfers - $2,095,795
Revised Q2 Q3 Revised Q3
Fund 2 of 2 Budget Amendment Budget
Water SDC Fund
Resources Beginning Fund Balance $ 1,746,414 $ 783,760 $ 2,530,174
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Licenses &Permits $ 2,227,973 $ - $ 2,227,973
Intergovernmental $ - $ - $ -
Charges for Services $ - $ - $ -
Fines &Forfeitures $ - $ - $ -
Interest Earnings $ 233 $ - $ 233
Miscellaneous $ - $ - $ -
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ - $ - $ -
Total Resources $ 3,974,620 $ 783,760 $ 4,758,380
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ - $ - $ -
Public Works $ - $ - $ -
Program Expenditures Total $ - $ - $ -
Debt Service $ - $ - $ -
Loans $ - $ - $ -
Work-In-Progress $ - $ - $ -
Transfers to Other Funds $ 2,720,960 $ 783,760 $ 3,504,720
Contingency $ 100,000 $ - $ 100,000
Total Budget $ 2,820,960 $ 783,760 $ 3,604,720
Reserve For Future Expenditure $ 1,153,660 $ - $ 1,153,660
Total Requirements $ 3,974,620 $ 783,760 $ 4,758,380
Q3CM02 - FTE Changes with No Budget Impact (LibraM Human Resources, Central Servcies�
Zero Budget Impact FTE Changes—
Central Services—Grounds Maintenance (1.00 FTE Add) and Graphics (0.50 FTE Add)
The Facilities Division is requesting an additional FTE whose primary focus will be to maintain the
ounds of city-owned properties. Central Services has continued to use seasonal staff with
disappointing results. In the Facilities Division's FY 16-17 budget $53,981 was budgeted for seasonal
staff. The one year cost for a Utility Worker I 1.00 FTE is approximately $59,737. We are
recommending the position be funded by using budgeted funds approved for seasonal staff as well as
5,756 out of contractual services. Additionally, Central Services would like to hire a part-time
Graphics Design positions rather than contract professionally for the position. This would be zero
budget impact as it would use already existing appropriations in the Professional/Contractual line item.
uman Resources—0.10 FTE Department Increase
The requested Human Resources Assistant FTE increase from .50 to .80 is a budget neutral reallocation
from within the Human Resources and Risk Management Division budgets. This change comes with a
corresponding decrease in the Human Resources Specialist (Recruitment) position from a 1.0 FTE to a
.80 FTE. This reflects better the needs of the department and comes with no additional budgetary
requirement.
Library—Technical Services (0.20 FTE Add to Acquisitions Supervisor)
n additional 0.2 FTE is requested to make the Acquisitions Supervisor in Technical Services 1.0 FTE.
This position as a supervisor has a lot of responsibilities and tasks that can be more effectively
accomplished during a full work week. In addition, being available to staff and public in the
supervisory role. The amount of this request is $13,289, including salary and benefits. This amount is
achieved by reallocation of money within the Library budget and therefore this request is budge
neutral.