MU11176 Software Support for Mathematical Method in Economics and Management

Mathematical Institute in Opava
Winter 2014
Extent and Intensity
0/2/0. 2 credit(s). Type of Completion: z (credit).
Teacher(s)
doc. Ing. Petr Seďa, Ph.D. (seminar tutor)
Guaranteed by
doc. Ing. Petr Seďa, Ph.D.
Mathematical Institute in Opava
Prerequisites (in Czech)
MU11150 Math. Meth. in Econ. Manag. II
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives
The aim of the course is to show a way how to solve selected problems of operations research practice with a help of selected software products. For teaching MS Excel, MS Project and WIN-QSB software products will be used. Students become familiar with the possibilities of using the programs and get the practical skills how to use it for specific types of tasks. The acquired skills will increase the employability of graduates. The course itself is built on knowledge the courses of Mathematical Methods in Economics and Management I, II and III.
Syllabus
  • 1. Basic information about software - MS Excel, MS Project, WIN-QSB.
    2. Tasks and problems of linear programming (mathematical models, soluting by MS Excel and WIN-QSB).
    3. Integer and binary programing (MS Excel, WIN-QSB).
    4. Assignment and transportation problem (MS Excel, WIN-QSB).
    5. Input-output models and corporate balance models (MS Excel).
    6. Queuing systems (MS Excel, WIN-QSB).
    7. Inventory models (MS Excel, WIN-QSB).
    8. Game theory problems (MS Excel).
    9. Project management - CPM method (MS Project, WIN-QSB).
    10. Project management - PERT method (MS Project, WIN-QSB).
    11. Optimalization of portfolio of financial assets (MS Excel).
Literature
    recommended literature
  • B. Render, R. M. Stair, N. Balakrishnan. Managerial Decision Modeling with Spreadsheets and Student CD Package (2nd Edition). info
  • HYNDRÁK, K. Microsoft Office Project - Hotová řešení 1. vyd. Brno: Computer Press, 2007. ISBN 978-80-251-1681-4. info
  • J. Jablonský. Programy pro matematické modelování. Management Press, Praha, 2007. info
  • M. D. Rosenau. Řízení projektů. Praha: Computer Press, 2007. ISBN 978-80-251-1506-0. info
  • I. Gros. Kvantitativní metody v manažerském rozhodování. Grada, Praha, 2003. ISBN 80-247-0421-8. info
  • K. Desai, Y. Chang. WinQSB Version 2.0. John Wiley & Sons, New Jersey, 2003. info
  • J. Jablonský. Operační výzkum - kvantitativní modely pro ekonomické rozhodování. Profesional Publishing, Praha, 2002. info
Teaching methods
Seminar classes
Assessment methods
Credit
Language of instruction
Czech
Further comments (probably available only in Czech)
The course can also be completed outside the examination period.
Teacher's information
Solving and presentation of a case study.
The course is also listed under the following terms Winter 2008, Winter 2009, Winter 2010, Winter 2011, Winter 2012, Winter 2013, Winter 2015, Winter 2016, Winter 2017, Winter 2018, Winter 2019, Winter 2020, Winter 2021, Winter 2022, Winter 2024.
  • Enrolment Statistics (Winter 2014, recent)
  • Permalink: https://is.slu.cz/course/sumu/winter2014/MU11176