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 annual demand for an airport metal detector, ABC distributors has a...

ABC distributors has an annual demand for an airport metal detector of 1,400 units. The cost of a typical detector to ABC is $400. Carrying cost is estimated to be 20% of the unit

Explain travel from the workstations to the main aisle, A portable lunch wa...

A portable lunch wagon is to be located along the main aisle of an industrial plant. The vendor wishes to locate the wagon so that the total walking distance for his customers is m

Scheduling, external factors affecting schedulling

external factors affecting schedulling

#tLean synchronization, Examples of how companies use lean synchronization ...

Examples of how companies use lean synchronization to reduce the environmental impact of their products

What are the main points of the new science of leadership, Based on the Lon...

Based on the London interview with Margaret Wheatley, "The New Science of Leadership," write 2 paragraphs describing Wheatley's theories and perspectives of leadership and organiza

Explain what would they have to learn elsewhere, What kinds of information ...

What kinds of information do you think recruiters can legitimately expect to learn on a social networking site? What would they have to learn elsewhere? How do you protect yourself

Explain where will the bottleneck in the system be, The process for renewin...

The process for renewing a driver's license at the Archer County Courthouse is as follows. First, the clerk fills out the application; then the clerk takes the driver's picture; an

Explain salary will the inducement comprise, Existing salary for managers i...

Existing salary for managers is 45,000 euros (58,567 US DOLLARS) PLUS BONUSES. AVERAGE SALARY FOR MANAGERS IN RANGE IS 60,000 EUROS (78,090), NO BONUSES. Recommendations must inclu

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