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 after a risk workshop has been completed, After a risk workshop has...

After a risk workshop has been completed, risk interviews are often completed with subject matter experts. Assess the value of the interviews to identify risk response strategies.

Organisations operations strategy, Question: Operations strategies are ...

Question: Operations strategies are developed to ensure managers deliver goods or services that are better, cheaper and more responsive to customer needs. Comment on any three

Explain kinds of skills needed by service workers, How does the degree of c...

How does the degree of customer contact relate to the kinds of skills needed by service workers and the degree of training they require?

Explain the focus and goals of organizational behaviour, Describe the focus...

Describe the focus and goals of Organizational Behaviour (OB). Why is this important to understand? How can this knowledge impact your career?

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

Briefly define the situational influences on organizational, Briefly explai...

Briefly explain the situational influences on organizational design

I need excel backup to understand a problem, Need Excel backup to understan...

Need Excel backup to understand how to answer this question. Bob White leaned back and wiped his forehead with his hand. He was the president of the home oven division of Winkley &

Describe a diet is being prepared for the university, A diet is being prepa...

A diet is being prepared for the University of Arizona dorms. The objective is to feed the students at the least cost, but the diet must have between 1,800 and 3,600 calories. No m

Explain graphically depict the interaction among its lunch, Big Bobs Burger...

Big Bobs Burger Barn would like to graphically depict the interaction among its lunch- ordering customers and its three employees. Customers come into the restaurant and eat there,

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