Question: Hint: The INDEX function may be used with a two - dimensional array: = INDEX ( array , row _ num, column, num ) ,

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_ num is the column position of the desired element of the matrix.) 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.56 and the fuel surcharge is $.56 per mile. The worksheet May in the provided datafile contains data for shipments for the month of May (each record is simply the cuntomer zp code for a given truckload shipment), as well as the distance table from the distribution centers to cech customer. Use the VLookUP function to retrieve the distance traveled for each shipment from the exerose completed above, and calculate the charge for each shipment. What is the total amount that floyd's Bumpers spends on these May shipments? If required, round your answers to two decimal places.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!