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

Productivity of the organisation, Productivity of the Organisation Pro...

Productivity of the Organisation Productivity of the organisation is normally an operations problem - the operations function is usually the area of the company with the large

Thus if a budget is prepared it can only be a crude estimate, Frequently, a...

Frequently, at the time the project charter is prepared there is only a very general understanding of the project, so if a budget is prepared it can only be a crude estimate.

Process design, Process Design New product is not realities unit they...

Process Design New product is not realities unit they are manufactured. Process design is necessary to manufacture new products. Process design is concerned with the overall

Describe the concepts of lean production, Explain the concepts of lean prod...

Explain the concepts of lean production. Describe its relation to Six Sigma. Please provide examples of the pros and cons for linking them.

Explain what type of information must mititech''s suppliers, 1 To ensure th...

1 To ensure that its supply chain can handle a surge in demand, MitiTech should: a. hire additional manufacturing employees b. modify its design to speed up production time

I have some charts that i need help to put it in excel, I have soem charts ...

I have soem charts that were done i word how do I gt them to you for someone to put in excel for me

Use of post-operative patient controlled analgesia, Use of post-operative p...

Use of post-operative patient controlled analgesia: Does the use of post-operative patient controlled analgesia (pca) in hospital settings help reduce overall morphine consump

Introduction of operations strategy, Introduction of Operations Strategy ...

Introduction of Operations Strategy The term strategy, given in the Collins English Dictionary is, 'the art or science of the planning and conduct of a war; generalship; a lon

Explain how many hats should be in inventory, The Bryant Museum is open 360...

The Bryant Museum is open 360 days per year. On average, they sell 3 hounds tooth hats per day. Each hat sells for $16. The museum%u2019s holding cost is $1 / hat / month. Each ord

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