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

Describe difference between a mission and vision statement, Explain the dif...

Explain the difference between a mission and vision statement. Discuss why mission statements are important in performance improvement and why a solid mission statement (describing

Explain faster operating system for netbooks, Assume you work for a small f...

Assume you work for a small firm that developed a better and faster operating system for netbooks than Microsoft Windows. What strategy might the firm use to unseat Windows in this

Explain product life cycle, How does a product life cycle differ from a pro...

How does a product life cycle differ from a product life cycle?

Performance & productivity measurement -theory of constraint, Performance &...

Performance & Productivity Measurement -Theory of Constraint Traditional financial measures of performance have been criticised by Kaplan and Norton (1992) who voiced thei

Operation function, meaning of operation function in operation management

meaning of operation function in operation management

Explain definition of a project, Definition of a Project •Analyze how proje...

Definition of a Project •Analyze how project management supports the concept of strategic planning.

How to find the optimal order quantity, Must use Excel for solution Zip ...

Must use Excel for solution Zip Games purchases blank 3.5-inch disks onto which it copies its software for sale through its mail order operation. A disk costs Zip $.20. Processi

Assignment problem, Six Operators are to be assigned to five jobs with the ...

Six Operators are to be assigned to five jobs with the cost of assignment in Rs. given in the matrix below. Determine the optimal assignment. Which operator will have no assignment

What separates characteristics from management techniques, Provide two exam...

Provide two examples of current leaders and describe how they demonstrate their leadership characteristics. What separates these characteristics from management techniques? How eff

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