Question

In: Statistics and Probability

Consider the following given information, determine the 3-year moving averages that would have been used to...

Consider the following given information, determine the 3-year moving averages that would have been used to forecast the sales (in millions) for the years subsequent to each group of three years. Determine the forecast error associated with each forecast.

Year(t) 1993/ 1994 /1995 /1996 /1997 /1998 /1999 /2000

Profit Y(t) 0.9 / 1.1 /1.2 / 1.3 / 1.4 / 1.5 / 1.6 / 1.7

You may create a table with below information.

Year / Sales in millions / 3-year Moving Forecast / Forecast error / Absolute error

b) In the below table, by using the actual level of sales for 1994 of 1.1 million dollars as the “seed” forecast for 1995, determine the forecast for each annual sales amount by the method of simple exponential smoothing. First use a smoothing constant of alpha = 0.8, then use a smoothing constant of alpha = 0.2, and compare the two sets of forecasts.

Year(t) 1993 /1994 /1995 /1996 /1997 /1998 /1999 /2000

Sales in millions Y(t) 0.9 /1.1 /1.5 /1.3 /1.1 /1.7 /1.9 /2.3

Solutions

Expert Solution

Note: The following data table

Year(t) 1993/ 1994 /1995 /1996 /1997 /1998 /1999 /2000

Profit Y(t) 0.9 / 1.1 /1.2 / 1.3 / 1.4 / 1.5 / 1.6 / 1.7

is not used as it lists the profits. However, both the parts refer to forecasting sales in millions

Let be the actual sales in millions and be the forecasted sales in millions for period t

a) A 3-year Moving Forecast for period t is

Forecast error is

Absolute error is

Get the following

Year(t) Sales in millions Y(t) 3-year Moving Forecast Forecast error Absolute error
1993 0.9
1994 1.1
1995 1.5
1996 1.3 (0.9+1.1+1.5)/3=1.167 (1.3-1.167)=0.133 |0.133|=0.133
1997 1.1 (1.1+1.5+1.3)/3=1.3 (1.1-1.3)=-0.2 |-0.2|=0.2
1998 1.7 (1.5+1.3+1.1)/3=1.3 (1.7-1.3)=0.4 |0.4|=0.4
1999 1.9 (1.3+1.1+1.7)/3=1.367 (1.9-1.367)=0.533 |0.533|=0.533
2000 2.3 (1.1+1.7+1.9)/3=1.567 (2.3-1.567)=0.733 |0.733|=0.733

ans: A 3-year Moving Forecast is

Year(t) Sales in millions Y(t) 3-year Moving Forecast Forecast error Absolute error
1993 0.9
1994 1.1
1995 1.5
1996 1.3 1.167 0.133 0.133
1997 1.1 1.300 -0.200 0.200
1998 1.7 1.300 0.400 0.400
1999 1.9 1.367 0.533 0.533
2000 2.3 1.567 0.733 0.733
MAD 0.400

The mean absolute deviation is

b) Exponential forecast for period t, with  a smoothing constant of alpha is

Get the following table for alpha=0.8

Year(t) Sales in millions Y(t) Exponential forecast , alpha=0.8 Forecast error Absolute error
1993 0.9
1994 1.1
1995 1.5
1996 1.3 0.8*1.5+(1-0.8)*1.1=1.42 (1.3-1.42)=-0.12 |-0.12|=0.12
1997 1.1 0.8*1.3+(1-0.8)*1.42=1.324 (1.1-1.324)=-0.224 |-0.224|=0.224
1998 1.7 0.8*1.1+(1-0.8)*1.324=1.145 (1.7-1.145)=0.555 |0.555|=0.555
1999 1.9 0.8*1.7+(1-0.8)*1.145=1.589 (1.9-1.589)=0.311 |0.311|=0.311
2000 2.3 0.8*1.9+(1-0.8)*1.589=1.838 (2.3-1.838)=0.462 |0.462|=0.462

ans: Exponential forecast using a smoothing constant of alpha=0.8 is

Year(t) Sales in millions Y(t) Exponential forecast , alpha=0.8 Forecast error Absolute error
1993 0.9
1994 1.1
1995 1.5 1.1
1996 1.3 1.420 -0.120 0.120
1997 1.1 1.324 -0.224 0.224
1998 1.7 1.145 0.555 0.555
1999 1.9 1.589 0.311 0.311
2000 2.3 1.838 0.462 0.462
MAD 0.334

The mean absolute deviation is

Get the following table for alpha=0.2

Year(t) Sales in millions Y(t) Exponential forecast , alpha=0.2 Forecast error Absolute error
1993 0.9
1994 1.1
1995 1.5
1996 1.3 0.2*1.5+(1-0.2)*1.1=1.18 (1.3-1.18)=0.12 |0.12|=0.12
1997 1.1 0.2*1.3+(1-0.2)*1.18=1.204 (1.1-1.204)=-0.104 |-0.104|=0.104
1998 1.7 0.2*1.1+(1-0.2)*1.204=1.183 (1.7-1.183)=0.517 |0.517|=0.517
1999 1.9 0.2*1.7+(1-0.2)*1.183=1.287 (1.9-1.287)=0.613 |0.613|=0.613
2000 2.3 0.2*1.9+(1-0.2)*1.287=1.409 (2.3-1.409)=0.891 |0.891|=0.891

ans: Exponential forecast using a smoothing constant of alpha=0.2 is

Year(t) Sales in millions Y(t) Exponential forecast , alpha=0.2 Forecast error Absolute error
1993 0.9
1994 1.1
1995 1.5 1.1
1996 1.3 1.180 0.120 0.120
1997 1.1 1.204 -0.104 0.104
1998 1.7 1.183 0.517 0.517
1999 1.9 1.287 0.613 0.613
2000 2.3 1.409 0.891 0.891

