Construct the time-series plot and identify the pattern.

Question

Want to see the full answer?

Answer 1

Question

Chapter 8, Problem 10P

(a)

To determine

Construct the time-series plot and identify the pattern.

(b)

To determine

Use exponential smoothing with α=0.4 to develop a forecast of demand for week 13.

Find the value of MSE.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Storrs Cycles has just started selling the new Cyclonemountain bike, with monthly sales as shown in the table. First,co-owner Bob Day wants to forecast by exponential smoothingby initially setting February’s forecast equal to January’s saleswith a = .1. Co-owner Sherry Snyder wants to use a three-periodmoving average. a) Is there a strong linear trend in sales over time?b) Fill in the table with what Bob and Sherry each forecast forMay and the earlier months, as relevant.c) Assume that May’s actual sales figure turns out to be 405.Complete the table’s columns and then calculate the meanabsolute deviation for both Bob’s and Sherry’s methods.d) Based on these calculations, which method seems moreaccurate?

After its move in 1990 to La Junta, Colorado, and its new initiatives, the DeBourgh Manufacturing Company began an upward climb of record sales. Suppose the figures shown here are the DeBourgh monthly sales figures from January 2001 through December 2009 (in $1,000s). a) Produce a time series plot. Are there any trends evident in the data? Does DeBourgh have a seasonal component to its sales? b) Deseasonalize the data using Multiplicative model with a 0.5 weighted moving average. Produce a time series plot of the deseasonalized data and add a trendline. c) Forecast the sales from January to December of the year 2010. d) Include a discussion of the general direction of sales and any seasonal tendencies that might be occurrinG Month 2001 2002 2003 2004 2005 2006 2007 2008 2009 January 139.7 165.1 177.8 228.6 266.7 431.8 381 431.8 495.3 February 114.3 177.8 203.2 254 317.5 457.2 406.4 444.5 533.4 March 101.6 177.8 228.6 266.7 368.3 457.2 431.8 495.3 635 April 152.4 203.2…

Suppose that the Perpetual Help College of Rizal had the following record of its growth of enrollment from 2011 -2020. Year Enrolment Year Enrolment 2011 5,200 2016 7,000 2012 5,500 2017 8,800 2013 6,000 2018 9,400 2014 6,500 2019 9,600 2015 6,800 2020 10,500 c) Using exponential smoothing and smoothing constant of .30 and 2011 previous forecast of 5200, develop a forecast of enrolment from 2012 to 2021. d) Forecast enrollment using Trend line Projection from 2011 to 2021. e) Evaluate forecast accuracy of each forecast model using MSE .…

Answer 2

Question

Chapter 8, Problem 10P

(a)

To determine

Construct the time-series plot and identify the pattern.

(b)

To determine

Use exponential smoothing with α=0.4 to develop a forecast of demand for week 13.

Find the value of MSE.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Question

Chapter 8, Problem 10P

(a)

To determine

Construct the time-series plot and identify the pattern.

(b)

To determine

Use exponential smoothing with α=0.4 to develop a forecast of demand for week 13.

Find the value of MSE.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Question

Chapter 8, Problem 10P

(a)

To determine

Construct the time-series plot and identify the pattern.

(b)

To determine

Use exponential smoothing with α=0.4 to develop a forecast of demand for week 13.

Find the value of MSE.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Chapter 8, Problem 10P

(a)

To determine

Construct the time-series plot and identify the pattern.

(b)

To determine

Use exponential smoothing with α=0.4 to develop a forecast of demand for week 13.

Find the value of MSE.

Answer 6

Chapter 8, Problem 10P

(a)

To determine

Construct the time-series plot and identify the pattern.

Answer 7

Chapter 8, Problem 10P

(a)

To determine

Construct the time-series plot and identify the pattern.

Answer 8

(b)

To determine

Use exponential smoothing with α=0.4 to develop a forecast of demand for week 13.

Find the value of MSE.

Answer 9

(b)

To determine

Use exponential smoothing with α=0.4 to develop a forecast of demand for week 13.

Find the value of MSE.

Answer 10

Expert Solution & Answer

Answer 11

Expert Solution & Answer

Answer 12

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 13

Ch. 8 - Consider the following time series data: Using...Ch. 8 - Refer to the time series data in Problem 1. Using...Ch. 8 - Problems 1 and 2 used different forecasting...Ch. 8 - Consider the following time series data: Compute...Ch. 8 - Consider the following time series...Ch. 8 - Consider the following time series...Ch. 8 - Refer to the gasoline sales time series data in...Ch. 8 - Prob. 8P Ch. 8 - Prob. 9P Ch. 8 - Prob. 10P

Construct the time-series plot and identify the pattern.

Solution Summary: The author explains how to construct a time-series plot and identify the horizontal pattern. Exponential smoothing is obtained using the formula given below.

Videos

Construct the time-series plot and identify the pattern.

Use exponential smoothing with α=0.4 to develop a forecast of demand for week 13.

Find the value of MSE.

Want to see the full answer?

Chapter 8 Solutions

Construct the time-series plot and identify the pattern.

Solution Summary: The author explains how to construct a time-series plot and identify the horizontal pattern. Exponential smoothing is obtained using the formula given below.

Videos

Construct the time-series plot and identify the pattern.

Use exponential smoothing with α=0.4 to develop a forecast of demand for week 13. Find the value of MSE.

Want to see the full answer?

Chapter 8 Solutions

Use exponential smoothing with α=0.4 to develop a forecast of demand for week 13.

Find the value of MSE.