IIT Roorkee · Business & Management

Decision making with spreadsheet

Prof. Ramesh Anbanandam · 60 free video lectures

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…

▶ Play on Open Lecture HallCourse page ↗

Lectures

  1. Introduction
  2. Cost, Revenue, & Profit Models, Break Even Analysis
  3. Linear Programming Problem: Formulation & Assumptions
  4. Linear Programming Problem: Graphical Solution Method
  5. Graphical Calculator and Excel Solver for solving LPP
  6. Sensitivity Analysis -1
  7. Sensitivity Analysis -2
  8. Sensitivity Analysis -3
  9. LPP Applications in Marketing
  10. LPP Applications in Finance
  11. LPP Applications in Operations - 1
  12. LPP Applications in Operations - 2
  13. LPP Applications in Operations - 3
  14. Advanced LP Applications – Data Envelopment Analysis
  15. Game Theory - 1
  16. Game Theory - 2
  17. Portfolio Management
  18. Revenue Management
  19. Distribution and Network Problems: Transportation Problem
  20. Assignment and Shortest Path Problem
  21. Maximal Flow, Production & Inventory Application, Scheduling and Assignment Problems
  22. Integer Linear Programming
  23. Integer Programming Distribution Problem
  24. Nonlinear Optimization Models
  25. Nonlinear Optimization Models - II
  26. Nonlinear Optimization Models - III
  27. Nonlinear Optimization Models - IV
  28. Nonlinear Optimization Models - V
  29. Project Scheduling: PERT/CPM - I
  30. Project Scheduling: PERT/CPM - II
  31. Project Scheduling For Uncertain Activity Duration: PERT/CPM - III
  32. Project Scheduling: PERT/CPM - IV
  33. Inventory Models: Economic Order Quantity (EOQ) Model - I​
  34. Inventory Models: Economic Order Quantity (EOQ) Model - I​I
  35. Economic Production Lot Size Model
  36. Inventory Model with Planned Shortages
  37. Inventory Model - III
  38. Single-period Inventory model with Probabilistic demand
  39. Multi-period Order-Quantity, Reorder Point Model with Probabilistic Demand
  40. Periodic Review Model (P-type) with Probabilistic Demand
  41. Financial risks associated with the development of a new product - I
  42. Financial risks associated with the development of a new product - II
  43. Inventory Simulation
  44. Simulation - III
  45. Simulation - 4
  46. Decision Analysis - I
  47. Decision Analysis - II
  48. Decision Analysis - III
  49. Decision Analysis - IV
  50. Decision Analysis - V
  51. Formulation Of Goal Programming - I
  52. Formulation Of Goal Programming - II
  53. Multicriteria Decisions- I
  54. Multicriteria Decisions- II
  55. Multicriteria Decisions- III
  56. Time Series Analysis and Forecasting - I
  57. Time Series Analysis and Forecasting - II
  58. Time Series Analysis and Forecasting - III
  59. Time Series Analysis and Forecasting - IV
  60. Time Series Analysis and Forecasting - V

From NPTEL (IITs and IISc) · CC BY-NC-SA. More from IIT Roorkee.

Open Lecture Hall is free, with no ads and no sign-up. It is not run by or connected to any university; the lectures are the universities' own free recordings, played from where they host them. About & rights