DTE Energy Company (DTE)

Days of inventory on hand (DOH)

		Dec 31, 2023	Sep 30, 2023	Jun 30, 2023	Mar 31, 2023	Dec 31, 2022	Sep 30, 2022	Jun 30, 2022	Mar 31, 2022	Dec 31, 2021	Sep 30, 2021	Jun 30, 2021	Mar 31, 2021	Dec 31, 2020	Sep 30, 2020	Jun 30, 2020	Mar 31, 2020	Dec 31, 2019	Sep 30, 2019	Jun 30, 2019	Mar 31, 2019
Inventory turnover		0.99	0.89	1.05	1.21	1.05	0.89	1.13	1.37	1.18	1.18	22.87	—	9.42	1.07	1.12	1.26	11.58	1.09	1.14	1.44
DOH	days	368.85	409.24	349.00	302.66	348.36	409.99	323.06	266.89	309.15	308.38	15.96	—	38.75	341.93	325.97	288.98	31.52	334.69	320.95	252.82

December 31, 2023 calculation

DOH = 365 ÷ Inventory turnover
= 365 ÷ 0.99
= 368.85

The days of inventory on hand (DOH) for DTE Energy Co. has shown some variability over the past eight quarters. In Q4 2023, the DOH stood at 61.47 days, representing an increase compared to the previous quarters where specific data points are not available. This increase may indicate a slower inventory turnover rate or an accumulation of inventory, which could tie up capital and potentially lead to increased holding costs.

The DOH of 145.57 days in Q1 2023 was significantly higher compared to other quarters, suggesting a potential issue with excessive inventory levels or challenges in managing inventory effectively. On the other hand, the DOH figures in Q3 2022, Q2 2022, and Q1 2022 were relatively lower, indicating a more efficient inventory management during those periods.

Overall, analyzing the trend in DOH can provide insights into the efficiency of DTE Energy Co.'s inventory management practices and its ability to control inventory levels effectively. A consistently high DOH may require further investigation to identify the root causes and improve operational efficiency in the future.