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 annual holding and order costs, Item Cost - $7.00 Order Cost - $283...

Item Cost - $7.00 Order Cost - $283.00 Annual Hold - 32% of item cost Annual Demand - 22,100 Average Demand - 442 per week Standard deviation of weekly demand 20 per week lead time

Explain what changes in culture are needed at the plaza inn, 1. How could t...

1. How could the Plaza Inn develop a collaborative strategy? Develop a specific plan. 2. How could technology help solve the problems at the front desk? Explain what you propose

Explain what is the yield to maturity on this bond, Plasma TV Corporation b...

Plasma TV Corporation bonds are currently priced at $1,088. They have 12 years until maturity and a coupon rate of 6%. What is the yield to maturity on this bond?

Explain how can the hrm professional be prepared to deal, How can the HRM p...

How can the HRM professional be prepared to deal with the variations in HR practices in the global environment

Work study, link between work study and value analysis?

link between work study and value analysis?

Why the company operates an average of 20 days a month, A food processor us...

A food processor uses approximately 29,730 glass jars a month for its fruit juice product. Because of storage limitations, a lot size of 4,000 jars has been used. Monthly holding c

Ventilation, a. To cater for adequate supply of oxygen or air required for...

a. To cater for adequate supply of oxygen or air required for respiration. b. To provide thermal comfort b maintaining adequate heat balance of the body. c. To get r

Explain crafting executive strategy, 1. What evidence do you find in this c...

1. What evidence do you find in this case, either explicitly or implicitly, that indicates that Whole Foods Market has a mission, core values, or is practicing decision-making that

Explain technology intensive should you make it, When you're creating a onl...

When you're creating a online site, how busy, technology intensive should you make it

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