Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Rev APR

Occupancy

ADR

Rev APR

Occupancy

ADR

Rev APR

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

Step: 1

The yeartoyear occupancy percent change fo... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Engineering Economics Analysis

Authors: Ted G. Feller

9th Edition

9780195168075

More Books

Students also viewed these Economics questions

Question

In a system with light damping (c Answered: 1 week ago

Answered: 1 week ago