Home / Questions / Floyds Bumpers has distribution centers in Lafayette Indiana Charlotte North Carolina Los ...
Floyd’s Bumpers has distribution centers in Lafayette, Indiana: Charlotte, North Carolina; Los Angeles, California; Dallas, Texas; and Pittsburgh, Pennsylvania. Each distribution center carries all products sold. Floyd’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 which of Floyd’s customers should be assigned to each distribution center. 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:
=MIN(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 =MIN(A1:A3) returns the number 6, because it is the smallest of the three numbers.
=MATCH(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 =MATCH(25,A1:A3,0) returns the number 2, because 25 is the second item in the range.
=INDEX(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 =INDEX(A1: A3, 2) 5 25 because 25 is the value in the second position of the array A1:A3. In the second column use the MATCH function to find the position of the minimum distance. In the third column, use the position in the previous column with the INDEX function referencing the row of distribution center names to find the name of the distribution center that should service that customer.
Apr 25 2020 View more View Less
17. (8 pts) Find the area of the region bounded by y=x?, and x = y.
May 05 2021A planned free way connecting two cities was originally budgeted to cost $200 million. After building part of the system ata cost of $150 million, the government realised...
May 23 2018Explain an appropriate response by the public employer to the following situation.Case Study 2: The state of Wisconsin prohibited employment discrimination on the basis o...
Aug 27 2020Explain the data component of social media information systems (SMIS).38) Explain the procedure component of social media information systems (SMIS) with respect to a us...
Dec 24 2019Non-Profit Organizations Please respond to the each and every single requested information following in 2-3 thorough paragraphs: (Please provide your resources) • 1. Prop...
May 02 2020Week 4 Discussion Initial Response 1: Social Media can be updated from a variety of devices and connectivity methods. In many situations, this has made social media the d...
May 02 2020Define the features of and indicate the differences between the four types of the market structure – perfect competition, monopoly, monopolistic competition, and oligopol...
Mar 19 2020How to make a schedule for employees working in a big firm?
Aug 22 2020Data related to the acquisition of timber rights and intangible assets during the current year ended December 31 are as follows:a. Timber rights on a tract of land were p...
May 04 2021Alex Hardaway borrowed $90,000 on March 1, 2008. This amount plus accrued interest at 12% compounded semi annually is to be repaid March 1, 2018. To retire this debt, Ale...
May 07 2018