Loading...
HomeMy WebLinkAbout10-28-2013 MUNICIPAL SERVICES COMMITTEE AGENDA PACKET Municipal Services Committee October 28, 2013 - 3:30 PM City Hall Conference Room 3 AGENDA I.CALL TO ORDER A.Roll Call B.Announcements C.Agenda Modifications II.CONSENT AGENDA A. October 14, 2013 Minutes* III.DISCUSSION ITEMS A. Red Light Photo Enforcement* (Lee) B. Cemetery Financial Review* (Coleman) C. Auburn Golf Course Financial Review* (Coleman) D. AVHS Board Review / Animal Control Licensing* (Coleman) E. Airport Management Contract* (Coleman) F. Ordinance No. 6474* (Coleman) An Ordinance of the City Council of the City of Auburn, Washington, Amending Ordinance No. 6432, the 2013-2014 Biennial Budget Ordinance, as Amended by Ordinance No. 6456 Ordinance No. 6462, Ordinance No. 6472, Ordinance No. 6473, Ordinance No. 6481, and Authorizing Amendment to the City of Auburn 2013-2014 Budget as Set Forth in Schedule “A” and Schedule “B” G. SCORE Jail Stats* (Coleman) H. Project Matrix* IV.ADJOURNMENT Agendas and minutes are available to the public at the City Clerk's Office, on the City website (http://www.auburnwa.gov), and via e-mail. Complete agenda packets are available for review at the City Clerk's Office. *Denotes attachments included in the agenda packet. Page 1 of 98 AGENDA BILL APPROVAL FORM Agenda Subject: October 14, 2013 Minutes Date: October 15, 2013 Department: Police Attachments: October 14, 2013 Minutes Budget Impact: $0 Administrative Recommendation: Background Summary: Reviewed by Council Committees: Municipal Services Councilmember:Peloza Staff: Meeting Date:October 28, 2013 Item Number:CA.A AUBURN * MORE THAN YOU IMAGINEDCA.A Page 2 of 98 Municipal Services Committee October 14, 2013 - 3:30 PM City Hall Conference Room 3 MINUTES I. CALL TO ORDER Chair Peloza called the meeting to order at 3:30 p.m. in Conference Room 3 of City Hall, 25 West Main Street, Auburn, WA. A. Roll Call Members present: Chair Bill Peloza, Vice Chair Wayne Osborne and Member John Partridge. Staff present: Mayor Pete Lewis, Chief of Police Bob Lee, Assistant Chief of Police Bill Pierson, Finance Director Shelley Coleman, Public Works Director Dennis Dowdy, Parks, Arts and Recreation Director Daryl Faber, Economic Development Planner Bill Thomas, Solid Waste and Recycling Supervisor Joan Nelson and Police Secretary/Scribe Terry Mendoza. Others present: None. B. Announcements C. Agenda Modifications At the request of Chair Peloza, an agenda modification was added to include public comment as a final discussion item. Jonathan Hunter, Albertson's Store Manager, requested time to discuss the shopping cart issue for his store located at 4010 A Street SE, Auburn. Mr. Hunter was a no show at the meeting; however, the Committee did discuss his request. Chair Peloza will contact Mr. Hunter and extend an invitation to the next Municipal Services Committee meeting on October 28, 2013. II. CONSENT AGENDA A. September 23, 2013 Minutes Vice Chair Osborne moved to accept the Minutes as presented. Member Partridge seconded. Chair Peloza concurred. MOTION PASSED: 3-0 III. ACTION A. Lea Hill Park - Project Acceptance (Faber) Page 1 of 4 CA.A Page 3 of 98 Parks, Arts and Recreation Director Daryl Faber provided an update on the completion of the newly constructed 7 acre Lea Hill Park at Green River Community College. The park includes 5 acres of an active area with 2 acres of wetlands and an ancillary area. This was an agreement with GRCC where we accepted a pass through of $1.5 million from them. We are currently working on closing out the project. Additionally, we received a $60,000.00 grant from King County for a synthetic soccer field at the park. A small budget adjustment was completed along the way to assist with the sidewalk and right of way improvements and have already gone through City Council. This final pay estimate is for the construction closeout of the contract with Bargmann Construction. Director Faber also mentioned the dedication of the park will be held at 4:00 p.m. on Wednesday, October 30, 2013. Committee discussion followed. Vice Chair Osborne moved to forward the Lea Hill Park Project Acceptance to full Council for consideration. Member Partridge seconded. Chair Peloza concurred. MOTION PASSED: 3-0 IV. DISCUSSION ITEMS A. Resolution No. 4997 (Coleman) Finance Director Shelley Coleman briefed the committee on Resolution No. 4997. This is a Resolution of the City Council of the City of Auburn, Washington, authorizing the acceptance and appropriation of grant funds in the amount of one hundred and eight thousand and eight hundred and sixty-nine dollars ($108,869.00). The Washington State Department of Ecology has requested to enter into an Interlocal Agreement with the City for the 2013-2015 Coordinated Prevention Grant Program to promote waste reduction and recycling. The City will use the grant funds for community outreach on residential recycling and yard waste, as well as education outreach on recycling in the schools. The City will match the grant and, historically, we also receive a 2-year grant from King County for the program. As such, the anticipated King County grant funds are included in the City's budget and used to backfill the City's match portion. In 2014, the King County grant will switch to an annual grant. Councilmember Partridge inquired about whether or not there is a method used to track or measure the effectiveness of this program. Joan Nelson, Solid Waste and Recycling Supervisor, reported that information on the community outreach and progress of the program is required by the Department of Ecology at the end of the year. The City remains in compliance with the program and the outreach with our community and schools have proven to be successful. Vice Chair Osborne moved to forward Resolution No. 4997 to full Page 2 of 4 CA.A Page 4 of 98 Council for consideration. Member Partridge seconded. Chair Peloza concurred. MOTION PASSED: 3-0 B. Animal Control and Rescue (Lee) Bill Pierson, Assistant Chief of Police, provided a review of the 3rd quarter report on Animal Control operations. The report shows that our continued efforts to provide community outreach and education to the Auburn citizens on animal control services has been quite effective. The number of calls for service (CFS) that were self- initiated increased and 911 dispatched CFS more than doubled. The 3rd quarter CFS totaled 411 and includes calls made directly to our animal control officer, wildlife-related calls, officer assist calls, and calls concerning deceased animals. The number of animals impounded, infractions and written warnings issued is on the rise. The committee requested a random sampling of the types of infractions (specifically those for licensing), written warnings and criminal citations issued for the 4th quarter report. Additionally, Chair Peloza suggested getting information out to the media spotlighting the success of animal control services. Mayor Lewis agreed and will work with his staff on the announcement. Committee discussion followed. C. Project Matrix The following change was made to the Project Matrix: Item 20P: Review date updated to 01/13/14. Airport Management Update: Finance Director Shelley Coleman provided an update on the Airport Management Contract and distributed a memo outlining the activity that has occurred to date along with items to consider with regard to this contract. In April 2013, the City issued a Request for Proposal (RFP) for Airport Management Services. Two proposals were received, one from Airport Management Group, LLC (AMG) and one from Aeroplex Partner's Group (AP). Some of the financial impacts to consider include the flight school being closed due to the March 2012 expiration of their lease and with that the decrease in fuel sales, as well. Additionally, the continuing debt payment on the GO bonds issued in 1999. Therefore the cost of the management contract is critical in the selection process and Finance has requested additional information from both firms. Director Coleman will brief the Airport Advisory Board at their meeting on Wednesday, October 16, and is hopeful about bringing the contract through the next round of Council Committee meetings. Committee discussion followed. Page 3 of 4 CA.A Page 5 of 98 Citizen Letter of Concern: Councilmember Partridge presented a letter from City of Auburn volunteer and resident, Blondie Day. The letter is a request for assistance from the City's Community Service Work Crew for the older seniors needing help with the pickup of their yard waste in the Skylark Village I neighborhood. Mayor Lewis has had contact with Ms. Day and has had discussions with the Parks department about the possible utilization of local service clubs/groups. Mayor Lewis will follow-up with Ms. Day directly. Committee discussion followed. V. ADJOURNMENT The meeting was adjourned at 4:30 p.m. The next regular meeting of the Municipal Services Committee is scheduled for Monday, October 28, 2013 at 3:30 p.m. in Conference Room 3 of City Hall, 25 West Main Street, Auburn, WA. Signed this ________ day of November, 2013. _____________________ ________________________________ Bill Peloza, Chair Terry Mendoza, Police Secretary/Scribe Page 4 of 4 CA.A Page 6 of 98 AGENDA BILL APPROVAL FORM Agenda Subject: Red Light Photo Enforcement Date: October 15, 2013 Department: Police Attachments: 3Q2013 PhotoSafe Report Financials Budget Impact: $0 Administrative Recommendation: Discussion only. Background Summary: 3rd Quarter report for 2013. Reviewed by Council Committees: Municipal Services Other: Finance Councilmember:Peloza Staff:Lee Meeting Date:October 28, 2013 Item Number:DI.A AUBURN * MORE THAN YOU IMAGINEDDI.A Page 7 of 98 PhotoSafe Auburn Third Quarter Review January – September 2013 340 E Main Street, Auburn, WA 98002 DI.A Page 8 of 98 340 E Main Street, Auburn, WA 98002 PURPOSE The City of Auburn launched the Traffic Safety and Enforcement Camera program, PhotoSafe, on June 30th, 2006. Initially the program included two intersections. A third was added in December 2006. The program was expanded further and now includes a total of 17 cameras throughout the city. The primary goal of the program is to improve traffic safety through reduction of red light violations and associated collisions, and to reduce incidents of speeding in designated school zones. Today, the program includes three intersections and six school zones. All of the violations and infractions included in this report occurred between January 1 and September 30 of the year noted. INTERSECTIONS 2006 June Auburn Way South and 4thSE (two approaches) Auburn Way South and M St SE (two approaches) December Harvey and 8thNE (one approach) SCHOOL SPEED ZONES 2006 November Mt. Baker/Gildo Rey School Zone (two approaches) 2007 November Chinook Elementary School Zone (two approaches) Dick Scobee School Zone (two approaches) 2009 September Lea Hill Elementary School Zone (two approaches) Arthur Jacobsen School Zone (two approaches) 2011 September Lakeland Hills Elementary (two approaches) DI.A Page 9 of 98 340 E Main Street, Auburn, WA 98002 RED LIGHT Third Quarter 2009-2013 Red Light Violation Reductions 4th/AWS (SB) 4th/AWS (NB) M/AWS (NB) M/AWS(WB) 8th/Harvey (SB) Total 3rd Quarter 2009 1,502 1,276 1,030 92 534 4,434 3rd Quarter 2010 1,229 923 856 84 160 3,252 3rd Quarter 2011 1,336 988 669 47 194 3,234 3rd Quarter 2012 1,023 722 420 25 247 2,437 3rd Quarter 2013 1,115 813 247 * 87 245 2,507 % Reduction 2009-2013 -25.8% -36.3% NA -5.4% -54.1% -43.5% *Due to construction the camera located at M St SE and Auburn Way S was inoperable until 6/20/2013 0 200 400 600 800 1,000 1,200 1,400 1,600 4th/AWS (SB)4th/AWS (NB)M/AWS (NB)M/AWS(WB)8th/Harvey (SB) 3rd Quarter 2009 3rd Quarter 2010 3rd Quarter 2011 3rd Quarter 2012 3rd Quarter 2013 NB = Northbound EB = Eastbound SB = Southbound WB = Westbound DI.A Page 10 of 98 340 E Main Street, Auburn, WA 98002 RED LIGHT Third Quarter 2009-2013 Red Light Violations vs. Infractions Issued 2009 2010 2011 2012 2013 Total Violations * 4,434 3,252 3,234 2,437 2,507 15,864 Infractions ** 3,764 2,669 2,582 1,829 1,889 12,733 % of Infractions Issued to Reported Violations 84.9% 82.1% 79.8% 75.1% 75.3% 80.3% *Violations are the total number of red light violations that occurred. **Infractions are the total number of incidents that resulted in a ticket being issued. Violations may not be accepted due to unreadable or obstructed plates, emergency vehicles, or inclimate weather. 4,434 3,252 3,234 2,437 2,507 15,864 3,764 2,669 2,582 1,829 1,889 12,733 0 2,000 4,000 6,000 8,000 10,000 12,000 14,000 16,000 18,000 20092010201120122013Total Violations Infractions DI.A Page 11 of 98 340 E Main Street, Auburn, WA 98002 SCHOOL ZONE SPEED ENFORCEMENT Third Quarter 2009 Dick Scobee 3rd Quarter 2009 261 3rd Quarter 2010 125 3rd Quarter 2011 107 3rd Quarter 2012 92 3rd Quarter 2013 105 % Reduction -59.8% *Lea Hill and Arthur Jacobsen reduction percentages were calculated by comparing 2010 to 2013 schools were activated in September of 2009. ** Lakeland Hills reduction percentage was calculated by comparing 2012 to 2013 activated until September 2011. 0 500 1000 1500 2000 2500 3000 3500 Dick Scobee Chinook 340 E Main Street, Auburn, WA 98002 SCHOOL ZONE SPEED ENFORCEMENT Quarter 2009-2013 School Zone Violation Reductions Dick Scobee Chinook Mt. Baker Lea Hill Jacobsen 1,933 630 688 916 440 1,870 763 513 1,210 517 359 1,147 243 298 1,276 -87.4% -52.7% -31.8% *Lea Hill and Arthur Jacobsen reduction percentages were calculated by comparing 2010 to 2013 in September of 2009. ** Lakeland Hills reduction percentage was calculated by comparing 2012 to 2013 because this sc Mt. Baker Lea Hill Arthur Jacobsen Lakeland Hills 2013 School Zone Violation Reductions Arthur Jacobsen Lakeland Hills 1,202 NA 2,872 NA 1,913 NA 643 237 648 198 -77.4% -16.5% *Lea Hill and Arthur Jacobsen reduction percentages were calculated by comparing 2010 to 2013. This is because both because this school was not Lakeland Hills 3rd Quarter 2009 3rd Quarter 2010 3rd Quarter 2011 3rd Quarter 2012 3rd Quarter 2013 DI.A Page 12 of 98 340 E Main Street, Auburn, WA 98002 SCHOOL ZONE SPEED ENFORCEMENT Third Quarter 2009-2013 School Zone Violations vs. Infractions Issued 2009 2010 2011 2012 2013 Total Violations 4,714 6,223 4,506 2,995 2,768 21,206 Infractions 3,835 5,521 3,657 2,579 2,481 18,073 % of Infractions Issued to Reported Violations 81.4% 88.7% 81.2% 86.1% 89.6% 85.2% *Violations are the total number of red light violations that occurred. **Infractions are the total number of incidents that resulted in a ticket being issued. Violations may not be accepted due to unreadable or obstructed plates, emergency vehicles, or inclimate weather. 4,714 6,223 4,506 2,995 2,768 21,206 3,835 5,521 3,657 2,579 2,481 18,073 0 5,000 10,000 15,000 20,000 25,000 2009 2010 2011 2012 2013 Total Violations Infractions DI.A Page 13 of 98 340 E Main Street, Auburn, WA 98002 COLLISION DATA Third Quarter 2009-2013 Collision Data The following chart shows the number of reported collisions and injuries through the 3rd Quarter of the years 2009 through 2013 at the three intersections that have PhotoSafe enforcement. M St SE & AWS 2009 2010 2011 2012 2013 Collisions 15 10 9 4 6 Injuries 2 4 4 3 2 4th St SE & AWS Collisions 9 4 0 12 9 Injuries 5 1 0 3 5 8th St NE & Harvey Rd NE Collisions 8 5 4 5 3 Injuries 2 2 0 0 0 DI.A Page 14 of 98 2013 Redflex Financial Performance Report to Municipal Services Committee Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total 2013 Year-to-date program financial performance Revenue from photo-enforcement [a](i)40,946$ 53,153$ 49,085$ 59,802$ 49,464$ 50,396$ 36,622$ 36,178$ 33,219$ 408,864$ Expenses City Payments to Redflex (ii)40,946$ 53,153$ 49,085$ 59,802$ 49,464$ 50,396$ 36,622$ 36,178$ 33,219$ 408,864$ Legal costs 139 80 100 11 41 30 72 37 174 685 Officer review 405 466 455 459 344 356 296 302 722 3,806 Admin overhead 5,186 6,712 6,205 7,534 6,231 6,348 4,624 4,565 4,264 51,669 Total [b] (iv)46,677$ 60,412$ 55,845$ 67,807$ 56,080$ 57,130$ 41,614$ 41,081$ 38,380$ -$ -$ -$ 465,024$ - Revenue over/(under) expenses [a-b] (v)(5,731)$ (7,259)$ (6,760)$ (8,004)$ (6,616)$ (6,734)$ (4,991)$ (4,904)$ (5,160)$ -$ -$ -$ (56,160)$ Redflex Invoices As Invoiced to City 82,790$ 82,790$ 82,790$ 82,790$ 82,790$ 82,790$ 82,790$ 82,790$ 82,790$ 745,110$ Paid by City (iii)40,946 53,153 49,085 59,802 49,464 50,396 36,622 36,178 33,219 408,864 Difference between amounts invoiced and paid (41,844)$ (29,637)$ (33,705)$ (22,988)$ (33,326)$ (32,394)$ (46,168)$ (46,612)(49,571)$ -$ -$ -$ (336,246)$ Footnotes Life to Date Balance by Year Total i. Revenue from photo-enforcement fines Total 2011 (179,928)$ ii. As per the agreement between the City and Redflex, the City's payment to Redflex is the lesser of the monthly invoice from Redflex or the monthly revenue from photo-enforcement fines.Total 2012 (398,141) iii. As per the agreement between the City and Redflex, the difference between the City's payment and the amount invoiced is accrued and will be payable from future surpluses or from YTD 2013 (336,246) photo-enforcement fines upon termination of the Redflex program.Total (914,314)$ iv. Total expenses, including program operating expenses and Redflex invoice payments by the City. v. Difference between Revenue (a) and Total expenses (b). Prepared by the Finance DepartmentDI.A Page 15 of 98 AGENDA BILL APPROVAL FORM Agenda Subject: Cemetery Financial Review Date: October 23, 2013 Department: Finance Attachments: Working Capital Balance Sheet Interments Budget Impact: $0 Administrative Recommendation: For committee review and discussion. Background Summary: The Cemetery ended the period with operating income of $60,489 compared to an operating loss of $125,093 for the previous year, reflecting an increase in operating revenue and a decrease in salaries/benefits expenditures. Year-to-date interments total 172 (82 burials, 90 cremations) compared to 187 (81 burials, 106 cremations) in 2012. Reviewed by Council Committees: Municipal Services Councilmember:Peloza Staff:Coleman Meeting Date:October 28, 2013 Item Number:DI.B AUBURN * MORE THAN YOU IMAGINEDDI.B Page 16 of 98 BUDGET YEAR-TO-DATE ACTUAL VARIANCE TO BUDGET PERCENT OF BUDGET Lot Sales 260,000.00 289,616.00 (29,616.00) 111.4% Openings & Closings 229,800.00 160,656.61 69,143.39 69.9% Marker Sales 100,000.00 126,196.80 (26,196.80) 126.2% Other (settings, liners, vases, etc)169,000.00 158,021.63 10,978.37 93.5% Total Operating Revenue 758,800.00 734,491.04 24,308.96 96.8% Salaries & Wages 398,492.55 293,358.75 105,133.80 73.6% Benefits 188,760.37 144,405.61 44,354.76 76.5% Supplies 191,300.00 106,642.88 84,657.12 55.7% Other Service Charges 77,620.00 44,185.37 33,434.63 56.9% Interfund Charges for Services 56,200.00 42,147.00 14,053.00 75.0% Depreciation 60,600.00 43,262.58 17,337.42 71.4% Total Operating Expenses 972,972.92 674,002.19 298,970.73 69.3% Operating Income or Loss (214,172.92) 60,488.85 (274,661.77) -28.2% Miscellaneous Revenue 210.00 360.44 (150.44) 171.6% Debt Service Interest 22,267.00 11,133.72 11,133.28 50.0% Total Non-operating Revenues (Expenses)(22,057.00) (10,773.28) (11,283.72) 48.8% Net Income or (Loss)(236,229.92) 49,715.57 (285,945.49) -21.0% Depreciation 60,600.00 43,262.58 17,337.42 71.4% Total Items Not Effecting Working Capital 60,600.00 43,262.58 17,337.42 71.4% Net Working Capital from Operations (175,629.92) 92,978.15 (268,608.07) -52.9% Operating Transfers In 320,000.00 0.00 320,000.00 0.0% Total Resources Other Than Operations 320,000.00 0.00 320,000.00 0.0% Increase In Fixed Assets - Construction 10000.00 0.00 10,000.00 0.0% Total Uses Other Than Operations 10,000.00 0.00 10,000.00 0.0% Net Change in Working Capital 134,370.08 92,978.15 41,391.93 69.2% Working Capital, Beginning of Year 182,098.05 182,098.05 0.00 100.0% Working Capital, End of Period 316,468.13 275,076.20 41,391.93 86.9% Net Change in Working Capital 134,370.08 92,978.15 41,391.93 69.2% City of Auburn Working Capital Statement Fund 436 - Cemetery September 2013 DI.B Page 17 of 98 Cash and Cash Equivalents 300,821.07 Inventories 14,083.75 Fixed Assets, Land 342,835.68 Fixed Assets, Building & Equipment 1,022,266.97 Fixed Assets, Improvements 1,143,417.39 Fixed Assets, Accumulated Depreciation (1,348,967.13) Deferred Charges 4,477.40 1,478,935.13 Current Account Payables 39,828.62 Long Term GO Bonds Payable 501,367.10 Employee Leave Benefits 15,921.00 557,116.72 Contributed Capital 739,168.78 Retained Earnings 182,649.63 921,818.41 1,478,935.13 City of Auburn Balance Sheet Fund 436 - Cemetery As of September 30, 2013 DI.B Page 18 of 98 2011 2012 2013 January 21 21 18 February 17 17 14 March 19 21 26 April 29 18 12 May 21 21 18 June 24 20 21 July 24 24 25 August 22 28 21 September 24 17 17 October 20 21 November 15 27 December 15 16 Total 251 251 172 January-September Only 201 187 172 City of Auburn Interments Fund 436 - Cemetery September 30, 2013 DI . B Pa g e 1 9 o f 9 8 AGENDA BILL APPROVAL FORM Agenda Subject: Auburn Golf Course Financial Review Date: October 16, 2013 Department: Finance Attachments: Working Capital Balance Sheet Rounds Played Budget Impact: $0 Administrative Recommendation: For committee review and discussion. Background Summary: The Golf Course ended the period with an operating loss of $76,152 compared to an operating loss of $112,443 for the same period last year and reflects an improvement in the year-to-date rounds played at the Golf Course (41,297 compared to 40,783 for the same period last year). Reviewed by Council Committees: Municipal Services Councilmember:Peloza Staff:Coleman Meeting Date:October 28, 2013 Item Number:DI.C AUBURN * MORE THAN YOU IMAGINEDDI.C Page 20 of 98 BUDGET YEAR-TO-DATE ACTUAL VARIANCE TO BUDGET PERCENT OF BUDGET Green Fees 1,025,000.00 933,752.60 91,247.40 91.1% Cart Rental 215,000.00 198,352.46 16,647.54 92.3% Pro Shop Sales 156,500.00 119,286.43 37,213.57 76.2% Restaurant 56,000.00 38,919.08 17,080.92 69.5% Other 1,500.00 1,801.66 (301.66) 120.1% Total Operating Revenue 1,454,000.00 1,292,112.23 161,887.77 88.9% Salaries & Wages 611,626.64 446,277.02 165,349.62 73.0% Benefits 276,845.24 217,458.42 59,386.82 78.5% Supplies 291,000.00 214,052.26 76,947.74 73.6% Other Service Charges 181,600.00 138,064.94 43,535.06 76.0% Interfund Charges for Services 164,500.00 123,372.00 41,128.00 75.0% Depreciation 325,000.00 229,039.79 95,960.21 70.5% Total Operating Expenses 1,850,571.88 1,368,264.43 482,307.45 73.9% Operating Income or Loss (396,571.88) (76,152.20) (320,419.68) 19.2% Miscellaneous Revenue 45.00 445.32 (400.32) 989.6% Total Non-operating Revenues (Expenses)45.00 445.32 (400.32) 989.6% Net Income or (Loss)(396,526.88) (75,706.88) (320,820.00) 19.1% Depreciation 325,000.00 229,039.79 95,960.21 70.5% Total Items Not Effecting Working Capital 325,000.00 229,039.79 95,960.21 70.5% Net Working Capital from Operations (71,526.88) 153,332.91 (224,859.79) -214.4% Operating Transfers In 51,250.00 46,687.64 4,562.36 91.1% Increase in Restricted Net Assets 0.00 0.00 0.00 0.0% Total Resources Other Than Operations 51,250.00 46,687.64 4,562.36 91.1% Net Change in Restricted Net Assets 0.00 (12,779.19) 12,779.19 0.0% Total Uses Other Than Operations 0.00 (12,779.19) 12,779.19 0.0% Net Change in Working Capital (20,276.88) 212,799.74 (233,076.62) -1049.5% Working Capital, Beginning of Year 90,691.62 90,691.62 0.00 100.0% Working Capital, End of Period 70,414.74 303,491.36 (233,076.62) 431.0% Net Change in Working Capital (20,276.88) 212,799.74 (233,076.62) -1049.5% City of Auburn Working Capital Statement Fund 437 - Golf Course September 2013 DI.C Page 21 of 98 Cash and Cash Equivalents 653,472.21 Customer Accounts Receivable 9,046.66 Fixed Assets, Land 2,229,635.82 Fixed Assets, Building & Equipment 6,620,690.54 Fixed Assets, Improvements 3,023,052.61 Fixed Assets, Accumulated Depreciation (3,455,771.69) 9,080,126.15 Current Account Payables 59,027.51 Interfund Payables 300,000.00 Deferred Revenue 112,046.23 Employee Leave Benefits 59,168.00 530,241.74 Contributed Capital 2,278,691.89 Retained Earnings 6,271,192.52 8,549,884.41 9,080,126.15 City of Auburn Balance Sheet Fund 437 - Golf Course As of September 30, 2013 DI.C Page 22 of 98 2011 2012 2013 January 701 1,125 1,277 February 1,545 1,687 1,764 March 2,183 1,939 2,548 April 3,215 3,920 4,007 May 4,887 5,545 5,994 June 6,956 5,873 6,605 July 8,058 7,531 7,686 August 7,612 7,447 7,181 September 5,179 5,716 4,235 October 2,805 2,503 November 1,321 1,546 December 1,506 872 Total 45,968 45,704 41,297 January-September Only 40,336 40,783 41,297 City of Auburn Rounds Played Fund 437 - Golf Course September 30, 2013 DI . C Pa g e 2 3 o f 9 8 AGENDA BILL APPROVAL FORM Agenda Subject: AVHS Board Review / Animal Control Licensing Date: October 23, 2013 Department: Finance Attachments: Memo Photo Collage YTD Animal Statistics Sales and Revenue by Month September Licensing Summary Budget Impact: $0 Administrative Recommendation: For committee review and discussion. Background Summary: Monthly update from the Auburn Valley Humane Society (AVHS) Board meeting and a Quarterly report on the Animal Control Licensing Program. Reviewed by Council Committees: Municipal Services Councilmember:Peloza Staff:Coleman Meeting Date:October 28, 2013 Item Number:DI.D AUBURN * MORE THAN YOU IMAGINEDDI.D Page 24 of 98 DI.D Page 25 of 98 DI.D Page 26 of 98 DI.D Page 27 of 98 DI.D Page 28 of 98 DI.D Page 29 of 98 DI.D Page 30 of 98 DI.D Page 31 of 98 2013 Budget Goal: $ 96,000 or more 2014 Budget Goal: $240,000 or more Year-to-Date Revenue 2013 (through September) = $116,920 Year-to-Date Licenses 2013 (through September) = 3,876 Year-to-Date Licenses 2012 (through September) = 4,733 as reported by King County CITY OF AUBURN PET LICENSING SEPTEMBER 2013 0 100 200 300 400 500 600 700 800 Ja n Fe b Ma r Ap r Ma y Ju n Ju l Au g Se p Oc t No v De c Nu m b e r o f L i c e n s e s S o l d Month Pet License Sales By Month 2013 vs 2012 2013 Licenses Sold 2012 Licenses Sold $0 $2,000 $4,000 $6,000 $8,000 $10,000 $12,000 $14,000 $16,000 $18,000 Ja n Fe b Ma r Ap r Ma y Ju n Ju l Au g Se p Oc t No v De c Li c e n s e R e v e n u e Month Pet Licensing Revenue By Month 2013 2013 License Revenue DI.D Page 32 of 98 CITY OF AUBURN PET LICENSING SEPTEMBER 2013 0 2,000 4,000 6,000 8,000 10,000 12,000 $0 $20,000 $40,000 $60,000 $80,000 $100,000 $120,000 $140,000 Ja n Fe b Ma r Ap r Ma y Ju n Ju l Au g Se p Oc t No v De c Nu m b e r o f L i c e n s e s S o l d Li c e n s e R e v e n u e Month Cumulative Pet Licensing Revenue & Sales 2013 vs 2012 2013 License Revenue (L) 2013 License Revenue (Budget Goal: $96,000) 2013 Licenses Sold (R) 2012 Licenses Sold (R) DI.D Page 33 of 98 Replacement Licensing Summary Report – Auburn, WA Clinic Clinic Name Unaltered Altered Activity from 9/1/13 through 9/30/13 Late FeesSeniorDisability Juvenile Pet License TotalService Excep PetData Corporate AUB900 PETDATA MAIL 6 106 64 $120.00 0 $2,235.00 $735.00 $0.00 0 $0.00 1 $0.00 177 $3,090.00 1 $5.00 $60.00 3 $2,865.00 109 AUB901 PETDATA ONLINE LICENSES 3 41 2 $180.00 0 $750.00 $30.00 $0.00 3 $45.00 0 $0.00 49 $1,005.00 0 $0.00 $90.00 6 $1,455.00 51 Subtotal PetData Corporate $180.00 $750.00 $30.00 $0.00 $45.00 $0.00 $1,005.00 $0.00 $90.00 $1,455.00 9 147 66 0 $300.00 $2,985.00 $765.00 $0.00 3 $45.00 1 $0.00 226 $4,095.00 1 $5.00 $150.00 9 $4,320.00 160 Municipal Locations AUB800 CITY HALL 16 118 65 $960.00 4 $3,540.00 $975.00 $60.00 5 $75.00 0 $0.00 208 $5,610.00 3 $15.00 $0.00 0 $0.00 0 Subtotal Municipal Locations $960.00 $3,540.00 $975.00 $60.00 $75.00 $0.00 $5,610.00 $15.00 $0.00 $0.00 16 118 65 4 $960.00 $3,540.00 $975.00 $60.00 5 $75.00 0 $0.00 208 $5,610.00 3 $15.00 $0.00 0 $0.00 0 Veterinary & Other Locations AUB018 FOREST HILL VETERINARY HOSPITAL 0 6 1 $0.00 1 $180.00 $15.00 $15.00 0 $0.00 0 $0.00 8 $210.00 0 $0.00 $0.00 0 $0.00 0 Subtotal Veterinary & Other Locations $0.00 $180.00 $15.00 $15.00 $0.00 $0.00 $210.00 $0.00 $0.00 $0.00 0 6 1 1 $0.00 $180.00 $15.00 $15.00 0 $0.00 0 $0.00 8 $210.00 0 $0.00 $0.00 0 $0.00 0 TOTAL REGISTRATIONS TOTAL REVENUE 25 271 132 5 $1,260.00 $6,705.00 $1,755.00 $75.00 8 $120.00 1 $0.00 $9,915.00 442 4 9 $20.00 $150.00 160 $4,320.00 $14,405.00 10/16/13 10:29:10Page:1 DI.D Page 34 of 98 AGENDA BILL APPROVAL FORM Agenda Subject: Airport Management Contract Date: October 23, 2013 Department: Finance Attachments: Memorandum Airport Management Contract Budget Impact: $0 Administrative Recommendation: Information only. Background Summary: Attached is the proposed contract for Airport management services with Aviation Management Group, LLC (AMG). The term is for 2 years beginning January 1, 2014 and ending December 31, 2015. The annual contract is $358,000 per year. The management company will also perform the fueling services and split the revenue evenly, 50% / 50%, with the City after all fuel costs have been paid. The City estimates approximately $12,000 from the fuel revenue. AMG was asked to remove the grant and project management from their proposal. Work outside the scope of the contract such as crack sealing, catch basin repair, building maintenance, tenant improvements, etc., will be done by a task order where the work will be submitted to the City for review and approval. At the last Municipal Services meeting, we reviewed the responses to the request for proposals. The memorandum is attached for reference. Reviewed by Council Committees: Municipal Services Councilmember:Peloza Staff:Coleman Meeting Date:October 28, 2013 Item Number:DI.F AUBURN * MORE THAN YOU IMAGINEDDI.F Page 35 of 98 DI.F Page 36 of 98 DI.F Page 37 of 98 DI.F Page 38 of 98 DI.F Page 39 of 98 DI.F Page 40 of 98 DI.F Page 41 of 98 DI.F Page 42 of 98 DI.F Page 43 of 98 DI.F Page 44 of 98 DI.F Page 45 of 98 DI.F Page 46 of 98 DI.F Page 47 of 98 DI.F Page 48 of 98 DI.F Page 49 of 98 DI.F Page 50 of 98 DI.F Page 51 of 98 DI.F Page 52 of 98 DI.F Page 53 of 98 DI.F Page 54 of 98 DI.F Page 55 of 98 DI.F Page 56 of 98 AGENDA BILL APPROVAL FORM Agenda Subject: Ordinance No. 6474 Date: October 16, 2013 Department: Finance Attachments: Memo Ordinance No. 6474 Schedule A & B Budget Impact: $11,344,964.25 Administrative Recommendation: City Council to introduce and adopt Ordinance No. 6474, amending the 2014 budget. Background Summary: Ordinance No. 6474 (Budget Amendment #6) represents the sixth budget amendment for the 2013-2014 biennium and the first budget amendment for 2014. For details, see the attached transmittal memorandum and supporting attachments. Reviewed by Council Committees: Finance, Municipal Services, Planning And Community Development, Public Works Councilmember:Partridge Staff:Coleman Meeting Date:October 28, 2013 Item Number:DI.G AUBURN * MORE THAN YOU IMAGINEDDI.G Page 57 of 98 Interoffice Memorandum To: City Council From: Shelley Coleman, Finance Director CC: Pete Lewis, Mayor Date: October 11, 2013 Re: Ordinance #6474 – 2013-2014 Budget Amendment #6 The City’s biennial 2013-2014 budget is approved by Council as two one-year appropriations. Budget Amendments #1 through #5 amended the budget for calendar year 2013. This amendment is the 6th budget amendment for the biennium and the 1st budget amendment for calendar year 2014. The purpose of this amendment is to 1) amend the 2014 budget for changes that occurred in 2013 for which there is an on-going fiscal impact; 2) to carryforward capital project budgets that are not anticipated to be completed in 2013; and 3) to establish budget spending authority for new programs and other changes in 2014. Proposed amendments to the 2014 budget are as follows: Continuation of previously approved requests by Council. The following items (grouped in chronologic order by budget amendment) were previously approved by Council in 2013 and will continue as an ongoing cost in 2014. These include: Budget Amendment #1, Ordinance #6456 (approved March 4, 2013) • Utility to newly created Sewer Metro Fund ($14.0 million) Move King County Metro expenses from Sewer Emergency Management Office Assistan t maintenance and Sound Transit garage security ($22,000) Labor agreements (funded by remaining labor dget Amendment #2, Ordinance #6462 (app • Economic Development Planner (1.0FTE; $118,550) • t (.4FTE; $22,373) • Stratford parking lo • contingency established by Council) Bu roved June 17, 2013) • Eliminate Cemetery Office Assistant (-1.0FTE; -$78,004) Equipment Rental Office Assistant (1.0FTE; $77,545) ormwater Fund ($74,000) help) ugust 15, 2013) • • Centralizing cost of Median Maintenance in General Fund from St • Museum Contracted Curator and Asst. Curator ($67,700) • Community Diversity Assistant (.25FTE; $16,724) • Parks Senior Center Assistant (.5FTE; $13,390. Cost partially offset by savings in temporary Budget Amendment #3, Ordinance #6472 (approved A Federal COPS grant funded Police Officers (5.0FTEs; $313,850. Cost partially offset by federal • Five Police Officers in BA#3 (5.0FTEs; $589,830) • Community Oriented Policing grant) DI.G Page 58 of 98 Solid Waste rate adjustment, Ordinance #6438 (approved November 7, 2012) • The City Council approved Ordinance #6438 which established revised solid waste rates effective January 1, 2013 and January 1, 2014. This amendment revises the 2014 budget for the Solid o enable project completion and 2) requested ansportation project expenses as approved by Council per Resolution #4937 (adopted June 17, re evenue Adjustments: Waste Fund (#434) consistent with this ordinance. Project Adjustments. This item includes 1) requested project expenses that were previously approved in 2013 but will require carryforward to 2014 t tr 2013), which approved the 2014-2019 Transportation Improvement Plan. Project budget changes a included in the Arterial Street Fund (#102), Local Street Fund (#103), Arterial Street Preservation Fund (#105), Water Utility Fund (#430), Stormwater Utility Fund (#432) and Airport Fund (#435). Other Requests. Other items requested for funding in this budget amendment include: R Several revenue adjustments amending the 2014 budget are proposed as part Adjusting property taxes upward (+$1.4 million to $15.7 million), reflecting a revision to the City’s million) and adjusting sales taxes on to of this budget adjustment. These adjustments include: • levy cap by King County as well as estimated new construction and a 1.0% property tax increase; • Adjusting sales taxes upward (+$1.5 million to $13.0 construction transferred to the Local Street Construction fund #103 (+$266,000 to $1.6 million), reflecting improvement in general economic conditions and retail sales activity; and • Adjusting building permit fees (+$345,000 to $1.2 million) and plan check fees (+$121,000 $585,000), reflecting the continued strengthening of the local and regional economy. New staffing: The following new positions are being requested: • Records Clerk, Legal Department (1.0FTE; $86,800): Funding is requested to hire a second legal clerk to support public records requests. The additional position will enable the City to keep up er disclosure of information. with workload and state law requirements regarding the prop • Administrative Assistant, Innovation and Technology Department (1.0FTE; $79,600): Funding is requested to hire an Administrative Assistant to support the IT Department Director and staff with daily administrative functions. Current administrative duties are handled by the Director a nd staff; approval of this position will enable the Department to utilize its technology staff more efficiently. • Mechanic, Public Works M&O (1.0FTE; $0 net cost): Funding is requested to hire an additional Mechanic to support the Public Works Maintenance and Operations Center. The additional position will enable the M&O Center to keep pace with workload and to utilize less overtime and extra help. It is expected that the cost of this function will be fully offset by savings in overtime an extra help. d Downtown property sales ($1,045,300): Payment of traffic impact fees related to the sale of the Teutsch property in downtown is recognized. Payment of these fees will occur in the City’s Capital provements Fund (#328) and will be payable to the City’s Mitigation Fees Fund (#124). Im Fully fund fire pension liabilities ($231,000): Funding to transfer $231,000 from the General Fund to the Fire Pension Fund (#611) is requested, enabling the City to fully fund its pension liabilit y for eligible tired firefighters. re KidStock community festival ($30,500) & Arts/Events six year action plan ($15,000): Funding is requested by the Parks Department to establish a kids oriented community festival. The cost of this quest will be partially offset by $10,000 in anticipated revenue from sale of merchandise at the re festival. Funding is also requested to evaluate the needs and strategies for continuing to provide cultural and community arts/events in the City. DI.G Page 59 of 98 Innovation and Technology Stand-by pay ($15,990): Funding is requested by the Innovation and Technology Department for standby pay paid to technology staff required to be on stand-by on venings and weekends ($2.50/hour). Table 1: 2014 Budget as Amended e Council approval of proposed Ordinance 6474 would amend the 2014 budget as follows: 2014 Budget as Adopted $ 212,945,255.00 Budget Am ,964.25endment #6 (Ord #6474) 11,344 Budget as Amended $224,290,219.25 Attachments: 1. Propose udget adjustment #6 ary of proposed 2014 budget adjustments by fund and department (Schedule A) et by fund (Schedule B) d Ordinance #6474 (b ) 2. Summ 3. Summary of approved changes to adopted 2014 budg DI.G Page 60 of 98 ORDINANCE NO. 6474 AN ORDINANCE OF THE CITY COUNCIL OF THE CITY OF AUBURN, WASHINGTON, AMENDING ORDINANCE NO. 6432, THE 2013-2014 BIENNIAL BUDGET ORDINANCE, AS AMENDED BY ORDINANCE NO. 6456, ORDINANCE NO. 6462, ORDINANCE NO. 6472, ORDINANCE NO. 6473, ORDINANCE 6481, AUTHORIZING AMENDMENT TO THE CITY OF AUBURN 2013-2014 BUDGET AS SET FORTH IN SCHEDULE “A” AND SCHEDULE “B” WHEREAS, the Auburn City Council at its regular meeting of December 3, 2012, adopted Ordinance No. 6432 which adopted the City of Auburn 2013-2014 Biennial budget; and WHEREAS, the Auburn City Council at its regular meeting of March 4, 2013, adopted Ordinance No. 6456 (BA#1) which amended Ordinance No. 6432 which adopted the City of Auburn 2013-2014 Biennial budget; and WHEREAS, the Auburn City Council at its regular meeting of May 28, 2013, adopted Ordinance No. 6462 (BA#2) which amended Ordinance No. 6456 which amended the City of Auburn 2013-2014 Biennial budget; and WHEREAS, the Auburn City Council at its regular meeting of August 5, 2013, adopted Ordinance No. 6472 (BA#3) which amended Ordinance No. 6462 which amended the City of Auburn 2013-2014 Biennial budget; and WHEREAS, the Auburn City Council at its regular meeting of September 16, 2013, adopted Ordinance No. 6473 (BA#4) which amended Ordinance No. 6472 which amended the City of Auburn 2013-2014 Biennial budget; and ------------------------- Ordinance No. 6474 October 11, 2013 Page 1 of 4 DI.G Page 61 of 98 WHEREAS, the Auburn City Council is scheduled to review Ordinance No. 6481 (BA#5) in late 2013, which will amend Ordinance No. 6473 which amended the City of Auburn 2013-2014 Biennial budget; and WHEREAS, the City of Auburn deems it necessary to appropriate additional funds to the various funds of the 2014 budget as outlined in this Ordinance (BA#6); and WHEREAS, this Ordinance has been approved by one more than the majority of all councilpersons in accordance with RCW 35A.34.200. NOW THEREFORE, THE CITY COUNCIL OF THE CITY OF AUBURN, WASHINGTON DO ORDAIN AS FOLLOWS: Section 1. Amendment of the 2013-2014 Biennial Budget. The 2013- 2014 Biennial Budget of the City of Auburn is amended pursuant to Chapter 35A.34 RCW, to reflect the revenues and expenditures as shown on Schedule “A” attached hereto and incorporated herein by reference. The Mayor of the City of Auburn, Washington is hereby authorized to utilize revenue and expenditure amounts shown on said Schedule “A” and Schedule “B”. A copy of said Schedule “A” and Schedule “B” is on file with the City Clerk and available for public inspection. Section 2. Severability. If any provision of this Ordinance or the application thereof to any person or circumstance is held to be invalid, the remainder of such code, ordinance or regulation or the application thereof to other person or circumstance shall not be affected. ------------------------- Ordinance No. 6474 October 11, 2013 Page 2 of 4 DI.G Page 62 of 98 ------------------------- Ordinance No. 6474 October 11, 2013 Page 3 of 4 Section 3. Implementation. The Mayor is hereby authorized to implement such administrative procedures as may be necessary to carry out the directives of this legislation. Section 4. Effective Date. This Ordinance shall take effect and be in force five (5) days from and after its passage, approval and publication as provided by law. INTRODUCED: _______________ PASSED: ____________________ APPROVED: _________________ ____________________________ PETER B. LEWIS, MAYOR ATTEST: ____________________________ Danielle E. Daskam City Clerk DI.G Page 63 of 98 ------------------------- Ordinance No. 6474 October 11, 2013 Page 4 of 4 APPROVED AS TO FORM: ____________________________ Daniel B. Heid City Attorney PUBLISHED:__________________ DI.G Page 64 of 98 Schedule A Summary of 2014 Budget Adjustments by Fund Budget Amendment #6 Ordinance 6474 General Fund (#001) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance General Fund 2014 Adopted Budget 8,311,010.00 50,553,102.00 54,498,330.00 4,365,782.00 BA#6 (Proposed Ordinance #6474) Revenues Economic Recovery Continuation of previously approved requests. Sales Tax revenue adjustment 0.00 1,500,000.00 0.00 1,500,000.00 Budget amended from $11.5M to $13.0 million Property Tax King County adjustment to assessed valuation. Budget amended 0.00 1,400,000.00 0.00 1,400,000.00 from $14.3M to $15.7 million King County District Court Transition Court Interpreter Revenue decrease due to KCDC transition.0.00 (14,000.00)0.00 (14,000.00) Court Interest Revenue decrease due to KCDC transition.0.00 (22,500.00)0.00 (22,500.00) Trial Court Improvement revenue decrease due to KCDC transition.0.00 (24,869.00)0.00 (24,869.00) Adult Probation Revenue decrease due to KCDC transition.0.00 (203,015.00)0.00 (203,015.00) Labor Agreements Continuation of previously approved requests Approved labor agreement adj (BA#1; 3.04.2013 & BA#2; 6.17.2013) funded from non-departmental contingency Police 0.00 0.00 681,295.31 (681,295.31) Planning 0.00 0.00 44,848.40 (44,848.40) Public Works 0.00 0.00 41,113.29 (41,113.29) Parks 0.00 0.00 38,264.98 (38,264.98) Legal 0.00 0.00 21,924.68 (21,924.68) Human Resources 0.00 0.00 16,454.08 (16,454.08) Finance 0.00 0.00 14,741.45 (14,741.45) Mayor 0.00 0.00 10,073.80 (10,073.80) Streets 0.00 0.00 3,080.26 (3,080.26) Carryforward unspent labor contingency from 2013 871,796.25 0.00 0.00 871,796.25 Legal Department New FTE - 1.0 Records Clerk (93.5% GF Funded)0.00 0.00 81,323.17 (81,323.17) Police Department Restoration of 5 existing police officers 0.00 0.00 589,830.00 (589,830.00) Continuation of previously approved requests 5 new police officers (BA#3; 8.15.2013) partially funded by Federal 0.00 205,780.00 519,630.00 (313,850.00) COPS grant. Parks Department New Kid Stock community festival; partially funded by festival revenues 0.00 10,000.00 30,500.00 (20,500.00) Arts & Events Six-year Action Plan 0.00 0.00 15,000.00 (15,000.00) Continuation of previously approved requests Median Maintenance Centralized in the GF from SWM (BA#2; 6.17.2013)0.00 74,000.00 74,000.00 0.00 Museum Contract Labor: Curator of Collections (BA#1; 3.4.2013)0.00 0.00 35,617.39 (35,617.39) Museum Contract Labor: Asst. Curator of Education (BA#1; 3.4.2013)0.00 0.00 32,080.83 (32,080.83) Senior Center Assistant (0.5 FTE to 1.0 FTE)0.00 0.00 24,390.00 (24,390.00) partially offset by reducing temporary help (BA#2; 6.17.2013).0.00 0.00 (11,000.00)11,000.00 F:\Budget Directory\2014 Budget\BA#6 - Mid Biennial Review\BA#6 - Sched A & B\BA#6 Worksheet - Sched A and B-update 10.3.2013.xlsx Page 1 DI.G Page 65 of 98 Schedule A Summary of 2014 Budget Adjustments by Fund Budget Amendment #6 Ordinance 6474 Public Works Continuation of previously approved requests Emerg Mgmt Office Asst (0.6 FTE to 1.0 FTE; 30% GF; BA#1; 3.04.2013)0.00 0.00 6,711.90 (6,711.90) Planning Department Building Permit revenue increase due to local development activity.0.00 345,000.00 0.00 345,000.00 Plan Check revenue increase due to local development activity.0.00 121,000.00 0.00 121,000.00 Continuation of previously approved requests Economic Development Planner (1.0 FTE; BA#1; 3.04.2013)0.00 0.00 118,550.00 (118,550.00) Merchant transaction fees associated with increased 0.00 0.00 35,000.00 (35,000.00) building permit activity. Community Diversity Asst (0.75 FTE to 1.0 FTE; BA#2; 6.17.2013)0.00 0.00 16,724.00 (16,724.00) Street Department Continuation of previously approved requests ER&R Office Assistant (10% GF; BA#2; 6.17.2013)0.00 0.00 7,754.00 (7,754.00) Non-Departmental Fully fund fire pension liability (transfer to F611)0.00 0.00 231,000.00 (231,000.00) BA#6 Total 871,796.25 3,391,396.00 2,678,907.54 1,584,284.71 2014 Revised Budget 9,182,806.25 53,944,498.00 57,177,237.54 5,950,066.71 Memo: Unrestricted GF Ending fund balance 4,939,778.96 Memo: Restricted GF Ending fund balance for salaries/benefits 1,010,287.75 Total Resources / Expenditures 63,127,304.25 63,127,304.25 8.0% General Fund Reserve Requirement 4,574,179.00 F:\Budget Directory\2014 Budget\BA#6 - Mid Biennial Review\BA#6 - Sched A & B\BA#6 Worksheet - Sched A and B-update 10.3.2013.xlsx Page 2 DI.G Page 66 of 98 Schedule A Summary of 2014 Budget Adjustments by Fund Budget Amendment #6 Ordinance 6474 Arterial Street Fund (#102) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 856,364.00 3,849,658.00 3,892,270.00 813,752.00 BA#6 (Proposed Ordinance #6474) Adjust beginning fund balance 92,300.00 0.00 0.00 92,300.00 Project Carryforwards and Adjustments C222A0 - S. 277th (AWN to Green River Br); (funding: Federal grant)2,700.00 700,260.00 702,960.00 0.00 CP1119 - AWS Corridor (funding: MIT contribution $230K and traffic 0.00 230,000.00 430,000.00 (200,000.00) impact fees $200K)0.00 200,000.00 0.00 200,000.00 TIP #21 - Main St. Signal Upgrades 0.00 0.00 265,000.00 (265,000.00) CP1218 - AWS Corridor Safety (funding: traffic impact fees)0.00 250,000.00 250,000.00 0.00 CP1114 - AWS & 12th St. SE (funding: traffic impact fees)0.00 250,000.00 250,000.00 0.00 CP1118 - AWS Pedestrian Dogwood to Fir; (funding: MIT contribution)0.00 238,800.00 238,800.00 0.00 TIP #68 - 37th St. SE & A St. SE Traffic Signal (funding: State Grant)0.00 121,400.00 176,400.00 (55,000.00) TIP #30 - Citywide Pedestrian Crossing Program 0.00 0.00 150,000.00 (150,000.00) TIP #23 - A St. SE Non-Motorized Access (funding: Federal grant)0.00 89,029.00 89,029.00 0.00 TIP #27 - A St. SE Safety Improvement Study 0.00 0.00 50,000.00 (50,000.00) TIP #54 - Kersey Way SE Corridor Study (funding: traffic mitigation fees)0.00 50,000.00 50,000.00 0.00 CP0911 - F St. SE (4th St. SE to AWS); (funding: Traffic impact fees)0.00 50,000.00 50,000.00 0.00 TIP #40 - 124th Ave. SE Corridor Ph. 1 (funding: Traffic impact fees $175,000;0.00 175,000.00 50,000.00 125,000.00 federal grant reduced $125,000)0.00 (125,000.00)0.00 (125,000.00) TIP #38 - 37th & B St. NW Railroad Crossing Safety Improv.0.00 0.00 26,900.00 (26,900.00) TIP #33 - BNSF 3rd Rail Expansion Roadway Improv.0.00 0.00 25,000.00 (25,000.00) TIP #47 - Environmental Park Roadway Improv. Study 10,000.00 0.00 10,000.00 0.00 TIP #48 - Downtown to Les Gove Non-Motorized Imp. Study 10,000.00 0.00 10,000.00 0.00 TIP #49 - S. 316th St. Bicycle & Pedestrian Improv. Study 0.00 0.00 5,000.00 (5,000.00) TIP #56 - Lea Hill Safe Routes to School Improv. (CP1120)0.00 0.00 5,000.00 (5,000.00) TIP #67 - Citywide Traffic Signal Safety Improv. (CP1222)0.00 0.00 5,000.00 (5,000.00) CP0912 - Citywide Guardrail Improv.5,000.00 0.00 5,000.00 0.00 CP1021 - 104th Ave. SE & Green River Rd Study 5,000.00 0.00 5,000.00 0.00 CP1104 - 8th Street NE/104th Ave. SE Intersection Improv.5,000.00 0.00 5,000.00 0.00 TIP #41 - 124th Ave. SE Corridor Ph.2 (deleted; combine with TIP #40)0.00 (50,000.00)(50,000.00)0.00 CP1024 - AWN & M St. SE Intersection (funding: Federal grant)0.00 (134,043.00)(134,043.00)0.00 CP1023 - Auburn Ave. NE & 3rd St. NE Pedestrian Improv (State grant 0.00 (110,000.00)(150,000.00)40,000.00 request denied; project scope reduced) BA#6 Total 130,000.00 1,935,446.00 2,520,046.00 (454,600.00) 2014 Revised Budget 986,364.00 5,785,104.00 6,412,316.00 359,152.00 Total Resources / Expenditures 6,771,468.00 6,771,468.00 F:\Budget Directory\2014 Budget\BA#6 - Mid Biennial Review\BA#6 - Sched A & B\BA#6 Worksheet - Sched A and B-update 10.3.2013.xlsx Page 3 DI.G Page 67 of 98 Schedule A Summary of 2014 Budget Adjustments by Fund Budget Amendment #6 Ordinance 6474 Local Street Fund (#103) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 270,670.00 1,447,650.00 1,444,300.00 274,020.00 BA#6 (Proposed Ordinance #6474) Sales Tax from Construction (increased from $1.294M to $1.560M) 0.00 265,700.00 0.00 265,700.00 Project Carryforwards and Adjustments CPXXXX - Local Street Improvement Program (2014-19 TIP; 6.17.2013)228,100.00 0.00 400,000.00 (171,900.00) BA#6 Total 228,100.00 265,700.00 400,000.00 93,800.00 2014 Revised Budget 498,770.00 1,713,350.00 1,844,300.00 367,820.00 Total Resources / Expenditures 2,212,120.00 2,212,120.00 Arterial Street Preservation Fund (#105) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 1,584,937.00 2,042,723.00 2,000,000.00 1,627,660.00 BA#6 (Proposed Ordinance #6474) Project Carryforwards and Adjustments CPXXXX - Arterial Street Preservation Program (2014-19 TIP; 6.17.2013)0.00 0.00 500,000.00 (500,000.00) CPXXXX - Arterial Bridge Deck Rehab (2014-19 TIP; 6.17.2013)0.00 0.00 250,000.00 (250,000.00) CP1225 - W. Valley Hwy System Preservation 5,000.00 0.00 5,000.00 0.00 CPXXXX - Crack Seal Program (reduced project scope)0.00 0.00 (100,000.00)100,000.00 BA#6 Total 5,000.00 0.00 655,000.00 (650,000.00) 2014 Revised Budget 1,589,937.00 2,042,723.00 2,655,000.00 977,660.00 Total Resources / Expenditures 3,632,660.00 3,632,660.00 F:\Budget Directory\2014 Budget\BA#6 - Mid Biennial Review\BA#6 - Sched A & B\BA#6 Worksheet - Sched A and B-update 10.3.2013.xlsx Page 4 DI.G Page 68 of 98 Schedule A Summary of 2014 Budget Adjustments by Fund Budget Amendment #6 Ordinance 6474 Drug Forfeiture Fund (#117) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 917,468.00 281,300.00 280,915.00 917,853.00 BA#6 (Proposed Ordinance #6474)0.00 Increase budget for air cards on video cameras (previously approved BA#2; 6.17.2013)0.00 0.00 1,440.00 (1,440.00) BA#6 Total 0.00 0.00 1,440.00 (1,440.00) 2014 Revised Budget 917,468.00 281,300.00 282,355.00 916,413.00 Total Resources / Expenditures 1,198,768.00 1,198,768.00 Cumulative Reserve Fund (#122) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 5,700,796.00 3,000.00 1,434,624.00 4,269,172.00 BA#6 (Proposed Ordinance #6474)0.00 Golf Course debt service administrative fees Transfer to Golf Course debt service fund F417 0.00 0.00 1,000.00 (1,000.00) BA#6 Total 0.00 0.00 1,000.00 (1,000.00) 2014 Revised Budget 5,700,796.00 3,000.00 1,435,624.00 4,268,172.00 Total Resources / Expenditures 5,703,796.00 5,703,796.00 F:\Budget Directory\2014 Budget\BA#6 - Mid Biennial Review\BA#6 - Sched A & B\BA#6 Worksheet - Sched A and B-update 10.3.2013.xlsx Page 5 DI.G Page 69 of 98 Schedule A Summary of 2014 Budget Adjustments by Fund Budget Amendment #6 Ordinance 6474 Mitigation Fees Fund (#124) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 2,456,217.00 955,185.00 426,050.00 2,985,352.00 BA#6 (Proposed Ordinance #6474)0.00 Transfer Traffic Mitigation Fees to F102 CP1218 - AWS Corridor Safety Improv.0.00 0.00 250,000.00 (250,000.00) CP1114 - AWS & 12th St. SE Intersection Improv.0.00 0.00 250,000.00 (250,000.00) CP1119 - AWS Corridor Improv. (Fir to Hemlock)0.00 0.00 200,000.00 (200,000.00) TIP #40 - 124th Ave. SE Corridor Improv. Phase 1 (& 2)0.00 0.00 175,000.00 (175,000.00) CP0911 - F St. SE (4th St. SE to AWS)0.00 0.00 50,000.00 (50,000.00) TIP #54 - Kersey Way SE Corridor Study 0.00 0.00 50,000.00 (50,000.00) CP1023 - Auburn Ave. NE & 3rd St. NE Pedestrian Imp.0.00 0.00 50,000.00 (50,000.00) TIP #41 - 124th Ave. SE Corridor Improv. Phase 2 (deleted; combine with TIP #40)0.00 0.00 (50,000.00)50,000.00 Transfer Park Impact Fees to F321 CPXXXX - Misc. Park Improvements 0.00 0.00 100,000.00 (100,000.00) Transfer Out To F328 CP1315 - City Wetland Mitigation Projects 0.00 0.00 15,790.00 (15,790.00) Downtown Property Sales Traffic Impact Fee revenue from F328 for Teutsch Development 0.00 1,045,300.00 0.00 1,045,300.00 BA#6 Total 0.00 1,045,300.00 1,090,790.00 (45,490.00) 2014 Revised Budget 2,456,217.00 2,000,485.00 1,516,840.00 2,939,862.00 Total Resources / Expenditures 4,456,702.00 4,456,702.00 2010 Annex A&B Bond Debt Fund (#230) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 158.00 1,696,520.00 1,696,520.00 158.00 BA#6 (Proposed Ordinance #6474)0.00 Continuation of sequestration impacts (BA#2; 6.17.2013) Increase Transfer In from F328 - REET1 0.00 17,675.00 0.00 17,675.00 Increase Transfer In from Facility fund F505 0.00 17,675.00 0.00 17,675.00 Reduced federal Build America Bond subsidy 0.00 (35,350.00)0.00 (35,350.00) BA#6 Total 0.00 0.00 0.00 0.00 2014 Revised Budget 158.00 1,696,520.00 1,696,520.00 158.00 Total Resources / Expenditures 1,696,678.00 1,696,678.00 F:\Budget Directory\2014 Budget\BA#6 - Mid Biennial Review\BA#6 - Sched A & B\BA#6 Worksheet - Sched A and B-update 10.3.2013.xlsx Page 6 DI.G Page 70 of 98 Schedule A Summary of 2014 Budget Adjustments by Fund Budget Amendment #6 Ordinance 6474 2010 C&D Local Revitalization Debt Fund (#231) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 200.00 598,320.00 598,220.00 300.00 BA#6 (Proposed Ordinance #6474)0.00 Continuation of sequestration impacts (BA#2; 6.17.2013) Increase Transfer In from F328 - REET2 0.00 11,408.00 0.00 11,408.00 Reduced Federal Build America Bond subsidy 0.00 (11,408.00)0.00 (11,408.00) BA#6 Total 0.00 0.00 0.00 0.00 2014 Revised Budget 200.00 598,320.00 598,220.00 300.00 Total Resources / Expenditures 598,520.00 598,520.00 Municipal Park Construction Fund (#321) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 325,267.00 18,171,700.00 18,436,000.00 60,967.00 BA#6 (Proposed Ordinance #6474) Project Carryforwards and Adjustments CP1016 - Fenster Levee Setback (funding: King Co $90,636,0.00 524,231.00 684,500.00 (160,269.00) federal grant $383,962; State grant $39,633; Stormwater utility $10,000) CPXXXX - Issac Evans Park 25,000.00 0.00 25,000.00 0.00 CPXXXX - Parks Acquisition & Development 20,000.00 0.00 20,000.00 0.00 CPXXXX - Dykstra Park (moved to 2015)0.00 0.00 (65,000.00)65,000.00 CPXXXX - Auburndale Park II (moved to 2015)0.00 0.00 (25,000.00)25,000.00 CPXXXX - Misc. Park Improvements (Funding: Park impact fees)0.00 100,000.00 0.00 100,000.00 CP0925 - Auburn Community Center - Reduce budget from 0.00 (9,160,000.00)(9,160,000.00)0.00 $17.66M to $8.5M. Funding Source includes $3.0M State appropriation and $5.5M from future sources to be determined. BA#6 Total 45,000.00 (8,535,769.00)(8,520,500.00)29,731.00 2014 Revised Budget 370,267.00 9,635,931.00 9,915,500.00 90,698.00 Total Resources / Expenditures 10,006,198.00 10,006,198.00 F:\Budget Directory\2014 Budget\BA#6 - Mid Biennial Review\BA#6 - Sched A & B\BA#6 Worksheet - Sched A and B-update 10.3.2013.xlsx Page 7 DI.G Page 71 of 98 Schedule A Summary of 2014 Budget Adjustments by Fund Budget Amendment #6 Ordinance 6474 Capital Improvements Fund (#328) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 4,586,304.00 1,524,819.00 1,097,300.00 5,013,823.00 BA#6 (Proposed Ordinance #6474) Continuation of sequestration impacts (BA#2; 6.17.2013) Transfer out to F230 for BAB subsidy 0.00 0.00 17,675.00 (17,675.00) Transfer out to F231 for BAB subsidy 0.00 0.00 11,408.00 (11,408.00) Project Carryforwards and Adjustments CP1303 - City Hall Remodel Phase 2 & 3 438,000.00 0.00 438,000.00 0.00 CPXXXX - City Sidewalk Improvements (Funding: State grant)0.00 100,000.00 125,000.00 (25,000.00) CP0716 - City Hall HVAC System Upgrade 99,319.00 0.00 99,319.00 0.00 CP1315 - Wetland Mitigation Proj. (Funding: Wetland mitigation fees)0.00 15,790.00 15,790.00 0.00 CP1226 - 8th St. NE & C St. NW Intersection Improv.5,000.00 0.00 5,000.00 0.00 CP1318 - Downtown Public Art (Peoples Choice Award)8,000.00 0.00 8,000.00 0.00 Downtown Property Sales - Teutsch Development Payment of Traffic Impact Fees to F124; source: REET 2 0.00 0.00 1,045,300.00 (1,045,300.00) BA#6 Total 550,319.00 115,790.00 1,765,492.00 (1,099,383.00) 2014 Revised Budget 5,136,623.00 1,640,609.00 2,862,792.00 3,914,440.00 Total Resources / Expenditures 6,777,232.00 6,777,232.00 Golf Course Debt Service Fund (#417) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 0.00 393,144.00 393,144.00 0.00 BA#6 (Proposed Ordinance #6474) Golf Debt Service Admin Fees (Bank of New York),0.00 1,000.00 1,000.00 0.00 funded by transfer in from Cumulative Reserve BA#6 Total 0.00 1,000.00 1,000.00 0.00 2014 Revised Budget 0.00 394,144.00 394,144.00 0.00 Total Resources / Expenditures 394,144.00 394,144.00 F:\Budget Directory\2014 Budget\BA#6 - Mid Biennial Review\BA#6 - Sched A & B\BA#6 Worksheet - Sched A and B-update 10.3.2013.xlsx Page 8 DI.G Page 72 of 98 Schedule A Summary of 2014 Budget Adjustments by Fund Budget Amendment #6 Ordinance 6474 Water Fund (#430) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 6,618,981.00 13,562,749.00 16,516,114.00 3,665,616.00 BA#6 (Proposed Ordinance #6474) Fund Operations New FTE - 1.0 Records Clerk (2% Water Funded)0.00 0.00 1,685.18 (1,685.18) Continuation of previously approved requests Approved labor agreement adj (BA#1; 3.04.2013 & BA#2; 6.17.2013)0.00 0.00 33,296.79 (33,296.79) ER&R Office Assistant (22% water; BA#2; 6.17.2013)0.00 0.00 17,060.00 (17,060.00) Emergency Management Office Asst (0.6 FTE to 1.0 FTE - 0.00 0.00 8,949.20 (8,949.20) 40% water funded; BA#1; 3.04.2013) Sequestration impacts (BA#2; 6.17.2013)0.00 (14,705.00)5,892.00 (20,597.00) Project Carryforwards and Adjustments CP0915 - Well 1 Improv. (Funding: PWTF loan)1,311,914.00 1,077,945.00 2,389,859.00 0.00 CP1219 - Valley AC Main Replacement 1,165,000.00 0.00 1,165,000.00 0.00 CP0765 - Lakeland Hills Reservoir Improv.725,500.00 0.00 725,500.00 0.00 CP1308 - BNSF Utility Crossing 680,000.00 0.00 680,000.00 0.00 CPXXXX - West Hill Springs Improvements 0.00 0.00 150,000.00 (150,000.00) C512A0 - Well 4 Power & Chlorination 0.00 0.00 137,300.00 (137,300.00) C524A0 - SCADA System Improv.100,000.00 0.00 100,000.00 0.00 BA#6 Total 3,982,414.00 1,063,240.00 5,414,542.17 (368,888.17) 2014 Revised Budget 10,601,395.00 14,625,989.00 21,930,656.17 3,296,727.83 Total Resources / Expenditures 25,227,384.00 25,227,384.00 Sewer Fund (#431) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 7,576,717.00 21,558,701.00 21,863,847.00 7,271,571.00 BA#6 (Proposed Ordinance #6474) Fund Operations New FTE - 1.0 Records Clerk (2% Sewer Funded)0.00 0.00 1,685.18 (1,685.18) Continuation of previously approved requests Approved labor agreement adj (BA#1; 3.04.2013 & BA#2; 6.17.2013)0.00 0.00 25,251.57 (25,251.57) ER&R Office Assistant (22% sewer; BA#2; 6.17.2013)0.00 0.00 17,060.00 (17,060.00) Sequestration impacts (BA#2; 6.17.2013)0.00 (6,575.00)5,892.00 (12,467.00) Emergency Management Office Asst (0.6 FTE to 1.0 FTE -0.00 0.00 3,355.95 (3,355.95) 15% sewer funded; BA#1; 3.04.2013) Move KC Metro Revenues & Expenditures to F433 (BA#1; 3.04.2013)0.00 (14,000,000.00)(14,000,000.00)0.00 BA#6 Total 0.00 (14,006,575.00)(13,946,755.30)(59,819.70) 2014 Revised Budget 7,576,717.00 7,552,126.00 7,917,091.70 7,211,751.30 Total Resources / Expenditures 15,128,843.00 15,128,843.00 F:\Budget Directory\2014 Budget\BA#6 - Mid Biennial Review\BA#6 - Sched A & B\BA#6 Worksheet - Sched A and B-update 10.3.2013.xlsx Page 9 DI.G Page 73 of 98 Schedule A Summary of 2014 Budget Adjustments by Fund Budget Amendment #6 Ordinance 6474 Storm Drainage Fund (#432) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 6,299,114.00 9,295,843.00 8,530,856.00 7,064,101.00 BA#6 (Proposed Ordinance #6474) Fund Operations New FTE - 1.0 Records Clerk (2% Storm Funded)0.00 0.00 1,685.18 (1,685.18) Continuation of previously approved requests Approved labor agreement adj (BA#1; 3.04.2013 & BA#2; 6.17.2013)0.00 0.00 31,148.44 (31,148.44) ER&R Office Assistant (22% sewer; BA#2; 6.17.2013)0.00 0.00 17,060.00 (17,060.00) Sequestration impacts (BA#2; 6.17.2013)0.00 (5,501.00)5,892.00 (11,393.00) Emergency Management Office Asst (0.6 FTE to 1.0 FTE - 0.00 0.00 3,355.95 (3,355.95) 15% storm; BA#1; 3.04.2013) Transfer Out Median Maintenance costs to the General Fund (BA#2; 6.17.2013)0.00 0.00 74,000.00 (74,000.00) 0.00 Project Carryforwards and Adjustments CP1122 - 30th St. NE Area Flooding Phase 1 1,939,588.00 0.00 1,939,588.00 0.00 CP1202 - AWS Flooding Phase 2 1,338,000.00 0.00 1,338,000.00 0.00 CPXXXX - East Ridge Manor Storm Drainage Improv.535,000.00 0.00 535,000.00 0.00 CP1302 - BNSF Utility Crossing 420,000.00 0.00 420,000.00 0.00 CPXXXX - Vactor Decant Facility 0.00 0.00 270,000.00 (270,000.00) CP0746 - Mill Creek 250,000.00 0.00 250,000.00 0.00 Transfer Out To F321 CP1016 - Fenster Levee Setback 0.00 0.00 10,000.00 (10,000.00) BA#6 Total 4,482,588.00 (5,501.00)4,895,729.57 (418,642.57) 2014 Revised Budget 10,781,702.00 9,290,342.00 13,426,585.57 6,645,458.43 Total Resources / Expenditures 20,072,044.00 20,072,044.00 Sewer Metro Fund (#433) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 0.00 0.00 0.00 0.00 BA#6 (Proposed Ordinance #6474) Fund operations Continuation of previously approved requests Move KC Metro Revenues & Expenditures from F431 (BA#1; 3.04.2013)0.00 14,000,000.00 14,000,000.00 0.00 BA#6 Total 0.00 14,000,000.00 14,000,000.00 0.00 2014 Revised Budget 0.00 14,000,000.00 14,000,000.00 0.00 Total Resources / Expenditures 14,000,000.00 14,000,000.00 F:\Budget Directory\2014 Budget\BA#6 - Mid Biennial Review\BA#6 - Sched A & B\BA#6 Worksheet - Sched A and B-update 10.3.2013.xlsx Page 10 DI.G Page 74 of 98 Schedule A Summary of 2014 Budget Adjustments by Fund Budget Amendment #6 Ordinance 6474 Solid Waste Fund (#434) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 596,362.00 12,062,904.00 12,497,894.00 161,372.00 BA#6 (Proposed Ordinance #6474) Fund operations New FTE - 1.0 Records Clerk (0.5% Solid Waste Funded)0.00 0.00 421.29 (421.29) Continuation of previously approved requests Adjust budgeted revenues and expenses for King County 0.00 1,087,595.00 35,278.00 1,052,317.00 tipping fee increase and Council approved Solid Waste rates per Ordinance #6438; 11.19.2012. Approved labor agreement adj (BA#1; 3.04.2013 & BA#2; 6.17.2013)0.00 0.00 7,134.34 (7,134.34) BA#6 Total 0.00 1,087,595.00 42,833.63 1,044,761.37 2014 Revised Budget 596,362.00 13,150,499.00 12,540,727.63 1,206,133.37 Total Resources / Expenditures 13,746,861.00 13,746,861.00 Airport Fund (#435) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 544,152.00 808,380.00 867,903.00 484,629.00 BA#6 (Proposed Ordinance #6474) Fund Operations Continuation of previously approved requests Approved labor agreement adj (BA#1; 3.04.2013 & BA#2; 6.17.2013)0.00 0.00 466.58 (466.58) Project Carryforwards and Adjustments CPXXXX - Asphalt Rehab & Seal Coat (Funding: Federal grant $238,500 0.00 251,750.00 265,000.00 (13,250.00) & State Grant $13,250) CPXXXX - General Repair & Maint. (Funding: Federal grant)103,000.00 37,000.00 140,000.00 0.00 CPXXXX - Wildlife Hazard Assessment (Funding: Federal 0.00 38,000.00 40,000.00 (2,000.00) grant $36,000 & State Grant $2,000) CP1221 - Airport Master Plan (reduce for portion completed in 2013)0.00 (100,000.00)(111,500.00)11,500.00 BA#6 Total 103,000.00 226,750.00 333,966.58 (4,216.58) 2014 Revised Budget 647,152.00 1,035,130.00 1,201,869.58 480,412.42 Total Resources / Expenditures 1,682,282.00 1,682,282.00 F:\Budget Directory\2014 Budget\BA#6 - Mid Biennial Review\BA#6 - Sched A & B\BA#6 Worksheet - Sched A and B-update 10.3.2013.xlsx Page 11 DI.G Page 75 of 98 Schedule A Summary of 2014 Budget Adjustments by Fund Budget Amendment #6 Ordinance 6474 Cemetery Fund (#436) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 58,852.00 1,049,010.00 1,024,384.00 83,478.00 BA#6 (Proposed Ordinance #6474) Fund Operations Continuation of previously approved requests Approved labor agreement adj (BA#1; 3.04.2013 & BA#2; 6.17.2013)0.00 0.00 2,964.29 (2,964.29) Reduce budget for Office Assistant position 0.00 0.00 (78,004.00)78,004.00 eliminated in December 2012. Project Carryforwards and Adjustments CPXXXX - Columbarium Niche Caps (project deleted; funded by Cemetery 0.00 0.00 (10,000.00)10,000.00 operations) Adjust budgeted revenues to reflect rate increases approved 0.00 127,200.00 0.00 127,200.00 by Res.4886; 1.22.2013 BA#6 Total 0.00 127,200.00 (85,039.71)212,239.71 2014 Revised Budget 58,852.00 1,176,210.00 939,344.29 295,717.71 Total Resources / Expenditures 1,235,062.00 1,235,062.00 Golf Course Fund (#437) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 91,134.00 1,521,430.00 1,537,577.00 74,987.00 BA#6 (Proposed Ordinance #6474) Fund Operations Continuation of previously approved requests Approved labor agreement adj (BA#1; 3.04.2013 & BA#2; 6.17.2013)0.00 0.00 2,838.18 (2,838.18) BA#6 Total 0.00 0.00 2,838.18 (2,838.18) 2014 Revised Budget 91,134.00 1,521,430.00 1,540,415.18 72,148.82 Total Resources / Expenditures 1,612,564.00 1,612,564.00 F:\Budget Directory\2014 Budget\BA#6 - Mid Biennial Review\BA#6 - Sched A & B\BA#6 Worksheet - Sched A and B-update 10.3.2013.xlsx Page 12 DI.G Page 76 of 98 Schedule A Summary of 2014 Budget Adjustments by Fund Budget Amendment #6 Ordinance 6474 Facilities Fund (#505) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 972,003.00 3,432,500.00 3,447,704.00 956,799.00 BA#6 (Proposed Ordinance #6474) Fund Operations Continuation of previously approved requests Transfer out to F230 for sequestration (BA#2; 6.17.2013)0.00 17,675.00 17,675.00 0.00 Approved labor agreement adj (BA#1; 3.04.2013 & BA#2; 6.17.2013)0.00 0.00 6,307.20 (6,307.20) Stratford Lot parking and Sound Transit Garage security (BA#1; 3.04.2013)0.00 0.00 22,000.00 (22,000.00) BA#6 Total 0.00 17,675.00 45,982.20 (28,307.20) 2014 Revised Budget 972,003.00 3,450,175.00 3,493,686.20 928,491.80 Total Resources / Expenditures 4,422,178.00 4,422,178.00 Innovation and Technology Fund (#518) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 1,921,570.00 4,990,126.00 5,137,179.00 1,774,517.00 BA#6 (Proposed Ordinance #6474) Fund Operations Continuation of previously approved requests Approved labor agreement adj (BA#1; 3.04.2013 & BA#2; 6.17.2013)0.00 0.00 31,650.24 (31,650.24) Funding for new Standby Pay Policy for on-call employees 0.00 0.00 15,990.00 (15,990.00) New FTE - 1.0 Office Assistant 0.00 0.00 79,600.00 (79,600.00) Personal Computer for new FTE - Records Clerk 0.00 2,500.00 2,500.00 0.00 BA#6 Total 0.00 2,500.00 129,740.24 (127,240.24) 2014 Revised Budget 1,921,570.00 4,992,626.00 5,266,919.24 1,647,276.76 Total Resources / Expenditures 6,914,196.00 6,914,196.00 F:\Budget Directory\2014 Budget\BA#6 - Mid Biennial Review\BA#6 - Sched A & B\BA#6 Worksheet - Sched A and B-update 10.3.2013.xlsx Page 13 DI.G Page 77 of 98 Schedule A Summary of 2014 Budget Adjustments by Fund Budget Amendment #6 Ordinance 6474 Equipment Rental Fund (#550) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 3,235,090.00 2,992,750.00 4,095,913.00 2,131,927.00 BA#6 (Proposed Ordinance #6474) Fund Operations New FTE - 1.0 Mechanic - Salary and Benefit 0.00 0.00 84,033.71 (84,033.71) expenses offset by reducing existing budget.0.00 0.00 (84,033.71)84,033.71 Equipment for New Mechanic FTE - One Time Costs 0.00 0.00 5,000.00 (5,000.00) Continuation of previously approved requests Approved labor agreement adj (BA#1; 3.04.2013 & BA#2; 6.17.2013)0.00 0.00 5,100.74 (5,100.74) ER&R Office Assistant (24% ER&R; BA#2; 6.17.2013)0.00 0.00 18,610.00 (18,610.00) BA#6 Total 0.00 0.00 28,710.74 (28,710.74) 2014 Revised Budget 3,235,090.00 2,992,750.00 4,124,623.74 2,103,216.26 Total Resources / Expenditures 6,227,840.00 6,227,840.00 Fire Pension Fund (#611) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 2,482,786.00 73,000.00 180,860.00 2,374,926.00 BA#6 (Proposed Ordinance #6474) Fund Operations Continuation of previously approved requests Approved labor agreement adj (BA#1; 3.04.2013 & BA#2; 6.17.2013)0.00 0.00 202.06 (202.06) Transfer In from General Fund to fully fund pension liability 0.00 231,000.00 0.00 231,000.00 BA#6 Total 0.00 231,000.00 202.06 230,797.94 2014 Revised Budget 2,482,786.00 304,000.00 181,062.06 2,605,723.94 Total Resources / Expenditures 2,786,786.00 2,786,786.00 F:\Budget Directory\2014 Budget\BA#6 - Mid Biennial Review\BA#6 - Sched A & B\BA#6 Worksheet - Sched A and B-update 10.3.2013.xlsx Page 14 DI.G Page 78 of 98 Schedule A Summary of 2014 Budget Adjustments by Fund Budget Amendment #6 Ordinance 6474 Cemetery Endowment Fund (#701) Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 1,547,220.00 139,351.00 1,595,220.00 91,351.00 BA#6 (Proposed Ordinance #6474) Fund Operations Continuation of previously approved requests Endowment Care Fee reduced from 15% to 10% by Ord.6447; 1.7.2013 0.00 (16,000.00)0.00 (16,000.00) BA#6 Total 0.00 (16,000.00)0.00 (16,000.00) 2014 Revised Budget 1,547,220.00 107,351.00 1,595,220.00 59,351.00 Total Resources / Expenditures 1,654,571.00 1,654,571.00 Grand Total - All Funds Beg. Fund Balance 2014 Revenues 2014 Expenditures Ending Fund Balance 2014 Adopted Budget 59,000,241.00 153,945,014.00 164,654,843.00 48,290,412.00 BA#6 (Proposed Ordinance #6474)10,398,217.25 946,747.00 11,455,925.90 (110,961.65) 2014 Revised Budget 69,398,458.25 154,891,761.00 176,110,768.90 48,179,450.35 Total Resources / Expenditures 224,290,219.25 224,290,219.25 October 11, 2013 Prepared by City of Auburn Financial Planning Department F:\Budget Directory\2014 Budget\BA#6 - Mid Biennial Review\BA#6 - Sched A & B\BA#6 Worksheet - Sched A and B-update 10.3.2013.xlsx Page 15 DI.G Page 79 of 98 Schedule B 2014 Appropriations by Fund 2014 Adopted BA#6 Total 2014 Revised Fund Budget (Ord 6474) Amendments Budget General Fund (#001)58,864,112.00 4,263,192.25 4,263,192.25 63,127,304.25 Arterial Street Fund (#102)4,706,022.00 2,065,446.00 2,065,446.00 6,771,468.00 Local Street Fund (#103)1,718,320.00 493,800.00 493,800.00 2,212,120.00 Hotel Motel Fund (#104)165,431.00 - - 165,431.00 Arterial Street Preservation Fund (#105)3,627,660.00 5,000.00 5,000.00 3,632,660.00 Drug Forfeiture Fund (#117)1,198,768.00 - - 1,198,768.00 Housing and Community Development Grant Fund (#119)495,647.00 - - 495,647.00 Recreation Trails Fund (#120)36,691.00 - - 36,691.00 Business Improvement Area Fund (#121)76,720.00 - - 76,720.00 Cumulative Reserve Fund (#122)5,703,796.00 - - 5,703,796.00 Mitigation Fees Fund (#124)3,411,402.00 1,045,300.00 1,045,300.00 4,456,702.00 1998 Library Fund (#229)330,354.00 - - 330,354.00 2010 Annex A&B Bond Debt Fund (#230)1,696,678.00 - - 1,696,678.00 2010 C&D Local Revitalization Debt Fund (#231)598,520.00 - - 598,520.00 LID Guarantee Fund (#249)34,688.00 - - 34,688.00 LID #250 (#250)56,762.00 - - 56,762.00 LID #350 (#275)7,246.00 - - 7,246.00 Municipal Park Construction Fund (#321)18,496,967.00 (8,490,769.00) (8,490,769.00) 10,006,198.00 Capital Improvements Fund (#328)6,111,123.00 666,109.00 666,109.00 6,777,232.00 Golf Course Debt Service Fund (#417)393,144.00 1,000.00 1,000.00 394,144.00 Water Fund (#430)20,181,730.00 5,045,654.00 5,045,654.00 25,227,384.00 Sewer Fund (#431)29,135,418.00 (14,006,575.00) (14,006,575.00) 15,128,843.00 Storm Drainage Fund (#432)15,594,957.00 4,477,087.00 4,477,087.00 20,072,044.00 Sewer Metro Fund (#433)- 14,000,000.00 14,000,000.00 14,000,000.00 Solid Waste Fund (#434)12,659,266.00 1,087,595.00 1,087,595.00 13,746,861.00 Airport Fund (#435)1,352,532.00 329,750.00 329,750.00 1,682,282.00 Cemetery Fund (#436)1,107,862.00 127,200.00 127,200.00 1,235,062.00 Golf Course Fund (#437)1,612,564.00 - - 1,612,564.00 Insurance Fund (#501)1,784,479.00 - - 1,784,479.00 Facilities Fund (#505)4,404,503.00 17,675.00 17,675.00 4,422,178.00 Innovation and Technology Fund (#518)6,911,696.00 2,500.00 2,500.00 6,914,196.00 Equipment Rental Fund (#550)6,227,840.00 - - 6,227,840.00 Fire Pension Fund (#611)2,555,786.00 231,000.00 231,000.00 2,786,786.00 Cemetery Endowment Fund (#701)1,686,571.00 (16,000.00) (16,000.00) 1,670,571.00 Total 212,945,255.00 11,344,964.25 11,344,964.25 224,290,219.25 October 11, 2013 Prepared by City of Auburn Financial Planning Department page 16DI.G Page 80 of 98 AGENDA BILL APPROVAL FORM Agenda Subject: SCORE Jail Stats Date: October 16, 2013 Department: Finance Attachments: SCORE Jail Statistics 2014 SCORE Budget Budget Impact: $0 Administrative Recommendation: Information only. Background Summary: Attached are the September Reports for the SCORE facility. City of Auburn Average Daily Population (ADP) for the month of September is 78. SCORE is now tracking ADP for the 2015 budget year, which is based upon the April 1, 2013 through March 31, 2014 ADP. ADP for the period April 2013 through September 2013 is approximately 71, down from 2014 budget count of 84. Contract ADP continues to grow, generating revenue that will offset future member city costs. The adopted budget for SCORE is attached. The City of Auburn's contribution to SCORE for the 2014 budget year is $5,504,537 and is based upon a 27.36% share of the operating costs. This is a $1,173,432 reduction in costs from the previous year where Auburn contributed 33.98% of the operating costs. See page 3 of the attached budget. Reviewed by Council Committees: Municipal Services Councilmember:Peloza Staff:Coleman Meeting Date:October 28, 2013 Item Number:DI.H AUBURN * MORE THAN YOU IMAGINEDDI.H Page 81 of 98 DI.H Page 82 of 98 DI.H Page 83 of 98 DI.H Page 84 of 98 DI.H Page 85 of 98 DI.H Page 86 of 98 DI.H Page 87 of 98 DI.H Page 88 of 98 DI.H Page 89 of 98 DI.H Page 90 of 98 DI.H Page 91 of 98 DI.H Page 92 of 98 DI.H Page 93 of 98 DI.H Page 94 of 98 DI.H Page 95 of 98 DI.H Page 96 of 98 AGENDA BILL APPROVAL FORM Agenda Subject: Project Matrix Date: October 15, 2013 Department: Police Attachments: Project Matrix Budget Impact: $0 Administrative Recommendation: Background Summary: Reviewed by Council Committees: Municipal Services Councilmember:Peloza Staff: Meeting Date:October 28, 2013 Item Number:DI.I AUBURN * MORE THAN YOU IMAGINEDDI.I Page 97 of 98 MUNICIPAL SERVICES COMMITTEE PROJECT - GOAL MATRIX NO.PROJECT DESCRIPTION LEAD COST REVIEW DATE EST. COMPL. DATE STATUS 10P Red Light Photo Enforcement Bob Lee 10/28/2013 Quarterly Reports: Jan (Prev Oct-Dec); April (Prev Jan- Mar); July (Prev Apr-June); October (Prev July-Sept) 2nd meeting of the month. The amended contract expires 5/31/14. City will initiate RFP process. 20P Animal Control and Rescue Bob Lee 1/13/2014 On-Going Quarterly Reports: Jan (Prev Oct-Dec); April (Prev Jan- Mar); July (Prev Apr-June); October (Prev July-Sept) 1st meeting of the month. 21P AVHS Board Review Shelley Coleman 10/28/2013 On-Going Report will be provided monthly after the 3rd Thursday. 24P Fireworks Update Bob Lee 6/9/2014 On-Going The Council Operations Committee/MIT met on 5/28/13. Further MIT Fireworks improvements were announced. 27P Animal Control Licensing Program Shelley Coleman 10/28/2013 On-Going Monthly staff report to be provided at 2nd meeting of the month. 28 P Solid Waste Rate Review Shelley Coleman 12/9/2013 Through MSWMAC input from other cities will help COA determine if it will change to direct billing. New rates will go into effect January 1 (2013 & 2014). Annual rate increases are planned in the next 4-5 years to end the commercial subsidy for residential service. 29P Golf Course & Restaurant Working Capital Review and Future Plans Shelley Coleman 10/28/2013 On-Going Quarterly Reports: Jan (Prev Oct-Dec); April (Prev Jan- Mar); July (Prev Apr-June); October (Prev July-Sept) 2nd meeting of the month. 31P Cemetery Update Daryl Faber 10/28/2013 Quarterly update to review Marketing Plan. 2nd meeting of the month. NO.ITEM OF INTEREST 3 I Shopping Cart Update Randy Bailey 1/13/2014 January (Prev July-Dec), July (Prev Jan-June). 4 I Ordinance No. 6398 - Pull Tabs Dan Heid 1/13/2014 Annual review of taxation basis to determine if any changes need to be made -dependent upon status of economy. Ordinance No. 6398 was enacted 2/21/12. 6I SCORE Jail Stats Shelley Coleman 10/28/2013 Quarterly Reports: Jan (Prev Oct-Dec); April (Prev Jan- Mar); July (Prev Apr-June); October (Prev July-Sept) 2nd meeting of the month. Review SCORE Jail statistics. 7I Concealed Pistol Licenses Benefit Cost Analysis John Partridge 11/25/2013 Determine if we have appropriate costs for this task.This item has been assigned to Councilmember Partridge to take to the Regional Law Safety &Justice Committee meetings for discussions. 8I Street Sweeping Schedule Randy Bailey 11/12/2013 Review street sweeping schedule. Last Revision Date: 10/15/13 E:\AGENDA\MunicipalServicesPaperlessPacket\2013\20-October 28\Resources\Matrix 10-15-13.xls DI.I Page 98 of 98