COURSE UNIT TITLE

: MANAGERIAL DECISION MODELING WITH SPREADSHEETS

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
ENM 5028 MANAGERIAL DECISION MODELING WITH SPREADSHEETS ELECTIVE 3 0 0 8

Offered By

Graduate School of Natural and Applied Sciences

Level of Course Unit

Second Cycle Programmes (Master's Degree)

Course Coordinator

PROFESSOR ŞEYDA AYŞE YILDIZ

Offered to

ENGINEERING MANAGEMENT- NON THESIS (EVENING PROGRAM)

Course Objective

The objective of this course is to introduce students to the subject of Management Science, and a variety of management science models, methods and computational procedures that are helpful in solving management problems in Finance, production and operations management, Accounting, Marketing, Operational Research, etc.
Emphasis is placed on the use of spreadsheets (specifically Microsoft Excel) for the solution of managerial decision making problems faced in real life.

Learning Outcomes of the Course Unit

1   To be able to define different types of managerial decision problems
2   To be familiar with spreadsheet modeling
3   To be able to model different problems faced in both service and manufacturing systems using spreadsheets
4   To be able to solve business problems using spreadsheets
5   To be able to define and solve real life business problems using spreadsheets

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Introduction to Management Science Models
2 Linear Programming (LP) Cases: Formulation and Applications
3 The Art of Modeling with Spreadsheets
4 Modelling and Solving LP problems using Excel
5 Case Studie
6 Sensitivity Analysis and What-if Analysis for Linear Programming Using Spreadsheets, Classical sensitivity output in Excel
7 Midterm
8 Ad-hoc sensitivity using spreadsheets, Solver Table in Excel (add-in)
9 Networks: Minimum cost, maximum flow, shortest route
10 Integer Linear Programming (ILP): Formulations and Solution Techniques
11 Macros, VBA, Premium Solver Platform
12 Non Linear Programming, Goal Programming using Solver
13 Presentations
14 Presentations

Recomended or Required Reading

N. Balakrishan, B. Render, R.M.Stair., Managerial Decision Modeling with Spreadsheets, Prentice Hall, 2007, ISBN 0-13-195114-9

Frederick S. Hillier, Mark S. Hillier., Introduction to Management Science: A Modeling and Case Studies Approach with Spreadsheets, 3/e, McGraw Hill publishers, ISBN 978-0-07-312903-7

S.C.Albright, W.L. Winston., Spreadsheet Modeling and Applications Essentials of Practical Management Science, Thomson Higher Education, ISBN 978-0-534-38032-8

Planned Learning Activities and Teaching Methods

Course notes that are prepared using different sources (Books, journal papers, conference proceedings) will be given using class board and visual presentations

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 MTE MIDTERM EXAM
2 ASG ASSIGNMENT
3 FIN FINAL EXAM
4 FCG FINAL COURSE GRADE MTE * 0.25 + ASG *0.25 +FIN *0.50
5 RST RESIT
6 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.25 + ASG *0.25 +RST *0.50


Further Notes About Assessment Methods

None

Assessment Criteria

To be announced.

Language of Instruction

English

Course Policies and Rules

To be announced.

Contact Details for the Lecturer(s)

derya.eren@deu.edu.tr

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 25 25
Preparation for final exam 1 25 25
Preparing assignments 4 13 52
Final 1 2 2
Midterm 1 2 2
Presentations 2 4 8
TOTAL WORKLOAD (hours) 192

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10
LO.134433422
LO.245545
LO.343445533
LO.4454443
LO.545534454