Rate Supply

profileTifa99
FactorRatingSupplierStudent.xlsx

Sheet1

Florida Power in Light is trying to determine which supplier will be used to provide generators to produce electricity for residents of the state. A Factor Rating matrix has been developed for 3 potential suppliers of these generators. Perform analysis on the potential suppliers by completing the matrix.
Which supplier would you select and why?
Factor Weight Westinghouse ABB Seimens
Reliability 0.3 2 3 5
Price 0.2 5 3 4
Technology 2 5 4
Lead Time 0.1 3 5 4
Flexibility 0.1 4 5 4