1. (TCO 1) Budgets are prepared for: (Points: 4)
an organization
a department
a product
All of the above
2. (TCO 2) Using the table “Paint Sales Time Series”, calculate the forecast for paint sales (in thousands) for Week 11 using a three day moving average.
Paint Sales Time Series | |
Week | Sales (000’s of gallons) |
1 | 6 |
2 | 8 |
3 | 10 |
4 | 9 |
5 | 11 |
6 | 12 |
7 | 10 |
8 | 8 |
9 | 7 |
10 | 9 |
8
9
10
11
3. (TCO 2) Using the table “Computer Sales Time Series”, calculate the mean absolute deviation for a six day moving average.
Computer Sales Time Series | |
Week | Sales (in thousands) |
1 | 2 |
2 | 4 |
3 | 5 |
4 | 3 |
5 | 6 |
6 | 7 |
7 | 5 |
8 | 8 |
9 | 4 |
10 | 2 |
11 | 3 |
12 | 5 |
(Points: 4)
1.86
2.94
3.89
5.39
4. (TCO 2) Using the table “Computer Sales Time Series”, calculate the forecast for computer sales (in thousands) for Week 13 using a three day weighted moving average. Use a weight of .40 for the most recent observation, .35 for the second most recent, and .25 for the third most recent.
Computer Sales Time Series | |
Week | Sales (in thousands) |
1 | 2 |
2 | 4 |
3 | 5 |
4 | 3 |
5 | 6 |
6 | 7 |
7 | 5 |
8 | 8 |
9 | 4 |
10 | 2 |
11 | 3 |
12 | 5 |
(Points: 4)
2.90
3.55
4.10
5.65
5. (TCO 2) Using the table “Paint Sales Time Series”, calculate the forecast for paint sales (in thousands) for Week 11 using exponential smoothing and a smoothing constant of .20.
Paint Sales Time Series | |
Week | Sales (000’s of gallons) |
1 | 6 |
2 | 8 |
3 | 10 |
4 | 9 |
5 | 11 |
6 | 12 |
7 | 10 |
8 | 8 |
9 | 7 |
10 | 9 |
(Points: 4)
6.40
7.97
8.64
9.17