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 must an organization do to prepare for such a risk, Product contaminat...

Product contamination is a catastrophic event, both for the organization at fault and for the victims. Cases of product contamination frequently make the news. Find an example o

Organizational Structure & Design, How can we predict the effects of calcul...

How can we predict the effects of calculated and deliberate organizational change on informal networks and structures? How can we mitigate against unanticipated and unintended cons

Explain different forecasting techniques, An analyst must decide between tw...

An analyst must decide between two different forecasting techniques for weekly sales of roller blades: a linear trend equation and the naive approach. The linear trend equation is

Location, How to find the total distance using Euclidean distance formula

How to find the total distance using Euclidean distance formula

Explain introduction to optimum design, Why are there no solutions for Intr...

Why are there no solutions for Introduction to Optimum Design textbooks?

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

Generate a table that includes all of the key elements, Create a table that...

Create a table that includes all of the key elements that you think an organization must focus on to promote change

Explain increasing the level of confidence, All other things held constant,...

All other things held constant, increasing the level of confidence for a confidence interval estimate for the difference between two population means will result in a wider confide

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