In: Statistics and Probability
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
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 SolutionsYou 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 &nbYou 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
Latest Questions
ADVERTISEMENT
|