HomeMy WebLinkAboutAppendix C 2018 Infrastructure ConceptsEdina Morningside Neighborhood
Flood Risk Reduction Concepts
This report will summarize analysis conducted by Annetta Wilson, Jessica Wilson and Ross Bintner to
define and describe flood risk and consequence for the Morningside Neighborhood in Edina and create a
conceptual framework that could be used to create a scope of work that would compare or judge flood
risk reduction options. The report is conceptual only and should not be relied on for actual
improvement decisions.
Context and Scope
The Morningside neighborhood has a valley and several low or landlocked areas that are prone to
flooding. The neighborhood is fully developed with primarily single family homes built between 1910
and 1960, with some infill happening later and redevelopment currently replacing some structures
(Appendix A.) Stormwater characteristics for the neighborhood are described in greater detail in
chapter 12 of the Comprehensive Water Resources Management Plan (2018 Draft, Barr Engineering).
This document is the Local Water Plan (LWP) for the city.
For this report, flood risk will be described in terms of both the probability and possible consequence of
high water on structures. Two rainfall probabilities modeled in development of the LWP are used in
this analysis, the 1% and 10% probability rainfalls. Assuming normal soil moisture conditions (AEP
neutral conditions), flood probabilities are assumed to be the same as the storm event probabilities
creating the flooding. The possible consequences of flooding are categorized and costs are estimated
assuming homeowners have taken no special effort to limit the consequence of flooding. Annualized
potential costs to homeowners are then estimated to test economic return on possible flood mitigating
infrastructure improvements to this area. Infrastructure improvement options were part of a separate
effort by Barr Engineering. These options are preliminary, non-exhaustive, and not optimized.
A variety of data and analysis was conducted to inform the analysis of flood risk. The following
subsections describe the original data sources (assembled data) and methods used to calculate criteria
relating to flood risk (derived data).
Assembled and Derived Data
Geographical data was assembled from City of Edina sources and new data was derived from the
relationships in the data to inform the flood risk analysis. The following is a summary of data and
methods. The development of methodology to derive adjacent ground elevations based on LIDAR and
home shape has applicability outside this study and is described in greater detail in Appendix B.
Assembled Data:
• Digital Elevation Map (DEM) from 2011-2012 Minnesota DNR LIDAR data with 5cm accuracy
• Subwatershed and Sewershed data (City of Edina)
• Building Footprints originally from 2002 Markhurd, Updated by City of Edina with 2012 and
2015 based on Hennepin County joint aerial photograph project
• Lot surveys from City of Edina Building Department records
• Property ID (PID), building year built, livable total and basement square footage, finished
basement %, building sales data, and building market values data from the City Assessor
• City of Edina Datalink Map, Google Streetview, Google search for Real Estate sale pictures and
descriptions of homes, Site visits
• 10% and 1% probability inundation polygon and elevation data from 2018 Comprehensive Water
Resources Management Plan.
• 2017 Flood Loss Estimations Table (Source: National Food Services, FloodTools.com, based on
national FEMA flood loss tables)
• Potential flood risk mitigation options from Barr Engineering
Derived Data:
• The following general data was derived from the assembled data to inform the analysis.
Minimum, maximum, and average adjacent grade elevations. Adjacent grades were calculated by
comparing DEM and building footprint clips using the method described in Appendix B.
The following building elevations data were derived
• Basement type was determined by looking at the elevation profile and StreetView. If it wasn’t
easy to see in StreetView or determine from the profile, the address was Google searched to
find Real Estate information and additional pictures of the house. If those were unavailable, the
site was visited to see in person, while remaining on city property. See the appendix for more
information on how the basement type was used in the elevation calculations.
• Building elevations; Elevations were overwritten if a survey was found in Building Department
survey data. Data source was recorded in a note field. Detailed information about building
elevation calculations can be found in Appendix B.
The following attributes were calculated using the derived adjacent grades:
• Low floor elevation was calculated by subtracting 8 feet from the maximum adjacent elevation
• Low opening elevation was equated to the minimum adjacent ground elevation.
• Garage floor elevation was equated to the maximum adjacent ground elevation.
• First floor elevation was calculated by adding 1 foot to the maximum adjacent ground elevation.
• The Elevation Difference was calculated by subtracting the minimum adjacent ground elevation
from the maximum adjacent ground elevation.
Property characteristics and property value were calculated to inform the analysis of consequence of
flood risk:
• Number of Sales was calculated from Excel Pivot Table using data from Assessor’s Office (see
appendix)
• Value per Square Foot was calculated (Building MV/Square Footage)
• Subwatersheds names of subwatersheds that intersect with building footprint
Analysis of Structural Flood Probability
For this analysis flood probability is categorized based on various ways water can intrude into residential
dwelling structures based on the following scheme. The thresholds defined in this scheme allow an
in/not in trigger to describe flood risk at varying probability storms and are not based on a literature
review of studies on flood effects on varying structures. A cursory review for similar work turned up
many interesting concepts, but no direct examples or industry standards that detail flood risk at this
granular a scale. The thresholds defined here are based on professional judgement and are obviously not
definitive. The categories are used to define probability of damage to each vector of flood risk.
Direct flood risk is from waters that overtop the foundation block and saturate and infiltrate through
wood framed portions of a home, overtop and flood window wells and collapse windows, or saturate
and infiltrate through low opening elevations such as windows and doors. Direct flood risk will be
categorized as follows:
• Moderate: Peak 1%/10% probability flood elevation is above minimum adjacent grade, but below
or equal to average ground elevation.
• Major: Peak 1%/10% probability is above average adjacent grade, but below or equal to
maximum adjacent grade.
• Severe: Peak 1%/10% probability is above maximum adjacent grade.
See Appendix B for GIS Methodology.
Indirect flood risk is from nearby standing flood waters saturating the ground and causing hydrostatic
pressure on foundations that typically result in water leaking from cracks and joints in foundation block
or concrete slab floors. In severe cases this hydrostatic pressure is known to collapse block
foundations. While these issues can also be attributed to raised groundwater with a variety of causes
such as temporary rises due to rainfall or flow paths, anywhere in the watershed, this category focuses
only on those areas with nearby standing flood waters. Indirect flood risk will be categorized as follows:
• Minor: Peak 1%/10% probability flood elevation in same subwatershed is </= 4’ above basement
elevation but > 2’ above basement elevation
• Moderate: Peak 1%/10% probability flood elevation in same subwatershed is >4’ above basement
elevation
Sanitary flood risk is from flood water in nearby homes subject to direct flooding flowing into the
sanitary sewer system through flooded floor drains and fixtures making its way into the public sanitary
line and overwhelming its capacity causing backup into other homes. Sanitary flood risk will be
categorized as follows:
• Moderate: Home is within the same sanitary sewershed where between 1 and 3 neighboring
homes are subject to Major or Severe Direct Flood Risk and the home is within 250’ of one of
the neighboring Direct Risk homes, and has a basement elevation lower than the flooded
basement plus 1 foot.
• Major: Home is within the same sanitary sewershed where between greater than 3 neighboring
homes are subject to Major or Severe Direct Flood Risk and the home is within 250’ of one of
the Direct Risk homes, and has a basement elevation lower than the flooded basement plus 5
feet.
The flood risk scheme above was compared to derived building low floor elevations to create effective
differential flood elevations for each affected single family dwelling. These differential elevations, along
with property characteristics were used to estimate the consequence of flooding, described in the next
section.
Overall, direct flood risk is the highest risk type followed by sanitary flood risk, with indirect flood risk
being the lowest risk. Since homes often fit into multiple risk types, they were assigned to the highest
risk of their designated risk types.
Figure 1: Morningside 10% Annual Probability Flood Risk
Figure 2: Morningside 1% Annual Probability Flood Risk
Analysis of Flood Consequence
This analysis attempts to create a decision framework to generalize costs of flood risk at the
neighborhood scale by assigning individual probability that any given home will experience damage by any
of the three risk categories described above, using best available data. The cost of flooding is then
annualized based on this probability. Using the same method, the base case condition is then compared
to neighborhood wide potential flood mitigation options.
Methodology
The following steps were used to develop flood consequence on a home by home basis for the base
case and each potential mitigation option. Only primary structures are considered.
1. Generate flood elevations. For this analysis, flood elevations were generated for 50, 20, 10, 4, 2
and 1% probability events by Barr Engineering for the existing conditions, and seven potential
flood mitigation options.
2. Apply elevations to structures. To simplify conditions where a structure was subject to risk from
more than one subwatershed (i.e. located on a subwatershed divide), each structure was assigned
to a single subwatershed, whichever was judged to be highest risk or most significant.
Figure 1:
999.5
1000.0
1000.5
1001.0
1001.5
1002.0
1002.5
1003.0
1003.5
0.0010.0100.1001.000 Peak Flood Elevation (feet)Annual Exceedance Probability
Flood Elevation -Mean
Flood Elevation - Mean
3. Determine possible damages. A square footage estimate of $40 per square foot was used. This
estimate was informed by the referenced FEMA damage tables. The square foot estimate of
damage was then factored for each risk category and a probability of damage was assigned to
factor the square foot rate consistent with the scheme described above, and depicted in the table
below. The probability of damage was based on the trigger elevations set in the section above,
and the probability factor was a guess based on experience.
Table 1:
Probabilities of Damage Occurring, given a mode and a "chance of damage"
factored with percent of maximum damage by mode
Direct
Mode
Direct
Mode2nd
Level
Indirect
Mode
Sanitary
Mode
Minor 0.0 0.0 0.1 0.0
Moderate 0.5 0.0 0.2 0.5
Major 0.9 0.0 0.2 0.8
Severe 1.0 0.5 0.2 0.8
The results are very sensitive to these factors, particularly the indirect mode since it can trigger
at lower elevations with correspondingly more probable events than the other damage types.
The factors are based on feel, and a non-exhaustive review of similar work.
4. Determine elevation damage curves. Basement floor, minimum adjacent grade, average adjacent
grade, and maximum adjacent grade were compared to subwatershed elevation data using the
trigger elevations on the subject home to develop damage curves for each structure for direct
and indirect risk.
Figure 2:
997
998
999
1000
1001
1002
1003
1004
1005
1006
$0 $10 $20 $30 $40 $50 $60 $70 $80 $90 $100Peak Flood Elevation (feet)Damage, Accounting for Probability of Damage
Thousands
Direct Damage Indirect Damage Sanitary Damage
5. Relate damages to annual exceedance probability (AEP). Damages in dollars were related to AEP
using the specified flood level elevations for the assigned subwatershed. Values for intermediate
probabilities were interpolated to create a cost versus probability damage curve for calculating
annualized damages. Two methods for combining risk types were tested, a maximum, and a
combined probability ‘or’ method. The ‘or’ method was used in the analysis.
Figure 3:
6. Calculate total annualized flood risk. The annualized damages were calculated by integrating the
potential damages by the AEP. The annualized expected damages take into account AEP for a
wide range of precipitation events, probability of damages from an event, and potential damage
cost to a home.
$0
$20,000
$40,000
$60,000
$80,000
$100,000
$120,000
0.0010.010.11 Mean Damage, Accounting forProbability of DamageAnnual Exceedance Probability
Maximum Or
𝑅𝑅𝑅𝑅𝑅𝑅𝑅𝑅_$=�(𝐷𝐷𝐷𝐷𝐷𝐷𝐷𝐷𝐷𝐷𝐷𝐷_$)(𝑑𝑑𝑑𝑑𝑑𝑑𝑑𝑑)𝐴𝐴𝐴𝐴𝐴𝐴2
𝐴𝐴𝐴𝐴𝐴𝐴1
Figure 4:
7. Calculate total neighborhood risk. The annualized damage cost for each home was then
summarized for existing conditions to determine the annualized cost impact to the neighborhood
under existing conditions.
8. Repeat steps 1 through 7 for Barr’s proposed flood risk mitigation options. Calculate the total
annualized neighborhood damage for each option, because none of the proposed options will
eliminate all risk of damage.
9. Compare to option cost. The annual benefit for each improvement was calculated by subtracting
the option annualized risk from the existing conditions annualized risk. A 60 year infrastructure
lifecycle was assumed, which is a typical conservative lifecycle estimate for stormwater
infrastructure. The option implementation cost was then annualized by the improvement
lifecycle.. The annualized Benefit Cost Ratio for each solution was calculated dividing the solution
cost avoidance by the annualized solution implementation cost. This simple, straight line
depreciation approach ignores the cost of money. A future refinement could include a present
value analysis.
Results
Potential Flood Mitigation Options
Alt 2b: Increase Storm Sewer Size (up to 60”) and add flood wall at Weber Pond.
Alt 3a: Excavate Weber Field Park, area North of Weber Pond, Open Space 5, area West of Monterey
Ave, and backyard between 44th St and Branson St. Add flood walls at Weber Pond and along Monterey
Ave. Add culvert to Weber Pond to drain north.
$0
$20,000
$40,000
$60,000
$80,000
$100,000
$120,000
0.0010.010.11 Mean Damage, Accounting forProbability of DamageAnnual Exceedance Probability
Or
Alt 4a: Excavate Open Space 5 and do predictive pumping from Open Space 5 and Weber Pond to park
north of Calvin School
Alt 5a: Add Underground Storage to Weber Park and park west of Monterey Ave
Alt 7b: Combination of 3a and 4a
Alt 8: Excavate areas North and West of Weber Pond and add flood wall.
Alt 9: Alt 8 and add Underground Storage at park west of Monterey Ave, and predictive pumping to
Weber Pond.
Table 2: Barr Engineer’s Opinion of Probable Cost for Proposed Flood Mitigation Options
Option Estimated Project Cost Minimum Estimated Cost (-30%) Maximum Estimated Cost (+50%)
Alt 2b $4,469,000.00 $3,129,000.00 $6,704,000.00
Alt 3a $5,069,000.00 $3,549,000.00 $7,604,000.00
Alt 4a $3,444,000.00 $2,411,000.00 $5,166,000.00
Alt 5a $31,681,000.00 $22,177,000.00 $47,522,000.00
Alt 7b $8,507,000.00 $5,955,000.00 $12,761,000.00
Alt 8 $5,179,000.00 $3,626,000.00 $7,769,000.00
Alt 9 $13,786,000.00 $9,651,000.00 $20,679,000.00
Table 3: Number of Homes per Option with Greatest Benefit
Option Homes with Greatest Benefit
Alt 3a 2 homes
Alt 5a 1 home
Alt 7b 69 homes
Alt 8 13 homes
Alt 9 11 homes
Table 4: Damage Risk Change from Existing Conditions
Option Risk Increase Risk Decrease
Alt 2b 15 homes 111 homes
Alt 3a 1 home 117 homes
Alt 4a 1 home 127 homes
Alt 5a 92 homes
Alt 7b 1 home 150 homes
Alt 8 74 homes
Alt 9 136 homes
The homes at increased risk are in the areas where the flood elevation increased as a result of increased
water flow to the associated subwatershed as a result of increased drain size or predictive pumping.
Berms or Flood Walls were included in the options to mitigate direct flood risk, but indirect flood risk
may still be a factor. The increased risk is minimal (less than $1000 annualized for the worst case
scenario).
Table 5: Homes at Risk of Flood Damage by Option
Option Homes at Risk Homes no longer at risk
Current 160 homes
Alt 2b 134 homes 26 homes
Alt 3a 150 homes 11 homes
Alt 4a 154 homes 6 homes
Alt 5a 155 homes 5 homes
Alt 7b 123 homes 38 homes
Alt 8 155 homes 5 homes
Alt 9 126 homes 34 homes
Table 6: Simple Annualized Costs and Benefits by Option (assuming 60 year lifecycle and simple
depreciation of capital cost and no ongoing maintenance)
Table:
Condition
Annual
Damage
Annual
Benefit
Improvement
Cost
Annual
Improvement
Cost Benefit - Cost
Benefit Cost
Ratio
Existing $404,202 --
Alt 2b $287,348 $116,854 $4,469,000.00 $74,483.33 $42,370.82 1.57
Alt 3a $271,606 $132,596 $5,069,000.00 $84,483.33 $48,112.68 1.57
Alt 4a $335,313 $68,889 $3,444,000.00 $57,400.00 $11,489.43 1.20
Alt 5a $326,616 $77,586 $31,681,000.00 $528,016.67 -$450,430.65 0.15
Alt 7b $170,765 $233,437 $8,507,000.00 $141,783.33 $91,654.14 1.65
Alt 8 $337,045 $67,157 $5,179,000.00 $86,316.67 -$19,159.21 0.78
Alt 9 $190,566 $213,636 $13,786,000.00 $229,766.67 -$16,130.51 0.93
Overall Alt 7b has the greatest benefit, based on the benefit cost ratio, greatest benefit to homes, and
number of homes improved or removed from flood risk. Options 5a, 8, and 9 are cost prohibitive, in
which the cost outweighs the benefit. Reducing the assumed lifecycle below 60 years was tested and
Option Alt 7b still is cost beneficial at a lifecycle of 40 years minimum. Increasing the improvement costs
to the maximum estimated in Table 2 still results in Alt 7b being cost beneficial and having the greatest
benefit of the proposed options, but wouldn’t be cost beneficial at a lifecycle below 60 years.
Summary of Options:
None of the mitigation options will eliminate risk, but most will reduce risk with a few exceptions of
increased risk to individual homes. Additional incentives for homeowners to decrease their risk are
recommended such as backflow preventers and sump pumps, in addition to infrastructure improvement.
Alt 2b: This option has a favorable Benefit Cost Ratio (1.57) and improvement cost ($ 4.5MM), but puts
15 homes at greater risk, mostly in the Weber Park area from the larger storm drains upstream. There
are other options that have greater impact.
Alt 3a: This option also has a favorable Benefit Cost Ratio (1.57) and reduces risk in 117 homes, but
only removes 11 homes from risk.
Alt 4a: This option has the lowest improvement cost ($3.4 MM) and decreases risk to 127 homes, but
only removes 6 homes from risk.
Alt 5a: The annualized cost outweighs the benefit for this option.
Alt 7b: This option has the highest Benefit Cost Ratio (1.65), removes the highest number of homes
from risk (38 homes), and also reduces risk in the most homes of all options (150 homes). The only
significant disadvantages are that it increases risk in one home and has the 3rd highest cost ($8.5 MM).
Alt 8: The annualized cost outweighs the benefit
Alt 9: The annualized cost outweighs the benefit
Home Sales Data Inquiry
We tested the hypothesis that homeowners that experience home flood inundation are more likely to
sell their homes. To test for a correlation, sales data was obtained from the assessor’s office for the
Morningside neighborhood. This data was on all sales from 1/1/1970 through 4/27/2018 and included
traditional sales, as well as bank sales, physical change sales (“flipping”), and estate sales. A pivot table
was used to determine the number of sales per home and the data was then added to the ArcMap
Building Data attribute table to calculate the mean number of sales for each flood condition.
Table 7: Morningside Mean Number of Sales per Home:
All homes 10% Surface Inundation
Annual Risk
1% Surface Inundation
Annual Risk
Under 1% Surface
Inundation Annual Risk
2.92 3.06 2.63 2.97
There is a higher mean number of sales per home in the 10% surface risk category, which may show a
correlation, but what this doesn’t take into account is the age of homes built post-1970, which would
have less overall tenure.
Morningside Mean Home Year Built in or post 1970
All homes 10% Surface Inundation
Annual Risk
1% Surface Inundation
Annual Risk
Under 1% Surface
Inundation Annual Risk
2004 1999 1998 2006
Appendix A:
Year Built Statistics for Morningside Single Family Homes:
The Single Family Homes were selected by attribute and the following statistics were generated:
Figure 5: Chart of ArcGIS statistics showing the majority of Morningside homes were built between
1910 and 1960.
Appendix B GIS Methodology:
Home Elevation Methodology
The adjacent grade elevations were calculated in Arc Map, using the DEM (digital elevation map) and
Building Footprint feature class. The DEM was clipped to the building footprints, converted into a
polygon feature class, and then spatially joined back to the Building Footprint feature class to add
minimum, average, and maximum elevations for each footprint. Since the DEM data needs to be in
integers to be converted to a polygon feature class (ArcGIS limitation), the elevation data was converted
from meters to feet and multiplied by 10, and converted to integers using the Map Algebra Tool before
converting to a polygon feature class. Once converted, the data was divided by 10 to get elevation data
to the nearest tenth.
Figure 6: GIS Model of Adjacent Grade Elevation calculation process
Figure 7: Example footprint with elevation data from DEM clip and derived data below.
The first floor and basement elevation data were obtained from the home lot surveys when possible. If
the survey contained a top-of- foundation or TOB (top of block) elevation, 1 foot was added to that
number to account for the sub-floor and floor. If basement elevation data wasn’t available, 9 feet was
subtracted from the First Floor Elevation.
If the lot survey was missing or didn’t contain elevation data, the first floor elevation was calculated by
adding 1 foot to the maximum footprint elevation from the DEM and the basement elevation was
determined by subtraction 8 feet from that elevation (or 9 feet total from the first floor elevation). The
critical structures at risk of surface inundation were also viewed using Street View to confirm the first
floor elevations.
First Floor Elevation: Plan versus Calculated Differences
To test the confidence level of the First Floor Elevation calculation methodology above, the homes with
known First Floor Elevations were selected (238 homes) and the calculated values subtracted from the
plan values to create a difference data. The data was then exported to Excel to be statistically analyzed
and summarized.
Figure 8: Histogram of Plan versus Calculated First Floor Elevation difference
The 95% Confidence Level is 0.2’ with the Mean being 0.17’ and a Standard Deviation of 1.72. 47.7% of
home calculated FFE’s were within ½’ of the plan FFE and 76.4% of home calculated FFE’s were within 1’
of the plan FFE. This is close enough to use for our analysis and to use for future city-wide models.
The difference outlier homes were further analyzed:
The biggest difference home (14.8’ plan above calculated FFE) was built after the LIDAR data was
collected. The landscape was significantly raised to elevate the home out of the flood plain.
The other homes with negative differences were mostly split-level walkout basement homes with FFE’s
below the maximum elevation.
The Basement Elevation calculations were also compared against the plan lFE’s in a total of 97 homes.
0
10
20
30
40
50
60
-8.5-7.5-6.5-5.5-4.5-3.5-2.5-1.5-0.50.51.52.53.54.55.56.57.58.59.510.511.512.513.514.5MoreFrequency Plan - Calculated Difference
First Floor Elevation: Plan versus Calculated
Difference
Figure 9: Histogram of Plan versus Calculated Basement Elevation difference:
The 95% Confidence Level is 0.66’ with the Mean being 0.46’ and a Standard Deviation of 3.28 . 26.8%
of home calculated FFE’s were within ½’ of the plan FFE and 43.3% of home calculated FFE’s were within
1’ of the plan FFE.
The outlier homes correspond with the outliers in the FFE analysis.
Flood Risk GIS Methodology:
In ArcMap, the 1% and 10% inundation shape polygons were overlaid on an elevation relief map (from
the DEM) and carefully inspected to remove false “artifacts” from the Barr model. Others were edited
or removed when new build landscaping elevation was done to increase the home elevation and reduce
the flood risk. Elevation contour lines from the plot surveys were used to reshape the polygons.
After editing the polygons, the structures were matched with their subwatersheds by selecting the
structures that intersected each subwatershed polygon. The subwatershed 1% and 10% inundation
elevations were added for each watershed. Since most structures overlapped 2 or more
subwatersheds, the higher inundation elevation numbers were added, unless there was surface
inundation risk by lower elevation inundation.
To determine surface flood risk, the structures overlapping the 1% and 10% inundation polygons were
selected.
0
2
4
6
8
10
12
-8.5-7.5-6.5-5.5-4.5-3.5-2.5-1.5-0.50.51.52.53.54.55.56.57.58.59.510.511.512.513.514.5Frequency Plan - Calculated Difference
Basement Elevation: Plan versus Calculated
Difference
Direct Flood Risk GIS Methodology:
The data was selected using the commands below for each 1% and 10% risk:
Moderate Flood Risk: Type = ‘Single Family’ AND SurfaceFlood10%/1% = 'Yes' AND (
FloodElevation10%/1% > Minimum Adjacent Elevation) AND ( FloodElevation10%/1% </= Average
Elevation)
Major Flood Risk: Type = ‘Single Family’ AND SurfaceFlood10%/1% = 'Yes' AND (
FloodElevation10%/1% > Average_Elevation ) AND ( FloodElevation10%/1% </=Maximum_Elevation)
Severe Flood Risk: Type = ‘Single Family’ AND SurfaceFlood10%/1% = 'Yes' AND FloodElevation10%/1%
> Maximum_Elevation
Indirect Flood Risk GIS Methodology:
The data was selected using the commands below for each 1% and 10% risk:
Minor: Type = ‘Single Family’AND FloodElevation10%/1% <=( BasementElevation + 4) AND (
FloodElevation10%/1% > BasementElevation)
Moderate: Type = ‘Single Family’AND FloodElevation10%/1% >( BasementElevation + 4)
Sanitary Flood Risk Methodology
Moderate:
• Select by Attributes: DirectFloodRisk 10%/1% = ‘Major’ OR DirectFloodRisk 10%/1% = ‘Severe’
• SanitaryRiskElevation10%/1% = BasementEvelation + 1. Sort the homes from lowest to highest
sanitary risk elevation
• Create a 250’ buffer around the selected homes, using the buffer tool
• Select by location the buildings intersecting the each buffer, starting with the buffer from the
target home with the lowest sanitary elevation and work upwards, since there will be overlap.
• Then select by attributes from that selection Type = ‘Single Family’ AND Sewershed = [the one
from the target home]
• Remove any other target homes with higher sanitary risk elevations from the selection, then
copy the SanitaryRiskElevation for the target home to the rest of the homes in the buffer
• Then Select by Attributes from current selection: SanitaryRiskElevation10%/1% >
BasementElevation. The selected homes will be your Moderate Risk homes
Major: Major is done similar to Moderate, with the following differences:
• Review Moderate flood risk buffers for clusters of over 3 homes with Major or Severe Direct
Flood risk that are on the same sanitary main. Select the buffers of these homes and export
selected to create a new feature class
• Then Select by Attributes: DirectFloodRisk 10%/1% = ‘Major’ OR DirectFloodRisk 10%/1% =
‘Severe’
• SanitaryRiskElevation10%/1% = BasementElevation +5. Sort the homes from lowest to highest
sanitary risk elevation
•Repeat the rest of the steps from the Moderate Sanitary Risk Methodology
Potential Mitigation Option Mapping
The Barr Engineering team helped created an Excel Macro-enabled spreadsheet to calculate and
summarize the annualized risk to each home, based on current conditions and each potential mitigation
option. The annualized risk data for each home and condition was then imported to ArcMap and
merged with the home data feature class.
The risk change was calculated for each option by home by subtracting the risk for the option from the
current condition risk. The homes removed from risk classifications were calculated by applying a
selection criterion for the current risk not equal to zero and the improvement option equaling zero.
These selections were exported as layers for creating the maps below.
3 sets of maps were made with this data:
-A single Greatest Impact map showing the at-risk homes categorized by the option that would
yield the greatest improvement to existing conditions. The greatest improvement option for
each home was calculated by selecting the option with the highest risk changes (positive). The
homes that had multiple options with the same improvement were left out.
-A series of maps depicting the homes at risk for current and each improvement condition. The
maps for the improvement conditions also included a category for the homes removed from risk
for the specified condition. A color gradient was used to show the risk level to each home in
$3000 increments (not noted on the maps to keep confidential).
-A series of maps showing the risk change from existing conditions for the improvement options.
Some of the improvement options had a few homes with increased risk, which were depicted in
red, while the improvement risk decrease amounts (in $3000 increments as above) were shown
on a green gradient. A category showing the homes removed from risk was also shown for each
option.
Resources
References for concept used in creating expected annual damage and damage-exceedance probability
and cost curves;
https://www.nap.edu/read/21720/chapter/5
http://www.naic.org/documents/cipr_study_1704_flood_risk.pdf
https://www.tandfonline.com/doi/pdf/10.1623/hysj.52.5.1016
https://www.fema.gov/media-library-
data/a10327c71a76f7c88d7cf403dcf60f4f/Actuarial_Methods_and_Assumptions_2013-09-04_508.pdf
Weber Field ParkOpen Space 5
Kojetin Park
Open Space 6 France4 4 th Grimes42nd
40th
LynnScottMorningsideAldenKipling
SunnysideCrockerBransonMonterey
45th EtonCur
v
eOakdaleNatchezSidellInglewoodLittelLynnOa
k
d
a
l
e
²
City of Edina Engineering DeptSemptember 2018
Morningside Greatest Impact Flood Mitigation Options
Greatest Impact
Alt3a (2 homes)Alt5a (1 home)Alt7b (69 homes)
Alt8 (13 homes)Alt9 (11 homes)
No Impact
Weber Field ParkOpen Space 5
Kojetin Park
Open Space 6 France4 4 th Grimes42nd
40th
LynnScottMorningsideAldenKipling
SunnysideCrockerBransonMonterey
45th EtonCur
v
eOakdaleNatchezSidellInglewoodLittelLynnOa
k
da
l
e
²
City of Edina Engineering DeptSemptember 2018
Morningside Homes at Risk of Inundation
Existing Conditions (160 homes at risk)
1 - lowest risk
2
3
4
5 - highest risk
No risk
Weber Field ParkOpen Space 5
Kojetin Park
Open Space 6 France4 4 th Grimes42nd
40th
LynnScottMorningsideAldenKipling
SunnysideCrockerBransonMonterey
45th EtonCur
v
eOakdaleNatchezSidellInglewoodLittelLynnOa
k
da
l
e
²
City of Edina Engineering DeptSemptember 2018
Morningside Homes at Risk of Inundation
Option Alt 2b (134 homes at risk)
1 - lowest risk
2
3
4
5 - highest risk
homes removed from risk (26 homes)
No risk
Weber Field ParkOpen Space 5
Kojetin Park
Open Space 6 France4 4 th Grimes42nd
40th
LynnScottMorningsideAldenKipling
SunnysideCrockerBransonMonterey
45th EtonCur
v
eOakdaleNatchezSidellInglewoodLittelLynnOa
k
da
l
e
²
City of Edina Engineering DeptSemptember 2018
Morningside Homes at Risk of Inundation
Option Alt 3a (150 homes at risk)
1 - lowest risk
2
3
4
5 - highest risk
homes removed from risk (11 homes)
No risk
Weber Field ParkOpen Space 5
Kojetin Park
Open Space 6 France4 4 th Grimes42nd
40th
LynnScottMorningsideAldenKipling
SunnysideCrockerBransonMonterey
45th EtonCur
v
eOakdaleNatchezSidellInglewoodLittelLynnOa
k
da
l
e
²
City of Edina Engineering DeptSemptember 2018
Morningside Homes at Risk of Inundation
Option Alt 4a (154 homes at risk)
1 - lowest risk
2
3
4
5 - highest risk
homes removed from risk (6 homes)
No risk
Weber Field ParkOpen Space 5
Kojetin Park
Open Space 6 France4 4 th Grimes42nd
40th
LynnScottMorningsideAldenKipling
SunnysideCrockerBransonMonterey
45th EtonCur
v
eOakdaleNatchezSidellInglewoodLittelLynnOa
k
da
l
e
²
City of Edina Engineering DeptSemptember 2018
Morningside Homes at Risk of Inundation
Option Alt 5a (155 homes at risk)
1 - lowest risk
2
3
4
5 - highest risk
homes removed from risk (5 homes)
No risk
Weber Field ParkOpen Space 5
Kojetin Park
Open Space 6 France4 4 th Grimes42nd
40th
LynnScottMorningsideAldenKipling
SunnysideCrockerBransonMonterey
45th EtonCur
v
eOakdaleNatchezSidellInglewoodLittelLynnOa
k
da
l
e
²
City of Edina Engineering DeptSemptember 2018
Morningside Homes at Risk of Inundation
Option Alt 7b (123 homes at risk)
1 - lowest risk
2
3
4
5 - highest risk
homes removed from risk (38 homes)
No risk
Weber Field ParkOpen Space 5
Kojetin Park
Open Space 6 France4 4 th Grimes42nd
40th
LynnScottMorningsideAldenKipling
SunnysideCrockerBransonMonterey
45th EtonCur
v
eOakdaleNatchezSidellInglewoodLittelLynnOa
k
da
l
e
²
City of Edina Engineering DeptSemptember 2018
Morningside Homes at Risk of Inundation
Option Alt 8 (155 homes at risk)
1 - lowest risk
23
4
5 - highest risk
homes removed from risk (5 homes)
No risk
Weber Field ParkOpen Space 5
Kojetin Park
Open Space 6 France4 4 th Grimes42nd
40th
LynnScottMorningsideAldenKipling
SunnysideCrockerBransonMonterey
45th EtonCur
v
eOakdaleNatchezSidellInglewoodLittelLynnOa
k
da
l
e
²
City of Edina Engineering DeptSemptember 2018
Morningside Homes at Risk of Inundation
Option Alt 9 (126 homes at risk)
1 - lowest risk
2
3
4
5 - highest risk
homes removed from risk (34 homes)
No risk
Weber Field ParkOpen Space 5
Kojetin Park
Open Space 6 France4 4 th Grimes42nd
40th
LynnScottMorningsideAldenKipling
SunnysideCrockerBransonMonterey
45th EtonCur
v
eOakdaleNatchezSidellInglewoodLittelLynnOa
k
d
a
l
e
²
City of Edina Engineering DeptSemptember 2018
Morningside Flood Risk Change by Mitigation Option
Option Alt 2b
1 - small risk increase
no change
1 - small risk decrease23
45 - large risk decrease
removed from risk
Proposed Berm around Weber Pond may mitigate increased flood risk to surrounding homes
Weber Field ParkOpen Space 5
Kojetin Park
Open Space 6 France4 4 th Grimes42nd
40th
LynnScottMorningsideAldenKipling
SunnysideCrockerBransonMonterey
45th EtonCur
v
eOakdaleNatchezSidellInglewoodLittelLynnOa
k
d
a
l
e
²
City of Edina Engineering DeptSemptember 2018
Morningside Flood Risk Change by Mitigation Option
Option Alt 3a
1 - small risk increase
no change
1 - small risk decrease
2345 - large risk decrease
removed from risk
Proposed Flood Wall may mitigate increasedrisk to home
Weber Field ParkOpen Space 5
Kojetin Park
Open Space 6 France4 4 th Grimes42nd
40th
LynnScottMorningsideAldenKipling
SunnysideCrockerBransonMonterey
45th EtonCur
v
eOakdaleNatchezSidellInglewoodLittelLynnOa
k
d
a
l
e
²
City of Edina Engineering DeptSemptember 2018
Morningside Flood Risk Change by Mitigation Option
Option Alt 4a
1 - small risk increase
no change
1 - small risk decrease23
45 - large risk decrease
removed from risk
Weber Field ParkOpen Space 5
Kojetin Park
Open Space 6 France4 4 th Grimes42nd
40th
LynnScottMorningsideAldenKipling
SunnysideCrockerBransonMonterey
45th EtonCur
v
eOakdaleNatchezSidellInglewoodLittelLynnOa
k
d
a
l
e
²
City of Edina Engineering DeptSemptember 2018
Morningside Flood Risk Change by Mitigation Option
Option Alt 5a
no change
1 - small risk decrease
2345 - large risk decrease
removed from risk
Weber Field ParkOpen Space 5
Kojetin Park
Open Space 6 France4 4 th Grimes42nd
40th
LynnScottMorningsideAldenKipling
SunnysideCrockerBransonMonterey
45th EtonCur
v
eOakdaleNatchezSidellInglewoodLittelLynnOa
k
d
a
l
e
²
City of Edina Engineering DeptSemptember 2018
Morningside Flood Risk Change by Mitigation Option
Option Alt 7b
1 - small risk increase
no change
1 - small risk decrease
2345 - large risk decrease
removed from risk
Proposed Flood Wall may mitigate increasedrisk to home
Weber Field ParkOpen Space 5
Kojetin Park
Open Space 6 France4 4 th Grimes42nd
40th
LynnScottMorningsideAldenKipling
SunnysideCrockerBransonMonterey
45th EtonCur
v
eOakdaleNatchezSidellInglewoodLittelLynnOa
k
d
a
l
e
²
City of Edina Engineering DeptSemptember 2018
Morningside Flood Risk Change by Mitigation Option
Option Alt 8
no change
1 - small risk decrease
2345 - large risk decrease
removed from risk
Weber Field ParkOpen Space 5
Kojetin Park
Open Space 6 France4 4 th Grimes42nd
40th
LynnScottMorningsideAldenKipling
SunnysideCrockerBransonMonterey
45th EtonCur
v
eOakdaleNatchezSidellInglewoodLittelLynnOa
k
d
a
l
e
²
City of Edina Engineering DeptSemptember 2018
Morningside Flood Risk Change by Mitigation Option
Option Alt 9
no change
1 - small risk decrease
2345 - large risk decrease
removed from risk
Barr Engineering Co. 4300 MarketPointe Drive, Suite 200, Minneapolis, MN 55435 952.832.2600 www.barr.com
Memorandum
To: Jessica Wilson and Ross Bintner, City of Edina From: Cory Anderson, Sarah Stratton, and Janna Kieffer Subject: Morningside Neighborhood Flood Risk Reduction Strategy Conceptual Study Date: November 19, 2018 Project: 23271649.00
1.0 Purpose of Project and Project Background
This technical memorandum summarizes Barr Engineering Co.’s (Barr’s) preliminary evaluation and
conceptual design of potential flood risk reduction options for the Morningside neighborhood within the
city of Edina. This work included a high-level evaluation of potential flood risk reduction options and
development of associated planning-level opinion of probable construction costs. In parallel to Barr’s
work, city of Edina staff (City) have been working on an approach for summarizing impacted structures
and estimating potential flood damages and we understand that this damage information (dollars) will be
used in conjunction with the estimated project cost data developed by Barr to help City staff further
evaluate the costs and benefits of flood risk reduction opportunities in the study area.
2.0 Description of Existing Conditions
The Morningside/Weber Park area is described in the City’s 2018 Comprehensive Water Resources
Management Plan (CWRMP, reference (1)):
The Morningside/Weber Park area is in the far northeastern corner of Edina, bordering St. Louis Park to the
north and Minneapolis to the east. The area is characterized by numerous backyard depressions and several
large low-lying areas, including Weber Park. There are two large stormwater detention basins in the area,
one located just north of West 42nd Street between Lynn Avenue and Kipling Avenue, and the other located
just north of West 42nd Street and west of France Avenue South (in Weber Park). The area is drained by a
piped outlet that conveys stormwater to Lake Bde Maka Ska (formerly named Lake Calhoun) in Minneapolis.
The storm sewer and detention basins in this area were originally designed for the 2-percent-annual-chance
(50-year) storm event using TP-40 rainfall frequency estimates. Portions of this area have experienced flood
problems historically.
Model results indicate that approximately 65 principle structures and Avail Academy – Edina Campus
(formerly Calvin Christian School) may be directly impacted by the 1-percent-annual-chance (100-year)
flood elevations within this area. In the west part of this area, the flood elevation is approximately 872.1 feet
(subwatershed MS_26). In the southwest part of this area, the flood elevation is approximately 871.7 feet
(subwatershed MS_15). In the southeast part of this area, the flood elevation is approximately 870.1 feet
To: Jessica Wilson and Ross Bintner, City of Edina From: Cory Anderson, Sarah Stratton, and Janna Kieffer Subject: Morningside Neighborhood Flood Risk Reduction Strategy Conceptual Study Date: November 19, 2018 Page: 2
P:\Mpls\23 MN\27\23271649 Morningside FRRS Study\WorkFiles\Technical Summary Memo\Morningside FRRS Exec Summary Memo_11192018.docx
(subwatershed MS_52). In subwatersheds MS_40 and MS_39a and MS_39b, the flood elevation is 870.0 feet.
In the smaller depressions without outlets to storm sewer such as subwatersheds MS_58, MS_20, MS_22,
MS_57, MS_17, and MS_24, the peak flood elevations are 872.9 feet, 877.3 feet, 872.4 feet, 902.5 feet, 902.5
feet, and 872.1 feet respectively. Flood elevations in subwatersheds MS_20 and MS_22 are controlled by the
10-day snowmelt event, while flood elevations in the remaining subwatersheds are controlled by the 24-
hour duration event.
Flood inundation mapping for the 1-percent-annual-chance (100-year) and the 10-percent-annual-chance
(10-year) storm events can be found on Figure 12.3 of the CWRMP and on the City’s Interactive Web Map.
3.0 Potential Flood Risk Reduction Options
Several potential flood risk reduction options were evaluated using the City’s XP-SWMM model. Five
storm recurrence intervals (i.e., 5-year, 10-year, 25-year, 50-year, and 100-year 24-hour storm events) were
simulated for each flood risk reduction option to help understand the amount of improvement each
option can achieve depending on the severity of the rainfall event. Barr conducted a cursory evaluation of
potentially impacted structures for each potential flood risk reduction option to assess which options
provided the greatest level of flood risk reduction (in terms of a reduction in the number of impacted
structures). The seven options that provided the greatest level of flood risk reduction are described below
and additional details are also shown on the figures included in Attachment A.
• Option 2b: Increase the size of the main trunk storm sewer along West 42nd Street and Crocker
Avenue (up to 60”), including some of the lateral storm sewer (e.g., along Grimes Avenue, 24” to
48”), and construct a flood wall on the east and south sides of Weber Pond, between the pond
and the adjacent residential properties, tying into West 42nd Street on the south side of Weber
Pond (Figure A-1).
• Option 3a: Provide additional flood storage by excavating (i.e., lowering) the ballfield area of
Weber Park and reconstructing the fields, excavating the wooded area north of Weber Pond,
excavating and re-grading the low area between Lynn Avenue and Kipling Avenue north of West
42nd Street, lowering the open area between Susan Lindgren Elementary School and Monterey
Avenue (Yale Gardens Park), and excavating some of the backyards between 44th Street and
Branson Street. Additionally, construct a flood wall on the east and south sides of Weber Pond,
between the pond and the adjacent residential properties (also included in Option 2b), and
construct an earthen berm along the west side of Monterey Avenue between West 41st Street and
West 42nd Street. This option would also include installation of a culvert to connect Weber Pond
to the newly excavated storage in the wooded area north of West 41st Street (Figure A-2).
• Option 4a: Provide additional flood storage by excavating and re-grading the low area between
Lynn Avenue and Kipling Avenue north of West 42nd Street, and installing predictive pumping
To: Jessica Wilson and Ross Bintner, City of Edina From: Cory Anderson, Sarah Stratton, and Janna Kieffer Subject: Morningside Neighborhood Flood Risk Reduction Strategy Conceptual Study Date: November 19, 2018 Page: 3
P:\Mpls\23 MN\27\23271649 Morningside FRRS Study\WorkFiles\Technical Summary Memo\Morningside FRRS Exec Summary Memo_11192018.docx
systems from the aforementioned low area and Weber Pond to the park (Minikahda Vista Park)
north of Avail Academy – Edina Campus to free up flood storage capacity prior to significant
rainfall events (Figure A-3). The predictive pumping rates were chosen to draw down these two
water bodies from their normal levels to about 6-inches of water depth over a 24 hour period
(recognizing that predicting storms more than 24 hours in advance is challenging). For modeling
purposes, the pumping rates were assumed to be the same regardless of predicted precipitation
amounts in order to maximize available flood storage.
• Option 5a: Provide additional flood storage by installing underground storage in Weber Park
and the open area between Susan Lindgren Elementary School and Monterey Avenue (Yale
Gardens Park). Water would be diverted from the storm sewer to the underground storage by
installing three diversion weirs in the existing storm sewer manholes (Figure A-4). Pumps would
be used to draw down water levels in the underground storage after precipitation events (one
pump in each underground storage unit).
• Option 7b: A combination of Options 2b, 3a, and 4a (Figure A-5), which includes:
o Increasing the size of the trunk storm sewer along West 42nd Street and Crocker Avenue
(up to 60”) and some of the lateral storm sewer (e.g., along Grimes Avenue, 24” to 48”)
o Excavating additional flood storage in the low area between Lynn Avenue and Kipling
Avenue
o Installing predictive pumping systems
o Excavating (lowering) the open area between Susan Lindgren Elementary School and
Monterey Avenue (Yale Gardens Park)
o Constructing an earthen berm west of Monterey Avenue
o Constructing a flood wall east and south of Weber Pond
• Option 8: A more simple variant of Option 3a (Figure A-6), which includes:
o Excavating (i.e., lowering) the ballfields in Weber Park and excavating (to a greater extent,
and deeper, than in Option 3a) the wooded area north of Weber Pond
o Constructing a flood wall east and south of Weber Pond
o Modifying (lowering) the inverts of the storm sewer pipe from Weber Pond to
Minneapolis so that the normal water level of Weber Pond can be lowered by less than 2
feet.
• Option 9: A combination of Option 2b, parts of 5a, and 8 (Figure A-7), which includes:
o Increasing the size of the trunk storm sewer along West 42nd Street and Crocker Avenue
(up to 60”) and some of the lateral storm sewer (e.g., along Grimes Avenue, 24” to 48”)
o Constructing a flood wall on the east and south sides of Weber Pond
To: Jessica Wilson and Ross Bintner, City of Edina From: Cory Anderson, Sarah Stratton, and Janna Kieffer Subject: Morningside Neighborhood Flood Risk Reduction Strategy Conceptual Study Date: November 19, 2018 Page: 4
P:\Mpls\23 MN\27\23271649 Morningside FRRS Study\WorkFiles\Technical Summary Memo\Morningside FRRS Exec Summary Memo_11192018.docx
o Excavating (i.e., lowering) the ballfields at Weber Park and excavating (to a greater extent)
the wooded area north of Weber Pond.
o Modifying (lowering) the inverts of the storm sewer from Weber Pond to Minneapolis so
that the normal water level of Weber Pond can be lowered by less than 2 feet.
o Installing underground storage in Yale Gardens Park, the required diversion weir in the
nearby manhole structure, and the low-flow pump to drain the stored water.
4.0 Results
Barr provided tables of peak flood elevations to the City for a subsequent analysis of flood consequences
and damages (reference (2)). The tables summarized flood elevations, by subwatershed, under existing
conditions and under each of the seven flood risk reduction options for each of the five modeled
recurrence intervals. Barr and City staff then developed a method to estimate flood damages based on
the peak flood elevations and approximate home elevations. The goal of the analysis was to estimate
flood risk and associated impacts at a neighborhood-scale for varying storm events. The flood damage
estimates reflect “loss potential” in dollars, based on estimated flood loss potential tables published by
the Federal Emergency Management Agency (FEMA) (reference (3)) and assumptions or judgments about
the probability of damage given a flood level relative to the assumed (LiDAR-based) home elevations.
The methodology for quantifying flood risk accounts for probability of flood events, probability of
damage, and the magnitude of damages for existing conditions and for each of the seven flood risk
reduction options. This approach for quantifying flood risk considers damage due to potential direct
flooding of homes at the surface, indirect flooding of homes via groundwater, and flooding of homes via
sanitary sewer backups. The results are detailed in the City’s documentation (reference (4)) and are
summarized below to provide a comparison of relative flood risk reduction in terms of the number of
impacted principle structures. Please note that in the City’s documentation and the summary provided
below, principle structures are referred to as “homes”. Additionally, homes that are referred to as
“removed from risk” in the summary below are homes that are no longer at risk of damage by the three
damage modes considered for storm events that have a 1%, or greater, chance of occurring each year;
however, no home is ever removed from all flood risk. Homes described as “increased risk” would expect
higher peak flood levels for some or all of the storm events modeled, and subsequently, higher expected
damages in dollars. Conversely, homes described as “decreased risk” would expect lower peak flood levels
for some or all of the storm events modeled, and subsequently lower expected damages in dollars.
• Option 2b: 26 homes were completely removed from risk, the risk was decreased for 111 homes
throughout the area, and the risk was increased for 15 homes. These 15 homes are primarily
around Weber Pond where water would accumulate due to the additional conveyance of storm
sewer upstream. 6 of those homes where the risk increased would be protected by the flood wall,
increasing the total number of homes removed from risk to 32.
To: Jessica Wilson and Ross Bintner, City of Edina From: Cory Anderson, Sarah Stratton, and Janna Kieffer Subject: Morningside Neighborhood Flood Risk Reduction Strategy Conceptual Study Date: November 19, 2018 Page: 5
P:\Mpls\23 MN\27\23271649 Morningside FRRS Study\WorkFiles\Technical Summary Memo\Morningside FRRS Exec Summary Memo_11192018.docx
• Option 3a: 11 homes were completely removed from risk, the risk was decreased for 117 homes
throughout the area, and the risk was increased for one home, which is near Yale Gardens Park
where additional storage and the earthen berm would allow water to be stored to a higher
elevation. However, the berm would separate this home from the stored water and it would be
protected, increasing the total number of homes removed from risk to 12.
• Option 4a: 6 homes were completely removed from risk, the risk was decreased for 127 homes
throughout the area, and the risk was increased for 1 home. This 1 house is east of Weber Pond.
Refinement of the predictive pumping scheme may help in further protecting this home.
• Option 5a: 5 homes were completely removed from risk, the risk was decreased for 92 homes
throughout the area, and the risk was not increased for any homes.
• Option 7b: 38 homes were completely removed from risk, the risk was decreased for 150 homes
throughout the area, and the risk was increased for 1 home. This 1 house is near Yale Gardens
Park where additional storage and the earthen berm would store water higher. However, the
berm would separate this home from the stored water and it would be protected, increasing the
total number of homes removed from risk to 39.
• Option 8: 5 homes were completely removed from risk, the risk was decreased for 74 homes
throughout the area, and the risk was not increased for any homes.
• Option 9: 34 homes were completely removed from risk, the risk was decreased for 136 homes
throughout the area, and the risk was not increased for any homes.
5.0 Planning-Level Opinion of Probable Construction Cost
The Engineer’s planning-level opinions of probable construction cost have been developed for each of the
flood risk reduction options discussed in Section 3.0 and are included as Attachment B. The planning-
level opinions of probable construction cost are intended to provide assistance in evaluating and
comparing flood risk reduction options and should not be assumed as absolute values for given options.
These opinions of probable cost generally correspond to standards established by the Association for the
Advancement of Cost Engineering (AACE). This cost estimate is characterized by limited project definition,
wide-scale use of parametric models to calculate estimated costs (i.e., making extensive use of order-of-
magnitude costs from similar projects or proposals), and uncertainty. At this stage of planning, the range
of uncertainty of total project cost is high. Due to the early stage of the project, it is standard practice to
place a broad accuracy range around the point cost estimate. The estimated accuracy range for the
opinions of probable cost developed as part of this analysis is -30% to +50%. All estimated construction
costs are presented in 2018 U.S. dollars and include costs for engineering and project administration.
Quantities are estimated with calculations based on site development assumptions as described for each
potential flood risk reduction option. Dimensions, areas and volumes were assumed based on LiDAR
elevation data and current understanding of proposed grading. For each potential flood risk reduction
To: Jessica Wilson and Ross Bintner, City of Edina From: Cory Anderson, Sarah Stratton, and Janna Kieffer Subject: Morningside Neighborhood Flood Risk Reduction Strategy Conceptual Study Date: November 19, 2018 Page: 6
P:\Mpls\23 MN\27\23271649 Morningside FRRS Study\WorkFiles\Technical Summary Memo\Morningside FRRS Exec Summary Memo_11192018.docx
option considered, planning-level opinion of costs do not include land acquisition or coordination with
residents or other subcontractors.
The opinion of probable cost provided in this report is made on the basis of Barr Engineering’s experience
and qualifications and represents our best judgment as experienced and qualified professionals familiar
with the project. It is acknowledged that additional investigations and additional site specific information
that become available in the next stage of study or design may result in changes to the assumed
configuration, cost and functioning of project features. In addition, because we have no control over the
eventual cost of labor, materials, equipment or services furnished by others, or over the contractor’s
methods of determining prices, or over competitive bidding or market conditions, Barr cannot and does
not guarantee that proposals, bids, or actual costs will not vary from the planning-level opinion of
probable costs presented.
6.0 References
1. City of Edina. 2018 Comprehensive Water Resources Management Plan. Edina, MN : s.n., July 2018.
2. Barr Engineering Co. Annualized Damage Method - Barr to Edina Round 2 - with Macro.xlsm. [Excel File]
September 14, 2018.
3. FEMA. Estimated Flood Loss Potential Tables. Flood Loss Estimations 2017. [Online] [Original data
source: National Flood Services, FloodTools.com] [Cited: September 1, 2018.]
https://www.fema.gov/media-library-data/1499290622913-
0bcd74f47bf20aa94998a5a920837710/Flood_Loss_Estimations_2017.pdf.
4. City of Edina. Edina Morningside Neighborhood Flood Risk Reduction Concepts. Edina, MN : s.n.,
September 2018.
To: Jessica Wilson and Ross Bintner, City of Edina From: Cory Anderson, Sarah Stratton, and Janna Kieffer Subject: Morningside Neighborhood Flood Risk Reduction Strategy Conceptual Study Date: November 19, 2018 Page: 7
P:\Mpls\23 MN\27\23271649 Morningside FRRS Study\WorkFiles\Technical Summary Memo\Morningside FRRS Exec Summary Memo_11192018.docx
Attachment A
Map Figures of the Flood Improvement Options
970 foot flood wall (top elev=871 ft)
456717
45673
France Ave SW 44th St
W 42nd St Grimes Ave W 39th St Ewing Ave SMorningside Rd
W 40th St Alden Dr Scott Ter Lynn Ave Kipling Ave Wood Da
le
Ave
S
Branson St Crocker Ave Monterey Ave Sunnyside Rd Lynn Ave SVallacher Ave Joppa Ave SKipling Ave SNatchez Ave SW 41st St Inglewood Ave SDar
t
A
ve
W 40th La Eaton Pl Ottawa Ave SW 45th StOakdale Ave C
u
r
v
e
A
v
e
Inglewood AveW 42 1/2 St
Colgate
A
v
e
Glendale Ter
Little St Monterey Ave SNatchez Ave Waveland Ter Glenhurst Ave SSunnyside Ave Ewing Ave SOttawa Ave SLynn Ave W 41st St Ottawa Ave SW 40th St
W 45th St Oakdale
Ave
Figure A-1
PROPOSED FLOOD RISK
REDUCTION OPTION -
OPTION 2BMorningside Neighborhood City of Edina
Barr Footer: ArcGIS 10.6, 2018-07-06 12:23 File: I:\Client\Edina\Projects\Morningside FRRS 23271649\Maps\Figure X Option 2b.mxd User: sms
Option 2B Proposed Storm Sewer Size Increase (up to 60")
Option 2B Flood Wall
!>Existing Manhole/Catch Basin
Existing Storm Sewer
Subwatersheds
Parcels 0 240 480Feet
!;N
Note: Vertical datum for all listed elevations is NGVD29
Imagery: USDA NRCS NAIP, 2017
Excavate 4.3 ac-ft580 foot berm (top elev = 874 ft)
Excavate 16.3 ac-ft970 foot flood wall (top elev = 870 ft)
Excavate 8.0 ac-ft
Excavate 13.6 ac-ft
Excavate 2.3 ac-ft
456717
45673
France Ave SW 44th St
W 42nd St Grimes Ave W 39th St Ewing Ave SMorningside Rd
W 40th St Alden Dr Scott Ter Lynn Ave Kipling Ave Wood Da
le
Ave
S
Branson St Crocker Ave Sunnyside Rd Lynn Ave SVallacher Ave Joppa Ave SKipling Ave SNatchez Ave SW 41st St Inglewood Ave SDar
t
A
ve
W 40th La Eaton Pl Ottawa Ave SW 45th StOakdale Ave Cu
r
v
e
A
v
e
W 42 1/2 St
Colgate
A
v
e
Glendale Ter
Little St Monterey Ave SNatchez Ave Waveland Ter Glenhurst Ave SSunnyside Ave Ewing Ave SOttawa Ave SLynn Ave W 41st St Ottawa Ave SW 40th St
W 45th St Oa
k
da
le
A
ve
Figure A-2
PROPOSED FLOOD RISK
REDUCTION OPTION - OPTION 3AMorningside Neighborhood City of Edina
Barr Footer: ArcGIS 10.6, 2018-07-06 12:22 File: I:\Client\Edina\Projects\Morningside FRRS 23271649\Maps\Figure X Option 3a.mxd User: sms
Option 3A Berm / Flood Wall
Option 3A Excavation
Option 3A Culvert
!>Existing Manhole/Catch Basin
Existing Storm Sewer
Subwatersheds
Parcels 0 240 480Feet
!;N
Imagery: USDA NRCS NAIP, 2017
Note: Vertical datum for all listed elevations is NGVD29
456717
45673
France Ave SW 44th St
W 42nd St Grimes Ave W 39th St Ewing Ave SMorningside Rd
W 40th St Alden Dr Scott Ter Lynn Ave Kipling Ave Wood Da
le
Ave
S
Branson St Crocker Ave Monterey Ave Sunnyside Rd Lynn Ave SVallacher Ave Joppa Ave SKipling Ave SNatchez Ave SW 41st St Inglewood Ave SDar
t
A
ve
W 40th La Eaton Pl Ottawa Ave SW 45th StOakdale Ave C
u
r
v
e
A
v
e
Inglewood AveW 42 1/2 St
Colgate
A
v
e
Glendale Ter
Little St Monterey Ave SNatchez Ave Waveland Ter Glenhurst Ave SSunnyside Ave Ewing Ave SOttawa Ave SLynn Ave W 41st St Ottawa Ave SW 40th St
W 45th St Oakdale
Ave
Figure A-3
PROPOSED FLOOD RISK
REDUCTION OPTION - OPTION 4AMorningside Neighborhood City of Edina
Barr Footer: ArcGIS 10.6, 2018-07-06 12:26 File: I:\Client\Edina\Projects\Morningside FRRS 23271649\Maps\Figure X Option 4a.mxd User: sms
Option 4A Predictive Pumping
Option 4A Excavation
!>Existing Manhole/Catch Basin
Existing Storm Sewer
Subwatersheds
Parcels 0 240 480Feet
!;N
Imagery: USDA NRCS NAIP, 2017
Note: Vertical datum for all listed elevations is NGVD29
Excavate 9.4 ac-ft
Predictive Pumping at 4.2 cfs for 24 hrs Predictive Pumping at 9.3 cfs for 24 hrs
456717
45673
France Ave SW 44th St
W 42nd St Grimes Ave W 39th St Ewing Ave SMorningside Rd
W 40th St Alden Dr Scott Ter Lynn Ave Kipling Ave Wood Da
le
Ave
S
Branson St Crocker Ave Monterey Ave Sunnyside Rd Lynn Ave SVallacher Ave Joppa Ave SKipling Ave SNatchez Ave SW 41st St Inglewood Ave SDar
t
A
ve
W 40th La Eaton Pl Ottawa Ave SW 45th StOakdale Ave C
u
r
v
e
A
v
e
Inglewood AveW 42 1/2 St
Colgate
A
v
e
Glendale Ter
Little St Monterey Ave SNatchez Ave Waveland Ter Glenhurst Ave SSunnyside Ave Ewing Ave SOttawa Ave SLynn Ave W 41st St Ottawa Ave SW 40th St
W 45th St Oakdale
Ave
Figure A-4
PROPOSED FLOOD RISK
REDUCTION OPTION - OPTION 5AMorningside Neighborhood City of Edina
Barr Footer: ArcGIS 10.6, 2018-07-06 15:53 File: I:\Client\Edina\Projects\Morningside FRRS 23271649\Maps\Figure X Option 5a.mxd User: sms
Option 5A Underground Storage
Option 5A Weir
!>Existing Manhole/Catch Basin
Existing Storm Sewer
Subwatersheds
Parcels 0 240 480Feet
!;N
Note: Vertical datum for all listed elevations is NGVD29
Imagery: USDA NRCS NAIP, 2017
Underground Storage 5.7 ac-ft Underground Storage 47.6 ac-ft
970 foot flood wall (top elev = 871 ft)
Excavate 4.3 ac-ft580 foot berm (top elev = 874 ft)
456717
45673
France Ave SW 44th St
W 42nd St Grimes Ave W 39th St Ewing Ave SMorningside Rd
W 40th St Alden Dr Scott Ter Lynn Ave Kipling Ave Wood Da
le
Ave
S
Branson St Crocker Ave Monterey Ave Sunnyside Rd Lynn Ave SVallacher Ave Joppa Ave SKipling Ave SNatchez Ave SW 41st St Inglewood Ave SDar
t
A
ve
W 40th La Eaton Pl Ottawa Ave SW 45th StOakdale Ave Cu
r
v
e
A
v
e
Inglewood Ave W 42 1/2 St
Colgate
A
v
e
Glendale Ter
Little St Monterey Ave SNatchez Ave Waveland Ter Glenhurst Ave SSunnyside Ave Ewing Ave SOttawa Ave SLynn Ave W 41st St Ottawa Ave SW 40th St
W 45th St Oakdale
Ave
Figure A-5
PROPOSED FLOOD RISK
REDUCTION OPTION - OPTION 7BMorningside Neighborhood City of Edina
Barr Footer: ArcGIS 10.6, 2018-07-06 12:35 File: I:\Client\Edina\Projects\Morningside FRRS 23271649\Maps\Figure X Option 7b.mxd User: sms
Option 3A Berm / Flood Wall
Option 4A Predictive Pumping
Option 4A Excavation
Option 3A Excavation
!>Existing Manhole/Catch Basin
Existing Storm Sewer
Subwatersheds
Parcels 0 240 480Feet
!;N
Imagery: USDA NRCS NAIP, 2017
Note: Vertical datum for all listed elevations is NGVD29
Excavate 2.3 ac-ft
Excavate 9.4 ac-ft
Predictive Pumping at 9.3 cfs for 24 hrs
Predictive Pumping at 4.2 cfs for 24 hrs
456717
45673
France Ave SW 44th St
W 42nd St Grimes Ave W 39th St Ewing Ave SMorningside Rd
W 40th St Alden Dr Scott Ter Lynn Ave Kipling Ave Wood Da
le
Ave
S
Branson St Crocker Ave Monterey Ave Sunnyside Rd Lynn Ave SVallacher Ave Joppa Ave SKipling Ave SNatchez Ave SW 41st St Inglewood Ave SDar
t
A
ve
W 40th La Eaton Pl Ottawa Ave SW 45th StOakdale Ave Cu
r
v
e
A
v
e
Inglewood AveW 42 1/2 St
Colgate
A
v
e
Glendale Ter
Little St Monterey Ave SNatchez Ave Waveland Ter Glenhurst Ave SSunnyside Ave Ewing Ave SOttawa Ave SLynn Ave W 41st St Ottawa Ave SW 40th St
W 45th St Oakdale
Ave
Figure A-6
PPROPOSED FLOOD RISK
REDUCTION OPTION - OPTION 8Morningside Neighborhood City of Edina
Barr Footer: ArcGIS 10.6, 2018-07-06 12:49 File: I:\Client\Edina\Projects\Morningside FRRS 23271649\Maps\Figure X Option 8.mxd User: sms
Option 8 Proposed Storm Sewer Invert Changes
Option 8 Berm
Option 8 Excavation
Option 8 Culvert
!>Existing Manhole/Catch Basin
Existing Storm Sewer
Subwatersheds
Parcels
0 240 480Feet
!;N
Note: Vertical datum for all listed elevations is NGVD29
Imagery: USDA NRCS NAIP, 2017
Excavate 16.3 ac-ftLower NWL by 1.93 ft 970 foot flood wall (top elev = 870 ft)
Excavate 23.3 ac-ft
456717
45673
France Ave SW 44th St
W 42nd St Grimes Ave W 39th St Ewing Ave SMorningside Rd
W 40th St Alden Dr Scott Ter Lynn Ave Kipling Ave Wood Da
le
Ave
S
Branson St Crocker Ave Monterey Ave Sunnyside Rd Lynn Ave SVallacher Ave Joppa Ave SKipling Ave SNatchez Ave SW 41st St Inglewood Ave SDar
t
A
ve
W 40th La Eaton Pl Ottawa Ave SW 45th StOakdale Ave C
u
r
v
e
A
v
e
Inglewood AveW 42 1/2 St
Colgate
A
v
e
Glendale Ter
Little St Monterey Ave SNatchez Ave Waveland Ter Glenhurst Ave SSunnyside Ave Ewing Ave SOttawa Ave SLynn Ave W 41st St Ottawa Ave SW 40th St
W 45th St Oakdale
Ave
Figure A-7
PROPOSED FLOOD RISK
REDUCTION OPTION - OPTION 9Morningside Neighborhood City of Edina
Barr Footer: ArcGIS 10.6, 2018-07-06 15:56 File: I:\Client\Edina\Projects\Morningside FRRS 23271649\Maps\Figure X Option 9.mxd User: sms
Option 8 Proposed Storm Sewer Invert Changes
Option 5A Underground Storage
Option 5A Weir
Option 8 Berm
Option 8 Excavation
Option 8 Culvert
!>Existing Manhole/Catch Basin
Existing Storm Sewer
Subwatersheds
Parcels
0 240 480Feet
!;N
Note: Vertical datum for all listed elevations is NGVD29
Imagery: USDA NRCS NAIP, 2017
UndergroundStorage 5.7 ac-ft
Excavate 16.3 ac-ftLower NWL by 1.93 ft 970 foot flood wall (top elev = 870 ft)
Excavate 23.3 ac-ft
To: Jessica Wilson and Ross Bintner, City of Edina From: Cory Anderson, Sarah Stratton, and Janna Kieffer Subject: Morningside Neighborhood Flood Risk Reduction Strategy Conceptual Study Date: November 19, 2018 Page: 15
P:\Mpls\23 MN\27\23271649 Morningside FRRS Study\WorkFiles\Technical Summary Memo\Morningside FRRS Exec Summary Memo_11192018.docx
Attachment B
Engineer’s Opinion of Probable Project Cost for Flood Improvement Options
PREPARED BY: BARR ENGINEERING COMPANY SHEET: 1 OF 7
BY:KJN2 DATE:7/6/2018
FEASIBILITY STUDY CHECKED BY: KAL DATE: 7/6/2018
ENGINEER'S OPINION OF PROBABLE PROJECT COST APPROVED BY:DATE:
PROJECT:Morningside FRRS Study ISSUED:DATE:
LOCATION:City of Edina ISSUED:DATE:
PROJECT #:23/27-1649.00 ISSUED:DATE:
OPINION OF COST - SUMMARY ISSUED:DATE:
Engineer's Opinion of Probable Project Cost
Morningside Flood Mitigation Feasibility Project
Option 2B
Cat.ESTIMATED
No.ITEM DESCRIPTION UNIT QUANTITY UNIT COST ITEM COST NOTES
A Mobilization/Demobilization (10%)LS 1 $240,000.00 $240,000.00 1,2,3,4,5,6
B Temporary Erosion Control LS 1 $30,000.00 $30,000.00 1,2,3,4,5,6
C Flotation Silt Curtain LF 900 $11.00 $9,900.00 1,2,3,4,5,6
D Remove and Dispose of Existing Storm Sewer LF 4,580 $20.00 $91,600.00 1,2,3,4,5,6
E Remove and Dispose of Existing Manhole/Catch Basin Each 22 $750.00 $16,500.00 1,2,3,4,5,6
F 24" RC Pipe Sewer (Furnish and Install) (12 - 13' depth)LF 278 $110.00 $30,580.00 1,2,3,4,5,6,7
G 36" RC Pipe Sewer (Furnish and Install) (8 - 13' depth)LF 710 $170.00 $120,700.00 1,2,3,4,5,6,7
H 48" RC Pipe Sewer (Furnish and Install) (15' depth)LF 368 $270.00 $99,360.00 1,2,3,4,5,6,7
I 60" RC Pipe Sewer (Furnish and Install) (8 - 10' depth)LF 840 $225.00 $189,000.00 1,2,3,4,5,6,7
J 60" RC Pipe Sewer (Furnish and Install) (10 - 16' depth)LF 2,630 $340.00 $894,200.00 1,2,3,4,5,6,7
K Construct Drainage Structure SD-48 LF 14 $372.00 $5,208.00 1,2,3,4,5,6
L Construct Drainage Structure SD-60 LF 56 $608.00 $34,048.00 1,2,3,4,5,6
M Construct Drainage Structure SD-72 LF 14 $804.00 $11,256.00 1,2,3,4,5,6
N Construct Drainage Structure SD-84 LF 224 $1,450.00 $324,800.00 1,2,3,4,5,6
O Casting Assembly Each 22 $750.00 $16,500.00 1,2,3,4,5,6
P Tie-In Existing Storm Sewer Main to Manhole Each 6 $1,000.00 $6,000.00 1,2,3,4,5,6
Q Connect CB Leads to Constructed Storm Sewer Each 38 $700.00 $26,600.00 1,2,3,4,5,6
R Excavation CY 1,110 $4.00 $4,440.00 1,2,3,4,5,6
S Offsite Disposal of Excavated Material CY 890 $16.00 $14,240.00 1,2,3,4,5,6
T Site Grading SY 2,230 $2.00 $4,460.00 1,2,3,4,5,6
U Reinforced Structural Concrete Flood Wall CY 450 $1,000.00 $450,000.00 1,2,3,4,5,6
V Clearing and Grubbing AC 1 $6,000.00 $6,000.00 1,2,3,4,5,6
W Tree 2", B&B Each 20 $500.00 $10,000.00 1,2,3,4,5,6
X Turf Establishment (w/ Disc Anchored Mulch)AC 1 $3,000.00 $3,000.00 1,2,3,4,5,6
CONSTRUCTION SUBTOTAL $2,638,000.00 1,2,3,4,5,6,7,8
CONSTRUCTION CONTINGENCY (30%)$791,000.00 1,5,8
ESTIMATED CONSTRUCTION COST $3,429,000.00 1,2,3,4,5,6,7,8
ENGINEERING, DESIGN, PERMITTING, AND CONSTRUCTION
OBSERVATION (30%)$1,029,000.00 1,2,3,4,5,8
RESIDENTIAL/CONSTRUCTION PERMANENT EASEMENT $11,000.00 1,2,3,5,8
ESTIMATED TOTAL PROJECT COST $4,469,000.00 1,2,3,4,5,6,7,8
-30%$3,129,000.00 5,8
50%$6,704,000.00 5,8
Notes
6 Estimate costs are to design, construct, and permit each alternative. The estimated costs do not include maintenance, monitoring or additional tasks
following construction.
8 Estimate costs are reported to nearest thousand dollars.
ESTIMATED ACCURACY RANGE
1 Limited Design Work Completed
2 Quantities Based on Design Work Completed.
3 Unit Prices Based on Information Available at This Time.
4 Minimal Soil and Field Investigations Completed. Costs do not included remediation of contaminated soils (if found).
5 This feasibility-level (Class 4, 10-15% design completion per ASTM E 2516-06) cost estimate is based on feasibility-level designs, alignments, quantities and
unit prices. Costs will change with further design. Time value-of-money escalation costs are not included. A construction schedule is not available at this
time. Contingency is an allowance for the net sum of costs that will be in the Final Total Project Cost at the time of the completion of design, but are not
included at this level of project definition. The estimated accuracy range for the Total Project Cost as the project is defined is -30% to +50%. The accuracy
range is based on professional judgement considering the level of design completed, the complexity of the project and the uncertainties in the project as
scoped. The contingency and the accuracy range are not intended to include costs for future scope changes that are not part of the project as currently
scoped or costs for risk contingency. Operation and Maintenance costs are not included.
7 Furnish and Install pipe cost per lineal foot includes all trenching, bedding, backfilling, compaction, and disposal of excess materials
\\barr.com\projects\Mpls\23 MN\27\23271649 Morningside FRRS Study\WorkFiles\Cost Estimates\Engineers Opinion of Probable Cost_20180704.xlsx 1
PREPARED BY: BARR ENGINEERING COMPANY SHEET: 2 OF 7
BY:KJN2 DATE:7/6/2018
FEASIBILITY STUDY CHECKED BY: KAL DATE: 7/6/2018
ENGINEER'S OPINION OF PROBABLE PROJECT COST APPROVED BY:DATE:
PROJECT:Morningside FRRS Study ISSUED:DATE:
LOCATION:City of Edina ISSUED:DATE:
PROJECT #:23/27-1649.00 ISSUED:DATE:
OPINION OF COST - SUMMARY ISSUED:DATE:
Engineer's Opinion of Probable Project Cost
Morningside Flood Mitigation Feasibility Project
Option 3A
Cat.ESTIMATED
No.ITEM DESCRIPTION UNIT QUANTITY UNIT COST ITEM COST NOTES
A Mobilization/Demobilization (10%)LS 1 $270,000.00 $270,000.00 1,2,3,4,5,6
B Temporary Erosion Control LS 1 $30,000.00 $30,000.00 1,2,3,4,5,6
C Dewatering LS 1 $50,000.00 $50,000.00 1,2,3,4,5,6
D Flotation Silt Curtain LF 1,000 $11.00 $11,000.00 1,2,3,4,5,6
E Remove Existing Sports Infrastructure LS 1 $15,000.00 $15,000.00 1,2,3,4,5,6
F Excavation CY 72,903 $4.00 $291,613.33 1,2,3,4,5,6
G Off Site Disposal of Excavated Material CY 72,290 $16.00 $1,156,634.07 1,2,3,4,5,6
H Site Grading SY 125,540 $2.00 $251,080.00 1,2,3,4,5,6
I Place On-Site Soil for Berm Construction CY 1,504 $5.00 $7,518.52 1,2,3,4,5,6
J 36" RC Pipe Sewer (Furnish and Install) (5' - 8' depth)LF 50 $110.00 $5,500.00 1,2,3,4,5,6,7
K 36" RC Pipe Sewer Flared End Section (Furnish and Install)Each 2 $1,540.00 $3,080.00 1,2,3,4,5,6
L MnDOT Class IV RipRap with Filter Fabric TON 53 $100.00 $5,275.00 1,2,3,4,5,6
M Reinforced Structural Concrete Flood Wall CY 450 $1,000.00 $450,000.00 1,2,3,4,5,6
N Clearing and Grubbing AC 9 $6,000.00 $54,000.00 1,2,3,4,5,6
O Upland Native Vegetation AC 5 $5,000.00 $25,000.00 1,2,3,4,5,6
P Tree 2", B&B Each 150 $500.00 $75,000.00 1,2,3,4,5,6
Q Turf Establishment (w/ Disc Anchored Mulch)AC 17 $3,000.00 $52,314.05 1,2,3,4,5,6
R Sod SY 4,840 $6.00 $29,040.00 1,2,3,4,5,6
S Erosion Control Blanket SY 29,476 $2.00 $58,951.20 1,2,3,4,5,6
T Wetland Restoration AC 2.5 $10,000.00 $25,000.00 1,2,3,4,5,6
U Reconstruction of Baseball Field LS 1 $75,000.00 $75,000.00 1,2,3,4,5,6
V Reconstruction of Ice Rink LS 1 $25,000.00 $25,000.00 1,2,3,4,5,6
CONSTRUCTION SUBTOTAL $2,966,000.00 1,2,3,4,5,6,7,8
CONSTRUCTION CONTINGENCY (30%)$890,000.00 1,5,8
ESTIMATED CONSTRUCTION COST $3,856,000.00 1,2,3,4,5,6,7,8
ENGINEERING, DESIGN, PERMITTING, AND CONSTRUCTION
OBSERVATION (30%)$1,157,000.00 1,2,3,4,5,8
RESIDENTIAL/CONSTRUCTION PERMANENT EASEMENT $56,000.00 1,2,3,5,8
ESTIMATED TOTAL PROJECT COST $5,069,000.00 1,2,3,4,5,6,7,8
-30%$3,549,000.00 5,8
50%$7,604,000.00 5,8
Notes
6 Estimate costs are to design, construct, and permit each alternative. The estimated costs do not include maintenance, monitoring or additional tasks
following construction.
7 Furnish and Install pipe cost per lineal foot includes all trenching, bedding, backfilling, compaction, and disposal of excess materials
8 Estimate costs are reported to nearest thousand dollars.
ESTIMATED ACCURACY RANGE
1 Limited Design Work Completed
2 Quantities Based on Design Work Completed.
3 Unit Prices Based on Information Available at This Time.
4 Minimal Soil and Field Investigations Completed. Costs do not included remediation of contaminated soils (if found).
5 This feasibility-level (Class 4, 10-15% design completion per ASTM E 2516-06) cost estimate is based on feasibility-level designs, alignments, quantities and
unit prices. Costs will change with further design. Time value-of-money escalation costs are not included. A construction schedule is not available at this time.
Contingency is an allowance for the net sum of costs that will be in the Final Total Project Cost at the time of the completion of design, but are not included at
this level of project definition. The estimated accuracy range for the Total Project Cost as the project is defined is -30% to +50%. The accuracy range is based
on professional judgement considering the level of design completed, the complexity of the project and the uncertainties in the project as scoped. The
contingency and the accuracy range are not intended to include costs for future scope changes that are not part of the project as currently scoped or costs for
risk contingency. Operation and Maintenance costs are not included.
\\barr.com\projects\Mpls\23 MN\27\23271649 Morningside FRRS Study\WorkFiles\Cost Estimates\Engineers Opinion of Probable Cost_20180704.xlsx 2
PREPARED BY: BARR ENGINEERING COMPANY SHEET: 3 OF 7
BY:KJN2 DATE:7/6/2018
FEASIBILITY STUDY CHECKED BY: KAL DATE: 7/6/2018
ENGINEER'S OPINION OF PROBABLE PROJECT COST APPROVED BY:DATE:
PROJECT:Morningside FRRS Study ISSUED:DATE:
LOCATION:City of Edina ISSUED:DATE:
PROJECT #:23/27-1649.00 ISSUED:DATE:
OPINION OF COST - SUMMARY ISSUED:DATE:
Engineer's Opinion of Probable Project Cost
Morningside Flood Mitigation Feasibility Project
Option 4A
Cat.ESTIMATED
No.ITEM DESCRIPTION UNIT QUANTITY UNIT COST ITEM COST NOTES
A Mobilization/Demobilization (10%)LS 1 $186,000.00 $186,000.00 1,2,3,4,5,6
B Temporary Erosion Control LS 1 $30,000.00 $30,000.00 1,2,3,4,5,6
C Excavation CY 15,165 $4.00 $60,661.33 1,2,3,4,5,6
D Off Site Disposal of Excavated Material CY 15,165 $16.00 $242,645.33 1,2,3,4,5,6
E Site Grading SY 14,520 $2.00 $29,040.00 1,2,3,4,5,6
F
Opti CMAC Predictive Pumping Control System (Furnish and
Install)Each 2 $85,000.00 $170,000.00 1,2,3,4,5,6
G
2,000 GPM Pumping Station (Includes Building Structure,
Electric Supply, Control Panel)LS 1 $500,000.00 $500,000.00 1,2,3,4,5,6
H
4,000 GPM Pumping Station (Includes Building Structure,
Electric Supply, Control Panel)LS 1 $700,000.00 $700,000.00 1,2,3,4,5,6
I Pumping Station Outlet Piping (Furnish and Install)LF 1,116 $40.00 $44,640.00 1,2,3,4,5,6,7
J Pumping Station Inlet Suction Piping (Furnish and Install)LF 24 $40.00 $960.00 1,2,3,4,5,6,7
K Tie-In Storm Sewer to Existing Manhole Each 2 $1,000.00 $2,000.00 1,2,3,4,5,6
L Clearing and Grubbing AC 3.2 $6,000.00 $19,239.67 1,2,3,4,5,6
M Upland Native Vegetation AC 0.7 $5,000.00 $3,500.00 1,2,3,4,5,6
N Tree 2", B&B Each 50 $500.00 $25,000.00 1,2,3,4,5,6
O Turf Establishment (w/ Disc Anchored Mulch)AC 0.5 $3,000.00 $1,500.00 1,2,3,4,5,6
P Erosion Control Blanket SY 1,452 $2.00 $2,904.00 1,2,3,4,5,6
Q Wetland Restoration AC 2 $10,000.00 $20,000.00 1,2,3,4,5,6
CONSTRUCTION SUBTOTAL $2,038,000.00 1,2,3,4,5,6,7,8
CONSTRUCTION CONTINGENCY (30%)$611,000.00 1,5,8
ESTIMATED CONSTRUCTION COST $2,649,000.00 1,2,3,4,5,6,7,8
ENGINEERING, DESIGN, PERMITTING, AND CONSTRUCTION
OBSERVATION (30%)$795,000.00 1,2,3,4,5,8
ESTIMATED TOTAL PROJECT COST $3,444,000.00 1,2,3,4,5,6,7,8
-30%$2,411,000.00 5,8
50%$5,166,000.00 5,8
Notes
6 Estimate costs are to design, construct, and permit each alternative. The estimated costs do not include maintenance, monitoring or additional tasks
following construction.
7 Furnish and Install pipe cost per lineal foot includes all trenching, bedding, backfilling, compaction, and disposal of excess materials
8 Estimate costs are reported to nearest thousand dollars.
ESTIMATED ACCURACY RANGE
1 Limited Design Work Completed
2 Quantities Based on Design Work Completed.
3 Unit Prices Based on Information Available at This Time.
4 Minimal Soil and Field Investigations Completed. Costs do not included remediation of contaminated soils (if found).
5 This feasibility-level (Class 4, 10-15% design completion per ASTM E 2516-06) cost estimate is based on feasibility-level designs, alignments, quantities and
unit prices. Costs will change with further design. Time value-of-money escalation costs are not included. A construction schedule is not available at this time.
Contingency is an allowance for the net sum of costs that will be in the Final Total Project Cost at the time of the completion of design, but are not included at
this level of project definition. The estimated accuracy range for the Total Project Cost as the project is defined is -30% to +50%. The accuracy range is based
on professional judgement considering the level of design completed, the complexity of the project and the uncertainties in the project as scoped. The
contingency and the accuracy range are not intended to include costs for future scope changes that are not part of the project as currently scoped or costs for
risk contingency. Operation and Maintenance costs are not included.
\\barr.com\projects\Mpls\23 MN\27\23271649 Morningside FRRS Study\WorkFiles\Cost Estimates\Engineers Opinion of Probable Cost_20180704.xlsx 3
PREPARED BY: BARR ENGINEERING COMPANY SHEET: 4 OF 7
BY:KJN2 DATE:7/6/2018
FEASIBILITY STUDY CHECKED BY: KAL DATE: 7/6/2018
ENGINEER'S OPINION OF PROBABLE PROJECT COST APPROVED BY:DATE:
PROJECT:Morningside FRRS Study ISSUED:DATE:
LOCATION:City of Edina ISSUED:DATE:
PROJECT #:23/27-1649.00 ISSUED:DATE:
OPINION OF COST - SUMMARY ISSUED:DATE:
Engineer's Opinion of Probable Project Cost
Morningside Flood Mitigation Feasibility Project
Option 5A
Cat.ESTIMATED
No.ITEM DESCRIPTION UNIT QUANTITY UNIT COST ITEM COST NOTES
A Mobilization/Demobilization LS 1 $576,000.00 $576,000.00 1,2,3,4,5,6
B Temporary Erosion Control LS 1 $30,000.00 $30,000.00 1,2,3,4,5,6
C Remove Existing Sports Infrastructure LS 1 $15,000.00 $15,000.00 1,2,3,4,5,6
D Excavation CY 785,587 $4.00 $3,142,346.67 1,2,3,4,5,6
E Excavate and Haul offsite CY 112,933 $16.00 $1,806,933.33 1,2,3,4,5,6
F Site Grading SY 43,560 $2.00 $87,120.00 1,2,3,4,5,6
G Salvage and Replace Existing Topsoil CY 7,260 $9.00 $65,340.00 1,2,3,4,5,6
H StormTrap Subsurface Storage CF 2,866,250 $6.00 $17,197,500.00 1,2,3,4,5,6
I 500 GPM Pump (Subsurface Storage Drawdown)Each 1 $30,000.00 $30,000.00 1,2,3,4,5,6
J 3,500 GPM Pump (Subsurface Storage Drawndown)Each 1 $300,000.00 $300,000.00 1,2,3,4,5,6
K 36" RC Pipe Sewer (Furnish and Install) (10' - 15' depth)LF 300 $215.00 $64,500.00 1,2,3,4,5,6,7
L 42" RC Pipe Sewer (Furnish and Install) (10' - 15' depth)LF 50 $270.00 $13,500.00 1,2,3,4,5,6,7
M
Construct Drainage Structure SD-72 w/ Weir
(Diversion Structure)Each 3 $15,000.00 $45,000.00 1,2,3,4,5,6
N Tie-In Existing Storm Sewer to Manhole Each 5 $1,000.00 $5,000.00 1,2,3,4,5,6
O Clearing and Grubbing AC 1 $6,000.00 $6,000.00 1,2,3,4,5,6
P Tree 2", B&B Each 25 $500.00 $12,500.00 1,2,3,4,5,6
Q Turf Establishment (w/ Disc Anchored Mulch)AC 9.0 $3,000.00 $27,000.00 1,2,3,4,5,6
R Reconstruction of Baseball Field LS 1 $75,000.00 $75,000.00 1,2,3,4,5,6
S Reconstruction of Ice Rink LS 1 $25,000.00 $25,000.00 1,2,3,4,5,6
CONSTRUCTION SUBTOTAL $23,524,000.00 1,2,3,4,5,6,7,8
CONSTRUCTION CONTINGENCY (30%)$7,057,000.00 1,5,8
ESTIMATED CONSTRUCTION COST $30,581,000.00 1,2,3,4,5,6,7,8
ENGINEERING, DESIGN, PERMITTING, AND CONSTRUCTION
OBSERVATION $1,100,000.00 1,2,3,4,5,8
ESTIMATED TOTAL PROJECT COST $31,681,000.00 1,2,3,4,5,6,7,8
-30%$22,177,000.00 5,8
50%$47,522,000.00 5,8
Notes
6 Estimate costs are to design, construct, and permit each alternative. The estimated costs do not include maintenance, monitoring or additional tasks
following construction.
7 Furnish and Install pipe cost per lineal foot includes all trenching, bedding, backfilling, compaction, and disposal of excess materials
8 Estimate costs are reported to nearest thousand dollars.
ESTIMATED ACCURACY RANGE
1 Limited Design Work Completed
2 Quantities Based on Design Work Completed.
3 Unit Prices Based on Information Available at This Time.
4 Minimal Soil and Field Investigations Completed. Costs do not included remediation of contaminated soils (if found).
5 This feasibility-level (Class 4, 10-15% design completion per ASTM E 2516-06) cost estimate is based on feasibility-level designs, alignments, quantities and
unit prices. Costs will change with further design. Time value-of-money escalation costs are not included. A construction schedule is not available at this time.
Contingency is an allowance for the net sum of costs that will be in the Final Total Project Cost at the time of the completion of design, but are not included at
this level of project definition. The estimated accuracy range for the Total Project Cost as the project is defined is -30% to +50%. The accuracy range is based
on professional judgement considering the level of design completed, the complexity of the project and the uncertainties in the project as scoped. The
contingency and the accuracy range are not intended to include costs for future scope changes that are not part of the project as currently scoped or costs for
risk contingency. Operation and Maintenance costs are not included.
\\barr.com\projects\Mpls\23 MN\27\23271649 Morningside FRRS Study\WorkFiles\Cost Estimates\Engineers Opinion of Probable Cost_20180704.xlsx 4
PREPARED BY: BARR ENGINEERING COMPANY SHEET: 5 OF 7
BY:KJN2 DATE:7/6/2018
FEASIBILITY STUDY CHECKED BY: KAL DATE: 7/6/2018
ENGINEER'S OPINION OF PROBABLE PROJECT COST APPROVED BY:DATE:
PROJECT:Morningside FRRS Study ISSUED:DATE:
LOCATION:City of Edina ISSUED:DATE:
PROJECT #:23/27-1649.00 ISSUED:DATE:
OPINION OF COST - SUMMARY ISSUED:DATE:
Engineer's Opinion of Probable Project Cost
Morningside Flood Mitigation Feasibility Project
Option 7B
Cat.ESTIMATED
No.ITEM DESCRIPTION UNIT QUANTITY UNIT COST ITEM COST NOTES
A Mobilization/Demobilization (10%)LS 1 $455,000.00 $455,000.00 1,2,3,4,5,6
B Temporary Erosion Control LS 1 $30,000.00 $30,000.00 1,2,3,4,5,6
C Excavation CY 26,923 $4.00 $107,693.33 1,2,3,4,5,6
D Off Site Disposal of Excavated Material CY 25,200 $16.00 $403,194.07 1,2,3,4,5,6
E Site Grading SY 40,712 $2.00 $81,424.44 1,2,3,4,5,6
Place On-Site Soil for Berm Construction CY 1,504 $5.00 $7,518.52 1,2,3,4,5,6
F Reinforced Structural Concrete Flood Wall CY 450 $1,000.00 $450,000.00 1,2,3,4,5,6
G Flotation Silt Curtain LF 900 $11.00 $9,900.00 1,2,3,4,5,6
H Remove and Dispose of Existing Storm Sewer LF 4,580 $20.00 $91,600.00 1,2,3,4,5,6
I Remove and Dispose of Existing Manhole/Catch Basin Each 22 $750.00 $16,500.00 1,2,3,4,5,6
J 24" RC Pipe Sewer (Furnish and Install) (12 - 13' depth)LF 278 $110.00 $30,580.00 1,2,3,4,5,6,7
K 36" RC Pipe Sewer (Furnish and Install) (8 - 13' depth)LF 710 $170.00 $120,700.00 1,2,3,4,5,6,7
L 48" RC Pipe Sewer (Furnish and Install) (15' depth)LF 368 $270.00 $99,360.00 1,2,3,4,5,6,7
M 60" RC Pipe Sewer (Furnish and Install) (8 - 10' depth)LF 840 $225.00 $189,000.00 1,2,3,4,5,6,7
N 60" RC Pipe Sewer (Furnish and Install) (10 - 16' depth)LF 2,630 $340.00 $894,200.00 1,2,3,4,5,6,7
O Construct Drainage Structure SD-48 LF 14 $372.00 $5,208.00 1,2,3,4,5,6
P Construct Drainage Structure SD-60 LF 56 $608.00 $34,048.00 1,2,3,4,5,6
Q Construct Drainage Structure SD-72 LF 14 $804.00 $11,256.00 1,2,3,4,5,6
R Construct Drainage Structure SD-84 LF 224 $1,450.00 $324,800.00 1,2,3,4,5,6
S Casting Assembly Each 22 $750.00 $16,500.00 1,2,3,4,5,6
T Tie-In Storm Sewer Main to Manhole Each 9 $1,000.00 $9,000.00 1,2,3,4,5,6
U Connect CB Leads to Constructed Storm Sewer Each 38 $700.00 $26,600.00 1,2,3,4,5,6
V
Opti CMAC Predictive Pumping Control System (Furnish and
Install)Each 2 $85,000.00 $170,000.00 1,2,3,4,5,6
W
2,000 GPM Pumping Station (Includes Building Structure,
Electric Supply, Control Panel)LS 1 $500,000.00 $500,000.00 1,2,3,4,5,6
X
4,000 GPM Pumping Station (Includes Building Structure,
Electric Supply, Control Panel)LS 1 $700,000.00 $700,000.00
Y Pumping Station Outlet Piping (Furnish and Install)LF 1,116 $40.00 $44,640.00 1,2,3,4,5,6,7
Z Pumping Station Inlet Suction Piping (Furnish and Install)LF 24 $40.00 $960.00 1,2,3,4,5,6,7
AA Clearing and Grubbing AC 6 $6,000.00 $33,994.49 1,2,3,4,5,6
BB Upland Native Vegetation AC 0.7 $5,000.00 $3,500.00 1,2,3,4,5,6
CC Wetland Restoration AC 2.0 $10,000.00 $20,000.00 1,2,3,4,5,6
DD Tree 2", B&B Each 150 $500.00 $75,000.00 1,2,3,4,5,6
EE Turf Establishment (w/ Disc Anchored Mulch)AC 4.7 $3,000.00 $14,134.85 1,2,3,4,5,6
FF Sod SY 4,840 $3.00 $14,520.00 1,2,3,4,5,6
GG Erosion Control Blanket SY 5,324 $2.00 $10,648.00 1,2,3,4,5,6
CONSTRUCTION SUBTOTAL $5,001,000.00 1,2,3,4,5,6,7,8
CONSTRUCTION CONTINGENCY (30%)$1,500,000.00 1,5,8
ESTIMATED CONSTRUCTION COST $6,501,000.00 1,2,3,4,5,6,7,8
ENGINEERING, DESIGN, PERMITTING, AND CONSTRUCTION
OBSERVATION (30%)$1,950,000.00 1,2,3,4,5,8
RESIDENTIAL/CONSTRUCTION PERMANENT EASEMENT $56,000.00 1,2,3,5,8
ESTIMATED TOTAL PROJECT COST $8,507,000.00 1,2,3,4,5,6,7,8
-30%$5,955,000.00 5,8
50%$12,761,000.00 5,8
Notes
6 Estimate costs are to design, construct, and permit each alternative. The estimated costs do not include maintenance, monitoring or additional tasks
following construction.
7 Furnish and Install pipe cost per lineal foot includes all trenching, bedding, backfilling, compaction, and disposal of excess materials
8 Estimate costs are reported to nearest thousand dollars.
ESTIMATED ACCURACY RANGE
1 Limited Design Work Completed
2 Quantities Based on Design Work Completed.
3 Unit Prices Based on Information Available at This Time.
4 Minimal Soil and Field Investigations Completed. Costs do not included remediation of contaminated soils (if found).
5 This feasibility-level (Class 4, 10-15% design completion per ASTM E 2516-06) cost estimate is based on feasibility-level designs, alignments, quantities and
unit prices. Costs will change with further design. Time value-of-money escalation costs are not included. A construction schedule is not available at this time.
Contingency is an allowance for the net sum of costs that will be in the Final Total Project Cost at the time of the completion of design, but are not included at
this level of project definition. The estimated accuracy range for the Total Project Cost as the project is defined is -30% to +50%. The accuracy range is based
on professional judgement considering the level of design completed, the complexity of the project and the uncertainties in the project as scoped. The
contingency and the accuracy range are not intended to include costs for future scope changes that are not part of the project as currently scoped or costs for
risk contingency. Operation and Maintenance costs are not included.
\\barr.com\projects\Mpls\23 MN\27\23271649 Morningside FRRS Study\WorkFiles\Cost Estimates\Engineers Opinion of Probable Cost_20180704.xlsx 5
PREPARED BY: BARR ENGINEERING COMPANY SHEET: 6 OF 7
BY:KJN2 DATE:7/6/2018
FEASIBILITY STUDY CHECKED BY: KAL DATE: 7/6/2018
ENGINEER'S OPINION OF PROBABLE PROJECT COST APPROVED BY:DATE:
PROJECT:Morningside FRRS Study ISSUED:DATE:
LOCATION:City of Edina ISSUED:DATE:
PROJECT #:23/27-1649.00 ISSUED:DATE:
OPINION OF COST - SUMMARY ISSUED:DATE:
Engineer's Opinion of Probable Project Cost
Morningside Flood Mitigation Feasibility Project
Option 8
Cat.ESTIMATED
No.ITEM DESCRIPTION UNIT QUANTITY UNIT COST ITEM COST NOTES
A Mobilization/Demobilization (10%)LS 1 $278,000.00 $278,000.00 1,2,3,4,5,6
B Temporary Erosion Control LS 1 $30,000.00 $30,000.00 1,2,3,4,5,6
C Dewatering LS 1 $50,000.00 $50,000.00 1,2,3,4,5,6
D Flotation Silt Curtain LF 1,000 $11.00 $11,000.00 1,2,3,4,5,6
E Remove Existing Sports Infrastructure LS 1 $15,000.00 $15,000.00 1,2,3,4,5,6
F Excavation CY 64,998 $4.00 $259,992.00 1,2,3,4,5,6
G Off Site Disposal of Excavated Material CY 64,778 $16.00 $1,036,448.00 1,2,3,4,5,6
H Site Grading SY 87,070 $2.00 $174,140.00 1,2,3,4,5,6
I Reinforced Structural Concrete Flood Wall CY 450 $1,000.00 $450,000.00 1,2,3,4,5,6
J Remove and Dispose of Existing Storm Sewer LF 1,190 $20.00 $23,800.00 1,2,3,4,5,6
K Remove and Dispose of Existing Manhole/Catch Basin Each 4 $750.00 $3,000.00 1,2,3,4,5,6
L 30" RC Pipe Sewer (Furnish and Install) (8 - 16' depth)LF 910 $160.00 $145,600.00 1,2,3,4,5,6,7
M 42" RC Pipe Sewer (Furnish and Install) (8 - 16' depth)LF 280 $250.00 $70,000.00 1,2,3,4,5,6,7
N Construct Drainage Structure SD-60 LF 16 $608.00 $9,728.00 1,2,3,4,5,6
O Construct Drainage Structure SD-72 LF 42 $804.00 $33,768.00 1,2,3,4,5,6
P Casting Assembly Each 4 $750.00 $3,000.00 1,2,3,4,5,6
Q Tie-In Storm Sewer Main to Manhole Each 3 $1,000.00 $3,000.00 1,2,3,4,5,6
R Connect CB Leads to Constructed Storm Sewer Each 2 $700.00 $1,400.00 1,2,3,4,5,6
S 6' x 8' Box Culvert (Furnish and Install)LF 100 $1,000.00 $100,000.00 1,2,3,4,5,6,7
T 6' x 8' Box Culvert End Section (Furnish and Install)Each 4 $10,000.00 $40,000.00 1,2,3,4,5,6
U MnDOT Class IV RipRap with Filter Fabric TON 248 $100.00 $24,800.00 1,2,3,4,5,6
V Clearing and Grubbing AC 5 $6,000.00 $30,000.00 1,2,3,4,5,6
W Upland Native Vegetation AC 4.5 $5,000.00 $22,500.00 1,2,3,4,5,6
X Tree 2", B&B Each 100 $500.00 $50,000.00 1,2,3,4,5,6
Y Turf Establishment (w/ Disc Anchored Mulch)AC 13.0 $3,000.00 $38,969.01 1,2,3,4,5,6
Z Erosion Control Blanket SY 24,200 $2.00 $48,400.00 1,2,3,4,5,6
AA Reconstruction of Baseball Field LS 1 $75,000.00 $75,000.00 1,2,3,4,5,6
BB Reconstruction of Ice Rink LS 1 $25,000.00 $25,000.00 1,2,3,4,5,6
CC Wetland Restoration AC 0.5 $10,000.00 $5,000.00 1,2,3,4,5,6
CONSTRUCTION SUBTOTAL $3,058,000.00 1,2,3,4,5,6,7,8
CONSTRUCTION CONTINGENCY (30%)$917,000.00 1,5,8
ESTIMATED CONSTRUCTION COST $3,975,000.00 1,2,3,4,5,6,7,8
ENGINEERING, DESIGN, PERMITTING, AND CONSTRUCTION
OBSERVATION (30%)$1,193,000.00 1,2,3,4,5,8
RESIDENTIAL/CONSTRUCTION PERMANENT EASEMENT $11,000.00 1,2,3,5,8
ESTIMATED TOTAL PROJECT COST $5,179,000.00 1,2,3,4,5,6,7,8
-30%$3,626,000.00 5,8
50%$7,769,000.00 5,8
Notes
6 Estimate costs are to design, construct, and permit each alternative. The estimated costs do not include maintenance, monitoring or additional tasks
following construction.
7 Furnish and Install pipe cost per lineal foot includes all trenching, bedding, backfilling, compaction, and disposal of excess materials
8 Estimate costs are reported to nearest thousand dollars.
ESTIMATED ACCURACY RANGE
1 Limited Design Work Completed
2 Quantities Based on Design Work Completed.
3 Unit Prices Based on Information Available at This Time.
4 Minimal Soil and Field Investigations Completed. Costs do not included remediation of contaminated soils (if found).
5 This feasibility-level (Class 4, 10-15% design completion per ASTM E 2516-06) cost estimate is based on feasibility-level designs, alignments, quantities and
unit prices. Costs will change with further design. Time value-of-money escalation costs are not included. A construction schedule is not available at this time.
Contingency is an allowance for the net sum of costs that will be in the Final Total Project Cost at the time of the completion of design, but are not included at
this level of project definition. The estimated accuracy range for the Total Project Cost as the project is defined is -30% to +50%. The accuracy range is based
on professional judgement considering the level of design completed, the complexity of the project and the uncertainties in the project as scoped. The
contingency and the accuracy range are not intended to include costs for future scope changes that are not part of the project as currently scoped or costs for
risk contingency. Operation and Maintenance costs are not included.
\\barr.com\projects\Mpls\23 MN\27\23271649 Morningside FRRS Study\WorkFiles\Cost Estimates\Engineers Opinion of Probable Cost_20180704.xlsx 6
PREPARED BY: BARR ENGINEERING COMPANY SHEET: 7 OF 7
BY:KJN2 DATE:7/6/2018
FEASIBILITY STUDY CHECKED BY: KAL DATE: 7/6/2018
ENGINEER'S OPINION OF PROBABLE PROJECT COST APPROVED BY:DATE:
PROJECT:Morningside FRRS Study ISSUED:DATE:
LOCATION:City of Edina ISSUED:DATE:
PROJECT #:23/27-1649.00 ISSUED:DATE:
OPINION OF COST - SUMMARY ISSUED:DATE:
Engineer's Opinion of Probable Project Cost
Morningside Flood Mitigation Feasibility Project
Option 9
Cat.ESTIMATED
No.ITEM DESCRIPTION UNIT QUANTITY UNIT COST ITEM COST NOTES
A Mobilization/Demobilization (10%)LS 1 $741,000.00 $741,000.00 1,2,3,4,5,6
B Temporary Erosion Control LS 1 $30,000.00 $30,000.00 1,2,3,4,5,6
C Dewatering LS 1 $50,000.00 $50,000.00 1,2,3,4,5,6
D Flotation Silt Curtain LF 1,000 $11.00 $11,000.00 1,2,3,4,5,6
E Remove Existing Sports Infrastructure LS 1 $15,000.00 $15,000.00 1,2,3,4,5,6
F Excavation CY 113,398 $4.00 $453,592.00 1,2,3,4,5,6
G Off Site Disposal of Excavated Material CY 101,885 $16.00 $1,630,154.67 1,2,3,4,5,6
H Site Grading SY 96,750 $2.00 $193,500.00 1,2,3,4,5,6
I Salvage and Replace Existing Topsoil CY 7,260 $9.00 $65,340.00 1,2,3,4,5,6
J Reinforced Structural Concrete Flood Wall CY 450 $1,000.00 $450,000.00 1,2,3,4,5,6
K 6' x 8' Box Culvert (Furnish and Install)LF 100 $1,000.00 $100,000.00 1,2,3,4,5,6,7
L 6' x 8' Box Culvert End Section (Furnish and Install)Each 4 $10,000.00 $40,000.00 1,2,3,4,5,6
M MnDOT Class IV RipRap with Filter Fabric TON 248 $100.00 $24,800.00 1,2,3,4,5,6
N Remove and Dispose of Existing Storm Sewer LF 5,770 $20.00 $115,400.00 1,2,3,4,5,6
O Remove and Dispose of Existing Manhole/Catch Basin Each 26 $750.00 $19,500.00 1,2,3,4,5,6
P 24" RC Pipe Sewer (Furnish and Install) (12 - 13' depth)LF 278 $110.00 $30,580.00 1,2,3,4,5,6,7
Q 30" RC Pipe Sewer (Furnish and Install) (8 - 16' depth)LF 910 $160.00 $145,600.00 1,2,3,4,5,6,7
R 36" RC Pipe Sewer (Furnish and Install) (8 - 13' depth)LF 710 $170.00 $120,700.00 1,2,3,4,5,6,7
S 42" RC Pipe Sewer (Furnish and Install) (8 - 16' depth)LF 280 $250.00 $70,000.00 1,2,3,4,5,6,7
T 48" RC Pipe Sewer (Furnish and Install) (15' depth)LF 368 $270.00 $99,360.00 1,2,3,4,5,6,7
U 60" RC Pipe Sewer (Furnish and Install) (8 - 10' depth)LF 840 $225.00 $189,000.00 1,2,3,4,5,6,7
V 60" RC Pipe Sewer (Furnish and Install) (10 - 16' depth)LF 2,630 $340.00 $894,200.00 1,2,3,4,5,6,7
W Construct Drainage Structure SD-48 LF 14 $372.00 $5,208.00 1,2,3,4,5,6
X Construct Drainage Structure SD-60 LF 72 $608.00 $43,776.00 1,2,3,4,5,6
Y Construct Drainage Structure SD-72 LF 70 $804.00 $56,280.00 1,2,3,4,5,6
A Construct Drainage Structure SD-84 LF 224 $1,450.00 $324,800.00 1,2,3,4,5,6
AA Casting Assembly Each 26 $750.00 $19,500.00 1,2,3,4,5,6
BB Tie-In Storm Sewer Main to Manhole Each 9 $1,000.00 $9,000.00 1,2,3,4,5,6
CC Connect CB Leads to Constructed Storm Sewer Each 40 $700.00 $28,000.00 1,2,3,4,5,6
DD 72" Diameter Weir Manhole (Diversion Structure)Each 1 $15,000.00 $15,000.00 1,2,3,4,5,6
EE StormTrap Subsurface Storage CF 304,920 $6.00 $1,829,520.00 1,2,3,4,5,6
FF 500 GPM Pump (Subsurface Storage Drawdown)Each 1 $30,000.00 $30,000.00 1,2,3,4,5,6
GG Clearing and Grubbing AC 5 $6,000.00 $30,000.00 1,2,3,4,5,6
HH Upland Native Vegetation AC 5 $5,000.00 $22,500.00 1,2,3,4,5,6
II Tree 2", B&B Each 100 $500.00 $50,000.00 1,2,3,4,5,6
JJ Turf Establishment (w/ Disc Anchored Mulch)AC 15.0 $3,000.00 $44,969.01 1,2,3,4,5,6
KK Erosion Control Blanket SY 24,200 $2.00 $48,400.00 1,2,3,4,5,6
LL Reconstruction of Baseball Field LS 1 $75,000.00 $75,000.00 1,2,3,4,5,6
MM Reconstruction of Ice Rink LS 1 $25,000.00 $25,000.00 1,2,3,4,5,6
NN Wetland Restoration AC 0.5 $10,000.00 $5,000.00 1,2,3,4,5,6
CONSTRUCTION SUBTOTAL $8,151,000.00 1,2,3,4,5,6,7,8
CONSTRUCTION CONTINGENCY (30%)$2,445,000.00 1,5,8
ESTIMATED CONSTRUCTION COST $10,596,000.00 1,2,3,4,5,6,7,8
ENGINEERING, DESIGN, PERMITTING, AND CONSTRUCTION
OBSERVATION (30%)$3,179,000.00 1,2,3,4,5,8
RESIDENTIAL/CONSTRUCTION PERMANENT EASEMENT $11,000.00 1,2,3,5,8
ESTIMATED TOTAL PROJECT COST $13,786,000.00 1,2,3,4,5,6,7,8
-30%$9,651,000.00 5,8
50%$20,679,000.00 5,8
Notes
6 Estimate costs are to design, construct, and permit each alternative. The estimated costs do not include maintenance, monitoring or additional tasks following
construction.
7 Furnish and Install pipe cost per lineal foot includes all trenching, bedding, backfilling, compaction, and disposal of excess materials
8 Estimate costs are reported to nearest thousand dollars.
ESTIMATED ACCURACY RANGE
1 Limited Design Work Completed
2 Quantities Based on Design Work Completed.
3 Unit Prices Based on Information Available at This Time.
4 Minimal Soil and Field Investigations Completed. Costs do not included remediation of contaminated soils (if found).
5 This feasibility-level (Class 4, 10-15% design completion per ASTM E 2516-06) cost estimate is based on feasibility-level designs, alignments, quantities and unit
prices. Costs will change with further design. Time value-of-money escalation costs are not included. A construction schedule is not available at this time.
Contingency is an allowance for the net sum of costs that will be in the Final Total Project Cost at the time of the completion of design, but are not included at this
level of project definition. The estimated accuracy range for the Total Project Cost as the project is defined is -30% to +50%. The accuracy range is based on
professional judgement considering the level of design completed, the complexity of the project and the uncertainties in the project as scoped. The contingency
and the accuracy range are not intended to include costs for future scope changes that are not part of the project as currently scoped or costs for risk contingency.
Operation and Maintenance costs are not included.
\\barr.com\projects\Mpls\23 MN\27\23271649 Morningside FRRS Study\WorkFiles\Cost Estimates\Engineers Opinion of Probable Cost_20180704.xlsx 7