COURSE UNIT TITLE

: MANAGEMENT SCIENCE MODELING WITH SPREADSHEETS

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
IND 4918 MANAGEMENT SCIENCE MODELING WITH SPREADSHEETS ELECTIVE 3 0 0 4

Offered By

Industrial Engineering

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

ASSOCIATE PROFESSOR FEHMI BURÇIN ÖZSOYDAN

Offered to

Industrial Engineering

Course Objective

The objective of this course is to introduce students to the Spreadsheet Modeling approach and to develop skills in order to solve problems in production and operations management. The spreadsheet software Microsoft Excel will be taught, various decision models will be developed by using Excel s built-in functions and several add-ins for Excel.

Learning Outcomes of the Course Unit

1   To be able to describe spreadsheet modeling concepts
2   To be able to model problems that arise in manufacturing and service systems, using spreadsheets
3   To be able to distinguish between different real life decision problems
4   To be able to solve problems in production and operations management using spreadsheets
5   To be able to analyze the solution decision

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 Basic Spreadsheet Modeling Concepts
3 Using Spreadsheets in Decision Modeling
4 Modeling, Solving Linear Programming Problems using Excel s Solver
5 Sensitivity Analysis using Solver
6 Solving Network Optimization Problems using spreadsheets
7 Data Envelopment Analysis
8 Midterm
9 Macros, VBA, Premium Solver Platform
10 Solving Integer Programming Problems using Solver
11 Case studies on various real world Production and Operations Management Problems
12 Case studies
13 Student presentations
14 Student presentations

Recomended or Required Reading

1) Introduction to Management Science: A Modeling and Case Studies Approach with Spreadsheets, Frederick S. Hillier, Mark S. Hillier, 3/e, McGraw Hill publishers. ISBN 978-0-07-312903-7
2) Managerial Decision Modeling with Spreadsheets, N. Balakrishan, B. Render, R.M.Stair, Prentice Hall, 2007, ISBN 0-13-195114

Planned Learning Activities and Teaching Methods

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.20 + ASG * 0.30 + FIN * 0.50
5 RST RESIT
6 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.20 + ASG * 0.30 + RST * 0.50


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

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, Tel. +90-232-3017604

Office Hours

To be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 12 3 36
Preparations before/after weekly lectures 13 2 26
Preparation for midterm exam 1 7 7
Preparation for final exam 1 7 7
Preparing group assignments 5 3 15
Final 1 2 2
Midterm 1 2 2
Presentations 2 4 8
TOTAL WORKLOAD (hours) 103

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11PO.12
LO.15
LO.25454
LO.353
LO.4545
LO.545555