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 how did social media play a role in these uprisings, 1 What the spa...

1 What the spark that started the current uprisings in the Middle East? Explain. 2 Apply your knowledge of the importance of Rule of Law into the current uprisings in the Middle

Explain charge of maintaining hospital supplies, Barbara Flynn is in charge...

Barbara Flynn is in charge of maintaining hospital supplies at General Hospital. During the past year, the mean lead time demand for bandage BX-5 was 60 (and was normally distribut

Explain what the term data redundancy means, Describe what the term "data r...

Describe what the term "data redundancy" means in database design. Explain if it is bad and if a normalized database design is always the best design. Discuss the pros and cons of

Calculate the median for sample data, The Hilllcrest Golf and Country Club ...

The Hilllcrest Golf and Country Club manager selected a random sample of the members and recorded the number of rounds of golf they played last season. The reason for his interest

Discuss involvement in organizational decision-making, Discuss the impact o...

Discuss the impact of involving your employees in decision-making. What are the pros and cons? Should employees be involved in critical organizational decisions? Why or why not? Pr

Difference between, Give difference between assembler, compiler and interpr...

Give difference between assembler, compiler and interpreter

Explain the marketing objective for a product in the, The marketing objecti...

The marketing objective for a product in the _____ stage of the product life cycle is to create consumer awareness and gain trial. introduction growth maturity decline

What is the objective under jit and time-based competition, _____ is the ob...

_____ is the objective under JIT and time-based competition. WIP reduction Material velocity Lead-time reduction Decreasing material wait time

What are programmed decisions, What are programmed decisions? Decisions...

What are programmed decisions? Decisions made in accordance with several habit, rule or procedure are termed as Programmed Decisions.

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