please help!

Calib Share - AA 0-A- we 49 29 $%98 Com Formatting Date URANTS AVAILABLE A De Cem S D H w 1 Instructions This malis Set As You will the to complete the winter on the new 100 Thu 11 14 ** W Sta Analysis W M ed t. WM 111 12 1 com. and www 11 Thu . 28 304 Udle Keview View Calibri 11 ' ' LG Paste NE BIU a-A- 2 Wrap Text + Merge & Center - Clipboard Font Alignment UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. Us H46 for A G H Deasonalised Demand (2) Trend Seasonal Factor Seasonal Index 1 2 3 Week 1 4 5 6 7 8 9 10 Week 2 11 12 13 14 15 15 17 Week 3 18 19 20 21 22 23 24 Week 4 25 26 B 0 E Deasonalized 1 Demand ('000) Demand (1) Level 0 Monday 100 Tuesday 110 Wednesday 120 Thursday 150 Friday 185 Saturday 200 Sunday 90 Monday 102 Tuesday 112 Wednesday 122 Thursday 153 Friday 189 Saturday 204 Sunday 92 Monday 104 Tuesday 114 Wednesday 125 Thursday 156 Friday 192 Saturday 208 Sunday 94 Monday 106 Tuesday 117 Wednesday 127 Static Analysis--1 Static Analysis --2 GNSS Winter's Analysis Holt's Analysis Ready Type here to search o M N OP 0 R STU 1. Determine the periodicity. Is it even orodd? You need to know this so you can use the correct formula for deseasonalizing the demand. 2. For the sample analysis in Winter's (next worksheet) you'll calculate a sample forecast and error rates for Week 6. Should you include Week 6 data in your Sample Static Analysis? (Hint: the answer is 'no'.) 3. Complete Column C. Remember the forecast time period should be numbered differently. 4. Calculate Deseasonalized Demand 1. Make sure you pay careful attention to th rst and last periods in which Deseasonalized Demand 1 may be calculated. Remember, this is sample Static analysis. 5. Calculate level and Trend at t-o. 6. Calculate Deseasonalized Demand 2 and seasonal factors. 7. Calculate Seasonal Indices. Remember, your periodicity determines the number of seasonal indices. 8. Use check figures to make sure your seasonal indices and level and trend at t=0 are correct. You'll need to take these into the Winter's Analysis on the next worksheet. Check Figures L-134.65 To 0.40 Seasonal Index for t3 is 0.88. If your level and trend aren't correct think about which data you're using. Remember, this is a sample Static. That means you don't use all the data FONE Alignment UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some H45 X fa D E F F G H 208 94 106 117 127 159 196 212 96 4 A B 22 Saturday 23 Sunday 24 Week 4 Monday 25 Tuesday 26 Wednesday 27 Thursday 28 Friday 29 Saturday 30 Sunday 31 Week 5 Monday 32 Tuesday 33 Wednesday 34 Thursday 35 Friday 36 Saturday 37 Sunday 38 Week 6 Monday 39 Tuesday 40 Wednesday 41 Thursday 42 43 Saturday 44 Sunday 108 119 130 162 200 216 55 A 88 898 97 110 121 132 166 Friday 204 45 221 99 46 47 48 Static Analysis--1 Static Analysis --2 Ready Winter's Anal Calib Share - AA 0-A- we 49 29 $%98 Com Formatting Date URANTS AVAILABLE A De Cem S D H w 1 Instructions This malis Set As You will the to complete the winter on the new 100 Thu 11 14 ** W Sta Analysis W M ed t. WM 111 12 1 com. and www 11 Thu . 28 304 Udle Keview View Calibri 11 ' ' LG Paste NE BIU a-A- 2 Wrap Text + Merge & Center - Clipboard Font Alignment UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. Us H46 for A G H Deasonalised Demand (2) Trend Seasonal Factor Seasonal Index 1 2 3 Week 1 4 5 6 7 8 9 10 Week 2 11 12 13 14 15 15 17 Week 3 18 19 20 21 22 23 24 Week 4 25 26 B 0 E Deasonalized 1 Demand ('000) Demand (1) Level 0 Monday 100 Tuesday 110 Wednesday 120 Thursday 150 Friday 185 Saturday 200 Sunday 90 Monday 102 Tuesday 112 Wednesday 122 Thursday 153 Friday 189 Saturday 204 Sunday 92 Monday 104 Tuesday 114 Wednesday 125 Thursday 156 Friday 192 Saturday 208 Sunday 94 Monday 106 Tuesday 117 Wednesday 127 Static Analysis--1 Static Analysis --2 GNSS Winter's Analysis Holt's Analysis Ready Type here to search o M N OP 0 R STU 1. Determine the periodicity. Is it even orodd? You need to know this so you can use the correct formula for deseasonalizing the demand. 2. For the sample analysis in Winter's (next worksheet) you'll calculate a sample forecast and error rates for Week 6. Should you include Week 6 data in your Sample Static Analysis? (Hint: the answer is 'no'.) 3. Complete Column C. Remember the forecast time period should be numbered differently. 4. Calculate Deseasonalized Demand 1. Make sure you pay careful attention to th rst and last periods in which Deseasonalized Demand 1 may be calculated. Remember, this is sample Static analysis. 5. Calculate level and Trend at t-o. 6. Calculate Deseasonalized Demand 2 and seasonal factors. 7. Calculate Seasonal Indices. Remember, your periodicity determines the number of seasonal indices. 8. Use check figures to make sure your seasonal indices and level and trend at t=0 are correct. You'll need to take these into the Winter's Analysis on the next worksheet. Check Figures L-134.65 To 0.40 Seasonal Index for t3 is 0.88. If your level and trend aren't correct think about which data you're using. Remember, this is a sample Static. That means you don't use all the data FONE Alignment UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some H45 X fa D E F F G H 208 94 106 117 127 159 196 212 96 4 A B 22 Saturday 23 Sunday 24 Week 4 Monday 25 Tuesday 26 Wednesday 27 Thursday 28 Friday 29 Saturday 30 Sunday 31 Week 5 Monday 32 Tuesday 33 Wednesday 34 Thursday 35 Friday 36 Saturday 37 Sunday 38 Week 6 Monday 39 Tuesday 40 Wednesday 41 Thursday 42 43 Saturday 44 Sunday 108 119 130 162 200 216 55 A 88 898 97 110 121 132 166 Friday 204 45 221 99 46 47 48 Static Analysis--1 Static Analysis --2 Ready Winter's Anal