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 transnational model, Q1. Is changing the organization's domain a fe...

Q1. Is changing the organization's domain a feasible strategy for coping with a threatening environment? Can you think of an organization in the recent news that has changed its do

Calculate the expected value of perfect information, A small building contr...

A small building contractor has recently experienced two successive years in which work opportunities exceeded the firm's capacity. The contractor must now make a decision on capac

Describe what are the advantages of financing, In the %u201CWhat would you ...

In the %u201CWhat would you do?%u201D section of your text in Chapter 9, Pam Marrone of AgraQuest, Inc. tapped into Internet sources when she needed additional financing. Be specif

Explain what is the contribution ratio, Foster Company makes power tools. T...

Foster Company makes power tools. The budgeted sales are $420,000, budgeted variable costs are $147,000, and budgeted fixed costs are $227,500. What is the budgeted operating in

Draw a 3-sigma p-chart using this information, The results of inspection of...

The results of inspection of DNA samples taken over the past 10 days are given below. Sample size is 100. Days: 1 2 3 4 5 6 7 8 9 10 Defectives: 7 6 6 9 5 6 0 8 9 1 a) Con

Explain why do resource constraints affect project results, Explain work br...

Explain work breakdown structure. Why do resource constraints affect project results?

Problem, a firm isconsidering replacement of a machien, whoes cost price is...

a firm isconsidering replacement of a machien, whoes cost price is rs 12200 and scrap value is rs 200 the running cost is rupee given below year running cost 1 200 2 50

Role or forecasting in capacity planning, Role or Forecasting in capacity P...

Role or Forecasting in capacity Planning The marketing department plays a major role in providing demand forecasts based on which both long term as well as short term capacity p

Explain benefits of free international trade, What are the benefits and dis...

What are the benefits and disadvantages of free international trade for the United States? Examples would be helpful also.

Explain consistency and standardization, The big problem a franchisor faces...

The big problem a franchisor faces is maintaining quality control; franchisees do not always exhibit strong commitment to consistency and standardization. WHAT IS ANOTHER problem t

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