In: Statistics and Probability
PureCoffee
PureCoffee imports high quality coffee beans from Africa and South America. They roast the beans in a innovative process slowly and gently to create a unique taste of coffee. Pure Coffee serves three markets (M1, M2, and M3) in Europe. Market demand for the next week is given in the following table.
Market |
Demand (tons per week) |
Market 1 (M1) |
500 |
Market 2 (M2) |
500 |
Market 3 (M3) |
1000 |
To serve Europe they have two roasting plants available - one in the North of Europe (N) and one in the South of Europe (S).
Roasting Plant |
Capacity (tons per week) |
North (N) |
1000 |
South (S) |
1000 |
Currently they are using two distribution centers in Europe to
connect the roasting plants with markets. They ship the roasted
beans from the production sites to the distribution centers and
distribute from there to three different markets.
The cost to transport a ton of roasted beans from a roasting plant
to a dibstrution center and from the distribution center to the
customers depends on the distances between the different locations.
These costs are given in the two tables below:
Origin: Roasting Plant |
Destination: Distribution Center |
Transportation Cost (Euros/ton) |
North (N) |
Distribution Center A |
50 |
Distribution Center B |
47 |
|
South (S) |
Distribution Center A |
51 |
Distribution Center B |
49 |
Origin: Distribution Center |
Destination: Market |
Transportation Cost (Euros/ton) |
Market 1 |
79 |
|
Distribution Center A |
Market 2 |
54 |
Market 3 |
40 |
|
Market 1 |
70 |
|
Distribution Center B |
Market 2 |
62 |
Market 3 |
48 |
In the optimal solution, what is the minimum total weekly cost of moving roasted beans from roasting plants to customers? Enter your answer in Euros without a currency symbol.
Solution:
FORMULA:
Enter Solver Parameters as follows:
Click Solve to generate the solution. After that, values appear automatically in Quantity column (D2:D11):