Question: Use the following spreadsheet to answer question 4 6: A B C D E F G H I This Year Last Year Percent Change Occupancy

Use the following spreadsheet to answer question 4 6:

A

B

C

D

E

F

G

H

I

This Year

Last Year

Percent Change

Occupancy

ADR

RevAPR

Occupancy

ADR

RevAPR

Occupancy

ADR

RevAPR

1

Jan

75.65%

84.76

64.12

79.23%

81.94

64.91

2

Feb

71.50%

87.63

62.65

75.43%

88.85

67.02

3

March

57.29%

98.54

56.46

56.45%

100.07

56.49

4

April

82.27%

95.04

78.19

78.17%

95.24

74.45

5

May

96.35%

104.57

100.76

82.42%

116.93

96.38

6

June

78.90%

87.8

69.29

82.60%

93.86

77.5

  1. The year-to-year occupancy percent change for June (G6) is _______________________

  1. The year to year ADR percent change for June (H6) is ____________________________

  1. The year to year RevPAR percent change for June (I6) ___________________________

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!