Reference no: EM132250733
Ch. 5 Homework
1. What are 3 types of business forecasting methods?
2. What are 5 aspects of time series forecasts?
3. What is a shortcoming of using moving average to forecast?
4. What are two advantages of using a weighted forecast?
5. What is exponential smoothing and what is a shortcoming of it?
6. When evaluating a statistical result at 95% confidence, a P value of 3% would tell you to accept or reject the null hypothesis
7. What does a seasonal index of 1.25 mean?
8. Mean absolute deviation (MAD) is a measure of what and what is a weakness of it compared to MAPE?
Using Excel solve:
9. What are forecasted sales in month 4 using a simple moving average?
|
Month
|
Sales
|
Forecast
|
|
1
|
3
|
|
|
2
|
5
|
|
|
3
|
8
|
|
|
4
|
|
|
10. What are forecasted sales in month 4 using a weighted moving average?
|
60%
|
most recent month
|
|
30%
|
2 months ago
|
|
10%
|
3 months ago
|
|
|
|
|
Month
|
Sales
|
|
|
1
|
3
|
|
|
2
|
5
|
|
|
3
|
8
|
|
|
4
|
|
|
11. What are forecasted sales in weeks 1 through 5 using exponential smoothing?
|
Week
|
Demand
|
Forecast (α=0.2)
|
|
1
|
500
|
|
|
2
|
600
|
|
|
3
|
400
|
|
|
4
|
300
|
|
|
5
|
500
|
|
12. What are forecasted sales in months 1 &2 using exponential smoothing with trend?
|
|
|
|
(β=0.4)
|
|
|
|
|
(α=0.2)
|
|
Month
|
Actual
|
Smoothed Forecast
|
Smoothed Trend
|
Forecast Including Trend
|
|
1
|
10
|
9
|
2
|
|
|
2
|
20
|
|
|
|
13. Across the months of Jan - May what are the season indexes in sales?
|
Month
|
2001
|
2002
|
2003
|
Avg over 3 yrs
|
Monthly avg
|
Seasonal Index
|
|
Jan
|
60
|
67
|
70
|
|
|
|
|
Feb
|
64
|
68
|
69
|
|
|
|
|
March
|
90
|
98
|
100
|
|
|
|
|
April
|
100
|
105
|
110
|
|
|
|
|
May
|
100
|
110
|
120
|
|
|
|
14. How accurate is the forecasting department at predicting sales?
|
Month
|
Sales
|
Forecast
|
|
|
1
|
30
|
32
|
|
|
2
|
50
|
39
|
|
|
3
|
30
|
40
|
|
|
4
|
20
|
32
|
|
|
|
|
|
|
|
MAD =
|
|
|
|
|
|
|
|
|
|
|
MAPE =
|
|
|
|
% accuracy =
|
|
15. Use tracking signals to answer if the forecast in control
|
|
|
|
|
|
Cummulative
|
|
|
|
|
|
|
|
Absolute
|
Absolute
|
|
|
|
Month
|
Sales
|
Forecast
|
Error
|
RSFE
|
Forecast Error
|
Forecast Error
|
MAD
|
Tracking signal
|
|
1
|
30
|
32
|
|
|
|
|
|
|
|
2
|
50
|
39
|
|
|
|
|
|
|
|
3
|
30
|
40
|
|
|
|
|
|
|
|
4
|
20
|
32
|
|
|
|
|
|
|
16. You are the manager of a toy factory. Sales have been steadily climbing year-on-year. Does the increase in sales follow a linear trend? If so, what is the equation and % variation in sales explained by the model? (Use Excel Data Analysis Regression).
|
Year
|
Sales
|
|
2012
|
2000
|
|
2013
|
3000
|
|
2014
|
3100
|
|
2015
|
3300
|
|
2016
|
3500
|
17. Using the VizDataEffectively file complete graphs for Benchmark (Ch 4 Effective Data Visualization) and BulletChart1 (Ch 4 Effective Data Visualization)
18. Using the Pivot_table_sample file, produce a 2D bar chart showing sum of years registered by Party?