Robinson Club, LLC
What used to be a time-consuming process of data collection and preparation is no longer an issue for ROBINSON. Theintegrated reporting and planning solution enables straightforward ad hoc analyses, consistent standard reporting, and efficient planning across the entire company. This saves time, minimizes errors, and improves the quality of planning.
The Company: Premium Club Vacations
ROBINSON Club GmbH, a subsidiary of TUI AG based in Hanover, is Germany’s quality and market leader in the premium segment for club vacations. Its portfolio currently includes 26 club resorts in 15 countries with a capacity of 16,000 beds.
ROBINSON offers families, couples, and solo travelers a wide variety of vacation options in a welcoming atmosphere, including sports, wellness, entertainment, golf, and the ROBY CLUB for children.
The facts at a glance:
✓ Significant time savings
✓ Error rate reduced to a minimum and planning quality significantly improved
✓ Flexible ad hoc analyses
✓ Implementation of short-term measures thanks to transparency
✓ Automatic conversion to local currencies
The Challenge: Updating Reporting and Planning
With the introduction of the new Protel hotel software and plans to overhaul its entire IT infrastructure, ROBINSON wanted to update its existing reporting and planning systems. Previously, the company had been compiling all relevant data in Excel through a time-consuming manual process in order to generate the necessary reports.
Similarly, the central controlling department collected the complex and detailed planning data from the individual clubs using standardized Excel files. Modified Excel spreadsheets and the resulting opaque data made the consolidation and interpretation of the planned figures prone to errors.
ROBINSON sought to address this manual and time-consuming process by introducing a new tool that combines flexible analytics, standardized reporting, and flexible planning logic. Board more than met these requirements. The design and implementation were handled by celver consultants.
The solution: Fast and flexible ad hoc analysis and planning
At the start of the project, an analysis and design phase was conducted to catalog the required reports, key figures, metrics, and dimensions. In addition, it was determined which individuals should receive which information and when. A subsequent design phase also defined the planning process: which key figures should be used for planning, when, by whom, and how. The foundation of any reporting and planning solution is a central data warehouse, which creates a consistent data foundation. The celver consultants implemented this using Microsoft SQL Server. Using SSIS packages (SQL Server Integration Services), data from various source systems is transferred, consolidated, and verified nightly.
The now consistent data set forms the basis for standard relational reporting using Microsoft Reporting Services, as well as for the required data model, which has been implemented in the Board database. In accordance with the previous definitions, the celver consultants developed the necessary reports and analyses.
With this solution, ROBINSON’s Controlling department now has access to standardized, up-to-date daily reports. In addition, employees—from the central Controlling department all the way down to the club director—can quickly and flexibly perform ad hoc analyses at any time to review, for example, the current booking status, number of overnight stays, room occupancy, and the associated utilization rates.
The key metric “occupancy” can be analyzed and planned across up to eight different dimensions and in a wide variety of combinations. All information can be easily broken down into other dimensions—such as booking channel or guest stay dates—using a drill-down function. This ensures that no information is overlooked by the management team, and that every trend can be addressed with appropriate measures.
At the same time, decentralized planning is now carried out using a defined planning process supported by an appropriate workflow. Based on the key metric “occupancy,” individual clubs report their expected lodging revenue.
The input can be flexibly adjusted at all levels, such as room category or age group. It is worth noting that accommodation revenue is initially planned in euros and then converted into the club’s local currency using stored exchange rates. In contrast, decentralized cost planning is carried out by cost type and cost center in the local currency.
This allows for a reliable comparison of expected costs with projected revenue. As a result, timely and reliable KER analyses are now standard practice at ROBINSON. ROBINSON also uses the solution for other analyses, including in the areas of incentives and meetings, HR, and sales management.
Thanks to the integrated reporting and planning solution, ROBINSON can now access up-to-date information at any time. Short-term capacity utilization analyses across a wide range of dimensions and combinations can be generated flexibly and easily. Similarly, the Board Office add-in allows for the centralized consolidation of decentralized planning data from the clubs with just a few mouse clicks. The effort involved in manual data preparation for both reporting and planning is no longer necessary. This allows important resources to be invested in the detailed analysis of current key figures and planning data, resulting in a lower error rate, higher data quality, and significantly improved planning quality.
Required standard reports are distributed to the relevant recipients via a report subscription, ensuring that important information is made available reliably and automatically. Reliable information regarding capacity utilization and cost projections creates the foundation for business success by enabling the implementation of appropriate measures. Thus, the integrated reporting and planning solution should be viewed as a factor influencing success—a factor that gives ROBINSON a significant competitive advantage.
Your contact person
.png)
