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

Linear programming, A paper mill produces two grades of paper viz, x and y....

A paper mill produces two grades of paper viz, x and y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y paper in

Find the average total setup cost and shortage cost, A manufacturer uses a ...

A manufacturer uses a purchase part who's demand over any time period of length t (in years) can assume to be normally distributed with mean 200t and variance 400t. The part cost $

Explain random system component is adequately represented, Suppose 40 obser...

Suppose 40 observations of a random system component have been recorded as shown in the table below (these numbers are sorted). 0.0345 0.1079 0.1313 0.1452 0.1788 0.2101 0.2249

Explain employee types, After an all-night study session the day before the...

After an all-night study session the day before their last final exam, four first-year MBA students decide to stop for some much-needed coffee at the campus Starbucks. They arrive

Explain various elements of strategic leadership, 1. Discuss the various el...

1. Discuss the various elements of strategic leadership. 2. Do you believe that one's propensity to become a leader is an acquired skill or that the ability to be a leader is so

Explain how many crates will it need to plan, A bottling facility with an e...

A bottling facility with an effective capacity of 40,000 crates per day operates with an efficiency of 85%. How many crates will it need to plan for bottling on a day that requires

Define conflict between earning profit and being responsible, There is some...

There is sometimes a perceived conflict between earning profit and being responsible. What should CanGo do about adding violent games to their product mix? What impact might this h

Identify different types of quality system, (a) Identify different types of...

(a) Identify different types of quality system/philosophy/approaches and critically discuss the relative effectiveness of the philosophy, systems and approaches (b) Evaluate the

Define elements of finagle a bagels operating system, Now, please answer th...

Now, please answer the question regarding operations management. How would you describe the elements of Finagle a Bagels operating system?

Moving average in local organic food market, Weekly sales of 10-grain bread...

Weekly sales of 10-grain bread at the local organic food market are in the table below. Based on this data, forecast Week 9 using a five-week moving average. Week Sales 1

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