Question

In: Statistics and Probability

Year Qtr t revenue ($M) 2011 1 1 5.889 2 2 6.141 3 3 8.272 4...

Year Qtr t revenue ($M)
2011 1 1 5.889
2 2 6.141
3 3 8.272
4 4 9.302
2012 1 5 6.436
2 6 6.932
3 7 8.987
4 8 10.602
2013 1 9 7.517
2 10 7.731
3 11 9.883
4 12 12.098
2014 1 13 8.487
2 14 8.685
3 15 11.559
4 16 15.221
2015 1 17 11.132
2 18 11.203
3 19 13.83
4 20 16.979
2016 1 21 12.312
2 22 13.452
3 23 17.659
4 24 21.655
2017 1 25 17.197
2 26 19.05
3 27 22.499
4 28 25.629

State the method ( Winter's additive or multiplicative) which is the most accurate to forecast for 2018 according to the data set?

Solutions

Expert Solution

From the scatter plot, increase the value of time, increases the corresponding value of revenue as a whole. Hence, this data presence the trend component. Also, there is a repeating short-term cycle with this series for every four data points. Hence, it also presence the seasonal component. Therefore, the most suitable model is to include both the trend and seasonal component in the model.

Arrange the given data as

Year Qtr t revenue Q1 Q2 Q3
2011 1 1 5.889 1 0 0
2 2 6.141 0 1 0
3 3 8.272 0 0 1
4 4 9.302 0 0 0
2012 1 5 6.436 1 0 0
2 6 6.932 0 1 0
3 7 8.987 0 0 1
4 8 10.602 0 0 0
2013 1 9 7.517 1 0 0
2 10 7.731 0 1 0
3 11 9.883 0 0 1
4 12 12.098 0 0 0
2014 1 13 8.487 1 0 0
2 14 8.685 0 1 0
3 15 11.559 0 0 1
4 16 15.221 0 0 0
2015 1 17 11.132 1 0 0
2 18 11.203 0 1 0
3 19 13.83 0 0 1
4 20 16.979 0 0 0
2016 1 21 12.312 1 0 0
2 22 13.452 0 1 0
3 23 17.659 0 0 1
4 24 21.655 0 0 0
2017 1 25 17.197 1 0 0
2 26 19.05 0 1 0
3 27 22.499 0 0 1
4 28 25.629 0 0 0

1) Forecast for 2018 with Qtr=1

revenue = 7.1955 + 0.54569*29 - 4.4366*1 - 4.3789*0 - 2.1396*0 =$18.5839

2)

Forecast for 2018 with Qtr=2

revenue = 7.1955 + 0.54569*30 - 4.4366*0 - 4.3789*1 - 2.1396*0 =$19.1873

3)

Forecast for 2018 with Qtr=3

revenue = 7.1955 + 0.54569*31 - 4.4366*0 - 4.3789*0 - 2.1396*1 = $ 21.9723

4)

Forecast for 2018 with Qtr=4

revenue = 7.1955 + 0.54569*32 - 4.4366*0 - 4.3789*0 - 2.1396*0 = $24.6576


Related Solutions

