Bridgestone - Budgeting for the LSCM Division
The overall objective of this project was the replacement of the reporting and budgeting process in place for LSCM (Logistics and Supply Chain Management) which is currently done in Cognos Finance. This project has enabled Bridgestone to decommission Cognos Finance Mid-2012 for this process. The project is divided into phases in line with the key milestones in the Budgeting process.
- Phase I: Setup of LSCM BPC Budget Data entry schedule for loading the Revised Budget 2012 + MTP (Mid Term Planning), including reporting
This first phase was done in about 45 mandays and went live with the revised budget cycle (RB) of 2012. The budget is mainly a cost budget (OPEX) with details on CAPEX and FTE. For this requirement, three different applications were created to allow the most efficient use of typical dimensions required for each reporting stream. For example, the dimension "Employee" is only used in the application FTE to allow for planning on FTE's. In order to have a user-friendly reporting system, the main application BUDGETING was used as a landing application from which the user can open each process (CAPEX, OPEX and FTE planning), without having to consider the three different applications by using an intelligent custom menu built in the MS Excel client of SAP BPC.
- Phase II: Upload of Actual Data from SAP for monthly reporting cycle – interaction with SAP Business Warehouse.
After the revised budget phase, the application is extended to use it on a monthly basis. As the FTE information on actual data is not immediately available in SAP back-end, this application received data entry schedules to allow actual data entry of FTE's. For the OPEX, the data is loaded from the SAP back-end by adding a DSO under the SAP BPC Multiprovider in BW. This phase was done in 12 mandays.