Question

How to calculate the above questions? What is the formula for weekend index?

Answer 1

Answer--A       Hotel-1	Total rooms=	400
	Sold Room -Nights	Average Daily Rate(ADR)(Rooms Revenue/Rooms sold) (Given)	Occupancy=Rooms sold/Total no. of rooms		RevPar=Total rooms revenues/Total no. of rooms available
1. Friday	350	200	350/400=	87.50%	(350*200)/400=	175
2. Saturday	300	190	300/400=	75.00%	(300*190)/400=	142.5
3. Weekend Average(1+2)/2	325	195		81.25%		158.75
4. Weekend Index(3/Total av. In the area as in answer B)	195/585=	0.33	81.25%/232.25%=	34.98%	158.75/455.45=	0.35	Weekend average/Weekend average in the area
							Hotel-1
Hotel-2	Total rooms=	300
	Sold Room -Nights	Average Daily Rate(ADR)(Rooms Revenue/Rooms sold) (Given)	Occupancy=Rooms sold/Total no. of rooms		RevPar=Total rooms revenues/Total no. of rooms available
1. Friday	250	210	250/300=	83.33%	(250*210)/300=	175
2.Saturday	200	180	200/300=	66.67%	(300*190)/400=	120
3. Weekend Average(1+2)/2	225	195		75.00%		147.5
4. Weekend Index(3/Total av. In the area as in ans. B)	195/585=	0.33	75.0%/232.25%=	32.29%	147.5/455.45=	0.32	Weekend average/Weekend average in the area
Hotel-3	Total rooms=	250
	Sold Room -Nights	Average Daily Rate(ADR)(Rooms Revenue/Rooms sold)	Occupancy=Rooms sold/Total no. of rooms		RevPar=Total rooms revenues/Total no. of rooms available
1. Friday	200	220	200/250=	80.00%	(200*220)/250=	176
2. Saturday	180	170	180/250=	72.00%	(180*170)/250=	122.4
3. Weekend Average(1+2)/2	190	195		76.00%		149.20
4. Weekend Index(3/Total av. In the area as in ans. B)	195/585=	0.33	76.0%/232.25%=	32.72%	149.2/455.45=	0.33	Weekend average/Weekend average in the area

Ans. B	Summary of
	Weekend Averages	ADR		Occup.		RevPar
	Sold Room -Nights	Average Daily Rate(ADR)(Rooms Revenue/Rooms sold) (Given)	Occupancy=Rooms sold/Total no. of rooms		RevPar=Total rooms evenues/Total no.of rooms available
Hotel-1	325	195		81.25%		158.75
Hotel-2	225	195		75.00%		147.5
Hotel-3	190	195		76.00%		149.2

		ADR		Occup.		RevPar
Total weekend av. of 3 hotels		585		232.25%		455.45

From the above Table, amongst the 3 hotels, Hotel--1 has the best performance for the weekend

with a highest room occupancy ratio of 81.25% &

highest RevPar ie, revenue per total no. of rooms in the hotel, of $ 158.75

Also, weekend indices for ADR are the same as for the other 2 hotels and

Occupancy & RevPar are better for Hotel -1 compared to the other 2 hotels