Year Qtr t revenue ($M) 2011 1 1 5.889 2 2 6.141 3 3 8.272 4...
Year Qtr t revenue ($M) 2011 1 1 5.889 2 2 6.141 3 3 8.272 4 4 9.302 2012 1 5 6.436 2 6 6.932 3 7 8.987 4 8 10.602 2013 1 9 7.517 2 10 7.731 3 11 9.883 4 12 12.098 2014 1 13 8.487 2 14 8.685 3 15 11.559 4 16 15.221 2015 1 17 11.132 2 18 11.203 3 19 13.83 4 20 16.979 2016 1 21 12.312 2 22 13.452 3 23 17.659...
Year Qtr t revenue ($M) 2011 1 1 5.889 2 2 6.141 3 3 8.272 4...
Year Qtr t revenue ($M) 2011 1 1 5.889 2 2 6.141 3 3 8.272 4 4 9.302 2012 1 5 6.436 2 6 6.932 3 7 8.987 4 8 10.602 2013 1 9 7.517 2 10 7.731 3 11 9.883 4 12 12.098 2014 1 13 8.487 2 14 8.685 3 15 11.559 4 16 15.221 2015 1 17 11.132 2 18 11.203 3 19 13.83 4 20 16.979 2016 1 21 12.312 2 22 13.452 3 23 17.659...
U.S. Manufactured General Aviation Shipments, 2009–2015 Year Qtr 1 Qtr 2 Qtr 3 Qtr 4 Total...
U.S. Manufactured General Aviation Shipments, 2009–2015 Year Qtr 1 Qtr 2 Qtr 3 Qtr 4 Total 2009 312 406 393 487 1,598 2010 239 373 271 440 1,323 2011 268 284 290 486 1,328 2012 307 357 333 507 1,504 2013 333 409 354 524 1,620 2014 330 388 379 516 1,613 2015 294 376 385 535 1,590 (c) Use MegaStat or Minitab to calculate estimated seasonal indexes and trend. (Round your answers to 3 decimal places.) Qtr1 Index Qtr2...
Year t=0 t=1 t=2 t=3 t=4 ??? $7,500 $12,500 $15,000 $17,500 The Payback Period of this...
Year t=0 t=1 t=2 t=3 t=4 ??? $7,500 $12,500 $15,000 $17,500 The Payback Period of this project is 2.4 years. The appropriate discount rate is 13%. Find the Net Present Value of the project. (Note that the cash flow for t=0 is not provided to you – that is, you must first solve for it). This will be a negative value
1. m •   (n • p) 2. (q   ⊃ ~t) • (~m v q) 3.   ~t...
1. m •   (n • p) 2. (q   ⊃ ~t) • (~m v q) 3.   ~t ⊃ z     : .     z
Year 0 Year 1 Year 2 Year 3 Year 4 Revenue 120000 440000 440000 330000 Cost...
Year 0 Year 1 Year 2 Year 3 Year 4 Revenue 120000 440000 440000 330000 Cost of Goods Sold -60000 -220000 -220000 165000 Gross Profit 60000 220000 220000 165000 Selling, General and Admin -7000 -7000 -7000 -7000 Depreciation -80000 -80000 -80000 -80000 EBIT -27000 133000 133000 78000 Income tax (35%) 9450 -46550 -46550 -27300 Incremental Earnings -36450 86450 86450 50700 Capital Purchaes -280,000 Change to NWC -5,000 -5,000 -5,000 -5,000 A garage is installing a new​ "bubble-wash" car wash. It...
(Show Work and Calculations) On January 2, 2011 N&M Company issued $1 Million of 5-year, 3%...
(Show Work and Calculations) On January 2, 2011 N&M Company issued $1 Million of 5-year, 3% bonds for $940,000, their interest payable semiannually every June 30, and Deember 31. N&M uses stright line amortization, having judged the difference under the effective interest method to be immaterial. On February 28, 2015, N&M retired $100,000 of the bonds at 98. Prepare the journal entries N&M should have made on each of the following dates: 1. February 28, 2015. 2. June 30, 2015.
Refer to Revenue Data Excel File. The 4 QTR Centered Moving Average for the 2nd quarter...
Refer to Revenue Data Excel File. The 4 QTR Centered Moving Average for the 2nd quarter of 2017 is: Select one: a. 222.125 b. 333.875 c. 269.250 d. 243.625 Year QTR Revenue (in $1000) 2015 1 205 2 400 3 200 4 229 2016 1 236 2 219 3 211 4 200 2017 1 280 2 275 3 261 4 322 2018 1 500 2 230 3 310 4 400 2019 1 325 2 241 3 379 4 316
These are the cash flows. Year 0 1 2 3 4 5 6   Revenue 3.2000 4.0000...
These are the cash flows. Year 0 1 2 3 4 5 6   Revenue 3.2000 4.0000 5.6000 5.6000 4.0000 2.4000   Expenses .7200 .9000 1.2600 1.2600 .9000 .5400   Depreciation .9500 .9500 .9500 .9500 .9500 .9500   Pretax profit 1.5300 2.1500 3.3900 3.3900 2.1500 .9100   Tax .5355 .7525 1.1865 1.1865 .7525 .3185   Net income .9945 1.3975 2.2035 2.2035 1.3975 .5915   OCF 1.9445 2.3475 3.1535 3.1535 2.3475 1.5415      Cash flow investment −5.7000 .4362    Change in NWC −.3200 −.0800 −.1600 0.0000 .1600 .1600 .2400...
V = X'(t) = -t^2 + 6 m/s Implies X(t) = -(1/3)*t^3 + 6*t The initial...
V = X'(t) = -t^2 + 6 m/s Implies X(t) = -(1/3)*t^3 + 6*t The initial position is zero in this case. This function will initially increase (this means the object is moving forward), then the negative force will be too strong, so the object will start moving backwards. calculate the maxima and minima. Graph the function X(t). Describe the motion. Every detail.   
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT