Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The data in the table below represent warehouse club and superstore sales in the eastern and central United States on a monthly basis. The data

The data in the table below represent warehouse club and superstore sales in the eastern and central United States on a monthly basis. The data are in millions of dollars.

a. Prepare a time-series plot of the data, and visually inspect that plot to determine the trend characteristics in this series.

b. Use and exponential smoothing model to develop a forecast of sales for the next 12 months, and explain which forecasting model is the best choice. Plot the actual and forecast values. Determine the MAPE for the model during the historical period.

Date Sales
Jan-02 2,580
Feb-02 2,616
Mar-02 2,838
Apr-02 2,985
May-02 3,258
Jun-02 3,107
Jul-02 3,097
Aug-02 3,288
Sep-02 3,077
Oct-02 3,429
Nov-02 4,011
Dec-02 5,739
Jan-03 2,877
Feb-03 2,885
Mar-03 3,259
Apr-03 3,454
May-03 3,771
Jun-03 3,667
Jul-03 3,743
Aug-03 3,792
Sep-03 3,699
Oct-03 4,082
Nov-03 4,727
Dec-03 6,672
Jan-04 3,560
Feb-04 3,575
Mar-04 4,220
Apr-04 4,282
May-04 4,594
Jun-04 4,691
Jul-04 4,629
Aug-04 4,795
Sep-04 4,632
Oct-04 5,067
Nov-04 5,746
Dec-04 7,965
Jan-05 4,317
Feb-05 4,118
Mar-05 4,855
Apr-05 4,999
May-05 5,343
Jun-05 5,392
Jul-05 5,274
Aug-05 5,435
Sep-05 5,217
Oct-05 5,460
Nov-05 6,288
Dec-05 8,403
Jan-06 4,758
Feb-06 4,914
Mar-06 5,431
Apr-06 5,474
May-06 6,124
Jun-06 6,027
Jul-06 5,914
Aug-06 6,244
Sep-06 5,808
Oct-06 6,373
Nov-06 6,994
Dec-06 9,018
Jan-07 5,694
Feb-07 5,431
Mar-07 6,240
Apr-07 6,101
May-07 6,849
Jun-07 6,694
Jul-07 6,815
Aug-07 6,948
Sep-07 6,450
Oct-07 7,190
Nov-07 7,738
Dec-07 9,769
Jan-08 6,665
Feb-08 6,400
Mar-08 7,277
Apr-08 7,584
May-08 8,169
Jun-08 8,179
Jul-08 8,118
Aug-08 8,284
Sep-08 7,962
Oct-08 8,636
Nov-08 9,433
Dec-08 11,786
Jan-09 8,082
Feb-09 7,761
Mar-09 8,994
Apr-09 8,803
May-09 9,712
Jun-09 9,843
Jul-09 9,769
Aug-09 9,944
Sep-09 9,582
Oct-09 10,209
Nov-09 11,115
Dec-09 14,995
Jan-10 9,183
Feb-10 9,478
Mar-10 10,751
Apr-10 10,518
May-10 11,349
Jun-10 11,728
Jul-10 11,590
Aug-10 11,871
Sep-10 11,336
Oct-10 11,986
Nov-10 13,130
Dec-10 16,694
Jan-11 11,195
Feb-11 10,919
Mar-11 12,389
Apr-11 12,619
May-11 13,489
Jun-11 13,620
Jul-11 13,438
Aug-11 14,084
Sep-11 13,172
Oct-11 14,040
Nov-11 15,759
Dec-11 19,992
Jan-12 13,162
Feb-12 13,394
Mar-12 15,285
Apr-12 14,467
May-12 16,086
Jun-12 16,027
Jul-12 15,622
Aug-12 16,360
Sep-12 14,714
Oct-12 15,894
Nov-12 18,152
Dec-12 22,089
Jan-13 15,161
Feb-13 15,342
Mar-13 16,997
Apr-13 16,623
May-13 18,064
Jun-13 17,605
Jul-13 17,746
Aug-13 18,907
Sep-13 16,735
Oct-13 18,146
Nov-13 20,336
Dec-13 24,665
Jan-14 17,686
Feb-14 17,908
Mar-14 18,691
Apr-14 19,030
May-14 20,623
Jun-14 19,596
Jul-14 20,122
Aug-14 20,029
Sep-14 18,669
Oct-14 20,518
Nov-14 21,967
Dec-14 27,584
Jan-15 19,315
Feb-15 19,186
Mar-15 21,211
Apr-15 20,985
May-15 22,385
Jun-15 22,223
Jul-15 22,602
Aug-15 22,456
Sep-15 21,418
Oct-15 23,092
Nov-15 24,598
Dec-15 30,706
Jan-16 21,692
Feb-16 21,699
Mar-16 23,402
Apr-16 24,046
May-16 24,881
Jun-16 24,602
Jul-16 24,631
Aug-16 24,831
Sep-16 23,603
Oct-16 24,608
Nov-16 26,705
Dec-16 34,023
Jan-17 23,837
Feb-17 23,438
Mar-17 26,305
Apr-17 25,429
May-17 27,152
Jun-17 27,218
Jul-17 26,722

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Internal Auditing Assurance & Consulting Services

Authors: Kurt F Reading, Paul J Sobel, Urton L Anderson, Michael J Head, Sri Ramamoorti

1st Edition

0894136100, 9780894136108

More Books

Students also viewed these Accounting questions

Question

Explain the difference between r and r.

Answered: 1 week ago

Question

What steps will Sara need to take to conduct a benefit audit?

Answered: 1 week ago