1. Speciality Packaging Corporation.xlsx

Year

2005

2006

2007

2008

2009

Quarter 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4

Black Plastic demand 2250 1737 2412 7269 3514 2143 3459 7056 4120 2766 2556 8253 5491 4382 4315 12035 5648 3696 4843 13097

Time period 2129.275 244.925 2386.2938 197.74375 Intercept

SUMMARY OUTPUT Regression Statistics Multiple R 0.9622246 R Square 0.9258762 Adjusted R 0.808013 Standard Er889.80665 Observation 16 ANOVA df Regression 5 Residual 11 Total 16

Clear Plastic demand 3200 7658 4420 2384 3654 8680 5695 1953 4742 13673 6640 2737 3486 13186 5448 3485 7728 16591 8236 3316

Q1 0 0

Time period

Q1

Q2

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0

0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0

Q2

Q3

Q4

-1331.675 -1148.1 4074.725 6831.00625 1384.7625 -1723.981

SS MS F Significance F 8787517 21757503 34.350081745 5.51E-006 8709315 791755.88 7496832

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 2129.275 564.95716 3.7689141 0.0031062342 885.81268 3372.7373 Time period 244.925 49.741704 4.9239366 0.0004540141 135.44425 354.40575 Q1 0 0 65535 Err:512 0 0

Q2 Q3 Q4

-1331.675 631.15147 -2.109913 Err:512 -2720.83 57.480019 -1148.1 637.00462 -1.802342 0.0989285098 -2550.138 253.93772 4074.725 646.64215 6.30136 5.82635E-005 2651.4752 5497.9748

Q3

Q4

0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0

0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1

Forecast Black Clear Plastic Plastic demand demand 6293 5747.9375 5206.25 12776.6875 5634.75 7528.1875 11102.5 4617.1875

SUMMARY OUTPUT Regression Statistics Multiple R 0.9433011 R Square 0.8898169 Adjusted R Squa0.7588413 Standard Error 1379.1308 Observations 16 ANOVA df SS MS Regression 5 68962155 33792431 Residual 11 20922018 1902002 Total 16 84173 Lower 95.0% Upper 95.0% 885.81268 3372.7373 135.44425 354.40575 0 0

Intercept Time period Q1

Coefficients Standard Error t Stat 2386.2938 875.63943 2.7252013 197.74375 77.095753 2.5649111 0 0 65535

-2720.83 57.480019 -2550.138 253.93772 2651.4752 5497.9748

Q2 Q3 Q4

6831.0063 978.23544 6.9829879 1384.7625 987.30737 1.4025647 -1723.981 1002.2448 -1.72012

F Significance F 22.208466 4.06E-005

P-value Lower 95% Upper 95%Lower 95.0% Upper 95.0% 0.019747 459.02435 4313.5631 459.02435 4313.5631 0.0262876 28.057141 367.43036 28.057141 367.43036 Err:512 0 0 0 0

Err:512 4677.9246 8984.0879 4677.9246 8984.0879 0.1883339 -788.2864 3557.8114 -788.2864 3557.8114 0.1133819 -3929.907 481.94467 -3929.907 481.94467

Year

2005

2006

2007

2008

2009

2009

Quarter 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4

Black Plastic demand 2250 1737 2412 7269 3514 2143 3459 7056 4120 2766 2556 8253 5491 4382 4315 12035 5648 3696 4843 13097

Time period 2107.4313 233.01875 2386.2938 197.74375 Intercept

Clear Plastic demand 3200 7658 4420 2384 3654 8680 5695 1953 4742 13673 6640 2737 3486 13186 5448 3485 7728 16591 8236 3316

Q1 0 0

Time period

Q1

Q2

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0

0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0

Q2

Q3

Q4

-1492.81875 -1153.638 4638.3438 6831.00625 1384.7625 -1723.981

SUMMARY OUTPUT Regression Statistics Multiple R 0.9606844 R Square 0.9229145 Adjusted R 0.8356917 Standard Er981.83542 Observation 20 ANOVA df Regression Residual Total

Intercept

SS MS F Significance F 5 124070 34624814 44.897284504 3.95E-008 15 14460012 964000.79 20 87584082

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% 2107.4313 561.0762 3.7560517 0.0019071869 911.52563 3303.3369

Time period233.01875 38.810453 6.0040204 2.41505E-005 Q1 0 0 65535 Err:512 Q2 -1492.819 622.17889 -2.39934 Err:512 Q3 -1153.638 625.79974 -1.843461 0.0851084867 Q4 4638.3438 631.78839 7.3416096 2.43884E-006

150.29623 0 -2818.962 -2487.498 3291.7187

315.74127 0 -166.6758 180.22308 5984.9688

Q3

Q4

0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0

0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1

Forecast Black Clear Plastic Plastic demand demand 6068.75 5747.9375 4808.95 12776.6875 5381.15 7528.1875 11406.15 4617.1875 7000.825 5741.025 6313.225 12338.23

SUMMARY OUTPUT Regression Statistics Multiple R 0.9433011 R Square 0.8898169 Adjusted R Squa0.7588413 Standard Error 1379.1308 Observations 16 ANOVA df SS MS Regression 5 68962155 33792431 Residual 11 20922018 1902002 Total 16 84173

Lower 95.0% Upper 95.0% 911.52563 3303.3369

Intercept Time period Q1

Coefficients Standard Error t Stat 2386.2938 875.63943 2.7252013 197.74375 77.095753 2.5649111 0 0 65535

150.29623 0 -2818.962 -2487.498 3291.7187

315.74127 0 -166.6758 180.22308 5984.9688

Q2 Q3 Q4

6831.0063 978.23544 6.9829879 1384.7625 987.30737 1.4025647 -1723.981 1002.2448 -1.72012

F Significance F 22.208466 4.06E-005

P-value Lower 95% Upper 95%Lower 95.0% Upper 95.0% 0.019747 459.02435 4313.5631 459.02435 4313.5631 0.0262876 28.057141 367.43036 28.057141 367.43036 Err:512 0 0 0 0

Err:512 4677.9246 8984.0879 4677.9246 8984.0879 0.1883339 -788.2864 3557.8114 -788.2864 3557.8114 0.1133819 -3929.907 481.94467 -3929.907 481.94467