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 human resource objectives essential for the company, Why do human r...

Why do human resource objectives essential for the company to succeed?

Principle of scheduling, Principle of Scheduling First Principle optim...

Principle of Scheduling First Principle optimum Task Size : scheduling tens to achieve its maximum efficient task sizes are small and all tasks are of the same order of magnit

Explain ways you expect to use format design, Commercial and personal Websi...

Commercial and personal Websites, as well as print media, design their formats and include visuals for optimal audience appeal. Select a Website or print medium for this reflective

Explain why is this qbe implementation so effective, Identify an Internet s...

Identify an Internet site that has a very effective Query-by-Example (QBE) implementation for complex queries (multiple simultaneous attributes/fields) to efficiently navigate amon

Explain the method of job evaluation, Explain the method of job evaluation....

Explain the method of job evaluation. Method of job evaluation: Following are the methods wherein job evaluation is done:- a) Ranking method. b) Classification method.

Line balancing, What do you understand by “line balancing”? What happens if...

What do you understand by “line balancing”? What happens if balance doesn’t exist?

Explain disadvantages of functional systems and briefly, In this case study...

In this case study, you will review a case involving a functional system. The Lynx Company uses a functional system for their sales system. It takes the orders from their salesm

Substitute favourable market unfavourable market build, Karen Villagomez, p...

Karen Villagomez, president of Wright Industries, is considering whether to build a manufacturing plant in the Ozarks. Her decision is summarized in the following table: Alternativ

Linear programing, Linear objective function & non linear objective functio...

Linear objective function & non linear objective function.

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