ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Workpaper 5. U-21860 DAAODE-7.3a-7.4a Late Fees 2019-2024
3
4
Michigan Public Service Commission
5
DTE Electric Company
6
Case No. U-21860
7
DAAODE-7.3a
8
Late Fees
9
10
JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTotal
11
2019 1,101,684 1,095,002 986,766 1,486,167 1,174,716 998,778 1,348,001 1,380,327 1,735,266 1,480,429 1,069,875 1,038,667 14,897,697
12
2020 989,450 1,145,214 1,318,795 1,421,580 1,573,495 2,107,959 1,840,229 2,160,785 2,170,369 1,557,381 1,394,305 1,101,998 18,783,581
13
2021 734,973 1,096,285 1,324,017 1,100,912 1,062,661 1,293,538 1,295,279 1,629,299 1,677,115 1,463,993 1,317,151 901,032 14,896,256
14
2022 604,250 1,022,850 1,135,712 1,330,128 1,504,658 1,321,425 1,464,084 2,113,401 1,670,993 1,665,192 1,100,551 1,111,302 16,044,546
15
2023 1,059,919 1,197,771 1,090,888 1,478,139 1,591,637 1,242,985 1,594,613 1,769,548 1,674,551 1,644,225 1,141,617 1,241,159 16,727,053
16
2024 1,173,140 1,208,302 1,176,140 1,793,403 1,454,121 1,353,329 1,907,615 1,671,411 2,096,437 1,915,658 1,238,712 1,176,442 18,164,709
17
TOTAL 99,513,842
18
ANNUAL AVG 16,585,640
19
MONTHLY AVG 1,382,136.69
20
LI Late Fees vs. Total
21
22
ANNUAL AVG
23
LI $6,706,890
24
TOTAL$16,585,640
25
LI PERCENT40.4%
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100