The Delhaize branch in Ninove handles beverage containers coming in bulk from the several warehouses in Belgium to be returned to the breweries. These containers need to be sorted and palletized first. ARCsom Automation actively helped developing and optimize the automation process to realize this. In the past, an Excel based reporting tool was developed by Delhaize in order to be able to get production statistics. This tool was not maintained and no one could continue the development of the tool. This is where ARCsom was asked to put a more performant and more flexible solution in place.
Solution
A Citect Scada handles the population of a database. As most of the needed data was already available in the database, the ‘Pluto Live Report’ software was chosen for the task.
Our IT and SCADA experts added the missing data points to be logged and created the necessary tables and views in SQL in order to provide the Pluto reporting tool with the exact historical data.
The Pluto reporting tool was configured to provide the needed production reports in a user-friendly way. Amongst other this includes:
- Graphical reports of production amounts for every automated production line.
- Graphical reports of production amounts for every beverage container brand of the manual production lines.
- Reports for statistical production figures and calculations such as processed, rejected and unrecognized beverage containers.
- Process alarms
- …
By combining knowledge in both the beverage handling process and data analysis we provided a future proof and scalable reporting tool!
