Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Month Demand Yearly average Seasonal Index Average SI Deseasonalized Time period 1/1/2019 2422 0.8226 0.7817 3098.40 2/1/2019 2564 0.8708 0.8020 3196.99 W N 3/1/2019 3080
Month Demand Yearly average Seasonal Index Average SI Deseasonalized Time period 1/1/2019 2422 0.8226 0.7817 3098.40 2/1/2019 2564 0.8708 0.8020 3196.99 W N 3/1/2019 3080 1.0460 0.8793 3502.77 4/1/2019 3004 1.0202 0.9846 3050.91 5/1/2019 2595 0.8813 0.9926 2614.41 6/1/2019 3654 1.2410 1.1140 3280.09 7/1/2019 2725 0.9255 0.8306 3280.69 8/1/2019 2383 0.8093 0.8672 2747.87 9/1/2019 2432 0.8260 0.8803 2762.68 9 10/1/2019 2744 0.9319 1.0535 2604.64 10 11/1/2019 3600 1.2227 1.2843 2803.03 11 12/1/2019 4130 2944.42 1.4027 1.5298 2699.63 12 1/1/2020 2634 0.7794 0.7817 3369.60 13 2/1/2020 2508 0.7421 0.8020 3127.17 14 3/1/2020 2653 0.7850 0.8793 3017.16 15 4/1/2020 3270 0.9676 0.9846 3321.06 16 5/1/2020 3770 1.1155 0.9926 3798.21 17 6/1/2020 3588 1.0617 1.1140 3220.85 18 7/1/2020 2658 0.7865 0.8306 3200.03 19 8/1/2020 3065 0.9069 0.8672 3534.30 20 9/1/2020 3095 0.9158 0.8803 3515.82 2110/1/2020 3634 1.0753 1.0535 3449.44 22 11/1/2020 4350 1.2871 1.2843 3387.00 23 12/1/2020 5330 3379.583333 1.5771 1.5298 3484.02 24 1/1/2021 2810 0.7431 0.7817 3594.75 25 2/1/2021 2999 0.7931 0.8020 3739.39 26 3/1/2021 3051 0.8069 0.8793 3469.79 27 4/1/2021 3653 0.9661 0.9846 3710.05 28 5/1/2021 3709 0.9809 0.9926 3736.75 29 6/1/2021 3930 1.0393 1.1140 3527.85 30 7/1/2021 2949 0.7799 0.8306 3550.37 31 8/1/2021 3348 0.8854 0.8672 3860.63 32 9/1/2021 3400 0.8992 0.8803 3862.29 33 10/1/2021 4361 1.1533 1.0535 4139.52 34 11/1/2021 5079 1.3432 1.2843 3954.61 35 12/1/2021 6087 3781.33 1.6097 1.5298 3978.85 36Total 3 year deseasonalized Highest yearly average Highest Average SI demand 3781.33 1.5298 121191.63 Average 3 year deseasonalized Total 3 year demand demand 121264 3366.43 Average 3 year demand 3368.44
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started