5. 2017 budget discussion Staff Report Date of Meeting: August 3, 2016 To: City Council From: Neil Soltis, Administrator Re: 2017 budget – preliminary discussions The information provided is based on a series of assumptions with the net result being a baseline budget. A baseline budget represents the steady state of operations for each department. This reflects the resources required for a department to provide the same level of service in the current year, before any new priorities or funding requests. Specifically included are full year salary, benefits, and other normal operating expenses, (including an allocation for capital expenses). Salary expenses in the baseline include open positions for the year (positions that have been open for one year should not be included). Re-occurring overtime and other non-base compensation costs are included. The budgetary revenue and expenditure amounts used in the information presented are based on the 2016 budgeted, 2014 actual, 2015 actual and the 2017 - 2020 Capital Improvement Programs as adjusted for the factors that are included in the assumptions. The goals in order to move forward with the budget are the following 1. Get consensus on the assumptions to be used moving forward 2. Look at the impact on property taxes and expenditures in each Fund 3. Discuss the identified variables or changes to the steady state 4. Discuss other changes to the programs, activities, or services provided Based on this discussion, the budgetary information will be recast for further refinement at future meetings.
CITY OF SCANDIA2017 BUDGET ASSUMPTIONS AND VARIABLES
Pay structure - merit step increases for non-bargaining unit employees 2%
Pay structure - bargaining unit employees 2%
Mayor & Council wages increase based on Ordinance 156 2.5%
Health insurance - 10% increase - League recommendation is 10-15%: Proposed renewal increase ranges from 3-5% depending on age group and deductible increased from $1,500 to $1,750 6%
PERA contribution rates - no change in rate 0%
Social security & medicare - no change in rate 0%
Workers Compensation - League range 4 - 8% increase 8%
Assessor - contract + 200 additional building permits @ $10 /
League of Minnesota Cities dues increase 3%
Property insurance - League range 2 - 3% increase 3%
Liability Insurance - League 2% increase 3%
Auto damage & liability - League range 3 - 7% increase 3%
Xcel - electricity - appplied for 6.4% increase in 2016 and 1.7% in 2017 6.50%
Lakes Area Television support -12.00%
Building permits - no change from 2016 budget - $25,000 less than 2016 projectedContract with Sheriff Department - estimated increase 3.50%Wage allocations Administrator - 20% to PlanningPublic Works Director - 12.5% 201 systems, 5% uptown systemPublic Works staff - 10% 201 systems, 3% uptown systemPT Parks - 20% to Park Improvement fund for lighted ballfield maintenance
Transfer from General Fund to Local Road Improvement FundAudited 12/31/2015 unassigned fund balance 1,737,134$ Less 2016 transfer (347,724)$ 1,389,410$ Less: 50% of expenditures before transfer 876,184$ Transfer to Local road Improvement Fund 513,226$
ASSUMPTIONS
\\SERVER\SharedDocs\Departments\Finance\Budget\2017\assumptions.xlsx
2015 2016 2017Transfer to Local road Improvement Fund per Fund Balance Policy 335,932$ 347,724$ 523,200$
2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 Projected 2015 Budget 2016 budget 2017 ProposedFund balance - 12/31 $1,329,553 $1,594,415 $1,715,890 $1,746,587 $1,517,894 $1,523,793 $1,393,396 $1,198,113Revenue$1,999,526 $2,170,437 $2,070,197 $1,944,186 $1,778,614 $1,795,244 $1,748,439 $1,944,186Expenditures$1,923,649 $1,905,575 $1,948,722 $1,913,489 $2,007,307 $1,987,341 $2,101,630 $2,263,968
$-
$500,000
$1,000,000
$1,500,000
$2,000,000
$2,500,000
GENERAL FUND SUMMARY
2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 Projected 2015 budget 2016 Budget 2017 ProposedOther Financing Sources $4,569 $7,042 $- $- $- $- $- $-Other Income and Transfers in $34,606 $30,075 $40,369 $46,603 $19,000 $19,458 $14,000 $16,500Fines & Forfeitures $17,818 $11,534 $13,468 $12,711 $12,000 $12,000 $12,000 $12,000Charges for Service $242,431 $229,801 $230,767 $67,281 $62,267 $62,204 $69,048 $68,100Intergovernmental Services $18,918 $43,083 $53,530 $83,337 $49,700 $34,732 $42,146 $50,800Licenses and permits $54,657 $100,007 $90,704 $138,741 $115,700 $80,230 $91,295 $90,400Other Taxes $8,900 $14,414 $17,249 $38,864 $21,800 $21,802 $21,802 $21,800Property Taxes $1,601,493 $1,724,724 $1,633,710 $1,583,779 $1,498,147 $1,564,818 $1,498,148 $1,481,168
$-
$500,000
$1,000,000
$1,500,000
$2,000,000
$2,500,000
GENERAL FUND REVENUE SUMMARY
2014 2015 2016 2017Tax Levy for Local road Improvement Fund 127,704$ 345,000$ 581,142$ 580,000$
2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 Projected 2015 budget 2016 Budget 2017 ProposedEconomic Development Authority $1,000 $- $5,000 $2,500 $- $5,000Local Road Improvement $345,000 $581,142 $345,000 $581,142 $580,000Capital Improvement Fund $100,000 $91,296 $222,104 $30,000 $30,000 $30,000 $30,000 $30,000Debt Service Fund $351,564 $343,003 $327,506 $272,691 $148,582 $272,691 $148,582 $116,739General Fund $1,603,610 $1,736,775 $1,620,464 $1,569,818 $1,498,147 $1,564,818 $1,498,148 $1,481,168
$-
$500,000
$1,000,000
$1,500,000
$2,000,000
$2,500,000
TAX LEVY
2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 Projected 2015 budget 2016 Budget 2017 ProposedTransfers$80,000 $99,900 $300,000 $356,522 $347,724 $220,000 $347,724 $523,200Personal Service $524,440 $529,128 $559,416 $568,674 $607,000 $611,927 $619,021 $628,888Capital Outlay $76,806 $84,212 $4,716 $18,525 $12,800 $6,700 $13,000 $4,000Contractual Services $1,091,660 $1,014,750 $905,138 $895,284 $894,133 $954,683 $936,630 $921,980Materials & Supplies $161,816 $179,044 $179,526 $101,869 $145,650 $194,031 $185,255 $185,900
$-
$500,000
$1,000,000
$1,500,000
$2,000,000
$2,500,000
EXPENDITURE SUMMARY BY OBJECT
Public Works Expenditures includes the transfer to the Local Road Improvement Fund
2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 Projected 2015 budget 2016 Budget 2017 ProposedPublic works $731,967 $847,491 $1,055,613 $1,029,107 $1,125,324 $1,039,155 $1,197,153 $1,364,191Community Center $42,538 $36,808 $42,439 $37,759 $36,300 $39,480 $40,261 $38,100Parks & Recreation $48,045 $59,385 $59,802 $56,589 $53,300 $62,244 $60,879 $62,500Fire$273,150 $276,840 $258,138 $224,038 $221,215 $271,515 $232,959 $234,200Police$117,172 $116,384 $121,113 $115,642 $116,200 $120,989 $116,197 $120,500Planning & Building $296,202 $204,125 $71,066 $105,206 $94,900 $71,700 $96,206 $97,000Elections$6,035 $470 $5,827 $1,172 $6,150 $470 $6,150 $1,300City Council $17,949 $17,801 $18,406 $19,578 $26,500 $20,121 $26,976 $19,462Administration & Finance $401,664 $347,730 $316,393 $351,783 $327,418 $361,667 $324,849 $326,715
$-
$500,000
$1,000,000
$1,500,000
$2,000,000
$2,500,000
EXPENDITURE SUMMARY BY DEPARTMENT
CITY OF SCANDIA2017 BUDGET ASSUMPTIONS AND VARIABLES
ADMINISTRATIONOrdinance codification 9,000$
Website upgrade - provide for custom background and 3 sets of banners using Scandia images 3,000$ Data technology replacements and upgrades Purchase firewall appliance 2,200$ Replace switch with gigabit ethernet switch 2,500$ Replace 2011 Dell server 7,000$
PLANNING - COMPREHENSIVE PLAN UPDATE (SPLIT 80% 2017 / 20% 2018)Comprehensive Plan basic update - $40,000 32,000$ Update on major issues - $55,000 44,000$ Complete comprehensive plan update - $70,000 56,000$
PARKS & RECREATIONBike route signage - recommended by PRC 1,800$ Lilleskogen fill - recommended by PRC 2,000$ Lilleskogen - wetland restoration - $2,000 included in 2016 - 2020 CIP 3,500$
PUBLIC WORKSAdd 2 additional layers to GIS (culverts and guardrails)1,000$ Upgrade GIS to be able to view from mobile devices 2,000$ Purchase GPS capture device 11,000$ Add Asset management software 15,000$ Purchase used roller for patching 8,000$
PAY STRUCTUREModify base pay fromn levels established in 2013 - $1% increase = $1,600 ?
EDAAdd funding to match County predevelopment loan fund - recommended by EDA 5,000$
POTENTIAL ITEMS FOR ADDITIONAL FUNDING
\\SERVER\SharedDocs\Departments\Finance\Budget\2017\assumptions.xlsx
2015 2016 2016 2016 2017Actual6 months Projected Budget Budget
Revenues 146,067$ 15,253$ 34,647$ -$ 14,209$ Expenditures 390,188$ -$ -$ -$ 77,000$ Net Revenues (Expenditures) (244,121)$ 15,253$ 34,647$ -$ (62,791)$ Fund Balance - January 1 287,055$ 42,934$ 42,934$ 42,934$ 77,581$ Fund Balance - December 31 42,934$ 58,187$ 77,581$ 42,934$ 14,790$
Transfer special assessments to Local Road Improvement fund ($77,000)
Revenues 44,220$ -$ -$ 43,010$ -$ Expenditures 42,080$ 40,710$ 43,010$ 43,010$ 10,060$ Net Revenues (Expenditures) 2,140$ (40,710)$ (43,010)$ -$ (10,060)$ Fund Balance - January 1 50,930$ 53,070$ 53,070$ 53,070$ 10,060$ Fund Balane - December 31 53,070$ 12,360$ 10,060$ 53,070$ (0)$
Transfer balance to 2015 Fire Tanker Equipment Certificate ($10,060)
Revenues 33,946$ -$ 32,744$ 32,744$ -$ Expenditures 32,310$ 593$ 31,185$ 31,185$ 8,294$ Net Revenues (Expenditures) 1,636$ (593)$ 1,559$ 1,559$ (8,294)$ Fund Balance - January 1 5,099$ 5,099$ 6,735$ 6,735$ 8,294$ Fund Balane - December 31 6,735$ 4,507$ 8,294$ 8,294$ -$
Transfer balance to Equipment Replacement Fund ($8,294)
Revenues 69,352$ -$ 69,092$ 69,092$ 68,023$ Expenditures 66,515$ 61,330$ 65,883$ 65,823$ 65,063$ Net Revenues (Expenditures) 2,837$ (61,330)$ 3,209$ 3,269$ 2,960$ Fund Balance - January 1 7,684$ 7,684$ 10,521$ 10,521$ 13,790$ Fund Balance - December 31 10,521$ (53,646)$ 13,730$ 13,790$ 16,750$
Revenues -$ -$ 49,056$ 49,056$ 48,739$ Expenditures -$ 46,720$ 46,720$ 46,720$ 46,064$ Net Revenues (Expenditures) -$ (46,720)$ 2,336$ 2,336$ 2,675$ Fund Balance - January 1 -$ -$ -$ -$ 2,336$ Fund Balance - December 31 -$ (46,720)$ 2,336$ 2,336$ 5,011$
FUND BALANCE
2013 FIRE TRUCK/DUMP TRUCK EQUIPMENT CERTIFICATE (FUND 313)
2011DUMP TRUCK EQUIPMENT CERTIFICATES (FUND 312)
DEBT SERVICE (FUNDS 307 - 315)
2007 BLACKTOP (FUND 307)
2015 FIRE TANKER EQUIPMENT CERTIFICATE (FUND 315)
FUND BALANCE
FUND BALANCE
FUND BALANCE
2010 FIRE RESCUE TRUCK EQUIPMENT CERTIFICATES (FUND 311)
FUND BALANCE
CAPITAL IMPROVEMENTS (FUND 401)
2015 2016 2016 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025Actual6 months Projected Budget Proposed Proposed Proposed Proposed Proposed Proposed Proposed Proposed Proposed
Revenue 30,967$ -$ 66,000$ 50,700$ 130,000$ 30,000$ 30,000$ 30,000$ -$ -$ -$ -$ -$
Expenditures 10,375$ 2,370$ 55,000$ 40,000$ 200,000$ -$ 100,000$ 30,000$ -$ -$ -$ -$ -$
Net Revenues (Expenditures)20,592$ (2,370)$ 11,000$ 10,700$ (70,000)$ 30,000$ (70,000)$ -$ -$ -$ -$ -$ -$
Balance January 1 335,466$ 335,466$ 356,058$ 254,165$ 367,058$ 297,058$ 327,058$ 257,058$ 257,058$ 257,058$ 257,058$ 257,058$ 257,058$
Balance December 31 356,058$ 333,096$ 367,058$ 264,865$ 297,058$ 327,058$ 257,058$ 257,058$ 257,058$ 257,058$ 257,058$ 257,058$ 257,058$
Interfund Loan from (to) Park Capital Fund (35,000)$ 6,000$ 6,000$ 6,000$ 6,000$ 6,000$ 6,000$ 5,000$ Advance from (to) 201 Sewer Fund 2,639$ 2,639$ 2,639$ 2,639$ 2,639$ 2,639$ 2,639$ 2,639$ 2,639$ 2,639$ 2,639$ 2,639$
CASH BALANCE 12/31 289,389$ 309,028$ 308,728$ 247,667$ 286,306$ 224,945$ 233,585$ 241,224$ 243,863$ 246,502$ 249,141$ 251,781$
Fire Roof replacement 100,000$ Warning sirens 30,000$
Log House LandingBoat ramp 55,000$ 40,000$ 205th Street - bound aggregate improvement 200,000$ -$ 55,000$ 40,000$ 200,000$ -$ 100,000$ 30,000$ -$ -$ -$ -$ -$
FUND BALANCE
EXPENDITURES BY DEPARTMENT
PARK CAPITAL IMPROVEMENTS (FUND 404)
2015 2016 2016 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025AccountDescriptionActual6 months Projected Budget Proposed Proposed Proposed Proposed Proposed Proposed Proposed Proposed Proposed
Revenue 26,393$ 5,220$ 8,450$ 33,720$ 43,900$ 18,700$ 8,700$ 48,700$ 8,700$ 8,700$ 8,700$ 8,700$ 8,700$
Expenditures 47,273$ -$ 8,000$ 32,500$ 35,200$ 10,000$ -$ 40,000$ -$ -$ -$ -$ -$
Net Revenues (Expenditures)(20,879)$ 5,220$ 450$ 1,220$ 8,700$ 8,700$ 8,700$ 8,700$ 8,700$ 8,700$ 8,700$ 8,700$ 8,700$
Balance January 1 1,067$ (19,812)$ (19,812)$ (18,592)$ (9,892)$ (1,192)$ 7,508$ 16,208$ 24,908$ 33,608$ 33,608$ 42,308$
Balance December 31 (19,812)$ (19,362)$ (18,592)$ (9,892)$ (1,192)$ 7,508$ 16,208$ 24,908$ 33,608$ 42,308$ 42,308$ 51,008$
Advance from (to) Capital Improvement fund 35,000$ (6,000)$ (6,000)$ (6,000)$ (6,000)$ (6,000)$ (6,000)$ (5,000)$
CASH BALANCE 12/31 15,188$ 9,638$ 10,408$ 12,338$ 15,038$ 17,738$ 20,438$ 24,138$ 32,838$ 41,538$ 50,238$ 58,938$
Undesignated Revenue 27$ 27$ 50$ 20$ -$ -$ -$ -$ -$ -$ -$ -$ -$ ExpenditureNet 27$ 27$ 50$ 20$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Balance 1/1 10,582$ (1,837)$ (1,837)$ (1,837)$ (1,787)$ (1,787)$ (1,787)$ (1,787)$ (1,787)$ (1,787)$ Transfer (12,446)$ Balance 12/31 (1,837)$ (1,810)$ (1,787)$ (1,817)$ (1,787)$ (1,787)$ (1,787)$ (1,787)$ (1,787)$ (1,787)$ -$ -$ -$
LilleskogenRevenue 12,617$ 3,093$ 6,000$ 31,000$ 41,200$ 16,000$ 6,000$ 46,000$ 6,000$ 6,000$ 6,000$ Expenditure (47,273)$ -$ (25,000)$ (35,200)$ (10,000)$ -$ (40,000)$ -$ -$ Net (34,656)$ 3,093$ 6,000$ 6,000$ 6,000$ 6,000$ 6,000$ 6,000$ 6,000$ 6,000$ 6,000$ -$ -$ Balance 1/1 (11,379)$ (31,000)$ (31,000)$ (31,000)$ (25,000)$ (19,000)$ (13,000)$ (7,000)$ (1,000)$ 5,000$ 11,000$ 17,000$ 17,000$ Transfer 15,035$ Balance 12/31 (31,000)$ (27,907)$ (25,000)$ (25,000)$ (19,000)$ (13,000)$ (7,000)$ (1,000)$ 5,000$ 11,000$ 17,000$ 17,000$ 17,000$
Wayne JohnsonRevenue 2,400$ 2,100$ 2,400$ 2,700$ 2,700$ 2,700$ 2,700$ 2,700$ 2,700$ 2,700$ 2,700$ 2,700$ 2,700$ Expenditure (8,000)$ (7,500)$ (2,200)$ Net 2,400$ 2,100$ (5,600)$ (4,800)$ 500$ 2,700$ 2,700$ 2,700$ 2,700$ 2,700$ 2,700$ 2,700$ 2,700$ Balance 1/1 -$ 13,025$ 13,025$ 13,025$ 7,425$ 7,925$ 10,625$ 13,325$ 16,025$ 18,725$ 21,425$ 24,125$ 26,825$ Transfer 10,625$ Balance 12/31 13,025$ 15,125$ 7,425$ 8,225$ 7,925$ 10,625$ 13,325$ 16,025$ 18,725$ 21,425$ 24,125$ 26,825$ 29,525$
LilleskogenParking lot 47,273$ Picnic shelter -$ 25,000$ 25,000$ Woodland plantings and fencing 1,200$ entrance signs 5,000$ Park benches 4,000$ Boardwalks 5,000$ Interpretive sign & kiosk 5,000$ 47,273$ -$ -$ 25,000$ 35,200$ 10,000$ -$ -$ -$ -$ -$ -$ -$
Wayne JohnsonBleacher improvements 8,000$ 8,000$ -$ -$ 8,000$ 8,000$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Skating rinkZamboni replacement 40,000$ -$ -$ -$ -$ -$ -$ -$ 40,000$ -$ -$ -$ -$ -$
Tennis court replacement 60,000$ Lilleskogen - wetland restoration 2,000$ 1,800$ 5,800$ 2,000$ 1,500$ 1,000$
-$ -$ 2,000$ 61,800$ 5,800$ 2,000$ 1,500$ 1,000$ -$ -$ -$
GENERAL FUND PARKS CAPITAL IMPROVEMENT PROJECTS
FUND BALANCE
FUND DESIGNATIONS
IMPROVEMENTS BY LOCATION
EQUIPMENT REPLACEMENT (FUND 406)
2015 2016 2016 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025AccountDescriptionActual6 months Projected Adopted Proposed Proposed Proposed Proposed Proposed Proposed Proposed Proposed Proposed
Revenue 236,523$ 29,195$ 29,650$ 206,000$ 209,294$ -$ -$ -$ -$ 200,000$ 250,000$ -$ 700,000$
Expenditures 216,938$ -$ 115,000$ 315,000$ 310,000$ 130,500$ 87,000$ -$ 25,500$ 240,000$ 250,000$ 67,500$ 700,000$
Net Revenues (Expenditures)19,585$ 29,195$ (85,350)$ (109,000)$ (100,706)$ (130,500)$ (87,000)$ -$ (25,500)$ (40,000)$ -$ (67,500)$ -$
Balance January 1 451,023$ 451,023$ 470,608$ 470,608$ 385,258$ 284,552$ 154,052$ 67,052$ 67,052$ 41,552$ 1,552$ 1,552$ (65,948)$
Balance December 31 470,608$ 480,218$ 385,258$ 361,608$ 284,552$ 154,052$ 67,052$ 67,052$ 41,552$ 1,552$ 1,552$ (65,948)$ (65,948)$
Public WorksReplace 2002 Sterling dump truck & plow -$ -$ 200,000$ 200,000$ Replace 2009 John Deere 1445 mower w broom & blower 25,000$ Replace 2008 Ford F350 + plow 30,000$ Replace 2008 Ford Ranger 25,500$ Replace 2010 Tiger ditch rear mower 15,000$ Replace 2011 Tiger ditch boom mower 12,000$ Replace 1999 John Deere 6410 Tractor 60,000$ Replace 2011 Ford F250 + plow 25,500$ Replace 2012 New Holland skid loader and trailer 200,000$ Replace 2011 Mack dump truck & plow 40,000$ Replace 2009 John Deere 1445 mower w broom & blower 25,000$ Replace Tiger ditch rear mower 15,000$ Replace Tiger ditch boom mower 12,000$ Replace patching equipment 15,500$
Fire SCBA & Masks -$ 98,000$ 98,000$ SCBA Air Compressor -$ 17,000$ 17,000$ Replace 1995 Ford - Grass Rig #5175 -$ 85,000$ Radio replacement 75,000$ Replace 2003 Peterbuilt Tanker - #5178 250,000$ Replace engine on 2000 Pumper truck - #5176 700,000$
-$ 115,000$ 315,000$ 310,000$ 130,500$ 87,000$ -$ 25,500$ 240,000$ 250,000$ 67,500$ 700,000$
FUND BALANCE SUMMARY
EXPENDITURES BY DEPARTMENT
LOCAL ROAD IMPROVEMENT (FUND 408)
2014 2015 2016 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025AccountDescriptionActualActualProjectedBudgetProposedProposedProposedProposedProposedProposedProposedProposedProposed
Revenue 328,137$ 703,246$ 950,366$ 949,366$ 1,180,700$ 594,700$ 580,500$ 580,500$ 580,500$ 580,500$ 580,500$ 580,000$ 580,000$
Expenditures -$ 628,427$ 1,140,000$ 1,250,000$ -$ 800,000$ -$ 925,000$ -$ 1,050,000$ -$ 700,000$ -$
Net Revenues (Expenditures)328,137$ 74,819$ (189,634)$ (300,634)$ 1,180,700$ (205,300)$ 580,500$ (344,500)$ 580,500$ (469,500)$ 580,500$ (120,000)$ 580,000$
Balance January 1 -$ 328,137$ 402,956$ 327,704$ 213,322$ 1,394,022$ 1,188,722$ 1,769,222$ 1,424,722$ 2,005,222$ 1,535,722$ 2,116,222$ 1,996,222$
Balance December 31 328,137$ 402,956$ 213,322$ 27,070$ 1,394,022$ 1,188,722$ 1,769,222$ 1,424,722$ 2,005,222$ 1,535,722$ 2,116,222$ 1,996,222$ 2,576,222$
236th, 237th Novak & Oldfield Old Marine Trail 199th & Parkview 202nd, Orwell & Orwell Ct.228th & Mallard
NOTES Transfer in balance from 2007 blacktop Special Assessments 77,000$ 14,200$ Transfer from General Fund per fund balance policy 325,173$ 347,724$ 347,724$ 523,200$
FUND BALANCE SUMMARY
2018 ($165,000)2019 ($215,000)2020 ($215,000)
2017 ($205,000)2016 ($175,000)
240th ST. N.
BIG
M A N N I N G
T R .
N .
LAKEMARINE
M
AY
BE
R
R
Y
TR
AIL
MA
X
W
I
L
L
A
V
E
.
O L I N D A T R A I L
STATE HWY. 97
CO
.
R
D
.
1
5
OAKHILLRD.
L
O
F
T
O
N
A
V
E
.
N
.
H W Y .
9 5
CO.RD.52
ST
.
C
R
O
I
X
R
I
V
E
R
C .S .A .H .
3
H W Y .9 5
220th ST.
R A I L R O A D
ST
.
C
R
O
I
X
R
I
V
E
R
R A I L R O A D
LAKE
MANNING
WHITE
LAKEROCK
LAKEBONE
NIELSENLAKE
LAKE
GERMAN
LAKE
SYLVAN
LAKESEA
LAKEGOOSE
LAKE
FISH
B
A
Y
M
A
RIN
E LAKE
LONG
LAKE
HAY
LAKE
SAND
LA
K
E
AL
I
C
E
240th ST. N. 240th ST. N.
230th ST.N.
SCANDIA TR. N.SCANDIA TR. N.
SCANDIA TR. N.
STATE HWY. 97
STATE HWY. 97
L
O
F
T
O
N
A
V
E
.
N
.
KI
R
K
AV
E
.
KI
R
K
A
V
E
.
220thST. N.
CO
.
R
D
.
1
5
C.
S
.
A
.
H
.
1
M A N N I N G
T R .
N .
238th ST. N.
M
E
L
A
NIE
T
R.
N.
228th ST. N.
MA
L
L
A
R
D
AV
E
.
M
E A
D O
W
B R
O
O
K
A V E
.
N .
230th ST. N.
236thST. N.
OAKHILLRD.
M
O
R G A N
A
V E .
N .
236th ST. N.
ST. N.
237th
N O V A K A V E .N .
N
O L
A
N
A
V E .
N .
O
L D F I
E L
D
A V
E .
N .
ORENRD.N.
O L D F I E L D
A V E .
N .
ST
.
C
R
O
I
X
T
R
.
N
.
S T .C R O I X T R .N .
OAKHILLRD.N.
O X B O R O A V E .N .
2 0 2 n d S T .N.
O
R
W
E
L
L
A
V
E.
N.
197th ST.
O R W E L L C T .
OLD
MARIN
E TR. N.
OL
I
N
D
A
T
R
.
N
.
C.
S
.
A
.
H
3
188thST.N.
N O R E L L
A V E .N .
182nd ST.N.181st ST.N.
MAPLE ST.M A R G O
A V E .N .
NE W G A T E A V E . N .
185th ST. N.OA
K
G
R
E
E
N
AV
E
.
N
.
C .S .A .H .3
OL
D
M
A
R
I
N
E
T
R
.
N
.
A
V
E
.
N
.
P
A
R
A
D
E
OLD MARINETR.N.
QU
A
N
T
A
V
E
.
N
.
CO. RD. 4OSTRUM TR.
L A K A M A G A TRAILN.
L A K A M A G A
196th ST. N.
T R A I L
20
5
t
h
ST. N.
CO. RD. 50192nd ST. N.
M
E A
D O
W
B R
O
O
K
A V E .
N .
MAYBERRY TRAIL 2 0 5 t h S T .N .
195th ST. N.
2 0 9 T H
CITY HALL
P O M R O Y
A V E .
N .
P E A B O D Y
T R .
N .
PILARRD.N.
PILARRD. N.
N
O
LA
N
A
VE.N.
OZ
A
R
K
A
V
E
199th ST N
P A R K V I E W L N
218th ST. N.
2 3 9 t h S T .N .
NO
V
A
K
A
V
E
.
N
.
PO
M
R
O
Y
AV
E
N
U
E
N
.
PI
C
K
E
T
T
AV
E
N
U
E
N
.
PR
I
M
R
O
S
E
LA
N
E
N
.
MANNINGTR, CT, CR
228th ST. N.
191st ST. N.
185th ST. N.
202nd ST. N.
KI
R
B
Y
A
V
E
.
N
.
213thST.N.
215th ST. N.
216th ST. N.
217th ST. N.
PE
N
R
O
S
E
AV
E
N
U
E
N
.
215th ST N.
PE
N
N
F
I
E
L
D
AV
E
.
N
.
PA
RR
ISH
RO
AD
N.
O L I N D A L N .N .
209th ST. N.
O
D
E
L
L
MEADOWBROOK CIR.
P A R I S A V E
O D E L L C T
N
E
W
B
E
R
R
Y
AVE
NB.CT.
K I R K C T .
207th ST. N.
KI
R
K
L
A
N
G
L
E
Y
180th ST. N.
OZARKCT
209THST.N.
O
R E N
2 13th
2 14thOLAND
A V E
O
L G I
L V I
E
A
V E .
N .
223rd
P E R K IN
S
A V E
2 0 9 t h S T NQU
A
D
R
A
N
T
AV
E
.
N
.
QUALITYTR.
20
5
t
h
C
T
.
1 9 7 t h S T N
OX
B
O
R
O
L
N
O S T R U M
P A R K V I E W A V E .
197th
LOFTONCT.
O R L O D R .
238th ST. N.
235th ST. N.
AVE.N
OXBORO CIR.
213TH
Q U I N E L L
A V E .
N .
232nd ST. N.
190th189th
L A R K S P U R A V E .N
L A Y T O N A V E .N
1 8 7 t hL
A
M
A
R
192nd
186th
QU
E
N
T
I
N
A
V
E
.
N
.
QU
A
R
R
Y
A
V
E
.
N
.
235thST. N.
M
E
A
D
O
W
R
I
D
G
E
C
I
R
C
L
E
TRAILLANE
M
E
A
D
O
W
R
I
D
G
E
S T .N .O A K H I L L
C T .N .97
COUNTY
97 97 95
95
95
COUNTY
COUNTY
COUNTY
COUNTY
COUNTY
COUNTY
COUNTY
COUNTY
COUNTY
COUNTY
COUNTY
K H I L L L
C C T N
202020222024
20182016
2018
2022
2020 2024
2016
2021 ($75,000) (QUINNELL AVE, 236TH, 237TH, NOVAK)2022 ($125,000)NEED TO PLAN IMPROVEMENTS
20262028
2028
2026
SEAL COAT
Bolton & Menk, Inc. 2015, All Rights ReservedcH:\SCND\_Mapping\Maps\Streets\DWG\Scandia_CIP_Map.dwg 8/18/2015 2:31:01 PM CHASKA, MN RAMSEY, MN MAPLEWOOD, MN BAXTER, MN ROCHESTER, MNMANKATO, MN FAIRMONT, MN SLEEPY EYE, MN BURNSVILLE, MN WILLMAR, MN
AMES, IA SPENCER, IA DES MOINES, IA FARGO, ND FIGURE NO. 1AUGUST, 2015
FEETSCALE
0 36001800HORZ.
CAPITAL IMPROVEMENT PLAN - STREETSCITY OF SCANDIA, MINNESOTA
RECONSTRUCT
201 SEWER SYSTEMS
2015 2016 2016 2015 2016 2017 2018 2019 2020 2021 2022AccountDescriptionActual6-months Projected Adopted Adopted Proposed Proposed Proposed Proposed Proposed Proposed
Revenue 75,095$ 28,657$ 77,200$ 74,550$ 74,550$ 74,550$ 74,550$ 74,550$ 74,550$ 74,551$ 74,552$
Expenditures 101,178$ 29,156$ 88,116$ 62,170$ 81,254$ 101,511$ 101,511$ 107,911$ 100,911$ 100,911$ 100,911$
Net Revenues (Expenditures)(26,082)$ (500)$ (10,916)$ 12,380$ (6,704)$ (26,961)$ (26,961)$ (33,361)$ (26,361)$ (26,360)$ (26,359)$
Add Depreciation 33,785$ 33,786$ 33,786$ 30,200$ 35,000$ 35,000$ 35,000$ 35,000$ 35,000$ 35,000$ Less Capitalized expenditures (102,650)$ -$ -$ -$ -$ (65,500)$ -$ -$ -$ -$ (700,000)$ Cash Flow (94,947)$ 33,287$ 22,871$ 12,380$ 23,496$ (57,461)$ 8,039$ 1,639$ 8,639$ 8,640$ (691,359)$
Balance January 1 923,227$ 923,227$ 897,145$ 923,227$ 897,145$ 886,229$ 859,269$ 832,308$ 798,948$ 772,587$ 746,228$
Balance December 31 897,145$ 922,728$ 886,229$ 947,988$ 890,441$ 859,269$ 832,308$ 798,948$ 772,587$ 746,228$ 719,869$
Cash balance - December 31 51,185$ 74,056$ 74,681$ 16,595$ 24,634$ 26,274$ 34,913$ 43,554$ (647,805)$
Anderson / EricksonDrainfield 47,459$ 200,000$
Bliss Lift station control upgrades 47,459$ Lift statino antenna 7,732$ Bliss Lift Station 1 - control panel 27,500$ Bliss Lift Station 2 - control panel 27,500$ Bliss Lift Station 2 - pump 1 5,250$ Bliss Lift Station 2 - pump 2 5,250$ Nitrate treatment 500,000$ 102,650$ -$ -$ -$ -$ 65,500$ -$ -$ -$ -$ 700,000$
FUND BALANCE SUMMARY
CAPITAL EXPENDITURES
UPTOWN SEWER SYSTEM (FUND 612)
2015 2016 2016 2015 2016 2017 2018 2019 2020 2021 2022Actual6 months Projected Budget Budget Proposed Proposed Proposed Proposed Proposed Proposed
Revenue 18,183$ 4,735$ 18,200$ 19,717$ 18,000$ 18,000$ 18,000$ 18,000$ 18,000$ 18,000$ 18,000$
Expenditures 16,820$ 8,306$ 18,301$ 19,323$ 15,969$ 20,418$ 20,400$ 20,400$ 20,400$ 20,400$ 20,400$
Net Revenues (Expenditures)1,362$ (3,571)$ (101)$ 394$ 2,031$ (2,418)$ (2,400)$ (2,400)$ (2,400)$ (2,400)$ (2,400)$
Add Depreciation 4,876$ 4,876$ 4,876$ 4,876$ 4,876$ 4,876$ 4,876$ 4,876$ 4,876$ 4,876$ 4,876$ Less Loan repayment to Capital Imp Fund (2,639)$ (2,639)$ (2,639)$ (2,639)$ (2,639)$ (2,639)$ (2,639)$ (2,639)$ (2,639)$ Less Capitalized expenditures -$ -$ -$ -$ -$ (500)$ -$ -$ (500)$ -$ (4,900)$ Cash Flow 3,599$ 1,305$ 4,775$ 2,631$ 4,268$ (681)$ (163)$ (163)$ (663)$ (163)$ (5,063)$
Balance January 1 155,188$ 166,189$ 162,386$ 155,188$ 162,386$ 171,937$ 170,575$ 170,249$ 169,923$ 168,598$ 168,272$
Balance December 31 162,386$ 168,799$ 171,937$ 160,450$ 170,922$ 170,575$ 170,249$ 169,923$ 168,598$ 168,272$ 158,146$
Cash balance (144)$ 4,631$ 1,887$ 3,950$ (163)$ 1,724$ 3,287$ (326)$ (3,339)$
Drainfield blower 500$ 500$ 500$ Replace Uptown pump 1 1,100$ Replace Uptown pump 2 1,100$ Replace Drainfield pump 1 1,100$ Replace Drainfield pump 2 1,100$ -$ -$ -$ -$ -$ 500$ -$ -$ 500$ -$ 4,900$
FUND BALANCE SUMMARY
CAPITAL EXPENDITURES
ECONOMIC DEVELOPMENT AUTHORITY
2015 2016 2015 2016 2017AccountDescriptionActualProjectedAdoptedAdoptedProposed
Revenue 5,001$ -$ 5,000$ -$ -$
Expenditures 365$ 325$ 5,000$ 500$ 500$
Net Revenues (Expenditures)4,636$ (325)$ -$ (500)$ (500)$
Balance January 1 760$ 5,396$ 5,071$
Balance December 31 5,396$ 5,071$ -$ (500)$ 4,571$
FUND BALANCE