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

Explain manual order management system, Mr. McNeely currently batches order...

Mr. McNeely currently batches orders for processing under the manual order management system. The orders are batched for daily processing. If Mr. McNeely opts to implement a Web-ba

Explain industrial disputes act, Explain Industrial Disputes Act. The I...

Explain Industrial Disputes Act. The Industrial Disputes Act intend at settling disputes between Employer and Employees.

Explain never underestimate the other guy, Jack Welch, the former CEO of Ge...

Jack Welch, the former CEO of General Electric of 20 years, respected business leader and writer proposes ten fundamental leadership principles (from his 2001 book 'Jack: Straight

Explain the stage in the product life cycle labeled a, The stage in the pro...

The stage in the product life cycle labeled A in the below figure is called introduction. maturity. growth. diversification. decline.

Discuss illiteracy and poor diets, Illiteracy and poor diets have been know...

Illiteracy and poor diets have been known to cost countries up to what percent of their productivity?

Explain the case of the marginalized workers, The Problem: The Case of the ...

The Problem: The Case of the Marginalized Workers You have decided to sub-contract out your grounds maintenance work. You have solicited bids for landscaping, a revamped irrigat

Statistical Process Control (SPC), I have an excel assignment for the SPC, ...

I have an excel assignment for the SPC, so I want to know if you could do it and how much will it cost?

Discuss the business model and strategy have evolved, Discussion is about D...

Discussion is about Dell Computer's business strategy in the increasingly competitive PC market. For this discussion, research the company and its business strategy and answer the

Design methods, Computer-Aided Design is one of the techniques used by Rega...

Computer-Aided Design is one of the techniques used by Regal Marine in the manufacturing of boats. With the aid of examples, critically discuss FIVE (5) techniques that are import

Explain ways to embed organizational culture, Which of the two ways to embe...

Which of the two ways to embed organizational culture has SAS used to create its current culture? Provide examples to support your conclusions.

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