There is a conversation that happens regularly in companies with between 50 and 500 employees. The COO — or whoever fills that role — arrives on Monday with a leadership meeting at 10:00. Before that meeting, the numbers need to be consolidated: sales by channel, available inventory, operating costs, variances against budget. And those numbers are not in one place.
They are in the ERP, in an Excel file someone on the team updates on Fridays, in a report that arrives by email from the logistics department, and in a dashboard that sometimes loads and sometimes doesn't.
The COO spends between 90 minutes and three hours pulling that together. Every week.
Nobody records it as a cost. But it is one.
Why This Cost Is Invisible in Most Companies
A senior executive's time does not appear on any line of the P&L when it is spent on operational tasks. There is no invoice. There is no vendor. There are only hours that disappear.
That makes the problem difficult to prioritize. When someone proposes automating reporting, the typical response is: "we already have it under control — the COO handles it." What goes unsaid is how much that control costs.
The template described below requires no software or consulting engagement. It requires three data points that any company can obtain in under ten minutes.
The Three Variables in the Model
Variable 1: COO Hourly Cost
The starting point is the real cost per hour of the profile consolidating the data. Not the gross annual salary divided by 1,800 hours. The total cost to the company, including social security contributions, benefits, and — where applicable — a prorated bonus.
In Spain, a COO at a mid-size company carries a total cost of between €80,000 and €140,000 per year. Divided by effective working hours (approximately 1,600 hours/year after deducting vacation and absences), the range is €50 to €87 per hour.
For this exercise, use the figure that applies to your situation. If it is not the COO who consolidates the data but rather a controller or an operations manager, adjust the number to reflect the actual profile.
Variable 2: Weekly Hours Spent on Consolidation
Honesty is important here. This is not only the time spent in front of a screen merging files. It includes:
- Time spent searching for and downloading data from different sources
- Time spent cleaning and validating data (identifying that a figure doesn't reconcile and tracing why)
- Time spent formatting so the report is presentable
- Time spent on corrections when someone flags an error after the meeting
In companies with an ERP in place but no integration between systems, this time typically falls between 3 and 6 hours per week for a senior profile. In companies with more data sources or more frequent reporting, it can exceed 8 hours.
Variable 3: Reporting Frequency
Not all reporting cycles carry the same weight. A monthly financial close that takes four hours has a different impact than a weekly report that takes one hour. For the calculation, what matters is the total number of hours per month, regardless of how they are distributed.
The Calculation
The formula is straightforward:
Monthly cost = (Weekly hours × 4.3 weeks) × Hourly cost
Examples using the ranges described above:
| Profile | Hours/week | Cost/hour | Monthly cost |
|---|
| Conservative COO | 3 h | €50 | €645 |
| Mid-range COO | 5 h | €65 | €1,397 |
| COO with intensive reporting | 8 h | €87 | €2,992 |
These figures represent only the direct cost of the hours. They do not include:
- The cost of decisions made on data that is 48 or 72 hours old
- The cost of errors that go undetected until after the meeting
- The opportunity cost: what that profile could be doing with those hours
If you apply a conservative 1.5× multiplier to cover those indirect factors, the real monthly range falls between €950 and €4,500 depending on the case.
A Concrete Example
An industrial distribution company with 120 employees had a controller spending 6 hours per week consolidating sales, warehouse, and purchasing data from three separate systems. The hourly cost of that profile was €55.
Direct monthly cost: 6 × 4.3 × 55 = €1,419
With the 1.5× multiplier: €2,128 per month, or approximately €25,500 per year.
They implemented an agent that extracts, validates, and consolidates data from all three systems each night. The report is available every morning without manual intervention. Consolidation time dropped from 6 hours per week to under 30 minutes of review.
The implementation cost was recovered in under four months.
When Automation Makes Sense — and When It Doesn't
This model does not justify automating every process. It makes sense when at least two of the following three conditions are met:
- The calculated monthly cost exceeds €800
- The process recurs weekly or more frequently
- The data comes from more than one source and requires manual validation
If the process runs once per quarter and takes two hours, it is probably not the priority. If it runs every week and consumes a senior executive's time, the number speaks for itself.
Conclusion
The cost of consolidating data manually does not appear in any report. That is why it is tolerated for years. But it is a real cost — calculable and, in most cases, avoidable.
The three-variable template requires nothing sophisticated: an hourly cost, a number of weekly hours, and a frequency. That is enough to decide whether the problem warrants attention or can wait.
If applying the model produces a number that strikes you as material, the next step is to verify whether your situation has a concrete technical solution. That is what we do in the free diagnostic.
