Overig
Excel sheet Pricing & capacity
- Instelling
- NHTV (NHTV)
Excel part of the report.
[Meer zien]Voorbeeld 2 van de 10 pagina's
Voorbeeld 2 van de 10 pagina's
In winkelwagengesponsord bericht van onze partner
Voorbeeld van de inhoud
ONLY FILL THE YELLOW CELLS so, only these !!upload in LMS before May Friday 15th 24:00 (resit before June Friday 26th 24:00)
student name Noortje van Campenhout class: RH03
Your accommodation name: Preston palace accommodation url: www.prestonpalace.nl photo exterior obliged:
choose a mainly leisure accommodation
EXTRA INFORMATION ABOUT YOUR ACCOMMODATION
1.Type All inclusive (hotel, bungalowpark, camping, youthhostel, appartementcomplex, all inclusive, etc)
2. Location: Inland (binnenland, bergen, strand, bossen )
3. Climate: Maritime climate (Tropisch, subtropisch, zeeklimaat, bergklimaat)
4. Positioning Familie and Leisure (business, leisure, familie, jongeren)
ROUGH BUSINESS ORIENTATION 1 2
competitor 1 van der Valk theaterhotel accommodation 1 url: https://www.theaterhotel.nl/ eventually photo:
competitor 2 Huis van bewaring accommodation 2 url: https://sheetz.nl/huisvanbewaring/ eventually photo:
competitor 3 T Elshuys accommodation 3 url: https://www.elshuys.nl/ eventually photo: 3 4
competitor 4 B&B Sageland accommodation 4 url: https://www.sagenland.nl/ eventually photo:
competitor accommodation analyses (0-10) Preston palace
10
van der Valk Huis van pric
e 5
only grade 1 to 10: Preston palace theaterhotel bewaring T Elshuys B&B Sageland B&B Sageland van der Valk theaterhotel
0
qua
price ppn (just an indication level and relative)ce 8 7 8 9 4 lity
quality (**** or check tripadvisor)ty 7.5 7.5 9 7 9 T Elshuys Huis van bewaring
balance Q--p -0.5 0.5 1 -2 5
Preston palace
10
size (= relative compared to other 4)ze 9 9 6 9 1 price 5
B&B Sageland van der Valk theaterhotel
0
child friendly (the more is not old aged friendly) fr 5 0 2 3 2 size
T Elshuys Huis van bewaring
business friendly (te more is NOT tourism friendly)fr 1 7 5 5 3
Preston palace
10
domestic targetgroup (the more is NOT inbound) c 8 6 7.5 5 3 price 5
B&B Sageland van der Valk theaterhotel
0
child
all inclusive (the more is NOT self service) cl 10 8 6 7 5 fr
T Elshuys Huis van bewaring
Preston palace
10
price 5
B&B Sageland van der Valk theaterhotel
0
busi
nessf
r
T Elshuys Huis van bewaring
Preston palace
10
price 5
B&B Sageland van der Valk theaterhotel
0
do
mes
tic
T Elshuys Huis van bewaring
Preston palace
10
price 5
B&B Sageland van der Valk theaterhotel
0
all
incl
T Elshuys Huis van bewaring
, upload in LMS before May Friday 15th 24:00 (resit before June Friday 26th 24:00)
student name Noortje van Campenhout
Your accommodation name: Preston palace url: www.prestonpalace.nl
physical capacity = nr of rooms/camping
step 1 Q capacity spots/bungalows/houses x 318 physical units
nr of weeks = 52 weeks (in real business often number of nights are counted)
total sequential capacity 16,536 sequential units
Although the price is
communicated per weekend or
step 2 P price average price/night week or..., please fill per night: € 260.00 x 7 nights per week = 7
x 7 = average P/week 1,820 Euro's per week (in rounded numbers!)
step 3 O max turnover (PXQ=O) per week € 578,760 Euro's per week
per year € 30,095,520 Euro's per year
step 4 occupation average whole year (your estimation in %) 85% max 100% !
results in: utilized capacity per week 270 physical units per week
utilized capacity per year 14,056 sequential units per year
realistic turnover (PXQ=O) per week € 491,946 Euro's per week
per year € 25,581,192 Euro's per year
go to next sheet 'table'
step 5 divide occupation per week (= differentiation) differing occupation (step 5) and differing prices (step 6) depends from several
go to table and fill realistic occupation per week in column J items of which 3 most important:
1. Location (mountains, beach, woods)
step 6 divide prices per week depending on holidays, climate, competition 2. Climate (Dutch rainy, Spanish subtr)
go to table and fill realistic prices per week in column V 3. Positioning (business, leisure, family)
step 7 a+b a calculate RevPAR remember module INTO Y1
Turnover= Available Rooms in
Revenue period: RevPAR
example (!) RevPAR week 7 € 483,487 318 € 1,520.40 we calculated for you; you're welcome
week 1-4 (=including wk 4) € 1,575,372 1,272 € 1,238.50 take care; your sequential
whole year (wk 1-52) € 25,035,711 16,536 € 1,514.01 capacity is changing!!
give your short motivated opinion about these 3 grades The RevPAR of week 7 is the highest. This has to do with the fact that week is 84% which is avarage
but the price is sligthly higher than average.
b Calculate NRevPAR NRevPAR = (Room Revenue – Distribution Costs) / Number of Available Rooms
First we have to calculate your distribuition costs
share of indirect distribution (booking.com hotels.com) * 5% of your average %-occupation step 5 in table (cel 'table L62') 84%
costs of indirect distribution (in % of price) 25% average provision whole year
z total costs of indirect distribution in year € 19.02
* take care; with 'share' we mean share of occupation (not share of total capacity)
turnover = Available Rooms in
revenue minus costs of distribution period: NRevPAR
week 7 € 483,487 € 6,043.59 318 € 1,501.40 we calculated for you; you're welcome
week 1-4 € 1,575,372 € 19,181.39 1,272 € 1,223.42
(=including take care; your sequential
year € 25,035,711 € 305,538.34 16,536 € 1,495.54 capacity is changing
week 4)
give your short motivated opinion about these 3 grades Week 7 also has the highest NRevPAR. All weeks need to pay costs, so the highest is the same.
step 8 from here you use the word document (make yourself a word document named "<your name> Hand in step 8+9 and End Report P+C" ) and upload when finished in LMS
1 Till now (step 1-7) you acted as a Yield- or Revenue Manager who proposed the budget for the coming year. your turnover in budget € 25,035,711
2 From now on (from step 8) you act as if you are IN the current year. And your boss wants you to increase turnover your boss want 0,5% increase € 125,179
with 0,5% extra budget. PLEASE do not worry about this exact amount; round it up or down; it is allowed. of turnover :
3 Look to your 3 final graphics (see graphics row 45-60). Choose yourself a week which in which you think you can
and will increase turnover with the demanded extra turnover.
you choose one week use the word document
current accommodations sold use the word document
current turnover in this week use the word document
why did you choose this week? use the word document
now your aim is to get more money out of this particular week. How? use the word document
what is your a. new offer (think of price elasticity) use the word document
b. how much EXTRA SALES do you expect use the word document
c. how much EXTRA MONEY do you expect use the word document
d. what is the price elasticity use the word document
e. target group profile use the word document
f. target group size use the word document
g. motivation choice targetgroup use the word document
h. medium (how to approach the targetroup) use the word document
i. how you handle intermediaires / channels use the word document
j. timing (when you start AND close offer) use the word document
step 9 GO THE EXTRA MILE ! not graded, but you will receive personal feed back in next block
k. show the complete advertising or landingpage use the word document
incl branding use the word document
look & feel use the word document
slogan use the word document
visual use the word document
conditions use the word document
etc
Voordelen van het kopen van samenvattingen bij Stuvia op een rij:
Verzekerd van kwaliteit door reviews
Stuvia-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!
Snel en makkelijk kopen
Je betaalt supersnel en eenmalig met iDeal, creditcard of Stuvia-tegoed voor de samenvatting. Zonder lidmaatschap.
Focus op de essentie
Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper 182266. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €4,39. Je zit daarna nergens aan vast.
Is Stuvia te vertrouwen?
4,6 sterren op Google & Trustpilot (+1000 reviews)
Afgelopen 30 dagen zijn er 55628 samenvattingen verkocht
Opgericht in 2010, al 14 jaar dé plek om samenvattingen te kopen