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 hides the information from the other side, Research suggests that a...

Research suggests that a party with an attractive BATNA will likely receive a more positive outcome if it hides the information from the other side.

Define effective public realtions program, Cite at least six steps that sho...

Cite at least six steps that should be observed in developing an effective public realtions program. Provide a recent negative public relations in sports

Explain cause are linked to employee disciplinary actions, Identify how the...

Identify how the issues of due process and just cause are linked to employee disciplinary actions

Explain forecast week 7 using a six-week moving average, Weekly sales of ry...

Weekly sales of rye bread at the corner store are shown below. Using this data, forecast Week 7 using a six-week moving average. Week Sales 1 415 2 389 3 420 4 382 5

Define company pay structure is fair to women and minorities, You have been...

You have been asked to evaluate whether a companys pay structure is fair to women and minorities. How would you go about answering this question? What factors might you consider in

Describe the history of welfare reform, Discuss the history of welfare refo...

Discuss the history of welfare reform. Discuss some of the historical aspects and your opinion about how these changes were implemented and whether or not the changes were effectiv

Explain identify an ethical framework that applies, Discuss the legal and e...

Discuss the legal and ethical issues surrounding Solyndra, the California based solar panel manufacturer. Incorporate two to three specific laws or ethical codes that apply to the

Explain how might superior benefit from using e-catalogues, Bill and Farrah...

Bill and Farrah have been recently hired by Superior Stereo Systems, a cutting-edge manufacturer of stereo speakers. Both Bill and Farrah have been assigned to work on two product

Define factors that need to be considered in media selection, There are thr...

There are three factors that need to be considered in media selection and budgeting. These include A) Audience reach, availability of the product, no competition B) Audience

Explain the rop that will provide a risk of stockout, Given this informatio...

Given this information: Expected demand during lead time = 300 units Standard deviation of lead time demand = 30 units Determine each of the following, assuming that lead time dema

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