Optimization using MS-Excel Solver
R. Pangayar Selvi
Dept. of Social Sciences, Agricultural College and Research Institute, TNAU, Killikulam, Vallanadu, Tamil Nadu (628 252), India
B. Sivasankari*
Dept. of Agricultural Economics, Agricultural College and Research Institute, TNAU, Madurai, Tamil Nadu (625 104), India
R. Vasanthi
Dept. of Physical Sciences & IT, Agricultural Engineering College and Research Institute, TNAU, Coimbatore, Tamil Nadu (641 003), India
DOI: NIL
Keywords: Linear Programming, MS Excel Solver, Operations Research, Optimization
Abstract
MS Excel has a built in ADD-IN pack (available under tools menu) known as “Solver” which is a powerful tool for solving optimization problems. The solver add-in for Excel is an easy way to solve linear, non-linear and integer programming problems in operations research. After formulating the real life problems, can be solved easily by using MS Excel Solver. In this article we illustrate the method of solving the linear programming problem using Solver.
Downloads
not found
Reference
Sakai Troxell, 2002. Optimization Software Pitfalls: Raising Awareness in the Classroom. INFORMS Transactions on Education 2(2): 40-46. https://doi.org/10.1287/ited.2.2.40
Hilal A. Abdelwali, Swilem M. Swilem, Rafik El Shiaty, Mokhtar M. Murad, 2019. “Solving A Transportation Problem Actual Problem Using Excel Solver”, International Journal of Engineering and Technical Research (IJETR); 9(12): 2454-4698.
Salim A. Saleh , Thekra I. Latif, 2009. “Solving Linear Programming Problems by Using Excel’s Solver”, Tikrit Journal of Pure Science; 14(2): 87-98.