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

Solve the problem requires an excel solution, The problem requires an excel...

The problem requires an excel solution and an algebraic solution with variables: During the month of July, Pittsburgh resident Bill Fly must make four round trip flights between Pi

Explain managerial motivation, Explain managerial motivation. Manageri...

Explain managerial motivation. Managerial Motivation: It is the means or inducements, which impel or inspire a person to intensify his willingness to use his abilities and po

Explain steps in the supply process, Examine the steps of the supply proces...

Examine the steps of the supply process in Chapter 4 of the text and identify a project where improvements could be made in one or more of the steps. Would the project have been mo

Explain business-level strategy, "Business-Level Strategy" Please respond t...

"Business-Level Strategy" Please respond to the following: • From the first e-Activity, assess your satisfaction with the company you researched and make recommendations about h

Explain labour agreements, Outline and explain the three major elements (an...

Outline and explain the three major elements (and their arguments) contained in the controversial question as to whether union security provisions should be negotiated in labour ag

Employees that meet to recognize work problems, Small groups of employees t...

Small groups of employees that meet to recognize work problems and their solution are known as   Quality circles.

Explain well-designed teams tend to sabotage leaders, When it comes to how ...

When it comes to how a team is designed (i.e., members, communication, goals, norms, etc.) and team leadership, which of the following statements is most true based upon the studie

Explain what would be the danger of your hospital, Assume you are the respo...

Assume you are the responsible senior executive of a hospital in a city with a population of 30,000 people, located about 50 miles away from a large city. What would be the danger

Learning curve concept plays vital role in location decision, This assignme...

This assignment is designed to demonstrate that the learning curve concept plays a vital strategic role in location decision. A company started making a new product simultaneously

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