NPTEL : NOC:Decision Making with Spreadsheet (Management)

Co-ordinators : Prof. Ramesh Anbanandam


Lecture 1 - Introduction

Lecture 2 - Cost, Revenue, and Profit Models, Break Even Analysis

Lecture 3 - Linear Programming Problem: Formulation and Assumptions

Lecture 4 - Linear Programming Problem: Graphical Solution Method

Lecture 5 - Graphical Calculator and Excel Solver for solving LPP

Lecture 6 - Sensitivity Analysis - 1

Lecture 7 - Sensitivity Analysis - 2

Lecture 8 - Sensitivity Analysis - 3

Lecture 9 - LPP Applications in Marketing

Lecture 10 - LPP Applications in Finance

Lecture 11 - LPP Applications in Operations - 1

Lecture 12 - LPP Applications in Operations - 2

Lecture 13 - LPP Applications in Operations - 3

Lecture 14 - Advanced LP Applications - Data Envelopment Analysis

Lecture 15 - Game Theory - 1

Lecture 16 - Game Theory - 2

Lecture 17 - Portfolio Management

Lecture 18 - Revenue Management

Lecture 19 - Distribution and Network Problems: Transportation Problem

Lecture 20 - Assignment and Shortest Path Problem

Lecture 21 - Maximal Flow, Production and Inventory Application, Scheduling and Assignment Problems

Lecture 22 - Integer Linear Programming

Lecture 23 - Integer Programming Distribution Problem

Lecture 24 - Nonlinear Optimization Models - I

Lecture 25 - Nonlinear Optimization Models - II

Lecture 26 - Nonlinear Optimization Models - III

Lecture 27 - Nonlinear Optimization Models - IV

Lecture 28 - Nonlinear Optimization Models - V

Lecture 29 - Project Scheduling: PERT/CPM - I

Lecture 30 - Project Scheduling: PERT/CPM - II

Lecture 31 - Project Scheduling For Uncertain Activity Duration: PERT/CPM - III

Lecture 32 - Project Scheduling: PERT/CPM - IV

Lecture 33 - Inventory Models: Economic Order Quantity (EOQ) Model - I

Lecture 34 - Inventory Models: Economic Order Quantity (EOQ) Model - I​I

Lecture 35 - Economic Production Lot Size Model

Lecture 36 - Inventory Model with Planned Shortages

Lecture 37 - Inventory Model - III

Lecture 38 - Single-period Inventory model with Probabilistic demand

Lecture 39 - Multi-period Order-Quantity, Reorder Point Model with Probabilistic Demand

Lecture 40 - Periodic Review Model (P-type) with Probabilistic Demand

Lecture 41 - Financial risks associated with the development of a new product - I

Lecture 42 - Financial risks associated with the development of a new product - II

Lecture 43 - Inventory Simulation

Lecture 44 - Simulation - III

Lecture 45 - Simulation - IV

Lecture 46 - Decision Analysis - I

Lecture 47 - Decision Analysis - II

Lecture 48 - Decision Analysis - III

Lecture 49 - Decision Analysis - IV

Lecture 50 - Decision Analysis - V

Lecture 51 - Formulation Of Goal Programming - I

Lecture 52 - Formulation Of Goal Programming - II

Lecture 53 - Multicriteria Decisions - I

Lecture 54 - Multicriteria Decisions - II

Lecture 55 - Multicriteria Decisions - III

Lecture 56 - Time Series Analysis and Forecasting - I

Lecture 57 - Time Series Analysis and Forecasting - II

Lecture 58 - Time Series Analysis and Forecasting - III

Lecture 59 - Time Series Analysis and Forecasting - IV

Lecture 60 - Time Series Analysis and Forecasting - V