potential analysis
blogStart potential analysis

Case Study: Automotive Manufacturing

From the fog of the "
" trialto global clarity

Over 200 complex projects across locations on three continents, managed centrally. Presented as a global best-practice standard to an industry audience at Smartsheet ENGAGE in Seattle.

5Works
3continents
200+projects managed

In video

FEW Automotive, featured at Smartsheet ENGAGE

The challenge

Transparency as a Critical Success Factor in Global Growth

As a hidden champion, the FEW Group grew rapidly, but its internal infrastructure could not keep pace. Five plants were operating in isolated Excel silos, which led to a failed project costing €600,000 because there was a lack of the transparency needed to take timely corrective action.

01

A fragmented data landscape: Working with isolated spreadsheet solutions across continental borders made it difficult to manage global projects consistently and prevented the adoption of any form of uniform standards.

02

High financial risk: A critical lack of real-time visibility meant that problems were not detected until avoidable losses totaling 600,000 euros had already been incurred as a result of a single failed project.

03

Administrative inefficiency: Reliance on manual processes and error-prone Excel spreadsheets tied up valuable management resources and prevented the company from achieving scalable operational excellence across the entire organization.

The solution

The Fresnel Principle as a Global Benchmark for Operational Excellence

Instead of installing rigid software, we implemented a dynamic system that focuses diffuse data streams into a clear line of sight, much like a Fresnel lens. This approach was so effective that Smartsheet invited us and FEW to Seattle to present the solution to an international audience of industry professionals as a global benchmark.

Kaizen Management System


We implemented a 7-step process—from the shop floor to strategy—to embed continuous improvement throughout the entire production process.

More on this

KPI Performance Hub


Today, real-time dashboards transform complex data sets into immediate decision-making bases for global management.

More on this

Smartsheet Integration


The technical basis enables global scaling and the automation of routine tasks across locations.

More on this

The result

Measurable Transformation

30 Admin costs through the radical automation of manual processes
90 Customer satisfaction through absolute delivery reliability and on-time execution
1 A single source of truth across all projects

Project partners

The people behind this project

Konstantin Gross

Konstantin Gross

Group Program Manager, FEW Automotive

Nico Röpnack

Nico Röpnack

Founder & Managing Director, Lighthouse Consultings

Answers for decision-makers

What Decision-Makers Need to Know

The questions that operations managers most frequently ask us before a project like the one at FEW.

Do we already need to be using Smartsheet?
No. We can build on existing Smartsheet environments or start from scratch. If you’re currently working with Excel pivot tables or scattered spreadsheets, we’ll take the data structure and seamlessly migrate it to a Smartsheet solution that your team can then maintain on their own.
What do you use n8n and automation for?
n8n connects the systems that currently require manual data transfer—such as Smartsheet, HubSpot, email, and ERP. Recurring tasks like status updates, notifications, and reports then run automatically in the background, rather than taking up someone’s time every day.
How do you approach the topic of AI, and does it make sense for small and medium-sized businesses in the DACH region?
We use AI specifically where it provides a measurable benefit—such as in classification, forecasting, or decision support—rather than as an end in itself. At FEW Automotive, we’ve used it to replace manual analyses that used to take days to complete. Every solution remains transparent and manageable for your team.
What are the regulations regarding data protection and the GDPR?
Data protection is an integral part of every project, not an afterthought. We clarify at the outset what data will be processed and where it is stored, enter into a data processing agreement if necessary, and prioritize components that process data within the EU. Sensitive data is only used where it is legally and contractually well-protected.
How long does a project take, and how much does it cost?
A first functional version is usually ready within a few weeks, and many projects begin with a clearly defined pilot. The investment required depends on the scope and level of integration. During a brief initial consultation, we’ll assess the effort and benefits for your specific situation before you make a commitment.

Next step

Global clarity—for your projects, too .

Schedule an appointment right away—it’s free and there’s no obligation. We’ll discuss where your greatest opportunities lie and how we can help you capitalize on them.

Smartsheet Gold Partner – Lighthouse Consultings in the Smartsheet Marketplace