8 HSs costs per MSBA.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Date MSBA Board Approved	Apr-19	Aug-18	Apr-24	Feb-19	Feb-18	Jan-16	Apr-19	Feb-17
2	District	Arlington14	Belmont11	Revere32	Waltham12	Attleboro9	Billerica	Lowell16	Somerville
3	School Name	Arlington HS	Belmont HS	Revere High	Waltham Sr HS	Attleboro HS	Billerica Memorial HS	Lowell HS	Somerville HS
4	Project Type	Core Program	Core Program	Core Program	Core Program	Core Program	Core Program	Core Program	Core Program
5	Project Scope	New Construction	Addition / Renovation	New Construction	New Construction	New Construction	New Construction	Addition / Renovation	Addition / Renovation
6	Enrollment	1,755	2,215	2,450	1,830	1,725	1,610	3,520	1,590
7	GSF	408,590	445,100	588,595	414,854	476,425	325,191	622,777	369,496
8	Assumed Start of Construction	Apr-19	Apr-19	Mar-25	Nov-21	May-19	Feb-17	Mar-21	Jun-18
9	OPM	Skanska USA Building, Inc	CHA Consulting, Inc.	Leftfield, LLC	Leftfield, LLC	Skanska USA Building, Inc	Leftfield, LLC	Skanska USA Building, Inc	PMA Consultants, LLC
10	Designer	HMFH Architects, Inc.	Perkins+Will	Perkins Eastman/DPC	Symmes Maini & McKee Associates, Inc.	Kaestle Boos Associates, Inc.	Perkins+Will	Perkins Eastman/DPC	Symmes Maini & McKee
11	Cost Estimator	Project Management & Cost	Project Management & Cost	Project Management & Cost	A M Fogarty & Associates Inc.	Miyakoda Consulting	Project Management & Cost	Project Management & Cost	VJ Associates of New England
12	Total Construction Cost	$235,286,827	$236,647,607	$412,006,854	$298,923,790	$223,088,312	$140,773,848	$270,444,856	$199,051,710
13	Cost per Square Foot	$575.85	$531.67	$699.98	$720.55	$468.25	$432.90	$434.26	$538.71
14	Soft costs	$55,564,993	$58,511,582	$85,511,047	$75,643,597	$36,829,868	$35,223,441	$72,954,364	$56,930,994
15	Project cost/sq ft	$711.84	$663.13	$845.26	$902.89	$545.56	$541.21	$551.40	$692.79
16	Reimbursement Rate	49.72%	40.66%	79.99%	65.71%	66.65%	56.99%	80.00%	75.29%
17	Maximum Facilities Grant	$86,051,829	$80,691,506	$238,853,595	$122,311,505	$126,948,617	$73,757,891	$216,001,846	$123,963,307
18
19		2017	2018	2019	2020	2021	2022	2023	2024	2025	2026	2027	2028
20	Escalation rates	5.3%	5.5%	6.1%	1.0%	12.0%	12.3%	2.0%	3.0%	3.0%	3.0%	3.0%	4.0%
21	from slide 6 of https://docs.google.com/presentation/d/1vhpH_ouaOfkL0nzV--iJrqisoDovI93p/edit#slide=id.p6
22
23		Arlington	Belmont	Revere	Waltham	Attleboro	Billerica	Lowell	Somerville
24	Escalation to July 2028	1.55	1.55	1.11	1.33	1.54	1.74	1.44	1.63
25
26		Arlington	Belmont	Revere	Waltham	Attleboro	Billerica	Lowell	Somerville	Lexington
27	Enrollment	1,755	2,215	2,450	1,830	1,725	1,610	3,520	1,590	2,395
28	Gross sq ft	408,590	445,100	588,595	414,854	476,425	325,191	622,777	369,496	440,816
29
30	Sq ft/student	233	201	240	227	276	202	177	232	184
31	X% more than Lexington	26%	9%	31%	23%	50%	10%	-4%	26%
32
33	Cost per Square Foot	$575.85	$531.67	$699.98	$720.55	$468.25	$432.90	$434.26	$538.71	$1,363.95
34
35	as of:	Apr-19	Apr-19	Mar-25	Nov-21	May-19	Feb-17	Mar-21	Jun-18	Jul-28
36
37	Escalation to July 2028	1.55	1.55	1.11	1.33	1.54	1.74	1.44	1.63	1.00
38	Escalated Project Cost $/sq ft	$1,104.92	$1,029.31	$938.06	$1,202.27	$842.65	$943.69	$791.85	$1,126.54	$1,363.95
39
40	Lexington higher by:	23.4%	32.5%	45.4%	13.4%	61.9%	44.5%	72.2%	21.1%
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100