Takata is an international group which manufactures passenger protection systems. The group includes 57 manufacturing sites and 15 research and development centres located around the world. Of a total of approximately 48,000 personnel, over 15,000 are employed in Europe alone. In 2013, around 40 % of its products were sold in North America, approx. 26% in Europe and around 34 % in Asia. Takata generates sales of over six billion euros (¥ 718 billion) in 21 countries.
Status quo and objectives
Takata needed to implement a rapid switch from an existing Excel-based forecasting tool to a new Web-based solution. The aim was to set up a comprehensive and uniform group-wide cash flow forecasting tool within just a few days. Despite this short time window there were very demanding requirements in terms of forecasting transparency and accuracy. The intention was to import all accounts receivable and payable from the SAP system in order to create a basis for manual forecasting on the part of the group subsidiaries.
An extremely efficient work flow was necessary on both sides in order to keep to the tight deadline. This involved preparing Excel templates for Takata into which all of the master data had to be filled. As a result, it was possible to rapidly import companies, users and accounts into TIP. The next step was to set up a forecasting grid which corresponded to the parameters defined in the scoping phase and which was linked via the SAP interface to the SAP data pool. This created the basis for flexible data analysis which can identify forecasting deviations and enable group-wide forecasting. The simple operation of the system and the use of existing data in particular increase the quality of the data and ensure that figures are generated which are transparent, up-to-date and which can be analysed centrally.
- Implementation of a group-wide cash flow forecasting system within ten days
- A dashboard report with an overview of the financial status and forecasting as well as ten other reports for analysing group data
- High levels of acceptance among subsidiaries leading to rapid results for the group