Imagine that you are managing a hotel with 120 rooms. In order to track the occupancy rates you use 6 weeks trailing period. You just received information that 102 out of 120 rooms were occupied on Wednesday (10/16/13). Using updated information on the occupancy rates and the occupancy rates for the last 6 Wednesdays in Table 1, calculate the rolling average for Wednesdays. Table 1 Date Occupancy O 64% O 57% 82% O 61% 09/04/13 09/11/13 09/18/13 09/25/13 10/02/13 10/09/13 42.5% 55% 60% 45% 62.5% 77.5%

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.6: Moving Averages Models
Problem 21P: The file P13_21.xlsx contains the weekly sales of rakes at a hardware store for a two-year period....
icon
Related questions
Question

Question     Z
.
Full explain this question and text typing work only     
We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line  .  

Imagine that you are managing a hotel with 120 rooms. In order to track the
occupancy rates you use 6 weeks trailing period. You just received information that
102 out of 120 rooms were occupied on Wednesday (10/16/13).
Using updated information on the occupancy rates and the occupancy rates for the
last 6 Wednesdays in Table 1, calculate the rolling average for Wednesdays.
Table 1
Date
Occupancy
O 64%
O 57%
82%
O 61%
09/04/13 09/11/13 09/18/13
42.5%
55%
60%
09/25/13 10/02/13 10/09/13
45%
62.5%
77.5%
Transcribed Image Text:Imagine that you are managing a hotel with 120 rooms. In order to track the occupancy rates you use 6 weeks trailing period. You just received information that 102 out of 120 rooms were occupied on Wednesday (10/16/13). Using updated information on the occupancy rates and the occupancy rates for the last 6 Wednesdays in Table 1, calculate the rolling average for Wednesdays. Table 1 Date Occupancy O 64% O 57% 82% O 61% 09/04/13 09/11/13 09/18/13 42.5% 55% 60% 09/25/13 10/02/13 10/09/13 45% 62.5% 77.5%
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,