The manager of a travel agency asked you to come up with a forecasting technique that...

90.2K

Verified Solution

Question

Statistics

The manager of a travel agency asked you to come up with aforecasting technique that will best fit to the actual demand forpackaged tours. You have observed and recorded the actual demandfor the last 10 periods. You also identified two possibletechniques for consideration: 2-month moving averages (F1), andexponential smoothing (F2) with a smoothing constant of 0.40. UsingCumulative Forecasting Error (CFE) and Mean Absolute Deviation(MAD) as your performance measures you will determine the techniquethat will best fit to the actual demand data provided in thefollowing table.
  
STEP 1: Given start forecast values in period 3,compute forecast values from period 4 to 10. You are asked toprovide the forecast values for period 6 and 10 for bothtechniques.

2-Month MA

Exponential

Period

Demand

F1

F2

1

128

--

--

2

172

--

--

3

89

150

129

4

143

5

72

6

140

7

129

8

140

9

98

10

174


  
  
STEP 2: Using data from period 3 to period10,
  
Provide the performance measures for F1 technique:
  
            CFE=                         MAD=  
  
Provide the performance measures for F2 technique:
  
            CFE=             MAD=  
  
Based on these measures, which technique best fit to your data?(Enter F1 or F2) =  
NOTE: All computed forecast values should berounded to the nearest integer (no decimal, for example 190).Performance measures (CFE and MAD) must be rounded to the nearesthundredth (two decimals after the dot, for example 30.99).
  
  

Answer & Explanation Solved by verified expert
4.5 Ratings (901 Votes)
AnswerBelow is the screenshot of the formula applied Below is the screenshot of the result    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students