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

Describe limitations of the relational model, Write a 200- to 350- word sho...

Write a 200- to 350- word short-answer response to the following: • Identify and describe three limitations of the relational model and recommend strategies to overcome these li

Explain receive advice from immediate supervisor, What are some of the poss...

What are some of the possible reasons Scott did not seek or receive advice from her immediate supervisor?

Makw or to Buy ?, • ABC Ltd. is in the business of manufacturing one type o...

• ABC Ltd. is in the business of manufacturing one type of valves for last 3 years. • Their sales have grown from 10,000 to about 50,000 valves per month. • Now they are planning t

Describe who are the stakeholders in this case, YP11-6 Giant Airlines opera...

YP11-6 Giant Airlines operates out of three main "hub" airports in the United States. Recently Mosquito Airlines began operating a flight from Reno, Nevada, into Giant's Metropolis

Assignment, #question.Opration system of the garments manufacture of bangla...

#question.Opration system of the garments manufacture of bangladesh.

Explain why has walmart tended to improve performance, Why has Walmart tend...

Why has Walmart tended to improve performance while other retail outlets have been suffering financially?

Compute a regression line and forecast the demand, The number of heart surg...

The number of heart surgeries performed at Heartville General Hospital has increased steadily over the past several years. Use the data below to calculate a regression line and for

Give an example of what team performance, Provide an example of what team p...

Provide an example of what team performance readiness might look like at various readiness levels

How must organisations have the flexibility to demand occur, How must organ...

How must organisations have the flexibility to demand occur? Forecasting demand can be complicated and unreliable into an uncertain environment. Therefore a balance requires to

Describe the basic idea underlying the contingency view, Explain the basic ...

Explain the basic idea underlying the contingency view

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