Operating review: Difference between revisions

From Emerald Forest Hotel
Jump to navigation Jump to search
No edit summary
No edit summary
 
(135 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}}<br><br>
{{Template:New Skin Box}}
== 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.


== Operating review ==__NOEDITSECTION__
The operating review consist of a number of crucial elements, whcih each have their own page:
An operational review is an in-depth look at the big picture, addressing in this case especially the financial elements so to
*The overview of the [[Operating review]]
make the choices, costs, revenues and results clearly visible.<br>
*The [[Revenues]]
Divided into revenues and costs, in the administration of Emerald Forest Hotel, as we use it, no [[VAT]] Value added tax is visible. There is no record on the [[liquidity]], balance sheets (opening nor end of the year) nor an investment plan.
*The [[Costs]]
We consider the revenues and the costs to be without any VAT and costs and revenues to be paid at the date they occurred. <br>. The total of the operating review is available as a [[operating review spreadsheet]].
*The [[Net profit]]
*The [[Key metrics]]
</div>


== All Revenues ==__NOEDITSECTION__
Revenues comprise the average (sales) prices the hotel had decided to chose, times the number of booked rooms (occupancy rate). 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 and other revenues are a separated revenue unit in the hotel. The sales prices in the past varied from a minimum of € 25 to a maximum of € 30 per person. On the [[Banqueting]] page, you can find some more info, pictures, and videos on banqueting. The 'other' elements in this group are things like additional sales, renting out bikes, upgrades, cancellation fees etc. Altogether a bit more than 8% of the total revenues.


[[Image:results_revenues_2018_new.jpg|thumb|600px|center|    <center>''Revenues overview during four years. We focus on the  History now''</center>]]
{{Template:New Skin Box}}
== 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.


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, the history will be your starting position, the other years just give you an indication of what might happen.
== 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. <br>


<table border=1 cellpadding=8>
Of course, the net profit per year is very interesting. The total costs will be deducted from the total revenues.
<tr><th>Revenues History</th></tr>
Upon taking over the net profit is: <br>
<tr><td>&nbsp;Rooms</td><td>&nbsp;Rooms revenues weekend</td><td>&nbsp;704,340</td><td>&nbsp;24.61%</td></tr>
- Total revenue 2,861,896 <br>
<tr><td></td><td>&nbsp;Rooms revenues weekdays</td><td>&nbsp;1,244,880</td><td>&nbsp;43.49%</td><td>&nbsp;68.10%</td></tr>
- Total cost 2,430,595<br>
<tr><td>&nbsp;Food and beverage</td><td>&nbsp;F&B revenues weekend</td><td>&nbsp;266,080</td><td>&nbsp;9.29%</td></tr>
- No fine or bonus 0,0<br>  
<tr><td></td><td>&nbsp;F&B revenues weekdays</td><td>&nbsp;414,960</td><td>&nbsp;14.49%</td><td>&nbsp;23.78%</td></tr>
- Net profit 431,301<br><br>
<tr><td>&nbsp;Banqueting and other revenues&nbsp;</td><td>&nbsp;Banqueting and other revenues&nbsp;</td><td>&nbsp;€ 231,636</td><td>&nbsp;8.09%</td><td>&nbsp;8.09%</td></tr>
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.  
<tr><td>&nbsp;'''Total revenues'''</td><td> </td><td>&nbsp;'''€ 2,861,896''' </td><td>&nbsp;'''100%'''</td><td>&nbsp;'''100%'''</td></tr>
</DIV><br>
</table>


== All costs ==__NOEDITSECTION__
[[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>]]
The situation below is just an example of the costs after four years. Again, the situations as you take over is the history (colored gray) the rest is example calculations. <br>


