Resolution No. 18-06 CITY OF TIGARD, OREGON
TIGARD CITY COUNCIL
RESOLUTION NO. 18-0&
A RESOLUTION TO ADOPT THE FY 2018 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 2018 budget was adopted;
and
WHEREAS, the city recognizes approximately $3,493,724 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 2017-18 Budget is hereby amended as detailed in Exhibit A.
SECTION: This resolution is effective immediately upon passage.
J
PASSED: This day of Q4 A If 4 018.
Mwrr- i of Tigard
cow C PR• �l� d�
ATTEST:
City Recorder-City of Tigard
RESOLUTION NO. 18-0 6
Page 1
Exhibit A
02PD01- Insurance Reimbursement
$16,500-A Traffic Unit officer was responding to a call on his motorcycle with his lights and sirens deployed
when he was struck by a vehicle that was changing lanes in order to get out of his way.The collision,which
occurred on Hwy 99(northbound)near Main Street,resulted in such extensive damage to the motorcycle(#15-
833)that it has been deemed a total loss. Our insurance carrier,CIS,will reimburse the City for a portion of the
replacement cost.
$2,320-A K9 Police dog,Rico,was injured during a training exercise resulting in a fractured toe,which required
surgery. Rico has recovered from his injury and was able complete his certification training. He was available for
his duty by the end of October. Our insurance carrier,CIS,riembursed the PD for a portion of the expenses
related to Rico's surgery.
FY 2018 Q2 Revised
General Fund Revised Q1 Amendment Q2
Resources
Beginning Fund Balance $ 14,755,111 $ - $ 14,755,111
Property Taxes $ 15,359,468 $ - $ 15,359,468
Franchise Fees $ 6,238,652 $ - $ 6,238,652
Special Assessments $ - $ - $ -
Licenses&Permits $ 2,328,630 $ - $ 2,328,630
Intergovernmental $ 6,074,334 $ - $ 6,074,334
Charges for Services $ 2,783,381 $ - $ 2,783,381
Fines& Forfeitures $ 692,476 $ - $ 692,476
Interest Earnings $ 103,722 $ - $ 103,722
Miscellaneous $ 90,432 $ 18,820 $ 109,252
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ - $ - $ -
Total Resources $ 48,426,206 $ 18,820 $ 48,445,026
Requirements
Community Development $ 4,085,616 $ - $ 4,085,616
Community Services $ 23,939,436 $ 18,820 $ 23,958,256
Policy and Administration $ 866,598 $ - $ 866,598
Public Works $ 4,924,851 $ - $ 4,924,851
Program Expenditures Total $ 33,816,501 $ 18,820 $ 33,835,321
Debt Service $ - $ - $ -
Loan to CCDA $ 41,000 $ - $ 41,000
Work-In-Progress $ - $ - $ -
Transfers to Other Funds $ 1,913,426 $ - $ 1,913,426
Contingency $ 1,022,500 $ - $ 1,022,500
Total Budget $ 36,793,427 $ 18,820 $ 36,812,247
Reserve For Future Expenditure $ 11,632,779 $ - $ 11,632,779
Total Requirements $ 48,426,206 $ 18,820 $ 48,445,026
Exhibit A
02PD02 -Training Budget Carry Forward
The PD purchased online training classes on cell phone forensics for three detectives. The courses were not
completed by the end of June and the costs must roll into FY 2017-18.The PD did not budget for this expense
in the current year and would like to carryforward the unused funding from FY 2016-17 in order to match the
expenditure.
FY 2018 Q2 Revised
General Fund Revised Q1 Amendment Q2
Resources
Beginning Fund Balance $ 14,755,111 $ 9,870 $ 14,764,981
Property Taxes $ 15,359,468 $ - $ 15,359,468
Franchise Fees $ 6,238,652 $ - $ 6,238,652
Special Assessments $ - $ - $ -
Licenses &Permits $ 2,328,630 $ - $ 2,328,630
Intergovernmental $ 6,074,334 $ - $ 6,074,334
Charges for Services $ 2,783,381 $ - $ 2,783,381
Fines &Forfeitures $ 692,476 $ - $ 692,476
Interest Earnings $ 103,722 $ - $ 103,722
Miscellaneous $ 90,432 $ - $ 90,432
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ - $ - $ -
Total Resources $ 48,426,206 $ 9,870 $ 48,436,076
Requirements
Community Development $ 4,085,616 $ - $ 4,085,616
Community Services $ 23,939,436 $ 9,870 $ 23,949,306
Policy and Administration $ 866,598 $ - $ 866,598
Public Works $ 4,924,851 $ - $ 4,924,851
Program Expenditures Total $ 33,816,501 $ 9,870 $ 33,826,371
Debt Service $ - $ - $ -
Loan to CCDA $ 41,000 $ - $ 41,000
Work-In-Progress $ - $ - $ -
Transfers to Other Funds $ 1,913,426 $ - $ 1,913,426
Contingency $ 1,022,500 $ - $ 1,022,500
Total Budget $ 36,793,427 $ 9,870 $ 36,803,297
Reserve For Future Expenditure $ 11,632,779 $ - $ 11,632,779
Total Requirements $ 48,426,206 $ 9,870 $ 48,436,076
Exhibit A
02PD03-Overtime reimbursement funded by various Federal Grants
Overtime expenses funded by various Federal Grant sources.
*$10,359-FY 2017-18 Safety Belt enforcement blitzes funded by Federal grant administered by ODOT.
*$10,431-FY 2017-18 DUII high visibility enforcement funded by Federal grant administered by ODOT via
Oregon Impact,a non-profit service organization.
*$1,500-FY 2017-18 Pedestrian Safety(crosswalk)enforcement funded by Federal grant administered by
ODOT via Oregon Impact.
*$3,000-FY 2017-18 OLCC minor decoy missions in collaboration with OLCC inspectors funded by Fderal grant
administered by Washington County.
*$1,744-FY 2017-18 IPCE missions funded by Federal Dept of Justice grant funds. Portland Police Bureau is
the main recipient and Tigard is a subrecipient.
FY 2018 Q2 Revised
General Fund Revised Q1 Amendment Q2
Resources
Beginning Fund Balance $ 14,755,111 $ - $ 14,755,111
Property Taxes $ 15,359,468 $ - $ 15,359,468
Franchise Fees $ 6,238,652 $ - $ 6,238,652
Special Assessments $ - $ - $ -
Licenses&Permits $ 2,328,630 $ - $ 2,328,630
Intergovernmental $ 6,074,334 $ 27,034 $ 6,101,368
Charges for Services $ 2,783,381 $ - $ 2,783,381
Fines&Forfeitures $ 692,476 $ $ 692,476
Interest Earnings $ 103,722 $ - $ 103,722
Miscellaneous $ 90,432 $ - $ 90,432
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ - $ - $ -
Total Resources $ 48,426,206 $ 27,034 $ 48,453,240
Requirements
Community Development $ 4,085,616 $ - $ 4,085,616
Community Services $ 23,939,436 $ 27,034 $ 23,966,470
Policy and Administration $ 866,598 $ - $ 866,598
Public Works $ 4,924,851 $ - $ 4,924,851
Program Expenditures Total $ 33,816,501 $ 27,034 $ 33,843,535
Debt Service $ - $ - $ -
Loan to CCDA $ 41,000 $ - $ 41,000
Work-In-Progress $ - $ - $ -
Transfers to Other Funds $ 1,913,426 $ - $ 1,913,426
Contingency $ 1,022,500 $ - $ 1,022,500
Total Budget $ 36,793,427 $ 27,034 $ 36,820,461
Reserve For Future Expenditure $ 11,632,779 $ - $ 11,632,779
Total Requirements $ 48,426,206 $ 27,034 $ 48,453,240
Exhibit A
02PW01 - Replacement of Tiger Mower
In early fall,the existing Tiger Mower experienced a catastrophic failure.The mower is over 20 years old and the cost
to repair the mower will exceed the value of the mower.The decision was made in Q1 to move this request to Q2 to
allow time to purchase and onboard the new mower before Spring of 18 when it will be needed.To complete work
this fall,the city borrowed a mower from Lake Oswego.
FY 2018 Q2 Revised
Gas Tax Fund Revised Q1 Amendment Q2
Resources
Beginning Fund Balance $ 2,374,799 $ - $ 2,374,799
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Special Assessments $ - $ - $ -
Licenses &Permits $ 68,974 $ - $ 68,974
Intergovernmental $ 3,201,114 $ - $ 3,201,114
Charges for Services $ - $ - $ -
Fines &Forfeitures $ - $ - $ -
Interest Earnings $ 55,732 $ - $ 55,732
Miscellaneous $ 62,818 $ - $ 62,818
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ 150,000 $ - $ 150,000
Total Resources $ 5,913,437 $ - $ 5,913,437
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ - $ - $ -
Public Works $ 2,331,702 $ 110,000 $ 2,441,702
Program Expenditures Total $ 2,331,702 $ 110,000 $ 2,441,702
Debt Service $ 585,000 $ - $ 585,000
Loan to CCDA $ - $ - $ -
Work-In-Progress $ - $ - $ -
Transfers to Other Funds $ 1,498,487 $ - $ 1,498,487
Contingency $ 173,000 $ (110,000) $ 63,000
Total Budget $ 4,588,189 $ - $ 4,588,189
Reserve For Future Expenditure $ 1,325,248 $ - $ 1,325,248
Total Requirements $ 5,913,437 $ - $ 5,913,437
Exhibit A
02PW02-Lake Oswego/Tigard Water Partnership
The LOT Water Partnership project is in its final year.This request carries forward prior year's unused appropriation
to pay final partnership invoices for project completion.This also provides for the property true up required by the
project in the amount of$311,000.
Fund 1 of 2 FY 2018 Q2 Revised
Water Fund Revised Q1 Amendment Q2
Resources
Beginning Fund Balance $ 15,744,833 $ 1,700,000 $ 17,444,833
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Special assessments $ - $ - $ -
Licenses&Permits $ 74,986 $ - $ 74,986
Intergovernmental $ - $ - $ -
Charges for Services $ 20,496,907 $ - $ 20,496,907
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 $ 36,417,054 $ 1,700,000 $ 38,117,054
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and administration $ - $ - $ -
Public Works $ 6,898,886 $ - $ 6,898,886
Program Expenditures Total $ 6,898,886 $ - $ 6,898,886
Debt Service $ - $ - $ -
Loan to CCDA $ - $ - $ -
Work-In-Progress $ 40,000 $ - $ 40,000
Transfers to Other Funds $ 17,457,159 $ 1,700,000 $ 19,157,159
Contingency $ 500,000 $ - $ 500,000
Total Budget $ 24,896,045 $ 1,700,000 $ 26,596,045
Reserve For Future Expenditure $ 11,521,009 $ - $ 11,521,009
Total Requirements $ 36,417,054 $ 1,700,000 $ 38,117,054
Exhibit A
Q2PW02- Lake Oswego/Tigard Water Partnership
The LOT Water Partnership project is in its final year.This request carries forward prior year's unused
appropriation to pay final partnership invoices for project completion.This also provides for the property true
up required by the project in the amount of$311,000.
Fund 2 of 2 FY 2018 Q2 Revised
Water CIP Fund Revised Q1 Amendment Q2
Resources
Beginning Fund Balance $ 1,632,847 $ - $ 1,632,847
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $
Special Assessments $ - $ $ -
Licenses&Permits $ - $ - $ -
Intergovernmental $ - $ - $ -
Charges for Services $ - $ - $ -
Fines&Forfeitures $ - $ - $ -
Interest Earnings $ 13,096 $ $ 13,096
Miscellaneous $ - $ - $ -
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ 11,589,346 $ 1,700,000 $ 13,289,346
Total Resources $ 13,235,289 $ 1,700,000 $ 14,935,289
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ - $ - $ -
Public Works $ - $ - $ -
Program Expenditures Total $ - $ - $ -
Debt Service $ - $ - $ -
Loan to CCDA $ - $ $ -
Work-In-Progress $ 11,924,346 $ 1,700,000 $ 13,624,346
Transfers to Other Funds $ - $ - $ -
Contingency $ - $ - $ -
Total Budget $ 11,924,346 $ 1,700,000 $ 13,624,346
Reserve For Future Expenditure $ 1,310,943 $ - $ 1,310,943
Total Requirements $ 13,235,289 $ 1,700,000 $ 14,935,289
Exhibit A
02PW03-CIP 93058 Fanno Creek Sanitary Siphon Repair
Increase FY18 design cost from$50,000 to$80,000 due to greater natural resource permitting requirements than
originally anticipated. FY19 design cost will remain the same at$15,000.This will increase the Total Project Cost
from$290,000 to$320,000.The design contract is from the on-call list;the Project Manager is fully aware that the
contract cannot go over$100,000.The Project Manager got 2 quotes-$95,000 was the lowest.
*This request is for both sanitary and stormwater funds.
Fund 1 of 2 FY 2018 Q2 Revised
Sanitary Sewer Fund Revised Q1 Amendment Q2
Resources
Beginning Fund Balance $ 3,479,552 $ - $ 3,479,552
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Special Assessments $ - $ - $ -
Licenses&Permits $ 42,200 $ - $ 42,200
Intergovernmental $ 1,673,500 $ - $ 1,673,500
Charges for Services $ 2,753,696 $ - $ 2,753,696
Fines&Forfeitures $ - $ - $ -
Interest Earnings $ 10,333 $ - $ 10,333
Dliscellaneous $ 13,091 $ - $ 13,091
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ 193,500 $ - $ 193,500
Total Resources $ 8,165,872 $ - $ 8,165,872
Requirements
Community Development $ - $ - $ -
Community Services $ $ - $ -
Policy and Administration $ $ - $ -
Public Works $ 2,471,239 $ - $ 2,471,239
Program Expenditures Total $ 2,471,239 $ - $ 2,471,239
Debt Service $ - $ - $ -
Loan to CCDA $ - $ - $ -
Work-In-Progress $ 2,697,500 $ 15,000 $ 2,712,500
Transfers to Other Funds $ 593,866 $ - $ 593,866
Contingency $ 305,000 $ (15,000) $ 290,000
Total Budget $ 6,067,605 $ - $ 6,067,605
Reserve For Future Expenditure $ 2,098,267 $ - $ 2,098,267
Total Requirements $ 8,165,872 $ - $ 8,165,872
Exhibit A
02PW03-CIP 93058 Fanno Creek Sanitary Siphon Repair
Increase FY18 design cost from$50,000 to$80,000 due to greater natural resource permitting requirements
than originally anticipated. FY19 design cost will remain the same at$15,000.This will increase the Total
Project Cost from$290,000 to$320,000.The design contract is from the on-call list;the Project Manager is
fully aware that the contract cannot go over$100,000.The Project Manager got 2 quotes-$95,000 was the
lowest.
*This request is for both sanitary and stormwater funds.
Fund 2 of 2 FY 2018 Q2 Revised
Stormwater Fund Revised Q1 Amendment Q2
Resources
Beginning Fund Balance $ 4,892,381 $ - $ 4,892,381
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Special Assessments $ - $ - $ -
Licenses&Permits $ - $ - $ -
Intergovernmental $ - $ - $ -
Charges for Services $ 2,755,890 $ - $ 2,755,890
Fines&Forfeitures $ - $ - $ -
Interest Earnings $ 7,936 $ $ 7,936
Miscellaneous $ 3,100 $ - $ 3,100
Other Financing Sources $ - $ - $ -
Transfers In from Other Funds $ 558,000 $ - $ 558,000
Total Resources $ 8,217,307 $ - $ 8,217,307
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $ -
Policy and Administration $ - $ - $ -
Public Works $ 2,329,116 $ - $ 2,329,116
Program Expenditures Total $ 2,329,116 $ - $ 2,329,116
Debt Service $ - $ - $ -
Loan to CCD a $ - $ - $ -
Work-In-Progress $ 1,634,500 $ 15,000 $ 1,649,500
Transfers to Other Funds $ 255,807 $ - $ 255,807
Contingency $ 185,000 $ (15,000) $ 170,000
Total Budget $ 4,404,423 $ - $ 4,404,423
Reserve For Future Expenditure $ 3,812,884 $ - $ 3,812,884
Total Requirements $ 8,217,307 $ - $ 8,217,307
Exhibit A
02FIS01-CIP 96047 Move WIP appropriation from Water Fund to Water CIP Fund
CIP 96047-Work-In-Progress inadvertently budgeted in Water fund. The request is to move the Work-In-Progress
to Water CIP from Water Fund.
Fund 1 of 2 FY 2018 Q2 Revised
Water Fund Revised Q1 Amendment Q2
Resources
Beginning Fund Balance $ 15,744,833 $ - $ 15,744,833
Property Taxes $ - $ - $ -
Franchise Fees $ - $ - $ -
Special Assessments $ - $ - $ -
Licenses&Permits $ 74,986 $ - $ 74,986
Intergovernmental $ - $ - $ -
Charges for Services $ 20,496,907 $ - $ 20,496,907
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 $ 36,417,054 $ - $ 36,417,054
Requirements
Community Development $ - $ - $ -
Community Services $ - $ $ -
Policy and Administration $ - $ $ -
Public Works $ 6,898,886 $ - $ 6,898,886
Program Expenditures Total $ 6,898,886 $ - $ 6,898,886
Debt Service $ - $ - $ -
Loan to CCDA $ - $ - $ -
Work-In-Progress $ 40,000 $ (40,000) $ -
Transfers to Other Funds $ 17,457,159 $ 40,000 $ 17,497,159
Contingency $ 500,000 $ - $ 500,000
Total Budget $ 24,896,045 $ - $ 24,896,045
Reserve For Future Expenditure $ 11,521,009 $ - $ 11,521,009
Total Requirements $ 36,417,054 $ - $ 36,417,054
Exhibit A
02FIS01-CIP 96047 Move WIP appropriation from Water Fund to Water CIP Fund
CIP 96047-Work-In-Progress inadvertently budgeted in Water fund. The request is to move the Work-In-
Progress to Water CIP from Water Fund.
Fund 2 of 2 FY 2018 Q2 Revised
Water CIP Fund Revised Q1 Amendment Q2
Resources
Beginning Fund Balance $ 1,632,847 $ - $ 1,632,847
Property Taxes $ - $ - $ -
Franchise Fees $ - $ $ -
Special Assessments $ $ $ -
Licenses&Permits $ - $ - $ -
Intergovernmental $ - $ - $ -
Charges for Services $ - $ - $ -
Fines&Forfeitures $ - $ - $ -
Interest Earnings $ 13,096 $ $ 13,096
,Miscellaneous $ - $ - $ -
Other Financing Sources $ - $ $ -
Transfers In from Other Funds $ 11,589,346 $ 40,000 $ 11,629,346
Total Resources $ 13,235,289 $ 40,000 $ 13,275,289
Requirements
Community Development $ - $ - $ -
Community Services $ - $ - $
Policy and Administration $ - $ - $ -
Public Works $ - $ - $ -
Program Expenditures Total $ - $ - $ -
Debt Service $ - $ - $ -
Loan to CCD A $ - $ - $ -
Work-In-Progress $ 11,924,346 $ 40,000 $ 11,964,346
Transfers to Other Funds $ - $ - $ -
Contingency $ - $ - $ -
Total Budget $ 11,924,346 $ 40,000 $ 11,964,346
Reserve For Future Expenditure $ 1,310,943 $ - $ 1,310,943
Total Requirements $ 13,235,289 $ 40,000 $ 13,275,289