D E 9 10 11 12 12 141 15 Month Demand 1/1/2019 2/1/2019 1/1/2019 4/1/2019 5/1/2019 6/1/2019 8 7/1/2019 8/1/2019 10 9/1/2019 11 10/1/2019 12 11/1/2019 13 12/1/2019 14 1/1/2020 15 2/1/2020 16 3/1/2020 17 4/1/2020 18 5/1/2020 19 6/1/2020 20 7/1/2020 -21 8/1/2020 22 9/1/2020 23 10/1/2020 24 11/1/2020 25 12/1/2020 26 1/1/2021 27 2/1/2021 28 3/1/2021 29 4/1/2021 30 5/1/2021 31 6/1/2021 32 7/1/2021 33 8/1/2021 34 9/1/2021 35 10/1/2021 36 11/1/2021 37 12/2/2021 Yearly average Seasonal Index Averages 2682 0.814063488 2833 0.859289237 3236 0.982218288 3560 1.080561528 3483 1.057189832 3743 1.136107247 2900 0.880232205 2589 0.785835336 2744 0.832882256 3714 1.12730492 2062 Put yearly average in below cel 0.929404125 4991 3294.583333 1.514910838 2810 0.74492997 3086 0.818097468 3061 0.811469977 3442 0.912472938 3893 1.032032872 3980 1.055096541 3138 0.831882649 3633 0.963.106968 3534 0.936862104 4229 1.121106349 1.295276808 4886 Put yearly average in below cel 5574 2772.166667 1477665356 3115 0.738107932 3272 0.77530952 1400 0.805639476 4141 0.981221492 4345 1,02955985 4667 1.10585 8658 3573 0.846632109 3987 0.944730762 3914 0.92733219 4886 1.157251318 5336 Put yearly average in below cel 1264380072 G002 4230.23 1423375392 Deseasonalized Time period 0:765700463 2502.67517 0.817565408 3462.719889 0.86644258 3734.811831 0.991418652 3590.514023 1.039594185 3350.343779 1.099020815 3405.758921 0.852915888 3400,100809 0.897891022 2883.423419 0.899059191 3052.079360 1.135387529 3271.129817 1.163020402 2632.799902 1.471983862 3390.662172 0.765700463 3669.842267 0.817565408 3774.621539 0.86644258 3532-836531 0.991418652 3471.73265 1.0395941188 3744.730439 1.099020815 3621.405478 0.852915888 3679.143566 0.897891022 4046.148042 0,89905919 3930.775682 1.135387529 3724.719439 1.163020402 4201.1300SS 1.471983862 3786.726297 0.765700463 4068.170153 0.817565408 40022126272 0.86544258 3924.09154 0.991418552 4176,842941 1.099594188 419.515478 1.099020815 4246,507329 0.852915888 4189.158687 0.897891022 4-1-10.408241 0.89905919 4353.499714 1.135387529 4303.375191 1.163020102 458805355 1.471983862 4080.887131 16 17 18 19 201 21 22 23 24 26 27 28 29 30 31 32 33 24 35 36 Dessor Financial information Franchise operati.... SI and regression Pt 1 Current operations Pt2 & Pt3 Ready 14 What is the calculated value of the 3-year total demand in Cell C42 of worksheet: Sl and regression? Submit Answer format: Number: Round to: 2 decimal places. What is the calculated value of the 3-year average deseasonalized demand in Cell F44 of workshoat: Si and regression? Submit Answer format: Number: Round to 2 decimal places What would be the calculated value of the total Average Sl for 2023? You should be able to answer this based on what you know about monthly seasonal index or by looking at the values in the previous years Submit Answer format: Number: Round to: 2 decimal places D 14 7 Month Demand 1/1/19 2/1/19 3/1/19 4/1/19 5/1/19 6/1/19 7/1/19 9/1/19 9/1/19 10/1/19 11/1/19 12/8/19 1/1/20 2/1/20 3/1/20 4/1/20 5/1/20 6/1/20 7/1/20 8/1/20 9/1/20 10/1/20 11/1/20 12/1/20 1/1/21 2/1/21 3/1/21 4/1/21 5/1/21 6/1/21 7/1/21 8/1/21 9/1/21 10/1/21 11/1/21 12/1/21 Yearly average Seasonal Index Averare si 2682 0.81 2831 0.86 3236 0.90 3560 1.08 3483 106 3743 1.14 2900 08 2589 0.79 2744 0.80 3714 113 3062 Put yearly average in below cel 093 4991 329458 1.51 2810 0.74 3086 0.82 3061 0.81 3442 091 3893 103 3980 106 3138 0.83 3633 0.96 3534 0.94 4229 112 4886 Put yearly average in below cell 130 5574 3772.17 143 3115 074 3272 0.78 3400 0.81 4141 098 4345 103 4667 111 3573 O.RS 3987 0.94 3914 0.93 4886 116 5336 Put yearly average in below cel 1.26 6007 4220751 142 Deseasonalized Time period 0.77 3502.68 0.92 3462.72 0.87 3734.81 0.99 3590.81 1.04 3350 35 1.10 3405.76 0.85 3400.10 0.90 2883.42 0.90 3052.08 1.14 3271.13 1 16 2537 80 3390.66 0.77 3669.84 0.22 3774.62 0.87 3532.84 0.99 3471.79 1.04 3744.73 1.10 3621.41 0.85 3679.14 0.90 4046.15 0.90 3930.78 1.14 3724.72 1.36 4201 13 1.47 3786.73 4068 17 0.92 4002.13 0.87 3924.09 0.99 4176.84 1.04 4179.52 1.30 4246.51 0.85 4189.16 0.90 4440.41 0:30 4353.44 1.34 4303 38 2.36 4588 05 1.47 4080.89 20 2 22 HANNNNNNNNNNHAM 24 22 23 3 3 3 5 36 EB 3: 32 Highest yeatly average 4220.25 10 Total 3 year deseasonalized demand Total 3 year demand 41 4 Average 3 year deseasonalized demand 4. Average 3 year demand 376233 4 14 15 36 40 44 4. 43 19 ED 9 Highest Avete 1.47
