Consider the following table:

a$.$ Draw hierarchical structure of the decision$-$making process $($Goal$,$ Criteria, and alternatives$)$

b$.$ Use SAW and TOPSIS method to rank the candidate. Assume that all the criteria have the same weight

c$.$ Use SAW and TOPSIS method to rank the candidate. Assume that cost is twice important than quality,

quality is $2$ time important than delivery time, delivery time is $3$ time important than production capacity

and the rest have the same importance.

Supplier A

Supplier B

Supplier C

Supplier D

Supplier E please solve with excel solver and send it with tables