Loading...
HomeMy WebLinkAboutSpecial 2011-11-21 COMPLETE AGENDA PACKETCitv of Tukwila City of Tukwila Budget Workshop November 21, 2011 City Hall Council Chambers 5:00 p.m. 7:00 p.m. Agenda L CIP Priorities IL Attachment A III. Budget Amendment Page 2 o f 49 Agenda Item I CIP Priorities NOTE: On the first two pages, the numbers on the far left represent pages numbers, not priority Page 3 of 49 page 4of49 City of Tukwila CAPITAL IMPROVEMENT PROGRAM for 2012-2017 BRIDGES ARTERIAL STREETS APE /Industry Dr Intersection 75 "Other City After Six RESIDENTIAL STREETS 2012 2013 2014 2015 2016 2017 TOTAL Sources Revenue Years 2 40 -42 Ave South (S 160 St S 131 PL) 650 0 0 200 2,800 0 3,650 0 3,650 4,360 5 Residential Improvements 0 0 200 300 0 0 500 0 500 1,393 Residential Streets Total 650 0 200 500 2,800 0 1 4,150 1 011 4,15011 5,753 BRIDGES ARTERIAL STREETS Traffic Impact Fee Projects 19 APE /Industry Dr Intersection 75 25 0 0 0 0 Total "Other City After Six Grant Funded 2012 2013 2014 2015 2016 2017 Project Sources Revenue Years 9 Boeing Access Rd Bridge Replacement 0 1,750 1,750 13,617 13,617 0 1 30,787 1 24,588 11 6,199 11 Bond 10 TUC Pedestrian /Bicycle Bridge 984 390 100 7,485 0 0 9,218 8,296 922 0 16 Tukwila Urban Center Transit Center 4,204 2,664 0 0 0 0 7,522 6,046 1,476 0 17 Andover Pk W (Tuk Pkwy Strander) 799 1,318 0 0 0 0 2,204 1,842 362 0 28 Interurban Ave S (S 143 Fort Dent) Scheduled in Beyond 0 0 0 1 0 1 5,00011 6,100 11 11,100 0 Grant Funded Total 5,987 6,122 1,850 21,102 13,617 0 1 60,831 1 45,77211 15,059 11 11,100 111 8,519 Total on this Spreadsheet 16,883 8,207 4,015 23,667 18,362 "Other City After Six Annual Programs 2012 2013 2014 2015 2016 2017 TOTAL Sources Revenue Years 14 Annual Overlay and Repair Program 1,350 1,450 1,500 1,550 1,560 1,650 9,060 0 9,060 1,670 15 Annual Traffic Signal Program 50 150 100 105 115 115 635 0 635 115 8 Annual Bridge Inspections and Repairs 205 205 270 270 270 270 1,490 0 1,490 270 27 Walk Roll Program 0 0 0 140 0 0 140 0 140 0 Annual Programs Total 1,605 1,805 1,870 2,065 1,945 2,035 1 11,325 1 0 11 11,325 11 2,055 Total "Other City After Six Projects Currently Underway with completion in 2012 Project Sources Revenue Years 1� 12 Southcenter Pkwy (S 180 S 200 St) 6,295 0 0 0 0 0 1 19,4301 13,909 11 5,52111 Bond I 13 Tukwila Urban Center Access (Klickitat) 2,251 0 0 0 0 0 25,118 24,178 940 0 18 Transportation Element of Comp Plan 20 0 0 0 0 0 400 70 330 0 Currert Projects Total 8,566 0 0 0 0 0 I 44,948 I 38,157 11 6,791 11 0 Traffic Impact Fee Projects 19 APE /Industry Dr Intersection 75 25 0 0 0 0 100 75 25 575 20 APE /Minkler Blvd Intersection 0 75 45 0 0 0 120 55 65 622 21 W Valley Hwy/ S 156 St Intersection 0 75 0 0 0 0 75 75 0 1,032 22 S 144th St Phase 11 (42 Ave S TIB) 0 68 0 0 0 0 88 68 20 1,750 23 S 133 St /SR599 Intersection 0 20 0 0 0 0 20 19 1 630 24 Macadam Rd S 144 St Intersection 0 17 0 0 0 0 21 21 0 610 25 E Marginal Way (BAR S 112 St) 0 0 50 0 0 0 50 50 0 3,300 Traffic Impact Fee Total 75 280 95 0 0 0 474 363 111 8,519 Total on this Spreadsheet 16,883 8,207 4,015 23,667 18,362 2,035 I 121,728 I 84,292 II 37,436 II 1 69.25 30.75 Grand Total in 104 Fund for 2012 CIP 16,233 8,207 3,815 23,167 15,562 2,035 69,019 I 61,458 II 7,561 II Page 5 of 49 1 H' \CIP \Budget Workshop 11- 21- 11.xlsx Page 6 o f 49 City of Tukwila CAPITAL IMPROVEMENT PROGRAM for 2012-2017 Page 7 of 49 H' \CIP \Budget Workshop 11- 21- 11.xlsx "Other City After Six RESIDENTIAL STREETS 2012 2013 2014 2015 2016 2017 TOTAL Sources Revenue Years 2 40 -42 Ave South (S 160 St S 131 PL) 650 0 0 200 2,800 0 3,650 0 3,650 4,360 5 Residential Improvements 0 0 200 300 0 0 500 0 500 1,393 Residential Streets Total 650 0 200 500 2,800 0 I 4,150 I 011 4,15011 5,753 BRIDGES ARTERIAL STREETS "Other City After Six Grant Funded 2012 2013 2014 2015 2016 2017 TOTAL Sources Revenue Years 9 Bond 10 TUC Pedestrian /Bicycle Bridge 984 390 100 7,485 0 0 8,959 8,037 922 0 16 Tukwila Urban Center Transit Center 4,204 2,664 0 0 0 0 6,868 5,163 1,476 0 17 Andover Pk W (Tuk Pkwy Strander) 799 1,318 0 0 0 0 2,117 1,420 362 0 28 Scheduled in Beyond 0 0 0 Grant Funded Total 5,987 4,372 100 7,485 0 0 I 17,944 I 14,62011 2,76011 0 "Other City After Six Annual Programs 2012 2013 2014 2015 2016 2017 TOTAL Sources Revenue Years 14 Annual Overlay and Repair Program 1,350 1,450 1,500 1,550 1,560 1,650 9,060 0 9,060 1,670 15 Annual Traffic Signal Program 50 150 100 105 115 115 635 0 635 115 8 Annual Bridge Inspections and Repairs 205 205 270 270 270 270 1,490 0 1,490 270 27 Walk Roll Program 0 0 0 140 0 0 140 0 140 0 Annual Programs Total 1,605 1,805 1,870 2,065 1,945 2,035 I 11,325 I 0 II 11,325 II 2,055 Projects Currently Underway with completion in 2012 12 0 0 0 0 0 I 0 I II II Bond 13 0 0 0 0 0 0 0 18 0 0 0 0 0 0 0 Currert Projects Total 0 0 0 0 0 0 I 0 I 0 11 011 0 Traffic Impact Fee Projects 19 APE /Industry Dr Intersection 75 25 0 0 0 0 100 75 25 575 20 APE /Minkler Blvd Intersection 0 75 45 0 0 0 120 55 65 622 21 W Valley Hwy/ S 156 St Intersection 0 75 0 0 0 0 75 75 0 1,032 22 S 144th St Phase 11 (42 Ave S TIB) 0 68 0 0 0 0 88 68 20 1,750 23 S 133 St /SR599 Intersection 0 20 0 0 0 0 20 19 1 630 24 Macadam Rd S 144 St Intersection 0 17 0 0 0 0 21 21 0 610 25 E Marginal Way (BAR S 112 St) 0 0 50 0 0 0 50 50 0 3,300 Traffic Impact Fee Total 75 280 95 0 0 0 474 363 111 8,519 Grand Total 8,317 6,457 2,265 10,050 1,945 2,035 I 35,693 I 17,347 II 18,346 II 48.60% 5140% Page 7 of 49 H' \CIP \Budget Workshop 11- 21- 11.xlsx Page 8 o f 49 City of Tukwila CAPITAL IMPROVEMENT PROGRAM for 2012-2017 CIP Page PROJECT TITLE 2 40 -42 Ave South (S 160 St S 131 PL) 3 Small Roadway Safety Improvements 4 Neighborhood Traffic Calming Program 5 Residential Improvements Grand Total Chanaes from 2011 to 2012 CIP: No new additions. RESIDENTIAL STREETS 103 Fund **Denotes other funding sources, grants, or mitigation. Page 9 of 49 2012 2017 Capital Improvement Program 1 11/17/2011 **Other After Six 2012 2013 2014 2015 2016 2017 TOTAL Sources Years 650 0 0 200 2,800 0 3,650 0 4,360 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 200 300 0 0 500 0 1,393 650 0 200 500 2,800 0 4,150 0 5,753 **Denotes other funding sources, grants, or mitigation. Page 9 of 49 2012 2017 Capital Improvement Program 1 11/17/2011 CITY OF TUKWILA CAPITAL PROJECT SUMMARY 2012 to 2017 PROJECT: 40 -42 Ave South (S 160 St S 131 PL) Project No. 99410303 DESCRIPTION: Design and construct street improvements, drainage, undergrounding, and driveway adjustments. JUSTIFICATION: Provide pedestrian and vehicle safety, drainage, and neighborhood revitalization. STATUS: IPhase III (S /C Blvd (154th) S 160 St) $3m, Design in 2012, construction in 2017. Project No. 94 -RS03 I ma 4 Page 10 of 49 2012 2017 Capital Improvement Program 2 Phase I (S /C Blvd (154) S 144 St) $3,796, Completed. Project No. 90 -RW15 Phase II (S 144 St- S 139 St) $1,850, Completed. Project No. 94 -RS02 Phase IV (S 139 St S 131 PI) $1 m in beyond. Project No. 94 -RS01 MAINT. IMPACT: Reduce pavement, shoulder, and drainage work. COMMENT: Design of Phase III in 2012. FINANCIAL Through Estimated (in $000's) 2010 2011 2012 2013 2014 2015 2016 2017 BEYOND TOTAL EXPENSES Design 1,235 650 100 1,985 Land(R/W) 27 100 127 Const Mgmt. 400 560 960 Construction 4,246 2,400 3,800 10,446 TOTAL EXPENSES 5,508 0 650 0 0 200 2,800 0 4,360 13,518 FUND SOURCES Awarded Grant 0 Proposed Grant 0 Mitigation Actual 0 Mitigation Expected 0 City Oper. Revenue 5,508 0 650 0 0 200 2,800 0 4,360 13,518 TOTAL SOURCES 5,508 0 650 0 0 200 2,800 0 4,360 13,518 I ma 4 Page 10 of 49 2012 2017 Capital Improvement Program 2 CITY OF TUKWILA CAPITAL PROJECT SUMMARY 2012 to 2017 PROJECT: Residential Improvements Project No. Varies DESCRIPTION: Select, design and construct residential streets and /or water and /or sewer projects go Page 11 of 49 2012 2017 Capital Improvement Program 5 Neighborhood revitalization by improving residential streets. Program is project oriented to specific residential JUSTIFICATION: streets that require quick design and construction. 53rd Ave S (137 -144), 37th Ave S (135- Tuk Int'I Blvd), S 132nd St (Tuk Int'I Blvd Military Road), and STATUS: S 150th St (42 -TIB) are prioritized future candidates. MAINT. IMPACT: Reduce maintenance. COMMENT: 53rd Ave S design is proposed for 2014/2015 (project may also have surface water improvements). FINANCIAL Through Estimated (in $000's) 2010 2011 2012 2013 2014 2015 2016 2017 BEYOND TOTAL EXPENSES Design 200 300 500 Land(R/W) 0 Const. Mgmt. 180 180 Construction 1,213 1,213 TOTAL EXPENSES 0 0 0 0 200 300 0 0 1,393 1,893 FUND SOURCES Awarded Grant 0 Proposed Grant 0 Mitigation Actual 0 Mitigation Expected 0 City Oper. Revenue 0 0 0 0 200 300 0 0 1,393 1,893 TOTAL SOURCES 0 0 0 0 200 300 0 0 1,393 1,893 go Page 11 of 49 2012 2017 Capital Improvement Program 5 City of Tukwila CAPITAL IMPROVEMENT PROGRAM for 2012-2017 BRIDGES ARTERIAL STREETS 104 Fund CIP **Other After Six Page PROJECT TITLE 2012 2013 2014 2015 2016 2017 TOTAL Sources Years 8 Annual Bridge Inspections and Repairs 205 205 270 270 270 270 1,490 0 270 9 Boeing Access Rd Bridge Replacement 0 1,750 1,750 13,617 13,617 0 30,734 30,734 0 10 TUC Pedestrian /Bicycle Bridge 984 390 100 7,485 0 0 8,959 8,037 0 11 BNSF Regional Center Access 0 0 0 0 0 0 0 0 0 12 Southcenter Pkwy (S 180 S 200 St) 6,295 0 0 0 0 0 6,295 5,667 0 13 Tukwila Urban Center Access (Klickitat) 2,251 0 0 0 0 0 2,251 10,154 0 14 Annual Overlay and Repair Program 1,350 1,450 1,500 1,550 1,560 1,650 9,060 0 1,670 15 Annual Traffic Signal Program 50 150 100 105 115 115 635 0 115 16 Tukwila Urban Center Transit Center 4,204 2,664 0 0 0 0 6,868 5,163 0 17 Andover Pk W (Tuk Pkwy Strander) 799 1,318 0 0 0 0 2,117 1,420 0 18 Transportation Element of Comp Plan 20 0 0 0 0 0 20 7 0 19 APE /Industry Dr Intersection 75 25 0 0 0 0 100 75 575 20 APE /Minkler Blvd Intersection 0 75 45 0 0 0 120 55 622 21 W Valley Hwy/ S 156 St Intersection 0 75 0 0 0 0 75 75 1,032 22 S 144th St Phase II (42 Ave S TIB) 0 68 0 0 0 0 68 0 1,750 23 S 133 St/SR599 Intersection 0 20 0 0 0 0 20 20 630 24 Macadam Rd S 144 St Intersection 0 17 0 0 0 0 17 1 610 25 E Marginal Way (BAR S 112 St) 0 0 50 0 0 0 50 50 3,300 26 Strander Blvd /SW 27th St Extension 0 0 0 0 0 0 0 0 2,500 27 Walk Roll Program 0 0 0 140 0 0 140 0 0 28 Interurban Ave S (S 143 Fort Dent) 0 0 0 0 0 0 0 0 11,100 29 TUC /TOD Pedestrian Improvements 0 0 0 0 0 0 0 0 1,100 30 Minkler Blvd (APW SIC Pkwy) 0 0 0 0 0 0 0 0 425 31 Tukwila Int'l Blvd Phase IV 0 0 0 0 0 0 0 0 4,591 32 Traffic Signal Interconnect Program 0 0 0 0 0 0 0 0 3,000 33 Southcenter Blvd (1 -5 61 st Ave Br) 0 0 0 0 0 0 0 0 20,000 34 Tukwila Int'l Blvd /S 116th Wy /SR599 0 0 0 0 0 0 0 0 4,675 35 S 168 St (SIC Pkwy APE) 0 0 0 0 0 0 0 0 23,244 36 West Valley Hwy (1 -405 Strander Blvd) 0 0 0 0 0 0 0 0 630 37 Rockery Replacement Program 0 0 0 0 0 0 0 0 525 38 Nelsen PI (S 158 St S 156 St) 0 0 0 0 0 0 0 0 200 39 S 180 St/Andover Pk W Intersection 0 0 0 0 0 0 0 0 210 40 S 143 St (Interurban Duwamish) 0 0 0 0 0 0 0 0 100 41 S 134 St (S 133 St 48 Ave S) 0 0 0 0 0 0 0 0 100 42 S 144th St Bridge Sidewalks 0 0 0 0 0 0 0 0 100 43 S 178th St Realignment 0 0 0 0 0 0 0 0 9,382 Grand Total 16,233 8,207 3,815 23,167 15,562 2,035 69,019 61,458 92,456 Traffic Impact Fee List Projects (project must be started within 8 years). **Denotes other funding sources, grants, or mitigation. Chanaes from 2011 to 2012 CIP: New: No new projects. Deleted: Tukwila Int'l Blvd Phases II III (116 138) completed in 2011. Page 12 of 49 2012 2017 Capital Improvement Program 7 11/17/2011 Land(R/W) Const. Mgmt. Construction TOTAL EXPENSES FUND SOURCES Awarded Grant Proposed Grant Bond Mitigation Expected City Oper. Revenue TOTAL SOURCES 1,602 1,602 12,015 12,015 53 0 0 1,750 1,750 13,617 13,617 1,400 1,400 10,894 10,894 350 350 2,723 2,723 53 0 0 0 0 0 0 53 0 0 1,750 1,750 13,617 13,617 (9 Project Location G1S Page 13 of 49 0 3,204 24,030 0 0 30,787 0 24,588 6,146 0 0 0 53 0 0 30,787 2012 2017 Capital Improvement Program 9 CITY OF TUKWILA CAPITAL PROJECT SUMMARY 2012 to 2017 PROJECT: Boeing Access Rd over BNRR Bridge Replacement Project No. 99410408 Replace the existing bridge with a 340' long concrete or steel bridge structure. It will be 110' wide curb to DESCRIPTION: curb and have sidewalks on both sides. The existing bridge is structurally and seismically deficient. Several pedestals are leaning, have concrete JUSTIFICATION: spalls, exposed rusty anchor bolts and reinforcements and some cracks. The existing railings do not meet standards. Type, size, and location draft report (specifically required for bridges) was completed in 2005. Federal grant STATUS: applications were submitted in 2008 and 2010. City will continue to submit application for funding as federal bridge funds are made available. MAINT. IMPACT: Maintenance will be reduced. New bridge will be constructed in phases to allow continued traffic use. Construction of projects over COMMENT: $10 million are only funded at 80% for federal funding. A Bond issue will be required for the City match. FINANCIAL Through Estimated (in $000's) 2010 2011 2012 2013 2014 2015 2016 2017 BEYOND TOTAL EXPENSES Design 53 1,750 1,750 3,553 Land(R/W) Const. Mgmt. Construction TOTAL EXPENSES FUND SOURCES Awarded Grant Proposed Grant Bond Mitigation Expected City Oper. Revenue TOTAL SOURCES 1,602 1,602 12,015 12,015 53 0 0 1,750 1,750 13,617 13,617 1,400 1,400 10,894 10,894 350 350 2,723 2,723 53 0 0 0 0 0 0 53 0 0 1,750 1,750 13,617 13,617 (9 Project Location G1S Page 13 of 49 0 3,204 24,030 0 0 30,787 0 24,588 6,146 0 0 0 53 0 0 30,787 2012 2017 Capital Improvement Program 9 C���' &Qa 1I WTV97 AIIr_1NUZION=10I11MULTA 2012 to 2017 PROJECT: Tukwila Urban Center Pedestrian /Bicycle Bridge Project No. 90510403 DESCRIPTION: Construct a new pedestrian /bicycle bridge over the Green River. JUSTIFICATION: Pedestrian /bicycle connection between Tukwila's Urban Center and commuter rail /Amtrak station. Supports local and regional goals and policies regarding land use and transportation in Urban Center. Pedestrian System Report identified the optimal location for bridge crossing to be south of the Best STATUS: Western Hotel. Type, Size, and Location Report was completed in 2011. Council approved a design of a twin -tied arch bridge with no accommodation for a future bridge crossing over West Valley Highway. MAINT. IMPACT: To be determined. State Enhancement design grant for $190k and Transit Oriented Development (TOD) planning grant of $55k. COMMENT: State Enhancement grant of $500k and Federal CMAQ grant of $750,833 for final design. Project is on Park Impact Fee list with funding of $2 million with an 80 %/20% split. FINANCIAL Through Estimated (in $000's) 2010 2011 2012 2013 2014 2015 2016 2017 BEYOND TOTAL EXPENSES Design 229 30 984 390 1,633 Land(R/W) 100 100 Const. Mgmt. 1,000 1,000 Construction 6,485 6,485 TOTAL EXPENSES 229 30 984 390 100 7,485 0 0 0 9,218 FUND SOURCES Awarded Grant 229 30 916 321 1,496 Proposed Grant 5,200 5,200 Mitigation Actual 0 Park Impact Fees Expected 35 80 1,485 1,600 City Oper. Revenue 0 0 68 34 20 800 0 0 0 922 TOTAL SOURCES 229 30 984 390 100 7,485 0 0 0 9,218 s Pro feCt LL7Catlaf7 y a s >F, TuMwru akwy e um 1 upad 9 P p +jp R JJ�� �9y�rn P 61805• Mn Page 14 of 49 2012 2017 Capital Improvement Program 10 C���' &Qa 1I WTV97 AIll r_1NUZION=10I11MULTA m el T S 2012 to 2017 PROJECT: Tukwila Urban Center Transit Center Project No. 90610402 DESCRIPTION: Design and construct a Transit Center for the Tukwila Urban Center (TUC). C High transit ridership and bus operations warrant conversion of the existing bus stops on Andover Park West JUSTIFICATION: to a Transit Center. The current facilities are inadequate in size and location to serve Metro operations and transit riders. City policy encourages the use of transit, and mitigation dollars and parking supply decisions �xt q bIA'.b, have been made based upon the expected improvements to the transit center. U{tl _pr STATUS: Design began in 2006. Construction schedule is linked to milestones identified in the State Mobility grant. nnitll'R MAINT. IMPACT: Minimal to moderate, depends on final maintenance agreement with King County Metro. 1ritinC c]r TOD grant of $468k with mitigation from Westfield S/C Mall of $500k for parking variance. WSDOT Regional COMMENT: Mobility Grant of $4.7m with $3.9m in 2011 -2013 and $835k in 2013 -2015 with a required match of 20% that can include past expenditures, other grants, and ROW value of land dedicated by Westfield. FINANCIAL Through Estimated (in $000's) 2010 2011 2012 2013 2014 2015 2016 2017 BEYOND TOTAL EXPENSES Design 271 40 738 1,049 Land (R/W) 343 916 1,259 Const. Mgmt. 250 300 550 Construction 2,300 2,364 4,664 TOTAL EXPENSES 614 40 4,204 2,664 0 0 0 0 0 7,522 FUND SOURCES Awarded TOD Grant 40 428 468 Awarded Mob Grant 2,400 2,335 4,735 Mitigation Actual 500 500 ROW Donation 343 343 City Oper. Revenue (229) 0 1,376 329 0 0 0 0 0 1,476 TOTAL SOURCES 614 40 4,204 2,664 0 0 0 0 0 7,522 m el T S s Page 15 of 49 2012 2017 Capital Improvement Program 16 q C �xt q bIA'.b, U{tl _pr nnitll'R Saharr, 1ritinC c]r s Page 15 of 49 2012 2017 Capital Improvement Program 16 C���' &Qa 1I WTV97T U IIr_1NU:ZOaJX01111MU il ►TilTI M FUND SOURCES Awarded Grant Proposed Grant Mitigation Actual 316 Impact Fees 101 5 City Oper. Revenue (340) 5 TOTAL SOURCES 77 10 355 1,065 444 799 253 0 0 1,318 0 0 l�liit9J$C LCyCc't %Cl7 Ji J- s iss s 3 160 st W 6'. S 0 1,420 316 106 0 0 0 362 0 0 0 2,204 �7_ Yin r v v_ J T A x Uvvand, sa_ I H Page 16 of 49 2012 2017 Capital Improvement Program 17 2012 to 2017 PROJECT: Andover Park West (Tukwila Pkwy Strander Blvd) Project No. 98810404 Zone 1 DESCRIPTION: Study and implement revised channelization. JUSTIFICATION: Revising left turn lanes will reduce accidents and lessen congestion. Major portion of Andover Park W at intersections are complete. Next phase is to revise turn lanes along STATUS: length of project. To be coordinated with Tukwila Urban Center Transit Center and APW water improvements. MAINT.IMPACT: Negligible. Project is on impact fee list and goal is to begin project by 2011. Design report completed in 1991 was updated COMMENT: in 2009. ACME Bowling mitigation of $111 k and Westfield Mall of $205k in 2007. Proposed TIB grant of $1.42m in 2012. Partial match from APW water overlay for $346k (see page 89). FINANCIAL Through Estimated (in $000's) 2010 2011 2012 2013 2014 2015 2016 2017 BEYOND TOTAL EXPENSES Design 77 10 278 365 Land(R/W) 80 80 Const. Mgmt. 41 122 163 Construction 400 1,196 1,596 TOTAL EXPENSES 77 10 799 1,318 0 0 0 0 0 2,204 FUND SOURCES Awarded Grant Proposed Grant Mitigation Actual 316 Impact Fees 101 5 City Oper. Revenue (340) 5 TOTAL SOURCES 77 10 355 1,065 444 799 253 0 0 1,318 0 0 l�liit9J$C LCyCc't %Cl7 Ji J- s iss s 3 160 st W 6'. S 0 1,420 316 106 0 0 0 362 0 0 0 2,204 �7_ Yin r v v_ J T A x Uvvand, sa_ I H Page 16 of 49 2012 2017 Capital Improvement Program 17 Project Location S 12 W E S 2012 to 2017 PROJECT: Interurban Ave S (S 143 St Fort Dent Way) Project No. 90310402 3 T St DESCRIPTION: Design and construct sidewalks, pavement restoration, drainage and lighting. Pedestrian traffic is forced to walk in traveled way, lighting is substandard, drainage is poor and o� JUSTIFICATION: pavement failure is accelerating. A I3 47 1 .a 150 SC Completed 90% of design in 2010. State TIB grant submitted in 2011. Federal STP construction grant STATUS: submitted in 2009 was unsuccessful. MAINT. IMPACT: Reduce annual pavement repairs and increase pedestrian safety. COMMENT: Federal Hwy STP Grant of $389,000 for design only. Proposed grants are Federal and State TIB. FINANCIAL Through Estimated (in $000's) 2010 2011 2012 2013 2014 2015 2016 2017 BEYOND TOTAL EXPENSES Design 464 250 714 Land(R/W) 150 150 Const. Mgmt. 1,300 1,300 Construction 9,400 9,400 TOTAL EXPENSES 464 0 0 0 0 0 0 0 11,100 11,564 FUND SOURCES Awarded Grant 389 389 Proposed Grant 5,000 5,000 Mitigation Actual 0 Impact Fees 0 City Oper. Revenue 75 0 0 0 0 0 0 0 6,100 6,175 TOTAL SOURCES 464 0 0 0 0 0 0 0 11,100 11,564 Project Location S 12 W E S Page 17 of 49 2012 2017 Capital Improvement Program 28 3 T St 1 �S� 37 o� N Sti443t 77 D A I3 47 1 .a 150 SC Page 17 of 49 2012 2017 Capital Improvement Program 28 CITY OF TUKWILA CAPITAL PROJECT SUMMARY 2012 to 2017 PROJECT: Andover Park W /Strander New Water Main Project No. 99840105 DESCRIPTION: Design and construct 2,100 LF of a 12" pipe along Andover Park West from Tukwila Pkwy to Strander Blvd JUSTIFICATION: Aging cast iron pipe and deficiencies under fire flow conditions. STATUS: Coordinated with the Transit Center and Andover Park West street improvements MAINT. IMPACT: Improved service would reduce maintenance liability. COMMENT: FINANCIAL Through Estimated (in $000's) 2010 2011 2012 2013 2014 2015 2016 2017 BEYOND TOTAL EXPENSES Design 165 165 Land(R/W) 0 Const. Mgmt. 177 177 Construction 1,212 1,212 TOTAL EXPENSES 0 0 1,554 0 0 0 0 0 0 1,554 FUND SOURCES Awarded Grant 0 Proposed Grant 0 Mitigation Actual 0 Mitigation Expected 0 Utility Revenue 0 0 1,554 0 0 0 0 0 0 1,554 TOTAL SOURCES 0 0 1,554 0 0 0 0 0 0 1,554 :y Project Loc ation S 16 9i r 2 1 \I 2 A r A t 44' Is s®xom s rmmnwo. st tl I Page 18 of 49 2012 2017 Capital Improvement Program 89 CITY OF TUKWILA CAPITAL PROJECT SUMMARY 2012 to 2017 PROJECT: Gilliam Creek 42 Ave S Culvert Project No. 99341208 DESCRIPTION: Design and replace the 36 -inch culvert under 42 Ave S /Gilliam Creek Pro ,lect Location The existing concrete pipe sections are separating and cracked which could erode the 42 Ave S fill and JUSTIFICATION: lead to loss of roadway. Trenchless repair techniques were reviewed as part of the 2005/2006 Small Drainage Design and are not feasible due to the structural deficiencies of the pipe. A complete pipe replacement will be required. Recent STATUS: video inspection revealed that the pipe's cracking has increased since the project was identified in 1993. The pipe will continue to be monitored and replaced as part of the future 42nd Ave S street project. R2pla( 1 MAINT. IMPACT: Will reduce monitoring when complete. Exlst ng Cu —t State Fish Wildlife hydraulic project approved (HPA) permit will be required. Replacement will require a fish COMMENT: passable structure. FINANCIAL Through Estimated (in $000's) 2010 2011 2012 2013 2014 2015 2016 2017 BEYOND TOTAL EXPENSES Design 125 125 Land(R/W) 0 Const. Mgmt. 36 36 Construction 8 200 208 TOTAL EXPENSES 8 0 125 236 0 0 0 0 0 369 FUND SOURCES Awarded Grant 0 Proposed Grant 0 Mitigation Actual 0 Mitigation Expected 0 Utility Revenue 8 0 125 236 0 0 0 0 0 369 TOTAL SOURCES 8 0 125 236 0 0 0 0 0 369 Pro ,lect Location 22p fi n i f 6� !�y Page 19 of 49 2012 2017 Capital Improvement Program 146 'n� R2pla( 1 Exlst ng Cu —t Remove sediment and existing weir Rravide 1 ©g� webs Far grade rontrol, r9 22p fi n i f 6� !�y Page 19 of 49 2012 2017 Capital Improvement Program 146 M I M I M 7 i S c �1 o U M IH m N H N O I U N ttS N I y O N 0 0 0 0 N o� V .I I F l MGM `1 a N I UI UJ co o O N d N N 0 o a X.�l d 0 O N l6 O r N d a) R d y U 0) i 'o i 0) 'o f O XIII k (7 a O O O N N 0 0 0 0 0 O O O O O O V O O O O O O O N N M O M O O O O N 0 0 0 I� V M N O CO CO CO M (O (O O O N N (O O O O� 10 O M O V O 0 0 (O N 10 O N N M V V N V M O V N O Q O I I I I I I I I I I I I I I I I I I O V Il O rl V O O M co N O O O CO CO CO CO O O O O O O O O O O O CO CO CO CO CO CO M N O rl N O O O N 0 M 00 W O to O O (6 O O N co M M co O D N M O 0 0 M 0 0 0 O O O O O co co co co co co O O O O O O O V O O(0 N O O N U of ti d I I I I I I I I I I I I I I I I I I 0 t 0 N O N U w6 C\ O O N (p O N t O cvi (o «j O N O O O O O N N T N V T 0) rl O O 00 N M r, O O N O l O M i cq `V N N O O O O O O }I N 00 00 U C V 0 00 O 0 V Q 2 E o N M I..V N O O V M U 0 0 O +r W E 0) M CV) O O N. ON W) i.! O N O N U m 00 o O n N O V O M O O O M O O M O V M N N N O O to N 0 U (O V M O rl O N W N O O O O M M to O N O M O 0 c Y W N n O `J N O Co Co M O O NO V M 2' O (O N N O 0 0 cv V (O O M M �O d CU CU O r- 00 0) O N M V In M 00 d) O N O') V In (0 1- 00 O O N M V In M r 00 O) O N M Z N N N N N N N N N N O') M O') 0') 0') 0') 0') 0') 0') 0') V V V V N p fn N t Mn N O m U U O s i N O 0) m C S N W 0 U c E Y H U O N w N U am) d Q N O) 0 i 0) 0 O C a m a' a o y N i cA cA 0 E U (o Y a o Q c d 0) r.+ 0) m C 00 y U N Y E y 0) C Q O i O t fn 0) i N C Q M 0) Y E fn Q t6 G) U) -0 N U d 0) c m a a m )n E op m op t W N E a C> a V U 3 U T r �U) 0) M N M m a m U U �j o s''W �.t�u) d� d¢-0 daMim V 0.0 mm`A�"a ds Y aY au�� X- -a 0 o 0 Ua a n 05 m Q d d 7 O H u) a� a> cq cq E W p m m m 0 m cq m of d c 3 Q Oi C m a LL of N� m F O Q C O M 0 0- 3 O 0) C U t C 00 Y N O M V V a a 0 C 0) U N C U 6 W O M U N U C Y 3 Y M N U N 00 V M V I m Q m H m 0) fA H Q Q H Q H Q Q (A (A 20 W fA H H H (A H fA W Z w w w w w O r N d a) R d y U 0) i 'o i 0) 'o f O XIII 0 N N d a) R IL x fn Il O r 00 O O rl O O N O O co O O N co O co O N O O O O N N O O N O t\ O O N N 05 M (O (O O V (O O O I� N O rl N O O Q (n r M V N N N O I I I I I I I I I O O O O V M O O O O O O O O O O O Co N. Co Co Co Co 0) M M O V (O O (f) N (O N V O N N m c LO rl O rl (O Il O O O O O O Co Co Co Co Co N M N. O O O O) 00 N N N O O N. 0) c U I t I I I I I I I I V C-4 O V N V O 0 o 0 0 (0 N O N O N Co N E T N C;) r d o 0 p 0 N L N LO N `V N 0 1 N O O cq N cq O U y H v 00 .M O 0 0 0 0 00 Q N LL 0 0 C O N w6 CL N V O O U m N N (n (n O N (n 00 U a LO cq �1 W O V O M 0 i (D 0 r r W N V O 00 O N N O) LO O O N N N N i 0) 0) O (n a z c w c r c 00 c m c O 0 N (n 0 M 0 Q 0 In 0 w 0 r 0 00 0 m O 0 m m N (0 M m Q m In m w r m m OD (0 f U N O 0) 05 U U O U N c O E (V O Q Q O U 6 0 J i G� N N 3 O 0) j( otS O_ 0) SL 0) Y 0) U i O Y) O) LL m x Q 0 i O t 05 i cu d oc) In .d d N N 00 O j V d d otf p d 05 U 05 d 05 J 0) U U Q f F 0� N .N T p 0) 0) O 7 Y Q Y cu 05 0 Q N O x O C x Q 05 r O i U) r 0) _,.e Y U 05 U t O m U 3 C 0) d U 0) 0) N d d 3 0 U 3 O LL c9 m m d 3 H O U it� (n T a m O m O x �i 0 d' U z 0 O x1v 0 N N d a) R IL XV x fn O O O O O O O O O O x CO o O O O O O x (n 0 0 C. O 0 Co O V O O v O a5 N O O N N (5 O O O (U I- O V li N Q O 06 O) N O) N Q Q} (h V V U) O O O O O O O O O Co Co w) a) LO M LO M a) a) L O N O N N O O N O W) N N E O Co v as m as C\i o o— W o— N 0 0 0 00 0(D 0 0 0 LO N LO N O 00 M N I I I I I d O O LO L t t t O O O O co O LO O N w6 w6 w6 V w6 (n U U U (ti O O O O M O (D O °o O c c� O N O w6 N O LO O LO w6 O N w6 w6 0 U ti U ti U ti �ti N E N o 0 0 o N O 0 O O o O co c� N i N O I� N `V N N V +r v d O O O O O O N O N O 0 t t t C 0 0 0 0 o o O o N o V C L C L O M —O y O O O N O Il N. cq O M O M o O O O O o O `v O O O Q O N 00 U W �1L�1�� O O O O— O O M M (LO LO w6 w6 w6 0 L o o v o o O O O O w o (D cq N O N N N_ O N N N LO N (D O O CV) N U U C\i U s d d d 01 O z O (D O r r N r r 01 O z In (D I- I- r I- 00 r- 01 O z O) r- O 00 00 N 00 00 U a) d d d 'o a N U U m m L o m o i r N i m i a U G� m O N U J y E O i cu N 0 w J H O O D so d p J N H J 7 O J O 0 O Q 0 Q~ y m O_ c cu m O d a5 m E fn O N m m LL O ,m p CD p cu o] a E E a) d a o> (n j d 0 7 cn w H pw d D H c y 3 J 3 a LL �j 3 a Q° m d w E cn d d cn E o cn E o d E w v a`) v O O *L 7 O cn O 'i W U U ii H W LL Z Z d XV Agenda Item II Attachment A Memo from Peggy McCarthy: Proposed 2012 -2017 Financial Planning Model CIP Attachment A Attachment A: Footnotes Attachment B Attachment G Attachment G: Footnotes Page 24 of 49 Page 25 of 49 City of Tukwila Jim Haggerton, Mayor INFORMATIONAL MEMORANDUM TO: Mayor Haggerton Councilmembers FROM: Peggy McCarthy, Interim Finance Director DATE: November 18, 2011 SUBJECT: Proposed 2012 -2017 Financial Planning Model and Capital Improvement Program ISSUE Consider for approval the Proposed 2012 -2017 Financial Planning Model and Capital Improvement Program. 1 20] :0]L110111] Each year the Financial Planning Model and Capital Improvement Program is updated. A draft of the model was distributed at the October 3 rd Regular meeting and the CIP projects were reviewed at an October 25 Budget /CIP Workshop. The November 21 workshop will provide Council an opportunity to further review the CIP projects and to review the Financial Planning Model. DISCUSSION Certain comments on the model follow. Attachment A: 1. Gambliu tax revenue has been extended through 2017. The voters indicated through the November 8 advisory vote their desire to retain gambling in the City. In anticipation of possible Council action repealing Ordinance 2323, gambling tax is shown as a revenue source in 2016 and 2017. 2. The one -time sale of property was reduced to $1M and moved to 2013. It represents one property the City currently is considering for sale during this period. 4. The model excludes the loan to the Park District with disbursements in 2012 and 2013 the subsequent payback starting in 2013 since the financial effect on the six -year period will be less than $500K. 5. The estimated unfunded PERS remains as a line item in the model but funds for this contingency are not currently being set aside. An option for funding this contingency would be to include it as an element of the Reserve Fund and increase the Reserve Fund funding requirements. 6. Various line items were revised to reflect the November 14 Council decisions regarding the Golf Course Fund financial protocols. Page 26 of 49 INFORMATIONAL MEMO Page 2 7. Based on the model, at the end of the six -year period the ending fund balance of the governmental funds totals $2.725M and of the Reserve Fund totals $8.2M. Attachment B: 1. The projections for the Parks Recreation operations and maintenance expenditures were increased to reflect the effect of the Council decisions on the Golf Course Fund financial protocols. 2. The schedule includes a transfer to the Golf Course Fund of $575K comprised of existing budget of $225K and proposed budget of $350K. This amount is a place holder in case such transfers are needed to provide working capital for the golf course. The amount will revert back to fund balance if not needed and not used. Attachment G: 1. The 2011 estimate reflects a reduction in greens fees and concession proceeds stemming from a closer analysis of year to date actual results. The green fees are considerably lower than the actual fees earned in 2010 and 2009 due to the unusually wet and cold weather experienced in several months in 2011. 2. The greens fee estimate for 2012 is conservative and is based on 2011 estimated results and the fee increase that will go into effect January 1, 2012. The conservative estimate assumes the 2012 weather will be similar to 2011. Hopefully this will not be the case and the weather will be much warmer and drier in 2012 than it was in 2011. 3. The reduction in revenue estimates negatively impacts the model's net cash flow for the six -year period. The $575K transfer -in place holder is reflected in the model, consistent with its inclusion in Attachment B, in case funds are needed to provide working capital. 4. Carryover from 2011 currently modeled at $328K, represents working capital comprised of course maintenance and pro shop inventories of $270K and refundable deposits of $50K. The golf course unrestricted cash and investment balance at the end of 2011 is estimated to be approximately $20K. Both the operational and financial policies regarding the inventory levels will be reviewed during 2012. RECOMMENDATION The Council will be asked to consider the Proposed 2012 -2017 Financial Planning Model and Capital Improvement Program at the November 28 Committee of the Whole meeting and to forward this item to the December 5 th Regular meeting for approval. ATTACHMENTS Attachment A with notes Attachment B Attachment G with notes Page 27 of 49 VV FIN Projects\Council Agenda Items \Workshop 11- 21- 11VnfoMemo_Financial Planning Model.doc ATTACHMENT A CITY OF TUKWILA TOTAL REVENUES EXPENDITURES 2012 2017 Analysis in 000's 2013 2014 16,492 16,739 14,215 14,570 4,985 5,135 1,512 1,550 1,000 0 1,545 1,628 2,577 2,654 2,112 2,175 4,294 4,423 1,706 1,757 836 861 1,657 1,707 52,930 53,199 206 212 355 366 133 137 67 68 114 118 875 901 53,806 54,100 47,010 49,125 6,037 3,130 2,100 2,100 835 868 318 328 (2,494) (1,450) 0 200 2,550 1,935 338 142 (4,355) 0 500 500 0 0 (967) 2,777 (1,527) (4,227) 0 0 18,860 14,632 6,100 8,200 2015 17,241 14,934 5,289 1,588 0 1,741 2,734 2,240 4,556 1,810 887 1,758 54,779 219 377 141 70 121 928 55,706 51,336 2,643 0 903 338 487 500 2,865 142 0 500 0 4,007 (3,520) 0 11,112 2012 2017 Financial Planning Model Vi l 2016 17,759 15,308 5,447 1,628 0 1,820 2,816 2,307 4,692 1,864 914 1,811 56,366 219 377 141 72 125 933 57,299 53,646 2,414 0 939 338 (37) 2,800 1,945 (58) 0 500 (50) 5,137 (5,174) 0 5,938 2017 Totals 18,291 102,770 15,690 88,585 5,611 31,307 1,669 9,422 0 1,000 1,907 10,165 2,901 16,184 2,377 13,260 4,833 26,967 1,920 10,712 941 5,252 1,865 10,408 58,005 326,032 225 1,280 388 2,209 145 826 74 415 129 718 961 5,448 58,966 331,480 56,060 302,736 2,406 19,909 0 6,700 939 5,287 348 1,978 (787) (5,130) 0 4,150 2,035 7,561 (54) 1,629 0 (4,255) 500 5,215 (55) (155) 2,426 14,145 (3,213) (19,275) 0 22,000 2,725 8,200 Page 28 of 49 1111812011 2009 2010 2011 2011 REVENUES (see A -1) Actual Actual Budget Estimate 2012 General Revenues Sales Tax 14,739 16,060 15,400 16,200 16,248 Property Taxes 12,190 13,189 13,530 13,800 13,868 Utility Taxes 4,942 4,064 4,723 4,800 4,840 RGRL 1,900 1,465 1,475 One -time sale of property 700 10 0 Interfund Utility Taxes 1,813 1,498 1,426 1,500 1,524 Gambling Taxes 2,568 2,110 2,586 2,400 2,502 Contract Agreement SCL 1,967 2,071 2,000 2,000 2,050 Charges /Fees for Services 2,727 3,985 4,338 4,345 4,169 Transfers In -Other Funds 1,857 1,696 1,475 1,837 1,656 Intergovernmental Revenue 3,572 1,189 872 949 812 Other Taxes /Miscellaneous 2,793 2,386 2,432 2,400 1,609 Subtotal 49,168 48,248 51,382 51,706 50,753 Dedicated Revenues (Capital) Real Estate Taxes 257 379 201 250 200 Motor Vehicle Taxes 393 394 339 360 345 Investment Interest /Misc. 136 62 18 100 129 Property Taxes 12 0 64 99 65 Parking Taxes 156 144 108 133 111 Subtotal 954 979 730 942 850 TOTAL REVENUE AVAILABLE 50,122 49,227 52,112 52,648 51,603 EXPENDITURES Operations Maintenance: 44,641 43,640 45,335 44,100 45,560 (See Attachment B) Debt Service 2,094 2,331 2,925 2,750 3,279 Transfer to Reserve Fund 0 0 400 1,500 2,500 Estimated Unfunded PERS 0 0 0 0 803 Admin /Engineering Overhead 497 552 384 515 309 Subtotal Available 2,890 2,704 3,068 3,783 (848) Capital Attachment C Residential Streets 0 32 (80) 20 650 Arterial Streets /Bridges 5,560 1,202 2,705 2,000 (3,769) Parks Trails 0 315 590 (43) 1,119 General Government Facilities 193 16 101 10 100 General Imp /HHD Response 2,612 1,740 2,144 326 2,715 Fire Improvements 0 0 0 (50) (50) Subtotal Capital 8,365 3,305 5,460 2,263 765 Balance by Year (5,475) (601) (2,392) 1,520 (1,613) Carryover from 2011 26,556 21,082 18,640 20,480 22,000 Accumulated Totals 21,081 20,481 16,248 22,000 20,387 Reserve fund balance 1,500 4,000 2013 2014 16,492 16,739 14,215 14,570 4,985 5,135 1,512 1,550 1,000 0 1,545 1,628 2,577 2,654 2,112 2,175 4,294 4,423 1,706 1,757 836 861 1,657 1,707 52,930 53,199 206 212 355 366 133 137 67 68 114 118 875 901 53,806 54,100 47,010 49,125 6,037 3,130 2,100 2,100 835 868 318 328 (2,494) (1,450) 0 200 2,550 1,935 338 142 (4,355) 0 500 500 0 0 (967) 2,777 (1,527) (4,227) 0 0 18,860 14,632 6,100 8,200 2015 17,241 14,934 5,289 1,588 0 1,741 2,734 2,240 4,556 1,810 887 1,758 54,779 219 377 141 70 121 928 55,706 51,336 2,643 0 903 338 487 500 2,865 142 0 500 0 4,007 (3,520) 0 11,112 2012 2017 Financial Planning Model Vi l 2016 17,759 15,308 5,447 1,628 0 1,820 2,816 2,307 4,692 1,864 914 1,811 56,366 219 377 141 72 125 933 57,299 53,646 2,414 0 939 338 (37) 2,800 1,945 (58) 0 500 (50) 5,137 (5,174) 0 5,938 2017 Totals 18,291 102,770 15,690 88,585 5,611 31,307 1,669 9,422 0 1,000 1,907 10,165 2,901 16,184 2,377 13,260 4,833 26,967 1,920 10,712 941 5,252 1,865 10,408 58,005 326,032 225 1,280 388 2,209 145 826 74 415 129 718 961 5,448 58,966 331,480 56,060 302,736 2,406 19,909 0 6,700 939 5,287 348 1,978 (787) (5,130) 0 4,150 2,035 7,561 (54) 1,629 0 (4,255) 500 5,215 (55) (155) 2,426 14,145 (3,213) (19,275) 0 22,000 2,725 8,200 Page 28 of 49 1111812011 Page 29 of 49 ATTACHMENT A -1 NOTES TO REVENUES GENERALREVENUES Sales Tax The sales tax estimate for 2012 reflects a 1.5% increase from 2010 actual receipts, plus approximately $1.2 million in mitigation money from the Department of Revenue. The expected increase for 2013 -2015 is 1.5% annually, and 3.0% for 2016 -2017. Property Taxes Tax collections are projected to grow at a rate of 2.5% for 2012 -2017. The estimate is based on increases in assessed values, as determined by the King County Assessor's Office, and new construction and tenant improvements. Utility Taxes A utility tax was approved beginning in 2003 at an initial rate of 4 increased to 5 and to 6% in 2007. The tax applies to electric, natural gas, and communications sales. In 2009, Council adopted a 6% utility tax on solid waste collection in the City and also adopted an interfund utility tax on the water, sewer and surface water funds. Gambling Taxes Estimated revenue for 2012 reflects the projected impact of new gambling activities at the Denny's location. Assuming all other casinos continue operations, the estimates for City revenues are conservative. Contract Agreement Seattle City Light (SCL) The City entered into a contract agreement with SCL in 2003 with a 4% contract payment. The rate was increased to 5% in 2006 and to 6% in 2007. The rate currently remains at 6 Charges /Fees for Services The amount includes Department of Community Development (DCD) revenues consisting of permits, licenses, fees, fines and forfeitures. The 2012 estimate includes $1,909 for licenses and permits and $2,260 for charges for services. Transfers In Other Funds Reflects the General fund support for Tukwila's Hotel /Motel Tax fund, the Internal Service funds and the Enterprise funds. This is expected to have a growth rate of 3% annually. Page 30 of 49 2012 2017 Financial Planning Model VIII ATTACHMENT A -1 continued Intergovernmental Revenue Includes regular on -going revenues such as liquor taxes and profits, emergency services (EMS) allocation and special non recurring grants. Other Taxes /Miscellaneous Includes admission taxes, and developer contributions. Annual growth is projected at 3% for 2012 -2017. DEDICATED REVENUES CAPITAL Real Estate Taxes This revenue source fluctuates as it is driven by property sale transactions. Motor Vehicle Taxes Revenue estimates for 2012 -2017 are based on historical collections. Investment Interest Interest earnings have stabilized and we are projecting very little growth given the current economic outlook. Property Taxes Provides a revenue source for debt service on capital facility replacements. Parking Taxes The parking tax, which began in 1999, is being used for the arterial street program. The growth rate is projected to be flat at the present time. Cash Carryover from 2011 Consists of the General Fund $6,000,000 and the Capital Funds: Streets $700,000, Arterial Streets $7,400,000, Land Acquisition and Parks $5,000,000, Facilities $2,000,000 and General Improvements $900,000 for a total of $22,000,000. Amounts do not include the $2,000,000 balance in the Contingency Fund 105 at 2011 and the total in this fund at 2017 of $8,075,000. Page 31 of 49 2012 2017 Financial Planning Model IX ATTACHMENT B City of Tukwila General Fund Operations Maintenance Expenditures 2012 2017 Analysis in 000's TOTAL EXPENDITURES 43,640 Notes: 2012 2010 EXPENDITURES Actuals City Council 243 Mayor, Boards 2,229 Human Resources 464 Finance 2,183 City Attorney 579 Parks Recreation 4,123 Community Development 2,635 Municipal Court 1,209 Police 13,166 Fire 9,914 Information Technology 953 Public Works /Streets 5,689 Dept. 20 Miscellaneous 253 Transfers to Golf Course 1,829 TOTAL EXPENDITURES 43,640 Notes: 2012 2013 2014 2015 2016 2017 Totals 270 282 295 308 322 336 1,814 2,523 2,637 2,755 2,879 3,009 3,144 16,947 573 599 626 654 683 714 3,849 1,603 1,675 1,751 1,829 1,912 1,998 10,767 543 567 593 620 648 677 3,647 3,509 3,667 3,832 4,005 4,185 4,373 23,571 2,684 2,805 2,931 3,063 3,201 3,345 18,028 994 1,039 1,085 1,134 1,185 1,239 6,677 14,063 14,696 15,357 16,048 16,770 17,525 94,460 10,226 10,686 11,167 11,670 12,195 12,743 68,687 1,154 1,206 1,260 1,317 1,376 1,438 7,751 6,290 6,573 6,869 7,178 7,501 7,838 42,249 553 578 604 631 659 689 3,714 575 575 45,560 47,010 49,125 51,336 53,646 56,060 302,736 A 4.5% increase is anticipated for the years 2013 -2016 due to the expected increases in healthcare, retirement rates, and general inflationary pressures. Most of the increases will be related to salaries and benefits. Moderate cost -of- living allowances (COLAS) are projected along with the normal annual step increases. The Rainy Day contingency and the estimated ending fund balances are not shown here as budgeted amounts because they are considered reserves to be used in emergencies. Page 32 of 49 2012 2017 Financial Planning Model X 1 11/18/2011 Page 33 of 49 REVENUES Green Fees'' Sales Tax (z) Merchandise Sales Power Cart Rentals Concession Proceeds Other Revenue (s) Total Revenues EXPENDITURES Operations Maintenance Indirect Cost Allocation Debt Service j6 Subtotal Golf Capital CIP Program Total Expenditures Cash Flow Year by Year Carryover from 2011 Accumulated Totals 2009 Actual 1,034 328 158 186 19 31 1.756 ATTACHMENT G 1,600 1,701 1,581 13 13 City of Tukwila 222 378 335 339 339 GOLF ENTERPRISE FUND 1,948 2,262 2,142 0 0 2012 2017 Analysis in 000's 67 2,063 1,948 2,337 2,209 2010 2011 2011 (192) (425) (97) 610 220 425 Actual Bud Estimate 2012 2013 2014 2015 2016 2017 Total 1,018 1,200 920 970 970 1,019 1,019 1,068 1,068 6,114 330 225 775 575 575 132 148 130 130 130 1 136 136 142 142 816 172 195 173 175 175 183 183 191 191 1,098 80 120 90 95 98 101 104 107 110 614 24 24 24 24 24 25 25 26 26 150 1,756 1,912 2,112 1,969 1,397 1,464 1,467 1,534 1,537 9,367 1,672 1,600 1,701 1,581 13 13 222 222 378 335 339 339 2,063 1,948 2,262 2,142 0 0 75 67 2,063 1,948 2,337 2,209 (307) (192) (425) (97) 610 220 425 425 303 28 328 2012 -2017 Financial Planning Model XXI I 1,458 1,448 1,486 1,521 1,562 1,601 9,076 15 15 16 16 17 17 97 1,473 1,463 1,502 1,537 1,579 1,618 9,173 66 80 80 80 82 82 470 1,539 1,543 1,582 1,617 1,661 1,700 9,643 430 (147) (118) (151) (127) (163) (276) 328 328 758 611 493 343 216 52 Page 34 of 49 11/18/2011 Page 35 of 49 ATTACHMENT G -1 NOTES TO GOLF ENTERPRISE FUND 1) The Green Fees are expected to increase modestly as a function of both increased players' participation and periodic greens fee increases. This model is at zero growth for golf rounds and includes only a $1.00 increase in green fees every two years. 2) A portion of the City's total sales tax revenue was allocated to pay the Golf Course's share of the 2003 Bond. See also note (4). The 2012 amount represents a place holder in case funds are needed. For 2012 and beyond, these funds will be provided only on a discretionary basis. 3) Other revenue includes golf instruction, equipment rental, and interest. 4) Assumptions for Operations and Maintenance include; removal of the Parks and Recreation's Director's 25% of salary and benefits and 50% of the Golf Maintenance building will be covered by the Parks Department. 5) Indirect Cost Allocation will be calculated on an annual basis. 6) The debt service on the 2003 Bond Issue, see note (2). The 2003 bond balance will be transferred to a governmental debt service fund and debt service in 2012 and beyond will be paid through this fund. Golf Enterprise Fund The City's Enterprise Funds account for operations that are self supported through user charges. The funds are financed and operated like a private business enterprise which requires periodic determination of revenues earned, expenses incurred, and net income for capital maintenance, public policy, management control and accountability. The Golf Enterprise Fund accounts for operation, maintenance, debt service and improvements of the municipal golf facility. The difference between the other utility enterprise funds is that Golf has voluntary users as opposed to involuntary users of the water, sewer, and surface water funds. Page 36 of 49 2012 2017 Financial Planning Model XXI I I Agenda Item III 2011 -12 Budget Amendments Memo from Peggy McCarthy: Mid Biennial Review and Modification of 2011 -12 Budget Budget Adjustment Page 37 of 49 Page 38 of 49 City of Tukwila Jim Haggerton, Mayor INFORMATIONAL MEMORANDUM TO: Mayor Haggerton Finance and Safety Committee FROM: Peggy McCarthy, Interim Finance Director DATE: November 18, 2011 SUBJECT: Mid Biennial Review and Modification of the 2011 -2012 Budget ISSUE Adjust the biennial budget to reflect new policies and circumstances, to add appropriations to funds at risk of exceeding budget in order to remain in compliance with state law, and to reallocate budget authority among General Fund departments to prevent over budget situations, consistent with past City practice. BACKGROUND The mid biennial budget adjustments are a refinement of the budget and are undertaken pursuant to TMC 3.30.020 and RCW 35A.34.130. The ordinance amending the budget, if necessary, must be passed before the end of the calendar year. The purpose and type of adjustments proposed for the 2011 -2012 budget modification are as follows: Revenue Backed Expenditures These expenditures have offsetting revenue sources such as grant revenue. Reallocation of Budget Among Departments These adjustments reallocate expenditure budget from departments expected to be under budget to departments at risk of going over budget. Council Decisions Budget Additions These adjustments add budget in support of Council decisions and as a result of circumstances necessitating additional budget. Carryover of Unused Budget Unused budget is moved from 2011 to 2012. Accounting Modifications These adjustments move budget from funds and accounts no longer used to funds and accounts currently used pursuant to changes in accounting procedures for purposes of streamlining and simplification. New Initiatives The COPS Bicycle Team initiative is proposed for 2012 and beyond. A full description of this initiative will be presented by Police Chief Mike Villa under a separate memorandum. Page 39 of 49 INFORMATIONAL MEMO Page 2 DISCUSSION General Fund 000 The revenue backed expenditure adjustments comprise the JAG Recovery Act grant which funded a portion of the Police mobile command unit; the Emergency Management Program Grant which will fund various emergency management costs in 2012, anticipated WCIA insurance proceeds funding repair costs for a damaged signal pole and a JAG grant obtained in partnership with the Tukwila School District to promote safety at Showalter Middle School. The reallocation of budget among departments transfers budget from departments expected to be under budget for the year Public Works, Mayor's and Parks Recreation to departments at risk of going over budget City Attorney, Parks Maintenance and Department 20. City Attorney special matters account has a $100K budget but actual costs to date of $306K comprised of $94K for criminal prosecution, $69K for Desc vs. Tukwila DCD, $70K for the Wells Inverse condemnation, $19K for Reed Trucking and $19K for the Whitcutt arbitration. Additional budget is proposed to cover a portion of this overage, such that the department will remain within budget. The Parks Maintenance salary budget excluded two staff members who were laid off at the end of 2010 but those jobs were reinstated in 2011, thus creating the over budget situation. The Department 20 claims and judgment account has a budget of $270K and to date expenditures of $405K comprised of the City's deductible portion of claims of $250K, the Fort Dent/Wells claim of $67K, and claims attributable to personnel issues of $87K. Additional budget is proposed to cover a portion of this overage, such that the department will remain within budget. The carryover of unused budget moves budget authority from 2011 to 2012 for projects and initiatives delayed or postponed until 2012. This includes the agenda manager technology system for the Clerk's office, crime analytical software for the Police Department and Department 20 transfers to General Government Fund 303 for removal of the flood mitigation devices and associated trail restoration. Council decisions or proposals before the Council resulting in added budget or creating new budget line items include reduction of the indirect cost allocation charged to the Golf Course Fund, the operating loan advanced to the Metropolitan Park District for $375K in 2011 and not to exceed $725K in 2012 (this loan will be paid back beginning in 2013); $166K additional funding of the Reserve Fund 105 in 2011 and $1.2M in 2012, and a proposed $175K funding of a new permit system for the Community Development department. The latter initiative will be funded through assessment of a permit technology fee after implementation of the system. An additional $550K transfer -out to the Golf Course Fund is also proposed (see Golf Course Fund 411 below for further explanation). This 2011 transfer can be funded by a $250K budget savings within the transfers -out account (debt service was budgeted for the SCORE bonds but was paid for through SCORE start -up funds and not charged to the City) and by a $300K use of ending fund balance. The additional $350K transfer -out to the Golf Course proposed for 2012 is a budget place holder to ensure sufficient budget exists for discretionary transfers. The new initiative would create a bicycle patrol team for the Tukwila International Boulevard neighborhood to increase police presence in the area. Police Chief Mike Villa will provide full details of the initiative under a separate memorandum. Page 40 of 49 VV TIN Projects\Council Agenda Items \Workshop 11- 21- 11\InfoMemo_2011 -2012 Mid Biennium Budget Amendment REVISED doc INFORMATIONAL MEMO Page 3 Hotel /Motel Tax Fund 101 The revenue backed Rock N Roll marathon expenditure for professional services is offset by revenue received from the marathon sponsors, the Competitor Group. Street Fund 103 Council decisions or proposals before the Council resulting in added budget or creating new budget line items include additional funding for the 42n Avenue residential street project. The expenditure budget carryover of $103K to 2012 is for the design work on 42n Ave S from Southcenter Blvd to S 160 These costs will be funded through ending fund balance. Arterial Street Fund 104 The revenue backed expenditure adjustment is for an anticipated grant that will be used to purchase land right of way for redesign of Andover Park West in connection with the Tukwila Transit Center project. If the grant is obtained and the right of way purchased, an additional $78K would be needed from the ending fund balance to fund the transaction. The adjustment also includes $6.6M of grant revenue expected to be received in 2012 for the Southcenter Parkway project. The expenditure budget carryover to 2012 of $9.2 million is primarily for the Southcenter Parkway extension project. The revenue budget carryover represents proceeds from the LID bonds that will be issued in 2012 to reimburse the City for the Southcenter Access Project costs. Contingency (Reserve) Fund 105 Council decisions or proposals before the Council resulting in added budget or creating new budget line items include additional funding of the Reserve fund to comply with funding requirements of the Reserve policy, adopted by Council in 2009. Debt Service Funds 2 Fund 207 serviced the debt on the 1999 General Obligation bond. This bond was refunded in 2008. The budget adjustment transfers the remaining fund balance of $13,300 to Fund 211, the fund servicing the refunded debt. The debt service budget for Fund 215 requires an additional $6K to fully service the 2011 debt. Therefore, additional budget is added. Council decisions or proposals before the Council resulting in added budget or creating new budget line items include transferring the 2003 outstanding bond balance from the Golf Course Fund 411 to a governmental debt service fund and transferring cash and investments from the Land Park Acquisition Fund 301 to the same governmental debt service fund. Land Acquisition Fund 301 Council decisions or proposals before the Council resulting in added budget or creating new budget line items include transferring cash and investments from the Land Park Acquisition Fund 301 to a governmental debt service fund for payment of debt service on the golf course portion of the 2003 outstanding bond issue. Page 41 of 49 VV TIN Projects\Council Agenda Items \Workshop 11- 21- 11\InfoMemo_2011 -2012 Mid Biennium Budget Amendment REVISED doc INFORMATIONAL MEMO Page 4 The expenditure budget adjustment represents planned land acquisition in 2012 and is consistent with the CIP proposal. This purchase will be funded through ending fund balance. Facility Replacement Fund 302 Unused expenditure budget is carried over to 2012; funding will be accomplished through ending fund balance. General Government Fund 303 The expenditure budget carryover adjustment moves budget to 2012 for the removal of the flood mitigation devices the Hesco barriers and Super Sacks and the associated trail restoration. Council decisions or proposals before the Council resulting in added budget or creating new budget line items include expenditure budget added for the bond funded emergency management measures undertaken in 2011 that were not budgeted including $199K for the 6300 building generator, $104K for the Police incident command vehicle and $273K for the new phone system. Water Fund 401 Council decisions or proposals before the Council resulting in added budget or creating new budget line items include expenditure budget added to the 1995 revenue bond principal payment account as a result of Council approval of the early redemption of the 1995 revenue bond. The accounting modification change moves debt service accounting to the appropriate utility funds (Funds 401, 402 and 412) from the Water Sewer Revenue Bond Fund 404 to simplify and streamline the accounting process. Sewer Fund 402 Budget Carryover Unused expenditure budget for the Interurban Avenue gravity sewer project and other projects is moved to 2012. Council decisions or proposals before the Council resulting in added budget or creating new budget line items include budget added to the Fund to cover the cost of the Andover Park West emergency sewer repair project. The accounting modification change moves debt service accounting to the appropriate utility funds (Funds 401, 402 and 412) from the Water Sewer Revenue Bond Fund 404 to simplify and streamline the accounting process. Water/ Sewer Revenue Bonds Fund 404 The accounting modification change moves debt service accounting to the appropriate utility funds (Funds 401, 402 and 412) from the Water Sewer Revenue Bond Fund 404 to simplify and streamline the accounting process. Page 42 of 49 VV TIN Projects\Council Agenda Items \Workshop 11- 21- 11\InfoMemo_2011 -2012 Mid Biennium Budget Amendment REVISED doc INFORMATIONAL MEMO Page 5 Golf Fund 411 Council decisions or proposals before the Council resulting in added budget or creating new budget line items include expenditure budget added in 2011 to support the $114K golf cart purchase. Revenue budget is added for 2011 through a transfer in from the General Fund to alleviate the current cash deficit of $279K and cover the December debt service payment of $262K. The existing budgeted transfer in from the General Fund of $225K is not sufficient to cover the General Fund indirect cost allocation charge of $221K and the annual debt service costs of $333K. The cash deficit is a result of underfunding in 2010 as well as 2011. The additional transfer -in proposed for 2012 is $350K and is a place holder for discretionary transfers in case of funding need. The 2012 expenditure budget reduction reduces the indirect cost allocation charge to the Golf Course Fund by the General Fund. Surface Water Fund 412 Budget Carryover Unused expenditure budget is moved to 2012; funding will be accomplished through ending fund balance. RECOMMENDATION The Council is being asked to consider the 2011 -2012 Mid Biennium Budget Amendments at the November 28 Committee of the Whole meeting and to move the item forward to the December 5 th Regular meeting for approval. ATTACHMENTS 2011 -2012 Mid Biennium Budget Amendment Page 43 of 49 VV TIN Projects\Council Agenda Items \Workshop 11- 21- 11\InfoMemo_2011 -2012 Mid Biennium Budget Amendment REVISED doc Page 44 of 49 CITY OF TUKWILA 2011 -2012 MID BIENNIUM BUDGET AMENDMENT DETAIL Biennial Budget Increase (Decrease) 2011 2012 Revenues Expenditures 104,417 82,210 50,000 76,437 (a) 230,854 82,210 313,064 104,417 76,437 (a) 82,210 50,000 230,854 82,210 160,000 60,000 100,000 (120,000) (90,000) (110,000) (21,000) 21,000 Revenue Backed Expenditures 15,000 Revenue: 2,000,000 JAG Recovery Act Mobile Command Unit 000.339.216.80.40 EMPG grant 000.333.970.42.00 Signal pole damage to be reimbursed by insurance (213,000) (WC IA) 000.344.100.00.00 JAG grant with Tukwila School distrist Total Revenue Expenditures JAG Recovery Act Mobile Command Unit 000.10.594.216.64.00 previously not budgeted JAG grant with Tukwila School distrist 000.10.xxx.xxx.xx Emergency Management CERT Trainer other 000.11.525.600.xx.xx Repair costs Signal pole 000.16.594.440.64.00 Total Expenditures Reallocation of Budget Among Departments Expenditures: City Attorney Special Matters 000.06.515.200.41.03 Parks Maintenance: Salaries 000.15.576.800.11.00 Dept20 Claims and judgements 000.20.514.230.49.03 Public Works Unallocated budget reduction (dept underbudget) 000.13.532.100.00.05 Mayors Unallocated budget reduction (dept underbudget) 000.03.513.100.00.05 Parks Recreation Unallocated budget reduction (dept underbudget) 000.07.574.200.00.05 Total Expenditures Carryover of Unused Budget Expenditures: City Clerk Agenda Manager technology system 000.03.514.300.64.00 Police Crime Analytical Software 000.10.594.100.64.00 Dept 20 Transfers -out (Fund 303, Gen Govt) 000.20.597.000.00.00 Est Ending Unreserved Fund Balance 000.20.291.840.00.00 Total Expenditures Council Decisions Budget Additions Revenue Indirect cost allocation transfer -in 000.397.000.00.00 Total Revenue Expenditures: Dept 20 Transfers -out (Fund 105, Reserve) 000.20.597.000.00.00 Dept 20 Transfers -oUt (Fund 103, Residential Street) 000.20.597.000.00.00 Dept 20 Transfers -oUt (Fund 411, Golf Course Fund) 000.20.597.000.00.00 Dept 20 TransferS -oUt (Fund 212 and 213 SCORE debt service, not chgd by SCORE) 000.20.597.000.00.00 Dept 20 Transfers -oUt (Fund 215, debt service) 000.20.597.000.00.00 Dept 20 Loan to Park District 000.20.599.000.xx.xx DCD Proposed Permit System 000.08.xxx.xxx.xx.xx Est Ending Unreserved Fund Balance 000.20.291.840.00.00 Total Expenditures Biennial Budget Increase (Decrease) 2011 2012 Revenues Expenditures 104,417 82,210 50,000 76,437 (a) 230,854 82,210 313,064 104,417 76,437 (a) 82,210 50,000 230,854 82,210 160,000 60,000 100,000 (120,000) (90,000) (110,000) (21,000) 21,000 (15,000) 15,000 (2,000,000) 2,000,000 2,036,000 (2,036,000) (213,000) (a) (213,000) (213,000) 166,260 1,200,000 (a) 220,000 (a) 550,000 350,000 313,064 (250,000) 6,000 375,000 725,000 175,000 (847,260) (2,883,000) (213,000) Page 45 of 49 (213,000) CITY OF TUKWILA 2011 -2012 MID BIENNIUM BUDGET AMENDMENT DETAIL Biennial Budget Increase (Decrease) 2011 2012 Revenues Expenditures New initiatives COP Bicycle Team Expenditures Police Department. Unallocated budget reduction (dept underbudget) 000.10.xxx.xxx.xx.xx (220,000) Salaries and benefits for 3 officers 000.10.xxx.xxx.xx.xx 345,000 Care and custody of prisoners (SCORE savings) 000.10.523.600.51.00 (125,000) Est Ending Unreserved Fund Balance (2011 carry over from Police dept) 000.20.291.840.00.00 220,000 (220,000) Fund Total Revenue Backed Expenditures Revenue Other Revenue Competitor Group 101.369.900.00.00 38,600 Total Revenue 38,600 38,600 Expenditures Professional services Rock N Roll Marathon 101.00.557.302.41.00 38,600 Total Expenditures 38,600 38,600 FUND TOTAL uw»« Council Decisions Budget Additions Revenue Transfer in 103.397.000.00.00 220,000 (a) Total Revenue 220,000 220,000 Expenditures: Professional Services /construction 103.98.595.xx.xx.xx 220,000 (a) Total Expenditures 220,000 220,000 FUND TOTAL Carryover of Unused Budget Expenditures Professional Services 103.98.595.800.41.00 (130,000) 130,000 Est Ending Unreserved Fund Balance 103.01.291.840.00.00 130,000 (130,000) Total Expenditures FUND TOTAL C. 7. i emu.... Revenue Backed Expenditures Revenue Grant Revenue various 104.33x.xxx.xx.xx 6,600,000 (a) Grant Revenue Tukwila Urban Center 104.333.203.XX.XX 416,000 Total Revenue 7,016,000 7,016,000 Expenditures Land Right of way Transit Center 104.98.595.800.61.00 494,000 Est Ending Unreserved Fund Balance 104.01.291.840.00.00 6,522,000 (a) Total Expenditures 7,016,000 7,016,000 FUND TOTAL Carryover of Unused Budget Revenue: Debt proceeds 104.391.100.00.00 (9,230,000) 9,230,000 Total Revenue (9,230,000) 9,230,000 Expenditures Professional Services Construction Southcenter Parkway 104.98.595.800.xx.xx (9,230,000) 9,230,000 Total Expenditures (9,230,000) 9,230,000 Ending fund balance Fund total Page 46 of 49 CITY OF TUKWILA 2011 -2012 MID BIENNIUM BUDGET AMENDMENT DETAIL Biennial Budget Increase (Decrease) _"w 2011 20 12 Revenues Expenditures a Council Decisions Budget Additions Revenue: Transfer in General Fund 105.397.000.00.00 166,260 1,200,000 (a) Total Revenue 166,260 1,200,000 1,366,260 Expenditure Est Ending Unreserved Fund Balance 105.00.291.840.00.00 166,260 1,200,000 Total Expenditures 166,260 1,200,000 1,366,260 Fund total Accounting Modifications: Expenditure: Transfer out 207.00.597.000.00.00 13,300 Est Ending Unreserved Fund Balance 207.00.291.840.00.00 (13,300) Total Expenditures Fund 207 total Revenue: Transfer in Fund 207 211.397.000.00.00 13,300 Total Revenue 13,300 13,300 Expenditure: Est Ending Unreserved Fund Balance 211.00.291.840.00.00 13,300 Total Expenditures 13,300 13,300 Fund 211 total Council Decisions Budget Additions Revenue: Transfer in General Fund 215.397.000.00.00 6,000 Total Revenue 6,000 6,000 Expenditure: Principal payment 215.00.592.950.83.00 6,000 Total Expenditures 6,000 6,000 Fund total Revenue: Transfer in Land Park Acquisitions 209.397.301.00.00 3,302,960 (a) Total Revenue 3,302,960 3,302,960 Expenditure: Debt service payment 209.00.xxx.xxx.xx.xx 333,751 (a) Est Ending Unreserved Fund Balance 3,302,960 (333,751) (a) Total Expenditures 3,302,960 3,302,960 Fund total Council Decisions Budget Additions Expenditure: Transfer out to debt service fund 301.00.597.209.00.00 3,302,960 (a) Land 301.98.594.760.61.00 1,000,000 Est Ending Unreserved Fund Balance 301.00.291.840.00.00 (3,302,960) (1,000,000) (a) Total Expenditures Fund total Carryover of Unused Budget Expenditure: Construction project 302.98.594.190.xx.xx (87,000) 87,000 Est Ending Unreserved Fund Balance 302.00.291.840.00.00 87,000 (87,000) Total Expenditures Fund total Page 47 of 49 CITY OF TUKWILA 2011 -2012 MID BIENNIUM BUDGET AMENDMENT DETAIL Council Decisions Budget Additions Construction Projects 303.98.594.190.65.00 600,000 Est Ending Unreserved Fund Balance 303.00.291.840.00.00 (600,000) Total Expenditures (2,000,000) 2,000,000 Fund total Biennial Budget Increase (Decrease) Council Decisions Budget Additions Expenditure: Investment interest 404.361.110.00.00 1995 Revenue bond principal ($1,370,000 payoff (60) 1995 Revenue bond principal Water /Sewer less December payment) 401.01.597.720.00.00 1,080,000 (291,748) 1995 Revenue bond principal 401.01.597.720.00.00 (310,000) 1995 Revenue bond interest 401.01.597.820.00.00 (80,494) Est Ending Working Capital 401.02.293.800.00.00 (1,080,000) 390,494 Accounting Modification Council Decisions Budget Additions (131,287) 2006 Revenue bond principal 401.01.597.720.01.00 (33,800) 2006 Revenue bond interest 401.01.597.820.01.00 (29,627) 2006 Revenue bond principal 401.02.582.347.72.00 33,800 2006 Revenue bond interest 401.02.592.347.83.00 29,627 Total Expenditures 404.00.582.380.72.00 Fund total 2006 Revenue bond principal Water /Sewer (80,600) Nul Investment interest 404.361.110.00.00 Carryover of Unused Budget (60) 1995 Revenue bond principal Water /Sewer 404.397.720.00.00 Expenditure: (291,748) 2006 Revenue bond principal Water /Sewer 404.397.720.01.00 Construction Projects 402.98.594.353.65.00 (120,000) 120,000 Est Ending Working Capital 402.02.293.800.00.00 120,000 (120,000) Council Decisions Budget Additions (131,287) Total Revenue Professional Services 402.98.594.353.xx.xx 416,000 Est Ending Working Capital 402.02.293.800.00.00 (416,000) 404.00.293.800.00.00 Accounting Modification (77,341) 1995 Revenue bond principal Water /Sewer 404.00.582.380.72.00 2006 Revenue bond principal 402.01.597.720.01.00 2006 Revenue bond principal Water /Sewer (80,600) 2006 Revenue bond interest 402.01.597.820.01.00 1995 Revenue bond interest Water /Sewer (70,649) 2006 Revenue bond principal 402.02.582.357.72.00 2006 Revenue bond interest Water /Sewer 80,600 2006 Revenue bond interest 402.02.592.357.83.00 General Government transfer to General Fund 70,649 Total Expenditures (6,411) Total Expenditures Fund total (671,185) Fund total 4, t "404 11 Accounting Modification Revenue: Investment interest 404.361.110.00.00 (60) (60) 1995 Revenue bond principal Water /Sewer 404.397.720.00.00 (283,250) (291,748) 2006 Revenue bond principal Water /Sewer 404.397.720.01.00 (123,600) (127,308) 1995 Revenue bond interest Water /Sewer 404.397.820.00.00 (117,264) (120,782) 2006 Revenue bond interest Water /Sewer 404.397.820.01.00 (127,463) (131,287) Total Revenue (651,637) (671,185) Expenditure: Est Ending Working Capital 404.00.293.800.00.00 (53,435) (77,341) 1995 Revenue bond principal Water /Sewer 404.00.582.380.72.00 (290,000) (310,000) 2006 Revenue bond principal Water /Sewer 404.00.582.380.72.01 (105,600) (105,600) 1995 Revenue bond interest Water /Sewer 404.00.592.380.83.00 (92,068) (71,937) 2006 Revenue bond interest Water /Sewer 404.00.592.380.83.01 (104,310) (99,896) General Government transfer to General Fund 404.00.597.190.00.00 (6,224) (6,411) Total Expenditures (651,637) (671,185) Fund total (1,322,822) (1,322,822) Page 48 of 49 CITY OF TUKWILA 2011 -2012 MID BIENNIUM BUDGET AMENDMENT DETAIL Biennial Budget Increase (Decrease) 412.98.594.382.41.00 (225,000) 412.98.594.382.61.00 (40,000) 412.98.594.382.65.00 (333,000) 412.02.293.800.00.00 598,000 225,000 40,000 333,000 (598,000) INCREASE IN BIENNIAL BUDGET $11,640,362 11,640,362 (a) Represents an adjustment added since review of the budget amendments by the Finance Safety Committee on November 8th. Page 49 of 49 201 201 Revenues Expenditures Council Decisions Budget Additions Revenue: Transfer in General Fund 411.397.190.00.00 550,000 350,000 Total Revenue 550,000 350,000 900,000 Expenditure: Indirect cost allocation 411.00.597.000.00.00 (213,000) (a) Small Tools Minor Equipment 411.00.576.680.35.00 114,210 Est Ending Working Capital 411.00.293.800.00.00 435,790 563,000 Total Expenditures 550,000 350,000 900,000 Fund total 412.98.594.382.41.00 (225,000) 412.98.594.382.61.00 (40,000) 412.98.594.382.65.00 (333,000) 412.02.293.800.00.00 598,000 225,000 40,000 333,000 (598,000) INCREASE IN BIENNIAL BUDGET $11,640,362 11,640,362 (a) Represents an adjustment added since review of the budget amendments by the Finance Safety Committee on November 8th. Page 49 of 49