Questions:
Value Curve and Swing Weights in Excel
1. Generate a value curve using Excel for the following problem:
Provide air movement: objective 50 mph; min 20 mph; max 100 mph.
Provide electrical power: objective 30 amps; min 10 amps; max 50 amps.
Provide communication: objective 120 miles; min 100 miles; max 200 miles
Provide ground movement: objective 4 mph; min 1 mph; max 8 mph
2. Define "swing weights" for each of the four listed in 1. (may be notional)
3. Create a decision matrix comparing 1 & 2.