Author:

Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.
 New Perspectives Excel 2019 | Module 11: SAM Project 1a

Hempstead University Foundation

Jinrui Dong

Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.
M website.
ID Project Name Project Type Campus Green Feature
EX-4096 Didrikson Gymnasium Expansion La Croix Materials
LA-5066 Wales Lake Landscape Hempstead Materials
RE-1751 Ardmore House Renovation Hempstead Materials
EX-4188 Transit Center Expansion Hempstead Stormwater
NE-3027 Bixbury Apartments New construction Newburgh Green roof
LA-5104 Hempsted Field Landscape Hempstead Stormwater
RE-1854 Sullivan Library Renovation Newburgh Green roof
RE-1890 Richardson Hall Renovation Newburgh Stormwater
LA-5218 Freestone Plaza Landscape Newburgh Stormwater
EX-4209 Boyle Residences Expansion Newburgh Materials
NE-3153 Ambani International Center New construction Hempstead Green roof
RE-1904 Clarkson Laboratory Renovation La Croix Stormwater
LA-5276 Alumni Center Landscape Hempstead Materials
RE-1922 Founders House Renovation Hempstead Solar panels
RE-1957 Nakamura Physics Renovation Hempstead Materials
RE-1961 Grounds and Building Renovation Newburgh Stormwater
RE-1977 Thorne Family Pavilion Renovation La Croix Solar panels
RE-1982 121 Forest Street Renovation Hempstead Materials
EX-4242 Kao Performance Center Expansion Hempstead Materials
NE-3209 Whitman Child Care New construction La Croix Solar panels
RE-1953 Riverfront Graduate Housing Renovation Hempstead Materials
LA-5303 Student Commons Landscape La Croix Materials
NE-3301 Politzer Center New construction Hempstead Materials
NE-3387 Sills Cultural Center New construction Newburgh Materials
UP-2004 Campus Electrical Upgrade Hempstead Solar panels
LA-5355 Arts Quad Landscape Hempstead Materials
UP-2033 Computing Research Upgrade Hempstead Green roof
NE-3412 Benton Hall of Business New construction Hempstead Materials
EX-4103 Santiago Field Expansion Newburgh Solar panels
LA-5113 Heinrich Mall Landscape Hempstead Materials
NE-3045 Charles Street Entrance New construction Hempstead Materials
UP-2011 Mansfield Observatory Upgrade Hempstead Solar panels
LA-5197 Visitor's Center Landscape La Croix Stormwater
Completed Budget Final Cost Project Type Number Total Cost
2016 $213,475 $225,631 Expansion 5 $743,687
2016 $59,320 $60,600 Landscape 8 $510,261
2017 $82,500 $89,754 New Construction 7 $4,292,507
2017 $62,750 $60,935 Renovation 10 $1,183,113
2017 $689,430 $700,225 Upgrade 3 $369,037
2017 $42,500 $42,850
2018 $55,750 $56,127 Final Cost
2018 $195,640 $200,326 >100000
2018 $48,700 $48,850 Number of Projects: 16
2018 $109,800 $110,456
2019 $847,400 $889,325 Completed
2019 $78,775 $79,349 2019
2019 $78,300 $78,550 Number of Projects: 9
2019 $32,500 $32,500
2019 $195,600 $199,800 Campus
2019 $78,500 $82,500 Newburgh
2019 $52,500 $52,500 Total Cost: $1,915,559
2019 $153,200 $155,600
2019 $210,750 $220,158 Campus
2020 $285,430 $285,329 Hempstead
2020 $225,000 $234,657 Average Cost: $232,785
2020 $76,500 $79,225
2020 $750,325 $752,855
2020 $575,200 $590,568
2021 $124,865 $154,382
2021 $83,450 $84,072
2021 $179,400 $180,055
2021 $989,500 $990,455
2016 $124,500 $126,507
2017 $76,500 $78,024
2017 $83,750 $83,750
2018 $34,600 $34,600
2018 $37,450 $38,090
Average Cost
$148,737
$63,783
$613,215
$118,311
$123,012
Final Cost Totals Campus
Green Feature Completed Hempstead La Croix Newburgh Total Result
Green roof
2017 $700,225 $700,225
2018 $56,127 $56,127
2019 $889,325 $889,325
2021 $180,055 $180,055
Materials
2016 $60,600 $225,631 $286,231
2017 $251,528 $251,528
2018 $110,456 $110,456
2019 $654,108 $654,108
2020 $987,512 $79,225 $590,568 $1,657,305
2021 $1,074,527 $1,074,527
Solar panels
2016 $126,507 $126,507
2018 $34,600 $34,600
2019 $32,500 $52,500 $85,000
2020 $285,329 $285,329
2021 $154,382 $154,382
Stormwater
2017 $103,785 $103,785
2018 $38,090 $249,176 $287,266
2019 $79,349 $82,500 $161,849
Total Result $4,422,922 $760,124 $1,915,559 $7,098,605
Final Cost Totals Campus
ID Hempstead La Croix Newburgh Total Result
RE-1922 $32,500 $32,500
UP-2011 $34,600 $34,600
LA-5197 $38,090 $38,090
LA-5104 $42,850 $42,850
LA-5218 $48,850 $48,850
RE-1977 $52,500 $52,500
RE-1854 $56,127 $56,127
LA-5066 $60,600 $60,600
EX-4188 $60,935 $60,935
LA-5113 $78,024 $78,024
LA-5276 $78,550 $78,550
LA-5303 $79,225 $79,225
RE-1904 $79,349 $79,349
RE-1961 $82,500 $82,500
NE-3045 $83,750 $83,750
LA-5355 $84,072 $84,072
RE-1751 $89,754 $89,754
EX-4209 $110,456 $110,456
EX-4103 $126,507 $126,507
UP-2004 $154,382 $154,382
RE-1982 $155,600 $155,600
UP-2033 $180,055 $180,055
RE-1957 $199,800 $199,800
RE-1890 $200,326 $200,326
EX-4242 $220,158 $220,158
EX-4096 $225,631 $225,631
RE-1953 $234,657 $234,657
NE-3209 $285,329 $285,329
NE-3387 $590,568 $590,568
NE-3027 $700,225 $700,225
NE-3301 $752,855 $752,855
NE-3153 $889,325 $889,325
NE-3412 $990,455 $990,455
Total Result $4,422,922 $760,124 $1,915,559 $7,098,605
 Data
