The Triton Energy Corporation explores for and produces oil and gas. Company president Gail Freeman wants to have her company's analyst forecast the company's sales per share for 2000. This will be an important forecast, since Triton's restructuring plans have hit a snag.The data are presented in Table shown below:
Year Sales per Share Year Sales per Share
1974 0.93 1987 5.33
1975 1.35 1988 8.12
1976 1.48 1989 10.65
1977 2.36 1990 12.06
1978 2.45 1991 11.63
1979 2.52 1992 6.58
1980 2.81 1993 2.96
1981 3.82 1994 1.58
1982 5.54 1995 2.99
1983 7.16 1996 3.69
1984 1.93 1997 3.98
1985 5.17 1998 4.39
1986 7.72 1999 6.85
a) Calculate all forecasting smoothing methods that you know (naïve, exponential smoothing, 2PMA, 3PMA, and ???) and determine the best method. Rank all the methods starting from the best. Support each method with a graph.
b) forecast sales per share for 2000, compare the results for this year from all methods and rank the methods.
c) Compute MAD, MSE. RMSE, MAPE and MPE