Docstoc

Supplier Comparison Chart

Document Sample
Supplier Comparison Chart Powered By Docstoc
					ABC, Inc.
Supplier Comparison Chart
Rate the Quality Critical Features of the suppliers ( 1 - worst, 10 - best ) Quality Critical Features Product Quality Service Quality Lead Time Reputation Responsiveness Price Weights 25% 13% 12% 10% 5% 35% Supplier X 4 5 7 8 2 3 Supplier Y 6 5 6 9 8 10

Total Scores: Total Weighted Scores: Rank:

29 4.44 2

44 7.67 1

General Supplier X Supplier Y Supplier Z Supplier T Supplier Q ████ ████████ ████ ████ ███

Best

hart

Supplier Z 4 7 3 8 10 2

Supplier T 1 1 2 4 4 9

Supplier Q 6 4 2 5 2 1 1 2 3 4 5 6 7 8 9 10

█ 0.25 0.13 0.12 0.1 0.05 0.35 0 0 0 0 2 2

34 4.27 4

21 4.37 3

20 3.21 5

4 5 7 8 2 3 0 0 0 0 1 1

6 5 6 9 8 10 0 0 0 0 4 4

4 7 3 8 10 2 0 0 0 0 3 3

1 1 2 4 4 9 0 0 0 0 5 5

6 4 2 5 2 1 0 0 0 0

check 1 1 1 1 1 1 0 0 0 0

4.44 1 0.65 0.84 0.8 0.1 1.05 0 0 0 0 2 24 4.44 25 4.63 ####

0 1 2 3 4 5 6 7 8 9 10

7.67 1.5 0.65 0.72 0.9 0.4 3.5 0 0 0 0 3 7.67 8 ####

4.27 1 0.91 0.36 0.8 0.5 0.7 0 0 0 0 4 4.27 4.46 ####

4.37 0.25 0.13 0.24 0.4 0.2 3.15 0 0 0 0 5 4.37 4.56 ####

3.21 1.5 0.52 0.24 0.5 0.1 0.35 0 0 0 0 6 3.21 3.35 ####

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

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

Supplier X Supplier Y Supplier Z Supplier T Supplier 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 25 13 12 10 5 35 % 25% 13% 12% 10% 5% 35%

Product Quality Service Quality Lead Time Reputation Responsiveness Price

4)

Select the rating scale that you want to use to rate the critical quality features of the suppliers:
1 1 1 1 1 1 to to to to to to 10 (1 worst, 10 best) 7 (1 worst, 7 best) 5 (1 worst, 5 best) 10 (1 best, 10 worst) 7 (1 best, 7 worst) 5 (1 best, 5 worst)

>> 5)

Your Supplier Comparison Chart is ready to use. Following steps are for online use. 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

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

1 1 1 1 1

5

these features, if necessary.

6 1 1 1 1 1 1 0 0 0 0

100 0.25 0.13 0.12 0.1 0.05 0.35 0 0 0 0

0 General 0 0 Product Quality1 -1 Service Quality 2 -1 Lead Time -1 3 Reputation -1 4 Responsiveness5 -1 Price -1 6 -1 7 -1 8 -1 9 -1 10

81-83f8-6bdb2fce8824

0 0 0 0 0 0

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

1

1

1 - worst 2 3 4 5 6

1 - worst, 10 - best

7 8 9 10 - best 10 - best


				
DOCUMENT INFO
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.