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 what is its current yield, Consider a $1,000 par value, 7% annual c...

Consider a $1,000 par value, 7% annual coupon bond. The bond matures in 9 years. Assuming the bonds required return is 10%, what is its current yield? (Semi-annually compounding)

Explain charlotte inventory levels, L. Houts Plastics is a large manufactur...

L. Houts Plastics is a large manufacturer of injection moulded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the informat

Explain objectives along with your reasoning for creating, Imagine you are ...

Imagine you are the product manager for a new electric car similar to the Chevrolet Volt. Using all your knowledge of the new product life cycle, speculate on the stages of the lif

Explain is overtime expense fully controllable, Is overtime expense fully c...

Is overtime expense fully controllable, partially controllable, or not at all controllable by the supervisor?

Explain technique to develop a forecast for the expected, air travel on Mou...

air travel on Mountain Airlines for the past 18 weeks was: Week Passengers 1 404 2 410 3 420 4 415 5 412 6 419 7 424 8 433 9 438 10 440 11 446 12 451 13 455 14 460 15 466 16 474 17

Explain what are cost and revenue relationships, Consider this statement: "...

Consider this statement: "To make effective decisions, managers must use basic cost and revenue relationships." What are cost and revenue relationships? Describe them in detail.

What are the advantages of using single sourcing strategies, What are the a...

What are the advantages of using single sourcing strategies? Advantages of using Single sourcing: a. Simple to keep relations along with only one supplier b. Simple to

Describe corporate strategy and ethical issues, Discuss corporate strategy ...

Discuss corporate strategy and ethical issues surrounding a human resource strategy cantered around hiring software engineers on work visas at equivalent salaries or sourcing engin

Plant location, factor relating methods for locating a plant

factor relating methods for locating a plant

Capacity planning, why is capacity planning important in operations managem...

why is capacity planning important in operations management

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