NOTE ! ! ! submit a zip-file through itslearning with named “familyname1”_”familyname2”_HA2.zip
1.(5p) SOLVETHEPROBLEMBELOWwithbothExcelandLp-solve.Doyou get the same answer? Why is it possible to get different answers? Is the evolutionary solver in Excel giving the right answer?
MINI CASE - Distribution plan for a mobile phone manufacturer
A cell phone manufacturers make a particular phone at 6 different factories. Its production quantity for a certain period is as follows:
Finland 6000 USA 8000 China 13000 Czech 8000 Brazil 14000 Turkey 7000 India 8000
The manufacturer has 10 distribution centers (markets) for this phone type and the demand for the time period is estimated to be:
New Stockholm Helsinki Beijing London Delhi
5000 8000 8000 7000 3000
New Rome York
5000 3000
Montevideo 9000
Cape
Town Moskov
5000 8000
Transport costs between production centers and distribution centers are (€ / pc)
New New Cape Stockholm Helsinki Beijing London Delhi Rome York Montevideo Town Moskov Finland 7245666 362 USA 2847445 573 China 8452235 646 Czech 4823628 243 Brazil 5452794 642 Turkey 6543349 597 India 6825842 272
Your task is to find the optimal transportation plan from the manufacturing plants into distribution centers (the markets) so that each distribution centers get what they need and so that total transport costs are as small as possible.