Question: 9. Use a spreadsheet program to compare a three-period moving-average forecasting model with a basic exponential smoothing model (ESF). Ten periods of past actual

9. Use a spreadsheet program to compare a three-period moving-average forecasting model with a basic exponential smoothing model (ESF). Ten periods of past actual demand data are available (27, 26, 32, 41, 28, 35, 43, 47, 28, and 38). Use the first five periods' data to seed the model (as described next) and the last five periods to test the model. a. Use the average of the first five periods to seed the ESF model (i.e., the "past forecast") and a smoothing model with a = 0.3. Compare this ESF model with a three-period moving average model using the last five periods of data. Use MAD as the criterion for comparing the techniques. b. Does your comparison change if you use the past three periods' data to seed the ESF model? What is the best alpha (smoothing) value to use for this model?

Step by Step Solution

★★★★★

3.47 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To answer this question we need to perform the following steps 1 Calculate the average of the first five periods to seed the Exponential Smoothing For... 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

Students Have Also Explored These Related General Management Questions!

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...

The ABC Floral Shop from problem 3 is considering fitting various forecasting models on the first seven days of demand and using the second seven days as a hold-out sample for comparing the pre...

Table # 11.1.1: Autism Versus Breastfeeding Breast Feeding Timelines Autism Yes No None 241 20 Column Total 261 Less than 2 months 198 25 223 2 to 6 months 164 27 191 More than 6 months 215 44 259...

If you thought a stock was fairly valued and its price would not change, how could you use a straddle to take advantage of your valuation? If you follow this strategy and the stocks price does not...

What type of circuit provides the select inputs when a MUX is used as a parallel-to-serial converter?

=+a) How would you code the variables? (How many dummy variables do you need? What values would they have?)

Calculating and explaining labor price and usage variances Huber and Sons, a CPA firm, established the following standard labor cost data for completing what the firm referred to as a Class 2 tax...

c) d) component. Explain two fundamental and Explain the concept of capital maintenance and the two main two enhancing qualities of accounting information. capital maintenance concepts e) Discuss...

U.P.I. Industries Ltd., a Canadian corporation, has recently been designated a public corporation. Its shares are traded on the Winnipeg Stock Exchange. Over the past year, the company has pursued an...

Which of the following is true with respect to the price elasticity of demand? Group of answer choices Elasticity will tend to be greater for a relatively expensive product than for a cheaper one. A...

Asmt Analysis 3. Students drop a tennis ball to see how position changes with time in free fall. They measure position with a meterstick and time with a timer. The data they collected is shown....

You have just been promoted to the top administrative position in your organization (or any other real organization of your choice). Analyze and describe the existing situation from an organizational...

Hunter is a new federal borough of investigation agent who is assigned to Las Vegas. He owns a midnight sedan insured by a personal auto policy. The FBI will not provide Hunter with a car so he will...

Research Paper Outline Introduction 1)Non-Compete Agreements- define what is a non compete agreement, history, and why they were created 2) When are these agreements enforceable i.e. definition and...

You are managing a medium size construction company suffering from employee absence , staff turnover and low productivity. You want to train you divisional managers to influence their teams to...

[The following information applies to the questions displayed below.] Sandras Purse Boutique has the following transactions related to its top-selling Gucci purse for the month of October. Sandra's...

Michelles trust is subject to 3.8% surtax on the lesser of the trusts net investment income or the excess of the trusts adjusted gross income over the $12,400 threshold (the highest trust tax rate)....

Using the same information as in Problem 16, develop the best policies for a periodic-review system. Thus, Demand (D) = 94 units/week (assume 52 weeks per year) Ordering and setup cost (S) =...

The Best Beer Corporation has a beer-processing facility located in Columbus, Ohio. The beer facility has a system efficiency of 90 percent, and the utilization is 80 percent. Three sub-facilities...

Clark Lawnmower Supply, Inc. stocks everything retail garden stores require for lawnmower repairs. A particular mower blade has been very popular with local garden stores as well as those who buy on...

10.28. Suppose that Aj = father's education is positively associated with Y = son's income at age 40. However, for the regression analysis conducted separately at fixed levels of X2 = son's...

10.29. Table 10.9 shows the mean number of children in Canadian families, classified by whether the family was English speaking or French speaking and by whether the family lived in Quebec or in...

10.41. A study (in Adolescence, vol. 335, 2000, p. 445) reported a sample correlation of 0.45 between depression and loneliness and 0.74 between loneliness and self-esteem. True or false: By the...