Using the $7$ step process for developing a supplier evaluation and selection survey, compare three suppliers of a product$/$service that you are familiar with $($for example an online store where you purchase or have purchased products, local stores where you may shop, or an example of three suppliers for similar products where you work$).$ In MS Excel, create a supplier evaluation survey similar to the one in Exhibit $7\mathrm{.}7$ with categories, sub$-$categories, and weights for each one based upon what you consider important in making a decision to purchase from a supplier.$$ Using your evaluation form, rate each of the suppliers for the product$/$service based upon your observations.$$ Provide your evaluation sheet and your scores in a format like the one presented in Exhibit $7\mathrm{.}7.$ Evaluate the results and make a determination of which supplier you would select and why.$$

Note $1$: In order to earn credit for your answers to the problems, you are$$required$$to$$show all supporting work. You will be expected to use Microsoft Office applications$($Excel and Word$)$ when showing your supporting work.

Note $2$: If the problem asks you to draw an illustrative figure such as a chart, graph, or diagram, please do so in order to earn credit.