Assignment:
Q1. 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
Q2. Define "swing weights" for each of the four listed in 1. (may be notional)
Q3. Create a decision matrix comparing 1 & 2.
Provide complete and step by step solution for the question and show calculations and use formulas.