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 process of designing a database, We are agree that the user should ...

We are agree that the user should be involved in the design of the database. Class, how would you go about the process of designing a database? What processes are involved?

Explain what is the market value of the bond, Knight, Inc., has issued a th...

Knight, Inc., has issued a three-year bond that pays a coupon of 5.00 percent. Coupon payments are made semi-annually. Given the market rate of interest of 3.70 percent, what is th

Explain how would you make a needs assessment, Suppose you were conducting ...

Suppose you were conducting a marketing analysis for a new textbook about technology management. What would you need to know to identify a market segment? How would you make a need

Explain safety stock would provide a stock out risk, The injection moulding...

The injection moulding department of a company uses an average of 30 gallons of special lubricant a day. The supply of the lubricant is replenished when the amount on hand is 170 g

Use cases, A case study presents an account of what happened to an organisa...

A case study presents an account of what happened to an organisation or business over a period of time. It chronicles the events that occurred within that organisation and which th

Line balancing, what do you understand by line balancing

what do you understand by line balancing

Explain what could go wrong as a result, Imagine the worst possible reports...

Imagine the worst possible reports from a system. What is wrong with them? List as many problems as you can. What are the consequences of such reports? What could go wrong as a res

Explain cosmetic window dressing, Do Whole Foods Market's mission/vision an...

Do Whole Foods Market's mission/vision and the core values as presented in cases Exhibit 1 and 3 really matter? Are they "real" or just cosmetic window dressing? What evidence can

Define productivity percentage change for each category, 1 Eric Johnson mak...

1 Eric Johnson makes billiard balls in his New England plant. With recent increases in his costs, he has a newfound interest in efficiency. Eric is interested in determining the pr

Explain objective of value stream mapping is to improve data, 1) Bill of ma...

1) Bill of material errors can cause serious problems for MRP system calculations of dependant demands 2) No matter what forecasting technique is used, the probability of a prod

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