Question: 3 Using simple exponential smoothing and the following time series data, respond to each of the items. Period Demand 1 126 25 2 112 points

3 Using simple exponential smoothing and the following time series data, respond to each of the items. Period Demand 1 126 25 2 112 points 3 135 4 145 ipped 5 166 6 161 7

132 s 141 eBook 9 116 1a 131 Print References Click here

for the Excel Data File b. Compute all possible forecasts using a

3 Using simple exponential smoothing and the following time series data, respond to each of the items. Period Demand 1 126 25 2 112 points 3 135 4 145 ipped 5 166 6 161 7 132 s 141 eBook 9 116 1a 131 Print References Click here for the Excel Data File b. Compute all possible forecasts using a smoothing coefficient (a) of 0.35. (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places.) 4 Check my work 3 c. Compute all possible forecasts using a smoothing coefficient (a) of 0.85. (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places.) 25 points Period Demand Exponential Smooth Error Absolute Error Skipped 1 126 N 112 3 135 eBook 4 145 Print 5 106 References 6 101 7 132 8 141 9 110 10 131 11Check my work 3 d. Compute the MADs for each exponential smoothing forecast. (Round your answers to 2 decimal places.) Average Forecast For an alpha of 0.35, the MAD 25 points For an alpha of 0.85, the MAD Skipped eBook Print References e. Which forecast model would you choose? Why? The forecast using the smoothing coefficient (a) of model is to be chosen because it has a measure of error (MAD)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Using simple exponential smoothing and the following time series data, respond to each of the items. (Note the data are the same as exercise 5.) a. G raph the time series data. What do you observe?...

Using simple exponential smoothing and the following time series data, respond to each of the items. (Note the data are the same as exercise 8.) a. G raph the time series data. What do you observe?...

1 Using simple exponential smoothing and the following time series data, respond to each of the items. \ table [ [ Period , Demand ] , [ 1 , 1 1 8 ] , [ 2 , 1 4 6 ] , [ 3 , 1 5 7 ] , [ 4 , 1 5 1 ] ,...

Using simple exponential smoothing and the following time series data, respond to each of the items. (Note the data are the same as exercise 6.) Period Demand 1 . . . . . . . . . . . . . . . . . . ....

Exercise 1 8 - 9 ( Algo ) ( LO 1 8 - 3 , LO 1 8 - 4 ) Using simple exponential smoothing and the following time series data, respond to each of the items. Period Demand 1 1 2 4 2 1 5 2 3 1 6 3 4 1 5...

Using simple exponential smoothing and the following time series data, respond to each of the items. Period Demand 1 1 0 8 2 1 3 6 3 1 4 7 4 1 4 1 5 1 5 0 6 1 5 4 7 1 0 5 8 1 3 0 9 1 2 0 1 0 1 1 9...

Using simple exponential smoothing and the following time series data, respond to each of the items. \ table [ [ Period , Demand ] , [ 1 , 1 2 0 ] , [ 2 , 1 4 8 ] , [ 3 , 1 5 9 ] , [ 4 , 1 5 3 ] , [...

Using simple exponential smoothing and the following time series data, respond to each of the items. Required: Click here for the Excel Data File b. Compute all possible forecasts using a smoothing...

Easton Diagnostics is a large medical testing laboratory that services a four- county region. Easton runs a van that picks up specimens from clinics and hospitals and takes them to the Easton...

Write a program that reads a string from a text file and determines if the string is a palindrome or not. Use a Stack and a Queue to check for the palindrome.

( 8 pts ) Analyze the following limits . You must show work / reasoning with graphical or analytical methods. You don't need to do separate work for each part. a . lim x 4 x - 3 x 2 - 4 x b . , lim x...

(a) Compute net operating profit after tax (NOPAT) for 2010. Assume that the combined federal and statutory rate is: 37.0%. (Hint: Treat equity in income of affiliates as operating. Round your answer...

If stock prices follow a random walk then capital markets are little different from a casino. Explain. True or False: Given the fact that a large portion of a companys future prospects are...

1.A firms Demand Function is Q = 100 2.5*Q. When the firm sets the price to maximize total revenue (TR), then TR will be _______.

Nike 2004 create an SBU analysis based on annual report. where which increased investments maintain current investments, divest of curren investments (get rid of lines) what is the business level...

A format changes the appearance of a cell based on a criterion. conditional specified rule - based logical

We discussed functional organizational structures. What does this mean? What functions would be represented by an executive committee for a full-service resort hotel? LO8

Describe global, organizational and individual learning systems and career development.

Consider the Work Life Development model listed in the chapter. Can you think of people that you know who are in each stage? What behaviors or thinking do they demonstrate? What stage are you...