Northwest Natural Gas Co (NWN)

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		1.39	2.01	2.79	4.42	1.60	1.75	2.60	5.12	2.20	2.76	4.14	6.02	2.52	3.65	3.74	4.64	2.83	6.07
DOH	days	262.47	181.43	130.98	82.53	227.86	208.09	140.13	71.22	165.55	132.39	88.15	60.58	144.83	99.88	97.71	78.59	128.84	60.15

December 31, 2023 calculation

DOH = 365 ÷ Inventory turnover
= 365 ÷ 1.39
= 262.47

To analyze the days of inventory on hand (DOH) for Northwest Natural Holding Co, we observe a fluctuating trend over the past eight quarters.

In Q4 2022, the DOH was relatively high at 73.99 days, indicating an extended time required to sell off the inventory. This trend continued into Q1 2023, with an even higher DOH of 96.08 days, suggesting potential inefficiencies in inventory management during this period.

However, a significant improvement was observed in Q2 2023, where the DOH decreased to 48.07 days, signaling a more efficient inventory turnover. This trend continued positively in Q3 2023, with a further reduction to 65.69 days.

Notably, in Q4 2023, there was a considerable increase in the DOH to 82.20 days, which may suggest a slower inventory turnover rate compared to the previous quarters.

Overall, Northwest Natural Holding Co has shown varying levels of efficiency in managing its inventory over the analyzed period. Close monitoring of inventory levels and sales patterns would be crucial for optimizing the DOH metric and enhancing operational performance.