Describe double exponential smoothing, Operation Management

Assignment Help:

The Cardinal Electronics Company must project the sales of cellular phones for the next year (called year 2). The number of cell phones sold by Cardinal Electronics in each of the past 6 months (July of year 1 through December of year 1) is shown below. Month Number of Cellular Phones Sold July 183 August 215 September 294 October 333 November 410 December 438 a. Forecast the number of cellular phones demanded in January of year 2 using a rolling (i.e. updated at end of each month when new demand data becomes available) 4-month linear regression model. For example, forecasts generated at the end of October are made by fitting a linear regression to the demands in months July through October and forecasts generated at the end of December are made by fitting a linear regression to the demands in months September through December. Forecast the number of cellular phones demanded in July of year 2. Calculate the MAD, MSE, and MAPE for a rolling 4-month linear regression model. b. Using Double Exponential Smoothing (DES) with ? = 0.15 and ?= 0.10 (i.e. assume the data has a linear trend pattern), forecast the number of cellular phones demanded in January of year 2. Forecast the number of cellular phones demanded in July of year 2. Calculate the MAD, MSE, and MAPE for your double exponential smoothing model. c. Based on the measures of forecast accuracy you calculated for the part a) linear regression model and the part b) DES (0.15, 0.10) model, which model is a better fit for this data?


Related Discussions:- Describe double exponential smoothing

Explain how to expand company, How to expand company, drive growth, and not...

How to expand company, drive growth, and not sacrifice margins?

Explain what protocols should be considered, What protocols, if any, should...

What protocols, if any, should be considered in this needs assessment?

Mean value - statistical aspects of variability, Mean value - Statistical A...

Mean value - Statistical Aspects of Variability The arithmetical mean value (µ, mu) of the measurements can be readily calculated, as follows. Let the class mid- point values

Explain what kind of data would be considered a nod, What kind of data woul...

What kind of data would be considered a NOD?/ REFERENCE WHERE THE INFO CAME FROM

Depict a forecast on a graph with the actual data, Develop a forecast for y...

Develop a forecast for years 2 through 12 using exponential smoothing with %u03B1 = .4 and a forecast for year 1 of 6. Plot your new forecast on a graph with the actual data and th

Operation function, meaning of operation function in operation management

meaning of operation function in operation management

Explain how an organization can use double-loop learning, Describe how an o...

Describe how an organization can use double-loop learning to improve performance.

Describe types of financial statements, What are the three basic financial ...

What are the three basic financial statements, and what major information does each contain? If you were planning to invest in a company, which of the three types of financial stat

Management as a process, Management as a process Much has been written...

Management as a process Much has been written of management as a process of 'getting things done through people', but the seminal work was that of the French engineer and indu

Describe the basic idea underlying the contingency view, Explain the basic ...

Explain the basic idea underlying the contingency view

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd