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 can the baker sue kristina for payment of the cake, Kristina places...

Kristina places an order for a cake on Flowers bakery's web site. She then calls the baker to tell him that she will pay him $1000 for the specially designed cake if he will guaran

Calculate the median for sample data, The Hilllcrest Golf and Country Club ...

The Hilllcrest Golf and Country Club manager selected a random sample of the members and recorded the number of rounds of golf they played last season. The reason for his interest

Formulate an integer programming model using excel solver, New fire station...

New fire stations are to be located in a city and the major of the city wants to decide where to locate the 2 fire stations. For planning purposes, the region has been divided into

Explain the probability that the second item is defective, A production pro...

A production process is known to produce a particular item in such a way that 5% of these are defective. If two items are randomly selected as they come off the production line, wh

Backward scheduling - scheduling techniques, Backward scheduling - Scheduli...

Backward scheduling - Scheduling Techniques Backward scheduling is another way of scheduling which is based on the as late possible approach with the condition that the jobs

Operation functions of an organization, Operation functions of an Organizat...

Operation functions of an Organization Case study IKEA is the most successful furniture retailer ever. With 276 stores in 36 countries, it has managed to develop its own s

Production process, with the help of a diagram, describe the production pro...

with the help of a diagram, describe the production process.

Forecasting, managerial decision modeling with spreadsheets 2nd Canadian ed...

managerial decision modeling with spreadsheets 2nd Canadian edition end of chapter 12 solution

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