Dashboard

From Emerald Forest Hotel
Revision as of 07:47, 23 December 2020 by Vinkesteijn (talk | contribs)
Jump to navigation Jump to search

→ Go! Category:Game play
 


GAME PLAY


The Team File, which you will have a private login link to, is crucial to your team in running the hotel. In this file you will find four tabs:

  • tab preparation where you start, introduce your hotel, strategy etc.
  • tab decisions where you, after the preparation make your decisions and give explanations each year.
  • tab dashboard where you can find an overview of the most important financial results
  • tab results where you find an operating review and other details on results and costs after each year


After a year has passed, the new dashboard and the results will only 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 is a specific way: so check your competition's assignment and timeline for details.

Team sheet tabs Emerald Forest Hotel.jpg

Team sheet tabs Emerald Forest Hotel

Elements in your dashboard

The dashboard reflects the most important financial figures in any year, linked to your results. So it is an interpretation and visualization of the numbers on the tab Results.
Each hotel will get it's own private dashboard within the Team File.

In the beginning, obviously, the charts do not show much, as just one year passed. Over the years they will fill-up and show interesting developments.
Your dashboard comprises coach comment per year and nine charts.

  • Coach comments

On top of the dashboard, you will find some basic information per year as a feedback from your coach. This is just a few lines but is very important. The coach assesses the quality of your decisions, your motivation, and calculations. This is a very important variable in a calculation of your occupancy rate. The coach comments give you an impression of how your team is doing.

Feedback on your work
  • Chart 1. Sales prices and chosen team costs

Gives you an overview of the choices your hotel has made over the years. The team costs (so your five decisions on costs to be made) are x € 10,000, to make them fit within the graph. So you can see the trend in your decisions comparing price-developments and costs developments.

Dashboard chart Sales prices and chosen team costsFeedback on your work
  • Chart 2. Hotel occupancy rate (in %)

All revenues start with your occupancy rate. The starting point, as you taken over, is 50%, the benchmark would be between 60-70%. Top hotels perform above 70% occupancy rate. You can compare your results to the top hotels and benchmark. In the example, only year 1 scored very well, above average. The other years, the occupancy rate was below the starting year, the history at 50% and also below the benchmarks.

Dashboard chart 2. Hotel occupancy rate (in %)
  • Chart 3. Net profit index

The preparation, so the history year is set at 100 (index) which represents € 436,301. All year afterward are indexed towards this year. This gives you an indication of how your hotel is doing compared to results in the history. In the example, year 2 scores 60: so this year the net profit was only 60% of the profit the starting year, the history with a profit of € 431.301.

Dashboard chart 3. Net profit index
  • Chart 4. Each year's profit in total net profit

All your hotel's profit is added up (tab results, row 70). This graph reflects the contribution of each year's profit in this total. This shows you the importance of the year passed. In the example, year 2 did not contribute much, the history, year 3 and 4 have an almost equal contribution.

Dashboard chart 4. Each year's profit in total net profit
  • Chart 5. Net profit this year total profit all years

In another graph showing the profit (or loss) per year plus the total profit until this year. This shows you the importance of the year passed. So in green, the net profit in any year, and in red the total of the profit added up over all years passed.

Dashboard chart 5. Net profit this year total profit all years
  • Chart 6. Revenues - costs - profit per year

Showing the total revenues per year, the total costs per year and so, the result, the total profit per year. The green column reflects the total of the revenues, the brown column (with red line) the total of the costs. So, deducted this leaves the orange column being the profit in any year. So in year 2, the total revenues have dropped a bit, but the costs as well. So the profit is higher than in year 1.

Dashboard chart 6. Revenues - costs - profit per year
  • Chart 7. Contribution per category in year's revenues

So you can see what the most important contributors to your hotel's revenues are. In the example, you can see that the most volatility is in the revenues from Rooms weekdays. Overall the contribution of banqueting & other is stable (at circa 11%).

File:Benchmarks 2018 chart7 2.jpg
Dashboard chart 7. Contribution per category in year's revenues
  • Chart 8. Rank on total net profit

You all start off with the same hotel. After year 1 there is a ranking on profit, all the years the profit is added up giving your hotel a position in your province. In this case rank 5, 5, 4 and at the end position 4.

Dashboard chart 8. Rank on total net profit
  • Chart 9. Rank on total creativity

You all start off with the same hotel. After year 1 there is a ranking on creativity, all the years the yearly results are added up giving your hotel a position in your province. In this case rank 3, 2, 1 and at the end position 1.

Dashboard chart 9. Rank on total creativity


→ GO! Top of this page

Emerald Forest Hotel offering an emerald hotel experience! | Run your own hotel in this management simulation.