IE413 Supply Chain Management – Fall 2012
Course Project: Logistic Network Design
Due on Monday January 21 by 5pm
Prepare a written report with the results organized in tables. Submit your project to me via email by the deadline. In your email should include your written report in pdf format and your Excel implementation. Attach the two documents to your email separately, do not compress the two into an archive file, e.g. zip, rar, 7z. This can be undertaken as a group project or you may choose to work individually. You may work as a team of maximum of 4 students.
Significant points will be deducted if you fail to follow the above instructions, submit only an Excel document, or submit the work of someone else.
Recall the Bis Corporation example covered in class. SKUs are aggregated into 3 groups. Customers are aggregated into 25 groups. Project data is uploaded as an Excel workbook. In this workbook SKU groups value, volume and weight data are given. Monthly demand AVG and STD values for each customer group are given in SKUs. Highway distances between all Turkish cities are given. The distances in the diagonal of the matrix corresponds to the average distance of two points (e.g. factory-warehouse or warehouse-customer) within the same city. There are two factories: Kocaeli plant produces S01 and S02 groups only, Adana plant produces S03 group only. Warehouse parameters and annual fixed costs are given. Inbound transportation is carried out on semi-trailer trucks, outbound transportation on regular trucks. There two alternatives to be compared: A1 with 2 warehouses and A2 with 5 warehouses.
a) Calculate and present in a table inbound and outbound unit cost of transportation of each SKU group. For each SKU group and truck type first find whether the truck capacity (number of SKUs that can be loaded) is limited by volume or weight. Then use the load factor to calculate how...