Question

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

1. PureCoffee wants to minimize the total weekly cost. They ask you to optimize the roasted beans flow from the processing facilities to their customers.

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.

2. How many tons of roasted beans should PureCoffee ship through Distribution Center B per week?

Answer 1

Solution:

FORMULA:

Enter Solver Parameters as follows:

Click Solve to generate the solution. After that, values appear automatically in Quantity column (D2:D11):