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 5351
1 February 2 5511
1 March 3 6544
1 April 4 6545
1 May 5 5455
1 June 6 4607
1 July 7 4699
1 August 8 3715
1 September 9 3361
1 October 10 3253
1 November 11 3348
1 December 12 4217
2 January 13 4246
2 February 14 4747
2 March 15 5419
2 April 16 4760
2 May 17 4473
2 June 18 3937
2 July 19 3344
2 August 20 2872
2 September 21 2535
2 October 22 2787
2 November 23 2712
2 December 24 3092
3 January 25 3313
3 February 26 3638
3 March 27 3679
3 April 28 3788
3 May 29 3609
3 June 30 2889
3 July 31 2453
3 August 32 2158
3 September 33 1877
3 October 34 1758
3 November 35 1992
3 December 36 2342

Group of answer choices

1. Linear Trend (Time Series Regression)

2. Weighted Moving Average

3. Simple Moving Average

4. Exponential Smoothing

5. Linear Trend (Time Series Regression) with Seasonality

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!