Help me check my work please

cost per mile:2.48

fuel surcharge: .56

Flayd's Burnpers has distribution centers in Laf byette, Indiana; Charlotte; North Carolina; Los Angeles, Califormia; Dallas, Texas, and Pittsburgh, Perinsylvaria Each distnbution center carnes all products sold. Hoyd's customers are auto repair shops and larger auto parts retail stores. You are asked to perform an analysis of the customer assignments to determine whidi of floyd's customers should be assigned to each distribution centec, The rule for assigning customers to distribution eenters is sinple: A customer should be assigned to the closest center. The worksheet Ployds in the provided datafile sontains the distance from each of Floyd's 1,029 customers to each of the five destributon centers. Your takk is to buld a list that tells whach distnbution center should serve each customer. The followng functions will be helgiful: min(array) The MiN functoon returns the smallest value in a set of numbers. For example, if the range A1:A. contains the values 6 , 25, and 38, then the formula =MIN(A1:AJ) returns the number 6 , beceuse it is the smallest of the three numbers: = MATCh(lookup vakie, lookup alray, mistch thpe) The MATCut function searches for a specified item in a range of cells and returns the relative postion of that item in the range: The fookup... value is the value to match, the lookup.array is the range of seacch, and match type indicates the type of motch (use o for an exact match). For example, if the range A1:AJ contains the valoes 6,25 , and 38 , then the formulo =MATCH(25, A1:A3,0) returns the number 2, because 25 is the second item in the range * InDex(ariay, columit num) The IfDEX funcson retums the value of an element in a position of an array. for example, If the range A1-A3 cantains the values 6,25 , and Je, then the formula - NDEx(A1:A3, 2) 5 25, because 25 is the value in the second postion of the array A1 A3. (Hent Create three new columns. In the first column, are the MiN function to cakculate the minimum destance for the customer in that row. In the second column use the March function to find the poction of the mainenum distance. In the thind celumit, une the positon in the previous colurnh with the INotx functoon referenang the row of discrhbution center names to find the name of the distrbubon center that should sierice that custorinet.) Click on the datafile logo to refrrence the dota. DATA (Hint: The INOtx function may be used with a two-dimerisonal array: eINDEX(array, row. mum, columin. num), where amay is a matra, row num is ihe row numbers and column fium is the colven poution of the deaired element of the matrk.) Floyd's bumpers pays a transportation company to sh p its product to its customers. flovd's Bumpers ships full truckloats to its customers. Therefore, the cost for shipping is a fanction of the distarice troveled and a fuel turcharge (also on a per mile basia). The cont per-mile is $2.48 and the fuel marcharge is 5.56 per mile. The workaheet May in the provided datafile contains data for shipments for the month of May (each record is simply the customer zip code for a given trucidoad shipment), as wel as the ditance rable from the distribution centers to each customer. Uie the VLookup function to retrieve the distance traveled for each shipment frans the exercise completed above, and. calculate the charge for each shipment. What is the total amount that floyd Bumpers spends on these May shipmerita? If required, round your answers to two decimal piaces