Learning objectives
The course starts from the themes covered in the courses of "Industrial Logistics" and "Supply chain management" and proposes the discussion of complementary topics in these courses, mainly based on a rigorous scientific approach and relating to real-world data and practical exercises carried out through MS Excel® tool. The learners are also asked to analyze some case studies related to the topics discussed. It is therefore expected that the student will acquire specialized expertise in logistics and supply chain management, based on a rigorous scientific approach and on the ability to deal with and solve real problems through the use of computers and MS Excel®.
Knowledge and understanding: At the end of the course, the student will acquire a comprehensive overview of logistic and supply chain processes and will be able to outline their design.
Applied knowledge and understanding: At the end of the course, the student will acquire the skills required to understand, control and plan all logistic and supply chain activities, with particular attention to warehouse processes and inventory management.
Making judgements: The student is expected to acquire adequate knowledge for a critical analysis of logistics and supply chain activities.
Communication skills: The student is expected to acquire a specific vocabulary on logistics and supply chain management and to be able to expose the main concepts and issues related to those areas
Learning ability: The student should be able to set up the project of logistic picking and inventory management processes, using the MS Excel tool, as well as outlining the results.
Prerequisites
The course can be attended with profit and understood having passed the exam of Industrial Logistics
Course unit content
- Introduction to the course;
- Picking
- Warehouse management systems- Inventory management
- Reverse logistics and sustainability of the supply chain;
- laboratory exercises
- external interventions
Full programme
- Introduction to the course;
- Picking
- Warehouse management systems- Inventory management
- Reverse logistics and sustainability of the supply chain;
- laboratory exercises
- external interventions
Bibliography
Ferrozzi, Shapiro. Logistica e Strategia Vol I e II. McGraw-Hill
Caron, Marchet, Wegner. Impianti di movimentazione e stoccaggio dei materiali. Hoepli, Milano
W. J. Hopp, M.L. Spearman, 2008. "Factory physics", 2nd edition, McGraw-Hill. Cap.2: Inventory control
Slides of lessons. The teacher shares this material using the Elly portal
Slides of external interventions (if available).
Any other material (eg scientific articles) made available by the teacher through the Elly portal
Teaching methods
The course consists of 6 CFUs, which are addressed mainly through face-to-face lessons and exercises. To be consistent with the test, the exercises are carried out in Microsoft Excel and may be carried out in the laboratory. The frontal lessons are held in the classroom. During the course students are offered the opportunity to deal with some company case studies on specific subjects to be taught, through the intervention of external experts (seminars).
The teacher provides students with the teaching material using the Elly platform, to which the students are invited to subscribe before the beginning of the lessons. The teaching material made available consists of pdf slides divided into the different chapters dealt with during the course. The teacher updates the material yearly, therefore that material may not be available in its entirety at the beginning of the course. However, the teacher will try to make available the material relating to a chapter of the course before the beginning of the chapter itself. The teacher also provides as teaching material the resolution of the exercises carried out in class, on Microsoft Excel files.
Additional teaching material, such as slides used by outsiders during seminars, will be provided to students if made available by the company involved.
Assessment methods and criteria
The acquired knowledge will be checked by means of an exam consisting in an exercise with Microsoft Excel (mandatory) plus the possibility of an oral exam (optional at the student's discretion). The test in Microsoft Excel is carried out in laboratory and consists of the resolution of 3 exercises on the topics covered during the course. Students will be allowed two hours to complete the test in Excel.
Each of the proposed exercises is assigned a score between a minimum of 0/30 (in case of question lest blank) and a maximum of 10/30 (in case of perfectly answered question); therefore, in case of correct resolution of all three exercises, the final mark that the student can achieve in Excel is 30/30. The teacher can of course assign an intermediate score depending on how the student has solved each exercise (e.g. partial resolution, resolution with some errors, etc.). The result of the test performed in Microsoft Excel is published by the teacher through the ESSE3 platform and has a validity of 7 days. When publishing the results, the teacher also indicates a useful moment for the students to view the tests and to carry out the oral tests (for interested students), within the term of the 7-day validity of the result of the exam. Students who wish to take part in the oral exam are invited to inform the teacher about it in order to improve the organization of the activities and to present themselves at the time indicated by the teacher.
Passing the test performed with Microsoft Excel with a minimum score of 18/30 is to be considered as a prerequisite for passing the exam and access to the oral test. Conversely, a student whose Microsoft Excel test was not sufficient will not be admitted to the oral test.
The oral test consists of a single question, in which the student should demonstrate perfect knowledge of the topic, ability to connect it with the case studies proposed and language properties in the disciplines of the course, besides the capability to write or express in correct Italian. The oral exam may change the student's marks both positively and negatively by up to 2 points, depending on how the student demonstrates that he/she has acquired the knowledge described above. If the student rejects the mark given following the oral exam, the mark in the exercise with Microsoft Excel will be considered as rejected too and the student will therefore have to repeat the entire exam.
Other information
- - -
