fema (des)

profileJordanjameire
BCA_Toolkit_6_Template.xlsx
Home>Education homework help>fema (des)

Home

Benefit-Cost Calculator v6.0.0
Welcome
Benefit-Cost Analysis (BCA) is the method by which the future benefits of a hazard mitigation project are determined and compared to its costs. The end result is a Benefit-Cost Ratio (BCR), which is calculated by a project's total benefits divided by its total costs. FEMA requires a BCA to validate cost effectiveness of proposed hazard mitigation projects prior to funding. For a community and/or property, this tool will assist with: • Estimating Annual Hazard Risks • Evaluating Mitigation Cost Effectiveness • Developing Aggregate Benefit-Cost Models For more information, including methodologies of the calculation models used in this tool, visit FEMA BCA Website.
Getting Started
Click on the "BCA Calculator" button on the ribbon bar.
Template Last Updated: July 17, 2019
https://www.fema.gov/benefit-cost-analysis

Saver

{"CommunityID":"93d55fa5-d88a-4ceb-b8f9-b1a2e455b2d2","CommunityName":"Residential safe room protection ","Locked":false,"importedProject":false,"importedDateTime":"","createdDate":"","reportData":"","MitigationActions":[]} {"MAID":"ad66af77-97f7-4c82-929c-c6127d30e595","MATitle":"Residential @ 36.4656750; -77.6607030","Locked":false,"Location":{"usrPropertyLocationSelected":{"value":false,"comment":null},"usrCoordinatesSelected":{"value":true,"comment":null},"Location":"525 Vance St, Roanoke Rapids, North Carolina, 27870","Latitude":36.465675,"Longitude":-77.660703,"Zipcode":"27870","County":{"ID":1931,"Name":null},"State":{"ID":34,"Name":"North Carolina","Abbr":"NC"},"comment":null},"filterAssetType":{"id":1,"description":""},"filterHazardType":{"id":7,"description":""},"filterMitigationActionType":{"id":12,"description":""},"usrAnalysisMethodType":{"value":1,"comment":null},"CostEstimation":{"usrProjectUsefulLife":{"value":30,"comment":null},"usrMitigationProjectCost":{"value":10000,"comment":null},"usrNumberOfYearsOfMaintenance":{"value":30,"comment":null},"usrAnnualProjectMaintenanceCost":{"value":0,"comment":null},"usrNumberOfMaintenanceYearsDefaultSelected":{"value":true,"comment":null},"outPresentWorthOfAnnualMaintenance":{"value":0,"comment":null},"outFinalMitigationProjectCost":{"value":10000,"comment":null}},"BCRCalculationResults":{"outAdjustedBenefitCostRatio":{"value":0,"comment":null},"outAnnualAfterMitigation":{"value":0,"comment":null},"outAnnualBeforeMitigation":{"value":0,"comment":null},"outAnnualMitigationBenefits":{"value":0,"comment":null},"outBenefitCostRatio":{"value":0,"comment":null},"outEnvironmentalBenefits":{"value":null,"comment":null},"outMitigationBenefits":{"value":null,"comment":null},"outMitigationCosts":{"value":0,"comment":null},"outPresentAfterMitigation":{"value":0,"comment":null},"outPresentBeforeMitigation":{"value":0,"comment":null},"outPresentMitigationBenefits":{"value":0,"comment":null},"outSocialBenefits":{"value":null,"comment":null},"outTotalMitigationBenefits":{"value":0,"comment":null}},"TypeOfServices":{"usrStateID":{"value":0,"comment":null},"usrUtilities":{"value":false,"comment":null},"usrRoadsBridges":{"value":false,"comment":null},"usrBuildings":{"value":false,"comment":null},"RoadsBridgesMitigationDetails":{"DEFAULT_FEDERALRATE":0.58,"usrFederalRate":{"value":0.58,"comment":null},"usrFederalRateDefaultSelected":{"value":true,"comment":null},"usrEstimatedNumberOfOneWayPerTrips":{"value":0,"comment":null},"usrAdditionalTimePerTripHour":{"value":0,"comment":null},"usrAdditionalTimePerTripMinute":{"value":0,"comment":null},"usrNumberOfAdditionalMiles":{"value":0,"comment":null},"usrDescription":{"value":null,"comment":null},"outTotal":0},"UtilitiesMitigationDetails":{"usrTypeOfService":{"value":0,"comment":null},"usrNumOfCustomersServed":{"value":0,"comment":null},"usrValuePerUnitService":{"value":0,"comment":null},"usrValuePerUnitServiceDefaultSelected":{"value":true,"comment":null},"usrDescription":{"value":null,"comment":null},"outTotal":0,"outTotalValuePerServicePerDay":{"value":0,"comment":null}},"BuildingsMitigationDetails":{"filterCriticalFacilityType":{"id":0,"description":null,"comment":null},"outTotal":null,"FireStationDetails":{"id":1,"buildingSubType":9,"usrNumOfPeopleServed":{"value":0,"comment":null},"filterTypeOfAreaServedNRF":{"id":0,"description":null,"comment":null},"usrDistanceBetweenAlternateStation":{"value":0,"comment":null},"usrDistanceBetweenEMSStation":{"value":0,"comment":null},"usrStationProvideEMS":{"value":false,"comment":null},"outTotal":0},"HospitalDetails":{"id":2,"buildingSubType":7,"usrNumOfPeopleServedNRH":{"value":0,"comment":null},"usrDistanceBetweenAlternateHospital":{"value":0,"comment":null},"usrNumOfPeopleServedByAlternateHospital":{"value":0,"comment":null},"outTotal":0},"PoliceStationDetails":{"id":3,"buildingSubType":9,"usrNumOfPeopleServedNRP":{"value":0,"comment":null},"filterTypeOfAreaServedNRP":{"id":0,"description":null,"comment":null},"usrNumOfPoliceOfficersAtStation":{"value":0,"comment":null},"usrNumOfPoliceOfficersServingSameArea":{"value":0,"comment":null},"outTotal":0},"OtherDetails":{"id":4,"usrServiceBudgetList":{"value":[],"comment":null},"outTotal":null}},"outTotalLossOfService":{"value":0,"comment":null}},"StructureAndMitigationInfo":{"filterDesignedWindSpeed":{"id":1,"description":null,"comment":null},"filterFirstPredominantStructureType":{"id":4,"description":null,"comment":null},"filterSecondPredominantStructureType":{"id":0,"description":null,"comment":null},"usrDefaultResponseTableSelected":{"value":true,"comment":null},"usrNewOrRetrofitSelected":{"value":false,"comment":null},"usrStandAloneOrInternalSelected":{"value":false,"comment":null},"usrCommunityOrResidentialSelected":{"value":false,"comment":null},"usrMaximumOccupancy":{"value":4,"comment":null},"usrGrossArea":{"value":0,"comment":null},"usrUsableArea":{"value":0,"comment":null},"usrCommunitySizeInMiles":{"value":0,"comment":null},"usrHSRFirstPercentOccupancy":{"value":0,"comment":null},"outHSRSecondPercentOccupancy":0,"outHSRFirstPopulation":0,"outHSRSecondPopulation":0},"TSROccupancyResults":{"outFirstAverage":0,"outSecondAverage":0,"day":{"usrFirstPercent":100,"usrSecondPercent":100,"usrEnteredFirstResponse":4,"usrEnteredSecondResponse":0,"outFirstOccupancy":0,"outSecondOccupancy":0,"outTotalPercent":0},"evening":{"usrFirstPercent":85,"usrSecondPercent":85,"usrEnteredFirstResponse":4,"usrEnteredSecondResponse":0,"outFirstOccupancy":0,"outSecondOccupancy":0,"outTotalPercent":0},"night":{"usrFirstPercent":60,"usrSecondPercent":60,"usrEnteredFirstResponse":4,"usrEnteredSecondResponse":0,"outFirstOccupancy":0,"outSecondOccupancy":0,"outTotalPercent":0},"comment":null,"fieldLabel":null},"TornadoCountsForArea":{"EF0":20,"EF1":20,"EF2":9.979942207,"EF3":1.998908251,"EF4":0.902901134,"EF5":0},"HSRDamagesBM":{"value":[],"comment":null},"HSRDamagesAM":{"value":[],"comment":null}} {"MAID":"b83ddc2e-d696-49b6-9802-710fa98dda26","MATitle":"Drainage Improvement @ 525 Vance St, Roanoke Rapids, North Carolina, 27870","Locked":false,"Location":{"usrPropertyLocationSelected":{"value":true,"comment":null},"usrCoordinatesSelected":{"value":true,"comment":null},"Location":"525 Vance St, Roanoke Rapids, North Carolina, 27870","Latitude":36.465675,"Longitude":-77.660703,"Zipcode":"27870","County":{"ID":1931,"Name":null},"State":{"ID":34,"Name":"North Carolina","Abbr":"NC"},"comment":null},"filterAssetType":{"id":1,"description":""},"filterHazardType":{"id":1,"description":""},"filterMitigationActionType":{"id":4,"description":""},"usrAnalysisMethodType":{"value":1,"comment":null},"CostEstimation":{"usrProjectUsefulLife":{"value":30,"comment":null},"usrMitigationProjectCost":{"value":10000,"comment":null},"usrNumberOfYearsOfMaintenance":{"value":0,"comment":null},"usrAnnualProjectMaintenanceCost":{"value":0,"comment":null},"usrNumberOfMaintenanceYearsDefaultSelected":{"value":false,"comment":null},"outPresentWorthOfAnnualMaintenance":{"value":0,"comment":null},"outFinalMitigationProjectCost":{"value":10000,"comment":null}},"BCRCalculationResults":{"outAdjustedBenefitCostRatio":{"value":0,"comment":null},"outAnnualAfterMitigation":{"value":null,"comment":null},"outAnnualBeforeMitigation":{"value":null,"comment":null},"outAnnualMitigationBenefits":{"value":null,"comment":null},"outBenefitCostRatio":{"value":0,"comment":null},"outEnvironmentalBenefits":{"value":0,"comment":null},"outMitigationBenefits":{"value":null,"comment":null},"outMitigationCosts":{"value":null,"comment":null},"outPresentAfterMitigation":{"value":null,"comment":null},"outPresentBeforeMitigation":{"value":null,"comment":null},"outPresentMitigationBenefits":{"value":0,"comment":null},"outSocialBenefits":{"value":0,"comment":null},"outTotalMitigationBenefits":{"value":0,"comment":null}},"TypeOfServices":{"usrStateID":{"value":0,"comment":null},"usrUtilities":{"value":false,"comment":null},"usrRoadsBridges":{"value":false,"comment":null},"usrBuildings":{"value":false,"comment":null},"RoadsBridgesMitigationDetails":{"DEFAULT_FEDERALRATE":0.58,"usrFederalRate":{"value":0.58,"comment":null},"usrFederalRateDefaultSelected":{"value":true,"comment":null},"usrEstimatedNumberOfOneWayPerTrips":{"value":0,"comment":null},"usrAdditionalTimePerTripHour":{"value":0,"comment":null},"usrAdditionalTimePerTripMinute":{"value":0,"comment":null},"usrNumberOfAdditionalMiles":{"value":0,"comment":null},"usrDescription":{"value":null,"comment":null},"outTotal":0},"UtilitiesMitigationDetails":{"usrTypeOfService":{"value":0,"comment":null},"usrNumOfCustomersServed":{"value":0,"comment":null},"usrValuePerUnitService":{"value":0,"comment":null},"usrValuePerUnitServiceDefaultSelected":{"value":true,"comment":null},"usrDescription":{"value":null,"comment":null},"outTotal":0,"outTotalValuePerServicePerDay":{"value":0,"comment":null}},"BuildingsMitigationDetails":{"filterCriticalFacilityType":{"id":0,"description":null,"comment":null},"outTotal":null,"FireStationDetails":{"id":1,"buildingSubType":9,"usrNumOfPeopleServed":{"value":0,"comment":null},"filterTypeOfAreaServedNRF":{"id":0,"description":null,"comment":null},"usrDistanceBetweenAlternateStation":{"value":0,"comment":null},"usrDistanceBetweenEMSStation":{"value":0,"comment":null},"usrStationProvideEMS":{"value":false,"comment":null},"outTotal":0},"HospitalDetails":{"id":2,"buildingSubType":7,"usrNumOfPeopleServedNRH":{"value":0,"comment":null},"usrDistanceBetweenAlternateHospital":{"value":0,"comment":null},"usrNumOfPeopleServedByAlternateHospital":{"value":0,"comment":null},"outTotal":0},"PoliceStationDetails":{"id":3,"buildingSubType":9,"usrNumOfPeopleServedNRP":{"value":0,"comment":null},"filterTypeOfAreaServedNRP":{"id":0,"description":null,"comment":null},"usrNumOfPoliceOfficersAtStation":{"value":0,"comment":null},"usrNumOfPoliceOfficersServingSameArea":{"value":0,"comment":null},"outTotal":0},"OtherDetails":{"id":4,"usrServiceBudgetList":{"value":[],"comment":null},"outTotal":null}},"outTotalLossOfService":{"value":0,"comment":null}},"DEFAULT_BRV":100,"DEFAULT_DEMOLITIONTHRESHOLD":50,"DEFAULT_MEALSPERDIEM":55,"DEFAULT_LODGINGPERDIEM":94,"usrDDFDefaultSelected":{"value":true,"comment":null},"usrFrequencyDamageRelationHistorical":{"value":null,"comment":null},"StructureAndMitigationInfo":{"outBaseFloodElevationWithSLR":{"value":0,"comment":null},"outBreakingWaveHeightAtHYF":{"value":0,"comment":null},"outBRVContentsDollars":{"value":175000,"comment":null},"outDdfCurveObj":{"value":[],"comment":null},"outDisplacementCostsR":{"value":0,"comment":null},"filterBuildingType":{"id":2,"description":null},"filterDDFType":{"id":"F8A4D9AA-9BF2-4720-84FC-CB484B5E8728","description":null},"filterFloodSource":{"id":2,"description":null,"comment":null},"filterFloodZone":{"id":0,"description":null},"filterFoundationType":{"id":0,"description":null},"filterNonResidentialPurpose":{"id":0,"description":null,"comment":null},"filterPropertyType":{"id":0,"description":null},"filterStructureType":{"id":0,"description":null},"outFirstFloorElevationAboveGrade":{"value":0,"comment":null},"outTotalBRVDollars":{"value":350000,"comment":null},"outTotalReducedStreetMaintenanceCosts":{"value":0,"comment":null},"usrAdditionalContents":{"value":0,"comment":null},"usrAnnualOperatingBudget":{"value":0,"comment":null},"usrBaseFloodElevation":{"value":0,"comment":null},"usrBarrierElevation":{"value":0,"comment":null},"usrBuildingSize":{"value":3500,"comment":null},"usrBRV":{"value":100,"comment":null},"usrBRVSelected":{"value":false,"comment":null},"usrConsiderSeaLevelRise":{"value":false,"comment":null},"usrContentsDollars":{"value":0,"comment":null},"usrContentsSelected":{"value":true,"comment":null},"usrCrawlSpace":{"value":0,"comment":null},"usrDemolitionThresholdSelected":{"value":false,"comment":null},"usrDemolitionThreshold":{"value":50,"comment":null},"usrLibraryDDFTypeSelected":{"value":true,"comment":null},"usrFeetToRaiseFirstFloor":{"value":0,"comment":null},"usrFirstFloorElevation":{"value":12,"comment":null},"usrGroundSurfaceElevation":{"value":0,"comment":null},"usrHasBasement":{"value":false,"comment":null},"usrIsEngineered":{"value":false,"comment":null},"usrIsFoundationElevated":{"value":false,"comment":null},"usrLengthOfRoad":{"value":0,"comment":null},"usrLodgingPerDiemSelected":{"value":true,"comment":null},"usrLodgingPerDiem":{"value":94,"comment":null},"usrLOFPerDay":{"value":0,"comment":null},"usrMealsPerDiemSelected":{"value":true,"comment":null},"usrMealsPerDiem":{"value":55,"comment":null},"usrMilesOfStreet":{"value":0,"comment":null},"usrMobileHomeType":{"value":0,"comment":null},"usrMonthlyDisplacementCostsNR":{"value":0,"comment":null},"usrNFIP":{"value":false,"comment":null},"usrNumPersonsLiving":{"value":0,"comment":null},"usrOneTimeDisplacementCostsNR":{"value":0,"comment":null},"usrPopulationAffected":{"value":0,"comment":null},"usrRent":{"value":0,"comment":null},"usrSeaLevelRise":{"value":0,"comment":null},"usrStreambedElevation":{"value":0,"comment":null},"usrStreetMaintenanceBudget":{"value":0,"comment":null},"usrUtilitiesElevated":{"value":false,"comment":null},"usrValueOfProjectedSLRIncrease":{"value":0,"comment":null},"usrWithObstructionSelected":{"value":false,"comment":null}},"DischargeValuesListBM":{"value":[{"isBeforeMitigation":true,"recurranceInterval":10,"surfaceElevation":0,"percentAnnualChance":0,"discharge":0},{"isBeforeMitigation":true,"recurranceInterval":50,"surfaceElevation":0,"percentAnnualChance":0,"discharge":0},{"isBeforeMitigation":true,"recurranceInterval":100,"surfaceElevation":0,"percentAnnualChance":0,"discharge":0},{"isBeforeMitigation":true,"recurranceInterval":500,"surfaceElevation":0,"percentAnnualChance":0,"discharge":0}],"comment":null},"DischargeValuesListAM":{"value":[{"isBeforeMitigation":false,"recurranceInterval":10,"surfaceElevation":0,"percentAnnualChance":0,"discharge":0},{"isBeforeMitigation":false,"recurranceInterval":50,"surfaceElevation":0,"percentAnnualChance":0,"discharge":0},{"isBeforeMitigation":false,"recurranceInterval":100,"surfaceElevation":0,"percentAnnualChance":0,"discharge":0},{"isBeforeMitigation":false,"recurranceInterval":500,"surfaceElevation":0,"percentAnnualChance":0,"discharge":0}],"comment":null},"usrDefaultStillWaterListSelected":{"value":true,"comment":null},"usrDefaultDischargeListSelected":{"value":false,"comment":null},"StillWaterListBM":null,"StillWaterListAM":null,"DepthDamagesBM":{"total":null,"buildings":{"total":null,"floodDepthList":[],"percentList":[],"damageList":[],"nfipList":[],"iccList":[]},"contents":{"total":null,"floodDepthList":[],"percentList":[],"damageList":[],"nfipList":[],"iccList":[]},"displacement":{"total":null,"floodDepthList":[],"percentList":[],"damageList":[],"nfipList":[],"iccList":[]},"lof":{"total":null,"floodDepthList":[],"percentList":[],"damageList":[],"nfipList":[],"iccList":[]}},"DepthDamagesAM":{"total":null,"buildings":{"total":null,"floodDepthList":[],"percentList":[],"damageList":[],"nfipList":[],"iccList":[]},"contents":{"total":null,"floodDepthList":[],"percentList":[],"damageList":[],"nfipList":[],"iccList":[]},"displacement":{"total":null,"floodDepthList":[],"percentList":[],"damageList":[],"nfipList":[],"iccList":[]},"lof":{"total":null,"floodDepthList":[],"percentList":[],"damageList":[],"nfipList":[],"iccList":[]}},"usrDepthDamagesBM":{"total":null,"buildings":{"total":null,"floodDepthList":[],"percentList":[],"damageList":[],"nfipList":[],"iccList":[]},"contents":{"total":null,"floodDepthList":[],"percentList":[],"damageList":[],"nfipList":[],"iccList":[]},"displacement":{"total":null,"floodDepthList":[],"percentList":[],"damageList":[],"nfipList":[],"iccList":[]},"lof":{"total":null,"floodDepthList":[],"percentList":[],"damageList":[],"nfipList":[],"iccList":[]}},"usrDepthDamagesAM":{"total":null,"buildings":{"total":null,"floodDepthList":[],"percentList":[],"damageList":[],"nfipList":[],"iccList":[]},"contents":{"total":null,"floodDepthList":[],"percentList":[],"damageList":[],"nfipList":[],"iccList":[]},"displacement":{"total":null,"floodDepthList":[],"percentList":[],"damageList":[],"nfipList":[],"iccList":[]},"lof":{"total":null,"floodDepthList":[],"percentList":[],"damageList":[],"nfipList":[],"iccList":[]}},"VolunteerCosts":{"usrNumberOfVolunteersRequired":{"value":0,"comment":null},"usrCostOfVolunteerTime":{"value":24.69,"comment":null},"usrNumberOfDaysLodging":{"value":0,"comment":null},"usrNumberOfHours":{"value":8,"comment":null},"usrPerPersonLodgingCost":{"value":94,"comment":null},"outVolunteerCosts":{"value":0,"comment":null},"usrDefaultLodgingCostSelected":{"value":1,"comment":null}},"SocialBenefits":{"usrNumOfPersons":{"value":0,"comment":null},"usrNumOfWorkers":{"value":0,"comment":null},"outProductivityLoss":{"value":8763,"comment":null},"outTotalBenefits":{"value":0,"comment":null},"outTotalLostProductivity":{"value":0,"comment":null},"outTotalStressAnxietyCost":{"value":0,"comment":null},"outTreatCost":{"value":2443,"comment":null}},"EnvironmentalBenefits":{"usrPercentGreenOpenSpace":{"value":0,"comment":""},"usrPercentRiparian":{"value":0,"comment":""},"usrPercentWetlands":{"value":0,"comment":""},"usrPercentForests":{"value":0,"comment":""},"usrPercentMarineEstuary":{"value":0,"comment":""},"usrSpatialUnit":{"value":1,"comment":""},"usrTotalProjectArea":{"value":0,"comment":""},"outForestsAcrePerYear":{"value":0,"comment":""},"outGreenOpenSpaceAcrePerYear":{"value":0,"comment":""},"outMarineEstuaryAcrePerYear":{"value":0,"comment":""},"outRiparianAcrePerYear":{"value":0,"comment":""},"outTotalCalculatedProjectArea":{"value":0,"comment":""},"outTotalLandUseBenefits":{"value":0,"comment":""},"outTotalPercentage":{"value":0,"comment":""},"outWetlandsAcrePerYear":{"value":0,"comment":""}},"DisplacementCost":{"usrDisplacementCostNR":{"value":0,"comment":null},"usrLodgingPerDiemDefaultSelected":{"value":true,"comment":null},"usrMealsPerDiemDefaultSelected":{"value":true,"comment":null},"usrLodgingPerDiem":{"value":94,"comment":null},"usrMealsPerDiem":{"value":55,"comment":null},"usrPopulationAffected":{"value":0,"comment":null},"outCostOfMealsAtHome":7,"outDisplacementCost":0}}

Properties

Column1
isTemplate

Release Notes

Notes Version Number Release Date
Updated properties tab to use data table for template identification. Supports backwards compatability for Office 2013. 6.0.1 7-Jun-19
Added Riverine Data worksheet to import flood projects. 6.0.2 3-Jul-19
Added Saver tab to fix MS Security Update deployed on July 9, 2019. 6.0.3 17-Jul-19

image1.png

image2.jpg