Problem Statement

Your organization has more than 25 branch offices in various countries around the world. You are requesting product forecasts from them in regular time intervals. Because every office is using different systems to store and manage their data, you will likely receive the information in different formats. Past attempts asking them to harmonize their systems did not work because the switchover costs appeared too high. Some are database exports, and others are hand-crafted Excel tables.

The Solution

• Use different short B4P program routines to read the different data from every branch office
• Automatically check for any inconsistencies, especially if data is provided in hand-made Excel sheets
• Align the data using common header names, e.g. 'Customer Name', 'Deliery Date', etc.
• Merge the data from the different sites
• Notify you if two sites start dealing with the same customer
• Consolidate and aggregate all forecast data according to your specifications
• Add formatting, colors and style to make the report easy to use
• Save the final report.