Question: Given the following data for two years, visualize/plot the data and indicate the most appropriate forecasting method if you need the forecast for each month

Given the following data for two years, visualize/plot the data and indicate the most appropriate forecasting method if you need the forecast for each month of Year 4.

Year Month Sales
1 January 1 5519
1 February 2 6143
1 March 3 6032
1 April 4 6513
1 May 5 6764
1 June 6 6085
1 July 7 6197
1 August 8 6709
1 September 9 6549
1 October 10 6415
1 November 11 7603
1 December 12 6803
2 January 13 7733
2 February 14 8053
2 March 15 7024
2 April 16 7675
2 May 17 7652
2 June 18 7847
2 July 19 7765
2 August 20 8566
2 September 21 9046
2 October 22 9372
2 November 23 8154
2 December 24 8956
3 January 25 8551
3 February 26 9508
3 March 27 9259
3 April 28 9294
3 May 29 9344
3 June 30 9127
3 July 31 9529
3 August 32 9294
3 September 33 9410
3 October 34 10480
3 November 35 10278
3 December 36 10423

Group of answer choices

1. Linear Trend (Time Series Regression) with Seasonality

2. Weighted Moving Average

3. Simple Moving Average

4. Linear Trend (Time Series Regression)

Exponential Smoothing

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!