Decisions: Difference between revisions

From Emerald Forest Hotel
Jump to navigation Jump to search
No edit summary
No edit summary
 
(184 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[Category:Hotel info]]__NOTOC__ 
{{Header Game play}}
''→ Go! [[:Category:Hotel info]]'' <br>
<br>The [[Team File|Team File]], with a private login link, is crucial to your team for running the hotel. In this Team File you will find four tabs:
{{Running competition}}
* [[Year 0]] tab is when you start, this is where you make all the strategic choices, introduce your hotel, targetgroups etc.  
== What can you do? ==__NOEDITSECTION__
* [[Year 1-2-3-4]] tab is where you take your decisions each year and give [[explanations]] each year, after your year 0 (strategic choices)
In the game you have a number of possibilities to influence your hotel.
* [[dashboard]] tab is where you can find an overview of the most important financial results
* The [[teampage]] whcih you have on this platform. On this teampage you present your strategy and the links to your social media. Anyone can read all on this platform. Only after loging-in you can edit your own teampage.
* [[results]] tab is where you will find an operating review and other details on results and costs after each year
* Your teamsheet: only accessible with your private hyperlink, any hotel has its own. This is not visible on the platform. In this private section a hotel has its own [[teamsheet]] with:
** tab 1 the [[decisions]] tab where you fill out your decisions on prices and expenses
*** in this tab a link to the [[explanations form]] to explain your decisions
** 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. (which you should link to your teampage)
* Other live actions of your team: sometimes required, like the Trade Fair but maybe also at your own initiative.
We know look at the (financial) decisions you make each year.


== Your hotels teamsheet == __NOEDITSECTION__
<br>After a year has passed, the new dashboard and the results will only be visible after being released by your coach. <br>
Look at the screenshot below: this is what you will see: your hotels private teamsheet.  
There is a [[Demo Team File]] you can check, with a filled out Team File at the end of an example Game.
<br>Each competition is setup in a specific way: so check your competition's assignment and timeline for details.  


[[Image: example_teamsheet_2015_05.jpeg|thumb|890px|center]] <center>''Your teamsheet ''</center>
<br><center>[[Image:Team sheet tabs Emerald Forest Hotel yera1-2-3-4.jpg|600px]] <br>''Emerald Forest HotelTeam File tabs '' </center>
This example is an example teamsheet as it lookes after four years. In this example all of the years are filled out, of course if you start you will only see column C the prologue (the history) filled out and the rest will be empty. The history, filled out with decisions from the past made by [[Christina Bergman]] will always be available and is your first point of reference. As you can see she didn't spend anything on the group of costs we now call team decisions on expenses, group 7 to 13 cell 18-24. They are marked n/a, not available, so not used in the past.


== Outlines on decisions ==__NOEDITSECTION__
== Working on your decisions ==
Christina Bergman has decided that she only wants to be informed with the main outlines of your choices. Therefore the number of items you can make decisions on is limited. These decisions need to be filled out and explained by you in the teamsheet. These decisions form the backbone of your new policy in running the hotel.<br>
Jill Jandal and Christina Bergman have decided that they only want to be informed of the high points of your choices; therefore the number of items you can make decisions on is limited. These decisions need to be filled out on the Decisions tab, each year. The [[history]] of the year before you take over, so Jill's last year, is available. She did not spend any money on some of the expenditure groups, like marketing costs. So you will see the indication N/A not available or 0.<br>


A few rules on the decisions and further information on their limitations.
There are rules regarding the decisions and further information on their limitations. You might have an brilliant plan, but it has to stay within these limitations.
For all decisions try to calculate what the effect will be. The algorithm, in the end, will make up your final, new operating review.  


- Please take into account that your hotel has 364 days and nights per year (52 weeks * 7 nights). <br>
- Please take into account that your hotel has 364 days and nights per year (52 weeks * 7 nights) <br>
- the basic occupancy rate of hotel used to be 50% <br>
- The basic [[occupancy rate]] of your hotel was 50% <br>
- the number of rooms in your hotel is 100 <br>
- The number of [[rooms]] in your hotel is 100 <br>
- the weekend days are 43% of the total number of nights (rounded-up) <br>
- The [[weekend|weekend days]] are 43% of the total number of nights (rounded up) <br>
- the weekday days are 57% of the total number of nights (rounded-up) <br>
- The [[weekdays]] are 57% of the total number of nights (rounded up) <br>
- the average number of guest in a room is in the weekend days is 1,7 <br>
- The average number of guest in a room on weekend days is 1.7 <br>
- the average number of guest in a room is during the week days is 1,0 <br>
- The average number of guest in a room on weekdays is 1.0 <br>
- We completely refrain from (adding) [[VAT]] and or other taxes on profit for now. <br>
- We completely refrain from (adding) [[VAT]] and or other taxes on profit for now <br>
- You cannot change the number of rooms of your hotel.<br>
- You cannot change the number of rooms in your hotel<br>
- You cannot sell the property.<br>
- You cannot sell the property<br>
- The effects of all of your decisions only last for one year!
- You cannot 'spend' or use profit (or cash flow) or make investments different or larger than indicated <br>
- The effects of all of your decisions only last for one year (unless it is an investment)!


== List of the decisions ==__NOEDITSECTION__
== Decisions list==
A version of the teamsheet with decisions and results as example is available at
Below you will find the list of ten financial decisions you will have to make each year in your Team File; there might be some small differences in your competition. Adapt the decisions to your new plans and strategy each year. <br>
[https://docs.google.com/spreadsheet/ccc?key=0Ah_nJphUpAz1dGxqWG1NRDZBaVNvdVVUWngtQnh4WEE example teamsheet team Z01] <br>
The explanations of your decisions are very important and account for the biggest part of your occupancy and thus results. And they contribute heavily to your mark. Also make calculations in your explanations, to justify your choices.<br>
You can not edit this example. The requested explanations form for this demo-team Z01 - not filled out - is available at:
[https://docs.google.com/document/d/1GaZ0Kfi96G5l2ZEmIXc4yF2hSYxJooGeFiKkZm8BBG8/edit example team Z01 explanations]
Underneath you will find the list of financial decisions you will have to make each year. Adapt them to your new plans and strategy each year. On filling them out, remember that (for now) you can only change the cells with a blue background and only in the active year. Do NOT (try to) change other cells and only fill out the year you are supposed to. <br>
Each year, use the decisions 14, the [[Explanations form]] to explain your decisions to Christina and your coaches. Of course your actual decisions go along with these explanations. These explanations are very important and account for the biggest part of your decisions and if they have the effect you hoped for and contribute heavily to your mark. Make especially calculations to justify your choices.


The above situation is the situation as you take over the hotel and shows Christina Bergman's decisions last year. After each year the next column should be filled out by your team, i.e., column D for year one, column E for year two etc. And, only the BLUE highlighted part. <br>
* Ranges
In all decisions made there are a few ranges built-in to make it possible for you to make your decisions appropriately and to prevent you from going bankrupt. Running this hotel consists of more than just filling out numbers in a spreadsheet; therefore you have to explain things in the Team File. We encourage you to behave like an entrepreneur throughout the entire game.<br>


You can only change the hotel's name in cell B1 in the first year.
* Price systems, [[rate|rates]]
* Ranges
You can use psychological pricing, flex prices, dynamic pricing, revenue management or whatever system you want to use in your decisions. The better your explanations in your Team File (and especially your calculations), the better your company's results will be, the higher your business coach [[mark]], and the more customers you get by a higher [[occupancy rate]]. In hospitality, we see the concept of 'rates' more frequently than prices.  
In all decisions made there are a few ranges built in to make it possible for you to make your decisions appropriately and to prevent you from going bankrupt. Running this hotel consists of more than just filling out numbers in a spreadsheet, therefore you have to explain things in the explanations form and we encourage you to behave like an entrepreneur throughout the entire game.<br>


* Euros
* Euros
Only make your decisions in euros, don't use cents or other currency. In filling out the amounts do not use € signs or . or ,  just use the numbers! <br>
Only make your decisions in whole euros, don't use cents or other currencies. In filling out the amounts in the Team File, do ''not'' use decimals! Not in the prices and not in costs.<br>


* Price systems
== Five Team decisions on (sales) prices, creating revenues ==
You can use psychological pricing, flex prices, dynamic pricing, revenue management or whatever system you want to use in your decisions. The better your explanations (and especially your calculations) are, the better your company's results will be, the higher your entrepreneurship [[mark]] and so the more customers you get.  
As you can see in the example: if you mouseover the description of the decision (like cell B8 in this example) you will get more information regarding what the decision is all about. You are allowed to fill out the pink cells according to the instructions.  <br>
You will have to decide what [[prices]] you will charge (per room per night) for weekdays or weekends which serve the markets. In the pages under [[rooms|room]] [[prices]], you can read a bit more on the history. Depending on your performance as a team and your choices made, you will get a certain occupancy rate and corresponding number of guests. These guest prices will bring your revenues in each of the five revenue categories, depending on the prices decided upon and this [[occupancy rate]]. So setting the prices too low (think of your [[cost price]]), even with a very high occupancy rate, might bring in revenue, but hardly any profit or even losses. <br>
We offer you just 5 possibilities in prices to decide on; we realize that there are many, many more. But, to keep things logical and in line, you will have to do with these five.
You cannot influence ''how many'' people will stay in the room.<br><br>


<hr>
[[Image: example decisions on prices_2018_3.jpg|thumb|700px|center]]  <center>''Example decisions on prices. Mouseover in row B gives you more info on the decision. You will also get an alert if the input is not okay. Be sure to explain in depth, with sources, arguments, and preferably calculations. When a year has passed, it will become greyed-out.''</center><br>
=== Team decisions on prices ===__NOEDITSECTION__
''<font color="green"> → '''Limitations'''</font color="green"><br>''
''Strongly recommended: Never change any of the five prices more than + or -20% per year to protect your hotel from high impact of too extreme changes.''<br>


[[Image: example decisions on pricesnew.jpeg|thumb|900px|center]] <center>''Decisions on prices.''</center>
* 1. Weekend last-minute [[room]] price (or [[rate]]) per night<br>
In the past, the average price was € 80. The last-minute price is the minimum price you will accept to fill up the empty rooms, the gaps in your occupancy. <br>
The revenues after each year, comprise the number of booked rooms (occupancy rate) at the weekend, times the average (sales) prices: so (last-minute and rack rate) divided by two.


As you can see in the example: if you mouse over the description of the decision (like cell B10 in this example) you will get more information what the decision is all about. You are allowed to fill out the blue cell according to this instruction.  You will get a warning in red if you exceed the amounts or fill out something wrongly.  
* 2. Weekend rack rate [[room]] price (or [[rate]]) per night <br>
In the past the average price was € 100. The rack rate is the highest price you will get. <br>
The revenues after each year, comprise the number of booked rooms (occupancy rate) in the weekend, times the average (sales) prices: so (last-minute and rack rate) divided by two.


You will have to decide what [[prices]] you will charge (per room per night) for hotel's week days or weekend days which serve the two current markets. There is not much information on the past yet. In the pages on [[rooms|room]] you can read a bit more as well as in the page on [[prices]].
* 3. Weekday last-minute [[room]] price (or [[rate]]) per night<br>
* 1. Weekend last-minute [[room]]-price per night<br>
In the past the average price was € 100. The last-minute price is the minimum price you will accept. <br>
In the past (prologue, year0) the average price was € 80. You can change this by a maximum of 20% (more or less) each year. The last-minute price is the minimum price you will accept. The system will automatically allocate a number of guests for this rate.
The revenues after each year, comprise the number of booked rooms (occupancy rate) during weekdays, times the average (sales) prices: so (last-minute and rack rate) divided by two.


* 2. Weekend rack rate [[room]]-price per night <br>
* 4. Weekday rack rate [[room]] price (or [[rate]]) per night <br>
In the past (prologue, year0) the average price was € 100. You can change this by a maximum of 20% (more or less) each year.
In the past the average price was € 140. The rack rate price is the highest price you will get. <br>
The rack rate price is the highest price you will get. The system will automatically allocate a number of guests for this rate.
The revenues after each year, comprise the number of booked rooms (occupancy rate) on weekdays, times the average (sales) prices: so (last-minute and rack rate) divided by two.


* 3. Weekdays last-minute [[room]]-price per night<br>
* 5. Banqueting and other activities price (or [[rate]]) per person per day
In the past (prologue, year0) the average price was € 100. You can change this by a maximum of 20% (more or less) each year. The last-minute price is the minimum price you will accept. The system will automatically allocate a number of guests for this rate.
In the past the average price was € 28. You can not skip this activity totally, so price 0 is not allowed. The occupancy rate of the rooms also has an impact on the numbers of booked banqueting arrangements and other activities.  


* 4. Weekdays rack rate [[room]]-price per night <br>
* Other ideas
In the past (prologue, year0) the average price was € 140. You can change this by a maximum of 20% (more or less) each year. The rack rate price is the highest price you will get. The system will automatically allocate a number of guests for this rate.
Of course there are many other possible [[prices]] and price systems, apart from [[last-minute]] and [[rack rate]]. Though, we focus on the total of five price settings; explain them more in depth and find benchmarks for this and give links arguing why you chose these prices for these [[target group|targetgroups]]<br>
If you think a specific, different price is absolutely necessary, use the marketing costs, or other costs, to promote this. Use the row ''Extra Information'' to explain your plan to your coach. Then be sure to make calculations on costs and revenues and predicted additional [[revenue]]s compared to the normal situation. Your coach might reward this with a [[bonus]], if consistent, well-thought-out etc. If so, you could find additional results from this at the bonus or fines (row 51-52). This will always be profit or losses, not revenues. But please (first) focus on the regular opportunities, there are plenty.  


You can make a decision on an average room-price. This will not be the price published, that's up to your marketing approach and you can elaborate on that in your explanations form. For any price chosen, let's say € 80, it means that there will always be an average of € 10 in there for the breakfast. So in fact you would get an average of € 70 for the room-use.<br>
And, as this is an average, it is of no importance for now or your decisions how many people will stay in the room.<br>
''<font color="green"> → '''Limitations'''</font color="green"><br>''
''Do not change any of these four prices by more then 20% each year. This is build in to protect your hotel from too extreme changes.''<br><br>


<hr>
== Five Team decisions to be made on costs ==
The market for [[banqueting]] is totally different and separated. Your hotel offers two choices in the type of banqueting offer.
Of course, you cannot influence the [[Fixed costs]] which are in your operating review, nor can you influence the [[variable costs]]; they are set by your occupancy rate. <br>
* 5. Banqueting standard price per person per day
Other things you will have to make decisions upon are decisions 6 - 10. This will create costs you decide on and which will be visible directly in your operating review after any year. On mouseover in the file you'll get more info on these choices. All these decisions bring extra costs compared to the past, as Christina did not spend money on these elements. Try to explain, for each form of cost what you expect it to bring you. So, how will you earn back these costs and what will they bring additionally?  All costs will have an effect, but  only in the year you make them. For maximum effect you will have to repeat them in subsequent years.<br>
In the past (prologue, year0) the average price was € 25. This is automatically linked to the occupancy rate.
In case you think you have an idea like this, please ''also'' explain this to your coach at the end of your Team File.<br><br>


* 6. Banqueting premium price per person per day
[[Image: example decisions on costs_2018_3.jpg|thumb|700px|center]]  <center>''Example decisions to be made on costs. Mouseover in row B gives you more info on the decision. You will also get an alert if the input is not okay. Be sure to explain in depth, with sources arguments, and calculations. When a year has passed, it will be greyed-out.''</center>
In the past (prologue, year0) the average price was € 30. This is automatically linked to the occupancy rate.


''<br><font color="green">  → '''Limitations'''</font color="green"><br>''
== Impact ==
''Do not change any of these prices by more then 50% each year. This is build in to protect your hotel from too extreme changes.''<br><br>
Check the impact of changing the [[Prices|Sales price]], on these pages.<br>
Or check [[Revenue per room]] to get even more information.


<hr>
=== Team decisions on expenses===__NOEDITSECTION__
Other things you will have to make decisions upon:<br>
[[Image: example decisions on expenses3.jpeg|thumb|650px|center]]  <center>''Team decisions and related expenses.''</center>


* 7. Marketing expenses
* 6. Marketing costs
No expenses made on this in the past: n/a means not available.<br>
No costs for this in the past: 0 or N/A means not available.<br>
This is the total spending for all paid marketing actions in the past: maybe this is on the shy-side? There was very little going on at the Emerald Forest Hotel, especially nothing on social media or affiliates and also not in bartering. So probably this is a decisions you can't afford to leave out.
This is the total spending for all paid marketing actions in the past: maybe this is on the low side? There was very little going on at the Emerald Forest Hotel, especially nothing on social media or affiliates and there was also not negotiating with distributors and partners. You could also include costs related to clean air, to green energy, to social responsibility, ecological footprint etc. So, this is probably a decision you cannot afford to leave out.
''<br><font color="green">  → '''Limitations'''</font color="green"><br>''
''<br><font color="green">  → '''Limitations'''</font color="green"><br>''
''You can use any amount between € 0 and € 100.000 per year. This is build in to protect your hotel from too extreme changes and costs.''<br><br>
''You can use any amount between € 0 and € 200,000 per year, to protect your hotel from the high impact of too extreme changes.''<br><br>
<hr>
 
* 8. Extra staff rewarding expenses
* 7. Staff development costs
No expenses made on this in the past: n/a means not available.<br>
No costs for this in the past: 0 or N/A means not available.<br>
Apart from the salaries, there were some extra's paid to the staff depending on their sales (if part of their job) or on their performance (others). In addition, sometimes there were special occasions for which something extra was paid.
Apart from the salaries, extra costs can be incurred here, such as spendings on necessary skills and resources to support the [[staff]] member's career goals and the organization's business needs. This will be things like training, developing skills or for instance courses on hospitality.  
''<br><font color="green">  → '''Limitations'''</font color="green">''<br>
''<br><font color="green">  → '''Limitations'''</font color="green">''<br>
''You can use any amount between € 0 and € 100,000 per year. This is build in to protect your hotel from too extreme changes and costs.''<br><br>
''You can use any amount between € 0 and € 100,000 per year, to protect your hotel from the high impact of too extreme changes.''<br><br>
<hr>
* 9. Extra depreciations of [[investments]]
No expenses made on this in the past: n/a means not available.<br>
You start off a new company: so, in the past this was € 0. These are the depreciation costs related to your NEWLY planned investments. Check the specific [[investments]] page on this. You can only explain expenses, not investments which you probably will make. So be sure to check the page on investments!<br>
''<font color="green">  → '''Limitations'''</font color="green">''<br>
''You can use any amount between € 0 and € 250.000 per year. This is build in to protect your hotel from too extreme changes and costs.''<br><br>
<hr>
* 10. Environmental expenses
No expenses made on this in the past: n/a means not available.<br>
This are expenses related to clear air, to green energy, to social responsibility, ecological footprint etc. All above the minimum required by legislation. <br>
<font color="green">  → '''Limitations'''</font color="green"><br>
''You can use any amount between € 0 and € 100,000 per year. This is build in to protect your hotel from too extreme changes and costs.''<br><br>
<hr>
* 11. Additional maintenance expenses
No expenses made on this in the past;: n/a mean not available.<br>
As you can see on the [[rooms|footage available]] the hotel is in need for some additional maintenance in the rooms, facilities etc. <br>
''<font color="green">  → '''Limitations'''</font color="green"''><br>
''You can use any amount between € 0 and € 100.000 per year, there is a history on the hotel. You have to explain the amount carefully , check the specific [[investments]] page on this''.<br><br>
<hr>
* 12. Market research expenses
No expenses made on this in the past: n/a means not available.<br>
These are the cost for buying information from [[Top Research]] which will be analyzing the past year and it will be visible, if bought, on your results page after any year. <br>
''<font color="green">  → '''Limitations'''</font color="green">''<br>
''You can use chose the amount from the choice box so € 0 buys you no information, € 25.000 buys you for the small package, € 50.000 buys you the medium package and € 75.000 gets you the large package. Make sure you explain very clearly in your explanations form why you think buying this will benefit your company. The company [[Top Research]] will carry out the research and report to you.''<br><br>
<hr>
* 13. Other expenses
No expenses made on this in the past: n/a means not available.<br>
This could be anything apart from the groups mentioned above. So things like supporting the distributions chain, good courses or maybe costs on legal issues and governmental- or city-fees. Maybe contribution to tourist information offices activities. <br>
''<font color="green">  → '''Limitations'''</font color="green">''<br>
''You can use any amount between € 0 and € 100.000 per year, remember there is a history on the hotel. This is build in to protect your hotel from too extreme changes and costs.''<br><br>
<hr>


=== Explanations form ===__NOEDITSECTION__
* 8. New [[investments]]
No costs for this in the past: 0 or N/A means not available.<br>
You can choose to spend a maximum of € 900,000 each year on additional investments. This investment is the number you should fill out in your Team File decisions. The depreciation costs related to NEWLY planned investments will be visible after each year in your results, as depreciation costs of new investments.  And, as you can see on the [[rooms|footage available]], the hotel is in need of some additional investments in the rooms, facilities etc. <br>
Check the specific [[investments]] page on this. In your decisions you fill out the investment itself: You will find the corresponding depreciations on your [[operating review]].  All your investments will be linearly depreciated in 4 years without any residual value; there is no choice in this, so you fill out the investment itself. The depreciation costs during all four operational years will be calculated by the program. There will be no other costs of new investments, like interest. For the rest see the max numbers in the table underneath. So if you want to invest € 900,000 in year 1, fill this out and the system will create  € 225,000 (row 44 in the results tab) in year 1 as depreciation costs, as well as in subsequent years. 
Investments have a direct effect in the year they are made,  so you can make them in any year of the Game, including the last year. So an investment will have effect during more years: four to be precise. <br>
The costs of equipment and furniture bought in hospitality are totally different from what you would buy privately (at a furniture store like the Ikea): realize that. There are standards for safety, usability, long-wearing, cleaning, and many other reasons to buy professional material. <!--- An example of the cost you can find [https://drive.google.com/file/d/19Se88lLUO9HNbiu3Tpcv1JLPILXzc8Oy/view?usp=sharing here: Hotel cost estimating guide] --->


[[Image: example decisions on explanations2.jpeg|thumb|650px|center]]  <center>''Explanations form.''</center>
* 14. Explanations form
Not  in use in the past.<br>
Each year you have to fill out a new year in the same explanations form. The link to this file is at decision 14. Only if your are really ready entirely set the choice box van '''No''' to '''Yes'''! So the default setting will be '''No''' <br>
''<font color="green">  → '''Limitations'''</font color="green">''<br>
''<font color="green">  → '''Limitations'''</font color="green">''<br>
''You have to repeat your decisions in this form. Be sure only to work in the applicable year!''<br><br>
''You can make any investment with a maximum of € 900,000 each year. So over four years you can invest a maximum of 4 x € 900,000 = € 3,600,000. The costs of this will be ''the [[depreciation]]'', automatically calculated and always linear over four years (a simplification, no residual value, no interest, but still). The maximum is built in to protect your hotel from too extreme changes and costs.''<br><br>


== No decisions or no explanations ==__NOEDITSECTION__
* 9. Market research package costs
If any team fails in delivering the decisions or explanations before the deadline this is a serious problem. This will end in a low [[mark#entrepreneurship |entrepreneurship mark]] and thus jeopardize your [[mark#gameplay mark|gameplay mark]]. If there is no decisions filled out, the decisions from the prologue will be filled out, will will have a very bad impact on your [[occupancy rate]].
No costs for this in the past: 0 or N/A means not available.<br>
These are the costs of buying information from [[Top Research]] which will be analysing ''the past year'' which will be visible, if bought, on your results tab after any year. It will give you a benchmark on the prices asked in the market ('S', small package) as well as the costs incurred in the market ('L', large package).  
''<br><font color="green">  → '''Limitations'''</font color="green">''<br>
''You can use chose the amount from the choice box so € 0 buys you no information, € 25,000 buys you the 'S' small package and € 50,000 gets you the 'L', large package. Elements not paid for will show up in your operating review as 'Not bought'. Make sure you explain very clearly in your explanations why you think buying this will benefit your company. The company [[Top Research]] will carry out the research and report to you.''<br><br>


== Costs and results ==__NOEDITSECTION__
* 10. Other costs
If a year has passed, you will see the results, only after they have been released. This part is accessible in your teamsheet by clicking at the bottom on the "Results" tab.  
No costs for this in the past: 0 or N/A means not available.<br>
With the costs mentioned above and the revenues made in the past, the results of Emerald Forest Hotel were realized: you can find this in the [[results]]. So, if you change the costs (increase the expenses), understand that you have to earn these extra costs back (or your profit will go down rapidly)!  <br>
This could be anything apart from the groups mentioned above. So things like supporting the distributions chain, cooperation with partners, maybe legal costs. Maybe a contribution to tourist information offices activities. <br>
Make additional calculations explaining the profit it might bring. If you explain the pros and cons and the costs and the results and the expected additional profit of a specific action, your coach ''might'' reward this with a bonus. A [[bonus]] is ''net'', it is directly added up to your profit in any year.
''<font color="green"><br>  → '''Limitations'''</font color="green">''<br>
''You can use any amount between € 0 and € 100,000 per year, to protect your hotel from the high impact of too extreme changes.''<br><br>


Compensating for the extra expenses or benefiting from them can only be done in a few ways: <br>
== Impact ==
- Make costs that -by making them- bring down other costs (for instance, in using ICT, less staff is needed); <br>
Check the impact of these additional costs on your [[Cost price]] and so [[Prices|Sales prices]], on these pages.<br>
- More revenues by choosing higher prices, so a higher profit per sold product; <br>
Or check [[Revenue per room]] to get even more information.  
- More revenues by achieving a higher occupancy-rate, so more sales.<br>


So fill out the decisions from above for each year and explain clearly what you are aiming for in doing so. Do stick to the deadlines!
== Overspending ==
If you would choose the maximum available for all options, you would spend an additional € 1,350,000. This is next to the variable costs and the fixed costs.
These are additional [[costs]], the so called costs of your team decisions. <br>
* Next to this, you have these regular [[variable costs]] depending on the occupancy rate, and
* [[fixed costs]] which you can not influence (only the occupancy rate does so with the variable costs). <br>
So, keep an eye on the [[net profit]] which is around € 450,000 as you take over, to keep things in balance.


All the costs which you have made extra through your decisions will be brought directly to the [[results]] of the year you are playing and will be immediately visible there. This will be at the end of each playing year. <br>
== No decisions or no explanations ==
Spending the maximum on all possible costs looks like a bad idea! You have to earn back all these expenses, so you will have to make clear choices and keep the profit in mind!
If any team fails to deliver the decisions or explanations before the deadline this is a serious problem. This could end in a fine or a low marking from your coach: This will also jeopardize your occupancy rate. You might also get [[fine|fined]].
So, if you would decide to spend to the maximum on all options you could have in extra costs (per year):


* decisions 1-6 are no expenses.
== Quality of decisions and assignment ==
* decisions 7 maximum € 100.000
Check the [[occupancy rate]] page, to get more information on how this is built up. The quality of your decisions, explanations and assignments play a major role in this. <br>
* decisions 8 maximum € 100.000
After all, your argument is assessed by the coaches, who create your [[dashboard]]. You will only see the results after the coach has 'released' them.
* decisions 9 maximum € 250.000
* decisions 10 maximum € 100.000
* decisions 11 maximum € 100.000
* decisions 12 maximum € 75.000
* decisions 13 maximum € 100.000
* decisions 14 brings no expenses.
The maximum grand total on expenses is € 825.000,-. Keep in mind that the profit in history (the prologue, year0) was € 486.307! To the total costs were € 2.430.595. Creating all expenses will rise the costs by more then 33%! So think all of the expenses well over and elaborate in the explanations form on how your decisions will keep the company healthy.<br>
Once again, these are the maximum and any euro spend you have to earn yourself.  


<br><hr>
<br><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 19:47, 9 September 2023

→ Go! Category:Info pages



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

  • Year 0 tab is when you start, this is where you make all the strategic choices, introduce your hotel, targetgroups etc.
  • Year 1-2-3-4 tab is where you take your decisions each year and give explanations each year, after your year 0 (strategic choices)
  • dashboard tab is where you can find an overview of the most important financial results
  • results tab is where you will 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 being released 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 setup in a specific way: so check your competition's assignment and timeline for details.



Emerald Forest HotelTeam File tabs

Working on your decisions

Jill Jandal and Christina Bergman have decided that they only want to be informed of the high points of your choices; therefore the number of items you can make decisions on is limited. These decisions need to be filled out on the Decisions tab, each year. The history of the year before you take over, so Jill's last year, is available. She did not spend any money on some of the expenditure groups, like marketing costs. So you will see the indication N/A not available or 0.

There are rules regarding the decisions and further information on their limitations. You might have an brilliant plan, but it has to stay within these limitations. For all decisions try to calculate what the effect will be. The algorithm, in the end, will make up your final, new operating review.

- Please take into account that your hotel has 364 days and nights per year (52 weeks * 7 nights)
- The basic occupancy rate of your hotel was 50%
- The number of rooms in your hotel is 100
- The weekend days are 43% of the total number of nights (rounded up)
- The weekdays are 57% of the total number of nights (rounded up)
- The average number of guest in a room on weekend days is 1.7
- The average number of guest in a room on weekdays is 1.0
- We completely refrain from (adding) VAT and or other taxes on profit for now
- You cannot change the number of rooms in your hotel
- You cannot sell the property
- You cannot 'spend' or use profit (or cash flow) or make investments different or larger than indicated
- The effects of all of your decisions only last for one year (unless it is an investment)!

Decisions list

Below you will find the list of ten financial decisions you will have to make each year in your Team File; there might be some small differences in your competition. Adapt the decisions to your new plans and strategy each year.
The explanations of your decisions are very important and account for the biggest part of your occupancy and thus results. And they contribute heavily to your mark. Also make calculations in your explanations, to justify your choices.

  • Ranges

In all decisions made there are a few ranges built-in to make it possible for you to make your decisions appropriately and to prevent you from going bankrupt. Running this hotel consists of more than just filling out numbers in a spreadsheet; therefore you have to explain things in the Team File. We encourage you to behave like an entrepreneur throughout the entire game.

You can use psychological pricing, flex prices, dynamic pricing, revenue management or whatever system you want to use in your decisions. The better your explanations in your Team File (and especially your calculations), the better your company's results will be, the higher your business coach mark, and the more customers you get by a higher occupancy rate. In hospitality, we see the concept of 'rates' more frequently than prices.

  • Euros

Only make your decisions in whole euros, don't use cents or other currencies. In filling out the amounts in the Team File, do not use decimals! Not in the prices and not in costs.

Five Team decisions on (sales) prices, creating revenues

As you can see in the example: if you mouseover the description of the decision (like cell B8 in this example) you will get more information regarding what the decision is all about. You are allowed to fill out the pink cells according to the instructions.
You will have to decide what prices you will charge (per room per night) for weekdays or weekends which serve the markets. In the pages under room prices, you can read a bit more on the history. Depending on your performance as a team and your choices made, you will get a certain occupancy rate and corresponding number of guests. These guest prices will bring your revenues in each of the five revenue categories, depending on the prices decided upon and this occupancy rate. So setting the prices too low (think of your cost price), even with a very high occupancy rate, might bring in revenue, but hardly any profit or even losses.
We offer you just 5 possibilities in prices to decide on; we realize that there are many, many more. But, to keep things logical and in line, you will have to do with these five. You cannot influence how many people will stay in the room.

Example decisions on prices. Mouseover in row B gives you more info on the decision. You will also get an alert if the input is not okay. Be sure to explain in depth, with sources, arguments, and preferably calculations. When a year has passed, it will become greyed-out.


Limitations
Strongly recommended: Never change any of the five prices more than + or -20% per year to protect your hotel from high impact of too extreme changes.

  • 1. Weekend last-minute room price (or rate) per night

In the past, the average price was € 80. The last-minute price is the minimum price you will accept to fill up the empty rooms, the gaps in your occupancy.
The revenues after each year, comprise the number of booked rooms (occupancy rate) at the weekend, times the average (sales) prices: so (last-minute and rack rate) divided by two.

  • 2. Weekend rack rate room price (or rate) per night

In the past the average price was € 100. The rack rate is the highest price you will get.
The revenues after each year, comprise the number of booked rooms (occupancy rate) in the weekend, times the average (sales) prices: so (last-minute and rack rate) divided by two.

  • 3. Weekday last-minute room price (or rate) per night

In the past the average price was € 100. The last-minute price is the minimum price you will accept.
The revenues after each year, comprise the number of booked rooms (occupancy rate) during weekdays, times the average (sales) prices: so (last-minute and rack rate) divided by two.

  • 4. Weekday rack rate room price (or rate) per night

In the past the average price was € 140. The rack rate price is the highest price you will get.
The revenues after each year, comprise the number of booked rooms (occupancy rate) on weekdays, times the average (sales) prices: so (last-minute and rack rate) divided by two.

  • 5. Banqueting and other activities price (or rate) per person per day

In the past the average price was € 28. You can not skip this activity totally, so price 0 is not allowed. The occupancy rate of the rooms also has an impact on the numbers of booked banqueting arrangements and other activities.

  • Other ideas

Of course there are many other possible prices and price systems, apart from last-minute and rack rate. Though, we focus on the total of five price settings; explain them more in depth and find benchmarks for this and give links arguing why you chose these prices for these targetgroups.
If you think a specific, different price is absolutely necessary, use the marketing costs, or other costs, to promote this. Use the row Extra Information to explain your plan to your coach. Then be sure to make calculations on costs and revenues and predicted additional revenues compared to the normal situation. Your coach might reward this with a bonus, if consistent, well-thought-out etc. If so, you could find additional results from this at the bonus or fines (row 51-52). This will always be profit or losses, not revenues. But please (first) focus on the regular opportunities, there are plenty.


Five Team decisions to be made on costs

Of course, you cannot influence the Fixed costs which are in your operating review, nor can you influence the variable costs; they are set by your occupancy rate.
Other things you will have to make decisions upon are decisions 6 - 10. This will create costs you decide on and which will be visible directly in your operating review after any year. On mouseover in the file you'll get more info on these choices. All these decisions bring extra costs compared to the past, as Christina did not spend money on these elements. Try to explain, for each form of cost what you expect it to bring you. So, how will you earn back these costs and what will they bring additionally? All costs will have an effect, but only in the year you make them. For maximum effect you will have to repeat them in subsequent years.
In case you think you have an idea like this, please also explain this to your coach at the end of your Team File.

Example decisions to be made on costs. Mouseover in row B gives you more info on the decision. You will also get an alert if the input is not okay. Be sure to explain in depth, with sources arguments, and calculations. When a year has passed, it will be greyed-out.

Impact

Check the impact of changing the Sales price, on these pages.
Or check Revenue per room to get even more information.


  • 6. Marketing costs

No costs for this in the past: 0 or N/A means not available.
This is the total spending for all paid marketing actions in the past: maybe this is on the low side? There was very little going on at the Emerald Forest Hotel, especially nothing on social media or affiliates and there was also not negotiating with distributors and partners. You could also include costs related to clean air, to green energy, to social responsibility, ecological footprint etc. So, this is probably a decision you cannot afford to leave out.
Limitations
You can use any amount between € 0 and € 200,000 per year, to protect your hotel from the high impact of too extreme changes.

  • 7. Staff development costs

No costs for this in the past: 0 or N/A means not available.
Apart from the salaries, extra costs can be incurred here, such as spendings on necessary skills and resources to support the staff member's career goals and the organization's business needs. This will be things like training, developing skills or for instance courses on hospitality.
Limitations

You can use any amount between € 0 and € 100,000 per year, to protect your hotel from the high impact of too extreme changes.

No costs for this in the past: 0 or N/A means not available.
You can choose to spend a maximum of € 900,000 each year on additional investments. This investment is the number you should fill out in your Team File decisions. The depreciation costs related to NEWLY planned investments will be visible after each year in your results, as depreciation costs of new investments. And, as you can see on the footage available, the hotel is in need of some additional investments in the rooms, facilities etc.
Check the specific investments page on this. In your decisions you fill out the investment itself: You will find the corresponding depreciations on your operating review. All your investments will be linearly depreciated in 4 years without any residual value; there is no choice in this, so you fill out the investment itself. The depreciation costs during all four operational years will be calculated by the program. There will be no other costs of new investments, like interest. For the rest see the max numbers in the table underneath. So if you want to invest € 900,000 in year 1, fill this out and the system will create € 225,000 (row 44 in the results tab) in year 1 as depreciation costs, as well as in subsequent years. Investments have a direct effect in the year they are made, so you can make them in any year of the Game, including the last year. So an investment will have effect during more years: four to be precise.
The costs of equipment and furniture bought in hospitality are totally different from what you would buy privately (at a furniture store like the Ikea): realize that. There are standards for safety, usability, long-wearing, cleaning, and many other reasons to buy professional material.

Limitations
You can make any investment with a maximum of € 900,000 each year. So over four years you can invest a maximum of 4 x € 900,000 = € 3,600,000. The costs of this will be the depreciation, automatically calculated and always linear over four years (a simplification, no residual value, no interest, but still). The maximum is built in to protect your hotel from too extreme changes and costs.

  • 9. Market research package costs

No costs for this in the past: 0 or N/A means not available.
These are the costs of buying information from Top Research which will be analysing the past year which will be visible, if bought, on your results tab after any year. It will give you a benchmark on the prices asked in the market ('S', small package) as well as the costs incurred in the market ('L', large package).
Limitations

You can use chose the amount from the choice box so € 0 buys you no information, € 25,000 buys you the 'S' small package and € 50,000 gets you the 'L', large package. Elements not paid for will show up in your operating review as 'Not bought'. Make sure you explain very clearly in your explanations why you think buying this will benefit your company. The company Top Research will carry out the research and report to you.

  • 10. Other costs

No costs for this in the past: 0 or N/A means not available.
This could be anything apart from the groups mentioned above. So things like supporting the distributions chain, cooperation with partners, maybe legal costs. Maybe a contribution to tourist information offices activities.
Make additional calculations explaining the profit it might bring. If you explain the pros and cons and the costs and the results and the expected additional profit of a specific action, your coach might reward this with a bonus. A bonus is net, it is directly added up to your profit in any year.
Limitations

You can use any amount between € 0 and € 100,000 per year, to protect your hotel from the high impact of too extreme changes.

Impact

Check the impact of these additional costs on your Cost price and so Sales prices, on these pages.
Or check Revenue per room to get even more information.

Overspending

If you would choose the maximum available for all options, you would spend an additional € 1,350,000. This is next to the variable costs and the fixed costs. These are additional costs, the so called costs of your team decisions.

  • Next to this, you have these regular variable costs depending on the occupancy rate, and
  • fixed costs which you can not influence (only the occupancy rate does so with the variable costs).

So, keep an eye on the net profit which is around € 450,000 as you take over, to keep things in balance.

No decisions or no explanations

If any team fails to deliver the decisions or explanations before the deadline this is a serious problem. This could end in a fine or a low marking from your coach: This will also jeopardize your occupancy rate. You might also get fined.

Quality of decisions and assignment

Check the occupancy rate page, to get more information on how this is built up. The quality of your decisions, explanations and assignments play a major role in this.
After all, your argument is assessed by the coaches, who create your dashboard. You will only see the results after the coach has 'released' them.



→ GO! Top of this page

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