Your firm is distributing a single type of product from warehouses in Berlin, Barcelona, Calais. Based...

Transcribed Image Text:

Your firm is distributing a single type of product from warehouses in Berlin, Barcelona, Calais. Based on the previous observations, gasoline and maintenance costs of transporting a good from one city to another is observed as 5.6 Euro for each kilometre that the distributing truck makes. Even though the product you were selling is heavy machinery for construction sites you were managing a high volume of sales. Hovewer, your business is seriously affected due to the COVID-19 outbreak. The pandemic resulted in a reduction in sales, and your company can distribute a single machine to each of the construction companies in Brussels, Athens, Cologne next month. At the beginning of the next month, a single machine will be available as inventory for each of your warehouses except for Calais. The Calais warehouse will have two machines available. a) Find the optimum warehouse/construction site assignment for next month to minimize the total gasoline and maintenance cost for your company. Explain with reasoning if you can't find a solution. b) Your new accountant introduced a holding cost to your books. Suppose that at the end of the month, $1832 of holding cost will incur for excessive inventory, if there is any. Update your model, don't solve. Driving distances (in km) between cities are given in the table below. Barcelona 1639 Antwerp Athens 160 3082 0 2766 0 3312 1465 2766 3312 1465 0 1899 723 704 913 46 1419 211 1399 237 1539 Amsterdam Antwerp Athens Barcelona Berlin Bem Brussels Calais Cologne Amsterdam 0 160 3082 1639 649 875 209 385 280 2552 2627 3021 2976 2562 Berlin 649 723 2552 1899 0 986 782 936 575 Bern Brussels 875 209 46 704 2627 3021 1419 782 655 0 212 219 913. 986 0 655 854 583 Calais 385 211 2976 1399 936 854 212 0 431 Cologne 280 237 2562 1539 575 583 219 431 0 Your firm is distributing a single type of product from warehouses in Berlin, Barcelona, Calais. Based on the previous observations, gasoline and maintenance costs of transporting a good from one city to another is observed as 5.6 Euro for each kilometre that the distributing truck makes. Even though the product you were selling is heavy machinery for construction sites you were managing a high volume of sales. Hovewer, your business is seriously affected due to the COVID-19 outbreak. The pandemic resulted in a reduction in sales, and your company can distribute a single machine to each of the construction companies in Brussels, Athens, Cologne next month. At the beginning of the next month, a single machine will be available as inventory for each of your warehouses except for Calais. The Calais warehouse will have two machines available. a) Find the optimum warehouse/construction site assignment for next month to minimize the total gasoline and maintenance cost for your company. Explain with reasoning if you can't find a solution. b) Your new accountant introduced a holding cost to your books. Suppose that at the end of the month, $1832 of holding cost will incur for excessive inventory, if there is any. Update your model, don't solve. Driving distances (in km) between cities are given in the table below. Barcelona 1639 Antwerp Athens 160 3082 0 2766 0 3312 1465 2766 3312 1465 0 1899 723 704 913 46 1419 211 1399 237 1539 Amsterdam Antwerp Athens Barcelona Berlin Bem Brussels Calais Cologne Amsterdam 0 160 3082 1639 649 875 209 385 280 2552 2627 3021 2976 2562 Berlin 649 723 2552 1899 0 986 782 936 575 Bern Brussels 875 209 46 704 2627 3021 1419 782 655 0 212 219 913. 986 0 655 854 583 Calais 385 211 2976 1399 936 854 212 0 431 Cologne 280 237 2562 1539 575 583 219 431 0