Our Work / DHL
3 weeks of manpower
Struggling to manage a complex budget model in Excel
Managing this model in Excel was hugely cumbersome, error-prone and time consuming. It was taking a full week just to sanitize the information. The data was difficult to manipulate and comparing actual to plan, was slow and tedious. Too much time was spent crunching the numbers and too little actually analysing the data.
Excel model was a nightmare...
As the sheets got larger and larger, trying to make a simple change in the Excel model was a nightmare. It would take more than a week just to sanitize the information and even then it was difficult to compare actuals to plan.Andrew May, Managing Director, DHL Freight UK
Move from old world FP&A to technologically empowered decision making
Determine KPIs and build financial models
Miagen structured the implementation process by setting up exploratory meetings to capture key requirements and information on existing business processes. From there, financial and operational planning models were created to enable detailed analysis of costs and profits. A clear, robust financial model was designed for deployment.
Implement FP&A technology
Using the Adaptive Planning platform, Miagen developed a clear reporting hierarchy and a multidimensional chart of accounts. Moving to an automated solution had an almost immediate impact, as the level of errors reduced overnight and financial accuracy improved. Adaptive was also integrated with DHL’s ERP system, providing a central repository for all data.
Empowering the DHL team
DHL now have a clear set of KPIs, custom accounts, budget plans and rolling forecasts. The internal team are fully trained and supported on the new models and systems, empowering them with the ability to make changes on the fly, in line with strategic direction, without a dependence on external consultants.
A more empowered, more agile FP&A approach.
New approach saves 3 weeks manpower per annum
Reliable budget. Ability to understand actual against plan
Planning is much more agile
Shared accountability for FP&A
Next year will be even faster!
Implementing Adaptive Planning with Miagen saved us at least 3 weeks of manpower across 3 people. Next year will be even faster!Andrew May, Managing Director DHL Freight UK