Pareto Frontier and design option

profileoluwafemi45
MAVFTOASpreadsheet.xlsx
Home>Engineering homework help>Pareto Frontier and design option

TO Analysis

Design Options Low => Good Low => Good High => Good
Options Pfd Pfn Ao
Design 1 0.0000024 0.010 0.999
Design 2 0.0000024 0.002 0.997
Design 3 0.0000008 0.020 0.999
Design 4 0.0000008 0.010 0.997
Design 5 0.0000008 0.002 0.993
Design 6 0.0000006 0.020 0.997
Design 7 0.0000006 0.010 0.993
Swing Weighting
Case Pfd Pfn Ao Rank Weight Wt Value
Worst 0.0000024 0.020 0.993 0
Best, Worst , Worst 0.0000008 0.020 0.993 100 wfd = 0.435
Worst, Best, Worst 0.0000024 0.002 0.993 80 wfn = 0.348
Worst, Worst, Best 0.0000024 0.020 0.999 50 wa = 0.217
230
MAVF Analysis Table Wt1 = wfd Wt2 = wfn Wt3 = wa
0.435 0.348 0.217
Design Option SVVF1 SVVF2 SVVF3 MAVF
Pfd Pfn Ao Vfd Vfn Va Vt
Design 1 0.0000024 0.010 0.999 0.00 0.56 1.00 0.41
Design 2 0.0000024 0.002 0.997 0.00 1.00 0.67 0.49
Design 3 0.0000008 0.020 0.999 0.89 0.00 1.00 0.60
Design 4 0.0000008 0.010 0.997 0.89 0.56 0.67 0.72
Design 5 0.0000008 0.002 0.993 0.89 1.00 0.00 0.73
Design 6 0.0000006 0.020 0.997 1.00 0.00 0.67 0.58
Design 7 0.0000006 0.010 0.993 1.00 0.56 0.00 0.63
Low Value 0.0000006 0.002 0.993
High Value 0.0000024 0.020 0.999
Uncertainties Pfd
Pfn
Ao
Rfd
Rfn
Ra
Reference Case = DO 4

Sensitivity Study

Reference Case = DO 4
Metric: MAVF
Questions:
What factor uncertainties have biggest impact?
Which factor(s) should one attempt to get a better estimate for?
What is effect on recommendation?
Factor Uncertainties Swing Weighting
Reference High Low Case Pfd Pfn Ao Rank Weight Wt Value
Pfd 0.0000008 0.0000009 0.0000007 Worst 0.0000024 0.020 0.993 0
Pfn 0.002 0.0022 0.0018 Best, Worst , Worst 0.0000008 0.020 0.993 100 wfd = 0.455
Ao 0.993 0.9935 0.9925 Worst, Best, Worst 0.0000024 0.002 0.993 80 wfn = 0.364
Rfd 100 100 90 Worst, Worst, Best 0.0000024 0.020 0.999 40 wa = 0.182
Rfn 80 100 70 220
Ra 50 60 40
MAVF Single Factor Uncert Table (for DO 4) Analysis Table Wt1 = wfd Wt2 = wfn Wt3 = wa
Reference High Fi Low Fi 0.455 0.364 0.182
Pfd 0.734 0.71 0.758 Design Option SVVF1 SVVF2 SVVF3 MAVF
Pfn 0.734 0.73 0.738 Pfd Pfn Ao Vfd Vfn Va Vt
Ao 0.734 0.752 0.716 Design 1 0.0000024 0.010 0.999 0.00 0.56 1.00 0.384
Rfd 0.734 0.734 0.727 Design 2 0.0000024 0.002 0.997 0.00 1.00 0.67 0.485
Rfn 0.734 0.756 0.722 Design 3 0.0000008 0.020 0.999 0.89 0.00 1.00 0.586
Ra 0.734 0.768 0.704 Design 4 0.0000008 0.010 0.997 0.89 0.56 0.67 0.727
Design 5 0.0000008 0.002 0.993 0.89 1.00 0.00 0.768
Design 6 0.0000006 0.020 0.997 1.00 0.00 0.67 0.576
Design 7 0.0000006 0.010 0.993 1.00 0.56 0.00 0.657
Low Value 0.0000006 0.002 0.993
High Value 0.0000024 0.020 0.999
Tornado Table (MAVF for DO 4)
Change in MAVF
Low Vt High Vt
Pfd -0.024 0.024
Pfn -0.004 0.004
Ao -0.018 0.018
Rfd -0.007 -0.000
Rfn -0.012 0.022
Ra -0.030 0.034
Total DO4 Uncertainty = 0.0504839583

Sensor System Design Tornado Diagram

Low Vt Pfd Pfn Ao Rfd Rfn Ra -2.4299516908212526E-2 -4.2995169082125084E-3 -1.8299516908212521E-2 -7.2995169082125111E-3 -1.2299516908212516E-2 -3.0299516908212532E-2 High Vt Pfd Pfn Ao Rfd Rfn Ra 2.3700483091787516E-2 3.7004830917874987E-3 1.7700483091787511E-2 -2.9951690821250487E-4 2.1700483091787515E-2 3.3700483091787525E-2

Factor

Change in MAVF

DO Costs

Design Options Low => Good Low => Good High => Good
Options Pfd Pfn Ao Cost
Design 1 0.0000024 0.010 0.999 $ 25.16
Design 2 0.0000024 0.002 0.997 $ 25.25
Design 3 0.0000008 0.020 0.999 $ 37.58
Design 4 0.0000008 0.010 0.997 $ 32.96
Design 5 0.0000008 0.002 0.993 $ 37.00
Design 6 0.0000006 0.020 0.997 $ 43.64
Design 7 0.0000006 0.010 0.993 $ 42.98
Value Cost of Pfd Cost of Pfn Cost of Ao
Low $ 27.78 $ 11.18 $ 10.20
Medium $ 15.63 $ 5.00 $ 12.33
High $ 1.74 $ 3.54 $ 18.42