Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Month Demand 1/1/2019 2323 2/1/2019 2804 3/1/2019 2469 4/1/2019 3278 5/1/2019 3617 6/1/2019 2669 7/1/2019 2010 8/1/2019 2715 9/1/2019 2890 10/1/2019 2973 11/1/2019 3485 12/1/2019
Month | Demand |
1/1/2019 | 2323 |
2/1/2019 | 2804 |
3/1/2019 | 2469 |
4/1/2019 | 3278 |
5/1/2019 | 3617 |
6/1/2019 | 2669 |
7/1/2019 | 2010 |
8/1/2019 | 2715 |
9/1/2019 | 2890 |
10/1/2019 | 2973 |
11/1/2019 | 3485 |
12/1/2019 | 4548 |
1/1/2020 | 2429 |
2/1/2020 | 2495 |
3/1/2020 | 2595 |
4/1/2020 | 3383 |
5/1/2020 | 3426 |
6/1/2020 | 3654 |
7/1/2020 | 2629 |
8/1/2020 | 2996 |
9/1/2020 | 3150 |
10/1/2020 | 3924 |
11/1/2020 | 4185 |
12/1/2020 | 4982 |
1/1/2021 | 2712 |
2/1/2021 | 3229 |
3/1/2021 | 3077 |
4/1/2021 | 3646 |
5/1/2021 | 3998 |
6/1/2021 | 4062 |
7/1/2021 | 3171 |
8/1/2021 | 3638 |
9/1/2021 | 3623 |
10/1/2021 | 4050 |
11/1/2021 | 4528 |
12/1/2021 | 5702 |
What is the calculated value of the highest average seasonal index located in Cell E51 of worksheet: SI and regression?
What is the calculated value of the 3-year total demand in Cell C53 of worksheet: SI and regression? (Over the 3 year period from your historical data, what was the total demand)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started