NPTEL - Decision making with spreadsheet
offered by IIT Roorkee

Public/Government Institute
Estd. 1847

Decision making with spreadsheet
at
IIT Roorkee
Overview

Boost your career by mastering concepts to LP Applications, Linear Programming, Minimisation Problem

Duration	12 weeks
Mode of learning	Online
Credential	Certificate

Decision making with spreadsheet
at
IIT Roorkee
Highlights

Earn a E- certificate of completion from IIT Roorkee

Decision making with spreadsheet
at
IIT Roorkee
Course details

Skills you will learn

Excel Operations Supply chain management Asset Allocation Marketing Simulation CPM Forecasting

Who should do this course?

For Undergraduate and Post Graduate students interested in operations management

More about this course

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
The model is then solved to generate a solution and recommendation to management
A problem is described in conjunction with the management science model being introduced

Decision making with spreadsheet
at
IIT Roorkee
Curriculum

Week 1

Introduction to Decision making in spreadsheet -1

Introduction to Decision making in spreadsheet -2

Linear Programming Problem -Graphical Solution Method and Computer solutions -1

Linear Programming Problem -Graphical Solution Method and Computer solutions -2

Minimisation Problem and special cases of LPP - 1

Week 2

Minimisation Problem and special cases of LPP - 2

Sensitivity Analysis - 1

Sensitivity Analysis - 2

LP Applications in Marketing - 1

LP Applications in Marketing -2

Week 3

LP Applications in Finance - 1

LP Applications in Finance - 2

LP Applications in Operations - 1

LP Applications in Operations -2

LP Applications in Operations -3

Week 4

LP Applications in Operations -Blending

LP Applications 'Supply Chain Management

LP Applications 'Revenue Management - 1

LP Applications 'Revenue Management - 2

Advanced Linear Programming Applications

Week 5

Portfolio models and Asset allocation Game theory - 1

Game theory - 2

Shortest-route problem Maximal flow problem

Week 6

A production and inventory application of LPP Integer linear programming

Applications involving 0 -1 variables

Modelling flexibility provided by 0-1 integer variables Nonlinear Optimization Models

Week 7

Constructing an index fund problem with LPP

Markowitz portfolio model Project scheduling: pert/cpm

Project scheduling considering expected activity times

Week 8

Project scheduling considering uncertain activity times

Considering time'cost trade-offs

Inventory models-Economic order quantity (eoq) model

Economic production lot size model

Week 9

Inventory model with planned shortages

Quantity discounts for the EOQ model

Single-period inventory model with probabilistic demand

Order-quantity, reorder point model with probabilistic demand

Periodic review model with probabilistic demand

Week 10

Waiting Line Models Structure of a waiting line system

Single-server waiting line model with poisson arrivals

Multiple-server waiting line model with poisson arrivals

Other waiting line models

Week 11

Simulation Risk analysis

Inventory simulation

Other simulation issues

Decision Analysis

Week 12

Multi criteria Decisions

Time Series Analysis and Forecasting Time Series Patterns Moving Averages and Exponential Smoothing

Seasonality Conclusion

Decision making with spreadsheet
at
IIT Roorkee
Faculty details

Prof. Ramesh Anbanandam

Professor Ramesh Anbanandam is working as an Associate Professor in the Department of Management Studies, IIT Roorkee, India. He is also Joint faculty of the Center of Transportation Systems, IIT Roorkee.