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 smoothing constan, Systembolaget uses forecasting to predict the nu...

Systembolaget uses forecasting to predict the number of bottles they think they will sell the next day. Below are the number of bottles sold each day during the five-day work week

Explain what is the cheapest cost for meeting, ABC Machine Shop, Inc., has ...

ABC Machine Shop, Inc., has a 1-year contract for the production of 48,000 gear housings for a new off-road vehicle. ABC hopes that the contract will be extended and the production

Explain implementation of a transnational strategy, What do you see as the ...

What do you see as the main organizational problems that are likely to be associated with implementation of a transnational strategy? Explain

Capacity implication, how can make a plan for appropriate capacity of a cin...

how can make a plan for appropriate capacity of a cinema by replacing amount of standard seats with luxury seats?

Explain assemble a computer mouse, You have been asked to set up an assembl...

You have been asked to set up an assembly line to assemble a computer mouse. The precedence network is shown below; task times in minutes are given in parentheses. There are 480 mi

Definitions of productivity, Definitions of Productivity 1. Pro...

Definitions of Productivity 1. Productivity is the relationship between output generated by a production or service system and the input provided to create the output.

Explain statutory law, Statutory law is: Answer a law enacted by a legislat...

Statutory law is: Answer a law enacted by a legislative body also known as the fundamental law of the nation a form of common law the separation of powers at the federal level all

Moving average in local organic food market, Weekly sales of 10-grain bread...

Weekly sales of 10-grain bread at the local organic food market are in the table below. Based on this data, forecast Week 9 using a five-week moving average. Week Sales 1

Complete the below table using rationale, Complete the below table. Which o...

Complete the below table. Which one of these techniques would you recommend to use and indicate your rationale? Technique Ave Bias Ave MAD MSE Ave MAPE Naïve

Manufacturing sector - car industry, Manufacturing Sector - Car Industry ...

Manufacturing Sector - Car Industry 1. A new era of globalisation 2. Current over capacity - increased competition - price pressure 3. Reduction in the number of compani

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