Operating review: Difference between revisions

From Emerald Forest Hotel
Jump to navigation Jump to search
No edit summary
No edit summary
 
(229 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[[Category:Hotel info]] __NOTOC__ __NOEDITSECTION__
[[Category:Info pages]] {{Template:New Skin Box}}
''→ Go! [[:Category:Hotel info]]'' <br>
''→ Go! [[Introduction to Hotel]]''</div><br>
{{Running competition}}
{{Template:New Skin Box}}
== What can you do? ==__NOEDITSECTION__
== All results ==
In the game you have a number of possibilities to influence your hotel.
The annual results of your hotel are stated in the operating review, 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 [[Team file]] which you have a private login link to. In this file you present your strategy and the links to your web site and social media. In this file you also do all your [[explanations]] of your decisions.
* Your [[Team finances]] spreadsheet: only accessible with your private link via your Team file, any hotel has its own. None of this is visible on the platform. In this file each hotel can follow:
** tab 1 the [[decisions]] tab where you fill out your decisions on prices and expenses
*** on this page you have to confirm at decision 14 that your decisions have been accounted for in depth in your [[Team file]].
** tab 2 the [[results]] tab where your hotel finds its results after each year, only after releasing by your coach.
** tap 3 for additional calculations which can be handy in some cases.
* The social media, websites etc. (on the first page of your Team file there should be links to all your social media and website(s) used)
* Other live actions of your team: sometimes required, like the Trade Fair but maybe also at your own initiative.


A version of the Team finances is available at
The operating review consist of a number of crucial elements, whcih each have their own page:
[https://docs.google.com/spreadsheet/ccc?key=0Ah_nJphUpAz1dGxqWG1NRDZBaVNvdVVUWngtQnh4WEE example Team finances team Z01] <br>
*The overview of the [[Operating review]]
You can not edit this example. <br>
*The [[Revenues]]
The requested explanantions for this demo-team Z01 - not filled out - are part of the Team file is available at:
*The [[Costs]]
[https://docs.google.com/document/d/1GaZ0Kfi96G5l2ZEmIXc4yF2hSYxJooGeFiKkZm8BBG8/edit example team Z01 Team file part explanations]
*The [[Net profit]]
*The [[Key metrics]]
</div>


We know look at the financial results you will get each year as ell as the  and some coach comment.


== All results ==__NOEDITSECTION__
{{Template:New Skin Box}}
There are also pages on the revenues per room: [[RevPOR]] and [[RevPAR]]. <br>
== Operating review ==
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. The prologue gives you information on how the hotel performs as you take over, you can not influence this, of course.
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
After each year they will be ready for you in your [[Team finances]] via the link in your [[Team file]].  
* your evaluations by your coach (so the quality of your arguments)
Your results presented there will be divided into the next parts:
* your competitors 
* The results, the operating review with
* your decisions
** The Revenues
The occupancy rate is the crucial element in all this. The total overview will be visible in your Team File after each year <br>
** The Costs: divided in costs fixed, costs variable and costs of your team's [[decisions]]
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.  
** Net profit
* The elements [[Key metrics]], [[Top Research|Market information from Top Research]] and [[Short comment]] of your coach are explained in separate pages.


== How many costs can you make? How much can you spend? == __NOEDITSECTION__
== Net profit ==
Have a look further down in this page. In the past there was a total of € 2.430.595 of costs made. Part of this is fixed costs. The profit was € 436.307.
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>
So if you make new additional costs an indication is that this should not be more then last years profit. But, if you have more occupancy or higher prices, you will have more revenues an can spend more. So in the simulation we have limited the costs to a maximum: if you spend all to the max you can spend is an additional € 850.000. So, as in reality, the options are very uncertain.  


== Operating review ==__NOEDITSECTION__
Of course, the net profit per year is very interesting. The total costs will be deducted from the total revenues.
''Please take into account that your hotel has 364 days (not 365) and some figures are rounded, we never use decimals, neither should you.<br>''<br>
Upon taking over the net profit is: <br>
At the end of each year you will find in your Team finances on 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.  
- Total revenue € 2,861,896 <br>
- Total cost € 2,430,595<br>
- No fine or bonus € 0,0<br>
- Net profit € 431,301<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.  
</DIV><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 extended [[algorithm]] calculates your occupancy rate depending on your decisions, your coach's mark (related to the quality of your explanations), the demand in the market and many other elements. Depending on your occupancy rate, you'll get more food & beverage and other revenues as well. <br>
[[Image:results_profit_2023_01.jpg|thumb|600px|center|    <center>''Net profit as you take over in grey 'year 1' column, plus examples in the following years; year 4 is not completed.<br> We will focus on year 0 now.</center>]]


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.


== Revenues ==__NOEDITSECTION__
{{Template:New Skin Box}}
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 through an algorithm. The mark your coach gives to you for your performing as a team is influencing your occupancy rate heavily. 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 which is an illusion.  
== Analysis ==
Check the situation for real via benchmarks and you will se that the margin in somewhere between 50% to 70% [[occupancy rate]].<br>
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>
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>
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.
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_2015.jpg|thumb|600px|center|    <center>''Revenues overview after four years.''</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. 


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, prologue) 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.
== 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>


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.
''→ Go! Following the Introduction to the Hotel? Step 10/10 is the page [[Staff|Staff page, click here.]]''
<hr></div><br>


<table border=1 cellpadding=8>
{{Footer}}
<tr><th>Revenues History</th></tr>
<tr><td>Rooms</td><td> Rooms revenues weekend</td><td> € 704.340</td><td> 24,56%</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>Food and beverage</td><td> F&B revenues weekend</td><td> € 266.080</td><td> 9,28%</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>Banqueting</td><td> Banqueting revenues</td><td> € 100.123</td><td> 3,49%</td><td> 3,49%</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>'''Total revenues'''</td><td> </td><td> '''€ 2.866.902''' </td><td> '''100%'''</td><td> '''100%'''</td></tr>
</table><br>
 
== Operating review costs ==__NOEDITSECTION__
The situation below is just an example of the costs as they will be shown in the final operating review. So this example shows the prologue(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_2.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 the prologue.
<table border=1 cellpadding=8>
<tr><th>'''Costs'''</th></tr>
<tr><td>'''Costs: fixed'''</td><td> Depreciation costs of existing assets</td><td> € 525.187</td><td> 34,64%</td></tr>
<tr><td></td><td> Fixed staff costs </td><td> € 550.271</td><td> 36,29%</td></tr>
<tr><td></td><td> Costs of premises</td><td> € 390.473</td><td> 25,75%</td></tr>
<tr><td></td><td> Insurance & interest costs</td><td> € 50.012</td><td> 03,29%</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>'''Costs: variable'''<td> Variable staff costs</td><td> € 355.170</td><td> 38,95%</td></tr>
<tr><td></td><td> Laundry costs</td><td> € 118.390</td><td> 12,94%</td></tr>
<tr><td></td><td> Cleaning costs</td><td> € 236.780</td><td> 25,88%</td></tr>
<tr><td></td><td> F&B purchase costs</td><td> € 204.312</td><td> 22,33% </td></tr>
<tr><td>'''Total variable costs'''</td><td></td><td> '''€ 914.652''' </td><td> '''100%'''</td><td>'''37,63%'''</td></tr>
<tr><td>'''Costs: team decisions'''</td><td> Marketing expenses</td><td> € 0</td><td> 00,00%</td></tr>
<tr><td></td><td> Extra staff rewarding expenses</td><td> € 0</td><td> 00,00%</td></tr>
<tr><td></td><td> Extra depreciations costs</td><td> € 0</td><td> 00,00%</td></tr>
<tr><td></td><td> Environmental expenses</td><td> € 0</td><td> 00,00%</td></tr>
<tr><td></td><td> Additional maintenance expenses</td><td> € 0</td><td> 00,00%</td></tr>
<tr><td></td><td> Market research expenses</td><td> € 0</td><td> 00,00%</td></tr>
<tr><td></td><td> Other expenses</td><td> € 0</td><td> 00,00%</td></tr>
<tr><td>'''Total team decisions costs'''</td><td></td><td> '''€ 0''' </td><td> '''100%'''</td><td> '''00,00%'''</td></tr>
<tr><td></td><td></td><td></td></tr>
<tr><td>'''Total all costs'''</td><td></td><td> '''€ 2.430.595''' </td><td>'''€ 2.430.595''' </td><td> '''100%'''</td></tr>
</table><br>
 
The different costs groups are all mentioned in the operating review table above.
 
* Costs: fixed
You can't influence these costs at all. 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 costs of existing assets: 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 and 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. You can't influence this, but it will be influenced by the occupancy rate you have created with your way of managing. <br>
- 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
All of your [[decisions]] numbers 7 -13 lead directly to expenses which can be seen directly at the costs side as expenses. They 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 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. There is no reserve and as their is no liquidity in the game, there is no need for spending them. The balance sheets just show the individual profit of each year in the operating review and the total of the net profit over the years. No worries about [[liquidity]]: you can invest and pay, though you can't see the proper balance sheets.
 
[[Image:results_profit2.jpg|thumb|600px|center|    <center>''Net profit in the prologue as you take over.''</center>]]
 
In this example on taking over (prologue)
-Total revenues were € 2.866.902<br>
-Total costs € 2.430.595<br>
-Net profit € 436.307<br>
 
For instance in year 4 there is a bonus in this case € 106.491 so this is added to the profit.<br>
 
So the net profit on taking over seems to be 15,21% of the revenues, a good and interesting result. <br>
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.
 
== Entrepreneurship mark and coach comment == __NOEDITSECTION__
Each year you will find the [[mark#entrepreneurship mark|entrepreneurship mark]] and [[mark#creativity mark|creativity mark]] of that specific year in your Team finances. Together they are your gameplay round for that year. This gives you an indications on how your coach thinks your are running the hotel, taking all into account (row 70). <br>
You will also see the ranking: <br>
on net profit and on creativity in your city. You will just se 1, 2, 3 of 4+. The last (4+) meaning anywhere outside the top 3. <br>
Before the dash | the result is in this specific year. After the dash the rank all of the years, so cumulative.
 
 
[[Image:gameplay mark02.jpg|thumb|750px|center|    <center>''Your total mark per year.''</center>]]
 
At the bottom of your file - result tab (row 164) you will find a few keywords from your coach on your performance.
 
[[Image:gameplay_comment.jpg|thumb|750px|center|    <center>''Some keywords of your coach in each year.''</center>]]
 
<br><hr>
 
''→ GO! [[#top|Top of this page]]''
<center><small>''Emerald Forest Hotel'' offering an <font color="green">'''emerald''' </font color="green">hotel experience!
| Run your own hotel in this management simulation.</small></center>

Latest revision as of 12:20, 12 October 2024

→ Go! Introduction to Hotel


All results

The annual results of your hotel are stated in the operating review, 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 operating review consist of a number of crucial elements, whcih each have their own page:


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.

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.

Of course, the net profit per year is very interesting. The total costs will be deducted from the total revenues. Upon taking over the net profit is:
- Total revenue € 2,861,896
- Total cost € 2,430,595
- No fine or bonus € 0,0
- Net profit € 431,301

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.


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


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 . . .