"Regression ModelIndependent variable (X) - Consumer pack Dependent variable (Y) - Seasonally adjusted caseshipment SUMMARY OUTPUT Regression Statistics Multiple R 0.444569106 R Square 0.19764169 Adjusted R Square 0.180199118 Standard Error 126482.8093 Observations 48 ANOVA df SS MS F Regression 1 1.81272E+11 1.81E+11 11.33099 Residual 46 7.35903E+11 1.6E+10 Total 47 9.17176E+11 Coefficients Standard Error t Stat P-value Intercept -163878.1976 80765.24748 -2.029068 0.048261 X Variable 1 0.700867759 0.20821023 3.366154 0.001547Significance F 0.001547046 Upper 95% Lower 95.0% Upper 95.0% -1306.188917 -326450.2062 -1306.189 1.119973208 0.28176231 1.119973 Lower 95% -326450.2062 0.28176231Question 1 Harmon Foods, Inc. ConsumerMonth Case Shipments * Packs (Cases)* Dealer Allowance Month Period Jan-84 425075 75253 457732 1 January Feb-84 315305 15036 254396 2 February Mar-84 367286 134440 259952 3 March Apr-84 429432 119740 267368 4 April May-84 347874 135590 158504 5 May Jun-84 435529 189639 430012 6 June Jul-84 299403 9308 388516 July 7 Aug-84 296505 41099 225616 8 August Sep-84 426701 9391 1042304 Septembe 9 r Oct-84 329722 942 974092 10 October Nov-84 281783 1818 301892 11 November Dec-84 166391 672 76148 December 12 Jan-85 629402 548704 0 13 Feb-85 263467 52818 315196 14 Mar-85 398320 2793 703624 15 Apr-85 376569 27749 198464 16 May-85 444404 21887 478880 17 Jun-85 386986 1110 457172 18 Jul-85 414314 436 709480 19 Aug-85 253493 1407 45380 20 Sep-85 484365 376650 28080 21 Oct-85 305989 122906 111520 22 Nov-85 315407 15138 267200 23 Dec-85 182784 5532 354304 24 Jan-86 655748 544807 664712 25 Feb-86 270483 43708 536824 26 Mar-86 365058 5740 551560 27 Apr-86 313135 9614 150080 28 May-86 528210 1507 580800 29 Jun-86 379856 13620 435080 30 Jul-86 472058 101179 361144 31 Aug-86 254516 80309 97844 32 Sep-86 551354 335768 30372 33 Oct-86 335826 91710 150324 34 Nov-86 320408 9856 293044 35 Dec-86 276901 107172 162788 36 Jan-87 455136 299781 32532 37 Feb-87 247570 21218 23468 38 Mar-87 622204 157 4503456 39 Apr-87 429331 12961 500904 40 May-87 453156 333529 0 41 Jun-87 320103 178105 0 42 Jul-87 451779 315564 46104 43 Aug-87 249482 80206 92252 44 Sep-87 744583 5940 4869952 45Oct-87 421186 36819 376556 46 Nov-87 397367 234562 376556 47 Dec-87 269096 71881 552536 48 Regression ModelIndependent variable (X) - Consumer pack Dependent variable (Y) - Seasonally adjusted caseshipmentSeasonally adjusted Forecast Forecast SeasonalityIndex Monthcase shipment value seasonally adjusted case shipment actual case shipment Jan-84 113 376172.5664 335319.4928 378911 Feb-84 98 321739.7959 333652.9832 326979.9 Mar-84 102 360084.3137 336612.6362 343344.9 Apr-84 107 401338.3178 336415.4574 359964.5 May-84 119 292331.0924 332473.6981 395643.7 Jun-84 104 418777.8846 338374.0994 351909.1 Jul-84 107 279815.8879 332749.4372 356041.9 Aug-84 81 366055.5556 340226.6797 275583.6 Sep-84 113 377611.5044 339763.1266 383932.3 Oct-84 97 339919.5876 338099.918 327956.9 Nov-84 95 296613.6842 340280.2824 323266.3 Dec-84 65 255986.1538 347380.6696 225797.4 Jan-85 556992.9204 359718.5933 406482 Feb-85 268843.8776 338920.7214 332142.3 Mar-85 390509.8039 349907.482 356905.6 Apr-85 351933.6449 347353.6719 371668.4 May-85 373448.7395 349379.5538 415761.7 Jun-85 372101.9231 348899.9324 362855.9 Jul-85 387209.3458 348587.6987 372988.8 Aug-85 312954.321 346201.9537 280423.6 Sep-85 428641.5929 354178.3759 400221.6 Oct-85 315452.5773 346109.6785 335726.4 Nov-85 332007.3684 354425.4837 336704.2 Dec-85 281206.1538 361328.7215 234863.7 Jan-86 580307.9646 377774.6411 426885.3 Feb-86 276003.0612 344772.7152 337877.3 Mar-86 357900 361899.1304 369137.1 Apr-86 292649.5327 366390.5988 392037.9 May-86 443873.9496 384811.4109 457925.6 Jun-86 365246.1538 374885.4585 389880.9 Jul-86 441175.7009 380571.9773 407212 Aug-86 314217.284 369667.7228 299430.9 Sep-86 487923.8938 388222.6246 438691.6 Oct-86 346212.3711 364941.6505 353993.4 Nov-86 337271.5789 376447.5119 357625.1 Dec-86 426001.5385 394038.8351 256125.2 Jan-87 402775.2212 387415.024 437779 Feb-87 252622.449 387312.7712 379566.5 Mar-87 610003.9216 447510.0024 456460.2 Apr-87 401243.9252 372632.2304 398716.5 May-87 380803.3613 369209.2906 439359.1 Jun-87 307791.3462 376532.5535 391593.9 Jul-87 422223.3645 437964.7672 468622.3 Aug-87 308002.4691 452414.39 366455.7 Sep-87 658923.0088 593960.3907 671175.2Oct-87 434212.3711 432271.6858 419303.5 Nov-87 418281.0526 418281.0526 397367 Dec-87 413993.8462 #DIV/0! #DIV/0!"