Project Type Count of ID Final Cost Totals Budget Totals Average of Budget
Expansion 5 $743,687 $721,275 $144,255
Landscape 8 $510,261 $502,720 $62,840
New construction 7 $4,292,507 $4,221,035 $603,005
Renovation 10 $1,183,113 $1,149,965 $114,997
Upgrade 3 $369,037 $338,865 $112,955
Total Result 33 $7,098,605 $6,933,860 $210,117
Final Cost Totals Completed
Project Type Project 2016 2017 2018 2019 2020
New construction $783,975 $889,325 ###
Ambani International Center $889,325
Benton Hall of Business
Bixbury Apartments $700,225
Politzer Center $752,855
Sills Cultural Center $590,568
Whitman Child Care $285,329
Charles Street Entr $83,750
Renovation $89,754 $256,453 $602,249 $234,657
121 Forest Street $155,600
Ardmore House $89,754
Clarkson Laboratory $79,349
Founders House $32,500
Grounds and Building $82,500
Nakamura Physics $199,800
Richardson Hall $200,326
Riverfront Graduate Housing $234,657
Sullivan Library $56,127
Thorne Family Pavilion $52,500
Total Result $873,729 $256,453 $1,491,574 ###
2021 Total Result
$990,455 ###
$889,325
$990,455 $990,455
$700,225
$752,855
$590,568
$285,329
$83,750
###
$155,600
$89,754
$79,349
$32,500
$82,500
$199,800
$200,326
$234,657
$56,127
$52,500
$990,455 ###