Recreate the spreadsheet in Figure 7-19 in your spreadsheet package. Change the weights and compare the outcome to Figure 7-19. Change the rankings. Add criteria. What additional information does this “what if ” analysis provide for you as a decision maker? What insight do you gain into the decision-making process involved in choosing the best alternative system design?

Figure 7.19.

Transcribed Image Text:

Criteria Requirements Real-time data entry Auto reorder Real-time data query Constraints Development costs Hardware costs Time to operation Ease of training Total Weight Alternative A Rating Score 18 18 14 50 20 15 10 5 50 100 5 90 3 54 1 14 158 5 5 5 5 100 75 50 25 250 408 Alternative B Alternative C Rating Score Rating Score 5 5 3 4 4 4 3 90 90 42 222 80 60 40 15 195 417 5 5 5 3435 90 90 70 250 60 60 30 25 175 425