Loading...
Resolution No. 13-44 CITY OF TIGARD, OREGON TIGARD CITY COUNCI ' !i3-- RESOLUTION NO. A RESOLUTION TO ADOPT A SUPPLEMENTAL BUDGET AMENDMENT TO FY 2014 TO ACHIEVE THE FOLLOWING: CARRYFORWARDS OF BUDGET ITEMS,GRANT REVENUES AND EXPENSES,BUDGET ADJUSTMENTS IN PUBLIC WORKS,COMMUNITY DEVELOPMENT, COMMUNITY SERVICES,POLICY AND ADMINISTRATION,AND THE CAPITAL IMPROVEMENT PROGRAM. WHEREAS, the city is acknowledging those items that were unknown at the time the FY 2014 Budget was adopted;and WHEREAS,the city recognizes $1,624,663 of unanticipated requirements in Public Works,Community Development,Community Services,Policy and Administration,and the Capital Improvement Program;and WHEREAS, the city recognizes reallocation of$1,060,000 to pay for unanticipated requirements within the Capital Improvement Program;and WHEREAS, the city recognizes additional revenue including$33,643 in grant revenue along with $342,132 in contingency to meet those requirements;and WHEREAS,the city acknowledges the transfer of the Police Department Technology Specialist position or 1.0 FTE from the Police to Information Technology;and WHEREAS, the city approves the transfer of the Senior Engineering Tech position or 1.0 FTE from Community Development to Public Works. NOW,THEREFORE,BE IT RESOLVED by the Tigard City Council that: SECTION 1: The FY 2013-14 Budget is hereby amended as detailed in Exhibit-A,and Exhibit-B including Attachments 1 and 2. SECTION 2: This resolution is effective immediately upon passage. PASSED: This —day of 2012. Mayj-City of Tigard ATTEST: "��F 6ityy Rec rder-City of Tigar RESOLUTION NO.44- Page 1 Attachment-1 FY 2014 First Quarter Supplemental Budget Amendment ProjecVContract/Carryforward/Grant Amount Financial Impact to Ftmd/Div Description tindin Fund Balance City of Tigard Operations A transfer of the PD Technology Specialist position No impact.This action from Police to Information Technology.This action I Transfer of the 1.0 FTE from Police to $79,337 moves budget from one Central Srv-IT will move payroll costs from the General Fund to Information Technology program to another,and General Fund-PD the Central Services Fund.Based on approval,this across funds. change will be effective 10/1/2013. Transfer Sr.Eng.Tech from CD to Engineering.A total of$4,040 of M&S,and$67,000 of salaries and No impact.This action benefits will be transferred due to the transfer of Sr.Engineering Tech(1.0 FTE)Transfer moves budget from one Private Development tasks from CD Engineering. 2 from Community Development to $71.040 program to another General Fund-CD/Pto W Based on approval,this change will to effective Engineering within the General Fund. 10/1/2013.Therefore,salaries and benefits have been prorated to reflect this timeline.This action has zero impact on General Fund. The FY 2014 Adopted Budget includes a$100,000 grant for the new E-Citation system in Police.The Recognition of Police Grants $31,143 No impact.This action General Fund-PD city recently received an additional$31,143 grant provides additional from ODOT for the new system.The funds will be 3 revenue to support used to purchase software,and hardware such as additional expenditures. hand-held devices for police officers. Recognition of the"Celebrate My Drive"grant from $2,500 General Fund-PD State Farm.Funds to be used for educational purposes concerning distracted driving. Total Grants $33,643 No impact.Increased expenditures are offset Willamette River Water Coalition by reduction of supply s participation in i study related a water 4 (WRWC)/Hillsboro Preliminary $100,000 contingency. Water-PW supply and treatment options as a member of Willamette River Water Supply Study Remaining contingency WRCW.Council approved participation this study during the July 16,2013 workshop. in the Water Fund will be$400,000. No impact.Increase in revenues plus decrease The van used by staff in the Fleet Division was in contingency offsets totaled.The city received a insurance check in the increase in program amount of$14,868 that was used toward the Purchase of replacement van $27,000 expenditures. Prop Mgmnt-PW purchase of the replacement van which costs Remaining contingency $27,000.A total of$12,314 is being requested from in Fleet/Property contingency to go towards the purchase of the new Management Fund will vehicle. be$12,686. Total Adjustments to Operations $344,663 Attachment-1 FY 2014 First Quarter Supplemental Budget Amendment Project/Contract/Carryforward/Grant :kmount Financial Impact to Fnnd/Dic Description Ending Fund Ralance Capital Improvement Program Request Summary: After the adoption ofthe FY 2014 CIP,a couple of issues appeared regarding these projects.First,the Walnut Street Culvert Improvement project that was not completed last Consolidation of CIP projects: 93010- vear was omitted from the CIP,Second,it was Derry Dell Creek and Sewer Interceptor determined that the Johnson Street Waterline,and Relocation;96032-Johnson St.Waterline the above-mentioned culvert project could be Replacement;92027-Park Land CIP included in the Clean Water Service permit package Development and a request for a for other agencies.By combining them with the carryforward of appropriation for the related Derry Dell Sewer Relocation project,the Walnut Street Culvert Improvement permits and projects can be managed more (Derry Dell/Fanno Creek)projects. efficiently.This request will reallocate adopted budgets along with requesting additional appropriations for the consolidated project.After all budget adjustments,total project costs will be $685,000. A total of$75.000 appears in the FY 2014 Adopted Budget the Derry Dell Creek Sewer Interceptor Relocation project.An additional appropriation in $200,000 No impact Sanitary Sewer-CIP the amount of$200,000 is being requested for Derry Dell that will provide a total of$275,000 of 6 appropriations in the Sanitary Sewer Fund for the combined project. Carryforward for$120,000 for Walnut St.Culvert $120,000 No impact Stormwater-CIP Improvement in Stormwater funds and apply them to Derry Dell Creek Sewer Interceptor Relocation project. Reallocation of appropriation in the amount of $285,000 No impact Water-CIP $285,000 is being requested from 96032-Johnson Street Waterline Replacement project to Derry Dell Creek Sewer Interceptor Relocation project. Appropriation of$50,000 is being requested from $50,000 No impact Gas Tax-CIP the Gas Tax Fund to be used for shoulder widening of Walnut Street. Reallocation of appropriation from 92027-Park Land No impact Parks Bond-CIP Development project in the amount of$30,000 is being requested to design trail connections for 30 000 Fanno Creek. Total Derry Dell Budget Adjustments $685,000 Attachment-I FY 2014 First Quarter Supplemental Budget Amendment Proiect/Coetract/Carryforward/Gnat Amovat Financial Impact to Fav De—ipfioa Eadiaz Fund Balance A total of$225,000 in additional appropriation is Main St.Sewer/Fanno Creek Crossing CIP being requested for easements and construction costs.Total project costs will amount to$437,000. An additional$45,000 is being requested to complete the acquisition of the easement for this $45,000 No impact Sanitary Sewer-CIP project.Total appropriation for the easement is $70,000.This item was approved by council on July 7 23,2013. A request for an additional appropriation of $180,000 is being requested for this project.With this request,total sewer construction costs will No impact Sanitary Sewer-CIP increase by$100,000 to a total of$267,000;and project management and construction management costs will increase by$80,000 to a total of IMO 000 $100,000. Total Main St.Sewer Appropriation $225,000 A total of$300,000 is being requested in order to Parks CIP budget adjustments for 92021- complete the improvements at Potso Dog Park and Potso Dog Park,92048-Summer Lake Parks-CIP Summer Lake.This action will be funded by Improvements,&92027-Park Land reallocating appropriations from the Park Land Development Projects Development project which has no impact on appropriations. 8 Improvements to Potso Dog Park include a paved $0 Parks Bond-CIP parking lot and stormwater improvements totaling L0 No impact Parks SDC-CIP $160,000 split between Parks Bond and Parks SDC. Total Potso Doz Park So Improvements at Summer Lake Park include 10 No impact Parks Bond-CIP construction of new restrooms for$140,000. Total Summer Lake Park $0 Additional appropriation is requested in order to 9 Ash Street Crossing Study $501000 No impact Traffic Impact Fee-PW complete the design and modeling study tied to the Tiedeman/Greenberg Rd./North Dakota Intersection Improvement. A total of$100,000 is being requested for the repair 10 Sanitary Sewer Major Maintenance $100,000 No impact Sanitary Sewer-CIP of the sewer at Red Rock Creek that was not completed last year due to permitting issues. A total of$50,000 is being requested to complete 11 Waterline Restoration-Black Bull S50,000 No impact Water-CIP design and construction to restore the waterline on Property the Black Bull property off of North Dakota Street due to illegal excavation. Anachment-1 FY 2014 First Quarter Supplemental Budget Amendment Project/Contract/Carrvfo—ord/Grant Amount Financial Impact to Fund/Dh Description EndinR Fund Balance This project installs a trail from Main Street to Grant Avenue,and is a key part of the Fanno Creek Regional Trail System.The FY 2014 Adopted Budget reflects a total project cost of 5491,000 Fanno Creek Trail-Main St.to Grant Ave. CIP which includes funding from the City Center Development Agency(CCDA).A reallocation of funding totaling$170,000 is being requested to complete permitting and construction on this project.If approved,total cost for the project will ` amount to$661,000. Parks&Recreation Advisory Board approved the S100,000 No impact Parks Bond-CIP use of these funds for construction of the trail.A total of$100,000 will be reallocated from 92027- Park Land Development to this project. A total of$50,000 will be reallocated from 95027- $50,000 No impact Gas Tax-CIP Citywide Pedestrian/Cyclist Improvements project in order to complete improvements to the trail. $20,000 No impact CCDA-CIP An additional$20,000 is requested to complete the purchase and installation of lighting along the trail. Total Fanno Creek Trail-Main to Gran $170,000 Overall Amendment Total 1$1,624,663 City of Tigard Exhibit A FY 2014 First Qtr Supplemental Budget Amendment L PTE Tratnsfer-Police to IT A transfer of the PD Technology Specialist position 11.0 FTE} from Police to IT is being requested.This action will move payroll costs from General Fund to Central Services.The result will have no affect on General Fund program expenditures but will increase interdepartmental services revenue and increase IT program expenditures in the Central Service Fund. Adopted Revised Budget Amendment Budget Central Service Fund Resources Beginning Fund Balance $ 199,348 $ 199,348 Property Taxes $ S - Franchise Fees $ - S - Licenses&Permits S 31,620 $ 31,620 Intergovernmental $ - S - Charges for Services S 5,750,628 S 5,750,628 Fines&Forfeitures $ - S - Interest Earnings S 593 S 593 Miscellaneous $ - S - Other Financing Sources S - S - Transfers 1n from Other Funds S 861,205 S 79,337 S 940,542 Total Resources $ 6,843,394 $ 79,337 $ Requirements Policy and Administration S 6,494,508 $ 79,337 S 6,573,845 Community Development $ - S - Community Services $ - S - Public Works S - S - Program Expenditures Total $ 6,494,508 $ 79,337 $ 6,573,845 Debt Semcc $ - S - Loans S S - Work-In-Progress S S - Transfers to Other Funds $ - S - Contingcncv S 340,000 S 340,000 Total Budget $ 6,834,508 $ 79,337 $ 6,913,845 Reserve For Future Expendittire $ 8,886 $ - $ 8,886 Total Requirements $ 6,843,394 $ 79,337 $ 6,922,731 1 City of Tigard Exhibit A FY 2014 First Qtr Supplemental Budget Amendment 2.FTE Transfer-Community Development to Public Works Engineering Transfer Sr.F.ng.Tech from CD to Engineering.A total of$4,040 of M&S,and$67,000 of salaries and benefits will be transferred due to the transfer of Private Development tasks from CD to Engineering.Based on approval,this change will be effective 10/1/2013.Therefore, salaries and benefits have been prorated to reflect this timeline.This action will result in a decrease of 1.0 FTE in CD with an increase in FTE in Engineering.In addition,program expenditures in CD will decrease by$71,040 and program expenditures in Engineering will increase by the same amount.This action has zero impact on General Fund. Adopted RcN'iscd Budget Amendment Budget General Fund Resources Beginning Fund Balance $ 8,156,853 $ 8,156,853 Property'1'axes S 13,020,535 S 13,020,535 Franchise Fees S 5,601,400 S 5,601,400 Licenses&Permits S 900,135 S 900,135 Intergovernmental S 5,575,381 5 5,575,381 Charges for Services $ 3,230,653 S 3,230,653 Fines&Forfeitures $ 1,098,783 $ 1,098,783 Interest Earnings S 103,722 S 103,722 Miscellaneous S 24,902 S 24,902 Other Financing Sources S 361,000 S 361,000 Transfers In from t l(her Fund. S $ Total Regis 38,071- f ,073,364 Requirements Policy and Administration $ 802,516 $ 802,516 Community Development S 3,094,988 $ (71,040) $ 3,023,948 Community Services S 20,048,141 S 20,048,141 Public Works S 5,396,392 $ 71,040 S 5,467,422 Program Expenditures Total $ 29,342,027 $ - $ 29,342,027 Debt Service S - S - Loans $ 361,000 $ 361,000 Work-ln-Progress $ - S - Transfers to Other Funds S 916,292 $ 916,292 Contingence > 1,200,1Njo $ 1,200,000 Total Budget $ 31,819,319 $ $ 31,819,319 Reserve For Future Expenditure $ 6,254,045 $ $ 6,254,045 Total Requirements $ 38,073,364 $ $ 38,073,364 2 City of Tigard Exhibit A FY 2014 First Qtr Supplemental Budget Amendment 3.Recognition of Grants-Police Department F-Citation System The FY 2014 Adopted Budget includes a$100,000 grant for the new E-Citation system in Police.The city recently received an additional$31,143 grant from ODOT for the new system.The funds will be used to purchase software and hardware such as hand-held devices for police officers.Intergovernmental Revenues urill increase by$31,143 in General Fund with an equal increase in Community Services program expenditures. State Farm Grant Recognition of the"Celebrate My Drive"grant from State Farm.Proceeds to be used for distracted driving education.This action will increase grant revenues by$2,500 with an equal increase in Community Services program expenditures. Adopted Revised Budget Amendment Budget General Fund Resources Beginning Fund Balance $ 8,156,853 $ 8,156,853 Property Taxes S 13,020,535 S 13,020,535 Franchise Fees S 5,601,400 S 5,601,400 Licenses&Permits $ 900,135 S 900,135 Intergovemmental $ 5,575,381 $ 33,643 S 5,609,024 Charges for Services $ 3,230,653 S 3,230,653 Fines&Forfeitures S 1,098,783 S 1,098,783 Interest Earnings S 103,722 S 103,722 Miscellaneous $ 24,902 $ 24,902 Other Financing Sources $ 361,000 5 361,000 Transfers In from Other Funds S Total Resources $ 38,073,364 $ 33,643 $ 38,107,007 Requirements Policy and Administration $ 802,516 S 802,516 Community Development $ 3,094,988 S 3,094,988 Community Services $ 20,048,141 $ 33,643 S 20,081,784 Public Works S 5,396,382 > 5,396,382 Program Expenditures Total $ 29,342,027 $ 33,643 $ 29,375,670 Debt Service $ - Loans S 361,000 5 361,000 Work-In-Progress S - Transfers to Other Funds $ 916,292 S 916,292 Contingency S 1,200,000 1,200,000 Total Budget $ 31,819,319 $ 33,643 $ 31,852,962 Reserve For Future Expenditure $ 6,254,045 $ - $ 6,254,045 Total Requirements $ 38,073,364 $ 33,643 $ 38,107,007 i City of Tigard Exhibit A FY 2014 First Qtr Supplemental Budget Amendment 4.Willamette River Water Coalition(WRWC)/Hillsboro Preliminary Willamete River Water Supply Study Tigard's participation in a study related to water supply and treatment options as a member of WRWC.Council approved participation in this study during the July 16,2013 workshop.This action will result in a decrease of$100,000 in contingency in the Water Fund with and equal increase in program expenditures. Adopted Revised Budget Amendment Budget Water Fund Resources Beginning Fund Balance $ 9,701,503 $ 9,701,503 Property Taxes $ - S - Franchise Fees $ - S - Licenses&Permits $ 13,202 $ 13,202 Intergovernmental $ - $ - Charges for Services $ 14,240,169 $ 14,240,169 Fines&Forfeitures $ - $ - Interest Earnings $ 30,644 $ 30,644 Miscellaneous $ $ - Other Financing Sources $ - $ - Transfers In from Other Funds $ 58,751 $ 58,751 ;044,269 $ a 24, Requirements Policy and Administration S - $ - Community Development $ - $ - Community Services S - $ - Public Works S 8,139,852 $ 100,000 S 8,239,852 Program Expenditures Total $ 8,139,852 $ 100,000 $ 8,239,852 Debt Service S - S - Loans $ S Work-In-Progress $ - S - Transfers to Other Funds $ 5,735,926 $ 5,735,926 Contingcncy S 500,000 S (100,000) S 400,000 Total Budget $ 14,375,778 $ - $ 14,3755778 Reserve For Future Expenditure $ 9,6685491 $ - $ 9,668,491 Total Requirements $ 24,044,269 $ - $ 24,044,269 4 City of Tigard Exhibit A FY 2014 First Qtr Supplemental Budget Amendment S.Purchase of replacement van-Public Works The van used by staff in the Fleet Division was totalled.The city received a insurance check in the amount of$14,868 that was used toward the purchase of the replacement van which costs$27,000.A total of$12,314 is being requested to go towards the purchase of the new vehicle.This action will increase recovered expenditures by$14,868 and decrease contingency by$12,314 in the Fleet/Property Management Fund.In tum,Public Works program expenditures will increase by$27,000. Adopted Revised Budget Amendment Budget Fleet/Property Management Fund Resources Beginning Fund Balance $ 86,512 $ 86,512 Property Taxes $ - $ - Franchise Fees $ $ Licenses&Permits $ S Intergovernmental 5 S Charges for Services $ 1,639,836 S 1,639,836 Fines&Forfeitures S - S - Interest Earnings $ S - Miscellaneous S S 14,868 S 13,868 Other Financing Sources S S - Transfcrs In from Other Funds S S Total Resources $ 1,726,348 $ 14,868 $ 1,741,216 Requirements Policy and Administration $ - S Community Development $ S - Community Services S - $ - Public Works c 1,698,713 $ 27,000 $ 1,725,713 Program Expenditures Total $ 4698,713 $ 27,000 $ 1,725,713 Debt Service $ - $ - Loans $ $ - Work-In-Progress $ $ Transfers to Other Funds S S Contingency 25,000 S (12,132) $ 12,868 Total Budget $ 1,723,713 $ 14,868 $ 1,738,581 Reserve For Future Expenditure $ 2,635 $ - $ 2,635 Total Requirements $ 1,726,348 $ 14,868 $ 1,741,216 5 City of Tigard Exhibit A FY 2014 First Qtr Supplemental Budget Amendment 6.Consolidation of CIP projects 94011-Culvert Improvements:Walnut St.(Derry Dell/Fenno Cr.)and 96032-Johnson St.Waterline Replacement with 93010-Derry Dell Creek and Sewer Interceptor Relocation project. After the adoption of the Fl 2014 CIP,a couple of issues appeared regarding these projects.First,it was discovered that the\Walnut Street culvert improvement project that was not completed last year was ornitted from the CIP.Second,it was determined that the Johnson Street W'atedine,and the above mentioned culvert project could be included in dee O can\Vater Service permit package for other agencies. By combining them with dee related Derry Dell Sewer Relocation project,the permits and projects can be managed more efficiently. The following budget adjustments are being requested: SanilM Sewer-will show an increase in beginning fund balance by$200,000 with an increase in transfers of$455,000.Capital program expenditures will increase by$655,000. Stormwater Fund-will show an increase in beginning fund balance of$120,(N)0 with an equal increase in transfers out. Water CIP-this fund will show a decrease in capital improvement program expenditures by$285,000. I lits action will also result in an increase in transfers by the same amount into the Sanitary Sewer Fund. Gas Tax this action will show an increase in beginning fund balance of$50,000 with an increase in transfers to the Sanitary Sewer Fund. Parks Bond-a reallocation of appropriation in the amount$30,OW from the Park Lund Development project is required.This action will have n.�impact on ending fund balance. Adopted Revised Budget Amendment Budget Sanitary Sewer Fund Resources Beginning Fund Balance $ 5,852,119 $ 200,000 $ 6,052,119 Property Taxes $ - $ - Franchise Fees $ - $ - Licenses&Permits $ 433,800 $ 433,800 Intergovernmental S - S - Charges for Services $ 1,484,277 $ 1,484,277 Fines&Forfeitures S S - Interest Earnings S 100,333 $ 100,333 Miscellaneous $ 128,788 $ 128,788 Other Financing Sources S - $ - Transfers In from Other Funds $ 936,000 $ 45SNO $ 1,391,000 Totd Beset rces '*. Requirements Policy and Administration S - $ - Community Development S - $ - Cormmunity Services S - $ - Public Works $ 1,973,373 $ 1,973,373 Program Expenditures Total $ 1,973,373 $ $ 1,973,373 Debt Service $ - $ Loans $ $ Work-]n-Progress $ 4,944,653 $ 655,(KKI $ 5,599,653 Transfers to Other Funds $ 230,149 $ 2,30,149 Contingencv S 400,(KK) $ 4(K),O(Kt Total Budget $ 7,548,175 $ 655,000 $ 8,203,175 Reserve For Future Expenditure $ 1,387,142 $ $ 1,387,142 Total Requirements $ 8,935,317 $ 655,000 $ 9,590,317 r. City of Tigard Exhibit A FY 2014 First Qtr Supplemental Budget Amendment 6.Consolidation of CIP projects 94011-Culvert Improvements:Walnut St.(Derry Dell/Fanno Cr.)and 96032-Johnson St.Waterline Replacement with 93010-Derry Dell Creek and Sewer Interceptor Relocation project. After the adoption of the FY 2014 CIP,a couple of issues appeared regarding these projects.First,it was discovered that the Walnut Street culvert improvement project that was not completed last year was omitted from the CIP.Second,it was determined that the Johnson Street Waterline,and the above mentioned culvert project could be included in the Clean\L'ater Service permit package for other agencies. By combining them with the related Derry Dell Sewer Relocation project,the permits and projects can be managed more efficiently. The following budget adjustments are bring requested: Sanitary Sewer-will show an increase in beginning fund balance by$200,000 with an increase in transfers of$455,000.Capital program expenditures will increase by$655,000. Stormwater Fund-rill show an increase in beginning fund balance of$120,000 with an equal increase in transfers out. Water CIP this fund will show a decrease in capital improvement program expenditures by$285,(0). This action will also result in an increase in transfers by the same amount into the Sanitary Sewer Fund. fi&LJC#A-this action will show an increase in beginning fund balance of$50,000 with an increase in transfers to the Sanitary Sewer Fund. Parks Bond-a reallocation of appropriation in the amount$30,0(10 from the Park land Development project is required.This action will have no impact on aiding fund balance. Adopted Revised Budget Amendment Budget Srormwater Fund Resources Beginning Fund Balance $ 2,3%,647 $ 120,000 $ 2,516,647 Property Taxes $ $ - Franchise Fees $ $ licenses&Permits $ - $ - Intergovernmental $ - $ - Charges for Services $ 2,053,830 S 2,053,830 Fines&Forfeitures S $ - Interest Earnings S 7,936 5 7,936 Miscellaneous S S Other Financing Sources $ $ I ransfca In from OIhcr Funcb S S Total Resources f 6 4MWI Requirements Policy and Administration 5 5 Community Development 5 - S - Community Services S - S - Publoc Works $ 1,442,387 $ 1,442,387 Program Expenditures Total t 1,442,387 $ $ 1,442,367 Debt Service S 5 Loans S S Work-In-Progress 5 1,16S,37S $ 1,165,375 Transfers to Other Funds $ 478,916 $ 120,000 $ 598,916 Contingency $ 1(X),000 $ 1(10,(88) Total Budget $ 3,186,678 $ 120,000 $ 3,306,678 Reserve For Future Expenditure $ 1,271,735 $ $ 1,271,735 Total Regtairemrna i 4,456.413 $ 120,000 6 4,S78r U 7 City of Tigard Exhibit A FY 2014 First Qtr Supplemental Budget Amendment 6.Consolidation of CIP projects 94011-Culvert Improvements:Walnut St.(Derry Dell/Fano Cr.)and 96032-Johnson St.Waterline Replacement with 93010-Derry Dell Creek and Sewer interceptor Relocation project. After the adoption of the FY 2014 CIP,a couple of issues appeared regarding these projects.First,it was discovered that the A"alnut Street culvert improvement project that was not completed last year was omitted from the CIP.Second,it was determined that the Johnson Street Waterline,and the above mentioned culvert project could be included in the Clean Water Service permit package for other agencies. By combining them with the related Derry Dell Sewer Relocation project,the permits and projects can be managed more efficiently. The following budget adjustments are being requested: Sanies Sewer-will show an increase in beginning fund balance by$200,000 with an increase in transfers of$455,000.Capital program expenditures will increase by$655,000. Stormwater Fund-will show an increase in beginning fund balance of$120,000 with an equal increase in transfers out. Water CIP-this find will show a decrease in capital improvement program expenditures by$285,000. This action will also result in an increase in transfers by the same amount into the Sanitary Sewer Fund. Gas Tax-this action will show an increase in beginning fund balance of$50,000 with an increase in transfers to the Sanitary Sewer Fund. Parks Bond-a reallocation of appropriation in the amount$30,000 from the Park Land Development project is required.This action will have no impact on ending fund balance. Adopted Revised Budget Amendment Budget Water CIP Fund Resources Beginning Fund Balance $ 84,231,728 $ 84,231,728 Property Taxes $ - $ - Franchise Fees S $ Licenses&Permits $ $ Intergovernmental $ $ Charges for Services $ Fines&Forfeitures $ - $ - Interest Earnings $ 13,096 $ 13,096 Miscellaneous $ - $ - Other Financing Sources $ - $ - Transfers In from Other Funds $ 702,443 $ 702,443 Requirements Policy and Administration S $ - Commumty Development S $ Community Services S $ Public works $ - $ - Program Expenditures Total $ $ $ Debt Service $ $ Loans $ - $ - Wodt-In-Progress $ 75,862,443 $ (285,000) $ 75,577,443 Transfers to Other Funds $ 546,672 $ 285,000 $ 831,672 Contingency $ - $ - Total Budget $ 76,409,115 $ $ 76,409,115 Reserve For Future Expenditure $ 8,538,152 $ $,; 8,538,152' Total Requirements 8 City of Tigard Exhibit A FY 2014 First Qtr Supplemental Budget Amendment 6.Consolidation of CIP projects 94011-Culvert Improvements:Walnut St.(Derry Dell/Fanno Cr.)and 96032-Johnson St.Waterline Replacement with 93010-Derry Dell Creek and Sewer Interceptor Relocation project. After the adoption of the FY 2014 CIP,a couple of issues appeared regarding these projects.First,it was discovered that the Walnut Street culvert improvement project that was not completed last year was omitted from the CIP.Second,it was determined that the Johnson Street Waterline,and the above mentioned culvert project could be included in the(Jean Water Service permit package for other agencies. By combining them with the related Derry Dell Sewer Relocation project,the permits and projects can be managed more efficiently. The following budget adjustments are being requested: Sanitary Sewer-will show an increase in beginning fund balance by$200,000 with an increase in transfers of$455,000.Capital program expenditures will increase by$6S5,000. Stormwater Fund-will show an increase in beginning find balance of$120,000 with an equal increase in transfers out Water CIP-this fund will show a decrease in capital improvement program expenditures by$285,000. Ilhis action will also result in an increase in transfers by the saute amount into the Sanitary Sewer Fund. Gas Tax-this action will show an increase in beginning hind balance of$50,(X1)with an increase in transfers to the Sanitary Sewer Fund. Parks Bond-a reallocation of appropriation in the amount$30,000 from the Park land Development project is required.This action will have no impact cm ending fund balance. Adopted Revised Budget Amendment Budget Gas Tax Fund Resources Beginning Fund Bakmce $ 1,476,663 $ 50,000 $ 1,526,663 Property Tues $ - $ Franchise Fees $ - $ - Licenses&Permits S 2,602 $ 2,602 Intergovernmental S 3,746,852 $ 3,746,852 Charges for Sermes $ - S - Fines&Forfeitures $ - $ - Interest Earnings S 55,732 $ 55,732 Miscellaneous S 60,297 $ 60297 Other Financing Sources S - $ - Transfers In from Other Funds S 100,000 S 100,(()1 Tont Resources i 5,442,146 $ 50,000 $ 5,493,E Requirements Policy and Administration S S Community Development S S Community Services $ - S Public Works $ 22.44,308 S 2,2.44,308 Paognm Expenditum Total t 7,244,308 $ $ 2,244,308 Debt Service 5 606,378 S 6116,378 Loans $ S Work-In-Progress 5 - $ - Transfers to Other Funds 5 2,554,452 $ 50,000 $ 2,014,452 Contingency $ 35,000 $ 35,4M)o Total Budget $ 5,440,138 $ 50,000 $ 5,490,138 Reserve For Future Expenditure $ 2,008 $ $ 2,008 Total Requirements $ 5,442,146 S 50,000 t 51492,146 9 City of Tigard Exhibit A FY 2014 First Qtr Supplemental Budget Amendment 7.Main Street Sewer/Fano Creek Crossing An additional appropriation of$225,000 is being requested for this project.Of this amount,$45,000 is required for purchase of the easement that was not completed last year.As a result,beginning fimd balance will increase by$45,000. In addition,a total of$180,0(10 is being requested to be used for construction along with project and construction management costs. This action will decrease contingency by$180,000 in the Sanitary Sewer Fund.In tum,total capital improvement program expenditures will increase by$225,000. Adopted Revised Budget Amendment Budget Sanitary Sewer Fund Resources Beginning Fund Balance $ 5,852,119 $ 45,000 $ 5,897,119 Property Taxes 5 - f Franchise Fees $ - f I.Icenses&Permits $ 433,800 $ 433,800 Intergovernmental $ - $ - Charges for Services $ 1,484,277 $ 1,484,277 Fines&Forfeitures $ - S - Interest Earnings $ 100,333 $ 100,333 Miscellaneous $ 128,788 $ 128,788 Other Financing Sources $ - $ - Transfcrs In from Other Funds 5 936,(MX) $ 936,000 Total Resources $ 8.35,317 $ 4S,800 $ Requirements Policy and Administration S $ - Community Development S $ Community Services S S - Public Works 19-; S 1,973,373 PmRram Expenditures Total 5 1,973,373 b $ 1,973,373 Debt Smice S - $ Loans S $ Work-In-Progress S 4,944,653 $ 225,000 $ 5,169,653 Transfers to Other Funds $ 230,149 $ 230,149 Contingency $ 400,000 $ (180,000) $ 220,000 Total Budget f 7,548,175 $ 45,X1 $ 7,594175 Reserve For Fuare 1Bxpatdlrone $_ _ 1 WAG i 10 City of Tigard Exhibit A FY 2014 First Qtr Supplemental Budget Amendment 8.Parks CIP Adjustments for 92021-Potso Dog Park,92048-Summer Lake Improvements,&92027-Park Land Development Projects A total of 5240,000 is being requested in order to complete the improvements at Pot;o Dog Park and Summer Lake. This action will be funded by reallocaung appioprintions from the Park Land Development ptojcet which has no impact un appropnanons. (See E%bibii H) 11 City of Tigard Exhibit A FY 2014 First Qtr Supplemental Budget Amendment 9.Ash Street Crossing Study Additional appropriation is requested in order to complete the design and modeling study tied to the Tiedeman/Greenburg Rd./North Dakota Intersection Improvements.This action will result in a decrease of beginning fund balance by$50,000 in the Traffic Impact Fee Fund.In addition, transfers will increase and capital improvement program expenditures will increase by$50,(W. Adopted Re,iscd Budget Amendment Budgei Traffic Impact Fee Fund Resources Beginning Fund Balance $ 772,454 $ 50,000 $ 822,454 Property Taxes - S Franchise Fees $ $ Licenses&Permits $ $ Intergovernmental $ $ Charges for Services $ S Fines&Forfeitures 5 S Interest Earnings S 4,04 H) S 4,1 HW Miscellaneous $ - S Other Financing Sources $ S Transfers In from Other Funds S - S = 776,454 $ 50,000 $ 826,454 Requirements Policy and Administration S Community Development Community Services S Public Works S Program Expenditures Total $ $ 5 Debt Service S - $ - Loans S $ Work-In-Progress S - $ - Transfers to Other Funds S 768,307 S Aw $ 818,307 Contingency S 8,147 $ N,14" Total Budget $ 776,454 $ 50,000 $ 826,451 Reserve For Future Expenditure $ - $ - $ - Total Requirements $ 776,454 $ 50,000 $ 826,454 t2 City of Tigard Exhibit A FY 2014 First Qtr Supplemental Budget Amendment 9.Ash Street Crossing Study Additional appropriation is requested in order to complete the design and modeling study tied to the Tiedeman/Greenburg Rd./North Dakota Intersection Improvements.This action will result in a decrease of beginning fimd balance by$50,000 in the Traffic Impact Fee Fund.In addition, transfers will increase and capital improvement program expenditures will increase by$50,000. Adopted Revised Budget Amendment Budget Transportation CIP Fund Resources Beginning Fund Balance $ 200,369 $ 200,.369 Property Taxes $ - $ - Franchise Fees $ $ Licenses&Permits $ $ Intergovemmental $ $ Charges for Services $ $ Fines&Forfeitures $ $ Interest Earnings $ $ Miscellaneous $ $ Other Financing Sources $ - $ - Transfcrs In from Other Funds $ 5,677,081 $ 50,0(1O $ 5,727,081 Total Reso=�;j. 5,877,450 $ 50,000 $ 5,927,450 Requirements Policy and Administration E - $ - Ccmtmunity Development $ $ Community Services $ $ Public Works $ $ Program Expenditures Total $ $ - $ - Debt Service $ $ Loans $ - $ - Work-In-Progress $ 5,677,081 $ 50,000 $ 5,727,081 Transfers to Other Funds $ - $ - Continlency S - $ - Total Budget $ 5,677,081 $ 50,000 $ 5,727,081 Reserve For Future Expenditure $ 200,369 $ - $ 200,369 Total Requirements $ 5,877,450 $ 50,000 $ 5,927,450 13 City of Tigard Exhibit A FY 2014 First Qtr Supplemental Budget Amendment 10.Capital Improvement Program-Sanitary Sewer Major Maintenance Program A total of$100,000 is being requested for the repair of the sewer at Red Rock Creck that was not completed last year due to permitting issues. This action will increase the beginning fund balance by$100,000 in Sanitary Sewer with an equal increase in capital expenditures program. Adopted Revised Budget Amendment Budget Sanitary Sewer Fund Resources Beginning Fund Balance $ 5,854119 S 100,000 i 5,952,119 Property Taxes S $ Franchise Fees S - $ - lreenses&Permits S 433,800 $ 433,800 Intergovernmental S - $ Charges for Services $ 1,484,277 $ 1,484,277 Fines&Forfeitures $ - $ Interest Earnings S 100,333 $ 100,333 Miscellaneous S 128,788 $ 128,788 Other Financing Sources $ - $ - Transfcrs In from Othcr Funds $ 936,000 $ 9361000 Total Reaottnccs $ 8,9353 Requirements Policy and Administration $ $ Community Development $ $ Community Senices $ $ - Public Works $ 1,973,373 $ 1,973,373 Program Expenditures Total $ 1,973,373 $ $ 4973,373 DebtSerice S $ - Loans S - $ Work-In-Progress S 4,944,653 $ 100,000 $ 5,044,653 Transfers to Other Funds S 230,149 $ 230,149 Contingency $ 40(1,(X1) $ 41X),IXX) Total Budget $ 7,548,175 $ 100,000 $ 7,648,175 Reserve For Future Expenditure $ 1,387,142 $ $ 1,387,142 Total Requirements $ 8,935,317 $ 100,000 $ 9,035,317 14 City of Tigard Exhibit A FY 2014 First Qtr Supplemental Budget Amendment 11.Capital Improvement Program-Waterline Restoration:Black Bull Property A total of$50,000 is being requested to complete design and construction to restore the waterline on the Black Bull property off of North Dakota Street due to illegal excavation.The result will show a decrease in contingency in the Water Fund by$50,000. Transfers will increase with an increase in capital program expenditures of$50,000 in the Water CIP Fund. Adopted Revised Budget Amendment Budget Water Fund Resources Beginning Fund Balance $ 9,701,503 $ 9,701,503 Property Taxes Franchise Fees S - S - licenses&Permits S 13,202 S 13,202 Intergovernmental S - S - Charges for Services S 14,240,169 $ 14,240,169 Fines&Forfeitures $ - S - Interest Earnings S 30,644 S 30,644 Miscellaneous S - S - Other Financing Sources S - $ - Transfers In from Othet Funds S 58,751 $ 58,751 Total Resources $ 24, Requirements Policy and Administration S $ - Community Development S S - Community Services S - S - Public Works S 8,139,852 S 8,139,852 Program Expenditures Total $ 8,139,852 $ - $ 8,139,852 Debt Service S - $ - Loans S - $ Work-In-Progress S - S - Transfers to Other Funds $ 5,735,926 $ 50,000 $ 5,785,926 Contingency S 500,000 $ (50,000) S 450,000 Total Budget $ 14,375,778 $ - $ 14,375,778 Reserve For Future Expenditure $ 9,668,491 $ - $ 9,668,491 Total Rcyoirrnicnts $ 24,044,269 $ - $ 24,044,269 is City of Tigard Exhibit A FY 2014 First Qtr Supplemental Budget Amendment 11.Capital Improvement Program-Waterline Restoration:Black Bull Property A total of$50,000 is being requested to complete design and construction to restore the waterline on the Black Bull property off of North Dakota Street due to illegal excavation.The result will show a decrease in contingency in the Water Fund by$50,000. Transfers will increase with an increase in capital program expenditures of$50,000 in the Water CIP Fund. Adopted Revised Budget Amendment Budget Water CIP Fund Resources Beginning Fund Balance $ 84,231,728 $ 84,231,728 Property Taxes S - $ - Franchise Fees S $ Licenses&Permits S $ Intergovernmental S $ - Charges for Services S 5 - Fines&Forfeitures S 5 - Interest Earnings S 13,096 5 13,096 Miscellaneous S - $ - Other Financing Sources S - S - Transfers In from Other Funds S 702,443 S 50,000 S 752,443 Total Resources $ 84,947,267__,_S__ _.50,000 Requirements Policy and Administration S $ Community Development $ $ Community Services S $ - Public Works 5 $ Program Expenditures Total $ - $ - $ Debt Service 5 $ Loans S S - Work-In-Progress S 75,862,443 $ 50,000 S 75,912,443 Transfers to Other Funds S 546,672 5 546,672 Contingency $ - S - Total Budget $ 76,409,115 $ 50,000 $ 76,459,115 Reserve For Future Expenditure $ 8,538,152 $ - $ 8,538,152 Total Requirements $ 84,%7,267 $ 50,000 $ 84,997,267 16 City of Tigard Exhibit A FY 2014 First Qtr Supplemental Budget Amendment 12.Fanno Creek Trail-Main Street to Grant Avenue The FY 2014 Adopted Budget reflects a total project cost of$491,000 which includes funding from the City Center Development Agency (CCDA).An additional$170,000 of appropriations is being requested to complete permitting and construction on this project In FY 2013,the Parks&Recreation Advisory Board approved a total of$100,000 to be used for construction of the trail.This action will result in a reallocation of$100,000 of Park Bond proceeds from the generic project 92027-Park Land Development with no impact on appropriation.In addition,$50,000 of Gras Tax Funds will be reallocated from 95027-Citywide Pedestnan/Cyclist Improvement project This action will have no impact on appropriations.Lastly,CCDA will be contributing an additional$20,000 for purchase and installation of lighting the trail.This amount will have no affect on CCDA appropriations as it will be reallocated from another project. (Sir Exhibit B) Adopted Revised Budget Amendment Budget Transportation CIP Fund Resources Beginning Fund Balance $ 200,369 $ 200,369 Property Taxes $ - $ Franchise Fees $ $ Licenses&Permits $ $ Intergovernmental $ - $ Charges for Services $ $ Fines&Forfeitures $ - Interest Earnings $ $ Miscellaneous $ $ Other Financing Sources $ - $ - Transfers In from Other Funds S 5,677,081 $ (50,(") S 5,627 081 -tal Resources $ 5,877,450 $ (50,000) $ 5,827,450 Requirements Policy and Administration $ - - Community Development $ Community Services $ Public Forks S - Program Expenditures Total $ $ $ Debt Service $ $ Loans $ $ - Work-In-Progress $ 5,677,081 $ (50,(W) $ 5,627,081 Transfers to Other Funds $ - $ - Contingency $ - $ - Total Budget $ 5,677,081 $ (50,000) $ 5,627,081 Reserve For Future Expenditure $ 200,369 $ $ 200,369 Total Requirements $ 5,877,450 $ (50,000) $ 5,827,450 17 City of Tigard Exhibit A FY 2014 First Qtr Supplemental Budget Amendment 12.Fanno Creek Trail-Main Street to Grant Avenue The FY 2014 Adopted Budget reflects a total project cost of$491,000 which includes funding from the City Center Development Agency (CCDA).An additional$170,(00 of appropriations is being requested to complete permitting and construction on this project. In FY 2013,the Parks&Recreation Advisory Board approved a total of$100,000 to be used for construction of the trail.This action will result in a reallocation of$100,000 of Park Bond proceeds from the generic project 92027-Park land Development with no impact on appropriation.In addition,$50,000 of Gas Tax Funds will be reallocated from 95027-Citywide Pedestrian/Cyclist Improvement project. This action will have no impact on appropriations.lastly,CCDA will be contributing an additional$20,000 for purchase and installation of lighting the trail.This amount will have no affect on CCDA appropriations as it will be reallocated from another project. (,Srr Exhibit B) Adopted Revised Budget Amendment Budget Parks Capital Fund Resources Beginning Fund Balance $ 139,479 $ 139,479 Property Taxes S Franchise Fees S S Licenses&Permits S $ - Intergovemmental 5 163,074 $ 163,074 Charges for Services 5 - $ - Fines&Forfeitures 5 - $ - Interest Earnings 5 3,015 $ 3,015 Miscellaneous $ $ Other Financing Sources S - $ - Transfers In from Other Funds S 7,421,573 S 50fNN) S 7,471,573 Total Remorse. $ 7,727,141 $ 50,000 $ 7,777,141 Requirements Policy and Admim.tran,m S 5 Community Development $ S Community Se--ccs S S Public\\,),k, S S Program Expenditures Total $ - $ - $ Debt Service $ Loans - $ - Work-In-Progress S 7,584,647 $ 50,000 $ 7,634,647 Transfers to Other Funds 100,397 $ 100,397 (;nntinWncv ? - $ - Total Budget $ 7,685,044 $ 50,000 $ 7,735,044 Reserve For Future Expenditure $ 42,097 $ - $ 42,097 Total Requirements $ 7,727,141 $ 50,000 $ 7,777,141 18 Exhibit B 92021-Potso Dog Park Improvements This project was added after the 17Y 2013-14 budget was adopted. \loner to fund this project is being transferred from Project 92027-Park Land Development,which is appropriated as a generic project and is allocated out as projects are identified during the fiscal year. Improvements to POCSo Dog Park include a paved parking lot and stormwater improvements. Original New Budget Projected Budget 2014 This change 2014 2015 Total External Expenses Construction 0 120,000 120,000 0 120,000 Total 0 120,000 120,000 0 120,000 Internal Expenses Project Management 0 20,000 20,000 0 20,000 Design and Engineering 0 0 0 0 0 Construction Management 0 20,000 20,000 0 20,000 Total 0 40,000 40,000 0 40,000 Total Project Expense 0 160,000 160,000 0 160,000 Revenue Funding Source Parks Bond* 0 85,000 85,000 0 85,000 Parks SDC` 0 75,000 75,000 75,000 Total Project Revenues 0 160,000 160,000 0 160,000 Other Revenue Source 0 0 0 0 0 Total Other Revenues 0 0 0 0 0 *Fundinag reallocated ficin 92027-11ark Land Development. There i.r no impact on appiopfiations. Exhibit B 92048-Summer Lake Improvements This project was added after the FY 2013-14 budget was adopted. \loney to fund this project is being transferred from Project 92027-Park Land Development,which is appropriated as a generic project and is allocated out as projects are identified during the fiscal year. The construction of new restrooms are to be provided to this park. Original New Budget Projected Budget 2014 This change 2014 2015 Total External Expenses Construction 0 60,000 60,000 0 60,000 Total 0 60,000 60,000 0 60,000 Internal Expenses Project Management 0 20,000 20,000 0 20,000 Design and Engineering 0 40,000 40,000 0 40,000 Construction\,lanagement 0 20,000 20,000 0 20,000 Total 0 80,000 80,000 0 80,000 Total Project Expense 0 140,000 140,000 0 140,000 Revenue Funding Source Parks Bond* 0 140,000 140,000 0 140,000 Parks SDC 0 0 0 0 Total Project Revenues 0 140,000 140,000 0 140,000 Other Revenue Source Total Other Revenues 0 0 0 0 0 *1'rrnding reallocaled�rorn 92027-Par/ Land Deuelopmerrl. There is rto impact on apf ioprzafionr. Exhibit B 92027-Park Land Development The project 92027-Park Land Development is appropriated as a generic project and is allocated out as projects are identified during the fiscal year. Funding is allocated for Potso Dog Park,Summer Lake Park, and Derr} Dell Creek and Sewer interceptor Relocation projects. Original Budget 2014 This change 2014 2015 Projected Total External Expenses Construction 468,075 (330,000) 138,075 - 138,075 Design and Engineering 143,543 - 143,543 - 143,543 Public Involvement 12,482 - 12,482 - 12,482 Total 624,100 (330,000) 294,100 - 294,100 Internal Expenses Construction Alanagemcnt 82,950 - 82,950 - 82,950 Project Nfanagenent 82,950 - 82,950 - 82,950 Total 165,900 - 165,900 - 165,900 Total Project Expense 790,000 (330,000) 460,000 - 460,000 Revenue Finding Source Parks SDC 475,000 (135,000) 340,000 - 340,000 Parks Bond 315,000 (195,000) 120,000 - 120,000 Total Project Revenues 790,000 (330,000) 460,000 - 460,000 I'nndlrtg reallnca/ed to/befil/owing projea.r with no hwpuct on erppiopriution $ 160,000 Polso Dog Pak(Split 85.000 loiu Bond and 75.000 fiom SDC) $ 140,000 Summer l�k.e re.rlroorn $ 30,000 Deily Dell Creek e:Seiner Inlerceplor Relocation Exhibit B 93010 -Derry Dell Creek& Sewer Interceptor The city-is partnering with Clean Water Service (CWS) and has acquired the Skelton Property in order to replace existing sewers along a new route and re-route Dern-Dell Creek to protect it from future erosion. This project has been combined with 96032 - Johnson Street Waterline Replacement project and has been expanded to include a trail and boardwalk on the Skelton property in order to link the Pathfinder Genesis Trail with the Fanno Creek Trail. Original New Budget Projected Budget 2014 This change 2014 2015 2016 Total External Expenses Design and Engineering 10,000 20,000 30,000 - - 30,000 Public Involvement 5,000 - 5,000 - - 5,000 Constriction 200,000 230,000 430,000 700,000 - 1,130,000 Total 215,000 250,000 465,000 700,000 - 1,165,000 Internal Expenses Project Management 110,000 50,000 160,000 50,000 - 210,000 Construction Management 35,000 50,000 85,000 50,000 - 135,000 Total 145,000 100,000 245,000 100,000 - 345,000 Total Project Expense 360,000 350,000 710,000 800,000 - 1,510,000 Revenue Funding Source Gas Tax Fund - - - 50,000 - 50,000 Parks Bond - 30,000 30,000 - - 30,000 Parks SDC - - - 570,000 - 570,000 Sewer Fund 75,000 200,000 275,000 - - 275,000 Stormwater - 120,000 120,000 180,000 - 300,000 Water CIP 285,000 285,000 - - 285,000 Total Project Revenues 360,000 350,000 710,000 800,000 - 1,510,000 Other Revenue Source Total Other Revenues - - - - - - Exhibit B 92024-Fanno Creek Trail-Main Street to Grant Ave This project includes the installation of a trail from\lain Street to Grant Avenue. This trail is a key part of the larger Fanno Creek Regional Trail System from Portland to Tualatin. The funding provided is for permitting and construction. Construction on this project is expected to be completed in FY 2014. Original Budget 2014 This change 2014 2015 Projected Total External Expenses Construction 410,380 118,437 528,817 - 528,817 Design and Engineering - 51,563 51,563 - 51,563 Public Involvement - - - - - Total 410,380 170,000 580,380 - 580,380 Internal Expenses Construction Management 40,310 - 40,310 - 40,310 Project Management 40,310 - 40,310 - 40,310 Total 80,620 - 80,620 - 80,620 Total Project Expense 491,000 170,000 661,000 - 661,000 Revenue Funding Source Parks Bond - 100,000 100,000 - 100,000 Stormwater Fund 69,000 - 69,000 - 69,000 Sewer Fund 82,000 - 82,000 - 82,000 Parks SDC 143,000 - 143,000 - 143,000 Gas Tax Fund - 50,000 50,000 - 50,000 Total Revenue Funding 294,000 150,000 444,000 - 444,000 NMetro Greenspace 127,000 - 127,000 - 127,000 CCDM\ 70,000 20,000 90,000 - 90,000 Total Other Funding 197,000 20,000 217,000 - 217,000 Total Revenues 491,000 170,000 661,000 - 661,000 Exhibit B 95027-Citywide Pedestrian&Cyclist Improvements This program allows the addition of sidewalks,hike lanes,short trail connections,and related facilities in order to link key gaps in the city's pedestrian and bicycle systems. This program also provides funding for the pedestrian amenities on major capital projects. Original Budget 2014 This change 2014 Projected Total External Expenses band/ROW 50,000 (50,000) - - Construction - - - - Design and Engineering 20,000 - 20,000 20,000 Pubhc Involvement - - - - Total 70,000 (50,000) 20,000 20,000 Internal Expenses Construction\Management - - - - Project Management 10,000 - 10,000 10,000 Total 10,000 - 10,000 10,000 Total Project Expense 80,000 (50,000) 30,000 30,000 Revenue Funding Source Gas Tax Fund 80,000 (50,000) 30,000 30,000 Total Project Revenues 80,000 (50,000) 30,000 30,000 FY 2014 First Quarter Supplemental Attachment-2 Summary of Budget Changes Adopted Ql Revised Budget Amendment Budget Affected City Funds Resources Beginning Fund Balance $ 113,213,675 $ 565,000 $ 113,778,675 Property Taxes S 13,020,535 $ - S 13,020,535 Franchise Fees S 5,601,400 $ S 5,601,400 Special Assessments S 120,000 $ S 120,000 Licenses&Permits $ 1,381,359 S S 1,381,359 Intergovernmental $ 9,485,307 S 33,643 S 9,518,950 Charges for Services $ 28,399,393 $ - S 28,399,393 Fines&Forfeitures $ 1,098,783 S S 1,098,783 Interest Earnings $ 319,071 $ $ 319,071 Miscellaneous $ 213,987 $ 14,868 $ 228,855 Other Financing Sources S 361,000 S - $ 361,000 Transfers In from Other Ftimlx c 15,757,053 S 614,11' S 16,391,390 Total Resources S 188,971,563 $ 1,247,848 $ 190,219,411 Requirements Policy and Administration $ 7,297,024 S 79,337 S 7,376,361 Community Development S 3,094,988 S (71,040) S 3,023,948 Community Services S 20,048,141 S 33,643 S 20,081,784 Public Works S 20,895,015 S 198,040 S 21,093,055 Program Expenditures Total $ 51,335,168 $ 239,980 $ 51,575,148 Debt Service S 606,378 S - S 606,378 Loans S 361,000 S - S 361,000 Work-In-Progress S 95,234,199 S 795,000 S 96,029,199 Transfers to Other Funds S 11,331,111 $ 555,000 S 11,886,111 Contingency S 2,608,147 S (342,132) S 2,266,015 Total Budget $ 161,476,003 $ 1,247,848 $ 162,723,851 Reserve For Future Expenditure $ 27,495,560 $ - $ 27,495,560 Total Rcquircmcnts $ 188,971,563 $ 1,247,848 $ 190,219,411 1 of 12 FY 2014 First Quarter Supplemental Attachment-2 Summary of Budget Changes Reference Budget Items: 2,3 Adopted Revised Budget Amendment Budget General Fund Resources Beginning Fund Balance $ 8,156,853 S $ 8,156,853 Property Taxes $ 13,020,535 $ S 13,020,535 Franchise Fees $ 5,601,400 $ S 5,601,400 Special Assessments $ - $ $ - Licenses&Permits $ 900,135 $ - S 900,135 Intergovernmental $ 5,575,381 $ 33,643 S 5,609,024 Charges for Services S 3,230,653 $ - $ 3,230,653 Fines&Forfeitures S 1,098,783 $ $ 1,098,783 Interest Earnings $ 103,722 $ $ 103,722 Miscellaneous $ 24,902 $ $ 24,902 Other Financing Sources S 361,000 $ S 361,000 Transfers In from Other I-Li rnds S Total Resources $ 38,073,364 $ 33,643 $ 38,107,007 Requirements Policy and Administration S 802,516 $ - $ 802,516 Community Development S 3,094,988 $ (71,040) $ 3,023,948 Community Services $ 20,048,141 $ 33,643 $ 20,081,784 Public Works S 5,396,382 $ 71,040 $ 5,467,422 Program Expenditures Total $ 29,342,027 $ 33,643 $ 29,375,670 Debt Service S - $ - S - Loans S 361,000 $ S 361,000 Work-In-Progress $ - $ $ - Transfers to Other Funds S 916,292 $ S 916,292 Contingency 1,200,000 $ S 1,200,000 Total Budget $ 31,819,319 $ 33,643 $ 31,852,962 Reserve For Future Expenditure $ 6,254,045 $ - $ 6,254,045 Total Requirements $ 38,073,364 $ 33,643 $ 38,107,007 2of12 FY 2014 First Quarter Supplemental Attachment-2 Summary of Budget Changes Reference Budget Items: 1 Adopted Revised Budget Amendment Budget Central Service Fund Resources Beginning Fund Balance $ 199,348 $ - $ 199,348 PropertyTaxes $ - $ - S - Franchise Fees $ - $ S - Licenses&Permits S 31,620 $ S 31,620 Intergovernmental $ - $ $ - Charges for Services S 5,750,628 S $ 5,750,628 Fines&Forfeitures $ - S $ - Interest Earnings $ 593 $ $ 593 Miscellaneous $ - $ $ - Other Financing Sources $ $ $ - Transfers In from Other Bunds S 861,205 S 79,337 $ 940,542 Total Resources $.6,843,394 Requirements Policy and Administration $ 6,494,508 S 79,337 $ 6,573,845 Community Development $ - S - $ - Community Services $ S - $ - Public Works S S S - Program Expenditures Total $ 6,494,508 $ 79,337 $ 6,573,845 Debt Service S - S - S Loans S S S Work-In-Progress S S - S Transfers to Other Funds S S - S Contingency S 3.30,000 S S 34'),O()()_ Total Budget $ 6,834,508 $ 79,337 $ 6,913,845 Reserve For Future Expenditure $ 8,886 $ - $ 8,886 Total Requirements $ 6,843,394 $ 79,337 $ 6,922,731 3of12 FY 2014 First Quarter Supplemental Attachment-2 Summary of Budget Changes Reference Budget Items: 4,11 Adopted Reviscd Budget Amendment Budget Water Fund Resources Beginning Fund Balance $ 9,701,503 $ - $ 9,701,503 Property Taxes S - S - $ - Franchise Fees S - S - $ - Licenses&Permits S 13,202 S - $ 13,202 Intergovernmental S - S - $ - Charges for Services S 14,240,169 S - $14,240,169 Fines&Forfeitures S - $ - $ - Interest Earnings S 30,644 S - S 30,644 Miscellaneous S - S S - Other Financing Sources S - $ S - Transfcrs In from Other Funds 1� 88,751 S c 58,751 Total Resources $24,044,269 $ - $24,044,269 Requirements Policy and Administration S S S Community Development S S S Community Services S $ S Public Works $ 8,139,852 $ 100,000 $ 8,239,852 Program Expenditures Total $ 8,139,852 $ 100,000 $ 8,239,852 Debt Service S - S - S - Loans S S S Work-In-Progress S - $ $ Transfers to Other Funds S 5,735,926 S 50,000 S 5,785,926 Contingency S 500,000 S (150,000) S 350,000 Total Budget $14,375,778 $ - $14,375,778 Reserve For Future Expenditure $ 9,668,491 $ - $ 9,668,491 Total Requirements $24,044,269 $ - $24,044,269 4of12 FY 2014 First Quarter Supplemental Attachment-2 Summary of Budget Changes Reference Budget Items: 5 Adopted Revised Budget Amendment Budget Fleet/Property Management Fund Resources Beginning Fund Balance $ 86,512 $ - $ 86,512 Property Taxes S - S S - Franchise Fees S $ S Licenses&Permits S S $ Intergovernmental $ S $ Charges for Services $1,639,836 S S1,639,836 Fines&Forfeitures $ S S Interest Earnings $ $ $ Miscellaneous $ $ 14,868 $ 14,868 Other Financing Sources S S - $ - Transfcrs In from Other Funds 11 1 Total Resources $1,726,348 $ 14,868 1,7412W- Requirementss Policy and Administration S Community Development $ - S S - Community Services S S - $ - Public Works S 1,698,713 S 27,000 $1,725,713 Program Expenditures Total $1,698,713 $ 27,000 $1,725,713 Debt Service S S - S Loans S S - S Work-In-Progress S S $ Transfers to Other Funds $ S $ Contingency S 25,000 S (12,132) $ 12,868 Total Budget $1,723,713 $ 14,868 $1,738,581 Reserve For Future Expenditure $ 2,635 $ - $ 2,635 Total Requirements $1,726,348 S 14,868 $1,741,216 5 of 12 FY 2014 First Quarter Supplemental Attachment-2 Summary of Budget Changes Reference Budget Items: 6,7,10 Adopted Revised Budget Amendment Budget Sanitary Sewer Fund Resources Beginning Fund Balance $5,852,119 $ 345,000 $6,197,119 Property Taxes $ S - S Franchise Fees S S - S Licenses&Permits $ 433,800 S S 433,800 Intergovernmental $ - S $ - Charges for Services $1,484,277 S S1,484,277 Fines&Forfeitures $ - S S - Interest Earnings $ 100,333 S S 100,333 Miscellaneous S 128,788 S $ 128,788 Other Financing Sources S - $ $ - Transfcrs In from Othcr bunds S 936,000 S 455,000 $1,391,000 Total Resources $8,935,317 $ 800,000 $9,735,3 Requirements Policy and Administration $ S S Community Development $ S - S Community Services $ - $ $ - Public Works $1,973,373 $ $1,973,373 Program Expenditures Total $1,973,373 $ $1,973,373 Debt Service S S $ Loans S S $ Work-In-Progress S4,944,653 S 980,000 $5,924,653 Transfers to Other Funds S 230,149 S - $ 230,149 Contingency S 400,000 S (180,000) $ 220,000 Total Budget $7,548,175 $ 800,000 $8,348,175 Reserve For Future Expenditure $1,387,142 $ - $1,387,142 Total Requirements $8,935,317 $ 800,000 $9,735,317 0 of 12 FY 2014 First Quarter Supplemental Attachment-2 Summary of Budget Changes Reference Budget Items: 6 Adopted Revised Budget Amendment Budget Stormwater Fund Resources Beginning Fund Balance $2,396,647 $ 120,000 $2,516,647 Property Taxes $ $ - $ Franchise Fees $ $ S Licenses&Permits $ S S - Intergovernmental $ S S - Charges for Services $2,053,830 S $2,053,830 Fines&Forfeitures S - $ $ - Interest Earnings S 7,936 S $ 7,936 Miscellaneous S - $ S - Other Financing Sources S S S - 'I'ransfers In from Other bunds S - - S Total Resources $4,458,413 $ 120,000 $4,578,413 Requiremt Policy and Administration S Community Development S S S Community Services S - S S - Public Works $ 1,442,387 S S 1,442,38' Program Expenditures Total $1,442,387 $ $1,442,387 Debt Service $ S S Loans $ S S Work-In-Progress $1,165,375 S S 1,165,375 Transfers to Other Funds S 478,916 S 120,000 $ 598,916 Contingency S 100,000 S - $ 100,000 Total Budget $3,186,678 $ 120,000 $3,306,678 Reserve For Future Expenditure $1,271,735 $ - $1,271,735 Total Reyuirennents $4,458,413 $ 120,000 $4,578,413 7of12 FY 2014 First Quarter Supplemental Attachment-2 Summary of Budget Changes Reference Budget Items: 6,11 Adopted Revised Budget Amendment Budget Water CIP Fund Resources Beginning Fund Balance $84,231,728 $ $84,231,728 Property Taxes S S S Franchise Fees S S S Licenses&Permits S S S Intergovernmental $ $ S Charges for Services $ $ S Fines&Forfeitures $ $ S Interest Earnings $ 13,096 S S 13,096 Miscellaneous S - S $ - Other Financing Sources S - S $ - Transfers in from Other bunds S 702,443 S 50,000 S 752,443 �"'- Total Resources $84,947,267 $ 50,000 $94,97W- Requirements Policy and Administration $ $ - $ Community Development $ $ - $ - Community Services S S $ - Public Works S S $ - Program Expenditures Total $ - $ - $ - Debt Service $ $ $ Loans $ - S $ Work-In-Progress S 75,862,443 $ (235,000) $75,627,443 Transfers to Other Funds S 546,672 $ 285,000 $ 831,672 Contingency S - $ - $ - Total Budget $76,409,115 $ 50,000 $76,459,115 Reserve For Future Expenditure $ 8,538,152 $ - $ 8,538,152 Total Requirements $84,947,267 $ 50,000 $84,997,267 8 of 12 FY 2014 First Quarter Supplemental Attachment-2 Summary of Budget Changes Reference Budget Items: 6 Adopted Reviscd Budget Amendment Budget Gas Tax Fund Resources Beginning Fund Balance $1,476,663 $ 50,000 $1,526,663 Property Taxes $ $ - $ - Franchise Fees $ $ $ - Licenses&Permits $ 2,602 $ $ 2,602 Intergovernmental $3,746,852 S $3,746,852 Charges for Services $ $ S Fines&Forfeitures $ $ S Interest Earnings $ 55,732 $ $ 55,732 Miscellaneous $ 60,297 $ S 60,297 Other Financing Sources $ - $ - S - Transfcrs In from Otho 1 uml> S 100,000 S ` 1111 nig Total Resources $5,442,146 $ 50,000 $5,492,146 Requirements Policy and Administration S - S Community Development $ S $ Community Services $ S $ Public Works $2,244,308 S $2,244,308 Program Expenditures Total $2,244,308 $ $2,244,308 Debt Service $ 606,378 $ $ 606,378 Loans $ - $ $ - Work-In-Progress $ - $ S - Transfers to Other Funds $2,554,452 S 50,000 S2,604,452 Contingency S 35,000 S - S 35,000 Total Budget $5,440,138 $ 50,000 $5,490,138 Reserve For Future Expenditure $ 2,008 $ - $ 2,008 Total Rcqoircmcnts $5,442,146 $ 50,000 $5,492,146 9of12 FY 2014 First Quarter Supplemental Attachment-2 Summary of Budget Changes Reference Budget Items:9 Adopted Rc%iscd Budget Amendment Budget Traffic Impact Fee Fund Resources Beginning Fund Balance $ 772,454 $ 50,000 $822,454 Property Taxes S S - S Franchise Fees $ - S S Licenses&Permits S S $ Intergovernmental S S S Charges for Services $ S S Fines&Forfeitures S S S Interest Earnings S 4,000 $ S 4,000 Miscellaneous $ - $ S - Other Financing Sources $ - $ S Transfers In from Other Fut S S S Total Resources $ 776,454 $ 50,000 $826,454 Requirements Policy and Administration S - S Community Development S S - S Community Services S S S Public Works S S S Program Expenditures Total $ - $ - $ - Debt Service $ $ $ Loans S S $ Work-In-Progress S S - $ Transfers to Other bunds S 768,307 $ 50,000 $818,307 Contingency S 8,147 S - S 8,147 Total Budget $ 776,454 $ 50,000 $826,454 Reserve For Future Expen $ - $ - $ - Total Requirements $ 776,454 $ 50,000 $826,454 10 of 12 FY 2014 First Quarter Supplemental Attachment-2 Summary of Budget Changes Reference Budget Items:9,12-Note that these taro items cancel each other out Adopted Revised Budget Amendment Budget Transportation CIP Fund Resources Beginning Fund Balance $ 200,369 $ $ 200,369 Property Taxes $ - S S - Franchise Fees $ $ $ Licenses&Permits $ S S Intergovernmental $ $ $ Charges for Services $ $ $ Fines&Forfeitures $ $ S Interest Earnings $ $ S Miscellaneous $ $ $ Other Financing Sources $ - $ S Transfers In from Othey Funds S 5,677,081 S S 5,677,081 Total Resources $ 5,877,450 $ - $ 5,877,450 Requirements Policy and Administration S - S S - Community Development S S $ - Community Services $ S S Public Works $ S S Program Expenditures Total $ - $ - $ - Debt Service S S S Loans $ $ S Work-In-Progress S 5,677,081 S S 5,677,081 Transfers to Other Funds S - S S - Contingency S - S S - Total Budget $ 5,677,081 $ - $ 5,677,081 Reserve For Future Expenditure $ 200,369 $ - $ 200,369 Total Requirements $ 5,877,450 $ - $ 5,877,450 11 of 12 FY 2014 First Quarter Supplemental Attachment-2 Summary of Budget Changes Reference Budget Items:12 Adopted Rcviscd Budget Amendment Budget Parks Capital Fund Resources Beginning Fund Balance $ 139,479 S $ 139,479 Property Taxes $ - S $ - Franchise Fees $ - $ $ Licenses&Permits $ - $ $ Intergovernmental $ 163,074 $ $ 163,074 Charges for Services $ - $ $ - Fines&Forfeitures $ - S $ - Interest Earnings $ 3,015 S $ 3,015 Miscellaneous $ - $ $ - Other Financing Sources $ - S S - Transfers In from Other Funds S7,421,573 S 50,000 <',471,;-, Total Resources $7,727,141 $ 50,000 $7,777,141 Requirements Policy and Administration Community Development S Community Services S Public Works S Program Expenditures Total $ $ $ Debt Service S S S Loans S S S Work-In-Progress $7,584,647 S 50,000 S7,634,647 Transfers to Other Funds S 100,397 S - S 100,397 Contingency S - S - $ - Total Budget $7,685,044 $ 50,000 $7,735,044 Reserve For Future Expenditure $ 42,097 $ - $ 42,097 Total Requirements $7,727,141 $ 50,000 S7,777,141 12 of 12