Course: Design of Logistics Systems in MS Excel

» List of faculties » EF » KPE
Course title Design of Logistics Systems in MS Excel
Course code KPE/NLS1
Organizational form of instruction Lesson
Level of course Bachelor
Year of study not specified
Semester Summer
Number of ECTS credits 2
Language of instruction Czech
Status of course Optional
Form of instruction Face-to-face
Work placements Course does not contain work placement
Recommended optional programme components None
Lecturer(s)
  • Dyntar Jakub, doc. Ing. Ph.D.
Course content
Seminar topics 1. Balancing in logistics systems. 2. Distribution warehouse balance. 3. Analysis of orders in distribution warehouse, typical order. 4. Analysis of distribution channel behavior. 5. XYZ analysis, turnover of inventory, determination of purchasing efficiency. 6. ABC analysis - turnover and frequency of the occurrence of items in orders. 7. Warehouse layout design. 8. Spreadsheet simulation of a storage system - resources requirements, sensitivity analysis.

Learning activities and teaching methods
unspecified
Learning outcomes

Students obtain knowledge in given course in accordance with requirements and course programme.
Prerequisites
No specification.

Assessment methods and criteria
unspecified
Active participation in seminars.
Recommended literature
  • DYNTAR, J. Návrh a optimalizace dodavatelských systémů s využitím dynamické simulace.. Praha: FinEco, 2018. ISBN 978-80-86590-15-8.
  • GROS, I. a DYNTAR, J. Matematické modely pro manažerské rozhodování.. Praha: Vysoká škola chemicko-technologická v Praze, 2015. ISBN 978-8070809105.
  • GROS I., et al. Velká kniha logistiky.. Praha: VŠCHT, 2016. ISBN 978-80-7080-952-5.
  • PECINOVSKÝ, J., PECINOVSKÝ, R. Office 2016: průvodce uživatele.. Praha: Grada, 2016. ISBN 978-80-247-5691-2.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester