Decision making with spreadsheet

By Prof. Ramesh Anbanandam   |   IIT Roorkee
Learners enrolled: 432
About the 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. 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
Course Status : Upcoming
Course Type : Core
Duration : 12 weeks
Start Date : 24 Jan 2022
End Date : 15 Apr 2022
Exam Date : 24 Apr 2022 IST
Category :
  • Operations
  • Management Studies
Credit Points : 3
Level : Undergraduate/Postgraduate

Course layout

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

Books and references

  1. Introduction to Operations Research by Frederick Hillier, Gerald Lieberman.
  2. Operations Research: An Introduction, 6th Edition by Hamdy A. Taha, University of Arkansas, Fayetteville.
  3. Introduction to Management Science: Quantitative Approaches to Decision Making, by David Anderson, Dennis J. Sweeney, Thomas Arthur Williams.

Instructor bio

Prof. Ramesh Anbanandam

IIT Roorkee
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. He did Ph.D. from IIT Delhi and M.Tech from NIT Trichy. His research area includes humanitarian supply chain management, multimodal freight transportation, sustainable mobility, healthcare waste management, and data-driven decision-making modeling. He has published more than 40 research papers in reputed journals and conferences. He was also organized international conferences, TEQIP training sessions, and NPTEL online courses. He is a regular reviewer of many peer-reviewed journals and actively participating in various seminars, talks, and conferences in India and abroad.

Course certificate

The course is free to enroll and learn from. But if you want a certificate, you have to register and write the proctored exam conducted by us in person at any of the designated exam centres.
The exam is optional for a fee of Rs 1000/- (Rupees one thousand only).
Date and Time of Exams: 24 April 2021 Morning session 9am to 12 noon; Afternoon Session 2pm to 5pm.
Registration url: Announcements will be made when the registration form is open for registrations.
The online registration form has to be filled and the certification exam fee needs to be paid. More details will be made available when the exam registration form is published. If there are any changes, it will be mentioned then.
Please check the form for more details on the cities where the exams will be held, the conditions you agree to when you fill the form etc.


Average assignment score = 25% of average of best 8 assignments out of the total 12 assignments given in the course.
Exam score = 75% of the proctored certification exam score out of 100

Final score = Average assignment score + Exam score

YOU WILL BE ELIGIBLE FOR A CERTIFICATE ONLY IF AVERAGE ASSIGNMENT SCORE >=10/25 AND EXAM SCORE >= 30/75. If one of the 2 criteria is not met, you will not get the certificate even if the Final score >= 40/100.

Certificate will have your name, photograph and the score in the final exam with the breakup. It will have the logos of NPTEL and IIT Roorkee. It will be e-verifiable at nptel.ac.in/noc.

Only the e-certificate will be made available. Hard copies will not be dispatched.

Once again, thanks for your interest in our online courses and certification. Happy learning.

- NPTEL team

MHRD logo Swayam logo


Goto google play store