Reference no: EM131668787
Question: 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.
|
Compare the performance of your designs with the fifo
: Design a "FIFO" memory system with following characteristics. Compare the performance of your designs with the FIFO that can be generated using the FIFO WIZARD.
|
|
Product has an own-price elasticity
: A firm sells a product for $25, and the product has an own-price elasticity of -4. Currently they sell 1,000 units.
|
|
Explain why marginal revenue is negative
: What is marginal revenue at the current price? Given that price is above marginal cost, explain why marginal revenue is negative.
|
|
Pricing manager for a fantasy football expert site
: You are the pricing manager for a fantasy football expert site. It is your job to set the price consumers must pay to "subscribe".
|
|
Define the min-match and index function
: Floyd's Bumpers has distribution centers in Lafayette, Indiana: Charlotte, North Carolina; Los Angeles, California; Dallas, Texas; and Pittsburgh, Pennsylvania.
|
|
The financials of the company in terms of project cash flows
: analyze the financials of the company in terms of project cash flows, ratio analysis, Profit and loss account, net present value and Internal rate of return.
|
|
What is your response to this plan
: We shouldn't stop addressing this concern until shoplifting is completely eliminated!" As a manager (and an economist) what is your response to this plan?
|
|
Have you ever liked a company or product on facebook
: Have you ever "liked" a company or product on Facebook? Participated in a company's blog or posted pictures on their website?
|
|
Calculate the profit maximizing quantity
: Calculate the profit maximizing quantity, price, and elasticity of demand at that point.
|