How a manual consolidation of several plants works
A typical monthly process looks like this: the group's BHP team asks each plant for data, the plants reply by email in different layouts, someone at headquarters copies the figures into a shared spreadsheet, and then explains the differences in area names and periods. Each step is short, but together they take a working day, and the result is still hard to compare between plants.
The biggest cost is not the hours themselves but the delay. A report that is ready only in the middle of the following month is no use for reacting to current events.
How the system replaces this process
Periodic reports are configured with rules for each product: permits, employees, notifications, training and deliveries. Each rule has a daily, weekly or monthly cadence. The report arrives by email with tables in the body, a PDF attachment carrying the client's logo and optionally an XLSX file, so the same set can be read on a phone and processed further in a spreadsheet.
The scope of locations and recipients is set separately for each rule. Two reports from the same system can therefore cover different areas and different recipients: a plant receives its own report, and headquarters receives a summary for the whole group. The training report shows, among other things, trainings expiring within 34 days and people who entered the plant without a valid training, which turns the report from an archive into a tool for current control.
Monthly group consolidation time: manual and with reporting rules
- Manual
- With reporting rules
Why the reports can be trusted
Report delivery is idempotent. For each pair of rule and period the system keeps a delivery log and does not send the same report twice. Disabling a rule stops delivery without deleting recipients or history, so changing settings does not destroy evidence. Reports are fed with system data, skipping service accounts and technical alarm templates, so the figures are not inflated by technical accounts.
Dates in the email, the PDF, the XLSX and the panel all come from one formatter with Polish date conventions. This is a small detail that matters in a group: plants do not argue about the format or the period, because they all read the same record.
Calculation: hours per month
The calculation below is illustrative and based on the assumptions in the table. Each group can insert its own figures. The values depend on the number of plants and on how the data is collected today.
With four plants, manual consolidation takes 16 hours a month in total: 8 hours of data collection (2 hours per plant), 6 hours of merging in a spreadsheet and 2 hours of correcting discrepancies. After the reporting rules are rolled out, 2 hours of checking the result remain, so the saving is 14 hours a month, or 168 hours a year. The monetary value can be calculated by multiplying the hours by your own employee rate, which we do not do here.
What this calculation does not cover
The calculation counts only the time spent on consolidation. It does not value faster reaction to expiring trainings, better comparability between plants or a lower risk of errors when figures are copied, because these effects cannot be honestly expressed in one number without data from a specific group. It is worth describing them qualitatively in the investment justification.
Time saved on group consolidated reports
| Parameter | Value |
|---|---|
| Number of plants in the group | 4 plants |
| Data collection from one plant | 2 hrs/month |
| Merging in a spreadsheet | 6 hrs/month |
| Correcting discrepancies | 2 hrs/month |
| Checking the report after the rules are in place | 2 hrs/month |
Result: Manual: 8 + 6 + 2 = 16 hrs/month. With rules: 2 hrs/month. Saving: 14 hrs/month, or 168 hrs a year.
Note: Sample calculation: the time assumptions do not come from a specific client. The result depends on the number of plants and on how the data is collected.
Video
Frequently asked questions
Can a report go to different people depending on the plant?
Yes. The scope of locations and recipients is set separately for each rule, so a plant and headquarters receive different views from the same system.
What happens if I disable a report rule?
Delivery stops, but the recipients and the history remain. Re-enabling the rule restores the report without reconfiguration.
Can a report go out twice for the same period?
No. The system keeps a delivery log for each pair of rule and period and does not resend the same report.
Let's calculate the saving for your group
Give us the number of plants and the way you consolidate data today, and we will prepare a calculation with your own assumptions.
Let's talk