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 product life cycle, How does a product life cycle differ from a pro...

How does a product life cycle differ from a product life cycle?

Describe how laws tie into business ethics, Discuss how laws tie into busin...

Discuss how laws tie into business ethics. Support your ideas with research and specific examples of laws discussed in your text.

Method describe how much one person is on a given dimension, Which statemen...

Which statement about comparative of performance appraisal is false/1. it is a method that seek to identify one relative standing among those being rated/2.this method indicate tha

Explain implement any change in strategy, 1. Describe how you think the hot...

1. Describe how you think the hotel's management will: (a) make sure that the way it manage the hotel is appropriate to the way it competes for business; (b) implement any change i

Analyze on the price of heating oil, Question For the financial year 20...

Question For the financial year 2012-2013, it has been decided the equalization of the tax on heating oil with the tax on fuel, thus increasing the price of heating oil. Do you

Explain important terms of the factories act 1948, Explain important Terms ...

Explain important Terms of the factories act 1948. Important Terms of act: (a) Factory:  A place wherein ten or more persons are working and wherein a manufacturin

Define fast food restaurant averages customers per hour, 1. A hospital emer...

1. A hospital emergency room averages 50 patients per shift. A shift is 8 hours long, and the average patient requires 20 minutes in the exam room. a. How many exam rooms should

Explain how to do aon in excel 2010, Does anyone know how to do aon in Exce...

Does anyone know how to do aon in Excel 2010 and if so can they contact me and wlk me through it sso that I can understand it

Explain cross-cultural repatriation, Preparing employees to work across nat...

Preparing employees to work across national and cultural boundaries is known as: Answer (1) cross-cultural repatriation. (2) Cross-cultural preparation. (3) Culture shock. (4) Reve

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