Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
A company is managing 4 warehouse and 6 retailers. The supply of these warehouses is 20000, 20000, and 10000, 5000.The demand of retailers is 4500,...
A company is managing 4 warehouse and 6 retailers. The supply of these warehouses is 20000, 20000, and 10000, 5000. The demand of retailers is 4500, 8000, 5500, 5000, 6000, and 8000. The cost of transportation between warehouses and retailers is shown in the following figure.
retailers
1
2
3
4
5
6
Warehouses
1
19
16
14
12
10
23
2
11
19
89
21
13
52
3
94
31
17
16
14
36
4
73
53
25
19
47
44
The company wants to decide how much to transport from warehouses to retailers.
a. Formulate the problem by identifying variables, constraints, and objective function. Write the formal formulation of the problem.
b. Solve the problem using Excel. Copy and paste screenshots of importing problem to Excel and solver feeding and final solution.
