Question

Calculate Weighted Average Occupancy and ADR based on the following information.
(Round to the nearest 1% and $1)
Hotel   # of Rooms     Occupancy in June   ADR in June
A Hotel   200   90%   $159
B Hotel   205   86%   148
C Hotel   210   79%   136
D Hotel   300   78%   121
E Hotel   335   70%   119
Total   1,250   ?   ?

Weighted Average Occupancy =______________

Answer 1

Hotel	No.of Rooms	Occupancy in june	ADR in June	Weighted averageOccupancy	Weighted Average ADR
Hotel A	200	90%	$159	180 (200 x 90%)	$28620 (200 x 90% x $159)
Hotel B	205	86%	148	176 (205 x 86%)	26092 (205 x 86% x 148)
Hotel C	210	79%	136	166 (210 x 79%)	22562 (210 x 79% x 136)
Hotel D	300	78%	121	234 (300 x 78%)	28314 (300 x 78% x 121)
Hotel E	335	70%	119	235 (335 x 70%)	27906 (335 x 70% x 119)
Total	1250	79% (991/1250)	135 (133494/991)	991	133494