Sales of storage bins at Bud’s Discount Store over the past eight years are shown below. Year Unit Sales


Sales of storage bins at Bud’s Discount Store over the past eight years are shown below.

Year Unit Sales
1 100
2 93
3 96
4 110
5 124
6 119
7 92
8 101
  1. Find the forecast and the MAPE for year 9 using:
  1. a 3-year moving average.
  2. a 3-year weighted moving average with weights of .6 (most recent), .3, and .1.
  3. Exponential smoothing with an alpha of .75 and a starting forecast for year 1 of 90.
  4. The naive method.

b) Which forecasting method is preferable using MAPE?

First Elementary school is trying to forecast the need for kindergarten teachers for the next 2 years. The school has data on births and enrollments for the past 10 years. The enrollments lag the births by 5 years.

Year Births Enrollments
1 131 161
2 192 127
3 158 134
4 93 141
5 107 112
6 130 148
7 128 188
8 124 155
9 97 110
10 147 124
  1. Forecast the kindergarten enrollments for the next 2 years using births as the independent variable, given the following data from the past 10 years.
  2. What is the correlation coefficient? Do you consider it to be significant?
  3. Explain the value of r-squared as it pertains to this model.
Price: $6.91
Solution: The downloadable solution consists of 4 pages, 291 words.
Deliverable: Word Document


log in to your account

Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in