InnerWeb
Skip to main content

Manual weekly summary vs automated report: cost and savings

A manual weekly OHS summary usually takes several hours of work every Monday: collecting figures from several places, pasting them into a spreadsheet and sending them by email. Below is a sample calculation with stated assumptions, showing what this costs per year and how much of that a scheduled report recovers, since it assembles and sends the summary on its own.

150 h
a year on the manual summary (assumption 3 h x 50 weeks)
Source: sample calculation
120 h
recovered a year at the 80% assumption
Source: sample calculation
10 800 PLN
value of recovered time a year at 90 PLN per hour
Source: sample calculation

What a manual weekly summary consists of

A manual summary has several stages, and each one takes time. First the data has to be collected: the number of open and closed permits, findings, training sessions and patrols. Then the data goes into a spreadsheet, where it is totalled, checked and formatted. Finally a message with a table and an attachment is created.

The biggest cost is not the counting itself but the repetition. The same summary is produced every week, so a small loss of time is multiplied by fifty. There are also delays: when the person responsible is on leave, the summary is either not produced or is produced several days late.

  • Collecting figures from several places and views
  • Retyping into the spreadsheet and checking the totals
  • Formatting the table and preparing the attachment
  • Sending to the recipient list and correcting after comments

What the scheduled report does instead of a person

A report rule has a daily, weekly or monthly frequency with a sending time. Its body contains tables, charts and details depending on four switches. A weekly report covers the previous full week from Monday to Sunday, so on Monday morning the recipients have a complete set of figures for the closed period.

A PDF with the client logo is attached to the email, and an XLSX file is optional. For permits the report shows the number of open, closed and active permits, the median time from opening to closing, and a ranking of external companies. The weekly table of issuers is broken down by day of the week.

Hours a year on the weekly summary

Hours a year on the weekly summaryBefore and after comparison: 150 hours a year manually versus 30 hours with the scheduled report050100150hoursManual: Preparing the summary: 150 hours150 hoursManualScheduled report: Preparing the summary: 30 hours30 hoursScheduled report
Source: Sample calculation based on the assumptions in the Calculation section

Sample calculation with stated assumptions

The figures below are sample assumptions, not results from a specific plant. Each plant should substitute its own values: the time needed to prepare the summary, the number of weeks and the cost of an hour of work.

Assuming 3 hours per week and 50 weeks per year, the manual summary takes 150 hours a year. At a cost of 90 PLN per hour, this comes to 13,500 PLN a year. The scheduled report takes over the collecting, totalling and sending. We assume 20% of the manual time remains for reading the report and discussing the conclusions, which is 30 hours, so 120 hours and 10,800 PLN a year are recovered.

Costs the spreadsheet does not show

Beyond working hours, the manual summary carries hidden costs. The first is the risk of error when figures are retyped. The second is version drift: two summaries from the same week, produced at different times, show different values. The third is dependence on a single person.

The automated report counts data from one source using the same definition every time. The data is cleaned: service accounts and technical alarm templates are excluded from queries, and times are given as the median or a percentile, which is resistant to extreme values. As a result, a figure in the Monday report has the same meaning next month and next year.

How to introduce the report without losing continuity

The safest approach is to run the report in parallel with the manual summary for 2-3 weeks. The figures are compared, the differences are explained, and only then is the manual summary stopped. Differences usually come from a different definition, for example whether permits closed on Sunday evening count towards that week.

It is also worth agreeing recipients and location scope from the start. Rules are set per instance and per location scope, and an empty scope means all locations. Two rules with different locations and recipients can run side by side, for example a separate report for each department and a consolidated one for management.

Indicative cost ranges and limits of the calculation

Reporting is a feature of the platform, so it is not a separate purchase. The implementation cost consists of configuring rules and recipients and a short check of the figures. The platform price is individual and depends on the scope of modules.

The calculation does not include time spent reading the reports or organisational changes. It also excludes hard-to-measure benefits, such as a faster response to a trend of expiring training or a growing number of findings. Treat it as a lower estimate.

Example calculation

Sample calculation: weekly OHS summary

Assumptions
ParameterValue
Time to prepare the summary3 hours a week
Number of weeks in a year50 weeks
Cost of an hour of work90 PLN
Time left for reading and conclusions20 % of manual time

Result: Manual: 150 h and 13,500 PLN a year. With the scheduled report: 30 h and 2,700 PLN. Recovered: 120 h and 10,800 PLN a year.

Note: Sample calculation based on the assumptions above. The results for a specific plant depend on the number of summaries, recipients and the cost of labour; individual pricing applies.

Video

Frequently asked questions

Does the report replace the analysis of findings?

No. The report removes the work of collecting and assembling the figures. Reading them and making decisions remain with people.

Will the report figures differ from our spreadsheet?

They may at the start, because the report applies fixed definitions and cleaned data. That is why it is worth keeping both summaries in parallel for 2-3 weeks.

Does the report cover data from other systems?

InnerWeb reports cover data recorded in InnerWeb. InnerWeb complements the client's existing systems, so summaries from time and attendance or ERP systems remain separate.

Calculate it with your own figures

We will put your summary preparation time and your hourly cost into the calculation. Book a call with InnerWeb.

Let's talk