ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Date 2 (date it leaves inventory) - Year
Date 2 (date it leaves inventory) - Quarter
Date 2 (date it leaves inventory) - Month
Average of Days in Inventory Trimmed
4
2018Q1
Mar
41.5
5
Q1 Total41.5
6
Q2
Apr
110
7
Q2 Total110
8
Q3
Sep
31
9
Q3 Total31
10
Q4
Dec
144
11
Q4 Total144
12
2018 Total73.6
13
2019Q1
Jan
369
14
Q1 Total369
15
Q2
Apr
349
16
May
91
17
Jun
518
18
Q2 Total326.75
19
Q3Jul443
20
Q3 Total443
21
Q4
Oct
261
22
Nov
467
23
Q4 Total364
24
2019 Total365.5555556
25
2020Q1
Feb
384
26
Mar
218.5
27
Q1 Total273.6666667
28
Q2
Apr
426
29
Jun
101.6666667
30
Q2 Total148
31
Q4
Oct
540
32
Nov
540
33
Q4 Total540
34
2020 Total244.75
35
2021Q1
Jan
19
36
Q1 Total19
37
Q2
May
317
38
Jun
298.3333333
39
Q2 Total303
40
Q3Jul373
41
Aug
391.3333333
42
Q3 Total386.75
43
Q4
Oct
306.6666667
44
Nov
309
45
Dec
298
46
Q4 Total304.1666667
47
2021 Total306.8666667
48
2022Q1
Feb
188
49
Mar
448
50
Q1 Total361.3333333
51
Q2
Apr
75
52
May
151.5
53
Jun
537
54
Q2 Total228.75
55
Q3Jul82
56
Sep
334.5
57
Q3 Total250.3333333
58
Q4
Nov
540
59
Q4 Total540
60
2022 Total299.0909091
61
2023Q1
Jan
534.5
62
Mar
347
63
Q1 Total422
64
Q2
May
269.5
65
Jun
397.3333333
66
Q2 Total346.2
67
Q3Jul539
68
Q3 Total539
69
Q4
Oct
223
70
Nov
100
71
Dec
368.6666667
72
Q4 Total285.8
73
2023 Total363.0625
74
2024Q1
Jan
540
75
Q1 Total540
76
Q3Jul500
77
Q3 Total500
78
2024 Total520
79
2025Q1
Jan
536
80
Feb
540
81
Mar
540
82
Q1 Total538.6666667
83
Q2
May
540
84
Jun
540
85
Q2 Total540
86
2025 Total539.2
87
Grand Total
320.44
88
89
90
91
92
93
94
95
96
97
98
99
100