$\backslash$table$[[1],[2,$Dimension,Importance,$\backslash$table$[[$Wolfbyte$],[$Performance$]],\backslash$table$[[$Dole Microsystems$],[$Performance$]]],[3,$Performance quality,$,4,3],[4,$Delivery speed,$1,3,5],[5,$After$-$sales support,$2,4,2],[6,$Cost,$4,2,4],[7,$Value index,,,$],[8,,,,],[9,,,,]]$

$24$ points developed the following criteria.

At a minimum, a shipper must be able to:

Pick up shipments in $10$ hours or less from the time they are notified. $($The manufacturer doesn't have enough space for shipments to sit around at the dock.$)$

Deliver shipments in $72$ hours or less.

Beyond this, shippers will be evaluated according to cost and the percentage of shipments that arrive undamaged.

Three shippers $-$ Big Ed$,$ Ship$-$It$-$All, and Fed.P$.$S$.-$ have put in bids for the business. The relevant performance information for the shippers is shown in the following chart:

$\backslash$table$[[,$Big Ed$,$Ship$-$It$-$All,Fed.P$.$S$.],[$Pickup time,$5$ hours,$10$ hours,$12$ hours$],[\backslash$table$[[$Shipping time$],[$Cost per $100$ lb shipment$],[\%$ of shipments that arrive$]],54$ hours,$72$ hours,$48$ hours$]]$

Download the Excel template file, In Excel, mark out order qualifier and order winner, show the qualifier level for order qualifiers, create the score table using If and$/$or RANK.AVE functions, generate the graph to show how well each of the shippers performs with regard to each performance dimension. Refer to the style of in$-$class example

undamaged

$H01.Q2.xlsx$ darr

Upload your Excel file.