SAB tracks the performance of profit improvement projects to ensure ROI
FOOD AND BEVERAGE
Goals
- To track the performance of profit improvement projects and to measure their positive or negative impact on revenue
Challenges
- Deciding which parameters to track and determining the monetary value for the chosen units
- Taking into account the effect of interactions between measured resources (e.g. the value of natural gas not being used due to an increase in the usage of biogas)
Results
- Faster detection and resolution of issues
- Performance is measured in terms of a commodity real to everyone – money
- Easier determination of what works and what doesn’t
- Values are available daily
Solutions & Products

Project goals and implementation
In view of the problems they faced, SAB set themselves the following goals:
- Ease of use – The system would have to retrieve the required data automatically but still allow for manual data entry (see later).
- The ability to aggregate data over any time period – This included determining weekly, monthly and yearly values.
- The capability to calculate revenue performance from a specific point in time against a baseline value.
- The ability to mine data from a variety of sources as well as manual entry.
- Generate graphical reports that would clearly show the revenue generated by PIPs or their regression from their target goals.
The solution that best complied with these criteria was Flow Software, which works seamlessly with Wonderware’s Historian and which was already in successful use at SAB.
The information from HMIs and PLCs is collected by Wonderware historian and channelled to Flow which also connects to other databases as well as web-based manual input forms. Flow is configured to aggregate and calculate results based on these values as required and to publish the results as web-based reports or back to the InTouch HMIs via System Platform.
“The best feature of Flow in this instance was its capability to integrate values from different sources into one platform,” says Venter. “Manual entries, database values or historian values from the PLC can all be integrated and Flow makes it easy to configure such an arrangement.”
Flow enabled the reporting system to be implemented quickly. The only time-consuming aspect of this exercise was to ensure that the calculations were correct and reported in terms everyone could understand – money. “The system was run in parallel with the manual Excel spreadsheet to check accuracy and it was quickly shown to be more accurate and informative as we could see daily rather than weekly values,” says Venter.
At SAB, the system measures biogas usage and compressor electricity consumption and reports this on a weekly, monthly or annual basis against a baseline established before the solution went into operation. “This looks straightforward but is more complicated than it seems,” says Venter. “For example, we usually measure electricity usage against volume packed giving us a ratio of kwh/hl. But this will skew the picture as those weeks where a lower packaging volume was planned while high brewing production occurred will affect the electricity ratio negatively. This gets even more complex with biogas as we have to consider the amount of natural gas we are not using due to the increase in biogas usage. This usually involves the finance department in order to determine an acceptable costing procedure.”

Benefits
- Less time spent on capturing data
- Real-time values are available on a day-to-day basis instead of only weekly. This provides previously-unknown opportunities for improvement (e.g. the use of biogas over weekends).
- Quicker reaction time to detect issues and rectify them – leads to cost savings
- The same approach can also be used to see improvements on KPIs vs the previous year’s performance and to track progressive improvements rather than comparing end results.
- Showing monetary values of performance improvements is sometimes a bigger motivator for operational staff than just the normal, unit-based performance measurements
- Quicker detection of a decline in performance against previous results.
- The determination that small improvements on some KPIs have a bigger impact on revenue that large improvements on others
- Tracking revenue improvement highlights where the effort should be focused while visual reports and dashboards on their HMIs help operational staff to understand where they should concentrate their efforts.