Case studyPharma

CAPEX: planning and reportingof project capital expenditure

Timeline: 1 month

1000

projects in various statuses
across the corporate group

4000

employees at the largest
Polish pharmaceutical company

200

Project Managers involved
in planning and forecasting

5 years

budget horizon covering
capital expenditure planning

01

Starting point

Capital expenditure was planned in Excel, which put a heavy load on headquarters and left Project Managers without up-to-date access to data.

02

Challenge

More than 1,000 projects, integration with the ERP Fixed Assets module, multiple currencies and access for 200+ Project Managers – all of this called for a structured planning and control system.

03

Business need

The company needed a web application providing up-to-date access to data and enabling reporting and forecasting of capital expenditure in multiple currencies.

Proposed solution

Moving the business processes to Fincorex® brought the entire capital expenditure planning and reporting process into one application. This covered every level – from individual invoices to aggregated reports for the whole Group.

The system was integrated with the ERP Fixed Assets module, enabling automatic import of data on capital expenditure incurred and adjustments at the mapping stage. Users gained access to unified planning forms tailored to their assigned projects and permissions. Versioning made it easy to compare different forecasts and budgets, while built-in planning rules locked or unlocked data entry depending on project status and attributes.

With support for multiple currencies within a single project, spending could be planned in the transaction currency (e.g. USD, CHF, EUR) and presented in the company and group currencies at the same time. Currency translation ran automatically, with no extra steps, which significantly sped up reporting.

The controlling team gained full control over the data, with the ability to review and filter information by company, Project Manager or project status. At the same time, more than 200 project managers received direct online access to current data, which increased their engagement and ownership of the planning process.

Results

  1. 01Central CAPEX planning platform

    With Fincorex®, users manage all investment projects in one application. The solution eliminated manual consolidation and made information consistent across the organization.

  2. 02Real-time project monitoring

    Project Managers can monitor spending, enter adjustments and analyze variances in unified forms, giving them more control over project delivery.

  3. 03Flexible multi-currency forecasting and reporting

    The system supports planning in transaction currencies, automatically translates data into reporting and group currencies, and lets users create multiple versions of budgets and forecasts, making scenarios easy to compare.

  4. 04Fast reporting and data analysis

    Integration with the ERP Fixed Assets module enables almost immediate reporting of CAPEX actuals and analysis from the whole-project level down to individual expenditure items.

  5. 05Simpler access management and version control

    The system lets you define access rights precisely per Project Manager, track changes to plans and quickly spot variances, improving data security and process transparency.

See your modelbefore you decide.

As a Proof of concept, we'll rebuild your reporting or planning model in Fincorex® and show it to you at our next meeting.