# Solve forecasting questions using naive, moving average

Hello,

I need the answer for these 3 questions please:

I have also attached the same questions in a Word file...

Q1. Sales (in thousands) of the new Thorton Model 506 convection oven over the eight-week period since its introduction have been as follows:

Week Sales

1 18.6

2 21.4

3 25.2

4 22.4

5 24.6

6 19.2

7 21.7

8 23.8

a) Use Naïve forecast, compute the accuracy measures and what is the forecast for week 9?

b) Use average of past values forecast, compute the accuracy measures and what is the forecast for week 9?

c) Use three week moving average, compute the accuracy measures and what is the forecast for week 9?

d) Use three week weighted moving average with weights of 0.2, 0.3 and 0.5, compute the accuracy measures and what is the forecast for week 9?

e) Compare the forecast methods used in a though d, which method should be used?

f) Which exponential smoothing model provides better forecasts, one using = .6 or = .2? Compare them using mean squared error. What are the forecasts for week 9?

Q2. A 24-hour coffee/donut shop makes donuts every eight hours. The manager must forecast donut demand so that the bakers have the fresh ingredients they need. Listed below is the actual number of glazed donuts (in dozens) sold in each of the preceding 13 eight-hour shifts.

Date Shift Demand(dozens)

June 3 Day 59

Evening 47

Night 40

June 4 Day 64

Evening 43

Night 39

June 5 Day 62

Evening 46

Night 42

June 6 Day 60

Evening 45

Night 40

June 7 Day 58

a. Produce a line chart

b. Develop the optimization model that finds the estimated regression equation that minimize the sum of squared error.

c. Solve for the estimated regression equation.

d. Forecast the demand for glazed donuts for the Day, Evening, and Night shifts of June 8.

Q3. Design a scenario that requires to conduct a multiple regression analysis. You need to find data, construct the linear model, run analysis, evaluate your model, and interpret the results.

© BrainMass Inc. brainmass.com October 10, 2019, 8:19 am ad1c9bdddfhttps://brainmass.com/statistics/correlation-and-regression-analysis/solve-forecasting-naive-moving-average-619264

#### Solution Preview

Please check both attachments.

1. Sales (in thousands) of the new Thorton Model 506 convection oven over the eight-week period since its introduction have been as follows:

Week Sales

1 18.6

2 21.4

3 25.2

4 22.4

5 24.6

6 19.2

7 21.7

8 23.8

a) Use Naïve forecast, compute the accuracy measures and what is the forecast for week 9?

From excel, forecasr for week 9 is 23.8 using naive.

b) Use average of past values forecast, compute the accuracy measures and what is the forecast for week 9?

From excel, forecasr for week 9 is 22.1 using average of past values.

c) Use three week moving average, compute the accuracy measures and what is the forecast for week 9?

From excel, forecasr for week 9 is 21.6 using moving average.

d) Use three week weighted moving average with weights of 0.2, 0.3 and 0.5, compute the accuracy measures and what is the forecast for week 9?

From excel, forecasr for week 9 is 22.3 using weighted moving average.

e) Compare the forecast methods used in a though d, which method should be used?

We use mean squared error to compare all methods and we choose the smallest value. So after calculations using excel, moving average is the best method because it has the smallest MSE.

f) Which exponential smoothing model ...

#### Solution Summary

The solution gives detailed steps on solving forecasting questions using naive, moving average, past averages and exponential methods and also building a multiple regression model with analysis part.