ISMM C55 Module 2 (M2) - Operations and Supply Chain Management (OSCM) A note on additional materials Morning session on the 9th November 2020, 09:00 - 10:30 Ettore Settanni (es679@cam.ac.uk) The following materials will be distributed on Moodle for use during the session · Reference PowerPoint deck . A complementary reading, to cover point 4 of the agenda (if we run out of time) Settanni, E .; Srai, J. S., Kothapalli, V. M. (2018) Combining field data analysis and simulation to evaluate an alternative Just-In-Time clinical trial supply strategy. Proceedings of the 22nd Cambridge International Manufacturing Symposium University of Cambridge, 27-28 Sept 2019. Available online at https://www.repository.cam.ac.uk/handle/1810/286069 · An MS Excel spreadsheet to demonstrate 'hands on' key concepts on probabilistic demand (see "supporting data" sub section in Moodle), in particular: o safety stock and Type 1 service (orange worksheet): slide 16 o units out of stock estimates (green worksheet): slide 18 & 19 o combined EOQ & safety stock exercise (green worksheet): slide 19 o Multi-echelon strategic safety stock positioning (purple worksheet): slide 24 The following optional materials will also be made available on Moodle: · An R1 script demonstrating normality testing & probability mass functions fitting in slide 15 (input data provided as *. csv) · A Tableau2 workbook with the dashboard-like demand data visualisation in slide 15 You have the option (not an obligation) to bring your laptop/tablet device running MS Excel, and access the spreadsheet during the lecture if you so wish 1 R is an open source language for statistical computing ( ... and more): https://www.r-project.org/. Probability distributions fitting is carried out using the MASS library (Venables WN, Ripley Btti (2002). Modern Applied Statistics with S, Fourth edition. Springer, New York). 2 Tableau is a "user-centric" data visualisation tool, a trial version of which can be downloaded here (https://www.tableau.com/en-gb/products/desktop)