Related Solutions

You have been given the following information about a motel for the coming year:                             &
You have been given the following information about a motel for the coming year:                                                   (A)            Occupancy Forecast         75% (B)            Rooms department variable cost per occupied room is estimated to be     $7.75                                        (C)            Owners' investment          $800,000 (D)            Desired after tax yield on owners' investment        15% (E)             Current income tax rate                  30% (F)             The motels fixed costs for the coming year were anticipated to be                 825,000                                   (G)            The motel has this many rooms available to rent     100...
Moving Averages.  Use the below actual sales to calculate a three-year average which will be used as...
Moving Averages.  Use the below actual sales to calculate a three-year average which will be used as the forecast for next periods (chapter 14, text). Exponential Smoothing. Use the same data to forecast sales for the next periods with α=.40 (chapter 14, text). Regression Analysis on Excel. Draw a scatter graph from Insert/Graph/Scatter graph selections in Excel (chapter 15, text). Month Actual Sales 1 3050 2 2980 3 3670 4 2910 5 3340 6 4060 7 4750 8 5510 9 5280...
You have been given the following information for KLM Manufacturing: Direct materials used                           &nb
You have been given the following information for KLM Manufacturing: Direct materials used                                           $53,000 Closing finished goods inventory                          34,000 Depreciation of factory equipment (a cost)          11,000 Factory repairs and maintenance                         16,000 Opening WIP inventory                                          19,000 Direct labour                                                             59,000 Indirect labour                                                          23,000 Indirect materials                                                      13,000 Other manufacturing overhead                             4,000 Tax on factory building (a cost)                             3,000 Marketing expenses                                    37,000 Opening finished goods inventory            27,000 Factory electric power                                             17,000 Closing WIP inventory                                            26,000 Depreciation of factory building                            9,000 Office expenses                                                       43,000...
Discuss the techniques of moving averages and filter rules as they are used by technical analysts....
Discuss the techniques of moving averages and filter rules as they are used by technical analysts. Include in your answer a discussion of technical analysis for an investor wishing to invest in emerging markets.
You have been given the following information for Kellygirl’s Athletic Wear Corp. for the year 2015:...
You have been given the following information for Kellygirl’s Athletic Wear Corp. for the year 2015: a. Net sales = $38,750,000. b. Cost of goods sold = $22,190,000. c. Other operating expenses = $6,100,000. d. Addition to retained earnings = $1,207,500. e. Dividends paid to preferred and common stockholders = $1,935,500. f. Interest expense = $1,835,000. g. The firm’s tax rate is 30 percent. h. In 2016, net sales are expected to increase by $9.75 million. i. Cost of goods...
You have been given the following information for PattyCake’s Athletic Wear Corp. for the year 2021:...
You have been given the following information for PattyCake’s Athletic Wear Corp. for the year 2021: Net sales = $39,000,000. Cost of goods sold = $22,240,000. Other operating expenses = $6,600,000. Addition to retained earnings = $1,212,500. Dividends paid to preferred and common stockholders = $1,948,000. Interest expense = $1,860,000. The firm’s tax rate is 30 percent. In 2022: Net sales are expected to increase by $10.00 million. Cost of goods sold is expected to be 60 percent of net...
You have been given the following information for PattyCake’s Athletic Wear Corp. for the year 2018:...
You have been given the following information for PattyCake’s Athletic Wear Corp. for the year 2018: Net sales = $38,450,000. Cost of goods sold = $22,130,000. Other operating expenses = $5,500,000. Addition to retained earnings = $1,201,500. Dividends paid to preferred and common stockholders = $1,920,500. Interest expense = $1,805,000. The firm’s tax rate is 30 percent. In 2019: Net sales are expected to increase by $9.45 million. Cost of goods sold is expected to be 60 percent of net...
You have been given the following information for PattyCake’s Athletic Wear Corp. for the year 2018:...
You have been given the following information for PattyCake’s Athletic Wear Corp. for the year 2018: Net sales = $38,500,000. Cost of goods sold = $22,140,000. Other operating expenses = $5,600,000. Addition to retained earnings = $1,202,500. Dividends paid to preferred and common stockholders = $1,923,000. Interest expense = $1,810,000. The firm’s tax rate is 30 percent. In 2019: Net sales are expected to increase by $9.50 million. Cost of goods sold is expected to be 60 percent of net...
You have been given the following information for PattyCake’s Athletic Wear Corp. for the year 2018:...
You have been given the following information for PattyCake’s Athletic Wear Corp. for the year 2018: Net sales = $38,700,000. Cost of goods sold = $22,180,000. Other operating expenses = $6,000,000. Addition to retained earnings = $1,206,500. Dividends paid to preferred and common stockholders = $1,933,000. Interest expense = $1,830,000. The firm’s tax rate is 30 percent. In 2019: Net sales are expected to increase by $9.70 million. Cost of goods sold is expected to be 60 percent of net...
You have been given the following information for PattyCake’s Athletic Wear Corp. for the year 2018:...
You have been given the following information for PattyCake’s Athletic Wear Corp. for the year 2018: Net sales = $39,150,000. Cost of goods sold = $22,270,000. Other operating expenses = $6,900,000. Addition to retained earnings = $1,215,500. Dividends paid to preferred and common stockholders = $1,955,500. Interest expense = $1,875,000. The firm’s tax rate is 30 percent. In 2019: Net sales are expected to increase by $10.15 million. Cost of goods sold is expected to be 60 percent of net...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT