I NEED HELP WITH SOLVING ON THE EXCEL SHEET OR WHAT TO APPLY IN IT$.$

QUESTION: A Chicago$-$based manufacturer is looking for someone to handle its shipments to the West Coast. In order to evaluate potential transportation providers, the manufacturer has 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:

Please open the sheet that I uploaded and 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.

QUESTIONS ATTACHED $-$ Are there any firms who can be ruled out based on failing to meet the order qualifiers?

Who is most likely to win the business? Why?

$-$ Who is most likely to win the business? Why?

$-$ What is going on with Fed.P$.$S$.?$ What does Fed.P$.$S$.$ need to do in order to compete successfully for the business?

$-$ Comment on Ship$-$It$-$All$$s competitive position. Does it meet the minimum requirements? Is it very competitive? Why or why not?