MGT 3332---Forecasting Case Analysis

profileTmanuel
CopyofCopyofForecastingDatasetUpdatedFall2018-1.xlsx
Home>Business & Finance homework help>Operations Management homework help>MGT 3332---Forecasting Case Analysis

Sheet1

MGT 3332 Forecasting Dataset
Fall 2018
Month/Yr. PERIOD PRICE AIP DIFF ADV DEMAND
Jan. 2016 1 6.1 5.8 -0.3 5.3 12.4
2 5.75 6 0.25 6.75 13.3
3 5.7 6.3 0.6 7.25 14.5
4 5.7 5.7 0 7.3 14.1
5 5.6 5.85 0.25 7.2 14
6 5.6 5.8 0.2 6.5 13.5
7 5.6 5.75 0.15 6.75 13.2
8 6.3 5.85 -0.45 6.89 11.9
9 6.4 5.65 -0.75 5.8 11.3
10 6.2 6 -0.2 5.5 11.12
11 5.9 6.1 0.2 6.5 11.8
12 5.9 6 0.1 6.25 12.8
Jan. 2017 13 5.7 6.1 0.4 7 13.3
14 5.75 6.2 0.45 6.9 14.3
15 5.75 6.1 0.35 6.8 15.5
16 5.8 6.1 0.3 6.8 15.4
17 5.7 6.2 0.5 7.1 15.1
18 5.8 6.3 0.5 7 14.8
19 5.7 6.1 0.4 7.2 14.5
20 5.8 5.75 -0.05 7.5 14
21 5.8 5.75 -0.05 7.8 13.8
22 5.75 5.65 -0.1 8.2 13.8
23 5.7 5.9 0.2 8.3 14.1 `
24 5.55 5.65 0.1 8.4 15.4
Jan. 2018 25 5.6 6.1 0.5 8.9 15.8
26 5.65 6.25 0.6 9.1 16.5
27 5.7 5.65 -0.05 9.3 17.2
28 5.75 5.75 0 9.4 17.6
29 5.8 5.85 0.05 9.3 17.3
30 5.3 6.25 0.95 9.4 17.1
31 5.4 6.3 0.9 9.5 16.8
32 5.7 6.4 0.7 9.6 16
Sep. 2018 33 5.9 6.5 0.6 9.7 15.9
Oct. 2018 34
Nov. 2018 35
Dec. 2018 36

Sheet2

Sheet3