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

Digital Cell Phone Inc., Prepare Paul Jordan''s report to John Smithers usi...

Prepare Paul Jordan''s report to John Smithers using regression analysis. Provide a summary of the cell phone industry outlook as part of Paul''s response.n..

Explain the size and timing of planned-order, A firm that produces wood shu...

A firm that produces wood shutters and bookcases has received two orders for shutters: one for 100 shutters and one for 150 shutters. The 100-unit order is due at the start of week

Explain inhumane labor standards, A few years ago, several U.S. retailers w...

A few years ago, several U.S. retailers were sued in Los Angeles courts for human rights abuses associates with contract manufactures located in the Marianas Islands, a territory o

Evaluate the two competitor''s strategies, As the industry watches to see h...

As the industry watches to see how United Airlines' strategy performs against American Airlines' strategy, management at United Airlines is anxiously monitoring market signs to det

What the cafeteria should use, A cafeteria wants to introduce a new burger,...

A cafeteria wants to introduce a new burger, with bread and beef together weighing at least 1 ounce. The cafeteria manage also wants the new burger to meet a new nutrition standard

Explain if the telethon sued me for my pledge, I was watching a telethon on...

I was watching a telethon on the TV late on evening. I was so moved by the telethon; I called and pledged $10,000. In the morning when I informed my husband what I pledged, he w

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

Current trends in operation management, What is the relationship between ma...

What is the relationship between mass customisation and rapid product development

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

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