Forecasting weekday occupancy between two years
 

Hi all,

I am tackling a little problem here with forecasting occupancy of a
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 my
22 rooms on Tuesdays fall into the five Tuesdays of January differently
(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 weekday
again. The challenge is that I obviously have to work with WHOLE
numbers and can't allow 2.17253 rooms or something like this to
happen.

Is there any logic or formula with which I can even out the 22 rooms on
the new year Tuesdays? The single Tuesday doesn't really matter, as long
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 all
days of the week and all days of the month...


THANKS!!!! :) :) :)

Titus.


--
titushanke
------------------------------------------------------------------------
titushanke's Profile: http://www.excelforum.com/member.php...o&userid=19997
View this thread: http://www.excelforum.com/showthread...hreadid=467476