TNT Post (pdf)

TNT Post is part of the TNT Group which provides businesses and consumers worldwide with an extensive range of services for their mail and express delivery needs. Headquartered in the Netherlands, TNT serves more than 200 countries, employs around 161,500 people in over 60 countries worldwide and reported revenues of €11 billion for 2007. In Europe, TNT Post reaches more than 70 million households and delivers 15 billion items per year. In the Netherlands, TNT Post collects and delivers over 23 million letters, direct mail items and packages every day to over 7 million households. TNT is publicly listed on the stock exchange of Amsterdam.

Business case
TNT Post has implemented SAP BW 3.5, amongst others for the purpose of analyzing and reporting actual mailing volumes delivered, actual labor capacity required for delivery and resulting costs of labor. Budgeting of mailing volumes, labor capacity and labor costs however was executed in MS Excel and thus was decoupled from reporting and analysis. As a result, the budgeting process was laborious, moreover since budgeting data was dispersed over multiple files. Hence, a clear need developed to integrate the budgeting process in the reporting process and bring the plan data together with the historical data in one analytical application. This integrated application was intended furthermore to support the centralization of the budgeting process and to implement a uniform forecasting schema.

Solution features
A set of web-enabled budgeting applications was developed as part of the existing SAP BW3.5 solution. Consequently, budget data can now be saved directly in the corporate data warehouse, which directly enables the analytical comparison of actuals vs. budgets. This integrated solution supports a multi-step budgeting process, during which labor capacity budgets are derived from mailing volume budgets and checked against historical data. Furthermore, the integrated solution facilitates a centralized schema of budget distribution, budget revaluation, budget versioning and budget readiness reporting within the organizational structure. All-in-all, the integrated solution in SAP BW3.5 contributes to a far more time-efficient budgeting process.

Tools & technologies
SAP BW 3.5; SAP BW-BPS 3.5; SAP BEx (Business Explorer); SAP WAD (Web Application Designer); ABAP/4; SAP NetWeaver BI 7.0.

Delivery approach
For the purpose of smooth communication, which is the critical driver for successful delivery, Ozone collaborated closely with Just-BI, a SAP BI services provider in the Netherlands. Just-BI installed the project leader and the lead consultant, who remained onsite during the project at all times and who interacted closely on the business site with TNT. Ozone provided the required SAP BI consultancy skills. From time to time, our consultants teamed up with TNT and Just-BI in the Netherlands, but the major part of the integrated solution was developed, tested and implemented remotely in Minsk.

Customer references
Gabe Boer, SAP CCC Chain Specialist P2C, ICT Mail Application Services at TNT Post.
Koen Lapre, partner at Just-BI.
Contact details available upon request.

Contact Valery or Andrei
For more information about the TNT Post project reference, please get in touch and ask for Valery or Andrei.