(b) Develop the three-week moving average for this time series. (Round your answers to two decimal places.)WeekTime SeriesForecastValue1192123174101.725186014Compute MSE. (Round your answer to two decimal places.)MSE =What is the forecast for week 7?(c) Use a = 0.2 to compute the exponential smoothing values for the time series.WeekTime SeriesForecastValue1192123174st1051810614 Centerville Bikes and Stuff (CBS) sells motorcycles and accessories. The number of helmets sold by CBS per week for the past six weeks follows.Week123456Value191217101814(a) Construct a time series plot.201816142018161412108.201820 T16181416121410121082-20123456702345 670123456712345 67WeekWeekWeekWeekWhat type of pattern exists in the data?The data appear to follow a seasonal pattern.The data appear to follow a horizontal pattern.The data appear to follow a cyclical pattern.The data appear to follow a trend pattern.

Step 1: Solution (a): The data appears to follow a horizontal pattern. Excel function to see the…

Answered: (b) Develop the three-week moving…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.7: Exponential Smoothing Models

Problem 27P: The file P13_27.xlsx contains yearly data on the proportion of Americans under the age of 18 living...

See similar textbooks

Similar questions

The file P13_27.xlsx contains yearly data on the proportion of Americans under the age of 18 living below the poverty level. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Create a chart of the series with the forecasts superimposed from this optimal smoothing constant. Does it make much of an improvement over the model in part b? d. Write a short report to summarize your results. Considering the chart in part c, would you say the forecasts are good?
b. The following table shows the number of televisions sold over the last ten years at a local electronic store. YEAR 1 2 3 4 5 6 TV SALES 150 300 480 600 630 640 700 825 900 980 7 8 9 10 i. Using trend projection, develop a formula to predict sales for years 11 and 12. You have to show all working. You will need to develop a table to calculate the slope and the intercept. ii. Use that formula to forecast television sales for years 11 and 12.
Corporate triple-A bond interest rates for 12 consecutive months follow. 9.5 9.4 9.5 9.6 9.8 9.8 9.9 10.6 9.9 9.7 9.6 9.6 (a) Construct a time series plot. What type of pattern exists in the data? The data appear to follow a trend pattern.The data appear to follow a cyclical pattern. The data appear to follow a horizontal pattern.The data appear to follow a seasonal pattern. (b) Develop three-month and four-month moving averages for this time series. (Round your answers to two decimal places.) Month Time SeriesValue 3-Month MovingAverage Forecast 4-Month MovingAverage Forecast 1 9.5 2 9.4 3 9.5 4 9.6 5 9.8 6 9.8 7 9.9 8 10.6 9 9.9 10 9.7 11 9.6 12 9.6 Does the three-month or four-month moving average provide more accurate forecasts based on MSE? Explain. The three-month moving average provides more accurate forecasts, because its MSE is larger than that of the four-month moving…
I need typing clear urjent no chatgpt use i will give 5 upvotes full explanationpls
Pls answer b and c
Year Quarter Sales Isolated trend 2016 1 18 2016 2 28 2016 12 2016 4 8 2017 1 16 2017 2 38 2017 3 24 2017 4 17 2018 1 34 A 2018 2 40 2018 29 2018 4 26 2019 1 42 2019 2 52 2019 40 2019 4 34 43.75 2020 1 46 2020 2 58 The table contains decomposition figures of the quarterly sales in millions of Rands for a large store. The value of A is
Please assist
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven month period were as follows:Months Sales (in thousand units)February 15March 19April 12May 21June 23July 24August 27a. Using the Naïve method in order to forecast September sales volume.b. Using linear trend equation in order to forecast September sales volume. c. Using five-month moving average in order to forecast September sales volume.d. Using weighted moving average of 0.80 for August, 0.05 for July, and 0.15 for June in order to forecast September sales volume.e. Using Exponential smoothing with a smoothing constant equal to 0.25 and assuming a March forecast of 18(000) in order to forecast September sales volume.
11.2
The following table shows the three-period moving average and five-period moving average for monthly sales of Budget Furniture's during 2019. Moving averages of Budget Furniture's Time period Months Sales Three-period moving average (rounded off to Five-period moving average four decimals) R'millions 1 Jan 7 5.0000 6.2 February 5.6667 6.6 March 5 7.0000 B 4 April 8.3333 8.2 May 7 9.3333 8.4 June 8.3333 9.6 7 July 12 8.6667 9.6 August 4 A 9.2 September 10 10.6667 10 October 13 10.6667 11 November 9 12 December 10 The seasonal index for the month of February in 2019 is: LO
ces Obtain estimates of quarter relatives for these data using the centered moving average method. ( decimal points and standardize the final seasonal relatives so their total is four.) Quarter Demand Year 1 2 3 4 1 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 16 20 35 49 31 36 65 74 50 52 92 86 61 Quarter 1 2 3 4 1 2 3 4 1 2 3 4 1 Year MA 2 MA₂ Demand/MA2
Solve for the intercept (a).

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS