PCN consolidation and validation — global automaker
The problem. A global automaker received PCN (Purchase/Negotiation Request) requests through a form, each one accompanied by an Excel file with the change data. Validating the file’s layout and business rules was manual, and periodically consolidating approved tickets — merging the data from every approved file into a single file to send to the requester — was done by hand, spreadsheet by spreadsheet.
The solution. Renew automated the entire workflow: a form and approval workflow with automatic validation of the attached file’s layout and business rules, eliminating the approval of out-of-standard files; a second form to request periodic consolidation, with filter criteria by period, approver and status; and an automatic consolidation routine that reads the Excel files from approved tickets, extracts the data, generates a single consolidated file, and emails it directly to the requester.
The result. Faster approval cycle, standardized input format, full traceability of who approved what and when, and the end of manual spreadsheet consolidation.
Clients by sector
Renew serves 13 clients across 7 sectors, in three countries (Brazil, Argentina and Mexico). Until formal brand-use authorization exists, clients are cited by sector:
- Automotive — the largest concentration of the portfolio, with global automakers and a manufacturer of road implements.
- Heavy industry — steel and packaging.
- Energy — a state-owned utility.
- Retail.
- Education.
- Logistics and transportation.
- Health and medical devices — dental implants.
The automotive concentration is no coincidence: it is the sector where Renew has built up the most SSC deployment experience, and where knowledge of high-volume processes and strict business rules applies with the greatest depth.