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 is there a best employment process- stepwise, Is there a best emplo...

Is there a best employment process, stepwise? What would you outline and why? What must steps should come first, and last?

Explain variety of theories of motivation, There are a variety of theories ...

There are a variety of theories of motivation, many of which are complementary. Of the main motivational theories described in the text, which theory or theories do you think would

Describe approaches to communication as related to managers, Clampitt prese...

Clampitt presented a communication model for his first 2 approaches to communication as related to managers; Arrow & Circuit. What communication model best describes his Dance Appr

Explain sophicated technology and industry benchmarking, Health care consta...

Health care constant changes are a result of continuing trends in regulatio, policy, patient and provider advocacy efforts, as well as increasingly sophicated technology and indust

I need excel backup to understand a problem, Need Excel backup to understan...

Need Excel backup to understand how to answer this question. Bob White leaned back and wiped his forehead with his hand. He was the president of the home oven division of Winkley &

Legal rules for recovery of the amounts, MJZ Corporation had a checking acc...

MJZ Corporation had a checking account with Gulfstream Bank. So that customers who close their accounts would not be embarrassed by having their checks bounce, the bank routinely h

Operation research, A paper mill produces two grades of paper viz., X and Y...

A paper mill produces two grades of paper viz., X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y paper i

What are policy and operative decisions, What are policy and operative deci...

What are policy and operative decisions? Policy decisions are very significant, they are taken by top management, and they have a long-term impact and mostly relate to fundamen

Explain leadership styles associated with path-goal theory, Identify four l...

Identify four leadership styles associated with path-goal theory. Explain each style and relate it to styles described in other theories. Can leaders exhibit more than one style?

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