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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!