supplier comparison chart

11
ABC, Inc Supplier Comparis Rate the Quality Critical Features of the suppl ( 1 - worst, 10 - best ) Quality Critical Features Weights Supplier X Product Quality 25% 4 Service Quality 13% 5 Lead Time 12% 7 Reputation 10% 8 Responsiveness 5% 2 Price 35% 3 Total Scores: 29 Total Weighted Scores: 4.44 Rank: 2 General Supplier X ████ Best Supplier Y ████████ Supplier Z ████ Supplier T ████ Supplier Q ███

Upload: spreadsheetzone

Post on 16-Nov-2014

280 views

Category:

Documents


0 download

DESCRIPTION

This template is prepared for evaluating different suppliers on the critical quality features. These features can be weighted. 6 different scales for ranking the suppliers is provided. The performances of the suppliers for critical quality features are displayed by a bar chart and the best suppliers for each feature are selected. SpreadsheetWEB version of the template provides all features of the template, also can be used, saved and edited online.

TRANSCRIPT

Page 1: Supplier Comparison Chart

ABC, Inc.Supplier Comparison Chart

Rate the Quality Critical Features of the suppliers( 1 - worst, 10 - best )

Quality Critical Features Weights Supplier X Supplier YProduct Quality 25% 4 6Service Quality 13% 5 5Lead Time 12% 7 6Reputation 10% 8 9Responsiveness 5% 2 8Price 35% 3 10

Total Scores: 29 44Total Weighted Scores: 4.44 7.67

Rank: 2 1

General

Supplier X ████Best Supplier Y ████████

Supplier Z ████Supplier T ████Supplier Q ███

Page 2: Supplier Comparison Chart

ABC, Inc.Supplier Comparison Chart

Supplier Y Supplier Z Supplier T Supplier Q6 4 1 65 7 1 46 3 2 29 8 4 58 10 4 2

10 2 9 1

44 34 21 207.67 4.27 4.37 3.21

1 4 3 5

███████████████████████

Page 3: Supplier Comparison Chart

█ check 0 4.44 7.67 4.27 4.37 3.211 0.25 4 6 4 1 6 1 1 1 1.5 1 0.25 1.52 13% 5 5 7 1 4 1 2 0.65 0.65 0.91 0.13 0.523 12% 7 6 3 2 2 1 3 0.84 0.72 0.36 0.24 0.244 10% 8 9 8 4 5 1 4 0.8 0.9 0.8 0.4 0.55 5% 2 8 10 4 2 1 5 0.1 0.4 0.5 0.2 0.16 35% 3 10 2 9 1 1 6 1.05 3.5 0.7 3.15 0.357 0 0 0 0 0 0 0 7 0 0 0 0 08 0 0 0 0 0 0 0 8 0 0 0 0 09 0 0 0 0 0 0 0 9 0 0 0 0 0

10 0 0 0 0 0 0 0 10 0 0 0 0 02 3 4 5 6

2 1 4 3 5 24 4.44 7.67 4.27 4.37 3.212 1 4 3 5 25 4.63 8 4.46 4.56 3.35

### TRUE ### ### ###

Page 4: Supplier Comparison Chart

Follow the steps to enable your Supplier Comparison Chart.1) Type the name of your company:

ABC, Inc.2) Type the name of suppliers that you want to compare (up to 5):

Supplier XSupplier YSupplier ZSupplier TSupplier Q

3) Type the critical quality features for suppliers that you want to evaluate. You can also assigne rates to these features, if necessary.

You can use any scale for weights.

Critical Quality Features Weights %

Product Quality 25 25%

Service Quality 13 13%

Lead Time 12 12%

Reputation 10 10%

Responsiveness 5 5%

Price 35 35%

4) Select the rating scale that you want to use to rate the critical quality features of the suppliers:

>> Your Supplier Comparison Chart is ready to use. Following steps are for online use.

5) Visit the site below:

http://www.spreadsheetweb.com/getting_started.htm

You will only need the username and password to create your Supplier Comparison Chart.

6) Visit the site below:

https://www4.spreadsheetweb.com/SpreadsheetWEB//

Login to page with your new account information.

7) Click "Add Web Application" to upload this file. Your Supplier Comparison Chart will be created automatically.

You can simply use the Supplier Comparison Chart from that link or place it on your website.

>> Your Supplier Comparison Chart will look like:

http://www1.spreadsheetweb.com/SpreadSheetWEB/Output.aspx?ApplicationId=5a14e64e-3c53-4d81-83f8-6bdb2fce8824

>> In order to see more online applications created with PSW you can check the link below:

http://www.spreadsheetweb.com/demos.htm

Page 5: Supplier Comparison Chart

Copyright (c) 2009 Pagos, Inc. http://www.pagos.com/

Page 6: Supplier Comparison Chart

Follow the steps to enable your Supplier Comparison Chart.

1 51111

Type the critical quality features for suppliers that you want to evaluate. You can also assigne rates to these features, if necessary.

06 100 Gener 0 01 0.25 Produc -1 11 0.13 Servic -1 21 0.12 Lead -1 31 0.1 Reput -1 41 0.05 Respo -1 51 0.35 Price -1 60 0 -1 70 0 -1 80 0 -1 90 0 -1 10

Click "Add Web Application" to upload this file. Your Supplier Comparison Chart will be created automatically.

http://www1.spreadsheetweb.com/SpreadSheetWEB/Output.aspx?ApplicationId=5a14e64e-3c53-4d81-83f8-6bdb2fce8824

Page 7: Supplier Comparison Chart

0 1 to 10 (1 worst, 10 best)0 1 to 7 (1 worst, 7 best)0 1 to 5 (1 worst, 5 best)0 1 to 10 (1 best, 10 worst)0 1 to 7 (1 best, 7 worst)0 1 to 5 (1 best, 5 worst)1 1

Page 8: Supplier Comparison Chart

1 to 10 (1 worst, 10 best) 1 - worst 1 - worst, 10 - best1 to 7 (1 worst, 7 best) 21 to 5 (1 worst, 5 best) 31 to 10 (1 best, 10 worst) 41 to 7 (1 best, 7 worst) 51 to 5 (1 best, 5 worst) 6

78

Page 9: Supplier Comparison Chart

910 - best

10 - best