Question

chapter 9.2 for under the hood and a rib farm which is this month last three months last four months B 26C 26B 27C 27B 28C 28 I know these are right however I need the formula and I hope none of formula before but it was like not the right one hell did the Zance or's for example the one 5248 how was the calculated because I know the numbers right but I can't seem to figure out how to get to that number I need help please

Comp Set Index 58.1 98.45% 5 7.7 95.49% 55.6 92.27% 15 9.2 16 City Center Novotel Performance: 17 Occupancy % Novotel 57.2 18 This month 19 Last 3 months 55. 1 20 Last 12 months 51.3 21 ADR 22 This month 266.57 23 Last 3 months 244.91 24 Last 12 months 231.45 5 RevPAR 6 This month $152.48 7 Last 3 months $134.95 3 Last 12 months $118.73 9.3 270.15 2 69.69 268.95 98.67% 90.81% 86.06% -- $156.96 $155.61 $149.54 Property Number of Supply

i know the $152.48 $156.96

$134.95 $155.61

$118.73. $149.54.

are all correct however need to know how this was calculated in order to receive that answer ?

Answer 1

Answer to the question is very simple
Values in given cells are calculated as follows:
Particulars		Given Answers
			Calculations	Final Answer
		Novotel
This Month	Cell B26	$152.48	=266.57*57.20%	152.47804	i.e. ADR Rate * Occupancy %
Last 3 Months	Cell B27	$134.95	=244.91*55.10%	134.94541	i.e. ADR Rate * Occupancy %
Last 12 Months	Cell B28	$118.73	=231.45*51.30%	118.73385	i.e. ADR Rate * Occupancy %
Particulars		Given Answers
			Calculations	Final Answer
		Comp Set
This Month	Cell C26	$156.96	=270.15*58.10%	156.95715	i.e. ADR Rate * Occupancy %
Last 3 Months	Cell C27	$155.61	=269.69*57.70%	155.61113	i.e. ADR Rate * Occupancy %
Last 12 Months	Cell C28	$149.54	=268.95*55.60%	149.5362	i.e. ADR Rate * Occupancy %