Case study

noir puma

WeightedDecisionCriteriaTemplate2.xlsx

Home >Applied Sciences homework help >Case study

Weighted Results

Cost

DC 2

DC3

Weight%

100

Alternative 1

Alternative 2

Alternative 3

This is just a description of the rankings

Ideal

Acceptable

Not Acceptable

Cost

DC2

DC3

Alternative 1

ERROR:#DIV/0!

Alternative 2

ERROR:#DIV/0!

Alternative 3

ERROR:#DIV/0!

Alternative 1

Alternative 2

Alternative 3

EXAMPLE COST DECISION CRITERION

Percentage

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]%

Alternative 1 Alternative 2 Alternative 3 0 0 0