BUS 278 WEEK 1 HOME WORK
Question 1 Question TCO 1 The type of budget that allows for adjustments to unpredictable changes is called a
Question 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- of gallons)
1 6
2 8
3 10
4 9
5 11
6 12
7 10
8 8
9 7
10 9
Question 3. Question : (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
Question 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
Question 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