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 reputation and credibility pressures, When JetBlue left their custo...

When JetBlue left their customers sitting on the tarmac for hours on Valentine's Day, and their CEO was ultimately terminated as a result, the company was responding to (pick the b

Describe harley davidson has excess capacity, Harley Davidson sells motorcy...

Harley Davidson sells motorcycle X and Y. Motorcycle X sells for $10,000, has variable cost (labour and material) of $2,000, and requires 10 hours of use of machinery to produce. M

How to perform a decision tree analysis for problem, Mountain States Electr...

Mountain States Electric Service is an electrical utility company serving several states in the Rocky Mountains region. It is considering replacing some of its equipment at a gener

Column minima method, Column Minima Method: Step 1: Determine  the  ...

Column Minima Method: Step 1: Determine  the  smallest cost in  the first  column  of the  transportation  table. Let it be  C1j  . allocate  Xi1= min ( ai bi ) in the cell

What is the ex post redistribution, 1. Two individuals, Vic and Val, are bo...

1. Two individuals, Vic and Val, are both working. Vic faces a 10 percent chance of becoming unemployed for three months and losing $12,000 of income. Val's probability of becoming

Analyze the environment and processes and procedures, Analyze the environme...

Analyze the environment, processes, and procedures at your work or school to determine which aspects can be controlled and which cannot be controlled. Explain your rationale. •From

Explain what will be the total costs for each alternative, Ergonomics Inc. ...

Ergonomics Inc. sells ergonomically designed office chairs. The company has the following information: Average demand = 54 units per day Average lead time = 30 days Item u

Explain method would you pursue to minimize channel conflict, D-Magic is a ...

D-Magic is a new company that has developed a revolutionary 3D television. It uses a new technology that provides a much sharper and realistic 3D experience than their competitors.

Explain managing human resources, 1. What challenges have managers at some ...

1. What challenges have managers at some technology companies faced in terms of managing human resources? 2. How do managers at some technology companies that invest resources in r

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