Formulating and solving linear programming models using the Excel spreadsheet program

Abstract

The aim of this research is to highlight the importance of using electronic tables to solve many mathematical problems facing decision makers and implementers, and it is used to reduce the difficulties that researchers face in obtaining ready-made software for quantitative analysis, which is expensive and difficult to understand and when applied, it takes a period of time to absorb it.
Electronic tables are used to solve many linear programming models, for example, resource identification issues, transportation issues, decision-making, and production scheduling. On the other hand, EXCEL electronic tables program is characterized by its ease of application and absorption by those who have experience in the field of linear programming, quantitative analysis, and computers.
This research contains a practical example of building, formulating and solving a mathematical model using this method.