Question: Question 2 - Forecasting (9 points] In a local travel agency, monthly sales of vacation packages are given in the table below. The company asked

Question 2 - Forecasting (9 points] In a local
Question 2 - Forecasting (9 points] In a local travel agency, monthly sales of vacation packages are given in the table below. The company asked you to suggest a forecasting technique that best suits their data. Month Sales MA WMA Deviation WMA Deviation| 1301 114 140 145 125 130 140 MAD a) [3 Points) Calculate forecast values for months 3 through 7 using a 2-months moving average. (Provide using the column MA in the table above and round your answer to the nearest whole number) b) (3 Points) Calculate forecast values for months 3 through 7 using a 2-months weighted moving average with weights 0.7 and 0.3, highest weight is for the most recent month. (Provide using the column WMA in the table above and round your answer to the nearest whole number) c) [2 points) Calculate the mean absolution deviation (MAD) for the two forecasting techniques. (Provide using the last two columns and the last row in the table above. Round MAD to one decimal point) d) [1 point] Which of these two techniques you would recommend to the travel agency and why

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 General Management Questions!