COURSE UNIT TITLE

: OPTIMIZATION AND SCENARIO ANALYSIS

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
VYA 5007 OPTIMIZATION AND SCENARIO ANALYSIS ELECTIVE 5 0 0 5

Offered By

DATA MANAGEMENT AND ANALYSIS

Level of Course Unit

Second Cycle Programmes (Master's Degree)

Course Coordinator

PROFESSOR DOCTOR ALI KEMAL ŞEHIRLIOĞLU

Offered to

DATA MANAGEMENT AND ANALYSIS

Course Objective

Using electronical table is taught for analyzing business problem with quantitative point of view in this course. Applications in finance, marketing and process management are discussed. Case studies about planning, cash flow management, portfolio optimization, supply chain management and other subjects are applied.

Learning Outcomes of the Course Unit

1   1- To be able to realize complicated quantitative analysis.
2   2- To be able to solve complicated problems without hard and unknown mathematical notations
3   3- To be able to use Microsoft Excel Solver, Matlab, Ds for Windows,Pro-model
4   4- To be able to model real world problems.
5   5- To be able to make decision with the help of comparing different scenarios.
6   6- To be able to implement real life applications about finance, marketing , management and other related field.

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 1. Introduction to optimization
2 2. Linear Programming (by using Ds For Windows ,Excel Solver)
3 3. Sensitivity Analysis (by using Ds For Windows ,Excel Solver)
4 4. Integer and Non-Linear Programming (by using Ds For Windows ,Excel Solver)
5 5. Transportation and assignment problems (by using Ds For Windows and Excel Solver)
6 6. Multiobjective Optimization. (Excel Solver)
7 7. Decision Making Under Uncertainty(by using Tree Plan)
8 8. Practice
9 9. Midterm
10 10. Decision Support Systems and Risk Management (by usingTree Plan)
11 11. Monte carlo simulation (by using Pro- model)
12 12. Optimization by simulation
13 13. Waiting LIne Models(by using Ds for Windows)
14 14. Applications about finance, marketing and planning.
15 15. Final Exam
16 16. Final Exam

Recomended or Required Reading

1-Hillier, Introduction to Management Science:A modelling and Case Studies Approach with Spreadsheets,Second Edition,2003.

Planned Learning Activities and Teaching Methods

1- Lecture Method,
2- Demonstration Method with Applications,
3-Determined Cases Discussed Analysis Method

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 MTE MIDTERM EXAM
2 STT TERM WORK (SEMESTER)
3 FIN FINAL EXAM
4 FCG FINAL COURSE GRADE MTE * 0.30 + STT * 0.30 + FIN* 0.40
5 RST RESIT
6 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.30 + STT * 0.30 + RST* 0.40


*** Resit Exam is Not Administered in Institutions Where Resit is not Applicable.

Further Notes About Assessment Methods

None

Assessment Criteria

Ara sınav notu, dönem içi çalışmalar ve Final notunun ağırlıklı ortalaması 75 ve üzeri olmalıdır.

Language of Instruction

Turkish

Course Policies and Rules

To be announced.

Contact Details for the Lecturer(s)

To be announced.

Office Hours

To be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 13 3 39
Preparations before/after weekly lectures 13 3 39
Preparation for midterm exam 1 20 20
Preparation for final exam 1 30 30
Final 1 3 3
Midterm 1 3 3
TOTAL WORKLOAD (hours) 134

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10
LO.11111111
LO.2111
LO.3111
LO.4111
LO.5111
LO.61111