i. ii. Differentiate between independent and dependent variable in forecasting. The last seven weeks of sales at KC car dealership can be seen in Table 2 below. Table 2 Week Sales 1 25 2 30 3 27 4 31 5 27 6 29 7 30 8 altor a. Use a three-period weighted-moving average forecast to determine a forecast for the gth week using weights of 3, 2, and 1 (where the most recent week receives the highest weight). (Round all forecasts to the nearest whole unit.) b. Calculate the MAD for this forecast. What does the MAD indicate? iii. The number of students enrolled in Spring Valley Elementary school has been steadily increasing over the past five years. The School Board would like to forecast enrolment for years 6 and 7 in order to better plan capacity. The past five years enrolment is indicated in table 3: Table 3 Year Enrollment 1 220 2 245 3 256 4 289 5 310 Assuming a linear trend, use the tabular method to derive values for: a. the slope b. the intercept c. Forecast period 6 enrollment