Consider the example of the town of Lincoln, which was analyzed using a multiplicative model in Figure
Question:
Consider the example of the town of Lincoln, which was analyzed using a multiplicative model in Figure 7.14. Repeat the forecasts using the additive model, with the same smoothing constants.
FIGURE 7.14 The Holt-Winters Method for the Town of Lincoln Example
a. What is the value of MSE corresponding to the multiplicative model in Figure 7.12?
FIGURE 7.12 Holt's Method for the Curtis Distributors Example
b. What is the value of MSE corresponding to the additive model with the same smoothing constants?
Transcribed Image Text:
Example for the Holt-Winters Method 1 Gamma 0.6 Alpha 0.2 Beta 0.5 4. Period Observed s(t) T(t) C(t) Forecast Error 8216 6303.0 0.0 1.30 9196 6303.0 0.0 1.46 3768 3 6303.0 0.0 0.60 6303.0 4032 0.0 0.64 10 7481 8216.0 735.0 6190.2 -56.4 1.25 11 6. 7889 5988.5 -129.1 1.37 8949.2 1060.2 F(t+ 1)=(5(1)+T())C(t+1-p) 12 3996 -46.6 0.64 3502.8 6024.4 13 3764 5959.1 -55.9 0.63 3824.0 60.0 14 6664 5791.8 -111.6 1.19 7358.4 694.4 15 10 7011 5564.6 -169.4 1.31 7804.5 793.5 16 11 4356 5683.6 -25.2 0.71 3437.3 -918.7 17 27.3 12 3565 5649.8 -29.5 0.63 3592.3 18 HIH7.7/7.8 7.9 7.10 7.14 0 7.11 7.12 7.13 H. 1 Example for Holt's Method 2 3 Alpha 0.2 Beta 0.5 4 Period Observed S(t) T(t) Forecast Error 66 66.0 0.0 69 бб.6 0.3 75 68.5 1.1 66.9 -8.1 72 70.1 1.3 69.6 2.4 10 92 75.6 71.5 -20.5 -4.0 F(t+1) = S(t)+T(t) 79.0 83.6 11 83 79.8 3.8 12 94 85.7 4.8 -10.4 90.5T()=B(S(1)-S(t-1))+(1-B)T(t-1) 99.7 13 8. 105 93.4 6.3 14 90 97.8 5.3 9.7 15 10 112 104.9 6.2 s(t) = ax(t) + (1-a)(S(t-1)+T(t-1) %3D 16 11 99 108.7 5.0 17 12 107 112.3 4.3 113.7 6.7 18 13 120 117.3 4.7 116.7 -3.3 19 14 114 120.4 3.9 122.0 8.0 20 15 138 127.0 5.2 124.3 -13.7 21 16 124 130.6 4.4 132.3 8.3 22 17 146 137.2 5.5 135.0 -11.0 23 18 143 142.8 5.5 142.7 -0.3 24 19 131 144.9 3.8 148.3 17.3 25 20 151 149.1 4.0 148.7 -2.3 26 7.7 7.8 7.9 7.10 7.11 7.12 0 E.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 81% (11 reviews)
The forecasted value obtained from exponential smoothing with trend and cyclical factor method is of less error comparing to other methods This method is of two types they are additive method and mult...View the full answer
Answered By
Akshay Singla
as a qualified engineering expert i am able to offer you my extensive knowledge with real solutions in regards to planning and practices in this field. i am able to assist you from the beginning of your projects, quizzes, exams, reports, etc. i provide detailed and accurate solutions.
i have solved many difficult problems and their results are extremely good and satisfactory.
i am an expert who can provide assistance in task of all topics from basic level to advance research level. i am working as a part time lecturer at university level in renowned institute. i usually design the coursework in my specified topics. i have an experience of more than 5 years in research.
i have been awarded with the state awards in doing research in the fields of science and technology.
recently i have built the prototype of a plane which is carefully made after analyzing all the laws and principles involved in flying and its function.
1. bachelor of technology in mechanical engineering from indian institute of technology (iit)
2. award of excellence in completing course in autocad, engineering drawing, report writing, etc
4.70+
48+ Reviews
56+ Question Solved
Related Book For
Management Science The Art Of Modeling With Spreadsheets
ISBN: 1301
4th Edition
Authors: Stephen G. Powell, Kenneth R. Baker
Question Posted:
Students also viewed these Numerical Analysis questions
-
Consider the example of a nonconvex programming problem presented in Sec. 13.10 and depicted in Fig. 13.18.
-
Consider the example of the new product at Curtis Distributors, which was analyzed using Holt's method in Figure 7.12. Repeat the forecasts using one smaller value of a than the value of 0.2 used in...
-
Consider the example of Figure 7.7, in which the smoothing constant was taken to be α = 0:2. Repeat the calculations for smoothing constants between 0.1 and 0.9, in steps of 0.1. FIGURE...
-
The bookkeeper of Cinnamon Ltd. who is usually responsible for the bank reconciliation is on holiday. Before she left she asked you to do this task for her. On March 31, you are given the bank...
-
Rank each of the following series of compounds in order of increasing oxidationlevel: CI (a) (b) CH3CN CH3CH2NH2 H2NCH2CH2NH2
-
A metallurgical engineer is considering two materials for use in a space vehicle. All estimates are made. (a) Which should be selected on the basis of a present worth comparison at an interest rate...
-
Explain the important objectives of transport costing.
-
Identify the key challenges that the Big Four firms will likely face in their efforts to establish a major presence in the Islamic banking industry.
-
Euro Travel uses the contribution margin income statement internally. Euro's first quarter results are as follows: ( Click the icon to view the income statement. ) Euro's relevant range is sales of...
-
Use the data from Problem 1 to plot the worker's daily money income-leisure trade-off line. To do so, calculate her daily pension and assume 150 working hours in a month. Assume that the worker is...
-
The database Book Club.xlsx contains data on a number of current customers of a direct-mail book club. a. How many records are in this database? b. How many fields are in this database? c. How many...
-
The operations manager at a manufacturing facility is about to begin an energy-efficiency initiative. As this program begins, it will be helpful to have benchmark data on energy use, in order to...
-
An American currency speculator feels strongly that the value of the Canadian dollar is going to fall relative to the U.S. dollar over the short run. If he wants to profit from these expectations,...
-
Case Study : While it might be easy to see the negative effects on the environment from car emissions or the waste we produce, fewer people think about the effects of discarded clothes on the...
-
CompanyWeek 8 Assignment - Financial Statement Analysis Overview In this assignment, you will take your work with financial statements to the next level. You will analyze financial statements similar...
-
In Exercises 9-12, assume that 100 births are randomly selected. Use subjective judgment to describe the given number of girls as (a) significantly low, (b) significantly high, or (c) neither...
-
Which of the following is not included in the cash flow statement? a. Cash from short-term investments b. Cash from operations c. Cash from the balance sheet d. Cash from capital financing Which of...
-
Case Study Chapter 13B Pharm - Saved Case Study Chapter 13 Central Nervous System Stimulants and Related Drugs Nancy has been unsuccessful in preventing migraine headaches and has been prescribed a...
-
The following information relates to the year ended 30 November 20*8 for the business of Rob Berry: stock at 1 December 20*7 1,657; stock at 30 November 20*8 2,004; purchases 54,672; sales 98,651;...
-
Borrowing costs should be recognised as an expense and charged to the profit and loss account of the period in which they are incurred : A. If the borrowing costs relate to qualifying asset B. If the...
-
The relationship between the time it takes to complete a project and the number of people assigned to work on it.
-
The relationship between the cost of manufacturing a product and the cumulative quantity produced.
-
The relationship between the effectiveness of a new drug and the amount spent on R&D.
-
Minden Company introduced a new product last year for which it is trying to find an optimal selling price. Marketing studies suggest that the company can increase sales by 5,000 units for each $2...
-
Prepare the adjusting journal entries and Post the adjusting journal entries to the T-accounts and adjust the trial balance. Dresser paid the interest due on the Bonds Payable on January 1. Dresser...
-
Venneman Company produces a product that requires 7 standard pounds per unit. The standard price is $11.50 per pound. If 3,900 units required 28,400 pounds, which were purchased at $10.92 per pound,...
Study smarter with the SolutionInn App