[[Image:results_costs_2018_02.jpg|thumb|600px|center|    <center>''Costs overview during four years. We focus on the History now.''</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. Especially the Cost on management team decision are missing in the relevant year History. The four test year are just a basic testing in what this could bring. For now, this all is just zero. These management team decisions is what has been lacking, the last few years: you can not do without anymore.<br>
{{Template:New Skin Box}}
<table border=1 cellpadding=8>
== Analysis ==
<tr><th>&nbsp;'''Costs'''</th></tr>
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>
<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></tr>
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.
<tr><td></td><td>&nbsp;Fixed staff costs </td><td>&nbsp;€ 550,271</td><td>&nbsp;36.29%</td></tr>
<tr><td></td><td>&nbsp;Costs of premises</td><td>&nbsp;€ 390,473</td><td>&nbsp;25.75%</td></tr>
<tr><td></td><td>&nbsp;Insurance & interest costs</td><td>&nbsp;€ 50,012</td><td>&nbsp;03.29%</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>&nbsp;'''Costs: variable'''<td>&nbsp;Variable staff costs</td><td>&nbsp;€ 355,170</td><td>&nbsp;38.95%</td></tr>
<tr><td></td><td>&nbsp;Laundry costs</td><td>&nbsp;€ 118,390</td><td>&nbsp;12.94%</td></tr>
<tr><td></td><td>&nbsp;Cleaning costs</td><td>&nbsp;€ 236,780</td><td>&nbsp;25.88%</td></tr>
<tr><td></td><td>&nbsp;F&B purchase costs</td><td>&nbsp;€ 204,312</td><td>&nbsp;22.33% </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>&nbsp;'''Costs: management team decisions'''</td><td>&nbsp;Marketing costs</td><td>&nbsp;€ 0</td><td>&nbsp;00.00%</td></tr>
<tr><td></td><td>&nbsp;Staff development costs</td><td>&nbsp;€ 0</td><td>&nbsp;00.00%</td></tr>
<tr><td></td><td>&nbsp;Extra depreciations costs</td><td>&nbsp;€ 0</td><td>&nbsp;00.00%</td></tr>
<tr><td></td><td>&nbsp;Market research costs</td><td>&nbsp;€ 0</td><td>&nbsp;00.00%</td></tr>
<tr><td></td><td>&nbsp;Other costs</td><td>&nbsp;€ 0</td><td>&nbsp;00.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></td><td></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>
</table><br>


The different costs groups are all mentioned in the operating review table above. <br>
== More numbers ==
Keep in mind that calculations are never 'perfect'. Calculation on the revenues on rooms weekend, for instance:<br>
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>
is 52 weeks x 100 rooms x 43% weekdays (3 nights out of 7) x 7 days a week = 15.652 nights x occupancy rate (starts at 50%) x average price (rack rate and last-minute). There is always a difference to the outcome of this calculation and the 'reality': caused by cancellations, refunds, double bookings, short stays, rounding-up numbers, missing one day in a year etc. There is no record on all of this. This all together might bring a difference up to a few percent in the expected revenues linked to the occupancy rate.
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.


* [[Fixed costs|Costs: fixed]]
== Past ==
You cannot 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>
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>


- Depreciation costs of existing assets: depreciation of all the assets especially the building, fixtures and fittings.<br>
''→ Go! Following the Introduction to the Hotel? Step 10/10 is the page [[Staff|Staff page, click here.]]''
- Fixed staff costs: staff needed to run the hotel and which have to be paid even if there are no guests at all. <br>
<hr></div><br>
- Costs of premises: costs of maintenance, repairs on small adaptions to the building and the parking lots.<br>
- Insurance & interest costs: costs for insurance for staff, building a liability and costs for mortgage and other loans. <br>


* [[Variable costs|Costs: variable]]
{{Footer}}
The variable costs will depend on the actual number of guests in the hotel. There is a ratio between occupancy rate and all of these costs. You cannot influence this, but it will be influenced by the occupancy rate you have created with the way of managing the hotel. <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 linen etc. needed.<br>
- Cleaning costs: rooms need to be cleaned more often because of more guests and to be cleaned better.<br>
- F&B purchase costs: more guest means more breakfasts etc. for guest and more f&b for additional staff so the purchase costs go up.<br>
 
* [[Costs team decisions|Costs: team decisions]]
All of your [[decisions]] (numbers 6 -10) lead directly to costs which can be seen directly on the costs side. They are directly connected to the situation the family Bergman explained: they have been neglected. As you can see in the past there were no costs made regarding these decisions. Of course, this was good for the profit but it will come back like a boomerang! So the family urges the new management to use this costs group team decisions in an efficient way. The screenshots just show a few years as example during some testing with the accountant. The history is the only valid, last year's result. <br>
 
* 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 then expected) or a fine (tax e.g.) this is added or deducted from the profit leading to the net profit.
 
[[Image:results_profit_2018_04.jpg|thumb|600px|center|    <center>''Net profit as you take over in gray headed 'history'</center>]]
 
In this example on taking over: <br>
- Total revenues were € 2,866,902<br>
- Total costs € 2,430,595<br>
- Net profit € 436,301<br><br>
The balance sheets just show the individual profit of the last year in the operating review and the total of the net profit.
 
== Key metrics ==
Some key metrics and ratios on the operations of your hotel in this section. <br>
Net profit once again showed here, but now linked to the total net profit. So adding up the profit of all years passed. <br>
The number of guests gives you an indication which numbers ''pass through'' your hotel in a year. <br>
Your hotel is ranked on net profit as well as on creativity. Both rankings are within your city.
There is ranking on creativity, this is linked to what you have done in all of the years related to creativity and evaluated by your coach. You can have any position depending on the number of hotels in your city.  <br>
 
== Market research costs and other costs ==
The are standard element sin a hotel  operating review. Both, again, are not used n the history. Some exercising with numbers is visible in the four test years.
 
== Analysing ==
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.
 
== Calculate yourself? == __NOEDITSECTION__
If you want to make calculations yourself, you can, in the top menu download the Team File as Excel file. Store this one on your computer and you can do some calculations in this version (which now, of course, has no longer links to the real one and new changes in the online one).
 
<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 . . .