HomeMy WebLinkAbout11-13-2018 Worksession Packet 0
City of Oak Park Heights Worksession
Date: Tuesday, November 13, 2018
Time: 5:00 PM
Location: Oak Park Heights City Hall
1. Call to Order
2. 2019 Budget Discussion—Xcel Energy Property Value Change
3. Financial Impacts Discussion—Future Xcel Energy King Plant Closure
4. Adjourn
Page 1 of 40
THIS PAGE INTENTIONALLY LEFT BLANK
Page 2 of 40
4«i r
City of Oak Park Heights Page 1 of 1
14168 Oak Park Blvd. N•Oak Park heights,MN 55082•Phone(651)439-4439•Fax(651)439-0574
11-8-18
TO: Mayor and City Co ci1� em rs
FROM: Eric Johnson,,fa Ad ni
RE: Worksession /13/18
Enclosed please find two sets f docume rela d to the planned Worksession items.
1. Memo from Betty Caruso discussing budget options relating to the Xcel Energy(&Menards)
property tax reductions including possible options.
2. The Council did continue its Worksession to discuss the issues related to the future financial
impacts being discussed and studied for the Xcel Allen S. King Plant Closure.The Mayor has
provided further documentation and plans to provide further updates.
Page 3 of 40
CITY OF OAK PARK HEI
Memoo,",.
To: Mayor and Council
From: Betty Caruso,Finance Director
Date: November 13,2018
Re: Response to 2019 Budget Work Session—Xcel Value Change
As we know, the City's estimated tax capacity value of$10,028,799 was adjusted to an
estimated $9,607,727 due to valuation reductions of$393,072 for Xcel and $28,552 for
Menards. If the City desires to maintain the currently proposed Budget Levy of
$5,280,246 this will necessitate an increase in the tax rate from 49.949% to 52.117%.
The results of this reduced valuation to Xcel and Menards (shifts) the tax burden to
residential property taxes by 3.2%to 6.4%or$23 to $64 per residence based of the value
of the property.
The taxpayers have been notified with the TNT notice that they will have a $0.00
increase or a possible reduction in taxes based on the information that was available at
the time the City adopted its preliminary budget, therefore in order to deal with real
possibility of the property taxes increasing we need to address the 2019 budget and how
to proceed.
We have essentially two options:
Option 1) Adopt the preliminary budget as is and inform the taxpayers (at TNT
hearing and/or special notices) of the unexpected increase in their taxes.
Option 2) Adjust the budget to reflect a $0.00 increase which would require
adjustments of approximately $200,000 in other revenue sources or reduction in
expenditures.
While neither option is ideal as funding will likely need to be made up in future
years- especially related to road reconstruction --- Staff would recommend Option 2
and can be accomplished by:
SUMMARY OF GENERAL FUND EXPENDITURES
After review of all expenditures again an additional $23,834 was decreased. These were
not immaterial to the departments,but could be done. See Attachment#1.
PROPOSED USES OF 2017 FUND BALANCE
In order to meet the$200,000 loss in tax revenue a portion of the 2017 Fund Balance
could also be utilized to balance the 2019 budget. This amount is $176,166. See
Attachment#2.
TRANSFERS FOR CAPITAL PROJECTS
Transfers can be reviewed for possible reductions. These amounts are the larger budget
items and can have an impact on future funding of projects. See Attachments 3 &4
Page 4 of 40
a
!Z2 vNi H N N - N N N N N N N N W W N 0 Ol y 0/ N N y N d d
07 10 10 0) 10 A
2 a`LU 10 f�i T ` w a 2 2 T E E 2 v v a v a v y a w v M w M v
-10 c � c .o c c s o � 5 c c 10 a c c c o
V
IR
mcoo0m °0rnm a $ m to
to
0f0 foO Ov -1SW aonoID
%6 t0 MO Ol 00
L9 cq g00
0V O r00 .i NN 4010O4 NO 0
WSLn
Q O O O(J p O
Q cn
O
V}Vf V!V1 V?i^Vf V)Vn V}V!to V1 V1 V)OF V1 in 4/1 V!V1 V1 V�V).In.V)
pp pp �p7 Co N
n 0 LD Goo O S N S .-I O O N N N lnp C1 0 0�0 O t00 14 0 R 00
z Opp 0ppp co
O1 N lm0 Ian M l�0 N M N O N b 0000 1l1 t00 M N rn Goo N l00 00
W N N N N v N In N
~ VI
FF V1•V}V}VF in N VY VF V}V)V)V!u?VF V)V)V! V}V}V} V1 V!H in
oo
F W '� n S s} W M l0 O N O M S ti V�1 N lN0 lnp O O 00 O fYl M 0 N
n
yNj N a 00 N O O m l0 Ln 00 W rl VI Ol n M H "V M n N m n uj l0 �
N m N M 'n-1 N CT M 4D N CV) N 0 1Nn N 00 .moi l0 m N 00 .i to N
W N .i LD m
NLn
L
Vf VT to to N V1 V?in in to VF OF V)in V)V}N V1 V}V?V}V}in in V)to VY
rel a N n N 0w1 N N N n In .i 00 N .-1 N N � m O 0) M 00 M M l0 H
S v O n w N M V n -e 0 In W w n M n W N
p Q 01 O N "V N N N N M N l0 W In l0 W N Q7 m n 00 00 .i n 00 H
O 00 N "V N O .-1 m ti Y'1 Vj l0 n O N N uj N 01 M )O !M1
n CO N N n M M O N N .i 00 OD 91 N Ln �} 00 ID
1L M N N N O N N14 14
0C 14 Q N N
F ~ to n V) in vv 0 Ln V?VS Vf Vr V)V) in In t4 i/! v*V)V)v�V1 iA N a
O o n O n o 01 O S N O S O .a-i n S N m n 0 Ln 0 S Ln D1 0 0 Ln 8 N
z u'1 lD O N to O7 n 0 C ul O 10 n 0 lD lD lD S lD 00 O S rn O M 00
W Iv1
a
01 e O n e N n V a try H O 00 M n N N V1 N O Ln V1 n O Ln i ti
W �,,,� 17 O nW1 M .0i N V M N N M M O V In O In n M .i co .� 01 p O
p O O N e} N N N N N n
00
z N m ~ ~ N m
LL }
Q V)V).V).V).V!V1 t/T V)N VT V!V) t/1 N t6 VF V1 _Z
V!V)V) V) V) V1 V)V)V}
N
W M M Oo n O O0 O O n (1 10 V N M N O N n 00 M 1!1 n to L0 0)
z n M O Ol In l0 01 l0 O 01 M V1 n V� M 00 ei N N M M N N 01 rl 00 L w
W .�1 ID N O0 M l0 00 n 00 n O N N n 01 N 01 M d' e? 1p n 01 00 n 01 00 a
0 N Q Ol n N q a? ~ 001 f1 1 PN
fl 000 N m N 0) (nl 9 N )0D N LD M O QI'm C4 N .mt
0 en
L4
M N .i N N N p N
tlr+n to v)vl w v) in vs in I^in in v)v!v*v1 v)v)v!v>in v}to
O n 10 v 0) 01 a 10 0) 0o m ID Ol In n n 00 M 01 N 0 v1 V' M 00
`�' n n .i .i m N v n kD n rn m V1 m m n rn n m m m m m 1D o n1
.i 111 N M .ti O n N N 0 W O 00 01 u) N W PI N It n N n 0 00
p 10 00 01 l0 l0 cn m V1 N M n V n 00 Vj n M Vl M N 00
a
? Op 10 N ID O1 m N 11) N N N O1 00 m V1 m l0 m O ID O
M U M N N N N N V]
N Q .i N N
N
V}Vi•V)V!V)V?V1•V1 V)to V!N Vf V)V} to VF VF VF N VT V1 V) V1 to V? N
� W
2 ()
o a o In
F w Q Z O IOi
z V] 2 a Z W W O
LLI0 (9 _p Z 0 ac z FW O D_
F W _Z W
Z a < "' z Z z -' W W
N z } ° LL, a z
z 0 Q N U um z In zn In a e� O z
W U 2 1n s W °� z z a z J) J1 > z Z 0 LL
� o J �oLLJuI'-LU zz /0 LuZooWc� 333 � � ° (� ` a
G LWLJ Ln En F5
¢ la7 z 1uy Q C Q O W Z J W W g J J J O W F Y H Z Z
LLJF 00 00 m fn a LLJ
U l7 w Iz—i u0 Q z a w m a l�—i w ¢ 0.. a s Q 1� a u F
Y
OvQ NN$ rySS=y No S� p0 0 " S SS �0 S v0 v0 `ro
QF�a
0 90 p S oS $ooS
. 00 - oddododdz ioSoLnr-
0 o m0N r-1 -io 0o
v po . N N N J
. vvavcvv vvrvvv
V 00ti .i . ti .i . " NA . A N0 0 00 0 0 00 0 0 0 0 0 0 00 0.i .i . N . 11 .i N ri0 0 0 0
rl
M
Page 5 of 40
PROPOSED USES OF 2017 FUND BALANCE
PROPOSED 9/14/18 PROPOSED 11/13/18
December 31, December 31,
2017 2017
Allocable Balance $ 578,270 $ 608,270
Call Bonds $ (136,600) $ (136,949)
2019 Budget-Finance Wages $ (37,500) $ (37,500)
Transfer for Travel Budget-Budg Proj $ (4,000) $ (4,000)
Possible Police Gun Cameras $ (7,000) $
Unfunded Street- Norell $ (250,000) $ (150,000)
Balance Budget $ (176,166)
Balance $ 143,170 $ 103,655
The above are suggestions based on the Preliminary Budget Changes and discussions that
were had during the work sessions.
11/8/2018 General Fund Balance Allocation.xlsx Page 6 of 40
a
M
a
a
I
y m
LU cu c
Y
C
m a m
v
0 a v `
M M m v
C
CL v m
m
w a? N
Y
C C i
U
C O OW O O
O O O O OW 0 O O O C 0 C, OO ' ' 'W O O O Ln O , ' O of Ln
N Ch r.: l0 cr�0 0rlj cn00 Vko Lr rr M L6 WCr N o 01 0 to
M
Ln w 4 N LU m a-1 N
in in 14 44
~ J (on N V 00 S 00 lD S O O O O 0 0 0 0 0 0 0 0 0 O O O 1D
S O O N O V1 O O u1 O O 0 O 10
N Q �••� 01 O O ' lD 00 O 8 1n O O Ln V1 V1 M N m O N t!1 O g t� 10 m
\ F�F M N O O O' f` 1D O Vi C ri O Vi l0 fV O N I� r-I tri M f` Vi Uj .-j ri %O
M tJ "t a N N N T O Vf N N O V M N ri N V Ol
M p
N V} ih N
N OO00 co V1 O S 00S NO MNM rV O N M OO o NO
LU LD dcn
pNNMNO M NrW0O M r+N to riMN ri 1n VNm
M N V l0 t\ ri
W
N ca rj
m
ZV} in VF N
m
LL O C-4 N 0 0 O C1 qr O O o 0 0 0 0 0 0 N O O O O O O O V 0 0 01 01 ¢
W, o N N o O O O1 a 0 0 C:) 0 0 0 0 00 I� 0 0 0 o O O O rl O 0 01 a Q
O N lD O O N O Im 0 0 0 0 0 O O 00 M O N O O O O C Ol O m O O1
x N a o o is m o v v ce 0 0 t+ri Lr o o r-i ai 06 Lr tri Ln ui vi o N 00 tri a a6
O 00 00 a N N 00 N Vl V1 N N O ri 8 to ri ri ri V1 M ri 00 N
O 0 1 M N ri N ri V1 rlr-1 ri V1
Q
n4 N ry C
y�j V► ih N
Z w O R O S pO O O O O O O O S S W N O N n O O O O 88 0 0 S O
4 C J ' O N V1 O O C M O S O O O O O ri ' cm O V ' M n N O o O S 0 ' ' v1 M O
Q O a t0 N O 00 N N O' O O M Vi O V' ri p Vi 01 V1 L M VI Ln 6 O m H N
~ N = N M a M Om 14 V1 N N N VQ O M ri N ri N
M
O^1 N
N Q N N
N
iR 44 in
U
d
W0
0: LL
z LLA
Ch Go
O K
F- ui
Z = Z O O O O N N m W &MW
OCLu 2 Lm Ln N
LU Ln z LnN
Q N 0 Z w O O Z Z Q M- w U Q LL LL
F-
cc
Z O v0 3 Z> > > M W 0 C J > 0 Z Z O Z F Q W
n > WW W N d C d LL F N tY ? a U D F- W Z W W H
LL LL Q_ laL z = F- W
C) = � cr p 0 cYj w J j LL y Z a w N N W O
a Q �- F 0 0 0 0 p qo o Z O F- O N Z Z Z w 0- v z W H
LL d Vl N C7 C7 LL m U z Q F- Z W LLJ0 0 W N W W Ur Q cc g
p 0 0 0 0 0 0 0 0 0 0 U a w M W J w F- F- U g W J ,n M D LU ( Di
W LL
0 � � � � � � � � ►- waz _� mmg > � aza ? d V1oca <n -Jw W h
5 F- F= F- F- F- F- � x c F- O a F- O M Z O M x o J 0 C W J 0b W z o< z
W 0 0 7 7 7 0 F- W Q Q = 0 0 0 F- � V W W U Q O 2 Q J F- W O Q
2 0 0 0 0 0 0 0 0 0 0 0 F- O C Cl �7 Z U O Q W Q > F- cc u a Q U W a F-
W W V1 V) V1 N V1 N V7 V1 VI N J W U {� L J W Q VI W F- V u ; V l.1 U 3 J 0 w J
F Z Z Z Z Z Z Z Z Z Z Q O J ][ J J \ J Z l_F M y a a
co _ J =3 2 Z Z Q � Z F-
a oc d cc c' Q Q Q F- 0 Q °C Q m Z O W O LL O
O Q F- F- F- F- F- F H F- F- H OR CO V) a F a u FW- n0. LL a UO a OU a Oa a OU w N U ED OF
W 0 0 0 0 0 0 0 0 0 0 0
O N N N N N N N N N N N
01 01 D1 O1 O1 01 01 01 01 01 01 Ol
a v v v v a
Z �
O a a a a v - o
V ri r-1 N N A AA N N A A A �
V 0 0 0 0 0 0 0 0 0 0 o 0
Q N N N ri N N ri N ri N N N
.ti
Page 7 of 40
a
a
wW Y {WD N r l0 N {tl Si N O O N ' ^�'7 O Pw')_ ' a0 f� N O f0 N N A f0 11�
N
n O
O W z v) N N GNO A N N C In N b Ol N O r N m m O N N m N n N
N q h r r N m
I'9
ti
C W O 8 p pp •^� O
to V N 70 O �$�j O Oa O CNO
NLL v .N... .0... .�..
W
a QQo $5� g
w W o X25 0 25 IR coo LTi Ri g o o 8 g o O p g e
m V z O O a w N m O '� Q i0 (+j m [ w] ( 0 W G [�) 1p
P
N O W H N W ^ A
A
a 7r
O (Np W u7 Q b N .A n 8 O W O oO M r O W Y07 N O m C! N N fOp O
�y�qj N
m W Z N f00 N r ld b f�0y a N 4N7 N n N N � C N C N Qi �?" ^ O N CD tF �Op
W h N N h f"1 M N N V
$ gym
O �
z w Q o
K
C7 D o
Z m Z !:c o O
O N W W to
l7
W m
W 'D N m A Z
z v oLu
a
cr IL
Q W n
� LL
z 0 S 8 S p
�rN W O ppO O pop o pO 8 o Lo �n O pp S Op O O o0 pO g po pO pp pp p
"' 7 0 O n7 r Iq N 171 n O b ' O O �O Cm 00 O ' W O O O O o ' yOj
W m U z 1606 a
d (A Lu
N oW m
0 Lu a w
p
W Iq �Op N f� O pO W Op O O p p pp11 m ��y{ m pO m m A Iq O N 01 N p p O �y N
Yp1I In 8 l7 S O ' O r m u�1 ' co e- ' q b O O V W �y 8 � � � � V O O W m
m O z fm0 V aN'1 YI h N iOV N amD Ilj A n sf {p" C p� N - (y T N O N OI 4D N (p" pp .Na^
N Q CCO 1q CV N N N ^PI
In rj
y
Q.
z (�'
w u T
U z 77
to z w to C2 Lu z
j W U U Z W 7.Dper.
W- ¢ w ou.
;z z v > = O R z a w w ¢ o z
g [9 p w z O g w U Y w m , 9O a 4 4¢ vYwj
Q > W z m 0 a a = m m 7�n p rn a w Q t- Q U
g mw p m z m w w O t7 O O 7n O rc w O 5 m m > >
rc of m O w z Y a—i LL x F Ime LL Z �A w V w j O � m ~ z O W w w z O w o w
F m z a = z o g O3 w , � m W m m 6 z w LL f Q a O z 0 .w.1 z z o F w w
ILII V ¢ J V a! m w K E a 0 Z a w z W E tz V U 3 Q ¢ S O F a V < o U m
m 2 m 2 .7 m U w P w w w U 2 �_ rr K O
K d w Q O p w O 0 0 x 0 5 > O O S O w a K 0 0 J 0 0 F- trl a w p
7t m m a a m U v w a a 0 U m U U 1- a � li a LL d U n 7- s 3 c7
.,
Page 8 of 40
FLAHERTY I HOOD P.A.
MEMORANDUM
To: Coalition of Utility Cities
From: Justin Stofferahn
Date: November 7,2018
Re: DRAFT: Preliminary analysis of changes to Local Government Aid as part of Utility
Valuation Reform
As the Coalition of Utility Cities(CUC)considers whether to engage in conversations over utility
valuation reform and works to prepare for possible power plant retirements, this analysis is
meant to help inform whether changes to Local Government Aid (LGA)should be considered as
part of any potential policy response.This analysis, which is preliminary, comes with several
limitations and assumptions, but is instructive in illustrating general impacts on CUC members.
Current Environment
To properly contextualize our analysis, it is important to understand what CUC members
currently receive from the LGA program.As shown in the table below, most CUC members do
not currently receive any LGA funding.
City 2018 LGA 2019 LGA
Becker $0 $0
Cohasset $0 $0
Monticello $0 $0
Hoyt Lakes $404,858 $405,333
Granite Falls $977,808 $979,975
Oak Park Heights $0 $0
Red Wing j $959,516 1 $794,066
Assumptions and Scenarios
To see what impact LGA could have on CUC members in the wake of plant closures,we
analyzed the impact of four different scenarios for each city.There are several underlying
assumptions throughout this analysis:
• For each city it is assumed that their power plant is closed and no longer pays state
assessed property taxes.
1
Page 9 of 40
• Each city is modeled individually, which assumes no other plant closures take place
during that time.
• Each model begins with the Certified 2019 LGA. Data is currently available to make a
dynamic estimate for 2020, but the data for all years after 2020 is held static.
This analysis models four different scenarios for each city:
• Scenario 1: LGA for 2019-2023 under current law.This scenario would occur without any
legislative changes because the closure of power plants will change the tax base and
thus alter the need calculated by the LGA formula.
• Scenario 2: LGA for 2019-2023 under a Coalition of Greater Minnesota Cities(CGMC)
proposal that increases the LGA appropriation by over$30 million and makes updates to
the need factors in the LGA formula.
• Scenario 3: LGA for 2019-2023 under current law with cities"eased onto"the LGA
formula.
• Scenario 4: LGA for 2019-2023 under the CGMC proposal with cities"eased onto"the
LGA formula.
The CGMC proposal is contained in SF4017 from the 2018 legislative session and includes
updates to the current factors used in the LGA formula to determine a city's need, and
increases the current appropriation by over$30 million to$564,982,145.
The "eased on" provision that is modeled in this analysis acknowledges that a city's tax base will
decline with closure of a plant, and thus the existing LGA amount is not reflective of its new
need.This provision works by providing each city a 2018 LGA amount that is 65.77%of its
unmet need for 2019.This 65.77%number is the share of unmet need fulfilled by the 2019 LGA
appropriation.That appropriation is$534,398,012 compared to a total unmet need of
$814,659,086.Since LGA is based in part on the previous year's LGA, this helps account for the
sudden drop in tax capacity in the wake of a plant closure.
2
Page 10 of 40
Tax Capacity and Levies
To model the impact of a plant closure,each CUC member's Adjusted Net Tax Capacity(ANTC),
which is the tax capacity amount used in the LGA formula, is altered by subtracting the Total
Utility Tax Capacity in a city.The impact of this change can be seen in the chart on the following
page.
Change in ANTC
2017 ANTC(With 2018
Assumed Plant ANTC(With Assumed
City 2017 ANTC Closure) 2018 ANTC Plant Closure)_
Becker $17,258,707 $4,002,189 $17,864,491
$4,024,534
Cohasset $11,016,197 $3,075,450 $11,275,828 $3,054,870
Monticello $28,412,608 $11,617,977 $30,180,787 $12,458,624
Hoyt Lakes $1,835,333 $1,119,119 $1,872,191 $1,155,965
Granite Falls $1,871,406 $1,474,200 $1,993,062 $1,585,920
Oak Park Heights $9,625,913 $5,226,241 $9,959,716 $5,245,331
Red Wing $31,513,497 $14,003,908 $33,140,103 $14,332,411
3
Page 11 of 40
City Finaces
In evaluating the impact of LGA on CLIC members it is important to understand how it compares
to the gap that would be left in tax capacity by closure of a power plant.The tables below
demonstrate how closure of a plant would impact each city's finances.
Becker
2017 2018
Current Tax Rate 39.55% 39.63%
Tax Rate after removing Total Utility Tax
Capacity from Tax Base 170.53% 175.94%
Current Levy $6,825,003 $7,080,568
Levy if Current Tax Rate is applied to Tax Base
without Total Utility Tax Capacity i $1,582,677 $1,595,119
-Amount of Levy Shifted onto Non-Utility
LT"payers $5,242,326 $5,485,449
Cohasset
2017 2018
Current Tax Rate 23.60% 26.16%
Tax Rate after removing Total Utility Tax
Capacity from Tax Base 84.54% 96.57%
Current Levy , $2,599,988 $2,950,000
Levy if Current Tax Rate is applied to Tax Base
without Total Utility Tax Capacity $725,852 _ $799,220
Amount of Levy Shifted onto Non-Utility
Taxpayers $1,874,135 $2,150,780
Granite Falls
2017 2018
Current Tax Rate 94.40% 93.47%
Tax Rate after removing Total Utility Tax
Capacity from Tax Base 119.83% 117.46%
Current Levy $1,766,583 $1,862,842
Levy if Current Tax Rate is applied to Tax Base
without Total Utility Tax Capacity $1,391,626 $1,482,301
Amount of Levy Shifted onto Non-Utility
Taxpayers 1 $374,957 1 $380,541
4
Page 12 of 40
Hoyt Lakes
2017 2018
Current Tax Rate 77.52% 77.14%
Tax Rate after removing Total Utility Tax
Capacity from Tax Base 127.13% 124.93%
Current Levy $1,422,682 $1,444,119
Levy if Current Tax Rate is applied to Tax Base
without Total Utility Tax Capacity $867,499 $891,656
Amount of Levy Shifted onto Non-Utility
Taxpayers 1 $555,182 $552,463
Red Wing
2017 2018
Current Tax Rate 68.53% 70.02%
Tax Rate after removing Total Utility Tax
Capacity from Tax Base 154.21% 161.91%
Current Levy $21,595,526 $23,205,223
Levy if Current Tax Rate is applied to Tax Base
without Total Utility Tax Capacity $9,596,579 $10,035,780
Amount of Levy Shifted onto Non-Utility
Taxpayers $11,998,947 $13,169,443
Monticello
2017 2018
Current Tax Rate 32.20% 31.63%
Tax Rate after removing Total Utility Tax
Capacity from Tax Base 78.76% 76.63%
Current Levy $9,149,885 $9,547,000
Levy if Current Tax Rate is applied to Tax Base
without Total Utility Tax Capacity $3,741,408 $3,941,000
Amount of Levy Shifted onto Non-Utility
Taxpayers $5,408,477 $5,606,000
Oak Park Heights
2017 2018
Current Tax Rate 53.96% 53.50%
Tax Rate after removing T_tal Utility Tax
Capacity from Tax Base 99.38% 101.59%
Current Levy $5,193,662 $5,328,501
Levy if Current Tax Rate is applied to Tax Base
without Total Utility Tax Capacity $2,819,819 $2,806,280
Amount of Levy Shifted onto Non-Utility
Taxpayers $2,373,843 $2,522,221
5
Page 13 of 40
BECKER LGA MODELING
Becker LGA (Current law)
$16,000
$15,102
$14,000 $13,688
$12,000 $12,002
$10,000 $10,030
$8,000
$6,000
$4,000 $3,598
$2,000
$U
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$877,888 and for 2020-23 is$969,525.
Becker LGA (CGMC Proposal w/$30+ million appropriation
increase and formula updates)
$100,000
$90,000 $86,873 $87,625 $88,368 $89,094
$80,000
$70,000
$60,000
$50,000
$40,000
$30,000
$20,000
$10,000 $3,598
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$877,888 and for 2020-23 is$1,181,987.
6
Page 14 of 40
Becker LGA (Current Law with "Eased On" provision which
provides a 2018 LGA amount = 65.77% of 2019 unmet need)
$700,000
$600,000 $578,239 $580,825 $581,622 $582,305 $582,878
$500,000
$400,000
$300,000
$200,000
$100,000
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$877,888 and for 2020-23 is$969,525.
Becker LGA (CGMC Proposal & "Eased On" Provision)
$700,000
$620,905 $621,290 $621,670 $622,042
$600,000 $578,239
$500,000
$400,000
$300,000
i
$200,000
$100,000
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$877,888 and for 2020-23 is$1,181,987.
7
Page 15 of 40
COHASSET LGA MODELING
Cohasset LGA (Current Law)
$7,000
$6,401
$6,000 $5,776
$5,000 $5,024
$4,154
$4,000
$3,000
$2,000 $1,424
$1,000
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$367,273 and for 2020-23 is$433,566.
Cohasset LGA (CGMC Proposal w/$30+ million appropriation
increase and formula updates)
$40,000
$36,557 $36,874 $37,187 $37,493
$35,000
$30,000
$25,000
$20,000
$15,000
$10,000
$5,000
$1,424
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$367,273 and for 2020-23 is$499,466.
8
Page 16 of 40
Cohasset LGA (Current Law with "Eased On" provision which
provides a 2018 LGA amount= 65.77% of 2019 unmet need)
$300,000
$250,000 $241,788 $242,995 $243,381 $243,715 $243,992
$200,000
$150,000
$100,000
$50,000
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$367,273 and for 2020-23 is$433,566.
Cohasset LGA (CGMC Proposal& "Eased On" Provision)
$300,000
$259,965 $260,129 $260,291 $260,449
$250,000 $241,788
$200,000
$150,000
$100,000
$50,000
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$367,273 and for 2020-23 is$499,466.
9
Page 17 of 40
GRANITE FALLS LGA MODELING
Granite Falls LGA (Current Law)
$1,200,000
$1,000,000 $977,808 $979,975 $980,606 $985,135 $986,662 $988,002 $989,102
$800,000
$600,000
$400,000
$200,000
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$1,759,510 and for 2020-23 is$1,755,428
Granite Falls LGA (CGMC Proposal w/$30+ million
appropriation increase and formula updates)
$1,200,000
$1,044,053 $1,044,625 $1,045,189 $1,045,741
$1,000,000 $977,808 $979,975 $980,606
$800,000
$600,000
$400,000
l
$200,000
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$1,759,510 and for 2020-23 is$1,883,567
10
Page 18 of 40
Granite Falls LGA (Current Law with "Eased On" provision
which provides a 2018 LGA amount= 65.77% of 2019 unmet
need)
$1,400,000
$1,200,000 $1,161,089 $1,163,359 $1,164,517 $1,165,389 $1,166,110
$1,000,000 $977,808 $979,975
$800,000
$600,000
$400,000
$200,000
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$1,759,510 and for 2020-23 is$1,755,428
Granite Falls LGA (CGMC Proposal & "Eased On" Provision)
$1,400,000
$1,200,000 $1,161,089 $1,210,983 $1,211,439 $1,211,891 $1,212,261
r
$1,000,000 $977,808 $979,975
i
$800,000
$600,000
$400,000
c
$200,000
$o
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$1,759,510 and for 2020-23 is$1,883,567
11
Page 19 of 40
HOYT LAKES LGA MODELING
Hoyt Lakes LGA (Current Law)
$450,000
$404,858 $405,333 $406,463 $409,200 $410,123 $410,933 $411,598
$400,000
i
$350,000
$300,000
$250,000
$200,000
$150,000
$100,000
$50,000
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$851,880 and for 2020-23 is$874,675
Hoyt Lakes LGA (CGMC Proposal w/$30+ million appropriation
increase and formula updates)
$500,000
$450,000 $439,666 $439,965 $440,260 $440,549
$404,858 $405,333 $406,463
$400,000
$350,000
$300,000
$250,000
$200,000
$150,000
$100,000
$50,000
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$851,880 and for 2020-23 is$879,050
12
Page 20 of 40
Hoyt Lakes LGA (Current Law with "Eased On" provision which
provides a 2018 LGA amount = 65.77%of 2019 unmet need)
$600,000 $561,169 $562,999 $563,617 $564,159 $564,604
$500,000
$404,858 $405,333
$400,000
$300,000
$200,000
$100,000
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$851,880 and for 2020-23 is$874,675
Hoyt Lakes LGA(CGMC Proposal & "Eased On" Provision)
$700,000
$600,000 $561,169 $583,503 $583,704 $583,902 $584,096
$500,000
$404,858 $405,333
$400,000 -
$300,000
6'
$200,000
$100,000
i
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$851,880 and for 2020-23 is$879,050
13
Page 21 of 40
RED WING LGA MODELING
Red Wing LGA (Current Law)
$1,200,000
$1,000,000 $959,516 $974,807 $1,002,506 $1,008,901 $1,013,920 $1,017,768
�a
$800,000 $794,066
$600,000
$400,000
$200,000
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$5,147,965 and for 2020-23 is$5,373,174
Red Wing LGA (CGMC Proposal w/$30+ million appropriation
increase and formula changes)
$1,600,000
$1,400,000 $1,345,199 $1,346,563 $1,347,890 $1,349,135
$1,200,000
$1,000,000 $959,516 $974,807
$800,000
$794,066
r _
$600,000
$400,000
$200,000
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$5,147,965 and for 2020-23 is$6,280,491
14
Page 22 of 40
Red Wing LGA (Current Law with "Eased On" provision which
provides a 2018 LGA amount= 65.77%of 2019 unmet need)
$4,000,000
$3,500,000 $3,377,101 $3,389,259 $3,392,127 $3,394,405 $3,396,150
$3,000,000
$2,500,000
$2,000,000
$1,500,000
$1,000,000 $959,516
$794,066
$500,000
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$5,147,965 and for 2020-23 is$5,373,174
Red Wing LGA (CGMC Proposal& "Eased On" Provision)
$4,000,000
$3,579,788 $3,580,534 $3,581,258 $3,581,939
$3,500,000 $3,377,101
$3,000,000
$2,500,000
$2,000,000
$1,500,000
$1,000,000 $959,516
$794,066
$500,000
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$5,147,965 and for 2020-23 is$6,280,491
15
Page 23 of 40
MONTICELLO LGA MODELING
Monticello LGA (Current Law)
$35,000 $32,738
$29,826
$30,000
$26,378
$25,000 $22,314
$20,000
$15,000
$10,000 $8,708
�u
$5,000
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$2,056,250 and for 2020-23 is$1,984,346
Monticello LGA (CGMC Proposal w/$30+ million
appropriation increase and formula changes)
$250,000
$200,000 $189,082 $190,711 $192,322 $193,893
$150,000
$100,000
I
$50,000
$8,708
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$2,056,250 and for 2020-23 is$2,563,194
16
Page 24 of 40
Monticello LGA (Current Law with "Eased On" provision which
provides a 2018 LGA amount= 65.77% of 2019 unmet need)
$1,600,000
$1,400,000 $1,352,082 $1,356,362 $1,357,656 $1,358,760 $1,359,692
$1,200,000
$1,000,000
$800,000
$600,000
$400,000
$200,000
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$2,056,250 and for 2020-23 is$1,984,346
Monticello LGA (CGMC Proposal & "Eased On" Provision)
1460000
1440000 $1,437,600 $1,438,372 $1,439,881 $1,440,466
1420000
1400000
1380000
1360000 $1,352,082
1340000
1320000
1300000
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$2,056,250 and for 2020-23 is$2,563,194
17
Page 25 of 40
OAK PARK HEIGHTS LGA MODELING
Oak Park Heights LGA (Current Law)
$10,000
$9,177
$9,000
$8,260
$8,000
$7,150
$7,000
$6,000 $5,875
$5,000
$4,000
$3,000
$2,000 $1,971
$1,000
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$529,233 and for 2020-23 is$641,989
Oak Park Heights LGA (CGMC Proposal w/$30+ million
appropriation increase and formula changes)
$70,000
$63,033 $63,584 $64,127 $64,659
$60,000
$50,000
$40,000
$30,000
$20,000
$10,000
$1,971
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$529,233 and for 2020-23 is$870,127
18
Page 26 of 40
Oak Park Heights LGA (Current Law with "Eased On"
provision which provides a 2018 LGA amount= 65.77% of
2019 unmet need)
$400,000
$350,000 $347,620 $349,406 $349,992 $350,502 $350,924
$300,000
$250,000
$200,000
$150,000
$100,000
$50,000
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$529,233 and for 2020-23 is$641,989
Oak Park Heights LGA (CGMC Proposal & "Eased On"
Provision)
$450,000
$400,000 $384,371 $384,703 $385,030 $385,350
$
$350,000 347,165
$300,000
$250,000
$200,000
$150,000
$100,000
$50,000
$0
2018 Certified 2019 Certified 2019 Est.LGA 2020 Est.LGA 2021 Est.LGA 2022 Est.LGA 2023 Est.LGA
LGA LGA
Note:The estimated unmet need for 2019 is$529,233 and for 2020-23 is$870,127
19
Page 27 of 40
1 1.
i
■ /I w
L�I
1�,rrf L
J
Page 28 of 40
a
W
O c
•0
N _O
U) c cu
cu N
O N '—
Z3 O O O
L — U
CU
LIT •c a
� OC m a) (1)
Q
Page 29 of 40
N
(7
V
3
U
C
N
� u
� v
o � a
c y
vi
m
3 u 16
o w a w
U E
�o
a) ° Ln 0 0
CL
W 41 d v �
L E — O u
wo en C: w� N r -a o
W ^ N N C y ate+
0s 3 u z
a 3 c m 1
Z Q
D. M pp a s ri p N
NC ` LL 41 u �
x}11Y ` N O t
•� wEC
N u w 3 w
GJ oC y ti m O
� d L
♦/
'w l7 3 E 14
V, II N vii -0 L9 ba +� c 14
0
N +'• N + 41
_- •0 3 N
c COLI N E u O M m
C
En
u C C C4 u
C N T
3 u 3 n
CL v y w o �i O
(D in ` O m O N m
O N V Q v 'a N
to O 0 L u
N Ln "O O O
II ayi m M c = c f0 E .
( ♦ y �a'i p w �i a uf6i 4-1 ai �O
V o m r2 c G w a) u o
N u c _ � M
� p 4-cu
- 3 O u t ,�
�r u C L En O
V C C -0 •� d C GAN/ ,� E 0
Ian u O y O Ui
C) H y U
1�(iyy U
W0
Z W Z a-i ca Q C
UW
O �►
Q,
CL U o u
nL' W C .� CL
0 C
W W �y C u
GJ u W 'O 0 R V
>
Z u V=f OAC a V W a
Page 30 of 40
1 1 1 1 1
1
1
1 m
1 I o
(U N W
� 1 1
d
m
� N �
4) 1
i
L '
t
1 N J
3c
JA
_ CA
C N
E V 1 1
L M o ■
i .0 1
1
H 01 V
0o ■
M `� N
.� c00
3
2 ^ Q 1 N =
3 Ln ^ ■
� � N
O
_vO ea i
M 41 r
Q y W ' N N
�r�v
L1_ _A LO m I 7I .711 I N
47 ep 4) N
10 i%L m m
NE-
CL 3
om ; N
N C ' o
N
I
�V N 15U
00
40
{ N ■
N
o C
N m
m I i
y N
V � o s
H u VI o Z
m N
i 1
/%W 8 Q O O O pO O O pO
LL
O VO 00 00 00 O S S O 1
LL o�0 k M c O o0 kO 4 N
Page 31 of 40
C
m
O
m �n
L
i
O I
N
V
m a
m N
u o
N
3 b
01
O
L V
V
X O �� N
■— =
ow
L ulIA M
O N =
4J
LW
N
to 4a ai j a
/1 C �� O
O e0 in w
.O E N
O
w N
LU !
O L _
cu
a
O
O 1.07
N
L N O
V L
L U
O
N W H
.p Nz
a '
� s s s s s g
O O cr CP Q O O o
W in Rt en C14 rl
Page 32 of 40
sr A
Ln
Ln
W^♦ 00
^W C
W
L 3:c lcc°�
LL 00 o
O_ H
•N 00
to 6e0c.
O ' 00
toCE to00
aR
41
O c
Ut7 U) se°c.
00
W (a :33 W l4eo
Eao c `� �e*oc'
a) m
c t
a, e°c.
a erne
o�
: oC.
.Q -a
c
Ln
^♦
M
o
W N e `ce, c
t &n °� o
4-1c � �
2 Nr�0 Op
V♦ m LL °eOc. 4. 1 o
cu
LZ
C G %C.U M P�0� u
OV �doe
(D
i c
L' N
V m x 9°F, 40, -,
en
W caC-
ZCD
m `off CG c m ��0 3
O
�y Is— re0c. v
L.L m oC0C.
Page 33 of 40
K
r•t
b 6
W 3 a•wl
`n
IAiA d• " a vc.
N ' E'a
O om Ln riEWi e�°c'
evpa IcC`
t LA o It a s o
•+
p 3�� ej•s . c °t
°a='•S se
�A N « a'CU r °t
CO O 'h o+° PCOC.
OC.
.O ++ s�°c.
V m A
Ln 0
U 3 SOC.
�c".°
C.
N v ecaR '.
ca C.0 Ln
L
V l2t
Ul O�OC.
3
OR
Ln -ct V m mm
L
O
_ A,
C cc'Oe
U ��°C.
0 r�OC.
v Oel
c� CL N se
C6 `
L
Oe
r �°e
coo
e
9
^, s �
W +�+ °e
V _ SOF.
o�
A�°t
-pel
ebe
�Oe
°C°C.
Page 34 of 40
M
O
N m m O
u O O
ey 00 W
O c No No of N
_ N ctio r4 O n O
N O N O�
N Y N N a
'= .� sG" c c 0i
Y Y p Qj Co
c •G
V N � 481
It
O N LTi
.�,� o •a °
U M o
O 0 -O Obi a 4.0
O
Uz ci
LLI
^ Z
L o a v
cu W
U y LA O y aE
C3
ts
o,
4.9 C) isth
o
O c a
.cu a 4 y
V
V
en
C4 41
r400.
.� OQNm MNa dC14 41 (N
— LLJ
Ln
WM '
fCO
14
cu N N O O 41
' 0 4D "� CN cq
Oao ++ ON NN`aNd�
�NCCO
OSN O1-1 CSNOC d CO -0 Cl
Cl) N N l
C X
cfw N X C O L L T �p W
41 41
M! LN Lai W LLI LY mLLJ W
LM
w,
+t C
O E
O w -a
T
Q
W 3 ?
U �
W
v I
Page 35 of 40
U
a.
;W � •
04
R C
�♦ c` aL`e' 3
m
/♦/^� a m
V♦ L C
3 «cu
a � «
C7 yL' N
U H W .l. C
O
V' CN _ E `i N
Y C
31
$ !
c. n e0 a us v. m
o.: o:
F u r, N c s ,,, N �; d 3 Q^, VVV a, 1Y
�^ m' ,� �.r o ,
■ N U; 'O O H LL 'E7 CCU
• O G f', L 4J L
0.
'A �: LL u 9 y C U YG
` c �m r �Z{,tom+ p N ��p �+; p �; OQ• N a�
/�\a >'M. "'� S f�0 C iJ (� N�- Opo p�. -ro-
c N ''
W N % p� U r _ 2 L m p ��ynU
W m 40 0 U m V U t 7 � Q 0 F3
w'' is u�i io 2 $'m > 3 oo ° 3 L o 7
� g+ ri � t3 E aJ° � � ax s. w aQ. «.; � s
rm-
tm
n9 Ln
}� is c F „,:
M O. '" .. pC O f' Qz d'O � W m m
L _
C. C d L « J y J C �+1. J N .:N G m t Y
O CC N �n w W m O 1°
m.
m N
bo m N m Z W d C N z y G C T
LU w u y �'o m m ° € ; £ 3 m Vc i V x a#'ci' u 3 3
_ E uu i m 2A”
O N. d N Ms H C N C CJ C d 3' 3. t` tO tO
pp cc m W L d C �4: w L p3 p� ��> Yf u1
2`IA 2 A0 uW (7 3 CD o: H oe �— mm oC H J J. > LA Ln
■^0
i.L �' f
to
Oco to NO 41 0M
T W'
CLJ EO.2 �: CO S s m x '- CO W'.:Z m' 3
O J •` LOD.. J
W
�w
3
tio
06 tn
. .
M
.,
.,
LLJ 06
LW 0
T �
Page 36 of 40
ti£OZ
££OZ
.-. Z£OZ
T£OZ
O c =
0£OZ
CL
C = 6ZOZ
•° •� szoz W
m LZOZ su z
C W s
m 3
(U wl 9ZOZ � � � �
O V SZOZ c " " +'
Lm aCi U w
p VZOZ ai
O Cl. o. a a
£ZOZ 6
ZZOZ
�C
� TZOZ
'� OZOZ
go g o 0
Ln Ln o Ln
m cl o vi
0 E
,W b£OZ
LL M
££OZ
mo
d
Z€OZ
CL S
cu X T£OZ
O
O 40 C7 0£OZ
J O
6ZOZ
In C >
I LU
szoz
40 m
CL CL LZOZ N t
•E O 9ZOZ 0° 3
^^♦♦ C a� wa� m
�+ •
macam
� � � aCi ai i i
• vzoz 2 0 U
> V 0 a a a a
.� £ZOZ r s s s
inimin8
ZZOZ in O1 '^ �'
V/ (U L
W p TZOZ
^� W OZOZ
W
o 0 o g g
ua rq to ri W
u+ Ln Icr er m
Page 37 of 40
e
LL I
H �
Cl) z
cnO
C
4) M M
L MOM"
WU. '
40-
06c
� c '
�> p
E
yICA
V N
L s I %
°1D 0 %
O M %
E 6
011 gasm�
� L w
I m -vc'
cl) s
._ 3 z oOe
4-0El
V
'o �
Cf)
z� m
N C p
W-A"M
Page 38 of 40
V
^\ p
W
U E
N O
C O) U O
� O N
L
coco
O N U
cu
O Q CO
.E L U
N N cn
L 0 N N
U
p a)
ci ca -0 c a
v
U O U ;
THIS PAGE INTENTIONALLY LEFT BLANK
Page 40 of 40