Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Month Demand Yearly average Seasonal Index Average SI Deseasonalized Time period 1/1/2020 2324 1 2/1/2020 2789 2 3/1/2020 2442 3 4/1/2020 3020 4 5/1/2020 2379
Month | Demand | Yearly average | Seasonal Index | Average SI | Deseasonalized | Time period |
1/1/2020 | 2324 | 1 | ||||
2/1/2020 | 2789 | 2 | ||||
3/1/2020 | 2442 | 3 | ||||
4/1/2020 | 3020 | 4 | ||||
5/1/2020 | 2379 | 5 | ||||
6/1/2020 | 3482 | 6 | ||||
7/1/2020 | 3362 | 7 | ||||
8/1/2020 | 2635 | 8 | ||||
9/1/2020 | 2274 | 9 | ||||
10/1/2020 | 3271 | 10 | ||||
11/1/2020 | 3575 | 11 | ||||
12/1/2020 | 4355 | 2992.33 | 12 | |||
1/1/2021 | 2243 | 13 | ||||
2/1/2021 | 2705 | 14 | ||||
3/1/2021 | 2966 | 15 | ||||
4/1/2021 | 3256 | 16 | ||||
5/1/2021 | 3684 | 17 | ||||
6/1/2021 | 3819 | 18 | ||||
7/1/2021 | 4604 | 19 | ||||
8/1/2021 | 3104 | 20 | ||||
9/1/2021 | 3133 | 21 | ||||
10/1/2021 | 3712 | 22 | ||||
11/1/2021 | 4215 | 23 | ||||
12/1/2021 | 5152 | 3549.416667 | 24 | |||
1/1/2022 | 2691 | 25 | ||||
2/1/2022 | 3139 | 26 | ||||
3/1/2022 | 2870 | 27 | ||||
4/1/2022 | 3424 | 28 | ||||
5/1/2022 | 3786 | 29 | ||||
6/1/2022 | 3722 | 30 | ||||
7/1/2022 | 3165 | 31 | ||||
8/1/2022 | 3287 | 32 | ||||
9/1/2022 | 3578 | 33 | ||||
10/1/2022 | 4477 | 34 | ||||
11/1/2022 | 5248 | 35 | ||||
12/1/2022 | 5503 | 3740.83 | 36 |
Find the seasonal index, average si, and deseasonalized.
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