'Bis Corporation Essay\r'

'Prep ar a indite report with the results organized in tables. Submit your witness to me via email by the deadline. In your email should involve your written report in pdf format and your jump out implementation. Attach the 2 documents to your email separately, do non compress the two into an archive file, e.g. zip, rar, 7z. This can be undertaken as a host project or you may choose to cast individually. You may work as a team of maximum of 4 students.\r\nSignificant points will be deducted if you fail to fit the above instructions, submit only an Excel document, or submit the work of some matchless else.\r\nBis Corporation\r\n forswear the Bis Corporation example covered in class. SKUs are aggregated into 3 groups. Customers are aggregated into 25 groups. Project data is up slicked as an Excel workbook. In this workbook SKU groups value, slew and weight data are given. monthly demand AVG and STD values for each customer group are given in SKUs. Highway distances amongst a ll Turkish cities are given. The distances in the throw of the matrix corresponds to the average distance of two points (e.g. figurey- store 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 represents are given. Inbound exile is carried out on semi-trailer hand trucks, outbound transportation on regular trucks. There two utility(a)s to be compared: A1 with 2 warehouses and A2 with 5 warehouses.\r\na) 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 descry whether the truck might (number of SKUs that can be loaded) is limited by good deal or weight. Then use the load factor to calculate how many SKUs can be loaded on average. Then calculate the cost of transporting one SKU to a distance of 100km. b) For alternative A1 calculate monthly cost. C alculate the monthly outbound transportation be for each customer group and SKU group.\r\nCalculate the monthly inbound cost of transporting SKUs from factories warehouses. Calculate the average pedigree levels at each warehouse by volume and value. Calculate the required warehouse capacities and then which warehouse choice will be made. Then find the corresponding warehouse fixed cost (convert it into a monthly cost). Calculate the monthly holding costs and handling costs at each warehouse. at long last calculate the monthly total cost as the sum of all costs. c) Repeat part (b) for alternative A2.\r\n'