Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question: What would be the calculated value of the total Average SI for 2 0 2 3 ? You should be able to answer this

Question: What would be the calculated value of the total Average SI 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.
Month
Demand
Yearly average
Seasonal Index
Average SI
Deseasonalized
Time period
1/1/2020
2422
0.8226
0.7821
3096.6851
1
2/1/2020
2564
0.8708
0.8025
3195.1567
2
3/1/2020
3080
1.0460
0.8798
3500.9003
3
4/1/2020
3004
1.0202
0.9852
3049.1713
4
5/1/2020
2595
0.8813
0.9931
2612.9134
5
6/1/2020
3654
1.2410
1.1146
3278.3152
6
7/1/2020
2725
0.9255
0.8311
3278.9033
7
8/1/2020
2383
0.8093
0.8677
2746.2448
8
9/1/2020
2432
0.8260
0.8808
2761.0371
9
10/1/2020
2744
0.9319
1.0542
2602.9858
10
11/1/2020
3600
1.2227
1.2851
2801.3286
11
12/1/2020
4130
2944.4167
1.4027
1.5238
2710.3290
12
1/1/2021
2634
0.7794
3367.7410
13
2/1/2021
2508
0.7421
3125.3717
14
3/1/2021
2653
0.7850
3015.5482
15
4/1/2021
3270
0.9676
3319.1711
16
5/1/2021
3770
1.1155
3796.0245
17
6/1/2021
3588
1.0617
3219.1010
18
7/1/2021
2658
0.7865
3198.2844
19
8/1/2021
3065
0.9069
3532.2033
20
9/1/2021
3095
0.9158
3513.7376
21
10/1/2021
3634
1.0753
3447.2486
22
11/1/2021
4350
1.2871
3384.9387
23
12/1/2021
5330
3379.5833
1.5771
3497.8337
24
1/1/2022
2810
0.7444
3592.7685
25
2/1/2022
2999
0.7945
3737.2367
26
3/1/2022
3051
0.8083
3467.9373
27
4/1/2022
3653
0.9677
3707.9303
28
5/1/2022
3709
0.9826
3734.6034
29
6/1/2022
3930
1.0411
3525.9384
30
7/1/2022
2949
0.7812
3548.4351
31
8/1/2022
3348
0.8869
3858.3414
32
9/1/2022
3400
0.9007
3860.0025
33
10/1/2022
4361
1.1553
4136.8881
34
11/1/2022
5079
1.3455
3952.2077
35
12/1/2022
6008
3774.7500
1.5916
3942.7739
36

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Airline Finance

Authors: Peter S. Morrell

4th Edition

1351959743, 978-1351959742

More Books

Students also viewed these Finance questions

Question

Th ey told me Id have to write a lett er. Whos got time for that?

Answered: 1 week ago