Course11010715760 lectures
Decision Making with Spreadsheet
Prof. Ramesh Anbanandam · IIT Roorkee
About
This course aims to provide Undergraduate and Graduate students with a sound conceptual understanding of the role that management science plays in decision-making process. This course is applications oriented and continues to use the problem-scenario approach. A problem is described in conjunction with the management science model being introduced. The model is then solved to generate a solution and recommendation to management.
INTENDED AUDIENCE : Undergraduate and Post Graduate students interested in operations management.
INDUSTRY SUPPORT : All analytics companies
Lectures
Week 1
- Introduction
- Cost, Revenue, & Profit Models, Break Even Analysis
- Linear Programming Problem: Formulation & Assumptions
- Linear Programming Problem: Graphical Solution Method
- Graphical Calculator and Excel Solver for solving LPP
Week 2
- Sensitivity Analysis -1
- Sensitivity Analysis -2
- Sensitivity Analysis -3
- LPP Applications in Marketing
- LPP Applications in Finance
Week 3
- LPP Applications in Operations - 1
- LPP Applications in Operations - 2
- LPP Applications in Operations - 3
- Advanced LP Applications – Data Envelopment Analysis
- Game Theory - 1
Week 4
- Game Theory - 2
- Portfolio Management
- Revenue Management
- Distribution and Network Problems: Transportation Problem
- Assignment and Shortest Path Problem
Week 5
- Maximal Flow, Production & Inventory Application, Scheduling and Assignment Problems
- Integer Linear Programming
- Integer Programming Distribution Problem
- Nonlinear Optimization Models
- Nonlinear Optimization Models - II
Week 6
- Nonlinear Optimization Models - III
- Nonlinear Optimization Models - IV
- Nonlinear Optimization Models - V
- Project Scheduling: PERT/CPM - I
- Project Scheduling: PERT/CPM - II
Week 7
- Project Scheduling For Uncertain Activity Duration: PERT/CPM - III
- Project Scheduling: PERT/CPM - IV
- Inventory Models: Economic Order Quantity (EOQ) Model - I
- Inventory Models: Economic Order Quantity (EOQ) Model - II
- Economic Production Lot Size Model
Week 8
- Inventory Model with Planned Shortages
- Inventory Model - III
- Single-period Inventory model with Probabilistic demand
- Multi-period Order-Quantity, Reorder Point Model with Probabilistic Demand
- Periodic Review Model (P-type) with Probabilistic Demand
Week 9
- Financial risks associated with the development of a new product - I
- Financial risks associated with the development of a new product - II
- Inventory Simulation
- Simulation - III
- Simulation - 4
Week 10
- Decision Analysis - I
- Decision Analysis - II
- Decision Analysis - III
- Decision Analysis - IV
- Decision Analysis - V
Week 11
- Formulation Of Goal Programming - I
- Formulation Of Goal Programming - II
- Multicriteria Decisions- I
- Multicriteria Decisions- II
- Multicriteria Decisions- III
Week 12
Syllabus and materials
At NPTEL, as the course publishes them.
Credits and licence
- Institution
- IIT Roorkee
- Department
- Management
- Teacher
- Prof. Ramesh Anbanandam
- Level
- Undergraduate
- Language
- English
- Subjects
- Business and management
- Source
- NPTEL
- Licence
- CC BY-NC-SA, as NPTEL states it. Non-commercial use only. NPTEL's terms
- Attribution
- NPTEL states: "Distributed under Creative Commons Attribution-ShareAlike / CC BY - NC - SA", beside a BY-NC-SA badge.
- Who can watch
- NPTEL gives no rating. Invisible Network shows it to Tweens profiles and older, judged from what the source says about it. How courses are placed
More like this
NPTEL110107153
Course
Econometric Modelling
40 lectures · Video
NPTEL110107167
Course
Retail Marketing Strategy
41 lectures · Video
NPTEL110107080
Course
Marketing Research and Analysis
60 lectures · Source's player
NPTEL110107081
Course
Project Management for Managers
60 lectures · Source's player
NPTEL110107093
Course
Working Capital Management
60 lectures · Source's player
NPTEL110107094
Course
Innovation, Business Models and Entrepreneurship
40 lectures · Source's player
NPTEL110107116
Course
Manufacturing Strategy
40 lectures · Source's player
NPTEL110107126
Course
Training of Trainers
48 lectures · Source's player
NPTEL110107127
Course
Management Accounting
60 lectures · Source's player
NPTEL110107129
Course
Business Analytics & Text Mining Modeling Using Python
40 lectures · Source's player
NPTEL110107130
Course
Toyota Production System
40 lectures · Source's player
NPTEL110107143
Course
Managerial Skills for Interpersonal Dynamics
60 lectures · Source's player