Assist with HW question for better understanding

Use the following data to answer Questions 27 - 28.

Past period	Demand
June	45
July	55
Aug.	57
Sept.	48
Oct.	50

1. Compute a weighted moving average forecast for November. Use the following weights: 0.5 for Oct., 0.2 for Sept., and 0.3 for August.

2. Compute an exponential smoothing forecast for November. Assume forecast for September is 46.5, and use a smoothing constant equal to 0.6.

Use the following data to answer Questions 29 - 30.

Actual Value	Forecast Value
45	44
55	56
57	52
48	50
50	48

3. Calculate MAD

4. Calculate MSE

5. Demand for 5 weeks of jobs at a carpet-cleaning business is shown below. Use linear regression to create a trend equation for this time-series.

Week (X)	Demand (Y)
1	55
2	60
3	41
4	35
5	20

The trend equation is: Y =

Week	Monday	Tuesday	Wednesday	Thursday	Friday
1	8	15	25	13	2
2	12	25	34	17	7

1. Compute and report Wednesday's Seasonal Factor.