HomeMy WebLinkAbout03-03-2014 PUBLIC WORKS COMMITTEE AGENDA MODIFICATIONPage 1 of 1
Interoffice Memorandum
Engineering Division
To: Public Works Committee
From: Ingrid Gaub, Interim City Engineer
CC: Mayor
City Clerk
Councilmembers
Shelley Coleman, Finance Director
Dan Heid, City Attorney
Date: January 6, 2014
Re: Agenda Modification for the January 6, 2014 Meeting
This modification removes the following item from the agenda:
IV. DISCUSSION
E. Ordinance No. 6502* (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. 6474, ORDINANCE NO. 6481, AUTHORIZING AMENDMENT
TO THE CITY OF AUBURN 2013-2014 BUDGET AS SET FORTH IN
SCHEDULE “A” AND SCHEDULE “B”
AGENDA BILL APPROVAL FORM
Agenda Subject:
Ordinance No. 6502
Date:
February 26, 2014
Department:
Finance
Attachments:
Ord. No. 6502, Memo, Att “A and B”
Budget Impact:
$26,160,549 (see attached)
Administrative Recommendation:
City Council to introduce and adopt Ordinance No. 6502, amending the 2014 budget
Background Summary:
Ordinance No. 6502 (Budget Amendment #7) represents the seventh budget amendment for the 2013-
2014 biennium and the second budget amendment for 2014. For details, see the attached transmittal
memorandum and supporting attachments.
Reviewed by Council & Committees: Reviewed by Departments & Divisions:
Arts Commission COUNCIL COMMITTEES: Building M&O
Airport Finance Cemetery Mayor
Hearing Examiner Municipal Serv. Finance Parks
Human Services Planning & CD Fire Planning
Park Board Public Works Legal Police
Planning Comm. Other Public Works Human Resources
Information Services
Action:
Committee Approval: Yes No
Council Approval: Yes No Call for Public Hearing ___/___/____
Referred to _________________________________ Until ____/___/____
Tabled ______________________________________ Until ___/___/____
Councilmember: Wales Staff: Coleman
Meeting Date: March 3, 2014 Item Number:
Interoffice Memorandum
To: City Council
From: Shelley Coleman, Finance Director
CC: Nancy Backus, Mayor
Date: February 26, 2014
Re: Ordinance #6502 – 2013-2014 Budget Amendment #7
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 and Budget Amendment #6
amended the budget for calendar year 2014. This amendment is the 7th budget amendment for the
biennium and the 2nd budget amendment for calendar year 2014.
Proposed amendments to the 2014 budget are as follows:
Carry-forward requests. Carry-forward requests represent projects and programs that were authorized and
started in 2013 but not yet completed at the end of December. Funding is therefore requested to be carried-
forward to 2014 for project continuation/completion. The majority of this budget amendment pertain to carry-
forward requests, most of which are related to transportation and utility capital projects as follows.
Transportation / Utility Projects
Arterial street improvements (Fund #102: $6,835,536)
o Auburn Way South corridor improvements (major funding from state and federal grants and
contribution from MIT);
o citywide traffic signal safety improvement (major funding from federal grants);
o 37th and B Street NW railroad crossing safety improvements (partial funding from federal grants)
o Auburn Way South and M Street Improvements (partial funding from state grants)
Local street improvements (Fund #103: $701,060)
o Local Street pavement reconstruction
Arterial Street Preservation (Fund #105: $623,600)
o Arterial pavement patching, chip seal and overlay
Water Utility (Fund #430: $4,193,683)
o Well 1 improvements
o Fulmer well field improvements
o Water meter and billing system improvements
o Academy booster pump station
o D Street utilities improvements
Sewer Utility (Fund #431: $2,302,627)
o Sewer pump station improvements
o Auburn Way South flooding
o D Street utility improvements
o BNSF utility crossing improvements
Storm Utility (Fund #432: $6,453,350)
o 30th Street NE area flooding
o Mill Creek wetland 5K restoration
o East Ridge Manor drainage improvement
o D Street utility improvement
o General storm system repair/replacement
Other Carryforward Requests. Other carryforward requests include general capital improvements, Airport
projects, Innovation/Technology projects, and vehicle/equipment replacements and are as follows:
General Fund (Fund #001: $243,348)
o Human services contracts including one-stop center, neighborhood grants, emergency housing,
and non-profit support (Administration; $153,348)
o Major comprehensive plan update (Community Development/Public Works; $51,000)
o Golf course repairs and Parks and Recreation open space plan (Parks; $39,000)
General capital improvements (Fund #328: $781,774)
o Citywide sidewalk repairs and annual traffic signal improvements
o City Hall remodel
o REET 2 transfer out to Arterial Streets improvement projects
Airport (Fund #435: $158,566)
o Airport Master Plan
o Asphalt rehabilitation
o Wildlife hazard mitigation
Facilities (Fund #505: $224,300)
o City hall exterior cleaning and brick sealing
o New roof for M&O building
Innovation and technological projects (Fund #518: $782,000)
o Citywide communications system hardware maintenance and system upgrade
o Springbrook utility billing system upgrade
o CAD replacement project
Equipment Repair and Replacement (Fund #550: $956,570)
o Replacing 1996 International thermo-lay truck for street maintenance
o Replacing 1994 International dump truck for water department
o Maintenance and Operations vehicle bay storage and fuel tank replacement
Other requests. Other requests included in this budget amendment establishes spending authority for new
items, such as contracts for services, land purchases, and receipt of grant revenues and insurance
reimbursements for which an amendment to budget is needed to formally receive and use these resources.
This category amends the 2014 budget for the following significant items:
General Fund (Fund #001)
o State and federal lobbying contract with Thompson Consulting per Res.5040 ($42,000 – net cost,
including cost of existing contract with Washington2 Advocates)
o Increased cost of Valley Communications emergency call center services ($172,000), based upon
2014 Valley Com budget and City’s share of total calls for service (approximately 17.6% of total
calls). Current budget is $1,651,900.
o Eliminate budgeted criminal justice high crime revenues ($144,228) – Auburn no longer qualifies
for state high crime distributions as the City’s crime rate is no longer in excess of 125% of state-
wide average (Auburn’s crime rate is 70 crimes/1,000 population vs 125% threshold of 100
crimes/1,000 population). Historically, the City received $149,000 in 2012 and $78,000 in 2013.
No distributions are expected in 2014.
Arterial Streets (Fund #102: $635,770)
o Property purchase of 5 parcels along the Lea Hill Road corridor expansion route. The properties
are currently listed for sale and the acquisition would be performed voluntarily (ie, no
condemnation). The corridor improvement is identified in the City’s TIP.
Cumulative Reserve (Fund #122: $250,000)
o Transfer to Equipment Repair/Replacement Fund (Fund #550) to replace aging golf course
mowers and to begin replacing the city’s fleet of electric golf carts over the next 3 years (replace
approximately 25 carts/year; citywide fleet is 72 carts)
General Capital Improvements (Fund #328: $70,000)
o Improvements to Marchini Meadows development (partially supported by developer payments)
Storm Utility (Fund #432: $1,689,400)
o M&O facility surface water runoff improvements (State DOE grant funding and contributions from
water and sewer utility)
Cemetery Fund (Fund #436: $50,000)
o Facility interfund charges to Cemetery is adjusted to more closely reflect actual utility charges.
Facilities (Fund #505: $339,300)
o R Street Property improvements and electrical system upgrade (partially funded by insurance
reimbursement)
Council approval of proposed Ordinance 6502 would amend the 2014 budget as follows:
Table 2: 2014 Budget as Amended
2014 Budget as Amended $ 235,925,274
Budget Amendment #7 (Ord #6502) 26,160,549
Revised Budget as Amended $262,085,823
Attachments:
1. Proposed Ordinance #6502 (budget adjustment #7)
2. Summary of proposed 2014 budget adjustments by fund and department (Schedule A)
3. Summary of approved changes to adopted 2014 budget by fund (Schedule B)
-------------------------
Ordinance No. 6502
February 26, 2014
Page 1 of 4
ORDINANCE NO. 6502
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. 6474, ORDINANCE NO. 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. 6502
February 26, 2014
Page 2 of 4
WHEREAS, the Auburn City Council at its regular meeting of December 2,
2013, adopted Ordinance No. 6481 (BA#5), which amended Ordinance No. 6473
which amended the City of Auburn 2013-2014 Biennial budget; and
WHEREAS, the Auburn City Council at its regular meeting of December 2,
2013, adopted Ordinance No. 6474 (BA#6), which amended Ordinance No. 6481
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#7);
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
-------------------------
Ordinance No. 6502
February 26, 2014
Page 3 of 4
remainder of such code, ordinance or regulation or the application thereof to other
person or circumstance shall not be affected.
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: _________________
____________________________
NANCY BACKUS, MAYOR
ATTEST:
____________________________
Danielle E. Daskam
City Clerk
-------------------------
Ordinance No. 6502
February 26, 2014
Page 4 of 4
APPROVED AS TO FORM:
____________________________
Daniel B. Heid
City Attorney
PUBLISHED:__________________
Schedule A
Summary of 2014 Budget Adjustments by Fund
Budget Amendment #7 Ordinance 6502
General Fund (#001)Beg. Fund Balance
2014
Revenues 2014 Expenditures Ending Fund Balance
General Fund
2014 Adopted Budget 8,311,010 50,553,102 54,498,330 4,365,782
BA#6 (Ordinance #6474, 12.3.2013)5,238,690 5,047,826 4,393,501 5,893,015
BA#7 (Proposed Ordinance #6502)
General Fund Revenues
Elimination of Criminal Justice High Crime revenues - the City does not 0 (144,228)0 (144,228)
currently qualify for distribution due to lowered crime rates.
Administrative Services
Carryforward - Projects related to Human Services including One-Stop Center,153,348 0 153,348 0
neighborhood grants, emergency housing, and non-profit support.
Community Development
Carryforward - Major Comprehensive Plan Update.51,000 0 51,000 0
Budget for Operations and Maintenance at Auburn Environmental Park.0 0 45,000 (45,000)
Budget for unanticipated expenditures related to visioning outreach 0 0 15,800 (15,800)
effort for Major Comprehensive Plan Update.0
0
Parks, Arts and Recreation
Carryforward - Golf Course Asphalt Repairs and Overlay on 15th hole ($25,000) and Parks and 39,000 0 39,000 0
Recreation Open Space Plan ($14,000).
New Requests:
Repair of broken drain line at White Soccer Field at Game Farm Park ($8,000) and installation of 0 0 25,000 (25,000)
safety fencing and traffic calming devices at Les Gove Spray Park ($17,000).
Police Department
Increased Valley Communications costs, based upon approved 2014 Valley Communications 0 0 172,000 (172,000)
budget and estimated City share of costs based on calls for service.
Public Works
Carryforward - Comprehensive Transportation Plan Update - MS1311.25,000 0 25,000 0
New Requests:
Budget for A Street NW Rail Crossing inspections, repairs and staff training.0 0 21,000 (21,000)
Non-Departmental
Thompson Consulting Group for State and Federal lobbying efforts (Resolution #5040).0 0 42,000 (42,000)
BA#7 Total 268,348 (144,228)589,148 (465,028)
2014 Revised Budget 13,818,048 55,456,700 59,480,978 9,793,769
Memo: Unrestricted GF Ending fund balance 8,783,481
Memo: Restricted GF Ending fund balance for salaries/benefits 1,010,288
Total Resources / Expenditures 69,274,748 69,274,748
8.0% General Fund Reserve Requirement 4,758,478
F:\Budget Directory\2014 Budget\BA#7 - Carry Forwards\Sched A & B\BA#7 - Sched A and B.xlsx Page 1
Schedule A
Summary of 2014 Budget Adjustments by Fund
Budget Amendment #7 Ordinance 6502
Arterial Street Fund (#102)Beg. Fund Balance
2014
Revenues 2014 Expenditures Ending Fund Balance
2014 Adopted Budget 856,364 3,849,658 3,892,270 813,752
BA#6 (Ordinance #6474, 12.3.2013)130,000 1,935,446 2,549,006 (483,560)
BA#7 (Proposed Ordinance #6502)
Carryforward Projects:
Auburn Way South Corridor Improvements, Fir to Hemlock; $2,061,622 State Grant; 0 2,577,027 2,577,027 0
$515,405 Muckleshoot Contribution - CP1119.
Auburn Way South Pedestrian Improvements; $115,000 Impact Fee Transfer-In from F124; 93,594 835,576 929,170 0
State Grant Funding of $629,376; and Muckleshoot contribution of $91,200 - CP1118.
Citywide Traffic Signal Safety Improvements; $368,376 Federal Grant Funding; $20,684 REET 2 50,000 389,060 439,060 0
Transfer-In from Fund 328 - CP1222.
South 277th Street Corridor Improvements; $76,937 in Federal Grants - C222A0.354,890 76,937 431,827 0
37th and B Street NW Railroad Crossing Safety Improvements; $285,438 in Federal Grants - CP1304.37,690 285,438 323,128 0
8th Street NE and 104th Ave SE Intersection Improvements, $119,000 REET 2 Transfer-In from F328;143,400 178,616 322,016 0
Federal Grant of $59,616 - CP1104.
Auburn Way South & M Street Improvements; $112,632 Transfer-In from F124; $74,963 State 61,186 187,595 248,781 0
Grant - CP1024.
AWS Corridor Safety Improvements; $237,831 Federal Grant - CP1218.0 237,831 237,831 0
M Street Underpass; $215,500 from PWTFL - C201A0.0 215,500 215,500 0
Main Street Signal Upgrade Project; $150,000 Mitigation Impact Fee Transfer-In from F124 - TIP#21.50,000 150,000 200,000 0
A Street NW Extension Wetland Maintenance and Mitigation; $76,672 Transfer-In from F124 - C207A0.66,028 76,672 142,700 0
Citywide Guardrail Improvements; $48,119 Federal Grant; $15,272 reimbursement from PSE - CP0912.0 63,391 63,391 0
Auburn Way South & 12th Street SE Improvements - CP1114.50,000 0 50,000 0
South 277th Street Wetland Mitigation - C410A0.30,000 0 30,000 0
Lea Hill Safe Routes to School Improvements - CP1120.25,105 0 25,105 0
New Requests:
Property purchase of 5 parcels along the future Lea Hill Road Corridor expansion route. The 0 600,000 600,000 0
corridor improvement is identified in the City's Comprehensive Transportation Plan. Funded by
Traffic Impact Fees via Transfer-In from Fund 124.
Lea Hill Safe Routes to School; Project Change Order #2 - CP1120 0 0 35,770 (35,770)
BA#7 Total 961,893 5,873,643 6,871,306 (35,770)
2014 Revised Budget 1,948,257 11,658,747 13,312,582 294,422
Total Resources / Expenditures 13,607,004 13,607,004
Local Street Fund (#103)Beg. Fund Balance
2014
Revenues 2014 Expenditures Ending Fund Balance
2014 Adopted Budget 270,670 1,447,650 1,444,300 274,020
BA#6 (Ordinance #6474, 12.3.2013)228,100 265,700 427,921 65,879
BA#7 (Proposed Ordinance #6502)
Carryforward Projects:
Local Street Pavement Reconstruction Project - CP1323 505,000 0 505,000 0
Local Street Pavement Reconstruction Project - CP1224 153,360 0 153,360 0
Pavement Patching, Chipseal, and Overlay - CP1402 42,700 0 42,700 0
BA#7 Total 701,060 0 701,060 0
2014 Revised Budget 1,199,830 1,713,350 2,573,281 339,899
Total Resources / Expenditures 2,913,180 2,913,180
F:\Budget Directory\2014 Budget\BA#7 - Carry Forwards\Sched A & B\BA#7 - Sched A and B.xlsx Page 2
Schedule A
Summary of 2014 Budget Adjustments by Fund
Budget Amendment #7 Ordinance 6502
Arterial Street Preservation Fund (#105)Beg. Fund Balance
2014
Revenues 2014 Expenditures Ending Fund Balance
2014 Adopted Budget 1,584,937 2,042,723 2,000,000 1,627,660
BA#6 (Ordinance #6474, 12.3.2013)5,000 0 682,984 (677,984)
BA#7 (Proposed Ordinance #6502)
Carryforward Projects:
Pavement Patching, Chipseal, and Overlay - CP1402 568,600 0 568,600 0
West Valley Highway System Preservation - CP1225 55,000 0 55,000 0
BA#7 Total 623,600 0 623,600 0
2014 Revised Budget 2,213,537 2,042,723 3,306,584 949,676
Total Resources / Expenditures 4,256,260 4,256,260
Drug Forfeiture Fund (#117)Beg. Fund Balance
2014
Revenues 2014 Expenditures Ending Fund Balance
2014 Adopted Budget 917,468 281,300 280,915 917,853
BA#6 (Ordinance #6474, 12.3.2013)0 0 1,733 (1,733)
BA#7 (Proposed Ordinance #6502)
Police administrative and research tools. Lexipol - web based policy/legal resource for law 0 0 14,000 (14,000)
enforcement ($10,000 in 2014; $12,900 ongoing annual subscription and maintenance fees starting
in 2015); PoliceOne Academy - training videos and resources for law enforcement ($4,000 in 2014;
$3,000 in ongoing annual subscription fees starting in 2015).
BA#7 Total 0 0 14,000 (14,000)
2014 Revised Budget 917,468 281,300 296,648 902,120
Total Resources / Expenditures 1,198,768 1,198,768
Cumulative Reserve Fund (#122)Beg. Fund Balance
2014
Revenues 2014 Expenditures Ending Fund Balance
2014 Adopted Budget 5,700,796 3,000 1,434,624 4,269,172
BA#6 (Ordinance #6474, 12.3.2013)2,000,000 0 1,222,084 777,916
BA#7 (Proposed Ordinance #6502)
Transfer-Out to Equipment Replacement Fund for Golf Course Equipment Replacement.0 0 250,000 (250,000)
BA#7 Total 0 0 250,000 (250,000)
2014 Revised Budget 7,700,796 3,000 2,906,708 4,797,088
Total Resources / Expenditures 7,703,796 7,703,796
F:\Budget Directory\2014 Budget\BA#7 - Carry Forwards\Sched A & B\BA#7 - Sched A and B.xlsx Page 3
Schedule A
Summary of 2014 Budget Adjustments by Fund
Budget Amendment #7 Ordinance 6502
Mitigation Fees Fund (#124)Beg. Fund Balance
2014
Revenues 2014 Expenditures Ending Fund Balance
2014 Adopted Budget 2,456,217 955,185 426,050 2,985,352
BA#6 (Ordinance #6474, 12.3.2013)0 1,045,300 1,090,790 (45,490)
BA#7 (Proposed Ordinance #6502)
Transfer Out to Fund 102 for 5 parcel land purchase.0 0 600,000 (600,000)
Transfer Out to Fund 102 for Main Street Signal Upgrade - TIP #21.0 0 150,000 (150,000)
Transfer Out to Fund 102 for AWS Pedestrian Improvements - CP1118.0 0 115,000 (115,000)
Transfer Out to Fund 102 for AWS & M Street Improvements - CP1024.0 0 112,632 (112,632)
Transfer Out to Fund 102 for A Street NW Extension Wetland Maintenance and Monitoring - C207A0.0 0 76,672 (76,672)
Transfer Out to Fund 328 for City Wetland Mitigation Projects - CP1315.0 0 30,868 (30,868)
Transfer Out to Fund 328 for Mohawks Plastic - CP0767.0 0 18,700 (18,700)
BA#7 Total 0 0 1,103,872 (1,103,872)
2014 Revised Budget 2,456,217 2,000,485 2,620,712 1,835,990
Total Resources / Expenditures 4,456,702 4,456,702
Municipal Park Construction Fund (#321)Beg. Fund Balance
2014
Revenues 2014 Expenditures Ending Fund Balance
2014 Adopted Budget 325,267 18,171,700 18,436,000 60,967
BA#6 (Ordinance #6474, 12.3.2013)45,000 (7,983,269)(7,915,500)(22,769)
BA#7 (Proposed Ordinance #6502)
0
Carryforward Projects:
Fenster Levee Setback, Phase 2; $51,683 Federal Grant; $24,200 Transfer-In from 0 75,883 75,883 0
Storm Fund - CP1016.
BA#7 Total 0 75,883 75,883 0
2014 Revised Budget 370,267 10,264,314 10,596,383 38,198
Total Resources / Expenditures 10,634,581 10,634,581
Capital Improvements Fund (#328)Beg. Fund Balance
2014
Revenues 2014 Expenditures Ending Fund Balance
2014 Adopted Budget 4,586,304 1,524,819 1,097,300 5,013,823
BA#6 (Ordinance #6474, 12.3.2013)1,625,319 1,615,790 6,544,408 (3,303,299)
BA#7 (Proposed Ordinance #6502)
Carryforward Projects:
Sidewalk Repair Project - CP1301 260,000 0 260,000 0
REET 2 Transfer-Out to F102 for 8th Street NE & 104th Ave SE Intersection Improvements - CP1104.119,000 0 119,000 0
City Hall Remodel - CP1303 101,022 0 101,022 0
Annual Traffic Signal Improvements - CP1322.94,500 0 94,500 0
8th Street NE ITS Improvements - CP1226.45,000 0 45,000 0
City Wetland Mitigation Projects; $30,868 Transfer-In from Fund 124 - CP1315.0 30,868 30,868 0
Public Art; funded by REET 2.22,000 0 22,000 0
REET 2 Transfer-Out to Fund 102 for Citywide Traffic Signal Safety Improvements - CP1222.20,684 0 20,684 0
Mohawks Plastics Wetland Mitigation; $18,700 Transfer-In from F124 - CP0767.0 18,700 18,700 0
New Requests:
Budget for the completion of improvements for the Marchini Meadows Development; $40,000 40,000 30,000 70,000 0
insurance settlement was receipted in 2013; $30,000 paid for by payback fees.
BA#7 Total 702,206 79,568 781,774 0
2014 Revised Budget 6,913,829 3,220,177 8,423,482 1,710,524
Total Resources / Expenditures 10,134,006 10,134,006
F:\Budget Directory\2014 Budget\BA#7 - Carry Forwards\Sched A & B\BA#7 - Sched A and B.xlsx Page 4
Schedule A
Summary of 2014 Budget Adjustments by Fund
Budget Amendment #7 Ordinance 6502
Water Fund (#430)Beg. Fund Balance
2014
Revenues 2014 Expenditures Ending Fund Balance
2014 Adopted Budget 6,618,981 13,562,749 16,516,114 3,665,616
BA#6 (Ordinance #6474, 12.3.2013)3,982,414 1,063,240 5,453,800 (408,146)
BA#7 (Proposed Ordinance #6502)
0
Carryforward Projects:0
Well 1 Improvements - CP0915 972,607 0 972,607 0
Fulmer Well field improvements - CP1107 866,157 0 866,157 0
Water Meter and Billing System improvements - CP1317 474,247 0 474,247 0
Academy Booster Pump Station - CP0909 472,116 0 472,116 0
D Street Utilities Improvements - CP1207 257,337 0 257,337 0
Valley AC Main Replacement - CP1219 230,746 0 230,746 0
Pipeline 5 Intertie - CP1103 202,807 0 202,807 0
SCADA System Improvements - C524A0 183,790 0 183,790 0
2013 Local Street Pavement Reconstruction - CP1224 137,513 0 137,513 0
Lakeland Hills Reservoir 6 - CP1106 116,592 0 116,592 0
Well 4 Power and Chlorination - C512A0 75,070 0 75,070 0
On Call Modeling (Carollo Engineers) 61,107 0 61,107 0
BNSF Utility Crossing - CP1308 48,644 0 48,644 0
Cost of Service Study Completion 36,219 0 36,219 0
Auburn Way South, Dogwood to Fir Street - CP1118 24,895 0 24,895 0
Lakeland Hills Reservoir 5 - CP0765 18,836 0 18,836 0
Utility Support Vehicle 15,000 0 15,000 0
New Requests:
M&O Expansion Project - CP1320. Consolidate funding to Storm utility.0 0 (220,000)220,000
Operating Transfer-Out to F432 for M&O Expansion Project - CP1320 0 0 220,000 (220,000)
BA#7 Total 4,193,683 0 4,193,683 0
2014 Revised Budget 14,795,078 14,625,989 26,163,597 3,257,470
Total Resources / Expenditures 29,421,067 29,421,067
Sewer Fund (#431)Beg. Fund Balance
2014
Revenues 2014 Expenditures Ending Fund Balance
2014 Adopted Budget 7,576,717 21,558,701 21,863,847 7,271,571
BA#6 (Ordinance #6474, 12.3.2013)0 (14,006,575)(13,911,530)(95,045)
BA#7 (Proposed Ordinance #6502)
0
Carryforward Projects:
Sewer Pump Station Improvements - CP1208 845,848 0 845,848 0
Auburn Way South Flooding, Phase 2 - CP1202 359,846 0 359,846 0
D Street Utility Improvements - CP1207 326,095 0 326,095 0
BNSF Utility Crossing Project - CP1308 305,560 0 305,560 0
SCADA System Improvements - C524A0 251,666 0 251,666 0
Sewer Repair/Replacement Improvements - Bud 431 120,502 0 120,502 0
Comprehensive Sewer Plan Update - Bud 431 75,000 0 75,000 0
Cost of Service Study Completion 18,110 0 18,110 0
New Requests:
M&O Expansion Project - CP1320. Consolidate funding to Storm utility.0 0 (470,000)470,000
Operating Transfer-Out to F432 for M&O Expansion Project - CP1320 0 0 470,000 (470,000)
Increase Project budget for BNSF Utility Crossing Project - CP1308.0 0 71,000 (71,000)
BA#7 Total 2,302,627 0 2,373,627 (71,000)
2014 Revised Budget 9,879,344 7,552,126 10,325,944 7,105,526
Total Resources / Expenditures 17,431,470 17,431,470
F:\Budget Directory\2014 Budget\BA#7 - Carry Forwards\Sched A & B\BA#7 - Sched A and B.xlsx Page 5
Schedule A
Summary of 2014 Budget Adjustments by Fund
Budget Amendment #7 Ordinance 6502
Storm Drainage Fund (#432)Beg. Fund Balance
2014
Revenues 2014 Expenditures Ending Fund Balance
2014 Adopted Budget 6,299,114 9,295,843 8,530,856 7,064,101
BA#6 (Ordinance #6474, 12.3.2013)4,482,588 (5,501)4,933,557 (456,470)
BA#7 (Proposed Ordinance #6502)
Carryforward Projects:
30th Street NE Area Flooding Phase 1 - CP1122 2,661,297 0 2,661,297 0
Mill Creek Wetland 5K Restoration Project - CP0746 725,450 0 725,450 0
East Ridge Manor Drainage Improvement Project - CP1316 577,900 0 577,900 0
D Street Utility Improvements - CP1207 540,077 0 540,077 0
Storm Repair and Replacement Project - CP1312 461,505 0 461,505 0
Citywide Storm Pond Cleaning - CP1108 378,627 0 378,627 0
Maintenance and Operations Storm Improvements - CP1320 301,729 0 301,729 0
Storm Pipeline Repair and Replacement Phase 2 - CP1109 242,040 0 242,040 0
Auburn Way South Flooding Improvement Phase 2 - CP1202 218,392 0 218,392 0
Hidden Valley Vista Storm Outfall Repair - EM1302 132,956 0 132,956 0
SCADA System Improvements - C5240A 101,489 0 101,489 0
BNRR Utility Crossing - CP1308 33,773 0 33,773 0
Transfer-Out to Fund 321 for Fenster Levee Setback - Phase 2 - CP1016.24,200 0 24,200 0
Control Structure Installation Project - CP1307 20,805 0 20,805 0
Cost of Service Study Completion 18,110 0 18,110 0
Utility Support Vehicle 15,000 0 15,000 0
New Requests:
Recognize Department of Ecology State Grant for M&O Expansion Project - CP1320 0 999,400 999,400 0
Operating Transfer-In from F430 and F431 for M&O Expansion Project - CP1320 0 690,000 690,000 0
BA#7 Total 6,453,350 1,689,400 8,142,750 0
2014 Revised Budget 17,235,052 10,979,742 21,607,163 6,607,631
Total Resources / Expenditures 28,214,794 28,214,794
Airport Fund (#435)Beg. Fund Balance
2014
Revenues 2014 Expenditures Ending Fund Balance
2014 Adopted Budget 544,152 808,380 867,903 484,629
BA#6 (Ordinance #6474, 12.3.2013)103,000 226,750 333,976 (4,226)
BA#7 (Proposed Ordinance #6502)
Carryforward Projects:
Airport Master Plan - CP1221 2,682 50,947 53,629 0
FAA share (90%); State DOT (5%); City (5%).
Airport Asphalt Rehabilitation - CP1324 4,223 80,228 84,451 0
FAA share (90%); State DOT (5%); City (5%).
Wildlife Hazard Assessment - CP1321 1,025 19,461 20,486 0
FAA share (90%); State DOT (5%); City (5%).
New Requests:
Adjust Airport fuel revenues to reflect change per Airport Management Contract.0 (16,380)0 (16,380)
BA#7 Total 7,930 134,256 158,566 (16,380)
2014 Revised Budget 655,082 1,169,386 1,360,445 464,023
Total Resources / Expenditures 1,824,468 1,824,468
F:\Budget Directory\2014 Budget\BA#7 - Carry Forwards\Sched A & B\BA#7 - Sched A and B.xlsx Page 6
Schedule A
Summary of 2014 Budget Adjustments by Fund
Budget Amendment #7 Ordinance 6502
Cemetery Fund (#436)Beg. Fund Balance
2014
Revenues 2014 Expenditures Ending Fund Balance
2014 Adopted Budget 58,852 1,049,010 1,024,384 83,478
BA#6 (Ordinance #6474, 12.3.2013)0 127,200 (82,995)210,195
BA#7 (Proposed Ordinance #6502)
New Requests:
Adjust Cemetery payment to Facilities fund to reflect actual cost of utilities (water, power, storm).0 0 50,000 (50,000)
BA#7 Total 0 0 50,000 (50,000)
2014 Revised Budget 58,852 1,176,210 991,389 243,673
Total Resources / Expenditures 1,235,062 1,235,062
Facilities Fund (#505)Beg. Fund Balance
2014
Revenues 2014 Expenditures Ending Fund Balance
2014 Adopted Budget 972,003 3,432,500 3,447,704 956,799
BA#6 (Ordinance #6474, 12.3.2013)0 17,675 49,686 (32,011)
BA#7 (Proposed Ordinance #6502)
Carryforward Projects:
Exterior Sealing Project at City Hall, including cleaning and pressure washing of the building 32,500 0 161,500 (129,000)
New Roof at M&O, Replace Carpet Extractor, and retainage for carpet replacement at the 62,800 0 62,800 0
Police Department.
New Requests:
Insurance settlement and project costs for R Street Property. 0 153,000 239,000 (86,000)
Required Electrical Code upgrade and repairs to the R Street Property.0 0 105,300 (105,300)
Interfund payment from Cemetery for actual cost of utilities (water, power, storm).0 50,000 0 50,000
BA#7 Total 95,300 203,000 568,600 (270,300)
2014 Revised Budget 1,067,303 3,653,175 4,065,990 654,488
Total Resources / Expenditures 4,720,478 4,720,478
Innovation and Technology Fund (#518)Beg. Fund Balance
2014
Revenues 2014 Expenditures Ending Fund Balance
2014 Adopted Budget 1,921,570 4,990,126 5,137,179 1,774,517
BA#6 (Ordinance #6474, 12.3.2013)0 210,295 338,876 (128,581)
BA#7 (Proposed Ordinance #6502)
Intergovernmental Revenues for IT support VRFA, City of Black Diamond, Algona, and Pacific.0 16,000 0 16,000
Carryforward Projects:
Citywide communications system hardware maintenance 220,000 0 220,000 0
Electronic Plan Review Program 80,000 0 80,000 0
Springbrook Upgrade to Version 7 65,000 0 65,000 0
CAD Replacement Project 60,000 0 60,000 0
Communications Systems Upgrade 58,000 0 58,000 0
Wireless Infrastructure Installation 50,000 0 50,000 0
Spillman Superforms 50,000 0 50,000 0
Police - Speech Recognition Software, payment from Police upon purchase of software 50,000 0 50,000 0
Records Management 34,000 0 34,000 0
CRW Upgrade 30,000 0 30,000 0
Infrastructure Installs 30,000 0 30,000 0
Automatic Vehicle Locator Project, payment from benefiting departments upon vehicle installations 30,000 0 30,000 0
Police - Software Security, payment from Police upon purchase of software 25,000 0 25,000 0
BA#7 Total 782,000 16,000 782,000 16,000
2014 Revised Budget 2,703,570 5,216,421 6,258,055 1,661,936
Total Resources / Expenditures 7,919,991 7,919,991
F:\Budget Directory\2014 Budget\BA#7 - Carry Forwards\Sched A & B\BA#7 - Sched A and B.xlsx Page 7
Schedule A
Summary of 2014 Budget Adjustments by Fund
Budget Amendment #7 Ordinance 6502
Equipment Rental Fund (#550)Beg. Fund Balance
2014
Revenues 2014 Expenditures Ending Fund Balance
2014 Adopted Budget 3,235,090 2,992,750 4,095,913 2,131,927
BA#6 (Ordinance #6474, 12.3.2013)0 50,000 80,759 (30,759)
BA#7 (Proposed Ordinance #6502)
Carryforward Projects:
Carryforward of Machinery and Equipment not purchased in 2013
Replace 1996 International 4700 4x2 Thermo Lay for Street Department - Unit #6426D 210,770 0 235,937 (25,167)
Replace 1994 International Dump Truck for Water Department - Unit #6506C 105,930 0 119,742 (13,812)
Replace 2004 Ford Super Duty 4x4 for Street Department - Unit #6402E 59,590 0 62,114 (2,524)
Replace 2001 Mitsubishi Flat Bed Dump Truck for Parks Department - Unit #6712C 53,180 0 56,709 (3,529)
Replace 2000 Ford F-450 Cab Chassis 4x2 for Parks Department - Unit #6713C 45,740 0 48,777 (3,037)
Replace 1998 Vermeer Brush Chipper for Parks Department - Unit #6770C 43,720 0 47,149 (3,429)
Replace 2002 Ford F-250 4x4 Super Cab for Sewer Department - Unit #6304E 41,670 0 44,219 (2,549)
Replace 2001 Dodge Ram 2500 Crew Cab 4x4 for Parks Department - Unit #6707D 37,300 0 40,099 (2,799)
Replace 2000 Dodge Ram Cargo Van for Engineering Department - Unit #6114C 26,830 0 28,607 (1,777)
Replace 2000 GMC Sonoma for Planning Department - Unit # 6215D 25,110 0 27,000 (1,890)
Replace 1994 Sullivan Portable Air Compressor for Street Department - Unit # 6472C 21,510 0 24,310 (2,800)
Replace 1997 Sullivan Portable Air Compressor for Water Department - Unit #6570D 19,680 0 21,907 (2,227)
Maintenance and Operations Vehicle Bay and Storage - CP0711 100,000 0 100,000 0
Maintenance and Operations Fuel Tank Replacement - CPxxxx 70,000 0 70,000 0
Utility Support Vehicle - Funded by Water and Storm Funds 0 30,000 30,000 0
New Requests:
Golf course equipment replacement funded by Transfer-In from Cumulative Reserve.0 250,000 250,000 0
Purchase of Asphalt Kettle for crack repair; to extend life of asphalt.0 0 54,770 (54,770)
Security camera system at Maintenance and Operations for facility and vehicle security.0 0 40,000 (40,000)
BA#7 Total 861,030 280,000 1,301,340 (160,310)
2014 Revised Budget 4,096,120 3,322,750 5,478,012 1,940,858
Total Resources / Expenditures 7,418,870 7,418,870
Grand Total - All Funds Beg. Fund Balance
2014
Revenues 2014 Expenditures Ending Fund Balance
2014 Adopted Budget 59,000,241 153,945,014 164,654,843 48,290,412
BA#6 (Ordinance #6474, 12.3.2013)17,748,977 5,231,042 20,436,667 2,543,352
BA#7 Total 17,953,027 8,207,522 28,581,209 (2,420,660)
2014 Revised Budget 94,702,245 167,383,578 213,672,719 48,413,104
Total Resources / Expenditures 262,085,823 262,085,823
February 25, 2014
Prepared by City of Auburn Financial Planning Department
F:\Budget Directory\2014 Budget\BA#7 - Carry Forwards\Sched A & B\BA#7 - Sched A and B.xlsx Page 8
Schedule B
2014 Appropriations by Fund
2014 Adopted BA#6 BA#7 Total 2014 Revised
Fund Budget (Ord 6474) (Ord 6502) Amendments Budget
General Fund (#001)58,864,112 10,286,516 124,120 10,410,636 69,274,748
Arterial Street Fund (#102)4,706,022 2,065,446 6,835,536 8,900,982 13,607,004
Local Street Fund (#103)1,718,320 493,800 701,060 1,194,860 2,913,180
Hotel Motel Fund (#104)165,431 - - - 165,431
Arterial Street Preservation Fund (#105)3,627,660 5,000 623,600 628,600 4,256,260
Drug Forfeiture Fund (#117)1,198,768 - - - 1,198,768
Housing and Community Development Grant Fund (#119)495,647 - - - 495,647
Recreation Trails Fund (#120)36,691 - - - 36,691
Business Improvement Area Fund (#121)76,720 - - - 76,720
Cumulative Reserve Fund (#122)5,703,796 2,000,000 - 2,000,000 7,703,796
Mitigation Fees Fund (#124)3,411,402 1,045,300 - 1,045,300 4,456,702
1998 Library Fund (#229)330,354 - - - 330,354
2010 Annex A&B Bond Debt Fund (#230)1,696,678 - - - 1,696,678
2010 C&D Local Revitalization Debt Fund (#231)598,520 - - - 598,520
LID Guarantee Fund (#249)34,688 - - - 34,688
LID #250 (#250)56,762 - - - 56,762
LID #350 (#275)7,246 - - - 7,246
Golf Course Debt Service Fund (#237)- 393,144 - 393,144 393,144
Municipal Park Construction Fund (#321)18,496,967 (7,938,269) 75,883 (7,862,386) 10,634,581
Capital Improvements Fund (#328)6,111,123 3,241,109 781,774 4,022,883 10,134,006
Golf Course Debt Service Fund (#417)393,144 (393,144) - (393,144) -
Water Fund (#430)20,181,730 5,045,654 4,193,683 9,239,337 29,421,067
Sewer Fund (#431)29,135,418 (14,006,575) 2,302,627 (11,703,948) 17,431,470
Storm Drainage Fund (#432)15,594,957 4,477,087 8,142,750 12,619,837 28,214,794
Sewer Metro Fund (#433)- 15,000,000 - 15,000,000 15,000,000
Solid Waste Fund (#434)12,659,266 1,087,595 - 1,087,595 13,746,861
Airport Fund (#435)1,352,532 329,750 142,186 471,936 1,824,468
Cemetery Fund (#436)1,107,862 127,200 - 127,200 1,235,062
Golf Course Fund (#437)1,612,564 (1,612,564) - (1,612,564) -
Insurance Fund (#501)1,784,479 - - - 1,784,479
Workers Compensation Self Insurance Fund (#503)- 840,000 - 840,000 840,000
Facilities Fund (#505)4,404,503 17,675 298,300 315,975 4,720,478
Innovation and Technology Fund (#518)6,911,696 210,295 798,000 1,008,295 7,919,991
Equipment Rental Fund (#550)6,227,840 50,000 1,141,030 1,191,030 7,418,870
Fire Pension Fund (#611)2,555,786 231,000 - 231,000 2,786,786
Cemetery Endowment Fund (#701)1,686,571 (16,000) - (16,000) 1,670,571
Total 212,945,255 22,980,019 26,160,549 49,140,568 262,085,823
February 25, 2014
Prepared by City of Auburn Financial Planning Department
page 9