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

What are disadvantages of the demand management strategies, What are the di...

What are the disadvantages of the demand management strategies? The disadvantages of the demand management strategies are as illustrated here: a. Not at all times effective

Principles and practices of management, How will you influence people to st...

How will you influence people to strive willingly for group objectives in our organization (target baes industry)?Apply your interpersonal influence through communication process t

How the organization you researched could become productive, Make one solid...

Make one solid recommendation for how the organization you researched could become more productive by applying one of the lessons learned. Explain your rationale.

Compute demand for a product, Historical demand for a product is:January DE...

Historical demand for a product is:January DEMAND 12 / February DEMAND 11/March DEMAND15/ April DEMAND 12/ May DEMAND 16 /June DEMAND 15 a. Using a weighted moving average with

Explain the probability that this person actually has heart, Medical studie...

Medical studies have shown that 10 out of 100 adults have heart disease. When a person with heart disease is given an EKG test, a 0.9 probability exists that the test will be posit

Explain asset has negative risk, Suppose rf is 5% and rM is 10%. According ...

Suppose rf is 5% and rM is 10%. According to the SML and the CAPM, an asset with a beta of -2.0 has a required return of negative 5% [= 5 - 2(10 - 5)]. Can this be possible? Does t

LOCATION AND LAYOUT, WHAT WOULD BE A GOOD RESEARCH QUESTION ON THIS TOPIC F...

WHAT WOULD BE A GOOD RESEARCH QUESTION ON THIS TOPIC FOR A GROUP PROJECT

Search a financial analysis report of coca-cola, Where can I find a financi...

Where can I find a financial analysis report of coca-cola for the past 5 years. I stress full financial analysis for the past 5years.

Explain performance appraisals are they necessary, 1.What purpose do they s...

1.What purpose do they serve under a performance management system? 2.Performance appraisals are they necessary or not? 3.What to do if an performance appraisal is unsatisfac

Compute the average number of customers waiting at lhs, During busy periods...

During busy periods, a new customer walks into LHS every 15 mins. (with a standard deviation of 15 mins). At SHC, a customer walks in every hour (with a standard deviation of 1 hou

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