A large furniture company has six retail locations spread out across Ontario and Quebec. To better...

Transcribed Image Text:

A large furniture company has six retail locations spread out across Ontario and Quebec. To better serve these retail locations, the company has decided to open new distribution centers to supply inventory to the retail locations. There are two types of costs associated with the delivery: set-up costs (fixed costs) are capital costs which may usually be written off over several years, and transportation costs which depend on the distance covered. We assume that they have been put on some comparable basis, by taking the costs over a year. There are 6 sites available for the construction of new distribution centers to deliver inventory to the retail locations. Retail Locations 1 2 3 100 80 50 120 90 60 140 110 80 160 125 100 190 150 130 200 180 150 ∞ Table 1: Transportation costs for satisfying entire demand of each retail location Distribution Center 1 2 3 4 5 6 4 50 70 65 80 75 100 80 5 6 60 100 100 130 150 ∞ ∞ ∞ ∞ ∞ Table 1 gives the transportation costs (in thousand dollars) of delivering the entire demand of each retail location from a distribution center (not the unit costs). Certain deliveries that are impossible are marked with the infinity symbol (o). The construction costs (fixed cost) for each distribution center as well as the capacity of each are listed in Table 2. Distribution Center 3 4 6 Cost (1000$) 9000 10000 4000 3000 100 180 275 300 Capacity (tons) Table 2: Fixed costs and capacity limits of the distribution centers 1 3500 300 2 9000 260 There are estimations for demand of each retail location which are shown in the following table. Retail Location Demand (tons) 1 2 3 120 80 76 100 Table 3: Demand data 5 110 6 100 Considering that the demand of a retail location needs to be satisfied and a retail location may be delivered to from distribution centers, which distribution centers should be opened to minimize the total cost of construction and of delivery, while satisfying all demands? Formulate algebraically the corresponding model for this problem, but Do NOT solve the problem in Excel. A large furniture company has six retail locations spread out across Ontario and Quebec. To better serve these retail locations, the company has decided to open new distribution centers to supply inventory to the retail locations. There are two types of costs associated with the delivery: set-up costs (fixed costs) are capital costs which may usually be written off over several years, and transportation costs which depend on the distance covered. We assume that they have been put on some comparable basis, by taking the costs over a year. There are 6 sites available for the construction of new distribution centers to deliver inventory to the retail locations. Retail Locations 1 2 3 100 80 50 120 90 60 140 110 80 160 125 100 190 150 130 200 180 150 ∞ Table 1: Transportation costs for satisfying entire demand of each retail location Distribution Center 1 2 3 4 5 6 4 50 70 65 80 75 100 80 5 6 60 100 100 130 150 ∞ ∞ ∞ ∞ ∞ Table 1 gives the transportation costs (in thousand dollars) of delivering the entire demand of each retail location from a distribution center (not the unit costs). Certain deliveries that are impossible are marked with the infinity symbol (o). The construction costs (fixed cost) for each distribution center as well as the capacity of each are listed in Table 2. Distribution Center 3 4 6 Cost (1000$) 9000 10000 4000 3000 100 180 275 300 Capacity (tons) Table 2: Fixed costs and capacity limits of the distribution centers 1 3500 300 2 9000 260 There are estimations for demand of each retail location which are shown in the following table. Retail Location Demand (tons) 1 2 3 120 80 76 100 Table 3: Demand data 5 110 6 100 Considering that the demand of a retail location needs to be satisfied and a retail location may be delivered to from distribution centers, which distribution centers should be opened to minimize the total cost of construction and of delivery, while satisfying all demands? Formulate algebraically the corresponding model for this problem, but Do NOT solve the problem in Excel.

Answer rating: 100% (QA)

solution given data NOTE From the question we understand that entire demand of a retail location has ... View the full answer