Question: The Sales2 variable in the file from the previous problem was created from the Sales1 variable by multiplying by monthly seasonal factors. Basically, the summer

The Sales2 variable in the file from the previous problem was created from the Sales1 variable by multiplying by monthly seasonal factors. Basically, the summer months are high and the winter months are low. This might represent the sales of a product that has a linear trend and seasonality.
a. Repeat parts a, b, and c from the previous problem to see how well these forecasting methods can deal with trend and seasonality.
b. Now use Winters’ method, with various values of the three smoothing constants, to forecast the series. Can you do much better? Which smoothing constants work well?
c. Use the ratio-to-moving-average method, where you first de-seasonalize the series and then forecast (by any appropriate method) the de-seasonalized series. Does this perform as well as, or better than, Winters’ method?
d. What can you conclude from your findings in parts a, b, and c about forecasting this type of series?

Step by Step Solution

★★★★★

3.27 Rating (171 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespacenowrap msorotate0 msobackgroundsourceauto msopatt... 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)

415_6070044e42b49_265538.xlsx

300 KBs Excel File

Students Have Also Explored These Related Statistics Questions!

The manufacturer of a product that has a variable cost of $2.50 per unit and total fixed cost of $125,000 wants to determine the level of output necessary to avoid losses. a. What level of sales is...

A marketing researcher studied annual sales of a product that had been introduced 10 years ago. The data are as follows, where X is the year (coded) and Y is sales in thousands of units: i: 1 2 3 4 5...

You are a consumer of a product that your country imports. There is an increase in demand in the rest of the world for this type of product. You are wondering if this change will be good or bad for...

Cutting Edge This case was adapted from Hiller, Frederick S. & Mark S. Hillier (2014). Introduction to Management Science: A Modeling and Case Studies Approach with Spreadsheets, 5th ed.,...

PLEASE COMPLETE NO LATER THAN 10/07 @8:00AM Each question(1,2,& 3) must be a minimum of 200 words. Please make answers detailed and knowledgeable based off the attached reading. ARE YOU ABLE TO...

Please see attachment. All three question need to be answered in narrative format. If you have questions, just let me know. Normal requirement for references are 2 outside our course text....

IOE 419 Mark S. Daskin Service Operations Management IOE Department Winter, 2017 University of Michigan Problem set 4 DUE: MONDAY - February 20, 2017 Points: 100 points total Problem 1: Babette has...

In Chapter 3, you were introduced to 3 types of costs associated with a manufactured product ? direct materials, direct labor, and manufacturing overhead. Explain how these costs are associated with...

Assume: A=3,B=1 find x(t), assume a proper values to A and B. X(2) = A 2-BZ (Z2)? Solve

TD Ltd is comprised of 4 major projects, details of which as follows: % of the Co. % returns Risk (%) Std. Deviation 15 Project with 1 2 3 4 Market value 28 17 31 24 Required: a) p.a. 10 18 15 13 20...

8 What kind of tide occurs when the Moon, Earth and Sun are all in line?

E16-21 Preparing the statement of cash flowsindirect method The comparative balance sheet of Darazi Company, for 2013 and the preceding year ended December 31, 2012, appears below in condensed form:...

Amir made taxable gifts as follows: $800,000 in 1975, $1.2 million in 1999, and $600,000 in 2017. What is Amirs gift tax liability for 2017?

Yolanda and Xavier, spouses, have four adult children, Andy, Betty, Cathy, and Danny. In 2017, they made a number of gifts. Yolanda gave Andy cash of $40,000 and Betty stock valued at $60,000. Xavier...

Refer to the facts of Problem C:12-36 and assume the current year is 2017. Emilys prior gifts are as follows: Year ___________Amount of Taxable Gifts 1974 ......................... $ 500,000 1998...

Which of the following statements is True? Select one: The floating rate regularly adjusts to a reference rate. O b. None of the options are correct. O c. The term 'spot loan' refers to a loan that...

Please answer question 2 in excel, with cell reference please! If a firm has a payout ratio of 6 5 % and a ROE on projects of 1 1 % , what is the growth rate for the firm? Assume a firm has a cost of...

HELP PLEASE (Individual or component costs of capital) Compute the cost of capital for the firn for the folowing a. Currently bonds with a simlar credt rating and matunty as the firris cutatanding...