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

Define pizza delivery process design requirements, Pizza USA is a chain of ...

Pizza USA is a chain of pizza restaurants offers sit down and take out service. Part I as the customer: make a list of the attributes of a pizza delivery of pizza delivery that are

Find average inventory, A grocery store needs to sell 3,000 cartons of 2L 2...

A grocery store needs to sell 3,000 cartons of 2L 2% milk per month. The sales is relatively constant throughout the month. The owner of this grocery store purchases milk from a su

Explain lower control limits for mean and range charts, Determine upper and...

Determine upper and lower control limits for mean and range charts.

How to determine the capacity requirements, Electronics assembly operates t...

Electronics assembly operates two 8 hours shifts for 275 days per year. Use this information in the table to determine the capacity requirements. Cell Phone Demand forecast (phones

What are the qualities you believe are important in a leader, Name three qu...

Name three qualities you believe are important in a leader. Elaborate on each of those qualities. Do you think a leader today has to be more aware of their ethical behaviours than

Explain affect your overall impression of the candidate, How does the use o...

How does the use of music in political play a role in establishing a candidate's brand? Does a candidate's use of a song you like (or dislike) affect your overall impression of the

Explain how much of an impact does maturity, 1. How much of an impact does ...

1. How much of an impact does "maturity" level of the industry or company have on strategy? 2. Can you be innovative in a mature industry? 3. Can you be conservative in an in

Explain what is the college education fee, On the day his son was born, a f...

On the day his son was born, a father decided to establish a fund for his son's college education. The father wants the son to be able to withdraw $4000 from the fund on his 18th b

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