Other
Excel sheet Pricing & capacity
- Course
- Institution
Excel part of the report.
[Show more]
Seller
Follow
182266
Reviews received
Content preview
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller 182266. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $4.70. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
55628 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now