# Floyd's Bumpers has distribution centers in Lafayette, Indiana: Charlotte, North Carolina; Los Angeles, California; Dallas, Texas; and

## Question:

The rule for assigning customers to distribution centers is simple: A customer should be assigned to the closest center. The data file Floyds contains the distance from each of Floyd's 1029 customers to each of the five distribution centers. Your task is to build a list that tells which distribution center should serve each customer. The following functions will be helpful:

5MIN(array) The MIN function returns the smallest value in a set of numbers. For example, if the range A1:A3 contains the values 6, 25, and 38, then the formula 5MIN(A1:A3) returns the number 6, because it is the smallest of the three numbers.

5MATCH(lookup_value, lookup_array, match type) The MATCH function searches for a specified item in a range of cells and returns the relative position of that item in the range. The lookup_ value is the value to match, the

lookup_array is the range of search, and match type indicates the type of match (use 0 for an exact match).

For example, if the range A1:A3 contains the values 6, 25, and 38, then the formula 5MATCH(25,A1:A3,0) returns the number 2, because 25 is the second item in the range.

5INDEX(array, column_num) The INDEX function returns the value of an element in a position of an array. For example, if the range A1:A3 contains the values 6, 25, and 38, then the formula 5INDEX(A1:

A3, 2) = 25 because 25 is the value in the second position of the array A1:A3. Distribution

The word "distribution" has several meanings in the financial world, most of them pertaining to the payment of assets from a fund, account, or individual security to an investor or beneficiary. Retirement account distributions are among the most...

Fantastic news! We've Found the answer you've been seeking!

## Step by Step Answer:

**Related Book For**

## Essentials Of Business Analytics

**ISBN:** 611

1st Edition

**Authors:** Jeffrey Camm, James Cochran, Michael Fry, Jeffrey Ohlmann, David Anderson, Dennis Sweeney, Thomas Williams