Difference between revisions of "Operating review"

From Emerald Forest Hotel
Jump to navigation Jump to search
 
(243 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[[Category:Hotel info]] __NOTOC__ __NOEDITSECTION__
[[Category:Hotel info]]  
''→ Go! [[:Category:Hotel info]]'' <br>
''→ Go! [[:Category:Hotel info]]'' {{Running Game}} __NOTOC__ __NOEDITSECTION__
{{Running competition}}


== What can you do? ==__NOEDITSECTION__
== All results ==
In the game you have a number of possibilities to influence your hotel.
The annual results (operating review) of your hotel, will be created ''automatically'' by the accountant at the end of each year. You just have to analyse the results, you do not have to calculate them yourselves. Of course, when making decisions and incurring costs, you will make some assumptions and calculations predicting occupancy and profit. After each year ends, they will be ready for you via your secret Team File link.  
* This platform on which you have a [[teampage]] (for instance 06NL-A01). On this teampage you present your strategy and for instance the links to your social media. Anyone can read all on this platform. Only after loging-in you can edit your own teampage.
* The social media (which you link to your teampage)where you can communicate with different targetgroups
* Other live actions of your team: sometimes required, like the Trade Fair but maybe also your own initiative.
* The secure section: only accessible with your private link, any hotel has its own code. In this secure section your hotel has its own [[teamsheet]] with:
** a [[decisions]] section to make financial choices each year
** the [[explanations form]], decision number 14 in which you explain your financial decisions each year: very important.
** the '''results''' section where your hotel finds its results ''after'' each year, after this has been released by your coach.  


A version of the teamsheet with decisions and results as example is available at
The results presented there will be divided into three parts:
[https://docs.google.com/spreadsheet/ccc?key=0Ah_nJphUpAz1dGwya2Y2a1VjTmRweGF4alZpTi14YUE&usp=drive_web#gid=0 example teamsheet team Z01] <br>
* Section [[Operating review]], found on the operating review page with all your revenues and costs resulting in your net profit (or loss). We'll dive into this now.
You can not edit this example. <br>
* Your personal [[key metrics]].  
The requested explanantions form for this demo-team Z01 - not filled out - is available at:
* [[Market research]], if your team decides to pay for this in advance.  
[https://docs.google.com/document/d/1ACCYeZVYe1wt4OBcU8_iDtPmFUmZf2VXBmgyk_hAOgY/edit example team Z01 explanations]


We know look at the financial results you will get each year as ell as the gameplay mark and some coach comment.
== Operating review ==
An operational review is an in-depth look at the big picture, summarizing the financial effects of your management choices: costs, revenue and results.<br> The results in this overview will be made automatically depending on
* your evaluations by your coach (so the quality of your arguments)
* your competitors 
* your decisions
The occupancy rate is the crucial element in all this. The total overview will be visible in your Team File after each year <br>
In the administration of Emerald Forest Hotel, as we use it, no [[VAT]] Value Added Tax is applicable. That is, not in the revenues, neither on the cost side. Furthermore, there is no record of the [[liquidity]], balance sheets (opening nor end of the year) nor an investment overview. We consider the revenues and the costs to be without any VAT, and all revenues and costs to be paid at the date they occurred; there is no debtors or creditors.  


== All results ==__NOEDITSECTION__
== Revenue ==
The results of your hotel will be calculated automatically by the accountant of your hotel. You just have to analyse the results, you do not have to calculate them yourselves. After each year they will be ready for you in the secure section which is only accessible through your secret link.
The hotel distinguishes three main types of revenue.
Your results presented there will be divided into the next parts:
* The results, the operating review with
** The Revenues
** The Costs: divided in costs fixed, costs variable and costs of your team's [[decisions]]
** Net profit
* The elements [[Key metrics]], [[Top Research|Market information from Top Research]] and [[Short commend]] of your coach are explained in separate pages.


== Operating review ==__NOEDITSECTION__
*''Room revenues'' comprise the average (sales) prices the hotel management [[Decisions|decided to choose]], times the number of booked rooms (occupancy rate). <br>
''Please take into account that your hotel has 364 days (not 365) and some figures are rounded.<br>''<br>
*''F&B revenues'': All food and beverage are considered to be incurred by these hotel guests, so the higher the occupancy rate, the more revenue the hotel gets from food and beverage.<br>
At the end of each year you will find, in the secure section, in the tab ''Results'' your operating review. Your team (and your coach) are the only ones who can see these results. If a year has passed, you will see your results, as soon as they have been released by your coach.  
*''Banqueting and other revenues'' are a separate revenue unit in the hotel. Previous sales prices of banqueting arrangements, varied from a minimum of € 25 to a maximum of € 30 per person. On the [[Banqueting]] page, you can find  more information, pictures, and videos on banqueting. The 'other revenues' in this group are additional sales, such as bike rental, upgrades, cancellation fees, etc. Altogether, this is a bit more than 8% of the total revenues. <br><br>


You do not have to calculate anything in this operating review yourselves. You only take the decisions and the rest is automatically calculated for you. An algorithm calculates your occupancy rate depending on your decisions, your coach's mark (related to the quality of your explanations) and other elements. Depending on your occupancy rate, you'll get more food & beverage and other revenues as well. <br>
[[Image:results_revenues_2021_new.jpg|thumb|600px|center|    <center>''Revenues overview year 0 and example of the other four years. <br> We now focus on year 0: at the time you take over.''</center>]]<br>


All the fixed and variable costs will automatically be calculated related to your occupancy rate and your decisions. The costs of your team choices will also be automatically brought to your operating review and will be visible here as well. So the operating review brings you the financial results of your hotel.
Below you'll find an overview which gives more insights into the revenue structure, as far as information is available in the hotel's administration. This all reflects the year before you take over; the year 0 will be your starting position, and the other years just give you an indication of what might happen. The operating review will be created for you, by the accountant: It will be visible (in due time) on the results tab in your Team File.<br><br>
 
== Revenues ==__NOEDITSECTION__
Revenues consist of the average (sales) prices times the number of booked rooms (occupancy rate). You can influence the prices, because you set them, while the occupancy rate is defined by all of your decisions and your explanations: the mark the coach gives to you for your performing as a team is influenced heavily by this. The maximum occupancy rate would mean all 100 rooms occupied during all days, so 52 weeks x 100 rooms x 7 days = 36.400 room nights. Check the next pages for detailed information on this.
* [[leisure targetgroup]]
* [[business targetgroup]].
 
All food and beverages are considered to be caused by these guests: so the higher the occupancy rate, the more revenues you get from food and beverages.<br>
Banqueting is a totally separated unit in the hotel. The sales prices in the past varied from a minimum of €25 to a maximum of €30 per person. You decide on the price of banqueting, so you do have some control. This gives you an indication: on the [[Banqueting]] page you can find some more info, pictures and videos on banqueting.
 
[[Image:results_revenues.jpg|thumb|600px|center|    <center>''Revenues overview in the last year.''</center>]]
 
The above situation is just an example of the revenues as they will be shown in the complete operating review. So this example shows the history (column B, year0) which is the same for all teams as they start. After each year the next column (so the next year) will be available and filled out automatically. In this example this is just year 1 in column C. In the example all years have been filled out.
 
Underneath you'll find an overview which gives some more insights into the revenue structure, as far as information is available in the Bergman's administration. This all reflects the year before you take over, this will be your starting position.


<center>
<table border=1 cellpadding=8>
<table border=1 cellpadding=8>
<tr><th>Revenues History</th></tr>
<tr><th>Revenues Year 0</th><td>'''Source'''</td><td>'''Amount'''</td><td>'''Percentage'''</td><td>'''Sub total'''</td></tr>
<tr><td>Rooms</td><td> Rooms revenues weekend</td><td> € 704.340</td><td> 24,56%</td></tr>
<tr><td>&nbsp;Rooms</td><td>&nbsp;Room revenue weekend</td><td>&nbsp;704,340</td><td>&nbsp;24.61%</td><td></td></tr>
<tr><td></td><td> Rooms revenues weekdays</td><td> € 1.244.880</td><td> 43,42%</td><td> 67,98%</td></tr>
<tr><td></td><td>&nbsp;Room revenue weekdays</td><td>&nbsp;1,244,880</td><td>&nbsp;43.49%</td><td>&nbsp;68.10%</td></tr>
<tr><td>Food and beverage</td><td> F&B revenues weekend</td><td> € 266.080</td><td> 9,28%</td></tr>
<tr><td>&nbsp;Food and beverage</td><td>&nbsp;F&B revenue weekend</td><td>&nbsp;266,080</td><td>&nbsp;&nbsp;9.29%</td><td></td></tr>
<tr><td></td><td> F&B revenues weekdays</td><td> € 414.960</td><td> 14,47%</td><td> 23,75%</td></tr>
<tr><td></td><td>&nbsp;F&B revenue weekdays</td><td>&nbsp;414,960</td><td>&nbsp;14.49%</td><td>&nbsp;23.78%</td></tr>
<tr><td>Banqueting</td><td> Banqueting revenues</td><td> € 100.123</td><td> 3,49%</td><td> 3,49%</td></tr>
<tr><td>&nbsp;Banqueting & other revenue&nbsp;</td><td>&nbsp;Banqueting and other revenue&nbsp;</td><td>&nbsp;231,636</td><td>&nbsp;&nbsp;8.09%</td><td>&nbsp;&nbsp;8.09%</td></tr>
<tr><td>Other revenues</td><td> Other revenues</td><td> € 136.519 </td><td> 4,76%</td><td> 4,76%</td></tr>
<tr><td>&nbsp;'''Total revenue'''</td><td> </td><td>&nbsp;'''€ 2,861,896''' </td><td>&nbsp;'''100%'''</td><td>&nbsp;'''100%'''</td></tr>
<tr><td>'''Total revenues'''</td><td> </td><td> '''€ 2.866.902''' </td><td> '''100%'''</td><td> '''100%'''</td></tr>
</table>
</table><br>
</center><br>
 
== All costs ==
== Operating review costs ==__NOEDITSECTION__
The situation below is just an example of the cost projections for the coming four years. Again, the situation when you take over is the year 0: You cannot influence the costs and prices of year 0.<br><br>
The situation below is just an example of the costs as they will be shown in the final operating review. So this example shows year0 (column B) which is the same for all teams and as you take over. After each year the next column (so the next year) will be available and filled out automatically. In this example this is just year 1 in column C.
 
[[Image:results_costs.jpg|thumb|600px|center|    <center>''Costs as shown after all of the years.''</center>]]


Underneath you'll find an overview which gives further insights into the cost structure as far as information is available in the Bergman's administration. This all reflects the situation as you take over, this will be your starting position. So this is all about year 0.
[[Image:results_costs_2021_03.jpg|thumb|600px|center|    <center><i> Costs overview during the starting year 0 and example of the next four consecutive years.<br> We will focus on year 0 now.''</i></center>]]<br>


Below you'll find an overview which gives further insights into the cost structure as far as information is available in the Bergman's administration. This reflects the situation as you take over, and will be your starting position. Note that the cost of Management Team Decisions are missing in the relevant year 0. The four years in the example give an impression how these decisions could influence the operating review. For now, in year 0, as you take over, the costs: Management Team Decisions are all zero. These decisions are, what has been lacking the last few years: You cannot do without any longer.<br><br>
<center>
<table border=1 cellpadding=8>
<table border=1 cellpadding=8>
<tr><th>'''Costs'''</th></tr>
<tr><th>&nbsp;'''Costs in year 0'''</th><td>'''Source'''</td><td>'''Amount'''</td><td>'''Percentage'''</td><td>'''Sub total'''</td></tr>
<tr><td>'''Costs: fixed'''</td><td> Depreciation costs of existing assets</td><td> € 525.187</td><td> 34,64%</td></tr>
<tr><td>&nbsp;'''Costs: fixed'''</td><td>&nbsp;Depreciation costs of existing assets&nbsp;</td><td>&nbsp;€ 525,187</td><td>&nbsp;34.64%</td><td></td></tr>
<tr><td></td><td> fixed staff costs </td><td> € 550.271</td><td> 36,29%</td></tr>
<tr><td></td><td>&nbsp;Fixed staff costs </td><td>&nbsp;€ 550,271</td><td>&nbsp;36.29%</td><td></td></tr>
<tr><td></td><td> costs of premises</td><td> € 390.473</td><td> 25,75%</td></tr>
<tr><td></td><td>&nbsp;Costs of premises</td><td>&nbsp;€ 390,473</td><td>&nbsp;25.75%</td><td></td></tr>
<tr><td></td><td> insurance & interest costs</td><td> € 50.012</td><td> 3,29%</td></tr>
<tr><td></td><td>&nbsp;Insurance & interest costs</td><td>&nbsp;&nbsp;50,012</td><td>&nbsp;03.29%</td><td></td></tr>
<tr><td>'''Total fixed costs'''</td><td></td><td> '''€  1.515.943'''</td><td> '''100%'''</td><td> '''62,36%'''</td></tr>
<tr><td>&nbsp;'''Total fixed costs'''</td><td></td><td>&nbsp;'''€  1,515,943'''&nbsp;</td><td>&nbsp;'''100%'''</td><td>&nbsp;'''62.36%'''</td></tr>
<tr><td>'''Costs: variable'''<td> variable staff costs</td><td> € 355.170</td><td> 38,95%</td></tr>
<tr><td>&nbsp;'''Costs: variable'''<td>&nbsp;Variable staff costs</td><td>&nbsp;€ 355,170</td><td>&nbsp;38.95%</td><td></td></tr>
<tr><td></td><td> laundry costs</td><td> € 118.390</td><td> 12,94%</td></tr>
<tr><td></td><td>&nbsp;Laundry costs</td><td>&nbsp;€ 118,390</td><td>&nbsp;12.94%</td><td></td></tr>
<tr><td></td><td> cleaning costs</td><td> € 236.780</td><td> 25,88%</td></tr>
<tr><td></td><td>&nbsp;Cleaning costs</td><td>&nbsp;€ 236,780</td><td>&nbsp;25.88%</td><td></td></tr>
<tr><td></td><td> f&b purchase costs</td><td> € 204.312</td><td> 22,33% </td></tr>
<tr><td></td><td>&nbsp;F&B purchase costs</td><td>&nbsp;€ 204,312</td><td>&nbsp;22.33% </td><td></td></tr>
<tr><td>'''Total variable costs'''</td><td></td><td> '''€ 914.652''' </td><td> '''100%'''</td><td>'''37,63%'''</td></tr>
<tr><td>&nbsp;'''Total variable costs'''</td><td></td><td>&nbsp;'''€ 914,652''' </td><td>&nbsp;'''100%'''</td><td>&nbsp;'''37.63%'''</td></tr>
<tr><td>'''Costs: team decisions'''</td><td> marketing expenses</td><td> € 0</td><td> 0,00%</td></tr>
<tr><td>&nbsp;'''Costs: Management Team Decisions'''</td><td>&nbsp;Marketing costs</td><td>&nbsp;€ 0</td><td>&nbsp;00.00%</td><td></td></tr>
<tr><td></td><td> extra staff rewarding expenses</td><td> € 0</td><td> 0,00%</td></tr>
<tr><td></td><td>&nbsp;Staff development costs</td><td>&nbsp;€ 0</td><td>&nbsp;00.00%</td><td></td></tr>
<tr><td></td><td> extra depreciations</td><td> € 0</td><td> 0,00%</td></tr>
<tr><td></td><td>&nbsp;Extra depreciation costs</td><td>&nbsp;€ 0</td><td>&nbsp;00.00%</td><td></td></tr>
<tr><td></td><td> environmental expenses</td><td> € 0</td><td> 0,00%</td></tr>
<tr><td></td><td>&nbsp;Market research costs</td><td>&nbsp;€ 0</td><td>&nbsp;00.00%</td><td></td></tr>
<tr><td></td><td> additional maintenance expenses</td><td> € 0</td><td> 0,00%</td></tr>
<tr><td></td><td>&nbsp;Other costs</td><td>&nbsp;€ 0</td><td>&nbsp;00.00%</td><td></td></tr>
<tr><td></td><td> market research expenses</td><td> € 0</td><td> 0,00%</td></tr>
<tr><td>&nbsp;'''Total Management Team decisions costs'''</td><td></td><td>&nbsp;'''€ 0''' </td><td>&nbsp;'''100%'''</td><td>&nbsp;'''00.00%'''</td></tr>
<tr><td></td><td> other expenses</td><td> € 0</td><td> 0,00%</td></tr>
<tr><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>'''Total team choices costs'''</td><td></td><td> '''€ 0''' </td><td> '''100%'''</td><td> '''0,00%'''</td></tr>
<tr><td>&nbsp;'''Total all costs'''</td><td></td><td>&nbsp;'''€ 2,430,595'''&nbsp;</td><td>&nbsp;</td><td>&nbsp;'''100%'''</td></tr>
<tr><td></td><td></td><td></td></tr>
</table>
<tr><td>'''Total all costs'''</td><td></td><td> '''€ 2.430.595''' </td><td>'''€ 2.430.595''' </td><td> '''100%'''</td></tr>
</center><br>
</table><br>
More info on costs:
 
* the [[fixed costs]] have stayed the same during all four years; the fixed depreciation costs are one of them. You can not influence them and they are calculated automatically. The logic is also explained in your Team File when you do a mouse-over of the cost group.
The different costs groups are all mentioned in the operating review table above.
* the [[variable costs]] depend on the occupancy rate; for example laundry; the more rooms occupied the more laundry there is. They are automatically influenced by the [[occupancy rate]] and calculated automatically. The logic is also explained in your Team File when you do a mouse-over of the cost group.
 
* the [[Costs Management Team Decisions]], will depend on the [[Year 1-2-3-4|Year 1-2-3-4 decisions]] made by the new Management Team. So, this is totally up to your Team, within [[decisions|boundaries]] to prevent you from doing very illogical things
* Costs: fixed
You can't influence these costs. These are costs which will be created no matter what the occupancy rate is. Over the years there can be small fluctuations, but the amounts will stay almost the same.<br>
 
-Depreciation going concern: depreciations of all the assets especially the building and the inventory. <br>
-Fixed staff costs: staff needed to run the hotel and which have to be paid even if there are no guests at all. <br>
-Costs of premises: costs of maintenance, repairs small adaptions to the building and the parking lots.<br>
-Insurance & interest costs: costs for insurance for staff, building an liability ans costs for mortgage and other loans. <br>
 
* Costs: variable
The variable costs will depend on the actual number of guests in the hotel so will only be filled out (automatically) after each year is finished. So there is a ratio between occupancy rate and all of these costs.
-Variable staff costs: the more guest you have the more work here will be to be done and the more staff is needed. So additional costs. <br>
-Laundry costs: the more guest the more towels, bed linnen etc. needed.<br>
-Cleaning costs: rooms need to be cleaned more often because of more guest and to be cleaned better.<br>
-F&B purchase costs: more guest mans more breakfasts etc. for guest and more f&b for additional staff so the purchase costs go up.<br>
 
* Costs: team decisions
Of your 14 [[decisions]] number 7 -13 lead directly to expenses which can be seen directly at the costs. The are directly connected to the choices you make in your [[decisions]] each year. As you can see in the past there were no expenses on these decisions. Of course this was good for the profit but it will come back like a boomerang! So Christina urges you to use this team costs group team decisions in an efficient way, though she knows this will probably lower the profit!
 
== Net profit ==__NOEDITSECTION__
The total costs will be deducted from the revenues. If there is a bonus or a fine this is added or deducted from the profit leading to the net profit. There is no VAT or other taxes in the city.
 
[[Image:results_profit.jpg|thumb|600px|center|   <center>''Net profit in year0 as you take over.''</center>]]
 
In this case
-Total revenues were € 2.866.902<br>


-Total costs € 2.430.595<br>
== Net profit ==
-Net profit € 436.307<br>
Of course, the net profit per year is very interesting. The total costs will be deducted from the total revenues. If there is a bonus (something which turned out much better than expected) or a fine (e.g., tax), this is added or deducted from the profit leading to the net profit. <br><br>
-There is a bonus in this case so € 50.000 is added<br>
-Net profit € 486.307<br>


So the net profit seems to be 32,8% of the revenues, a good and very interesting result. <br>
[[Image:results_profit_2023_01.jpg|thumb|600px|center|    <center>''Net profit as you take over in grey 'year 0' column, plus examples in the following years; year 4 is not completed.<br> We will focus on year 0 now.</center>]]
But, the management did not make enough [[investments]] over the recent years, so the depreciation costs have been kind of low. There is no problem with liquidity at all. <br>
Furthermore the [[Bergman family|Bergmans]] did not really consider themselves to be staff, so there are hardly any wages for them in the staff costs. Their income mainly originated from the net profit which they, partly, took out of the company, being the entrepreneurs.


== Gameplay mark and coach comment == __NOEDITSECTION__
In this example, upon taking over: <br>
Each year you will find the [[mark|gameplay mark]] of that specific year in your teamsheet. This gives you an indications on how your coach thinks your are running the hotel, taking all into account (row 70). In this case gameplay mark for the first year (year0) was 6,0 which is an average result on the scale of ten.
- Total revenue was € 2,873,406<br>
- Total cost was € 2,434,417<br>
- Fine € 50,000<br>
- Net profit € 388,989<br><br>
The operating review shows the profit in any individual year and the total of net profit (all years added up). Again, in the example a number of predictions for future additional costs have been made. More on this on the [[Net profit]] page.


[[Image:gameplay mark.jpg|thumb|750px|center|    <center>''Your gameplay mark per year.''</center>]]
== Key metrics ==
Some key metrics and ratios for hotel operations: <br><br>
[[Image:key metrics 2021.jpg|thumb|600px|center|    <center>''Key metrics of year 0 as the new Management Team takes over. <br> We will focus on year 0 now.''</center>]]
More on this on the [[Key metrics]] page, as well as on the [[ratios]] and [[benchmarks]] pages.


At the bottom of your teamsheets - result tab (row 164) you will find a few keywords from your coach on your performance.  
== Analysis ==
So the net profit upon taking over, in the example above, seems to be 15.07% of the revenue, with 84.93% being costs. This seems to be a good and interesting result, but it is up to you to put this in (a real) perspective of the industry. Because management did not make enough [[investments]] over the recent years, depreciation costs have been rather low. There is no problem with liquidity at all. <br>
Furthermore, the [[Bergman family|Bergmans]] did not really consider themselves to be staff, so there have been hardly any wages for them in the staff costs, which distorts the numbers. Their income mainly originated from the net profit which they, partly, took out of the company, being the entrepreneurs.


[[Image:gameplay_commend.jpg|thumb|750px|center|    <center>''Some keywords of your coach in each year.''</center>]]
== More numbers ==
Check [https://setupmyhotel.com/train-my-hotel-staff/front-office-training/187-fixed-cost-and-variable-cost-in-hotels.html basic set-up of costs groups] in hotels to have some reference on the numbers. <br>
Of course, any situation is different, any time frame (think of the [[Covid]] period), the ownership, the state (quality)  of the premises etc. The file, though, might give some ideas from a calculation perspective. 


<br><hr>
== Past ==
When your assignment is managing one of the new establishments, these will be the benchmarks you start with, and you refer to. So, you will start in your new venue, as a point of reference, with all the same set-up of costs and decisions as in the past. At the time you take your own decisions, you can roll out your new ideas, and concepts in full.
<br><br>


''→ Go! Following the Introduction to the Hotel? Step 10/10 is the page [[Staff|Staff page, click here.]]''
<hr>
''→ GO! [[#top|Top of this page]]''
''→ GO! [[#top|Top of this page]]''
<center><small>''Emerald Forest Hotel'' offering an <font color="green">'''emerald''' </font color="green">hotel experience!
<center><small>''Emerald Forest Hotel'' offer an <font color="green">'''emerald''' </font color="green">hotel experience!
| Run your own hotel in this management simulation.</small></center>
| Run your own hotel in this management simulation.</small></center>

Latest revision as of 15:33, 10 September 2023

→ Go! Category:Hotel info  

All results

The annual results (operating review) of your hotel, will be created automatically by the accountant at the end of each year. You just have to analyse the results, you do not have to calculate them yourselves. Of course, when making decisions and incurring costs, you will make some assumptions and calculations predicting occupancy and profit. After each year ends, they will be ready for you via your secret Team File link.

The results presented there will be divided into three parts:

  • Section Operating review, found on the operating review page with all your revenues and costs resulting in your net profit (or loss). We'll dive into this now.
  • Your personal key metrics.
  • Market research, if your team decides to pay for this in advance.

Operating review

An operational review is an in-depth look at the big picture, summarizing the financial effects of your management choices: costs, revenue and results.
The results in this overview will be made automatically depending on

  • your evaluations by your coach (so the quality of your arguments)
  • your competitors
  • your decisions

The occupancy rate is the crucial element in all this. The total overview will be visible in your Team File after each year
In the administration of Emerald Forest Hotel, as we use it, no VAT Value Added Tax is applicable. That is, not in the revenues, neither on the cost side. Furthermore, there is no record of the liquidity, balance sheets (opening nor end of the year) nor an investment overview. We consider the revenues and the costs to be without any VAT, and all revenues and costs to be paid at the date they occurred; there is no debtors or creditors.

Revenue

The hotel distinguishes three main types of revenue.

  • Room revenues comprise the average (sales) prices the hotel management decided to choose, times the number of booked rooms (occupancy rate).
  • F&B revenues: All food and beverage are considered to be incurred by these hotel guests, so the higher the occupancy rate, the more revenue the hotel gets from food and beverage.
  • Banqueting and other revenues are a separate revenue unit in the hotel. Previous sales prices of banqueting arrangements, varied from a minimum of € 25 to a maximum of € 30 per person. On the Banqueting page, you can find more information, pictures, and videos on banqueting. The 'other revenues' in this group are additional sales, such as bike rental, upgrades, cancellation fees, etc. Altogether, this is a bit more than 8% of the total revenues.

Revenues overview year 0 and example of the other four years.
We now focus on year 0: at the time you take over.


Below you'll find an overview which gives more insights into the revenue structure, as far as information is available in the hotel's administration. This all reflects the year before you take over; the year 0 will be your starting position, and the other years just give you an indication of what might happen. The operating review will be created for you, by the accountant: It will be visible (in due time) on the results tab in your Team File.

Revenues Year 0SourceAmountPercentageSub total
 Rooms Room revenue weekend € 704,340 24.61%
 Room revenue weekdays € 1,244,880 43.49% 68.10%
 Food and beverage F&B revenue weekend € 266,080  9.29%
 F&B revenue weekdays € 414,960 14.49% 23.78%
 Banqueting & other revenue  Banqueting and other revenue  € 231,636  8.09%  8.09%
 Total revenue  € 2,861,896  100% 100%


All costs

The situation below is just an example of the cost projections for the coming four years. Again, the situation when you take over is the year 0: You cannot influence the costs and prices of year 0.

Costs overview during the starting year 0 and example of the next four consecutive years.
We will focus on year 0 now.


Below you'll find an overview which gives further insights into the cost structure as far as information is available in the Bergman's administration. This reflects the situation as you take over, and will be your starting position. Note that the cost of Management Team Decisions are missing in the relevant year 0. The four years in the example give an impression how these decisions could influence the operating review. For now, in year 0, as you take over, the costs: Management Team Decisions are all zero. These decisions are, what has been lacking the last few years: You cannot do without any longer.

 Costs in year 0SourceAmountPercentageSub total
 Costs: fixed Depreciation costs of existing assets  € 525,187 34.64%
 Fixed staff costs  € 550,271 36.29%
 Costs of premises € 390,473 25.75%
 Insurance & interest costs €  50,012 03.29%
 Total fixed costs € 1,515,943  100% 62.36%
 Costs: variable Variable staff costs € 355,170 38.95%
 Laundry costs € 118,390 12.94%
 Cleaning costs € 236,780 25.88%
 F&B purchase costs € 204,312 22.33%
 Total variable costs € 914,652  100% 37.63%
 Costs: Management Team Decisions Marketing costs € 0 00.00%
 Staff development costs € 0 00.00%
 Extra depreciation costs € 0 00.00%
 Market research costs € 0 00.00%
 Other costs € 0 00.00%
 Total Management Team decisions costs € 0  100% 00.00%
 Total all costs € 2,430,595   100%


More info on costs:

  • the fixed costs have stayed the same during all four years; the fixed depreciation costs are one of them. You can not influence them and they are calculated automatically. The logic is also explained in your Team File when you do a mouse-over of the cost group.
  • the variable costs depend on the occupancy rate; for example laundry; the more rooms occupied the more laundry there is. They are automatically influenced by the occupancy rate and calculated automatically. The logic is also explained in your Team File when you do a mouse-over of the cost group.
  • the Costs Management Team Decisions, will depend on the Year 1-2-3-4 decisions made by the new Management Team. So, this is totally up to your Team, within boundaries to prevent you from doing very illogical things

Net profit

Of course, the net profit per year is very interesting. The total costs will be deducted from the total revenues. If there is a bonus (something which turned out much better than expected) or a fine (e.g., tax), this is added or deducted from the profit leading to the net profit.

Net profit as you take over in grey 'year 0' column, plus examples in the following years; year 4 is not completed.
We will focus on year 0 now.

In this example, upon taking over:
- Total revenue was € 2,873,406
- Total cost was € 2,434,417
- Fine € 50,000
- Net profit € 388,989

The operating review shows the profit in any individual year and the total of net profit (all years added up). Again, in the example a number of predictions for future additional costs have been made. More on this on the Net profit page.

Key metrics

Some key metrics and ratios for hotel operations:

Key metrics of year 0 as the new Management Team takes over.
We will focus on year 0 now.

More on this on the Key metrics page, as well as on the ratios and benchmarks pages.

Analysis

So the net profit upon taking over, in the example above, seems to be 15.07% of the revenue, with 84.93% being costs. This seems to be a good and interesting result, but it is up to you to put this in (a real) perspective of the industry. Because management did not make enough investments over the recent years, depreciation costs have been rather low. There is no problem with liquidity at all.
Furthermore, the Bergmans did not really consider themselves to be staff, so there have been hardly any wages for them in the staff costs, which distorts the numbers. Their income mainly originated from the net profit which they, partly, took out of the company, being the entrepreneurs.

More numbers

Check basic set-up of costs groups in hotels to have some reference on the numbers.
Of course, any situation is different, any time frame (think of the Covid period), the ownership, the state (quality) of the premises etc. The file, though, might give some ideas from a calculation perspective.

Past

When your assignment is managing one of the new establishments, these will be the benchmarks you start with, and you refer to. So, you will start in your new venue, as a point of reference, with all the same set-up of costs and decisions as in the past. At the time you take your own decisions, you can roll out your new ideas, and concepts in full.

→ Go! Following the Introduction to the Hotel? Step 10/10 is the page Staff page, click here.


→ GO! Top of this page

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