Performance analysis of the water supply system of a dairy company by means of an advanced simulation tool

This work presents the result of a research project, concerning the development of a simulation model for a water supply system of a dairy company, located in Parma, Italy. The approach developed allows investigating, through process simulation, the plant areas where the efficiency of the water supply system can be significantly improved by means of some simple interventions. The final objective is to reduce the water consumption of the plant; this represents a relevant issue to the dairy industry. In line with this goal, at first the simulation model was used to reproduce the current (AS IS) system, so as to reach a precise knowledge of the water flows in the plant. In the second part of the work, a series of alternative (TO BE) scenarios was investigated, and the related performance was assessed, thus identifying the best plant configuration. The process simulator was designed under Microsoft Excel, programmed with Visual Basic for Applications. Thanks to the study implemented, an optimal scenario of the water supply system was finally identified, which allows savings up to 7.2% of water compared to the original configuration.