Chat with us, powered by LiveChat Case study | Gen Paper
+1(978)310-4246 credencewriters@gmail.com
  

Weighted Results

Cost DC 2 DC3
Weight% 30 40 30 100
Alternative 1 0
Alternative 2 0
Alternative 3 0
This is just a description of the rankings
Ideal 1
Acceptable 2
Not Acceptable 3
Cost DC2 DC3
Alternative 1 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Alternative 2 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Alternative 3 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Alternative 1 Alternative 2 Alternative 3 EXAMPLE COST DECISION CRITERION
Percentage ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
There are three criteria and each of the ratings will be given a calculated weight equal to 100%. The higher the weight, the more important the decision criteria is. Each criteria will also be rated on a scale of 1 to 3; 1 = an ideal solution, 2 = an acceptable solution, and 3 = an unacceptable solution.
Cost – 30%
Each alternative will be measured on the cost to implement, which includes internal, external, and capitalized costs.
Step 1 ·      Any alternative that falls under $25,000 will be rated a 1.
List Key Critiera horizontally and Alternatives vertically ·      Any alternative that falls between $25,000 and $50,000 will be rated a 2.
Enter in the percentage each criteria was valued at ·      Any alternative that exceeds $50,000 will be rated a 3.
Enter in rating; ideal, acceptable, not acceptable (1,2,3)
Step 2
Calculation: Each rating (1,2,3) divided by key decision criteria percentage
Do this for every Alternative
To create the chart:
List alternatives horizontally and and value of the total provided by the calculation for each alternative
Click Insert, select chart, voila!

Alternative Analysis and Evaluation

Percentage

[VALUE]%

[VALUE]%

[VALUE]%

Alternative 1 Alternative 2 Alternative 3 0 0 0

error: Content is protected !!