Methods for Solving Linear Programming Problems Using Modern Computer Technologies

Abstract

The purpose of the article is to improve the study of such software products, as systems of the automated engineering’s and economic calculations of Excel and MathCAD which are resulted the detailed decision of optimization task, as to one of major and labour intensive in economic calculations. The research methods are mathematical modeling methods for solving linear programming problems, that promotes higher levels and training quality of the specialists requires the solution of a whole range of tasks: development and support of systems thinking, providing all kinds of cognitive activity, development and consolidation of skills and abilities in conjunction with active teaching methods. The novelty of the research is proposed method of solution, as a result of the appearance in recent years of engineering means and scientific calculations allows the specialist to solve the tasks without perfect knowledge of programming languages, with using the format of a regular mathematical record. However, there is a need for perfect possession of such software as Excel and MathCad – automated engineering and economic calculation systems. Conclusions. This development will assist more high-quality preparation of highly skilled specialists in an economy, management, account and audit.

Keywords

• лінійне програмування
• оптимізація
• математичне моделювання
• excel
• mathcad
• економічні розрахунки