Importance of production optimization and possible solution

The task of optimizing the structure of raw materials during the planning of the production must de solved at each company interested in maximizing the profit from the sale of manufactured products. The main tool for solving these tasks is the set up «Solver» in Microsoft Excel.