Question: Develop an exponential smoothing forecast with = 0.20 for the demand data in Problem 12-1. Compare this forecast with the three-month moving average computed

Develop an exponential smoothing forecast with α = 0.20 for the demand data in Problem 12-1. Compare this forecast with the three-month moving average computed in 12-1(a) using MAD and indicate which forecast seems to be most accurate.

Step by Step Solution

★★★★★

3.42 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The 3month moving average forecast appears to be more accurate Month Demand Forecast ... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

184_606ee5f39843b_143074.xlsx

300 KBs Excel File

Students Have Also Explored These Related Management Leadership Questions!

Develop an exponential smoothing forecast with a = .20 for the demand data in Problem 1. Compare this forecast with the 3-month moving average computed in part (a) of Problem 1, using MAD, and...

a. Create a 4-period moving average forecast, an exponential smoothing forecast with alpha=0.2, and a linear trend forecast for your data. b. Calculate the MSE and MAD for each. c. Plot the original...

For the data in Problem 5-42, develop an exponential smoothing model with a smoothing constant of 0.3. Using the MSE, compare this with the model in Problem 5-42. In Problem 5-42, The following table...

12.28 Develop an exponential smoothing forecast with = .20 for the demand data in Problem 12.1. Compare this forecast with the three-month moving average computed in 12.1a. using MAD and indicate...

Problem 6-11 For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83. Choose the correct time...

5. Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23 13 21 13 19 21 17 (a) Choose the correct time series plot. (1) 30 25 20 Value 15 10 5 0 1 2 5 7 4 Month (11) 30 25 20 Value 10...

20 Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize. a....

Calculate the mean absolute deviation (MAD) for the forecasts made by each technique in periods 412. (Round your answers to 3 decimal places.) I ONLY NEED THE ANSWER TO e1. 3rd time posting this...

e-1. Calculate the mean absolute deviation (MAD) for the forecasts made by each technique in periods 412. (Round your answers to 3 decimal places.) ********I ONYL NEED THE ANSWER to e1****** Your...

Your manager is trying to determine what forecasting method to use. Based upon the following historical data, caiculate the following forecast and specify what procedure you would utilize. a....

Determine the average and rms values of the following waveform. 4 Figure 9FE-2

In Problem 36, the Blue Sox general manager has asked a superscout to assign a probability to each of the three states of nature for the pitchers during the next 10 years. The scout estimates there...

you record _ _ _ _ on an income and expense statement. your charitable payments, your checking account balance, your cash on hand

4. T or F Past performance is the best basis for setting control standards.

MagTech assembles Blu-ray players from four major components arranged as follows: The components can be purchased from three different vendors, who have supplied the following reliability data: a. If...

Dfinity promises its customers that network services are 90% reliability. The network consists of three serial nodes, each of which must work for the network to be operational. Consistent with its...

Identify, Inc. guarantees that it can correctly identify individuals from three pieces of informationdate of birth, place of birth, and profession. In reality, whether Identify can keep that...

Write a program called CozaLozaWoza which prints the numbers 1 to 1 1 0 , 1 1 numbers per line. The program shall print "Coza" in place of the numbers which are multiples of 3 , "Loza" for multiples...

Hoping someone can help me here because my teacher never teach this lesson just handing out a lecture only. Even I search, I am still can't understand. Thank you! 1. The following are the Math final...

The General Hospital is evaluating new office equipment offered by three companies. In each case the interest rate is 15% and the useful life of the equipment is four years. Use NPW analysis to...