Loading...
Resolution No. 16-14 CITY OF TIGARD, OREGON TIGARD CITY COUNCIL RESOLUTION NO. 16- /1/ A RESOLUTION TO AMEND THE FY 2016 ADOPTED BUDGET TO ACHIEVE THE FOLLOWING: RECOGNITION OF GRANT REVENUES AND EXPENSES ALONG WITH BUDGET ADJUSTMENTS IN COMMUNITY DEVELOPMENT, PUBLIC WORKS, COMMUNITY SERVICES,POLICY&ADMINISTRATION, AND THE CAPITAL IMPROVEMENT PROGRAM. WHEREAS, the city acknowledges those items that were unknown at the time the FY 2016 Budget was adopted;and WHEREAS, the city recognizes approximately $363,200 of unanticipated budget in operations and the capital improvement program;and WHEREAS, the city acknowledges that the increase in unanticipated requirements is offset by grants, transfers, fund contingency,and reserve for future expenditures. NOW,THEREFORE,BE IT RESOLVED by the Tigard City Council that: SECTION 1: The FY 2015-16 Budget is hereby amended as detailed in Exhibit A. SECTION This resolution is effective immediately upon passage. PASSED: This day of /U 2016. Mayor- ty of Tigard ATTEST: City Recorder-City of Tigard RESOLUTION NO. 16- Page 1 FY 2016 Third Quarter Budget Supplemental Exhibit A FISOI.Microcomputer Support Technician A request in the amount of$58,000 is needed to hire a 1.0 FTE Microcomputer Support Technician along with the purchase of 3 new network servers.The Support Tech position,at a pro-rated cost of$8,000 will assist with the significant increase in helpdesk tickets as well as replacing the 250 aging computer devices within the city.The new network servers at a cost of$50,000 will replace aging servers. In addition,the servers will be able to handle the anticipated increased network traffic due to the new citywide phone system.As a result,Central Services Fund contingency will decrease by$8,000,and Central Services Fund reserves for future expenditures will decrease by$50,000.Information Technology program expenditures will increase by$58,000. Q2 Q3 Revised Revised Budget Amendment Budget Central Service Fund Resources Beginning Fund Balance $ 387,372 $ 387,372 Property Taxes S - $ - Franchise Fees $ - $ - Licenses&Permits $ 33,872 $ 33,872 Intergovernmental $ - $ - Charges for Services $ 6,986,481 $ 6,986,481 Fines&Forfeitures $ - $ - Interest Earnings $ 22,593 $ 22,593 Miscellaneous $ 19,900 $ 19,900 Other Financing Sources $ - $ - Transfers In from Other Funds $ 733,824 $ 733,824 Total Resources $ 8,184,042, $ $ 8,184,042 Requirements Community Development $ - $ - Community Services $ - $ - Pohcy and Administration $ 7,864,297 $ 58,000 $ 7,922,297 Public Works $ - $ Program Expenditures Total $ 7,864,297 $ 58,000 $ 77922,297 Debt Service $ $ _ Loans $ $ Work-In-Progress $ $ _ Transfers to Other Funds $ $ _ Contingency $ 110,000 $ (8,000) $ 102,000 Total Budget $ 7,974,297 $ 50,000 $ 8,024,297 Reserve For Future Expenditure $ 209,745 $ (50,000) $ 159,745 Total Requirements S 8,184,042 $ - $ 8,184,042 I:\FIN\Budget 16\Amendments\0,3\FY16-Exhibit-A-0,3FY16-Exhibit-A-Q3FIS1 1 FY 2016 Third Quarter Budget Supplemental Exhibit A FIS02.Credit Cud Fees Due to the increase in credit card usage in Utility Billing,there has been a significant increase in the credit card fees along with fees for banking analysis.The increase in credit card fees in Utility Billing is primarily due to an increase in water meter sales resulting from a higher increase in customer payments by credit cards. Related bank analysis fees include the lock box,E-lock box and electronic check service/ACH.Therefore, a total request of$80,000 is needed to pay for the increased credit card fees.As a result,there will be a decrease in contingency Stormwater of$8,800,Water for$55200,and Sanitary Sewer Funds for$16,000.Transfers will increase.Policy and Administration program expenditures will increase by$80,000. Fund Iof4 Q2 Q3 Revised Revised Budget Amendment Budget Stormwater Fund Resources Beginning Fund Balance $ 3,826,154 $ 3,826,154 Property Taxes $ - $ - Franchise Fees $ $ Licenses&Permits S _ $ _ Intergovernmental $ - $ Charges for Services S 2,595,949 $ 2,595,949 Fines&Forfeitures $ - $ _ Interest Earnings S 7,936 $ 7,936 Miscellaneous $ 3,100 $ 3,100 Other Financing Sources $ - $ - Transfers In from Other Funds S - S - Total Resources $ 6,433,139 $ $ 6,433,139 Requirements Community Development S - S Community Services S $ Policy and Administration $ - $ - Public Works S 1,738,126 S 1,738,126 Program Expenditures Total $ 1,738,126 $ $ 1,738,126 Debt Service $ - $ _ Loans $ - $ - Work-In-Progress $ 1,327,096 $ 1,327,096 Transfers to Other Funds $ 433,356 $ 8,800 $ 442,156 Contingency $ 190,000 $ (8,800) S 181,200 Total Budget $ 3,688,578 $ $ 3,688,578 Reserve For Future Expenditure $ 2,744,561 $ $ 2,744,561 Total Requirements $ 6,433,139 $ $ 6,433,139 I:\FIN\Budget 16\Amendments\Q3\FY16-Exhibit-A-Q3FY16-Exhibit-A-Q3FIS 2 2 FY 2016 Third Quarter Budget Supplemental Exhibit A FIS02.Credit Card Fees Due to the increase in credit card usage in Utility Billing,there has been a significant increase in the credit card fees along with fees for banking analysis.The increase in credit card fees in Utility Billing is primarily due to an increase in water meter sales resulting from a higher increase in customer payments by credit cards. Related bank analysis fees include the lock box,E-lock box and electronic check service/ACH.Therefore, a total request of$80,000 is needed to pay for the increased credit card fees.As a result,there will be a decrease in contingency Stormwater of$8,800,Water for$55,200,and Sanitary Sewer Funds for$16,000.Transfers will increase.Policy and Administration program expenditures will increase by$80,000. Fund 2 of 4 Q2 Q3 Revised Revised Budget Amendment Budget Water Fund Resources Beginning Fund Balance $ 20,253,515 $ 20,253,515 Property Taxes $ - $ - Franchise Fees $ - $ - Licenses&Permits $ 31,335 $ 31,335 Intergovernmental $ - $ _ Charges for Services $ 18,827,178 $ 18,827,178 Fines&Forfeitures $ - S - Interest Earnings $ 30,644 S 30,644 Miscellaneous $ 10,933 S 10,933 Other Financing Sources $ - $ - Transfers In from Othcr Funds $ 58,751 $ 58,751 Total Resources $ 39,212,356 $ $ 39,212,356 Requirements Community Development S Community Services S S Policy and Administration $ $ Public Works S 8,682,558 $ 8,682,558 Program Expenditures Total $ 8,682,558 $ $ 8,682 558 Debt Service S - $ - Loans $ $ Work-In-Progress $ - $ _ Transfers to Other Funds S 24,882,226 $ 55,200 $ 24,937,426 Contingency S 500,000 $ (55,200) $ 444,800 Total Budget $ 34,064,784 $ $ 34,064,784 Reserve For Future Expenditure $ 5,147,572 $ $ 5,137,572 Total Requirements $ 39,212,356 $ $ 39,212,356 I:\FIN\Budget 16\Amendments\Q3\FY16-Exhibit-A-0,3FY16-Exhibit-A-Q3FIS 2 3 FY 2016 Third Quarter Budget Supplemental Exhibit A FIS02.Credit Card Fees Due to the increase in credit card usage in Utility Billing,there has been a significant increase in the credit card fees along with fees for banking analysis.The increase in credit card fees in Utility Billing is primarily due to an increase in water meter sales resulting from a higher increase in customer payments by credit cards. Related bank analysis fees include the lock box,E-lock box and electronic check service/ACH.Therefore, a total request of$80,000 is needed to pay for the increased credit card fees.As a result,there will be a decrease in contingency Stormwater of$8,800,Water for$55,200,and Sanitary Sewer Funds for$16,000.Transfers will increase.Policy and Administration program expenditures will increase by$80,000. Fund 3 of 4 Q2 Q3 Revised Revised Budget Amendment Budget Sanitary Sewer Fund Resources Beginning Fund Balance $ 3,595,376 $ 3,595,376 Property Tares S - S Franchise Fees $ - $ Licenses&Permits $ 16,549 $ 16,549 Intergovernmental $ 221,770 $ 221,770 Charges for Services $ 1,590,932 S 1,590,932 Fines&Forfeitures $ - S - Interest Earnings $ 100,333 $ 100,333 Miscellaneous $ 143,091 $ 143,091 Other Financing Sources $ - $ - Transfers In from Other Funds S - $ - Total Resources $ 5,668,051 $ $ 5,668,051 Requirements Community Development Community Services S Policy and Administration $ - Public Works $ 1,960,087 $ 1,960,087 Program Expenditures Total $ 1,960,087 $ $ 1,960,087 Debt Service $ - $ - Loans $ - $ - Work-In-Progress $ 984,693 $ 984,693 Transfers to Other Funds S 93,434 $ 16,000 $ 109,434 Contingency S 392,000 $ (16,000) S 376,000 Total Budget $ 3,430,214 $ $ 3,430,214 Reserve For Future Expenditure $ 2,237,837 $ $ 2,237,837 Total Requirements $ 5,6682051 $ $ 5,668,051 I:\FIN\Budget 16\Amendments\Q3\FY16-Exhibit-A-Q3FY16-Exhibit-A-Q3FIS 2 a FY 2016 Third Quarter Budget Supplemental Exhibit A FIS02.Credit Card Fees Due to the increase in credit card usage in Utility Billing,there has been a significant increase in the credit card fees along with fees for banking analysis.The increase in credit card fees in Utility Billing is primarily due to an increase in water meter sales resulting from a higher increase in customer payments by credit cards. Related bank analysis fees include the lock box,E-lock box and electronic check service/ACH.Therefore, a total request of$80,000 is needed to pay for the increased credit card fees.As a result,there will be a decrease in contingency Stormwater of$8,800,Water for$55,200,and Sanitary Sewer Funds for$16,000.Transfers will increase.Policy and Administration program expenditures will increase by$80,000. Fund 4 of 4 Q2 Q3 Revised Revised Budget Amendment Budget Central Service Fund Resources Beginning Fund Balance $ 387,372 $ 387,372 Property Taxes $ S - Franchise Fees $ - $ - Licenses&Permits $ 33,872 $ 33,872 Intergovernmental $ - S - Charges for Services $ 6,986,481 $ 6,986,481 Fines&Forfeitures $ - $ - Interest Earnings $ 22,593 $ 22,593 Miscellaneous $ 19,900 $ 19,900 Other Financing Sources $ - S - Transfers In from Other Funds $ 733,824 S 80,000 S 813,824 Total Resources $ 8,184,042 S 80,000 $ 8,264,042 Requirements Community Development $ - S - Community Services $ - $ - Policy and Administration $ 7,864,297 $ 80,000 $ 7,944,297 Public Works S - S Program Expenditures Total $ 7,864,297 $ 80,000 $ 7,944,297 Debt Service S - S Loans S S Work-In-Progress $ $ Transfers to Other Funds S $ - Contingencv $ 110,000 $ 110,000 Total Budget $ 7,974,297 $ 80,000 $ 8,054,297 Reserve For Future Expenditure $ 209,745 $ - $ 209,745 Total Requirements $ 8,184,042 $ 80,000 $ 8,264 042 I:\FIN\Budget 16\Amendments\Q3\FY16-Exhibit-A-Q3FY16-Exhibit-A-Q3FIS 2 5 FY 2016 Third Quarter Budget Supplemental Exhibit A FIS03.Software License&Maintenance The annual software licenses and maintenance costs for Springbrook/Accela related to the functionality of receiving credit card payments by phone for Utility Billing customers has increased. This request totaling$25,000 will cover Interactive Voice Response(IVR)transaction fees and the Springbrook subscription fee for the fiscal period ended 06/30/16.This action will show a decrease in contingency Stormwater of$2,750,Water for$17,250,and Sanitary Sewer Funds for$5,000.Transfers will increase.Policy and Administration program expenditures will increase by$25,000. Fund 1 of 4 Q2 Q3 Revised Revised Budget Amendment Budget Stormwater Fund Resources Beginning Fund Balance $ 3,826,154 $ 3,826,154 Property Taxes S - S Franchise Fees $ $ Licenses&Permits S $ Intergovemmental $ - $ - Charges for Services S 2,595,949 S 2,595,949 Fines&Forfeitures $ - $ - Interest Earnings S 7,936 S 7,936 Miscellaneous $ 3,100 $ 3,100 Other Financing Sources S - $ - Transfers In from Othcr Funds $ $ Total Resources $ 6,433,139 $ $ 6,433,139 Requirements Community Development $ Community Services S - Policy and Administration $ - S Public Works $ 1,738,126 8 1,'38.1-'G Program Expenditures Total $ 1,738,126 $ $ 1,738,126 Debt Service $ - $ - Loans $ - $ - Work-In-Progress $ 1,327,096 $ 1,327,096 Transfers to Other Funds $ 433,356 $ 2,750 $ 436,106 Contmgetcy $ 190,000 $ (2,750) $ 187,250 Total Budget $ 3,688,578 $ $ 3,688,578 Reserve For Future Expenditure $ 2,744,561 $ $ 2,744 561 Total Requirements $ 6,433,139 $ $ 6,433 139 I:\FIN\Budget 16\Amendments\0.3\FY36-Exhibit-A-Q3FY16-Exhibit-A-Q3FI6 3 6 FY 2016 Third Quarter Budget Supplemental Exhibit A FIS03.Software License&Maintenance The annual software licenses and maintenance costs for Springbrook/Accela related to the functionality of receiving credit card payments by phone for Utility Billing customers has increased. This request totaling$25,000 will cover Interactive Voice Response(IVR)transaction fees and the Springbrook subscription fee for the fiscal period ended 06/30/16.This action will show a decrease in contingency Stormwater of$2,750,Water for$17,250,and Sanitary Sewer Funds for$5,000.Transfers will increase.Policy and Administration program expenditures will increase by$25,000. Fund 2 of 4 Q2 Q3 Revised Revised Budget Amendment Budget Water Fund Resources Beginning Fund Balance $ 20,253,515 $ 20,253,515 Property Taxes $ - Franchise Fees $ - $ Licenses&Permits S 31,335 $ 31,335 Intergovernmental $ - $ _ Charges for Services S 18,827,178 $ 18,827,178 Fines&Forfeitures S - $ - Interest Earnings $ 30,644 $ 30,644 Miscellaneous $ 10,933 $ 10,933 Other Financing Sources S - $ _ Transfers In from Other Funds ti ;ti-51 $ 58,751 Total Resources $ 39,212,356 $ $ 39,212,356 Requirements Community Development S $ Community Services S $ Policy and Administration $ $ _ Public Works $ 8,682,558 $ 8,682,558 Program Expenditures Total $ 8,682,558 $ $ 8,682,558 Debt Service S - $ Loans S - $ - Work-In-Progress 5 - $ - Transfers to Other Fund. $ 24,882,226 $ 17,250 $ 24,899,476 Contingency $ 500,000 $ (17,250) $ 482,750 Total Budget $ 34,064,784 $ $ 34,064,784 Reserve For Future Expenditure $ 5,147,572 $ $ 5,147,572 Total Requirements $ 39,212,356 $ $ 39,212,356 I:\FIN\Budget 16\Amendments\Q3\FY36-Exhibit-A-Q3FY16-Exhibit-A-Q3FIS 3 7 FY 2016 Third Quarter Budget Supplemental Exhibit A FIS03.Software License&Maintenance The annual software licenses and maintenance costs for Springbrook/Accela related to the functionality of receiving credit card payments by phone for Utility Billing customers has increased. This request totaling$25,000 will cover Interactive Voice Response(IVR)transaction fees and the Springbrook subscription fee for the fiscal period ended 06/30/16.This action will show a decrease in contingency Stormwater of$2,750,Water for$17,250,and Sanitary Sewer Funds for$5,000.Transfers will increase.Policy and Administration program expenditures will increase by$25,000. Fund 3 of Q2 Q3 Revised Revised Budget Amendment Budget Sanitary Sewer Fund Resources Beginning Fund Balance $ 3,595,376 $ 3,595,376 Property''axes S - 5 Franchise Fees $ - $ Licenses&Permits S 16,549 $ 16,549 Intergovernmental $ 221,770 $ 221,770 Charges for Services $ 1,590,932 $ 1,590,932 Fines&Forfeitures $ - $ _ Interest Earnings $ 100,333 $ 100,333 Miscellaneous $ 143,091 $ 143,091 Other Financing Sources $ - S - Transfers In from Other Funds $ Total Resources $ 5,668,051 $ $ 5,668,051 Requirements Community Development $ $ Community Services $ $ Polity and Administration S $ - Public Works $ 1,960,087 $ 1,960,087 Program Expenditures Total $ 1,960,087 $ $ 4960,087 Debt Service $ $ Loans $ - $ - Work-In-Progress $ 984,693 $ 984,693 Transfers to Other Funds $ 93,434 $ 5,000 $ 98,434 Contingency $ 392,000 $ (5,000) S 387,000 Total Budget $ 3,430,214 $ $ 3,430,214 Reserve For Future Expenditure $ 2,237,837 $ $ 2,237,837 Total Requirements $ 5,668,051 $ $ 5,668,051 I:\FIN\Budget 16\Amendments\Q3\FY16-Exhibit-A-Q3FY16-Exhibit-A-Q3FIS 3 8 FY 2016 Third Quarter Budget Supplemental Exhibit A FIS03.Software License&Maintenance The annual software licenses and maintenance costs for Springbrook/Accela related to the functionality of receiving credit card payments by phone for Utility Billing customers has increased. This request totaling$25,000 will cover Interactive Voice Response(IVR)transaction fees and the Spr ngbrook subscription fee for the fiscal period ended 06/30/16.This action will show a decrease in contingency Stomtwater of$2,750,Water for$17,250,and Sanitary Sewer Funds for$5,000.Transfers will increase.Policy and Administration program expenditures will increase by$25,000. Fund 4 of 4 Q2 Q3 Revised Revised Budget Amendment Budget Central Service Fund Resources Beginning Fund Balance $ 387,372 $ 387,372 Property'Taxes $ S Franchise Fees $ S Licenses&Permits $ 33,872 $ 33,872 Intergovernmental $ - $ - Charges for Services S 6,986,481 $ 6,986,481 Fines&Forfeitures $ - S - Interest Eammgs S 22,593 $ 22,593 Miscellaneous $ 19,900 S 19,900 Other Financing Sources S - $ - Transfers In from Other Funds 733,824 S 25,000 $ 758.5_3 Total Resources $ 8,1842042 $ 25,000 $ 8,209,042 Requirements Community Development Community Services S - $ - Policy and Administration $ 7,864,297 $ 25,000 $ 7,889,297 Public Works $ $ Program Expenditures Total $ 7,864,297 $ 25,000 $ 7,889,297 Debt Service $ $ Loans $ $ Work-In-Progress $ $ Transfers to Other Funds $ S - Contingency $ 110,000 $ 110,000 Total Budget $ 7,974,297 $ 25,000 $ 7,999,297 Reserve For Future Expenditure $ 209,745 $ $ 209,745 Total Requirements $ 8,184,042 $ 25,000 $ 8,209,042 I:\FIN\Budget 16\Amendments\Q3\FY16-Exhibit-A-Q3FY16-Exhibit-A-Q3FIS 3 0 FY 2016 Third Quarter Budget Supplemental Exhibit A FIS04.System Development Charges(SDC)-Legal Fees&Implementation Services The city has had difficulty with the implementation of SDC fees.In addition,a lawsuit has been filed by the Home Builders Association related to the new SDC's.By fiscal year end,a total of$45,000 is expected to be spent on these issues with an estimated expense of$20,000 related to the Home Builder's Association's litigation;and $25,000 for discussions related to system development charges.As a result,Central Service Fund contingency will decrease by$45,000 with an equal increase in program expenditures for Policy&Administration. Q2 Q3 Revised Revised Budget Amendment Budget Central Service Fund Resources Beginning Fund Balance $ 387,372 $ 387,372 Property Taxes $ $ - Franchise Fees $ $ - Licenses&Permits $ 33,872 $ 33,872 Intergovernmental $ - $ - Charges for Services S 6,986,481 $ 6,986,481 Fines&Forfeitures $ $ - Interest Earnings $ 22,593 $ 22,593 Miscellaneous $ 19,900 $ 19,900 Other Financing Sources $ - $ - Transfers In from Other Funds $ 733,824 S 733,824 Total Resources $ 8,184,042 $ $ 8,184,042 Requirements Community Development $ - $ Community Services $ - $ Policy and Administration $ 7,864,297 $ 45,000 $ 7,909,297 Public Works S - S - Program Expenditures Total $ 7,864,297 $ 45,000 $ 7,909,297 Debt Service S $ _ Loans 5 S Work-In-Progress S Transfers to Other Funds S - $ Contingency 110,000 $ (45,000) $ 65pn0 Total Budget $ 7,974,297 $ $ 7,974,297 Reserve For Future Expenditure $ 209,745 $ $ 209,745 Total Requirements $ 8,184,042 $ $ 8,184,042 I:\FIN\Budget 16\Amendments\Q3\FY16-Exhibit-A-Q3FY16-Exhibit-A-Q3FIS 4 FY 2016 Third Quarter Budget Supplemental Exhibit A FIS05.Bancroft Debt Service Fund A request in the amount of$2,700 is required to correct an audit finding in the principle payment for the Bancroft Debt Service fund.Payments are due July 1.To make the July 1st payment on time, payment is normally made a couple of days earlier which falls within the prior fiscal year.This additional appropriation will provide enough budget to ensure that payments are in line with the amortization schedule. This action will show a decrease in reserve for future expenditures by$2,700 in the Bancroft Debt Service Fund with an equal increase in debt service payments. Q3 Adopted Revised Budget Amendment Budget Bancroft Debt Service Fund Resources Beginning Fund Balance $ 563,718 $ 563,718 Property Taxes $ - $ - Special Assessments $ 120,000 $ 120,000 Licenses&Permits $ - $ - Intergovernmental $ $ Charges for Services $ $ Fines&Forfeitures $ $ Interest Earnings $ $ Miscellaneous $ $ Other Financing Sources $ Transfers In from Other Funds S $ _ Total Resources $ 683,718 $ $ 6832718 Requirements Community Development $ - Community Services $ $ Policy and Administration S S Public Works S S Program Expenditures Total $ $ $ - Debt Service $ 103,200 $ 2,700 $ 105,900 Loans $ - $ - Work-In-Progress S - $ - Transfers to Other Funds S 499 499 Contingencv S ti Total Budget $ 103,699 $ 2,700 $ 106,399 Reserve For Future Expenditure $ 580,019 $ (2,700) $ 577,319 Total Requirements $ 683,718 $ - $ 683,718 I:\FIN\Budget 16\Amendments\Q3\FY16-Exhibit-A-Q3FY16-Exhibit-A-0,3FIS 5 11 FY 2016 Third Quarter Budget Supplemental Exhibit A CDOL Vehicle Replacement A request in the amount of$25,000 is required in order to replace a vehicle that was totaled after being stolen from the city parking lot.As a result,Building contingency will decrease by$25,000 with an equal increase in Building program expenditures. Q3 Adopted Revised Budget Amendment Budget Building Fund Resources Beginning Fund Balance $ 2,213,677 $ 2,213,677 Property Taxes $ - $ _ Franchise Fees S - S - Licenses&Permits $ 1,791,239 S 1,791,239 Intergovernmental S 8,281 S 8,281 Charges for Services S 7,035 S 7,035 Fines&Forfeitures $ - $ - Interest Earnings S 19,782 $ 19,782 Miscellaneous $ 932 $ 932 Other Financing Sources $ - S - Transfers In from Other Funds $ 180,000 $ 180,000 Total Resources $ 4,220,946 $ $ 4,220,946 Requirements Community Development $ 1,949,847 S 25,000 $ 1,974,847 Community Services $ - S - Policy and Administration $ $ Public Works $ $ Program Expenditures Total $ 1,949,847 $ 25,000 $ 1,974,847 Debt Service S - $ - I.oans $ $ Work-In-Progress S S Transfers to Other Funds $ - $ - Contingeency S 250,000 S (25,000) S 225,000 Total Budget $ 2,199,847 $ $ 2,199,847 Reserve For Future Expenditure $ 2,021,099 $ $ 2,021,099 Total Requirements $ 42220,946 $ $ 4,220,946 I:\FIN\Budget 16\Amendments\Q3\FY16-Exhibit-A-03FY16-Exhibit-A-Q3CD1 FY 2016 Third Quarter Budget Supplemental Exhibit A CD02.Credit Card Fees Due to the increase in credit card usage in Community Development for increased building permit activity,the department has seen a significant increase in its credit card fees and related fees for banking analysis. Therefore,a request in the amount of$15,000 is required.This action will decrease Building Fund contingency by$15,000 with an equal increase in Building program expenditures. Q3 Adopted Revised Budget Amendment Budget Building Fund Resources Beginning Fund Balance $ 2,213,677 $ 2,213,677 Property'faxes ti $ Franchise Fees 5 $ - Licenses&Permits $ 1,791,239 $ 1,791,239 Intergovernmental $ 8,281 $ 8,281 Charges for Services $ 7,035 $ 7,035 Fines&Forfeitures $ - S - Interest Earnings $ 19,782 $ 19,782 Miscellaneous $ 932 $ 932 Other Financing Sources S - $ - Transfers In from Other Funds S 180,000 S 180,000 Total Resources $ 4,220,946 $ $ 4,220,946 Requirements Community Development $ 1,949,847 $ 15,000 $ 1,964,847 Community Services $ - $ _ Policy and Administration $ $ Public Works $ - S Program Expenditures Total $ 1,949,847 $ 15,000 $ 1,964,847 Debt Service S S - Loans $ Work-In-Progress $ $ Transfers to Other Funds S - $ - Contingency S 250,000 $ (15,000) $ 235,000 Total Budget $ 2,199,847 $ $ 2,199,847 Reserve For Future Expenditure $ 2,021,099 $ $ 2,021,099 Total Requirements $ 4,220,946 $ $ 4,220 946 I:\FIN\Budget 16\Amendments\Q3\FY16-Exhibit-A-Q3FY16-Exhibit-A-Q3CD 2 13 FY 2016 Third Quarter Budget Supplemental Exhibit A CD03.Tigard Triangle Strategic Plan The city signed an intergovernmental agreement with Metro in March 2016 after being awarded the Community Planning&Development Grant(CPDG)in the amount of$145,250.A request in the amount of$36,250 is needed to be used to implement the Tigard Triangle Strategic Plan that was completed in March 2015.The expected deliverables include a Streetscape Design,Opportunity Site Analysis,and an Urban Renewal Plan.The remaining$109,000 will be budgeted in Community Development in FY 2017.As a result,General Fund intergovernmental revenues will increase by$36,250 with an equal increase in Community Development program expenditures. Q2 Q3 Revised Revised Budget Amendment Budget General Fund Resources Beginning Fund Balance $ 10,779,593 $ 10,779,5593 Property Taxes $ 14,330,765 $ 14,330,765 Franchise Fees $ 5,909,165 $ 5,909,165 Licenses&Permits S 1,352,420 $ 1,352,420 Intergovernmental S 5,475,285 $ 36,250 $ 5,511,535 Charges for Services S 3,039,908 $ 3,039,908 Fines&Forfeitures S 873,006 $ 873,006 Interest Earnings $ 103,722 $ 103,722 Miscellaneous S 56,432 $ 56,432 Other Financing Sources S - S - Tmnsfers In from Othcr I rind, S 57,750 S 57,750 Total Resources $ 41,978,046 $ 36,250 $ 42,014,296 Requirements Community Development $ 4,043,179 $ 36,250 S 4,079,429 Community Services S 22 326,539 $ 22,326,539 Policy and Administration $ 906,662 $ 906,662 Public Works S 4256,072 S 456,072 Program Expenditures Total $ 31,532,452 $ 36,250 $ 31,568,702 Debt Service $ - S - Loans $ $ Work-In-Progress $ - $ - Transfers to Other Funds $ 3,504,936 $ 3,504,936 Contingency $ 978,868 $ 978,868 Total Budget $ 36,016,256 $ 36,250 $ 36,052 506 Reserve For Future Expenditure $ 5,961,790 $ $ 5,961,790 Total Requiremems $ 41,978,046 $ 36,250 $ 42,014,296 I:\FIN\Budget 16\Amendments\Q3\FY16-Exhibit-A-Q3FY16-Exhibit-A-Q3CD3 FY 2016 Third Quarter Budget Supplemental Exhibit A LIBOI.Washington County Cooperative Library Services WCCLS has issued a distribution of Pool 2 funds amounting to$48,794 for the City of Tigard.This action will recognize the revenue and expense of the funds to be used to re-upholster furniture and the purchase of new computers in the Library.As a result,intergovernmental revenues will increase in the General Fund by$48,794 with an equal increase in Community Services program expenditures. Q2 Q3 Revised Revised Budget Amendment Budget General Fund Resources Beginning Fund Balance $ 10,779,593 $ 10,779,593 Property Taxes S 14,330,765 $ 14,330,765 Franchise Fees S 5,909,165 $ 5,909,165 Licenses&Permits S 1,352,420 S 1,352,420 Intergovernmental $ 5,475,285 $ 48,794 $ 5,524,079 Charges for Services $ 3,039,908 $ 3,039,908 Fines&Forfeitures $ 873,006 $ 873,006 Interest Earnings $ 103,722 S 103,722 Miscellaneous $ 56,432 $ 56,432 Other Financing Sources $ - S - Transfers in from Other Funds $ 57,750 S 57,750 Total Resources $ 41,978,046 $ 48,794 $ 42,026,840 Requirements Community Development $ 4,043,179 $ 4,043,179 Community Services $ 22,326,539 S 48,794 $ 22,375,333 Policy and Administration $ 906,662 $ 906,662 Public Works S 4,256,072 S 4,256,072 Program Expenditures Total $ 31,532,452 $ 48,794 $ 31,581,246 Debt Service $ - S - Loans $ S Work-In-Progress $ - S - Transfers to Other Funds $ 3,504,936 S 3,504,936 Contingency $ 978,868 S 978,868 Total Budget $ 36,016,256 $ 48,794 $ 36,065,050 Reserve For Future Expenditure $ 5,961,790 $ - $ 5,961,790 Total Requirements $ 41,978,046 $ 48,794 $ 42,026,840 1:\FIN\Budget 16\Amendments\Q3\FY16-Exhibit-A-Q3FY16-Exhibit-A-0,3LIB1 15 FY 2016 Third Quarter Budget Supplemental Exhibit A P1301.Property&Evidence office reconfiguration Recognize funds from the sale of ammunition that is no longer needed(sales$14,880)and the sale of two patrol cars at the State of Oregon auction($5,600)in order to purchase:5 modular desks (3 for the patrol sergeant office reconfiguration and 2 sit/stand desks for property&evidence office reconfiguration)and 6 chairs for the patrol sergeant office(3 replacement chairs+3 new chairs). The reconfiguration of the two offices is to maximize use of space and ease over-crowding. This action will cause an increase in miscellaneous revenues within General Fund by$20,000 with an increase in Community Services program expenditures by the same amount. Q2 Q3 Revised Revised Budget Amendment Budget General Fund Resources Beginning Fund Balance $ 10,779,593 $ 10,779,593 Property Taxes $ 14,330,765 $ 14,330,765 Franchise Fees S 5,909,165 $ 5,909,165 Licenses&Permits S 1,352,420 $ 1,352,420 Intergovernmental $ 5,475,285 $ 20,480 $ 5,495,765 Charges for Services $ 3,039,908 $ 3,039,908 Fines&Forfeitures $ 873,006 $ 873,006 Interest Earnings $ 103,722 $ 103,722 Miscellaneous $ 56,432 S 56,432 Other Financing Sources S - S - Transfers In from Other Funds S 57,750 S 57,750 Total Resources $ 41,978,046 $ 20,480 $ 41,998,526 Requirements Community Development $ 4,043,179 $ 4,043,179 Community Services $ 22,326,539 $ 20,480 $ 22,347,019 Policy and Administration $ 906,662 $ 906,662 Public Works S 4,256,072 $ 4,256,072 Program Expenditures Total $ 3125329452 $ 207480 $ 31,5521932 Debt Service S - S - Loans $ $ Work-In-Progress S - S - Transfers to Other Funds $ 3,504,936 $ 3,504,936 Contingency $ 978,868 $ 978,868 Total Budget $ 36,016,256 $ 20,480 $ 36,036,736 Reserve For Future Expenditure $ 5,961,790 $ $ 5,961,790 Total Requirements $ 41,978,046 $ 20,480 $ 41,998,526 I:\FIN\Budget 16\Amendments\Q3\FY16-Exhibit-A-Q3FY16-Exhibit-A-0,3PD1 16 FY 2016 Third Quarter Budget Supplemental Exhibit A PWOL Streets FTE Technical Adjustment With the migration to a new position control system and process,a Utility Worker II position within Street Maintenance Division was inadvertently omitted.The budget dollars for this position remained but the FTI;was eliminated.This request will authorize the additional 1.0 FTE without any impact to budget. I:\FIN\Budget 16\Amendments\43\FY16-Exhibit-A-03FY16-Exhibit-A-Q3PW1 17 FY 2016 Third Quarter Budget Supplemental Exhibit A C I P 01.95th Ave.&N.Dakota Sidewalk Improvements A total of$60,000 is being requested to provide the required curbing and storm drain improvements. The city has received a Community Development Block Grant(CDBG)from Washington County in the amount of$30,000 to perform this work.This request recognizes and appropriates the$30,000 CDBG funds.In addition, a total of$30,000 from Gas Tax Fund contingency will fully fund the work This action will show an increase in Gas Tax intergovernmental revenues by$30,000 with a decrease in Gas Tax contingency by the same amount.Transfers will increase.Capital program expenditures will increase by $60,000 in the Transportation CIP Fund. Fund 1 of 2 Q2 Q3 Revised Revised Budget Amendment Budget Gas Tax Fund Resources Beginning Fund Balance $ 1,028,122 $ 1,028,122 Property Taxes S S Franchise Fees $ S Licenses&Permits S 5,872 S 5,872 Intergovernmental $ 3,070,117 $ 30,000 $ 3,100,117 Charges for Services $ - $ - Fines&Forfeitures $ - S - Interest Earnings $ 55,732 $ 55,732 Miscellaneous $ 62,818 S 62,818 Other Financing Sources $ - S - Transfers In from Other Funds $ 136,275 S 136,475 Total Resources $ 4,358,936 $ 30,000 $ 47388,936 Requirements Community Development 5 S Community Services $ $ Policy and Administration $ - S - Public Works S 2,202,321 S 2,202,321 Program Expenditures Total $ 2,202,321 $ $ 2,202,321 Debt Service $ 592,425 $ 592,425 Loans $ - $ - Work-In-Progress $ - $ - Transfers to Other Funds $ 552,639 $ 60,000 $ 612,639 Contingency $ 200,000 $ (30,000) $ 170,000 Total Budget $ 3,547,385 $ 30,000 $ 3,577,385 Reserve For Future Expenditure $ 811,551 $ - $ 811,551 Total Requirements $ 4,358,936 $ 30,000 $ 4,388 936 I:\FIN\Budget 16\Amendments\Q3\FY16-Exhibit-A-0.3FY16-Exhibit-A-Q395045 1S FY 2016 Third Quarter Budget Supplemental Exhibit A CIP 01.95th Ave.&N.Dakota Sidewalk Improvements A total of$60,000 is being requested to provide the required curbing and storm drain improvements. The city has received a Community Development Block Grant(CDBG)from Washington County in the amount of$30,000 to perform this work.This request recognizes and appropriates the$30,000 CDBG funds.In addition, a total of$30,000 from Gas Tax Fund contingency will fully fund the work. This action will show an increase in Gas Tax intergovernmental revenues by$30,000 with a decrease in Gas Tax contingency by the same amount.Transfers will increase.Capital program expenditures will increase by $60,000 in the Transportation CIP Fund. Fund 2 of 2 Q2 Q3 Revised Revised Budget Amendment Budget Transportation CIP Fund Resources Beginning Fund Balance $ 379,619 $ 379,619 Property Taves $ - S - Franchise Fees S S Licenses&Permits $ S Intergovernmental $ S Charges for Services $ S Fines&Forfeitures $ $ Interest Earnings $ $ Miscellaneous $ $ Other Financing Sources $ - $ - Transfers In from Other Funds $ 1,635,448 5 60,000 S 1,695,448 Total Resources $ 2,015,067 $ 60,000 $ 21075,067 Requirements Community Development 5 - S - Community Services S $ Policy and Administration $ $ Public Works $ S - Program Expenditures Total $ $ $ Debt Service $ $ Loans $ $ - Work-In-Progress $ 1,625,448 $ 60,000 $ 1,685,448 Transfers to Other Funds S 57,410 $ 57,410 Contingency $ $ - Total Budget $ 1,682,858 $ 60,000 $ 1,742,858 Reserve For Future Expenditure $ 332,209 $ $ 332,209 Total Requirements $ 2,015,067 $ 60,000 $ 2,075,067 I:\FIN\Budget 16\Amendments\0,3\FY16-Exhibit-A-Q3FY16-Exhibit-A-Q395045 19 FY 2016 Third Quarter Budget Supplemental Exhibit A CIP 02.Tiedeman Crossing/Fano Creek Trail This request recognizes and appropriates$10,000 of a$660,000 Community Development Block Grant(CDBG) from Metro for work on the Tiedeman Crossing/Fanno Creek Trail. This project fills sidewalk"gaps"on Tiedeman Avenue,and improves a dangerous connection near the Fanno Creek trail. The remainder of the METRO grant is programmed in subsequent years in the FY 2016-17 CIP. As a result,there is an increase in intergovernmental revenues in Parks Capital Fund by$10,000 with an equal increase in capital program expenditures. Q2 Q3 Revised Revised Budget Amendment Budget Parks Capital Fund Resources Beginning Fund Balance $ 298,740 $ 298,740 Property Taxes S $ - Franchise Fees $ $ Licenses&Permits $ $ - Intergovemmental $ $ 10,000 $ 10,000 Charges for Services $ $ - Fines&Forfeitures $ $ - Interest Earnings $ 3,015 $ 3,015 Miscellaneous $ - $ - Other Financing Sources $ - $ - Transfers In from Other Funds $ 3,686,561 $ 3,686,561 Total Resources $ 3,988,316 $ 10,000 $ 3,998 316 Requirements Community Development $ Community Services $ S Policy and Administration S $ Public Works y' $ Program Expenditures Total $ $ - $ Debt Service $ $ Loans $ $ - Work-In-Progress $ 3,686,561 $ 10,000 $ 3,696,561 Transfers to Other Funds $ 123,932 $ 123,932 Contingency $ - $ - Total Budget $ 3,810,493 $ 10,000 $ 3,820,493 Reserve For Future Expenditure $ 177,823 $ - $ 177,823 Total Requirements $ 3,988,316 $ 10,000 $ 3,998,316 I:\FIN\Budget 16\Amendments\Q3\FY16-Exhibit-A-Q3FY16-Exhibit-A-Q392051 20