Dashboard
Team File elements
The Team File, with a private login link, is crucial to your team in running the hotel. In this Team File you will find 4 tabs:
- tab Year 1 where you start; this is where you do the strategic choices, introduce your hotel, strategy, logo etc. We call it 'Get Ready!'
- tab Year 2-3-4-5 where you take your decisions each year and give explanations each year, after your Strategic choices in Year 1
- tab Dashboard where you can find an overview of the most important financial results and a short comment of your coach
- tab Results where you can find an operating review and other details on results and costs after each year
After a year has passed, the new dashboard and results will be visible after releasing by your coach. There is a Demo Team File you can check, with a filled out Team File at the end of an example Game.
Each competition is set-up in a specific way: so check your competition's assignments and timeline for details. You will see some 'locked' symbols on the tabs of your Team File: don't worry. On the tabs Year 1 and tab Year 2-3-4-5 you can edit in the indicated cells. Do be careful in handling the file, it is a spreadsheet.
The tabs Dashboard and Results you can never edit.
Team File tabs Emerald Forest Hotel
Elements in your dashboard
The dashboard reflects the most important financial figures in any year, linked to your results. It is an interpretation and visualization of the numbers on the tab 'Results'.
In the beginning, obviously, the charts on the dashboard do not show much information, as just one year has passed. Over the years, the charts will start showing interesting developments.
Your dashboard consists of Coach Comment per year and 9 charts.
Coach comments
On top of the dashboard, you will find some basic information per year provided by your coach. Just a few lines, but very important. The coach assesses the quality of your decisions, your motivation, and calculations. This is a very important variable in the provision of your occupancy rate. The Coach Comment gives you an impression of how your team is doing. More on this on the page Coach comment.
Underneath these comments given by your coach, you will find
- Year finished?: indicating the year is over.
- BA grade: the grade assigned by your coach each year for your business assignment.
- CA grade: the grade assigned by your coach each year for your creativity assignment.
- Bonus / Fine, when applicable you will find the amount here.
- Avg. BA grade, the average business assignment grade across all years.
- Avg. CA grade, the average creativity assignment grade across all years
All charts below this section, as well as those on the 'Results' tab, will be automatically updated each year once your coach has completed this section.
Seven Charts
These charts visualize your teams decision and results. We have a look at all seven, on the tab Dashboard undernetah the coach comments.
Chart 1: Sales prices and chosen costs of Management Team decisions
Gives you an overview of the choices your hotel has made over the years. The Management Team costs (so your 5 decisions on costs to be made) are * € 10,000, to make them fit within the graph. You can see the trend in your decisions, comparing price developments and costs developments.
Chart 2: Hotel Occupancy Rate (in %)
All revenues start with your occupancy rate. The starting point, as you take over the hotel, is 50% occupancy, the benchmark would be between 60-70%. Top hotels perform above 70% occupancy rate. You can compare your results to the top hotels and benchmarks.
Chart 3: Net Profit index
Year 1 is set at 100 (index) which represents € 431,301 the profit the moment you take over. All following years are indexed in relation to Year 1. This gives you an indication of how your hotel is doing, compared to historic results. In the example,
Chart 4: Each year's profit in total net profit
All your hotel's profit is summed (tab Results, on row 70). This graph reflects the contribution of each year's profit in the total. It shows the importance of the past year. In the example, Year 2 did not contribute much, Year 3, Year 4 and 5 have an almost equal contribution.
Chart 5: Yearly and Total Net Profit
Another graph showing the profit (or loss) per year plus the total profit until this year. In green, the net profit in any year, and in blue the total of the profit added up over all passed years.
Chart 6: Revenue - costs - profit per year
Showing the total revenue per year, the total costs per year and the total profit per year. The blue linen reflects the total of the revenue, the red line the total of the costs. This leaves the orange section being the profit in any year.
Chart 7: Category-wise contribution to annual Revenue
Here you can see the most important contributors to your hotel's revenue. In the example, you can see that the most volatility is found in the revenues from Rooms on weekdays. Overall, the contribution of banqueting & other is stable (approx. 11%).
