Problem 7-19 Floyd's Bumpers pays a transportation company

Floyd's Bumpers pays a transportation company to ship its product to its customers. Floyd's Bumpers
ships full truckloads to its customers. Therefore, the cost for shipping is a function of the distance
traveled and a fuel surcharge (also on a per mile basis). The cost per mile is $2.42 and the fuel
surcharge is $.56 per mile. The file FloydsMay contains data for shipments for the month of May (each
record is simply the customer zip code for a given truckload shipment), as well as the distance table
from the distribution centers to each customer. Use the MATCH and INDEX functions to retrieve the
distance traveled for each shipment and calculate the charge for each shipment. What is the total
amount that Floyd's Bumpers spends on these May shipments?
Click on the webfile logo to reference the data.

Hint: The INDEX function may be used with a two-dimensional array: =INDEX(array, row_num,
column_num), where array is a matrix, row_num is the row numbers and column_numis the column
position of the desired element of the matrix.
If required, round your answers to two decimal places.