There are five candidate suppliers (A, B, C, D and E) to select for a manufacturing company The evaluation criteria are profit, service network, financial stability of supplier, delivery conditions, geographical location and quality The following matrix shows the scores of the suppliers for all criteria Supplier profit service network financial stability delivery conditions geographical loc quality A 5 8 6 4 9 1 B 5 1 7 6 5 9 C 7 9 5 2 4 2 D 7 7 2 1 2 9 E 4 4 9 9 10 1 The criteria weights are given in the following table profit service network financial stability delivery conditions geographical loc quality 0 28 0 24 0 16 0 07 0 1 0 15 Question 1 Using TOPSIS methodology, calculate the score of each supplier and find out the best supplier Please create an Excel file f Question 2 ( Using ELECTRE methodology, find out the best supplier Please create an Excel file

Question: There are five candidate suppliers (A, B, C, D and E) to select for a manufacturing company. The evaluation criteria are profit, service network, financial

Step by Step Solution

Students Have Also Explored These Related General Management Questions!

The Answer is in the image, click to view ...

There are five candidate suppliers (A, B, C, D and E) to select for a manufacturing company. The evaluation criteria are profit, service network, financial stability of supplier, delivery conditions, geographical location and quality.

The following matrix shows the scores of the suppliers for all criteria:

The criteria weights are given in the following table:

profit	service network	financial stability	delivery conditions	geographical loc.	quality
0.28	0.24	0.16	0.07	0.1	0.15

Question 1

Using TOPSIS methodology, calculate the score of each supplier and find out the best supplier. Please create an Excel file f

Question 2 (

Using ELECTRE methodology, find out the best supplier. Please create an Excel file

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Supplier

profit

service network

financial stability

delivery conditions

geographical loc.

quality

Margie Frump is employed as a teacher. She occasionally purchases items that she uses in the course of her employment that are subject to depreciation. Assets held by Margie at 30 June 2021: Margie...

Excel There are five candidate suppliers (A, B, C, D and E) to select for a manufacturing company. The evaluation criteria are profit, service network, financial stability of supplier, delivery...

Work on the following problem: There are five candidate suppliers (A, B, C, D and E) to select for a manufacturing company. The evaluation criteria are price, delivery conditions, geographical...

Using AHP methodology, the calculate score of each supplier and find out the best supplier . For each matrix, you must show your calculations. Note that you must also conduct consistency analysis for...

There are five candidate suppliers (A, B, C, D and E) to select for a manufacturing company. The evaluation criteria are price, delivery conditions, geographical location and quality. The following...

There are five candidate suppliers (A, B, C, D and E) to select for a manufacturing company. The evaluation criteria are price, delivery conditions and quality. The following matrix compares the...

Excel Question 1 (100 points). There are five candidate suppliers (A, B, C, D and E) to select for a manufacturing company. The evaluation criteria are price, delivery conditions, geographical...

The oil company, ExxonMobil has been notably sceptical about the commercial prospects for renewable energy production. Instead, its focus seems to be to secure an increasingly dominant position in...

Anthony carelessly rolls his toy car off a 77.0-cm-high table. The car strikes the floor at a horizontal distance of 98.0 cm from the edge of the table. (a) What was the velocity with which the car...

There are four types of accounting changes principles, estimates, entities and errors. Group of answer choices True False

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...