Homework Strategic Logistics Planning Topic: $$Distribution locations$$

The company Snack Deliveries wants to review its distribution concept and wants to optimize the distribution costs respectively the costs of transportation. The company delivers chocolates and pastries to its retail customers.

An assortment is produced in four plants, in that each plant is responsible for a specific sub$-$assortment.

In the order file $($Excel$)$ orders for $1$ complete month are listed.

$\frac{1}{3}$

The file is structured as follows:

Column $1$: Sequence number

Column $2$: Order number of each customer order

Column $3$: Postal code of the production plant of the ordered article

Column $4$: City name of the postal code of the manufacturing plant

Columns $5$ and $6$: Geo$-$coordinates of the factories

Column $7$: Customer number

Column $8$: Postal code of the customer

Column $9$: Location designation of the customer's postal code

Columns $10$ and $11$: Geo$-$coordinates of the customers

Column $12$: Desired date of the customer

Column $13$: Order position of an order $($in decadic steps$)$

Column $14$: Artiicle number

Column $15$: Order quantity in cartons

Task: Several distribution variants are to be checked. The following configurations and combinations are possible:

a$.$ Supplying customers from four warehouses directly assigned to the respective plant,

b$.$ Setting up a central warehouse to supply the complete country

c$.$ Establishment of $20$ regional warehouses.

Carry out estimates for the respective routes or tour lengths! Please observe the driving time regulations of the drivers.

The total personnel costs in the warehouses are the same in all configurations.

$1$