Question: Consider a supply chain network with two potential sites for warehouses and four retailer regions. The fixed costs of locating warehouses at the three sites

Consider a supply chain network with two potential sites for warehouses and four retailer regions. The fixed costs of locating warehouses at the three sites are given as follows: Site 1: $500,000 Site 2: $600,000 The capacities of the two sites are 60,000 and 65,000 respectively. The retailer demands are 10,000, 20,000, 15,000 and 30,000 units respectively The unit transportation costs ($) are given in the following table: R R2 R3 R4 Site 1 10 8 00 4 Site 2 4 12 9 3 ) Formulate a mixed integer linear program to determine the optimal location and distribution plan that will minimize the total cost. Assume each retailer has to be supplied by exactly one warehouse Solve using Excel Solver. a. What is the total cost of your optimal solution? b. What is the distribution plan proposed by your solution to satisfy customer demand

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!

Consider a supply chain network with three potential sites for warehouses and eight retailer regions. The fixed costs of locating warehouses at the three sites are given below: Site 1: $100,000 Site...

Need help with this question? Hint: Repla & (0, 1) for i = 1, 2, ..., 5. 5.10 (Adapted from Srinivasan, 2010) Consider a supply chain network with three potential sites for warehouses and eight...

(30 points) Consider a supply chain network with three potential sites for warehouses and five retailer regions. The fixed costs of building warehouses at the three sites are: Site 1: $100,000 Site...

this the fourmultion is ready i want to but in lingo to get the solution 5.10 (Adapted from Srinivasan, 2010) Consider a supply chain network with three potential sites for warehouses and eight...

5 . 1 0 ( Adapted from Srinivasan, 2 0 1 0 ) Consider a supply chain network with three potential sites for warehouses and eight retailer regions. The fixed costs of locating warehouses at the three...

Consider a supply chain network with three potential sites for warehouses and eight retailer regions. The fixed costs of locating warehouses at the three sites are given as follows: Site 1 : $ 1 5 0...

( Location - distribution problem, reference: LN _ Ch 1 _ 0 4 ) Consider a supply chain network with three potential sites for warehouses and eight retailer regions. The fixed costs ( initial capital...

Consider a supply chain network with three potential sites for warehouses and eight retailer regions. The fixed costs ( i n i t i a l capital investment ) o f locating warehouses a t the three sites...

4. (25 points) Consider a supply chain network with three potential sites for warehouses and five retailer regions. The fixed costs of building warehouses at the three sites are given as follows:...

When business transactions are conducted internationally, cultural differences must be taken into consideration. Geert Hofstede is a leading researcher on how cultural variables can affect such...

Benerux Industries has been in business for 30 years. The firms major product is a control unit for elevators. The firm has a reputation for manufacturing products of exceptionally high quality,...

Question 1 4 2 pts A city reports deferred tax revenue of $ 3 0 0 , 0 0 0 at the beginning of the year and $ 3 5 0 , 0 0 0 at the end of the year. What adjustment is needed to fund balance to...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...