BUSN 278 Week 1 Homework ***100% All correct answers***
1. Question : (TCO 1) Budgets are prepared for:
an organization
a department
a product
All of the above
Points Received: 4 of 4
Comments:
2. Question : (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
Points Received: 4 of 4
Comments:
3. Question : (TCO 2) Using the table “Paint Sales Time Series”, calculate the mean absolute deviation for 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
2.67
1.76
2.54
3.67
Points Received: 4 of 4
Comments:
4. Question : (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
2.90
3.55
4.10
5.65
Points Received: 4 of 4
Comments:
5. Question : (TCO 2) Using the table “Computer Sales Time Series”, calculate the forecast for computer sales (in thousands) for Week 13 using exponential smoothing and a smoothing constant of .25.
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
3.79
4.27
5.15
5.53
Points Received: 4 of 4
Comments:
