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 a product at each stage of the plc, Using the product life cycle, d...

Using the product life cycle, describe a product at each stage of the PLC and support your choice.

Industrial policy, Industrial Policy The course of action set by the go...

Industrial Policy The course of action set by the government to influence the development of domestic industrial sectors in particular and the direction of the national organiz

Explain what is the forecast error, The numbers of patient arrivals to the ...

The numbers of patient arrivals to the ER department at a local hospital for the past 5 weeks are: week: 1 , 2 , 3 , 4 , 5 arrivals: 405 ,420 , 400 , 380 , 411 a) Compute a three-w

Find loan payment than the lease payment, Sutton Corporation, which has a z...

Sutton Corporation, which has a zero tax rate due to tax loss carry-forwards, is considering a 5-year, $6,000,000 bank loan to finance service equipment. The loan has an interest r

Explain what professional credential do professionals, What steps would you...

What steps would you take to prepare yourself for a career as human resources director or vice president for human resources in a U.S. healthcare facility? What professional creden

Explain what short-run and long-run, What short-run, long-run and policy op...

What short-run, long-run and policy options are available to employers in lieu of layoffs? Explain.

Operations function - transformation processes and planning, Operations Fun...

Operations Function - Transformation Processes and Planning The operations function is concerned with the design of transformation processes, planning their use, and organisin

Concepts of collective bargaining process, The United Auto Workers union en...

The United Auto Workers union enters into contract negotiations with the Ford Motor Company in Michigan. What are the three main subject areas the UAW can negotiate with Ford? Prov

Explain productivity compared to having imported cars, During the 1950s and...

During the 1950s and 609, Mr. T. Ohno of Toyota developed the k an n Production System. Subsequently many other Japanese automobile companies adopted it. The net result with the Ja

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

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