Busn 278 Week 1 Homework 100 All Answers Question Tco Budgets

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: