From Multiple Spreadsheets to a Single Dashboard: How Embraer Turned Contract Price Adjustments into a Strategic Decision
Within Embraer's Cost Engineering division, one of the organization's most critical financial disciplines historically relied on one of the least strategic tools available: manual Excel spreadsheets. Contract tracking, price adjustment formulas, and the monitoring of global economic indices across worldwide aerospace suppliers were scattered across dozens of disconnected files, updated by hand and maintained by individual specialists.
The issue was not the expertise of the team—it was infrastructure. Every contractual adjustment required cross-referencing external economic indices with complex contractual formulas manually, every supplier renegotiation spawned a new spreadsheet version, and every historical analysis depended on tracking down whoever authored the file. The result was massive time consumed by clerical tasks and a fragmented view of a landscape requiring high-level strategic foresight.
Cost Engineering is not a clerical department; it is a strategic decision center. The work that truly matters lies in anticipating macroeconomic risks, prioritizing high-impact supply agreements, and approaching supplier negotiations armed with bulletproof financial data. When management lives in manual spreadsheets, however, team energy is depleted long before reaching analysis: compiling indices, updating formulas, reconciling versions. Furthermore, contract adjustments span multiple corporate units, each with distinct governance requirements. Without a unified system governing access and audit trails, collaboration depended on informal email exchanges and data risked losing traceability.
The hypothesis was clear: if an intelligent web platform could automatically ingest market indices, store contractual adjustment formulas, and compute price adjustments autonomously, Cost Engineering could shift from routine data entry to high-leverage strategic analysis. The requisite technology existed; what was missing was integrating it with Embraer's enterprise rules, supplier contract repositories, and the operational demands of cross-referencing dozens of economic sources for every pricing decision.
Engineering the platform involved intricate technical realities.
The indices driving price adjustments originate from diverse international institutions, each with distinct schemas and release schedules. Ingesting, normalizing, and updating these indicators automatically required an enterprise integration pipeline, not a simple script. Furthermore, contract master records already resided within iSupply; re-entering contracts from scratch would introduce redundant labor and human error. Therefore, the platform had to interface with existing repositories, ingesting master records seamlessly. Additionally, every aerospace agreement carries distinct adjustment logic, with weighted coefficients and index linkages that shift across renegotiations. The system had to empower Cost Engineering specialists to configure and adjust these mathematical formulas independently without requiring technical support.
Image 01: In-person meeting between AutoU and Embraer teams aligning project objectives
The Proactive Price Adjustment Hub is an enterprise web platform replacing manual spreadsheet tracking with a unified environment for contract administration, automated adjustment modeling, and market data intelligence. Built across four core epics, each layer tackles a specific dimension of the challenge. The system automatically ingests international economic indices on a recurring basis (including BLS, Standard & Poor's, Eurostat, Cost Drivers) and interfaces with Embraer's internal master databases to import contract records without data duplication. The platform also natively ingests standard inflation reports, ensuring forecast charts and analytics update automatically with every new data release. Moreover, the interface provides a dedicated workbench where Cost Engineering specialists configure adjustment formulas, set weighting parameters, and update terms as supplier negotiations conclude. Additionally, an intelligent contract radar visually classifies each agreement across risk and opportunity quadrants based on index variance versus projected spend. Predictive projection graphs highlight future budgetary variances, while automated spend ranking focuses engineering efforts on the highest-value supplier agreements. Finally, an executive dashboard unifies all indicators in real time, streamlining macroeconomic oversight. The platform also automates analytical report generation, eliminating manual presentation drafting and guaranteeing consistent executive reporting.
The most profound impact lies not simply in hours saved, but in transforming the nature of work. Cost Engineering ceased to be spreadsheet operators and returned to practicing true cost engineering: modeling scenarios, pre-empting supply risks, and negotiating armed with empirical evidence. Centralizing contract intelligence also resolved an unspoken vulnerability: relying on key individuals to know the status of critical agreements. With a unified, live command center, executive leadership no longer needs to ask for status updates—they see trends immediately and can act before market volatility erodes margins.
Far beyond digitizing spreadsheets, the Proactive Price Adjustment Hub transformed contract adjustments from a reactive operational burden into an agile strategic capability backed by reliable data, rigorous governance, and automated prioritization.
Automation unlocks the analysis that matters. The bottleneck was never team competence; it was the hours lost to manual clerical triage. By automating index ingestion and adjustment calculations, the platform returned time to Cost Engineering for the work that truly demands their intellect. What began as an efficiency initiative revealed an indispensable strategic asset: an executive radar delivering clarity on contract adjustments that never existed before.
Image 02: AutoU and Embraer teams collaborating on the Proactive Price Adjustment project