The verdict in three sentences
In a 20-branch equipment rental network, manual reporting eats 80 hours a week of branch managers who should be with customers. Make or n8n automation (USD 3,500 to 11,000) removes data entry by connecting the rental ERP, CRM and spreadsheets in 4 to 6 weeks. A data warehouse with dashboards (USD 17,000 to 40,000, 8 to 12 weeks) becomes necessary once leadership wants to compare margin, utilization and sales pipeline per branch in one reliable view.
Where the 80 weekly hours go
Every Monday, branch managers export the week's revenue from the rental ERP, copy quotes from the CRM, add equipment check-outs and returns, then email an Excel file to head office. The financial controller consolidates 20 files in slightly different formats and leadership gets a summary on Wednesday, already outdated.
| Weekly task (2026 estimate) | Time per branch | Network time (20 branches) | After automation |
|---|---|---|---|
| Export and rework of rental revenue | 1 h | 20 h | 0 h |
| Copying quotes and CRM follow-ups | 1 h | 20 h | 0 h |
| Fleet tracking (check-outs, returns, downtime) | 1 h | 20 h | 0.25 h |
| Comments and action plan | 0.5 h | 10 h | 0.5 h |
| Corrections requested by head office | 0.5 h | 10 h | 0 h |
| Consolidation at head office | 8 h | 1 h | |
| Total | 4 h | 88 h | about 16 h |
The branch manager's commentary stays useful: automation removes data entry, not analysis. The roughly 70 hours freed each week go back to the field, job site visits and quote follow-ups.
Two levels of automation: the 2026 grid
| Option | Setup cost | Monthly cost | Timeline | Limits |
|---|---|---|---|---|
| Make scenarios linking ERP, CRM and Google Sheets | USD 3,500 to 6,500 | USD 35 to 130 | 3 to 5 weeks | fragile if the ERP changes its exports |
| Self-hosted n8n with staging database | USD 5,500 to 11,000 | USD 20 to 90 (server) | 4 to 6 weeks | needs technical maintenance |
| Data warehouse (BigQuery or PostgreSQL) and Power BI | USD 17,000 to 28,000 | USD 170 to 450 (Power BI Pro at USD 14 per user) | 8 to 10 weeks | data model to validate |
| Full warehouse, 3-year history and forecasting | USD 28,000 to 40,000 | USD 330 to 660 | 10 to 12 weeks | higher budget |
| BI module built into the rental ERP | USD 170 to 550/month | included | 2 to 4 weeks | CRM data rarely integrated |
Level 1 fits if the goal is to stop data entry. Level 2 brings what spreadsheets never deliver: one definition of utilization, margin per equipment family and quote conversion rate, identical across all 20 branches.
The metrics to automate first
| Metric | Source | Frequency | Alert threshold |
|---|---|---|---|
| Fleet utilization by family | rental ERP | daily | below 60% for 2 weeks |
| Rental and service revenue per branch | ERP and billing | daily | more than 10% off budget |
| Quotes issued and conversion rate | CRM | weekly | below 25% over a month |
| Average quote response time | CRM | weekly | over 48 h |
| Equipment under repair or idle | ERP and workshop | daily | over 8% of fleet |
| Receivables over 60 days | accounting | weekly | over 5% of revenue |
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Keep 8 to 12 metrics on the dashboard home page. Beyond that, branch managers stop looking.
If you hand this project to Kolonell, it falls under our custom application grid: 2,500,000 to 4,000,000 FCFA (EUR 3,810 to 6,100) for level 1 automation, 4,000,000 to 7,000,000 FCFA (EUR 6,100 to 10,670) for a data warehouse with dashboards, then maintenance at 35,000, 75,000 or 120,000 FCFA a month (EUR 50, 110 or 180).
Mini case study
Marcus, VP of sales at a 20-branch equipment rental network around Miami, counts 88 hours of reporting a week. After automation, 16 remain: 72 hours freed, or 3,300 hours over 46 weeks. At a loaded USD 45 an hour, that is USD 148,500 of time a year. Assuming cautiously that only half turns into useful sales activity, the gain reaches USD 74,000. The level 2 project costs USD 26,000 plus USD 330 a month, or about USD 30,000 in year one: payback in about five months, before counting faster quote follow-ups.
FAQ
Make or n8n, which one? Make is quicker to learn and costs USD 35 to 130 a month. Self-hosted n8n costs USD 20 to 90 a month in server fees and keeps data in-house, but needs a provider for maintenance.
Our rental ERP has no API, is that a blocker? No. A scheduled CSV export or read access to the database works in most cases. Allow 1 to 2 extra weeks to make that feed reliable.
How much do Power BI licences cost? Power BI Pro is USD 14 per user per month. For 20 branch managers and 5 head office staff, the budget is about USD 4,200 a year.
Will branch managers adopt the dashboard? Adoption exceeds 80% when they help choose the metrics and the dashboard truly replaces the Excel file. Plan a half-day of training per branch.
What if a data feed breaks? An email or Teams alert warns the owner within an hour. A maintenance contract covers these incidents, which happen 2 to 4 times a year on average.
Let's scope your project. Send us your tool list (ERP, CRM, accounting) and branch count, and we will price level 1 automation or a data warehouse with an indicative budget and a 6 to 12 week timeline. Detailed quote within 48 h. WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.
