Course: Management Science Modeling

» List of faculties » FCH » KEMCH
Course title Management Science Modeling
Course code KEMCH/C774
Organizational form of instruction Lecture + Seminary
Level of course Master
Year of study not specified
Semester Summer
Number of ECTS credits 6
Language of instruction Czech
Status of course Compulsory
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Munzarová Simona, Ing. Ph.D.
Course content
Week 1: Mathematical modeling of managerial decision-making problems. Formulation, solution and implementation of the models. Modeling in MS Excel. Week 2: Input - Output Models on a business level. Week 3: Linear programming, basic model of linear programming, graphical solution, solution using Solver tool in MS Excel. Duality in Linear Programming Models, Solution Sensitivity Analysis. Week 4: Special problems of linear programming, integer programming and 0-1 models, Capital Budgeting Problem, assigning problems. Week 5: Transportation problem. Week 6: Queue models, single and multi-channel systems, economic optimization. Week 7: Inventory optimization. Deterministic inventory models, optimal order size, optimal production batch size. Week 8: Stochastic inventory models, insurance stock, optimal size of a single order. Week 9: Replacement models. Optimal cycle of device replacement, models of failing units. Week 10: Multicriteria decision making problems, decision making under uncertainty and risk, decision trees, basic principles of game theory. Case study - use of multicriteria decision making methods. Week 11: Models for project management. Project planning using CPM and PERT methods. Week 12: Gant chart, resource and cost analysis in the project network graphs. Week 13: Simulation in models of managerial decision problems. Presentation of students' seminar papers.

Learning activities and teaching methods
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Work with text (with textbook, with book), Methods of individual activities, Stimulating activities (simulation, games, drama)
  • Contact teaching - 78 hours per semester
  • Preparation for a partial test - 32 hours per semester
  • Preparation for an exam - 32 hours per semester
  • Term paper - 16 hours per semester
  • Preparation of a presentation (report) - 4 hours per semester
  • Home preparation for classes - 18 hours per semester
Learning outcomes
The aim of the course is to prepare students for solving more complex managerial decision-making problems using basic and advanced quantitative methods and mathematical models.
Students will acquire the ability to formulate managerial decision-making problems as mathematical models, to choose appropriate methods of their solution, to look for optimal resp. effective solution using MS Excel and interpret the obtained solution including sensitivity analysis.
Prerequisites
The prerequisite for the study of the subject is knowledge of mathematics, business economics and business management at bachelor level and the ability to work in MS Excel.

Assessment methods and criteria
Oral examination, Written examination, Home assignment evaluation, Self project defence

The level of acquired knowledge and application skills is examined. Knowledge and skills are verified by: oral examination, 2 written tests, solving given assessments at seminars, processing of 2 seminar papers, presentation of the second seminar paper.
Recommended literature
  • Anderson, D. R. Quantitative Methods for Business. 12. vyd.. S.l.: South-Western/Cengage Learning, 2013. ISBN 978-1-133-58446-9.
  • Gros, I. Matematické modely pro manažerské rozhodování. Praha: Vydavatelství VŠCHT, 2009. ISBN 978-80-7080-709-5.
  • Jablonský, J. Operační výzkum: kvantitativní modely pro ekonomické rozhodování. 3. vyd.. Praha: Professional Publishing, 2007. ISBN 978-80-86946-44-3.
  • Munzarová, S. , Machač O. Manažerské kvantitativní metody. Učební text dostupný v systému STAG. Univerzita Pardubice. 2017.
  • Munzarová, S., Machač, O., Paták, M. Sbírka příkladů k předmětu Manažerské kvantitativní metody. Materiál dostupný v systému STAG.. 2017.
  • Munzarová, S. Manažerské kvantitativní metody. PPT prezentace dostupné v systému STAG. Univerzita Pardubice. 2017.
  • Powell, S. G., Baker, K. R. Management Science: The Art of Modeling with Spreadsheets. 4. vyd.. Hoboken: John Wiley, 2014. ISBN 978-1-118-58269-5.
  • Ravindran, A. R. Operation research and management science handbook. Boca Raton: CRC Press/Taylor& Francis, 2008. ISBN 978-0-8493-9721-9.


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