$1)$ Calculate the supplier performance index $($SPI$)$ for each supplier, inclusive of delivery costs $-$ round to $3$ decimal places. $(15$ pts$)$

$2)$ Applying the SPI from question #$1,$ calculate the total delivered unit cost from each supplier, adjusted for inflation $-$ round to $2$ decimal places. $(10$ pts$)$

$3)$ Produce a weighted point system evaluation matrix for these suppliers. $(10$ pts$)$

a$)$ Use primary categories of Cost, Quality, Service, and Innovation $$ determine your own sub$-$categories.

b$)$ Determine your own weighting and scoring criteria

$4)$ If your goal is to rationalize and consolidate your purchasing volume with $2$ suppliers, which $2$ would you recommend keeping? Why? Based on your adjusted $($for SPI and inflation$)$ pricing, what will be your annualized savings $($split the full volume $60/40$ between your selected $2$ remaining suppliers$)?(10$ pts$)$

$5)$ For the $2$ suppliers that you choose, identify and explain at least $2$ areas in which you can challenge them for further savings and$/$or continued performance improvement? $(5$ pts$)$