$1.$ 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.

Criteria unit

C$1$ quality Score $(1-9)$

C$2$ cost $ $($dollar$)$

C$3$ delivery time days

C$4$ production capacity tons

C$5$ flexibility Score $(1-9)$

C$6$ payment term Score $(1-9)$

C$7$ information technology Score $(1-9)$

C$8$ packing Score $(1-9)$

C$9$ experience years

C$10$ customer relationship Score $(1-9)$

C$11$ environmental factor Score $(1-9)$

C$1$ C$2$ C$3$ C$4$ C$5$ C$6$ C$7$ C$8$ C$9$ C$10$ C$11$

Supplier A Normal $$20,000224177372655$

Supplier B Medium $$23,000205089761566$

Supplier C High $$25,000244379482079$

Supplier D Normal $$22,500277568661976$

Supplier E Medium $$21,500296087462367$ please solve with excel solver and send me the excel tables