Course code InfT3030
Credit points 3
Total Hours in Course81
Number of hours for lectures8
Number of hours for seminars and practical classes24
Independent study hours49
Date of course confirmation10.03.2021
Responsible UnitInstitute of Computer Systems and Data Science
Mg. paed.
Students study the Operations Research methods for decision-making, acquire practical skills in Mathematical Programming (Linear Programming, Integer Programming and Integer Nonlinear Programming), modelling with MS Excel optimization tool Solver, Project Management software MS Office Project and a comparison of alternatives by The Analytic Hierarchy Process.
After completing the course student will have:
Knowledge about Operations Research methods for decision planning and making management with computer (tests, home works and practical works);
Skills - build the mathematical models with MS Excel and MS Project for operations research and decision making with AHP (tests, home works and practical works);
Competence – knowledge and ability for optimal and environmental safety decision planning and making process with Information Technologies (tests, home works and practical works).
1. Introduction. Mathematical Programming. Classification of methods. [L- 1 h]
2. Linear programming (LP) and MS Excel Solver. Use of limited resources for profit (income) maximization. [L- 1 h ; P – 4 h]
3. Linear programming (LP) and MS Excel Solver. Use of limited resources for cost (time) minimization. [L- 1 h; P – 4 h]
4. Integer linear programming and MS Excel Solver. Optimization of the use of production resources. [L- 1 h; P – 2 h]
5. Integer nonlinear programming (INLP) with MS Excel Solver. Optimization of the use of production resources. [L – 1 h; P – 2 h]
6. 1st test (LP, IP, INLP). [2 h]
7. Network models for managing processes or projects. Critical Path Method (CPM). Project execution time risk assessment with Program Evaluation and Review Techniques (PERT). [L- 1 h; P – 2 h]
8. Linear programming in project networks for cost optimization. [L- 1 h; P – 2 h]
9. Introduction to the MS Office Project app for project or process planning. [P – 1 h]
10. 2nd test (CPM, LP networks). [2 h]
11. The Analytical Hierarchy Process (AHP) for solving forest engineering problems. [L- 1 h; P – 1 h]
12. The defence of individual and independent work - the application of the AHP method. [2 h]
Successfully passed the formal test with a grade at least 40% of the course total score.
Tasks for the independent work are included in e-studies (http://estudijas.llu.lv).
There is one independent and individual work in the semester.
1. The formal test cumulative assessment depends on two tests (70 %) and independent individual work (30 %) ratings.
2. Students who are mostly studying independently, or wish to improve the cumulative assessment take the written formal test (70 %). Independent individual work assessment (30 %) will also be taken into account.
1. Hamdy A. Taha Operations research: an introduction. 10 edition. Harlow, England: Pearson Education 2017. 843 p.
2. Hamdy A. Taha Operations research: an introduction. 9 edition. Upper Saddle River, N.J. : Pearson Education/Prentice Hall, 2011. 824 p.
3. Frolova L. Matemātiskā modelēšana ekonomikā un menedžmentā. Rīga: Izglītības soļi, 2005. 438 lpp.
4. Koroļova J. Lekciju konspekti, laboratorijas darbu uzdevumi un papildmateriāli. http://estudijas.llu.lv
1. Peļņa M., Gulbe M. Optimizācijas uzdevumi ekonomikā. Rīga: Datorzinību centrs, 2003. 160 lpp.
2. Praude V., Beļcikovs J. Loģistika. Rīga: Vaidelote, 2003. 541 lpp.
3. Moore J.H., Weatherford L.R. Decision modelling with Microsoft Excel. Prentice Hall, 2001. 1020 p
E-žurnāls "Operation Research" [tiešsaiste]. eISSN: 1526-5463 (Online) [Skatīts 17.05.2022.] Pieejams: https://pubsonline.informs.org/journal/opre
General study course for Professional Bachelor’s study programme “Forest Engineering”