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

Problem on abc analysis of inventory, Problem on ABC Analysis of Inventory:...

Problem on ABC Analysis of Inventory: The ABC Analysis of Inventory divides inventory into three classes: Class A - high annual dollar volume Class B - medium annual doll

Coca colas change in sales remain competitive and profitable, How would you...

How would you respond to Coca Cola's change in sales policy? How would you ensure Pepsi's board that this response will allow you to remain competitive and profitable?

Operations function - transformation processes and planning, Operations Fun...

Operations Function - Transformation Processes and Planning The operations function is concerned with the design of transformation processes, planning their use, and organisin

Explain quality metrics, A variety of organizational culture characteristic...

A variety of organizational culture characteristics make project success more likely. The characteristics include: A. Sufficient funding B. Feasible schedule C. Respect fo

Principle of motion economy, Principle of Motion Economy: The improvem...

Principle of Motion Economy: The improvement of any method is generally  accomplished using the ideas chosen from the alternatives  throw up during the critical examination ph

Describe shared storage policies and list example, Define shared storage po...

Define shared storage policies and list example that it is practice in real life?

Types of dispatching, Types of Dispatching Dispatching may be centralize...

Types of Dispatching Dispatching may be centralized or decentralized. Centralized dispatching refers to the instructions issued from the central dispatching section directly

Explain the various types of time-series, Describe the various types of tim...

Describe the various types of time-series and associative forecasting models. Which types of organizations are each of these most applicable to, and why?

Could you please explain which values i need to calculate, Regarding the tr...

Regarding the trash bag case (Essentials of Business Statistics, chapter 7 exercise 50), I am not sure where the 1.9991 comes from. I tired computing the standard normal distrib

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