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 supermarket is monitored using a range, Checkout time at a supermar...

Checkout time at a supermarket is monitored using a range and mean chart. Six samples which contain 20 observations per sample have been collected and the sample means and sample r

Explain importance and enforcement of consumer rights, Compare a Utilitaria...

Compare a Utilitarian and a Libertarian view on the importance and enforcement of consumer rights (to choose, to safety, to be informed, to be heard, to redress and to privacy).

Explain what types of interpretations might a consumer make, Reflect on the...

Reflect on the GEICO commercials you have seen and those discussed in your textbook. One of the things that these ads do is invite the audience to become involved and make an inter

Consider the one-period-ahead forecasts, Do NOT use Minitab for this proble...

Do NOT use Minitab for this problem; you may use Excel. Handy, Inc. produces a solar powered electronic calculator that has experienced the following monthly sales history for the

Explain changing the manufacturing process, Your company makes baby seats f...

Your company makes baby seats for cars and RVs. Your main product was designed some time ago, and new and better engineering data are available, but your product has a good record

Explain choosing a new piece of equipment, The following table shows the cr...

The following table shows the critical factors in a company's decision on choosing a new piece of equipment. Calculate the breakeven volume and utilization for each option and then

Define the amount of fabric she needs is to forecast, The percentage of val...

The percentage of value of shipments that come from materials for the average manufacturer is: a. greater than or equal to 40 and less than or equal to 49 percent. b. greater than

Explain a plan of viable business options for family fabrics, Case 1: You a...

Case 1: You are a consultant for a Fabric company that burned down, this company was the only source of income for many of the town people they all worked there, as a consultant to

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

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

Explain what is the tax on salvage value, Mars Inc. is considering the purc...

Mars Inc. is considering the purchase of a new machine that will reduce manufacturing costs by $5,000 annually. Mars will use the MACRS accelerated method to depreciate the machine

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