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

How several more hours of overtime would each worker, Games4U makes video g...

Games4U makes video games on CDs at its Old Town plant. The plant produces 800 games each day, and employs 100 workers that work 8 hours each day. They use the following resources

.Operational Plan and Budget, Can you create a Operational Plan and Budget ...

Can you create a Operational Plan and Budget if I provide instruction. Also need budget plan to be placed in excel

How did the corporation performs in the return on investment, How did the c...

How did the corporation perform the past year overall in terms of return on investment, market share, and profitability?

Hill approach to manufacturing operations, Hill Approach to Manufacturing O...

Hill Approach to Manufacturing Operations - Operation Management  Hill's five step approach to developing manufacturing operations illustrated in table below (Hill, 1993). A

Explain what is your best choice using emv criterion, Dalton and Carla run ...

Dalton and Carla run a small bicycle shop called "D n C"Bicycles. They must order bicycles for the coming season. Orders for the bicycle must be placed in quantities of twenty(20).

Explain break even analysis, Explain Break Even Analysis. Break Even A...

Explain Break Even Analysis. Break Even Analysis: This Analysis implies that at several points in the operations, total revenue equivalent total cost. This analysis is concer

Succession planning and workforce plan evaluation, Succession Planning and ...

Succession Planning and Workforce Plan Evaluation Develop a succession plan that addresses internal labour needs in the medium to long term, utilising succession planning princ

When good faith bargaining requires, Good faith bargaining requires the par...

Good faith bargaining requires the parties to come to an agreement about both mandatory and permissive items

What is cutting stock problem, Consider the cutting stock problem that aris...

Consider the cutting stock problem that arises when a company manufactures sheets of standard width 100 and has commitments to supply 40 sections of width 40, 60 sections of width

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