Purchase Solution

Value Curve and Swing Weights in Excel

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution
Solution Summary

The value curve and swing weights in excel is examined.

Purchase this Solution
Free BrainMass Quizzes
Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Probability Quiz

Some questions on probability

View More Free Quizzes
Related BrainMass Solutions

  • Tradeoff Weights: Evaluate the qualitative vs. the quantitative approach.

    Swing weight method forces decision makers to consider values of attribute's ranges in decision making and risk analysis process. In this method, actual weights of attributes are determined by dividing each value form the sum of all values.

  • Direct method, swing weighting, & equivalence, which one?

    Swing weights work like this; based on weighing varies amount of attributes in different areas. It can be used for qualitative analysis.

  • Statistics

    Excel file contains solution by both manual and excel method. Hope this is useful to you. Thanks Excel file contains solution by both manual and excel method. It contains ANOVA analysis and calculate p -value

  • Decision-Making Techniques

    The different methods of tradeoff weights are direct method, swing weights, and equivalence lottery.

  • ANOVA Output of Shift Workers

    Based on these ratings presented in the table below, produce an ANOVA table and determine if the average amount of output for any shift is different then the others.

  • optimal production level

    The production function to build a playground swing is: Q = 15 + 8L - 0.6L2 Where: Q is the total number of swings built in an hour L is the labor of one worker If it costs $10 per hour for a laborer and each swing is sold for $20 and there

  • Population has average weight of 71kgs. Compute a test statistic.

    A sampling of that population resulted in the following weights: Weights in kgs 60 62 65 68 69 69 71 72 75 77 c. Find a 95% confidence interval for this sample of data. d.

  • Calculating the WACC using the market value weights

    The solution helps in estimating the WACC using the market value weights and book value.

  • Physics of Using Dumbbells and Case of George of the Jungle

    My Weight is 149.69 kg (330 lbs) Weights that I held = 3.63 kg (8 lbs) Time it took to make 1 full rotation with the weights held out as in figure (a) = 2.19 sec Time it took to make 1 full rotation with my arms held in as if figure (b) George

View More Related Solutions