Optimalizace výroby piva v pivovaru

The present thesis is based on actual data provided by the employees of the Zubr Brewery and it focuses on production optimization, aiming to maximize yearly profit while taking into account various limitations defined in advance. A convenient tool for determining the optimum yearly production of individual products is linear programming. For the purposes of this thesis, the production planning problem is utilized. An economic model was constructed on the basis of available data and -- after several essential calculation tasks -- a mathematical model was established, which was subsequently calculated using Microsoft Excel and its Solver functionality. Finally, the resultant values were interpreted. Apart from the analysis per se, the first two chapters explain the concept of linear programming and briefly introduce the Zubr Brewery, its products and its technology of brewing.