HomeMy WebLinkAboutExpansion Options handoutSummary of Expansion Options
A B
C
E
G 1
1
K
L
M
N
O
P
T
U
V
W
x
Y
Z
AA
AB
AC
Avg. # of
# of
Ending Fund
Ending Fund
Ending Fund
Ending Fund
Ending Fund
Ending Fund
Total # of
Total # of Total # of Staff
Avg. # of Primary
Secondary
Time to
FFE & Setup
Capital Construction
Debt Service &
Portable
Facility Size
Balance
Balance
Balance
Balance
Balance
Balance
45 -Day Reserve Unassigned Fund
1
Description
Students
Teacher FTEs FTEs
Students per Class
Students per Class
Completion
Costs
Design Costs
costs
Lease Costs
Buildings
Sq /Ft
FY 11/12
FY 12/13
FY 13/14
FY 14/15
FY 15/16
FY 16/17
Requirement
Balance
2
FY 11/12 - Baseline Data
621
44 23.2
20
20
0
$ -
$ -
$ -
$ -
63,000
$ 657,001
$ 502,101
$ 336,152 $
(8,356) $
(375,124) $
(884,632)
$ - $
-
3
Option 1 -A
4Section GK -G12 (G6 in MYP)
1,150
78.4 33.0
20
25
2 yrs 4 mos
1,302,779
11,725,009
870,000
112,390
657,001
502,101
336,152
291,080
248,977
210,040
1,188,008
(977,968)
4
c Option 1 -B
0
4 Section (G6 in PYP)
1,130
78.4 33.0
20
25
2 yrs 4 mos
1,325,229
11,927,062
885,000
112,015
657,001
502,101
336,152
116,969
(103,420)
(324,941)
1,167,347
(1,492,287)
5
0 Option 2 -A
c
5 Section Prim. & 4 Section Sec. (G6 in PYP)
1,270
88.0 35.0
20
25
2 yrs 4 mos
1,512,916
13,616,240
983,000
129,090
657,001
502,101
336,152
1,341,751
1,725,358
2,124,924
1,311,974
812,950
6
Option 2 -B
5 Section Prim. & 4 Section Sec. (G6 in MYP)
1,270
89.4 35.0
20
25
2 yrs 4 mos
1,482,188
13,339,692
990,000
118,883
657,001
502,101
336,152
301,751
271,358
250,924
1,311,974
(1,061,050)
7
= Option 3
4Section GK- G12 (phased)
1,150
78.4 33.0
20
25
3 yrs
1,304,488
11,740,394
880,000
112,390
657,001
502,101
336,152
142,519
189,009
116,572
1,167,357
(1,050,785)
8
Option 4
5 Section Prim. & 4 Section Sec. (phased)
1,270
88.0 35.0
20
25
3 yrs
1,446,032
13,014,285
975,000
117,590
657,001
502,101
336,152
(26,703)
(250,499)
(195,433)
1,277,145
(1.472,578)
9
Options
Status Quo
621
44.1 23.2
20
20
0
-
-
-
-
-
63,000
657,001
502,101
336,152
(8,356)
(375,1241
(884.632)
746,288
(1,630,920)
10
Option 5 -A
3Sections GK- G12(20 Students /Class)
771
54.3 30.0
20
20
Undefined
579,500
160,000
1,440,000
176,000
6
79,500
657,001
(204,685)
(681,077)
(1,333,233)
(2,012,346)
(2,863,724)
912,460
(3,776,184)
11
Option 6 -B
3 Sections GK -G12 (20 -25 Students /Class)
859
54.3 30.0
20
25
Undefined
579,500
160,000
1,440,000
176,000
6
79,500
657,001
329,089
497,912
490,160
472,152
281,016
916,102
(635,086)
12
Option 7 -A
4Sections GK- G12(20 Students /Class)
1,028
71.8 37.5
20
20
Undefined
1,101,500
160,000
1,440,000
248,000
12
91,500
657,001
(304,253)
(355,692)
(624,284)
(911,106)
(1,414,105)
1,131,140
(2,545,245)
13
c
n Option 7 -B
45ections GK -G12 (20-25 Students /Class)
1,145
71.8 37.5
20
25
Undefined
1,101,500
160,000
1,440,000
248,000
12
91,500
657,001
407,446
1,216,294
1,806,908
2,401,557
2,778,882
1,135,996
1,642,886
14
O
Option 8 -A
N
DP Expansion (4- sections)
688
46.3 23.3
20
20
2 yrs
208,000
-
-
48,000
4
71,000
657,001
203,268
(40,872)
(441,156)
(864,785)
(1,439,884)
791,818
(2,231,703)
15
Option 8 -13
DP Expansion (5-sections)
725
48.5 23.3
20
20
2yrs
292,500
-
-
60,000
5
73,000
657,001
188,114
69,330
(209733)
(509,005)
(964,134)
814,109
11,778,243)
Option 9
MYP /DP Classroom Expansion
739
43.9 25.4
20
25
Undefined
100,000
-
-
-
-
63,000
657,001
746,549
1,092,421
1,286,712
1,472,502
1,511,663
763,970
747,694
Option 10
Organic Growth- 45ection PYP (20 Students /Class)
991
66.4 325
20
20
Undefined
819,500
150,000
1,440,000
206,000
9
84,500
657,001
(49,251)
1,919
(53879)
(32,122)
779,124
189'.051)
116
18
(118.527)
19
Option 11
Phased 4Sections GK- G12(20 -25 Students /Class)
1,145
71.8 37.5
20
25
Undefined
579,500
160,000
1,440,000
248,000
12
91,500
657,001
412,439
513,900
1,112,116
1,625,365
2,107,082
1,123,126
983,955
22
Cost of $1 Million of Construction over Time (Using the Construction Cost Index)
1,000,000
1,036,400
1,074,125
1,113,223
1,153,744
1,195,741
23
Cost of Option 2A over Time (Using the Construction Cost Index)
15,129,156
15,679,857
16,250,604
16,842,126
17,455,179
18,090,548
Wages and Salaries
held flat through 2012/13 (step- increase included), all expenditures increase
Assumptions - All Options
at the estimated rate
of inflation, all revenues held flat through FY 12/13 and increase
at the
24
estimated rate of
inflation beginning FY 13/14.
PYP Teacher /Section Ratio
1.46
FSP - State Funding / Student
$ 6,667
25
MYP /DP Teacher /Section Ratio
1.12
Blacksmith Average Gift
$ 1,000
26
PYP /MYP Retention
100%
Operating Cost /Square Foot
$ 5.45
27
DP Retention
85%
Modular Building Setup $ / Unit
$ 35,000
28
Average Daily Attendance (ADA)
97%
Debt Service Cost / $1,000
$ 0.065
29
r
Growth /Inflation
3%
Instructional Supply Cost /Student
$ 350
30
Enrollment Narratives Facility Acquisition
4 Sections of 20 students in PYP (K -5) & 4 Sections of 25 students in
MYP /DP (6 -12). Cost approximately $12 million to build necessary
facilities and will take 28 months from start to finish. Cost of High School Building, Middle
expansion (debt service) is covered by the increased student School Buildin, Media Center,
enrollment This models revenues exceed expenditures, and the Cafetorium
Fund Balance will build to approximately $210,040 over five years,
but does not meet the 45 -Day Reserve Requirement.
4 Sections of 20 students in PYP (K -6) & 4 Sections of 25 students in
- - - - -- - -- - -- - - --
MYP /DP (7 -12). Cost approximately $12 million to build necessary
High School Building, Middle
facilities and will take 28 months from start to finish. This model's
School Buildin, Media Center,
revenues are less then expenditures. This model's revenues exceed
Cafetorium, Primary School
expenditures, and the Fund Balance will be depleted within three
Addition
years.
. .......... .............. ........... . ........ . ... -----
5 Sections of 20 students in PYP (K -5) & 4 Sections of 25 students in
- - - - -- - -- - -- - - --
MYP /DP (6 -12). Cost approximately $15 million to build necessary
High School Building, Middle
1 facilities and will take 28 months from start to finish. Cost of
by
School Building, Performance Hall,
expansion (debt service) is covered the increased student
Cafetorium, Primary School
enrollment. This model's revenues exceed expenditures. The Fund
Addition, Media Center
Balance will build to approximately $2.1 million over five years
School Addition
with approximately $812,000 undesignated.
-- -_-
............ ... ..
5 Sections of 20 students in PYP (K -6) & 4 Sections of 25 students in
---- - - - - -- - -
MYP /DP (7 -12). Cost approximately $14 million to build necessary
1 facilities and will take 28 months from start to finish. Cost of
High School Building, Middle
I facilities and will take 37 months from start to finish. Cost of
School Buildin, Media Center,
expansion (debt service) is covered by the increased student
Cafetorium, Primary School
enrollment. This model's revenues exceed expenditures. The Fund
Addition
1 Balance will build to approximately $250,000 over five years, but
School Addition
j— --does not meet the 45 -Day Reserve Requirement.
. .. .... ........ . .... ... ... .... ... ....... .... ................................... _ ..............
..
........................... -
4 Sections of 20 students in PYP (K -5) & 4 Sections of 25 students in Phase 1
MYP /DP (6 -12). Cost approximately $12 million to build necessary
facilities and will take 37 months from start to finish. Cost of Middle School Building, Media
expansion (debt service) is covered by the increased student Center, Cafetorium
enrollment. This model's revenues exceed expenditures. The Fund Phase 2
Balance will build to approximately $116,572 over five years, but High School Building
does not meet the 45 -Day Reserve Requirement. __- .._- .__._...._..__...- _.._._._.._
j 5 Sections of 20 students in PYP (K -5) & 4 Sections of 25 students in
Phase 1
MYP /DP (6-12). Cost approximately $13 million to build necessary
Middle School Building, Media
I facilities and will take 37 months from start to finish. Cost of
Center, Cafetorium
j expansion (debt service) is covered by the increased student
Phase 2
i enrollment. This model's revenues exceed expenditures. The Fund
High School Building, Primary
IBalance will be depleted within two years.
---- -_..........- ----__._ .... ... ................. .......... _ .......... ....... . .............. _.-.._..-...............__,...._......_.................................................. . .............. ...... .... .. ... _.
School Addition
2 Sections of 20 students in PYP (K -6) & 3 Sections of 20 students in
MYP /DP (7 -12). This model's revenues are less then expenditures, No additional facilities
and the Fund Balance will be depleted within three years without
changes to the revenues /expenditures.
_.. - - -... - - - ------- -._ ....................... -
i
i
! 3 Sections of 20 students in PYP (K -6) & 3 Sections of 20 students in
MYP /DP (7 -12). This model's revenues are less then expenditures, Cafetorium, 6 new portable
and the Fund Balance will be depleted within one year due to ,buildings
setup, FFE, and lease costs. j
........... .. - . . ..... .................................. ....... ... ............ .. .. . ....... . .... ...... ... .. .... ... . . ...... ......... -.- . . . .. . ...... . .................... . ... ... - ----
3 Sections of 20 students in PYP (K -6) & 3 Sections of 25 students in
MYP /DP (7 -12). This model's revenues exceed expenditures, and Cafetorium, 6 new portable
the Fund Balance will build to approximately $281,016 over the
buildings
1 next five years, but does not meet the 45 -Day Reserve
Requirement.
. ........ . .... ... ..... ---._.........._.._..._.__.._._ ....................... _. .... - - -- - --
4 Sections of 20 students in PYP (K -6) & 4 Sections of 20 students in
MYP /DP (7 -12). This model's revenues are less then expenditures, Cafetorium, 12 new portable
and the Fund Balance will be depleted within one year due to buildings
setup, FFE, and lease costs.
4 Sections of 20 students in PYP (K -6) & 4 Sections of 25 students in
MYP /DP (7 -12). This model's revenues exceed expenditures, and Cafetorium, 12 new portable
the Fund Balance will build to approximately $2.8 million over the buildings
7 next five years
_ -_ ......... .........
2 Section of 20 students in PYP (K -6), 3 Sections of 20 students in
MYP (7 -10), & 4 Sections of 24 students in DP. This model's Cafetorium, 4 new portable
revenues are less then expenditures, and the Fund Balance will be buildings
depleted within two years.
L__._._... ..._ ................ ...- ...... - _ ...... _ ... - ....... ..... ---- ........... __ _.... .................... . ............ __....._- - -..._ ---- .........
- - -
-- .._ .. ... ......... ... _ _ ._ ..........
j 2 Section of 20 students in PYP (K -6), 3 Sections of 20 students in
MYP (7 -10), & 5 Sections of 24 students in DP. This model's Cafetorium, 5 new portable
j revenues are less then expenditures, and the Fund Balance will be buildings j
depleted within three years.
..._
2 Section of 20 students in PYP (K -6), 3 Sections of 25 students in
MYP /DP (7 -12). This model's revenues exceed expenditures, and
the Fund Balance will build to approximately $1.5 million over the
No additional facilities
j next five years with approximately $747,000 undesignated.
............... - -.._ _._
4 Sections of 20 students in PYP (K -6) growing into 4 Sections of 20
students in MYP /DP (7 -12) over the next 7 years. This model's Cafetorium, 9 new portable
revenues are less then expenditures, and the Fund Balance will be buildings
depleted within one year due to setup FFE, and lease costs
...... ............................... ... - ....... ... ._ ... _....- _ ...... --- - - - - --
This is a combination of Option 6 -B and 7 -B. Will result in 4
Sections of 20 students in PYP (K -6) & 4 Sections of 25 students in Cafetorium, 12 new portable
MYP /DP (7 -12). This model's revenues exceed expenditures, and buildings
the Fund Balance will build to approximately $2.1 million over the
next five years with approximately $980,000 undesignated.