Question: Using the data from Question 1 and this updated actual sales data, what is the mean average deviation for Kristens forecast when using exponential smoothing
Using the data from Question 1 and this updated actual sales data, what is the mean average deviation for Kristens forecast when using exponential smoothing with = .3?
*QUESTION 1 IS BELOW WAS A GUIDE*
|
| Customers Per Day | ||||||
| Week | Sun | Mon | Tue | Wed | Thu | Fri | Sat |
| Actual: | 160 | 204 | 197 | 210 | 215 | 300 | 421 |
| a. | 8.57 | |
| b. | 8.93 | |
| c. | 10.4 | |
| d. | None of the above |
QUESTION 1:
QUESTION 1
Kristen Pacheco owns a small restaurant thats open seven days a week. Until recently, she forecasted the daily number of customers she would have using her intuition. However, she wanted to open another restaurant and recognized the need to adopt a more formal method of forecasting that could be used in both locations. Kristen decided to compare a three week moving average forecast with exponential smoothing forecasts using = .7 and = .3. She collected sales data for a month. The actual sales for the past three weeks are shown in the table below along with her forecast for last week.
|
| Customers Per Day | ||||||
| Week | Sun | Mon | Tue | Wed | Thu | Fri | Sat |
| Actual: |
|
|
|
|
|
|
|
| 3 weeks ago | 138 | 183 | 182 | 188 | 207 | 277 | 388 |
| 2 weeks ago | 143 | 194 | 191 | 200 | 213 | 292 | 401 |
| Last week | 157 | 196 | 204 | 193 | 226 | 313 | 408 |
| Forecast: |
|
|
|
|
|
|
|
| Last week | 155 | 191 | 192 | 198 | 204 | 286 | 396 |
What is the forecast for Kristens sales for each day of the week using a three-week moving average?
| a. | 146, 187, 187, 193, 205, 281, 392 | |
| b. | 146, 191, 192, 194, 215, 294, 399 | |
| c. | 155, 191, 192, 198, 204, 286, 396 | |
| d. | None of the above |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
