Forecasting weekday occupancy between two years

T

titushanke

Hi all,

I am tackling a little problem here with forecasting occupancy of
hotel on a given day of the month next year in relation to this year.
An example.

This Year January occupancy was split amongst the weekdays as follows:
Mondays 20 rooms
Tuesdays 22 rooms
Wednesdays 23 rooms
Thursdays 30 rooms
Fridays 40 rooms
Saturdays 40 rooms
Sundays 15 rooms

This year in January, we had:

5 Mondays
4 Tuesdays
4 Wednesdays
4 Thursdays
4 Fridays
5 Saturdays
5 Sundays

Next year in January, we will have:

5 Mondays
5 Tuesdays
4 Wednesdays
4 Thursdays
4 Fridays
4 Saturdays
5 Sundays

My rooms are split up amongst the weekdays this year, meaning that m
22 rooms on Tuesdays fall into the five Tuesdays of January differentl
(one Tuesday 3 rooms, the other Tuesday maybe 5 rooms etc.).

For next year I would like to do a projection of my rooms by weekda
again. The challenge is that I obviously have to work with WHOL
numbers and can't allow 2.17253 rooms or something like this t
happen.

Is there any logic or formula with which I can even out the 22 rooms o
the new year Tuesdays? The single Tuesday doesn't really matter, as lon
as all the rooms get split up over the Tuesdays somewhat evenly...

Thanks for any ideas...
Useless to say, that I have to be able to easily repeat this for al
days of the week and all days of the month...


THANKS!!!! :) :) :)

Titus
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top