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

Economic advantage of statistical process control, Economic Advantage of St...

Economic Advantage of Statistical Process Control Since only samples of the output are measured, the cost of the measurement is substantially less than if all of the output we

Explain enable them to limit the probability of a stockout, A wine company'...

A wine company's daily demand is normally distributed with a mean of 18 bottles, and a standard deviation of 4 bottles. This company checks their winery's stock every 30 days. In t

List of operation., List the operation involved in any buying and selling b...

List the operation involved in any buying and selling business?

Explain advantage of favourable conditions, With your instructors help iden...

With your instructors help identify a local firm that has enjoyed great growth in recent years to what degree and in what ways do you think this from success resulted from taking a

Compute the mad and mse, The last 4 weekly values of sales were 80,100,105 ...

The last 4 weekly values of sales were 80,100,105 and 90 units. The last 4 forecast (for the same 4 weeks) were 60, 80, 95 and 75 units. Calculate the MAD, MSE and MAPE for these

Important functions of maintenance department, Problem 1: What are the ...

Problem 1: What are the important functions of maintenance department? Day to day activities Keeping the machinery, equipment, and services in proper working condition

Define criteria that considered to perform the project, One of the most imp...

One of the most important aspects of managing risk for a project is to accurately define the size of the project. Determine the criteria that must be considered to perform the proj

Explain decision alternative and state of nature, A payoff a. is always mea...

A payoff a. is always measured in profit. b. is always measured in cost. c. exists for each pair of decision alternative and state of nature. d. exists for each state of nature.

Objectives of good layout, Objectives of Good Layout Any of the follow...

Objectives of Good Layout Any of the following objectives might be achieved through a good layout: Provide enough production capacity. Reduce material handlin

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