Prepare a CSV File for Program Based Business

For example, a Tier-1 tire manufacturer in the automotive industry may supply parts, assemblies, and components as part of an OEM program by a car manufacturer. The overall sales process involves close collaboration with the OEM to get their program forecasts and program variant forecasts, and identify the parts and components that can be supplied to the OEM. The Tier-1 manufacturers may rely on third party research, such as IHS Markit, which provides production schedules per vehicle per assembly.

Manufacturers can use this research data, along with data obtained through collaboration, to populate program forecasts and program variant forecasts. Program Managers can then import the forecasts data using CSV files. Create two CSV files: one for the manufacturing program forecasts, and one for the manufacturing program variant forecasts. The Data Processing Engines use the manufacturing program forecasts and manufacturing program variant forecasts to generate manufacturing program component forecasts.

Important Make sure that the CSV file includes data for all periods in the manufacturing program, otherwise the CSV upload may fail with errors.

1. Create a .CSV File
   Follow these guidelines when you prepare a .csv file for import.
2. Import Data From a .CSV File
   Import data from a .csv file into a target object. Use this data to calculate supplier component forecasts, but only after you run data processing engine templates.