Enabling Exacting Financial Modelling and Decision Making

Budget Airline

In an eleven-month timeframe, supported a leading budget airline through an intensive tendering process for a new contact centre partner. Key project contributions included development of financial business case including 5 years of Income Statement, financial and scenario modelling specifically around contact volumes and pricing. The modelling enabled Senior Management to control the project and ensure the financial objectives were met. The outcome was the provision of a multi-language service via a multi-geographic footprint, with improved levels of customer service and reduced costs of circa £2m per year.

 

FTSE 250 Facilities Management Company

In a two-month timescale successfully improved the monthly reporting consolidation, improving turnaround times by circa nine hours per version. This was done through standardising templates and the use of a VBA tool, facilitating the reduction of number crunching and increasing value-added analysis. In a two-month timescale built a rolling Excel planning model and process for the £100m multi-site catering division. Enabled an efficient monthly forecasting and budget process with consolidations taking circa 10 minutes and providing Senior Management with a complete and in-depth understanding of divisional performance.

 

Indian owned Multi-National Logistics Company

In a six-month timeframe, managed the whole implementation of Monthly Customer Profitability Reporting to support an IPO project within the logistics industry. Designed a new process, including the build of an Excel based Profit and Loss tool, embedding the project designs and methodology into monthly reporting and system BAU. The model enabled the preparation and consolidation of Profit and Loss Accounts for over 5,000 customer accounts, over 10 different entities and 5 divisions, for 3 Financial years. Cost Drivers were identified and used to allocate overheads to customers, enabling profitability down to EBITDA.

 

A European specialist in precast concrete sleepers, rail and infrastructure.

In a 3-month timeframe, significantly improved their overall HS2 Project financial reporting process. Key changes included, individual cost build up by products, detailed labour analysis, breakdown of costs by individual components. Income statement, Balance Sheet and Cashflow were added to enable results to be consolidated into periodic group reporting. The outcomes include the reduction of the forecast cycle from 2 months to 2 hours, the process becoming embedded into the month end process and a holistic approach to risk and cash management.

 

​