\begin{tabular}{|c|c|} \hline & \multicolumn{1}{|c|}{ A } \\ \hline 1 & May Shipments \\ \hline 2 & Customer Zipcode \\ \hline 3 & 45140 \\ \hline 4 & 40069 \\ \hline 5 & 51108 \\ \hline 6 & 53154 \\ \hline 7 & 30106 \\ \hline 8 & 30567 \\ \hline 9 & 08054 \\ \hline 10 & 35603 \\ \hline 11 & 76011 \\ \hline 12 & 41042 \\ \hline 13 & 60915 \\ \hline 14 & 92394 \\ \hline 15 & 49548 \\ \hline 16 & 53916 \\ \hline 17 & 30336 \\ \hline 18 & 28341 \\ \hline 19 & 07728 \\ \hline 20 & L9P 1J5 \\ \hline 21 & 54971 \\ \hline 22 & 64755 \\ \hline 23 & 43219 \\ \hline 24 & 60164 \\ \hline \end{tabular} B C D F G K Note: each record is one shipment to the indicated customer zipcode. \begin{tabular}{l|l|} Cost per Mile & Enter the corresponding value from the problem statement. \\ Fuel Surcharge per Mile & $0.56 \end{tabular} should serve each customer. The following functions will be helpful: =MIN(array) it is the smallest of the three numbers: \[ \text { =MATCH(lookup_value, lookup_array, match type }) \] range of search, and match type indicates the type of match (use 0 for an exact match). =INDEX(array, column_num) the row of distribution center names to find the name of the distribution center that should service that customer.) Click on the datafile logo to reference the data. DATA column position of the desired element of the matrix.) Bumpers spends on these May shipments? If required, round your answers to two decimal places. $ \begin{tabular}{|c|c|} \hline & \multicolumn{1}{|c|}{ A } \\ \hline 1 & May Shipments \\ \hline 2 & Customer Zipcode \\ \hline 3 & 45140 \\ \hline 4 & 40069 \\ \hline 5 & 51108 \\ \hline 6 & 53154 \\ \hline 7 & 30106 \\ \hline 8 & 30567 \\ \hline 9 & 08054 \\ \hline 10 & 35603 \\ \hline 11 & 76011 \\ \hline 12 & 41042 \\ \hline 13 & 60915 \\ \hline 14 & 92394 \\ \hline 15 & 49548 \\ \hline 16 & 53916 \\ \hline 17 & 30336 \\ \hline 18 & 28341 \\ \hline 19 & 07728 \\ \hline 20 & L9P 1J5 \\ \hline 21 & 54971 \\ \hline 22 & 64755 \\ \hline 23 & 43219 \\ \hline 24 & 60164 \\ \hline \end{tabular} B C D F G K Note: each record is one shipment to the indicated customer zipcode. \begin{tabular}{l|l|} Cost per Mile & Enter the corresponding value from the problem statement. \\ Fuel Surcharge per Mile & $0.56 \end{tabular}