Assignment2Database.xlsx

Sheet1

AlternativesOptimistic ConditionsRealistic ConditionsPessimistic Conditions
Apartment Building430000350000-110000
Office Building260000150000-240000
Warehouse360000220000-140000
Probability0.350.510.14
Fee for Survey13000
Probability of survey results positive0.58
Probability of survey results negative0.42
If the analysis report results positiveOptimistic ConditionsRealistic ConditionsPessimistic Conditions
probability0.670.210.12
If the analysis report results negativeOptimistic ConditionsRealistic ConditionsPessimistic Conditions
probability0.110.310.58