Optimization using MS-Excel Solver

Authors

  • R. Pangayar Selvi
  • B. Sivasankari
  • R. Vasanthi

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

Download data is not yet available.

Author Biographies

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

Downloads

Published

2020-10-28

How to Cite

[1]
Selvi, R.P. et al. 2020. Optimization using MS-Excel Solver. Biotica Research Today. 2, 10 (Oct. 2020), 1061–1062.

Issue

Section

General Article

Categories