Operational property planning in the real estate industry 

with alstria

better decisions group GmbH | Alstria 2 11

alstria and bdg develop a solution for operational planning of leasing assumptions, action planning and P&L in Board.

The alstria office REIT-PLC previously used Excel datasheets for operational planning: There was a separate Excel template for each of the more than 100 real estate properties, which was manually filled with the planning inputs. In addition, access to master data (e.g. portfolio contracts, vacancies), which serve as basic information for the planners, was only possible through exports from the previous systems. The enormous manual effort in Excel led to a high error rate, and combining and evaluating the data of all properties was enormously time-consuming.

As a REIT (Real Estate Investment Trust), alstria is also subject to strict regulations in planning and reporting – the Controlling department therefore discussed the introduction of a modern BI solution. To support the project, alstria engaged external consultants (PwC). Together they developed an initial catalogue of requirements and began the selection process. In the process, the software board with bdg as implementation partner was compelling – the decisive factors were the software’s possibilities in the area of self-service BI, its flexibility and speed of evaluation as well as bdg’s references from successfully completed projects in the housing industry.

With the introduction of Board, we have a much more efficient and transparent building planning process. The manual effort and thus the susceptibility to errors are reduced to a minimum, which results in a high-quality reporting structure. Due to automated planning steps and the dynamic creation of analyses, the time required is very low and the tool has a high level of acceptance among colleagues in the operational area.

PROJECT OBJECTIVE

The primary goal of the project was to completely replace Excel as a planning tool with a solution in Board in order to reduce the manual effort and error-prone media breaks to a minimum and to generally simplify the work of the operative planners. The reporting for the areas of letting assumptions, action planning and P&L was also to be made more dynamic and clearer. The planning of letting assumptions (extended and new tenancy agreements), the necessary construction measures (refurbishment, modernisation, maintenance) with the associated costs and the associated data from contracts were first to be collected and then integrated at a higher level. The next objective was to map all data in a profit and loss account and to prepare it for financial analysis for each property.

Read the whole story now

And find out all about the highlights:

  • Agile development of an operational planning solution
  • Five input templates replace over one hundred Excel datasheets

  • Improved quality of planning, reporting and analysis with a significant reduction in time expenditure

  • Cooperative collaboration and high commitment to the success of the project

better decisions group GmbH | bdg success story lesen
better decisions group GmbH | Alstria 2 12

About alstria

alstria office REIT-PLC is a German public limited company with its registered office in Hamburg. The company has been operating under the legal form of a REIT (Real Estate Investment Trust) since 2007 and was the first PLC of its kind in Germany. alstria owns and manages a high-quality portfolio of office properties in major German office centres. As a long-term oriented company, alstria manages the properties over their entire life cycle: from acquisition to leasing, ongoing management, modernisation and possible sale. A detailed concept is developed for each individual building, and modernising the properties is an essential part of the business model in order to create consistent value.

IndustryRegionApplicationNumber of users
Real EstateHamburg, GermanyControlling/Real Estate Operations90

EXPLORE MORE SUCCESS STORIES

Beitragsbild Success Story KFC

Restaurant planning at KFC

Good planning is crucial for business success. This is especially true in the fast-food business, where speed of response and quick adaptation to changing consumer trends are essential. As the business grew, so did KFC’s restaurant planning requirements, which meant that the Excel-based planning system was soon unable to keep pace with growth and needed to be replaced with a more powerful solution.

Beitragsbild EOS Success Story

Lean management in monthly closing: Process automation in financial accounting EOS

The bdg and EOS project aimed to establish an integrated financial accounting system through automation and process optimization that minimizes manual effort, improves data consistency and reduces the susceptibility to errors. Since the performance management software Jedox was already in use in several corporate departments, the high flexibility of the application should also be used for this project and the new solution should be integrated into the existing application landscape.

Beitragsbild Success Story Strato

Driver-based Profit and Loss Account with STRATO

STRATO and bdg jointly developed the concept for the implementation of a BI/CPM solution for controlling. Board was chosen as the software; the intuitive and user-friendly design of the application was particularly decisive, enabling it to be used as a self-service BI.

Available in 5 locations 

Select your location