Question: Moving average is the forecasting model that Blue & Red utilizes for its room revenue projections. The operational data for the weekdays of a certain
Moving average is the forecasting model that Blue & Red utilizes for its room revenue projections. The operational data for the weekdays of a certain week is given below: Weekdays Available # of Rooms Occ. % ADR Day #1 300 55.00 $102.10 Day #2 300 67.00 $108.34 Day #3 300 59.00 $110.12 Day #4 300 81.00 $114.43 Day #5 300 86.00 $121.67 Calculate the room revenue for day #6 and #7 RESPECTIVELY for Blue & Red Inn by implementing three-day moving average forecasting model. $25,814.30 dor day #6 and $24.712.40 for day #7 $27,400.50 dor day #6 and $28,000.16 for day #7 $21.711.18 dor day #6 and $26,588.70 for day #7 $26.229.53 dor day #6 and $28,47563 for day #7
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
