For PB Leiner, the objective of the project was to replace the existing Excel sheets used to perform the S&OP process. Based on the net demand (delta sales/forecast/stock), the monthly demand planning information is done on finished goods. They are converted in a BPC S&OP model into a weekly demand planning information on intermediates through a set of allocation rules (e.g. production blending loss, material reservation percentages, customer and production lead times). Inventory and sales data are sourced from SAP ECC while sales forecast are fetched from another BPC application. Reporting is available in both BPC (high-level) and BW Analysis for Office (drill-through).
